{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Table rentabilité optimisé","investissement réel","Remboursement Mensualités"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Table rentabilité optimisé","index":0,"n_rows":215,"n_cols":23,"rows_kept":215,"cut":false,"hidden":false,"merged":[[158,2,158,3],[159,2,159,3],[160,2,160,3],[161,2,161,3],[112,2,112,3],[157,2,157,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[58,1,59,1],[58,7,59,7],[71,5,71,6],[74,5,74,6],[79,5,79,6],[83,5,83,6],[113,2,113,3],[114,2,114,3],[115,2,115,3],[116,2,116,3],[16,10,17,10],[24,2,25,2],[24,4,25,4],[56,1,57,1],[56,7,57,7],[16,2,17,2],[16,3,16,4],[16,5,17,5],[16,6,17,6],[16,7,17,7],[16,8,16,9],[24,3,25,3],[24,6,25,6]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"chambre froide "]
[]
[null,"Dimmensionnement réel"]
[null,"Dimmensionnement optimisé "]
[null,"Dimmensionnement réel"]
[]
[]
[null,"Cases à vérifier"]
[null,"Cases à compléter"]
[null,"Cases à laisser vides"]
[null,"Cases calculées"]
[]
[null,"Caractéristiques techniques du Projet"]
[]
[null,"Usage Productif","Rendement (kg/jour)","Puissance (kW)",null,"Prix (FCFA)","Energie consommée (KWh/j)","Energie à produire (kWh/j)","Fonctionnement optimal",null,"Coefficient déperdition (k)"]
[null,null,null,"Max","Nominale",null,null,null,"heures par jour","jours à l'année"]
[null,"chambre froide 20 m3",1800,"-",0.9,6556749.3799999999,{"$f":"E19*I19","v":21.6},{"$f":"E19*I19/K19","v":27},24,365,0.8]
[null,null,null,"-",null,null,null,{"$f":"E20*I20/K20","v":0},16,365,0.8]
[null,null,null,"-",null,null,null,{"$f":"E21*I21/K21","v":0},16,365,0.8]
[]
[]
[]
[null,"Equipements complementaires","Puissance (kW)","Nombre","Consommation énergétique (kWh/jour)","Fonctionnement","Prix (FCFA)"]
[{"$nulls":5},"h/jour"]
[null,"Hangar",null,1,{"$f":"C27*F27","v":0},null,4500000]
[null,"Autres accessoires (petits matériels)",null,1,0,null,857007.82]
[null,"main d'eoeuvre",null,1,0,null,4478218.4400000004]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},"-","-"]
[]
[null,"Parafoudre",{"$nulls":4},12510]
[null,"Puit ",{"$nulls":4},500000]
[null,"Local technique",{"$nulls":4},2206450]
[null,"Câbles et accessoires",{"$nulls":4},250000]
[null,"Installation & transport équipements",{"$nulls":4},1374000]
[null,"Support alluminium",{"$nulls":4},17000]
[]
[null,"Alimentation Solaire","Puissance (kW)","Prix (FCFA)","Coefficient déperdition","Tension (V)",null,"Batteries","Capacité (Ampères/h)","Prix (FCFA)","Tension (V)","Durée de vie*","* en conditions optimales, annoncées constructeur"]
[null,"Modules polycristallins 275 W",0.27500000000000002,50000,0.6,"24V",null,"OPzV 2V",500,136000,2,10]
[null,"Modules polycristallins 300 W",0.3,70000,null,null,null,"Gel 220Ah 12V",220,360250,12,10]
[{"$nulls":7},"Batteries (1018 Ah/C20, 2V 2230Ah/C100)",2230,257594.31,2]
[null,"Tension nécessaire ",{"$f":"IF(J46<0.5,\"12V\",IF(AND(J46>=0.5,J46<2),\"24V\",IF(J46>=2,\"48V\")))","v":"48V"},{"$nulls":4},"Tension nécessaire batteries",{"$f":"IF(J46<0.5,12,IF(AND(J46>=0.5,J46<2),24,IF(J46>=2,48)))","v":48},{"$f":"F97*INDEX(C:C,MATCH(F76,B:B,0))","v":4.6750000000000007}]
[]
[null,"Onduleur","kVa","Prix (FCFA)",null,null,null,"Régulateur","tension /courant","Prix (FCFA)","Tension (V)"]
[null,"Victron quatro 5 kW",5,1426500,null,null,null,"VICTRON MPPT 150/85","150V/85A",315000,"12V/24V/48V"]
[null,"Onduleurs (48volt/3000va)",3,421387,null,null,null,"Régulateurs (MPPT150/60)","100V/60A",208332,"12V/24V/48V"]
[]
[null,"Irradiation Solaire"]
[null,"Month ","Jan ","Feb ","Mar ","Apr ","May ","Jun ","Jul ","Aug ","Sep ","Oct ","Nov ","Dec ","Year"]
[null,"H(15)*",5.12,5.75,6.37,6.61,6.34,6.05,6.26,5.51,6.03,5.81,5.226,5.03,6.01]
[]
[null,"Électricité du réseau",null,"1ère Tranche","2ème Tranche","3ème Tranche",null,null,null,"1ère Tranche","2ème Tranche","3ème Tranche","Total"]
[null,"UP-Petite Puissance","Tranche (KWh)",50,500,"∞",null,"UP-Petite Puissance","Energie par Tranche",{"$f":"(F91*30)-SUM(K57:L57)","v":50},{"$f":"IF((F91*30)>D57,(F91*30)-D57-L57,0)","v":450},{"$f":"IF((F91*30)>E57,(F91*30)-E57,0)","v":148},{"$f":"SUM(J57:L57)","v":648}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J57*D58","v":6442.5},{"$f":"K57*E58","v":61056},{"$f":"L57*F58","v":21856.639999999999},{"$f":"SUM(J58:L58)","v":89355.14}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F91*30)-SUM(K59:L59)","v":100},{"$f":"IF((F91*30)>D59,(F91*30)-D59-L59,0)","v":400},{"$f":"IF((F91*30)>E59,(F91*30)-E59,0)","v":148},{"$f":"SUM(J59:L59)","v":648}]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J59*D60","v":12981},{"$f":"K59*E60","v":54612},{"$f":"L59*F60","v":22087.52},{"$f":"SUM(J60:L60)","v":89680.52}]
[]
[null,"Frais fixes de raccordement","Fixe/Distance","Prix TTC","Étude raccordement"]
[null,"Réseau HTA","Kg câble","10.000 à 100.000",550000]
[null,"Réseau HTA - Autres Frais","Fixe","2.000.000 à 7.000.000",550000]
[null,"Transformateur HT/MT - BT","Fixe",4800000,179000]
[null,"Extension BT*","Distance",8260,179000]
[null,"Dépend également de la distance de transport des équipements et nombre et type de poteaux non mesurable sauf par Sénélec (approximation)"]
[]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"quantité min stockée souhaitée (kg /jour)",null,null,null,{"$f":"C19","v":1800}]
[null,"Répartition clients internes/externes",null,null,null,0.5,0.5]
[]
[null,"Choix de la chambre froide",null,null,null,"chambre froide 20 m3"]
[null,"Choix de l'alimentation solaire",null,null,null,"Modules polycristallins 275 W"]
[null,"Choix du système de stokage",null,null,null,"Batteries (1018 Ah/C20, 2V 2230Ah/C100)"]
[null,"Choix de l'onduleur",null,null,null,"Onduleurs (48volt/3000va)"]
[null,"Choix du régulateur",null,null,null,"Régulateurs (MPPT150/60)"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M57<M59,B57,B59)","v":"UP-Moyenne Puissance"}]
[null,"Raccordement nécessaire (MT, BT) et distance",null,null,null,"MT",500]
[null,"Montant Frais HTA et KG câble",null,null,null,4462549,30]
[]
[null,"Autonomie nécessaires au projet (jours)",null,null,null,1]
[null,"Profondeur décharge batteries",null,null,null,0.8]
[]
[null,"Choix du cas pour dimensionnement solaire",null,null,null,"best case"]
[{"$nulls":5},"worst case"]
[{"$nulls":5},"average","x"]
[]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"SUM(E27:E33)+INDEX(G:G,MATCH(F75,B:B,0))","v":21.6},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F75,B:B,0))+SUM(E27:E32))/O54*F95","v":4.4925124792013316},"KW"]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(INDEX(G:G,MATCH(F75,B:B,0))+SUM(E27:E32))*1000*(F84)/(F85*I46)","v":562.49999999999989},"Ah"]
[]
[null,"Nb de chambre froide",null,null,null,{"$f":"ROUNDUP(F72/(C19),0)","v":1},"unités"]
[null,"Puissance equippement journaliere majoré (KW)",null,null,null,{"$f":"(INDEX(E:E,MATCH(F75,B:B,0))+SUM(C27:C33))*2","v":1.8}]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F92/INDEX(C:C,MATCH(F76,B:B,0)),0)","v":17},"unités"]
[null,"Nb de batteries en série",null,null,null,{"$f":"I46/INDEX(K:K,MATCH(F77,H:H,0))","v":24},"unités"]
[null,"Nb de batteries en dérivation",null,null,null,{"$f":"ROUNDUP(F93/INDEX(I:I,MATCH(F77,H:H,0)),0)","v":1},"unités"]
[null,"Nb de batteries total",null,null,null,{"$f":"F98*F99","v":24},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,7,"ans"]
[null,"Nb régulateurs",null,null,null,{"$f":"IF(OR(C46=24,C46=12),1,2)","v":2},"unités"]
[null,"Nb onduleurs",null,null,null,{"$f":"ROUNDUP(F96/INDEX(C:C,MATCH(F78,B:B,0)),0)","v":1},"unités"]
[]
[null,"Ratio de fonctionnement ",null,null,null,0.9]
[null,"Employés nécessaires pour fonctionnement",null,null,null,1,"personnes"]
[null,"Intrant annuel attendu ",null,null,null,{"$f":"INDEX(C:C,MATCH($F$75,B:B,0))*INDEX(J:J,MATCH($F$75,B:B,0))*F105*F95","v":591300},"Kilos"]
[null,"Extrant annuel attendu "]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION"]
[null,"Désignation","Quantité",null,"Prix unitaire","Montant total/an","Montant total/mois","évolution annuelle charges d'exploitation",null,null,0.02]
[null,"Maintenance et réparation des équipements",12,null,25000,{"$f":"E114*C114","v":300000}]
[null,"Achat de casiers de légumes 50x30",300,null,2000,{"$f":"E115*C115","v":600000},null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"((MIN(M60,M58)*12)+IF(F81=\"MT\",(G81*D66)+D65+E63+F82,(G81*D66)))-(SUM(F142:F147,F152)+SUM(G142:G147,G152))","v":14551285.232999999}]
[null,"Motivation comité de la chambre froide",12,null,15000,180000,null,null,null,"Sur 5 ans",{"$f":"((MIN(M60,M58)*12*5)+IF(F81=\"MT\",(G81*D66)+D65+E63+F82,(G81*D66)))-(SUM(F142:F147,F152)+(SUM(G142:G147,G152)*5))","v":18671777.244999997}]
[null,"Recherche de marché",1,null,324000,324000]
[null,"Sous Total",null,null,null,{"$f":"SUM(F114:F117)","v":1404000}]
[null,"Imprévus (1%)",null,null,null,{"$f":"F118*1%","v":14040}]
[{"$nulls":9},"Sur 10 ans",{"$f":"((MIN(M60,M58)*12*10)+IF(F81=\"MT\",(G81*D66)+D65+E63+F82,(G81*D66)))-(SUM(F142:F147,F152)+(SUM(G142:G147,G152)*10))","v":23822392.259999998}]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"F118+F119","v":1418040},{"$f":"F121/12","v":118170}]
[]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"chambre froide 20 m3",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F95,'investissement réel'!C5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(F:F,MATCH(F75,B:B,0)),'investissement réel'!D5)","v":6556749.3799999999},15,{"$f":"C125*D125","v":6556749.3799999999},{"$f":"IFERROR(F125/E125,0)","v":437116.62533333333}]
[null,"Panneaux solaire 275KW",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F97,'investissement réel'!C4)","v":16},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F76,B:B,0)),'investissement réel'!D4)","v":47622.48},20,{"$f":"C126*D126","v":761959.68},{"$f":"IFERROR(F126/E126,0)","v":38097.984000000004}]
[null,"Batteries (1018 Ah/C20, 2V 2230Ah/C100)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F100,'investissement réel'!C6)","v":24},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F77,H:H,0)),'investissement réel'!D6)","v":257594.31},5,{"$f":"C127*D127","v":6182263.4399999995},{"$f":"IFERROR(F127/E127,0)","v":1236452.6879999998}]
[null,"Hangar",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D27,'investissement réel'!C7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G27,'investissement réel'!D7)","v":4500000},10,4500000,450000]
[null,"Autres accessoires (petits matériels)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D28,'investissement réel'!C8)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G28,'investissement réel'!D8)","v":857007.82},10,857007.82,85700.781999999992]
[null,"Onduleurs (48volt/4000va)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F103,'investissement réel'!C9)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F78,B:B,0)),'investissement réel'!D9)","v":313875.42},10,313875.42,31387.541999999998]
[null,"Régulateurs (MPPT150/60)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F102,'investissement réel'!C10)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F79,H:H,0)),'investissement réel'!D10)","v":322009.28999999998},10,322009.28999999998,32200.928999999996]
[null,"Main d'œuvre ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D29,'investissement réel'!C11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G29,'investissement réel'!D11)","v":4478218.4400000004},null,4478218.4400000004,0]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C12)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G32,'investissement réel'!D12)","v":421386.77},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C13)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G33,'investissement réel'!D13)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C14)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G34,'investissement réel'!D14)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C15)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G35,'investissement réel'!D15)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C16)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G36,'investissement réel'!D16)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C17)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G37,'investissement réel'!D17)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C18)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G38,'investissement réel'!D18)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C19)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G39,'investissement réel'!D19)","v":0},15]
[null,null,{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C20)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G40,'investissement réel'!D20)","v":0},15]
[null,"Onduleurs (48volt/3000va)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F103,'investissement réel'!C12)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),421387,'investissement réel'!D12)","v":421386.77},10,{"$f":"C142*D142","v":421386.77},{"$f":"IFERROR(F142/E142,0)","v":42138.677000000003}]
{"$rows_empty":10}
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F125:F152)","v":24393470.240000002},{"$f":"SUM(G125:G152)","v":2353095.2273333333}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité KG/jour",null,"Prix unitaire","Recettes mensulles","Recettes annuelles",null,null,null,0.02]
[null,"service conservation",{"$f":"F107","v":591300},null,10,{"$f":"G159/12","v":492750},{"$f":"C159*E159","v":5913000}]
[{"$nulls":5},{"$f":"C160*E160*25","v":0},{"$f":"F160*12","v":0}]
[{"$nulls":5},0,0]
[null,"TOTAL (F CFA)",null,null,null,{"$f":"SUM(F159:F161)","v":492750},{"$f":"SUM(G159:G161)","v":5913000}]
[]
[null,"Ressources et Financement des investissements"]
[]
[null,"BFR (Besoin en fonds de roulement)"]
[null,"Type de tiers","Client/fournisseur","Délais de paiement / stocks (jours)","Part des achats/ventes"]
[null,null,"founisseur",0,1]
[null,null,"client",0,1]
[]
[null,"Créances clients",{"$f":"((D169*F162/365*E169))","v":0}]
[null,"Crédit fournisseurs",{"$f":"(D168*F121*E168/365)*-1","v":0}]
[null,"Impact Stocks consommable",0]
[null,"Impact Stocks produits finis",0]
[null,"BFR",null,"F CFA"]
[]
[]
[null,"SCHÉMA DE FINANCEMENT",null,null,null,"ECHEANCIER DE REMBOURSEMENT"]
[null,"Désignation ","Part","Montant total TTC",null,"Année","Remboursement Capital ","Intérêts","Reste","Annuité","mensualité"]
[null,"Investissements",null,{"$f":"F153","v":24393470.240000002},null,{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F180)","v":2666549.3408455476},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F180)","v":1483815.2140452766},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F180)","v":259763068.64359918},{"$f":"G180+H180","v":4150364.5548908245},{"$f":"J180/12","v":345863.71290756873}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C175","v":0},null,{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F181)","v":2853207.7947047362},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F181)","v":1297156.7601860883},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F181)","v":226563736.99690464},{"$f":"G181+H181","v":4150364.5548908245},{"$f":"J181/12","v":345863.71290756873}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D180:D181)","v":24393470.240000002},null,{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F182)","v":3052932.3403340671},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F182)","v":1097432.2145567569},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F182)","v":191040452.13494134},4150364.554890824,345863.71290756867]
[null,"Apport personnel",{"$f":"D183/D182","v":5.3993793709607094E-2},1317096,null,{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F183)","v":3266637.6041574515},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F183)","v":883726.95073337236},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F183)","v":153030537.33264065},4150364.554890824,345863.71290756867]
[null,"Subvention",0,{"$f":"C184*D182","v":0},null,{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=5,5,\"-\"))","v":5},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F184)","v":3495302.2364484738},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F184)","v":655062.31844235084},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F184)","v":112359928.49417895},4150364.5548908245,345863.71290756873]
[null,"Emprunt",{"$f":"100%-C183-C184","v":0.94600620629039289},{"$f":"C185*D182","v":23076374.240000002},null,{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=6,6,\"-\"))","v":6},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F185)","v":3739973.392999867},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F185)","v":410391.1618909578},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F185)","v":68842377.037024885},4150364.5548908249,345863.71290756873]
[null,"Taux  d'interet annuel de l'emprunt %",null,7.0000000000000007E-2,null,{"$f":"IF($D$187>10,\"nb an insuffisant\",IF($D$187>=7,7,\"-\"))","v":7},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F186)","v":4001771.5305098575},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F186)","v":148593.02438096725},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F186)","v":22278596.977870047},{"$f":"G186+H186","v":4150364.5548908245},345863.71290756873]
[null,"Remboursement de l'emprunt (années)",null,7,null,{"$f":"IF($D$187>10,\"nb an insuffisant\",IF($D$187>=8,8,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":0},0]
[{"$nulls":5},{"$f":"IF($D$187>10,\"nb an insuffisant\",IF($D$187>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":0},0]
[{"$nulls":5},{"$f":"IF(D187>10,\"nb an insuffisant\",IF(D187>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":0},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G180:G189)","v":23076374.240000002},{"$f":"SUM(H180:H189)","v":5976177.6442357702},null,{"$f":"SUM(J180:J189)","v":29052551.884235777},{"$f":"SUM(K180:K189)","v":2421045.9903529808}]
[]
[]
[null,"Ressources et Financement des investissements"]
[]
[null,"RESULTAT BRUT D'EXPLOITATION (EBE)"]
[null,"Désignation / Durée (années)",0,1,2,3,4,5,6,7,8,9,"Total"]
[null,"Recettes  ",{"$f":"D185+D183","v":24393470.240000002},{"$f":"G162","v":5913000},{"$f":"D197+($K$158*D197)","v":6031260},6151885.2000000002,6274922.9040000001,6400421.3620800003,6528429.7893216005,6658998.3851080323,6792178.3528101929,6928021.919866397,{"$f":"SUM(C197:L197)","v":82072588.153186232}]
[null,"Dépenses ",{"$f":"D180","v":24393470.240000002},{"$f":"F121","v":1418040},{"$f":"D198+($K$113*D198)","v":1446400.8},{"$f":"E198+($K$113*E198)","v":1475328.8160000001},1504835.3923200001,1534932.1001664002,1565630.7421697283,1596943.3570131229,1628882.2241533853,1661459.8686364531,38225923.540459089]
[null,"Amortissements ",0,{"$f":"$G$153","v":2353095.2273333333},2353095.2273333333,2353095.2273333333,2353095.2273333333,2353095.2273333333,2353095.2273333333,2353095.2273333333,2353095.2273333333,2353095.2273333333,21177857.046]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$180:$J$189,MATCH(D196,$F$180:$F$189,0)),0)","v":4150364.5548908245},{"$f":"IFERROR(INDEX($J$180:$J$189,MATCH(E196,$F$180:$F$189,0)),0)","v":4150364.5548908245},4150364.554890824,4150364.554890824,4150364.5548908245,4150364.5548908249,4150364.5548908245,0,0,29052551.884235777]
[null,"Bénéfice avant impôts (EBITDA)",0,{"$f":"D197-SUM(D198:D200)","v":-2008499.7822241578},{"$f":"E197-SUM(E198:E200)","v":-1918600.5822241576},-1826903.3982241573,-1733372.2705441574,-1637970.5203105574,-1540660.7350722859,-1441404.7541292487,2810200.901323474,2913466.8238966106,-6383744.317508636]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D201<0,0,0.3*D201)","v":0},{"$f":"IF(E201<0,0,0.3*E201)","v":0},0,0,0,0,0,843060.27039704216,874040.04716898315,1717100.3175660253]
[null,"Bénéfice après impôts ",0,{"$f":"D201-D202","v":-2008499.7822241578},{"$f":"E201-E202","v":-1918600.5822241576},-1826903.3982241573,-1733372.2705441574,-1637970.5203105574,-1540660.7350722859,-1441404.7541292487,1967140.6309264319,2039426.7767276275,-8100844.635074662]
[null,"Trésorerie",{"$f":"C197-C198","v":0},{"$f":"C204+D203","v":-2008499.7822241578},{"$f":"D204+E203","v":-3927100.3644483155},-5754003.7626724727,-7487376.0332166301,-9125346.5535271876,-10666007.288599472,-12107412.042728722,-10140271.41180229,-8100844.635074662]
[null,"Cash Flows",0,{"$f":"D203+D200-($H$190/$D$187)","v":1288125.1092044138},{"$f":"E203+E200-($H$190/$D$187)","v":1378024.309204414},1469721.4932044139,1563252.6208844138,1658654.3711180142,1755964.1563562863,1855220.137299323,1113400.9674641788,1185687.1132653747]
[null,"Cash Flows cumulés",{"$f":"-C198","v":-24393470.240000002},{"$f":"C206+D205","v":-23105345.130795587},-21727320.821591172,-20257599.328386758,-18694346.707502343,-17035692.33638433,-15279728.180028044,-13424508.04272872,-12311107.075264541,-11125419.961999167]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F211,IF(D196<=H211,D205,0),IF(E196<=H211,E205,0),IF(F196<=H211,F205,0),IF(G196<=H211,G205,0),IF(H196<=H211,H205,0),IF(I196<=H211,I205,0),IF(J196<=H211,J205,0),IF(K196<=H211,K205,0),IF(L196<=H211,L205,0))-D180","v":-13914788.275374185},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D180+IF(H211>=D196,(D203+D200-H190/D187)*((1+F211)^-1),0)+IF(H211>=E196,(E203+E200-H190/D187)*((1+F211)^-2),0)+IF(H211>=F196,(F203+F200-H190/D187)*((1+F211)^-3),0)+IF(H211>=G196,(G203+G200-H190/D187)*((1+F211)^-4),0)+IF(H211>=H196,(H203+H200-H190/D187)*((1+F211)^-5),0)+IF(H211>=I196,(I203+I200-H190/D187)*((1+F211)^-6),0)+IF(H211>=J196,(J203+J200-H190/D187)*((1+F211)^-7),0)+IF(H211>=K196,(K203+K200-H190/D187)*((1+F211)^-8),0)+IF(H211>=L196,(L203+L200-H190/D187)*((1+F211)^-9),0)","v":-13914788.27537418},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N212:W212)","v":-0.10819874255235462},{"$nulls":10},{"$f":"-D180","v":-24393470.240000002},{"$f":"IF(D196<=H211,D205,0)","v":1288125.1092044138},{"$f":"IF(E196<=H211,E205,0)","v":1378024.309204414},{"$f":"IF(F196<=H211,F205,0)","v":1469721.4932044139},{"$f":"IF(G196<=H211,G205,0)","v":1563252.6208844138},{"$f":"IF(H196<=H211,H205,0)","v":1658654.3711180142},{"$f":"IF(I196<=H211,I205,0)","v":1755964.1563562863},{"$f":"IF(J196<=H211,J205,0)","v":1855220.137299323},{"$f":"IF(K196<=H211,K205,0)","v":1113400.9674641788},{"$f":"IF(L196<=H211,L205,0)","v":1185687.1132653747}]
[null,"IPI",{"$f":"SUM(O212:W212)/D180","v":0.54391811199720608},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N213,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère -456 CFA"},{"$nulls":9},{"$f":"(C213-1)*1000","v":-456.0818880027939}]
[null,"DCRI",{"$f":"N214+(-P214/(O214-P214))","v":{"$error":"#N/A"}},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C214,0)&\" ans et \"&ROUNDDOWN((C214-ROUNDDOWN(C214,0))*12,0)&\" mois\"","v":{"$error":"#N/A"}},{"$nulls":9},{"$f":"IF(AND(L206<0,L196<=H211),L196,IF(AND(K206<0,K196<=H211),K196,IF(AND(J206<0,J196<=H211),J196,IF(AND(I206<0,I196<=H211),I196,IF(AND(H206<0,H196<=H211),H196,IF(AND(G206<0,G196<=H211),G196,IF(AND(F206<0,F196<=H211),F196,IF(AND(E206<0,E196<=H211),E196,IF(AND(D206<0,D196<=H211),D196,IF(AND(C206<0,C196<=H211),C196))))))))))","v":9},{"$f":"INDEX(C206:L206,MATCH(INDEX(C196:L196,MATCH(P214,C206:L206,0))+1,C196:L196,0))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L206<0,L196<=H211),L206,IF(AND(K206<0,K196<=H211),K206,IF(AND(J206<0,J196<=H211),J206,IF(AND(I206<0,I196<=H211),I206,IF(AND(H206<0,H196<=H211),H206,IF(AND(G206<0,G196<=H211),G206,IF(AND(F206<0,F196<=H211),F206,IF(AND(E206<0,E196<=H211),E206,IF(AND(D206<0,D196<=H211),D206,IF(AND(C206<0,C196<=H211),C206))))))))))","v":-11125419.961999167}]
[null,"DSCR",{"$f":"(D197-D198)/(D200)","v":1.0830277534784507}]

{"sheet":"investissement réel","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Désignation ","Quantité","Prix unitaire TTC","Montant Total TTC","Durée de vie (an)","Amortissement annuel"]
[null,"Panneaux solaire",16,47622.48,{"$f":"C4*D4","v":761959.68},20,{"$f":"E4/F4","v":38097.984000000004}]
[null,"Equipements frigorifique ",1,6556749.3799999999,{"$f":"C5*D5","v":6556749.3799999999},15,{"$f":"E5/F5","v":437116.62533333333}]
[null,"Batteries ",24,257594.31,{"$f":"C6*D6","v":6182263.4399999995},5,1236452.6879999998]
[null,"Hangar",1,4500000,4500000,10,450000]
[null,"Autres accessoires (petits matériels)",1,857007.82,857007.82,10,85700.781999999992]
[null,"Onduleurs 48/2000VA",1,313875.42,313875.42,10,31387.541999999998]
[null,"Régulateurs ",1,322009.28999999998,322009.28999999998,10,32200.928999999996]
[null,"Main d'œuvre ",1,4478218.4400000004,4478218.4400000004]
[null,"Onduleurs 48/3000VA",1,421386.77,421386.77,10,42138.677000000003]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"C16*D16","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"C21*D21","v":0}]
[{"$nulls":4},0]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E4:E22)","v":24393470.240000002},null,{"$f":"SUM(G4:G22)","v":2353095.2273333333}]

{"sheet":"Remboursement Mensualités","index":2,"n_rows":133,"n_cols":7,"rows_kept":133,"cut":false,"hidden":true,"merged":[]}
["Remboursement de prêt"]
["Taux annuel",{"$f":"'Table rentabilité optimisé'!D186","v":7.0000000000000007E-2}]
["Capital emprunté",{"$f":"'Table rentabilité optimisé'!D185","v":23076374.240000002}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité optimisé'!D187","v":7},{"$f":"B4*12","v":84}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":345863.71290756867},"Formule mensualité","=-VPM((1+B2)^(1/12)-1;B4*12;B3)"]
[]
["Décomposition de la mensualité"]
["Remboursement du principal",{"$f":"-PPMT((1+B2)^(1/12)-1,1,B4*12,B3)","v":215386.53794043479},"Formule principal","=-PRINCPER((1+B2)^(1/12)-1;1;B4*12;B3)"]
["Remboursement des interêts",{"$f":"-IPMT((1+B2)^(1/12)-1,1,B4*12,B3)","v":130477.17496713389},"Formule intérêt","=-INTPER((1+B2)^(1/12)-1;1;B4*12;B3)"]
[]
[]
["Dans les formules ci-dessous Taux de période = TP =  (1+$B$2)^(1/12)-1"]
["Périodes","Mensualité","Capital","Intérêts","Reste (ou résiduel)","Années"]
[{"$f":"IF(B4<>0,1,\"-\")","v":1},{"$f":"IF(A14<>\"-\",C14+D14,\"\")","v":345863.71290756867},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":215386.53794043479},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":130477.17496713389},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":22860987.702059567},{"$f":"IF(A14<>\"-\",1,\"\")","v":1},{"$f":"IF(A14<>\"-\",1,\"\")","v":1}]
[{"$f":"IF(AND($B$4<>0,A14<$C$4),A14+1,\"-\")","v":2},345863.71290756873,{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":216604.36474043989},129259.34816712882,22644383.337319128,{"$f":"IF(A15<>\"-\",IF(G14<G15,F14,F14+1),\"\")","v":1},{"$f":"IF(A15=\"-\",\"\",IF(G14<12,G14+1,1))","v":2}]
[3,345863.71290756867,{"$f":"IF(A16<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A16,$B$4*12,$B$3),\"\")","v":217829.07731022887},128034.63559733979,22426554.260008898,1,3]
[4,345863.71290756867,219060.71458294528,126802.99832462342,22207493.545425951,1,4]
[5,345863.71290756873,220299.31571186616,125564.39719570255,21987194.229714088,1,5]
[6,345863.71290756867,221544.92007164692,124318.79283592176,21765649.309642442,1,6]
[7,345863.71290756867,222797.56725957309,123066.1456479956,21542851.742382865,1,7]
[8,345863.71290756867,224057.29709681892,121806.41581074975,21318794.445286047,1,8]
[9,345863.71290756867,225324.14962971339,120539.56327785527,21093470.295656335,1,9]
[10,345863.71290756873,226598.16513101329,119265.54777655544,20866872.130525321,1,10]
[11,345863.71290756867,227879.38410118324,117984.3288063854,20638992.746424139,1,11]
[12,345863.71290756867,229167.84726968376,116695.86563788494,20409824.899154454,1,12]
[13,345863.71290756873,230463.59559626522,115400.11731130349,20179361.303558189,2,1]
[14,345863.71290756867,231766.67027227065,114097.04263529801,19947594.633285917,2,2]
[15,345863.71290756873,233077.11272194493,112786.60018562379,19714517.520563975,2,3]
[16,345863.71290756867,234394.96460375143,111468.74830381725,19480122.555960223,2,4]
[17,345863.71290756867,235720.26781169677,110143.44509587192,19244402.288148522,2,5]
[18,345863.71290756867,237053.0644766622,108810.64843090648,19007349.223671865,2,6]
[19,345863.71290756873,238393.39696774323,107470.31593982548,18768955.826704118,2,7]
[20,345863.71290756867,239741.30789359624,106122.40501397243,18529214.518810522,2,8]
[21,345863.71290756873,241096.84010379337,104766.87280377536,18288117.678706728,2,9]
[22,345863.71290756873,242460.03669018421,103403.67621738451,18045657.642016545,2,10]
[23,345863.71290756873,243830.94098826611,102032.7719193026,17801826.70102828,2,11]
[24,345863.71290756873,245209.59657856161,100654.1163290071,17556617.104449719,2,12]
[25,345863.71290756867,246596.04728800379,99267.665619564912,17310021.057161715,3,1]
[26,345863.71290756873,247990.33719132966,97873.375716239068,17062030.719970383,3,2]
[27,345863.71290756873,249392.51061248107,96471.202295087642,16812638.209357902,3,3]
[28,345863.71290756867,250802.61212601402,95061.100781554647,16561835.597231889,3,4]
[29,345863.71290756873,252220.68655851556,93643.026349053165,16309614.910673372,3,5]
[30,345863.71290756873,253646.77899002857,92216.93391754014,16055968.131683346,3,6]
[31,345863.71290756873,255080.93475548524,90782.778152083469,15800887.19692786,3,7]
[32,345863.71290756867,256523.19944614798,89340.513461420705,15544363.997481711,3,8]
[33,345863.71290756873,257973.61891105887,87890.093996509837,15286390.378570653,3,9]
[34,345863.71290756867,259432.23925849708,86431.473649071617,15026958.139312156,3,10]
[35,345863.71290756873,260899.10685744474,84964.606050123984,14766059.03245471,3,11]
[36,345863.71290756867,262374.26833906089,83489.444568507781,14503684.764115648,3,12]
[37,345863.71290756867,263857.770598164,82005.942309404665,14239826.993517486,4,1]
[38,345863.71290756867,265349.66079472267,80514.05211284601,13974477.332722764,4,2]
[39,345863.71290756867,266849.98635535472,79013.726552213964,13707627.346367408,4,3]
[40,345863.71290756867,268358.79497483501,77504.917932733675,13439268.551392574,4,4]
[41,345863.71290756867,269876.13461761159,75987.578289957077,13169392.416774962,4,5]
[42,345863.71290756867,271402.05351933051,74461.659388238142,12897990.363255633,4,6]
[43,345863.71290756873,272936.60018836922,72927.112719199504,12625053.76306726,4,7]
[44,345863.71290756867,274479.82340737828,71383.889500190358,12350573.939659884,4,8]
[45,345863.71290756867,276031.77223483298,69831.940672735713,12074542.167425049,4,9]
[46,345863.71290756873,277592.49600659189,68271.21690097684,11796949.67141846,4,10]
[47,345863.71290756867,279162.04433746584,66701.668570102847,11517787.627080992,4,11]
[48,345863.71290756873,280740.46712279518,65123.245784773535,11237047.159958195,4,12]
[49,345863.71290756867,282327.8145400355,63535.898367533191,10954719.345418163,5,1]
[50,345863.71290756873,283924.13705035328,61939.575857215423,10670795.208367808,5,2]
[51,345863.71290756867,285529.48540022952,60334.22750733915,10385265.722967578,5,3]
[52,345863.71290756867,287143.91062307346,58719.802284495236,10098121.812344505,5,4]
[53,345863.71290756867,288767.46404084441,57096.248866724272,9809354.3483036626,5,5]
[54,345863.71290756867,290400.19726568367,55463.515641885017,9518954.1510379761,5,6]
[55,345863.71290756867,292042.16220155498,53821.550706013666,9226911.9888364226,5,7]
[56,345863.71290756873,293693.41104589484,52170.301861673892,8933218.5777905267,5,8]
[57,345863.71290756873,295353.99629127129,50509.716616297417,8637864.5814992581,5,9]
[58,345863.71290756873,297023.9707270533,48839.742180515415,8340840.6107722037,5,10]
[59,345863.71290756867,298703.38744108845,47160.325466480252,8042137.2233311143,5,11]
[60,345863.71290756873,300392.29982139083,45471.41308617789,7741744.9235097244,5,12]
[61,345863.71290756873,302090.76155783801,43772.951349730705,7439654.1619518846,6,1]
[62,345863.71290756867,303798.82664387795,42064.886263690707,7135855.3353080079,6,2]
[63,345863.71290756867,305516.5493782456,40347.163529323094,6830338.7859297637,6,3]
[64,345863.71290756867,307243.98436668859,38619.728540880104,6523094.8015630711,6,4]
[65,345863.71290756873,308981.18652370357,36882.526383865181,6214113.615039371,6,5]
[66,345863.71290756873,310728.21107428154,35135.501833287177,5903385.4039650895,6,6]
[67,345863.71290756867,312485.11355566385,33378.599351904828,5590900.2904094234,6,7]
[68,345863.71290756867,314251.94981910742,31611.763088461263,5276648.3405903131,6,8]
[69,345863.71290756873,316028.77603166027,29834.936875908439,4960619.564558655,6,9]
[70,345863.71290756867,317815.648677947,28048.064229621694,4642803.9158807062,6,10]
[71,345863.71290756873,319612.62456196465,26251.088345604057,4323191.2913187481,6,11]
[72,345863.71290756873,321419.76080888818,24443.95209868054,4001771.5305098556,6,12]
[73,345863.71290756867,323237.11486688664,22626.598040682056,3678534.4156429693,7,1]
[74,345863.71290756873,325064.74450894946,20798.968398619261,3353469.6711340174,7,2]
[75,345863.71290756873,326902.70783472282,18961.005072845906,3026566.9632992931,7,3]
[76,345863.71290756867,328751.06327235675,17112.649635211917,2697815.9000269435,7,4]
[77,345863.71290756867,330609.86958036275,15253.843327205943,2367206.0304465815,7,5]
[78,345863.71290756873,332479.18584948126,13384.527058087471,2034726.8445970938,7,6]
[79,345863.71290756867,334359.0715045603,11504.641403008367,1700367.7730925344,7,7]
[80,345863.71290756873,336249.58630644495,9614.1266011237476,1364118.1867860928,7,8]
[81,345863.71290756873,338150.79035387648,7712.9225536922295,1025967.396432206,7,9]
[82,345863.71290756867,340062.74408540328,5800.9688221654123,685904.65234680846,7,10]
[83,345863.71290756873,341985.50828130217,3878.2046262665485,343919.14406550676,7,11]
[84,345863.71290756873,343919.14406551037,1944.5688420583756,0,7,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]