{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Entrées","Calculs","Résultats et scénarios","Graphiques","Rapport imprimable"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":1,"defined_names":15,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Introduction","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Outil de comparaison des coûts de systèmes de pompage"]
["et d'irrigation solaire, au diesel, et raccordé au réseau STEG"]
["Version \"draft\", juillet 2020"]
[]
[null,"A quoi sert l’outil?  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pourquoi l'utiliser? "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Comment l'utiliser?"]

{"sheet":"Entrées","index":1,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[12,5,12,6],[13,5,13,6],[13,9,13,11]]}
[]
[null,"Veuillez indiquer vos hypothèses et entrées pour les analyses"]
[]
[{"$f":"CHAR(128)","v":"€"},"Cliquer sur les flèches pour voir les choix possible."]
[]
[null,"Système de pompage et d'irrigation à énergie solaire (SPIS)"]
[]
[null,"Taille de l'installation",10,"kWc"]
[]
[null,"Coût du SPIS, hors taxes",50000,"DT"]
[null,"Coût du SPIS, TTC",55000,"DT"]
[]
[null,"Choix de la subvention","FTI",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[null,null,1000,"DT",null,"Domaines de l’agriculture dont le coût ne dépasse pas 200 000 DT?",null,"Non",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"},"Société mutuelle de services agricoles ou groupements de développement?",null,null,"Non",{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[null,"Subvention appliquée",{"$f":"IF(C13=\"FTE\",\nMIN(50000,IF(C8<0.25,6000*C8,IF(C8<0.5,4500*C8,IF(C8<2,3500*C8,IF(C8<5,3000*C8,IF(C8<10,1500*C8,1000*C8)))))),\nIF(C13=\"FTI\",\n    MIN(500000, IF(AND(H14=\"Non\",M14=\"Non\"),0.5,IF(M14=\"Oui\",0.6,0.55))*C10),\nC14\n))","v":25000},"DT"]
[null,null,{"$f":"C15/C11","v":0.45454545454545453},"du coût d'installation, TTC"]
[]
[null,"Coûts fixes d'exploitation",0.01,"du coût d'investissement par an"]
[null,"Durée de vie du SPIS",25,"années"]
[null,"Montant de la dette",20000,"DT"]
[null,null,{"$f":"C20/C11","v":0.36363636363636365},"du coût TTC du SPIS"]
[null,"Taux d'interêt pour la dette",0.1]
[null,"Durée du crédit",10,"années"]
[]
[null,"Système de pompage et d'irrigation au diesel (SPID)"]
[]
[null,"Coût du SPID, TTC",50000,"DT"]
[]
[null,"Consommation diesel",1750,"litres/an"]
[null,"Prix diesel actuel",1.49,"DT/litre"]
[null,"augmentation du prix diesel",0.05,"par an"]
[]
[null,"Coûts fixes d'exploitation",0.01,"du coût d'investissement par an"]
[null,"Durée de vie du SPID",25,"années"]
[null,"Montant de la dette",30000,"DT"]
[null,null,{"$f":"C35/C27","v":0.6},"du coût du SPID, TTC"]
[null,"taux d'interêt pour la dette",0.1]
[null,"Durée du crédit",10,"années"]
[]
[null,"Système de pompage et d'irrigation raccordé au réseau STEG (SPIRR)"]
[]
[null,"Coût du SPIRR, TTC",40000,"DT"]
[]
[null,"Coût de raccordement au réseau STEG",50000,"DT"]
[]
[null,"Consommation d'électricité annuelle",50000,"kWh/an"]
[null,"Tarif moyen d'électricité actuel",0.14000000000000001,"DT/kWh"]
[null,"Augmentation du prix d'électricité",0.08,"par an"]
[]
[null,"Coûts fixes d'exploitation",0.01,"du coût d'investissement par an"]
[null,"Durée de vie du SPIRR",25,"années"]
[null,"Montant de la dette",25000,"DT"]
[null,null,{"$f":"C52/C42","v":0.625},"du coût du SPIRR, TTC"]
[null,"taux d'interêt pour la dette",0.1]
[null,"Durée du crédit",10,"années"]
[]
[null,"Hypothèses globales"]
[]
[null,"Taux d'actualisation",0.1]
[null,"Taux d'inflation",7.0000000000000007E-2]

{"sheet":"Calculs","index":2,"n_rows":74,"n_cols":54,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[null,"année",null,null,"2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01","2041-01-01","2042-01-01","2043-01-01","2044-01-01","2045-01-01","2046-01-01","2047-01-01","2048-01-01","2049-01-01","2050-01-01","2051-01-01","2052-01-01","2053-01-01","2054-01-01","2055-01-01","2056-01-01","2057-01-01","2058-01-01","2059-01-01","2060-01-01","2061-01-01","2062-01-01","2063-01-01","2064-01-01","2065-01-01","2066-01-01","2067-01-01","2068-01-01","2069-01-01"]
[null,"#",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[null,"Facteur - inflation",null,null,1,{"$f":"IF(F3<=Entrées!$C$19,E4*(1+Entrées!$C$60),0)","v":1.07},{"$f":"IF(G3<=Entrées!$C$19,F4*(1+Entrées!$C$60),0)","v":1.1449},{"$f":"IF(H3<=Entrées!$C$19,G4*(1+Entrées!$C$60),0)","v":1.2250430000000001},{"$f":"IF(I3<=Entrées!$C$19,H4*(1+Entrées!$C$60),0)","v":1.3107960100000002},{"$f":"IF(J3<=Entrées!$C$19,I4*(1+Entrées!$C$60),0)","v":1.4025517307000004},{"$f":"IF(K3<=Entrées!$C$19,J4*(1+Entrées!$C$60),0)","v":1.5007303518490005},{"$f":"IF(L3<=Entrées!$C$19,K4*(1+Entrées!$C$60),0)","v":1.6057814764784306},{"$f":"IF(M3<=Entrées!$C$19,L4*(1+Entrées!$C$60),0)","v":1.7181861798319209},{"$f":"IF(N3<=Entrées!$C$19,M4*(1+Entrées!$C$60),0)","v":1.8384592124201555},{"$f":"IF(O3<=Entrées!$C$19,N4*(1+Entrées!$C$60),0)","v":1.9671513572895665},{"$f":"IF(P3<=Entrées!$C$19,O4*(1+Entrées!$C$60),0)","v":2.1048519522998363},{"$f":"IF(Q3<=Entrées!$C$19,P4*(1+Entrées!$C$60),0)","v":2.2521915889608248},{"$f":"IF(R3<=Entrées!$C$19,Q4*(1+Entrées!$C$60),0)","v":2.4098450001880827},{"$f":"IF(S3<=Entrées!$C$19,R4*(1+Entrées!$C$60),0)","v":2.5785341502012487},{"$f":"IF(T3<=Entrées!$C$19,S4*(1+Entrées!$C$60),0)","v":2.7590315407153363},{"$f":"IF(U3<=Entrées!$C$19,T4*(1+Entrées!$C$60),0)","v":2.9521637485654102},{"$f":"IF(V3<=Entrées!$C$19,U4*(1+Entrées!$C$60),0)","v":3.1588152109649892},{"$f":"IF(W3<=Entrées!$C$19,V4*(1+Entrées!$C$60),0)","v":3.3799322757325387},{"$f":"IF(X3<=Entrées!$C$19,W4*(1+Entrées!$C$60),0)","v":3.6165275350338169},{"$f":"IF(Y3<=Entrées!$C$19,X4*(1+Entrées!$C$60),0)","v":3.8696844624861844},{"$f":"IF(Z3<=Entrées!$C$19,Y4*(1+Entrées!$C$60),0)","v":4.1405623748602176},{"$f":"IF(AA3<=Entrées!$C$19,Z4*(1+Entrées!$C$60),0)","v":4.4304017411004333},{"$f":"IF(AB3<=Entrées!$C$19,AA4*(1+Entrées!$C$60),0)","v":4.7405298629774641},{"$f":"IF(AC3<=Entrées!$C$19,AB4*(1+Entrées!$C$60),0)","v":5.0723669533858873},{"$f":"IF(AD3<=Entrées!$C$19,AC4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AE3<=Entrées!$C$19,AD4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AF3<=Entrées!$C$19,AE4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AG3<=Entrées!$C$19,AF4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AH3<=Entrées!$C$19,AG4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AI3<=Entrées!$C$19,AH4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$19,AI4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AK3<=Entrées!$C$19,AJ4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AL3<=Entrées!$C$19,AK4*(1+Entrées!$C$60),0)","v":0},{"$f":"IF(AM3<=Entrées!$C$19,AL4*(1+Entrées!$C$60),0)","v":0}]
[]
["Flux de trésorerie du système de pompage et d'irrigation à énergie solaire (SPIS)"]
[]
[null,"Coût fixes d'exploitation"]
[null,"Valeur réele","DT",null,{"$f":"Entrées!C18*Entrées!C10","v":500},{"$f":"IF(F3<=Entrées!$C$19,E9,0)","v":500},{"$f":"IF(G3<=Entrées!$C$19,F9,0)","v":500},{"$f":"IF(H3<=Entrées!$C$19,G9,0)","v":500},{"$f":"IF(I3<=Entrées!$C$19,H9,0)","v":500},{"$f":"IF(J3<=Entrées!$C$19,I9,0)","v":500},{"$f":"IF(K3<=Entrées!$C$19,J9,0)","v":500},{"$f":"IF(L3<=Entrées!$C$19,K9,0)","v":500},{"$f":"IF(M3<=Entrées!$C$19,L9,0)","v":500},{"$f":"IF(N3<=Entrées!$C$19,M9,0)","v":500},{"$f":"IF(O3<=Entrées!$C$19,N9,0)","v":500},{"$f":"IF(P3<=Entrées!$C$19,O9,0)","v":500},{"$f":"IF(Q3<=Entrées!$C$19,P9,0)","v":500},{"$f":"IF(R3<=Entrées!$C$19,Q9,0)","v":500},{"$f":"IF(S3<=Entrées!$C$19,R9,0)","v":500},{"$f":"IF(T3<=Entrées!$C$19,S9,0)","v":500},{"$f":"IF(U3<=Entrées!$C$19,T9,0)","v":500},{"$f":"IF(V3<=Entrées!$C$19,U9,0)","v":500},{"$f":"IF(W3<=Entrées!$C$19,V9,0)","v":500},{"$f":"IF(X3<=Entrées!$C$19,W9,0)","v":500},{"$f":"IF(Y3<=Entrées!$C$19,X9,0)","v":500},{"$f":"IF(Z3<=Entrées!$C$19,Y9,0)","v":500},{"$f":"IF(AA3<=Entrées!$C$19,Z9,0)","v":500},{"$f":"IF(AB3<=Entrées!$C$19,AA9,0)","v":500},{"$f":"IF(AC3<=Entrées!$C$19,AB9,0)","v":500},{"$f":"IF(AD3<=Entrées!$C$19,AC9,0)","v":0},{"$f":"IF(AE3<=Entrées!$C$19,AD9,0)","v":0},{"$f":"IF(AF3<=Entrées!$C$19,AE9,0)","v":0},{"$f":"IF(AG3<=Entrées!$C$19,AF9,0)","v":0},{"$f":"IF(AH3<=Entrées!$C$19,AG9,0)","v":0},{"$f":"IF(AI3<=Entrées!$C$19,AH9,0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$19,AI9,0)","v":0},{"$f":"IF(AK3<=Entrées!$C$19,AJ9,0)","v":0},{"$f":"IF(AL3<=Entrées!$C$19,AK9,0)","v":0},{"$f":"IF(AM3<=Entrées!$C$19,AL9,0)","v":0},{"$f":"IF(AN3<=Entrées!$C$19,AM9,0)","v":0},{"$f":"IF(AO3<=Entrées!$C$19,AN9,0)","v":0},{"$f":"IF(AP3<=Entrées!$C$19,AO9,0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$19,AP9,0)","v":0},{"$f":"IF(AR3<=Entrées!$C$19,AQ9,0)","v":0},{"$f":"IF(AS3<=Entrées!$C$19,AR9,0)","v":0},{"$f":"IF(AT3<=Entrées!$C$19,AS9,0)","v":0},{"$f":"IF(AU3<=Entrées!$C$19,AT9,0)","v":0},{"$f":"IF(AV3<=Entrées!$C$19,AU9,0)","v":0},{"$f":"IF(AW3<=Entrées!$C$19,AV9,0)","v":0},{"$f":"IF(AX3<=Entrées!$C$19,AW9,0)","v":0},{"$f":"IF(AY3<=Entrées!$C$19,AX9,0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$19,AY9,0)","v":0},{"$f":"IF(BA3<=Entrées!$C$19,AZ9,0)","v":0},{"$f":"IF(BB3<=Entrées!$C$19,BA9,0)","v":0}]
[null,"Valeur nominale","DT",null,{"$f":"E9*E4","v":500},535,572.45000000000005,612.52150000000006,655.39800500000013,701.27586535000023,750.36517592450025,802.89073823921535,859.09308991596049,919.2296062100778,983.57567864478324,1052.4259761499181,1126.0957944804125,1204.9225000940414,1289.2670751006244,1379.5157703576681,1476.081874282705,1579.4076054824945,1689.9661378662693,1808.2637675169085,1934.8422312430921,2070.2811874301087,2215.2008705502167,2370.2649314887321,2536.1834766929437,0,0,0,0,0,0,0,{"$f":"AK9*AK4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Service de la dette"]
[null,"Solde de trésorerie reporté","DT",null,{"$f":"Entrées!C20","v":20000},{"$f":"E13-E16","v":18745.092102349769},{"$f":"F13-(F14-F15)","v":17364.693414934514},15846.254858777735,14175.972447005277,12338.661794055573,10317.620075810899,8094.4741857417566,5649.0137066656998,2959.0071796820353,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AM13-(AM14-AM15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Service de la dette (annuités)","DT",null,{"$f":"IFERROR(E13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!E3+1)),0)","v":3254.9078976502306},{"$f":"IFERROR(F13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!F3+1)),0)","v":3254.9078976502315},{"$f":"IFERROR(G13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!G3+1)),0)","v":3254.907897650231},{"$f":"IFERROR(H13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!H3+1)),0)","v":3254.907897650231},{"$f":"IFERROR(I13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!I3+1)),0)","v":3254.9078976502319},{"$f":"IFERROR(J13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!J3+1)),0)","v":3254.9078976502319},{"$f":"IFERROR(K13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!K3+1)),0)","v":3254.9078976502324},{"$f":"IFERROR(L13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!L3+1)),0)","v":3254.9078976502324},{"$f":"IFERROR(M13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!M3+1)),0)","v":3254.9078976502346},{"$f":"IFERROR(N13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!N3+1)),0)","v":3254.9078976502378},{"$f":"IFERROR(O13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!O3+1)),0)","v":0},{"$f":"IFERROR(P13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!P3+1)),0)","v":0},{"$f":"IFERROR(Q13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!Q3+1)),0)","v":0},{"$f":"IFERROR(R13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!R3+1)),0)","v":0},{"$f":"IFERROR(S13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!S3+1)),0)","v":0},{"$f":"IFERROR(T13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!T3+1)),0)","v":0},{"$f":"IFERROR(U13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!U3+1)),0)","v":0},{"$f":"IFERROR(V13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!V3+1)),0)","v":0},{"$f":"IFERROR(W13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!W3+1)),0)","v":0},{"$f":"IFERROR(X13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!X3+1)),0)","v":0},{"$f":"IFERROR(Y13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!Y3+1)),0)","v":0},{"$f":"IFERROR(Z13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!Z3+1)),0)","v":0},{"$f":"IFERROR(AA13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AA3+1)),0)","v":0},{"$f":"IFERROR(AB13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AB3+1)),0)","v":0},{"$f":"IFERROR(AC13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AC3+1)),0)","v":0},{"$f":"IFERROR(AD13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AD3+1)),0)","v":0},{"$f":"IFERROR(AE13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AE3+1)),0)","v":0},{"$f":"IFERROR(AF13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AF3+1)),0)","v":0},{"$f":"IFERROR(AG13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AG3+1)),0)","v":0},{"$f":"IFERROR(AH13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AH3+1)),0)","v":0},{"$f":"IFERROR(AI13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AI3+1)),0)","v":0},{"$f":"IFERROR(AJ13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AJ3+1)),0)","v":0},{"$f":"IFERROR(AK13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AK3+1)),0)","v":0},{"$f":"IFERROR(AL13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AL3+1)),0)","v":0},{"$f":"IFERROR(AM13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AM3+1)),0)","v":0},{"$f":"IFERROR(AN13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AN3+1)),0)","v":0},{"$f":"IFERROR(AO13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AO3+1)),0)","v":0},{"$f":"IFERROR(AP13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AP3+1)),0)","v":0},{"$f":"IFERROR(AQ13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AQ3+1)),0)","v":0},{"$f":"IFERROR(AR13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AR3+1)),0)","v":0},{"$f":"IFERROR(AS13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AS3+1)),0)","v":0},{"$f":"IFERROR(AT13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AT3+1)),0)","v":0},{"$f":"IFERROR(AU13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AU3+1)),0)","v":0},{"$f":"IFERROR(AV13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AV3+1)),0)","v":0},{"$f":"IFERROR(AW13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AW3+1)),0)","v":0},{"$f":"IFERROR(AX13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AX3+1)),0)","v":0},{"$f":"IFERROR(AY13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AY3+1)),0)","v":0},{"$f":"IFERROR(AZ13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!AZ3+1)),0)","v":0},{"$f":"IFERROR(BA13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!BA3+1)),0)","v":0},{"$f":"IFERROR(BB13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!BB3+1)),0)","v":0}]
[null,"Interet","DT",null,{"$f":"Entrées!$C$22*E13","v":2000},{"$f":"Entrées!$C$22*F13","v":1874.509210234977},{"$f":"Entrées!$C$22*G13","v":1736.4693414934516},{"$f":"Entrées!$C$22*H13","v":1584.6254858777736},{"$f":"Entrées!$C$22*I13","v":1417.5972447005279},{"$f":"Entrées!$C$22*J13","v":1233.8661794055574},{"$f":"Entrées!$C$22*K13","v":1031.7620075810898},{"$f":"Entrées!$C$22*L13","v":809.44741857417569},{"$f":"Entrées!$C$22*M13","v":564.90137066656996},{"$f":"Entrées!$C$22*N13","v":295.90071796820354},{"$f":"Entrées!$C$22*O13","v":0},{"$f":"Entrées!$C$22*P13","v":0},{"$f":"Entrées!$C$22*Q13","v":0},{"$f":"Entrées!$C$22*R13","v":0},{"$f":"Entrées!$C$22*S13","v":0},{"$f":"Entrées!$C$22*T13","v":0},{"$f":"Entrées!$C$22*U13","v":0},{"$f":"Entrées!$C$22*V13","v":0},{"$f":"Entrées!$C$22*W13","v":0},{"$f":"Entrées!$C$22*X13","v":0},{"$f":"Entrées!$C$22*Y13","v":0},{"$f":"Entrées!$C$22*Z13","v":0},{"$f":"Entrées!$C$22*AA13","v":0},{"$f":"Entrées!$C$22*AB13","v":0},{"$f":"Entrées!$C$22*AC13","v":0},{"$f":"Entrées!$C$22*AD13","v":0},{"$f":"Entrées!$C$22*AE13","v":0},{"$f":"Entrées!$C$22*AF13","v":0},{"$f":"Entrées!$C$22*AG13","v":0},{"$f":"Entrées!$C$22*AH13","v":0},{"$f":"Entrées!$C$22*AI13","v":0},{"$f":"Entrées!$C$22*AJ13","v":0},{"$f":"Entrées!$C$22*AK13","v":0},{"$f":"Entrées!$C$22*AL13","v":0},{"$f":"Entrées!$C$22*AM13","v":0},{"$f":"Entrées!$C$22*AN13","v":0},{"$f":"Entrées!$C$22*AO13","v":0},{"$f":"Entrées!$C$22*AP13","v":0},{"$f":"Entrées!$C$22*AQ13","v":0},{"$f":"Entrées!$C$22*AR13","v":0},{"$f":"Entrées!$C$22*AS13","v":0},{"$f":"Entrées!$C$22*AT13","v":0},{"$f":"Entrées!$C$22*AU13","v":0},{"$f":"Entrées!$C$22*AV13","v":0},{"$f":"Entrées!$C$22*AW13","v":0},{"$f":"Entrées!$C$22*AX13","v":0},{"$f":"Entrées!$C$22*AY13","v":0},{"$f":"Entrées!$C$22*AZ13","v":0},{"$f":"Entrées!$C$22*BA13","v":0},{"$f":"Entrées!$C$22*BB13","v":0}]
[null,"Montant du principal","DT",null,{"$f":"(E14-E15)","v":1254.9078976502306},{"$f":"(F14-F15)","v":1380.3986874152545},1518.4385561567794,1670.2824117724574,1837.310652949704,2021.0417182446745,2223.1458900691423,2445.4604790760568,2690.0065269836646,2959.0071796820343,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(AN14-AN15)","v":0},{"$f":"(AO14-AO15)","v":0},{"$f":"(AP14-AP15)","v":0},{"$f":"(AQ14-AQ15)","v":0},{"$f":"(AR14-AR15)","v":0},{"$f":"(AS14-AS15)","v":0},{"$f":"(AT14-AT15)","v":0},{"$f":"(AU14-AU15)","v":0},{"$f":"(AV14-AV15)","v":0},{"$f":"(AW14-AW15)","v":0},{"$f":"(AX14-AX15)","v":0},{"$f":"(AY14-AY15)","v":0},{"$f":"(AZ14-AZ15)","v":0},{"$f":"(BA14-BA15)","v":0},{"$f":"(BB14-BB15)","v":0}]
[]
[null,"Capitaux propres initials","DT",{"$f":"Entrées!C11-Entrées!C15-Calculs!E13","v":10000}]
[]
[null,"Flux de trésorerie net","DT",null,{"$f":"-(E14+E10)-D18","v":-13754.907897650231},{"$f":"-(F14+F10)","v":-3789.9078976502315},-3827.3578976502313,-3867.4293976502313,-3910.3059026502319,-3956.1837630002319,-4005.2730735747327,-4057.7986358894477,-4114.0009875661954,-4174.1375038603155,-983.57567864478324,-1052.4259761499181,-1126.0957944804125,-1204.9225000940414,-1289.2670751006244,-1379.5157703576681,-1476.081874282705,-1579.4076054824945,-1689.9661378662693,-1808.2637675169085,-1934.8422312430921,-2070.2811874301087,-2215.2008705502167,-2370.2649314887321,-2536.1834766929437,0,0,0,0,0,0,0,0,{"$f":"-(AL14+AL10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coût totale actualisé","DT",{"$f":"-XNPV(Entrées!C59,Calculs!E20:BB20,Calculs!$E$2:$BB$2)","v":41134.978653302082}]
[null,"Coût totale actualisé par année de la vie du projet","DT",{"$f":"D22/Entrées!C19","v":1645.3991461320832}]
[]
["Flux de trésorerie du système de pompage et d'irrigation au diesel (SPID)"]
[]
[null,"Coût d'exploitation"]
[null,"Coût fixes d'exploitation (valeur réele)","DT",null,{"$f":"Entrées!C33*Entrées!C27","v":500},{"$f":"IF(F3<=Entrées!$C$34,E28,0)","v":500},{"$f":"IF(G3<=Entrées!$C$34,F28,0)","v":500},{"$f":"IF(H3<=Entrées!$C$34,G28,0)","v":500},{"$f":"IF(I3<=Entrées!$C$34,H28,0)","v":500},{"$f":"IF(J3<=Entrées!$C$34,I28,0)","v":500},{"$f":"IF(K3<=Entrées!$C$34,J28,0)","v":500},{"$f":"IF(L3<=Entrées!$C$34,K28,0)","v":500},{"$f":"IF(M3<=Entrées!$C$34,L28,0)","v":500},{"$f":"IF(N3<=Entrées!$C$34,M28,0)","v":500},{"$f":"IF(O3<=Entrées!$C$34,N28,0)","v":500},{"$f":"IF(P3<=Entrées!$C$34,O28,0)","v":500},{"$f":"IF(Q3<=Entrées!$C$34,P28,0)","v":500},{"$f":"IF(R3<=Entrées!$C$34,Q28,0)","v":500},{"$f":"IF(S3<=Entrées!$C$34,R28,0)","v":500},{"$f":"IF(T3<=Entrées!$C$34,S28,0)","v":500},{"$f":"IF(U3<=Entrées!$C$34,T28,0)","v":500},{"$f":"IF(V3<=Entrées!$C$34,U28,0)","v":500},{"$f":"IF(W3<=Entrées!$C$34,V28,0)","v":500},{"$f":"IF(X3<=Entrées!$C$34,W28,0)","v":500},{"$f":"IF(Y3<=Entrées!$C$34,X28,0)","v":500},{"$f":"IF(Z3<=Entrées!$C$34,Y28,0)","v":500},{"$f":"IF(AA3<=Entrées!$C$34,Z28,0)","v":500},{"$f":"IF(AB3<=Entrées!$C$34,AA28,0)","v":500},{"$f":"IF(AC3<=Entrées!$C$34,AB28,0)","v":500},{"$f":"IF(AD3<=Entrées!$C$34,AC28,0)","v":0},{"$f":"IF(AE3<=Entrées!$C$34,AD28,0)","v":0},{"$f":"IF(AF3<=Entrées!$C$34,AE28,0)","v":0},{"$f":"IF(AG3<=Entrées!$C$34,AF28,0)","v":0},{"$f":"IF(AH3<=Entrées!$C$34,AG28,0)","v":0},{"$f":"IF(AI3<=Entrées!$C$34,AH28,0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$34,AI28,0)","v":0},{"$f":"IF(AK3<=Entrées!$C$34,AJ28,0)","v":0},{"$f":"IF(AL3<=Entrées!$C$34,AK28,0)","v":0},{"$f":"IF(AM3<=Entrées!$C$34,AL28,0)","v":0},{"$f":"IF(AN3<=Entrées!$C$34,AM28,0)","v":0},{"$f":"IF(AO3<=Entrées!$C$34,AN28,0)","v":0},{"$f":"IF(AP3<=Entrées!$C$34,AO28,0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$34,AP28,0)","v":0},{"$f":"IF(AR3<=Entrées!$C$34,AQ28,0)","v":0},{"$f":"IF(AS3<=Entrées!$C$34,AR28,0)","v":0},{"$f":"IF(AT3<=Entrées!$C$34,AS28,0)","v":0},{"$f":"IF(AU3<=Entrées!$C$34,AT28,0)","v":0},{"$f":"IF(AV3<=Entrées!$C$34,AU28,0)","v":0},{"$f":"IF(AW3<=Entrées!$C$34,AV28,0)","v":0},{"$f":"IF(AX3<=Entrées!$C$34,AW28,0)","v":0},{"$f":"IF(AY3<=Entrées!$C$34,AX28,0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$34,AY28,0)","v":0},{"$f":"IF(BA3<=Entrées!$C$34,AZ28,0)","v":0},{"$f":"IF(BB3<=Entrées!$C$34,BA28,0)","v":0}]
[null,"Coût fixes d'exploitation (valeur nominale)","DT",null,{"$f":"E28*E4","v":500},535,572.45000000000005,612.52150000000006,655.39800500000013,701.27586535000023,750.36517592450025,802.89073823921535,859.09308991596049,919.2296062100778,983.57567864478324,1052.4259761499181,1126.0957944804125,1204.9225000940414,1289.2670751006244,1379.5157703576681,1476.081874282705,1579.4076054824945,1689.9661378662693,1808.2637675169085,1934.8422312430921,2070.2811874301087,2215.2008705502167,2370.2649314887321,2536.1834766929437,0,0,0,0,0,0,0,{"$f":"AK28*AK4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Consommation diesel annuelle","litres",null,{"$f":"Entrées!$C$29","v":1750},{"$f":"IF(F3<=Entrées!$C$34,E30,0)","v":1750},{"$f":"IF(G3<=Entrées!$C$34,F30,0)","v":1750},{"$f":"IF(H3<=Entrées!$C$34,G30,0)","v":1750},{"$f":"IF(I3<=Entrées!$C$34,H30,0)","v":1750},{"$f":"IF(J3<=Entrées!$C$34,I30,0)","v":1750},{"$f":"IF(K3<=Entrées!$C$34,J30,0)","v":1750},{"$f":"IF(L3<=Entrées!$C$34,K30,0)","v":1750},{"$f":"IF(M3<=Entrées!$C$34,L30,0)","v":1750},{"$f":"IF(N3<=Entrées!$C$34,M30,0)","v":1750},{"$f":"IF(O3<=Entrées!$C$34,N30,0)","v":1750},{"$f":"IF(P3<=Entrées!$C$34,O30,0)","v":1750},{"$f":"IF(Q3<=Entrées!$C$34,P30,0)","v":1750},{"$f":"IF(R3<=Entrées!$C$34,Q30,0)","v":1750},{"$f":"IF(S3<=Entrées!$C$34,R30,0)","v":1750},{"$f":"IF(T3<=Entrées!$C$34,S30,0)","v":1750},{"$f":"IF(U3<=Entrées!$C$34,T30,0)","v":1750},{"$f":"IF(V3<=Entrées!$C$34,U30,0)","v":1750},{"$f":"IF(W3<=Entrées!$C$34,V30,0)","v":1750},{"$f":"IF(X3<=Entrées!$C$34,W30,0)","v":1750},{"$f":"IF(Y3<=Entrées!$C$34,X30,0)","v":1750},{"$f":"IF(Z3<=Entrées!$C$34,Y30,0)","v":1750},{"$f":"IF(AA3<=Entrées!$C$34,Z30,0)","v":1750},{"$f":"IF(AB3<=Entrées!$C$34,AA30,0)","v":1750},{"$f":"IF(AC3<=Entrées!$C$34,AB30,0)","v":1750},{"$f":"IF(AD3<=Entrées!$C$34,AC30,0)","v":0},{"$f":"IF(AE3<=Entrées!$C$34,AD30,0)","v":0},{"$f":"IF(AF3<=Entrées!$C$34,AE30,0)","v":0},{"$f":"IF(AG3<=Entrées!$C$34,AF30,0)","v":0},{"$f":"IF(AH3<=Entrées!$C$34,AG30,0)","v":0},{"$f":"IF(AI3<=Entrées!$C$34,AH30,0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$34,AI30,0)","v":0},{"$f":"IF(AK3<=Entrées!$C$34,AJ30,0)","v":0},{"$f":"IF(AL3<=Entrées!$C$34,AK30,0)","v":0},{"$f":"IF(AM3<=Entrées!$C$34,AL30,0)","v":0},{"$f":"IF(AN3<=Entrées!$C$34,AM30,0)","v":0},{"$f":"IF(AO3<=Entrées!$C$34,AN30,0)","v":0},{"$f":"IF(AP3<=Entrées!$C$34,AO30,0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$34,AP30,0)","v":0},{"$f":"IF(AR3<=Entrées!$C$34,AQ30,0)","v":0},{"$f":"IF(AS3<=Entrées!$C$34,AR30,0)","v":0},{"$f":"IF(AT3<=Entrées!$C$34,AS30,0)","v":0},{"$f":"IF(AU3<=Entrées!$C$34,AT30,0)","v":0},{"$f":"IF(AV3<=Entrées!$C$34,AU30,0)","v":0},{"$f":"IF(AW3<=Entrées!$C$34,AV30,0)","v":0},{"$f":"IF(AX3<=Entrées!$C$34,AW30,0)","v":0},{"$f":"IF(AY3<=Entrées!$C$34,AX30,0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$34,AY30,0)","v":0},{"$f":"IF(BA3<=Entrées!$C$34,AZ30,0)","v":0},{"$f":"IF(BB3<=Entrées!$C$34,BA30,0)","v":0}]
[null,"Prix diesel (nominale)","DT/litre",null,{"$f":"Entrées!C30","v":1.49},{"$f":"IF(F3<=Entrées!$C$34,E31*(1+Entrées!$C$31),0)","v":1.5645},{"$f":"IF(G3<=Entrées!$C$34,F31*(1+Entrées!$C$31),0)","v":1.642725},{"$f":"IF(H3<=Entrées!$C$34,G31*(1+Entrées!$C$31),0)","v":1.72486125},{"$f":"IF(I3<=Entrées!$C$34,H31*(1+Entrées!$C$31),0)","v":1.8111043125000001},{"$f":"IF(J3<=Entrées!$C$34,I31*(1+Entrées!$C$31),0)","v":1.9016595281250002},{"$f":"IF(K3<=Entrées!$C$34,J31*(1+Entrées!$C$31),0)","v":1.9967425045312504},{"$f":"IF(L3<=Entrées!$C$34,K31*(1+Entrées!$C$31),0)","v":2.0965796297578128},{"$f":"IF(M3<=Entrées!$C$34,L31*(1+Entrées!$C$31),0)","v":2.2014086112457036},{"$f":"IF(N3<=Entrées!$C$34,M31*(1+Entrées!$C$31),0)","v":2.3114790418079889},{"$f":"IF(O3<=Entrées!$C$34,N31*(1+Entrées!$C$31),0)","v":2.4270529938983882},{"$f":"IF(P3<=Entrées!$C$34,O31*(1+Entrées!$C$31),0)","v":2.5484056435933078},{"$f":"IF(Q3<=Entrées!$C$34,P31*(1+Entrées!$C$31),0)","v":2.6758259257729735},{"$f":"IF(R3<=Entrées!$C$34,Q31*(1+Entrées!$C$31),0)","v":2.8096172220616222},{"$f":"IF(S3<=Entrées!$C$34,R31*(1+Entrées!$C$31),0)","v":2.9500980831647037},{"$f":"IF(T3<=Entrées!$C$34,S31*(1+Entrées!$C$31),0)","v":3.0976029873229391},{"$f":"IF(U3<=Entrées!$C$34,T31*(1+Entrées!$C$31),0)","v":3.2524831366890861},{"$f":"IF(V3<=Entrées!$C$34,U31*(1+Entrées!$C$31),0)","v":3.4151072935235405},{"$f":"IF(W3<=Entrées!$C$34,V31*(1+Entrées!$C$31),0)","v":3.5858626581997175},{"$f":"IF(X3<=Entrées!$C$34,W31*(1+Entrées!$C$31),0)","v":3.7651557911097036},{"$f":"IF(Y3<=Entrées!$C$34,X31*(1+Entrées!$C$31),0)","v":3.9534135806651891},{"$f":"IF(Z3<=Entrées!$C$34,Y31*(1+Entrées!$C$31),0)","v":4.1510842596984485},{"$f":"IF(AA3<=Entrées!$C$34,Z31*(1+Entrées!$C$31),0)","v":4.3586384726833716},{"$f":"IF(AB3<=Entrées!$C$34,AA31*(1+Entrées!$C$31),0)","v":4.5765703963175399},{"$f":"IF(AC3<=Entrées!$C$34,AB31*(1+Entrées!$C$31),0)","v":4.8053989161334174},{"$f":"IF(AD3<=Entrées!$C$34,AC31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AE3<=Entrées!$C$34,AD31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AF3<=Entrées!$C$34,AE31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AG3<=Entrées!$C$34,AF31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AH3<=Entrées!$C$34,AG31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AI3<=Entrées!$C$34,AH31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$34,AI31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AK3<=Entrées!$C$34,AJ31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AL3<=Entrées!$C$34,AK31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AM3<=Entrées!$C$34,AL31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AN3<=Entrées!$C$34,AM31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AO3<=Entrées!$C$34,AN31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AP3<=Entrées!$C$34,AO31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$34,AP31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AR3<=Entrées!$C$34,AQ31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AS3<=Entrées!$C$34,AR31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AT3<=Entrées!$C$34,AS31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AU3<=Entrées!$C$34,AT31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AV3<=Entrées!$C$34,AU31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AW3<=Entrées!$C$34,AV31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AX3<=Entrées!$C$34,AW31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AY3<=Entrées!$C$34,AX31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$34,AY31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(BA3<=Entrées!$C$34,AZ31*(1+Entrées!$C$31),0)","v":0},{"$f":"IF(BB3<=Entrées!$C$34,BA31*(1+Entrées!$C$31),0)","v":0}]
[null,"Coût variables d'exploitation (valeur nominale)","DT",null,{"$f":"E30*E31","v":2607.5},{"$f":"F30*F31","v":2737.875},2874.7687500000002,3018.5071874999999,3169.4325468750003,3327.9041742187501,3494.2993829296879,3669.0143520761721,3852.4650696799813,4045.0883231639805,4247.3427393221791,4459.7098762882888,4682.6953701027032,4916.8301386078392,5162.6716455382311,5420.8052278151436,5691.8454892059008,5976.4377636661957,6275.2596518495056,6589.0226344419816,6918.4737661640811,7264.3974544722851,7627.6173271959005,8008.9981935556953,8409.4481032334807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coût d'exploitation total (nominale)","DT",null,{"$f":"E32+E29","v":3107.5},{"$f":"F32+F29","v":3272.875},3447.21875,3631.0286875000002,3824.8305518750003,4029.1800395687505,4244.6645588541878,4471.9050903153875,4711.558159595942,4964.3179293740586,5230.9184179669628,5512.1358524382067,5808.7911645831155,6121.7526387018806,6451.9387206388556,6800.3209981728114,7167.9273634886058,7555.8453691486902,7965.2257897157751,8397.2864019588906,8853.3159974071732,9334.6786419023938,9842.8181977461172,10379.263125044428,10945.631579926425,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Service de la dette"]
[null,"Solde de trésorerie reporté","DT",null,{"$f":"Entrées!C35","v":30000},{"$f":"E36-E39","v":28117.638153524655},{"$f":"F36-F39","v":26047.040122401773},23769.382288166606,21263.95867050792,18507.992691083364,15476.430113716353,12141.711278612638,8473.5205599985529,4438.5107695230536,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Service de la dette (annuités)","DT",null,{"$f":"IFERROR(E36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-E3+1)),0)","v":4882.3618464753454},{"$f":"IFERROR(F36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-F3+1)),0)","v":4882.3618464753472},{"$f":"IFERROR(G36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-G3+1)),0)","v":4882.3618464753472},{"$f":"IFERROR(H36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-H3+1)),0)","v":4882.3618464753472},{"$f":"IFERROR(I36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-I3+1)),0)","v":4882.361846475349},{"$f":"IFERROR(J36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-J3+1)),0)","v":4882.3618464753481},{"$f":"IFERROR(K36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-K3+1)),0)","v":4882.3618464753499},{"$f":"IFERROR(L36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-L3+1)),0)","v":4882.3618464753499},{"$f":"IFERROR(M36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-M3+1)),0)","v":4882.3618464753545},{"$f":"IFERROR(N36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-N3+1)),0)","v":4882.3618464753581},{"$f":"IFERROR(O36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-O3+1)),0)","v":0},{"$f":"IFERROR(P36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-P3+1)),0)","v":0},{"$f":"IFERROR(Q36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-Q3+1)),0)","v":0},{"$f":"IFERROR(R36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-R3+1)),0)","v":0},{"$f":"IFERROR(S36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-S3+1)),0)","v":0},{"$f":"IFERROR(T36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-T3+1)),0)","v":0},{"$f":"IFERROR(U36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-U3+1)),0)","v":0},{"$f":"IFERROR(V36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-V3+1)),0)","v":0},{"$f":"IFERROR(W36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-W3+1)),0)","v":0},{"$f":"IFERROR(X36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-X3+1)),0)","v":0},{"$f":"IFERROR(Y36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-Y3+1)),0)","v":0},{"$f":"IFERROR(Z36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-Z3+1)),0)","v":0},{"$f":"IFERROR(AA36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AA3+1)),0)","v":0},{"$f":"IFERROR(AB36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AB3+1)),0)","v":0},{"$f":"IFERROR(AC36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AC3+1)),0)","v":0},{"$f":"IFERROR(AD36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AD3+1)),0)","v":0},{"$f":"IFERROR(AE36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AE3+1)),0)","v":0},{"$f":"IFERROR(AF36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AF3+1)),0)","v":0},{"$f":"IFERROR(AG36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AG3+1)),0)","v":0},{"$f":"IFERROR(AH36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AH3+1)),0)","v":0},{"$f":"IFERROR(AI36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AI3+1)),0)","v":0},{"$f":"IFERROR(AJ36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AJ3+1)),0)","v":0},{"$f":"IFERROR(AK36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AK3+1)),0)","v":0},{"$f":"IFERROR(AL36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AL3+1)),0)","v":0},{"$f":"IFERROR(AM36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AM3+1)),0)","v":0},{"$f":"IFERROR(AN36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AN3+1)),0)","v":0},{"$f":"IFERROR(AO36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AO3+1)),0)","v":0},{"$f":"IFERROR(AP36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AP3+1)),0)","v":0},{"$f":"IFERROR(AQ36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AQ3+1)),0)","v":0},{"$f":"IFERROR(AR36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AR3+1)),0)","v":0},{"$f":"IFERROR(AS36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AS3+1)),0)","v":0},{"$f":"IFERROR(AT36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AT3+1)),0)","v":0},{"$f":"IFERROR(AU36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AU3+1)),0)","v":0},{"$f":"IFERROR(AV36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AV3+1)),0)","v":0},{"$f":"IFERROR(AW36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AW3+1)),0)","v":0},{"$f":"IFERROR(AX36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AX3+1)),0)","v":0},{"$f":"IFERROR(AY36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AY3+1)),0)","v":0},{"$f":"IFERROR(AZ36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-AZ3+1)),0)","v":0},{"$f":"IFERROR(BA36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-BA3+1)),0)","v":0},{"$f":"IFERROR(BB36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-BB3+1)),0)","v":0}]
[null,"Interet","DT",null,{"$f":"Entrées!$C$37*E36","v":3000},{"$f":"Entrées!$C$37*F36","v":2811.7638153524658},{"$f":"Entrées!$C$37*G36","v":2604.7040122401777},{"$f":"Entrées!$C$37*H36","v":2376.9382288166607},{"$f":"Entrées!$C$37*I36","v":2126.3958670507923},{"$f":"Entrées!$C$37*J36","v":1850.7992691083364},{"$f":"Entrées!$C$37*K36","v":1547.6430113716353},{"$f":"Entrées!$C$37*L36","v":1214.1711278612638},{"$f":"Entrées!$C$37*M36","v":847.35205599985534},{"$f":"Entrées!$C$37*N36","v":443.85107695230539},{"$f":"Entrées!$C$37*O36","v":0},{"$f":"Entrées!$C$37*P36","v":0},{"$f":"Entrées!$C$37*Q36","v":0},{"$f":"Entrées!$C$37*R36","v":0},{"$f":"Entrées!$C$37*S36","v":0},{"$f":"Entrées!$C$37*T36","v":0},{"$f":"Entrées!$C$37*U36","v":0},{"$f":"Entrées!$C$37*V36","v":0},{"$f":"Entrées!$C$37*W36","v":0},{"$f":"Entrées!$C$37*X36","v":0},{"$f":"Entrées!$C$37*Y36","v":0},{"$f":"Entrées!$C$37*Z36","v":0},{"$f":"Entrées!$C$37*AA36","v":0},{"$f":"Entrées!$C$37*AB36","v":0},{"$f":"Entrées!$C$37*AC36","v":0},{"$f":"Entrées!$C$37*AD36","v":0},{"$f":"Entrées!$C$37*AE36","v":0},{"$f":"Entrées!$C$37*AF36","v":0},{"$f":"Entrées!$C$37*AG36","v":0},{"$f":"Entrées!$C$37*AH36","v":0},{"$f":"Entrées!$C$37*AI36","v":0},{"$f":"Entrées!$C$37*AJ36","v":0},{"$f":"Entrées!$C$37*AK36","v":0},{"$f":"Entrées!$C$37*AL36","v":0},{"$f":"Entrées!$C$37*AM36","v":0},{"$f":"Entrées!$C$37*AN36","v":0},{"$f":"Entrées!$C$37*AO36","v":0},{"$f":"Entrées!$C$37*AP36","v":0},{"$f":"Entrées!$C$37*AQ36","v":0},{"$f":"Entrées!$C$37*AR36","v":0},{"$f":"Entrées!$C$37*AS36","v":0},{"$f":"Entrées!$C$37*AT36","v":0},{"$f":"Entrées!$C$37*AU36","v":0},{"$f":"Entrées!$C$37*AV36","v":0},{"$f":"Entrées!$C$37*AW36","v":0},{"$f":"Entrées!$C$37*AX36","v":0},{"$f":"Entrées!$C$37*AY36","v":0},{"$f":"Entrées!$C$37*AZ36","v":0},{"$f":"Entrées!$C$37*BA36","v":0},{"$f":"Entrées!$C$37*BB36","v":0}]
[null,"Montant du principal","DT",null,{"$f":"E37-E38","v":1882.3618464753454},{"$f":"F37-F38","v":2070.5980311228814},2277.6578342351695,2505.4236176586865,2755.9659794245567,3031.5625773670117,3334.7188351037148,3668.1907186140861,4035.0097904754994,4438.5107695230527,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capitaux propres initials","DT",{"$f":"Entrées!C27-Entrées!C35","v":20000}]
[]
[null,"Flux de trésorerie net","DT",null,{"$f":"-(E37+E33)-D41","v":-27989.861846475345},{"$f":"-(F37+F33)","v":-8155.2368464753472},{"$f":"-(G37+G33)","v":-8329.5805964753472},-8513.3905339753474,-8707.1923983503493,-8911.5418860440986,-9127.0264053295377,-9354.2669367907365,-9593.9200060712974,-9846.6797758494176,-5230.9184179669628,-5512.1358524382067,-5808.7911645831155,-6121.7526387018806,-6451.9387206388556,-6800.3209981728114,-7167.9273634886058,-7555.8453691486902,-7965.2257897157751,-8397.2864019588906,-8853.3159974071732,-9334.6786419023938,-9842.8181977461172,-10379.263125044428,-10945.631579926425,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coût totale actualisé","DT",{"$f":"-XNPV(Entrées!C59,Calculs!E43:BB43,Calculs!$E$2:$BB$2)","v":101538.45942498489}]
[null,"Coût totale actualisé par année de la vie du projet","DT",{"$f":"D45/Entrées!C34","v":4061.5383769993955}]
[]
["Flux de trésorerie du système de pompage et d'irrigation raccordé au réseau STEG (SPIRR)"]
[]
[null,"Coût d'exploitation"]
[null,"Coût fixes d'exploitation (valeur réele)","DT",null,{"$f":"Entrées!C50*Entrées!C42","v":400},{"$f":"IF(F3<=Entrées!$C$51,E51,0)","v":400},{"$f":"IF(G3<=Entrées!$C$51,F51,0)","v":400},{"$f":"IF(H3<=Entrées!$C$51,G51,0)","v":400},{"$f":"IF(I3<=Entrées!$C$51,H51,0)","v":400},{"$f":"IF(J3<=Entrées!$C$51,I51,0)","v":400},{"$f":"IF(K3<=Entrées!$C$51,J51,0)","v":400},{"$f":"IF(L3<=Entrées!$C$51,K51,0)","v":400},{"$f":"IF(M3<=Entrées!$C$51,L51,0)","v":400},{"$f":"IF(N3<=Entrées!$C$51,M51,0)","v":400},{"$f":"IF(O3<=Entrées!$C$51,N51,0)","v":400},{"$f":"IF(P3<=Entrées!$C$51,O51,0)","v":400},{"$f":"IF(Q3<=Entrées!$C$51,P51,0)","v":400},{"$f":"IF(R3<=Entrées!$C$51,Q51,0)","v":400},{"$f":"IF(S3<=Entrées!$C$51,R51,0)","v":400},{"$f":"IF(T3<=Entrées!$C$51,S51,0)","v":400},{"$f":"IF(U3<=Entrées!$C$51,T51,0)","v":400},{"$f":"IF(V3<=Entrées!$C$51,U51,0)","v":400},{"$f":"IF(W3<=Entrées!$C$51,V51,0)","v":400},{"$f":"IF(X3<=Entrées!$C$51,W51,0)","v":400},{"$f":"IF(Y3<=Entrées!$C$51,X51,0)","v":400},{"$f":"IF(Z3<=Entrées!$C$51,Y51,0)","v":400},{"$f":"IF(AA3<=Entrées!$C$51,Z51,0)","v":400},{"$f":"IF(AB3<=Entrées!$C$51,AA51,0)","v":400},{"$f":"IF(AC3<=Entrées!$C$51,AB51,0)","v":400},{"$f":"IF(AD3<=Entrées!$C$51,AC51,0)","v":0},{"$f":"IF(AE3<=Entrées!$C$51,AD51,0)","v":0},{"$f":"IF(AF3<=Entrées!$C$51,AE51,0)","v":0},{"$f":"IF(AG3<=Entrées!$C$51,AF51,0)","v":0},{"$f":"IF(AH3<=Entrées!$C$51,AG51,0)","v":0},{"$f":"IF(AI3<=Entrées!$C$51,AH51,0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$51,AI51,0)","v":0},{"$f":"IF(AK3<=Entrées!$C$51,AJ51,0)","v":0},{"$f":"IF(AL3<=Entrées!$C$51,AK51,0)","v":0},{"$f":"IF(AM3<=Entrées!$C$51,AL51,0)","v":0},{"$f":"IF(AN3<=Entrées!$C$51,AM51,0)","v":0},{"$f":"IF(AO3<=Entrées!$C$51,AN51,0)","v":0},{"$f":"IF(AP3<=Entrées!$C$51,AO51,0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$51,AP51,0)","v":0},{"$f":"IF(AR3<=Entrées!$C$51,AQ51,0)","v":0},{"$f":"IF(AS3<=Entrées!$C$51,AR51,0)","v":0},{"$f":"IF(AT3<=Entrées!$C$51,AS51,0)","v":0},{"$f":"IF(AU3<=Entrées!$C$51,AT51,0)","v":0},{"$f":"IF(AV3<=Entrées!$C$51,AU51,0)","v":0},{"$f":"IF(AW3<=Entrées!$C$51,AV51,0)","v":0},{"$f":"IF(AX3<=Entrées!$C$51,AW51,0)","v":0},{"$f":"IF(AY3<=Entrées!$C$51,AX51,0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$51,AY51,0)","v":0},{"$f":"IF(BA3<=Entrées!$C$51,AZ51,0)","v":0},{"$f":"IF(BB3<=Entrées!$C$51,BA51,0)","v":0}]
[null,"Coût fixes d'exploitation (valeur nominale)","DT",null,{"$f":"E51*E4","v":400},{"$f":"F51*F4","v":428},{"$f":"G51*G4","v":457.96000000000004},490.01720000000006,524.3184040000001,561.02069228000016,600.2921407396002,642.31259059137221,687.27447193276839,735.3836849680622,786.86054291582661,841.94078091993458,900.87663558432996,963.93800007523305,1031.4136600804995,1103.6126162861344,1180.865499426164,1263.5260843859958,1351.9729102930155,1446.6110140135268,1547.8737849944737,1656.224949944087,1772.1606964401733,1896.2119451909857,2028.9467813543549,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Consommation électricité annuelle","kWh",null,{"$f":"Entrées!C46","v":50000},{"$f":"IF(F3<=Entrées!$C$51,E53,0)","v":50000},{"$f":"IF(G3<=Entrées!$C$51,F53,0)","v":50000},{"$f":"IF(H3<=Entrées!$C$51,G53,0)","v":50000},{"$f":"IF(I3<=Entrées!$C$51,H53,0)","v":50000},{"$f":"IF(J3<=Entrées!$C$51,I53,0)","v":50000},{"$f":"IF(K3<=Entrées!$C$51,J53,0)","v":50000},{"$f":"IF(L3<=Entrées!$C$51,K53,0)","v":50000},{"$f":"IF(M3<=Entrées!$C$51,L53,0)","v":50000},{"$f":"IF(N3<=Entrées!$C$51,M53,0)","v":50000},{"$f":"IF(O3<=Entrées!$C$51,N53,0)","v":50000},{"$f":"IF(P3<=Entrées!$C$51,O53,0)","v":50000},{"$f":"IF(Q3<=Entrées!$C$51,P53,0)","v":50000},{"$f":"IF(R3<=Entrées!$C$51,Q53,0)","v":50000},{"$f":"IF(S3<=Entrées!$C$51,R53,0)","v":50000},{"$f":"IF(T3<=Entrées!$C$51,S53,0)","v":50000},{"$f":"IF(U3<=Entrées!$C$51,T53,0)","v":50000},{"$f":"IF(V3<=Entrées!$C$51,U53,0)","v":50000},{"$f":"IF(W3<=Entrées!$C$51,V53,0)","v":50000},{"$f":"IF(X3<=Entrées!$C$51,W53,0)","v":50000},{"$f":"IF(Y3<=Entrées!$C$51,X53,0)","v":50000},{"$f":"IF(Z3<=Entrées!$C$51,Y53,0)","v":50000},{"$f":"IF(AA3<=Entrées!$C$51,Z53,0)","v":50000},{"$f":"IF(AB3<=Entrées!$C$51,AA53,0)","v":50000},{"$f":"IF(AC3<=Entrées!$C$51,AB53,0)","v":50000},{"$f":"IF(AD3<=Entrées!$C$51,AC53,0)","v":0},{"$f":"IF(AE3<=Entrées!$C$51,AD53,0)","v":0},{"$f":"IF(AF3<=Entrées!$C$51,AE53,0)","v":0},{"$f":"IF(AG3<=Entrées!$C$51,AF53,0)","v":0},{"$f":"IF(AH3<=Entrées!$C$51,AG53,0)","v":0},{"$f":"IF(AI3<=Entrées!$C$51,AH53,0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$51,AI53,0)","v":0},{"$f":"IF(AK3<=Entrées!$C$51,AJ53,0)","v":0},{"$f":"IF(AL3<=Entrées!$C$51,AK53,0)","v":0},{"$f":"IF(AM3<=Entrées!$C$51,AL53,0)","v":0},{"$f":"IF(AN3<=Entrées!$C$51,AM53,0)","v":0},{"$f":"IF(AO3<=Entrées!$C$51,AN53,0)","v":0},{"$f":"IF(AP3<=Entrées!$C$51,AO53,0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$51,AP53,0)","v":0},{"$f":"IF(AR3<=Entrées!$C$51,AQ53,0)","v":0},{"$f":"IF(AS3<=Entrées!$C$51,AR53,0)","v":0},{"$f":"IF(AT3<=Entrées!$C$51,AS53,0)","v":0},{"$f":"IF(AU3<=Entrées!$C$51,AT53,0)","v":0},{"$f":"IF(AV3<=Entrées!$C$51,AU53,0)","v":0},{"$f":"IF(AW3<=Entrées!$C$51,AV53,0)","v":0},{"$f":"IF(AX3<=Entrées!$C$51,AW53,0)","v":0},{"$f":"IF(AY3<=Entrées!$C$51,AX53,0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$51,AY53,0)","v":0},{"$f":"IF(BA3<=Entrées!$C$51,AZ53,0)","v":0},{"$f":"IF(BB3<=Entrées!$C$51,BA53,0)","v":0}]
[null,"Prix moyen d'électricité (nominale)","DT/kWh",null,{"$f":"Entrées!C47","v":0.14000000000000001},{"$f":"IF(F3<=Entrées!$C$51,E54*(1+Entrées!$C$48),0)","v":0.15120000000000003},{"$f":"IF(G3<=Entrées!$C$51,F54*(1+Entrées!$C$48),0)","v":0.16329600000000005},{"$f":"IF(H3<=Entrées!$C$51,G54*(1+Entrées!$C$48),0)","v":0.17635968000000007},{"$f":"IF(I3<=Entrées!$C$51,H54*(1+Entrées!$C$48),0)","v":0.1904684544000001},{"$f":"IF(J3<=Entrées!$C$51,I54*(1+Entrées!$C$48),0)","v":0.20570593075200011},{"$f":"IF(K3<=Entrées!$C$51,J54*(1+Entrées!$C$48),0)","v":0.22216240521216013},{"$f":"IF(L3<=Entrées!$C$51,K54*(1+Entrées!$C$48),0)","v":0.23993539762913296},{"$f":"IF(M3<=Entrées!$C$51,L54*(1+Entrées!$C$48),0)","v":0.25913022943946362},{"$f":"IF(N3<=Entrées!$C$51,M54*(1+Entrées!$C$48),0)","v":0.27986064779462072},{"$f":"IF(O3<=Entrées!$C$51,N54*(1+Entrées!$C$48),0)","v":0.30224949961819042},{"$f":"IF(P3<=Entrées!$C$51,O54*(1+Entrées!$C$48),0)","v":0.32642945958764569},{"$f":"IF(Q3<=Entrées!$C$51,P54*(1+Entrées!$C$48),0)","v":0.35254381635465737},{"$f":"IF(R3<=Entrées!$C$51,Q54*(1+Entrées!$C$48),0)","v":0.38074732166302999},{"$f":"IF(S3<=Entrées!$C$51,R54*(1+Entrées!$C$48),0)","v":0.41120710739607241},{"$f":"IF(T3<=Entrées!$C$51,S54*(1+Entrées!$C$48),0)","v":0.44410367598775824},{"$f":"IF(U3<=Entrées!$C$51,T54*(1+Entrées!$C$48),0)","v":0.47963197006677893},{"$f":"IF(V3<=Entrées!$C$51,U54*(1+Entrées!$C$48),0)","v":0.51800252767212129},{"$f":"IF(W3<=Entrées!$C$51,V54*(1+Entrées!$C$48),0)","v":0.55944272988589105},{"$f":"IF(X3<=Entrées!$C$51,W54*(1+Entrées!$C$48),0)","v":0.60419814827676233},{"$f":"IF(Y3<=Entrées!$C$51,X54*(1+Entrées!$C$48),0)","v":0.65253400013890339},{"$f":"IF(Z3<=Entrées!$C$51,Y54*(1+Entrées!$C$48),0)","v":0.70473672015001576},{"$f":"IF(AA3<=Entrées!$C$51,Z54*(1+Entrées!$C$48),0)","v":0.76111565776201706},{"$f":"IF(AB3<=Entrées!$C$51,AA54*(1+Entrées!$C$48),0)","v":0.82200491038297852},{"$f":"IF(AC3<=Entrées!$C$51,AB54*(1+Entrées!$C$48),0)","v":0.88776530321361691},{"$f":"IF(AD3<=Entrées!$C$51,AC54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AE3<=Entrées!$C$51,AD54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AF3<=Entrées!$C$51,AE54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AG3<=Entrées!$C$51,AF54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AH3<=Entrées!$C$51,AG54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AI3<=Entrées!$C$51,AH54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AJ3<=Entrées!$C$51,AI54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AK3<=Entrées!$C$51,AJ54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AL3<=Entrées!$C$51,AK54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AM3<=Entrées!$C$51,AL54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AN3<=Entrées!$C$51,AM54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AO3<=Entrées!$C$51,AN54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AP3<=Entrées!$C$51,AO54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AQ3<=Entrées!$C$51,AP54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AR3<=Entrées!$C$51,AQ54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AS3<=Entrées!$C$51,AR54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AT3<=Entrées!$C$51,AS54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AU3<=Entrées!$C$51,AT54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AV3<=Entrées!$C$51,AU54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AW3<=Entrées!$C$51,AV54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AX3<=Entrées!$C$51,AW54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AY3<=Entrées!$C$51,AX54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(AZ3<=Entrées!$C$51,AY54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(BA3<=Entrées!$C$51,AZ54*(1+Entrées!$C$48),0)","v":0},{"$f":"IF(BB3<=Entrées!$C$51,BA54*(1+Entrées!$C$48),0)","v":0}]
[null,"Coût variables d'exploitation (valeur nominale)","DT",null,{"$f":"E53*E54","v":7000.0000000000009},{"$f":"F53*F54","v":7560.0000000000018},{"$f":"G53*G54","v":8164.8000000000029},8817.984000000004,9523.4227200000041,10285.296537600005,11108.120260608006,11996.769881456648,12956.511471973181,13993.032389731035,15112.474980909521,16321.472979382284,17627.19081773287,19037.366083151501,20560.355369803619,22205.183799387913,23981.598503338948,25900.126383606064,27972.136494294551,30209.907413838115,32626.700006945168,35236.836007500788,38055.782888100854,41100.245519148928,44388.265160680843,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coût d'exploitation total (nominale)","DT",null,{"$f":"E55+E52","v":7400.0000000000009},{"$f":"F55+F52","v":7988.0000000000018},{"$f":"G55+G52","v":8622.760000000002},9308.0012000000042,10047.741124000004,10846.317229880005,11708.412401347607,12639.082472048021,13643.78594390595,14728.416074699098,15899.335523825348,17163.413760302217,18528.067453317199,20001.304083226732,21591.769029884119,23308.796415674045,25162.464002765111,27163.652467992059,29324.109404587565,31656.518427851643,34174.573791939642,36893.060957444875,39827.943584541026,42996.45746433991,46417.211942035196,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Service de la dette"]
[null,"Solde de trésorerie reporté","DT",null,{"$f":"Entrées!C52","v":25000},{"$f":"E59-E62","v":23431.365127937213},{"$f":"F59-F62","v":21705.866768668144},19807.81857347217,17719.965558756598,15423.327242569467,12897.025094763623,10118.092732177196,7061.267133332125,3698.7589746025433,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Service de la dette (annuités)","DT",null,{"$f":"IFERROR(E59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-E3+1)),0)","v":4068.634872062788},{"$f":"IFERROR(F59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-F3+1)),0)","v":4068.6348720627898},{"$f":"IFERROR(G59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-G3+1)),0)","v":4068.6348720627884},{"$f":"IFERROR(H59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-H3+1)),0)","v":4068.6348720627889},{"$f":"IFERROR(I59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-I3+1)),0)","v":4068.6348720627898},{"$f":"IFERROR(J59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-J3+1)),0)","v":4068.6348720627893},{"$f":"IFERROR(K59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-K3+1)),0)","v":4068.6348720627907},{"$f":"IFERROR(L59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-L3+1)),0)","v":4068.6348720627907},{"$f":"IFERROR(M59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-M3+1)),0)","v":4068.6348720627943},{"$f":"IFERROR(N59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-N3+1)),0)","v":4068.6348720627966},{"$f":"IFERROR(O59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-O3+1)),0)","v":0},{"$f":"IFERROR(P59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-P3+1)),0)","v":0},{"$f":"IFERROR(Q59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-Q3+1)),0)","v":0},{"$f":"IFERROR(R59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-R3+1)),0)","v":0},{"$f":"IFERROR(S59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-S3+1)),0)","v":0},{"$f":"IFERROR(T59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-T3+1)),0)","v":0},{"$f":"IFERROR(U59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-U3+1)),0)","v":0},{"$f":"IFERROR(V59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-V3+1)),0)","v":0},{"$f":"IFERROR(W59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-W3+1)),0)","v":0},{"$f":"IFERROR(X59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-X3+1)),0)","v":0},{"$f":"IFERROR(Y59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-Y3+1)),0)","v":0},{"$f":"IFERROR(Z59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-Z3+1)),0)","v":0},{"$f":"IFERROR(AA59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AA3+1)),0)","v":0},{"$f":"IFERROR(AB59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AB3+1)),0)","v":0},{"$f":"IFERROR(AC59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AC3+1)),0)","v":0},{"$f":"IFERROR(AD59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AD3+1)),0)","v":0},{"$f":"IFERROR(AE59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AE3+1)),0)","v":0},{"$f":"IFERROR(AF59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AF3+1)),0)","v":0},{"$f":"IFERROR(AG59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AG3+1)),0)","v":0},{"$f":"IFERROR(AH59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AH3+1)),0)","v":0},{"$f":"IFERROR(AI59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AI3+1)),0)","v":0},{"$f":"IFERROR(AJ59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AJ3+1)),0)","v":0},{"$f":"IFERROR(AK59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AK3+1)),0)","v":0},{"$f":"IFERROR(AL59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AL3+1)),0)","v":0},{"$f":"IFERROR(AM59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AM3+1)),0)","v":0},{"$f":"IFERROR(AN59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AN3+1)),0)","v":0},{"$f":"IFERROR(AO59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AO3+1)),0)","v":0},{"$f":"IFERROR(AP59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AP3+1)),0)","v":0},{"$f":"IFERROR(AQ59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AQ3+1)),0)","v":0},{"$f":"IFERROR(AR59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AR3+1)),0)","v":0},{"$f":"IFERROR(AS59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AS3+1)),0)","v":0},{"$f":"IFERROR(AT59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AT3+1)),0)","v":0},{"$f":"IFERROR(AU59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AU3+1)),0)","v":0},{"$f":"IFERROR(AV59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AV3+1)),0)","v":0},{"$f":"IFERROR(AW59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AW3+1)),0)","v":0},{"$f":"IFERROR(AX59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AX3+1)),0)","v":0},{"$f":"IFERROR(AY59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AY3+1)),0)","v":0},{"$f":"IFERROR(AZ59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-AZ3+1)),0)","v":0},{"$f":"IFERROR(BA59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-BA3+1)),0)","v":0},{"$f":"IFERROR(BB59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-BB3+1)),0)","v":0}]
[null,"Interet","DT",null,{"$f":"Entrées!$C$54*Calculs!E59","v":2500},{"$f":"Entrées!$C$54*Calculs!F59","v":2343.1365127937215},{"$f":"Entrées!$C$54*Calculs!G59","v":2170.5866768668143},{"$f":"Entrées!$C$54*Calculs!H59","v":1980.7818573472171},{"$f":"Entrées!$C$54*Calculs!I59","v":1771.9965558756599},{"$f":"Entrées!$C$54*Calculs!J59","v":1542.3327242569467},{"$f":"Entrées!$C$54*Calculs!K59","v":1289.7025094763624},{"$f":"Entrées!$C$54*Calculs!L59","v":1011.8092732177197},{"$f":"Entrées!$C$54*Calculs!M59","v":706.12671333321259},{"$f":"Entrées!$C$54*Calculs!N59","v":369.87589746025435},{"$f":"Entrées!$C$54*Calculs!O59","v":0},{"$f":"Entrées!$C$54*Calculs!P59","v":0},{"$f":"Entrées!$C$54*Calculs!Q59","v":0},{"$f":"Entrées!$C$54*Calculs!R59","v":0},{"$f":"Entrées!$C$54*Calculs!S59","v":0},{"$f":"Entrées!$C$54*Calculs!T59","v":0},{"$f":"Entrées!$C$54*Calculs!U59","v":0},{"$f":"Entrées!$C$54*Calculs!V59","v":0},{"$f":"Entrées!$C$54*Calculs!W59","v":0},{"$f":"Entrées!$C$54*Calculs!X59","v":0},{"$f":"Entrées!$C$54*Calculs!Y59","v":0},{"$f":"Entrées!$C$54*Calculs!Z59","v":0},{"$f":"Entrées!$C$54*Calculs!AA59","v":0},{"$f":"Entrées!$C$54*Calculs!AB59","v":0},{"$f":"Entrées!$C$54*Calculs!AC59","v":0},{"$f":"Entrées!$C$54*Calculs!AD59","v":0},{"$f":"Entrées!$C$54*Calculs!AE59","v":0},{"$f":"Entrées!$C$54*Calculs!AF59","v":0},{"$f":"Entrées!$C$54*Calculs!AG59","v":0},{"$f":"Entrées!$C$54*Calculs!AH59","v":0},{"$f":"Entrées!$C$54*Calculs!AI59","v":0},{"$f":"Entrées!$C$54*Calculs!AJ59","v":0},{"$f":"Entrées!$C$54*Calculs!AK59","v":0},{"$f":"Entrées!$C$54*Calculs!AL59","v":0},{"$f":"Entrées!$C$54*Calculs!AM59","v":0},{"$f":"Entrées!$C$54*Calculs!AN59","v":0},{"$f":"Entrées!$C$54*Calculs!AO59","v":0},{"$f":"Entrées!$C$54*Calculs!AP59","v":0},{"$f":"Entrées!$C$54*Calculs!AQ59","v":0},{"$f":"Entrées!$C$54*Calculs!AR59","v":0},{"$f":"Entrées!$C$54*Calculs!AS59","v":0},{"$f":"Entrées!$C$54*Calculs!AT59","v":0},{"$f":"Entrées!$C$54*Calculs!AU59","v":0},{"$f":"Entrées!$C$54*Calculs!AV59","v":0},{"$f":"Entrées!$C$54*Calculs!AW59","v":0},{"$f":"Entrées!$C$54*Calculs!AX59","v":0},{"$f":"Entrées!$C$54*Calculs!AY59","v":0},{"$f":"Entrées!$C$54*Calculs!AZ59","v":0},{"$f":"Entrées!$C$54*Calculs!BA59","v":0},{"$f":"Entrées!$C$54*Calculs!BB59","v":0}]
[null,"Montant du principal","DT",null,{"$f":"E60-E61","v":1568.634872062788},{"$f":"F60-F61","v":1725.4983592690683},{"$f":"G60-G61","v":1898.0481951959741},2087.8530147155716,2296.6383161871299,2526.3021478058427,2778.9323625864281,3056.825598845071,3362.5081587295817,3698.7589746025424,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capitaux propres initials","DT",{"$f":"Entrées!C42+Entrées!C44-Entrées!C52","v":65000}]
[]
[null,"Flux de trésorerie net","DT",null,{"$f":"-(E60+E56)-D64","v":-76468.634872062787},{"$f":"-(F60+F56)","v":-12056.634872062792},{"$f":"-(G60+G56)","v":-12691.39487206279},-13376.636072062793,-14116.375996062794,-14914.952101942796,-15777.047273410397,-16707.717344110813,-17712.420815968744,-18797.050946761894,-15899.335523825348,-17163.413760302217,-18528.067453317199,-20001.304083226732,-21591.769029884119,-23308.796415674045,-25162.464002765111,-27163.652467992059,-29324.109404587565,-31656.518427851643,-34174.573791939642,-36893.060957444875,-39827.943584541026,-42996.45746433991,-46417.211942035196,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coût totale actualisé","DT",{"$f":"-XNPV(Entrées!C59,Calculs!E66:BB66,Calculs!$E$2:$BB$2)","v":241335.69634464107}]
[null,"Coût totale actualisé par année de la vie du projet","DT",{"$f":"D68/Entrées!C51","v":9653.4278537856426}]
[]
[]
[null,null,null,{"$f":"D23","v":1645.3991461320832},{"$f":"D72","v":1645.3991461320832},{"$f":"E72","v":1645.3991461320832},1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832,1645.3991461320832]
[null,null,null,{"$f":"D46","v":4061.5383769993955},{"$f":"D73","v":4061.5383769993955},4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955,4061.5383769993955]
[null,null,null,{"$f":"D69","v":9653.4278537856426},9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426,9653.4278537856426]

{"sheet":"Résultats et scénarios","index":3,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[[9,1,9,2],[9,4,9,5],[9,7,9,8],[13,1,13,2],[31,1,31,2],[13,7,13,8],[31,7,31,8],[51,7,51,8],[10,4,10,5],[10,7,10,8],[51,1,51,2],[10,1,10,2],[13,4,13,5],[31,4,31,5],[51,4,51,5]]}
[]
["Résultats"]
[null,null,null,"Système de pompage et d'irrigation à énergie solaire (SPIS)","Système de pompage et d'irrigation au diesel (SPID)","Système de pompage et d'irrigation raccordé au réseau STEG (SPIRR)"]
[null,"Coût totale actualisé sur la vie du projet","DT",{"$f":"Calculs!D22","v":41134.978653302082},{"$f":"Calculs!D45","v":101538.45942498489},{"$f":"Calculs!D68","v":241335.69634464107}]
[null,"Coût totale actualisé par année de la vie du projet","DT/an",{"$f":"Calculs!D23","v":1645.3991461320832},{"$f":"Calculs!D46","v":4061.5383769993955},{"$f":"Calculs!D69","v":9653.4278537856426}]
[]
[]
["Scénarios"]
[]
[null,"Système de pompage et d'irrigation à énergie solaire (SPIS)",null,null,"Système de pompage et d'irrigation au diesel (SPID)",null,null,"Système de pompage et d'irrigation raccordé au réseau STEG (SPIRR)"]
[null,"Coût du SPIS, TTC",null,null,"Coût du SPID, TTC",null,null,"Coût du SPIRR, TTC"]
[]
[]
[]
[null,"scénario (changement)","Coût totale actualisé par année de la vie du projet",null,"scénario (changement)","Coût totale actualisé par année de la vie du projet",null,"scénario (changement)","Coût totale actualisé par année de la vie du projet"]
[{"$f":"A17-10","v":-70},{"$f":"TEXT(Entrées!$C$11*(1+$A16/100),\"0,0\")&\" (\"&TEXT($A16,\"0\")&\"%)\"","v":"16,500 (-70%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A16/100),\"0,0\")&\" (\"&TEXT($A16,\"0\")&\"%)\"","v":"15,000 (-70%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A16/100),\"0,0\")&\" (\"&TEXT($A16,\"0\")&\"%)\"","v":"12,000 (-70%)"}]
[-60,{"$f":"TEXT(Entrées!$C$11*(1+$A17/100),\"0,0\")&\" (\"&TEXT($A17,\"0\")&\"%)\"","v":"22,000 (-60%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A17/100),\"0,0\")&\" (\"&TEXT($A17,\"0\")&\"%)\"","v":"20,000 (-60%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A17/100),\"0,0\")&\" (\"&TEXT($A17,\"0\")&\"%)\"","v":"16,000 (-60%)"}]
[-50,{"$f":"TEXT(Entrées!$C$11*(1+$A18/100),\"0,0\")&\" (\"&TEXT($A18,\"0\")&\"%)\"","v":"27,500 (-50%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A18/100),\"0,0\")&\" (\"&TEXT($A18,\"0\")&\"%)\"","v":"25,000 (-50%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A18/100),\"0,0\")&\" (\"&TEXT($A18,\"0\")&\"%)\"","v":"20,000 (-50%)"}]
[-40,{"$f":"TEXT(Entrées!$C$11*(1+$A19/100),\"0,0\")&\" (\"&TEXT($A19,\"0\")&\"%)\"","v":"33,000 (-40%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A19/100),\"0,0\")&\" (\"&TEXT($A19,\"0\")&\"%)\"","v":"30,000 (-40%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A19/100),\"0,0\")&\" (\"&TEXT($A19,\"0\")&\"%)\"","v":"24,000 (-40%)"}]
[-30,{"$f":"TEXT(Entrées!$C$11*(1+$A20/100),\"0,0\")&\" (\"&TEXT($A20,\"0\")&\"%)\"","v":"38,500 (-30%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A20/100),\"0,0\")&\" (\"&TEXT($A20,\"0\")&\"%)\"","v":"35,000 (-30%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A20/100),\"0,0\")&\" (\"&TEXT($A20,\"0\")&\"%)\"","v":"28,000 (-30%)"}]
[-20,{"$f":"TEXT(Entrées!$C$11*(1+$A21/100),\"0,0\")&\" (\"&TEXT($A21,\"0\")&\"%)\"","v":"44,000 (-20%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A21/100),\"0,0\")&\" (\"&TEXT($A21,\"0\")&\"%)\"","v":"40,000 (-20%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A21/100),\"0,0\")&\" (\"&TEXT($A21,\"0\")&\"%)\"","v":"32,000 (-20%)"}]
[{"$f":"A23-10","v":-10},{"$f":"TEXT(Entrées!$C$11*(1+$A22/100),\"0,0\")&\" (\"&TEXT($A22,\"0\")&\"%)\"","v":"49,500 (-10%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A22/100),\"0,0\")&\" (\"&TEXT($A22,\"0\")&\"%)\"","v":"45,000 (-10%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A22/100),\"0,0\")&\" (\"&TEXT($A22,\"0\")&\"%)\"","v":"36,000 (-10%)"}]
[0,{"$f":"TEXT(Entrées!C11,\"0,0\")&\" (cas centrale)\"","v":"55,000 (cas centrale)"},null,null,{"$f":"TEXT(Entrées!C27,\"0,0\")&\" (cas centrale)\"","v":"50,000 (cas centrale)"},null,null,{"$f":"TEXT(Entrées!C42,\"0,0\")&\" (cas centrale)\"","v":"40,000 (cas centrale)"}]
[{"$f":"A23+10","v":10},{"$f":"TEXT(Entrées!$C$11*(1+$A24/100),\"0,0\")&\" (\"&TEXT($A24,\"0\")&\"%)\"","v":"60,500 (10%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A24/100),\"0,0\")&\" (\"&TEXT($A24,\"0\")&\"%)\"","v":"55,000 (10%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A24/100),\"0,0\")&\" (\"&TEXT($A24,\"0\")&\"%)\"","v":"44,000 (10%)"}]
[{"$f":"A24+10","v":20},{"$f":"TEXT(Entrées!$C$11*(1+$A25/100),\"0,0\")&\" (\"&TEXT($A25,\"0\")&\"%)\"","v":"66,000 (20%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A25/100),\"0,0\")&\" (\"&TEXT($A25,\"0\")&\"%)\"","v":"60,000 (20%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A25/100),\"0,0\")&\" (\"&TEXT($A25,\"0\")&\"%)\"","v":"48,000 (20%)"}]
[30,{"$f":"TEXT(Entrées!$C$11*(1+$A26/100),\"0,0\")&\" (\"&TEXT($A26,\"0\")&\"%)\"","v":"71,500 (30%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A26/100),\"0,0\")&\" (\"&TEXT($A26,\"0\")&\"%)\"","v":"65,000 (30%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A26/100),\"0,0\")&\" (\"&TEXT($A26,\"0\")&\"%)\"","v":"52,000 (30%)"}]
[40,{"$f":"TEXT(Entrées!$C$11*(1+$A27/100),\"0,0\")&\" (\"&TEXT($A27,\"0\")&\"%)\"","v":"77,000 (40%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A27/100),\"0,0\")&\" (\"&TEXT($A27,\"0\")&\"%)\"","v":"70,000 (40%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A27/100),\"0,0\")&\" (\"&TEXT($A27,\"0\")&\"%)\"","v":"56,000 (40%)"}]
[50,{"$f":"TEXT(Entrées!$C$11*(1+$A28/100),\"0,0\")&\" (\"&TEXT($A28,\"0\")&\"%)\"","v":"82,500 (50%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A28/100),\"0,0\")&\" (\"&TEXT($A28,\"0\")&\"%)\"","v":"75,000 (50%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A28/100),\"0,0\")&\" (\"&TEXT($A28,\"0\")&\"%)\"","v":"60,000 (50%)"}]
[60,{"$f":"TEXT(Entrées!$C$11*(1+$A29/100),\"0,0\")&\" (\"&TEXT($A29,\"0\")&\"%)\"","v":"88,000 (60%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A29/100),\"0,0\")&\" (\"&TEXT($A29,\"0\")&\"%)\"","v":"80,000 (60%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A29/100),\"0,0\")&\" (\"&TEXT($A29,\"0\")&\"%)\"","v":"64,000 (60%)"}]
[70,{"$f":"TEXT(Entrées!$C$11*(1+$A30/100),\"0,0\")&\" (\"&TEXT($A30,\"0\")&\"%)\"","v":"93,500 (70%)"},null,null,{"$f":"TEXT(Entrées!$C$27*(1+$A30/100),\"0,0\")&\" (\"&TEXT($A30,\"0\")&\"%)\"","v":"85,000 (70%)"},null,null,{"$f":"TEXT(Entrées!$C$42*(1+$A30/100),\"0,0\")&\" (\"&TEXT($A30,\"0\")&\"%)\"","v":"68,000 (70%)"}]
[]
[null,"Montant de la dette",null,null,"Consommation de diesel",null,null,"Coût de raccordement au réseau STEG"]
[]
[]
[null,"changement","Coût totale actualisé par année de la vie du projet",null,"changement","Coût totale actualisé par année de la vie du projet",null,"changement","Coût totale actualisé par année de la vie du projet"]
[{"$f":"A37-10","v":-70},{"$f":"TEXT(Entrées!$C$20*(1+$A36/100),\"0,0\")&\" (\"&TEXT($A36,\"0\")&\"%)\"","v":"6,000 (-70%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A36/100),\"0,0\")&\" (\"&TEXT($A36,\"0\")&\"%)\"","v":"525 (-70%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A36/100),\"0,0\")&\" (\"&TEXT($A36,\"0\")&\"%)\"","v":"15,000 (-70%)"}]
[-60,{"$f":"TEXT(Entrées!$C$20*(1+$A37/100),\"0,0\")&\" (\"&TEXT($A37,\"0\")&\"%)\"","v":"8,000 (-60%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A37/100),\"0,0\")&\" (\"&TEXT($A37,\"0\")&\"%)\"","v":"700 (-60%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A37/100),\"0,0\")&\" (\"&TEXT($A37,\"0\")&\"%)\"","v":"20,000 (-60%)"}]
[-50,{"$f":"TEXT(Entrées!$C$20*(1+$A38/100),\"0,0\")&\" (\"&TEXT($A38,\"0\")&\"%)\"","v":"10,000 (-50%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A38/100),\"0,0\")&\" (\"&TEXT($A38,\"0\")&\"%)\"","v":"875 (-50%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A38/100),\"0,0\")&\" (\"&TEXT($A38,\"0\")&\"%)\"","v":"25,000 (-50%)"}]
[-40,{"$f":"TEXT(Entrées!$C$20*(1+$A39/100),\"0,0\")&\" (\"&TEXT($A39,\"0\")&\"%)\"","v":"12,000 (-40%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A39/100),\"0,0\")&\" (\"&TEXT($A39,\"0\")&\"%)\"","v":"1,050 (-40%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A39/100),\"0,0\")&\" (\"&TEXT($A39,\"0\")&\"%)\"","v":"30,000 (-40%)"}]
[-30,{"$f":"TEXT(Entrées!$C$20*(1+$A40/100),\"0,0\")&\" (\"&TEXT($A40,\"0\")&\"%)\"","v":"14,000 (-30%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A40/100),\"0,0\")&\" (\"&TEXT($A40,\"0\")&\"%)\"","v":"1,225 (-30%)"},null," ",{"$f":"TEXT(Entrées!$C$44*(1+$A40/100),\"0,0\")&\" (\"&TEXT($A40,\"0\")&\"%)\"","v":"35,000 (-30%)"}]
[-20,{"$f":"TEXT(Entrées!$C$20*(1+$A41/100),\"0,0\")&\" (\"&TEXT($A41,\"0\")&\"%)\"","v":"16,000 (-20%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A41/100),\"0,0\")&\" (\"&TEXT($A41,\"0\")&\"%)\"","v":"1,400 (-20%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A41/100),\"0,0\")&\" (\"&TEXT($A41,\"0\")&\"%)\"","v":"40,000 (-20%)"}]
[{"$f":"A43-10","v":-10},{"$f":"TEXT(Entrées!$C$20*(1+$A42/100),\"0,0\")&\" (\"&TEXT($A42,\"0\")&\"%)\"","v":"18,000 (-10%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A42/100),\"0,0\")&\" (\"&TEXT($A42,\"0\")&\"%)\"","v":"1,575 (-10%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A42/100),\"0,0\")&\" (\"&TEXT($A42,\"0\")&\"%)\"","v":"45,000 (-10%)"}]
[0,{"$f":"TEXT(Entrées!C20,\"0,0\")&\" (cas centrale)\"","v":"20,000 (cas centrale)"},null,null,{"$f":"TEXT(Entrées!C29,\"0,0\")&\" (cas centrale)\"","v":"1,750 (cas centrale)"},null,null,{"$f":"TEXT(Entrées!C44,\"0,0\")&\" (cas centrale)\"","v":"50,000 (cas centrale)"}]
[{"$f":"A43+10","v":10},{"$f":"TEXT(Entrées!$C$20*(1+$A44/100),\"0,0\")&\" (\"&TEXT($A44,\"0\")&\"%)\"","v":"22,000 (10%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A44/100),\"0,0\")&\" (\"&TEXT($A44,\"0\")&\"%)\"","v":"1,925 (10%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A44/100),\"0,0\")&\" (\"&TEXT($A44,\"0\")&\"%)\"","v":"55,000 (10%)"}]
[{"$f":"A44+10","v":20},{"$f":"TEXT(Entrées!$C$20*(1+$A45/100),\"0,0\")&\" (\"&TEXT($A45,\"0\")&\"%)\"","v":"24,000 (20%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A45/100),\"0,0\")&\" (\"&TEXT($A45,\"0\")&\"%)\"","v":"2,100 (20%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A45/100),\"0,0\")&\" (\"&TEXT($A45,\"0\")&\"%)\"","v":"60,000 (20%)"}]
[30,{"$f":"TEXT(Entrées!$C$20*(1+$A46/100),\"0,0\")&\" (\"&TEXT($A46,\"0\")&\"%)\"","v":"26,000 (30%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A46/100),\"0,0\")&\" (\"&TEXT($A46,\"0\")&\"%)\"","v":"2,275 (30%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A46/100),\"0,0\")&\" (\"&TEXT($A46,\"0\")&\"%)\"","v":"65,000 (30%)"}]
[40,{"$f":"TEXT(Entrées!$C$20*(1+$A47/100),\"0,0\")&\" (\"&TEXT($A47,\"0\")&\"%)\"","v":"28,000 (40%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A47/100),\"0,0\")&\" (\"&TEXT($A47,\"0\")&\"%)\"","v":"2,450 (40%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A47/100),\"0,0\")&\" (\"&TEXT($A47,\"0\")&\"%)\"","v":"70,000 (40%)"}]
[50,{"$f":"TEXT(Entrées!$C$20*(1+$A48/100),\"0,0\")&\" (\"&TEXT($A48,\"0\")&\"%)\"","v":"30,000 (50%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A48/100),\"0,0\")&\" (\"&TEXT($A48,\"0\")&\"%)\"","v":"2,625 (50%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A48/100),\"0,0\")&\" (\"&TEXT($A48,\"0\")&\"%)\"","v":"75,000 (50%)"}]
[60,{"$f":"TEXT(Entrées!$C$20*(1+$A49/100),\"0,0\")&\" (\"&TEXT($A49,\"0\")&\"%)\"","v":"32,000 (60%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A49/100),\"0,0\")&\" (\"&TEXT($A49,\"0\")&\"%)\"","v":"2,800 (60%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A49/100),\"0,0\")&\" (\"&TEXT($A49,\"0\")&\"%)\"","v":"80,000 (60%)"}]
[70,{"$f":"TEXT(Entrées!$C$20*(1+$A50/100),\"0,0\")&\" (\"&TEXT($A50,\"0\")&\"%)\"","v":"34,000 (70%)"},null,null,{"$f":"TEXT(Entrées!$C$29*(1+$A50/100),\"0,0\")&\" (\"&TEXT($A50,\"0\")&\"%)\"","v":"2,975 (70%)"},null,null,{"$f":"TEXT(Entrées!$C$44*(1+$A50/100),\"0,0\")&\" (\"&TEXT($A50,\"0\")&\"%)\"","v":"85,000 (70%)"}]
[]
[null,"Taux d'interêt pour la dette",null,null,"Augmentation du prix du diesel",null,null,"Consommation d'électricité annuelle"]
[]
[]
[null,"changement","Coût totale actualisé par année de la vie du projet",null,"changement","Coût totale actualisé par année de la vie du projet",null,"changement","Coût totale actualisé par année de la vie du projet"]
[{"$f":"A57-10","v":-70},{"$f":"TEXT(Entrées!$C$22*(1+$A56/100),\"0.0%\")&\" (\"&TEXT($A56,\"0\")&\"%)\"","v":"3.0% (-70%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A56/100),\"0.0%\")&\" (\"&TEXT($A56,\"0\")&\"%)\"","v":"1.5% (-70%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A56/100),\"0,0\")&\" (\"&TEXT($A56,\"0\")&\"%)\"","v":"15,000 (-70%)"}]
[-60,{"$f":"TEXT(Entrées!$C$22*(1+$A57/100),\"0.0%\")&\" (\"&TEXT($A57,\"0\")&\"%)\"","v":"4.0% (-60%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A57/100),\"0.0%\")&\" (\"&TEXT($A57,\"0\")&\"%)\"","v":"2.0% (-60%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A57/100),\"0,0\")&\" (\"&TEXT($A57,\"0\")&\"%)\"","v":"20,000 (-60%)"}]
[-50,{"$f":"TEXT(Entrées!$C$22*(1+$A58/100),\"0.0%\")&\" (\"&TEXT($A58,\"0\")&\"%)\"","v":"5.0% (-50%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A58/100),\"0.0%\")&\" (\"&TEXT($A58,\"0\")&\"%)\"","v":"2.5% (-50%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A58/100),\"0,0\")&\" (\"&TEXT($A58,\"0\")&\"%)\"","v":"25,000 (-50%)"}]
[-40,{"$f":"TEXT(Entrées!$C$22*(1+$A59/100),\"0.0%\")&\" (\"&TEXT($A59,\"0\")&\"%)\"","v":"6.0% (-40%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A59/100),\"0.0%\")&\" (\"&TEXT($A59,\"0\")&\"%)\"","v":"3.0% (-40%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A59/100),\"0,0\")&\" (\"&TEXT($A59,\"0\")&\"%)\"","v":"30,000 (-40%)"}]
[-30,{"$f":"TEXT(Entrées!$C$22*(1+$A60/100),\"0.0%\")&\" (\"&TEXT($A60,\"0\")&\"%)\"","v":"7.0% (-30%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A60/100),\"0.0%\")&\" (\"&TEXT($A60,\"0\")&\"%)\"","v":"3.5% (-30%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A60/100),\"0,0\")&\" (\"&TEXT($A60,\"0\")&\"%)\"","v":"35,000 (-30%)"}]
[-20,{"$f":"TEXT(Entrées!$C$22*(1+$A61/100),\"0.0%\")&\" (\"&TEXT($A61,\"0\")&\"%)\"","v":"8.0% (-20%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A61/100),\"0.0%\")&\" (\"&TEXT($A61,\"0\")&\"%)\"","v":"4.0% (-20%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A61/100),\"0,0\")&\" (\"&TEXT($A61,\"0\")&\"%)\"","v":"40,000 (-20%)"}]
[{"$f":"A63-10","v":-10},{"$f":"TEXT(Entrées!$C$22*(1+$A62/100),\"0.0%\")&\" (\"&TEXT($A62,\"0\")&\"%)\"","v":"9.0% (-10%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A62/100),\"0.0%\")&\" (\"&TEXT($A62,\"0\")&\"%)\"","v":"4.5% (-10%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A62/100),\"0,0\")&\" (\"&TEXT($A62,\"0\")&\"%)\"","v":"45,000 (-10%)"}]
[0,{"$f":"TEXT(Entrées!C22,\"0%\")&\" (cas centrale)\"","v":"10% (cas centrale)"},null,null,{"$f":"TEXT(Entrées!C31,\"0%\")&\" (cas centrale)\"","v":"5% (cas centrale)"},null,null,{"$f":"TEXT(Entrées!C46,\"0,0\")&\" (cas centrale)\"","v":"50,000 (cas centrale)"}]
[{"$f":"A63+10","v":10},{"$f":"TEXT(Entrées!$C$22*(1+$A64/100),\"0.0%\")&\" (\"&TEXT($A64,\"0\")&\"%)\"","v":"11.0% (10%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A64/100),\"0.0%\")&\" (\"&TEXT($A64,\"0\")&\"%)\"","v":"5.5% (10%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A64/100),\"0,0\")&\" (\"&TEXT($A64,\"0\")&\"%)\"","v":"55,000 (10%)"}]
[{"$f":"A64+10","v":20},{"$f":"TEXT(Entrées!$C$22*(1+$A65/100),\"0.0%\")&\" (\"&TEXT($A65,\"0\")&\"%)\"","v":"12.0% (20%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A65/100),\"0.0%\")&\" (\"&TEXT($A65,\"0\")&\"%)\"","v":"6.0% (20%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A65/100),\"0,0\")&\" (\"&TEXT($A65,\"0\")&\"%)\"","v":"60,000 (20%)"}]
[30,{"$f":"TEXT(Entrées!$C$22*(1+$A66/100),\"0.0%\")&\" (\"&TEXT($A66,\"0\")&\"%)\"","v":"13.0% (30%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A66/100),\"0.0%\")&\" (\"&TEXT($A66,\"0\")&\"%)\"","v":"6.5% (30%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A66/100),\"0,0\")&\" (\"&TEXT($A66,\"0\")&\"%)\"","v":"65,000 (30%)"}]
[40,{"$f":"TEXT(Entrées!$C$22*(1+$A67/100),\"0.0%\")&\" (\"&TEXT($A67,\"0\")&\"%)\"","v":"14.0% (40%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A67/100),\"0.0%\")&\" (\"&TEXT($A67,\"0\")&\"%)\"","v":"7.0% (40%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A67/100),\"0,0\")&\" (\"&TEXT($A67,\"0\")&\"%)\"","v":"70,000 (40%)"}]
[50,{"$f":"TEXT(Entrées!$C$22*(1+$A68/100),\"0.0%\")&\" (\"&TEXT($A68,\"0\")&\"%)\"","v":"15.0% (50%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A68/100),\"0.0%\")&\" (\"&TEXT($A68,\"0\")&\"%)\"","v":"7.5% (50%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A68/100),\"0,0\")&\" (\"&TEXT($A68,\"0\")&\"%)\"","v":"75,000 (50%)"}]
[60,{"$f":"TEXT(Entrées!$C$22*(1+$A69/100),\"0.0%\")&\" (\"&TEXT($A69,\"0\")&\"%)\"","v":"16.0% (60%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A69/100),\"0.0%\")&\" (\"&TEXT($A69,\"0\")&\"%)\"","v":"8.0% (60%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A69/100),\"0,0\")&\" (\"&TEXT($A69,\"0\")&\"%)\"","v":"80,000 (60%)"}]
[70,{"$f":"TEXT(Entrées!$C$22*(1+$A70/100),\"0.0%\")&\" (\"&TEXT($A70,\"0\")&\"%)\"","v":"17.0% (70%)"},null,null,{"$f":"TEXT(Entrées!$C$31*(1+$A70/100),\"0.0%\")&\" (\"&TEXT($A70,\"0\")&\"%)\"","v":"8.5% (70%)"},null,null,{"$f":"TEXT(Entrées!$C$46*(1+$A70/100),\"0,0\")&\" (\"&TEXT($A70,\"0\")&\"%)\"","v":"85,000 (70%)"}]

{"sheet":"Graphiques","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Rapport imprimable","index":5,"n_rows":137,"n_cols":5,"rows_kept":137,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Outil de comparaison des coûts de systèmes de pompage"]
[null,"et d'irrigation solaire, au diesel, et raccordé au réseau STEG"]
[null,{"$f":"\"Rapport de synthèse imprimé le \"&TEXT(TODAY(),\"dd mmmm yyyy\")","v":"Rapport de synthèse imprimé le 28 July 2020"}]
[]
[null,"Hypothèses"]
[null,null,"variable","valeur","unité"]
[null,null,"Système de pompage et d'irrigation à énergie solaire (SPIS)"]
[null,null,"Taille de l'installation",{"$f":"Entrées!C8","v":10},"kWc"]
[null,null,"Coût du SPIS, hors taxes",{"$f":"Entrées!C10","v":50000},"DT"]
[null,null,"Coût du SPIS, TTC",{"$f":"Entrées!C11","v":55000},"DT"]
[null,null,"Choix de la subvention",{"$f":"Entrées!C13","v":"FTI"}]
[null,null,"Montant de la subvention",{"$f":"Entrées!C15","v":25000},"DT"]
[null,null,"Coûts fixes d'exploitation",{"$f":"Entrées!C18*Entrées!C10","v":500},"DT/an"]
[null,null,"Durée de vie du SPIS",{"$f":"Entrées!C19","v":25},"années"]
[null,null,"Montant de la dette",{"$f":"Entrées!C20","v":20000},"DT"]
[null,null,"Taux d'interêt pour la dette",{"$f":"Entrées!C22","v":0.1}]
[null,null,"Durée du crédit",{"$f":"Entrées!C23","v":10},"années"]
[]
[null,null,"Système de pompage et d'irrigation au diesel (SPID)"]
[null,null,"Coût du SPID, TTC",{"$f":"Entrées!C27","v":50000},"DT"]
[null,null,"Consommation diesel",{"$f":"Entrées!C29","v":1750},"litres/an"]
[null,null,"Prix diesel actuel",{"$f":"Entrées!C30","v":1.49},"DT/litre"]
[null,null,"Augmentation du prix diesel",{"$f":"Entrées!C31","v":0.05},"par an"]
[null,null,"Coûts fixes d'exploitation",{"$f":"Entrées!C33*Entrées!C27","v":500},"DT/an"]
[null,null,"Durée de vie du SPID",{"$f":"Entrées!C34","v":25},"années"]
[null,null,"Montant de la dette",{"$f":"Entrées!C35","v":30000},"DT"]
[null,null,"Taux d'interêt pour la dette",{"$f":"Entrées!C37","v":0.1}]
[null,null,"Durée du crédit",{"$f":"Entrées!C38","v":10},"années"]
[]
[null,null,"Système de pompage et d'irrigation raccordé au réseau STEG (SPIRR)"]
[null,null,"Coût du SPIRR, TTC",{"$f":"Entrées!C42","v":40000},"DT"]
[null,null,"Coût de raccordement au réseau STEG",{"$f":"Entrées!C44","v":50000},"DT"]
[null,null,"Consommation d'électricité",{"$f":"Entrées!C46","v":50000},"kWh/an"]
[null,null,"Tarif moyen d'électricité actuel",{"$f":"Entrées!C47","v":0.14000000000000001},"DT/kWh"]
[null,null,"Augmentation du prix d'électricité",{"$f":"Entrées!C48","v":0.08},"par an"]
[null,null,"Coûts fixes d'exploitation",{"$f":"Entrées!C50*Entrées!C42","v":400},"DT/an"]
[null,null,"Durée de vie du SPIRR",{"$f":"Entrées!C51","v":25},"années"]
[null,null,"Montant de la dette",{"$f":"Entrées!C52","v":25000},"DT"]
[null,null,"Taux d'interêt pour la dette",{"$f":"Entrées!C54","v":0.1}]
[null,null,"Durée du crédit",{"$f":"Entrées!C55","v":10},"années"]
[]
[null,"Outil d'analyse de la rentabilité des projets PV en Tunisie (version juillet 2020)"]
[null,"Page 1"]
[]
[null,"Résultats"]
[]
[null,null,"variable","valeur","unité"]
[null,null,"Système de pompage et d'irrigation à énergie solaire (SPIS)"]
[null,null,"Coût totale actualisé sur la vie du projet",{"$f":"'Résultats et scénarios'!D4","v":41134.978653302082},"DT"]
[null,null,"Coût totale actualisé par année de la vie du projet",{"$f":"'Résultats et scénarios'!D5","v":1645.3991461320832},"DT/an"]
[]
[null,null,"Système de pompage et d'irrigation au diesel (SPID)"]
[null,null,"Coût totale actualisé sur la vie du projet",{"$f":"'Résultats et scénarios'!E4","v":101538.45942498489},"DT"]
[null,null,"Coût totale actualisé par année de la vie du projet",{"$f":"'Résultats et scénarios'!E5","v":4061.5383769993955},"DT/an"]
[]
[null,null,"Système de pompage et d'irrigation raccordé au réseau STEG (SPIRR)"]
[null,null,"Coût totale actualisé sur la vie du projet",{"$f":"'Résultats et scénarios'!F4","v":241335.69634464107},"DT"]
[null,null,"Coût totale actualisé par année de la vie du projet",{"$f":"'Résultats et scénarios'!F5","v":9653.4278537856426},"DT/an"]
[]
[null,"Outil d'analyse de la rentabilité des projets PV en Tunisie (version juillet 2020)"]
[null,"Page 2"]
[]
[null,null,"Graphiques"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outil d'analyse de la rentabilité des projets PV en Tunisie (version juillet 2020)"]
[null,"Page 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outil d'analyse de la rentabilité des projets PV en Tunisie (version juillet 2020)"]
[null,"Page 4"]