{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Introduction","Etude de Base","Questionnaire","Récapitulatif","Résumé","12-Mois Cash Flow","10-Ans Cash Flow","Calcul Énergétique","1er Remboursement","2ème Remboursement"],"not_rendered":{"charts":7,"images":13,"macros":0,"external_links":0,"defined_names":183,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,8],[27,1,27,8],[18,2,18,8],[19,2,19,8],[20,2,20,8],[22,2,22,8],[24,1,24,8],[5,0,5,8],[6,0,6,8],[10,1,10,2],[28,1,28,8],[0,0,0,8],[2,0,2,8],[4,0,4,8],[7,1,7,8],[21,2,21,8],[12,1,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8],[16,2,16,8],[17,2,17,8],[25,1,25,8]]}
["Introduction"]
[]
["PUE Mini Business Plan Calculateur"]
[]
["Cet outil constitue un supplément au document \"Photovoltaics for Productive Use Applications: A Catalogue of DC-Appliances\" (GIZ HERA, 2015). Il a été créé afin de chiffrer les projets par des consultants, des formateurs, des fournisseurs et autres collaborateurs dans le domaine du développement rural.   "]
["Traduction effectuée par la fondation Antenna"]
[]
["Objectif:","Déterminer la performance financière d'un projet, basé sur la technologie solaire, durant sa phase de pré-étude ou l'évaluation de prerformance. "]
["Version:","1.0 (Dec 2015)"]
["Auteurs:","Robert Schultz"]
[null,"Caspar Priesemann"]
["Lien:","https://energypedia.info/wiki/File:PUE_Mini_Business_Plan_Calculator.xlsx"]
["Instructions:","L'outil est présenté à travers 10 feuilles excel:"]
[null,"Introduction","Sert d'introduction et fournit des instructions"]
[null,"Etude de base","Entrée de données de base ! Effectuer une évaluation basique des performances financières d'une idée commerciale"]
[null,"Questionnaire","Entrée de données détaillées ! Introduction étape par étape des aspects importants et détaillé d'une idée commerciale"]
[null,"Récapitulatif","Pas de données d'entrée nécessaires ! Récapitulatif des valeurs entrées dans le Questionnaire"]
[null,"Résumé ","Pas de données d'entrée nécessaires ! Présentation des résultats et des graphiques en relation avec les données entrées dans le Questionnaire"]
[null,"12-Mois Cash Flow","Pas de données d'entrée nécessaires !  Résultat des flux de liquidités ou cash flow pendant la première année d'opération"]
[null,"10-Ans Cash Flow","Pas de données d'entrée nécessaires !  Résultat des flux de liquidités ou cash flow pendant les dix premières années d'opération"]
[null,"Calcul énergétique","Pas de données d'entrée nécessaires ! Dimensionnement du système solaire et comparaison avec une source d'énergie alternative "]
[null,"1er Remboursemnt","Pas de données d'entrée nécessaires ! Calcul automatique du remboursement mensuel du prêt contracté auprès de la 1ère banque "]
[null,"2ème Remboursement","Pas de données d'entrée nécessaires ! Calcul automatique du remboursement mensuel du prêt contracté auprès de la 2ère banque "]
[]
["Indices:","Entrées des valeurs nécessaires dans les cellules blanches"]
[null,"Etude de base est seulement une vérification rapide, indépendante des autres feuilles "]
[null,"Le symbol \"$\" est représentatif de l'argent en général et n'est pas relié à une monnaie en particulier. Aucune conversion n'est nécessaire"]

{"sheet":"Etude de Base","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Etude de Base"]
["La feuille Etude de Base permet une évaluation sommaire de votre idée commercial pour qu'elle soit potentiellement un succès. Les valeurs peuvent correspondre à des estimations. La planification de votre projet nécessite une vision claire. Ainsi, si cette Etude de Base vous offere un résultat positive, veuillez procéder au Questionnaire de façon plus détaillée."]
[null,null,"Valeur","Unité"]
["A","Revenu"]
["A.1","Prix unitaire du principal produit vendu",0,"$/unité"]
["A.2","Nombre de produit principal vendu par mois",0,"Nbr"]
["A.3","Prix d'autres produits ou services vendus par mois",0,"$/mois"]
[null,"Estimation du revenu mensuel:",{"$f":"(C5*C6)+C7","v":0},"$/mois"]
["B","Dépense"]
["B.1","Coûts mensuels fixes (salaires, loyer, prêt,…)",0,"$/mois"]
["B.2","Coûts mensuels variables (matériels, consommables,…)",0,"$/mois"]
["B.3","Autres dépenses mensuels",0,"$/mois"]
[null,"Estimation de la dépense mensuelle:",{"$f":"SUM(C10:C12)","v":0},"$/mois"]
["C","Dépense initiale"]
["C.1","Unique dépense initiale (rénovation des locaux, frais d'enregistrement,…)",0,"$"]
[null,"Estimation de la dépense initiale:",{"$f":"C15","v":0}]
[]
["D","Investissement"]
["D.1","Coût estimé de tous les appareils électriques",0,"$"]
["D.2","Coût estimé du système solaire",0,"$"]
[null,"Estimation de  l'investissement:",{"$f":"SUM(C19:C20)","v":0},"$"]
[]
[]
[null,"PROFIT OR LOSS?"]
[null,"An 1",{"$f":"($C$8*12)-($C$13*12)-$C$16-$C$21","v":0}]
[null,"An 2",{"$f":"($C$8*12)-($C$13*12)+C25","v":0}]
[null,"An 3",{"$f":"($C$8*12)-($C$13*12)+C26","v":0}]
[null,"An 4",{"$f":"($C$8*12)-($C$13*12)+C27","v":0}]
[null,"An 5",0]
[null,"An 6",0]
[null,"An 7",0]
[null,"An 8",0]
[null,"An 9",0]
[null,"An 10",0]

{"sheet":"Questionnaire","index":2,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,0,1,7],[14,7,17,7],[13,2,13,4],[14,2,14,4],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[20,1,21,2],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[54,2,54,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[81,0,82,2],[97,0,97,2],[88,1,88,6],[89,1,89,6],[78,2,78,3]]}
[null,"Questionnaire "]
["Afin de voir si votre idée a une perspective d'avenir, il est important de répondre aux questions qui suivent, une par une. Ce questionnaire vous permet d'avoir une réflexion sur les tenants et aboutissants de votre projet.  "]
[null,"Questions",null,null,null,"Valeur","Unité","Indices"]
["A","Votre commerce"]
["A.1","Quel est le nom de votre (nouveau) commerce ?",{"$nulls":4},"texte"]
["A.2","Quel est le produit principal que vous vendez ?",{"$nulls":4},"texte","e.g. fournitures, poulets, laits, boissons, …"]
["A.3","Quel est le service principal que vous vendez ? ",{"$nulls":4},"texte","e.g. coiffure, recharge téléphonique, construction, maintenance…"]
["A.4","Quels seront les matériaux nécessaires à acheter ? ",{"$nulls":4},"texte","Sans ces matéreiux (e.g. bois, oeufs, habits), votre commerce ne peut produire quoique ce soit "]
["A.5","Quels seront les matériaux optionnels à acheter ? ",{"$nulls":4},"texte","Avec ces matériaux, vous pouvez obtenir des produits de meilleures qualités mais ils ne sont pas nécessaires"]
["A.6","Quels seront les produits consommables essentiels à utiliser ? ",{"$nulls":4},"texte","Sans ces produits consommables (e.g. papier, colle, imprimante), votre commerce ne peut produire quoique ce soit"]
["A.7","Quels seront les produits consommables optionnels à utiliser ? ",{"$nulls":4},"texte","Avec ces produits consommables, vous pouvez obtenir des produits de meilleures qualités mais ils ne sont pas nécessaires"]
[]
["B","Votre revenu "]
[null,"Vous vendez le produit:",{"$f":"E6","v":0}]
[null,"Vous vendez le service: ",{"$f":"E7","v":0},{"$nulls":4},"En utilisant vos idées sur le sujet, considérez quel sera votre revenu dans les différents cas dépendant du marché cible et de la taille de votre commerce. Si vous n'êtes pas certain, tentez d'approximer du mieux possible."]
["B.1","Lors d'un excellent mois, à quel revenu vous vous attendez ?",null,null,"Scenario: Strong",0,"$/mois"]
["B.2","Lors d'un bon mois, à quel revenu vous vous attendez ? ",null,null,"Scenario: Stable",0,"$/mois"]
["B.3","Lors d'un mauvais mois, à quel revenu vous vous attendez ?",null,null,"Scenario: Weak",0,"$/mois"]
[]
["C","Votre dépense"]
["C.1","Quel sera votre unique dépense initiale, tel que: "]
["C.1.1",null,null,null,"frais d'enregistrement",0,"$","Frais payés pour l'inscription au registre du commerce ou tout autre autorité"]
["C.1.2",null,null,null,"frais légaux",0,"$","Frais payés pour l'obtention de documents légalisés demandés pour l'enregistrement au registre du commerce "]
["C.1.3",null,null,null,"rénovation du commerce",0,"$"]
["C.1.4",null,null,null,"matériel initial",0,"$"]
["C.1.5",null,null,null,"autres",0,"$"]
["C.2","Quel sera votre dépense mensuelle tel que:"]
["C.2.1","Quel sera le coût des ",{"$f":"E8","v":0},null,"avec une forte affluence de clients",0,"$/mois"]
["C.2.2","Quel sera le coût des ",{"$f":"E9","v":0},null,"avec une forte affluence de clients",0,"$/mois"]
["C.2.3","Quel sera le coût des ",{"$f":"E10","v":0},null,"avec une forte affluence de clients",0,"$/mois"]
["C.2.4","Quel sera le coût des ",{"$f":"E11","v":0},null,"avec une forte affluence de clients",0,"$/mois"]
["C.3","Quel sera votre dépense mensuelle tel que:"]
["C.3.1",null,null,null,"prix du téléphone professionnel",0,"$/mois","Pour le téléphone, fax, portable, email ou connexion internet"]
["C.3.2",null,null,null,"coûts des transports",0,"$/mois","Pour votre propre transport chez le client ou les magasins pour l'achat de matériels; incluant le fuel et la maintenance"]
["C.3.3",null,null,null,"coûts des livraisons",0,"$/mois","Pour les livraisons par d'autres transporteurs servant votre commerce"]
["C.3.4",null,null,null,"loyer du local",0,"$/mois","Si vous n'êtes pas le propriétaire ou si vous souhaitez mettre de côté de l'argent pour de futures rénovations"]
["C.3.5",null,null,null,"salaires des employés",0,"$/mois"]
["C.3.6",null,null,null,"taxes et droits de douane",0,"$/mois"]
["C.3.7",null,null,null,"sous-traitants",0,"$/mois","Paiement régulier de sous-traitants"]
["C.3.8",null,null,null,"publicité",0,"$/mois","Supports publicitaires, participation à des événements de promotions"]
["C.3.9",null,null,null,"eau, électricité,..",0,"$/mois","Si vous n'êtes pas le producteur"]
["C.3.10",null,null,null,"frais d'assurances",0,"$/mois","Assurance contre le feu, les vols, accidents et autres"]
["C.3.11",null,null,null,"frais de comptabilité ",0,"$/mois","Pour un support administratif effectué en votre faveur"]
["C.3.12",null,null,null,"autres",0,"$/mois"]
["C.3.13",null,null,null,"autres",0,"$/mois"]
[]
["C.4","Quel est l'augmentation de prix attendu",null,null,null,0,"%/année","Inflation, augmentation régulière des prix à cause du fuel ou d'autres facteurs externes"]
[]
["D","Vos équipements électriques"]
["D.1.1","Quel est le votre 1er équipement dont votre commerce a besoin? ",{"$nulls":4},"texte"]
["D.1.2","Quel sera le prix de ",{"$f":"F50","v":0},null,"?",null,"$"]
["D.1.3","Quel sera la puissance de ",{"$f":"F50","v":0},null,"?",null,"Watt","Regarder les caractéristiques de votre appareil; si c'est un groupement d'équipements, ajouter les Watt"]
["D.1.4","Est ce que ",{"$f":"F50","v":0},null,"sera connecté en DC ou AC ?",null,"AC or DC","Regarder si l'équipement est sur DC (Voltage inférieur à 20V) ou AC (Voltage supérieur à 100V)"]
["D.1.5","Combien d'heures le/la",{"$f":"F50","v":0},null,"est utilisé par jour de grande affluence ?",null,"hrs/jour","Nombre d'heures pendant lesquelles, l'équipement est connecté"]
["D.1.6","Combien de ",{"$f":"F50","v":0},null,"avez-vous besoin ?",null,"qt"]
["D.1.7","Pour la maintenance et la réparation de ",null,{"$f":"F50","v":0},"quel en sera le coût ? ",null,"$/mois","Argent que vous souhaitez garder en cas de remplacement ou réparation"]
[]
["D.2.1","Quel est le votre 1er équipement dont votre commerce a besoin? ",{"$nulls":4},"texte"]
["D.2.2","Quel sera le prix de ",{"$f":"F58","v":0},null,"?",null,"$"]
["D.2.3","Quel sera la puissance de ",{"$f":"F58","v":0},null,"?",null,"Watt","Regarder les caractéristiques de votre appareil; si c'est un groupement d'équipements, ajouter les Watt"]
["D.2.4","Est ce que ",{"$f":"F58","v":0},null,"sera connecté en DC ou AC ?",null,"AC or DC","Regarder si l'équipement est sur DC (Voltage inférieur à 20V) ou AC (Voltage supérieur à 100V)"]
["D.2.5","Combien d'heures le/la",{"$f":"F58","v":0},null,"est utilisé par jour de grande affluence ?",null,"hrs/jour","Nombre d'heures pendant lesquelles, l'équipement est connecté"]
["D.2.6","Combien de ",{"$f":"F58","v":0},null,"avez-vous besoin ?",null,"qt"]
["D.2.7","Pour la maintenance et la réparation de ",null,{"$f":"F58","v":0},"quel en sera le coût ? ",null,"$/mois","Argent que vous souhaitez garder en cas de remplacement ou réparation"]
[]
["D.3.1","Quel est le votre 1er équipement dont votre commerce a besoin? ",{"$nulls":4},"texte"]
["D.3.2","Quel sera le prix de ",{"$f":"F66","v":0},null,"?",null,"$"]
["D.3.3","Quel sera la puissance de ",{"$f":"F66","v":0},null,"?",null,"Watt","Regarder les caractéristiques de votre appareil; si c'est un groupement d'équipements, ajouter les Watt"]
["D.3.4","Est ce que ",{"$f":"F66","v":0},null,"sera connecté en DC ou AC ?",null,"AC or DC","Regarder si l'équipement est sur DC (Voltage inférieur à 20V) ou AC (Voltage supérieur à 100V)"]
["D.3.5","Combien d'heures le/la",{"$f":"F66","v":0},null,"est utilisé par jour de grande affluence ?",null,"hrs/jour","Nombre d'heures pendant lesquelles, l'équipement est connecté"]
["D.3.6","Combien de ",{"$f":"F66","v":0},null,"avez-vous besoin ?",null,"qt"]
["D.3.7","Pour la maintenance et la réparation de ",null,{"$f":"F66","v":0},"quel en sera le coût ? ",null,"$/mois","Argent que vous souhaitez garder en cas de remplacement ou réparation"]
[]
["D.4.1","Quel est le votre 1er équipement dont votre commerce a besoin? ",{"$nulls":4},"texte"]
["D.4.2","Quel sera le prix de ",{"$f":"F74","v":0},null,"?",null,"$"]
["D.4.3","Quel sera la puissance de ",{"$f":"F74","v":0},null,"?",null,"Watt","Regarder les caractéristiques de votre appareil; si c'est un groupement d'équipements, ajouter les Watt"]
["D.4.4","Est ce que ",{"$f":"F74","v":0},null,"sera connecté en DC ou AC ?",null,"AC or DC","Regarder si l'équipement est sur DC (Voltage inférieur à 20V) ou AC (Voltage supérieur à 100V)"]
["D.4.5","Combien d'heures le/la",{"$f":"F74","v":0},null,"est utilisé par jour de grande affluence ?",null,"hrs/jour","Nombre d'heures pendant lesquelles, l'équipement est connecté"]
["D.4.6","Combien de ",{"$f":"F74","v":0},null,"avez-vous besoin ?",null,"qt"]
["D.4.7","Pour la maintenance et la réparation de ",null,{"$f":"F74","v":0},"quel en sera le coût ? ",null,"$/mois","Argent que vous souhaitez garder en cas de remplacement ou réparation"]
[]
["Pour alimenter votre équipement électrique depuis un système solaire, la capacité nécessaire est:"]
[null,null,null,{"$f":"'Calcul Énergétique'!B11","v":0},"Watt peak (Wp)","Note: une moyenne de  ",5,"heures d'ensoleillement par jour est supposé. Vous pouvez ajuster la valeur au besoin."]
[]
["D.5.1","Pendant combien de jours pouvez-vous rester sans soleil ? ",null,null,null,1,"jour(s)","Note: 1 jour est le minimum, au vu du dimensionnement de la batterie qui est nécessaire pour la stabilité du réseau"]
["D.5.2","Quel est le prix d'une telle installation (PV + batteries)",{"$nulls":4},"$","Vous pouvez vous référer à votre fournisseur de PV ainsi qu'à la page 8"]
["D.5.3","Quel est le prix des batteries si vous deviez les remplacer ?",{"$nulls":4},"$","Vous pouvez vous référer à votre fournisseur de PV ainsi qu'à la page 8"]
[]
[null,"Comparaison avec une source alternative d'électricité:"]
[null,"Note: cette partie est optionelle et ne considère que la période de remboursement entre un système solaire et une autre source d'électrcitié (e.g. génératrice diesel). Cette alternative n'est pas prise en compte dans les calculs financiers."]
[null,"Quelle est la source alternative d'électricité ?",{"$nulls":4},"texte","Aucune, génératrice diesel, réseau électriqueNone, Diesel engine, petrol engine, grid electricity"]
[null,"Combien vous coûterait",null,{"$f":"F91","v":0},"par mois ?",0,"$/mois","Dépense pour le fuel ou la connexion au réseau "]
[null,"Combien vous coûterait la maintenance ou la réparation de",null,{"$f":"F91","v":0},"par mois ?",0,"$/mois"]
[null,"Si vous souhaitez acheter un(e) nouveau/lle",null,{"$f":"F91","v":0},"combien cela vous coûterait ?",0,"$","Regardez avec votre fournisseur"]
[]
[]
["E","Financer votre commerce"]
["La somme minimum requise pour commencer votre commerce est de:",null,null,{"$f":"Résumé!$D$18","v":0},"$"]
[]
["E.1","Si vous avez accès à une subvention pour démarrer votre projet, combien pourriez-vous obtenir ?",null,null,null,0,"$","La subvention peut-être de l'argent obtenu gratuitement auprès d'un proche, d'une organisation ou même du gouvernement"]
["E.2","Combien de fonds propre (capital) avez-vous pour démarrer votre commerce ? ",null,null,null,0,"$"]
[]
["E.3","Si vous avez besoin d'un prêt bancaire, quel est le nom de la première banque ? ",{"$nulls":4},"texte"]
["E.3.1","Quel est le montant de la part de",null,{"$f":"F103","v":0},"que vous souhaitez emprunter ?",0,"$"]
["E.3.2","Quel est le taux d'intérêt de ",null,{"$f":"F103","v":0},"à payer chaque année ? ",0,"%/année"]
["E.3.3","Pour rembourser vode dettes contractées de ",null,{"$f":"F103","v":0},"combien d'années vous faudra t-il ? ",null,"années"]
["E.3.4","Quelle est la caution demandée par",null,{"$f":"F103","v":0},"pour l'obtention d'un prêt ?",0,"%"]
["E.3.5","Quelle serait votre date préférée afin de débuter votre projet ?",{"$nulls":4},"jj/mm/yyyy","Note: Ajouter n'importe quelle date. Cette donnée est importante pour calculer le remboursement de la dette."]
[]
["E.4","Si vous avez besoin d'un prêt bancaire, quel est le nom de la seconde banque ? ",{"$nulls":4},"texte"]
["E.4.1","Quel est le montant de la part de",null,{"$f":"F110","v":0},"que vous souhaitez emprunter ?",0,"$"]
["E.4.2","Quel est le taux d'intérêt de ",null,{"$f":"F110","v":0},"à payer chaque année ? ",0,"%/année"]
["E.4.3","Pour rembourser vode dettes contractées de ",null,{"$f":"F110","v":0},"combien d'années vous faudra t-il ? ",null,"années"]
["E.4.4","Quelle est la caution demandée par",null,{"$f":"F110","v":0},"pour l'obtention d'un prêt ?",0,"%"]
["E.4.5","Quelle serait votre date préférée afin de débuter votre projet ?",{"$nulls":4},"jj/mm/yyyy","Note: Ajouter n'importe quelle date. Cette donnée est importante pour calculer le remboursement de la dette."]

{"sheet":"Récapitulatif","index":3,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,0,1,5]]}
[null,"Récapitulatif"]
["Ce Récapitulatif offre une vue d'ensemble sur les aspects techniques et financiers de votre future commerce. Les résultats sont en lien avec les valeurs introduites dans le Questionnaire. Il est possible de voir l'évolution des résultats en changeant les valeurs dans la feuille excel précédante."]
[null,"Nom du commerce:",null,{"$f":"Questionnaire!$E$5","v":0}]
[null,"Type des principaux produits:",null,{"$f":"Questionnaire!$E$6","v":0}]
[null,"Type des principaux services:",null,{"$f":"Questionnaire!$E$7","v":0}]
[null,"Aspects techniques et financiers",null,"Valeur ","Unité","Sensible à"]
["B","Votre revenu "]
[null,{"$f":"Questionnaire!$E$16","v":"Scenario: Strong"},null,{"$f":"Questionnaire!$F$16","v":0},"$/mois","Si le marché est important, votre produit et service sont sujet à une forte demande. "]
[null,{"$f":"Questionnaire!$E$17","v":"Scenario: Stable"},null,{"$f":"Questionnaire!$F$17","v":0},"$/mois","Si le marché est stable, votre produit et service sont sujet à une demande régulière. "]
[null,{"$f":"Questionnaire!$E$18","v":"Scenario: Weak"},null,{"$f":"Questionnaire!$F$18","v":0},"$/mois","If your market is weak and there is low demand for your product and service. But markets change!"]
[]
["C","Votre dépense"]
[null,"Dépense initiale totale (sans les équipements)",null,{"$f":"SUM(Questionnaire!$F$22:$F$26)","v":0},"$"]
[null,"Dépense total en matériel et produits consommables:",null,{"$f":"SUM(Questionnaire!$F$28:$F$31)","v":0},"$/mois"]
[null,"Dépense mensuelle régulière:",null,{"$f":"SUM(Questionnaire!$F$33:$F$45)","v":0},"$/mois"]
[null,"Inflation annuelle:",null,{"$f":"Questionnaire!$F$47","v":0},"%/année","Plus c'est élevé, plus il faudra ajuster vos prix de ventes."]
[]
["D","Votre équipement électrique"]
[null,"Nombre total d'appareils électriques:",null,{"$f":"'Calcul Énergétique'!$C$8","v":0},"qt","Plus c'est élevé, plus le coût d'investissement et la demande/consommation électrique augmenteront"]
[null,"Coût total d'appareils électriques:",null,{"$f":"(Questionnaire!$F$51*Questionnaire!$F$55)+(Questionnaire!$F$59*Questionnaire!$F$63)+(Questionnaire!$F$67*Questionnaire!$F$71)+(Questionnaire!$F$75*Questionnaire!$F$79)","v":0},"$","Plus c'est élevé, plus le coût d'investissement et la demande/consommation électrique augmenteront"]
[null,"Coût total du système solaire:",null,{"$f":"Questionnaire!$F$86","v":0},"$","Plus c'est élevé, plus le coût d'investissement et la demande/consommation électrique augmenteront"]
[null,"Epargnes pour la maintenance et la réparation:",null,{"$f":"Questionnaire!$F$56+Questionnaire!$F$64+Questionnaire!$F$72+Questionnaire!$F$80","v":0},"$/mois","Plus c'est élevé, plus l'épargne sera plus importante"]
[null,"Epargnes mensuelles pour la maintenance PV et sa réparation:",null,{"$f":"'Calcul Énergétique'!$C$20","v":0},"$/mois","Plus c'est élevé, plus l'épargne sera plus importante"]
[null,"Puissance totale requise par les appareils:",null,{"$f":"'Calcul Énergétique'!$B$8","v":0},"Watts","Puissance maximale si tous les appareils sont connectés"]
[null,"Consommation électrique totale journalière:",null,{"$f":"'Calcul Énergétique'!$F$8","v":0},"Wh/jour","Consommation maximale si tous les appareils sont connectés"]
[null,"Capacité solaire à installer:",null,{"$f":"'Calcul Énergétique'!$B$11","v":0},"Wp","Plus c'est élevé, plus le système est coûteux"]
[null,"Capacité de la batterie associée aux panneaux solaires:",null,{"$f":"'Calcul Énergétique'!$B$15","v":0},"Wh","Pour la réduire: diminuer les jours d'autonomie et faire fonctionner le commerce pendant la journée"]
[null,"Onduleur nécessaire ?",null,{"$f":"'Calcul Énergétique'!$B$12","v":"No"},"Oui ou Non?","Si oui → coût additionnel pour le système solaire"]
[null,"Jours d'autonomies ?",null,{"$f":"Questionnaire!$F$85","v":1},"Jours","Plus c'est élevé, plus la capacité de la batterie sera importante"]
[null,"Le système solaire comparé à l'alternative, a une période de remboursement de:",null,{"$f":"'Calcul Énergétique'!$B$27","v":37},"Mois","Plus c'est court, plus le solaire s'impose comme solution nécessaire"]
[]
["E","Financer votre commerce"]
[null,"Fond initial nécessaire pour démarrer votre commerce:",null,{"$f":"Résumé!$D$18","v":0},"$","Plus c'est élevé, plus il faut faire attention au planning"]
[null,"Fond propre:",null,{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},"$","Plus c'est élevé, le moins d'argent sera emprunté"]
[null,"Fond prêté par les banques:",null,{"$f":"Questionnaire!$F$104+Questionnaire!$F$111","v":0},"$","Si c'est rouge, la valeur est trop faible pour démarrer le commerce"]
[null,"Taux d'intérêt moyen à payer: ",null,{"$f":"AVERAGE(Questionnaire!$F$105, Questionnaire!$F$112)","v":0},"%/année","Plus l'intérêt est fort, plus le montant à rembourser aux banques sera élevé"]
[null,"Période moyenne de remboursement:",null,{"$f":"AVERAGE(Questionnaire!$F$106,Questionnaire!$F$113)","v":{"$error":"#DIV/0!"}},"années","Plus la durée est longue, le moins d'argent sera remboursé mensuellement"]
[null,"Prêt mensuel à rembourser à ",{"$f":"Questionnaire!$F$103","v":0},{"$f":"'1er Remboursement'!Scheduled_Monthly_Payment","v":"0"},"$/mois","Influencé par le taux d'intérêt et la période de prêt"]
[null,"Prêt mensuel à rembourser à ",{"$f":"Questionnaire!F110","v":0},{"$f":"'2ème Remboursement'!Scheduled_Monthly_Payment","v":"0"},"$/mois","Influencé par le taux d'intérêt et la période de prêt"]

{"sheet":"Résumé","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,3,1,5],[5,7,5,8],[4,7,4,8],[3,7,3,8],[2,7,2,8],[10,7,10,8],[6,7,6,8],[8,7,8,8],[16,7,16,8],[23,7,23,8],[7,7,7,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[17,7,17,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[26,7,29,8],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[24,7,24,8],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[0,1,0,8],[20,1,20,2],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[15,1,15,2],[16,1,16,2],[7,3,7,5],[8,3,8,5],[11,3,11,5],[12,3,12,5],[13,3,13,5]]}
[null,"Résumé"]
[null,null,null,"Valeur",null,null,"Unité","Notes"]
[null,"Information de base"]
[null,"Nom du commerce:",null,{"$f":"Questionnaire!$E$5","v":0},null,null,"texte"]
[null,"Type des principaux produits:",null,{"$f":"Questionnaire!$E$6","v":0},null,null,"texte"]
[null,"Type des principaux services:",null,{"$f":"Questionnaire!$E$7","v":0},null,null,"texte"]
[null,"Investissement total sur les biens",null,{"$f":"D12+D13","v":0},null,null,"$","inclus les appareils et le système PV"]
[null,"Fond propre total ou subvenetion",null,{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},null,null,"$"]
[null,"Fond prêté par les banques",null,{"$f":"Questionnaire!$F$104+Questionnaire!$F$111","v":0},null,null,"$","si Rouge: cette valeur est trop faible pour démarrer votre projet"]
[]
[null,"Dépense initiale et générale"]
[null,"Coût des appareils électriques:",null,{"$f":"(Questionnaire!$F$51*Questionnaire!$F$55)+(Questionnaire!$F$59*Questionnaire!$F$63)+(Questionnaire!$F$67*Questionnaire!$F$71)+(Questionnaire!$F$75*Questionnaire!$F$79)","v":0},null,null,"$"]
[null,"Coût du système PV:",null,{"$f":"Questionnaire!$F$86","v":0},null,null,"$"]
[null,"Coût total du matériel et des produits de consommation:",null,{"$f":"SUM('12-Mois Cash Flow'!$C$14:$C$15)","v":0},null,null,"$"]
[null,"Caution bancaire nécessaire:",null,{"$f":"(Questionnaire!$F$104*Questionnaire!$F$107)+(Questionnaire!$F$111*Questionnaire!$F$114)","v":0},null,null,"$"]
[null,"Dépense initiale:",null,{"$f":"SUM(Questionnaire!$F$22:$F$26)","v":0},null,null,"$"]
[null,"Coût opérationnel au 1er mois:",null,{"$f":"F25-D14","v":0},null,null,"$"]
[null,"Fond total requis au 1er mois:",null,{"$f":"SUM(D12:F17)-D14","v":0},null,null,"$/mois"]
[]
[null,"Dépenses courantes (mensuelles)"]
[null,"Döpenses courantes sur l'opérationnel:",null,null,null,{"$f":"SUM('12-Mois Cash Flow'!$C$16:$C$28)","v":0},"$/mois"]
[null,"Coût du matériel et des produits de consommation:",null,null,null,{"$f":"SUM('12-Mois Cash Flow'!$C$14:$C$15)","v":0},"$/mois"]
[null,"Remboursement du prêt mensuel:",null,null,null,{"$f":"'12-Mois Cash Flow'!$D$30+'12-Mois Cash Flow'!$D$31","v":0},"$/mois"]
[null,"Epargnes pour la maintenance et le remplacement des équipements: ",null,null,null,{"$f":"SUM(Récapitulatif!$D$22:$D$23)","v":0},"$/mois","inclus les appareils et le système PV"]
[null,"Dépenses mensuelles totales:",null,null,null,{"$f":"SUM(F21:F24)","v":0},"$/mois"]
[]
[null,"Profit/Perte annuel(le) par scenario (argent à la fin de l'année)","An 1","An 3","An 5","An 7","An 10","Le profit décline dans le temps à cause de facteurs tel que l'inflation. Ainsi, vous devez augmenter les prix de ventes de temps à autre."]
[null,{"$f":"Questionnaire!$E$16","v":"Scenario: Strong"},{"$f":"'10-Ans Cash Flow'!C35","v":0},{"$f":"'10-Ans Cash Flow'!E35","v":0},{"$f":"'10-Ans Cash Flow'!G35","v":0},{"$f":"'10-Ans Cash Flow'!I35","v":0},{"$f":"'10-Ans Cash Flow'!L35","v":0}]
[null,{"$f":"Questionnaire!$E$17","v":"Scenario: Stable"},{"$f":"'10-Ans Cash Flow'!C71","v":0},{"$f":"'10-Ans Cash Flow'!E71","v":0},{"$f":"'10-Ans Cash Flow'!G71","v":0},{"$f":"'10-Ans Cash Flow'!I71","v":0},{"$f":"'10-Ans Cash Flow'!L71","v":0}]
[null,{"$f":"Questionnaire!$E$18","v":"Scenario: Weak"},{"$f":"'10-Ans Cash Flow'!C107","v":0},{"$f":"'10-Ans Cash Flow'!E107","v":0},{"$f":"'10-Ans Cash Flow'!G107","v":0},{"$f":"'10-Ans Cash Flow'!I107","v":0},{"$f":"'10-Ans Cash Flow'!L107","v":0}]

{"sheet":"12-Mois Cash Flow","index":5,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":false,"merged":[[86,3,86,14],[0,1,0,16],[37,1,37,16],[74,1,74,16],[12,3,12,14],[49,3,49,14]]}
[null,"12-Mois Cash Flow"]
[null,{"$f":"Questionnaire!E16","v":"Scenario: Strong"},"Nom de l'entreprise:",null,{"$f":"Questionnaire!$E$5","v":0},{"$nulls":4},"Début de l'année fiscale:",{"$f":"Questionnaire!$F$108","v":"00:00:00"}]
[null,null,"Lancement",{"$f":"K2","v":"00:00:00"},{"$f":"DATE(YEAR(D3),MONTH(D3)+1,1)","v":"1900-02-01"},{"$f":"DATE(YEAR(E3),MONTH(E3)+1,1)","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","An 1","An 2"]
[null,"STRONG: CASH DISPONIBLE (début du mois)",{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},{"$f":"C35","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O35","v":0}]
[]
[null,"Rentrée d'argent"]
[null,"Ventes au comptant",null,{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"Questionnaire!$F$16","v":0},{"$f":"SUM(D7:O7)","v":0},{"$f":"SUM(D7:O7)","v":0}]
[null,"Autres ventes"]
[null,"Rentrée d'argent totale",{"$f":"SUM(C7:C7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Argent total disponible (avant prélèvement)",{"$f":"(C4+C9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q4+Q9)","v":0}]
[]
[null,"MONTANT PAYÉ"]
[null,"dépense initiale",{"$f":"SUM(Questionnaire!$F$22:$F$26)","v":0},0,{"$nulls":11},{"$f":"SUM(C13:O13)","v":0},0]
[null,"matériels",{"$f":"Questionnaire!$F$28+Questionnaire!$F$29","v":0},{"$f":"C14","v":0},{"$f":"D14","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C14:O14)","v":0},{"$f":"P14+(P14*Questionnaire!$F$47)","v":0}]
[null,"consommables",{"$f":"Questionnaire!$F$30+Questionnaire!$F$31","v":0},{"$f":"C15","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C15:O15)","v":0},{"$f":"P15+(P15*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$33","v":"prix du téléphone professionnel"},{"$f":"Questionnaire!$F$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P16+(P16*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$34","v":"coûts des transports"},{"$f":"Questionnaire!$F$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P17+(P17*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$35","v":"coûts des livraisons"},{"$f":"Questionnaire!$F$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P18+(P18*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$36","v":"loyer du local"},{"$f":"Questionnaire!$F$36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P19+(P19*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$37","v":"salaires des employés"},{"$f":"Questionnaire!$F$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P20+(P20*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$38","v":"taxes et droits de douane"},{"$f":"Questionnaire!$F$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P21+(P21*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$39","v":"sous-traitants"},{"$f":"Questionnaire!$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P22+(P22*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$40","v":"publicité"},{"$f":"Questionnaire!$F$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P23+(P23*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$41","v":"eau, électricité,.."},{"$f":"Questionnaire!$F$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P24+(P24*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$42","v":"frais d'assurances"},{"$f":"Questionnaire!$F$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P25+(P25*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$43","v":"frais de comptabilité "},{"$f":"Questionnaire!$F$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P26+(P26*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$44","v":"autres"},{"$f":"Questionnaire!$F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P27+(P27*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$45","v":"autres"},{"$f":"Questionnaire!$F$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P28+(P28*Questionnaire!$F$47)","v":0}]
[null,"SOUS-TOTAL",{"$f":"SUM(C13:C28)","v":0},{"$f":"SUM(D13:D28)","v":0},{"$f":"SUM(E13:E28)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P13:P28)","v":0},{"$f":"SUM(Q13:Q28)","v":0}]
[null,"Prêt mensuel à rembourser à la 1ère banque",null,{"$f":"'1er Remboursement'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D30","v":"0"},{"$f":"E30","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C30:O30)","v":0},{"$f":"P30","v":0}]
[null,"Prêt mensuel à rembourser à la 2ème banque",null,{"$f":"'2ème Remboursement'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D31","v":"0"},{"$f":"E31","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C31:O31)","v":0},{"$f":"P31","v":0}]
[null,{"$f":"Récapitulatif!$B$22","v":"Epargnes pour la maintenance et la réparation:"},null,{"$f":"Récapitulatif!$D$22","v":0},{"$f":"D32","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C32:O32)","v":0},{"$f":"P32","v":0}]
[null,{"$f":"Récapitulatif!$B$23","v":"Epargnes mensuelles pour la maintenance PV et sa réparation:"},null,{"$f":"Récapitulatif!$D$23","v":0},{"$f":"D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MONTANT TOTAL PAYÉ",{"$f":"SUM(C29:C33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Montant des liquidités (fin du mois)",{"$f":"(C10-C34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q10-Q34)","v":0}]
[]
[]
[null,"12-Mois Cash Flow"]
[null,{"$f":"Questionnaire!E17","v":"Scenario: Stable"},"Nom de l'entreprise:",null,{"$f":"Questionnaire!$E$5","v":0},{"$nulls":4},"Début de l'année fiscale:",{"$f":"Questionnaire!$F$108","v":"00:00:00"}]
[null,null,"Lancement",{"$f":"K39","v":"00:00:00"},{"$f":"DATE(YEAR(D40),MONTH(D40)+1,1)","v":"1900-02-01"},{"$f":"DATE(YEAR(E40),MONTH(E40)+1,1)","v":"1900-03-01"},{"$f":"DATE(YEAR(F40),MONTH(F40)+1,1)","v":"1900-04-01"},{"$f":"DATE(YEAR(G40),MONTH(G40)+1,1)","v":"1900-05-01"},{"$f":"DATE(YEAR(H40),MONTH(H40)+1,1)","v":"1900-06-01"},{"$f":"DATE(YEAR(I40),MONTH(I40)+1,1)","v":"1900-07-01"},{"$f":"DATE(YEAR(J40),MONTH(J40)+1,1)","v":"1900-08-01"},{"$f":"DATE(YEAR(K40),MONTH(K40)+1,1)","v":"1900-09-01"},{"$f":"DATE(YEAR(L40),MONTH(L40)+1,1)","v":"1900-10-01"},{"$f":"DATE(YEAR(M40),MONTH(M40)+1,1)","v":"1900-11-01"},{"$f":"DATE(YEAR(N40),MONTH(N40)+1,1)","v":"1900-12-01"},"An 1","An 2"]
[null,"STABLE: CASH DISPONIBLE (début du mois)",{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},{"$f":"C72","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O72","v":0}]
[]
[null,"Rentrée d'argent"]
[null,"Ventes au comptant",null,{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"Questionnaire!$F$17","v":0},{"$f":"SUM(D44:O44)","v":0},{"$f":"SUM(D44:O44)","v":0}]
[null,"Autres ventes"]
[null,"Rentrée d'argent totale",{"$f":"SUM(C44:C44)","v":0},{"$f":"SUM(D44:D44)","v":0},{"$f":"SUM(E44:E44)","v":0},{"$f":"SUM(F44:F44)","v":0},{"$f":"SUM(G44:G44)","v":0},{"$f":"SUM(H44:H44)","v":0},{"$f":"SUM(I44:I44)","v":0},{"$f":"SUM(J44:J44)","v":0},{"$f":"SUM(K44:K44)","v":0},{"$f":"SUM(L44:L44)","v":0},{"$f":"SUM(M44:M44)","v":0},{"$f":"SUM(N44:N44)","v":0},{"$f":"SUM(O44:O44)","v":0},{"$f":"SUM(P44:P44)","v":0},{"$f":"SUM(Q44:Q44)","v":0}]
[null,"Argent total disponible (avant prélèvement)",{"$f":"(C41+C46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q41+Q46)","v":0}]
[]
[null,"MONTANT PAYÉ"]
[null,"dépense initiale",{"$f":"SUM(Questionnaire!$F$22:$F$26)","v":0},0,{"$nulls":11},{"$f":"SUM(C50:O50)","v":0},0]
[null,"matériels",{"$f":"Questionnaire!$F$28+Questionnaire!$F$29","v":0},{"$f":"C51","v":0},{"$f":"D51","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C51:O51)","v":0},{"$f":"P51+(P51*Questionnaire!$F$47)","v":0}]
[null,"consommables",{"$f":"Questionnaire!$F$30+Questionnaire!$F$31","v":0},{"$f":"C52","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C52:O52)","v":0},{"$f":"P52+(P52*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$33","v":"prix du téléphone professionnel"},{"$f":"Questionnaire!$F$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P53+(P53*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$34","v":"coûts des transports"},{"$f":"Questionnaire!$F$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P54+(P54*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$35","v":"coûts des livraisons"},{"$f":"Questionnaire!$F$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P55+(P55*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$36","v":"loyer du local"},{"$f":"Questionnaire!$F$36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P56+(P56*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$37","v":"salaires des employés"},{"$f":"Questionnaire!$F$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P57+(P57*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$38","v":"taxes et droits de douane"},{"$f":"Questionnaire!$F$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P58+(P58*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$39","v":"sous-traitants"},{"$f":"Questionnaire!$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P59+(P59*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$40","v":"publicité"},{"$f":"Questionnaire!$F$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P60+(P60*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$41","v":"eau, électricité,.."},{"$f":"Questionnaire!$F$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P61+(P61*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$42","v":"frais d'assurances"},{"$f":"Questionnaire!$F$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P62+(P62*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$43","v":"frais de comptabilité "},{"$f":"Questionnaire!$F$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P63+(P63*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$44","v":"autres"},{"$f":"Questionnaire!$F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P64+(P64*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$45","v":"autres"},{"$f":"Questionnaire!$F$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P65+(P65*Questionnaire!$F$47)","v":0}]
[null,"SOUS-TOTAL",{"$f":"SUM(C50:C65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Prêt mensuel à rembourser à la 1ère banque",null,{"$f":"'1er Remboursement'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D67","v":"0"},{"$f":"E67","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C67:O67)","v":0},{"$f":"P67","v":0}]
[null,"Prêt mensuel à rembourser à la 2ème banque",null,{"$f":"'2ème Remboursement'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D68","v":"0"},{"$f":"E68","v":"0"},"0","0","0","0","0","0","0","0","0"]
[null,{"$f":"Récapitulatif!$B$22","v":"Epargnes pour la maintenance et la réparation:"},null,{"$f":"Récapitulatif!$D$22","v":0},{"$f":"D69","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C69:O69)","v":0},{"$f":"P69","v":0}]
[null,{"$f":"Récapitulatif!$B$23","v":"Epargnes mensuelles pour la maintenance PV et sa réparation:"},null,{"$f":"Récapitulatif!$D$23","v":0},{"$f":"D70","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MONTANT TOTAL PAYÉ",{"$f":"SUM(C66:C70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Montant des liquidités (fin du mois)",{"$f":"(C47-C71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q47-Q71)","v":0}]
[]
[]
[null,"12-Mois Cash Flow"]
[null,{"$f":"Questionnaire!E18","v":"Scenario: Weak"},"Nom de l'entreprise:",null,{"$f":"Questionnaire!$E$5","v":0},{"$nulls":4},"Début de l'année fiscale:",{"$f":"Questionnaire!$F$108","v":"00:00:00"}]
[null,null,"Lancement",{"$f":"K76","v":"00:00:00"},{"$f":"DATE(YEAR(D77),MONTH(D77)+1,1)","v":"1900-02-01"},{"$f":"DATE(YEAR(E77),MONTH(E77)+1,1)","v":"1900-03-01"},{"$f":"DATE(YEAR(F77),MONTH(F77)+1,1)","v":"1900-04-01"},{"$f":"DATE(YEAR(G77),MONTH(G77)+1,1)","v":"1900-05-01"},{"$f":"DATE(YEAR(H77),MONTH(H77)+1,1)","v":"1900-06-01"},{"$f":"DATE(YEAR(I77),MONTH(I77)+1,1)","v":"1900-07-01"},{"$f":"DATE(YEAR(J77),MONTH(J77)+1,1)","v":"1900-08-01"},{"$f":"DATE(YEAR(K77),MONTH(K77)+1,1)","v":"1900-09-01"},{"$f":"DATE(YEAR(L77),MONTH(L77)+1,1)","v":"1900-10-01"},{"$f":"DATE(YEAR(M77),MONTH(M77)+1,1)","v":"1900-11-01"},{"$f":"DATE(YEAR(N77),MONTH(N77)+1,1)","v":"1900-12-01"},"An 1","An 2"]
[null,"WEAK: CASH DISPONIBLE (début du mois)",{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},{"$f":"C109","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O109","v":0}]
[]
[null,"Rentrée d'argent"]
[null,"Ventes au comptant",null,{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"Questionnaire!$F$18","v":0},{"$f":"SUM(D81:O81)","v":0},{"$f":"SUM(D81:O81)","v":0}]
[null,"Autres ventes"]
[null,"Rentrée d'argent totale",{"$f":"SUM(C81:C81)","v":0},{"$f":"SUM(D81:D81)","v":0},{"$f":"SUM(E81:E81)","v":0},{"$f":"SUM(F81:F81)","v":0},{"$f":"SUM(G81:G81)","v":0},{"$f":"SUM(H81:H81)","v":0},{"$f":"SUM(I81:I81)","v":0},{"$f":"SUM(J81:J81)","v":0},{"$f":"SUM(K81:K81)","v":0},{"$f":"SUM(L81:L81)","v":0},{"$f":"SUM(M81:M81)","v":0},{"$f":"SUM(N81:N81)","v":0},{"$f":"SUM(O81:O81)","v":0},{"$f":"SUM(P81:P81)","v":0},{"$f":"SUM(Q81:Q81)","v":0}]
[null,"Argent total disponible (avant prélèvement)",{"$f":"(C78+C83)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q78+Q83)","v":0}]
[]
[null,"MONTANT PAYÉ"]
[null,"dépense initiale",{"$f":"SUM(Questionnaire!$F$22:$F$26)","v":0},0,{"$nulls":11},{"$f":"SUM(C87:O87)","v":0},0]
[null,"matériels",{"$f":"Questionnaire!$F$28+Questionnaire!$F$29","v":0},{"$f":"C88","v":0},{"$f":"D88","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C88:O88)","v":0},{"$f":"P88+(P88*Questionnaire!$F$47)","v":0}]
[null,"consommables",{"$f":"Questionnaire!$F$30+Questionnaire!$F$31","v":0},{"$f":"C89","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C89:O89)","v":0},{"$f":"P89+(P89*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$33","v":"prix du téléphone professionnel"},{"$f":"Questionnaire!$F$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P90+(P90*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$34","v":"coûts des transports"},{"$f":"Questionnaire!$F$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P91+(P91*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$35","v":"coûts des livraisons"},{"$f":"Questionnaire!$F$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P92+(P92*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$36","v":"loyer du local"},{"$f":"Questionnaire!$F$36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P93+(P93*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$37","v":"salaires des employés"},{"$f":"Questionnaire!$F$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P94+(P94*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$38","v":"taxes et droits de douane"},{"$f":"Questionnaire!$F$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P95+(P95*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$39","v":"sous-traitants"},{"$f":"Questionnaire!$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P96+(P96*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$40","v":"publicité"},{"$f":"Questionnaire!$F$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P97+(P97*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$41","v":"eau, électricité,.."},{"$f":"Questionnaire!$F$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P98+(P98*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$42","v":"frais d'assurances"},{"$f":"Questionnaire!$F$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P99+(P99*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$43","v":"frais de comptabilité "},{"$f":"Questionnaire!$F$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P100+(P100*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$44","v":"autres"},{"$f":"Questionnaire!$F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P101+(P101*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$45","v":"autres"},{"$f":"Questionnaire!$F$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P102+(P102*Questionnaire!$F$47)","v":0}]
[null,"SOUS-TOTAL",{"$f":"SUM(C87:C102)","v":0},{"$f":"SUM(D87:D102)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Prêt mensuel à rembourser à la 1ère banque",null,{"$f":"'1er Remboursement'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D104","v":"0"},{"$f":"E104","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C104:O104)","v":0},{"$f":"P104","v":0}]
[null,"Prêt mensuel à rembourser à la 2ème banque",null,{"$f":"'2ème Remboursement'!Scheduled_Monthly_Payment","v":"0"}]
[null,{"$f":"Récapitulatif!$B$22","v":"Epargnes pour la maintenance et la réparation:"},null,{"$f":"Récapitulatif!$D$22","v":0},{"$f":"D106","v":0},{"$f":"E106","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C106:O106)","v":0},{"$f":"P106","v":0}]
[null,{"$f":"Récapitulatif!$B$23","v":"Epargnes mensuelles pour la maintenance PV et sa réparation:"},null,{"$f":"Récapitulatif!$D$23","v":0},{"$f":"D107","v":0},{"$f":"E107","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"MONTANT TOTAL PAYÉ",{"$f":"SUM(C103:C107)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Montant des liquidités (fin du mois)",{"$f":"(C84-C108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q84-Q108)","v":0}]

{"sheet":"10-Ans Cash Flow","index":6,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":false,"merged":[[84,3,84,12],[0,1,0,13],[36,1,36,13],[72,1,72,13],[12,3,12,12],[48,3,48,12]]}
[null,"10-Ans Cash Flow"]
[null,{"$f":"Questionnaire!E16","v":"Scenario: Strong"},"Nom de l'entreprise:",null,{"$f":"Questionnaire!$E$5","v":0},{"$nulls":4},"Début de l'année fiscale:",{"$f":"Questionnaire!$F$108","v":"00:00:00"}]
[null,null,"An 1","An 2","An 3","An 4","An 5","An 6","An 7","An 8","An 9","An 10","An 11","An 12"]
[null,"STRONG: CASH DISPONIBLE (début de l'année)",{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},{"$f":"C35","v":0},{"$f":"D35","v":0},{"$f":"E35","v":0},{"$f":"F35","v":0},0,0,0,0,0,0,0]
[]
[null,"Rentrée d'argent"]
[null,"Ventes au comptant",{"$f":"'12-Mois Cash Flow'!Q9","v":0},{"$f":"C7","v":0},{"$f":"D7","v":0},{"$f":"E7","v":0},{"$f":"F7","v":0},{"$f":"G7","v":0},0,0,0,0,0]
[null,"Autres ventes"]
[null,"Rentrée d'argent totale",{"$f":"SUM(C7:C7)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Argent total disponible (avant prélèvement)",{"$f":"(C4+C9)","v":0},{"$f":"(D4+D9)","v":0},{"$f":"(E4+E9)","v":0},{"$f":"(F4+F9)","v":0},{"$f":"(G4+G9)","v":0},{"$f":"(H4+H9)","v":0},0,0,0,0,0]
[]
[null,"MONTANT PAYÉ"]
[null,"dépense initiale",{"$f":"'12-Mois Cash Flow'!$P$13","v":0},0]
[null,"matériels",{"$f":"'12-Mois Cash Flow'!$P$14","v":0},{"$f":"C14+(C14*Questionnaire!$F$47)","v":0},{"$f":"D14+(D14*Questionnaire!$F$47)","v":0},{"$f":"E14+(E14*Questionnaire!$F$47)","v":0},{"$f":"F14+(F14*Questionnaire!$F$47)","v":0},{"$f":"G14+(G14*Questionnaire!$F$47)","v":0},{"$f":"H14+(H14*Questionnaire!$F$47)","v":0},{"$f":"I14+(I14*Questionnaire!$F$47)","v":0},{"$f":"J14+(J14*Questionnaire!$F$47)","v":0},{"$f":"K14+(K14*Questionnaire!$F$47)","v":0},{"$f":"L14+(L14*Questionnaire!$F$47)","v":0}]
[null,"consommables",{"$f":"'12-Mois Cash Flow'!$P$15","v":0},{"$f":"C15+(C15*Questionnaire!$F$47)","v":0},{"$f":"D15+(D15*Questionnaire!$F$47)","v":0},{"$f":"E15+(E15*Questionnaire!$F$47)","v":0},{"$f":"F15+(F15*Questionnaire!$F$47)","v":0},{"$f":"G15+(G15*Questionnaire!$F$47)","v":0},{"$f":"H15+(H15*Questionnaire!$F$47)","v":0},{"$f":"I15+(I15*Questionnaire!$F$47)","v":0},{"$f":"J15+(J15*Questionnaire!$F$47)","v":0},{"$f":"K15+(K15*Questionnaire!$F$47)","v":0},{"$f":"L15+(L15*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$33","v":"prix du téléphone professionnel"},{"$f":"'12-Mois Cash Flow'!$P$16","v":0},{"$f":"C16+(C16*Questionnaire!$F$47)","v":0},{"$f":"D16+(D16*Questionnaire!$F$47)","v":0},{"$f":"E16+(E16*Questionnaire!$F$47)","v":0},{"$f":"F16+(F16*Questionnaire!$F$47)","v":0},{"$f":"G16+(G16*Questionnaire!$F$47)","v":0},{"$f":"H16+(H16*Questionnaire!$F$47)","v":0},{"$f":"I16+(I16*Questionnaire!$F$47)","v":0},{"$f":"J16+(J16*Questionnaire!$F$47)","v":0},{"$f":"K16+(K16*Questionnaire!$F$47)","v":0},{"$f":"L16+(L16*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$34","v":"coûts des transports"},{"$f":"'12-Mois Cash Flow'!$P$17","v":0},{"$f":"C17+(C17*Questionnaire!$F$47)","v":0},{"$f":"D17+(D17*Questionnaire!$F$47)","v":0},{"$f":"E17+(E17*Questionnaire!$F$47)","v":0},{"$f":"F17+(F17*Questionnaire!$F$47)","v":0},{"$f":"G17+(G17*Questionnaire!$F$47)","v":0},{"$f":"H17+(H17*Questionnaire!$F$47)","v":0},{"$f":"I17+(I17*Questionnaire!$F$47)","v":0},{"$f":"J17+(J17*Questionnaire!$F$47)","v":0},{"$f":"K17+(K17*Questionnaire!$F$47)","v":0},{"$f":"L17+(L17*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$35","v":"coûts des livraisons"},{"$f":"'12-Mois Cash Flow'!$P$18","v":0},{"$f":"C18+(C18*Questionnaire!$F$47)","v":0},{"$f":"D18+(D18*Questionnaire!$F$47)","v":0},{"$f":"E18+(E18*Questionnaire!$F$47)","v":0},{"$f":"F18+(F18*Questionnaire!$F$47)","v":0},{"$f":"G18+(G18*Questionnaire!$F$47)","v":0},{"$f":"H18+(H18*Questionnaire!$F$47)","v":0},{"$f":"I18+(I18*Questionnaire!$F$47)","v":0},{"$f":"J18+(J18*Questionnaire!$F$47)","v":0},{"$f":"K18+(K18*Questionnaire!$F$47)","v":0},{"$f":"L18+(L18*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$36","v":"loyer du local"},{"$f":"'12-Mois Cash Flow'!$P$19","v":0},{"$f":"C19+(C19*Questionnaire!$F$47)","v":0},{"$f":"D19+(D19*Questionnaire!$F$47)","v":0},{"$f":"E19+(E19*Questionnaire!$F$47)","v":0},{"$f":"F19+(F19*Questionnaire!$F$47)","v":0},{"$f":"G19+(G19*Questionnaire!$F$47)","v":0},{"$f":"H19+(H19*Questionnaire!$F$47)","v":0},{"$f":"I19+(I19*Questionnaire!$F$47)","v":0},{"$f":"J19+(J19*Questionnaire!$F$47)","v":0},{"$f":"K19+(K19*Questionnaire!$F$47)","v":0},{"$f":"L19+(L19*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$37","v":"salaires des employés"},{"$f":"'12-Mois Cash Flow'!$P$20","v":0},{"$f":"C20+(C20*Questionnaire!$F$47)","v":0},{"$f":"D20+(D20*Questionnaire!$F$47)","v":0},{"$f":"E20+(E20*Questionnaire!$F$47)","v":0},{"$f":"F20+(F20*Questionnaire!$F$47)","v":0},{"$f":"G20+(G20*Questionnaire!$F$47)","v":0},{"$f":"H20+(H20*Questionnaire!$F$47)","v":0},{"$f":"I20+(I20*Questionnaire!$F$47)","v":0},{"$f":"J20+(J20*Questionnaire!$F$47)","v":0},{"$f":"K20+(K20*Questionnaire!$F$47)","v":0},{"$f":"L20+(L20*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$38","v":"taxes et droits de douane"},{"$f":"'12-Mois Cash Flow'!$P$21","v":0},{"$f":"C21+(C21*Questionnaire!$F$47)","v":0},{"$f":"D21+(D21*Questionnaire!$F$47)","v":0},{"$f":"E21+(E21*Questionnaire!$F$47)","v":0},{"$f":"F21+(F21*Questionnaire!$F$47)","v":0},{"$f":"G21+(G21*Questionnaire!$F$47)","v":0},{"$f":"H21+(H21*Questionnaire!$F$47)","v":0},{"$f":"I21+(I21*Questionnaire!$F$47)","v":0},{"$f":"J21+(J21*Questionnaire!$F$47)","v":0},{"$f":"K21+(K21*Questionnaire!$F$47)","v":0},{"$f":"L21+(L21*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$39","v":"sous-traitants"},{"$f":"'12-Mois Cash Flow'!$P$22","v":0},{"$f":"C22+(C22*Questionnaire!$F$47)","v":0},{"$f":"D22+(D22*Questionnaire!$F$47)","v":0},{"$f":"E22+(E22*Questionnaire!$F$47)","v":0},{"$f":"F22+(F22*Questionnaire!$F$47)","v":0},{"$f":"G22+(G22*Questionnaire!$F$47)","v":0},{"$f":"H22+(H22*Questionnaire!$F$47)","v":0},{"$f":"I22+(I22*Questionnaire!$F$47)","v":0},{"$f":"J22+(J22*Questionnaire!$F$47)","v":0},{"$f":"K22+(K22*Questionnaire!$F$47)","v":0},{"$f":"L22+(L22*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$40","v":"publicité"},{"$f":"'12-Mois Cash Flow'!$P$23","v":0},{"$f":"C23+(C23*Questionnaire!$F$47)","v":0},{"$f":"D23+(D23*Questionnaire!$F$47)","v":0},{"$f":"E23+(E23*Questionnaire!$F$47)","v":0},{"$f":"F23+(F23*Questionnaire!$F$47)","v":0},{"$f":"G23+(G23*Questionnaire!$F$47)","v":0},{"$f":"H23+(H23*Questionnaire!$F$47)","v":0},{"$f":"I23+(I23*Questionnaire!$F$47)","v":0},{"$f":"J23+(J23*Questionnaire!$F$47)","v":0},{"$f":"K23+(K23*Questionnaire!$F$47)","v":0},{"$f":"L23+(L23*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$41","v":"eau, électricité,.."},{"$f":"'12-Mois Cash Flow'!$P$24","v":0},{"$f":"C24+(C24*Questionnaire!$F$47)","v":0},{"$f":"D24+(D24*Questionnaire!$F$47)","v":0},{"$f":"E24+(E24*Questionnaire!$F$47)","v":0},{"$f":"F24+(F24*Questionnaire!$F$47)","v":0},{"$f":"G24+(G24*Questionnaire!$F$47)","v":0},{"$f":"H24+(H24*Questionnaire!$F$47)","v":0},{"$f":"I24+(I24*Questionnaire!$F$47)","v":0},{"$f":"J24+(J24*Questionnaire!$F$47)","v":0},{"$f":"K24+(K24*Questionnaire!$F$47)","v":0},{"$f":"L24+(L24*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$42","v":"frais d'assurances"},{"$f":"'12-Mois Cash Flow'!$P$25","v":0},{"$f":"C25+(C25*Questionnaire!$F$47)","v":0},{"$f":"D25+(D25*Questionnaire!$F$47)","v":0},{"$f":"E25+(E25*Questionnaire!$F$47)","v":0},{"$f":"F25+(F25*Questionnaire!$F$47)","v":0},{"$f":"G25+(G25*Questionnaire!$F$47)","v":0},{"$f":"H25+(H25*Questionnaire!$F$47)","v":0},{"$f":"I25+(I25*Questionnaire!$F$47)","v":0},{"$f":"J25+(J25*Questionnaire!$F$47)","v":0},{"$f":"K25+(K25*Questionnaire!$F$47)","v":0},{"$f":"L25+(L25*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$43","v":"frais de comptabilité "},{"$f":"'12-Mois Cash Flow'!$P$26","v":0},{"$f":"C26+(C26*Questionnaire!$F$47)","v":0},{"$f":"D26+(D26*Questionnaire!$F$47)","v":0},{"$f":"E26+(E26*Questionnaire!$F$47)","v":0},{"$f":"F26+(F26*Questionnaire!$F$47)","v":0},{"$f":"G26+(G26*Questionnaire!$F$47)","v":0},{"$f":"H26+(H26*Questionnaire!$F$47)","v":0},{"$f":"I26+(I26*Questionnaire!$F$47)","v":0},{"$f":"J26+(J26*Questionnaire!$F$47)","v":0},{"$f":"K26+(K26*Questionnaire!$F$47)","v":0},{"$f":"L26+(L26*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$44","v":"autres"},{"$f":"'12-Mois Cash Flow'!$P$27","v":0},{"$f":"C27+(C27*Questionnaire!$F$47)","v":0},{"$f":"D27+(D27*Questionnaire!$F$47)","v":0},{"$f":"E27+(E27*Questionnaire!$F$47)","v":0},{"$f":"F27+(F27*Questionnaire!$F$47)","v":0},{"$f":"G27+(G27*Questionnaire!$F$47)","v":0},{"$f":"H27+(H27*Questionnaire!$F$47)","v":0},{"$f":"I27+(I27*Questionnaire!$F$47)","v":0},{"$f":"J27+(J27*Questionnaire!$F$47)","v":0},{"$f":"K27+(K27*Questionnaire!$F$47)","v":0},{"$f":"L27+(L27*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$45","v":"autres"},{"$f":"'12-Mois Cash Flow'!$P$28","v":0},{"$f":"C28+(C28*Questionnaire!$F$47)","v":0},{"$f":"D28+(D28*Questionnaire!$F$47)","v":0},{"$f":"E28+(E28*Questionnaire!$F$47)","v":0},{"$f":"F28+(F28*Questionnaire!$F$47)","v":0},{"$f":"G28+(G28*Questionnaire!$F$47)","v":0},{"$f":"H28+(H28*Questionnaire!$F$47)","v":0},{"$f":"I28+(I28*Questionnaire!$F$47)","v":0},{"$f":"J28+(J28*Questionnaire!$F$47)","v":0},{"$f":"K28+(K28*Questionnaire!$F$47)","v":0},{"$f":"L28+(L28*Questionnaire!$F$47)","v":0}]
[null,"SOUS-TOTAL",{"$f":"SUM(C13:C28)","v":0},{"$f":"SUM(D13:D28)","v":0},{"$f":"SUM(E13:E28)","v":0},0,0,0,0,0,0,0,0]
[null,"Prêt mensuel à rembourser à la 1ère banque",{"$f":"'12-Mois Cash Flow'!$P$30","v":0},{"$f":"IF('1er Remboursement'!Loan_Years<2,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<3,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<4,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<5,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<6,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<7,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<8,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<9,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<10,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<11,\"0\",$C$30)","v":"0"}]
[null,"Prêt mensuel à rembourser à la 2ème banque",{"$f":"'12-Mois Cash Flow'!$P$31","v":0},{"$f":"IF('2ème Remboursement'!Loan_Years<2,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<3,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<4,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<5,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<6,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<7,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<8,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<9,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<10,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<11,\"0\",$C$31)","v":"0"}]
[null,{"$f":"Récapitulatif!$B$22","v":"Epargnes pour la maintenance et la réparation:"},{"$f":"'12-Mois Cash Flow'!$P$32","v":0},{"$f":"C32","v":0},0,0,{"$f":"F32","v":0},0,0,0,0,0,0]
[null,{"$f":"Récapitulatif!$B$23","v":"Epargnes mensuelles pour la maintenance PV et sa réparation:"},{"$f":"'12-Mois Cash Flow'!$P$33","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"MONTANT TOTAL PAYÉ",{"$f":"SUM(C29:C33)","v":0},{"$f":"SUM(D29:D33)","v":0},{"$f":"SUM(E29:E33)","v":0},{"$f":"SUM(F29:F33)","v":0},{"$f":"SUM(G29:G33)","v":0},0,0,0,0,0,0]
[null,"Montant des liquidités (fin du mois)",{"$f":"C10-C34","v":0},{"$f":"(D10-D34)","v":0},{"$f":"(E10-E34)","v":0},{"$f":"(F10-F34)","v":0},{"$f":"(G10-G34)","v":0},0,0,0,0,0,0]
[]
[null,"10-Ans Cash Flow"]
[null,{"$f":"Questionnaire!E17","v":"Scenario: Stable"},"Nom de l'entreprise:",null,{"$f":"Questionnaire!$E$5","v":0},{"$nulls":4},"Début de l'année fiscale:",{"$f":"Questionnaire!$F$108","v":"00:00:00"}]
[null,null,"An 1","An 2","An 3","An 4","An 5","An 6","An 7","An 8","An 9","An 10","An 11","An 12"]
[null,"STABLE: CASH DISPONIBLE (début de l'année)",{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},{"$f":"C71","v":0},{"$f":"D71","v":0},{"$f":"E71","v":0},{"$f":"F71","v":0},0,0,0,0,0,0,0]
[]
[null,"Rentrée d'argent"]
[null,"Ventes au comptant",{"$f":"'12-Mois Cash Flow'!Q46","v":0},{"$f":"C43","v":0},{"$f":"D43","v":0},{"$f":"E43","v":0},{"$f":"F43","v":0},{"$f":"G43","v":0},0,0,0,0,0]
[null,"Autres ventes"]
[null,"Rentrée d'argent totale",{"$f":"SUM(C43:C43)","v":0},{"$f":"SUM(D43:D43)","v":0},{"$f":"SUM(E43:E43)","v":0},{"$f":"SUM(F43:F43)","v":0},{"$f":"SUM(G43:G43)","v":0},{"$f":"SUM(H43:H43)","v":0},{"$f":"SUM(I43:I43)","v":0},{"$f":"SUM(J43:J43)","v":0},{"$f":"SUM(K43:K43)","v":0},{"$f":"SUM(L43:L43)","v":0},{"$f":"SUM(M43:M43)","v":0}]
[null,"Argent total disponible (avant prélèvement)",{"$f":"(C40+C45)","v":0},{"$f":"(D40+D45)","v":0},{"$f":"(E40+E45)","v":0},{"$f":"(F40+F45)","v":0},{"$f":"(G40+G45)","v":0},{"$f":"(H40+H45)","v":0},{"$f":"(I40+I45)","v":0},{"$f":"(J40+J45)","v":0},{"$f":"(K40+K45)","v":0},{"$f":"(L40+L45)","v":0},{"$f":"(M40+M45)","v":0}]
[]
[null,"MONTANT PAYÉ"]
[null,"dépense initiale",{"$f":"'12-Mois Cash Flow'!$P$13","v":0},0]
[null,"matériels",{"$f":"'12-Mois Cash Flow'!$P$14","v":0},{"$f":"C50+(C50*Questionnaire!$F$47)","v":0},{"$f":"D50+(D50*Questionnaire!$F$47)","v":0},{"$f":"E50+(E50*Questionnaire!$F$47)","v":0},{"$f":"F50+(F50*Questionnaire!$F$47)","v":0},{"$f":"G50+(G50*Questionnaire!$F$47)","v":0},{"$f":"H50+(H50*Questionnaire!$F$47)","v":0},{"$f":"I50+(I50*Questionnaire!$F$47)","v":0},{"$f":"J50+(J50*Questionnaire!$F$47)","v":0},{"$f":"K50+(K50*Questionnaire!$F$47)","v":0},{"$f":"L50+(L50*Questionnaire!$F$47)","v":0}]
[null,"consommables",{"$f":"'12-Mois Cash Flow'!$P$15","v":0},{"$f":"C51+(C51*Questionnaire!$F$47)","v":0},{"$f":"D51+(D51*Questionnaire!$F$47)","v":0},{"$f":"E51+(E51*Questionnaire!$F$47)","v":0},{"$f":"F51+(F51*Questionnaire!$F$47)","v":0},{"$f":"G51+(G51*Questionnaire!$F$47)","v":0},{"$f":"H51+(H51*Questionnaire!$F$47)","v":0},{"$f":"I51+(I51*Questionnaire!$F$47)","v":0},{"$f":"J51+(J51*Questionnaire!$F$47)","v":0},{"$f":"K51+(K51*Questionnaire!$F$47)","v":0},{"$f":"L51+(L51*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$33","v":"prix du téléphone professionnel"},{"$f":"'12-Mois Cash Flow'!$P$16","v":0},{"$f":"C52+(C52*Questionnaire!$F$47)","v":0},{"$f":"D52+(D52*Questionnaire!$F$47)","v":0},{"$f":"E52+(E52*Questionnaire!$F$47)","v":0},{"$f":"F52+(F52*Questionnaire!$F$47)","v":0},{"$f":"G52+(G52*Questionnaire!$F$47)","v":0},{"$f":"H52+(H52*Questionnaire!$F$47)","v":0},{"$f":"I52+(I52*Questionnaire!$F$47)","v":0},{"$f":"J52+(J52*Questionnaire!$F$47)","v":0},{"$f":"K52+(K52*Questionnaire!$F$47)","v":0},{"$f":"L52+(L52*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$34","v":"coûts des transports"},{"$f":"'12-Mois Cash Flow'!$P$17","v":0},{"$f":"C53+(C53*Questionnaire!$F$47)","v":0},{"$f":"D53+(D53*Questionnaire!$F$47)","v":0},{"$f":"E53+(E53*Questionnaire!$F$47)","v":0},{"$f":"F53+(F53*Questionnaire!$F$47)","v":0},{"$f":"G53+(G53*Questionnaire!$F$47)","v":0},{"$f":"H53+(H53*Questionnaire!$F$47)","v":0},{"$f":"I53+(I53*Questionnaire!$F$47)","v":0},{"$f":"J53+(J53*Questionnaire!$F$47)","v":0},{"$f":"K53+(K53*Questionnaire!$F$47)","v":0},{"$f":"L53+(L53*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$35","v":"coûts des livraisons"},{"$f":"'12-Mois Cash Flow'!$P$18","v":0},{"$f":"C54+(C54*Questionnaire!$F$47)","v":0},{"$f":"D54+(D54*Questionnaire!$F$47)","v":0},{"$f":"E54+(E54*Questionnaire!$F$47)","v":0},{"$f":"F54+(F54*Questionnaire!$F$47)","v":0},{"$f":"G54+(G54*Questionnaire!$F$47)","v":0},{"$f":"H54+(H54*Questionnaire!$F$47)","v":0},{"$f":"I54+(I54*Questionnaire!$F$47)","v":0},{"$f":"J54+(J54*Questionnaire!$F$47)","v":0},{"$f":"K54+(K54*Questionnaire!$F$47)","v":0},{"$f":"L54+(L54*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$36","v":"loyer du local"},{"$f":"'12-Mois Cash Flow'!$P$19","v":0},{"$f":"C55+(C55*Questionnaire!$F$47)","v":0},{"$f":"D55+(D55*Questionnaire!$F$47)","v":0},{"$f":"E55+(E55*Questionnaire!$F$47)","v":0},{"$f":"F55+(F55*Questionnaire!$F$47)","v":0},{"$f":"G55+(G55*Questionnaire!$F$47)","v":0},{"$f":"H55+(H55*Questionnaire!$F$47)","v":0},{"$f":"I55+(I55*Questionnaire!$F$47)","v":0},{"$f":"J55+(J55*Questionnaire!$F$47)","v":0},{"$f":"K55+(K55*Questionnaire!$F$47)","v":0},{"$f":"L55+(L55*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$37","v":"salaires des employés"},{"$f":"'12-Mois Cash Flow'!$P$20","v":0},{"$f":"C56+(C56*Questionnaire!$F$47)","v":0},{"$f":"D56+(D56*Questionnaire!$F$47)","v":0},{"$f":"E56+(E56*Questionnaire!$F$47)","v":0},{"$f":"F56+(F56*Questionnaire!$F$47)","v":0},{"$f":"G56+(G56*Questionnaire!$F$47)","v":0},{"$f":"H56+(H56*Questionnaire!$F$47)","v":0},{"$f":"I56+(I56*Questionnaire!$F$47)","v":0},{"$f":"J56+(J56*Questionnaire!$F$47)","v":0},{"$f":"K56+(K56*Questionnaire!$F$47)","v":0},{"$f":"L56+(L56*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$38","v":"taxes et droits de douane"},{"$f":"'12-Mois Cash Flow'!$P$21","v":0},{"$f":"C57+(C57*Questionnaire!$F$47)","v":0},{"$f":"D57+(D57*Questionnaire!$F$47)","v":0},{"$f":"E57+(E57*Questionnaire!$F$47)","v":0},{"$f":"F57+(F57*Questionnaire!$F$47)","v":0},{"$f":"G57+(G57*Questionnaire!$F$47)","v":0},{"$f":"H57+(H57*Questionnaire!$F$47)","v":0},{"$f":"I57+(I57*Questionnaire!$F$47)","v":0},{"$f":"J57+(J57*Questionnaire!$F$47)","v":0},{"$f":"K57+(K57*Questionnaire!$F$47)","v":0},{"$f":"L57+(L57*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$39","v":"sous-traitants"},{"$f":"'12-Mois Cash Flow'!$P$22","v":0},{"$f":"C58+(C58*Questionnaire!$F$47)","v":0},{"$f":"D58+(D58*Questionnaire!$F$47)","v":0},{"$f":"E58+(E58*Questionnaire!$F$47)","v":0},{"$f":"F58+(F58*Questionnaire!$F$47)","v":0},{"$f":"G58+(G58*Questionnaire!$F$47)","v":0},{"$f":"H58+(H58*Questionnaire!$F$47)","v":0},{"$f":"I58+(I58*Questionnaire!$F$47)","v":0},{"$f":"J58+(J58*Questionnaire!$F$47)","v":0},{"$f":"K58+(K58*Questionnaire!$F$47)","v":0},{"$f":"L58+(L58*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$40","v":"publicité"},{"$f":"'12-Mois Cash Flow'!$P$23","v":0},{"$f":"C59+(C59*Questionnaire!$F$47)","v":0},{"$f":"D59+(D59*Questionnaire!$F$47)","v":0},{"$f":"E59+(E59*Questionnaire!$F$47)","v":0},{"$f":"F59+(F59*Questionnaire!$F$47)","v":0},{"$f":"G59+(G59*Questionnaire!$F$47)","v":0},{"$f":"H59+(H59*Questionnaire!$F$47)","v":0},{"$f":"I59+(I59*Questionnaire!$F$47)","v":0},{"$f":"J59+(J59*Questionnaire!$F$47)","v":0},{"$f":"K59+(K59*Questionnaire!$F$47)","v":0},{"$f":"L59+(L59*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$41","v":"eau, électricité,.."},{"$f":"'12-Mois Cash Flow'!$P$24","v":0},{"$f":"C60+(C60*Questionnaire!$F$47)","v":0},{"$f":"D60+(D60*Questionnaire!$F$47)","v":0},{"$f":"E60+(E60*Questionnaire!$F$47)","v":0},{"$f":"F60+(F60*Questionnaire!$F$47)","v":0},{"$f":"G60+(G60*Questionnaire!$F$47)","v":0},{"$f":"H60+(H60*Questionnaire!$F$47)","v":0},{"$f":"I60+(I60*Questionnaire!$F$47)","v":0},{"$f":"J60+(J60*Questionnaire!$F$47)","v":0},{"$f":"K60+(K60*Questionnaire!$F$47)","v":0},{"$f":"L60+(L60*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$42","v":"frais d'assurances"},{"$f":"'12-Mois Cash Flow'!$P$25","v":0},{"$f":"C61+(C61*Questionnaire!$F$47)","v":0},{"$f":"D61+(D61*Questionnaire!$F$47)","v":0},{"$f":"E61+(E61*Questionnaire!$F$47)","v":0},{"$f":"F61+(F61*Questionnaire!$F$47)","v":0},{"$f":"G61+(G61*Questionnaire!$F$47)","v":0},{"$f":"H61+(H61*Questionnaire!$F$47)","v":0},{"$f":"I61+(I61*Questionnaire!$F$47)","v":0},{"$f":"J61+(J61*Questionnaire!$F$47)","v":0},{"$f":"K61+(K61*Questionnaire!$F$47)","v":0},{"$f":"L61+(L61*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$43","v":"frais de comptabilité "},{"$f":"'12-Mois Cash Flow'!$P$26","v":0},{"$f":"C62+(C62*Questionnaire!$F$47)","v":0},{"$f":"D62+(D62*Questionnaire!$F$47)","v":0},{"$f":"E62+(E62*Questionnaire!$F$47)","v":0},{"$f":"F62+(F62*Questionnaire!$F$47)","v":0},{"$f":"G62+(G62*Questionnaire!$F$47)","v":0},{"$f":"H62+(H62*Questionnaire!$F$47)","v":0},{"$f":"I62+(I62*Questionnaire!$F$47)","v":0},{"$f":"J62+(J62*Questionnaire!$F$47)","v":0},{"$f":"K62+(K62*Questionnaire!$F$47)","v":0},{"$f":"L62+(L62*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$44","v":"autres"},{"$f":"'12-Mois Cash Flow'!$P$27","v":0},{"$f":"C63+(C63*Questionnaire!$F$47)","v":0},{"$f":"D63+(D63*Questionnaire!$F$47)","v":0},{"$f":"E63+(E63*Questionnaire!$F$47)","v":0},{"$f":"F63+(F63*Questionnaire!$F$47)","v":0},{"$f":"G63+(G63*Questionnaire!$F$47)","v":0},{"$f":"H63+(H63*Questionnaire!$F$47)","v":0},{"$f":"I63+(I63*Questionnaire!$F$47)","v":0},{"$f":"J63+(J63*Questionnaire!$F$47)","v":0},{"$f":"K63+(K63*Questionnaire!$F$47)","v":0},{"$f":"L63+(L63*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$45","v":"autres"},{"$f":"'12-Mois Cash Flow'!$P$28","v":0},{"$f":"C64+(C64*Questionnaire!$F$47)","v":0},{"$f":"D64+(D64*Questionnaire!$F$47)","v":0},{"$f":"E64+(E64*Questionnaire!$F$47)","v":0},{"$f":"F64+(F64*Questionnaire!$F$47)","v":0},{"$f":"G64+(G64*Questionnaire!$F$47)","v":0},{"$f":"H64+(H64*Questionnaire!$F$47)","v":0},{"$f":"I64+(I64*Questionnaire!$F$47)","v":0},{"$f":"J64+(J64*Questionnaire!$F$47)","v":0},{"$f":"K64+(K64*Questionnaire!$F$47)","v":0},{"$f":"L64+(L64*Questionnaire!$F$47)","v":0}]
[null,"SOUS-TOTAL",{"$f":"SUM(C49:C64)","v":0},{"$f":"SUM(D49:D64)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Prêt mensuel à rembourser à la 1ère banque",{"$f":"'12-Mois Cash Flow'!$P$30","v":0},{"$f":"IF('1er Remboursement'!Loan_Years<2,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<3,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<4,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<5,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<6,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<7,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<8,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<9,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<10,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<11,\"0\",$C$30)","v":"0"}]
[null,"Prêt mensuel à rembourser à la 2ème banque",{"$f":"'12-Mois Cash Flow'!$P$31","v":0},{"$f":"IF('2ème Remboursement'!Loan_Years<2,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<3,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<4,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<5,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<6,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<7,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<8,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<9,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<10,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<11,\"0\",$C$31)","v":"0"}]
[null,{"$f":"Récapitulatif!$B$22","v":"Epargnes pour la maintenance et la réparation:"},{"$f":"'12-Mois Cash Flow'!$P$32","v":0},{"$f":"C68","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"Récapitulatif!$B$23","v":"Epargnes mensuelles pour la maintenance PV et sa réparation:"},{"$f":"'12-Mois Cash Flow'!$P$33","v":0},{"$f":"C69","v":0},0,0,0,0,0,0,0,0,0]
[null,"MONTANT TOTAL PAYÉ",{"$f":"SUM(C65:C69)","v":0},{"$f":"SUM(D65:D69)","v":0},{"$f":"SUM(E65:E69)","v":0},{"$f":"SUM(F65:F69)","v":0},{"$f":"SUM(G65:G69)","v":0},{"$f":"SUM(H65:H69)","v":0},{"$f":"SUM(I65:I69)","v":0},{"$f":"SUM(J65:J69)","v":0},{"$f":"SUM(K65:K69)","v":0},{"$f":"SUM(L65:L69)","v":0},{"$f":"SUM(M65:M69)","v":0}]
[null,"Montant des liquidités (fin du mois)",{"$f":"C46-C70","v":0},{"$f":"(D46-D70)","v":0},{"$f":"(E46-E70)","v":0},{"$f":"(F46-F70)","v":0},{"$f":"(G46-G70)","v":0},{"$f":"(H46-H70)","v":0},{"$f":"(I46-I70)","v":0},{"$f":"(J46-J70)","v":0},{"$f":"(K46-K70)","v":0},{"$f":"(L46-L70)","v":0},{"$f":"(M46-M70)","v":0}]
[]
[null,"10-Ans Cash Flow"]
[null,{"$f":"Questionnaire!E18","v":"Scenario: Weak"},"Nom de l'entreprise:",null,{"$f":"Questionnaire!$E$5","v":0},{"$nulls":4},"Début de l'année fiscale:",{"$f":"Questionnaire!$F$108","v":"00:00:00"}]
[null,null,"An 1","An 2","An 3","An 4","An 5","An 6","An 7","An 8","An 9","An 10","An 11","An 12"]
[null,"WEAK: CASH DISPONIBLE (début de l'année)",{"$f":"Questionnaire!$F$100+Questionnaire!$F$101","v":0},{"$f":"C107","v":0},{"$f":"D107","v":0},{"$f":"E107","v":0},{"$f":"F107","v":0},0,0,0,0,0,0,0]
[]
[null,"Rentrée d'argent"]
[null,"Ventes au comptant",{"$f":"'12-Mois Cash Flow'!Q83","v":0},{"$f":"C79","v":0},{"$f":"D79","v":0},{"$f":"E79","v":0},{"$f":"F79","v":0},{"$f":"G79","v":0},0,0,0,0,0]
[null,"Autres ventes"]
[null,"Rentrée d'argent totale",{"$f":"SUM(C79:C79)","v":0},{"$f":"SUM(D79:D79)","v":0},{"$f":"SUM(E79:E79)","v":0},{"$f":"SUM(F79:F79)","v":0},{"$f":"SUM(G79:G79)","v":0},{"$f":"SUM(H79:H79)","v":0},{"$f":"SUM(I79:I79)","v":0},{"$f":"SUM(J79:J79)","v":0},{"$f":"SUM(K79:K79)","v":0},{"$f":"SUM(L79:L79)","v":0},{"$f":"SUM(M79:M79)","v":0}]
[null,"Argent total disponible (avant prélèvement)",{"$f":"(C76+C81)","v":0},{"$f":"(D76+D81)","v":0},{"$f":"(E76+E81)","v":0},{"$f":"(F76+F81)","v":0},{"$f":"(G76+G81)","v":0},{"$f":"(H76+H81)","v":0},{"$f":"(I76+I81)","v":0},{"$f":"(J76+J81)","v":0},{"$f":"(K76+K81)","v":0},{"$f":"(L76+L81)","v":0},{"$f":"(M76+M81)","v":0}]
[]
[null,"MONTANT PAYÉ"]
[null,"dépense initiale",{"$f":"'12-Mois Cash Flow'!$P$13","v":0},0]
[null,"matériels",{"$f":"'12-Mois Cash Flow'!$P$14","v":0},{"$f":"C86+(C86*Questionnaire!$F$47)","v":0},{"$f":"D86+(D86*Questionnaire!$F$47)","v":0},{"$f":"E86+(E86*Questionnaire!$F$47)","v":0},{"$f":"F86+(F86*Questionnaire!$F$47)","v":0},{"$f":"G86+(G86*Questionnaire!$F$47)","v":0},{"$f":"H86+(H86*Questionnaire!$F$47)","v":0},{"$f":"I86+(I86*Questionnaire!$F$47)","v":0},{"$f":"J86+(J86*Questionnaire!$F$47)","v":0},{"$f":"K86+(K86*Questionnaire!$F$47)","v":0},{"$f":"L86+(L86*Questionnaire!$F$47)","v":0}]
[null,"consommables",{"$f":"'12-Mois Cash Flow'!$P$15","v":0},{"$f":"C87+(C87*Questionnaire!$F$47)","v":0},{"$f":"D87+(D87*Questionnaire!$F$47)","v":0},{"$f":"E87+(E87*Questionnaire!$F$47)","v":0},{"$f":"F87+(F87*Questionnaire!$F$47)","v":0},{"$f":"G87+(G87*Questionnaire!$F$47)","v":0},{"$f":"H87+(H87*Questionnaire!$F$47)","v":0},{"$f":"I87+(I87*Questionnaire!$F$47)","v":0},{"$f":"J87+(J87*Questionnaire!$F$47)","v":0},{"$f":"K87+(K87*Questionnaire!$F$47)","v":0},{"$f":"L87+(L87*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$33","v":"prix du téléphone professionnel"},{"$f":"'12-Mois Cash Flow'!$P$16","v":0},{"$f":"C88+(C88*Questionnaire!$F$47)","v":0},{"$f":"D88+(D88*Questionnaire!$F$47)","v":0},{"$f":"E88+(E88*Questionnaire!$F$47)","v":0},{"$f":"F88+(F88*Questionnaire!$F$47)","v":0},{"$f":"G88+(G88*Questionnaire!$F$47)","v":0},{"$f":"H88+(H88*Questionnaire!$F$47)","v":0},{"$f":"I88+(I88*Questionnaire!$F$47)","v":0},{"$f":"J88+(J88*Questionnaire!$F$47)","v":0},{"$f":"K88+(K88*Questionnaire!$F$47)","v":0},{"$f":"L88+(L88*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$34","v":"coûts des transports"},{"$f":"'12-Mois Cash Flow'!$P$17","v":0},{"$f":"C89+(C89*Questionnaire!$F$47)","v":0},{"$f":"D89+(D89*Questionnaire!$F$47)","v":0},{"$f":"E89+(E89*Questionnaire!$F$47)","v":0},{"$f":"F89+(F89*Questionnaire!$F$47)","v":0},{"$f":"G89+(G89*Questionnaire!$F$47)","v":0},{"$f":"H89+(H89*Questionnaire!$F$47)","v":0},{"$f":"I89+(I89*Questionnaire!$F$47)","v":0},{"$f":"J89+(J89*Questionnaire!$F$47)","v":0},{"$f":"K89+(K89*Questionnaire!$F$47)","v":0},{"$f":"L89+(L89*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$35","v":"coûts des livraisons"},{"$f":"'12-Mois Cash Flow'!$P$18","v":0},{"$f":"C90+(C90*Questionnaire!$F$47)","v":0},{"$f":"D90+(D90*Questionnaire!$F$47)","v":0},{"$f":"E90+(E90*Questionnaire!$F$47)","v":0},{"$f":"F90+(F90*Questionnaire!$F$47)","v":0},{"$f":"G90+(G90*Questionnaire!$F$47)","v":0},{"$f":"H90+(H90*Questionnaire!$F$47)","v":0},{"$f":"I90+(I90*Questionnaire!$F$47)","v":0},{"$f":"J90+(J90*Questionnaire!$F$47)","v":0},{"$f":"K90+(K90*Questionnaire!$F$47)","v":0},{"$f":"L90+(L90*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$36","v":"loyer du local"},{"$f":"'12-Mois Cash Flow'!$P$19","v":0},{"$f":"C91+(C91*Questionnaire!$F$47)","v":0},{"$f":"D91+(D91*Questionnaire!$F$47)","v":0},{"$f":"E91+(E91*Questionnaire!$F$47)","v":0},{"$f":"F91+(F91*Questionnaire!$F$47)","v":0},{"$f":"G91+(G91*Questionnaire!$F$47)","v":0},{"$f":"H91+(H91*Questionnaire!$F$47)","v":0},{"$f":"I91+(I91*Questionnaire!$F$47)","v":0},{"$f":"J91+(J91*Questionnaire!$F$47)","v":0},{"$f":"K91+(K91*Questionnaire!$F$47)","v":0},{"$f":"L91+(L91*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$37","v":"salaires des employés"},{"$f":"'12-Mois Cash Flow'!$P$20","v":0},{"$f":"C92+(C92*Questionnaire!$F$47)","v":0},{"$f":"D92+(D92*Questionnaire!$F$47)","v":0},{"$f":"E92+(E92*Questionnaire!$F$47)","v":0},{"$f":"F92+(F92*Questionnaire!$F$47)","v":0},{"$f":"G92+(G92*Questionnaire!$F$47)","v":0},{"$f":"H92+(H92*Questionnaire!$F$47)","v":0},{"$f":"I92+(I92*Questionnaire!$F$47)","v":0},{"$f":"J92+(J92*Questionnaire!$F$47)","v":0},{"$f":"K92+(K92*Questionnaire!$F$47)","v":0},{"$f":"L92+(L92*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$38","v":"taxes et droits de douane"},{"$f":"'12-Mois Cash Flow'!$P$21","v":0},{"$f":"C93+(C93*Questionnaire!$F$47)","v":0},{"$f":"D93+(D93*Questionnaire!$F$47)","v":0},{"$f":"E93+(E93*Questionnaire!$F$47)","v":0},{"$f":"F93+(F93*Questionnaire!$F$47)","v":0},{"$f":"G93+(G93*Questionnaire!$F$47)","v":0},{"$f":"H93+(H93*Questionnaire!$F$47)","v":0},{"$f":"I93+(I93*Questionnaire!$F$47)","v":0},{"$f":"J93+(J93*Questionnaire!$F$47)","v":0},{"$f":"K93+(K93*Questionnaire!$F$47)","v":0},{"$f":"L93+(L93*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$39","v":"sous-traitants"},{"$f":"'12-Mois Cash Flow'!$P$22","v":0},{"$f":"C94+(C94*Questionnaire!$F$47)","v":0},{"$f":"D94+(D94*Questionnaire!$F$47)","v":0},{"$f":"E94+(E94*Questionnaire!$F$47)","v":0},{"$f":"F94+(F94*Questionnaire!$F$47)","v":0},{"$f":"G94+(G94*Questionnaire!$F$47)","v":0},{"$f":"H94+(H94*Questionnaire!$F$47)","v":0},{"$f":"I94+(I94*Questionnaire!$F$47)","v":0},{"$f":"J94+(J94*Questionnaire!$F$47)","v":0},{"$f":"K94+(K94*Questionnaire!$F$47)","v":0},{"$f":"L94+(L94*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$40","v":"publicité"},{"$f":"'12-Mois Cash Flow'!$P$23","v":0},{"$f":"C95+(C95*Questionnaire!$F$47)","v":0},{"$f":"D95+(D95*Questionnaire!$F$47)","v":0},{"$f":"E95+(E95*Questionnaire!$F$47)","v":0},{"$f":"F95+(F95*Questionnaire!$F$47)","v":0},{"$f":"G95+(G95*Questionnaire!$F$47)","v":0},{"$f":"H95+(H95*Questionnaire!$F$47)","v":0},{"$f":"I95+(I95*Questionnaire!$F$47)","v":0},{"$f":"J95+(J95*Questionnaire!$F$47)","v":0},{"$f":"K95+(K95*Questionnaire!$F$47)","v":0},{"$f":"L95+(L95*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$41","v":"eau, électricité,.."},{"$f":"'12-Mois Cash Flow'!$P$24","v":0},{"$f":"C96+(C96*Questionnaire!$F$47)","v":0},{"$f":"D96+(D96*Questionnaire!$F$47)","v":0},{"$f":"E96+(E96*Questionnaire!$F$47)","v":0},{"$f":"F96+(F96*Questionnaire!$F$47)","v":0},{"$f":"G96+(G96*Questionnaire!$F$47)","v":0},{"$f":"H96+(H96*Questionnaire!$F$47)","v":0},{"$f":"I96+(I96*Questionnaire!$F$47)","v":0},{"$f":"J96+(J96*Questionnaire!$F$47)","v":0},{"$f":"K96+(K96*Questionnaire!$F$47)","v":0},{"$f":"L96+(L96*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$42","v":"frais d'assurances"},{"$f":"'12-Mois Cash Flow'!$P$25","v":0},{"$f":"C97+(C97*Questionnaire!$F$47)","v":0},{"$f":"D97+(D97*Questionnaire!$F$47)","v":0},{"$f":"E97+(E97*Questionnaire!$F$47)","v":0},{"$f":"F97+(F97*Questionnaire!$F$47)","v":0},{"$f":"G97+(G97*Questionnaire!$F$47)","v":0},{"$f":"H97+(H97*Questionnaire!$F$47)","v":0},{"$f":"I97+(I97*Questionnaire!$F$47)","v":0},{"$f":"J97+(J97*Questionnaire!$F$47)","v":0},{"$f":"K97+(K97*Questionnaire!$F$47)","v":0},{"$f":"L97+(L97*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$43","v":"frais de comptabilité "},{"$f":"'12-Mois Cash Flow'!$P$26","v":0},{"$f":"C98+(C98*Questionnaire!$F$47)","v":0},{"$f":"D98+(D98*Questionnaire!$F$47)","v":0},{"$f":"E98+(E98*Questionnaire!$F$47)","v":0},{"$f":"F98+(F98*Questionnaire!$F$47)","v":0},{"$f":"G98+(G98*Questionnaire!$F$47)","v":0},{"$f":"H98+(H98*Questionnaire!$F$47)","v":0},{"$f":"I98+(I98*Questionnaire!$F$47)","v":0},{"$f":"J98+(J98*Questionnaire!$F$47)","v":0},{"$f":"K98+(K98*Questionnaire!$F$47)","v":0},{"$f":"L98+(L98*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$44","v":"autres"},{"$f":"'12-Mois Cash Flow'!$P$27","v":0},{"$f":"C99+(C99*Questionnaire!$F$47)","v":0},{"$f":"D99+(D99*Questionnaire!$F$47)","v":0},{"$f":"E99+(E99*Questionnaire!$F$47)","v":0},{"$f":"F99+(F99*Questionnaire!$F$47)","v":0},{"$f":"G99+(G99*Questionnaire!$F$47)","v":0},{"$f":"H99+(H99*Questionnaire!$F$47)","v":0},{"$f":"I99+(I99*Questionnaire!$F$47)","v":0},{"$f":"J99+(J99*Questionnaire!$F$47)","v":0},{"$f":"K99+(K99*Questionnaire!$F$47)","v":0},{"$f":"L99+(L99*Questionnaire!$F$47)","v":0}]
[null,{"$f":"Questionnaire!$E$45","v":"autres"},{"$f":"'12-Mois Cash Flow'!$P$28","v":0},{"$f":"C100+(C100*Questionnaire!$F$47)","v":0},{"$f":"D100+(D100*Questionnaire!$F$47)","v":0},{"$f":"E100+(E100*Questionnaire!$F$47)","v":0},{"$f":"F100+(F100*Questionnaire!$F$47)","v":0},{"$f":"G100+(G100*Questionnaire!$F$47)","v":0},{"$f":"H100+(H100*Questionnaire!$F$47)","v":0},{"$f":"I100+(I100*Questionnaire!$F$47)","v":0},{"$f":"J100+(J100*Questionnaire!$F$47)","v":0},{"$f":"K100+(K100*Questionnaire!$F$47)","v":0},{"$f":"L100+(L100*Questionnaire!$F$47)","v":0}]
[null,"SOUS-TOTAL",{"$f":"SUM(C85:C100)","v":0},{"$f":"SUM(D85:D100)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Prêt mensuel à rembourser à la 1ère banque",{"$f":"'12-Mois Cash Flow'!$P$30","v":0},{"$f":"IF('1er Remboursement'!Loan_Years<2,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<3,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<4,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<5,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<6,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<7,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<8,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<9,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<10,\"0\",$C$30)","v":"0"},{"$f":"IF('1er Remboursement'!Loan_Years<11,\"0\",$C$30)","v":"0"}]
[null,"Prêt mensuel à rembourser à la 2ème banque",{"$f":"'12-Mois Cash Flow'!$P$31","v":0},{"$f":"IF('2ème Remboursement'!Loan_Years<2,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<3,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<4,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<5,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<6,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<7,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<8,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<9,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<10,\"0\",$C$31)","v":"0"},{"$f":"IF('2ème Remboursement'!Loan_Years<11,\"0\",$C$31)","v":"0"}]
[null,{"$f":"Récapitulatif!$B$22","v":"Epargnes pour la maintenance et la réparation:"},{"$f":"'12-Mois Cash Flow'!$P$32","v":0},{"$f":"C104","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"Récapitulatif!$B$23","v":"Epargnes mensuelles pour la maintenance PV et sa réparation:"},{"$f":"'12-Mois Cash Flow'!$P$33","v":0},{"$f":"C105","v":0},0,0,0,0,0,0,0,0,0]
[null,"MONTANT TOTAL PAYÉ",{"$f":"SUM(C101:C105)","v":0},{"$f":"SUM(D101:D105)","v":0},{"$f":"SUM(E101:E105)","v":0},{"$f":"SUM(F101:F105)","v":0},{"$f":"SUM(G101:G105)","v":0},{"$f":"SUM(H101:H105)","v":0},{"$f":"SUM(I101:I105)","v":0},{"$f":"SUM(J101:J105)","v":0},{"$f":"SUM(K101:K105)","v":0},{"$f":"SUM(L101:L105)","v":0},{"$f":"SUM(M101:M105)","v":0}]
[null,"Montant des liquidités (fin du mois)",{"$f":"C82-C106","v":0},{"$f":"(D82-D106)","v":0},{"$f":"(E82-E106)","v":0},{"$f":"(F82-F106)","v":0},{"$f":"(G82-G106)","v":0},{"$f":"(H82-H106)","v":0},{"$f":"(I82-I106)","v":0},{"$f":"(J82-J106)","v":0},{"$f":"(K82-K106)","v":0},{"$f":"(L82-L106)","v":0},{"$f":"(M82-M106)","v":0}]

{"sheet":"Calcul Énergétique","index":7,"n_rows":27,"n_cols":38,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[21,0,21,5]]}
["Calcul Énergétique"]
[]
["Type d'appareils","Wattage (W)","Qt","Hrs/jour","AC?","Wh/jour"]
[{"$f":"Questionnaire!F50","v":0},{"$f":"Questionnaire!F52","v":0},{"$f":"Questionnaire!F55","v":0},{"$f":"Questionnaire!F54","v":0},{"$f":"IF(Questionnaire!F53=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B4*C4*D4)","v":0}]
[{"$f":"Questionnaire!F58","v":0},{"$f":"Questionnaire!F60","v":0},{"$f":"Questionnaire!F63","v":0},{"$f":"Questionnaire!F62","v":0},{"$f":"IF(Questionnaire!F61=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B5*C5*D5)","v":0}]
[{"$f":"Questionnaire!F66","v":0},{"$f":"Questionnaire!F68","v":0},{"$f":"Questionnaire!F71","v":0},{"$f":"Questionnaire!F70","v":0},{"$f":"IF(Questionnaire!F69=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B6*C6*D6)","v":0}]
[{"$f":"Questionnaire!F74","v":0},{"$f":"Questionnaire!F76","v":0},{"$f":"Questionnaire!F79","v":0},{"$f":"Questionnaire!F78","v":0},{"$f":"IF(Questionnaire!F77=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B7*C7*D7)","v":0}]
["Total:",{"$f":"SUM(B4:B7)","v":0},{"$f":"SUM(C4:C7)","v":0},0,null,{"$f":"SUM(F4:F7)","v":0}]
["Ensoleillement journalier:",{"$f":"Questionnaire!$G$83","v":5},"hrs/jour"]
["Pertes",0.2,"%"]
["PV module capacity required:",{"$f":"(B15/B9)+((B15/B9)*B10)","v":0},"Wp"]
["Onduleur?",{"$f":"IF(COUNTIF(E4:E7,\"AC\"),\"Yes\",\"No\")","v":"No"}]
["Jours d'autonomie:",{"$f":"Questionnaire!F85","v":1}]
["Profondeur de décharge:",0.6,"%"]
["Batterie:",{"$f":"((F8*B13)+((F8*B13)/B14))","v":0},"Wh"]
[]
[]
[null,"Coût d'investissement ($)","Coût de maintenance ($/mois)","Coût du fuel ($/mois)","Inflation($/année)"]
[{"$f":"Questionnaire!F91","v":0},{"$f":"Questionnaire!F94","v":0},{"$f":"Questionnaire!F93","v":0},{"$f":"Questionnaire!F92","v":0},{"$f":"Questionnaire!$F$47","v":0}]
["Système PV ",{"$f":"Questionnaire!F86","v":0},{"$f":"(Questionnaire!F87/36)","v":0},0,{"$f":"Questionnaire!$F$47","v":0}]
[]
["Système PV vs Alternative: Période d'amortisation (mois) et coût total ($)",{"$nulls":5},"Nom de l'entreprise:",null,{"$f":"Questionnaire!E5","v":0}]
[null,"Coût d'investissement","Mois1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Mois 13","Mois 14","Mois 15","Mois 16","Mois 17","Mois 18","Mois 19","Mois 20 ","Mois 21","Mois 22","Mois 23","Mois 24","Mois 25","Mois 26","Mois 27","Mois 28","Mois 29","Mois 30","Mois 31","Mois 32","Mois 33","Mois 34","Mois 35","Mois 36"]
[{"$f":"A19","v":0},{"$f":"B19","v":0},{"$f":"B24+$C$19+$D$19+(($C$19+$D$19)*($E$19/12))","v":0},{"$f":"C24+$C$19+$D$19+(($C$19+$D$19)*($E$19/12))","v":0},{"$f":"D24+$C$19+$D$19+(($C$19+$D$19)*$E$19/12)","v":0},{"$f":"E24+$C$19+$D$19+(($C$19+$D$19)*$E$19/12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A20","v":"Système PV "},{"$f":"B20","v":0},{"$f":"B25+$C$20+$D$20+(($C$20+$D$20)*($E$20/12))","v":0},{"$f":"C25+$C$20+$D$20+(($C$20+$D$20)*($E$20/12))","v":0},{"$f":"D25+$C$20+$D$20+(($C$20+$D$20)*($E$20/12))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Remboursement?",{"$f":"IF(B24>B25,TRUE)","v":false},{"$f":"IF(C24>C25,TRUE)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(AB24>AB25,TRUE)","v":false},{"$f":"IF(AC24>AC25,TRUE)","v":false},{"$f":"IF(AD24>AD25,TRUE)","v":false},{"$f":"IF(AE24>AE25,TRUE)","v":false},{"$f":"IF(AF24>AF25,TRUE)","v":false},{"$f":"IF(AG24>AG25,TRUE)","v":false},{"$f":"IF(AH24>AH25,TRUE)","v":false},{"$f":"IF(AI24>AI25,TRUE)","v":false},{"$f":"IF(AJ24>AJ25,TRUE)","v":false},{"$f":"IF(AK24>AK25,TRUE)","v":false},{"$f":"IF(AL24>AL25,TRUE)","v":false}]
["Dernier mois de remboursement:",{"$f":"37-(COUNTIF(C26:AL26,\"TRUE\"))","v":37}]

{"sheet":"1er Remboursement","index":8,"n_rows":374,"n_cols":10,"rows_kept":374,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,7],[0,0,0,9]]}
["1er remboursement de prêt"]
["Banque:",{"$f":"Questionnaire!F103","v":0}]
[]
[null,"Valeur d'entrée",null,null,null,"Relevé du prêt"]
[null,null,"Montant du prêt",{"$f":"E5","v":0},{"$f":"Questionnaire!$F$104","v":0},null,"Versement prévu",{"$f":"IF(Values_Entered,-PMT(Interest_Rate/Num_Pmt_Per_Year,Loan_Years*Num_Pmt_Per_Year,Loan_Amount),\"0\")","v":"0"}]
[null,null,"Taux d'intérêt annuel",{"$f":"E6","v":0},{"$f":"Questionnaire!$F$105","v":0},null,"Nombre de versements prévus",{"$f":"IF(Values_Entered,Loan_Years*Num_Pmt_Per_Year,\"\")","v":""}]
[null,null,"Période de prêt en année",{"$f":"E7","v":0},{"$f":"Questionnaire!$F$106","v":0},null,"Nombre de versements actuels",{"$f":"IF(Values_Entered,Number_of_Payments,\"\")","v":""}]
[null,null,"Nombre de versements par année",12,null,null,"Versement anticipé total",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Extra_Pay),\"\")","v":""}]
[null,null,"Date du début du prêt",{"$f":"E9","v":"00:00:00"},{"$f":"Questionnaire!F108","v":"00:00:00"},null,"Taux d'intérêt total",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Int),\"\")","v":""}]
[null,null,"Versements optionnelles",0]
[]
[]
["PmtNo.","Date du versement","Solde de début","Versement prévu","Versements optionnelles","Versement total","Principal","Intérêt","Solde de fin","Intérêt cumulé "]
[]
[{"$f":"IF(Values_Entered,1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},{"$f":"IF(Values_Entered,Loan_Amount,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*(Interest_Rate/Num_Pmt_Per_Year),\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H15)","v":0}]
[{"$f":"IF(Values_Entered,A15+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I15,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H16)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H17)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H18)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H19)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H20)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H21)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H22)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H23)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H24)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H25)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H26)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H27)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H28)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H29)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H30)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H31)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H32)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H33)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H34)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H35)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H36)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H37)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H38)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H39)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H40)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H41)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H42)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H43)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H44)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H45)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H46)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H47)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H48)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H49)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H50)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H51)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H52)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H53)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H54)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H55)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H56)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H57)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H58)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H59)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H60)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H61)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H62)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H63)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H64)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H65)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H66)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H67)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H68)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H69)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H70)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H71)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H72)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H73)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H74)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H75)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H76)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H77)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H78)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H79)","v":0}]
[{"$f":"IF(Values_Entered,A79+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H80)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H81)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H82)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H83)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H84)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H85)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H86)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H87)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H88)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H89)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H90)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H91)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H92)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H93)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H94)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H95)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H96)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H97)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H98)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H99)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H100)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H101)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H102)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H103)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H104)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H105)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H106)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H107)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H108)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H109)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H110)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H111)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H112)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H113)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H114)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H115)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H116)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H117)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H118)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H119)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H120)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H121)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H122)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H123)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H124)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H125)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H126)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H127)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H128)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H129)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H130)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H131)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H132)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H133)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H134)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H135)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H136)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H137)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H138)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H139)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H140)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H141)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H142)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H143)","v":0}]
[{"$f":"IF(Values_Entered,A143+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I143,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H144)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H145)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H146)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H147)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H148)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H149)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H150)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H151)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H152)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H153)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H154)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H155)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H156)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H157)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H158)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H159)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H160)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H161)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H162)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H163)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H164)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H165)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H166)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H167)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H168)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H169)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H170)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H171)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H172)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H173)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H174)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H175)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H176)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H177)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H178)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H179)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H180)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H181)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H182)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H183)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H184)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H185)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H186)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H187)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H188)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H189)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H190)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H191)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H192)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H193)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H194)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H195)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H196)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H197)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H198)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H199)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H200)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H201)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H202)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H203)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H204)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H205)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H206)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H207)","v":0}]
[{"$f":"IF(Values_Entered,A207+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I207,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H208)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H209)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H210)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H211)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H212)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H213)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H214)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H215)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H216)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H217)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H218)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H219)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H220)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H221)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H222)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H223)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H224)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H225)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H226)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H227)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H228)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H229)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H230)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H231)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H232)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H233)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H234)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H235)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H236)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H237)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H238)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H239)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H240)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H241)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H242)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H243)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H244)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H245)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H246)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H247)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H248)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H249)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H250)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H251)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H252)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H253)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H254)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H255)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H256)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H257)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H258)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H259)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H260)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H261)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H262)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H263)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H264)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H265)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H266)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H267)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H268)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H269)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H270)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H271)","v":0}]
[{"$f":"IF(Values_Entered,A271+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I271,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H272)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H273)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H274)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H275)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H276)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H277)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H278)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H279)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H280)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H281)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H282)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H283)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H284)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H285)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H286)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H287)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H288)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H289)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H290)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H291)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H292)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H293)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H294)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H295)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H296)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H297)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H298)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H299)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H300)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H301)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H302)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H303)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H304)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H305)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H306)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H307)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H308)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H309)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H310)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H311)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H312)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H313)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H314)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H315)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H316)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H317)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H318)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H319)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H320)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H321)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H322)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H323)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H324)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H325)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H326)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H327)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H328)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H329)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H330)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H331)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H332)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H333)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H334)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H335)","v":0}]
[{"$f":"IF(Values_Entered,A335+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I335,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H336)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H337)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H338)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H339)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H340)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H341)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H342)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H343)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H344)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H345)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H346)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H347)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H348)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H349)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H350)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H351)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H352)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H353)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H354)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H355)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H356)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H357)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H358)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H359)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H360)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H361)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H362)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H363)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H364)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H365)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H366)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H367)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H368)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H369)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H370)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H371)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H372)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H373)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H374)","v":0}]

{"sheet":"2ème Remboursement","index":9,"n_rows":374,"n_cols":10,"rows_kept":374,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,7],[0,0,0,9]]}
["2ème Remboursement de prêt"]
["Banque:",{"$f":"Questionnaire!F110","v":0}]
[]
[null,"Valeur d'entrée",null,null,null,"Relevé du prêt"]
[null,null,"Montant du prêt",{"$f":"E5","v":0},{"$f":"Questionnaire!$F$111","v":0},null,"Versement prévu",{"$f":"IF(Values_Entered,-PMT(Interest_Rate/Num_Pmt_Per_Year,Loan_Years*Num_Pmt_Per_Year,Loan_Amount),\"0\")","v":"0"}]
[null,null,"Taux d'intérêt annuel",{"$f":"E6","v":0},{"$f":"Questionnaire!$F$112","v":0},null,"Nombre de versements prévus",{"$f":"IF(Values_Entered,Loan_Years*Num_Pmt_Per_Year,\"\")","v":""}]
[null,null,"Période de prêt en année",{"$f":"E7","v":0},{"$f":"Questionnaire!$F$113","v":0},null,"Nombre de versements actuels",{"$f":"IF(Values_Entered,Number_of_Payments,\"\")","v":""}]
[null,null,"Nombre de versements par année",12,null,null,"Versement anticipé total",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Extra_Pay),\"\")","v":""}]
[null,null,"Date du début du prêt",{"$f":"E9","v":"00:00:00"},{"$f":"Questionnaire!$F$115","v":"00:00:00"},null,"Taux d'intérêt total",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Int),\"\")","v":""}]
[null,null,"Versements optionnelles",0]
[]
[]
["PmtNo.","Date du versement","Solde de début","Versement prévu","Versements optionnelles","Versement total","Principal","Intérêt","Solde de fin","Intérêt cumulé "]
[]
[{"$f":"IF(Values_Entered,1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},{"$f":"IF(Values_Entered,Loan_Amount,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*(Interest_Rate/Num_Pmt_Per_Year),\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H15)","v":0}]
[{"$f":"IF(Values_Entered,A15+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I15,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H16)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H17)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H18)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H19)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H20)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H21)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H22)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H23)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H24)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H25)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H26)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H27)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H28)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H29)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H30)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H31)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H32)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H33)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H34)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H35)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H36)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H37)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H38)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H39)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H40)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H41)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H42)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H43)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H44)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H45)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H46)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H47)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H48)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H49)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H50)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H51)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H52)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H53)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H54)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H55)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H56)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H57)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H58)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H59)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H60)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H61)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H62)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H63)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H64)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H65)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H66)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H67)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H68)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H69)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H70)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H71)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H72)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H73)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H74)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H75)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H76)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H77)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H78)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H79)","v":0}]
[{"$f":"IF(Values_Entered,A79+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H80)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H81)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H82)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H83)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H84)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H85)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H86)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H87)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H88)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H89)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H90)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H91)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H92)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H93)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H94)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H95)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H96)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H97)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H98)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H99)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H100)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H101)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H102)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H103)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H104)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H105)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H106)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H107)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H108)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H109)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H110)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H111)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H112)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H113)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H114)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H115)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H116)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H117)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H118)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H119)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H120)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H121)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H122)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H123)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H124)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H125)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H126)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H127)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H128)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H129)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H130)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H131)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H132)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H133)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H134)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H135)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H136)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H137)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H138)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H139)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H140)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H141)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H142)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H143)","v":0}]
[{"$f":"IF(Values_Entered,A143+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I143,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H144)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H145)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H146)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H147)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H148)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H149)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H150)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H151)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H152)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H153)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H154)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H155)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H156)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H157)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H158)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H159)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H160)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H161)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H162)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H163)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H164)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H165)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H166)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H167)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H168)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H169)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H170)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H171)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H172)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H173)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H174)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H175)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H176)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H177)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H178)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H179)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H180)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H181)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H182)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H183)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H184)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H185)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H186)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H187)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H188)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H189)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H190)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H191)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H192)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H193)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H194)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H195)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H196)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H197)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H198)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H199)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H200)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H201)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H202)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H203)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H204)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H205)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H206)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H207)","v":0}]
[{"$f":"IF(Values_Entered,A207+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I207,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H208)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H209)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H210)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H211)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H212)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H213)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H214)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H215)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H216)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H217)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H218)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H219)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H220)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H221)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H222)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H223)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H224)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H225)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H226)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H227)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H228)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H229)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H230)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H231)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H232)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H233)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H234)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H235)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H236)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H237)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H238)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H239)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H240)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H241)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H242)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H243)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H244)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H245)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H246)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H247)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H248)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H249)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H250)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H251)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H252)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H253)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H254)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H255)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H256)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H257)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H258)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H259)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H260)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H261)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H262)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H263)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H264)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H265)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H266)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H267)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H268)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H269)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H270)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H271)","v":0}]
[{"$f":"IF(Values_Entered,A271+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I271,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H272)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H273)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H274)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H275)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H276)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H277)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H278)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H279)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H280)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H281)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H282)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H283)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H284)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H285)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H286)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H287)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H288)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H289)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H290)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H291)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H292)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H293)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H294)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H295)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H296)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H297)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H298)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H299)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H300)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H301)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H302)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H303)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H304)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H305)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H306)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H307)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H308)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H309)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H310)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H311)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H312)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H313)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H314)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H315)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H316)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H317)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H318)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H319)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H320)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H321)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H322)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H323)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H324)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H325)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H326)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H327)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H328)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H329)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H330)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H331)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H332)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H333)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H334)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H335)","v":0}]
[{"$f":"IF(Values_Entered,A335+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I335,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H336)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H337)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H338)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H339)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H340)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H341)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H342)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H343)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H344)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H345)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H346)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H347)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H348)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H349)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H350)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H351)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H352)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H353)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H354)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H355)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H356)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H357)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H358)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H359)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H360)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H361)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H362)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H363)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H364)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H365)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H366)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H367)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H368)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H369)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H370)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H371)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H372)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H373)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H374)","v":0}]