{"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":195,"n_cols":23,"rows_kept":195,"cut":false,"hidden":false,"merged":[[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[100,2,100,3],[71,5,71,6],[80,5,80,6],[23,4,24,4],[101,2,101,3],[16,2,17,2],[16,3,16,4],[16,5,17,5],[69,5,69,6],[16,7,17,7],[67,5,67,6],[63,5,63,6],[23,11,24,11],[23,8,24,8],[16,6,17,6],[23,9,23,10],[16,10,17,10],[16,8,16,9],[53,1,54,1],[53,7,54,7],[55,1,56,1],[55,7,56,7],[23,3,24,3],[23,2,24,2],[23,5,24,5],[23,7,24,7],[23,6,24,6],[135,2,135,3],[109,2,109,3],[136,2,136,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[133,2,133,3],[134,2,134,3],[132,2,132,3]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Pompe solaire_Bananeraie"]
[]
[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,"Pompe de surface (983,2Kg/m3)",380,null,55,5824300,{"$f":"E19*I19","v":330},{"$f":"G19/K19","v":412.5},6,365,0.8]
[]
[]
[]
[]
[null,null,"Vitesse rotation","Taille buse","Graine ou poudre","Energie (kWh)","Quantité (Kg)","Temps pressage (Min)","Densité","Teneur",null,"Rendement huile (L/kg)"]
[{"$nulls":9},"Huile","Tourteaux"]
[]
[]
[]
[]
[null,"Equipements facultatifs"]
[null,"designation","nombre","prix"]
[null,"cloture grillage",1,2493750]
[null,"Genie civil (structures modules)",1,3187500]
[null,"conditionneur d'energie + protection ",1,3252999]
[null,"accessoirs cablages + protection",1,3128125]
[null,"ligne d'aspiration (PeHD)",1,178000]
[null,"ligne de refoulement (PeHD)",1,750000]
[null,"accessoirs pompe",1,2231250]
[]
[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,"Sharp ND-AC275",0.27500000000000002,90000,0.6,"24V",null,"Victron Energy Gel",220,400000,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(J43<0.5,12,IF(AND(J43>=0.5,J43<2),24,IF(J43>=2,48)))","v":48},{"$f":"F85*INDEX(C:C,MATCH(F65,B:B,0))","v":70.675000000000011}]
[]
[null,"Conditionneur","kVa","Prix (FCFA)",null,null,null,"Régulateur",null,"Prix (FCFA)","Tension (V)"]
[null,null,2,450000,null,null,null,"BlueSolar 150V 35A de Victron Energy",null,220000,"12V/24V/48V"]
[null,"Xtender",{"$nulls":5},"…"]
[]
[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é'!G75=\"x\",MAX(C51:N51),IF('Table rentabilité'!G76=\"x\",MIN(C51:N51),IF('Table rentabilité'!G77=\"x\",AVERAGE(C51:N51),\"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":"(F80*30)-SUM(K54:L54)","v":50},{"$f":"IF((F80*30)>D54,(F80*30)-D54-L54,0)","v":450},{"$f":"IF((F80*30)>E54,(F80*30)-E54,0)","v":9400},{"$f":"SUM(J54:L54)","v":9900}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J54*D55","v":6442.5},{"$f":"K54*E55","v":61056},{"$f":"L54*F55","v":1388192},{"$f":"SUM(J55:L55)","v":1455690.5}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F80*30)-SUM(K56:L56)","v":100},{"$f":"IF((F80*30)>D56,(F80*30)-D56-L56,0)","v":400},{"$f":"IF((F80*30)>E56,(F80*30)-E56,0)","v":9400},9900]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J56*D57","v":12981},{"$f":"K56*E57","v":54612},1402856,1470449]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"Production min. souhaitée (m3 d'eau/jour)",null,null,null,{"$f":"INDEX(C:C,MATCH($F$64,B:B,0))*INDEX(I:I,MATCH($F$64,B:B,0))","v":2280},"m3"]
[null,"Temps de fonctionnement (heures)",null,null,null,{"$f":"I19","v":6}]
[]
[null,"Choix de la pompes",null,null,null,"Pompe de surface (983,2Kg/m3)"]
[null,"Choix de l'alimentation solaire",null,null,null,"Sharp ND-AC275"]
[null,"Choix du système de stokage",null,null,null,"Victron Energy Gel"]
[null,"Choix du conditionneur (onduleur)",null,null,null,"Vitron Energy Phoenix"]
[null,"Choix décortiqueuse solaire"]
[{"$nulls":5},"Oui"]
[{"$nulls":5},{"$f":"IF(M55<M57,B54,B56)","v":"UP-Petite Puissance"}]
[]
[null,"Autonomie nécessaires au projet (jours)",null,null,null,1]
[null,"Profondeur décharge batteries",null,null,null,0.7]
[]
[null,"Choix du cas pour dimensionnement solaire",null,null,null,"best case"]
[{"$nulls":5},"worst case"]
[{"$nulls":5},"average","x"]
[]
[null,"puissance equipement total majoré",null,null,null,{"$f":"E19*1.2","v":66}]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"G19+G20+G21+G22","v":330},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F64,B:B,0))/O51)","v":70.607365988645753}]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(G19+G20+G21)*1000*(F72)/(F73*I43)","v":9821.4285714285725}]
[]
[null,"Nb de pompes",null,null,null,{"$f":"ROUNDUP(F61/(C19*I19),0)","v":1},"unités"]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F81/INDEX(C:C,MATCH(F65,B:B,0)),0)","v":257},"unités","=ARRONDI.SUP(F77/INDEX(C:C;EQUIV(F61;B:B;0));0)"]
[null,"Nb de batteries en série",null,null,null,{"$f":"ROUNDUP(I43/INDEX(K:K,MATCH(F66,H:H,0)),0)","v":4},"unités","=ARRONDI.SUP(I37/INDEX(K:K;EQUIV(F62;H:H;0));0)"]
[null,"Nb de batteries en dérivation",null,null,null,2,"unités","=ARRONDI.SUP(F78/INDEX(I:I;EQUIV(F62;H:H;0));0)"]
[null,"Nb de batteries total",null,null,null,{"$f":"F86*F87","v":8},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,{"$f":"INDEX(L:L,MATCH(F66,H:H,0))*(130%-F73)","v":6.0000000000000009},"ans"]
[null,"Nb conditionneur",null,null,null,{"$f":"IF(OR(I43=24,I43=12),1,2)","v":2},"unités","=SI(OU(I37=24;I37=12);1;2)"]
[null,"Nb régulateurs",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,1,"personnes"]
[null,"Extrant annuel attendu en eau",null,null,null,{"$f":"INDEX(C:C,MATCH($F$64,B:B,0))*INDEX(J:J,MATCH($F$64,B:B,0))*F84*F93","v":124830},"m3"]
[null,"Extrant annuel attendu en bananes",null,null,null,{"$f":"315","v":315},"Tonnes"]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION"]
[null,"Désignation","Quantité sacs de kg",null,"Prix unitaire","Montant total/an","Montant total/mois",null,"évolution annuelle charges d'exploitation",null,null,0.01]
[null,"engrais",{"$f":"71*4","v":284},null,9500,{"$f":"E102*C102*L102","v":1753700},{"$f":"F102/12","v":146141.66666666666},null,"Part charges imputables au business de l'huile (Baobab)*",null,null,0.65]
[null,"salaires",1,null,600600,{"$f":"E103*C103","v":600600},{"$f":"F103/12","v":50050},null,"* La création de Bouye sera gérée par RaS, les charges sont donc réparties "]
[null,"materiels vegetales",null,null,null,{"$f":"E104*C104","v":0},{"$f":"F104/12","v":0},null,"entre les 2 projets selon le poids de chaque transformation dans le revenu généré"]
[null,"Entretien système d'irrigation",null,null,null,{"$f":"E105*C105","v":0},0]
[null,"fumier",71,null,65000,{"$f":"E106*C106","v":4615000},384583.33333333331]
[{"$nulls":5},{"$f":"E107*C107*12","v":0},0]
[{"$nulls":5},{"$f":"E108*C108*12","v":0},0,null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"(MIN(M55,M57)*12)-G128","v":14893499.396666666}]
[{"$nulls":5},{"$f":"E109*C109*12","v":0},0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F102:F109)","v":6969300},{"$f":"SUM(G102:G109)","v":580775},null,null,null,"Sur 5 ans",{"$f":"(MIN(M55,M57)*12*5)-(G128*5)","v":74467496.983333334}]
[{"$nulls":10},"Sur 9 ans",{"$f":"(MIN(M55,M57)*12*9)-(G128*9)","v":134041494.56999999}]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"Pompe solaire (55 KW)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F84,'investissement réel'!C4)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(F:F,MATCH(F64,B:B,0)),'investissement réel'!D4)","v":5824300},10,{"$f":"C114*D114","v":5824300},{"$f":"IFERROR(F114/E114,0)","v":582430}]
[null,"accessoirs pompe",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C38,'investissement réel'!C5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D38,'investissement réel'!D5)","v":2231250},10,2231250,223125]
[null,"Champs solaire (81,9 KWc)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F85,'investissement réel'!C6)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F65,B:B,0)),'investissement réel'!D6)","v":17541678},25,{"$f":"C116*D116","v":17541678},{"$f":"IFERROR(F116/E116,0)","v":701667.12}]
[null,"cloture grillage",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C32,'investissement réel'!C7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D32,'investissement réel'!D7)","v":2493750},10,{"$f":"C117*D117","v":2493750},{"$f":"IFERROR(F117/E117,0)","v":249375}]
[null,"Genie civil (structures modules)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C33,'investissement réel'!C8)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D33,'investissement réel'!D8)","v":3187500},15,3187500,212500]
[null,"conditionneur d'energie + protection ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F90,'investissement réel'!C9)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D34,'investissement réel'!D9)","v":3252999},10,3252999,325299.90000000002]
[null,"accessoirs cablages + protection",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C35,'investissement réel'!C10)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D35,'investissement réel'!D10)","v":3340625},15,3340625,222708.33333333334]
[null,"ligne d'aspiration (PeHD)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C36,'investissement réel'!C11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D36,'investissement réel'!D11)","v":193625},20,193625,9681.25]
[null,"ligne de refoulement (PeHD)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C37,'investissement réel'!C12)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D37,'investissement réel'!D12)","v":960000},20,960000,48000]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F114:F127)","v":39025727},{"$f":"SUM(G114:G127)","v":2574786.6033333335}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité ",null,"Prix unitaire","Recettes annuelles","Recettes mensuelles",null,null,null,0.01]
[null,"cotisation producteur",71,null,300300,{"$f":"C134*E134","v":21321300},{"$f":"F134/12","v":1776775}]
[{"$nulls":5},{"$f":"C135*E135","v":0},{"$f":"F135/12","v":0}]
[{"$nulls":5},{"$f":"C136*E136","v":0},0]
[null,"TOTAL (F CFA)",null,null,null,{"$f":"SUM(F134:F136)","v":21321300},{"$f":"SUM(G134:G136)","v":1776775}]
[]
[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":"((D146*F137/365*E146)+(D147*F137/365*E147))","v":0}]
[null,"Crédit fournisseurs",{"$f":"((D143*F110*E143/365)+(D144*F110*E144/365)+(D145*F110*E145/365))*-1","v":0}]
[null,"Impact Stocks consommable",{"$f":"F102*D148/365","v":0}]
[null,"Impact Stocks produits finis",{"$f":"F134*D149/365","v":0}]
[null,"BFR",{"$f":"SUM(C151:C154)","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":39025727},null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F160)","v":8789690.993780775},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F160)","v":2377884.4674831782},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F160)","v":411766255.93676084},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F160)","v":11167575.461263953},{"$f":"J160/12","v":930631.28843866277}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C155","v":0},null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":9404969.3633454293},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":1762606.0979185246},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":302331991.24696481},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F161)","v":11167575.461263955},{"$f":"J161/12","v":930631.28843866289}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D160:D161)","v":39025727},null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":10063317.218779609},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":1104258.2424843449},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":185237328.02888298},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F162)","v":11167575.461263953},930631.28843866277]
[null,"Apport personnel",0,{"$f":"D162*C163","v":0},null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":10767749.42409418},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":399826.03716977272},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":59946038.385535516},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":11167575.461263953},930631.28843866277]
[null,"Subvention",0,{"$f":"C164*D162","v":0},null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=5,5,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":0},0]
[null,"Emprunt",{"$f":"100%-(C164+C163)","v":1},{"$f":"D162*C165","v":39025727},null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=6,6,\"-\"))","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},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":0}]
[null,"Taux de l'emprunt",null,7.0000000000000007E-2,null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=7,7,\"-\"))","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,"Remboursement de l'emprunt (années)",null,4,null,{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=8,8,\"-\"))","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}]
[{"$nulls":5},{"$f":"IF(D167>10,\"nb an insuffisant\",IF(D167>=9,9,\"-\"))","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(D167>10,\"nb an insuffisant\",IF(D167>=10,\"Année 10\",\"-\"))","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},"TOTAL",{"$f":"SUM(G160:G169)","v":39025726.999999993},{"$f":"SUM(H160:H169)","v":5644574.8450558214},{"$f":"SUM(I160:I169)","v":959281613.59814405},{"$f":"SUM(J160:J169)","v":44670301.845055819},{"$f":"SUM(K160:K169)","v":3722525.1537546515}]
[]
[]
[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":"F137","v":21321300},{"$f":"D177+($K$133*D177)","v":21534513},{"$f":"E177+($K$133*E177)","v":21749858.129999999},{"$f":"F177+($K$133*F177)","v":21967356.711300001},22187030.278413001,22408900.581197131,22632989.587009102,22859319.482879192,23087912.677707985,{"$f":"SUM(C177:L177)","v":199749180.44850641}]
[null,"Dépenses ",null,{"$f":"F110","v":6969300},{"$f":"D178+(D178*$L$101)","v":7038993},{"$f":"E178+(E178*$L$101)","v":7109382.9299999997},{"$f":"F178+(F178*$L$101)","v":7180476.7593},7252281.5268930001,7324804.3421619302,7398052.3855835497,7472032.9094393849,7546753.238533779,{"$f":"SUM(C178:L178)","v":65292077.091911644}]
[null,"Amortissements ",0,{"$f":"$G$128","v":2574786.6033333335},{"$f":"$G$128","v":2574786.6033333335},2574786.6033333335,2574786.6033333335,2574786.6033333335,2574786.6033333335,2574786.6033333335,2574786.6033333335,2574786.6033333335,23173079.43]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$160:$J$169,MATCH(D176,$F$160:$F$169,0)),0)","v":11167575.461263953},{"$f":"IFERROR(INDEX($J$160:$J$169,MATCH(E176,$F$160:$F$169,0)),0)","v":11167575.461263955},11167575.461263953,11167575.461263953,0,0,0,0,0,44670301.845055819]
[null,"Bénéfice avant impôts ",0,{"$f":"D177-SUM(D178:D180)","v":609637.93540271372},{"$f":"E177-SUM(E178:E180)","v":753157.93540271372},898113.13540271297,1044517.8874027133,12359962.148186669,12509309.635701869,12660150.598092219,12812499.970106473,12966372.835840873,66613722.08153896]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D181<0,0,0.3*D181)","v":182891.3806208141},{"$f":"IF(E181<0,0,0.3*E181)","v":225947.3806208141},269433.94062081387,313355.366220814,3707988.6444560005,3752792.8907105606,3798045.1794276657,3843749.991031942,3889911.8507522619,19984116.624461684]
[null,"Bénéfice après impôts ",0,{"$f":"D181-D182","v":426746.55478189961},{"$f":"E181-E182","v":527210.55478189955},628679.1947818991,731162.52118189936,8651973.5037306678,8756516.7449913081,8862105.4186645523,8968749.9790745303,9076460.985088611,46629605.457077265]
[null,"Trésorerie",{"$f":"C177-C178","v":0},{"$f":"C184+D183","v":426746.55478189961},953957.10956379911,{"$f":"E184+F183","v":1582636.3043456981},2313798.8255275972,10965772.329258265,19722289.074249573,28584394.492914125,37553144.471988656,46629605.457077265,148732344.61970687]
[null,"Cash Flows",0,{"$f":"D183+D180-($H$170/$D$167)","v":10183178.304781897},10283642.304781899,10385110.944781898,10487594.271181898,7240829.7924667122,7345373.0337273525,7450961.7074005967,7557606.2678105747,7665317.2738246555,78599613.900757492]
[null,"Cash Flows cumulés",{"$f":"-C178","v":0},{"$f":"C186+D185","v":10183178.304781897},{"$f":"D186+E185","v":20466820.609563798},{"$f":"E186+F185","v":30851931.554345697},41339525.825527593,48580355.617994308,55925728.651721664,63376690.359122261,70934296.62693283,78599613.900757492,420258141.45074755]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F191,IF(D176<=H191,D185,0),IF(E176<=H191,E185,0),IF(F176<=H191,F185,0),IF(G176<=H191,G185,0),IF(H176<=H191,H185,0),IF(I176<=H191,I185,0),IF(J176<=H191,J185,0),IF(K176<=H191,K185,0),IF(L176<=H191,L185,0))-D160","v":24105610.53229408},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D160+IF(H191>=D176,(D183+D180-H170/D167)*((1+F191)^-1),0)+IF(H191>=E176,(E183+E180-H170/D167)*((1+F191)^-2),0)+IF(H191>=F176,(F183+F180-H170/D167)*((1+F191)^-3),0)+IF(H191>=G176,(G183+G180-H170/D167)*((1+F191)^-4),0)+IF(H191>=H176,(H183+H180-H170/D167)*((1+F191)^-5),0)+IF(H191>=I176,(I183+I180-H170/D167)*((1+F191)^-6),0)+IF(H191>=J176,(J183+J180-H170/D167)*((1+F191)^-7),0)+IF(H191>=K176,(K183+K180-H170/D167)*((1+F191)^-8),0)+IF(H191>=L176,(L183+L180-H170/D167)*((1+F191)^-9),0)","v":24105610.532294095},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N192:W192)","v":0.18567792862451138},{"$nulls":10},{"$f":"-D160","v":-39025727},{"$f":"IF(D176<=H191,D185,0)","v":10183178.304781897},{"$f":"IF(E176<=H191,E185,0)","v":10283642.304781899},{"$f":"IF(F176<=H191,F185,0)","v":10385110.944781898},{"$f":"IF(G176<=H191,G185,0)","v":10487594.271181898},{"$f":"IF(H176<=H191,H185,0)","v":7240829.7924667122},{"$f":"IF(I176<=H191,I185,0)","v":7345373.0337273525},{"$f":"IF(J176<=H191,J185,0)","v":7450961.7074005967},{"$f":"IF(K176<=H191,K185,0)","v":7557606.2678105747},{"$f":"IF(L176<=H191,L185,0)","v":7665317.2738246555}]
[null,"RSI",{"$f":"SUM(O192:W192)/D160","v":2.0140461163159751},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N193,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 1014 CFA"},{"$nulls":9},{"$f":"(C193-1)*1000","v":1014.046116315975}]
[null,"DRCI",{"$f":"N194+(-P194/(O194-P194))","v":{"$error":"#N/A"}},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C194,0)&\" ans et \"&ROUNDDOWN((C194-ROUNDDOWN(C194,0))*12,0)&\" mois\"","v":{"$error":"#N/A"}},{"$nulls":9},{"$f":"IF(AND(L186<0,L176<=H191),L176,IF(AND(K186<0,K176<=H191),K176,IF(AND(J186<0,J176<=H191),J176,IF(AND(I186<0,I176<=H191),I176,IF(AND(H186<0,H176<=H191),H176,IF(AND(G186<0,G176<=H191),G176,IF(AND(F186<0,F176<=H191),F176,IF(AND(E186<0,E176<=H191),E176,IF(AND(D186<0,D176<=H191),D176,IF(AND(C186<0,C176<=H191),C176))))))))))","v":false},{"$f":"INDEX(C186:L186,MATCH(INDEX(C176:L176,MATCH(P194,C186:L186,0))+1,C176:L176,0))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L186<0,L176<=H191),L186,IF(AND(K186<0,K176<=H191),K186,IF(AND(J186<0,J176<=H191),J186,IF(AND(I186<0,I176<=H191),I186,IF(AND(H186<0,H176<=H191),H186,IF(AND(G186<0,G176<=H191),G186,IF(AND(F186<0,F176<=H191),F186,IF(AND(E186<0,E176<=H191),E186,IF(AND(D186<0,D176<=H191),D186,IF(AND(C186<0,C176<=H191),C186))))))))))","v":false}]
[null,"DSCR",{"$f":"(D177-D178)/(D180)","v":1.285149140006405}]

{"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é'!D166","v":7.0000000000000007E-2}]
["Capital emprunté",{"$f":"'Table rentabilité'!D165","v":39025727}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité'!D167","v":4},{"$f":"B4*12","v":48}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":930631.28843866277},"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":709974.15413147525},"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":220657.13430718746},"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":930631.28843866265},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":709974.15413147525},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":220657.13430718746},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":38315752.845868528},{"$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":930631.28843866277},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":713988.45122023474},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":216642.837218428},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":37601764.394648291},{"$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},930631.28843866265,718025.44572836231,212605.84271030041,36883738.94891993,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,930631.28843866277,722085.26599036693,208546.02244829581,36161653.682929561,1,4]
[5,930631.28843866265,726168.04106637964,204463.24737228308,35435485.641863182,1,5]
[6,930631.28843866265,730273.90074625623,200357.38769240648,34705211.741116926,1,6]
[7,930631.28843866265,734402.97555370315,196228.31288495957,33970808.76556322,1,7]
[8,930631.28843866277,738555.39675042685,192075.89168823589,33232253.368812792,1,8]
[9,930631.28843866265,742731.29634030641,187899.99209835619,32489522.072472487,1,9]
[10,930631.28843866265,746930.80707359058,183700.48136507213,31742591.265398897,1,10]
[11,930631.28843866265,751154.06245111662,179477.22598754609,30991437.20294778,1,11]
[12,930631.28843866265,755401.19672855537,175230.09171010734,30236036.006219223,1,12]
[13,930631.28843866289,759672.34492067865,170958.94351798421,29476363.661298547,2,1]
[14,930631.28843866277,763967.64280565118,166663.64563301156,28712396.0184929,2,2]
[15,930631.28843866265,768287.2269293475,162344.06150931513,27944108.791563548,2,3]
[16,930631.28843866277,772631.23460969259,158000.05382897015,27171477.556953855,2,4]
[17,930631.28843866277,776999.80394102621,153631.48449763653,26394477.753012829,2,5]
[18,930631.28843866265,781393.07379849406,149238.21464016859,25613084.679214336,2,6]
[19,930631.28843866277,785811.18384246237,144820.10459620037,24827273.495371871,2,7]
[20,930631.28843866265,790254.27452295658,140377.01391570608,24037019.220848911,2,8]
[21,930631.28843866265,794722.48708412785,135908.80135453478,23242296.73376479,2,9]
[22,930631.28843866289,799215.96356874204,131415.32486992082,22443080.770196043,2,10]
[23,930631.28843866265,803734.84682269476,126896.44161596795,21639345.923373349,2,11]
[24,930631.28843866277,808279.28049955424,122352.00793910852,20831066.642873794,2,12]
[25,930631.28843866265,812849.40906512598,117781.87937353672,20018217.23380867,3,1]
[26,930631.28843866277,817445.37780204671,113185.91063661603,19200771.856006622,3,2]
[27,930631.28843866265,822067.33281440183,108563.95562426082,18378704.523192219,3,3]
[28,930631.28843866289,826715.42103237112,103915.86740629171,17551989.10215985,3,4]
[29,930631.28843866277,831389.79021689808,99241.498221764734,16720599.311942946,3,5]
[30,930631.28843866289,836090.58896438882,94540.699474274021,15884508.722978562,3,6]
[31,930631.28843866265,840817.96671143465,89813.321727228045,15043690.75626713,3,7]
[32,930631.28843866265,845572.07373956358,85059.214699099117,14198118.682527561,3,8]
[33,930631.28843866265,850353.06118001684,80278.227258645842,13347765.621347547,3,9]
[34,930631.28843866265,855161.08101855381,75470.207420108884,12492604.540328991,3,10]
[35,930631.28843866254,859996.28610028327,70635.002338379316,11632608.254228711,3,11]
[36,930631.28843866277,864858.83013452298,65772.458304139756,10767749.424094182,3,12]
[37,930631.28843866265,869748.86769968469,60882.420738977919,9898000.5563945025,4,1]
[38,930631.28843866277,874666.55424819002,55964.73419047278,9023334.0021463111,4,2]
[39,930631.28843866277,879612.04611141002,51019.242327252701,8143721.9560348988,4,3]
[40,930631.28843866265,884585.5005046369,46045.787934025764,7259136.4555302672,4,4]
[41,930631.28843866277,889587.07553208084,41044.212906581895,6369549.3799981847,4,5]
[42,930631.28843866277,894616.93019189592,36014.358246766817,5474932.4498062879,4,6]
[43,930631.28843866265,899675.22438123496,30956.064057427648,4575257.2254250571,4,7]
[44,930631.28843866265,904762.11890133296,25869.169537329679,3670495.1065237224,4,8]
[45,930631.28843866265,909877.77546261798,20753.512976044683,2760617.331061095,4,9]
[46,930631.28843866265,915022.35668985255,15608.931748810153,1845594.9743712544,4,10]
[47,930631.28843866265,920196.02612730314,10435.26231135952,925398.94824393839,4,11]
[48,930631.28843866277,925398.94824393955,5232.3401947231641,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,"Pompe solaire (55 KW)",1,5824300,{"$f":"C4*D4","v":5824300},10,{"$f":"E4/F4","v":582430}]
[null,"accessoirs pompe",1,2231250,2231250,10,223125]
[null,"Champs solaire (81,9 KWc)",1,17541678,17541678,25,701667.12]
[null,"cloture grillage",1,2493750,2493750,10,249375]
[null,"Genie civil (structures modules)",1,3187500,3187500,15,212500]
[null,"conditionneur d'energie + protection ",1,3252999,3252999,10,325299.90000000002]
[null,"accessoirs cablages + protection",1,3340625,{"$f":"C10*D10","v":3340625},15,{"$f":"E10/F10","v":222708.33333333334}]
[null,"ligne d'aspiration (PeHD)",1,193625,{"$f":"C11*D11","v":193625},20,{"$f":"E11/F11","v":9681.25}]
[null,"ligne de refoulement (PeHD)",1,960000,960000,20,48000]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$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":39025727},null,{"$f":"SUM(G4:G22)","v":2574786.6033333335}]