{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["INFO","Simplified_input_correlation","Product_descriptive_data","Product_tech_data","Process_design_data","Data_catalogue_example","Input_series","Method_input","Method_calculation","Method_output","Output_series","Greek_to_soft","Symbols","Subs_building","Subs_system","Subs_del_EP","Subs_other","History"],"not_rendered":{"charts":0,"images":50,"macros":1,"external_links":0,"defined_names":12,"comments":8,"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":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Intended use of this document\nThose responsible for the drafting of actual individual EPB standards shall\n-  read and understand the following documents\n   - prCEN/TS 16628 Basic Principles (in short \"BP\")\n   - prCEN/TS 16629 Detailed Technical Rules (in short \"DTR\")\n   - prEN 15603:2013 (\"Overarching Standard\", in short \"OA\"))\n   - prCEN/TR 15615:2013 Technical report to overarching standard;\n- Prepare their individual EPB standard according to CEN rules, BP, DTR and OA\n- Prepare the accompanying technical report using the dedicated template\n- Prepare an accompanying XLS spreadsheet, to demonstrate inputs, output and calculation chain.\n\nThis sample excel spreadsheet provides a template to help in this task."]
["Why an Excel spradsheet?\n\nTo demonstrate the validity and required data I/O for the calculation procedure defined in the standard:\n- list of all input needed --> sheet \"Method_input\"\n- list of intended output --> sheet  \"Method_output\"\n- calculation sequence --> sheet  \"Method_calculation\""]
["The example is prepared for a simple procedure. The sheet calculation may need extensions such as:\n- using several columns when operating on arrays\n- refering to a subset of sheets input/calculation/output to describe a subroutine\nFor complex tasks MACRO can be used.\n\nThis sheet does not support calculation methods that take into account data in a different time-step than that that is being calculated. A version that allows taking into account values at previous time step will be developed."]
["LIST SHEETS"]
["Simplified_input_correlation\nUse this sheet to demontrate simplified input correlation, if any in your standard.\nTypically these correlations are defined in annex C of the standard. They provide the normal detailed input of a procedure, based on a simplified input data set."]
["Product_descriptive_data\nUse this sheet to list product descriptive data (typically with case identifiers). Some examples of selection tables are given.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Product_tech_data\nUse this sheet to list product technical data (typically numerical values and data). Some examples are given with default that may be typically included in annex A of the standard.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Process_design_data\nUse this sheet to list system descriptive data (typically with case identifiers). Some examples of selection tables are given.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Data_catalogue_example\nIt is an example of how a data catalogue can work, filtering the catalogue of product properties based on product descriptive data. You can optionally build a similar catalogue for products involved in your standard."]
["Input_series\nPrepare in this sheet data for each time step if you want to test the procedure on more steps."]
["Method_input\nList in this sheet all the input required for the calculation in one time step.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE REQUIRED DATA INPUT."]
["Method_calculation\nDetail in this sheet your calculation procedure. There should be one calculation in one cell for each equation in the standard.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE CALCULATION PROCEDURE."]
["Method_output\nList in this sheet all the intended output of the procedure.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE AVAILABLE DATA OUTPUT."]
["Output_series\nSeries alculation results are stored in this sheet.\nCalculation for each time step is launched in this sheet."]
["Greek_to_soft\nThis sheet includes the correspondence table between greek letters and software language coding of variables"]
["Symbols\nThis sheet includes common symbols for reference."]
["Subs buildings\nThis sheet includes relevant common symbols for the building domain"]
["Subs systems\nThis sheet includes relevant common symbols for the technical systems domain"]
["Subs del_EP\nThis sheet includes relevant common symbols for the assessment boundary energy flows"]
["Subs others\nThis sheet includes relevant common symbols for other general purposes (typically futher levels appended to previously defined subscripts)"]
["Hostory \nChanges in this sheet according to revisions"]

{"sheet":"Simplified_input_correlation","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Create here a simulation of each correlation method in your Annex C, if any"]
[]
[]
["Name","Symbol","Unit","Value","Range","Formula ref.","Formula","Notes"]
["Input data"]
["Length of the building","lL","m",30,"4…100"]
["Width of the building","lW","m",20,"4…20"]
["Number of loors","Nlev","-",3,"1…10"]
["Floor heigth","Hfl","m",3.1,"2…5"]
[]
[]
["METHOD"]
[]
["Detail all formulas"]
["Length of connection of radiators to vertical shafts ","lA","m",{"$f":"0.55*Method_in*D7*D8","v":990}]
["Length of vertical shafts","lS","m",{"$f":"0.025*Method_in*D7*D8*D9","v":139.5}]
["Length of base collector","lV","m",{"$f":"2*Method_in+0.01625*Method_in*D7*D7","v":255}]
["…"]
[]
["Output data"]
["Length of shafts","lS","m",{"$f":"+D16","v":139.5},"0...∞"]
["diameter of shafts","dS","m",null,"0…0,2"]
["Length of base ring","lB","m",{"$f":"+D17","v":255},"0...∞"]
["diameter of base ring","dB","m",null,"0…0,2"]

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

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

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

{"sheet":"Input_series","index":6,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Load here the value of input variables for each time-step (time series)\nSet the number of input data for each time steps and the number of time step before running The macro from sheet \"Output series\".\n\nLocal constant data may be input via the sheets \"Constants\" "]
[]
["Time series for data input"]
["Settings"]
["Number of input data",null,5]
["Number of time steps",null,12]
[]
["Description","Generation output","Calculation interval duration","Operation time","Boiler average water temperature","Boiler return water temperature","External temperature"]
["Symbol","QH;gen;out ","tci ","tgnr ","ϑgnr;w;m ","ϑgnr;w;r ","ϑext "]
["Unit","kWh","h","h","°C","°C","°C"]
[]
[]
["Time stamp",null,null,"VALUES"]
[1,32000,744,710,65,{"$f":"+E14-10","v":55},3]
[2,25000,{"$f":"+C14","v":744},{"$f":"+D14","v":710},60,{"$f":"+E15-10","v":50},7]
[3,12000,{"$f":"+C15","v":744},{"$f":"+D15","v":710},55,45,12]
[4,5000,744,710,50,40,15]
[5,2000,744,710,50,40,18]
[6,1500,744,710,50,40,21]
[7,1200,744,710,50,40,24]
[8,1600,744,710,50,40,23]
[9,8000,744,710,55,45,20]
[10,16000,744,710,60,50,15]
[11,21000,744,710,65,55,9]
[12,28000,744,710,70,60,4]

{"sheet":"Method_input","index":7,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,8],[48,10,48,11]]}
["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"]
["Required thermal energy to extraction by refrigeration unit","QC,gen,in,req","Q_C_gen_in_req","kWh",100,"0...∞","M4-1","Yes","Thermal energy of cooling"]
["Required thermal energy for recovery","QC,gen,out,req","Q_C_gen_out_req","kWh",0,null,"M4-1","Yes"]
["Cooling generation operation time interval","tC,gen,op","t_C_gen_op","h",1,"0…8760","M4-1","Yes","time when the cooling generation system is working"]
["Ambient air temperature","ϑe ","theta_e","°C",33,"-50…+50","M1-13","Yes"]
["Ambient air wet-bulb temperature","ϑe;wb","theta_e_wb ","°C",21,"-50…+50","M1-13","Yes"]
["Required cooling generation output temperature","ϑC;gen;req;out","theta_C_gen_req_out","°C",6,"-50…+50","M4-1","Yes"]
["Internal air temperature","ϑi ","theta_i","°C",20,"0…30","M2-2","Yes"]
["Electrical power for control, actors, sensors, etc.","Pctrl;el;j","P_ctrl_el_j","kW",0.1,"0...∞","local","Yes","of jth component, at the moment it is just the sum"]
["Part-load factor at particular part-load stage","fC,PL,k","f_C_PL_k",1,0.9,"List","local","Yes","tabulated in annex B, Tables B.11, B.12, and B.13; or to be inserted here from product data"]
["Energy efficiency correction factor","fEER;corr","f_EER_corr",1,1,"0...∞","local","Yes"]
["Free-cooling factor","fhr,fc","f_hr_fc",1,1,"List","local","Yes","to be taken from Table B.16"]
["Electrical free-cooling factor","fhr,fc,el","f_hr_fc_el",1,1,"List","local","Yes","to be taken from Table B.16"]
["Multiple-generator factor","fC,mult","f_C_mult",1,1,"List","local","Yes","to be taken from Table B.17"]
["Electrical heat rejection part-load factor","fhr,PL,el","f_hr_PL_el",1,0.8,"List","local","Yes","to be taken from Table B.14"]
["Absorption type system part-load value","PLVabs","PLV_abs",1,null,"List","local","Yes","to be taken from Section B.2.3.2"]
[]
["Product data"]
["Product description data "]
["Refrigeration system type","REFR_TYPE","REFR_TYPE",null,"WTR_CLG_CHLL","List","Local","No","air-cooled RAC, air-cooled chiller and water-cooled chiller system"]
["Cooling generation system type","GEN_TYPE","GEN_TYPE",null,"COMP","List","Local","No","compression, absorption type"]
["Compressor type","COMP_TYPE","COMP_TYPE",null,"PSTN","List","Local","No","piston, scroll, screw, centrifugal compressor"]
["Compressor control type","COMP_CTRL_TYPE","COMP_CTRL_TYPE",null,"FIXED","List","Local","No","fixed capacity, staged capacity, variable capacity by inverter, variable capacity by other means"]
["Room air conditioning system zining","AIR_CLG_RAC_ZONE_TYPE","AIR_CLG_RAC_ZONE_TYPE",null,null,"List","Local","No","single, multiple zones"]
["Air-cooled heat rejection","AIR_CLG_HEAT_REJ","AIR_CLG_HEAT_REJ",null,"EXTERNAL","List","Local","No","internal, external heat rejection"]
["Heat rejection system type ","HEAT_REJ_TYPE:","HEAT_REJ_TYPE",null,"WET","List","Local","No","dry, wet, and hybrid"]
[]
[]
["Product technical data "]
["Nominal thermal power of the refrigeration unit","ΦC;gen;n ","Phi_C_gen_n","kW",200,"0...∞","M4-3","No"]
["Nominal thermal power of heat rejection system","Φhr;n ","Phi_hr_n","kW",250,"0...∞","M4-3","No","for all heat rejection systems"]
["Nominal thermal power of heat rejection system in dry operation mode","Φhr;n;dry ","Phi_hr_n_dry","kW",15,"0...∞","M4-3","No","for hybrid systems only in dry operation mode"]
["Nominal energy efficiency ratio","EERn","EER_n",1,4.5,"0...∞","EN 14511","No","for compression type refrigeration systems"]
["Nominal heat ratio","ζn","zeta_n",1,null,"0...∞","???","No","for absorption type refrigeration systems"]
["Ambient temperature for air cooled system nominal energy efficiency ratio","ϑe;n ","theta_e_n","°C",35,"-50…+50","EN 14511","No"]
["Internal temperature for air cooled system nominal energy efficiency ratio","ϑi;n ","theta_i_n","°C",20,"0…30","EN 14511","No"]
["Required cooling generation output temperature at nominal conditions","ϑC;gen;req;out;n","theta_C_gen_req_out_n","°C",7,"-50…+50","M4-1","No"]
["Reference ambient temperature for air cooled system ","ϑe;ref ","theta_e_ref","°C",33,"-50…+50","local","No"]
["Reference heat rejection input cooling water","ϑC;wat;hr;in;ref","theta_W_hr_in_ref","°C",33,"20…50","local","No","input into heat rejection"]
["Reference heat rejection output cooling water","ϑC;wat;hr;out;ref","theta_W_hr_out_ref","°C",28,"20…50","local","No","output"]
["Nominal heat rejection input cooling water","ϑC;wat;hr;in;n","theta_W_hr_in_n","°C",35,"20…50","EN 14511","No","output"]
["Reference heat rejection input cooling water","ϑC;wat;hr;in;limit","theta_W_hr_in_limit","°C",20,"20…50","local","No","input into heat rejection"]
["Evaporator temperature difference","Δϑevap","Delta_theta_evap","K",6,"0...∞","local","No"]
["Condenser temperature difference","Δϑcond","Delta_theta_cond","K",4,"0...∞","local","No"]
["Specific electrical energy for heat rejection","phr;el","p_hr_el","kW/kW",1.7999999999999999E-2,"0...∞","local","No","to be taken from Table B.8","air","water"]
["Specific electrical energy for distribution","pdist;el","p_dist_el","kW/kW",2.5000000000000001E-2,"0...∞","TC228","No",null,"dry","dry","wet"]
["Coefficient","a0","a_0",1,2.0164,"List","local","Yes","to be taken from Table B.15",1,2.64,2.0164]
["Coefficient","a1","a_1","1/°C",-3.0700000000000002E-2,"List","local","Yes","to be taken from Table B.15",0,-7.7530000000000002E-2,-3.0700000000000002E-2]
["Coefficient","a2","a_2","1/°C^2",0,"List","local","Yes","to be taken from Table B.15",0,8.3000000000000001E-4,0]
["Coefficient for heat rejection","b0","b_0",1,0.44400000000000001,"List","local","Yes","to be taken from Table B.9",0.41699999999999998,0.41699999999999998,0.44400000000000001]
["Coefficient for heat rejection","b1","b_1","1/°C",4.7999999999999996E-3,"List","local","Yes","to be taken from Table B.9",0,0,4.7999999999999996E-3]
[]
["System design data"]
["Process design"]
["Cooling generation temperature control","CLG_GEN_TMP_CTRL","CLG_GEN_TMP_CTRL",null,"TRUE","List","Local","No","true, false"]
["Multiple cooling generator arrangement","CLGL_GEN_ARR","CLG_GEN_ARR",null,"SINGLE","List","Local","Yes","single, sequential, parallel"]
["Heat rejection control","HEAT_REJ_CTRL","HEAT_REJ_CTRL",null,"VAR_TEMP","List","Local","No","no control, const. cooling water temperature, variable cooling water temperature"]
[]
["Control type data"]
["Hybrid heat rejection control","HBRD_HEAT_REJ_CTRL","HBRD_HEAT_REJ_CTRL",null,null,"List","Local","No","dry, wet operation"]
["Constants"]
["Absolute temperature","T0,abs","T_0_abs",null,273.14999999999998,null,"local","no"]

{"sheet":"Method_calculation","index":8,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["THIS IS A MANDATORY SHEET\nOne time step calculation shall be described here.\nFor each calculation step (= 1 row) data for the formula in column D shall be taken from the \"Method_input\" sheet or previous calculation steps.\nInclude in the column \"Formula ref\" its number in the standard text. The example is based on EN 15316-4-1:2008\nCopy and paste a copy of the equation into column \"Formula\"\nUse the column note for information on the calculation"]
[]
["Description","Symbol","Unit","Value","Formula ref","Formula","Notes"]
["Operating conditions calculation"]
["part-load value","PLV",null,{"$f":"D9*D19*Method_input!E16*Method_input!E18","v":1.1086232122287696},29]
["Cooling generation part-load operation"]
["part-load factor of required cooling energy demand","fC;PL",null,{"$f":"Method_in/Method_input!E8/Method_input!E34","v":0.5},30]
["part-load stage","k",null,{"$f":"MIN(ROUND(D7,1),1)","v":0.5},31]
["part-load factor","fC;PL;k",null,{"$f":"IF(D7<0.05,1,Method_input!E14)","v":0.9},32,null,"from table or known from product data"]
["thermal energy extraced by the refrigeration unit","QC;gen;in","kWh",{"$f":"IF(D7<=1,Method_in,Method_input!E34*Method_input!E8)","v":100},33.340000000000003,null,"Method output"]
["part-load factor of covered cooling energy demand","fC;PL;cvd",null,{"$f":"MIN(1,D10/Method_in)","v":1},35,null,"Method output"]
["Cooling generator energy efficiency ratio temperature correction"]
["Cooling generator energy efficiency ration temperature correction factor","fEER;corr",null,{"$f":"((Method_input!E66+Method_input!E11-Method_input!E47)/((Method_input!E66+D16+Method_input!E48)-(Method_input!E66+Method_input!E11-Method_input!E47)))/((Method_input!E66+Method_input!E41-Method_input!E47)/((Method_input!E66+D17+Method_input!E48)-(Method_input!E66+Method_input!E41-Method_input!E47)))","v":1.023280804057751},36]
["logical relation for air-cooling",null,null,{"$f":"IF(OR(Method_input!E24=\"AIR_CLG_CHLL\", Method_input!E24=\"AIR_CLG_RAC\"),TRUE,FALSE)","v":false},null,null,"they are mutually exclusive","This line is not required in an efficient software implementation."]
["logical relation for water-cooling",null,null,{"$f":"IF(Method_input!E24=\"WTR_CLG_CHLL\",TRUE,FALSE)","v":true},null,null,"they are mutually exclusive","This line is not required in an efficient software implementation."]
["Required heat rejection input temperature","ϑC;gen;hr;req;in;ref","°C",{"$f":"IF(D14,IF(Method_input!E29=\"EXTERNAL\",Method_input!E42,Method_input!E42),Method_input!E43)","v":33},"37-39"]
["Required heat rejection input temperature at nominal conditions","ϑC;gen;hr;req;in;n","°C",{"$f":"IF(D14,IF(Method_input!E29=\"EXTERNAL\",Method_input!E39,Method_input!E40),Method_input!E45)","v":35},"37-39"]
["Heat rejection part-load operation"]
["part-load factor of the heat rejection system","fhr,PL",null,{"$f":"D20*D20*Method_input!E53+D20*Method_input!E52+Method_input!E51","v":1.2318035693528218},40]
["temperature to be inserted in Eq. (34)","ϑ","°C",{"$f":"IF(D14,Method_input!E9,D30)","v":25.556886988654803},"41,47"]
["Air-cooled systems"]
["recoverable thermal energy","QC;gen;out;rbl","kWh",{"$f":"IF(D14,0,\"not avail.\")","v":"not avail."},43,null,"Method output"]
["temperature level of recoverable heat","ϑC;gen;out;rbl","°C",{"$f":"IF(D14,\"not defined\",\"not defined\")","v":"not defined"},44,null,"Method output"]
["thermal energy to be transferred through heat rejection system","Qhr;out","kWh",{"$f":"IF(D14,IF(Method_input!E25=\"COMP\",Method_calculation!D10*(1+1/(Method_input!E37*Method_calculation!D9*D13)),Method_calculation!D10*(1+1/(Method_input!E38*Method_calculation!D9))),\"not avail.\")","v":"not avail."},"45,46"]
[]
["Water-cooled systems"]
["cooling water inlet temperature (HEAT_REJ_CTRL=\"NO_CTRL\"","ϑW;hr;in","°C",{"$f":"IF(D15,D31+D39/Method_input!E8/Method_input!E35*(Method_input!E43-Method_input!E44),\"not avail.\")","v":25.55688698723915},48,null,null,"This line is not required in an efficient software implementation."]
["cooling water inlet temperature (HEAT_REJ_CTRL=\"CNST_TEMP\"","ϑW;hr;in","°C",{"$f":"IF(D15,Method_input!E43,\"not avail.\")","v":33},48,null,null,"This line is not required in an efficient software implementation."]
["cooling water inlet temperature (HEAT_REJ_CTRL=\"VAR_TEMP\")","ϑW;hr;in","°C",{"$f":"IF(D15,MAX(Method_input!E46,D31+D39/Method_input!E8/Method_input!E35*(Method_input!E43-Method_input!E44)),\"not avail.\")","v":25.55688698723915},48,null,null,"This line is not required in an efficient software implementation."]
["cooling water inlet temperature","ϑW;hr;in","°C",{"$f":"IF(Method_input!E61=\"NO_CTRL\",Method_calculation!D27,IF(Method_input!E61=\"CNST_TEMP\",Method_calculation!D28,Method_calculation!D29))","v":25.55688698723915},48,null,"considering if-statement"]
["cooling water outlet temperature","ϑW;hr;out","°C",{"$f":"IF(D15,IF(D32,D30-D40*(D30-Method_input!E9),D30-D40*(D30-Method_input!E10)),\"not avail.\")","v":23.07429495659126},"49, 50",null,"Method output"]
["logical relation for dry heat rejection",null,null,{"$f":"IF(D15,OR(Method_input!E30=\"DRY\",AND(Method_input!E30=\"HBRD\",Method_calculation!D34=\"HBRD_DRY\")),\"\")","v":false},null,"HEAT_REJ_TYPE=WET or (HEAT_REJ_TYPE=HBRD and HBRD_HEAT_REJ_CTRL=HBRD_WET)","for Eq. (42) in order to keep XLS clear","This line is not required in an efficient software implementation."]
["logical relation for wet heat rejection",null,null,{"$f":"IF(D15,OR(Method_input!E30=\"WET\",AND(Method_input!E30=\"HBRD\",Method_calculation!D34=\"HBRD_WET\")),\"\")","v":true},null,"HEAT_REJ_TYPE=DRY or (HEAT_REJ_TYPE=HBRD and HBRD_HEAT_REJ_CTRL=HBRD_DRY)","for Eq. (43) in order to keep XLS clear","This line is not required in an efficient software implementation."]
["hybrid heat rejection control mode",null,null,{"$f":"IF(D15,IF(Method_input!E30=\"HBRD\",IF(D39>Method_input!E36*Method_input!E8,\"HBRD_WET\",\"HBRD_DRY\"),\"no hybrid\"),\"\")","v":"no hybrid"},51]
["cooling water outlet temperature difference",null,null,{"$f":"IF(D15,D30-D36,\"\")","v":-1.1301276084907386E-4},null,"Has to be made zero by tuning D36: use <ctrl>+i to iterate","XLS trick in order to solve Eqs. D15 and D23 iteratively","This line is not required in an efficient software implementation."]
["cooling water inlet temperature","ϑW;hr;in","°C",25.556999999999999,null,null,null,"Has to be adjusted manually."]
["recoverable thermal energy","QC;gen;out;rbl","kWh",{"$f":"IF(D15,IF(Method_input!E25=\"COMP\",Method_calculation!D10*(1+1/(Method_input!E37*Method_calculation!D9*D13)),Method_calculation!D10*(1+1/(Method_input!E38*Method_calculation!D9))),\"\")","v":124.12960150017418},"52,53",null,"Method output"]
["temperature level of recoverable heat","ϑC;gen;out;rbl","°C",{"$f":"D30","v":25.55688698723915},54,null,"Method output"]
["thermal energy to be transferred through heat rejection system","Qhr;out","kWh",{"$f":"IF(D15,MAX(D37-Method_input!E7,0),\"\")","v":124.12960150017418},55]
["temperature ratio of evaporation","ηe",null,{"$f":"IF(D15,Method_input!E55*Method_input!E10+Method_input!E54,\"\")","v":0.54479999999999995},"Table B.9"]
["Energy calculation: per time interval"]
["electrical cooling energy input (for compression type systems)","EC;gen;el;in","kWh",{"$f":"IF(Method_input!E25=\"COMP\",D10/D5/Method_input!E37/D13,0)","v":19.588838760193163},56,null,"Method output"]
["thermal cooling energy input (for absorption type systems)","QH;C;gen;in","kWh",{"$f":"IF(Method_input!E25=\"ABS\",D10/Method_input!E20/Method_input!E38,\"not avail.\")","v":"not avail."},57,null,"Method output"]
["energy demand for heat rejection","Whr,el,in","kWh",{"$f":"IF(D14,0,D39*Method_input!E17*Method_input!E49*Method_input!E19)","v":1.7874662616025081},"58,59"]
["energy demand for control, actors, sensors, etc.","Wctrl,el,in","kWh",{"$f":"Method_input!E8*Method_input!E13","v":0.1},60]
["energy demand for heat rejection water distribution","Wdist,hr,el,in","kWh",{"$f":"IF(D14,0,Method_calculation!D39*Method_input!E50)","v":3.1032400375043547},"61,62"]
["auxiliary energy demand","Waux,el,in","kWh",{"$f":"D44+D45+D46","v":4.9907062991068631},63,null,"additional information"]
["energy efficiency ratio","EER",1,{"$f":"IF(Method_input!E25=\"COMP\",D10/(Method_calculation!D42+Method_calculation!D47),\"not avail.\")","v":4.0684235513205138},64,null,"additional information"]
["heat ratio","ς",1,{"$f":"IF(Method_input!E25=\"ABS\",Method_calculation!D10/D43,\"not avail.\")","v":"not avail."},65,null,"additional information"]

{"sheet":"Method_output","index":9,"n_rows":15,"n_cols":10,"rows_kept":15,"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"]
["Thermal energy to be extracted by refrigeration system","QC,gen,in","Q_C_gen_in","kWh",{"$f":"Method_calculation!D10","v":100},"0...∞","M4-6","Yes","Thermal energy of cooling"]
["Cooling generation electrical energy input","EC,gen,el;in ","E_C_gen_el_in","kWh",{"$f":"Method_calculation!D42","v":19.588838760193163},"0...∞","M1-9, M4-4","Yes","Electrical energy required by the refrigeration unit"]
["Recoverable thermal energy","QC,gen,out,rbl","Q_C_gen_out_rbl","kWh",{"$f":"IF(Method_calculation!D14,Method_calculation!D22,Method_calculation!D37)","v":124.12960150017418},null,"M4-1","Yes"]
["Temperature level of heat t.b. rejected","ϑC,gen,out,max","theta_C_gen_out_max","°C",{"$f":"Method_calculation!D38","v":25.55688698723915},null,"M3-1","Yes","temperature level of recoverable heat","Hit <ctrl>+i to iterate for correct value"]
["Cooling generation heat input","QH;C,gen;abs;in;req ","Q_H_C_gen_abs_in_req","kWh",{"$f":"Method_calculation!D43","v":"not avail."},null,"M3-1","Yes","Thermal energy required by the absorption type refrigeration unit"]
["Auxiliary electrical energy input","WC;aux,gen;in","W_C_aux_gen_in","kWh",{"$f":"Method_calculation!D47","v":4.9907062991068631},"0...∞","M1-9, M4-4","Yes"]
["Operating condition data"]
["Part-load factor of covered cooling energy demand","fC,PL,cvd","f_C_PL_cvd","-",{"$f":"Method_calculation!D11","v":1},"0…1","M4-1","Yes","for quality control"]
["Hybrid heat rejection control","HBRD_HEAT_REJ_CTRL","HBRD_HEAT_REJ_CTRL",null,{"$f":"Method_calculation!D34","v":"no hybrid"},"List","M4-1","Yes","dry and wet operation modes"]
["Other data"]

{"sheet":"Output_series","index":10,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,0,6,4],[0,0,0,5]]}
["Here a time series can be generated to test the method with variable input data.\nData input series must be inserted in the \"input_series\" sheet before."]
[]
["Time series for data output"]
["Settings"]
["Number of output data",null,3]
[]
["This table will be filled automatically via a macro scanning the \"input_series\" and performing for each time step the calculation defined in the \"Method_calculation\" sheet."]
["Press CLEAR OUTPUT to reset output series"]
["Press \"Run method\" to start calculation of individual time steps"]
[]
[]
[]
[null,"Generation input","Recoverable heat","Total auxiliary energy "]
[null,"kWh","kWh","kWh"]
["Symbol","EH,gen,in","QH,gen,rbl","WH,gnr,aux"]
["Destination"]
["Time stamp",null,null,"VALUES"]
[1,null,null,null,0]
[2,null,null,null,0]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
[11,null,null,null,0]
[12,null,null,null,0]

{"sheet":"Greek_to_soft","index":11,"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":12,"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,"p","specific power","kW/kW"]
[null,null,null,"s","number of time steps of a particular part-load stage"]
[null,null,null,"k","part-load stage"]
[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":13,"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":14,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,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","e","evaporative","cvd","covered","HU","Humidification"]
[null,"DHU","Dehumidification","nod","node","rej","rejected","…","… your new subscript","DHU","Dehumidification"]
[null,"L","lighting","gen","generation","…","… your new subscript",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,"HR","heat rejection","…","… your new subscript",null,null,null,null,"…","… your new subscript"]
[null,"FC","free cooling"]
[null,"…","… your new subscript"]
[]
[]
[null,"Please insert any new subscript in the yellow field"]

{"sheet":"Subs_del_EP","index":15,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[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],[33,7,33,8],[34,5,34,6],[34,7,34,8],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,25,6],[25,7,25,8],[26,5,26,6],[26,7,26,8],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,33,6],[43,5,43,6],[43,7,43,8],[44,1,45,2],[44,3,45,4],[44,5,44,6],[44,7,45,8],[45,5,45,6],[43,1,43,2],[43,3,43,4],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[58,5,58,6],[58,7,58,8],[59,5,59,6],[59,7,59,8],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[46,7,48,8],[51,7,51,8],[52,7,52,8],[51,5,51,6],[52,5,52,6]]}
[]
[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,"n","nominal"]
[null,null,null,null,null,"WB","wet-bulb"]
[null,null,null,null,null,"PL","part-load"]
[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":16,"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,"zxx","… other zones","bin","bin",null,null,"…","… your new subscript"]
[null,"amb","ambient","an","annual"]
[null,"…","… your new subscript","…","… 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":17,"n_rows":7,"n_cols":4,"rows_kept":7,"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"]