{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Feuil1","index":0,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,1,51,2],[50,1,50,2],[21,1,21,2],[22,1,22,2],[48,1,48,2],[49,1,49,2],[32,1,32,2],[27,1,27,2],[28,1,28,2],[47,7,47,8],[0,1,0,9],[5,1,5,2],[5,3,5,8],[6,5,6,6],[10,5,10,7],[2,4,2,5],[3,4,3,5]]}
[null,"Attention : suivre impérativement  les cellules  accessibles afin d'y saisir les données nécessaires."]
[]
[null,"1ere Période du : ","2019-11-19","Au","2019-12-31"]
[null,"2ème Période du : ","2020-01-01",{"$f":"IF(C4<>\"\",D3,\"\")","v":"Au"},"2020-03-31"]
[null,"Electricité"]
[null,"Point de mesure",null,"CH1006601234500000000000000008028"]
[null,"Quantités consommées",null,null,null,"Relevé du"]
[null,null,"Elément","Date du\ndébut","Date de \nfin","Relevé du Départ","Relevé de\nFin","Coefficient","Nb de Mois","Quantité Kwh",null,"Nb de jours"]
[null,null,"Tarif Consommation (1)","2019-11-19","2019-12-31",26313,26438,null,1,{"$f":"G9-F9","v":125},null,{"$f":"E9-D9","v":42},{"$f":"ROUND(L9/30,0)","v":1}]
[null,null,"Tarif Consommation (2)","2020-01-01","2020-03-30",26438,26707,null,{"$f":"TEXT(L10,\"m\")","v":"3"},{"$f":"G10-F10","v":269},null,{"$f":"E10-D10","v":89},{"$f":"ROUND(L10/30,0)","v":3}]
[]
[null,"Calcul des Prix",null,"Quantité","Prix Unitaire\nH.T.","Total H.T",null,"Taux\nTVA",7.7,"Montant\nCHF T.T.C."]
[null,"Electricité"]
[null,"Tarif énergie",null,"Du",{"$f":"$C$3","v":"2019-11-19"},"AU",{"$f":"$E$4","v":"2020-03-31"}]
[null,"Energie",null,null,"PRIX DU KW H.T EN CT.","PRIX TOTAL KW H.T ",null,null,null,"PRIX TTC",null,"TVA"]
[null,"Consommation (1) en kwh",null,{"$f":"G9-F9","v":125},0.59899999999999998,{"$f":"E16*D16/10","v":7.4874999999999998},null,7.7,{"$f":"F16*H16%","v":0.57653749999999993},{"$f":"F16+I16","v":8.0640374999999995},null,{"$f":"G16*$I$12/100","v":0}]
[null,"Consommation (2) en kwh",null,{"$f":"G10-F10","v":269},0.67100000000000004,{"$f":"E17*D17/10","v":18.049900000000001},null,7.7,{"$f":"F17*H17%","v":1.3898423},{"$f":"F17+I17","v":19.439742300000002},null,{"$f":"G17*$I$12/100","v":0}]
[null,null,"Consommation  (1) + (2)",{"$f":"D16+D17","v":394},null,"Nb de jour","Nb de mois",null," H.T."]
[null,"Abonnement (1)",null,{"$f":"TEXT(G19,\"m\")","v":"1"},3.6,30,{"$f":"I9","v":1},{"$f":"H17","v":7.7},{"$f":"E19*G19","v":3.6},{"$f":"I19+L19","v":3.8772000000000002},null,{"$f":"I19*$I$12/100","v":0.2772}]
[null,"Abonnement (2)",null,{"$f":"TEXT(G20,\"m\")","v":"1"},3.6,{"$f":"E20*G20","v":10.8},{"$f":"I10","v":"3"},{"$f":"I12","v":7.7},{"$f":"E20*G20","v":10.8},{"$f":"I20+L20","v":11.631600000000001},null,{"$f":"I20*$I$12/100","v":0.83160000000000012}]
[null,"Sous Total Energie (1) + (2)",null,null,null,null,null,null,null,{"$f":"SUM(J16:J20)","v":43.012579800000005},null,0]
[null,"Acheminement ",null,"Du",{"$f":"$C$3","v":43788},"AU",{"$f":"$E$3","v":43830},null,null,null,null,3374.91]
[]
[null,"Acheminement",null,"Nb kwh","Prix H.T KW","Prix T.T.C KW","TVA","TAUX TVA",null,"PRIX TTC"]
[null,"Consommation (1) en kwh",null,{"$f":"D16","v":125},7.89,{"$f":"E25*D25/100","v":9.8625000000000007},{"$f":"F25*H25%","v":0.75941250000000005},7.7,null,{"$f":"F25+G25","v":10.621912500000001},null,5.8474762500000006E-2]
[null,"Consommation (2) en kwh",null,{"$f":"D17","v":269},8.3000000000000007,{"$f":"E26*D26/100","v":22.327000000000002},{"$f":"F26*H26%","v":1.719179},7.7,null,{"$f":"F26+G26","v":24.046179000000002},null,0.132376783]
[null,null,null,"Nb mois","Prix H.T mois en CHF","Togal Prix H.T. en CHF","Montant TVA","TAUX TVA"]
[null,"Abonnement (1)",null,{"$f":"G19","v":1},6.2,{"$f":"E28*D28","v":6.2},{"$f":"F28*H28%","v":0.47739999999999999},{"$f":"I12","v":7.7},null,{"$f":"F28+G28","v":6.6774000000000004}]
[null,"Abonnement (2)",null,{"$f":"G20","v":"3"},6.31,{"$f":"E29*D29","v":18.93},{"$f":"F29*H29%","v":1.4576099999999999},{"$f":"I12","v":7.7},null,20.387609999999999]
[null,"Total Acheminement (1) + (2)",null,{"$f":"D25+D26","v":394},null,null,null,null,null,{"$f":"SUM(J25:J29)","v":61.733101500000004},null,0]
[null,"Participation collectivités publiques",null,"Du",{"$f":"C3","v":"2019-11-19"},"AU",{"$f":"E4","v":"2020-03-31"}]
[null,"Taxes légales",null,"Kwh","Cts le Kwh",null,"H.T.","% TVA","COUT\n TVA","EN CTS"]
[null,"Emolument cantonal",null,{"$f":"D25","v":125},0.02,null,{"$f":"E33*D33","v":2.5},{"$f":"$I$12","v":7.7},{"$f":"G33*H33%","v":0.1925},{"$f":"G33+I33","v":2.6924999999999999},null,{"$f":"G34*H33%","v":0.41425999999999996}]
[null,"Emolument cantonal",null,{"$f":"D26","v":269},0.02,null,{"$f":"E34*D34","v":5.38},{"$f":"I12","v":7.7},{"$f":"G34*H34%","v":0.41425999999999996},{"$f":"G34+I34","v":5.7942599999999995},null,{"$f":"G34*H34%","v":0.41425999999999996}]
[null,"Taxes cantonale efficacité énergétique",null,{"$f":"D25","v":125},0.18,null,{"$f":"E35*D35","v":22.5},0,0,22.5,null,0]
[null,"Taxes cantonale efficacité énergétique",null,{"$f":"D26","v":269},0.18,null,48.42,0,0,48.42]
[null,"Nyon Emolument sur l'usage du sol",null,{"$f":"D25","v":125},0.7,null,87.5,{"$f":"$I$12","v":7.7},6.7374999999999998,94.237499999999997,null,{"$f":"G37*H37/100","v":6.7374999999999998}]
[null,"Nyon Emolument sur l'usage du sol",null,{"$f":"D26","v":269},0.7,null,188.29999999999998,7.7,14.499099999999999,202.79909999999998]
[null,"Nyon Taxes sur l'éclairage public",null,{"$f":"D25","v":125},0.8,null,100,0,0,100,null,0]
[null,"Nyon Taxes sur l'éclairage public",null,{"$f":"D26","v":269},0.8,null,215.20000000000002,0,0,215.20000000000002]
[null,"Nyon Taxes pour l'énergie renouvlable",null,{"$f":"D25","v":125},0.5,null,62.5,0,0,62.5,null,0]
[null,"Nyon Taxes pour l'énergie renouvlable",null,{"$f":"D26","v":269},0.5,null,134.5,0,0,134.5]
[null,"Nyon Taxes pour le développement durable",null,{"$f":"D25","v":125},0.2,null,{"$f":"E43*D43","v":25},0,0,25,null,0]
[null,"Nyon Taxes pour le développement durable",null,{"$f":"D26","v":269},0.2,null,{"$f":"E44*D44","v":53.800000000000004},0,0,53.800000000000004]
[null,"Taxe Fédérale pour supplément coût transport",null,{"$f":"D25","v":125},2.2999999999999998,null,{"$f":"E45*D45","v":287.5},0,{"$f":"G45*H45%","v":0},287.5,null,0]
[null,"Taxe Fédérale pour supplément coût transport",null,{"$f":"D26","v":269},2.2999999999999998,null,618.69999999999993,0,0,618.69999999999993]
[]
[null,null,null,null,null,null,null,"Total TAXES",null,{"$f":"J49+J50","v":18.111433599999998}]
[null,"Sous Total des Taxes (1)",null,null,null,null,null,null,null,{"$f":"(J33+J35+J37+J39+J43+J45)/(100)","v":5.319300000000001}]
[null,"Sous Total des Taxes (2)",null,null,null,null,null,null,null,{"$f":"(J34+J36+J38+J40+J42+J44+J46)/100","v":12.792133599999998},null,{"$f":"J49+J50","v":18.111433599999998}]
[null,{"$f":"IF(J51>0,\"Acompte\",\"\")","v":"Acompte"},null,null,null,null,null,null,null,10]
[null,{"$f":"IF(J52>0,\"Acompte\",\"\")","v":"Acompte"},null,null,null,null,null,null,null,20,null,{"$f":"J51+J52","v":30}]
[null,"MONTANT FINAL ELECTRICITE ",null,null,"Sous déduction accomptes",null,{"$f":"L52","v":30},null,"CHF",{"$f":"J21+J30+J48-(G53)","v":92.857114899999999}]