{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Disclaimer","INFO","Data_catalogue_example","Input_series","Method_input","Method_calculation","Method_output","Output_series","History"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":21,"comments":3,"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":"Disclaimer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INFO","index":1,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Intended use of this document\nThose responsible for the drafting of actual individual EPB standards shall\n-  read and understand the following documents\n   - prCEN/TS 16628 Basic Principles (in short \"BP\")\n   - prCEN/TS 16629 Detailed Technical Rules (in short \"DTR\")\n   - prEN 15603:2013 (\"Overarching Standard\", in short \"OA\"))\n   - prCEN/TR 15615:2013 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 spradsheet?\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\""]
["The example is prepared for a simple procedure. The sheet calculation may need extensions such as:\n- using several columns when operating on arrays\n- refering to a subset of sheets input/calculation/output to describe a subroutine\nFor complex tasks MACRO can be used.\n\nThis sheet does not support calculation methods that take into account data in a different time-step than that that is being calculated. A version that allows taking into account values at previous time step will be developed."]
["LIST OF AVAILABLE SHEETS"]
["Simplified_input_correlation\nUse this sheet to demontrate simplified input correlation, if any in your standard.\nTypically these correlations are defined in annex C of the standard. They provide the normal detailed input of a procedure, based on a simplified input data set."]
["Product_descriptive_data\nUse this sheet to list product descriptive data (typically with case identifiers). Some examples of selection tables are given.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Product_tech_data\nUse this sheet to list product technical data (typically numerical values and data). Some examples are given with default that may be typically included in annex A of the standard.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Process_design_data\nUse this sheet to list system descriptive data (typically with case identifiers). Some examples of selection tables are given.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Data_catalogue_example\nIt is an example of how a data catalogue can work, filtering the catalogue of product properties based on product descriptive data. You can optionally build a similar catalogue for products involved in your standard."]
["Input_series\nPrepare in this sheet data for each time step if you want to test the procedure on more steps."]
["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."]
["Output_series\nSeries alculation results are stored in this sheet.\nCalculation for each time step is launched in this sheet."]

{"sheet":"Data_catalogue_example","index":2,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,9,0,20],[0,22,0,30],[8,0,8,2]]}
["EXAMPLE OF A PRODUCT DATA CATALOGUE\nProduct descriptive data is used to filter the actual catalogue. Unsuitable prioducts are indicated by \"Non available\"\nThe desired product in the catalogue is then selected via the main list --> alla data is available with one click.\nNOTE: Default data are also part of the catalogue.\nThis sample catalogue is connected to the \"Method input\" sheet.\nNOTE: This highlights the high importance of the user interface and of a correct data input structuring.",null,null,null,null,null,null,null,null,"DATA FOR EACH BOILER",null,null,null,null,null,null,null,null,null,null,null,null,"SELECTION OF BOILERS COMPATIBLE WITH THE QUALITATIVE DESCRIPTION"]
[]
[]
[" Product descriptive data (qualitative)"]
[]
[]
["Product technical data"]
[null,null,null,null,"i=-1","i=+1"]
["Energy required for domestic hot water use (test condition)",null,null,"QW;sol;us;an ",2000,3000,"kWh"]
["Auxiliary energy consumption",null,null,"WW;sol;aux;an ",60,60,"kWh"]
["Solar contribution to the heat use",null,null,"QW;sol;out;an",{"$f":"E9*0.4","v":800},{"$f":"F9*0.4","v":1200},"kWh"]
[{"$f":"IF(A18=1,\"Solar contribution to the heat use\",\"Backup contribution to the heat use\")","v":"Backup contribution to the heat use"},null,null,{"$f":"IF(A18=1,\"QW;sol;out;an\",\"QW;bu;out;an\")","v":"QW;bu;out;an"},{"$f":"E9*0.6","v":1200},{"$f":"F9*0.6","v":1800},"kWh"]
[]
[]
["System design data"]
[]
["Product main layout type",null,"SOL_TYPE"]
[2,null,{"$f":"INDEX(C20:C21,A18)","v":"PAR"}]
[]
["Preheater or solar-only",null,"SER"]
["Solar-plus-supplementary",null,"PAR"]
[]
[]
["Orientation of the collector",null,"ƒcol"]
[1,"ƒcol",{"$f":"INDEX(C27:C29,A25)","v":1}]
["Options:",null,"Values:"]
["South east - South west / -20o - +5o",null,1]
["East - West / minimum shading",null,0.8]
["other cases",null,0]
[]
["Location of the heat storage tank",null,"STO_LOC","ƒrbl"]
[2,"ƒcol",{"$f":"INDEX(C34:C36,A32)","v":"NHS"},{"$f":"INDEX(D34:D36,A32)","v":0.5}]
["Options:",null,"Values:","Values:"]
["Heated space",null,"HS",1]
["Not heated space",null,"NHS",0.5]
["Outside",null,"OUT",0]
[]
["Insulation on backup loop ",null,"ƒbu;ins"]
[1,"ƒbu;ins",{"$f":"INDEX(C41:C42,A39)","v":0.02}]
["Options:",null,"Values:"]
["Insulated",null,0.02]
["Not insulated",null,0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Operating conditions"]
[]
[]
[]
["System design data"]

{"sheet":"Input_series","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Load here the value of input variables for each time-step (time series)\nSet the number of input data for each time steps and the number of time step before running The macro from sheet \"Output series\".\n\nLocal constant data may be input via the sheets \"Constants\" "]
[]
["Time series for data input"]
["Settings"]
["Number of input data",null,6]
["Number of time steps",null,12]
[]
["Description","Calculation interval duration","Solar irradiation","Outside air tempertaure","Heat use hot water","Auxiliary backup heater","Heat losses backup heater"]
["Symbol","tci ","Isol","ϑ","QW;sol;us","WW;bu;aux;nom","QW;bu;ls;nom"]
["Unit","h","W/m2","°C","kWh","kWh","kWh"]
["Origin",null,"M1-13","M1-13","M8-2","M8-8.x","M8-8.x"]
[]
["Time stamp",null,null,"VALUES"]
[1,744,67,0.6,{"$f":"5.8/24*B14","v":179.8},{"$f":"B14*0.003","v":2.2320000000000002},{"$f":"E14*0.05","v":8.99}]
[2,672,108,1.1000000000000001,{"$f":"5.8/24*B15","v":162.4},{"$f":"B15*0.003","v":2.016},{"$f":"E15*0.05","v":8.120000000000001}]
[3,744,145,5.6,179.8,2.2320000000000002,8.99]
[4,720,184,8.3000000000000007,174,2.16,8.7000000000000011]
[5,744,204,13.3,179.8,2.2320000000000002,8.99]
[6,720,209,16.7,174,2.16,8.7000000000000011]
[7,744,210,18.3,179.8,2.2320000000000002,8.99]
[8,744,200,18.3,179.8,2.2320000000000002,8.99]
[9,720,177,15,174,2.16,8.7000000000000011]
[10,744,121,9.4,179.8,2.2320000000000002,8.99]
[11,720,67,4.4000000000000004,174,2.16,8.7000000000000011]
[12,744,53,1.7,179.8,2.2320000000000002,8.99]
[]
["total",{"$f":"SUM(B14:B26)","v":8760},{"$f":"AVERAGE(C14:C26)","v":145.41666666666666},null,{"$f":"SUM(E14:E26)","v":2117}]

{"sheet":"Method_input","index":4,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["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","Unit","Value","Range","Origin","Varying","Notes"]
["Operating conditions data"]
["Calculation interval duration","tci ","h",744,"672 … 8769",null,"YES"]
["Solar irradiation","Isol;S45","W/m2",53,"0 … 1200","M1-13","Yes"]
["Outside air tempertaure","ϑoutside","°C",1.7,"-20 … 30","M1-13","Yes"]
["Heat use hot water","QW;sol;us","kWh",179.8,"≥ 0","M8-2","YES"]
["Auxiliary backup heater","WW;bu;aux;nom","kWh",2.2320000000000002,"≥ 0","M8-8.x","YES"]
["Heat losses backup heater","QW;bu;ls;nom","kWh",8.99,"≥ 0","M8-8.x","YES"]
[]
[]
[]
["Product data"]
["Product description data "]
[null,"SOL_LAYOUT",null,{"$f":"Data_catalogue_example!C18","v":"PAR"}]
[]
[]
["Product technical data "]
["Test result QW;sol;us i=-1"]
["Auxiliary energy consumption","WW;sol;aux;an,i=-1","kWh",{"$f":"Data_catalogue_example!E10","v":60}]
["Energy required for domestic hot water use","QW;sol;us;an,i=-1","kWh",{"$f":"Data_catalogue_example!E9","v":2000}]
["SOL_LAYOUT=SER"]
["Solar contribution to the heat use","QW;sol;out;an,i=-1","kWh",{"$f":"Data_catalogue_example!E11","v":800}]
["SOL_LAYOUT=PAR"]
["Backup contribution to the heat use","QW;bu;out;an,i=-1","kWh",{"$f":"Data_catalogue_example!E12","v":1200}]
["Test result QW;sol;us i=+1"]
["Auxiliary energy consumption","WW;sol;aux;an,i=+1","kWh",{"$f":"Data_catalogue_example!F10","v":60}]
["Energy required for domestic hot water use","QW;sol;us;an,i=+1","kWh",{"$f":"Data_catalogue_example!F9","v":3000}]
["SOL_LAYOUT=SER"]
["Solar contribution to the heat use","QW;sol;out;an,i=+1","kWh",{"$f":"Data_catalogue_example!F11","v":1200}]
["SOL_LAYOUT=PAR"]
["Backup contribution to the heat use","QW;bu;out;an,i=+1","kWh",{"$f":"Data_catalogue_example!F12","v":1800}]
[]
["Process design"]
[]
[]
[]
[]
["Control type data"]
[]
[]
["Constants"]
["Water specific heat","cp,w ","Wh/kg°C",1.1599999999999999]

{"sheet":"Method_calculation","index":5,"n_rows":24,"n_cols":7,"rows_kept":24,"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"]
[]
["Test results:"]
["auxiliary energy consumption (test)","WW;sol;aux;an","kWh",{"$f":"Ww_sol_aux_1+(Ww_sol_aux_2-Ww_sol_aux_1)*(Qw_sol_us_an-Qw_sol_us_1)/(Qw_sol_us_2-Qw_sol_us_1)","v":60},null,"Linear interpolation i=-1 .. i=+1"]
["solar contribution (test)","QW;sol;out;an","kWh",{"$f":"QW_sol_out_1+(QW_sol_out_2-QW_sol_out_1)*(Qw_sol_us_an-Qw_sol_us_1)/(Qw_sol_us_2-Qw_sol_us_1)","v":846.8},null,"Linear interpolation i=-1 .. i=+2","SOL_TYPE=\"SER\" only"]
["backup conribution (test)","QW;bu;out;an","kWh",{"$f":"Qw_bu_out_1+(Qw_bu_out_2-Qw_bu_out_1)*(Qw_sol_us_an-Qw_sol_us_1)/(Qw_sol_us_2-Qw_sol_us_1)","v":1270.2},null,"Linear interpolation i=-1 .. i=+3","SOL_TYPE=\"PAR\" only"]
["Preparations:"]
["solar irradiation","Isol","W/m2",{"$f":"Method_input!D7*Data_catalogue_example!C25","v":53},"(1)"]
["monthly distribution","ƒdist ","-",{"$f":"D10*Input_series!B14/(Isol_s45_an*tci_an)","v":3.0954979000667269E-2},"(2)"]
["Performance calculations"]
["backup contribution","QW;bu;out","kWh",{"$f":"IF(SOL_TYPE=\"SER\",Method_input!D9-D11*D7,Method_input!D9-D11*(Qw_sol_us_an-D8))","v":153.58732378223496},"(3) or (4)"]
["solar & backup output","Qw;sol;bu;out","kWh",{"$f":"Method_input!D9","v":179.8},"(5)"]
["auxiliary energy consumption (test)","Ww;sol;aux","kWh",{"$f":"D11*D6","v":1.857298740040036},"(6)"]
["Heat losses"]
["solar fraction","fsolar","-",{"$f":"(Method_input!D9-D13)/Method_input!D9","v":0.14578796561604587},"(7)",null,"intermediate result"]
["air temperature storage","ϑst;amb","oC",{"$f":"IF(STO_LOC=\"HS\",20,IF(STO_LOC=\"NHS\",(20+Method_input!D8)/2,Method_input!D8))","v":10.85}]
["storage heat losses solar","Qw;sol;st;ls","kWh",{"$f":"(60-D18)*(0.37+2.06*(Method_input!D9/Method_in)^0.4)*D17*Method_in/1000","v":8.1951153579947604},"(8)"]
["storage heat losses backup","Qw;bu;st;ls","kWh",{"$f":"IF(Data_catalogue_example!C18=\"PAR\",(60-D18)*(0.37+2.06*(Method_input!D9/Method_in)^0.4)*Method_in/1000,0)","v":56.212564071151156},"(9)"]
["heat losses backup loop","QW;bu;dis;ls","kWh",{"$f":"Data_catalogue_example!C39*(1-D13)","v":-3.0517464756446993},"(10)"]
["recoverable losses","QW;sol;ls;rbl","kWh",{"$f":"Data_catalogue_example!D32*(D19+D20+D21)","v":30.677966476750608},"(11)",null,"no test for space heating implemented"]
["reduced backup auxiliary","WW;bu;aux","kWh",{"$f":"Method_input!D10*(1-D17)","v":1.9066012607449858},"(12)"]
["reduced backup heat losses","QW;bu;ls","kWh",{"$f":"IF(D17<0.8,Method_input!D11,Method_input!D11*(1-D17))","v":8.99},"(13)"]

{"sheet":"Method_output","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"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."]
[]
["Description","Unit",null,"Value"]
[]
[]
[]
[]
[]
["Name","Symbol","Unit","Value","Intended destination","Notes"]
[]
["Backup heat contribution","QW;bu;out","kWh",{"$f":"Method_calculation!D13","v":153.58732378223496},"M8-8.x"]
["Heat output to distribution","QW;sol;bu;out","kWh",{"$f":"Method_calculation!D14","v":179.8},"M8-6"]
["auxiliary energy consumption","WW;sol;aux","kWh",{"$f":"Method_calculation!D15","v":1.857298740040036},"M8-1"]
["Recocoverable heat losses","QW;sol;ls;rbl","kWh",{"$f":"Method_calculation!D22","v":30.677966476750608},"M2-2"]
["reduced auxiliary energy consumption backup heater","WW;bu;aux","kWh",{"$f":"Method_calculation!D23","v":1.9066012607449858},"M8-8.x"]
["reduced heat lsses backup heater","QW;bu;ls","kWh",{"$f":"Method_calculation!D24","v":8.99},"M8-8.x"]

{"sheet":"Output_series","index":7,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,0,6,4],[0,0,0,5]]}
["Here a time series can be generated to test the method with variable input data.\nData input series must be inserted in the \"input_series\" sheet before."]
[]
["Time series for data output"]
["Settings"]
["Number of output data",null,6]
[]
["This table will be filled automatically via a macro scanning the \"input_series\" and performing for each time step the calculation defined in the \"Method_calculation\" sheet."]
["Press CLEAR OUTPUT to reset output series"]
["Press \"Run method\" to start calculation of individual time steps"]
[]
[]
[]
[null,"Backup heat ","Heat output ","auxiliary energy consumption","Recocoverable heat ","reduced auxiliary energy  backup ","reduced  losses backup "]
[null,"kWh","kWh","kWh","kWh","kWh","kWh"]
["Symbol","QW;bu;out","QW;sol;bu;out","WW;sol;aux","QW;sol;ls;rbl","WW;bu;aux","QW;bu;ls"]
["Destination","M8-8.x","M8-6","M8-1","M2-2","M8-8.x","M8-8.x"]
["Time stamp",null,null,"VALUES"]
[1,146.66322063037251,179.8,2.3479059543902343,32.202061751431749,1.820646876790831,8.99]
[2,108.98548997134671,162.4,3.784684224987243,32.862121478959239,1.3529233237822349,8.120000000000001]
[3,108.08607449856736,179.8,5.0812890057699098,36.685856234324461,1.341758166189112,8.99]
[4,82.997501432664762,174,6.4479805314597476,37.823795914499456,1.0303138108882521,8.7000000000000011]
[5,78.905925501432691,179.8,7.1488479805314595,37.92108081265765,0.97952183381088853,8.99]
[6,70.633031518624648,174,7.3240648427993875,36.045427989945857,0.8768238395415473,8.7000000000000011]
[7,75.938452722063047,179.8,7.3591082152529737,36.104453155038897,0.9426842406876792,8.99]
[8,80.884240687679096,179.8,7.0086744907171177,35.412429271478452,1.0040802292263611,8.99]
[9,86.459553008595989,174,6.2026769242846491,34.497729545833536,1.0732910028653295,8.7000000000000011]
[10,119.95596561604586,179.8,4.240248066883856,33.337135844751941,1.4891085386819487,8.99]
[11,140.8632206303725,174,2.3479059543902343,30.091559632847208,1.748646876790831,8.7000000000000011]
[12,153.58732378223496,179.8,1.857298740040036,30.677966476750608,1.9066012607449858,8.99]
[]
["Annual",{"$f":"SUM(B18:B30)","v":1253.9600000000003},{"$f":"SUM(C18:C30)","v":2117},61.150684931506859,413.66161810851906,15.566400000000002,105.85000000000001]

{"sheet":"History","index":8,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2012-07-04","Issued for discussion in CTL"]
[null,"2012-08-24","Issued for comments in TC 371","Improved readability"]
[null,"2013-07-03","Revised for the toolkit"]