{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Copyright","Données","Base UEM","Option HC bleu","Tempo bleu","COMPAR","Pac","elec","Liste"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":2,"defined_names":16,"comments":3,"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":"Copyright","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Document réalisé par Lombard Franck"]
["Lien donné par juju Sur chaleurTerre,com"]
["Modifié et adapté Par et pour w36xb2w"]
["Le 15 8 2010"]
[]
["Mot de passe W36xb2w"]
[]
["mettre à jour les tarifs dans les feuilles/ base/hc/ tempo"]
[]
["Attention Remettre la véritable taxe communale"]
["remplir la feuille elec les données se mettent a jour"]
["remplir la feuille de données pour Abonnement CTA CSPE TSPE TVA tout le reste ce calcul seul"]

{"sheet":"Données","index":1,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,7],[12,2,12,3],[3,2,3,3]]}
["Attention mettre a jour les valeurs abonnement et prix du kw"]
[]
["Puissance souscrite",null,15]
[null,null,"Hp ou HP HC"]
[null,null,"Ancien","Nouveau"]
["Consommation HP",null,0,{"$f":"E11","v":0},{"$f":"D6-C6","v":0}]
[]
[null,null,null,null,null,"% HP/HC",null,null,null,null,null,null,null,null,"calcul 2012","http://itow.fr/itow/edfbc.php"]
["Consommation HP",null,0,{"$f":"elec!K30","v":0},{"$f":"D9-C9","v":0},{"$f":"E9/E11","v":{"$error":"#DIV/0!"}}]
["Consommation HC",null,0,{"$f":"elec!K31","v":0},{"$f":"D10-C10","v":0},{"$f":"E10/E11","v":{"$error":"#DIV/0!"}}]
["Consommation totale",null,{"$f":"SUM(C9:C10)","v":0},{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0},{"$f":"F10+F9","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"TEMPO"]
[null,null,null,"Nouveau","Somme"]
["HC",null,0,{"$f":"E11*F15","v":0},{"$f":"D15-C15","v":0},0.31]
["HP",null,0,{"$f":"E11*F16","v":0},0,0.56000000000000005,{"$f":"F16+F15","v":0.87000000000000011}]
["HC",null,0,{"$f":"E11*F17","v":0},0,0.04]
["HP",null,0,{"$f":"E6*F18","v":0},0,0.06,{"$f":"F18+F17","v":0.1}]
["HC",null,0,{"$f":"E6*F19","v":0},0,0.02]
["HP",null,0,{"$f":"E6*F20","v":0},0,0.01,{"$f":"F20+F19","v":0.03}]
[null,null,null,null,{"$f":"SUM(E15:E20)","v":0},{"$f":"SUM(F15:F20)","v":1.0000000000000002}]
[]
[]
[]
[null,null,"Période en mois"]
["Abonnement",null,12]
[null,null,"Taux TVA"]
["Abonnement","Tva réduite",5.5E-2]
["Consommation","Tva normale",0.2]
["Autres prestations","Tva normale",0.2]
[]
[]
[]
[]
[]
["Autres prestations",{"$f":"NOW()","v":"2018-10-04T11:01:15.590"}]
["CSPE",1.95E-2]
["TSPE",2.2499999999999999E-2]
["Taxe departementale",3.1900000000000001E-3]
["Taxe Communale",0]
["Assiette",0.8]
[]
[null,null,null,3.2000000000000001E-2]
[]
[null,null,"Ps KVA","Composante Gestion a1","Soutirage a2","composante comptage",null,"TURPE annuel","TURPE MOIS","CTA/mois","CTA annuel"]
[null,null,null,null,null,null,null,null,null,null,0.27039999999999997]
[null,null,3,9.02,3.6,24,null,{"$f":"IF(Puissance_souscrite=C47,D47+F47+(C47*E47),0)","v":0},{"$f":"H47/12","v":0},{"$f":"IF(I47*K$46=0,\" \",I47*K$46)","v":" "},{"$f":"K$46*H47","v":0}]
[null,null,6,{"$f":"D47","v":9.02},3.6,24,null,{"$f":"IF(Puissance_souscrite=C48,D48+F48+(C48*E48),0)","v":0},{"$f":"H48/12","v":0}," ",0]
[null,null,9,9.02,3.6,24,null,{"$f":"IF(Puissance_souscrite=C49,D49+F49+(C49*E49),0)","v":0},0," ",0]
[null,null,12,{"$f":"D49","v":9.02},7.2,{"$f":"F49","v":24},null,0,0," ",0]
[null,null,15,9.02,{"$f":"E50","v":7.2},{"$f":"F50","v":24},null,{"$f":"IF(Puissance_souscrite=C51,D51+F51+(C51*E51),0)","v":141.01999999999998},{"$f":"H51/12","v":11.751666666666665},{"$f":"IF(I51*K$46=0,\" \",I51*K$46)","v":3.1776506666666657},{"$f":"K$46*H51","v":38.131807999999992}]
[null,null,18,9.02,{"$f":"E51","v":7.2},{"$f":"F51","v":24},null,0,0," ",0]
[null,null,null,null,null,null,null,{"$f":"MAX(H47:H52)","v":141.01999999999998},{"$f":"MAX(I47:I52)","v":11.751666666666665},{"$f":"I53*K$46","v":3.1776506666666657},{"$f":"ROUND(MAX(K47:K52),2)","v":38.130000000000003}]
[null,null,null,null,null,"http://www.cre.fr/calculatrice/simple"]

{"sheet":"Base UEM","index":2,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,3,0,5],[31,1,31,2],[3,2,3,3],[64,2,64,3],[60,2,60,3],[56,2,56,3],[3,1,4,1],[33,1,33,2]]}
[null,null,null,"Option BASE"]
["Puissance souscrite",{"$f":"Données!C3","v":15}]
[]
[null,"Puissance souscrite","Option base HT/mois"]
[null,null,"Abonnement","Prix du kWh"]
[null,3,{"$f":"A59/12","v":3.8941666666666666},{"$f":"D59","v":0.13042000000000001}]
[null,6,{"$f":"A63/12","v":6.7016666666666671},{"$f":"D63","v":0.12083000000000002}]
[null,9,{"$f":"A67/12","v":7.7333333333333334},{"$f":"D67","v":0.12192}]
[null,12,{"$f":"A71/12","v":11.995833333333332},{"$f":"D8","v":0.12192}]
[null,15,{"$f":"A75/12","v":13.860833333333334},0.12192]
[null,18,{"$f":"A79/12","v":15.872222222222222},0.12192]
[]
[]
[]
[null,null,{"$f":"TRUNC(VLOOKUP($B2,$B6:$G14,2),2)","v":13.86},{"$f":"TRUNC(VLOOKUP($B2,$B6:$G14,3),4)","v":0.12189999999999999}]
[]
[]
[]
[]
["Des taxes municipales au taux de 8% et des taxes départementales au taux de 4% basées sur 80% du montant HT "]
[]
[]
[null,null,null,{"$f":"D21","v":0}]
[]
[null,"Ancien","Nouveau","Différence","Consommation en kWh","Prix du kWh ht","Prix HT"]
["Consommation",{"$f":"Données!C6","v":0},{"$f":"Données!D6","v":0},{"$f":"C26-B26","v":0},{"$f":"D26","v":0},{"$f":"D15","v":0.12189999999999999},{"$f":"F26*E26","v":0}]
[]
[]
[]
[]
[]
[null,"Période en mois",null,null,null,"Coût de l'abonnement","Cout annuel"]
[null,null,null,null,null," / mois"]
["Abonnement",{"$f":"Données!C26","v":12},null,null,null,{"$f":"C15","v":13.86},{"$f":"F34*B34","v":166.32}]
[]
[null,null,null,null,null,"Total HT",{"$f":"G26+G34","v":166.32}]
[]
[null,null,"Kw","Montant HT","Valeur"]
["Taxe départementale",null,{"$f":"Données!$D$6","v":0},null,{"$f":"C39*Données!B39","v":0}]
["Taxe communale",null,{"$f":"C39","v":0},null,{"$f":"D40*Données!B40","v":0}]
[{"$f":"Données!A37","v":"CSPE"},null,{"$f":"C40","v":0},null,{"$f":"C41*Données!B37","v":0}]
[{"$f":"Données!A38","v":"TSPE"},null,{"$f":"C41","v":0},null,{"$f":"C42*Données!B38","v":0}]
["CTA",null,null,{"$f":"Données!H53","v":141.01999999999998},{"$f":"D43*Données!K46","v":38.131807999999992}]
["TVA réduite",null,null,{"$f":"G34+((G34*Données!B41)*Données!C39)+E43","v":204.45180799999997},{"$f":"D44*Données!C28","v":11.244849439999998}]
["TVA",null,null,{"$f":"SUM(E39:E42)-D44+G36","v":-38.131807999999978},{"$f":"D45*Données!C29","v":-7.6263615999999956}]
[]
[null,null,null,{"$f":"G36","v":166.32},{"$f":"SUM(E39:E45)","v":41.750295839999993},"Total TTC",{"$f":"SUM(D47:E47)","v":208.07029583999997}]
[null,null,null,null,null,"Prix du Kwh Net",{"$f":"G47/D26","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["Calcul Abonnement                     de TTC vers HT",3,"Calcul KWh                       de TTC vers HT"]
[{"$f":"B58","v":56.075999999999993},{"$f":"B59*(1+Données!C$29)","v":56.075999999999993},"TTC",{"$f":"E58","v":0.156504},{"$f":"E59*(1+Données!C29)","v":0.156504}]
[{"$f":"A58/(1+Données!C$29)","v":46.73},46.73,"HT",{"$f":"D58/(1+Données!C$29)","v":0.13042000000000001},0.13042000000000001]
[]
["Calcul Abonnement                     de TTC vers HT",6,"Calcul KWh                       de TTC vers HT"]
[{"$f":"B62","v":96.504000000000005},{"$f":"B63*(1+Données!C$29)","v":96.504000000000005},"TTC",{"$f":"E62","v":0.14499600000000001},{"$f":"E63*(1+Données!C$29)","v":0.14499600000000001}]
[{"$f":"A62/(1+Données!C$29)","v":80.42},80.42,"HT",{"$f":"D62/(1+Données!C$29)","v":0.12083000000000002},0.12083000000000001]
[]
["Calcul Abonnement                     de TTC vers HT",9,"Calcul KWh                       de TTC vers HT"]
[{"$f":"B66","v":111.36},{"$f":"B67*(1+Données!C29)","v":111.36},"TTC",{"$f":"E66","v":0.14630399999999999},{"$f":"E67*(1+Données!C$29)","v":0.14630399999999999}]
[{"$f":"A66/(1+Données!C$29)","v":92.8},92.8,"HT",{"$f":"D66/(1+Données!C$29)","v":0.12192},0.12192]
[]
["Calcul Abonnement                     de TTC vers HT",12]
[{"$f":"B70","v":172.73999999999998},{"$f":"B71*(1+Données!C29)","v":172.73999999999998}]
[{"$f":"A70/(1+Données!C$29)","v":143.94999999999999},143.94999999999999]
[]
["Calcul Abonnement                     de TTC vers HT",15]
[{"$f":"B74","v":199.596},{"$f":"B75*(1+Données!C29)","v":199.596}]
[{"$f":"A74/(1+Données!C$29)","v":166.33},166.33]
[]
["Calcul Abonnement                     de TTC vers HT",18]
[228.56,{"$f":"B79*(1+Données!C$29)","v":228.56399999999999}]
[{"$f":"A78/(1+Données!C$29)","v":190.46666666666667},190.47]

{"sheet":"Option HC bleu","index":3,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[56,2,56,3],[60,2,60,3],[0,3,0,5],[3,1,4,1],[35,4,35,5],[33,1,33,2],[31,1,32,2],[3,4,3,6]]}
[null,null,null,"Option H.C"]
["Puissance souscrite",{"$f":"Données!C3","v":15}]
[]
[null,"Puissance souscrite",null,null,"Option Heures Creuses"]
[null,null,null,"Abonnement annuel","Abonnement mois","Prix du kWh HC","Prix du kWh HP"]
[null,3]
[null,6,null,{"$f":"E7*12","v":83.76},{"$f":"A59/12","v":6.98},{"$f":"D63","v":0.10596},{"$f":"D59","v":0.13}]
[null,9,null,97.924999999999997,{"$f":"A63/12","v":8.1604166666666664},{"$f":"F7","v":0.10596},{"$f":"G7","v":0.13}]
[null,12,null,152.71,{"$f":"A67/12","v":12.725833333333334},{"$f":"F8","v":0.10596},0.13]
[null,15,null,176.72,{"$f":"A71/12","v":14.726666666666667},0.10596,0.13]
[null,18,null,199.86,{"$f":"A75/12","v":16.655000000000001},0.10596,0.13]
[]
[]
[]
[null,null,null,null,{"$f":"TRUNC(VLOOKUP($B2,$B6:$G14,4),2)","v":14.72},{"$f":"TRUNC(VLOOKUP($B2,$B6:$G14,5),4)","v":0.10589999999999999},{"$f":"TRUNC(VLOOKUP($B2,$B6:$G14,6),4)","v":0.13}]
[]
[]
[]
[]
["Des taxes municipales au taux de 8% et des taxes départementales au taux de 4% basées sur 80% du montant HT "]
[]
[]
[]
[]
[null,"Ancien","Nouveau","Différence","Consommation en kWh","Prix du kWh","Prix HT"]
["Consommation HP",{"$f":"Données!C9","v":0},{"$f":"Données!E9","v":0},{"$f":"C26-B26","v":0},{"$f":"D26","v":0},{"$f":"G15","v":0.13},{"$f":"F26*E26","v":0}]
["Consommation HC",{"$f":"Données!C10","v":0},{"$f":"Données!E10","v":0},{"$f":"C27-B27","v":0},{"$f":"D27","v":0},{"$f":"F15","v":0.10589999999999999},{"$f":"F27*E27","v":0}]
["Somme",null,null,{"$f":"D27+D26","v":0},null,null,{"$f":"G27+G26","v":0},"ok"]
[]
[]
[]
[null,"Période en mois ",null,null,null,"Coût de l'abonnement"]
[null,null,null,null,null," / mois"]
["Abonnement",{"$f":"'Base UEM'!B34:C34","v":12},null,null,null,{"$f":"E15","v":14.72},{"$f":"F34*B34","v":176.64000000000001},"ok"]
[]
[null,null,null,null,"Total HT",null,{"$f":"SUM(G28:G34)","v":176.64000000000001},"ok"]
[]
[null,null,"Kw","Montant HT","Valeur"]
["Taxe départementale",null,{"$f":"Données!E11","v":0},null,{"$f":"C39*Données!B39","v":0}]
["Taxe communale",null,{"$f":"C39","v":0},null,{"$f":"C40*Données!B40","v":0}]
[{"$f":"Données!A37","v":"CSPE"},null,{"$f":"C40","v":0},null,{"$f":"C41*Données!B37","v":0},"OK"]
[null,null,{"$f":"C41","v":0},null,{"$f":"C42*Données!B38","v":0},"OK"]
[{"$f":"Données!K45","v":"CTA annuel"},null,null,{"$f":"Données!H53","v":141.01999999999998},{"$f":"D43*Données!K46","v":38.131807999999992},"OK"]
["TVA réduite",null,null,{"$f":"G34+((G34*Données!B41)*Données!C39)+E43","v":214.77180800000002},{"$f":"D44*Données!C28","v":11.812449440000002},"OK"]
["TVA",null,null,{"$f":"SUM(E39:E43)+G36-D44","v":0},{"$f":"D45*Données!C30","v":0},"OK"]
[]
[null,null,null,{"$f":"G36","v":176.64000000000001},{"$f":"SUM(E39:E45)","v":49.944257439999994},"Total TTC",{"$f":"SUM(D47:E47)","v":226.58425744000002}]
[null,null,null,null,null,"Prix du Kwh Net",{"$f":"G47/D28","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["Calcul Abonnement                     de TTC vers HT",6,"Calcul KWh   HP                  de TTC vers HT"]
[{"$f":"B58","v":100.512},{"$f":"B59*(1+Données!C$29)","v":100.512},"TTC",{"$f":"E58","v":0.156},{"$f":"E59*(1+Données!C$29)","v":0.156}]
[{"$f":"A58/(1+Données!C$29)","v":83.76},83.76,"HT",{"$f":"D58/(1+Données!C29)","v":0.13},0.13]
[]
["Calcul Abonnement                     de TTC vers HT",9,"Calcul KWh       HC              de TTC vers HT"]
[{"$f":"B62","v":117.50999999999999},{"$f":"B63*(1+Données!C$29)","v":117.50999999999999},"TTC",{"$f":"E62","v":0.12715199999999999},{"$f":"E63*(1+Données!C$29)","v":0.12715199999999999}]
[{"$f":"A62/(1+Données!C$29)","v":97.924999999999997},97.924999999999997,"HT",{"$f":"D62/(1+Données!C29)","v":0.10596},0.10596]
[]
["Calcul Abonnement                     de TTC vers HT",12]
[{"$f":"B66","v":183.25200000000001},{"$f":"B67*(1+Données!C$29)","v":183.25200000000001}]
[{"$f":"A66/(1+Données!C$29)","v":152.71},152.71]
[]
["Calcul Abonnement                     de TTC vers HT",15]
[{"$f":"B70","v":212.06399999999999},{"$f":"B71*(1+Données!C$29)","v":212.06399999999999}]
[{"$f":"A70/(1+Données!C$29)","v":176.72},176.72]
[]
["Calcul Abonnement                     de TTC vers HT",18]
[{"$f":"B74","v":239.83199999999999},{"$f":"B75*(1+Données!C$29)","v":239.83199999999999}]
[{"$f":"A74/(1+Données!C$29)","v":199.86},199.86]

{"sheet":"Tempo bleu","index":4,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[[70,2,70,3],[74,2,74,3],[66,2,66,3],[3,7,3,8],[3,2,4,2],[54,2,54,3],[58,2,58,3],[62,2,62,3],[35,4,35,5],[3,1,4,1],[31,1,32,2],[33,1,33,2],[0,3,0,6],[3,3,3,4],[3,5,3,6]]}
[null,null,null,"Option tempo"]
["Puissance souscrite",{"$f":"Données!C3","v":15}]
[]
[null,"Puissance souscrite","Abonnement","Jours bleus",null,"Jours blancs",null,"Jours rouges"]
[null,null,null,"HC","HP","HC","HP","HC","HP"]
[null,9,{"$f":"A57/12","v":8.0724999999999998},{"$f":"D61","v":8.9599999999999999E-2},{"$f":"D57","v":0.1065},{"$f":"D69","v":0.1167},{"$f":"D65","v":0.13950000000000001},{"$f":"D77","v":0.18010000000000001},{"$f":"D73","v":0.42716999999999999}]
[null,12,{"$f":"A61/12","v":12.638333333333334},{"$f":"D6","v":8.9599999999999999E-2},0.1065,0.1167,0.13950000000000001,0.18010000000000001,0.42716999999999999]
[null,15,{"$f":"A65/12","v":14.585833333333333},8.9599999999999999E-2,0.1065,0.1167,0.13950000000000001,0.18010000000000001,0.42716999999999999]
[null,18,{"$f":"A69/12","v":16.461666666666666},8.9599999999999999E-2,0.1065,0.1167,0.13950000000000001,0.18010000000000001,0.42716999999999999]
[]
[]
[]
[null,null,{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,2),4)","v":14.585800000000001},{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,3),4)","v":8.9599999999999999E-2},{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,4),4)","v":0.1065},{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,5),4)","v":0.1167},{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,6),4)","v":0.13950000000000001},{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,7),4)","v":0.18010000000000001},{"$f":"TRUNC(VLOOKUP($B2,$B6:$I12,8),4)","v":0.42709999999999998}]
[]
[]
["Bleu",{"$f":"C25-B25+C26-B26","v":0},{"$f":"Données!B37","v":1.95E-2},{"$f":"B16*C16","v":0},null,"HT","TTC"]
["Blanc",{"$f":"C27-B27+C28-B28","v":0},{"$f":"Données!B$37","v":1.95E-2},{"$f":"B17*C17","v":0},null,{"$f":"SUM(D16:D18)","v":0},{"$f":"(F17*B44)+F17","v":0}]
["Rouge",{"$f":"C29-B29+C30-B30","v":0},{"$f":"Données!B$37","v":1.95E-2},{"$f":"B18*C18","v":0}]
[null,{"$f":"SUM(B16:B18)","v":0}]
["Des taxes municipales au taux de 8% et des taxes départementales au taux de 4% basées sur 80% du montant HT "]
[]
[null,{"$f":"B21+C21","v":0},null,{"$f":"D21","v":0}]
[]
[null,"Ancien","Nouveau","Différence","Consommation en kWh","Prix du kWh en €","Prix HT en €"]
["Bleu HC",0,{"$f":"Données!E15","v":0},{"$f":"C25-B25","v":0},{"$f":"D25","v":0},{"$f":"D13","v":8.9599999999999999E-2},{"$f":"F25*E25","v":0}]
["Bleu HP",{"$f":"Données!C16","v":0},{"$f":"Données!E16","v":0},0,0,{"$f":"E13","v":0.1065},0]
["Blanc HC",{"$f":"Données!C17","v":0},{"$f":"Données!E17","v":0},0,0,{"$f":"F13","v":0.1167},0]
["Blanc HP",{"$f":"Données!C18","v":0},{"$f":"Données!E18","v":0},0,0,{"$f":"G13","v":0.13950000000000001},0]
["Rouge HC",{"$f":"Données!C19","v":0},{"$f":"Données!E19","v":0},0,0,{"$f":"H13","v":0.18010000000000001},0]
["Rouge HP",{"$f":"Données!C20","v":0},{"$f":"Données!E20","v":0},0,0,{"$f":"I13","v":0.42709999999999998},0]
["Somme",null,"²",{"$f":"SUM(D25:D30)","v":0},0,null,{"$f":"SUM(G25:G30)","v":0}]
[null,"Période en mois",null,null,null,"Coût de l'abonnement"]
[null,null,null,null,null," / mois en €"]
["Abonnement",{"$f":"'Option HC bleu'!B34:C34","v":12},null,null,null,{"$f":"C13","v":14.585800000000001},{"$f":"F34*B34","v":175.02960000000002}]
[]
[null,null,null,null,"Total HT",null,{"$f":"SUM(G31:G34)","v":175.02960000000002}]
[]
[null,null,"Kw","Montant HT","Valeur"]
["Taxe départementale",null,{"$f":"Données!$D$6","v":0},null,{"$f":"C39*Données!B39","v":0}]
["Taxe communale",null,{"$f":"C39","v":0},null,{"$f":"D40*Données!B40","v":0}]
[{"$f":"Données!A37","v":"CSPE"},null,{"$f":"C40","v":0},null,{"$f":"C41*Données!B37","v":0}]
[{"$f":"Données!A38","v":"TSPE"},null,{"$f":"C41","v":0},null,{"$f":"C42*Données!B38","v":0}]
[{"$f":"'Base UEM'!A43","v":"CTA"},null,null,{"$f":"Données!H53","v":141.01999999999998},{"$f":"D43*Données!K46","v":38.131807999999992}]
["TVA réduite",null,null,{"$f":"G34+((G34*Données!B41)*Données!C39)+E43","v":213.16140799999999},{"$f":"D44*Données!C28","v":11.723877439999999}]
["TVA",null,null,{"$f":"G36+SUM(E39:E42)-D44","v":-38.131807999999978},{"$f":"D45*Données!C30","v":-7.6263615999999956}]
[]
[null,null,null,{"$f":"G36","v":175.02960000000002},{"$f":"SUM(E39:E45)","v":42.229323839999992},"Total TTC",{"$f":"E47+D47","v":217.25892384000002}]
[null,null,null,null,"Prix du Kwh Net",null,{"$f":"G47/E31","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
["Calcul Abonnement                     de TTC vers HT",9,"Calcul KWh   HP                  de TTC vers HT"]
[{"$f":"B56","v":116.244},{"$f":"B57*(1+Données!C$29)","v":116.244},"TTC",{"$f":"E56","v":0.1278},{"$f":"E57*(1+Données!C$29)","v":0.1278}]
[{"$f":"A56/(1+Données!C$29)","v":96.87},96.87,"HT",{"$f":"D56/(1+Données!C$29)","v":0.1065},0.1065]
[]
["Calcul Abonnement                     de TTC vers HT",12,"Calcul KWh       HC              de TTC vers HT"]
[{"$f":"B60","v":181.99199999999999},{"$f":"B61*(1+Données!C$29)","v":181.99199999999999},"TTC",{"$f":"E60","v":0.10751999999999999},{"$f":"E61*(1+Données!C$29)","v":0.10751999999999999}]
[{"$f":"A60/(1+Données!C$29)","v":151.66},151.66,"HT",{"$f":"D60/(1+Données!C$29)","v":8.9599999999999999E-2},8.9599999999999999E-2]
[]
["Calcul Abonnement                     de TTC vers HT",15,"Calcul KWh   HP                  de TTC vers HT"]
[{"$f":"B64","v":210.036},{"$f":"B65*(1+Données!C$29)","v":210.036},"TTC",{"$f":"E64","v":0.16740000000000002},{"$f":"E65*(1+Données!C$29)","v":0.16740000000000002}]
[{"$f":"A64/(1+Données!C$29)","v":175.03},175.03,"HT",{"$f":"D64/(1+Données!C$29)","v":0.13950000000000001},0.13950000000000001]
[]
["Calcul Abonnement                     de TTC vers HT",18,"Calcul KWh       HC              de TTC vers HT"]
[{"$f":"B68","v":237.04799999999997},{"$f":"B69*(1+Données!C$29)","v":237.04799999999997},"TTC",{"$f":"E68","v":0.14004},{"$f":"E69*(1+Données!C$29)","v":0.14004}]
[{"$f":"A68/(1+Données!C$29)","v":197.54},197.54,"HT",{"$f":"D68/(1+Données!C$29)","v":0.1167},0.1167]
[]
["Calcul Abonnement                     de TTC vers HT",24,"Calcul KWh   HP                  de TTC vers HT"]
[{"$f":"B72","v":581.60400000000004},{"$f":"B73*(1+Données!C$29)","v":581.60400000000004},"TTC",{"$f":"E72","v":0.51260399999999995},{"$f":"E73*(1+Données!C$29)","v":0.51260399999999995}]
[{"$f":"A72/(1+Données!C$29)","v":484.67000000000007},484.67,"HT",{"$f":"D72/(1+Données!C$29)","v":0.42716999999999999},0.42716999999999999]
[]
["Calcul Abonnement                     de TTC vers HT",30,"Calcul KWh       HC              de TTC vers HT"]
[{"$f":"B76","v":605.42399999999998},{"$f":"B77*(1+Données!C$29)","v":605.42399999999998},"TTC",{"$f":"E76","v":0.21612000000000001},{"$f":"E77*(1+Données!C$29)","v":0.21612000000000001}]
[{"$f":"A76/(1+Données!C$29)","v":504.52},504.52,"HT",{"$f":"D76/(1+Données!C$29)","v":0.18010000000000001},0.18010000000000001]
[]
["Calcul Abonnement                     de TTC vers HT",36]
[{"$f":"B80","v":710.66399999999999},{"$f":"B81*(1+Données!C$29)","v":710.66399999999999}]
[{"$f":"A80/(1+Données!C$29)","v":592.22},592.22]

{"sheet":"COMPAR","index":5,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[[44,13,44,14],[44,15,44,16],[0,9,1,9],[0,0,0,6],[44,10,44,12],[39,10,39,12],[27,0,28,3],[31,0,32,5],[34,0,35,4]]}
["COMPARAISON TARIF UEM",null,null,null,null,null,null,107,"m2",108,"http://itow.fr/itow/edfbc.php"]
[]
[]
[null,"Réglage "]
["Mois",{"$f":"Données!C26","v":12},null,null,"Ancien relevé ",null,"Nouveau relevé",null,"PRIX TTC "]
["Puissance KW",{"$f":"Données!C3","v":15}]
[]
[]
[null,"Bleu ",{"$f":"Données!G16","v":0.87000000000000011},"HC",{"$f":"'Tempo bleu'!B25","v":0},{"$f":"(G9-E9)/$G$15","v":{"$error":"#DIV/0!"}},{"$f":"'Tempo bleu'!C25","v":0}]
[null,null,null,"HP",{"$f":"'Tempo bleu'!B26","v":0},{"$error":"#DIV/0!"},{"$f":"'Tempo bleu'!C26","v":0}]
["TEMPO","Blanc",{"$f":"Données!G18","v":0.1},"HC",{"$f":"'Tempo bleu'!B27","v":0},{"$error":"#DIV/0!"},{"$f":"'Tempo bleu'!C27","v":0}]
[null,null,null,"HP",{"$f":"'Tempo bleu'!B28","v":0},{"$error":"#DIV/0!"},{"$f":"'Tempo bleu'!C28","v":0}]
[null,"Rouge ",{"$f":"Données!G20","v":0.03},"HC",{"$f":"'Tempo bleu'!B29","v":0},{"$error":"#DIV/0!"},{"$f":"'Tempo bleu'!C29","v":0}]
[null,null,null,"HP",{"$f":"'Tempo bleu'!B30","v":0},{"$error":"#DIV/0!"},{"$f":"'Tempo bleu'!C30","v":0}]
[null,null,null,null,null,"Somme",{"$f":"SUM('Tempo bleu'!E31)","v":0}]
[null,null,null,"Autres énergie pour chauffage équivalent",null,null,null,{"$f":"IF(I16=\"non\",0,F35*G35/365*30)","v":0},"non","jours"]
[null,null,null,"Total Chauffage et équivalent",null,null,null,null,{"$f":"'Tempo bleu'!G47","v":217.25892384000002},{"$f":"I17+H16","v":217.25892384000002}]
[null,null,null,null,null,null,"Prix du Kwh Net",null,{"$f":"I17/G15","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"Autres énergie pour chauffage équivalent",null,null,null,{"$f":"H16","v":0},null,{"$f":"J16","v":"jours"}]
[null,null,null,"HC",{"$f":"'Option HC bleu'!B27","v":0},{"$f":"G22/G24","v":{"$error":"#DIV/0!"}},{"$f":"'Option HC bleu'!C27","v":0},null,{"$f":"'Option HC bleu'!G47+H21","v":226.58425744000002},{"$f":"H21+I22","v":226.58425744000002},{"$f":"I22-I17","v":9.3253335999999933}]
["OPTION HC",null,null,"HP",{"$f":"'Option HC bleu'!B26","v":0},{"$f":"G23/G24","v":{"$error":"#DIV/0!"}},{"$f":"'Option HC bleu'!C26","v":0}]
[null,null,null,null,null,{"$f":"F15","v":"Somme"},{"$f":"'Option HC bleu'!D28","v":0}]
[null,null,null,null,null,null,"Prix du Kwh Net",null,{"$f":"I22/G24","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Autres énergie pour chauffage équivalent",null,null,null,{"$f":"H16","v":0},null,{"$f":"J21","v":"jours"}]
["BASE UEM 2012 107M2 Chauffés ECS 300 L 2 personnes tarif 15 Kva",null,null,null,{"$f":"'Base UEM'!B26","v":0},null,{"$f":"'Base UEM'!C26","v":0},null,{"$f":"'Base UEM'!G47+H27","v":208.07029583999997},{"$f":"I28+H27","v":208.07029583999997},{"$f":"I28-I17","v":-9.1886280000000511}]
[null,null,null,null,null,null,"Prix du Kwh Net",null,{"$f":"I28/G28","v":{"$error":"#DIV/0!"}}]
[]
[]
["Tout électrique tarif 18 Kw HC moyennes 1981 à 1998 60 m2 chauffés ECS 150 L 4 personnes",null,null,null,null,null,{"$f":"12330+4438","v":16768},null,3537,null,{"$f":"I32-I22","v":3310.4157425600001}]
[null,null,null,null,null,null,{"$f":"G29","v":"Prix du Kwh Net"},null,{"$f":"I32/G32","v":0.2109375}]
[]
["Fioul et Electricité années 1998 a 2008 tarif 12 Kva                 74 m2 chauffés 2 personnes",null,null,null,null,2348,0.92720000000000002,null,{"$f":"G35*F35","v":2177.0655999999999},null,{"$f":"I35-I17","v":1959.8066761599998}]
[null,null,null,null,null,null,null,4438,1053.82]
[null,null,null,null,null,null,null,null,{"$f":"I36+I35","v":3230.8855999999996},null,{"$f":"I37-I17","v":3013.6266761599995}]
[null,null,null,null,null,null,{"$f":"G33","v":"Prix du Kwh Net"},null,{"$f":"I36/H36","v":0.23745380802163135}]
[]
[null,null,null,null,null,null,null,null,null,null,"Electricité année en cours"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I32-I22","v":3310.4157425600001},{"$f":"K41/K43*L43","v":4082.8460824906665},{"$f":"K41/K43*M43","v":5903.5747408986672}]
[null,null,null,null,null,null,null,null,null,null,"http://www.developpement-durable.gouv.fr/energie/petrole/se_resul_fr.php"]
[null,null,null,null,null,null,null,null,null,null,60,74,{"$f":"H1","v":107}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I37-I22","v":3004.3013425599997},{"$f":"K44/K43*L43","v":3705.3049891573328},{"$f":"K44/K43*M43","v":5357.6707275653325}]
[null,null,null,null,null,null,null,null,null,null,"Fioul cumul",null,null,"moyenne",null,"Cout PAC",null,"Facture UEM"]
[null,null,null,null,null,"GAIN HP",null,2008,1,null,1204.0999999999999,{"$f":"K46/K$41*L$41","v":1485.0566666666664},{"$f":"K46/$L$43*$M$43","v":1741.0635135135133},{"$f":"AVERAGE(K46:M46)","v":1476.7400600600597},{"$f":"N46","v":1476.7400600600597},2749,{"$f":"Q46+Q47","v":0}]
[null,null,null,null,null,"GAIN HC",null,2009,2,null,832.47,1026.713,1203.7066216216215,1020.9632072072072,{"$f":"N47+O46","v":2497.7032672672667},2749,{"$f":"P46+P47","v":5498},1612.53]
[null,null,null,null,null,"GAIN HC",null,2010,3,null,1142.0999999999999,1408.5899999999997,1651.4148648648647,1400.7016216216216,{"$f":"N48+O47","v":3898.4048888888883},2749,{"$f":"Q47+P47","v":8247},1080.74]
[null,null,null,null,null,"GAIN HC",null,2011,4,null,2055.92,2535.6346666666668,2972.7491891891891,2521.434618618619,6419.8395075075077,2749,10996,981.98]
[null,null,null,null,null,"Fin amortissement réel 107 m2",null,2012,5,null,1922.11,2370.6023333333333,2779.2671621621616,2357.326498498498,8777.1660060060058,2749,13745,1197.6600000000001]
[null,null,null,null,null,"Fin amortissement prévu 74 m2",null,2013,6,null,1750.93,2159.4803333333334,2531.7501351351352,2147.3868228228225,10924.552828828828,2749,16494,1225]
[null,null,null,null,null,null,null,2014,7,null,1784.08,2200.3653333333327,2579.6832432432429,2188.0428588588584,13112.595687687686,2749,19243,1267.94]
[null,null,null,null,null,"Fin amortissement prévu 60 m2",null,2015,8,null,1809.4,2231.5933333333332,2616.2945945945949,{"$f":"AVERAGE(K53:M53)","v":2219.0959759759758},15331.691663663662,2749,21992,1320]
[null,null,null,null,null,null,null,2016,9,null,1916.43,2363.5970000000002,2771.0541891891889,2350.3603963963965,17682.052060060058,2749,24741]
[null,null,null,null,null,null,null,2017,10,null,null,0,0,0,17682.052060060058,2749,27490]
[null,null,null,null,null,null,null,2018,11,null,null,{"$f":"K56/K$41*L$41","v":0},{"$f":"K56/$L$43*$M$43","v":0},0,17682.052060060058,2749,30239]
[null,null,null,null,null,null,null,2019,12,null,null,0,0,0,17682.052060060058,2749,32988]
[null,null,null,null,null,null,"GAIN TOTAL",null,null,null,{"$f":"SUM(K46:K57)","v":14417.539999999999},{"$f":"SUM(L46:L57)","v":17781.632666666665},{"$f":"SUM(M46:M57)","v":20846.983513513511},{"$f":"AVERAGE(K58:M58)","v":17682.052060060058},null,{"$f":"SUM(P46:P57)","v":32988},null,{"$f":"SUM(R46:R57)","v":8685.85}]
[null,null,null,null,null,null,"Achat",null,null,null,null,null,null,null,null,21000]
[null,null,null,null,null,null,"Prime UEM et Etat",null,null,null,null,null,null,null,null,9300]
[null,null,null,null,null,null,"Cout net PAC",null,null,null,null,null,null,null,null,{"$f":"P59-P60","v":11700}]

{"sheet":"Pac","index":6,"n_rows":124,"n_cols":36,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année",2012]
[null,"ANNEES",2012,{"$f":"C2+1","v":2013},2014,2015,2016,2017,2018,2019,2020,"TOTAL","CUMUL Hp/HC","MOYENNE","Kw/j","Somme Kw/j",null,null,null,"Mois",8]
["MOIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour",29,{"$f":"IF(AND(ISNUMBER(U1),ISNUMBER(U2),ISNUMBER(U3)),\" \" & CHOOSE(WEEKDAY(DATE(U1,U2,U3),1),\"DIMANCHE\",\"LUNDI\",\"MARDI\",\"MERCREDI\",\"JEUDI\",\"VENDREDI\",\"SAMEDI\") & \" !\",\"\")","v":" MERCREDI !"},null,"Remise en route"]
[2008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(U1),ISNUMBER(U2),ISNUMBER(U3)),\"C'est le \" & TODAY()-DATE(U1,U2,U3) & \"° jour depuis la réparation\" & \" !\",\"\")","v":"C'est le 2227° jour depuis la réparation !"}]
["JANVIER Hp",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:K5)","v":0},null,{"$f":"AVERAGE(D5:K5)","v":{"$error":"#DIV/0!"}},{"$f":"N5/31","v":{"$error":"#DIV/0!"}},{"$f":"O5+O6","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+L6+L5","v":0},{"$f":"AVERAGE(D6:K6)","v":{"$error":"#DIV/0!"}},{"$f":"N6/31","v":{"$error":"#DIV/0!"}}]
["FÉVRIER Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$f":"N7/28","v":{"$error":"#DIV/0!"}},{"$f":"O7+O8","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"TODAY()","v":"2018-10-04"}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L8+L7","v":0},{"$error":"#DIV/0!"},{"$f":"N8/28","v":{"$error":"#DIV/0!"}},null,null,null,null,"Nb Jour écoulé",null,{"$f":"IF(AND(ISNUMBER(U1),ISNUMBER(U2),ISNUMBER(U3)),TODAY()-DATE(U1,U2,U3),\"\")","v":2227}]
["MARS Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O9+O10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L10+L9","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,"Année",null,365]
["AVRIL Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$f":"N11/30","v":{"$error":"#DIV/0!"}},{"$f":"O11+O12","v":{"$error":"#DIV/0!"}},null,"avant le 7 6 2012",null,null,6076,1549,3.93,"h/j"]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L12+L11","v":0},{"$error":"#DIV/0!"},{"$f":"N12/30","v":{"$error":"#DIV/0!"}},null,null,null,null,"Kw",null,"Heures","résistances","G"]
["MAI Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O13+O14","v":{"$error":"#DIV/0!"}},null,"Total PAC",null,{"$f":"L40","v":0},null,{"$f":"L33","v":0},{"$f":"L34","v":0},{"$f":"(T19)/(107*2.5*(21-15))*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L14+L13","v":0},{"$error":"#DIV/0!"},{"$f":"N14/31","v":{"$error":"#DIV/0!"}}]
["JUIN Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$f":"N15/30","v":{"$error":"#DIV/0!"}},{"$f":"O15+O16","v":{"$error":"#DIV/0!"}},null,"Kw/J",null,{"$f":"T13/V8","v":0},null,{"$f":"(V13)/V8","v":0},"h/j"]
["30 j ECS seule",null,null,null,null,null,null,null,null,null,null,0,{"$f":"L16+L15","v":0},{"$error":"#DIV/0!"},{"$f":"N16/30","v":{"$error":"#DIV/0!"}}]
["JUILLET Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O17+O18","v":{"$error":"#DIV/0!"}},null,"Kw/h",null,{"$f":"T15/24","v":0},null,{"$f":"V15*T10","v":0}]
["29 j ecs seule",null,null,null,null,null,null,null,null,null,null,0,{"$f":"L18+L17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["ECS AOÛT Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AVERAGE(C19:K19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"O19+O20","v":{"$error":"#DIV/0!"}},null,"Kw/hmax",null,{"$f":"N5/31/24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L20+L19","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["SEPTEMBRE Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$f":"N21/30","v":{"$error":"#DIV/0!"}},{"$f":"O21+O22","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L22+L21","v":0},{"$error":"#DIV/0!"},{"$f":"N22/30","v":{"$error":"#DIV/0!"}}]
["OCTOBRE Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O23+O24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L24+L23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["NOVEMBRE Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$f":"N25/30","v":{"$error":"#DIV/0!"}},{"$f":"O25+O26","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L26+L25","v":0},{"$error":"#DIV/0!"},{"$f":"N26/30","v":{"$error":"#DIV/0!"}}]
["DÉCEMBRE Hp",null,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O27+O28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"L28+L27","v":0},{"$error":"#DIV/0!"},{"$f":"N28/31","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conso /an moyenne",null,{"$f":"T10*T15","v":0}]
["Somme HP /An",null,{"$f":"C5+C7+C9+C11+C13+C15+C17+C19+C21+C23+C25+C27","v":0},0,0,0,0,0,0,0,0]
["Somme HC /An",null,{"$f":"C6+C8+C10+C12+C14+C16+C18+C20+C22+C24+C26+C28","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,"Conso ECS mois",null,{"$f":"SUM(N15:N20)/3","v":{"$error":"#DIV/0!"}}]
["Somme Pac /An",null,{"$f":"C30+C31","v":0},0,{"$f":"E30+E31","v":0},0,0,0,0,0,0,null,{"$f":"SUM(M5:M28)","v":0},{"$f":"SUM(N5:N28)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O5:O28)","v":{"$error":"#DIV/0!"}},null,null,"Conso ECS Jour",null,{"$f":"T31/30","v":{"$error":"#DIV/0!"}}]
["Compresseur",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C33:K33)","v":0},null,null,null,null,null,"Conso ECS absence",null,2.4500000000000002]
["résistances",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B34:K34)","v":0}]
["H/Kw",null,{"$f":"IF(C33<=0,\" \",C33/C32)","v":" "}," ",{"$f":"IF(E33<=0,\" \",E33/E32)","v":" "},{"$f":"IF(F33<=0,\" \",F33/F32)","v":" "}," "," "," "," "," "]
["Kw/h",null,{"$f":"IF(C32<=0,\" \",C32/C33)","v":" "}," ",{"$f":"IF(E32<=0,\" \",E32/E33)","v":" "},{"$f":"IF(F32<=0,\" \",F32/F33)","v":" "}," "," "," "," "," "]
["Conso hors PAC  annuel",null,{"$f":"elec!G32-Pac!C32","v":0},{"$f":"elec!H32-Pac!D32","v":0},{"$f":"elec!I32-Pac!E32","v":0},{"$f":"elec!J32-Pac!F32","v":0},{"$f":"elec!K32-Pac!G32","v":0},{"$f":"elec!P32-Pac!H32","v":0},{"$f":"elec!Q32-Pac!I32","v":0},{"$f":"elec!R32-Pac!J32","v":0},{"$f":"elec!S32-Pac!K32","v":0},{"$f":"SUM(C37:K37)","v":0},null,null,null,null,null,"Conso PAC heure",null,{"$f":"T29/V17","v":{"$error":"#DIV/0!"}}]
["Cumul relevé Hp",null,{"$f":"C27+C25+C23+C21+C19+C17+C15+C13+C11+C9+C7+C5","v":0},{"$f":"D27+D25+D23+D21+D19+D17+D15+D13+D11+D9+D7+D5+C38","v":0},0,{"$f":"F27+F25+F23+F21+F19+F17+F15+F13+F11+F9+F7+F5+E38","v":0},0,0,0,0,0,{"$f":"K38","v":0},null,null,null,null,null,"conso ECS an",null,{"$f":"T31*12","v":{"$error":"#DIV/0!"}},{"$f":"T38/T29","v":{"$error":"#DIV/0!"}},null,null,null,"PAC NUIT 6 KW"]
["Cumul relevé Hc",null,{"$f":"C31","v":0},{"$f":"C39+D31","v":0},0,0,0,0,0,0,0,{"$f":"K39","v":0},null,null,null,null,null,"COP ECS",null,{"$f":"T52/T38","v":{"$error":"#DIV/0!"}}]
["Cumul relevé HP HC PAC + ECS",null,{"$f":"C38+C39","v":0},{"$f":"D38+D39","v":0},0,0,0,0,0,0,0,{"$f":"L39+L38","v":0},null,null,null,null,null,"conso chauffage",null,{"$f":"T29-T38","v":{"$error":"#DIV/0!"}},{"$f":"T40/T29","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cop moyen annuel",null,{"$f":"13000/T40","v":{"$error":"#DIV/0!"}}]
["Total énergie/An",null,{"$f":"C38+C37","v":0},{"$f":"D38+D37","v":0},0,0,0,0,0,0,0,0]
["Energie total",null,{"$f":"C42","v":0},{"$f":"C43+D42","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"cout ECS/an",null,{"$f":"T38*COMPAR!I25","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cout Chauffage",null,{"$f":"T40*COMPAR!I25","v":{"$error":"#DIV/0!"}}]
["MOYENNE/mois",null,{"$f":"C42/12","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,"cout PAC/an",null,{"$f":"T43+T44","v":{"$error":"#DIV/0!"}}]
["ECART",null,{"$f":"C42","v":0},{"$f":"D42-C42","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,"Conso fioul",null,{"$f":"2400-T57","v":1766},"ans"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cout fioul",null,{"$f":"T46*0.76","v":1342.16}]
["TEMPERATURE ",null,21,{"$f":"C48","v":21},{"$f":"D48","v":21},21,21,21,{"$f":"H48","v":21},21,21,{"$f":"AVERAGE(C48:K48)","v":21},null,null,null,null,null,"Amortissement",null,{"$f":"2000/T47","v":1.4901353042856291}]
[]
["Kw/J mini PAC",null,{"$f":"C32/365","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"N37/365","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conso cumulus",null,{"$f":"8*365","v":2920}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cout avec cumulus",null,{"$f":"T52*COMPAR!I33","v":615.9375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain",null,{"$f":"T53-T43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amortissement",null,{"$f":"2000/T54","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cumulus fioul ",null,634,"ans"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cout fioul",null,{"$f":"T57*0.76","v":481.84000000000003}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sachant qu’il faut environ une puissance de 11 watts par litre d’eau (entre 6 et 8 heures de fonctionnement par tranche de 24 heures) et en moyenne 50 litres d’eau chaude quotidienne , par personne."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avec cette base vous pouvez calculer la puissance de votre ballon "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prenons ici l'exemple d'un cumuls de  branché automatiquement sur le tarif nuit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de personne",null,"Ballon","Watt/l","Puissance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,300,11,{"$f":"V72*U72","v":3300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Il chauffe entre 6 et 8 heures par nuit au prix de",null,null,null,{"$f":"'Option HC bleu'!D62","v":0.12715199999999999},"(prix du kWh en heures creuses ) soit",null,null,{"$f":"W72/1000","v":3.3},"x",7,null,{"$f":"AC73*AA73","v":23.099999999999998},"de fonctionnement par nuit",null,{"$f":"W73*AE73","v":2.9372111999999992},365,{"$f":"AI73*AH73","v":1072.0820879999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avec PAC Cop",null,{"$f":"T39","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"AA73/U74","v":{"$error":"#DIV/0!"}},"x",7,null,{"$f":"AC74*AA74","v":{"$error":"#DIV/0!"}},"de fonctionnement par nuit",null,{"$f":"AE74*W73","v":{"$error":"#DIV/0!"}},365,{"$f":"AI74*AH74","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNEES",{"$f":"C2","v":2012},{"$f":"D2","v":2013},2014,2015,2016,2017,2018,2019,2020]
[null,"MOIS"]
[]
[null,"JANVIER",{"$f":"C5+C6","v":0},{"$f":"D5+D6","v":0},{"$f":"E5+E6","v":0},0,0,0,0,0,0]
[null,"FEVRIER",{"$f":"C7+C8","v":0},{"$f":"D7+D8","v":0},{"$f":"E7+E8","v":0},0,0,0,0,0,0]
[null,"MARS",{"$f":"C9+C10","v":0},{"$f":"D9+D10","v":0},{"$f":"E9+E10","v":0},0,0,0,0,0,0]
[null,"AVRIL",{"$f":"C11+C12","v":0},{"$f":"D11+D12","v":0},{"$f":"E11+E12","v":0},0,0,0,0,0,0]
[null,"MAI",{"$f":"C13+C14","v":0},{"$f":"D13+D14","v":0},{"$f":"E13+E14","v":0},0,0,0,0,0,0]
[null,"JUIN",{"$f":"C15+C16","v":0},{"$f":"D15+D16","v":0},{"$f":"E15+E16","v":0},0,0,0,0,0,0]
[null,"JUILLET",{"$f":"C17+C17","v":0},{"$f":"D17+D17","v":0},{"$f":"E17+E17","v":0},0,0,0,0,0,0]
[null,"AOUT",{"$f":"C19+C20","v":0},{"$f":"D19+D20","v":0},{"$f":"E19+E20","v":0},0,0,0,0,0,0]
[null,"SEPT",{"$f":"C21+C22","v":0},{"$f":"D21+D22","v":0},{"$f":"E21+E22","v":0},0,0,0,0,0,0]
[null,"OCT",{"$f":"C23+C24","v":0},{"$f":"D23+D24","v":0},{"$f":"E23+E24","v":0},0,0,0,0,0,0]
[null,"NOV",{"$f":"C25+C26","v":0},{"$f":"D25+D26","v":0},{"$f":"E25+E26","v":0},0,0,0,0,0,0]
[null,"DEC",{"$f":"C27+C28","v":0},{"$f":"D27+D28","v":0},{"$f":"E27+E28","v":0},0,0,0,0,0,0]
[null,"conso PAC",{"$f":"SUM(C107:C118)","v":0},0,{"$f":"SUM(E107:E118)","v":0},0,0,0,0,0,0]
[]
[null,"Cout du kw",{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}},{"$f":"COMPAR!$I$25","v":{"$error":"#DIV/0!"}}]
[null,"cout PAC + ECS",{"$f":"C121*C119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Hiver",0,{"$f":"SUM(D107:D110)+SUM(C116:C118)","v":0},{"$f":"SUM(E107:E110)+SUM(D116:D118)","v":0},0,0,0,0,0,0]

{"sheet":"elec","index":7,"n_rows":117,"n_cols":35,"rows_kept":117,"cut":false,"hidden":false,"merged":[[39,2,39,15]]}
[]
[null,"ANNEES",2008,{"$f":"C2+1","v":2009},{"$f":"D2+1","v":2010},2011,2012,2013,2014,{"$f":"I2+1","v":2015},{"$f":"J2+1","v":2016},{"$f":"K2+1","v":2017},2018,2019,{"$f":"N2+1","v":2020},2021,"Compteur","CUMUL","MOYENNE 2008/2010","jour"]
[null,"MOIS"]
[]
[null,"JAN Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:P5)","v":0},null,{"$f":"AVERAGE(C5:P5)","v":{"$error":"#DIV/0!"}},{"$f":"S5/31","v":{"$error":"#DIV/0!"}}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q4+Q6","v":0},{"$error":"#DIV/0!"},{"$f":"S6/31","v":{"$error":"#DIV/0!"}}]
[null,"FEV Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$f":"S7/28","v":{"$error":"#DIV/0!"}}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$f":"S8/28","v":{"$error":"#DIV/0!"}}]
[null,"MAR Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"AVR Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$f":"S11/30","v":{"$error":"#DIV/0!"}}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$f":"S12/30","v":{"$error":"#DIV/0!"}}]
[null,"MAI Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"JUI hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R13+Q15","v":0},{"$error":"#DIV/0!"},{"$f":"S15/30","v":{"$error":"#DIV/0!"}}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q14+Q16","v":0},{"$f":"AVERAGE(D16:P16)","v":{"$error":"#DIV/0!"}},{"$f":"S16/30","v":{"$error":"#DIV/0!"}}]
[null,"JUI Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R15+Q17","v":0},{"$f":"AVERAGE(C17:P17)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q16+Q18","v":0},{"$f":"AVERAGE(D18:P18)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"AOU Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R17+Q19","v":0},{"$f":"AVERAGE(C19:P19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q18+Q20","v":0},{"$f":"AVERAGE(D20:P20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"SEP hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R19+Q21","v":0},{"$f":"AVERAGE(C21:P21)","v":{"$error":"#DIV/0!"}},{"$f":"S21/30","v":{"$error":"#DIV/0!"}}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q20+Q22","v":0},{"$f":"AVERAGE(D22:P22)","v":{"$error":"#DIV/0!"}},{"$f":"S22/30","v":{"$error":"#DIV/0!"}}]
[null,"OCT Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R21+Q23","v":0},{"$f":"AVERAGE(C23:P23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q22+Q24","v":0},{"$f":"AVERAGE(D24:P24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"NOV Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R23+Q25","v":0},{"$f":"AVERAGE(C25:P25)","v":{"$error":"#DIV/0!"}},{"$f":"S25/30","v":{"$error":"#DIV/0!"}}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q24+Q26","v":0},{"$f":"AVERAGE(D26:P26)","v":{"$error":"#DIV/0!"}},{"$f":"S26/30","v":{"$error":"#DIV/0!"}}]
[null,"DEC Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"R25+Q27","v":0},{"$f":"AVERAGE(C27:P27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"hc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q26+Q28","v":0},{"$f":"AVERAGE(D28:P28)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["index",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPTEUR"]
[38234,"Somme Hp",{"$f":"C27+C25+C23+C21+C19+C17+C15+C13+C11+C9+C7+C5","v":0},{"$f":"D27+D25+D23+D21+D19+D17+D15+D13+D11+D9+D7+D5","v":0},{"$f":"E27+E25+E23+E21+E19+E17+E15+E13+E11+E9+E7+E5","v":0},0,0,{"$f":"H27+H25+H23+H21+H19+H17+H15+H13+H11+H9+H7+H5","v":0},{"$f":"I27+I25+I23+I21+I19+I17+I15+I13+I11+I9+I7+I5","v":0},0,0,{"$f":"L27+L25+L23+L21+L19+L17+L15+L13+L11+L9+L7+L5","v":0},0,0,0,0,{"$f":"SUM(D27+D25)-128+A30+SUM(E30:P30)","v":38106},{"$f":"R27","v":0},{"$f":"S27+S25+S23+S21+S19+S17+S15+S13+S11+S9+S7+S5","v":{"$error":"#DIV/0!"}}]
[28449,"Somme Hc",{"$f":"C28+C26+C24+C22+C20+C18+C16+C14+C12+C10+C8+C6","v":0},{"$f":"D28+D26+D24+D22+D20+D18+D16+D14+D12+D10+D8+D6","v":0},0,0,0,{"$f":"H28+H26+H24+H22+H20+H18+H16+H14+H12+H10+H8+H6","v":0},{"$f":"I28+I26+I24+I22+I20+I18+I16+I14+I12+I10+I8+I6","v":0},0,0,{"$f":"L28+L26+L24+L22+L20+L18+L16+L14+L12+L10+L8+L6","v":0},0,0,0,0,{"$f":"SUM(C31:P31)+A31","v":28449},{"$f":"R28","v":0},{"$f":"S28+S26+S24+S22+S20+S18+S16+S14+S12+S10+S8+S6","v":{"$error":"#DIV/0!"}}]
[null,"Somme /an",{"$f":"C31+C30","v":0},{"$f":"D31+D30","v":0},0,0,0,0,0,0,0,{"$f":"L31+L30","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"608-234","v":374}]
[null,"MOYENNE",{"$f":"C32/12","v":0},{"$f":"D32/12","v":0},{"$f":"E32/12","v":0},0,0,0,0,0,0,{"$f":"L32/12","v":0},0,0,0,0,{"$f":"Q32/12","v":0},null,{"$f":"S30/12","v":{"$error":"#DIV/0!"}}]
[null,"ECART",null,{"$f":"D32-C32","v":0},0,0,0,0,0,0,0,{"$f":"L32-K32","v":0},{"$f":"M32-L32","v":0},{"$f":"N32-M32","v":0},{"$f":"O32-N32","v":0},{"$f":"P32-O32","v":0},{"$f":"Q32-D32","v":0},null,{"$f":"AVERAGE(C35:D35)","v":0}]
[]
[null,"Température",21,21,21,21,21,21,21,21,21,21,21,21,21,21,{"$f":"AVERAGE(C37:P37)","v":21}]
[null,"Surface",107,107,107,107,107,107,107,107,107,107,107,107,107,107]
[null,"Energie","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC","PAC"]
[null,"ECS","ECS PAC"]
[null,"Kw/J mini",{"$f":"C30/365","v":0},{"$f":"D30/365","v":0},{"$f":"E30/365","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"S30/365","v":{"$error":"#DIV/0!"}}]
[]
[null,"Moyenne",null,null,null,null,{"$f":"AVERAGE(D32:J32)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNEES",2008,2009,{"$f":"D100+1","v":2010},2011,2012,2013,2014,2015,2016,null,null,null,null,{"$f":"K100+1","v":2017}]
[null,"MOIS"]
[]
[null,"JANVIER",{"$f":"C5+C6","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"FEVRIER",{"$f":"C7+C8","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"MARS",{"$f":"C9+C10","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"AVRIL",{"$f":"C11+C12","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"MAI",{"$f":"C13+C14","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"JUIN",{"$f":"C15+C16","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"JUILLET",{"$f":"C17+C18","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"AOUT",{"$f":"C19+C20","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"SEPT",{"$f":"C21+C22","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,"OCT",{"$f":"C23+C24","v":0},0,0,0,0,{"$f":"H23+H24","v":0},{"$f":"I23+I24","v":0},0,0,null,null,null,null,0]
[null,"NOV",{"$f":"C25+C26","v":0},0,0,0,0,{"$f":"H25+H26","v":0},{"$f":"I25+I26","v":0},0,0,null,null,null,null,0]
[null,"DEC",{"$f":"C27+C28","v":0},0,0,0,0,{"$f":"H27+H28","v":0},{"$f":"I27+I28","v":0},0,0,null,null,null,null,0]
[null,"conso Electrique",{"$f":"SUM(C103:C114)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,0,{"$f":"AVERAGE(C115:H115)","v":0}]
[]
[null,"Conso estimée",{"$f":"C115","v":0},{"$f":"D115","v":0},{"$f":"E115+(Pac!$D$119/3)","v":0},{"$f":"F115+(Pac!$D$119/3)","v":0},{"$f":"G115+(Pac!$D$119/3)","v":0},{"$f":"H115+(Pac!$D$119/3)","v":0},{"$f":"I115+(Pac!$E119/3)","v":0},{"$f":"J115+(Pac!$F$119/3)","v":0},{"$f":"K115+(Pac!$G$119/3)","v":0},null,null,null,null,{"$f":"P115+(Pac!$H$119/3)","v":0},{"$f":"AVERAGE(C117:H117)","v":0}]

{"sheet":"Liste","index":8,"n_rows":96,"n_cols":8,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["Département","DJU 18°","Temp base","Ville"]
[1,2626,-10,"01 Amberieu"]
[2,2963,-7,"02 Eparcy"]
[3,2508,-8,"03 Vichy"]
[4,3323,-8,"04 Saint André Les Alpes"]
[5,4475,-10,"Agnières En Devoluy"]
[6,3428,-8]
[7,2314,-8]
[8,3089,-10]
[9,3206,-5]
[10,2620,-10]
[11,1930,-4]
[12,2703,-6]
[13,1853,-5]
[14,2517,-7,null,null,null,null,"Calcul DJU base 18°"]
[15,3302,-8,null,null,null,null,"DJU = 18 – Tmin + Tmax / 2"]
[16,2136,-5,null,null,null,null,"Exemple pour deux jours (NJ)"]
[17,1846,-5,null,null,null,null,"Le 10/10/2005 = Tmin 8°  Tmax 12  d’où DJU  = 18 – (8 + 12 / 2) = 8"]
[18,2487,-7,null,null,null,null,"Le 11/10/2005 = Tmin 6°  Tmax 10  d’où DJU  = 18 – (6 + 10 / 2) = 8"]
[19,3200,-8,null,null,null,null,"soit au total 16 DJU (pour NJ=2) "]
[20,3022,-2]
[21,2868,-10,null,null,null,null,"Correction pour une base 21°"]
[22,2445,-4,null,null,null,null,"écart base T° = 21°-18°=3°"]
[23,3061,-8,null,null,null,null,"DJU = DJU période + (NJ * écart base T°)"]
[24,2079,-5,null,null,null,null,"DJU = 16 + ( 2 * 3)  = 22   "]
[25,3548,-12]
[26,3389,-6]
[27,2600,-7]
[28,2586,-7]
[29,2160,-4]
[30,3928,-5]
[31,2511,-5]
[32,2150,-5]
[33,2037,-4]
[34,1825,-4]
[35,2292,-5]
[36,2403,-7]
[37,2338,-7]
[38,3700,-10]
[39,2918,-10]
[40,2036,-4]
[41,2467,-7]
[42,2636,-10]
[43,2905,-8]
[44,2199,-5]
[45,2532,-7]
[46,2132,-6]
[47,2078,-5]
[48,3500,-6]
[49,2308,-7]
[50,2228,-4]
[51,2709,-10]
[52,2954,-12]
[53,2550,-7]
[54,2923,-15,"nancy"]
[55,2985,-12,"verdun"]
[56,2163,-4]
[57,2981,-15,"Metz"]
[58,2858,-10]
[59,2720,-9]
[60,2680,-7]
[61,2537,-7]
[62,2644,-9]
[63,3918,-8]
[64,4083,-5]
[65,5243,-5]
[66,3931,-4]
[67,3310,-15]
[68,4036,-15]
[69,3012,-10]
[70,3101,-12]
[71,2935,-10]
[72,2428,-7]
[73,4546,-10]
[74,3869,-10]
[75,2406,-5]
[76,2569,-7]
[77,2626,-7]
[78,2659,-7]
[79,2350,-7]
[80,2607,-9]
[81,2250,-5]
[82,2150,-5]
[83,2589,-2]
[84,4277,-6]
[85,2214,-5]
[86,2363,-7]
[87,2520,-8]
[88,2875,-15]
[89,2532,-10]
[90,3939,-15]
[91,2688,-7]
[92,2500,-5]
[93,2464,-5]
[94,2510,-5]
[95,2559,-7]