{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Disclaimer","INFO","Product_descriptive_data","Product_tech_data","Process_design_data","Data_catalogue_example","Input_series","Method_input","Method_cal_stratification","Method_output","Output_series","History","Flowchart","fsto_bac_acc"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":45,"comments":5,"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":"Disclaimer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INFO","index":1,"n_rows":14,"n_cols":1,"rows_kept":14,"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 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":"Product_descriptive_data","index":2,"n_rows":48,"n_cols":3,"rows_kept":48,"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)"]
[]
["storage type"]
[3,"STO_H_TYPE",{"$f":"INDEX(C11:C14,A9)","v":"STO_H_ECH"}]
[]
["Storage only",null,"STO_H"]
["Storage with direct heating",null,"STO_H_DIR"]
["Storage with heat exhanger",null,"STO_H_ECH"]
["Storage with heat exhanger and additional back up",null,"STO_H_ECH_DIR"]
[]
[]
["Storage use"]
[1,"BLR_USE",{"$f":"INDEX(C20:C23,A18)","v":"STO_H_USE_H"}]
[]
["Heating",null,"STO_H_USE_H"]
["Domestic hot water",null,"STO_H_USE_W"]
["Heating + Domestic Hot Water",null,"STO_H_USE_H+W"]
["Cooling",null,"STO_C_USE"]
[]
[]
["Fuel"]
[1,"BLR_FUEL",{"$f":"INDEX(C29:C33,A27)","v":"STO_FUEL_HEX"}]
[]
["From heat exchanger",null,"STO_FUEL_HEX"]
["Heat exchanger (base + back up)",null,"STO_FUEL_HEX_HEX"]
["Heat Exchanger base + elctricity back up",null,"STO_FUEL_HEX_EL"]
["Electricity",null,"STO_FUEL_EL"]
["Electricity (base +  back-up)",null,"STO_FUEL_EL_EL"]
[]
[]
["CE Marking"]
[1,"STO_H_CE",{"$f":"INDEX(C39:C40,A37)","v":"STO_H_DATA_YES"}]
[]
["Storage unit is marked CE",null,"STO_H_DATA_YES"]
["Storage unit is NOT marked CE",null,"STO_H_DATA_NO"]
[]
[]
["Storage control type"]
[2,"STO_CTRL_POW",{"$f":"INDEX(C46:C48,A44)","v":"STO_CTRL_POW_CRM"}]
[]
["Single thermostatic control (ON-OFF)",null,"STO_H_CTRL_POW_ONOF"]
["Thermostat and external signal authorization ( e.g. cost rflctiv message for dirct electrical heating)",null,"STO_CTRL_POW_CRM"]
["Other",null,"STO_CTRL_POW_OTH"]

{"sheet":"Product_tech_data","index":3,"n_rows":150,"n_cols":9,"rows_kept":150,"cut":false,"hidden":false,"merged":[[0,0,0,3],[73,4,73,6],[73,7,73,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    Storage volume (nominal);","VSTO,H","l",250]
["Height","LSTO,H,HGT","m",1.52]
[]
["A.1.2.2      Standby losses","QSTO,H,STBL","W/K",{"$f":"INDEX(D17:D23,D25)","v":2.6436270774419355}]
[]
[]
["Base formula"]
[]
[]
["Data table","Standard",null,"Q_STO_STBL","C1","C2","C3","C4","C5"]
["Data",null,null,"W/K"]
["Unit"]
["Direct Electrical Horizontal","EN 60379",null,{"$f":"(E17+F17*POWER($D$5,G17))*1000/H17/I17","v":3.2768518518518519},0.93899999999999995,1.04E-2,1,45,24]
["Direct Electrical (Volume greater or equal to 75 liters)","EN 60379",null,{"$f":"(E18+F18*POWER($D$5,G18))*1000/H18/I18","v":2.6436270774419355},0.224,6.6299999999999998E-2,{"$f":"2/3","v":0.66666666666666663},45,24]
["Direct Electrical (Volume lower than 75 liters)","EN12977-3",null,{"$f":"(E19+F19*POWER($D$5,G19))*1000/H19/I19","v":2.7784753619563318},0.1474,7.1900000000000006E-2,{"$f":"2/3","v":0.66666666666666663},45,24]
["Solar storage ","EN 15332",null,{"$f":"(E20+F20*POWER($D$5,G20))*1000/H20/I20","v":2.5298221281347035},0,0.16,0.5,1000,1]
["Other","-",null,{"$f":"(E21+F21*POWER($D$5,G21))*1000/H21/I21","v":3.6467421222314282},0,0.189,0.55000000000000004,45,24]
["My storage",null,null,3.8]
["Default Storage",null,null,2.75]
["Last storage"]
["Your selection",null,null,2]
[null,null," "," "]
[]
["A.1.2.3. Caracterisation of the energy input"]
["Temperature set point","qSTO,H,VOL_1,set","°C",60]
["Direct Electrical Unit 1",null," "," "]
[" ",null,"Unit","Value"]
["Power","PSTO_H_EL1","kW",3]
["Altitude","zSTO,H,EL1","z",1.23]
[]
[]
["Heat Exchanger 1"]
["Transmission power","USTO_H_HEX1","W/K",200]
["Altitude min","zSTO,H,HEX1,min","m",0]
["Altitud max","zSTO,H,HEX1,max","m",0.35]
["Circulator power","PSTO H,aux,1","kW",0.06]
["Circulator mass flow","DVSTO,H,aux1","m3/h",0.2]
[]
["Direct Electrical Unit 2",null," "," "]
[" ",null,"Unit","Value"]
["Power","PSTO_H_EL2","kW",3]
["Altitude","zSTO,H,EL2","z",0]
["Temperature set point","qSTO,H,EL2,set","°C",60]
[]
["Heat Exchanger 2"]
["Transmission power","USTO_H_HEX2","W/K"]
["Altitude min","zSTO,H,HEX2,min","m",1.1000000000000001]
["Altitud max","zSTO,H,HEX2,max","m",1.4]
["Circulator power","PSTO H,aux,2","kW",0.06]
["Circulator mass flow","DVSTO,H,aux2","m3/h",0.3]
[]
[]
["A.1.3. Information for modeling the storage unit"]
[]
["Single volume fo the model",null," "," "]
[" ",null,"Unit","Value"]
["volume ","VSTO,H","-",1]
["Volume of part 1","VSTO,H,1","l",{"$f":"D5","v":250}]
["Temperature set point","qSTO_H_EL1_set","°C",60]
[]
["4 volumes considered ( Storage with heat exchanger in the lower part and direct electrical in the upper part",null,"Unit","Value"]
["Number of volume ","NVOLSTO,H","-",4]
["Altitude of layer 1","zSTO,H,VOL,1","m",{"$f":"D39","v":0.35}]
["Volume 1","VSTO,H,1","l",{"$f":"D$5*D67/$D6","v":57.565789473684212}]
["Altitude of layer 2","zSTO_H_VOL,2","m",{"$f":"D67+D70/$D$5","v":0.63947368421052631}]
["Volume 2","VSTO,H,2","l",{"$f":"(D$5-D$68-D$74)/2","v":72.368421052631575}]
["Altitude of layer 3","zSTO_H_VOL,3","m",{"$f":"D69+D72/$D$5","v":0.92894736842105263}]
["Volume 3","VSTO,H,3","l",{"$f":"(D$5-D$68-D$74)/2","v":72.368421052631575}]
["Altitude of layer 4","zSTO_H_VOL,3","m",{"$f":"D33","v":1.23}]
["Volume 4","VSTO,H,3","l",{"$f":"D$5*(D6-D73)/$D6","v":47.697368421052637}]
[]
[null,null,null,{"$f":"D74+D72+D70+D68","v":250},"Sum (for check)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["generator output at full load;"]
["generator efficiency at full load;"]
["generator output at intermediate load;"]
["generator efficiency at intermediate load;"]
["stand-by heat loss at test temperature difference Dθi,test;"]
["power consumption of auxiliary devices at full load;"]
["power consumption of auxiliary devices at intermediate load;"]
["stand-by power consumption of auxiliary devices;"]
["minimum operating boiler temperature."]
["Recoverable fraction of stand-by losses"]
[]
["correction factor of full-load efficiency;"]
["correction factor of intermediate load efficiency;"]
[]
["generator average water temperature at test conditions for full load;"]
["generator average water temperature at test conditions for intermediate load;"]
["difference between mean boiler temperature and test room temperature in test conditions;"]
[]
["part of the auxiliary energy recovered"]
["part of the nominal electrical power not transmitted to the distribution sub-system"]

{"sheet":"Process_design_data","index":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)"]
[]
["Storage location (installation position)"]
[3,"STO_H_LOC",{"$f":"INDEX(C11:C14,A9)","v":"STO_H_LOC_BLR"},null,"qi,amb "]
[null,null,null,null,"°C"]
["Heated space",null,"STO_H_LOC_INT",null,20]
["Unheated room",null,"STO_H_LOC_UNH",null,5]
["Storage (or boiler) room",null,"STO_H_LOC_BLR",null,15]
["External",null,"STO_H_LOC_EXT",null,-10]
["Selected value",null,null,null,{"$f":"INDEX(E11:E14,$A$9)","v":15},"°C"]
[]
[]
["Boiler hydraulic connection"]
[2,"STO_HCON",{"$f":"INDEX(C21:C24,A19)","v":"STO_HCON_HEX"},null,"to be suppressed"]
[]
["Direct connection",null,"STO_HCON_DIR"]
["Heat exchanger",null,"STO_HCON_HEX"]
[" ",null," "]
[" ",null," "]

{"sheet":"Data_catalogue_example","index":5,"n_rows":124,"n_cols":23,"rows_kept":124,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,9,0,20],[0,22,0,30]]}
["EXAMPLE OF A PRODUCT DATA CATALOGUE\nProduct descriptive data is used to filter the actual catalogue. Unsuitable prioducts are indicated by \"Non available\"\nThe desired product in the catalogue is then selected via the main list --> alla data is available with one click.\nNOTE: Default data are also part of the catalogue.\nThis sample catalogue is connected to the \"Method input\" sheet.\nNOTE: This highlights the high importance of the user interface and of a correct data input structuring.",null,null,null,null,null,null,null,null,"DATA FOR EACH BOILER",null,null,null,null,null,null,null,null,null,null,null,null,"SELECTION OF BOILERS COMPATIBLE WITH THE QUALITATIVE DESCRIPTION"]
[]
[]
[" Product descriptive data (qualitative)"]
[]
["Boiler use"]
[3,null,"STO_USE",{"$f":"INDEX(D9:D11,A7)","v":"STO_USE_H_DHW"}]
[]
["Heating",null,null,"STO_USE_H"]
["Domestic hot water",null,null,"STO_USE_DHW"]
["Heating + Domestic Hot water",null,null,"STO_USE_H_DHW"]
[]
[]
["Fuel for main"]
[4,null,"STO_FUEL",{"$f":"INDEX(D17:D21,A15)","v":"STO_FUEL_EL"}]
["Values"]
["Heat Echanger",null,null,"STO_FUEL_HEX"]
["Gas",null,null,"STO_FUEL_GAS"]
["Oil",null,null,"STO_FUEL_OIL"]
["Electricity",null,null,"STO_FUEL_EL"]
["Other ",null,null,"STO_FUEL_OTH"]
[]
[]
[]
["Fuel for Back-up"]
[1,null,"STO_FUEL_BKP",{"$f":"INDEX(D28:D33,A26)","v":"NO"}]
["Values"]
["No Back up",null,null,"NO"]
["Heat Echanger",null,null,"STO_FUEL_BKP_HEX"]
["Gas",null,null,"STO_FUEL_BKP_GAS"]
["Oil",null,null,"STO_FUEL_BKP_OIL"]
["Electricity",null,null,"STO_FUEL_BKP_EL"]
["Other ",null,null,"STO_FUEL_BKP_OTH"]
[]
[]
[" "]
["Storage unit is marked CE",null,"STO_H_DATA_YES"]
["Storage unit is NOT marked CE",null,"STO_H_DATA_NO"]
[]
[]
["Storage control type"]
[3,"STO_CTRL_POW",{"$f":"INDEX(C44:C46,A42)","v":"STO_CTRL_POW_OTH"}]
[]
["Single thermostatic control (ON-OFF)",null,"STO_H_CTRL_POW_ONOF"]
["Thermostat and external signal authorization ( e.g. cost reflctive message for direct electrical heating)",null,"STO_CTRL_POW_CRM"]
["Other",null,"STO_CTRL_POW_OTH"]
[" "]
[]
["Product technical data"]
[]
["Volume",null,null,null,"V_STO","l",200]
[]
[]
["System design data"]
[]
["Localisation",null,"LOC",{"$f":"INDEX(D59:D62,C57)","v":"LOC_BLR"}]
[null,null,3]
["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"]
["Heat exchanger"]
[" "]
[" "]
[]
[]
["Description",null,"Variable TAG","Option tag","Symbol","Unit","Value","Range",null," "," "," "," "," "," "," "," "," "," "," "," "]
["Volume",null,null,null,"ФPn ","l",200,"0-1000",null,{"$f":"+$G$51","v":200},200,200,200,200,200,200,200,200,45,30,{"$f":"+$G$51","v":200}]
["Height",null,null,null,null,"m",1.52,"0-5",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"]
["Use Type",null,null,null,null,null,{"$f":"INDEX(D9:D11,A7)","v":"STO_USE_H_DHW"}]
["Fuel type",null,null,null,null,null,{"$f":"INDEX(D17:D21,A15)","v":"STO_FUEL_EL"}]
["CE marking",null,null,null,null,null,{"$f":"INDEX(C37:C38,A35)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"C1"," ",0.224,null,null,0.224]
[null,null,null,null,"C2",null,6.6299999999999998E-2,null,null,6.6299999999999998E-2]
[null,null,null,null,"C3",null,{"$f":"2/3","v":0.66666666666666663},null,null,{"$f":"2/3","v":0.66666666666666663}]
[null,null,null,null,"C4",null,45,null,null,45]
[null,null,null,null,"C5"," ",24,null,null,24]
["Stanby losses transmission coefficient",null,null,null,"QSTO_STBL","W/K",{"$f":"1000/G83/G84*(G80+G81*POWER(G75,G82))","v":2.306877875271574}]
["Direct Electrical Unit 1",null," "," "," "," "," "]
[" ",null," "," "," "]
["Power",null,null,null,"PSTO,H,EL,1","kW",3]
["Altitude",null,null,null,"zSTO,H,EL1","z",0]
[]
["Temperature set point",null,null,null,"qSTO,H,set,1","°C",60]
[null,null,null,null,null," "]
[]
["Heat Exchanger 1"]
["Transmission power",null,null,null,"USTO_H_HEX1_U","W/K",200]
["Altitude min","to be changed into index to adress the correct volume",null,null,"zSTO_H_HEX1_min","m",0,null,null,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48]
["Altitud max","to be changed into index to adress the correct volume",null,null," "," ",0.35,null,null,{"$f":"(+J94+J95*J75^J96)/1000","v":0},0,0,{"$f":"(+M94+M95*M75^M96)/1000","v":0},{"$f":"(+N94+N95*N75^N96)/1000","v":0},{"$f":"(+O94+O95*O75^O96)/1000","v":0},0,0,0,0.3,0.4,0.6]
["Circulator power",null,null,null,"PSTO H,aux,1","kW",0,null,null,0,0,0,0,0,0,0,0,0]
["Circulator mass flow",null,null,null,"DVSTO,H,HX1","m3/h",0,null,null,15,15,15,15,15,15,15,15,15]
[null,null,null,null,null,null,null,null,null,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48]
[null,null,null,null,null,null,null,null,null,{"$f":"(+J98+J99*J86^J100)/1000","v":0},0,0,{"$f":"(+M98+M99*M86^M100)/1000","v":0},{"$f":"(+N98+N99*N86^N100)/1000","v":0},{"$f":"(+O98+O99*O86^O100)/1000","v":0},0,0,0,0.1,7.0000000000000007E-2,0.05]
[null,null,null,null,null,null,null,null,null,15,15,15,15,15,15,15,15,15]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(+J102+J103*J91^J104)/1000","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,50,30,0,50,30,0,50,50,50,50,50,50]
[null,null,null,null,null,null,null,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]
[]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[]
[null,null,null,null,null,null,null,null,null,70,70,70,70,70,70,70,70,70,70,70,70]
[null,null,null,null,null,null,null,null,null,50,40,30,50,40,30,50,50,50,50,50,50]
["part of the thermal losses energy recovered",null,null,null,"frvd,sto,stbl","-",1,"0 …. 1",null,50,50,50,50,50,50,50,50,50,50,50,50]
["part of the thermal losses not recovered",null,null,null,"frbl,sto,stbl","-",0,"0 …. 1"]
["part of the auxiliary energy recovered",null,null,null,"frvd,aux ","-",0.75,"0 …. 1",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 ","-",0.25,"0 …. 1",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]
["Reduction due to room location",null,null,null,"storm",null,0.7,"0 …..1"]
[]
[]
[]
["System design data"]
["Installation room temperature;",null,null,null,"qi,amb","°C",15]

{"sheet":"Input_series","index":6,"n_rows":108,"n_cols":17,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["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,79]
[]
["Description",null,"Calculation interval duration","Energy required for heating","Temperature required for heating","Energy required for DHW","Temperature required for DHW","Input from generation","Input temperature (to heat exchanger)","Output  water temperature (from heat exchanger)","Room temperature","Input temperature for DWH","Electrical power availability","Temperature layer 1","Temperature layer 2","Temperature Layer 3","Temperature Layer 4"]
["Symbol",null,"tci ","Esto,dis,H","qsto,dis,H","Esto,dis,W","qsto,dis,W ","Qgen,sto,in ","qsto,gen,in","qsto,gn,out ","qamb ","qsto,in,W ","E_El_ON","qsto,vol,1 ","qsto,vol_2","qsto,vol_3 ","qsto,vol_4 "]
["Unit",null,"h","kWh","°C","kWh","°C","kWh","°C","°C","°C","°C","Y/N","°C","°C","°C","°C"]
["Origin","15316-3-1","h","x","x","x",null," ","x","x","x",null,"1/0"]
["Origin","15316-3-3","h",null," ","x","x",null,null,null,"x","x","1/0"]
[]
[" "]
["Time stamp","Type of USE",null,null,"VALUES"]
[1,"STO_USE_DEL",1,0,40,0,40,3.4,50,40,15,12,1,65,65,65,65]
[2,"STO_USE_DEL",{"$f":"+C16","v":1},0,50,0,40,3.4,60,{"$f":"+I17-10","v":50},15,12,1,{"$f":"+Output_series!L18","v":65},{"$f":"+Output_series!K18","v":65},{"$f":"+Output_series!J18","v":65},{"$f":"+Output_series!I18","v":65}]
[3,"STO_USE_DEL",{"$f":"+C17","v":1},0,{"$f":"+E17","v":50},0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L19","v":65},{"$f":"+Output_series!K19","v":65},{"$f":"+Output_series!J19","v":65},{"$f":"+Output_series!I19","v":65}]
[4,"STO_USE_DEL",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L20","v":65},{"$f":"+Output_series!K20","v":65},{"$f":"+Output_series!J20","v":65},{"$f":"+Output_series!I20","v":65}]
[5,"STO_USE_SBY",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L21","v":65},{"$f":"+Output_series!K21","v":65},{"$f":"+Output_series!J21","v":65},{"$f":"+Output_series!I21","v":65}]
[6,"STO_USE_STO",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L22","v":65},{"$f":"+Output_series!K22","v":65},{"$f":"+Output_series!J22","v":65},{"$f":"+Output_series!I22","v":65}]
[7,"STO_USE_STO",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L23","v":65},{"$f":"+Output_series!K23","v":65},{"$f":"+Output_series!J23","v":65},{"$f":"+Output_series!I23","v":65}]
[8,"STO_USE_STO",1,0,50,1.61,40,3.4,60,50,15,12,0,{"$f":"+Output_series!L24","v":65},{"$f":"+Output_series!K24","v":65},{"$f":"+Output_series!J24","v":65},{"$f":"+Output_series!I24","v":65}]
[9,"STO_USE_DELSTO",1,0,50,0.42,40,3.4,0,0,15,12,0,{"$f":"+Output_series!L25","v":36.822976115629089},{"$f":"+Output_series!K25","v":64.581596805284263},{"$f":"+Output_series!J25","v":62.617543454601112},{"$f":"+Output_series!I25","v":62.617543454601112}]
[10,"STO_USE_DELSTO",{"$f":"+C24","v":1},0,50,0.21,40,3.4,60,{"$f":"+I25-10","v":50},15,12,0,{"$f":"+Output_series!L26","v":32.876140863065366},{"$f":"+Output_series!K26","v":60.214786294538669},{"$f":"+Output_series!J26","v":62.502878388979141},{"$f":"+Output_series!I26","v":61.981365163469285}]
[11,"STO_USE_DELSTO",1,0,50,0.105,40,3.4,55,{"$f":"+I26-10","v":45},15,12,0,{"$f":"+Output_series!L27","v":30.981117468151659},{"$f":"+Output_series!K27","v":57.851613953296443},{"$f":"+Output_series!J27","v":61.954387960227599},{"$f":"+Output_series!I27","v":61.648462560393362}]
[12,"STO_USE_DELSTO",1,0,50,0.21,40,3.4,50,{"$f":"+I27-10","v":40},15,12,0,{"$f":"+Output_series!L28","v":29.914571057316948},{"$f":"+Output_series!K28","v":56.497395059574522},{"$f":"+Output_series!J28","v":61.430354463973217},{"$f":"+Output_series!I28","v":61.285088012025241}]
[13,"STO_USE_DELSTO",1,0,50,0.315,40,3.4,0,0,15,12,0,{"$f":"+Output_series!L29","v":28.237728661787994},{"$f":"+Output_series!K29","v":54.183746379789632},{"$f":"+Output_series!J29","v":60.707195807584966},{"$f":"+Output_series!I29","v":60.554215680005349}]
[14,"STO_USE_DELSTO",{"$f":"+C28","v":1},0,60,0,40,3.4,60,{"$f":"+I29-10","v":50},15,12,0,{"$f":"+Output_series!L30","v":26.079633305498305},{"$f":"+Output_series!K30","v":50.939729813684231},{"$f":"+Output_series!J30","v":59.635691692778067},{"$f":"+Output_series!I30","v":59.484731265313989}]
[15,"STO_USE_DELSTO",1,0,60,0.105,40,3.4,55,{"$f":"+I30-10","v":45},15,12,0,{"$f":"+Output_series!L31","v":25.740927437073211},{"$f":"+Output_series!K31","v":50.601023945259143},{"$f":"+Output_series!J31","v":59.296985824352973},{"$f":"+Output_series!I31","v":59.259245717486955}]
[16,"STO_USE_DELSTO",1,0,60,0.105,40,3.4,50,{"$f":"+I31-10","v":40},15,12,0,{"$f":"+Output_series!L32","v":24.884495130074466},{"$f":"+Output_series!K32","v":49.31865318094183},{"$f":"+Output_series!J32","v":58.633809401246999},{"$f":"+Output_series!I32","v":58.618979991019835}]
[17,"STO_USE_DELSTO",1,0,50,0.105,40,3.4,0,0,15,12,0,{"$f":"+Output_series!L33","v":24.062706982063755},{"$f":"+Output_series!K33","v":48.048359455738108},{"$f":"+Output_series!J33","v":57.950628623763222},{"$f":"+Output_series!I33","v":57.962833675380089}]
[18,"STO_USE_DELSTO",{"$f":"+C32","v":1},0,60,0.105,40,3.4,60,{"$f":"+I33-10","v":50},15,12,0,{"$f":"+Output_series!L34","v":23.274619074412698},{"$f":"+Output_series!K34","v":46.790660756620738},{"$f":"+Output_series!J34","v":57.247634195108468},{"$f":"+Output_series!I34","v":57.336228075084883}]
[19,"STO_USE_DELSTO",{"$f":"+C33","v":1},0,{"$f":"+E33","v":60},0.21,40,3.4,55,{"$f":"+I34-10","v":45},15,12,0,{"$f":"+Output_series!L35","v":22.51976572036881},{"$f":"+Output_series!K35","v":45.546988701920583},{"$f":"+Output_series!J35","v":56.52543068007067},{"$f":"+Output_series!I35","v":56.738640688620755}]
[20,"STO_USE_DELSTO",1,0,60,0.105,40,3.4,55,{"$f":"+I35-10","v":45},15,12,0,{"$f":"+Output_series!L36","v":21.377104981829305},{"$f":"+Output_series!K36","v":43.39210183355155},{"$f":"+Output_series!J36","v":55.345649359500513},{"$f":"+Output_series!I36","v":55.901985677493663}]
[{"$f":"A35+1","v":21},"STO_USE_DELSTO",1,0,60,0.73499999999999999,40,3.4,55,{"$f":"+I36-10","v":45},15,12,0,{"$f":"+Output_series!L37","v":20.707076766243905},{"$f":"+Output_series!K37","v":42.200936775857812},{"$f":"+Output_series!J37","v":54.569378809739533},{"$f":"+Output_series!I37","v":55.375257683088783}]
[{"$f":"A36+1","v":22},"STO_USE_DELSTO",1,0,60,1.5049999999999999,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L38","v":17.917522142162383},{"$f":"+Output_series!K38","v":35.675625478545456},{"$f":"+Output_series!J38","v":50.710128276109714},{"$f":"+Output_series!I38","v":53.559119526385665}]
[23,"STO_USE_DELSTO",1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L39","v":14.045131416138352},{"$f":"+Output_series!K39","v":24.410328678084557},{"$f":"+Output_series!J39","v":41.145366494791375},{"$f":"+Output_series!I39","v":51.159245118450279}]
[24,"STO_USE_DELSTO",1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L40","v":45.752216317164326},{"$f":"+Output_series!K40","v":45.752216317164326},{"$f":"+Output_series!J40","v":45.752216317164326},{"$f":"+Output_series!I40","v":50.837622687552368}]
[25,"STO_USE_DELSTO",1,0,40,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L41","v":61.214593111063266},{"$f":"+Output_series!K41","v":61.214593111063266},{"$f":"+Output_series!J41","v":61.214593111063266},{"$f":"+Output_series!I41","v":61.214593111063266}]
[26,"STO_USE_DELSTO",1,0,50,0,40,3.4,60,{"$f":"+I41-10","v":50},15,12,1,{"$f":"+Output_series!L42","v":65},{"$f":"+Output_series!K42","v":65},{"$f":"+Output_series!J42","v":65},{"$f":"+Output_series!I42","v":65}]
[27,"STO_USE_DELSTO",1,0,{"$f":"+E41","v":50},0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L43","v":65},{"$f":"+Output_series!K43","v":65},{"$f":"+Output_series!J43","v":65},{"$f":"+Output_series!I43","v":65}]
[28,"STO_USE_DELSTO",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L44","v":65},{"$f":"+Output_series!K44","v":65},{"$f":"+Output_series!J44","v":65},{"$f":"+Output_series!I44","v":65}]
[29,"STO_USE_DELSTO",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L45","v":65},{"$f":"+Output_series!K45","v":65},{"$f":"+Output_series!J45","v":65},{"$f":"+Output_series!I45","v":65}]
[30,"STO_USE_DELSTO",1,0,50,0,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L46","v":65},{"$f":"+Output_series!K46","v":65},{"$f":"+Output_series!J46","v":65},{"$f":"+Output_series!I46","v":65}]
[31,"STO_USE_DELSTO",1,0,50,0.21,40,3.4,50,40,15,12,1,{"$f":"+Output_series!L47","v":65},{"$f":"+Output_series!K47","v":65},{"$f":"+Output_series!J47","v":65},{"$f":"+Output_series!I47","v":65}]
[32,null,1,0,50,0.105,40,3.4,60,50,15,12,0,{"$f":"+Output_series!L48","v":65},{"$f":"+Output_series!K48","v":65},{"$f":"+Output_series!J48","v":65},{"$f":"+Output_series!I48","v":65}]
[33,null,1,0,50,0.105,40,3.4,0,0,15,12,0,{"$f":"+Output_series!L49","v":62.697620309655541},{"$f":"+Output_series!K49","v":64.507965137241769},{"$f":"+Output_series!J49","v":64.379874701327651},{"$f":"+Output_series!I49","v":64.379874701327651}]
[34,null,1,0,50,0,40,3.4,60,{"$f":"+I49-10","v":50},15,12,0,{"$f":"+Output_series!L50","v":63.799386447068024},{"$f":"+Output_series!K50","v":63.799386447068024},{"$f":"+Output_series!J50","v":63.799386447068024},{"$f":"+Output_series!I50","v":63.799386447068024}]
[35,null,1,0,50,0.21,40,3.4,55,{"$f":"+I50-10","v":45},15,12,0,{"$f":"+Output_series!L51","v":63.314152718957821},{"$f":"+Output_series!K51","v":63.314152718957821},{"$f":"+Output_series!J51","v":63.314152718957821},{"$f":"+Output_series!I51","v":63.314152718957821}]
[36,null,1,0,50,0.315,50,3.4,50,{"$f":"+I51-10","v":40},15,12,0,{"$f":"+Output_series!L52","v":59.223222408854852},{"$f":"+Output_series!K52","v":62.843912064027265},{"$f":"+Output_series!J52","v":62.609052807552068},{"$f":"+Output_series!I52","v":62.609052807552068}]
[37,null,1,0,50,0,40,3.4,0,0,15,12,0,{"$f":"+Output_series!L53","v":53.705119683054058},{"$f":"+Output_series!K53","v":62.004949645818343},{"$f":"+Output_series!J53","v":61.839261546806199},{"$f":"+Output_series!I53","v":61.839261546806199}]
[38,null,1,0,60,0,40,3.4,60,{"$f":"+I53-10","v":50},15,12,0,{"$f":"+Output_series!L54","v":61.455538496048085},{"$f":"+Output_series!K54","v":61.455538496048085},{"$f":"+Output_series!J54","v":61.455538496048085},{"$f":"+Output_series!I54","v":61.455538496048085}]
[39,null,1,0,60,0,40,3.4,55,{"$f":"+I54-10","v":45},15,12,0,{"$f":"+Output_series!L55","v":60.993610677339639},{"$f":"+Output_series!K55","v":60.993610677339639},{"$f":"+Output_series!J55","v":60.993610677339639},{"$f":"+Output_series!I55","v":60.993610677339639}]
[40,null,1,0,60,0,40,3.4,50,{"$f":"+I55-10","v":40},15,12,0,{"$f":"+Output_series!L56","v":60.536276009773218},{"$f":"+Output_series!K56","v":60.536276009773218},{"$f":"+Output_series!J56","v":60.536276009773218},{"$f":"+Output_series!I56","v":60.536276009773218}]
[41,null,1,0,50,0,40,3.4,0,0,15,12,0,{"$f":"+Output_series!L57","v":60.083488821630091},{"$f":"+Output_series!K57","v":60.083488821630091},{"$f":"+Output_series!J57","v":60.083488821630091},{"$f":"+Output_series!I57","v":60.083488821630091}]
[42,null,1,0,60,0.21,40,3.4,60,{"$f":"+I57-10","v":50},15,12,0,{"$f":"+Output_series!L58","v":59.635203895325475},{"$f":"+Output_series!K58","v":59.635203895325475},{"$f":"+Output_series!J58","v":59.635203895325475},{"$f":"+Output_series!I58","v":59.635203895325475}]
[43,null,1,0,{"$f":"+E57","v":60},0,40,3.4,55,{"$f":"+I58-10","v":45},15,12,0,{"$f":"+Output_series!L59","v":55.580597605732443},{"$f":"+Output_series!K59","v":59.201287260904863},{"$f":"+Output_series!J59","v":59.018197443834168},{"$f":"+Output_series!I59","v":59.018197443834168}]
[44,null,1,0,60,0.42,50,3.4,55,{"$f":"+I59-10","v":45},15,12,0,{"$f":"+Output_series!L60","v":58.671139814797925},{"$f":"+Output_series!K60","v":58.671139814797925},{"$f":"+Output_series!J60","v":58.671139814797925},{"$f":"+Output_series!I60","v":58.671139814797925}]
[45,null,1,0,60,0.52500000000000002,40,3.4,55,{"$f":"+I60-10","v":45},15,12,0,{"$f":"+Output_series!L61","v":51.01519246692952},{"$f":"+Output_series!K61","v":58.256571777274345},{"$f":"+Output_series!J61","v":57.920223593465494},{"$f":"+Output_series!I61","v":57.920223593465494}]
[46,null,1,0,60,0,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L62","v":42.93849108270777},{"$f":"+Output_series!K62","v":56.443075773970982},{"$f":"+Output_series!J62","v":57.193556931371347},{"$f":"+Output_series!I62","v":57.193556931371347}]
[47,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L63","v":42.556243703977884},{"$f":"+Output_series!K63","v":56.060828395241103},{"$f":"+Output_series!J63","v":56.811309552641461},{"$f":"+Output_series!I63","v":56.811309552641461}]
[48,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L64","v":65},{"$f":"+Output_series!K64","v":65},{"$f":"+Output_series!J64","v":65},{"$f":"+Output_series!I64","v":65}]
[49,null,1,0,40,0,40,3.4,0,0,15,12,1,{"$f":"+Output_series!L65","v":65},{"$f":"+Output_series!K65","v":65},{"$f":"+Output_series!J65","v":65},{"$f":"+Output_series!I65","v":65}]
[50,null,1,0,50,0,40,3.4,60,{"$f":"+I65-10","v":50},15,12,1,{"$f":"+Output_series!L66","v":65},{"$f":"+Output_series!K66","v":65},{"$f":"+Output_series!J66","v":65},{"$f":"+Output_series!I66","v":65}]
[51,null,1,0,50,0,40,3.4,55,{"$f":"+I66-10","v":45},15,12,1,{"$f":"+Output_series!L67","v":65},{"$f":"+Output_series!K67","v":65},{"$f":"+Output_series!J67","v":65},{"$f":"+Output_series!I67","v":65}]
[52,null,1,0,50,0,40,3.4,55,{"$f":"+I67-10","v":45},15,12,1,{"$f":"+Output_series!L68","v":65},{"$f":"+Output_series!K68","v":65},{"$f":"+Output_series!J68","v":65},{"$f":"+Output_series!I68","v":65}]
[53,null,1,0,50,0,40,3.4,55,{"$f":"+I68-10","v":45},15,12,1,{"$f":"+Output_series!L69","v":65},{"$f":"+Output_series!K69","v":65},{"$f":"+Output_series!J69","v":65},{"$f":"+Output_series!I69","v":65}]
[54,null,1,0,50,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L70","v":65},{"$f":"+Output_series!K70","v":65},{"$f":"+Output_series!J70","v":65},{"$f":"+Output_series!I70","v":65}]
[55,null,1,0,50,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L71","v":65},{"$f":"+Output_series!K71","v":65},{"$f":"+Output_series!J71","v":65},{"$f":"+Output_series!I71","v":65}]
[56,null,1,0,50,1.915,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L72","v":65},{"$f":"+Output_series!K72","v":65},{"$f":"+Output_series!J72","v":65},{"$f":"+Output_series!I72","v":65}]
[57,null,1,0,50,3.92,40,3.4,55,{"$f":"+I72-10","v":45},15,12,0,{"$f":"+Output_series!L73","v":31.579277458367912},{"$f":"+Output_series!K73","v":64.596518837678261},{"$f":"+Output_series!J73","v":62.260393268387432},{"$f":"+Output_series!I73","v":62.260393268387432}]
[58,null,1,0,50,0.21,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L74","v":39.284486500757197},{"$f":"+Output_series!K74","v":39.284486500757197},{"$f":"+Output_series!J74","v":39.284486500757197},{"$f":"+Output_series!I74","v":39.284486500757197}]
[59,null,1,0,50,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L75","v":35.427791257027025},{"$f":"+Output_series!K75","v":39.048480912199437},{"$f":"+Output_series!J75","v":39.048480912199437},{"$f":"+Output_series!I75","v":40.470444593850253}]
[60,null,1,0,50,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L76","v":33.707202981040645},{"$f":"+Output_series!K76","v":38.587363095699224},{"$f":"+Output_series!J76","v":38.817591210610786},{"$f":"+Output_series!I76","v":40.845508946890092}]
[61,null,1,0,50,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L77","v":32.119020208268097},{"$f":"+Output_series!K77","v":38.055245933445576},{"$f":"+Output_series!J77","v":38.577303891258111},{"$f":"+Output_series!I77","v":41.194206825734398}]
[62,null,1,0,60,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L78","v":30.650578327472175},{"$f":"+Output_series!K78","v":37.466284998525133},{"$f":"+Output_series!J78","v":38.324077736591853},{"$f":"+Output_series!I78","v":41.519404573805119}]
[63,null,1,0,60,0.315,45,3.4,55,45,15,12,0,{"$f":"+Output_series!L79","v":29.290852236018463},{"$f":"+Output_series!K79","v":36.832359410085537},{"$f":"+Output_series!J79","v":38.055534811776731},{"$f":"+Output_series!I79","v":41.82355960666375}]
[64,null,1,0,60,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L80","v":25.936396791381014},{"$f":"+Output_series!K80","v":35.253313403962586},{"$f":"+Output_series!J80","v":37.627091824939761},{"$f":"+Output_series!I80","v":43.106838432405794}]
[65,null,1,0,50,0,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L81","v":24.924390856407157},{"$f":"+Output_series!K81","v":34.510150349501927},{"$f":"+Output_series!J81","v":37.288003081653486},{"$f":"+Output_series!I81","v":43.307063798855118}]
[66,null,1,0,60,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L82","v":24.72544847250499},{"$f":"+Output_series!K82","v":34.311207965599756},{"$f":"+Output_series!J82","v":37.089060697751314},{"$f":"+Output_series!I82","v":43.108121414952947}]
[67,null,1,0,60,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L83","v":23.790556135072997},{"$f":"+Output_series!K83","v":33.559030605658265},{"$f":"+Output_series!J83","v":36.73307115728511},{"$f":"+Output_series!I83","v":43.314864282552513}]
[68,null,1,0,60,0.105,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L84","v":22.919126123147688},{"$f":"+Output_series!K84","v":32.804499234877696},{"$f":"+Output_series!J84","v":36.359770860295178},{"$f":"+Output_series!I84","v":43.511533205353317}]
[69,null,1,0,60,0.73499999999999999,45,3.4,55,45,15,12,0,{"$f":"+Output_series!L85","v":22.106453680739541},{"$f":"+Output_series!K85","v":32.051216140649657},{"$f":"+Output_series!J85","v":35.970153551833945},{"$f":"+Output_series!I85","v":43.698930978319581}]
[70,null,1,0,60,3.71,40,3.4,55,45,15,12,0,{"$f":"+Output_series!L86","v":17.900190826213105},{"$f":"+Output_series!K86","v":27.909593259580497},{"$f":"+Output_series!J86","v":34.237499872739733},{"$f":"+Output_series!I86","v":46.051971879084235}]
[71,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L87","v":12.02983031735265},{"$f":"+Output_series!K87","v":12.02983031735265},{"$f":"+Output_series!J87","v":12.02983031735265},{"$f":"+Output_series!I87","v":12.02983031735265}]
[72,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L88","v":26.568813617900197},{"$f":"+Output_series!K88","v":26.568813617900197},{"$f":"+Output_series!J88","v":26.568813617900197},{"$f":"+Output_series!I88","v":26.568813617900197}]
[73,null,1,0,60,0,40,3.4,55,{"$f":"+I88-10","v":45},15,12,1,{"$f":"+Output_series!L89","v":40.963229423167675},{"$f":"+Output_series!K89","v":40.963229423167675},{"$f":"+Output_series!J89","v":40.963229423167675},{"$f":"+Output_series!I89","v":40.963229423167675}]
[74,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L90","v":55.214515231242792},{"$f":"+Output_series!K90","v":55.214515231242792},{"$f":"+Output_series!J90","v":55.214515231242792},{"$f":"+Output_series!I90","v":55.214515231242792}]
[75,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L91","v":65},{"$f":"+Output_series!K91","v":65},{"$f":"+Output_series!J91","v":65},{"$f":"+Output_series!I91","v":65}]
[76,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L92","v":65},{"$f":"+Output_series!K92","v":65},{"$f":"+Output_series!J92","v":65},{"$f":"+Output_series!I92","v":65}]
[77,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L93","v":65},{"$f":"+Output_series!K93","v":65},{"$f":"+Output_series!J93","v":65},{"$f":"+Output_series!I93","v":65}]
[78,null,1,0,60,0,40,3.4,55,45,15,12,1,{"$f":"+Output_series!L94","v":65},{"$f":"+Output_series!K94","v":65},{"$f":"+Output_series!J94","v":65},{"$f":"+Output_series!I94","v":65}]
[79,null,1,0,60,0,40,3.4,55,{"$f":"+I94-10","v":45},15,12,1,{"$f":"+Output_series!L95","v":65},{"$f":"+Output_series!K95","v":65},{"$f":"+Output_series!J95","v":65},{"$f":"+Output_series!I95","v":65}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]

{"sheet":"Method_input","index":7,"n_rows":60,"n_cols":8,"rows_kept":60,"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"]
["Energy use (storage, use for heating /DHW)","-","-",null,"0...∞","M3-6","YES"]
["Calculation interval","tci ","h",1,"0…8760","M1-9","Yes"]
["Energy required for heating","QH;sto;out","kWh",0,"0...∞","M3-6","Yes"]
["Temperature required for heating","θsto;out;H;min ","°C",60,"0…100","M3-6","YES"]
["Energy required for domestic hot water","QW;sto;out","kWh",0,"0...∞","M3-6","YES"]
["Temperature required for domestic hot water","qsto;out;W;min ","°C",40,"0-100","M3-6","YES"]
["Potential Input from generation","QX;sto;in ","kWh",3.4,"0...∞","M3-6","YES"]
["Temperature input from generation","qsto;gen;flw","°C",55,"0-100","M3-6","YES"]
["Temperature output to generation","qsto;gen;ret","°C",45,"0-100","M3-6","YES"]
["Ambient temperature ","qsto;amb","°C",15,"0-100","M1-9","NO"]
["Temperature input for DHW (cold water)","qsto;dhw;in","°C",12,"0-100","M3-6","NO"]
[" Availability of back-up","STO_BU_ON","-",1,"Y/N","Local","YES"]
["Temperature volume 1","qsto;vol,1","°C",65,"0-100","Local","YES"]
["Temperature volume 2","qsto;vol,2","°C",65,"0-100","Local","YES"]
["Temperature volume 3","qsto;vol,3","°C",65,"0-100","Local","YES"]
["Temperature volume 4 (output to generation)","qsto;vol,4","l",65,"0-100","Local","YES"]
[null," "," ",null," "," "," "]
[null," "," ",null," "," "," "]
[]
["Product data"]
["Product description data "]
[" "]
["Energy type (Main)","STO_FUEL_TYPE"," ",{"$f":"Data_catalogue_example!D15","v":"STO_FUEL_EL"}," "," "," ","STO_USE_DEL … STO_USE_SBY …"]
["Energy type (Back-up)","STO_FUEL_TYPE"," ",{"$f":"Data_catalogue_example!D26","v":"NO"}," "," "," "]
["Product technical data "," "," "," "," "," "," "]
["Volume (total)","Vsto;tot","l",{"$f":"Data_catalogue_example!G51","v":200},"0…100000","Local","NO"]
["Thermal losses coefficient (global)","Hsto;tot","W/K",{"$f":"Data_catalogue_example!G85","v":2.306877875271574},null,"Local"]
["Volume 4","Vsto;4","l",{"$f":"D$31/4","v":50},"0…100000","Local","NO"]
["Volume 3","Vsto;3","l",{"$f":"D$31/4","v":50},"0…100000","Local","NO"]
["Volume 2","Vsto;2","l",{"$f":"D$31/4","v":50},"0…100000","Local","NO"]
["Volume 1","Vsto;1","l",{"$f":"D$31/4","v":50},"0…100000","Local","NO"]
["Electrical heater power at volume 1","Φsto;el;1","kW",3,"0-10000","Local","No","To be modifed according to type of heating element"]
["Position","zsto;el,1;min","z",0,"0-100","Local","NO"]
["Altitud max","zsto;el,1;max","m",{"$f":"Data_catalogue_example!G97","v":0.35},"0-100","Local","NO"]
["Circulator power","Φsto;pmp,1","kW",{"$f":"Data_catalogue_example!G98","v":0},"0-100","Local","NO"]
["Circulator mass flow","V'sto;pmp,1","m3/h",{"$f":"Data_catalogue_example!G99","v":0},"0-500","Local","NO"]
[]
["part of the thermal losses recovable","fsto;rm",null,{"$f":"+Data_catalogue_example!G115","v":1},"0… 1","Local","NO","to be modifed according position of the storage in the heated space"]
["part of the auxiliary energy recovered","fsto;aux;rvd","-",{"$f":"+Data_catalogue_example!G117","v":0.75},"0…1","Local","NO"]
["part of the nominal electrical power not transmitted to the distribution sub-system","fsto;aux;nrvd","-",{"$f":"+Data_catalogue_example!G118","v":0.25},"0.1","Local","NO"]
[]
["System design data"]
["Process design"]
["storage room temperature;","qsto;amb","°C",{"$f":"+Data_catalogue_example!G124","v":15},"-50…+50","Local","Yes"]
[" "," ","-"]
["Control type data"]
["Control type","STO_CTRL_TYPE","°C",65,null,null,"YES"]
["Thermostat set","qsto;set;on","°C",65,null,null,"YES"]
[]
["Constants"]
["Water specific heat","Cp,w ","Wh/kg°C",1.1599999999999999,null,null,"NO"]
["Volumic mass","rW","kg/m3",1000,"0-10000","Local","NO"]
[]
["Model Information"]
["Number of layers for the storage model","Nsto;vol",null,4,null,null,"NO"]

{"sheet":"Method_cal_stratification","index":8,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,0,0,7],[25,7,28,7]]}
["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",null,null,"Formula","Notes","My notes"]
[null,null,null,null,null,"Formula ref"]
["Type of energy use",null,"-",{"$f":"+Method_input!D6","v":0}]
[]
["Single storage and multivolume calculation"]
["energy stored for DHW service","QW;sto;t0",null,null,null,"Formula (2)"]
["Energy required for DHW use","QW;sto;out","kWh",{"$f":"+_Q_W_sto_out","v":0},null,null,null,"LS: input copied here for convenience"]
["Step 1 - Domestic hot water use - Calculation of volume withdrawn for the storage unit for  DHW use"]
["Minimum temperature required for DHW use","qsto;out;W;min ","°C",{"$f":"+_θ_sto_out_W_min","v":40},null,null,null,"LS: input copied here for convenience  This should the temperature at usage and therefore about 40…60 °C according to tapping patterns (M243)"]
["Volume withdrawn from Volume 4","Vsto,4,use","l",{"$f":"IF(_V_sto_4*_Cp_W*(_θ_sto_vol_4-_θ_sto_dw_in)/1000<Method_cal_stratification!D$9,_V_sto_4,D$9*1000/_Cp_W/(_θ_sto_vol_4-_θ_sto_dw_in))","v":0},null,"Formula (4)","if","The volume withdrawn is adapted considering the energy to be used and condition on the minimum temperzature of the water used"]
["Energy withdrawn from Volume 4","Qsto,4,use","kWh",{"$f":"MIN(_V_sto_4*_Cp_W*(_θ_sto_vol_4-_θ_sto_dw_in)/1000,D$9)","v":0},null,null,null,"if the energy contained in volume 4 is lower than the energy need then volume 3 is sollicated with the energy demand reduced with energy already extracted from volume 4"]
["Volume withdrawn from Volume 3","Vsto,3,use","l",{"$f":"IF(_V_sto_3*_Cp_W*(Method_input!D$20-_θ_sto_dw_in)/1000<(Method_cal_stratification!D$9-D13),_V_sto_3,(D$9-D13)*1000/_Cp_W/(Method_input!D$20-_θ_sto_dw_in))","v":0}]
["Energy withdrawn from Volume 3","Qsto,3,use","kWh",{"$f":"MAX(0,D$9-D13)","v":0}]
["Volume withdrawn from Volume 2","Vsto,2,use","l",{"$f":"IF(Method_input!D$35*_Cp_W*(Method_input!D$19-_θ_sto_dw_in)/1000<(Method_cal_stratification!D$9-D$13-D$15),Method_input!D$35,(D$9-D$13-D$15)*1000/_Cp_W/(Method_input!D$19-_θ_sto_dw_in))","v":0},null,null," "]
["Energy withdrawn from Volume 2","Qsto,2,use","kWh",{"$f":"MAX(0,D$9-D13-D15)","v":0},null," "]
["Volume withdrawn from Volume 1","Vsto,1,use","l",{"$f":"IF(Method_input!D$36*_Cp_W*(Method_input!D$18-_θ_sto_dw_in)/1000<(Method_cal_stratification!D$9-D$13-D$15-D$17),Method_input!D$36,(D$9-D$13-D$15)*1000/_Cp_W/(Method_input!D$18-_θ_sto_dw_in))","v":0}]
["Energy withdrawn from Volume 1","Qsto,1,use","kWh",{"$f":"MAX(0,D$9-D$13-D$15-D$17)","v":0}]
["Total volume withdrawn","Vsto,use","l",{"$f":"D12+D14+D17+D19","v":0},null,null,null,"Sum of volume extraded"]
["Energy delivered by the storage unit","Qsto,W,del","l",{"$f":"D13+D15+D17+D19","v":0},null,"Formula (2)",null,"Need condition if the energy stored is not sufficient to correspond to the demand (output result)"]
[]
["Step 2 Volume to be withdrawn after energy delivery for heating service",null,null,null,null,null,"to be added; in most cases the energy is transfered to the distribution system without mass transfer (heat exchnager - just check whether sufficint energy is stored)"]
[]
["Step 3 Calculation of temperature of the storage unit after energy withdrawn  for DHW use"]
["Temperature of volume 4","qsto,vol,4","°C",{"$f":"IF(D$20<_V_sto_4,(_θ_sto_vol_4*(_V_sto_4-D$20)+_V_sto_3*D$20)/_V_sto_4,IF(D$20<_V_sto_4+_V_sto_3,((_θ_sto_vol_3*(_V_sto_4+_V_sto_3-D$20)+_θ_sto_vol_2*(D$20-_V_sto_4-_V_sto_3))/(_V_sto_4)),IF(D$20<_V_sto_4+_V_sto_3+_V_sto_2,IF(D$20<_V_sto_4+_V_sto_3+_V_sto_2+_V_sto_1,12,_θ_sto_dw_in))))","v":65},null,null,null,"The temperatures in the different volumes are calculated according to the volume extracted from the storage unit fromvolume 1 (input of cf water)to volume 4 (output of water). Temperature of volume i+1 consider the temperature of volume i and the volume used is reduced with the sum of the volumes below"]
["Temperature of volume 3","qsto,vol,3","°C",{"$f":"IF($D$20<_V_sto_3,(Method_input!$D$20*(_V_sto_3-$D$20)+_θ_sto_vol_2*$D$20)/_V_sto_3,IF($D$20<_V_sto_4+_V_sto_3,((Method_input!$D$19*(_V_sto_3+Method_input!$D$35-$D$20)+Method_input!$D$18*($D$20-_V_sto_3))/(_V_sto_3)),_θ_sto_dw_in))","v":65}]
["Temperature of volume 2","qsto,vol,2","°C",{"$f":"IF(D$20<_V_sto_2,(_θ_sto_vol_2*(_V_sto_2-D$20)+_θ_sto_vol_1*D$20)/_V_sto_2,IF(D$20<_V_sto_4+_V_sto_3,((_θ_sto_vol_1*(_V_sto_2+_V_sto_1-D$20)+_θ_sto_dw_in*(D$20-Method_input!D35))/(Method_input!D35)),12))","v":65}]
["Temperature of volume 1","qsto,vol,1","°C",{"$f":"IF(D$20<_V_sto_1,(_θ_sto_vol_1*(_V_sto_1-D$20)+_θ_sto_dw_in*D$20)/_V_sto_1,_θ_sto_dw_in)","v":65}]
[]
["Step 4 Temperatures in storage unit after energy input"]
["Step 4.0 - Energy input"]
["Temperature of volume 4","qsto,vol,4","°C",{"$f":"D$26","v":65}]
["Temperature of volume 3","qsto,vol,3","°C",{"$f":"D$27","v":65}]
["Temperature of volume 2","qsto,vol,2","°C",{"$f":"D$28","v":65},null,"Formula (9)",null,"in this calculation method the energy input is allocated to the volume 1"]
["Temperature of volume 1","qsto,vol,1","°C",{"$f":"D$29+Method_input!D$12*Method_input!D$17*1000/(_Cp_W*Method_input!D$36)","v":123.62068965517241},null,null,null,"The temperature could exced the set point  value"]
["Energy accumulation","Qsto;H;tmp1",null,{"$f":"_Cp_W/1000*(D36*Method_input!D$36+D35*Method_input!D$35+Method_cal_stratification!D34*_V_sto_3+Method_cal_stratification!D33*_V_sto_4)","v":18.48},null,"Formula (10)"]
[]
["Step 4.1 Condition for mixing volumes of the storage unit when the temperatur of the upper layer is lower than the temperature of volume below ",null,null,"Final","Iteration 2","Iteration 1","Formula (11)"]
["Temperature of volume 4","qsto,vol,4","°C",{"$f":"IF($E41>$E$40,(E$40*_V_sto_4+Method_cal_stratification!E$41*SUM(Method_input!D$34:D$36))/_V_sto_tot,E40)","v":79.655172413793082},{"$f":"F40","v":65},{"$f":"$D33","v":65},"           SI qsto,vol,i+1  <  qsto,vol,i"]
["Temperature of volume 3","qsto,vol,3","°C",{"$f":"IF($E42>$E$40,(E$40*_V_sto_4+Method_cal_stratification!E$41*SUM(Method_input!D$34:D$36))/_V_sto_tot,E41)","v":79.655172413793082},{"$f":"IF(F42>F41,(F41*Method_input!$D$34+Method_cal_stratification!$F$42*SUM(Method_input!$D$35:$D$36))/SUM(Method_input!$D$34:D$36),$F$41)","v":84.540229885057457},{"$f":"$D34","v":65}]
["Temperature of volume 2","qsto,vol,2","°C",{"$f":"IF($E43>$E$40,(E$40*_V_sto_4+Method_cal_stratification!E$41*SUM(Method_input!D$34:D$36))/_V_sto_tot,E42)","v":79.655172413793082},{"$f":"IF(F42>F41,(F41*Method_input!$D$34+Method_cal_stratification!F42*SUM(Method_input!$D$35:$D$36))/SUM(Method_input!$D$34:D$36),$F$42)","v":84.540229885057457},{"$f":"IF($D$36>$D$35,($D$36*Method_input!$D$36+Method_cal_stratification!$D$35*Method_input!$D$35)/(SUM(Method_input!$D$35:$D$36)),$D$35)","v":94.310344827586192}]
["Temperature of volume 1","qsto,vol,1","°C",{"$f":"IF($E43>$E$40,(E$40*_V_sto_4+Method_cal_stratification!E$41*SUM(Method_input!D$34:D$36))/_V_sto_tot,E43)","v":79.655172413793082},{"$f":"IF(F42>F41,(F41*Method_input!$D$34+Method_cal_stratification!$F$42*SUM(Method_input!$D$35:$D$36))/SUM(Method_input!$D$34:D$36),$F$43)","v":84.540229885057457},{"$f":"IF($D$36>$D$35,($D$36*Method_input!$D$36+$D$35*Method_input!$D$35)/(SUM(Method_input!$D$35:$D$36)),$D$36)","v":94.310344827586192},{"$f":"($D$36*Method_input!$D$36+$D$35*Method_input!$D$35)/1000","v":9.4310344827586192}]
["enrgy stored",null,null,{"$f":"_Cp_W/1000*(D43*Method_input!D$36+D42*Method_input!D$35+Method_cal_stratification!D41*_V_sto_3+Method_cal_stratification!D40*_V_sto_4)","v":18.479999999999993},null,"formula (10)"]
["Step 4.2 Thermal losses","Qsto,stbl","kWh",{"$f":"(Method_input!D$32/1000*(Method_input!D$36*(MIN(Method_cal_stratification!D$43,Method_input!D53)-Method_input!D$15)+Method_input!D$35*(MIN(Method_cal_stratification!D$42,Method_input!D53)-Method_input!D$15)+_V_sto_3*(MIN(Method_cal_stratification!D$41,Method_input!D53)-Method_input!D$15)+_V_sto_4*(MIN(Method_cal_stratification!D$40,Method_input!D53)-Method_input!D$15))/Method_input!D31)","v":0.1153438937635787},null,"Formula (12)"]
[null,null,null,null,null,null,{"$f":"_Cp_W/1000*(_V_sto_tot*Method_input!D53)","v":15.08}]
["Step 4.3  Limitation of the energy delivered due to temperature regulation","Energy surplus",null,{"$f":"IF(D43>Method_input!D53,D37-D45-_Cp_W/1000*(_V_sto_tot*Method_input!D53),0)","v":3.2846561062364206},null,"Formula (15)"," Qsto,gen,in +( Qsto,step8 - Qsto,step7) + Qsto,","thermostat is located on volume 1"]
["Adjustment of energy delivered to the storage according with the set temperature","Qsto,H,W","kWh",{"$f":"MIN(Method_input!D12-D47,Method_input!D12*Method_input!D17)","v":0.11534389376357934}]
["Temperature of volume 4","qsto,vol,4","°C",{"$f":"IF(D40>Method_input!D$53,Method_input!D$53,D40-1000*D$45/(Method_input!D$31*_Cp_W))","v":65},null,"Formula (13)","Temperature below the set point","Additionnal output"]
["Temperature of volume 3","qsto,vol,3","°C",{"$f":"IF(D41>Method_input!D$53,Method_input!D$53,D41-1000*D$45/(Method_input!D$31*_Cp_W))","v":65},null,null,null,"Additionnal output"]
["Temperature of volume 2","qsto,vol,2","°C",{"$f":"IF(D42>Method_input!D$53,Method_input!D$53,D42-1000*D$45/(Method_input!D$31*_Cp_W))","v":65},null,null,"Temperature above the set point   qsto,vol,i =qsto,set","Additionnal output"]
["Temperature of volume 1","qsto,vol,1","°C",{"$f":"IF(D43>Method_input!D$53,Method_input!D53,D43-1000*D$45/(Method_input!D$31*_Cp_W))","v":65},null,null,null,"Additionnal output"]
[null,null,null,null,null,null,null," "]
["Thermal losses","FSTO,H,ls","kWh",{"$f":"D45","v":0.1153438937635787},null,"formula (14)"]
["Time of operation for auxiliary energy","tsto,H,gen,aux","h",{"$f":"IF(_Vh_sto_pmp_1=0,0,Method_cal_stratification!D48/(_Cp_W*Method_cal_stratification!D41*(_θ_sto_gen_flw-_θ_sto_gen_ret)))","v":0},null,"formula (27)"]
["total auxiliary energy ","Wsto,aux","kWh",{"$f":"D55*_Φ_sto_pmp_1","v":0},null,"formula (29)",null,"Method output"]
[]
["Recovered auxiliary energy to the heating medium","Qsto,h,aux,rvd ","kWh",{"$f":"D$56*Method_input!D$45","v":0},null,"formula (30)"]
["recoverable auxiliary energy transmitted to the heated space ","Qsto,h,rbl,aux ","kWh",{"$f":"D$56*_f_sto_rm*(1-Method_input!D$44)","v":0},null,"formula (31)"]
["Recoverable heat losses (storage)","Qsto,h,rbl,env ","kWh",{"$f":"D45*Method_input!D43","v":0.1153438937635787},null,"formula (32)"]
["total recoverable heat losses ","Qsto,h,ls,rbl  ","kWh",{"$f":"+D60+D59","v":0.1153438937635787},null,"formula (33)",null,"Method output"]
["Fuel heat input ","QSTO,h,in ","kWh",{"$f":"D48","v":0.11534389376357934},null,"formula (14)",null,"Method output"]
[null,null," "," ",null," "," ","Method output"]
["Back up energy","Qsto,bu,in","kWh",{"$f":"0","v":0},null,"formula (15)",null,"Method output"]
[null,null," ",null,null," "]
["Energy delivered to DHW distribution system","Qsto,W,out","kWh",{"$f":"D21","v":0},null,null,null,"Method output"]
["Energy delivered to the heating distribution system","Qsto,H,out","kWh",0,null,null," see spredsheet Example_1vol","Method output"]
[]
["Energy type (Main)",null,"List",{"$f":"Method_input!D28","v":"STO_FUEL_EL"}]
["Energy type (Back-up)",null,"List",{"$f":"Method_input!D29","v":"NO"}]

{"sheet":"Method_output","index":9,"n_rows":24,"n_cols":6,"rows_kept":24,"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."]
[]
["Description","Unit",null,"Value"]
[]
[]
[]
[]
[]
["Name","Symbol","Unit","Value","Intended destination","Notes"]
["Energy flow data"]
["Input from generation unit","EH,gen,in ","kWh",{"$f":"+Method_cal_stratification!D62","v":0.11534389376357934},"M3-1","Fuel required from the generation unit "]
["Recoverable heat","QH,gen,ls,rbl  ","kWh",{"$f":"+Method_cal_stratification!D61","v":0.1153438937635787},"M2-2","Recoverable heat for heating "]
["Back up energy","QSTO,bkup,in","kWh",{"$f":"+Method_cal_stratification!D55","v":0},"M3-1","Energy from back up"]
["Total auxiliary energy ","Wsto,aux","kWh",{"$f":"+Method_cal_stratification!D56","v":0},"M3-1","storage auxiliary energy"]
["Operating condition data"]
["energy delivered to DHW distribution","Qsto,W,out",null,{"$f":"+Method_cal_stratification!D66","v":0},"M8-6"]
["energy delivered to Heating system","Qsto,H,out",null,{"$f":"Method_cal_stratification!D67","v":0},"M3-6"]
["Temperature 4","qsto,vol,4",null,{"$f":"+Method_cal_stratification!D49","v":65},"Local"]
["Temperature 3","qsto,vol,3",null,{"$f":"+Method_cal_stratification!D50","v":65},"Local"]
["Temperature 2","qsto,vol,2",null,{"$f":"+Method_cal_stratification!D51","v":65},"Local"]
["Temperature 1","qsto,vol,1",null,{"$f":"+Method_cal_stratification!D52","v":65},"Local"]
["Other data"]
["Back up energy","STO_FUEL","List",{"$f":"Method_cal_stratification!D69","v":"STO_FUEL_EL"},"M3-1","Needed to apply the right weighting factors"]
["Fuel type (generation)","STO_FUEL","List",{"$f":"Method_cal_stratification!D70","v":"NO"},"M3-1","Needed to apply the right weighting factors"]

{"sheet":"Output_series","index":10,"n_rows":98,"n_cols":16,"rows_kept":98,"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,13]
[]
["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,"Input from generation unit","Recoverable heat","Back up energy","Total auxiliary energy ","Operating condition data","Energy delivered to DHW system","Energy delivred to heating system","Temperature 4","Temperature 3","Temperature 2","Temperature 1","Other data","Back up energy","Fuel type (generation)","energy stored"]
[null,"EH,gen,in ","QH,gen,ls,rbl  ","WSTO,H,bkup","WH,gen,aux",null,null,null,null,null,null,null,"STO_ELEC","STO_FUEL",null,"(kWh)"]
["Symbol","ESTO,in","QSTO,rbl"," ","WSTO,aux"]
["Destination"]
["Time stamp",null,null,"VALUES"," "]
[1,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I18*[0]!_V_sto_4+J18*_V_sto_3+K18*_V_sto_2+L18*_V_sto_1)","v":15.08}]
[2,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I19*[0]!_V_sto_4+J19*_V_sto_3+K19*_V_sto_2+L19*_V_sto_1)","v":15.08}]
[3,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I20*[0]!_V_sto_4+J20*_V_sto_3+K20*_V_sto_2+L20*_V_sto_1)","v":15.08}]
[4,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I21*[0]!_V_sto_4+J21*_V_sto_3+K21*_V_sto_2+L21*_V_sto_1)","v":15.08}]
[5,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I22*[0]!_V_sto_4+J22*_V_sto_3+K22*_V_sto_2+L22*_V_sto_1)","v":15.08}]
[6,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I23*[0]!_V_sto_4+J23*_V_sto_3+K23*_V_sto_2+L23*_V_sto_1)","v":15.08}]
[7,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I24*[0]!_V_sto_4+J24*_V_sto_3+K24*_V_sto_2+L24*_V_sto_1)","v":15.08}]
[8,0,9.7069541174051394E-2,0,0,null,1.61,0,62.617543454601112,62.617543454601112,64.581596805284263,36.822976115629089,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I25*[0]!_V_sto_4+J25*_V_sto_3+K25*_V_sto_2+L25*_V_sto_1)","v":13.145100270146704}]
[9,0,9.1789370770686884E-2,0,0,null,0.42,0,61.981365163469285,62.502878388979141,60.214786294538669,32.876140863065366,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I26*[0]!_V_sto_4+J26*_V_sto_3+K26*_V_sto_2+L26*_V_sto_1)","v":12.619359901183044}]
[10,0,8.8795500499707775E-2,0,0,null,0.21,0,61.648462560393362,61.954387960227599,57.851613953296443,30.981117468151659,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I27*[0]!_V_sto_4+J27*_V_sto_3+K27*_V_sto_2+L27*_V_sto_1)","v":12.321263752640004}]
[11,0,8.6868451023872181E-2,0,0,null,0.105,0,61.285088012025241,61.430354463973217,56.497395059574522,29.914571057316948,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I28*[0]!_V_sto_4+J28*_V_sto_3+K28*_V_sto_2+L28*_V_sto_1)","v":12.129389698387616}]
[12,0,8.369695355936535E-2,0,0,null,0.21,0,60.554215680005349,60.707195807584966,54.183746379789632,28.237728661787994,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I29*[0]!_V_sto_4+J29*_V_sto_3+K29*_V_sto_2+L29*_V_sto_1)","v":11.81360741869174}]
[13,0,7.9303009760863061E-2,0,0,null,0.315,0,59.484731265313989,59.635691692778067,50.939729813684231,26.079633305498305,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I30*[0]!_V_sto_4+J30*_V_sto_3+K30*_V_sto_2+L30*_V_sto_1)","v":11.376107592481928}]
[{"$f":"A30+1","v":14},0,7.8579761474622173E-2,0,0,null,0,0,59.259245717486955,59.296985824352973,50.601023945259143,25.740927437073211,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I31*[0]!_V_sto_4+J31*_V_sto_3+K31*_V_sto_2+L31*_V_sto_1)","v":11.304094609601993}]
[15,0,7.6574613573210673E-2,0,0,null,0.105,0,58.618979991019835,58.633809401246999,49.31865318094183,24.884495130074466,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I32*[0]!_V_sto_4+J32*_V_sto_3+K32*_V_sto_2+L32*_V_sto_1)","v":11.104444386790421}]
[16,0,7.4575777916185693E-2,0,0,null,0.105,0,57.962833675380089,57.950628623763222,48.048359455738108,24.062706982063755,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I33*[0]!_V_sto_4+J33*_V_sto_3+K33*_V_sto_2+L33*_V_sto_1)","v":10.905422666742821}]
[17,0,7.2609575918724592E-2,0,0,null,0.105,0,57.336228075084883,57.247634195108468,46.790660756620738,23.274619074412698,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I34*[0]!_V_sto_4+J34*_V_sto_3+K34*_V_sto_2+L34*_V_sto_1)","v":10.709650241871154}]
[18,0,7.0676618050025605E-2,0,0,null,0.105,0,56.738640688620755,56.52543068007067,45.546988701920583,22.51976572036881,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I35*[0]!_V_sto_4+J35*_V_sto_3+K35*_V_sto_2+L35*_V_sto_1)","v":10.517187895876887}]
[19,0,6.7581160562578638E-2,0,0,null,0.21,0,55.901985677493663,55.345649359500513,43.39210183355155,21.377104981829305,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I36*[0]!_V_sto_4+J36*_V_sto_3+K36*_V_sto_2+L36*_V_sto_1)","v":10.208976827437752}]
[20,0,6.5737982004609924E-2,0,0,null,0.105,0,55.375257683088783,54.569378809739533,42.200936775857812,20.707076766243905,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I37*[0]!_V_sto_4+J37*_V_sto_3+K37*_V_sto_2+L37*_V_sto_1)","v":10.025453702025942}]
[{"$f":"A37+1","v":21},0,5.7005984239336262E-2,0,0,null,0.73499999999999999,0,53.559119526385665,50.710128276109714,35.675625478545456,17.917522142162383,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I38*[0]!_V_sto_4+J38*_V_sto_3+K38*_V_sto_2+L38*_V_sto_1)","v":9.1560189345457861}]
[{"$f":"A38+1","v":22},0,4.1218565262848915E-2,0,0,null,1.5049999999999999,0,51.159245118450279,41.145366494791375,24.410328678084557,14.045131416138352,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I39*[0]!_V_sto_4+J39*_V_sto_3+K39*_V_sto_2+L39*_V_sto_1)","v":7.584084159032944}]
[23,3.4,7.4616403968314648E-2,0,0,null,0,0,50.837622687552368,45.752216317164326,45.752216317164326,45.752216317164326,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I40*[0]!_V_sto_4+J40*_V_sto_3+K40*_V_sto_2+L40*_V_sto_1)","v":10.909467755064631}]
[24,3.4,0.10768215329795483,0,0,null,0,0,61.214593111063266,61.214593111063266,61.214593111063266,61.214593111063266,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I41*[0]!_V_sto_4+J41*_V_sto_3+K41*_V_sto_2+L41*_V_sto_1)","v":14.201785601766678}]
[25,0.99355829199690104,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I42*[0]!_V_sto_4+J42*_V_sto_3+K42*_V_sto_2+L42*_V_sto_1)","v":15.08}]
[26,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I43*[0]!_V_sto_4+J43*_V_sto_3+K43*_V_sto_2+L43*_V_sto_1)","v":15.08}]
[27,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I44*[0]!_V_sto_4+J44*_V_sto_3+K44*_V_sto_2+L44*_V_sto_1)","v":15.08}]
[28,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I45*[0]!_V_sto_4+J45*_V_sto_3+K45*_V_sto_2+L45*_V_sto_1)","v":15.08}]
[29,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I46*[0]!_V_sto_4+J46*_V_sto_3+K46*_V_sto_2+L46*_V_sto_1)","v":15.08}]
[30,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I47*[0]!_V_sto_4+J47*_V_sto_3+K47*_V_sto_2+L47*_V_sto_1)","v":15.08}]
[31,0.38477785602773151,0.1153438937635787,0,0,null,0.21,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I48*[0]!_V_sto_4+J48*_V_sto_3+K48*_V_sto_2+L48*_V_sto_1)","v":15.08}]
[32,0,0.11415208815991391,0,0,null,0.105,0,64.379874701327651,64.379874701327651,64.507965137241769,62.697620309655541,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I49*[0]!_V_sto_4+J49*_V_sto_3+K49*_V_sto_2+L49*_V_sto_1)","v":14.845989421274052}]
[33,0,0.11370484209632416,0,0,null,0.105,0,63.799386447068024,63.799386447068024,63.799386447068024,63.799386447068024,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I50*[0]!_V_sto_4+J50*_V_sto_3+K50*_V_sto_2+L50*_V_sto_1)","v":14.801457655719782}]
[34,0,0.11257422492156874,0,0,null,0,0,63.314152718957821,63.314152718957821,63.314152718957821,63.314152718957821,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I51*[0]!_V_sto_4+J51*_V_sto_3+K51*_V_sto_2+L51*_V_sto_1)","v":14.688883430798214}]
[35,0,0.10909583194388758,0,0,null,0.21,0,62.609052807552068,62.609052807552068,62.843912064027265,59.223222408854852,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I52*[0]!_V_sto_4+J52*_V_sto_3+K52*_V_sto_2+L52*_V_sto_1)","v":14.342543925103202}]
[36,0,0.10449594277893839,0,0,null,0.315,0,61.839261546806199,61.839261546806199,62.004949645818343,53.705119683054058,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I53*[0]!_V_sto_4+J53*_V_sto_3+K53*_V_sto_2+L53*_V_sto_1)","v":13.884538360504118}]
[37,0,0.10824356726128928,0,0,null,0,0,61.455538496048085,61.455538496048085,61.455538496048085,61.455538496048085,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I54*[0]!_V_sto_4+J54*_V_sto_3+K54*_V_sto_2+L54*_V_sto_1)","v":14.257684931083155}]
[38,0,0.10716725394036022,0,0,null,0,0,60.993610677339639,60.993610677339639,60.993610677339639,60.993610677339639,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I55*[0]!_V_sto_4+J55*_V_sto_3+K55*_V_sto_2+L55*_V_sto_1)","v":14.150517677142796}]
[39,0,0.10610164287540925,0,0,null,0,0,60.536276009773218,60.536276009773218,60.536276009773218,60.536276009773218,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I56*[0]!_V_sto_4+J56*_V_sto_3+K56*_V_sto_2+L56*_V_sto_1)","v":14.044416034267387}]
[40,0,0.10504662764920561,0,0,null,0,0,60.083488821630091,60.083488821630091,60.083488821630091,60.083488821630091,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I57*[0]!_V_sto_4+J57*_V_sto_3+K57*_V_sto_2+L57*_V_sto_1)","v":13.93936940661818}]
[41,0,0.10400210290267178,0,0,null,0,0,59.635203895325475,59.635203895325475,59.635203895325475,59.635203895325475,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I58*[0]!_V_sto_4+J58*_V_sto_3+K58*_V_sto_2+L58*_V_sto_1)","v":13.835367303715511}]
[42,0,0.1006686591855825,0,0,null,0.21,0,59.018197443834168,59.018197443834168,59.201287260904863,55.580597605732443,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I59*[0]!_V_sto_4+J59*_V_sto_3+K59*_V_sto_2+L59*_V_sto_1)","v":13.503460225749729}]
[43,0,0.10175578871661077,0,0,null,0,0,58.671139814797925,58.671139814797925,58.671139814797925,58.671139814797925,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I60*[0]!_V_sto_4+J60*_V_sto_3+K60*_V_sto_2+L60*_V_sto_1)","v":13.611704437033119}]
[44,0,9.6179784705469742E-2,0,0,null,0.42,0,57.920223593465494,57.920223593465494,58.256571777274345,51.01519246692952,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I61*[0]!_V_sto_4+J61*_V_sto_3+K61*_V_sto_2+L61*_V_sto_1)","v":13.056508263005822}]
[45,0,8.9572046051884277E-2,0,0,null,0.52500000000000002,0,57.193556931371347,57.193556931371347,56.443075773970982,42.93849108270777,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I62*[0]!_V_sto_4+J62*_V_sto_3+K62*_V_sto_2+L62*_V_sto_1)","v":12.398583481726446}]
[46,0,8.8681391865333026E-2,0,0,null,0,0,56.811309552641461,56.811309552641461,56.060828395241103,42.556243703977884,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I63*[0]!_V_sto_4+J63*_V_sto_3+K63*_V_sto_2+L63*_V_sto_1)","v":12.30990208986111}]
[47,2.8854418039024643,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I64*[0]!_V_sto_4+J64*_V_sto_3+K64*_V_sto_2+L64*_V_sto_1)","v":15.08}]
[48,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I65*[0]!_V_sto_4+J65*_V_sto_3+K65*_V_sto_2+L65*_V_sto_1)","v":15.08}]
[49,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I66*[0]!_V_sto_4+J66*_V_sto_3+K66*_V_sto_2+L66*_V_sto_1)","v":15.08}]
[50,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I67*[0]!_V_sto_4+J67*_V_sto_3+K67*_V_sto_2+L67*_V_sto_1)","v":15.08}]
[51,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I68*[0]!_V_sto_4+J68*_V_sto_3+K68*_V_sto_2+L68*_V_sto_1)","v":15.08}]
[52,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I69*[0]!_V_sto_4+J69*_V_sto_3+K69*_V_sto_2+L69*_V_sto_1)","v":15.08}]
[53,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I70*[0]!_V_sto_4+J70*_V_sto_3+K70*_V_sto_2+L70*_V_sto_1)","v":15.08}]
[54,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I71*[0]!_V_sto_4+J71*_V_sto_3+K71*_V_sto_2+L71*_V_sto_1)","v":15.08}]
[55,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I72*[0]!_V_sto_4+J72*_V_sto_3+K72*_V_sto_2+L72*_V_sto_1)","v":15.08}]
[56,0,9.3607629658644068E-2,0,0,null,1.915,0,62.260393268387432,62.260393268387432,64.596518837678261,31.579277458367912,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I73*[0]!_V_sto_4+J73*_V_sto_3+K73*_V_sto_2+L73*_V_sto_1)","v":12.80040180430362}]
[57,0,5.6583984021069907E-2,0,0,null,3.92,0,39.284486500757197,39.284486500757197,39.284486500757197,39.284486500757197,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I74*[0]!_V_sto_4+J74*_V_sto_3+K74*_V_sto_2+L74*_V_sto_1)","v":9.1140008681756708}]
[58,0,5.4753296545402515E-2,0,0,null,0.21,0,40.470444593850253,39.048480912199437,39.048480912199437,35.427791257027025,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I75*[0]!_V_sto_4+J75*_V_sto_3+K75*_V_sto_2+L75*_V_sto_1)","v":8.9317214651660155}]
[59,0,5.3566410768567378E-2,0,0,null,0.105,0,40.845508946890092,38.817591210610786,38.587363095699224,33.707202981040645,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I76*[0]!_V_sto_4+J76*_V_sto_3+K76*_V_sto_2+L76*_V_sto_1)","v":8.8135446415859633}]
[60,0,5.2394461793304321E-2,0,0,null,0.105,0,41.194206825734398,38.577303891258111,38.055245933445576,32.119020208268097,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I77*[0]!_V_sto_4+J77*_V_sto_3+K77*_V_sto_2+L77*_V_sto_1)","v":8.6968550578049584}]
[61,0,5.1237925000208795E-2,0,0,null,0.105,0,41.519404573805119,38.324077736591853,37.466284998525133,30.650578327472175,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I78*[0]!_V_sto_4+J78*_V_sto_3+K78*_V_sto_2+L78*_V_sto_1)","v":8.5817000469108695}]
[62,0,5.0097344162286631E-2,0,0,null,0.105,0,41.82355960666375,38.055534811776731,36.832359410085537,29.290852236018463,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I79*[0]!_V_sto_4+J79*_V_sto_3+K79*_V_sto_2+L79*_V_sto_1)","v":8.4681337517435793}]
[63,0,4.7721473976588949E-2,0,0,null,0.315,0,43.106838432405794,37.627091824939761,35.253313403962586,25.936396791381014,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I80*[0]!_V_sto_4+J80*_V_sto_3+K80*_V_sto_2+L80*_V_sto_1)","v":8.2315711462559715}]
[64,0,4.6618178080820742E-2,0,0,null,0.105,0,43.307063798855118,37.288003081653486,34.510150349501927,24.924390856407157,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I81*[0]!_V_sto_4+J81*_V_sto_3+K81*_V_sto_2+L81*_V_sto_1)","v":8.1217172690122261}]
[65,0,4.6154633065303013E-2,0,0,null,0,0,43.108121414952947,37.089060697751314,34.311207965599756,24.72544847250499,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I82*[0]!_V_sto_4+J82*_V_sto_3+K82*_V_sto_2+L82*_V_sto_1)","v":8.0755626359469233}]
[66,0,4.5084957408911649E-2,0,0,null,0.105,0,43.314864282552513,36.73307115728511,33.559030605658265,23.790556135072997,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I83*[0]!_V_sto_4+J83*_V_sto_3+K83*_V_sto_2+L83*_V_sto_1)","v":7.9690562864729966}]
[67,0,4.4034926149763322E-2,0,0,null,0.105,0,43.511533205353317,36.359770860295178,32.804499234877696,22.919126123147688,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I84*[0]!_V_sto_4+J84*_V_sto_3+K84*_V_sto_2+L84*_V_sto_1)","v":7.8645059065730845}]
[68,0,4.3004943592536898E-2,0,0,null,0.105,0,43.698930978319581,35.970153551833945,32.051216140649657,22.106453680739541,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I85*[0]!_V_sto_4+J85*_V_sto_3+K85*_V_sto_2+L85*_V_sto_1)","v":7.7619517523894785}]
[69,0,3.8503585776908905E-2,0,0,null,0.73499999999999999,0,46.051971879084235,34.237499872739733,27.909593259580497,17.900190826213105,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I86*[0]!_V_sto_4+J86*_V_sto_3+K86*_V_sto_2+L86*_V_sto_1)","v":7.3137568385818188}]
[70,0,-6.9206336258147228E-3,0,0,null,3.71,0,12.02983031735265,12.02983031735265,12.02983031735265,12.02983031735265,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I87*[0]!_V_sto_4+J87*_V_sto_3+K87*_V_sto_2+L87*_V_sto_1)","v":2.7909206336258148}]
[71,3.4,2.6955874272968049E-2,0,0,null,0,0,26.568813617900197,26.568813617900197,26.568813617900197,26.568813617900197,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I88*[0]!_V_sto_4+J88*_V_sto_3+K88*_V_sto_2+L88*_V_sto_1)","v":6.1639647593528455}]
[72,3.4,6.0495533177944066E-2,0,0,null,0,0,40.963229423167675,40.963229423167675,40.963229423167675,40.963229423167675,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I89*[0]!_V_sto_4+J89*_V_sto_3+K89*_V_sto_2+L89*_V_sto_1)","v":9.5034692261749019}]
[73,3.4,9.3701692526575092E-2,0,0,null,0,0,55.214515231242792,55.214515231242792,55.214515231242792,55.214515231242792,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I90*[0]!_V_sto_4+J90*_V_sto_3+K90*_V_sto_2+L90*_V_sto_1)","v":12.809767533648328}]
[74,2.3855763601152513,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I91*[0]!_V_sto_4+J91*_V_sto_3+K91*_V_sto_2+L91*_V_sto_1)","v":15.08}]
[75,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I92*[0]!_V_sto_4+J92*_V_sto_3+K92*_V_sto_2+L92*_V_sto_1)","v":15.08}]
[76,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I93*[0]!_V_sto_4+J93*_V_sto_3+K93*_V_sto_2+L93*_V_sto_1)","v":15.08}]
[77,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I94*[0]!_V_sto_4+J94*_V_sto_3+K94*_V_sto_2+L94*_V_sto_1)","v":15.08}]
[78,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I95*[0]!_V_sto_4+J95*_V_sto_3+K95*_V_sto_2+L95*_V_sto_1)","v":15.08}]
[79,0.11534389376357934,0.1153438937635787,0,0,null,0,0,65,65,65,65,null,"STO_FUEL_EL","NO",{"$f":"_Cp_W/1000*(I96*[0]!_V_sto_4+J96*_V_sto_3+K96*_V_sto_2+L96*_V_sto_1)","v":15.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_Cp_W/1000*(I97*[0]!_V_sto_4+J97*_V_sto_3+K97*_V_sto_2+L97*_V_sto_1)","v":0}]
[null,{"$f":"SUM(B88:B96)","v":13.16229582893315},null,null,null,null,{"$f":"SUM(G73:G96)","v":11.645000000000003}]

{"sheet":"History","index":11,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[null,"2013-09-25","1.1","Correction lines 23 and 44-48 (index misfit)"]
[null,"2013-09-27","1.2","Adjustment of subscripts"]
[null,"2013-11-19","1.21","Correction temperature volume 1et 2 Step4.1/ index of output series for volume 1-4 and adjustment of energy input"]
[null,"2013-12-30","1.22","Data input profile M,S and L from Mandate M323 and Labelling Directive - Calculation procedure line D27 corrected"]

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

{"sheet":"fsto_bac_acc","index":13,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Profile","L","M","S","standby"]
["Ecalculated",{"$f":"SUM(Output_series!$B$73:$B$97)","v":13.16229582893315},{"$f":"+SUM(Output_series!$B$24:$B$47)","v":8.4856216545783791},{"$f":"SUM(Output_series!$B$47:$B$72)","v":4.3083147038024112},{"$f":"_V_sto_tot*_H_sto_tot*(_θ_sto_set_on-_θ_sto_amb)/10000","v":2.306877875271574}]
["required",{"$f":"SUM(Output_series!$G$73:$G$97)","v":11.645000000000003},{"$f":"+SUM(Output_series!$G$24:$G$47)","v":5.8449999999999998},{"$f":"SUM(Output_series!$G$48:$G$72)","v":2.1}]
["losses",{"$f":"SUM(Output_series!$C$73:$C$97)","v":1.5896595789334618},{"$f":"+SUM(Output_series!$C$25:$C$48)","v":2.1217886794020098},{"$f":"SUM(Output_series!$C$48:$C$72)","v":2.7148807326902378}]
[null,{"$f":"(B6-B7)","v":1.5172958289331469},{"$f":"(C6-C7)","v":2.6406216545783794},{"$f":"(D6-D7)","v":2.2083147038024111},{"$f":"E6","v":2.306877875271574}]
["f_sto_bac_acc",{"$f":"MIN(1,B$9/$E$9)","v":0.6577269846825009},{"$f":"MIN(1,C$8/$E$9)","v":0.91976636567821135},{"$f":"MIN(1,D$9/$E$9)","v":0.9572742135482315},1]
[null,{"$f":"B7+B8","v":13.234659578933465},{"$f":"C7+C8","v":7.9667886794020095},{"$f":"D7+D8","v":4.8148807326902379}]