{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Relevés"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"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":"Relevés","index":0,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,10,21,16],[0,6,0,14],[3,8,3,9],[3,10,3,12],[4,8,4,12],[20,3,20,5]]}
[null,null,null,null,null,null,"RELEVE GROUPE DES LOCATAIRES",null,null,null,null,null,null,null,null,null,null,"Base"]
[null,null,null,null,{"$f":"[1]Base!B3","v":"Immeuble Rue De la Fléchère 17 - M. Deblue"},null,null,null,null,null,{"$f":"[1]Base!B5","v":"Relevés par G. Vocat"}]
[null,null,null,null,{"$f":"[1]Base!B4","v":"CH - 1260  Nyon"}]
[null,null,null,null,null,null,"Année(s) :",null,{"$f":"F8&\"  /  \"&F14","v":"2024  /  2025"},null,"Consommation Annuelle d'eau en M3 :",null,null,null,{"$f":"[1]Immeuble!I20","v":-1229.471}]
[null,null,null,null,null,null,null,null,"Coût estimé des Charges + Taxes \nen CHF :",null,null,null,null,null,{"$f":"'[1]Prix M3 Eau'!F17","v":1022.8799289027902},null,"EN KWH","EN KWH"]
[null,null,null,"Jour","Mois","Année","Kw\nElectricité\nImmeuble","Conso.\nMensuelle\nImmeuble","Kw\nElectricité\nStudio","Conso.\nMensuelle\nStudio","Kw\nElectricité\n1er gauche","Conso.\nMensuelle\n1er Gauche","Kw\nElectricité\n1er droit\n","Conso.\nMensuelle\n1er droit","Compteur d'Eau\n","Conso. \nMensuelle m 3","Total Général de Consommation Electricité","Consommation Mensuelle Electricité De TOUT l'Immeuble ","Commentaires"]
[null,null,null,30,"Juin",{"$f":"IF(D7>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},18272,"Conso",59965,"↓",36335,"↓",30472,"↓",1229.471,"M3",{"$f":"SUM(G7:M7)","v":145044},{"$f":"I7+J8+L8+N8+K29","v":60605},"Situation de départ"]
[null,null,null,31,{"$f":"IF(D8>0,\"Juillet\",\"\")","v":"Juillet"},{"$f":"IF(D8>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},18296,{"$f":"IF(G8<>\"\",G8-G7,\"\")","v":24},60100,{"$f":"IF(I8<>\"\",I8-I7,\"\")","v":135},36662,{"$f":"IF(K8<>\"\",K8-K7,\"\")","v":327},30650,{"$f":"IF(M8<>\"\",M8-M7,\"\")","v":178},1279.7819999999999,{"$f":"IF(O8<>\"\",O8-O7,\"\")","v":50.310999999999922},146194,{"$f":"IF(Q8>0,Q8-Q7,\"\")","v":1150}]
[null,null,null,31,{"$f":"IF(D9>0,\"Août\",\"\")","v":"Août"},{"$f":"IF(D9>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},18305,{"$f":"IF(G9<>\"\",G9-G8,\"\")","v":9},60149,{"$f":"IF(I9<>\"\",I9-I8,\"\")","v":49},36861,{"$f":"IF(K9<>\"\",K9-K8,\"\")","v":199},30715,{"$f":"IF(M9<>\"\",M9-M8,\"\")","v":65},1297.3800000000001,{"$f":"IF(O9<>\"\",O9-O8,\"\")","v":17.598000000000184},146287,93]
[null,null,null,30,{"$f":"IF(D10>0,\"Septembre\",\"\")","v":"Septembre"},{"$f":"IF(D10>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},18320,15,60175,26,36981,120,30775,{"$f":"IF(M10<>\"\",M10-M9,\"\")","v":60},1309.04,11.659999999999854,146412,125]
[null,null,null,31,{"$f":"IF(D11>0,\"Octobre\",\"\")","v":"Octobre"},{"$f":"IF(D11>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},18339,19,60202,27,37105,124,30849,74,1323.654,14.614000000000033,146665,253]
[null,null,null,30,{"$f":"IF(D12>0,\"Novembre\",\"\")","v":"Novembre"},{"$f":"IF(D12>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},18360,21,60212,10,37214,109,30920,71,1336,12.346000000000004,146846,181]
[null,null,null,31,{"$f":"IF(D13>0,\"Décembre\",\"\")","v":"Décembre"},{"$f":"IF(D13>0,TEXT([1]Base!$C$9,\"aaaa\"),\"\")","v":"2024"},183.91,-18176.09,null,null,null,"",null,"",null,"",null,""]
[null,null,null,31,{"$f":"IF(D14>0,\"Janvier\",\"\")","v":"Janvier"},{"$f":"IF(D14>0,TEXT([1]Base!$C$11,\"aaaa\"),\"\")","v":"2025"},null,"",null,"",null,"",null,"",null,"",0,""]
[null,null,null,28,{"$f":"IF(D15>0,\"Février\",\"\")","v":"Février"},{"$f":"IF(D15>0,TEXT([1]Base!$C$11,\"aaaa\"),\"\")","v":"2025"},null,"",null,"",null,"",null,"",null,"",0,""]
[null,null,null,31,{"$f":"IF(D16>0,\"Mars\",\"\")","v":"Mars"},{"$f":"IF(D16>0,TEXT([1]Base!$C$11,\"aaaa\"),\"\")","v":"2025"},null,"",null,"",null,"",null,"",null,"",0,""]
[null,null,null,30,{"$f":"IF(D17>0,\"Avril\",\"\")","v":"Avril"},{"$f":"IF(D17>0,TEXT([1]Base!$C$11,\"aaaa\"),\"\")","v":"2025"},null,"",null,"",null,"",null,"",null,"",0,""]
[null,null,null,31,{"$f":"IF(D18>0,\"Mai\",\"\")","v":"Mai"},{"$f":"IF(D18>0,TEXT([1]Base!$C$11,\"aaaa\"),\"\")","v":"2025"},null,"",null,"",null,"",null,"",null,"",0,""]
[null,null,null,30,{"$f":"IF(D19>0,\"Juin\",\"\")","v":"Juin"},{"$f":"IF(D19>0,TEXT([1]Base!$C$11,\"aaaa\"),\"\")","v":"2025"},null,null,null,"",null,"",null,"",null,"",0,""]
[]
[null,null,null,{"$f":"IF(E19<>\"\",\"Consommations Annuelles\",\"\")","v":"Consommations Annuelles"},null,null,{"$f":"G24","v":""},{"$f":"SUM(H8:H19)","v":-18088.09},{"$f":"I24","v":""},{"$f":"SUM(J8:J19)","v":247},{"$f":"K24","v":""},{"$f":"SUM(L8:L19)","v":879},{"$f":"M24","v":""},{"$f":"SUM(N8:N19)","v":448},{"$f":"O24","v":""},{"$f":"SUM(P8:P19)","v":106.529},null,{"$f":"R24","v":1802}]
[null,null,null,null,null,null,null,null,null,null,"Coût de la Consommation électrique générale de tout l'immeuble (sans compteur)",null,null,null,null,null,null,{"$f":"'[1]Cal. kwh '!C23*Relevés!R21","v":435.57435555449098}]
[]
[null,null,null,null,null,null,{"$f":"IF(G19>0,G19-G7,\"\")","v":""},null,{"$f":"IF(I19>0,I19-I7,\"\")","v":""},null,{"$f":"IF(K19>0,K19-K7,\"\")","v":""},null,{"$f":"IF(M19>0,M19-M7,\"\")","v":""},null,{"$f":"IF(O19>0,O19-O7,\"\")","v":""},null,{"$f":"Q19-Q7","v":-145044},{"$f":"SUM(R8:R19)","v":1802}]