{"text_format":"1","workbook":"xlsx","n_sheets":13,"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","Graphs","History"],"not_rendered":{"charts":14,"images":45,"macros":1,"external_links":1,"defined_names":38,"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":18,"n_cols":1,"rows_kept":18,"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 OF AVAILABLE SHEETS"]
["Simplified_input_correlation\nUse this sheet to demontrate simplified input correlation, if any in your standard.\nTypically these correlations are defined in annex C of the standard. They provide the normal detailed input of a procedure, based on a simplified input data set."]
["Product_descriptive_data\nUse this sheet to list product descriptive data (typically with case identifiers). Some examples of selection tables are given.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Product_tech_data\nUse this sheet to list product technical data (typically numerical values and data). Some examples are given with default that may be typically included in annex A of the standard.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Process_design_data\nUse this sheet to list system descriptive data (typically with case identifiers). Some examples of selection tables are given.\nThe output from the selection tables (green cells) can be linked to the sheet \"method_input\" for use in the procedure."]
["Data_catalogue_example\nIt is an example of how a data catalogue can work, filtering the catalogue of product properties based on product descriptive data. You can optionally build a similar catalogue for products involved in your standard."]
["Input_series\nPrepare in this sheet data for each time step if you want to test the procedure on more steps."]
["Method_input\nList in this sheet all the input required for the calculation in one time step.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE REQUIRED DATA INPUT."]
["Method_calculation\nDetail in this sheet your calculation procedure. There should be one calculation in one cell for each equation in the standard.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE CALCULATION PROCEDURE."]
["Method_output\nList in this sheet all the intended output of the procedure.\nTHIS SHEET IS REQUIRED TO DEMONSTRATE THE AVAILABLE DATA OUTPUT."]
["Output_series\nSeries alculation results are stored in this sheet.\nCalculation for each time step is launched in this sheet."]

{"sheet":"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"]
[]
[]
["Name","Symbol","Unit","Value","Range","Formula ref.","Formula","Notes"]
["Input data"]
["Length of the building","lL","m",30,"4…100"]
["Width of the building","lW","m",20,"4…20"]
["Number of loors","Nlev","-",3,"1…10"]
["Floor heigth","Hfl","m",3.1,"2…5"]
[]
[]
["METHOD"]
[]
["Detail all formulas"]
["Length of connection of radiators to vertical shafts ","lA","m",{"$f":"0.55*Method_in*D7*D8","v":990}]
["Length of vertical shafts","lS","m",{"$f":"0.025*Method_in*D7*D8*D9","v":139.5}]
["Length of base collector","lV","m",{"$f":"2*Method_in+0.01625*Method_in*D7*D7","v":255}]
["…"]
[]
["Output data"]
["Length of shafts","lS","m",null,"0...∞"]
["diameter of shafts","dS","m",null,"0…0,2"]
["Length of base ring","lB","m",null,"0...∞"]
["diameter of base ring","dB","m",null,"0…0,2"]

{"sheet":"Product_descriptive_data","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"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)"]
[]
["Cooling generator type 1"]
[1,"GEN_TYPE",{"$f":"INDEX(C11:C13,A9)","v":"COMP"}]
[]
["Compression chiller",null,"COMP"]
["Absorption chiller",null,"ABS"]
["Any other generator type",null,"OTHER"]
[]
[]
["Cooling generator type 2"]
[1,"GEN_TYPE",{"$f":"INDEX(C19:C21,A17)","v":"COMP"}]
[]
["Compression chiller",null,"COMP"]
["Absorption chiller",null,"ABS"]
["Any other generator type",null,"OTHER"]
[]
[]
["Heat rejection type"]
[4,"HEAT_REJ_TYPE",{"$f":"INDEX(C27:C31,A25)","v":"HYBRID"}]
[]
["Air cooled condenser",null,"AIR_C_COND"]
["Heat rejection with dry operation",null,"DRY"]
["Heat rejection with wet operation (sprayed air cooler, cooling tower)",null,"WET"]
["Heat rejection with dry or wet operation depending on conditions",null,"HYBRID"]
["Other type of heat rejection (ground, ground water, surface water)",null,"OTHER"]

{"sheet":"Product_tech_data","index":3,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,3],[31,6,35,11],[31,5,35,5]]}
["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)"]
[]
["Data input type"]
[1,null,{"$f":"INDEX(C6:C7,A4)","v":14825}]
[]
["EN 14825",null,14825]
["EN 14511 or default value",null,14511]
[]
["6.3.2.2.2 Compressor chiller characteristics",null,null,"Chiller 1","Chiller 2"]
["Energy efficiency at part load condition A","EERA","-",{"$f":"Method_input!D33","v":2.83},{"$f":"Method_input!E33","v":4},"EN 14825","No",null,null,"Matrix A:"]
["Part load ratio A","fC;PL;A","%",{"$f":"Method_input!D34","v":100},{"$f":"Method_input!E34","v":100},"EN 14825","No",null,null,{"$f":"(D11/100)^3","v":1},{"$f":"(D11/100)^2","v":1},{"$f":"(D11/100)","v":1},1,{"$f":"-(D10/Method_input!$D$30*D11/100)/(Method_input!$D$78+D12)","v":-3.5695163305372126E-3},null,{"$f":"D10/Method_input!$D$30*((D13-D12)/(Method_input!$D$78+D12))","v":8.2098875602355889E-2},{"$f":"E10/Method_input!$D$30*((E13-E12)/(Method_input!$D$78+E12))","v":0.11604081357223447}]
["Evaporator chilled water outlet temperature at part load condition A","ϑC; evap;out;A","°C",{"$f":"Method_input!D35","v":7},{"$f":"Method_input!E35","v":7},"EN 14825","No",null,null,{"$f":"(D15/100)^3","v":0.40522399999999997},{"$f":"(D15/100)^2","v":0.54759999999999998},{"$f":"(D15/100)","v":0.74},1,{"$f":"-(D14/Method_input!$D$30*D15/100)/(Method_input!$D$78+D16)","v":-3.3508046232173707E-3},null,{"$f":"D14/Method_input!$D$30*((D17-D16)/(Method_input!$D$78+D16))","v":8.6034172758283831E-2},{"$f":"E14/Method_input!$D$30*((E17-E16)/(Method_input!$D$78+E16))","v":9.5859802516193693E-2}]
["Condensor cooling water/air inlet temperature part load condition A","ϑcond;in;A","°C",{"$f":"Method_input!D36","v":30},{"$f":"Method_input!E36","v":30},"EN 14825","No",null,null,{"$f":"(D19/100)^3","v":0.10382299999999998},{"$f":"(D19/100)^2","v":0.22089999999999999},{"$f":"(D19/100)","v":0.47},1,{"$f":"-(D18/Method_input!$D$30*D19/100)/(Method_input!$D$78+D20)","v":-2.8218098709109013E-3},null,{"$f":"D18/Method_input!$D$30*((D21-D20)/(Method_input!$D$78+D20))","v":9.0057761837581962E-2},{"$f":"E18/Method_input!$D$30*((E21-E20)/(Method_input!$D$78+E20))","v":7.5678791460152911E-2}]
["Energy efficiency at part load condition B","EERB","-",{"$f":"Method_input!D37","v":3.59},{"$f":"Method_input!E37","v":4},"EN 14825","No",null,null,{"$f":"(D23/100)^3","v":9.2609999999999984E-3},{"$f":"(D23/100)^2","v":4.4099999999999993E-2},{"$f":"(D23/100)","v":0.21},1,{"$f":"-(D22/Method_input!$D$30*D23/100)/(Method_input!$D$78+D24)","v":-1.2846474850360956E-3},null,{"$f":"D22/Method_input!$D$30*((D25-D24)/(Method_input!$D$78+D24))","v":6.7291058739985948E-2},{"$f":"E22/Method_input!$D$30*((E25-E24)/(Method_input!$D$78+E24))","v":5.5497780404112136E-2}]
["Part load ratio B","fC;PL;B","%",{"$f":"Method_input!D38","v":74},{"$f":"Method_input!E38","v":74},"EN 14825","No",null,null,{"$f":"(D26/100)^3","v":0.10382299999999998},{"$f":"(D26/100)^2","v":0.22089999999999999},{"$f":"(D26/100)","v":0.47},1,{"$f":"-D29/Method_input!$D$30*D26/100/(Method_input!$D$78+D27)","v":-1.8403107853766749E-3},null,{"$f":"D29/Method_input!$D$30*((D28-D27)/(Method_input!$D$78+D27))","v":9.0057761837581976E-2},{"$f":"E29/Method_input!$D$30*((E28-E27)/(Method_input!$D$78+E27))","v":0.11604081357223447}]
["Evaporator chilled water outlet temperature at part load condition B","ϑC;evap;out;B","°C",{"$f":"Method_input!D39","v":7},{"$f":"Method_input!E39","v":7},"EN 14825","No",null,null,"B = Inverse of matrix A:",null,null,null,null,null,"Test:"]
["Condensor cooling water/air inlet temperature at part load condition B","ϑcond;in;B","°C",{"$f":"Method_input!D40","v":26},{"$f":"Method_input!E40","v":26},"EN 14825","No",null,null,{"$f":"MINVERSE(A)","v":9.1859418346163029},-26.877385367951419,19.979083984970575,-9.18594183461631,6.8983013829808533,null,{"$f":"MMULT(A,D32:D36)","v":8.2098875602355445E-2}]
["Energy efficiency at part load condition C","EERC","-",{"$f":"Method_input!D41","v":4.76},{"$f":"Method_input!E41","v":4},"EN 14825","No",null,null,-13.044037405155152,45.154007418158379,-35.016380637749023,20.300931454502045,-17.394520829756257,null,8.6034172758283622E-2]
["Part load ratio C","fC;PL;C","%",{"$f":"Method_input!D42","v":47},{"$f":"Method_input!E42","v":47},"EN 14825","No",null,null,5.5290183902555547,-20.929419986023767,14.367294606800927,-14.309860189965287,15.342967178932577,null,9.0057761837581851E-2]
["Evaporator chilled water outlet temperature at part load condition C","ϑC;evap;out;C","°C",{"$f":"Method_input!D43","v":7},{"$f":"Method_input!E43","v":7},"EN 14825","No",null,null,-0.67092281971670586,2.652797935816805,-2.9667984188892769,3.1948705700795514,-1.2099472672903742,null,6.7291058739985907E-2]
["Condensor cooling water/air inlet temperature at part load condition C","ϑcond;in;C","°C",{"$f":"Method_input!D44","v":22},{"$f":"Method_input!E44","v":22},"EN 14825","No",null,null,0,0,-1018.8496502324338,0,1018.8496502324338,null,9.0057761837581865E-2]
["Energy efficiency at part load condition D","EERD","-",{"$f":"Method_input!D45","v":4.8499999999999996},{"$f":"Method_input!E45","v":4},"EN 14825","No"]
["Part load ratio D","fC;PL;D","%",{"$f":"Method_input!D46","v":21},{"$f":"Method_input!E46","v":21},"EN 14825","No"]
["Evaporator chilled water outlet temperature at part load condition D","ϑC;evap;out;D","°C",{"$f":"Method_input!D47","v":7},{"$f":"Method_input!E47","v":7},"EN 14825","No"]
["Condensor cooling water/air inlet temperature at part load condition D","ϑcond;in;D","°C",{"$f":"Method_input!D48","v":18},{"$f":"Method_input!E48","v":18},"EN 14825","No"]
["Part load ratio at 5th mearured point","fC;PL;5","%",{"$f":"Method_input!D49","v":47},{"$f":"Method_input!E49","v":47},"local","No"]
["Evaporator chilled water outlet temperature at 5th measured point","ϑC;evap;out;5","°C",{"$f":"Method_input!D50","v":7},{"$f":"Method_input!E50","v":7},"local","No"]
["Condensor cooling water/air inlet temperature at 5th measured point","ϑcond;in;5","°C",{"$f":"Method_input!D51","v":30},{"$f":"Method_input!E51","v":30},"local","No"]
["Energy efficiency at 5th measured point","EER5","-",{"$f":"D18*(D21-D20)/(D13-D12)","v":3.1043478260869564},{"$f":"Method_input!E52","v":4},"Formula (2) or local"]
[]
[null,null,null,null,null,"Formula ref","Formula"]
["Coefficient for the calculation of compression chiller characteristics","C1","-",{"$f":"MMULT(B,P11:P15)","v":0.24416729864195785},{"$f":"MMULT(B,Q11:Q15)","v":0.29216136286119776},"Formula (1)"]
["Coefficient for the calculation of compression chiller characteristics","C2","-",-0.54005044040788253,-0.72700155973820713]
["Coefficient for the calculation of compression chiller characteristics","C3","-",0.36599489564434151,0.70884613363623949]
["Coefficient for the calculation of compression chiller characteristics","C4","-",1.1987121723938662E-2,-1.117650240681331E-2]
["Corrective temperature difference","Dϑcorr","K",1.4210854715202004E-14,41.122832111568059]

{"sheet":"Process_design_data","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"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)"]
[]
["Free cooling operation possibility"]
[1,"FREE_COOL_OP",{"$f":"INDEX(C11:C12,A9)","v":"YES"}]
[]
["Free cooling possibility available (chiller can be bypassed)",null,"YES"]
["Free cooling not available",null,"NO"]
[]
[]
["Control of the hybrid heat rejection"]
[1,"HEAT_REJ_CTRL",{"$f":"INDEX(C18:C19,A16)","v":"TEMP"}]
[]
["Switch between dry and wet operation at a fixed outside air temperature",null,"TEMP"]
["Switch between dry and wet operation when chiller max. power at dry operation exceeded",null,"MAX_POWER"]

{"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":85,"n_cols":17,"rows_kept":85,"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,16]
["Number of time steps",null,72]
[]
["Description","Calculation time interval","Ambient air temperature","Ambient air wet-bulb temperature","Required cooling energy to be extracted by the generation system","Required generation outlet temperature","Recovered heat of the cooling generation system","Absorption cooling generation heat input","Supply temperature of absorption generation heat input","Temperature difference due to the heat losses in the heat rejection circuit","Heat losses in the heat rejection circuit","Auxiliary energy consumption in the heat rejection circuit","Priority for operation of generator j=1","Priority for operation of generator j=2","Sink temperature for generator type OTHER","Cooling operation factor","Operation factor of the control devices"]
["Symbol","tc,i","ϑe ","ϑe,wb","QC;gen;in;req","ϑC;gen;out;req","QC;gen;out;rd","QH;C;gen;abs;in","ϑH;C;gen;abs;in","DJls;dis;hr;","Qls;dis;hr;","Waux;dis;hr;","p","p","ϑsk ","fop;C","fop;ctrl"]
["Unit","h","°C","°C","kWh","°C","kWh","kWh","°C","K","kWh","kWh","-","-","°C","-","-"]
["Origin","M1-9","M1-13","M1-13","M4-1/\nM4-7","M4-1/\nM4-7","M3-1","M3-1","M3-1","M4-6","M4-6","M4-6","M10-12","M10-12","local","local","local"]
[]
["Time stamp",null,null,"VALUES"]
[1,1,14.2,12.3,7.6779149999999996,14,0,{"$f":"Output_series!H18","v":0},85,1,2,0.5,2,1,15,1,1]
[2,1,13.3,11.7,7.6578629999999999,14,0,{"$f":"Output_series!H19","v":0},85,1,2,0.5,2,1,15,1,1]
[3,1,12.8,11.2,7.6583290000000002,14,0,{"$f":"Output_series!H20","v":0},85,1,2,0.5,2,1,15,1,1]
[4,1,11.9,10.9,7.6552290000000003,14,0,{"$f":"Output_series!H21","v":0},85,1,2,0.5,2,1,15,1,1]
[5,1,12.1,11.2,7.6556890000000006,14,0,{"$f":"Output_series!H22","v":0},85,1,2,0.5,2,1,15,1,1]
[6,1,14.8,12.5,7.6805780000000006,14,0,{"$f":"Output_series!H23","v":0},85,1,2,0.5,2,1,15,1,1]
[7,1,17.600000000000001,13.5,24.943709999999999,14,0,{"$f":"Output_series!H24","v":0},85,1,2,0.5,2,1,15,1,1]
[8,1,20,14.1,8.2373130000000003,14,0,{"$f":"Output_series!H25","v":0},85,1,2,0.5,2,1,15,1,1]
[9,1,21.9,15,32.80547,14,0,{"$f":"Output_series!H26","v":0},85,1,2,0.5,2,1,15,1,1]
[10,1,24.2,16.2,54.28304,14,0,{"$f":"Output_series!H27","v":0},85,1,2,0.5,2,1,15,1,1]
[11,1,26,17,83.536179999999987,14,0,{"$f":"Output_series!H28","v":0},85,1,2,0.5,2,1,15,1,1]
[12,1,28.4,17.7,121.3237,14,0,{"$f":"Output_series!H29","v":0},85,1,2,0.5,2,1,15,1,1]
[13,1,30,17.399999999999999,83.938570000000013,14,0,{"$f":"Output_series!H30","v":0},85,1,2,0.5,2,1,15,1,1]
[14,1,31.1,17,96.63897,14,0,{"$f":"Output_series!H31","v":0},85,1,2,0.5,2,1,15,1,1]
[15,1,32.299999999999997,16.5,126.8655,14,0,{"$f":"Output_series!H32","v":0},85,1,2,0.5,2,1,15,1,1]
[16,1,32.6,16.600000000000001,83.362300000000005,14,0,{"$f":"Output_series!H33","v":0},85,1,2,0.5,2,1,15,1,1]
[17,1,32.700000000000003,16.5,64.910240000000002,14,0,{"$f":"Output_series!H34","v":0},85,1,2,0.5,2,1,15,1,1]
[18,1,31.2,18.100000000000001,47.641169999999995,14,0,{"$f":"Output_series!H35","v":0},85,1,2,0.5,2,1,15,1,1]
[19,1,27.9,17.899999999999999,37.940489999999997,14,0,{"$f":"Output_series!H36","v":0},85,1,2,0.5,2,1,15,1,1]
[20,1,24.4,17.2,8.7321439999999999,14,0,{"$f":"Output_series!H37","v":0},85,1,2,0.5,2,1,15,1,1]
[21,1,21.1,16.600000000000001,8.1733239999999991,14,0,{"$f":"Output_series!H38","v":0},85,1,2,0.5,2,1,15,1,1]
[22,1,19.2,15.8,7.9435820000000001,14,0,{"$f":"Output_series!H39","v":0},85,1,2,0.5,2,1,15,1,1]
[23,1,18.100000000000001,15.6,7.7656159999999996,14,0,{"$f":"Output_series!H40","v":0},85,1,2,0.5,2,1,15,1,1]
[24,1,17,15.1,7.7245010000000001,14,0,{"$f":"Output_series!H41","v":0},85,1,2,0.5,2,1,15,1,1]
[25,1,17.7,17,7.7071199999999997,14,0,{"$f":"Output_series!H42","v":0},85,1,2,0.5,2,1,15,1,1]
[26,1,17,16.399999999999999,7.7070789999999993,14,0,{"$f":"Output_series!H43","v":0},85,1,2,0.5,2,1,15,1,1]
[27,1,16.600000000000001,16.100000000000001,7.6963800000000004,14,0,{"$f":"Output_series!H44","v":0},85,1,2,0.5,2,1,15,1,1]
[28,1,16.2,15.6,7.6910230000000004,14,0,{"$f":"Output_series!H45","v":0},85,1,2,0.5,2,1,15,1,1]
[29,1,15.8,15.2,7.6883340000000002,14,0,{"$f":"Output_series!H46","v":0},85,1,2,0.5,2,1,15,1,1]
[30,1,16.600000000000001,16,7.702153,14,0,{"$f":"Output_series!H47","v":0},85,1,2,0.5,2,1,15,1,1]
[31,1,18.7,17.3,17.01632,14,0,{"$f":"Output_series!H48","v":0},85,1,2,0.5,2,1,15,1,1]
[32,1,21.2,18.399999999999999,9.0165589999999991,14,0,{"$f":"Output_series!H49","v":0},85,1,2,0.5,2,1,15,1,1]
[33,1,23.7,19.600000000000001,30.87032,14,0,{"$f":"Output_series!H50","v":0},85,1,2,0.5,2,1,15,1,1]
[34,1,25.8,20.3,52.225819999999999,14,0,{"$f":"Output_series!H51","v":0},85,1,2,0.5,2,1,15,1,1]
[35,1,27.3,20.9,84.880560000000003,14,0,{"$f":"Output_series!H52","v":0},85,1,2,0.5,2,1,15,1,1]
[36,1,28.8,21,126.2893,14,0,{"$f":"Output_series!H53","v":0},85,1,2,0.5,2,1,15,1,1]
[37,1,30.3,21.3,90.222830000000002,14,0,{"$f":"Output_series!H54","v":0},85,1,2,0.5,2,1,15,1,1]
[38,1,31.5,20.9,103.12130000000001,14,0,{"$f":"Output_series!H55","v":0},85,1,2,0.5,2,1,15,1,1]
[39,1,32.4,21,126.6562,14,0,{"$f":"Output_series!H56","v":0},85,1,2,0.5,2,1,15,1,1]
[40,1,32.4,20.6,84.229690000000005,14,0,{"$f":"Output_series!H57","v":0},85,1,2,0.5,2,1,15,1,1]
[41,1,32.6,20.3,66.01652,14,0,{"$f":"Output_series!H58","v":0},85,1,2,0.5,2,1,15,1,1]
[42,1,29.9,22,46.904789999999998,14,0,{"$f":"Output_series!H59","v":0},85,1,2,0.5,2,1,15,1,1]
[43,1,27.4,20.7,31.430859999999999,14,0,{"$f":"Output_series!H60","v":0},85,1,2,0.5,2,1,15,1,1]
[44,1,24.2,20.2,8.4418930000000003,14,0,{"$f":"Output_series!H61","v":0},85,1,2,0.5,2,1,15,1,1]
[45,1,22.4,19.399999999999999,8.123329,14,0,{"$f":"Output_series!H62","v":0},85,1,2,0.5,2,1,15,1,1]
[46,1,21.2,19.3,7.8712349999999995,14,0,{"$f":"Output_series!H63","v":0},85,1,2,0.5,2,1,15,1,1]
[47,1,20.2,18.7,7.7353459999999998,14,0,{"$f":"Output_series!H64","v":0},85,1,2,0.5,2,1,15,1,1]
[48,1,19.399999999999999,18.3,7.7195369999999999,14,0,{"$f":"Output_series!H65","v":0},85,1,2,0.5,2,1,15,1,1]
[49,1,17.600000000000001,15.1,7.6485760000000003,14,0,{"$f":"Output_series!H66","v":0},85,1,2,0.5,2,1,15,1,1]
[50,1,17.3,15.1,7.6424989999999999,14,0,{"$f":"Output_series!H67","v":0},85,1,2,0.5,2,1,15,1,1]
[51,1,16.5,14.8,7.6333860000000007,14,0,{"$f":"Output_series!H68","v":0},85,1,2,0.5,2,1,15,1,1]
[52,1,15.8,14.5,7.6277989999999996,14,0,{"$f":"Output_series!H69","v":0},85,1,2,0.5,2,1,15,1,1]
[53,1,15.2,14.1,7.6122060000000005,14,0,{"$f":"Output_series!H70","v":0},85,1,2,0.5,2,1,15,1,1]
[54,1,14.4,13.7,7.5997209999999997,14,0,{"$f":"Output_series!H71","v":0},85,1,2,0.5,2,1,15,1,1]
[55,1,14.5,13.6,5.5240179999999999,14,0,{"$f":"Output_series!H72","v":0},85,1,2,0.5,2,1,15,1,1]
[56,1,16.3,14.6,5.5577719999999999,14,0,{"$f":"Output_series!H73","v":0},85,1,2,0.5,2,1,15,1,1]
[57,1,17.8,15.3,5.5918850000000004,14,0,{"$f":"Output_series!H74","v":0},85,1,2,0.5,2,1,15,1,1]
[58,1,19,15.8,6.0756069999999998,14,0,{"$f":"Output_series!H75","v":0},85,1,2,0.5,2,1,15,1,1]
[59,1,20.5,16,8.9173500000000008,14,0,{"$f":"Output_series!H76","v":0},85,1,2,0.5,2,1,15,1,1]
[60,1,21.8,16.2,18.141099999999998,14,0,{"$f":"Output_series!H77","v":0},85,1,2,0.5,2,1,15,1,1]
[61,1,23,16.5,14.57667,14,0,{"$f":"Output_series!H78","v":0},85,1,2,0.5,2,1,15,1,1]
[62,1,23.8,16.899999999999999,17.556090000000001,14,0,{"$f":"Output_series!H79","v":0},85,1,2,0.5,2,1,15,1,1]
[63,1,24.3,16.8,27.2104,14,0,{"$f":"Output_series!H80","v":0},85,1,2,0.5,2,1,15,1,1]
[64,1,24,16.600000000000001,13.710709999999999,14,0,{"$f":"Output_series!H81","v":0},85,1,2,0.5,2,1,15,1,1]
[65,1,22.1,16.2,8.5627929999999992,14,0,{"$f":"Output_series!H82","v":0},85,1,2,0.5,2,1,15,1,1]
[66,1,19.100000000000001,15.2,6.0824099999999994,14,0,{"$f":"Output_series!H83","v":0},85,1,2,0.5,2,1,15,1,1]
[67,1,16.399999999999999,14.5,5.5891380000000002,14,0,{"$f":"Output_series!H84","v":0},85,1,2,0.5,2,1,15,1,1]
[68,1,15.1,14,7.6586000000000007,14,0,{"$f":"Output_series!H85","v":0},85,1,2,0.5,2,1,15,1,1]
[69,1,14.1,13.3,7.6501229999999998,14,0,{"$f":"Output_series!H86","v":0},85,1,2,0.5,2,1,15,1,1]
[70,1,13.2,12.7,7.6361999999999997,14,0,{"$f":"Output_series!H87","v":0},85,1,2,0.5,2,1,15,1,1]
[71,1,12.3,11.8,7.627135,14,0,{"$f":"Output_series!H88","v":0},85,1,2,0.5,2,1,15,1,1]
[72,1,11.8,11.4,7.6207719999999997,14,0,{"$f":"Output_series!H89","v":0},85,1,2,0.5,2,1,15,1,1]

{"sheet":"Method_input","index":7,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["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","Unit","Value","Range","Origin","Varying","Notes"]
["Operating conditions data",null,null,"Generator 1","Generator 2"]
["Calculation time interval","tc,i","h",1,null,"M1-9","no"]
["Ambient air temperature","ϑe ","°C",11.8,null,"M1-13","yes"]
["Ambient air wet-bulb temperature","ϑe,wb","°C",11.4,null,"M1-13","yes"]
["Required cooling energy to be extracted by the generation system","QC;gen;in;req","kWh",7.6207719999999997,null,"M4-1","yes","Method output (looped through, but also used in calculation)"]
["Required generation outlet temperature","ϑC;gen;out;req","°C",14,null,"M4-1","yes"]
["Recovered heat of the cooling generation system","QC;gen;out;rd","kWh",0,null,"M3-1","yes"]
["Absorption cooling generation heat input","QH;C;gen;abs;in","kWh",0,null,"M3-1","yes","Method output (looped through, but also used in calculation)"]
["Supply temperature of absorption generation heat input","ϑH;C;gen;abs;in","°C",85,null,"M3-1","yes"]
["Temperature difference due to the heat losses in the heat rejection circuit","DJls;dis;hr;","K",1,null,"M4-6","Yes"]
["Heat losses in the heat rejection circuit","Qls;dis;hr;","kWh",2,null,"M4-6","Yes"]
["Auxiliary energy consumption in the heat rejection circuit","Waux;dis;hr;","kWh",0.5,null,"M4-6","Yes"]
["Priority for operation of generator j=1","p","-",2,null,"M10-12","yes"]
["Priority for operation of generator j=2","p","-",1,null,"M10-12","yes"]
["Sink temperature for generator type OTHER","ϑsk ","°C",15,null,"local","yes"]
["Cooling operation factor","fop;C","-",1,null,"local","yes"]
["Operation factor of the control devices","fop;ctrl","-",1,null,"local","yes"]
[]
["Product description data"]
["Generator type","GEN_TYPE","List",{"$f":"Product_descriptive_data!C9","v":"COMP"},{"$f":"Product_descriptive_data!C17","v":"COMP"},"local","No"]
["Heat rejection type","HEAT_REJ_TYPE","List",{"$f":"Product_descriptive_data!C25","v":"HYBRID"},null,"local","No"]
[]
["Product technical data"]
["Generator outlet temperature limit","JC;gen;out;lim","°C",6,6,"local","No"]
["Nominal thermal power extracted from chilled water circuit","ΦC;gen;n","kW",100,50,"local","No"]
["Nominal energy efficiency ratio","EERn","-",2.83,4,"EN 14511","No","or default value"]
["condensor cooling water/air inlet temperature at nominal conditions","ϑcond;in;n","°C",30,34,"local","No"]
["evaporator chilled water outlet temperature at nominal conditions","ϑC;evap;out;n","°C",7,10,"local","No"]
["Energy efficiency at part load condition A","EERA","-",2.83,4,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Part load ratio A","fC;PL;A","%",100,100,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Evaporator chilled water outlet temperature at part load condition A","ϑC; evap;out;A","°C",7,7,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Condensor cooling water/air inlet temperature part load condition A","ϑcond;in;A","°C",30,30,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Energy efficiency at part load condition B","EERB","-",3.59,4,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Part load ratio B","fC;PL;B","%",74,74,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Evaporator chilled water outlet temperature at part load condition B","ϑC;evap;out;B","°C",7,7,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Condensor cooling water/air inlet temperature at part load condition B","ϑcond;in;B","°C",26,26,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Energy efficiency at part load condition C","EERC","-",4.76,4,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Part load ratio C","fC;PL;C","%",47,47,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Evaporator chilled water outlet temperature at part load condition C","ϑC;evap;out;C","°C",7,7,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Condensor cooling water/air inlet temperature at part load condition C","ϑcond;in;C","°C",22,22,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Energy efficiency at part load condition D","EERD","-",4.8499999999999996,4,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Part load ratio D","fC;PL;D","%",21,21,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Evaporator chilled water outlet temperature at part load condition D","ϑC;evap;out;D","°C",7,7,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Condensor cooling water/air inlet temperature at part load condition D","ϑcond;in;D","°C",18,18,"EN 14825","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Part load ratio at 5th mearured point","fC;PL;5","%",47,47,"local","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Evaporator chilled water outlet temperature at 5th measured point","ϑC;evap;out;5","°C",7,7,"local","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Condensor cooling water/air inlet temperature at 5th measured point","ϑcond;in;5","°C",30,30,"local","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Energy efficiency at 5th measured point","EER5","-",{"$f":"Product_tech_data!D29","v":3.1043478260869564},4,"Formula (2) or local","No","used in sheet \"Product_tech_data\" to calculate performance map"]
["Minimum part load ratio of the generator","fC;PL;min","%",25,0,"local","No"]
["Coefficient for the calculation of absorption chiller characteristics","C5","-",-1.428E-3,-1.428E-3,"local","No"]
["Coefficient for the calculation of absorption chiller characteristics","C6","-",3.1150000000000001E-2,3.1150000000000001E-2,"local","No"]
["Coefficient for the calculation of absorption chiller characteristics","C7","-",0.4476,0.4476,"local","No"]
["condenser input limit temperature","Jcond;in;lim","°C",20,null,"local","No"]
["specific electrical power demand of the heat rejection system in dry operation","phr;el;dry","kW/kW",2.5000000000000001E-2,null,"local","No"]
["specific electrical power demand of the heat rejection system in wet operation","phr;el;wet","kW/kW",3.3000000000000002E-2,null,"local","No"]
["specific electrical power demand of the heat rejection system type OTHER","phr;el;oth","kW/kW",0.1,null,"local","No"]
["electric power consumption of control device i (sensors, actuators, controllers)","Pel;C;ctrl,i","kW",0.1,null,"local","No"]
[]
["System design data"]
["Process design"]
["Free cooling operation possibility","FREE_COOL_OP","-",{"$f":"Process_design_data!C9","v":"YES"},null,"local","no"]
["number of generators","ngen","-",2,null,"local","no","Method output (looped through, but also used in calculation)"]
["wet heat rejection temperature limit","ϑlim;wet;hr","°C",22,null,"local","No"]
["free cooling operation temperature difference limit","DJfc","°C",2,null,"local","No"]
["heat rejection operation temperature difference","DJhr","°C",6,null,"local","No"]
["required supply temperature of absorption generation heat input","ϑH;C;gen;abs;in;req","°C",90,null,"local","no","Method output (looped through)"]
["Max. temperature level of recoverable heat","ϑC,gen;out;max","°C",40,null,"local","no","Method output (looped through)"]
[]
["Control type data"]
["Control of the hybrid heat rejection","HBRD_HEAT_REJ_CTRL","-",{"$f":"Process_design_data!C16","v":"TEMP"}]
[]
["Constants"]
["Water specific heat","cp,w ","Wh/kg°C",1.1599999999999999]
["Reference Temperature","T0,abs","K",273.14999999999998]

{"sheet":"Method_calculation","index":8,"n_rows":82,"n_cols":7,"rows_kept":82,"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"]
["Operation conditions calculations"]
["Evaporator water outlet temperature for chiller type generators ","JC,cond;in;dry","°C",{"$f":"MAX(Method_input!D57,Method_input!D7+Method_input!D69+Method_input!D14)","v":20},"Formula (3a)","max(Jcond;in;lim ; Je + DJhr + DJls;dis;hr)"]
["Evaporator water outlet temperature for chiller type generators ","JC,cond;in;wet","°C",{"$f":"MAX(Method_input!D57,Method_input!D8+Method_input!D69+Method_input!D14)","v":20},"Formula (3b)","max(Jcond;in;lim ; Je;wb + DJhr + DJls;dis;hr)"]
["generation outlet temperature really delivered","JC;gen;out","-",{"$f":"MAX(Method_input!D10,Method_input!D28)","v":14},"Formula (4)","JC;gen;out = max(JC;gen;out;req ; JC;gen;out;lim)","Method output"]
["Evaporator outlet water temperature in case of compression or absorption chillers","JC;evap;out","°C",{"$f":"IF(OR(Method_input!D24=\"COMP\",Method_input!D24=\"ABS\"),D7,\"-\")","v":14},"Formula (5)","JC;evap;out =  JC;gen;out"]
["Operation factor for free cooling mode, if FREE_COOL_OP = NO","fop;fc","-",{"$f":"IF(OR(Method_input!D65=\"NO\",Method_input!D25=\"AIR_C_COND\"),0,\"-\")","v":"-"},"Formula (6a)","fop;fc = 0"]
["Operation factor for free cooling mode, else if HEAT_REJ_TYPE = DRY","fop;fc","-",{"$f":"IF(AND(Method_input!D65=\"YES\",Method_input!D25=\"DRY\"),IF((Method_input!D10-Method_input!D7)>Method_input!D68,1,0),\"-\")","v":"-"},"Formula (6b)","If (JC;gen;out;req - Je) > DJfc                 fop;fc = 1\nelse                                                   fop;fc = 0"]
["Operation factor for free cooling mode, else if HEAT_REJ_TYPE = WET or HYBRID","fop;fc","-",{"$f":"IF(AND(Method_input!D65=\"YES\",OR(Method_input!D25=\"WET\",Method_input!D25=\"HYBRID\")),IF((Method_input!D10-Method_input!D8)>Method_input!D68,1,0),\"-\")","v":1},"Formula (6c)","If (JC;gen;out;req - Je;wb) > DJfc              fop;fc = 1\nelse                                                   fop;fc = 0"]
["Operation factor for free cooling mode, else","fop;fc","-",{"$f":"IF(AND(Method_input!D65=\"YES\",Method_input!D25=\"OTHER\"),IF((Method_input!D10-Method_input!D19)>Method_input!D68,1,0),\"-\")","v":"-"},"Formula (6d)","If (JC;gen;out;req - Jsk) > DJfc              fop;fc = 1\nelse                                                   fop;fc = 0"]
["Maximum energy possibly extracted by the generation system ","QC;gen;in;max","kWh",{"$f":"SUM(D14:D19)","v":462.98670456134926},"Formula (7)"]
["The maximum heat extraction of generator j=1, If HEAT_REJ_TYPE = AIR_C_COND","QC;gen;in;max;j","kWh",{"$f":"IF(Method_input!D25=\"AIR_C_COND\",IF(D20<>\"-\",D20,IF(D23<>\"-\",D23,D26)),0)","v":0},"Formula (8a)","QC;gen;in;max;j = QC;gen;in;max;j;e","Method output"]
["The maximum heat extraction of generator j=1, else if fop;hr;wet = 1","QC;gen;in;max;j","kWh",{"$f":"IF(AND(Method_input!D25<>\"AIR_C_COND\",OR(D44=1,D46=1,D48=1,D50=1,D52=1,D54=1,D56=1,D58=1)),IF(D22<>\"-\",D22,D25),0)","v":0},"Formula (8b)","QC;gen;in;max;j = QC;gen;in;max;j;wet","Method output"]
["The maximum heat extraction of generator j=1, else","QC;gen;in;max;j","kWh",{"$f":"IF(AND(Method_input!D25<>\"AIR_C_COND\",OR(D44=0,D46=0,D48=0,D50=0,D52=0,D54=0,D56=0,D58=0)),IF(D21<>\"-\",D21,IF(D24<>\"-\",D24,IF(D26<>\"-\",D26))),0)","v":392.91153548694081},"Formula (8c)","QC;gen;in;max;j = QC;gen;in;max;j;dry","Method output"]
["The maximum heat extraction of generator j=2, If HEAT_REJ_TYPE = AIR_C_COND","QC;gen;in;max;j","kWh",{"$f":"IF(Method_input!D25=\"AIR_C_COND\",IF(D27<>\"-\",D27,IF(D30<>\"-\",D30)),0)","v":0},"Formula (8a)","QC;gen;in;max;j = QC;gen;in;max;j;e","Method output"]
["The maximum heat extraction of generator j=2, else if fop;hr;wet = 1","QC;gen;in;max;j","kWh",{"$f":"IF(AND(Method_input!D25<>\"AIR_C_COND\",OR(D44=1,D46=1,D48=1,D50=1,D52=1,D54=1,D56=1,D58=1)),IF(D29<>\"-\",D29,IF(D32<>\"-\",D32)),0)","v":0},"Formula (8b)","QC;gen;in;max;j = QC;gen;in;max;j;wet","Method output"]
["The maximum heat extraction of generator j=2, else","QC;gen;in;max;j","kWh",{"$f":"IF(AND(Method_input!D25<>\"AIR_C_COND\",OR(D44=0,D46=0,D48=0,D50=0,D52=0,D54=0,D56=0,D58=0)),IF(D28<>\"-\",D28,IF(D31<>\"-\",D31,IF(D33<>\"-\",D33))),0)","v":70.07516907440845},"Formula (8c)","QC;gen;in;max;j = QC;gen;in;max;j;dry","Method output"]
["maximum heat extraction of the generator j=1 depending on type and operation, if GEN_TYPE = COMP","QC;gen;in;max;j;e","kWh",{"$f":"IF(Method_input!D24=\"COMP\",Method_input!D29*Method_in*((Method_input!$D$78+D8)/(MAX(Method_input!D57,Method_input!D7)-D8+Product_tech_data!D36))/((Method_input!$D$78+Method_input!D32)/(Method_input!D31-Method_input!D32+Product_tech_data!D36)),\"-\")","v":392.91153548694081},"Formula (9a)"]
["maximum heat extraction of the generator j=1 depending on type and operation, if GEN_TYPE = COMP","QC;gen;in;max;j;dry","kWh",{"$f":"IF(Method_input!D24=\"COMP\",Method_input!D29*Method_in*((Method_input!$D$78+D8)/(D5-D8+Product_tech_data!D36))/((Method_input!$D$78+Method_input!D32)/(Method_input!D31-Method_input!D32+Product_tech_data!D36)),\"-\")","v":392.91153548694081},"Formula (9b)"]
["Maximum heat extraction of the generator j=1 depending on type and operation, if GEN_TYPE = COMP","QC;gen;in;max;j;wet","kWh",{"$f":"IF(Method_input!D24=\"COMP\",Method_input!D29*Method_in*((Method_input!$D$78+D8)/(D6-D8+Product_tech_data!D36))/((Method_input!$D$78+Method_input!D32)/(Method_input!D31-Method_input!D32+Product_tech_data!D36)),\"-\")","v":392.91153548694081},"Formula (9c)"]
["Maximum heat extraction of the generator j=1 depending on type and operation, if GEN_TYPE = ABS","QC;gen;in;max;j;e","kWh",{"$f":"IF(Method_input!D24=\"ABS\",Method_input!D29*Method_in*(Method_input!D54*D34^2+Method_input!D55*D34+Method_input!D56)/(Method_input!D54*D37^2+Method_input!D55*D37+Method_input!D56),\"-\")","v":"-"},"Formula (9d)"]
["Maximum heat extraction of the generator j=1 depending on type and operation, if GEN_TYPE = ABS","QC;gen;in;max;j;dry","kWh",{"$f":"IF(Method_input!D24=\"ABS\",Method_input!D29*Method_in*(Method_input!D54*D35^2+Method_input!D55*D35+Method_input!D56)/(Method_input!D54*D37^2+Method_input!D55*D37+Method_input!D56),\"-\")","v":"-"},"Formula (9e)"]
["Maximum heat extraction of the generator j=1 depending on type and operation, if GEN_TYPE = ABS","QC;gen;in;max;j;wet","kWh",{"$f":"IF(Method_input!D24=\"ABS\",Method_input!D29*Method_in*(Method_input!D54*D36^2+Method_input!D55*D36+Method_input!D56)/(Method_input!D54*D37^2+Method_input!D55*D37+Method_input!D56),\"-\")","v":"-"},"Formula (9f)"]
["Maximum heat extraction of the generator j=1 depending on type and operation, else","QC;gen;in;max;j;dry","kWh",{"$f":"IF(Method_input!D24=\"OTHER\",Method_input!D29*Method_in*0.1,\"-\")","v":"-"},"Formula (9g)"]
["maximum heat extraction of the generator j=2 depending on type and operation, if GEN_TYPE = COMP","QC;gen;in;max;j;e","kWh",{"$f":"IF(Method_input!E24=\"COMP\",Method_input!E29*Method_in*((Method_input!$D$78+D8)/(MAX(Method_input!D57,Method_input!D7)-D8+Product_tech_data!E36))/((Method_input!$D$78+Method_input!E32)/(Method_input!E31-Method_input!E32+Product_tech_data!E36)),\"-\")","v":70.07516907440845},"Formula (9a)"]
["maximum heat extraction of the generator j=2 depending on type and operation, if GEN_TYPE = COMP","QC;gen;in;max;j;dry","kWh",{"$f":"IF(Method_input!E24=\"COMP\",Method_input!E29*Method_in*((Method_input!$D$78+D8)/(D5-D8+Product_tech_data!E36))/((Method_input!$D$78+Method_input!E32)/(Method_input!E31-Method_input!E32+Product_tech_data!E36)),\"-\")","v":70.07516907440845},"Formula (9b)"]
["Maximum heat extraction of the generator j=2 depending on type and operation, if GEN_TYPE = COMP","QC;gen;in;max;j;wet","kWh",{"$f":"IF(Method_input!E24=\"COMP\",Method_input!E29*Method_in*((Method_input!$D$78+D8)/(D6-D8+Product_tech_data!E36))/((Method_input!$D$78+Method_input!E32)/(Method_input!E31-Method_input!E32+Product_tech_data!E36)),\"-\")","v":70.07516907440845},"Formula (9c)"]
["Maximum heat extraction of the generator j=2 depending on type and operation, if GEN_TYPE = ABS","QC;gen;in;max;j;e","kWh",{"$f":"IF(Method_input!E24=\"ABS\",Method_input!E29*Method_in*(Method_input!E54*D34^2+Method_input!E55*D34+Method_input!E56)/(Method_input!E54*D37^2+Method_input!E55*D37+Method_input!E56),\"-\")","v":"-"},"Formula (9d)"]
["Maximum heat extraction of the generator j=2 depending on type and operation, if GEN_TYPE = ABS","QC;gen;in;max;j;dry","kWh",{"$f":"IF(Method_input!E24=\"ABS\",Method_input!E29*Method_in*(Method_input!E54*D35^2+Method_input!E55*D35+Method_input!E56)/(Method_input!E54*D37^2+Method_input!E55*D37+Method_input!E56),\"-\")","v":"-"},"Formula (9e)"]
["Maximum heat extraction of the generator j=2 depending on type and operation, if GEN_TYPE = ABS","QC;gen;in;max;j;wet","kWh",{"$f":"IF(Method_input!E24=\"ABS\",Method_input!E29*Method_in*(Method_input!E54*D36^2+Method_input!E55*D36+Method_input!E56)/(Method_input!E54*D37^2+Method_input!E55*D37+Method_input!E56),\"-\")","v":"-"},"Formula (9f)"]
["Maximum heat extraction of the generator j=2 depending on type and operation, else","QC;gen;in;max;j;dry","kWh",{"$f":"IF(Method_input!E24=\"OTHER\",Method_input!E29*Method_in,\"-\")","v":"-"},"Formula (9g)"]
["Carnot heat ratio with outdoor air","zc;e","kWh",{"$f":"(Method_input!$D$78+D8)*(Method_input!D13-MAX(Method_input!D57,Method_input!D7))/((Method_input!$D$78+Method_input!D13)*(MAX(Method_input!D57,Method_input!D7)-D8))","v":8.6857229280096817},"Formula (22)"]
["Carnot heat ratio with dry heat rejection ","zc;dry","kWh",{"$f":"(Method_input!$D$78+D8)*(Method_input!D13-D5)/((Method_input!$D$78+Method_input!D13)*(D5-D8))","v":8.6857229280096817},"Formula (22)"]
["Carnot heat ratio with wet heat rejection","zc;wet","kWh",{"$f":"(Method_input!$D$78+D8)*(Method_input!D13-D6)/((Method_input!$D$78+Method_input!D13)*(D6-D8))","v":8.6857229280096817},"Formula (22)"]
["Carnot heat ratio under nominal conditions","zc;n","kWh",{"$f":"(Method_input!$D$78+Method_input!D32)*(90-Method_input!D31)/((Method_input!$D$78+90)*(Method_input!D31-Method_input!D32))","v":2.0124634089398921},"Formula (22)"]
["Energy to be extracted by the generator with priority p (for p = 1..ngen), if\n",null,"kWh",{"$f":"IF(Method_input!D17<Method_input!D18,IF(Method_input!D9>IF(D14<>0,D14,IF(D15<>0,D15,D16)),Method_input!D9-IF(D14<>0,D14,IF(D15<>0,D15,D16)),\"-\"),IF(Method_input!D9>IF(D17<>0,D17,IF(D18<>0,D18,D19)),Method_input!D9-IF(D17<>0,D17,IF(D18<>0,D18,D19)),\"-\"))","v":"-"},"Formula (10a)"]
["Energy to be extracted by the generator with priority p (for p = 1..ngen), if\n",null,"kWh",{"$f":"IF(Method_input!D17<Method_input!D18,IF(Method_input!D9>IF(D14<>0,D14,IF(D15<>0,D15,D16)),IF(D14<>0,D14,IF(D15<>0,D15,D16)),\"-\"),IF(Method_input!D9>IF(D17<>0,D17,IF(D18<>0,D18,D19)),IF(D17<>0,D17,IF(D18<>0,D18,D19)),\"-\"))","v":"-"},"Formula (11a)"]
["Energy to be extracted by the generator with priority p (for p = 1..ngen), else",null,"kWh",{"$f":"IF(Method_input!D17<Method_input!D18,IF(Method_input!D9<=IF(D14<>0,D14,IF(D15<>0,D15,D16)),0,\"-\"),IF(Method_input!D9<=IF(D17<>0,D17,IF(D18<>0,D18,D19)),0,\"-\"))","v":0},"Formula (10b)"]
["Energy to be extracted by the generator with priority p (for p = 1..ngen), else",null,"kW",{"$f":"IF(Method_input!D17<Method_input!D18,IF(Method_input!D9<=IF(D14<>0,D14,IF(D15<>0,D15,D16)),MAX(0,Method_input!D9),\"-\"),IF(Method_input!D9<=IF(D17<>0,D17,IF(D18<>0,D18,D19)),MAX(0,Method_input!D9),\"-\"))","v":7.6207719999999997},"Formula (11b)"]
["Part-load factor of generator j=1",null,"-",{"$f":"IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40))/IF(D14<>0,D14,IF(D15<>0,D15,D16))*100","v":0},"Formula (12)"]
["Part-load factor of generator j=2",null,"-",{"$f":"IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41))/IF(D17<>0,D17,IF(D18<>0,D18,D19))*100","v":10.875138941024854},"Formula (12)"]
["Operation factor of the heat rejection device, if HEAT_REJ_TYPE = AIR_C_COND","fop;hr;wet","-",{"$f":"IF(Method_input!D25=\"AIR_C_COND\",0,\"-\")","v":"-"},"Formula (13a)","fop;hr;wet = 0"]
["Condenser inlet temperature from the heat rejection device, if HEAT_REJ_TYPE = AIR_C_COND","Jcond;in","°C",{"$f":"IF(Method_input!D25=\"AIR_C_COND\",MAX(Method_input!D57,Method_input!D7),\"-\")","v":"-"},"Formula (14a)","Jcond;in = max(Jcond;in;lim ; Je)"]
["Operation factor of the heat rejection device, else if HEAT_REJ_TYPE = DRY","fop;hr;wet","-",{"$f":"IF(Method_input!D25=\"DRY\",0,\"-\")","v":"-"},"Formula (13b)","fop;hr;wet = 0"]
["Condenser inlet temperature from the heat rejection device, else if HEAT_REJ_TYPE = DRY","Jcond;in","°C",{"$f":"IF(Method_input!D25=\"DRY\",D5,\"-\")","v":"-"},"Formula (14b)","Jcond;in = Jcond;in;dry"]
["Operation factor of the heat rejection device, else if HEAT_REJ_TYPE = WET","fop;hr;wet","-",{"$f":"IF(Product_descriptive_data!C25=\"WET\",1,\"-\")","v":"-"},"Formula (13c)","fop;hr;wet = 1"]
["Condenser inlet temperature from the heat rejection device, else if HEAT_REJ_TYPE = WET","Jcond;in","°C",{"$f":"IF(Method_input!D25=\"WET\",D6,\"-\")","v":"-"},"Formula (14c)","Jcond;in = Jcond;in;wet"]
["Operation factor of the heat rejection device, else if HEAT_REJ_TYPE = HYBRID, if HBRD_HEAT_REJ_CTRL = TEMP, if Je > Jlim;wet;hr","fop;hr;wet","-",{"$f":"IF(AND(Method_input!D25=\"HYBRID\",Method_input!D74=\"TEMP\",Method_input!D7>Method_input!D67),1,\"-\")","v":"-"},"Formula (13d)","fop;hr;wet = 1"]
["Condenser inlet temperature from the heat rejection device, else if HEAT_REJ_TYPE = HYBRID, if HBRD_HEAT_REJ_CTRL = TEMP, if Je > Jlim;wet;hr","Jcond;in","°C",{"$f":"IF(AND(Method_input!D25=\"HYBRID\",Method_input!D74=\"TEMP\",Method_input!D7>Method_input!D67),D6,\"-\")","v":"-"},"Formula (14d)","Jcond;in = Jcond;in;wet"]
["Operation factor of the heat rejection device, else if HEAT_REJ_TYPE = HYBRID, if HBRD_HEAT_REJ_CTRL = TEMP, else","fop;hr;wet","-",{"$f":"IF(AND(Method_input!D25=\"HYBRID\",Method_input!D74=\"TEMP\",Method_input!D7<=Method_input!D67),0,\"-\")","v":0},"Formula (13e)","fop;hr;wet = 0"]
["Condenser inlet temperature from the heat rejection device, else if HEAT_REJ_TYPE = HYBRID, if HBRD_HEAT_REJ_CTRL = TEMP, else","Jcond;in","°C",{"$f":"IF(AND(Method_input!D25=\"HYBRID\",Method_input!D74=\"TEMP\",Method_input!D7<=Method_input!D67),D5,\"-\")","v":20},"Formula (14e)","Jcond;in = Jcond;in;dry"]
["Operation factor of the heat rejection device, else if HEAT_REJ_TYPE = HYBRID, else if HEAT_REJ_CTRL = MAX_POWER, if ","fop;hr;wet","-",{"$f":"IF(AND(Product_descriptive_data!C25=\"HYBRID\",Process_design_data!C16=\"MAX_POWER\",Method_input!D9>SUM(D21,D24,D26,D28,D31,D33)),1,\"-\")","v":"-"},"Formula (13f)","fop;hr;wet = 1"]
["Condenser inlet temperature from the heat rejection device, else if HEAT_REJ_TYPE = HYBRID, else if HBRD_HEAT_REJ_CTRL = MAX_POWER, if ","Jcond;in","°C",{"$f":"IF(AND(Product_descriptive_data!C25=\"HYBRID\",Process_design_data!C16=\"MAX_POWER\",Method_input!D9>SUM(D21,D24,D26,D28,D31,D33)),MAX(D6,Method_input!D57),\"-\")","v":"-"},"Formula (14f)","Jcond;in = max(Jcond;in;lim ; Jcond;in;wet)"]
["Operation factor of the heat rejection device, else if HEAT_REJ_TYPE = HYBRID,  else if HBRD_HEAT_REJ_CTRL = MAX_POWER,, else","fop;hr;wet","-",{"$f":"IF(AND(Product_descriptive_data!C25=\"HYBRID\",Process_design_data!C16=\"MAX_POWER\",Method_input!D9<=SUM(D21,D24,D26,D28,D31,D33)),0,\"-\")","v":"-"},"Formula (13g)","fop;hr;wet = 0"]
["Condenser inlet temperature from the heat rejection device, else if HEAT_REJ_TYPE = HYBRID,  else if HBRD_HEAT_REJ_CTRL = MAX_POWER, else","Jcond;in","°C",{"$f":"IF(AND(Product_descriptive_data!C25=\"HYBRID\",Process_design_data!C16=\"MAX_POWER\",Method_input!D9<=SUM(D21,D24,D26,D28,D31,D33)),D5,\"-\")","v":"-"},"Formula (14g)","Jcond;in = Jcond;in;dry"]
["Operation factor of the heat rejection device, else","fop;hr;wet","-",{"$f":"IF(Product_descriptive_data!C25=\"OTHER\",0,\"-\")","v":"-"},"Formula (13h)","fop;hr;wet = 0"]
["Condenser inlet temperature from the heat rejection device, else","Jcond;in","°C",{"$f":"IF(Method_input!D25=\"OTHER\",MAX(Method_input!D57,Method_input!D19),\"-\")","v":"-"},"Formula (14h)","Jcond;in = max(Jcond;in;lim ; Jsk)"]
["Energy calculations"]
["Heat extracted by the cooling generation system","QC;gen;in","kWh",{"$f":"Method_input!D20*((1-IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12))))*(IF(Method_input!D24=\"COMP\",IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40)))+IF(Method_input!E24=\"COMP\",IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41))))+(1-IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12))))*(IF(Method_input!D24=\"OTHER\",IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40)))+IF(Method_input!E24=\"OTHER\",IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41))))+IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12)))*Method_input!D9)+IF(Method_input!D24=\"ABS\",MIN(IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40)),Method_input!D12*D74))+IF(Method_input!E24=\"ABS\",MIN(IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41)),Method_input!D12*D75))","v":7.6207719999999997},"Formula (15)",null,"Method output"]
["Total heat potentially recoverable or to be rejected ","QC;gen;out","kWh",{"$f":"D64+D77+Method_input!D12+Method_input!D20*((1-IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12))))*(IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40))+IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41)))+IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12)))*Method_input!D9)","v":7.6207719999999997},"Formula (16)"]
["Heat potentially recoverable","QC;gen;out;rbl","kWh",{"$f":"D64+D77+Method_input!D12+Method_input!D20*(1-IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12))))*(IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40))+IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41)))","v":0},"Formula (17)",null,"Method output"]
["Required electrical energy for the compression chillers","EC;gen;el;in","kWh",{"$f":"Method_input!D20*(1-IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12))))*(IF(Method_input!D24=\"COMP\",IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40))/D65,0)+IF(Method_input!E24=\"COMP\",IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41))/D66,0))","v":0},"Formula (18)",null,"Method output"]
["Energy efficiency ratio for generator j =1","EERj","-",{"$f":"Method_input!D30*(IF(D67<>\"-\",D67,IF(D69<>\"-\",D69,D71)))","v":9.9612475816827448},"Formula (19)","EERj = EERn;j × fEER;j"]
["Energy efficiency ratio for generator j =2","EERj","-",{"$f":"Method_input!E30*IF(D68<>\"-\",D68,IF(D70<>\"-\",D70,D72))","v":8.8301808098445047},"Formula (19)","EERj = EERn;j × fEER;j"]
["factor for the calculation of the EER based on EN 14825 data if fC;PL;j > fC;PL;j;min,  for generator j =1","fEER;j","-",{"$f":"IF(AND(Product_tech_data!C4=14825,D42>Method_input!D53),(Method_input!$D$78+D8)/(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8+D42/100*Product_tech_data!D36)*(Product_tech_data!D32*(D42/100)^3+Product_tech_data!D33*(D42/100)^2+Product_tech_data!D34*D42/100+Product_tech_data!D35),\"-\")","v":"-"},"Formula (20a)"]
["factor for the calculation of the EER based on EN 14825 data if fC;PL;j > fC;PL;j;min,  for generator j =2","fEER;j","-",{"$f":"IF(AND(Product_tech_data!C4=14825,D42>Method_input!E53),(Method_input!$D$78+D8)/(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8+D42/100*Product_tech_data!DE6)*(Product_tech_data!E32*(D42/100)^3+Product_tech_data!E33*(D42/100)^2+Product_tech_data!E34*D42/100+Product_tech_data!E35),\"-\")","v":"-"},"Formula (20a)"]
["factor for the calculation of the EER based on EN 14825 data, else, for generator j =1","fEER;j","-",{"$f":"IF(AND(Product_tech_data!C4=14825,D42<=Method_input!D53),(Method_input!$D$78+D8)/(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8+Method_input!D53/100*Product_tech_data!D36)*(Product_tech_data!D32*(Method_input!D53/100)^3+Product_tech_data!D33*(Method_input!D53/100)^2+Product_tech_data!D34*Method_input!D53/100+Product_tech_data!D35),\"-\")","v":3.5198754705592736},"Formula (20b)"]
["factor for the calculation of the EER based on EN 14825 data, else, for generator j =2","fEER;j","-",{"$f":"IF(AND(Product_tech_data!C4=14825,D42<=Method_input!E53),(Method_input!$D$78+D8)/(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8+Method_input!D53/100*Product_tech_data!E36)*(Product_tech_data!E32*(Method_input!D53/100)^3+Product_tech_data!E33*(Method_input!D53/100)^2+Product_tech_data!E34*Method_input!D53/100+Product_tech_data!E35),\"-\")","v":2.2075452024611262},"Formula (20b)"]
["factor for the calculation of the EER based on nominal EER from EN 14511 or default value, for generator j =1","fEER;j","-",{"$f":"IF(Product_tech_data!C4=14511,(Method_input!D78+D8)/(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8)/((Method_input!D78+Method_input!D32)/(Method_input!D31-Method_input!D32)),\"-\")","v":"-"},"Formula (20c)"]
["factor for the calculation of the EER based on nominal EER from EN 14511 or default value, for generator j =2","fEER;j","-",{"$f":"IF(Product_tech_data!C4=14511,(Method_input!D78+D8)/(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8)/((Method_input!D78+Method_input!E32)/(Method_input!E31-Method_input!E32)),\"-\")","v":"-"},"Formula (20c)"]
["Required heat input for the absorption chillers","QH;C;gen;abs;in;req","kWh",{"$f":"(1-IF(D9<>\"-\",D9,IF(D10<>\"-\",D10,IF(D11<>\"-\",D11,D12))))*(IF(Method_input!D24=\"ABS\",IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40))/D74,0)+IF(Method_input!E24=\"ABS\",IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41))/D75,0))","v":0},"Formula (21)",null,"Method output"]
["Heat ratio for generator k=1","zk","kWh",{"$f":"Method_input!D54*D76^2+Method_input!D55*D76+Method_input!D56","v":0.61042940339458696},"Formula (22)"]
["Heat ratio for generator k=2","zk","kWh",{"$f":"Method_input!E54*D76^2+Method_input!E55*D76+Method_input!E56","v":0.61042940339458696},"Formula (22)"]
["Carnot heat ratio ","zc","kWh",{"$f":"(Method_input!$D$78+D8)*(Method_input!D13-IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59))))))))/((Method_input!$D$78+Method_input!D13)*(IF(D45<>\"-\",D45,IF(D47<>\"-\",D47,IF(D49<>\"-\",D49,IF(D51<>\"-\",D51,IF(D53<>\"-\",D53,IF(D55<>\"-\",D55,IF(D57<>\"-\",D57,D59)))))))-D8))","v":8.6857229280096817},"Formula (23)"]
["Required electrical energy for the generators 1..n of type OTHER","EC;gen;el;in","kWh",{"$f":"Method_input!D20*IF(Method_input!D24=\"OTHER\",IF(Method_input!D17<Method_input!D18,IF(D39<>\"-\",D39,D41),IF(D38<>\"-\",D38,D40)),0)*0.1+IF(Method_input!E24=\"OTHER\",IF(Method_input!D17<Method_input!D18,IF(D38<>\"-\",D38,D40),IF(D39<>\"-\",D39,D41)),0)*0.1","v":0},"Formula (24)",null,"Method output"]
["Auxiliary electrical energy demand","WC;aux;gen","kWh",{"$f":"IF(D79<>\"-\",D79)+IF(D80<>\"-\",D80)+D82+Method_input!D16","v":0.84051929999999997},"Formula (25)",null,"Method output"]
["Auxiliary electrical energy demand for the heat rejection if HEAT_REC_TYPE = OTHER","Whr","kWh",{"$f":"IF(Method_input!D25=\"OTHER\",D81*(1-IF(OR(D48=1,D50=1,D54=1),1,0))*Method_input!D60,\"-\")","v":"-"},"Formula (26a)"]
["Auxiliary electrical energy demand for the heat rejection","Whr","kWh",{"$f":"IF(Method_input!D25<>\"OTHER\",D81*((1-IF(OR(D48=1,D50=1,D54=1),1,0))*Method_input!D58+IF(OR(D48=1,D50=1,D54=1),1,0)*Method_input!D59),\"-\")","v":0.24051929999999999},"Formula (26b)"]
["Heat input to the rejection system ","Qhr","kWh",{"$f":"D62-Method_input!D11+Method_input!D15","v":9.6207719999999988},"Formula (27)"]
["Auxiliary energy consumption of the control components","WC;ctrl","kWh",{"$f":"Method_input!D61*Method_input!D21*Method_in","v":0.1},"Formula (28)"]

{"sheet":"Method_output","index":9,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["THIS IS A MANDATORY SHEET\nOutput of one step calculation shall be indicated here.\nEach cell in the column value shall be a reference to a single cell in the \"Method_calculation\" sheet.\nThe macro will take the calculation step results and fill the values table in the \"Output_series\" sheet."]
[]
[]
[]
[]
[]
[]
[]
["Name","Symbol","Unit","Value","Intended destination","Notes"]
["Energy flow data"]
["Cooling generation electrical energy input","EC,gen,el,in","kWh",{"$f":"Method_calculation!D64+Method_calculation!D77","v":0},"M4-1, M4-4"]
["Generation system auxiliary energy input","WC;aux;gen","kWh",{"$f":"Method_calculation!D78","v":0.84051929999999997},"M4-1, M4-4"]
["Absorption cooling generation heat input","QH;C;gen;abs;in","kWh",{"$f":"Method_input!D12","v":0},"M4-4"]
["Operation conditions data"]
["Cooling energy extracted by generation system","QC;gen;in","kWh",{"$f":"Method_calculation!D61","v":7.6207719999999997},"M4-1"]
["Distribution inlet temperature from the cooling generation","ϑC;gen;out","°C",{"$f":"Method_calculation!D7","v":14},"M4-1"]
["Required absorption cooling generation heat input","QH;C;gen;abs;in;req","kWh",{"$f":"Method_calculation!D73","v":0},"M3-1"]
["Required supply temperature of absorption generation heat input","ϑH;C;gen;abs;in;req","°C",{"$f":"Method_input!D70","v":90},"M3-1"]
["Recoverable heat of the cooling generation system","QC;gen;out;rbl","kWh",{"$f":"Method_calculation!D63","v":0},"M3-1"]
["Max. temperature level of recoverable heat","ϑC,gen;out;max","°C",{"$f":"Method_input!D71","v":40},"M3-1"]
["Required energy to be extracted by the generation system","QC;gen;in;req","kWh",{"$f":"Method_input!D9","v":7.6207719999999997},"M10-12"]
["Number of generators","ngen","-",{"$f":"Method_input!D66","v":2},"M10-12"]
["Maximum heat extraction of generator j=1 at the current calculation interval","QC;gen;in;j;max","kWh",{"$f":"IF(Method_calculation!D14<>0,Method_calculation!D14,IF(Method_calculation!D15<>0,Method_calculation!D15,Method_calculation!D16))","v":392.91153548694081},"M10-12"]
["Maximum heat extraction of generator j=2 at the current calculation interval","QC;gen;in;j;max","kWh",{"$f":"IF(Method_calculation!D17<>0,Method_calculation!D17,IF(Method_calculation!D18<>0,Method_calculation!D18,Method_calculation!D19))","v":70.07516907440845},"M10-12"]
[]
[]
[null,null,null,{"$f":"Method_calculation!D11","v":1}]
[null,null,null,{"$f":"Method_calculation!D50","v":"-"}]
[null,null,null,{"$f":"Method_calculation!D52","v":0}]

{"sheet":"Output_series","index":10,"n_rows":89,"n_cols":20,"rows_kept":89,"cut":false,"hidden":false,"merged":[[6,0,6,5],[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,19]
[]
["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,"Cooling generation electrical energy input","Generation system auxiliary energy input","Absorption cooling generation heat input",null,"Cooling energy extracted by generation system","Distribution inlet temperature from the cooling generation","Required absorption cooling generation heat input","required supply temperature of absorption generation heat input","Recoverable heat of the cooling generation system","Max. temperature level of recoverable heat","Required energy to be extracted by the generation system","Number of generators","Maximum heat extraction of generator j=1 at the current time step","Maximum heat extraction of generator j=2 at the current time step"]
[null,"EC,gen,el,in","WC;aux;gen","QH;C;gen;abs;in",null,"QC;gen;in","ϑC;gen;out","QH;C;gen;abs;in;req","ϑH;C;gen;abs;in;req","QC;gen;out;rbl","ϑC,gen;out;max","QC;gen;in;req","ngen","QC;gen;in;j;max","QC;gen;in;j;max"]
["Symbol","kWh","kWh","kWh",null,"kWh","°C","kWh","°C","kWh","°C","kWh","-","kWh","kWh"]
["Destination","M4-1, M4-4","M4-1, M4-4","M4-4",null,"M4-1","M4-1","M3-1","M3-1","M3-1","M3-1","M10-12","M10-12","M10-12","M10-12"]
["Time stamp","VALUES"]
[1,0.93359697225915006,1.1869011032725691,12.864532158643614,null,7.6779149999999996,14,0,90,21.476044130902764,40,7.6779149999999996,2,327.42627957245082,68.334993691162239,null,null,0,"-",0]
[2,0,0.84144657499999997,0,null,7.6578629999999999,14,0,90,0,40,7.6578629999999999,2,374.20146236851508,69.631868879412409,null,null,1,"-",0]
[3,0,0.841458225,0,null,7.6583290000000002,14,0,90,0,40,7.6583290000000002,2,392.91153548694081,70.07516907440845,null,null,1,"-",0]
[4,0,0.84138072500000005,0,null,7.6552290000000003,14,0,90,0,40,7.6552290000000003,2,392.91153548694081,70.07516907440845,null,null,1,"-",0]
[5,0,0.84139222499999999,0,null,7.6556890000000006,14,0,90,0,40,7.6556890000000006,2,392.91153548694081,70.07516907440845,null,null,1,"-",0]
[6,0.96597625899492201,1.1917801484680259,13.02465167972611,null,7.6805780000000006,14,0,90,21.671205938721034,40,7.6805780000000006,2,302.23964268226234,67.496918820083749,null,null,0,"-",0]
[7,3.6229587149043763,2.4775165229174951,44.533992201795414,null,24.943709999999999,14,0,90,73.100660916699795,40,24.943709999999999,2,222.40275593600447,63.842993368194847,null,null,0,"-",0]
[8,1.3339479023510659,1.2701068321418973,15.233012383324832,null,8.2373130000000003,14,0,90,24.804273285675897,40,8.2373130000000003,2,181.34378560935752,61.011966644245604,null,null,0,"-",0]
[9,5.7460753572490795,3.1652565367655159,62.058716113371553,null,32.80547,14,0,90,100.61026147062063,40,32.80547,2,158.21941026319786,58.942761424609273,null,null,0,"-",0]
[10,7.3557339754295032,5.8211817285826779,94.578854163439516,null,54.28304,14,0,90,156.21762813886903,40,54.28304,2,256.24665357843992,65.619129308185535,null,null,0,1,"-"]
[11,16.805340111672031,7.247803817316484,99.107080413069951,null,83.536179999999987,14,0,90,199.44860052474195,40,83.536179999999987,2,235.74692129216473,64.592282764707946,null,null,0,1,"-"]
[12,14.673663980330213,8.4244466649822058,99.107080413069966,null,121.3237,14,0,90,235.10444439340017,40,121.3237,2,220.32422550669605,63.719798647322108,null,null,0,1,"-"]
[13,16.204481984493029,7.241254369119579,99.107080413069966,null,83.938570000000013,14,0,90,199.25013239756299,40,83.938570000000013,2,226.6797320116969,64.090817452204632,null,null,0,1,"-"]
[14,13.120510501536092,7.5585965101819994,99.107080413069951,null,96.63897,14,0,90,208.86656091460605,40,96.63897,2,235.74692129216473,64.592282764707946,null,null,0,1,"-"]
[15,14.129965973456777,8.589384030755383,99.107080413069966,null,126.8655,14,0,90,240.10254638652674,40,126.8655,2,248.15465399175233,65.230258556168536,null,null,0,1,"-"]
[16,17.391368498763367,7.2614047140905003,99.107080413069966,null,83.362300000000005,14,0,90,199.86074891183335,40,83.362300000000005,2,245.56970967933819,65.101657183097146,null,null,0,1,"-"]
[17,8.931248294194214,6.3733027673397187,99.107080413069966,null,64.910240000000002,14,0,90,172.9485687072642,40,64.910240000000002,2,248.15465399175233,65.230258556168536,null,null,0,1,"-"]
[18,7.0853550396130682,5.3014186755537551,85.740707552924974,null,47.641169999999995,14,0,90,140.46723259253804,40,47.641169999999995,2,212.38461377672496,63.231737804423418,null,null,0,1,"-"]
[19,5.5898547715696809,4.3487165747608767,68.067127190881138,null,37.940489999999997,14,0,90,111.59747196245081,40,37.940489999999997,2,216.28157916712365,63.474830059258053,null,null,0,1,"-"]
[20,1.2440074205971301,1.5062686490664747,15.486534914750589,null,8.7321439999999999,14,0,90,25.462686335347719,40,8.7321439999999999,2,231.1244326393772,64.340573028096784,null,null,0,1,"-"]
[21,1.3861241956286401,1.2720369238499354,15.322028758368772,null,8.1733239999999991,14,0,90,24.881476953997414,40,8.1733239999999991,2,167.19639807954951,59.796651153488455,null,null,0,"-",0]
[22,1.2421770007079036,1.242930485082842,14.531460402605775,null,7.9435820000000001,14,0,90,23.717219403313678,40,7.9435820000000001,2,193.23518138702033,61.927326376325695,null,null,0,"-",0]
[23,1.1549285305398644,1.2224117338513807,13.975924823515356,null,7.7656159999999996,14,0,90,22.89646935405522,40,7.7656159999999996,2,212.38461377672496,63.231737804423418,null,null,0,"-",0]
[24,1.0897093120724548,1.2116703617936573,13.652604159673837,null,7.7245010000000001,14,0,90,22.466814471746289,40,7.7245010000000001,2,235.74692129216473,64.592282764707946,null,null,0,"-",0]
[25,1.1247846393375149,1.2153621267686889,13.78258043141004,null,7.7071199999999997,14,0,90,22.614485070747556,40,7.7071199999999997,2,220.32422550669605,63.719798647322108,null,null,0,"-",0]
[26,1.0872515590557967,1.2104035587932862,13.621811792675652,null,7.7070789999999993,14,0,90,22.416142351731448,40,7.7070789999999993,2,235.74692129216473,64.592282764707946,null,null,0,"-",0]
[27,1.0643279452668086,1.2067058373487942,13.507525548684956,null,7.6963800000000004,14,0,90,22.268233493951765,40,7.6963800000000004,2,245.56970967933819,65.101657183097146,null,null,0,"-",0]
[28,1.0421877475342161,1.2033373642216283,13.40028382133092,null,7.6910230000000004,14,0,90,22.133494568865135,40,7.6910230000000004,2,256.24665357843992,65.619129308185535,null,null,0,"-",0]
[29,1.0204314696432795,1.2001061827617603,13.295481840827124,null,7.6883340000000002,14,0,90,22.004247310470404,40,7.6883340000000002,2,267.89422874109624,66.14489378534131,null,null,0,"-",0]
[30,1.0651262901026957,1.2071234184452335,13.517657447706645,null,7.702153,14,0,90,22.284936737809339,40,7.702153,2,245.56970967933819,65.101657183097146,null,null,0,"-",0]
[31,2.6017432546699628,1.913076240546967,30.904986367208704,null,17.01632,14,0,90,50.52304962187867,40,17.01632,2,201.49309512150836,62.51350591177286,null,null,0,"-",0]
[32,1.535401352330652,1.3368636935917242,16.922587391338315,null,9.0165589999999991,14,0,90,27.474547743668964,40,9.0165589999999991,2,166.01895865645409,59.688564403640029,null,null,0,"-",0]
[33,4.9132369163451637,3.7207576809610656,56.784857658232582,null,30.87032,14,0,90,92.568414574577744,40,30.87032,2,187.10073118425774,61.466238798159907,null,null,0,1,"-"]
[34,8.5664172535760574,5.871587278715519,96.952831798409377,null,52.225819999999999,14,0,90,157.74506905198544,40,52.225819999999999,2,177.25332427982315,60.67564474986586,null,null,0,1,"-"]
[35,15.088934074960765,7.2355269581050141,99.107080413069966,null,84.880560000000003,14,0,90,199.07657448803073,40,84.880560000000003,2,169.60210164903947,60.014003292077909,null,null,0,1,"-"]
[36,17.316497429060082,8.6755249687902918,99.107080413069966,null,126.2893,14,0,90,242.71287784213004,40,126.2893,2,168.39065806583204,59.905130070232907,null,null,0,1,"-"]
[37,14.952207153055596,7.4073098796821437,99.10708041306998,null,90.222830000000002,14,0,90,204.28211756612558,40,90.222830000000002,2,164.85798691759777,59.580867697915082,null,null,0,1,"-"]
[38,15.67306106045794,7.856747568626421,99.107080413069966,null,103.12130000000001,14,0,90,217.90144147352791,40,103.12130000000001,2,169.60210164903947,60.014003292077909,null,null,0,1,"-"]
[39,17.357013383783336,8.6889696952961586,99.107080413069966,null,126.65619999999998,14,0,90,243.12029379685328,40,126.6562,2,168.39065806583204,59.905130070232907,null,null,0,1,"-"]
[40,15.161382186084779,7.2164390357721073,99.107080413069966,null,84.229690000000005,14,0,90,198.49815259915476,40,84.229690000000005,2,173.34332447953295,60.343010404701687,null,null,0,1,"-"]
[41,74.912403396354904,8.5871881257110214,99.107080413069966,null,66.01652,14,0,90,240.03600380942487,40,66.01652,2,177.25332427982315,60.67564474986586,null,null,0,1,"-"]
[42,8.2482828335508245,5.4173501796147887,88.827235639624618,null,46.904789999999998,14,0,90,143.98030847317543,40,46.904789999999998,2,157.16461419477653,58.83773685758915,null,null,0,1,"-"]
[43,5.242945959157324,3.8113485063034207,58.639785140946323,null,31.430859999999999,14,0,90,95.31359110010365,40,31.430859999999999,2,172.07804473880645,60.232941281891883,null,null,0,1,"-"]
[44,1.3788218189314001,1.5065902809381395,15.651717936769794,null,8.4418930000000003,14,0,90,25.472432755701195,40,8.4418930000000003,2,178.59615249406423,60.787339303318532,null,null,0,1,"-"]
[45,1.28158603482651,1.4681203573919595,14.901762461899528,null,8.123329,14,0,90,24.306677496726039,40,8.123329,2,190.11848491303616,61.695921108954046,null,null,0,1,"-"]
[46,1.340367746000704,1.2496151686279051,14.773003999115499,null,7.8712349999999995,14,0,90,23.984606745116203,40,7.8712349999999995,2,166.01895865645409,59.688564403640029,null,null,0,"-",0]
[47,1.2634208751264355,1.2335127288011178,14.341742276918279,null,7.7353459999999998,14,0,90,23.340509152044714,40,7.7353459999999998,2,178.59615249406423,60.787339303318532,null,null,0,"-",0]
[48,1.2178813408304074,1.2274612116628663,14.161030125684247,null,7.7195369999999999,14,0,90,23.098448466514654,40,7.7195369999999999,2,190.11848491303616,61.695921108954046,null,null,0,"-",0]
[49,1.1109203512953147,1.2103777071169528,13.655611933382788,null,7.6485760000000003,14,0,90,22.415108284678105,40,7.6485760000000003,2,222.40275593600447,63.842993368194847,null,null,0,"-",0]
[50,1.0940894184400489,1.2078390515722779,13.576973644451058,null,7.6424989999999999,14,0,90,22.313562062891108,40,7.6424989999999999,2,228.88050610889778,64.215452395128736,null,null,0,"-",0]
[51,1.0503067881342913,1.2014153205389357,13.372920033423137,null,7.6333860000000007,14,0,90,22.05661282155743,40,7.6333860000000007,2,248.15465399175233,65.230258556168536,null,null,0,"-",0]
[52,1.0123969827160912,1.1957748571750355,13.190798304285336,null,7.6277989999999996,14,0,90,21.830994287001424,40,7.6277989999999996,2,267.89422874109624,66.14489378534131,null,null,0,"-",0]
[53,0.97855728401197384,1.1900603113654202,13.011649170604837,null,7.6122060000000005,14,0,90,21.602412454616811,40,7.6122060000000005,2,287.49624547824965,66.949529986714197,null,null,0,"-",0]
[54,0.93466163570998151,1.1829750738327138,12.78462031759857,null,7.5997209999999997,14,0,90,21.319002953308551,40,7.5997209999999997,2,318.57692066508736,68.053332499028855,null,null,0,"-",0]
[55,0.68322107020210776,1.0379668509030719,9.3114349659207729,null,5.5240179999999999,14,0,90,15.51867403612288,40,5.5240179999999999,2,314.32922838955284,67.913370819415306,null,null,0,"-",0]
[56,0.75698318709168066,1.0504013992924244,9.7013007846052979,null,5.5577719999999999,14,0,90,16.016055971696979,40,5.5577719999999999,2,253.49131321738139,65.488991577795872,null,null,0,"-",0]
[57,0.81997486546899934,1.0606985849715524,10.016083533393093,null,5.5918850000000004,14,0,90,16.427943398862094,40,5.5918850000000004,2,218.28418638163402,63.597078456500462,null,null,0,"-",0]
[58,0.94162022267204304,1.1025000327451724,11.082774087134849,null,6.0756069999999998,14,0,90,18.100001309806892,40,6.0756069999999998,2,196.45576774347063,62.16047406034324,null,null,0,"-",0]
[59,1.4750872501767585,1.3247092238674774,16.595931704522339,null,8.9173500000000008,14,0,90,26.988368954699098,40,8.9173500000000008,2,174.62734910530727,60.45348254258252,null,null,0,"-",0]
[60,3.1649038848683086,2.0396552057447472,34.280204344921586,null,18.141099999999998,14,0,90,55.586208229789889,40,18.141099999999998,2,159.28846033254379,59.048161596952148,null,null,0,"-",0]
[61,2.0056598014817379,2.0559329723115249,25.536851177655372,null,14.57667,14,0,90,42.119180979137113,40,14.57667,2,248.15465399175233,65.230258556168536,null,null,0,1,"-"]
[62,2.4644573881239697,2.3488706536650241,30.975533025967668,null,17.556090000000001,14,0,90,50.996080414091637,40,17.556090000000001,2,238.12820332541895,64.718877624482616,null,null,0,1,"-"]
[63,3.8007653952859641,3.2709048301320287,47.925344608714909,null,27.2104,14,0,90,78.936510004000866,40,27.2104,2,240.55808295118845,64.845969687003205,null,null,0,1,"-"]
[64,1.8960461674773184,1.9751009831088591,24.062970593397193,null,13.710709999999999,14,0,90,39.669726760874511,40,13.710709999999999,2,245.56970967933819,65.101657183097146,null,null,0,1,"-"]
[65,1.1603187182344599,1.4791960556968742,14.919192999852637,null,8.5627929999999992,14,0,90,24.642304718087097,40,8.5627929999999992,2,256.24665357843992,65.619129308185535,null,null,0,1,"-"]
[66,0.94690547742697329,1.1035087412137157,11.111034171121657,null,6.0824099999999994,14,0,90,18.140349648548629,40,6.0824099999999994,2,194.83216635716096,62.043681188573395,null,null,0,"-",0]
[67,0.76514310131020713,1.0532041101303757,9.773883303904821,null,5.5891380000000002,14,0,90,16.128164405215028,40,5.5891380000000002,2,250.79459711932418,65.359369011441743,null,null,0,"-",0]
[68,0.97919399069198065,1.1925730909832366,13.065129648637486,null,7.6586000000000007,14,0,90,21.702923639329466,40,7.6586000000000007,2,291.04558184217854,67.085543147913384,null,null,0,"-",0]
[69,0.92489620532412042,1.1841861265834979,12.792425858015797,null,7.6501229999999998,14,0,90,21.367445063339918,40,7.6501229999999998,2,332.03791731290778,68.476700411192823,null,null,0,"-",0]
[70,0.87540752534495248,1.1765958562837278,12.552226726004163,null,7.6361999999999997,14,0,90,21.063834251349114,40,7.6361999999999997,2,380.23696982607186,69.77901110605525,null,null,0,"-",0]
[71,0,0.84067837499999998,0,null,7.627135,14,0,90,0,40,7.627135,2,392.91153548694081,70.07516907440845,null,null,1,"-",0]
[72,0,0.84051929999999997,0,null,7.6207719999999997,14,0,90,0,40,7.6207719999999997,2,392.91153548694081,70.07516907440845,null,null,1,"-",0]

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

{"sheet":"History","index":12,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2014-10-14","1st complete version"]
[]
[null,"2014-10-24",null,"graphs added"]
[null,"2015-02-13",null,"disclaimer updated"]
[null,"2015-11-11","adapted to FV version"]
[null,null,"EN 14825 / 14511 / default added"]