{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["READ ME","1 Geographic Data","2 Input","3 Cooling Curve","4 Output","Calculation Sheet","Translation","5 Weather Data"],"not_rendered":{"charts":8,"images":15,"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":61,"n_cols":6,"rows_kept":61,"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],[55,2,57,8],[60,2,60,8],[40,5,41,8],[44,5,45,8],[48,5,49,8],[50,5,51,8],[50,2,51,4],[40,2,41,4],[44,2,45,4],[48,2,49,4],[53,2,53,8],[42,2,43,4],[42,5,43,8],[46,2,47,4],[46,5,47,8]]}
[]
[]
[]
[null,null,null,"Language:","English"]
[]
[]
[]
[{"$f":"Translation!B6","v":"Design Tool: Solar Water Chiller for Cold Rooms "}]
{"$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 water chiller for cold rooms 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!B20","v":"For selecting basic site information: ambient temperatures or solar radiation. "}]
[]
[null,null,{"$f":"Translation!B14","v":"2. Input"},null,null,{"$f":"Translation!B21","v":"For adding data about the product to be cooled under given conditions"}]
[]
[null,null,{"$f":"Translation!B15","v":"3. Cooling Curve"},null,null,{"$f":"Translation!B22","v":"Visualization of the Cooling Curve and Cooling Load profile"}]
[]
[null,null,{"$f":"Translation!B16","v":"4. Output"},null,null,{"$f":"Translation!B23","v":"For an overview of the results"}]
[]
[null,null,{"$f":"Translation!B17","v":"5. Weather Data"},null,null,{"$f":"Translation!B24","v":"To add weather data for a specific location"}]
[]
[null,null,{"$f":"Translation!B18","v":"Calculation Sheet (Hidden)"},null,null,{"$f":"Translation!B25","v":"All calculations are done within this sheet"}]
[]
[null,null,{"$f":"Translation!B19","v":"Translation sheet (Hidden)"},null,null,{"$f":"Translation!B26","v":"Contains the translation into several languages"}]
[]
[]
[null,null,{"$f":"Translation!B27","v":"Additional information"}]
[]
[null,null,{"$f":"Translation!B28","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!B29","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!B30","v":"1. Geographic Data"}]
[]
[{"$f":"Translation!B46","v":"Choose location:"}]
["Mali (Bamako)"]
[null,{"$f":"Translation!B33","v":"January"},{"$f":"Translation!B34","v":"February"},{"$f":"Translation!B35","v":"March"},{"$f":"Translation!B36","v":"April"},{"$f":"Translation!B37","v":"May"},{"$f":"Translation!B38","v":"June"},{"$f":"Translation!B39","v":"July"},{"$f":"Translation!B40","v":"August"},{"$f":"Translation!B41","v":"September"},{"$f":"Translation!B42","v":"October"},{"$f":"Translation!B43","v":"November"},{"$f":"Translation!B44","v":"December"}]
[{"$f":"Translation!B31","v":"Mean daily temperature [°C]:"},{"$f":"'5 Weather Data'!C6","v":25.1},{"$f":"'5 Weather Data'!D6","v":27.8},{"$f":"'5 Weather Data'!E6","v":30.3},{"$f":"'5 Weather Data'!F6","v":31.1},{"$f":"'5 Weather Data'!G6","v":31.5},{"$f":"'5 Weather Data'!H6","v":29},{"$f":"'5 Weather Data'!I6","v":27.4},{"$f":"'5 Weather Data'!J6","v":25.9},{"$f":"'5 Weather Data'!K6","v":26.4},{"$f":"'5 Weather Data'!L6","v":27.4},{"$f":"'5 Weather Data'!M6","v":26.5},{"$f":"'5 Weather Data'!N6","v":24.8}]
[{"$f":"Translation!B32","v":"Solar irradiation [kWh/m² day]:"},{"$f":"'5 Weather Data'!C7","v":5.4},{"$f":"'5 Weather Data'!D7","v":5.9},{"$f":"'5 Weather Data'!E7","v":6.9},{"$f":"'5 Weather Data'!F7","v":6.6},{"$f":"'5 Weather Data'!G7","v":6.4},{"$f":"'5 Weather Data'!H7","v":6.1},{"$f":"'5 Weather Data'!I7","v":5.8},{"$f":"'5 Weather Data'!J7","v":5.6},{"$f":"'5 Weather Data'!K7","v":5.8},{"$f":"'5 Weather Data'!L7","v":5.8},{"$f":"'5 Weather Data'!M7","v":5.7},{"$f":"'5 Weather Data'!N7","v":5.4}]
[]
[{"$f":"Translation!B47","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!B45","v":"Locations can be added on the sheet \"Weather Data\""}]

{"sheet":"2 Input","index":2,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,1,2,6],[5,4,5,6]]}
[]
[]
[null,{"$f":"Translation!B48","v":"Input of parameters"}]
[]
[]
[null,{"$f":"Translation!B49","v":"Product information"},null,null,{"$f":"Translation!B50","v":"Data"}]
[]
[null,{"$f":"Translation!B51","v":"Total mass to be cooled"},null,null,{"$f":"Translation!B54","v":"Mass ="},500,"kg/day"]
[null,{"$f":"Translation!B52","v":" Moisture content of the product"},null,null,{"$f":"Translation!B55","v":"MC ="},86,{"$f":"Translation!B58","v":"% wet based"}]
[null,{"$f":"Translation!B53","v":" or Heat capacity of the product"},null,null,{"$f":"Translation!B56","v":"cp ="},0,{"$f":"Translation!B59","v":"kJ/kg K"}]
[null,{"$f":"Translation!B60","v":"Radius"},null,null,"r =",0.05,"m"]
[null,{"$f":"Translation!B61","v":"Density"},null,null,"δ =",997,"kg/m³"]
[null,{"$f":"Translation!B62","v":"Convection air - product"},null,null,"h =",5,"W/m²K"]
[]
[]
[null,{"$f":"Translation!B64","v":"Temperature information"}]
[]
[null,{"$f":"Translation!B65","v":"Initial temperature of the product"},null,null,"Ti =",30,"°C"]
[null,{"$f":"Translation!B66","v":"Final temperature of the product"},null,null,"Tm =",15,"°C"]
[]
[]
[null,{"$f":"Translation!B70","v":"System information"}]
[]
[null,{"$f":"Translation!B71","v":"Batteries"},null,null,null,"Yes"]
[null,{"$f":"Translation!B72","v":"Autonomy of the system"},null,null,null,1,{"$f":"IF(K24=\"YES\",\"days\",\"\")","v":""}]
[null,{"$f":"Translation!B73","v":"System losses"},null,null,null,25,"%"]
[]
[]
[null,{"$f":"Translation!B88","v":"Cold Room"}]
[{"$nulls":5},{"$f":"F31*F32*F33","v":90.75},"m3"]
[null,{"$f":"Translation!B89","v":"Inner length of the cold room"},null,null,"x =",5.5,"m"]
[null,{"$f":"Translation!B90","v":"Inner width of the cold room"},null,null,"y =",5.5,"m"]
[null,{"$f":"Translation!B91","v":"Inner height of the cold room"},null,null,"z =",3,"m",1,{"$f":"Translation!B74","v":"PV Panels"},null,7,{"$f":"Translation!B80","v":"Water bath"}]
[null,{"$f":"Translation!B93","v":"Thermal conductivity of insulation"},null,null,"k /  l =",0.04,"W/m K",2,{"$f":"Translation!B75","v":"Charge Controller"},null,8,{"$f":"Translation!B81","v":"Ice on evaporator surface"}]
[null,{"$f":"Translation!B94","v":"Thickness of insulation"},null,null,"L =",0.2,"m",3,{"$f":"Translation!B76","v":"Batteries"},null,9,{"$f":"Translation!B82","v":"DC pump"}]
[null,{"$f":"Translation!B95","v":"Ice storage inside the cold room?"},null,null,null,"Yes",null,4,{"$f":"Translation!B77","v":"Control Unit"},null,10,{"$f":"Translation!B83","v":"Fan coil unit"}]
[{"$nulls":7},5,{"$f":"Translation!B78","v":"Compressor"},null,11,{"$f":"Translation!B84","v":"Cold room"}]
[null,{"$f":"Translation!B96","v":"Economic information"},{"$nulls":5},6,{"$f":"Translation!B79","v":"Ice storage"},null,12,{"$f":"Translation!B85","v":"Cooled product"}]
[]
[null,{"$f":"Translation!B97","v":"Currency used for calculation"},null,null,null,"€"]
[null,{"$f":"Translation!B98","v":"Specific cost of PV"},null,null,null,1.1000000000000001,{"$f":"Translation!B112","v":"€/Wp"}]
[null,{"$f":"Translation!B99","v":"PV lifetime"},null,null,null,21,{"$f":"Translation!B106","v":"years"}]
[null,{"$f":"Translation!B100","v":"Specif cost of battery  "},null,null,null,2,{"$f":"F40&\"/Ah@12V\"","v":"€/Ah@12V"}]
[null,{"$f":"Translation!B101","v":"Battery lifetime"},null,null,null,3,{"$f":"Translation!B106","v":"years"}]
[null,{"$f":"Translation!B102","v":"Cost of solar cooling unit"},null,null,null,650,{"$f":"F40","v":"€"}]
[null,{"$f":"Translation!B103","v":"Solar cooling unit lifetime"},null,null,null,12,{"$f":"Translation!B106","v":"years"}]
[null,{"$f":"Translation!B104","v":"Material & construction costs for cooling box"},null,null,null,2000,{"$f":"F40","v":"€"}]
[null,{"$f":"Translation!B105","v":"Maintenance costs per year"},null,null,null,25,{"$f":"F40","v":"€"}]
[]
[null,{"$f":"Translation!B107","v":"Additional income per product unit"},null,null,null,0,{"$f":"Translation!B111","v":"€/kg or l"}]
[null,{"$f":"Translation!B108","v":"Additional income per month"},null,null,null,500,{"$f":"Translation!B113","v":"€/month"}]
[null,{"$f":"Translation!B109","v":"Discount rate"},null,null,null,5,"%"]
[null,{"$f":"Translation!B110","v":"Inflation  "},null,null,null,3,"%"]

{"sheet":"3 Cooling Curve","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,1,2,10]]}
[]
[]
[null,{"$f":"Translation!B122","v":"Cooling Curve & Cooling Load"}]

{"sheet":"4 Output","index":4,"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!B124","v":"Results"}]
[]
[]
[null,{"$f":"Translation!B125","v":"System Design without batteries"},{"$nulls":5},{"$f":"Translation!B136","v":"System Design with batteries"}]
[]
[null,{"$f":"Translation!B126","v":"Cooling units needed:"},null,{"$f":"'Calculation Sheet'!P18","v":24},null,null,null,{"$f":"Translation!B126","v":"Cooling units needed:"},null,{"$f":"'Calculation Sheet'!P20","v":8}]
[null,{"$f":"Translation!B127","v":"Cooling units costs:"},null,{"$f":"'Calculation Sheet'!$U$75","v":15600},{"$f":"'Calculation Sheet'!$E$70","v":"€"},null,null,{"$f":"Translation!B127","v":"Cooling units costs:"},null,{"$f":"'Calculation Sheet'!P75","v":5200},{"$f":"'Calculation Sheet'!$E$70","v":"€"}]
[]
[null,{"$f":"Translation!B128","v":"Solar PV size:"},null,{"$f":"'Calculation Sheet'!$P$19","v":4332},"Wp",null,null,{"$f":"Translation!B128","v":"Solar PV size:"},null,{"$f":"'Calculation Sheet'!P21","v":2548},"Wp"]
[null,{"$f":"Translation!B129","v":"Solar PV costs:"},null,{"$f":"'Calculation Sheet'!U71","v":4765.2000000000007},{"$f":"'Calculation Sheet'!$E$70","v":"€"},null,null,{"$f":"Translation!B129","v":"Solar PV costs:"},null,{"$f":"'Calculation Sheet'!P71","v":2802.8},{"$f":"'Calculation Sheet'!$E$70","v":"€"}]
[]
[{"$nulls":7},{"$f":"Translation!B130","v":"Battery size:"},null,{"$f":"'Calculation Sheet'!P22","v":680},"Ah (12V)"]
[{"$nulls":7},{"$f":"Translation!B131","v":"Battery costs:"},null,{"$f":"'Calculation Sheet'!P73","v":1360},{"$f":"'Calculation Sheet'!$E$70","v":"€"}]
[]
[]
[null,{"$f":"Translation!B132","v":"Total initial investment:"},null,{"$f":"'Calculation Sheet'!B131","v":22365.200000000001},{"$f":"'Calculation Sheet'!$E$70","v":"€"},null,null,{"$f":"Translation!B132","v":"Total initial investment:"},null,{"$f":"'Calculation Sheet'!B105","v":11362.8},{"$f":"'Calculation Sheet'!$E$70","v":"€"}]
[null,{"$f":"Translation!B133","v":"Payback period:"},null,{"$f":"'Calculation Sheet'!B132","v":3.7},{"$f":"Translation!B137","v":"years"},null,null,{"$f":"Translation!B133","v":"Payback period:"},null,{"$f":"'Calculation Sheet'!B106","v":1.9},{"$f":"Translation!B137","v":"years"}]
[null,{"$f":"Translation!B134","v":"Net present value:"},null,{"$f":"'Calculation Sheet'!B133","v":39623.837092545393},{"$f":"'Calculation Sheet'!$E$70","v":"€"},null,null,{"$f":"Translation!B134","v":"Net present value:"},null,{"$f":"'Calculation Sheet'!B107","v":52182.594850789756},{"$f":"'Calculation Sheet'!$E$70","v":"€"}]
[null,{"$f":"Translation!B135","v":"Internal rate of return:"},null,{"$f":"'Calculation Sheet'!B134*100","v":24.630644348064635},"%",null,null,{"$f":"Translation!B135","v":"Internal rate of return:"},null,{"$f":"'Calculation Sheet'!B108*100","v":49.414294888332755},"%"]

{"sheet":"Calculation Sheet","index":5,"n_rows":232,"n_cols":31,"rows_kept":232,"cut":false,"hidden":true,"merged":[[12,14,12,15],[15,14,15,15],[231,1,232,1],[231,2,232,2],[231,3,232,3],[231,4,232,4],[231,5,232,5],[231,6,232,6],[231,7,232,7],[231,8,232,8],[231,9,232,9],[231,10,232,10],[231,11,232,11],[231,12,232,12]]}
[]
[{"$nulls":14},{"$f":"Translation!B120","v":"Thermal losses cold month in kWh"}]
[null,"January","February","March","April","May","June","July","August","September","October","November","December",null,0,0]
["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},null,24,{"$f":"MIN(B6:M6)","v":7.4381999999999993}]
["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},null,{"$f":"Translation!B121","v":"Thermal losses hot month in kWh"}]
["Thermal losses for each day [kWh]:",{"$f":"(1+0.25*$G$61)*($E$53*$E$56*(B4-$E$40)*24/1000)","v":7.6658999999999997},{"$f":"(1+0.25*$G$61)*($E$53*$E$56*(C4-$E$40)*24/1000)","v":9.7151999999999994},{"$f":"(1+0.25*$G$61)*($E$53*$E$56*(D4-$E$40)*24/1000)","v":11.6127},12.219899999999999,12.523499999999999,10.625999999999999,9.4115999999999982,8.2730999999999977,8.6525999999999996,9.4115999999999982,8.7284999999999986,7.4381999999999993,null,0,0]
["Thermal Energy Liquid phase [kWh]:",{"$f":"$E$28*$E$32*($E$39-MAX($E$40,0))/3600","v":8.0547432666666676},{"$f":"$E$28*$E$32*($E$39-MAX($E$40,0))/3600","v":8.0547432666666676},8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,8.0547432666666676,null,24,{"$f":"MAX(B6:M6)","v":12.523499999999999}]
["Thermal Energy Change Phase [kWh]:",{"$f":"$E$28*$E$32*80/3600","v":42.958630755555561},{"$f":"$E$28*$E$32*80/3600","v":42.958630755555561},42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561,42.958630755555561]
["Thermal Energy Ice Phase [kWh]:",{"$f":"0.5*$E$28*$E$32*(0-MIN($E$40,0))/3600","v":0},{"$f":"0.5*$E$28*$E$32*(0-MIN($E$40,0))/3600","v":0},0,0,0,0,0,0,0,0,0,0]
["Max Power to cool down the product [kW]: ",{"$f":"B12/$E$33","v":0.34834452129527782},{"$f":"C12/$E$33","v":0.35174764901777783},0.35489869320527778,0.35590702734527779,0.35641119441527785,0.35326015022777785,0.35124348194777782,0.34935285543527783,0.34998306427277787,0.35124348194777782,0.35010910604027784,0.34796639599277784]
["Thermal Energy to cold down the air of the cold room once per day [kWh]:",{"$f":"$E$57*1.2*(B4-$E$40)*0.000277778","v":0.30552524442000006},{"$f":"$E$57*1.2*(C4-$E$40)*0.000277778","v":0.38720030976000003},0.46282537025999998,0.48702538962000003,0.49912539929999999,0.42350033879999999,0.37510030007999995,0.32972526377999994,0.34485027587999995,0.37510030007999995,0.34787527829999998,0.29645023716000002]
["Daily Energy to cool down the product and air [kWh]: ",{"$f":"IF($E$40>0,B7,B7+B8+B9)*$E$34/30+B11","v":8.3602685110866677},{"$f":"IF($E$40>0,C7,C7+C8+C9)*$E$34/30+C11","v":8.4419435764266684},8.5175686369266668,8.541768656286667,8.5538686659666681,8.4782436054666679,8.4298435667466673,8.384468530446668,8.3995935425466683,8.4298435667466673,8.4026185449666677,8.3511935038266678]
["Qtotal for each day [kW]:",{"$f":"B6+B12","v":16.026168511086667},{"$f":"C6+C12","v":18.15714357642667},20.130268636926665,20.761668656286666,21.077368665966667,19.104243605466667,17.841443566746666,16.657568530446667,17.052193542546668,17.841443566746666,17.131118544966668,15.789393503826666]
["COP without battery:",{"$f":"$E$44*(1/((B4+5+273.15)/((MIN(-5,$E$43))+273.15)-1))","v":1.9099002849002824},{"$f":"$E$44*(1/((C4+5+273.15)/((MIN(-5,$E$43))+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$44*(1/((B4+5+273.15)/((MIN(-5,$E$43))+273.15)-1))","v":1.9099002849002824},{"$f":"$E$44*(1/((C4+5+273.15)/((MIN(-5,$E$43))+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]
["Energy needed without battery [kWhel]:",{"$f":"B13/B14","v":8.3911022150161134},{"$f":"C13/C14","v":10.238150694595232},12.101433169019501,12.728764971447054,13.048082038226623,11.114159994230096,9.9536824821379764,8.920480480970129,9.2589945172283947,9.9536824821379764,9.3274037201757682,8.196470541609818,null,"Maximum values "]
["Engergy needed with battery [kWhel]:",{"$f":"B13/B15","v":8.3911022150161134},{"$f":"C13/C15","v":10.238150694595232},12.101433169019501,12.728764971447054,13.048082038226623,11.114159994230096,9.9536824821379764,8.920480480970129,9.2589945172283947,9.9536824821379764,9.3274037201757682,8.196470541609818,null,null,"rounded"]
["Cooling units needed (no battery):",{"$f":"1000*B16/(70*8)","v":14.98411109824306},{"$f":"1000*C17/(70*8)","v":18.282411954634341},21.609702087534824,22.729937449012596,23.300146496833253,19.846714275410886,17.774433003817816,15.929429430303802,16.533918780764992,17.774433003817816,16.656078071742442,14.636554538588962,null,{"$f":"MAX(B18:M18)","v":23.300146496833253},{"$f":"MAX(1,IF( O18-ROUNDDOWN(O18,0)<0.2,  ROUNDDOWN(O18,0),      ROUNDUP(O18,0)        ))","v":24}]
["PV without battery (Wp):",{"$f":"(1+$E$64/100)*1.7*1000*B16/B5","v":3302.0541123906},{"$f":"(1+$E$64/100)*1.7*1000*C16/C5","v":3687.4695298330284},3726.8906498791939,4098.276600655302,4332.3709892549332,3871.7360635637638,3646.8233231971035,3385.003753939558,3392.3040257086791,3646.8233231971035,3477.3215623462293,3225.4629446149743,null,{"$f":"MAX(B19:M19)","v":4332.3709892549332},{"$f":"ROUND(O19,0)","v":4332}]
["Cooling units needed (with battery):",{"$f":"1000*B17/(75*24)","v":4.6617234527867293},{"$f":"1000*C17/(75*24)","v":5.6878614969973507},6.7230184272330566,7.071536095248363,7.2489344656814572,6.1745333301278311,5.5298236011877648,4.9558224894278498,5.1438858429046643,5.5298236011877648,5.1818909556532038,4.5535947453387884,null,7.2489344656814572,{"$f":"MAX(1,IF( O20-ROUNDDOWN(O20,0)<0.2,  ROUNDDOWN(O20,0),      ROUNDUP(O20,0)        ))","v":8}]
["PV with battery (Wp):",{"$f":"(1+$E$64/100)*1000*B17/B5","v":1942.3847719944706},{"$f":"(1+$E$64/100)*1000*C17/C5","v":2169.0997234311931},2192.2886175759963,2410.7509415619425,2548.4535230911374,2277.4918020963314,2145.1901901159431,1991.1786787879755,1995.4729562992229,2145.1901901159431,2045.4832719683702,1897.3311438911614,null,2548.4535230911374,2548]
["Battery (Ah related to 12 V):",{"$f":"MAX($E$63,1)*(1+$E$64/100)*1000/2*B17/12","v":437.03657369875594},{"$f":"MAX($E$63,1)*(1+$E$64/100)*1000/2*C17/12","v":533.23701534350164},630.28297755309893,662.95650892953415,679.58760615763663,578.86249969948415,518.42096261135293,464.60835838386089,482.23929777231223,518.42096261135293,485.80227709248794,426.89950737551135,null,679.58760615763663,680]
[]
[]
[]
["Product information"]
[]
[{"$f":"'2 Input'!B8","v":"Total mass to be cooled"},null,null,"Mass =",{"$f":"'2 Input'!F8","v":500},"kg or l"]
[{"$f":"'2 Input'!B9","v":" Moisture content of the product"},null,null,"MC =",{"$f":"'2 Input'!F9","v":86},"%"]
[{"$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-E29)/100)-0.628*((100-E29)/100)^3","v":3.8662767680000005},"kJ/kg K"]
["CP due to input of the user (either calculated via MC or direct)",null,null,"cp =",{"$f":"IF(E30>0,E30,E31)","v":3.8662767680000005},"kJ/kg K"]
[null,null,null,"t =",24,"h"]
["How many days will the product be cooled? ",null,null,null,30]
[]
[]
["Temperature information"]
[]
[{"$f":"'2 Input'!B18","v":"Initial temperature of the product"},null,null,"Ti =",{"$f":"'2 Input'!F18","v":30},"°C"]
[{"$f":"'2 Input'!B19","v":"Final temperature of the product"},null,null,"Tm =",{"$f":"'2 Input'!F19","v":15},"°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":"E40-5","v":10},"°C"]
["Alpha - value:",null,null,null,0.25]
[null,null,null,"COP worst case =",{"$f":"$E$44*(1/((E42+273.15)/($E$43+273.15)-1))","v":3.2924418604651202}]
[]
[]
["Isolation material"]
[]
["Inner length of the cold room",null,null,"x =",{"$f":"'2 Input'!F31","v":5.5},"m"]
["Inner width of the cold room",null,null,"y =",{"$f":"'2 Input'!F32","v":5.5},"m"]
["Inner height of the cold room",null,null,"z =",{"$f":"'2 Input'!F33","v":3},"m"]
["Inner area of the cold room",null,null,"A =",{"$f":"2*(E50*E51+E51*E52+E50*E52)","v":126.5},"m²"]
[{"$f":"'2 Input'!B34","v":"Thermal conductivity of insulation"},null,null,"k /  l =",{"$f":"'2 Input'!F34","v":0.04},"W/m K"]
[{"$f":"'2 Input'!B35","v":"Thickness of insulation"},null,null,"L =",{"$f":"'2 Input'!F35","v":0.2},"m"]
[null,null,null,"U =",{"$f":"E54/E55","v":0.19999999999999998}]
["Cold Room Volume",null,null,"V=",{"$f":"'2 Input'!F30","v":90.75},"m3",{"$nulls":8},"Batteries:"]
[{"$nulls":15},"Yes",{"$f":"IF(H85=\"Yes\",1,0)","v":1}]
[{"$nulls":15},"No",{"$f":"1-Q58","v":0}]
["System information"]
[{"$f":"'2 Input'!B36","v":"Ice storage inside the cold room?"},null,null,null,{"$f":"IF(OR('2 Input'!F36=Translation!E86,'2 Input'!F36=Translation!F86,'2 Input'!F36=Translation!G86,'2 Input'!F36=Translation!H86),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(E61=\"Yes\",1,0)","v":1}]
["Batteries ",null,null,null,{"$f":"IF(OR('2 Input'!F24=Translation!E86,'2 Input'!F24=Translation!F86,'2 Input'!F24=Translation!G86,'2 Input'!F24=Translation!H86),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(E62=\"Yes\",1,0)","v":1}]
[{"$f":"'2 Input'!B25","v":"Autonomy of the system"},null,null,null,{"$f":"'2 Input'!F25","v":1}]
[{"$f":"'2 Input'!B26","v":"System losses"},null,null,null,{"$f":"'2 Input'!F26","v":25},"%"]
[]
[]
[]
["Economic information",{"$nulls":6},"Income",{"$nulls":5},"System with Battery",{"$nulls":4},"System without Battery"]
[]
[{"$f":"'2 Input'!B40","v":"Currency used for calculation"},null,null,null,{"$f":"'2 Input'!F40","v":"€"}]
[{"$f":"'2 Input'!B41","v":"Specific cost of PV"},null,null,null,{"$f":"'2 Input'!F41","v":1.1000000000000001},{"$f":"E70&\"/Wp\"","v":"€/Wp"},null,"Additional income per product:",null,null,{"$f":"E79*E28*E34*12","v":0},{"$f":"E70&\"/year\"","v":"€/year"},null,"Total PV Costs:",null,{"$f":"P21*E71","v":2802.8},null,null,"Total PV Costs:",null,{"$f":"P19*E71","v":4765.2000000000007}]
[{"$f":"'2 Input'!B42","v":"PV lifetime"},null,null,null,{"$f":"'2 Input'!F42","v":21},"years",null,"Additional income per year:",null,null,{"$f":"E80*12","v":6000},{"$f":"E70&\"/year\"","v":"€/year"},null,"Lifetime PV:",null,{"$f":"E72","v":21},null,null,"Lifetime PV:",null,{"$f":"E72","v":21}]
[{"$f":"'2 Input'!B43","v":"Specif cost of battery  "},null,null,null,{"$f":"'2 Input'!F43","v":2},{"$f":"E70&\"/Ah@12V\"","v":"€/Ah@12V"},null,"Total income :",null,null,{"$f":"SUM(K71:K72)","v":6000},{"$f":"E70&\"/year\"","v":"€/year"},null,"Total Battery costs:",null,{"$f":"P22*E73","v":1360}]
[{"$f":"'2 Input'!B44","v":"Battery lifetime"},null,null,null,{"$f":"'2 Input'!F44","v":3},"years",{"$nulls":7},"Lifetime battery:",null,{"$f":"E74","v":3}]
[{"$f":"'2 Input'!B45","v":"Cost of solar cooling unit"},null,null,null,{"$f":"'2 Input'!F45","v":650},{"$f":"E70","v":"€"},{"$nulls":7},"Total solar cooling unit costs:",null,{"$f":"P20*E75","v":5200},null,null,"Total solar cooling unit costs:",null,{"$f":"P18*E75","v":15600}]
[{"$f":"'2 Input'!B46","v":"Solar cooling unit lifetime"},null,null,null,{"$f":"'2 Input'!F46","v":12},"years",{"$nulls":7},"Lifetime cooling unit:",null,{"$f":"E76","v":12},null,null,"Lifetime cooling unit:",null,{"$f":"E76","v":12}]
[{"$f":"'2 Input'!B47","v":"Material & construction costs for cooling box"},null,null,null,{"$f":"'2 Input'!F47","v":2000},{"$f":"E70","v":"€"},{"$nulls":7},"Material & construction:",null,{"$f":"E77","v":2000},null,null,"Material & construction:",null,{"$f":"E77","v":2000}]
[{"$f":"'2 Input'!B48","v":"Maintenance costs per year"},null,null,null,{"$f":"'2 Input'!F48","v":25},{"$f":"E70&\"/year\"","v":"€/year"},{"$nulls":7},"Maintenance per year:",null,{"$f":"E78","v":25},null,null,"Maintenance per year:",null,{"$f":"E78","v":25}]
[{"$f":"'2 Input'!B50","v":"Additional income per product unit"},null,null,null,{"$f":"'2 Input'!F50","v":0},{"$f":"E70&\"/kg or l\"","v":"€/kg or l"}]
[{"$f":"'2 Input'!B51","v":"Additional income per month"},null,null,null,{"$f":"'2 Input'!F51","v":500},{"$f":"E70&\"/year\"","v":"€/year"}]
[{"$f":"'2 Input'!B52","v":"Discount rate"},null,null,null,{"$f":"'2 Input'!F52","v":5},"%"]
[{"$f":"'2 Input'!B53","v":"Inflation  "},null,null,null,{"$f":"'2 Input'!F53","v":3},"%"]
[]
[]
[null,"Economic Analysis: System with battery",null,null,null,"With batteries? ",null,{"$f":"E62","v":"Yes"}]
[]
[null,null,null,{"$f":"IF(E103<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,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":"P71","v":2802.8},{"$f":"IF(MOD(D88,$P$72)=0,$C$90*(1+($E$82/100))^D88,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5214.0336255873744,0,0,0,0]
["Battery Costs",null,{"$f":"P73","v":1360},{"$f":"IF(MOD(D88,$P$74)=0,$C$91*(1+($E$82/100))^D88,0)","v":0},0,1486.1087199999999,0,0,1623.9111232794398,0,0,1774.4915300077726,0,0,1939.0348061108029,0,0,2118.8356865770397,0,0,2315.3089632862684,0,0,2530.0006175249137,0,0,2764.5999847861463,0]
["Solar cooling units cost",null,{"$f":"P75","v":5200},{"$f":"IF(MOD(D88,$P$76)=0,$C$92*(1+($E$82/100))^D88,0)","v":0},0,0,0,0,0,0,0,0,0,0,7413.9566116001288,0,0,0,0,0,0,0,0,0,0,0,10570.529353594089,0]
["Material & Construction",null,{"$f":"P77","v":2000},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":"P78","v":25},{"$f":"$D$94*(1+($E$82/100))^(E88-1)","v":25.75},{"$f":"$D$94*(1+($E$82/100))^(F88-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(C90:C95)","v":11362.8},{"$f":"SUM(D90:D95)","v":25},25.75,1512.63122,27.318175,28.137720249999997,1652.8929751369399,29.851307413224998,30.74684663562175,1806.1607820424629,32.619329595731109,33.597909483603047,9387.5972644790418,35.644022171154468,36.713342836289101,2156.6504296984176,38.949185415019109,40.117660977469676,2356.6301540930622,42.560826530997581,43.837651326927507,7789.1870239790233,46.507364292737385,47.902585221519509,13384.469001158401,50.819852661510048]
["Expenses per year accumulated:",null,{"$f":"C96","v":11362.8},{"$f":"SUM($C$96:D96)","v":11387.8},{"$f":"SUM($C$96:E96)","v":11413.55},{"$f":"SUM($C$96:F96)","v":12926.181219999999},{"$f":"SUM($C$96:G96)","v":12953.499394999999},{"$f":"SUM($C$96:H96)","v":12981.63711525},{"$f":"SUM($C$96:I96)","v":14634.530090386939},{"$f":"SUM($C$96:J96)","v":14664.381397800164},{"$f":"SUM($C$96:K96)","v":14695.128244435786},{"$f":"SUM($C$96:L96)","v":16501.289026478247},{"$f":"SUM($C$96:M96)","v":16533.908356073978},{"$f":"SUM($C$96:N96)","v":16567.506265557582},{"$f":"SUM($C$96:O96)","v":25955.103530036624},{"$f":"SUM($C$96:P96)","v":25990.747552207777},{"$f":"SUM($C$96:Q96)","v":26027.460895044067},{"$f":"SUM($C$96:R96)","v":28184.111324742484},{"$f":"SUM($C$96:S96)","v":28223.060510157502},{"$f":"SUM($C$96:T96)","v":28263.178171134972},{"$f":"SUM($C$96:U96)","v":30619.808325228034},{"$f":"SUM($C$96:V96)","v":30662.369151759031},{"$f":"SUM($C$96:W96)","v":30706.206803085959},{"$f":"SUM($C$96:X96)","v":38495.393827064981},{"$f":"SUM($C$96:Y96)","v":38541.90119135772},{"$f":"SUM($C$96:Z96)","v":38589.80377657924},{"$f":"SUM($C$96:AA96)","v":51974.272777737642},{"$f":"SUM($C$96:AB96)","v":52025.092630399151}]
["Expenses per year accumulated (for hiding in the diagramm):",null,{"$f":"IF($H$85=\"YES\",C97,NA())","v":11362.8},{"$f":"IF($H$85=\"YES\",D97,NA())","v":11387.8},11413.55,12926.181219999999,12953.499394999999,12981.63711525,14634.530090386939,14664.381397800164,14695.128244435786,16501.289026478247,16533.908356073978,16567.506265557582,25955.103530036624,25990.747552207777,26027.460895044067,28184.111324742484,28223.060510157502,28263.178171134972,30619.808325228034,30662.369151759031,30706.206803085959,38495.393827064981,38541.90119135772,38589.80377657924,51974.272777737642,52025.092630399151]
[]
[" Accumulated income per year:",null,0,{"$f":"K73","v":6000},{"$f":"$K$73+D100","v":12000},{"$f":"$K$73+E100","v":18000},24000,30000,36000,42000,48000,54000,60000,66000,72000,78000,84000,90000,96000,102000,108000,114000,120000,126000,132000,138000,144000,150000]
["Income per year:",null,null,{"$f":"$K$73","v":6000},{"$f":"$K$73","v":6000},6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000]
["Cashfow per year:",null,{"$f":"C100-C97","v":-11362.8},{"$f":"D101-D96","v":5975},{"$f":"E101-E96","v":5974.25},4487.3687799999998,5972.6818249999997,5971.8622797500002,{"$f":"I101-I96","v":4347.1070248630604},5970.1486925867748,5969.2531533643778,4193.8392179575367,5967.380670404269,5966.402090516397,-3387.5972644790418,5964.3559778288454,5963.2866571637105,3843.3495703015824,5961.0508145849808,5959.8823390225307,3643.3698459069378,5957.4391734690025,5956.1623486730723,-1789.1870239790233,5953.4926357072627,5952.0974147784809,-7384.4690011584007,5949.1801473384903]
["Accumulated cashflow per year (for payback calculation)",null,{"$f":"C102","v":-11362.8},{"$f":"C103+D102","v":-5387.7999999999993},{"$f":"D103+E102","v":586.45000000000073},5073.8187800000005,11046.500605000001,17018.36288475,21365.469909613061,27335.618602199836,33304.871755564214,37498.710973521753,43466.091643926018,49432.493734442418,46044.89646996338,52009.252447792227,57972.53910495594,61815.88867525752,67776.939489842494,{"$f":"S103+T102","v":73736.821828865024},{"$f":"T103+U102","v":77380.191674771966},{"$f":"U103+V102","v":83337.630848240966},{"$f":"V103+W102","v":89293.793196914034},{"$f":"W103+X102","v":87504.606172935004},{"$f":"X103+Y102","v":93458.098808642273},{"$f":"Y103+Z102","v":99410.19622342076},{"$f":"Z103+AA102","v":92025.727222262358},{"$f":"AA103+AB102","v":97974.907369600842}]
[null,null,{"$f":"C88+ABS(C103)/(ABS(C103)+ABS(D103))","v":0.67835182023330509},1.9018370506758169,{"$f":"E88+ABS(E103)/(ABS(E103)+ABS(F103))","v":2.1036081540990001},{"$f":"F88+ABS(F103)/(ABS(F103)+ABS(G103))","v":3.3147467899873746},4.3936060693484027,5.4433732028774697,6.4387062088854679,7.4507816219975531,8.4703839900729019,9.4631483034757728,10.46788755142925,11.517740311382761,12.469586417078427,13.472889663948129,14.48395775935321,15.477000846038369,16.478942393010104,17.487945202987287,18.481466152664506,19.482748904547311,20.5050599638638,21.483550498329716,22.484569528615918,23.519287051427561,24.484344315059481,26]
["Total initial investment costs:",{"$f":"SUM(C90:C94)","v":11362.8},{"$f":"E70","v":"€"}]
["Payback period:",{"$f":"ROUND(IF(W103<0,25,HLOOKUP(1,D87:AB104,18,FALSE)),1)","v":1.9},"years"]
["Net Present Value:",{"$f":"C102+NPV((E81/100),D102:W102)","v":52182.594850789756},{"$f":"E70","v":"€"}]
["Internal Rate of Return:",{"$f":"IRR(C102:W102)","v":0.49414294888332755}]
[]
[]
[]
[]
[null,"Economic Analysis: System without battery"]
[]
[null,null,null,{"$f":"IF(E129<0,0,1)","v":0},{"$f":"IF(F129<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":"U71","v":4765.2000000000007},{"$f":"IF(MOD(D116,$U$72)=0,$C$118*(1+($E$82/100))^D116,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8864.6756931100881,0,0,0,0]
["Solar cooling units cost",null,{"$f":"U75","v":15600},{"$f":"IF(MOD(D116,$U$76)=0,$C$119*(1+($E$82/100))^D116,0)","v":0},0,0,0,0,0,0,0,0,0,0,22241.869834800385,0,0,0,0,0,0,0,0,0,0,0,31711.588060782269,0,null,null,{"$f":"Translation!B140","v":"Accumulated income"}]
["Material & Construction",null,{"$f":"U77","v":2000},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(H85=\"Yes\",Translation!B142,\"\")","v":"Accumulated system costs with batteries"}]
["Maintenance costs",null,0,{"$f":"U78","v":25},{"$f":"$D$121*(1+($E$82/100))^(E116-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!B141","v":"Accumulated system costs without batteries"}]
[]
["Expenses per year:",null,{"$f":"SUM(C118:C122)","v":22365.200000000001},25,25.75,26.522499999999997,27.318175,28.137720249999997,28.981851857499997,29.851307413224998,30.74684663562175,31.669252034690398,32.619329595731109,33.597909483603047,22276.475681568496,35.644022171154468,36.713342836289101,37.814743121377774,38.949185415019109,40.117660977469676,41.321190806793766,42.560826530997581,43.837651326927507,8909.8284739768242,46.507364292737385,47.902585221519509,31760.927723560435,50.819852661510048]
["Expenses per year accumulated:",null,{"$f":"C123","v":22365.200000000001},{"$f":"SUM($C$123:D123)","v":22390.2},{"$f":"SUM($C$123:E123)","v":22415.95},{"$f":"SUM($C$123:F123)","v":22442.4725},{"$f":"SUM($C$123:G123)","v":22469.790675},{"$f":"SUM($C$123:H123)","v":22497.928395250001},{"$f":"SUM($C$123:I123)","v":22526.910247107502},{"$f":"SUM($C$123:J123)","v":22556.761554520726},{"$f":"SUM($C$123:K123)","v":22587.508401156349},{"$f":"SUM($C$123:L123)","v":22619.17765319104},{"$f":"SUM($C$123:M123)","v":22651.796982786771},{"$f":"SUM($C$123:N123)","v":22685.394892270375},{"$f":"SUM($C$123:O123)","v":44961.870573838867},{"$f":"SUM($C$123:P123)","v":44997.51459601002},{"$f":"SUM($C$123:Q123)","v":45034.227938846307},{"$f":"SUM($C$123:R123)","v":45072.042681967687},{"$f":"SUM($C$123:S123)","v":45110.991867382705},{"$f":"SUM($C$123:T123)","v":45151.109528360175},{"$f":"SUM($C$123:U123)","v":45192.430719166972},{"$f":"SUM($C$123:V123)","v":45234.991545697972},{"$f":"SUM($C$123:W123)","v":45278.829197024897},{"$f":"SUM($C$123:X123)","v":54188.657671001725},{"$f":"SUM($C$123:Y123)","v":54235.165035294463},{"$f":"SUM($C$123:Z123)","v":54283.067620515983},{"$f":"SUM($C$123:AA123)","v":86043.995344076422},{"$f":"SUM($C$123:AB123)","v":86094.815196737938}]
[]
[" Accumulated investment per year:",null,0,{"$f":"K73","v":6000},{"$f":"$K$73+D126","v":12000},{"$f":"$K$73+E126","v":18000},24000,30000,36000,42000,48000,54000,60000,66000,72000,78000,84000,90000,96000,102000,108000,114000,120000,126000,132000,138000,144000,150000]
["Income per year:",null,null,{"$f":"$K$73","v":6000},{"$f":"$K$73","v":6000},6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000]
["Cashfow per year:",null,{"$f":"C126-C124","v":-22365.200000000001},{"$f":"D127-D123","v":5975},{"$f":"E127-E123","v":5974.25},5973.4775,5972.6818249999997,5971.8622797500002,5971.0181481424997,5970.1486925867748,5969.2531533643778,5968.3307479653095,5967.380670404269,5966.402090516397,-16276.475681568496,5964.3559778288454,5963.2866571637105,5962.1852568786226,5961.0508145849808,5959.8823390225307,5958.6788091932067,5957.4391734690025,5956.1623486730723,-2909.8284739768242,5953.4926357072627,5952.0974147784809,-25760.927723560435,5949.1801473384903]
["Accumulated cashflow per year (for payback calculation)",null,{"$f":"C128","v":-22365.200000000001},{"$f":"C129+D128","v":-16390.2},{"$f":"D129+E128","v":-10415.950000000001},-4442.4725000000008,1530.2093249999989,7502.0716047499991,13473.089752892498,19443.238445479274,25412.491598843651,31380.82234680896,37348.203017213229,43314.605107729629,27038.129426161133,33002.48540398998,38965.772061153693,44927.957318032313,50889.008132617295,56848.890471639825,62807.569280833035,68765.008454302035,74721.170802975103,71811.342328998275,77764.834964705544,83716.932379484031,57956.004655923593,63905.184803262084]
[null,null,null,{"$f":"D116+ABS(D129)/(ABS(D129)+ABS(E129))","v":1.6114343163788907},{"$f":"E116+ABS(E129)/(ABS(E129)+ABS(F129))","v":2.7010131795619623},3.7437986201449798,4.1694156035337526,5.3576645479304759,6.409313264580919,7.433461643055792,8.4474556921112534,9.4565876233600132,10.463016399817901,11.615677633495025,12.450330655384681,13.458570021929098,14.464465846845773,15.468893552480248,16.472340827061632,17.475100889573703,18.477360635186987,19.479244822116303,20.50992895164282,21.48009879399439,22.481570373198569,23.590916897265714,24.475590341052222,26]
["Total initial investment costs:",{"$f":"SUM(C118:C122)","v":22365.200000000001},{"$f":"E70","v":"€"}]
["Payback period:",{"$f":"ROUND(IF(W129<0,25,HLOOKUP(1,D115:AB130,16,FALSE)),1)","v":3.7},"years"]
["Net Present Value:",{"$f":"C128+NPV((E81/100),D128:W128)","v":39623.837092545393},{"$f":"E70","v":"€"}]
["Internal Rate of Return:",{"$f":"IRR(C128:W128)","v":0.24630644348064634}]
[]
["Cooling Curve Calculation"]
[]
["Initial temperature of the product",null,null,"Ti =",{"$f":"'2 Input'!F18","v":30},"°C",{"$nulls":6},"Time (h)",{"$f":"P159","v":"Temperature of the product"}]
["Final temperature of the product",null,null,"Tm =",{"$f":"'2 Input'!F19","v":15},"°C",{"$nulls":6},0,{"$f":"E138","v":30}]
[{"$nulls":12},1,{"$f":"($E$139-($E$139-$E$138)*EXP(-M140*3600/$B$151))","v":24.115301745918522}]
["Total mass to be cooled",null,null,"Mass =",{"$f":"'2 Input'!F8","v":500},"kg/day",{"$nulls":6},2,{"$f":"($E$139-($E$139-$E$138)*EXP(-M141*3600/$B$151))","v":20.539248394609686}]
[" Moisture content of the product",null,null,"MC =",{"$f":"'2 Input'!F9","v":86},"% wet based",{"$nulls":6},3,18.366128037497468]
[" or Heat capacity of the product",null,null,"cp =",{"$f":"'2 Input'!F10","v":0},"kJ/kg K",null,"Calculated heat Capacity of the product:",null,null,{"$f":"4.19-2.3*((100-E142)/100)-0.628*((100-E142)/100)^3","v":3.8662767680000005},"kJ/kg K",4,17.045551518479066]
["Radius",null,null,"r =",{"$f":"'2 Input'!F11","v":0.05},"m",null,"cp value due to selection: ",null,null,{"$f":"IF(E143>0,E143,K143)","v":3.8662767680000005},"kJ/kg K",5,16.243054621850568]
["Density",null,null,"δ =",{"$f":"'2 Input'!F12","v":997},"kg/m³",{"$nulls":6},6,15.755387864321772]
["Convection air - product",null,null,"h =",{"$f":"'2 Input'!F13","v":5},"W/m²K",{"$nulls":6},7,15.459039221233194]
[{"$nulls":12},8,15.278952067650135]
[{"$nulls":12},9,15.169515484618589]
["Volumen Product",{"$f":"3/4*PI()*E144^3","v":2.9452431127404316E-4},"m³",{"$nulls":9},10,15.103012319526938]
["Surface Product",{"$f":"4*PI()*E144^2","v":3.1415926535897934E-2},"m²",{"$nulls":9},11,15.062599225069]
["Time constant Tau",{"$f":"3600*E145*K144*0.277778*B149/(B150*E146)","v":7227.5269151969105},"s",{"$nulls":9},12,15.038040721704308]
["Product Mass",{"$f":"E145*B149*1000","v":293.64073834022105},"g/unit",{"$nulls":9},13,15.023116843797817," "]
["Cold Room Volume",{"$f":"'2 Input'!F30","v":90.75},"m3",{"$nulls":4},"T: Temperature Cooling medium",{"$nulls":4},14,15.014047800442025]
[{"$nulls":7},"Tset: Start temperature",{"$nulls":4},15,15.008536662659701,null,"Titles for the diagramm"]
[{"$nulls":7},"t: Time (s)",{"$nulls":4},16,15.005187617069753]
[{"$nulls":12},17,15.003152446328871,null,{"$f":"Translation!B114","v":"Cooling Curve"}]
["Cooling Load Calculation",{"$nulls":11},18,15.001915699968364,null,{"$f":"Translation!B115","v":"Temperature in °C"}]
[{"$nulls":12},19,15.001164145551087,null,{"$f":"Translation!B116","v":"Time in h"}]
[{"$nulls":12},20,15.000707435864955,null,{"$f":"Translation!B117","v":"Temperature of the product"}]
["Total mass to be cooled",null,null,"Mass =",{"$f":"'2 Input'!F8","v":500},"kg/day",{"$nulls":6},21,15.000429899424997]
["Area of the refrigerator",null,null,"A =",{"$f":"'2 Input'!F33","v":3},"m²",{"$nulls":6},22,15.000261244198615]
["Thermal conductivity of insulation",null,null,"k /  l =",{"$f":"'2 Input'!F34","v":0.04},"W/m K",{"$nulls":6},23,15.00015875464665]
["Thickness of insulation",null,null,"L =",{"$f":"'2 Input'!F35","v":0.2},"m",{"$nulls":6},24,15.00009647310052]
["Ice storage inside the cold room?",null,null,null,{"$f":"IF(OR('2 Input'!F36=Translation!E86,'2 Input'!F36=Translation!F86,'2 Input'!F36=Translation!G86),\"Yes\",\"No\")","v":"Yes"}]
["Final temperature of the product",null,null,"Tm =",{"$f":"'2 Input'!F19","v":15},"°C"]
[]
["U",{"$f":"E162/E163","v":0.19999999999999998},"W/m²"]
["cp value due to selection: ",{"$f":"IF(E143>0,E143,K143)","v":3.8662767680000005},"kJ/kg"]
[]
[null,"Time (h)","T product  (°C)","T Ambient (°C)","Q Product (kW)","Q transmission (losses through insulation) (kW)",{"$f":"K190","v":"Accumulated Cooling load in kWh"}]
[null,{"$f":"M139","v":0},{"$f":"N139","v":30},26.6,{"$f":"($C171-$C172)*$E$160*$B$168/(($B172-$B171)*3600)","v":3.1599822425618584},{"$f":"$B$167*$E$161*(D171-$E$165)/1000","v":6.9600000000000009E-3},0]
[null,{"$f":"M140","v":1},24.115301745918522,27.3,1.9202794435130415,7.3800000000000003E-3,{"$f":"(E171+F171)*(B172-B171)","v":3.1669422425618583}]
[null,{"$f":"M141","v":2},20.539248394609686,28,1.1669284376070601,7.7999999999999996E-3,{"$f":"G172+(E172+F172)*(B173-B172)","v":5.0946016860748999}]
[null,{"$f":"M142","v":3},18.366128037497468,28.6,0.70912698831210552,8.1600000000000006E-3,{"$f":"G173+(E173+F173)*(B174-B173)","v":6.2693301236819599}]
[null,{"$f":"M143","v":4},17.045551518479066,27.7,0.43092709830928572,7.6199999999999992E-3,6.9866171119940654]
[null,{"$f":"M144","v":5},16.243054621850568,26.8,0.26186870210548246,7.0800000000000004E-3,7.4251642103033513]
[null,{"$f":"M145","v":6},15.755387864321772,25.8,0.1591341491669018,6.4800000000000005E-3,{"$f":"G176+(E176+F176)*(B177-B176)","v":7.6941129124088334}]
[null,{"$f":"M146","v":7},15.459039221233194,24.3,9.6703719182420975E-2,5.5799999999999999E-3,7.8597270615757351]
[null,{"$f":"M147","v":8},15.278952067650135,23,5.876557202002318E-2,4.7999999999999996E-3,7.9620107807581562]
[null,{"$f":"M148","v":9},15.169515484618589,21.8,3.5711061415600084E-2,4.0800000000000003E-3,8.0255763527781792]
[null,{"$f":"M149","v":10},15.103012319526938,21.3,2.1701140031349077E-2,3.7800000000000004E-3,8.0653674141937799]
[null,{"$f":"M150","v":11},15.062599225069,20.9,1.3187495974411387E-2,3.5399999999999993E-3,8.0908485542251292]
[null,{"$f":"M151","v":12},15.038040721704308,20.399999999999999,8.0138670053238204E-3,3.239999999999999E-3,8.1075760501995404]
[null,{"$f":"M152","v":13},15.023116843797817,20.100000000000001,4.8699210603449453E-3,3.0600000000000011E-3,8.1188299172048648]
[null,{"$f":"M153","v":14},15.014047800442025,19.7,2.9593866629233595E-3,2.8199999999999996E-3,8.12675983826521]
[null,{"$f":"M154","v":15},15.008536662659701,19.3,1.7983801610261501E-3,2.5800000000000007E-3,8.1325392249281325]
[null,{"$f":"M155","v":16},15.005187617069753,19.100000000000001,1.0928518547758119E-3,2.4600000000000008E-3,8.1369176050891578]
[null,{"$f":"M156","v":17},15.003152446328871,18.8,6.6411162799084303E-4,2.2800000000000003E-3,8.1404704569439339,null,null,null,"Titles for the diagramm"]
[null,{"$f":"M157","v":18},15.001915699968364,18.600000000000001,4.035718588066834E-4,2.1600000000000005E-3,8.1434145685719255,null,null,null,{"$f":"Translation!B116","v":"Time in h"}]
[null,{"$f":"M158","v":19},15.001164145551087,19.5,2.4524528461281015E-4,2.6999999999999997E-3,8.1459781404307314,null,null,null,{"$f":"Translation!B118","v":"Accumulated Cooling load in kWh"}]
[null,{"$f":"M159","v":20},15.000707435864955,21,1.4903231806701972E-4,3.5999999999999995E-3,8.148923385715344,null,null,null,{"$f":"Translation!B119","v":"Cooling load"}]
[null,{"$f":"M160","v":21},15.000429899424997,22.5,9.0564969939229773E-5,4.4999999999999997E-3,8.1526724180334114]
[null,{"$f":"M161","v":22},15.000261244198615,24,5.5035135239710507E-5,5.3999999999999994E-3,8.157262983003351]
[null,{"$f":"M162","v":23},15.00015875464665,25.3,3.3444124288651298E-5,6.1800000000000006E-3,8.162718018138591]
[null,{"$f":"M163","v":24},15.00009647310052,26.6,null,6.9600000000000009E-3,8.1689314622628793]
{"$rows_empty":33}
[null,5.17,6.01,6.19,6.28,6.02,5.57,5.14,4.97,5.3,5.56,5.53,5.26]
[]
[]
[null,5.17,6.01,6.19,6.28,6.02,5.57,5.14,4.97,5.3,5.56,5.53,5.26]

{"sheet":"Translation","index":6,"n_rows":142,"n_cols":8,"rows_kept":142,"cut":false,"hidden":true,"merged":[[47,2,112,3],[123,2,141,3],[5,2,28,3],[29,2,46,3],[113,2,122,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 Water Chiller for Cold Rooms "},"Read me",null,"Design Tool: Solar Water Chiller for Cold Rooms ","Outil de conception: Refroidisseur solaire d'eau pour chambres froides"]
[null,{"$f":"INDEX(E7:H7,$C$3)","v":"Read Me Sheet "},null,null,"Read Me Sheet ","Lisez-moi"]
[null,"Introduction",null,null,"Introduction","Introduction"]
[null,{"$f":"INDEX(E9:H9,$C$3)","v":"This tool calculates the required power of a do-it-yourself water chiller for cold rooms 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 water chiller for cold rooms 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 refroidisseur d'eau pour chambres froides 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."]
[null,"Tips & Tricks",null,null,"Tips & Tricks","Conseils et astuces"]
[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. "]
[null,"Overview of the following sheets",null,null,"Overview of the following sheets","Aperçu des feuilles"]
[null,"1. Geographic Data",null,null,"1. Geographic Data","1. Geographic Data","1. Geographic Data","1. Geographic Data"]
[null,"2. Input",null,null,"2. Input","2. Input","2. Input","2. Input"]
[null,"3. Cooling Curve",null,null,"3. Cooling Curve","3. Cooling Curve","3. Cooling Curve","3. Cooling Curve"]
[null,"4. Output",null,null,"4. Output","4. Output","4. Output","4. Output"]
[null,"5. Weather Data",null,null,"5. Weather Data","5. Weather Data","5. Weather Data","5. Weather Data"]
[null,"Calculation Sheet (Hidden)",null,null,"Calculation Sheet (Hidden)","Feuille de calcul (caché)"]
[null,"Translation sheet (Hidden)",null,null,"Translation sheet (Hidden)","Feuille de traduction (caché)"]
[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"]
[null,"Visualization of the Cooling Curve and Cooling Load profile",null,null,"Visualization of the Cooling Curve and Cooling Load profile","Visualisation de la courbe de refroidissement et du profil de charge de refroidissement"]
[null,"For an overview of the results",null,null,"For an overview of the results","Pour un aperçu des résultats"]
[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"]
[null,"Contains the translation into several languages",null,null,"Contains the translation into several languages","Contient la traduction en plusieurs langues"]
[null,"Additional information",null,null,"Additional information","Informatios supplémentaires"]
[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."]
[null,"In cooperation with",null,null,"In cooperation with","En coopération avec"]
[null,"1. Geographic Data","1 Geographic Data",null,"1. Geographic Data","1. Données géographiques"]
[null,"Mean daily temperature [°C]:",null,null,"Mean daily temperature [°C]:","Temperature quotidienne moyenne [°C]"]
[null,"Solar irradiation [kWh/m² day]:",null,null,"Solar irradiation [kWh/m² day]:","Irradiation solaire [kWh/m² jour]"]
[null,"January",null,null,"January","Janvier"]
[null,"February",null,null,"February","Février"]
[null,"March",null,null,"March","Mars "]
[null,"April",null,null,"April","Avril"]
[null,"May",null,null,"May","Mai"]
[null,"June",null,null,"June","Juin"]
[null,"July",null,null,"July","Juillet"]
[null,"August",null,null,"August","Août"]
[null,"September",null,null,"September","Septembre"]
[null,"October",null,null,"October","Octobre "]
[null,"November",null,null,"November","Novembre"]
[null,"December",null,null,"December","Décembre"]
[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,"Choose location:",null,null,"Choose location:","Selectionner localisation:","Selectionar ubicación:"]
[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:"]
[null,"Input of parameters","2 Input",null,"Input of parameters","Entrée de paramètres"]
[null,"Product information",null,null,"Product information","Information du produit"]
[null,"Data",null,null,"Data","Données"]
[null,"Total mass to be cooled",null,null,"Total mass to be cooled","Masse totale à refroidir"]
[null," Moisture content of the product",null,null," Moisture content of the product","Teneur en humidité du produit"]
[null," or Heat capacity of the product",null,null," or Heat capacity of the product","ou capacité thermique du produit"]
[null,"Mass =",null,null,"Mass =","Masse ="]
[null,"MC =",null,null,"MC =","MC ="]
[null,"cp =",null,null,"cp =","cp ="]
[null,"kg or l",null,null,"kg or l","kg ou l"]
[null,"% wet based",null,null,"% wet based","% à base humide"]
[null,"kJ/kg K",null,null,"kJ/kg K","kJ/kg K"]
[null,"Radius",null,null,"Radius","Rayon"]
[null,"Density",null,null,"Density","Densité "]
[null,"Convection air - product",null,null,"Convection air - product","Convection air - produit"]
[null,"Conduction coefficient of the product",null,null,"Conduction coefficient of the product","Coefficient de conduction du porduit"]
[null,"Temperature information",null,null,"Temperature information","Information des températures"]
[null,"Initial temperature of the product",null,null,"Initial temperature of the product","Température initiale du produit"]
[null,"Final temperature of the product",null,null,"Final temperature of the product","Température finale du produit"]
[null,"Time to cool down the product",null,null,"Time to cool down the product","Temps pour refroidir le produit"]
[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?"]
[null,"per month",null,null,"per month","par mois"]
[null,"System information",null,null,"System information","Informations du système"]
[null,"Batteries",null,null,"Batteries","Batteries"]
[null,"Autonomy of the system",null,null,"Autonomy of the system","Autonomie du système"]
[null,"System losses",null,null,"System losses","Pertes du système"]
[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,"Ice storage",null,null,"Ice storage","Stockage de glace"]
[null,"Water bath",null,null,"Water bath","Bain d'eau"]
[null,"Ice on evaporator surface",null,null,"Ice on evaporator surface","Glace surface de l'évaporateur"]
[null,"DC pump",null,null,"DC pump","Pompe CC"]
[null,"Fan coil unit",null,null,"Fan coil unit","Ventilo-convecteur"]
[null,"Cold room",null,null,"Cold room","Chambre froide"]
[null,"Cooled product",null,null,"Cooled product","Produit refroidi"]
[null,"Yes",null,null,"Yes","Oui"]
[null,"No",null,null,"No","Non"]
[null,"Cold Room",null,null,"Cold Room","Chambre froide"]
[null,"Inner length of the cold room",null,null,"Inner length of the cold room","Longueur intérieur de la chambre froide"]
[null,"Inner width of the cold room",null,null,"Inner width of the cold room","Largeur intérieur de la chambre froide"]
[null,"Inner height of the cold room",null,null,"Inner height of the cold room","Hauteur intérieur de la chambre froide"]
[null,"Area of the cold room",null,null,"Area of the cold room","Surface du réfrigérateur"]
[null,"Thermal conductivity of insulation",null,null,"Thermal conductivity of insulation","Conductivité thermique de l'isolation"]
[null,"Thickness of insulation",null,null,"Thickness of insulation","Épaisseur de l'isolation"]
[null,"Ice storage inside the cold room?",null,null,"Ice storage inside the cold room?","Stockage de glace dans la chambre froide?"]
[null,"Economic information",null,null,"Economic information","Informations économiques"]
[null,{"$f":"INDEX(E97:H97,$C$3)","v":"Currency used for calculation"},null,null,"Currency used for calculation","Devise utilisée pour le calcul"]
[null,"Specific cost of PV",null,null,"Specific cost of PV","Coût spécifique du PV"]
[null,"PV lifetime",null,null,"PV lifetime","PV durée de vie"]
[null,"Specif cost of battery  ",null,null,"Specif cost of battery  ","Coût spécifique de la batterie"]
[null,"Battery lifetime",null,null,"Battery lifetime","Durée de vie de la batterie"]
[null,"Cost of solar cooling unit",null,null,"Cost of solar cooling unit","Coût de l'unité de refroidissement solaire"]
[null,"Solar cooling unit lifetime",null,null,"Solar cooling unit lifetime","Durée de vie de l'unité de refroidissement solaire"]
[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"]
[null,"Maintenance costs per year",null,null,"Maintenance costs per year","Coûts de maintenance par an"]
[null,"years",null,null,"years","années"]
[null,"Additional income per product unit",null,null,"Additional income per product unit","Revenu supplémentaire par unité de produit"]
[null,"Additional income per month",null,null,"Additional income per month","Revenu supplémentaire par mois"]
[null,"Discount rate",null,null,"Discount rate","Taux de remise"]
[null,"Inflation  ",null,null,"Inflation  ","Inflation"]
[null,"€/kg or l",null,null,{"$f":"'2 Input'!G45&\"/kg or l\"","v":"€/kg or l"},{"$f":"'2 Input'!G45&\"/kg ou l\"","v":"€/kg ou l"}]
[null,"€/Wp",null,null,{"$f":"'2 Input'!G45&\"/Wp\"","v":"€/Wp"},{"$f":"'2 Input'!G45&\"/Wc\"","v":"€/Wc"}]
[null,"€/month",null,null,{"$f":"'2 Input'!G45&\"/month\"","v":"€/month"},{"$f":"'2 Input'!G45&\"/mois\"","v":"€/mois"}]
[null,"Cooling Curve","3 Cooling Curve",null,"Cooling Curve","Courbe de refroidissement"]
[null,"Temperature in °C",null,null,"Temperature in °C","Température en °C"]
[null,"Time in h",null,null,"Time in h","Temps en h"]
[null,"Temperature of the product",null,null,"Temperature of the product","Température du produit"]
[null,"Accumulated Cooling load in kWh",null,null,"Accumulated Cooling load in kWh","Charge de refroidissement accumulée en kWh"]
[null,"Cooling load",null,null,"Cooling load","Charge de refroidissement"]
[null,"Thermal losses cold month in kWh",null,null,"Thermal losses cold month in kWh","Pertes thermiques mois froid en kWh"]
[null,"Thermal losses hot month in kWh",null,null,"Thermal losses hot month in kWh","Pertes thermiques mois chaud en kWh"]
[null,"Cooling Curve & Cooling Load",null,null,"Cooling Curve & Cooling Load","Courbe de refroidissement et charge de refroidissement"]
[null,0]
[null,"Results","4 Output",null,"Results","Résultats"]
[null,"System Design without batteries",null,null,"System Design without batteries","Conception du système sans batteries"]
[null,"Cooling units needed:",null,null,"Cooling units needed:","Unités de refroidissement nécessaires:"]
[null,"Cooling units costs:",null,null,"Cooling units costs:","Coûts des unités de refroidissement:"]
[null,"Solar PV size:",null,null,"Solar PV size:","Taille PV solaire:"]
[null,"Solar PV costs:",null,null,"Solar PV costs:","Coûts PV solaire:"]
[null,"Battery size:",null,null,"Battery size:","Taille des batteries:"]
[null,"Battery costs:",null,null,"Battery costs:","Coûts des batteries:"]
[null,"Total initial investment:",null,null,"Total initial investment:","Investissement initial total:"]
[null,"Payback period:",null,null,"Payback period:","Période de récupération:"]
[null,"Net present value:",null,null,"Net present value:","Valeur actuelle nette:"]
[null,"Internal rate of return:",null,null,"Internal rate of return:","Taux de rendement interne:"]
[null,"System Design with batteries",null,null,"System Design with batteries","Conception du système avec batteries"]
[null,"years",null,null,"years","années"]
[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 "]
[null,"Years",null,null,"Years","Années"]
[null,"Accumulated income",null,null,"Accumulated income","Revenu accumulé"]
[null,"Accumulated system costs without batteries",null,null,"Accumulated system costs without batteries","Coûts accumulé du système sans batteries"]
[null,"Accumulated system costs with batteries",null,null,"Accumulated system costs with batteries","Coûts accumulé du système avec batteries"]

{"sheet":"5 Weather Data","index":7,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,{"$f":"\"Selection: \"&S13","v":"Selection: Mali (Bamako)"},{"$f":"Translation!B33","v":"January"},{"$f":"Translation!B34","v":"February"},{"$f":"Translation!B35","v":"March"},{"$f":"Translation!B36","v":"April"},{"$f":"Translation!B37","v":"May"},{"$f":"Translation!B38","v":"June"},{"$f":"Translation!B39","v":"July"},{"$f":"Translation!B40","v":"August"},{"$f":"Translation!B41","v":"September"},{"$f":"Translation!B42","v":"October"},{"$f":"Translation!B43","v":"November"},{"$f":"Translation!B44","v":"December"}]
[null,{"$f":"Translation!B31","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":"Translation!B32","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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"Solar irradiation [kWh/m² day]:"]