{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Table rentabilité","Remboursement Mensualités","investissement réel"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":196,"n_cols":23,"rows_kept":196,"cut":false,"hidden":false,"merged":[[16,2,17,2],[16,3,16,4],[16,5,17,5],[66,5,66,6],[101,2,101,3],[99,2,99,3],[16,7,17,7],[65,5,65,6],[16,6,17,6],[16,10,17,10],[16,8,16,9],[48,1,49,1],[48,7,49,7],[50,1,51,1],[50,7,51,7],[135,2,135,3],[111,2,111,3],[68,5,68,6],[77,5,77,6],[100,2,100,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[137,2,137,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[133,2,133,3],[134,2,134,3],[132,2,132,3],[136,2,136,3]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Menuiserie Métallique"]
[]
[null,"Dimmensionnement réel"]
[null,"Dimmensionnement optimisé "]
[null,"Dimmensionnement réel"]
[]
[]
[null,"Cases à vérifier"]
[null,"Cases à compléter"]
[null,"Cases à laisser vides"]
[null,"Cases calculées"]
[]
[null,"Caractéristiques techniques du Projet"]
[]
[null,"Usage Productif","Rendement (kg/heure)","Puissance (kW)",null,"Prix (FCFA)","Energie consommée (KWh/j)","Energie à produire (kWh/j)","Fonctionnement optimal",null,"Coefficient déperdition (k)"]
[null,null,null,"Projet","Nominale",null,null,null,"heures par jour","jours à l'année"]
[null,"Poste de soudure",null,null,2,250000,{"$f":"E19*I19","v":6},{"$f":"G19/K19","v":7.5},3,365,0.8]
[null,"Meule",null,null,1,40000,{"$f":"E20*I20","v":6},{"$f":"G20/K20","v":7.5},6,null,0.8]
[null,"Perceuse",null,null,1,{"$f":"100000","v":100000},6,{"$f":"G21/K21","v":7.5},6,null,0.8]
[{"$nulls":8},6]
[]
[]
[null,"Equipements facultatifs"]
[null,"designation","nombre","prix"]
[null,"Installation atelier",1,1500000]
[null,"Construction Bureau",1,500000]
[null," Construction magasin de vente de pièces détaillées dans l'atelier ",1,1500000]
[null,"Plat pour moteur",1,160000]
[null,"Etau",1,40000]
[null,"Accessoires",1,2618801]
[]
[]
[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,"Panneaux solaires de 375 W",0.375,97987,0.6,"24V",null,"Batteries de 12 V/185 Ah    ",185,433902,12,10]
[null,"BlueSolar SPM-300-24 Monocristallin",0.3,100000,0.6,"24V",null,"Victron Energy Gel 2",265,null,12,10]
[{"$nulls":7},"Tension nécessaire système",{"$f":"IF(J38<0.5,12,IF(AND(J38>=0.5,J38<2),24,IF(J38>=2,48)))","v":48},{"$f":"F84*INDEX(C:C,MATCH(F62,B:B,0))","v":4.125}]
[]
[null,"Onduleur","kVa","Prix (FCFA)",null,null,null,"Régulateur","Courant (A)","Prix (FCFA)","Tension (V)"]
[null,"Onduleur chargeur Victron QUATTRO         ",2,2116221,null,null,null,"BlueSolar 150V 35A de Victron Energy",35,220000,"12V/24V/48V"]
[null,"Victron quatro 5 kW",5,1426500,null,null,null,"Régulateur de charge Smartsolar Victron MPPT 250/100                          ",100,400000,"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é'!G72=\"x\",MAX(C46:N46),IF('Table rentabilité'!G73=\"x\",MIN(C46:N46),IF('Table rentabilité'!G74=\"x\",AVERAGE(C46:N46),\"erreur\")))","v":5.8421666666666674}]
[]
[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":"(F77*30)-SUM(K49:L49)","v":50},{"$f":"IF((F77*30)>D49,(F77*30)-D49-L49,0)","v":450},{"$f":"IF((F77*30)>E49,(F77*30)-E49,0)","v":40},{"$f":"SUM(J49:L49)","v":540}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J49*D50","v":6442.5},{"$f":"K49*E50","v":61056},{"$f":"L49*F50","v":5907.2000000000007},{"$f":"SUM(J50:L50)","v":73405.7}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F77*30)-SUM(K51:L51)","v":100},{"$f":"IF((F77*30)>D51,(F77*30)-D51-L51,0)","v":400},{"$f":"IF((F77*30)>E51,(F77*30)-E51,0)","v":40},540]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J51*D52","v":12981},{"$f":"K51*E52","v":54612},5969.6,73562.600000000006]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"Production min. equipements (Nb equip/jour)",null,null,null,{"$f":"INDEX(C:C,MATCH($F$61,B:B,0))*INDEX(I:I,MATCH($F$61,B:B,0))","v":0}]
[null,"Temps de fonctionnement (heures/jour)",null,null,null,9]
[]
[null,"Choix du poste",null,null,null,"Poste de soudure"]
[null,"Choix du meule",null,null,null,"Meule"]
[null,"Choix de la perceuse",null,null,null,"Perceuse"]
[null,"Choix de l'alimentation solaire",null,null,null,"Panneaux solaires de 375 W"]
[null,"Choix du système de stokage",null,null,null,"Batteries de 12 V/185 Ah    "]
[null,"Choix de l'onduleur",null,null,null,"Onduleur chargeur Victron QUATTRO                           "]
[null,"Choix du régulateur",null,null,null,"Régulateur de charge Smartsolar Victron MPPT 250/100         "]
[null,"Choix décortiqueuse solaire"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M50<M52,B49,B51)","v":"UP-Petite Puissance"}]
[]
[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,"puissance equipement total majoré",null,null,null,{"$f":"SUM(E19:E21)*1.2","v":4.8}]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"G19+G20+G21+G22","v":18},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F61,B:B,0))+INDEX(H:H,MATCH(F61,B:B,0))+INDEX(H:H,MATCH(F61,B:B,0)))/O46","v":3.8513108721079505}]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(((G19+G20+G21)*1000)*(F69))/(F70*I38)","v":468.74999999999994}]
[]
[null,"Nombre de poste ",null,null,null,1,"unités"]
[null,"Nombre de meule",null,null,null,1]
[null,"Nombre de perceuse",null,null,null,1,"unités"]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F78/INDEX(C:C,MATCH(F62,B:B,0)),0)","v":11},"unités"]
[null,"Nb de batteries en série",null,null,null,{"$f":"ROUNDUP(I38/INDEX(K:K,MATCH(F63,H:H,0)),0)","v":4},"unités"]
[null,"Nb de batteries en dérivation",null,null,null,{"$f":"ROUNDUP(F79/INDEX(I:I,MATCH(F63,H:H,0)),0)","v":3},"unités"]
[null,"Nb de batteries total",null,null,null,{"$f":"F85*F86","v":12},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,{"$f":"INDEX(L:L,MATCH(F63,H:H,0))*(130%-F70)","v":5},"ans"]
[null,"Nb régulateurs",null,null,null,{"$f":"IF(OR(I38=24,I38=12),1,2)","v":2},"unités"]
[null,"Nb onduleurs",null,null,null,1,"unités"]
[]
[null,"Ratio de fonctionnement ",null,null,null,0.9]
[null,"Employés nécessaires pour fonctionnement",null,null,null,10,"personnes"]
[]
[]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité annuelle",null,"Prix unitaire","Montant total/an","Montant total/mois",null,"évolution annuelle charges d'exploitation",null,null,0.01]
[null,"Entretien charrue",{"$f":"30","v":30},null,{"$f":"20000","v":20000},{"$f":"E101*C101","v":600000},{"$f":"F101/12","v":50000},{"$nulls":4},0]
[null,"Révision moteur",{"$f":"12","v":12},null,{"$f":"150000","v":150000},{"$f":"E102*C102","v":1800000},{"$f":"F102/12","v":150000}]
[null,"Entretien système hydraulique",{"$f":"10","v":10},null,{"$f":"60000","v":60000},600000,50000]
[null,"Vente de pièces détachées ",{"$f":"12","v":12},null,{"$f":"400000","v":400000},4800000,400000]
[null,"Autres réparations",{"$f":"12","v":12},null,{"$f":"300000","v":300000},3600000,300000]
[null,"Soudure entretien charrue",{"$f":"C101","v":30},null,{"$f":"10000","v":10000},300000,25000]
[null,"Soudure révision moteur",{"$f":"C102","v":12},null,{"$f":"10000","v":10000},120000,10000]
[null,"Soudure entretien système hydraulique",{"$f":"C103","v":10},null,{"$f":"10000","v":10000},100000,8333.3333333333339]
[null,"Soudure  autres réparations",{"$f":"C105","v":12},null,{"$f":"10000","v":10000},120000,10000]
[null,"Ventes machines",null,null,null,{"$f":"E110*C110","v":0},0,null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"(MIN(M50,M52)*12)-SUM(G124:G127)","v":100629.99999999988}]
[{"$nulls":5},0,0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F101:F111)","v":12040000},{"$f":"SUM(G101:G111)","v":1003333.3333333334},null,null,null,"Sur 5 ans",{"$f":"(MIN(M50,M52)*12*5)-(SUM(G124:G127)*5)","v":503150}]
[{"$nulls":10},"Sur 9 ans",{"$f":"(MIN(M50,M52)*12*9)-(SUM(G124:G127)*9)","v":905669.99999999907}]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"Installation atelier",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C27,'investissement réel'!C4)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D27,'investissement réel'!D4)","v":1500000},20,{"$f":"C116*D116","v":1500000},{"$f":"IFERROR(F116/E116,0)","v":75000}]
[null,"Construction Bureau",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C28,'investissement réel'!C5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D28,'investissement réel'!D5)","v":500000},20,{"$f":"C117*D117","v":500000},25000]
[null,"Construction magasin de vente de pièces détaillées dans l'atelier ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C29,'investissement réel'!C6)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D29,'investissement réel'!D6)","v":1500000},20,{"$f":"C118*D118","v":1500000},{"$f":"IFERROR(F118/E118,0)","v":75000}]
[null,"Plat pour moteur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C30,'investissement réel'!C7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D30,'investissement réel'!D7)","v":160000},15,{"$f":"C119*D119","v":160000},{"$f":"IFERROR(F119/E119,0)","v":10666.666666666666}]
[null,"Etau",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C31,'investissement réel'!C8)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D31,'investissement réel'!D8)","v":40000},10,{"$f":"C120*D120","v":40000},{"$f":"IFERROR(F120/E120,0)","v":4000}]
[null,"Poste de soudure",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F81,'investissement réel'!C9)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F19,'investissement réel'!D9)","v":250000},10,250000,25000]
[null,"Meule",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F82,'investissement réel'!C10)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F20,'investissement réel'!D10)","v":40000},10,40000,4000]
[null,"Perceuse",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F83,'investissement réel'!C11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F21,'investissement réel'!D11)","v":100000},10,100000,10000]
[null,"Panneaux",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F84,'investissement réel'!C12)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F62,B:B,0)),'investissement réel'!D12)","v":1175844},20,1175844,58792.2]
[null,"Batteries",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F87,'investissement réel'!C13)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F63,H:H,0)),'investissement réel'!D13)","v":1735608},7,1735608,247944]
[null,"Onduleur",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F90,'investissement réel'!C14)","v":1},{"$f":"D41","v":2116221},10,2116221,211622.1]
[null,"Accessoires",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C32,'investissement réel'!C15)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D32,'investissement réel'!D15)","v":2618801},10,2618801,261880.1]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F116:F127)","v":11736474},{"$f":"SUM(G116:G127)","v":1008905.0666666667},{"$f":"G128/12","v":84075.422222222216}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION"]
[null,"Désignation","Quantité",null,"Prix unitaire","charges annuelles","charges mensuelles",null,null,null,0.01]
[null,"Salaire",1,null,2520000,{"$f":"C134*E134","v":2520000},{"$f":"F134/12","v":210000}]
[null,"Achat matiere premiere",12,null,250000,{"$f":"C135*E135","v":3000000},{"$f":"F135/12","v":250000}]
[null,"Maintenance",12,null,19116,{"$f":"C136*E136","v":229392},19116]
[null,"location magazin, restauration",12,null,230000,{"$f":"C137*E137","v":2760000},230000]
[null,"TOTAL (F CFA)",null,null,null,{"$f":"SUM(F134:F137)","v":8509392},{"$f":"SUM(G134:G137)","v":709116}]
[]
[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"]
{"$rows_empty":8}
[null,"Créances clients",{"$f":"((D147*F138/365*E147)+(D148*F138/365*E148))","v":0}]
[null,"Crédit fournisseurs",{"$f":"((D144*F112*E144/365)+(D145*F112*E145/365)+(D146*F112*E146/365))*-1","v":0}]
[null,"Impact Stocks consommable",{"$f":"F101*D149/365","v":0}]
[null,"Impact Stocks produits finis",{"$f":"F134*D150/365","v":0}]
[null,"BFR",{"$f":"SUM(C152:C155)","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é","mensualité"]
[null,"Investissements",null,{"$f":"F128","v":11736474},null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":1681507.10727533},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":829117.42114311433},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":85697090.661603794},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":2510624.5284184441},{"$f":"J161/12","v":209218.710701537}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C156","v":0},null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":1883287.9601483713},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":627336.56827007292},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":64230133.693692282},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":2510624.5284184436},{"$f":"J162/12","v":209218.71070153697}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D161:D162)","v":11736474},null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":2109282.5153661775},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":401342.01305226661},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":40187141.889631361},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":2510624.5284184441},209218.710701537]
[null,"Apport personnel",{"$f":"D164/D163","v":0.31525652423376904},{"$f":"SUM(F116:F120)","v":3700000},null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":2362396.4172101207},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":148228.1112083233},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":13258991.069083121},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":2510624.5284184441},209218.710701537]
[null,"Subvention",0,{"$f":"C165*D163","v":0},null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=5,5,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":0},0]
[null,"Emprunt",{"$f":"100%-(C165+C164)","v":0.68474347576623096},{"$f":"D163*C166","v":8036474},null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=6,6,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":0}]
[null,"Taux de l'emprunt",null,0.12,null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=7,7,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0}]
[null,"Remboursement de l'emprunt (années)",null,4,null,{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=8,8,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0}]
[{"$nulls":5},{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0}]
[{"$nulls":5},{"$f":"IF(D168>10,\"nb an insuffisant\",IF(D168>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0}]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G161:G170)","v":8036474},{"$f":"SUM(H161:H170)","v":2006024.1136737773},{"$f":"SUM(I161:I170)","v":203373357.31401056},{"$f":"SUM(J161:J170)","v":10042498.113673776},{"$f":"SUM(K161:K170)","v":836874.84280614788}]
[]
[]
[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":"D164+D166","v":11736474},{"$f":"F112","v":12040000},{"$f":"D178+($K$133*D178)","v":12160400},{"$f":"E178+($K$133*E178)","v":12282004},{"$f":"F178+($K$133*F178)","v":12404824.039999999},12528872.280399999,12654161.003203999,12780702.61323604,12908509.6393684,13037594.735762084,{"$f":"SUM(C178:L178)","v":124533542.31197053}]
[null,"Dépenses ",{"$f":"D161","v":11736474},{"$f":"F138","v":8509392},{"$f":"D179+(D179*$L$100)","v":8594485.9199999999},{"$f":"E179+(E179*$L$100)","v":8680430.7792000007},{"$f":"F179+(F179*$L$100)","v":8767235.0869920012},8854907.4378619213,8943456.5122405402,9032891.0773629453,9123219.9881365746,9214452.1880179401,{"$f":"SUM(C179:L179)","v":91456944.989811912}]
[null,"Amortissements ",0,{"$f":"$G$128","v":1008905.0666666667},{"$f":"$G$128","v":1008905.0666666667},1008905.0666666667,1008905.0666666667,1008905.0666666667,1008905.0666666667,1008905.0666666667,1008905.0666666667,1008905.0666666667,9080145.5999999996]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$161:$J$170,MATCH(D177,$F$161:$F$170,0)),0)","v":2510624.5284184441},{"$f":"IFERROR(INDEX($J$161:$J$170,MATCH(E177,$F$161:$F$170,0)),0)","v":2510624.5284184436},2510624.5284184441,2510624.5284184441,0,0,0,0,0,10042498.113673776]
[null,"Bénéfice avant impôts ",0,{"$f":"D178-SUM(D179:D181)","v":11078.404914889485},{"$f":"E178-SUM(E179:E181)","v":46384.484914889559},82043.625714888796,118059.35792288743,2665059.775871411,2701799.4242967926,2738906.4692064282,2776384.5845651589,2814237.4810774773,13953953.608484823]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D182<0,0,0.3*D182)","v":3323.5214744668451},{"$f":"IF(E182<0,0,0.3*E182)","v":13915.345474466867},24613.087714466637,35417.807376866229,799517.93276142329,810539.82728903776,821671.94076192845,832915.37536954763,844271.24432324315,4186186.0825454472]
[null,"Bénéfice après impôts ",0,{"$f":"D182-D183","v":7754.88344042264},{"$f":"E182-E183","v":32469.139440422692},57430.538000422159,82641.550546021201,1865541.8431099877,1891259.5970077547,1917234.5284444997,1943469.2091956113,1969966.2367542342,9767767.525939377]
[null,"Trésorerie",{"$f":"C178-C179","v":0},{"$f":"C185+D184","v":7754.88344042264},40224.022880845332,{"$f":"E185+F184","v":97654.560881267491},180296.11142728868,2045837.9545372764,3937097.5515450314,5854332.0799895311,7797801.2891851421,9767767.525939377,29728765.979826182]
[null,"Cash Flows",0,{"$f":"D184+D181-($H$171/$D$168)","v":2016873.3834404226},2041587.6394404222,2066549.0380004218,2091760.050546021,1364035.8146915433,1389753.5685893104,1415728.5000260554,1441963.180777167,1468460.2083357899,15296711.383847155]
[null,"Cash Flows cumulés",{"$f":"-C179","v":-11736474},{"$f":"C187+D186","v":-9719600.6165595781},{"$f":"D187+E186","v":-7678012.9771191562},{"$f":"E187+F186","v":-5611463.9391187346},-3519703.8885727134,-2155668.0738811698,-765914.50529185939,649813.99473419599,2091777.175511363,3560237.3838471528,-34885009.446450502]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F192,IF(D177<=H192,D186,0),IF(E177<=H192,E186,0),IF(F177<=H192,F186,0),IF(G177<=H192,G186,0),IF(H177<=H192,H186,0),IF(I177<=H192,I186,0),IF(J177<=H192,J186,0),IF(K177<=H192,K186,0),IF(L177<=H192,L186,0))-D161","v":576701.9535446465},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D161+IF(H192>=D177,(D184+D181-H171/D168)*((1+F192)^-1),0)+IF(H192>=E177,(E184+E181-H171/D168)*((1+F192)^-2),0)+IF(H192>=F177,(F184+F181-H171/D168)*((1+F192)^-3),0)+IF(H192>=G177,(G184+G181-H171/D168)*((1+F192)^-4),0)+IF(H192>=H177,(H184+H181-H171/D168)*((1+F192)^-5),0)+IF(H192>=I177,(I184+I181-H171/D168)*((1+F192)^-6),0)+IF(H192>=J177,(J184+J181-H171/D168)*((1+F192)^-7),0)+IF(H192>=K177,(K184+K181-H171/D168)*((1+F192)^-8),0)+IF(H192>=L177,(L184+L181-H171/D168)*((1+F192)^-9),0)","v":576701.95354464534},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N193:W193)","v":6.1912527747830959E-2},{"$nulls":10},{"$f":"-D161","v":-11736474},{"$f":"IF(D177<=H192,D186,0)","v":2016873.3834404226},{"$f":"IF(E177<=H192,E186,0)","v":2041587.6394404222},{"$f":"IF(F177<=H192,F186,0)","v":2066549.0380004218},{"$f":"IF(G177<=H192,G186,0)","v":2091760.050546021},{"$f":"IF(H177<=H192,H186,0)","v":1364035.8146915433},{"$f":"IF(I177<=H192,I186,0)","v":1389753.5685893104},{"$f":"IF(J177<=H192,J186,0)","v":1415728.5000260554},{"$f":"IF(K177<=H192,K186,0)","v":1441963.180777167},{"$f":"IF(L177<=H192,L186,0)","v":1468460.2083357899}]
[null,"RSI",{"$f":"SUM(O193:W193)/D161","v":1.3033481251564272},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N194,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 303 CFA"},{"$nulls":9},{"$f":"(C194-1)*1000","v":303.34812515642716}]
[null,"DRCI",{"$f":"N195+(-P195/(O195-P195))","v":7},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C195,0)&\" ans et \"&ROUNDDOWN((C195-ROUNDDOWN(C195,0))*12,0)&\" mois\"","v":"Le délai de récupération est de 7 ans et 0 mois"},{"$nulls":9},{"$f":"IF(AND(L187<0,L177<=H192),L177,IF(AND(K187<0,K177<=H192),K177,IF(AND(J187<0,J177<=H192),J177,IF(AND(I187<0,I177<=H192),I177,IF(AND(H187<0,H177<=H192),H177,IF(AND(G187<0,G177<=H192),G177,IF(AND(F187<0,F177<=H192),F177,IF(AND(E187<0,E177<=H192),E177,IF(AND(D187<0,D177<=H192),D177,IF(AND(C187<0,C177<=H192),C177))))))))))","v":6},null,{"$f":"IF(AND(L187<0,L177<=H192),L187,IF(AND(K187<0,K177<=H192),K187,IF(AND(J187<0,J177<=H192),J187,IF(AND(I187<0,I177<=H192),I187,IF(AND(H187<0,H177<=H192),H187,IF(AND(G187<0,G177<=H192),G187,IF(AND(F187<0,F177<=H192),F187,IF(AND(E187<0,E177<=H192),E187,IF(AND(D187<0,D177<=H192),D187,IF(AND(C187<0,C177<=H192),C187))))))))))","v":-765914.50529185939}]
[null,"DSCR",{"$f":"(D178-D179)/(D181)","v":1.4062668312350513}]

{"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é'!D167","v":0.12}]
["Capital emprunté",{"$f":"'Table rentabilité'!D166","v":8036474}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité'!D168","v":4},{"$f":"B4*12","v":48}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":209218.710701537},"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":132962.27299137664},"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":76256.437710160346},"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":209218.71070153697},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":132962.27299137664},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":76256.437710160346},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":7903511.7270086231},{"$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":209218.710701537},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":134223.92446790333},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":74994.786233633669},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":7769287.8025407195},{"$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},209218.71070153703,135497.54749404639,73721.163207490623,7633790.2550466741,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,209218.71070153697,136783.25566536121,72435.455036175772,7497006.9993813122,1,4]
[5,209218.71070153697,138081.16365528796,71137.547046249019,7358925.8357260246,1,5]
[6,209218.710701537,139391.38722537927,69827.323476157733,7219534.4485006453,1,6]
[7,209218.71070153697,140714.04323562517,68504.667465911814,7078820.4052650202,1,7]
[8,209218.71070153703,142049.24965487601,67169.461046661017,6936771.1556101441,1,8]
[9,209218.71070153697,143397.12557136398,65821.585130173,6793374.0300387796,1,9]
[10,209218.71070153703,144757.79120332509,64460.919498211922,6648616.238835454,1,10]
[11,209218.71070153697,146131.36790972101,63087.342791815958,6502484.8709257338,1,11]
[12,209218.710701537,147517.97820106376,61700.732500473248,6354966.8927246695,1,12]
[13,209218.710701537,148917.74575034197,60300.964951195019,6206049.146974328,2,1]
[14,209218.71070153697,150330.79540405184,58887.915297485139,6055718.3515702765,2,2]
[15,209218.710701537,151757.25319333209,57461.45750820492,5903961.0983769437,2,3]
[16,209218.71070153703,153197.24634520471,56021.464356332304,5750763.8520317394,2,4]
[17,209218.710701537,154650.90329392266,54567.807407614346,5596112.9487378169,2,5]
[18,209218.71070153703,156118.35369242492,53100.357009112093,5439994.5950453915,2,6]
[19,209218.710701537,157599.72842390032,51618.982277636671,5282394.8666214924,2,7]
[20,209218.71070153697,159095.15961346123,50123.55108807575,5123299.7070080303,2,8]
[21,209218.71070153697,160604.78063992781,48613.930061609179,4962694.9263681024,2,9]
[22,209218.710701537,162128.72614772423,47089.984553812777,4800566.2002203781,2,10]
[23,209218.71070153703,163667.13205888771,45551.5786426493,4636899.0681614904,2,11]
[24,209218.71070153703,165220.13558519157,43998.575116345448,4471678.9325762987,2,12]
[25,209218.71070153697,166787.87524038315,42430.835461153831,4304891.057335916,3,1]
[26,209218.71070153697,168370.49085253821,40848.219848998771,4136520.5664833775,3,2]
[27,209218.71070153697,169968.12357653206,39250.587125004924,3966552.4429068444,3,3]
[28,209218.710701537,171580.91590662941,37637.794794907597,3794971.5270002158,3,4]
[29,209218.710701537,173209.01168919352,36009.699012343473,3621762.5153110223,3,5]
[30,209218.710701537,174852.55613551606,34366.154566020945,3446909.9591755057,3,6]
[31,209218.710701537,176511.69583476853,32707.014866768477,3270398.2633407367,3,7]
[32,209218.710701537,178186.57876707675,31032.131934460249,3092211.6845736597,3,8]
[33,209218.71070153703,179877.35431671934,29341.356384817689,2912334.3302569417,3,9]
[34,209218.71070153703,181584.17328545131,27634.537416085714,2730750.1569714909,3,10]
[35,209218.71070153703,183307.1879059544,25911.522795582612,2547442.9690655349,3,11]
[36,209218.710701537,185046.5518554147,24172.158846122311,2362396.4172101207,3,12]
[37,209218.710701537,186802.4202692293,22416.290432307698,2175593.9969408913,4,1]
[38,209218.710701537,188574.94975484296,20643.760946694023,1987019.0471860506,4,2]
[39,209218.71070153703,190364.29840571611,18854.412295820915,1796654.7487803334,4,3]
[40,209218.710701537,192170.6258154251,17048.084886111898,1604484.1229649074,4,4]
[41,209218.710701537,193994.09309189691,15224.617609640089,1410490.0298730098,4,5]
[42,209218.710701537,195834.86287177814,13383.847829758848,1214655.1670012334,4,6]
[43,209218.710701537,197693.09933494093,11525.611366596082,1016962.0676662903,4,7]
[44,209218.71070153697,199568.96821912611,9649.7424824108712,817393.09944716748,4,8]
[45,209218.710701537,201462.6368347258,7756.0738668111971,615930.46261243988,4,9]
[46,209218.710701537,203374.27407970562,5844.4366218313808,412556.18853273429,4,10]
[47,209218.71070153703,205304.05045466911,3914.6602468679152,207252.13807806466,4,11]
[48,209218.710701537,207252.13807806463,1966.5726234723695,0,4,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-",{"$f":"IF(A79<>\"-\",C79+D79,\"\")","v":""},{"$f":"IF(A79<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":""},{"$f":"IF(A79<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":""},{"$f":"IF(A79<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A79,0),\"\")","v":""},"",""]
[{"$f":"IF(AND($B$4<>0,A79<$C$4),A79+1,\"-\")","v":"-"},"","","","",{"$f":"IF(A80<>\"-\",IF(G79<G80,F79,F79+1),\"\")","v":""},{"$f":"IF(A80=\"-\",\"\",IF(G79<12,G79+1,1))","v":""}]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]

{"sheet":"investissement réel","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Désignation ","Quantité","Prix unitaire TTC","Montant Total TTC","Durée de vie (an)","Amortissement annuel"]
[null,"Installation atelier",1,1500000,{"$f":"C4*D4","v":1500000},20,{"$f":"E4/F4","v":75000}]
[null,"Construction Bureau",1,500000,500000,20,25000]
[null," Construction magasin de vente de pièces détaillées dans l'atelier ",1,1500000,1500000,20,75000]
[null,"Plat pour moteur",1,160000,160000,15,10666.666666666666]
[null,"Etau",1,40000,{"$f":"C8*D8","v":40000},10,{"$f":"E8/F8","v":4000}]
[null,"Poste de soudure",1,250000,250000,10,25000]
[null,"Meule",1,40000,40000,10,4000]
[null,"Perceuse",1,{"$f":"100000","v":100000},{"$f":"C11*D11","v":100000},10,{"$f":"E11/F11","v":10000}]
[null,"Panneaux",1,{"$f":"97987*12","v":1175844},{"$f":"C12*D12","v":1175844},{"$f":"20","v":20},58792.2]
[null,"Batteries",1,{"$f":"433902*4","v":1735608},{"$f":"C13*D13","v":1735608},7,247944]
[null,"Onduleur",1,{"$f":"2116221","v":2116221},2116221,10,211622.1]
[null,"Accessoires",1,{"$f":"7646474-(D12+D13+D14)","v":2618801},2618801,10,261880.1]
[{"$nulls":4},{"$f":"C16*D16","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"C21*D21","v":0}]
[{"$nulls":4},0]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E4:E22)","v":11736474},null,{"$f":"SUM(G4:G22)","v":1008905.0666666667}]