{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["READ ME","1 Geographic Data","2 Input","3 Output","Calculation Sheet","Systems Table"],"not_rendered":{"charts":5,"images":14,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"READ ME","index":0,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[51,2,53,8],[56,2,56,8],[40,5,41,8],[42,5,43,8],[44,5,45,8],[46,5,47,8],[46,2,47,4],[40,2,41,4],[42,2,43,4],[44,2,45,4],[49,2,49,8],[38,5,39,8],[19,2,19,7],[17,2,17,8],[21,2,24,8],[27,2,27,8],[36,2,36,8],[38,2,39,4]]}
{"$rows_empty":17}
[null,null,"Read Me Sheet "]
[]
[null,null,"Introduction"]
[]
[null,null,"This tool calculates the required power to cool different products from a given to a desired temperature and gives an economic analysis. Four example systems (described under  http://solar-cooling-engineering.com/example-systems ) can be selected, data will automatically be filled in. It is also possible, to design an own system. "]
[]
[]
[]
[]
[]
[null,null,"Tips & Tricks"]
{"$rows_empty":8}
[null,null,"Overview of the following sheets"]
[]
[null,null,"1. Geographic Data",null,null,"For adding basic site information: ambient temperatures or solar radiation. "]
[]
[null,null,"2. Input",null,null,"For adding data about the product to be cooled under given conditions"]
[]
[null,null,"3. Output",null,null,"For an overview of the results"]
[]
[null,null,"Calculation Sheet (Hidden)",null,null,"All calculations are done within this sheet"]
[]
[null,null,"Systems Table (Hidden)",null,null,"Contains example values of the three sample systems"]
[]
[]
[null,null,"Additional information"]
[]
[null,null,"This tool was created by the solar cooling group of the Institute of  Agricultural Engineering ( Tropics/Subtropics Department) of the University of Hohenheim, Germany. "]
[]
[]
[]
[]
[null,null,"In cooperation with"]

{"sheet":"1 Geographic Data","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,3,2,8],[10,0,10,4],[10,5,10,6],[10,9,10,12]]}
[]
[]
[null,null,null,"1 Geographic Data"]
[]
[]
[]
[null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Mean daily temperature [°C]:",25,26,26,26,25,23,22,23,24,25,25,25]
["Solar irradiation [kWh/m² day]:",6.2,6.6,6,5.3,4.5999999999999996,4.3,4.4000000000000004,4.7,5.6,5.9,5.6,5.8]
[]
["Use to obtain indicative monthly irradiation and temperature data for the site:",{"$nulls":4},"www.worldclimate.com",null,null,null,"www.sdwebx.worldbank.org/climateportal"]

{"sheet":"2 Input","index":2,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,1,2,6],[10,4,10,5],[13,9,13,11],[13,4,13,6]]}
[]
[]
[null,"Input of parameters"]
{"$rows_empty":7}
[null,null,null,"Select System:","Battery-free refrigerator"]
[]
[]
[null,"Product information",null,null,{"$f":"IF(E11='Systems Table'!$D$7, \"Own system data\",'Systems Table'!D9&\" preset data\")","v":"Battery-free refrigerator preset data"},{"$nulls":4},{"$f":"IF(E11='Systems Table'!D7, \"Please put in data\",\"Only required for own system design\")","v":"Only required for own system design"}]
[]
[null,"Total mass to be cooled",null,null,"Mass =",{"$f":"'Systems Table'!N18","v":12},"kg or l",null,null,"Mass =",10,"kg or l"]
[null," Moisture content of the product",null,null,"MC =",{"$f":"'Systems Table'!N19","v":100},"% wet based",null,null,"MC =",100,"% wet based"]
[null," or Heat capacity of the product",null,null,"cp =",{"$f":"'Systems Table'!N20","v":0},"kJ/kg K",null,null,"cp = ",0,"kJ/kg K"]
[]
[]
[null,"Temperature information"]
[]
[null,"Initial temperature of the product",null,null,"Ti =",{"$f":"'Systems Table'!N25","v":25},"°C",null,null,"Ti =",25,"°C"]
[null,"Final temperature of the product",null,null,"Tm =",{"$f":"'Systems Table'!N26","v":4},"°C",null,null,"Tm =",4,"°C"]
[null,"Time to cool down the product",null,null,"t =",{"$f":"'Systems Table'!N27","v":8},"h",null,null,"t =",10,"h"]
[null,"How often do you cool down the product",null,null,null,{"$f":"'Systems Table'!N28","v":30},"per month",null,null,null,30,"per month"]
[]
[]
[null,"System information"]
[]
[null,"Batteries",null,null,null,{"$f":"'Systems Table'!N32","v":"No"},{"$nulls":4},"Yes"]
[null,"Autonomy of the system",null,null,null,{"$f":"'Systems Table'!N33","v":1},{"$f":"IF(K31=\"YES\",\"days\",\"\")","v":"days"},null,null,null,1,{"$f":"IF(K31=\"YES\",\"days\",\"\")","v":"days"}]
[null,"System losses",null,null,null,{"$f":"'Systems Table'!N34","v":30},"%",null,null,null,25,"%"]
[]
[null,"Isolation material"]
[]
[null,"Area of the cooling room",null,null,"A =",{"$f":"'Systems Table'!N38","v":0.9},"m²",null,null,"A =",2,"m²"]
[null,"Thermal conductivity of insulation",null,null,"k /  l =",{"$f":"'Systems Table'!N39","v":3.5000000000000003E-2},"W/m K",null,null,"k /  l =",3.5000000000000003E-2,"W/m K"]
[null,"Thickness of insulation",null,null,"L =",{"$f":"'Systems Table'!N40","v":0.06},"m",null,null,"L =",0.1,"m"]
[]
[]
[null,"Economic information"]
[]
[null,"Currency used for calculation",null,null,null,{"$f":"'Systems Table'!N45","v":"€"},{"$nulls":4},"$"]
[null,"Specific cost of PV",null,null,null,{"$f":"'Systems Table'!N46","v":1.1000000000000001},{"$f":"F44&\"/Wp\"","v":"€/Wp"},null,null,null,1.1000000000000001,{"$f":"K44&\"/Wp\"","v":"$/Wp"}]
[null,"PV lifetime",null,null,null,{"$f":"'Systems Table'!N47","v":21},"years",null,null,null,21,"years"]
[null,"Specif cost of battery  ",null,null,null,{"$f":"'Systems Table'!N48","v":2},{"$f":"F44&\"/Ah@12V\"","v":"€/Ah@12V"},null,null,null,2,{"$f":"K44&\"/Ah@12V\"","v":"$/Ah@12V"}]
[null,"Battery lifetime",null,null,null,{"$f":"'Systems Table'!N49","v":5},"years",null,null,null,4,"years"]
[null,"Cost of solar cooling unit",null,null,null,{"$f":"'Systems Table'!N50","v":650},{"$f":"F44","v":"€"},null,null,null,650,{"$f":"K44","v":"$"}]
[null,"Solar cooling unit lifetime",null,null,null,{"$f":"'Systems Table'!N51","v":12},"years",null,null,null,12,"years"]
[null,"Material & construction costs for cooling box",null,null,null,{"$f":"'Systems Table'!N52","v":250},{"$f":"F44","v":"€"},null,null,null,300,{"$f":"K44","v":"$"}]
[null,"Maintenance costs per year",null,null,null,{"$f":"'Systems Table'!N53","v":25},{"$f":"F44&\"/year\"","v":"€/year"},null,null,null,30,{"$f":"K44&\"/year\"","v":"$/year"}]
[]
[null,"Additional income per product unit",null,null,null,{"$f":"'Systems Table'!N54","v":0.09},{"$f":"F44&\"/\"&G16","v":"€/kg or l"},null,null,null,7.0000000000000007E-2,{"$f":"F44&\"/\"&G16","v":"€/kg or l"}]
[null,"Additional income per month",null,null,null,{"$f":"'Systems Table'!N55","v":0},{"$f":"F44&\"/month\"","v":"€/month"},null,null,null,15,{"$f":"K44&\"/month\"","v":"$/month"}]
[null,"Discount rate",null,null,null,{"$f":"'Systems Table'!N56","v":5},"%",null,null,null,5,"%"]
[null,"Inflation  ",null,null,null,{"$f":"'Systems Table'!N57","v":3},"%",null,null,null,3,"%"]

{"sheet":"3 Output","index":3,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,6],[15,1,15,3],[15,7,15,9]]}
[]
[]
[null,"Results"]
[]
[]
[null,"Selected System: ",null,{"$f":"'Systems Table'!D9","v":"Battery-free refrigerator"}]
{"$rows_empty":9}
[null,"System Design without batteries",{"$nulls":5},{"$f":"IF('Systems Table'!N32=\"yes\",\"System Design with batteries\",\"\")","v":""}]
[]
[null,"Cooling units needed:",null,{"$f":"'Calculation Sheet'!$P$17","v":1},null,null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Cooling units needed:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$P$19,\"\")","v":""}]
[null,"Cooling units costs:",null,{"$f":"'Calculation Sheet'!$U$70","v":650},{"$f":"'Calculation Sheet'!$E$65","v":"€"},null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Cooling units costs:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$P$70,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$E$65,\"\")","v":""}]
[]
[null,"Solar PV size:",null,{"$f":"'Calculation Sheet'!$P$18","v":140},"Wp",null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Solar PV size:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$P$20,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",\"Wp\",\"\")","v":""}]
[null,"Solar PV costs:",null,{"$f":"'Calculation Sheet'!$U$66","v":154},{"$f":"'Calculation Sheet'!$E$65","v":"€"},null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Solar PV costs:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$P$66,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$E$65,\"\")","v":""}]
[]
[{"$nulls":7},{"$f":"IF('Systems Table'!N32=\"yes\",\"Battery size:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$P$21,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",\"Ah @12 V\",\"\")","v":""}]
[{"$nulls":7},{"$f":"IF('Systems Table'!N32=\"yes\",\"Battery costs:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!P68,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!$E$65,\"\")","v":""}]
[]
[]
[null,"Total initial investment",null,{"$f":"'Calculation Sheet'!B126","v":1054},{"$f":"'Calculation Sheet'!E65","v":"€"},null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Total initial investment\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!B100,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!E65,\"\")","v":""}]
[null,"Payback period:",null,{"$f":"'Calculation Sheet'!B127","v":2.9},"years",null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Payback period:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!B101,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",\"years\",\"\")","v":""}]
[null,"Net present value:",null,{"$f":"'Calculation Sheet'!B128","v":2876.1417354761534},{"$f":"'Calculation Sheet'!E65","v":"€"},null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Net present value:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!B102,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!E65,\"\")","v":""}]
[null,"Internal rate of return:",null,{"$f":"'Calculation Sheet'!B129*100","v":33.24404564579622},"%",null,null,{"$f":"IF('Systems Table'!N32=\"yes\",\"Internal rate of return:\",\"\")","v":""},null,{"$f":"IF('Systems Table'!N32=\"yes\",'Calculation Sheet'!B103*100,\"\")","v":""},{"$f":"IF('Systems Table'!N32=\"yes\",\"%\",\"\")","v":""}]

{"sheet":"Calculation Sheet","index":4,"n_rows":129,"n_cols":31,"rows_kept":129,"cut":false,"hidden":true,"merged":[[11,14,11,15],[14,14,14,15]]}
[]
[]
[null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Mean daily temperature [°C]:",{"$f":"'1 Geographic Data'!B8","v":25},{"$f":"'1 Geographic Data'!C8","v":26},{"$f":"'1 Geographic Data'!D8","v":26},{"$f":"'1 Geographic Data'!E8","v":26},{"$f":"'1 Geographic Data'!F8","v":25},{"$f":"'1 Geographic Data'!G8","v":23},{"$f":"'1 Geographic Data'!H8","v":22},{"$f":"'1 Geographic Data'!I8","v":23},{"$f":"'1 Geographic Data'!J8","v":24},{"$f":"'1 Geographic Data'!K8","v":25},{"$f":"'1 Geographic Data'!L8","v":25},{"$f":"'1 Geographic Data'!M8","v":25}]
["Solar irradiation [kWh/m² day]:",{"$f":"'1 Geographic Data'!B9","v":6.2},{"$f":"'1 Geographic Data'!C9","v":6.6},{"$f":"'1 Geographic Data'!D9","v":6},{"$f":"'1 Geographic Data'!E9","v":5.3},{"$f":"'1 Geographic Data'!F9","v":4.5999999999999996},{"$f":"'1 Geographic Data'!G9","v":4.3},{"$f":"'1 Geographic Data'!H9","v":4.4000000000000004},{"$f":"'1 Geographic Data'!I9","v":4.7},{"$f":"'1 Geographic Data'!J9","v":5.6},{"$f":"'1 Geographic Data'!K9","v":5.9},{"$f":"'1 Geographic Data'!L9","v":5.6},{"$f":"'1 Geographic Data'!M9","v":5.8}]
["Thermal losses for each day [kWh]:",{"$f":"$E$49*$E$52*(B4-$E$39)*24/1000","v":0.2646},{"$f":"$E$49*$E$52*(C4-$E$39)*24/1000","v":0.27720000000000006},0.27720000000000006,0.27720000000000006,0.2646,0.23939999999999997,0.2268,0.23939999999999997,0.252,0.2646,0.2646,0.2646]
["Thermal Energy Liquid phase [kWh]:",{"$f":"$E$27*$E$31*($E$38-MAX($E$39,0))/3600","v":0.29330000000000001},{"$f":"$E$27*$E$31*($E$38-MAX($E$39,0))/3600","v":0.29330000000000001},0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001]
["Thermal Energy Change Phase [kWh]:",{"$f":"$E$27*$E$31*80/3600","v":1.1173333333333333},{"$f":"$E$27*$E$31*80/3600","v":1.1173333333333333},1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333,1.1173333333333333]
["Thermal Energy Ice Phase [kWh]:",{"$f":"0.5*$E$27*$E$31*(0-MIN($E$39,0))/3600","v":0},{"$f":"0.5*$E$27*$E$31*(0-MIN($E$39,0))/3600","v":0},0,0,0,0,0,0,0,0,0,0]
["Max Power to cool down the product [kW]: ",{"$f":"B11/$E$32","v":3.6662500000000001E-2},{"$f":"C11/$E$32","v":3.6662500000000001E-2},3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2,3.6662500000000001E-2]
["Daily Energy to cool down the product [kWh]: ",{"$f":"IF($E$39>0,B7,B7+B8+B9)*$E$33/30","v":0.29330000000000001},{"$f":"IF($E$39>0,C7,C7+C8+C9)*$E$33/30","v":0.29330000000000001},0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001,0.29330000000000001]
["Qtotal for each day [kW]:",{"$f":"B6+B11","v":0.55790000000000006},{"$f":"C6+C11","v":0.57050000000000001},0.57050000000000001,0.57050000000000001,0.55790000000000006,0.53269999999999995,0.52010000000000001,0.53269999999999995,0.54530000000000001,0.55790000000000006,0.55790000000000006,0.55790000000000006]
["COP without battery:",{"$f":"$E$43*(1/((B4+5+273.15)/((MIN(-5,$E$42))+273.15)-1))","v":1.9153571428571432},{"$f":"$E$43*(1/((C4+5+273.15)/((MIN(-5,$E$42))+273.15)-1))","v":1.8621527777777764},1.8621527777777764,1.8621527777777764,1.9153571428571432,2.0314393939393947,2.0949218749999989,2.0314393939393947,1.9716911764705869,1.9153571428571432,1.9153571428571432,1.9153571428571432]
["COP with battery:",{"$f":"$E$43*(1/((B4+5+273.15)/($E$42+273.15)-1))","v":2.19475806451613},{"$f":"$E$43*(1/((C4+5+273.15)/($E$42+273.15)-1))","v":2.1261718749999998},2.1261718749999998,2.1261718749999998,2.19475806451613,2.3461206896551712,2.4299107142857146,2.3461206896551712,2.2679166666666641,2.19475806451613,2.19475806451613,2.19475806451613]
["Energy needed without battery [kWhel]:",{"$f":"B12/B13","v":0.29127727018459815},{"$f":"C12/C13","v":0.30636584001491723},0.30636584001491723,0.30636584001491723,0.29127727018459815,0.26222785754242017,0.24826701473056137,0.26222785754242017,0.27656460936043281,0.29127727018459815,0.29127727018459815,0.29127727018459815,null,"Maximum values "]
["Engergy needed with battery [kWhel]:",{"$f":"B12/B14","v":0.25419658276685642},{"$f":"C12/C14","v":0.26832261620429915},0.26832261620429915,0.26832261620429915,0.25419658276685642,0.22705566783024078,0.21404078633106741,0.22705566783024078,0.24044093330883731,0.25419658276685642,0.25419658276685642,0.25419658276685642,null,null,"rounded"]
["Cooling units needed (no battery):",{"$f":"1000*B15/(70*8)","v":0.52013798247249665},{"$f":"1000*C16/(70*8)","v":0.47914752893624851},0.47914752893624851,0.47914752893624851,0.45392246922652929,0.40545654969685857,0.38221568987690607,0.40545654969685857,0.42935880948006666,0.45392246922652929,0.45392246922652929,0.45392246922652929,null,{"$f":"MAX(B17:M17)","v":0.52013798247249665},{"$f":"MAX(1,IF( O17-ROUNDDOWN(O17,0)<0.2,  ROUNDDOWN(O17,0),      ROUNDUP(O17,0)        ))","v":1}]
["PV without battery (Wp):",{"$f":"(1+$E$59/100)*1.7*1000*B15/B5","v":103.82625275934869},{"$f":"(1+$E$59/100)*1.7*1000*C15/C5","v":102.58613733832836},112.84475107216117,127.74877479867304,139.93973197999173,134.77292213226713,124.69775058057742,123.30288620611672,109.14424762259938,109.10555374711218,114.95049412642177,110.98668398413136,null,{"$f":"MAX(B18:M18)","v":139.93973197999173},{"$f":"ROUND(O18,0)","v":140}]
["Cooling units needed (with battery):",{"$f":"1000*B16/(70*24)","v":0.15130748974217642},{"$f":"1000*C16/(70*24)","v":0.15971584297874949},0.15971584297874949,0.15971584297874949,0.15130748974217642,0.1351521832322862,0.12740522995896869,0.1351521832322862,0.1431196031600222,0.15130748974217642,0.15130748974217642,0.15130748974217642,null,0.15971584297874949,{"$f":"MAX(1,IF( O19-ROUNDDOWN(O19,0)<0.2,  ROUNDDOWN(O19,0),      ROUNDUP(O19,0)        ))","v":1}]
["PV with battery (Wp):",{"$f":"(1+$E$59/100)*1000*B16/B5","v":53.299283483373124},{"$f":"(1+$E$59/100)*1000*C16/C5","v":52.851424403877104},58.136566844264813,65.814981333129978,71.838164694981174,68.644736785886749,63.239323234178997,62.802631527513405,55.816645232408668,56.009416541849717,59.009920999448816,56.975096137398857,null,71.838164694981174,72]
["Battery (Ah related to 12 V):",{"$f":"MAX($E$58,1)*(1+$E$59/100)*1000*B16/12","v":27.537963133076115},{"$f":"MAX($E$58,1)*(1+$E$59/100)*1000*C16/12","v":29.068283422132406},29.068283422132406,29.068283422132406,27.537963133076115,24.597697348276085,23.187751852532301,24.597697348276085,26.047767775124044,27.537963133076115,27.537963133076115,27.537963133076115,null,29.068283422132406,29]
[]
[]
[]
["Product information"]
[]
[{"$f":"'2 Input'!B16","v":"Total mass to be cooled"},null,null,"Mass =",{"$f":"'Systems Table'!N18","v":12},"kg or l"]
[{"$f":"'2 Input'!B17","v":" Moisture content of the product"},null,null,"MC =",{"$f":"'Systems Table'!N19","v":100},"%"]
[{"$f":"'2 Input'!B18","v":" or Heat capacity of the product"},null,null,"cp =",{"$f":"'Systems Table'!N20","v":0},"kJ/kg K"]
["Calculated heat capacity of the product:",null,null,"cp =",{"$f":"4.19-2.3*((100-E28)/100)-0.628*((100-E28)/100)^3","v":4.1900000000000004},"kJ/kg K"]
["CP due to input of the user (either calculated via MC or direct)",null,null,"cp =",{"$f":"IF(E29>0,E29,E30)","v":4.1900000000000004},"kJ/kg K"]
[{"$f":"'2 Input'!B25","v":"Time to cool down the product"},null,null,"t =",{"$f":"'Systems Table'!N27","v":8},"h"]
[{"$f":"'2 Input'!B26","v":"How often do you cool down the product"},null,null,null,{"$f":"'Systems Table'!N28","v":30}]
[]
[]
["Temperature information"]
[]
[{"$f":"'2 Input'!B23","v":"Initial temperature of the product"},null,null,"Ti =",{"$f":"'Systems Table'!N25","v":25},"°C"]
[{"$f":"'2 Input'!B24","v":"Final temperature of the product"},null,null,"Tm =",{"$f":"'Systems Table'!N26","v":4},"°C"]
[]
["Maximum Temperature within the year:",null,null,"Tyearmax =",{"$f":"MAX(B4:M4)","v":26},"°C"]
["Temperature within the cooling device ( Final temp - 5°C):",null,null,"Tcold =",{"$f":"E39-5","v":-1},"°C"]
["Alpha - value:",null,null,null,0.25]
[null,null,null,"COP worst case =",{"$f":"$E$43*(1/((E41+273.15)/($E$42+273.15)-1))","v":2.5199074074074095}]
[]
[]
["Isolation material"]
[]
[{"$f":"'2 Input'!B37","v":"Area of the cooling room"},null,null,"A =",{"$f":"'Systems Table'!N38","v":0.9},"m²"]
[{"$f":"'2 Input'!B38","v":"Thermal conductivity of insulation"},null,null,"k /  l =",{"$f":"'Systems Table'!N39","v":3.5000000000000003E-2},"W/m K"]
[{"$f":"'2 Input'!B39","v":"Thickness of insulation"},null,null,"L =",{"$f":"'Systems Table'!N40","v":0.06},"m"]
[null,null,null,"U =",{"$f":"E50/E51","v":0.58333333333333337}]
[]
[]
[]
["System information"]
[]
[{"$f":"'2 Input'!B32","v":"Autonomy of the system"},null,null,null,{"$f":"'Systems Table'!N33","v":1}]
[{"$f":"'2 Input'!B33","v":"System losses"},null,null,null,{"$f":"'Systems Table'!N34","v":30},"%"]
[]
[]
[]
["Economic information",{"$nulls":6},"Income",{"$nulls":5},"System with Battery",{"$nulls":4},"System without Battery"]
[]
[{"$f":"'2 Input'!B44","v":"Currency used for calculation"},null,null,null,{"$f":"'Systems Table'!N45","v":"€"}]
[{"$f":"'2 Input'!B45","v":"Specific cost of PV"},null,null,null,{"$f":"'Systems Table'!N46","v":1.1000000000000001},{"$f":"E65&\"/Wp\"","v":"€/Wp"},null,"Additional income per product:",null,null,{"$f":"E74*E27*E33*12","v":388.80000000000007},{"$f":"E65&\"/year\"","v":"€/year"},null,"Total PV Costs:",null,{"$f":"P20*E66","v":79.2},null,null,"Total PV Costs:",null,{"$f":"P18*E66","v":154}]
[{"$f":"'2 Input'!B46","v":"PV lifetime"},null,null,null,{"$f":"'Systems Table'!N47","v":21},"years",null,"Additional income per year:",null,null,{"$f":"E75*12","v":0},{"$f":"E65&\"/year\"","v":"€/year"},null,"Lifetime PV:",null,{"$f":"E67","v":21},null,null,"Lifetime PV:",null,{"$f":"E67","v":21}]
[{"$f":"'2 Input'!B47","v":"Specif cost of battery  "},null,null,null,{"$f":"'Systems Table'!N48","v":2},{"$f":"E65&\"/Ah@12V\"","v":"€/Ah@12V"},null,"Total income :",null,null,{"$f":"SUM(K66:K67)","v":388.80000000000007},{"$f":"E65&\"/year\"","v":"€/year"},null,"Total Battery costs:",null,{"$f":"P21*E68","v":58}]
[{"$f":"'2 Input'!B48","v":"Battery lifetime"},null,null,null,{"$f":"'Systems Table'!N49","v":5},"years",{"$nulls":7},"Lifetime battery:",null,{"$f":"E69","v":5}]
[{"$f":"'2 Input'!B49","v":"Cost of solar cooling unit"},null,null,null,{"$f":"'Systems Table'!N50","v":650},{"$f":"E65","v":"€"},{"$nulls":7},"Total solar cooling unit costs:",null,{"$f":"P19*E70","v":650},null,null,"Total solar cooling unit costs:",null,{"$f":"P17*E70","v":650}]
[{"$f":"'2 Input'!B50","v":"Solar cooling unit lifetime"},null,null,null,{"$f":"'Systems Table'!N51","v":12},"years",{"$nulls":7},"Lifetime cooling unit:",null,{"$f":"E71","v":12},null,null,"Lifetime cooling unit:",null,{"$f":"E71","v":12}]
[{"$f":"'2 Input'!B51","v":"Material & construction costs for cooling box"},null,null,null,{"$f":"'Systems Table'!N52","v":250},{"$f":"E65","v":"€"},{"$nulls":7},"Material & construction:",null,{"$f":"E72","v":250},null,null,"Material & construction:",null,{"$f":"E72","v":250}]
[{"$f":"'2 Input'!B52","v":"Maintenance costs per year"},null,null,null,{"$f":"'Systems Table'!N53","v":25},{"$f":"E65&\"/year\"","v":"€/year"},{"$nulls":7},"Maintenance per year:",null,{"$f":"E73","v":25},null,null,"Maintenance per year:",null,{"$f":"E73","v":25}]
[{"$f":"'2 Input'!B54","v":"Additional income per product unit"},null,null,null,{"$f":"'Systems Table'!N54","v":0.09},{"$f":"E65&\"/kg or l\"","v":"€/kg or l"}]
[{"$f":"'2 Input'!B55","v":"Additional income per month"},null,null,null,{"$f":"'Systems Table'!N55","v":0},{"$f":"E65&\"/year\"","v":"€/year"}]
[{"$f":"'2 Input'!B56","v":"Discount rate"},null,null,null,{"$f":"'Systems Table'!N56","v":5},"%"]
[{"$f":"'2 Input'!B57","v":"Inflation  "},null,null,null,{"$f":"'Systems Table'!N57","v":3},"%"]
[]
[]
[null,"Economic Analysis: System with battery",null,null,null,"With batteries? ",null,{"$f":"'Systems Table'!N32","v":"No"}]
[]
[null,null,null,{"$f":"IF(E98<0,0,1)","v":0},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[]
["PV Costs",null,{"$f":"P66","v":79.2},{"$f":"IF(MOD(D83,$P$67)=0,$C$85*(1+($E$77/100))^D83,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,147.33533007939204,0,0,0,0]
["Battery Costs",null,{"$f":"P68","v":58},{"$f":"IF(MOD(D83,$P$69)=0,$C$86*(1+($E$77/100))^D83,0)","v":0},0,0,0,67.237896309399986,0,0,0,0,77.947150001959059,0,0,0,0,90.362110162844331,0,0,0,0,104.75445161082597,0,0,0,0,121.4391199199444]
["Solar cooling units cost",null,{"$f":"P70","v":650},{"$f":"IF(MOD(D83,$P$71)=0,$C$87*(1+($E$77/100))^D83,0)","v":0},0,0,0,0,0,0,0,0,0,0,926.7445764500161,0,0,0,0,0,0,0,0,0,0,0,1321.3161691992611,0]
["Material & Construction",null,{"$f":"P72","v":250},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]
["Maintenance costs",null,0,{"$f":"P73","v":25},{"$f":"$D$89*(1+($E$77/100))^(E83-1)","v":25.75},{"$f":"$D$89*(1+($E$77/100))^(F83-1)","v":26.522499999999997},27.318175,28.137720249999997,28.981851857499997,29.851307413224998,30.74684663562175,31.669252034690398,32.619329595731109,33.597909483603047,34.605846768111135,35.644022171154468,36.713342836289101,37.814743121377774,38.949185415019109,40.117660977469676,41.321190806793766,42.560826530997581,43.837651326927507,45.152780866735334,46.507364292737385,47.902585221519509,49.339662778165099,50.819852661510048]
[]
["Expenses per year:",null,{"$f":"SUM(C85:C90)","v":1037.2},{"$f":"SUM(D85:D90)","v":25},25.75,26.522499999999997,27.318175,95.375616559399987,28.981851857499997,29.851307413224998,30.74684663562175,31.669252034690398,110.56647959769018,33.597909483603047,961.35042321812728,35.644022171154468,36.713342836289101,128.17685328422209,38.949185415019109,40.117660977469676,41.321190806793766,42.560826530997581,148.59210293775348,192.48811094612736,46.507364292737385,47.902585221519509,1370.6558319774263,172.25897258145446]
["Expenses per year accumulated:",null,{"$f":"C91","v":1037.2},{"$f":"SUM($C$91:D91)","v":1062.2},{"$f":"SUM($C$91:E91)","v":1087.95},{"$f":"SUM($C$91:F91)","v":1114.4725000000001},{"$f":"SUM($C$91:G91)","v":1141.7906750000002},{"$f":"SUM($C$91:H91)","v":1237.1662915594002},{"$f":"SUM($C$91:I91)","v":1266.1481434169002},{"$f":"SUM($C$91:J91)","v":1295.9994508301252},{"$f":"SUM($C$91:K91)","v":1326.7462974657469},{"$f":"SUM($C$91:L91)","v":1358.4155495004372},{"$f":"SUM($C$91:M91)","v":1468.9820290981274},{"$f":"SUM($C$91:N91)","v":1502.5799385817304},{"$f":"SUM($C$91:O91)","v":2463.9303617998576},{"$f":"SUM($C$91:P91)","v":2499.5743839710121},{"$f":"SUM($C$91:Q91)","v":2536.2877268073012},{"$f":"SUM($C$91:R91)","v":2664.4645800915232},{"$f":"SUM($C$91:S91)","v":2703.4137655065424},{"$f":"SUM($C$91:T91)","v":2743.5314264840122},{"$f":"SUM($C$91:U91)","v":2784.8526172908059},{"$f":"SUM($C$91:V91)","v":2827.4134438218034},{"$f":"SUM($C$91:W91)","v":2976.0055467595571},{"$f":"SUM($C$91:X91)","v":3168.4936577056847},{"$f":"SUM($C$91:Y91)","v":3215.0010219984219},{"$f":"SUM($C$91:Z91)","v":3262.9036072199415},{"$f":"SUM($C$91:AA91)","v":4633.5594391973682},{"$f":"SUM($C$91:AB91)","v":4805.8184117788223}]
["Expenses per year accumulated (for hiding in the diagramm):",null,{"$f":"IF($H$80=\"YES\",C92,NA())","v":{"$error":"#N/A"}},{"$f":"IF($H$80=\"YES\",D92,NA())","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"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[" Accumulated income per year:",null,0,{"$f":"K68","v":388.80000000000007},{"$f":"$K$68+D95","v":777.60000000000014},{"$f":"$K$68+E95","v":1166.4000000000001},1555.2000000000003,1944.0000000000005,2332.8000000000006,2721.6000000000008,3110.400000000001,3499.2000000000012,3888.0000000000014,4276.8000000000011,4665.6000000000013,5054.4000000000015,5443.2000000000016,5832.0000000000018,6220.800000000002,6609.6000000000022,6998.4000000000024,7387.2000000000025,7776.0000000000027,8164.8000000000029,8553.6000000000022,8942.4000000000015,9331.2000000000007,9720]
["Income per year:",null,null,{"$f":"$K$68","v":388.80000000000007},{"$f":"$K$68","v":388.80000000000007},388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007]
["Cashfow per year:",null,{"$f":"C95-C92","v":-1037.2},{"$f":"D96-D91","v":363.80000000000007},{"$f":"E96-E91","v":363.05000000000007},362.27750000000009,361.48182500000007,293.42438344060008,359.81814814250009,358.94869258677505,358.05315336437832,357.13074796530969,278.23352040230986,355.20209051639699,-572.55042321812721,353.15597782884561,352.08665716371098,260.62314671577798,349.85081458498098,348.68233902253041,347.4788091932063,346.23917346900248,240.20789706224659,196.3118890538727,342.29263570726266,340.89741477848054,-981.85583197742619,216.54102741854561]
["Accumulated cashflow per year (for payback calculation)",null,{"$f":"C97","v":-1037.2},{"$f":"C98+D97","v":-673.4},{"$f":"D98+E97","v":-310.34999999999991},51.92750000000018,413.40932500000025,706.83370844060028,1066.6518565831004,1425.6005491698754,1783.6537025342536,2140.7844504995633,2419.017970901873,2774.2200614182702,2201.6696382001428,2554.8256160289884,2906.9122731926996,3167.5354199084777,3517.3862344934587,{"$f":"S98+T97","v":3866.0685735159891},{"$f":"T98+U97","v":4213.5473827091955},{"$f":"U98+V97","v":4559.7865561781982},{"$f":"V98+W97","v":4799.9944532404452},{"$f":"W98+X97","v":4996.3063422943178},{"$f":"X98+Y97","v":5338.5989780015807},{"$f":"Y98+Z97","v":5679.4963927800609},{"$f":"Z98+AA97","v":4697.6405608026344},{"$f":"AA98+AB97","v":4914.1815882211804}]
[null,null,{"$f":"C83+ABS(C98)/(ABS(C98)+ABS(D98))","v":0.60633695779258745},1.6845235069885642,{"$f":"E83+ABS(E98)/(ABS(E98)+ABS(F98))","v":2.8566637453333419},{"$f":"F83+ABS(F98)/(ABS(F98)+ABS(G98))","v":3.1115912113768345},4.3690353902316152,5.3985562230562358,6.4279870907621159,7.4442155209151393,8.4544991239460323,9.4694906166222879,10.465801481820611,11.557532467335644,12.462876450101065,13.467767891438132,14.478547584909508,15.473832841080897,16.476387589002083,17.47849657637963,18.480267525670353,19.487168081346105,20.489980305160529,21.483439972351025,22.484530111452724,23.547308609126453,24.488735693187969,26]
["Total initial investment costs:",{"$f":"SUM(C85:C89)","v":1037.2},{"$f":"E65","v":"€"}]
["Payback period:",{"$f":"ROUND(IF(W98<0,25,HLOOKUP(1,D82:AB99,18,FALSE)),1)","v":2.9},"years"]
["Net Present Value:",{"$f":"C97+NPV((E76/100),D97:W97)","v":2709.4597247733554},{"$f":"E65","v":"€"}]
["Internal Rate of Return:",{"$f":"IRR(C97:W97)","v":0.33060248376463686}]
[]
[]
[]
[]
[null,"Economic Analysis: System without battery"]
[]
[null,null,null,{"$f":"IF(E124<0,0,1)","v":0},{"$f":"IF(F124<0,0,1)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[{"$nulls":30},"Titles for the diagramm:"]
["PV Costs",null,{"$f":"U66","v":154},{"$f":"IF(MOD(D111,$U$67)=0,$C$113*(1+($E$77/100))^D111,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,286.48536404326228,0,0,0,0]
["Solar cooling units cost",null,{"$f":"U70","v":650},{"$f":"IF(MOD(D111,$U$71)=0,$C$114*(1+($E$77/100))^D111,0)","v":0},0,0,0,0,0,0,0,0,0,0,926.7445764500161,0,0,0,0,0,0,0,0,0,0,0,1321.3161691992611,0,null,null,"Accumulated income"]
["Material & Construction",null,{"$f":"U72","v":250},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,null,null,{"$f":"IF(H80=\"Yes\",\"Accumulated system costs with batteries\",\"\")","v":""}]
["Maintenance costs",null,0,{"$f":"U73","v":25},{"$f":"$D$116*(1+($E$77/100))^(E111-1)","v":25.75},26.522499999999997,27.318175,28.137720249999997,28.981851857499997,29.851307413224998,30.74684663562175,31.669252034690398,32.619329595731109,33.597909483603047,34.605846768111135,35.644022171154468,36.713342836289101,37.814743121377774,38.949185415019109,40.117660977469676,41.321190806793766,42.560826530997581,43.837651326927507,45.152780866735334,46.507364292737385,47.902585221519509,49.339662778165099,50.819852661510048,null,null,"Accumulated system costs without batteries"]
[]
["Expenses per year:",null,{"$f":"SUM(C113:C117)","v":1054},25,25.75,26.522499999999997,27.318175,28.137720249999997,28.981851857499997,29.851307413224998,30.74684663562175,31.669252034690398,32.619329595731109,33.597909483603047,961.35042321812728,35.644022171154468,36.713342836289101,37.814743121377774,38.949185415019109,40.117660977469676,41.321190806793766,42.560826530997581,43.837651326927507,331.63814490999761,46.507364292737385,47.902585221519509,1370.6558319774263,50.819852661510048]
["Expenses per year accumulated:",null,{"$f":"C118","v":1054},{"$f":"SUM($C$118:D118)","v":1079},{"$f":"SUM($C$118:E118)","v":1104.75},{"$f":"SUM($C$118:F118)","v":1131.2725},{"$f":"SUM($C$118:G118)","v":1158.5906750000001},{"$f":"SUM($C$118:H118)","v":1186.7283952500002},{"$f":"SUM($C$118:I118)","v":1215.7102471075002},{"$f":"SUM($C$118:J118)","v":1245.5615545207252},{"$f":"SUM($C$118:K118)","v":1276.3084011563469},{"$f":"SUM($C$118:L118)","v":1307.9776531910372},{"$f":"SUM($C$118:M118)","v":1340.5969827867684},{"$f":"SUM($C$118:N118)","v":1374.1948922703714},{"$f":"SUM($C$118:O118)","v":2335.5453154884985},{"$f":"SUM($C$118:P118)","v":2371.1893376596531},{"$f":"SUM($C$118:Q118)","v":2407.9026804959421},{"$f":"SUM($C$118:R118)","v":2445.71742361732},{"$f":"SUM($C$118:S118)","v":2484.6666090323392},{"$f":"SUM($C$118:T118)","v":2524.784270009809},{"$f":"SUM($C$118:U118)","v":2566.1054608166028},{"$f":"SUM($C$118:V118)","v":2608.6662873476002},{"$f":"SUM($C$118:W118)","v":2652.5039386745279},{"$f":"SUM($C$118:X118)","v":2984.1420835845256},{"$f":"SUM($C$118:Y118)","v":3030.6494478772629},{"$f":"SUM($C$118:Z118)","v":3078.5520330987824},{"$f":"SUM($C$118:AA118)","v":4449.2078650762087},{"$f":"SUM($C$118:AB118)","v":4500.0277177377184}]
[]
[" Accumulated investment per year:",null,0,{"$f":"K68","v":388.80000000000007},{"$f":"$K$68+D121","v":777.60000000000014},{"$f":"$K$68+E121","v":1166.4000000000001},1555.2000000000003,1944.0000000000005,2332.8000000000006,2721.6000000000008,3110.400000000001,3499.2000000000012,3888.0000000000014,4276.8000000000011,4665.6000000000013,5054.4000000000015,5443.2000000000016,5832.0000000000018,6220.800000000002,6609.6000000000022,6998.4000000000024,7387.2000000000025,7776.0000000000027,8164.8000000000029,8553.6000000000022,8942.4000000000015,9331.2000000000007,9720]
["Income per year:",null,null,{"$f":"$K$68","v":388.80000000000007},{"$f":"$K$68","v":388.80000000000007},388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007,388.80000000000007]
["Cashfow per year:",null,{"$f":"C121-C119","v":-1054},{"$f":"D122-D118","v":363.80000000000007},{"$f":"E122-E118","v":363.05000000000007},362.27750000000009,361.48182500000007,360.6622797500001,359.81814814250009,358.94869258677505,358.05315336437832,357.13074796530969,356.18067040426894,355.20209051639699,-572.55042321812721,353.15597782884561,352.08665716371098,350.98525687862229,349.85081458498098,348.68233902253041,347.4788091932063,346.23917346900248,344.96234867307254,57.161855090002462,342.29263570726266,340.89741477848054,-981.85583197742619,337.98014733849004]
["Accumulated cashflow per year (for payback calculation)",null,{"$f":"C123","v":-1054},{"$f":"C124+D123","v":-690.19999999999993},{"$f":"D124+E123","v":-327.14999999999986},35.127500000000225,396.6093250000003,757.27160475000039,1117.0897528925004,1476.0384454792754,1834.0915988436536,2191.2223468089633,2547.403017213232,2902.6051077296288,2330.0546845115014,2683.210662340347,3035.2973195040581,3386.2825763826804,3736.1333909676614,4084.8157299901918,4432.2945391833982,4778.5337126524009,5123.4960613254734,5180.6579164154755,5522.9505521227384,5863.8479669012186,4881.992134923792,5219.9722822622825]
[null,null,null,{"$f":"D111+ABS(D124)/(ABS(D124)+ABS(E124))","v":1.6784292524696516},{"$f":"E111+ABS(E124)/(ABS(E124)+ABS(F124))","v":2.9030370365258671},3.0813632239964708,4.3437177223181331,5.4040158007218349,6.4307884791789007,7.4459155458290134,8.4556393920092852,9.4624173000561989,10.467412700827843,11.554709310938492,12.464777849027021,13.469215164315452,14.472671424900946,15.475440158494763,16.477708438347452,17.479601132413958,18.481204775292603,19.482581230487732,20.497226271307014,21.484010409353377,22.485031024558442,23.545685391866694,24.483271563164315,26]
["Total initial investment costs:",{"$f":"SUM(C113:C117)","v":1054},{"$f":"E65","v":"€"}]
["Payback period:",{"$f":"ROUND(IF(W124<0,25,HLOOKUP(1,D110:AB125,16,FALSE)),1)","v":2.9},"years"]
["Net Present Value:",{"$f":"C123+NPV((E76/100),D123:W123)","v":2876.1417354761534},{"$f":"E65","v":"€"}]
["Internal Rate of Return:",{"$f":"IRR(C123:W123)","v":0.33244045645796216}]

{"sheet":"Systems Table","index":5,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"System","Number",null,null,"Batteries",null,null,"Changing pictures:"]
["Possible Systems to choose:",null,null,"Smart ice-maker",1,null,null,"Yes",null,null,null,{"$f":"D3","v":"Smart ice-maker"},{"$f":"IF($E$9=E3,1,0)","v":0}]
[null,null,null,"Battery-free refrigerator",2,null,null,"No",null,null,null,{"$f":"D4","v":"Battery-free refrigerator"},{"$f":"IF($E$9=E4,1,0)","v":1}]
[null,null,null,"Water chiller for milk cooling",3,{"$nulls":6},"Water chiller for milk cooling",{"$f":"IF($E$9=E5,1,0)","v":0}]
[null,null,null,"Water chiller for cold rooms",4,{"$nulls":6},"Water chiller for cold rooms",{"$f":"IF($E$9=E6,1,0)","v":0}]
[null,null,null,"Own system design",5,{"$nulls":6},"Own system design",{"$f":"IF($E$9=E7,1,0)","v":0}]
[]
["Selected value:",null,null,{"$f":"'2 Input'!E11","v":"Battery-free refrigerator"},{"$f":"VLOOKUP(D9,D3:E7,2,FALSE)","v":2}]
[]
[]
[]
[null,null,null,"System Data",null,null,{"$f":"D3","v":"Smart ice-maker"},{"$f":"D4","v":"Battery-free refrigerator"},{"$f":"D5","v":"Water chiller for milk cooling"},{"$f":"D6","v":"Water chiller for cold rooms"},{"$f":"D7","v":"Own system design"},null,null,"Selected values depending on user choice (are used for Calculation sheet)"]
[null,null,1,"Number",null,null,{"$f":"E3","v":1},{"$f":"E4","v":2},{"$f":"E5","v":3},{"$f":"E6","v":4},{"$f":"E7","v":5}]
[null,null,2]
[null,null,3,"Product information"]
[null,null,4]
[null,null,5,{"$f":"'2 Input'!B16","v":"Total mass to be cooled"},null,"Mass =",20,12,70,1000,{"$f":"'2 Input'!K16","v":10},"kg or l",null,{"$f":"HLOOKUP($E$9,$G$14:$K$59,C18)","v":12}]
[null,null,6,{"$f":"'2 Input'!B17","v":" Moisture content of the product"},null,"MC =",100,100,99,86,{"$f":"'2 Input'!K17","v":100},"% wet based",null,{"$f":"HLOOKUP($E$9,$G$14:$K$59,C19)","v":100}]
[null,null,7,{"$f":"'2 Input'!B18","v":" or Heat capacity of the product"},null,"cp = ",{"$nulls":4},{"$f":"'2 Input'!K18","v":0},"kJ/kg K",null,0]
[null,null,8]
[null,null,9]
[null,null,10,"Temperature information"]
[null,null,11]
[null,null,12,{"$f":"'2 Input'!B23","v":"Initial temperature of the product"},null,"Ti =",20,25,35,25,{"$f":"'2 Input'!K23","v":25},"°C",null,25]
[null,null,13,{"$f":"'2 Input'!B24","v":"Final temperature of the product"},null,"Tm =",-10,4,4,12,{"$f":"'2 Input'!K24","v":4},"°C",null,4]
[null,null,14,{"$f":"'2 Input'!B25","v":"Time to cool down the product"},null,"t =",24,8,4,24,{"$f":"'2 Input'!K25","v":10},"h",null,8]
[null,null,15,{"$f":"'2 Input'!B26","v":"How often do you cool down the product"},null,null,30,30,30,1,{"$f":"'2 Input'!K26","v":30},"per month",null,30]
[null,null,16]
[null,null,17]
[null,null,18,"System information"]
[null,null,19,null,null,null,"Yes","No","Yes","Yes",{"$f":"'2 Input'!K31","v":"Yes"},null,null,"No"]
[null,null,20,{"$f":"'2 Input'!B32","v":"Autonomy of the system"},null,null,1,1,1,1,{"$f":"'2 Input'!K32","v":1},"days",null,1]
[null,null,21,{"$f":"'2 Input'!B33","v":"System losses"},null,null,25,30,25,25,{"$f":"'2 Input'!K33","v":25},"%",null,30]
[null,null,22]
[null,null,23,"Isolation material"]
[null,null,24]
[null,null,25,{"$f":"'2 Input'!B37","v":"Area of the cooling room"},null,"A =",2.12,0.9,5,24,{"$f":"'2 Input'!K37","v":2},"m²",null,0.9]
[null,null,26,{"$f":"'2 Input'!B38","v":"Thermal conductivity of insulation"},null,"k /  l =",3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,{"$f":"'2 Input'!K38","v":3.5000000000000003E-2},"W/m K",null,3.5000000000000003E-2]
[null,null,27,{"$f":"'2 Input'!B39","v":"Thickness of insulation"},null,"L =",0.1,0.06,0.1,0.1,{"$f":"'2 Input'!K39","v":0.1},"m",null,0.06]
[null,null,28]
[null,null,29]
[null,null,30,"Economic information"]
[null,null,31]
[null,null,32,{"$f":"'2 Input'!B44","v":"Currency used for calculation"},null,null,"€","€","€","€",{"$f":"'2 Input'!K44","v":"$"},null,null,"€"]
[null,null,33,{"$f":"'2 Input'!B45","v":"Specific cost of PV"},null,null,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,{"$f":"'2 Input'!K45","v":1.1000000000000001},{"$f":"N45&\"/Wp\"","v":"€/Wp"},null,1.1000000000000001]
[null,null,34,{"$f":"'2 Input'!B46","v":"PV lifetime"},null,null,21,21,21,21,{"$f":"'2 Input'!K46","v":21},"years",null,21]
[null,null,35,{"$f":"'2 Input'!B47","v":"Specif cost of battery  "},null,null,2,2,2,2,{"$f":"'2 Input'!K47","v":2},{"$f":"N45&\"/Ah@12V\"","v":"€/Ah@12V"},null,2]
[null,null,36,{"$f":"'2 Input'!B48","v":"Battery lifetime"},null,null,4,5,4,4,{"$f":"'2 Input'!K48","v":4},"years",null,5]
[null,null,37,{"$f":"'2 Input'!B49","v":"Cost of solar cooling unit"},null,null,650,650,650,650,{"$f":"'2 Input'!K49","v":650},{"$f":"N45","v":"€"},null,650]
[null,null,38,{"$f":"'2 Input'!B50","v":"Solar cooling unit lifetime"},null,null,12,12,12,12,{"$f":"'2 Input'!K50","v":12},"years",null,12]
[null,null,39,{"$f":"'2 Input'!B51","v":"Material & construction costs for cooling box"},null,null,350,250,450,450,{"$f":"'2 Input'!K51","v":300},{"$f":"N45","v":"€"},null,250]
[null,null,40,{"$f":"'2 Input'!B52","v":"Maintenance costs per year"},null,null,50,25,75,75,{"$f":"'2 Input'!K52","v":30},{"$f":"N45&\"/year\"","v":"€/year"},null,25]
[null,null,41,{"$f":"'2 Input'!B54","v":"Additional income per product unit"},null,null,0.15,0.09,0.05,0.05,{"$f":"'2 Input'!K54","v":7.0000000000000007E-2},null,null,0.09]
[null,null,42,{"$f":"'2 Input'!B55","v":"Additional income per month"},null,null,0,0,0,0,{"$f":"'2 Input'!K55","v":15},{"$f":"N45&\"/year\"","v":"€/year"},null,0]
[null,null,43,{"$f":"'2 Input'!B56","v":"Discount rate"},null,null,5,5,5,5,{"$f":"'2 Input'!K56","v":5},"%",null,5]
[null,null,44,{"$f":"'2 Input'!B57","v":"Inflation  "},null,null,3,3,3,3,{"$f":"'2 Input'!K57","v":3},"%",null,3]
[null,null,45]
[null,null,46]