{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["INFO","Product_descriptive_data","Product_tech_data","Process_design_data","Data_catalogue_example","Input_series","Method_input","Method_calculation","Output_series","Method_output","History","Avrami curve","Feuil2"],"not_rendered":{"charts":2,"images":34,"macros":1,"external_links":0,"defined_names":57,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INFO","index":0,"n_rows":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":1,"n_rows":55,"n_cols":3,"rows_kept":55,"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_C_TYPE",{"$f":"INDEX(C11:C13,A9)","v":"STO_C_PCM"}]
[]
["Cold water storage",null,"STO_C_W"]
["Ice storage",null,"STO_H_ICE"]
["Phase Change Material (PCM) storage",null,"STO_C_PCM"]
[]
[]
["Storage use"]
[4,"STO_C_USE",{"$f":"INDEX(C19:C22,A17)","v":"STO_C_USE"}]
[]
[" ",null," "]
[" ",null," "]
[" ",null," "]
["Cooling",null,"STO_C_USE"]
[]
[]
["Fuel"]
[4,"STO_C_FUEL",{"$f":"INDEX(C28:C32,A26)","v":"STO_FUEL_EL"}]
[]
[]
[]
[]
["Electricity",null,"STO_FUEL_EL"]
[]
[]
[]
["CE Marking"]
[1,"STO_C_CE",{"$f":"INDEX(C38:C39,A36)","v":"STO_C_DATA_YES"}]
[]
["Storage unit is marked CE",null,"STO_C_DATA_YES"]
["Storage unit is NOT marked CE",null,"STO_C_DATA_NO"]
[]
[]
["Storage control type"]
[2,"STO_C_CTRL_POW",{"$f":"INDEX(C45:C47,A43)","v":"STO_C_CTRL_POW_CRM"}]
[]
["Single thermostatic/pressure control (ON-OFF)",null,"STO_C_CTRL_POW_ONOF"]
["Thermostat and external signal authorization ( e.g. cost reflective message for low cost storage)",null,"STO_C_CTRL_POW_CRM"]
["Other",null,"STO_C_CTRL_POW_OTH"]
[]
[]
["Storage  type (sizing)"]
[2,"STO_C_SIZING",{"$f":"INDEX(C53:C55,A51)","v":"STO_C_ACC_50"}]
[2]
["Accumulation",null,"STO_C_ACC_100"]
["Semi accumulation",null,"STO_C_ACC_50"]
["Shifting peak period",null,"STO_C_OFF_PEAK"]

{"sheet":"Product_tech_data","index":2,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,3],[84,7,84,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);","VC;sto","l",1000]
[" "," "," "]
["§"]
["A.1.2.2      Standby losses","HC;sto;stb","WK",5.8,null,{"$f":"D8*60*24","v":8352}]
[]
["A.1.3. Caracteristic of material used for cooling storage"]
[]
[]
[]
[null,null,null,null,null,"qtr","Qlat","Qsens,sol","Qsens,liq","Kv,cr","Kv,fu","r","quse,min","quse,max"]
["Data table"," Symbol","Unit","Value","Water",0,93,"0,54+0,17%/K",1.1599999999999999,1,1,1000,-40,90]
["Transition Temperature (liquid- solid) ","Jtr","°C",{"$f":"INDEX(F$15:F$23,$D$25,1)","v":-33},"PCM  SN33",-33,44.6,0.7,1.08,1.6,2.2000000000000002,724,-40,60]
["Latent heat capacity","Qlat","kWh/m3",{"$f":"INDEX(G$15:G$23,$D$25,1)","v":44.6},"PCM  SN29",-28.9,39.299999999999997,0.8,1.1499999999999999,1.6,2.2000000000000002,681,-40,60]
["Sensible heat capacity in liquid phase","Qsens,sol","kWh/°C.m3",{"$f":"INDEX(H$15:H$23,$D$25,1)","v":0.7},"xx",-15.4]
["Sensible heat capacity in solid phase","Qsens,liq","kWh/°C.m3",{"$f":"INDEX(I$15:I$23,$D$25,1)","v":1.08},"xx",-11.7]
["Conductance for cristalisation","Kv,cr","kWh/m3",{"$f":"INDEX(J$15:J$23,$D$25,1)","v":1.6},"xx",-10.4]
["Conductance for melting","Kv,fu","kWh/m3",{"$f":"INDEX(K$15:K$23,$D$25,1)","v":2.2000000000000002},"xa",-5.5]
["density","r","kg/m3",{"$f":"INDEX(L$15:L$23,$D$25,1)","v":724},"IN.03",-2.6,48.3,0.8,1.2,1.6,2.2000000000000002,558,-25,60]
["Minimum temperature for use ","Juse,min","°C",{"$f":"INDEX(M$15:M$23,$D$25,1)","v":-40},"xe",0]
["Maximum temperature for use ","Juse,max","°C",{"$f":"INDEX(N$15:N$23,$D$25,1)","v":60}]
["Your selection",null,null,2]
[null,null," "," "]
["A.1.1.4. Caracterisation of  feed up system to storage"]
["Seasonal performance of cooling production","COPC;gen;sto","-",3.25]
["CE Marking","STO_C_CE","logical",1]
["Power (pump)","fC;sto;pmp;out","kW",0.06]
["Mass flow rate (nominal)","DVC;gen;sto;aux","m3/h",0.3]
[]
[]
["A.1.1.5. Caracterisation of  pump and pipes to deliver 'cooling' to users"]
["Thermal losses of the secondary system ","HC;sto;dis;ls","W/K",20]
["Power","fC;sto;pmp;in","kW",0.06]
["Mass flow rate (nominal)","DVC;sto;use","m3/h",0.3]

{"sheet":"Process_design_data","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"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_C_LOC",{"$f":"INDEX(C11:C14,A9)","v":"STO_C_LOC_CHL"},null,"qamb "]
[null,null,null,null,"°C"]
["Heated space",null,"STO_C_LOC_INT",null,20]
["Unheated room",null,"STO_C_LOC_UNH",null,5]
["Storage (or chiller) room",null,"STO_C_LOC_CHL",null,15]
["External",null,"STO_C_LOC_EXT",null,-10]
["Selected value",null,null,null,{"$f":"INDEX(E11:E14,$A$9)","v":15},"°C"]
[]
[]
[]
["type of control"]
[]
["Continous operation",null,"STO_CTRL_CONT"]
["Time schedule operation",null,"STO_CTRL_TIME"]
["Temperature control",null,"ST0_CTRL_TEMP"]
[null,null,null,null," "," "]
[" "," "," ",null,"Value","Unit"]
["Control factor for stroage","fC;sto;ctrl","f_C_sto_ctrl",null,1,"-"]

{"sheet":"Data_catalogue_example","index":4,"n_rows":108,"n_cols":24,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,9,0,21],[0,23,0,31]]}
["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 FLUID or PCM USED",null,null,null,null,null,null,null,null,null,null,null,null,null,"SELECTION OF PCM COMPATIBLE WITH THE QUALITATIVE DESCRIPTION"]
[]
[]
[" Product descriptive data (qualitative)"]
[]
["Storage type"]
[1,null,"STO_USE",{"$f":"INDEX(D9:D11,A7)","v":"STO_USE_C"}]
[]
["Cooling",null,null,"STO_USE_C"]
[" ",null,null," "]
[" ",null,null," "]
[]
[]
["Fluid used for storage"]
[2,null,"STO_FLUID",{"$f":"INDEX(D17:D18,A15)","v":"STO_FL_PCM"}]
["Cold water",null,null,"STO_FL_CWAT"]
["Ice",null,null,"STO_FL_ICE"]
["Phase Change Material",null,null,"STO_FL_PCM"]
[]
[]
["CE Marking"]
[2,"STO_C_CE",{"$f":"INDEX(C24:C25,A22)","v":"STO_C_DATA_NO"}]
[" "]
["Storage unit is marked CE",null,"STO_C_DATA_YES"]
["Storage unit is NOT marked CE",null,"STO_C_DATA_NO"]
[]
[]
["Storage control type"]
[3,"STO_CTRL_POW",{"$f":"INDEX(C31:C33,A29)","v":"STO_CTRL_POW_OTH"}]
[]
["Single thermostatic control (ON-OFF)",null,"STO_C_CTRL_ON"]
["Thermostat and external signal authorization ( e.g. cost reflective message for electricity)",null,"STO_CTRL_POW_CRM"]
["Other",null,"STO_CTRL_POW_OTH"]
[" "]
[]
["Product technical data"]
[]
[]
[]
["System design data"]
[]
["Localisation",null,"LOC",{"$f":"INDEX(D45:D48,C43)","v":"LOC_CLR"}]
[null,null,3]
["Values"]
["Heated space",null,null,"LOC_INT"]
["Unheated space",null,null,"LOC_UNH"]
["Chiller room",null,null,"LOC_CLR"]
["External",null,null,"LOC_EXT"]
[]
[]
["Operating conditions"]
[]
[]
[]
["Description",null,"Variable TAG","Option tag","Symbol","Unit","Value","Range",null," "," "," "," "," ",null," "," "," "]
["Volume",null,"no",null,"VSTO,C","l",1200,"0-1000"]
["diameter of tube",null,"no",null,"DSTO,C","m",0.03,"0-0,1"]
["Lenght of tube",null,"no",null,"LSTO,C","m",80,"0-1000"]
["Percentage of volume used by PCM",null,"no",null,"VSTO,C,PCM","%",60,"0-100"]
["Use Type",null,"yes",null,null,null,{"$f":"INDEX(D9:D11,A7)","v":"STO_USE_C"}]
["CE marking",null,"no",null,null,null,{"$f":"INDEX(C24:C25,A22)","v":"STO_C_DATA_NO"}]
["Standby losses transmission coefficient",null,null,null,"HSTO,C,STBL","W/K",{"$f":"Product_tech_data!D8","v":5.8}]
["Temperature set point of the storage",null,"no",null,"qSTO,C,set,1","°C",4]
[null,null,null,null,null," "]
[]
[" Caracteristic of material used for cooling storage"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
["Data table",null,null,null,null,null,{"$f":"INDEX(H$71:I$80,$G$81,1)","v":"PCM"},null,"qtr","Qlat","Qsens,sol","Qsens,liq","Kv,cr       l(water)","Kv,fu       l(water)","rsld ","rliq  ","hsto,C","% of volume used for PCM"]
["Transition Temperature (liquid- solid) ",null,null,null,"qtr","°C",{"$f":"INDEX(I$71:I$80,$G$81,1)","v":0},"Water",0,93,0.54,1.1599999999999999,0.55000000000000004,2.1,1000,900,1," "]
["Latent heat capacity",null,null,null,"Qlat","kWh/kg",{"$f":"INDEX(J$71:J$80,$G$81,1)","v":20},"PCM",0,20,0.1,0.4,1.1499999999999999,1.85,600,600,0.9,60]
["Sensible heat capacity in solid phase",null,null,null,"Cpsens,sld","kWh/°C.kg",{"$f":"INDEX(K$71:K$80,$G$81,1)","v":0.1},"AC 00",0,{"$f":"48.4/O73","v":8.6428571428571424E-2},{"$f":"0.7/O73","v":1.25E-3},{"$f":"1.1/P73","v":1.9642857142857144E-3},1.1499999999999999,1.85,560,560,0.9,60]
["Sensible heat capacity in liquid phase",null,null,null,"Cpsens,liq","kWh/°C.kg",{"$f":"INDEX(L$71:L$80,$G$81,1)","v":0.4},"AN 03",-2.6,{"$f":"48.3/O74","v":8.1587837837837837E-2},{"$f":"0.8/O74","v":1.3513513513513514E-3},{"$f":"1.2/P74","v":2.0270270270270271E-3},1.1499999999999999,1.85,592,592,0.9,60]
["Conductance for cristalisation",null,null,null,"Kv,cr       l(water)","kW/°C.kg",{"$f":"INDEX(M$71:M$80,$G$81,1)","v":1.1499999999999999},"AN 06",-5.5,{"$f":"44.6/O75","v":7.1360000000000007E-2},0.75,1.1000000000000001,1.1499999999999999,1.85,625,625,0.9,60]
["Conductance for melting",null,null,null,"Kv,fu       l(water)","kW/°C.kg",{"$f":"INDEX(N$71:N$80,$G$81,1)","v":1.85},"AN10",-10.4,49.9,0.7,1.07,1.1499999999999999,1.85,617,617,0.9,60]
["density (liquid phase)",null,null,null,"rliq  ","kg/m3",{"$f":"INDEX(O$71:P$80,$G$81,1)","v":600},"AN 12",-11.7,47.7,0.75,1.0900000000000001,1.1499999999999999,1.85,620,620,0.9,60]
["density (solid phase)",null,null,null,"rsol  ","kg/m3",{"$f":"INDEX(P$71:P$80,$G$81,1)","v":600},"AN 15",-15.4,46.4,0.7,1.1200000000000001,1.1499999999999999,1.85,602,602,0.9,60]
["Coefficient of filling - nodules",null,null,null,"hPCM","-",{"$f":"INDEX(Q$71:Q$80,$G$81,1)","v":0.9}," "," ",null,null,null," "," "," "," ",0.9,60]
[" ",null,null,null," "," ",{"$f":"INDEX(R$71:R$80,$G$81,1)","v":60}," "," ",null,null,null,null,null,null,null,0.9,60]
["Your selection",null,null,null,null,null,2]
[]
[]
[" Caracterisation of  system for storage",null,null,null,null,null,null,null,null,{"$f":"333/3.6","v":92.5}]
["Seasonal performance of cooling production",null,null,null,"COPC;gen","-",{"$f":"Product_tech_data!D28","v":3.25}]
["Set temperature ",null,null,null,"qC;gen;sto","°C",-4]
["CE Marking",null,null,null,"COPsto,C,gen,DATA","logical",{"$f":"Product_tech_data!D29","v":1}]
["Power",null,null,null,"fC;sto;pmp;out","kW",{"$f":"Product_tech_data!D30","v":0.06}]
["Mass flow rate (nominal)",null,null,null,"qC;sto;v;pmp;out","m3/h",0.65]
[]
[]
[" Caracterisation of  pump to deliver 'cooling' to users"]
["Thermal losses of the secondary system ",null,null,null,"HC;sto;dis;ls;in","W/K",{"$f":"Product_tech_data!D35","v":20}]
["Power",null,null,null,"fC;sto;pmp;in","kW",{"$f":"Product_tech_data!D36","v":0.06}]
["Mass flow rate (nominal)",null,null,null,"qC;sto;v;pmp;in","m3/h",{"$f":"Product_tech_data!D37","v":0.3}]
[]
[]
[null,null,null,null," "]
["part of the thermal losses energy recoverable",null,null,null,"fC;sto;rvd;stb","-",1,"0 …. 1"]
["part of the thermal losses not recovered",null,null,null,"fC;sto;rbl","-",0,"0 …. 1"]
["part of the auxiliary energy recovered",null,null,null,"fC;sto;aux ","-",0.75,"0 …. 1"]
["part of the nominal electrical power not transmitted to the distribution sub-system",null,null,null,"fC;sto;aux;rbl ","-",0.25,"0 …. 1"]
[]
[null,null,null,1]
[]
[]
["System design data"]
["Installation room temperature;",null,null,null,"qsto,amb","°C",15]

{"sheet":"Input_series","index":5,"n_rows":35,"n_cols":14,"rows_kept":35,"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,null,13]
["Number of time steps",null,null,12]
[]
["Description","Calculation interval duration","hour of the day","Ambient air temperature","Energy required (for cooling demand","Temperature required for cooling","temperature difference (generation to transition)","Room temperature","Temperature of the medium in the storage","Temperature exhanger (distribution)","Mass of liquid phase (initial)","Temperature of the solid phase","cooling st0rage control"]
["Symbol","tci ","nnd ","Je ","QC;dis;in;tot;req","JC;sto;dis;in;req","DJC;sto;gen;flw","Jsto;amb ","JC;sto","JC;sto;exh ","Msto,fl,sld","JC;sto;sld;0","CLG_STO_CTRL","fC;sto;ctrl"]
["Unit","h","h","°C","kWh","°C","°C","°C","°C","°C","kg","-","-"]
["Origin","-","-","x","x","x","x","x","x","x"]
["Origin","M4-1","M1-9","M1-13","M4-9","M4-9","M4-6","M1-9","Local","Local","Local","M4-12","Local","M10-12"]
[]
[" "]
["Time stamp",null,null,null,null,"VALUES"]
[1,1,12,20,2,4,-4,15,0,4,50,0,"CONT",1]
[2,1,12,20,2,4,-6,15,0,4,50,0,"CONT",1]
[3,1,12,20,2,4,-6,15,0,4,40,0,"CONT",1]
[4,1,12,20,2,4,-6,15,0,4,50,0,"CONT",1]
[5,1,12,20,-2,4,-6,15,0,4,50,0,"CONT",1]
[6,1,12,20,-2,4,-6,15,0,4,50,0,"CONT",1]
[7,1,12,20,-1,4,-6,15,0,4,20,0,"CONT",1]
[8,1,12,20,0,4,-6,15,0,4,50,0,"CONT",1]
[9,1,12,20,0,4,-6,15,0,4,50,0,"CONT",1]
[10,1,12,20,-3,4,-6,15,0,4,50,0,"CONT",1]
[11,1,12,20,-3,4,-6,15,0,4,60,0,"CONT",1]
[12,720,12,20,-72,4,-6,15,0,4,78,0,"CONT",1]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Method_input","index":6,"n_rows":71,"n_cols":12,"rows_kept":71,"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","Computed Symbol","Unit","Value","Range","Origin","Varying","Notes"]
["Operating conditions data"]
["Duration of the time step","tci ","t_ci ","h",720,"0…8760","M3-1","NO","neutralised"]
["Hour of theday","nnd ","n_nd ","h",12,"0…8760","M3-1","NO","neutralised"]
["Ambient air temperature","Je","theta_e","°C",20,"0…8760","M3-1","NO"]
["Energy required for cooling use","QC;dis;in;tot;req","Q_C_dis_in_tot_req","kWh",-72,"].∞; +∞[","M4-9","NO","positive or negative"]
["Average temperature required for cooling (Min)","JC;dis;in;req","theta_C_sto_dis_in_req","°C",4,"-100,100","M4-9","NO","idem"]
["Temperature difference of primary circuit vs transition temperature(input to storage)","JC;gen;flw","theta_C_gen_flw","°C",-6,"0...∞","M4-9","YES","neutralised"]
["Room temperature","Jsto;amb","theta_sto_amb","°C",15,"-100,100","M4-8","NO"]
["Temperature of storage unit","JC;sto","theta_C_sto","°C",0,"-100,100",null,"YES"]
["Temperature exhanger (dsitribution side)","JC;sto;exh","theta_C_sto_exh","°C",4,"0...∞","Local","YES"]
["Mass of solid phase","mC;sto;sld","m_C_sto_sld","kg",78,"0...∞","Local","YES",null,null," "," "]
["Mass of liquid phase (PCM)","mC;sto;lqd","m_C_sto_lqd","kg",0,"0...∞","Local","YES",null,null," "," "]
["Cooling strorage control","CLG_STO_CTRL","CLG_STO_CTRL","-","CONT","List","Local","NO",null,null," "]
["Storage control operation factor","fC;sto;ctrl","f_C_sto_ctrl","-",1,"0…1","M10-12","YES"]
[]
["System data"]
[]
["Product data"]
["Cooling production information"]
["Seasonal performance of cooling production","COPC;sto;gen ","COP_C_gen_sto ","-",{"$f":"Data_catalogue_example!$G$85","v":3.25},null,null,null,"not used in this version"]
["CE Marking","COPC;gen;stoDATA","COP_C_gen_sto_DATA","logical",{"$f":"Data_catalogue_example!$G$87","v":1},null,null,null,"not used in this version"]
["Energy losses (pipes, heat exchanger)","HC;sto;out;ls","H_C_sto_out_ls","W/K",5.8,"0-1000",null,"NO"]
["Circulator power from cooling production","fC;sto;pmp;out","P_C_sto_pmp_out","kW",0,"0-100","Local","NO","neutralised as accounted in the generation part"]
["Circulator mass flow","qC;sto;v;pmp;out","q_C_sto_v_pmp_out","m3/h",0.65,"0-500","Local","NO"]
[]
["Storage technical data "," "," "," "," "," "," "," "]
["Volume of fluid used for heat transfer","VC;sto;tot","V_C_sto_tot","l",{"$f":"Data_catalogue_example!G56","v":1200},"0…100000","Local","NO"," volume participating to storage (PCM modules) -Equal to  0 for ice or water storage"]
["Diameter of tube","DC;sto","D_C_sto","m",{"$f":"Data_catalogue_example!G57","v":0.03},"0-0,1","Local","No","Relevant for Water/Ice storage only"]
["Lenght of tube","LC;sto","L_C_sto","m",40,"0-10000","Local","No","Relevant for Water/Ice storage only"]
["Percentage of volume used by PCM","VC;sto;PCM","V_C_sto_PCM","%",{"$f":"Data_catalogue_example!G59","v":60},"0_100","Local","No","Relevant fo rPCM only"]
["Sensible heat capacity of fluid for heat transfer","Cpsto;sens","Cp_sto_sens_med","kWh/°C.m3",1.1599999999999999]
["Density of fluid ","rsto;lqd","rau_sto","kg/m3",1000]
["Thermal losses coefficient of storage unit","HC;sto;tot;ls","H_C_sto_tot_ls","W/K",{"$f":"Data_catalogue_example!G62","v":5.8},"0-1000","Local",null," "]
["Type of storage (PCM, ice, water)","TYPE_STO_MAT","TYPE_STO_MAT","-",{"$f":"+Data_catalogue_example!$G$70","v":"PCM"},{"$f":"Data_catalogue_example!G81","v":2}]
["Transition Temperature (liquid- solid) ","qtr","theta_tr","°C",{"$f":"+Data_catalogue_example!G71","v":0}]
["Latent heat capacity","Qlat","Q_lat","kWh/kg",{"$f":"+Data_catalogue_example!G72","v":20}]
["Sensible heat capacity in solid phase","Cpsens,sld","Cp_sens_sld","kWh/°C.kg",{"$f":"+Data_catalogue_example!G73","v":0.1}]
["Sensible heat capacity in liquid phase","Cpsens,lqd","Cp_sens_lqd","kWh/°C.kg",{"$f":"+Data_catalogue_example!G74","v":0.4}]
["Conductance for cristalisation","Kv,cr","Kv_cr",{"$f":"IF(Data_catalogue_example!$G$81=1,H43,D42)","v":"kWh/°C.kg"},{"$f":"+Data_catalogue_example!G75","v":1.1499999999999999},null,null,"W/m.°C"]
["Conductance for melting","Kv,fu","Kv_fu",{"$f":"IF(Data_catalogue_example!$G$81=1,H44,D43)","v":"kWh/°C.kg"},{"$f":"+Data_catalogue_example!G76","v":1.85},null,null,"W/m.°C"]
["density (liquid phase)","rlqd","rau_lqd","kg/m3",{"$f":"+Data_catalogue_example!G77","v":600}]
["density (solid phase)","rsld","rau_sld","kg/m3",{"$f":"+Data_catalogue_example!G78","v":600},null,null," "]
["Volume used for PCM modules","Vsto,pcm","V_sto_pcm","l",{"$f":"Data_catalogue_example!G59/100*Data_catalogue_example!G56","v":720}]
[" "," "," "," "," "]
["part of the thermal losses recoverable","frvd,ls","f_rvd_ls",null,{"$f":"+Data_catalogue_example!G99","v":1},"0… 1","Local","NO"]
["part of the auxiliary energy recoverable","frvd,aux ","f_rvd_aux ","-",{"$f":"+Data_catalogue_example!G101","v":0.75},"0…1","Local","NO"]
["part of the nominal electrical power not transmitted to the distribution sub-system","frbl,aux ","f_rbl_aux ","-",{"$f":"+Data_catalogue_example!G102","v":0.25},"0.1","Local","NO"]
[]
["Storage distribution data "]
["Circulator power to 'USERS'","fC;sto;pmp;in","P_C_sto_pmp_in;","kW",0,"0-100","Local","NO","neutralised as accounted in the distribution part"]
["Circulator mass flow","qC;sto;v;pmp;in","q_C_sto_v_pmp_in","m3/h",0.9,"0-500","Local","NO"]
["Difference Temperature of primary circuit vs transition temperature(input to storage)","DqC;sto;flw;in","delta_theta_C_sto_in_flw","°C",{"$f":"E10-E13","v":4},"-100,100",null,"NO"]
["Energy losses (pipes, heat exchanger)","HC;sto;ls;in","H_C_sto_ls_in","W/K",5.8,"0-1000",null,"NO"]
[]
["System design data"]
["Process design"]
["storage room temperature;","qsto;amb","theta_sto_amb","theta_sto_amb",{"$f":"+Data_catalogue_example!G108","v":15},"-50…+50","Local","Yes"]
[" "," "," "," "]
["Control type data"]
["Thermostat","Tsto,C,set ","T_C_sto_set ","T_C_sto_set ",0,"-50…+50","Local","YES"]
[null,null,"d_C_sto_max","d_C_sto_max",3.5000000000000003E-2,"0-1","Local","No"]
[]
["Constants"]
["Water specific heat","Cp;w ","Cp_w ","Cp_w ",1.1599999999999999,null,null,"NO"]
[]
["Model Information"]
["Number of layers for the storage model","NSTO,vol","N_STO_vol","N_STO_vol",1,null,null,"NO"]

{"sheet":"Method_calculation","index":7,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,6],[30,8,30,9]]}
["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"]
[]
["Energy required for  cooling distribution system ","QC;in;tot;req","kWh",{"$f":"Q_C_dis_in_tot_req","v":-72},"-",null,"Corresponding to the difference between energy input from the distribution and energy extracted from the generation"]
[null,"QC;sto;dis;in","kWh",0,null,"net energy used for distribution","undertermined as new formula introduces the difference beteween used and extracted energy (see above)"]
["Energy available from cooling production unit","QC;sto;gen;out","kWh",0,"-","net energy extracted from the generation unit","undertermined as new formula introduces the difference beteween used and extracted energy (see above)"]
["Type of material for storage","STO_TYPE","-",{"$f":"Method_input!E38","v":"PCM"}]
["Single storage and monozone calculation",null,null," "]
["Step 1 Energy stored"]
["Liquid mass","mC;sto;lqd,0","kg",{"$f":"IF(Method_input!F38=1,0,Method_input!E45*Method_input!E47/1000-Method_input!E15)","v":354}]
["Sensible heat available (liquid)","QC;sto;sens;lqd","kWh",{"$f":"(Method_input!E42*Method_calculation!D11/Method_input!E45+Method_input!E31*Method_input!E35/Method_input!E36)*(Method_input!E10-Method_input!E13)","v":6.5119999999999996},"Formula (2)",null," "]
["Latent heat available","QC;lat","kWh",{"$f":"IF(Method_input!E15>0,Method_input!E40*Method_input!E15/1000,0)","v":1.56},"Formula (3)"]
["Sensible heat available (solid)","QC;sto;lat","kWh",{"$f":"IF(Method_input!E15>1,Method_input!E$41*Method_input!E$15*(Method_input!E39-Method_input!E12)/2/Method_input!E45,0)","v":-9.7500000000000017E-2},"Formula (4)",null,"need correction to consider the temperature gradient inside the solid phase (see difference of sheet 'Avrami')"]
["Energy stored comply to satisfy need for energy used"," ","logical",{"$f":"TRUE()","v":true},"Formula (5)"]
["Energy variation in the storage","DQC;sto;in","kWh",{"$f":"MIN(SUM(D$12:D$14), Q_C_dis_in_tot_req*f_C_sto_ctrl)","v":-72},null,"positive means reduction of the energy stored","negative value mean 'storage'"]
[]
["Step2- Energy balance when storage capacity is delivered to heat exchanger","QC;gen;out"," ",null,null,null,"If energy used and enegy produced are equal to 0, this step corresponds to a standby mode"]
["Initial temperature in the storage unit","qsto,C","°C",{"$f":"Method_input!E13","v":0},"-"]
["Energy gain due to thermal transfer in the generation circuit"," Qsto,C,out,ls","kWh",{"$f":"H_C_sto_out_ls*(theta_sto_amb-theta_C_gen_flw)/1000*t_ci","v":87.695999999999998},"Formula (7)"]
["Energy gain due to thermal transfer in the distribution circuit"," QC;sto;in;ls","kWh",{"$f":"Method_input!E$57*(theta_sto_amb-theta_C_sto_dis_in_req)/1000*t_ci","v":45.936},"Formula (8)",null," "]
["Energy gain due to thermal transfer (standby losses)in the storage unit"," QC;sto;ls","kWh",{"$f":"Method_input!E37*(Method_input!E61-theta_C_sto)/1000*t_ci","v":62.639999999999993},"Formula (9)"]
["Duration of operation for auxiliary pump (Heat exchanger) expressed as part of the step time"," tC;sto;aux;in","h",{"$f":"MAX(D$6/(Method_input!E$42*Method_input!E$55*(Method_input!E10-Method_input!E13)),0)","v":0},"Formula(23)"]
[" "," "," "," ",null," "," "]
["Step3a -  Evolution of solid and liquid phase after energy use from the storage unit (WATER)"," ",null,null,null," "]
["Potential Energy to be transformed","DQC;sto","kWh",{"$f":"D22+D21+D20+D16","v":124.27199999999999},"formula (10)","corresponds to energy available (D14) completed with gain from thermal losses"]
["Step 3a Water (ice and iced water)"]
["Energy transformed","QC;sto;in,tmp1","kWh",{"$f":"MIN(D26,D14+D15)","v":0.90249999999999997},null,"If Q>0 then reduction of the solid mass -if Q<0 then storage)"," "]
["Maximum mass to be stored","m_C;sto;sld;max","kg",{"$f":"Method_input!E33*Method_input!E46*3.14*((Method_input!E32+d_sto_C_max)^2-Method_input!E32^2)/4","v":62.643000000000015},null,null,"corresponds to dsto,C,max"]
["Thickness of the ice around the tube before at beginning of step time"," dC;sto;0","m",{"$f":"IF(Method_input!F$38=1,(SQRT(Method_input!E$32^2/4+Method_input!E$15/(3.14*Method_input!E$46*Method_input!E$33))-Method_input!E$32/2),0)","v":0},"formula (11)",null,null,null," "," "]
["Variation of mass of the solid phase ","DmC;sto;sld,tmp1","kg",{"$f":"IF(TYPE_STO_MAT=1,-D$28/(Method_input!E$40+Method_input!E$41*(Method_input!E$13+Method_input!E$12)/2)*Method_input!E$46,0)","v":0},"formula (12)",null,null,null,"dsto,C,tmp1 = solution of A.d2+ B.d +C = 0 w"]
["Limitation as the solid mass shall not exceed the limit value ","DmC;sto;sld;tmp2","kg",{"$f":"IF(TYPE_STO_MAT=1,MIN(D29-Method_input!E15,Method_calculation!D31),0)","v":0},null,"Dmsto,C,sld,tmp1+msto,C,sld,>0"]
["Test as the solid mass could not be negative","DmC;sto;sld","kg",{"$f":"IF(D31+m_C_sto_sld<0,-Method_input!E15,D32)","v":0},null,"Dmsto,C,sld,tmp1+msto,C,sld,>0","Limitation of mass variation as the thickness is limitd to Dsto,C,max)"]
["Correction of the energy input if the maximum mass is achieved","DQC;sto","kWh",{"$f":"IF(Method_input!F$38=1,-D$33*(Method_input!E$40+Method_input!E$41*(Method_input!E$13+theta_C_gen_flw)/2)/rau_sld,0)","v":0},"formula (12)"]
["Thickness of the ice around the tube after energy use","dC;sto","m",{"$f":"IF(Method_input!F$38=1,(MIN(d_sto_C_max,SQRT(Method_input!E$32^2/4+(Method_input!E$15+D33)/(3.14*Method_input!E$46*Method_input!E$33))-Method_input!E$32/2)),0)","v":0},"formula (12)",null,"limited to d_sto_C_max ",null,"A=",{"$f":"3.14*(D$30+Method_input!E$32)*Method_input!E$33/8*Method_input!E$41*(Method_input!E$39-Method_input!$E$12)/Method_calculation!D$30","v":{"$error":"#DIV/0!"}}]
["Mass of solid phase after 'use' mode and balance of thermal losses","mC;sto;sld","kg",{"$f":"IF(Method_input!F38=1,D33+Method_input!E15,0)","v":0},"formula (14)",null,null,null,"C=",{"$f":"D28","v":0.90249999999999997}]
["Temperature of the  storage (liquid)","qC;sto","°C",{"$f":"+D19","v":0},null,null,"need improvment if solid mass become equal to 0"]
[]
["Step 3 b Phase changing Material (solid and liqhid mass after energy balance)"]
["Evolution of solid mass","DmC;sto;sld,tmp1","kg",{"$f":"IF(Method_input!F$38=1,0,-D$28/(Q_lat+Cp_sens_sld*(theta_C_sto+theta_C_gen_flw)/2))","v":-4.5812182741116751E-2},"formula (15)"]
["Limitation solid phase","DmC;sto;sld;tmp1","kg",{"$f":"IF(D40>0,MIN(D40,D11),MAX(D40,D11*-1))","v":-4.5812182741116751E-2},"formula (16)","                                       then                                     and   "]
["Limitation of energy for transformation to solid phase",null,null,{"$f":"IF(TYPE_STO_MAT=1,0,-D$41*(Method_input!E$40+Method_input!E$41*(Method_input!E$13+Method_input!E$12)/2))","v":0.95060279187817254},"formula (17)"," If                                         then                                        and"," "]
["Mass (solid phase)","mC;sto;sld","kg",{"$f":"Method_input!E15+Method_calculation!D41","v":77.954187817258884}," "]
["Temperature (solid phase)","-","°C",{"$f":"MAX(Method_input!E$39+(D$42-Method_input!E$41*Method_calculation!D$41)/(Method_input!E$41*Method_calculation!D$43),Method_input!E$39)","v":0.12253145557637488},"formula (18)"]
["Mass (liquid phase)","mC;sto;lqd","kg",{"$f":"D11-D41","v":354.04581218274114}]
["Temperature( liquid phase)","mC;sto;lqd","°C",{"$f":"MAX(theta_tr+(D$42-Cp_sens_sld*Method_calculation!D$41)/(Cp_sens_lqd*(Method_calculation!D$11-D41)),theta_tr)","v":6.7447769277614329E-3},"formula (22)"]
[]
["Total energy input from cooling unit","DQC;gen;sto;out","kWh",{"$f":"IF(TYPE_STO_MAT=1,-Method_calculation!D28+SUM(D20:D22),-Method_calculation!D42+SUM(D20:D22))","v":195.32139720812182},"formula (1)"]
["Opetation time for auxiliary input (primary circuit)"," tC;sto,aux;out","h",{"$f":"ABS(D$7/(Method_input!E$35*Method_input!E28*Method_input!E12*-1))","v":0},"formula (25)"]
["energy for auxiliary (input)","WC;aux;sto;out","kWh",{"$f":"D49*Method_input!E27","v":0},"formula (26)"]
["Mass (solid phase)","MC;sto;sld","kg",{"$f":"IF(Method_input!F$38=1,D36,D43)","v":77.954187817258884},null,null,"Additionnal output"]
["Mass (liquid phase)","MC;sto;lqd","kg",{"$f":"IF(Method_input!F$38=1,,D45)","v":354.04581218274114},null,null,"Additionnal output"]
["total auxiliary energy ","WC;aux;sto","kWh",{"$f":"D23*Method_input!E54+D50","v":0},"Formula (27)",null,"Method output"]
["Heat losses from storage and distribution","QC;sto;ls","kWh",{"$f":"(D21+D22)","v":108.57599999999999},"Formula(6)+(7)+ (8)"]
["Recoverable heat losses from storage and distribution","QC;sto;ls;rbl","kWh",{"$f":"D54*Method_input!E49","v":108.57599999999999},"Formula (29)"]
["Recoverable heat losses from auxiliary energy","QC;sto;aux;ls;rbl","kWh",{"$f":"D$53*Method_input!E$50","v":0},"Formula(28)"]
["total recoverable heat losses ","QC;sto;ls;tot;rbl  ","kWh",{"$f":"D56+D55","v":108.57599999999999},"Formula (30)",null,"Method output"]
["heat extracted form generation ","qC;sto","°C",{"$f":"D37","v":0},"Formula (1)",null,"Method output"]
["heat extracted from distribution","QC;sto;in","kWh",{"$f":"D5","v":-72},"Formula (1)",null,"Method out[put"]
["Cooling production "," "," ",{"$f":"D58/Method_input!E24","v":0}," ",null," "]
[null,null,null," "]
[null,null,null,null," "]
[null,null,null,null," ","  "]

{"sheet":"Output_series","index":8,"n_rows":38,"n_cols":12,"rows_kept":38,"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,12]
[]
["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,"Energy extracted fused from Generation","Recoverable heat","Total auxiliary energy "," ",null,"Temperture of the medium of the storage unit","  ",null,"Mass  (solid)","Mass (liquid) PCM only","Type of medium"]
[null,"kWh","kWh","kWh"," ",null,"°C"," ",null,"kg","kg","-"]
["Symbol","QC;gen;sto;out","QC;sto;rbl","WC;aux;sto"," ",null,"qC;sto"," ",null,"MC;sto;sld","MC;sto;lqd","List"]
[null,"Q_C_gen_sto_out","Q_C_sto_rbl","W_C_aux_sto"," ",null,"Theta_C_sto"," ",null,"M_C_sto_sld","M_C_sto_lqd","List"]
["Destination"]
["Time stamp",null,null,"VALUES"," "]
[1,2,0.15079999999999999,0,null,null,0,null," ",49.952651515151516,382.0473484848485,"PCM"]
[2,2,0.15079999999999999,0,null,null,0,null," ",49.952411167512693,382.04758883248729,"PCM"]
[3,2,0.15079999999999999,0,null,null,0,null," ",39.951776649746193,392.04822335025381,"PCM"]
[4,2,0.15079999999999999,0,null,null,0,null," ",49.952411167512693,382.04758883248729,"PCM"]
[5,-2,0.15079999999999999,0,null,null,0,null," ",50.087685279187816,381.91231472081216,"PCM"]
[6,-2,0.15079999999999999,0,null,null,0,null," ",50.087685279187816,381.91231472081216,"PCM"]
[7,-1,0.15079999999999999,0,null,null,0,null," ",20.036923857868022,411.96307614213197,"PCM"]
[8,0,0.15079999999999999,0,null,null,0,null," ",49.98616243654822,382.01383756345177,"PCM"]
[9,0,0.15079999999999999,0,null,null,0,null," ",49.98616243654822,382.01383756345177,"PCM"]
[10,-3,0.15079999999999999,0,null,null,0,null," ",50.138446700507615,381.86155329949241,"PCM"]
[11,-3,0.15079999999999999,0,null,null,0,null," ",60.138446700507615,371.86155329949241,"PCM"]
[12,-72,108.57599999999999,0,null,null,0,null," ",77.954187817258884,354.04581218274114,"PCM"]
[13]
[{"$f":"A31+1","v":14}]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Method_output","index":9,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["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,null,"Value"]
[]
[]
[]
[]
[]
["Name","Symbol","Computed symbol","Unit","Value","Intended destination","Notes"]
["Energy flow daa"]
["Energy extracted from the distribution system","QC;sto;in","Q_C_sto_in","kWh",{"$f":"+Method_calculation!D59","v":-72},"M4-1","Difference input and output"]
["Heat losses (recoverable)","QC;sto;ls;tot;rbl","Q_C_sto_ls_rbl","kWh",{"$f":"Method_calculation!D57","v":108.57599999999999},"M2-2","Recoverable heat for heating of storage room"]
["Total auxiliary energy ","WC;sto;aux","Q_C_sto_aux","kWh",{"$f":"Method_calculation!D53","v":0},"M4-1; M4-4","storage auxiliary energy"]
[]
["Operating condition data"]
["Temperture of the medium of the storage unit","JC;sto;out","theta_C_sto_out","oC",{"$f":"Method_calculation!D58","v":0},"M4-1"]
[]
["Other data"," "," "," "," "," ","for information only"]
["Mass (solid phase)","mC;sto;sld","m_C_sto_sld","kg",{"$f":"Method_calculation!D51","v":77.954187817258884},"local"]
["Mass (liquid phase)","mC;sto;lqd","m_C_sto_lqd","kg",{"$f":"Method_calculation!D52","v":354.04581218274114},"local","only available for PCM"]
["Type of material for storage","STO_TYPE","STO_TYPE","List",{"$f":"Method_calculation!D8","v":"PCM"},"-"]

{"sheet":"History","index":10,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version scope","Changes, notes"]
[null,"2013-09-02","0.0","Draft version to state of terms and subscripts - PCM to be added"]
[null,"2013-10-10","0.1","First version - test to be addded"]
[null,"2013-12-27","0.2","Addition of condition on solid mass and liquid mass - Add energy auxiliary of th primary circuit"]

{"sheet":"Avrami curve","index":11,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null," "]
[]
[]
[]
[]
[]
[]
[]
[null,null,"%","Cristalisation","Melting"]
[" ","Tf",0,0,0]
[null,null,{"$f":"C12+10","v":10},5,3]
[null,null,{"$f":"C13+10","v":20},10,5]
[null,null,30,25,12]
[null,null,40,60,25]
[null,null,50,80,46]
[null,null,60,88,80]
[null,null,70,92,90]
[null,null,80,96,95]
[null,null,90,98,97]
[null,"Ts",100,100,100]
[]
[]
[]
[]
[null,"Distance Linear / non linear regretion"]
[null,"Tr","Tsol"]
[2.1,0,{"$f":"-6+6*(1-EXP(-A29*B29/6))","v":-6},-6]
[2.1,{"$f":"B29+0.1","v":0.1},{"$f":"-6-6*(LOG((0.03+B30*0.02)/0.03)/LOG(0.03/0.05))","v":-5.2419504644841046},{"$f":"-6+B30*6","v":-5.4}]
[2.1,{"$f":"B30+0.1","v":0.2},{"$f":"-6-6*(LOG((0.03+B31*0.02)/0.03)/LOG(0.03/0.05))","v":-4.5298723815231696},{"$f":"-6+B31*6","v":-4.8}]
[2.1,0.30000000000000004,-3.8585073068596563,-4.1999999999999993]
[2.1,0.4,-3.2234504253546992,-3.5999999999999996]
[2.1,0.5,-2.620975232242051,-3]
[2.1,0.6,-2.0479010335391763,-2.4000000000000004]
[2.1,0.7,-1.5014912983509081,-1.8000000000000007]
[2.1,0.79999999999999993,-0.97937462483966797,-1.2000000000000002]
[2.1,0.89999999999999991,-0.47948253910170813,-0.60000000000000053]
[2.1,0.99999999999999989,0,0,null,null,"Temperature of ice stored"]
[null,null,null,"linear"]

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