{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Rez TEST","Liste","Param"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":23,"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":"Rez TEST","index":0,"n_rows":20,"n_cols":41,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,25,2,34],[2,0,2,7],[2,8,2,12],[2,13,2,17],[2,18,2,20],[2,21,2,24]]}
[null,null,null,null,null,null,null,"Nom du chantier:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temp. de service:",null,null,null,null,null,null,30,"\\",25,"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temp moyenne:",null,null,null,null,null,null,null,null,null,null,30,"°C"]
["Données du local",null,null,null,null,null,null,null,"Zone extérieure",null,null,null,null,"Zone intérieure",null,null,null,null,"Totaux",null,null,"Matériel",null,null,null,"Perte de charge",null,null,null,null,null,null,null,null,null,null,"contrôle"]
[1,2,null,3,4,null,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
["Local n°","Facteur   f","Résistance","T° Ambiante","Surafce totale","Puissance au m² reporté","Surafce utile","Puissance nette","Nbre de tubes","Puissance au m2","Longueur de tube","Puissance","Surface ZE","Puissance au m2","Ecartement  [m]","Longueur tube","Puissance","Surface ZI","Puissance totale","collcteur -> boucle","Pertes par le sol","Distributeur","Rail de fixation","Aiguilles","Feuille PE","Débit total  [l/h]","Vitesse [m/s]","Longueur totale","Contenance [litres]","D P   [Pa/m]","D P   Vanne [kPa]","D P   RETOUR [kPa]","D P   TUBE [kPa]","D P   TOTAL","Position réglage",null,"Ecartement  [m]","Puiss./m²   [W/m²]","Surface [m²]","Puiss. Effective [W]","différence"]
["001",1,0.1,24,35,{"$f":"ecartement(C6,D6,N6,$AG$2,TRUE)","v":23.3},{"$f":"E6*0.9","v":31.5},670,null,null,{"$f":"(1/0.1)*M6","v":0},{"$f":"J6*M6*B6","v":0},null,{"$f":"Q6/(R6*B6)","v":21.269841269841269},{"$f":"ecartement(C6,D6,N6,$AG$2)","v":10},{"$f":"(1/O6)*R6","v":3.1500000000000004},{"$f":"H6-L6","v":670},{"$f":"G6-M6","v":31.5},{"$f":"H6","v":670},null,null,{"$f":"ROUNDUP(P6/80,0)","v":1},{"$f":"E6*0.6","v":21},{"$f":"T6*0.5","v":0},{"$f":"E6*1.1","v":38.5},{"$f":"(S6+U6)/(1.163*($AE$1-$AG$1))","v":115.21926053310403}]
[]
[null,1,0.1,24,35,23.3,31.5,670,null,null,null,null,null,{"$f":"Q8/(R8*B8)","v":21.269841269841269},10,null,670,31.5,670]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    'resistance 0.10; puissance 21.27;"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    'tAmbiance 24; t2 30"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:P18)","v":3.1500000000000004},"m",null,null,null,null,{"$f":"SUM(V6:V14)","v":1},"boucles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN6:AN18)","v":0}]

{"sheet":"Liste","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[0]
[0.05]
[0.1]
[0.15]

{"sheet":"Param","index":2,"n_rows":99,"n_cols":12,"rows_kept":99,"cut":false,"hidden":false,"merged":[[17,1,23,1],[1,1,7,1],[9,1,15,1],[26,1,32,1],[34,1,40,1],[84,1,90,1],[92,1,98,1],[42,1,48,1],[51,1,57,1],[59,1,65,1],[67,1,73,1],[76,1,82,1]]}
[0,0,15,16,17,18,20,21,22,24,"Ecartement"]
[null,27.5,0,0,0,0,0,0,0,0,30]
[null,null,47,41.977777777777781,39.466666666666669,35.700000000000003,24.450000000000003,22.575000000000003,20.700000000000003,13.200000000000003,30]
[null,null,54.100000000000009,48.322222222222237,45.433333333333337,41.099999999999994,32.499999999999993,28.150000000000002,23.8,15.2,25]
[null,null,62.45000000000001,55.783333333333339,52.45000000000001,47.45,37.399999999999991,32.399999999999991,27.399999999999995,17.399999999999999,20]
[null,null,72,64.311111111111103,60.466666666666654,54.699999999999989,43.2,37.450000000000003,31.7,20.200000000000003,15]
[null,null,83.6,83.944444444444457,75.76666666666668,63.500000000000007,50.05,43.424999999999997,36.799999999999997,23.400000000000002,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,30,0,0,0,0,0,0,0,0,30]
[null,null,56.4,51.37777777777778,48.866666666666667,45.1,37.6,33.85,30.1,22.6,30]
[null,null,64.900000000000006,59.122222222222227,56.233333333333334,51.9,43.3,38.950000000000003,34.6,26,25]
[null,null,74.900000000000006,68.233333333333334,64.900000000000006,59.9,49.9,44.9,39.9,29.9,20]
[null,null,86.4,78.711111111111109,74.86666666666666,69.099999999999994,57.6,51.85,46.1,34.6,15]
[null,null,100.3,91.366666666666674,86.9,80.2,66.8,60.15,53.5,40.1,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,35,0,0,0,0,0,0,0,0,30]
[null,null,75.2,70.177777777777777,67.666666666666671,63.9,63.9,56.4,48.9,41.4,30]
[null,null,86.5,80.722222222222214,77.833333333333329,73.5,64.900000000000006,60.550000000000004,56.2,47.6,25]
[null,null,99.8,93.133333333333326,89.8,84.8,74.900000000000006,69.900000000000006,64.900000000000006,54.9,20]
[null,null,115.2,107.51111111111112,103.66666666666667,97.9,86.4,80.650000000000006,74.900000000000006,63.4,15]
[null,null,133.69999999999999,106.21111111111111,109.16666666666666,113.6,100.3,93.6,86.9,73.5,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[0.05,null,15,16,17,18,20,21,22,24,"Ecartement"]
[null,27.5,0,0,0,0,0,0,0,0,30]
[null,null,37.849999999999994,33.783333333333331,31.749999999999993,28.699999999999996,22.75,19.675000000000001,16.600000000000001,10.65,30]
[null,null,42.600000000000009,38.066666666666663,35.799999999999997,32.4,25.6,22.124999999999996,18.649999999999999,11.849999999999998,25]
[null,null,48,42.8888888888889,40.333333333333343,36.5,28.799999999999997,24.949999999999996,21.1,13.350000000000001,20]
[null,null,54.15,48.37222222222222,45.483333333333334,41.15,32.449999999999996,28.175000000000001,23.900000000000006,15.149999999999999,15]
[null,null,61.349999999999994,61.555555555555536,55.533333333333317,46.499999999999993,36.700000000000003,31.800000000000008,26.900000000000006,17.149999999999999,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,30,0,0,0,0,0,0,0,0,30]
[null,null,45.4,41.355555555555554,39.333333333333329,36.299999999999997,30.3,27.25,24.2,18.2,30]
[null,null,51.1,46.566666666666663,44.3,40.9,34.1,30.65,27.2,20.399999999999999,25]
[null,null,57.6,52.488888888888894,49.933333333333337,46.1,38.4,34.549999999999997,30.7,23,20]
[null,null,65,59.222222222222221,56.333333333333336,52,43.3,39,34.700000000000003,26,15]
[null,null,73.599999999999994,67.022222222222211,63.733333333333327,58.8,49,44.1,39.200000000000003,29.4,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,35,0,0,0,0,0,0,0,0,30]
[null,null,60.5,56.5,54.5,51.5,45.4,42.4,39.4,33.299999999999997,30]
[null,null,68.099999999999994,63.566666666666663,61.3,57.9,51.1,47.7,44.3,37.5,25]
[null,null,76.8,71.688888888888883,69.133333333333326,65.3,57.6,53.75,49.9,42.3,20]
[null,null,86.7,80.922222222222217,78.033333333333331,73.7,65,60.65,56.3,47.7,15]
[null,null,98.1,77.955555555555563,80.13333333333334,83.4,73.599999999999994,68.699999999999989,63.8,53.9,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[0.1,null,15,16,17,18,20,21,22,24,"Ecartement"]
[null,27.5,0,0,0,0,0,0,0,0,30]
[null,null,32.349999999999994,28.883333333333336,27.150000000000002,24.55,19.300000000000004,16.774999999999999,14.249999999999998,9.0500000000000007,30]
[null,null,35.649999999999991,31.894444444444439,30.016666666666666,27.199999999999996,21.500000000000004,18.575000000000003,15.65,9.9500000000000028,25]
[null,null,39.5,35.25555555555556,33.133333333333326,29.95,23.700000000000003,20.550000000000004,17.399999999999999,11.100000000000001,20]
[null,null,43.7,39.033333333333331,36.700000000000003,33.200000000000003,26.25,22.75,19.25,12.25,15]
[null,null,48.599999999999994,48.788888888888891,44.033333333333331,36.900000000000006,29.2,25.3,21.400000000000002,13.6,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,30,0,0,0,0,0,0,0,0,30]
[null,null,38.799999999999997,35.333333333333336,33.6,31,25.8,23.25,20.7,15.5,30,{"$f":"MATCH(21.27,J60:J66,1)","v":5}]
[null,null,42.8,39.022222222222219,37.133333333333333,34.299999999999997,28.6,25.700000000000003,22.8,17.100000000000001,25]
[null,null,47.4,43.177777777777777,41.066666666666663,37.9,31.6,28.450000000000003,25.3,19,20]
[null,null,52.5,47.833333333333336,45.5,42,35,31.5,28,21,15]
[null,null,58.3,53.1,50.5,46.6,38.9,35,31.1,23.3,10,"resistance 0.10; puissance 21.27; "]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10,"tAmbiance 24; t2 30"]
[]
[null,35,0,0,0,0,0,0,0,0,30]
[null,null,51.7,48.233333333333334,46.5,43.9,38.799999999999997,36.200000000000003,33.6,28.4,30]
[null,null,57.1,53.277777777777779,51.366666666666667,48.5,42.8,39.950000000000003,37.1,31.4,25]
[null,null,63.2,59.022222222222219,56.93333333333333,53.8,47.4,44.25,41.1,34.799999999999997,20]
[null,null,70.099999999999994,65.433333333333337,63.1,59.6,52.5,49,45.5,38.5,15]
[null,null,77.7,61.722222222222221,63.43333333333333,66,58.3,54.4,50.5,42.7,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[0.15,null,15,16,17,18,20,21,22,24,"Ecartement"]
[null,27.5,0,0,0,0,0,0,0,0,30]
[null,null,28.249999999999996,25.227777777777774,23.716666666666669,21.450000000000003,16.950000000000003,14.700000000000003,12.450000000000003,7.9999999999999991,30]
[null,null,30.85,27.561111111111117,25.916666666666671,23.450000000000003,18.549999999999997,16.049999999999997,13.549999999999999,8.65,25]
[null,null,33.65,30.049999999999997,28.25,25.549999999999997,20.3,17.600000000000001,14.900000000000002,9.4999999999999982,20]
[null,null,36.800000000000004,32.911111111111111,30.966666666666669,28.049999999999997,22.15,19.200000000000003,16.250000000000004,10.35,15]
[null,null,40.349999999999994,40.511111111111113,36.566666666666677,30.650000000000006,24.100000000000005,20.925000000000001,17.75,11.200000000000001,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,30,0,0,0,0,0,0,0,0,30]
[null,null,33.9,30.877777777777776,29.366666666666667,27.1,22.6,20.350000000000001,18.100000000000001,13.6,30]
[null,null,37,33.711111111111116,32.06666666666667,29.6,24.7,22.2,19.7,14.8,25]
[null,null,40.4,36.799999999999997,35,32.299999999999997,27,24.3,21.6,16.2,20]
[null,null,44.2,40.288888888888891,38.333333333333336,35.4,29.5,26.55,23.6,17.7,15]
[null,null,48.4,44.088888888888889,41.933333333333337,38.700000000000003,32.200000000000003,29,25.8,19.3,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]
[]
[null,35,0,0,0,0,0,0,0,0,30]
[null,null,45.2,42.177777777777777,40.666666666666664,38.4,33.9,31.65,29.4,24.8,30]
[null,null,49.3,46.011111111111113,44.366666666666667,41.9,37,34.5,32,27.1,25]
[null,null,53.9,50.3,48.5,45.8,40.4,37.700000000000003,35,29.6,20]
[null,null,59,55.044444444444444,53.06666666666667,50.1,44.2,41.25,38.299999999999997,32.4,15]
[null,null,64.5,51.24444444444444,52.666666666666664,54.8,48.4,45.15,41.9,35.5,10]
[null,null,99999,99999,99999,99999,99999,99999,99999,99999,10]