{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Disclaimer","INFO","Simplified_input_correlation","Product_descriptive_data","Product_tech_data","Process_design_data","Data_catalogue_example","Input_series","Method_input","Method_calculation","Method_output","Output_series","History"],"not_rendered":{"charts":0,"images":52,"macros":1,"external_links":0,"defined_names":14,"comments":5,"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":"Simplified_input_correlation","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Create here a simulation of each correlation method in your Annex C"]
[]
[]
["Name","Symbol","Unit","Value","Range","Formula ref.","Formula","Notes"]
["Input data"]
["Length of the building","LL","m",15,"4…100"]
["Width of the building","LW","m",10,"4…20"]
["Number of loors","Nlev","-",3,"1…10"]
["Floor heigth","hfl","m",2.9,"2…5"]
["Length ","lc","m",0,"0 / 6",null,null,"0= outside shafts  6 = innner shafts"]
[]
["linear thermal transmittance for insulated pipes in air ","Y ","W/(m∙K)",0.2,"0,05..0,5",null,null,"Standard-Values "]
["inner diameter of pipe (without insulation)","di","m",0.02,"0,01…1,00"," "]
["outer diameter of pipe (with insulation)","da","m",0.06,"0,01…1,00"]
["thermal conductivity of insulation ","lD","W/(m∙K)",0.04,"0,01..0,08"]
[]
["thermal conductivity of embedded material","lem","W/(m∙K)",1,"0,01….5,0"]
["the depth of pipe from surface","z","m",0.15,"0,05..2,0"]
["thermal conductivity of the pipe material ","lP","W/(m∙K)",380,"10..500"]
["inner diameter of the pipe","dp,i","m",1.9E-2]
["outer diameter of the pipe","dp,a","m",2.1999999999999999E-2]
["specific heat of the pipe","cp","kWh/(kg∙K)",0.106,"0,02…0,25"]
["density of the pipe","rp","kg/m³",8900,"1000…20000"]
[]
[]
["METHOD"]
[]
["Heating/Cooling Space heating"]
["Length of connection of radiators to vertical shafts ","lA","m",{"$f":"0.55*LL*D7*D8","v":247.5}]
["Length of vertical shafts","lS","m",{"$f":"0.025*Method_in*D7*D8*D9","v":32.625}]
["Length of base distributor/collector","lV","m",{"$f":"2*Method_in+0.01625*Method_in*D7*D7","v":54.375}]
["max. Length of pipes in a circuit","Lmax","m",{"$f":"2*(LL+D7/2+D8*D9+D10)","v":57.4}]
["DHW "]
["Length of pipes in open circuitet stubs","lA","m",{"$f":"0.05*LL*D7*D8","v":22.5}]
["Length of vertical shafts","lS","m",{"$f":"0.075*LL*D7*D8*D9","v":97.875},null,null,null,"Length with circulation loop\n* (0,5) without circulation loop"]
["Length of base distributor/collector","lV","m",{"$f":"2*LL+0.0125*LL*D7","v":31.875},null,null,null,"Length with circulation loop\n* (0,5) without circulation loop"]
["Max. Length of pipes in a circuit (circulation) ","Lmax","m",{"$f":"2*(LL+D7/2+D8*D9+D10)","v":57.4}]
[null," "," "]
["correction factor for special design conditions of the distribution system","fX,corr",null,1,null,null,null,"Annex"]
["linear thermal transmittance for insulated pipes in air ","Y ","W/(m∙K)",{"$f":"3.1415/( 1/(2*D15)*LN(D14/D13)+1/(Method_input!D57*Simplified_input_correlation!D14))","v":0.19862813566950063},null,"Formula (3)"]
["linear thermal transmittance for insulated embedded pipes ","Yem  ","W/(m∙K)",{"$f":"3.1419/(1/2*( 1/D15*LN(D14/D13)+1/D17*LN(4*D18/D14)))","v":0.21109321192864816},null,"Formula (4)"]
["linear thermal transmittance for non insulated pipes","Ynon ","W/(m∙K)",{"$f":"3.1415/( 1/(2*D19)*LN(D21/D20)+1/(Method_input!D58*Simplified_input_correlation!D21))","v":0.96752451647856808},null,"Formula (5)",null,"exact calculation"]
["linear thermal transmittance for non insulated pipes","Ynon ","W/(m∙K)",{"$f":"Method_input!D58*Simplified_input_correlation!D21*3.1415","v":0.96758200000000005},null,"Formula (6)",null,"approximation"]
[]
["Volume of pipes in open circuited stubs per zone","VP","m³",{"$f":"D20^2*0.785*D34","v":6.3761625000000001E-3}]
["mass of pipe","mP","kg/m³",{"$f":"D45*D23","v":56.747846250000002}]
["factor for efficiency ","fX,e  ",null,{"$f":"(1.25+(0.2/(Method_calculation!D32))^0.5)*Simplified_input_correlation!D48","v":4.3317573011948536},null,"Formula (23)"]
["factor for pump design selection ","b",null,1,null,null,null,"constant"]
["constant depending on control system of the pump","CP1",null,0.9,null,null,null,"HEAT_DISTR_CTRL_PMP  0 / 3 / 4"]
["constant depending on control system of the pump","CP2",null,0.1,null,null,null,"HEAT_DISTR_CTRL_PMP  0 / 3 / 4"]
["expenditure energy factor of distribution pumps ","eX,dis ",null,{"$f":"D47*(D49+D50*Method_calculation!D34^(-1))","v":4.7954257328134329},null,"Formula (22)"]
["factor fEEI","fEEI",null,{"$f":"Product_tech_data!A4/0.623","v":0.43338683788121996},null,"Formula (28)"]
[]
["Output data"]
["Length of shafts","lS","m",null,"0...∞"]
["diameter of shafts","dS","m",null,"0…0,2"]
["Length of base ring","lB","m",null,"0...∞"]
["diameter of base ring","dB","m",null,"0…0,2"]

{"sheet":"Product_descriptive_data","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Example of descriptive data.\nIn a simple structure, this can be connected directly to the \"method_input\" sheet where this data is required.\nIn this example spreadsheet the \"Method_input\" is linked to the \"data_catalogue\"."]
[]
[]
[]
[]
[" Product descriptive data (qualitative)"]
[]
["Boiler type, condensing / non condensing"]
[3,"BLR_TYPE",{"$f":"INDEX(C11:C13,A9)","v":"BLR_TYPE_STND"}]
[]
["Condensing",null,"BLR_TYPE_COND"]
["Low temperature",null,"BLR_TYPE_LTMP"]
["Standard",null,"BLR_TYPE_STND"]
[]
[]
["Boiler use"]
[0,"BLR_USE",{"$f":"INDEX(#REF!,A17)","v":{"$error":"#REF!"}}]

{"sheet":"Product_tech_data","index":4,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["EXAMPLE OF A SHEET WITH DEFAULT INPUT\nCreate here a simulation of each default data formula given in annex A of the standard.\nOptionally connect the selected values to the detailed input data selection sheet  (detailed input)"]
[]
[]
[0.27]

{"sheet":"Process_design_data","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Example of process design data.\nIn a simple structure, this can be connected directly to the \"method_input\" sheet where this data is required.\nIn this example spreadsheet the \"Method input\" is linked to the detailed input."]

{"sheet":"Data_catalogue_example","index":6,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,9,0,20],[0,22,0,30]]}
["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 technical data"]
[]
["Pump energy efficiency index EEI"]
[3,null,"EEI",{"$f":"INDEX(D9:D11,A7)","v":0.3}]
[]
["Heating",null,null,0.25]
["Cooling",null,null,0.25]
["Domestic hot water",null,null,0.3]

{"sheet":"Input_series","index":7,"n_rows":6,"n_cols":3,"rows_kept":6,"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,0]
["Number of time steps",null,0]

{"sheet":"Method_input","index":8,"n_rows":62,"n_cols":8,"rows_kept":62,"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"]
["Input temperature of the heating emitters","qH,em,in ","°C",68,"0..110","M3-5","YES"]
["Output temperature of the heating emitters","qH,em,out ","°C",58,"0..110","M3-5","YES"]
["Flowrate in the heating circuit",null,"m³/h",3.5,"0…..µ","M3-5","YES"]
["Input temperature of the cooling emitters","qC,em,in ","°C",6,"0..110","M4-5","YES"]
["Output temperature of the cooling emitters","qC,em,out ","°C",12,"0..110","M4-5","YES"]
["Flowrate in the cooling circuit",null,"m³/h",0.8,"0…..µ","M4-5","YES"]
["Temperature of DHW","qW","°C",50,"30..70","M8-1","YES"]
["Temperature difference between hot water tapping temperature to the return temperature in a circulation loop system ","DqW","K",5,"2..10","M8-1","YES","only in circulation systems"]
["Calculation interval","tci ","h",1,"1…8760","M1-9","YES"]
["Total time operation ","top ","h",1,"0…8760","M1-6","YES","Sum"]
["Surrounding zone temperature in the calculation interval at heating period","qah,H","°C",13,"-30…+30","M2-2","YES"]
["Surrounding zone temperature in the calculation interval at cooling period","qah,C","°C",22,"-30…+30","M2-2","YES"]
["Surrounding zone temperature in the calculation interval at DHW period","qah,W","°C",13,"-30…+30","M2-2","YES"]
["time after a tapping before next tapping","tatap","h",2,"0..24","M8-1","YES"]
["operation time of the distribution system","tX,op","h",1,"0…8760",null,"YES"]
[]
[]
["Product data"]
["Product description data "]
[]
["Product technical data "]
[]
["System design data"]
["Process design"]
["Tapping profile","ntap","1/h",0.5,"1..30","M8-1","YES"]
["number of operations of circulation pump","nnom","1/d",2,"0…24","M8-1","YES"]
["average hot water temperature in circulation system without operation ","θW,avg","°C",25,"20…70","M8-1","YES","LOCAL or te be calculated"]
["resistance ratio of components in the piping system","fcomp",null,0.3,"0…0,8",null," ","LOCAL"]
["pressure loss per length","RX,max","kPa/m",0.1,"0,05…0,50"]
["pressure losses of additional resistances","DpX,add","kPa",3,"0…100",null,"YES"]
["calculated heat load of a zone","FH,em.out","kW",50,"1…..µ"]
["calculated heat load or cooling load of a zone","FC,em.out","kW",50,"1…..µ"]
["design temperature difference in the distribution circuit - heating","DqH,dis,des","K",15,"1…50"]
["design temperature difference in the distribution circuit - cooling","DqC,dis,des","K",6,"1…20"]
["design temperature difference in the circulation circuit","DqW,circ","K",5,"1…10"]
[" "," ",null," "," "]
["Primary energy factor for thermal energy carrier ","fX,Y",null,1.1000000000000001]
["Primary energy factor for electrical energy carrier ","fX,Z",null,2.4]
[]
[]
["Control type data"]
["type of flow rate control ","HEAT_DISTR_CTRL_PMP",null,null,"0, 3, 4"]
["type of speed control ","HEAT_DISTR_CTRL",null,null,"0, 2, 3"]
[" "," "]
[]
["Constants"]
[" (specific heat ∙ density) of water","cw∙rw","kWh/(m³·K)",1.1499999999999999]
["Specific heat of water","cw","kWh/(kg∙K)",1.163]
["Density of water","rw","kg/m³",990]
["Factor for pump selection","b","-",1,null,null,null,"selection at design point"]
[null,"b","-",2,null,null,null,"selection different from design point"]
["outer total surface coefficient of heat transfer (convection and radiation)","ha","W/(m²K)",8,null,"Local","NO","value for insulated pipes"]
[null,"ha","W/(m²K)",14,null,null,null,"value for uninsulated pipes"]
[]
[]
[" "]
[null,null," "]

{"sheet":"Method_calculation","index":9,"n_rows":44,"n_cols":12,"rows_kept":44,"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"]
[]
["mean water temperature in the space heating distribution system ","θH,em,mean","°C",{"$f":"(Method_in+Method_input!D7)/2","v":63},"Formula (1)",null,"Index X:\nheating H, cooling C, DHW W"]
["mean water temperature in the space cooling distribution system ","θC,em,mean","°C",{"$f":"(Method_input!D9+Method_input!D10)/2","v":9},"Formula (1)",null,"Index X:\nheating H, cooling C, DHW W"]
["mean water temperature in the distribution system for DHW ","θW,em,mean","°C",{"$f":"Method_input!D12-Method_input!D13/2","v":47.5},"Formula (2)"]
["thermal loss distribution system  for space heating","QH,dis,ls","kWh",{"$f":"1/1000*Method_input!D15*Simplified_input_correlation!D12*(Method_calculation!D5-Method_input!D16)*Simplified_input_correlation!D31*Method_input!D14","v":0.54375000000000007},"Formula (7)",null,"thermal loss in timestep tci"]
["thermal loss (gain) distribution system  for space cooling","QC,dis,ls","kWh",{"$f":"1/1000*Method_input!D15*Simplified_input_correlation!D12*(Method_calculation!D6-Method_input!D17)*Simplified_input_correlation!D29*Method_input!D15","v":-0.64350000000000007},"Formula (7)",null,"thermal loss (gain) in timestep tci"]
["thermal loss distribution system  for DHW ","QW,dis,ls","kWh",{"$f":"1/1000*Method_input!D14*Simplified_input_correlation!D12*(Method_calculation!D7-Method_input!D18)*Simplified_input_correlation!D30*Method_input!D15","v":0.22511250000000002},"Formula (7)",null,"thermal loss in timestep tci\nlength of hotwater and circulation pipes"]
["mass flow of hot water in open circuited stubs ","mw,dis,stub ","kg/h",{"$f":"Simplified_input_correlation!D45*Method_input!D54*Method_input!D30","v":3.1562004374999999},"Formula (9)"]
["additional thermal loss for distribution pipes with open circuited stubs ","QW,dis,stub ","kWh",{"$f":"D11*Method_input!D53* (Method_input!D12-Method_input!D18)*Method_input!D14","v":135.8144610260625},"Formula (8)"]
["mass flow of hot water in pipes of the circulation system ","mw,dis,nom ","kg/h",{"$f":"1/24*Simplified_input_correlation!D45*Method_input!D54*Method_input!D31","v":0.52603340625000006},"Formula (11)"]
["thermal loss in circulation systems without operation ","Qw,dis,nom ","kWh",{"$f":"D13*Method_input!D53* (Method_input!D32-Method_input!D18)*Method_input!D14","v":7.3413222176250006},"Formula (10)"]
["hot water temperature after a tapping during a time without operation ","qW,dis,atap ","°C",{"$f":"Method_input!D18+(Method_input!D12-Method_input!D18)*EXP(-D16)","v":31.86094588864777},"Formula (12)"]
["exponent Ci for the calculation of the temperature drop after a tapping in section i","Ci"," ",{"$f":"(D17*Simplified_input_correlation!D34*Method_input!D19)/(Method_input!D53*Method_input!D54*Simplified_input_correlation!D45+Simplified_input_correlation!D22*Simplified_input_correlation!D46)*1/(Method_input!D12-Method_input!D18)","v":0.6738244835338808},"Formula (13)"]
["heat flow rate per length ","qi","W/m",{"$f":"Simplified_input_correlation!D12*(Method_input!D12-Method_input!D18)","v":7.4},"Formula (14)"]
["part of recoverable thermal loss of distribution system","fH,dis,rbl",null,0.65,null,null,"assumption"]
["Recoverable thermal loss of the distribution system for heating in the zone","QH,dis,rbl","kWh",{"$f":"D8*D18","v":0.35343750000000007}]
["Input energy to the emission system","QX,em","kWh",{"$f":"Method_input!D8*Method_input!D52*(Method_in-Method_input!D7)*Method_input!D14","v":40.249999999999993},"Formula (37)"]
["thermal expenditure energy factor ","eX,dis ",null,{"$f":"(D20+Method_calculation!D8)/(D20)","v":1.0135093167701865},"Formula (36)"]
["primary energy related expenditure energy factor ","eP,X,dis ",null,{"$f":"(Method_input!D42*Method_calculation!D8+Method_input!D43*Method_calculation!D36)/D20","v":1.7768639404694492E-2},"Formula (38)"]
["input thermal energy for distribution ","QH,dis,in ","kWh",{"$f":"D20+D8","v":40.793749999999996},"Formula(39)",null,"    or"]
["mean hot water temperature","qW,avg ","°C",{"$f":"(Method_input!D12+Method_calculation!D15)/2","v":40.930472944323881},"Formula(15)"]
["mean temperature without operation simplified","qW,em,mean ","°C",{"$f":"25*Simplified_input_correlation!D12^(-0.2)","v":34.49324153653037},"Formula(16)"]
[]
[]
["Auxiliary energy"]
["differential pressure of a pipe system in a zone ","DpX,des","kPa",{"$f":"(1+Method_input!D33)*Method_input!D34*Simplified_input_correlation!D32+Method_input!D35","v":10.462},"Formula (20)",null,"Index X:\nheating H, cooling C, DHW W"]
["flow at design point for space heating or cooling systems ",null,"m³/h",{"$f":"Method_input!D37/(Method_input!D52*Method_input!D39)","v":7.2463768115942031},"Formula (21)",null,"Index X:\nheating H, cooling C, DHW W"]
["flow at design point for DHW systems ",null,"m³/h",{"$f":"D10/(Method_input!D52*Method_input!D40)","v":3.9150000000000004E-2},"Formula (22)"]
["hydraulic design power of a circulation pump ","PX,hydr,des ","kW",{"$f":"D30*D29/3600","v":2.1058776167471819E-2},"Formula (19)",null,"Index X:\nheating H, cooling C, DHW W"]
["auxiliary energy demand for a ribbon heater ","WW,dis,aux,rib ","kWh",{"$f":"D10","v":0.22511250000000002},"Formula (19)",null,"calculation only with the length of hot water pipes and year"]
["mean part load of the distribution system ","bX,dis "," ",{"$f":"Method_input!D8/Method_calculation!D30","v":0.48299999999999998},"Formula (25)",null,"Index X:\nheating H, cooling C, DHW W"]
["hydraulic energy demand ","WX,dis,hydr ","kWh",{"$f":"D32*D34*Method_input!D20*Simplified_input_correlation!D39","v":1.0171388888888888E-2},"Formula (24)",null,"Index X:\nheating H, cooling C, DHW W"]
["auxiliary energy demand ","WX,dis,aux ","kWh",{"$f":"D35*Simplified_input_correlation!D51","v":4.8776140016230402E-2},"Formula (26)",null,"Index X:\nheating H, cooling C, DHW W"]
["Recoverable auxiliary energy of the distribution system for heating in the zone","QX,dis,aux,rbl","kWh",{"$f":"D36*0.25","v":1.21940350040576E-2},"Formula (34)",null,"Index X:\nheating H, cooling C, DHW W",null,null,null,null," "]
["Recovered auxiliary energy of the distribution system for heating in the zone","QX,dis,aux,rvd","kWh",{"$f":"D36*0.75","v":3.6582105012172801E-2},"Formula (35)",null,"Index X:\nheating H, cooling C, DHW W"]
["Distribution pump in setback operation","WX,dis,aux,setb","kWh",{"$f":"D32*Method_input!D14","v":2.1058776167471819E-2},"Formula(30)",null,"HEAT_DISTR_CTRL = 2 "]
["Distribution pump in boost mode operation","WX,dis,aux,setb","kWh",{"$f":"3.3*D32*Method_input!D14","v":6.9493961352656994E-2},"Formula(31)",null,"HEAT_DISTR_CTRL = 3 "]
[]
[]
[]
[null,"LOCAL"]

{"sheet":"Method_output","index":10,"n_rows":43,"n_cols":6,"rows_kept":43,"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"]
["Energy flow data"]
["Thermal loss of the distribution system for heating in the zone","QH,dis,ls","kWh",{"$f":"Method_calculation!D8","v":0.54375000000000007},"M3-1"," "]
["Thermal loss of the distribution system for cooling in the zone","QC,dis,ls","kWh",{"$f":"Method_calculation!D9","v":-0.64350000000000007},"M3-1"]
["Thermal loss of the distribution system for DHW in the zone","QW,dis,ls","kWh",{"$f":"Method_calculation!D10","v":0.22511250000000002},"M3-1"]
[]
[]
["Recoverable thermal loss of the distribution system for heating in the zone","QH,dis,rbl","kWh",{"$f":"Method_calculation!D19","v":0.35343750000000007},"M3-1","Recoverable heat for heating "]
["Recoverable thermal loss of the distribution system for cooling in the zone","QC,dis,rbl","kWh",null,"M3-1","Recoverable heat for cooling"]
["Recoverable thermal loss of the distribution system for DHW in the zone","QW,dis,rbl","kWh",null,"M3-1","Recoverable heat for heating "]
[]
["Recoverd thermal loss of the distribution system for heating in the zone","QH,dis,rvd","kWh",{"$f":"Method_calculation!D29","v":10.462},"M3-1","Recovered heat for heating "]
["Recovered thermal loss of the distribution system for cooling in the zone","QC,dis,rvdl","kWh",null,"M3-1","Recovered heat for heating "]
["Recovered thermal loss of the distribution system for DHW in the zone","QW,dis,vd","kWh",null,"M3-1","Recoverable heat for heating "]
[]
["Auxiliary energy for distribution system heating in the zone","WH,dis,aux","kWh",{"$f":"Method_calculation!D29","v":10.462},"M3-1"]
["Auxiliary energy for distribution system cooling in the zone","WC,dis,aux","kWh",null,"M3-1"]
["Auxiliary energy for distribution system DHW in the zone","WW,dis,aux","kWh",null,"M3-1"]
[]
["Recoverable auxiliary energy for distribution system heating in the zone","WH,dis,rbl","kWh",null,"M3-1"]
["Recoverable auxiliary energy for distribution system cooling in the zone","WC,dis,rbl","kWh",null,"M3-1"]
["Recoverable auxiliary energy for distribution system DHW in the zone","WW,dis,rbl","kWh",null,"M3-1"]
[]
[]
[]
[null," "," "," "," "," "]
["Operating condition data"]
["Flow rate"]
["Temperature 1"]
["Temperature 2"]
["Other data"]
[" "," "," "," "," "," "]
[]
[]
[" "," "," ",null," "]

{"sheet":"Output_series","index":11,"n_rows":29,"n_cols":4,"rows_kept":29,"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,3]
[]
["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,"Generation input","Recoverable heat","Total auxiliary energy "]
[null,"kWh","kWh","kWh"]
["Symbol","EH,gen,in","QH,gen,rbl","WH,gnr,aux"]
["Destination"]
["Time stamp",null,null,"VALUES"]
[1,35119.502006996212,88.388305872581725,162.1294556628107]
[2,27399.828300860725,75.718233693428033,118.61318402407555]
[3,13191.76547066001,60.726048565979752,40.693386820011433]
[4,5665.134279094993,50.545545475692947,23.168077841671433]
[5,2456.4929701882675,49.982231972817736,15.657231136668571]
[6,1921.7194187038133,49.8883463890052,14.40542335250143]
[7,1600.8552878131406,49.832015038717678,13.654338682001145]
[8,2028.6741290007042,49.907123505767707,14.655784909334859]
[9,8920.0123572277371,59.974963895479469,30.678924546674288]
[10,17577.667390595736,71.522021785407134,62.66369191713035]
[11,23091.035187021003,83.259602429445096,93.746743087655474]
[12,30817.483858736668,96.168150420264951,137.26301472639065]

{"sheet":"History","index":12,"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"]