{"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":1,"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 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",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":12718686.952000007}]
[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":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,{"$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":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,{"$f":"C149*D149","v":1000000},0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F129:F149)-11000000","v":17486306},{"$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,{"$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,{"$f":"F150","v":17486306},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":1213242.1419992303},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":1331739.27382279},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":139135407.36526382},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F183)","v":2544981.4158220198}]
[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":1358831.1990391391},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":1186150.2167828809},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":123646554.09710471},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F184)","v":2544981.4158220198}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D183:D184)","v":17486306},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":1521890.9429238371},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":1023090.4728981829},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":106299038.43676649},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F185)","v":2544981.4158220198}]
[null,"Apport personnel",{"$f":"'[1]#_Capitalisation'!$D$24","v":0.1},{"$f":"C186*D185","v":1748630.6},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":1704517.856074699},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":840463.55974732095},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":86869820.89718768},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F186)","v":2544981.4158220198}]
[null,"Subvention",{"$f":"'[1]#_Capitalisation'!$D$26","v":0.20000000000000007},{"$f":"C187*D185","v":3497261.2000000011},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":1909059.9988036645},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":635921.41701835545},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":65109097.252859376},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F187)","v":2544981.4158220198}]
[null,"Emprunt",{"$f":"'[1]#_Capitalisation'!$D$25","v":0.7},{"$f":"D185*C188","v":12240414.199999999},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":2138147.1986601059},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":406834.21716191393},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":40737086.771211654},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F188)","v":2544981.4158220198}]
[null,"Taux de l'emprunt",null,{"$f":"'[1]#_Capitalisation'!$C$27","v":0.12},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":2394724.8624993209},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":150256.55332269918},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":13440435.031766182},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité optimisé'!$F189)","v":2544981.4158220198}]
[null,"Remboursement de l'emprunt (années)",null,{"$f":"'[1]#_Capitalisation'!$C$28","v":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":12240414.199999997},{"$f":"SUM(H183:H192)","v":5574455.710754144},{"$f":"SUM(I183:I192)","v":575237439.85215986},{"$f":"SUM(J183:J192)","v":17814869.910754137}]
[]
[]
[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":13989044.799999999},{"$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":161550061.3039926}]
[null,"Dépenses ",{"$f":"D183","v":17486306},{"$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,68840587.475227714]
[null,"Amortissements ",0,{"$f":"G150","v":1315352.3904761905},400000,400000,400000,400000,400000,400000,400000,400000,4515352.3904761905]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$183:$J$192,MATCH(D199,$F$183:$F$192,0)),0)","v":2544981.4158220198},{"$f":"IFERROR(INDEX($J$183:$J$192,MATCH(E199,$F$183:$F$192,0)),0)","v":2544981.4158220198},2544981.4158220198,2544981.4158220198,2544981.4158220198,2544981.4158220198,2544981.4158220198,0,0,17814869.910754137]
[null,"Bénéfice avant impôts ",0,{"$f":"D200-SUM(D201:D203)","v":5609666.1937017888},{"$f":"E200-SUM(E201:E203)","v":6809118.5841779802},7101741.5841779802,7403143.2741779797,7713587.0148779806,8033344.0677989796,8362693.8323076125,11246905.505573522,11596312.670740727,73876512.727534547]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D204<0,0,0.3*D204)","v":1682899.8581105366},{"$f":"IF(E204<0,0,0.3*E204)","v":2042735.575253394},2130522.4752533939,2220942.9822533936,2314076.1044633943,2410003.2203396936,2508808.1496922835,3374071.6516720564,3478893.8012222182,22162953.818260364]
[null,"Bénéfice après impôts ",0,{"$f":"D204-D205","v":3926766.335591252},{"$f":"E204-E205","v":4766383.0089245867},4971219.1089245863,5182200.2919245865,5399510.9104145858,5623340.8474592865,5853885.6826153286,7872833.8539014664,8117418.8695185091,51713558.909274191]
[null,"Trésorerie",{"$f":"C200-C201","v":-3497261.2000000011},{"$f":"C207+D206","v":429505.13559125084},5195888.1445158375,{"$f":"E207+F206","v":10167107.253440425},15349307.545365011,{"$f":"G207+H206","v":20748818.455779597},26372159.303238884,32226044.985854212,40098878.839755677,48216297.709274188]
[null,"Cash Flows",0,{"$f":"D206+D203-($H$193/$D$190)","v":5675396.9355912516},{"$f":"E206+E203-($H$193/$D$190)","v":6515013.6089245863},6719849.708924586,6930830.8919245861,7148141.5104145855,7371971.4474592861,7602516.2826153282,7076483.0380794462,7321068.053696489]
[null,"Cash Flows cumulés",{"$f":"-C201","v":-17486306},{"$f":"C209+D208","v":-11810909.064408749},{"$f":"D209+E208","v":-5295895.455484163},{"$f":"E209+F208","v":1423954.2534404229},8354785.1453650091,{"$f":"G209+H208","v":15502926.655779595},22874898.103238881,30477414.385854207,37553897.423933655,44874965.477630146]
[]
[]
[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":31348682.802012973},"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":31348682.80201298},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N215:W215,10.8%)","v":0.34967125529052989},{"$nulls":10},{"$f":"-D183","v":-17486306},{"$f":"IF(D199<=H214,D208,0)","v":5675396.9355912516},{"$f":"IF(E199<=H214,E208,0)","v":6515013.6089245863},{"$f":"IF(F199<=H214,F208,0)","v":6719849.708924586},{"$f":"IF(G199<=H214,G208,0)","v":6930830.8919245861},{"$f":"IF(H199<=H214,H208,0)","v":7148141.5104145855},{"$f":"IF(I199<=H214,I208,0)","v":7371971.4474592861},{"$f":"IF(J199<=H214,J208,0)","v":7602516.2826153282},{"$f":"IF(K199<=H214,K208,0)","v":7076483.0380794462},{"$f":"IF(L199<=H214,L208,0)","v":7321068.053696489}]
[null,"IPI",{"$f":"SUM(O215:W215)/D183","v":3.566291901653222},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N216,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 2566 CFA"},{"$nulls":9},{"$f":"(C216-1)*1000","v":2566.2919016532219}]
[null,"DCRI",{"$f":"N217+(-P217/(O217-P217))","v":2.7880973064696253},{"$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 2 ans et 9 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":2},{"$f":"INDEX(C209:L209,MATCH(INDEX(C199:L199,MATCH(P217,C209:L209,0))+1,C199:L199,0))","v":1423954.2534404229},{"$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":-5295895.455484163}]
[null,"DSCR",{"$f":"(D200-D201)/(D203)","v":3.7210487829598646}]
[]
[]
[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":5574455.710754144},"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":225.22679140218915},"FCFA"]
[null,"Prix moyen du KWh avec amortissement",null,null,null,{"$f":"SUM(F227:F229)/F232","v":315.1530572949581},"FCFA"]
[null,"Prix moyen mouture (1kg)",null,null,null,{"$f":"F233*F242","v":4.4327335269447641},"FCFA"]
[null,"Prix moyen décorticage (1kg)",null,null,null,{"$f":"F234*F242","v":6.9369851751874263},"FCFA"]
[null,"Prix moyen tamisage (1kg)",null,null,null,{"$f":"F235*F242","v":0.11824406548614927},"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.51086785211159913},null,"Prix unitaire au Kg",null,{"$f":"F244","v":4.4327335269447641},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G262*G259","v":3546.1868215558111},"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.9369851751874263},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G265*G268","v":4162.1911051124562},"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.11824406548614927},"FCFA"]
[{"$nulls":4},"Montant total",null,{"$f":"G271*G274","v":472.97626194459707},"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":274532.87750897784},"FCFA","mensuel",null,{"$f":"G275+G269+G263","v":8181.3541886128642},"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.12}]
["Capital emprunté",{"$f":"'Table rentabilité optimisé'!D188","v":12240414.199999999}]
["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":212081.78465183501},"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":95935.028874505035},"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":116146.75577732998},"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":212081.78465183501},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":95935.028874505035},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":116146.75577732998},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":12144479.171125494},{"$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":212081.78465183498},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":96845.336498668461},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":115236.44815316654},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":12047633.834626826},{"$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},212081.78465183498,97764.281843384349,114317.50280845065,11949869.552783441,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,212081.78465183498,98691.946870194442,113389.83778164056,11851177.605913246,1,4]
[5,212081.78465183498,99628.414318356576,112453.37033347842,11751549.191594889,1,5]
[6,212081.78465183501,100573.76771222432,111508.01693961069,11650975.423882667,1,6]
[7,212081.78465183498,101528.09136869648,110553.69328313852,11549447.332513969,1,7]
[8,212081.78465183498,102491.47040473745,109590.31424709754,11446955.862109233,1,8]
[9,212081.78465183504,103463.99074496898,108617.79390686605,11343491.871364264,1,9]
[10,212081.78465183498,104445.73912933358,107636.04552250142,11239046.132234929,1,10]
[11,212081.78465183504,105436.80312083132,106644.98153100371,11133609.329114098,1,11]
[12,212081.78465183504,106437.27111332931,105644.51353850574,11027172.058000769,1,12]
[13,212081.78465183498,107447.23233944573,104634.55231238925,10919724.825661324,2,1]
[14,212081.78465183501,108466.77687850878,103615.00777332623,10811258.048782814,2,2]
[15,212081.78465183498,109495.99566459056,102585.78898724444,10701762.053118223,2,3]
[16,212081.78465183501,110534.98049461788,101546.80415721714,10591227.072623607,2,4]
[17,212081.78465183498,111583.82403655947,100497.96061527552,10479643.248587046,2,5]
[18,212081.78465183498,112642.61983769132,99439.16481414366,10367000.628749356,2,6]
[19,212081.78465183501,113711.46233294015,98370.322318894861,10253289.166416414,2,7]
[20,212081.78465183498,114790.44685330604,97291.337798528955,10138498.71956311,2,8]
[21,212081.78465183498,115879.66963436535,96202.115017469652,10022619.049928743,2,9]
[22,212081.78465183501,116979.22782485372,95102.556826981294,9905639.8221038897,2,10]
[23,212081.78465183498,118089.21949533117,93992.565156503828,9787550.6026085578,2,11]
[24,212081.78465183504,119209.74364692891,92872.041004906117,9668340.8589616306,2,12]
[25,212081.78465183498,120340.90022017933,91740.884431655664,9547999.9587414507,3,1]
[26,212081.78465183498,121482.79010392993,90598.994547905066,9426517.1686375216,3,2]
[27,212081.78465183498,122635.51514434154,89446.26950749346,9303881.653493179,3,3]
[28,212081.78465183498,123799.17815397211,88282.606497862886,9180082.4753392078,3,4]
[29,212081.78465183498,124973.88292094672,87107.901730888276,9055108.5924182609,3,5]
[30,212081.78465183498,126159.73421821439,85922.050433620592,8928948.8582000453,3,6]
[31,212081.78465183498,127356.83781289308,84724.94683894192,8801592.0203871522,3,7]
[32,212081.78465183501,128565.30047570291,83516.4841761321,8673026.7199114487,3,8]
[33,212081.78465183498,129785.22999048927,82296.554661345712,8543241.4899209607,3,9]
[34,212081.78465183498,131016.73516383626,81065.049487998738,8412224.7547571249,3,10]
[35,212081.78465183498,132259.92583477101,79821.858817063985,8279964.8289223528,3,11]
[36,212081.78465183498,133514.91288456047,78566.871767274526,8146449.9160377923,3,12]
[37,212081.78465183498,134781.80824660094,77299.976405234047,8011668.1077911919,4,1]
[38,212081.78465183501,136060.72491640164,76021.059735433373,7875607.3828747896,4,2]
[39,212081.78465183498,137351.77696166263,74730.007690172366,7738255.6059131268,4,3]
[40,212081.78465183501,138655.0795324489,73426.705119386112,7599600.5263806786,4,4]
[41,212081.78465183498,139970.74887146044,72111.035780374557,7459629.7775092172,4,5]
[42,212081.78465183501,141298.90232440026,70782.882327434752,7318330.8751848182,4,6]
[43,212081.78465183498,142639.65835044035,69442.12630139463,7175691.2168343775,4,7]
[44,212081.78465183498,143993.13653278735,68088.648119047648,7031698.0803015903,4,8]
[45,212081.78465183498,145359.45758934811,66722.327062486875,6886338.6227122415,4,9]
[46,212081.78465183501,146738.74338349677,65343.041268338238,6739599.8793287454,4,10]
[47,212081.78465183498,148131.11693494365,63950.667716891323,6591468.7623938015,4,11]
[48,212081.78465183501,149536.70243070787,62545.082221127137,6441932.0599630931,4,12]
[49,212081.78465183498,150955.62523619321,61126.159415641785,6290976.4347269014,5,1]
[50,212081.78465183501,152388.01190636997,59693.772745465045,6138588.4228205308,5,2]
[51,212081.78465183498,153833.99019706229,58247.794454772709,5984754.4326234674,5,3]
[52,212081.78465183504,155293.68907634291,56788.095575492116,5829460.7435471248,5,4]
[53,212081.78465183501,156767.23873603583,55314.545915799179,5672693.5048110904,5,5]
[54,212081.78465183504,158254.77060332845,53827.014048506586,5514438.7342077615,5,6]
[55,212081.78465183498,159756.41735249333,52325.367299341662,5354682.3168552695,5,7]
[56,212081.78465183498,161272.31291672197,50809.471735113017,5193410.0039385464,5,8]
[57,212081.78465183498,162802.59250007002,49279.192151764961,5030607.4114384744,5,9]
[58,212081.78465183504,164347.39258951653,47734.392062318504,4866260.0188489594,5,10]
[59,212081.78465183504,165906.85096713708,46174.93368469795,4700353.1678818213,5,11]
[60,212081.78465183501,167481.10672239296,44600.677929442056,4532872.0611594291,5,12]
[61,212081.78465183498,169070.30026453652,43011.484387298449,4363801.7608948918,6,1]
[62,212081.78465183501,170674.57333513451,41407.211316700494,4193127.1875597583,6,2]
[63,212081.78465183498,172294.0690207099,39787.715631125095,4020833.1185390474,6,3]
[64,212081.78465183498,173928.93176550418,38152.852886330817,3846904.1867735442,6,4]
[65,212081.78465183498,175579.30738436026,36502.477267474722,3671324.8793891817,6,5]
[66,{"$f":"IF(A79<>\"-\",C79+D79,\"\")","v":212081.78465183498},{"$f":"IF(A79<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":177245.34307572799},{"$f":"IF(A79<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":34836.441576107012},{"$f":"IF(A79<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A79,0),\"\")","v":3494079.5363134537},6,6]
[{"$f":"IF(AND($B$4<>0,A79<$C$4),A79+1,\"-\")","v":67},212081.78465183504,178927.18743479272,33154.597217042312,3315152.348878663,{"$f":"IF(A80<>\"-\",IF(G79<G80,F79,F79+1),\"\")","v":6},{"$f":"IF(A80=\"-\",\"\",IF(G79<12,G79+1,1))","v":7}]
[68,212081.78465183501,180624.99046672878,31456.794185106224,3134527.3584119342,6,8]
[69,212081.78465183504,182338.90360007863,29742.881051756402,2952188.4548118562,6,9]
[70,212081.78465183501,184069.07970025865,28012.704951576361,2768119.3751115967,6,10]
[71,212081.78465183498,185815.67308319366,26266.111568641336,2582303.7020284031,6,11]
[72,212081.78465183498,187578.83952908026,24502.945122754736,2394724.8624993227,6,12]
[73,212081.78465183501,189358.7362962811,22723.04835555391,2205366.1262030397,7,1]
[74,212081.78465183498,191155.52213535079,20926.262516484188,2014210.6040676888,7,2]
[75,212081.78465183498,192969.35730319525,19112.42734863974,1821241.2467644941,7,3]
[76,212081.78465183501,194800.40357736486,17281.381074470148,1626440.8431871291,7,4]
[77,212081.78465183501,196648.82427048369,15432.96038135132,1429792.0189166479,7,5]
[78,212081.78465183501,198514.78424481553,13567.00040701949,1231277.234671833,7,6]
[79,212081.78465183504,200398.44992696802,11683.334724867009,1030878.7847448606,7,7]
[80,212081.78465183498,202299.98932273639,9781.7953290986025,828578.79542212747,7,8]
[81,212081.78465183501,204219.57203208821,7862.2126197467933,624359.22339003906,7,9]
[82,212081.78465183501,206157.36926428988,5924.4153875451402,418201.85412574932,7,10]
[83,212081.78465183501,208113.55385317709,3968.2307986579199,210088.30027257279,7,11]
[84,212081.78465183501,210088.30027257008,1993.4843792649244,0,7,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]