{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Entrées","Calculs","Résultats et scénarios"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"Entrées","index":0,"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",60000,"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.41666666666666669},"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",10000,"DT"]
[null,null,{"$f":"C20/(C11-C15)","v":0.2857142857142857},"du coût nette 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.48,"DT/litre"]
[null,"augementation du prix diesel",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 SPID",25,"années"]
[null,"Montant de la dette",10000,"DT"]
[null,null,{"$f":"C35/C27","v":0.2},"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",50000,"DT"]
[]
[null,"Coût de raccordement au réseau STEG",50000,"DT"]
[]
[null,"Consommation d'électricité",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",10000,"DT"]
[null,null,{"$f":"C52/C44","v":0.2},"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":1,"n_rows":69,"n_cols":54,"rows_kept":69,"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":10000},{"$f":"E13-E16","v":9372.5460511748843},{"$f":"F13-(F14-F15)","v":8682.3467074672571},7923.1274293888673,7087.9862235026385,6169.3308970277867,5158.8100379054495,4047.2370928708783,2824.5068533328499,1479.5035898410176,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":1627.4539488251153},{"$f":"IFERROR(F13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!F3+1)),0)","v":1627.4539488251157},{"$f":"IFERROR(G13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!G3+1)),0)","v":1627.4539488251155},{"$f":"IFERROR(H13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!H3+1)),0)","v":1627.4539488251155},{"$f":"IFERROR(I13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!I3+1)),0)","v":1627.453948825116},{"$f":"IFERROR(J13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!J3+1)),0)","v":1627.453948825116},{"$f":"IFERROR(K13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!K3+1)),0)","v":1627.4539488251162},{"$f":"IFERROR(L13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!L3+1)),0)","v":1627.4539488251162},{"$f":"IFERROR(M13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!M3+1)),0)","v":1627.4539488251173},{"$f":"IFERROR(N13*Entrées!$C$22/(1-(1+Entrées!$C$22)^-(Entrées!$C$23-Calculs!N3+1)),0)","v":1627.4539488251189},{"$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":1000},{"$f":"Entrées!$C$22*F13","v":937.2546051174885},{"$f":"Entrées!$C$22*G13","v":868.23467074672578},{"$f":"Entrées!$C$22*H13","v":792.3127429388868},{"$f":"Entrées!$C$22*I13","v":708.79862235026394},{"$f":"Entrées!$C$22*J13","v":616.93308970277872},{"$f":"Entrées!$C$22*K13","v":515.88100379054492},{"$f":"Entrées!$C$22*L13","v":404.72370928708784},{"$f":"Entrées!$C$22*M13","v":282.45068533328498},{"$f":"Entrées!$C$22*N13","v":147.95035898410177},{"$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":627.45394882511528},{"$f":"(F14-F15)","v":690.19934370762724},759.21927807838972,835.1412058862287,918.65532647485202,1010.5208591223372,1111.5729450345711,1222.7302395380284,1345.0032634918323,1479.5035898410172,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":25000}]
[]
[null,"Flux de trésorerie net","DT",null,{"$f":"-(E14+E10)-D18","v":-27127.453948825114},{"$f":"-(F14+F10)","v":-2162.4539488251157},-2199.9039488251155,-2239.9754488251156,-2282.8519538251162,-2328.7298141751162,-2377.8191247496165,-2430.3446870643315,-2486.5470387410778,-2546.6835550351966,-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":45138.705714085772}]
[null,"Coût totale actualisé par année de la vie du projet","DT",{"$f":"D22/Entrées!C19","v":1805.5482285634309}]
[]
["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.48},{"$f":"IF(F3<=Entrées!$C$34,E31*(1+Entrées!$C$31),0)","v":1.5984},{"$f":"IF(G3<=Entrées!$C$34,F31*(1+Entrées!$C$31),0)","v":1.7262720000000003},{"$f":"IF(H3<=Entrées!$C$34,G31*(1+Entrées!$C$31),0)","v":1.8643737600000003},{"$f":"IF(I3<=Entrées!$C$34,H31*(1+Entrées!$C$31),0)","v":2.0135236608000007},{"$f":"IF(J3<=Entrées!$C$34,I31*(1+Entrées!$C$31),0)","v":2.174605553664001},{"$f":"IF(K3<=Entrées!$C$34,J31*(1+Entrées!$C$31),0)","v":2.3485739979571214},{"$f":"IF(L3<=Entrées!$C$34,K31*(1+Entrées!$C$31),0)","v":2.5364599177936911},{"$f":"IF(M3<=Entrées!$C$34,L31*(1+Entrées!$C$31),0)","v":2.7393767112171865},{"$f":"IF(N3<=Entrées!$C$34,M31*(1+Entrées!$C$31),0)","v":2.9585268481145617},{"$f":"IF(O3<=Entrées!$C$34,N31*(1+Entrées!$C$31),0)","v":3.1952089959637267},{"$f":"IF(P3<=Entrées!$C$34,O31*(1+Entrées!$C$31),0)","v":3.4508257156408249},{"$f":"IF(Q3<=Entrées!$C$34,P31*(1+Entrées!$C$31),0)","v":3.7268917728920909},{"$f":"IF(R3<=Entrées!$C$34,Q31*(1+Entrées!$C$31),0)","v":4.0250431147234584},{"$f":"IF(S3<=Entrées!$C$34,R31*(1+Entrées!$C$31),0)","v":4.3470465639013351},{"$f":"IF(T3<=Entrées!$C$34,S31*(1+Entrées!$C$31),0)","v":4.694810289013442},{"$f":"IF(U3<=Entrées!$C$34,T31*(1+Entrées!$C$31),0)","v":5.0703951121345181},{"$f":"IF(V3<=Entrées!$C$34,U31*(1+Entrées!$C$31),0)","v":5.4760267211052795},{"$f":"IF(W3<=Entrées!$C$34,V31*(1+Entrées!$C$31),0)","v":5.9141088587937025},{"$f":"IF(X3<=Entrées!$C$34,W31*(1+Entrées!$C$31),0)","v":6.3872375674971993},{"$f":"IF(Y3<=Entrées!$C$34,X31*(1+Entrées!$C$31),0)","v":6.8982165728969758},{"$f":"IF(Z3<=Entrées!$C$34,Y31*(1+Entrées!$C$31),0)","v":7.4500738987287347},{"$f":"IF(AA3<=Entrées!$C$34,Z31*(1+Entrées!$C$31),0)","v":8.0460798106270346},{"$f":"IF(AB3<=Entrées!$C$34,AA31*(1+Entrées!$C$31),0)","v":8.6897661954771976},{"$f":"IF(AC3<=Entrées!$C$34,AB31*(1+Entrées!$C$31),0)","v":9.3849474911153745},{"$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":2590},{"$f":"F30*F31","v":2797.2000000000003},3020.9760000000006,3262.6540800000007,3523.6664064000011,3805.5597189120017,4110.0044964249628,4438.8048561389596,4793.9092446300765,5177.4219842004832,5591.6157429365212,6038.9450023714435,6522.0606025611596,7043.8254507660522,7607.3314868273364,8215.918005773523,8873.1914462354071,9583.0467619342398,10349.69050288898,11177.665743120098,12071.879002569707,13037.629322775285,14080.63966859731,15207.090842085096,16423.658109451906,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":3090},{"$f":"F32+F29","v":3332.2000000000003},3593.4260000000004,3875.175580000001,4179.0644114000015,4506.8355842620022,4860.3696723494631,5241.695594378175,5653.0023345460368,6096.6515904105609,6575.1914215813049,7091.3709785213614,7648.1563970415718,8248.7479508600936,8896.59856192796,9595.4337761311908,10349.273320518112,11162.454367416734,12039.656640755249,12985.929510637006,14006.721233812799,15107.910510205395,16295.840539147528,17577.355773573829,18959.841586144848,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":10000},{"$f":"E36-E39","v":9372.5460511748843},{"$f":"F36-F39","v":8682.3467074672571},7923.1274293888673,7087.9862235026385,6169.3308970277867,5158.8100379054495,4047.2370928708783,2824.5068533328499,1479.5035898410176,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":1627.4539488251153},{"$f":"IFERROR(F36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-F3+1)),0)","v":1627.4539488251157},{"$f":"IFERROR(G36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-G3+1)),0)","v":1627.4539488251155},{"$f":"IFERROR(H36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-H3+1)),0)","v":1627.4539488251155},{"$f":"IFERROR(I36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-I3+1)),0)","v":1627.453948825116},{"$f":"IFERROR(J36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-J3+1)),0)","v":1627.453948825116},{"$f":"IFERROR(K36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-K3+1)),0)","v":1627.4539488251162},{"$f":"IFERROR(L36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-L3+1)),0)","v":1627.4539488251162},{"$f":"IFERROR(M36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-M3+1)),0)","v":1627.4539488251173},{"$f":"IFERROR(N36*Entrées!$C$37/(1-(1+Entrées!$C$37)^-(Entrées!$C$38-N3+1)),0)","v":1627.4539488251189},{"$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":1000},{"$f":"Entrées!$C$37*F36","v":937.2546051174885},{"$f":"Entrées!$C$37*G36","v":868.23467074672578},{"$f":"Entrées!$C$37*H36","v":792.3127429388868},{"$f":"Entrées!$C$37*I36","v":708.79862235026394},{"$f":"Entrées!$C$37*J36","v":616.93308970277872},{"$f":"Entrées!$C$37*K36","v":515.88100379054492},{"$f":"Entrées!$C$37*L36","v":404.72370928708784},{"$f":"Entrées!$C$37*M36","v":282.45068533328498},{"$f":"Entrées!$C$37*N36","v":147.95035898410177},{"$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":627.45394882511528},{"$f":"F37-F38","v":690.19934370762724},759.21927807838972,835.1412058862287,918.65532647485202,1010.5208591223372,1111.5729450345711,1222.7302395380284,1345.0032634918323,1479.5035898410172,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":40000}]
[]
[null,"Flux de trésorerie net","DT",null,{"$f":"-(E37+E33)-D41","v":-44717.453948825118},{"$f":"-(F37+F33)","v":-4959.6539488251165},{"$f":"-(G37+G33)","v":-5220.8799488251161},-5502.6295288251167,-5806.5183602251172,-6134.2895330871179,-6487.8236211745789,-6869.1495432032916,-7280.4562833711543,-7724.1055392356793,-6575.1914215813049,-7091.3709785213614,-7648.1563970415718,-8248.7479508600936,-8896.59856192796,-9595.4337761311908,-10349.273320518112,-11162.454367416734,-12039.656640755249,-12985.929510637006,-14006.721233812799,-15107.910510205395,-16295.840539147528,-17577.355773573829,-18959.841586144848,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":112505.20079146647}]
[null,"Coût totale actualisé par année de la vie du projet","DT",{"$f":"D45/Entrées!C34","v":4500.2080316586589}]
[]
["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":500},{"$f":"IF(F3<=Entrées!$C$51,E51,0)","v":500},{"$f":"IF(G3<=Entrées!$C$51,F51,0)","v":500},{"$f":"IF(H3<=Entrées!$C$51,G51,0)","v":500},{"$f":"IF(I3<=Entrées!$C$51,H51,0)","v":500},{"$f":"IF(J3<=Entrées!$C$51,I51,0)","v":500},{"$f":"IF(K3<=Entrées!$C$51,J51,0)","v":500},{"$f":"IF(L3<=Entrées!$C$51,K51,0)","v":500},{"$f":"IF(M3<=Entrées!$C$51,L51,0)","v":500},{"$f":"IF(N3<=Entrées!$C$51,M51,0)","v":500},{"$f":"IF(O3<=Entrées!$C$51,N51,0)","v":500},{"$f":"IF(P3<=Entrées!$C$51,O51,0)","v":500},{"$f":"IF(Q3<=Entrées!$C$51,P51,0)","v":500},{"$f":"IF(R3<=Entrées!$C$51,Q51,0)","v":500},{"$f":"IF(S3<=Entrées!$C$51,R51,0)","v":500},{"$f":"IF(T3<=Entrées!$C$51,S51,0)","v":500},{"$f":"IF(U3<=Entrées!$C$51,T51,0)","v":500},{"$f":"IF(V3<=Entrées!$C$51,U51,0)","v":500},{"$f":"IF(W3<=Entrées!$C$51,V51,0)","v":500},{"$f":"IF(X3<=Entrées!$C$51,W51,0)","v":500},{"$f":"IF(Y3<=Entrées!$C$51,X51,0)","v":500},{"$f":"IF(Z3<=Entrées!$C$51,Y51,0)","v":500},{"$f":"IF(AA3<=Entrées!$C$51,Z51,0)","v":500},{"$f":"IF(AB3<=Entrées!$C$51,AA51,0)","v":500},{"$f":"IF(AC3<=Entrées!$C$51,AB51,0)","v":500},{"$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":500},{"$f":"F51*F4","v":535},{"$f":"G51*G4","v":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,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":7500.0000000000009},{"$f":"F55+F52","v":8095.0000000000018},{"$f":"G55+G52","v":8737.2500000000036},9430.5055000000048,10178.820725000005,10986.572402950005,11858.485436532506,12799.660619695864,13815.604561889142,14912.261995941113,16096.050659554305,17373.898955532204,18753.286612213284,20242.288583245543,21849.622444904242,23584.699569745582,25457.680377621655,27479.533989088559,29662.102632160819,32018.171181355025,34561.54223818826,37307.117194930899,40270.983758651069,43470.510450637659,46924.448637373789,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":10000},{"$f":"E59-E62","v":9372.5460511748843},{"$f":"F59-F62","v":8682.3467074672571},7923.1274293888673,7087.9862235026385,6169.3308970277867,5158.8100379054495,4047.2370928708783,2824.5068533328499,1479.5035898410176,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":1627.4539488251153},{"$f":"IFERROR(F59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-F3+1)),0)","v":1627.4539488251157},{"$f":"IFERROR(G59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-G3+1)),0)","v":1627.4539488251155},{"$f":"IFERROR(H59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-H3+1)),0)","v":1627.4539488251155},{"$f":"IFERROR(I59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-I3+1)),0)","v":1627.453948825116},{"$f":"IFERROR(J59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-J3+1)),0)","v":1627.453948825116},{"$f":"IFERROR(K59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-K3+1)),0)","v":1627.4539488251162},{"$f":"IFERROR(L59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-L3+1)),0)","v":1627.4539488251162},{"$f":"IFERROR(M59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-M3+1)),0)","v":1627.4539488251173},{"$f":"IFERROR(N59*Entrées!$C$54/(1-(1+Entrées!$C$54)^-(Entrées!$C$55-N3+1)),0)","v":1627.4539488251189},{"$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":1000},{"$f":"Entrées!$C$54*Calculs!F59","v":937.2546051174885},{"$f":"Entrées!$C$54*Calculs!G59","v":868.23467074672578},{"$f":"Entrées!$C$54*Calculs!H59","v":792.3127429388868},{"$f":"Entrées!$C$54*Calculs!I59","v":708.79862235026394},{"$f":"Entrées!$C$54*Calculs!J59","v":616.93308970277872},{"$f":"Entrées!$C$54*Calculs!K59","v":515.88100379054492},{"$f":"Entrées!$C$54*Calculs!L59","v":404.72370928708784},{"$f":"Entrées!$C$54*Calculs!M59","v":282.45068533328498},{"$f":"Entrées!$C$54*Calculs!N59","v":147.95035898410177},{"$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":627.45394882511528},{"$f":"F60-F61","v":690.19934370762724},{"$f":"G60-G61","v":759.21927807838972},835.1412058862287,918.65532647485202,1010.5208591223372,1111.5729450345711,1222.7302395380284,1345.0032634918323,1479.5035898410172,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":90000}]
[]
[null,"Flux de trésorerie net","DT",null,{"$f":"-(E60+E56)-D64","v":-99127.453948825118},{"$f":"-(F60+F56)","v":-9722.4539488251175},{"$f":"-(G60+G56)","v":-10364.703948825119},-11057.95944882512,-11806.274673825121,-12614.026351775121,-13485.939385357622,-14427.114568520979,-15443.05851071426,-16539.715944766231,-16096.050659554305,-17373.898955532204,-18753.286612213284,-20242.288583245543,-21849.622444904242,-23584.699569745582,-25457.680377621655,-27479.533989088559,-29662.102632160819,-32018.171181355025,-34561.54223818826,-37307.117194930899,-40270.983758651069,-43470.510450637659,-46924.448637373789,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":251669.77349079054}]
[null,"Coût totale actualisé par année de la vie du projet","DT",{"$f":"D68/Entrées!C51","v":10066.790939631621}]

{"sheet":"Résultats et scénarios","index":2,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[9,7,9,8],[27,7,27,8],[45,7,45,8],[8,4,8,5],[8,7,8,8],[9,1,9,2],[27,1,27,2],[45,1,45,2],[8,1,8,2],[9,4,9,5],[27,4,27,5],[45,4,45,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é par année de la vie du projet","DT/an",{"$f":"Calculs!D23","v":1805.5482285634309},{"$f":"Calculs!D46","v":4500.2080316586589},{"$f":"Calculs!D69","v":10066.790939631621}]
[]
[]
["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 SPIS, TTC",null,null,"Coût du SPIS, TTC"]
[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"]
[null,{"$f":"B13-0.1","v":-0.7},null,null,{"$f":"E13-0.1","v":-0.7},null,null,{"$f":"H13-0.1","v":-0.7}]
[null,-0.6,null,null,-0.6,null,null,-0.6]
[null,-0.5,null,null,-0.5,null,null,-0.5]
[null,-0.4,null,null,-0.4,null,null,-0.4]
[null,-0.30000000000000004,null,null,-0.30000000000000004,null,null,-0.30000000000000004]
[null,-0.2,null,null,-0.2,null,null,-0.2]
[null,{"$f":"B19-0.1","v":-0.1},null,null,{"$f":"E19-0.1","v":-0.1},null,null,{"$f":"H19-0.1","v":-0.1}]
[null,0,null,null,0,null,null,0]
[null,{"$f":"B19+0.1","v":0.1},null,null,{"$f":"E19+0.1","v":0.1},null,null,{"$f":"H19+0.1","v":0.1}]
[null,{"$f":"B20+0.1","v":0.2},null,null,{"$f":"E20+0.1","v":0.2},null,null,{"$f":"H20+0.1","v":0.2}]
[null,0.30000000000000004,null,null,0.30000000000000004,null,null,0.30000000000000004]
[null,0.4,null,null,0.4,null,null,0.4]
[null,0.5,null,null,0.5,null,null,0.5]
[null,0.6,null,null,0.6,null,null,0.6]
[null,0.7,null,null,0.7,null,null,0.7]
[]
[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"]
[null,{"$f":"B31-0.1","v":-0.7},null,null,{"$f":"E31-0.1","v":-0.7},null,null,{"$f":"H31-0.1","v":-0.7}]
[null,-0.6,null,null,-0.6,null,null,-0.6]
[null,-0.5,null,null,-0.5,null,null,-0.5]
[null,-0.4,null,null,-0.4,null,null,-0.4]
[null,-0.30000000000000004,null,null,-0.30000000000000004,null,null,-0.30000000000000004]
[null,-0.2,null,null,-0.2,null,null,-0.2]
[null,{"$f":"B37-0.1","v":-0.1},null,null,{"$f":"E37-0.1","v":-0.1},null,null,{"$f":"H37-0.1","v":-0.1}]
[null,0,null,null,0,null,null,0]
[null,{"$f":"B37+0.1","v":0.1},null,null,{"$f":"E37+0.1","v":0.1},null,null,{"$f":"H37+0.1","v":0.1}]
[null,{"$f":"B38+0.1","v":0.2},null,null,{"$f":"E38+0.1","v":0.2},null,null,{"$f":"H38+0.1","v":0.2}]
[null,0.30000000000000004,null,null,0.30000000000000004,null,null,0.30000000000000004]
[null,0.4,null,null,0.4,null,null,0.4]
[null,0.5,null,null,0.5,null,null,0.5]
[null,0.6,null,null,0.6,null,null,0.6]
[null,0.7,null,null,0.7,null,null,0.7]
[]
[null,"Taux d'interêt pour la dette",null,null,"Augmentation du prix du diesel"]
[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"]
[null,{"$f":"B49-0.1","v":-0.7},null,null,{"$f":"E49-0.1","v":-0.7},null,null,{"$f":"H49-0.1","v":-0.7}]
[null,-0.6,null,null,-0.6,null,null,-0.6]
[null,-0.5,null,null,-0.5,null,null,-0.5]
[null,-0.4,null,null,-0.4,null,null,-0.4]
[null,-0.30000000000000004,null,null,-0.30000000000000004,null,null,-0.30000000000000004]
[null,-0.2,null,null,-0.2,null,null,-0.2]
[null,{"$f":"B55-0.1","v":-0.1},null,null,{"$f":"E55-0.1","v":-0.1},null,null,{"$f":"H55-0.1","v":-0.1}]
[null,0,null,null,0,null,null,0]
[null,{"$f":"B55+0.1","v":0.1},null,null,{"$f":"E55+0.1","v":0.1},null,null,{"$f":"H55+0.1","v":0.1}]
[null,{"$f":"B56+0.1","v":0.2},null,null,{"$f":"E56+0.1","v":0.2},null,null,{"$f":"H56+0.1","v":0.2}]
[null,0.30000000000000004,null,null,0.30000000000000004,null,null,0.30000000000000004]
[null,0.4,null,null,0.4,null,null,0.4]
[null,0.5,null,null,0.5,null,null,0.5]
[null,0.6,null,null,0.6,null,null,0.6]
[null,0.7,null,null,0.7,null,null,0.7]