{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Info","STATUS","Product_descriptive_data","Product_tech_data","Process_design_data","Input_series","Method_input","Method_calculation","Method_output","Output_series","History","TEMPLATE_INFO","Data_catalogue_example","Simplified_input_correlation","Method_input _2"],"not_rendered":{"charts":0,"images":44,"macros":1,"external_links":0,"defined_names":15,"comments":9,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"STATUS","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["2013-11-17","Version issued for first comments"]
[null,"Completed sheets have a green tab: input/output variables"]
[null,"Uncompleted sheets have a yellow tab "]
[null,"Red-tab sheets are kept \"pro memoria\""]
[null,"The calculation method has not been implemented yet."]
[null,"The input/output data should be complete"]
[]
["2014-02-16","Completed with single stage and multi stage calculation."]
[null,"Still to be checked and validated."]

{"sheet":"Product_descriptive_data","index":2,"n_rows":69,"n_cols":3,"rows_kept":69,"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)"]
[]
["B.1.1.1 Heater type"]
[5,"LRH_TYPE",{"$f":"INDEX(C11:C21,A9)","v":"LRH_TYPE_AIR_MODUALL"}]
[]
["Overhead luminous radiant heater",null,"LRH_TYPE_LUM"]
["Overhead radiant tube heater unflued",null,"LRH_TYPE_RADNOFLUE"]
["Overhead radiant tube heater flued",null,"LRH_TYPE_RADFLUE"]
["Air heater, ON-OFF",null,"LRH_TYPE_AIR_ONOFF"]
["Air heater modulating output and combustion air",null,"LRH_TYPE_AIR_MODUALL"]
["Air heater modulating output and not combustion air",null,"LRH_TYPE_AIR_MODUGAS"]
["Example n°1",null,"LRH_TYPE_EX1"]
["Example n°2",null,"LRH_TYPE_EX2"]
["Example n°3",null,"LRH_TYPE_EX3"]
["Example n°4",null,"LRH_TYPE_EX4"]
["Last type",null,"LRH_TYPE_LAST"]
[]
[]
["B.1.1.2 Heater use"]
[1,"LRH_USE",{"$f":"INDEX(C27:C30,A25)","v":"LRH_USE_H"}]
[]
["Heating",null,"LRH_USE_H"]
["Domestic hot water","Not applicable","LRH_USE_W"]
["Cooling","Not applicable","LRH_USE_C"]
["All","Not applicable","LRH_USE_ALL"]
[]
[]
["B.1.1.3 Heater fuel"]
[1,"LRH_FUEL",{"$f":"INDEX(C36:C39,A34)","v":"LRH_FUEL_GAS"}]
[]
["Gas",null,"LRH_FUEL_GAS"]
["LPG",null,"LRH_FUEL_LPG"]
["Oil",null,"LRH_FUEL_OIL"]
["Biomass",null,"LRH_FUEL_BM"]
[]
[]
["B.1.1.4 Burner power control type"]
[3,"LRH_CTRL_POW",{"$f":"INDEX(C45:C47,A43)","v":"LRH_CTRL_POW_MODUL"}]
[]
["Single stage control (ON-OFF)",null,"LRH_CTRL_POW_ONOFF"]
["Multistage (stepped) control ",null,"LRH_CTRL_POW_STEP"]
["Modulating control",null,"LRH_CTRL_POW_MODUL"]
[]
[]
["B.1.1.5 Condensing"]
[1,"LRH_COND",{"$f":"INDEX(C53:C54,A51)","v":"LRH_COND_YES"}]
[]
["Condensing heater","YES",{"$f":"$B$51&\"_\"&B53","v":"LRH_COND_YES"}]
["Non condensing heater","NO",{"$f":"$B$51&\"_\"&B54","v":"LRH_COND_NO"}]
[]
[]
["B.1.1.6 Pilot flame"]
[2,"LRH_PILOT",{"$f":"INDEX(C60:C61,A58)","v":"LRH_PILOT_NO"}]
[]
["Heater with pilot flame",null,"LRH_PILOT_YES"]
["Heater without pilot flame",null,"LRH_PILOT_NO"]
[]
[]
["B.1.1.7 Ventilation requirement"]
[3,"LRH_VENT",{"$f":"INDEX(C67:C69,A65)","v":"LRH_VENT_NO"}]
[]
["Type A heater",null,"LRH_VENT_YES"]
["Type A heater, with room ventilation interlock",null,"LRH_VENT_INTERLOCK"]
["Not a type A heater, no heated room ventilation",null,"LRH_VENT_NO"]

{"sheet":"Product_tech_data","index":3,"n_rows":155,"n_cols":12,"rows_kept":155,"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)"]
[]
[]
[]
["6.3.1.2.2    Generator combustion power at full load;","Фlrh,comb,Pn ","kW",{"$f":"42*3","v":126}]
["6.3.1.2.2    Generator combustion power at minimum load;","Фlrh,comb,Pmin ","kW",{"$f":"+D5*0.5","v":63}]
[]
[]
["6.3.1.2.3 Heat losses to the flue with burner on ","αlrh;ch;ON","%",{"$f":"INDEX(C18:C26,A12)","v":4},null,null,"after 2005"]
["6.3.1.2.4 Correction factor for heat losses to the flue with burner on ","flrh;corr;ch;ON","%",{"$f":"INDEX(D18:D26,A12)","v":0.18},null,null,"1990 - 2005"]
["6.3.1.2.5 Test temperature for heat losses to the flue with burner on ","ϑlrh;air;test;ON","°C",{"$f":"INDEX(E18:E26,A12)","v":20},null,null,"before 1990"]
[8]
[1]
[]
["Data table A10",null,null,null,null,"after 2005","1990 - 2005","before 1990",null,"after 2005","1990 - 2005","before 1990"]
["Data",null,null,"flrh,corr,ch,on","ϑlrh,gen,air,test","αlrh,ch,on","αlrh,ch,on","αlrh,ch,on",null,"αlrh,ch,on","αlrh,ch,on","αlrh,ch,on"]
["Unit",null,null,"-","°C","%","%","%",null,"%","%","%"]
["Overhead luminous radiant heater",null,{"$f":"INDEX(F18:H18,1,$A$13)","v":0},0,20,0,0,0,{"$f":"INDEX(J18:L18,1,$A$13)","v":0},0,0,0]
["Overhead radiant tube heater unflued",null,0,0,20,0,0,0,0,0,0,0]
["Overhead radiant tube heater flued",null,10,0.25,20,10,13,16,8,8,10,13]
["Air heater with natural draught burner",null,13,0.18,20,13,15,18,6,6,8,10]
["Air heater with forced draught burner",null,10,0.18,20,10,13,16,12,12,14,"n.A."]
["Air heater modulating output ",null,8,0.18,20,8,10,"n.A.",4,4,"n.A.","n.A"]
["Condensing air heater",null,6,0.18,20,6,"n.A.","n.A.",6,6,"n.A.","n.A."]
["Measured, special case",null,4,0.18,20,4,{"$f":"+F25","v":4},{"$f":"+G25","v":4},3,3,{"$f":"+J25","v":3},{"$f":"+K25","v":3}]
["Last case",null,10,0.18,20,10,0,0,10,10,0,0]
[]
[]
["6.3.1.2.3 Heat losses to the flue with burner on at minimum power","αlrh;ch;ON","%",{"$f":"INDEX(I18:I26,A12)","v":3}]
[]
[]
[]
["AUXILAIRY ENERGY DATA"]
[4]
[1]
["Known value of auxiliary power of equipment related to the burner","Φlrh;aux;br;known","W",500]
["Known value of auxiliary power of equipment after the burner","Φlrh;aux;blw;known","W",800]
[]
["Data table"]
["Data",null,"nlrh,ch,on","flrh,aux,blw","flrh,aux,br"]
["Unit",null,"-","%","%"]
["Overhead luminous radiant heater (unflued)",null,0,0,0.18]
["Overhead radiant tube heater <=60kW \n(see NOTE 3)",null,0.1,0,0.25]
["Overhead radiant tube heater > 60kW\n(see NOTE 4)",null,0.15,2,0.3]
["Air heater (centrifugal blowing)",null,0.1,0,1.7]
["Air heater (axial blowing)",null,0.1,0,0.9]
["Measured, special case",null,0.1,0,0.9]
["Last case",null,0.1,0,0.9]
["Selected values",null,null,{"$f":"INDEX(D42:D48,A34)","v":0},{"$f":"INDEX(E42:E48,A34)","v":1.7}]
[]
["Default  value of auxiliary power of equipment related to the burner","Φlrh;aux;br;def","W",{"$f":"+D49*D5*10","v":0}]
["Default value of auxiliary power of equipment after the burner","Φlrh;aux;blw;def","W",{"$f":"+E49*D5*10","v":2142}]
[]
["6.3.1.2.6 Load factor exponent","nlrh;ch;ON",null,{"$f":"INDEX(C42:C48,A34)","v":0.1}]
["6.3.1.2.7 Auxiliary power of equipment related to the burner ","Φlrh;aux;br","W",{"$f":"IF(A35=1,D36,D51)","v":500},null,null,null,null,null,"Known value of auxiliary power"]
["6.3.1.2.8 Auxiliary power of equipment after the burner","Φlrh;aux;blw","W",{"$f":"IF(A35=1,D37,D52)","v":800},null,null,null,null,null,"Default value of auxilairy power"]
[]
[]
["6.3.1.2.9       Losses through the generator envelope ","αlrh;env","%",{"$f":"+C71-D71*LOG(D5)","v":1.6016739202965449}]
[2]
["Data table AXX"]
["Data",null,"clrh;1","clrh;2"]
["Unit",null,"%","%"]
["Well insulated, high efficiency new appliance",null,1.72,0.44]
["Well insulated and maintained",null,3.45,0.88]
["Old unit with average insulation",null,6.9,1.76]
["Old unit, poor insulation",null,8.36,2.2000000000000002]
["No insulation",null,10.35,2.64]
["Last option in the table",null,0,0]
["Known value ",2.5,{"$f":"+B70","v":2.5},0]
["Selected values",null,{"$f":"INDEX(C64:C70,$A$60)","v":3.45},{"$f":"INDEX(D64:D70,$A$60)","v":0.88}]
[]
[]
["6.3.1.2.10 Pilot flame losses ","αlrh,plt","%",{"$f":"INDEX(B79:B83,A75)","v":0}]
[1]
["Data table AXX"]
["Data","αlrh,plt"]
["Unit","%"]
["Heater without permanent pilot flame",0]
["Heater with permanent pilot flame, default value",2]
["Measured value",1.5]
["Manufacturer data ",0.7]
["Last option",0]
[]
[]
["6.3.1.2.11 Combustion efficiency of condensing heaters ","ηlrh,comb","%",{"$f":"INDEX(B92:B97,A88)","v":99}]
["6.3.1.2.11 Combustion efficiency of condensing heaters at minimum power","ηlrh,comb,Pmin","%",{"$f":"INDEX(C92:C97,A88)","v":106}]
[4]
["Data table AXX"]
["Data","ηlrh,comb","ηlrh,comb,Pmin"]
["Unit","%","%"]
["On-Off appliances",104,"n.a."]
["Multi-stage or modulating appliances with modulated combustion air flow",94,104]
["Multi-stage or modulating appliances without modulated combustion air flow",102,90]
["Measured value",99,106]
["Manufacturer data ",104,106]
["Last option",90,90]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["generator output at full load;"]
["generator efficiency at full load;"]
["generator output at intermediate load;"]
["generator efficiency at intermediate load;"]
["stand-by heat loss at test temperature difference Dθi,test;"]
["power consumption of auxiliary devices at full load;"]
["power consumption of auxiliary devices at intermediate load;"]
["stand-by power consumption of auxiliary devices;"]
["minimum operating boiler temperature."]
["Recoverable fraction of stand-by losses"]
[]
["correction factor of full-load efficiency;"]
["correction factor of intermediate load efficiency;"]
[]
["generator average water temperature at test conditions for full load;"]
["generator average water temperature at test conditions for intermediate load;"]
["difference between mean boiler temperature and test room temperature in test conditions;"]
[]
["part of the auxiliary energy recovered"]
["part of the nominal electrical power not transmitted to the distribution sub-system"]

{"sheet":"Process_design_data","index":4,"n_rows":31,"n_cols":4,"rows_kept":31,"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."]
[]
[]
["6.3.1.2.9 Auxiliary energy recovery factor","klrh,aux,rh",null,{"$f":"INDEX(C10:C12,A5)","v":0.8}]
[2]
[]
["Data table"]
["Data",null,"klrh,aux,rh"]
["Unit",null,"-"]
["Heater located within the heated space",null,1]
["Heater located outside the heated space",null,0.8]
["Last case",null,0.5]
[]
[]
["A.2.2 correction factor of envelope losses ","klrh,env",null,{"$f":"INDEX(C21:C26,A16)","v":0.7}]
[3]
[]
["Data table"]
["Data",null,"klrh,aux,rh"]
["Unit",null,"-"]
["Heater installed within the heated space without direct contact with wall or roof",null,0]
["Heater installed within the heated space with direct contact with wall or roof",null,0.1]
["Heater installed within a boiler room",null,0.7]
["Heater installed under the roof, outside the heated space",null,0.8]
["Heater installed outdoors",null,1]
["Last case",null,0.5]
[]
[]
["height of the building","Hlrh","m",6]
["Air temperature vertical gradient","dϑH","°C/m",0.3]
["Difference between air and radiant temperature","Δϑlrh;rad","°C",2.5]

{"sheet":"Input_series","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"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,5]
["Number of time steps",null,12]
[]
["Description","Generation output","Calculation interval duration","Operation time","External temperature","Installation room temperature"]
["Symbol","QH,gen,out ","tci ","tgnr ","qext ","qint "]
["Unit","kWh","h","h","°C","°C"]
["Origin","15316-3-1"]
[]
["Time stamp",null,null,"VALUES"]
[1,{"$f":"+P14*$O$14","v":16000},720,720,3,3,null,null,null,null,null,null,null,null,1.6,10000]
[2,{"$f":"+P15*$O$14","v":19200},{"$f":"+C14","v":720},{"$f":"+D14","v":720},7,7,null,null,null,null,null,null,null,null,null,12000]
[3,22400,{"$f":"+C15","v":720},{"$f":"+D15","v":720},12,12,null,null,null,null,null,null,null,null,null,14000]
[4,25600,720,720,15,15,null,null,null,null,null,null,null,null,null,16000]
[5,28800,720,720,18,18,null,null,null,null,null,null,null,null,null,18000]
[6,32000,720,720,21,21,null,null,null,null,null,null,null,null,null,20000]
[7,35200,720,720,24,24,null,null,null,null,null,null,null,null,null,22000]
[8,38400,720,720,23,23,null,null,null,null,null,null,null,null,null,24000]
[9,41600,720,720,20,20,null,null,null,null,null,null,null,null,null,26000]
[10,44800,720,720,15,15,null,null,null,null,null,null,null,null,null,28000]
[11,48000,720,720,9,9,null,null,null,null,null,null,null,null,null,30000]
[12,51200,720,720,4,4,null,null,null,null,null,null,null,null,null,32000]

{"sheet":"Method_input","index":6,"n_rows":50,"n_cols":9,"rows_kept":50,"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"]
[null,"ϑ"]
[]
["Name","Symbol","Software name","Unit","Value","Range","Origin","Varying","Notes"]
["Operating conditions data"]
["heat output","QH,gen,out ","Q_H_gen_out","kWh",51200,"0...∞","M3-6","YES"]
["calculation interval","tci ","t_ci","h",720,"0…8760","M1-9","YES"]
["total time of required heater operation","tlrh,gen ","t_gnr","h",720,"0…8760","M1-6","YES"]
["average external temperature in the calculation interval","ϑext","theta_ext","°C",4,"-50…+50","M1-13","YES"]
["indoor temperature of the room where the heater is located","ϑint","theta_int","°C",4,"-50…+50","M1-13","YES"]
["Product data"]
["Product description data "]
["Heater type","LRH_TYPE","LRH_TYPE",null,{"$f":"+Product_descriptive_data!C9","v":"LRH_TYPE_AIR_MODUALL"},"List","Local","NO"]
["Energy use","LRH_USE","LRH_USE",null,{"$f":"+Product_descriptive_data!C25","v":"LRH_USE_H"},"List","Local","NO"]
["Fuel","LRH_FUEL","LRH_FUEL",null,{"$f":"+Product_descriptive_data!C34","v":"LRH_FUEL_GAS"},"List","Local","NO"]
["Type of power control","LRH_CTRL_POW","LRH_CTRL_POW",null,{"$f":"+Product_descriptive_data!C43","v":"LRH_CTRL_POW_MODUL"},"List","Local","NO"]
["Condensing heater","LHR_COND","LHR_COND",null,{"$f":"+Product_descriptive_data!C51","v":"LRH_COND_YES"},"List","Local","NO"]
["Pilot flame","LRH_PILOT","LRH_PILOT",null,{"$f":"+Product_descriptive_data!C58","v":"LRH_PILOT_NO"},"List","Local","NO"]
["Heated room ventilation","LRH_VENT","LRH_VENT",null,{"$f":"Product_descriptive_data!C65","v":"LRH_VENT_NO"},"List","Local","NO"]
["Product technical data "]
["Full load combustion power;","Фlrh;cmb;Pn ","Phi_lrh_cmb_pn","kW",{"$f":"+Product_tech_data!D5","v":126},"0...∞","Local","NO"]
["Fuel flow rate at full power","V'lrh;fuel;Pn","V_lrh_fuel_Pn","QT/h",null,"0...∞","Local","NO"]
["Heat losses to the flue with burner on at full load","αlrh;ch;ON","alpha_lrh_ch_ON","%",{"$f":"+Product_tech_data!D9","v":4},"0…20","Local","NO"]
["Correction factor for heat losses to the flue with burner on","flrh;corr;ch;ON","f_lrh_corr_ch_ON","-",{"$f":"+Product_tech_data!D10","v":0.18},"0…1","Local","NO"]
["Test  temperature for  heat losses to the flue with burner on","ϑlrh;air;test;ON","theta_lrh_air_test_ON","°C",{"$f":"+Product_tech_data!D11","v":20},"0…40","Local","NO"]
["Load factor exponent","nlrh;ch;ON","n_lrh_ch_ON","-",{"$f":"+Product_tech_data!D54","v":0.1},"0…1","Local","NO"]
["Auxiliary power of equipment related to the burner ","Φlrh;aux;br","Phi_lrh_aux_br","W",{"$f":"+Product_tech_data!D55","v":500},"0...∞","Local","NO"]
["Auxiliary power of equipment after the burner ","Φlrh;aux;blw","Phi_lrh_aux_blw","W",{"$f":"+Product_tech_data!D56","v":800},"0...∞","Local","NO"]
["Losses through the generator envelope","αlrh;env","alpha_lrh_env","%",{"$f":"+Product_tech_data!D59","v":1.6016739202965449},"0…40","Local","NO"]
["Pilot flame losses","αlrh;pilot","alpha_lrh_pilot","%",{"$f":"+Product_tech_data!D74","v":0},"0…10","Local","NO"]
["Specific ventilation requirement","Vlrh;vent","V_lrh_vent","m³/h",1.3,"-50…+50","EN 13410","NO"]
["Data for modulating heaters"]
["Minimum power combustion power;","Фlrh;cmb;Pmin ","Phi_lrh_cmb_Pmin ","kW",{"$f":"+Product_tech_data!D6","v":63},"0...∞","Local","NO"]
["Fuel flow rate at minimum power","V'lrh;fuel;Pmin","V_lrh_fuel_Pmin","QT/h",null,"0...∞","Local","NO"]
["Loss factor with burner ON at minimum load","αlrh;ch;ON;Pmin","alpha_lrh_ch_ON_Pmin","%",{"$f":"+Product_tech_data!D29","v":3},"0…20","Local","NO"]
["Auxiliary power of equipment related to the burner at minimum power","Φlrh;aux;br;Pmin","Phi_lrh_aux_br_Pmin","W",{"$f":"+E27","v":500},"0...∞","Local","NO"]
["Auxiliary power of equipment after the burner at minimum power","Φlrh;aux;blw;Pmin","Phi_lrh_aux_blw_Pmin","W",{"$f":"+E28","v":800},"0...∞","Local","NO"]
["Data for condensing heaters"]
["Combustion efficiency of condensing heaters ","ηlrh;comb","eta_lrh_comb","%",{"$f":"+Product_tech_data!D86","v":99},"0…10","Local","NO"]
["Combustion efficiency of condensing heaters at Pmin","ηlrh;comb;Pmin","eta_lrh_comb_Pmin","%",{"$f":"+Product_tech_data!D87","v":106},"0…10","Local","NO"]
["System design data"]
["Process design"]
["Auxiliary energy recovery factor ","klrh;aux;rh","k_lrh_aux_rh","-",{"$f":"+Process_design_data!D4","v":0.8},"0…1","Local","NO"]
["Correction factor of envelope losses","klrh;env ","k_lrh_env ",".",{"$f":"+Process_design_data!D15","v":0.7},"0…1","Local","NO"]
["height of the building","Hlrh","H_lrh","m",{"$f":"+Process_design_data!D29","v":6},"0…100","Local","NO"]
["Air temperature vertical gradient","dϑ;H","Nabla_theta_H","°C/m",{"$f":"+Process_design_data!D30","v":0.3},"0…10","Local","NO"]
["Difference between air and radiant temperature","Δϑlrh;rad","Deltatheta_lhr_rad","°C",{"$f":"+Process_design_data!D31","v":2.5},"-10…+10","Local","NO"]
["Control type data"]
["Constants"]
["Air specific heat","cp;air","cp_air","Wh/m³K",0.3,null,"EN XXXX","NO"]

{"sheet":"Method_calculation","index":7,"n_rows":186,"n_cols":8,"rows_kept":186,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["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","Software name","Unit","Value","Formula ref","Formula","Notes"]
[]
["Generation sub-system required output","QH;gen;out ",null,"kWh",{"$f":"+Method_input!E6","v":51200},null,null,"Data transfer"]
["MAXIMUM ENERGY OUTPUT"]
[]
["Full load combustion power;","Фlrh;cmb;Pn ",null,"kW",{"$f":"+Method_input!E21","v":126},null,null,"Data transfer"]
["calculation interval","tci ","t_ci","h",{"$f":"+Method_input!E7","v":720},null,null,"Data transfer"]
["total time of required heater operation","tlrh;gen ","t_gnr","h",{"$f":"+Method_input!E8","v":720},null,null,"Data transfer"]
["Heat losses to the flue with burner on at full load","αlrh;ch;ON","alpha_lrh_ch_ON","%",{"$f":"+Method_input!E23","v":4}]
["Maximum energy output ","QH;gen;out;max;ci",null,"kWh",{"$f":"+E8*E10*(1-E61/100)","v":88742.366652734447},"(5)",null,"Method output"]
["Iteration control",null,null,null,true,null,"Set to TRUE to start iterations","Just for spreadsheet test"]
["Iteration initial value for βlrh;cmb ",null,null,null,{"$f":"+E5/(E10*E8)","v":0.56437389770723101},"(26)"]
[]
["Load factor","βlrh;cmb ",null,"p.u.",{"$f":"+IF(E13,E67,E14)","v":0.56989089767275702}]
["Burner ON time","tlrh;ON",null,"h",{"$f":"+E16*E10","v":410.32144632438508},"(6)",null,"Iteration start"]
["average external temperature in the calculation interval","ϑext","theta_ext","°C",{"$f":"+Method_input!E9","v":4},null,null,"Data transfer"]
["indoor temperature of the room where the heater is located","ϑint","theta_int","°C",{"$f":"+Method_input!E10","v":4},null,null,"Data transfer"]
["6.4.4.3 Losses through the chimney with burner on "]
["Heater type","LRH_TYPE","LRH_TYPE",null,"LRH_TYPE_LUM",null,null,"Data transfer"]
["Combustion air temperature","ϑlrh;gen;air",null,"°C",{"$f":"IF(E21=Product_descriptive_data!C12,Method_calculation!E19,Method_calculation!E18)","v":4},null,"To be developed: selection of intake air temperature"]
["Test  temperature for  heat losses to the flue with burner on","ϑlrh;air;test;ON","theta_lrh_air_test_ON","°C",{"$f":"+Method_input!E25","v":20},null,null,"Data transfer"]
["Load factor exponent","nlrh;ch;ON","n_lrh_ch_ON","-",{"$f":"+Method_input!E26","v":0.1},null,null,"Data transfer"]
["Correction factor for heat losses to the flue with burner on","flrh;corr;ch;ON","f_lrh_corr_ch_ON","-",{"$f":"+Method_input!E24","v":0.18},null,null,"Data transfer"]
["Actual specific heat losses through the chimney with the burner on ","αlrh;ch;on;corr ",null,"-",{"$f":"+(E11+(E22-E23)*E25)*(E16^E24)","v":1.0587591941362815},"(10)"]
["6.4.4.4 Induced ventilation heat losses αlrh,vent,ON and αlrh,vent,OFF"]
["height of the building","Hlrh","H_lrh","m",{"$f":"+Method_input!E45","v":6},null,null,"Data transfer"]
["Air temperature vertical gradient","??","??","°C/m",{"$f":"+Method_input!E46","v":0.3},null,null,"Data transfer"]
["Difference between air and radiant temperature","Δϑlrh;rad","deltatheta_lhr_rad","°C",{"$f":"+Method_input!E47","v":2.5},null,null,"Data transfer"]
["temperature of the air/flue-mixture exiting the building near the roof ","ϑlrh;air;exh ",null,"°C",{"$f":"+E19-E30+E28*E29","v":3.3},"(15)"]
["Specific ventilation requirement","Vlrh;vent","V_lrh_vent","m³/hkW",{"$f":"+Method_input!E31","v":1.3},null,null,"Data transfer"]
["Air specific heat","cp;air","cp_air","Wh/kg°C",{"$f":"+Method_input!E50","v":0.3},null,null,"Data transfer"]
["absolute induced ventilation heat loss ","Φlrh;vent ",null,"W",{"$f":"+E32*E8*E33*(E31-E18)","v":-34.39800000000001},"(14)"]
["specific ventilation loss ","αlrh;vent ",null,"%",{"$f":"+E34*100/(E8*1000)","v":-2.7300000000000008E-2},"(13)"]
["Heated room ventilation","LRH_VENT","LRH_VENT",null,{"$f":"+Method_input!E19","v":"LRH_VENT_NO"}]
["Type A heater?",null,null,null,{"$f":"NOT(E36=Product_descriptive_data!C69)","v":false}]
["Interlok of fan?",null,null,null,{"$f":"E36=Product_descriptive_data!C68","v":false}]
["ventilation heat losses with burner ON","αlrh;vent;ON ",null,"%",{"$f":"IF(E37,E35,0)","v":0},"(16) (17)"]
["ventilation heat losses with burner OFF","αlrh;vent;OFF ",null,"%",{"$f":"IF(AND(E37,NOT(E38)),E35,0)","v":0},"(18) (19)"]
["6.4.4.5 Corrected envelope losses αlrh,env,corr"]
["Losses through the generator envelope","αlrh;env","alpha_lrh_env","%",{"$f":"+Method_input!E29","v":1.6016739202965449},null,null,"Data transfer"]
["Correction factor of envelope losses","klrh;env ","k_lrh_env ",".",{"$f":"+Method_input!E44","v":0.7},null,null,"Data transfer"]
["Corrected envelope losses ","αlrh;env;corr ",null,"%",{"$f":"+E42*E43","v":1.1211717442075813},"(20)"]
["6.4.4.6 Heat recovery from condensation αlrh,cond"]
["Combustion efficiency of condensing heaters ","ηlrh;comb","eta_lrh_comb","%",{"$f":"+Method_input!E39","v":99},null,null,"Data transfer"]
["Condensing heater","LHR_COND","LHR_COND",null,{"$f":"+Method_input!E17","v":"LRH_COND_YES"},null,null,"Data transfer"]
["Condensing heater ?",null,null,null,{"$f":"E47=Product_descriptive_data!C53","v":true},null,null,"Data transfer"]
["heat recovery from condensation ","αlrh;cond",null,"%",{"$f":"IF(E48,IF(E46>100,E46-100,0),0)","v":0},"(21)"]
["6.4.5.1 Auxiliary energy related to time burner on"]
["Auxiliary power of equipment related to the burner ","Φlrh;aux;br","Phi_lrh_aux_br","kW",{"$f":"+Method_input!E27/1000","v":0.5},null,null,"Data transfer"]
["auxiliary energy for the generator related to time when burner on ","Wlrh;br ",null,"kWh",{"$f":"+E51*E17","v":205.16072316219254},"(22)"]
["Auxiliary energy recovery factor (burner)","klrh;aux;br;rh","k_lrh_aux_br_rh","-",{"$f":"+Method_input!E43","v":0.8}]
["Recovered auxiliary energy for the generator related to time when burner on ","Qlrh;br;rh  ",null,"kWh",{"$f":"+E53*E52","v":164.12857852975404},"(23)"]
["6.4.5.2 Auxiliary energy of additional devices (after the burner)"]
["Auxiliary power of equipment after the burner ","Φlrh;aux;blw","Phi_lrh_aux_blw","kW",{"$f":"+Method_input!E28/1000","v":0.8},null,null,"Data transfer"]
["auxiliary energy of additional devices after the burner ","Wlrh;blw ",null,"kWh",{"$f":"+E56*E10","v":576},"(24)"]
["Auxiliary energy recovery factor  (constnt op.)","klrh;aux;blw;rh","k_lrh_aux_blw_rh","-",{"$f":"+Method_input!E43","v":0.8},null,null,"Data transfer"]
["Rcovered auxiliary energy of additional devices after the burner ","Qlrh;blw;rh ",null,"kWh",{"$f":"+E58*E57","v":460.8},"(25)"]
["6.4.6 Energy calculation"]
["Burner ON losses ","αlrh;ON",null,"%",{"$f":"+E26+E39+E44-E49","v":2.1799309383438628},"(8)"]
["Pilot flame","LRH_PILOT","LRH_PILOT",null,{"$f":"+Method_input!E18","v":"LRH_PILOT_NO"},null,null,"Data transfer"]
["Pilot flame?",null,null,null,{"$f":"E62=Product_descriptive_data!C60","v":false}]
["Pilot flame losses",null,null,"%",{"$f":"+Method_input!E30","v":0},null,null,"Data transfer"]
["Pilot flame losses","αlrh;pilot","alpha_lrh_pilot","%",{"$f":"IF(E63,E64,0)","v":0},null,null,"Actual value"]
["Burner OFF losses ","αlrh;OFF",null,"%",{"$f":"+E65+E40","v":0},"(9)"]
["New load factor","βlrh;cmb ",null,"p.u.",{"$f":"+(100*((E5-E59)/(E8*E10))+E66)/(100*(1+E54/E5)-E61+E66)","v":0.56989089767275702},"(27)"]
[]
["Fuel heat input ","EH;gen;in ",null,"kWh",{"$f":"+E8*E17","v":51700.502236872519},"(28)",null,"Method output - Single stage"]
["total auxiliary energy ","Wgnr;aux",null,"kWh",{"$f":"+E17*E51+E56*E10","v":781.16072316219254},"(29)",null,"Method output - Single stage"]
["total recoverable heat losses ","QH;gen;ls;rbl  ",null,"kWh",0,null,"See clause 6.4.6 item 9)","Method output - Single stage"]
["Fuel used",null,null,null,{"$f":"+Method_input!$E$15","v":"LRH_FUEL_GAS"},"See note","No calculation. Just pass the information to subsequent modules to appy the relevant weuighting factors for deliverd energy","Method output - Single stage"]
[]
["7       Multistage and modulating heaters "]
["Generation sub-system required output","QH;gen;out ",null,"kWh",{"$f":"+Method_in","v":51200},null,null,"Data transfer"]
["Full load combustion power;","Фlrh;cmb;Pn ",null,"kW",{"$f":"+Method_input!E21","v":126},null,null,"Data transfer"]
["Minimum power combustion power","Фlrh,cmb,Pmin ",null,"kW",{"$f":"+Method_input!E33","v":63},null,null,"Data transfer"]
["modulating ration ","klrh;mod ",null,null,{"$f":"+E77/E76","v":0.5},"(31)"]
["total time of required heater operation","tlrh;gen ","t_gnr","h",{"$f":"+Method_input!E8","v":720},null,null,"Data transfer"]
[]
["ON_OFF mode"]
["Iteration control",null,null,null,true,null,"Set to TRUE to start iterations","Just for spreadsheet test"]
["Iteration initial value for βlrh;cmb;min","βlrh;cmb;min ",null,null,{"$f":"+E75/(E77*E79)","v":1.128747795414462},"(26)"]
["Load factor","βlrh;cmb;min ",null,"p.u.",{"$f":"+IF(E82,E120,E83)","v":1.0689587380030769},null,null,"Iteration start"]
["Burner ON time","tlrh;ON",null,"h",{"$f":"+E84*E79","v":769.6502913622154},"(33)"]
["Burner OFF time","tlrh;OFF",null,"h",{"$f":"+E79-E85","v":-49.650291362215398},"(34)"]
[]
["Heat losses to the flue with burner on at minimum load","αlrh;ch;ON;Pmin",null,"%",{"$f":"+Method_input!E35","v":3},null,null,"Data transfer"]
["average external temperature in the calculation interval","ϑext","theta_ext","°C",{"$f":"+Method_input!E9","v":4},null,null,"Data transfer"]
["indoor temperature of the room where the heater is located","ϑint","theta_int","°C",{"$f":"+Method_input!E10","v":4},null,null,"Data transfer"]
["Heater type","LRH_TYPE","LRH_TYPE",null,"LRH_TYPE_LUM",null,null,"Data transfer"]
["Combustion air temperature","ϑlrh;gen;air",null,"°C",{"$f":"IF(E91=Product_descriptive_data!$C$87,Method_calculation!E89,Method_calculation!E90)","v":4},null,"To be developed: selection of intake air temperature"]
["Test  temperature for  heat losses to the flue with burner on","ϑlrh;air;test;ON","theta_lrh_air_test_ON","°C",{"$f":"+Method_input!E25","v":20},null,null,"Data transfer"]
["Load factor exponent","nlrh;ch;ON","n_lrh_ch_ON","-",{"$f":"+Method_input!E26","v":0.1},null,null,"Data transfer"]
["Correction factor for heat losses to the flue with burner on","flrh;corr;ch;ON","f_lrh_corr_ch_ON","-",{"$f":"+Method_input!E24","v":0.18},null,null,"Data transfer"]
["Actual specific heat losses through the chimney with the burner on at minimum power ","αlrh;ch;on;corr ",null,"-",{"$f":"+(E88+(E92-E93)*E95)*(E84^E94)","v":0.12080289446819584},"(41)"]
[]
["ventilation heat losses with burner ON","αlrh;vent;ON ",null,"%",{"$f":"+E39","v":0},null,null,"Same as ON-OFF"]
["ventilation heat losses with burner OFF","αlrh;vent;OFF",null,"%",{"$f":"+E40","v":0},null,null,"Same as ON-OFF"]
["Corrected envelope losses ","αlrh;env;corr ",null,"%",{"$f":"+E44","v":1.1211717442075813},null,null,"Same as ON-OFF"]
[]
["Combustion efficiency of condensing heaters ","ηlrh;comb","eta_lrh_comb","%",{"$f":"+Method_input!E40","v":106},null,null,"Data transfer"]
["Condensing heater","LHR_COND","LHR_COND",null,{"$f":"+Method_input!E17","v":"LRH_COND_YES"},null,null,"Data transfer"]
["Condensing heater ?",null,null,null,{"$f":"E103=Product_descriptive_data!$C$53","v":true},null,null,"Data transfer"]
["heat recovery from condensation at minimum power ","αlrh;cond;Pmin",null,"%",{"$f":"IF(E104,IF(E102>100,E102-100,0),0)","v":6},"(41)"]
["Burner ON losses at minimum power ","αlrh,ON,Pmin ",null,"%",{"$f":"+E96+((E98+E100)/E78)-E105","v":-3.6368536171166417},"(38)"]
[]
["Pilot flame losses","αlrh;pilot","alpha_lrh_pilot","%",{"$f":"+E65","v":0},null,null,"Same as ON-OFF"]
["Burner OFF losses at referred to minimum power","αlrh,OFF;Pmin ",null,"%",{"$f":"+(E108+E99)/E78","v":0},"(39)"]
[]
["Auxiliary power of equipment related to the burner ","Φlrh;aux;br","Phi_lrh_aux_br","kW",{"$f":"+Method_input!E27/1000","v":0.5},null,null,"Data transfer"]
["auxiliary energy for the generator related to time when burner on ","Wlrh;br ",null,"kWh",{"$f":"+E111*E85","v":384.8251456811077},"(22)"]
["Auxiliary energy recovery factor (burner)","klrh;aux;br;rh","k_lrh_aux_br_rh","-",{"$f":"+Method_input!E43","v":0.8}]
["Recovered auxiliary energy for the generator related to time when burner on ","Qlrh;br;rh  ",null,"kWh",{"$f":"+E113*E112","v":307.86011654488618},"(23)"]
[]
["Auxiliary power of equipment after the burner ","Φlrh;aux;blw","Phi_lrh_aux_blw","kW",{"$f":"+Method_input!E28/1000","v":0.8},null,null,"Data transfer"]
["auxiliary energy of additional devices after the burner ","Wlrh;blw ",null,"kWh",{"$f":"+E116*E79","v":576},"(24)"]
["Auxiliary energy recovery factor  (constnt op.)","klrh;aux;blw;rh","k_lrh_aux_blw_rh","-",{"$f":"+Method_input!E43","v":0.8},null,null,"Data transfer"]
["Rcovered auxiliary energy of additional devices after the burner ","Qlrh;blw;rh ",null,"kWh",{"$f":"+E118*E117","v":460.8},"(25)"]
["New load factor","βlrh;cmb;min ",null,"p.u.",{"$f":"(100*(E75-E119)/(E77*E79)+E109)/(100+(1+E114/E75)-E106+E109)","v":1.0689587380030769},"(43)"]
[]
["Fuel heat input ","EH;gen;in ",null,"kWh",{"$f":"+E85*E77","v":48487.968355819568},"(44)",null,"Method output, multistage ON-OFF mode"]
["total auxiliary energy ","Wgnr;aux",null,"kWh",{"$f":"+E85*E111+E116*E79","v":960.82514568110764},"(45)",null,"Method output, multistage ON-OFF mode"]
["total recoverable heat losses ","QH;gen;ls;rbl  ",null,"kWh",0,null,"See clause 6.4.6 item 9)","Method output, multistage ON-OFF mode"]
["Fuel used",null,null,null,{"$f":"+Method_input!$E$15","v":"LRH_FUEL_GAS"},"See note","No calculation. Just pass the information to subsequent modules to appy the relevant weuighting factors for deliverd energy","Method output, multistage ON-OFF mode"]
[]
["MODULATING  mode"]
[]
["Burner ON time","tlrh;ON",null,"h",{"$f":"+E10","v":720},"(35)"]
["Burner OFF time","tlrh;OFF",null,"h",0,"(36)"]
[]
["Heat losses to the flue with burner on at maximum load","αlrh;ch;ON",null,"%",{"$f":"+Method_input!E23","v":4},null,null,"Data transfer"]
["average external temperature in the calculation interval","ϑext","theta_ext","°C",{"$f":"+E89","v":4},null,null,"Data transfer"]
["indoor temperature of the room where the heater is located","ϑint","theta_int","°C",{"$f":"+E90","v":4},null,null,"Data transfer"]
["Heater type","LRH_TYPE","LRH_TYPE",null,"LRH_TYPE_LUM",null,null,"Data transfer"]
["Combustion air temperature","ϑlrh;gen;air",null,"°C",{"$f":"IF(E135=Product_descriptive_data!$C$87,Method_calculation!E133,Method_calculation!E134)","v":4},null,"To be developed: selection of intake air temperature"]
["Test  temperature for  heat losses to the flue with burner on","ϑlrh;air;test;ON","theta_lrh_air_test_ON","°C",{"$f":"+E93","v":20},null,null,"Data transfer"]
["Load factor exponent","nlrh;ch;ON","n_lrh_ch_ON","-",{"$f":"+Method_input!E26","v":0.1},null,null,"Data transfer"]
["Correction factor for heat losses to the flue with burner on","flrh;corr;ch;ON","f_lrh_corr_ch_ON","-",{"$f":"+Method_input!E24","v":0.18},null,null,"Data transfer"]
["Load factor at Pn",null,null,null,1]
["Actual specific heat losses through the chimney with the burner on at full load","αlrh;ch;on;Pn;corr ",null,"-",{"$f":"+(E132+(E136-E137)*E139)*(E140^E138)","v":1.1200000000000001},"(41)"]
[]
["ventilation heat losses with burner ON","αlrh;vent;ON ",null,"%",{"$f":"+E98","v":0},null,null,"Already calculated"]
["Corrected envelope losses ","αlrh;env;corr ",null,"%",{"$f":"+E100","v":1.1211717442075813},null,null,"Already calculated"]
["heat recovery from condensation at maximum power ","αlrh;cond",null,"%",{"$f":"+E49","v":0},null,null,"Already calculated"]
["total losses when the burner is ON at maximum power ","αlrh,ON;Pn ",null,"%",{"$f":"+E141+E143+E144-E145","v":2.2411717442075814},"(37)"]
[]
["Actual specific heat losses through the chimney with the burner on at minimum power ","αlrh;ch;on;corr ",null,"%",{"$f":"+E96","v":0.12080289446819584},null,null,"Already calculated"]
["heat recovery from condensation at minimum power ","αlrh;cond;Pmin",null,"%",{"$f":"+E105","v":6},null,null,"Already calculated"]
["total losses when the burner is ON at minimum power ","αlrh,ON;Pmin ",null,"%",{"$f":"+E148+(E144+E143)/E78-E149","v":-3.6368536171166417},"(38)"]
[]
["average combustion power ","Φlrh;cmb;avg  ",null,"kW",{"$f":"+E75/E79","v":71.111111111111114},"(46)"]
["Iteration control",null,null,null,true,null,"Set to TRUE to start iterations","Just for spreadsheet test"]
["average combustion power ","Φlrh;cmb;avg  ",null,"kW",{"$f":"IF(E153,E170,E152)","v":67.912507375662955},null,null,"Current average power value"]
[]
["modulation factor ","βlrh;mod ",null,"p.u.",{"$f":"+(E154-E77)/(E76-E77)","v":7.7976307550205626E-2},"(47)"]
[]
["Auxiliary power of equipment related to the burner ","Φlrh;aux;br","Phi_lrh_aux_br","kW",{"$f":"+Method_input!E27","v":500},null,null,"Data transfer"]
["auxiliary energy for the generator related to time when burner on ","Wlrh;br ",null,"kWh",{"$f":"+E158*E129/1000","v":360},"(22)"]
["Auxiliary energy recovery factor (burner)","klrh;aux;br;rh","k_lrh_aux_br_rh","-",{"$f":"+Method_input!$E$43","v":0.8}]
["Recovered auxiliary energy for the generator related to time when burner on ","Qlrh;br;rh  ",null,"kWh",{"$f":"+E160*E159","v":288},"(23)"]
[]
["Auxiliary power of equipment after the burner ","Φlrh;aux;blw","Phi_lrh_aux_blw","kW",{"$f":"+Method_input!E28","v":800},null,null,"Data transfer"]
["auxiliary energy of additional devices after the burner ","Wlrh;blw ",null,"kWh",{"$f":"+E163*E79/1000","v":576},"(24)"]
["Auxiliary energy recovery factor  (constnt op.)","klrh;aux;blw;rh","k_lrh_aux_blw_rh","-",{"$f":"+Method_input!$E$43","v":0.8},null,null,"Data transfer"]
["Rcovered auxiliary energy of additional devices after the burner ","Qlrh;blw;rh ",null,"kWh",{"$f":"+E165*E164","v":460.8},"(25)"]
[]
["losses with burner on at average power ","αlrh;ON;avg ",null,"%",{"$f":"+E150+(E146-E150)*E156","v":-3.1785069037541156},"(48)"]
[]
["new average combustion power ","Φlrh;cmb;avg ",null,"kW",{"$f":"+(E75-E166-E161)/(E79*(1-E168/100))","v":67.912507375663125},"(49)"]
[]
["Fuel heat input ","EH;gen;in ",null,"kWh",{"$f":"+E170*E79","v":48897.005310477449},"(50)",null,"Method output, multistage ON-OFF mode"]
["total auxiliary energy ","Wgnr;aux",null,"kWh",{"$f":"+E158*E129/1000+E163*E79/1000","v":936},"(51)",null,"Method output, multistage ON-OFF mode"]
["total recoverable heat losses ","QH;gen;ls;rbl  ",null,"kWh",0,null,"See clause 6.4.6 item 9)","Method output, multistage ON-OFF mode"]
["Fuel used",null,null,null,{"$f":"+Method_input!$E$15","v":"LRH_FUEL_GAS"},"See note","No calculation. Just pass the information to subsequent modules to appy the relevant weuighting factors for deliverd energy","Method output, multistage ON-OFF mode"]
[]
["Output selection"]
["Power control type","LRH_CTRL_POW",null,"List",{"$f":"+Method_input!E16","v":"LRH_CTRL_POW_MODUL"}]
["Single stage burner?",null,null,null,{"$f":"E178=Product_descriptive_data!C45","v":false}]
["Modulating in ON-OFF mode?",null,null,null,{"$f":"E120<1","v":false}]
[]
["Selected output"]
["Fuel heat input ","EH;gen;in ",null,"kWh",{"$f":"IF($E$179,E69,IF($E$180,E122,E172))","v":48897.005310477449}]
["total auxiliary energy ","Wgnr;aux",null,"kWh",{"$f":"IF($E$179,E70,IF($E$180,E123,E173))","v":936}]
["total recoverable heat losses ","QH;gen;ls;rbl  ",null,"kWh",0]
["Fuel used",null,null,null,"LRH_FUEL_GAS"]

{"sheet":"Method_output","index":8,"n_rows":15,"n_cols":9,"rows_kept":15,"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"]
["Energy flow data"]
["Generation input","EH;gen;in ","E_H_gen_in","kWh",{"$f":"+Method_calculation!E183","v":48897.005310477449},"0...∞","M3-1","YES","Required fuel input"]
["Recoverable heat losses","QH;gen;ls;rbl  ","Q_H_gen_ls_rbl  ","kWh",{"$f":"+Method_calculation!E185","v":0},"0...∞","M2-2","YES","Recoverable heat for heating "]
["Total auxiliary energy ","WH;gen;aux","W_H_gen_aux","kWh",{"$f":"+Method_calculation!E184","v":936},"0...∞","M3-1","YES","Total auxiliary energy"]
["Operating condition data"]
["Maximum energy output ","QH;gen;out;max","Q_H_gen_out_max","kWh",{"$f":"+Method_calculation!E12","v":88742.366652734447},"0...∞","?","YES","Could be also expressed as power"]
["Other data"]
["Fuel type","LRH_FUEL","LRH_FUEL","List",{"$f":"+Method_calculation!E186","v":"LRH_FUEL_GAS"},"List","M3-1","YES","Needed to apply the right weighting factors"]
[]
["Thermal efficiency",null,null,null,{"$f":"+Method_in/Method_out","v":1.0470988903083003}]

{"sheet":"Output_series","index":9,"n_rows":29,"n_cols":10,"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,9]
[]
["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,"maximum output"]
[null,"kWh","kWh","kWh",null,null,null,null,null,"Thermal"]
["Symbol","EH,gen,in","QH,gen,rbl","WH,gnr,aux",null,"QH;gen;out;max",null,"LRH_FUEL",null,"Efficiency"]
["Destination"]
["Time stamp",null,null,"VALUES"]
[1,14825.049045474043,0,693.65911940852413,null,88986.890085522013,null,"LRH_FUEL_GAS",null,1.0792544396259289]
[2,17990.454451841182,0,718.78138453842212,null,88413.753232520787,null,"LRH_FUEL_GAS",null,1.0672326289142202]
[3,21234.697153483576,0,744.52934248796487,null,87681.574687701024,null,"LRH_FUEL_GAS",null,1.0548773000195699]
[4,24456.968651938842,0,770.10292580903842,null,87220.355264621889,null,"LRH_FUEL_GAS",null,1.0467364277367441]
[5,27715.416754383383,0,795.96362503478872,null,86751.201465630191,null,"LRH_FUEL_GAS",null,1.0391328499668]
[6,31011.243394085959,0,822.12097931814253,null,86274.986556751013,null,"LRH_FUEL_GAS",null,1.0318838104409127]
[7,34345.63348417294,0,848.58439273153135,null,85792.386463063565,null,"LRH_FUEL_GAS",null,1.024875549790653]
[8,37455.652681005537,0,873.26708476988529,null,85908.737229269071,null,"LRH_FUEL_GAS",null,1.0252124112490331]
[9,40412.47347572857,0,896.73391647403628,null,86334.49819443599,null,"LRH_FUEL_GAS",null,1.0293851482509391]
[10,43184.417107565561,0,918.73346910766327,null,87074.985213127715,null,"LRH_FUEL_GAS",null,1.0374112469414667]
[11,46031.549166565914,0,936,null,87980.304139704109,null,"LRH_FUEL_GAS",null,1.0427630803019732]
[12,48897.00530989893,0,936,null,88742.366652734447,null,"LRH_FUEL_GAS",null,1.0470988903206888]

{"sheet":"History","index":10,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2013-11-15","First version for I/O check"]
[null,"2014-01-25","First version with working calculation procedure"]

{"sheet":"TEMPLATE_INFO","index":11,"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 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":12,"n_rows":119,"n_cols":30,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,9,0,20],[0,22,0,30],[36,23,36,24],[36,25,36,26],[36,27,36,28],[36,29,36,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 descriptive data (qualitative)"]
[]
["Boiler use"]
[1,null,"BLR_USE",{"$f":"INDEX(D9:D11,A7)","v":"BLR_USE_H"}]
[]
["Heating",null,null,"BLR_USE_H"]
["Domestic hot water",null,null,"BLR_USE_DHW"]
["All",null,null,"BLR_USE_ALL"]
[]
[]
["Fuel"]
[1,null,"BLR_FUEL",{"$f":"INDEX(D17:D19,A15)","v":"BLR_FUEL_GAS"}]
["Values"]
["Gas",null,null,"BLR_FUEL_GAS"]
["Oil",null,null,"BLR_FUEL_OIL"]
["All",null,null,"BLR_FUEL_ALL"]
[]
[]
["Boiler type, condensing / non condensing"]
[2,null,"BLR_COND",{"$f":"INDEX(D25:D26,A23)","v":"BLR_COND_NO"}]
["Values"]
["Condensing",null,null,"BLR_COND_YES"]
["Non condensing",null,null,"BLR_COND_NO"]
[]
[]
["Product technical data"]
[]
["Generator output at full load;",null,null,null,"ФPn ","kW",60]
[]
[]
["Boiler product data",null,"BLR_DATA",{"$f":"INDEX(D38:D49,C36)","v":"BLR_DATA_GAS_LT"}]
[]
[null,null,2]
["Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Display ?","Condensing ?",null,"Fuel ?",null,"Condition 3?",null,"Condition 4?"]
[{"$f":"IF(W38,B38,\"NOT COMPATIBLE\")","v":"Gas, standard, minimum value"},"Gas, standard, minimum value",null,"BLR_DATA_GAS_STD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(X38,Z38,AB38,AD38)","v":true},{"$f":"$D$23=Y38","v":true},"BLR_COND_NO",{"$f":"OR($D$15=$D$19,$D$15=AA38)","v":true},"BLR_FUEL_GAS",true,null,true]
[{"$f":"IF(W39,B39,\"NOT COMPATIBLE\")","v":"Gas, low temperature, minimum value"},"Gas, low temperature, minimum value",null,"BLR_DATA_GAS_LT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(X39,Z39,AB39,AD39)","v":true},{"$f":"$D$23=Y39","v":true},"BLR_COND_NO",true,"BLR_FUEL_GAS",true,null,true]
["NOT COMPATIBLE","Gas, Condensing, minimum value",null,"BLR_DATA_GAS_CND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"BLR_COND_YES",true,"BLR_FUEL_GAS",true,null,true]
["NOT COMPATIBLE","Oil, standard, minimum value",null,"BLR_DATA_OIL_STD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,true,"BLR_COND_NO",false,"BLR_FUEL_OIL",true,null,true]
["NOT COMPATIBLE","Oil, low temperature, minimum value",null,"BLR_DATA_OIL_LT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,true,"BLR_COND_NO",false,"BLR_FUEL_OIL",true,null,true]
["NOT COMPATIBLE","Oil, condensing, minimum value",null,"BLR_DATA_OIL_CND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"BLR_COND_YES",false,"BLR_FUEL_OIL",true,null,true]
["NOT COMPATIBLE","Default national: 1 - old oil boiler",null,"BLR_DATA_NAT_1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,true,"BLR_COND_NO",false,"BLR_FUEL_OIL",true,null,true]
["Default national: 2 - old gas boiler","Default national: 2 - old gas boiler",null,"BLR_DATA_NAT_2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,true,"BLR_COND_NO",true,"BLR_FUEL_GAS",true,null,true]
["Default national: 3 - new boiler","Default national: 3 - new boiler",null,"BLR_DATA_NAT_3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,true,"BLR_COND_NO",true,"BLR_FUEL_GAS",true,null,true]
["Make 1 boiler 1 gas (catalogue)","Make 1 boiler 1 gas (catalogue)",null,"BLR_DATA_CAT_01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,true,"BLR_COND_NO",true,"BLR_FUEL_GAS",true,null,true]
["NOT COMPATIBLE","Make 1 boiler 2 oil (catalogue)",null,"BLR_DATA_CAT_02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,true,"BLR_COND_NO",false,"BLR_FUEL_OIL",true,null,true]
["Custom values","Custom values",null,"BLR_DATA_USR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,true,"BLR_COND_NO",true,"BLR_FUEL_GAS",true,null,true]
[]
[]
["System design data"]
[]
["Localisation",null,"LOC",{"$f":"INDEX(D57:D60,C55)","v":"LOC_INT"}]
[null,null,1]
["Values"]
["Heated space",null,null,"LOC_INT"]
["Unheated space",null,null,"LOC_UNH"]
["Boiler room",null,null,"LOC_BLR"]
["External",null,null,"LOC_EXT"]
[]
[]
["Operating conditions"]
[]
[]
["Direct connection"]
["Independent flow rate"]
["Heat exchanger"]
["Last option"]
[]
[]
["Description",null,"Variable TAG","Option tag","Symbol","Unit","Value","Range",null,{"$f":"+D38","v":"BLR_DATA_GAS_STD"},{"$f":"+D39","v":"BLR_DATA_GAS_LT"},{"$f":"+D40","v":"BLR_DATA_GAS_CND"},{"$f":"+D41","v":"BLR_DATA_OIL_STD"},{"$f":"+D42","v":"BLR_DATA_OIL_LT"},{"$f":"+D43","v":"BLR_DATA_OIL_CND"},{"$f":"+D44","v":"BLR_DATA_NAT_1"},{"$f":"+D45","v":"BLR_DATA_NAT_2"},{"$f":"+D46","v":"BLR_DATA_NAT_3"},{"$f":"+D47","v":"BLR_DATA_CAT_01"},{"$f":"+D48","v":"BLR_DATA_CAT_02"},{"$f":"+D49","v":"BLR_DATA_USR"}]
["generator output at full load;",null,null,null,"ФPn ","kW",{"$f":"INDEX(J73:U73,1,$C$36)","v":60},null,null,{"$f":"+$G$31","v":60},60,60,60,60,60,60,60,60,45,30,{"$f":"+$G$31","v":60}]
["Boiler type",null,null,null,null,null,{"$f":"INDEX(J74:U74,1,$C$36)","v":"BLR_COND_NO"},null,null,"BLR_COND_NO","BLR_COND_NO","BLR_COND_YES","BLR_COND_NO","BLR_COND_NO","BLR_COND_YES","BLR_COND_NO","BLR_COND_NO","BLR_COND_NO","BLR_COND_NO","BLR_COND_NO","BLR_COND_YES"]
["Fuel type",null,null,null,null,null,{"$f":"INDEX(J75:U75,1,$C$36)","v":"BLR_FUEL_GAS"},null,null,"BLR_FUEL_GAS","BLR_FUEL_GAS","BLR_FUEL_GAS","BLR_FUEL_OIL","BLR_FUEL_OIL","BLR_FUEL_OIL","BLR_FUEL_OIL","BLR_FUEL_GAS","BLR_FUEL_GAS","BLR_FUEL_GAS","BLR_FUEL_OIL","BLR_FUEL_GAS"]
["CE marking",null,null,null,null,null,{"$f":"INDEX(J76:U76,1,$C$36)","v":"BLR_CE_YES"},null,null,"BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_YES","BLR_CE_NO","BLR_CE_YES"]
["Limited power",null,null,null,"ФPn,ltd","kW",null,null,null,{"$f":"IF(J73>400,400,J73)","v":60},{"$f":"IF(K73>400,400,K73)","v":60},60,60,60,60,60,60,60,45,30,60]
[null,null,null,null,"C1","%",null,null,null,85,88,94,85,88,94,92,91,93]
[null,null,null,null,"C2","%",null,null,null,2,1.5,1,2,1.5,1,0,0,0]
["generator efficiency at full load;",null,null,null,"ηgnr,Pn ","%",{"$f":"INDEX(J80:U80,1,$C$36)","v":90.667226875575466},null,null,{"$f":"J78+J79*LOG10(J77)","v":88.556302500767288},{"$f":"K78+K79*LOG10(K77)","v":90.667226875575466},95.778151250383644,88.556302500767288,90.667226875575466,95.778151250383644,92,91,93,94,92,93]
["generator output at intermediate load;",null,null,null,"ФPint ","kW",{"$f":"INDEX(J81:U81,1,$C$36)","v":18},null,null,{"$f":"+J73*0.3","v":18},{"$f":"+K73*0.3","v":18},18,{"$f":"+M73*0.3","v":18},{"$f":"+N73*0.3","v":18},{"$f":"+O73*0.3","v":18},18,18,18,13.5,9,18]
[null,null,null,null,"C3","%",null,null,null,81.5,89,98,81.5,89,{"$f":"98/1.05","v":93.333333333333329},90,89,91]
[null,null,null,null,"C4","%",null,null,null,3,1.5,1,3,1.5,{"$f":"1/1.05","v":0.95238095238095233},0,0,0]
["generator efficiency at intermediate load;",null,null,null,"ηgnr,Pint ","%",{"$f":"INDEX(J84:U84,1,$C$36)","v":91.667226875575466},null,null,{"$f":"J82+J83*LOG10(J77)","v":86.834453751150932},{"$f":"K82+K83*LOG10(K77)","v":91.667226875575466},99.778151250383644,86.834453751150932,91.667226875575466,95.026810714651077,90,89,91,94,92,93]
[null,null,null,null,"C5","%",null,null,null,8.5,5,4.8,8.5,5,4.8,5,5,5]
[null,null,null,null,"C6","%",null,null,null,-0.4,-0.35,-0.35,-0.4,-0.35,-0.35,-0.35,-0.35,-0.35]
["stand-by heat loss at test temperature difference Dθi,test;",null,null,null,"Фgnr,ls,P0","kW",{"$f":"INDEX(J87:U87,1,$C$36)","v":0.71576147134151091},null,null,{"$f":"+J73*(J85/100)*(J73^J86)","v":0.99153871472970456},0.71576147134151091,0.68713101248785047,{"$f":"+M73*(M85/100)*(M73^M86)","v":0.99153871472970456},{"$f":"+N73*(N85/100)*(N73^N86)","v":0.71576147134151091},{"$f":"+O73*(O85/100)*(O73^O86)","v":0.68713101248785047},0.71576147134151091,0.71576147134151091,0.71576147134151091,0.5,0.6,0.4]
[null,null,null,null,"C7","W",null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"C8","W",null,null,null,45,45,45,45,45,45,45,45,45]
[null,null,null,null,"n","-",null,null,null,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48]
["power consumption of auxiliary devices at full load;",null,null,null,"Paux,gnr,Pn ","kW",{"$f":"INDEX(J91:U91,1,$C$36)","v":0.32116271006242814},null,null,{"$f":"(+J88+J89*J73^J90)/1000","v":0.32116271006242814},0.32116271006242814,0.32116271006242814,{"$f":"(+M88+M89*M73^M90)/1000","v":0.32116271006242814},{"$f":"(+N88+N89*N73^N90)/1000","v":0.32116271006242814},{"$f":"(+O88+O89*O73^O90)/1000","v":0.32116271006242814},0.32116271006242814,0.32116271006242814,0.32116271006242814,0.3,0.4,0.6]
[null,null,null,null,"C7","W",null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"C8","W",null,null,null,15,15,15,15,15,15,15,15,15]
[null,null,null,null,"n","-",null,null,null,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48]
["power consumption of auxiliary devices at intermediate load;",null,null,null,"Paux,gnr,Pint ","kW",{"$f":"INDEX(J95:U95,1,$C$36)","v":6.0065080230017151E-2},null,null,{"$f":"(+J92+J93*J81^J94)/1000","v":6.0065080230017151E-2},6.0065080230017151E-2,6.0065080230017151E-2,{"$f":"(+M92+M93*M81^M94)/1000","v":6.0065080230017151E-2},{"$f":"(+N92+N93*N81^N94)/1000","v":6.0065080230017151E-2},{"$f":"(+O92+O93*O81^O94)/1000","v":6.0065080230017151E-2},6.0065080230017151E-2,6.0065080230017151E-2,6.0065080230017151E-2,0.1,7.0000000000000007E-2,0.05]
[null,null,null,null,"C7","W",null,null,null,15,15,15,15,15,15,15,15,15]
[null,null,null,null,"C8","W",null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"n","-",null,null,null,0,0,0,0,0,0,0,0,0]
["stand-by power consumption of auxiliary devices;",null,null,null,"Paux,gnr,P0 ","kW",{"$f":"INDEX(J99:U99,1,$C$36)","v":1.4999999999999999E-2},null,null,{"$f":"(+J96+J97*J85^J98)/1000","v":1.4999999999999999E-2},1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,0,0,0]
["auxiliary power when the generation system is inactive",null,null,null,"Paux,off","kW",{"$f":"INDEX(J100:U100,1,$C$36)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0]
["minimum operating boiler temperature.",null,null,null,"θgnr,min","°C",{"$f":"INDEX(J101:U101,1,$C$36)","v":30},null,null,50,30,0,50,30,0,50,50,50,50,50,50]
["Recoverable fraction of stand-by losses",null,null,null,"fgnr,env","-",{"$f":"INDEX(J102:U102,1,$C$36)","v":0.5},null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[]
["correction factor of full-load efficiency;",null,null,null,"fcorr,Pn ","-",{"$f":"INDEX(J104:U104,1,$C$36)","v":0.04},null,null,0.04,0.04,0.2,0.04,0.04,0.2,0.04,0.04,0.1,0.04,0.04,0.04]
["correction factor of intermediate load efficiency;",null,null,null,"fcorr,Pint ","-",{"$f":"INDEX(J105:U105,1,$C$36)","v":0.05},null,null,0.05,0.05,0.2,0.05,0.05,0.2,0.05,0.05,0.05,0.05,0.05,0.05]
[]
["generator average water temperature at test conditions for full load;",null,null,null,"θgnr,test,Pn","°C",{"$f":"INDEX(J107:U107,1,$C$36)","v":70},null,null,70,70,70,70,70,70,70,70,70,70,70,70]
["generator average water temperature at test conditions for intermediate load;",null,null,null,"θgnr,test,Pint","°C",{"$f":"INDEX(J108:U108,1,$C$36)","v":40},null,null,50,40,30,50,40,30,50,50,50,50,50,50]
["difference between mean boiler temperature and test room temperature in test conditions;",null,null,null,"Dθtest,P0 ","°C",{"$f":"INDEX(J109:U109,1,$C$36)","v":50},null,null,50,50,50,50,50,50,50,50,50,50,50,50]
[]
["part of the auxiliary energy recovered",null,null,null,"frvd,aux ","-",{"$f":"INDEX(J111:U111,1,$C$36)","v":0.75},null,null,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
["part of the nominal electrical power not transmitted to the distribution sub-system",null,null,null,"frbl,aux ","-",{"$f":"INDEX(J112:U112,1,$C$36)","v":0.25},null,null,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[]
[]
[]
[]
["System design data"]
["Installation room temperature;",null,null,null,"qi,brm ","°C",15]
["Temperature reduction factor of install. room",null,null,null,"bbrm","-",0.7]

{"sheet":"Simplified_input_correlation","index":13,"n_rows":24,"n_cols":8,"rows_kept":24,"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",30,"4…100"]
["Width of the building","lW","m",20,"4…20"]
["Number of loors","Nlev","-",3,"1…10"]
["Floor heigth","Hfl","m",3.1,"2…5"]
[]
[]
["METHOD"]
[]
["Detail all formulas"]
["Length of connection of radiators to vertical shafts ","lA","m",{"$f":"0.55*Method_in*D7*D8","v":990}]
["Length of vertical shafts","lS","m",{"$f":"0.025*Method_in*D7*D8*D9","v":139.5}]
["Length of base collector","lV","m",{"$f":"2*Method_in+0.01625*Method_in*D7*D7","v":255}]
["…"]
[]
["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":"Method_input _2","index":14,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["All 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"]
["heat output to the heat distribution sub-system(s);","QH,gen,out ","kWh",28000,"0...∞","M3-6","YES"]
["calculation interval","tci ","h",744,"0…8760","M1-9","Yes"]
["total time of generator(s) operation","tgnr ","h",710,"0…8760","M1-6","Yes"]
["average water temperature in the boiler;","qgnr,w,m ","°C",70,"0…100","M3-6","YES"]
["return water temperature to the boiler (for condensing boilers);","qgnr,w,r ","°C",60,"0…100","M3-6","YES"]
["external temperature of the calculation interval","qext ","°C",4,"-50…+50","M1-13","YES"]
[]
[]
[]
["Product data"]
["Product description data "]
["Condensing boiler","BLR_COND",null,{"$f":"+Product_descriptive_data!C9","v":"LRH_TYPE_AIR_MODUALL"},"Y/N","Local","NO"]
["Fuel","BLR_FUEL",null,{"$f":"+Product_descriptive_data!C34","v":"LRH_FUEL_GAS"},"List","Local","NO"]
[]
["Product technical data "]
["generator output at full load;","ФPn ","kW",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0...∞","Local","NO"]
["generator efficiency at full load;","ηgnr,Pn ","%",{"$f":"+Product_tech_data!D86","v":99},"0…120%","Local","NO"]
["generator output at intermediate load;","ФPint ","kW",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0...∞","Local","NO"]
["generator efficiency at intermediate load;","ηgnr,Pint ","%",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…120%","Local","NO"]
["stand-by heat loss at test temperature difference Dθi,test;","Фgnr,ls,P0","kW",{"$f":"+Data_catalogue_example!G87","v":0.71576147134151091},"0...∞","Local","NO"]
["power consumption of auxiliary devices at full load;","Paux,gnr,Pn ","kW",{"$f":"+Product_tech_data!#REF!/1000","v":{"$error":"#REF!"}},"0...∞","Local","NO"]
["power consumption of auxiliary devices at intermediate load;","Paux,gnr,Pint ","kW",{"$f":"+Product_tech_data!#REF!/1000","v":{"$error":"#REF!"}},"0...∞","Local","NO"]
["stand-by power consumption of auxiliary devices;","Paux,gnr,P0 ","kW",{"$f":"+Product_tech_data!#REF!/1000","v":{"$error":"#REF!"}},"0...∞","Local","NO"]
["auxiliary power when the generation system is inactive","Paux,off","kW",{"$f":"+Data_catalogue_example!G100","v":0},"0...∞","Local","NO"]
["minimum operating boiler temperature.","θgnr,min","°C",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…100","Local","NO"]
["Recoverable fraction of stand-by losses","fgnr,env","-",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…1","Local","NO"]
[null,null,null,null,null,"Local"]
["correction factor of full-load efficiency;","fcorr,Pn ","-",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…1","Local","NO"]
["correction factor of intermediate load efficiency;","fcorr,Pint ","-",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…1","Local","NO"]
[]
["generator average water temperature at test conditions for full load;","θgnr,test,Pn","°C",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…100","Local","NO"]
["generator average water temperature at test conditions for intermediate load;","θgnr,test,Pint","°C",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…100","Local","NO"]
["difference between mean boiler temperature and test room temperature in test conditions;","Dθtest,P0 ","°C",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…100","Local","NO"]
[null,null,null,null,null,"Local"]
["part of the auxiliary energy recovered","frvd,aux ","-",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0…1","Local","NO"]
["part of the nominal electrical power not transmitted to the distribution sub-system","frbl,aux ","-",{"$f":"+Product_tech_data!#REF!","v":{"$error":"#REF!"}},"0….1","Local","NO"]
[]
["System design data"]
["Process design"]
["boiler room temperature;","qi,brm ","°C",{"$f":"+Process_design_data!#REF!","v":{"$error":"#REF!"}},"-50…+50","Local","Yes"]
["Temperature reduction factor of boiler room","bbrm","-",{"$f":"+Process_design_data!#REF!","v":{"$error":"#REF!"}},"0…1","Local","NO"]
[]
[]
["Control type data"]
["Burner control type"]