{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["INFO","Product_tech_data","Process_design_data","Calculation_options","Input_series","Method_input","Scheme","Method_calculation","Method_output","Other modules","Output_series","History","Control_Options","Product_descriptive_data","Data_catalogue_example","Simplified_input_correlation","Method_input _2"],"not_rendered":{"charts":0,"images":95,"macros":1,"external_links":0,"defined_names":16,"comments":11,"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":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["DISCLAIMER:\nThis spreadsheet has been developed in the framework of the revision of the standards linked to the \"Energy Performance of Buildings Directive\" recast (EPBD-recast, directive 2010/31/EU). It is meant for technical committee(s) and the working group(s) concerned by the revision of the standard to which this spreadsheet applies to check that all equations in the revised standard are consistent and can be linked with other relevant standards. It is not meant to perform a full or partial energy performance calculation."]
["Although it has been developed with care, neither the technical committee(s) not the working group(s) in which the standard to which this spreadsheet applies warrant that the calculations and procedures in this spreadsheet are free of errors. The technical committees s well as the working groups and their respective members expressly disclaims any liability or responsibility arising from use of this spreadsheet, or any consequences thereof. Any responsibility arising from the use of this spreadsheet lies with the user."]
["WARNING:\nNote that the spreadsheet does not allow to test all calculation options that are possible according to the standard to which it applies. This remark applies in particular but not only to limitations on the number instances of a variable that can be considered. In case of differences, the standard should be regarded as the reference, not the spreadsheet.\n"]
["TERMS OF USE\nThis file can be used freely only as a tool to help understand the supported EN standard. \nAny other application is deemed to be an unintended and unapproprite use of this file."]
["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."]
["Other_systems\nThis sheet includes simple simulation of connected systems to test data links with subsystem modules."]

{"sheet":"Product_tech_data","index":1,"n_rows":113,"n_cols":4,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Create 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)"]
[]
[]
[]
["Product technical data: HEAT EMITTERS"]
[null,"Emitters nominal Δϑ air","Emitters exponent n","Emitters nominal Δϑ water"]
["Radiator",50,1.3,20]
["Floor heating",15,1.1000000000000001,5]
["Fan-coil",25,1,10]
["Special option 1",30,1.2,10]
["Last option",50,1.3,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Clause","Symbol","Unit","Value"]
["Clause","Фlrh,comb,Pn ","kW",{"$f":"42*3","v":126}]
["Clause","Фlrh,comb,Pmin ","kW",{"$f":"+D42*0.5","v":63}]
[]
[]
[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":2,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["These selection described the type of hydraulic connection of emiters and generators"]
[]
[]
["Emission and control circuit"]
[null,"EM_CIRCUIT_TYPE"]
["Description","Specifier, parts","Specifier, complete"]
["Type 1 - Constant flow","CONST_FLW",{"$f":"$B$6&\"_\"&B8","v":"EM_CIRCUIT_TYPE_CONST_FLW"}]
["Type 2 - Variable flow","VAR_FLW",{"$f":"$B$6&\"_\"&B9","v":"EM_CIRCUIT_TYPE_VAR_FLW"}]
["Type 3 - ON-OFF","ON_OFF","EM_CIRCUIT_TYPE_ON_OFF"]
["Type 4 - By bass","BY_PASS","EM_CIRCUIT_TYPE_BY_PASS"]
[]
[]
["Generator circuit"]
[null,"GEN_CIRCUIT_TYPE"]
["Description","Specifier, parts","Specifier, complete"]
["Type 1 - Direct connection","DIRECT",{"$f":"$B$15&\"_\"&B17","v":"GEN_CIRCUIT_TYPE_DIRECT"}]
["Type 2 - Independent flow","INDEP",{"$f":"$B$15&\"_\"&B18","v":"GEN_CIRCUIT_TYPE_INDEP"}]
["Type 3 - Heat exchanger","EXCH","GEN_CIRCUIT_TYPE_EXCH"]
["Type 4 - Anti-condensate","NOCOND","GEN_CIRCUIT_TYPE_NOCOND"]

{"sheet":"Calculation_options","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Calculation options"]
[]
["Simplified heat recovery dhw"]
[1,"OPT_HEAT_REC",{"$f":"INDEX(C7:C8,A5)","v":"OPT_HEAT_REC_SIMPLE"}]
["Description","Specifier, parts","Specifier, complete"]
["Simplified heat recovery","SIMPLE",{"$f":"$B$5&\"_\"&B7","v":"OPT_HEAT_REC_SIMPLE"}]
["Explicit heat recovery","DETAIL",{"$f":"$B$5&\"_\"&B8","v":"OPT_HEAT_REC_DETAIL"}]

{"sheet":"Input_series","index":4,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["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,21]
["Number of time steps",null,12,null,null,null,null,null,null,null,null,null,null,null,"NOT USED IN THIS EXAMPLE"]
[]
["Description","Dhw needs, TZ1","Dhw needs, TZ2","Dhw needs, TZ3","Calculation interval","Heating system on time","Dhw system on time","cold water temperature","Heating needs, TZ1","Heating needs, TZ2","Heating needs, TZ3","heat energy required by the AHU ","operation time of coil circuit","required flow temperature ","average temperature  of the air in the coil","Heat energy required by the cooling generator","required flow temperature","required return temperature","Internal temperature of thermal zone TZ1","Internal temperature of thermal zone TZ2","Internal temperature of thermal zone TZ3","External air temperature"]
["Symbol","QW;nd;wzn,1 ","QW;nd;wzn,2","QW;nd;wzn,3","tci","tH;on","tW;on","ϑW;cold","QH;nd;tz,1","QH;nd;tz,2","QH;nd;tz,3","QHV;gen;in;req ","tV","ϑV;gen;flw ","ϑV;gen;air ","QC;gen;in;req ","ϑC;gen;in;flw ","ϑC;gen;in;ret ","ϑint;tz,1","ϑint;tz,2","ϑint;tz,3","ϑext"]
["Unit","kWh","kWh","kWh","h","h","h","kWh","kWh","kWh"]
["Origin"]
[]
["Time stamp",null,null,"VALUES"]
[1,248,186,300,744,{"$f":"+E14","v":744},{"$f":"+E14","v":744},10,1800,1600,2200,0,0,0,0,0,0,0,20,20,20,2]
[2,224,168,270,672,{"$f":"+E15","v":672},{"$f":"+E15","v":672},10,1400,1200,1800,0,0,0,0,0,0,0,20,20,20,4]
[3,248,186,300,744,744,744,11,800,600,900,0,0,0,0,0,0,0,20,20,20,7]
[4,240,180,290,720,720,720,11,500,300,400,0,0,0,0,0,0,0,20,20,20,12]
[5,248,186,300,744,0,744,12,0,0,0,0,0,0,0,0,0,0,20,20,20,17]
[6,240,180,290,720,0,720,13,0,0,0,0,0,0,0,0,0,0,22,22,22,22]
[7,248,186,300,744,0,744,12,0,0,0,0,0,0,0,0,0,0,24,24,24,26]
[8,248,186,300,744,0,744,12,0,0,0,0,0,0,0,0,0,0,22,22,22,24]
[9,240,180,290,720,0,720,11,0,0,0,0,0,0,0,0,0,0,20,20,20,19]
[10,248,186,300,744,744,744,11,600,700,1000,0,0,0,0,0,0,0,20,20,20,14]
[11,240,180,290,720,720,720,10,1100,1200,1400,0,0,0,0,0,0,0,20,20,20,8]
[12,248,186,300,744,744,744,10,1500,1400,1800,0,0,0,0,0,0,0,20,20,20,3]

{"sheet":"Method_input","index":5,"n_rows":279,"n_cols":10,"rows_kept":279,"cut":false,"hidden":false,"merged":[[0,0,0,8],[188,0,191,0],[188,1,191,1]]}
["THIS IS A MANDATORY SHEET\nAll input data for the method shall be listed here.\n"]
[null,"ϑ"]
[]
["Name","Symbol","Software name","Unit","Value","Range","Origin","Varying","Notes"]
["Operating conditions data"]
["Dhw needs, TZ1","QW;nd;wzn,1 ","Q_W_nd_wzn_1","kWh",248,"0...∞","M8-1","YES","From 12831-3. Only kWh"]
["Dhw needs, TZ2","QW;nd;wzn,2","Q_W_nd_wzn_2","kWh",186,"0...∞",null,"YES","From 12831-3. Only kWh"]
["Dhw needs, TZ3","QW;nd;wzn,3","Q_W_nd_wzn_3","kWh",300,"0...∞",null,"YES","From 12831-3. Only kWh"]
["Calculation interval","tci","t_ci","h",744,"0…8760",null,"YES","From 52000-1 (?)"]
["Heating system on time","tH;on",null,"h",744,"0…8760",null,"YES","Local"]
["Dhw system on time","tW;on",null,"h",744,"0…8760",null,"YES","Local"]
["cold water temperature","ϑW;cold",null,"°C",10,"0…100",null,"YES","prEN 12831-3 already has a spec about it"]
["Heating needs, TZ1","QH;nd;tz,1",null,"kWh",1500,"0...∞"]
["Heating needs, TZ2","QH;nd;tz,2",null,"kWh",1400,"0...∞"]
["Heating needs, TZ3","QH;nd;tz,3",null,"kWh",1800,"0...∞"]
["heat energy required by the AHU ","QHV;gen;in;req ",null,"kWh",0,null,null,null,"Not used in trhis example"]
["operation time of coil circuit","tV",null,"h",0,null,null,null,"Not used in trhis example"]
["required flow temperature ","ϑV;gen;flw ",null,"°C",0,null,null,null,"Not used in trhis example"]
["average temperature  of the air in the coil","ϑV;gen;air ",null,"°C",0,null,null,null,"Not used in trhis example"]
["Heat energy required by the cooling generator","QC;gen;in;req ",null,"kWh",0,null,null,null,"Not used in trhis example"]
["required flow temperature","ϑC;gen;in;flw ",null,"°C",0,null,null,null,"Not used in trhis example"]
["required return temperature","ϑC;gen;in;ret ",null,"°C",0,null,null,null,"Not used in trhis example"]
["Internal temperature of thermal zone TZ1","ϑint;tz,1",null,"°C",20]
["Internal temperature of thermal zone TZ2","ϑint;tz,2",null,"°C",20]
["Internal temperature of thermal zone TZ3","ϑint;tz,3",null,"°C",20]
["External air temperature","ϑext",null,"°C",17]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dhw final distribution input","QW;dfin,i;in",null,"kWh",{"$f":"+'Other modules'!I16","v":291.15199999999999}]
[null,null,null,null,{"$f":"+'Other modules'!K16","v":518.36400000000003}]
["Dhw final distribution aux","QW;dfin,i;aux",null,"kWh",{"$f":"+'Other modules'!I17","v":0}]
[null,null,null,null,{"$f":"+'Other modules'!K17","v":0}]
["Dhw final distribution recoverable","QW;dfin.i;ls;rbl;H",null,"kWh",{"$f":"+'Other modules'!I18","v":43.152000000000001}]
[null,null,null,null,{"$f":"+'Other modules'!K18","v":16.181999999999999}]
["Dhw final distribution where recoverable","TZW;dfin,i;ls;rbl",null,"-",{"$f":"+'Other modules'!I19","v":"TZ3"}]
[null,null,null,null,{"$f":"+'Other modules'!K19","v":"TZ1"}]
[]
["Dhw circulation loop input","QW;dloop,i;in",null,"kWh",{"$f":"+'Other modules'!K32","v":563.00400000000002}]
["Dhw circulation loop aux","QW;dloop,i;aux",null,"kWh",{"$f":"+'Other modules'!K33","v":37.200000000000003}]
["Dhw circulation loop recoverable losses","QW;dloop,i;ls;rbl;H",null,"kWh",{"$f":"+'Other modules'!K34","v":14.88}]
["Dhw circulation loop where recoverable","TZW;dloop,i;ls;rbl;H",null,"-",{"$f":"+'Other modules'!K35","v":"Any"}]
[]
["Dhw storage input","QW;sto,i;in",null,"kWh",{"$f":"+'Other modules'!J46","v":898.79599999999994}]
["Dhw storage aux","QW;sto,i;aux",null,"kWh",{"$f":"+'Other modules'!J47","v":0}]
["Dhw storage recoverable losses","QW;sto,i;ls;rbl;H",null,"kWh",{"$f":"+'Other modules'!J48","v":22.32}]
["Dhw storage where recoverable","TZsto,i;ls;rbl,hz",null,"-",{"$f":"+'Other modules'!J49","v":"TZ2"}]
[]
["Heating emission and control input","QH;em,i;in",null,"kWh",{"$f":"+'Other modules'!E62","v":1648.1058245614036}]
[null,null,null,null,{"$f":"+'Other modules'!F62","v":1531.8867836257309}]
[null,null,null,null,{"$f":"+'Other modules'!G62","v":1296.5020636415425}]
[null,null,null,null,{"$f":"+'Other modules'!H62","v":617.81735180055398}]
["Heating emission and control  aux","QH;em,i;aux",null,"kWh",{"$f":"+'Other modules'!E63","v":0}]
[null,null,null,null,{"$f":"+'Other modules'!F63","v":0}]
[null,null,null,null,{"$f":"+'Other modules'!G63","v":7.7790123818492543}]
[null,null,null,null,{"$f":"+'Other modules'!H63","v":0}]
["Heating emission and control  recoverable losses","QH;em,i;rbl",null,null,{"$f":"+'Other modules'!E64","v":0}]
[null,null,null,null,{"$f":"+'Other modules'!F64","v":0}]
[null,null,null,null,{"$f":"+'Other modules'!G64","v":0}]
[null,null,null,null,{"$f":"+'Other modules'!H64","v":0}]
["Heating emission and control, where recoverable","TZH;em,i;ls;rbl",null,null,{"$f":"+'Other modules'!E65","v":"TZ1"}]
[null,null,null,null,{"$f":"+'Other modules'!F65","v":"TZ2"}]
[null,null,null,null,{"$f":"+'Other modules'!G65","v":"TZ3"}]
[null,null,null,null,{"$f":"+'Other modules'!H65","v":"TZ3"}]
[]
["Distribution 1, 2, 3 and 4"]
["Distribution input","QH;dis,i;ls",null,null,{"$f":"+'Other modules'!E78","v":1886.5299724354209}]
[null,null,null,null,{"$f":"+'Other modules'!F78","v":1648.7936085038668}]
[null,null,null,null,{"$f":"+'Other modules'!G78","v":1317.8309223607782}]
[null,null,null,null,{"$f":"+'Other modules'!H78","v":941.81459556376774}]
["Distribution auxiliary","QH;dis,i;aux",null,null,{"$f":"+'Other modules'!$E$79","v":17.856000000000002}]
[null,null,null,null,{"$f":"+'Other modules'!$F$79","v":5.952}]
[null,null,null,null,{"$f":"+'Other modules'!$G$79","v":5.952}]
[null,null,null,null,{"$f":"+'Other modules'!$H$79","v":17.856000000000002}]
["Distribution recoverable losses","QH;dis,i;rbl",null,null,{"$f":"+'Other modules'!$E$80","v":178.98551090551283}]
[null,null,null,null,{"$f":"+'Other modules'!$F$80","v":58.490612439067952}]
[null,null,null,null,{"$f":"+'Other modules'!$G$80","v":8.5613034876943104}]
[null,null,null,null,{"$f":"+'Other modules'!$H$80","v":97.266133128964157}]
["Distribution losses where recoverable","TZH;dis,i;ls;rbl",null,null,{"$f":"+'Other modules'!$E$81","v":"TZ1"}]
[null,null,null,null,{"$f":"+'Other modules'!$F$81","v":"TZ2"}]
[null,null,null,null,{"$f":"+'Other modules'!$G$81","v":"TZ3"}]
[null,null,null,null,{"$f":"+'Other modules'!$H$81","v":"TZ3"}]
["Distribution 123"]
["Distribution input","QH;dis,i;in",null,null,{"$f":"+'Other modules'!F95","v":5064.1709086033661}]
["Distribution auxiliary","QH;dis,i;aux",null,null,{"$f":"+'Other modules'!F96","v":29.76}]
["Distribution recoverable losses","QH;dis,i;rbl",null,null,{"$f":"+'Other modules'!F97","v":0}]
["Distribution losses where recoverable","TZH;dis,i;ls;rbl",null,null,{"$f":"+'Other modules'!F98","v":"None"}]
["Thermal solar"]
["Supplied heat","QW;sol;out",null,"kWh",{"$f":"+'Other modules'!J107","v":617.92224999999996}]
["Auxiliary energy","QW;sol;aux",null,"kWh",{"$f":"+'Other modules'!J108","v":30.896112500000001}]
["Thermal solar  recoverable losses","QW;sol;i;ls;rbl;H",null,"kWh",{"$f":"+'Other modules'!J109","v":0}]
["Thermal solar losses where recoverable","TZsol,i;ls;rbl,hz",null,"-",{"$f":"+'Other modules'!J110","v":"None"}]
["Generators, step 1"]
["Maximum heat supplied","QH;gen;out;max",null,"kWh",{"$f":"+'Other modules'!G117","v":4761.6000000000004}]
[null,null,null,"kWh",{"$f":"+'Other modules'!H117","v":8928}]
["Generators, step 2"]
["Fuel input",null,null,"kWh",{"$f":"+'Other modules'!G128","v":5012.21052631579}]
[null,null,null,null,{"$f":"+'Other modules'!H128","v":1731.9042503237531}]
["Auxiliary energy",null,null,"kWh",{"$f":"+'Other modules'!G129","v":150.3663157894737}]
[null,null,null,null,{"$f":"+'Other modules'!H129","v":69.276170012950118}]
["Generation recoverable losses","QW;gen,i;ls;rbl;H",null,"kWh",{"$f":"+'Other modules'!G130","v":100.24421052631587}]
[null,null,null,null,{"$f":"+'Other modules'!H130","v":61.993498846986057}]
["Generation where recoverable","TZgen,i;ls;rbl,hz",null,null,{"$f":"+'Other modules'!G131","v":"TZ3"}]
[null,null,null,null,{"$f":"+'Other modules'!H131","v":"None"}]
[]
[]
["Product data"]
["Product description data "]
[null,null,null,null,null,null,null,null,"No product descritpion data"]
[]
["Product technical data "]
[]
["nominal power of the coil","ϕV;Hcoil,nom  ",null,"kW",null,null,null,"NO","From TC 156"]
["nominal temperature difference ","ΔϑV;Hcoil;nom ",null,"°C",null,null,null,"NO","From TC 157"]
[]
["Emitters nominal power, HZ1","ϕH;em;nom  ",null,"kW",5,null,null,null,"To be connected to deafult evaluation"]
["Emitters nominal power, HZ2","ϕH;em;nom  ",null,"kW",10]
["Emitters nominal power, HZ3","ϕH;em;nom  ",null,"kW",5]
["Emitters nominal power, HZ4","ϕH;em;nom  ",null,"kW",10]
[]
[]
[]
[]
[]
["System design data"]
["Process design"]
["Heating system zone 1 floor area","Ahz;1",null,"m² ",120,null,null,"NO"]
["Heating system zone 2 floor area","Ahz;2",null,"m² ",110,null,null,"NO"]
["Heating system zone 3 floor area","Ahz;3",null,"m² ",70,null,null,"NO"]
["Heating system zone 4 floor area","Ahz;4",null,"m² ",80,null,null,"NO"]
[]
["Auxiliary energy recovery factor, W, dloop","fW;dloop;aux;rh",null,null,0.85]
[]
["Auxiliary energy recovery factor, W, sto","fW;sto;aux;rh",null,null,0.85]
[]
["Recoverable losses recovery factor","frh",null,null,0.8]
[]
["Auxiliary energy recovery factor, H, em","fH;em;aux;rh",null,null,0.85]
[]
["Auxiliary energy recovery factor, H, dis","fH;dis;aux;rh",null,null,0.85]
["Recoverable losses recovery factor H;dis","fH;dis;rbl;rh",null,null,0.8]
[]
[]
["Heat emitters type data"]
["Emitter type, HZ1",null,null,null,1]
["Emitter type, HZ2",null,null,null,1]
["Emitter type, HZ3",null,null,null,2]
["Emitter type, HZ4",null,null,null,3]
[]
[]
["Emitters nominal Δϑ HZ1","ΔθH;em;air;n",null,"°C",{"$f":"INDEX(Product_tech_data!$B$7:$B$11,E153)","v":50}]
["Emitters nominal Δϑ HZ2","ΔθH;em;air;n",null,"°C",{"$f":"INDEX(Product_tech_data!$B$7:$B$11,E154)","v":50}]
["Emitters nominal Δϑ HZ3","ΔθH;em;air;n",null,"°C",{"$f":"INDEX(Product_tech_data!$B$7:$B$11,E155)","v":15}]
["Emitters nominal Δϑ HZ4","ΔθH;em;air;n",null,"°C",{"$f":"INDEX(Product_tech_data!$B$7:$B$11,E156)","v":25}]
[]
["Emitters exponent n HZ1","nH;em",null,"-",{"$f":"INDEX(Product_tech_data!$C$7:$C$11,E153)","v":1.3}]
["Emitters exponent n HZ2","nH;em",null,"-",{"$f":"INDEX(Product_tech_data!$C$7:$C$11,E154)","v":1.3}]
["Emitters exponent n HZ3","nH;em",null,"-",{"$f":"INDEX(Product_tech_data!$C$7:$C$11,E155)","v":1.1000000000000001}]
["Emitters exponent n HZ4","nH;em",null,"-",{"$f":"INDEX(Product_tech_data!$C$7:$C$11,E156)","v":1}]
[]
["Emission circuit type data"]
["Circuit type HZ,1",null,null,2,{"$f":"INDEX(Process_design_data!$A$8:$A$11,Method_input!D170)","v":"Type 2 - Variable flow"}]
["Circuit type HZ,2",null,null,3,{"$f":"INDEX(Process_design_data!$A$8:$A$11,Method_input!D171)","v":"Type 3 - ON-OFF"}]
["Circuit type HZ,3",null,null,1,{"$f":"INDEX(Process_design_data!$A$8:$A$11,Method_input!D172)","v":"Type 1 - Constant flow"}]
["Circuit type HZ,4",null,null,4,{"$f":"INDEX(Process_design_data!$A$8:$A$11,Method_input!D173)","v":"Type 4 - By bass"}]
[]
["Generation circuit type data"]
["Circuit type, GEN 1",null,null,1,{"$f":"INDEX(Process_design_data!$C$17:$C$20,Method_input!D176)","v":"GEN_CIRCUIT_TYPE_DIRECT"}]
["Circuit type, GEN 2",null,null,2,{"$f":"INDEX(Process_design_data!$C$17:$C$20,Method_input!D177)","v":"GEN_CIRCUIT_TYPE_INDEP"}]
[]
["Energy carrier",null,null,null,"FUEL_GAS"]
[]
["Control type data"]
["circulation loop operation time ","tW;dloop;ON,ci",null,"h",{"$f":"+$E$11","v":744},null,null,"YES"]
["storage back-up heater operation time ","tW;sto;bup;ON,ci",null,"h",{"$f":"+$E$11","v":744},null,null,"YES"]
["domestic hot water generator operation time ","tW;gen;ON,ci ",null,"h",744,null,null,"YES"]
["Dhw set temperature in the storage","ϑW;sto",null,"°C",60,null,null,"YES","Missing definition in the standard"]
["Dhw set temperature in the circulation loop","ϑW;dloop",null,"°C",50,null,null,"YES","Missing definition in the standard"]
["Dhw temperature for the expression of needs","ϑW;hot",null,"°C",40,null,null,"NO","Missing definition in the standard"]
["Dhw set temperature in the generator","ϑW;gen",null,"°C",60,null,null,"YES","Missing definition in the standard"]
["Heating emission  system operation time","tH;cr,i;ON",null,"h",{"$f":"+$E$10","v":744}]
[null,null,null,"h",{"$f":"+$E$10","v":744}]
[null,null,null,"h",744]
[null,null,null,"h",744]
[]
["Set full load DT (water) HZ1","ΔθH;em;n",null,"°C",{"$f":"INDEX(Product_tech_data!$D$7:$D$11,Method_input!E153)","v":20}]
["Set full load DT (water) HZ2","ΔθH;em;n",null,"°C",{"$f":"INDEX(Product_tech_data!$D$7:$D$11,Method_input!E154)","v":20}]
["Set full load DT (water) HZ3","ΔθH;em;n",null,"°C",{"$f":"INDEX(Product_tech_data!$D$7:$D$11,Method_input!E155)","v":5}]
["Set full load DT (water) HZ4","ΔθH;em;n",null,"°C",{"$f":"INDEX(Product_tech_data!$D$7:$D$11,Method_input!E156)","v":10}]
[]
["Max flow temperature HZ1","θH;em;flw;max,i",null,"°C",80]
["Max flow temperature HZ2","θH;em;flw;max,i",null,"°C",80]
["Max flow temperature HZ3","θH;em;flw;max,i",null,"°C",80]
["Max flow temperature HZ4","θH;em;flw;max,i",null,"°C",80]
[]
["Max Δθ flow / return HZ1","ΔθH;em;w;max,i",null,"°C",20]
["Max Δθ flow / return HZ2","ΔθH;em;w;max,i",null,"°C",20]
["Max Δθ flow / return HZ3","ΔθH;em;w;max,i",null,"°C",20]
["Max Δθ flow / return HZ4","ΔθH;em;w;max,i",null,"°C",20]
[]
["Desired return temperature HZ1","θH;em;ret;req",null,"°C",20]
["Desired return temperature HZ2","θH;em;ret;req",null,null,20]
["Desired return temperature HZ3","θH;em;ret;req",null,null,20]
["Desired return temperature HZ4","θH;em;ret;req",null,null,20]
[]
["Mixing valve for HZ1","MIX",null,null,0]
["Mixing valve for HZ2",null,null,null,0]
["Mixing valve for HZ3",null,null,null,1]
["Mixing valve for HZ4",null,null,null,0]
[]
["Mixing valve Δθ for HZ1","ΔθH;em;mix",null,"°C",2]
["Mixing valve Δθ for HZ2","ΔθH;em;mix",null,null,2]
["Mixing valve Δθ for HZ3","ΔθH;em;mix",null,null,2]
["Mixing valve Δθ for HZ4","ΔθH;em;mix",null,null,2]
[]
["Desired load factor with ON-OFF for HZ1","βH;em;req",null,"%",80]
["Desired load factor with ON-OFF for HZ2","βH;em;req",null,"%",80]
["Desired load factor with ON-OFF for HZ3","βH;em;req",null,"%",80]
["Desired load factor with ON-OFF for HZ4","βH;em;req",null,"%",80]
[]
["Minimum flow temperature for HZ1","θH;em;flw;min",null,"°C",50]
["Minimum flow temperature for HZ2","θH;em;flw;min",null,null,45]
["Minimum flow temperature for HZ3","θH;em;flw;min",null,null,50]
["Minimum flow temperature for HZ4","θH;em;flw;min",null,null,45]
[]
["Generator 1 nominal power","ϕX;gen;n  ",null,null,8]
["Generator 2 nominal power","ϕX;gen;n  ",null,null,15]
["Generator 1 nominal Δθ","ΔθX;gen;n",null,null,10]
["Generator 1 nominal Δθ","ΔθX;gen;n",null,null,10]
["Generator 1: flow control",null,null,null,0]
["Generator 1: flow control",null,null,null,0]
[]
[]
["Calculation options"]
["Simplified heat recovery from dhw ?",null,null,null,{"$f":"+Calculation_options!C5","v":"OPT_HEAT_REC_SIMPLE"}]
[]
["Constants"]
["Water specific heat","cw","c_w","Wh/kgK",1.1599999999999999,null,"EN XXXX","NO"]
[]
[]
[]
[]
[]
[]
[]
["Spare lines for local air heaters"]
[]
["Local air heaters, heat output to air","QH;gen,i;out",null,"kWh",{"$f":"+'Other modules'!$E$160","v":1},null,null,null,null,"HZ1"]
[null,null,null,"kWh",{"$f":"+'Other modules'!$F$160","v":2},null,null,null,null,"HZ2"]
[null,null,null,"kWh",{"$f":"+'Other modules'!$G$160","v":3},null,null,null,null,"HZ3"]
[null,null,null,"kWh",{"$f":"+'Other modules'!$H$160","v":0},null,null,null,null,"HZ4"]
["Supplied heat to water","QH;gen,i;out;w",null,"kWh",{"$f":"+'Other modules'!$E$161","v":0}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$F$161","v":0.42857142857142855}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$G$161","v":0}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$H$161","v":0}]
["Auxiliary input","WH;gen,i;aux",null,"kWh",{"$f":"+'Other modules'!$E$162","v":4.1571428571428565E-2}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$F$162","v":0}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$G$162","v":0.1875}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$H$162","v":0}]
["Fuel input","EH;gen,i,in",null,"kWh",{"$f":"+'Other modules'!$E$163","v":1.3857142857142857}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$F$163","v":2.8571428571428572}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$G$163","v":3.75}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$H$163","v":0}]
["Heater recoverable losses","QH;em,i;rbl",null,"kWh",{"$f":"+'Other modules'!$E$164","v":0}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$F$164","v":0}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$G$164","v":0.375}]
[null,null,null,"kWh",{"$f":"+'Other modules'!$H$164","v":0}]
["Heater losses where recoverable","TZH;em,i;ls;rbl",null,null,{"$f":"+'Other modules'!$E$165","v":"TZ1"}]
[null,null,null,null,{"$f":"+'Other modules'!$F$165","v":"TZ2"}]
[null,null,null,null,{"$f":"+'Other modules'!$G$165","v":"TZ3"}]
[null,null,null,null,{"$f":"+'Other modules'!$H$165","v":"TZ3"}]

{"sheet":"Scheme","index":6,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Thermal zones",null,null,null,"Thermal zones","Heating and dhw zones",null,"Circuits\nEm & ctrl\nFinal distribution","Node","Distribution","Node","Distribution","Node","Distribution","Generators"]
[null,"TZ1"]
[null,"TZ2",null,null,null,"TZ1","HZ 1",null,"CR1"]
[null,"TZ3"]
[null,"None"]
[null,"Any"]
[null,null,null,null,null,"TZ2","HZ 2",null,"CR2","Node",null,"CR123"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disg,1","G1"]
[]
[null,null,null,null,null,null,"HZ 3",null,"CR3"]
[]
[null,null,null,null,null,"TZ 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Node"]
[null,null,null,null,null,null,"HZ 4",null,"CR4",null,null,null,null,null,"Disg,2","G2"]
[]
[]
[]
[null,null,null,null,null,null,"WZ 1",null,"Dfin,1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Node"]
[null,null,null,null,null,null,null,null,null,null,null,"Storage"]
[null,null,null,null,null,null,"WZ 2",null,"Dfin,23",null,"Dloop,23"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TS",null,null,"TS"]
[]
[null,null,null,null,null,null,"WZ 3"]

{"sheet":"Method_calculation","index":7,"n_rows":389,"n_cols":22,"rows_kept":389,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,4,2,10],[2,16,2,19],[2,20,2,21]]}
["THIS IS A MANDATORY SHEET\nOne time step calculation shall be described here.\nFor each calculation step (= 1 row) data for the formula in column D shall be taken from the \"Method_input\" sheet or previous calculation steps.\nInclude in the column \"Formula ref\" its number in the standard text. The example is based on EN 15316-4-1:2008\nCopy and paste a copy of the equation into column \"Formula\"\nUse the column note for information on the calculation"]
[]
["Description","Symbol","Software name","Unit","Values",null,null,null,null,null,null,null,"Formula ref","Formula","Notes","Editing notes","Recoverable losses per thermal zone",null,null,null,"Auxiliary"]
[null,null,null,null,"HZ 1","HZ 2","HZ 3","HZ 4","WZ 1","WZ 2","WZ 3","HCW",null,null,null,null,{"$f":"+Scheme!B3","v":"TZ1"},{"$f":"+Scheme!B4","v":"TZ2"},{"$f":"+Scheme!B5","v":"TZ3"},{"$f":"+Scheme!B7","v":"Any"},"H","W"]
["This is the main calculation sheet"]
["Local input data are copied here for clarity and identified in the Notes column"]
["Ouput data to calculation modules is identified by a light green background. Data is copied into \"Method_output\" sheet and from here into \"Other_modules\" sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Data ouput to module MXX"]
["Input data from calculation modules is identified by a light blue background. Data is calculated in the \"Other_modules\" sheet, copied into \"Method_input\" sheet and from there into this sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Data input as module MXX results "]
["White background lines are calculations done into EN 15316-1"]
["A yellow background (on other colors) highlight attention points"]
["Rose background are comments"]
["Calculation interval","tci","t_ci","h",{"$f":"+Method_input!E9","v":744}]
["Heating system on time","tH;on",null,"h",{"$f":"+Method_input!E10","v":744}]
["Dhw system on time","tW;on",null,"h",{"$f":"+Method_input!E11","v":744}]
["6.4.1.1 Domestic hot water needs "]
["Domestic hot water needs","QW;nd;wzn,i ",null,"kWh",null,null,null,null,{"$f":"+Method_input!E6","v":248},{"$f":"+Method_input!E7","v":186},{"$f":"+Method_input!E8","v":300},null,null,null,"Input data from module M 8.2"]
["Number of taps ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Possible input for final distribution calculation"]
["6.4.1.2 Domestic hot water system required output",null,null,null,null,null,null,null,null,null,"WZS23"]
["Combination of  needs per dhw system zone","QW;nd;wzs,i ",null,"kWh",null,null,null,null,{"$f":"+I16","v":248},null,{"$f":"+J16+K16","v":486},null,"(1b)",null,"Also QW;sys;out;wzs,i "]
["6.4.2.1 Final distribution calculation"]
["Dhw final distribution output","QW;dfin,i;out",null,"kWh",null,null,null,null,{"$f":"+I19","v":248},null,{"$f":"+K19","v":486},null,null,null,"Data ouput to module M8.6"]
["Dhw final distribution temperature","ϑW;dfin,i",null,"°C",null,null,null,null,{"$f":"+Method_input!E185","v":60},null,{"$f":"+Method_input!E186","v":50},null,null,null,"Data ouput to module M8.6"]
["Tapping rate","ntap;dfin,i",null,"1/h",null,null,null,null,0.125,null,0.125,null,null,null,"Data ouput to module M8.6"]
["Dhw final distribution input","QW;dfin;i;in",null,"kWh",null,null,null,null,{"$f":"+Method_input!E38","v":291.15199999999999},null,{"$f":"+Method_input!E39","v":518.36400000000003},null,null,null,"Data input as module M8.6 results "]
["Dhw final distribution aux","WW;dfin;i;aux",null,"kWh",null,null,null,null,{"$f":"+Method_input!E40","v":0},null,{"$f":"+Method_input!E41","v":0},null,null,null,"Data input as module M8.6 results ","Possibly non-zero to handle ribbon heating",null,null,null,null,null,{"$f":"SUM(I25:K25)","v":0}]
["Dhw final distribution recoverable losses","QW;dfin;i;ls;rbl;hz,j",null,"kWh",null,null,null,null,{"$f":"+Method_input!E42","v":43.152000000000001},null,{"$f":"+Method_input!E43","v":16.181999999999999},null,null,null,"Data input as module M8.6 results "]
["Dhw final distribution where recoverable","TZW;dfin;i;ls;rbl;hz,j",null,null,null,null,null,null,{"$f":"+Method_input!E44","v":"TZ3"},null,{"$f":"+Method_input!E45","v":"TZ1"},null,null,null,"Data input as module M8.6 results ","This is given as an information from module M8,6 because the final distribution will be described there.",{"$f":"IF($E27=Q$4,$E26,0)+IF($F27=Q$4,$F26,0)+IF($G27=Q$4,$G26,0)+IF($H27=Q$4,$H26,0)+IF($I27=Q$4,$I26,0)+IF($J27=Q$4,$J26,0)+IF($K27=Q$4,$K26,0)","v":16.181999999999999},{"$f":"IF($E27=R$4,$E26,0)+IF($F27=R$4,$F26,0)+IF($G27=R$4,$G26,0)+IF($H27=R$4,$H26,0)+IF($I27=R$4,$I26,0)+IF($J27=R$4,$J26,0)+IF($K27=R$4,$K26,0)","v":0},{"$f":"IF($E27=S$4,$E26,0)+IF($F27=S$4,$F26,0)+IF($G27=S$4,$G26,0)+IF($H27=S$4,$H26,0)+IF($I27=S$4,$I26,0)+IF($J27=S$4,$J26,0)+IF($K27=S$4,$K26,0)","v":43.152000000000001},{"$f":"IF($E27=T$4,$E26,0)+IF($F27=T$4,$F26,0)+IF($G27=T$4,$G26,0)+IF($H27=T$4,$H26,0)+IF($I27=T$4,$I26,0)+IF($J27=T$4,$J26,0)+IF($K27=T$4,$K26,0)","v":0}]
["Dhw final distribution input","QW;dfin,i;in",null,"kWh",null,null,null,null,{"$f":"+I24","v":291.15199999999999},null,{"$f":"+K24","v":518.36400000000003}]
[]
["6.4.2.2 Domestic hot water circulation loop"]
["Dhw circulation loop output","QW;dloop;i;out",null,"kWh",null,null,null,null,null,null,{"$f":"+K28","v":518.36400000000003},null,"(3)",null,"Combine connected dfin\nTrivial because one "]
["Dhw circulation loop output","QW;dloop;i;in",null,"kWh",null,null,null,null,null,null,{"$f":"+K31","v":518.36400000000003},null,"(3)",null,"Data ouput to module M8.6"]
["Circulation loop temperature","ϑW;dloop,j",null,"°C",null,null,null,null,null,null,{"$f":"+Method_input!E186","v":50},null,null,null,"Data ouput to module M8.6"]
["Circulation loop temperature difference","ΔϑW;dloop,j",null,"°C",null,null,null,null,null,null,2,null,null,null,"Data ouput to module M8.6"]
["Circulation loop operation time","tdloop;ON",null,"h",null,null,null,null,null,null,{"$f":"+Method_input!E182","v":744},null,null,null,"Data ouput to module M8.6"]
["Dhw circulation loop input","QW;dloop;i;ls",null,"kWh",null,null,null,null,null,null,{"$f":"+Method_input!E47","v":563.00400000000002},null,null,null,"Data input as module M8.6 results "]
["Dhw circulation loop aux","QW;dloop;i;aux",null,"kWh",null,null,null,null,null,null,{"$f":"+Method_input!E48","v":37.200000000000003},null,null,null,"Data input as module M8.6 results ",null,null,null,null,null,null,{"$f":"SUM(I37:K37)","v":37.200000000000003}]
["Dhw circulation loop recoverable losses","QW;dloop;i;ls;rbl;H",null,"kWh",null,null,null,null,null,null,{"$f":"+Method_input!E49","v":14.88},null,null,null,"Data input as module M8.6 results "]
["Dhw circulation loop where recoverable","TZW;dloop,i;ls;rbl,hz",null,"-",null,null,null,null,null,null,{"$f":"+Method_input!E50","v":"Any"},null,null,null,"Data input as module M8.6 results ","This is given as an inforamtion from module MXX because the finel distribution will be edescribed there.",{"$f":"IF($E39=Q$4,$E38,0)+IF($F39=Q$4,$F38,0)+IF($G39=Q$4,$G38,0)+IF($H39=Q$4,$H38,0)+IF($I39=Q$4,$I38,0)+IF($J39=Q$4,$J38,0)+IF($K39=Q$4,$K38,0)","v":0},{"$f":"IF($E39=R$4,$E38,0)+IF($F39=R$4,$F38,0)+IF($G39=R$4,$G38,0)+IF($H39=R$4,$H38,0)+IF($I39=R$4,$I38,0)+IF($J39=R$4,$J38,0)+IF($K39=R$4,$K38,0)","v":0},{"$f":"IF($E39=S$4,$E38,0)+IF($F39=S$4,$F38,0)+IF($G39=S$4,$G38,0)+IF($H39=S$4,$H38,0)+IF($I39=S$4,$I38,0)+IF($J39=S$4,$J38,0)+IF($K39=S$4,$K38,0)","v":0},{"$f":"IF($E39=T$4,$E38,0)+IF($F39=T$4,$F38,0)+IF($G39=T$4,$G38,0)+IF($H39=T$4,$H38,0)+IF($I39=T$4,$I38,0)+IF($J39=T$4,$J38,0)+IF($K39=T$4,$K38,0)","v":14.88}]
["Dhw circulation loop input","QW;dloop;i;in",null,"kWh",null,null,null,null,null,null,{"$f":"+K36","v":563.00400000000002}]
[]
["6.6 DHW Node calculation"]
["Input to connected distributions","QW;node,i;out",null,"kWh",null,null,null,null,null,{"$f":"+K40+I28","v":854.15599999999995},null,null,"(12)"]
["Temperature of connected distributions","θW;node,i;out",null,"°C",null,null,null,null,null,{"$f":"MAX(K33,I22)","v":60},null,null,"(13)",null,null,"This not exactly the equation required."]
[]
["6.6.5 Domestic hot water storage"]
["Storage output","QW;sto,i;out",null,"kWh",null,null,null,null,null,{"$f":"+J43","v":854.15599999999995},null,null,null,null,"Data ouput to module M8.7"]
["Set temperature","ϑW;sto",null,"°C",null,null,null,null,null,{"$f":"+J44","v":60},null,null,null,null,"Data ouput to module M8.7"]
["Operation time of storage",null,null,null,null,null,null,null,null,{"$f":"+Method_input!E183","v":744},null,null,null,null,"Data ouput to module M8.7","Now set as the calcualtion interval"]
["Dhw storage input","QW;sto;i;in",null,"kWh",null,null,null,null,null,{"$f":"+Method_input!E52","v":898.79599999999994},null,null,null,null,"Data input as module M8.7 results "]
["Dhw storage aux","QW;sto;i;aux",null,"kWh",null,null,null,null,null,{"$f":"+Method_input!E53","v":0},null,null,null,null,"Data input as module M8.7 results ",null,null,null,null,null,null,{"$f":"SUM(I51:K51)","v":0}]
["Dhw storage recoverable losses","QW;sto;i;ls;rbl;H",null,"kWh",null,null,null,null,null,{"$f":"+Method_input!E54","v":22.32},null,null,null,null,"Data input as module M8.7 results "]
["Dhw storage where recoverable","TZsto,i;ls;rbl,hz",null,"-",null,null,null,null,null,{"$f":"+Method_input!E55","v":"TZ2"},null,null,null,null,"Data input as module M8.7 results ","This is given as an inforamtion from module MXX because the finel distribution will be edescribed there.",{"$f":"IF($E53=Q$4,$E52,0)+IF($F53=Q$4,$F52,0)+IF($G53=Q$4,$G52,0)+IF($H53=Q$4,$H52,0)+IF($I53=Q$4,$I52,0)++IF($J53=Q$4,$J52,0)+IF($K53=Q$4,$K52,0)","v":0},{"$f":"IF($E53=R$4,$E52,0)+IF($F53=R$4,$F52,0)+IF($G53=R$4,$G52,0)+IF($H53=R$4,$H52,0)+IF($I53=R$4,$I52,0)++IF($J53=R$4,$J52,0)+IF($K53=R$4,$K52,0)","v":22.32},{"$f":"IF($E53=S$4,$E52,0)+IF($F53=S$4,$F52,0)+IF($G53=S$4,$G52,0)+IF($H53=S$4,$H52,0)+IF($I53=S$4,$I52,0)++IF($J53=S$4,$J52,0)+IF($K53=S$4,$K52,0)","v":0},{"$f":"IF($E53=T$4,$E52,0)+IF($F53=T$4,$F52,0)+IF($G53=T$4,$G52,0)+IF($H53=T$4,$H52,0)+IF($I53=T$4,$I52,0)++IF($J53=T$4,$J52,0)+IF($K53=T$4,$K52,0)","v":0}]
["Dhw storage input","QW;sto;i;in",null,"kWh",null,null,null,null,null,{"$f":"+J50","v":898.79599999999994}]
[]
["Thermal solar"]
["Required output for dhw","QW;sol;out;req",null,"kWh",null,null,null,null,null,{"$f":"+J54","v":898.79599999999994}]
[]
["Supplied heat","QW;sol;out",null,"kWh",null,null,null,null,null,{"$f":"+Method_input!E97","v":617.92224999999996}]
["Auxiliary energy","QW;sol;aux",null,"kWh",null,null,null,null,null,{"$f":"+Method_input!E98","v":30.896112500000001},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I60:K60)","v":30.896112500000001}]
["Thermal solar  recoverable losses","QW;sol;i;ls;rbl;H",null,"kWh",null,null,null,null,null,{"$f":"+Method_input!E99","v":0}]
["Thermal solar losses where recoverable","TZsol,i;ls;rbl,hz",null,"-",null,null,null,null,null,{"$f":"+Method_input!E100","v":"None"},null,null,null,null,null,null,{"$f":"IF($E62=Q$4,$E61,0)+IF($F62=Q$4,$F61,0)+IF($G62=Q$4,$G61,0)+IF($H62=Q$4,$H61,0)+IF($I62=Q$4,$I61,0)+IF($J62=Q$4,$J61,0)+IF($K62=Q$4,$K61,0)","v":0},{"$f":"IF($E62=R$4,$E61,0)+IF($F62=R$4,$F61,0)+IF($G62=R$4,$G61,0)+IF($H62=R$4,$H61,0)+IF($I62=R$4,$I61,0)+IF($J62=R$4,$J61,0)+IF($K62=R$4,$K61,0)","v":0},{"$f":"IF($E62=S$4,$E61,0)+IF($F62=S$4,$F61,0)+IF($G62=S$4,$G61,0)+IF($H62=S$4,$H61,0)+IF($I62=S$4,$I61,0)+IF($J62=S$4,$J61,0)+IF($K62=S$4,$K61,0)","v":0},{"$f":"IF($E62=T$4,$E61,0)+IF($F62=T$4,$F61,0)+IF($G62=T$4,$G61,0)+IF($H62=T$4,$H61,0)+IF($I62=T$4,$I61,0)+IF($J62=T$4,$J61,0)+IF($K62=T$4,$K61,0)","v":0}]
["Heat required to back-up heating",null,null,"kWh",null,null,null,null,null,{"$f":"+J57-J59","v":280.87374999999997}]
["LOOK FOR THE DEFINITION OF THE LENGTH OF THE HEATING PERIOD IN THE CALCULATION INTERVAL"]
[]
["6.5.2.1 heat recovery from dhw"]
["Thermal zone specification",null,null,null,"TZ1","TZ2","TZ3"]
["Heating needs","QH;nd;z,i;req ",null,"kWh",{"$f":"+Method_input!E13","v":1500},{"$f":"+Method_input!E14","v":1400},{"$f":"+Method_input!E15","v":1800},null,null,null,null,null,null,null,"Input data from M2.2","This need alredy includes the contribtuion of air preheating"]
["Thermal zone floor area","Ahz,i",null,"m² ",{"$f":"+Method_input!E135","v":120},{"$f":"+Method_input!E136","v":110},150,null,null,null,null,null,null,null,"Input data"]
["Recoverable losses from dhw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q16:Q64)","v":16.181999999999999},{"$f":"SUM(R16:R64)","v":22.32},{"$f":"SUM(S16:S64)","v":43.152000000000001},{"$f":"SUM(T16:T64)","v":14.88}]
["Split of unlocalised recoverable losses",null,null,null,null,null,null,null,null,null,null,null,"(3a)",null,null,null,{"$f":"+$T$70*E69/SUM($E$69:$G$69)","v":4.6989473684210532},{"$f":"+$T$70*F69/SUM($E$69:$G$69)","v":4.3073684210526322},5.8736842105263154]
["Recoverable losses from dhw","QW;sys;ls;rbl;tz,i ",null,null,{"$f":"+Q72","v":20.880947368421051},{"$f":"+R72","v":26.627368421052633},49.025684210526315,null,null,null,null,null,null,null,null,null,{"$f":"+Q70+Q71","v":20.880947368421051},{"$f":"+R70+R71","v":26.627368421052633},49.025684210526315]
["Simplified?",null,null,null,{"$f":"Method_input!E243=Calculation_options!C7","v":true},null,null,null,null,null,null,null,null,null,"Input data","Simplified heat recovery: reduction of needs"]
["Recovery factor","fW;rbl;rh",null,null,{"$f":"+Method_input!E144","v":0.8},null,null,null,null,null,null,null,null,null,"Input data"]
["Simplified recovery",null,null,null,{"$f":"IF($E$73,E72*$E$74,0)","v":16.70475789473684},{"$f":"IF($E$73,F72*$E$74,0)","v":21.301894736842108},39.220547368421052,null,null,null,null,null,"(3b)"]
["To explicit recovery",null,null,null,{"$f":"IF($E$73,0,E72)","v":0},{"$f":"IF($E$73,0,F72)","v":0},0,null,null,null,null,null,"(3d) or (3a)",null,"To thermal zone balance",null,{"$f":"+E76","v":0},{"$f":"+F76","v":0},0]
["Required heating system output by thermal zone","QH;sys;out;tz,i",null,null,{"$f":"+MAX(E68-E75,0)","v":1483.2952421052632},{"$f":"+MAX(F68-F75,0)","v":1378.6981052631579},1760.779452631579,null,null,null,null,null,"(3c) or (3e)","Qh,sys;out = Qh,nd - eta rvd x Qrbl"]
[]
["6.5.2.2 Align thermal zones and heating system zones"]
["Heating system zone floor area","AHZ",null,"m² ",120,110,100,50]
["Required heating system output by heating system zone","QH;sys;out;hz,i",null,"kWh",{"$f":"+E77","v":1483.2952421052632},{"$f":"+F77","v":1378.6981052631579},{"$f":"+$G$77*G80/($G$80+$H$80)","v":1173.8529684210525},{"$f":"+$G$77*H80/($G$80+$H$80)","v":586.92648421052627},null,null,null,null,null,null,"tz = thermal zone (heat balance for need calculation, module M2.2)\nhz = heating system zone (service area)","Apply here any sum or distribution rules to match heating needs by thermal zones to heating system zones and areas heated by specific systems (like stoves, see next step)"]
[]
["6.4.6.2 Space heating emitters circuits"]
[]
["Internal temperature","θint;tz,i",null,"°C",{"$f":"+Method_input!$E$23","v":20},{"$f":"+Method_input!$E$24","v":20},{"$f":"+Method_input!$E$25","v":20},{"$f":"+Method_input!$E$25","v":20},null,null,null,null,null,null,"data input","Possible default value"]
[null,"QH;sys;out;hz,i ",null,"kWh",{"$f":"+E81","v":1483.2952421052632},{"$f":"+F81","v":1378.6981052631579},{"$f":"+G81","v":1173.8529684210525},{"$f":"+H81","v":586.92648421052627}]
["Emission system required output ","QH;em,i;out",null,"kWh",{"$f":"+E86","v":1483.2952421052632},{"$f":"+F86","v":1378.6981052631579},{"$f":"+G86","v":1173.8529684210525},{"$f":"+H86","v":586.92648421052627},null,null,null,null,null,null,"Data ouput to module"]
["Emission system operation time","tH;em,i;ON",null,"h",{"$f":"+Method_input!E189","v":744},{"$f":"+Method_input!E190","v":744},{"$f":"+Method_input!E191","v":744},{"$f":"+Method_input!E192","v":744},null,null,null,null,null,null,"Data ouput to module"]
["Fans operation time","tH;cr,i;ON x βem",null,"h",{"$f":"+E201","v":561.4663501925221},{"$f":"+F201","v":260.93678830951069},538.89407999999992,47.938176108246161,null,null,null,null,null,"Auxiliary of emiters to be calculated in the circuit module in this EN 15316-1 to avoid a loop.\nPutting the equation for auxiliaries in EN 15316-2  but asking for β from EN 15316-1 creates problems. \nNeeds a more accurate look to solve definitely."]
[]
["Heating emission and control input","QH;em,i;out",null,"kWh",{"$f":"+Method_input!E57","v":1648.1058245614036},{"$f":"+Method_input!E58","v":1531.8867836257309},{"$f":"+Method_input!E59","v":1296.5020636415425},{"$f":"+Method_input!E60","v":617.81735180055398},null,null,null,null,null,null,"Data input as module return"]
["Heating emission and control  aux","QH;em,i;aux",null,"kWh",{"$f":"+Method_input!E61","v":0},{"$f":"+Method_input!E62","v":0},{"$f":"+Method_input!E63","v":7.7790123818492543},{"$f":"+Method_input!E64","v":0},null,null,null,null,null,null,"Data input as module return",null,null,null,null,null,{"$f":"SUM(E92:H92)","v":7.7790123818492543}]
["Heating emission and control   recoverable losses","QH;em;i;ls;rbl;H",null,"kWh",{"$f":"+Method_input!E65","v":0},{"$f":"+Method_input!E66","v":0},{"$f":"+Method_input!E67","v":0},{"$f":"+Method_input!E68","v":0}]
["Heating emission and control  losses where recoverable","TZH;em,i;ls;rbl,hz",null,"-",{"$f":"+Method_input!E69","v":"TZ1"},{"$f":"+Method_input!E70","v":"TZ2"},{"$f":"+Method_input!E71","v":"TZ3"},{"$f":"+Method_input!E72","v":"TZ3"},null,null,null,null,null,null,null,null,{"$f":"IF($E94=Q$4,$E93,0)+IF($F94=Q$4,$F93,0)+IF($G94=Q$4,$G93,0)+IF($H94=Q$4,$H93,0)+IF($I94=Q$4,$I93,0)+IF($J94=Q$4,$J93,0)+IF($K94=Q$4,$K93,0)","v":0},0,0,0]
["Emission & ctrl input","QH;em;i;in",null,"kWh",{"$f":"+E91","v":1648.1058245614036},{"$f":"+F91","v":1531.8867836257309},1296.5020636415425,617.81735180055398]
[]
["Temperature (operating conditions) calculation for emitters"]
["Water specific heat","cw","c_w","Wh/kgK",{"$f":"+Method_input!E246","v":1.1599999999999999},null,null,null,null,null,null,null,null,"Constant","Copy of input"]
["Emitters properties",null,null,null,null,null,null,null,null,null,null,null,null,"Common input for any type of emitter circuit","Copy of input"]
["Nominal emitter power","ΦH;em;n",null,"kW",{"$f":"+Method_input!E124","v":5},{"$f":"+Method_input!E125","v":10},{"$f":"+Method_input!E126","v":5},{"$f":"+Method_input!E127","v":10},null,null,null,null,null,null,"Copy of input"]
["Nominal DT (air)","ΔθH;em;air",null,"°C",{"$f":"+Method_input!E159","v":50},{"$f":"+Method_input!E160","v":50},{"$f":"+Method_input!E161","v":15},{"$f":"+Method_input!E162","v":25},null,null,null,null,null,null,"Copy of input"]
["Emitter exponent","nH;em",null,null,{"$f":"+Method_input!E164","v":1.3},{"$f":"+Method_input!E165","v":1.3},{"$f":"+Method_input!E166","v":1.1000000000000001},{"$f":"+Method_input!E167","v":1},null,null,null,null,null,null,"Copy of input"]
["Mixing valve","MIX_EM",null,null,{"$f":"Method_input!$E$214=1","v":false},{"$f":"Method_input!$E$215=1","v":false},{"$f":"Method_input!$E$216=1","v":true},{"$f":"Method_input!$E$217=1","v":false},null,null,null,null,null,"Specifies if there is a mixing valve at the connectoin point to the header","Copy of input"]
["Mixing valve Δθ","ΔθH;em;mix",null,null,{"$f":"+Method_input!$E$219","v":2},{"$f":"+Method_input!$E$220","v":2},{"$f":"+Method_input!$E$221","v":2},{"$f":"+Method_input!$E$222","v":2},null,null,null,null,null,"Specifies the minimum desired DT for correct operation of the mixing valve, if any","Copy of input"]
[]
["Type 1: constant flow and temperature"]
["Control properties"]
["Set full load DT (water)","ΔθH;em;n",null,"°C",{"$f":"+Method_input!$E$194","v":20},{"$f":"+Method_input!$E$195","v":20},{"$f":"+Method_input!$E$196","v":5},{"$f":"+Method_input!$E$197","v":10},null,null,null,null,null,null,"Copy of input"]
[]
["Average power","ΦH,em,eff ",null,"kW",{"$f":"+IF(E88=0,0,E95/E88)","v":2.2151960007545748},2.058987612400176,1.742610300593471,0.83039966639859408,null,null,null,null,"(C.1)",null,"\"eff\" for effective i.e. actual"]
["Nominal flow rate","V’H,em,nom ",null,"m³/h ",{"$f":"+E100/(E108*__c_w)","v":0.21551724137931036},{"$f":"+F100/(F108*__c_w)","v":0.43103448275862072},{"$f":"+G100/(G108*__c_w)","v":0.86206896551724144},{"$f":"+H100/(H108*__c_w)","v":0.86206896551724144},null,null,null,null,"(C.4)"]
["Actual flow rate","V’H,em,eff ",null,"m³/h ",{"$f":"+E111","v":0.21551724137931036},{"$f":"+F111","v":0.43103448275862072},{"$f":"+G111","v":0.86206896551724144},{"$f":"+H111","v":0.86206896551724144},null,null,null,null,"(C.5)"]
["Emitter to air temperature difference  ","ΔθH,em,air,eff  ",null,"°C",{"$f":"+IFERROR(E101*((E110/E100)^(1/E102)),0)","v":26.730213695566434},{"$f":"+IFERROR(F101*((F110/F100)^(1/F102)),0)","v":14.825567893023543},5.7535641718375743,2.0759991659964854,null,null,null,null,"(C.2)"]
["Average emitter temperature","θH,em,avg  ",null,"°C",{"$f":"+E113+E85","v":46.730213695566434},{"$f":"+F113+F85","v":34.825567893023546},{"$f":"+G113+G85","v":25.753564171837574},{"$f":"+H113+H85","v":22.075999165996485},null,null,null,null,"(C.3)"]
["DT actual flow / return","ΔθH,em,w,eff  ",null,"°C",{"$f":"+E110/(__c_w*E112)","v":8.8607840030182992},{"$f":"+F110/(__c_w*F112)","v":4.1179752248003521},{"$f":"+G110/(__c_w*G112)","v":1.742610300593471},{"$f":"+H110/(__c_w*H112)","v":0.83039966639859408},null,null,null,null,"(C.6)"]
["Emitter flow temperature ","θH,em,flw  ",null,"°C",{"$f":"+E114+E115/2","v":51.160605697075582},{"$f":"+F114+F115/2","v":36.88455550542372},{"$f":"+G114+G115/2","v":26.624869322134309},{"$f":"+H114+H115/2","v":22.491198999195781},null,null,null,null,"(C.7)"]
["Emitter return temperature ","θH,em,ret ",null,"°C",{"$f":"+E114-E115/2","v":42.299821694057286},{"$f":"+F114-F115/2","v":32.766580280623373},{"$f":"+G114-G115/2","v":24.88225902154084},{"$f":"+H114-H115/2","v":21.66079933279719},null,null,null,null,"(C.8)"]
[]
["Circuit required flow  temperature  ","θH,em,flw,min  ",null,"°C",{"$f":"IF(E103,E104+E116,E116)","v":51.160605697075582},{"$f":"IF(F103,F104+F116,F116)","v":36.88455550542372},28.624869322134309,22.491198999195781,null,null,null,null,"(C.10)"]
[]
["Type 2: Variable flow rate"]
["Control properties"]
["Target return temperature","θH,em,ret,set  ",null,"°C",{"$f":"+MAX(Method_input!$E$209,E85)","v":20},{"$f":"+MAX(Method_input!$E$209,F85)","v":20},{"$f":"+MAX(Method_input!$E$209,G85)","v":20},{"$f":"+MAX(Method_input!$E$209,H85)","v":20}]
["Set full load DT (water)","ΔθH;em;w;n",null,"°C",{"$f":"+Method_input!$E$194","v":20},{"$f":"+Method_input!$E$195","v":20},{"$f":"+Method_input!$E$196","v":5},{"$f":"+Method_input!$E$197","v":10},null,null,null,null,null,null,"Copy of input"]
["Maximum flow temperature","θH;em;flw;max",null,"°C",{"$f":"+Method_input!E199","v":80},{"$f":"+Method_input!$E$200","v":80},{"$f":"+Method_input!$E$201","v":80},{"$f":"+Method_input!$E$202","v":80},null,null,null,null,null,null,"Copy of input"]
["Max Δθ flow / return HZ1","ΔθH;em:w;max",null,"°C",{"$f":"+Method_input!$E$204","v":20},{"$f":"+Method_input!$E$205","v":20},{"$f":"+Method_input!$E$206","v":20},{"$f":"+Method_input!$E$207","v":20},null,null,null,null,null,null,"Copy of input"]
[]
["Average power","ΦH,em,eff  ",null,"kW",{"$f":"+IF(E88=0,0,E95/E88)","v":2.2151960007545748},{"$f":"+IF(F88=0,0,F95/F88)","v":2.058987612400176},{"$f":"+IF(G88=0,0,G95/G88)","v":1.742610300593471},{"$f":"+IF(H88=0,0,H95/H88)","v":0.83039966639859408}]
["Actual DT (air)","ΔθH,em,air,eff  ",null,"°C",{"$f":"+IFERROR(E101*((E128/E100)^(1/E102)),0)","v":26.730213695566434},{"$f":"+IFERROR(F101*((F128/F100)^(1/F102)),0)","v":14.825567893023543},{"$f":"+IFERROR(G101*((G128/G100)^(1/G102)),0)","v":5.7535641718375743},{"$f":"+IFERROR(H101*((H128/H100)^(1/H102)),0)","v":2.0759991659964854}]
["Average emitter temperature","θH,em,avg  ",null,"°C",{"$f":"+E85+E129","v":46.730213695566434},{"$f":"+F85+F129","v":34.825567893023546},{"$f":"+G85+G129","v":25.753564171837574},{"$f":"+H85+H129","v":22.075999165996485}]
["Limited flow temperature","θH,em,flw,lim  ",null,"°C",{"$f":"MIN(E125,E130+E126/2)","v":56.730213695566434},{"$f":"MIN(F125,F130+F126/2)","v":44.825567893023546},{"$f":"MIN(G125,G130+G126/2)","v":35.753564171837574},{"$f":"MIN(H125,H130+H126/2)","v":32.075999165996485}]
["Emitter flow temperature","θH,em,flw  ",null,"°C",{"$f":"MIN(E131,2*E130-E123)","v":56.730213695566434},{"$f":"MIN(F131,2*F130-F123)","v":44.825567893023546},{"$f":"MIN(G131,2*G130-G123)","v":31.507128343675149},{"$f":"MIN(H131,2*H130-H123)","v":24.151998331992971}]
["Emiter return temperature","θH,em,ret ",null,"°C",{"$f":"2*E130-E132","v":36.730213695566434},{"$f":"2*F130-F132","v":24.825567893023546},20,20]
["Actual DT (flow/return)","ΔθH,em,w,eff  ",null,"°C",{"$f":"+E132-E133","v":20},{"$f":"+F132-F133","v":20},11.507128343675149,4.1519983319929707]
["Actual flow rate","V’H,em,eff ",null,"m³/h ",{"$f":"+IFERROR(E128/(__c_w*E134),0)","v":9.5482586239421324E-2},{"$f":"+IFERROR(F128/(__c_w*F134),0)","v":8.8749466051731729E-2},{"$f":"+IFERROR(G128/(__c_w*G134),0)","v":0.1305495354067211},{"$f":"+IFERROR(H128/(__c_w*H134),0)","v":0.17241379310344829}]
[]
["Circuit required flow  temperature  ","θH,em,flw,min  ",null,"°C",{"$f":"E132+IF(E103,E104,0)","v":56.730213695566434},{"$f":"F132+IF(F103,F104,0)","v":44.825567893023546},{"$f":"G132+IF(G103,G104,0)","v":33.507128343675149},{"$f":"H132+IF(H103,H104,0)","v":24.151998331992971}]
[]
["Type 3: On-OFF control"]
["Control properties"]
["Set full load DT (water)","ΔθH;em;w;n",null,"°C",{"$f":"+Method_input!$E$194","v":20},{"$f":"+Method_input!$E$195","v":20},{"$f":"+Method_input!$E$196","v":5},{"$f":"+Method_input!$E$197","v":10}]
["Desired load factor with ON-OFF","βH;em;req",null,"%",{"$f":"+Method_input!$E$224","v":80},{"$f":"+Method_input!$E$225","v":80},{"$f":"+Method_input!$E$226","v":80},{"$f":"+Method_input!$E$227","v":80}]
[]
["Nominal flow rate","V’H,em,nom ",null,"m³/h ",{"$f":"+E100/(E141*__c_w)","v":0.21551724137931036},{"$f":"+F100/(F141*__c_w)","v":0.43103448275862072},{"$f":"+G100/(G141*__c_w)","v":0.86206896551724144},{"$f":"+H100/(H141*__c_w)","v":0.86206896551724144}]
["Flow rate when on","V’H,em,eff",null,"m³/h",{"$f":"+E144","v":0.21551724137931036},{"$f":"+F144","v":0.43103448275862072},0.86206896551724144,0.86206896551724144]
["Average power","ΦH,em,eff  ",null,"kW",{"$f":"+IF(E88=0,0,E95/E88)","v":2.2151960007545748},{"$f":"+IF(F88=0,0,F95/F88)","v":2.058987612400176},{"$f":"+IF(G88=0,0,G95/G88)","v":1.742610300593471},{"$f":"+IF(H88=0,0,H95/H88)","v":0.83039966639859408}]
["Actual DT (air)","ΔθH,em,air,eff  ",null,"°C",{"$f":"+IFERROR(E101*((E146/E100)^(1/E102)),0)","v":26.730213695566434},{"$f":"+IFERROR(F101*((F146/F100)^(1/F102)),0)","v":14.825567893023543},{"$f":"+IFERROR(G101*((G146/G100)^(1/G102)),0)","v":5.7535641718375743},{"$f":"+IFERROR(H101*((H146/H100)^(1/H102)),0)","v":2.0759991659964854}]
["Flow temperature","θH,em,flw,calc  ",null,"°C",{"$f":"+IFERROR(E85+(E101+E141/2)*((E146*100/E100/E142)^(1/E102)),0)","v":58.082884943930203},{"$f":"+IFERROR(F85+(F101+F141/2)*((F146*100/F100/F142)^(1/F102)),0)","v":41.122180418336413},{"$f":"+IFERROR(G85+(G101+G141/2)*((G146*100/G100/G142)^(1/G102)),0)","v":28.222119088501429},{"$f":"+IFERROR(H85+(H101+H141/2)*((H146*100/H100/H142)^(1/H102)),0)","v":23.113998748994728}]
[]
["Circuit required flow  temperature  ","θH,em,flw,min  ",null,"°C",{"$f":"E148+IF(E103,E104,0)","v":58.082884943930203},{"$f":"F148+IF(F103,F104,0)","v":41.122180418336413},{"$f":"G148+IF(G103,G104,0)","v":30.222119088501429},{"$f":"H148+IF(H103,H104,0)","v":23.113998748994728},null,null,null,null,null,null,null,"Not em but cr"]
[]
["Type 4 - Variable heat exchange + by-pass"]
["Control properties"]
["Set full load DT (water)","ΔθH;em;w;n",null,"°C",{"$f":"+Method_input!$E$194","v":20},{"$f":"+Method_input!$E$195","v":20},{"$f":"+Method_input!$E$196","v":5},{"$f":"+Method_input!$E$197","v":10}]
["Desired load factor ","βH;em;req",null,"%",{"$f":"+Method_input!$E$224","v":80},{"$f":"+Method_input!$E$225","v":80},{"$f":"+Method_input!$E$226","v":80},{"$f":"+Method_input!$E$227","v":80}]
["Minimum flow temperature","θH,em,flw,min;set",null,"°C",{"$f":"+Method_input!$E$229","v":50},{"$f":"+Method_input!$E$230","v":45},{"$f":"+Method_input!$E$231","v":50},{"$f":"+Method_input!$E$232","v":45}]
[]
["Flow rate when on","V’H,em,nom ",null,null,{"$f":"+E100/(E154*__c_w)","v":0.21551724137931036},{"$f":"+F100/(F154*__c_w)","v":0.43103448275862072},{"$f":"+G100/(G154*__c_w)","v":0.86206896551724144},{"$f":"+H100/(H154*__c_w)","v":0.86206896551724144}]
["Average power","θH,em,eff ",null,null,{"$f":"+IF(E88=0,0,E95/E88)","v":2.2151960007545748},{"$f":"+IF(F88=0,0,F95/F88)","v":2.058987612400176},{"$f":"+IF(G88=0,0,G95/G88)","v":1.742610300593471},{"$f":"+IF(H88=0,0,H95/H88)","v":0.83039966639859408}]
["calculated flow temperature","θH,em,flw,calc",null,null,{"$f":"+IFERROR(E85+(E101+E154/2)*((E159*100/E100/E155)^(1/E102)),0)","v":58.082884943930203},{"$f":"+IFERROR(F85+(F101+F154/2)*((F159*100/F100/F155)^(1/F102)),0)","v":41.122180418336413},{"$f":"+IFERROR(G85+(G101+G154/2)*((G159*100/G100/G155)^(1/G102)),0)","v":28.222119088501429},{"$f":"+IFERROR(H85+(H101+H154/2)*((H159*100/H100/H155)^(1/H102)),0)","v":23.113998748994728}]
["Set temperature","θH,em,flw,set",null,null,"user ","user ","user ","user ",null,null,null,null,null,null,"Data input"]
["Selected emitter  flow temperature","θH,em,flw,min",null,null,{"$f":"MAX(E160,E156,E161)","v":58.082884943930203},{"$f":"MAX(F160,F156,F161)","v":45},50,45,null,null,null,null,null,null,"Add set temperature"]
[]
["Circuit required flow  temperature  ","θH,cr,flw,min  ",null,"°C",{"$f":"E162+IF(E103,E104,0)","v":58.082884943930203},{"$f":"F162+IF(F103,F104,0)","v":45},{"$f":"G162+IF(G103,G104,0)","v":52},{"$f":"H162+IF(H103,H104,0)","v":45}]
[]
["Type of circuit",null,null,null,{"$f":"Method_input!$D$170","v":2},{"$f":"Method_input!$D$171","v":3},{"$f":"Method_input!$D$172","v":1},{"$f":"Method_input!$D$173","v":4}]
["Minimum flow temperature for circuits 1, 2 and 3","θH,cr,flw,min",null,null,{"$f":"CHOOSE(E166,E119,E137,E150,E164)","v":56.730213695566434},{"$f":"CHOOSE(F166,F119,F137,F150,F164)","v":41.122180418336413},{"$f":"CHOOSE(G166,G119,G137,G150,G164)","v":28.624869322134309}]
["Selected flow temperature (node output)","θH;nod;out  ",null,null,{"$f":"MAX($E$167:$G$167)","v":56.730213695566434},{"$f":"MAX($E$167:$G$167)","v":56.730213695566434},56.730213695566434]
[]
["Minimum flow temperature for circuit 4 ","θH,cr,flw,min",null,null,null,null,{"$f":"+F275","v":56.730213695566434},{"$f":"CHOOSE(H166,H119,H137,H150,H164)","v":45},"DHW"]
["Minimum flow temperature for node 123"]
["Selected flow temperature (node output)","θH;nod;out  ",null,null,null,null,null,{"$f":"MAX(G170:I170)","v":56.730213695566434}]
[]
["Complete temperature calculation"]
["Type 1"]
["Circuit flow temperature","θH,cr,flw  ",null,"°C",{"$f":"+E168","v":56.730213695566434},{"$f":"+F168","v":56.730213695566434},56.730213695566434,{"$f":"+H172","v":56.730213695566434}]
["Circuit return temperature","θH,cr,ret  ",null,"°C",{"$f":"+E117","v":42.299821694057286},{"$f":"+F117","v":32.766580280623373},{"$f":"+G117","v":24.88225902154084},{"$f":"+H117","v":21.66079933279719}]
["Circuit flow rate","V’H,cr ",null,"m³/h",{"$f":"+E110/(__c_w*(E176-E177))","v":0.13233540187880641},{"$f":"+F110/(__c_w*(F176-F177))","v":7.4070124938891785E-2},{"$f":"+G110/(__c_w*(G176-G177))","v":4.716944226115409E-2},{"$f":"+H110/(__c_w*(H176-H177))","v":2.0412709889392366E-2}]
["Distribution flow temperature","θH,dis,flw  ",null,"°C",{"$f":"+E116","v":51.160605697075582},{"$f":"+F116","v":36.88455550542372},{"$f":"+G116","v":26.624869322134309},{"$f":"+H116","v":22.491198999195781}]
["Distribution return temperature","θH,ret,ret  ",null,"°C",{"$f":"+E177","v":42.299821694057286},{"$f":"+F177","v":32.766580280623373},24.88225902154084,21.66079933279719]
["Emission load factor","βH,em  ",null,null,{"$f":"+E110/E100","v":0.44303920015091497},{"$f":"+F110/F100","v":0.2058987612400176},0.34852206011869419,8.3039966639859408E-2]
["Type 2"]
["Circuit flow temperature","θH,cr,flw  ",null,"°C",{"$f":"+$E$168","v":56.730213695566434},{"$f":"+$F$168","v":56.730213695566434},{"$f":"+$G$168","v":56.730213695566434},{"$f":"+$H$172","v":56.730213695566434}]
["With mixing valve"]
["Return temperature","θH,cr,ret  ",null,"°C",{"$f":"+E133","v":36.730213695566434},{"$f":"+F133","v":24.825567893023546},{"$f":"+G133","v":20},{"$f":"+H133","v":20}]
["Circuit flow rate","V’H,cr ",null,"m³/h",{"$f":"+E128/__c_w/(E183-E185)","v":9.5482586239421324E-2},{"$f":"+F128/__c_w/(F183-F185)","v":5.5634196098587094E-2},{"$f":"+G128/__c_w/(G183-G185)","v":4.0899578520928494E-2},{"$f":"+H128/__c_w/(H183-H185)","v":1.9489725469920352E-2}]
["Without mixing valve"]
["Return temperature","θH,cr,ret  ",null,"°C",{"$f":"MAX(E85,2*E130-E183)","v":36.730213695566434},{"$f":"MAX(F85,2*F130-F183)","v":20},{"$f":"MAX(G85,2*G130-G183)","v":20},{"$f":"MAX(H85,2*H130-H183)","v":20}]
["Circuit flow rate","V’H,cr ",null,"m³/h",{"$f":"+E128/__c_w/(E183-E188)","v":9.5482586239421324E-2},{"$f":"+F128/__c_w/(F183-F188)","v":4.832504748669314E-2},{"$f":"+G128/__c_w/(G183-G188)","v":4.0899578520928494E-2},{"$f":"+H128/__c_w/(H183-H188)","v":1.9489725469920352E-2}]
["Selected circuit return temperature","θH,cr,ret  ",null,"°C",{"$f":"IF(E103,E185,E188)","v":36.730213695566434},{"$f":"IF(F103,F185,F188)","v":20},{"$f":"IF(G103,G185,G188)","v":20},{"$f":"IF(H103,H185,H188)","v":20}]
["Selected circuit flow rate","V’H,cr ",null,"m³/h",{"$f":"IF(E103,E186,E189)","v":9.5482586239421324E-2},{"$f":"IF(F103,F186,F189)","v":4.832504748669314E-2},{"$f":"IF(G103,G186,G189)","v":4.0899578520928494E-2},{"$f":"IF(H103,H186,H189)","v":1.9489725469920352E-2}]
["Distribution flow temperature","θH,dis,flw  ",null,"°C",{"$f":"IF(E103,E137,E183)","v":56.730213695566434},{"$f":"IF(F103,F137,F183)","v":56.730213695566434},{"$f":"IF(G103,G137,G183)","v":33.507128343675149},{"$f":"IF(H103,H137,H183)","v":56.730213695566434}]
["Distribution return temperature","θH,dis,ret  ",null,"°C",{"$f":"+E190","v":36.730213695566434},{"$f":"+F190","v":20},20,20]
["Emission load factor","βH,em  ",null,null,{"$f":"+E128/E100","v":0.44303920015091497},{"$f":"+F128/F100","v":0.2058987612400176},0.34852206011869419,8.3039966639859408E-2]
[]
["Type 3"]
["Flow temperature to emitters","θH,em,flw,eff  ",null,"m³/h",{"$f":"IF(E103,E148,E168)","v":56.730213695566434},{"$f":"IF(F103,F148,F168)","v":56.730213695566434},{"$f":"IF(G103,G148,G168)","v":28.222119088501429},{"$f":"IF(H103,H148,H172)","v":56.730213695566434}]
["Relative temperature difference",null,null,"-",{"$f":"+(E197-E85)/(E101+E141/2)","v":0.61217022825944056},{"$f":"+(F197-F85)/(F101+F141/2)","v":0.61217022825944056},{"$f":"+(G197-G85)/(G101+G141/2)","v":0.46983537648579599},{"$f":"+(H197-H85)/(H101+H141/2)","v":1.2243404565188811}]
["Relative power when ON","βH;em;ON",null,"-",{"$f":"+E198^E102","v":0.52836478681105414},{"$f":"+F198^F102","v":0.52836478681105414},{"$f":"+G198^G102","v":0.4356525751483678},{"$f":"+H198^H102","v":1.2243404565188811}]
["Power when ON","ФH;em;ON",null,"kW",{"$f":"+E199*E100","v":2.6418239340552709},{"$f":"+F199*F100","v":5.2836478681105419},{"$f":"+G199*G100","v":2.1782628757418392},{"$f":"+H199*H100","v":12.243404565188811}]
["Time ON","t H,cr,ON  ",null,"h",{"$f":"+E86/E200","v":561.4663501925221},{"$f":"+F86/F200","v":260.93678830951069},{"$f":"+G86/G200","v":538.89407999999992},{"$f":"+H86/H200","v":47.938176108246161}]
["Emitter return temperature","θH,em,ret  ",null,null,{"$f":"+E197-E200/(__c_w*E145)","v":46.16291795934535},{"$f":"+F197-F200/(__c_w*F145)","v":46.16291795934535},{"$f":"+G197-G200/(__c_w*G145)","v":26.043856212759589},{"$f":"+H197-H200/(__c_w*H145)","v":44.486809130377623}]
["Circuit flow temperature","θH,cr,flw  ",null,"°C",{"$f":"+E168","v":56.730213695566434},{"$f":"+F168","v":56.730213695566434},{"$f":"+G168","v":56.730213695566434},{"$f":"+H172","v":56.730213695566434}]
["Circuit return temperature","θH,cr,ret  ",null,"°C",{"$f":"+E202","v":46.16291795934535},{"$f":"+F202","v":46.16291795934535},26.043856212759589,44.486809130377623]
["Circuit flow rate","V’H,cr ",null,"m³/h",{"$f":"+E146/(__c_w*(E168-E202))","v":0.18071337951135333},{"$f":"+F146/(__c_w*(F168-F202))","v":0.16797006209929158},{"$f":"+G146/(__c_w*(G168-G202))","v":4.8954987895646895E-2},{"$f":"+H146/(__c_w*(H172-H202))","v":5.8469176409761049E-2}]
["Distribution flow temperature","θH,dis,flw  ",null,"°C",{"$f":"+E197","v":56.730213695566434},{"$f":"+F197","v":56.730213695566434},{"$f":"+G197","v":28.222119088501429},{"$f":"+H197","v":56.730213695566434}]
["Distribution return temperature","θH,ret,ret  ",null,"°C",{"$f":"+E202","v":46.16291795934535},{"$f":"+F202","v":46.16291795934535},{"$f":"+G202","v":26.043856212759589},{"$f":"+H202","v":44.486809130377623}]
["Load factor ","βH,em  ",null,"-",{"$f":"+E201/E88","v":0.75465907283941147},{"$f":"+F201/F88","v":0.35072148966332084},{"$f":"+G201/G88","v":0.72431999999999985},{"$f":"+H201/H88","v":6.4433032403556662E-2}]
[]
["Type 4"]
["With mixing valve"]
["Flow temperature",null,null,"°C",{"$f":"+E162","v":58.082884943930203},{"$f":"+F162","v":45},{"$f":"+G162","v":50},{"$f":"+H162","v":45}]
["Without mixing valve"]
["Flow  temperature",null,null,"°C",{"$f":"+E168","v":56.730213695566434},{"$f":"+F168","v":56.730213695566434},{"$f":"+G168","v":56.730213695566434},{"$f":"+H172","v":56.730213695566434}]
["Selected flow temperature","θH,em,flw,eff  ",null,"°C",{"$f":"IF(E121,E212,E214)","v":56.730213695566434},{"$f":"IF(F121,F212,F214)","v":56.730213695566434},{"$f":"IF(G121,G212,G214)","v":56.730213695566434},{"$f":"IF(H121,H212,H214)","v":56.730213695566434}]
["Return temperature","θH,em,ret  ",null,"°C",{"$f":"+E215-E159/(E158*__c_w)","v":47.869429692548138},{"$f":"+F215-F159/(F158*__c_w)","v":52.61223847076608},{"$f":"+G215-G159/(G158*__c_w)","v":54.987603394972965},{"$f":"+H215-H159/(H158*__c_w)","v":55.899814029167842}]
["Average temperature","θH,em,avg",null,"°C",{"$f":"+(E216+E215)/2","v":52.299821694057286},{"$f":"+(F216+F215)/2","v":54.67122608316626},55.858908545269699,56.315013862367138]
["Power when ON","ΦH,em,ON ",null,"kW",{"$f":"+E100*(((E217-E85)/E101)^E102)","v":2.833147340813551},{"$f":"+F100*(((F217-F85)/F101)^F102)","v":6.2129656754269753},{"$f":"+G100*(((G217-G85)/G101)^G102)","v":13.04146537411423},{"$f":"+H100*(((H217-H85)/H101)^H102)","v":14.526005544946855}]
["Circuit flow rate","V’H,em ",null,"m³/h",{"$f":"+IFERROR(E159/(__c_w*(E168-E216)),0)","v":0.21551724137931044},{"$f":"+IFERROR(F159/(__c_w*(F168-F216)),0)","v":0.43103448275862055},{"$f":"+IFERROR(G159/(__c_w*(G168-G216)),0)","v":0.86206896551724221},{"$f":"+IFERROR(H159/(__c_w*(H172-H216)),0)","v":0.86206896551724432}]
["Distribution flow temperature","θH,dis,flw  ",null,"°C",{"$f":"+E215","v":56.730213695566434},56.730213695566434,56.730213695566434,56.730213695566434]
["Distribution return temperature","θH,ret,ret  ",null,"°C",47.869429692548138,52.61223847076608,54.987603394972965,55.899814029167842]
["Load factor","βH,em  ",null,null,{"$f":"+E159/E218","v":0.78188520901933445},{"$f":"+F159/F218","v":0.33140173629861164},{"$f":"+G159/G218","v":0.13362074357474787},{"$f":"+H159/H218","v":5.7166415352737095E-2}]
[]
["Data selection"]
["Circuit type",null,null,null,{"$f":"+Method_input!$D$170","v":2},{"$f":"+Method_input!$D$171","v":3},{"$f":"+Method_input!$D$172","v":1},{"$f":"+Method_input!$D$173","v":4}]
["Flow temperature","θH,cr,flw  ",null,null,{"$f":"+E168","v":56.730213695566434},{"$f":"+F168","v":56.730213695566434},{"$f":"+G168","v":56.730213695566434},{"$f":"+H172","v":56.730213695566434},null,null,null,null,null,"Select which to use"]
["Return temperature","θH,cr,ret",null,null,{"$f":"CHOOSE(E225,E177,E190,E202,E216)","v":36.730213695566434},{"$f":"CHOOSE(F225,F177,F190,F202,F216)","v":46.16291795934535},{"$f":"CHOOSE(G225,G177,G190,G202,G216)","v":24.88225902154084},{"$f":"CHOOSE(H225,H177,H190,H202,H216)","v":55.899814029167842},null,null,null,null,null,"Select which to use"]
["Flow rate","V'H,cr",null,null,{"$f":"CHOOSE(E225,E178,E191,E205,E219)","v":9.5482586239421324E-2},{"$f":"CHOOSE(F225,F178,F191,F205,F219)","v":0.16797006209929158},{"$f":"CHOOSE(G225,G178,G191,G205,G219)","v":4.716944226115409E-2},{"$f":"CHOOSE(H225,H178,H191,H205,H219)","v":0.86206896551724432},null,null,null,null,null,"Select which to use"]
["Distribution flow temperature","θH,dis,flw  ",null,null,{"$f":"CHOOSE(E$225,E179,E192,E206,E220)","v":56.730213695566434},56.730213695566434,26.624869322134309,56.730213695566434,null,null,null,null,null,"Select which to use"]
["Distribution return temperature","θH,ret,ret  ",null,null,36.730213695566434,46.16291795934535,24.88225902154084,55.899814029167842,null,null,null,null,null,"Select which to use"]
["Load factor","βH,em  ",null,null,{"$f":"CHOOSE($E$225,E181,E194,E208,E222)","v":0.44303920015091497},{"$f":"CHOOSE($E$225,F181,F194,F208,F222)","v":0.2058987612400176},0.34852206011869419,8.3039966639859408E-2,0,0,0,0,null,"Select which to use"]
["6.5.3.4 Heating distribution 1, 2 and 3"]
["Required output",null,null,"kWh",{"$f":"+E95","v":1648.1058245614036},{"$f":"+F95","v":1531.8867836257309},{"$f":"+G95","v":1296.5020636415425},null,null,null,null,null,null,null,"Just copy of data"]
["Heating distribution required output ","QH;em,i;out",null,"kWh",{"$f":"+E233","v":1648.1058245614036},{"$f":"+F233","v":1531.8867836257309},{"$f":"+G233","v":1296.5020636415425},null,null,null,null,null,null,null,"Data ouput to module M3.6"]
["Flow temperature","θH,dis,flw  ",null,null,{"$f":"+E229","v":56.730213695566434},{"$f":"+F229","v":56.730213695566434},26.624869322134309,null,null,null,null,null,null,null,"Data ouput to module M3.6"]
["Return temperature","θH,ret,ret  ",null,null,{"$f":"+E230","v":36.730213695566434},{"$f":"+F230","v":46.16291795934535},24.88225902154084,null,null,null,null,null,null,null,"Data ouput to module M3.6"]
["Operation time","tH;dis,i;ON",null,null,{"$f":"+E88","v":744},{"$f":"+F88","v":744},{"$f":"+G88","v":744},null,null,null,null,null,null,null,"Data ouput to module M3.6"]
[]
["Heating distribution  input","QW;sto;i;ls",null,"kWh",{"$f":"+Method_input!$E$75","v":1886.5299724354209},{"$f":"+Method_input!$E$76","v":1648.7936085038668},{"$f":"+Method_input!$E$77","v":1317.8309223607782},null,null,null,null,null,null,null,"Data input as module M3.6 results "]
["Heating distribution  aux","QW;sto;i;aux",null,"kWh",{"$f":"+Method_input!$E$79","v":17.856000000000002},{"$f":"+Method_input!$E$80","v":5.952},{"$f":"+Method_input!$E$81","v":5.952},null,null,null,null,null,null,null,"Data input as module M3.6 results ",null,null,null,null,null,{"$f":"SUM(E240:H240)","v":29.759999999999998}]
["Heating distribution  recoverable losses","QW;sto;i;ls;rbl;H",null,"kWh",{"$f":"+Method_input!$E$83","v":178.98551090551283},{"$f":"+Method_input!$E$84","v":58.490612439067952},{"$f":"+Method_input!$E$85","v":8.5613034876943104},null,null,null,null,null,null,null,"Data input as module M3.6 results "]
["Heating distribution  losses where recoverable","TZsto,i;ls;rbl,hz",null,"-",{"$f":"+Method_input!$E$87","v":"TZ1"},{"$f":"+Method_input!$E$88","v":"TZ2"},{"$f":"+Method_input!$E$89","v":"TZ3"},null,null,null,null,null,null,null,"Data input as module M3.6 results ",null,{"$f":"IF($E242=Q$4,$E241,0)+IF($F242=Q$4,$F241,0)+IF($G242=Q$4,$G241,0)+IF($H242=Q$4,$H241,0)+IF($I242=Q$4,$I241,0)+IF($J242=Q$4,$J241,0)+IF($K242=Q$4,$K241,0)","v":178.98551090551283},58.490612439067952,8.5613034876943104,0]
[]
["6.6 - NODE 123"]
["Required heating system input by heating zone","QX;dis;in",null,null,{"$f":"+E239","v":1886.5299724354209},{"$f":"+F239","v":1648.7936085038668},1317.8309223607782]
["Flow temperature","θX;dis;in;flw",null,null,{"$f":"+E226","v":56.730213695566434},{"$f":"+F226","v":56.730213695566434},56.730213695566434]
["Return temperature","θX;dis;in;ret",null,null,{"$f":"+E227","v":36.730213695566434},{"$f":"+F227","v":46.16291795934535},24.88225902154084]
["Flow rate","V'X;dis;in",null,null,{"$f":"+IFERROR(E245/(E237*__c_w*(E246-E247)),0)","v":0.10929562780609363},{"$f":"+IFERROR(F245/(F237*__c_w*(F246-F247)),0)","v":0.18078879442632048},{"$f":"+IFERROR(G245/(G237*__c_w*(G246-G247)),0)","v":4.7945430512979552E-2}]
["Tiem on","tX;dis;on",null,null,{"$f":"+E237","v":744},{"$f":"+F237","v":744},744]
["Node energy output","QX;nod;out",null,"kWh",null,{"$f":"SUM(E245:G245)","v":4853.1545033000657}]
["Node flow temperature","θX;nod;flw",null,"°C",null,{"$f":"MAX(E246:G246)","v":56.730213695566434},null,null,null,null,null,null,null,null,"Done before"]
["Node return temperature","θX;nod;ret",null,"°C",null,{"$f":"+F251-F250/(__c_w*(E248*E249+F248*F249+G248*G249))","v":40.094626439729531}]
["Required energy input","QX;nod;in",null,"kWh",null,{"$f":"+F250","v":4853.1545033000657},null,null,null,null,null,null,null,null,"No losses in the node"]
["Required operation time","tX;nod",null,"h",null,{"$f":"MAX(E249:G249)","v":744}]
["Input flow rate","V'X;nod;in",null,"m³/h",null,{"$f":"+F253/(__c_w*F254*(F251-F252))","v":0.3380298527453936}]
[]
["6.5.3.4 Heating distribution 123 and 4"]
["Required output","QH;dis;out",null,"kWh",null,{"$f":"+F253","v":4853.1545033000657},null,{"$f":"+H95","v":617.81735180055398}]
["Required operation time","tH;dis;ON",null,"h",null,{"$f":"+F254","v":744},null,{"$f":"+H88","v":744}]
["Output flow temperature","θH;dis;out;flw",null,"°C",null,{"$f":"+F251","v":56.730213695566434},null,{"$f":"+H229","v":56.730213695566434}]
["Output flow rate","V';dis;flw",null,"m³/h",null,{"$f":"+F255","v":0.3380298527453936},null,{"$f":"+H228","v":0.86206896551724432}]
["Return temperature","θH;dis;out;flw",null,"°C",null,{"$f":"+F252","v":40.094626439729531},null,{"$f":"+H230","v":55.899814029167842}]
[]
["Required output","QH;dis;out",null,"kWh",null,{"$f":"+F258","v":4853.1545033000657},null,{"$f":"+H258","v":617.81735180055398}]
["Flow temperature","θH;dis;flw",null,"°C",null,{"$f":"+F260","v":56.730213695566434},null,{"$f":"+H260","v":56.730213695566434}]
["Return temperature","θH;dis;ret",null,"°C",null,{"$f":"+F262","v":40.094626439729531},null,{"$f":"+H262","v":55.899814029167842}]
["Operation time","tH;dis,i;ON",null,null,null,{"$f":"+F259","v":744},null,{"$f":"+H259","v":744}]
[]
["Heating distribution  input","QH;dis;in",null,"kWh",null,{"$f":"+Method_input!E92","v":5064.1709086033661},null,{"$f":"+Method_input!E78","v":941.81459556376774}]
["Heating distribution  aux","W;dis;aux",null,"kWh",null,{"$f":"+Method_input!E93","v":29.76},null,{"$f":"+Method_input!E82","v":17.856000000000002},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E270:H270)","v":47.616}]
["Heating distribution  recoverable losses","QH;dis;ls;rbl;H",null,"kWh",null,{"$f":"+Method_input!E94","v":0},null,{"$f":"+Method_input!E86","v":97.266133128964157}]
["Heating distribution  losses where recoverable","TZH;dis;ls;rbl,hz",null,"-",null,{"$f":"+Method_input!E95","v":"None"},null,{"$f":"+Method_input!E90","v":"TZ3"},null,null,null,null,null,null,null,null,{"$f":"IF($E272=Q$4,$E271,0)+IF($F272=Q$4,$F271,0)+IF($G272=Q$4,$G271,0)+IF($H272=Q$4,$H271,0)+IF($I272=Q$4,$I271,0)+IF($J272=Q$4,$J271,0)+IF($K272=Q$4,$K271,0)","v":0},0,97.266133128964157,0]
[]
["Required heating system input by heating zone","QH;dis;in",null,null,null,{"$f":"+F269","v":5064.1709086033661},null,{"$f":"+H269","v":941.81459556376774}]
["Flow temperature","θH;dis;in;flw",null,null,null,{"$f":"+F260","v":56.730213695566434},null,{"$f":"+H226","v":56.730213695566434}]
["Return temperature","θH;dis;in;flw",null,null,null,{"$f":"+F262","v":40.094626439729531},null,{"$f":"+H227","v":55.899814029167842}]
["Flow rate","V'X;dis;in;flw",null,null,null,{"$f":"+IFERROR(F274/(F267*__c_w*(F275-F276)),0)","v":0.35272747763308959},null,{"$f":"+IFERROR(H274/(H267*__c_w*(H275-H276)),0)","v":1.3141572209658536},null,null,null,null,null,null,"Adjusting to include losses"]
[]
["Node 4"]
["Required outputs",null,null,"kWh",null,{"$f":"+F274","v":5064.1709086033661},null,{"$f":"+H274","v":941.81459556376774},null,{"$f":"+J63","v":280.87374999999997}]
["Required flow temperature",null,null,"°C",null,{"$f":"+F275","v":56.730213695566434},null,{"$f":"+H275","v":56.730213695566434},null,60]
["Required flow rate",null,null,"m³/h",null,{"$f":"+F277","v":0.35272747763308959},null,{"$f":"+H277","v":1.3141572209658536},null,{"$f":"+J280/(__c_w*10*J49)","v":3.2544696653689281E-2}]
["Operation time",null,null,"h",null,{"$f":"+F267","v":744},null,{"$f":"+H267","v":744},null,{"$f":"+J49","v":744}]
["Required input",null,null,"kWh",null,{"$f":"SUM(E280:L280)","v":6286.8592541671333}]
["Required operation time",null,null,"h",null,{"$f":"MAX(E283:L283)","v":744}]
["Input flow temperature",null,null,"°C",null,{"$f":"MAX(E281:L281)","v":60}]
["Input flow rate",null,null,"m³/h",null,{"$f":"SUM(E282:L282)","v":1.6994293952526325}]
["Return temperature",null,null,"°C",null,{"$f":"+F286-F284/(F287*__c_w*F285)","v":55.713531002542261}]
[]
["Generators, maximum output",null,null,null,"TOT",null,"G1","G2","G3…"]
["Flow temperature ",null,null,null,null,null,{"$f":"+F286","v":60},{"$f":"+F286","v":60},null,null,null,null,null,null,"Data ouput to module"]
["Operation time",null,null,null,null,null,{"$f":"+F285","v":744},{"$f":"+F285","v":744},null,null,null,null,null,null,"Data ouput to module"]
[]
["Maximum heat supplied","QHW;gen;out;max",null,"kWh",null,null,{"$f":"+Method_input!E102","v":4761.6000000000004},{"$f":"+Method_input!E103","v":8928}]
["6.7.1     Heat generator dispatch sequence "]
["Required heat ouput","QX;gen,j;out;req",null,null,null,null,{"$f":"+F284","v":6286.8592541671333},{"$f":"+G296-G297","v":1525.2592541671329}]
["Output distribution, sequential","QX;gen,j;out",null,null,null,null,{"$f":"MIN(G294,G296)","v":4761.6000000000004},{"$f":"MIN(H294,H296)","v":1525.2592541671329}]
["Output distribution, parallel","QX;gen,j;out",null,null,null,null,{"$f":"$G$296*G294/SUM($G$294:$L$294)","v":2186.7336536233511},{"$f":"$G$296*H294/SUM($G$294:$L$294)","v":4100.1256005437826}]
[null,1]
["Required heat ouput per generator","QHW;gen;out",null,null,null,null,{"$f":"INDEX(G297:G298,$B$299)","v":4761.6000000000004},{"$f":"INDEX(H297:H298,$B$299)","v":1525.2592541671329},null,null,null,null,null,"Doing selection between dispatch options"]
["Generation circuit flow temperature","θx;gen;cr;flw",null,null,null,null,{"$f":"+G291","v":60},{"$f":"+H291","v":60}]
["Generation circuit return temperature","θx;gen;cr;ret",null,null,null,null,{"$f":"+F288","v":55.713531002542261},{"$f":"+F288","v":55.713531002542261}]
["Generation circuit flow rate","V'X;gen;cr",null,null,null,null,{"$f":"+$F$287*G300/SUM($G$300:$L$300)","v":1.2871296590696371},{"$f":"+$F$287*H300/SUM($G$300:$L$300)","v":0.41229973618299531}]
["Generation circuit operation time","tX;gen;ON",null,null,null,null,{"$f":"+IF(G300>0,MAX($E$13:$E$14),0)","v":744},{"$f":"+IF(H300>0,MAX($E$13:$E$14),0)","v":744}]
[]
[]
["Type 1; direct circuit"]
["Operation time","tX;gen;ON",null,"h",null,null,{"$f":"+G304","v":744},{"$f":"+H304","v":744}]
["Required output","QX;gen;out",null,"kWh",null,null,{"$f":"+G300","v":4761.6000000000004},{"$f":"+H300","v":1525.2592541671329}]
["Generator flow rate","V'X;gen",null,null,null,null,{"$f":"+G303","v":1.2871296590696371},{"$f":"+H303","v":0.41229973618299531}]
["Generator flow temperature","θx;gen;flw",null,null,null,null,{"$f":"+G301","v":60},{"$f":"+H301","v":60}]
["Generator return temperature","θx;gen;ret",null,null,null,null,{"$f":"+G302","v":55.713531002542261},{"$f":"+H302","v":55.713531002542261}]
[]
["Type 2; independent flow rate"]
["Generator nominal power","ϕX;gen;out;n  ",null,"kW",null,null,{"$f":"+Method_input!E234","v":8},{"$f":"+Method_input!E235","v":15},null,null,null,null,null,null,"Input data"]
["Generator nominal Δθ","ΔθX;gen;w;n",null,"°C",null,null,{"$f":"+Method_input!E236","v":10},{"$f":"+Method_input!E237","v":10},null,null,null,null,null,null,"Input data"]
["Speed control","GEN_PMP_CTRL",null,null,null,null,{"$f":"Method_input!E238=1","v":false},{"$f":"Method_input!E239=1","v":false},null,null,null,null,null,"GEN_PMP_CTRL_NONE\nGEN_PMP_CTRL_DT_CONST","Input data"]
["Actual power","ϕX;gen;out ",null,"kW",null,null,{"$f":"G303*(G301-G302)*__c_w","v":6.400000000000003},{"$f":"H303*(H301-H302)*__c_w","v":2.0500796426977601}]
["Actual generator Δθ","Δθx;gen;eff",null,"°C",null,null,{"$f":"IF(G317,G316,G316*G318/G315)","v":8.0000000000000036},{"$f":"IF(H317,H316,H316*H318/H315)","v":1.3667197617985067}]
["Generator flow temperature","θx;gen;flw",null,"°C",null,null,{"$f":"IF(G319<(G301-G302),G301,G302+G319)","v":63.713531002542268},{"$f":"IF(H319<(H301-H302),H301,H302+H319)","v":60}]
["Generator return temperature","θx;gen;ret",null,"°C",null,null,{"$f":"IF(G319<(G301-G302),G301-G319,G302)","v":55.713531002542261},{"$f":"IF(H319<(H301-H302),H301-H319,H302)","v":58.633280238201493}]
["Generator flow rate","V'X;gen",null,"m³/h",null,null,{"$f":"+G318/(__c_w*G319)","v":0.68965517241379326},{"$f":"+H318/(__c_w*H319)","v":1.2931034482758621}]
[]
["Type 3; heat exchanger"]
[]
[]
[]
["Flow temperature","θx;gen;flw",null,"°C",null,null,{"$f":"+G320","v":63.713531002542268},{"$f":"+H320","v":60}]
["Return temperature","θx;gen;ret",null,"°C",null,null,{"$f":"+G321","v":55.713531002542261},{"$f":"+H321","v":58.633280238201493}]
[]
["Type 4; anti condensate pump"]
[]
[]
["Flow temperature","θx;gen;flw",null,"°C",null,null,{"$f":"+G328","v":63.713531002542268},{"$f":"+H328","v":60}]
["Return temperature","θx;gen;ret",null,"°C",null,null,{"$f":"+G329","v":55.713531002542261},58.633280238201493]
[]
["Circuit type",null,null,null,null,null,{"$f":"+Method_input!D176","v":1},{"$f":"+Method_input!D177","v":2}]
["Flow temperature","θx;gen;flw",null,"°C",null,null,{"$f":"CHOOSE(G337,G311,G320,G328,G334)","v":60},{"$f":"CHOOSE(H337,H311,H320,H328,H334)","v":60}]
["Return temperature","θx;gen;ret",null,"°C",null,null,{"$f":"CHOOSE(G337,G312,G321,G329,G335)","v":55.713531002542261},{"$f":"CHOOSE(H337,H312,H321,H329,H335)","v":58.633280238201493}]
["Generators calculation"]
["Required output","QX;gen;out",null,"kWh",null,null,{"$f":"+G300","v":4761.6000000000004},{"$f":"+H300","v":1525.2592541671329},null,null,null,null,null,null,"Data ouput to module"]
["Operation time","tX;gen;on",null,"h",null,null,{"$f":"+G304","v":744},{"$f":"+H304","v":744},null,null,null,null,null,null,"Data ouput to module"]
["Flow temperature","θx;gen;flw",null,"°C",null,null,{"$f":"+G338","v":60},{"$f":"+H338","v":60},null,null,null,null,null,null,"Data ouput to module"]
["Return temperature","θx;gen;ret",null,"°C",null,null,{"$f":"+G339","v":55.713531002542261},{"$f":"+H339","v":58.633280238201493},null,null,null,null,null,null,"Data ouput to module"]
[]
["Fuel input","EHW;gen;in",null,"kWh",null,null,{"$f":"+Method_input!E105","v":5012.21052631579},{"$f":"+Method_input!E106","v":1731.9042503237531},null,null,null,null,null,null,"Data input from module"]
["Auxiliary energy","EHW;gen;aux",null,"kWh",null,null,{"$f":"+Method_input!E107","v":150.3663157894737},{"$f":"+Method_input!E108","v":69.276170012950118},null,null,null,null,null,null,"Data input from module"]
["Generation recoverable losses","QW;gen,i;ls;rbl;H",null,"kWh",null,null,{"$f":"+Method_input!E109","v":100.24421052631587},{"$f":"+Method_input!E110","v":61.993498846986057},null,null,null,null,null,null,"Data input from module"]
["Generation where recoverable","TZgen,i;ls;rbl,hz",null,null,null,null,{"$f":"+Method_input!E111","v":"TZ3"},{"$f":"+Method_input!E112","v":"None"},null,null,null,null,null,null,"Data input from module",null,{"$f":"IF($E349=Q$4,$E348,0)+IF($F349=Q$4,$F348,0)+IF($G349=Q$4,$G348,0)+IF($H349=Q$4,$H348,0)+IF($I349=Q$4,$I348,0)+IF($J349=Q$4,$J348,0)+IF($K349=Q$4,$K348,0)","v":0},0,100.24421052631587,0]
[]
["Total fuel input","EHW;gen;in",null,"kWh",{"$f":"+G346+H346","v":6744.1147766395434}]
["Total generation auxiliary energy","WHW;gen;aux",null,"kWh",{"$f":"+G347+H347","v":219.64248580242383}]
["Heat output for heating","QH;gen;out",null,"kWh",{"$f":"+F280+H280","v":6005.9855041671335}]
["Heat output for dhw","QW;gen;out",null,"kWh",{"$f":"+J280","v":280.87374999999997}]
["Total heat ouput","QHW;gen;out",null,"kWh",{"$f":"+E353+E354","v":6286.8592541671333}]
["6,8 Generation input per energy carrier and per service "]
["Fuel input for heating ","EH;gen;in",null,"kWh",{"$f":"+E351*E353/E355","v":6442.8125315654888}]
["Fuel input for dhw","EH;gen;in",null,"kWh",{"$f":"+E351*E354/E355","v":301.30224507405575},null,null,null,null,null,null,null,null,null,null,"Recoverable losses",{"$f":"SUM(Q75:Q357)","v":178.98551090551283},{"$f":"SUM(R75:R357)","v":58.490612439067952},{"$f":"SUM(S75:S357)","v":206.07164714297434},{"$f":"SUM(T75:T357)","v":0}]
["6.9.2 distribution rule for dhw"]
["Generation auxiliary energy for dhw","WH;gen;aux",null,"kWh",{"$f":"+E352*E353/E355","v":209.8296673262098},null,null,null,null,null,null,null,null,null,null,"Auxiliary energy for heating",null,null,null,null,{"$f":"SUM(U16:U355)","v":85.155012381849247}]
["Generation auxiliary energy for dhw","WW;gen;aux",null,"kWh",{"$f":"+E352*E354/E355","v":9.8128184762140513},null,null,null,null,null,null,null,null,null,null,"Auxiliary energy for dhw",null,null,null,null,null,{"$f":"SUM(V17:V360)","v":68.096112500000004}]
[]
[]
["FINAL OUTPUT"]
["Fuel input for heating ","EH;gen;in",null,"kWh",{"$f":"+E357","v":6442.8125315654888}]
["Energy carrier for heating","H_FUEL",null,null,{"$f":"+Method_input!E179","v":"FUEL_GAS"}]
["Auxiliary energy for heating","WH;aux",null,"kWh",{"$f":"+E360+U360","v":294.98467970805905}]
["Fuel input for dhw","EH;gen;in",null,"kWh",{"$f":"+E358","v":301.30224507405575}]
["Energy carrier for dhw","H_FUEL",null,null,{"$f":"+Method_input!E179","v":"FUEL_GAS"}]
["Auxiliary energy for dhw","WH;aux",null,"kWh",{"$f":"+E361+V361","v":77.908930976214052}]
["Recoverable losses","QHW;ls;rbl",null,"kWh",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Recoverable losses, where recoverable","TZsto,i;ls;rbl,hz",null,"-","TZ1","TZ2","TZ3"]
[]
[]
[]
[]
[]
[]
[]
["6.X.X.X  Contribution by local heaters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local heaters give contributions in well defined heating system zones"]
["Required input by any local heater",null,null,"kWh",1,2,3,4,null,null,null,null,null,null,null,"Ask for contribution by stoves"]
["Heaters operation time","tH;cr,i;ON",null,"h",11,12,13,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equations for stove and/or air heater contribution !!!!"]
["Local air heaters, heat output to air","QH;gen,i;out",null,"kWh",{"$f":"+Method_input!E256","v":1},{"$f":"+Method_input!E257","v":2},{"$f":"+Method_input!E258","v":3},{"$f":"+Method_input!E259","v":0}]
["Supplied heat to water","QH;gen,i;out;w",null,"kWh",{"$f":"+Method_input!E260","v":0},{"$f":"+Method_input!E261","v":0.42857142857142855},{"$f":"+Method_input!E262","v":0},{"$f":"+Method_input!E263","v":0}]
["Auxiliary input","WH;gen,i;aux",null,"kWh",{"$f":"+Method_input!E264","v":4.1571428571428565E-2},{"$f":"+Method_input!E265","v":0},{"$f":"+Method_input!E266","v":0.1875},{"$f":"+Method_input!E267","v":0},null,null,null,null,null,null,null,"Apply here checking the controbution from any stove  and / or air heater"]
["Fuel input","EH;gen,i;in",null,"kWh",{"$f":"+Method_input!E268","v":1.3857142857142857},{"$f":"+Method_input!E269","v":2.8571428571428572},{"$f":"+Method_input!E270","v":3.75},{"$f":"+Method_input!E271","v":0}]
["Heater recoverable losses","QH;em,i;rbl",null,"kWh",{"$f":"+Method_input!E272","v":0},{"$f":"+Method_input!E273","v":0},{"$f":"+Method_input!E274","v":0.375},{"$f":"+Method_input!E275","v":0}]
["Heater losses where recoverable","TZH;em,i;ls;rbl",null,"kWh",{"$f":"+Method_input!E276","v":"TZ1"},{"$f":"+Method_input!E277","v":"TZ2"},{"$f":"+Method_input!E278","v":"TZ3"},{"$f":"+Method_input!E279","v":"TZ3"}]

{"sheet":"Method_output","index":8,"n_rows":118,"n_cols":9,"rows_kept":118,"cut":false,"hidden":false,"merged":[[57,1,60,1],[50,1,53,1],[46,1,49,1],[0,0,0,8],[28,0,29,0],[26,0,27,0],[42,1,45,1],[28,1,29,1],[24,0,25,0]]}
["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"]
["Fuel input for heating ","EH;gen;in",null,"kWh",{"$f":"+Method_calculation!E365","v":6442.8125315654888}]
["Energy carrier for heating","H_FUEL",null,null,{"$f":"+Method_calculation!E366","v":"FUEL_GAS"}]
["Auxiliary energy for heating","WH;aux",null,"kWh",{"$f":"+Method_calculation!E367","v":294.98467970805905}]
["Fuel input for dhw","EW;gen;in",null,"kWh",{"$f":"+Method_calculation!E368","v":301.30224507405575}]
["Energy carrier for dhw","H_FUEL",null,null,{"$f":"+Method_calculation!E369","v":"FUEL_GAS"}]
["Auxiliary energy for dhw","WW;aux",null,"kWh",{"$f":"+Method_calculation!E370","v":77.908930976214052}]
["Recoverable losses","QHW;ls;rbl;H,1",null,"kWh",{"$f":"+Method_calculation!E371","v":{"$error":"#REF!"}}]
["Recoverable losses","QHW;ls;rbl;H,2",null,"kWh",{"$f":"+Method_calculation!F371","v":{"$error":"#REF!"}}]
["Recoverable losses","QHW;ls;rbl;H,3",null,"kWh",{"$f":"+Method_calculation!G371","v":{"$error":"#REF!"}}]
["Recoverable losses, where recoverable","TZHW;ls;rbl,1",null,"kWh",{"$f":"+Method_calculation!E372","v":"TZ1"}]
["Recoverable losses, where recoverable","TZHW;ls;rbl,2",null,"kWh",{"$f":"+Method_calculation!F372","v":"TZ2"}]
["Recoverable losses, where recoverable","TZHW;ls;rbl,3",null,"kWh",{"$f":"+Method_calculation!G372","v":"TZ3"}]
[]
[]
[]
[]
[]
[]
["To dhw final distribution module"]
["Dhw final distribution output ","QW;dfin;out,i",null,"kWh",{"$f":"+Method_calculation!I21","v":248},null,null,null,"WZ1"]
[null,null,null,"kWh",{"$f":"+Method_calculation!K21","v":486},null,null,null,"WZ 2-3"]
["Dhw final distribution temperature ","ϑW;dfin,i",null,"°C",{"$f":"+Method_calculation!I22","v":60},null,null,null,"WZ1"]
[null,null,null,"°C",{"$f":"+Method_calculation!K22","v":50},null,null,null,"WZ 2-3"]
["Dhw tapping rate","ntap",null,"1/h",{"$f":"+Method_calculation!I23","v":0.125},null,null,null,"WZ1"]
[null,null,null,"1/h",{"$f":"+Method_calculation!K23","v":0.125},null,null,null,"WZ 2-3"]
["To dhw circulation loop module"]
["Circulation loop output","QW;dloop;out,i",null,"kWh",{"$f":"+Method_calculation!K32","v":518.36400000000003}]
["Circulation loop temperature","ϑW;dloop,j",null,"°C",{"$f":"+Method_calculation!K33","v":50}]
["Circulation loop temperature difference","ΔϑW;dloop,j",null,"°C",{"$f":"+Method_calculation!K34","v":2}]
["Circulation loop operation time","t;dloop;ON",null,"h",{"$f":"+Method_calculation!K35","v":744}]
["To dhw storage module"]
["Storage output",null,null,"kWh",{"$f":"+Method_calculation!J47","v":854.15599999999995}]
["Storage temperature",null,null,"°C",{"$f":"+Method_calculation!J48","v":60}]
["Storage operation time",null,null,"h",{"$f":"+Method_calculation!J49","v":744}]
[]
[]
["To heating emission module"]
["Emission system required output ","QH;em,i;out",null,"kWh",{"$f":"+Method_calculation!E87","v":1483.2952421052632}]
[null,null,null,"kWh",{"$f":"+Method_calculation!F87","v":1378.6981052631579}]
[null,null,null,"kWh",{"$f":"+Method_calculation!G87","v":1173.8529684210525}]
[null,null,null,"kWh",{"$f":"+Method_calculation!H87","v":586.92648421052627}]
["Emission system operation time","tH;em,i;ON",null,"h",{"$f":"+Method_calculation!E88","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!F88","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!G88","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!H88","v":744}]
["Emission load factor","βH,em",null,"h",{"$f":"+Method_calculation!E231","v":0.44303920015091497}]
[null,null,null,"h",{"$f":"+Method_calculation!F231","v":0.2058987612400176}]
[null,null,null,"h",{"$f":"+Method_calculation!G231","v":0.34852206011869419}]
[null,null,null,"h",{"$f":"+Method_calculation!H231","v":8.3039966639859408E-2}]
[]
["To distibution modules"]
["Circuits 1,2,3 and 4"]
["Distribution  system required output ","QH;dis,i;out",null,"kWh",{"$f":"+Method_calculation!E234","v":1648.1058245614036}]
[null,null,null,"kWh",{"$f":"+Method_calculation!F234","v":1531.8867836257309}]
[null,null,null,"kWh",{"$f":"+Method_calculation!G234","v":1296.5020636415425}]
[null,null,null,"kWh",{"$f":"+Method_calculation!H264","v":617.81735180055398}]
["Flow temperature","θH;dis,i;flw",null,"°C",{"$f":"+Method_calculation!$E$235","v":56.730213695566434}]
[null,null,null,"°C",{"$f":"+Method_calculation!$F$235","v":56.730213695566434}]
[null,null,null,"°C",{"$f":"+Method_calculation!$G$235","v":26.624869322134309}]
[null,null,null,"°C",{"$f":"+Method_calculation!H265","v":56.730213695566434}]
["Return temperature","tH;gen,i;ON",null,"°C",{"$f":"+Method_calculation!$E$236","v":36.730213695566434}]
[null,null,null,"°C",{"$f":"+Method_calculation!$F$236","v":46.16291795934535}]
[null,null,null,"°C",{"$f":"+Method_calculation!$G$236","v":24.88225902154084}]
[null,null,null,"°C",{"$f":"+Method_calculation!H266","v":55.899814029167842}]
["Operation time","tH;dis,i;ON",null,"h",{"$f":"+Method_calculation!$E$237","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!$F$237","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!$G$237","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!H267","v":744}]
["Circuit 123"]
["Required output","QH;dis,i;out",null,"kWh",{"$f":"+Method_calculation!F264","v":4853.1545033000657}]
["Flow temperature","θH;dis,i;flw",null,"°C",{"$f":"+Method_calculation!F265","v":56.730213695566434}]
["Return temperature","tH;gen,i;ON",null,"°C",{"$f":"+Method_calculation!F266","v":40.094626439729531}]
["Operation time","tH;dis,i;ON",null,"h",{"$f":"+Method_calculation!F267","v":744}]
[]
["Thermal solar"]
["Required output for dhw",null,null,"kWh",{"$f":"+Method_calculation!J57","v":898.79599999999994}]
[]
["Generators - 1st call"]
["Flow temperature",null,null,"°C",{"$f":"+Method_calculation!G291","v":60}]
[null,null,null,"°C",{"$f":"+Method_calculation!H291","v":60}]
["Operation time",null,null,"h",{"$f":"+Method_calculation!G292","v":744}]
[null,null,null,"h",{"$f":"+Method_calculation!H292","v":744}]
["Generators - 2nd call"]
["Required output",null,null,"kWh",{"$f":"+Method_calculation!G341","v":4761.6000000000004}]
[null,null,null,null,{"$f":"+Method_calculation!H341","v":1525.2592541671329}]
["Operation time",null,null,"h",{"$f":"+Method_calculation!G342","v":744}]
[null,null,null,null,{"$f":"+Method_calculation!H342","v":744}]
["Flow temperature",null,null,"°C",{"$f":"+Method_calculation!G343","v":60}]
[null,null,null,null,{"$f":"+Method_calculation!H343","v":60}]
["Return temperature",null,null,"°C",{"$f":"+Method_calculation!G344","v":55.713531002542261}]
[null,null,null,null,{"$f":"+Method_calculation!H344","v":58.633280238201493}]
[]
[]
[]
[]
[]
[]
["Other data"]
["Fuel type","LRH_FUEL","LRH_FUEL","List",{"$f":"+Method_calculation!#REF!","v":{"$error":"#REF!"}},"List","M3-1","YES","Needed to apply the right weighting factors"]
[]
[]
[]
[]
[]
["To local heaters module"]
["Required heater output","QH;gen,i;out",null,"kWh",{"$f":"+Method_calculation!E381","v":1}]
[null,null,null,"kWh",{"$f":"+Method_calculation!F381","v":2}]
[null,null,null,"kWh",{"$f":"+Method_calculation!G381","v":3}]
[null,null,null,"kWh",{"$f":"+Method_calculation!H381","v":4}]
["Operation time","tH;gen,i;ON",null,"h",{"$f":"+Method_calculation!E382","v":11}]
[null,null,null,"h",{"$f":"+Method_calculation!F382","v":12}]
[null,null,null,"h",{"$f":"+Method_calculation!G382","v":13}]
[null,null,null,"h",{"$f":"+Method_calculation!H382","v":14}]

{"sheet":"Other modules","index":9,"n_rows":165,"n_cols":14,"rows_kept":165,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,4,2,10]]}
["THIS IS A SPECIFIC SHEET\nHere the connected modules are simulated with linear equations"]
[]
["Description","Symbol","Software name","Unit","Values",null,null,null,null,null,null,"Formula ref","Formula","Notes"]
[null,null,null,null,"HZ 1","HZ 2","HZ 3","HZ 4","WZ 1","WZ 2","WZ 3"]
["FINAL DISTRIBUTION FOR DHW"]
["Dhw final distribution output ","QW;dfin;out,i",null,"kWh",null,null,null,null,{"$f":"+Method_output!E25","v":248},null,{"$f":"+Method_output!E26","v":486}]
["Dhw final distribution temperature","ϑW;dfin",null,"°C",null,null,null,null,{"$f":"+Method_calculation!I22","v":60},null,{"$f":"+Method_calculation!K22","v":50},null,null,"Data received"]
["calculation interval","tci",null,"h",null,null,null,null,{"$f":"+Method_input!E9","v":744},null,{"$f":"+Method_input!E9","v":744},null,null,"Assumed known"]
["Tapping frequency","ntap",null,"1/h",null,null,null,null,{"$f":"+Method_output!E30","v":0.125},null,{"$f":"+Method_output!E30","v":0.125},null,null,"Data received"]
["Water volume","V",null,"l",null,null,null,null,10,null,10,null,null,"Simulation"]
["Ribbon heating",null,null,"0…1",null,null,null,null,0,null,0,"\\"]
["Losses ",null,null,"kWh",null,null,null,null,{"$f":"+(I7-20)*I10*1.16*I8*I9/1000","v":43.151999999999994},null,{"$f":"+(K7-20)*K10*1.16*K8*K9/1000","v":32.363999999999997}]
["Fraction recoverable",null,null,"%",null,null,null,null,100,null,50]
["Heating zone",null,null,null,null,null,null,null,"TZ3",null,"TZ1"]
["Dhw final distribution loses","QW;dfin;i;ls;rbl;H",null,null,null,null,null,null,{"$f":"+I12*(1-I11)","v":43.151999999999994},null,{"$f":"+K12*(1-K11)","v":32.363999999999997}]
["Dhw final distribution input","QW;dfin;i;in",null,"kWh",null,null,null,null,{"$f":"+I15+I6","v":291.15199999999999},null,{"$f":"+K15+K6","v":518.36400000000003},null,"Do we come back with losses or input?\nWhat about recovery?","Data returned"]
["Dhw final distribution aux","QW;dfin;i;aux",null,"kWh",null,null,null,null,{"$f":"+I12*I11","v":0},null,{"$f":"+K12*K11","v":0},null,null,"Data returned"]
["Dhw final distribution recoverable","QW;dfin;i;ls;rbl;H",null,"kWh",null,null,null,null,{"$f":"+I12*I13/100","v":43.152000000000001},null,{"$f":"+K12*K13/100","v":16.181999999999999},null,null,"Data returned"]
["Dhw final distribution where recoverable","TZdfin,i;ls;rbl,hz",null,"-",null,null,null,null,{"$f":"+I14","v":"TZ3"},null,{"$f":"+K14","v":"TZ1"},null,null,"Data returned"]
["DHW Circulation loop"]
["Circulation loop output","QW;dloop;out,i",null,"kWh",null,null,null,null,null,null,{"$f":"+Method_output!E32","v":518.36400000000003},null,null,"Data received"]
["Circulation loop temperature","ϑW;dloop,j",null,"°C",null,null,null,null,null,null,{"$f":"+Method_output!E33","v":50},null,null,"Data received"]
["Circulation loop temperature difference","ΔϑW;dloop,j",null,"°C",null,null,null,null,null,null,{"$f":"+Method_output!E34","v":2},null,null,"Data received"]
["Circulation loop operation time","t;dloop;ON",null,"h",null,null,null,null,null,null,{"$f":"+Method_output!E35","v":744},null,null,"Data received"]
["Room temperature",null,null,"°C",null,null,null,null,null,null,20]
["Heat loss coefficient",null,null,"W/K",null,null,null,null,null,null,2.5]
["Fraction recoverable",null,null,"%",null,null,null,null,null,null,20]
["Heating zone",null,null,null,null,null,null,null,null,null,"Any"]
["Pump power",null,null,"W",null,null,null,null,null,null,50]
["Fraction auxiliary recoverable",null,null,"%",null,null,null,null,null,null,80]
["Dhw circulation loop losses","QW;dloop;i;ls",null,"kWh",null,null,null,null,null,null,{"$f":"+(K22-K25/2)*K24*K26/1000","v":74.400000000000006}]
["Dhw circulation loop input","QW;dloop;i;in",null,"kWh",null,null,null,null,null,null,{"$f":"+K21+K31-K33*K30/100","v":563.00400000000002},null,null,"Data returned"]
["Dhw circulation loop aux","QW;dloop;i;aux",null,"kWh",null,null,null,null,null,null,{"$f":"+K29*K24/1000","v":37.200000000000003},null,null,"Data returned"]
["Dhw circulation loop recoverable losses","QW;dloop;i;ls;rbl;H",null,"kWh",null,null,null,null,null,null,{"$f":"+K31*K27/100","v":14.88},null,null,"Data returned"]
["Dhw circulation loop where recoverable","TZdloop,i;ls;rbl",null,"-",null,null,null,null,null,null,{"$f":"+K28","v":"Any"},null,null,"Data returned"]
["Dhw storage"]
["Storge  output","QW;sto,i;out",null,"kWh",null,null,null,null,null,{"$f":"+Method_output!E37","v":854.15599999999995},null,null,null,"Data received"]
["Set storage temperature","ϑW;sto",null,"°C",null,null,null,null,null,{"$f":"+Method_output!E38","v":60},null,null,null,"Data received"]
["Storage operation time","tci",null,"h",null,null,null,null,null,{"$f":"+Method_output!E39","v":744}]
["Room temperature",null,null,"°C",null,null,null,null,null,20,null,null,null,"Actual module: use only equation 30"]
["Storage heat loss coefficient","Hsto",null,"W/K",null,null,null,null,null,1.5]
["B factor of the room where storage is located",null,null,null,null,null,null,null,null,0.5,null,null,null,"1 = external…0 = internal"]
["Location of storage",null,null,null,null,null,null,null,null,"TZ2"]
["Auxiliary average power",null,null,"W/K",null,null,null,null,null,0]
["Storage losses","Qw;sto;ls",null,"kWh",null,null,null,null,null,{"$f":"+J41*J39*(J38-J40)/1000","v":44.64}]
["Storage input","QW;dloop;i;in",null,"kWh",null,null,null,null,null,{"$f":"+J37+J45-J44*0.8","v":898.79599999999994},null,null,null,"Data returned"]
["Auxiliary energy","Qw;sto;laux",null,"kWh",null,null,null,null,null,{"$f":"+J44*J39/1000","v":0},null,null,null,"Data returned"]
["Dhw storage rcoverable losses","QW;dloop;i;ls;rbl;H",null,"kWh",null,null,null,null,null,{"$f":"+J45*(1-J42)","v":22.32},null,null,null,"Data returned"]
["Dhw storage losses where recoverable","TZdloop,i;ls;rbl,hz",null,"-",null,null,null,null,null,{"$f":"+J43","v":"TZ2"},null,null,null,"Data returned"]
[]
[]
["Heating emission and control"]
["Emission system required output ","QH;em,i;out",null,"kWh",{"$f":"+Method_output!E43","v":1483.2952421052632},{"$f":"+Method_output!E44","v":1378.6981052631579},{"$f":"+Method_output!E45","v":1173.8529684210525},{"$f":"+Method_output!E46","v":586.92648421052627},null,null,null,null,null,"Data received"]
["Emission system operation time","tH;em,i;ON",null,"h",{"$f":"+Method_output!E47","v":744},{"$f":"+Method_output!E48","v":744},{"$f":"+Method_output!E49","v":744},{"$f":"+Method_output!E50","v":744}]
["Emission load factor","βH,em  ",null,null,{"$f":"+Method_output!E51","v":0.44303920015091497},{"$f":"+Method_output!E52","v":0.2058987612400176},{"$f":"+Method_output!E53","v":0.34852206011869419},{"$f":"+Method_output!E54","v":8.3039966639859408E-2}]
["Fans operation time","tH;cr,i;ON",null,"h",{"$f":"+E54*E55","v":329.62116491228073},{"$f":"+F54*F55","v":153.18867836257309},259.30041272830846,61.781735180055399]
["Emission efficiency",null,null,"%",90,90,90,95]
["Auxiliary power",null,null,"W",0,0,30,0]
["Auxiliary recovery factor",null,null,"%",100,100,100,100]
["Where recoverable",null,null,null,"TZ1","TZ2","TZ3","TZ3"]
["Emission losses","QH;em,i;ls",null,"kWh",{"$f":"+E53*(100-E57)/E57","v":164.81058245614037},{"$f":"+F53*(100-F57)/F57","v":153.18867836257311},130.42810760233917,30.8908675900277]
["Emission  input","QH;em,i;in",null,"kWh",{"$f":"+E53+E61-E63*E59/100","v":1648.1058245614036},{"$f":"+F53+F61-F63*F59/100","v":1531.8867836257309},1296.5020636415425,617.81735180055398,null,null,null,null,null,"Data returned"]
["Emission  aux","WH;em,i;aux",null,"kWh",{"$f":"+E56*E58/1000","v":0},{"$f":"+F56*F58/1000","v":0},7.7790123818492543,0,null,null,null,null,null,"Data returned"]
["Emission recoverable losses","QH;em,i;ls;rbl;H",null,"kWh",0,0,0,0,null,null,null,null,"No recoverable losses","Data returned"]
["Emission recoverable losses where recoverable","TZH;em,i;ls;rbl,hz",null,"-",{"$f":"+E60","v":"TZ1"},{"$f":"+F60","v":"TZ2"},"TZ3","TZ3",null,null,null,null,null,"Data returned"]
["Heating distribution circuits 1, 2, 3 and 4",null,null,null,"HZ1","HZ2","HZ3","HZ4"]
["Distribution system required output ","QH;dis,i;out",null,"kWh",{"$f":"+Method_output!E58","v":1648.1058245614036},{"$f":"+Method_output!E59","v":1531.8867836257309},{"$f":"+Method_output!E60","v":1296.5020636415425},{"$f":"+Method_output!E61","v":617.81735180055398},null,null,null,null,null,"Data received"]
["Distribution flow temperature","ϑH;dis,i;flw",null,"°C",{"$f":"+Method_output!$E$62","v":56.730213695566434},{"$f":"+Method_output!$E$63","v":56.730213695566434},{"$f":"+Method_output!$E$64","v":26.624869322134309},{"$f":"+Method_output!$E$65","v":56.730213695566434},null,null,null,null,null,"Data received"]
["Distribution return temperature","ϑH;dis,i;ret",null,"°C",{"$f":"+Method_output!$E$66","v":36.730213695566434},{"$f":"+Method_output!$E$67","v":46.16291795934535},{"$f":"+Method_output!$E$68","v":24.88225902154084},{"$f":"+Method_output!$E$69","v":55.899814029167842},null,null,null,null,null,"Data received"]
["Distribution operation time","t;dis;ON",null,"h",{"$f":"+Method_output!$E$70","v":744},{"$f":"+Method_output!$E$71","v":744},{"$f":"+Method_output!$E$72","v":744},{"$f":"+Method_output!$E$73","v":744},null,null,null,null,null,"Data received"]
["Room temperature",null,null,"°C",20,20,20,20]
["Heat loss coefficient",null,null,"W/K",12,5,5,12]
["Fraction recoverable",null,null,"%",75,50,40,30]
["Heating zone",null,null,null,"TZ1","TZ2","TZ3","TZ3"]
["Pump power",null,null,"W",30,10,10,30]
["Recovery factor of auxiliary energy",null,null,"%",80,80,80,80]
["Distribution losses","QW;dis;i;ls",null,"kWh",{"$f":"+((E68+E69)/2-E71)*E72*E70/1000","v":238.6473478740171},{"$f":"+((F68+F69)/2-F71)*F72*F70/1000","v":116.9812248781359},21.403258719235776,324.22044376321384]
["Distribution   input","QW;dis;i;in",null,"kWh",{"$f":"+E67+E77-E75*E70/100000","v":1886.5299724354209},{"$f":"+F67+F77-F75*F70/100000","v":1648.7936085038668},1317.8309223607782,941.81459556376774,null,null,null,null,null,"Data returned"]
["Distribution aux","QW;dis,i;aux",null,"kWh",{"$f":"+E75*E70*0.8/1000","v":17.856000000000002},{"$f":"+F75*F70*0.8/1000","v":5.952},5.952,17.856000000000002,null,null,null,null,null,"Data returned"]
["Distribution recoverable losses","QW;dis,i;ls;rbl;H",null,"kWh",{"$f":"+E77*E73/100","v":178.98551090551283},{"$f":"+F77*F73/100","v":58.490612439067952},8.5613034876943104,97.266133128964157,null,null,null,null,null,"Data returned"]
["Distribution where recoverable","TZdis,i;ls;rbl,hz",null,"-",{"$f":"+E74","v":"TZ1"},{"$f":"+F74","v":"TZ2"},"TZ3","TZ3",null,null,null,null,null,"Data returned"]
[]
["Heating distribution circuit 123"]
["Distribution system required output ","QH;dis,i;out",null,"kWh",null,{"$f":"+Method_output!E75","v":4853.1545033000657},null,null,null,null,null,null,null,"Data received"]
["Distribution flow temperature","ϑH;dis,i;flw",null,"°C",null,{"$f":"+Method_output!E76","v":56.730213695566434},null,null,null,null,null,null,null,"Data received"]
["Distribution return temperature","ϑH;dis,i;ret",null,"°C",null,{"$f":"+Method_output!E77","v":40.094626439729531},null,null,null,null,null,null,null,"Data received"]
["Distribution operation time","t;dis;ON",null,"h",null,{"$f":"+Method_output!E78","v":744},null,null,null,null,null,null,null,"Data received"]
["Room temperature",null,null,"°C",null,20]
["Heat loss coefficient",null,null,"W/K",null,10]
["Fraction recoverable",null,null,"%",null,0]
["Thermal zone where recoverable",null,null,null,null,"None"]
["Pump power",null,null,"W",null,50]
["Recovery factor of auxiliary energy",null,null,"%",null,80]
["Distribution losses","QW;dis;i;ls",null,"kWh",null,{"$f":"+((F85+F86)/2-F88)*F89*F87/1000","v":211.38840530330103}]
["Distribution   input","QW;dis;i;in",null,"kWh",null,{"$f":"+F94+F84-F92*F87/100000","v":5064.1709086033661},null,null,null,null,null,null,null,"Data returned"]
["Distribution aux","QW;dis,i;aux",null,"kWh",null,{"$f":"+F92*F87*0.8/1000","v":29.76},null,null,null,null,null,null,null,"Data returned"]
["Distribution recoverable losses","QW;dis,i;ls;rbl;H",null,"kWh",null,{"$f":"+F94*F90/100","v":0},null,null,null,null,null,null,null,"Data returned"]
["Distribution where recoverable","TZdis,i;ls;rbl,hz",null,"-",null,{"$f":"+F91","v":"None"},null,null,null,null,null,null,null,"Data returned"]
["THERMAL SOLAR"]
["Required output for dhw",null,null,"kWh",null,null,null,null,null,{"$f":"+Method_output!E81","v":898.79599999999994}]
["External temperature",null,null,"°C",null,null,null,null,null,{"$f":"+Method_input!E26","v":17}]
["Min for thermal solar",null,null,"°C",null,null,null,null,null,6]
["max for thermal soalr",null,null,"°C",null,null,null,null,null,22]
["Fraction auxiliary",null,null,"%",null,null,null,null,null,5]
["Thermal zone where recoverable",null,null,null,null,null,null,null,null,"None"]
["Percent coverage",null,null,"%",null,null,null,null,null,{"$f":"MIN(MAX(100*(J101-J102)/(J103-J102),0),100)","v":68.75}]
["Output to distribution",null,null,"kWh",null,null,null,null,null,{"$f":"+J100*J106/100","v":617.92224999999996}]
["Auxiliary energy",null,null,"kWh",null,null,null,null,null,{"$f":"+J107*J104/100","v":30.896112500000001}]
["Distribution recoverable losses","QW;dis,i;ls;rbl;H",null,"kWh",null,null,null,null,null,0,null,null,null,"Data returned"]
["Distribution where recoverable","TZdis,i;ls;rbl,hz",null,"-",null,null,null,null,null,{"$f":"+J105","v":"None"},null,null,null,"Data returned"]
[]
["GENERATOR, STEP 1",null,null,null,null,"TOT","G1","G2"]
["Flow temperature",null,null,"°C",null,null,{"$f":"+Method_output!E84","v":60},{"$f":"+Method_output!E85","v":60}]
["Operation time",null,null,"h",null,null,{"$f":"+Method_output!E86","v":744},{"$f":"+Method_output!E87","v":744}]
["Full load power",null,null,null,null,null,{"$f":"+Method_input!E234","v":8},{"$f":"+Method_input!E235","v":15}]
["Maximum monthlky load",null,null,"%",null,null,80,80]
["Maximum output",null,null,"kWh",null,null,{"$f":"+G115*G114*G116/100","v":4761.6000000000004},{"$f":"+H115*H114*H116/100","v":8928}]
[]
["GENERATOR, STEP 2",null,null,null,null,"TOT","G1","G2"]
["Required output",null,null,"kWh",null,null,{"$f":"+Method_output!E89","v":4761.6000000000004},{"$f":"+Method_output!E90","v":1525.2592541671329}]
["Operation time",null,null,"h",null,null,{"$f":"+Method_output!E91","v":744},{"$f":"+Method_output!E92","v":744}]
["Flow temperature",null,null,"°C",null,null,{"$f":"+Method_output!E93","v":60},{"$f":"+Method_output!E94","v":60}]
["Return temperature",null,null,"°C",null,null,{"$f":"+Method_output!E95","v":55.713531002542261},{"$f":"+Method_output!E96","v":58.633280238201493}]
["Efficiency",null,null,"%",null,null,{"$f":"IF(G123<50,110-(G123-20)*0.5,95)","v":95},{"$f":"92-(AVERAGE(H122:H123)-20)/10","v":88.068335988089927}]
["Auxiliary",null,null,"%",null,null,3,4]
["Fraction recoverable",null,null,"%",null,null,40,30]
["Heating zone",null,null,null,null,null,"TZ3","None"]
["Fuel input",null,null,"kWh",null,null,{"$f":"+G120*100/G124","v":5012.21052631579},{"$f":"+H120*100/H124","v":1731.9042503237531}]
["Auxiliary energy",null,null,"kWh",null,null,{"$f":"+G128*G125/100","v":150.3663157894737},{"$f":"+H128*H125/100","v":69.276170012950118}]
["Generation recoverable losses","QW;gen,i;ls;rbl;H",null,"kWh",null,null,{"$f":"+MAX(G128-G120,0)*G126/100","v":100.24421052631587},{"$f":"+MAX(H128-H120,0)*H126/100","v":61.993498846986057}]
["Generation where recoverable","TZgen,i;ls;rbl,hz",null,null,null,null,{"$f":"+G127","v":"TZ3"},{"$f":"+H127","v":"None"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Spare lines for local air heaters"]
[]
[]
["Local heaters"]
["Required heater output","QH;gen,i;out",null,"kWh",{"$f":"+Method_output!E111","v":1},{"$f":"+Method_output!E112","v":2},{"$f":"+Method_output!E113","v":3},{"$f":"+Method_output!E114","v":4},null,null,null,null,null,"Data received"]
["Operation time","tH;gen,i;ON",null,"h",{"$f":"+Method_output!E115","v":11},{"$f":"+Method_output!E116","v":12},{"$f":"+Method_output!E117","v":13},{"$f":"+Method_output!E118","v":14}]
["Local heater efficiency to air",null,null,"%",70,70,80,70]
["Local heater efficiency to water",null,null,"%",0,15,0,0,null,null,null,null,null,"If non zero, triggers a contribution to water"]
["Maximum power",null,null,"kW",2,2,2,0,null,null,null,null,null,"If zero, cancels heater effect"]
["Auxiliary energy use (% of input)",null,null,"%",3,0,5,0,null,null,null,null,null,"Auxiliary as percentage of input"]
["Auxiliary recovery",null,null,"%",100,100,0,100,null,null,null,null,null,"Recoverable part of auxiliary, if not altready accounted as reduction of input"]
["Heat loss recoverability factor",null,null,"%",0,0,50,0,null,null,null,null,null,"Recoverable part of losses, if not altready accounted as reduction of input"]
["Where recoverable",null,null,null,"TZ1","TZ2","TZ3","TZ3"]
["Supplied heat","QH;gen,i;out",null,"kWh",{"$f":"IF(E155>0,MIN(E151,E152*E155*E153/100),0)","v":1},{"$f":"IF(F155>0,MIN(F151,F152*F155*F153/100),0)","v":2},3,0,null,null,null,null,null,"Data returned"]
["Supplied heat to water","QH;gen,i;out;w",null,"kWh",{"$f":"IF(E160>0,E160*E154/E153,0)","v":0},{"$f":"IF(F160>0,F160*F154/F153,0)","v":0.42857142857142855},0,0,null,null,null,null,null,"Data returned"]
["Auxiliary input","WH;gen,i;aux",null,"kWh",{"$f":"+E163*E156/100","v":4.1571428571428565E-2},{"$f":"+F163*F156/100","v":0},0.1875,0,null,null,null,null,null,"Data returned"]
["Fuel input","EH;gen,i;in",null,"kWh",{"$f":"+E160*(100/E153)*(1-E156*E157/10000)","v":1.3857142857142857},{"$f":"+F160*(100/F153)*(1-F156*F157/10000)","v":2.8571428571428572},3.75,0,null,null,null,null,null,"Data returned"]
["Heater recoverable losses","QH;em,i;rbl",null,"kWh",{"$f":"+(E163-E161-E160)*E158/100","v":0},{"$f":"+(F163-F161-F160)*F158/100","v":0},0.375,0,null,null,null,null,null,"Data returned"]
["Heater losses where recoverable","TZH;em,i;ls;rbl",null,"-",{"$f":"+E159","v":"TZ1"},{"$f":"+F159","v":"TZ2"},"TZ3","TZ3",null,null,null,null,null,"Data returned"]

{"sheet":"Output_series","index":10,"n_rows":29,"n_cols":13,"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,12]
[]
["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,"Fuel input for heating ","Energy carrier for heating","Auxiliary energy for heating","Fuel input for dhw","Energy carrier for dhw","Auxiliary energy for dhw","Recoverable losses","Recoverable losses","Recoverable losses","Recoverable losses, where recoverable","Recoverable losses, where recoverable","Recoverable losses, where recoverable"]
[null,"kWh",null,"kWh","kWh",null,"kWh","kWh","kWh","kWh","kWh","kWh","kWh"]
["Symbol","EH;gen;in","H_FUEL","WH;aux","EW;gen;in","H_FUEL","WW;aux","QHW;ls;rbl;H,1","QHW;ls;rbl;H,2","QHW;ls;rbl;H,3","TZHW;ls;rbl,1","TZHW;ls;rbl,2","TZHW;ls;rbl,3"]
["Destination"]
["Time stamp",null,null,"VALUES"]
[1,7828.5235846112082,"FUEL_GAS",349.33859331504215,976.88933988310941,"FUEL_GAS",70.714931437604108,206.23054475829406,69.578770015048292,242.08743001330839,"TZ1","TZ2","TZ3"]
[2,6147.720398241463,"FUEL_GAS",279.20911527882299,876.45243289840448,"FUEL_GAS",63.009263429949023,165.84017206764756,57.775132767740608,208.06307547591882,"TZ1","TZ2","TZ3"]
[3,3300.9021768084576,"FUEL_GAS",178.52982587581673,946.10104953702501,"FUEL_GAS",68.391768986110776,109.52381334254103,45.44917311351621,176.2024613437041,"TZ1","TZ2","TZ3"]
[4,1892.3924423811836,"FUEL_GAS",132.74657169130566,915.24210526316904,"FUEL_GAS",79.760013157895159,75.037249885037028,36.176617722796706,137.00942288013624,"TZ1","TZ2","TZ3"]
[5,0,"FUEL_GAS",0,946.10105263157891,"FUEL_GAS",96.479144078947371,0,0,18.922021052631589,"TZ1","TZ2","TZ3"]
[6,0,"FUEL_GAS",0,915.2421052631579,"FUEL_GAS",106.93126315789473,0,0,18.304842105263152,"TZ1","TZ2","TZ3"]
[7,0,"FUEL_GAS",0,946.10105263157891,"FUEL_GAS",110.52283157894738,0,0,18.922021052631589,"TZ1","TZ2","TZ3"]
[8,0,"FUEL_GAS",0,946.10105263157891,"FUEL_GAS",110.52283157894738,0,0,18.922021052631589,"TZ1","TZ2","TZ3"]
[9,0,"FUEL_GAS",0,915.2421052631579,"FUEL_GAS",98.779888157894732,0,0,18.304842105263152,"TZ1","TZ2","TZ3"]
[10,3217.8211829874522,"FUEL_GAS",176.68994333087102,946.10106386783673,"FUEL_GAS",88.052931916035106,87.300858482911451,39.849806106615659,168.5354697606513,"TZ1","TZ2","TZ3"]
[11,5143.1550298964121,"FUEL_GAS",242.32483094786738,929.11538004313024,"FUEL_GAS",71.177096576390198,139.54444437061105,52.395225004457409,202.97612933126007,"TZ1","TZ2","TZ3"]
[12,6574.9285116156834,"FUEL_GAS",299.77139631579803,970.09710128898439,"FUEL_GAS",69.559464705503387,178.98551090551283,62.815926889586009,227.83118338274812,"TZ1","TZ2","TZ3"]

{"sheet":"History","index":11,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2014-11-29","First version for I/O check"]
[null,"2016-04-24","Completed scheme","Including temperature calculation"]

{"sheet":"Control_Options","index":12,"n_rows":41,"n_cols":4,"rows_kept":41,"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(C39:C41,A34)","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]

{"sheet":"Product_descriptive_data","index":13,"n_rows":45,"n_cols":3,"rows_kept":45,"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)"]
[]
["Clause"]
[5,"LRH_TYPE",{"$f":"INDEX(C34:C45,A32)","v":"LRH_TYPE_"}]
["Description","Specifier, parts","Specifier, complete"]
["Overhead luminous radiant heater","LUM",{"$f":"$B$32&\"_\"&B34","v":"LRH_TYPE_LUM"}]
["Overhead radiant tube heater unflued","RADNOFLUE",{"$f":"$B$32&\"_\"&B35","v":"LRH_TYPE_RADNOFLUE"}]
["Overhead radiant tube heater flued","RADFLUE","LRH_TYPE_RADFLUE"]
["Air heater, ON-OFF",null,"LRH_TYPE_"]
["Air heater modulating output and combustion air",null,"LRH_TYPE_"]
["Air heater modulating output and not combustion air",null,"LRH_TYPE_"]
["Stove",null,"LRH_TYPE_"]
["Example n°1",null,"LRH_TYPE_"]
["Example n°2",null,"LRH_TYPE_"]
["Example n°3",null,"LRH_TYPE_"]
["Example n°4",null,"LRH_TYPE_"]
["Last type",null,"LRH_TYPE_"]

{"sheet":"Data_catalogue_example","index":14,"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":15,"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":16,"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!C32","v":"LRH_TYPE_"},"Y/N","Local","NO"]
["Fuel","BLR_FUEL",null,{"$f":"+Product_descriptive_data!#REF!","v":{"$error":"#REF!"}},"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!#REF!","v":{"$error":"#REF!"}},"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"]