{"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":1,"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":285,"n_cols":23,"rows_kept":285,"cut":false,"hidden":false,"merged":[[154,1,155,1],[154,2,154,4],[154,5,154,7],[14,3,15,3],[63,1,64,1],[65,1,66,1],[63,7,64,7],[65,7,66,7],[87,5,87,6],[14,2,15,2],[14,4,14,5],[117,2,117,3],[91,5,91,6],[100,5,100,6],[14,6,14,7],[14,8,15,8],[14,9,14,10],[14,12,15,12],[14,11,15,11],[14,13,14,15],[271,8,272,8],[274,8,275,8],[254,1,254,3],[254,4,254,7],[254,8,254,10]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Pôle multiservice paysans PMP"]
[]
[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","Selection","Nb applications","Capacité",null,"Puissance (kW)",null,"Prix (FCFA)","Production",null,"Energie consommée (KWh/j)","Energie à produire (kWh/j)","Fonctionnement optimal",null,null,"Coefficient déperdition (k)"]
[{"$nulls":4},"Quantité","Unité","Nominale","Absorbée",null,"Produit final","Tourteaux",null,null,"heures par jour pointe","heures par jour moyen","jours à l'année"]
[null,"Moulin à grains, 250 Kg/h","oui",1,250,"kg/h",4.6859999999999999,4.6859999999999999,1000000,1,0,{"$f":"H17*N17*D17","v":18.744},{"$f":"(H17*N17*D17)/Q17","v":26.777142857142859},4,4,300,0.7]
[null,"Moulin à grains, 125 Kg/h",null,null,300,"kg/h",2.2000000000000002,2.2000000000000002,700000]
[null,"Décortiqueuse électrique 150 Kg/h","oui",1,150,"kg/h",4.4000000000000004,4.4000000000000004,1000000,0.9,0.1,{"$f":"H19*N19*D19","v":17.600000000000001},{"$f":"(H19*N19*D19)/Q19","v":25.142857142857146},4,3,300,0.7]
[null,"Décortiqueuse électrique 75 Kg/h",null,null,150,"kg/h",2.2000000000000002,2.2000000000000002,700000]
[null,"Vibro-tamiseur 800 Kg/h","oui",1,800,"kg/h",0.4,0.4,1500000,"-","-",{"$f":"H21*N21*D21","v":2.4000000000000004},{"$f":"(H21*N21*D21)/Q21","v":3.4285714285714293},6,5,200,0.7]
[null,"Vibro-tamiseur 400 Kg/h",null,null,400,"kg/h",0.3,0.3,900000]
[null,"Congélateur 360L","non",1,200,"L/j",0.15,0.15,400000,"-","-",{"$f":"H23*N23*D23","v":3.5999999999999996},6,24,"-",300,0.6]
[null,"Téléviseur","non",1,"-","-",0.15,0.15,300000,"-","-",1.7999999999999998,3,12,8,300,0.6]
[null,"Banc de recharge de smartphone","oui",1,25,"téléphones/h",{"$f":"0.01*E25","v":0.25},{"$f":"G25","v":0.25},20000,"-","-",1,1.4285714285714286,4,5,300,0.7]
[null,"Pompe solaire (modèle Lorentz PS2-150 Boost-60)","non",2,1.3,"m3/h",0.3,0.3,1000000,"-","-",3,5,5,1,300,0.6]
[null,"Ordinateur","non",1,"-","-",0.1,0.1,500000,"-","-",{"$f":"H27*N27*D27","v":0},0,0,6,300,0.7]
[null,"Photocopieuse","non",1,"-","-",0.15,0.15,500000,"-","-",0.15,0.25,1,1,300,0.6]
[null,"Combiné bois menuisier","non",1,"-","-",1.5,1.5,2400000,"-","-",12,20,8,3,140,0.6]
[null,"Thermo-soudeur","non",1,"-","-",null,null,0,"-","-",0,{"$f":"(H30*N30*D30)/Q30","v":0},8,8,140,0.6]
[null,"Tisse sac","oui",1,"-","-",0.25,0.25,150000,{"$nulls":4},1,1,300,0.7]
[]
[null,"Éclairage","oui",3,"-","-",1.0999999999999999E-2,1.0999999999999999E-2,1500,"-","-",0.32999999999999996,0.47142857142857142,10,6,300,0.7]
[null,"Support aluminium","oui",{"$f":"C135","v":54},"-","-",null,null,35000]
[null,"Démarreur/variateur","oui",1,"-","-"]
[null,"Parafoudre ","oui",1,"-","-",null,null,140000]
[null,"Câbles et accessoires & installation int.","oui",1,"-","-",null,null,1000000]
[null,"Batiment","oui",1,"-","-",null,null,10000000]
[null,"Local batteries","oui",1,"-","-",null,null,1000000]
[null,"Installation","oui",1,"-","-",null,null,1000000]
[null,"Coffret DC"]
[null,"Coffret AC"]
[null,"Ensemble mise à la terre ",null,1,{"$nulls":4},161755]
[null,"Coffret pour batteries",null,1,{"$nulls":4},{"$f":"9112*F107","v":218688}]
[]
[]
[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 PV  (375 Wc) Polycristallin",0.375,78148,0.6,"24V",null,"Victron Energy Gel",220,400000,12,7]
[null,"BlueSolar SPM-300-24 Monocristallin",0.3,300000,0.6,"24V",null,"GEL HOPPECKE 6 OPzV 370",400,{"$f":"660*655","v":432300},6,10]
[null,"Tension nécessaire alimentation solaire",{"$f":"IF(J52<0.5,\"12V\",IF(AND(J52>=0.5,J52<2),\"24V\",IF(J52>=2,\"48V\")))","v":"48V"},{"$nulls":4},"Batteries OPZS 1220 (Ah)",1220,194400.625,2,12]
[{"$nulls":7},"Victron Energy Gel 2",265,580000,12,7]
[{"$nulls":7},"Tension nécessaire batteries",{"$f":"IF(J52<0.5,12,IF(AND(J52>=0.5,J52<2),24,IF(J52>=2,48)))","v":48},{"$f":"F104*INDEX(C:C,MATCH(F81,B:B,0))","v":10.125}]
[]
[null,"Onduleur chargeur ","kVa","Prix (FCFA)",null,null,null,"Regulateur/Onduleur reseau",null,"Prix (FCFA)","Tension (V)"]
[null,"Vitron Energy Phoenix",2,450000,null,null,null,"Onduleur reseau 20 KW",null,1870329,"12V/24V/48V"]
[null,"Convertisseur chargeur victron  8KVA",8,1660376,null,null,null,"Régulateur Victron Smart bluesolar MPPT 150V ; 85A",null,316410,"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,{"$f":"IF('Table rentabilité optimisé'!G95=\"x\",MAX(C60:N60),IF('Table rentabilité optimisé'!G96=\"x\",MIN(C60:N60),IF('Table rentabilité optimisé'!G97=\"x\",AVERAGE(C60:N60),\"erreur\")))","v":5.8421666666666674}]
[]
[null,"Électricité du réseau"]
[null,"Frais variables d'utilisation 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":"(F100*30)-SUM(K64:L64)","v":50},{"$f":"IF((F100*30)>D64,(F100*30)-D64-L64,0)","v":450},{"$f":"IF((F100*30)>E64,(F100*30)-E64,0)","v":702.22},{"$f":"SUM(J64:L64)","v":1202.22}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J64*D65","v":6442.5},{"$f":"K64*E65","v":61056},{"$f":"L64*F65","v":103703.84960000002},{"$f":"SUM(J65:L65)","v":171202.34960000002}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F100*30)-SUM(K66:L66)","v":100},{"$f":"IF((F100*30)>D66,(F100*30)-D66-L66,0)","v":400},{"$f":"IF((F100*30)>E66,(F100*30)-E66,0)","v":702.22},{"$f":"SUM(J66:L66)","v":1202.22}]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J66*D67","v":12981},{"$f":"K66*E67","v":54612},{"$f":"L66*F67","v":104799.31280000001},{"$f":"SUM(J67:L67)","v":172392.31280000001}]
[]
[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,"Commandes annuelles totales de mil",{"$nulls":4},"Tonnes"]
[]
[null,"Choix de l'alimentation solaire",null,null,null,"Modules PV  (375 Wc) Polycristallin"]
[null,"Choix du système de stokage",null,null,null,"Batteries OPZS 1220 (Ah)"]
[null,"Choix de l'onduleur reseau ",null,null,null,"Onduleur reseau 20 KW"]
[null,"Choix de l'onduleur chargeur ",null,null,null,"Convertisseur chargeur victron  8KVA"]
[null,"Choix de la decortiqueuse",null,null,null,"Décortiqueuse électrique 150 Kg/h"]
[null,"Choix du moulin",null,null,null,"Moulin à grains, 250 Kg/h"]
[null,"Choix du vibro tamisseur",null,null,null,"Vibro-tamiseur 800 Kg/h"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M65<M67,B64,B66)","v":"UP-Petite Puissance"}]
[null,"Raccordement nécessaire (MT, BT) et distance",null,null,null,"MT",600]
[null,"Montant Frais HTA et KG câble",null,null,null,4462549,33]
[]
[null,"Autonomie nécessaires au projet (jours)",null,null,null,0.9]
[null,"Profondeur décharge batteries",null,null,null,0.7]
[]
[null,"Choix du cas pour dimensionnement solaire",null,null,null,"best case"]
[{"$nulls":5},"worst case"]
[{"$nulls":5},"average","x"]
[]
[null,"Puissance Equipements ",null,null,null,{"$f":"(G17+G19+G21+G23+G25+G33)*1.2","v":11.8764},"KW"]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"SUMIF(C17:C33,\"oui\",L17:L33)","v":40.073999999999998},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"SUMIF(C17:C33,\"oui\",M17:M33)/O60","v":9.7992020246891443}]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"SUMIF(C17:C33,\"oui\",L17:L33)*1000*(F92)/(F93*I52)","v":1073.4107142857144}]
[]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F101/INDEX(C:C,MATCH(F81,B:B,0)),0)","v":27},"unités"]
[null,"Nb de batteries en série",null,null,null,{"$f":"ROUNDUP(I52/INDEX(K:K,MATCH(F82,H:H,0)),0)","v":24},"unités"]
[null,"Nb de batteries en dérivation",null,null,null,{"$f":"ROUNDUP(F102/INDEX(I:I,MATCH(F82,H:H,0)),0)","v":1},"unités"]
[null,"Nb de batteries total",null,null,null,{"$f":"F105*F106","v":24},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,{"$f":"INDEX(L:L,MATCH(F82,H:H,0))*(130%-F93)","v":7.2000000000000011},"ans"]
[null,"Convertisseur chargeur victron  8KVA",null,null,null,{"$f":"ROUNDUP(F99/INDEX(C:C,MATCH(F84,B:B,0)),0)","v":2},"unités"]
[null,"Nbre regulateur ",null,null,null,{"$f":"IF(OR(C50=24,C50=12),1,2)","v":2},"unités"]
[null,"Nb régulateurs",{"$nulls":4},"unités"]
[]
[null,"Employés nécessaires pour fonctionnement",null,null,null,4,"personnes"]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION"]
[null,"Désignation","Quantité",null,"Prix unitaire","Montant total/an",null,"évolution annuelle charges d'exploitation",null,null,0.03]
[null,"Achat mil tamisé paysan",{"$f":"F79*1000","v":0},"Kilos",180,{"$f":"E119*C119","v":0}]
[null,"Cout de mise en sac",{"$f":"C119","v":0},"Kilos",5,{"$f":"E120*C120","v":0},null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"((MIN(M67,M65)*12)+IF(F89=\"MT\",(G89*D73)+D72+E70+F90,(G89*D73)))-(SUM(F135:F144,F149)+SUM(G135:G144,G149))","v":-11140969.278609518}]
[null,"Cout de tamisage manuel",0,"Kilos",2.5,{"$f":"E121*C121","v":0},null,null,null,"Sur 5 ans",{"$f":"((MIN(M67,M65)*12*5)+IF(F89=\"MT\",(G89*D73)+D72+E70+F90,(G89*D73)))-(SUM(F135:F144,F149)+(SUM(G135:G144,G149)*5))","v":-11170062.393047608}]
[null,"Paiement opérateurs",{"$f":"SUM(C157:C162)","v":1235000},"Kilos",3,{"$f":"E122*C122","v":3705000},null,null,null,"Sur 10 ans",{"$f":"((MIN(M67,M65)*12*10)+IF(F89=\"MT\",(G89*D73)+D72+E70+F90,(G89*D73)))-(SUM(F135:F144,F149)+(SUM(G135:G144,G149)*10))","v":-11206428.786095217}]
[null,"Entretien/maintenance",6,null,125000,{"$f":"E123*C123","v":750000}]
[null,"Salaires gestion plateforme",1,{"$f":"G113","v":"personnes"},50000,{"$f":"E124*C124*12","v":600000}]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F119:F124)","v":5055000}]
[]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,{"$f":"B17","v":"Moulin à grains, 250 Kg/h"},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D17,'investissement réel'!B4)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(I:I,MATCH(F86,B:B,0)),'investissement réel'!C4)","v":1000000},15,{"$f":"C129*D129","v":1000000},{"$f":"IFERROR(F129/E129,0)","v":66666.666666666672}]
[null,{"$f":"B23","v":"Congélateur 360L"},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D23,'investissement réel'!B5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I23,'investissement réel'!C5)","v":400000},7,{"$f":"C130*D130","v":400000},{"$f":"IFERROR(F130/E130,0)","v":57142.857142857145}]
[null,{"$f":"B25","v":"Banc de recharge de smartphone"},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D25,'investissement réel'!B6)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I25,'investissement réel'!C6)","v":20000},10,20000,2000]
[null,{"$f":"B19","v":"Décortiqueuse électrique 150 Kg/h"},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D19,'investissement réel'!B7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(I:I,MATCH(F85,B:B,0)),'investissement réel'!C7)","v":1000000},15,1000000,66666.666666666672]
[null,"Vibro-tamiseur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D21,'investissement réel'!B8)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(I:I,MATCH(F87,B:B,0)),'investissement réel'!C8)","v":1300000},15,1300000,86666.666666666672]
[null,"Éclairage",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D33,'investissement réel'!B9)","v":3},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I33,'investissement réel'!C9)","v":1500},2,4500,2250]
[null,"Modules  PV 375 W ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F104,'investissement réel'!B10)","v":54},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F81,B:B,0)),'investissement réel'!C10)","v":78148.148148148102},20,4219999.9999999972,210999.99999999985]
[null,"Batteries OPZS 1220 (Ah)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F107,'investissement réel'!B12)","v":48},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F82,H:H,0)),'investissement réel'!C12)","v":194400.625},10,9331230,933123]
[null,"Onduleur reseau 20 KW",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),0,'investissement réel'!B11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),0,'investissement réel'!C11)","v":1870329},7,1870329,267189.85714285716]
[null,"Support aluminium",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D34,'investissement réel'!B22)","v":14},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I34,'investissement réel'!C22)","v":82500},10,1155000,115500]
[null,"Convertisseur chargeur victron  8KVA",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F109,'investissement réel'!B13)","v":3},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F84,B:B,0)),'investissement réel'!C13)","v":1660376},15,4981128,332075.2]
[null,"Coffret DC",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D41,'investissement réel'!B14)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I41,'investissement réel'!C14)","v":275563},15,275563,18370.866666666665]
[null,"Coffret AC",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D42,'investissement réel'!B15)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I42,'investissement réel'!C15)","v":1049763},20,1049763,52488.15]
[null,"Démarreur/variateur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D35,'investissement réel'!B23)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I35,'investissement réel'!C23)","v":925000},10,925000,92500]
[null,"Parafoudre ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D36,'investissement réel'!B24)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I36,'investissement réel'!C24)","v":140000},7,140000,20000]
[null,"Câbles et accessoires & installation int.",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D37,'investissement réel'!B16)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I37,'investissement réel'!C16)","v":583632},30,583632,19454.400000000001]
[null,"Ensemble mise à la terre ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D43,'investissement réel'!B17)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I43,'investissement réel'!C17)","v":161755},30,161755,5391.833333333333]
[null,"Coffret pour batteries",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D43,'investissement réel'!B18)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I44,'investissement réel'!C18)","v":437401},30,437401,14580.033333333333]
[null,"Batiment",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D38,'investissement réel'!B19)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I38,'investissement réel'!C19)","v":10000000},null,{"$f":"C147*D147","v":10000000},0]
[null,"Local batteries",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D39,'investissement réel'!B20)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I39,'investissement réel'!C20)","v":1149167},15,1149167,76611.133333333331]
[null,"Installation",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D40,'investissement réel'!B21)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I40,'investissement réel'!C21)","v":1370600},null,{"$f":"C149*D149","v":1370600},0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F129:F149)","v":41375068},{"$f":"SUM(G129:G149)","v":2439677.3309523808}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Modèle 1",null,null,"Modèle 2",null,null,"Choix modèle","Recettes annuelles",null,"évolution annuelle recettes d'exploitation",null,null,0.03]
[null,null,"Quantité","Unité","Prix unitaire","Quantité","Unité","Prix unitaire"]
[null,"Service tamisage (inclus prix rachat)",{"$f":"E21*O21*P21","v":800000},"Kg",10,null,null,null,1,{"$f":"IF(I157=1,C157*E157,IF(I157=2,F157*H157,0))","v":8000000}]
[null,"Vente de mil tamisé",0,"Kg",230,null,null,null,1,{"$f":"IF(I158=1,C158*E158,IF(I158=2,F158*H158,0))","v":0}]
[null,"Vente de mil tamisé décortiqué",0,"Kg",300,null,null,null,1,{"$f":"IF(I159=1,C159*E159,IF(I159=2,F159*H159,0))","v":0}]
[null,"Vente de farine de mil",0,"Kg",500,null,null,null,1,{"$f":"IF(I160=1,C160*E160,IF(I160=2,F160*H160,0))","v":0}]
[null,"Service décorticage",{"$f":"E19*O19*P19","v":135000},"Kg",15,null,null,null,1,{"$f":"IF(I161=1,C161*E161,IF(I161=2,F161*H161,0))","v":2025000}]
[null,"Service mouture",{"$f":"E17*O17*P17","v":300000},"Kg",15,null,null,null,1,4500000]
[null,"TOTAL (F CFA)",{"$nulls":7},{"$f":"SUM(J157:J162)","v":14525000}]
[]
[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,"Fournisseurs matières","founisseur",0,1]
[null,"Acheteurs services","client",0,0.5]
[null,"Stocks de consommable",null,30,0]
[null,"Stocks de produits finis",null,30,0]
[]
[null,"Créances clients",0]
[null,"Crédit fournisseurs",{"$f":"(D170*J163*E170/365)*-1","v":0}]
[null,"Impact Stocks consommable",{"$f":"F119*D171/365","v":0}]
[null,"Impact Stocks produits finis",{"$f":"(J158*D172/365)","v":0}]
[null,"BFR",{"$f":"SUM(C174:C177)","v":0},"F CFA"]
[]
[]
[null,"SCHÉMA DE FINANCEMENT",null,null,null,"ECHEANCIER DE REMBOURSEMENT"]
[null,"Désignation ","Part","Montant total TTC",null,"Année","Capital","Intérêts","Reste","Annuité"]
[null,"Investissements",null,30080000,null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":2174431.7899257452},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":3246324.3605359127},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":274935886.85299492},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":5420756.1504616579}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C178","v":0},null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":2500596.5584146101},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":2920159.5920470478},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":246767888.40183517},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":5420756.1504616588}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D183:D184)","v":30080000},null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":2875686.042176805},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":2545070.1082848534},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":214374690.18300146},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":5420756.1504616588}]
[null,"Apport personnel",0.2,{"$f":"C186*D185","v":6016000},null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":3307038.9485033294},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":2113717.201958329},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":177122512.23134261},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":5420756.1504616588}]
[null,"Subvention",0,{"$f":"C187*D185","v":0},null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=5,5,\"-\"))","v":5},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":3803094.790778833},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":1617661.3596828259},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":134282507.58693492},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":5420756.1504616588}]
[null,"Emprunt",{"$f":"100%-C187-C186","v":0.8},{"$f":"D185*C188","v":24064000},null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=6,6,\"-\"))","v":6},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":4373559.0093956627},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":1047197.1410659954},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":85016502.24586603},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":5420756.1504616588}]
[null,"Taux de l'emprunt",null,0.15,null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=7,7,\"-\"))","v":7},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":5029592.8608050179},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":391163.28965664038},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":28360596.103636719},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":5420756.1504616579}]
[null,"Remboursement de l'emprunt (années)",null,7,null,{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=8,8,\"-\"))","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}]
[{"$nulls":5},{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=9,9,\"-\"))","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}]
[{"$nulls":5},{"$f":"IF(D190>10,\"nb an insuffisant\",IF(D190>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F192)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F192)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F192)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F192)","v":0}]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G183:G192)","v":24064000.000000007},{"$f":"SUM(H183:H192)","v":13881293.053231606},{"$f":"SUM(I183:I192)","v":1160860583.6056118},{"$f":"SUM(J183:J192)","v":37945293.053231612}]
[]
[]
[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":"D188+D186","v":30080000},{"$f":"J163","v":14525000},{"$f":"D200+($O$155*D200)","v":14960750},{"$f":"E200+($O$155*E200)","v":15409572.5},15871859.675000001,16348015.46525,16838455.9292075,17343609.607083727,17863917.895296238,18399835.432155125,{"$f":"SUM(C200:L200)","v":177641016.50399262}]
[null,"Dépenses ",{"$f":"D183","v":30080000},{"$f":"F125","v":5055000},{"$f":"D201+($K$118*D201)","v":5206650},{"$f":"E201+($K$118*E201)","v":5362849.5},{"$f":"F201+($K$118*F201)","v":5523734.9850000003},{"$f":"G201+($K$118*G201)","v":5689447.03455},5860130.4455864998,6035934.3589540944,6217012.389722717,6403522.7614143984,81434281.475227714]
[null,"Amortissements ",0,{"$f":"G150","v":2439677.3309523808},400000,400000,400000,400000,400000,400000,400000,400000,5639677.3309523808]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$183:$J$192,MATCH(D199,$F$183:$F$192,0)),0)","v":5420756.1504616579},{"$f":"IFERROR(INDEX($J$183:$J$192,MATCH(E199,$F$183:$F$192,0)),0)","v":5420756.1504616588},5420756.1504616588,5420756.1504616588,5420756.1504616588,5420756.1504616588,5420756.1504616579,0,0,37945293.053231612]
[null,"Bénéfice avant impôts ",0,{"$f":"D200-SUM(D201:D203)","v":1609566.5185859613},{"$f":"E200-SUM(E201:E203)","v":3933343.8495383412},4225966.8495383412,4527368.5395383425,4837812.2802383415,5157569.3331593424,5486919.0976679735,11246905.505573522,11596312.670740727,52621764.644580886]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D204<0,0,0.3*D204)","v":482869.95557578839},{"$f":"IF(E204<0,0,0.3*E204)","v":1180003.1548615023},1267790.0548615023,1358210.5618615027,1451343.6840715024,1547270.7999478027,1646075.7293003921,3374071.6516720564,3478893.8012222182,15786529.393374268]
[null,"Bénéfice après impôts ",0,{"$f":"D204-D205","v":1126696.5630101729},{"$f":"E204-E205","v":2753340.6946768388},2958176.7946768389,3169157.9776768396,3386468.5961668389,3610298.5332115395,3840843.3683675816,7872833.8539014664,8117418.8695185091,36835235.251206629]
[null,"Trésorerie",{"$f":"C200-C201","v":0},{"$f":"C207+D206","v":1126696.5630101729},3880037.2576870117,{"$f":"E207+F206","v":6838214.0523638502},10007372.030040689,{"$f":"G207+H206","v":13393840.626207527},17004139.159419067,20844982.52778665,28717816.381688118,36835235.251206629]
[null,"Cash Flows",0,{"$f":"D206+D203-($H$193/$D$190)","v":4564410.8487244584},{"$f":"E206+E203-($H$193/$D$190)","v":6191054.9803911252},6395891.0803911248,6606872.263391125,6824182.8818811243,7048012.8189258268,7278557.6540818671,5889791.9891540939,6134377.0047711367]
[null,"Cash Flows cumulés",{"$f":"-C201","v":-30080000},{"$f":"C209+D208","v":-25515589.151275542},{"$f":"D209+E208","v":-19324534.170884416},{"$f":"E209+F208","v":-12928643.090493292},-6321770.8271021666,{"$f":"G209+H208","v":502412.05477895774},7550424.8737047845,14828982.527786652,20718774.516940746,26853151.521711882]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F214,IF(D199<=H214,D208,0),IF(E199<=H214,E208,0),IF(F199<=H214,F208,0),IF(G199<=H214,G208,0),IF(H199<=H214,H208,0),IF(I199<=H214,I208,0),IF(J199<=H214,J208,0),IF(K199<=H214,K208,0),IF(L199<=H214,L208,0))-D183","v":14562742.408279173},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D183+IF(H214>=D199,(D206+D203-H193/D190)*((1+F214)^-1),0)+IF(H214>=E199,(E206+E203-H193/D190)*((1+F214)^-2),0)+IF(H214>=F199,(F206+F203-H193/D190)*((1+F214)^-3),0)+IF(H214>=G199,(G206+G203-H193/D190)*((1+F214)^-4),0)+IF(H214>=H199,(H206+H203-H193/D190)*((1+F214)^-5),0)+IF(H214>=I199,(I206+I203-H193/D190)*((1+F214)^-6),0)+IF(H214>=J199,(J206+J203-H193/D190)*((1+F214)^-7),0)+IF(H214>=K199,(K206+K203-H193/D190)*((1+F214)^-8),0)+IF(H214>=L199,(L206+L203-H193/D190)*((1+F214)^-9),0)","v":14562742.408279182},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N215:W215,10.8%)","v":0.14461976646929742},{"$nulls":10},{"$f":"-D183","v":-30080000},{"$f":"IF(D199<=H214,D208,0)","v":4564410.8487244584},{"$f":"IF(E199<=H214,E208,0)","v":6191054.9803911252},{"$f":"IF(F199<=H214,F208,0)","v":6395891.0803911248},{"$f":"IF(G199<=H214,G208,0)","v":6606872.263391125},{"$f":"IF(H199<=H214,H208,0)","v":6824182.8818811243},{"$f":"IF(I199<=H214,I208,0)","v":7048012.8189258268},{"$f":"IF(J199<=H214,J208,0)","v":7278557.6540818671},{"$f":"IF(K199<=H214,K208,0)","v":5889791.9891540939},{"$f":"IF(L199<=H214,L208,0)","v":6134377.0047711367}]
[null,"IPI",{"$f":"SUM(O215:W215)/D183","v":1.8927244521845705},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N216,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 893 CFA"},{"$nulls":9},{"$f":"(C216-1)*1000","v":892.72445218457051}]
[null,"DCRI",{"$f":"N217+(-P217/(O217-P217))","v":4.9263776977441633},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C217,0)&\" ans et \"&ROUNDDOWN((C217-ROUNDDOWN(C217,0))*12,0)&\" mois\"","v":"Le délai de récupération est de 4 ans et 11 mois"},{"$nulls":9},{"$f":"IF(AND(L209<0,L199<=H214),L199,IF(AND(K209<0,K199<=H214),K199,IF(AND(J209<0,J199<=H214),J199,IF(AND(I209<0,I199<=H214),I199,IF(AND(H209<0,H199<=H214),H199,IF(AND(G209<0,G199<=H214),G199,IF(AND(F209<0,F199<=H214),F199,IF(AND(E209<0,E199<=H214),E199,IF(AND(D209<0,D199<=H214),D199,IF(AND(C209<0,C199<=H214),C199))))))))))","v":4},{"$f":"INDEX(C209:L209,MATCH(INDEX(C199:L199,MATCH(P217,C209:L209,0))+1,C199:L199,0))","v":502412.05477895774},{"$f":"IF(AND(L209<0,L199<=H214),L209,IF(AND(K209<0,K199<=H214),K209,IF(AND(J209<0,J199<=H214),J209,IF(AND(I209<0,I199<=H214),I209,IF(AND(H209<0,H199<=H214),H209,IF(AND(G209<0,G199<=H214),G209,IF(AND(F209<0,F199<=H214),F209,IF(AND(E209<0,E199<=H214),E209,IF(AND(D209<0,D199<=H214),D209,IF(AND(C209<0,C199<=H214),C209))))))))))","v":-6321770.8271021666}]
[null,"DSCR",{"$f":"(D200-D201)/(D203)","v":1.7469887479062287}]
[]
[]
[null,"Factures simulées"]
[]
[]
[null,"Durée de vie du projet ou d'un prêt",null,null,null,7,"ans"]
[null,"Investissement total projet",null,null,null,{"$f":"SUM('investissement réel'!E4:E24)-10000000","v":31375068},"FCFA"]
[null,"Intérêts théoriques",null,null,null,13765297.782336438,"FCFA"]
[null,"Investissement optimisé aux machines",null,null,null,17486305.999999996,"FCFA"]
[null,"Taux de remboursement (intérêts)",null,null,null,{"$f":"H193","v":13881293.053231606},"FCFA"]
[null,"Amortissements",null,null,null,{"$f":"G150*F224","v":17077741.316666666},"FCFA"]
[]
[null,"Energie nécessaire par jour",null,null,null,{"$f":"F100","v":40.073999999999998},"KWh"]
[null,"Energie nécessaire durée projet",null,null,null,{"$f":"F231*365*F224","v":102389.06999999999},"KWh"]
[null,"Energie nécessaire mouture (1kg)",null,null,null,{"$f":"((H17*Q17)/E17)*1.5","v":1.9681199999999996E-2},"KWh"]
[null,"Energie nécessaire décorticage (1kg)",null,null,null,{"$f":"((H19*Q19)/E19)*1.5","v":3.0800000000000001E-2},"KWh"]
[null,"Energie nécessaire tamisage (1kg)",null,null,null,{"$f":"((H21*Q21)/E21)*1.5","v":5.2499999999999986E-4},"KWh"]
[]
[null,"Temps total utilisation des machines possible/mois ",null,null,null,{"$f":"(N17+N19+N21)*30","v":420},"heures"]
[null,"Temps nécessaire mouture (1kg)",null,null,null,{"$f":"3600/250","v":14.4},"Sec"]
[null,"Temps nécessaire décorticage (1kg)",null,null,null,{"$f":"3600/150","v":24},"Sec"]
[null,"Temps nécessaire tamisage (1kg)",null,null,null,{"$f":"3600/800","v":4.5},"Sec"]
[]
[null,"Prix moyen du KWh sans amortissement",null,null,null,{"$f":"SUM(F227:F228)/F232","v":306.35690951418553},"FCFA"]
[null,"Prix moyen du KWh avec amortissement",null,null,null,{"$f":"SUM(F227:F229)/F232","v":473.14953021741752},"FCFA"]
[null,"Prix moyen mouture (1kg)",null,null,null,{"$f":"F233*F242","v":6.0294716075305868},"FCFA"]
[null,"Prix moyen décorticage (1kg)",null,null,null,{"$f":"F234*F242","v":9.4357928130369153},"FCFA"]
[null,"Prix moyen tamisage (1kg)",null,null,null,{"$f":"F235*F242","v":0.16083737749494736},"FCFA"]
[]
[{"$nulls":4},"PROJET PMP mil avec GIZ"]
[null,"SIMULATION DE FACTURE ELECTRICITE"]
[]
[null,"Site","Godaguene Sorokh"]
[]
[]
[]
[null,"MODELE REMBOURSEMENT SYSTÈME SOLAIRE ",null,null,"MODELE PAIEMENT KWh Prix solaire"]
[]
[]
[{"$nulls":5},"Service Mouture"]
[null,"Délai de rentabilisation: ",{"$f":"F224","v":7},"ans","Quantité moulue",null,800,"Kg"]
[{"$nulls":4},"Consommation mouture",null,{"$f":"G259*F233","v":15.744959999999997},"KWh"]
[null,"Part du champ solaire dimenssionné",null,null,"Temps d'utilisation moulin",null,{"$f":"G259*F238/3600*2","v":6.4},"heures"]
[null,"pour les équipements productifs:",{"$f":"(F227+F228)/(F225+F226)","v":0.69489022761764685},null,"Prix unitaire au Kg",null,{"$f":"F244","v":6.0294716075305868},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G262*G259","v":4823.5772860244697},"FCFA"]
[null,"Montant du paiement mensuel",null,null,null,"Service Décorticage"]
[null,"pour le système complet:",{"$f":"SUM(F225:F226)/F224/12","v":537385.30693257658},"FCFA","Quantité Décortiquée",null,600,"Kg"]
[{"$nulls":4},"Consommation décortiqueuse",null,{"$f":"G265*F234","v":18.48},"KWh"]
[{"$nulls":4},"Temps d'utilisation décortiqueuse",null,{"$f":"G265*F239/3600*2","v":8},"heures"]
[{"$nulls":4},"Prix unitaire au Kg",null,{"$f":"F245","v":9.4357928130369153},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G265*G268","v":5661.4756878221488},"FCFA"]
[{"$nulls":5},"Service Tamisage"]
[{"$nulls":4},"Quantité tamisée",null,4000,"Kg"]
[{"$nulls":4},"Consommation tamisage",null,{"$f":"G271*F235","v":2.0999999999999996},"KWh"]
[{"$nulls":4},"Temps d'utilisation tamiseur",null,{"$f":"G271*F240/3600*2","v":10},"heures"]
[{"$nulls":4},"Prix unitaire au Kg",null,{"$f":"F246","v":0.16083737749494736},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G271*G274","v":643.34950997978945},"FCFA"]
[]
[{"$nulls":4},"Temps d'utilisation des machines",null,{"$f":"SUM(G273,G267,G261)","v":24.4},"heures"]
[{"$nulls":4},"Taux d'utilisation des machines",null,{"$f":"G277/F237","v":5.8095238095238089E-2}]
[]
[{"$nulls":4},"Consommation totale des machines",null,{"$f":"G272+G266+G260","v":36.324959999999997},"KWh"]
[]
[]
[]
[null,"Montant du paiement",null,null,"Montant du paiement"]
[null,"mensuel",{"$f":"(F227+F228)/F224/12","v":373423.79825275717},"FCFA","mensuel",null,{"$f":"G275+G269+G263","v":11128.402483826409},"FCFA"]

{"sheet":"investissement réel","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
["Moulin à grains",1,1000000,15,{"$f":"B4*C4","v":1000000},{"$f":"E4/D4","v":66666.666666666672}]
["Congélateur 360L",1,400000,7,{"$f":"B5*C5","v":400000},{"$f":"E5/D5","v":57142.857142857145}]
["Banc de recharge de smartphone",1,20000,10,20000,{"$f":"E6/D6","v":2000}]
["Décortiqueuse électrique",1,1000000,15,1000000,66666.666666666672]
["Vibro-tamiseur",1,1300000,15,{"$f":"B8*C8","v":1300000},86666.666666666672]
["Éclairage",3,1500,2,4500,2250]
["Modules PV  (375 Wc)",54,78148.148148148102,20,{"$f":"B10*C10","v":4219999.9999999972},210999.99999999985]
["Onduleur reseau 20 KW",1,1870329,10,1870329,187032.9]
["Batteries OPZS 1220 (Ah)",48,194400.625,7,9331230,1333032.857142857]
["Convertisseur chargeur victron  8KVA",3,1660376,10,{"$f":"B13*C13","v":4981128},498112.8]
["Coffret DC",1,275563,15,275563,18370.866666666665]
["Coffret AC",1,1049763,15,1049763,69984.2]
["Câbles et accessoires ",1,583632,20,583632,29181.599999999999]
["Ensemble mise à la terre et accessoires",1,161755,10,161755,16175.5]
["Coffret pour batteries",1,437401,7,437401,62485.857142857145]
["Batiment",1,10000000,30,10000000,333333.33333333331]
["Local batteries",1,1149167,30,1149167,38305.566666666666]
["Installation",1,1370600,30,1370600,45686.666666666664]
["Support aluminium",14,82500,20,{"$f":"B22*C22","v":1155000},{"$f":"IFERROR(E22/D22,0)","v":57750}]
["Démarreur/variateur",1,925000,15,925000,61666.666666666664]
["Parafoudre ",1,140000,15,140000,9333.3333333333339]
[" TOTAL (F CFA) ",null,null,null,{"$f":"SUM(E4:E24)","v":41375068},2737297.6190476194]

{"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é'!D189","v":0.15}]
["Capital emprunté",{"$f":"'Table rentabilité optimisé'!D188","v":24064000}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité optimisé'!D190","v":7},{"$f":"B4*12","v":84}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":451729.67920513818},"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":169821.9184457864},"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":281907.76075935172},"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":451729.67920513812},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":169821.9184457864},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":281907.76075935172},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":23894178.081554215},{"$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},{"$f":"IF(A15<>\"-\",C15+D15,\"\")","v":451729.67920513818},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":171811.36811154895},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":279918.31109358923},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":23722366.713442665},{"$f":"IF(A15<>\"-\",IF(G14<G15,F14,F14+1),\"\")","v":1},{"$f":"IF(A15=\"-\",\"\",IF(G14<12,G14+1,1))","v":2}]
[{"$f":"IF(AND($B$4<>0,A15<$C$4),A15+1,\"-\")","v":3},451729.67920513818,173824.12401486206,277905.55519027612,23548542.589427803,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,451729.67920513812,175860.45918636245,275869.22001877567,23372682.130241439,1,4]
[5,451729.67920513824,177920.64985521795,273809.02934992028,23194761.480386224,1,5]
[6,451729.67920513818,180004.97548659815,271724.70371854003,23014756.504899625,1,6]
[7,451729.67920513824,182113.71881958391,269615.9603855543,22832642.78608004,1,7]
[8,451729.67920513824,184247.16590552087,267482.51329961733,22648395.62017452,1,8]
[9,451729.67920513824,186405.60614682251,265324.07305831573,22461990.014027696,1,9]
[10,451729.67920513812,188589.33233622744,263140.34686891071,22273400.681691468,1,10]
[11,451729.67920513812,190798.64069651693,260931.03850862122,22082602.040994953,1,11]
[12,451729.67920513824,193033.8309206976,258695.84828444061,21889568.210074253,1,12]
[13,451729.67920513818,195295.20621265459,256434.47299248358,21694273.003861599,2,1]
[14,451729.67920513812,197583.07332828143,254146.60587685669,21496689.93053332,2,2]
[15,451729.67920513818,199897.74261709157,251831.93658804661,21296792.187916227,2,3]
[16,451729.67920513824,202239.52806431707,249490.15114082114,21094552.659851909,2,4]
[17,451729.67920513818,204608.74733350088,247120.93187163729,20889943.912518408,2,5]
[18,451729.67920513824,207005.72180958814,244723.95739555007,20682938.19070882,2,6]
[19,451729.67920513812,209430.77664252173,242298.90256261639,20473507.4140663,2,7]
[20,451729.67920513818,211884.24079134924,239845.43841378894,20261623.173274949,2,8]
[21,451729.67920513818,214366.44706884612,237363.23213629206,20047256.726206101,2,9]
[22,451729.67920513824,216877.7321866618,234851.94701847641,19830378.994019441,2,10]
[23,451729.67920513818,219418.43680099474,232311.24240414344,19610960.557218447,2,11]
[24,451729.67920513824,221988.90555880248,229740.77364633573,19388971.651659645,2,12]
[25,451729.67920513824,224589.48714455304,227140.19206058516,19164382.164515093,3,1]
[26,451729.67920513824,227220.53432752399,224509.14487761425,18937161.630187567,3,2]
[27,451729.67920513818,229882.40400965564,221847.27519548254,18707279.226177912,3,3]
[28,451729.67920513824,232575.45727396489,219154.22193117332,18474703.768903948,3,4]
[29,451729.67920513812,235300.05943352627,216429.61977161188,18239403.709470421,3,5]
[30,451729.67920513824,238056.58008102665,213673.09912411161,18001347.129389394,3,6]
[31,451729.67920513812,240845.39313890025,210884.28606623787,17760501.736250494,3,7]
[32,451729.67920513824,243666.87691005191,208062.80229508629,17516834.85934044,3,8]
[33,451729.67920513812,246521.41412917327,205208.26507596488,17270313.445211269,3,9]
[34,451729.67920513824,249409.39201466134,202320.28719047687,17020904.053196609,3,10]
[35,451729.67920513818,252331.2023211442,199398.47688399398,16768572.850875463,3,11]
[36,451729.67920513818,255287.24139262314,196442.43781251504,16513285.60948284,3,12]
[37,451729.67920513824,258277.91021623634,193451.76898890187,16255007.699266601,4,1]
[38,451729.67920513824,261303.61447665287,190426.06472848533,15993704.08478995,4,2]
[39,451729.67920513824,264364.76461110427,187364.91459403397,15729339.320178846,4,3]
[40,451729.67920513818,267461.77586505993,184267.90334007825,15461877.544313785,4,4]
[41,451729.67920513812,270595.06834855553,181134.61085658261,15191282.475965232,4,5]
[42,451729.67920513824,273765.06709318096,177964.61211195725,14917517.408872049,4,6]
[43,451729.67920513824,276972.20210973563,174757.47709540257,14640545.206762316,4,7]
[44,451729.67920513818,280216.90844656003,171512.77075857815,14360328.298315754,4,8]
[45,451729.67920513824,283499.62624854961,168230.0529565886,14076828.672067206,4,9]
[46,451729.67920513818,286820.80081686086,164908.87838827731,13790007.871250343,4,10]
[47,451729.67920513818,290180.8826693162,161548.79653582198,13499826.988581028,4,11]
[48,451729.67920513824,293580.32760151697,158149.35160362124,13206246.660979513,4,12]
[49,451729.67920513812,297019.59674867202,154710.0824564661,12909227.064230839,5,1]
[50,451729.67920513818,300499.15664815111,151230.52255698707,12608727.907582685,5,2]
[51,451729.67920513818,304019.47930277023,147710.19990236795,12304708.428279916,5,3]
[52,451729.67920513824,307581.04224481928,144148.63696031892,11997127.3860351,5,4]
[53,451729.67920513824,311184.32860083925,140545.35060429896,11685943.057434257,5,5]
[54,451729.67920513818,314829.8271571584,136899.85204797977,11371113.230277102,5,6]
[55,451729.67920513818,318518.03242619633,133211.64677894185,11052595.197850902,5,7]
[56,451729.67920513818,322249.44471354439,129480.2344915938,10730345.753137361,5,8]
[57,451729.67920513812,326024.57018583239,125705.10901930573,10404321.182951527,5,9]
[58,451729.67920513818,329843.92093939037,121885.75826574782,10074477.262012137,5,10]
[59,451729.67920513824,333708.01506971405,118021.66413542417,9740769.2469424214,5,11]
[60,451729.67920513824,337617.37674174493,114112.30246339331,9403151.870200675,5,12]
[61,451729.67920513824,341572.53626097331,110157.14294416491,9061579.3339397013,6,1]
[62,451729.67920513818,345574.03014537418,106155.64905976401,8716005.3037943281,6,2]
[63,451729.67920513818,349622.40119818615,102107.27800695204,8366382.902596144,6,3]
[64,451729.67920513824,353718.19858154259,98011.480623595649,8012664.7040146012,6,4]
[65,451729.67920513812,357861.97789096547,93867.701314172664,7654802.7261236366,6,5]
[66,{"$f":"IF(A79<>\"-\",C79+D79,\"\")","v":451729.67920513818},{"$f":"IF(A79<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":362054.30123073258},{"$f":"IF(A79<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":89675.377974405594},{"$f":"IF(A79<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A79,0),\"\")","v":7292748.4248929061},6,6]
[{"$f":"IF(AND($B$4<>0,A79<$C$4),A79+1,\"-\")","v":67},451729.67920513824,366295.73729012621,85433.941915011994,6926452.687602777,{"$f":"IF(A80<>\"-\",IF(G79<G80,F79,F79+1),\"\")","v":6},{"$f":"IF(A80=\"-\",\"\",IF(G79<12,G79+1,1))","v":7}]
[68,451729.67920513824,370586.86142057652,81142.817784561717,6555865.8261822015,6,8]
[69,451729.67920513818,374928.25571370771,76801.423491430454,6180937.5704684928,6,9]
[70,451729.67920513818,379320.50908029935,72409.170124838827,5801617.0613881946,6,10]
[71,451729.67920513818,383764.21733017155,67965.461874966626,5417852.8440580219,6,11]
[72,451729.67920513818,388259.98325300706,63469.695952131107,5029592.860805016,6,12]
[73,451729.67920513812,392808.41670011968,58921.262505018458,4636784.4441048913,7,1]
[74,451729.67920513824,397410.13466718083,54319.544537957416,4239374.3094377145,7,2]
[75,451729.67920513812,402065.76137791446,49663.917827223653,3837308.5480598025,7,3]
[76,451729.67920513812,406775.92836877436,44953.75083636379,3430532.6196910255,7,4]
[77,451729.67920513818,411541.27457461081,40188.404630527373,3018991.3451164141,7,5]
[78,451729.67920513812,416362.44641534291,35367.232789795235,2602628.8987010755,7,6]
[79,451729.67920513824,421240.09788364562,30489.581321492587,2181388.80081743,7,7]
[80,451729.67920513818,426174.8906336634,25554.788571474779,1755213.9101837575,7,8]
[81,451729.67920513824,431167.4940707644,20562.185134373809,1324046.4161130004,7,9]
[82,451729.67920513812,436218.58544234472,15511.093762793425,887827.83067065477,7,10]
[83,451729.67920513818,441328.84992969781,10400.829275440394,446498.98074095696,7,11]
[84,451729.67920513818,446498.98074095865,5230.6984641795461,-3.7252902984619141E-9,7,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]