{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Coût Energie"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Coût Energie","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12]]}
[]
[null,"Quantité d'eau",null,120,"m3",{"$f":"+D2","v":120},"m3",{"$f":"+F2","v":120},"m3",{"$f":"F2","v":120},"m3",{"$f":"F2","v":120},"m3"]
[null,"Energie",null,{"$f":"+F3","v":218},"kWh/jour",218,"kWh/jour",{"$f":"+F3","v":218},"kWh/jour",{"$f":"F3","v":218},"kWh/jour",{"$f":"+F3","v":218},"kWh/jour"]
[null,"Source primaire",null,"GASOIL",null,"PV",null,"ELECTRICITE",null,"BUTANE subventionné",null,"BUTANE non subventionné"]
[null,"Rendement",null,0.3,null,1,null,1,null,0.32,null,0.32]
[null,"Energie primaire consommée",null,{"$f":"+D3/D5","v":726.66666666666674},"kWh",{"$f":"+F3/F5","v":218},"kWh",{"$f":"+H3/H5","v":218},"kWh",{"$f":"+J3/J5","v":681.25},"kWh",{"$f":"+L3/L5","v":681.25},"kWh"]
[null,"Contenu énergetique",null,{"$f":"10000*4.18/3600*0.8","v":9.2888888888888896},"kWh/litre",1,"kWh/kWh",1,"kWh/kWh",{"$f":"11500*4.18/3600*12","v":160.23333333333335},"kWh/Bouteille",{"$f":"11500*4.18/3600*12","v":160.23333333333335},"kWh/Bouteille"]
[null,"Quantité réellement consommée",null,{"$f":"D6/D7","v":78.229665071770341},"litre",{"$f":"F6/F7","v":218},"kWh",{"$f":"H6/H7","v":218},"kWh",{"$f":"J6/J7","v":4.2516122321614311},"Bouteille",{"$f":"L6/L7","v":4.2516122321614311},"Bouteille"]
[null,"Prix de l'énergie",null,9.5,"DH/litre",0,"DH/kWh",0.9,"DH/kWh",42,"DH/Bouteille",126,"DH/Bouteille"]
[null,"Facture énergétique journalière",null,{"$f":"D9*D8","v":743.18181818181824},"DH/jour",{"$f":"F9*F8","v":0},"DH/jour",{"$f":"H9*H8","v":196.20000000000002},"DH/jour",{"$f":"J9*J8","v":178.56771375078011},"DH/jour",{"$f":"L9*L8","v":535.70314125234029},"DH/jour"]
[null,"Facture énergétique mensuelle ",null,{"$f":"D10*30","v":22295.454545454548},"DH/mois",{"$f":"F10*30","v":0},"DH/mois",{"$f":"H10*30","v":5886.0000000000009},"DH/mois",{"$f":"J10*30","v":5357.0314125234036},"DH/mois",{"$f":"L10*30","v":16071.094237570209},"DH/mois"]
[null,"Coût unitaire de l'eau - Exploitation",null,{"$f":"D10/D2","v":6.1931818181818183},"DH/m3",{"$f":"F10/F2","v":0},"DH/m3",{"$f":"H10/H2","v":1.6350000000000002},"DH/m3",{"$f":"J10/J2","v":1.488064281256501},"DH/m3",{"$f":"L10/L2","v":4.464192843769502},"DH/m3"]
[null,"Durée d'exploitation",null,{"$f":"+F13","v":10},"ans",10,"ans",{"$f":"+F13","v":10},"ans",{"$f":"F13","v":10},"ans",{"$f":"F13","v":10},"ans"]
[null,"Coût d'exploitation",null,{"$f":"D10*30*12*D13","v":2675454.5454545459},"DH",{"$f":"F10*30*12*F13","v":0},"DH",{"$f":"H10*30*12*H13","v":706320.00000000012},"DH",{"$f":"J10*30*12*J13","v":642843.76950280846},"DH",{"$f":"L10*30*12*L13","v":1928531.308508425},"DH"]
[null,"Prix de la connection",null,0,"DH",0,"DH",280000,"DH",0,"DH",0,"DH"]
[null,"Prix de l'installation",null,{"$f":"(51750+72000/2)*(1+0.05*(D13-1))","v":127237.5},"DH",600000,"DH",50000,"DH",70000,"DH",70000,"DH"]
[null,"Coût total",null,{"$f":"+D16+D14+D15","v":2802692.0454545459},"DH",{"$f":"+F16+F14+F15","v":600000},"DH",{"$f":"+H16+H14+H15","v":1036320.0000000001},"DH",{"$f":"+J16+J14+J15","v":712843.76950280846},"DH",{"$f":"+L16+L14+L15","v":1998531.308508425},"DH"]
[null,"Coût unitaire de l'eau - Total",null,{"$f":"D17/(D2*D13*365)","v":6.3988402864259042},"DH/m3",{"$f":"F17/(F2*F13*365)","v":1.3698630136986301},"DH/m3",{"$f":"H17/(H2*H13*365)","v":2.3660273972602743},"DH/m3",{"$f":"J17/(J2*J13*365)","v":1.6274971906456814},"DH/m3",{"$f":"L17/(L2*L13*365)","v":4.5628568687406963},"DH/m3"]
[]
[]
[null,"ANNEE",1,2,3,4,5,6,7,8,9,10]
[null,"Coût cumulé GASOIL",{"$f":"+$D$15+$D$16+C21*12*$D$11","v":394782.95454545459},{"$f":"+$D$15+$D$16+D21*12*$D$11","v":662328.40909090918},929873.86363636376,1197419.3181818184,1464964.7727272729,1732510.2272727275,2000055.6818181821,2267601.1363636367,2535146.5909090913,2802692.0454545459]
[null,"Coût cumulé ELECTRICITE",{"$f":"+$H$15+$H$16+C21*12*$H$11","v":400632},471264,541896,612528,683160,753792,824424,895056.00000000012,965688.00000000012,1036320.0000000001]
[null,"Coût cumulé PV",{"$f":"+$F$15+$F$16+C21*12*$F$11","v":600000},600000,600000,600000,600000,600000,600000,600000,600000,600000]
[null,"Coût cumulé BUTANE subventionné",{"$f":"+$J$15+$J$16+C21*12*$J$11","v":134284.37695028086},198568.75390056169,262853.13085084251,327137.50780112337,391421.88475140423,455706.26170168503,519990.63865196588,584275.01560224674,648559.3925525276,712843.76950280846]
[null,"Coût cumulé BUTANE non subventionné",{"$f":"+$L$15+$L$16+C21*12*$L$11","v":262853.13085084251},{"$f":"+$L$15+$L$16+D21*12*$L$11","v":455706.26170168503},{"$f":"+$L$15+$L$16+E21*12*$L$11","v":648559.39255252748},{"$f":"+$L$15+$L$16+F21*12*$L$11","v":841412.52340337005},1034265.6542542125,1227118.785105055,1419971.9159558977,1612825.0468067401,1805678.1776575826,1998531.308508425]
[null,"Différence PV-GASOIL",{"$f":"+C24-C22","v":205217.04545454541},-62328.409090909176,-329873.86363636376,-597419.31818181835,-864964.77272727294,-1132510.2272727275,-1400055.6818181821,-1667601.1363636367,-1935146.5909090913,-2202692.0454545459]
[null,"Différence PV-ELECTRICITE",{"$f":"+C24-C23","v":199368},128736,58104,-12528,-83160,-153792,-224424,-295056.00000000012,-365688.00000000012,-436320.00000000012]
[null,"Différence PV-BUTANE subventionné",{"$f":"C24-C25","v":465715.62304971914},{"$f":"D24-D25","v":401431.24609943829},{"$f":"E24-E25","v":337146.86914915749},{"$f":"F24-F25","v":272862.49219887663},208578.11524859577,144293.73829831497,80009.361348034116,15724.984397753258,-48559.392552527599,-112843.76950280846]
[null,"Différence PV-BUTANE non subventionné",{"$f":"+C24-C26","v":337146.86914915749},{"$f":"+D24-D26","v":144293.73829831497},{"$f":"+E24-E26","v":-48559.392552527483},{"$f":"+F24-F26","v":-241412.52340337005},-434265.65425421251,-627118.78510505497,-819971.91595589765,-1012825.0468067401,-1205678.1776575826,-1398531.308508425]
[]
[{"$nulls":4},"Point mort en année"]
[null,null,null,"GASOIL",2.14]
[null,null,null,"ELECTRICITE",3.82]
[null,null,null,"BUTANE 1",8.24]
[null,null,null,"BUTANE 2",2.75]