{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Main BuildingFF&E","development summary","Professional fees","Lakefront work","Phase 1","Employee Housing","Cabins","Square footages"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main BuildingFF&E","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Balsam House Resort"]
["Chestertown, New York"]
[]
["Costs Main building"]
[{"$nulls":7},"IDA exemption"]
["FF&E for rooms",48,"no.","u/m","cost","subtotal","freight","sales tax","total"]
["queen beds / frame , headboard",null,48,"ea",2000,{"$f":"C7*E7","v":96000},{"$f":"F7*0.08","v":7680},null,{"$f":"F7+G7+H7","v":103680}]
["fabric for headboards",8,{"$f":"C7*B8","v":384},"yds",27,{"$f":"C8*E8","v":10368},{"$f":"F8*0.08","v":829.44},null,{"$f":"F8+G8+H8","v":11197.44}]
["wardrobe",null,48,"ea",1200,{"$f":"C9*E9","v":57600},{"$f":"F9*0.08","v":4608},null,{"$f":"F9+G9+H9","v":62208}]
["dressers",null,48,"ea",750,36000,2880,null,38880]
["lounge chair",null,48,"ea",675,32400,2592,null,34992]
["fabric for lounges",7,{"$f":"C11*B12","v":336},"yds",25,8400,672,null,9072]
["occaisonal table",null,48,"ea",575,27600,2208,null,29808]
["side chairs",2,{"$f":"C13*B14","v":96},"ea",375,36000,2880,null,38880]
["side table",null,48,"ea",400,19200,1536,null,20736]
["bedside tables",null,96,"ea",400,38400,3072,null,41472]
["bedside lamps",null,96,"ea",500,48000,3840,null,51840]
["area rugs large",null,48,"ea",1000,48000,3840,null,51840]
["artwork",null,50,"ea",150,7500,600,null,8100]
["safe",null,48,"ea",385,18480,1478.4,null,19958.400000000001]
["sofa",null,24,"ea",2500,60000,4800,null,64800]
["fabric for sofa",14,{"$f":"B22*C21","v":336},"yds",28,9408,752.64,null,10160.64]
["wallcovering",30,{"$f":"B23*48","v":1440},"yds",30,43200,3456,null,46656]
["bedding",48,48,"ea",75,{"$f":"C24*E24","v":3600},288,null,{"$f":"F24+G24+H24","v":3888}]
["pillows",6,{"$f":"B24*B25","v":288},"ea",7.5,{"$f":"C25*E25","v":2160},172.8,null,{"$f":"F25+G25+H25","v":2332.8000000000002}]
["bath accessories",null,48,"lot",65,{"$f":"C26*E26","v":3120},249.6,null,{"$f":"F26+G26+H26","v":3369.6}]
["wall sconces",2,48,"ea",400,{"$f":"C27*E27*B27","v":38400},3072,null,41472]
["luggage rack",null,48,"ea",50,2400,192,null,2592]
["Outdoor deck furniture",null,13,"sets",1500,19500,1560,null,21060]
["floor lamps",null,48,"ea",1200,57600,4608,null,62208]
["window treatments",null,96,"ea",1100,105600,8448,null,114048]
["fabric for draperies",16,{"$f":"B32*C31","v":1536},"yds",40,{"$f":"C32*E32","v":61440},4915.2,null,{"$f":"F32+G32+H32","v":66355.199999999997}]
[]
["totals",{"$nulls":4},{"$f":"SUM(F7:F33)","v":890376},{"$f":"SUM(G7:G33)","v":71230.080000000002},null,{"$f":"SUM(I7:I33)","v":961606.08000000007}]
[]
["total per room",null,48,{"$nulls":5},{"$f":"I34/C36","v":20033.460000000003}]
[]
["FF&E Dining/bistro bar/lobby/outdoor"]

{"sheet":"development summary","index":1,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Balsam House Resort"]
[]
["Development Budget"]
["2025-02-04"]
["Prepared by DiGuiseppe, reviewed by Frank P. Ellis"]
["Description",null,"s/f","cost","construction only","FF&E only"]
[]
["Building and land ppraisal",null,null,"Owners equity to be determined",6800000]
["Main Construction (hotel,conference,pool) ",null,null,{"$f":"'Square footages'!D71","v":16681830},{"$f":"D9","v":16681830}]
["Cabins  Construction ( eliminate  from development)",null,null,{"$f":"Cabins!G23","v":-2050500},{"$f":"D10","v":-2050500}]
["Employee Housing",null,null,{"$f":"'Employee Housing'!D18","v":732000},{"$f":"D11","v":732000}]
["Lakehouse",null,null,73500,{"$f":"'Lakefront work'!D16","v":65750}]
["geothermal ",null,null,750000,750000]
["Site work, roads and features",null,null,600000,{"$f":"D14","v":600000}]
["wells",null,null,55000,{"$f":"D15","v":55000}]
["septic",null,null,85000,85000]
["Approvals",null,null,50000]
["FF&E Main hotel",null,null,{"$f":"'Main BuildingFF&E'!I34","v":961606.08000000007},null,{"$f":"D18","v":961606.08000000007}]
["FF&E Cabins (10)",null,null,{"$f":"Cabins!Q31","v":-303696},null,-303696]
["FF&E employee housing",null,null,{"$f":"'Employee Housing'!D19","v":125000},null,125000]
[" FF&E pool Outdoor furniture",null,null,150000,null,150000]
["FF&E lake house outdoor furniture",null,null,{"$f":"'Lakefront work'!D18","v":10000},null,10000]
["materials on site",null,null,-250000,{"$f":"D23","v":-250000}]
["exterior renovation fall 2023",null,null,-256000,{"$f":"D24","v":-256000}]
["Subtotal",null,null,{"$f":"SUM(D9:D24)","v":17413740.079999998},{"$f":"SUM(E9:E24)","v":16413080}]
[]
["Professional fee & soft costs",null,null,{"$f":"'Professional fees'!F15","v":1386593.8168000001}]
["total of FF&E",{"$nulls":4},{"$f":"SUM(F18:F27)","v":942910.08000000007}]
["Admin fees",null,null,10000]
["Legal",null,null,50000]
["inventory/ operating equipment",null,null,225000]
["tech services & systems",null,null,75000]
["pre-opening/ Marketing",null,null,300000]
["insurance",null,null,25000]
["IDA tax exemption",null,null,0,"sales ax on purchases, property, "]
["working capital",null,null,475000,"4.5% of the gross sales"]
["Upstate Revitalization Initiative grant",null,null,-4500000,"after property opens"]
[]
["development total ",null,null,{"$f":"SUM(D25:D38)","v":15460333.896799996}]
["Realized  development cost",null,null,{"$f":"SUM(D39:D39)","v":15460333.896799996}]
[]
["financing costs"]
["40% debt",null,null,{"$f":"0.4*D40","v":6184133.5587199992}]
["misc. closing costs",null,null,20000]
["lender fees based on 40% debt",null,0.01,{"$f":"0.01*D43","v":61841.335587199996}]
[]
["total owners equity",null,0.6,{"$f":"D40-D43","v":9276200.3380799964}]
["equity owner share # 1",null,null,"TBD"]
["property and building value",null,null,5770000]
["total owners equity",null,null,"TBD"]
["Equity owner share # 2",null,null,"TBD"]

{"sheet":"Professional fees","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"%",null,null,"cost","fee"]
["Professional fees/ consultants"]
["Architect",2.5000000000000001E-2,"of construction cost",null,{"$f":"'development summary'!E25","v":16413080},{"$f":"B4*E4","v":410327}]
["Interior Design",0.1,"of FFE costs",null,{"$f":"'development summary'!F28","v":942910.08000000007},{"$f":"B5*E5","v":94291.008000000016}]
["Procurement of FF&E",0.08,"of FFE costs",null,{"$f":"'development summary'!F28","v":942910.08000000007},{"$f":"B6*E6","v":75432.806400000001}]
["Structual Engineering/ MEP",0.01,"of construction cost",null,{"$f":"E4","v":16413080},{"$f":"B7*E7","v":164130.80000000002}]
["Developers fee",0.03,null,null,{"$f":"'development summary'!D25","v":17413740.079999998},{"$f":"B8*E8","v":522412.20239999995}]
["Geothermal evaluation",1,null,null,25000,{"$f":"E9","v":25000}]
["Kitchen consultant",1,null,null,25000,25000]
["Spa consultant",1,null,null,20000,20000]
["Branding / marketing onsultant",1,null,null,30000,30000]
["Landscape design","flat fee",null,null,20000,20000]
[]
["total soft costs",{"$nulls":4},{"$f":"SUM(F4:F14)","v":1386593.8168000001}]

{"sheet":"Lakefront work","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Lakefront"]
[]
["Construction",null,null,"total"]
["Gazebo renovation","budget",null,5000]
["Lakehouse"]
["Electrical",null,null,10000]
["water",null,null,15000]
["flooring",null,null,5000]
["painting",null,null,3000]
["heating",null,null,2500]
["window glass removable",null,null,3750]
["cooking set up",null,null,4000]
["roof repair",null,null,3000]
["finished roof floor",null,null,4500]
["wharf enlargment / repair",null,null,10000]
["subtotal",null,null,{"$f":"SUM(D4:D15)","v":65750}]
[]
["FF&E budget",null,null,10000]

{"sheet":"Phase 1","index":4,"n_rows":86,"n_cols":13,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Phase One construction work"]
[]
["2023-08-02"]
[]
["Balsam House"]
["477 Atateka Drive"]
["Chestertown, NY"]
[]
["item","trade","vendor","Location","time","bid cost","accepted cost","deposit","date of wire","payment","notes","balance","payments"]
["siding, tyvek, removals","carpentry","JF Construction","Kingston, staying onsite","10-12 wks",160000,160000,10000,"2023-08-25",null,null,{"$f":"G10-H10","v":150000},"weekly"]
["painting","painter","JF Construction","Kingston, staying onsite","10-12 wks","inc",null,13636.36,null,null,null,-13636.36,"weekly"]
["masonry of chimney","mason","JF Construction","Kingston, staying onsite","10-12 wks","inc",{"$nulls":5},0,"weekly"]
[]
[]
["electrical","electrican","Terry Weaver III","Coxsackie, staying on site","1 week",14500,14500,14500,"2023-08-24",null,null,0]
["site work","excavator/ landspace/ tree work","Papa Bear Tree service","Stone Ridge, uncle in Chester area","2 weeks",33000,{"$nulls":5},0]
["landscape",null,"Martin",null,null,null,1300,1300,"cash"]
["addition","carpentry, roofing, masonry","Trintite Constrction","Newburgh","Phase 2",799900,{"$nulls":5},0]
["plumbing","plumber","Trintite Constrction","Newburgh","4 days",5000,5000,2500,"2023-09-01",2500,"2023-09-20",2500,"weekly"]
["roofing ","Membrane roofing","3 Bros Roofing","Warrensburg","2 weeks",15400,15400,8400,"2023-08-23",7000,"2023-09-25",{"$f":"G20-H20","v":7000},"upon completion"]
["roofing ","additional work on roof","3 Bros Roofing","Warrensburg","2 weeks",4000,4000,4000,"2023-09-23",null,null,{"$f":"G21-H21","v":0}]
["Feasibility Study","consultting","HVS consultting","Buffalo","48 days",11000,11000,5500,"paid by check",null,null,{"$f":"G22-H22","v":5500},"upon completion"]
["Geothermal","initial investigation and evaluation","Altren Energy","Accord",null,7500,{"$nulls":5},0]
["geothermal ","feasibility","Altren Energy","Accord",null,25000,{"$nulls":5},0]
["geothermal","tax credit and incentives","Altren Energy","Accord",null,4750,{"$nulls":5},0]
["dumpster","trash removal","casella","Warrensburg",null,1149.33,1149.33,{"$f":"F26","v":1149.33},"paid by CC",null,null,0]
["2nd dumpster","trash removal","caselle","Warrensburg",null,1149.33,1149.33,1149.33,"paid by cc"]
["materials for elctrical",{"$nulls":10},{"$f":"F32-G32","v":0},"paid 8/21"]
["3rd dumpster","trash removal","casella",null,null,null,1149.33,1149.33,"paid by cc"]
[]
[{"$nulls":9},"sales tax"]
[null,"materials for electrical",null,null,4586,4586,4586,"2023-08-18",null,{"$f":"G32*0.08","v":366.88}]
["materials for carpentry",null,"Home depot",null,null,null,4926.1000000000004,4926.1000000000004,"2023-08-23",{"$f":"G33*0.08","v":394.08800000000002},null,null,"paid 8/24"]
["paint etc",null,"HD",null,null,null,98.48,null,null,{"$f":"G34*0.08","v":7.8784000000000001}]
["lumber and mortar, Zip",null,"HD",null,null,null,1471.14,null,null,117.69120000000001]
["shells for nail gun",null,"HD",null,null,null,87.1,null,null,6.968]
["moldings",null,"HD",null,null,null,77.61,null,null,6.2088000000000001]
["led spot lights for sign",null,"HD",null,null,null,97.01,null,null,7.7608000000000006]
["caarpentry supplies",null,"HD",null,null,null,520.79999999999995,null,null,41.663999999999994]
["paint etc",null,"HD",null,null,null,704.76,null,null,56.380800000000001]
["lumber",null,"HD",null,null,null,-134.94,null,null,-10.795199999999999]
["paint etc",null,"HD",null,null,null,950.75,null,null,76.06]
["paint etc",null,"HD",null,null,null,528.57000000000005,null,null,42.285600000000002]
["wood filler, paint, sanding dics",null,"HD",null,null,null,238.76,null,null,19.1008]
["Lumber",null,"Murphys",null,null,null,1933.35]
["moldings",null,"Murphys",null,null,null,2666.35]
["lumber for trim",null,"Murphys",null,null,null,1189.76]
["lumber for trim",null,"Murphys",null,null,null,945.75]
["lumber for trim",null,"Murphys",null,null,null,203.09]
["lumber",null,"Murphys",null,null,null,2869.44]
["lumber for trim",null,"Murphys",null,null,null,1078.4000000000001]
["crown moldings for exterior",null,"Murphys",null,null,null,639.86]
["furring strips and cement",null,"HD",null,null,null,313.98,null,null,{"$f":"G53*0.08","v":25.118400000000001}]
["Zip, nails, mason mix furring strip",null,"hd",null,null,null,-1567.4,null,null,-125.39200000000001]
["materials for stone",null,"Champlain stone",null,null,null,7800]
["freight for stone",null,"Cs trucking",null,null,null,650]
["freight for stone 2nd ",null,"Home Depot",null,null,null,650,null,"2023-08-23",{"$f":"G57*0.08","v":52},null,null,"paid 8/24"]
["painting supplies",null,"HD",null,null,null,982.44,null,null,78.595200000000006]
["materisl and dishwasher ",null,"Home Depot","Ulster County HD",null,null,1370.91,null,null,109.67280000000001]
["refubd",null,"HD",null,null,null,-19.78,null,null,-1.5824]
["paint and hardware",null,"HD",null,null,null,601.70000000000005,null,null,48.136000000000003]
["Refund","h","hd",null,null,null,-385.17,null,null,-30.813600000000001]
["cinstruction variuos",null,"HD",null,null,null,1146.25,null,null,91.7]
["refund",null,"HD",null,null,null,-296.32,null,null,-23.7056]
["Staples etc ",null,"HD",null,null,null,178.92,null,null,14.313599999999999]
["apt supplies",null,"HD",null,null,null,32.18,null,null,2.5744000000000002]
["paint primer, caulking",null,"HD",null,null,null,1370.91,null,null,109.67280000000001]
["nails",null,"Loews",null,null,null,83.14,null,null,6.6512000000000002]
["primer and load shots for gun",null,"HD",null,null,null,256.02]
["paint brushes ",null,"HD",null,null,null,71.11]
["lumber ",null,"Murphys",null,null,null,978.94]
["moldings, lumber , paintin supplies",null,"HD",null,null,null,1168.57]
[]
[{"$nulls":8},"total sales tax",{"$f":"SUM(J32:J73)","v":1489.1120000000001}]
[]
[]
["plumbing supplies","Trintite, paid in cash","ACE hardware",null,null,null,100]
[]
[{"$nulls":6},{"$f":"SUM(G10:G78)","v":255812.53000000003},{"$nulls":4},{"$f":"SUM(L10:L33)","v":151363.64000000001}]
["subtotal"]
["Reimbursables",{"$nulls":5},2321.33]
["less retainer","project management",{"$nulls":4},-7500]
[{"$nulls":8},"2023-08-24"]
[{"$nulls":12},"paid 8/24"]
["Total ","labor plus materials"]
["Project Management","construction management","DiGuiseppe",null,null,null,{"$f":"0.2*G79","v":51162.506000000008}]

{"sheet":"Employee Housing","index":5,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Barn Renovation"]
["Employee Housing"]
["Construction","sf","cost/ sf","total","notes"]
["flooring",4550,15,{"$f":"B4*C4","v":68250},"wood floors"]
["structure",4550,75,{"$f":"B5*C5","v":341250},"reno barn "]
["windows",null,null,30000,"pella budget"]
["common bathrooms",2,15000,{"$f":"B7*C7","v":30000},"men/ women"]
["plumbing",null,null,25000,"kitchen and bath"]
["electrical",null,null,25000,"line runs to barn already"]
["carpentry",null,null,100000]
["doors and trim",null,null,10000]
["site work",null,null,10000,"roads and clearing"]
["septic",null,null,12000,"one system"]
["well/ water",null,null,7500,"new well"]
["kitchen, common",null,null,25000,"open type"]
["HVAC",null,null,30000]
["Insulation",null,null,18000,"spray closed cell foam"]
["total construction",null,null,{"$f":"SUM(D4:D17)","v":732000}]
["FF&E 20 rooms",20,7500,125000]
["construction / sf",null,null,{"$f":"D18/B4","v":160.87912087912088}]

{"sheet":"Cabins","index":6,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Cabins"]
["10000 sq. ft each"]
[{"$nulls":15},"IDA exemption"]
["Construction costs","no.","cost","subtotal","freight","sales tax","total",null,"FF& E for cabin",null,"no.","u/m","cost","subtotal","freight","sales tax","total"]
["excavation/ site clearing",10,7500,{"$f":"B5*C5","v":75000},0,null,{"$f":"SUM(C5:F5)","v":82500},null,"queen beds / frame , headboard",null,20,"ea",1500,{"$f":"K5*M5","v":30000},{"$f":"N5*0.08","v":2400},null,{"$f":"N5+O5+P5","v":32400}]
["foundation",10,15000,150000,0,null,165000,null,"wardrobe",null,20,"ea",800,{"$f":"K6*M6","v":16000},{"$f":"N6*0.08","v":1280},null,17280]
["carpentry",10,30000,300000,0,null,330000,null,"dressers",null,20,"ea",550,11000,880,null,11880]
["Metal roofing",10,15000,150000,150,null,165150,null,"lounge chair",null,20,"ea",400,8000,640,null,8640]
["gutters and leaders",10,2500,25000,0,null,27500,null,"fabric for lounges",null,140,"yds",25,3500,280,null,3780]
[" wood flooring",10,8500,85000,250,null,93750,null,"dining table",null,10,"ea",800,8000,640,null,8640]
["bathrooms",20,15000,300000,0,null,315000,null,"dining chairs",null,40,"ea",300,12000,960,null,12960]
["decking",10,5000,50000,175,null,55175,null,"side board",null,10,"ea",450,4500,360,null,4860]
["hot tub",10,13000,{"$f":"B13*C13","v":130000},0,null,143000,null,"club chairs",null,20,"ea",675,13500,1080,null,14580]
["windows",10,7500,{"$f":"B14*C14","v":75000},250,null,82750,null,"fabric for clubs",null,140,"yds",25,3500,280,null,3780]
["doors",10,3500,35000,75,null,38575,null,"coffee table",null,20,"ea",400,8000,640,null,8640]
["marble/ tile",10,7500,75000,300,null,82800,null,"fireplace tools",null,10,"ea",150,1500,120,null,1620]
["fireplace, stone",10,7500,75000,0,null,82500,null,"bedside tables",null,40,"ea",375,15000,1200,null,16200]
["hardware",10,500,5000,0,null,5500,null,"bedside lamps",null,40,"ea",300,12000,960,null,12960]
["septic",6,15000,90000,0,null,105000,null,"area rugs small",null,20,"ea",600,12000,960,null,12960]
["water",10,7500,75000,0,null,82500,null,"area rugs large",null,10,"ea",1000,10000,800,null,10800]
["generator",5,5000,25000,0,null,30000,null,"outdoor bench",null,10,"ea",600,6000,480,null,6480]
["geothermal/ radiant",10,15000,150000,0,null,165000,null,"outdoor lounges",null,20,"ea",750,15000,1200,null,16200]
["subtotal",null,{"$f":"SUM(C5:C22)","v":180500},{"$f":"SUM(D5:D22)","v":1870000},null,null,{"$f":"-SUM(C23:F23)","v":-2050500},null,"outdoor coffee table",null,10,"ea",350,3500,280,null,3780]
["cost per sq. ft",10,1000,{"$f":"B24*C24","v":10000},null,null,{"$f":"G23/D24","v":-205.05},null,"outdoor recliner",null,20,"ea",600,12000,960,null,12960]
[{"$nulls":8},"server",null,10,"ea",400,4000,320,null,4320]
[{"$nulls":8},"artwork",null,50,"ea",150,7500,600,null,8100]
[{"$nulls":8},"safe",null,20,"ea",385,7700,616,null,8316]
[{"$nulls":8},"sofa",null,20,"ea",2500,50000,4000,null,54000]
[{"$nulls":8},"fabric for sofa",null,250,"yds",28,7000,560,null,7560]
[{"$nulls":8},"bedding ",null,20,"ea","b"]
[{"$nulls":8},"totals",{"$nulls":4},{"$f":"SUM(N5:N30)","v":281200},{"$f":"SUM(O5:O30)","v":22496},null,{"$f":"-SUM(Q5:Q30)","v":-303696}]
[]
[{"$nulls":8},"total per cabin ",null,10,{"$nulls":5},{"$f":"Q31/K33","v":-30369.599999999999}]

{"sheet":"Square footages","index":7,"n_rows":74,"n_cols":19,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Basement",{"$nulls":4},"1st Floor",null,null,null,"2nd floor",null,null,null,"3rd floor",null,null,null,"4th floor"]
["areas","room #","sf","spa",null,"room #","sf",null,null,"room #","SF",null,null,"Room #","SF",null,null,"Room # ","SF"]
["reception",null,368,368,null,"conference",4793,null,null,"rm 201",303,null,null,"housekeeping",389,389]
["pedicure",null,124,124,null,"pool deck",10000,null,null,"rm 202",304,null,null,"rm 301",265]
["office",null,190,190,null,"entry",485,null,null,"rm 203",258,null,null,"rm 302",248]
["treatment room",null,140,140,null,"lobby",1201,null,null,"rm 204",275,null,null,"rm 303",279]
["treatment room",null,140,140,null,"elevator ",80,80,null,"rm 205",228,null,null,"rm 308",326]
["treatment room",null,140,{"$f":"C8","v":140}]
["treatment room",null,140,{"$f":"C9","v":140}]
["treatment room",null,140,{"$f":"C10","v":140}]
["couples room",null,200,{"$f":"C11","v":200}]
["salon",null,483,483,null,"office",95,null,null,"rm 206",258,null,null,"rm 307",232]
["storage",null,65,65,null,"offices",243,null,null,"rm 207",230,null,null,"rm 312",248]
["spa kitchen",null,200,200,null,"rm 101",277,null,null,"Stair 1",101,101,null,"rm 313",247]
["bathroom",null,139,139,null,"rm 102",275,null,null,"rm 214",228,null,null,"rm 314",242]
["elevator",null,68,null,null,"rm 103",279,null,null,"rm 213",187,null,null,"rm 304",245]
["room",null,161,161,null,"rm 104",562,null,null,"rm 212",229,null,null,"rm 309",243]
["wine cellar",null,215,null,null,"rm 105",229,null,null,"rm 211",217,null,null,"rm 305",240]
["spa lounge entry",null,400,400,null,"rm 106",229,null,null,"rm 210",236,null,null,"rm 310",239]
["employee lounge w/ lockers",null,511,null,null,"rm 107",431,null,null,"rm 208",405,null,null,"rm 311",167]
["fitness",null,400,400,null,"rm 111",436,null,null,"rm 215",245,null,null,"rm 306",166]
["retail",null,120,{"$f":"C22","v":120},null,"rm 10",229,null,null,"rm 216",273,null,null,"rm 315",188]
["pump room",null,283,null,null,"rm 109",216,null,null,"rm 217",247,null,null,"stair 2",101,101]
["water supply",null,349,null,null,"rm 108",306,null,null,"rm 218",246,null,null,"elev",67]
["crawl space",null,319,null,null,"room",69,null,null,"rm 219",252,null,null,"stair 1",101,101]
["mechancial",null,164,null,null,"public bathrooms",470,null,null,"rm 220",285,null,null,"corridor",1341]
["lockers",null,410,{"$f":"C27","v":410},null,"kitchen",670,null,null,"stair 2",123,123,null,"freight elev",62,62]
["lockers",null,410,{"$f":"C28","v":410},null,"kitchen",176,null,null,"rm 221",193]
["storage",null,288,288,null,"hall",219,null,null,"elev",67,67]
["spa storage for products/ linens",null,164,164,null,"kitchen",481,null,null,"conference hall mezz",3339]
["laundry",null,400,null,null,"dining room",2129,null,null,"corridor",1189,1189]
["hall",null,400,null,null,"bistro dining",1811,null,null,"freight elev",62,62]
["hall",null,270,270,null,"bar / bistro",2248]
["hall",null,105,105,null,"stair #2",84,84,null,"total gross",{"$f":"SUM(K3:K33)","v":9980},{"$f":"SUM(L2:L33)","v":1542},null,"total",{"$f":"SUM(O3:O33)","v":5636}]
["hall",null,942,942,null,"terrace"]
["hall",null,120,120,null,"terrace"]
["hall",null,100,{"$f":"C37","v":100},null,"stair 1",101,101]
["hall",null,200,200,null,"connection",1377,1377]
["hall",null,320,{"$f":"C39","v":320},null,"corridor",413,413]
["hall",null,101,null,null,"freight elev",82,83]
["hall",null,82]
[]
[]
["gross total",null,12244,9890,null,"gross total",{"$f":"SUM(G3:G43)","v":30696},null,null,"gross total",{"$f":"K34","v":9980},null,null,"Gross total",{"$f":"O34","v":5636}]
["net space",null,{"$f":"D44","v":9890},null,null,"net space",{"$f":"G44-H46","v":28558},null,null,"net space",{"$f":"K44-L46","v":8438},null,null,"net space",{"$f":"O44-P46","v":4983}]
["support space",null,null,{"$f":"C44-C45","v":2354},null,"support space",null,{"$f":"SUM(H2:H44)","v":2138},null,"support space",null,{"$f":"L34","v":1542},null,"support space",null,{"$f":"SUM(P3:P45)","v":653}]
[]
[]
["net space"]
[" basement spa/ salon",9490,425,{"$f":"B50*C50","v":4033250}]
["basment / fitness",400,275,{"$f":"B51*C51","v":110000}]
["1st floor",{"$f":"G45","v":28558},225,{"$f":"B52*C52","v":6425550}]
["2nd floor",{"$f":"K45","v":8438},185,1561030]
["3rd floor",{"$f":"O45","v":4983},175,872025]
["4th floor",null,null,0]
["pool",7500,150,1125000]
["conference center",7500,225,1687500]
["total",null,null,{"$f":"SUM(D50:D57)","v":15814355}]
[]
["support space"]
["basment",{"$f":"D46","v":2354},75,{"$f":"B61*C61","v":176550}]
["1st floor",{"$f":"H46","v":2138},100,213800]
["2nd floor",{"$f":"L46","v":1542},75,115650]
["3rd floor",{"$f":"P46","v":653},75,48975]
["4th floor",null,null,0]
["pool",1000,125,125000]
["conference center",2500,75,187500]
["total",null,null,{"$f":"SUM(D61:D67)","v":867475}]
[]
[]
["Total hotel",null,null,{"$f":"D58+D68","v":16681830}]
[]
[]
[null,{"$f":"SUM(B50:B73)","v":77056}]