{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Disclaimer","INFO","Measured_data_report_1","Method_input","Method_calculation","Method_output","History","Foglio2"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":6,"n_cols":1,"rows_kept":6,"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\""]
["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."]
["THIS IS A SIMPLIFIED VERSION INCLUDING ONLY THE MANDATORY SHEET\nONLY ONE CALCULATION EXAMPLE AT ONE TIME-STEP IS SUPPORTED"]

{"sheet":"Measured_data_report_1","index":2,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This is the source data used for this example"]
[null,"Initial date","Final date","Initial meter reading\nor\n final stock","Final meter reading \nor\ninitial stock","Source of  delivered energy data","Checked","Deliveries","Average ext. Temp.","Source of ext temp.","Indoor temp.","Source of internal temp. data","Type of use during meas. Interval"]
[null,"Dmeas,i,t;ini","Dmeas,i,t;ini","Rcr,i,t;ini\nMstock;cr,i,t;fin","Rcr,i,t;fin\nMstock;cr,i,t;ini",null,null,"Msup;cr,i,t","ϑext,t",null,"ϑint,t"]
[null,"[day]","[day]","m³ /kg/l","m³ /kg/l",null,"OK/KO","m³ /kg/l","°C",null,"°C"]
[]
[null,"2002-06-26","2002-08-27",10657,10690,"Inv","OK",0,23.25,"METEO",null,"USER","nH"]
[null,"2002-08-27","2002-11-04",10690,10742,"Inv","OK",0,16.53,"METEO",null,null,"HnH"]
[null,"2002-11-04","2002-12-06",10742,10868,"Inv","OK",0,10.7,"METEO",13.6,"USER","H"]
[null,"2002-12-06","2003-01-04",10868,11054,"Inv","OK",0,5.8,"METEO",13.6,"USER","H"]
[null,"2003-01-04","2003-01-10",11054,11108,"Inv","OK",0,3.3,"METEO",13.6,"USER","H"]
[null,"2003-01-10","2003-02-01",11108,11310,"Inv","OK",0,3.35,"METEO",13.6,"USER","H"]
[null,"2003-02-01","2003-02-22",11310,11622,"Inv","OK",0,2.67,"METEO",13.6,"USER","H"]
[null,"2003-02-22","2003-03-04",11622,11733,"Inv","OK",0,5.85,"METEO",13.6,"USER","H"]
[null,"2003-03-04","2003-05-02",11733,12066,"Inv","OK",0,11.28,"METEO",null,null,"HnH"]
[null,"2003-05-02","2003-05-04",12066,12067,"Inv","OK",0,19.3,"METEO",null,null,"nH"]
[null,"2003-05-04","2003-07-01",12067,12095,"Inv","OK",0,23.7,"METEO",null,null,"nH"]
[null,"2003-07-01","2003-09-19",12095,12124,"Inv","OK",0,26.8,"METEO",null,null,"nH"]
[null,"2003-09-19","2003-10-16",12124,12138,"Inv","OK",0,19.5,"METEO",null,null,"HnH"]
[null,"2003-10-16","2003-11-18",12138,12297,"Inv","OK",0,8.9600000000000009,"METEO",13.6,"USER","H"]
[null,"2003-11-18","2003-12-31",12297,12667,"Inv","OK",0,6.88,"METEO",13.6,"USER","H"]
[null,"2003-12-31","2004-01-12",12667,12793,"Inv","OK",0,2.4500000000000002,"METEO",13.6,"USER","H"]
[null,"2004-01-12","2004-02-26",12793,13333,"Inv","OK",0,3.48,"METEO",13.6,"USER","H"]
[null,"2004-02-26","2004-03-20",13333,13560,"Inv","OK",0,6.61,"METEO",13.6,"USER","H"]
[null,"2004-03-20","2004-04-02",13560,13615,"Inv","OK",0,9.9499999999999993,"METEO",13.6,"USER","H"]
[null,"2004-04-02","2004-06-14",13615,13682,"Inv","OK",0,15.7,"METEO",null,null,"HnH"]
[null,"2004-06-14","2004-08-25",13682,13716,"Inv","OK",0,23.6,"METEO",null,null,"nH"]
[null,"2004-08-25","2004-09-18",13716,13728,"Inv","OK",0,21.01,"METEO",null,null,"nH"]
[null,"2004-09-18","2004-11-02",13728,13752,"Inv","OK",0,16.3,"METEO",null,null,"HnH"]
[null,"2004-11-02","2004-11-09",13752,13761,"Inv","OK",0,13.4,"METEO",13.6,"USER","H"]
[null,"2004-11-09","2004-12-11",13761,13987,"Inv","OK",0,7.45,"METEO",13.6,"USER","H"]
[null,"2004-12-11","2005-01-01",13987,14170.15,"Inv","OK",0,4.6500000000000004,"METEO",13.6,"USER","H"]
[null,"2005-01-01","2005-01-10",14170.15,14261,"Inv","OK",0,3,"METEO",13.6,"USER","H"]
[null,"2005-01-10","2005-02-28",14261,14806,"Inv","OK",0,2.69,"METEO",13.6,"USER","H"]
[null,"2005-02-28","2005-03-26",14806,14997,"Inv","OK",0,7.5,"METEO",13.6,"USER","H"]
[null,"2005-03-26","2005-05-06",14997,15068,"Inv","OK",0,13.7,"METEO",null,null,"HnH"]
[null,"2005-05-06","2005-05-30",15068,15086,"Inv","OK",0,18.760000000000002,"METEO",null,null,"nH"]
[null,"2005-05-30","2005-06-30",15086,15101,"Inv","OK",0,23.3,"METEO",null,null,"nH"]
[null,"2005-06-30","2005-09-01",15101,15129,"Inv","OK",0,22.8,"METEO",null,null,"nH"]
[null,"2005-09-01","2005-11-04",15129,15165,"Inv","OK",0,16.46,"METEO",null,null,"HnH"]
[null,"2005-11-04","2005-12-24",15165,15570,"Inv","OK",0,5.77,"METEO",13.6,"USER","H"]
[null,"2005-12-24","2005-12-31",15570,15652,"Inv","OK",0,1.9,"METEO",13.6,"USER","H"]
[null,"2005-12-31","2006-01-10",15652,15747,"Inv","OK",0,3.83,"METEO",13.6,"USER","H"]
[null,"2006-01-10","2006-02-11",15747,16168,"Inv","OK",0,2.5499999999999998,"METEO",13.6,"USER","H"]
[null,"2006-02-11","2006-03-18",16168,16515,"Inv","OK",0,5.45,"METEO",13.6,"USER","H"]
[null,"2006-03-18","2006-04-01",16515,16554,"Inv","OK",0,10,"METEO",null,null,"HnH"]
[null,"2006-04-01","2006-04-15",16554,16585,"Inv","OK",0,11.12,"METEO",null,null,"HnH"]
[null,"2006-04-15","2006-05-02",16585,16597,"Inv","OK",0,15.8,"METEO",null,null,"nH"]
[null,"2006-05-02","2006-06-23",16597,16628,"Inv","OK",0,19.3,"METEO",null,null,"nH"]
[null,"2006-06-23","2006-09-07",16628,16660,"Inv","OK",0,23.9,"METEO",null,null,"nH"]
[null,"2006-09-07","2006-10-26",16660,16691,"Inv","OK",0,17.68,"METEO",null,null,"HnH"]
[null,"2006-10-26","2006-12-18",16691,16910,"Inv","OK",0,9.5,"METEO",13.6,"USER","H"]
[null,"2006-12-18","2007-02-21",16910,17374,"Inv","OK",0,5.6,"METEO",13.6,"USER","H"]
[null,"2007-02-21","2007-04-21",17374,17512,"Inv","OK",0,12.24,"METEO",13.6,"USER","H"]
[null,"2007-04-21","2007-04-30",17512,17517,"Inv","OK",0,19.170000000000002,"METEO",null,null,"HnH"]

{"sheet":"Method_input","index":3,"n_rows":58,"n_cols":59,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["THIS IS A MANDATORY SHEET\nAll input data for the method shall be listed here.\nIn the simplest version, values for data input in column D (both green and blue background) may be inserted manually.\nVarying data (green background) can be fed from the \"input_series\" sheet.\nIn this sample data sheet, product data (blue background) is linked to a sample catalogue built in the \"Detailed_input\" sheet"]
[]
[]
["Name","Symbol","Software name","Unit","Value","Range","Origin","Varying","Notes",null,null,null,null,null,null,null,"DATA ARRAY"]
["Operating conditions data"]
[]
["Measured data"]
[]
["Type of fuel","MEAS_CARRIER",null,null,"GAS_METER"]
["Initial date","Dmeas,i,t;ini",null,"[day]",{"$f":"+K10","v":"2002-06-26"},null,null,null,null,null,"2002-06-26","2002-08-27","2002-11-04","2002-12-06","2003-01-04","2003-01-10","2003-02-01","2003-02-22","2003-03-04","2003-05-02","2003-05-04","2003-07-01","2003-09-19","2003-10-16","2003-11-18","2003-12-31","2004-01-12","2004-02-26","2004-03-20","2004-04-02","2004-06-14","2004-08-25","2004-09-18","2004-11-02","2004-11-09","2004-12-11","2005-01-01","2005-01-10","2005-02-28","2005-03-26","2005-05-06","2005-05-30","2005-06-30","2005-09-01","2005-11-04","2005-12-24","2005-12-31","2006-01-10","2006-02-11","2006-03-18","2006-04-01","2006-04-15","2006-05-02","2006-06-23","2006-09-07","2006-10-26","2006-12-18","2007-02-21","2007-04-21"]
["Final date","Dmeas,i,t;ini",null,"[day]",{"$f":"+K11","v":"2002-08-27"},null,null,null,null,null,"2002-08-27","2002-11-04","2002-12-06","2003-01-04","2003-01-10","2003-02-01","2003-02-22","2003-03-04","2003-05-02","2003-05-04","2003-07-01","2003-09-19","2003-10-16","2003-11-18","2003-12-31","2004-01-12","2004-02-26","2004-03-20","2004-04-02","2004-06-14","2004-08-25","2004-09-18","2004-11-02","2004-11-09","2004-12-11","2005-01-01","2005-01-10","2005-02-28","2005-03-26","2005-05-06","2005-05-30","2005-06-30","2005-09-01","2005-11-04","2005-12-24","2005-12-31","2006-01-10","2006-02-11","2006-03-18","2006-04-01","2006-04-15","2006-05-02","2006-06-23","2006-09-07","2006-10-26","2006-12-18","2007-02-21","2007-04-21","2007-04-30"]
["Initial meter reading or\n final stock","Rcr,i,t;ini\nMstock;cr,i,t;fin",null,"m³ /kg/l",10657,null,null,null,null,null,10657,10690,10742,10868,11054,11108,11310,11622,11733,12066,12067,12095,12124,12138,12297,12667,12793,13333,13560,13615,13682,13716,13728,13752,13761,13987,14170.15,14261,14806,14997,15068,15086,15101,15129,15165,15570,15652,15747,16168,16515,16554,16585,16597,16628,16660,16691,16910,17374,17512]
["Final meter reading or\ninitial stock","Rcr,i,t;fin\nMstock;cr,i,t;ini",null,"m³ /kg/l",10690,null,null,null,null,null,10690,10742,10868,11054,11108,11310,11622,11733,12066,12067,12095,12124,12138,12297,12667,12793,13333,13560,13615,13682,13716,13728,13752,13761,13987,14170.15,14261,14806,14997,15068,15086,15101,15129,15165,15570,15652,15747,16168,16515,16554,16585,16597,16628,16660,16691,16910,17374,17512,17517]
["Source of  delivered energy data","MEAS_DEL_SOURCE",null,null,"Inv",null,null,null,null,null,"Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv","Inv"]
["Checked","MEAS_DEL_CHECKED",null,"OK/KO","OK",null,null,null,null,null,"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
["Deliveries","Msup;cr,i,t",null,"m³ /kg/l",0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Average ext. Temp.","ϑext,t",null,"°C",{"$f":"+K17","v":23.25},null,null,null,null,null,23.25,16.53,10.7,5.8,3.3,3.35,2.67,5.85,11.28,19.3,23.7,26.8,19.5,8.9600000000000009,6.88,2.4500000000000002,3.48,6.61,9.9499999999999993,15.7,23.6,21.01,16.3,13.4,7.45,4.6500000000000004,3,2.69,7.5,13.7,18.760000000000002,23.3,22.8,16.46,5.77,1.9,3.83,2.5499999999999998,5.45,10,11.12,15.8,19.3,23.9,17.68,9.5,5.6,12.24,19.170000000000002]
["Source of ext temp.","MEAS_TEXT_SOURCE",null,null,"METEO",null,null,null,null,null,"METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO","METEO"]
["Indoor temp.","ϑint,t",null,"°C",13.6,null,null,null,null,null,{"$f":"IF(K21=\"H\",$E$19,\"\")","v":""},{"$f":"IF(L21=\"H\",$E$19,\"\")","v":""},13.6,13.6,13.6,13.6,13.6,13.6,"","","","","",13.6,13.6,13.6,13.6,13.6,13.6,"","","","",13.6,13.6,13.6,13.6,13.6,13.6,"","","","","",13.6,13.6,13.6,13.6,13.6,"","","","","","",13.6,13.6,13.6,""]
["Source of internal temp. data","MEAS_TINT_SOURCE",null,null,"USER",null,null,null,null,null,"USER",null,"USER","USER","USER","USER","USER","USER",null,null,null,null,null,"USER","USER","USER","USER","USER","USER",null,null,null,null,"USER","USER","USER","USER","USER","USER",null,null,null,null,null,"USER","USER","USER","USER","USER",null,null,null,null,null,null,"USER","USER","USER"]
["Type of use during meas. Interval","MEAS_USE",null,null,"nH",null,null,null,null,null,"nH","HnH","H","H","H","H","H","H","HnH","nH","nH","nH","HnH","H","H","H","H","H","H","HnH","nH","nH","HnH","H","H","H","H","H","H","HnH","nH","nH","nH","HnH","H","H","H","H","H","HnH","HnH","nH","nH","nH","HnH","H","H","H","HnH"]
[]
["Gas absolute pressure at measurement point","Pmeas;abs",null,"Pa",101300]
["Gas absolute temperature at measurement point","Tmeas",null,"K",{"$f":"15+273","v":288}]
[]
[]
[]
[]
["Product data"]
["Product description data "]
[]
["Product technical data "]
[]
["System design data"]
["Process design"]
[]
["utilization factor of heat gains","ηH,gn",null,"-",0.92500000000000004]
["ratio of heat gains and losses","γH",null,"-",0.23599999999999999]
["reference internal temperature ","ϑint,ref",null,"°C",20]
["reference area","Ameas;ref",null,"m²",125]
["Normalised degree days","DDnorm",null,"°Cdays",2293]
[]
["Control type data"]
[]
[]
["Constants"]
["Water specific heat","cpw ","cp_w ","Wh/kg°C",1.1599999999999999]
["Liquid fuel density","ρfuel",null,"kg/l",0.84]
["Gas reference pressure ","Pref;abs",null,"Pa",101300]
["Gas reference temperature ","Tref",null,"K",{"$f":"15+273","v":288}]
["Calorific value of fuel","Hi",null,"kWh/Sm³",9.4499999999999993]
[]
[]
[]
[]
["calculation interval","tci ","t_ci ","h",744,"0…8760","M1-9","Yes"]
["generator efficiency at full load;","ηgnr;Pn ","eta_gnr_Pn ","%",90.667226875575466,"0…120%","Local","NO"]
["Temperature reduction factor of boiler room","bbrm","bbrm","-",0.7,"0…1","Local","NO"]

{"sheet":"Method_calculation","index":4,"n_rows":57,"n_cols":57,"rows_kept":57,"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",null,null,null,null,null,null,null,"DATA ARRAY"]
[]
[]
[]
["Initial meter reading or\n final stock","Rcr,i,t;ini\nMstock;cr,i,t;fin","m³ /kg/l",{"$f":"+Method_input!E12","v":10657},null,null,"Input data array",null,{"$f":"+Method_input!K12","v":10657},{"$f":"+Method_input!L12","v":10690},{"$f":"+Method_input!M12","v":10742},{"$f":"+Method_input!N12","v":10868},{"$f":"+Method_input!O12","v":11054},{"$f":"+Method_input!P12","v":11108},{"$f":"+Method_input!Q12","v":11310},{"$f":"+Method_input!R12","v":11622},{"$f":"+Method_input!S12","v":11733},{"$f":"+Method_input!T12","v":12066},{"$f":"+Method_input!U12","v":12067},{"$f":"+Method_input!V12","v":12095},{"$f":"+Method_input!W12","v":12124},{"$f":"+Method_input!X12","v":12138},{"$f":"+Method_input!Y12","v":12297},{"$f":"+Method_input!Z12","v":12667},{"$f":"+Method_input!AA12","v":12793},{"$f":"+Method_input!AB12","v":13333},{"$f":"+Method_input!AC12","v":13560},{"$f":"+Method_input!AD12","v":13615},{"$f":"+Method_input!AE12","v":13682},{"$f":"+Method_input!AF12","v":13716},{"$f":"+Method_input!AG12","v":13728},{"$f":"+Method_input!AH12","v":13752},{"$f":"+Method_input!AI12","v":13761},{"$f":"+Method_input!AJ12","v":13987},{"$f":"+Method_input!AK12","v":14170.15},{"$f":"+Method_input!AL12","v":14261},{"$f":"+Method_input!AM12","v":14806},{"$f":"+Method_input!AN12","v":14997},{"$f":"+Method_input!AO12","v":15068},{"$f":"+Method_input!AP12","v":15086},{"$f":"+Method_input!AQ12","v":15101},{"$f":"+Method_input!AR12","v":15129},{"$f":"+Method_input!AS12","v":15165},{"$f":"+Method_input!AT12","v":15570},{"$f":"+Method_input!AU12","v":15652},{"$f":"+Method_input!AV12","v":15747},{"$f":"+Method_input!AW12","v":16168},{"$f":"+Method_input!AX12","v":16515},{"$f":"+Method_input!AY12","v":16554},{"$f":"+Method_input!AZ12","v":16585},{"$f":"+Method_input!BA12","v":16597},{"$f":"+Method_input!BB12","v":16628},{"$f":"+Method_input!BC12","v":16660},{"$f":"+Method_input!BD12","v":16691},{"$f":"+Method_input!BE12","v":16910},{"$f":"+Method_input!BF12","v":17374},{"$f":"+Method_input!BG12","v":17512}]
["Final meter reading or\ninitial stock","Rcr,i,t;fin\nMstock;cr,i,t;ini","m³ /kg/l",{"$f":"+Method_input!E13","v":10690},null,null,"Input data array",null,{"$f":"+Method_input!K13","v":10690},{"$f":"+Method_input!L13","v":10742},{"$f":"+Method_input!M13","v":10868},{"$f":"+Method_input!N13","v":11054},{"$f":"+Method_input!O13","v":11108},{"$f":"+Method_input!P13","v":11310},{"$f":"+Method_input!Q13","v":11622},{"$f":"+Method_input!R13","v":11733},{"$f":"+Method_input!S13","v":12066},{"$f":"+Method_input!T13","v":12067},{"$f":"+Method_input!U13","v":12095},{"$f":"+Method_input!V13","v":12124},{"$f":"+Method_input!W13","v":12138},{"$f":"+Method_input!X13","v":12297},{"$f":"+Method_input!Y13","v":12667},{"$f":"+Method_input!Z13","v":12793},{"$f":"+Method_input!AA13","v":13333},{"$f":"+Method_input!AB13","v":13560},{"$f":"+Method_input!AC13","v":13615},{"$f":"+Method_input!AD13","v":13682},{"$f":"+Method_input!AE13","v":13716},{"$f":"+Method_input!AF13","v":13728},{"$f":"+Method_input!AG13","v":13752},{"$f":"+Method_input!AH13","v":13761},{"$f":"+Method_input!AI13","v":13987},{"$f":"+Method_input!AJ13","v":14170.15},{"$f":"+Method_input!AK13","v":14261},{"$f":"+Method_input!AL13","v":14806},{"$f":"+Method_input!AM13","v":14997},{"$f":"+Method_input!AN13","v":15068},{"$f":"+Method_input!AO13","v":15086},{"$f":"+Method_input!AP13","v":15101},{"$f":"+Method_input!AQ13","v":15129},{"$f":"+Method_input!AR13","v":15165},{"$f":"+Method_input!AS13","v":15570},{"$f":"+Method_input!AT13","v":15652},{"$f":"+Method_input!AU13","v":15747},{"$f":"+Method_input!AV13","v":16168},{"$f":"+Method_input!AW13","v":16515},{"$f":"+Method_input!AX13","v":16554},{"$f":"+Method_input!AY13","v":16585},{"$f":"+Method_input!AZ13","v":16597},{"$f":"+Method_input!BA13","v":16628},{"$f":"+Method_input!BB13","v":16660},{"$f":"+Method_input!BC13","v":16691},{"$f":"+Method_input!BD13","v":16910},{"$f":"+Method_input!BE13","v":17374},{"$f":"+Method_input!BF13","v":17512},{"$f":"+Method_input!BG13","v":17517}]
["Deliveries","Msup;cr,i,t","m³ /kg/l",{"$f":"+Method_input!E16","v":0},null,null,"Input data"]
["Delivered amount of fuel","Mdel;cr,i,t;meas ","m³ /kg/l",{"$f":"+D8+D9-D7","v":33},"(1), (3), (4)",null,"Formula depends on the type of fuel",null,{"$f":"+I8+I9-I7","v":33},52,126,186,54,202,312,111,333,1,28,29,14,159,370,126,540,227,55,67,34,12,24,9,226,183.14999999999964,90.850000000000364,545,191,71,18,15,28,36,405,82,95,421,347,39,31,12,31,32,31,219,464,138,5]
["Gas absolute pressure at measurement point","Pmeas;abs","Pa",{"$f":"+Method_input!E23","v":101300},null,null,"Input data"]
["Gas absolute temperature at measurement point","Tmeas","K",{"$f":"+Method_input!E24","v":288},null,null,"Input data"]
["Gas reference pressure ","Pref;abs","Pa",{"$f":"+Method_input!E49","v":101300},null,null,"Input data"]
["Gas reference temperature ","Tref","K",{"$f":"+Method_input!E50","v":288},null,null,"Input data"]
["Correction factor for gas","kmeas;corr;gas ","-",{"$f":"+(D14/D12)*(D11/D13)","v":1},"(2)"]
["Correction factor of the reading ","kmeas;corr;",null,{"$f":"+D15","v":1},null,null,"Automatic selection depending on the type of fule to be implemented."]
["Calorific value of fuel","Hi","kWh/Sm³",{"$f":"+Method_input!E51","v":9.4499999999999993},null,null,"Input data"]
["Delivered energy","Edel;cr,i,t;meas ","kWh",{"$f":"+$D$17*$D$16*D10","v":311.84999999999997},"(7)",null,null,null,{"$f":"+$D$17*$D$16*I10","v":311.84999999999997},491.4,1190.6999999999998,1757.6999999999998,510.29999999999995,1908.8999999999999,2948.3999999999996,1048.9499999999998,3146.85,9.4499999999999993,264.59999999999997,274.04999999999995,132.29999999999998,1502.55,3496.4999999999995,1190.6999999999998,5103,2145.1499999999996,519.75,633.15,321.29999999999995,113.39999999999999,226.79999999999998,85.05,2135.6999999999998,1730.7674999999965,858.53250000000332,5150.25,1804.9499999999998,670.94999999999993,170.1,141.75,264.59999999999997,340.2,3827.2499999999995,774.9,897.74999999999989,3978.45,3279.1499999999996,368.54999999999995,292.95,113.39999999999999,292.95,302.39999999999998,292.95,2069.5499999999997,4384.7999999999993,1304.0999999999999,47.25]
["Initial date","Dmeas,i,t;ini","day",{"$f":"+Method_input!E10","v":"2002-06-26"},null,null,"Input data array",null,{"$f":"+Method_input!K10","v":"2002-06-26"},{"$f":"+Method_input!L10","v":"2002-08-27"},{"$f":"+Method_input!M10","v":"2002-11-04"},{"$f":"+Method_input!N10","v":"2002-12-06"},{"$f":"+Method_input!O10","v":"2003-01-04"},{"$f":"+Method_input!P10","v":"2003-01-10"},{"$f":"+Method_input!Q10","v":"2003-02-01"},{"$f":"+Method_input!R10","v":"2003-02-22"},{"$f":"+Method_input!S10","v":"2003-03-04"},{"$f":"+Method_input!T10","v":"2003-05-02"},{"$f":"+Method_input!U10","v":"2003-05-04"},{"$f":"+Method_input!V10","v":"2003-07-01"},{"$f":"+Method_input!W10","v":"2003-09-19"},{"$f":"+Method_input!X10","v":"2003-10-16"},{"$f":"+Method_input!Y10","v":"2003-11-18"},{"$f":"+Method_input!Z10","v":"2003-12-31"},{"$f":"+Method_input!AA10","v":"2004-01-12"},{"$f":"+Method_input!AB10","v":"2004-02-26"},{"$f":"+Method_input!AC10","v":"2004-03-20"},{"$f":"+Method_input!AD10","v":"2004-04-02"},{"$f":"+Method_input!AE10","v":"2004-06-14"},{"$f":"+Method_input!AF10","v":"2004-08-25"},{"$f":"+Method_input!AG10","v":"2004-09-18"},{"$f":"+Method_input!AH10","v":"2004-11-02"},{"$f":"+Method_input!AI10","v":"2004-11-09"},{"$f":"+Method_input!AJ10","v":"2004-12-11"},{"$f":"+Method_input!AK10","v":"2005-01-01"},{"$f":"+Method_input!AL10","v":"2005-01-10"},{"$f":"+Method_input!AM10","v":"2005-02-28"},{"$f":"+Method_input!AN10","v":"2005-03-26"},{"$f":"+Method_input!AO10","v":"2005-05-06"},{"$f":"+Method_input!AP10","v":"2005-05-30"},{"$f":"+Method_input!AQ10","v":"2005-06-30"},{"$f":"+Method_input!AR10","v":"2005-09-01"},{"$f":"+Method_input!AS10","v":"2005-11-04"},{"$f":"+Method_input!AT10","v":"2005-12-24"},{"$f":"+Method_input!AU10","v":"2005-12-31"},{"$f":"+Method_input!AV10","v":"2006-01-10"},{"$f":"+Method_input!AW10","v":"2006-02-11"},{"$f":"+Method_input!AX10","v":"2006-03-18"},{"$f":"+Method_input!AY10","v":"2006-04-01"},{"$f":"+Method_input!AZ10","v":"2006-04-15"},{"$f":"+Method_input!BA10","v":"2006-05-02"},{"$f":"+Method_input!BB10","v":"2006-06-23"},{"$f":"+Method_input!BC10","v":"2006-09-07"},{"$f":"+Method_input!BD10","v":"2006-10-26"},{"$f":"+Method_input!BE10","v":"2006-12-18"},{"$f":"+Method_input!BF10","v":"2007-02-21"},{"$f":"+Method_input!BG10","v":"2007-04-21"}]
["Final date","Dmeas,i,t;ini","day",{"$f":"+Method_input!E11","v":"2002-08-27"},null,null,"Input data array",null,{"$f":"+Method_input!K11","v":"2002-08-27"},{"$f":"+Method_input!L11","v":"2002-11-04"},{"$f":"+Method_input!M11","v":"2002-12-06"},{"$f":"+Method_input!N11","v":"2003-01-04"},{"$f":"+Method_input!O11","v":"2003-01-10"},{"$f":"+Method_input!P11","v":"2003-02-01"},{"$f":"+Method_input!Q11","v":"2003-02-22"},{"$f":"+Method_input!R11","v":"2003-03-04"},{"$f":"+Method_input!S11","v":"2003-05-02"},{"$f":"+Method_input!T11","v":"2003-05-04"},{"$f":"+Method_input!U11","v":"2003-07-01"},{"$f":"+Method_input!V11","v":"2003-09-19"},{"$f":"+Method_input!W11","v":"2003-10-16"},{"$f":"+Method_input!X11","v":"2003-11-18"},{"$f":"+Method_input!Y11","v":"2003-12-31"},{"$f":"+Method_input!Z11","v":"2004-01-12"},{"$f":"+Method_input!AA11","v":"2004-02-26"},{"$f":"+Method_input!AB11","v":"2004-03-20"},{"$f":"+Method_input!AC11","v":"2004-04-02"},{"$f":"+Method_input!AD11","v":"2004-06-14"},{"$f":"+Method_input!AE11","v":"2004-08-25"},{"$f":"+Method_input!AF11","v":"2004-09-18"},{"$f":"+Method_input!AG11","v":"2004-11-02"},{"$f":"+Method_input!AH11","v":"2004-11-09"},{"$f":"+Method_input!AI11","v":"2004-12-11"},{"$f":"+Method_input!AJ11","v":"2005-01-01"},{"$f":"+Method_input!AK11","v":"2005-01-10"},{"$f":"+Method_input!AL11","v":"2005-02-28"},{"$f":"+Method_input!AM11","v":"2005-03-26"},{"$f":"+Method_input!AN11","v":"2005-05-06"},{"$f":"+Method_input!AO11","v":"2005-05-30"},{"$f":"+Method_input!AP11","v":"2005-06-30"},{"$f":"+Method_input!AQ11","v":"2005-09-01"},{"$f":"+Method_input!AR11","v":"2005-11-04"},{"$f":"+Method_input!AS11","v":"2005-12-24"},{"$f":"+Method_input!AT11","v":"2005-12-31"},{"$f":"+Method_input!AU11","v":"2006-01-10"},{"$f":"+Method_input!AV11","v":"2006-02-11"},{"$f":"+Method_input!AW11","v":"2006-03-18"},{"$f":"+Method_input!AX11","v":"2006-04-01"},{"$f":"+Method_input!AY11","v":"2006-04-15"},{"$f":"+Method_input!AZ11","v":"2006-05-02"},{"$f":"+Method_input!BA11","v":"2006-06-23"},{"$f":"+Method_input!BB11","v":"2006-09-07"},{"$f":"+Method_input!BC11","v":"2006-10-26"},{"$f":"+Method_input!BD11","v":"2006-12-18"},{"$f":"+Method_input!BE11","v":"2007-02-21"},{"$f":"+Method_input!BF11","v":"2007-04-21"},{"$f":"+Method_input!BG11","v":"2007-04-30"}]
["Measurement interval duration","tt","h",{"$f":"24*(D20-D19)","v":1488},"(8)",null,null,null,{"$f":"24*(I20-I19)","v":1488},1656,768,696,144,528,504,240,1416,48,1392,1920,648,792,1032,288,1080,552,312,1752,1728,576,1080,168,768,504,216,1176,624,984,576,744,1512,1536,1200,168,240,768,840,336,336,408,1248,1824,1176,1272,1560,1416,216]
["Delivered power","Φdel,meas,t  ","kW",{"$f":"+D18/D21","v":0.2095766129032258},"(9)",null,null,null,{"$f":"+I18/I21","v":0.2095766129032258},0.29673913043478262,1.5503906249999997,2.5254310344827582,3.5437499999999997,3.615340909090909,5.85,4.3706249999999995,2.222351694915254,0.19687499999999999,0.1900862068965517,0.14273437499999997,0.20416666666666664,1.897159090909091,3.3880813953488369,4.1343749999999995,4.7249999999999996,3.8861413043478255,1.6658653846153846,0.36138698630136984,0.18593749999999998,0.19687499999999999,0.21,0.50624999999999998,2.7808593749999999,3.4340624999999929,3.9746875000000155,4.3794642857142856,2.8925480769230765,0.68185975609756089,0.29531249999999998,0.19052419354838709,0.17499999999999999,0.22148437499999998,3.1893749999999996,4.6124999999999998,3.7406249999999996,5.1802734374999995,3.9037499999999996,1.0968749999999998,0.87187499999999996,0.27794117647058819,0.23473557692307692,0.16578947368421051,0.24910714285714286,1.6270047169811319,2.8107692307692305,0.9209745762711864,0.21875]
["Type of use during meas. Interval","MEAS_USE",null,{"$f":"+Method_input!E21","v":"nH"},null,null,"Input data array",null,{"$f":"+Method_input!K21","v":"nH"},{"$f":"+Method_input!L21","v":"HnH"},{"$f":"+Method_input!M21","v":"H"},{"$f":"+Method_input!N21","v":"H"},{"$f":"+Method_input!O21","v":"H"},{"$f":"+Method_input!P21","v":"H"},{"$f":"+Method_input!Q21","v":"H"},{"$f":"+Method_input!R21","v":"H"},{"$f":"+Method_input!S21","v":"HnH"},{"$f":"+Method_input!T21","v":"nH"},{"$f":"+Method_input!U21","v":"nH"},{"$f":"+Method_input!V21","v":"nH"},{"$f":"+Method_input!W21","v":"HnH"},{"$f":"+Method_input!X21","v":"H"},{"$f":"+Method_input!Y21","v":"H"},{"$f":"+Method_input!Z21","v":"H"},{"$f":"+Method_input!AA21","v":"H"},{"$f":"+Method_input!AB21","v":"H"},{"$f":"+Method_input!AC21","v":"H"},{"$f":"+Method_input!AD21","v":"HnH"},{"$f":"+Method_input!AE21","v":"nH"},{"$f":"+Method_input!AF21","v":"nH"},{"$f":"+Method_input!AG21","v":"HnH"},{"$f":"+Method_input!AH21","v":"H"},{"$f":"+Method_input!AI21","v":"H"},{"$f":"+Method_input!AJ21","v":"H"},{"$f":"+Method_input!AK21","v":"H"},{"$f":"+Method_input!AL21","v":"H"},{"$f":"+Method_input!AM21","v":"H"},{"$f":"+Method_input!AN21","v":"HnH"},{"$f":"+Method_input!AO21","v":"nH"},{"$f":"+Method_input!AP21","v":"nH"},{"$f":"+Method_input!AQ21","v":"nH"},{"$f":"+Method_input!AR21","v":"HnH"},{"$f":"+Method_input!AS21","v":"H"},{"$f":"+Method_input!AT21","v":"H"},{"$f":"+Method_input!AU21","v":"H"},{"$f":"+Method_input!AV21","v":"H"},{"$f":"+Method_input!AW21","v":"H"},{"$f":"+Method_input!AX21","v":"HnH"},{"$f":"+Method_input!AY21","v":"HnH"},{"$f":"+Method_input!AZ21","v":"nH"},{"$f":"+Method_input!BA21","v":"nH"},{"$f":"+Method_input!BB21","v":"nH"},{"$f":"+Method_input!BC21","v":"HnH"},{"$f":"+Method_input!BD21","v":"H"},{"$f":"+Method_input!BE21","v":"H"},{"$f":"+Method_input!BF21","v":"H"},{"$f":"+Method_input!BG21","v":"HnH"}]
[null,null,null,null,null,null,"Auxiliary data: non heating intervals delivered energy",null,{"$f":"IF(I23=\"nH\",I22*I21,\"\")","v":311.84999999999997},{"$f":"IF(J23=\"nH\",J22*J21,\"\")","v":""},"","","","","","","",9.4499999999999993,264.59999999999997,274.04999999999995,"","","","","","","","",321.29999999999995,113.39999999999999,"","","","","","","","",170.1,141.75,264.59999999999997,"","","","","","","","",113.39999999999998,292.95,302.39999999999998,"","","","",""]
[null,null,null,null,null,null,"Auxiliary data: non heating intervals duration",null,{"$f":"IF(I23=\"nH\",I21,\"\")","v":1488},{"$f":"IF(J23=\"nH\",J21,\"\")","v":""},"","","","","","","",48,1392,1920,"","","","","","","","",1728,576,"","","","","","","","",576,744,1512,"","","","","","","","",408,1248,1824,"","","","",""]
["Average power in non-heating measurement intervals ","Φdel;meas;nH;avg","kW",{"$f":"SUM(I24:BE24)/SUM(I25:BE25)","v":0.19161096256684487},"(10)"]
["Average ext. Temp.","ϑext,t","°C","See array",null,null,"Input data array",null,{"$f":"+Method_input!K17","v":23.25},{"$f":"+Method_input!L17","v":16.53},{"$f":"+Method_input!M17","v":10.7},{"$f":"+Method_input!N17","v":5.8},{"$f":"+Method_input!O17","v":3.3},{"$f":"+Method_input!P17","v":3.35},{"$f":"+Method_input!Q17","v":2.67},{"$f":"+Method_input!R17","v":5.85},{"$f":"+Method_input!S17","v":11.28},{"$f":"+Method_input!T17","v":19.3},{"$f":"+Method_input!U17","v":23.7},{"$f":"+Method_input!V17","v":26.8},{"$f":"+Method_input!W17","v":19.5},{"$f":"+Method_input!X17","v":8.9600000000000009},{"$f":"+Method_input!Y17","v":6.88},{"$f":"+Method_input!Z17","v":2.4500000000000002},{"$f":"+Method_input!AA17","v":3.48},{"$f":"+Method_input!AB17","v":6.61},{"$f":"+Method_input!AC17","v":9.9499999999999993},{"$f":"+Method_input!AD17","v":15.7},{"$f":"+Method_input!AE17","v":23.6},{"$f":"+Method_input!AF17","v":21.01},{"$f":"+Method_input!AG17","v":16.3},{"$f":"+Method_input!AH17","v":13.4},{"$f":"+Method_input!AI17","v":7.45},{"$f":"+Method_input!AJ17","v":4.6500000000000004},{"$f":"+Method_input!AK17","v":3},{"$f":"+Method_input!AL17","v":2.69},{"$f":"+Method_input!AM17","v":7.5},{"$f":"+Method_input!AN17","v":13.7},{"$f":"+Method_input!AO17","v":18.760000000000002},{"$f":"+Method_input!AP17","v":23.3},{"$f":"+Method_input!AQ17","v":22.8},{"$f":"+Method_input!AR17","v":16.46},{"$f":"+Method_input!AS17","v":5.77},{"$f":"+Method_input!AT17","v":1.9},{"$f":"+Method_input!AU17","v":3.83},{"$f":"+Method_input!AV17","v":2.5499999999999998},{"$f":"+Method_input!AW17","v":5.45},{"$f":"+Method_input!AX17","v":10},{"$f":"+Method_input!AY17","v":11.12},{"$f":"+Method_input!AZ17","v":15.8},{"$f":"+Method_input!BA17","v":19.3},{"$f":"+Method_input!BB17","v":23.9},{"$f":"+Method_input!BC17","v":17.68},{"$f":"+Method_input!BD17","v":9.5},{"$f":"+Method_input!BE17","v":5.6},{"$f":"+Method_input!BF17","v":12.24},{"$f":"+Method_input!BG17","v":19.170000000000002}]
[null,null,null,null,null,null,"Auxiliary data: Heating interval?",null,{"$f":"I23=\"H\"","v":false},{"$f":"J23=\"H\"","v":false},true,true,true,true,true,true,false,false,false,false,false,true,true,true,true,true,true,false,false,false,false,true,true,true,true,true,true,false,false,false,false,false,true,true,true,true,true,false,false,false,false,false,false,true,true,true,false]
["Measured heating power ","Φdel,t;meas;H  ","kW","See array","(11)",null,null,null,{"$f":"IF(I28,I22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(J28,J22-$D$26,#N/A)","v":{"$error":"#N/A"}},1.3587796624331547,2.3338200719159135,3.352139037433155,3.4237299465240643,5.6583890374331549,4.1790140374331548,{"$error":"#N/A"},{"$f":"IF(R28,R22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(S28,S22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(T28,T22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(U28,U22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(V28,V22-$D$26,#N/A)","v":1.705548128342246},{"$f":"IF(W28,W22-$D$26,#N/A)","v":3.1964704327819922},{"$f":"IF(X28,X22-$D$26,#N/A)","v":3.9427640374331547},{"$f":"IF(Y28,Y22-$D$26,#N/A)","v":4.5333890374331549},{"$f":"IF(Z28,Z22-$D$26,#N/A)","v":3.6945303417809807},{"$f":"IF(AA28,AA22-$D$26,#N/A)","v":1.4742544220485396},{"$f":"IF(AB28,AB22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AC28,AC22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AD28,AD22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AE28,AE22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AF28,AF22-$D$26,#N/A)","v":0.31463903743315513},{"$f":"IF(AG28,AG22-$D$26,#N/A)","v":2.5892484124331552},{"$f":"IF(AH28,AH22-$D$26,#N/A)","v":3.2424515374331482},{"$f":"IF(AI28,AI22-$D$26,#N/A)","v":3.7830765374331707},{"$f":"IF(AJ28,AJ22-$D$26,#N/A)","v":4.1878533231474409},{"$f":"IF(AK28,AK22-$D$26,#N/A)","v":2.7009371143562317},{"$f":"IF(AL28,AL22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AM28,AM22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AN28,AN22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AO28,AO22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AP28,AP22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AQ28,AQ22-$D$26,#N/A)","v":2.9977640374331549},{"$f":"IF(AR28,AR22-$D$26,#N/A)","v":4.4208890374331551},{"$f":"IF(AS28,AS22-$D$26,#N/A)","v":3.5490140374331549},{"$f":"IF(AT28,AT22-$D$26,#N/A)","v":4.9886624749331547},{"$f":"IF(AU28,AU22-$D$26,#N/A)","v":3.7121390374331549},{"$f":"IF(AV28,AV22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AW28,AW22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AX28,AX22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AY28,AY22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(AZ28,AZ22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(BA28,BA22-$D$26,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(BB28,BB22-$D$26,#N/A)","v":1.435393754414287},{"$f":"IF(BC28,BC22-$D$26,#N/A)","v":2.6191582682023857},{"$f":"IF(BD28,BD22-$D$26,#N/A)","v":0.72936361370434155},{"$f":"IF(BE28,BE22-$D$26,#N/A)","v":{"$error":"#N/A"}}]
["Corresponding temperature","ϑext,t","°C",null,null,null,null,null,{"$f":"IF(I28,I27,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(J28,J27,#N/A)","v":{"$error":"#N/A"}},10.7,5.8,3.3,3.35,2.67,5.85,{"$error":"#N/A"},{"$f":"IF(R28,R27,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8.9600000000000009,6.88,2.4500000000000002,3.48,6.61,9.9499999999999993,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.4,7.45,4.6500000000000004,3,2.69,7.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5.77,1.9,3.83,2.5499999999999998,5.45,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},9.5,5.6,12.24,{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,"Auxiliary data: Non heating interval?",null,{"$f":"I23=\"nH\"","v":true},false,false,false,false,false,false,false,false,true,true,true,false,false,false,false,false,false,false,false,true,true,false,false,false,false,false,false,false,false,true,true,{"$f":"AO23=\"nH\"","v":true},false,false,false,false,false,false,false,false,true,true,true,false,false,false,false,false]
["Measured non-heating power ","Φdel,t;meas;nH  ","kW",null,null,null,null,null,{"$f":"IF(I32,I22,#N/A)","v":0.2095766129032258},{"$f":"IF(J32,J22,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.19687499999999999,0.1900862068965517,0.14273437499999997,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.18593749999999998,0.19687499999999999,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.29531249999999998,0.19052419354838709,0.17499999999999999,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.27794117647058819,0.23473557692307692,0.16578947368421051,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Corresponding temperature","ϑext,t","°C",null,null,null,null,null,{"$f":"IF(I32,I27,#N/A)","v":23.25},{"$f":"IF(J32,J27,#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},19.3,23.7,26.8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},23.6,21.01,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},18.760000000000002,23.3,22.8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},15.8,19.3,23.9,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Normalised internal temperature","ϑint,norm","°C",20]
["Normalised degree days","DDnorm","°Cdays",{"$f":"+Method_input!E41","v":2293}]
["Season duration","tseas","days",183]
["Seasonal average external temperature","ϑext;avg","°C",{"$f":"20-(D37/D38)","v":7.4699453551912569},null,null,null,null,null,null,null,0,{"$f":"MAX(I22:BE22)","v":5.85}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D45","v":2.9699453551912569},{"$f":"+D45","v":2.9699453551912569}]
["Temperature increase because of gains","Δϑgains","°C",2]
["Expected external temperature with heating off","ϑext;H;OFF,exp","°C",{"$f":"+D36-D41","v":18}]
["External temperature with heating off","ϑext;H;OFF,real","°C",13.5]
["Correction for indoor temperature",null,"°C",{"$f":"+D42-D43","v":4.5}]
["Corrected average external temperature","ϑext;avg;corr","°C",{"$f":"+D39-D44","v":2.9699453551912569}]
["Power at corrected average external temperature",null,"kW",4.3,null,null,"See graph"]
["Base power",null,"kW",0.19]
["Average heaeting power",null,"kW",{"$f":"+D46-D47","v":4.1099999999999994}]
[]
["Normalised deliverd energy","Edel;meas;H;seas,norm","kWh",{"$f":"+D48*D38*24","v":18051.119999999995},null,null,"Output data"]
[]
[]
[]
[]
[]
[]
["Fuel used",null,null,null,null,"No calculation. Just pass the information to subsequent modules to appy the relevant weuighting factors for deliverd energy","Method output"]

{"sheet":"Method_output","index":5,"n_rows":28,"n_cols":9,"rows_kept":28,"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","Software name","Unit","Value","Range","Intended destination","Varying","Notes"]
["Energy flow data"]
[]
["Normalised deliverd energy","Edel;meas;H;seas,norm",null,"kWh",{"$f":"+Method_calculation!D50","v":18051.119999999995}]
[]
[]
[]
[]
[]
["Operating condition data"]
["Flow rate"]
[]
[]
[]
[]
[]
["Other data"]
["Fuel type","BLR_FUEL","BLR_FUEL","List",{"$f":"+Method_calculation!D57","v":0},"List","M3-1","Yes","Needed to apply the right weighting factors"]
[]
[]
[]
["Recoverable heat","QH;gen;ls;rbl  ","Q_H_gen_ls_rbl  ","kWh",96.168150420264951,"0...∞","M2-2","Yes","Recoverable heat for heating "]
["Total auxiliary energy ","WH;gen;aux","W_H_gen_aux","kWh",137.26301472639065,"0...∞","M3-1","Yes","Boiler auxiliary energy"]
["Temperature 1"]
["Temperature 2"]

{"sheet":"History","index":6,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[]
[null,"2014-01-14","Issued for discussion "]

{"sheet":"Foglio2","index":7,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,13.2,null,null,null,null,null,14.9]
[null,null,null,null,null,null,null,null,null,31,28,31,15,null,null,null,null,null,15,30,31]
[null,null,null,null,null,null,null,"Temperatura media","[°C]",3.3,4.8,8.6,{"$f":"+(M17*3+L19)/4","v":12.049999999999999},17.3,21.3,23.6,23.4,20.399999999999999,{"$f":"+(S17*3+T19)/4","v":13.55},9.5,5]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(J21:U21)","v":2292.6999999999998},{"$f":"+(20-J19)*J18","v":517.69999999999993},{"$f":"+(20-K19)*K18","v":425.59999999999997},353.40000000000003,119.25000000000001,null,null,null,null,null,{"$f":"+(20-S19)*S18","v":96.749999999999986},315,465]