{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Courbe de chauffe","liste"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"Courbe de chauffe","index":0,"n_rows":14,"n_cols":48,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,47]]}
[null,null,"Remplir les cellules Blanches"]
[]
["Temp consigne",21]
["Station météo",54]
["Temp régionale mini",{"$f":"LOOKUP(B4,liste!A2:A105,liste!C2:C105)","v":-15}]
["DJU",{"$f":"LOOKUP(B4,liste!A2:A105,liste!B2:B105)+(232*(B3-18))","v":3619}]
["Consigne départ PAC",58]
["Consigne retour PAC",51,null,null,null,null,null,null,null,null,null,null,"²"]
["Delta T",{"$f":"B7-B8","v":7}]
["Courbe",0.6,{"$f":"IF($B3+$B10*($B$3-C$11)*C$12>=$B$8,$B$8,$B3+$B10*($B$3-C$11)*C$12)","v":19.763999999999999},20.3856,21,21.607199999999999,22.2072,22.8,23.3856,23.963999999999999,24.5352,25.0992,25.655999999999999,26.2056,26.748000000000001,27.283200000000001,27.811199999999999,28.332000000000001,28.845600000000001,29.352000000000004,29.851199999999999,30.343200000000003,30.828000000000003,31.305600000000002,31.776000000000003,32.239200000000004,32.6952,33.143999999999998,33.585599999999999,34.020000000000003,34.447200000000002,34.867199999999997,35.28,35.685600000000001,36.084000000000003,36.475200000000001,36.859200000000001,37.236000000000004,37.605599999999995,37.968000000000004,38.3232,38.671199999999999,39.012,39.345600000000005,39.671999999999997,39.991199999999999,40.303200000000004,40.608000000000004]
["Bivalence",-7,{"$f":"D11+1","v":23},{"$f":"B3+1","v":22},{"$f":"B3","v":21},{"$f":"E11-1","v":20},19,18,17,16,15,14,13,12,11,10,9,8,7,{"$f":"S11-1","v":6},{"$f":"T11-1","v":5},4,3,2,1,0,-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14,-15,-16,-17,-18,-19,-20,-21,-22]
["Coefficient",{"$f":"B10%","v":6.0000000000000001E-3},{"$f":"D12+$B12","v":1.0300000000000002},{"$f":"E12+$B12","v":1.0240000000000002},{"$f":"F12+$B12","v":1.0180000000000002},{"$f":"G12+$B12","v":1.0120000000000002},{"$f":"H12+$B12","v":1.0060000000000002},{"$f":"I12+$B12","v":1.0000000000000002},{"$f":"J12+$B12","v":0.99400000000000022},{"$f":"K12+$B12","v":0.98800000000000021},{"$f":"L12+$B12","v":0.98200000000000021},{"$f":"M12+$B12","v":0.9760000000000002},{"$f":"N12+$B12","v":0.9700000000000002},{"$f":"O12+$B12","v":0.96400000000000019},{"$f":"P12+$B12","v":0.95800000000000018},{"$f":"Q12+$B12","v":0.95200000000000018},{"$f":"R12+$B12","v":0.94600000000000017},{"$f":"S12+$B12","v":0.94000000000000017},{"$f":"T12+$B12","v":0.93400000000000016},{"$f":"U12+$B12","v":0.92800000000000016},{"$f":"V12+$B12","v":0.92200000000000015},{"$f":"W12+$B12","v":0.91600000000000015},{"$f":"X12+$B12","v":0.91000000000000014},{"$f":"Y12+$B12","v":0.90400000000000014},{"$f":"Z12+$B12","v":0.89800000000000013},{"$f":"AA12+$B12","v":0.89200000000000013},{"$f":"AB12+$B12","v":0.88600000000000012},{"$f":"AC12+$B12","v":0.88000000000000012},{"$f":"AD12+$B12","v":0.87400000000000011},{"$f":"AE12+$B12","v":0.8680000000000001},{"$f":"AF12+$B12","v":0.8620000000000001},{"$f":"AG12+$B12","v":0.85600000000000009},{"$f":"AH12+$B12","v":0.85000000000000009},{"$f":"AI12+$B12","v":0.84400000000000008},{"$f":"AJ12+$B12","v":0.83800000000000008},{"$f":"AK12+$B12","v":0.83200000000000007},{"$f":"AL12+$B12","v":0.82600000000000007},{"$f":"AM12+$B12","v":0.82000000000000006},{"$f":"AN12+$B12","v":0.81400000000000006},{"$f":"AO12+$B12","v":0.80800000000000005},{"$f":"AP12+$B12","v":0.80200000000000005},{"$f":"AQ12+$B12","v":0.79600000000000004},{"$f":"AR12+$B12","v":0.79},{"$f":"AS12+$B12","v":0.78400000000000003},{"$f":"AT12+$B12","v":0.77800000000000002},{"$f":"AU12+$B12","v":0.77200000000000002},{"$f":"AV12+$B12","v":0.76600000000000001},0.76]
["G=Maison",0.95]
["COP à -7°",2.2000000000000002]

{"sheet":"liste","index":1,"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,1619,-8,"Nice"]
[7,2314,-8]
[8,3089,-10]
[9,3206,-5]
[10,2620,-10,null,null,null,null,"http://www.therloss.fr/services.php"]
[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]