{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFO","Method_input","Method_calculation","Method_output","History"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":1,"defined_names":6,"comments":2,"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":"INFO","index":0,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Draft spreadsheet, according to template for all EPB standards "]
["Concerns EPB standard:"]
["ISO/DIS 13370,Thermal performance of buildings — Heat transfer via the ground — Calculation methods"]
["Produced by the Project Leader for the preparation of this standard"]
[]
["DISCLAIMER:"]
["·         This spreadsheet has been developed in the framework of the preparation and revision of the set of EN or ISO standards on the energy performance of buildings, to support the European \"Energy Performance of Buildings Directive\" recast (EPBD-recast, directive 2010/31/EU). "]
["·         It is meant for use by CEN and ISO technical committee(s) and the working group(s) working on the preparation or revision of the EPB-standard to which this spreadsheet applies. The spreadsheet supports checking  that all equations in the developed standard are consistent and can be linked with other relevant standards. It is not meant to perform a full or partial energy performance calculation."]
["·         The spreadsheet supports the expert user of the standards, in particular those who want to review the content of the standard and those who want to translate the standard to a software, to understand the correct interpretation of the equations and calculation steps in the standard."]
["·         Although it has been developed with care, neither the technical committee(s), nor the working group(s) and experts related to the EPB- standard to which this spreadsheet applies warrant that the calculations and procedures in this spreadsheet are free of errors. The technical committees as well as the working groups and their respective members expressly disclaim any liability or responsibility arising from use of this spreadsheet, or any consequences thereof. Any responsibility arising from the use of this spreadsheet lies with the user."]
["DRAFT VERSION:"]
["·         As long as the associated EPB standard or any of the other EPB standards to which it is directly linked are in a draft stage, this spreadsheet is also a draft version only."]
["WARNINGS: "]
["·         Note that the spreadsheet may not allow testing all calculation options that are possible according to the standard to which it applies. This remark applies in particular but not only to limitations on the number instances of a variable that can be considered. "]
["·         In case of differences, the standard should be regarded as the reference, not the spreadsheet. However, during the standard's drafting phase, shortcomings in the draft standard may have been detected and dealt with in the spreadsheets (ideally, such differences are marked)."]
["·         Note also that these spreadsheets are purely intended for testing and demonstration and therefore not aiming to be user friendly or to be protected against wrong or improper use. "]
["TERMS OF USE:"]
["·         The user is not allowed to redistribute a modified version of this spreadsheet."]
["·         The author(s) would appreciate your feed back on the spreadsheet via the comment sheets for the associated draft standard to be prepared by the national standards bodies during enquiry of the draft standard(s),"]
[]
[]
["SCOPE OF THIS SPREADSHEET:"]
["THIS SPREADSHEET PROVIDES ONE CALCULATION EXAMPLE PROVIDING 12 MONTHLY VALUES (FULL YEAR)"]
["THE OUTPUT IS SUITED TO THE INPUT FOR e.g.: "]
["- CALCULATION OF THE OVERALL (SEASONAL) THERMAL TRANSMITTANCE OF A BUILDING"]
["- CALCULATION OF ENERGY NEEDS FOR HEATING AND COOLING (MONTHLY METHOD)"]
["- CALCULATION OF ENERGY NEEDS FOR HEATING AND COOLING (HOURLY METHOD)"]
[]
[]
[]
[]
[]
["For those responsible for the drafting of this spreadsheet on the accompanying EPB standard"]
["Intended use of this document\nThose responsible for the drafting of actual individual EPB standards shall\n-  read and understand the following documents\n   - EN/TS 16628 Basic Principles (in short \"BP\")\n   - EN/TS 16629 Detailed Technical Rules (in short \"DTR\")\n   - Most recent draft of ISO 52000-1 cq EN 15603 (\"Overarching Standard\", in short \"OA\"))\n   - Most recent draft of ISO/TR 52000-2 cq EN/TR 15615 Technical report to overarching standard;\n- Prepare their individual EPB standard according to CEN rules, BP, DTR and OA\n- Prepare the accompanying technical report using the dedicated template\n- Prepare an accompanying XLS spreadsheet, to demonstrate inputs, output and calculation chain.\n\nThis sample excel spreadsheet provides a template to help in this task."]
["Why an Excel spreadsheet?\n\nTo demonstrate the validity and required data I/O for the calculation procedure defined in the standard:\n- list of all input needed --> sheet \"Method_input\"\n- list of intended output --> sheet  \"Method_output\"\n- calculation sequence --> sheet  \"Method_calculation\""]
["Method_input\nList in this sheet all the input required for the calculation in one time step.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE REQUIRED DATA INPUT."]
["Method_calculation\nDetail in this sheet your calculation procedure. There should be one calculation in one cell for each equation in the standard.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE CALCULATION PROCEDURE."]
["Method_output\nList in this sheet all the intended output of the procedure.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE AVAILABLE DATA OUTPUT."]

{"sheet":"Method_input","index":1,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["THIS IS A MANDATORY SHEET\nAll input data for the method shall be listed here.\nIn the simplest version, values for data input in column D (both green and blue background) may be inserted manually.\nVarying data (green background) can be fed from the \"input_series\" sheet.\nIn this sample data sheet, product data (blue background) is linked to a sample catalogue built in the \"Detailed_input\" sheet"]
[]
[]
["Name","Symbol","Software name","Unit","Value","Range","Origin","Varying","Notes"]
["Identifiers for building geometric characteristics"]
["Area of floor","A","A","m2",100,"0...∞",null,"No","For the part of the building being assessed"]
["Exposed perimeter","P","P","m",40,"0...∞",null,"No","For the part of the building being assessed"]
[]
["Thickness of the walls of the building","Dw;e","D_w_e","m",0.3,"0...∞",null,"No"]
["Height of the upper surface of the floor above external ground level","h","h","m",null,"0...∞",null,"No"]
["Depth of basement floor below ground level","z","z","m",null,"0...∞",null,"No"]
[]
["Identifiers for thermal characteristics of building fabric"]
[]
["Linear thermal transmittance associated with wall/floor junction","Ψwf","psi_wf","W/(m.K) ",0.05,"0…10","ISO 14683 or ISO 10211","No"]
["Thermal resistance of the floor construction (excluding the effect of the ground)","Rf","R_f","(m2.K)/W ",2.5,"0...10","ISO 13370","No"]
["Thermal conductivity of ground","λ","lambda_g","W/(m.K) ",2,"0...10","ISO 13370, Table 8","No","Default value (ISO 13370 Table 9)"]
["Thermal capacity of ground per volume","ρc","Rhoc","J/(m³·K)",{"$f":"2*10^6","v":2000000},"1...4 E+06","ISO 13370, Table 8","No","Default value (ISO 13370 Table 9)"]
["Periodic penetration depth","d ","delta","m",3.2,"0...10","ISO 13370 Annex H","No","Default value (ISO 13370 Table H.1)"]
[]
[]
["Identifiers for tabulated and conventional values"]
["external surface resistance","Rse","R_s_e","(m2×K)/W",0.04,"N/A","ISO 6946 Annex C","No","Default value (ISO 6946 Table 9)"]
["internal surface resistance","Rsi","R_s_i","(m2×K)/W",0.17,"0.1…0,17","ISO 6946 Annex C","No","Default value (ISO 6946 Table 9)"]
[]
[]
["Identifiers for constants"]
["specific heat capacity of air at constant pressure","cp","c_p","J/(kg·K)",1008,null,"ISO 13370","No","Default value (ISO 13370 Table 8)"]
[]
["Identifiers for periodic heat flows"]
["time lead of the heat flow cycle compared with that of the internal temperature","a","alpha","months",0,"0…6","ISO 13370 Annex H","No","Default value (ISO 13370 Table H2)"]
["time lag of the heat flow cycle compared with that of the external temperature","b","beta","months",1,"0…6","ISO 13370 Annex H","No","Default value (ISO 13370 Table H2)"]
["month number in which the minimum external temperature occurs ","t","tau","-",1,"1 or 7","ISO 13370 Annex C","No","tau = 1 in the northern hemisphere and tau = 7 in the southern hemisphere"]
["annual mean internal temperature",null,"theta_int_an","°C",20,"-50…+50","ISO 52016-1","No","Typically: the average between heating and cooling set point; see also next line (amplitude)"]
["amplitude of internal temperature variations",null,"theta_int_amp","K",2,"-50…+50","ISO 52016-1","No","= Half of the difference between the expected monthly max (e.g.: cooling set point) and monthly min (e.g.: heating set point)"]
["annual mean external temperature",null,"theta_e_an","°C",10,"-50…+50","ISO 52016-1","No","Should match the annual mean value of the monthly mean outdoor temperature; see also next line (amplitude)"]
["amplitude of external temperature variations",null,"theta_e_amp","K",12,"-50…+50","ISO 52016-1","No","= Half of the difference between the highest and the lowest monthly mean outdoor temperature"]

{"sheet":"Method_calculation","index":2,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,17,26,21],[0,0,0,17],[16,0,16,15],[20,15,23,15],[20,16,23,16],[20,17,23,17],[3,5,3,6],[25,17,25,21]]}
["THIS IS A MANDATORY SHEET\nOne time step calculation shall be described here.\nFor each calculation step (= 1 row) data for the formula in column D shall be taken from the \"Method_input\" sheet or previous calculation steps.\nInclude in the column \"Formula ref\" its number in the standard text. The example is based on EN 15316-4-1:2008\nCopy and paste a copy of the equation into column \"Formula\"\nUse the column note for information on the calculation"]
[]
["Description","Symbol","Unit","Value",null,"Notes",null,null,null,null,null,null,null,null,null,"Formula ref","Formula","Notes"]
[null,null,null,null,null,"See also:\nColumn P: formula reference\nColumn Q: copy of the formula\nColumn R: Notes"]
["Characteristic dimension of floor","B","m",{"$f":"Method_input!E6/(0.5*Method_input!E7)","v":5},null,null,null,null,null,null,null,null,null,null,null,"Formula 2"]
["Equivalent thickness of ground",null,"m",{"$f":"Method_input!E9+Method_input!E17*(Method_input!E24+Method_input!E16+Method_input!E23)","v":5.72},null,null,null,null,null,null,null,null,null,null,null,"Formula 3"]
["Thermal transmittance, including the effect of the ground\nIf df;sog < B (uninsulated and moderately insulated floors):","Uf;sog","W/(m².K)",{"$f":"((2*Method_input!E17)/((PI()*D5+D6))*LN((PI()*D5/D6)+1))","v":0.24654288266266219},null,null,null,null,null,null,null,null,null,null,null,"Formula 4"]
["Thermal transmittance, including the effect of the ground\nIf df;sog > B (well-insulated floors):","Uf;sog","W/(m².K)",{"$f":"(Method_input!E17)/(0.457*D5+D6)","v":0.24984384759525299},null,null,null,null,null,null,null,null,null,null,null,"Formula 5"]
["Applicable in this case","Uf;sog","W/(m².K)",{"$f":"IF(D6<D5,D7,D8)","v":0.24984384759525299},null,null,null,null,null,null,null,null,null,null,null,"Formula 4 or Formula 5"]
["Effective thermal resistance of floor construction (including the effect of the ground)","Rf;eff","m²·K/W",{"$f":"1/D9-Method_input!E24","v":3.8324999999999996},null,null,null,null,null,null,null,null,null,null,null,"Formula 20 (rev)","DIS: Rf;eff = Rf + Rg + Rv \nImproved: Rf;eff = 1/U – Rsi","This is an improvement compared to the DIS: simpler, more direct formula (result is the same)"]
["Steady state heat transfer coefficient","Hg","W/K",{"$f":"Method_input!E6*D9+Method_input!E7*Method_input!E15","v":26.984384759525298},null,null,null,null,null,null,null,null,null,null,null,"Formula 1",null,"Note: this quantity includes both the annual-average effect of the ground and the linear perimeter heat transfer."]
["periodic heat transfer coefficient related to internal temperature variations ","Hpi","W/K",{"$f":"Method_input!E6*Method_input!E17/D6*SQRT(2/((1+Method_input!E19/D6)^2+1))","v":26.692208501718127},null,null,null,null,null,null,null,null,null,null,null,"Formula H.4"]
["Periodic heat transfer coefficient related to external temperature variations ","Hpe","W/K",{"$f":"0.37*Method_input!E7*Method_input!E17*LN(Method_input!E19/D6+1)","v":13.152083379526262},null,null,null,null,null,null,null,null,null,null,null,"Formula H.5"]
["The thermal resistance of 0,5 m of ground","Rg","m²·K/W",{"$f":"0.5/Method_input!E17","v":0.25}]
["The thermal capacity of 0,5 m of ground","κg","J/(m²·K)",{"$f":"0.5*Method_input!E18","v":1000000}]
["Thermal resistance of virtual layer","Rve","m2K/W",{"$f":"1/D9-Method_input!E24-Method_input!E16-D14","v":1.0824999999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: this quantity includes the annual-average effect of the ground on the transmission; the linear perimeter heat transfer is not included: this is included in theta_v"]
["Varying outputs : time step is one month : data shown for ach month"]
["month number","m","-",1,{"$f":"+D18+1","v":2},{"$f":"+E18+1","v":3},4,5,6,7,8,9,10,11,{"$f":"+N18+1","v":12}]
["internal temperature in month m ","qint,m","°C",{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(D18-Method_input!$E$33)/12)","v":18},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(E18-Method_input!$E$33)/12)","v":18.267949192431121},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(F18-Method_input!$E$33)/12)","v":19},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(G18-Method_input!$E$33)/12)","v":20},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(H18-Method_input!$E$33)/12)","v":21},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(I18-Method_input!$E$33)/12)","v":21.732050807568879},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(J18-Method_input!$E$33)/12)","v":22},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(K18-Method_input!$E$33)/12)","v":21.732050807568879},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(L18-Method_input!$E$33)/12)","v":21},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(M18-Method_input!$E$33)/12)","v":20},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(N18-Method_input!$E$33)/12)","v":19},{"$f":"Method_input!$E$34-Method_input!$E$35*COS(2*PI()*(O18-Method_input!$E$33)/12)","v":18.267949192431125},"Formula C.1"]
["external temperature in month m ","qe,m","°C",{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(D18-Method_input!$E$33)/12)","v":-2},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(E18-Method_input!$E$33)/12)","v":-0.39230484541326405},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(F18-Method_input!$E$33)/12)","v":3.9999999999999982},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(G18-Method_input!$E$33)/12)","v":10},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(H18-Method_input!$E$33)/12)","v":15.999999999999996},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(I18-Method_input!$E$33)/12)","v":20.392304845413264},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(J18-Method_input!$E$33)/12)","v":22},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(K18-Method_input!$E$33)/12)","v":20.392304845413264},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(L18-Method_input!$E$33)/12)","v":16.000000000000007},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(M18-Method_input!$E$33)/12)","v":10.000000000000002},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(N18-Method_input!$E$33)/12)","v":3.9999999999999982},{"$f":"Method_input!$E$36-Method_input!$E$37*COS(2*PI()*(O18-Method_input!$E$33)/12)","v":-0.39230484541326049},"Formula C.2"]
["annual average rate of heat flow","Fsteady;m","W",{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},{"$f":"$D$11*(Method_input!$E$34-Method_input!$E$36)","v":269.84384759525301},"Formula C.3"]
["periodic heat flow due to internal temperature variation","Fper;int;m","W",{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(D18-Method_input!$E$33+Method_input!$E$31)/12)","v":-53.384417003436255},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(E18-Method_input!$E$33+Method_input!$E$31)/12)","v":-46.232261291197737},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(F18-Method_input!$E$33+Method_input!$E$31)/12)","v":-26.692208501718135},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(G18-Method_input!$E$33+Method_input!$E$31)/12)","v":-3.2701918003978696E-15},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(H18-Method_input!$E$33+Method_input!$E$31)/12)","v":26.692208501718117},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(I18-Method_input!$E$33+Method_input!$E$31)/12)","v":46.232261291197737},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(J18-Method_input!$E$33+Method_input!$E$31)/12)","v":53.384417003436255},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(K18-Method_input!$E$33+Method_input!$E$31)/12)","v":46.232261291197744},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(L18-Method_input!$E$33+Method_input!$E$31)/12)","v":26.692208501718152},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(M18-Method_input!$E$33+Method_input!$E$31)/12)","v":9.8105754011936083E-15},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(N18-Method_input!$E$33+Method_input!$E$31)/12)","v":-26.692208501718135},{"$f":"-$D$12*Method_input!$E$35*COS(2*PI()*(O18-Method_input!$E$33+Method_input!$E$31)/12)","v":-46.232261291197723}]
["periodic heat flow due to external temperature variation","Fper;e;m","W",{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(D18-Method_input!$E$33-Method_input!$E$32)/12)","v":136.68045983233003},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(E18-Method_input!$E$33-Method_input!$E$32)/12)","v":157.82500055431515},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(F18-Method_input!$E$33-Method_input!$E$32)/12)","v":136.68045983233003},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(G18-Method_input!$E$33-Method_input!$E$32)/12)","v":78.912500277157591},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(H18-Method_input!$E$33-Method_input!$E$32)/12)","v":9.6679527787535658E-15},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(I18-Method_input!$E$33-Method_input!$E$32)/12)","v":-78.912500277157548},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(J18-Method_input!$E$33-Method_input!$E$32)/12)","v":-136.68045983233003},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(K18-Method_input!$E$33-Method_input!$E$32)/12)","v":-157.82500055431515},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(L18-Method_input!$E$33-Method_input!$E$32)/12)","v":-136.68045983233006},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(M18-Method_input!$E$33-Method_input!$E$32)/12)","v":-78.912500277157648},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(N18-Method_input!$E$33-Method_input!$E$32)/12)","v":-2.9003858336260697E-14},{"$f":"$D$13*Method_input!$E$37*COS(2*PI()*(O18-Method_input!$E$33-Method_input!$E$32)/12)","v":78.912500277157591}]
["average rate of heat flow in month m ","Fm","W",{"$f":"D21+D22+D23","v":353.13989042414676},{"$f":"E21+E22+E23","v":381.43658685837045},379.8320989258649,348.75634787241063,296.53605609697115,237.16360860929319,186.54780476635926,158.2511083321356,159.85559626464109,190.93134731809536,243.15163909353484,302.52408658121288]
["virtual temperature in ground  in month m ","qv,m","°C",{"$f":"D19-D24/(Method_input!$E$6*$D9)","v":3.8655758857735272},{"$f":"E19-E24/(Method_input!$E$6*$D9)","v":3.0009498034248452},{"$f":"F19-F24/(Method_input!$E$6*$D9)","v":3.7972202404922584},{"$f":"G19-G24/(Method_input!$E$6*$D9)","v":6.0410271764067662},{"$f":"H19-H24/(Method_input!$E$6*$D9)","v":9.1311443547187299},{"$f":"I19-I24/(Method_input!$E$6*$D9)","v":12.23957737298192},{"$f":"J19-J24/(Method_input!$E$6*$D9)","v":14.53342411422647},{"$f":"K19-K24/(Method_input!$E$6*$D9)","v":15.398050196575152},{"$f":"L19-L24/(Method_input!$E$6*$D9)","v":14.601779759507741},{"$f":"M19-M24/(Method_input!$E$6*$D9)","v":12.357972823593233},{"$f":"N19-N24/(Method_input!$E$6*$D9)","v":9.2678556452812693},{"$f":"O19-O24/(Method_input!$E$6*$D9)","v":6.1594226270180794},"Formula F.2"]
["ground heat transfer coefficient in month m adjusted to monthly temp.diff. (See comment in column R)","Hg,m","W/K",{"$f":"D24/(D19-D20)","v":17.656994521207338},{"$f":"E24/(E19-E20)","v":20.44112508247683},25.322139928390989,34.875634787241061,59.30721121939419,177.02132740725224,{"$error":"#DIV/0!"},118.12023532992323,31.971119252928265,19.093134731809538,16.210109272902322,16.212216938079809,"Formula C.10",null,"According to DIS. However, this quantity appears unsuited, because the monthly ground heat flow is not related to the monthly temp.difference. This leads to extreme values (including division by zero). \nProposed improved formula: see next row"]
["ground heat transfer coefficient related to annual temperature difference, in month m ","Hg,an,m","W/K",{"$f":"D24/(Method_input!$E$34-Method_input!$E$36)","v":35.313989042414676},{"$f":"E24/(Method_input!$E$34-Method_input!$E$36)","v":38.143658685837046},{"$f":"F24/(Method_input!$E$34-Method_input!$E$36)","v":37.983209892586487},{"$f":"G24/(Method_input!$E$34-Method_input!$E$36)","v":34.875634787241061},{"$f":"H24/(Method_input!$E$34-Method_input!$E$36)","v":29.653605609697117},{"$f":"I24/(Method_input!$E$34-Method_input!$E$36)","v":23.716360860929321},{"$f":"J24/(Method_input!$E$34-Method_input!$E$36)","v":18.654780476635928},{"$f":"K24/(Method_input!$E$34-Method_input!$E$36)","v":15.825110833213561},{"$f":"L24/(Method_input!$E$34-Method_input!$E$36)","v":15.985559626464109},{"$f":"M24/(Method_input!$E$34-Method_input!$E$36)","v":19.093134731809535},{"$f":"N24/(Method_input!$E$34-Method_input!$E$36)","v":24.315163909353483},{"$f":"O24/(Method_input!$E$34-Method_input!$E$36)","v":30.25240865812129},"Formula C.10\n(rev)",null,"This is an improvement compared to the DIS, based on validation of the links with ISO/DIS 52016-1 (monthly and hourly calculation of energy need for heating and cooling"]
["Monthly temperature difference","(qint;m - qe;m)","K",{"$f":"D19-D20","v":20},18.660254037844386,15.000000000000002,10,5.0000000000000036,1.3397459621556145,0,1.3397459621556145,4.9999999999999929,9.9999999999999982,15.000000000000002,18.660254037844386]
["Per season (for overall Htr)",null,null,"Heating season","Cooling season","Hemisphere"]
["Ground heat transfer coefficient for H resp. C, related to annual average temp.difference","Hg;H/C \n(related to annual average temp.diff.)","W/K",{"$f":"+(SUM(D27:O27)-IF(Method_calculation!E34>5,SUM(M27:O27)+SUM(D27:F27),SUM(G27:L27)))/6","v":30.850260820020413},{"$f":"+SUM(D27:O27)/6-D30","v":23.118508699030183},{"$f":"+IF(Method_input!$E$33<6,\"Northern hemisphere\", \"Southern hemisphere\")","v":"Northern hemisphere"}]
["Seasonal temperature difference","(qint;m - qe;m)mn;H/C","K",{"$f":"+(SUM(D28:O28)-IF(Method_input!E33>5,SUM(M28:O28)+SUM(D28:F28),SUM(G28:L28)))/6","v":16.220084679281459},{"$f":"+SUM(D28:O28)/6-D31","v":3.779915320718537},{"$f":"+IF(Method_input!$E$33<6,\"Northern hemisphere\", \"Southern hemisphere\")","v":"Northern hemisphere"}]
["Ground heat transfer coefficient for H resp. C, adjusted to seasonal average temp.difference","Hg;H/C;adj \n(adjusted to seas. temp.diff.)","W/K",{"$f":"+D30*(Method_input!E34-Method_input!E36)/D31","v":19.019790235390474},{"$f":"+D30*(Method_input!$E$34-Method_input!$E$36)/E31","v":81.616274975588553},{"$f":"+IF(Method_input!$E$33<6,\"Northern hemisphere\", \"Southern hemisphere\")","v":"Northern hemisphere"}]

{"sheet":"Method_output","index":3,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["THIS IS A MANDATORY SHEET\nOutput of one step calculation shall be indicated here.\nEach cell in the column value shall be a reference to a single cell in the \"Method_calculation\" sheet.\nThe macro will take the calculation step results and fill the values table in the \"Output_series\" sheet."]
[]
[]
["Name","Symbol","Software name","Unit","Value","Range","Intended destination","Varying",null,null,null,null,null,null,null,null,"Notes"]
["Thermal transmittance of slab on ground floor","Uf;sog","U_f_sog","W/(m2·K)",{"$f":"Method_calculation!$D$9","v":0.24984384759525299},"0…∞","M 2-5","No"]
["Thermal transmittance of suspended floor ","Uf",null,"W/(m2·K)",null,"0…∞","M2-5","No"]
["Thermal transmittance of basement wall","Uw;b",null,"W/(m2·K)",null,"0…∞","M2-5","No"]
["Thermal transmittance of basement floor","Uf;b",null,"W/(m2·K)",null,"0…∞","M2-5","No"]
["Thermal transmittance of the whole basement ","Ub",null,"W/(m2·K)",null,"0…∞","M2-5","No"]
["Effective thermal resistance of floor construction (including the effect of the ground)","Rf;eff","R_f_eff","m2K/W",{"$f":"Method_calculation!D10","v":3.8324999999999996},"0…∞","M2-5","No"]
["Thermal resistance of suspended floor","Rf",null,"m2K/W",null,"0…∞","M2-5","No"]
["Thermal resistance of basement wall","Rw;b",null,"m2K/W",null,"0…∞","M2-5","No"]
["Thermal resistance of basement floor","Rf;b",null,"m2K/W",null,"0…∞","M2-5","No"]
["Thermal resistance of the whole basement","Rf;b",null,"m2K/W",null,"0…∞","M2-5","No"]
["Ground heat transfer coefficient for heating, adjusted to seasonal average temp.difference","Hg;H;adj ","H_g_H_adj","W/K",{"$f":"Method_calculation!D32","v":19.019790235390474},"0…∞","M2-5","No"]
["Ground heat transfer coefficient for cooling adjusted to seasonal average temp.difference","Hg;C;adj ","H_g_C_adj","W/K",{"$f":"Method_calculation!E32","v":81.616274975588553},"0…∞","M2-5","No"]
["The thermal resistance of 0,5 m of ground","Rg","R_g","m²·K/W",{"$f":"Method_calculation!D14","v":0.25},"0…∞","M2-5","No"]
["The thermal capacity of 0,5 m of ground","κg","kappa_g","J/(m²·K)",{"$f":"Method_calculation!D15","v":1000000},"0…∞","M2-5","No"]
["Thermal resistance of virtual layer","Rve;m","R_ve_m","m2K/W",{"$f":"Method_calculation!D16","v":1.0824999999999996},"0…∞","M2-5","No"]
[]
["Monthly values"]
["month number","m","m","-",1,{"$f":"+E22+1","v":2},{"$f":"+F22+1","v":3},4,5,6,7,8,9,10,11,{"$f":"+O22+1","v":12}]
[" virtual temperature in ground in month m  ","qv,m","theta_v_m","°C",{"$f":"Method_calculation!D25","v":3.8655758857735272},{"$f":"Method_calculation!E25","v":3.0009498034248452},{"$f":"Method_calculation!F25","v":3.7972202404922584},{"$f":"Method_calculation!G25","v":6.0410271764067662},{"$f":"Method_calculation!H25","v":9.1311443547187299},{"$f":"Method_calculation!I25","v":12.23957737298192},{"$f":"Method_calculation!J25","v":14.53342411422647},{"$f":"Method_calculation!K25","v":15.398050196575152},{"$f":"Method_calculation!L25","v":14.601779759507741},{"$f":"Method_calculation!M25","v":12.357972823593233},{"$f":"Method_calculation!N25","v":9.2678556452812693},{"$f":"Method_calculation!O25","v":6.1594226270180794}]
["ground heat transfer coefficient related to annual temperature difference, in month m ","Hg,an,m","H_g_an_m","W/K",{"$f":"Method_calculation!D27","v":35.313989042414676},{"$f":"Method_calculation!E27","v":38.143658685837046},{"$f":"Method_calculation!F27","v":37.983209892586487},{"$f":"Method_calculation!G27","v":34.875634787241061},{"$f":"Method_calculation!H27","v":29.653605609697117},{"$f":"Method_calculation!I27","v":23.716360860929321},{"$f":"Method_calculation!J27","v":18.654780476635928},{"$f":"Method_calculation!K27","v":15.825110833213561},{"$f":"Method_calculation!L27","v":15.985559626464109},{"$f":"Method_calculation!M27","v":19.093134731809535},{"$f":"Method_calculation!N27","v":24.315163909353483},{"$f":"Method_calculation!O27","v":30.25240865812129}]

{"sheet":"History","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2014.06.04","First draft version (internal)"]
[null,"2014.11.26","Updated draft version (internal)","Calculation repeated to cover 12 months"]
[null,"2015.04.22.","Embedded in ISO/DIS 52016-1 spreadsheet (ISO/TC163/SC 2 N document, for public distribution)","Adapted and integrated in spreadsheet of ISO/DIS 52016-1"]
[null,"2015.06.03","ISO/TC163/SC 2 N document, for public distribution","Version embedded in spreadsheet of ISO/DIS 52016-1 reviewed and used as basis for this stand alone version (including few corrections)"]