{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Table rentabilité","Remboursement Mensualités","dimensionnement réel"],"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":202,"n_cols":23,"rows_kept":202,"cut":false,"hidden":false,"merged":[[16,7,17,7],[16,8,16,9],[16,10,17,10],[16,6,17,6],[16,2,17,2],[16,3,16,4],[74,5,74,6],[78,5,78,6],[22,2,23,2],[22,4,23,4],[16,5,17,5],[22,3,23,3],[51,1,52,1],[51,7,52,7],[53,1,54,1],[53,7,54,7],[69,5,69,6],[66,5,66,6]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Presse à huile d'arachide"]
[]
[null,"réel"]
[null,"optimisé"]
[null,"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 (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 KK",{"$f":"8*I19","v":96},"-",0.35,{"$f":"IF(B5=INDEX(B6:B7,1,1),F16,'dimensionnement réel'!E18)","v":2033742},{"$f":"E19*I19","v":4.1999999999999993},{"$f":"E19*I19/K19","v":5.2499999999999991},12,365,0.8]
[null,null,null,"-",null,null,{"$f":"E20*I20","v":0},{"$f":"E20*I20/K20","v":0},null,365,0.8]
[null,null,null,"-",null,null,0,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,"Ampoule LED",7.0000000000000001E-3,4,{"$f":"C25*F25*D25","v":0.33600000000000002},12,5000]
[null,"Projecteur LED",0.3,1,{"$f":"C26*F26*D26","v":0.6},2,40000]
[{"$nulls":4},{"$f":"C27*F27","v":0},null,null,{"$f":"0.936+0.36","v":1.296}]
[null,"Coffret de protection DC ",null,1,null,null,21550]
[null,"Coffret de protection AC",null,1,null,null,2162]
[null,"Câbles et accessoires et protections",null,1,null,null,150000]
[null,"transprot equipement",null,1,null,null,400000]
[null,"Installation ",null,1,null,null,500000]
[null,"locale technique ",null,1,null,null,1000000]
[null,"demarreur",null,1,null,null,87648]
[null,"support",null,1,null,null,7500]
[null,"Monotoring",null,1,"-"]
[]
[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.26500000000000001,124000,0.6,"24V",null,"Batterie de 12V, 265 Ah en C40 ",265,400000,12,10]
[null,"Modules polycristallins 275",0.27500000000000002,49191,null,24,null,"Gel 220Ah 12V",220,360250,12,10]
[null,"Tension nécessaire ",{"$f":"IF(J41<0.5,\"12V\",IF(AND(J41>=0.5,J41<2),\"24V\",IF(J41>=2,\"48V\")))","v":"24V"},{"$nulls":4},"Tension nécessaire batteries",{"$f":"IF(J41<0.5,12,IF(AND(J41>=0.5,J41<2),24,IF(J41>=2,48)))","v":24},{"$f":"F96*INDEX(C:C,MATCH(F71,B:B,0))","v":1.1000000000000001}]
[]
[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,"Xtender 4 KVA",4,500000,null,null,null,"Régulateur Victron Smart bluesolar MPPT 100V ; 80A","100/80",150000]
[]
[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":"(F86*30)-SUM(K52:L52)","v":50},{"$f":"IF((F86*30)>D52,(F86*30)-D52-L52,0)","v":104.07999999999998},{"$f":"IF((F86*30)>E52,(F86*30)-E52,0)","v":0},{"$f":"SUM(J52:L52)","v":154.07999999999998}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J52*D53","v":6442.5},14121.574399999998,0,20564.074399999998]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F86*30)-SUM(K54:L54)","v":100},{"$f":"IF((F86*30)>D54,(F86*30)-D54-L54,0)","v":54.079999999999984},{"$f":"IF((F86*30)>E54,(F86*30)-E54,0)","v":0},154.07999999999998]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J54*D55","v":12981},7383.5423999999975,0,20364.542399999998]
[]
[null,"Frais fixes de raccordement","Fixe/Distance","Prix TTC","Étude raccordement"]
[null,"Réseau HTA","Kg câble","10.000 à 100.000",550000]
[null,"Réseau HTA - Autres Frais","Fixe","2.000.000 à 7.000.000",550000]
[null,"Transformateur HT/MT - BT","Fixe",4800000,179000]
[null,"Extension BT*","Distance",8260,179000]
[null,"Dépend également de la distance de transport des équipements et nombre et type de poteaux non mesurable sauf par Sénélec (approximation)"]
[]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"Production min. souhaitée (kg /jour)",null,null,null,{"$f":"C19","v":96}]
[]
[]
[null,"Choix presse à huiles",null,null,null,"Presse à huile KK"]
[null,"Choix de l'alimentation solaire",null,null,null,"Modules polycristallins 275"]
[null,"Choix du système de stokage",null,null,null,"Batterie de 12V, 265 Ah en C40 "]
[null,"Choix de l'onduleur",null,null,null,"Onduleur 2KVA"]
[null,"Choix du régulateur",null,null,null,"Régulateur Victron Smart bluesolar MPPT 100V ; 50A"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M52<M54,B52,B54)","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:E36)+INDEX(G:G,MATCH(F70,B:B,0))","v":5.1359999999999992},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F70,B:B,0))+SUM(E25:E36))/O49*F90","v":1.0292845257903493},"KW"]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(INDEX(G:G,MATCH(F70,B:B,0))+SUM(E26:E33))*1000*(F79)/(F80*I41)","v":249.99999999999991},"Ah"]
[]
[null,"nombre presse à huile",null,null,null,{"$f":"ROUNDUP(F67/(C19),0)","v":1},"unités"]
[null,"puissance equippement journaliere majoré (KW)",null,null,null,{"$f":"(SUM(E19:E21)+SUM(E25:E36))*1.2","v":1.5431999999999999},"unités"]
[null,"Ampoules LED",null,null,null,{"$f":"D25","v":4},"unités"]
[null,"projecteur LED",null,null,null,{"$f":"D26","v":1},"unités"]
[null,"Nb ensemble prises",null,null,null,1,"unités"]
[null,"Nb de demmareur",null,null,null,1,"unités"]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F87/INDEX(C:C,MATCH(F71,B:B,0)),0)","v":4},"unités"]
[null,"Nb de batteries en série",null,null,null,{"$f":"I41/INDEX(K:K,MATCH(F72,H:H,0))","v":2},"unités"]
[null,"Nb de batteries en dérivation",null,null,null,{"$f":"ROUNDUP(F88/INDEX(I:I,MATCH(F72,H:H,0)),0)","v":1},"unités"]
[null,"Nb de batteries total",null,null,null,{"$f":"F97*F98","v":2},"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(C41=24,C41=12),1,1)","v":1},"unités"]
[null,"Nb onduleurs",null,null,null,{"$f":"ROUNDUP(F91/INDEX(C:C,MATCH(F73,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,"quantité d'arachide annuelle pressée attendue en Kg ",null,null,null,{"$f":"INDEX(C:C,MATCH($F$70,B:B,0))*INDEX(J:J,MATCH($F$70,B:B,0))*F104*F90","v":31536},"Kg"]
[]
[]
[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":"F106","v":31536},250,{"$f":"C113*D113/12","v":657000},{"$f":"E113*12","v":7884000}]
[null,"bidons vides pour conditionnement",8,100,{"$f":"C114*D114*30","v":24000},{"$f":"E114*12","v":288000},null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"((MIN(M55,M53)*12)+IF(F76=\"MT\",(G76*D61)+D60+E58+F77,(G76*D61)))-(SUM(F127:F131,F137)+SUM(G127:G131,G137))","v":11930018.388799999}]
[null,"salaires equipe presse",2,30000,{"$f":"C115*D115","v":60000},{"$f":"E115*12","v":720000}]
[null,"faris de maintenaice/trois mois",null,20000,{"$f":"F116/12","v":5000},{"$f":"D116*3","v":60000},null,null,null,"Sur 5 ans",{"$f":"((MIN(M55,M53)*12*5)+IF(F76=\"MT\",(G76*D61)+D60+E58+F77,(G76*D61)))-(SUM(F127:F131,F137)+(SUM(G127:G131,G137)*5))","v":12270463.944}]
[null,"transport",1,10000,{"$f":"C117*D117","v":10000},{"$f":"D117*12","v":120000}]
[null,"divers",1]
[{"$nulls":9},"Sur 10 ans",{"$f":"((MIN(M55,M53)*12*10)+IF(F76=\"MT\",(G76*D61)+D60+E58+F77,(G76*D61)))-(SUM(F127:F131,F137)+(SUM(G127:G131,G137)*10))","v":12696020.888}]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E113:E119)","v":756000},{"$f":"SUM(F113:F119)","v":9072000}]
[]
[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),F90,'dimensionnement réel'!C18)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(F:F,MATCH(F70,B:B,0)),'dimensionnement réel'!E18)","v":2033742},10,{"$f":"C124*D124","v":2033742},{"$f":"IFERROR(F124/E124,0)","v":203374.2}]
[null,"ampoul LED",{"$f":"IF(B5=INDEX(B6:B7,1,1),D25,'dimensionnement réel'!C17)","v":4},{"$f":"IF(B5=INDEX(B6:B7,1,1),G25,'dimensionnement réel'!E17)","v":5000},4,{"$f":"C125*D125","v":20000},5000]
[null,"projecteur LED",{"$f":"IF(B5=INDEX(B6:B7,1,1),F93,'dimensionnement réel'!C19)","v":2},{"$f":"IF(B5=INDEX(B6:B7,1,1),C126,'dimensionnement réel'!E19)","v":40000},10,{"$f":"C126*D126","v":80000},8000]
[null,"Modules PV ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F96,'dimensionnement réel'!C7)","v":8},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(D:D,MATCH(F71,B:B,0)),'dimensionnement réel'!E7)","v":49191},25,{"$f":"C127*D127","v":393528},{"$f":"IFERROR(F127/E127,0)","v":15741.12}]
[null,"Support aluminium",{"$f":"IF(B5=INDEX(B6:B7,1,1),C127,'dimensionnement réel'!C15)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G35,'dimensionnement réel'!E15)","v":100000},20,100000,5000]
[null,"Batterie ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F99,'dimensionnement réel'!C8)","v":2},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(J:J,MATCH(F72,H:H,0)),'dimensionnement réel'!E8)","v":327957},{"$f":"F100","v":7},655914,93702]
[null,"Régulateur ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F101,'dimensionnement réel'!C9)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(J:J,MATCH(F74,H:H,0)),'dimensionnement réel'!E9)","v":114700},10,114700,11470]
[null,"Onduleur chargeur  ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F102,'dimensionnement réel'!C10)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),INDEX(D:D,MATCH(F73,B:B,0)),'dimensionnement réel'!E10)","v":333500},10,333500,33350]
[null,"Demmareur ",{"$f":"IF(B5=INDEX(B6:B7,1,1),F95,'dimensionnement réel'!C13)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G34,'dimensionnement réel'!E13)","v":87648},10,87648,8764.7999999999993]
[null,"Coffret de protection DC ",{"$f":"IF(B5=INDEX(B6:B7,1,1),D28,'dimensionnement réel'!C11)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G28,'dimensionnement réel'!E11)","v":21550},10,{"$f":"C133*D133","v":21550}]
[null,"Coffret de protection AC",{"$f":"IF(B5=INDEX(B6:B7,1,1),D29,'dimensionnement réel'!C12)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G29,'dimensionnement réel'!E12)","v":2162},10,2162]
[null,"Câbles et accessoires et protections",{"$f":"IF(B5=INDEX(B6:B7,1,1),D30,'dimensionnement réel'!C14)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G30,'dimensionnement réel'!E14)","v":200000},20,200000,10000]
[null,"transport equipement",{"$f":"IF(B5=INDEX(B6:B7,1,1),D31,'dimensionnement réel'!C22)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G31,'dimensionnement réel'!E22)","v":550000},null,550000]
[null,"Installation ",{"$f":"IF(B5=INDEX(B6:B7,1,1),D32,'dimensionnement réel'!C16)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G32,'dimensionnement réel'!E16)","v":500000},0,500000,0]
[null,"locale technique ",{"$f":"IF(B5=INDEX(B6:B7,1,1),D33,'dimensionnement réel'!C21)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),G33,'dimensionnement réel'!E21)","v":1000000},20,1000000,50000]
[null,"Monotoring",{"$f":"IF(B5=INDEX(B6:B7,1,1),D36,'dimensionnement réel'!C23)","v":1},{"$f":"IF(B5=INDEX(B6:B7,1,1),D36*G36,'dimensionnement réel'!E23)","v":393560},null,393560]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F124:F139)","v":6486304},{"$f":"SUM(G124:G138)","v":444402.12}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité","Prix unitare","Recettes annuelles","Recettes mensuel",null,"évolution annuelle recettes d'exploitation",null,null,0.02]
[null,"ventes d'huiles d'arrachides(L)",{"$f":"F106*0.35","v":11037.599999999999},1100,{"$f":"C146*D146","v":12141359.999999998},{"$f":"E146/12","v":1011779.9999999999}]
[null,"ventes de tourteaux (kG)",7922,200,{"$f":"C147*D147","v":1584400},{"$f":"E147/12","v":132033.33333333334}]
[]
[null,"TOTAL (F CFA)",null,null,{"$f":"SUM(E146:E148)","v":13725759.999999998},{"$f":"SUM(F146:F148)","v":1143813.3333333333}]
[]
[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":"((D156*F149/365*E156))","v":0}]
[null,"Crédit fournisseurs",{"$f":"(D155*F120*E155/365)*-1","v":0}]
[null,"Impact Stocks consommable",0]
[null,"Impact Stocks produits finis",0]
[null,"BFR",{"$f":"F113","v":7884000},"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":"F140","v":6486304},null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":2543206.8701662542},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":1254004.2872863284},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":129613148.09843665},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":3797211.1574525819},{"$f":"J167/12","v":316434.26312104851}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C162","v":7884000},null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":2848391.6945862081},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":948819.46286637511},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":97145302.90994972},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":3797211.1574525819},{"$f":"J168/12","v":316434.26312104851}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D167:D168)","v":14370304},null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":3190198.6979365554},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":607012.45951602771},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":60781316.298844323},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":3797211.1574525819},316434.26312104851]
[null,"Apport personnel",{"$f":"D170/F140","v":0.15417100401091283},{"$f":"F138","v":1000000},null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":3573022.5416889447},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":224188.61576363805},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":20053651.29440625},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":3797211.1574525819},316434.26312104851]
[null,"Subvention",0,{"$f":"C171*D169","v":0},null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=5,5,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},0]
[null,"Emprunt",{"$f":"100%-(C171+C170)","v":0.84582899598908723},{"$f":"D169*C172","v":12154819.804377964},null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=6,6,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},0]
[null,"Taux de l'emprunt",null,0.12,null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=7,7,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F173)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F173)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F173)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F173)","v":0},0]
[null,"Remboursement de l'emprunt (années)",null,4,null,{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=8,8,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F174)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F174)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F174)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F174)","v":0},0]
[{"$nulls":5},{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F175)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F175)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F175)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F175)","v":0},0]
[{"$nulls":5},{"$f":"IF(D174>10,\"nb an insuffisant\",IF(D174>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F176)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F176)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F176)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F176)","v":0},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G167:G176)","v":12154819.804377962},3034024.8254323695,null,15188844.629810328]
[]
[]
[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":"E149","v":13725759.999999998},{"$f":"D184+($K$145*D184)","v":14000275.199999997},14280280.703999998,14565886.318079999,14857204.044441599,15154348.125330431,15457435.08783704,15766583.78959378,16081915.465385657,{"$f":"SUM(C184:L184)","v":133889688.73466851}]
[null,"Dépenses ",null,{"$f":"SUM(F114:F117)","v":1188000},{"$f":"(F113+D185)+(F113+D185)*$K$112","v":9253440},{"$f":"E185+($K$112*E185)","v":9438508.8000000007},{"$f":"F185+($K$112*F185)","v":9627278.9760000017},{"$f":"G185+($K$112*G185)","v":9819824.5555200018},10016221.046630401,10216545.467563009,10420876.376914268,10629293.904452553,80609989.127080232]
[null,"Amortissements ",null,{"$f":"$G$140","v":444402.12},444402.12,444402.12,444402.12,444402.12,444402.12,444402.12,444402.12,444402.12,3999619.0800000005]
[null,"Remboursement emprunt",null,{"$f":"IFERROR(INDEX($J$167:$J$176,MATCH(D183,$F$167:$F$176,0)),0)","v":3797211.1574525819},3797211.1574525819,3797211.1574525819,3797211.1574525819,0,0,0,0,0,15188844.629810328]
[null,"Bénéfice avant impôts (EBITDA)",null,{"$f":"D184-SUM(D185:D187)","v":8296146.7225474156},505221.92254741676,600158.62654741667,696994.06462741643,4592977.3689215984,4693724.958700031,4796487.5002740324,4901305.2926795129,5008219.4409331046,34091235.897777945]
[null,"Impôts sur le bénéfice ",null,{"$f":"IF(D188<0,0,0.3*D188)","v":2488844.0167642245},151566.57676422503,180047.58796422501,209098.21938822491,1377893.2106764794,1408117.4876100093,1438946.2500822097,1470391.5878038539,1502465.8322799313,10227370.769333385]
[null,"Bénéfice après impôts ",null,{"$f":"D188-D189","v":5807302.7057831911},353655.34578319173,420111.03858319169,487895.84523919155,3215084.1582451193,3285607.4710900215,3357541.2501918226,3430913.7048756592,3505753.6086531733,23863865.128444564]
[null,"Trésorerie",null,{"$f":"C191+D190","v":5807302.7057831911},6160958.0515663829,6581069.0901495749,7068964.9353887662,10284049.093633886,13569656.564723909,16927197.814915732,20358111.519791391,23863865.128444564]
[null,"Cash Flows",null,{"$f":"D190+D187-($H$177/$D$174)","v":8846007.6568776816},3392360.2968776813,3458815.9896776811,3526600.7963336813,2456577.9518870269,2527101.2647319292,2599035.0438337303,2672407.4985175668,2747247.4022950809]
[null,"Cash Flows cumulés",null,{"$f":"C193+D192","v":8846007.6568776816},12238367.953755364,15697183.943433044,19223784.739766724,21680362.691653751,24207463.95638568,26806499.000219408,29478906.498736974,32226153.901032053]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F198,IF(D183<=H198,D192,0),IF(E183<=H198,E192,0),IF(F183<=H198,F192,0),IF(G183<=H198,G192,0),IF(H183<=H198,H192,0),IF(I183<=H198,I192,0),IF(J183<=H198,J192,0),IF(K183<=H198,K192,0),IF(L183<=H198,L192,0))-D167","v":20141965.905712593},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D167+IF(H198>=D183,(D190+D187-H177/D174)*((1+F198)^-1),0)+IF(H198>=E183,(E190+E187-H177/D174)*((1+F198)^-2),0)+IF(H198>=F183,(F190+F187-H177/D174)*((1+F198)^-3),0)+IF(H198>=G183,(G190+G187-H177/D174)*((1+F198)^-4),0)+IF(H198>=H183,(H190+H187-H177/D174)*((1+F198)^-5),0)+IF(H198>=I183,(I190+I187-H177/D174)*((1+F198)^-6),0)+IF(H198>=J183,(J190+J187-H177/D174)*((1+F198)^-7),0)+IF(H198>=K183,(K190+K187-H177/D174)*((1+F198)^-8),0)+IF(H198>=L183,(L190+L187-H177/D174)*((1+F198)^-9),0)","v":20141965.905712597},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N199:W199)","v":0.91682490271085015},{"$nulls":10},{"$f":"-D167","v":-6486304},{"$f":"IF(D183<=H198,D192,0)","v":8846007.6568776816},{"$f":"IF(E183<=H198,E192,0)","v":3392360.2968776813},{"$f":"IF(F183<=H198,F192,0)","v":3458815.9896776811},{"$f":"IF(G183<=H198,G192,0)","v":3526600.7963336813},{"$f":"IF(H183<=H198,H192,0)","v":2456577.9518870269},{"$f":"IF(I183<=H198,I192,0)","v":2527101.2647319292},{"$f":"IF(J183<=H198,J192,0)","v":2599035.0438337303},{"$f":"IF(K183<=H198,K192,0)","v":2672407.4985175668},{"$f":"IF(L183<=H198,L192,0)","v":2747247.4022950809}]
[null,"IPI",{"$f":"SUM(O199:W199)/D167","v":4.9683385023323074},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N200,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 3968 CFA"},{"$nulls":9},{"$f":"(C200-1)*1000","v":3968.3385023323076}]
[null,"DCRI",{"$f":"N201+(-P201/(O201-P201))","v":{"$error":"#N/A"}},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C201,0)&\" ans et \"&ROUNDDOWN((C201-ROUNDDOWN(C201,0))*12,0)&\" mois\"","v":{"$error":"#N/A"}},{"$nulls":9},{"$f":"IF(AND(L193<0,L183<=H198),L183,IF(AND(K193<0,K183<=H198),K183,IF(AND(J193<0,J183<=H198),J183,IF(AND(I193<0,I183<=H198),I183,IF(AND(H193<0,H183<=H198),H183,IF(AND(G193<0,G183<=H198),G183,IF(AND(F193<0,F183<=H198),F183,IF(AND(E193<0,E183<=H198),E183,IF(AND(D193<0,D183<=H198),D183,IF(AND(C193<0,C183<=H198),C183))))))))))","v":false},{"$f":"INDEX(C193:L193,MATCH(INDEX(C183:L183,MATCH(P201,C193:L193,0))+1,C183:L183,0))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L193<0,L183<=H198),L193,IF(AND(K193<0,K183<=H198),K193,IF(AND(J193<0,J183<=H198),J193,IF(AND(I193<0,I183<=H198),I193,IF(AND(H193<0,H183<=H198),H193,IF(AND(G193<0,G183<=H198),G193,IF(AND(F193<0,F183<=H198),F193,IF(AND(E193<0,E183<=H198),E193,IF(AND(D193<0,D183<=H198),D193,IF(AND(C193<0,C183<=H198),C193))))))))))","v":false}]
[null,"DSCR",{"$f":"(D184-D185)/(D187)","v":3.3018337617050375}]

{"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é'!D173","v":0.12}]
["Capital emprunté",{"$f":"'Table rentabilité'!D172","v":12154819.804377964}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité'!D174","v":4},{"$f":"B4*12","v":48}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":316434.26312104857},"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":201099.69484013689},"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":115334.5682809117},"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":316434.26312104857},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":201099.69484013689},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":115334.5682809117},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":11953720.109537827},{"$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},316434.26312104857,203007.88820368276,113426.3749173658,11750712.221334144,{"$f":"IF(A15<>\"-\",IF(G14<G15,F14,F14+1),\"\")","v":1},{"$f":"IF(A15=\"-\",\"\",IF(G14<12,G14+1,1))","v":2}]
[3,316434.26312104857,204934.18801893448,111500.07510211406,11545778.03331521,1,3]
[4,316434.26312104857,206878.76609426309,109555.4970267855,11338899.267220946,1,4]
[5,316434.26312104857,208841.79586829359,107592.46725275497,11130057.471352654,1,5]
[6,316434.26312104857,210823.45242537427,105610.81069567428,10919234.018927278,1,6]
[7,316434.26312104857,212823.91251119258,103610.35060985597,10706410.106416086,1,7]
[8,316434.26312104857,214843.35454853909,101590.90857250946,10491566.751867548,1,8]
[9,316434.26312104857,216881.95865322137,99552.304467827169,10274684.793214325,1,9]
[10,316434.26312104857,218939.90665012863,97494.356470919927,10055744.886564195,1,10]
[11,316434.26312104857,221017.38208944863,95416.881031599929,9834727.5044747479,1,11]
[12,316434.26312104857,223114.57026303906,93319.692858009541,9611612.9342117086,1,12]
[13,316434.26312104857,225231.65822095348,91202.604900095059,9386381.2759907544,2,1]
[14,316434.26312104857,227368.83478812489,89065.428332923664,9159012.4412026312,2,2]
[15,316434.26312104857,229526.29058120682,86907.972539841721,8929486.1506214235,2,3]
[16,316434.26312104857,231704.21802557484,84730.045095473703,8697781.932595849,2,4]
[17,316434.26312104857,233902.81137248903,82531.451748559557,8463879.1212233603,2,5]
[18,316434.26312104857,236122.2667164194,80311.996404629157,8227756.8545069396,2,6]
[19,316434.26312104857,238362.78201253587,78071.481108512671,7989394.0724944053,2,7]
[20,316434.26312104857,240624.55709436399,75809.706026684551,7748769.5154000409,2,8]
[21,316434.26312104857,242907.79369160818,73526.469429440374,7505861.7217084328,2,9]
[22,316434.26312104857,245212.69544814428,71221.567672904304,7260649.0262602875,2,10]
[23,316434.26312104857,247539.46794018269,68894.795180865884,7013109.558320106,2,11]
[24,316434.26312104857,249888.31869460395,66545.944426444636,6763221.2396255024,2,12]
[25,316434.26312104851,252259.45720746811,64174.805913580429,6510961.782418034,3,1]
[26,316434.26312104857,254653.0949627001,61781.168158348461,6256308.6874553328,3,2]
[27,316434.26312104857,257069.4454509519,59364.81767009668,5999239.2420043806,3,3]
[28,316434.26312104857,259508.72418864406,56925.53893240451,5739730.5178157371,3,4]
[29,316434.26312104857,261971.14873718793,54463.114383860644,5477759.3690785496,3,5]
[30,316434.26312104857,264456.93872238998,51977.324398658602,5213302.4303561589,3,6]
[31,316434.26312104857,266966.31585404044,49467.947267008138,4946336.114502118,3,7]
[32,316434.26312104857,269499.5039456879,46934.759175360647,4676836.6105564302,3,8]
[33,316434.26312104857,272056.72893460141,44377.534186447177,4404779.8816218292,3,9]
[34,316434.26312104857,274638.21890192182,41796.044219126758,4130141.6627199082,3,10]
[35,316434.26312104857,277244.20409300487,39190.059028043717,3852897.4586269027,3,11]
[36,316434.26312104857,279874.91693795664,36559.346183091919,3573022.5416889451,3,12]
[37,316434.26312104857,282530.59207236452,33903.671048684017,3290491.9496165812,4,1]
[38,316434.26312104857,285211.46635822434,31222.796762824204,3005280.4832583591,4,2]
[39,316434.26312104857,287917.77890506637,28516.484215982215,2717362.7043532915,4,3]
[40,316434.26312104857,290649.77109128161,25784.492029766974,2426712.9332620092,4,4]
[41,316434.26312104857,293407.68658565072,23026.576535397842,2133305.2466763575,4,5]
[42,316434.26312104851,296191.77136907697,20242.491751971556,1837113.4753072839,4,6]
[43,316434.26312104857,299002.27375652554,17431.989364523026,1538111.2015507556,4,7]
[44,316434.26312104857,301839.44441917073,14594.818701877843,1236271.7571315877,4,8]
[45,316434.26312104857,304703.53640675382,11730.726714294738,931568.22072483227,4,9]
[46,316434.26312104857,307594.80517015269,8839.4579508958668,623973.41555467993,4,10]
[47,316434.26312104857,310513.50858416571,5920.7545368828742,313459.90697051212,4,11]
[48,316434.26312104857,313459.90697051171,2974.3561505368502,1.862645149230957E-9,4,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]

{"sheet":"dimensionnement réel","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,2,4,3]]}
[]
[]
[null,"Investissement (CAPEX)"]
[]
[null,"Désignation","Quantité",null,"P.U. (en Fcfa)","P.T. (en Fcfa)","Durée de vie"]
[null,null,"Quantité","Unité",null,null,null,"Amortissement Annuel"]
[null,"Modules photovoltaïque de 275 Wc et t ; (9,31A ; 39,08V)",8,"u",49191,{"$f":"C7*E7","v":393528},25,{"$f":"F7/G7","v":15741.12}]
[null,"Batterie de 12V, 265 Ah en C40 ",2,"u",327957,{"$f":"C8*E8","v":655914},7,{"$f":"F8/G8","v":93702}]
[null,"Régulateur Victron Smart bluesolar MPPT 100V ; 50A",1,"u",114700,{"$f":"E9*C9","v":114700},10,11470]
[null,"Onduleur VICTRON (24V ; 2000W)",1,"u",333500,333500,10,33350]
[null,"Coffret de protection DC (2 disjoncteurs DC 40A + Parafoudre DC class 2)",1,"ens",21550,21550,10,2155]
[null,"Coffret de protection AC (1 disjoncteur AC 20A)",1,"U",2162,2162,10,216.2]
[null,"Démarreur électronique 2.2 kW",1,"U",87648,87648,10,8764.7999999999993]
[null,"Matériels de raccordements  ",1,"ens",200000,200000,20,10000]
[null,"BOX batteries et SOPPORTES",1,"ens",100000,100000,15,6666.666666666667]
[null,"Frais d'installation",1,"ens",500000,500000,20,0]
["<","Ampoules led",4,"U",5000,20000,4,5000]
[null,"Presse à huile",1,"U",2033742,2033742,10,{"$f":"F18/G18","v":203374.2}]
[null,"Projecteur led",2,"U",40000,80000,10,8000]
[null,"Autres",1,"u",null,0,10,0]
[null,"Batiment ",1,"u",1000000,1000000,20,50000]
[null,"transport presse et système solaire",1,"u",550000,550000,"-"]
[null,"Monitoring",1,"u",393560,393560]
[null,"Total",null,null,null,{"$f":"SUM(F7:F23)","v":6486304},null,{"$f":"SUM(H7:H23)","v":448439.98666666669}]