{"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":[[271,8,272,8],[274,8,275,8],[254,1,254,3],[254,4,254,7],[254,8,254,10],[14,8,15,8],[14,9,14,10],[14,12,15,12],[14,11,15,11],[14,13,14,15],[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]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Pôle multiservice paysans PMP"]
[]
[null,"Dimmensionnement optimisé "]
[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":27},"-","-",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":2700336.0952000003}]
[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":7152936.4760000035}]
[null,"Paiement opérateurs",{"$f":"SUM(C157:C162)","v":1235000},"Kilos",5,{"$f":"E122*C122","v":6175000},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":12718686.952000007}]
[]
[null,"Salaires gestion plateforme",1,{"$f":"G113","v":"personnes"},61500,{"$f":"E124*C124*12","v":738000}]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F119:F124)","v":6913000}]
[]
[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":1500000},15,1500000,100000]
[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":27},{"$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},20,2109996,105499.8]
[null,"Batteries OPZS 1220 (Ah)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F107,'investissement réel'!B12)","v":24},{"$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,4665615,466561.5]
[null,"Onduleur reseau 20 KW",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),0,'investissement réel'!B11)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),0,'investissement réel'!C11)","v":0},7,0,0]
[null,"Support aluminium",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D34,'investissement réel'!B22)","v":27},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I34,'investissement réel'!C22)","v":35000},10,945000,94500]
[null,"Convertisseur chargeur victron  8KVA",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F109,'investissement réel'!B13)","v":2},{"$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,3320752,221383.46666666667]
[null,"Coffret DC",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D41,'investissement réel'!B14)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I41,'investissement réel'!C14)","v":0},15,0,0]
[null,"Coffret AC",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D42,'investissement réel'!B15)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),I42,'investissement réel'!C15)","v":0},20,0,0]
[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":0},10,0,0]
[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":1000000},30,1000000,33333.333333333336]
[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":218688},30,218688,7289.6]
[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,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":1000000},15,1000000,66666.666666666672]
[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":1000000},null,1000000,0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F129:F149)","v":28486306},{"$f":"SUM(G129:G149)","v":1315352.3904761905}]
[]
[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,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,{"$f":"F150","v":28486306},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":2020598.9577556585},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":1124372.7723602389},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":196837529.95856163},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":3144971.730115898}]
[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":2162040.8847985547},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":982930.84531734267},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":171680472.52259305},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":3144971.730115898}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D183:D184)","v":28486306},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":2313383.7467344534},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":831587.98338144401},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":144762421.06610665},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":3144971.730115898}]
[null,"Apport personnel",{"$f":"D186/D185","v":0.38615045418665378},{"$f":"SUM(F147:F148)","v":11000000},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":2475320.6090058652},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":669651.12111003231},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":115960106.00766623},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":3144971.730115898}]
[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":2648593.0516362758},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":496378.67847962177},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":85141628.895134941},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":3144971.730115898}]
[null,"Emprunt",{"$f":"100%-C187-C186","v":0.61384954581334616},{"$f":"D185*C188","v":17486305.999999996},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":2833994.5652508149},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":310977.16486508254},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":52165858.384726487},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":3144971.730115898}]
[null,"Taux de l'emprunt",null,7.0000000000000007E-2,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":3032374.1848183721},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":112597.54529752558},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":16881783.938589435},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":3144971.7301158975}]
[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":17486305.999999993},{"$f":"SUM(H183:H192)","v":4528496.1108112875},{"$f":"SUM(I183:I192)","v":783429800.77337849},{"$f":"SUM(J183:J192)","v":22014802.110811286}]
[]
[]
[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":28486305.999999996},{"$f":"J163","v":14525000},{"$f":"D200+($O$155*D200)","v":14960750},15409572.5,15871859.675000001,16348015.46525,16838455.9292075,17343609.607083727,17863917.895296238,18399835.432155125,{"$f":"SUM(C200:L200)","v":176047322.50399262}]
[null,"Dépenses ",{"$f":"D183","v":28486306},{"$f":"F125","v":6913000},{"$f":"D201+($K$118*D201)","v":7120390},{"$f":"E201+($K$118*E201)","v":7334001.7000000002},{"$f":"F201+($K$118*F201)","v":7554021.7510000002},{"$f":"G201+($K$118*G201)","v":7780642.4035299998},8014061.6756358994,8254483.5259049768,8502118.0316821262,8757181.5726325903,98716206.660385624]
[null,"Amortissements ",0,{"$f":"$G$150","v":1315352.3904761905},1315352.3904761905,1315352.3904761905,1315352.3904761905,1315352.3904761905,1315352.3904761905,1315352.3904761905,1315352.3904761905,1315352.3904761905,11838171.514285713]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$183:$J$192,MATCH(D199,$F$183:$F$192,0)),0)","v":3144971.730115898},3144971.730115898,3144971.730115898,3144971.730115898,3144971.730115898,3144971.730115898,3144971.7301158975,0,0,22014802.110811286]
[null,"Bénéfice avant impôts ",0,{"$f":"D200-SUM(D201:D203)","v":3151675.8794079125},{"$f":"E200-SUM(E201:E203)","v":3380035.8794079125},3615246.6794079114,3857513.8034079112,4107048.9411279112,4364070.1329795122,4628801.9605866615,8046447.4731379226,8327301.4690463431,43478142.218510002]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D204<0,0,0.3*D204)","v":945502.7638223737},{"$f":"IF(E204<0,0,0.3*E204)","v":1014010.7638223737},1084574.0038223735,1157254.1410223732,1232114.6823383733,1309221.0398938537,1388640.5881759983,2413934.2419413766,2498190.4407139029,13043442.665552998]
[null,"Bénéfice après impôts ",0,{"$f":"D204-D205","v":2206173.1155855386},{"$f":"E204-E205","v":2366025.1155855386},2530672.6755855381,2700259.6623855382,2874934.2587895379,3054849.0930856587,3240161.3724106634,5632513.231196546,5829111.0283324402,30434699.552956998]
[null,"Trésorerie",{"$f":"C200-C201","v":0},{"$f":"C207+D206","v":2206173.1155855386},4572198.2311710771,{"$f":"E207+F206","v":7102870.9067566153},9803130.5691421535,{"$f":"G207+H206","v":12678064.827931691},15732913.921017349,18973075.293428011,24605588.524624556,30434699.552956998]
[null,"Cash Flows",0,{"$f":"D206+D203-($H$193/$D$190)","v":4704216.8298712522},4864068.8298712522,5028716.3898712518,5198303.3766712518,5372977.9730752511,5552892.8073713724,5738205.0866963761,4985585.2153663617,5182183.0125022558]
[null,"Cash Flows cumulés",{"$f":"-C201","v":-28486306},{"$f":"C209+D208","v":-23782089.170128748},{"$f":"D209+E208","v":-18918020.340257496},{"$f":"E209+F208","v":-13889303.950386245},-8691000.5737149939,{"$f":"G209+H208","v":-3318022.6006397428},2234870.2067316296,7973075.2934280057,12958660.508794367,18140843.521296624]
[]
[]
[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":8172885.5191189721},"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":8172885.5191189768},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N215:W215)","v":0.10921680063416339},{"$nulls":10},{"$f":"-D183","v":-28486306},{"$f":"IF(D199<=H214,D208,0)","v":4704216.8298712522},{"$f":"IF(E199<=H214,E208,0)","v":4864068.8298712522},{"$f":"IF(F199<=H214,F208,0)","v":5028716.3898712518},{"$f":"IF(G199<=H214,G208,0)","v":5198303.3766712518},{"$f":"IF(H199<=H214,H208,0)","v":5372977.9730752511},{"$f":"IF(I199<=H214,I208,0)","v":5552892.8073713724},{"$f":"IF(J199<=H214,J208,0)","v":5738205.0866963761},{"$f":"IF(K199<=H214,K208,0)","v":4985585.2153663617},{"$f":"IF(L199<=H214,L208,0)","v":5182183.0125022558}]
[null,"IPI",{"$f":"SUM(O215:W215)/D183","v":1.6368268150070644},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N216,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 637 CFA"},{"$nulls":9},{"$f":"(C216-1)*1000","v":636.8268150070644}]
[null,"DCRI",{"$f":"N217+(-P217/(O217-P217))","v":5.5975304612822931},{"$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 5 ans et 7 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":5},{"$f":"INDEX(C209:L209,MATCH(INDEX(C199:L199,MATCH(P217,C209:L209,0))+1,C199:L199,0))","v":2234870.2067316296},{"$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":-3318022.6006397428}]
[null,"DSCR",{"$f":"(D200-D201)/(D203)","v":2.4203715178449263}]
[]
[]
[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":4528496.1108112875},"FCFA"]
[null,"Amortissements",null,null,null,{"$f":"G150*F224","v":9207466.7333333343},"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":215.01125179485746},"FCFA"]
[null,"Prix moyen du KWh avec amortissement",null,null,null,{"$f":"SUM(F227:F229)/F232","v":304.93751768762644},"FCFA"]
[null,"Prix moyen mouture (1kg)",null,null,null,{"$f":"F233*F242","v":4.2316794488249476},"FCFA"]
[null,"Prix moyen décorticage (1kg)",null,null,null,{"$f":"F234*F242","v":6.6223465552816103},"FCFA"]
[null,"Prix moyen tamisage (1kg)",null,null,null,{"$f":"F235*F242","v":0.11288090719230014},"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.48769658218910017},null,"Prix unitaire au Kg",null,{"$f":"F244","v":4.2316794488249476},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G262*G259","v":3385.3435590599579},"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":6.6223465552816103},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G265*G268","v":3973.4079331689663},"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.11288090719230014},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G271*G274","v":451.52362876920057},"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":262080.97750965817},"FCFA","mensuel",null,{"$f":"G275+G269+G263","v":7810.2751209981252},"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":7.0000000000000007E-2}]
["Capital emprunté",{"$f":"'Table rentabilité optimisé'!D188","v":17486305.999999996}]
["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":262080.97750965811},"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":163210.86109700098},"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":98870.116412657138},"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":262080.97750965811},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":163210.86109700098},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":98870.116412657138},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":17323095.138902996},{"$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":262080.97750965814},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":164133.67903444704},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":97947.298475211122},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":17158961.459868547},{"$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},262080.97750965811,165061.71471867748,97019.262790980632,16993899.745149869,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,262080.97750965814,165994.99765159131,96085.979858066814,16827904.747498281,1,4]
[5,262080.97750965814,166933.55750189541,95147.420007762717,16660971.189996384,1,5]
[6,262080.97750965811,167877.4241060479,94203.553403610218,16493093.765890336,1,6]
[7,262080.97750965811,168826.62746920658,93254.350040451536,16324267.138421129,1,7]
[8,262080.97750965809,169781.19776618277,92299.779743475301,16154485.940654946,1,8]
[9,262080.97750965811,170741.16534240061,91339.812167257507,15983744.775312547,1,9]
[10,262080.97750965814,171706.56071486155,90374.416794796591,15812038.214597683,1,10]
[11,262080.97750965811,172677.41457311469,89403.562936543429,15639360.800024569,1,11]
[12,262080.97750965809,173653.75778023232,88427.219729425778,15465707.042244337,1,12]
[13,262080.97750965814,174635.62137379104,87445.356135867085,15291071.420870546,2,1]
[14,262080.97750965814,175623.03656685833,86457.940942799803,15115448.384303689,2,2]
[15,262080.97750965811,176616.03474898491,85464.942760673206,14938832.349554703,2,3]
[16,262080.97750965809,177614.64748720269,84466.330022455411,14761217.7020675,2,4]
[17,262080.97750965811,178618.90652702807,83462.070982630044,14582598.795540471,2,5]
[18,262080.97750965814,179628.84379347126,82452.133716186872,14402969.951747002,2,6]
[19,262080.97750965814,180644.49139205107,81436.48611760707,14222325.460354948,2,7]
[20,262080.97750965809,181665.88160981558,80415.095899842519,14040659.578745134,2,8]
[21,262080.97750965814,182693.04691636865,79387.930593289493,13857966.531828765,2,9]
[22,262080.97750965814,183726.01996490185,78354.957544756282,13674240.511863863,2,10]
[23,262080.97750965811,184764.8335932327,77316.143916425412,13489475.678270631,2,11]
[24,262080.97750965809,185809.52082484859,76271.456684809513,13303666.157445783,2,12]
[25,262080.97750965811,186860.11486995639,75220.862639701721,13116806.042575825,3,1]
[26,262080.97750965814,187916.6491265384,74164.328383119733,12928889.393449286,3,2]
[27,262080.97750965814,188979.15718141387,73101.820328244256,12739910.236267872,3,3]
[28,262080.97750965809,190047.67281130687,72033.304698351232,12549862.563456567,3,4]
[29,262080.97750965814,191122.22998392006,70958.747525738087,12358740.333472647,3,5]
[30,262080.97750965814,192202.86285901425,69878.114650643882,12166537.470613632,3,6]
[31,262080.97750965814,193289.60578949464,68791.371720163501,11973247.864824139,3,7]
[32,262080.97750965811,194382.49332250268,67698.484187155438,11778865.371501636,3,8]
[33,262080.97750965809,195481.56020051442,66599.417309143682,11583383.811301121,3,9]
[34,262080.97750965814,196586.84136244497,65494.136147213154,11386796.969938675,3,10]
[35,262080.97750965811,197698.37194475898,64382.605564899131,11189098.597993918,3,11]
[36,262080.97750965809,198816.18728258798,63264.790227070116,10990282.410711328,3,12]
[37,262080.97750965809,199940.32291085331,62140.654598804787,10790342.087800477,4,1]
[38,262080.97750965811,201070.81456539605,61010.162944262054,10589271.273235079,4,2]
[39,262080.97750965814,202207.69818411284,59873.279325545285,10387063.575050965,4,3]
[40,262080.97750965814,203351.00990809838,58729.967601559758,10183712.565142868,4,4]
[41,262080.97750965809,204500.78608279442,57580.191426863676,9979211.7790600732,4,5]
[42,262080.97750965811,205657.06325914522,56423.914250512891,9773554.7158009298,4,6]
[43,262080.97750965814,206819.87819475925,55261.099314898878,9566734.8376061693,4,7]
[44,262080.97750965814,207989.26785507787,54091.709654580263,9358745.5697510913,4,8]
[45,262080.97750965811,209165.26941455045,52915.708095107671,9149580.3003365397,4,9]
[46,262080.97750965814,210347.92025781612,51733.057251842016,8939232.3800787255,4,10]
[47,262080.97750965811,211537.25798089211,50543.719528765992,8727695.1220978312,4,11]
[48,262080.97750965811,212733.32039236915,49347.657117288974,8514961.801705461,4,12]
[49,262080.97750965814,213936.14551461308,48144.831995045053,8301025.6561908498,5,1]
[50,262080.97750965811,215145.77158497379,46935.205924684327,8085879.8846058752,5,2]
[51,262080.97750965814,216362.23705700072,45718.74045265741,7869517.6475488767,5,3]
[52,262080.97750965814,217585.58060166525,44495.396907992879,7651932.0669472087,5,4]
[53,262080.97750965809,218815.84110859002,43265.136401068077,7433116.2258386221,5,5]
[54,262080.97750965809,220053.05768728536,42027.919822372729,7213063.1681513321,5,6]
[55,262080.97750965811,221297.26966839237,40783.707841265743,6991765.8984829411,5,7]
[56,262080.97750965814,222548.51660493331,39532.46090472483,6769217.3818780072,5,8]
[57,262080.97750965809,223806.83827356895,38274.139236089148,6545410.543604441,5,9]
[58,262080.97750965811,225072.27467586321,37008.702833794894,6320338.2689285781,5,10]
[59,262080.97750965811,226344.86603955456,35736.111470103555,6093993.4028890207,5,11]
[60,262080.97750965814,227624.652819835,34456.324689823137,5866368.750069188,5,12]
[61,262080.97750965814,228911.675700636,33169.301809022138,5637457.0743685514,6,1]
[62,262080.97750965811,230205.97559592195,31875.001913736174,5407251.0987726282,6,2]
[63,262080.97750965811,231507.59365099075,30573.383858667359,5175743.505121639,6,3]
[64,262080.97750965814,232816.57124378183,29264.406265876318,4942926.9338778555,6,4]
[65,262080.97750965814,234132.94998619135,27948.027523466779,4708793.9838916659,6,5]
[66,{"$f":"IF(A79<>\"-\",C79+D79,\"\")","v":262080.97750965811},{"$f":"IF(A79<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":235456.77172539535},{"$f":"IF(A79<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":26624.205784262766},{"$f":"IF(A79<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A79,0),\"\")","v":4473337.2121662702},6,6]
[{"$f":"IF(AND($B$4<>0,A79<$C$4),A79+1,\"-\")","v":67},262080.97750965811,236788.07854517983,25292.898964478285,4236549.133621091,{"$f":"IF(A80<>\"-\",IF(G79<G80,F79,F79+1),\"\")","v":6},{"$f":"IF(A80=\"-\",\"\",IF(G79<12,G79+1,1))","v":7}]
[68,262080.97750965814,238126.91276727864,23954.064742379502,3998422.2208538111,6,8]
[69,262080.97750965811,239473.31695271877,22607.660556939332,3758948.9039010927,6,9]
[70,262080.97750965814,240827.33390317365,21253.643606484475,3518121.569997916,6,10]
[71,262080.97750965811,242189.00666232337,19891.970847334731,3275932.5633355957,6,11]
[72,262080.97750965809,243558.37851722341,18522.598992434694,3032374.1848183703,6,12]
[73,262080.97750965811,244935.49299968049,17145.484509977628,2787438.6918186899,7,1]
[74,262080.97750965814,246320.39388763648,15760.583622021646,2541118.2979310546,7,2]
[75,262080.97750965814,247713.12520656013,14367.852303098016,2293405.1727244928,7,3]
[76,262080.97750965809,249113.73123084649,12967.246278811599,2044291.441493649,7,4]
[77,262080.97750965809,250522.2564852247,11558.721024433395,1793769.1850084234,7,5]
[78,262080.97750965811,251938.74574617302,10142.231763485095,1541830.4392622486,7,6]
[79,262080.97750965809,253363.24404334239,8717.7334663157017,1288467.1952189077,7,7]
[80,262080.97750965809,254795.7966609881,7285.1808486700002,1033671.39855792,7,8]
[81,262080.97750965814,256236.44913940912,5844.5283702490224,777434.94941850752,7,9]
[82,262080.97750965814,257685.24727639582,4395.7302332623267,519749.70214211568,7,10]
[83,262080.97750965809,259142.23712868599,2938.7403809721059,260607.4650134258,7,11]
[84,262080.97750965811,260607.46501342906,1473.5124962290618,0,7,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]