{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFO","Method_input","Method_calculation","Method_output","History"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":28,"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":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Draft spreadsheet, according to template for all EPB standards "]
["Concerns EPB standard:"]
["ISO/DIS 10077-1, Thermal performance of windows, doors and shutters — Calculation of thermal transmittance — Part 1: General"]
["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"]
[]
[]
[]
[]
[]
["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":53,"n_cols":12,"rows_kept":53,"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","Source/Origin standard",null,"Origin needs to be checked for all inputs"]
["Geometrial characteristics of the product"]
["Width of the window","bW","b_w","m",1.23,null,null,null,"This is not a characteristic used in ISO 10077-1. It is defined in this spreadsheet for the calculation of AW."]
["Heigth of the window","hW","h_w","m",1.48,null,null,null,"This is not a characteristic used in ISO 10077-1. It is defined in this spreadsheet for the calculation of AW."]
["Width of the door","bD","b_d","m",1.48,null,null,null,"This is not a characteristic used in ISO 10077-1. It is defined in this spreadsheet for the calculation of AD."]
["Heigth of the door","hD","h_d","m",2.13,null,null,null,"This is not a characteristic used in ISO 10077-1. It is defined in this spreadsheet for the calculation of AD."]
["Witdth of the frame","bf","b_f","m",0.11,null,null,null,"This is not a characteristic used in ISO 10077-1. It is defined in this spreadsheet for the calculation of Af and lg, lp, lgb."]
["Frame Area (window)","Af","A_f","m2",{"$f":"A_w-A_g","v":0.54780000000000006},"0..20",null,"No",null,"Technical drawing"]
["Frame Area (door)","Af","A_f","m2",{"$f":"A_d-A_p","v":0.74579999999999957},"0..20",null,"No",null,"Technical drawing"]
["Glass Area","Ag","A_g","m2",{"$f":"(b_w-2*b_f)*(h_w-2*b_f)","v":1.2726},"0..20",null,"No",null,"Technical drawing"]
["Panel Area","Ap","A_p","m2",{"$f":"(b_d-2*b_f)*(h_d-2*b_f)","v":2.4066000000000001},"0..20",null,"No",null,"Technical drawing"]
["Window Area","AW","A_w","m2",{"$f":"b_w*h_w","v":1.8204},"0..20",null,"No",null,"Technical drawing"]
["Door Area","AD","A_d","m2",{"$f":"b_d*h_d","v":3.1523999999999996},"0..20",null,"No",null,"Technical drawing"]
["Visible length perimeter glass","lg","l_g","m",{"$f":"2*(b_w-2*b_f)+2*(h_w-2*b_f)","v":4.54},"0..50",null,"No","It is assumed a window with only a glazing","Technical drawing"]
["Visible length perimeter panel","lp","l_p","m",{"$f":"2*(b_d-2*b_f)+2*(h_d-2*b_f)","v":6.34},"0..50",null,"No","It is assumed a door with only a panel","Technical drawing"]
["Visible length glazing bar (Georgian bar)","lgb","l_gb","m",{"$f":"(b_w-2*b_f)+(h_w-2*b_f)","v":2.27},"0..50",null,"No","A single cross is assumed for the calcualtion","Technical drawing"]
[null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,"No"]
["Thermal characteristics of the componentes",null,null,null,null,null,null,"No"]
["Thermal transmittance frame","Uf","U_f","W/(m2K)",1.8,"0..10",null,"No",null,"EN ISO 10077-2 or EN 12412-2 or EN 10077-1 Annex"]
["Thermal transmittance glas","Ug","U_g","W/(m2K)",1.2,"0..10",null,"No",null,"Table C.1 in ISO 10077-1"]
["Thermal transmittance panel","Up","U_p","W/(m2K)",0.8,"0..10",null,"No",null,"EN ISO 6946 or EN ISO 10211"]
["Thermal transmittance window number n","Uwn","U_w1, U_w2","W/(m2K)",1.5,"0..10",null,"No",null,"EN ISO 10077-1 or EN ISO 12567-1"]
["Linear thermal transmittance frame/glas","Yfg","psi_fg","W/(m K)",0.04,"0..10",null,"No",null,"EN ISO 10077-1 or EN ISO 10077-2"]
["Linear thermal transmittance frame/panel","Yfp","psi_fp","W/(m K)",0.1,"0..10",null,"No",null,"EN ISO 10077-2  "]
["Linear thermal transmittance georgian bar","Ygb","psi_gb","W/(m K)",0.03,"0..10",null,"No",null,"EN ISO 10077-2  "]
["Thermal resistance of the cavity","Rs","R_s","(m2K)/W",0.17,"0..10",null,"No","Double Windows and coupled windows","EN ISO 10077-1 Annex"]
["Additional thermal resistance  of shutter (incl. Cavity)","DR","delta_r","(m2K)/W",0.17,"0..10",null,"No",null,"Table C.1 in ISO 10077-1"]
[null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,"No"]
["Operating and boundary conditions",null,null,null,null,null,null,"No"]
["External surface thermal resistance (vertical-30° inclination)","Rse","r_se","(m2K)/W",0.04,null,null,"No"]
["Internal surface thermal resistance (vertical-30° inclination)","Rsi","r_si","(m2K)/W",0.13,null,null,"No"]
["External surface thermal resistance (more than 30° inclination)","Rse","r_se","(m2K)/W",0.04,null,null,"No","Only used for the calculation of the design value of inclined windows"]
["Internal surface thermal resistance (more than 30° inclination)","Rsi","r_si","(m2K)/W",0.1,null,null,"No","Only used for the calculation of the design value of inclined windows"]
["Inclination of the window","a","alpha","°",null,null,null,null,null,null,null,"index sky not defined on OA level"]
[null,null,null,null,null,null,null,null,null,null,null,"index sky not defined on OA level"]
[]
[]
[]
[]
[]
[]
["Constants"]
["Thermal conductivity glas","lg","lambda_g","W/(m K)",1,"N/A",null,null,null,null,null,"What is the origin of the value?"]
[null,null,null,null,null,null,null,null,null,null,null,"What is the origin of the value?"]
[null,null,null,null,null,null,null,null,null,null,null,"What is the origin of the value?"]
[null,null,null,null,null,null,null,null,null,null,null,"Value given in national annex? Index sk is not defined at OA level. What is the origin of the value? Climate standard or national annex?"]

{"sheet":"Method_calculation","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["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","Formula ref","Formula","Notes"]
[]
[]
[]
[]
["Thermal transmittance of a single window","UW","W/(m2K)",{"$f":"(A_g*Method_calculation!U_g+A_f*U_f+l_g*psi_fg+l_gb*psi_gb)/(A_f+A_g)","v":1.5177213799165017},"(1)",null,"Thermal transmittance of a window with a transparent filling only."]
["Thermal transmittance of a double window","UW","W/(m2K)",{"$f":"1/(1/U_w_n-r_si+R_s-r_se+1/U_w_n)","v":0.75},"(3)",null,"Calculation of a double window consisting of two indiviual windows.For the example it is assumed that the two windows have the same UW value"]
["Thermal transmittance of the transparent part of a coupled window","Ug","W/(m2K)",{"$f":"1/(1/Method_calculation!U_g-r_si+R_s-r_se+1/Method_calculation!U_g)","v":0.6},"(4)",null,"Calculation of the Ug of a coupled window with two individual IGU.",null,{"$f":"Method_calculation!U_g","v":1.2}]
["Thermal transmittance of a window with a closed shutter","UWS","W/(m2K)",{"$f":"1/(1/U_w+delta_R)","v":1.2064436701116314},"(5)",null,"Window with shutter"]
["Thermal transmittance of a door","UD","W/(m2K)",{"$f":"(A_p*U_p+A_f_door*U_f+l_p*psi_fp)/(A_f_door+A_p)","v":1.2376982616419234},"(7)",null,"For this example Ag=0 and lg is assumed (only opaque panel)"]

{"sheet":"Method_output","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"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","Notes"]
["Thermal Transmittance"]
["Thermal trasmittance window","UW","U_W","W/(m2K)",{"$f":"U_w","v":1.5177213799165017},"0..10","EN 14351-1\nISO 52016-1","No"]
["Thermal trasmittance window with shutter","UWS","U_WS","W/(m2K)",{"$f":"Method_calculation!D11","v":1.2064436701116314},"0..10","EN 14351-1\nISO 52016-1","No"]
["Thermal trasmittance door","UD","U_D","W/(m2K)",{"$f":"Method_calculation!D12","v":1.2376982616419234},"0..10","EN 14351-1\nISO 52016-1","No"]

{"sheet":"History","index":4,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[null,"2014-05-15","Input, output variables"]
[null,"2015-05-15","Caluclation method added"]
[null,"2015-06-15","Final draft accompanying the draft FDIS, ready for distribution as CEN TEC 89 N document and for public distribution"]