{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Table rentabilité","Remboursement Mensualités","investissement reél"],"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é","index":0,"n_rows":217,"n_cols":23,"rows_kept":217,"cut":false,"hidden":false,"merged":[[54,1,55,1],[54,7,55,7],[56,1,57,1],[56,7,57,7],[72,5,72,6],[69,5,69,6],[70,5,70,6],[78,5,78,6],[82,5,82,6],[22,2,23,2],[22,4,23,4],[16,5,17,5],[73,5,73,6],[22,6,23,6],[22,3,23,3],[16,7,17,7],[16,8,16,9],[16,10,17,10],[16,6,17,6],[16,2,17,2],[16,3,16,4]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Presse à huile_Moulin à mil"]
[]
[null,"investissement réel"]
[null,"investissement optimisé"]
[null,"investissement réel"]
[]
[]
[null,"Cases à vérifier"]
[null,"Cases à compléter"]
[null,"Cases à laisser vides"]
[null,"Cases calculées"]
[]
[null,"Caractéristiques techniques du Projet"]
[{"$nulls":5},1650000]
[null,"Usage Productif","Rendement (L,Kg/jour)","Puissance (kW)",null,"Prix (FCFA)","Energie consommée (KWh/j)","Energie à produire (kWh/j)","Fonctionnement optimal",null,"Coefficient déperdition (k)"]
[null,null,null,"Max","Nominale",null,null,null,"heures par jour","jours à l'année"]
[null,"Presse à huile ",16,"-",0.31,{"$f":"IF(B5=INDEX(B6:B7,1,1),F16,'investissement reél'!E21)","v":2033742},{"$f":"E19*I19","v":3.7199999999999998},{"$f":"E19*I19/K19","v":4.6499999999999995},12,360,0.8]
[null,"Moulin à mil + variateur  ",{"$f":"50*$I20","v":300},"-",1.8,700000,{"$f":"E20*I20","v":10.8},{"$f":"E20*I20/K20","v":13.5},6,360,0.8]
[null,null,null,"-",null,null,{"$f":"E21*I21","v":0},{"$f":"E21*I21/K21","v":0},null,365,0.8]
[]
[null,"Equipements complémentaires","Puissance (kW)","Nombre","Consommation énergétique (kWh/jour)","Fonctionnement","Prix unitaire (FCFA)"]
[{"$nulls":5},"h/jour"]
[null,"Eclairage ( Ampoules LED)",1.4999999999999999E-2,4,{"$f":"C25*F25*D25","v":0.36},6,2500]
[null,"Banc de recharge telephone",0,10,{"$f":"C26*F26*D26","v":0},10]
[null,"Projecteur LED",null,1,null,null,40000]
[{"$nulls":4},{"$f":"C28*F28","v":0},null,null,{"$f":"0.936+0.36","v":1.296}]
[null,"Coffret de protection DC ",null,1,null,null,46308]
[null,"Coffret de protection AC",null,1,null,null,2164]
[null,"Câbles et accessoires et protections",null,1,null,null,399000]
[null,"transprot equipement",null,1,null,null,550000]
[null,"Support modules",null,1,null,null,7000]
[null,"Installation ",null,1,null,null,500000]
[null,"locale technique ",null,1,null,null,1000000]
[null,"demarreur electronique 2,2 KW",null,1,null,null,87648]
[null,"ensacheuse",null,2,null,null,20000]
[null,"Box bateries et support",null,1,null,null,0]
[null,"Monotoring",null,1,"-",null,0]
[]
[null,"Alimentation Solaire","Puissance (kW)","Prix (FCFA)","Coefficient déperdition","Tension (V)",null,"Batteries","Capacité (Ampères/h)","Prix (FCFA)","Tension (V)","Durée de vie*","* en conditions optimales, annoncées constructeur"]
[null,"Modules polycristallins 265",0.375,124000,0.6,"24V",null,"Batterie de 12V, 265 Ah en C40 ",265,400000,12,10]
[null,"Modules polycristallins 275",0.27500000000000002,49800,null,24,null,"Gel 220Ah 12V",220,223252,12,10]
[null,"Tension nécessaire ",{"$f":"IF(J44<0.5,\"12V\",IF(AND(J44>=0.5,J44<2),\"24V\",IF(J44>=2,\"48V\")))","v":"48V"},{"$nulls":4},"Tension nécessaire batteries",{"$f":"IF(J44<0.5,12,IF(AND(J44>=0.5,J44<2),24,IF(J44>=2,48)))","v":48},{"$f":"F101*INDEX(C:C,MATCH(F75,B:B,0))","v":3.3000000000000003}]
[]
[null,"Onduleur","kVa","Prix (FCFA)",null,null,null,"Régulateur","tension/courant","Prix (FCFA)","Tension (V)"]
[null,"Onduleur 2KVA",2,333500,null,null,null,"Régulateur Victron Smart bluesolar MPPT 100V ; 50A","100/50",114700,"12V/24V/48V"]
[null,"Onduleur victron 3KW, 48V",3,425314,null,null,null,"Régulateur Victron Smart bluesolar MPPT 150V ; 85A","150/85",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,6.01]
[]
[null,"Électricité du réseau",null,"1ère Tranche","2ème Tranche","3ème Tranche",null,null,null,"1ère Tranche","2ème Tranche","3ème Tranche","Total"]
[null,"UP-Petite Puissance","Tranche (KWh)",50,500,"∞",null,"UP-Petite Puissance","Energie par Tranche",{"$f":"(F90*30)-SUM(K55:L55)","v":50},{"$f":"IF((F90*30)>D55,(F90*30)-D55-L55,0)","v":396.40000000000003},{"$f":"IF((F90*30)>E55,(F90*30)-E55,0)","v":0},{"$f":"SUM(J55:L55)","v":446.40000000000003}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J55*D56","v":6442.5},{"$f":"K55*E56","v":53783.552000000011},{"$f":"L55*F56","v":0},{"$f":"SUM(J56:L56)","v":60226.052000000011}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F90*30)-SUM(K57:L57)","v":100},{"$f":"IF((F90*30)>D57,(F90*30)-D57-L57,0)","v":346.40000000000003},{"$f":"IF((F90*30)>E57,(F90*30)-E57,0)","v":0},{"$f":"SUM(J57:L57)","v":446.40000000000003}]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J57*D58","v":12981},{"$f":"K57*E58","v":47293.992000000006},{"$f":"L57*F58","v":0},{"$f":"SUM(J58:L58)","v":60274.992000000006}]
[]
[null,"Frais fixes de raccordement","Fixe/Distance","Prix TTC","Étude raccordement"]
[null,"Réseau HTA","Kg câble","10.000 à 100.000",550000]
[null,"Réseau HTA - Autres Frais","Fixe","2.000.000 à 7.000.000",550000]
[null,"Transformateur HT/MT - BT","Fixe",4800000,179000]
[null,"Extension BT*","Distance",8260,179000]
[null,"Dépend également de la distance de transport des équipements et nombre et type de poteaux non mesurable sauf par Sénélec (approximation)"]
[]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"Production huile min. souhaitée presse  (L /jour)",null,null,null,{"$f":"C19","v":16}]
[null,"Production min. souhaitée moulin(kg /jour)",null,null,null,{"$f":"C20","v":300}]
[]
[null,"Choix presse à huiles",null,null,null,"Presse à huile "]
[null,"Choix du moulin",null,null,null,"Moulin à mil + variateur  "]
[null,"Choix de l'alimentation solaire",null,null,null,"Modules polycristallins 275"]
[null,"Choix du système de stokage",null,null,null,"Gel 220Ah 12V"]
[null,"Choix de l'onduleur",null,null,null,"Onduleur victron 3KW, 48V"]
[null,"Choix du régulateur",null,null,null,"Régulateur Victron Smart bluesolar MPPT 150V ; 85A"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M55<M57,B55,B57)","v":"UP-Moyenne Puissance"}]
[null,"Raccordement nécessaire (MT, BT) et distance",null,null,null,"MT",500]
[null,"Montant Frais HTA et KG câble",null,null,null,4462549,30]
[]
[null,"Autonomie nécessaires au projet (jours)",null,null,null,1]
[null,"Profondeur décharge batteries",null,null,null,0.8]
[]
[null,"Choix du cas pour dimensionnement solaire",null,null,null,"best case"]
[{"$nulls":5},"worst case"]
[{"$nulls":5},"average","x"]
[]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"SUM(E25:E39)+INDEX(G:G,MATCH(F73,B:B,0))+INDEX(G:G,MATCH(F74,B:B,0))","v":14.88},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F73,B:B,0))+INDEX(H:H,MATCH(F74,B:B,0))+SUM(E25:E39))/O52*F94","v":3.0798668885191347},"KW"]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(INDEX(G:G,MATCH(F73,B:B,0))+SUM(E26:E35))*1000*(F83)/(F84*I44)","v":96.874999999999972},"Ah"]
[]
[null,"Nombre presse à huile",null,null,null,{"$f":"ROUNDUP(F70/(C19),0)","v":1},"unités"]
[null,"Nombre de moulin solaire",null,null,null,{"$f":"ROUNDUP(F71/(C20),0)","v":1}]
[null,"puissance equippement journaliere majoré (KW)",null,null,null,{"$f":"(SUM(C25:C39)+SUM(E19:E21))*1.2","v":2.5499999999999998},"unités"]
[null,"Ampoules LED",null,null,null,{"$f":"D25","v":4},"unités"]
[null,"projecteur LED",null,null,null,{"$f":"D27","v":1},"unités"]
[null,"Nb ensemble prises",null,null,null,1,"unités"]
[null,"Nb de variateurs/demarreurs",null,null,null,1,"unités"]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F91/INDEX(C:C,MATCH(F75,B:B,0)),0)","v":12},"unités"]
[null,"Nb de batteries en série",null,null,null,{"$f":"I44/INDEX(K:K,MATCH(F76,H:H,0))","v":4},"unités"]
[null,"Nb de batteries en dérivation",null,null,null,{"$f":"ROUNDUP(F92/INDEX(I:I,MATCH(F76,H:H,0)),0)","v":1},"unités"]
[null,"Nb de batteries total",null,null,null,{"$f":"F102*F103","v":4},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,7,"ans"]
[null,"Nb régulateurs",null,null,null,{"$f":"IF(OR(C44=24,C44=12),1,1)","v":1},"unités"]
[null,"Nb onduleurs",null,null,null,{"$f":"ROUNDUP(F96/INDEX(C:C,MATCH(F77,B:B,0)),0)","v":1},"unités"]
[]
[null,"Ratio de fonctionnement ",null,null,null,0.9]
[null,"Employés nécessaires pour fonctionnement",null,null,null,2,"personnes"]
[null,"Extrant annuel attendu  en huile ",null,null,null,{"$f":"INDEX(C:C,MATCH($F$73,B:B,0))*INDEX(J:J,MATCH($F$73,B:B,0))*F109*F94","v":5184},"Litres"]
[null,"Extrant annuel attendu en mouture",null,null,null,{"$f":"INDEX(C:C,MATCH($F$74,B:B,0))*INDEX(J:J,MATCH($F$74,B:B,0))*F94*F109","v":97200},"Kilos"]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION"]
[null,"Désignation","Quantité","Prix unitaire","Montant mensuel","Montant total/an",null,"évolution annuelle charges d'exploitation",null,null,0.02]
[null,"achats graines d'arrachide non decortiqués",{"$f":"(F111/0.45)/12","v":960},400,{"$f":"C118*D118","v":384000},{"$f":"E118*12","v":4608000}]
[null,"bidons vides pour conditionnement",7,25,{"$f":"C119*D119*30","v":5250},{"$f":"E119*12","v":63000},null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"((MIN(M58,M56)*12)+IF(F80=\"MT\",(G80*D64)+D63+E61+F81,(G80*D64)))-(SUM(F137:F141,F148)+SUM(G137:G141,G148))","v":10375948.081142858}]
[null,"salaires equipe presse",1,30000,{"$f":"C120*D120","v":30000},{"$f":"E120*6","v":180000}]
[null,"salaire equipe moulin",1,30000,{"$f":"C121*D121","v":30000},{"$f":"E121*12","v":360000},null,null,null,"Sur 5 ans",{"$f":"((MIN(M58,M56)*12*5)+IF(F80=\"MT\",(G80*D64)+D63+E61+F81,(G80*D64)))-(SUM(F137:F141,F148)+(SUM(G137:G141,G148)*5))","v":11806104.405714286}]
[null,"achats grains de mil",15,200,90000,1080000]
[null,"achats grains de mais",15,175,78750,945000]
[null,"achats sachets",17,30,15300,183600]
[null,"transport",1,10000,{"$f":"C125*D125","v":10000},{"$f":"E125*3","v":30000}]
[null,"divers (marketing, imprevu",1,0,0,0,null,null,null,"Sur 10 ans",{"$f":"((MIN(M58,M56)*12*10)+IF(F80=\"MT\",(G80*D64)+D63+E61+F81,(G80*D64)))-(SUM(F137:F141,F148)+(SUM(G137:G141,G148)*10))","v":13593799.811428573}]
[null,"faris de maintenaice/trois mois",1,50000,{"$f":"C127*D127/2","v":25000},{"$f":"E127*3","v":75000}]
[{"$nulls":4},0,0]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E118:E128)","v":668300},{"$f":"SUM(F118:F128)","v":7524600}]
[]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"Presse à huile",{"$f":"IF(B5=INDEX(B6:B7,1,1),F94,'investissement reél'!C21)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(F:F,MATCH(F73,B:B,0)),'investissement reél'!E21)","v":2033742},15,{"$f":"C133*D133","v":2033742},{"$f":"IFERROR(F133/E133,0)","v":135582.79999999999}]
[null,"moulin solaire + variateur",{"$f":"IF(B5=INDEX(B6:B7,1,1),F95,'investissement reél'!C23)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(F:F,MATCH(F74,B:B,0)),'investissement reél'!E23)","v":700000},15,{"$f":"C134*D134","v":700000},46666.666666666664]
[null,"ampoul LED",{"$f":"IF(B5=INDEX(B6:B7,1,1),F97,'investissement reél'!C19)","v":4},{"$f":"IF(B5=INDEX(B6:B7,1,1),G25,'investissement reél'!E19)","v":2500},4,{"$f":"C135*D135","v":10000},2500]
[null,"projecteur LED",{"$f":"IF(B5=INDEX(B6:B7,1,1),F98,'investissement reél'!C22)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G27,'investissement reél'!E22)","v":40000},8,{"$f":"C136*D136","v":40000},5000]
[null,"Modules PV ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F101,'investissement reél'!C9)","v":18},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(D:D,MATCH(F75,B:B,0)),'investissement reél'!E9)","v":49800},25,896400,35856]
[null,"Support aluminium",{"$f":"IF(B5=INDEX(B6:B7,1,1),C137,0)","v":0},{"$f":"IF(B5=INDEX(B6:B7,1,1),G33,0)","v":0},null,0,0]
[null,"Batterie ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F104,'investissement reél'!C10)","v":8},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(J:J,MATCH(F76,H:H,0)),'investissement reél'!E10)","v":223252},{"$f":"F105","v":7},1786016,255145.14285714287]
[null,"Régulateur ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F106,'investissement reél'!C11)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(J:J,MATCH(F78,H:H,0)),'investissement reél'!E11)","v":316410},10,316410,31641]
[null,"Onduleur chargeur  ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F107,'investissement reél'!C12)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(D:D,MATCH(F77,B:B,0)),'investissement reél'!E12)","v":425314},10,425314,42531.4]
[null,"Demmareur ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F100,'investissement reél'!C15)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G36,'investissement reél'!E15)","v":87648},10,87648,8764.7999999999993]
[null,"Ensemble prise téléphones",0,null,null,0,0]
[null,"Coffret de protection DC ",{"$f":"IF(B5=INDEX(B6:B7,1,1),D29,'investissement reél'!C13)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G29,'investissement reél'!E13)","v":46308},10,46308,4630.8]
[null,"Coffret de protection AC",{"$f":"IF(B5=INDEX(B6:B7,1,1),D30,'investissement reél'!C14)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G30,'investissement reél'!E14)","v":2164},10,{"$f":"C145*D145","v":2164},216.4]
[null,"Câbles et accessoires et protections",{"$f":"IF(B5=INDEX(B6:B7,1,1),D31,'investissement reél'!C16)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G31,'investissement reél'!E16)","v":399000},20,399000,19950]
[null,"transprot equipement",{"$f":"IF(B5=INDEX(B6:B7,1,1),D32,'investissement reél'!C25)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G32,'investissement reél'!E25)","v":550000},"-",550000,0]
[null,"Installation ",{"$f":"IF(B5=INDEX(B6:B7,1,1),D34,'investissement reél'!C18)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G34,'investissement reél'!E18)","v":500000},0,500000,0]
[null,"locale technique ",{"$f":"IF(B5=INDEX(B6:B7,1,1),D35,'investissement reél'!C26)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G35,'investissement reél'!E26)","v":1000000},30,1000000,33333.333333333336]
[null,"Monotoring",{"$f":"IF(B5=INDEX(B6:B7,1,1),D39,'investissement reél'!C24)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G39,'investissement reél'!E24)","v":694127},null,694127,0]
[null,"ensacheuses",{"$f":"IF(B5=INDEX(B6:B7,1,1),D37,'investissement reél'!C20)","v":2},{"$f":"IF(B5=INDEX(B6:B7,1,1),G37,'investissement reél'!E20)","v":20000},10,40000,4000]
[null,"BOX batteries et SOPPORTES",{"$f":"IF(B5=INDEX(B6:B7,1,1),D38,'investissement reél'!C17)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G38,'investissement reél'!E17)","v":200000},20,200000,10000]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F133:F152)","v":9727129},{"$f":"SUM(G133:G152)","v":635818.34285714303}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité","Prix unitare","Recettes annuelles","Recettes mensuelles",null,"évolution annuelle recettes d'exploitation",null,null,0.02]
[null,"ventes d'huiles d'arrachides(L)",{"$f":"F111","v":5184},1100,{"$f":"C159*D159","v":5702400},{"$f":"E159/12","v":475200}]
[null,"ventes de tourteaux (kG)",{"$f":"C118*0.55*12","v":6336},200,{"$f":"C160*D160","v":1267200},{"$f":"E160/12","v":105600}]
[null,"prestation huile",{"$f":"16*30*12","v":5760},200,{"$f":"C161*D161","v":1152000},{"$f":"E161/12","v":96000}]
[null,"prestation mouture mil, mais ",{"$f":"F112","v":97200},25,{"$f":"C162*D162","v":2430000},202500]
[null,"ventes cereales locales",{"$f":"(C123+C122*90%)*30*12","v":10260},500,{"$f":"C163*D163","v":5130000},427500]
[null,"TOTAL (F CFA)",null,null,{"$f":"SUM(E159:E163)","v":15681600},{"$f":"SUM(F159:F163)","v":1306800}]
[]
[null,"Ressources et Financement des investissements"]
[]
[null,"BFR (Besoin en fonds de roulement)"]
[null,"Type de tiers","Client/fournisseur","Délais de paiement / stocks (jours)","Part des achats/ventes"]
[null,null,"founisseur",0,1]
[null,null,"client",0,1]
[]
[null,"Créances clients",{"$f":"((D171*F164/365*E171))","v":0}]
[null,"Crédit fournisseurs",{"$f":"(D170*F129*E170/365)*-1","v":0}]
[null,"Impact Stocks consommable",0]
[null,"Impact Stocks produits finis",0]
[null,"BFR",{"$f":"F118","v":4608000},"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é","mensualité"]
[null,"Investissements",null,{"$f":"F153","v":9727129},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F182)","v":6213237.8619269691},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F182)","v":681785.03890794679},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F182)","v":114368210.29585066},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F182)","v":6895022.9008349143},{"$f":"J182/12","v":574585.2417362429}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C177","v":4608000},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F183)","v":6648164.5122618563},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F183)","v":246858.388573059},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F183)","v":37011552.679117985},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F183)","v":6895022.9008349143},{"$f":"J183/12","v":574585.2417362429}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D182:D183)","v":14335129},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=3,3,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":0},0]
[null,"Apport personnel",{"$f":"D185/F153","v":0.10280525733749393},{"$f":"F149","v":1000000},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=4,4,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":0},0]
[null,"Subvention",0,{"$f":"C186*D184","v":0},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=5,5,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},0]
[null,"Emprunt",{"$f":"100%-(C186+C185)","v":0.8971947426625061},{"$f":"D184*C187","v":12861402.374188829},null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=6,6,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},0]
[null,"Taux de l'emprunt",null,7.0000000000000007E-2,null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=7,7,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},0]
[null,"Remboursement de l'emprunt (années)",null,2,null,{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=8,8,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},0]
[{"$nulls":5},{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},0]
[{"$nulls":5},{"$f":"IF(D189>10,\"nb an insuffisant\",IF(D189>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G182:G191)","v":12861402.374188825},{"$f":"SUM(H182:H191)","v":928643.42748100578},null,{"$f":"SUM(J182:J191)","v":13790045.801669829}]
[]
[]
[null,"Ressources et Financement des investissements"]
[]
[null,"RESULTAT BRUT D'EXPLOITATION (EBE)"]
[null,"Désignation / Durée (années)",0,1,2,3,4,5,6,7,8,9,"Total"]
[null,"Recettes  ",null,{"$f":"E164","v":15681600},{"$f":"D199+($K$158*D199)","v":15995232},16315136.640000001,16641439.3728,16974268.160255998,17313753.523461118,17660028.593930341,18013229.16580895,18373493.74912513,{"$f":"SUM(C199:L199)","v":152968181.20538154}]
[null,"Dépenses ",null,{"$f":"F129","v":7524600},{"$f":"D200+($K$117*D200)","v":7675092},{"$f":"E200+($K$117*E200)","v":7828593.8399999999},7985165.7167999996,8144869.0311359996,8307766.4117587199,8473921.7399938945,8643400.1747937724,8816268.1782896481,73399677.092772037]
[null,"Amortissements ",0,{"$f":"$G$153","v":635818.34285714303},{"$f":"$G$153","v":635818.34285714303},635818.34285714303,635818.34285714303,635818.34285714303,635818.34285714303,635818.34285714303,635818.34285714303,635818.34285714303,5722365.0857142871]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$182:$J$191,MATCH(D198,$F$182:$F$191,0)),0)","v":6895022.9008349143},{"$f":"IFERROR(INDEX($J$182:$J$191,MATCH(E198,$F$182:$F$191,0)),0)","v":6895022.9008349143},0,0,0,0,0,0,0,13790045.801669829]
[null,"Bénéfice avant impôts (EBITDA)",0,{"$f":"D199-SUM(D200:D202)","v":626158.75630794279},789298.75630794279,7850724.4571428578,8020455.3131428566,8193580.7862628549,8370168.7688452546,8550288.5110793039,8734010.6481580343,8921407.2279783394,60056093.225225389]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D203<0,0,0.3*D203)","v":187847.62689238283},236789.62689238283,2355217.3371428573,2406136.5939428569,2458074.2358788564,2511050.6306535765,2565086.5533237909,2620203.1944474103,2676422.1683935015,18016827.967567615]
[null,"Bénéfice après impôts ",0,{"$f":"D203-D204","v":438311.12941555993},552509.12941555993,5495507.120000001,5614318.7192000002,5735506.5503839981,5859118.1381916776,5985201.9577555135,6113807.453710624,6244985.0595848374,42039265.257657766]
[null,"Trésorerie",{"$f":"C199-C200","v":0},{"$f":"C206+D205","v":438311.12941555993},990820.25883111986,6486327.3788311211,12100646.098031122,17836152.648415118,23695270.786606796,29680472.74436231,35794280.198072933,42039265.257657766]
[null,"Cash Flows",0,{"$f":"D205+D202-($H$192/$D$189)","v":6869012.3165099714},6983210.3165099714,5031185.4062594986,5149997.0054594977,5271184.8366434956,5394796.4244511751,5520880.244015011,5649485.7399701215,5780663.3458443349]
[null,"Cash Flows cumulés",{"$f":"-C200","v":0},{"$f":"C208+D207","v":6869012.3165099714},13852222.633019943,18883408.039279442,24033405.044738941,29304589.881382436,34699386.305833608,40220266.549848616,45869752.289818734,51650415.63566307]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F213,IF(D198<=H213,D207,0),IF(E198<=H213,E207,0),IF(F198<=H213,F207,0),IF(G198<=H213,G207,0),IF(H198<=H213,H207,0),IF(I198<=H213,I207,0),IF(J198<=H213,J207,0),IF(K198<=H213,K207,0),IF(L198<=H213,L207,0))-D182","v":31361246.879102834},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D182+IF(H213>=D198,(D205+D202-H192/D189)*((1+F213)^-1),0)+IF(H213>=E198,(E205+E202-H192/D189)*((1+F213)^-2),0)+IF(H213>=F198,(F205+F202-H192/D189)*((1+F213)^-3),0)+IF(H213>=G198,(G205+G202-H192/D189)*((1+F213)^-4),0)+IF(H213>=H198,(H205+H202-H192/D189)*((1+F213)^-5),0)+IF(H213>=I198,(I205+I202-H192/D189)*((1+F213)^-6),0)+IF(H213>=J198,(J205+J202-H192/D189)*((1+F213)^-7),0)+IF(H213>=K198,(K205+K202-H192/D189)*((1+F213)^-8),0)+IF(H213>=L198,(L205+L202-H192/D189)*((1+F213)^-9),0)","v":31361246.879102841},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N214:W214)","v":0.63853618308399529},{"$nulls":10},{"$f":"-D182","v":-9727129},{"$f":"IF(D198<=H213,D207,0)","v":6869012.3165099714},{"$f":"IF(E198<=H213,E207,0)","v":6983210.3165099714},{"$f":"IF(F198<=H213,F207,0)","v":5031185.4062594986},{"$f":"IF(G198<=H213,G207,0)","v":5149997.0054594977},{"$f":"IF(H198<=H213,H207,0)","v":5271184.8366434956},{"$f":"IF(I198<=H213,I207,0)","v":5394796.4244511751},{"$f":"IF(J198<=H213,J207,0)","v":5520880.244015011},{"$f":"IF(K198<=H213,K207,0)","v":5649485.7399701215},{"$f":"IF(L198<=H213,L207,0)","v":5780663.3458443349}]
[null,"IPI",{"$f":"SUM(O214:W214)/D182","v":5.3099342710128621},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N215,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 4310 CFA"},{"$nulls":9},{"$f":"(C215-1)*1000","v":4309.9342710128622}]
[null,"DCRI",{"$f":"N216+(-P216/(O216-P216))","v":{"$error":"#N/A"}},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C216,0)&\" ans et \"&ROUNDDOWN((C216-ROUNDDOWN(C216,0))*12,0)&\" mois\"","v":{"$error":"#N/A"}},{"$nulls":9},{"$f":"IF(AND(L208<0,L198<=H213),L198,IF(AND(K208<0,K198<=H213),K198,IF(AND(J208<0,J198<=H213),J198,IF(AND(I208<0,I198<=H213),I198,IF(AND(H208<0,H198<=H213),H198,IF(AND(G208<0,G198<=H213),G198,IF(AND(F208<0,F198<=H213),F198,IF(AND(E208<0,E198<=H213),E198,IF(AND(D208<0,D198<=H213),D198,IF(AND(C208<0,C198<=H213),C198))))))))))","v":false},{"$f":"INDEX(C208:L208,MATCH(INDEX(C198:L198,MATCH(P216,C208:L208,0))+1,C198:L198,0))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L208<0,L198<=H213),L208,IF(AND(K208<0,K198<=H213),K208,IF(AND(J208<0,J198<=H213),J208,IF(AND(I208<0,I198<=H213),I208,IF(AND(H208<0,H198<=H213),H208,IF(AND(G208<0,G198<=H213),G208,IF(AND(F208<0,F198<=H213),F208,IF(AND(E208<0,E198<=H213),E208,IF(AND(D208<0,D198<=H213),D208,IF(AND(C208<0,C198<=H213),C208))))))))))","v":false}]
[null,"DSCR",{"$f":"(D199-D200)/(D202)","v":1.183027252746655}]

{"sheet":"Remboursement Mensualités","index":1,"n_rows":133,"n_cols":7,"rows_kept":133,"cut":false,"hidden":true,"merged":[]}
["Remboursement de prêt"]
["Taux annuel",{"$f":"'Table rentabilité'!D188","v":7.0000000000000007E-2}]
["Capital emprunté",{"$f":"'Table rentabilité'!D187","v":12861402.374188829}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité'!D189","v":2},{"$f":"B4*12","v":24}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":574585.24173624301},"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":501865.00282666},"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":72720.238909583},"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":574585.24173624301},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":501865.00282666},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":72720.238909583},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":12359537.371362168},{"$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},574585.24173624301,504702.62051749247,69882.621218750501,11854834.750844676,{"$f":"IF(A15<>\"-\",IF(G14<G15,F14,F14+1),\"\")","v":1},{"$f":"IF(A15=\"-\",\"\",IF(G14<12,G14+1,1))","v":2}]
[3,574585.24173624301,507556.28251130285,67028.959224940176,11347278.468333373,1,3]
[4,574585.24173624313,510426.07952491276,64159.162211330324,10836852.388808461,1,4]
[5,574585.24173624301,513312.10278806987,61273.138948173182,10323540.286020391,1,5]
[6,574585.24173624301,516214.44404634828,58370.797689894716,9807325.8419740424,1,6]
[7,574585.24173624301,519133.1955640649,55452.046172178067,9288192.6464099791,1,7]
[8,574585.24173624301,522068.45012721251,52516.791609030559,8766124.196282763,1,8]
[9,574585.24173624301,525020.30104640906,49564.940689833958,8241103.8952363553,1,9]
[10,574585.24173624301,527988.84215986473,46596.399576378273,7713115.0530764917,1,10]
[11,574585.24173624301,530974.16783636436,43611.073899878611,7182140.8852401264,1,11]
[12,574585.24173624301,533976.37297826773,40608.868757975288,6648164.5122618591,1,12]
[13,574585.2417362429,536995.5530245261,37589.688711716823,6111168.9592373325,2,1]
[14,574585.2417362429,540031.80395371688,34553.437782526045,5571137.1552836169,2,2]
[15,574585.24173624301,543085.22228709399,31500.019449148986,5028051.9329965217,2,3]
[16,574585.2417362429,546155.90509165649,28429.336644586449,4481896.0279048653,2,4]
[17,574585.2417362429,549243.94998323463,25341.291753008314,3932652.0779216308,2,5]
[18,574585.24173624301,552349.45512959268,22235.786606650345,3380302.6227920391,2,6]
[19,574585.24173624301,555472.51925354952,19112.722482693545,2824830.1035384871,2,7]
[20,574585.2417362429,558613.24163611722,15972.000100125699,2266216.8619023692,2,8]
[21,574585.24173624301,561771.72211965767,12813.519616585338,1704445.1397827119,2,9]
[22,574585.24173624301,564948.0611110552,9637.1806251877588,1139497.0786716565,2,10]
[23,574585.24173624301,568142.35958490986,6442.8821513331313,571354.71908674948,2,11]
[24,574585.24173624301,571354.71908674645,3230.5226494965641,-1.862645149230957E-9,2,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]

{"sheet":"investissement reél","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,2,6,3],[26,1,26,4],[6,7,7,7]]}
[]
[]
[]
[]
[null,"Investissement (CAPEX)"]
[]
[null,"Désignation","Quantité",null,"P.U. (en Fcfa)","P.T. (en Fcfa)","Durée de vie","Amortissement Annuel"]
[null,null,"Quantité","Unité"]
[null,"Modules photovoltaïque de 275 Wc et support ; (9,31A ; 39,08V)",18,"u",49800,{"$f":"C9*E9","v":896400},25,{"$f":"F9/G9","v":35856}]
[null,"Batterie de 12V, 220 Ah en C40 et support",8,"u",223252,{"$f":"C10*E10","v":1786016},7,{"$f":"F10/G10","v":255145.14285714287}]
[null,"Régulateur Victron Smart bluesolar MPPT 150V ; 85A",1,"u",316410,{"$f":"E11*C11","v":316410},10,{"$f":"F11/G11","v":31641}]
[null,"Onduleur VICTRON (48V ; 3000W)",1,"u",425314,425314,10,42531.4]
[null,"Coffret de protection DC ( 3 disjoncteurs DC 100A + Parafoudre DC class 2)",1,"ens",46308,46308,10,4630.8]
[null,"Coffret de protection AC (1 disjoncteur AC 20A)",1,"U",2164,2164,10,216.4]
[null,"Démarreur électronique 2.2 kW",1,"U",87648,87648,10,8764.7999999999993]
[null,"Matériels de raccordements  ",1,"ens",399000,399000,20,19950]
[null,"BOX batteries et SOPPORTES",1,"ens",200000,200000,20,10000]
[null,"Frais d'installation",1,"ens",500000,500000]
[null,"Ampoules led",4,"U",2500,10000,4,2500]
[null,"Ensacheuses",2,"U",20000,40000,10,4000]
[null,"Presse à huile",1,"U",2033742,2033742,15,135582.79999999999]
[null,"Projecteur led",1,"U",40000,40000,8,5000]
[null,"Moulin Solaire + variateur",1,"U",700000,700000,15,46666.666666666664]
[null,"Coor control ",1,"U",694127,694127]
[null,"Transport système solaire + presse ",1,"U",550000,550000]
[null,"local (batiment)",1,null,1000000,1000000,30,33333.333333333336]
[null,"Total",null,null,null,{"$f":"SUM(F9:F26)","v":9727129},null,{"$f":"SUM(H9:H26)","v":635818.34285714291}]