{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ASHE Energy to Care","Talking Points","Key","test"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"ASHE Energy to Care","index":0,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,0,7,1],[21,2,21,5],[2,2,2,5],[5,2,5,5],[11,2,11,5]]}
[]
[]
["                                                     ",null,"Energy to Care Benefits Calculator Tool"]
[]
[]
[null,null,"SELECT INPUTS"]
[null,null,"Select either bed capacity OR ",0]
[null,null,"Floor area (ft2) of your hospital",0]
[null,null,"Select your state","Alabama"]
[null,null,"Enter hospital's annual energy costs  ($)"]
[null,null,"ASHE Chapter",{"$f":"VLOOKUP(D9,Table3[#All],2,0)","v":"Region4"}]
[null,null,"\n*A result of #N/A below means there is no equivanet sized hospital in the ASHE program in your same region. You might be able to generate comparable results by inputing a larger or smaller sized hospital or selecting a state in a neigboring region. Air pollution and health care cost data are not available for Alaska and Hawaii."]
[]
[null,null,"% reduction in EUI of",{"$f":"Key!F23","v":{"$error":"#N/A"}}]
[null,null,"Energystar Score",{"$f":"Key!G23","v":{"$error":"#N/A"}}]
[null,null,"Site energy use ",{"$f":"Key!H23","v":{"$error":"#N/A"}},"kBtu"]
[null,null,"Electric use savings (kWh)",{"$f":"IF(Key!I23>0,Key!I23,0)","v":{"$error":"#N/A"}},"kWh"]
[null,null,"Gas use savings (Therms)",{"$f":"IFERROR(Key!J23,0)","v":0},"Therms"]
[]
[]
[]
[null,null,"BY PARTICIPATING IN THE ASHE ENERGY TO CARE PROGRAM WE COULD….."]
[null,null,"Reduce our hospital's annual energy consumption ",{"$f":"IF(D14>0,D14,0)","v":{"$error":"#N/A"}}]
[null,null,"Reduce our hospital’s annual operating costs",{"$f":"MROUND(D10*D23, 100)","v":{"$error":"#N/A"}},"$ per year"]
[null,null,"Reduce our hospital's operating costs over 10 years ",{"$f":"MROUND(D24*10,1000)","v":{"$error":"#N/A"}},"$"]
[null,null,"Reduce fine particulate pollution",{"$f":"((VLOOKUP(D9,'Talking Points'!A1:F52,3,FALSE))*(D17/1000)+(D18*'Talking Points'!J11))","v":{"$error":"#N/A"}},"lbs per year"]
[null,null,"Reduce nitrogen oxide pollution",{"$f":"((VLOOKUP(D9, 'Talking Points'!A1:E52,4,FALSE))*(D17/1000))+(D18*'Talking Points'!J9)","v":{"$error":"#N/A"}},"lbs per year"]
[null,null,"Reduce greenhouse gas emissions",{"$f":"((VLOOKUP(D9, 'Talking Points'!A1:E52,5,FALSE))*(D17/1000))+(D18*'Talking Points'!J10)","v":{"$error":"#N/A"}},"lbs per year"]
[null,null,"The pollution avoided would reduce health care costs",{"$f":"((VLOOKUP(D9, 'Talking Points'!A1:G52,7,FALSE))*D17)/100","v":{"$error":"#N/A"}},"$ per year"]
[null,null,"Reduce coal dependancy. In our region coal generates",{"$f":"VLOOKUP(D9,'Talking Points'!A2:B52,2,FALSE)","v":0.22},"of our electricity"]
[null,null,"Remain competative. Another hospital in our region participating in ASHE's program reduced their EUI",{"$f":"INDEX(test!BC:BC,MATCH(D11,test!BA:BA,0))","v":7.6627218934911173E-2}]
[null,null,"Reduce our energy use intensity (EUI)",{"$f":"IF(D14>0,D14,0)","v":{"$error":"#N/A"}}]
[null,null,"Achieve an ENERGY STAR Score of",{"$f":"Key!G23","v":{"$error":"#N/A"}}]
[null,null,"Limit our energy use to",{"$f":"MROUND(Key!H23,1000)","v":{"$error":"#N/A"}},"kBtu"]
[null,null,"Achieve electricity savings",{"$f":"MROUND(D17, 100)","v":{"$error":"#N/A"}},"kWh"]
[null,null,"Reduce gas consumption",{"$f":"MROUND(D18, 100)","v":0},"Therms"]
[null,null,"Help to reduce health care costs ",{"$f":"VLOOKUP(D9,'Talking Points'!A2:H52,8,FALSE)","v":105.54},"$ per person"]

{"sheet":"Talking Points","index":1,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[null,"% of Coal Mix (EIA 2017)","PM2.5 (lb/MWh)","Nox (lb/MWh)","CO2 (lbs/MWh)","Region","cents/kwh","$/capita health benefits","Natural Gas Emission Factors"]
["Alabama",0.22,0.1,0.91,1502,"SE",4.0199999999999996,105.54,"We used EPA emission factors for small controlled low Nox burners"]
["Alaska",0.09,"NA","NA","NA",null,null,"NA","Nox (lb/10x6 scf)",50]
["Arizona",0.3,7.0000000000000007E-2,0.96,1317,"SW",1.62,8.59,"CO2(lb/10 x 6 scf)",120000]
["Arkansas",0.43,0.1,0.91,1502,"SE",4.0199999999999996,98.39,"PM (lb/10x6 scf)",7.6]
["California",0,0.05,0.33,1087,"CA",1.08,4.4800000000000004,"https://www3.epa.gov/ttnchie1/ap42/ch01/final/c01s04.pdf"]
["Colorado",0.54,0.04,1.37,1672,"RM",2.3199999999999998,16.559999999999999]
["Connecticut",0.01,0.04,0.42,1114,"NE",3.73,75.040000000000006,"Convert to therms"]
["Delaware",0.05,0.21,0.97,1675,"GL",7.95,103.42,"Nox (lb/therm)",{"$f":"(J3/1000000)/1.037","v":4.8216007714561243E-5}]
["District of Columbia","NA",0.21,0.97,1675,"GL",7.95,63.3,"CO2 (lb/therm)",{"$f":"(J4/1000000)/1.037","v":0.11571841851494696}]
["Florida",0.16,0.1,0.91,1502,"SE",4.0199999999999996,42.71,"PM (lb/therm)",{"$f":"(J5/1000000)/1.037","v":7.3288331726133074E-6}]
["Georgia",0.25,0.1,0.91,1502,"SE",4.0199999999999996,57.41]
["Hawaii",0.14000000000000001,"NA","NA","NA",null,null,"NA"]
["Idaho",0,0.08,1.25,1635,"NW",2.5499999999999998,8.0500000000000007]
["Illinois",0.32,0.1,1.35,1965,"UM",7.06,86.87]
["Indiana",0.73,0.21,0.97,1675,"GL",7.95,128.41999999999999]
["Iowa",0.44,0.1,1.35,1965,"UM",7.06,79.599999999999994]
["Kansas",0.38,0.1,1.18,1813,"LM",5.23,52.73]
["Kentucky",0.78,0.1,0.91,1502,"SE",4.0199999999999996,147.77000000000001]
["Louisiana",0.13,0.1,0.91,1502,"SE",4.0199999999999996,70.87]
["Maine",0.01,0.04,0.42,1114,"NE",3.73,57.95]
["Maryland",0.25,0.21,0.97,1675,"GL",7.95,86.54]
["Massachusetts",0.04,0.04,0.42,1114,"NE",3.73,47.4]
["Michigan",0.37,0.21,0.97,1675,"GL",7.95,104.8]
["Minnesota",0.39,0.1,1.35,1965,"UM",7.06,25.54]
["Mississippi",0.08,0.1,0.91,1502,"SE",4.0199999999999996,88.88]
["Missouri",0.8,0.1,1.35,1965,"UM",7.06,89.18]
["Montana",0.49,0.08,1.25,1635,"NW",2.5499999999999998,17.53]
["Nebraska",0.6,0.1,1.35,1965,"UM",7.06,47.38]
["Nevada",0.05,7.0000000000000007E-2,0.96,1317,"SW",1.62,9.2200000000000006]
["New Hampshire",0.02,0.04,0.42,1114,"NE",3.73,60.17]
["New Jersey",0.02,0.21,0.97,1675,"GL",7.95,79.819999999999993]
["New Mexico",0.55000000000000004,7.0000000000000007E-2,0.96,1317,"SW",1.62,16.75]
["New York",0.01,0.04,0.42,1114,"NE",3.73,83.97]
["North Carolina",0.27,0.1,0.91,1502,"SE",4.0199999999999996,76.599999999999994]
["North Dakota",0.64,0.1,1.35,1965,"UM",7.06,24.25]
["Ohio",0.56999999999999995,0.21,0.97,1675,"GL",7.95,137.24]
["Oklahoma",0.24,0.1,1.18,1813,"LM",5.23,67.02]
["Oregon",0.03,0.08,1.25,1635,"NW",2.5499999999999998,5.71]
["Pennsylvania",0.22,0.21,0.97,1675,"GL",7.95,139.87]
["Rhode Island",0,0.04,0.42,1114,"NE",3.73,72.48]
["South Carolina",0.2,0.1,0.91,1502,"SE",4.0199999999999996,78.680000000000007]
["South Dakota",0.19,0.1,1.35,1965,"UM",7.06,41.25]
["Tennessee",0.35,0.1,0.91,1502,"SE",4.0199999999999996,123.86]
["Texas",0.3,0.08,0.65,1387,"TX",3.58,38.67]
["Utah",0.71,0.08,1.25,1635,"NW",2.5499999999999998,7.58]
["Vermont",0,0.04,0.42,1114,"NE",3.73,79.37]
["Virgina",0.12,0.1,0.91,1502,"SE",4.0199999999999996,89.13]
["Washington",0.05,0.08,1.25,1635,"NW",2.5499999999999998,6.86]
["West Virginia",0.93,0.21,0.97,1675,"GL",7.95,184.11]
["Wisconsin",0.55000000000000004,0.1,1.35,1965,"UM",7.06,69.84]
["Wyoming",0.86,0.08,1.25,1635,"NW",2.5499999999999998,24.34]

{"sheet":"Key","index":2,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":true,"merged":[]}
["Hospital Bed Capacity",{"$f":"'ASHE Energy to Care'!D7","v":0},{"$f":"VLOOKUP(B1,Table1[#All],2,TRUE)","v":"BedA"},null,null,"Reduction in  EUI (kBtu/ft²)","ENERGY STAR Score","Site energy use (kBtu)","Electric use savings (kWh)","Gas use savings (therms)"]
["Area of the hospital",{"$f":"'ASHE Energy to Care'!D8","v":0},{"$f":"VLOOKUP(B2,Table2[#All],2,TRUE)","v":{"$error":"#N/A"}}]
["State","='Input sheet '!D6",null,null,"hospital #1",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F2, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G2, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H2, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I2, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J2, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #2",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F3, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G3, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H3, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I3, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J3, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
["ASHE Chapter",{"$f":"'ASHE Energy to Care'!D11","v":"Region4"},null,null,"hospital #3",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F4, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G4, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H4, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I4, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J4, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
["Check - if Region 10 with no winners, borrow from Region 9",{"$f":"IF(B5=\"Region10\",\"Region9\",B5)","v":"Region4"},null,null,"hospital #4",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F5, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G5, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H5, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I5, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J5, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
["Combined Key",{"$f":"IF(B1>0,CONCATENATE(C1,B6),CONCATENATE(C2,B6))","v":{"$error":"#N/A"}},null,null,"hospital #5",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F6, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G6, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H6, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I6, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J6, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #6",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F7, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G7, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H7, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I7, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J7, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #7",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F8, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G8, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H8, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I8, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J8, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #8",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F9, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G9, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H9, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I9, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J9, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #9",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F10, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G10, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H10, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I10, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J10, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #10",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F11, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G11, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H11, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I11, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J11, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #11",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F12, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G12, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H12, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I12, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J12, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #12",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F13, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G13, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H13, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I13, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J13, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #13",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F14, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G14, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H14, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I14, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J14, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #14",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F15, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G15, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H15, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I15, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J15, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #15",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F16, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G16, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H16, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I16, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J16, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #16",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F17, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G17, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H17, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I17, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J17, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #17",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F18, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G18, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H18, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I18, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J18, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #18",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F19, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G19, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H19, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I19, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J19, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #19",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F20, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G20, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H20, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I20, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J20, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,"hospital #20",{"$f":"INDEX(test!$AG$3:$AG$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($F$2:$F21, test!$AG$3:$AG$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AA$3:$AA$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($G$2:$G21, test!$AA$3:$AA$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$AC$3:$AC$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($H$2:$H21, test!$AC$3:$AC$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$U$3:$U$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($I$2:$I21, test!$U$3:$U$238), \"\"), 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(test!$X$3:$X$238, MATCH(0, IF($B$7=test!$AX$3:$AX$238, COUNTIF($J$2:$J21, test!$X$3:$X$238), \"\"), 0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"MAX(INDEX(F3:F22,1):INDEX(F3:F22,MATCH(99^99,F3:F22,1)))","v":{"$error":"#N/A"}},{"$f":"MAX(INDEX(G3:G22,1):INDEX(G3:G22,MATCH(99^99,G3:G22,1)))","v":{"$error":"#N/A"}},{"$f":"MAX(INDEX(H3:H22,1):INDEX(H3:H22,MATCH(99^99,H3:H22,1)))","v":{"$error":"#N/A"}},{"$f":"MAX(INDEX(I3:I22,1):INDEX(I3:I22,MATCH(99^99,I3:I22,1)))","v":{"$error":"#N/A"}},{"$f":"MAX(INDEX(J3:J22,1):INDEX(J3:J22,MATCH(99^99,J3:J22,1)))","v":{"$error":"#N/A"}}]
[]
["# reference tables fr vlookup"]
[]
[null,"Table 1",null,null,"Table 2",null,null,"Table 3",null,null,"ASHE chapter regions"]
[null,"VALUE","KEY",null,"VALUE","KEY",null,"Value","Key"]
[null,0,"BedA",null,1,"AreaA",null,"Maine","Region1",null,"Maine"]
[null,100,"BedB",null,50000,"AreaB",null,"Connecticut","Region1",null,"Connecticut"]
[null,300,"BedC",null,150000,"AreaC",null,"Massachusetts","Region1",null,"Massachusetts"]
[null,500,"BedD",null,300000,"AreaD",null,"New Hampshire","Region1",null,"New Hampshire"]
[null,null,null,null,500000,"AreaE",null,"New Jersey","Region1",null,"New Jersey"]
[null,null,null,null,1000000,"AreaF",null,"New York","Region1",null,"New York"]
[null,null,null,null,null,null,null,"Rhode Island","Region1",null,"Rhode Island "]
[null,null,null,null,null,null,null,"Vermont","Region1",null,"Vermont"]
[null,null,null,null,null,null,null,"Delaware","Region2",null,"Delaware"]
[null,null,null,null,null,null,null,"District of Columbia","Region2",null,"District of Columbia"]
[null,null,null,null,null,null,null,"Maryland","Region2",null,"Maryland"]
[null,null,null,null,null,null,null,"Pennsylvania","Region2",null,"Pennsylvania"]
[null,null,null,null,null,null,null,"Kentucky","Region3",null,"Kentucky"]
[null,null,null,null,null,null,null,"North Carolina","Region3",null,"North Carolina"]
[null,null,null,null,null,null,null,"South Carolina","Region3",null,"South Carolina"]
[null,null,null,null,null,null,null,"Tennessee","Region3",null,"Tennessee"]
[null,null,null,null,null,null,null,"Virgina","Region3",null,"Virginia"]
[null,null,null,null,null,null,null,"West Virginia","Region3",null,"West Virginia"]
[null,null,null,null,null,null,null,"Alabama","Region4",null,"Alabama"]
[null,null,null,null,null,null,null,"Florida","Region4",null,"Florida"]
[null,null,null,null,null,null,null,"Georgia","Region4",null,"Georgia"]
[null,null,null,null,null,null,null,"Mississippi","Region4",null,"Mississippi"]
[null,null,null,null,null,null,null,"Illinois","Region5",null,"Illinois"]
[null,null,null,null,null,null,null,"Indiana","Region5",null,"Indiana"]
[null,null,null,null,null,null,null,"Michigan","Region5",null,"Michigan"]
[null,null,null,null,null,null,null,"Ohio","Region5",null,"Ohio"]
[null,null,null,null,null,null,null,"Iowa","Region6",null,"Iowa"]
[null,null,null,null,null,null,null,"Minnesota","Region6",null,"Minnesota"]
[null,null,null,null,null,null,null,"North Dakota","Region6",null,"North Dakota"]
[null,null,null,null,null,null,null,"South Dakota","Region6",null,"South Dakota"]
[null,null,null,null,null,null,null,"Wisconsin","Region6",null,"Wisconsin"]
[null,null,null,null,null,null,null,"Arkansas","Region7",null,"Arkansas"]
[null,null,null,null,null,null,null,"Louisiana","Region7",null,"Louisiana"]
[null,null,null,null,null,null,null,"New Mexico","Region7",null,"New Mexico"]
[null,null,null,null,null,null,null,"Oklahoma","Region7",null,"Oklahoma"]
[null,null,null,null,null,null,null,"Texas","Region7",null,"Texas"]
[null,null,null,null,null,null,null,"Colorado","Region8",null,"Colorado"]
[null,null,null,null,null,null,null,"Kansas","Region8",null,"Kansas"]
[null,null,null,null,null,null,null,"Missouri","Region8",null,"Missouri"]
[null,null,null,null,null,null,null,"Nebraska","Region8",null,"Nebraska"]
[null,null,null,null,null,null,null,"Arizona","Region9",null,"Arizona"]
[null,null,null,null,null,null,null,"California","Region9",null,"California"]
[null,null,null,null,null,null,null,"Nevada","Region9",null,"Nevada"]
[null,null,null,null,null,null,null,"Utah","Region9",null,"Utah"]
[null,null,null,null,null,null,null,"Alaska","Region10",null,"Alaska"]
[null,null,null,null,null,null,null,"Hawaii","Region10",null,"Hawaii"]
[null,null,null,null,null,null,null,"Idaho","Region10",null,"Idaho"]
[null,null,null,null,null,null,null,"Montana","Region10",null,"Montana"]
[null,null,null,null,null,null,null,"Oregon","Region10",null,"Oregon"]
[null,null,null,null,null,null,null,"Washington","Region10",null,"Washington"]
[null,null,null,null,null,null,null,"Wyoming","Region10",null,"Wyoming"]

{"sheet":"test","index":3,"n_rows":120,"n_cols":60,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
["ACEEE Data - Hospital (General Medical & Surgical) for tool"]
["Property Id","Property Name","Parent Property Name","Year Ending","City","Postal Code","Number of Buildings","Year Built","Occupancy","Metered Areas (Energy)","Metered Areas  (Water)","Hospital (General Medical & Surgical) - Gross Floor Area (ft²)","Area Key","Hospital (General Medical & Surgical) - Licensed Bed Capacity","Bed Key","Hospital (General Medical & Surgical) - Number of MRI Machines","Hospital (General Medical & Surgical) - Onsite Laundry Facility","Other - Specialty Hospital - Gross Floor Area (ft²)","Other - Specialty Hospital - Weekly Operating Hours","Electricity Use - Grid Purchase (kWh)","One year electricity use savings","Electricity Use – Generated from Onsite Renewable Systems and Used Onsite (kWh)","Electricity Use - Grid Purchase and Generated from Onsite Renewable Systems (kWh)","Natural Gas Use (therms)","One year natural gas use savings","Diesel #2 Use (kBtu)","ENERGY STAR Score","Site EUI (kBtu/ft²)","Site Energy Use (kBtu)",null,"Site Energy Use - Adjusted to Current Year (kBtu)","Weather Normalized Site EUI (kBtu/ft²)","Weather normalized EUI % reduction","Weather Normalized Water/Wastewater Site EUI (kBtu/gpd)","Water Use (All Water Sources) (kgal)","Energy Cost ($)","Energy Cost Intensity ($/ft²)","Total Water Cost (All Water Sources) ($)","Total Water Cost Intensity (All Water Sources) ($/ft²)","Investment in Energy Projects, Cumulative ($)","Estimated Savings from Energy Projects, Cumulative ($)","Green Power - Onsite and Offsite (kWh)","Avoided Emissions - Onsite and Offsite Green Power (Metric Tons CO2e)","Total GHG Emissions (Metric Tons CO2e)","Direct GHG Emissions (Metric Tons CO2e)","Indirect GHG Emissions (Metric Tons CO2e)","Net Emissions (Metric Tons CO2e)","State/Province","Region Key","Combined Key",null,null,null,"Number of EtC winners","Energy savings ","Winning hospital in the region","State"]
["28405","Westchester Division","Not Applicable: Standalone Property","2013-12-31","White Plains","10605",0,"1930",100,"Whole Building","Whole Building",602980,{"$f":"VLOOKUP(L3,Table2[#All],2,TRUE)","v":"AreaE"},416.06,{"$f":"VLOOKUP(N3,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",6210737.9000000004,-178817.70000000019,"Not Available",6210739,860167.10149999999,-39703.329400000046,"Not Available",99,182.9,110304374.40000001,-6.4616090846815633E-2,111307476.7,188.2,2.4870466321243581E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,6593.2,4798.6000000000004,1794.7,6593.2,"New York",{"$f":"VLOOKUP(AV3,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O3,AW3),CONCATENATE(M3,AW3))","v":"AreaERegion1"},null,null,"Region1",{"$f":"COUNTIF(AW:AW,BA3)","v":11},{"$f":"MAX(IF(AW:AW=BA3,AG:AG))","v":0.35117773019271897},{"$f":"INDEX(B:B,MATCH(BC3,AG:AG,0))","v":"Russell Regional Hospital"},{"$f":"INDEX(AV:AV,MATCH(BC3,AG:AG,0))","v":"Kansas"},null,null,{"$f":"MAX(IF(AW3:AW120=BA3,AG3:AG120))","v":0.35117773019271897}]
[28405,"Westchester Division","Not Applicable: Standalone Property","2007-12-31","White Plains",10605,0,1930,100,"Whole Building","Whole Building",602980,{"$f":"VLOOKUP(L4,Table2[#All],2,TRUE)","v":"AreaE"},416.06,{"$f":"VLOOKUP(N4,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",6488139.4000000004,-523900.20000000019,"Not Available",6488140,671879.98640000005,128414.98329999996,"Not Available",99,189.9,114499532.40000001,6.3662623282587288E-2,115607430,189.9,6.3609467455621321E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,7311.6,5436.8,1874.8,7311.6,"New York",{"$f":"VLOOKUP(AV4,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O4,AW4),CONCATENATE(M4,AW4))","v":"AreaERegion1"},null,null,"Region2",{"$f":"COUNTIF(AW:AW,BA4)","v":5},{"$f":"MAX(IF(AW:AW=BA4,AG:AG))","v":0.12591986917416184},{"$f":"INDEX(B:B,MATCH(BC4,AG:AG,0))","v":"Wellspan Surgery and Rehab Hospital"},{"$f":"INDEX(AV:AV,MATCH(BC4,AG:AG,0))","v":"Pennsylvania"},null,null,{"$f":"MAX(IF(AW3:AW120=BA4,AG3:AG120))","v":0}]
["28405","Westchester Division","Not Applicable: Standalone Property","2006-12-31","White Plains","10605",0,"1930",100,"Whole Building","Whole Building",602980,{"$f":"VLOOKUP(L5,Table2[#All],2,TRUE)","v":"AreaE"},416.06,{"$f":"VLOOKUP(N5,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",5964239.2000000002,-301119.90000000037,"Not Available",5964240,800294.96970000002,-98045.766640000045,"Not Available",98,202.8,122284483.40000001,-6.1806146997628493E-2,123630590.90000001,202.8,-6.1780104712041942E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,7599.7,5876.3,1723.4,7599.7,"New York",{"$f":"VLOOKUP(AV5,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O5,AW5),CONCATENATE(M5,AW5))","v":"AreaERegion1"},null,null,"Region3",21,{"$f":"MAX(IF(AW:AW=BA5,AG:AG))","v":0.19701395650762743},{"$f":"INDEX(B:B,MATCH(BC5,AG:AG,0))","v":"CHS Pineville"},"North Carolina"]
["4743676","Wellspan Surgery and Rehab Hospital","Not Applicable: Standalone Property","2016-12-31","York","17403",1,"1960",100,"Whole Building","Whole Building",146000,{"$f":"VLOOKUP(L6,Table2[#All],2,TRUE)","v":"AreaB"},103.78,{"$f":"VLOOKUP(N6,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",3822066.1,319958.5,"Not Available",3822067,177994.1961,38863.39360000001,"Not Available",51,211.2,30840310.600000001,0.13898011401351912,30511361,213.8,0.12591986917416184,"Not Available","Not Available",431329.03,2.95,"Not Available","Not Available",0,0,0,0,2266.6,945.4,1321.2,2266.6,"Pennsylvania",{"$f":"VLOOKUP(AV6,Table3[#All],2,FALSE)","v":"Region2"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O6,AW6),CONCATENATE(M6,AW6))","v":"AreaBRegion2"},null,null,"Region4",2,{"$f":"MAX(IF(AW:AW=BA6,AG:AG))","v":7.6627218934911173E-2},"UF Health Shands Cancer Hospital","Florida"]
["1721339","University of Arkansas for Medical Sciences","Not Applicable: Standalone Property","2009-12-31","Little Rock","72205",42,"1955",100,"Whole Building","Not Available",3732417,{"$f":"VLOOKUP(L7,Table2[#All],2,TRUE)","v":"AreaF"},470,{"$f":"VLOOKUP(N7,Table1[#All],2,TRUE)","v":"BedC"},8,"No","Not Available","Not Available",150376277.5,-9115871,"Not Available",150376300,4988564.1911599999,-291205.41717000026,"Not Available",13,245.4,936250066.60000002,-1.7709865699693784E-2,967441246.79999995,244.5,0.21230670103092777,"Not Available","Not Available",12134907.5,3.18,"Not Available","Not Available",0,0,0,0,79417.100000000006,26496.7,52920.5,79417.100000000006,"Arkansas",{"$f":"VLOOKUP(AV7,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O7,AW7),CONCATENATE(M7,AW7))","v":"AreaFRegion7"},null,null,"Region5",36,{"$f":"MAX(IF(AW:AW=BA7,AG:AG))","v":0.29347284504235166},"Barnesville Hospital","Ohio"]
["3297548","University Hospital","Not Applicable: Standalone Property","2017-12-31","Madison","537921525",1,"1979",100,"Whole Building","Whole Building",1738623,{"$f":"VLOOKUP(L8,Table2[#All],2,TRUE)","v":"AreaF"},679,{"$f":"VLOOKUP(N8,Table1[#All],2,TRUE)","v":"BedD"},5,"No","Not Available","Not Available",44288251.799999997,776433.70000000298,"Not Available",44288260,"Not Available",{"$error":"#VALUE!"},"Not Available",22,307.89999999999998,535283479.30000001,0.11072329052880296,539968776.5,310.8,0.11123820417500709,"Not Available",40441.199999999997,6122813.0099999998,3.52,198712.68,0.11,0,0,0,0,57318.9,0,57318.9,57318.9,"Wisconsin",{"$f":"VLOOKUP(AV8,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O8,AW8),CONCATENATE(M8,AW8))","v":"AreaFRegion6"},null,null,"Region6",9,{"$f":"MAX(IF(AW:AW=BA8,AG:AG))","v":0.14055793991416318},"Aurora Medical Center - Summit","Wisconsin"]
["4431897","UF Health Shands Cancer Hospital","Not Applicable: Standalone Property","2017-12-31","Gainesville","32608",2,"1958",100,"Whole Building","Not Available",546365,{"$f":"VLOOKUP(L9,Table2[#All],2,TRUE)","v":"AreaE"},345,{"$f":"VLOOKUP(N9,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",16906964.899999999,167960,"Not Available",16906970,11898.00006,-1268.9995099999996,"Not Available",16,318.2,232353138.59999999,5.0039446972629173E-2,232353133,312.10000000000002,7.6627218934911173E-2,"Not Available","Not Available",4828291.42,6.61,"Not Available","Not Available",0,0,0,0,"Not Available",63.2,"Not Available",0,"Florida",{"$f":"VLOOKUP(AV9,Table3[#All],2,FALSE)","v":"Region4"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O9,AW9),CONCATENATE(M9,AW9))","v":"AreaERegion4"},"BedDAreaERegion5",null,"Region7",27,{"$f":"MAX(IF(AW:AW=BA9,AG:AG))","v":0.32246849196001737},"Memorial Hermann Katy Hospital","Texas"]
[1159992,"Thompson Health Main Campus","Not Applicable: Standalone Property","2007-12-31","Canandaigua",14424,3,1969,85,"Whole Building","Not Available",381540,{"$f":"VLOOKUP(L10,Table2[#All],2,TRUE)","v":"AreaD"},307.10000000000002,{"$f":"VLOOKUP(N10,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",7932641.0999999996,252768.20000000019,"Not Available",7932642,552518.97979999997,-1465.9656999999424,"Not Available",78,215.8,82318072.700000003,6.3196586603560437E-2,91772627.5,214.9,6.0751748251748276E-2,"Not Available",24088.799999999999,1231121.5900000001,3.23,81231.09,0.21,50350,25814,0,0,3999.5,2934.7,1064.8,3999.5,"New York",{"$f":"VLOOKUP(AV10,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O10,AW10),CONCATENATE(M10,AW10))","v":"AreaDRegion1"},null,null,"Region8",2,{"$f":"MAX(IF(AW:AW=BA10,AG:AG))","v":0.35117773019271897},"Russell Regional Hospital","Kansas"]
["28404","The Allen Hospital","Not Applicable: Standalone Property","2013-12-31","New York","10034",1,"1991",100,"Whole Building","Whole Building",308789,{"$f":"VLOOKUP(L11,Table2[#All],2,TRUE)","v":"AreaD"},206.9,{"$f":"VLOOKUP(N11,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",9084257.1999999993,1205042.9000000004,"Not Available",9084258,179537.0343,-26206.806600000011,"Not Available",86,158.5,48949192.700000003,2.9558342239438352E-2,51915421.299999997,158.30000000000001,5.6052474657125685E-2,"Not Available",17852.8,"Not Available","Not Available","Not Available","Not Available",0,0,0,0,3578.6,953.6,2625,3578.6,"New York",{"$f":"VLOOKUP(AV11,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O11,AW11),CONCATENATE(M11,AW11))","v":"AreaDRegion1"},null,null,"Region9",5,{"$f":"MAX(IF(AW:AW=BA11,AG:AG))","v":0.19090552724421792},"Canyon Vista Medical Center","Arizona"]
["28404","The Allen Hospital","Not Applicable: Standalone Property","2005-12-31","New York","10034",1,"1991",100,"Whole Building","Whole Building",308789,{"$f":"VLOOKUP(L12,Table2[#All],2,TRUE)","v":"AreaD"},206.9,{"$f":"VLOOKUP(N12,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",10019997.699999999,-631198.89999999851,"Not Available",10020000,217210.9749,-7953.9794999999867,"Not Available",73,181.1,55909333.899999999,-5.5684160415081153E-2,57784025,176.9,-4.5508274231678594E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,4049.1,1153.7,2895.4,4049.1,"New York",{"$f":"VLOOKUP(AV12,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O12,AW12),CONCATENATE(M12,AW12))","v":"AreaDRegion1"},null,null,"Region10",{"$f":"COUNTIF(AW:AW,BA12)","v":0},{"$f":"MAX(IF(AW:AW=BA12,AG:AG,BC11))","v":0.19090552724421792},"Canyon Vista Medical Center","Arizona"]
["1224637","Texas Children's Hospital West Tower","Not Applicable: Standalone Property","2012-12-31","Houston","77030",1,"1989",100,"Whole Building","Not Available",1118729,{"$f":"VLOOKUP(L13,Table2[#All],2,TRUE)","v":"AreaF"},771.9,{"$f":"VLOOKUP(N13,Table1[#All],2,TRUE)","v":"BedD"},2,"100% Yes","Not Available","Not Available",25846516,-365631,"Not Available",25846520,"Not Available",{"$error":"#VALUE!"},"Not Available",69,263.5,294782428.5,9.2817318144231858E-2,295261445.10000002,261.60000000000002,9.0086956521739051E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,"Not Available","Not Available",12130.8,0,"Texas",{"$f":"VLOOKUP(AV13,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O13,AW13),CONCATENATE(M13,AW13))","v":"AreaFRegion7"}]
["1224637","Texas Children's Hospital West Tower","Not Applicable: Standalone Property","2011-12-31","Houston","77030",1,"1989",100,"Whole Building","Not Available",1118729,{"$f":"VLOOKUP(L14,Table2[#All],2,TRUE)","v":"AreaF"},771.9,{"$f":"VLOOKUP(N14,Table1[#All],2,TRUE)","v":"BedD"},2,"100% Yes","Not Available","Not Available",25480885,828964.80000000075,"Not Available",25480890,"Not Available",{"$error":"#VALUE!"},"Not Available",61,290.5,324942742.39999998,4.9203826568307359E-2,321067671.39999998,287.5,6.0150375939849551E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,"Not Available","Not Available",13941.7,0,"Texas",{"$f":"VLOOKUP(AV14,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O14,AW14),CONCATENATE(M14,AW14))","v":"AreaFRegion7"}]
["4066168","Swedish Covenant Hospital","Swedish Covenant Hospital Campus","2014-12-31","Chicago","60625",0,"1999",100,"Whole Building","Not Available",607911,{"$f":"VLOOKUP(L15,Table2[#All],2,TRUE)","v":"AreaE"},312,{"$f":"VLOOKUP(N15,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",22827666.199999999,1038197.1000000015,"Not Available",22827670,687007.00084999995,40688.333459999994,"Not Available",31,241.1,146588706.5,4.9359072412700947E-2,149250471.5,240.6,4.5616818722729074E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,16606.8,3649,12957.8,16606.8,"Illinois",{"$f":"VLOOKUP(AV15,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O15,AW15),CONCATENATE(M15,AW15))","v":"AreaERegion5"}]
["2710504","St. Vincent Seton Specialty Hospital","Not Applicable: Standalone Property","2017-12-31","Indianapolis","462602478",1,"2001",100,"Whole Building","Whole Building",64422,{"$f":"VLOOKUP(L16,Table2[#All],2,TRUE)","v":"AreaB"},44.2,{"$f":"VLOOKUP(N16,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",2087999.9,53249.700000000186,"Not Available",2088000,50500.195469999999,2318.9040900000036,"Not Available",99,189,12174276,3.2855368380248023E-2,12175591.6,193.4,1.0235414534288638E-2,"Not Available","Not Available",185273.55,2.88,"Not Available","Not Available",0,0,0,0,1453.5,268.2,1185.2,1453.5,"Indiana",{"$f":"VLOOKUP(AV16,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O16,AW16),CONCATENATE(M16,AW16))","v":"AreaBRegion5"}]
["23140","St. Francis Hospital & Health Services","Not Applicable: Standalone Property","2005-12-31","Maryville","64468",1,"1968",100,"Whole Building","Not Available",173961,{"$f":"VLOOKUP(L17,Table2[#All],2,TRUE)","v":"AreaC"},154.5,{"$f":"VLOOKUP(N17,Table1[#All],2,TRUE)","v":"BedB"},1,"100% Yes","Not Available","Not Available",4601538.4000000004,-451524.90000000037,"Not Available",4601539,208698.63829999999,-28204.717799999984,"Not Available",95,209,36570314.799999997,-0.1353982521785673,37083725.5,210.7,-0.14262472885032529,"Not Available","Not Available",383715,2.19,"Not Available","Not Available",0,0,0,0,4494.8,1108.5,3386.3,4494.8,"Missouri",{"$f":"VLOOKUP(AV17,Table3[#All],2,FALSE)","v":"Region8"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O17,AW17),CONCATENATE(M17,AW17))","v":"AreaCRegion8"}]
["1161724","St. Francis Eastside","Not Applicable: Standalone Property","2013-12-31","Greenville","29615",1,"1990",100,"Whole Building","Whole Building",212190,{"$f":"VLOOKUP(L18,Table2[#All],2,TRUE)","v":"AreaC"},146.4,{"$f":"VLOOKUP(N18,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6190271.2999999998,159359.70000000019,"Not Available",6190272,159053.90536,-9148.5061700000078,"Not Available",90,175.6,37261875,-1.6542989991972113E-2,39956582.100000001,176.6,-1.6695451928612583E-2,"Not Available",11247.4,572651.76,2.7,62973.41,0.3,0,0,0,0,3136.9,862.3,2274.6,3136.9,"South Carolina",{"$f":"VLOOKUP(AV18,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O18,AW18),CONCATENATE(M18,AW18))","v":"AreaCRegion3"}]
["1161724","St. Francis Eastside","Not Applicable: Standalone Property","2012-12-31","Greenville","29615",1,"1990",100,"Whole Building","Whole Building",212190,{"$f":"VLOOKUP(L19,Table2[#All],2,TRUE)","v":"AreaC"},146.4,{"$f":"VLOOKUP(N19,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6349631,80832.400000000373,"Not Available",6349632,149905.39919,5411.9005999999936,"Not Available",90,172.7,36655483.700000003,2.9144786901417013E-2,39258094.100000001,173.7,2.415730337078658E-2,"Not Available",11848.5,537184.07999999996,2.5299999999999998,63206.080000000002,0.3,0,0,0,0,3129.4,796.2,2333.1999999999998,3129.4,"South Carolina",{"$f":"VLOOKUP(AV19,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O19,AW19),CONCATENATE(M19,AW19))","v":"AreaCRegion3"}]
["1160002","St. Elizabeth Ft. Thomas","Not Applicable: Standalone Property","2012-12-31","Ft. Thomas","41075",1,"1957",100,"Whole Building","Not Available",401774,{"$f":"VLOOKUP(L20,Table2[#All],2,TRUE)","v":"AreaD"},277.2,{"$f":"VLOOKUP(N20,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",12737897.199999999,31167.300000000745,"Not Available",12737900,603380.35199999996,-4760.6586999999126,"Not Available",21,258.39999999999998,103799745.8,-3.5746216688925195E-3,106465427.8,262.89999999999998,-1.505791505791497E-2,"Not Available","Not Available",915577.32,2.2799999999999998,"Not Available","Not Available",0,0,0,0,10095.4,3204.8,6890.6,10095.4,"Kentucky",{"$f":"VLOOKUP(AV20,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O20,AW20),CONCATENATE(M20,AW20))","v":"AreaDRegion3"}]
["1160343","St. Elizabeth Florence","Not Applicable: Standalone Property","2012-12-31","Florence","41042",1,"1978",100,"Whole Building","Not Available",389900,{"$f":"VLOOKUP(L21,Table2[#All],2,TRUE)","v":"AreaD"},269,{"$f":"VLOOKUP(N21,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",11017552.4,569474.90000000037,"Not Available",11017550,526694.7733,12078.328499999945,"Not Available",47,231.5,90261370.900000006,3.3730921006527199E-2,93117601.5,235.1,2.3671096345515018E-2,"Not Available","Not Available",789801.9,2.0299999999999998,"Not Available","Not Available",0,0,0,0,8757.5,2797.5,5959.9,8757.5,"Kentucky",{"$f":"VLOOKUP(AV21,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O21,AW21),CONCATENATE(M21,AW21))","v":"AreaDRegion3"}]
["2551208","South Sacramento Hospital Campus","Not Applicable: Standalone Property","2017-12-31","Sacramento","95823",14,"1985",100,"Whole Building","Whole Building",782909,{"$f":"VLOOKUP(L22,Table2[#All],2,TRUE)","v":"AreaE"},539.6,{"$f":"VLOOKUP(N22,Table1[#All],2,TRUE)","v":"BedD"},1,"100% Yes","Not Available","Not Available",18606853.199999999,2172534.1000000015,"Not Available",18606860,760366.03399999999,-47451.040000000037,"Not Available",85,178.2,139523194.19999999,1.876059365470413E-2,137466277.30000001,178.2,2.3026315789473777E-2,"Not Available",49315,2888301.26,3.69,111248,0.14000000000000001,0,0,0,0,8510.7000000000007,4038.7,4472,8510.7000000000007,"California",{"$f":"VLOOKUP(AV22,Table3[#All],2,FALSE)","v":"Region9"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O22,AW22),CONCATENATE(M22,AW22))","v":"AreaERegion9"}]
["1230980","Shriners Hospital for Children-Chicago","Not Applicable: Standalone Property","2013-12-31","Chicago","60707",1,"1981",100,"Whole Building","Not Available",196466,{"$f":"VLOOKUP(L23,Table2[#All],2,TRUE)","v":"AreaC"},60,{"$f":"VLOOKUP(N23,Table1[#All],2,TRUE)","v":"BedA"},0,"100% Yes","Not Available","Not Available",4893478.4000000004,375747,"Not Available",4893479,346719.53090000001,26196.262099999993,"Not Available",26,261.5,51368503.399999999,7.0592771832643925E-2,52096807,258.39999999999998,7.2505384063173167E-2,"Not Available","Not Available",624272.28,3.18,"Not Available","Not Available",0,0,0,0,4619.3,1841.6,2777.7,4619.3,"Illinois",{"$f":"VLOOKUP(AV23,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O23,AW23),CONCATENATE(M23,AW23))","v":"AreaCRegion5"}]
["1230980","Shriners Hospital for Children-Chicago","Not Applicable: Standalone Property","2009-12-31","Chicago","60707",1,"1981",100,"Whole Building","Not Available",196466,{"$f":"VLOOKUP(L24,Table2[#All],2,TRUE)","v":"AreaC"},60,{"$f":"VLOOKUP(N24,Table1[#All],2,TRUE)","v":"BedA"},0,"100% Yes","Not Available","Not Available",5444820.2999999998,150637.90000000037,"Not Available",5444821,338488.8236,44665.161599999992,"Not Available",9,266.8,52426611.5,8.675742783765085E-2,57247504.399999999,272.2,5.1237364935517567E-2,"Not Available",13172.4,816537.32,4.16,"Not Available","Not Available",0,0,0,0,4888.5,1797.9,3090.7,4888.5,"Illinois",{"$f":"VLOOKUP(AV24,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O24,AW24),CONCATENATE(M24,AW24))","v":"AreaCRegion5"}]
[17946,"Shriners Hospital for Children - Houston","Not Applicable: Standalone Property","2007-12-31","Houston",77030,1,1996,100,"Whole Building","Not Available",150562,{"$f":"VLOOKUP(L25,Table2[#All],2,TRUE)","v":"AreaC"},103.9,{"$f":"VLOOKUP(N25,Table1[#All],2,TRUE)","v":"BedB"},1,"100% Yes","Not Available","Not Available",2762146.7,76295.899999999907,"Not Available",2762147,2377.2419960000002,58.482024999999794,"Not Available",100,175.5,26426649.5,2.3610931886702161E-2,26774109.199999999,177.3,1.6891891891890932E-3,"Not Available","Not Available",507491.87,3.37,"Not Available","Not Available",314830,0,0,0,2166.6,12.6,2154,2166.6,"Texas",{"$f":"VLOOKUP(AV25,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O25,AW25),CONCATENATE(M25,AW25))","v":"AreaCRegion7"}]
["17946","Shriners Hospital for Children - Houston","Not Applicable: Standalone Property","2006-12-31","Houston","77030",1,"1996",100,"Whole Building","Not Available",150562,{"$f":"VLOOKUP(L26,Table2[#All],2,TRUE)","v":"AreaC"},103.9,{"$f":"VLOOKUP(N26,Table1[#All],2,TRUE)","v":"BedB"},1,"100% Yes","Not Available","Not Available",2838442.6,112493.10000000009,"Not Available",2838443,2435.724021,-153.90002099999992,"Not Available",100,179.8,27065695.800000001,2.8059696162788909E-2,27310776.399999999,177.6,4.103671706263496E-2,"Not Available",4232,"Not Available","Not Available",31432.04,0.21,314830,0,0,0,2221.6,12.9,2208.6999999999998,2221.6,"Texas",{"$f":"VLOOKUP(AV26,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O26,AW26),CONCATENATE(M26,AW26))","v":"AreaCRegion7"}]
["17946","Shriners Hospital for Children - Houston","Not Applicable: Standalone Property","2005-12-31","Houston","77030",1,"1996",100,"Whole Building","Not Available",150562,{"$f":"VLOOKUP(L27,Table2[#All],2,TRUE)","v":"AreaC"},103.9,{"$f":"VLOOKUP(N27,Table1[#All],2,TRUE)","v":"BedB"},1,"100% Yes","Not Available","Not Available",2950935.7,8653.8999999999069,"Not Available",2950936,2281.8240000000001,130.30198999999993,"Not Available",100,185,27847076.300000001,9.518755836894514E-3,28162193,185.2,5.3705692803437165E-3,"Not Available",4883,"Not Available","Not Available",35194.49,0.23,314830,0,0,0,2294.3000000000002,12.1,2282.1999999999998,2294.3000000000002,"Texas",{"$f":"VLOOKUP(AV27,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O27,AW27),CONCATENATE(M27,AW27))","v":"AreaCRegion7"}]
["1447046","Saint Thomas West Hospital","Not Applicable: Standalone Property","2012-12-31","Nashville","37202",6,"1974",100,"Whole Building","Whole Building",1152408,{"$f":"VLOOKUP(L28,Table2[#All],2,TRUE)","v":"AreaF"},756.1,{"$f":"VLOOKUP(N28,Table1[#All],2,TRUE)","v":"BedD"},3,"No","Not Available","Not Available",42007628.399999999,1294637.8000000045,"Not Available",42007630,1746793.9214699997,217441.34372000024,"Not Available",35,256.8,302109437.60000002,7.8796677223095135E-2,300650301.60000002,258.89999999999998,6.9708947179303024E-2,"Not Available","Not Available",4502894.82,3.83,"Not Available","Not Available",0,0,0,0,30946.3,9278.1,21668.2,30946.3,"Tennessee",{"$f":"VLOOKUP(AV28,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O28,AW28),CONCATENATE(M28,AW28))","v":"AreaFRegion3"}]
["2521570","Saint Thomas Rutherford Hospital","Not Applicable: Standalone Property","2013-12-31","Murfreesboro","37129",1,"2010",100,"Whole Building","Whole Building",556362,{"$f":"VLOOKUP(L29,Table2[#All],2,TRUE)","v":"AreaE"},383.9,{"$f":"VLOOKUP(N29,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",15830929.9,711022.69999999925,"Not Available",15830930,580653.41099999996,13431.406000000075,"Not Available",74,201.5,112080480.40000001,3.2534851174912116E-2,113322230.5,202.5,3.5714285714285712E-2,"Not Available","Not Available",1651209.5,2.97,"Not Available","Not Available",0,0,0,0,11647.9,3084.1,8563.7000000000007,11647.9,"Tennessee",{"$f":"VLOOKUP(AV29,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O29,AW29),CONCATENATE(M29,AW29))","v":"AreaERegion3"}]
["1466803","Saint Thomas Midtown Hospital (Baptist)","Not Applicable: Standalone Property","2013-12-31","Nashville","37203",4,"1950",100,"Whole Building","Whole Building",1820956,{"$f":"VLOOKUP(L30,Table2[#All],2,TRUE)","v":"AreaF"},683,{"$f":"VLOOKUP(N30,Table1[#All],2,TRUE)","v":"BedD"},2.5499999999999998,"No","Not Available","Not Available",42105005.200000003,2130473,"Not Available",42105010,1524933.9885100001,-63750.609829999972,"Not Available",92,162.6,296155694,3.0099797280494262E-3,305090128.89999998,163,1.3317191283292911E-2,"Not Available","Not Available",4133662.17,2.27,"Not Available","Not Available",0,0,0,0,30876.3,8099.7,22776.7,30876.3,"Tennessee",{"$f":"VLOOKUP(AV30,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O30,AW30),CONCATENATE(M30,AW30))","v":"AreaFRegion3"}]
["1466803","Saint Thomas Midtown Hospital (Baptist)","Not Applicable: Standalone Property","2012-12-31","Nashville","37203",4,"1950",100,"Whole Building","Whole Building",1820956,{"$f":"VLOOKUP(L31,Table2[#All],2,TRUE)","v":"AreaF"},683,{"$f":"VLOOKUP(N31,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",44235478.200000003,2987317.8999999985,"Not Available",44235480,1461183.3786800001,317311.15507999994,"Not Available",90,163.1,297049807.89999998,0.12367877213050588,303577482.69999999,165.2,0.11278195488721805,"Not Available","Not Available",4356764.29,2.39,"Not Available","Not Available",0,0,0,0,31690.2,7761,23929.200000000001,31690.2,"Tennessee",{"$f":"VLOOKUP(AV31,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O31,AW31),CONCATENATE(M31,AW31))","v":"AreaFRegion3"}]
["1466803","Saint Thomas Midtown Hospital (Baptist)","Not Applicable: Standalone Property","2011-12-31","Nashville","37203",4,"1950",100,"Whole Building","Whole Building",1820956,{"$f":"VLOOKUP(L32,Table2[#All],2,TRUE)","v":"AreaF"},683,{"$f":"VLOOKUP(N32,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",47222796.100000001,5246842.8999999985,"Not Available",47222800,1778494.53376,217343.66363999993,"Not Available",77,186.2,338973653.10000002,0.10468970806225104,347481859.89999998,186.2,9.7430925836161031E-2,"Not Available","Not Available",4878158.4800000004,2.68,"Not Available","Not Available",0,0,0,0,34991.599999999999,9446.4,25545.1,34991.599999999999,"Tennessee",{"$f":"VLOOKUP(AV32,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O32,AW32),CONCATENATE(M32,AW32))","v":"AreaFRegion3"}]
["1466803","Saint Thomas Midtown Hospital (Baptist)","Not Applicable: Standalone Property","2010-12-31","Nashville","37203",4,"1950",100,"Whole Building","Whole Building",1820956,{"$f":"VLOOKUP(L33,Table2[#All],2,TRUE)","v":"AreaF"},683,{"$f":"VLOOKUP(N33,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",52469639,1409616.799999997,"Not Available",52469650,1995838.1973999999,213166.20307000028,"Not Available",58,207.9,378610249.60000002,6.4551219351147243E-2,385474480,206.3,7.1139126519585691E-2,"Not Available","Not Available",5207183.34,2.86,"Not Available","Not Available",0,0,0,0,38984.199999999997,10600.8,28383.4,38984.199999999997,"Tennessee",{"$f":"VLOOKUP(AV33,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O33,AW33),CONCATENATE(M33,AW33))","v":"AreaFRegion3"}]
["4682536","Russell Regional Hospital","Russell Regional Hospital","2016-12-31","Russell","67665",2,"1941",100,"Whole Building","Whole Building",80623,{"$f":"VLOOKUP(L34,Table2[#All],2,TRUE)","v":"AreaB"},47,{"$f":"VLOOKUP(N34,Table1[#All],2,TRUE)","v":"BedA"},0,"100% Yes","Not Available","Not Available",730895.4,484816.70000000007,"Not Available",730895.5,48349.224069999997,21944.085220000008,"Not Available",100,90.9,7328737.7999999998,0.34432189194192075,7318702.9000000004,90.9,0.35117773019271897,"Not Available",1540.4,116453.71,1.44,25437.05,0.32,0,0,0,0,728.3,256.8,471.5,728.3,"Kansas",{"$f":"VLOOKUP(AV34,Table3[#All],2,FALSE)","v":"Region8"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O34,AW34),CONCATENATE(M34,AW34))","v":"AreaBRegion8"}]
["1477187","Providence Park Hospital","Not Applicable: Standalone Property","2017-12-31","Novi","48374",1,"2007",100,"Whole Building","Whole Building",840083,{"$f":"VLOOKUP(L35,Table2[#All],2,TRUE)","v":"AreaE"},347.8,{"$f":"VLOOKUP(N35,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",24790076.899999999,911681.5,"Not Available",24790080,675590.16200000001,18570.851999999955,"Not Available",42,181.1,152142769,3.1619415845629481E-2,154256637.59999999,183.1,0.27941755214482489,"Not Available","Not Available",1939303.32,2.31,"Not Available","Not Available",0,0,0,0,17968.5,3588.4,14380.1,17968.5,"Michigan",{"$f":"VLOOKUP(AV35,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O35,AW35),CONCATENATE(M35,AW35))","v":"AreaERegion5"}]
["1447047","Providence Hospital - Mobile","Not Applicable: Standalone Property","2017-12-31","Mobile","36685",4,"1987",100,"Whole Building","Whole Building",693259,{"$f":"VLOOKUP(L36,Table2[#All],2,TRUE)","v":"AreaE"},478.3,{"$f":"VLOOKUP(N36,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",1826999.8,54000.09999999986,"Not Available",1827000,259055.50380490001,-60794.494309100002,"Not Available",100,46.4,32139274.5,-0.22462981003791049,32176525.399999999,48.6,-0.28571428571428586,"Not Available","Not Available",437983.39,0.63,"Not Available","Not Available",0,0,0,0,1376,1376,0,1376,"Alabama",{"$f":"VLOOKUP(AV36,Table3[#All],2,FALSE)","v":"Region4"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O36,AW36),CONCATENATE(M36,AW36))","v":"AreaERegion4"}]
["19887","Park Ridge Health","Not Applicable: Standalone Property","2011-12-31","Hendersonville","28792",1,"1985",100,"Whole Building","Not Available",197042,{"$f":"VLOOKUP(L37,Table2[#All],2,TRUE)","v":"AreaC"},136,{"$f":"VLOOKUP(N37,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",7068651.0999999996,83369.800000000745,"Not Available",7068652,283759.00030000001,32980,"Not Available",26,267.5,52701140.399999999,6.1579326073370674E-2,52069718,266.7,4.9536707056308027E-2,"Not Available",10203.200000000001,591510.96,3,30371.66,0.15,0,0,0,0,4119.8999999999996,1522.5,2597.4,4119.8999999999996,"North Carolina",{"$f":"VLOOKUP(AV37,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O37,AW37),CONCATENATE(M37,AW37))","v":"AreaCRegion3"}]
["4158243","Owensboro Health Regional Hospital","Not Applicable: Standalone Property","2017-12-31","Owensboro","42303",1,"2012",100,"Whole Building","Not Available",786990,{"$f":"VLOOKUP(L38,Table2[#All],2,TRUE)","v":"AreaE"},455,{"$f":"VLOOKUP(N38,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",22467220.300000001,2877678.1999999993,"Not Available",22467220,1037270.691,134628.24400000006,"Not Available","Not Available",228.8,180385234.09999999,0.11431158781929814,"Not Available",233.2,9.4368932038834993E-2,"Not Available","Not Available",2702786.88,3.43,"Not Available","Not Available",0,0,0,0,17663.099999999999,5509.4,12153.6,17663.099999999999,"Kentucky",{"$f":"VLOOKUP(AV38,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O38,AW38),CONCATENATE(M38,AW38))","v":"AreaERegion3"}]
["28402","NYP Cornell (East Campus)","NYP Cornell (East Campus)","2013-12-31","New York","10021",12,"1932",100,"Whole Building","Whole Building",2971874,{"$f":"VLOOKUP(L39,Table2[#All],2,TRUE)","v":"AreaF"},2050.6,{"$f":"VLOOKUP(N39,Table1[#All],2,TRUE)","v":"BedD"},3,"No","Not Available","Not Available",26271182.899999999,3276726.9000000022,"Not Available",26271190,12801880.604180001,-249142.93966000155,"Not Available",70,309.5,919842924.39999998,-1.3756182635836724E-2,934186013.89999998,309.5,-1.3756960366852238E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",1304260,0,0,0,45873.7,69550.7,-23677,45873.7,"New York",{"$f":"VLOOKUP(AV39,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O39,AW39),CONCATENATE(M39,AW39))","v":"AreaFRegion1"}]
["28400","NYP Columbia (West Campus)","NYP Columbia (West Campus)","2013-12-31","New York","10032",12,"1969",100,"Whole Building","Whole Building",3889181,{"$f":"VLOOKUP(L40,Table2[#All],2,TRUE)","v":"AreaF"},2683.5,{"$f":"VLOOKUP(N40,Table1[#All],2,TRUE)","v":"BedD"},9,"No","Not Available","Not Available",101464098.7,-70170.70000000298,"Not Available",101464100,9050832.4900000002,12660.650000000373,"Not Available",8,331.2,1288255036.5999999,-0.10411731256041754,1291585175.5999999,331.3,-8.4096858638743416E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",763384,0,0,0,80167.600000000006,50958.6,29209.1,80167.600000000006,"New York",{"$f":"VLOOKUP(AV40,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O40,AW40),CONCATENATE(M40,AW40))","v":"AreaFRegion1"}]
[28400,"NYP Columbia (West Campus)","NYP Columbia (West Campus)","2007-12-31","New York",10032,12,1969,100,"Whole Building","Whole Building",3889181,{"$f":"VLOOKUP(L41,Table2[#All],2,TRUE)","v":"AreaF"},2683.5,{"$f":"VLOOKUP(N41,Table1[#All],2,TRUE)","v":"BedD"},9,"100% Yes","Not Available","Not Available",92146534.099999994,8677674.8000000119,"Not Available",92146550,7118939.6260000002,-954981.70500000007,"Not Available",60,239.3,930524666.10000002,0.17624890106172769,925474024.10000002,243.6,0.13525026624068157,"Not Available",329033.7,"Not Available","Not Available","Not Available","Not Available",763384,0,0,0,61081.599999999999,63083,-2001.4,61081.599999999999,"New York",{"$f":"VLOOKUP(AV41,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O41,AW41),CONCATENATE(M41,AW41))","v":"AreaFRegion1"}]
["28400","NYP Columbia (West Campus)","NYP Columbia (West Campus)","2006-12-31","New York","10032",12,"1969",100,"Whole Building","Whole Building",3889181,{"$f":"VLOOKUP(L42,Table2[#All],2,TRUE)","v":"AreaF"},2683.5,{"$f":"VLOOKUP(N42,Table1[#All],2,TRUE)","v":"BedD"},9,"100% Yes","Not Available","Not Available",100824208.90000001,-11359234.900000006,"Not Available",100824200,6163957.9214000003,-508405.77280000038,"Not Available",23,290.5,1129618725.0999999,-7.6963796822152764E-2,1130930201.5999999,281.7,-4.682274247491626E-2,"Not Available",340540.3,"Not Available","Not Available","Not Available","Not Available",763384,0,0,0,76719.399999999994,63760.3,12959.1,76719.399999999994,"New York",{"$f":"VLOOKUP(AV42,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O42,AW42),CONCATENATE(M42,AW42))","v":"AreaFRegion1"}]
["28400","NYP Columbia (West Campus)","NYP Columbia (West Campus)","2005-12-31","New York","10032",12,"1969",100,"Whole Building","Whole Building",3889181,{"$f":"VLOOKUP(L43,Table2[#All],2,TRUE)","v":"AreaF"},2683.5,{"$f":"VLOOKUP(N43,Table1[#All],2,TRUE)","v":"BedD"},9,"100% Yes","Not Available","Not Available",89464974,1170061,"Not Available",89464980,5655552.1486,-542067.3786000004,"Not Available",43,269.7,1048892013.3,0.25540376756690286,1043154544.2,269.10000000000002,0.25724537675959147,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",763384,0,0,0,71529.3,64086.8,7442.5,71529.3,"New York",{"$f":"VLOOKUP(AV43,Table3[#All],2,FALSE)","v":"Region1"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O43,AW43),CONCATENATE(M43,AW43))","v":"AreaFRegion1"}]
["2793034","Midland Memorial Hospital","Midland Memorial Hospital","2016-12-31","Midland","79701",2,"1950",100,"Whole Building","Not Available",869102,{"$f":"VLOOKUP(L44,Table2[#All],2,TRUE)","v":"AreaE"},474,{"$f":"VLOOKUP(N44,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",22562009.600000001,997654.69999999925,"Not Available",22562010,748164.94449999998,63299.88432000007,"Not Available",83,174.7,151798080.59999999,6.0260397633294167E-2,153461929.40000001,173.4,6.4724919093851127E-2,"Not Available",50531.5,1568349.18,1.8,489169.57,0.56000000000000005,0,0,0,0,14351.4,3973.9,10377.6,14351.4,"Texas",{"$f":"VLOOKUP(AV44,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O44,AW44),CONCATENATE(M44,AW44))","v":"AreaERegion7"}]
["2793034","Midland Memorial Hospital","Midland Memorial Hospital","2015-12-31","Midland","79701",2,"1950",100,"Whole Building","Not Available",869102,{"$f":"VLOOKUP(L45,Table2[#All],2,TRUE)","v":"AreaE"},279.19,{"$f":"VLOOKUP(N45,Table1[#All],2,TRUE)","v":"BedB"},2,"No","Not Available","Not Available",23559664.300000001,3251053.8999999985,"Not Available",23559670,811464.82882000005,259731.25078,"Not Available",74,185.9,161532067.19999999,0.1866371342466529,164543190.5,185.4,0.19250871080139367,"Not Available",51096.2,1721533.57,1.98,497578.2,0.56999999999999995,0,0,0,0,15146.5,4310.1000000000004,10836.5,15146.5,"Texas",{"$f":"VLOOKUP(AV45,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O45,AW45),CONCATENATE(M45,AW45))","v":"AreaERegion7"}]
["2793034","Midland Memorial Hospital","Midland Memorial Hospital","2014-12-31","Midland","79701",2,"1950",100,"Whole Building","Not Available",869102,{"$f":"VLOOKUP(L46,Table2[#All],2,TRUE)","v":"AreaE"},263,{"$f":"VLOOKUP(N46,Table1[#All],2,TRUE)","v":"BedB"},2,"No","Not Available","Not Available",26810718.199999999,1327304.4000000022,"Not Available",26810720,1071196.0796000001,41369.53816999984,"Not Available",41,228.5,198597789.5,4.1810143745686361E-2,201168257.09999999,229.6,3.9732329569217899E-2,"Not Available",61534,2412036.38,2.78,563729.11,0.65,0,0,0,0,18021.400000000001,5689.6,12331.8,18021.400000000001,"Texas",{"$f":"VLOOKUP(AV46,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O46,AW46),CONCATENATE(M46,AW46))","v":"AreaERegion7"}]
["4458873","Methodist Hospital","Not Applicable: Standalone Property","2017-12-31","Henderson","42420",1,"1946",85,"Whole Building","Not Available",493454,{"$f":"VLOOKUP(L47,Table2[#All],2,TRUE)","v":"AreaD"},205,{"$f":"VLOOKUP(N47,Table1[#All],2,TRUE)","v":"BedB"},1,"100% Yes","Not Available","Not Available",14225356.800000001,1575418.7999999989,"Not Available",14225360,601965.03890000004,111557.77419999999,"Not Available",50,220.4,108733427.09999999,0.13196957446241073,110261141.3,224.1,0.13105854982551371,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,10892.5,3197.3,7695.2,10892.5,"Kentucky",{"$f":"VLOOKUP(AV47,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O47,AW47),CONCATENATE(M47,AW47))","v":"AreaDRegion3"}]
["3909588","Mercy Willard Hospital","Not Applicable: Standalone Property","2016-12-31","Willard","44890",1,"2012",100,"Whole Building","Not Available",105387,{"$f":"VLOOKUP(L48,Table2[#All],2,TRUE)","v":"AreaB"},25,{"$f":"VLOOKUP(N48,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",2781359.7,84486.899999999907,"Not Available",2781360,108155.48940000001,40708.960099999982,"Not Available",80,192.7,20305549.5,0.17673690271091239,20274194.800000001,195.3,0.15491129381220245,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,2153.3000000000002,574.5,1578.8,2153.3000000000002,"Ohio",{"$f":"VLOOKUP(AV48,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O48,AW48),CONCATENATE(M48,AW48))","v":"AreaBRegion5"}]
["3909588","Mercy Willard Hospital","Not Applicable: Standalone Property","2015-12-31","Willard","44890",1,"2012",100,"Whole Building","Not Available",105387,{"$f":"VLOOKUP(L49,Table2[#All],2,TRUE)","v":"AreaB"},25,{"$f":"VLOOKUP(N49,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",2865846.6,158576.69999999972,"Not Available",2865847,148864.44949999999,42182.580000000016,"Not Available",52,234,24664714.800000001,0.16174945214688866,25115142.399999999,231.1,0.16146589259796815,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,2417.4,790.7,1626.8,2417.4,"Ohio",{"$f":"VLOOKUP(AV49,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O49,AW49),CONCATENATE(M49,AW49))","v":"AreaBRegion5"}]
["1577320","Memorial Hermann Sugar Land Hospital","Not Applicable: Standalone Property","2017-12-31","Sugar Land","77479",1,"2005",100,"Whole Building","Not Available",361204,{"$f":"VLOOKUP(L50,Table2[#All],2,TRUE)","v":"AreaD"},166.9,{"$f":"VLOOKUP(N50,Table1[#All],2,TRUE)","v":"BedB"},1.1599999999999999,"No","Not Available","Not Available",9743513.9000000004,-455500.40000000037,"Not Available",9743515,126313.2251,-12294.839800000002,"Not Available",100,127,45876195.899999999,-6.4597053441576152E-2,45898169.299999997,124.1,0.10397111913357404,"Not Available",26163.7,693193.3,1.92,162841.09,0.45,0,0,0,0,5152.5,670.9,4481.6000000000004,5152.5,"Texas",{"$f":"VLOOKUP(AV50,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O50,AW50),CONCATENATE(M50,AW50))","v":"AreaDRegion7"}]
["1577320","Memorial Hermann Sugar Land Hospital","Not Applicable: Standalone Property","2011-12-31","Sugar Land","77479",1,"2005",100,"Whole Building","Not Available",241914,{"$f":"VLOOKUP(L51,Table2[#All],2,TRUE)","v":"AreaC"},166.9,{"$f":"VLOOKUP(N51,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",8004248.7999999998,245847,"Not Available",8004250,79970.003020000004,29129.995880000002,"Not Available",90,146,35307500.700000003,9.6054632047800223E-2,57786091.5,144.5,0.12899336949969864,"Not Available",24404,690090.37,2.85,120182,0.5,0,0,0,0,4106.3999999999996,424.8,3681.6,4106.3999999999996,"Texas",{"$f":"VLOOKUP(AV51,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O51,AW51),CONCATENATE(M51,AW51))","v":"AreaCRegion7"}]
["1577320","Memorial Hermann Sugar Land Hospital","Not Applicable: Standalone Property","2010-12-31","Sugar Land","77479",1,"2005",100,"Whole Building","Not Available",235892.6,{"$f":"VLOOKUP(L52,Table2[#All],2,TRUE)","v":"AreaC"},166.9,{"$f":"VLOOKUP(N52,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",8250095.7999999998,-146501,"Not Available",8250097,109099.99890000001,31830.003499999992,"Not Available",77,165.6,39059330.299999997,6.4278389953406997E-2,66548622.899999999,165.9,9.0460526315789477E-2,"Not Available",18226,779058.39,3.3,105778,0.45,0,0,0,0,4374.2,579.5,3794.7,4374.2,"Texas",{"$f":"VLOOKUP(AV52,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O52,AW52),CONCATENATE(M52,AW52))","v":"AreaCRegion7"}]
["1781181","Memorial Hermann Southwest Heart and Vascular Institute","Memorial Hermann Southwest Campus","2014-12-31","Houston","77074",1,"2007",100,"Whole Building","Whole Building",165383,{"$f":"VLOOKUP(L53,Table2[#All],2,TRUE)","v":"AreaC"},114.1,{"$f":"VLOOKUP(N53,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",3929731.3,471412.40000000037,"Not Available",3929732,"Not Available",{"$error":"#VALUE!"},"Not Available",94,134.1,22182051.5,0.18140477242788133,22705682.399999999,135.4,0.17839805825242722,"Not Available",9001.7999999999993,343727.25,2.08,75808.160000000003,0.46,0,0,0,0,2390.1,0,2390.1,2390.1,"Texas",{"$f":"VLOOKUP(AV53,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O53,AW53),CONCATENATE(M53,AW53))","v":"AreaCRegion7"}]
["1781181","Memorial Hermann Southwest Heart and Vascular Institute","Memorial Hermann Southwest Campus","2011-12-31","Houston","77074",1,"2007",100,"Whole Building","Whole Building",165383,{"$f":"VLOOKUP(L54,Table2[#All],2,TRUE)","v":"AreaC"},114.1,{"$f":"VLOOKUP(N54,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",5275934.3,471179.79999999981,"Not Available",5275935,1522.9999823000001,933.99998669999991,"Not Available",36,218.4,36121790.5,6.7941541600551658E-2,35646551,216.7,7.9048023799405107E-2,"Not Available",14995,528633.44999999995,3.2,121150,0.73,0,0,0,0,3627.8,8.1,3619.8,3627.8,"Texas",{"$f":"VLOOKUP(AV54,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O54,AW54),CONCATENATE(M54,AW54))","v":"AreaCRegion7"}]
["1781181","Memorial Hermann Southwest Heart and Vascular Institute","Memorial Hermann Southwest Campus","2010-12-31","Houston","77074",1,"2007",100,"Whole Building","Whole Building",165383,{"$f":"VLOOKUP(L55,Table2[#All],2,TRUE)","v":"AreaC"},114.1,{"$f":"VLOOKUP(N55,Table1[#All],2,TRUE)","v":"BedB"},0,"No","Not Available","Not Available",5747114.0999999996,282766.80000000075,"Not Available",5747115,2456.999969,382.99987899999996,"Not Available",19,234.3,38754855.100000001,9.0794247601790418E-2,38988932.399999999,235.3,8.5858585858585731E-2,"Not Available",13696,635645.25,3.84,87505,0.53,0,0,0,0,3911.4,13.1,3898.4,3911.4,"Texas",{"$f":"VLOOKUP(AV55,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O55,AW55),CONCATENATE(M55,AW55))","v":"AreaCRegion7"}]
["1460283","Memorial Hermann Southeast Hospital","Not Applicable: Standalone Property","2014-12-31","Houston","77089",1,"1986",100,"Whole Building","Not Available",520885,{"$f":"VLOOKUP(L56,Table2[#All],2,TRUE)","v":"AreaE"},272,{"$f":"VLOOKUP(N56,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",14898637.699999999,1165871.9000000004,"Not Available",14898640,324224.19699999999,140466.73000000004,"Not Available",93,159.80000000000001,83256577.799999997,0.17796616957941222,92131069.099999994,160.4,0.17447246525990737,"Not Available",34180.5,1292843.6100000001,2.48,296939.13,0.56999999999999995,0,0,0,0,8574.9,1722.1,6852.7,8574.9,"Texas",{"$f":"VLOOKUP(AV56,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O56,AW56),CONCATENATE(M56,AW56))","v":"AreaERegion7"}]
["1460283","Memorial Hermann Southeast Hospital","Not Applicable: Standalone Property","2010-12-31","Houston","77089",1,"1986",100,"Whole Building","Not Available",520885,{"$f":"VLOOKUP(L57,Table2[#All],2,TRUE)","v":"AreaE"},272,{"$f":"VLOOKUP(N57,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",16395483.4,806524.90000000037,"Not Available",16395490,517840.03100000002,91428.963999999978,"Not Available",78,206.8,107725399.2,9.9437752042645072E-2,113721617.5,206.8,9.8124727431312689E-2,"Not Available",32172,1722703.12,3.31,212372.01,0.41,0,0,0,0,10291.700000000001,2750.5,7541.2,10291.700000000001,"Texas",{"$f":"VLOOKUP(AV57,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O57,AW57),CONCATENATE(M57,AW57))","v":"AreaERegion7"}]
["1747727","Memorial Hermann Northeast Hospital","Not Applicable: Standalone Property","2011-12-31","Humble","77338",1,"1977",100,"Whole Building","Not Available",397201,{"$f":"VLOOKUP(L58,Table2[#All],2,TRUE)","v":"AreaD"},274.10000000000002,{"$f":"VLOOKUP(N58,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",13219336.800000001,567980.89999999851,"Not Available",13219340,132630.0012,48069.999199999991,"Not Available",94,146.9,58367382.600000001,0.10358945542818181,61699511.200000003,146.30000000000001,0.11225728155339805,"Not Available",17617.599999999999,1150807.04,2.9,157439.25,0.4,0,0,0,0,5754,704.5,5049.5,5754,"Texas",{"$f":"VLOOKUP(AV58,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O58,AW58),CONCATENATE(M58,AW58))","v":"AreaDRegion7"}]
["1747727","Memorial Hermann Northeast Hospital","Not Applicable: Standalone Property","2010-12-31","Humble","77338",1,"1977",100,"Whole Building","Not Available",397201,{"$f":"VLOOKUP(L59,Table2[#All],2,TRUE)","v":"AreaD"},274.10000000000002,{"$f":"VLOOKUP(N59,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",13787317.699999999,1219729.4000000004,"Not Available",13787320,180700.00039999999,192069.97040000002,"Not Available",86,163.9,65112333.799999997,0.26410982526349586,70001235.299999997,164.8,0.25965858041329731,"Not Available",14767.9,1323710.99,3.33,64238.97,0.16,0,0,0,0,6226.2,959.8,5266.5,6226.2,"Texas",{"$f":"VLOOKUP(AV59,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O59,AW59),CONCATENATE(M59,AW59))","v":"AreaDRegion7"}]
["1458017","Memorial Hermann Katy Hospital","Not Applicable: Standalone Property","2016-12-31","Katy","77494",1,"2005",100,"Whole Building","Not Available",472711,{"$f":"VLOOKUP(L60,Table2[#All],2,TRUE)","v":"AreaD"},215.4,{"$f":"VLOOKUP(N60,Table1[#All],2,TRUE)","v":"BedB"},2,"No","Not Available","Not Available",14913258.4,-3337157.4000000004,"Not Available",14913260,170288.06719999999,-49375.814299999984,"Not Available",95,143.69999999999999,67912850.700000003,-0.31642403589056706,69345941.900000006,144.30000000000001,8.7863463969658523E-2,"Not Available",28522.2,1053330.27,2.23,270531.26,0.56999999999999995,0,0,0,0,6601,904.5,5696.5,6601,"Texas",{"$f":"VLOOKUP(AV60,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O60,AW60),CONCATENATE(M60,AW60))","v":"AreaDRegion7"}]
["1458017","Memorial Hermann Katy Hospital","Not Applicable: Standalone Property","2010-12-31","Katy","77494",1,"2005",100,"Whole Building","Not Available",312189,{"$f":"VLOOKUP(L61,Table2[#All],2,TRUE)","v":"AreaD"},215.4,{"$f":"VLOOKUP(N61,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",11190267.1,1671231.4000000004,"Not Available",11190270,102690.00128,177240.00472,"Not Available",92,155.19999999999999,48450196,0.32592381117534752,72817736.099999994,155.9,0.32246849196001737,"Not Available",20779,996674.01,3.19,206934,0.66,0,0,0,0,4819.8999999999996,545.4,4274.3999999999996,4819.8999999999996,"Texas",{"$f":"VLOOKUP(AV61,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O61,AW61),CONCATENATE(M61,AW61))","v":"AreaDRegion7"}]
["4682251","McLaren Bay Region","Not Applicable: Standalone Property","2017-12-31","Bay City","48708",1,"1977",85,"Whole Building","Whole Building",521184,{"$f":"VLOOKUP(L62,Table2[#All],2,TRUE)","v":"AreaE"},399,{"$f":"VLOOKUP(N62,Table1[#All],2,TRUE)","v":"BedC"},3,"No","Not Available","Not Available",11698676,4445880.1999999993,"Not Available",11698680,802053.71299999999,16616.217000000062,"Not Available",82,230.5,120121258.7,0.1228966292899733,120121255,235.2,0.12271540469973902,"Not Available","Not Available",1188849.95,2.2799999999999998,"Not Available","Not Available",0,0,0,0,11046.2,4260.1000000000004,6786.1,11046.2,"Michigan",{"$f":"VLOOKUP(AV62,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O62,AW62),CONCATENATE(M62,AW62))","v":"AreaERegion5"}]
["3425772","Latrobe Hospital","Not Applicable: Standalone Property","2017-12-31","Latrobe","15650",1,"1942",100,"Whole Building","Whole Building",410844,{"$f":"VLOOKUP(L63,Table2[#All],2,TRUE)","v":"AreaD"},331.5,{"$f":"VLOOKUP(N63,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",15604496,872299.80000000075,"Not Available",15604500,781350.46799999999,54367.052999999956,"Not Available",7,275.60000000000002,131377593.5,6.0182826574471271E-2,133376768.5,281.89999999999998,5.0841750841750917E-2,"Not Available","Not Available",1360157.55,2.85,"Not Available","Not Available",0,0,0,0,13007.8,4150.1000000000004,8857.7000000000007,13007.8,"Pennsylvania",{"$f":"VLOOKUP(AV63,Table3[#All],2,FALSE)","v":"Region2"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O63,AW63),CONCATENATE(M63,AW63))","v":"AreaDRegion2"}]
["2551213","Kaiser Hospital Walnut Creek","Not Applicable: Standalone Property","2016-12-31","Walnut Creek","94596",9,"1984",100,"Whole Building","Whole Building",624499,{"$f":"VLOOKUP(L64,Table2[#All],2,TRUE)","v":"AreaE"},422.6,{"$f":"VLOOKUP(N64,Table1[#All],2,TRUE)","v":"BedC"},3,"No","Not Available","Not Available",19234951.399999999,1721703.4000000022,"Not Available",19234950,507566.02299999999,105159.99700000003,"Not Available",87,186.4,116386264.5,0.12344372338027262,116140736.7,189.2,0.10670443814919746,"Not Available",22884,2253018.63,3.61,182855.91,0.28999999999999998,0,0,0,0,7318.9,2695.9,4623,7318.9,"California",{"$f":"VLOOKUP(AV64,Table3[#All],2,FALSE)","v":"Region9"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O64,AW64),CONCATENATE(M64,AW64))","v":"AreaERegion9"}]
["4384557","Indiana Regional Medical Center","Not Applicable: Standalone Property","2017-12-31","Indiana","15701",1,"1914",100,"Whole Building","Whole Building",374000,{"$f":"VLOOKUP(L65,Table2[#All],2,TRUE)","v":"AreaD"},231.49,{"$f":"VLOOKUP(N65,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",9714203.4000000004,134093.90000000037,"Not Available",9714205,506217.67300000001,-10743.990600000019,"Not Available",61,224,83766633.200000003,-7.4187896719263629E-3,83766637.400000006,227.6,-1.3357079252003563E-2,"Not Available","Not Available",980231.48,2.62,"Not Available","Not Available",0,0,0,0,6046.7,2688.8,3358,6046.7,"Pennsylvania",{"$f":"VLOOKUP(AV65,Table3[#All],2,FALSE)","v":"Region2"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O65,AW65),CONCATENATE(M65,AW65))","v":"AreaDRegion2"}]
["5017435","Hopkins County Memorial Hospital","Not Applicable: Standalone Property","2016-12-31","Sulphur Springs","75482",1,"1967",100,"Whole Building","Not Available",197244,{"$f":"VLOOKUP(L66,Table2[#All],2,TRUE)","v":"AreaC"},96,{"$f":"VLOOKUP(N66,Table1[#All],2,TRUE)","v":"BedA"},1,"100% Yes","Not Available","Not Available",6482255.4000000004,631758,"Not Available",6482256,237740.00589999999,89029.967300000018,"Not Available",48,232.7,45891458.600000001,0.19418002952554145,46442202.799999997,234.1,0.19108500345542498,"Not Available","Not Available",667000.43999999994,3.38,"Not Available","Not Available",0,0,0,0,4244.3,1262.8,2981.6,4244.3,"Texas",{"$f":"VLOOKUP(AV66,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O66,AW66),CONCATENATE(M66,AW66))","v":"AreaCRegion7"}]
["4000724","Heart Hospital","Not Applicable: Standalone Property","2016-12-31","Lafayette","70508",1,"2003",100,"Whole Building","Whole Building",59966,{"$f":"VLOOKUP(L67,Table2[#All],2,TRUE)","v":"AreaB"},35,{"$f":"VLOOKUP(N67,Table1[#All],2,TRUE)","v":"BedA"},0,"No","Not Available","Not Available",3912563.2,160479,"Not Available",3912564,82050.678899999999,10569.707399999985,"Not Available",1,359.4,21554735.100000001,6.9282226035873015E-2,21547542.199999999,358.6,7.2426280393171227E-2,"Not Available","Not Available",394989.62,6.59,"Not Available","Not Available",0,0,0,0,2662.7,435.8,2226.9,2662.7,"Louisiana",{"$f":"VLOOKUP(AV67,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O67,AW67),CONCATENATE(M67,AW67))","v":"AreaBRegion7"}]
["4000724","Heart Hospital","Not Applicable: Standalone Property","2015-12-31","Lafayette","70508",1,"2003",100,"Whole Building","Whole Building",59966,{"$f":"VLOOKUP(L68,Table2[#All],2,TRUE)","v":"AreaB"},35,{"$f":"VLOOKUP(N68,Table1[#All],2,TRUE)","v":"BedA"},0,"No","Not Available","Not Available",4073042.2,688559.89999999944,"Not Available",4073043,92620.386299999984,13446.654600000023,"Not Available",1,386.2,23159260.199999999,0.13756348076287681,23190222.100000001,386.6,0.13666815542652966,"Not Available",3053.3,403118.55,6.72,6167.62,0.1,0,0,0,0,2810.2,492,2318.3000000000002,2810.2,"Louisiana",{"$f":"VLOOKUP(AV68,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O68,AW68),CONCATENATE(M68,AW68))","v":"AreaBRegion7"}]
["3606142","Hardin Memorial Hospital","Not Applicable: Standalone Property","2014-12-31","Elizabethtown","42701",7,"1954",100,"Whole Building","Not Available",500000,{"$f":"VLOOKUP(L69,Table2[#All],2,TRUE)","v":"AreaE"},345,{"$f":"VLOOKUP(N69,Table1[#All],2,TRUE)","v":"BedC"},2,"100% Yes","Not Available","Not Available",21149248.899999999,-581741.09999999776,"Not Available",21149250,798258.79418700002,22551.468577999971,"Not Available",25,304,151987125.5,1.7749281858415555E-3,152234569.30000001,299.89999999999998,1.6398819285011482E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,15680.6,4239.8999999999996,11440.7,15680.6,"Kentucky",{"$f":"VLOOKUP(AV69,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O69,AW69),CONCATENATE(M69,AW69))","v":"AreaERegion3"}]
["22023","Good Samaritan Hospital","Not Applicable: Standalone Property","2012-12-31","Cincinnati","45220",9,"1915",100,"Whole Building","Whole Building",1267494,{"$f":"VLOOKUP(L70,Table2[#All],2,TRUE)","v":"AreaF"},657,{"$f":"VLOOKUP(N70,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",35490770.299999997,-8328.5999999940395,"Not Available",35490770,1480333.311,6709.0069999999832,"Not Available",66,212.6,269531642.10000002,2.2190242725854833E-3,275392632.10000002,216.8,-8.8413215449046328E-3,"Not Available",92367.8,3299575.45,2.6,621333.87,0.49,343000,0,0,0,7892.7,7892.7,0,7892.7,"Ohio",{"$f":"VLOOKUP(AV70,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O70,AW70),CONCATENATE(M70,AW70))","v":"AreaFRegion5"}]
["22023","Good Samaritan Hospital","Not Applicable: Standalone Property","2011-12-31","Cincinnati","45220",9,"1915",100,"Whole Building","Whole Building",1267494,{"$f":"VLOOKUP(L71,Table2[#All],2,TRUE)","v":"AreaF"},661,{"$f":"VLOOKUP(N71,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",35482441.700000003,-1011998.700000003,"Not Available",35482450,1487042.318,173440.70699999994,"Not Available",67,213.1,270131069.5,4.8515187587608886E-2,274943457.89999998,214.9,3.5890533871691339E-2,"Not Available",96564.2,3635574.61,2.87,"Not Available","Not Available",343000,0,0,0,7925.2,7925.2,0,7925.2,"Ohio",{"$f":"VLOOKUP(AV71,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O71,AW71),CONCATENATE(M71,AW71))","v":"AreaFRegion5"}]
["22023","Good Samaritan Hospital","Not Applicable: Standalone Property","2009-12-31","Cincinnati","45220",9,"1915",100,"Whole Building","Whole Building",1252720.8,{"$f":"VLOOKUP(L72,Table2[#All],2,TRUE)","v":"AreaF"},882.9,{"$f":"VLOOKUP(N72,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",33983927.600000001,1979690.299999997,"Not Available",33983930,1677806.8470000001,98855.187999999849,"Not Available",58,227.2,284577315.80000001,5.4975208808414951E-2,298910334.5,228.2,5.4681027340513742E-2,"Not Available","Not Available",4627046.29,3.69,"Not Available","Not Available",343000,0,0,0,8974.2000000000007,8974.2000000000007,0,8974.2000000000007,"Ohio",{"$f":"VLOOKUP(AV72,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O72,AW72),CONCATENATE(M72,AW72))","v":"AreaFRegion5"}]
["4230654","Geisinger Community Medical Center","Not Applicable: Standalone Property","2016-12-31","Scranton","18510",1,"1969",100,"Whole Building","Whole Building",519859,{"$f":"VLOOKUP(L73,Table2[#All],2,TRUE)","v":"AreaE"},358.7,{"$f":"VLOOKUP(N73,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",16438616.199999999,-345701.69999999925,"Not Available",16438620,953175.88100000005,-479823.59380000003,"Not Available",24,291.2,151406153.5,-0.48082791096779781,150789378.30000001,289.3,-2.6250443419652481E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,10745.2,5062.8,5682.4,10745.2,"Pennsylvania",{"$f":"VLOOKUP(AV73,Table3[#All],2,FALSE)","v":"Region2"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O73,AW73),CONCATENATE(M73,AW73))","v":"AreaERegion2"}]
["3197807","Excela Westmoreland Hospital","Not Applicable: Standalone Property","2014-12-31","Greensburg","15601",1,"1922",100,"Whole Building","Whole Building",506619,{"$f":"VLOOKUP(L74,Table2[#All],2,TRUE)","v":"AreaE"},386.8,{"$f":"VLOOKUP(N74,Table1[#All],2,TRUE)","v":"BedC"},3,"No","Not Available","Not Available",17506645.899999999,898823.30000000075,"Not Available",17506650,701047.01699999999,107407.15800000005,"Not Available",45,256.3,129837384.8,9.6122470943904664E-2,130863870.2,255.5,0.10913528591352863,"Not Available","Not Available",1760010.26,3.47,"Not Available","Not Available",0,0,0,0,13661,3723.6,9937.4,13661,"Pennsylvania",{"$f":"VLOOKUP(AV74,Table3[#All],2,FALSE)","v":"Region2"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O74,AW74),CONCATENATE(M74,AW74))","v":"AreaERegion2"}]
["1252717","CHS Pineville","Not Applicable: Standalone Property","2016-12-31","Charlotte","28210",2,"1987",100,"Whole Building","Whole Building",506495,{"$f":"VLOOKUP(L75,Table2[#All],2,TRUE)","v":"AreaE"},235,{"$f":"VLOOKUP(N75,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",15928933.199999999,1017606,"Not Available",15928940,518920.48196,88444.715599999996,"Not Available",67,209.8,106241574.8,0.12842291209397483,109524551.40000001,212.2,0.14227970897332262,"Not Available",30179.8,1365856.68,2.7,280682.90999999997,0.55000000000000004,0,0,0,0,8609.4,2756.2,5853.2,8609.4,"North Carolina",{"$f":"VLOOKUP(AV75,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O75,AW75),CONCATENATE(M75,AW75))","v":"AreaERegion3"}]
["1252717","CHS Pineville","Not Applicable: Standalone Property","2015-12-31","Charlotte","28210",2,"1987",100,"Whole Building","Whole Building",506495,{"$f":"VLOOKUP(L76,Table2[#All],2,TRUE)","v":"AreaE"},235,{"$f":"VLOOKUP(N76,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",16946539.199999999,3064020.1999999993,"Not Available",16946540,607365.19756,260918.14125999995,"Not Available",43,240.7,121895786.7,0.21736011673004133,127424482.2,247.4,0.19701395650762743,"Not Available",31731.599999999999,1509575.47,2.98,286142.01,0.56000000000000005,0,0,0,0,9700.7999999999993,3473.7,6227.1,9700.7999999999993,"North Carolina",{"$f":"VLOOKUP(AV76,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O76,AW76),CONCATENATE(M76,AW76))","v":"AreaERegion3"}]
["1252717","CHS Pineville","Not Applicable: Standalone Property","2014-12-31","Charlotte","28210",2,"1987",100,"Whole Building","Whole Building",506495,{"$f":"VLOOKUP(L77,Table2[#All],2,TRUE)","v":"AreaE"},235,{"$f":"VLOOKUP(N77,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",20010559.399999999,2446218.200000003,"Not Available",20010560,868283.33881999995,169535.29925000004,"Not Available",8,307.5,155749520.69999999,0.14226060402164414,165054298,308.10000000000002,0.14345287739783144,"Not Available",35968.800000000003,1851659.82,3.66,363539.5,0.72,0,0,0,0,12012.7,4659.7,7353,12012.7,"North Carolina",{"$f":"VLOOKUP(AV77,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O77,AW77),CONCATENATE(M77,AW77))","v":"AreaERegion3"}]
["2732380","CHS Lincoln","Not Applicable: Standalone Property","2015-12-31","Linconton","28092",2,"2008",100,"Whole Building","Whole Building",178770,{"$f":"VLOOKUP(L78,Table2[#All],2,TRUE)","v":"AreaC"},101,{"$f":"VLOOKUP(N78,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",5783992.4000000004,435176.79999999981,"Not Available",5783993,178491.29319999999,34308.708900000027,"Not Available",76,211.8,37855685.299999997,0.11050335932750037,39251726.799999997,210.9,0.10975094976783453,"Not Available",17148.7,438304,2.4500000000000002,316683.27,1.77,0,0,0,0,3093.6,968.2,2125.4,3093.6,"North Carolina",{"$f":"VLOOKUP(AV78,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O78,AW78),CONCATENATE(M78,AW78))","v":"AreaCRegion3"}]
["2732380","CHS Lincoln","Not Applicable: Standalone Property","2014-12-31","Linconton","28092",2,"2008",100,"Whole Building","Whole Building",178770,{"$f":"VLOOKUP(L79,Table2[#All],2,TRUE)","v":"AreaC"},101,{"$f":"VLOOKUP(N79,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6219169.2000000002,304153.20000000019,"Not Available",6219170,212800.00210000001,57740.004600000015,"Not Available",56,238.1,42558547.799999997,0.13694616494691683,44642940.700000003,236.9,0.14259862468331524,"Not Available",14024.3,535568.43999999994,3,290087.7,1.62,0,0,0,0,3419.9,1134.5999999999999,2285.3000000000002,3419.9,"North Carolina",{"$f":"VLOOKUP(AV79,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O79,AW79),CONCATENATE(M79,AW79))","v":"AreaCRegion3"}]
["3772794","CHS Blue Ridge Morganton","Not Applicable: Standalone Property","2014-12-31","Morganton","28655",1,"1979",100,"Whole Building","Whole Building",325273,{"$f":"VLOOKUP(L80,Table2[#All],2,TRUE)","v":"AreaD"},181,{"$f":"VLOOKUP(N80,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",12405431.199999999,182017.10000000149,"Not Available",12405430,535169.98,58340.021000000066,"Not Available",10,301.8,98164942.200000003,4.0415072314368562E-2,100152382.90000001,301.10000000000002,4.1998090995863789E-2,"Not Available",9222.2999999999993,1402459.14,4.3099999999999996,25126.5,0.08,0,0,0,0,7573.2,3014.8,4558.3999999999996,7573.2,"North Carolina",{"$f":"VLOOKUP(AV80,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O80,AW80),CONCATENATE(M80,AW80))","v":"AreaDRegion3"}]
["4568549","CHRISTUS SPOHN Hospital Kleberg","Not Applicable: Standalone Property","2017-12-31","Kingsville","78363",6,"1970",95,"Not Available","Not Available",157140,{"$f":"VLOOKUP(L81,Table2[#All],2,TRUE)","v":"AreaC"},140.22,{"$f":"VLOOKUP(N81,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6514192.0999999996,225790.40000000037,"Not Available",6514193,137399.9993,20059.999799999991,"Not Available",33,228.9,35966426.100000001,7.1662227422967531E-2,35686329.200000003,232.2,7.0456365092073744E-2,"Not Available",14119.7,499591.05,3.18,50229.05,0.32,0,0,0,0,3726.1,729.8,2996.3,3726.1,"Texas",{"$f":"VLOOKUP(AV81,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O81,AW81),CONCATENATE(M81,AW81))","v":"AreaCRegion7"}]
["4567806","CHRISTUS SANTA ROSA Hospital New Braunfels","Not Applicable: Standalone Property","2017-12-31","New Braunfels","78130",1,"1970",95,"Whole Building","Not Available",197220,{"$f":"VLOOKUP(L82,Table2[#All],2,TRUE)","v":"AreaC"},132,{"$f":"VLOOKUP(N82,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",5090367.4000000004,705504.19999999925,"Not Available",5090368,326339.99560000002,24790.030999999959,"Not Available",67,253.5,50002335.100000001,8.9020144631703366E-2,50024234.399999999,252.6,8.6437613019891515E-2,"Not Available",18235.5,494797.44,2.5099999999999998,60904.93,0.31,0,0,0,0,4074.7,1733.3,2341.4,4074.7,"Texas",{"$f":"VLOOKUP(AV82,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O82,AW82),CONCATENATE(M82,AW82))","v":"AreaCRegion7"}]
["5037152","Canyon Vista Medical Center","Not Applicable: Standalone Property","2017-12-31","Sierra Vista","85635",1,"2015",100,"Whole Building","Whole Building",188000,{"$f":"VLOOKUP(L83,Table2[#All],2,TRUE)","v":"AreaC"},100,{"$f":"VLOOKUP(N83,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6229859.2999999998,408020,"Not Available",6229860,179490.00080000001,73579.994500000001,"Not Available",78,208.5,39205282.600000001,0.18246444266234579,39157068.299999997,206.4,0.19090552724421792,"Not Available","Not Available",818998.37,4.3600000000000003,"Not Available","Not Available",0,0,0,0,3917.7,953.4,2964.3,3917.7,"Arizona",{"$f":"VLOOKUP(AV83,Table3[#All],2,FALSE)","v":"Region9"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O83,AW83),CONCATENATE(M83,AW83))","v":"AreaCRegion9"}]
["3759857","Camden Clark Medical Center","Not Applicable: Standalone Property","2016-12-31","Parkersburg","26102",0,"1970",100,"Whole Building","Not Available",463939,{"$f":"VLOOKUP(L84,Table2[#All],2,TRUE)","v":"AreaD"},310.5,{"$f":"VLOOKUP(N84,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",16237301.1,300013.70000000112,"Not Available",16237300,742744.95900000003,-23202.249000000069,"Not Available",14,279.5,129676174.09999999,-1.0099566772432516E-2,129256604.2,283.3,0.11634435433562074,"Not Available","Not Available",1565942.03,3.38,"Not Available","Not Available",0,0,0,0,13161.9,3945.1,9216.9,13161.9,"West Virginia",{"$f":"VLOOKUP(AV84,Table3[#All],2,FALSE)","v":"Region3"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O84,AW84),CONCATENATE(M84,AW84))","v":"AreaDRegion3"}]
["6331862","CA-AHCL-15630 18th Avenue","Not Applicable: Standalone Property","2017-12-31","Clearlake","95422",1,"2014",100,"Whole Building","Whole Building",53281,{"$f":"VLOOKUP(L85,Table2[#All],2,TRUE)","v":"AreaB"},25,{"$f":"VLOOKUP(N85,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",2194461.7999999998,142677.10000000009,"Not Available",2194462,"Not Available",{"$error":"#VALUE!"},"Not Available",66,271.7,14475471,1.2063840206965807E-2,14475471.1,273.60000000000002,1.0130246020260329E-2,"Not Available",3013,498235.88,9.35,19795.93,0.37,0,0,0,0,1028.5,501.1,527.4,1028.5,"California",{"$f":"VLOOKUP(AV85,Table3[#All],2,FALSE)","v":"Region9"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O85,AW85),CONCATENATE(M85,AW85))","v":"AreaBRegion9"}]
["5788159","BHMC-HS","Not Applicable: Standalone Property","2017-12-31","Heber Springs","72543",1,"2007",100,"Whole Building","Not Available",62986,{"$f":"VLOOKUP(L86,Table2[#All],2,TRUE)","v":"AreaB"},25,{"$f":"VLOOKUP(N86,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",2401794.7999999998,219919.80000000028,"Not Available",2401795,55720.000699999997,14670.006100000006,"Not Available",73,218.6,13766925,0.13872162745775665,13918885.6,222.5,0.12608012568735269,"Not Available","Not Available",222169.13,3.53,"Not Available","Not Available",0,0,0,0,1213.4000000000001,296,917.4,1213.4000000000001,"Arkansas",{"$f":"VLOOKUP(AV86,Table3[#All],2,FALSE)","v":"Region7"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O86,AW86),CONCATENATE(M86,AW86))","v":"AreaBRegion7"}]
["18251","Bethesda North Hospital","Not Applicable: Standalone Property","2012-12-31","Cincinnati","45242",2,"1969",100,"Whole Building","Not Available",907635,{"$f":"VLOOKUP(L87,Table2[#All],2,TRUE)","v":"AreaE"},626.29999999999995,{"$f":"VLOOKUP(N87,Table1[#All],2,TRUE)","v":"BedD"},1,"No","Not Available","Not Available",22356008.199999999,217287.40000000224,"Not Available",22356010,1248128.9820000001,45903.277000000002,"Not Available",75,222.1,201588407.5,2.576700760251547E-2,190387493.80000001,221.3,2.2526501766784425E-2,"Not Available",46080.7,2322033,2.56,340113.03,0.37,0,0,0,0,19356.3,6666.3,12690,19356.3,"Ohio",{"$f":"VLOOKUP(AV87,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O87,AW87),CONCATENATE(M87,AW87))","v":"AreaERegion5"}]
["18251","Bethesda North Hospital","Not Applicable: Standalone Property","2011-12-31","Cincinnati","45242",2,"1969",100,"Whole Building","Not Available",907635,{"$f":"VLOOKUP(L88,Table2[#All],2,TRUE)","v":"AreaE"},626.29999999999995,{"$f":"VLOOKUP(N88,Table1[#All],2,TRUE)","v":"BedD"},1,"No","Not Available","Not Available",22573295.600000001,723973.09999999776,"Not Available",22573300,1294032.2590000001,63663.256999999983,"Not Available",72,228,206920119.80000001,4.095596834511351E-2,195368953.69999999,226.4,2.8326180257510707E-2,"Not Available",47876.800000000003,2593061.06,2.86,321566,0.35,0,0,0,0,19723.5,6910.1,12813.4,19723.5,"Ohio",{"$f":"VLOOKUP(AV88,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O88,AW88),CONCATENATE(M88,AW88))","v":"AreaERegion5"}]
["18251","Bethesda North Hospital","Not Applicable: Standalone Property","2010-12-31","Cincinnati","45242",2,"1969",100,"Whole Building","Not Available",907635,{"$f":"VLOOKUP(L89,Table2[#All],2,TRUE)","v":"AreaE"},626.29999999999995,{"$f":"VLOOKUP(N89,Table1[#All],2,TRUE)","v":"BedD"},1,"No","Not Available","Not Available",23297268.699999999,346271.60000000149,"Not Available",23297270,1357695.5160000001,-22233.363000000129,"Not Available",66,237.7,215756642,-4.4649347472550723E-3,202862911.5,233,1.6877637130801686E-2,"Not Available",53500.7,3063562.96,3.38,330870,0.36,0,0,0,0,20472.599999999999,7248.2,13224.3,20472.599999999999,"Ohio",{"$f":"VLOOKUP(AV89,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O89,AW89),CONCATENATE(M89,AW89))","v":"AreaERegion5"}]
["18251","Bethesda North Hospital","Not Applicable: Standalone Property","2009-12-31","Cincinnati","45242",2,"1969",100,"Whole Building","Not Available",907635,{"$f":"VLOOKUP(L90,Table2[#All],2,TRUE)","v":"AreaE"},626.29999999999995,{"$f":"VLOOKUP(N90,Table1[#All],2,TRUE)","v":"BedD"},1,"No","Not Available","Not Available",23643540.300000001,369550.19999999925,"Not Available",23643540,1335462.1529999999,-117733.52799999993,"Not Available",61,236.7,214797584.80000001,-5.3060261552949704E-2,205929875.80000001,237,-5.4270462633451901E-2,"Not Available","Not Available",3384372.01,3.73,"Not Available","Not Available",0,0,0,0,20557.2,7136.3,13420.9,20557.2,"Ohio",{"$f":"VLOOKUP(AV90,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O90,AW90),CONCATENATE(M90,AW90))","v":"AreaERegion5"}]
["3921779","Barnesville Hospital","Not Applicable: Standalone Property","2016-12-31","Barnesville","43713",1,"1952",100,"Whole Building","Not Available",70117,{"$f":"VLOOKUP(L91,Table2[#All],2,TRUE)","v":"AreaB"},25.27,{"$f":"VLOOKUP(N91,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",1812172.7,172461.90000000014,"Not Available",1812173,33127.727539,-883.15063999999984,"Not Available",100,135.4,9495906.6999999993,5.0032363842620171E-2,9466014.5,141.80000000000001,0.29347284504235166,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,1204.5999999999999,176,1028.7,1204.5999999999999,"Ohio",{"$f":"VLOOKUP(AV91,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O91,AW91),CONCATENATE(M91,AW91))","v":"AreaBRegion5"}]
["1507801","Aurora St. Lukes South Shore","Not Applicable: Standalone Property","2012-12-31","Cudahy","53110",1,"1959",100,"Whole Building","Not Available",363262,{"$f":"VLOOKUP(L92,Table2[#All],2,TRUE)","v":"AreaD"},248.8,{"$f":"VLOOKUP(N92,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",7937504.5999999996,-367763.39999999944,"Not Available",7937506,466981.96409999998,55794.008100000035,"Not Available",60,203.1,73780965.400000006,5.5368555701989612E-2,75050730.099999994,214.4,1.1981566820276471E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,6986,2480.4,4505.6000000000004,6986,"Wisconsin",{"$f":"VLOOKUP(AV92,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O92,AW92),CONCATENATE(M92,AW92))","v":"AreaDRegion6"}]
["1229817","Aurora Sinai Medical Center","Not Applicable: Standalone Property","2017-12-31","Milwaukee","53233",5,"1972",100,"Whole Building","Whole Building",956244,{"$f":"VLOOKUP(L93,Table2[#All],2,TRUE)","v":"AreaE"},386,{"$f":"VLOOKUP(N93,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",18349149.100000001,2361293.6999999993,"Not Available",18349150,47850.834509999993,23073.834970000004,"Not Available",89,144.69999999999999,138642833.59999999,0.14027582665646743,139796627.80000001,147.1,0.13368669022379279,"Not Available","Not Available",2371435.48,2.4700000000000002,"Not Available","Not Available",0,0,0,0,15400.7,254.2,15146.5,15400.7,"Wisconsin",{"$f":"VLOOKUP(AV93,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O93,AW93),CONCATENATE(M93,AW93))","v":"AreaERegion6"}]
["1756414","Aurora Sheboygan Memorial Medical Center","Not Applicable: Standalone Property","2017-12-31","Sheboygan","53083",1,"1972",100,"Whole Building","Whole Building",285978,{"$f":"VLOOKUP(L94,Table2[#All],2,TRUE)","v":"AreaC"},185,{"$f":"VLOOKUP(N94,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6082044.4000000004,176509.79999999981,"Not Available",6082045,373860.14577,52439.050310000021,"Not Available",82,203.3,58137952.600000001,9.136888319764247E-2,58564977.600000001,208,9.0113735783027102E-2,"Not Available",13230.8,644423.27,2.25,57800.73,0.2,500000,50000,0,0,6618.3,1985.8,4632.6000000000004,6618.3,"Wisconsin",{"$f":"VLOOKUP(AV94,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O94,AW94),CONCATENATE(M94,AW94))","v":"AreaCRegion6"}]
["1756414","Aurora Sheboygan Memorial Medical Center","Not Applicable: Standalone Property","2012-12-31","Sheboygan","53083",1,"1972",100,"Whole Building","Whole Building",285978,{"$f":"VLOOKUP(L95,Table2[#All],2,TRUE)","v":"AreaC"},185,{"$f":"VLOOKUP(N95,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6397795.2000000002,29489.099999999627,"Not Available",6397796,537286.02300000004,64973.993999999948,"Not Available",45,264.2,75557882.200000003,8.0310925064389568E-2,76936965.799999997,264.7,7.641311933007687E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",500000,50000,0,0,7726.9,2853.8,4873.1000000000004,7726.9,"Wisconsin",{"$f":"VLOOKUP(AV95,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O95,AW95),CONCATENATE(M95,AW95))","v":"AreaCRegion6"}]
["1266379","Aurora Medical Center- Oshkosh","Not Applicable: Standalone Property","2010-12-31","Oshkosh","54904",1,"2003",100,"Whole Building","Not Available",474288,{"$f":"VLOOKUP(L96,Table2[#All],2,TRUE)","v":"AreaD"},84,{"$f":"VLOOKUP(N96,Table1[#All],2,TRUE)","v":"BedA"},1,"No","Not Available","Not Available",10990244.4,257632.19999999925,"Not Available",10990250,513080.96230000001,59944.021999999997,"Not Available",67,188.3,89286495.700000003,6.8759122339038012E-2,89228960.700000003,192.9,4.1252485089463137E-2,"Not Available",7809.9,"Not Available","Not Available","Not Available","Not Available",0,0,0,0,11131.9,2760.8,8371.1,11131.9,"Wisconsin",{"$f":"VLOOKUP(AV96,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O96,AW96),CONCATENATE(M96,AW96))","v":"AreaDRegion6"}]
["2396333","Aurora Medical Center Summit","Not Applicable: Standalone Property","2017-12-31","Summit","53066",1,"2009",100,"Whole Building","Not Available",826320,{"$f":"VLOOKUP(L97,Table2[#All],2,TRUE)","v":"AreaE"},117,{"$f":"VLOOKUP(N97,Table1[#All],2,TRUE)","v":"BedB"},2,"100% Yes","Not Available","Not Available",13518302.699999999,861218.10000000149,"Not Available",13518300,701079.32499999995,24599.037000000011,"Not Available",92,140.69999999999999,116232386.90000001,4.438334340192062E-2,117400294.7,144.1,4.0612516644474003E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,11397.2,3723.8,7673.5,11397.2,"Wisconsin",{"$f":"VLOOKUP(AV97,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O97,AW97),CONCATENATE(M97,AW97))","v":"AreaERegion6"}]
["4864726","Aurora Medical Center - Summit","Not Applicable: Standalone Property","2016-12-31","Summit","53066",1,"2009",100,"Whole Building","Whole Building",826320,{"$f":"VLOOKUP(L98,Table2[#All],2,TRUE)","v":"AreaE"},117,{"$f":"VLOOKUP(N98,Table1[#All],2,TRUE)","v":"BedB"},2,"100% Yes","Not Available","Not Available",14257431.4,36258.299999998882,"Not Available",14257430,726349.93400000001,99601.050000000047,"Not Available",93,146.80000000000001,121281355.40000001,7.6761731619254592E-2,121281363.59999999,149.9,6.4294631710361941E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,11951,3858,8093,11951,"Wisconsin",{"$f":"VLOOKUP(AV98,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O98,AW98),CONCATENATE(M98,AW98))","v":"AreaERegion6"}]
["4864726","Aurora Medical Center - Summit","Not Applicable: Standalone Property","2015-12-31","Summit","53066",1,"2009",100,"Whole Building","Whole Building",826320,{"$f":"VLOOKUP(L99,Table2[#All],2,TRUE)","v":"AreaE"},117,{"$f":"VLOOKUP(N99,Table1[#All],2,TRUE)","v":"BedB"},1.43,"100% Yes","Not Available","Not Available",14293689.699999999,944103.60000000149,"Not Available",14293690,825950.98400000005,258576.07699999993,"Not Available",87,159,131365173.59999999,0.18124004625836487,134495876.09999999,160.19999999999999,0.14055793991416318,"Not Available",17685,"Not Available","Not Available",108639.99,0.13,0,0,0,0,12500.6,4387,8113.6,12500.6,"Wisconsin",{"$f":"VLOOKUP(AV99,Table3[#All],2,FALSE)","v":"Region6"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O99,AW99),CONCATENATE(M99,AW99))","v":"AreaERegion6"}]
["1432853","Advocate Trinity Hospital","Not Applicable: Standalone Property","2017-12-31","Chicago","60617",1,"1960",100,"Whole Building","Whole Building",367669,{"$f":"VLOOKUP(L100,Table2[#All],2,TRUE)","v":"AreaD"},205,{"$f":"VLOOKUP(N100,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",9059394.3000000007,587615.69999999925,"Not Available",9059395,538611.65339999995,40041.244800000102,"Not Available",65,230.6,84771822.599999994,6.619310915540122E-2,85342003.200000003,240.5,6.0179757717858558E-2,"Not Available","Not Available",1252956.44,3.41,"Not Available","Not Available",0,0,0,0,8003.3,2860.8,5142.3999999999996,8003.3,"Illinois",{"$f":"VLOOKUP(AV100,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O100,AW100),CONCATENATE(M100,AW100))","v":"AreaDRegion5"}]
["1432853","Advocate Trinity Hospital","Not Applicable: Standalone Property","2009-12-31","Chicago","60617",1,"1960",100,"Whole Building","Whole Building",367669,{"$f":"VLOOKUP(L101,Table2[#All],2,TRUE)","v":"AreaD"},254.7,{"$f":"VLOOKUP(N101,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",10405497,-758913.90000000037,"Not Available",10405500,645704.05599999998,39206.944000000018,"Not Available",40,272.2,100073965.5,1.312831397181359E-2,97307656.299999997,278.5,2.9616724738675958E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,9336.2000000000007,3429.6,5906.5,9336.2000000000007,"Illinois",{"$f":"VLOOKUP(AV101,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O101,AW101),CONCATENATE(M101,AW101))","v":"AreaDRegion5"}]
["1432655","Advocate Lutheran General Hospital","Not Applicable: Standalone Property","2012-12-31","Park Ridge","60068",0,"1959",100,"Whole Building","Whole Building",1694182,{"$f":"VLOOKUP(L102,Table2[#All],2,TRUE)","v":"AreaF"},1087.2,{"$f":"VLOOKUP(N102,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",56611167.200000003,-1268198.1000000015,"Not Available",56611170,1995971.0072999999,131051.98099999991,"Not Available",41,219.6,392754426.69999999,2.1861505585941878E-2,399598926,227.7,-1.2449977767896766E-2,"Not Available","Not Available",5133746.3,2.87,"Not Available","Not Available",17900,105492,0,0,42736,10601.6,32134.5,42736,"Illinois",{"$f":"VLOOKUP(AV102,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O102,AW102),CONCATENATE(M102,AW102))","v":"AreaFRegion5"}]
["1432655","Advocate Lutheran General Hospital","Not Applicable: Standalone Property","2011-12-31","Park Ridge","60068",0,"1959",100,"Whole Building","Whole Building",1694182,{"$f":"VLOOKUP(L103,Table2[#All],2,TRUE)","v":"AreaF"},1087.2,{"$f":"VLOOKUP(N103,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",55342969.100000001,1394050.1999999955,"Not Available",55342980,2127022.9882999999,-84726.455899999943,"Not Available",38,224.5,401532532.39999998,-9.341359293317638E-3,413819853.89999998,224.9,-1.9954648526077125E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",17900,105492,0,0,42712.2,11297.6,31414.6,42712.2,"Illinois",{"$f":"VLOOKUP(AV103,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O103,AW103),CONCATENATE(M103,AW103))","v":"AreaFRegion5"}]
["1252266","Advocate Illinois Masonic Medical Center","Not Applicable: Standalone Property","2017-12-31","Chicago","60657",15,"1908",100,"Whole Building","Whole Building",1335452,{"$f":"VLOOKUP(L104,Table2[#All],2,TRUE)","v":"AreaF"},397,{"$f":"VLOOKUP(N104,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",21354143.199999999,1854609.8000000007,"Not Available",21354150,1166326.3662776002,74241.937575659715,"Not Available",99,141.9,189492982.09999999,6.7662751303327703E-2,191387896.40000001,146.5,6.3897763578274758E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,18316.3,6194.9,12121.4,18316.3,"Illinois",{"$f":"VLOOKUP(AV104,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O104,AW104),CONCATENATE(M104,AW104))","v":"AreaFRegion5"}]
["1252266","Advocate Illinois Masonic Medical Center","Not Applicable: Standalone Property","2015-12-31","Chicago","60657",15,"1908",100,"Whole Building","Whole Building",1288091.5,{"$f":"VLOOKUP(L105,Table2[#All],2,TRUE)","v":"AreaF"},397,{"$f":"VLOOKUP(N105,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",22472284.699999999,-354448.5,"Not Available",22472290,1263560.5462040401,-1822.1812992400955,"Not Available",96,157.6,203031499.19999999,-6.9013939239013361E-3,211324522.69999999,160.69999999999999,5.6924882629108081E-2,"Not Available","Not Available","Not Available","Not Available","Not Available","Not Available",0,0,0,0,19467.400000000001,6711.4,12756,19467.400000000001,"Illinois",{"$f":"VLOOKUP(AV105,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O105,AW105),CONCATENATE(M105,AW105))","v":"AreaFRegion5"}]
["1252266","Advocate Illinois Masonic Medical Center","Not Applicable: Standalone Property","2012-12-31","Chicago","60657",15,"1908",100,"Whole Building","Whole Building",1143379,{"$f":"VLOOKUP(L106,Table2[#All],2,TRUE)","v":"AreaF"},397,{"$f":"VLOOKUP(N106,Table1[#All],2,TRUE)","v":"BedC"},2,"No","Not Available","Not Available",20279683.399999999,-457490.89999999851,"Not Available",20279690,1036791.028792,116067.00501899992,"Not Available",98,151.19999999999999,172873391.09999999,5.4919030408150472E-2,194497262.90000001,159.9,3.7383177570093104E-3,"Not Available","Not Available",2413824.2799999998,2.11,"Not Available","Not Available",0,0,0,0,17018.3,5506.9,11511.4,17018.3,"Illinois",{"$f":"VLOOKUP(AV106,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O106,AW106),CONCATENATE(M106,AW106))","v":"AreaFRegion5"}]
["1432627","Advocate Good Shepherd Hospital","Not Applicable: Standalone Property","2017-12-31","Barrington","60010",4,"1979",100,"Whole Building","Whole Building",681239,{"$f":"VLOOKUP(L107,Table2[#All],2,TRUE)","v":"AreaE"},323.39999999999998,{"$f":"VLOOKUP(N107,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",18400892.5,14116.5,"Not Available",18400890,1011233.165,-61385.070000000065,"Not Available",28,240.6,163907169.40000001,-3.8591205290973374E-2,165644248.09999999,244.4,6.8242470453679011E-2,"Not Available","Not Available",2032603.42,2.98,"Not Available","Not Available",0,0,0,0,15816.1,5371.1,10445,15816.1,"Illinois",{"$f":"VLOOKUP(AV107,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O107,AW107),CONCATENATE(M107,AW107))","v":"AreaERegion5"}]
["1432627","Advocate Good Shepherd Hospital","Not Applicable: Standalone Property","2016-12-31","Barrington","60010",4,"1979",100,"Whole Building","Whole Building",606308.19999999995,{"$f":"VLOOKUP(L108,Table2[#All],2,TRUE)","v":"AreaE"},323.39999999999998,{"$f":"VLOOKUP(N108,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",18415009,-1233264.3000000007,"Not Available",18415010,949848.09499999997,-33719.593999999925,"Not Available",18,260.3,157816827.80000001,-5.0452680189170561E-2,173469582.09999999,262.3,0.1638508128785463,"Not Available","Not Available",1986028.36,3.28,"Not Available","Not Available",0,0,0,0,15498.1,5045.1000000000004,10453,15498.1,"Illinois",{"$f":"VLOOKUP(AV108,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O108,AW108),CONCATENATE(M108,AW108))","v":"AreaERegion5"}]
["1432627","Advocate Good Shepherd Hospital","Not Applicable: Standalone Property","2013-12-31","Barrington","60010",4,"1979",100,"Whole Building","Whole Building",479587,{"$f":"VLOOKUP(L109,Table2[#All],2,TRUE)","v":"AreaD"},323.39999999999998,{"$f":"VLOOKUP(N109,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",16870280.800000001,381189.19999999925,"Not Available",16870280,900197.46699999995,14634.516000000061,"Not Available",6,307.7,147581151.80000001,1.8384817142428577E-2,194905855.80000001,305.7,1.6725635252492727E-2,"Not Available",28885.3,1553009.7,3.24,"Not Available","Not Available",0,0,0,0,14357.5,4781.3999999999996,9576.2000000000007,14357.5,"Illinois",{"$f":"VLOOKUP(AV109,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O109,AW109),CONCATENATE(M109,AW109))","v":"AreaDRegion5"}]
["1432627","Advocate Good Shepherd Hospital","Not Applicable: Standalone Property","2009-12-31","Barrington","60010",4,"1979",100,"Whole Building","Whole Building",479587,{"$f":"VLOOKUP(L110,Table2[#All],2,TRUE)","v":"AreaD"},323.39999999999998,{"$f":"VLOOKUP(N110,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",17885498.899999999,979934.40000000224,"Not Available",17885500,1029292.042,52419.998000000021,"Not Available",2,341.9,163954534,4.9759666726089419E-2,219752695.5,343.1,3.5965158752458433E-2,"Not Available",40718.9,"Not Available","Not Available","Not Available","Not Available",0,0,0,0,15619.5,5467.1,10152.4,15619.5,"Illinois",{"$f":"VLOOKUP(AV110,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O110,AW110),CONCATENATE(M110,AW110))","v":"AreaDRegion5"}]
["1432267","Advocate Good Samaritan Hospital","Not Applicable: Standalone Property","2017-12-31","Downers Grove","60515",1,"1976",100,"Whole Building","Whole Building",1033972.8,{"$f":"VLOOKUP(L111,Table2[#All],2,TRUE)","v":"AreaF"},678.3,{"$f":"VLOOKUP(N111,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",24707391.600000001,921559.69999999925,"Not Available",24707390,1579678.4240000001,-98592.850000000093,"Not Available",59,234.3,242269472.69999999,-2.8506869003379422E-2,248404690.30000001,237.4,7.0113591852722312E-2,"Not Available","Not Available",2944431.42,2.85,"Not Available","Not Available",0,0,0,0,22415.200000000001,8390.4,14024.8,22415.200000000001,"Illinois",{"$f":"VLOOKUP(AV111,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O111,AW111),CONCATENATE(M111,AW111))","v":"AreaFRegion5"}]
["1432267","Advocate Good Samaritan Hospital","Not Applicable: Standalone Property","2011-12-31","Downers Grove","60515",1,"1976",100,"Whole Building","Whole Building",931695,{"$f":"VLOOKUP(L112,Table2[#All],2,TRUE)","v":"AreaE"},678.3,{"$f":"VLOOKUP(N112,Table1[#All],2,TRUE)","v":"BedD"},2,"No","Not Available","Not Available",25840511,1837084.8999999985,"Not Available",25840510,1440993.969,-48657.983999999939,"Not Available",47,249.3,232267231.30000001,6.0013634475540876E-3,254394848.40000001,248.8,4.4017607042816896E-3,"Not Available",32125.1,2929674,3.14,193908.91,0.21,0,0,0,0,22321.8,7653.8,14668,22321.8,"Illinois",{"$f":"VLOOKUP(AV112,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O112,AW112),CONCATENATE(M112,AW112))","v":"AreaERegion5"}]
["5155855","Advocate Eureka Hospital","Not Applicable: Standalone Property","2016-12-31","Eureka","61530",1,"1978",100,"Whole Building","Not Available",88750,{"$f":"VLOOKUP(L113,Table2[#All],2,TRUE)","v":"AreaB"},25,{"$f":"VLOOKUP(N113,Table1[#All],2,TRUE)","v":"BedA"},0,"No","Not Available","Not Available",1722620.6,-229395.80000000005,"Not Available",1722621,61291.145097499997,-18320.864751699999,"Not Available",91,135.30000000000001,12006696.6,-0.27840815114980089,11938282.6,137.9,0.13324952859836575,"Not Available","Not Available",165887.71,1.87,"Not Available","Not Available",0,0,0,0,1593.2,325.5,1267.7,1593.2,"Illinois",{"$f":"VLOOKUP(AV113,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O113,AW113),CONCATENATE(M113,AW113))","v":"AreaBRegion5"}]
["1841784","Advocate Condell Medical Center","Not Applicable: Standalone Property","2011-12-31","Libertyville","60048",7,"1927",100,"Whole Building","Whole Building",749359,{"$f":"VLOOKUP(L114,Table2[#All],2,TRUE)","v":"AreaE"},514.70000000000005,{"$f":"VLOOKUP(N114,Table1[#All],2,TRUE)","v":"BedD"},1,"No","Not Available","Not Available",21330343.100000001,-1882730.700000003,"Not Available",21330350,991542.85144999996,-176390.66024999996,"Not Available",42,229.4,171933424.59999999,-0.16272986942601445,176549655.30000001,230.9,-4.621658359764394E-2,"Not Available",21664,2224818.19,2.97,167280.39000000001,0.22,0,0,0,0,17374.400000000001,5266.6,12107.8,17374.400000000001,"Illinois",{"$f":"VLOOKUP(AV114,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O114,AW114),CONCATENATE(M114,AW114))","v":"AreaERegion5"}]
["1432600","Advocate Christ Medical Center","Not Applicable: Standalone Property","2016-12-31","Oak Lawn","60453",4,"2000",100,"Whole Building","Whole Building",1952709,{"$f":"VLOOKUP(L115,Table2[#All],2,TRUE)","v":"AreaF"},923.5,{"$f":"VLOOKUP(N115,Table1[#All],2,TRUE)","v":"BedD"},6,"No","Not Available","Not Available",55455320.399999999,-4196386.3999999985,"Not Available",55455330,2603355.3399899998,-136306.07639000006,"Not Available",59,230.2,449549110.10000002,-6.6291867096727825E-2,448175949.89999998,234.2,8.6939571150097511E-2,"Not Available","Not Available",5906191.4199999999,3.02,"Not Available","Not Available",0,0,0,0,45306,13827.7,31478.400000000001,45306,"Illinois",{"$f":"VLOOKUP(AV115,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O115,AW115),CONCATENATE(M115,AW115))","v":"AreaFRegion5"}]
["1432600","Advocate Christ Medical Center","Not Applicable: Standalone Property","2013-12-31","Oak Lawn","60453",4,"2000",100,"Whole Building","Whole Building",1338403,{"$f":"VLOOKUP(L116,Table2[#All],2,TRUE)","v":"AreaF"},923.5,{"$f":"VLOOKUP(N116,Table1[#All],2,TRUE)","v":"BedD"},4,"No","Not Available","Not Available",44727419,1403727.299999997,"Not Available",44727420,2015292.0379999999,-56858.058999999892,"Not Available",48,264.60000000000002,354139176,-2.5373130781688926E-3,474874099.80000001,263.2,4.1863851474335641E-2,"Not Available",98132,3951610.02,2.95,611690.01,0.46,0,0,0,0,36093,10704.2,25388.799999999999,36093,"Illinois",{"$f":"VLOOKUP(AV116,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O116,AW116),CONCATENATE(M116,AW116))","v":"AreaFRegion5"}]
["1432600","Advocate Christ Medical Center","Not Applicable: Standalone Property","2012-12-31","Oak Lawn","60453",4,"2000",100,"Whole Building","Whole Building",1315503.8,{"$f":"VLOOKUP(L117,Table2[#All],2,TRUE)","v":"AreaF"},923.5,{"$f":"VLOOKUP(N117,Table1[#All],2,TRUE)","v":"BedD"},4,"No","Not Available","Not Available",46131146.299999997,20443.10000000149,"Not Available",46131150,1958433.9790000001,259587.02299999981,"Not Available",41,268.5,353242888.19999999,6.8627526514807871E-2,471864664.39999998,274.7,5.2104899930986964E-2,"Not Available","Not Available",4120287.24,3.13,"Not Available","Not Available",0,0,0,0,36587.800000000003,10402.200000000001,26185.599999999999,36587.800000000003,"Illinois",{"$f":"VLOOKUP(AV117,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O117,AW117),CONCATENATE(M117,AW117))","v":"AreaFRegion5"}]
["2801928","Advocate Bromenn Medical Center","Not Applicable: Standalone Property","2012-12-31","Normal","61761",4,"1966",100,"Whole Building","Whole Building",530064.69999999995,{"$f":"VLOOKUP(L118,Table2[#All],2,TRUE)","v":"AreaE"},406.5,{"$f":"VLOOKUP(N118,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",17500413,-1443781,"Not Available",17500420,792351.96600000001,-174325.902,"Not Available",17,262.10000000000002,138946613.19999999,-0.19177618705634916,146613419,260.8,-2.6912725874663149E-3,"Not Available",18754.599999999999,1454065.24,2.74,"Not Available","Not Available",0,0,0,0,17087.2,4208.6000000000004,12878.7,17087.2,"Illinois",{"$f":"VLOOKUP(AV118,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O118,AW118),CONCATENATE(M118,AW118))","v":"AreaERegion5"}]
["2801928","Advocate Bromenn Medical Center","Not Applicable: Standalone Property","2011-12-31","Normal","61761",4,"1966",100,"Whole Building","Whole Building",446897,{"$f":"VLOOKUP(L119,Table2[#All],2,TRUE)","v":"AreaD"},406.5,{"$f":"VLOOKUP(N119,Table1[#All],2,TRUE)","v":"BedC"},1,"No","Not Available","Not Available",16056632,-349804.80000000075,"Not Available",16056630,618026.06400000001,81933.923999999999,"Not Available",18,260.89999999999998,116587841.5,5.6638792716876447E-2,139465172.90000001,260.10000000000002,6.7407673001075502E-2,"Not Available",23496.799999999999,1437182.32,3.22,"Not Available","Not Available",0,0,0,0,15098.8,3282.6,11816.2,15098.8,"Illinois",{"$f":"VLOOKUP(AV119,Table3[#All],2,FALSE)","v":"Region5"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O119,AW119),CONCATENATE(M119,AW119))","v":"AreaDRegion5"}]
["3762047","3901 Lone Tree Way","Not Applicable: Standalone Property","2016-12-31","Antioch","94509",1,"1967",100,"Whole Building","Not Available",185700,{"$f":"VLOOKUP(L120,Table2[#All],2,TRUE)","v":"AreaC"},128.13,{"$f":"VLOOKUP(N120,Table1[#All],2,TRUE)","v":"BedB"},1,"No","Not Available","Not Available",6970707.0999999996,517441.60000000056,"Not Available",6970708,200774.96966999999,83038.319930000027,"Not Available",32,236.2,43861552.399999999,0.18670825114204118,43858163.600000001,236,0.18732782369146,"Not Available","Not Available",1216605.8600000001,6.55,"Not Available","Not Available",0,0,0,0,2741.8,1066.4000000000001,1675.4,2741.8,"California",{"$f":"VLOOKUP(AV120,Table3[#All],2,FALSE)","v":"Region9"},{"$f":"IF(Key!$B$1>0,CONCATENATE(O120,AW120),CONCATENATE(M120,AW120))","v":"AreaCRegion9"}]