{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Tarifs et Surcharges","Prod"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil1","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,10],[13,2,13,3],[14,2,14,3],[15,2,15,3],[22,2,22,3],[16,2,16,3],[19,2,19,3],[20,2,20,3],[21,2,21,3]]}
[]
["Tarif social - Calcul du coût de la consommation annuelle"]
[]
["Tarifs TVAC d'application du 1er octobre au 31 décembre 2023"]
[]
["Choisissez votre type de compteur:",null,null,null,null,null,null,null,null,"Compteur simple - monohoraire",1]
[null,null,null,null,null,null,null,null,null,"Compteur bihoraire",2]
[null,null,null,null,null,null,null,null,null,"Compteur simple + exclusif nuit",3]
[null,null,null,null,null,null,null,null,null,"Compteur bihoraire + exclusif nuit",4]
[]
[]
[{"$f":"IF(J11<>0,\"Introduisez vos consommations annuelles:\",\"\")","v":""}]
[]
[{"$f":"IF(OR(J11=1,J11=3),\"Consommation annuelle:\",\"\")","v":""},null,null,null,{"$f":"IF(OR(J11=1,J11=3),\"  kWh\",\"\")","v":""}]
[{"$f":"IF(OR(J11=2,J11=4),\"Consommation heures pleines (jours de la semaine):\",\"\")","v":""},null,null,null,{"$f":"IF(OR(J11=2,J11=4),\"  kWh\",\"\")","v":""}]
[{"$f":"IF(OR(J11=2,J11=4),\"Consommation heures creuses (nuits et week-ends):\",\"\")","v":""},null,null,null,{"$f":"IF(OR(J11=2,J11=4),\"  kWh\",\"\")","v":""}]
[{"$f":"IF(OR(J11=3,J11=4),\"Consommation en ''exclusif nuit'' :\",\"\")","v":""},null,null,null,{"$f":"IF(OR(J11=3,J11=4),\"  kWh\",\"\")","v":""}]
[]
[]
[{"$f":"IF(J11=1,\"Montant annuel de la facture:\",\"\")","v":""},null,{"$f":"IF(J11=1,C14*'Tarifs et Surcharges'!C19,\"\")","v":""},null,{"$f":"IF(J11=1,\"€\",\"\")","v":""}]
[{"$f":"IF(J11=2,\"Montant annuel de la facture:\",\"\")","v":""},null,{"$f":"IF(J11=2,C15*'Tarifs et Surcharges'!C23+C16*'Tarifs et Surcharges'!C25,\"\")","v":""},null,{"$f":"IF(J11=2,\"€\",\"\")","v":""}]
[{"$f":"IF(J11=3,\"Montant annuel de la facture:\",\"\")","v":""},null,{"$f":"IF(J11=3,C14*'Tarifs et Surcharges'!C19+C17*'Tarifs et Surcharges'!C29,\"\")","v":""},null,{"$f":"IF(J11=3,\"€\",\"\")","v":""}]
[{"$f":"IF(J11=4,\"Montant annuel de la facture:\",\"\")","v":""},null,{"$f":"IF(J11=4,C15*'Tarifs et Surcharges'!C23+Feuil1!C16*'Tarifs et Surcharges'!C25+Feuil1!C17*'Tarifs et Surcharges'!C29,\"\")","v":""},null,{"$f":"IF(J11=4,\"€\",\"\")","v":""}]

{"sheet":"Tarifs et Surcharges","index":1,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Cotisations fédérales et surcharges"]
[null,"c€/kWh","€/kWh","Tarif d'application du ",null,"2023-01-01","au ","2023-03-31"]
["Cotisation fédérale: redevance CREG",0,{"$f":"B3/100","v":0}]
["Cotisation sur l'énergie",0,{"$f":"B4/100","v":0},null,"Taux de TVA à appliquer "]
["Cotis. Féd.: passif dénucléarisation",0,{"$f":"B5/100","v":0}]
["Cotis. Féd.: passif fonds KYOTO",0,0]
["Cotis. Féd.: Surcharge.aide sociale (OSP)",0,0]
["Cotis. Féd.: surcharge clients protégés",0,0]
["Surcharge \"Chauffage\"",0,0]
["Redevance de raccordement",7.4999999999999997E-2,7.5000000000000002E-4]
["Coût certificats verts Offshore",0,0]
[]
["Total",{"$f":"SUM(B3:B12)","v":7.4999999999999997E-2},{"$f":"SUM(C3:C12)","v":7.5000000000000002E-4},null,null,"à remplir !!",null,"HTVA"]
[]
["Tarifs","TVAC",0.06,null,null,"Tarifs","c€/kWh","€/kWh"]
[]
["Tarif normal",null,null,null,null,"Tarif normal"]
["  - monohoraire",{"$f":"C18*100","v":21.568000000000001},0.21568000000000001,null,null,"  - monohoraire",28.579000000000001,{"$f":"G18/100","v":0.28578999999999999}]
["   + cot fed & surch",{"$f":"B18+B13","v":21.643000000000001},{"$f":"C18+C13","v":0.21643000000000001}]
[]
["Tarif bihoraire",null,null,null,null,"Tarif bihoraire"]
["  - jour",{"$f":"C22*100","v":21.878},0.21878,null,null,"  - jour",29.515000000000001,{"$f":"G22/100","v":0.29515000000000002}]
["   + cot fed & surch",{"$f":"B22+B13","v":21.952999999999999},{"$f":"C22+C13","v":0.21953}]
["  - nuit",{"$f":"C24*100","v":21.248000000000001},0.21248,null,null,"  - nuit",23.864999999999998,{"$f":"G24/100","v":0.23864999999999997}]
["   + cot fed & surch",{"$f":"B24+B13","v":21.323},{"$f":"C24+C13","v":0.21323}]
[]
["Tarif exclusif nuit",null,null,null,null,"Tarif exclusif nuit"]
["  - excl nuit",{"$f":"C28*100","v":20.265000000000001},0.20265,null,null,"  - excl nuit",17.396999999999998,{"$f":"G28/100","v":0.17396999999999999}]
["   + cot fed & surch",{"$f":"B28+B13","v":20.34},{"$f":"C28+C13","v":0.2034}]

{"sheet":"Prod","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[1,"Compteur normal - monohoraire"]
[2,"Compteur bihoraire"]
[3,"Compteur simple + exclusif nuit"]
[4,"Compteur bihoraire + exclusif nuit"]