{"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":217,"n_cols":23,"rows_kept":217,"cut":false,"hidden":false,"merged":[[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],[117,2,117,3],[159,2,159,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]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"MACHINE A GLACE"]
[]
[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,"Machine à glace ZIEGRA ZBE 375",{"$f":"16*I19","v":256},"-",1.7,5100000,{"$f":"E19*I19","v":27.2},{"$f":"E19*I19/K19","v":34},16,365,0.8]
[null,"Machine à glace ZIEGRA ZBE 750",{"$f":"31*I20","v":496},"-",3.1,11000000,{"$f":"E20*I20","v":49.6},{"$f":"E20*I20/K20","v":62},16,365,0.8]
[null,"Machine à glace ZIEGRA ZBE 1000",{"$f":"41.5*I21","v":664},"-",4.3,14000000,{"$f":"E21*I21","v":68.8},{"$f":"E21*I21/K21","v":85.999999999999986},16,365,0.8]
[]
[]
[]
[null,"Usage Productif - complément","Puissance (kW)","Nombre","Consommation énergétique (kWh/jour)","Fonctionnement","Prix (FCFA)"]
[{"$nulls":5},"h/jour"]
[null,"Kit Lorentz PS150 pompe",0.15,1,"-","-",1403000]
[null,"Pompe supresseur et cables",1.1299999999999999,1,{"$f":"C28*F28","v":1.6949999999999998},1.5,550000]
[null,"Ballon Supresseur ",0,1,0,0,225000]
[null,"Refroidisseur",0.1,1,0.15000000000000002,1.5,415000]
[null,"Ventilateurs",6.5000000000000002E-2,1,0.52,8,15000]
[null,"Lampes",1.2E-2,8,0.14400000000000002,12,2500]
[null,"Ensemble prise téléphones",0.1,1,1.2000000000000002,12,32750]
[null,"Kit Congélateur solaire (240L) et hacheur",0.25,1,"-","-"]
[]
[null,"Parafoudre",null,2,null,null,12510]
[null,"Puit ",null,1,null,null,500000]
[null,"Local technique",null,1,null,null,2206450]
[null,"Câbles et accessoires",null,1,null,null,250000]
[null,"Installation & transport équipements",null,1,null,null,1374000]
[null,"Support alluminium",null,"-",null,null,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",{"$nulls":5},"Gel 220Ah 12V",220,360250,12,10]
[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":"F102*INDEX(C:C,MATCH(F76,B:B,0))","v":6.3250000000000002}]
[]
[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,"Victron 8KW",8,{"$nulls":4},"VICTRON MPPT 100/50","100V/50A",null,"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":427.27},{"$f":"SUM(J57:L57)","v":927.27}]
[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":63099.2336},{"$f":"SUM(J58:L58)","v":130597.73360000001}]
[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":427.27},{"$f":"SUM(J59:L59)","v":927.27}]
[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":63765.774799999999},{"$f":"SUM(J60:L60)","v":131358.77480000001}]
[]
[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,"Production min. souhaitée (kg glace/jour)",null,null,null,1]
[null,"Répartition clients pêcheurs/particuliers/autre",null,null,null,0.7,0.15,{"$f":"100%-(F73+G73)","v":0.15000000000000002}]
[]
[null,"Choix de la machine à glace",null,null,null,"Machine à glace ZIEGRA ZBE 375"]
[null,"Choix de l'alimentation solaire",null,null,null,"Modules polycristallins 275 W"]
[null,"Choix du système de stokage",null,null,null,"OPzV 2V"]
[null,"Choix de l'onduleur",null,null,null,"Victron quatro 5 Kw"]
[null,"Choix du régulateur",null,null,null,"VICTRON MPPT 150/85"]
[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:E34)+INDEX(G:G,MATCH(F75,B:B,0))","v":30.908999999999999},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F75,B:B,0))+SUM(E28:E33))/O54*F95","v":6.2743760399334452},"KW"]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(INDEX(G:G,MATCH(F75,B:B,0))+SUM(E28:E33))*1000*(F84)/(F85*I46)","v":804.92187499999989},"Ah"]
[]
[null,"Nb de machines à glace",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:C34))*1.2","v":4.2083999999999993}]
[null,"Nb Kit Lorentz pour pompage",null,null,null,{"$f":"D27","v":1},"unités"]
[null,"Kit Congélateur solaire (240L) et hacheur",null,null,null,{"$f":"D34","v":1},"unités"]
[null,"Nb lampes",null,null,null,{"$f":"D32","v":8},"unités"]
[null,"Nb ensemble prises",null,null,null,{"$f":"D33","v":1},"unités"]
[null,"Nb de ventilateurs",null,null,null,{"$f":"D31","v":1},"unités"]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F92/INDEX(C:C,MATCH(F76,B:B,0)),0)","v":23},"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":2},"unités"]
[null,"Nb de batteries total",null,null,null,{"$f":"F103*F104","v":48},"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,4,"personnes"]
[null,"Extrant annuel attendu en glace",null,null,null,{"$f":"INDEX(C:C,MATCH($F$75,B:B,0))*INDEX(J:J,MATCH($F$75,B:B,0))*F110*F95","v":84096},"Kilos"]
[null,"Intrant annuel attendu en eau",null,null,null,{"$f":"F112","v":84096},"Litres"]
[]
[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,"Transport Glace vers port pêche",{"$f":"(F112*F73)/25","v":2354.6880000000001},"bacs",0,{"$f":"E119*C119","v":0},{"$f":"F119/12","v":0}]
[null,"-",null,null,null,{"$f":"E120*C120","v":0},{"$f":"F120/12","v":0},"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(F144:F149,F154)+SUM(G144:G149,G154))","v":6217148.0889142845}]
[null,"Crédit télephonique",1,"forfait",10000,{"$f":"E121*12","v":120000},{"$f":"F121/12","v":10000},null,null,"Sur 5 ans",{"$f":"((MIN(M60,M58)*12*5)+IF(F81=\"MT\",(G81*D66)+D65+E63+F82,(G81*D66)))-(SUM(F144:F149,F154)+(SUM(G144:G149,G154)*5))","v":9429624.444571428}]
[null,"Salaires",3,{"$f":"G111","v":"personnes"},40000,{"$f":"E122*C122*12","v":1440000},{"$f":"F122/12","v":120000},null,null,"Sur 10 ans",{"$f":"((MIN(M60,M58)*12*10)+IF(F81=\"MT\",(G81*D66)+D65+E63+F82,(G81*D66)))-(SUM(F144:F149,F154)+(SUM(G144:G149,G154)*10))","v":13445219.889142854}]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F119:F122)","v":1560000},{"$f":"SUM(G119:G122)","v":130000}]
[]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"Machine à glace",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F95,'investissement réel'!C4)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(F:F,MATCH(F75,B:B,0)),'investissement réel'!E4)","v":5100000},10,{"$f":"C127*D127","v":5100000},{"$f":"IFERROR(F127/E127,0)","v":510000}]
[null,"Kit Lorentz PS150 Pompe",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F97,'investissement réel'!C5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G27,'investissement réel'!D5)","v":1403000},10,{"$f":"C128*D128","v":1403000},140300]
[null,"Kit congélateur solaire",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F98,'investissement réel'!C6)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G34,'investissement réel'!D6)","v":1248000},10,1248000,124800]
[null,"Pompe surpresseur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D28,'investissement réel'!C7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G28,'investissement réel'!D7)","v":550000},10,550000,55000]
[null,"Ballon surpresseur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D29,'investissement réel'!C8)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G29,'investissement réel'!D8)","v":225000},10,225000,22500]
[null,"Refroidisseur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D30,'investissement réel'!C9)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G30,'investissement réel'!D9)","v":415000},10,415000,41500]
[null,"Puits",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D37,'investissement réel'!C10)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G37,'investissement réel'!D10)","v":500000},null,500000,0]
[null,"Local technique",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D38,'investissement réel'!C11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G38,'investissement réel'!D11)","v":2206450},null,{"$f":"C134*D134*I134","v":882580},0,"Part des locaux dédiée au projet",0.4]
[null,"briques en banco + transport",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C12)","v":27},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G33,'investissement réel'!D12)","v":50000}]
[null,"briques en ciment + transport",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C13)","v":27},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G34,'investissement réel'!D13)","v":17000}]
[null,"Fer et ciment structure",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C14)","v":24},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G35,'investissement réel'!D14)","v":136000}]
[null,"Zinc et ciment structure",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C15)","v":2},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G36,'investissement réel'!D15)","v":315000}]
[null,"Rogniers (11 palmiers)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C16)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G37,'investissement réel'!D16)","v":1426500}]
[null,"Maconnerie",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C17)","v":2},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G38,'investissement réel'!D17)","v":12510}]
[null,"Charpenterie",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C18)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G39,'investissement réel'!D18)","v":15000}]
[null,"Coquillages",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C19)","v":8},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G40,'investissement réel'!D19)","v":2500}]
[null,"Autres équipements & frais",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),96,'investissement réel'!C20)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G41,'investissement réel'!D20)","v":32750}]
[null,"Modules PV ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F102,'investissement réel'!C12)","v":27},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F76,B:B,0)),'investissement réel'!D12)","v":50000},20,1350000,{"$f":"IFERROR(F144/E144,0)","v":67500}]
[null,"Support aluminium",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C144,'investissement réel'!C13)","v":27},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G41,'investissement réel'!D13)","v":17000},20,{"$f":"C145*D145","v":459000},22950]
[null,"Batterie ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F105,'investissement réel'!C14)","v":24},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F77,H:H,0)),'investissement réel'!D14)","v":136000},{"$f":"F106","v":7},3264000,466285.71428571426]
[null,"Régulateur ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F107,'investissement réel'!C15)","v":2},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F79,H:H,0)),'investissement réel'!D15)","v":315000},10,630000,63000]
[null,"Onduleur ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F108,'investissement réel'!C16)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F78,B:B,0)),'investissement réel'!D16)","v":1426500},10,1426500,142650]
[null,"Parafoudre ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D36,'investissement réel'!C17)","v":2},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G36,'investissement réel'!D17)","v":12510},15,25020,1668]
[null,"Ventilateurs",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D31,'investissement réel'!C18)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G31,'investissement réel'!D18)","v":15000},10,15000,1500]
[null,"Lampes",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F99,'investissement réel'!C19)","v":8},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G32,'investissement réel'!D19)","v":2500},1,{"$f":"C151*D151","v":20000},20000]
[null,"Ensemble prise téléphones",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D33,'investissement réel'!C20)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G33,'investissement réel'!D20)","v":32750},15,32750,2183.3333333333335]
[null,"Câbles et accessoires (dijoncteur AC/DC, demarreur electronotique)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D39,'investissement réel'!C21)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G39,'investissement réel'!D21)","v":250000},20,250000,12500]
[null,"Installation & transport équipements",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D40,'investissement réel'!C22)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),G40,'investissement réel'!D22)","v":1374000},0,1374000,0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F127:F154)+1800000","v":20969850},{"$f":"SUM(G127:G154)","v":1694337.0476190476}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité",null,"Prix unitaire","Recettes annuelles","Recettes mensuelles",null,null,null,0.02]
[null,"Vente de glace par bacs 25 Kg",{"$f":"F112*(F73+H73)/25","v":2859.2639999999997},"Bacs",2500,{"$f":"C161*E161","v":7148159.9999999991},{"$f":"F161/12","v":595679.99999999988}]
[null,"Vente de glace au kilo",{"$f":"F112*G73","v":12614.4},"Kilos",150,{"$f":"C162*E162","v":1892160},{"$f":"F162/12","v":157680}]
[null,"Chargement de téléphone",{"$f":"300*20","v":6000},"Recharge",100,{"$f":"C163*E163","v":600000},{"$f":"F163/12","v":50000}]
[null,"TOTAL (F CFA)",null,null,null,{"$f":"SUM(F161:F163)","v":9640320},{"$f":"SUM(G161:G163)","v":803359.99999999988}]
[]
[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,"Transport glace","founisseur",0,1]
[null,"Acheteurs de glace","client",0,1]
[]
[null,"Créances clients",{"$f":"((D171*F164/365*E171))","v":0}]
[null,"Crédit fournisseurs",{"$f":"(D170*F123*E170/365)*-1","v":0}]
[null,"Impact Stocks consommable",0]
[null,"Impact Stocks produits finis",0]
[null,"BFR",20000,"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":"F155","v":20969850},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F182)","v":1941445.8548892296},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F182)","v":2131066.5063908473},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F182)","v":222646288.44205379},{"$f":"G182+H182","v":4072512.3612800771},{"$f":"J182/12","v":339376.03010667308}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C177","v":20000},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F183)","v":2174419.3574759392},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F183)","v":1898093.0038041384},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F183)","v":197860823.99642947},4072512.3612800776,{"$f":"J183/12","v":339376.03010667313}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D182:D183)","v":20989850},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F184)","v":2435349.680373054},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F184)","v":1637162.6809070231},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F184)","v":170101103.81733024},4072512.3612800771,339376.03010667308]
[null,"Apport personnel",{"$f":"D185/D182","v":6.5931802087282457E-2},{"$f":"F133+F134","v":1382580},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F185)","v":2727591.6420178222},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F185)","v":1344920.7192622547},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F185)","v":139010217.21673906},4072512.3612800771,339376.03010667308]
[null,"Subvention",0,{"$f":"C186*D184","v":0},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=5,5,\"-\"))","v":5},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F186)","v":3054902.6390599641},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F186)","v":1017609.7222201133},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F186)","v":104188424.22407688},4072512.3612800771,339376.03010667308]
[null,"Emprunt",{"$f":"100%-C185-C186","v":0.93406819791271756},{"$f":"C187*D182","v":19587270},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=6,6,\"-\"))","v":6},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F187)","v":3421490.9557471629},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F187)","v":651021.40553291445},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F187)","v":65188016.072295219},4072512.3612800771,339376.03010667308]
[null,"Taux  d'interet annuel de l'emprunt %",null,0.12,null,{"$f":"IF($D$189>10,\"nb an insuffisant\",IF($D$189>=7,7,\"-\"))","v":7},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F188)","v":3832069.8704368258},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,F188)","v":240442.49084325158},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,F188)","v":21507558.942299724},4072512.3612800771,339376.03010667308]
[null,"Remboursement de l'emprunt (années)",null,7,null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=7,7,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,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},{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F190)","v":0},0]
[{"$nulls":5},{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F191)","v":0},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G182:G191)","v":19587270},{"$f":"SUM(H182:H191)","v":8920316.5289605428},null,{"$f":"SUM(J182:J191)","v":28507586.528960537},{"$f":"SUM(K182:K191)","v":2375632.2107467116}]
[]
[]
[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  ",null,{"$f":"F164","v":9640320},{"$f":"D199+($K$160*D199)","v":9833126.4000000004},10029788.928000001,10230384.706560001,10434992.4006912,10643692.248705024,10856566.093679124,11073697.415552707,11295171.363863762,{"$f":"SUM(C199:L199)","v":94037739.557051823}]
[null,"Dépenses ",null,{"$f":"F123","v":1560000},{"$f":"D200+($K$118*D200)","v":1591200},1623024,1655484.48,1688594.1695999999,1722366.052992,1756813.37405184,1791949.6415328768,1827788.6343635344,15217220.352540251]
[null,"Amortissements ",0,{"$f":"$G$155","v":1694337.0476190476},{"$f":"$G$155","v":1694337.0476190476},1694337.0476190476,1694337.0476190476,1694337.0476190476,1694337.0476190476,1694337.0476190476,1694337.0476190476,1694337.0476190476,15249033.428571433]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$182:$J$191,MATCH(D198,$F$182:$F$191,0)),0)","v":4072512.3612800771},{"$f":"IFERROR(INDEX($J$182:$J$191,MATCH(E198,$F$182:$F$191,0)),0)","v":4072512.3612800776},4072512.3612800771,4072512.3612800771,4072512.3612800771,4072512.3612800771,4072512.3612800771,0,0,28507586.528960537]
[null,"Bénéfice avant impôts (EBITDA)",0,{"$f":"D199-SUM(D200:D202)","v":2313470.5911008753},{"$f":"E199-SUM(E200:E202)","v":2475076.9911008757},2639915.5191008765,2808050.8176608756,2979548.8221920757,3154476.7868138989,3332903.3107281597,7587410.7264007833,7773045.68188118,35063899.246979602]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D203<0,0,0.3*D203)","v":694041.17733026261},{"$f":"IF(E203<0,0,0.3*E203)","v":742523.09733026265},791974.65573026298,842415.24529826269,893864.64665762265,946343.03604416968,999870.9932184479,2276223.2179202349,2331913.7045643539,10519169.774093879]
[null,"Bénéfice après impôts ",0,{"$f":"D203-D204","v":1619429.4137706128},1732553.893770613,1847940.8633706137,1965635.5723626129,2085684.175534453,2208133.7507697293,2333032.3175097117,5311187.5084805489,5441131.9773168266,24544729.47288572]
[null,"Trésorerie",{"$f":"C199-C200","v":0},{"$f":"C206+D205","v":1619429.4137706128},3351983.307541226,5199924.1709118392,7165559.7432744522,9251243.9188089054,11459377.669578634,13792409.987088345,19103597.495568894,24544729.47288572]
[null,"Cash Flows",0,{"$f":"D205+D202-($H$192/$D$189)","v":4417610.8423420414},{"$f":"E205+E202-($H$192/$D$189)","v":4530735.3223420419},4646122.2919420414,4763817.0009340411,4883865.6041058814,5006315.1793411579,5131213.7460811399,4036856.5757718999,4166801.0446081776]
[null,"Cash Flows cumulés",{"$f":"-C200","v":0},{"$f":"C208+D207","v":4417610.8423420414},8948346.1646840833,13594468.456626125,18358285.457560167,23242151.061666049,28248466.241007209,33379679.987088349,37416536.56286025,41583337.607468426]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F213,IF(D198<=H213,D207,0),IF(E198<=H213,E207,0),IF(F198<=H213,F207,0),IF(G198<=H213,G207,0),IF(H198<=H213,H207,0),IF(I198<=H213,I207,0),IF(J198<=H213,J207,0),IF(K198<=H213,K207,0),IF(L198<=H213,L207,0))-D182","v":11906952.383638356},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D182+IF(H213>=D198,(D205+D202-H192/D189)*((1+F213)^-1),0)+IF(H213>=E198,(E205+E202-H192/D189)*((1+F213)^-2),0)+IF(H213>=F198,(F205+F202-H192/D189)*((1+F213)^-3),0)+IF(H213>=G198,(G205+G202-H192/D189)*((1+F213)^-4),0)+IF(H213>=H198,(H205+H202-H192/D189)*((1+F213)^-5),0)+IF(H213>=I198,(I205+I202-H192/D189)*((1+F213)^-6),0)+IF(H213>=J198,(J205+J202-H192/D189)*((1+F213)^-7),0)+IF(H213>=K198,(K205+K202-H192/D189)*((1+F213)^-8),0)+IF(H213>=L198,(L205+L202-H192/D189)*((1+F213)^-9),0)","v":11906952.38363836},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N214:W214)","v":0.16456717873566085},{"$nulls":10},{"$f":"-D182","v":-20969850},{"$f":"IF(D198<=H213,D207,0)","v":4417610.8423420414},{"$f":"IF(E198<=H213,E207,0)","v":4530735.3223420419},{"$f":"IF(F198<=H213,F207,0)","v":4646122.2919420414},{"$f":"IF(G198<=H213,G207,0)","v":4763817.0009340411},{"$f":"IF(H198<=H213,H207,0)","v":4883865.6041058814},{"$f":"IF(I198<=H213,I207,0)","v":5006315.1793411579},{"$f":"IF(J198<=H213,J207,0)","v":5131213.7460811399},{"$f":"IF(K198<=H213,K207,0)","v":4036856.5757718999},{"$f":"IF(L198<=H213,L207,0)","v":4166801.0446081776}]
[null,"IPI",{"$f":"SUM(O214:W214)/D182","v":1.9830059636796842},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N215,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 983 CFA"},{"$nulls":9},{"$f":"(C215-1)*1000","v":983.00596367968421}]
[null,"DCRI",{"$f":"N216+(-P216/(O216-P216))","v":{"$error":"#N/A"}},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C216,0)&\" ans et \"&ROUNDDOWN((C216-ROUNDDOWN(C216,0))*12,0)&\" mois\"","v":{"$error":"#N/A"}},{"$nulls":9},{"$f":"IF(AND(L208<0,L198<=H213),L198,IF(AND(K208<0,K198<=H213),K198,IF(AND(J208<0,J198<=H213),J198,IF(AND(I208<0,I198<=H213),I198,IF(AND(H208<0,H198<=H213),H198,IF(AND(G208<0,G198<=H213),G198,IF(AND(F208<0,F198<=H213),F198,IF(AND(E208<0,E198<=H213),E198,IF(AND(D208<0,D198<=H213),D198,IF(AND(C208<0,C198<=H213),C198))))))))))","v":false},{"$f":"INDEX(C208:L208,MATCH(INDEX(C198:L198,MATCH(P216,C208:L208,0))+1,C198:L198,0))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L208<0,L198<=H213),L208,IF(AND(K208<0,K198<=H213),K208,IF(AND(J208<0,J198<=H213),J208,IF(AND(I208<0,I198<=H213),I208,IF(AND(H208<0,H198<=H213),H208,IF(AND(G208<0,G198<=H213),G208,IF(AND(F208<0,F198<=H213),F208,IF(AND(E208<0,E198<=H213),E208,IF(AND(D208<0,D198<=H213),D208,IF(AND(C208<0,C198<=H213),C208))))))))))","v":false}]
[null,"DSCR",{"$f":"(D199-D200)/(D202)","v":1.9841118413352548}]

{"sheet":"investissement réel","index":1,"n_rows":23,"n_cols":9,"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,"Machine à glace",1,5100000,{"$f":"C4*D4","v":5100000},10,510000]
[null,"Kit Lorentz PS150 Pompe",1,1403000,{"$f":"C5*D5","v":1403000},10,140300]
[null,"Kit congélateur solaire",1,1248000,1248000,10,124800]
[null,"Pompe surpresseur",1,550000,550000,10,55000]
[null,"Ballon surpresseur",1,225000,225000,10,22500]
[null,"Refroidisseur",1,415000,415000,10,41500]
[null,"Puits",1,500000,500000,30,16666.666666666668]
[null,"Local technique",1,2206450,{"$f":"C11*D11*I11","v":882580},30,29419.333333333332,"Part des locaux dédiée au projet",0.4]
[null,"Modules PV ",27,50000,1350000,20,67500]
[null,"Support aluminium",27,17000,459000,20,22950]
[null,"Batterie ",24,136000,3264000,7,466285.71428571426]
[null,"Régulateur ",2,315000,630000,10,63000]
[null,"Onduleur ",1,1426500,{"$f":"C16*D16","v":1426500},10,142650]
[null,"Parafoudre ",2,12510,25020,15,1668]
[null,"Ventilateurs",1,15000,15000,10,1500]
[null,"Lampes",8,2500,20000,1,20000]
[null,"Ensemble prise téléphones",1,32750,32750,15,2183.3333333333335]
[null,"Câbles et accessoires ",1,250000,{"$f":"C21*D21","v":250000},20,12500]
[null,"Installation & transport équipements",1,1374000,1374000,0,0]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E4:E22)+1800000","v":20969850},null,{"$f":"SUM(G4:G22)","v":1740423.0476190476}]

{"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é'!D188","v":0.12}]
["Capital emprunté",{"$f":"'Table rentabilité optimisé'!D187","v":19587270}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité optimisé'!D189","v":7},{"$f":"B4*12","v":84}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":339376.03010667313},"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":153516.48092290264},"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":185859.54918377046},"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":339376.03010667313},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":153516.48092290264},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":185859.54918377046},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":19433753.519077096},{"$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},339376.03010667313,{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":154973.16702242594},184402.86308424716,19278780.35205467,{"$f":"IF(A15<>\"-\",IF(G14<G15,F14,F14+1),\"\")","v":1},{"$f":"IF(A15=\"-\",\"\",IF(G14<12,G14+1,1))","v":2}]
[3,339376.03010667308,{"$f":"IF(A16<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A16,$B$4*12,$B$3),\"\")","v":156443.67531471828},182932.3547919548,19122336.676739953,1,3]
[4,339376.03010667313,157928.1369557048,181447.8931509683,18964408.539784249,1,4]
[5,339376.03010667313,159426.68434582194,179949.34576085117,18804981.855438426,1,5]
[6,339376.03010667313,160939.4511418266,178436.5789648465,18644042.404296599,1,6]
[7,339376.03010667313,162466.57226871685,176909.45783795626,18481575.832027882,1,7]
[8,339376.03010667313,164008.18393176617,175367.84617490694,18317567.648096118,1,8]
[9,339376.03010667313,165564.42362867171,173811.60647800143,18152003.224467445,1,9]
[10,339376.03010667313,167135.43016181776,172240.59994485535,17984867.794305626,1,10]
[11,339376.03010667313,168721.3436506557,170654.68645601743,17816146.450654972,1,11]
[12,339376.03010667313,170322.30554420143,169053.7245624717,17645824.145110771,1,12]
[13,339376.03010667308,171938.45863365111,167437.57147302196,17473885.686477117,2,1]
[14,339376.03010667313,173569.94706511722,165806.08304155592,17300315.739412002,2,2]
[15,339376.03010667313,175216.91635248464,164159.11375418847,17125098.823059518,2,3]
[16,339376.03010667313,176879.51339038953,162496.51671628357,16948219.309669126,2,4]
[17,339376.03010667308,178557.88646732073,160818.14363935235,16769661.423201807,2,5]
[18,339376.03010667313,180252.18527884595,159123.84482782715,16589409.237922961,2,6]
[19,339376.03010667313,181962.56094096301,157413.46916571012,16407446.676981997,2,7]
[20,339376.03010667308,183689.16600357823,155686.86410309485,16223757.510978419,2,8]
[21,339376.03010667313,185432.15446411245,153943.87564256066,16038325.356514307,2,9]
[22,339376.03010667313,187191.68178123605,152184.34832543708,15851133.674733071,2,10]
[23,339376.03010667313,188967.90488873457,150408.12521793856,15662165.769844336,2,11]
[24,339376.03010667313,190760.98220950575,148615.04789716739,15471404.787634831,2,12]
[25,339376.03010667313,192571.07366968942,146804.95643698369,15278833.71396514,3,1]
[26,339376.03010667313,194398.34071293144,144977.68939374166,15084435.373252209,3,2]
[27,339376.03010667313,196242.94631478298,143133.08379189012,14888192.426937427,3,3]
[28,339376.03010667313,198105.05499723644,141270.97510943667,14690087.371940192,3,4]
[29,339376.03010667313,199984.83284339943,139391.19726327367,14490102.539096791,3,5]
[30,339376.03010667302,201882.44751230758,137493.58259436546,14288220.091584483,3,6]
[31,339376.03010667313,203798.06825387877,135577.96185279437,14084422.023330605,3,7]
[32,339376.03010667313,205731.86592400784,133644.16418266529,13878690.157406595,3,8]
[33,339376.03010667308,207684.01299980612,131692.01710686696,13671006.144406792,3,9]
[34,339376.03010667313,209654.68359498453,129721.34651168859,13461351.460811807,3,10]
[35,339376.03010667313,211644.05347538288,127731.97663129022,13249707.407336423,3,11]
[36,339376.03010667313,213652.30007464663,125723.73003202649,13036055.107261777,3,12]
[37,339376.03010667313,215679.60251005233,123696.42759662078,12820375.504751723,4,1]
[38,339376.03010667313,217726.1415984834,121649.88850818972,12602649.363153242,4,2]
[39,339376.03010667308,219792.0998725571,119583.93023411599,12382857.263280682,4,3]
[40,339376.03010667313,221877.661596905,117498.3685097681,12160979.601683777,4,4]
[41,339376.03010667308,223983.0127846075,115393.01732206556,11936996.588899171,4,5]
[42,339376.03010667308,226108.3412137847,113267.68889288839,11710888.247685388,4,6]
[43,339376.03010667308,228253.83644434437,111122.19366232872,11482634.411241041,4,7]
[44,339376.03010667313,230419.68983488897,108956.34027178417,11252214.721406154,4,8]
[45,339376.03010667313,232606.09455978306,106769.93554689005,11019608.626846369,4,9]
[46,339376.03010667313,234813.24562638294,104562.78448029021,10784795.381219987,4,10]
[47,339376.03010667313,237041.33989242904,102334.69021424408,10547754.041327558,4,11]
[48,339376.03010667313,239290.57608360445,100085.4540230687,10308463.465243952,4,12]
[49,339376.03010667308,241561.15481125881,97814.875295414269,10066902.310432695,5,1]
[50,339376.03010667313,243853.2785903016,95522.7515163715,9823049.0318423938,5,2]
[51,339376.03010667313,246167.15185726419,93208.87824940891,9576881.8799851276,5,3]
[52,339376.03010667313,248502.98098853382,90873.049118139286,9328378.8989965953,5,4]
[53,339376.03010667313,250860.97431876065,88515.055787912468,9077517.9246778339,5,5]
[54,339376.03010667308,253241.34215943911,86134.687947233979,8824276.582518395,5,6]
[55,339376.03010667308,255644.29681766589,83731.73328900717,8568632.285700731,5,7]
[56,339376.03010667308,258070.05261507584,81305.977491597252,8310562.2330856547,5,8]
[57,339376.03010667313,260518.82590695727,78857.204199715838,8050043.4071786962,5,9]
[58,339376.03010667308,262990.83510154905,76385.195005124042,7787052.5720771477,5,10]
[59,339376.03010667308,265486.3006795207,73889.729427152371,7521566.271397626,5,11]
[60,339376.03010667313,268005.4452136372,71370.584893035935,7253560.8261839915,5,12]
[61,339376.03010667308,270548.49338861008,68827.536718062998,6983012.3327953778,6,1]
[62,339376.03010667308,273115.67202113802,66260.358085535059,6709896.6607742421,6,2]
[63,339376.03010667313,275707.21008013614,63668.820026536989,6434189.4506941047,6,3]
[64,339376.03010667313,278323.33870715811,61052.691399514995,6155866.1119869463,6,4]
[65,339376.03010667313,280964.29123701219,58411.738869660941,5874901.8207499348,6,5]
[66,339376.03010667308,283630.30321857205,55745.726888101046,5591271.5175313596,6,6]
[67,339376.03010667313,286321.61243578611,53054.417670887022,5304949.9050955772,6,7]
[68,339376.03010667313,289038.45892888523,50337.571177787904,5015911.4461666923,6,8]
[69,339376.03010667313,291781.0850157924,47594.945090880727,4724130.361150898,6,9]
[70,339376.03010667313,294549.7353137352,44826.294792937908,4429580.6258371621,6,10]
[71,339376.03010667313,297344.6567610635,42031.373345609616,4132235.9690760989,6,11]
[72,339376.03010667313,300166.0986392739,39209.931467399227,3832069.8704368267,6,12]
[73,339376.03010667308,303014.31259524357,36361.717511429524,3529055.5578415804,7,1]
[74,339376.03010667313,305889.55266367487,33486.477442998235,3223166.0051779058,7,2]
[75,339376.03010667313,308792.07528975274,30583.954816920395,2914373.9298881534,7,3]
[76,339376.03010667313,311722.13935201737,27653.890754655749,2602651.7905361354,7,4]
[77,339376.03010667313,314680.00618545391,24696.023921219214,2287971.784350682,7,5]
[78,339376.03010667313,317665.93960480101,21710.090501872128,1970305.8447458856,7,6]
[79,339376.03010667313,320680.20592808072,18695.824178592411,1649625.6388177983,7,7]
[80,339376.03010667313,323723.07400035171,15652.956106321404,1325902.5648174509,7,8]
[81,339376.03010667313,326794.81521768775,12581.214888985356,999107.74959976599,7,9]
[82,339376.03010667308,329895.70355138369,9480.3265552893899,669212.04604838043,7,10]
[83,339376.03010667313,333026.01557239139,6350.0145342817177,336186.03047598898,7,11]
[84,339376.03010667308,336186.03047598701,3189.9996306860667,-3.7252902984619141E-9,7,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]