{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["READ ME","1 Geographic Data","2 Input","3 Output","Calculation Sheet","Translation","4 Weather Data"],"not_rendered":{"charts":4,"images":10,"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":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,0,10,10],[29,2,33,8],[19,2,19,8],[38,5,39,8],[17,2,17,8],[21,2,24,8],[27,2,27,8],[36,2,36,8],[38,2,39,4],[53,2,55,8],[58,2,58,8],[40,5,41,8],[42,5,43,8],[46,5,47,8],[48,5,49,8],[48,2,49,4],[40,2,41,4],[42,2,43,4],[46,2,47,4],[51,2,51,8],[44,2,45,4],[44,5,45,8]]}
[]
[]
[]
[null,null,null,"Language:","English"]
[]
[]
[]
[{"$f":"Translation!B6","v":"Design Tool: Solar Refrigerator"}]
{"$rows_empty":9}
[null,null,{"$f":"Translation!B7","v":"Read Me Sheet "}]
[]
[null,null,{"$f":"Translation!B8","v":"Introduction"}]
[]
[null,null,{"$f":"Translation!B9","v":"This tool calculates the required power of a do-it-yourself refrigerator to cool different products from a given to a desired temperature and gives an economic analysis. Examplary data is filled and and can be modified by own data. "}]
[]
[]
[]
[]
[]
[null,null,{"$f":"Translation!B10","v":"Tips & Tricks"}]
[]
[null,null,{"$f":"Translation!B11","v":"● Enter values into white (non-coloured) cells only!\n● None entry cells (coloured cells) are protected. Unprotect first if changes are necessary\n"}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Translation!B12","v":"Overview of the following sheets"}]
[]
[null,null,{"$f":"Translation!B13","v":"1. Geographic Data"},null,null,{"$f":"Translation!B19","v":"For selecting basic site information: ambient temperatures or solar radiation. "}]
[]
[null,null,{"$f":"Translation!B14","v":"2. Input"},null,null,{"$f":"Translation!B20","v":"For adding data about the product to be cooled under given conditions"}]
[]
[null,null,{"$f":"Translation!B15","v":"3. Output"},null,null,{"$f":"Translation!B21","v":"For an overview of the results"}]
[]
[null,null,{"$f":"Translation!B16","v":"4. Weather Data"},null,null,{"$f":"Translation!B22","v":"To add weather data for a specific location"}]
[]
[null,null,{"$f":"Translation!B17","v":"Calculation Sheet (Hidden)"},null,null,{"$f":"Translation!B23","v":"All calculations are done within this sheet"}]
[]
[null,null,{"$f":"Translation!B18","v":"Translation sheet (Hidden)"},null,null,{"$f":"Translation!B24","v":"Contains the translation into several languages"}]
[]
[]
[null,null,{"$f":"Translation!B25","v":"Additional information"}]
[]
[null,null,{"$f":"Translation!B26","v":"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,{"$f":"Translation!B27","v":"In cooperation with"}]

{"sheet":"1 Geographic Data","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,3,2,8],[10,7,10,8],[10,9,10,12]]}
[]
[]
[null,null,null,{"$f":"Translation!B28","v":"1. Geographic Data"}]
[]
[{"$f":"Translation!B43","v":"Choose location:"}]
["Mali (Bamako)"]
[null,{"$f":"Translation!B31","v":"January"},{"$f":"Translation!B32","v":"February"},{"$f":"Translation!B33","v":"March"},{"$f":"Translation!B34","v":"April"},{"$f":"Translation!B35","v":"May"},{"$f":"Translation!B36","v":"June"},{"$f":"Translation!B37","v":"July"},{"$f":"Translation!B38","v":"August"},{"$f":"Translation!B39","v":"September"},{"$f":"Translation!B40","v":"October"},{"$f":"Translation!B41","v":"November"},{"$f":"Translation!B42","v":"December"}]
[{"$f":"Translation!B29","v":"Mean daily temperature [°C]:"},{"$f":"'4 Weather Data'!C6","v":25.1},{"$f":"'4 Weather Data'!D6","v":27.8},{"$f":"'4 Weather Data'!E6","v":30.3},{"$f":"'4 Weather Data'!F6","v":31.1},{"$f":"'4 Weather Data'!G6","v":31.5},{"$f":"'4 Weather Data'!H6","v":29},{"$f":"'4 Weather Data'!I6","v":27.4},{"$f":"'4 Weather Data'!J6","v":25.9},{"$f":"'4 Weather Data'!K6","v":26.4},{"$f":"'4 Weather Data'!L6","v":27.4},{"$f":"'4 Weather Data'!M6","v":26.5},{"$f":"'4 Weather Data'!N6","v":24.8}]
[{"$f":"Translation!B30","v":"Solar irradiation [kWh/m² day]:"},{"$f":"'4 Weather Data'!C7","v":5.4},{"$f":"'4 Weather Data'!D7","v":5.9},{"$f":"'4 Weather Data'!E7","v":6.9},{"$f":"'4 Weather Data'!F7","v":6.6},{"$f":"'4 Weather Data'!G7","v":6.4},{"$f":"'4 Weather Data'!H7","v":6.1},{"$f":"'4 Weather Data'!I7","v":5.8},{"$f":"'4 Weather Data'!J7","v":5.6},{"$f":"'4 Weather Data'!K7","v":5.8},{"$f":"'4 Weather Data'!L7","v":5.8},{"$f":"'4 Weather Data'!M7","v":5.7},{"$f":"'4 Weather Data'!N7","v":5.4}]
[]
[{"$f":"Translation!B45","v":"Use to obtain indicative monthly irradiation and temperature data for the site:"},{"$nulls":6},"www.worldclimate.com",null,"www.sdwebx.worldbank.org/climateportal"]
[]
[{"$f":"Translation!B44","v":"Locations can be added on the sheet \"Weather Data\""}]

{"sheet":"2 Input","index":2,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,1,2,6],[5,4,5,6]]}
[]
[]
[null,{"$f":"Translation!B46","v":"Input of parameters"}]
[]
[]
[null,{"$f":"Translation!B47","v":"Product information"},null,null,{"$f":"Translation!B48","v":"Data"}]
[]
[null,{"$f":"Translation!B49","v":"Total mass to be cooled"},null,null,{"$f":"Translation!B52","v":"Mass ="},12,{"$f":"Translation!B55","v":"kg or l"}]
[null,{"$f":"Translation!B50","v":" Moisture content of the product"},null,null,{"$f":"Translation!B53","v":"MC ="},100,{"$f":"Translation!B56","v":"% wet based"}]
[null,{"$f":"Translation!B51","v":" or Heat capacity of the product"},null,null,{"$f":"Translation!B54","v":"cp ="},0,{"$f":"Translation!B57","v":"kJ/kg K"}]
[]
[]
[null,{"$f":"Translation!B58","v":"Temperature information"}]
[]
[null,{"$f":"Translation!B59","v":"Initial temperature of the product"},null,null,"Ti =",25,"°C"]
[null,{"$f":"Translation!B60","v":"Final temperature of the product"},null,null,"Tm =",4,"°C"]
[null,{"$f":"Translation!B61","v":"Time to cool down the product"},null,null,"t =",8,"h"]
[null,{"$f":"Translation!B62","v":"How often do you cool down the product"},null,null,null,30,{"$f":"Translation!B63","v":"per month"}]
[]
[]
[null,{"$f":"Translation!B64","v":"System information"}]
[]
[null,{"$f":"Translation!B65","v":"Batteries"},null,null,null,"Yes"]
[null,{"$f":"Translation!B66","v":"Autonomy of the system"},null,null,null,3,{"$f":"IF(K23=\"YES\",\"days\",\"\")","v":""}]
[null,{"$f":"Translation!B67","v":"System losses"},null,null,null,30,"%"]
[]
[]
[null,{"$f":"Translation!B77","v":"Isolation material"}]
[]
[null,{"$f":"Translation!B78","v":"Length of the refrigerator"},null,null,"x =",0.5,"m"]
[null,{"$f":"Translation!B79","v":"Width of the refrigerator"},null,null,"y =",0.5,"m",1,{"$f":"Translation!B70","v":"PV Panels"},null,5,{"$f":"Translation!B74","v":"Compressor"}]
[null,{"$f":"Translation!B80","v":"Height of the refrigerator"},null,null,"z =",0.5,"m",2,{"$f":"Translation!B71","v":"Charge Controller"},null,6,{"$f":"Translation!B75","v":"Refrigerator"}]
[null,{"$f":"Translation!B81","v":"Thermal conductivity of insulation"},null,null,"k /  l =",3.5000000000000003E-2,"W/m K",3,{"$f":"Translation!B72","v":"Batteries"},null,7,{"$f":"Translation!B76","v":"Evaporator plate"}]
[null,{"$f":"Translation!B82","v":"Thickness of insulation"},null,null,"L =",0.06,"m",4,{"$f":"Translation!B73","v":"Control Unit"}]
[]
[]
[null,{"$f":"Translation!B83","v":"Economic information"}]
[]
[null,{"$f":"Translation!B84","v":"Currency used for calculation"},null,null,null,"€"]
[null,{"$f":"Translation!B85","v":"Specific cost of PV"},null,null,null,1.1000000000000001,{"$f":"Translation!B99","v":"€/Wp"}]
[null,{"$f":"Translation!B86","v":"PV lifetime"},null,null,null,21,{"$f":"Translation!B93","v":"years"}]
[null,{"$f":"Translation!B87","v":"Specif cost of battery  "},null,null,null,2,{"$f":"F39&\"/Ah@12V\"","v":"€/Ah@12V"}]
[null,{"$f":"Translation!B88","v":"Battery lifetime"},null,null,null,3,{"$f":"Translation!B93","v":"years"}]
[null,{"$f":"Translation!B89","v":"Cost of solar cooling unit"},null,null,null,650,{"$f":"F39","v":"€"}]
[null,{"$f":"Translation!B90","v":"Solar cooling unit lifetime"},null,null,null,12,{"$f":"Translation!B93","v":"years"}]
[null,{"$f":"Translation!B91","v":"Material & construction costs for cooling box"},null,null,null,250,{"$f":"F39","v":"€"}]
[null,{"$f":"Translation!B92","v":"Maintenance costs per year"},null,null,null,25,{"$f":"Translation!B93","v":"years"}]
[]
[null,{"$f":"Translation!B94","v":"Additional income per product unit"},null,null,null,0.09,{"$f":"Translation!B98","v":"€/kg or l"}]
[null,{"$f":"Translation!B95","v":"Additional income per month"},null,null,null,0,{"$f":"Translation!B100","v":"€/month"}]
[null,{"$f":"Translation!B96","v":"Discount rate"},null,null,null,5,"%"]
[null,{"$f":"Translation!B97","v":"Inflation  "},null,null,null,3,"%"]

{"sheet":"3 Output","index":3,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,5,3],[5,7,5,9],[2,1,2,10]]}
[]
[]
[null,{"$f":"Translation!B101","v":"Results"}]
[]
[]
[null,{"$f":"Translation!B102","v":"System Design without batteries"},{"$nulls":5},{"$f":"Translation!B113","v":"System Design with batteries"}]
[]
[null,{"$f":"Translation!B103","v":"Cooling units needed:"},null,{"$f":"'Calculation Sheet'!P17","v":1},null,null,null,{"$f":"Translation!B103","v":"Cooling units needed:"},null,{"$f":"'Calculation Sheet'!P19","v":1}]
[null,{"$f":"Translation!B104","v":"Cooling units costs:"},null,{"$f":"'Calculation Sheet'!$U$74","v":650},{"$f":"'Calculation Sheet'!$E$69","v":"€"},null,null,{"$f":"Translation!B104","v":"Cooling units costs:"},null,{"$f":"'Calculation Sheet'!P74","v":650},{"$f":"'Calculation Sheet'!$E$69","v":"€"}]
[]
[null,{"$f":"Translation!B105","v":"Solar PV size:"},null,{"$f":"'Calculation Sheet'!$P$18","v":186},"Wp",null,null,{"$f":"Translation!B105","v":"Solar PV size:"},null,{"$f":"'Calculation Sheet'!P20","v":97},"Wp"]
[null,{"$f":"Translation!B106","v":"Solar PV costs:"},null,{"$f":"'Calculation Sheet'!U70","v":204.60000000000002},{"$f":"'Calculation Sheet'!$E$69","v":"€"},null,null,{"$f":"Translation!B106","v":"Solar PV costs:"},null,{"$f":"'Calculation Sheet'!P70","v":106.7},{"$f":"'Calculation Sheet'!$E$69","v":"€"}]
[]
[{"$nulls":7},{"$f":"Translation!B107","v":"Battery size:"},null,{"$f":"'Calculation Sheet'!P21","v":156},"Ah (12V)"]
[{"$nulls":7},{"$f":"Translation!B108","v":"Battery costs:"},null,{"$f":"'Calculation Sheet'!P72","v":312},{"$f":"'Calculation Sheet'!$E$69","v":"€"}]
[]
[]
[null,{"$f":"Translation!B109","v":"Total initial investment:"},null,{"$f":"'Calculation Sheet'!B130","v":1104.5999999999999},{"$f":"'Calculation Sheet'!$E$69","v":"€"},null,null,{"$f":"Translation!B109","v":"Total initial investment:"},null,{"$f":"'Calculation Sheet'!B104","v":1318.7},{"$f":"'Calculation Sheet'!$E$69","v":"€"}]
[null,{"$f":"Translation!B110","v":"Payback period:"},null,{"$f":"'Calculation Sheet'!B131","v":3},{"$f":"Translation!B114","v":"years"},null,null,{"$f":"Translation!B110","v":"Payback period:"},null,{"$f":"'Calculation Sheet'!B105","v":4.5999999999999996},{"$f":"Translation!B114","v":"years"}]
[null,{"$f":"Translation!B111","v":"Net present value:"},null,{"$f":"'Calculation Sheet'!B132","v":2825.5417354761535},{"$f":"'Calculation Sheet'!$E$69","v":"€"},null,null,{"$f":"Translation!B111","v":"Net present value:"},null,{"$f":"'Calculation Sheet'!B106","v":1074.2959286584417},{"$f":"'Calculation Sheet'!$E$69","v":"€"}]
[null,{"$f":"Translation!B112","v":"Internal rate of return:"},null,{"$f":"'Calculation Sheet'!B133*100","v":31.587528980005118},"%",null,null,{"$f":"Translation!B112","v":"Internal rate of return:"},null,{"$f":"'Calculation Sheet'!B107*100","v":16.250021565895011},"%"]

{"sheet":"Calculation Sheet","index":4,"n_rows":133,"n_cols":31,"rows_kept":133,"cut":false,"hidden":false,"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.1},{"$f":"'1 Geographic Data'!C8","v":27.8},{"$f":"'1 Geographic Data'!D8","v":30.3},{"$f":"'1 Geographic Data'!E8","v":31.1},{"$f":"'1 Geographic Data'!F8","v":31.5},{"$f":"'1 Geographic Data'!G8","v":29},{"$f":"'1 Geographic Data'!H8","v":27.4},{"$f":"'1 Geographic Data'!I8","v":25.9},{"$f":"'1 Geographic Data'!J8","v":26.4},{"$f":"'1 Geographic Data'!K8","v":27.4},{"$f":"'1 Geographic Data'!L8","v":26.5},{"$f":"'1 Geographic Data'!M8","v":24.8}]
["Solar irradiation [kWh/m² day]:",{"$f":"'1 Geographic Data'!B9","v":5.4},{"$f":"'1 Geographic Data'!C9","v":5.9},{"$f":"'1 Geographic Data'!D9","v":6.9},{"$f":"'1 Geographic Data'!E9","v":6.6},{"$f":"'1 Geographic Data'!F9","v":6.4},{"$f":"'1 Geographic Data'!G9","v":6.1},{"$f":"'1 Geographic Data'!H9","v":5.8},{"$f":"'1 Geographic Data'!I9","v":5.6},{"$f":"'1 Geographic Data'!J9","v":5.8},{"$f":"'1 Geographic Data'!K9","v":5.8},{"$f":"'1 Geographic Data'!L9","v":5.7},{"$f":"'1 Geographic Data'!M9","v":5.4}]
["Thermal losses for each day [kWh]:",{"$f":"$E$52*$E$55*(B4-$E$39)*24/1000","v":0.44310000000000005},{"$f":"$E$52*$E$55*(C4-$E$39)*24/1000","v":0.49979999999999997},0.5522999999999999,0.56910000000000005,0.57750000000000001,0.52500000000000002,0.4914,0.45989999999999998,0.47039999999999998,0.4914,0.47249999999999998,0.43679999999999997]
["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.73640000000000005},{"$f":"C6+C11","v":0.79309999999999992},0.84559999999999991,0.86240000000000006,0.87080000000000002,0.81830000000000003,0.78469999999999995,0.75319999999999998,0.76370000000000005,0.78469999999999995,0.76580000000000004,0.73009999999999997]
["COP without battery:",{"$f":"$E$43*(1/((B4+5+273.15)/((MIN(-5,$E$42))+273.15)-1))","v":1.9099002849002824},{"$f":"$E$43*(1/((C4+5+273.15)/((MIN(-5,$E$42))+273.15)-1))","v":1.7734788359788365},1.6634615384615381,1.6310827250608273,1.6153614457831316,1.7189102564102563,1.7924465240641729,1.867339832869082,1.8416895604395609,1.7924465240641729,1.8366438356164392,1.926364942528735]
["COP with battery:",{"$f":"$E$43*(1/((B4+5+273.15)/($E$42+273.15)-1))","v":2.187700964630225},{"$f":"$E$43*(1/((C4+5+273.15)/($E$42+273.15)-1))","v":2.0129437869822477},1.8743112947658405,1.8338948787061973,1.8143333333333345,1.9439285714285717,2.0370508982035953,2.1328369905956119,2.0999228395061729,2.0370508982035953,2.0934615384615376,2.2090097402597388]
["Energy needed without battery [kWhel]:",{"$f":"B12/B13","v":0.38556986761141204},{"$f":"C12/C13","v":0.44720014917024037},0.50833757225433529,0.52872854745478282,0.5390743986574682,0.4760574305426068,0.43778154018273308,0.40335454036919605,0.41467357822114481,0.43778154018273308,0.41695618124184208,0.37900399030393445,null,"Maximum values "]
["Engergy needed with battery [kWhel]:",{"$f":"B12/B14","v":0.33660907587727362},{"$f":"C12/C14","v":0.39400007348888494},0.4511523792026455,0.4702559617857805,0.47995590666911603,0.42095168105823988,0.38521374242145828,0.35314466286974083,0.36368002939555394,0.38521374242145828,0.36580562189968785,0.33051008634943985,null,null,"rounded"]
["Cooling units needed (no battery):",{"$f":"1000*B15/(70*8)","v":0.68851762073466438},{"$f":"1000*C16/(70*8)","v":0.70357155980158026},0.80562924857615259,0.83974278890317944,0.85706411905199287,0.75169943046114263,0.68788168289546126,0.63061546941025148,0.64942862392063205,0.68788168289546126,0.65322432482087112,0.59019658276685694,null,{"$f":"MAX(B17:M17)","v":0.85706411905199287},{"$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$63/100)*1.7*1000*B15/B5","v":157.79803841133713},{"$f":"(1+$E$63/100)*1.7*1000*C15/C5","v":167.51056435020868},162.81536734522913,177.04395301137424,186.14912828640698,172.47326581953459,166.80986272480001,159.18098825284346,158.00493239116037,166.80986272480001,161.66195799025809,155.11089232809167,null,{"$f":"MAX(B18:M18)","v":186.14912828640698},{"$f":"ROUND(O18,0)","v":186}]
["Cooling units needed (with battery):",{"$f":"1000*B16/(70*24)","v":0.20036254516504381},{"$f":"1000*C16/(70*24)","v":0.23452385326719341},0.26854308285871753,0.27991426296772648,0.28568803968399764,0.25056647682038091,0.22929389429848707,0.21020515647008384,0.21647620797354403,0.22929389429848707,0.21774144160695705,0.19673219425561897,null,0.28568803968399764,{"$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$63/100)*1000*B16/B5","v":81.035518266751055},{"$f":"(1+$E$63/100)*1000*C16/C5","v":86.813575514500059},84.999723617889728,92.626174291138582,97.491043542164178,89.711013996018352,86.341011232395829,81.980011023332693,81.514489347279337,86.341011232395829,83.429352363086707,79.567243010050333,null,97.491043542164178,97]
["Battery (Ah related to 12 V):",{"$f":"MAX($E$62,1)*(1+$E$63/100)*1000*B16/12","v":109.39794966011395},{"$f":"MAX($E$62,1)*(1+$E$63/100)*1000*C16/12","v":128.05002388388763},146.62452324085982,152.83318758037868,155.98566966746273,136.80929634392797,125.19446628697396,114.77201543266578,118.19600955355504,125.19446628697396,118.88682711739857,107.41577806356797,null,155.98566966746273,156]
[]
[]
[]
["Product information"]
[]
[{"$f":"'2 Input'!B8","v":"Total mass to be cooled"},null,null,"Mass =",{"$f":"'2 Input'!F8","v":12},"kg or l"]
[{"$f":"'2 Input'!B9","v":" Moisture content of the product"},null,null,"MC =",{"$f":"'2 Input'!F9","v":100},"%"]
[{"$f":"'2 Input'!B10","v":" or Heat capacity of the product"},null,null,"cp =",{"$f":"'2 Input'!F10","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'!B17","v":"Time to cool down the product"},null,null,"t =",{"$f":"'2 Input'!F17","v":8},"h"]
[{"$f":"'2 Input'!B18","v":"How often do you cool down the product"},null,null,null,{"$f":"'2 Input'!F18","v":30}]
[]
[]
["Temperature information"]
[]
[{"$f":"'2 Input'!B15","v":"Initial temperature of the product"},null,null,"Ti =",{"$f":"'2 Input'!F15","v":25},"°C"]
[{"$f":"'2 Input'!B16","v":"Final temperature of the product"},null,null,"Tm =",{"$f":"'2 Input'!F16","v":4},"°C"]
[]
["Maximum Temperature within the year:",null,null,"Tyearmax =",{"$f":"MAX(B4:M4)","v":31.5},"°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.0934615384615376}]
[]
[]
["Isolation material"]
[]
["Length of the refrigerator",null,null,"x =",{"$f":"'2 Input'!F30","v":0.5},"m"]
["Width of the refrigerator",null,null,"y =",{"$f":"'2 Input'!F31","v":0.5},"m"]
["Height of the refrigerator",null,null,"z =",{"$f":"'2 Input'!F32","v":0.5},"m"]
["Area of the refrigerator",null,null,"A =",{"$f":"2*(E49*E50+E50*E51+E49*E51)","v":1.5},"m²"]
[{"$f":"'2 Input'!B33","v":"Thermal conductivity of insulation"},null,null,"k /  l =",{"$f":"'2 Input'!F33","v":3.5000000000000003E-2},"W/m K",{"$nulls":8},"Batteries:"]
[{"$f":"'2 Input'!B34","v":"Thickness of insulation"},null,null,"L =",{"$f":"'2 Input'!F34","v":0.06},"m",{"$nulls":9},"Yes",{"$f":"IF(H84=\"Yes\",1,0)","v":1}]
[null,null,null,"U =",{"$f":"E53/E54","v":0.58333333333333337},{"$nulls":10},"No",{"$f":"1-Q54","v":0}]
[]
[]
[]
["System information"]
[]
["Batteries ",null,null,null,{"$f":"'2 Input'!F23","v":"Yes"}]
[{"$f":"'2 Input'!B24","v":"Autonomy of the system"},null,null,null,{"$f":"'2 Input'!F24","v":3}]
[{"$f":"'2 Input'!B25","v":"System losses"},null,null,null,{"$f":"'2 Input'!F25","v":30},"%"]
[]
[]
[]
["Economic information",{"$nulls":6},"Income",{"$nulls":5},"System with Battery",{"$nulls":4},"System without Battery"]
[]
[{"$f":"'2 Input'!B39","v":"Currency used for calculation"},null,null,null,{"$f":"'2 Input'!F39","v":"€"}]
[{"$f":"'2 Input'!B40","v":"Specific cost of PV"},null,null,null,{"$f":"'2 Input'!F40","v":1.1000000000000001},{"$f":"E69&\"/Wp\"","v":"€/Wp"},null,"Additional income per product:",null,null,{"$f":"E78*E27*E33*12","v":388.80000000000007},{"$f":"E69&\"/year\"","v":"€/year"},null,"Total PV Costs:",null,{"$f":"P20*E70","v":106.7},null,null,"Total PV Costs:",null,{"$f":"P18*E70","v":204.60000000000002}]
[{"$f":"'2 Input'!B41","v":"PV lifetime"},null,null,null,{"$f":"'2 Input'!F41","v":21},"years",null,"Additional income per year:",null,null,{"$f":"E79*12","v":0},{"$f":"E69&\"/year\"","v":"€/year"},null,"Lifetime PV:",null,{"$f":"E71","v":21},null,null,"Lifetime PV:",null,{"$f":"E71","v":21}]
[{"$f":"'2 Input'!B42","v":"Specif cost of battery  "},null,null,null,{"$f":"'2 Input'!F42","v":2},{"$f":"E69&\"/Ah@12V\"","v":"€/Ah@12V"},null,"Total income :",null,null,{"$f":"SUM(K70:K71)","v":388.80000000000007},{"$f":"E69&\"/year\"","v":"€/year"},null,"Total Battery costs:",null,{"$f":"P21*E72","v":312}]
[{"$f":"'2 Input'!B43","v":"Battery lifetime"},null,null,null,{"$f":"'2 Input'!F43","v":3},"years",{"$nulls":7},"Lifetime battery:",null,{"$f":"E73","v":3}]
[{"$f":"'2 Input'!B44","v":"Cost of solar cooling unit"},null,null,null,{"$f":"'2 Input'!F44","v":650},{"$f":"E69","v":"€"},{"$nulls":7},"Total solar cooling unit costs:",null,{"$f":"P19*E74","v":650},null,null,"Total solar cooling unit costs:",null,{"$f":"P17*E74","v":650}]
[{"$f":"'2 Input'!B45","v":"Solar cooling unit lifetime"},null,null,null,{"$f":"'2 Input'!F45","v":12},"years",{"$nulls":7},"Lifetime cooling unit:",null,{"$f":"E75","v":12},null,null,"Lifetime cooling unit:",null,{"$f":"E75","v":12}]
[{"$f":"'2 Input'!B46","v":"Material & construction costs for cooling box"},null,null,null,{"$f":"'2 Input'!F46","v":250},{"$f":"E69","v":"€"},{"$nulls":7},"Material & construction:",null,{"$f":"E76","v":250},null,null,"Material & construction:",null,{"$f":"E76","v":250}]
[{"$f":"'2 Input'!B47","v":"Maintenance costs per year"},null,null,null,{"$f":"'2 Input'!F47","v":25},{"$f":"E69&\"/year\"","v":"€/year"},{"$nulls":7},"Maintenance per year:",null,{"$f":"E77","v":25},null,null,"Maintenance per year:",null,{"$f":"E77","v":25}]
[{"$f":"'2 Input'!B49","v":"Additional income per product unit"},null,null,null,{"$f":"'2 Input'!F49","v":0.09},{"$f":"E69&\"/kg or l\"","v":"€/kg or l"}]
[{"$f":"'2 Input'!B50","v":"Additional income per month"},null,null,null,{"$f":"'2 Input'!F50","v":0},{"$f":"E69&\"/year\"","v":"€/year"}]
[{"$f":"'2 Input'!B51","v":"Discount rate"},null,null,null,{"$f":"'2 Input'!F51","v":5},"%"]
[{"$f":"'2 Input'!B52","v":"Inflation  "},null,null,null,{"$f":"'2 Input'!F52","v":3},"%"]
[]
[]
[null,"Economic Analysis: System with battery",null,null,null,"With batteries? ",null,{"$f":"IF(OR('2 Input'!F23=Translation!E68,'2 Input'!F23=Translation!F68,'2 Input'!F23=Translation!G68),\"Yes\",\"No\")","v":"Yes"}]
[]
[null,null,null,{"$f":"IF(E102<0,0,1)","v":0},0,0,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":"P70","v":106.7},{"$f":"IF(MOD(D87,$P$71)=0,$C$89*(1+($E$81/100))^D87,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,198.49343080140318,0,0,0,0]
["Battery Costs",null,{"$f":"P72","v":312},{"$f":"IF(MOD(D87,$P$73)=0,$C$90*(1+($E$81/100))^D87,0)","v":0},0,340.93082400000003,0,0,372.54431651704795,0,0,407.08923335472429,0,0,444.83739669600772,0,0,486.08583397943852,0,0,531.15911510684975,0,0,580.41190637336263,0,0,634.23176121564541,0]
["Solar cooling units cost",null,{"$f":"P74","v":650},{"$f":"IF(MOD(D87,$P$75)=0,$C$91*(1+($E$81/100))^D87,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":"P76","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":"P77","v":25},{"$f":"$D$93*(1+($E$81/100))^(E87-1)","v":25.75},{"$f":"$D$93*(1+($E$81/100))^(F87-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(C89:C94)","v":1318.7},{"$f":"SUM(D89:D94)","v":25},25.75,367.45332400000001,27.318175,28.137720249999997,401.52616837454792,29.851307413224998,30.74684663562175,438.75848538941466,32.619329595731109,33.597909483603047,1406.1878199141349,35.644022171154468,36.713342836289101,523.90057710081624,38.949185415019109,40.117660977469676,572.48030591364352,42.560826530997581,43.837651326927507,824.05811804150119,46.507364292737385,47.902585221519509,2004.8875931930718,50.819852661510048]
["Expenses per year accumulated:",null,{"$f":"C95","v":1318.7},{"$f":"SUM($C$95:D95)","v":1343.7},{"$f":"SUM($C$95:E95)","v":1369.45},{"$f":"SUM($C$95:F95)","v":1736.9033240000001},{"$f":"SUM($C$95:G95)","v":1764.2214990000002},{"$f":"SUM($C$95:H95)","v":1792.3592192500003},{"$f":"SUM($C$95:I95)","v":2193.885387624548},{"$f":"SUM($C$95:J95)","v":2223.7366950377732},{"$f":"SUM($C$95:K95)","v":2254.4835416733949},{"$f":"SUM($C$95:L95)","v":2693.2420270628095},{"$f":"SUM($C$95:M95)","v":2725.8613566585404},{"$f":"SUM($C$95:N95)","v":2759.4592661421434},{"$f":"SUM($C$95:O95)","v":4165.6470860562786},{"$f":"SUM($C$95:P95)","v":4201.2911082274331},{"$f":"SUM($C$95:Q95)","v":4238.0044510637226},{"$f":"SUM($C$95:R95)","v":4761.9050281645386},{"$f":"SUM($C$95:S95)","v":4800.8542135795578},{"$f":"SUM($C$95:T95)","v":4840.9718745570271},{"$f":"SUM($C$95:U95)","v":5413.452180470671},{"$f":"SUM($C$95:V95)","v":5456.0130070016685},{"$f":"SUM($C$95:W95)","v":5499.8506583285962},{"$f":"SUM($C$95:X95)","v":6323.9087763700973},{"$f":"SUM($C$95:Y95)","v":6370.4161406628346},{"$f":"SUM($C$95:Z95)","v":6418.3187258843536},{"$f":"SUM($C$95:AA95)","v":8423.2063190774261},{"$f":"SUM($C$95:AB95)","v":8474.0261717389367}]
["Expenses per year accumulated (for hiding in the diagramm):",null,{"$f":"IF($H$84=\"YES\",C96,NA())","v":1318.7},{"$f":"IF($H$84=\"YES\",D96,NA())","v":1343.7},1369.45,1736.9033240000001,1764.2214990000002,1792.3592192500003,2193.885387624548,2223.7366950377732,2254.4835416733949,2693.2420270628095,2725.8613566585404,2759.4592661421434,4165.6470860562786,4201.2911082274331,4238.0044510637226,4761.9050281645386,4800.8542135795578,4840.9718745570271,5413.452180470671,5456.0130070016685,5499.8506583285962,6323.9087763700973,6370.4161406628346,6418.3187258843536,8423.2063190774261,8474.0261717389367]
[]
[" Accumulated income per year:",null,0,{"$f":"K72","v":388.80000000000007},{"$f":"$K$72+D99","v":777.60000000000014},{"$f":"$K$72+E99","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$72","v":388.80000000000007},{"$f":"$K$72","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":"C99-C96","v":-1318.7},{"$f":"D100-D95","v":363.80000000000007},363.05000000000007,21.346676000000059,361.48182500000007,360.6622797500001,-12.726168374547854,358.94869258677505,358.05315336437832,-49.958485389414591,356.18067040426894,355.20209051639699,-1017.3878199141349,353.15597782884561,352.08665716371098,-135.10057710081617,349.85081458498098,348.68233902253041,-183.68030591364345,346.23917346900248,344.96234867307254,-435.25811804150112,342.29263570726266,340.89741477848054,-1616.0875931930718,337.98014733849004]
["Accumulated cashflow per year (for payback calculation)",null,{"$f":"C101","v":-1318.7},{"$f":"C102+D101","v":-954.9},{"$f":"D102+E101","v":-591.84999999999991},-570.50332399999979,-209.02149899999972,151.64078075000037,138.91461237545252,497.86330496222757,855.91645832660583,805.95797293719124,1162.1386433414602,1517.3407338578572,499.95291394372236,853.10889177256797,1205.195548936279,1070.0949718354627,1419.9457864204437,{"$f":"S102+T101","v":1768.6281254429741},{"$f":"T102+U101","v":1584.9478195293307},{"$f":"U102+V101","v":1931.1869929983332},{"$f":"V102+W101","v":2276.1493416714056},{"$f":"W102+X101","v":1840.8912236299045},{"$f":"X102+Y101","v":2183.1838593371672},{"$f":"Y102+Z101","v":2524.0812741156478},{"$f":"Z102+AA101","v":907.993680922576},{"$f":"AA102+AB101","v":1245.973828261066}]
[null,null,{"$f":"C87+ABS(C102)/(ABS(C102)+ABS(D102))","v":0.58000527797325829},1.6173589785033133,2.5091825246072941,3.7318603682233222,4.5795490982447262,5.5218997283747768,6.2181523708552016,7.367757975457347,8.5150307641930034,9.4095113859100703,10.433718077187132,11.752166515525113,12.369497469983683,13.414471676249589,14.529688643245214,15.429749982319562,16.445323152503189,17.527385738228027,18.450764235171619,19.459004662186086,20.552860557375833,21.457469402452741,22.463790289572191,23.73543885468187,24.421544743386917,26]
["Total initial investment costs:",{"$f":"SUM(C89:C93)","v":1318.7},{"$f":"E69","v":"€"}]
["Payback period:",{"$f":"ROUND(IF(W102<0,25,HLOOKUP(1,D86:AB103,18,FALSE)),1)","v":4.5999999999999996},"years"]
["Net Present Value:",{"$f":"C101+NPV((E80/100),D101:W101)","v":1074.2959286584417},{"$f":"E69","v":"€"}]
["Internal Rate of Return:",{"$f":"IRR(C101:W101)","v":0.16250021565895012}]
[]
[]
[]
[]
[null,"Economic Analysis: System without battery"]
[]
[null,null,null,{"$f":"IF(E128<0,0,1)","v":0},{"$f":"IF(F128<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]
[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":"U70","v":204.60000000000002},{"$f":"IF(MOD(D115,$U$71)=0,$C$117*(1+($E$81/100))^D115,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,380.61626937176283,0,0,0,0]
["Solar cooling units cost",null,{"$f":"U74","v":650},{"$f":"IF(MOD(D115,$U$75)=0,$C$118*(1+($E$81/100))^D115,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,{"$f":"Translation!B117","v":"Accumulated income"}]
["Material & Construction",null,{"$f":"U76","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(H84=\"Yes\",Translation!B119,\"\")","v":"Accumulated system costs with batteries"}]
["Maintenance costs",null,0,{"$f":"U77","v":25},{"$f":"$D$120*(1+($E$81/100))^(E115-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,{"$f":"Translation!B118","v":"Accumulated system costs without batteries"}]
[]
["Expenses per year:",null,{"$f":"SUM(C117:C121)","v":1104.5999999999999},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,425.76905023849815,46.507364292737385,47.902585221519509,1370.6558319774263,50.819852661510048]
["Expenses per year accumulated:",null,{"$f":"C122","v":1104.5999999999999},{"$f":"SUM($C$122:D122)","v":1129.5999999999999},{"$f":"SUM($C$122:E122)","v":1155.3499999999999},{"$f":"SUM($C$122:F122)","v":1181.8724999999999},{"$f":"SUM($C$122:G122)","v":1209.1906750000001},{"$f":"SUM($C$122:H122)","v":1237.3283952500001},{"$f":"SUM($C$122:I122)","v":1266.3102471075001},{"$f":"SUM($C$122:J122)","v":1296.1615545207251},{"$f":"SUM($C$122:K122)","v":1326.9084011563468},{"$f":"SUM($C$122:L122)","v":1358.5776531910371},{"$f":"SUM($C$122:M122)","v":1391.1969827867683},{"$f":"SUM($C$122:N122)","v":1424.7948922703713},{"$f":"SUM($C$122:O122)","v":2386.1453154884985},{"$f":"SUM($C$122:P122)","v":2421.789337659653},{"$f":"SUM($C$122:Q122)","v":2458.5026804959421},{"$f":"SUM($C$122:R122)","v":2496.3174236173199},{"$f":"SUM($C$122:S122)","v":2535.2666090323391},{"$f":"SUM($C$122:T122)","v":2575.3842700098089},{"$f":"SUM($C$122:U122)","v":2616.7054608166027},{"$f":"SUM($C$122:V122)","v":2659.2662873476002},{"$f":"SUM($C$122:W122)","v":2703.1039386745279},{"$f":"SUM($C$122:X122)","v":3128.8729889130259},{"$f":"SUM($C$122:Y122)","v":3175.3803532057632},{"$f":"SUM($C$122:Z122)","v":3223.2829384272827},{"$f":"SUM($C$122:AA122)","v":4593.9387704047094},{"$f":"SUM($C$122:AB122)","v":4644.7586230662191}]
[]
[" Accumulated investment per year:",null,0,{"$f":"K72","v":388.80000000000007},{"$f":"$K$72+D125","v":777.60000000000014},{"$f":"$K$72+E125","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$72","v":388.80000000000007},{"$f":"$K$72","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":"C125-C123","v":-1104.5999999999999},{"$f":"D126-D122","v":363.80000000000007},{"$f":"E126-E122","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,-36.969050238498085,342.29263570726266,340.89741477848054,-981.85583197742619,337.98014733849004]
["Accumulated cashflow per year (for payback calculation)",null,{"$f":"C127","v":-1104.5999999999999},{"$f":"C128+D127","v":-740.79999999999984},{"$f":"D128+E127","v":-377.74999999999977},-15.472499999999684,346.00932500000039,706.67160475000048,1066.4897528925005,1425.4384454792755,1783.4915988436537,2140.6223468089634,2496.8030172132321,2852.0051077296293,2279.4546845115019,2632.6106623403475,2984.6973195040587,3335.682576382681,3685.5333909676619,4034.2157299901924,4381.6945391833988,4727.9337126524015,5072.896061325474,5035.9270110869757,5378.2196467942385,5719.1170615727187,4737.2612295952922,5075.2413769337818]
[null,null,null,{"$f":"D115+ABS(D128)/(ABS(D128)+ABS(E128))","v":1.6622859952617228},{"$f":"E115+ABS(E128)/(ABS(E128)+ABS(F128))","v":2.9606520481406844},3.0428029818649933,4.3286934485287709,5.3985376749296821,6.4279777216652327,7.4442098848496512,8.4544953646974292,9.4615971533291336,10.466796145774982,11.555788259715474,12.464052190586676,13.468660552501156,14.472233848070822,15.475086166255828,16.477416213042734,17.479355839233101,18.480995976789764,19.482401370260046,20.501828553629522,21.483565977753528,22.484640575313829,23.546950091352699,24.482778086238998,26]
["Total initial investment costs:",{"$f":"SUM(C117:C121)","v":1104.5999999999999},{"$f":"E69","v":"€"}]
["Payback period:",{"$f":"ROUND(IF(W128<0,25,HLOOKUP(1,D114:AB129,16,FALSE)),1)","v":3},"years"]
["Net Present Value:",{"$f":"C127+NPV((E80/100),D127:W127)","v":2825.5417354761535},{"$f":"E69","v":"€"}]
["Internal Rate of Return:",{"$f":"IRR(C127:W127)","v":0.3158752898000512}]

{"sheet":"Translation","index":5,"n_rows":119,"n_cols":8,"rows_kept":119,"cut":false,"hidden":false,"merged":[[45,2,99,3],[100,2,118,3],[5,2,26,3],[27,2,44,3]]}
[]
[null,"Selected language:",{"$f":"'READ ME'!E4","v":"English"}]
[null,"Number:",{"$f":"MATCH(C2,E5:H5,0)","v":1}]
[{"$nulls":4},1,2,3,4]
[null,"Appearence in the tool",null,null,"English","Français","Español","Deutsch"]
[null,{"$f":"INDEX(E6:H6,$C$3)","v":"Design Tool: Solar Refrigerator"},"Read me",null,"Design Tool: Solar Refrigerator","Outil de conception: Réfrigerateur Solaire","Herramienta de Disenyo: Refrigerador Solar"]
[null,{"$f":"INDEX(E7:H7,$C$3)","v":"Read Me Sheet "},null,null,"Read Me Sheet ","Lisez-moi","Leame"]
[null,"Introduction",null,null,"Introduction","Introduction","Introdución"]
[null,"This tool calculates the required power of a do-it-yourself refrigerator to cool different products from a given to a desired temperature and gives an economic analysis. Examplary data is filled and and can be modified by own data. ",null,null,"This tool calculates the required power of a do-it-yourself refrigerator to cool different products from a given to a desired temperature and gives an economic analysis. Examplary data is filled and and can be modified by own data. ","Cet outil calcule la puissance requise d'un réfrigérateur de bricolage pour refroidir différents produits d'une température donnée à une température souhaitée et fournit une analyse économique. Des données d'exemple sont remplies et peuvent être modifiées par vos propres données.","Esta Herramienta calcula el sistema solar (con o sin baterias) requerido para un refrigerador"]
[null,"Tips & Tricks",null,null,"Tips & Tricks","Conseils et astuces","Consejos"]
[null,"● Enter values into white (non-coloured) cells only!\n● None entry cells (coloured cells) are protected. Unprotect first if changes are necessary\n",null,null,"● Enter values into white (non-coloured) cells only!\n● None entry cells (coloured cells) are protected. Unprotect first if changes are necessary\n","● Saisissez des valeurs uniquement dans les cellules blanches (non colorées)!\n● Les cellules qui ne doivent pas être remplies(cellules de couleur) sont protégées. ","Inserte los valores unicamente en las celdas de color blanco"]
[null,"Overview of the following sheets",null,null,"Overview of the following sheets","Aperçu des feuilles","Resumen de las tablas"]
[null,"1. Geographic Data",null,null,"1. Geographic Data","1. Geographic Data","1. Geographic Data"]
[null,"2. Input",null,null,"2. Input","2. Input","2. Input"]
[null,"3. Output",null,null,"3. Output","3. Output","3. Output"]
[null,"4. Weather Data",null,null,"4. Weather Data","4. Weather Data","4. Weather Data"]
[null,"Calculation Sheet (Hidden)",null,null,"Calculation Sheet (Hidden)","Feuille de calcul (caché)","Hoja de cálculo (no visible)"]
[null,"Translation sheet (Hidden)",null,null,"Translation sheet (Hidden)","Feuille de traduction (caché)","Hoja de tradución (no visible)"]
[null,"For selecting basic site information: ambient temperatures or solar radiation. ",null,null,"For selecting basic site information: ambient temperatures or solar radiation. ","Pour choisir des informations de base sur le site: températures ambiantes ou rayonnement solaire.","Selection de datos climaticos: Temperatura ambiente y radiación solar"]
[null,"For adding data about the product to be cooled under given conditions",null,null,"For adding data about the product to be cooled under given conditions","Pour ajouter des données sur le produit à refroidir dans des conditions données","Datos acerca del producto a ser refrigerado ( carga térmica)"]
[null,"For an overview of the results",null,null,"For an overview of the results","Pour un aperçu des résultats","Resumen de los resultados"]
[null,"To add weather data for a specific location",null,null,"To add weather data for a specific location","Pour ajouter des données météorologiques pour un endroit spécifique","Para añadir datos meteorológicos para una ubicación específica"]
[null,"All calculations are done within this sheet",null,null,"All calculations are done within this sheet","Tous les calculs sont effectués dans cette feuille","Todos los cálculos están hechos en esta tabla"]
[null,"Contains the translation into several languages",null,null,"Contains the translation into several languages","Contient la traduction en plusieurs langues","Contiene la tradución a distintos idiomas"]
[null,"Additional information",null,null,"Additional information","Informatios supplémentaires","Información adicional"]
[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,"This tool was created by the solar cooling group of the Institute of  Agricultural Engineering ( Tropics/Subtropics Department) of the University of Hohenheim, Germany. ","Cet outil a été créé par le groupe de refroidissement solaire de l’Institut d'Ingénierie Agricole (Département tropiques / subtropiques) de l’Université de Hohenheim, en Allemagne.","Esta Herramienta ha sido creada por el grupo de refrigeración solar del Instituto de Ingeniería Agrónoma de la Universidad de Hohenheim en Alemania."]
[null,"In cooperation with",null,null,"In cooperation with","En coopération avec","En cooperación con:"]
[null,"1. Geographic Data","1 Geographic Data",null,"1. Geographic Data","1. Données géographiques","1. Datos Climáticos"]
[null,"Mean daily temperature [°C]:",null,null,"Mean daily temperature [°C]:","Temperature quotidienne moyenne [°C]","Temperatura media diaria [°C]"]
[null,"Solar irradiation [kWh/m² day]:",null,null,"Solar irradiation [kWh/m² day]:","Irradiation solaire [kWh/m² jour]","Irradiación solar  [kWh/m² dia]:"]
[null,"January",null,null,"January","Janvier","Enero"]
[null,"February",null,null,"February","Février","Febrero"]
[null,"March",null,null,"March","Mars ","Marzo"]
[null,"April",null,null,"April","Avril","Abril"]
[null,"May",null,null,"May","Mai","Mayo"]
[null,"June",null,null,"June","Juin","Junio"]
[null,"July",null,null,"July","Juillet","Julio"]
[null,"August",null,null,"August","Août","Agosto"]
[null,"September",null,null,"September","Septembre","Septiembre"]
[null,"October",null,null,"October","Octobre ","Octubre "]
[null,"November",null,null,"November","Novembre","Noviembre"]
[null,"December",null,null,"December","Décembre","Diciembre"]
[null,"Choose location:",null,null,"Choose location:","Selectionner localisation:","Selectionar ubicación:"]
[null,"Locations can be added on the sheet \"Weather Data\"",null,null,"Locations can be added on the sheet \"Weather Data\"","Des localisations peuvent être ajoutées sur la feuille \"Weather Data\"","Las ubicaciones pueden ser añadidas en la hoja \"Weather Data\"."]
[null,"Use to obtain indicative monthly irradiation and temperature data for the site:",null,null,"Use to obtain indicative monthly irradiation and temperature data for the site:","À utiliser pour obtenir des données indicatives mensuelles sur l’irradiation et la température du site:","Usar para obtener valores indicativos de la temperatura media y radiación solar mensual:"]
[null,"Input of parameters","2 Input",null,"Input of parameters","Entrée de paramètres","Entrada de parámetros"]
[null,"Product information",null,null,"Product information","Information du produit","Información del producto"]
[null,"Data",null,null,"Data","Données","Datos"]
[null,"Total mass to be cooled",null,null,"Total mass to be cooled","Masse totale à refroidir","Masa total a ser refrigerada"]
[null," Moisture content of the product",null,null," Moisture content of the product","Teneur en humidité du produit","Contenido de Humedad del producto"]
[null," or Heat capacity of the product",null,null," or Heat capacity of the product","ou capacité thermique du produit","o Capacidad calorífica del producto"]
[null,"Mass =",null,null,"Mass =","Masse =","Masa="]
[null,"MC =",null,null,"MC =","MC =","MC="]
[null,"cp =",null,null,"cp =","cp =","cp="]
[null,"kg or l",null,null,"kg or l","kg ou l","kg ó l"]
[null,"% wet based",null,null,"% wet based","% à base humide","% base humeda"]
[null,"kJ/kg K",null,null,"kJ/kg K","kJ/kg K","kJ/kg K"]
[null,"Temperature information",null,null,"Temperature information","Information des températures","Información de temperatura"]
[null,"Initial temperature of the product",null,null,"Initial temperature of the product","Température initiale du produit","Temperatura inicial del producto"]
[null,"Final temperature of the product",null,null,"Final temperature of the product","Température finale du produit","Temperatura final del producto"]
[null,"Time to cool down the product",null,null,"Time to cool down the product","Temps pour refroidir le produit","Tiempo para refrigerar el producto"]
[null,"How often do you cool down the product",null,null,"How often do you cool down the product","À quelle fréquence refroidissez-vous le produit?","En que frecuencia se introduce el producto en el refrigerador?"]
[null,"per month",null,null,"per month","par mois","al mes"]
[null,"System information",null,null,"System information","Informations du système","Información dle sistema"]
[null,"Batteries",null,null,"Batteries","Batteries","Baterias"]
[null,"Autonomy of the system",null,null,"Autonomy of the system","Autonomie du système","Autonomía"]
[null,"System losses",null,null,"System losses","Pertes du système","Perdidas del sistema"]
[null,"Yes",null,null,"Yes","Oui","Si"]
[null,{"$f":"INDEX(E69:H69,$C$3)","v":"No"},null,null,"No","Non","No "]
[null,"PV Panels",null,null,"PV Panels","Panneau solaires"]
[null,"Charge Controller",null,null,"Charge Controller","Contrôleur de charge"]
[null,"Batteries",null,null,"Batteries","Batteries"]
[null,"Control Unit",null,null,"Control Unit","Unité de control"]
[null,"Compressor",null,null,"Compressor","Compressseur"]
[null,"Refrigerator",null,null,"Refrigerator","Réfrigérateur"]
[null,"Evaporator plate",null,null,"Evaporator plate","Plaque d'évaporateur"]
[null,"Isolation material",null,null,"Isolation material","Matériau d'isolation","Aislamiento"]
[null,"Length of the refrigerator",null,null,"Length of the refrigerator","Longueur du réfrigérateur"]
[null,"Width of the refrigerator",null,null,"Width of the refrigerator","Largeur du réfrigérateur"]
[null,"Height of the refrigerator",null,null,"Height of the refrigerator","Hauteur du réfrigérateur"]
[null,"Thermal conductivity of insulation",null,null,"Thermal conductivity of insulation","Conductivité thermique de l'isolation","Conductividad térmica"]
[null,"Thickness of insulation",null,null,"Thickness of insulation","Épaisseur de l'isolation","Espesor del aislante"]
[null,"Economic information",null,null,"Economic information","Informations économiques","Información económica"]
[null,{"$f":"INDEX(E84:H84,$C$3)","v":"Currency used for calculation"},null,null,"Currency used for calculation","Devise utilisée pour le calcul","Moneda"]
[null,"Specific cost of PV",null,null,"Specific cost of PV","Coût spécifique du PV","Coste especifico de paneles fotovoltáicos"]
[null,"PV lifetime",null,null,"PV lifetime","PV durée de vie","Durabilidad de los paneles fotovoltáicos"]
[null,"Specif cost of battery  ",null,null,"Specif cost of battery  ","Coût spécifique de la batterie","Coste especifico de las baterias"]
[null,"Battery lifetime",null,null,"Battery lifetime","Durée de vie de la batterie","Durabilidad de las baterias"]
[null,"Cost of solar cooling unit",null,null,"Cost of solar cooling unit","Coût de l'unité de refroidissement solaire","Coste especifico de las unidades de refrigeración"]
[null,"Solar cooling unit lifetime",null,null,"Solar cooling unit lifetime","Durée de vie de l'unité de refroidissement solaire","Durabilidad de las unidades de refrigeración"]
[null,"Material & construction costs for cooling box",null,null,"Material & construction costs for cooling box","Coûts de matériel et de construction pour la glacière","Coste de materiales y construción del refrigerador"]
[null,"Maintenance costs per year",null,null,"Maintenance costs per year","Coûts de maintenance par an","Coste de manteinimiento anual"]
[null,"years",null,null,"years","années","anyos"]
[null,"Additional income per product unit",null,null,"Additional income per product unit","Revenu supplémentaire par unité de produit","Ingresos adicionales por unidad de producto"]
[null,"Additional income per month",null,null,"Additional income per month","Revenu supplémentaire par mois","Ingresos adicionales mensuales"]
[null,"Discount rate",null,null,"Discount rate","Taux de remise","Tasa de descuento "]
[null,"Inflation  ",null,null,"Inflation  ","Inflation","Inflación"]
[null,"€/kg or l",null,null,{"$f":"'2 Input'!G44&\"/kg or l\"","v":"€/kg or l"},{"$f":"'2 Input'!G44&\"/kg ou l\"","v":"€/kg ou l"},{"$f":"'2 Input'!G44&\"/kg o l\"","v":"€/kg o l"}]
[null,"€/Wp",null,null,{"$f":"'2 Input'!G44&\"/Wp\"","v":"€/Wp"},{"$f":"'2 Input'!G44&\"/Wc\"","v":"€/Wc"}]
[null,"€/month",null,null,{"$f":"'2 Input'!G44&\"/month\"","v":"€/month"},{"$f":"'2 Input'!G44&\"/mois\"","v":"€/mois"},{"$f":"'2 Input'!G44&\"/mes\"","v":"€/mes"}]
[null,"Results","3 Output",null,"Results","Résultats","Resultados"]
[null,"System Design without batteries",null,null,"System Design without batteries","Conception du système sans batteries","Disenyo del sistema sin baterias"]
[null,"Cooling units needed:",null,null,"Cooling units needed:","Unités de refroidissement nécessaires:","Unidades de refrigeración necesarias:"]
[null,"Cooling units costs:",null,null,"Cooling units costs:","Coûts des unités de refroidissement:","Coste de las unidades de refrigeración:"]
[null,"Solar PV size:",null,null,"Solar PV size:","Taille PV solaire:","Potencia fotovoltáica:"]
[null,"Solar PV costs:",null,null,"Solar PV costs:","Coûts PV solaire:","Coste de los paneles solares:"]
[null,"Battery size:",null,null,"Battery size:","Taille des batteries:","Capacidad de las baterías:"]
[null,"Battery costs:",null,null,"Battery costs:","Coûts des batteries:","Coste de las baterias:"]
[null,"Total initial investment:",null,null,"Total initial investment:","Investissement initial total:","Inversión total:"]
[null,"Payback period:",null,null,"Payback period:","Période de récupération:","Periodo de Amortización:"]
[null,"Net present value:",null,null,"Net present value:","Valeur actuelle nette:","Valor presente neto:"]
[null,"Internal rate of return:",null,null,"Internal rate of return:","Taux de rendement interne:","Tasa interna de retorno:"]
[null,"System Design with batteries",null,null,"System Design with batteries","Conception du système avec batteries","Disenyo del sistema con baterias"]
[null,"years",null,null,"years","années","Anyos"]
[null,"Accumulated income & system costs over 20 years",null,null,"Accumulated income & system costs over 20 years","Revenu accumulé et coûts du système sur 20 ans ","Ingresos acumulados y coste durante 20 anyos"]
[null,"Years",null,null,"Years","Années","Anyos"]
[null,"Accumulated income",null,null,"Accumulated income","Revenu accumulé","Ingresos acumulados  "]
[null,"Accumulated system costs without batteries",null,null,"Accumulated system costs without batteries","Coûts accumulé du système sans batteries","Coste del sistema acumulado sin baterias"]
[null,"Accumulated system costs with batteries",null,null,"Accumulated system costs with batteries","Coûts accumulé du système avec batteries","Coste del sistema acumulado con baterias"]

{"sheet":"4 Weather Data","index":6,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,{"$f":"\"Selection: \"&'1 Geographic Data'!A6","v":"Selection: Mali (Bamako)"},{"$f":"'1 Geographic Data'!B7","v":"January"},{"$f":"'1 Geographic Data'!C7","v":"February"},{"$f":"'1 Geographic Data'!D7","v":"March"},{"$f":"'1 Geographic Data'!E7","v":"April"},{"$f":"'1 Geographic Data'!F7","v":"May"},{"$f":"'1 Geographic Data'!G7","v":"June"},{"$f":"'1 Geographic Data'!H7","v":"July"},{"$f":"'1 Geographic Data'!I7","v":"August"},{"$f":"'1 Geographic Data'!J7","v":"September"},{"$f":"'1 Geographic Data'!K7","v":"October"},{"$f":"'1 Geographic Data'!L7","v":"November"},{"$f":"'1 Geographic Data'!M7","v":"December"}]
[null,{"$f":"'1 Geographic Data'!A8","v":"Mean daily temperature [°C]:"},{"$f":"INDEX(C14:C51,MATCH($S$13,$B$14:$B$50,0)+1)","v":25.1},{"$f":"INDEX(D14:D51,MATCH($S$13,$B$14:$B$50,0)+1)","v":27.8},30.3,31.1,31.5,29,27.4,25.9,26.4,27.4,26.5,24.8]
[null,{"$f":"'1 Geographic Data'!A9","v":"Solar irradiation [kWh/m² day]:"},{"$f":"INDEX(C14:C52,MATCH($S$13,$B$14:$B$50,0)+2)","v":5.4},{"$f":"INDEX(D14:D52,MATCH($S$13,$B$14:$B$50,0)+2)","v":5.9},6.9,6.6,6.4,6.1,5.8,5.6,5.8,5.8,5.7,5.4]
[]
[]
[]
[]
[]
[{"$nulls":16},"Selection:",null,{"$f":"'1 Geographic Data'!A6","v":"Mali (Bamako)"}]
[null,"Kenya (Kisumu)",{"$f":"C5","v":"January"},"February","March","April","May","June","July","August","September","October","November","December",null,null,"List of locations:"]
[null,{"$f":"B6","v":"Mean daily temperature [°C]:"},25,26,26,26,25,23,22,23,24,25,25,25,{"$nulls":4},{"$f":"B14","v":"Kenya (Kisumu)"}]
[null,{"$f":"B7","v":"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,{"$nulls":4},{"$f":"B18","v":"Mali (Bamako)"}]
[{"$nulls":18},{"$f":"B22","v":"Benin (Porto Novo)"}]
[null,"Mali (Bamako)",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December",{"$nulls":4},{"$f":"B26","v":"+++ Add location +++"}]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"},25.1,27.8,30.3,31.1,31.5,29,27.4,25.9,26.4,27.4,26.5,24.8,{"$nulls":4},{"$f":"B30","v":"+++ Add location +++"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"},5.4,5.9,6.9,6.6,6.4,6.1,5.8,5.6,5.8,5.8,5.7,5.4,{"$nulls":4},{"$f":"B34","v":"+++ Add location +++"}]
[{"$nulls":18},{"$f":"B38","v":"+++ Add location +++"}]
[null,"Benin (Porto Novo)",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December",{"$nulls":4},{"$f":"B42","v":"+++ Add location +++"}]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"},28,29,29.5,29,28,27,26,26,26.5,27,28,28.5,{"$nulls":4},{"$f":"B46","v":"+++ Add location +++"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"},5.9290322580645167,5.9285714285714288,5.709677419354839,5.8,5.0838709677419356,4.0166666666666666,4.1354838709677413,4.4290322580645167,4.4066666666666663,4.532258064516129,5.2566666666666659,5.7064516129032263,{"$nulls":4},{"$f":"B50","v":"+++ Add location +++"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]
[]
[null,"+++ Add location +++",{"$f":"C14","v":"January"},"February","March","April","May","June","July","August","September","October","November","December"]
[null,{"$f":"B15","v":"Mean daily temperature [°C]:"}]
[null,{"$f":"B16","v":"Solar irradiation [kWh/m² day]:"}]