{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pertes au dos","Calculs","Donnees"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":4,"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":"Pertes au dos","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7]]}
["Calculer les pertes au dos du plancher chauffant"]
[]
["Ce programme permet de calculer le % de 'Pertes au dos de l'émetteur' produites pour un Plancher chauffant"]
[]
["Type de plancher:"]
[]
["Température intérieure de consigne :",null,null,20,19]
["Température de la cave ou du vide ventilé éventuel :",null,null,10,"°C"]
["Température de surface du plancher chauffant :",null,null,28,"°C"]
[null,null,null,null,"(de 20°C a 28°C)"]
["Type de terrain ",null,null,1,"W/(m K)","(Renseigner seulement dans le cas de pertes sur sol)"]
["Température moyenne extérieure :",null,null,6,"°C","(Renseigner seulement dans le cas de pertes sur l'exterieur)"]
[]
["Caractéristiques du plancher :"]
[null,null,"Couche","Epaisseur [m]","Conductivité [W/mK]","Ressistance [m²K/W]"]
[null,null,"Chape",7.0000000000000007E-2,1.2]
[null,null,"Isolant",7.0000000000000007E-2,2.5000000000000001E-2]
[null,null,"Dalle de béton",0.15,2.1,0]
[]
["Emission utile dans le local :",null,{"$f":"Calculs!C15*(Calculs!D18-D7)","v":79.999999999999972},"W/m²"]
[]
["Pertes vers le bas :",null,{"$f":"Calculs!B8","v":9.1593065096499817},"W/m²"]
[]
["Pourcentage de perte vers le bas :",null,{"$f":"C22/(C20+C22)","v":0.10272967420017612}," % de la puissance totale"]

{"sheet":"Calculs","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Sur sol",null,null,"Cellule",3]
["Sur local non chauffé ou vide sanitaire"]
["Sur l'extérieur"]
["Perte vers les bas = "]
[null,null,null,"sol","lnc ou vs","ext"]
["Résistance vers le bas",{"$f":"INDEX(D6:F6,1,E1)","v":2.9114285714285719},"Résistance vers le bas",{"$f":"'Pertes au dos'!D17/'Pertes au dos'!E17+IF(ISERROR('Pertes au dos'!D18/'Pertes au dos'!E18),0,'Pertes au dos'!D18/'Pertes au dos'!E18)+'Pertes au dos'!F18+1/'Pertes au dos'!D11","v":3.8714285714285719},{"$f":"0.17+'Pertes au dos'!D17/'Pertes au dos'!E17+IF(ISERROR('Pertes au dos'!D18/'Pertes au dos'!E18),0,'Pertes au dos'!D18/'Pertes au dos'!E18)+'Pertes au dos'!F18","v":3.0414285714285718},{"$f":"0.04+'Pertes au dos'!D17/'Pertes au dos'!E17+IF(ISERROR('Pertes au dos'!D18/'Pertes au dos'!E18),0,'Pertes au dos'!D18/'Pertes au dos'!E18)+'Pertes au dos'!F18","v":2.9114285714285719}]
["U",{"$f":"1/B6","v":0.34347399411187435},"U",{"$f":"1/D6","v":0.2583025830258302},{"$f":"1/E6","v":0.32879286049788631},0.34347399411187435]
[null,{"$f":"INDEX(D8:F8,1,E1)","v":9.1593065096499817},"pertes W/m²",{"$f":"D7*(D18-10)","v":5.8548585485854838},{"$f":"E7*(D18-'Pertes au dos'!D8)","v":7.4526381712854226},{"$f":"F7*(D18-'Pertes au dos'!D12)","v":9.1593065096499817}]
["kequi reg all",{"$f":"INDEX(D9:F9,1,E1)","v":0.34347399411187435},null,{"$f":"1/('Pertes au dos'!D17/'Pertes au dos'!E17+IF(ISERROR('Pertes au dos'!D18/'Pertes au dos'!E18),0,'Pertes au dos'!D18/'Pertes au dos'!E18)+'Pertes au dos'!F18)","v":0.34825870646766166},{"$f":"E7","v":0.32879286049788631},{"$f":"F7","v":0.34347399411187435}]
[]
[null,null,"En faisant l'hypothèse que le sol est à ",null,null,"10°C à 1m de profondeur"]
[]
[null,"Puissance utile = "]
[null,"Rhaut",{"$f":"1/10+'Pertes au dos'!D16/'Pertes au dos'!E16","v":0.15833333333333335}]
[null,"k",{"$f":"1/C14","v":6.3157894736842097}]
[]
[]
[null,"T couche eau",null,{"$f":"(10*'Pertes au dos'!D9-10*'Pertes au dos'!D7+Calculs!C15*'Pertes au dos'!D7)/Calculs!C15","v":32.666666666666664}]

{"sheet":"Donnees","index":2,"n_rows":117,"n_cols":8,"rows_kept":117,"cut":false,"hidden":true,"merged":[]}
["hgf","ghg","gh"]
["Maison individuelle","Salon/ Salle à manger",19,null,null,"Usage habitation",null,"Dalle de béton"]
["Maison individuelle","Chambre 1",19,null,null,"Commerces et bureaux",null,"Plancher à entrevous"]
["Maison individuelle","Salle d'eau 1",21,null,null,"Hotels et pensions"]
["Maison individuelle","Couloir 1",19,null,null,"Enseignement"]
["Maison individuelle","Cuisine 1",19]
["Maison individuelle","Buanderie",21]
["Maison en bande","Salon/ Salle à manger",19]
["Maison en bande","Chambre 1",19]
["Maison en bande","Salle d'eau 1",21]
["Maison en bande","Couloir 1",19]
["Maison en bande","Cuisine 1",19]
["Maison en bande","Buanderie",21]
["Maison en bande","Entrée",20]
["Maison en bande","Zone commune",20]
["Maison en bande","Escaliers 1",20,null,null,"Grave"]
["Logements collective","Salon/ Salle à manger",19,null,null,"Sable semi-dense"]
["Logements collective","Chambre 1",19,null,null,"Limon"]
["Logements collective","Salle d'eau 1",21,null,null,"Argile semi-dure"]
["Logements collective","Couloir 1",19,null,null,"Roche molle"]
["Logements collective","Cuisine 1",19,null,null,"Sable dense"]
["Logements collective","Buanderie",21,null,null,"Sable lâche"]
["Logements collective","Entrée",20,null,null,"Argile dure"]
["Logements collective","Zone commune",20,null,null,"Argille mole"]
["Logements collective","Escaliers 1",20,null,null,"Roche dure"]
["Logements collective","Bureau 1",21]
["Logements collective","Toilettes",21]
["Commerces et bureaux","Bureau 1",21]
["Commerces et bureaux","Bureau 2",21]
["Commerces et bureaux","Salle de reunions",21]
["Commerces et bureaux","Salle des fêtes",21]
["Commerces et bureaux","salle de cours",21]
["Commerces et bureaux","Salle de repos",21]
["Commerces et bureaux","Vestibule d'entrée",21]
["Commerces et bureaux","Cuisine 2",19]
["Commerces et bureaux","Salle à manger",21]
["Commerces et bureaux","Cafétéria",21]
["Commerces et bureaux","Toilettes",21]
["Commerces et bureaux","Escaliers 2",20]
["Commercial","Escaliers 2",20]
["Commercial","Bureau 1",21]
["Commercial","Toilettes",21]
["Commercial","Salle à manger",21]
["Commercial","Cafétéria",21]
["Bureaux administratives","Bureau 1",21]
["Bureaux administratives","Bureau 2",21]
["Bureaux administratives","Salle de reunions",21]
["Bureaux administratives","Salle des fêtes",21]
["Bureaux administratives","salle de cours",21]
["Bureaux administratives","Salle de repos",21]
["Bureaux administratives","Vestibule d'entrée",21]
["Bureaux administratives","Cuisine 2",19]
["Bureaux administratives","Salle à manger",21]
["Bureaux administratives","Cafétéria",21]
["Bureaux administratives","Toilettes",21]
["Bureaux administratives","Escaliers 2",20]
["Hotels et pensions","Chambre 2",21]
["Hotels et pensions","Dégagement",21]
["Hotels et pensions","Salle de bain",21]
["Hotels et pensions","Salon/ Salle à manger",21]
["Hotels et pensions","Cuisine 1",19]
["Hotels et pensions","Réception",21]
["Hotels et pensions","Couloir 2",21]
["Hotels et pensions","Salle à manger",21]
["Hotels et pensions","Cafétéria",21]
["Hotels et pensions","Salle de reunions",21]
["Hotels et pensions","Salle de lecture",21]
["Hotels et pensions","Gymnase 1",21]
["Hotels et pensions","Escaliers 2",20]
["Hotels et pensions"," Toilettes",21]
["Hotels et pensions","Cuisine 2",19]
["Hotels et pensions","Bureau 1",21]
["Parking","Bureau 1",21]
["Parking","Toilettes",21]
["Affluence publique","Bureau 1",21]
["Affluence publique","Toilettes",21]
["Affluence publique","Local de sport",21]
["Affluence publique","Salle d'embarquement",21]
["Enseignement","Salle de cours",21]
["Enseignement","Salle de musique",21]
["Enseignement","Laboratoire",21]
["Enseignement","Atelier",21]
["Enseignement","Garderie",21]
["Enseignement","Bibliothèque",21]
["Enseignement","Salle des fêtes",21]
["Enseignement","Cafétéria",21]
["Enseignement","Salle à manger",21]
["Enseignement","Gymnase 2",21]
["Enseignement","Vestiaires",21]
["Enseignement","Infirmerie",21]
["Enseignement","Salle polyvalente",21]
["Enseignement","Bureau 2",21]
["Enseignement","Salle de professeurs",21]
["Enseignement","Zone administrative",21]
["Enseignement","Toilettes",21]
["Enseignement","Escaliers 2",20]
["Enseignement","Cuisine 1",19]
["Hospitalier","Vestibule d'entrée",21]
["Hospitalier","Salle d'attente",21]
["Hospitalier","Toilettes",21]
["Hospitalier","Infirmerie",21]
["Hospitalier","Salle de consultation medicale",21]
["Hospitalier","Salle de traitement médical",21]
["Hospitalier","Bloc opératoire",21]
["Hospitalier","Chambre d'hôpital",21]
["Hospitalier","Salle d'eau 2",21]
["Hospitalier","Cafétéria",21]
["Hospitalier","Salle à manger",21]
["Hospitalier","Bureau 2",21]
["Hospitalier","Zone administrative",21]
["Hospitalier","Salle de repos",21]
["Hospitalier","Laboratoire",21]
["Hospitalier","Escaliers 2",20]
["Hospitalier","Cuisine 2",19]
["Hospitalier","Vestiaires",21]
["Industriel","Bureau 1",21]
["Industriel","Toilettes",21]