{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["INFO","Simplified_input_correlation","Product_descriptive_data","Product_tech_data","Process_design_data","System_configuration","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":26,"images":74,"macros":1,"external_links":0,"defined_names":56,"comments":6,"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":33}]
["Length of vertical shafts","lS","m",{"$f":"0.025*Method_in*D7*D8*D9","v":2325}]
["Length of base collector","lV","m",{"$f":"2*Method_in+0.01625*Method_in*D7*D7","v":-4250}]
["…"]
[]
["Output data"]
["Length of shafts","lS","m",{"$f":"+D16","v":2325},"0...∞"]
["diameter of shafts","dS","m",null,"0…0,2"]
["Length of base ring","lB","m",{"$f":"+D17","v":-4250},"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":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[23,10,23,12],[10,10,10,12],[24,10,24,12],[8,10,8,12],[11,10,11,12],[12,10,12,12],[13,10,13,12],[17,10,17,12],[22,10,22,12],[21,10,21,12],[28,0,29,0],[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,6,29,6]]}
["Leakage calculation (not implemented)"]
["6.3.2.2.2 Duct leakage factors"]
["The duct leakage factor ","flea,du","-",null,"Formula (1)"]
["The air flow through the duct leakage ","qV;lea;du","m3/h",null,"Formula (2)"]
["6.3.2.2.3 Air handling unit leakage factors"]
["The air handling unit leakage factor ","flea;ahu","-",null,"Formula (3)"]
["Rotary heat exchangers"]
["Input data",null,null,null,null,null,null,null,null,"Table D.1 — Constants for the calculation"]
["Constant for the rotation speed dependence of the heat recovery efficiency for rotary heat recoveries","C3","-",{"$f":"Product_tech_data!K11","v":1.0182},null,null,null,null,null,null,"HEAT_REC_TYPE"]
["Constant for the rotation speed dependence of the heat recovery efficiency for rotary heat recoveries","C4","-",3.5200000000000002E-2,null,null,null,null,null,"Parameter","ROT_NH","ROT_HYG","ROT_SORP"]
["Constant for the rotation speed dependence of the heat recovery efficiency for rotary heat recoveries","C5","-",0.27600000000000002,null,null,null,null,null,"C3",1.0182]
["Exponent for the rotation speed dependence of the heat recovery efficiency for rotary heat recoveries","e1","-",{"$f":"Product_tech_data!K14","v":-2.7},null,null,null,null,null,"C4",80]
["Constant for moisture difference dependence of the humidity recovery efficiency for rotary heat recoveries","C6","-",{"$f":"IF(System_configuration!B71=2,Product_tech_data!K15,IF(System_configuration!B71=3,Product_tech_data!L15,IF(System_configuration!B71=4,Product_tech_data!M15,\"-\")))","v":248},null,null,null,null,null,"C5",4.8600000000000003]
["Constant for moisture difference dependence of the humidity recovery efficiency for rotary heat recoveries","C7","-",{"$f":"IF(System_configuration!B71=2,Product_tech_data!K16,IF(System_configuration!B71=3,Product_tech_data!L16,IF(System_configuration!B71=4,Product_tech_data!M16,\"-\")))","v":-0.24},null,null,null,null,null,"e1",-2.7]
["Constant for moisture difference dependence of the humidity recovery efficiency for rotary heat recoveries","C8","-",{"$f":"IF(System_configuration!B71=2,Product_tech_data!K17,IF(System_configuration!B71=3,Product_tech_data!L17,IF(System_configuration!B71=4,Product_tech_data!M17,\"-\")))","v":"-"},null,null,null,null,null,"C6",248,129,16.399999999999999]
["Constant for the mass flow relation dependence of the humidity recovery efficiency for rotary heat recoveries","C9","-",{"$f":"IF(System_configuration!B71=2,Product_tech_data!K19,IF(System_configuration!B71=3,Product_tech_data!L19,IF(System_configuration!B71=4,Product_tech_data!M19,\"-\")))","v":0.1},null,null,null,null,null,"C7",-0.24,0.35699999999999998,0.91800000000000004]
["Constant for the air velocity dependence of the humidity recovery efficiency for rotary heat recoveries","C10","-",{"$f":"IF(System_configuration!B71=2,Product_tech_data!K20,IF(System_configuration!B71=3,Product_tech_data!L20,IF(System_configuration!B71=4,Product_tech_data!M20,\"-\")))","v":-0.2},null,null,null,null,null,"C8","-",23.8,"-"]
["Constant for the air velocity dependence of the humidity recovery efficiency for rotary heat recoveries","C11","-",{"$f":"IF(System_configuration!B71=2,Product_tech_data!K21,IF(System_configuration!B71=3,Product_tech_data!L21,IF(System_configuration!B71=4,Product_tech_data!M21,\"-\")))","v":1},null,null,null,null,null,"DxODA;nom",5.0000000000000001E-3]
["Constant for the rotation speed dependence of the humidity recovery efficiency for rotary heat recoveries","C12","-",{"$f":"Product_tech_data!K22","v":1.0532999999999999},null,null,null,null,null,"C9",0.1,0.1,0.1]
["Constant for the rotation speed dependence of the humidity recovery efficiency for rotary heat recoveries","C13","-",{"$f":"Product_tech_data!K23","v":80000},null,null,null,null,null,"C10",-0.2,-0.152,9.8000000000000004E-2]
["Constant for the rotation speed dependence of the humidity recovery efficiency for rotary heat recoveries","C14","-",{"$f":"Product_tech_data!K24","v":15},null,null,null,null,null,"C11",1,1,1]
["Exponent for the rotation speed dependence of the humidity recovery efficiency for rotary heat recoveries","e2","-",{"$f":"Product_tech_data!K25","v":-4},null,null,null,null,null,"C12",1.0532999999999999]
["Annex D calculation",null,null,null,null,null,null,null,null,"C13",80000]
["The correction factor for the rotation number for rotary heat exchangers ","fn","-",{"$f":"IF(System_configuration!B81<>3,1,D9-D10*(D26/Method_input!E85+D11)^D12)","v":2.2204460492503131E-16},"Formula (D.1)",null,null,null,null,"C14",15]
["The temperature efficiency necessary to reach the supply air set point temperature ","hhr;req","-",{"$f":"IF(System_configuration!B81<>3,\"-\",IF((IF(System_configuration!B68=1,Method_calculation!D56,Method_calculation!D57)-IF(System_configuration!B62=2,IF(System_configuration!B58=1,Method_calculation!D99,Method_calculation!D101),Method_calculation!D97))=0,0,(IF(Method_calculation!D81<>\"-\",Method_calculation!D81,IF(Method_calculation!D82<>\"-\",Method_calculation!D82,IF(Method_calculation!D83<>\"-\",Method_calculation!D83,Method_calculation!D84)))-IF(System_configuration!B62=2,IF(System_configuration!B58=1,Method_calculation!D99,Method_calculation!D101),Method_calculation!D97))/(IF(System_configuration!B68=1,Method_calculation!D56,Method_calculation!D57)-IF(System_configuration!B62=2,IF(System_configuration!B58=1,Method_calculation!D99,Method_calculation!D101),Method_calculation!D97))))","v":0},"Formula (D.2)","if JSUP;hr = JETA;hr:in     hhr;req = 0   else ",null,null,null,"e2",-4]
["For rotary heat exchangers, the rotation number in case of controlled heat recovery","nrot","min-1",{"$f":"IF(System_configuration!B81=3,Method_input!E85*MIN(1,((-(D27-D9)/D10)^(1/D12)-D11)),\"-\")","v":0.20291239785747428},"Formula (D.3)"]
["with","fn;req","-",{"$f":"D25/(Method_input!E51*Method_calculation!D86*Method_calculation!D87)","v":0},"Formula (D.4)"]
["The correction factor for the condensation potential (If HEAT_REC_TYPE = ROT_SORP or ROT_NH)","fΔx;x","-",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=4),MAX(0,D13*(Method_calculation!D107-D31)+D14),\"-\")","v":0},"Formula (D.5a)","fDx;x = max[0 ; C6 × (xETA;hr;in – xe:sat) + C7]"]
["The correction factor for the condensation potential (If HEAT_REC_TYPE = ROT_HYG)","fΔx;x","-",{"$f":"IF(System_configuration!B71=3,IF(Method_input!E8-D31>0,D13*(Method_calculation!D107-D31)+D14,MAX(0,D15*(Method_calculation!D107-D31)+D14)),\"-\")","v":"-"},"Formula (D.5b)","If (xe – xe;sat) > 0: fDx;x = C6 × (xETA;hr;in – xe:sat) + C7"]
[null,null,null,null,"Formula (D.5c)","If (xe – xe;sat) <= 0:  fDx;x = max[0 ; C8 × (xETA;hr;in – xe:sat) + C7]"]
["The saturation moisture content of the outdoor air","xODA;sat","kg/kg dry air",{"$f":"0.622*D32/(Method_input!E133-D32)","v":1.6416024950491801E-2},"Formula (D.6)"]
["the saturation pressure ","pODA;sat","Pa",{"$f":"611.2*EXP(17.62*theta_e/(243.12+theta_e))","v":2605.4385590298621},"Formula (D.7)"]
["The correction factor for the mass flow relation","fq;x","-",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4),1-D16*((Method_calculation!D44-Method_calculation!D43)/(Method_calculation!D43*IF(System_configuration!B94=3,Method_calculation!D74,IF(System_configuration!B94=2,Method_calculation!D75,Method_calculation!D76)))+1)*((Method_calculation!D44-Method_calculation!D43)/(Method_calculation!D43*IF(System_configuration!B94=3,Method_calculation!D74,IF(System_configuration!B94=2,Method_calculation!D75,Method_calculation!D76)))+1),\"-\")","v":0.9},"Formula (D.8)"]
["The correction factor for the air velocity ","fv;x","-",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4),D17*(Method_input!D95-Method_input!E113)+D18,\"-\")","v":1.7000000000000002},"Formula (D.9)","fv;x = C10 (vhr;eff – vhr;nom) + C11 "]
["The correction factor for the rotation number for rotary heat exchangers","fn;x","-",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4),MAX(0,D19-D20*(D26+D21)^D22),\"-\")","v":0},"Formula (D.10)"]
["Fans"]
["Input data"]
["Reference value of the air volume flow rate to characterise the efficiency factor of the supply fan as a function of the air volume flow rate (1st key parameter determining hF(qV) )","qV,fan;SUP;refEf","m3/h",5000]
["Efficiency factor of the supply fan for the reference air flow rate (2nd key parameter determining hF(qV) )","hfan;SUP;refEf","–",0.72]
["Reference value of the air volume flow rate to characterise the efficiency factor of the extract fan as a function of the air volume flow rate (1st key parameter determining hF(qV) )","qV,fan;ETA;refEf","m3/h",5000]
["Efficiency factor of the extractfan for the reference air flow rate (2nd key parameter determining hF(qV) )","hfan;ETA;refEf","–",0.78]
["Pressure difference over the supply fan if the air volume flow is 0 (1st key parameter determining the fan characteristic curve)","Dpfan;SUP;0","Pa",800]
["Reference value of the air volume flow rate to characterise the supply fan characteristic curve (2nd key parameter determining the fan characteristic curve)","qV,fan;SUP;refCc","m3/h",5000]
["Pressure difference over the supply fan for the reference air volume flow rate (3rd key parameter determining the fan characteristic curve)","Dpfan;SUP;refCc","Pa",600]
["Pressure difference over the extract fan if the air volume flow is 0 (1st key parameter determining the fan characteristic curve)","Dpfan;ETA;0","Pa",800]
["Reference value of the air volume flow rate to characterise the extract fan characteristic curve (2nd key parameter determining the fan characteristic curve)","qV,fan;ETA;refCc","m3/h",5000]
["Pressure difference over the extract fan for the reference air volume flow rate (3rd key parameter determining the fan characteristic curve)","Dpfan;ETA;refCc","Pa",600]
["Old PE version calculation as proxy (since there is no function given)"]
["The fan energy consumption for the current time step is the energy consumption for ventilation","EV;gen;in;el","kWh",{"$f":"D39/SQRT(D38*Method_calculation!D43)*Method_calculation!D43/Method_input!E72","v":0.4618484599952673},"Derived from former Formula (82)"]
["The fan energy consumption for the current time step is the energy consumption for ventilation","EV;gen;in;el","kWh",{"$f":"D41/SQRT(D40*Method_calculation!D44)*Method_calculation!D44/Method_input!E74","v":0.4618484599952673},"Former Formula (82)"]
["The supply and extract fan pressure differences are (single zone, no contol)","Δpfan;SUP","Pa",{"$f":"(D42-(Method_calculation!D43/Product_tech_data!D43)^2*(Product_tech_data!D42-Product_tech_data!D44))/Method_input!E73","v":1.3181671345279999},"Former Formula (83a)"]
["The supply and extract fan pressure differences are (single zone, no contol)","Δpfan;ETA","Pa",{"$f":"(D45-(Method_calculation!D44/Product_tech_data!D46)^2*(Product_tech_data!D45-Product_tech_data!D47))/Method_input!E75","v":1.3181671345279999},"Former Formula (84a)"]

{"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)"]
[2,"BLR_LOC",{"$f":"INDEX(C11:C14,A9)","v":"BLR_LOC_UNH"},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":5},{"$f":"INDEX(F11:F14,$A$9)","v":0.5}]
[]
[]
["Boiler hydraulic connection"]
[1,"BLR_HCON",{"$f":"INDEX(C21:C24,A19)","v":"BLR_HCON_DIR"}]
[]
["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":"System_configuration","index":5,"n_rows":123,"n_cols":22,"rows_kept":123,"cut":false,"hidden":false,"merged":[[100,13,100,15],[100,11,100,12],[84,11,86,11],[66,13,66,14],[65,13,65,19],[81,11,82,11],[81,12,82,12],[47,15,47,17],[48,15,48,17],[53,15,53,17],[54,15,54,17],[55,15,55,17],[55,11,57,11],[55,12,57,12],[56,15,56,17],[57,15,57,17],[44,14,44,18],[51,15,51,17],[52,15,52,17],[49,11,51,11],[49,12,51,12],[49,15,49,17],[52,11,54,11],[52,12,54,12],[46,11,48,11],[46,12,48,12],[46,15,46,17],[50,15,50,17]]}
[]
[]
[]
[null,"Yes "]
[null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["General","A","B","C","D","E","F","G","H"]
["Volume flow rates","Frost protection / ground preheating/-cooling","Exhaust air fan","Heat recovery","Recirculation","Cooling / dehumidification","Humidification","Heating","Supply fan"]
[]
["Air handling unit localosation","Ground air preheating and -cooling","localisation","Heat recovery type",null,null,"Humidifier type",null,"Fan motor localisation"]
[]
["Supply air temperature control","Frost protection type",null,"only for PLATE and ROT_HYG","Recirculation control ",null," humidifier control",null,"System type for variable air volume flow rate fan energy calculation"]
[]
["Control of the volume flow rate ","Control of the frost protection",null,"Control of the heat recovery device",null,null,"humidification energy carrier ",null,"Control of the fan"]
[]
["System type",null,null,null,null,null,"Adiabatic cooling",null,"localisation"]
[]
[]
[]
["6.4.2.1.1     Volume flow rates"]
["Flow rate calculation",1,"Detailed"]
[null,null,"Simplified"]
[]
["AHU_LOC",2,"COND","Air handling unit is located in the conditioned zone"]
[null,null,"NC","Air handling unit is located in the non-conditioned zone"]
[]
["If SUP_TEMP_CTRL = ",2,"CONST ","constant supply air temperature",null,null,null,null,null,null,null,"Table B.5 — Default heat recovery leakage and outdoor air factors"]
[null,null,"ODA_COMP ","Variable set point with outdoor temperature compensation",null,null,null,null,null,null,null,"SUP_FAN_LOC","ETA_FAN_LOC",null,"HEAT_REC_TYPE"]
[null,null,"LOAD_COMP ","Variable set point with load dependent compensation",null,null,null,null,null,null,null,null,null,"Leakage factor","FLAT_PLATE","ROT_NH","ROT_HYG","ROT_SORP","PUMP_CIRC"]
[null,null,"NO_CTRL",null,null,null,null,null,null,null,null,"UP_HR","UP_HR","flea;hr;SUP",1,1.04,null,null,1,null,{"$f":"IF(AND(B119=1,B68=1,B71=1),O47,IF(AND(B119=1,B68=1,OR(B71=2,B71=3,B71=4)),P47,IF(AND(B119=1,B68=1,B71=5),S47,IF(AND(B119=1,B68=2,B71=1),O50,IF(AND(B119=1,B68=2,OR(B71=2,B71=3,B71=4)),P50,IF(AND(B119=1,B68=2,B71=5),S50,IF(AND(B119=2,B68=1,B71=1),O53,IF(AND(B119=2,B68=1,OR(B71=2,B71=3,B71=4)),P53,IF(AND(B119=2,B68=1,B71=5),S53,IF(AND(B119=2,B68=2,B71=1),O56,IF(AND(B119=2,B68=2,OR(B71=2,B71=3,B71=4)),P56,S56)))))))))))","v":1.1000000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"flea;hr;ETA",1,1,null,null,1,null,{"$f":"IF(AND(B119=1,B68=1,B71=1),O48,IF(AND(B119=1,B68=1,OR(B71=2,B71=3,B71=4)),P48,IF(AND(B119=1,B68=1,B71=5),S48,IF(AND(B119=1,B68=2,B71=1),O51,IF(AND(B119=1,B68=2,OR(B71=2,B71=3,B71=4)),P51,IF(AND(B119=1,B68=2,B71=5),S51,IF(AND(B119=2,B68=1,B71=1),O54,IF(AND(B119=2,B68=1,OR(B71=2,B71=3,B71=4)),P54,IF(AND(B119=2,B68=1,B71=5),S54,IF(AND(B119=2,B68=2,B71=1),O57,IF(AND(B119=2,B68=2,OR(B71=2,B71=3,B71=4)),P57,S57)))))))))))","v":1.1000000000000001}]
["AIR_FLOW_CTRL",4,"NO_CONTR","no flow rate control, continuous operation",null,null,null,null,null,null,null,null,null,"fODA;hr",1,1,null,null,1,null,{"$f":"IF(AND(B119=1,B68=1,B71=1),O49,IF(AND(B119=1,B68=1,OR(B71=2,B71=3,B71=4)),P49,IF(AND(B119=1,B68=1,B71=5),S49,IF(AND(B119=1,B68=2,B71=1),O52,IF(AND(B119=1,B68=2,OR(B71=2,B71=3,B71=4)),P52,IF(AND(B119=1,B68=2,B71=5),S52,IF(AND(B119=2,B68=1,B71=1),O55,IF(AND(B119=2,B68=1,OR(B71=2,B71=3,B71=4)),P55,IF(AND(B119=2,B68=1,B71=5),S55,IF(AND(B119=2,B68=2,B71=1),O58,IF(AND(B119=2,B68=2,OR(B71=2,B71=3,B71=4)),P58,S58)))))))))))","v":0.90900000000000003}]
[null,null,"ON/OFF CTRL","time dependent flow rate control, continuous operation during occupancy time",null,null,null,null,null,null,null,"UP_HR","DOWN_HR","flea;hr;SUP",1,1.1000000000000001,null,null,1]
[null,null,"MULIT_STAGE ","multi stage variable flow rate control",null,null,null,null,null,null,null,null,null,"flea;hr;ETA",1,1.1000000000000001,null,null,1]
[null,null,"VARIABLE","continuously variable flow rate control",null,null,null,null,null,null,null,null,null,"fODA;hr",1,1,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"DOWN_HR","UP_HR","flea;hr;SUP",1,1.1000000000000001,null,null,1]
["GND_PREH_CTRL",2,"NO_CTRL","No control of the ground preheating/-cooling (contiuous operation)",null,null,null,null,null,null,null,null,null,"flea;hr;ETA",1,1.1000000000000001,null,null,1]
[null,null,"BYPASS","Bypass to adjust the supply air temperature",null,null,null,null,null,null,null,null,null,"fODA;hr",1,0.90900000000000003,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"DOWN_HR","DOWN_HR","flea;hr;SUP",1,1.02,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"flea;hr;ETA",1,1,null,null,1]
["DEFR_TYPE",1,"PREH","The entering temperature to the heat recovery is enhanced by a preheating coil",null,null,null,null,null,null,null,null,null,"fODA;hr",1,0.98,null,null,1]
[null,null,"BYPASS","A bypass in the supply air decreases the transferred heat and rises the leaving extract air temperature"]
[null,null,"RECIRC","Recirculation of extract air to the outside air increases the entering temperature to the heat recovery",null,null,null,null,null,null,null,"Tabelle B.5 – Default humidity recovery efficiency and constants for the calculation"]
[null,null,null,null,null,null,null,null,null,null,null,"Parameter","ROT_NH","ROT_HYG","ROT_SORP"]
["DEFR_CTRL",2,"DIRECT","Defrosting is controlled directly by measurement of the pressure drop, and the resulting effect is considered by corrected efficiency values. These must be provided according to EN 13053;2006",null,null,null,null,null,null,null,"hxr;nom",0.3,0.42,0.69]
[null,null,"INDIRECT","Frost is prevented by controlling the leaving temperature from the heat recovery device."]
[]
["System type",2,13141,"balanced residential ventilation systems tested according to EN 13141-7 or EN 13141-8",null,null,null,null,null,null,null,"Table B.6 — Default nominal temperature efficiencies and values for the constants"]
[null,null,"else",null,null,null,null,null,null,null,null,null,null,"HEAT_REC_TYPE"]
[null,null,null,null,null,null,null,null,null,null,null,"Parameter","Unit","PLATE",null,"ROT_NH","ROT_HYG","ROT_SORP","PUMP_CIRC","OTHER",2,"PLATE"]
["ETA_FAN_LOC",1,"UP_HR","Extract fan is located upstream of the heat recovery device or the recirculation",null,null,null,null,null,null,null,null,null,"cross flow","counter flow",null,null,null,null,null,null,"ROT_NH"]
[null,null,"DOWN_HR","Extract fan is located downstream of the heat recovery device or the recirculation",null,null,null,null,null,null,null,"hhr;nom","-",0.6,0.85,0.69,0.67,0.69,0.71,null,null,"ROT_HYG"]
[null,null,null,null,null,null,null,null,null,null,null,"vhr;nom ","m/s",3.5,null,null,null,null,null,null,null,"ROT_SORP"]
["If HEAT_REC_TYPE =",2,"PLATE","Flat plate heat exchanger",null,null,null,null,null,null,null,"C1",null,-2.01E-2,-2.01E-2,-6.4299999999999996E-2,-6.8400000000000002E-2,-6.6500000000000004E-2,-4.9099999999999998E-2,null,null,"PUMP_CIRC"]
[null,null,"ROT_NH","Rotary, non-hygroscopic",null,null,null,null,null,null,null,"C2",null,1,null,1,1,1,1]
[null,null,"ROT_HYG","Rotary hygroscopic",null,null,null,null,null,null,null,"Φhr;max","kW",1.0000000000000001E-5,1.0000000000000001E-5,0.5,0.5,0.5,1.0000000000000001E-5]
[null,null,"ROT_SORBT","Rotary sorbtive",null,null,null,null,null,null,null,"nrot;max","min-1",1.0000000000000001E-5,1.0000000000000001E-5,20,20,20,1.0000000000000001E-5]
[null,null,"PUMP_CIRC","Pumped circuit system",null,null,null,null,null,null,null,"Phr;rot;max","kW",1.0000000000000001E-5,1.0000000000000001E-5,0.05,0.05,0.05,1.0000000000000001E-5]
[null,null,"OTHER","other type of heat recovery",null,null,null,null,null,null,null,"pel;hr;pu;max","kWh/m3",1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,0.3]
[null,null,null,null,null,null,null,null,null,null,null,"fpl;hr;min","-",1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,1.0000000000000001E-5,0.6]
["Building use category (im Anhang)",1,{"$f":"IF(OR(B71=1,B71=3),\"Residential\",\"-\")","v":"-"},null,null,null,null,null,null,null,null,"ΔpSUP+ETA;des;hr","Pa",300,500,400,400,400,500]
[null,null,{"$f":"IF(OR(B71=1,B71=3),\"Non residential\",\"-\")","v":"-"}]
[]
["If HEAT_REC_CTRL = ",3,{"$f":"IF(B71=1,\"NO_CTRL\",\"-\")","v":"-"},null,null,null,null,null,null,null,null,"Table B.10  Default specific humidification pump energy power consumption for different humidifier types and control strategies"]
[null,null,{"$f":"IF(B71=1,\"BYPASS\",\"-\")","v":"-"},null,null,null,null,null,null,null,null,"HUM_TYPE","HUM_CTRL","Specific power pel,HU,des","qm;w;HU,des "]
[null,null,{"$f":"IF(OR(B71=2,B71=3,B71=4,B71=5),\"SPEED\",\"-\")","v":"SPEED"},null,null,null,null,null,null,null,null,null,null,"kWh/m3","kg/h"]
[null,null,{"$f":"IF(B71=5,\"HYDR\",\"-\")","v":"-"},null,null,null,null,null,null,null,null,"CONTACT","NO_CTRL",0.01,1]
[null,null,null,null,null,null,null,null,null,null,null,"ROT_SPRAY","NO_CTRL",0.2,1]
["RCA",1,"yes",null,null,null,null,null,null,null,null,null,"ON_OFF",0.2,1]
[null,null,"no",null,null,null,null,null,null,null,null,null,"SPEED",0.2,1]
[null,null,null,null,null,null,null,null,null,null,null,"HI_PRES","SPEED",0.04,1]
["If RCA_CTRL = ",3,"ZONE_BASED",null,null,null,null,null,null,null,null,"HYBRID","ON_OFF",0.02,1]
[null,null,"FIX","Fixed proportion of recirculation air",null,null,null,null,null,null,null,"STEAM","-","-","-"]
[null,null,"VARIABLE","Variable proportion of recirculation air"]
[null,null,null,null,null,null,null,null,null,null,null,"Table B.12 — Default fan motor heat recovery factors"]
["If HUM_TYPE",1,"CONTACT","Contact and drip humidifier",null,null,null,null,null,null,null,"FAN_MOT_LOC","ffan;rd"]
[null,null,"ROT_SPRAY","Rotary spray humidifier",null,null,null,null,null,null,null,"IN_AIR",0.9]
[null,null,"HI_PRES","High pressure humidifier",null,null,null,null,null,null,null,"OUTS_AIR",0.6]
[null,null,"HYBRID","Hybrid humidifier"]
[null,null,"STEAM","Steam humidifier"]
[]
["GEN_CRHU;gen",1,"HUM_CR_EL","Electricity"]
[null,null,"HUM_CR_GAS","Gas",null,null,null,null,null,null,null,"Table B.14 – Temperature limit values for frost protection"]
[null,null,"HUM_CR_SOL","solar",null,null,null,null,null,null,null,"DEFR_CTRL = DIRECT",null,"DEFR_CTRL = INDIRECT"]
[null,null,"HUM_CR_OTHER","other type of carrier",null,null,null,null,null,null,null,"Limit ","Value °C","Building use category","HEAT_REC_TYPE","JETA;hr;lim, °C"]
[null,null,null,null,null,null,null,null,null,null,null,"Je;lim1",-10,"Residential","FLAT_PLATE",5]
["If HUM_CTRL = ",2,"NO_CTRL","Uncontrolled or valve controlled",null,null,null,null,null,null,null,"Je;lim2",-5,"Residential","ROT_HYG",0]
[null,null,"ON_OFF","On/off",null,null,null,null,null,null,null,null,null,"Non residential","FLAT_PLATE",0]
[null,null,"SPEED","Pump speed control",null,null,null,null,null,null,null,null,null,"Non residential","ROT_HYG",-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Non residential","ROT_NH",-10]
["FAN_MOT_LOC",2,"IN_AIR","Fan motor is located inside the air stream",null,null,null,null,null,null,null,null,null,"Non residential","ROT_SORBT",-5]
[null,null,"OUTS_AIR","Fan motor is located outside the air stream",null,null,null,null,null,null,null,null,null,"Non residential","PUMP_CIRC",10]
[]
[" If SYS_TYPE =",1,"SINGLE_ZONE","The system is serving one single zone or is controlled according to a pilot zone"]
[null,null,"MULTI_ZONE","The system is serving several zones with individual zone volume flow rate controls"]
[]
["If FAN_CTRL",4,"NO_CTRL","No control; the fan reacts on the variable flow rate according to its characteristics"]
[null,null,{"$f":"IF(B111=2,\"CONST_PRES\",\"-\")","v":"-"},"The fan pressure difference is kept constant"]
[null,null,{"$f":"IF(B111=2,\"MIN_PRES\",\"-\")","v":"-"},"The fan is controlled to the minimum necessary pressure difference necessary in the system"]
[null,null,{"$f":"IF(B111=1,\"DIRECT\",\"-\")","v":"DIRECT"},"The fan is controlled directly according to the variable flow rate "]
[]
["SUP_FAN_LOC = UP_HR",2,"UP_HR"]
[null,null,"DOWN_HR"]
[]
["Adiabatic cooling",2,"yes"]
[null,null,"no"]

{"sheet":"Input_series","index":6,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Load here the value of input variables for each time-step (time series)\nSet the number of input data for each time steps and the number of time step before running The macro from sheet \"Output series\".\n\nLocal constant data may be input via the sheets \"Constants\" "]
[]
["Time series for data input"]
["Settings"]
["Number of input data",null,20]
["Number of time steps",null,48]
[]
["Description","external temperature of the calculation interval","external air moisture content of the calculation interval","Temperature of the thermal zone where the duct or ahu losses go to","Temperature of the unconditioned duct surrounding","Moisture content of the unconditioned duct surrounding","AHU heating coil input","AHU cooling coil output","AHU cooling coil  inlet temperature","Operation requirement signal","Required supply air volume flow rate per ventilation zone i","Required return air volume flow rate per ventilation zone i","Required supply outdoor air volume flow rate per ventilation zone i","Required ventilation zone supply air temperature","Required ventilation zone supply air moisture content","Required ventilation zone supply air moisture content","Ventilation zone return air temperature","Thermal zone return air moisture content","Average partial load factor (averaged over all zones)","Partial load diversity (over all zones)","Operation factor of the control devices"]
["Symbol","Je","xe","JIDA;zt","Jsur;nc","xsur;nc","QH;ahu;in","QC;ahu;out;","JC;ahu;in","fop;V","qV;SUP;dis;zv;req;i","qV;ETA;dis;zv;req;i","qV;ODA;zv;req;i","JSUP;req;zv","xSUP;zt;min;req","xSUPzt;max;req","JETA;zv","xETA;zv","fpl","DfV","fop;ctrl"]
["Unit","°C","kg/kg dry air","°C","°C","kg/kg dry air","kWh","kWh","°C","-","m3/h","m3/h","m3/h","°C","kg/kg dry air","kg/kg dry air","°C","kg/kg dry air","–","–","-"]
[]
[]
["Time stamp",null,"VALUES"]
[1,-9.6999999999999993,1.6999999999999999E-3,21,15,1.6999999999999999E-3,{"$f":"Output_series!I18","v":0.74473072367948112},{"$f":"Output_series!J18","v":0},{"$f":"Output_series!P18","v":20.79701576906837},1,500,-500,{"$f":"K14/2","v":250},21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X18+0.002","v":9.6400325978864988E-3},0.9,0.9,1]
[2,-9.3000000000000007,1.73E-3,21,15,1.73E-3,{"$f":"Output_series!I19","v":0.73899439408817269},{"$f":"Output_series!J19","v":0},{"$f":"Output_series!P19","v":20.813658274226103},1,500,-500,{"$f":"K15/2","v":250},21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X19+0.002","v":9.6717584037706306E-3},0.9,0.9,1]
[3,-9.1999999999999993,1.7099999999999999E-3,21,15,1.7099999999999999E-3,{"$f":"Output_series!I20","v":0.73756031169034597},{"$f":"Output_series!J20","v":0},{"$f":"Output_series!P20","v":20.817818900515537},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X20+0.002","v":9.6506078665145444E-3},0.9,0.9,1]
[4,-9.5,1.72E-3,21,15,1.72E-3,{"$f":"Output_series!I21","v":0.74186255888382757},{"$f":"Output_series!J21","v":0},{"$f":"Output_series!P21","v":20.805337021647237},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X21+0.002","v":9.6611831351425866E-3},0.9,0.9,1]
[5,-9.3000000000000007,1.7800000000000001E-3,21,15,1.7800000000000001E-3,{"$f":"Output_series!I22","v":0.73899439408817269},{"$f":"Output_series!J22","v":0},{"$f":"Output_series!P22","v":20.813658274226103},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X22+0.002","v":9.724634746910845E-3},0.9,0.9,1]
[6,-8.8000000000000007,1.8400000000000001E-3,21,15,1.8400000000000001E-3,{"$f":"Output_series!I23","v":0.73182398209903632},{"$f":"Output_series!J23","v":0},{"$f":"Output_series!P23","v":20.834461405673277},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X23+0.002","v":9.7880863586791052E-3},0.9,0.9,1]
[7,-8.1,1.89E-3,21,15,1.89E-3,{"$f":"Output_series!I24","v":1.2678276666297639},{"$f":"Output_series!J24","v":0},{"$f":"Output_series!P24","v":19.52078648690204},1,1000,-1000,500,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X24+0.002","v":6.0000000000000001E-3},0.9,0.9,1]
[8,-8.1,1.9299999999999999E-3,21,15,1.9299999999999999E-3,{"$f":"Output_series!I25","v":2.6390161148191247},{"$f":"Output_series!J25","v":0},{"$f":"Output_series!P25","v":19.244879781141648},1,2000,-2000,1000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X25+0.002","v":6.0000000000000001E-3},0.9,0.9,1]
[9,-7.7,1.98E-3,21,15,1.98E-3,{"$f":"Output_series!I26","v":3.9629847022784888},{"$f":"Output_series!J26","v":0},{"$f":"Output_series!P26","v":19.095496957208301},1,3000,-3000,1500,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X26+0.002","v":6.0196000458958218E-3},0.9,0.9,1]
[10,-7,1.9199999999999998E-3,21,15,1.9199999999999998E-3,{"$f":"Output_series!I27","v":5.284275076215101},{"$f":"Output_series!J27","v":0},{"$f":"Output_series!P27","v":19.019293479450521},1,4000,-4000,2000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X27+0.002","v":6.0000000000000001E-3},0.9,0.9,1]
[11,-6,2.1299999999999999E-3,21,15,2.1299999999999999E-3,{"$f":"Output_series!I28","v":5.050083501361005},{"$f":"Output_series!J28","v":0},{"$f":"Output_series!P28","v":19.131243646946523},1,4000,-4000,2000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X28+0.002","v":6.1742704210309592E-3},0.9,0.9,1]
[12,-5.6,2.2499999999999998E-3,21,15,2.2499999999999998E-3,{"$f":"Output_series!I29","v":2.4411031963238683},{"$f":"Output_series!J29","v":0},{"$f":"Output_series!P29","v":19.481514678011649},1,2000,-2000,1000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X29+0.002","v":6.2966405382184586E-3},0.9,0.9,1]
[13,-4.7,2.31E-3,21,15,2.31E-3,{"$f":"Output_series!I30","v":3.6283116788511931},{"$f":"Output_series!J30","v":0},{"$f":"Output_series!P30","v":19.405403146574301},1,3000,-3000,1500,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X30+0.002","v":6.3578255968122057E-3},0.9,0.9,1]
[14,-4.0999999999999996,2.2000000000000001E-3,21,15,2.2000000000000001E-3,{"$f":"Output_series!I31","v":4.7438113265419899},{"$f":"Output_series!J31","v":0},{"$f":"Output_series!P31","v":19.343948965188922},1,4000,-4000,2000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X31+0.002","v":6.2456529893903309E-3},0.9,0.9,1]
[15,-4.0999999999999996,2.3E-3,21,15,2.3E-3,{"$f":"Output_series!I32","v":4.7438113265419899},{"$f":"Output_series!J32","v":0},{"$f":"Output_series!P32","v":19.343948965188922},1,4000,-4000,2000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X32+0.002","v":6.347628087046581E-3},0.9,0.9,1]
[16,-4,2.32E-3,21,15,2.32E-3,{"$f":"Output_series!I33","v":2.3320701959625247},{"$f":"Output_series!J33","v":0},{"$f":"Output_series!P33","v":19.632961012008447},1,2000,-2000,1000,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X33+0.002","v":6.3680231065778338E-3},0.9,0.9,1]
[17,-3.6,2.3500000000000001E-3,21,15,2.3500000000000001E-3,{"$f":"Output_series!I34","v":1.0968364546027147},{"$f":"Output_series!J34","v":0},{"$f":"Output_series!P34","v":19.907812831585041},1,1000,-1000,500,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X34+0.002","v":6.3986156358747086E-3},0.9,0.9,1]
[18,-3.4,2.3999999999999998E-3,21,15,2.3999999999999998E-3,{"$f":"Output_series!I35","v":3.9083054457801341},{"$f":"Output_series!J35","v":3.3360391083617493},{"$f":"Output_series!P35","v":9.2585989763148646},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X35+0.002","v":9.9999921191360266E-3},0.9,0.9,1]
[19,-3.5,2.4500000000000004E-3,21,15,2.4500000000000004E-3,{"$f":"Output_series!I36","v":3.9093028151493057},{"$f":"Output_series!J36","v":3.3469351334723267},{"$f":"Output_series!P36","v":9.256022115113403},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X36+0.002","v":9.999990015185636E-3},0.9,0.9,1]
[20,-3.6,2.4599999999999999E-3,21,15,2.4599999999999999E-3,{"$f":"Output_series!I37","v":3.9096170325467736},{"$f":"Output_series!J37","v":3.3480818160998185},{"$f":"Output_series!P37","v":9.2559227440978731},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X37+0.002","v":9.9999895943955648E-3},0.9,0.9,1]
[21,-3.7,2.4399999999999999E-3,21,15,2.4399999999999999E-3,{"$f":"Output_series!I38","v":3.9094188281156459},{"$f":"Output_series!J38","v":3.341916434015157},{"$f":"Output_series!P38","v":9.2576817005175087},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X38+0.002","v":9.999990435975728E-3},0.9,0.9,1]
[22,-3.8,2.4199999999999998E-3,21,15,2.4199999999999998E-3,{"$f":"Output_series!I39","v":3.9092206462608075},{"$f":"Output_series!J39","v":3.3357510745068155},{"$f":"Output_series!P39","v":9.2594405750629232},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X39+0.002","v":9.9999912775558773E-3},0.9,0.9,1]
[23,-4.4000000000000004,2.3599999999999997E-3,21,15,2.3599999999999997E-3,{"$f":"Output_series!I40","v":3.9090564608413501},{"$f":"Output_series!J40","v":3.3133831089333268},{"$f":"Output_series!P40","v":9.2662769424285276},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X40+0.002","v":9.9999938022963357E-3},0.9,0.9,1]
[24,-4.9000000000000004,2.33E-3,21,15,2.33E-3,{"$f":"Output_series!I41","v":3.9092612607683561},{"$f":"Output_series!J41","v":3.2996178539876615},{"$f":"Output_series!P41","v":9.2707350064953022},1,500,-500,250,21,4.0000000000000001E-3,8.0000000000000002E-3,22,{"$f":"Output_series!X41+0.002","v":9.9999950646665701E-3},0.9,0.9,1]
[25,20.8,1.265E-2,26,28,1.265E-2,{"$f":"Output_series!I42","v":1.7157675206285656},{"$f":"Output_series!J42","v":3.2039496633806146},{"$f":"Output_series!P42","v":14.37474853556837},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X42+0.002","v":1.3000000000000015E-2},0.9,0.9,1]
[26,20.8,1.2449999999999999E-2,26,28,1.2449999999999999E-2,{"$f":"Output_series!I43","v":1.7069370708154015},{"$f":"Output_series!J43","v":3.0420870706199956},{"$f":"Output_series!P43","v":14.40677267317707},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X43+0.002","v":1.3000000000000001E-2},0.9,0.9,1]
[27,20,1.2320000000000001E-2,26,28,1.2320000000000001E-2,{"$f":"Output_series!I44","v":1.8060681516250094},{"$f":"Output_series!J44","v":2.9857930457766093},{"$f":"Output_series!P44","v":14.407852306600573},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X44+0.002","v":1.3000000000000017E-2},0.9,0.9,1]
[28,19.600000000000001,1.2330000000000001E-2,26,28,1.2330000000000001E-2,{"$f":"Output_series!I45","v":1.8561427009565838},{"$f":"Output_series!J45","v":3.0435192022558497},{"$f":"Output_series!P45","v":14.38625405368969},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X45+0.002","v":1.2999999999999364E-2},0.9,0.9,1]
[29,19.399999999999999,1.222E-2,26,28,1.222E-2,{"$f":"Output_series!I46","v":1.8761138198336151},{"$f":"Output_series!J46","v":2.9793226425116797},{"$f":"Output_series!P46","v":14.393827634577466},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X46+0.002","v":1.29999999999996E-2},0.9,0.9,1]
[30,20.5,1.2449999999999999E-2,26,28,1.2449999999999999E-2,{"$f":"Output_series!I47","v":1.7497578731233696},{"$f":"Output_series!J47","v":3.0289536601907572},{"$f":"Output_series!P47","v":14.412064792450645},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X47+0.002","v":1.3000000000000166E-2},0.9,0.9,1]
[31,22.7,1.2580000000000001E-2,26,28,1.2580000000000001E-2,{"$f":"Output_series!I48","v":1.4456649923084135},{"$f":"Output_series!J48","v":3.9024900319476528},{"$f":"Output_series!P48","v":14.148462969449445},1,1000,-1000,500,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X48+0.002","v":1.3000000000000001E-2},0.9,0.9,1]
[32,24.4,1.291E-2,26,28,1.291E-2,{"$f":"Output_series!I49","v":2.2503783078651036},{"$f":"Output_series!J49","v":9.4643903422406286},{"$f":"Output_series!P49","v":13.883038334161984},1,2000,-2000,1000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X49+0.002","v":1.2999999999999986E-2},0.9,0.9,1]
[33,26.3,1.3390000000000001E-2,26,28,1.3390000000000001E-2,{"$f":"Output_series!I50","v":2.8578196049039923},{"$f":"Output_series!J50","v":17.093902376389064},{"$f":"Output_series!P50","v":13.58069426843355},1,3000,-3000,1500,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X50+0.002","v":1.2999999982021126E-2},0.9,0.9,1]
[34,28.3,1.311E-2,26,28,1.311E-2,{"$f":"Output_series!I51","v":3.5487982094041022},{"$f":"Output_series!J51","v":22.712689067605179},{"$f":"Output_series!P51","v":13.562437615747527},1,4000,-4000,2000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X51+0.002","v":1.2999999980901922E-2},0.9,0.9,1]
[35,30.1,1.304E-2,26,28,1.304E-2,{"$f":"Output_series!I52","v":3.5125172071033846},{"$f":"Output_series!J52","v":22.841274798693703},{"$f":"Output_series!P52","v":13.543556380782526},1,4000,-4000,2000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X52+0.002","v":1.2999999979760934E-2},0.9,0.9,1]
[36,31.6,1.337E-2,26,28,1.337E-2,{"$f":"Output_series!I53","v":1.9531543818763886},{"$f":"Output_series!J53","v":11.629394475718509},{"$f":"Output_series!P53","v":13.533807556003916},1,2000,-2000,1000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X53+0.002","v":1.299999997920631E-2},0.9,0.9,1]
[37,32.700000000000003,1.342E-2,26,28,1.342E-2,{"$f":"Output_series!I54","v":2.7887616871865317},{"$f":"Output_series!J54","v":17.779084117717815},{"$f":"Output_series!P54","v":13.495345241443326},1,3000,-3000,1500,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X54+0.002","v":1.2999999976898928E-2},0.9,0.9,1]
[38,33.200000000000003,1.2289999999999999E-2,26,28,1.2289999999999999E-2,{"$f":"Output_series!I55","v":3.3848464853469018},{"$f":"Output_series!J55","v":21.870962591954186},{"$f":"Output_series!P55","v":13.567628777815148},1,4000,-4000,2000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X55+0.002","v":1.2999999981142445E-2},0.9,0.9,1]
[39,33.799999999999997,1.145E-2,26,28,1.145E-2,{"$f":"Output_series!I56","v":3.2884688146383727},{"$f":"Output_series!J56","v":20.367871834969129},{"$f":"Output_series!P56","v":13.634503839909669},1,4000,-4000,2000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X56+0.002","v":1.2999999985108512E-2},0.9,0.9,1]
[40,33.700000000000003,1.1640000000000001E-2,26,28,1.1640000000000001E-2,{"$f":"Output_series!I57","v":1.8492955194508056},{"$f":"Output_series!J57","v":10.120465857116223},{"$f":"Output_series!P57","v":13.664438578033408},1,2000,-2000,1000,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X57+0.002","v":1.2999999986923342E-2},0.9,0.9,1]
[41,32.5,1.2039999999999999E-2,26,28,1.2039999999999999E-2,{"$f":"Output_series!I58","v":0.97463722619570259},{"$f":"Output_series!J58","v":5.1601783715872518},{"$f":"Output_series!P58","v":13.663076125319384},1,1000,-1000,500,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X58+0.002","v":1.2999999986865558E-2},0.9,0.9,1]
[42,30.7,1.3269999999999999E-2,26,28,1.3269999999999999E-2,{"$f":"Output_series!I59","v":0.97728579134200089},{"$f":"Output_series!J59","v":5.3838083970740751},{"$f":"Output_series!P59","v":13.59844424652222},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X59+0.002","v":1.2999999975671124E-2},0.9,0.9,1]
[43,29.4,1.251E-2,26,28,1.251E-2,{"$f":"Output_series!I60","v":0.96915704128431868},{"$f":"Output_series!J60","v":5.1847160931283058},{"$f":"Output_series!P60","v":13.641445664773695},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X60+0.002","v":1.2999999979335182E-2},0.9,0.9,1]
[44,27,1.2489999999999999E-2,26,28,1.2489999999999999E-2,{"$f":"Output_series!I61","v":0.97233611262724018},{"$f":"Output_series!J61","v":5.1489424006607187},{"$f":"Output_series!P61","v":13.654880336188807},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X61+0.002","v":1.2999999980491457E-2},0.9,0.9,1]
[45,25,1.1890000000000001E-2,26,28,1.1890000000000001E-2,{"$f":"Output_series!I62","v":0.95846183968119758},{"$f":"Output_series!J62","v":3.8918370288757105},{"$f":"Output_series!P62","v":13.971161442230553},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X62+0.002","v":1.3000000000000012E-2},0.9,0.9,1]
[46,23.6,1.1779999999999999E-2,26,28,1.1779999999999999E-2,{"$f":"Output_series!I63","v":1.194909057551109},{"$f":"Output_series!J63","v":3.3685448382436118},{"$f":"Output_series!P63","v":14.163671914237138},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X63+0.002","v":1.2999999999999996E-2},0.9,0.9,1]
[47,22.6,1.157E-2,26,28,1.157E-2,{"$f":"Output_series!I64","v":1.3580429455662022},{"$f":"Output_series!J64","v":2.8884437405346652},{"$f":"Output_series!P64","v":14.322057422453375},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X64+0.002","v":1.2999999999999996E-2},0.9,0.9,1]
[48,21.8,1.15E-2,26,28,1.15E-2,{"$f":"Output_series!I65","v":1.4928496107148346},{"$f":"Output_series!J65","v":2.5836481671483154},{"$f":"Output_series!P65","v":14.433173244791936},1,500,-500,250,25,7.0000000000000001E-3,1.0999999999999999E-2,26,{"$f":"Output_series!X65+0.002","v":1.2999999999999989E-2},0.9,0.9,1]

{"sheet":"Method_input","index":7,"n_rows":147,"n_cols":9,"rows_kept":147,"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","h",1,"0…8760","M1-9","No"]
["external temperature of the calculation interval","Je","theta_e","°C",21.8,"-50…+50","M1-13","Yes"]
["external air moisture content of the calculation interval","xe","x_e","kg/kg dry air",1.15E-2,"0...∞","M1-13","Yes"]
["Temperature of the thermal zone where the duct or ahu losses go to","JIDA;zt","theta_IDA_zt","°C",26,"-50…+50","M2-2","Yes"]
["Temperature of the unconditioned duct surrounding","Jsur;nc","theta_sur_nc","°C",28,"-50…+50","M2-2","Yes"]
["Moisture content of the unconditioned duct surrounding","xsur;nc","x_sur_nc","kg/kg dry air",1.15E-2,"0...∞","M2-2","Yes"]
["AHU heating coil input","QH;ahu;in","Q_H_ahu_in","kWh",1.4928496107148346,"0...∞","M3-1","Yes"]
["AHU cooling coil output","QC;ahu;out;","Q_C_ahu_out","kWh",2.583648167148263,"0...∞","M4-1","Yes"]
["AHU cooling coil inlet temperature","JC;ahu;in","theta_C_ahu_in","°C",14.433173244791936,"0…25","M4-1","Yes"]
["Operation requirement signal","fop;V","f_op_V","-",1,"0…1","M5-5","Yes"]
["Required supply air volume flow rate per ventilation zone i","qV;SUP;dis;zv;req;i","q_V_SUP_dis_zv_req_i","m3/h",500,null,"M5-5","Yes","In case of demand controlled operation, including operation for mechanical ventilative cooling purpose."]
["Required return air volume flow rate per ventilation zone i","qV;ETA;dis;zv;req;i","q_V_ETA_dis_zv_req_i","m3/h",-500,null,"M5-5","Yes"]
["Required supply outdoor air volume flow rate per ventilation zone i","qV;ODA;zv;req;i","q_V_ODA_zv_req_i","m3/h",250,null,"M5-5","Yes"]
["Required ventilation zone supply air temperature","JSUP;req;zv","theta_SUP_req_zV","°C",25,"0...∞","M5-5","Yes"]
["Required ventilation zone supply air moisture content","xSUP;zt;min;req","x_SUP_zV:min_req","kg/kg dry air",7.0000000000000001E-3,"0...∞","M6-2","Yes"]
["Required ventilation zone supply air moisture content","xSUP;zt;max;req","x_SUP_zV_max_req","kg/kg dry air",1.0999999999999999E-2,"0...∞","M7-2","Yes"]
["Ventilation zone return air temperature","JETA;zv","theta_a_ETA_zV","°C",26,"0…+50","M5-5","Yes"]
["Thermal zone return air moisture content","xETA;zv","x_a_ETA_zV","kg/kg dry air",1.2999999999999946E-2,"0…100","M6-2, \nM7-2","Yes"]
["Average partial load factor (averaged over all zones)","fpl","f_pl","–",0.9,null,"Local","Yes","Per zone (according to ventilation related zoning)"]
["Partial load diversity (over all zones)","DfV","delta_f_V","–",0.9,null,"Local","Yes","Per zone (according to ventilation related zoning)"]
["Operation factor of the control devices","fop;ctrl","f_op_ctrl","-",1,null,"Local","Yes"," In case of humidification or dehumidification need; local in case of a system based control scheme (return air humidity control); instead, an operation signal may be needed."]
[]
[]
["Product data"]
["Product description data "]
["Heat recovery type","HEAT_REC_TYPE",null,null,{"$f":"IF(System_configuration!B71=1,System_configuration!C71,IF(System_configuration!B71=2,System_configuration!C72,IF(System_configuration!B71=3,System_configuration!C73,IF(System_configuration!B71=4,System_configuration!C74,IF(System_configuration!B71=5,System_configuration!C75,System_configuration!C76)))))","v":"ROT_NH"},"List","Local","NO","Single zone, multi zone"]
[null,null,null,null,{"$f":"IF(System_configuration!B78=1,System_configuration!C78,System_configuration!C79)","v":"-"},null,null,null,"only for FLAT_PLATE and ROT_HYG"]
["Frost protection type","DEFR_TYPE",null,null,{"$f":"IF(System_configuration!B58=1,System_configuration!C58,IF(System_configuration!B58=2,System_configuration!C59,System_configuration!C60))","v":"PREH"},"List","Local","NO","L_hts: Heated space; L_uts: Unheated space"]
["Humidifier type","HUM_TYPE",null,null,{"$f":"IF(System_configuration!B93=1,System_configuration!C93,IF(System_configuration!B93=2,System_configuration!C94,IF(System_configuration!B93=3,System_configuration!C95,IF(System_configuration!B93=4,System_configuration!C96,System_configuration!C97))))","v":"CONTACT"},"List","Local","NO","IN_AIR, OUT_AIR"]
["Energy carrier for steam humidifier","GEN_CRHU;gen",null,null,{"$f":"IF(E34=\"STEAM\",IF(System_configuration!B99=1,System_configuration!C99,IF(System_configuration!B99=2,System_configuration!C100,IF(System_configuration!B99=3,System_configuration!C101,System_configuration!C102))),\"-\")","v":"-"}]
[]
["Product technical data "]
["Duct leakage factor","flea;du;SUP",null,"-",1.02]
["Duct leakage factor","flea;du;ETA",null,"-",1.02]
["Duct leakage factor","flea;du;zv",null,"-",1.02]
["Duct leakage factor","flea;du;nc",null,"-",1.02]
["Air handling unit leakage factor","flea;ahu;SUP",null,"-",1.04]
["Air handling unit leakage factor","flea;ahu;ETA",null,"-",1.04]
["Nominal supply air volume flow rate of the air handling unit","qV;SUP;ahu;nom",null,"m3/h",5000]
["Supply air volume flow rate of the air handling unit at stage 1..n","qV;SUP;ahu;st1..stn",null,"m3/h",3000]
["Nominal extract air volume flow rate of the air handling unit","qV;ETA;ahu;nom",null,"m3/h",5000]
["Extract air volume flow rate of the air handling unit at stage 1..n","qV;ETA;ahu;st1..stn",null,"m3/h",3000]
["Number of stages","nst",null,"-",1]
["Minimum volume flow rate ratio","nq;min",null,"-",0.2]
["Recovered ratio of the fan power","ffan;rd",null,"-",{"$f":"IF(System_configuration!B108=1,System_configuration!M94,System_configuration!M95)","v":0.6}]
["Nominal heat recovery temperature efficiency at design air velocity","hhr;nom",null,"-",{"$f":"IF(System_configuration!B71=1,System_configuration!N69,IF(System_configuration!B71=2,System_configuration!P69,IF(System_configuration!B71=3,System_configuration!Q69,IF(System_configuration!B71=4,System_configuration!R69,System_configuration!S69))))","v":0.69}]
["Maximum (design) supply air flow rate of the system","qV;SUP;hr;nom",null,"m3/h",5000]
["Nominal air velocity for the heat recovery","vhr;nom",null,"m/s",{"$f":"IF(System_configuration!B71=1,System_configuration!N70,IF(System_configuration!B71=2,System_configuration!N70,IF(System_configuration!B71=3,System_configuration!N70,IF(System_configuration!B71=4,System_configuration!N70,System_configuration!N70))))","v":3.5}]
["Constant for the velocity dependence of the heat recovery efficiency","C1",null,"s/m",{"$f":"IF(System_configuration!B71=1,System_configuration!N71,IF(System_configuration!B71=2,System_configuration!P71,IF(System_configuration!B71=3,System_configuration!Q71,IF(System_configuration!B71=4,System_configuration!R71,System_configuration!S71))))","v":-6.4299999999999996E-2}]
["Constant for the velocity dependence of the heat recovery efficiency","C2",null,"-",{"$f":"IF(System_configuration!B71=1,System_configuration!N72,IF(System_configuration!B71=2,System_configuration!P72,IF(System_configuration!B71=3,System_configuration!Q72,IF(System_configuration!B71=4,System_configuration!R72,System_configuration!S72))))","v":1}]
["Correction factor for the rotation number for rotary heat exchangers ","fn",null,"-",{"$f":"Product_tech_data!D24","v":2.2204460492503131E-16},null,null,null,"See sheet Product_tech_data"]
["Nominal humidity recovery efficiency at design air velocity","hxr;nom",null,"-",{"$f":"IF(System_configuration!B71=1,0,IF(System_configuration!B71=2,System_configuration!M62,IF(System_configuration!B71=3,System_configuration!N62,IF(System_configuration!B71=4,System_configuration!O62,0))))","v":0.3}]
["Nominal humidity recovery efficiency at design air velocity","DxODA;nom",null,"kg / kg dry air",{"$f":"Product_tech_data!K18","v":5.0000000000000001E-3}]
["Factor for moisture difference dependence of the humidity recovery efficiency for rotary heat recoveries","fΔx;x",null,"-",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=4),Product_tech_data!D28,Product_tech_data!D29)","v":0},null,null,null,"See sheet Product_tech_data"]
["Correction factor for the mass flow relation dependence of the humidity recovery efficiency for rotary heat recoveries","fq;x",null,"-",{"$f":"Product_tech_data!D33","v":0.9},null,null,null,"See sheet Product_tech_data"]
["Correction factor for the air velocity dependence of the humidity recovery efficiency for rotary heat recoveries","fv;x",null,"-",{"$f":"Product_tech_data!D34","v":1.7000000000000002},null,null,null,"See sheet Product_tech_data"]
["Correction factor for the rotation speed dependence of the humidity recovery efficiency for rotary heat recoveries","fn;x",null,"-",{"$f":"Product_tech_data!D35","v":0},null,null,null,"See sheet Product_tech_data"]
["Correction factor for other heat recovery types","fxr;other",null,"-",0.4,null,null,null,"proxy value"]
["Heat recovery efficiency reduced due to defrost operation at Je = -15°C, accor­ding to EN 13053:2006","eD;-15",null,"-",0.4]
["Heat recovery efficiency reduced due to defrost operation at Je = -7°C, according to EN 13053:2006","eD;-7",null,"-",0.7]
["Constant for the cooling coil moisture content","CC;1",null,"-",11.908300000000001]
["Constant for the cooling coil moisture content","CC;2",null,"-",4110.34]
["Constant for the cooling coil moisture content","CC;3",null,"-",235]
["cooling coil bypass factor","fC;bp",null,"-",0.1]
["cooling coil temperature efficiency.","hcoil;C",null,"-",0.8]
["heating coil temperature efficiency.","hcoil;H",null,"-",0.8]
["Nominal efficiency of the supply fan, taken from manu­facturer's data, provided according to EN ISO 5801 ","ηfan;SUP;nom",null,"–",0.72]
["Nominal pressure difference over the supply fan, taken from manufacturer's data according to EN ISO 5801 ","Δpfan;SUP;nom",null,"Pa",600]
["Nominal efficiency of the extract fan, taken from manu­facturer's data, provided according to EN ISO 5801 ","ηfan;ETA;nom",null,"–",0.78]
["Nominal pressure difference over the supply fan, taken from manufacturer's data according to EN ISO 5801","Δpfan;ETA;nom",null,"Pa",600]
["Function for the dependence of the efficiency of the supply / extract fan on the volume flow rate, derived from manufacturer's data, provided according to EN ISO 5801 ","fh(qV)",null,"-",{"$f":"Product_tech_data!D49","v":0.4618484599952673},null,null,null,"See sheet Product_tech_data"]
["Function for the dependence of the efficiency of the supply / extract fan on the volume flow rate, derived from manufacturer's data, provided according to EN ISO 5801 ","fh(qV)",null,"-",{"$f":"Product_tech_data!D50","v":0.4618484599952673},null,null,null,"See sheet Product_tech_data"]
["Function for the dependence of the pressure difference over the supply / extract fan on the volume flow rate, derived from manufacturer's data, provided according to EN ISO 5801 ","fΔp(qV)",null,"-",{"$f":"Product_tech_data!D51","v":1.3181671345279999},null,null,null,"See sheet Product_tech_data"]
["Function for the dependence of the pressure difference over the supply / extract fan on the volume flow rate, derived from manufacturer's data, provided according to EN ISO 5801 ","fΔp(qV)",null,"-",{"$f":"Product_tech_data!D52","v":1.3181671345279999},null,null,null,"See sheet Product_tech_data"]
["Supply air handling unit surface area","Aahu;SUP",null,"m2",35]
["Supply air handling unit heat loss coefficient","Uahu;SUP",null,"kW/m2 K",5.0000000000000001E-4]
["Extract air handling unit surface area","Aahu;ETA",null,"m2",35]
["Extract air handling unit heat loss coefficient","Uahu;ETA",null,"kW/m2 K",5.0000000000000001E-4]
["Maximum heat transfer power of the heat recovery device","Φhr;max",null,"kW",{"$f":"IF(System_configuration!B71=1,System_configuration!N73,IF(System_configuration!B71=2,System_configuration!P73,IF(System_configuration!B71=3,System_configuration!Q73,IF(System_configuration!B71=4,System_configuration!R73,System_configuration!S73))))","v":0.5}]
["Maximum rotation speed of the rotary heat recovery device","nrot;max",null,"min-1",17.5]
["Rotor drive power at max. rotation speed","Phr;rot;max",null,"kW",{"$f":"IF(System_configuration!B71=1,System_configuration!N75,IF(System_configuration!B71=2,System_configuration!P75,IF(System_configuration!B71=3,System_configuration!Q75,IF(System_configuration!B71=4,System_configuration!R75,System_configuration!S75))))","v":0.05}]
["Relative pump power consumption per transported volume at maximum speed","pel;hr;pu;max",null,"kWh/m3",{"$f":"IF(System_configuration!B71=1,System_configuration!N76,IF(System_configuration!B71=2,System_configuration!P76,IF(System_configuration!B71=3,System_configuration!Q76,IF(System_configuration!B71=4,System_configuration!R76,System_configuration!S76))))","v":1.0000000000000001E-5}]
["Minimum part load factor of the heat recovery","fpl;hr;min",null,"-",{"$f":"IF(System_configuration!B71=1,System_configuration!N77,IF(System_configuration!B71=2,System_configuration!P77,IF(System_configuration!B71=3,System_configuration!Q77,IF(System_configuration!B71=4,System_configuration!R77,System_configuration!S77))))","v":1.0000000000000001E-5}]
["Efficiency of the adiabatic cooling humidifier","hhu;ac",null,"-",0.9]
["Electric power consumption of the control devices (sensors, actuators, controllers)","SPel;V;ctrl",null,"kW",0.1]
["Design air volume flow rate of the humidified system ","qV;SUP;HU;des",null,"m3/h",5000]
["Specific power consumption of the humidification pump per volume flow rate","pel;HU;des",null,"kWh/m3",2.0000000000000001E-4]
["Design water evaporation mass flow rate of the humidifier","qm;w;HU,des ",null,"kg/h",13.5]
[]
["System design data"]
["Process design"]
["Supply fan localisation","SUP_FAN_LOC",null,null,{"$f":"IF(System_configuration!B119=1,System_configuration!C119,System_configuration!C120)","v":"DOWN_HR"},"List","Local","NO","IN_AIR, OUT_AIR"]
["Extract fan localisation","ETA_FAN_LOC",null,null,{"$f":"IF(System_configuration!B68=1,System_configuration!C68,System_configuration!C69)","v":"UP_HR"},"List","Local","NO","IN_AIR, OUT_AIR"]
["Fan motor localisation","FAN_MOT_LOC",null,null,{"$f":"IF(System_configuration!B108=1,System_configuration!C108,System_configuration!C109)","v":"OUTS_AIR"},"List","Local","NO","IN_AIR, OUT_AIR"]
["System type for variable air volume flow rate fan energy calculation","SYS_TYPE",null,null,{"$f":"IF(System_configuration!B111=1,System_configuration!C111,System_configuration!C112)","v":"SINGLE_ZONE"},"List","Local","NO","L_hts: Heated space; L_uts: Unheated space"]
["Air handling unit localisation","AHU_LOC",null,null,{"$f":"IF(System_configuration!B41=1,System_configuration!C41,System_configuration!C42)","v":"NC"},"List","Local","NO","L_hts: Heated space; L_uts: Unheated space"]
["Heat transfer coefficient from the supply duct to the non-conditioned surrounding","Hdu;SUP;nc",null,"kW/K",0.01,null,null,"NO"]
["Heat transfer coefficient of the supply air duct to a specific conditioned thermal zone.","Hdu;SUP;zt;i",null,"kW/K",0.01,null,null,"NO"]
["Heat transfer coefficient from the extract duct to the non-conditioned surrounding","Hdu;ETA;nc",null,"kW/K",0.01,null,null,"NO"]
["Maximum design required supply air volume flow rate for ventilation zone i","qV;SUP;dis;zv;max;des;i",null,"m3/h",5000,null,"M5-5","NO"]
["Design supply outdoor air volume flow rate for ventilation zone i","qV;ODA;zv;req;des;i",null,"m3/h",5000,null,"M5-5","NO"]
["Number of ventilation zones","nzv",null,"-",1,null,null,"NO"]
["Supply temperature setpoint (for constant supply temperature control)","JSUP;set",null,"°C",18,null,null,"NO"]
["Maximum supply air temperature setpoint for ODA_COMP control option","JSUP;set;max",null,"°C",23,"0...∞",null,"NO"]
["Maximum supply air temperature setpoint for ODA_COMP control option","JSUP;set;min",null,"°C",19,"0...∞",null,"NO"]
["Slope factor for ODA_COMP control option","fe",null,"-",-0.4,"0...∞",null,"NO"]
["Temperature offset for ODA_COMP control option","DJoff",null,"K",29,null,null,"NO"]
["Design air velocity in the heat recovery unit","vhr;des",null,"m/s",3.5,null,null,"NO"]
["Outdoor air temperature limit 1 for defrost operation calculation","Je;lim1",null,"°C",{"$f":"System_configuration!M103","v":-10},null,null,"NO"]
["Outdoor air temperature limit 2 for defrost operation calculation","Je;lim2",null,"°C",{"$f":"System_configuration!M104","v":-5},null,null,"NO"]
["Limit for the exhaust air temperature after the heat recovery","JEHA;hr;lim",null,"°C",-5,null,null,"NO"]
["Supply fan design pressure difference","DpSUP;des",null,"Pa",600,null,null,"NO"]
["Extract fan design pressure difference","DpETA;des",null,"Pa",600,null,null,"NO"]
["Pressure drop of the heat recovery device in the supply and extract air stream at design conditions","DpSUP+ETA;des;hr",null,"Pa",500,null,null,"NO"]
["Controlled portion of the design supply pressure difference","fDp;SUP;ctrl",null,"-",0.8,null,null,"NO"]
["Controlled portion of the design extract pressure difference","fDp;ETA;ctrl",null,"-",0.8,null,null,"NO"]
[]
["Control type data"]
["Control of the volume flow rate ","AIR_FLOW_CTRL",null,null,{"$f":"IF(System_configuration!B49=1,System_configuration!C49,IF(System_configuration!B49=2,System_configuration!C50,IF(System_configuration!B49=3,System_configuration!C51,System_configuration!C52)))","v":"VARIABLE"},"List","Local","NO","Constant, stepped, variable speed…"]
["Control of the supply air temperature","SUP_TEMP_CTRL",null,null,{"$f":"IF(System_configuration!B44=1,System_configuration!C44,IF(System_configuration!B44=2,System_configuration!C45,IF(System_configuration!B44=3,System_configuration!C46,System_configuration!C47)))","v":"ODA_COMP "}]
["Control of the air recirculation","RCA_CTRL",null,null,{"$f":"IF(System_configuration!B89=1,System_configuration!C90,IF(System_configuration!B89=2,System_configuration!C91,System_configuration!C89))","v":"ZONE_BASED"}]
["Control of the heat recovery device","HEAT_REC_CTRL",null,null,{"$f":"IF(System_configuration!B81=1,System_configuration!C81,IF(System_configuration!B81=2,System_configuration!C82,IF(System_configuration!B81=3,System_configuration!C83,System_configuration!C84)))","v":"SPEED"},"List","Local","NO","Depending on type"]
["Control of the frost protection","DEFR_CTRL",null,null,{"$f":"IF(System_configuration!B62=1,System_configuration!C62,System_configuration!C63)","v":"INDIRECT"},"List","Local","NO","Preheating, bypass…"]
["Control of the fan","FAN_CTRL",null,null,{"$f":"IF(System_configuration!B114=1,System_configuration!C114,IF(System_configuration!B114=2,#REF!,IF(System_configuration!B114=3,System_configuration!C115,System_configuration!C116)))","v":"-"},"List","Local","NO","a, b, c"]
["Control of the humidifier","HUM_CTRL",null,null,{"$f":"IF(System_configuration!B104=1,System_configuration!C104,IF(System_configuration!B104=2,System_configuration!C105,System_configuration!C106))","v":"ON_OFF"},"List","Local","NO","…"]
[]
["Constants"]
["Atmonsperic pressure","patm",null,"Pa",101325]
["Air density ","ra",null,"kg/m3",1.204]
["Specific heat of the air at constant pressure","ca",null,"kWh/(kg K)",2.7900000000000001E-4]
["Evaporation heat of the water","rw",null,"kWh/kg",0.68]
["Density correction"]
["Height above sea level","h",null,"m",400]
["Air density at h above sea level","ρa",null,"kg/m3",{"$f":"E134*(1-0.00651*E138/288)^4.255","v":1.1583563641239809}]
[]
["Assumptions for data from non-inplemented calculations"]
["temperature difference in ground preheating according to annex C (to be added)","DJgnd",null,"K",0]
["difference in moisture content in ground preheating according to annex C (to be added)","Dxgnd",null,"kg/kg dry air",0]
["Saturation moisture content at axtract air distribution leaving wetbulb temperature, calculated according to equations (51) and (52) with Jwb;ETA;dis;ou","xwb;ETA;dis;out",null,"kg/kg dry air",1.55E-2]
["Extract air distribution leaving wetbulb temperature; this is calculated through psychrometric calculaton methods, e.g. according to [2], which involves iteration","Jwb;ETA;dis;out",null,"°C",21]
["temperature difference in ground preheating according to annex C (to be added)","DJODA;du",null,"K",0]
["difference in moisture content in ground preheating according to annex C (to be added)","DxODA;du",null,"kg/kg dry air",0]

{"sheet":"Method_calculation","index":8,"n_rows":187,"n_cols":10,"rows_kept":187,"cut":false,"hidden":false,"merged":[[39,6,40,6],[39,2,40,2],[39,3,40,3],[93,0,97,0],[39,4,40,4],[93,4,95,4],[51,2,52,2],[51,4,52,4],[51,0,52,0],[53,0,54,0],[53,2,54,2],[53,4,54,4],[93,6,95,6],[93,2,95,2],[39,0,40,0],[0,0,0,6],[34,4,35,4],[34,3,35,3],[34,2,35,2],[34,0,35,0],[34,6,35,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.4.2.1.1.1 Detailed calculation"]
["Volume flow rates required to be provided by the air handling unit to the distribution duct system","qV;SUP;dis;in;req","m3/h",{"$f":"IF(System_configuration!B38=1,Method_input!E38*q_V_SUP_dis_zv_req,\"-\")","v":510},"Formula (4a)"]
["Volume flow rates required to be provided by the air handling unit to the distribution duct system","qV;ETA;dis;out;req","m3/h",{"$f":"IF(System_configuration!B38=1,-Method_input!E39*q_V_ETA_dis_zv_req,\"-\")","v":510},"Formula (5a)"]
["Supply volume flow rate going to a specific ventilation zone i served by the system","qV;SUP;dis;zv;i","m3/h",{"$f":"IF(D33<>\"-\",D33,IF(D34<>\"-\",D34,IF(D35<>\"-\",D35,D37)))*q_V_SUP_dis_zv_req/IF(D5<>\"-\",D5,D14)","v":980.39215686274508},"Formula (6)",null,"Method output"]
["Volume flow rate extracted from a specific ventilation zone i  served by the system","qV;ETA;dis;zv;i","m3/h",{"$f":"-IF(D33<>\"-\",D33,IF(D34<>\"-\",D34,IF(D35<>\"-\",D35,D37)))*q_V_ETA_dis_zv_req/IF(D5<>\"-\",D5,D14)","v":980.39215686274508},"Formula (7)",null,"Method output"]
["Supply leakage volume flow rate going to the specific zone i","qV;lea;SUP;dis;zv;i","m3/h",{"$f":"(Method_input!E40-1)*D7","v":19.607843137254918},"Formula (8)","qV;lea;SUP;dis;zv;i = (flea;du;zv -1) × qV;SUP;dis;zv;i","Method output"]
["Extract leakage volume flow rate extracted from the specific ventilation zone i","qV;lea;ETA;dis;zv;i","m3/h",{"$f":"(Method_input!E40-1)*D8","v":19.607843137254918},"Formula (9)","qV;lea;ETA;dis;zv;i = (flea;du;zv -1) × qV;ETA;dis;zv;i","Method output"]
["Leakage volume flow rate going to the non-conditioned space","qV;lea;dis;nc","m3/h",{"$f":"(Method_input!E41-1)*IF(D33<>\"-\",D33,IF(D34<>\"-\",D34,IF(D35<>\"-\",D35,D37)))","v":20.000000000000018},"Formula (10)","qV;lea;dis;nc, = (flea;du;nc -1) × qV;SUP;dis;in"]
["Maximum volume flow rate factor","fV;max","-",{"$f":"IF(System_configuration!B38=1,MAX(D7/Method_input!E105),\"-\")","v":0.19607843137254902},"Formula (11a)"]
["6.4.2.1.1.2 Simplified calculation"]
["Volume flow rate required to be provided by the air handling unit to the distribution duct system","qV;SUP;dis;in;req","m3/h",{"$f":"IF(System_configuration!B38=2,f_pl*Method_input!E44,\"-\")","v":"-"},"Formula (4b)","qV;SUP;dis;in;req = fpl × qV;SUP;ahu;nom"]
["Volume flow rate required to be provided by the air handling unit to the distribution duct system","qV;ETA;dis;out;req","m3/h",{"$f":"IF(System_configuration!B38=2,f_pl*Method_input!E46,\"-\")","v":"-"},"Formula (5b)","qV;ETA;dis;out;req = fpl × qV;ETA;ahu;nom"]
["Maximum volume flow rate factor","fV;max","-",{"$f":"IF(System_configuration!B38=2,f_pl+delta_f_V,\"-\")","v":"-"},"Formula (11b)","fV;max = fpl + DfV"]
["6.4.2.1.2 Air temperature and humidity change in the ductwork"]
["Required supply air temperature modified in the duct","JSUP,dis,in;req","°C",{"$f":"theta_SUP_req_zV+D20+D21","v":24.880910772067097},"Formula (12)"]
["Real supply air temperature are modified in the duct as follows","JSUP,dis,out","°C",{"$f":"D132-D20-D21","v":20.399089227933057},"Formula (13)",null,"Method output"]
["Temperature drop due to the supply duct heat losses to the non-conditioned space","DJSUP;du;nc","°C",{"$f":"(theta_SUP_req_zV-theta_sur_nc)*(1-EXP(-(Method_input!E102/(Method_input!E139*Method_input!E135*IF(System_configuration!B49=1,D33,IF(System_configuration!B49=2,D34,IF(System_configuration!B49=3,D35,D37)))))))","v":-9.1405670080388801E-2},"Formula (14)"]
["Temperature drop due to the supply duct heat losses to the conditioned space","DJSUP;du;cnd","°C",{"$f":"(theta_SUP_req_zV-D20-theta_IDA_zt)*(1-EXP(-(Method_input!E103/(Method_input!E139*Method_input!E135*IF(System_configuration!B49=1,D33,IF(System_configuration!B49=2,D34,IF(System_configuration!B49=3,D35,D37)))))))","v":-2.7683557852514674E-2},"Formula (15)"]
["Real supply air humidity content ","xSUP,dis,out","kg/kg dry air",{"$f":"D133","v":1.0999999999999989E-2},"Formula (16)","xSUP,dis,out = xSUP,dis,in","Method output"]
["Required supply air humidity content ","xSUP,dis,in;min;req","kg/kg dry air",{"$f":"x_SUP_req_zV","v":7.0000000000000001E-3},"Formula (17)","xSUP,dis,in;req = xSUP,dis,out;req"]
["Required supply air humidity content ","xSUP,dis,in;max;req","kg/kg dry air",{"$f":"Method_input!E21","v":1.0999999999999999E-2},"Formula (17)","xSUP,dis,in;req = xSUP,dis,out;req"]
["Extract air temperature","JETA,dis,out","°C",{"$f":"theta_a_ETA_zV/Method_input!E38+(Method_input!E38-1)/Method_input!E38*Method_input!E10+D26","v":25.978278572887582},"Formula (18)"]
["Temperature difference due to the extract duct heat losses to the non-conditioned space","DJdu;ETA","K",{"$f":"(theta_a_ETA_zV-Method_input!E10)*(1-EXP(-Method_input!E104/(Method_input!E139*Method_input!E135*IF(System_configuration!B49=1,D38,IF(System_configuration!B49=2,D39,IF(System_configuration!B49=3,D40,D42))))))","v":-6.0937113386925867E-2},"Formula (19)"]
["Extract air humidity","xETA,dis,out","g/kg dry air",{"$f":"x_a_ETA_zV+(Method_input!E39-1)*x_sur_nc","v":1.3229999999999947E-2},"Formula (20)","xETA,dis,out = xETA,zv + (flea,du - 1)×xsur;nc"]
["6.4.2.2.1 Distribution heat losses"]
["Heat losses of the ductwork ","Qls,V,dis","kWh",{"$f":"t_ci*Method_input!E139*Method_input!E135*(IF(D33<>\"-\",D33,IF(D34<>\"-\",D34,IF(D35<>\"-\",D35,D37)))*(D20+D21)+IF(D38<>\"-\",D38,IF(D39<>\"-\",D39,IF(D40<>\"-\",D40,D42)))*D26+D9*(D132- theta_IDA_zt)+D11*(D132-Method_input!E10))","v":-0.14432739653451498},"Formula (21)",null,"QA output"]
["6.4.2.2.2 Recoverable distribution heat losses"]
["Recoverable heat losses of the ductwork to a specific thermal zone i","Qls,V,dis;rbl;zt;i",null,{"$f":"(IF(System_configuration!B49=1,D33,IF(System_configuration!B49=2,D34,IF(System_configuration!B49=3,D35,D37)))*Method_input!E139*Method_input!E135*D21+D9*Method_input!E139*Method_input!E135*(D123-theta_IDA_zt))*t_ci","v":-0.17363626403874169},"Formula (22)","QV;ls;dis;rbl;zt;i = [qV;SUP;zt;i ⋅ ρa ⋅ ca ⋅ ΔϑSUP;du;cnd + qV,SUP,lea,du;zt;i ⋅ ρa ⋅ ca ⋅ (ϑSUP,dis,in - ϑIDA;zt;i)] × tci","Method output"]
["6.4.3.2.1 Air flow rates in the air handling unit"]
["Supply volume air flow rate (no flow rate control, continuous operation)","qV;SUP;dis;in","m3/h",{"$f":"IF(System_configuration!B49=1,Method_input!E44,\"-\")","v":"-"},"Formula (23a)","qV;SUP;dis;in = qV;SUP;ahu;nom"]
["Supply volume air flow rate (time dependent flow rate control, continuous operation during occupancy time)","qV;SUP;dis;in","m3/h",{"$f":"IF(System_configuration!B49=2,Method_input!E44*f_op_V,\"-\")","v":"-"},"Formula (23b)","qV;SUP;dis;in = fop;V × qV;SUP;ahu;nom"]
["Supply volume air flow rate (multi stage variable flow rate control)","qV;SUP;dis;in","m3/h",{"$f":"IF(System_configuration!B49=3,IF(IF(D5<>\"-\",D5,D14)<(Method_input!E45),Method_input!E15*Method_input!E45,Method_input!E15*Method_input!E44),\"-\")","v":"-"},"Formula (23c)","if qV;SUP;dis;in;req < qV;SUP;ahu;st1:             qV;SUP;dis;in = fop;V  qV;SUP;ahu;st1"]
[null,"qV;SUP;dis;in",null,null,null,"else if qV;SUP;dis;in;req < qV;SUP;ahu;st2:      qV;SUP;dis;in = fop;V  qV;SUP;ahu;st2"]
["Supply volume air flow rate (continuously variable flow rate control)","qV;SUP;dis;in","m3/h",{"$f":"IF(System_configuration!B49=4,f_op_V*MAX(Method_input!E49*Method_input!E44,IF(D5<>\"-\",D5,D14)),\"-\")","v":1000},"Formula (23d)","qV;SUP;dis;in = fop;V × qV;SUP;dis;in;req"]
["Extract volume air flow rate (not control)","qV;ETA;dis;out","m3/h",{"$f":"IF(System_configuration!B49=1,Method_input!E46,\"-\")","v":"-"},"Formula (24a)","qV;ETA;dis;out = qV;ETA;ahu;nom"]
["Extract volume air flow rate (time control)","qV;ETA;dis;out","m3/h",{"$f":"IF(System_configuration!B49=2,f_op_V*Method_input!E46,\"-\")","v":"-"},"Formula (24b)","qV;ETA;dis;out = fop;V × qV;ETA;ahu;nom"]
["Extract volume air flow rate (multi stage variable flow rate control)","qV;ETA;dis;out","m3/h",{"$f":"IF(System_configuration!B49=3,IF(IF(D6<>\"-\",D6,D15)<(Method_input!E47),Method_input!E15*Method_input!E47,Method_input!E15*Method_input!E46),\"-\")","v":"-"},"Formula (24c)","if qV;ETA;dis;out;req < qV;ETA;ahu;st1:                qV;ETA;dis;out = fop;V  qV;ETA;ahu;st1"]
[null,"qV;ETA;dis;out",null,null,null,"else if qV;ETA;dis;out;req < qV;ETA;ahu;st2:         qV;ETA;dis;out = fop;V  qV;ETA;ahu;st2"]
["Extract volume air flow rate (variabel)","qV;ETA;dis;out","m3/h",{"$f":"IF(System_configuration!B49=4,f_op_V*MAX(Method_input!E49*Method_input!E46,IF(D6<>\"-\",D6,D15)),\"-\")","v":1000},"Formula (24d)","qV;ETA;dis;out = fop;V × qV;ETA;dis;out;req"]
["Supply air volume flow rate transported","qv;SUP;ahu","m3/h",{"$f":"Method_input!E42*((1-IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))+IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))*IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O47,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P47,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S47,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O50,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P50,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S50,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O53,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P53,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S53,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O56,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P56,System_configuration!S56))))))))))))*IF(System_configuration!B49=1,D33,IF(System_configuration!B49=2,D34,IF(System_configuration!B49=3,D35,D37)))","v":1066.5200000000002},"Formula (25)","qv;SUP;ahu = flea;ahu;SUP × flea;hr;SUP × qv;SUP;dis;in"]
["Extract air volume flow rate transported","qv;ETA;ahu","m3/h",{"$f":"Method_input!E43*((1-IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))+IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))*IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O48,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P48,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S48,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O51,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P51,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S51,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O54,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P54,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S54,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O57,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P57,System_configuration!S57))))))))))))*IF(System_configuration!B49=1,D38,IF(System_configuration!B49=2,D39,IF(System_configuration!B49=3,D40,D42)))","v":1066.5200000000002},"Formula (26)","qv;ETA;ahu = flea;ahu;ETA × flea;hr;ETA × qv;ETA;dis;out"]
["Supply leakage air volume flow rates ","qv;lea;ahu;SUP","m3/h",{"$f":"(Method_input!E42-1)*IF(D33<>\"-\",D33,IF(D34<>\"-\",D34,IF(D35<>\"-\",D35,D37)))","v":40.000000000000036},"Formula (27)","qv;lea;ahu;SUP = (flea;ahu;SUP -1) × qv;SUP;dis;in"]
["Extract leakage air volume flow rates ","qv;lea;ahu;ETA","m3/h",{"$f":"(Method_input!E43-1)*IF(D38<>\"-\",D38,IF(D39<>\"-\",D39,IF(D40<>\"-\",D40,D42)))","v":40.000000000000036},"Formula (28)","qv;lea;ahu;ETA = (flea;ahu;ETA - 1) × qv;ETA;dis;out"]
["6.4.3.2.2 Supply temperature control"]
["Supply air temperature (constant supply air temperature)","JSUP;ahu;req","°C",{"$f":"IF(System_configuration!B44=1,Method_input!E108-IF(D52<>\"-\",D52,D54),\"-\")","v":"-"},"Formula (29a)","JSUP;ahu;req = JSUP;set - DJfan;SUP"]
["Supply air temperature (Variable set point with outdoor temperature compensation)","JSUP;ahu;req","°C",{"$f":"IF(System_configuration!B44=2,MIN(Method_input!E109,MAX(Method_input!E110,Method_input!E111*theta_e+Method_input!E112))-IF(D52<>\"-\",D52,D54),\"-\")","v":20.237663045811395},"Formula (29b)","JSUP;ahu;req = min[JSUP;set;max;; max(JSUP;set;min ; fe × Je + DJoff)] - DJfan;SUP"]
["Supply air temperature (Variable set point with load dependent compensation)","JSUP;ahu;req","°C",{"$f":"IF(System_configuration!B44=3,D18-IF(D52<>\"-\",D52,D54),\"-\")","v":"-"},"Formula (29c)","JSUP;ahu;req = JSUP,dis,in;req - DJfan;SUP"]
["6.4.3.2.3 Temperature rise in the fan"]
["Air temperature increase in the fan, EN 13141 systems","DJfan;SUP","K",{"$f":"IF(System_configuration!B65=1,0,\"-\")","v":"-"},"Formula (30a)","DJfan;SUP/ETA = 0"]
[null,"DJfan;ETA",null,{"$f":"IF(System_configuration!B65=1,0,\"-\")","v":"-"},null,"DJfan;SUP/ETA = 0"]
["Air temperature increase in the fan, other systems","DJfan;SUP","K",{"$f":"IF(System_configuration!B65=1,\"-\",IF(D138<>\"-\",D138,IF(D140<>\"-\",D140,IF(D142<>\"-\",D142,IF(D144<>\"-\",D144,D146))))*Method_input!E50/(Method_input!E139*Method_input!E135*D136*3600000))","v":4.2336954188607105E-2},"Formula (30b)"]
[null,"DJfan;ETA",null,{"$f":"IF(System_configuration!B65=1,\"-\",IF(D139<>\"-\",D139,IF(D141<>\"-\",D141,IF(D143<>\"-\",D143,IF(D145<>\"-\",D145,D147))))*Method_input!E51/(Method_input!E139*Method_input!E135*D137*3600000))","v":4.4942305215598305E-2}]
["Air temperature leaving the extract fan (If ETA_FAN_LOC = UP_HR)","JETA:hr;in","°C",{"$f":"IF(System_configuration!B68=1,D25+IF(D53<>\"-\",D53,D55),\"-\")","v":26.023220878103182},"Formula (31a)","JETA:hr;in = JETA;dis;out + DJfan;ETA"]
["Air temperature leaving the extract fan (else)","JETA:hr;in","°C",{"$f":"IF(System_configuration!B68=2,D25,\"-\")","v":"-"},"Formula (31b)","JETA:hr;in = JETA;dis;out"]
["6.4.3.2.4 Ground air preheating and -cooling"]
["Air temperature after the ground preheating, if SUP_FAN_LOC = UP_HR, if GND_PREH_CTRL = NONE or SUP_TEMP_CTRL = NO_CTRL","JODA;preh","°C",{"$f":"IF(Method_input!E97=\"UP_HR\",IF(OR(System_configuration!B54=1,System_configuration!B44=4),theta_e+Method_input!E142+Method_input!E146+IF(D52<>\"-\",D52,D54),\"-\"),\"-\")","v":"-"},"Formula (32a)","ϑODA;preh = ϑe + Δϑgnd + ΔϑODA;du + Δϑfan;SUP"]
["Air temperature after the ground preheating, if SUP_FAN_LOC = UP_HR, else if JSUP;ahu;req > Je","JODA;preh","°C",{"$f":"IF(Method_input!E97=\"UP_HR\",IF(AND(System_configuration!B54<>1,System_configuration!B44<>4,theta_e<D49),MIN(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50)),theta_e+Method_input!E142+Method_input!E146+IF(D52<>\"-\",D52,D54)),\"-\"),\"-\")","v":"-"},"Formula (32b)","ϑODA;preh = min(ϑSUP;ahu;req ; ϑe + Δϑgnd + ΔϑODA;du + Δϑfan;SUP)"]
["Air temperature after the ground preheating, if SUP_FAN_LOC = UP_HR, else","JODA;preh","°C",{"$f":"IF(Method_input!E97=\"UP_HR\",IF(AND(System_configuration!B54<>1,System_configuration!B44<>4,theta_e>=D49),MAX(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50)),theta_e+Method_input!E142+Method_input!E146+IF(D52<>\"-\",D52,D54)),\"-\"),\"-\")","v":"-"},"Formula (32c)","ϑODA;preh = max(ϑSUP;ahu;req ; ϑe + Δϑgnd + ΔϑODA;du + Δϑfan;SUP)"]
["Air temperature after the ground preheating (else, if GND_PREH_CTRL = NONE or SUP_TEMP_CTRL = NO_CTRL","JODA;preh","°C",{"$f":"IF(Method_input!E97=\"DOWN_HR\",IF(OR(System_configuration!B54=1,System_configuration!B44=4),theta_e+Method_input!E142+Method_input!E146,\"-\"),\"-\")","v":"-"},"Formula (32d)","ϑODA;preh = ϑe + Δϑgnd + ΔϑODA;du"]
["Air temperature after the ground preheating, else if JSUP;ahu;req > Je","JODA;preh","°C",{"$f":"IF(Method_input!E97=\"DOWN_HR\",IF(AND(System_configuration!B54<>1,System_configuration!B44<>4,theta_e<D49),MIN(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50)),theta_e+Method_input!E142+Method_input!E146),\"-\"),\"-\")","v":"-"},"Formula (32e)","ϑODA;preh = min(ϑSUP;ahu;req ; ϑe + Δϑgnd + ΔϑODA;du)"]
["Air temperature after the ground preheating, else else","JODA;preh","°C",{"$f":"IF(Method_input!E97=\"DOWN_HR\",IF(AND(System_configuration!B54<>1,System_configuration!B44<>4,theta_e>=D49),MAX(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50)),theta_e+Method_input!E142+Method_input!E146),\"-\"),\"-\")","v":21.8},"Formula (32f)","ϑODA;preh = max(ϑSUP;ahu;req ; ϑe + Δϑgnd + ΔϑODA;du)"]
["Air moisture content after the ground preheating","xODA;preh","kg/kg dry air",{"$f":"x_e+Method_input!E143+Method_input!E147","v":1.15E-2},"Formula (33)","xODA;preh = xe + Δxgnd + ΔxODA;du"]
["6.4.3.2.5 Recirculation"]
["Required supply temperature after the heat recovery (If RCA_CTRL = FIX)","JSUP;hr;req","°C",{"$f":"IF(System_configuration!B89=2,(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,IF(D50<>\"-\",D50,D75)))-((1-IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))))*IF(D56<>\"-\",D56,D57))/IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)),\"-\")","v":"-"},"Formula (34a)"]
["Required supply temperature after the heat recovery (else if SUP_AIR_TEMP_CTRL = NO_CTRL)","JSUP;hr;req","°C",{"$f":"IF(System_configuration!B44=4,(1-(1-D85)*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))*IF(D56<>\"-\",D56,D57)+IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))*(1-D85)*IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))),\"-\")","v":"-"},"Formula (34b)","JSUP;hr;req = [1 - (1 – hhr) × fODA;min] × JETA;hr:in + fODA;min × (1 – hhr) × JODA;preh"]
["Required supply temperature after the heat recovery (else if JODA;preh < JETA;hr:in and JODA;preh < J SUP;ahu;req)","JSUP;hr;req","°C",{"$f":"IF(AND(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))<IF(System_configuration!B68=1,D56,D57),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))<IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50))),MIN(IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50)),(1-(1-D85)*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))*IF(System_configuration!B68=1,D56,D57)+IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))*(1-D85)*IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))),\"-\")","v":"-"},"Formula (34c)","JSUP;hr;req = min{JSUP;ahu;req ; [1 - (1 – hhr) × fODA;min] × JETA;hr:in + fODA;min × (1 – hhr) × JODA;preh}"]
["The required supply temperature after the heat recovery (else if JODA;preh > JETA;hr:in and JODA;preh > J SUP;ahu;req)","JSUP;hr;req","°C",{"$f":"IF(AND(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))>IF(System_configuration!B122=1,D106,IF(System_configuration!B68=1,D56,D57)),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))>IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50))),MAX(IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50)),(1-(1-D85)*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))*IF(System_configuration!B122=1,Method_calculation!D106,IF(System_configuration!B68=1,D56,D57))+IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))*(1-D85)*IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))),\"-\")","v":"-"},"Formula (34d)","JSUP;hr;req = max{JSUP;ahu;req ; [1 - (1 – hhr) × fODA;min] × JETA;hr:in + fODA;min × (1 – hhr) × JODA;preh}"]
["Required supply temperature after the heat recovery (else)","JSUP;hr;req","°C",{"$f":"IF(AND(D67=\"-\",D68=\"-\",D69=\"-\",D70=\"-\"),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))),\"-\")","v":21.8},"Formula (34e)","JSUP;hr;req = JODA;preh"]
["Minimum outdoor air fraction is (if RCA_CTRL = VARIABLE)","fODA;min","-",{"$f":"IF(AND(System_configuration!B122=2,System_configuration!B89=3),MIN(IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S49,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S52,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S55,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O58,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P58,System_configuration!S58))))))))))),q_V_ODA_zv_req/D7),\"-\")","v":0.255},"Formula (35a)"]
["Minimum outdoor air fraction is (else if RCA_CTRL = FIX)","fODA;min","-",{"$f":"IF(AND(System_configuration!B122=2,System_configuration!B89=2),MIN(IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S49,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S52,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S55,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O58,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P58,System_configuration!S58))))))))))),Method_input!E106/Method_input!E44),\"-\")","v":"-"},"Formula (35b)"]
["Minimum outdoor air fraction is (else)","fODA;min","-",{"$f":"IF(OR(System_configuration!B122=1,System_configuration!B89=1),IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S49,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S52,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S55,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O58,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P58,System_configuration!S58))))))))))),\"-\")","v":"-"},"Formula (35c)","fODA;min = fODA;hr"]
["Supply temperature after the recirculation (If HEAT_REC_CTRL = NO_CTRL or SUP_AIR_TEMP_CTRL = NO_CTRL)","JSUP;RCA","°C",{"$f":"IF(OR(System_configuration!B81=1,System_configuration!B44=4),(1-IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))*IF(D56<>\"-\",D56,D57)+IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))*IF(D81<>\"-\",D81,D82),\"-\")","v":"-"},"Formula (36a)","JSUP;RCA = (1 – fODA;min) × JETA;hr:in + fODA;min × JSUP;hr"]
["Supply temperature after the recirculation (else)","JSUP;RCA","°C",{"$f":"IF(AND(System_configuration!B84<>1,System_configuration!B47<>4),IF(D67<>\"-\",D67,IF(D68<>\"-\",D68,IF(D69<>\"-\",D69,IF(D70<>\"-\",D70,D71)))),\"-\")","v":21.8},"Formula (36b)","JSUP;RCA = JSUP;hr;req"]
["Supply air moisture content after the recirculation ","xSUP;RCA","g/kg",{"$f":"(1-IF(D78=\"-\",D79,D78))*IF(System_configuration!B122=1,D107,D27)+IF(D78=\"-\",D79,D78)*D89","v":1.1657429999999996E-2},"Formula (37)","xSUP;RCA = (1 – fODA) × xETA;hr;in + fODA × xSUP;hr"]
["Outdoor air factor of the current time step ","fODA","-",{"$f":"IF(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))<>IF(D56<>\"-\",D56,D57),\"-\",IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S49,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S52,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S55,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O58,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P58,System_configuration!S58))))))))))))","v":"-"},"Formula (38a)","if JSUP;hr = JETA;hr:in                                     fODA = fODA;hr "]
["Outdoor air factor of the current time step ","fODA","-",{"$f":"IF(D78=\"-\",MAX(IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)),MIN(IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P49,IF(AND(System_configuration!B119=1,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S49,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P52,IF(AND(System_configuration!B119=1,System_configuration!B68=2,System_configuration!B71=5),System_configuration!S52,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=1),System_configuration!O55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P55,IF(AND(System_configuration!B119=2,System_configuration!B68=1,System_configuration!B71=5),System_configuration!S55,IF(AND(System_configuration!B119=2,System_configuration!B68=2,System_configuration!B71=1),System_configuration!O58,IF(AND(System_configuration!B119=2,System_configuration!B68=2,OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4)),System_configuration!P58,System_configuration!S58))))))))))),(IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))-IF(D56<>\"-\",D56,D57))/(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-IF(D56<>\"-\",D56,D57)))),\"-\")","v":0.90900000000000003},"Formula (38b)","else","Method output",null,null,{"$f":"IF(D78=\"-\",MAX(IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)),(IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))-IF(D56<>\"-\",D56,D57))/(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-IF(D56<>\"-\",D56,D57))),\"-\")","v":1}]
["6.4.3.2.6 Heat recovery"]
["Supply air temperature after the heat recovery (no heat recovery control) ","JSUP;hr","°C",{"$f":"IF(System_configuration!B81=1,IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))+D85*(IF(System_configuration!B68=1,D56,D57)-IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))),\"-\")","v":"-"},"Formula (39a)","JSUP;hr = JODA;preh + hhr (JETA;hr;in - JODA;preh)"]
["Supply air temperature after the heat recovery (else if JODA;preh < JETA;hr:in and JODA;preh < J SUP;ahu;req)","JSUP;hr","°C",{"$f":"IF(AND(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))<IF(System_configuration!B68=1,D56,D57),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))<IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50))),MIN(IF(D98<>\"-\",D98,IF(D100<>\"-\",D100,D102)),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))+D85*(IF(System_configuration!B68=1,D56,D57)-IF(D97<>\"-\",D97,IF(D99<>\"-\",D99,D101)))),\"-\")","v":"-"},"Formula (39b)","JSUP;hr = min[JSUP;hr;lim ; JODA;preh + hhr (JETA;hr;in - JODA;fp)]"]
["Supply air temperature after the heat recovery (else if JODA;preh > JETA;hr:in and JODA;preh > J SUP;ahu;fp)","JSUP;hr","°C",{"$f":"IF(AND(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))>IF(System_configuration!B68=1,D56,D57),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))>IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50))),MAX(IF(D67<>\"-\",D67,IF(D68<>\"-\",D68,IF(D69<>\"-\",D69,IF(D70<>\"-\",D70,D71)))),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))+D85*(IF(System_configuration!B122=1,D106,IF(System_configuration!B68=1,D56,D57))-IF(D97<>\"-\",D97,IF(D99<>\"-\",D99,D101)))),\"-\")","v":"-"},"Formula (39c)","JSUP;hr = max[JSUP;hr;req ; JODA;preh + hhr (JETA;hr;in - JODA;fp)]"]
["Supply air temperature after the heat recovery (else)","JSUP;hr","°C",{"$f":"IF(OR(AND(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))>IF(System_configuration!B68=1,D56,D57),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))>IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50))),AND(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))<IF(System_configuration!B68=1,D56,D57),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))<IF(System_configuration!B44=1,D48,IF(System_configuration!B44=2,D49,D50)))),\"-\",IF(D97<>\"-\",D97,IF(D99<>\"-\",D99,D101)))","v":21.8},"Formula (39d)","JSUP;hr = JODA;fp"]
["Heat recovery temperature efficiency ","hhr","-",{"$f":"Method_input!E51*D86*D87","v":0.83683818472805993},"Formula (40)","hhr = hhr;nom × fq × fv × fn"]
["Correction factor for the mass flow ratio other than 1 ","fq","-",{"$f":"((D44-D43)/(D43*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))+1)^0.4","v":1},"Formula (41)"]
["Correction factor for the air velocity ","fv","-",{"$f":"Method_input!E54*(D88-Method_input!E53)+Method_input!E55","v":1.212808963374},"Formula (42)","fv = C1 (vhr;eff – vhr;nom) + C2"]
["Air velocity ","vhr;eff","m/s",{"$f":"(Method_input!E113*D43*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))/Method_input!E52","v":0.19037382000000005},"Formula (43)"]
["Moisture content of the supply air after the heat recovery","xSUP;hr","kg/kg dry air",{"$f":"IF(OR(System_configuration!B71=3,System_configuration!B71=4),D65+IF(D90<>\"-\",D90,D92)*(IF(System_configuration!B122=1,Method_calculation!D107,D27)-D65),D65)","v":1.15E-2},"Formula (44)","xSUP;hr = xODA;preh + hxr (xETA;hr;in - xODA;preh)"]
["Humidity recovery efficiency, rotary heat exchanger","hxr","-",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4),Method_input!E57*Method_input!E59*Method_input!E60*Method_input!E61*Method_input!E62,\"-\")","v":0},"Formula (45a)","hxr = hxr;nom × fDx;x × fq;x × fv;x × fn;x"]
["Humidity recovery efficiency for heat exchanger, if HEAT_REC_TYPE = OTHER","hxr","-",{"$f":"IF(Method_input!E31=\"OTHER\",Method_input!E57*Method_input!E63,\"-\")","v":"-"},"Formula (45b)","ηxr = ηxr;nom ⋅ fxr;other"]
["Humidity recovery efficiency, else","hxr","-",{"$f":"IF(OR(System_configuration!B71=1,System_configuration!B71=5),0,\"-\")","v":"-"},"Formula (45c)","hxr = 0"]
["6.4.3.2.7 Frost protection"]
["The effect of frost protection on heat recovery, if DEFR_CTRL = DIRECT","ηhr","-",{"$f":"IF(System_configuration!B62=1,IF(theta_e<Method_input!E114,Method_input!E64,\"-\"),\"-\")","v":"-"},"Formula (46)","if Je < Je;lim1:           ηhr = εD;-15"]
[null,"ηhr",null,{"$f":"IF(System_configuration!B62=1,IF(theta_e<Method_input!E115,IF(theta_e<Method_input!E114,Method_input!E65,\"-\"),\"-\"),\"-\")","v":"-"},null,"else if Je < Je;lim2:    ηhr = εD;-7"]
[null,"ηhr",null,{"$f":"IF(System_configuration!B62=1,IF(theta_e>=Method_input!E115,D85,\"-\"),\"-\")","v":"-"},null,"else                         ηhr = ηhr"]
[null,"JODA;fp","°C",{"$f":"IF(System_configuration!B62=1,IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))),\"-\")","v":"-"},"Formula (47a)","JODA;fp = JODA;preh"]
[null,"JSUP;hr;lim","°C",{"$f":"IF(System_configuration!B62=1,IF(D67<>\"-\",D67,IF(D68<>\"-\",D68,IF(D69<>\"-\",D69,IF(D70<>\"-\",D70,D71)))),\"-\")","v":"-"},"Formula (48a)","JSUP;hr;lim = JSUP;hr;req "]
["The effect of frost protection on outdoor air, if DEFR_CTRL = INDIRECT, if DEFR_TYPE = PREH","JODA;fp","°C",{"$f":"IF(System_configuration!B62=2,IF(System_configuration!B58=1,MAX(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))),IF(D67<>\"-\",D67,IF(D68<>\"-\",D68,IF(D69<>\"-\",D69,IF(D70<>\"-\",D70,D71))))-D103*D43*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))/(D43-D44*(1-IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74)))))),\"-\")","v":21.8},"Formula (47b)"]
["The effect of frost protection on outdoor air, if DEFR_CTRL = INDIRECT, if DEFR_TYPE = PREH","JSUP;hr;lim","°C",{"$f":"IF(System_configuration!B62=2,IF(System_configuration!B58=1,IF(D67<>\"-\",D67,IF(D68<>\"-\",D68,IF(D69<>\"-\",D69,IF(D70<>\"-\",D70,D71))))),\"-\")","v":21.8},"Formula (48b)","JSUP;hr;lim = JSUP;hr;req "]
["The effect of frost protection on outdoor air, if DEFR_CTRL = INDIRECT, else","JODA;fp","°C",{"$f":"IF(AND(System_configuration!B62=2,OR(System_configuration!B58=2,System_configuration!B58=3)),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))),\"-\")","v":"-"},"Formula (47c)","JODA;fp = JODA;preh"]
["The effect of frost protection on outdoor air, if DEFR_CTRL = INDIRECT, else","JSUP;hr;lim","°C",{"$f":"IF(AND(System_configuration!B62=2,OR(System_configuration!B58=2,System_configuration!B58=3)),MIN(IF(D67<>\"-\",D67,IF(D68<>\"-\",D68,IF(D69<>\"-\",D69,IF(D70<>\"-\",D70,D71)))),IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))+D103*D43*IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))/(D43-D44*(1-IF(D72<>\"-\",D72,IF(D73<>\"-\",D73,D74))))),\"-\")","v":"-"},"Formula (48c)"]
["Maximum heat recoverd temperature difference","DJETA;hr","K",{"$f":"IF(System_configuration!B62=2,MAX(0,IF(System_configuration!B68=1,D56,D57)-Method_input!E116),\"-\")","v":31.023220878103182},"Formula (49)","DJETA;hr = max(0;  JETA;hr;in - JEHA;hr;lim)"]
["6.4.3.2.8     Adiabatic cooling"]
["Recirculation supply temperature ","JSUP;RCA","°C",{"$f":"MIN(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50)),IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84))))","v":20.237663045811395},"Formula (50)","JSUP;RCA = min(JSUP;ahu;req; JSUP;hr)"]
["Extract air temperature entering the heat recovery","JETA;hr;in","°C",{"$f":"IF(System_configuration!B122=1,MAX((IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50))-IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))))/D85+IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64))))),D25-Method_input!E89*(D25-Method_input!E145)),D25)","v":25.978278572887582},"Formula (51)"]
["Extract air moisture content entering the heat recovery ","xETA;hr;in","kg/kg dry air",{"$f":"IF(System_configuration!B122=1,D27+((Method_input!E144-D27)*(D25-D106))/(D25-Method_input!E145),D27)","v":1.3229999999999947E-2},"Formula (52)"]
["6.4.3.2.9.1 Cooling and dehumidification"]
["Required supply air temperature after the cooling coil in the current time step\nIf SUP_AIR_TEMP_CTRL = NO_CTRL","JSUP;C;req","°C",{"$f":"IF(System_configuration!B44=4,IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76)),\"-\")","v":"-"},"Formula (53a)","JSUP;C;req = JSUP;RCA"]
["Required supply air temperature after the cooling coil in the current time step, else","JSUP;C;req","°C",{"$f":"IF(System_configuration!B44<>4,MIN(D117,IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,IF(D50<>\"-\",D50,D75))),IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))),\"-\")","v":15.906538595833549},"Formula (53b)","JSUP;C;req = min(JSUP;DHU;req; JSUP;ahu;req; JSUP;RCA)",null,null,null,{"$f":"IF(System_configuration!B54=1,D59,D60)","v":"-"}]
["Required supply air moisture content after the cooling coil ","xSUP;C;req","kg/kg dry air",{"$f":"MIN(D24,D77-D112)","v":1.0999999999999989E-2},"Formula (54)","xSUP;C;req = min(xSUP;dis;in;req; xSUP;RCA - DxC)"]
["The difference in moisture content due to uncontrolled dehumidification in the cooling coil ","DxC","kg/kg dry air",{"$f":"MAX(0,(D77-D113)*(1-Method_input!E69))","v":6.5743000000000821E-4},"Formula (55)","DxC = max[0; (xSUP;RCA - xC;coil;req) × (1-fC;bp)]"]
["Required cooling coil surface moisture content ","xC;coil;req","kg/kg dry air",{"$f":"EXP(Method_input!E66-(Method_input!E67/(D114+Method_input!E68)))","v":1.092695222222221E-2},"Formula (56)"]
["Required coil surface temperature for cooling","ϑC;coil;req","°C",{"$f":"(IF(D109<>\"-\",D109,D110)-Method_input!E69*IF(System_configuration!B122=1,D105,IF(OR(System_configuration!B81=1,System_configuration!B44=4),D75,D76)))/(1-Method_input!E69)","v":15.251709550926165},"Formula (57)"]
["Required coil surface moisture content for dehumidification ","xDHU;coil","kg/kg dry air",{"$f":"(D24-Method_input!E69*D77)/(1-Method_input!E69)","v":1.0926952222222222E-2},"Formula (58)"]
["Required coil surface temperature for dehumidification ","JDHU;coil","°C",{"$f":"Method_input!E67/(Method_input!E66-LN(Method_calculation!D115))-Method_input!E68","v":15.251709550926165},"Formula (59)"]
["Resulting supply temperature for dehumidification ","JSUP;DHU;req","°C",{"$f":"IF(Method_input!E21>D77,IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76)),Method_input!E69*IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))+(1-Method_input!E69)*D116)","v":15.906538595833549},"Formula (60)","If xSUP;zt;max;req < xSUP;RCA:     JSUP;DHU;req = fC;bp × JSUP;RCA + (1 - fC;bp) × JDHU;coil;req\nelse:                                  JSUP;DHU;req = JSUP;RCA"]
["Required inlet  temperature to the cooling coil in the current time step","JC;ahu;in;req","°C",{"$f":"(IF(D109<>\"-\",D109,D110)-IF(System_configuration!B122=1,D105,IF(OR(System_configuration!B81=1,System_configuration!B44=4),D75,D76))*(1-Method_input!E70))/Method_input!E70","v":14.433173244791936},"Formula (61)",null,"Method output"]
["Actual supply air temperature after the cooling coil in the current time step ","JSUP;C","°C",{"$f":"IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))-Q_C_V_out/(D43*Method_input!E139*Method_input!E135)-Method_input!E136/Method_input!E135*(D120-D77)","v":15.906538595833702},"Formula (62)"]
["The actual supply air moisture content after the cooling coil ","xSUP;C","kg/kg dry air",{"$f":"MIN((Method_input!E69*D77+(1-Method_input!E69)*EXP(Method_input!E66-Method_input!E67/(D121+Method_input!E68))),Method_calculation!D77)","v":1.0999999999999989E-2},"Formula (63)"]
["Actual cooling coil temperature","ϑC;coil","°C",{"$f":"Method_input!E70*(Method_input!E14-IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76)))/(1-Method_input!E69)+IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))","v":15.251709550926165},"Formula (64)"]
["6.4.3.2.9.2 Humidification"]
["Supply air moisture content after the humidifier ","xSUP;HU","kg/kg dry air",{"$f":"MAX(D23,D120)","v":1.0999999999999989E-2},"Formula (65)","xSUP;HU = max[xSUP;dis;in;min;req; xSUP;C]"]
["Change in supply air temperature in the humidifier, if HUM_TYPE = STEAM","DJSUP;HU","K",{"$f":"IF(System_configuration!B93=5,0,\"-\")","v":"-"},"Formula (66a)","DJSUP;HU = 0"]
["Change in supply air temperature in the humidifier, else","DJSUP;HU","K",{"$f":"IF(OR(System_configuration!B93=1,System_configuration!B93=2,System_configuration!B93=3,System_configuration!B93=4),MAX(0,Method_input!E136/Method_input!E135*(Method_calculation!D123-Method_calculation!D120)),\"-\")","v":0},"Formula (66b)"]
["6.4.3.2.8.3 Heating"]
["Required supply air temperature after the heating coil ","JSUP;H;req","°C",{"$f":"IF(System_configuration!B44=4,IF(D109<>\"-\",D109,D110),\"-\")","v":"-"},"Formula (67a)","JSUP;H;req = JSUP;C;req"]
["Required supply air temperature after the heating coil","JSUP;H;req","°C",{"$f":"IF(OR(System_configuration!B44=1,System_configuration!B44=2,System_configuration!B44=3),MAX(IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,IF(D50<>\"-\",D50))),IF(D109<>\"-\",D109,D110)),\"-\")","v":20.237663045811395},"Formula (67b)","JSUP;H;req = max (JSUP;ahu;req; JSUP;C;req)"]
["Required inlet temperature to the heating coil","JH;ahu;in;req","°C",{"$f":"(IF(D127<>\"-\",D127,D128)-IF(D109<>\"-\",D109,D110)*(1-Method_input!E71))/Method_input!E71","v":21.320444158305854},"Formula (68)",null,"Method output"]
["Actual supply air temperature after the heating coil","JSUP;H","°C",{"$f":"D119+Q_H_V_in/(D43*Method_input!E139*Method_input!E135)-IF(D124<>\"-\",D124,D125)","v":20.237663045811548},"Formula (69)"]
["6.4.3.2.9.4 Fan"]
["Supply air temperature after the supply fan, delivered to the distribution system","JSUP;dis;in","°C",{"$f":"D130+D54","v":20.280000000000154},"Formula (70)","JSUP;dis;in = JSUP;H + DJfan;SUP"]
["The supply air humidity content delivered to the distribution system","xSUP;dis;in","kg/kg dry air",{"$f":"D123","v":1.0999999999999989E-2},"Formula (71)","xSUP;dis;in = xSUP;HU"]
["6.4.4.1. Fan"]
["Fan energy consumption for the current time step is the energy consumption for ventilation","EV;gen;in;el",null,{"$f":"(D43/D136*IF(D138<>\"-\",D138,IF(D140<>\"-\",D140,IF(D142<>\"-\",D142,(IF(D144<>\"-\",D144,D146)))))+D44/D137*IF(D139<>\"-\",D139,IF(D141<>\"-\",D141,IF(D143<>\"-\",D143,(IF(D145<>\"-\",D145,D147))))))*t_ci/3600000","v":4.6771404662294784E-2},"Formula (72)",null,"Method output"]
["Efficiency of the supply fan","ηfan;SUP",null,{"$f":"Method_input!E72*Method_input!E76","v":0.33253089119659246},"Formula (73)","ηfan;SUP/ETA = ηfan;SUP/ETA;nom × fh(qV)"]
["Efficiency of theextract fan","ηfan;ETA",null,{"$f":"Method_input!E74*Method_input!E77","v":0.36024179879630852},"Formula (73)","ηfan;SUP/ETA = ηfan;SUP/ETA;nom × fh(qV)"]
["Supply fan pressure difference  (single zone, no contol)","Δpfan;SUP","Pa",{"$f":"IF(System_configuration!B111=1,IF(System_configuration!B114=1,Method_input!E73*Method_input!E78,\"-\"),\"-\")","v":"-"},"Formula (74a)","Δpfan;SUP = Δpfan;SUP;nom × fΔp(qV)"]
["Extract fan pressure difference (single zone, no contol)","Δpfan;ETA","Pa",{"$f":"IF(System_configuration!B111=1,IF(System_configuration!B114=1,Method_input!E75*Method_input!E79,\"-\"),\"-\")","v":"-"},"Formula (75a)","Δpfan;ETA = Δpfan;ETA;nom × fΔp(qV)"]
["Supply fan pressure difference (single zone, direct)","Δpfan;SUP","Pa",{"$f":"IF(System_configuration!B111=1,IF(System_configuration!B114=4,Method_input!E117*(D43/Method_input!E44)^2,\"-\"),\"-\")","v":27.299157849600014},"Formula (74b)"]
["Extract fan pressure difference (single zone, direct)","Δpfan;ETA","Pa",{"$f":"IF(System_configuration!B111=1,IF(System_configuration!B114=4,Method_input!E118*(D44/Method_input!E46)^2,\"-\"),\"-\")","v":27.299157849600014},"Formula (75b)"]
["Supply fan pressure difference (multi zone, no contol)","Δpfan;SUP","Pa",{"$f":"IF(System_configuration!B111=2,IF(System_configuration!B114=1,Method_input!E73*Method_input!E78,\"-\"),\"-\")","v":"-"},"Formula (74c)","Δpfan;SUP = Δpfan;SUP;nom × fΔp (qV)"]
["Extract fan pressure difference (multi zone, no contol)","Δpfan;ETA","Pa",{"$f":"IF(System_configuration!B111=2,IF(System_configuration!B114=1,Method_input!E75*Method_input!E79,\"-\"),\"-\")","v":"-"},"Formula (75c)","Δpfan;ETA = Δpfan;ETA;nom × fΔp (qV)"]
["Supply fan pressure difference (multi zone, const pres)","Δpfan;SUP","Pa",{"$f":"IF(System_configuration!B111=2,IF(System_configuration!B114=2,Method_input!E117*((1-Method_input!E120)*(Method_calculation!D43/Method_input!E44)^2+Method_input!E120),\"-\"),\"-\")","v":"-"},"Formula (74d)"]
["Extract fan pressure difference (multi zone, const pres)","Δpfan;ETA","Pa",{"$f":"IF(System_configuration!B111=2,IF(System_configuration!B114=2,Method_input!E118*((1-Method_input!E121)*(Method_calculation!D44/Method_input!E46)^2+Method_input!E121),\"-\"),\"-\")","v":"-"},"Formula (75d)"]
["Supply fan pressure difference (multi zone, min pres)","Δpfan;SUP","Pa",{"$f":"IF(System_configuration!B111=2,IF(System_configuration!B114=3,Method_input!E117*((1-Method_input!E120)*(D43/Method_input!E44)^2+Method_input!E120*IF(D12=\"-\",D16,D12)),\"-\"),\"-\")","v":"-"},"Formula (74e)"]
["Extract fan pressure difference (multi zone, min pres)","Δpfan;ETA","Pa",{"$f":"IF(System_configuration!B111=2,IF(System_configuration!B114=3,Method_input!E118*((1-Method_input!E121)*(D44/Method_input!E46)^2+Method_input!E121*IF(D12=\"-\",D16,D12)),\"-\"),\"-\")","v":"-"},"Formula (75e)"]
["6.4.4.2. Ground preheating and -cooling"]
["Energy transferred by the ground preheating, if present","Qgnd","kWh",{"$f":"t_ci*Method_input!E139*Method_input!E135*D43*IF(D78=\"-\",D79,D78)*(IF(D59<>\"-\",D59,IF(D60<>\"-\",D60,IF(D61<>\"-\",D61,IF(D62<>\"-\",D62,IF(D63<>\"-\",D63,D64)))))-theta_e)","v":0},"Formula (76)","Qgnd = ra × ca × qv;SUP;ahu × fODA × (JODA,preh – Je) × tci ","QA output"]
["6.4.4.3 Heat recovery"]
["Energy transferred by the heat recovery","Qhr","kWh",{"$f":"t_ci*Method_input!E139*Method_input!E135*D43*IF(D78=\"-\",D79,D78)*(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-(IF(System_configuration!B62=2,IF(D99<>\"-\",D99,D101),D97))+Method_input!E134/Method_input!E136*(D89-D65))","v":0},"Formula (77)",null,"Method output"]
["Required energy supplied by the heating coil without heat recovery ","QH;ahu;in;tot;req","kWh",{"$f":"MAX(0,t_ci*Method_input!E139*Method_input!E135*D43*(IF(D127=\"-\",D128,D127)+IF(D124=\"-\",D125,D124)-theta_e))","v":0},"Formula (78)","QH;ahu;in;tot;req = max[0 ; rac a × qv;SUP;ahu × (JSUP;H;req + DJSUP;HU – Je) × tci ]","Method output"]
["6.4.4.4 Recirculation"]
["Rnergy transferred by the recirculation, if present, in the current time step","QRCA","kWh",{"$f":"t_ci*Method_input!E139*Method_input!E135*D44*(1-IF(D78<>\"-\",D78,D79))*(IF(D56<>\"-\",D56,D57)-theta_e)","v":0.13246482944914964},"Formula (79)","QRCA = raca × qv;ETA;ahu ×(1-fODA) (JETA;hr;in – Je)×tci ","QA output"]
["6.4.4.5 Cooling and dehumidification"]
["Required energy to be extracted by the cooling coil ","QC;ahu;out;req","kWh",{"$f":"t_ci*D43*(Method_input!E139*Method_input!E135*(IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76))-IF(D109<>\"-\",D109,D110))+Method_input!E139*Method_input!E136*(D77-D111))","v":2.5836481671483154},"Formula (80)",null,"Method output"]
["Required energy to be extracted for dehumidification","QDHU;ahu;out;req","kWh",{"$f":"t_ci*D43*(Method_input!E139*Method_input!E135*(MIN(IF(System_configuration!B122=1,D105,IF(D75<>\"-\",D75,D76)),IF(D48<>\"-\",D48,IF(D49<>\"-\",D49,D50)))-D119)+Method_input!E139*Method_input!E136*(D77-D112-D120))","v":1.4928496107147817},"Formula (81)",null,"QA output"]
["6.4.4.6 Humidification"]
["Energy supplied for humidification  (steam)","EHU;cr","kWh",{"$f":"IF(System_configuration!B93=5,t_ci*D43*Method_input!E139*Method_input!E136*(D123-D120),\"-\")","v":"-"},"Formula (82a)",null,"Method output"]
["Energy supplied for humidification (else)","EHU;cr","kWh",{"$f":"IF(OR(System_configuration!B93=1,System_configuration!B93=2,System_configuration!B93=3,System_configuration!B93=4,),0,\"-\")","v":0},"Formula (82b)","EHU;cr = 0","Method output"]
["Water use for humidification","mw;HU","kg",{"$f":"D43*Method_input!E139*(D123-D120)*t_ci","v":0},"Formula (83)",null,"QA output"]
["6.4.4.7 Heating"]
["Required energy to be supplied by the heating coil ","QH;ahu;in;req","kWh",{"$f":"t_ci*Method_input!E139*Method_input!E135*D43*(IF(D127<>\"-\",D127,D128)+IF(D124<>\"-\",D124,D125)-D110)","v":1.4928496107148346},"Formula (84)","QH;ahu;in;req = rac a × qv;SUP;ahu × (JSUP;H;req + DJSUP;HU – J SUP,C) × tci ","Method output"]
["6.4.4.8 Generation heat losses"]
["Heat losses of the air handling units (cond)","Qls;V;gen","kWh",{"$f":"IF(System_configuration!B41=1,t_ci*Method_input!E80*Method_input!E81*(IF(System_configuration!B81=1,D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-theta_IDA_zt)+Method_input!E82*Method_input!E83*(IF(D56<>\"-\",D56,D57)-theta_IDA_zt)+D45*Method_input!E139*Method_input!E135*(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-theta_IDA_zt),\"-\")","v":"-"},"Formula (85a)","Qls;V;gen = [(A×U)ahu;SUP (JSUP;hr - JIDA;zt) + (A×U)ahu;ETA (JETA;hr;in - JIDA;zt) + qV;lea;ahu;SUP  (rc)a (JSUP;hr - JIDA;zt)]×tci","QA output"]
["Heat losses of the air handling units (else)","Qls;V;gen","kWh",{"$f":"IF(System_configuration!B41=2,t_ci*Method_input!E80*Method_input!E81*(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-Method_input!E10)+Method_input!E82*Method_input!E83*(IF(D56<>\"-\",D56,D57)-Method_input!E10)+Method_calculation!D45*Method_input!E139*Method_input!E135*(IF(D81<>\"-\",D81,IF(D82<>\"-\",D82,IF(D83<>\"-\",D83,D84)))-Method_input!E10)+D46*Method_input!E139*Method_input!E135*(IF(D56<>\"-\",D56,D57)-Method_input!E10),\"-\")","v":-0.24879695996735413},"Formula (85b)","Qls;V;gen = [(A×U)ahu;SUP (JSUP;hr - Jsur;nc) + (A×U)ahu;ETA (JETA;hr;in - Jsur;nc) + qV;lea;ahu;SUP  (rc)a (JSUP;hr - Jsur;nc) +qV;lea;ahu;ETA  (rc)a (JETA;hr;in - Jsur;nc)]×tci","QA output"]
["6.4.4.9 Recoverable generation heat losses"]
["Recoverable heat losses of the air handling units (cond)","QV;ls;gen;rbl","kWh",{"$f":"IF(System_configuration!B41=1,D165,\"-\")","v":"-"},"Formula (86a)","QV;ls;gen;rbl = QV;ls;gen","Method output"]
["Recoverable heat losses of the air handling units (else)","QV;ls;gen;rbl","kWh",{"$f":"IF(System_configuration!B41=2,0,\"-\")","v":0},"Formula (86b)","QV;ls;gen;rbl = 0","Method output"]
["6.4.4.10.1 Ventilation"]
["Auxiliary energy required ventilation system ","WV;aux","kWh",{"$f":"IF(D173<>\"-\",D173,IF(D174<>\"-\",D174,D175))+IF(D178<>\"-\",D178,D179)+D181","v":0.10057974970816422},"Formula (87)","WV;aux = WV;aux;hr + WV;preh + WV;aux;ctrl","Method output"]
["6.4.4.10.1.1 Heat recovery"]
["Auxiliary energy required by the heat recovery system (ROT_NH or ROT_HYG or ROT_SORP)","WV;aux;hr","kWh",{"$f":"IF(OR(System_configuration!B71=2,System_configuration!B71=3,System_configuration!B71=4),Method_input!E86*t_ci*Product_tech_data!D26/Method_input!E85,\"-\")","v":5.7974970816421223E-4},"Formula (88a)"]
["Auxiliary energy required by the heat recovery system  (PUMP_CIRC)","WV;aux;hr","kWh",{"$f":"IF(System_configuration!B71=5,D43*IF(D78=\"-\",D79,D78)*Method_input!E87*t_ci*(MAX(Method_input!E88,Method_calculation!D151/(t_ci*Method_input!E84)))^2.5,\"-\")","v":"-"},"Formula (88b)"]
["Auxiliary energy required by the heat recovery system  (else)","WV;aux;hr","kWh",{"$f":"IF(System_configuration!B71=1,0,\"-\")","v":"-"},"Formula (88c)","WV;aux;hr = 0"]
["Portion of the fan energy consumption for the pressure drop of the heat recovery","EV;gen;in;el;hr","kWh",{"$f":"(D135*Method_input!E119)/(Method_input!E117+Method_input!E118)","v":1.9488085275956159E-2},"Formula (89)",null,"Method output"]
["6.4.4.10.1.2 Frost protection"]
["Energy supplied for frost protection (Preh)","WV;preh","kWh",{"$f":"IF(System_configuration!B58=1,t_ci*(Method_input!E139*Method_input!E135*Method_calculation!D43*IF(D78=\"-\",D79,D78)*((IF(System_configuration!B62=2,IF(System_configuration!B58=1,D99,D101),D97))-theta_e)),\"-\")","v":0},"Formula (90a)","WV;preh = [ra × ca × qv;SUP;ahu × fODA × (JODA,fp – Je)] × tci"]
["Energy supplied for frost protection  (else)","WV;preh","kWh",{"$f":"IF(OR(System_configuration!B58=2,System_configuration!B58=3),0,\"-\")","v":"-"},"Formula (90b)","WV;preh = 0"]
["6.4.4.10.1.3 Control"]
["Auxiliary energy consumption of the control components ","WV;aux;ctrl","kWh",{"$f":"Method_input!E90*f_op_ctrl*t_ci","v":0.1},"Formula (91)","WV;aux;ctrl = S Pel;V;ctrl × fop;ctrl × tci"]
["6.4.4.10.2 Humidification"]
["Energy consumption of the humidification pump (steam)","WHU","kWh",{"$f":"IF(System_configuration!B93=5,0,\"-\")","v":"-"},"Formula (92a)","WHU = 0","Method output"]
["Energy consumption of the humidification pump (else)","WHU","kWh",{"$f":"IF(System_configuration!B93<>5,t_ci*Method_input!E91*Method_input!E92*IF(D185<>\"-\",D185,IF(D186<>\"-\",D186,D187)),\"-\")","v":0},"Formula (92b)","WHU = qV;SUP;HU;des × pel;HU,des × fpl;HU × tci ","Method output"]
["Part load factor of humidification pump (no control)","fpl;HU","-",{"$f":"IF(System_configuration!B104=1,1,\"-\")","v":"-"},"Formula (93a)","fpl;HU =1"]
["Part load factor of humidification pump (on off)","fpl;HU","-",{"$f":"IF(System_configuration!B104=2,(D43*Method_input!E139*(D123-D120))/Method_input!E93,\"-\")","v":0},"Formula (93b)"]
["Part load factor of humidification pump (speed)","fpl;HU","-",{"$f":"IF(System_configuration!B104=3,((D43*Method_input!E139*(D123-D120))/Method_input!E93)^2.5,\"-\")","v":"-"},"Formula (93c)"]

{"sheet":"Method_output","index":9,"n_rows":35,"n_cols":9,"rows_kept":35,"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"]
["Ventilation generation input","EV;gen;in;el","E_V_gen_in_el ","kWh",{"$f":"Method_calculation!D135","v":4.6771404662294784E-2},"0...∞","M1-9, M5-4","Yes","Electric energy required by fan"]
["Humidification generation input","EHU;cr","E_HU_cr ","kWh",{"$f":"IF(System_configuration!B93=5,Method_calculation!D159,Method_calculation!D160)","v":0},"0...∞","M1-9, M5-4","Yes","Electric energy required humidifier (only for specific humidifier types)"]
["Humidification generation energy carrier indentifier","GEN_CRHU;gen","GEN_CR_HU_gen","List",{"$f":"Method_input!E35","v":"-"},"0...∞","M1–9, M5–4","No"]
["Ventilation auxiliary energy","WV;aux","W_V_aux","kWh",{"$f":"Method_calculation!D171","v":0.10057974970816422},"0...∞","M1-9, M5-4","Yes","for heat recovery drives etc."]
["Humidification auxiliary energy","WHU;aux","W_HU_aux","kWh",{"$f":"IF(System_configuration!B93=5,Method_calculation!D183,Method_calculation!D184)","v":0},"0...∞","M1-9, M5-4","Yes","for pumps etc."]
["Recoverable duct heat losses","QV;ls;dis;rbl;zt;i","Q_V_ls_dis_rbl_zt_i","kWh",{"$f":"Method_calculation!D31","v":-0.17363626403874169},"-∞...∞","M2-2","Yes","Recoverable heat transfer through duct surface for heating and cooling (negative values)"]
["Recoverable AHU heat losses","QV;ls;gen;rbl","Q_V_ls_gen_rbl","kWh",{"$f":"IF(System_configuration!B41=1,Method_calculation!D168,Method_calculation!D169)","v":0},"-∞...∞","M2-2","Yes","Recoverable heat transfer through AHU surface for heating and cooling (negative values)"]
["Required AHU heating coil input","QH;ahu;in;req","Q_H_ahu_in_req","kWh",{"$f":"Method_calculation!D163","v":1.4928496107148346},"0...∞","M3-1","Yes","Required heat to be supplied to the AHU for air heating"]
["Required AHU cooling coil output","QC;ahu;out;req","Q_C_ahu_out_req","kWh",{"$f":"Method_calculation!D156","v":2.5836481671483154},"0...∞","M4-1","Yes","Required heat to be extracted from AHU for air cooling and dehumidification"]
["Heat transferred by heat recovery","Qhr","Q_hr","kWh",{"$f":"Method_calculation!D151","v":0},"-∞...∞","M5-4","Yes"]
["Heat required for the supply air without heat recovery","QH;ahu;in;tot;req","Q_H_ahu_in_tot_req","kWh",{"$f":"Method_calculation!D152","v":0},"-∞...∞","M5-4","Yes"]
["Electric energy input for the pressure drop of the heat recovery","EV;gen;in;el;hr","E_V_gen_in_el_hr","kWh",{"$f":"Method_calculation!D176","v":1.9488085275956159E-2},"-∞...∞","M5-4","Yes"]
["Operating conditions data"]
["Required heating coil water inlet temperature","JH;ahu;in;req","Teta_H_ahu_in_req","°C",{"$f":"Method_calculation!D129","v":21.320444158305854},"20…90","M3-1","Yes"]
["Required cooling coil water inlet temperature","JC;ahu;in;req","Teta_C_ahu_in_req","°C",{"$f":"Method_calculation!D118","v":14.433173244791936},"20…90","M4-1","Yes"]
["Required cooling air supply temperature","JSUP;C;req","theta_SUP_C_req","°C",{"$f":"IF(Method_calculation!D109<>\"-\",Method_calculation!D109,Method_calculation!D110)","v":15.906538595833549},"0…30","M4-1","Yes"]
["Supply volume flow rate going to ventilation zone","qV;SUP;dis;zv;i","q_V_SUP_dis_zv","m3/h",{"$f":"Method_calculation!D7","v":980.39215686274508},"0...∞","M5-5","Yes"]
["Extract volume flow from a ventilation zone","qV;ETA;dis;zv;i","q_V_ETA_dis_zv","m3/h",{"$f":"-Method_calculation!D8","v":-980.39215686274508},"0...∞","M5-5","Yes"]
["Duct leakage volume flow going to a ventilation zone","qV;lea;SUP;dis;zv;i","q_V_lea_SUP_dis_zv_i","m3/s",{"$f":"Method_calculation!D9","v":19.607843137254918},"0...∞","M5-5","Yes"]
["Duct leakage volume flow extracted from a ventilation zone","qV;lea;ETA;dis;zv;i","q_V_lea_ETA_dis_zv_i","m3/s",{"$f":"Method_calculation!D10","v":19.607843137254918},"0...∞","M5-5","Yes"]
["Supply outside air fraction","fODA","f_ODA","-",{"$f":"Method_calculation!D79","v":0.90900000000000003},"0…1","M5-5","Yes"]
["Supply air temperature","JSUP;dis;out","theta_SUP_dis_out","°C",{"$f":"Method_calculation!D19","v":20.399089227933057},"-273...∞","M5-5","Yes"]
["Supply air moisture content","xSUP;dis;out","x_SUP_dis_out","kg/kg dry air",{"$f":"Method_calculation!D22","v":1.0999999999999989E-2},"0...∞","M6-2, M7-2","Yes"]
["Quality assurance data"]
["Heat transferred by ground preheating / cooling","Qgnd","Q_gnd","kWh",{"$f":"Method_calculation!D149","v":0},"-∞...∞",null,"Yes"]
["Heat transferred by recirculation","QRCA","Q_RCA","kWh",{"$f":"Method_calculation!D154","v":0.13246482944914964},"-∞...∞",null,"Yes"]
["Duct heat losses","Qls;V;dis","Q_ls_V_dis","kWh",{"$f":"Method_calculation!D29","v":-0.14432739653451498},"-∞...∞",null,"Yes","Heat transfer through duct surface for heating and cooling (negative values)"]
["Heat losses of the AHU","Qls;V;gen","Q_ls_V_gen","kWh",{"$f":"IF(System_configuration!B41=1,Method_calculation!D165,Method_calculation!D166)","v":-0.24879695996735413},"-∞...∞",null,"Yes","Heat transfer through AHU surface for heating and cooling (negative values)"]
["Required energy to be extracted for dehumidification","QDHU;ahu;out;req","Q_DHU_au_out_req","kWh",{"$f":"Method_calculation!D157","v":1.4928496107147817},"0...∞",null,"Yes"]
["Water use for humidification","mw;HU","m_w_HU","kg",{"$f":"Method_calculation!D161","v":0},"0...∞",null,"Yes"]

{"sheet":"Output_series","index":10,"n_rows":65,"n_cols":31,"rows_kept":65,"cut":false,"hidden":false,"merged":[[6,0,6,5],[0,0,0,6],[16,14,16,23],[16,1,16,12],[16,25,16,30]]}
["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,30]
[]
["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,"Ventilation generation input","Humidification generation input","Humidification generation energy carrier indentifier","Ventilation auxiliary energy","Humidification auxiliary energy","Recoverable duct heat losses","Recoverable AHU heat losses","Required AHU heating coil input","Required AHU cooling coil output","Heat transferred by heat recovery","Heat required for the supply air without heat recovery","Electric energy input for the pressure drop of the heat recovery",null,"Required heating coil water inlet temperature","Required cooling coil water inlet temperature","Required cooling air supply temperature","Supply volume flow rate going to ventilation zone i","Extract volume flow from a ventilation zone i","Duct leakage volume flow going to a ventilation zone i","Duct leakage volume flow extracted from a ventilation zone i","Supply outside air fraction","Supply air temperature","Supply air moisture content",null,"Heat transferred by ground preheating / cooling","Heat transferred by recirculation","Duct heat losses","Heat losses of the AHU","Required energy to be extracted for dehumidification","Water use for humidification"]
["Symbol","EV;gen;in;el","EHU;cr","GEN_CRHU;gen","WV;aux","WHU;aux","QV;ls;dis;rbl;zt;i","QV;ls;gen;rbl","QH;ahu;in;req","QC;ahu;out;req","Qhr","QH;ahu;in;tot;req","EV;gen;in;el;hr",null,"JH;ahu;in;req","JC;ahu;in;req","JSUP;C;req","qV;SUP;dis;zv;i","qV;ETA;dis;zv;i","qV;lea;SUP;dis;zv;i","qV;lea;ETA;dis;zv;i","fODA","JSUP;dis;out","xSUP;dis;out",null,"Qgnd","QRCA","Qls;V;dis","Qls;V;gen","QDHU;ahu;out;req","mw;HU"]
["Unit","kWh","kWh","List","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh",null,"°C","°C","°C","m3/h","m3/h","m3/s","m3/s","-","°C","kg/kg dry air",null,"kWh","kWh","kWh","kWh","kWh","kg"]
["Destination","M1-9,\nM5-4","M1-9, M5-4","M1–9, M5–4","M1-9, M5-4","M1-9, \nM5-4","M2-2","M2-2","M3-1","M4-1","M5-4","M5-4","M5-4",null,"M3-1","M4-1","M4-1","M5-5","M5-5","M5-5","M5-5","M5-5","M5-5","M5-5"]
["Time stamp","Energy flow data",null,null,null,null,null,null,null,null,null,null,null,null,"Operating conditions data",null,null,null,null,null,null,null,null,null,null,"Quality assurance data"]
[1,4.6771404662294784E-2,0,"-",0.41146800309979259,0,-0.13482641039481996,0,0.74473072367948112,0,1.7954611860530363,11.256425468228036,1.9488085275956159E-2,null,23.497824864997153,20.79701576906837,20.797015769068366,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822758657521117,7.6400325978864987E-3,null,0,8.1711850583862322,0.19059202034128647,0.18940241927329815,0,0]
[2,4.6771404662294784E-2,0,"-",0.37891119498528703,0,-0.1348262093518558,0,0.73899439408817269,0,1.8279316295086228,11.118553686619688,1.9488085275956159E-2,null,23.493664238707716,20.813658274226103,20.813658274226103,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822758657521117,7.6717584037706297E-3,null,0,8.0684705810880128,0.19059202034128647,0.20114955912420712,0,0]
[3,4.6771404662294784E-2,0,"-",0.37079964741925886,0,-0.13482634338049856,0,0.73756031169034597,0,1.8360492403725199,11.084085741217597,1.9488085275956159E-2,null,23.492624082135357,20.817818900515537,20.817818900515537,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822758657521117,7.6506078665145444E-3,null,0,8.0427919617634558,0.19059202034128647,0.20408634408693455,0,0]
[4,4.6771404662294784E-2,0,"-",0.39516887262598122,0,-0.13482627636617719,0,0.74186255888382757,0,1.8116964077808297,11.187489577423863,1.9488085275956159E-2,null,23.495744551852436,20.805337021647237,20.805337021647233,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822758657521117,7.6611831351425866E-3,null,0,8.1198278197371234,0.19059202034128647,0.19527598919875269,0,0]
[5,4.6771404662294784E-2,0,"-",0.37891119498528703,0,-0.13482587428024881,0,0.73899439408817269,0,1.8279316295086228,11.118553686619688,1.9488085275956159E-2,null,23.493664238707716,20.813658274226103,20.813658274226103,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822758657521117,7.7246347469108459E-3,null,0,8.0684705810880128,0.19059202034128647,0.20114955912420712,0,0]
[6,4.6771404662294784E-2,0,"-",0.33848895998762668,0,-0.13482547219432042,0,0.73182398209903632,0,1.8685196838281057,10.946213959609249,1.9488085275956159E-2,null,23.488463455845924,20.834461405673277,20.834461405673277,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822758657521117,7.7880863586791051E-3,null,0,7.9400774844652355,0.19059202034128647,0.21583348393784346,0,0]
[7,5.2133265434182015E-2,0,"-",0.22469905527192763,3.450153619217198E-3,-0.13747623315436502,0,1.2678276666297639,0,4.3387537186384337,11.210548442791463,2.1722193930909173E-2,null,23.81332134362043,19.52078648690204,19.52078648690204,1000,-1000,20.000000000000018,20.000000000000018,0.5,22.82607603619681,4.0000000000000001E-3,null,0,5.4391599901068686,0.19195254741191622,0.26472095330969936,0,4.6577073859432175E-2]
[8,0.29491028411126669,0,"-",0.2273190525509515,3.0009646438621464E-3,-0.27231707580380421,0,2.6390161148191247,0,8.6571304663049311,22.325820069552968,0.12287928504636111,null,23.779024735838192,19.244879781141648,19.244879781141648,2000,-2000,40.000000000000036,40.000000000000036,0.5,22.911039360396636,4.0000000000000001E-3,null,0,10.872529981745448,0.25946360095693849,0.36388461019188478,0,4.0513022692138974E-2]
[9,0.81267718046829851,0,"-",0.15000000000000002,0,-0.40773126683959809,0,3.9629847022784888,0,12.801652805549823,32.899902674945643,0.33861549186179102,null,23.682636499490844,19.095496957208301,19.095496957208301,3000,-3000,60.000000000000057,60.000000000000057,0.50000000000000033,22.940241735369526,4.0196000458958218E-3,null,0,16.135265167117332,0.32575572005816417,0.46735686935072823,0,0]
[10,1.6682644938938245,0,"-",0.15000000000000002,7.9516005850108328E-3,-0.54329297609468696,0,5.284275076215101,0,16.370986753439002,42.749185060854359,0.69511020578909355,null,23.543320352904907,19.019293479450521,19.019293479450521,4000,-4000,80.000000000000071,80.000000000000071,0.50000000000000022,22.95501111215815,4.0000000000000001E-3,null,0,21.093923231200257,0.3917385529159817,0.56465614105657713,0,0.10734660789764623]
[11,1.6682644938938245,0,"-",0.15000000000000002,0,-0.5432884704176385,0,5.050083501361005,0,15.812237836763039,41.236299771164667,0.69511020578909355,null,23.515332811030909,19.131243646946523,19.131243646946523,4000,-4000,80.000000000000071,80.000000000000071,0.5,22.95501111215815,4.1742704210309591E-3,null,0,20.37397843304062,0.3917385529159817,0.58038361900565438,0,0]
[12,0.29491028411126669,0,"-",0.15000000000000002,0,-0.27231324105532306,0,2.4411031963238683,0,8.0847070383534358,20.498409218723193,0.12287928504636111,null,23.719866011620695,19.481514678011649,19.481514678011649,2000,-2000,40.000000000000036,40.000000000000036,0.5,22.911039360396636,4.2966405382184585E-3,null,0,9.972598984045888,0.25946360095693849,0.3932224774894254,0,0]
[13,0.81267718046829851,0,"-",0.15000000000000002,0,-0.40772470834665508,0,3.6283116788511931,0,11.516450033117911,29.66015108322723,0.33861549186179102,null,23.605159952149343,19.405403146574301,19.405403146574301,3000,-3000,60.000000000000057,60.000000000000057,0.50000000000000033,22.940241735369526,4.3578255968122056E-3,null,0,14.515389371258127,0.32575572005816417,0.50272175619299209,0,0]
[14,1.6682644938938245,0,"-",0.15000000000000002,0,-0.54328662485602208,0,4.7438113265419899,0,14.750614895078737,38.500509538157999,0.69511020578909355,null,23.462156481470306,19.343948965188922,19.343948965188922,4000,-4000,80.000000000000071,80.000000000000071,0.50000000000000033,22.95501111215815,4.2456529893903309E-3,null,0,19.006083316537278,0.3917385529159817,0.61026582710890165,0,0]
[15,1.6682644938938245,0,"-",0.15000000000000002,0,-0.54328398833942726,0,4.7438113265419899,0,14.750614895078737,38.500509538157999,0.69511020578909355,null,23.462156481470306,19.343948965188922,19.343948965188922,4000,-4000,80.000000000000071,80.000000000000071,0.50000000000000033,22.95501111215815,4.347628087046581E-3,null,0,19.006083316537278,0.3917385529159817,0.61026582710890165,0,0]
[16,0.29491028411126669,0,"-",0.15000000000000002,0,-0.27231231827451485,0,2.3320701959625247,0,7.6177842001870619,19.346497541667759,0.12287928504636111,null,23.682004428121495,19.632961012008447,19.632961012008447,2000,-2000,40.000000000000036,40.000000000000036,0.5,22.911039360396636,4.3680231065778338E-3,null,0,9.3966431455181691,0.25946360095693849,0.40651086477355114,0,0]
[17,5.2133265434182015E-2,0,"-",0.15000000000000002,0,-0.13747365665097575,0,1.0968364546027147,0,3.8329416899278628,9.5590002367078437,2.1722193930909173E-2,null,23.716564757449685,19.907812831585041,19.907812831585041,1000,-1000,20.000000000000018,20.000000000000018,0.5,22.82607603619681,4.3986156358747086E-3,null,0,4.6292220921772662,0.19195254741191622,0.30120034721686184,0,0]
[18,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412937067817,0,3.9083054457801341,3.3360391083617493,1.8771293343409015,9.0849449078965137,1.9488085275956159E-2,null,25.792402250736135,9.2585989763148646,11.618706226112439,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.25500000000000067,22.822585786956498,7.9999921191360266E-3,null,0,6.5534320409392421,0.19058980750830329,0.3066424655511053,3.2539931070464565,0]
[19,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412938401067,0,3.9093028151493057,3.3469351334723267,1.8844845780206045,9.1194128532986003,1.9488085275956159E-2,null,25.793125654290893,9.256022115113403,11.615812611893382,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.25500000000000039,22.822539635786832,7.999990015185636E-3,null,0,6.5791106602638001,0.19058921674936941,0.30614600890213323,3.2535754016587446,0]
[20,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412938667718,0,3.9096170325467736,3.3480818160998185,1.8918398217003072,9.1538807987006887,1.9488085275956159E-2,null,25.793353559808473,9.2559227440978731,11.614900989823072,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.25500000000000006,22.822530405552918,7.9999895943955648E-3,null,0,6.6047892795883589,0.19058909859758291,0.30564955225316121,3.2524593382394569,0]
[21,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412938134417,0,3.9094188281156459,3.341916434015157,1.8991950653800178,9.1883487441027754,1.9488085275956159E-2,null,25.793209799839019,9.2576817005175087,11.615476029700893,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.25500000000000078,22.822548866020721,7.999990435975728E-3,null,0,6.6304678989129062,0.19058933490115565,0.30515309560418924,3.2508194482659798,0]
[22,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412937601118,0,3.9092206462608075,3.3357510745068155,1.9065503090597209,9.2228166895048638,1.9488085275956159E-2,null,25.793066056244406,9.2594405750629232,11.616051004079338,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.2550000000000005,22.822567326488617,7.9999912775558773E-3,null,0,6.6561465182374651,0.19058957120472955,0.30465663895521716,3.2491795809393058,0]
[23,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412936001215,0,3.9090564608413501,3.3133831089333268,1.95068177113795,9.429624361917389,1.9488085275956159E-2,null,25.792946970658114,9.2662769424285276,11.616527346424499,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.25500000000000028,22.82262270789224,7.9999938022963357E-3,null,0,6.8102182341847977,0.19059028011545051,0.30167789906138481,3.2403880923338981,0]
[24,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.13482412935201266,0,3.9092612607683561,3.2996178539876615,1.9874579895364739,9.6019640889278275,1.9488085275956159E-2,null,25.793095514417121,9.2707350064953022,11.615933171388486,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,22.822650398594003,7.99999506466657E-3,null,0,6.9386113308075776,0.19059063457081035,0.29919561581652476,3.2334110761101695,0]
[25,4.6771404662294784E-2,0,"-",0.10057974970816422,0,-0.17363626403874169,0,1.7157675206285656,3.2039496633806146,0,0,1.9488085275956159E-2,null,21.882129100150564,14.37474853556837,15.659798828454697,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,20.79908922793291,1.1000000000000015E-2,null,0,0.16383065976504943,-0.13920718885065028,-0.27922421699097771,1.7157675206285175,0]
[26,4.6771404662294784E-2,0,"-",0.10057974970816422,0,-0.17363626403874169,0,1.7069370708154015,3.0420870706199956,0,0,1.9488085275956159E-2,null,21.87572427262883,14.40677267317707,15.685418138541655,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,20.799089227932971,1.1000000000000001E-2,null,0,0.16383065976504943,-0.13920718885064948,-0.27922421699097771,1.7069370708153782,0]
[27,4.6771404662294784E-2,0,"-",0.10172286253426367,0,-0.17363626403874169,0,1.8060681516250094,2.9857930457766093,0.30004887917151329,0.33008677576624124,1.9488085275956159E-2,null,22.267625193653558,14.407852306600573,15.717814454442737,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,21.119089227933692,1.1000000000000017E-2,null,0,0.18892332401776929,-0.13511102270354697,-0.27442696297294711,1.8060681516247381,0]
[28,4.6771404662294784E-2,0,"-",0.10241768301161246,0,-0.17363626403874169,0,1.8561427009565838,3.0435192022558497,0.47550450844630004,0.52310727001793189,1.9488085275956159E-2,null,22.463944844235737,14.38625405368969,15.732535852114031,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,21.279089227919087,1.0999999999999364E-2,null,0,0.20146965614412915,-0.13306293963018728,-0.26955860184916736,1.8561427009621685,0]
[29,4.6771404662294784E-2,0,"-",0.10277448965050438,0,-0.17363626403874169,0,1.8761138198336151,2.9793226425116797,0.56323232308369509,0.619617517143779,1.9488085275956159E-2,null,22.55843012805818,14.393827634577466,15.754594716824252,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,21.359089227924212,1.09999999999996E-2,null,0,0.20774282220730919,-0.13203889809334837,-0.26712442128727737,1.8761138198371625,0]
[30,4.6771404662294784E-2,0,"-",0.10088277459420059,0,-0.17363626403874169,0,1.7497578731233696,3.0289536601907572,8.0729342578028454E-2,8.881115795162646E-2,1.9488085275956159E-2,null,22.02678269648354,14.412064792450645,15.681184443122794,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,20.919089227936531,1.1000000000000166E-2,null,0,0.17324040885981939,-0.13767112654544392,-0.28051241437767194,1.7497578731218848,0]
[31,5.2133265434182015E-2,0,"-",0.10057974970816422,0,-0.17695014082962396,0,1.4456649923084135,3.9024900319476528,0,0,2.1722193930909173E-2,null,20.878825371456056,14.148462969449445,15.858770375559557,1000,-1000,20.000000000000018,20.000000000000018,0.90900000000000003,20.036842132608431,1.1000000000000001E-2,null,0,0.10899797636686451,-0.15078562101255338,-0.22316489996166841,1.4456649923084013,0]
[32,0.29491028411126669,0,"-",0.10057974970816422,0,-0.34544283196003239,0,2.2503783078651036,9.4643903422406286,0,0,0.12287928504636111,null,19.893637014291212,13.883038334161984,15.986430667329588,2000,-2000,40.000000000000036,40.000000000000036,0.90900000000000003,19.299533697241205,1.0999999999999985E-2,null,0,0.11430909407444645,-0.26199494781515054,-0.23932933831035935,2.2503783078651383,0]
[33,0.81267718046829851,0,"-",0.15000000000000002,0,-0.51359902763608933,0,2.8578196049039923,17.093902376389064,-1.3565773208491977E-2,0,0.33861549186179102,null,19.426791630041691,13.58069426843355,16.1188764350049,3000,-3000,60.000000000000057,60.000000000000057,0.5,19.039939671087399,1.0999999982021126E-2,null,0,-1.7098366221984976E-2,-0.37314189964232264,-0.19723546062975356,2.8578201056015016,0]
[34,1.6682644938938245,0,"-",0.15000000000000002,0,-0.68166934209926411,0,3.5487982094041022,22.712689067605179,-1.0572448750306453,0,0.69511020578909355,null,19.25467301881584,13.562437615747527,16.173882815806795,4000,-4000,80.000000000000071,80.000000000000071,0.5,19.030049254461495,1.0999999980901922E-2,null,0,-1.3622540025445664,-0.47787331620917944,-0.19391851326845888,3.5487989185084459,0]
[35,1.6682644938938245,0,"-",0.15000000000000002,0,-0.68166934209929375,0,3.5125172071033846,22.841274798693703,-2.0629929250473618,0,0.69511020578909355,null,19.248373750734199,13.543556380782526,16.199079888133355,4000,-4000,80.000000000000071,80.000000000000071,0.5,19.030049229433018,1.0999999979760934E-2,null,0,-2.658154639231932,-0.47787331751631962,-0.16560905296011932,3.512517958559354,0]
[36,0.29491028411126669,0,"-",0.15000000000000002,0,-0.34544283196030123,0,1.9531543818763886,11.629394475718509,-1.5919798183181491,0,0.12287928504636111,null,19.550426349130323,13.533807556003916,16.159273327973139,2000,-2000,40.000000000000036,40.000000000000036,0.50000000000000344,19.059533241121745,1.099999997920631E-2,null,0,-1.9637293279107255,-0.2682620939308778,-0.11747618682650486,1.9531547679328387,0]
[37,0.81267718046829851,0,"-",0.15000000000000002,0,-0.5135990276361887,0,2.7887616871865317,17.779084117717815,-2.755331687729901,0,0.33861549186179102,null,19.410804775240695,13.495345241443326,16.18282385420888,3000,-3000,60.000000000000057,60.000000000000057,0.5,19.039939558729522,1.0999999976898928E-2,null,0,-3.4728333973882926,-0.37314190404333447,-0.12179036869959042,2.7887623305380695,0]
[38,1.6682644938938245,0,"-",0.15000000000000002,0,-0.681669342099258,0,3.3848464853469018,21.870962591954186,-3.7951145667428214,0,0.69511020578909355,null,19.226206995365793,13.567628777815148,16.287746909606973,4000,-4000,80.000000000000071,80.000000000000071,0.5,19.030049259737602,1.0999999981142445E-2,null,0,-4.8899835135268388,-0.47787331593362892,-0.11685387131797928,3.3848471853755,0]
[39,1.6682644938938245,0,"-",0.15000000000000002,0,-0.68166934209915542,0,3.2884688146383727,20.367871834969129,-4.1303639167483919,0,0.69511020578909355,null,19.20947347792201,13.634503839909669,16.35468097938211,4000,-4000,80.000000000000071,80.000000000000071,0.5,19.030049346734945,1.0999999985108512E-2,null,0,-5.3219503924226235,-0.47787331139009537,-0.107417384548533,3.2884693673228163,0]
[40,0.29491028411126669,0,"-",0.15000000000000002,0,-0.34544283196020148,0,1.8492955194508056,10.120465857116223,-2.2048160434115136,0,0.12287928504636111,null,19.514361479055882,13.664438578033408,16.303532808270894,2000,-2000,40.000000000000036,40.000000000000036,0.50000000000000244,19.059533410398771,1.0999999986923342E-2,null,0,-2.7196713659783556,-0.26826208951053676,-0.10003517851608983,1.8492957621264559,0]
[41,5.2133265434182015E-2,0,"-",0.15000000000000002,0,-0.17695014082970886,0,0.97463722619570259,5.1601783715872518,-0.9645854736793581,0,2.1722193930909173E-2,null,19.631697675473827,13.663076125319384,16.247281159488466,1000,-1000,20.000000000000018,20.000000000000018,0.5,19.116841844498097,1.0999999986865558E-2,null,0,-1.1649747754534183,-0.16279763200062555,-8.6895975020574251E-2,0.97463734808202773,0]
[42,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.17363626403889587,0,0.97728579134200089,5.3838083970740751,-0.34398850077708731,0,1.9488085275956159E-2,null,19.666499748972416,13.59844424652222,16.122316233167297,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.25500000000000006,19.119088694267006,1.0999999975671124E-2,null,0,-1.2009323073621649,-0.16071206795409071,-9.7077751933382583E-2,0.97728600758721951,0]
[43,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.17363626403887264,0,0.96915704128431868,5.1847160931283058,-0.24837033294091954,0,1.9488085275956159E-2,null,19.660603872410256,13.641445664773695,16.145899739415945,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,19.119088774640137,1.0999999979335182E-2,null,0,-0.86711025614294568,-0.16071206692527293,-0.10353168837001889,0.96915722494305667,0]
[44,4.6771404662294784E-2,0,"-",0.15000000000000002,0,-0.17363626403886531,0,0.97233611262724018,5.1489424006607187,-7.1844484627995531E-2,0,1.9488085275956159E-2,null,19.662909689674553,13.654880336188807,16.136676470358751,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.255,19.119088800003496,1.0999999980491457E-2,null,0,-0.25082339235361822,-0.16071206660060877,-0.1154466479453477,0.97233628600912536,0]
[45,4.6771404662294784E-2,0,"-",0.10057974970816422,0,-0.17363626403874169,0,0.95846183968119758,3.8918370288757105,0,0,1.9488085275956159E-2,null,19.65284651881813,13.971161442230553,16.176929153784442,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,19.119089227933006,1.1000000000000012E-2,null,0,3.2094172438270369E-2,-0.16071206112288883,-0.15142973749175848,0.9584618396811605,0]
[46,4.6771404662294784E-2,0,"-",0.10057974970816422,0,-0.17363626403874169,0,1.194909057551109,3.3685448382436118,0,0,1.9488085275956159E-2,null,20.384344424416813,14.163671914237138,16.05093753138971,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,19.679089227933027,1.0999999999999996E-2,null,0,7.6006334880530019E-2,-0.15354377036547531,-0.1940278973248315,1.1949090575510648,0]
[47,4.6771404662294784E-2,0,"-",0.10057974970816422,0,-0.17363626403874169,0,1.3580429455662022,2.8884437405346652,0,0,1.9488085275956159E-2,null,20.902667322773567,14.322057422453375,15.9776459379627,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,20.079089227933043,1.0999999999999996E-2,null,0,0.10737216519642979,-0.14842356268160847,-0.22445515434845514,1.3580429455661525,0]
[48,4.6771404662294784E-2,0,"-",0.10057974970816422,0,-0.17363626403874169,0,1.4928496107148346,2.5836481671483154,0,0,1.9488085275956159E-2,null,21.320444158305854,14.433173244791936,15.906538595833549,980.39215686274508,-980.39215686274508,19.607843137254918,19.607843137254918,0.90900000000000003,20.399089227933057,1.0999999999999989E-2,null,0,0.13246482944914964,-0.14432739653451498,-0.24879695996735413,1.4928496107147817,0]

{"sheet":"Graphs","index":11,"n_rows":82,"n_cols":1,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
["Energy flow data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Operating conditions data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quality assurance data"]

{"sheet":"Greek_to_soft","index":12,"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":13,"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":14,"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":15,"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":16,"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":17,"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":18,"n_rows":15,"n_cols":4,"rows_kept":15,"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,"2014-04-09",null,"1st Version, WG doc"]
[null,"2014-05-01",null,"2nd version"]
[null,"2014-05-12",null,"3rd version, CTL distribution"]
[null,"2014-06-01",null,"4th version, WG doc"]
[null,"2014-06-30",null,"PE version"]
[null,"2014-10-09",null,"revised PE version, changes in standard submitted"]
[null,"2015-02-13",null,"Disclaimer added"]
[null,"2015-11-15",null,"Adapted to FV version"]