{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["INFO","Simplified_input_correlation","Product_descriptive_data","Product_tech_data","Process_design_data","Data_catalogue_example","Ground preh+prec","Input_series","Method_input","Method_calculation","Method_output","Output_series","Graphs","Greek_to_soft","Symbols","Subs_building","Subs_system","Subs_del_EP","Subs_other","History"],"not_rendered":{"charts":31,"images":163,"macros":1,"external_links":0,"defined_names":14,"comments":9,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INFO","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["\nDISCLAIMER:\n• This spreadsheet has been developed in the framework of the preparation and revision of the set of EN or ISO standards on the energy performance of buildings, to support the European \"Energy Performance of Buildings Directive\" recast (EPBD-recast, directive 2010/31/EU). \n• It is meant for use by  CEN and ISO technical committee(s) and the working group(s) working on the preparation or revision of the EPB-standard to which this spreadsheet applies. The spreadsheet supports checking  that all equations in the developed standard are consistent and can be linked with other relevant standards. It is not meant to perform a full or partial energy performance calculation.\n• The spreadsheet supports the expert user of the standards, in particular those who want to review the content of the standard and those who want to translate the standard to a software, to understand the correct interpretation of the equations and calculation steps in the standard.\n• Although it has been developed with care, neither the technical committee(s), nor the working group(s) and experts related to the EPB- standard to which this spreadsheet applies warrant that the calculations and procedures in this spreadsheet are free of errors. The technical committees as well as the working groups and their respective members expressly disclaim any liability or responsibility arising from use of this spreadsheet, or any consequences thereof. Any responsibility arising from the use of this spreadsheet lies with the user."]
["DRAFT VERSION:\n• As long as the associated EPB standard or any of the other EPB standards to which it is directly linked are in a draft stage, this spreadsheet is also a draft version only."]
["WARNINGS: \n• Note that the spreadsheet may not allow testing all calculation options that are possible according to the standard to which it applies. This remark applies in particular but not only to limitations on the number instances of a variable that can be considered. \n• In case of differences, the standard should be regarded as the reference, not the spreadsheet. However, during the standard's drafting phase, shortcomings in the draft standard may have been detected and dealt with in the spreadsheets (ideally, such differences are marked).\n• Note also that these spreadsheets are purely intended for testing and demonstration and therefore not aiming to be user friendly or to be protected against wrong or improper use. \n"]
["TERMS OF USE:\n• The user is not allowed to redistribute a modified version of this spreadsheet.\n• The author(s) would appreciate your feed back on the spreadsheet via the comment sheets for the associated draft standard to be prepared by the national standards bodies during enquiry of the draft standard(s),\n"]
["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."]
["Greek_to_soft\nThis sheet includes the correspondence table between greek letters and software language coding of variables"]
["Symbols\nThis sheet includes common symbols for reference."]
["Subs buildings\nThis sheet includes relevant common symbols for the building domain"]
["Subs systems\nThis sheet includes relevant common symbols for the technical systems domain"]
["Subs del_EP\nThis sheet includes relevant common symbols for the assessment boundary energy flows"]
["Subs others\nThis sheet includes relevant common symbols for other general purposes (typically futher levels appended to previously defined subscripts)"]
["Hostory \nChanges in this sheet according to revisions"]

{"sheet":"Simplified_input_correlation","index":1,"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, if any"]
[]
[]
["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",{"$f":"+D16","v":139.5},"0...∞"]
["diameter of shafts","dS","m",null,"0…0,2"]
["Length of base ring","lB","m",{"$f":"+D17","v":255},"0...∞"]
["diameter of base ring","dB","m",null,"0…0,2"]

{"sheet":"Product_descriptive_data","index":2,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Example of descriptive data.\nIn a simple structure, this can be connected directly to the \"method_input\" sheet where this data is required.\nIn this example spreadsheet the \"Method_input\" is linked to the \"data_catalogue\"."]
[]
[]
[]
[]
[" Product descriptive data (qualitative)"]
[]
["Boiler type, condensing / non condensing"]
[3,"BLR_TYPE",{"$f":"INDEX(C11:C13,A9)","v":"BLR_TYPE_STND"}]
[]
["Condensing",null,"BLR_TYPE_COND"]
["Low temperature",null,"BLR_TYPE_LTMP"]
["Standard",null,"BLR_TYPE_STND"]
[]
[]
["Boiler use"]
[1,"BLR_USE",{"$f":"INDEX(C19:C22,A17)","v":"BLR_USE_H"}]
[]
["Heating",null,"BLR_USE_H"]
["Domestic hot water",null,"BLR_USE_W"]
["Cooling",null,"BLR_USE_C"]
["All",null,"BLR_USE_ALL"]
[]
[]
["Fuel"]
[1,"BLR_FUEL",{"$f":"INDEX(C28:C31,A26)","v":"BLR_FUEL_GAS"}]
[]
["Gas",null,"BLR_FUEL_GAS"]
["LPG",null,"BLR_FUEL_LPG"]
["Oil",null,"BLR_FUEL_OIL"]
["Biomass",null,"BLR_FUEL_BM"]
[]
[]
["CE Marking"]
[1,"BLR_CE",{"$f":"INDEX(C37:C38,A35)","v":"BLR_DATA_YES"}]
[]
["Boiler is marked CE",null,"BLR_DATA_YES"]
["Boiler is NOT marked CE",null,"BLR_DATA_NO"]
[]
[]
["Burner control type"]
[1,"BLR_CTRL_POW",{"$f":"INDEX(C44:C46,A42)","v":"BLR_CTRL_POW_ONOF"}]
[]
["Single stage control (ON-OFF)",null,"BLR_CTRL_POW_ONOF"]
["Stepped control ",null,"BLR_CTRL_POW_STEP"]
["Modulating control",null,"BLR_CTRL_POW_MOD"]

{"sheet":"Product_tech_data","index":3,"n_rows":140,"n_cols":10,"rows_kept":140,"cut":false,"hidden":false,"merged":[[0,0,0,3],[88,1,88,3],[88,4,88,6],[88,7,88,9]]}
["EXAMPLE OF A SHEET WITH DEFAULT INPUT\nCreate here a simulation of each default data formula given in annex A of the standard.\nOptionally connect the selected values to the detailed input data selection sheet  (detailed input)"]
[]
[]
[]
["A.1.2.1    Generator output at full load;","ФPn ","kW",60]
[]
[]
["A.1.2.2      Generator efficiency at full load","ηgnr;Pn ","%",{"$f":"+IF(D10<D29,D27+D28*LOG10(D10),D27+D28*LOG10(D29))","v":88.556302500767288}]
["Known input"]
["Generator output at full load;","ФPn ","kW",{"$f":"+D5","v":60}]
[]
["Base formula"]
[]
["Data table"]
["Data",null," c1"," c2"]
["Unit",null,"%","%"]
["Gas standard boiler",null,85,2]
["Gas low temperature boiler",null,88.5,1.5]
["Gas condensing boiler",null,92,1]
["Oil standard boiler",null,85,2]
["Oil low temperature boiler",null,88,1.5]
["Oil condensing boiler",null,92,1]
["My boiler with fixed value (c2 = 0)",null,91,0]
["Last boiler ",null,50,0]
["Your selection"]
["Selection index",null,null,1]
[" c1",null,"%",{"$f":"INDEX(C17:C24,D26)","v":85}]
[" c2",null,"%",{"$f":"INDEX(D17:D24,D26)","v":2}]
["Maximum kW",null,"kW",400]
[]
["A.1.2.3    Generator output at intermediate load;","ФPint ","kW",{"$f":"+D5*0.3","v":18}]
[]
[]
["A.1.2.4      Generator efficiency at intermediate load","ηgnr,Pint ","%",{"$f":"+IF(D36<D55,D53+D54*LOG10(D36),D53+D54*LOG10(D55))","v":91.667226875575466}]
["Known input"]
["Generator output at full load;","ФPn ","kW",{"$f":"+D5","v":60}]
[]
["Base formula"]
[]
["Data table"]
["Data",null," c3"," c4"]
["Unit",null,"%","%"]
["Gas standard boiler",null,81.5,3]
["Gas low temperature boiler",null,89,1.5]
["Gas condensing boiler",null,98,1]
["Oil standard boiler",null,81,2]
["Oil low temperature boiler",null,89,1.5]
["Oil condensing boiler",null,96,1]
["My boiler with fixed value (c2 = 0)",null,87,0]
["Last boiler ",null,50,0]
["Your selection"]
["Selection index",null,null,2]
[" c3",null,"%",{"$f":"INDEX(C43:C50,D52)","v":89}]
[" c4",null,"%",{"$f":"INDEX(D43:D50,D52)","v":1.5}]
["Maximum kW",null,"kW",400]
[]
[]
["A.1.2.5     Stand-by heat losses","Фgen,ls,P0 ","kW",{"$f":"D60*(D77/100)*(D60^D78)","v":0.89999999999999991}]
["Known input"]
["Generator output at full load;","ФPn ","kW",{"$f":"+D5","v":60}]
[]
["Base formula"]
[]
["Data table"]
["Data",null," c5"," c6"]
["Unit",null,"-","-"]
["Gas standard boiler",null,8.5,-0.4]
["Gas low temperature boiler",null,6.5,-0.35]
["Gas condensing boiler",null,4.8,-0.35]
["Oil standard boiler",null,8.5,-0.4]
["Oil low temperature boiler",null,6.5,-0.35]
["Oil condensing boiler",null,4.8,-0.35]
["My boiler (direct proportion to power if c6 set to 0)",null,1.5,0]
["Last boiler ",null,2,0]
["Your selection"]
["Selection index",null,null,7]
[" c7",null,"%",{"$f":"INDEX(C67:C74,D76)","v":1.5}]
[" c8",null,"%",{"$f":"INDEX(D67:D74,D76)","v":0}]
[]
[]
["A.1.2.6      Generator auxiliaries at full load","Фaux,Pn ","W",{"$f":"D99+D100*(D85^D101)","v":321.16271006242812}]
["A.1.2.6      Generator auxiliaries at part load","Фaux,Pint ","W",{"$f":"G99+G100*(D85^G101)","v":107.05423668747605}]
["A.1.2.6      Generator auxiliaries at no load","Фaux,P0","W",{"$f":"J99+J100*(D85^J101)","v":15}]
["Known input"]
["Generator output at full load;","ФPn ","kW",{"$f":"+D5","v":60}]
[]
["Base formula"]
[]
["Data table","Full power",null,null,"Intermediate power",null,null,"No load"]
["Data","n"," c7"," c8","n"," c7"," c8","n"," c7"," c8"]
["Unit","-","W","W",null,"-",".",null,"-","."]
["Gas atmospheric boiler",1,40,0.14799999999999999,1,40,0.14799999999999999,0,15,0]
["Forced draught boiler",0.48,0,45,0.48,0,15,0.48,15,0]
["Condensing boiler",0.48,0,45,0.48,0,15,0,15,0]
["My boiler with fixed value (n = 1)",1,0,20,1,0,10,0,10,0]
["Last boiler ",1,0,20,1,0,10,0,10,0]
["Your selection"]
["Selection index",null,null,2,null,null,{"$f":"+D98","v":2},null,null,{"$f":"+G98","v":2}]
[" c7",null,"W",{"$f":"INDEX(C92:C96,D98)","v":0},null,"W",{"$f":"INDEX(F92:F96,G98)","v":0},null,"W",{"$f":"INDEX(I92:I96,J98)","v":15}]
[" c8",null,"W",{"$f":"INDEX(D92:D96,D98)","v":45},null,"W",{"$f":"INDEX(G92:G96,G98)","v":15},null,"W",{"$f":"INDEX(J92:J96,J98)","v":0}]
["n",null,"-",{"$f":"INDEX(B92:B96,D98)","v":0.48},null,"-",{"$f":"INDEX(E92:E96,G98)","v":0.48},null,"-",{"$f":"INDEX(H92:H96,J98)","v":0.48}]
[]
[]
["A.1.2.1    Recoverable fraction of heat losses","ФPn ","kW",60]
[]
["Efficiency correction factor at full load","fcorr,Pn ","%/°C",{"$f":"+D124","v":0.04}]
["Efficiency correction factor at part load","fcorr,Pint ","%/°C",{"$f":"+D125","v":0.05}]
["Known input"]
["Generator output at full load;","ФPn ","kW",{"$f":"+D53","v":89}]
[]
["Base formula"]
[]
["Data table"]
["Data",null,"fcorr,Pn ","fcorr,Pint "]
["Unit",null,"%/°C","%/°C"]
["Standard boiler",null,0.04,0.05]
["Low temperature boiler",null,0.04,0.05]
["Gas condensing boiler",null,0.2,0.2]
["Oil condensing boiler",null,0.1,0.1]
["My boiler",null,0.04,0.05]
["Last boiler ",null,0.04,0.05]
["Your selection"]
["Selection index",null,null,6]
[" c7",null,"%/°C",{"$f":"INDEX(C116:C121,D123)","v":0.04}]
[" c8",null,"%/°C",{"$f":"INDEX(D116:D121,D123)","v":0.05}]
[]
[]
["Minimum boiler operating temperature","θgnr,min","°C",{"$f":"IF(Product_descriptive_data!C9=Product_descriptive_data!C13,50,0)","v":50}]
[]
["Recoverable fraction of stand-by losses","fgnr,env","-",0.5]
[]
["generator average water temperature at test conditions for full load;","θgnr,test,Pn","°C",70]
[]
["generator average water temperature at test conditions for intermediate load;","θgnr,test,Pint","°C",50]
[]
["difference between mean boiler temperature and test room temperature in test conditions;","Dθtest,P0 ","°C",{"$f":"IF(Product_descriptive_data!C43=Product_descriptive_data!C47,50,0)","v":50}]
[]
["part of the auxiliary energy recovered","frvd,aux ","-",0.75]
[]
["part of the nominal electrical power not transmitted to the distribution sub-system","frbl,aux ","-",0.25]

{"sheet":"Process_design_data","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"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."]
[]
[]
[]
[]
[" Process design data (qualitative)"]
[]
["Boiler location (installation position)"]
[1,"BLR_LOC",{"$f":"INDEX(C11:C14,A9)","v":"BLR_LOC_INT"},null,"qi,brm ","bbrm"]
[null,null,null,null,"°C","-"]
["Heated space",null,"BLR_LOC_INT",null,20,0]
["Unheated room",null,"BLR_LOC_UNH",null,5,0.5]
["Boiler room",null,"BLR_LOC_BLR",null,15,0.7]
["External",null,"BLR_LOC_EXT",null,-10,1]
["Selected value",null,null,null,{"$f":"INDEX(E11:E14,$A$9)","v":20},{"$f":"INDEX(F11:F14,$A$9)","v":0}]
[]
[]
["Boiler hydraulic connection"]
[4,"BLR_HCON",{"$f":"INDEX(C21:C24,A19)","v":"BLR_HCON_HEX"}]
[]
["Direct connection",null,"BLR_HCON_DIR"]
["Hydraulic decoupling (independent flow rate)",null,"BLR_HCON_DEC"]
["Direct, with condensate prevention pump",null,"BLR_HCON_NCP"]
["Heat exchanger",null,"BLR_HCON_HEX"]

{"sheet":"Data_catalogue_example","index":5,"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"]
[3,null,"BLR_USE",{"$f":"INDEX(D9:D11,A7)","v":"BLR_USE_ALL"}]
[]
["Heating",null,null,"BLR_USE_H"]
["Domestic hot water",null,null,"BLR_USE_DHW"]
["All",null,null,"BLR_USE_ALL"]
[]
[]
["Fuel"]
[2,null,"BLR_FUEL",{"$f":"INDEX(D17:D19,A15)","v":"BLR_FUEL_OIL"}]
["Values"]
["Gas",null,null,"BLR_FUEL_GAS"]
["Oil",null,null,"BLR_FUEL_OIL"]
["All",null,null,"BLR_FUEL_ALL"]
[]
[]
["Boiler type, condensing / non condensing"]
[1,null,"BLR_COND",{"$f":"INDEX(D25:D26,A23)","v":"BLR_COND_YES"}]
["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_NAT_1"}]
[]
[null,null,7]
["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":"NOT COMPATIBLE"},"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":false},{"$f":"$D$23=Y38","v":false},"BLR_COND_NO",{"$f":"OR($D$15=$D$19,$D$15=AA38)","v":false},"BLR_FUEL_GAS",true,null,true]
[{"$f":"IF(W39,B39,\"NOT COMPATIBLE\")","v":"NOT COMPATIBLE"},"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":false},{"$f":"$D$23=Y39","v":false},"BLR_COND_NO",false,"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,true,"BLR_COND_YES",false,"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,false,"BLR_COND_NO",true,"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,false,"BLR_COND_NO",true,"BLR_FUEL_OIL",true,null,true]
["Oil, condensing, minimum value","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,true,true,"BLR_COND_YES",true,"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,false,"BLR_COND_NO",true,"BLR_FUEL_OIL",true,null,true]
["NOT COMPATIBLE","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,false,false,"BLR_COND_NO",false,"BLR_FUEL_GAS",true,null,true]
["NOT COMPATIBLE","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,false,false,"BLR_COND_NO",false,"BLR_FUEL_GAS",true,null,true]
["NOT COMPATIBLE","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,false,false,"BLR_COND_NO",false,"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,false,"BLR_COND_NO",true,"BLR_FUEL_OIL",true,null,true]
["NOT COMPATIBLE","Custom values",null,"BLR_DATA_USR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"BLR_COND_NO",false,"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_OIL"},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":92},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":90},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":50},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":50},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":"Ground preh+prec","index":6,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
["Calculation method for ground preheating and -cooling - see prEN 16798-5-1 Annex C",null,null,null,null,"must be completed and verified"]
[]
["Input"]
["Name","Symbol","Software name","Unit","Value","Range","Origin","Varying","Notes"]
["inner surface of the ground heat exchanger","As","A_S","m²",50,"0...∞",null,"No"]
["annual mean outside air temperature","ϑe;mn;an","theta_e_mn_an","°C",5,"-50…+50",null,"Yes"]
["maximum monthly mean outside air temperature","ϑe;max;m","theta_e_max_m","°C",-14,"-50…+50",null,"Yes"]
["annual hour (with tan = 0 h at the beginning of the year)","tan","t_an","h",300,"0…8760",null,"Yes"]
["density of the ground material","ρgnd","rho_gnd","kg/m³",1500,"0...∞",null,"No"]
["capacity of the ground material","cgnd","c_gnd","J/(kg*K)",1200,"0...∞",null,"No"]
["conductivity of the ground material","λgnd","lambda_gnd","W/mK",1.88,"0...∞",null,"No"]
["depth in the ground","z","z","m²",2,"0...∞",null,"Yes"]
["time of the year when the monthly mean outside air temperature is minimal","tan;min","t_an_min","h",350,"0…8760",null,"Yes"]
["inner diameter of the duct","di","d_i","m",0.15,"0...∞",null,"Yes"]
["outer diameter of the duct","do","d_o","m",0.155,"0...∞",null,"Yes"]
["average air temperature in the duct","ϑm ","theta_m","°C",1,"-50…+50",null,"Yes","ϑm =ϑe"]
["velocity of the air in the duct","v","v","m/s",3,"0...∞",null,"Yes"]
["maximum relative humidity of the air leaving the ground heat exchanger ","ϕODA;gnd;max","phi_ODA_gnd_max","%",100,"0…100",null,"Yes"]
["mean external moisture content of the calculation interval","xe","x_e","kg/kg dry air",3.3999999999999998E-3,"0...∞",null,"Yes"]
["mean pressure of the ambient air","patm","p_atm","Pa",100000,"-∞...∞",null,"No"]
["conductivity of the duct","λdu","lambda_du","W/mK",3.3999999999999998E-3,"0...∞",null,"No"]
[]
["Calculation"]
["Description","Symbol","Unit","Value","Formula ref","Formula","Notes"]
["Temperature difference"]
["temperature difference by preheating or - cooling in the ground","Δϑgnd","K",{"$f":"(D28-E17)*(1-EXP(-((D31*E6)/(Method_input!E118*Method_input!E119*Method_calculation!D15))))","v":12.133703809312834},"Formula (C.1)"]
["temperature of the ground","ϑgnd","°C",{"$f":"E7+(E8-E7)*EXP(-D29)*COS(2*PI()*(E9/8760)-D29-D30)","v":13.133703809312834},"Formula (C.2)"]
["factor which takes the ground material an the dept in the ground into account","ξ","m²",{"$f":"E13*SQRT((PI()*E10*E11)/(E12*8760*3600))","v":0.61767348183720239},"Formula (C.3)"]
["time shift factor to correct the time position of the minimal ground temperature factor","ft","-",{"$f":"PI()*(((2*E14)/8760)+1)","v":3.3926331624382926},"Formula (C.4)"]
["heat transfer coefficient of the ground heat exchanger","Udu","W/(m*K)",{"$f":"((1/(2*PI()))*(1/E22)*((E16/2)/(E15/2))*(1/D32))^(-1)","v":0.31291633493497728},"Formula (C.5)"]
["inside surface coefficient ","hi","W/(m²*K)",{"$f":"(4.13+0.23*(E17/100)-0.0077*(E17/100)^2)*((E18^0.75)/(E15^0.25))","v":15.135957116197295},"Formula (C.6)"]
["moisture difference"]
["moisture difference by preheating or -cooling in the ground","Δxgnd","kg/kg dry air",{"$f":"D35-E20","v":0},"Formula (C.7)"]
["moisture content of the outdoor air leaving the ground heat exchanger","xODA;gnd","kg/kg dry air",{"$f":"MIN(E20,(0.622*(D36/(E21-D36))))","v":3.3999999999999998E-3},"Formula (C.8)"]
["partial pressure of the outdoor air leaving the ground heat exchanger","pp;ODA;gnd","Pa",{"$f":"(D37*E19)/100","v":1507.9365502158719},"Formula (C.9)"]
["saturation pressure of the air leaving the ground heat exchanger","pODA;gnd;sat","Pa",{"$f":"611.2*EXP((17.62*(E17+D27))/(243.12+(E17+D27)))","v":1507.9365502158719},"Formula (C.10)"]

{"sheet":"Input_series","index":7,"n_rows":25,"n_cols":49,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["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",null,null,"example with:","200 m²","V = 200 m² x h = 200 m² x 2,5 m = 500 m³"]
["Number of input data",null,48,null,"h = 2,5 m","q = V x n = 500 m³ x 0,4 h-1 = 200 m³/h-1"]
["Number of time steps",null,12,null,"n = 0,4 h-1"]
[]
["Description","calculation interval","mean external temperature of the calculation interval","internal temperature","mean temperature of the unconditioned duct or air handling unit surrounding","AHU heating coil input","required energy to be supplied by the heat pump for space heating","required energy to be extracted by the heat pump for cooling","required energy from heat pump for domestic hot water","required supply volume flow rate with stage 1 going to the zone","required supply volume flow rate with stage 2 going to the zone","required supply volume flow rate with stage 3 going to the zone","required exhaust volume flow rate with stage 1 from zone","required exhaust volume flow rate with stage 2 from zone","required exhaust volume flow rate with stage 3 from zone","mean return air temperature with stage 1","mean return air temperature with stage 2","mean return air temperature with stage 3","operating time of the ventilation system with stage 1","operating time of the ventilation system with stage 2","operating time of the ventilation system with stage 3","total time in the time step (e.g. one month) or bin","operating time of the ventilation system in defrosting mode","recirculation air volume flow rate with stage 1","recirculation air volume flow rate with stage 2","recirculation air volume flow rate with stage 3","average difference between outdoor temperature and the defrost mode setpoint during the defrosting period","mean air temperature difference between inflow and outflow air in a preheating coil with air volume flow rate with stage 1","mean air temperature difference between inflow and outflow air in a preheating coil with air volume flow rate with stage 2","mean air temperature difference between inflow and outflow air in a preheating coil with air volume flow rate with stage 3","correction factor for extract air temperature deviations","correction factor for mean ventilation mechanical air flow deviations","correction factor for heating circuit temperature deviations","heat loss coefficient of the heat pump","heat loss coefficient of the heat pump for cooling","specific power input of a fan m with air volume flow 1 including fan controls according to design","specific power input of a fan m with air volume flow 2 including fan controls according to design","specific power input of a fan m with air volume flow 3 including fan controls according to design","rotation speed with stage 1","rotation speed with stage 2","rotation speed with stage 3","Ventilation flow control factor","Exponent for non-linearity of motor and drive ","factor taking into account electrical preheating control, in consideration of type of controller","Area of the particular zone j","Area of the net floor","operating time of the ventilation system in preheating mode","operating time of the ventilation system in precooling mode","operating time of the ventilation system in heat recovery mode"]
["Symbol","tci","ϑe","ϑi","ϑsur;nc;m","QH;V;in","QH;V;hp;out;req","QC;V;hp;in;req","QW;V;hp;out;req","qV;SUP;dis;req;1","qV;SUP;dis;req;2","qV;SUP;dis;req;3","qV;ETA;dis;req;1","qV;ETA;dis;req;2","qV;ETA;dis;req;3","ϑETA;1","ϑETA;2","ϑETA;3","tV;1","tV;2","tV;3","ttotal","tdefrost","qV;rca;1","qV;rca;2","qV;rca;3","ΔTdefrost","Δϑpreh;1","Δϑpreh;2","Δϑpreh;3","fΔϑ-ETA","fV","f∆ϑ –h","fgen,hp","fgen,cu","SPI1","SPI2","SPI3","nrot,1","nrot,2","nrot,3","fflow,ctrl","x","fdefrost,ctr","Aj","Afloor","tv;preh","tv;prec","tv;hr"]
["Unit","mth","°C","°C","°C","kWh","kWh","kWh","kWh","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","°C","°C","°C","h","h","h","h","h","m³/h","m³/h","m³/h","K","K","K","K","-","-","-","-","-","kW/(m³/h)","kW/(m³/h)","kW/(m³/h)","min-1","min-2","min-3","-","-","-","m²","m²","h","h","h"]
[]
[]
["Time stamp",null,null,"VALUES"]
["January",1,1,21,10,0,1500,0,200,140,200,260,140,200,260,22,22,22,248,248,248,{"$f":"31*24","v":744},168,0,40,60,2.4,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["February",2,1.9,21,10,0,1500,0,200,140,200,260,140,200,260,22,22,22,224,224,224,{"$f":"28*24","v":672},168,0,40,60,2.4,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["March",3,4.7,21,10,0,1000,0,200,140,200,260,140,200,260,22,22,22,248,248,248,{"$f":"31*24","v":744},0,0,40,60,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["April",4,9.1999999999999993,21,10,0,1000,0,200,140,200,260,140,200,260,22,22,22,240,240,240,{"$f":"30*24","v":720},0,0,40,60,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["May",5,14.1,21,10,0,500,0,200,140,200,260,140,200,260,22,22,22,248,248,248,{"$f":"31*24","v":744},0,0,40,60,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["June",6,16.7,24,18,0,0,500,200,140,200,260,140,200,260,25,25,25,240,240,240,{"$f":"30*24","v":720},0,0,0,0,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["July",7,19,24,18,0,0,1000,200,140,200,260,140,200,260,25,25,25,248,248,248,{"$f":"31*24","v":744},0,0,0,0,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["August",8,18.600000000000001,24,18,0,0,750,200,140,200,260,140,200,260,25,25,25,248,248,248,{"$f":"31*24","v":744},0,0,0,0,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["September",9,14.3,21,10,0,500,0,200,140,200,260,140,200,260,22,22,22,240,240,240,{"$f":"30*24","v":720},0,0,40,60,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["October",10,9.5,21,10,0,1000,0,200,140,200,260,140,200,260,22,22,22,248,248,248,{"$f":"31*24","v":744},0,0,40,60,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["November",11,4.0999999999999996,21,10,0,1000,0,200,140,200,260,140,200,260,22,22,22,240,240,240,{"$f":"30*24","v":720},0,0,40,60,0,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]
["December",12,0.9,21,10,0,1500,0,200,140,200,260,140,200,260,22,22,22,248,248,248,{"$f":"31*24","v":744},168,0,40,60,2.4,0,0,0,1,1,1,0.02,0.02,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,null,null,null,0.65,2,1]

{"sheet":"Method_input","index":8,"n_rows":120,"n_cols":9,"rows_kept":120,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["THIS IS A MANDATORY SHEET\nAll input data for the method shall be listed here.\nIn the simplest version, values for data input in column D (both green and blue background) may be inserted manually.\nVarying data (green background) can be fed from the \"input_series\" sheet.\nIn this sample data sheet, product data (blue background) is linked to a sample catalogue built in the \"Detailed_input\" sheet"]
[]
[]
["Name","Symbol","Software name","Unit","Value","Range","Origin","Varying","Notes"]
["Operating conditions data"]
["calculation interval","tci","t_ci","mth",12,"1…12","M1-9","No"]
["mean external temperature of the calculation interval","ϑe","theta_e","°C",0.9,"-50…+50","M1-13","Yes"]
["internal temperature","ϑi","theta_i","°C",21,"0…+30","M2-2","Yes"]
["mean temperature of the unconditioned duct or air handling unit surrounding","ϑsur,nc;m","theta_sur_nc_m","°C",10,"-50…+50","M2-2","Yes"]
["AHU heating coil input","QH;V;in","Q_H_V_in","kWh",0,"0...∞","M3-1","Yes"]
["required energy to be supplied by the heat pump for space heating","QH;V;hp;out;req","Q_H_V_hp_out_req","kWh",1500,"0...∞","M2-2","Yes"]
["required energy to be extracted by the heat pump for cooling","QC;V;hp;in;req","Q_C_V_hp_in_req","kWh",0,"0...∞","M2-2","Yes"]
["required energy from heat pump for domestic hot water","QW;V;hp;out;req","Q_W_V_hp_out_req","kWh",200,"0...∞","M8-1","Yes"]
["required supply volume flow rate with stage 1 going to the zone","qV;SUP;dis;req;1","q_V_SUP_dis_req_1","m³/h",140,"0...∞","M5-5","Yes"]
["required supply volume flow rate with stage 2 going to the zone","qV;SUP;dis;req;2","q_V_SUP_dis_req_2","m³/h",200,"0...∞","M5-5","Yes"]
["required supply volume flow rate with stage 3 going to the zone","qV;SUP;dis;req;3","q_V_SUP_dis_req_3","m³/h",260,"0...∞","M5-5","Yes"]
["required exhaust volume flow rate with stage 1 from zone","qV;ETA;dis;req;1","q_V_ETA_dis_req_1","m³/h",140,"0...∞","M5-5","Yes"]
["required exhaust volume flow rate with stage 2 from zone","qV;ETA;dis;req;2","q_V_ETA_dis_req_2","m³/h",200,"0...∞","M5-5","Yes"]
["required exhaust volume flow rate with stage 3 from zone","qV;ETA;dis;req;3","q_V_ETA_dis_req_3","m³/h",260,"0...∞","M5-5","Yes"]
["mean return air temperature with stage 1","ϑETA;1","theta_ETA_1","°C",22,"0…+50","M5-5","Yes"]
["mean return air temperature with stage 2","ϑETA;2","theta_ETA_2","°C",22,"0…+50","M5-5","Yes"]
["mean return air temperature with stage 3","ϑETA;3","theta_ETA_3","°C",22,"0…+50","M5-5","Yes"]
["operating time of the ventilation system with stage 1","tV;1","t_V_1","h",248,"0…8760","Local","Yes"]
["operating time of the ventilation system with stage 2","tV;2","t_V_2","h",248,"0…8760","Local","Yes"]
["operating time of the ventilation system with stage 3","tV;3","t_V_3","h",248,"0…8760","Local","Yes"]
["total time in the time step (e.g. one month) or bin","ttotal","t_total","h",744,"0…8760","-","Yes"]
["operating time of the ventilation system in defrosting mode","tdefrost","t_defrost","h",168,"0…8760","-","Yes"]
["recirculation air volume flow rate with stage 1","qV;rca;1","q_V_rca_1","m³/h",0,"0...∞","Local","Yes"]
["recirculation air volume flow rate with stage 2","qV;rca;2","q_V_rca_2","m³/h",40,"0...∞","Local","Yes"]
["recirculation air volume flow rate with stage 3","qV;rca;3","q_V_rca_3","m³/h",60,"0...∞","Local","Yes"]
["Average difference between outdoor temperature and the defrost mode setpoint during the defrosting period","ΔTdefrost","delta_T_defrost","K",2.4,"0…50","Local","Yes"]
["mean air temperature difference between inflow and outflow air in a preheating coil with air volume flow rate with stage 1","Δϑpreh;1","delta_theta_preh_1","K",0,"-50…+50","Local","Yes"]
["mean air temperature difference between inflow and outflow air in a preheating coil with air volume flow rate with stage 2","Δϑpreh;2","delta_theta_preh_2","K",0,"-50…+50","Local","Yes"]
["mean air temperature difference between inflow and outflow air in a preheating coil with air volume flow rate with stage 3","Δϑpreh;3","delta_theta_preh_3","K",0,"-50…+50","Local","Yes"]
["correction factor for extract air temperature deviations","fΔϑ-ETA","f_delta_theta_ETA","-",1,"0,98…1,12","Local","Yes"]
["correction factor for mean ventilation mechanical air flow deviations","fV","f_V","-",1,"0,71…3,55","Local","Yes"]
["correction factor for heating circuit temperature deviations","fΔϑ-h","f_delta_theta_h","-",1,"0,853…1,154","Local","Yes"]
["heat loss coefficient of the heat pump","fgen,hp","f_gen_hp","-",0.02,"0…0,02","Local","Yes"]
["heat loss coefficient of the heat pump for cooling","fgen,cu","f_gen_cu","-",0.02,"0…0,02","Local","Yes"]
["specific power input of a fan m with air volume flow 1 including fan controls according to design","SPI1","SPI_1","kW/(m³/h)",4.0000000000000002E-4,"0...∞","prEN 13142","Yes"]
["specific power input of a fan m with air volume flow 2 including fan controls according to design","SPI2","SPI_2","kW/(m³/h)",5.0000000000000001E-4,"0...∞","prEN 13142","Yes"]
["specific power input of a fan m with air volume flow 3 including fan controls according to design","SPI3","SPI_3","kW/(m³/h)",5.9999999999999995E-4,"0...∞","prEN 13142","Yes"]
["rotation speed with stage 1","nrot;1","n_rot_1","min-1",null,"0...∞","Local","Yes"]
["rotation speed with stage 2","nrot;2","n_rot_2","min-1",null,"0...∞","Local","Yes"]
["rotation speed with stage 3","nrot;3","n_rot_3","min-1",null,"0...∞","Local","Yes"]
["Ventilation flow control factor","fflow,ctrl","f_flow_ctrl","-",0.65,"0…1","Local","Yes"]
["Exponent for non-linearity of motor and drive ","x","x","-",2,"1…2","Local","Yes"]
["factor taking into account electrical preheating control, in consideration of type of controller","fdefrost;ctrl","f_defrost_ctrl","-",1,"0,8…3,1","Local","Yes"]
["Area of the particular zone j","Aj","A_j","m²",null,"0...∞","Local","Yes"]
["Area of the net floor","Afloor","A_floor","m²",null,"0...∞","Local","Yes"]
["operating time of the ventilation system in preheating mode","tv;preh","t_v_preh","h",null,"0…8760","Local","Yes"]
["operating time of the ventilation system in precooling mode","tv;prec","t_v_prec","h",null,"0…8761","Local","Yes"]
["operating time of the ventilation system in heat recovery mode","tv;hr","t_v_hr","h",null,"0…8762","Local","Yes"]
[]
["Product data"]
["Product description data "]
[]
[]
[]
["Product technical data "]
["duct area","Adu","A_du","m²",25,null,null,"No","EN 14239"]
["limit outdoor air temperature for preheating","ϑe;lim;preh","theta_e_lim_preh","°C",0,null,null,"Yes","EN 13141-7"]
["limit outdoor air temperature for precooling","ϑe;lim;prec","theta_e_lim_prec","°C",26,null,null,"Yes","EN 13141-7"]
["duct leakage factor","flea,du","f_lea_du","-",1.02,null,null,null,"6.3.2.2.2"]
["air handling unit leakage factor","flea,ahu","f_lea_ahu","-",1.04,null,null,null,"6.3.2.2.3"]
["air handling unit insulation factor","fins,ahu","f_ins_ahu","-",0.02,null,null,null,"6.4.2.2"]
["number of stages k","nst","n_st","-",3,null,null,"No"]
["temperature ratio of heat recovery with air volume flow with stage 1","ηhr;1","eta_hr_1","-",0.8,null,null,"No"]
["temperature ratio of heat recovery with air volume flow with stage 2","ηhr;2","eta_hr_2","-",0.8,null,null,"No"]
["temperature ratio of heat recovery with air volume flow with stage 3","ηhr;3","eta_hr_3","-",0.8,null,null,"No"]
["air handling unit surface area","Aahu","A_ahu","m²",5,null,null,"No"]
["air handling unit heat loss coefficient","Uahu","U_ahu","kW/m²K",1E-3,null,null,"No"]
["maximum rotation speed of the rotary heat recovery device","nrot,max","n_rot_max","min-1",20,null,null,"No"]
["Rotor drive power at max. rotation speed","Phr,rot,max","P_hr_rot_max","kW",0.05,null,null,"No"]
["electric power consumption of the control devices (sensors, actuators, controllers)","∑Pel,V,ctrl","sum_P_el_V_ctrl","kW",0.01,null,null,"No"]
["coefficient of performance of the heat pump for domestic hot water (with stage 1)","COPW;1","COP_W_1","-",3,null,null,"No","EN 16147\nprEN 16573"]
["coefficient of performance of the heat pump for domestic hot water (with stage 2)","COPW;2","COP_W_2","-",3.2,null,null,"No","EN 16147\nprEN 16573"]
["coefficient of performance of the heat pump for domestic hot water (with stage 2)","COPW;3","COP_W_3","-",3.4,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for domestic hot water (with stage 1)","pW;hp;1","p_W_h_1","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for domestic hot water (with stage 2)","pW;hp;2","p_W_h_2","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for domestic hot water (with stage 3)","pW;hp;3","p_W_h_3","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["coefficient of performance of the heat pump for space heating (with stage 1)","COPH;1","COP_H_1","-",3.5,null,null,"No","EN 16147\nprEN 16573"]
["coefficient of performance of the heat pump for space heating (with stage 2)","COPH;2","COP_H_2","-",3.7,null,null,"No","EN 16147\nprEN 16573"]
["coefficient of performance of the heat pump for space heating (with stage 3)","COPH;3","COP_H_3","-",3.9,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for space heating (with stage 1)","pH;hp;1","p_H_hp_1","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for space heating (with stage 2)","pH;hp;2","p_H_hp_2","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for space heating (with stage 3)","pH;hp;3","p_H_hp_3","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["energy efficiency ratio of the heat pump for cooling (with stage 1)","EER1","EER_1","-",2.2000000000000002,null,null,"No","EN 16147\nprEN 16573"]
["energy efficiency ratio of the heat pump for cooling (with stage 2)","EER2","EER_2","-",2.4,null,null,"No","EN 16147\nprEN 16573"]
["energy efficiency ratio of the heat pump for cooling (with stage 3)","EER3","EER_3","-",2.6,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for cooling (with stage 1)","pC;hp;1","p_C_hp_1","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for cooling (with stage 2)","pC;hp;2","p_C_hp_2","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
["power consumption of the heat pump for cooling (with stage 3)","pC;hp;3","p_C_hp_3","W/(m³/h)",2,null,null,"No","EN 16147\nprEN 16573"]
[]
["pressure difference between duct and ambient air with stage 1","Δpdu;1","delta_p_du_1","Pa",40,null,null,"Yes"]
["pressure difference between duct and ambient air with stage 2","Δpdu;2","delta_p_du_2","Pa",50,null,null,"Yes"]
["pressure difference between duct and ambient air with stage 3","Δpdu;3","delta_p_du_3","Pa",60,null,null,"Yes"]
["air tightness factor of the ductwork with stage 1","clea;du;1","c_lea_du_1","m³/(s*m²*Pa)",1.02,null,null,"No","EN 12237\nEN 1507"]
["air tightness factor of the ductwork with stage 2","clea;du;2","c_lea_du_2","m³/(s*m²*Pa)",1.02,null,null,"No","EN 12237\nEN 1507"]
["air tightness factor of the ductwork with stage 3","clea;du;3","c_lea_du_3","m³/(s*m²*Pa)",1.02,null,null,"No","EN 12237\nEN 1507"]
["pressure difference exponent","ep","e_p","-",0.67,null,null,"Yes"]
["fan efficiency","ηfan","eta_fan","-",0.35,"0,2…0,35","Local","No"]
[]
[]
["System design data"]
["   Process design"]
["heat transfer coefficient from the supply duct to the non-conditioned surrounding","Hdu;SUP;nc","H_du_SUP_nc","kW/K",5.0000000000000001E-3,"0...∞",null,"No"]
["heat transfer coefficient from the extract air duct to the non-conditioned surrounding","Hdu;ETA;nc","H_du_ETA_nc","kW/K",5.0000000000000001E-3,"0...∞",null,"No"]
["heat transfer coefficient of the supply air duct to the thermal zone","Hdu;SUP;cnd","H_du_SUP_cnd","kW/K",0.01,"0...∞",null,"No"]
["pressure loss of the external defrosting device","Δpdefrost","delta_p_defrost","Pa",20,"10…40","Local","No"]
[]
["  Control type data"]
[]
[]
[]
["Constants"]
["standard atmospheric pressure","patm","p_atm","Pa",101325,null,null,"No"]
["air density","ρa","rho_a","kg/m³",1.204,null,null,"No"]
["specific heat of the air at constant pressure","ca","c_a","kWh/(kg*K)",2.7900000000000001E-4,null,null,"No"]
["evaporation heat of water","rW","r_W","kWh/kg",0.68,null,null,"No"]

{"sheet":"Method_calculation","index":9,"n_rows":154,"n_cols":14,"rows_kept":154,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["THIS IS A MANDATORY SHEET\nOne time step calculation shall be described here.\nFor each calculation step (= 1 row) data for the formula in column D shall be taken from the \"Method_input\" sheet or previous calculation steps.\nInclude in the column \"Formula ref\" its number in the standard text. The example is based on EN 15316-4-1:2008\nCopy and paste a copy of the equation into column \"Formula\"\nUse the column note for information on the calculation"]
[]
["Description","Symbol","Unit","Value","Formula ref","Formula","Notes"]
["6.3.2.2.2 duct leakage factor"]
["duct leakage factor","flea;du","-","-","Formula (1)"]
["supply air flow trough duct leakage with stage 1","qV;SUP;lea;du;1","m³/h",{"$f":"(Method_input!E61*Method_input!E98*(Method_input!E95^Method_input!E101))/3600","v":8.387216890308466E-2},"Formula (2)",null,"generally"]
["supply air flow trough duct leakage with stage 2","qV;SUP;lea;du;2","m³/h",{"$f":"(Method_input!E61*Method_input!E99*(Method_input!E96^Method_input!E101))/3600","v":9.7397449097277281E-2},"Formula (2)"]
["supply air flow trough duct leakage with stage 3","qV;SUP;lea;du;3","m³/h",{"$f":"(Method_input!E61*Method_input!E100*(Method_input!E97^Method_input!E101))/3600","v":0.11005227315229912},"Formula (2)"]
["6.3.2.2.3 air handling unit leakage factor"]
["air handling unit leakage factor","flea;ahu","m³/h","-","Formula (3)"]
["6.4.2.1 volume flow rates"]
["supply volume flow rate with stage 1 going to the zone served by the system","qV;SUP;dis;1","m³/h",{"$f":"Method_input!E14*Method_input!E64*Method_input!E65","v":148.51200000000003},"Formula (4)",null,"generally"]
["supply volume flow rate with stage 2 going to the zone served by the system","qV;SUP;dis;2","m³/h",{"$f":"Method_input!E15*Method_input!E64*Method_input!E65","v":212.16},"Formula (4)"]
["supply volume flow rate with stage 3 going to the zone served by the system","qV;SUP;dis;3","m³/h",{"$f":"Method_input!E16*Method_input!E64*Method_input!E65","v":275.80799999999999},"Formula (4)"]
["mean supply volume flow rate going to the zone served by the system","qV;SUP;dis","m³/h",{"$f":"(D12*Method_input!E23+D13*Method_input!E24+D14*Method_input!E25)/Method_input!E26","v":212.16000000000003},"Formula (5)"]
["extract volume flow rate with stage 1 from the zone served by the system","qV;ETA;dis;1","m³/h",{"$f":"Method_input!E17*Method_input!E64*Method_input!E65","v":148.51200000000003},"Formula (6)",null,"generally"]
["extract volume flow rate with stage 2 from the zone served by the system","qV;ETA;dis;2","m³/h",{"$f":"Method_input!E18*Method_input!E64*Method_input!E65","v":212.16},"Formula (6)"]
["extract volume flow rate with stage 3 from the zone served by the system","qV;ETA;dis;3","m³/h",{"$f":"Method_input!E19*Method_input!E64*Method_input!E65","v":275.80799999999999},"Formula (6)"]
["mean extract volume flow rate from the zone served by the system ","qV;ETA;dis","m³/h",{"$f":"(D16*Method_input!E23+D17*Method_input!E24+D18*Method_input!E25)/Method_input!E26","v":212.16000000000003},"Formula (7)"]
["operating time of the ventilation system","tV","h",{"$f":"Method_input!E23+Method_input!E24+Method_input!E25","v":744},"Formula (8)"]
["mean duct leakage volume flow rate with stage 1 to the zone","qV;lea;SUP;dis;1","m³/h",{"$f":"(Method_input!E64-1)*Method_calculation!D12","v":2.9702400000000031},"Formula (9)",null,"generally"]
["mean duct leakage volume flow rate with stage 2 to the zone","qV;lea;SUP;dis;2","m³/h",{"$f":"(Method_input!E64-1)*Method_calculation!D13","v":4.2432000000000034},"Formula (9)"]
["mean duct leakage volume flow rate with stage 3 to the zone","qV;lea;SUP;dis;3","m³/h",{"$f":"(Method_input!E64-1)*Method_calculation!D14","v":5.5161600000000046},"Formula (9)"]
["mean duct leakage volume flow rate with stage 1 from the zone","qV;lea;ETA;dis;1","m³/h",{"$f":"(Method_input!E64-1)*Method_calculation!D16","v":2.9702400000000031},"Formula (10)",null,"generally"]
["mean duct leakage volume flow rate with stage 2 from the zone","qV;lea;ETA;dis;2","m³/h",{"$f":"(Method_input!E64-1)*Method_calculation!D17","v":4.2432000000000034},"Formula (10)"]
["mean duct leakage volume flow rate with stage 3 from the zone","qV;lea;ETA;dis;3","m³/h",{"$f":"(Method_input!E64-1)*Method_calculation!D18","v":5.5161600000000046},"Formula (10)"]
["6.4.2.2 supply air temperature"]
["mean supply air temperature going to the supply air ductwork with stage 1","ϑSUP;dis;in;1","°C",{"$f":"Method_input!E7+Method_input!E32+Method_calculation!D31+Method_calculation!D37+Method_calculation!D40","v":17.186736898741533},"Formula (11)",null,"generally",null,null,{"$f":"Method_input!E7+Method_input!E32","v":0.9},{"$f":"Method_input!E7+Method_input!E32+Method_calculation!D31","v":17.186736898741533},{"$f":"Method_input!E7+Method_input!E32+Method_calculation!D31+Method_calculation!D37","v":17.186736898741533},{"$f":"Method_input!E7+Method_input!E32+Method_calculation!D31+Method_calculation!D37+Method_calculation!D40","v":17.186736898741533},"k=1"]
["mean supply air temperature going to the supply air ductwork with stage 2","ϑSUP;dis;in;2","°C",{"$f":"Method_input!E7+Method_input!E33+Method_calculation!D32+Method_calculation!D38+Method_calculation!D41","v":17.895239700309222},"Formula (11)",null,null,null,null,{"$f":"Method_input!E7+Method_input!E33","v":0.9},{"$f":"Method_input!E7+Method_input!E33+Method_calculation!D32","v":16.941531452239804},{"$f":"Method_input!E7+Method_input!E33+Method_calculation!D32+Method_calculation!D38","v":17.895239700309222},{"$f":"Method_input!E7+Method_input!E33+Method_calculation!D32+Method_calculation!D38+Method_calculation!D41","v":17.895239700309222},"k=2"]
["mean supply air temperature going to the supply air ductwork with stage 3","ϑSUP;dis;in;3","°C",{"$f":"Method_input!E7+Method_input!E34+Method_calculation!D33+Method_calculation!D39+Method_calculation!D42","v":17.93623881713723},"Formula (11)",null,null,null,null,{"$f":"Method_input!E7+Method_input!E34","v":0.9},{"$f":"Method_input!E7+Method_input!E34+Method_calculation!D33","v":16.806411975816395},{"$f":"Method_input!E7+Method_input!E34+Method_calculation!D33+Method_calculation!D39","v":17.93623881713723},{"$f":"Method_input!E7+Method_input!E34+Method_calculation!D33+Method_calculation!D39+Method_calculation!D42","v":17.93623881713723},"k=3"]
["mean air temperature difference for heat recovery with air volume flow rate with stage 1","Δϑhr;1","K",{"$f":"(Method_input!E68-(Method_input!E65-1)-Method_input!E66)*(D55-D34)","v":16.286736898741534},"Formula (12)",null,"generally"]
["mean air temperature difference for heat recovery with air volume flow rate with stage 2","Δϑhr;2","K",{"$f":"(Method_input!E69-(Method_input!E65-1)-Method_input!E66)*(D56-D35)","v":16.041531452239806},"Formula (12)"]
["mean air temperature difference for heat recovery with air volume flow rate with stage 3","Δϑhr;3","K",{"$f":"(Method_input!E70-(Method_input!E65-1)-Method_input!E66)*(D57-D36)","v":15.906411975816397},"Formula (12)"]
["mean air temperature after preheating with air volume flow rate with stage 1","ϑODA;preh;1","°C",{"$f":"Method_input!E7+Method_input!E32","v":0.9},"Formula (13)",null,"generally"]
["mean air temperature after preheating with air volume flow rate with stage 2","ϑODA;preh;2","°C",{"$f":"Method_input!E7+Method_input!E33","v":0.9},"Formula (13)"]
["mean air temperature after preheating with air volume flow rate with stage 3","ϑODA;preh;3","°C",{"$f":"Method_input!E7+Method_input!E34","v":0.9},"Formula (13)"]
["mean air temperature difference for recirculation with air volume flow rate with stage 1","Δϑrca;1","K",{"$f":"((Method_input!E28)/D12)*(Method_input!E20-(D34+D31))","v":0},"Formula (14)",null,"generally"]
["mean air temperature difference for recirculation with air volume flow rate with stage 2","Δϑrca;2","K",{"$f":"(Method_input!E29/D13)*(Method_input!E21-(D35+D32))","v":0.95370824806941845},"Formula (14)",null,"qV;rca;k as defined in Input_series!\nqV;out;k = qV;SUP;dis;k"]
["mean air temperature difference for recirculation with air volume flow rate with stage 3","Δϑrca;3","K",{"$f":"(Method_input!E30/D14)*(Method_input!E22-(D36+D33))","v":1.129826841320833},"Formula (14)"]
["mean air temperature difference between inflow and outflow air in a reheating device, e.g. air-to-air heatpump or coil with air volume flow rate with stage 1","Δϑrh;1","K",{"$f":"(Method_input!E10)/(Method_calculation!D12*(Method_input!E118*Method_input!E119)*Method_input!E26)","v":0},"Formula (15)",null,"generally"]
["mean air temperature difference between inflow and outflow air in a reheating device, e.g. air-to-air heatpump or coil with air volume flow rate with stage 2","Δϑrh;2","K",{"$f":"(Method_input!E10)/(Method_calculation!D13*(Method_input!E118*Method_input!E119)*Method_input!E26)","v":0},"Formula (15)"]
["mean air temperature difference between inflow and outflow air in a reheating device, e.g. air-to-air heatpump or coil with air volume flow rate with stage 3","Δϑrh;3","K",{"$f":"(Method_input!E10)/(Method_calculation!D14*(Method_input!E118*Method_input!E119)*Method_input!E26)","v":0},"Formula (15)"]
["mean supply air temperature with volume flow rate with stage 1 leaving the air distribution system and going to the zone","ϑSUP;dis;out;1","°C",{"$f":"D28-D46","v":17.318487434292422},"Formula (16)",null,"generally"]
["mean supply air temperature with volume flow rate with stage 2 leaving the air distribution system and going to the zone","ϑSUP;dis;out;2","°C",{"$f":"D29-D47","v":17.836804991526702},"Formula (16)"]
["mean supply air temperature with volume flow rate with stage 3 leaving the air distribution system and going to the zone","ϑSUP;dis;out;3","°C",{"$f":"D30-D48","v":17.875417193469431},"Formula (16)"]
["mean air temperature drop in the supply ductwork air with volume flow rate with stage 1","Δϑdu;1","K",{"$f":"D49+D52","v":-0.13175053555089045},"Formula (17)",null,"generally"]
["mean air temperature drop in the supply ductwork air with volume flow rate with stage 2","Δϑdu;2","K",{"$f":"D50+D53","v":5.8434708782519995E-2},"Formula (17)"]
["mean air temperature drop in the supply ductwork air with volume flow rate with stage 3","Δϑdu;3","K",{"$f":"D51+D54","v":6.0821623667798363E-2},"Formula (17)"]
["temperature drop due to the heat losses of the supply duct section j  to the non-conditioned space with stage 1","ΔϑSUP,du;nc;j;1","K",{"$f":"(D28-Method_input!E9)*(1-EXP(-(Method_input!E107/((Method_input!E118*Method_input!E119)*Method_calculation!D12))))","v":0.68537396533450889},"Formula (18)",null,"generally"]
["temperature drop due to the heat losses of the supply duct section j  to the non-conditioned space with stage 2","ΔϑSUP,du;nc;j;2","K",{"$f":"(D29-Method_input!E9)*(1-EXP(-(Method_input!E107/((Method_input!E118*Method_input!E119)*Method_calculation!D13))))","v":0.53492836198624361},"Formula (18)"]
["temperature drop due to the heat losses of the supply duct section j  to the non-conditioned space with stage 3","ΔϑSUP,du;nc;j;3","K",{"$f":"(D30-Method_input!E9)*(1-EXP(-(Method_input!E107/((Method_input!E118*Method_input!E119)*Method_calculation!D14))))","v":0.41694712864940681},"Formula (18)"]
["temperature drop due to heat losses of the supply duct section i to an conditioned zone with stage 1","ΔϑSUP;du;cnd;i;1","K",{"$f":"(D28-D49-Method_input!E8)*(1-EXP(-(Method_input!E109/((Method_input!E118*Method_input!E119)*Method_calculation!D12))))","v":-0.81712450088539934},"Formula (19)",null,"generally"]
["temperature drop due to heat losses of the supply duct section i to an conditioned zone with stage 2","ΔϑSUP;du;cnd;i;2","K",{"$f":"(D29-D50-Method_input!E8)*(1-EXP(-(Method_input!E109/((Method_input!E118*Method_input!E119)*Method_calculation!D13))))","v":-0.47649365320372361},"Formula (19)",null,"Note: theta_SUP_du_in_k is generally the temperature at the exit of the preceding duct sequence. If the duct sequence is the first in the system, it is equal to theta_SUP_dis_in_k. If the duct sequence is the last in the system, it is equal to theta_SUP_dis_out_k ."]
["temperature drop due to heat losses of the supply duct section i to an conditioned zone with stage 3","ΔϑSUP;du;cnd;i;3","K",{"$f":"(D30-D51-Method_input!E8)*(1-EXP(-(Method_input!E109/((Method_input!E118*Method_input!E119)*Method_calculation!D14))))","v":-0.35612550498160844},"Formula (19)"]
["extract air temperature modified in the duct with stage 1","ϑETA;dis;out;1","°C",{"$f":"((1/Method_input!E64)*Method_input!E20)+(((Method_input!E64-1)/Method_input!E64)*Method_input!E9)+D58","v":22.909103917218289},"Formula (19b)",null,"generally"]
["extract air temperature modified in the duct with stage 2","ϑETA;dis;out;2","°C",{"$f":"((1/Method_input!E64)*Method_input!E21)+(((Method_input!E64-1)/Method_input!E64)*Method_input!E9)+D59","v":22.577745205729467},"Formula (19b)"]
["extract air temperature modified in the duct with stage 3","ϑETA;dis;out;3","°C",{"$f":"((1/Method_input!E64)*Method_input!E22)+(((Method_input!E64-1)/Method_input!E64)*Method_input!E9)+D60","v":22.395151318670806},"Formula (19b)"]
["temperature difference due to the extract duct heat losses to the non-conditioned space with stage 1","Δϑdu;ETA;1","K",{"$f":"(Method_input!E20-Method_input!E9)*(1-EXP(-(Method_input!E108/((Method_input!E118*Method_input!E119)*Method_calculation!D16))))","v":1.1443980348653495},"Formula (19c)",null,"generally"]
["temperature difference due to the extract duct heat losses to the non-conditioned space with stage 2","Δϑdu;ETA;2","K",{"$f":"(Method_input!E21-Method_input!E9)*(1-EXP(-(Method_input!E108/((Method_input!E118*Method_input!E119)*Method_calculation!D17))))","v":0.8130393233765294},"Formula (19c)",null," "]
["temperature difference due to the extract duct heat losses to the non-conditioned space with stage 3","Δϑdu;ETA;3","K",{"$f":"(Method_input!E22-Method_input!E9)*(1-EXP(-(Method_input!E108/((Method_input!E118*Method_input!E119)*Method_calculation!D18))))","v":0.63044543631786798},"Formula (19c)"]
["outdoor air fraction with stage 1","fODA;1","-",{"$f":"((D34+D31+D37)-(D55))/((D34+D31)-(D55))","v":1},"Formula (20)",null,"generally"]
["outdoor air fraction with stage 2","fODA;2","-",{"$f":"((D35+D32+D38)-(D56))/((D35+D32)-(D56))","v":0.8307891982487482},"Formula (20)"]
["outdoor air fraction with stage 3","fODA;3","-",{"$f":"((D36+D33+D39)-(D57))/((D36+D33)-(D57))","v":0.79783869455901602},"Formula (20)"]
["outdoor air fraction","fODA","-",{"$f":"((D61*Method_input!E23)+(D62*Method_input!E24)+(D63*Method_input!E25))/Method_input!E26","v":0.87620929760258803},"Formula (20h)"]
["6.4.3.2 distribution heat losses"]
["heat losses of the ductwork in the current calculation interval","Qls;V;dis","kWh",{"$f":"(Method_input!E118*Method_input!E119)*(((D12*D49+D21*(D28-Method_input!E9))*Method_input!E23)+((D13*D50+D22*(D29-Method_input!E9))*Method_input!E24)+((D14*D51+D23*(D30-Method_input!E9))*Method_input!E25))","v":35.730360289379085},"Formula (25)"]
["recoverable heat losses of the ductwork in the current calculation interval","Qls;V;dis;rbl","kWh",0,"Formula (26)"]
["6.4.3.3 generation heat losses"]
["generation heat losses of the air handling unit","Qls;V;gen","kWh",{"$f":"D70+Method_input!E38*(IF(Method_calculation!D102=\"true\",Method_calculation!D103,Method_calculation!D110)+IF(Method_calculation!D118=\"true\",Method_calculation!D119,Method_calculation!D126))+Method_input!E39*(IF(Method_calculation!D134=\"true\",Method_calculation!D135,Method_calculation!D142))","v":25.557473507186224},"Formula (27)"]
["heat losses through casing of the air handling unit","Qls;V;ahu","kWh",{"$f":"(Method_input!E71*Method_input!E72)*(Method_calculation!D71-Method_input!E9)*D20","v":6.5608402738035032},"Formula (28)"]
["mean air temperature in the air handling unit","ϑa;m","°C",{"$f":"(0.5*((((Method_input!E7+Method_input!E32)+MAX(Method_calculation!D28,D55))*Method_input!E23)+(((Method_input!E7+Method_input!E33)+MAX(Method_calculation!D29,D56))*Method_input!E24)+(((Method_input!E7+Method_input!E34)+MAX(Method_calculation!D30,D57))*Method_input!E25)))/Method_calculation!D20","v":11.763666740269759},"Formula (29)"]
["recoverable heat losses of the air handling unit in the current calculation interval","Qls;V;gen;rbl","kWh",{"$f":"D69","v":25.557473507186224},"Formula (30)",null,"Note: If the air handling unit is an unconditioned space Q_ls_V_gen_rbl is 0."]
["6.4.3.4 fan"]
["fan energy required by the fans for distributing the air through the ventilation ductwork in the current calculation interval for a fan m","EV;gen;fan","kWh",{"$f":"(Method_input!E23*Method_calculation!D12*(Method_input!E40+((2.78*10^(-7)*Method_input!E110)/Method_input!E102)))+(Method_input!E24*Method_calculation!D13*(Method_input!E41+((2.78*10^(-7)*Method_input!E110)/Method_input!E102)))+Method_input!E25*Method_calculation!D14*(Method_input!E42+((2.78*10^(-7)*Method_input!E110)/Method_input!E102))","v":84.587973778285715},"Formula (31)"]
["fan energy required by the fans for distributing the air through the ventilation ductwork in the current calculation interval","EV;gen;fan","kWh",{"$f":"Method_calculation!D20*((AVERAGE(Method_input!E40:E42))+(((2.78*10^(-7))*Method_input!E110)/Method_input!E102))*MAX(Method_calculation!D12:D14)*(Method_input!E46^(Method_input!E47))","v":44.725994863323436},"Formula (31a)",null,"Note: If only one SPI value is available (with reference air volume flow according EN 13142) then the fan energy required in the current calculation interval for fan m is calculated with formula (31a)."]
["6.4.3.5 auxiliary energy"]
["auxiliary energy in the current calculation interval","WV;aux","kWh",{"$f":"D78+D79+D80","v":32.124390364839194},"Formula (32)","    Wv,aux = WV;aux;hr + WV;aux;preh + WV;aux;ctrl"]
["auxiliary energy required by the heat recovery in the current calculation interval","WV;aux;hr","kWh",{"$f":"(Method_input!E23*Method_input!E74*(Method_input!E43/Method_input!E73))+(Method_input!E24*Method_input!E74*(Method_input!E44/Method_input!E73))+(Method_input!E25*Method_input!E74*(Method_input!E45/Method_input!E73))","v":0},"Formula (33)"]
["auxiliary energy required by the preheating in the current calculation interval","WV;aux;preh","kWh",{"$f":"(Method_input!E118*Method_input!E119)*(Method_calculation!D15/Method_input!E64)*Method_calculation!D64*Method_input!E27*Method_input!E31*Method_input!E48","v":24.684390364839196},"Formula (34)"]
["auxiliary energy required by the control components in the current calculation interval","WV;aux;ctrl","kWh",{"$f":"(Method_input!E23*Method_input!E75)+(Method_input!E24*Method_input!E75)+(Method_input!E25*Method_input!E75)","v":7.4399999999999995},"Formula (35)"]
["6.4.3.6 preheating and precooling"]
["operting time of the ventilation system with stage 1 in preheating mode","tv;preh;1","h",{"$f":"Method_input!E23/Method_calculation!D20*Method_input!E51","v":0}]
["operting time of the ventilation system with stage 2 in preheating mode","tv;preh;2","h",{"$f":"Method_input!E24/Method_calculation!D20*Method_input!E51","v":0}]
["operting time of the ventilation system with stage 3 in preheating mode","tv;preh;3","h",{"$f":"Method_input!E25/Method_calculation!D20*Method_input!E51","v":0}]
["energy transferred from enviroment by ground heat exchanger or solar air panel for preheating in the current calculation interval","Qpreh","kWh",{"$f":"(Method_input!E118*Method_input!E119)*Method_calculation!D64*(((Method_calculation!D15/Method_input!E64)*Method_input!E32*D82)+((Method_calculation!D15/Method_input!E64)*Method_input!E33*D83)+((Method_calculation!D15/Method_input!E64)*Method_input!E34*D84))","v":0},"Formula (36)",null,"Note:operating time of the ventilation system with stage k in preheating mode (with tv;preh;k = tdefrost  if preheating only practice for defrosting or with ϑe < ϑe;lim;preh)n all other cases) in the current calculation interval or bin"]
["operting time of the ventilation system with stage 1 in precooling mode","tv;prec;1","h",{"$f":"Method_input!E23/Method_calculation!D20*Method_input!E52","v":0}]
["operting time of the ventilation system with stage 2 in precooling mode","tv;prec;2","h",{"$f":"Method_input!E24/Method_calculation!D20*Method_input!E52","v":0}]
["operting time of the ventilation system with stage 3 in precooling mode","tv;prec;3","h",{"$f":"Method_input!E25/Method_calculation!D20*Method_input!E52","v":0}]
["energy transferred from enviroment by ground heat exchanger for precooling in the current calculation interval","Qpreh","kWh",{"$f":"(Method_input!E118*Method_input!E119)*Method_calculation!D64*(((Method_calculation!D15/Method_input!E64)*Method_input!E32*Method_input!E23)+((Method_calculation!D15/Method_input!E64)*Method_input!E33*Method_input!E24)+((Method_calculation!D15/Method_input!E64)*Method_input!E34*Method_input!E25))","v":0},"Formula (37)",null,"Note:operating time of the ventilation system with stage k in precooling mode (with ϑe > ϑe;lim;prec) in the current calculation interval or bin"]
["6.4.3.7 heat recovery"]
["operting time of the ventilation system with stage 1 in heat recovery mode","tv;hr;1","h",{"$f":"Method_input!E23/Method_calculation!D20*Method_input!E53","v":0}]
["operting time of the ventilation system with stage 2 in heat recovery mode","tv;hr;2","h",{"$f":"Method_input!E24/Method_calculation!D20*Method_input!E53","v":0}]
["operting time of the ventilation system with stage 3 in heat recovery mode","tv;hr;3","h",{"$f":"Method_input!E25/Method_calculation!D20*Method_input!E53","v":0}]
["energy transferred by the heat recovery in the current calculation interval","Qhr","kWh",{"$f":"(Method_input!E118*Method_input!E119)*Method_calculation!D64*(((Method_calculation!D15/Method_input!E64)*D31*D91)+((Method_calculation!D15/Method_input!E64)*D32*D92)+((Method_calculation!D15/Method_input!E64)*D33*D93))","v":0},"Formula (38)",null,"Note: operating time of the ventilation system with stage k in heat recovery mode (except for time, when the heat exchanger is bypassed, it is used if there are useable gains of heat) in current calculation interval or bin. If there is no Bypass:  tv;hr;k =tv;k "]
["6.4.3.8 recirculation"]
["energy transferred by the recirculation, if present, in the current calculation interval","Qrca","kWh",{"$f":"(Method_input!E118*Method_input!E119)*(((D15/Method_input!E64)*D37*Method_input!E23)+((D15/Method_input!E64)*D38*Method_input!E24)+((D15/Method_input!E64)*D39*Method_input!E25))","v":36.103268806951576},"Formula (39)"]
["6.4.3.9 heating"]
["required energy supplied by the reheating device, e.g. air-to-air heatpump or coil, if present, in the current calculation interval","QH;V;in;req","kWh",{"$f":"(Method_input!E118*Method_input!E119)*(((Method_calculation!D15/Method_input!E64)*Method_calculation!D40*D91)+((Method_calculation!D15/Method_input!E64)*Method_calculation!D41*D92)+((Method_calculation!D15/Method_input!E64)*Method_calculation!D42*D93))","v":0},"Formula (40)",null,"Note: operating time of the ventilation system with stage k in reheating mode (except for time, when the heat exchanger is bypassed) in current calculation interval or bin\ntv;rh;k =tv;hr;k "]
["6.4.3.10.1 energy output"]
["domestic hot water"]
["maximum energy output of the heat pump to the domestic hot water heating system in current calculation interval","QW;V;hp;out;max","kWh",{"$f":"(Method_input!E35*Method_input!E36*((Method_input!E79*Method_input!E76*D16*Method_input!E23)+(Method_input!E80*Method_input!E77*D17*Method_input!E24)+(Method_input!E81*Method_input!E78*D18*Method_input!E25)))/1000","v":1022.8488192},"Formula (41)"]
["case a) QW;V;hp;out;req > QW;V;hp;out;max",null,"true or false",{"$f":"IF(Method_input!E13>Method_calculation!D101,\"true\",\"false\")","v":"false"}]
["heat generator output of the heat pump to the domestic hot water system","QW;V;gen;hp;out","kWh",{"$f":"D101","v":1022.8488192},"Formula (42a)"]
["residual heat demand required for domestic hot water ","Q*W;out","kWh",{"$f":"Method_input!E13-Method_calculation!D103","v":-822.84881919999998},"Formula (43a)"]
["operating time of the heat pump used for domestic hot water","ton;W","h",{"$f":"Method_input!E23+Method_input!E24+Method_input!E25","v":744},"Formula (44a)"]
["operating time of the heat pump used for domestic hot water with stage 1","ton;W;1","h",{"$f":"Method_input!E23","v":248},"Formula (45a)"]
["operating time of the heat pump used for domestic hot water with stage 2","ton;W;2","h",{"$f":"Method_input!E24","v":248},"Formula (45a)"]
["operating time of the heat pump used for domestic hot water with stage 3","ton;W;3","h",{"$f":"Method_input!E25","v":248},"Formula (45a)"]
["case b) QW;V;hp;out;req ≤ QW;V;hp;out;max",null,"true or false",{"$f":"IF(Method_input!E13<=Method_calculation!D101,\"true\",\"false\")","v":"true"}]
["heat generator output of the heat pump to the domestic hot water system","QW;V;gen;hp;out","kWh",{"$f":"Method_input!E13","v":200},"Formula (42b)"]
["residual heat demand required for domestic hot water ","Q*W;out","kWh",{"$f":"0","v":0},"Formula (43b)"]
["operating time of the heat pump used for domestic hot water","ton;W","h",{"$f":"(D110/D101)*D105","v":145.47604416885463},"Formula (44b)"]
["operating time of the heat pump used for domestic hot water with stage 1","ton;W;1","h",{"$f":"(D110/D101)*Method_input!E23","v":48.492014722951538},"Formula (45b)"]
["operating time of the heat pump used for domestic hot water with stage 2","ton;W;2","h",{"$f":"(D110/D101)*Method_input!E24","v":48.492014722951538},"Formula (45b)"]
["operating time of the heat pump used for domestic hot water with stage 3","ton;W;3","h",{"$f":"(D110/D101)*Method_input!E25","v":48.492014722951538},"Formula (45b)"]
["space heating"]
["maximum energy output in current calculation interval of the extract air heat pump to the heating system","QH;V;hp;out;max","kWh",{"$f":"(Method_input!E35*Method_input!E37*Method_input!E36*(((Method_input!E85/1000)*Method_calculation!D16*Method_input!E82*(Method_input!E23-IF(Method_calculation!D102=\"true\",Method_calculation!D106,Method_calculation!D113)))+((Method_input!E86/1000)*Method_calculation!D17*Method_input!E83*(Method_input!E24-IF(Method_calculation!D102=\"true\",Method_calculation!D107,Method_calculation!D114)))+((Method_input!E87/1000)*Method_calculation!D18*Method_input!E84*(Method_input!E25-IF(Method_calculation!D102=\"true\",Method_calculation!D108,Method_calculation!D115)))))-IF(D102=\"true\",D103,D110)","v":749.831661669136},"Formula (46)"]
["case a) QH;V;hp;out;req > QH;V;hp;out;max",null,"true or false",{"$f":"IF(Method_input!E11>Method_calculation!D117,\"true\",\"false\")","v":"true"}]
["heat generator output of the heat pump to the space heating system","QH;V;gen;hp;out","kWh",{"$f":"D117","v":749.831661669136},"Formula (47a)"]
["residual heat demand required for space heating","Q*H;out","kWh",{"$f":"Method_input!E11-Method_calculation!D119","v":750.168338330864},"Formula (48a)"]
["operating time of the heat pump used for space heating","ton;H","h",{"$f":"(Method_input!E23-IF(Method_calculation!D102=\"true\",D106,D113))+(Method_input!E24-IF(Method_calculation!D102=\"true\",D107,D114))+(Method_input!E25-IF(Method_calculation!D102=\"true\",D108,D115))","v":598.52395583114549},"Formula (49a)"]
["operating time of the heat pump used for space heating with stage 1","ton;H;1","h",{"$f":"Method_input!E23-IF(D102=\"true\",D106,D113)","v":199.50798527704848},"Formula (50a)"]
["operating time of the heat pump used for space heating with stage 2","ton;H;2","h",{"$f":"Method_input!E24-IF(D102=\"true\",D107,D114)","v":199.50798527704848},"Formula (50a)"]
["operating time of the heat pump used for space heating with stage 3","ton;H;3","h",{"$f":"Method_input!E25-IF(D102=\"true\",D108,D115)","v":199.50798527704848},"Formula (50a)"]
["case b) QH;V;hp;out;req ≤ QH;V;hp;out;max",null,"true or false",{"$f":"IF(Method_input!E11<=Method_calculation!D117,\"true\",\"false\")","v":"false"}]
["heat generator output of the heat pump to the space heating system","QH;V;gen;hp;out","kWh",{"$f":"Method_input!E11","v":1500},"Formula (47b)"]
["residual heat demand required for space heating","Q*H;out","kWh",{"$f":"0","v":0},"Formula (48b)"]
["operating time of the heat pump used for space heating","ton;H","h",{"$f":"(D126/D117)*((Method_input!E23-IF(Method_calculation!D102=\"true\",Method_calculation!D106,Method_calculation!D113))+(Method_input!E24-IF(Method_calculation!D102=\"true\",Method_calculation!D107,Method_calculation!D114))+(Method_input!E25-IF(Method_calculation!D102=\"true\",Method_calculation!D108,Method_calculation!D115)))","v":1197.3166507109527},"Formula (49b)"]
["operating time of the heat pump used for space heating with stage 1","ton;H;1","h",{"$f":"(D126/D117)*(Method_input!E23-IF(D102=\"true\",D106,D113))","v":399.10555023698424},"Formula (50b)"]
["operating time of the heat pump used for space heating with stage 2","ton;H;2","h",{"$f":"(D126/D117)*(Method_input!E24-IF(D102=\"true\",D107,D114))","v":399.10555023698424},"Formula (50b)"]
["operating time of the heat pump used for space heating with stage 3","ton;H;3","h",{"$f":"(D126/D117)*(Method_input!E25-IF(D102=\"true\",D108,D115))","v":399.10555023698424},"Formula (50b)"]
["space cooling"]
["maximum energy output in current calculation interval of the extract air heat pump to the cooling system","QC;V;hp;in;max","kWh",{"$f":"(((Method_input!E91/1000)*Method_input!E88*Method_calculation!D16*(Method_input!E23-IF(Method_calculation!D102=\"true\",Method_calculation!D106,Method_calculation!D113)))+((Method_input!E92/1000)*Method_input!E89*Method_calculation!D17*(Method_input!E24-IF(D102=\"true\",D107,D114)))+((Method_input!E93/1000)*Method_input!E90*D18*(Method_input!E25-IF(D102=\"true\",D108,D115))))","v":619.67627124938281},"Formula (51)"]
["case a) QC;V;hp;in;req > QC;V;hp;in;max",null,"true or false",{"$f":"IF(Method_input!E12>Method_calculation!D133,\"true\",\"false\")","v":"false"}]
["heat generator output of the heat pump to the space cooling system","QC;V;gen;hp;in","kWh",{"$f":"D133","v":619.67627124938281},"Formula (52a)"]
["residual heat demand required for space cooling","Q*C;in","kWh",{"$f":"Method_input!E12-Method_calculation!D135","v":-619.67627124938281},"Formula (53a)"]
["operating time of the heat pump used for space cooling","ton;C","h",{"$f":"(Method_input!E23-IF(D102=\"true\",D106,D113))+(Method_input!E24-IF(D102=\"true\",D107,D114))+(Method_input!E25-IF(D102=\"true\",D108,D115))","v":598.52395583114549},"Formula (54a)"]
["operating time of the heat pump used for space cooling with stage 1","ton;C;1","h",{"$f":"Method_input!E23-IF(D102=\"true\",Method_calculation!D106,Method_calculation!D113)","v":199.50798527704848},"Formula (55a)"]
["operating time of the heat pump used for space cooling with stage 2","ton;C;2","h",{"$f":"Method_input!E24-IF(D102=\"true\",Method_calculation!D107,Method_calculation!D114)","v":199.50798527704848},"Formula (55a)"]
["operating time of the heat pump used for space cooling with stage 3","ton;C;3","h",{"$f":"Method_input!E25-IF(D102=\"true\",Method_calculation!D108,Method_calculation!D115)","v":199.50798527704848},"Formula (55a)"]
["case b) QC;V;hp;in;req ≤ QC;V;hp;in;max",null,"true or false",{"$f":"IF(Method_input!E12<=Method_calculation!D133,\"true\",\"false\")","v":"true"}]
["heat generator output of the heat pump to the space cooling system","QC;V;gen;hp;in","kWh",{"$f":"Method_input!E12","v":0},"Formula (52b)"]
["residual heat demand required for space cooling","Q*C;in","kWh",{"$f":"0","v":0},"Formula (53b)"]
["operating time of the heat pump used for space cooling","ton;C","h",{"$f":"(D142/D133)*((Method_input!E23-IF(D102=\"true\",D106,D113))+(Method_input!E24-IF(D102=\"true\",D107,D114))+(Method_input!E25-IF(D102=\"true\",D108,D115)))","v":0},"Formula (54b)"]
["operating time of the heat pump used for space cooling with stage 1","ton;C;1","h",{"$f":"(D142/D133)*(Method_input!E23-IF(D102=\"true\",D106,D113))","v":0},"Formula (55b)"]
["operating time of the heat pump used for space cooling with stage 2","ton;C;2","h",{"$f":"(D142/D133)*(Method_input!E24-IF(D102=\"true\",D107,D114))","v":0},"Formula (55b)"]
["operating time of the heat pump used for space cooling with stage 3","ton;C;3","h",{"$f":"(D142/D133)*(Method_input!E25-IF(D102=\"true\",D108,D115))","v":0},"Formula (55b)"]
["6.4.3.10.2 energy input"]
["domestic hot water"]
["electrical input of heat pump for domestic hot water","EW;V;hp;in","kWh",{"$f":"((Method_input!E79/1000)*Method_calculation!D16*IF(D102=\"true\",D106,D113))+((Method_input!E80/1000)*Method_calculation!D17*IF(D102=\"true\",D107,D114))+((Method_input!E81/1000)*Method_calculation!D18*IF(D102=\"true\",D108,D115))","v":61.728395061728392},"Formula (56)"]
["space heating"]
["electrical input of heat pump for space heating","EH;V;hp;in","kWh",{"$f":"((Method_input!E85/1000)*Method_calculation!D16*IF(Method_calculation!D118=\"true\",Method_calculation!D122,Method_calculation!D129))+((Method_input!E86/1000)*Method_calculation!D17*IF(Method_calculation!D118=\"true\",Method_calculation!D123,Method_calculation!D130))+((Method_input!E87/1000)*Method_calculation!D18*IF(Method_calculation!D118=\"true\",Method_calculation!D124,Method_calculation!D131))","v":253.96568493827164},"Formula (57)"]
["space cooling"]
["electrical input of heat pump for space cooling","EC;V;hp;in","kWh",{"$f":"((Method_input!E91/1000)*Method_calculation!D16*IF(Method_calculation!D134=\"true\",Method_calculation!D138,Method_calculation!D145))+((Method_input!E92/1000)*Method_calculation!D17*IF(Method_calculation!D134=\"true\",Method_calculation!D139,Method_calculation!D146))+((Method_input!E93/1000)*Method_calculation!D18*IF(Method_calculation!D134=\"true\",Method_calculation!D140,Method_calculation!D147))","v":0},"Formula (58)"]

{"sheet":"Method_output","index":10,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["THIS IS A MANDATORY SHEET\nOutput of one step calculation shall be indicated here.\nEach cell in the column value shall be a reference to a single cell in the \"Method_calculation\" sheet.\nThe macro will take the calculation step results and fill the values table in the \"Output_series\" sheet."]
[]
[]
["Name","Symbol","Software name","Unit","Value","Range","Intended destination","Varying","Notes"]
["Energy flow data"]
["electrical input of heat pump for domestic hot water","EW;V;hp;in","E_W_V_hp_in","kWh",{"$f":"Method_calculation!D150","v":61.728395061728392},"0...∞","M1-9","Yes"]
["electrical input of heat pump for space heating","EH;V;hp;in","E_H_V_hp_in","kWh",{"$f":"Method_calculation!D152","v":253.96568493827164},"0...∞","M1-9","Yes"]
["electrical input of heat pump for cooling","EC;V;hp;in","E_C_V_hp_in","kWh",{"$f":"Method_calculation!D154","v":0},"0...∞","M1-9","Yes"]
["ventilation fan energy","EV;gen;fan","E_V_gen_fan","kWh",{"$f":"Method_calculation!D74","v":84.587973778285715},"0...∞","M1-9, M5-4","Yes"]
["ventilation auxiliary energy","WV;aux","W_V_aux","kWh",{"$f":"Method_calculation!D77","v":32.124390364839194},"0...∞","M1-9, M5-4","Yes"]
["recoverable duct heat losses","Qls;V;dis;rbl","Q_ls_V_dis_rbl","kWh",{"$f":"Method_calculation!D67","v":0},"0...∞","M2-2","Yes"]
["recoverable AHU heat losses","Qls;V;gen;rbl","Q_ls_V_gen_rbl","kWh",{"$f":"Method_calculation!D72","v":25.557473507186224},"0...∞","M2-2","Yes"]
["required AHU heating coil input","QH;V;in;req","Q_H_V_in_req","kWh",{"$f":"Method_calculation!D98","v":0},"0...∞","M3-1","Yes"]
["energy output of heat pump to domestic hot water system","QW;V;gen;hp;out","Q_W_V_gen_hp_out","kWh",{"$f":"IF(Method_calculation!D102=\"true\",Method_calculation!D103,Method_calculation!D110)","v":200},"0...∞","M8-1","Yes"]
["energy extracted by the heat pump from the cooling system","QC;V;gen;hp;in","Q_C_V_gen_hp_in","kWh",{"$f":"IF(Method_calculation!D134=\"true\",Method_calculation!D135,Method_calculation!D142)","v":0},"0...∞","M4-1","Yes"]
["energy output of heat pump to the space heating system","QH;V;gen;hp;out","Q_H_V_gen_hp_out","kWh",{"$f":"IF(Method_calculation!D118=\"true\",Method_calculation!D119,Method_calculation!D126)","v":749.831661669136},"0...∞","M3-1","Yes"]
["duct heat losses","Qls;V;dis","Q_ls_V_dis","kWh",{"$f":"Method_calculation!D66","v":35.730360289379085},"0...∞","M5-4","Yes"]
["overall heat losses of the AHU","Qls;V;gen","Q_ls_V_gen","kWh",{"$f":"Method_calculation!D69","v":25.557473507186224},"0...∞","M5-4","Yes"]
["heat transferred by heat recovery","Qhr","Q_hr","kWh",{"$f":"Method_calculation!D94","v":0},"-∞...∞","M5-4","Yes"]
[]
["Operating condition data"]
["mean duct leakage volume flow going to zone with stage 1","qV;lea;SUP;dis;1","q_V_lea_SUP_dis_1","m³/h",{"$f":"Method_calculation!D21","v":2.9702400000000031},"0...∞","M5-5","Yes"]
["mean duct leakage volume flow going to zone with stage 2","qV;lea;SUP;dis;2","q_V_lea_SUP_dis_2","m³/h",{"$f":"Method_calculation!D22","v":4.2432000000000034},"0...∞","M5-5","Yes"]
["mean duct leakage volume flow going to zone with stage 3","qV;lea;SUP;dis;3","q_V_lea_SUP_dis_3","m³/h",{"$f":"Method_calculation!D23","v":5.5161600000000046},"0...∞","M5-5","Yes"]
["supply volume flow rate with stage 1 going to the zone served by the system","qV;SUP;dis;1","q_V_SUP_dis_1","m³/h",{"$f":"Method_calculation!D12","v":148.51200000000003},"0...∞",null,"Yes"]
["supply volume flow rate with stage 2 going to the zone served by the system","qV;SUP;dis;2","q_V_SUP_dis_2","m³/h",{"$f":"Method_calculation!D13","v":212.16},"0...∞",null,"Yes"]
["supply volume flow rate with stage 3 going to the zone served by the system","qV;SUP;dis;3","q_V_SUP_dis_3","m³/h",{"$f":"Method_calculation!D14","v":275.80799999999999},"0...∞",null,"Yes"]
["mean supply volume flow going to zone","qV;SUP;dis","q_V_SUP_dis","m³/h",{"$f":"Method_calculation!D15","v":212.16000000000003},"0...∞","M5-5","Yes"," "]
["mean duct leakage volume flow from the zone with stage 1","qV;lea;ETA;dis;1","q_V_lea_ETA_dis_1","m³/h",{"$f":"Method_calculation!D24","v":2.9702400000000031},"0...∞","M5-5","Yes"]
["mean duct leakage volume flow from the zone with stage 2","qV;lea;ETA;dis;2","q_V_lea_ETA_dis_2","m³/h",{"$f":"Method_calculation!D25","v":4.2432000000000034},"0...∞","M5-5","Yes"]
["mean duct leakage volume flow from the zone with stage 3","qV;lea;ETA;dis;3","q_V_lea_ETA_dis_3","m³/h",{"$f":"Method_calculation!D26","v":5.5161600000000046},"0...∞","M5-5","Yes"]
["extract volume flow rate with stage 1 from the zone served by the system","qV;ETA;dis;1","q_V_ETA_dis_1","m³/h",{"$f":"Method_calculation!D16","v":148.51200000000003},"0...∞",null,"Yes"]
["extract volume flow rate with stage 2 from the zone served by the system","qV;ETA;dis;2","q_V_ETA_dis_2","m³/h",{"$f":"Method_calculation!D17","v":212.16},"0...∞",null,"Yes"]
["extract volume flow rate with stage 3 from the zone served by the system","qV;ETA;dis;3","q_V_ETA_dis_3","m³/h",{"$f":"Method_calculation!D18","v":275.80799999999999},"0...∞",null,"Yes"]
["mean extract volume flow from the zone","qV;ETA;dis","q_V_ETA_dis","m³/h",{"$f":"Method_calculation!D19","v":212.16000000000003},"0...∞","M5-5","Yes"]
["supply air temperature with stage 1","ϑSUP;dis;out;1","theta_SUP_dis_out_1","°C",{"$f":"Method_calculation!D43","v":17.318487434292422},"0…60","M5-5","Yes"]
["supply air temperature with stage 2","ϑSUP;dis;out;2","theta_SUP_dis_out_2","°C",{"$f":"Method_calculation!D44","v":17.836804991526702},"0…60","M5-5","Yes"]
["supply air temperature with stage 3","ϑSUP;dis;out;3","theta_SUP_dis_out_3","°C",{"$f":"Method_calculation!D45","v":17.875417193469431},"0…60","M5-5","Yes"]
[]
["Other data"]

{"sheet":"Output_series","index":11,"n_rows":33,"n_cols":38,"rows_kept":33,"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,33]
[]
["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,"electrical input of heat pump for domestic hot water","electrical input of heat pump for space heating","electrical input of heat pump for cooling","ventilation fan energy","ventilation auxiliary energy","recoverable duct heat losses","recoverable AHU heat losses","required AHU heating coil input","energy output of heat pump to domestic hot water system","energy extracted by the heat pump from the cooling system","energy output of heat pump to the space heating system","duct heat losses","Overall heat losses of the AHU","heat transferred by heat recovery",null,null,"mean duct leakage volume flow going to zone with stage 1","mean duct leakage volume flow going to zone with stage 2","mean duct leakage volume flow going to zone with stage 3","supply volume flow rate with stage 1 going to the zone served by the system","supply volume flow rate with stage 2 going to the zone served by the system","supply volume flow rate with stage 3 going to the zone served by the system","mean supply volume flow going to zone","mean duct leakage volume flow from the zone with stage1","mean duct leakage volume flow from the zone with stage2","mean duct leakage volume flow from the zone with stage3","extract volume flow rate with stage 1 from the zone served by the system","extract volume flow rate with stage 2 from the zone served by the system","extract volume flow rate with stage 3 from the zone served by the system","mean extract volume flow from the zone","supply air temperature with stage 1","supply air temperature with stage 2","supply air temperature with stage 3",null,"mean supply air temperature","mean duct leckage supply volume flow going to zone","mean duct leckage extract volume flow from the zone"]
["Symbol","EW;V;hp;in","EH;V;hp;in","EC;V;hp;in","EV;gen;fan","WV;aux","Qls;V;dis;rbl","Qls;V;gen;rbl","QH;V;in;req","QW;V;gen;hp;out","QC;V;gen;hp;in","QH;V;gen;hp;out","Qls;V;dis","Qls;V;gen","Qhr",null,null,"qV;lea;SUP;dis;1","qV;lea;SUP;dis;2","qV;lea;SUP;dis;3","qV;SUP;dis;1","qV;SUP;dis;2","qV;SUP;dis;3","qV;SUP;dis","qV;lea;ETA;dis;1","qV;lea;ETA;dis;2","qV;lea;ETA;dis;3","qV;ETA;dis;1","qV;ETA;dis;2","qV;ETA;dis;3","qV;ETA;dis","ϑSUP;dis;out;1","ϑSUP;dis;out;2","ϑSUP;dis;out;3",null,"ϑSUP;dis;out","qV;lea;SUP;dis","qV;lea;ETA;dis"]
["Unit","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh",null,null,"m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","m³/h","°C","°C","°C",null,"°C","m³/h","m³/h"]
["Destination","M1-9","M1-9","M1-9","M1-9, M5-4","M1-9, M5-4","M2-2","M2-2","M3-1","M8-1","M4-1","M3-1","M5-4","M5-4","M5-4",null,null,"M5-5","M5-5","M5-5",null,null,null,"M5-5","M5-5","M5-5","M5-5",null,null,null,"M5-5","M5-5","M5-5","M5-5",null,"M5-5","M5-5","M5-5"]
["Time stamp"]
["January",61.728395061728392,253.96568493827164,0,84.587973778285715,32.125906541650444,0,25.743473507186227,0,200,0,749.831661669136,35.834100217229881,25.743473507186227,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,17.337735688369815,17.853898636969674,17.892720162937117,null,{"$f":"((AF18*Input_series!S14)+(AG18*Input_series!T14)+(AH18*Input_series!U14))/Input_series!V14","v":17.694784829425533},{"$f":"((R18*Input_series!S14)+(S18*Input_series!T14)+(T18*Input_series!U14))/Input_series!V14","v":4.2432000000000034},{"$f":"((Y18*Input_series!S14)+(Z18*Input_series!T14)+(AA18*Input_series!U14))/Input_series!V14","v":4.2432000000000034}]
["February",61.728395061728392,223.41464493827164,0,76.402040832000012,31.420214667604142,0,24.317335688689116,0,200,0,635.57077206913596,33.209589287123833,24.317335688689116,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,17.510969975066342,18.007741445956434,18.048446888146305,null,{"$f":"((AF19*Input_series!S15)+(AG19*Input_series!T15)+(AH19*Input_series!U15))/Input_series!V15","v":17.855719436389695},{"$f":"((R19*Input_series!S15)+(S19*Input_series!T15)+(T19*Input_series!U15))/Input_series!V15","v":4.2432000000000034},{"$f":"((Y19*Input_series!S15)+(Z19*Input_series!T15)+(AA19*Input_series!U15))/Input_series!V15","v":4.2432000000000034}]
["March",61.728395061728392,253.96568493827164,0,84.587973778285715,7.4399999999999995,0,32.625473507186229,0,200,0,749.831661669136,39.672477547709562,32.625473507186229,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,18.049921089233308,18.486363518359681,18.532930033241549,null,{"$f":"((AF20*Input_series!S16)+(AG20*Input_series!T16)+(AH20*Input_series!U16))/Input_series!V16","v":18.356404880278181},{"$f":"((R20*Input_series!S16)+(S20*Input_series!T16)+(T20*Input_series!U16))/Input_series!V16","v":4.2432000000000034},{"$f":"((Y20*Input_series!S16)+(Z20*Input_series!T16)+(AA20*Input_series!U16))/Input_series!V16","v":4.2432000000000034}]
["April",61.728395061728392,243.78200493827165,0,81.859329462857147,7.1999999999999993,0,39.524094234353868,0,200,0,711.74469846913598,42.910426742899034,39.524094234353868,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,18.916092522715928,19.255577563293468,19.311563659287483,null,{"$f":"((AF21*Input_series!S17)+(AG21*Input_series!T17)+(AH21*Input_series!U17))/Input_series!V17","v":19.161077915098961},{"$f":"((R21*Input_series!S17)+(S21*Input_series!T17)+(T21*Input_series!U17))/Input_series!V17","v":4.2432000000000043},{"$f":"((Y21*Input_series!S17)+(Z21*Input_series!T17)+(AA21*Input_series!U17))/Input_series!V17","v":4.2432000000000043}]
["May",61.728395061728392,169.34846707655714,0,84.587973778285715,7.4399999999999995,0,45.112840273803513,0,200,0,500,49.424030765684982,45.112840273803513,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,19.85925697250812,20.093166189999149,20.159409163204163,null,{"$f":"((AF22*Input_series!S18)+(AG22*Input_series!T18)+(AH22*Input_series!U18))/Input_series!V18","v":20.037277441903811},{"$f":"((R22*Input_series!S18)+(S22*Input_series!T18)+(T22*Input_series!U18))/Input_series!V18","v":4.2432000000000034},{"$f":"((Y22*Input_series!S18)+(Z22*Input_series!T18)+(AA22*Input_series!U18))/Input_series!V18","v":4.2432000000000034}]
["June",61.728395061728392,0,204.91803278688528,81.859329462857147,7.1999999999999993,0,24.918700154566491,0,200,500,0,22.957020663197515,24.918700154566491,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,22.964969255966661,22.910546569490492,22.877199124297569,null,{"$f":"((AF23*Input_series!S19)+(AG23*Input_series!T19)+(AH23*Input_series!U19))/Input_series!V19","v":22.917571649918237},{"$f":"((R23*Input_series!S19)+(S23*Input_series!T19)+(T23*Input_series!U19))/Input_series!V19","v":4.2432000000000043},{"$f":"((Y23*Input_series!S19)+(Z23*Input_series!T19)+(AA23*Input_series!U19))/Input_series!V19","v":4.2432000000000043}]
["July",61.728395061728392,0,253.96568493827164,84.587973778285715,7.4399999999999995,0,31.954182251373027,0,200,619.67627124938281,0,26.499957524512521,31.954182251373027,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,23.407679099746669,23.395046568300707,23.385812522631785,null,{"$f":"((AF24*Input_series!S20)+(AG24*Input_series!T20)+(AH24*Input_series!U20))/Input_series!V20","v":23.396179396893054},{"$f":"((R24*Input_series!S20)+(S24*Input_series!T20)+(T24*Input_series!U20))/Input_series!V20","v":4.2432000000000034},{"$f":"((Y24*Input_series!S20)+(Z24*Input_series!T20)+(AA24*Input_series!U20))/Input_series!V20","v":4.2432000000000034}]
["August",61.728395061728392,0,253.96568493827164,84.587973778285715,7.4399999999999995,0,31.210182251373041,0,200,619.67627124938281,0,26.016878769867574,31.210182251373041,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,23.330686083437101,23.310785698942411,23.297358018573661,null,{"$f":"((AF25*Input_series!S21)+(AG25*Input_series!T21)+(AH25*Input_series!U21))/Input_series!V21","v":23.312943266984391},{"$f":"((R25*Input_series!S21)+(S25*Input_series!T21)+(T25*Input_series!U21))/Input_series!V21","v":4.2432000000000034},{"$f":"((Y25*Input_series!S21)+(Z25*Input_series!T21)+(AA25*Input_series!U21))/Input_series!V21","v":4.2432000000000034}]
["September",61.728395061728392,171.25663560446102,0,81.859329462857147,7.1999999999999993,0,44.469200264971128,0,200,0,500,48.030494149728952,44.469200264971128,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,19.897753480662903,20.127353480885095,20.194015102139538,null,{"$f":"((AF26*Input_series!S22)+(AG26*Input_series!T22)+(AH26*Input_series!U22))/Input_series!V22","v":20.073040687895844},{"$f":"((R26*Input_series!S22)+(S26*Input_series!T22)+(T26*Input_series!U22))/Input_series!V22","v":4.2432000000000043},{"$f":"((Y26*Input_series!S22)+(Z26*Input_series!T22)+(AA26*Input_series!U22))/Input_series!V22","v":4.2432000000000043}]
["October",61.728395061728392,253.96568493827164,0,84.587973778285715,7.4399999999999995,0,41.553473507186226,0,200,0,749.831661669136,44.651994084548065,41.553473507186226,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,18.973837284948104,19.306858499622386,19.363472567690543,null,{"$f":"((AF27*Input_series!S23)+(AG27*Input_series!T23)+(AH27*Input_series!U23))/Input_series!V23","v":19.214722784087009},{"$f":"((R27*Input_series!S23)+(S27*Input_series!T23)+(T27*Input_series!U23))/Input_series!V23","v":4.2432000000000034},{"$f":"((Y27*Input_series!S23)+(Z27*Input_series!T23)+(AA27*Input_series!U23))/Input_series!V23","v":4.2432000000000034}]
["November",61.728395061728392,243.78200493827165,0,81.859329462857147,7.1999999999999993,0,30.344094234353854,0,200,0,711.74469846913598,37.790359336069109,30.344094234353854,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,17.934431564768953,18.383801645701844,18.429112216435424,null,{"$f":"((AF28*Input_series!S24)+(AG28*Input_series!T24)+(AH28*Input_series!U24))/Input_series!V24","v":18.249115142302077},{"$f":"((R28*Input_series!S24)+(S28*Input_series!T24)+(T28*Input_series!U24))/Input_series!V24","v":4.2432000000000043},{"$f":"((Y28*Input_series!S24)+(Z28*Input_series!T24)+(AA28*Input_series!U24))/Input_series!V24","v":4.2432000000000043}]
["December",61.728395061728392,253.96568493827164,0,84.587973778285715,32.124390364839194,0,25.557473507186224,0,200,0,749.831661669136,35.730360289379085,25.557473507186224,0,null,null,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,2.9702400000000031,4.2432000000000034,5.5161600000000046,148.51200000000003,212.16,275.80799999999999,212.16000000000003,17.318487434292422,17.836804991526702,17.875417193469431,null,{"$f":"((AF29*Input_series!S25)+(AG29*Input_series!T25)+(AH29*Input_series!U25))/Input_series!V25","v":17.676903206429518},{"$f":"((R29*Input_series!S25)+(S29*Input_series!T25)+(T29*Input_series!U25))/Input_series!V25","v":4.2432000000000034},{"$f":"((Y29*Input_series!S25)+(Z29*Input_series!T25)+(AA29*Input_series!U25))/Input_series!V25","v":4.2432000000000034}]
[]
["SUM (absolute value)",{"$f":"ABS(B18)+ABS(B19)+ABS(B20)+ABS(B21)+ABS(B22)+ABS(B23)+ABS(B24)+ABS(B25)+ABS(B26)+ABS(B27)+ABS(B28)+ABS(B29)","v":740.74074074074076},{"$f":"ABS(C18)+ABS(C19)+ABS(C20)+ABS(C21)+ABS(C22)+ABS(C23)+ABS(C24)+ABS(C25)+ABS(C26)+ABS(C27)+ABS(C28)+ABS(C29)","v":2067.44649724892},{"$f":"ABS(D18)+ABS(D19)+ABS(D20)+ABS(D21)+ABS(D22)+ABS(D23)+ABS(D24)+ABS(D25)+ABS(D26)+ABS(D27)+ABS(D28)+ABS(D29)","v":712.84940266342846},995.95517513142863,161.67051157409378,0,397.33052338222893,0,2400,1739.3525424987656,6058.3868156839526,442.72768937795013,397.33052338222893,{"$f":"ABS(O18)+ABS(O19)+ABS(O20)+ABS(O21)+ABS(O22)+ABS(O23)+ABS(O24)+ABS(O25)+ABS(O26)+ABS(O27)+ABS(O28)+ABS(O29)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arithmetic mean",null,null,{"$f":"AVERAGE(R18:R29)","v":2.9702400000000035},4.2432000000000025,5.5161600000000055,148.512,212.16,275.80799999999999,212.16,2.9702400000000035,4.2432000000000025,5.5161600000000055,148.512,212.16,275.80799999999999,212.16,{"$f":"AVERAGE(AF18:AF29)","v":19.62515170430969},{"$f":"AVERAGE(AG18:AG29)","v":19.913995400754001},19.947288054337879,null,19.828811719800527,4.2432000000000025,4.2432000000000025]

{"sheet":"Graphs","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Greek_to_soft","index":13,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,2,27,4]]}
[]
[null,"Greek","Software","Greek capital","Software"]
[null,"α","alpha","(A)","A"]
[null,"β ","beta","(B)","B"]
[null,"γ","gamma","Γ","Gamma"]
[null,"δ","delta","Δ","Delta"]
[null,"ε","epsilon","(Ε)","E"]
[null,"ζ","zeta","(Ζ)","Z"]
[null,"η","eta","(Η)","H"]
[null,"ϑ (var. θ)","theta","Θ","Theta"]
[null,"(ι)","iota","(Ι)","I"]
[null,"(κ)","kappa","(Κ)","K"]
[null,"λ","lambda","Λ","Lambda"]
[null,"μ","mu","(Μ)","M"]
[null,"(ν)","nu","(Ν)","N"]
[null,"ξ","xi","Ξ","XI"]
[null,"(ο)","omicron","(Ο)","O"]
[null,"π","pi","Π","Pi"]
[null,"ρ","rho","(Ρ)","P"]
[null,"σ (var. ς)","sigma","Σ","Sigma"]
[null,"(τ)","tau","(Τ)","T"]
[null,"(υ)","upsilon","Υ","Y"]
[null," φ (var. ϕ)","phi","Φ","Phi"]
[null,"(χ)","chi","(Χ)","X"]
[null,"ψ","psi","Ψ","Psi"]
[null,"ω","omega","Ω","Omega"]
[]
[null,null,"Do not use these letters: risk of confusion with latin alphabet"]

{"sheet":"Symbols","index":14,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[[10,3,12,3],[10,4,12,4]]}
[]
[null,null,null,"Symbol","Meaning","Unit"]
[null,null,null,"A","area","m²"]
[null,null,null,"b","temperature reduction factor","-"]
[null,null,null,"C","heat capacity ","J/K a)"]
[null,null,null,"c","specific heat capacity ","J/(kg•K) a)"]
[null,null,null,"c","coefficient d)  ","various"]
[null,null,null,"d","thickness","m"]
[null,null,null,"D","diameter","m"]
[null,null,null,"E","energy in general e)","kg, m3, (kW•h), J a) b)"]
[null,null,null,"EP","energy performance indicator","J/(m2•a),"]
[null,null,null,null,null,"kg/(m2•a),"]
[null,null,null,null,null,"€/(m2•a) a) c) "]
[null,null,null,"f","factor (e.g. primary energy factor, policy factor, …)","– d)"]
[null,null,null,"H","heat transfer coefficient","W/K"]
[null,null,null,"H","calorific value","MJ/kg"]
[null,null,null,"h","surface coefficient of heat transfer ","W/(m²•K)"]
[null,null,null,"I","solar irradiance","W/m2"]
[null,null,null,"k","coefficient","d)"]
[null,null,null,"K","CO2 emission coefficient","kg/J; g/(kW•h)"]
[null,null,null,"L","length","m"]
[null,null,null,"m","mass (e.g. quantity of CO2 emissions)","kg"]
[null,null,null,"n","air exchange rate","1/h"]
[null,null,null,"N","number of items (integer only)","–"]
[null,null,null,"O","occupancy","persons"]
[null,null,null,"p","pressure","Pa"]
[null,null,null,"P","power in general including electrical power","W"]
[null,null,null,"Q","quantity of heat","J, (kW•h) a)"]
[null,null,null,"q","volumetric airflow rate","m3/s"]
[null,null,null,"q","heat flow density","W/m²"]
[null,null,null,"R","thermal resistance","m²·K/W"]
[null,null,null,"RER","renewable energy ratio","–"]
[null,null,null,"T","thermodynamic temperature","K"]
[null,null,null,"t","time, period of time","s a)"]
[null,null,null,"U","thermal transmittance ","W/(m²•K)"]
[null,null,null,"V","volume","m³"]
[null,null,null,"W","(electrical) auxiliary energy","(kW•h), J a)"]
[null,null,null,"x","mixing ratio","%kg/kg"]
[null,null,null,"X","volume fraction","%"]
[null,null,null,"X, Y","any property, system, …","–"]
[null,null,null,"Δ","delta (difference) prefix to be combined with symbols","various"]
[null,null,null,"h","efficiency factor","-"]
[null,null,null,"φ","relative humidity","%"]
[null,null,null,"ϑ","Celsius temperature  ","°C"]
[null,null,null,"ψ","linear thermal transmittance ","W/(m•K)"]
[null,null,null,"Φ","heat flow rate, thermal power","W"]
[null,null,null,"χ","point thermal transmittance","W/K"]
[null,null,null,"ρ","density","kg/m³"]
[null,null,null,"τ","time constant","s a)"]
[null,null,null,"τ","light transmittance","?"]
[null,null,null,"…","… your new symbol …","…"]
[]
[]
[]
[]
[]
[]
[null,null,null,"a)","Hours (h) may be used as the unit of time instead of seconds for all quantities involving time (i.e. for time periods as well as for air change rates), but in that case the unit of energy is (W•h) instead of J."]
[null,null,null,"b)","The unit depends on the type of energy carrier."]
[null,null,null,"c)","The unit depends on the indicator chosen"]
[null,null,null,"d)","Coefficients have dimensions; factors are dimensionless."]
[null,null,null,"e)","Including primary energy and energy carriers; note that for heat the symbol Q and for auxiliary energy and work the symbol W is used."]

{"sheet":"Subs_building","index":15,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[3,5,3,6],[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
[]
[null,"COMMON SUBSCRIPTS: BUILDING"]
[]
[null,"Level 1",null,"Level 2",null,"Level 3"]
[null,"Service",null,"Building",null,"Utilised or non-utilised"]
[null,"H","heating","nd","need","ut","utilised"]
[null,"C","cooling","ht","heat transfer","nut","non-utilised"]
[null,"W","DHW","tr","transmission heat transfer","…","… your new subscript"]
[null,"V","ventilation","ve","ventilation heat transfer"]
[null,"HU","Humidification","gn","gains"]
[null,"DHU","Dehumidification","sol","solar"]
[null,"L","lighting","int","internal"]
[null,"BAC","Building automation and control","sens","sensible"]
[null,"E","Photovoltaic, wind","lat","latent"]
[null,"XY","combination  of H, C, W","…","… your new subscript"]
[null,"EPus","EPB services"]
[null,"nEPus","non EPB services"]
[null,"TOT","total"]
[null,"A","appliances"]
[null,"T","transport"]
[null,"…","… your new subscript"]
[]
[]
[]
[]
[]
[]
[null,"Please insert any new subscript in the yellow field"]

{"sheet":"Subs_system","index":16,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10]]}
[]
[null,"COMMON SUBSCRIPTS: ENERGY EXCHANGE BETWEEN SUBSYSTEMS"]
[]
[null,"Level 1",null,"Level 2",null,"Level 3",null,"Level 4",null,"Level 5"]
[null,"Service",null,"Technical building system",null,"Balance item",null,"Balance item specification",null,"Destination of recovery (service)"]
[null,"H","heating","us","use","ls","losses","rbl","recoverable","H","heating"]
[null,"C","cooling","sys","system","aux","auxiliary","rvd","recovered","C","cooling"]
[null,"W","DHW","em","emission","in","input","nrbl","non-recoverable","W","DHW"]
[null,"V","ventilation","dis","distribution","out","output","nrvd","non-recovered","V","ventilation"]
[null,"HU","Humidification","sto","storage","…","… your new subscript","…","… your new subscript","HU","Humidification"]
[null,"DHU","Dehumidification","nod","node",null,null,null,null,"DHU","Dehumidification"]
[null,"L","lighting","gen","generation",null,null,null,null,"L","lighting"]
[null,"BAC","BAC","hum","humidification a",null,null,null,null,"BAC","BAC"]
[null,"E","Photovoltaic, wind","dhum","dehumidification a",null,null,null,null,"E","Photovoltaic, wind"]
[null,"XY","combination  of H, C, W","hp","heat pump",null,null,null,null,"XY","combination  of H, C, W"]
[null,"EPus","EPBD services","blr","boiler",null,null,null,null,"EPus","EPBD services"]
[null,"nEPus","non EPBD services","cgn","cogeneration",null,null,null,null,"nEPus","non EPBD services"]
[null,"TOT","total","ts","thermal solar",null,null,null,null,"TOT","total"]
[null,"A","appliances","pv","Photovoltaic",null,null,null,null,"A","appliances"]
[null,"T","transport","lrh","local and radiant heaters",null,null,null,null,"T","transport"]
[null,"…","… your new subscript","…","… your new subscript",null,null,null,null,"…","… your new subscript"]
[]
[]
[]
[]
[null,"Please insert any new subscript in the yellow field"]

{"sheet":"Subs_del_EP","index":17,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[[44,7,46,8],[49,7,49,8],[50,7,50,8],[49,5,49,6],[50,5,50,6],[56,7,56,8],[57,5,57,6],[57,7,57,8],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,4,57,4],[49,1,50,1],[49,2,50,2],[49,3,50,3],[49,4,50,4],[56,5,56,6],[41,5,41,6],[41,7,41,8],[42,1,43,2],[42,3,43,4],[42,5,42,6],[42,7,43,8],[43,5,43,6],[41,1,41,2],[41,3,41,4],[31,7,31,8],[32,5,32,6],[32,7,32,8],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,23,6],[23,7,23,8],[24,5,24,6],[24,7,24,8],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,31,6],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[4,1,5,2],[4,3,5,4],[4,5,4,6],[4,7,4,8],[5,5,5,6],[5,7,5,8]]}
[]
[null,"COMMON SUBSCRIPTS: ENERGY FLOWS AT ASSESSMENT BOUNDARY"]
[]
[null,"Level 1",null,"Level 2",null,"Level 3"]
[null,"Type of energy flow",null,"Energy carrier",null,"Qualifier "]
[null,null,null,null,null,"which service"]
[null,"del","delivered","gas","gas","H","heating"]
[null,"exp","exported","oil","oil","C","cooling"]
[null,"pr","produced","el","electricity","W","DHW"]
[null,"EPus","used for EPBD services","wd","wood","V","ventilation"]
[null,"nEPus","used for services other than EPBD","dh","district heating","HU","Humidification"]
[null,"…","… your new subscript","dc","district cooling","DHU","Dehumidification"]
[null,null,null,"sf","solid fuel","L","lighting"]
[null,null,null,"lf","liquid fuel","BAC","BAC"]
[null,null,null,"bm","biomass","E","Photovoltaic, wind"]
[null,null,null,"sol","solar heat","XY","combination  of H, C, W"]
[null,null,null,"pv","solar electricity","EPus","EPBD services"]
[null,null,null,"ah","Heat from surroundings","nEPus","non EPBD services"]
[null,null,null,"wnd","wind","TOT","total"]
[null,null,null,"cr","carrier (generic)","A","appliances"]
[null,null,null,"…","… your new subscript","T","transport"]
[null,null,null,null,null,"…","… your new subscript"]
[]
[null,null,null,null,null,"Qualifier "]
[null,null,null,null,null,"Origin"]
[null,null,null,null,null,"onst","on site"]
[null,null,null,null,null,"ofst","off site"]
[null,null,null,null,null,"nrby","neardy"]
[null,null,null,null,null,"dist","distant"]
[null,null,null,null,null,"…","… your new subscript"]
[]
[null,null,null,null,null,"Qualifier "]
[null,null,null,null,null,"which balance item"]
[null,null,null,null,null,"used","used in the same time step"]
[null,null,null,null,null,"nused","NOT used in the same time step"]
[null,null,null,null,null,"rdel","redelivered"]
[null,null,null,null,null,"tmp","temporary (exported)"]
[null,null,null,null,null,"grid","to/from grid"]
[null,null,null,null,null,"…","… your new subscript"]
[]
[]
[null,"Level 1",null,"Level 2",null,"Level 3",null,"Level 4"]
[null,"Primary energy",null,"Type of primary energy",null,"Qualifier",null,"Energy carrier"]
[null,null,null,null,null,"Type of energy flow"]
[null,"P","Primary","tot","total primary energy","del","delivered","See level 2…3 of table above"]
[null,"…","… your new subscript","ren","renewable primary fraction","exp","exported"]
[null,null,null,"nren","non renewable primary fraction","pr","produced"]
[null,null,null,"…","… your new subscript","…","… your new subscript"]
[]
[null,null,null,null,null,"Qualifier"]
[null,null,null,null,null,"Destination of energy flow"]
[null,null,null,null,null,"EPus","used for EPBD services"]
[null,null,null,null,null,"nEPus","used for services other than EPBD"]
[null,null,null,null,null,"X","Any EPB use"]
[null,null,null,null,null,"…","… your new subscript"]
[]
[null,null,null,null,null,"Qualifier"]
[null,null,null,null,null,"Origin of energy flow"]
[null,null,null,null,null,"onst","on site"]
[null,null,null,null,null,"ofst","off site"]
[null,null,null,null,null,"nrby","neardy"]
[null,null,null,null,null,"dist","distant"]
[null,null,null,null,null,"…","… your new subscript"]
[]
[]
[null,"Please insert any new subscript in the yellow field"]

{"sheet":"Subs_other","index":18,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,1,14,8],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
[null,"OTHER COMMON SUBSCRIPTS"]
[]
[null,"Level n + 1",null,"Level n + 2",null,"Level n + 3",null,"Level n + 4"]
[null,"Spatial coverage",null,"Time period",null,"How acquired",null,"Statistical"]
[null,"B","building","wk","weekly","calc","calculated","avg","time-average"]
[null,"zb","building zone","day","daily","meas","measured","mn","mean \n(time or space) a  "]
[null,"sp","space","h","hourly","est","estimated","max","maximum"]
[null,"bu ","building unit","m","monthly","…","… your new subscript","min","minimum"]
[null,"zt","thermal zone","seas","seasonal",null,null,"pk","peak"]
[null,"zV","ventilation zone","bin","bin",null,null,"…","… your new subscript"]
[null,"…","… your new subscript","an","annual"]
[null,null,null,"…","… your new subscript"]
[]
[]
[null,"a mean is used for time or spatial average (to be ascertained from the context)"]
[]
[null,"Please insert any new subscript in the yellow field"]

{"sheet":"History","index":19,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2012-07-04","Issued for discussion in CTL"]
[null,"2012-08-24","Issued for comments in TC 371","Improved readability"]
[null,"2013-07-03","Revised for the toolkit"]
[null,"2013-11-18","Revised to include software language and references to common symbols and subscripts"]
[null,"2016-01-01","Adapted to FV version"]
[null,"2016-01-31","Disclaimer added"]