{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Example  - Male"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Example  - Male","index":0,"n_rows":92,"n_cols":42,"rows_kept":92,"cut":false,"hidden":false,"merged":[[13,33,13,41],[54,8,54,11],[54,13,54,15],[54,19,54,21],[54,22,54,25],[54,26,54,32],[54,33,54,41],[13,8,13,11],[13,13,13,15],[13,19,13,21],[13,22,13,25],[13,26,13,32],[10,0,10,1],[13,0,13,6],[54,0,54,6],[0,0,3,3],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1]]}
["Using the dataset provided, determine and analyze:\n- Heat transfer from the human body per different mechanisms\n- Evaluate the category of comfort per ISO 17772 standard\n- Evaluate the thermal sensation using the PMV index"]
[]
[]
[]
[]
["Given and constants:"]
["1 met ",null,58.2,"W/m2","A_body",{"$f":"C9","v":0},null,null,"f_eff (sitting)",null,null,null,null,"alfa_1"]
["Summer Clothing insulation level",null,0.4,"clo","R_cl_summer",null,null,null,"f_cl_summer",null,"R_v,cl",null,null,"alfa_2"]
["Surface area A_body (m2) ",null,null,"m2","Epsilon",null,null,null,null,null,null,null,null,"alfa_3"]
["1kcal/min =",null,69.78,"W","Stefan-Boltzman contstant",{"$f":"5.67*10^-8","v":5.6699999999999998E-8},null,null,"h_fg (or L_v) [kJ/kg]",2430]
["Winter Clothing insulation level",null,0.8,"clo","R_cl_winter",null,null,null,"f_cl_winter"]
[]
["Case (2-1): DRIFT UP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of missing values:"]
["Input parameters",null,null,null,null,null,null,null,"Calculated values using embbedded formulas",null,null,null,null,"Values calculated using online tool https://comfort.cbe.berkeley.edu/upload",null,null,"Calculated",null,null,"Heat Transfer Coefficients",null,null,"Finding skin temperature via iteration",null,null,null,"Skin evaporation related parameters",null,null,null,null,null,null,"Heat fluxes "]
["Time (min)","M (kcal/min)","Air Temperature (ta ,oC)","Globe Temperature (tg,oC)","Air Speed (va, m/s)","RH (%)","t_sk mean (oC)",null,"Coefficient A","Mean Radiant Temperature (tmrt, oC)","Operative Temperature (top, oC)","T_OP Category",null,"PMV","PPD","SET ","Sensation",null,"Met (-)","h_conv [W/m2K]","h_rad [W/m2K]","h_e  [W/m2kPa]","t_cl [°C]","T_cl iteration [K]","T_cl iteration [K]","Delta","t_b [oC]","M_rsw [kg/sm2]","Q_E,rsw [W/m2]","Q_E,max [W/m2]","w [-]","p_v,sk [kPa]","p_v,a [kPa]","Q_M [W/m2]","Q_conv, res [W/m2]","Q_conv,sk [W/m2]","Q_rad [W/m2]","Q_E,sk  [W/m2]","Q_E,res [W/m2] simplified formula","Heat generation","Heat losses","Delta Q [W/m2]"]
[5,1.1340886752445956,23.667901666666666,23.886231666666689,9.8998656249999969E-2,51.987200000000001,32.67856428571428,null,{"$f":"IF(E16<0.2,0.5,IF(E16<0.6,0.6,IF(E16<1,0.7,)))","v":0.5},{"$f":"((D16+273)^4+(1.1*10^8*E16^0.6/(0.95*0.04^0.4))*(D16-C16))^0.25-273","v":24.104518212919061},{"$f":"I16*C16+J16*(1-I16)","v":23.886209939792863},{"$f":"IF(AND(K16>=23.5,K16<=25.5),\"Category I\",IF(AND(K16>=25.5,K16<=26),\"Category II\",IF(AND(K16>=26,K16<=27),\"Category III\",IF(AND(K16>=27,K16<=28),\"Category IV\",IF(AND(K16>=28),\"Beyond Cat. IV\",)))))","v":"Category I"},null,null,null,null,{"$f":"IF(N16<=-2.5,\"Cold\",IF(AND(N16<=-1.5,N16>-2.5),\"Cool\",IF(AND(N16<=-0.5,N16>-1.5),\"Slightly Cool\",IF(AND(N16<=0.5,N16>-0.5),\"Neutral\",IF(AND(N16<=1.5,N16>0.5),\"Slightly Warm\",IF(AND(N16<=2.5,N16>1.5),\"Warm\",IF(N16>2.5,\"Hot\",)))))))","v":"Neutral"},null,{"$f":"AH16/$C$7","v":0},null,null,null,{"$f":"Y16-273.15","v":{"$error":"#DIV/0!"}},{"$f":"((1/$F$8)*(G16+273.15)+$J$8*(T16*(C16+273.15)+4*$F$9*$F$10*($J$7/$C$9)*(J16+273.15)*((Y16+(J16+273.15))/2)^3))/((1/$F$8)+$J$8*(T16+4*$F$9*$F$10*($J$7/$C$9)*(((J16+273.15)+Y16)/2)^3))","v":{"$error":"#DIV/0!"}},{"$f":"X16","v":{"$error":"#DIV/0!"}},{"$f":"X16-Y16","v":{"$error":"#DIV/0!"}}]
[10,1.1679612865373161,23.600900000000006,23.828655833333311,9.6832999999999961E-2,52.128600000000006,32.721133333333327,null,{"$f":"IF(E17<0.2,0.5,IF(E17<0.6,0.6,IF(E17<1,0.7,)))","v":0.5},{"$f":"((D17+273)^4+(1.1*10^8*E17^0.6/(0.95*0.04^0.4))*(D17-C17))^0.25-273","v":24.053487642921709},{"$f":"I17*C17+J17*(1-I17)","v":23.82719382146086},{"$f":"IF(AND(K17>=23.5,K17<=25.5),\"Category I\",IF(AND(K17>=25.5,K17<=26),\"Category II\",IF(AND(K17>=26,K17<=27),\"Category III\",IF(AND(K17>=27,K17<=28),\"Category IV\",IF(AND(K17>=28),\"Beyond Cat. IV\",)))))","v":"Category I"},null,null,null,null,{"$f":"IF(N17<=-2.5,\"Cold\",IF(AND(N17<=-1.5,N17>-2.5),\"Cool\",IF(AND(N17<=-0.5,N17>-1.5),\"Slightly Cool\",IF(AND(N17<=0.5,N17>-0.5),\"Neutral\",IF(AND(N17<=1.5,N17>0.5),\"Slightly Warm\",IF(AND(N17<=2.5,N17>1.5),\"Warm\",IF(N17>2.5,\"Hot\",)))))))","v":"Neutral"},null,0,null,null,null,{"$f":"Y17-273.15","v":{"$error":"#DIV/0!"}},{"$f":"((1/$F$8)*(G17+273.15)+$J$8*(T17*(C17+273.15)+4*$F$9*$F$10*($J$7/$C$9)*(J17+273.15)*((Y17+(J17+273.15))/2)^3))/((1/$F$8)+$J$8*(T17+4*$F$9*$F$10*($J$7/$C$9)*(((J17+273.15)+Y17)/2)^3))","v":{"$error":"#DIV/0!"}},{"$f":"X17","v":{"$error":"#DIV/0!"}},{"$f":"X17-Y17","v":{"$error":"#DIV/0!"}}]
[15,1.1359202820037972,23.536788750000014,23.768019166666654,0.10242256250000002,52.251200000000004,32.664957142857141,null,0.5,24.004228833969307,23.77050879198466,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[20,1.0465124045434553,23.483519583333329,23.711248750000024,0.10015518749999998,52.553600000000003,32.624666666666663,null,0.5,23.940917321749112,23.712218452541222,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[25,1.1137867168254894,23.525407916666698,23.732025416666676,9.0801270833333336E-2,52.709800000000008,32.532157142857145,null,0.5,23.928489332988647,23.726948624827671,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[30,1.1108665893012701,23.607169166666679,23.791192916666688,8.0655666666666639E-2,52.714800000000004,32.478866666666661,null,0.5,23.954096007211263,23.780632586938971,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[35,1.0167790818606866,23.94901708333332,24.10603041666668,4.1113864583333326E-2,52.797799999999995,32.58040714285714,null,0.5,24.198538008745004,24.07377754603916,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[40,1.0628000091328969,24.504977916666668,24.702874999999981,2.6061781249999999E-2,52.685600000000001,32.728290476190473,null,0.5,24.791037711958779,24.648007814312724,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y23-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[45,1.0701954117976826,25.177357500000014,25.41508875000002,2.5253479166666662E-2,52.749000000000002,32.87167619047618,null,0.5,25.518264238930726,25.34781086946537,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[50,1.0691612309992409,25.976170416666669,26.188603749999999,2.8028239583333326E-2,54.951000000000001,33.046392857142855,null,0.5,26.285994578006125,26.131082497336397,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"X25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[55,1.1767608511985999,26.699236666666668,26.894073333333349,3.8296510416666672E-2,57.514599999999994,33.202154761904765,null,0.5,27.001031838030315,26.850134252348489,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[60,1.0849903804720249,27.120000000000005,27.28803291666668,5.6730718750000006E-2,58.803800000000003,33.231597619047619,null,0.5,27.404339433142241,27.262169716571123,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[65,1.0319733864501814,27.309049999999978,27.405440416666686,4.5119406250000001E-2,58.554600000000008,33.313283333333331,null,0.5,27.463541950937383,27.386295975468681,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y28-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[70,1.097828951768185,27.530294583333319,27.568353749999993,4.9780802083333298E-2,57.729399999999998,33.358609523809527,null,0.5,27.592653347335784,27.56147396533455,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[75,1.054655965607421,27.760282083333337,27.772115000000031,4.3798125000000007E-2,57.495199999999997,33.381321428571425,null,0.5,27.779097683802377,27.769689883567857,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[80,0.96298777258107882,27.979344166666674,27.997770833333348,5.019286458333333E-2,57.602599999999995,33.475480952380948,null,0.5,28.009544229079665,27.994444197873172,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[85,1.1286204186421724,28.180379999999992,28.17451041666666,3.9049979166666644E-2,56.982600000000005,33.49482142857142,null,0.5,28.171289962107721,28.175834981053857,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y32-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[90,1.1197356026706207,28.524351666666679,28.50866916666666,2.6194281250000017E-2,57.031199999999998,33.561814285714277,null,0.5,28.50192016631695,28.513135916491812,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[95,1.1691132903880068,29.028617083333327,29.032179166666648,2.4649343750000014E-2,57.529200000000003,33.711640476190475,null,0.5,29.033649478879624,29.031133281106477,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[100,0.98364140718158721,29.619148750000004,29.624862499999999,2.9702854166666667E-2,59.091600000000007,33.860121428571425,null,0.5,29.627484699776744,29.623316724888376,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"X35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[105,1.2112132870029262,30.209313750000014,30.215783750000021,3.365656249999998E-2,60.654399999999995,33.999099999999999,null,0.5,30.218965521428515,30.214139635714265,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[110,1.1138153311755095,30.634354166666665,30.651434166666657,3.4472156250000011E-2,62.871200000000002,34.146121428571419,null,0.5,30.659918345545748,30.647136256106208,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[115,1.1744193464330899,30.96396625000002,30.945671666666659,3.0342458333333298E-2,64.614400000000003,34.258516666666665,null,0.5,30.937277681945375,30.950621965972697,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[120,1.1822779115845714,31.305923749999991,31.270272499999979,3.6789020833333352E-2,66.264800000000008,34.373016666666658,null,0.5,31.251968272278305,31.278946011139148,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[125,1.0822519755020017,31.565649166666663,31.514422499999995,3.1069979166666681E-2,66.684600000000003,34.477738095238102,null,0.5,31.490713519091457,31.528181342879058,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[130,1.0421247113336209,31.84491916666666,31.775082500000025,3.8099093749999986E-2,66.318400000000011,34.578423809523812,null,0.5,31.738644301740067,31.791781734203362,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[135,1.1504046647017876,32.030645000000014,31.974916666666704,2.1644739583333326E-2,66.411000000000016,34.651442857142854,null,0.5,31.954247434063518,31.992446217031766,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[140,1.092939801558336,32.065689166666651,32.008399166666692,1.9398729166666656E-2,66.401399999999995,34.712466666666671,null,0.5,31.988509158243687,32.027099162455173,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[145,1.221311960184899,32.02962041666666,31.96873166666667,3.6960562500000016E-2,66.103399999999993,34.742673809523808,null,0.5,31.93759544837377,31.983607932520215,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[150,1.1756477941446977,31.848255416666664,31.77888500000002,6.0913177083333304E-2,64.316400000000016,34.697197619047621,null,0.5,31.730918940304605,31.789587178485633,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[155,1.1708456681230301,31.56881416666667,31.474804583333359,5.9239604166666689E-2,60.678600000000003,34.656261904761905,null,0.5,31.410682500212658,31.489748333439664,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[160,1.1076233071177257,31.418982499999995,31.282807916666673,2.6905729166666663E-2,56.762799999999991,34.657692857142848,null,0.5,31.224854394421925,31.321918447210962,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[165,1.0882743430937374,31.438315000000014,31.326425000000018,2.5543718749999982E-2,55.810600000000001,34.708769047619043,null,0.5,31.280290416484092,31.359302708242055,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[170,1.1273734571515401,31.517347083333345,31.440021250000015,2.1953374999999997E-2,55.244199999999999,34.752500000000005,null,0.5,31.410943053302333,31.464145068317841,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[175,1.3312053806022459,31.727677083333315,31.674846666666642,2.1887531250000015E-2,56.108400000000003,34.83598095238095,null,0.5,31.655062411999097,31.691369747666208,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[180,1.2661075930057848,31.838399377593344,31.830045643153547,2.5535088174273857E-2,57.138599999999997,34.95579285714286,null,0.5,31.82661968398611,31.832509530789729,"Beyond Cat. IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["Case (2-2): DRIFT DOWN ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of missing values:"]
["Input parameters",null,null,null,null,null,null,null,"Calculated values using embbedded formulas",null,null,null,null,"Values calculated using online tool https://comfort.cbe.berkeley.edu/upload",null,null,"Calculated",null,null,"Heat Transfer Coefficients",null,null,"Finding skin temperature via iteration",null,null,null,"Skin evaporation related parameters",null,null,null,null,null,null,"Heat fluxes "]
["Time (min)","M (kcal/min)","Air Temperature (ta ,oC)","Globe Temperature (tg,oC)","Air Speed (va, m/s)","RH (%)","t_sk mean (oC)",null,"Coefficient A","Mean Radiant Temperature (tmrt, oC)","Operative Temperature (top, oC)","T_OP Category",null,"PMV","PPD","SET ","Sensation",null,"Met (-)","h_conv [W/m2K]","h_rad [W/m2K]","h_e  [W/m2kPa]","t_cl [°C]","T_cl iteration [K]","T_cl iteration [K]","Delta","t_b [oC]","M_rsw [kg/sm2]","Q_E,rsw [W/m2]","Q_E,max [W/m2]","w [-]","p_v,sk [kPa]","p_v,a [kPa]","Q_M [W/m2]","Q_conv, res [W/m2]","Q_conv,sk [W/m2]","Q_rad [W/m2]","Q_E,sk  [W/m2]","Q_E,res [W/m2] simplified formula","Heat generation","Heat losses","Delta Q [W/m2]"]
[5,0.86985584027060514,23.305297291666665,23.497937380952383,8.2136015625000017E-2,33.777140476190468,32.679916666666671,null,{"$f":"IF(E57<0.2,0.5,IF(E57<0.6,0.6,IF(E57<1,0.7,)))","v":0.5},{"$f":"((D57+273)^4+(1.1*10^8*E57^0.6/(0.95*0.04^0.4))*(D57-C57))^0.25-273","v":23.670842176290364},{"$f":"I57*C57+J57*(1-I57)","v":23.488069733978513},{"$f":"IF(AND(K57>=21,K57<=25),\"Category I\",IF(AND(K57>=20,K57<=21),\"Category II\",IF(AND(K57>=18,K57<=20),\"Category III\",IF(AND(K57>=16,K57<=18),\"Category IV\",))))","v":"Category I"},null,null,null,null,{"$f":"IF(N57<=-2.5,\"Cold\",IF(AND(N57<=-1.5,N57>-2.5),\"Cool\",IF(AND(N57<=-0.5,N57>-1.5),\"Slightly Cool\",IF(AND(N57<=0.5,N57>-0.5),\"Neutral\",IF(AND(N57<=1.5,N57>0.5),\"Slightly Warm\",IF(AND(N57<=2.5,N57>1.5),\"Warm\",IF(N57>2.5,\"Hot\",)))))))","v":"Neutral"},null,{"$f":"AH57/$C$7","v":0},null,null,null,{"$f":"Y57-273.15","v":{"$error":"#DIV/0!"}},{"$f":"((1/$F$8)*(G57+273.15)+$J$8*(T57*(C57+273.15)+4*$F$9*$F$10*($J$7/$C$9)*(J57+273.15)*((Y57+(J57+273.15))/2)^3))/((1/$F$8)+$J$8*(T57+4*$F$9*$F$10*($J$7/$C$9)*(((J57+273.15)+Y57)/2)^3))","v":{"$error":"#DIV/0!"}},{"$f":"X57","v":{"$error":"#DIV/0!"}},{"$f":"X57-Y57","v":{"$error":"#DIV/0!"}}]
[10,0.95016526245831445,23.220210833333333,23.363029523809519,5.6275375000000016E-2,33.662338095238098,32.684954761904763,null,{"$f":"IF(E58<0.2,0.5,IF(E58<0.6,0.6,IF(E58<1,0.7,)))","v":0.5},{"$f":"((D58+273)^4+(1.1*10^8*E58^0.6/(0.95*0.04^0.4))*(D58-C58))^0.25-273","v":23.465373937284483},{"$f":"I58*C58+J58*(1-I58)","v":23.342792385308908},{"$f":"IF(AND(K58>=21,K58<=25),\"Category I\",IF(AND(K58>=20,K58<=21),\"Category II\",IF(AND(K58>=18,K58<=20),\"Category III\",IF(AND(K58>=16,K58<=18),\"Category IV\",))))","v":"Category I"},null,null,null,null,"Neutral",null,{"$f":"AH58/$C$7","v":0},null,null,null,{"$f":"Y58-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"X58","v":{"$error":"#DIV/0!"}},{"$f":"X58-Y58","v":{"$error":"#DIV/0!"}}]
[15,0.94729884199770453,23.436521875,23.570524285714288,4.7561916666666683E-2,33.509747619047616,32.686876190476184,null,0.5,23.657156430626571,23.546839152813284,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[20,0.93462182964390794,23.638828958333331,23.802491428571422,6.7927874999999999E-2,33.411876190476185,32.685661904761901,null,0.5,23.933190808583333,23.786009883458334,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[25,1.0284252991193024,23.738446458333332,23.884690952380947,5.694915104166666E-2,33.425269047619047,32.686973809523806,null,0.5,23.989684638192273,23.864065548262801,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[30,1.0643867989426679,23.889043958333339,24.029417142857145,7.417263541666666E-2,33.459552380952381,32.682802380952374,null,0.5,24.147329273343132,24.018186615838236,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[35,0.99601545031443595,23.704098333333338,23.914606428571432,9.7697354166666667E-2,33.510016666666658,32.672407142857139,null,0.5,24.123358552782577,23.913728443057956,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[40,1.0435383708788299,23.059045625000003,23.338413571428571,0.11041317187499999,33.593366666666668,32.655490476190479,null,0.5,23.638158242091549,23.348601933545776,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y64-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[45,0.9311399555994857,22.365010416666667,22.612804761904762,0.1211748333333333,33.733561904761906,32.636945238095237,null,0.5,22.896028809594725,22.630519613130694,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y65-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[50,0.94138168945005596,21.743085208333333,21.935595238095235,0.12349808333333334,33.837669047619045,32.61481666666667,null,0.5,22.159755141093626,21.95142017471348,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[55,1.1447627455165954,21.105725,21.309205952380953,0.12514229687500003,33.975219047619056,32.594161904761911,null,0.5,21.549535883108604,21.327630441554302,"Category I",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[60,1.0388853556073689,20.619467083333337,20.80789,0.12786189583333335,34.092564285714289,32.576180952380959,null,0.5,21.03449564733188,20.826981365332607,"Category II",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[65,1.0179356629784522,20.145858749999995,20.355005000000006,0.12767671875,34.261476190476188,32.566366666666667,null,0.5,20.607446730234869,20.376652740117432,"Category II",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[70,0.92995039930986667,19.682043749999998,19.896833809523809,0.130579265625,34.272821428571419,32.566816666666668,null,0.5,20.160826960966233,19.921435355483116,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[75,1.0475887690976688,19.293400416666667,19.512446666666666,0.1276068125,34.303354761904757,32.575600000000001,null,0.5,19.77902113296193,19.5362107748143,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[80,0.86403543044623432,18.964838333333336,19.193266666666666,0.12476854687500001,34.348642857142856,32.590314285714285,null,0.5,19.468419582658498,19.216628957995916,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[85,1.0514303022860578,18.737377499999997,18.945821904761903,0.10779291145833333,34.390183333333326,32.608157142857145,null,0.5,19.176447806921885,18.95691265346094,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y73-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[90,1.1575127653780628,18.888692708333338,19.076609999999999,8.4309046874999988E-2,34.496114285714285,32.626157142857146,null,0.5,19.255829927949776,19.072261318141557,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$f":"Y74-273.15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[95,1.0525758129471432,19.118934374999998,19.346704047619049,0.10302920833333336,34.514278571428569,32.644002380952386,null,0.5,19.590944948270476,19.354939661635235,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[100,1.0544254983573973,19.082945208333335,19.337641904761906,0.11270637500000003,34.501740476190477,32.65350476190477,null,0.5,19.625833376522451,19.354389292427893,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"X76","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[105,1.0899851979510684,18.870248750000002,19.105339761904762,0.11292288541666666,34.547690476190468,32.655576190476189,null,0.5,19.372318360780241,19.121283555390121,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"X77","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[110,0.90287501032153528,18.561205000000001,18.798252380952384,0.11242763020833332,34.687776190476185,32.655409523809524,null,0.5,19.067588612228519,18.81439680611426,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[115,1.2401251773114828,18.234966041666667,18.468089523809521,0.11424944270833333,34.81644285714286,32.65168095238095,null,0.5,18.736445200215712,18.485705620941189,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[120,1.1016723139276965,17.899927916666673,18.133355476190474,0.11189357291666666,34.980419047619044,32.642445238095235,null,0.5,18.399641645922827,18.149784781294748,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[125,1.0356555864490935,17.653196041666668,17.855843571428572,0.10577152083333334,35.095150000000004,32.635452380952373,null,0.5,18.080031479276101,17.866613760471385,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[130,1.0584587556574077,17.813083124999999,17.996355952380956,8.7513796875000022E-2,35.15992142857143,32.62757380952381,null,0.5,18.177099097382381,17.99509111119119,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[135,1.0688386253178435,18.161255833333332,18.372566904761907,9.8853052083333365E-2,35.208021428571428,32.623102380952375,null,0.5,18.595850201486826,18.378553017410077,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[140,1.111560774253783,18.224311041666667,18.466574999999999,0.11541712499999998,35.335166666666666,32.622052380952375,null,0.5,18.747145974099112,18.485728507882889,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[145,1.2001460784077418,18.059730625,18.282613333333337,0.11649796875,35.482892857142858,32.624726190476188,null,0.5,18.542705427304838,18.301218026152419,"Category III",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[150,1.2208630241694949,17.7825025,17.977447857142856,0.11464459375,35.53619761904762,32.630973809523809,null,0.5,18.20350907913496,17.99300578956748,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[155,0.98797134064674952,17.48683354166667,17.664806428571428,0.12314005729166666,35.591530952380957,32.64674047619048,null,0.5,17.880937312889785,17.683885427278227,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[160,1.0713394070323858,17.193497916666669,17.382261904761901,0.11735467708333332,35.621654761904765,32.663411904761908,null,0.5,17.6056156238364,17.399556770251536,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[165,1.0839628511401727,17.049961458333335,17.220072142857141,9.9950552083333338E-2,35.557761904761904,32.67664523809524,null,0.5,17.403216858260066,17.226589158296701,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[170,0.99056356927088396,17.281205,17.44578119047619,8.5116604166666679E-2,35.447640476190472,32.682302380952379,null,0.5,17.606329366237048,17.443767183118524,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[175,1.2386712994394016,17.579032708333333,17.787526428571429,9.6055567708333359E-2,35.320283333333329,32.679783333333333,null,0.5,18.005385799065778,17.792209253699554,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[180,1.3143831356375026,17.607373750000004,17.824411190476191,0.113375296875,35.118902380952377,32.665383333333338,null,0.5,18.074778408141015,17.841076079070511,"Category IV",null,null,null,null,"Neutral",null,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]