{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Tool Description","User_Interaction","Cooling Systems Graphs","Cooling System Schematics","Acknowledgments","No Airflow Containment","CAC Airflow","HAC-VED Airflow","CAC and HAC-VED Airflow","Reliability Default Values","Maintenance Default Values","Reliability Customized Values","Maintenance Customized Values","MCDST-Values (3)"],"not_rendered":{"charts":14,"images":29,"macros":1,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Tool Description","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"merged":[[0,1,0,8],[5,2,5,3],[5,5,10,8],[6,2,6,3],[7,2,7,3],[12,1,39,8],[44,1,54,8],[55,1,65,8]]}
[null,"DC-E-WISE (Data Center Energy and Water Information Simulator and Evaluator) "]
[]
[]
[]
[]
[null,null,"Version",null,"2023.V1","Note: The cooling energy and water use for the systems included in this tool were calculated based on our developed 8760 energy and water analysis based on meteorological year (TMY3) weather data for Phoenix-Sky Harbor International Airport (weather station with location code 722780) from the EnergyPlus weather database.Therefore, this version of the MCDST is currently applicable for data centers in Phoenix, AZ. Its application can be extended to other locations within climate type 2B (ASHRAE's classification). "]
[null,null,"Application",null,"Phoenix, AZ"]
[]
[]
[]
[]
[null,"Tool Description"]
[null,"The DC-E-WISE is an excel-based tool that we developed to facilitate the comparison of nine cooling systems based on five main criteria: Energy Use, Onsite Water Use, Total Cooling Water Use, Reliability, and Maintenance. \nThe nine studied cooling systems are: Air-cooled chiller, Air-cooled chiller + Air-side economizer (ASE), Pre-cooled-air-cooled chiller, Pre-cooled-air-cooled chiller + ASE, Water-cooled chiller, Water-cooled chiller + ASE, Water-cooled chiller + Water-side economizer (WSE), Water-cooled chiller + ASE + WSE, and Evaporative cooling system + ASE.\nThe DC-E-WISE tool employs the technique for order preference by similarity to ideal solution (TOPSIS) method to rank the modeled cooling systems. The tool then presents a tabulated list of the ranked cooling systems, which includes energy and water use data, as the result. By utilizing the TOPSIS method, the tool provides a systematic and objective way of comparing and ranking the cooling systems, enabling users to make informed decisions when selecting and optimizing cooling systems for their data centers. The tabulated result provides a concise summary of the ranked cooling systems, allowing users to quickly identify the most efficient and effective options for their specific needs. This tool utilizes modeling data for cooling energy, water use (onsite cooling and humidification), and total cooling water use in DCs located in the greater Phoenix area. The power and water use data, which are model outputs, are normalized based on the modeled IT load (in MW) at the uninterrupted power supply (UPS) output. Therefore, the tool can calculate the total energy and onsite and total cooling water use for a given IT load as entered by the user. Along with overall DC power and water use, the tool provides estimates for key DC metrics including PUE, WUEOnsite, and WUESource."]
{"$rows_empty":30}
[null,"Disclaimer"]
[null,"The DC-E-WISE was prepared as an account of work sponsored by Salt River Project (SRP)."]

{"sheet":"User_Interaction","index":1,"n_rows":125,"n_cols":13,"rows_kept":125}
[]
[]
[{"$nulls":12},"Availability of Cooling System (Percentage of the Year)"]
[{"$nulls":12},{"v":0.5,"d":"50%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[{"$nulls":12},{"v":1,"d":"100%"}]
{"$rows_empty":112}
[{"$nulls":5},{"$f":"_xlfn.RANK.EQ(E125,$E$25:$E$33,0)","v":{"$error":"#N/A"}}]

{"sheet":"Cooling Systems Graphs","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Cooling System Schematics","index":3,"n_rows":1,"n_cols":16377,"rows_kept":1,"merged":[[0,1,0,8],[0,16376,0,16383],[1,1,1048575,8],[1,16376,1048575,16383]]}
[null,"Cooling Systems Schematics ",{"$nulls":16374},"Cooling Systems Modeling Parameters and Assumptions "]

{"sheet":"Acknowledgments","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,2,0,6]]}
[null,null,"Acknowledgments"]
[]
[]
[null,null,"Development Team",null,null,"Sponsor"]
[null,null,"Leila Karimi* (UofA)",null,null,"Salt River Project (SRP): Arizona electric power and water utility company"]
[null,null,"Kerri Hickenbottom (UofA)"]
[null,null,"Reema Shinh (UofA)"]
[null,null,"Leeann Yacuel (SRP)"]
[null,null,"Michael Green (SRP)"]
[null,null,"Jamie Ashby (SRP)"]
[null,null,"Joseph Degraft-Johnson (SRP) "]
[]
[]
[null,null,"Advising and Outreach",null,null,"Contact"]
[null,null,"Colin Laisure-Pool, Central AZ ASHRAE GAC Chair ",null,null,"*Email: lkarimi@arizona.edu "]
[null,null,"Matt Renner, Northshore IO Inc",null,null,"*Phone: (915) 207-0240"]

{"sheet":"No Airflow Containment","index":5,"n_rows":124,"n_cols":29,"rows_kept":124,"merged":[[6,2,6,5],[6,7,6,10],[6,12,6,15],[6,17,6,21],[6,22,6,26],[20,8,20,14],[22,9,22,14],[23,8,28,8],[35,9,35,14]]}
[]
["Airflow Type"]
["Configuration","Selected"]
[]
[]
[]
[null,null,"Parameters Weight Percentage",{"$nulls":4},"Normalized Performance Values (NPVs)",{"$nulls":4},"Weighted Normalized Values(WNVs)",{"$nulls":4},"Ideal Best Value (V-)",{"$nulls":4},"Ideal Worst Value (V-)",{"$nulls":5},"Cooling System Availbility (% of the Year)"]
[null,null,{"v":30.739965311523687,"d":"30.74"},{"v":13.457273703044814,"d":"13.46"},{"v":14.083193410163176,"d":"14.08"},{"v":35.20798352540794,"d":"35.21"},{"v":6.511584049860393,"d":"7"}]
["Cooling System","Paramter Unit","Energy Use (MWh/MW IT Load)","Onsite Water Use (acre-ft/MW IT Load)","Total Cooling Water Use (acre-ft/MW IT Load)","Reliability","Maintenance","NPV_Energy","NPV_Onsite Water","NPV_Source Water","NPV_Reliability","NPV_Maintenance","WNV_Energy","WNV_Onsite Water","WNV_Source Water","WNV_Reliability","WNV_Maintenance","V+_Energy","V+_Onsite Water","V+_Source Water","V+_Reliability","V+_Maintenance","V-_Energy","V-_Onsite Water","V-_Source Water","V-_Reliability","V-_Maintenance"]
["Air-Cooled Chiller ","Parameter Unit/MW IT Load",{"v":3747.04,"d":"3,747.04"},0.003,4.91,"89","81",{"$f":"C10/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.454965964673747},{"$f":"D10/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":7.1885093344824878E-5},{"$f":"E10/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.09821560913459763},{"$f":"F10/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3586689220255373},{"$f":"G10/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.22212130770273764},{"$f":"$C$8/100*H10","v":0.13985637971994894},{"$f":"$D$8/100*I10","v":9.6737737631023362E-6},{"$f":"$E$8/100*J10","v":0.013831894193395275},{"$f":"$F$8/100*K10","v":0.12628009497750942},{"$f":"$G$8/100*L10","v":0.014463615643712789},{"$f":"MIN(M10:M18)","v":0.01627012107789694},{"$f":"MIN(N10:N18)","v":9.6737737631023362E-6},{"$f":"MIN(O10:O18)","v":0.01278675514130777},{"$f":"MAX(P10:P18)","v":0.12628009497750942},{"$f":"MIN(Q10:Q18)","v":0.007321089399904003},{"$f":"MAX(M10:M18)","v":0.13985637971994894},{"$f":"MAX(N10:N18)","v":0.07184389314730669},{"$f":"MAX(O10:O18)","v":0.07363863833306569},{"$f":"MIN(P10:P18)","v":0.08335905145987278},{"$f":"MAX(Q10:Q18)","v":0.029105794443520797},null,100]
["Air-Cooled Chiller+ ASE ","Parameter Unit/MW IT Load",{"v":2866.7657749092236,"d":"2,866.77"},{"v":0.7820356909802254,"d":"0.78"},{"v":4.539,"d":"4.54"},"83.25","100",{"$f":"C11/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.34808298184040115},{"$f":"D11/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":0.018738902881699375},{"$f":"E11/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.0907944297071158},{"$f":"F11/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3354964916699548},{"$f":"G11/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.27422383667004646},0.10700058787305661,{"$f":"$D$8/100*I11","v":0.002521745449738037},{"$f":"$E$8/100*J11","v":0.01278675514130777},{"$f":"$F$8/100*K11","v":0.1181215495154793},{"$f":"$G$8/100*L11","v":0.017856315609521962},{"$nulls":11},100]
["Pre-Cooled-Air-Cooled Chiller","Parameter Unit/MW IT Load",{"v":3440.87,"d":"3,440.87"},{"v":5.968,"d":"5.97"},{"v":10.477,"d":"10.48"},"88","103",{"$f":"C12/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.4177907732148458},0.14300341236063827,0.2095733069049245,{"$f":"F12/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.35463893413760994},0.28245055177014783,0.1284287387609902,0.019244360606064912,0.029514614147495375,{"$f":"$F$8/100*K12","v":0.12486121750585201},{"$f":"$G$8/100*L12","v":0.018392005077807617},{"$nulls":11},100]
["Pre-Cooled-Air-Cooled Chiller +ASE","Parameter Unit/MW IT Load",{"v":2560.072,"d":"2,560.07"},{"v":6.874,"d":"6.87"},{"v":10.139,"d":"10.14"},"82.25","122",0.31084419358059934,0.16471271055077538,{"$f":"E13/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.20281223238608662},0.33146650378202747,0.3345530807374567,0.09555339727956177,0.022165840282521818,0.028562438946402174,0.11670267204382191,0.021784705043616796,{"$nulls":11},100]
["Water-Cooled Chiller","Parameter Unit/MW IT Load",{"v":2947.35,"d":"2,947.35"},22.28,26.14,"88.5","135",0.3578675263624536,0.5338666265742328,0.522883100362196,0.3566539280815736,0.37020217950456275,0.11000835346502613,0.07184389314730669,0.07363863833306569,0.1255706562416807,0.02410602607285465,{"$nulls":11},100]
["Water-Cooled Chiller+ASE","Parameter Unit/MW IT Load",{"v":2240.29,"d":"2,240.29"},15.13,18.07,"82.75","154",{"$f":"C15/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.2720162317453106},0.36254048743573347,0.36145744543017905,0.33348149772599117,0.42230470847187157,0.08361769528022236,0.04878806567857945,0.05090475113536713,0.11741211077965062,0.02749872603866382,{"$nulls":11},100]
["Water-Cooled Chiller+WSE","Parameter Unit/MW IT Load",{"v":2907.27,"d":"2,907.27"},22.19,{"v":26,"d":"26.00"},"86.25","144",0.35300100882751306,0.531710073773888,0.5200826552952217,0.347586455333737,0.3948823248048669,0.10851238766290619,0.07155367993441361,0.07324424623793832,0.12237818193045154,0.025713094477711623,{"$nulls":11},100]
["Water-Cooled Chiller+WSE+ASE","Parameter Unit/MW IT Load",{"v":2240.29,"d":"2,240.29"},15.13,{"v":18.1,"d":"18.10"},"81.5","163",0.2720162317453106,0.36254048743573347,0.36205754080167357,0.32844401286608194,0.4469848537721757,0.08361769528022236,0.04878806567857945,0.05098926372718014,0.11563851394007886,0.029105794443520797,{"$nulls":11},100]
["Evaporative Cooling +ASE","Parameter Unit/MW IT Load",435.91,{"v":14.545,"d":"14.55"},{"v":15.116,"d":"15.12"},{"v":58.75,"d":"59"},"41",{"$f":"C18/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.05292823499640598},0.3485228942334926,0.3023680545170219,0.2367617884157339,{"$f":"G18/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.11243177303471905},0.01627012107789694,0.04690167979477449,0.04258307792817983,0.08335905145987278,0.007321089399904003,{"$nulls":11},50]
[]
[null,"Σparameters' weight",{"$f":"C8+D8+E8+F8+G8","v":{"v":100.00000000000001,"d":"100.00"}}]
[{"$nulls":8},"Parameter Weight Percentage calculation based on entered paramters' importance comparison by user"]
[]
["Cooling System","Distanc from Ideal Best (S+)","Distanc from Ideal Worst (S-)","S++S-","Perfomance Score (PS)","Rank of Cooling Systems",{"$nulls":3},"Parameters"]
["Air-Cooled Chiller ",{"$f":"SQRT(SUM((M10-$R$10)^2+(N10-$S$10)^2+(O10-$T$10)^2+(P10-$U$10)^2+(Q10-$V$10)^2))","v":0.12379689544541038},{"$f":"SQRT(SUM((M10-$W$10)^2+(N10-$X$10)^2+(O10-$Y$10)^2+(P10-$Z$10)^2+(Q10-$AA$10)^2))","v":0.10389230526965311},{"$f":"B24+C24","v":0.2276892007150635},{"$f":"C24/D24","v":0.45628999945266085},{"$f":"_xlfn.RANK.EQ(E24,$E$24:$E$32,0)","v":4},null,null,"Parameters",null,"Energy Usage","Onsite water Use","Total Water Use","Reliability","Maintenance"]
["Air-Cooled Chiller+ ASE ",{"$f":"SQRT(SUM((M11-$R$10)^2+(N11-$S$10)^2+(O11-$T$10)^2+(P11-$U$10)^2+(Q11-$V$10)^2))","v":0.0917381107518388},{"$f":"SQRT(SUM((M11-$W$10)^2+(N11-$X$10)^2+(O11-$Y$10)^2+(P11-$Z$10)^2+(Q11-$AA$10)^2))","v":0.10451314248636784},0.19625125323820664,0.532547643706058,{"$f":"_xlfn.RANK.EQ(E25,$E$24:$E$32,0)","v":2},{"$nulls":3},"Energy Usage",1,"3","2","0.8","5"]
["Pre-Cooled-Air-Cooled Chiller",0.11555919847539929,0.08174011488157891,0.1972993133569782,0.4142949789880142,7,{"$nulls":3},"Onsite water Use",{"$f":"1/L25","v":0.3333333333333333},1,"1","0.5","2"]
["Pre-Cooled-Air-Cooled Chiller +ASE",0.0855951459294942,0.08733797756041527,0.17293312348990947,0.5050390335747991,3,{"$nulls":3},"Total Water Use",{"$f":"1/M25","v":0.5},{"$f":"1/M26","v":1},1,"0.4","1.5"]
["Water-Cooled Chiller",0.13391116598136255,0.05193959889458547,0.185850764875948,0.27946938463909043,8,{"$nulls":3},"Reliability",{"$f":"1/N25","v":1.25},{"$f":"1/N26","v":2},{"$f":"1/N27","v":2.5},1,"6"]
["Water-Cooled Chiller+ASE",0.09409456440422052,0.07330336931404137,0.1673979337182619,0.43789888970442237,5,{"$nulls":3},"Maintenance",{"$f":"1/O25","v":0.2},{"$f":"1/O26","v":0.5},{"$f":"1/O27","v":0.6666666666666666},{"$f":"1/O28","v":0.16666666666666666},1]
["Water-Cooled Chiller+WSE",0.13279977247029898,0.05016660804403308,0.18296638051433206,0.2741848415157529,9]
["Water-Cooled Chiller+WSE+ASE",0.09466929571315517,0.07245218199493805,0.1671214777080932,0.43353004645811244,6,{"$nulls":4},{"$f":"K25/(K25+K26+K27+K28+K29)","v":{"v":0.30456852791878175,"d":"0.30"}},{"$f":"L26/(L25+L26+L27+L28+L29)","v":{"v":0.13333333333333333,"d":"0.13"}},{"$f":"M27/(M25+M26+M27+M28+M29)","v":{"v":0.13953488372093023,"d":"0.14"}},{"$f":"N28/(N25+N26+N27+N28+N29)","v":{"v":0.3488372093023256,"d":"0.35"}},{"$f":"O29/(O25+O26+O27+O28+O29)","v":{"v":0.06451612903225806,"d":"0.06"}}]
["Evaporative Cooling +ASE",0.07020610412875006,{"$f":"SQRT(SUM((M18-$W$10)^2+(N18-$X$10)^2+(O18-$Y$10)^2+(P18-$Z$10)^2+(Q18-$AA$10)^2))","v":0.13166130235556045},0.2018674064843105,0.6522167429034335,1,{"$nulls":3},"Σparameters' weight",{"$f":"K31/(K31+L31+M31+N31+O31)*100","v":{"v":30.739965311523687,"d":"30.74"}},{"$f":"L31/(K31+L31+M31+N31+O31)*100","v":{"v":13.457273703044814,"d":"13.46"}},{"$f":"M31/(K31+L31+M31+N31+O31)*100","v":{"v":14.083193410163176,"d":"14.08"}},{"$f":"N31/(K31+L31+M31+N31+O31)*100","v":{"v":35.20798352540794,"d":"35.21"}},{"$f":"O31/(K31+L31+M31+N31+O31)*100","v":{"v":6.511584049860393,"d":"6.51"}}]
[{"$nulls":10},{"$f":"SUM(K32:O32)","v":{"v":100.00000000000001,"d":"100.00"}}]
[]
["List of Ranked Cooling Systems","Cooling Eneregy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water (acre-ft)","PUE","Onsite WUE (gal/kWh)","Source WUE (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Evaporative Cooling +ASE",4359.1,145.50273580649997,151.21703640549998,1.1959016711707515,0.5410391318493151,1.0516891454392259,50]
["Air-Cooled Chiller+ ASE ",28667.657749092235,7.823192336607041,45.40333820331456,1.4790597849193796,0.02908985296136957,0.6606483811219446,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",25600.72,68.76492306179999,102.3246509026,1.4433345758394682,0.2556963212328767,0.8720001851163296,100]
["Air-Cooled Chiller ",37470.4,0.030010877099999996,49.1495835331,1.5815984841425157,1.1159280821917808E-4,0.6754541455370733,100]
["Water-Cooled Chiller+ASE",22402.9,151.354856841,180.722594422,1.4060847855123784,0.5627997294520548,1.1631979328658404,100]
["Water-Cooled Chiller+WSE+ASE",22402.9,151.354856841,180.722594422,1.4060847855123784,0.5627997294520548,1.1631979328658404,100]
["Pre-Cooled-Air-Cooled Chiller",34408.7,59.7016381776,104.8076589206,1.5459342869567918,0.22199529315068495,0.8821092336812352,100]
["Water-Cooled Chiller",29473.5,222.88078059600002,261.51729701100004,1.488446634361507,0.828762589041096,1.4643293019134593,100]
["Water-Cooled Chiller+WSE",29072.7,221.98045428299997,260.091565986,1.4837779175597179,0.8254148047945205,1.45898797559252,100]
[]
[]
[]
[]
["IT Load (MW)",10]
["Cooling System","Annual Cooling Energy Use (MWh)","Annual IT Energy Use at UPS Outlet (MWh)","Annual IT Energy Use at UPS Inlet (MWh)","Annual Lighting Energy Use  (MWh)","Annual Total Energy Use (MWh)","Total Onsite Water Use (kgal)","Total Cooling Water Use (kgal)","Total Source Water Use (kgal)","PUE","WUEOnsite (gal/kWh)","WUESource  (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Air-Cooled Chiller ",{"v":37470.4,"d":"37,470.40"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":138548.02721088438,"d":"138548.03"},{"v":9.77553,"d":"9.78"},16009.636330000001,{"v":59169.783149047624,"d":"59169.78"},{"v":1.5815984841425157,"d":"1.58"},{"v":1.1159280821917808E-4,"d":"0.00"},0.6754541455370733,100]
["Air-Cooled Chiller+ ASE ",{"v":28667.657749092235,"d":"28,667.66"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":129565.63715893765,"d":"129565.64"},{"v":2548.271119415974,"d":"2548.27"},14789.360978278359,{"v":57872.79818628234,"d":"57872.80"},{"v":1.4790597849193796,"d":"1.48"},{"v":0.02908985296136957,"d":"0.03"},0.6606483811219446,100]
["Pre-Cooled-Air-Cooled Chiller",{"v":34408.7,"d":"34,408.70"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":135423.84353741497,"d":"135423.84"},{"v":19446.78768,"d":"19446.79"},34139.30258,{"v":77272.7688704762,"d":"77272.77"},{"v":1.5459342869567918,"d":"1.55"},{"v":0.22199529315068495,"d":"0.22"},0.8821092336812352,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",{"v":25600.72,"d":"25,600.72"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":126436.10884353741,"d":"126436.11"},{"v":22398.99774,"d":"22399.00"},33330.50518,{"v":76387.21621619047,"d":"76387.22"},{"v":1.4433345758394682,"d":"1.44"},{"v":0.2556963212328767,"d":"0.26"},0.8720001851163296,100]
["Water-Cooled Chiller",{"v":29473.5,"d":"29,473.50"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":130387.92517006802,"d":"130387.93"},{"v":72599.60280000001,"d":"72599.60"},85184.78730000001,{"v":128275.24684761904,"d":"128275.25"},{"v":1.488446634361507,"d":"1.49"},{"v":0.828762589041096,"d":"0.83"},1.4643293019134593,100]
["Water-Cooled Chiller+ASE",{"v":22402.9,"d":"22,402.90"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":123173.02721088435,"d":"123173.03"},{"v":49301.2563,"d":"49301.26"},58867.2946,{"v":101896.13891904762,"d":"101896.14"},{"v":1.4060847855123784,"d":"1.41"},{"v":0.5627997294520548,"d":"0.56"},1.1631979328658404,100]
["Water-Cooled Chiller+WSE",{"v":29072.7,"d":"29,072.70"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":129978.94557823129,"d":"129978.95"},{"v":72306.3369,"d":"72306.34"},84720.3798,{"v":127807.34666190475,"d":"127807.35"},{"v":1.4837779175597179,"d":"1.48"},{"v":0.8254148047945205,"d":"0.83"},1.45898797559252,100]
["Water-Cooled Chiller+WSE+ASE",{"v":22402.9,"d":"22,402.90"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":123173.02721088435,"d":"123173.03"},{"v":49301.2563,"d":"49301.26"},58867.2946,{"v":101896.13891904762,"d":"101896.14"},{"v":1.4060847855123784,"d":"1.41"},{"v":0.5627997294520548,"d":"0.56"},1.1631979328658404,100]
["Evaporative Cooling +ASE",{"v":4359.1,"d":"4,359.10"},{"v":87600,"d":"87600.00"},{"v":97333.33333333333,"d":"97333.33"},{"v":973.3333333333333,"d":"973.33"},{"v":104760.98639455783,"d":"104760.99"},{"v":47395.027949999996,"d":"47395.03"},49256.36365,{"v":92127.96914047618,"d":"92127.97"},{"v":1.1959016711707515,"d":"1.20"},{"v":0.5410391318493151,"d":"0.54"},1.0516891454392259,50]
{"$rows_empty":64}
[{"$nulls":5},{"$f":"_xlfn.RANK.EQ(E124,$E$24:$E$32,0)","v":{"$error":"#N/A"}}]

{"sheet":"CAC Airflow","index":6,"n_rows":124,"n_cols":29,"rows_kept":124,"merged":[[6,2,6,5],[6,7,6,10],[6,12,6,15],[6,17,6,21],[6,22,6,26],[20,8,20,14],[22,9,22,14],[23,8,28,8],[35,9,35,14]]}
[]
["Airflow Type"]
["Configuration"]
[{"$nulls":6},{"v":0,"d":"0.0"}]
[{"$nulls":6},{"v":0,"d":"0.0"}]
[{"$nulls":6},{"v":0,"d":"0.0"}]
[null,null,"Parameters Weight Percentage",{"$nulls":3},{"v":0,"d":"0.0"},"Normalized Performance Values (NPVs)",{"$nulls":4},"Weighted Normalized Values(WNVs)",{"$nulls":4},"Ideal Best Value (V-)",{"$nulls":4},"Ideal Worst Value (V-)",{"$nulls":5},"Cooling System Availbility (% of the Year)"]
[null,null,{"v":30.739965311523687,"d":"30.74"},{"v":13.457273703044814,"d":"13.46"},{"v":14.083193410163176,"d":"14.08"},{"v":35.20798352540794,"d":"35.21"},{"v":6.511584049860393,"d":"6.5"}]
["Cooling System","Paramter Unit","Energy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water Use (acre-ft)","Reliability","Maintenance","NPV_Energy","NPV_Onsite Water","NPV_Source Water","NPV_Reliability","NPV_Maintenance","WNV_Energy","WNV_Onsite Water","WNV_Source Water","WNV_Reliability","WNV_Maintenance","V+_Energy","V+_Onsite Water","V+_Source Water","V+_Reliability","V+_Maintenance","V-_Energy","V-_Onsite Water","V-_Source Water","V-_Reliability","V-_Maintenance"]
["Air-Cooled Chiller ","Parameter Unit/MW IT Load",{"v":3372.82,"d":"3,372.82"},{"v":4.3E-3,"d":"0.00"},4.42,"89","81",{"$f":"C10/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.5763011890862385},{"$f":"D10/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":1.3449009421428681E-4},{"$f":"E10/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.11956836681559856},{"$f":"F10/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3540277179278358},{"$f":"G10/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.22212130770273764},{"$f":"$C$8/100*H10","v":0.17715478561500825},{"$f":"$D$8/100*I10","v":1.8098700081899416E-5},{"$f":"$E$8/100*J10","v":0.016839044356014108},{"$f":"$F$8/100*K10","v":0.12464602060341012},{"$f":"$G$8/100*L10","v":0.014463615643712789},{"$f":"MIN(M10:M18)","v":0.036381052702887884},{"$f":"MIN(N10:N18)","v":1.8098700081899416E-5},{"$f":"MIN(O10:O18)","v":0.015913783442835134},{"$f":"MAX(P10:P18)","v":0.12464602060341012},{"$f":"MIN(Q10:Q18)","v":0.007321089399904003},{"$f":"MAX(M10:M18)","v":0.17715478561500825},{"$f":"MAX(N10:N18)","v":0.08173878036988061},{"$f":"MAX(O10:O18)","v":0.08122362571724452},{"$f":"MIN(P10:P18)","v":0.09978684233699968},{"$f":"MAX(Q10:Q18)","v":0.029105794443520797},null,{"v":100,"d":"100.00"}]
["Air-Cooled Chiller+ ASE ","Parameter Unit/MW IT Load",{"v":1940,"d":"1,940.00"},{"v":1.8583666844808637,"d":"1.86"},{"v":4.4,"d":"4.40"},"83.25","100",{"$f":"C11/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.3314805731783204},{"$f":"D11/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":0.058123700111749575},{"$f":"E11/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.11902733348159132},{"$f":"F11/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3311551406459813},{"$f":"G11/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.27422383667004646},0.10189701320945559,{"$f":"$D$8/100*I11","v":0.007821865410375104},{"$f":"$E$8/100*J11","v":0.016762849585172414},{"$f":"$F$8/100*K11","v":0.11659304736217857},{"$f":"$G$8/100*L11","v":0.017856315609521962},{"$nulls":11},{"v":100,"d":"100.00"}]
["Pre-Cooled-Air-Cooled Chiller","Parameter Unit/MW IT Load",{"v":3146.89,"d":"3,146.89"},{"v":5.268,"d":"5.27"},9.39,"88","103",{"$f":"C12/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.537697371612951},0.1647660037955495,0.25401515031639604,{"$f":"F12/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3500498784005568},0.28245055177014783,0.16528798551479573,0.022173012100336304,0.03577344491017477,{"$f":"$F$8/100*K12","v":0.12324550351797856},{"$f":"$G$8/100*L12","v":0.018392005077807617},{"$nulls":11},{"v":100,"d":"100.00"}]
["Pre-Cooled-Air-Cooled Chiller +ASE","Parameter Unit/MW IT Load",{"v":1744.252,"d":"1,744.25"},{"v":6.089,"d":"6.09"},{"v":8.375,"d":"8.38"},"82.25","122",0.29803384161207824,0.1904442287606494,{"$f":"E13/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.22655770861552893},0.32717730111870225,0.3345530807374567,0.0916154995281543,0.02562860111597338,0.031906560289958856,0.115192530276747,0.021784705043616796,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller","Parameter Unit/MW IT Load",{"v":1452.67,"d":"1,452.67"},19.42,21.32,"88.5","135",0.2482123114633767,0.6073947975910349,0.5767415340517107,0.3520387981641963,0.37020217950456275,0.07630037844277313,0.08173878036988061,0.08122362571724452,0.12394576206069434,0.02410602607285465,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+ASE","Parameter Unit/MW IT Load",{"v":1018.31,"d":"1,018.31"},9.84,11.18,"82.75","154",{"$f":"C15/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.17399483632639973},0.30776337838804235,0.3024376337100434,0.32916622088234176,0.42230470847187157,0.053485952330577693,0.04141656018741633,0.042592876900506275,0.11589278881946279,0.02749872603866382,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+WSE","Parameter Unit/MW IT Load",{"v":1407.98,"d":"1,407.98"},{"v":19.3,"d":"19.30"},21.15,"86.25","144",0.2405762976410369,0.6036415856594733,0.5721427507126492,0.34308865922781845,0.3948823248048669,0.07395307044260273,0.08123370036759504,0.08057597016509013,0.1207945986184733,0.025713094477711623,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+WSE+ASE","Parameter Unit/MW IT Load",{"v":1018.31,"d":"1,018.31"},9.84,11.18,"81.5","163",0.17399483632639973,0.30776337838804235,0.3024376337100434,0.32419392147324294,0.4469848537721757,0.053485952330577693,0.04141656018741633,0.042592876900506275,0.11414214246267332,0.029105794443520797,{"$nulls":11},{"v":100,"d":"100.00"}]
["Evaporative Cooling","Parameter Unit/MW IT Load",{"v":692.6527090497001,"d":"692.65"},{"v":3.2694369530044023,"d":"3.27"},{"v":4.177132700063799,"d":"4.18"},{"v":71.25,"d":"71"},"41",{"$f":"C18/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.11835098814912938},0.1022574148458681,0.11299840156530767,0.2834210663186326,{"$f":"G18/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.11243177303471905},0.036381052702887884,0.013761060197466451,0.015913783442835134,0.09978684233699968,0.007321089399904003,{"$nulls":11},{"v":75,"d":"75.00"}]
[]
[null,"Σparameters' weight",{"$f":"C8+D8+E8+F8+G8","v":{"v":100.00000000000001,"d":"100.00"}}]
[{"$nulls":8},"Parameter Weight Percentage calculation based on entered paramters' importance comparison by user"]
[]
["Cooling System","Distanc from Ideal Best (S+)","Distanc from Ideal Worst (S-)","S++S-","Perfomance Score (PS)","Rank of Cooling Systems",{"$nulls":3},"Parameters"]
["Air-Cooled Chiller ",{"$f":"SQRT(SUM((M10-$R$10)^2+(N10-$S$10)^2+(O10-$T$10)^2+(P10-$U$10)^2+(Q10-$V$10)^2))","v":0.14095785067499417},{"$f":"SQRT(SUM((M10-$W$10)^2+(N10-$X$10)^2+(O10-$Y$10)^2+(P10-$Z$10)^2+(Q10-$AA$10)^2))","v":0.10796303197726616},{"$f":"B24+C24","v":0.2489208826522603},{"$f":"C24/D24","v":0.43372428551159087},{"$f":"_xlfn.RANK.EQ(E24,$E$24:$E$32,0)","v":8},null,null,"Parameters",null,"Energy Usage","Onsite water Use","Total Water Use","Reliability","Maintenance"]
["Air-Cooled Chiller+ ASE ",{"$f":"SQRT(SUM((M11-$R$10)^2+(N11-$S$10)^2+(O11-$T$10)^2+(P11-$U$10)^2+(Q11-$V$10)^2))","v":0.06730380478541087},{"$f":"SQRT(SUM((M11-$W$10)^2+(N11-$X$10)^2+(O11-$Y$10)^2+(P11-$Z$10)^2+(Q11-$AA$10)^2))","v":0.12526625078412296},0.19257005556953383,0.6504970381487553,{"$f":"_xlfn.RANK.EQ(E25,$E$24:$E$32,0)","v":4},{"$nulls":3},"Energy Usage",1,"3","2","0.8","5"]
["Pre-Cooled-Air-Cooled Chiller",0.13276584760546542,0.08012312210923649,0.2128889697147019,0.37636107787365214,9,{"$nulls":3},"Onsite water Use",{"$f":"1/L25","v":0.3333333333333333},1,"1","0.5","2"]
["Pre-Cooled-Air-Cooled Chiller +ASE",0.06527691412907652,0.11484088206475812,0.18011779619383464,0.637587648147613,5,{"$nulls":3},"Total Water Use",{"$f":"1/M25","v":0.5},{"$f":"1/M26","v":1},1,"0.4","1.5"]
["Water-Cooled Chiller",0.1132228878767605,0.10382804309067578,0.21705093096743627,0.47835797168846467,7,{"$nulls":3},"Reliability",{"$f":"1/N25","v":1.25},{"$f":"1/N26","v":2},{"$f":"1/N27","v":2.5},1,"6"]
["Water-Cooled Chiller+ASE",0.05658569005944997,0.13665350599772838,0.19323919605717835,0.7071728137250861,2,{"$nulls":3},"Maintenance",{"$f":"1/O25","v":0.2},{"$f":"1/O26","v":0.5},{"$f":"1/O27","v":0.6666666666666666},{"$f":"1/O28","v":0.16666666666666666},1]
["Water-Cooled Chiller+WSE",0.11199075035484643,0.10537601631817867,0.2173667666730251,0.4847843942799729,6]
["Water-Cooled Chiller+WSE+ASE",0.05747250701289824,0.13644878585834136,0.1939212928712396,0.703629724400306,3,{"$nulls":4},{"$f":"K25/(K25+K26+K27+K28+K29)","v":0.30456852791878175},{"$f":"L26/(L25+L26+L27+L28+L29)","v":0.13333333333333333},{"$f":"M27/(M25+M26+M27+M28+M29)","v":0.13953488372093023},{"$f":"N28/(N25+N26+N27+N28+N29)","v":0.3488372093023256},{"$f":"O29/(O25+O26+O27+O28+O29)","v":0.06451612903225806}]
["Evaporative Cooling +ASE",0.028405065301804318,{"$f":"SQRT(SUM((M18-$W$10)^2+(N18-$X$10)^2+(O18-$Y$10)^2+(P18-$Z$10)^2+(Q18-$AA$10)^2))","v":0.1708161678225971},0.1992212331244014,0.857419488594034,1,{"$nulls":3},"Σparameters' weight",{"$f":"K31/(K31+L31+M31+N31+O31)*100","v":30.739965311523687},{"$f":"L31/(K31+L31+M31+N31+O31)*100","v":13.457273703044814},{"$f":"M31/(K31+L31+M31+N31+O31)*100","v":14.083193410163176},{"$f":"N31/(K31+L31+M31+N31+O31)*100","v":35.20798352540794},{"$f":"O31/(K31+L31+M31+N31+O31)*100","v":6.511584049860393}]
[{"$nulls":10},{"$f":"SUM(K32:O32)","v":{"v":100.00000000000001,"d":"100.00000000"}}]
[]
["List of Ranked Cooling Systems","Cooling Eneregy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water (acre-ft)","PUE","Onsite WUE (gal/kWh)","Source WUE (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Evaporative Cooling +ASE",69265.27090497,327.06223527604527,417.86138625266136,1.2258083328343545,0.12161521696043807,0.6450353750807074,75]
["Water-Cooled Chiller+ASE",101831,984.35676888,1117.84600847,1.263742506134874,0.36602441095890415,0.9056424610784953,100]
["Water-Cooled Chiller+WSE+ASE",101831,984.35676888,1117.84600847,1.263742506134874,0.36602441095890415,0.9056424610784953,100]
["Air-Cooled Chiller+ ASE ",194000,185.90404724896558,440.2167072489655,1.371105519833504,0.06912678567406096,0.6545888426429671,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",174425.19999999998,609.1207688730001,837.773019301,1.3483038238126297,0.22649620308219182,0.8022219358501848,100]
["Water-Cooled Chiller+WSE",140798,1930.6997601,2115.2704503200002,1.3091331966576583,0.7179137328767123,1.2769136078495325,100]
["Water-Cooled Chiller",145267,1942.7041109400002,2133.13316857,1.3143389090796134,0.7223774452054795,1.2836001593824744,100]
["Air-Cooled Chiller ",337282,0.43015590509999996,442.56975688509993,1.5380074860994626,1.5994969178082191E-4,0.6568891462562513,100]
["Pre-Cooled-Air-Cooled Chiller",314689,526.9910018759999,939.513665086,1.5116900413133287,0.1959569712328767,0.8414486188736681,100]
[]
[]
[]
[]
["IT Load (MW)",100]
["Cooling System","Annual Cooling Energy Use (MWh)","Annual IT Energy Use at UPS Outlet (MWh)","Annual IT Energy Use at UPS Inlet (MWh)","Annual Lighting Energy Use  (MWh)","Annual Total Energy Use (MWh)","Total Onsite Water Use (kgal)","Total Cooling Water Use (kgal)","Total Source Water Use (kgal)","PUE","WUEOnsite (gal/kWh)","WUESource  (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Air-Cooled Chiller ",{"v":337282,"d":"337,282.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1347294.5578231292,"d":"1347294.56"},{"v":140.11593,"d":"140.12"},144159.52993,{"v":575434.8921204761,"d":"575434.89"},{"v":1.5380074860994626,"d":"1.54"},{"v":1.5994969178082191E-4,"d":"0.00"},0.6568891462562513,100]
["Air-Cooled Chiller+ ASE ",{"v":194000,"d":"194,000.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1201088.4353741496,"d":"1201088.44"},{"v":60555.06425047739,"d":"60555.06"},143393.0642504774,{"v":573419.8261552393,"d":"573419.83"},{"v":1.371105519833504,"d":"1.37"},{"v":0.06912678567406096,"d":"0.07"},0.6545888426429671,100]
["Pre-Cooled-Air-Cooled Chiller",{"v":314689,"d":"314,689.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1324240.476190476,"d":"1324240.48"},{"v":171658.3068,"d":"171658.31"},306030.5098,{"v":737108.9901333333,"d":"737108.99"},{"v":1.5116900413133287,"d":"1.51"},{"v":0.1959569712328767,"d":"0.20"},0.8414486188736681,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",{"v":174425.19999999998,"d":"174,425.20"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1181114.1496598637,"d":"1181114.15"},{"v":198410.67390000002,"d":"198410.67"},272890.2343,{"v":702746.4158047618,"d":"702746.42"},{"v":1.3483038238126297,"d":"1.35"},{"v":0.22649620308219182,"d":"0.23"},0.8022219358501848,100]
["Water-Cooled Chiller",{"v":145267,"d":"145,267.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1151360.8843537413,"d":"1151360.88"},{"v":632802.6420000001,"d":"632802.64"},694831.6510000001,{"v":1124433.7396190476,"d":"1124433.74"},{"v":1.3143389090796134,"d":"1.31"},{"v":0.7223774452054795,"d":"0.72"},1.2836001593824744,100]
["Water-Cooled Chiller+ASE",{"v":101831,"d":"101,831.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1107038.4353741496,"d":"1107038.44"},{"v":320637.384,"d":"320637.38"},364119.221,{"v":793342.7959047619,"d":"793342.80"},{"v":1.263742506134874,"d":"1.26"},{"v":0.36602441095890415,"d":"0.37"},0.9056424610784953,100]
["Water-Cooled Chiller+WSE",{"v":140798,"d":"140,798.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1146800.6802721086,"d":"1146800.68"},628892.43,689013.1760000001,{"v":1118576.3204761904,"d":"1118576.32"},{"v":1.3091331966576583,"d":"1.31"},{"v":0.7179137328767123,"d":"0.72"},1.2769136078495325,100]
["Water-Cooled Chiller+WSE+ASE",{"v":101831,"d":"101,831.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1107038.4353741496,"d":"1107038.44"},{"v":320637.384,"d":"320637.38"},364119.221,{"v":793342.7959047619,"d":"793342.80"},{"v":1.263742506134874,"d":"1.26"},{"v":0.36602441095890415,"d":"0.37"},0.9056424610784953,100]
["Evaporative Cooling +ASE",{"v":69265.27090497,"d":"69,265.27"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1073808.0995628946,"d":"1073808.10"},{"v":106534.93005734375,"d":"106534.93"},136111.20073376593,{"v":565050.9885706997,"d":"565050.99"},{"v":1.2258083328343545,"d":"1.23"},{"v":0.12161521696043807,"d":"0.12"},0.6450353750807074,75]
{"$rows_empty":64}
[{"$nulls":5},{"$f":"_xlfn.RANK.EQ(E124,$E$24:$E$32,0)","v":{"$error":"#N/A"}}]

{"sheet":"HAC-VED Airflow","index":7,"n_rows":124,"n_cols":29,"rows_kept":124,"merged":[[6,2,6,5],[6,7,6,10],[6,12,6,15],[6,17,6,21],[6,22,6,26],[20,8,20,14],[22,9,22,14],[23,8,28,8],[35,9,35,14]]}
[]
["Airflow Type"]
["Configuration"]
[]
[]
[]
[null,null,"Parameters Weight Percentage",{"$nulls":4},"Normalized Performance Values (NPVs)",{"$nulls":4},"Weighted Normalized Values(WNVs)",{"$nulls":4},"Ideal Best Value (V-)",{"$nulls":4},"Ideal Worst Value (V-)",{"$nulls":5},"Cooling System Availbility (% of the Year)"]
[null,null,{"v":30.739965311523687,"d":"30.74"},{"v":13.457273703044814,"d":"13.46"},{"v":14.083193410163176,"d":"14.08"},{"v":35.20798352540794,"d":"35.21"},{"v":6.511584049860393,"d":"6.51"}]
["Cooling System","Paramter Unit","Energy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water Use (acre-ft)","Reliability","Maintenance","NPV_Energy","NPV_Onsite Water","NPV_Source Water","NPV_Reliability","NPV_Maintenance","WNV_Energy","WNV_Onsite Water","WNV_Source Water","WNV_Reliability","WNV_Maintenance","V+_Energy","V+_Onsite Water","V+_Source Water","V+_Reliability","V+_Maintenance","V-_Energy","V-_Onsite Water","V-_Source Water","V-_Reliability","V-_Maintenance"]
["Air-Cooled Chiller ","Parameter Unit/MW IT Load",{"v":3079.35,"d":"3,079.35"},{"v":0.007,"d":"0.01"},4.04,"89","81",{"$f":"C10/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.6009131384425602},{"$f":"D10/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":2.289366533607233E-4},{"$f":"E10/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.10075906718441818},{"$f":"F10/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3496120375134334},{"$f":"G10/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.22212130770273764},{"$f":"$C$8/100*H10","v":0.18472049030963134},{"$f":"$D$8/100*I10","v":3.080863204934348E-5},{"$f":"$E$8/100*J10","v":0.014190094309857867},{"$f":"$F$8/100*K10","v":0.12309134857057265},{"$f":"$G$8/100*L10","v":0.014463615643712789},{"$f":"MIN(M10:M18)","v":0.04187165665240395},{"$f":"MIN(N10:N18)","v":3.080863204934348E-5},{"$f":"MIN(O10:O18)","v":0.014190094309857867},{"$f":"MAX(P10:P18)","v":0.12309134857057265},{"$f":"MIN(Q10:Q18)","v":0.007321089399904003},{"$f":"MAX(M10:M18)","v":0.18472049030963134},{"$f":"MAX(N10:N18)","v":0.08498781212468894},{"$f":"MAX(O10:O18)","v":0.07425212715603845},{"$f":"MIN(P10:P18)","v":0.1127184821179963},{"$f":"MAX(Q10:Q18)","v":0.029105794443520797},null,{"v":100,"d":"100.00"}]
["Air-Cooled Chiller+ ASE ","Parameter Unit/MW IT Load",{"v":1328.13,"d":"1,328.13"},{"v":3.062727539268556,"d":"3.06"},{"v":4.803,"d":"4.80"},"83.25","100",{"$f":"C11/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.2591750747916663},{"$f":"D11/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":0.10016722757083805},{"$f":"E11/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.11978856427890111},{"$f":"F11/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.32702474295498124},{"$f":"G11/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.27422383667004646},{"$f":"$C$8/100*H11","v":0.07967032808707379},{"$f":"$D$8/100*I11","v":0.013479777974959445},{"$f":"$E$8/100*J11","v":0.01687005519065528},{"$f":"$F$8/100*K11","v":0.11513881762359746},{"$f":"$G$8/100*L11","v":0.017856315609521962},{"$nulls":11},{"v":100,"d":"100.00"}]
["Pre-Cooled-Air-Cooled Chiller","Parameter Unit/MW IT Load",{"v":2908.010826925907,"d":"2,908.01"},{"v":5.271,"d":"5.27"},9.081,"88","103",{"$f":"C12/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.5674775237088969},0.17238929998062463,0.22648343789646075,{"$f":"F12/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.345683812372833},0.28245055177014783,0.17444239393880853,0.023198899933155638,0.03189610060094537,{"$f":"$F$8/100*K12","v":0.12170829971022913},{"$f":"$G$8/100*L12","v":0.018392005077807617},{"$nulls":11},{"v":100,"d":"100.00"}]
["Pre-Cooled-Air-Cooled Chiller +ASE","Parameter Unit/MW IT Load",{"v":1223.2283122941562,"d":"1,223.23"},{"v":5.554,"d":"5.55"},{"v":7.157,"d":"7.16"},"82.25","122",0.23870426037068787,0.18164488182363675,0.17849817916803984,0.32309651781438087,0.3345530807374567,0.07337760683507863,0.024444448914579097,0.025138243805854645,0.11375576876325394,0.021784705043616796,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller","Parameter Unit/MW IT Load",{"v":1398.77,"d":"1,398.77"},19.31,21.14,"88.5","135",0.27295996579125464,0.6315381109136524,0.5272392772966833,0.3476479249431332,0.37020217950456275,0.0839077987985786,0.08498781212468894,0.07425212715603845,0.12239982414040088,0.02410602607285465,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+ASE","Parameter Unit/MW IT Load",{"v":864.1,"d":"864.10"},7.46,8.59,"82.75","154",{"$f":"C15/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.1686229376096307},0.24398106201014227,0.21423771958271093,0.325060630384681,0.42230470847187157,0.05183463252847271,0.032833199298300336,0.030171512406356207,0.11444729319342568,0.02749872603866382,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+WSE","Parameter Unit/MW IT Load",{"v":1268.97,"d":"1,268.97"},19.03,20.69,"86.25","144",0.2476304237223621,0.6223806447792235,0.5160161138726763,0.33880941837678236,0.3948823248048669,0.07612150635303323,0.0837554668427152,0.07267154734429686,0.11928796420462799,0.025713094477711623,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+WSE+ASE","Parameter Unit/MW IT Load",{"v":864.089,"d":"864.09"},7.46,8.59,"81.5","163",0.16862079103826896,0.24398106201014227,0.21423771958271093,0.3201503489589306,0.4469848537721757,0.05183397267318072,0.032833199298300336,0.030171512406356207,0.1127184821179963,0.029105794443520797,{"$nulls":11},{"v":100,"d":"100.00"}]
["Evaporative Cooling +ASE","Parameter Unit/MW IT Load",{"v":698.0139869510583,"d":"698.01"},{"v":4.535378104445947,"d":"4.54"},{"v":20.29855653504064,"d":"20.30"},{"v":81.75,"d":"82"},"41",{"$f":"C18/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.1362124395004026},0.14833061213676516,0.5062533716982353,0.32113240524408065,{"$f":"G18/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.11243177303471905},0.04187165665240395,0.019961256460646296,0.07129664148173476,0.11306424433308217,0.007321089399904003,{"$nulls":11},{"v":96,"d":"96.00"}]
[]
[null,"Σparameters' weight",{"$f":"C8+D8+E8+F8+G8","v":{"v":100.00000000000001,"d":"100.00"}}]
[{"$nulls":8},"Parameter Weight Percentage calculation based on entered paramters' importance comparison by user"]
[]
["Cooling System","Distanc from Ideal Best (S+)","Distanc from Ideal Worst (S-)","S++S-","Perfomance Score (PS)","Rank of Cooling Systems",{"$nulls":3},"Parameters"]
["Air-Cooled Chiller ",{"$f":"SQRT(SUM((M10-$R$10)^2+(N10-$S$10)^2+(O10-$T$10)^2+(P10-$U$10)^2+(Q10-$V$10)^2))","v":0.143027287460728},{"$f":"SQRT(SUM((M10-$W$10)^2+(N10-$X$10)^2+(O10-$Y$10)^2+(P10-$Z$10)^2+(Q10-$AA$10)^2))","v":0.10557996964629504},{"$f":"B24+C24","v":0.24860725710702303},{"$f":"C24/D24","v":0.42468579105413595},{"$f":"_xlfn.RANK.EQ(E24,$E$24:$E$32,0)","v":8},null,null,"Parameters",null,"Energy Usage","Onsite water Use","Total Water Use","Reliability","Maintenance"]
["Air-Cooled Chiller+ ASE ",{"$f":"SQRT(SUM((M11-$R$10)^2+(N11-$S$10)^2+(O11-$T$10)^2+(P11-$U$10)^2+(Q11-$V$10)^2))","v":0.04232056555252641},{"$f":"SQRT(SUM((M11-$W$10)^2+(N11-$X$10)^2+(O11-$Y$10)^2+(P11-$Z$10)^2+(Q11-$AA$10)^2))","v":0.13990727826664776},0.18222784381917417,0.7677601585709296,{"$f":"_xlfn.RANK.EQ(E25,$E$24:$E$32,0)","v":3},{"$nulls":3},"Energy Usage",1,"3","2","0.8","5"]
["Pre-Cooled-Air-Cooled Chiller",0.1361974357176914,0.07689697018264875,0.21309440590034018,0.3608586994940255,9,{"$nulls":3},"Onsite water Use",{"$f":"1/L25","v":0.3333333333333333},1,"1","0.5","2"]
["Pre-Cooled-Air-Cooled Chiller +ASE",0.04477568462874133,0.13612341598909566,0.18089910061783698,0.7524825470341429,4,{"$nulls":3},"Total Water Use",{"$f":"1/M25","v":0.5},{"$f":"1/M26","v":1},1,"0.4","1.5"]
["Water-Cooled Chiller",0.11346536821316863,0.10139982661137925,0.21486519482454788,0.4719229966220408,7,{"$nulls":3},"Reliability",{"$f":"1/N25","v":1.25},{"$f":"1/N26","v":2},{"$f":"1/N27","v":2.5},1,"6"]
["Water-Cooled Chiller+ASE",0.04373236970245917,0.1494236490339034,0.19315601873636257,0.7735904374683287,1,{"$nulls":3},"Maintenance",{"$f":"1/O25","v":0.2},{"$f":"1/O26","v":0.5},{"$f":"1/O27","v":0.6666666666666666},{"$f":"1/O28","v":0.16666666666666666},1]
["Water-Cooled Chiller+WSE",0.1093420437409372,0.10886884187767093,0.21821088561860813,0.4989157235168979,6]
["Water-Cooled Chiller+WSE+ASE",0.04486446289185492,0.1494055916133098,0.1942700545051647,0.7690613563365105,2,{"$nulls":4},{"$f":"K25/(K25+K26+K27+K28+K29)","v":0.30456852791878175},{"$f":"L26/(L25+L26+L27+L28+L29)","v":0.13333333333333333},{"$f":"M27/(M25+M26+M27+M28+M29)","v":0.13953488372093023},{"$f":"N28/(N25+N26+N27+N28+N29)","v":0.3488372093023256},{"$f":"O29/(O25+O26+O27+O28+O29)","v":0.06451612903225806}]
["Evaporative Cooling +ASE",0.06131005871740562,{"$f":"SQRT(SUM((M18-$W$10)^2+(N18-$X$10)^2+(O18-$Y$10)^2+(P18-$Z$10)^2+(Q18-$AA$10)^2))","v":0.15848555151709204},0.21979561023449767,0.7210587661327968,5,{"$nulls":3},"Σparameters' weight",{"$f":"K31/(K31+L31+M31+N31+O31)*100","v":30.739965311523687},{"$f":"L31/(K31+L31+M31+N31+O31)*100","v":13.457273703044814},{"$f":"M31/(K31+L31+M31+N31+O31)*100","v":14.083193410163176},{"$f":"N31/(K31+L31+M31+N31+O31)*100","v":35.20798352540794},{"$f":"O31/(K31+L31+M31+N31+O31)*100","v":6.511584049860393}]
[{"$nulls":10},{"$f":"SUM(K32:O32)","v":{"v":100.00000000000001,"d":"100.00000000"}}]
[]
["List of Ranked Cooling Systems","Cooling Eneregy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water (acre-ft)","PUE","Onsite WUE (gal/kWh)","Source WUE (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Water-Cooled Chiller+ASE",86410,746.27047722,859.5444821199999,1.2457793619730997,0.27749411643835614,0.8094419040008697,100]
["Water-Cooled Chiller+WSE+ASE",86408.90000000001,746.27047722,859.543040141,1.245778080638648,0.27749411643835614,0.8094413568710589,100]
["Air-Cooled Chiller+ ASE ",132813,306.3837992392468,480.4870328092468,1.2998318733886247,0.11392612230573036,0.6689543322426731,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",122322.83122941562,555.601371378,715.9531476083285,1.2876124055261418,0.20659548561643834,0.7564059827761008,100]
["Evaporative Cooling +ASE",69801.39869510583,453.7022496485276,545.2042051839549,1.2264328410234047,0.16870519300363201,0.6923920161206257,96]
["Water-Cooled Chiller+WSE",126897,1903.68997071,2070.0379790399998,1.2929406237380794,0.7078703801369863,1.2599560264731462,100]
["Water-Cooled Chiller",139877,1931.7001226699997,2115.0634832,1.3080603702668279,0.7182857089041096,1.276827487008045,100]
["Air-Cooled Chiller ",307935,0.7002537990000001,404.369165949,1.5038226477805734,2.603832191780822E-4,0.6423926538214829,100]
["Pre-Cooled-Air-Cooled Chiller",290801.0826925907,527.291110647,908.4993419378902,1.483864212747248,0.1960685640410959,0.8296785828841707,100]
[]
[]
[]
[]
["IT Load (MW)",100]
["Cooling System","Annual Cooling Energy Use (MWh)","Annual IT Energy Use at UPS Outlet (MWh)","Annual IT Energy Use at UPS Inlet (MWh)","Annual Lighting Energy Use  (MWh)","Annual Total Energy Use (MWh)","Total Onsite Water Use (kgal)","Total Cooling Water Use (kgal)","Total Source Water Use (kgal)","PUE","WUEOnsite (gal/kWh)","WUESource  (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Air-Cooled Chiller ",{"v":307935,"d":"307,935.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1317348.6394557822,"d":"1317348.64"},{"v":228.09570000000002,"d":"228.10"},131716.3407,{"v":562735.964747619,"d":"562735.96"},{"v":1.5038226477805734,"d":"1.50"},{"v":2.603832191780822E-4,"d":"0.00"},0.6423926538214829,100]
["Air-Cooled Chiller+ ASE ",{"v":132813,"d":"132,813.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1138652.7210884353,"d":"1138652.72"},{"v":99799.2831398198,"d":"99799.28"},156510.43413981982,{"v":586003.9950445816,"d":"586004.00"},{"v":1.2998318733886247,"d":"1.30"},{"v":0.11392612230573036,"d":"0.11"},0.6689543322426731,100]
["Pre-Cooled-Air-Cooled Chiller",{"v":290801.0826925907,"d":"290,801.08"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1299865.050366589,"d":"1299865.05"},{"v":171756.0621,"d":"171756.06"},295928.12440973625,{"v":726798.4386065336,"d":"726798.44"},{"v":1.483864212747248,"d":"1.48"},{"v":0.1960685640410959,"d":"0.20"},0.8296785828841707,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",{"v":122322.83122941562,"d":"122,322.83"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1127948.4672409003,"d":"1127948.47"},{"v":180977.64539999998,"d":"180977.65"},233209.49433496044,{"v":662611.6409118643,"d":"662611.64"},{"v":1.2876124055261418,"d":"1.29"},{"v":0.20659548561643834,"d":"0.21"},0.7564059827761008,100]
["Water-Cooled Chiller",{"v":139877,"d":"139,877.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1145860.8843537413,"d":"1145860.88"},{"v":629218.281,"d":"629218.28"},688945.76,{"v":1118500.8786190473,"d":"1118500.88"},{"v":1.3080603702668279,"d":"1.31"},{"v":0.7182857089041096,"d":"0.72"},1.276827487008045,100]
["Water-Cooled Chiller+ASE",{"v":86410,"d":"86,410.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1091302.7210884353,"d":"1091302.72"},{"v":243084.846,"d":"243084.85"},279981.91599999997,{"v":709071.1079047618,"d":"709071.11"},{"v":1.2457793619730997,"d":"1.25"},{"v":0.27749411643835614,"d":"0.28"},0.8094419040008697,100]
["Water-Cooled Chiller+WSE",{"v":126897,"d":"126,897.00"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1132615.9863945576,"d":"1132615.99"},{"v":620094.453,"d":"620094.45"},674279.472,{"v":1103721.479190476,"d":"1103721.48"},{"v":1.2929406237380794,"d":"1.29"},{"v":0.7078703801369863,"d":"0.71"},1.2599560264731462,100]
["Water-Cooled Chiller+WSE+ASE",{"v":86408.90000000001,"d":"86,408.90"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1091301.5986394556,"d":"1091301.60"},{"v":243084.846,"d":"243084.85"},279981.4463,{"v":709070.6286190476,"d":"709070.63"},{"v":1.245778080638648,"d":"1.25"},{"v":0.27749411643835614,"d":"0.28"},0.8094413568710589,100]
["Evaporative Cooling +ASE",{"v":69801.39869510583,"d":"69,801.40"},{"v":876000,"d":"876000.00"},{"v":973333.3333333333,"d":"973333.33"},{"v":9733.333333333332,"d":"9733.33"},{"v":1074355.1687365025,"d":"1074355.17"},{"v":147785.74907118164,"d":"147785.75"},177590.94631399182,{"v":606535.4061216682,"d":"606535.41"},{"v":1.2264328410234047,"d":"1.23"},{"v":0.16870519300363201,"d":"0.17"},0.6923920161206257,96]
{"$rows_empty":64}
[{"$nulls":5},{"$f":"_xlfn.RANK.EQ(E124,$E$24:$E$32,0)","v":{"$error":"#N/A"}}]

{"sheet":"CAC and HAC-VED Airflow","index":8,"n_rows":124,"n_cols":29,"rows_kept":124,"merged":[[6,2,6,5],[6,7,6,10],[6,12,6,15],[6,17,6,21],[6,22,6,26],[20,8,20,14],[22,9,22,14],[23,8,28,8],[35,9,35,14]]}
[]
["Airflow Type"]
["Configuration"]
[]
[]
[]
[null,null,"Parameters Weight Percentage",{"$nulls":4},"Normalized Performance Values (NPVs)",{"$nulls":4},"Weighted Normalized Values(WNVs)",{"$nulls":4},"Ideal Best Value (V-)",{"$nulls":4},"Ideal Worst Value (V-)",{"$nulls":5},"Cooling System Availbility (% of the Year)"]
[null,null,"20","30","10","30","10"]
["Cooling System","Paramter Unit","Energy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water Use (acre-ft)","Reliability","Maintenance","NPV_Energy","NPV_Onsite Water","NPV_Source Water","NPV_Reliability","NPV_Maintenance","WNV_Energy","WNV_Onsite Water","WNV_Source Water","WNV_Reliability","WNV_Maintenance","V+_Energy","V+_Onsite Water","V+_Source Water","V+_Reliability","V+_Maintenance","V-_Energy","V-_Onsite Water","V-_Source Water","V-_Reliability","V-_Maintenance"]
["Air-Cooled Chiller ","Parameter Unit/MW IT Load",{"v":2963.591900696844,"d":"2,963.59"},{"v":0.0062,"d":"0.01"},3.89,"89","81",{"$f":"C10/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.6173095929213128},{"$f":"D10/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":1.8179991459545095E-4},{"$f":"E10/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.10260096956347296},{"$f":"F10/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3491691543414809},{"$f":"G10/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.22212130770273764},{"$f":"$C$8/100*H10","v":0.12346191858426257},{"$f":"$D$8/100*I10","v":5.4539974378635286E-5},{"$f":"$E$8/100*J10","v":0.010260096956347296},{"$f":"$F$8/100*K10","v":0.10475074630244426},{"$f":"$G$8/100*L10","v":0.022212130770273765},{"$f":"MIN(M10:M18)","v":0.025206405124562944},{"$f":"MIN(N10:N18)","v":5.4539974378635286E-5},{"$f":"MIN(O10:O18)","v":0.010260096956347296},{"$f":"MAX(P10:P18)","v":0.10475074630244426},{"$f":"MIN(Q10:Q18)","v":0.011243177303471906},{"$f":"MAX(M10:M18)","v":0.12346191858426257},{"$f":"MAX(N10:N18)","v":0.16713863116033395},{"$f":"MAX(O10:O18)","v":0.054175421975160266},{"$f":"MIN(P10:P18)","v":0.0959234362207776},{"$f":"MAX(Q10:Q18)","v":0.04469848537721757},null,{"v":100,"d":"100.00"}]
["Air-Cooled Chiller+ ASE ","Parameter Unit/MW IT Load",{"v":1164.8133797187402,"d":"1,164.81"},{"v":3.0789854139648583,"d":"3.08"},{"v":4.605,"d":"4.61"},"83.25","100",{"$f":"C11/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.24262803292666585},{"$f":"D11/SQRT(SUM($D$10^2+$D$11^2+$D$12^2+$D$13^2+$D$14^2+$D$15^2+$D$16^2+$D$17^2+$D$18^2))","v":0.09028375569345976},{"$f":"E11/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.12145950252950978},{"$f":"F11/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.32661047302166607},{"$f":"G11/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.27422383667004646},0.04852560658533317,{"$f":"$D$8/100*I11","v":0.027085126708037924},{"$f":"$E$8/100*J11","v":0.012145950252950979},{"$f":"$F$8/100*K11","v":0.09798314190649982},{"$f":"$G$8/100*L11","v":0.027422383667004648},{"$nulls":11},{"v":100,"d":"100.00"}]
["Pre-Cooled-Air-Cooled Chiller","Parameter Unit/MW IT Load",{"v":2798.2163384740443,"d":"2,798.22"},5.27,{"v":8.937,"d":"8.94"},"88","103",{"$f":"C12/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.5828622316058478},0.1545299274061333,0.2357184742901691,{"$f":"F12/SQRT(SUM($F$10^2+$F$11^2+$F$12^2+$F$13^2+$F$14^2+$F$15^2+$F$16^2+$F$17^2+$F$18^2))","v":0.3452459054162957},0.28245055177014783,0.11657244632116957,0.04635897822183999,0.023571847429016912,{"$f":"$F$8/100*K12","v":0.1035737716248887},{"$f":"$G$8/100*L12","v":0.028245055177014783},{"$nulls":11},{"v":100,"d":"100.00"}]
["Pre-Cooled-Air-Cooled Chiller +ASE","Parameter Unit/MW IT Load",{"v":1074.7173815091553,"d":"1,074.72"},{"v":5.238,"d":"5.24"},6.65,"82.25","122",0.22386123714566758,0.15359160526628585,{"$f":"E13/SQRT(SUM($E$10^2+$E$11^2+$E$12^2+$E$13^2+$E$14^2+$E$15^2+$E$16^2+$E$17^2+$E$18^2))","v":0.17539754436943322},0.32268722409648093,0.3345530807374567,0.04477224742913352,0.046077481579885754,0.017539754436943323,0.09680616722894428,0.03345530807374567,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller","Parameter Unit/MW IT Load",{"v":1173.66,"d":"1,173.66"},{"v":19,"d":"19.00"},20.54,"88.5","135",0.244470764229606,0.5571287705344465,0.5417542197516027,0.34720752987888825,0.37020217950456275,0.048894152845921204,0.16713863116033395,0.054175421975160266,0.10416225896366647,0.03702021795045628,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+ASE","Parameter Unit/MW IT Load",764.07,6.94,7.94,"82.75","154",{"$f":"C15/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.15915407939685688},0.20349861407942416,0.20942203042004506,0.3246488485590735,0.42230470847187157,0.03183081587937138,0.061049584223827245,0.020942203042004507,0.09739465456772205,0.04223047084718716,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+WSE","Parameter Unit/MW IT Load",{"v":1173.66,"d":"1,173.66"},{"v":19,"d":"19.00"},20.54,"86.25","144",0.244470764229606,0.5571287705344465,0.5417542197516027,0.3383802197972216,0.3948823248048669,0.048894152845921204,0.16713863116033395,0.054175421975160266,0.10151406593916648,0.03948823248048669,{"$nulls":11},{"v":100,"d":"100.00"}]
["Water-Cooled Chiller+WSE+ASE","Parameter Unit/MW IT Load",{"v":764.071,"d":"764.07"},6.94,7.94,"81.5","163",0.15915428769462986,0.20349861407942416,0.20942203042004506,0.31974478740259205,0.4469848537721757,0.03183085753892597,0.061049584223827245,0.020942203042004507,0.0959234362207776,0.04469848537721757,{"$nulls":11},{"v":100,"d":"100.00"}]
["Evaporative Cooling +ASE","Parameter Unit/MW IT Load",{"v":605.057,"d":"605.06"},{"v":16.734,"d":"16.73"},{"v":17.526,"d":"17.53"},{"v":82.75,"d":"83"},"41",{"$f":"C18/SQRT(SUM($C$10^2+$C$11^2+$C$12^2+$C$13^2+$C$14^2+$C$15^2+$C$16^2+$C$17^2+$C$18))","v":0.1260320256228147},0.49068383400649623,0.4622582500178476,0.3246488485590735,{"$f":"G18/SQRT(SUM($G$10^2+$G$11^2+$G$12^2+$G$13^2+$G$14^2+$G$15^2+$G$16^2+$G$17^2+$G$18^2))","v":0.11243177303471905},0.025206405124562944,0.14720515020194885,0.046225825001784765,0.09739465456772205,0.011243177303471906,{"$nulls":11},{"v":98,"d":"98.00"}]
[]
[null,"Σparameters' weight",{"$f":"C8+D8+E8+F8+G8","v":{"v":100,"d":"100.00"}}]
[{"$nulls":8},"Parameter Weight Percentage calculation based on entered paramters' importance comparison by user"]
[]
["Cooling System","Distanc from Ideal Best (S+)","Distanc from Ideal Worst (S-)","S++S-","Perfomance Score (PS)","Rank of Cooling Systems",{"$nulls":3},"Parameters"]
["Air-Cooled Chiller ",{"$f":"SQRT(SUM((M10-$R$10)^2+(N10-$S$10)^2+(O10-$T$10)^2+(P10-$U$10)^2+(Q10-$V$10)^2))","v":0.09886588827996277},{"$f":"SQRT(SUM((M10-$W$10)^2+(N10-$X$10)^2+(O10-$Y$10)^2+(P10-$Z$10)^2+(Q10-$AA$10)^2))","v":0.1744396940083642},{"$f":"B24+C24","v":0.27330558228832696},{"$f":"C24/D24","v":0.6382588037456804},{"$f":"_xlfn.RANK.EQ(E24,$E$24:$E$32,0)","v":5},null,null,"Parameters",null,"Energy Usage","Onsite water Use","Total Water Use","Reliability","Maintenance"]
["Air-Cooled Chiller+ ASE ",{"$f":"SQRT(SUM((M11-$R$10)^2+(N11-$S$10)^2+(O11-$T$10)^2+(P11-$U$10)^2+(Q11-$V$10)^2))","v":0.03981910855863},{"$f":"SQRT(SUM((M11-$W$10)^2+(N11-$X$10)^2+(O11-$Y$10)^2+(P11-$Z$10)^2+(Q11-$AA$10)^2))","v":0.1652259590271202},0.2050450675857502,0.8058031386588825,{"$f":"_xlfn.RANK.EQ(E25,$E$24:$E$32,0)","v":1},{"$nulls":3},"Energy Usage",1,"3","2","0.8","5"]
["Pre-Cooled-Air-Cooled Chiller",0.10468766071805252,0.1260992115921296,0.23078687231018213,0.5463881473407628,6,{"$nulls":3},"Onsite water Use",{"$f":"1/L25","v":0.3333333333333333},1,"1","0.5","2"]
["Pre-Cooled-Air-Cooled Chiller +ASE",0.05577115600520466,0.1493895132535174,0.20516066925872206,0.7281586368054137,2,{"$nulls":3},"Total Water Use",{"$f":"1/M25","v":0.5},{"$f":"1/M26","v":1},1,"0.4","1.5"]
["Water-Cooled Chiller",0.17627127058292713,0.07541343168211988,0.251684702265047,0.2996345467302285,8,{"$nulls":3},"Reliability",{"$f":"1/N25","v":1.25},{"$f":"1/N26","v":2},{"$f":"1/N27","v":2.5},1,"6"]
["Water-Cooled Chiller+ASE",0.06994790974746763,0.1440966595123375,0.21404456925980514,0.6732086686928946,3,{"$nulls":3},"Maintenance",{"$f":"1/O25","v":0.2},{"$f":"1/O26","v":0.5},{"$f":"1/O27","v":0.6666666666666666},{"$f":"1/O28","v":0.16666666666666666},1]
["Water-Cooled Chiller+WSE",0.17667772336313925,0.07495834552005655,0.2516360688831958,0.2978839474513117,9]
["Water-Cooled Chiller+WSE+ASE",0.07124300123376832,0.14406798419097003,0.21531098542473837,0.6691158089624218,4,{"$nulls":4},{"$f":"K25/(K25+K26+K27+K28+K29)","v":0.30456852791878175},{"$f":"L26/(L25+L26+L27+L28+L29)","v":0.13333333333333333},{"$f":"M27/(M25+M26+M27+M28+M29)","v":0.13953488372093023},{"$f":"N28/(N25+N26+N27+N28+N29)","v":0.3488372093023256},{"$f":"O29/(O25+O26+O27+O28+O29)","v":0.06451612903225806}]
["Evaporative Cooling +ASE",0.15166063355331966,{"$f":"SQRT(SUM((M18-$W$10)^2+(N18-$X$10)^2+(O18-$Y$10)^2+(P18-$Z$10)^2+(Q18-$AA$10)^2))","v":0.10600050849934747},0.2576611420526671,0.4113950115057725,7,{"$nulls":3},"Σparameters' weight",{"$f":"K31/(K31+L31+M31+N31+O31)*100","v":30.739965311523687},{"$f":"L31/(K31+L31+M31+N31+O31)*100","v":13.457273703044814},{"$f":"M31/(K31+L31+M31+N31+O31)*100","v":14.083193410163176},{"$f":"N31/(K31+L31+M31+N31+O31)*100","v":35.20798352540794},{"$f":"O31/(K31+L31+M31+N31+O31)*100","v":6.511584049860393}]
[{"$nulls":10},{"$f":"SUM(K32:O32)","v":{"v":100.00000000000001,"d":"100.00000000"}}]
[]
["List of Ranked Cooling Systems","Cooling Eneregy Use (MWh)","Onsite Water Use (acre-ft)","Total Cooling Water (acre-ft)","PUE","Onsite WUE (gal/kWh)","Source WUE (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Air-Cooled Chiller+ ASE ",23296.267594374804,61.60203523412799,90.20985184002025,1.8849619548685417,0.1145308762700757,0.8685156582174924,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",21494.347630183107,104.79798283320001,131.19304172306485,1.8721057907404615,0.19484104315068496,0.9436833594468695,100]
["Water-Cooled Chiller+ASE",15281.400000000001,138.85032471600002,157.61588391600003,1.8277782534246576,0.2581513630136987,0.9892626643835617,100]
["Water-Cooled Chiller+WSE+ASE",15281.42,138.85032471600002,157.615908476,1.8277783961187215,0.2581513630136987,0.9892627214611873,100]
["Air-Cooled Chiller ",59271.838013936875,0.12404495868,72.90986203979449,2.141636972131399,2.3062513698630138E-4,0.8568854139895459,100]
["Pre-Cooled-Air-Cooled Chiller",55964.32676948089,105.43821487799998,174.16240815092252,2.1180388610836247,0.19603136643835614,1.043246910871806,100]
["Evaporative Cooling +ASE",12101.14,334.80134492760004,349.66154484760006,1.805088042237443,0.6224646842465754,1.3444999011415528,98]
["Water-Cooled Chiller",23473.2,380.1377766,408.9628662,1.8862243150684932,0.7067544520547946,1.4612441780821919,100]
["Water-Cooled Chiller+WSE",23473.2,380.1377766,408.9628662,1.8862243150684932,0.7067544520547946,1.4612441780821919,100]
[]
[]
[]
[]
["IT Load (MW)",20]
["Cooling System","Annual Cooling Energy Use (MWh)","Annual IT Energy Use at UPS Outlet (MWh)","Annual IT Energy Use at UPS Inlet (MWh)","Annual Lighting Energy Use  (MWh)","Annual Total Energy Use (MWh)","Total Onsite Water Use (kgal)","Total Cooling Water Use (kgal)","Total Source Water Use (kgal)","PUE","WUEOnsite (gal/kWh)","WUESource  (gal/kWh)","Cooling System Availbility (% of the Year)"]
["Air-Cooled Chiller ",{"v":59271.838013936875,"d":"59,271.84"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":375214.7975174211,"d":"375214.80"},{"v":40.405524,"d":"40.41"},23749.140729574752,{"v":150126.32453096844,"d":"150126.32"},{"v":2.141636972131399,"d":"2.14"},{"v":2.3062513698630138E-4,"d":"0.00"},0.8568854139895459,100]
["Air-Cooled Chiller+ ASE ",{"v":23296.267594374804,"d":"23,296.27"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":330245.3344929685,"d":"330245.33"},{"v":20065.809522517262,"d":"20065.81"},29384.316560267183,{"v":152163.94331970467,"d":"152163.94"},{"v":1.8849619548685417,"d":"1.88"},{"v":0.1145308762700757,"d":"0.11"},0.8685156582174924,100]
["Pre-Cooled-Air-Cooled Chiller",{"v":55964.32676948089,"d":"55,964.33"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":371080.40846185107,"d":"371080.41"},{"v":34344.6954,"d":"34344.70"},56730.42610779236,{"v":182776.85878474044,"d":"182776.86"},{"v":2.1180388610836247,"d":"2.12"},{"v":0.19603136643835614,"d":"0.20"},1.043246910871806,100]
["Pre-Cooled-Air-Cooled Chiller +ASE",{"v":21494.347630183107,"d":"21,494.35"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":327992.93453772884,"d":"327992.93"},{"v":34136.150760000004,"d":"34136.15"},42733.88981207325,{"v":165333.32457509154,"d":"165333.32"},{"v":1.8721057907404615,"d":"1.87"},{"v":0.19484104315068496,"d":"0.19"},0.9436833594468695,100]
["Water-Cooled Chiller",{"v":23473.2,"d":"23,473.20"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":330466.5,"d":"330466.50"},123823.38,133212.66,256009.98,{"v":1.8862243150684932,"d":"1.89"},{"v":0.7067544520547946,"d":"0.71"},1.4612441780821919,100]
["Water-Cooled Chiller+ASE",{"v":15281.400000000001,"d":"15,281.40"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},320226.75,{"v":45228.118800000004,"d":"45228.12"},51340.67880000001,{"v":173318.8188,"d":"173318.82"},{"v":1.8277782534246576,"d":"1.83"},{"v":0.2581513630136987,"d":"0.26"},0.9892626643835617,100]
["Water-Cooled Chiller+WSE",{"v":23473.2,"d":"23,473.20"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":330466.5,"d":"330466.50"},123823.38,133212.66,256009.98,{"v":1.8862243150684932,"d":"1.89"},{"v":0.7067544520547946,"d":"0.71"},1.4612441780821919,100]
["Water-Cooled Chiller+WSE+ASE",{"v":15281.42,"d":"15,281.42"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":320226.775,"d":"320226.78"},{"v":45228.118800000004,"d":"45228.12"},51340.6868,{"v":173318.82880000002,"d":"173318.83"},{"v":1.8277783961187215,"d":"1.83"},{"v":0.2581513630136987,"d":"0.26"},0.9892627214611873,100]
["Evaporative Cooling +ASE",{"v":12101.14,"d":"12,101.14"},{"v":175200,"d":"175200.00"},{"v":219000,"d":"219000.00"},{"v":21900,"d":"21900.00"},{"v":316251.425,"d":"316251.43"},{"v":109055.81268000002,"d":"109055.81"},113896.26868000002,{"v":235556.38268000004,"d":"235556.38"},{"v":1.805088042237443,"d":"1.81"},{"v":0.6224646842465754,"d":"0.62"},1.3444999011415528,98]
{"$rows_empty":64}
[{"$nulls":5},{"$f":"_xlfn.RANK.EQ(E124,$E$24:$E$32,0)","v":{"$error":"#N/A"}}]

{"sheet":"Reliability Default Values","index":9,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[1,2,1,8]]}
[]
[null,null,"Scores range from 1 to 10 (1 as the lowest and 10 as the highest)"]
[null,null,"Cooling System Type","Annual Availability ","Fluctuation of IT Room Air Supply Affected by Outdoor Condition","Lifetime","IT Room Air Contamination","Complexity ","Overall Reliability     (out of 100)"]
[null,null,"Air-Cooled Chiller",50,10,9,10,10,{"$f":"SUM(D4:H4)","v":89}]
[null,null,"Air-Cooled Chiller + ASE ",50,8.5,8.75,8,8,{"$f":"SUM(D5:H5)","v":83.25}]
[null,null,"Pre-Cooled-Air-Cooled Chiller",50,10,9,10,9,88]
[null,null,"Pre-Cooled-Air-Cooled Chiller + ASE",50,8.5,8.75,8,7,82.25]
[null,null,"Water-Cooled Chiller",50,10,10,10,8.5,88.5]
[null,null,"Water-Cooled Chiller + ASE",50,8.5,9.75,8,6.5,82.75]
[null,null,"Water-Cooled Chiller + WSE",50,9,9.75,10,7.5,86.25]
[null,null,"Water-Cooled Chiller + WSE + ASE",50,8.5,9.5,8,5.5,81.5]
[null,null,"Evaporative Cooling + ASE (No Airflow Containment)",25,8.5,9.25,8,8,58.75]
[null,null,"Evaporative Cooling + ASE (CAC Airflow)",37.5,8.5,9.25,8,8,71.25]
[null,null,"Evaporative Cooling + ASE (HAC-VED Airflow)",48,8.5,9.25,8,8,81.75]
[null,null,"Evaporative Cooling + ASE (CAC and HAC-VED Airflow)",49,8.5,9.25,8,8,82.75]

{"sheet":"Maintenance Default Values","index":10,"n_rows":13,"n_cols":10,"rows_kept":13,"merged":[[1,3,1,9],[2,9,3,9]]}
[]
[{"$nulls":3},"Weights range from 1 to 10 (1 as the lowest and 10 as the highest)"]
[{"$nulls":3},"Annual Maintenance Actions","Semi-Annual Maintenance Actions","Monthly Maintenance Actions","Weekly Maintenance Actions","Daily Maintenance Actions","Water Treatment Requirement","Overall Maintenance Value"]
[{"$nulls":3},5,4,3,2,1,10]
[null,null,"Air-Cooled Chiller",10,4,0,6,3,0,{"$f":"D5*$D$4+E5*$E$4+F5*$F$4+G5*$G$4+H5*$H$4+I5*$I$4","v":81}]
[null,null,"Air-Cooled Chiller + ASE ",{"$f":"1+D5","v":11},{"$f":"3+E5","v":7},{"$f":"0+F5","v":0},{"$f":"1+G5","v":7},{"$f":"0+H5","v":3},{"$f":"0+I5","v":0},{"$f":"D6*$D$4+E6*$E$4+F6*$F$4+G6*$G$4+H6*$H$4+I6*$I$4","v":100}]
[null,null,"Pre-Cooled-Air-Cooled Chiller",{"$f":"D5+1","v":11},{"$f":"0+E5","v":4},{"$f":"1+F5","v":1},{"$f":"G5+2","v":8},{"$f":"0+H5","v":3},1,{"$f":"D7*$D$4+E7*$E$4+F7*$F$4+G7*$G$4+H7*$H$4+I7*$I$4","v":103}]
[null,null,"Pre-Cooled-Air-Cooled Chiller + ASE",{"$f":"1+D7","v":12},{"$f":"3+E7","v":7},{"$f":"0+F7","v":1},{"$f":"1+G7","v":9},{"$f":"0+H7","v":3},1,{"$f":"D8*$D$4+E8*$E$4+F8*$F$4+G8*$G$4+H8*$H$4+I8*$I$4","v":122}]
[null,null,"Water-Cooled Chiller",{"$f":"3+D5","v":13},{"$f":"0+E5","v":4},{"$f":"4+F5","v":4},{"$f":"7+G5","v":13},{"$f":"3+H5","v":6},1,135]
[null,null,"Water-Cooled Chiller + ASE",{"$f":"1+D9","v":14},{"$f":"3+E9","v":7},{"$f":"0+F9","v":4},{"$f":"1+G9","v":14},{"$f":"0+H9","v":6},1,154]
[null,null,"Water-Cooled Chiller + WSE",{"$f":"1+D9","v":14},{"$f":"0+E9","v":4},{"$f":"0+F9","v":4},{"$f":"2+G9","v":15},{"$f":"0+H9","v":6},1,144]
[null,null,"Water-Cooled Chiller + WSE + ASE",{"$f":"1+D11","v":15},{"$f":"3+E11","v":7},{"$f":"0+F11","v":4},{"$f":"1+G11","v":16},{"$f":"0+H11","v":6},1,163]
[null,null,"Evaporative Cooling + ASE",{"$f":"1+1","v":2},{"$f":"3","v":3},{"$f":"0+1","v":1},{"$f":"1+2","v":3},{"$f":"0+0","v":0},1,{"$f":"D13*$D$4+E13*$E$4+F13*$F$4+G13*$G$4+H13*$H$4+I13*$I$4","v":41}]

{"sheet":"Reliability Customized Values","index":11,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[1,2,1,9]]}
[]
[null,null,"Scores range from 1 to 10 (1 as the lowest and 10 as the highest)"]
[null,null,"Cooling System Type","Annual Availability ","Fluctuation of IT Room Air Supply Affected by Outdoor Condition","Lifetime","IT Room Air Contamination","Complexity ","Overall Reliability     (out of 50)","Overall Reliability (Scaled to 100)"]
[null,null,"Air-Cooled Chiller",{"$nulls":5},{"$f":"SUM(D4:H4)","v":0},{"$f":"I4*100/50","v":{"v":0,"d":"0.0"}}]
[null,null,"Air-Cooled Chiller + ASE ",{"$nulls":5},{"$f":"SUM(D5:H5)","v":0},{"$f":"I5*100/50","v":{"v":0,"d":"0.0"}}]
[null,null,"Pre-Cooled-Air-Cooled Chiller",{"$nulls":5},0,{"$f":"I6*100/50","v":{"v":0,"d":"0.0"}}]
[null,null,"Pre-Cooled-Air-Cooled Chiller + ASE",{"$nulls":5},0,{"v":0,"d":"0.0"}]
[null,null,"Water-Cooled Chiller",{"$nulls":5},0,{"v":0,"d":"0.0"}]
[null,null,"Water-Cooled Chiller + ASE",{"$nulls":5},0,{"v":0,"d":"0.0"}]
[null,null,"Water-Cooled Chiller + WSE",{"$nulls":5},0,{"v":0,"d":"0.0"}]
[null,null,"Water-Cooled Chiller + WSE + ASE",{"$nulls":5},0,{"v":0,"d":"0.0"}]
[null,null,"Evaporative Cooling + ASE",{"$nulls":5},0,{"$f":"I12*100/50","v":{"v":0,"d":"0.0"}}]

{"sheet":"Maintenance Customized Values","index":12,"n_rows":13,"n_cols":10,"rows_kept":13,"merged":[[1,3,1,9],[2,9,3,9]]}
[]
[{"$nulls":3},"Weights range from 1 to 10 (1 as the lowest and 10 as the highest)"]
[{"$nulls":3},"Annual Maintenance Actions","Semi-Annual Maintenance Actions","Monthly Maintenance Actions","Weekly Maintenance Actions","Daily Maintenance Actions","Water Treatment Requirement","Overall Maintenance Score"]
[{"$nulls":3},5,4,3,2,1,10]
[null,null,"Air-Cooled Chiller",{"$nulls":6},{"$f":"D5*$D$4+E5*$E$4+F5*$F$4+G5*$G$4+H5*$H$4+I5*$I$4","v":0}]
[null,null,"Air-Cooled Chiller + ASE ",{"$nulls":6},{"$f":"D6*$D$4+E6*$E$4+F6*$F$4+G6*$G$4+H6*$H$4+I6*$I$4","v":0}]
[null,null,"Pre-Cooled-Air-Cooled Chiller",{"$nulls":6},{"$f":"D7*$D$4+E7*$E$4+F7*$F$4+G7*$G$4+H7*$H$4+I7*$I$4","v":0}]
[null,null,"Pre-Cooled-Air-Cooled Chiller + ASE",{"$nulls":6},{"$f":"D8*$D$4+E8*$E$4+F8*$F$4+G8*$G$4+H8*$H$4+I8*$I$4","v":0}]
[null,null,"Water-Cooled Chiller",{"$nulls":6},0]
[null,null,"Water-Cooled Chiller + ASE",{"$nulls":6},0]
[null,null,"Water-Cooled Chiller + WSE",{"$nulls":6},0]
[null,null,"Water-Cooled Chiller + WSE + ASE",{"$nulls":6},0]
[null,null,"Evaporative Cooling + ASE",{"$nulls":6},{"$f":"D13*$D$4+E13*$E$4+F13*$F$4+G13*$G$4+H13*$H$4+I13*$I$4","v":0}]

{"sheet":"MCDST-Values (3)","index":13,"n_rows":22,"n_cols":22,"rows_kept":22,"hidden":true,"merged":[[0,2,0,5],[0,6,0,9],[0,10,0,13],[0,14,0,17],[0,18,0,21]]}
[null,null,"Parameters Weight",{"$nulls":3},"Normalized Performance Values (NPVs)",{"$nulls":3},"Weighted Normalized Values(WNVs)",{"$nulls":7},"Ideal Worst Value (V-)"]
[null,null,{"v":0.3,"d":"30%"},{"v":0.15,"d":"15%"},{"v":0.05,"d":"5%"},{"v":0.5,"d":"50%"}]
["Cooling System","Paramter Unit","Energy Use (MWh)","Onsite Water Use (acre-ft)","Source Water Use (acre-ft)","Reliability","NPV_Energy","NPV_Onsite Water","NPV_Source Water","NPV_Reliability","WNV_Energy","WNV_Onsite Water","WNV_Source Water","WNV_Reliability","V+_Energy","V+_Onsite Water","V+_Source Water","V+_Reliability","V-_Energy","V-_Onsite Water","V-_Source Water","V-_Reliability"]
["Air-Cooled Chiller ","MWh",{"v":10740.239788181489,"d":"10,740.24"},0,{"v":15.15056244969731,"d":"15.15"},1,{"$f":"C4/SQRT(SUM($C$4^2+$C$5^2+$C$6^2+$C$7^2+$C$8^2+$C$9^2+$C$10^2+$C$11^2+$C$12))","v":0.6454965824735477},{"$f":"D4/SQRT(SUM($D$4^2+$D$5^2+$D$6^2+$D$7^2+$D$8^2+$D$9^2+$D$10^2+$D$11^2+$D$12^2))","v":0},{"$f":"E4/SQRT(SUM($E$4^2+$E$5^2+$E$6^2+$E$7^2+$E$8^2+$E$9^2+$E$10^2+$E$11^2+$E$12^2))","v":0.6454965824735478},{"$f":"F4/SQRT(SUM($F$4^2+$F$5^2+$F$6^2+$F$7^2+$F$8^2+$F$9^2+$F$10^2+$F$11^2+$F$12^2))","v":0.5136654969375142},{"$f":"$C$2*G4","v":0.1936489747420643},{"$f":"$D$2*H4","v":0},{"$f":"$E$2*I4","v":0.03227482912367739},{"$f":"$F$2*J4","v":0.2568327484687571},{"$f":"MIN(K4:K12)","v":0.06499503774702017},{"$f":"MIN(L4:L12)","v":0},{"$f":"MIN(M4:M12)","v":0.010832506291170031},{"$f":"MAX(N4:N12)","v":0.2568327484687571},{"$f":"MAX(K4:K12)","v":0.1936489747420643},{"$f":"MAX(L4:L12)","v":0.14933465091005121},{"$f":"MAX(M4:M12)","v":0.03227482912367739},{"$f":"MIN(N4:N12)","v":0.17978292392812995}]
["Air-Cooled Chiller+ ASE ","MWh",{"v":4727.416230412072,"d":"4,727.42"},0,{"v":6.668660685153824,"d":"6.67"},0.7,{"$f":"C5/SQRT(SUM($C$4^2+$C$5^2+$C$6^2+$C$7^2+$C$8^2+$C$9^2+$C$10^2+$C$11^2+$C$12))","v":0.2841213120789784},{"$f":"D5/SQRT(SUM($D$4^2+$D$5^2+$D$6^2+$D$7^2+$D$8^2+$D$9^2+$D$10^2+$D$11^2+$D$12^2))","v":0},{"$f":"E5/SQRT(SUM($E$4^2+$E$5^2+$E$6^2+$E$7^2+$E$8^2+$E$9^2+$E$10^2+$E$11^2+$E$12^2))","v":0.28412131207897845},{"$f":"F5/SQRT(SUM($F$4^2+$F$5^2+$F$6^2+$F$7^2+$F$8^2+$F$9^2+$F$10^2+$F$11^2+$F$12^2))","v":0.3595658478562599},{"$f":"$C$2*G5","v":0.08523639362369352},{"$f":"$D$2*H5","v":0},{"$f":"$E$2*I5","v":0.014206065603948922},{"$f":"$F$2*J5","v":0.17978292392812995}]
["Pre-Cooled-Air-Cooled Chiller","MWh",{"v":9248.585169371727,"d":"9,248.59"},7.258651704561853,{"v":13.046381639830752,"d":"13.05"},1,{"$f":"C6/SQRT(SUM($C$4^2+$C$5^2+$C$6^2+$C$7^2+$C$8^2+$C$9^2+$C$10^2+$C$11^2+$C$12))","v":0.5558470050281625},{"$f":"D6/SQRT(SUM($D$4^2+$D$5^2+$D$6^2+$D$7^2+$D$8^2+$D$9^2+$D$10^2+$D$11^2+$D$12^2))","v":0.07933816221975058},{"$f":"E6/SQRT(SUM($E$4^2+$E$5^2+$E$6^2+$E$7^2+$E$8^2+$E$9^2+$E$10^2+$E$11^2+$E$12^2))","v":0.5558470050281625},{"$f":"F6/SQRT(SUM($F$4^2+$F$5^2+$F$6^2+$F$7^2+$F$8^2+$F$9^2+$F$10^2+$F$11^2+$F$12^2))","v":0.5136654969375142},{"$f":"$C$2*G6","v":0.16675410150844874},{"$f":"$D$2*H6","v":0.011900724332962588},{"$f":"$E$2*I6","v":0.027792350251408127},{"$f":"$F$2*J6","v":0.2568327484687571}]
["Pre-Cooled-Air-Cooled Chiller +ASE","MWh",{"v":3604.781752006205,"d":"3,604.78"},4.626449847609392,{"v":5.0850327486539735,"d":"5.09"},0.7,{"$f":"C7/SQRT(SUM($C$4^2+$C$5^2+$C$6^2+$C$7^2+$C$8^2+$C$9^2+$C$10^2+$C$11^2+$C$12))","v":0.2166501258234006},{"$f":"D7/SQRT(SUM($D$4^2+$D$5^2+$D$6^2+$D$7^2+$D$8^2+$D$9^2+$D$10^2+$D$11^2+$D$12^2))","v":0.05056779736111205},{"$f":"E7/SQRT(SUM($E$4^2+$E$5^2+$E$6^2+$E$7^2+$E$8^2+$E$9^2+$E$10^2+$E$11^2+$E$12^2))","v":0.21665012582340062},{"$f":"F7/SQRT(SUM($F$4^2+$F$5^2+$F$6^2+$F$7^2+$F$8^2+$F$9^2+$F$10^2+$F$11^2+$F$12^2))","v":0.3595658478562599},{"$f":"$C$2*G7","v":0.06499503774702017},{"$f":"$D$2*H7","v":7.585169604166807E-3},{"$f":"$E$2*I7","v":0.010832506291170031},{"$f":"$F$2*J7","v":0.17978292392812995}]
["Water-Cooled Chiller","MWh",{"v":6373.002295933349,"d":"6,373.00"},91.0842221070545,{"v":8.989982642924858,"d":"8.99"},0.9,{"$f":"C8/SQRT(SUM($C$4^2+$C$5^2+$C$6^2+$C$7^2+$C$8^2+$C$9^2+$C$10^2+$C$11^2+$C$12))","v":0.3830222865831918},{"$f":"D8/SQRT(SUM($D$4^2+$D$5^2+$D$6^2+$D$7^2+$D$8^2+$D$9^2+$D$10^2+$D$11^2+$D$12^2))","v":0.9955643394003414},{"$f":"E8/SQRT(SUM($E$4^2+$E$5^2+$E$6^2+$E$7^2+$E$8^2+$E$9^2+$E$10^2+$E$11^2+$E$12^2))","v":0.3830222865831919},{"$f":"F8/SQRT(SUM($F$4^2+$F$5^2+$F$6^2+$F$7^2+$F$8^2+$F$9^2+$F$10^2+$F$11^2+$F$12^2))","v":0.46229894724376275},{"$f":"$C$2*G8","v":0.11490668597495754},{"$f":"$D$2*H8","v":0.14933465091005121},{"$f":"$E$2*I8","v":0.019151114329159596},{"$f":"$F$2*J8","v":0.23114947362188137}]
{"$rows_empty":8}
["Cooling System","Distanc from Ideal Best (S+)","Distanc from Ideal Worst (S-)","S++S-","Perfomance Score (PS)","Rank of Cooling Systems"]
["Air-Cooled Chiller ",{"$f":"SQRT(SUM((K4-$O$4)^2+(L4-$P$4)^2+(M4-$Q$4)^2+(N4-$R$4)^2))","v":0.13042855788813373},{"$f":"SQRT(SUM((K4-$S$4)^2+(L4-$T$4)^2+(M4-$U$4)^2+(N4-$V$4)^2))","v":0.16804021371138603},{"$f":"B18+C18","v":0.2984687715995198},{"$f":"C18/D18","v":0.5630076902546424},{"$f":"_xlfn.RANK.EQ(E18,$E$18:$E$26,0)","v":4}]
["Air-Cooled Chiller+ ASE ",{"$f":"SQRT(SUM((K5-$O$4)^2+(L5-$P$4)^2+(M5-$Q$4)^2+(N5-$R$4)^2))","v":0.07973561846442533},{"$f":"SQRT(SUM((K5-$S$4)^2+(L5-$T$4)^2+(M5-$U$4)^2+(N5-$V$4)^2))","v":0.18542007960926468},{"$f":"B19+C19","v":0.26515569807369},{"$f":"C19/D19","v":0.6992875542796526},{"$f":"_xlfn.RANK.EQ(E19,$E$18:$E$26,0)","v":2}]
["Pre-Cooled-Air-Cooled Chiller",{"$f":"SQRT(SUM((K6-$O$4)^2+(L6-$P$4)^2+(M6-$Q$4)^2+(N6-$R$4)^2))","v":0.10384686131225766},{"$f":"SQRT(SUM((K6-$S$4)^2+(L6-$T$4)^2+(M6-$U$4)^2+(N6-$V$4)^2))","v":0.1599005517790061},{"$f":"B20+C20","v":0.26374741309126376},{"$f":"C20/D20","v":0.6062639625726914},{"$f":"_xlfn.RANK.EQ(E20,$E$18:$E$26,0)","v":3}]
["Pre-Cooled-Air-Cooled Chiller +ASE",{"$f":"SQRT(SUM((K7-$O$4)^2+(L7-$P$4)^2+(M7-$Q$4)^2+(N7-$R$4)^2))","v":0.07742228529089931},{"$f":"SQRT(SUM((K7-$S$4)^2+(L7-$T$4)^2+(M7-$U$4)^2+(N7-$V$4)^2))","v":0.19262534662724304},{"$f":"B21+C21","v":0.27004763191814235},{"$f":"C21/D21","v":0.713301373017158},{"$f":"_xlfn.RANK.EQ(E21,$E$18:$E$26,0)","v":1}]
["Water-Cooled Chiller",{"$f":"SQRT(SUM((K8-$O$4)^2+(L8-$P$4)^2+(M8-$Q$4)^2+(N8-$R$4)^2))","v":0.15975243484155754},{"$f":"SQRT(SUM((K8-$S$4)^2+(L8-$T$4)^2+(M8-$U$4)^2+(N8-$V$4)^2))","v":0.09492682633339697},{"$f":"B22+C22","v":0.25467926117495454},{"$f":"C22/D22","v":0.37273088470358806},{"$f":"_xlfn.RANK.EQ(E22,$E$18:$E$26,0)","v":5}]