{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget","HED"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Budget","index":0,"n_rows":144,"n_cols":25,"rows_kept":144,"cut":false,"hidden":false,"merged":[[143,8,143,9],[138,1,138,9],[132,5,132,6],[134,5,134,6],[135,5,135,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[136,5,136,6],[137,5,137,6],[139,8,139,9],[142,8,142,9],[141,8,141,9],[140,8,140,9],[110,5,110,6],[111,5,111,6],[112,5,112,6],[114,5,114,6],[117,5,117,6],[131,5,131,6],[106,5,106,6],[107,6,107,9],[96,5,96,6],[97,5,97,6],[98,5,98,6],[99,5,99,6],[100,5,100,6],[101,5,101,6],[118,5,118,6],[124,5,124,6],[125,5,125,6],[126,5,126,6],[127,5,127,6],[129,5,129,6],[130,5,130,6],[115,5,115,6],[90,5,90,6],[92,5,92,6],[93,5,93,6],[94,5,94,6],[86,5,86,6],[102,5,102,6],[103,5,103,6],[104,5,104,6],[105,5,105,6],[76,5,76,6],[81,5,81,6],[82,5,82,6],[83,5,83,6],[84,5,84,6],[78,5,78,8],[79,5,79,6],[87,5,87,6],[89,5,89,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[73,5,73,6],[62,5,62,6],[63,5,63,6],[65,5,65,6],[67,5,67,6],[75,5,75,6],[66,7,66,8],[57,5,57,6],[58,1,58,9],[53,5,53,6],[54,5,54,6],[55,5,55,6],[64,7,64,8],[61,5,61,6],[69,5,69,6],[39,5,39,6],[40,5,40,6],[37,5,37,6],[38,5,38,6],[48,5,48,6],[51,5,51,6],[52,5,52,6],[41,5,41,6],[42,5,42,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[30,5,30,6],[8,22,8,23],[3,3,3,7],[4,6,4,7],[5,6,5,7],[18,5,18,6],[19,5,19,6],[29,5,29,6],[27,2,27,3],[28,5,28,6],[20,5,20,6],[21,5,21,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6]]}
[]
[null,"BUDGET SUMMARY REPORT ",null,null,null,null,null,null,null,null,"Version 8 (08-3-21)"]
[null,null,"BUILDING:",null,null,"Room:",null,null,null,null,"PROJECT #:",null,null,null,null,null,null,null,null,null,"Budget:"]
[null,null,"PROJECT:"]
[null,null,"BUDGET:",null,null,"TYPE:",null,null,null,null,"Project Balance",null,null,null,null,null,null,null,null,"Y","Preliminary Budget"]
[null,null,"DATE:",null,null,"PREPARER:",null,null,null,null,{"$f":"+K144","v":0},null,null,null,null,null,null,null,null,"N","Design/Construction"]
[null,"FUNDING:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A","Change Order"]
[null,null,"FY","FUNDING SOURCE","INDEX","ACCT CD","FUNDED AMOUNT           (PRE-AIPP)","REVERT DATE","Override AIPP? Default \"N\"","AIPP","AVAILABLE FUNDING           (Post-AIPP)",null,null,null,null,null,"AIPP CALCULATIONS"]
[null,null,null,null,null,null,null,null,"Y",{"$f":"R9","v":0},{"$f":"G9-J9","v":0},null,null,null,null,null,{"$f":"IF(I9=\"Y\",0,IF(OR(D9=$U$19,D9=$U$20,D9=$U$21),IF($G$5=$U$12,0,IF(G9<U38,0,IF(G9>=$U$33,200000,G9*$U$35))),0))","v":0},{"$f":"IF($Q$16>=$U$37,IF(SUM(Q9,#REF!)>=$U$37,$U$37-SUM(#REF!),Q9),Q9)","v":0},null,null,null,null,"Rate "]
[null,null,null,null,null,null,null,null,"N",0,0,null,null,null,null,null,0,{"$f":"IF($Q$16>=$U$37,IF(SUM(Q10,R9,#REF!)>=$U$37,$U$37-SUM(R9,#REF!),Q10),Q10)","v":0},null,null,"Cap. Improvement",null,"$10,000,000.01 and above",1.4999999999999999E-2,{"$f":"$X$16*X10","v":0}]
[null,null,null,null,null,null,0,null,"N",0,0,null,null,null,null,null,0,{"$f":"IF($Q$16>=$U$37,IF(SUM(Q11,R10,R9,#REF!)>=$U$37,$U$37-SUM(R10,R9,#REF!),Q11),Q11)","v":0},null,null,"Env. Health/Safety",null,"$2,000,000.01-$10,000,000.01",4.2500000000000003E-2,{"$f":"$X$16*X11","v":0}]
[null,null,null,null,null,null,0,null,"N",0,0,null,null,null,null,null,0,{"$f":"IF($Q$16>=$U$37,IF(SUM(Q12,R11,R10,R9,#REF!)>=$U$37,$U$37-SUM(R11,R10,R9,#REF!),Q12),Q12)","v":0},null,null,"Infrastructure",null,"$750,000.01-$2,000,000",0.06,0]
[null,null,null,null,null,null,0,null,"N",0,0,null,null,null,null,null,0,{"$f":"IF($Q$16>=$U$37,IF(SUM(Q13,R12,R11,R10,R9,#REF!)>=$U$37,$U$37-SUM(R12,R11,R10,R9,#REF!),Q13),Q13)","v":0},null,null,"Major Maint.",null,"$0-$750,000",0.09,0]
[null,null,null,null,null,null,0,null,"N",0,0,null,null,null,null,null,0,{"$f":"IF($Q$16>=$U$37,IF(SUM(Q14,R12,R11,R10,R9,#REF!,R13)>=$U$37,$U$37-SUM(R12,R11,R10,R9,#REF!,R13),Q14),Q14)","v":0}]
[null,null,null,null,null,null,0,null,"N",0,0,null,null,null,null,null,0,{"$f":"IF($Q$16>=$U$37,IF(SUM(Q15,R14,R12,R11,R10,R9,#REF!,R13)>=$U$37,$U$37-SUM(R14,R12,R11,R10,R9,#REF!,R13),Q15),Q15)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G9:G15)","v":0},null,null,{"$f":"SUM(J9:J15)","v":0},{"$f":"SUM(K9:K15)","v":0},null,null,null,null,null,{"$f":"SUM(Q9:Q15)","v":0},null,null,null,null,null,"Project Subtotal",{"$f":"K16","v":0}]
[null,"Design, Testing, & Consulting  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fund Sources"]
[null,null,"Survey Services",null,null,null,null,null,null,null,{"$f":"SUM(J19:J22)","v":0},null,null,null,null,null,"Estimated",null,null,null,null,null,"Admin Fee",{"$f":"IF(K16<750000.01,Y13,IF(K16<2000000.01,Y12,IF(K16<10000000.01,Y11,IF(K16>=10000000.01,Y10))))","v":0}]
[null,null,"l","Site Survey Services",null,null,null,null,null,0,null,null,null,null,null,null,"Actual",null,null,null,"STB- Severance Tax Bond"]
[null,null,"l","Habitat Survey",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"GOB- General Obligation Bond"]
[null,null,"l","Archeological Site Survey",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"GF- General Fund"]
[null,null,"l","Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"R&R- Renewal & Replacement"]
[null,null,"Geotechnical Investigation:",null,null,null,null,null,null,null,{"$f":"SUM(J24:J27)","v":0},null,null,null,null,null,null,null,null,null,"RB- Revenue Bond"]
[null,null,"l","Geotechnical Investigation",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"LCL RB- Local Revenue Bond"]
[null,null,"l","Material Testing",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Gift"]
[null,null,"l","Other ",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"NMDOT"]
[null,null,"l","Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Federal- i.e. DOD, DOE"]
[null,null,"Total Design Fee:",null,null,null,null,null,null,null,{"$f":"SUM(J29:J31)","v":0},null,null,null,null,null,null,null,null,null,"Departmental- Various Sources"]
[null,null,"l","Base Design Fee",null,null,null,null,null,0]
[null,null,"l","Other",null,null,null,null,null,0]
[null,null,"l","Other ",null,null,null,null,null,0]
[null,null,"Added Design Services:",null,null,null,null,null,null,null,{"$f":"SUM(J33:J36)","v":0}]
[null,null,"l","Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,20000000]
[null,null,"l","Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"AIPP %"]
[null,null,"l","Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0.01]
[null,null,"l","Other",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Max AIPP"]
[null,null,"Specialty Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J38:J43)","v":0},null,null,null,null,null,null,null,null,null,200000]
[null,null,"l","Laboratory Consultant",null,null,null,null,null,0]
[null,null,"l","Bldg. Code & Fire Safety Consultant",null,null,null,null,null,0]
[null,null,"l","Lighting Consultant",null,null,null,null,null,0]
[null,null,"l","Acoustical Consultant",null,null,null,null,null,0]
[null,null,"l","Cost Estimation Consultant",null,null,null,null,null,0]
[null,null,"l","Other- List"]
[null,null,"Asbestos/HazMat Consultant",null,null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":0}]
[null,null,"l","Asbestos/ Hazmat Survey",null,null,null,null,null,0]
[null,null,"l","Abatement Design",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Landscape Design Consultant:",null,null,null,null,null,null,null,{"$f":"SUM(J49:J50)","v":0}]
[null,null,"l","Base Design Fee",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"LEED: (Design, Testing, Admin.)",null,null,null,null,null,null,null,{"$f":"SUM(J52:J56)","v":0}]
[null,null,"l","LEED Consultant",null,null,null,null,null,0]
[null,null,"l","LEED Commissioning",null,null,null,null,null,0]
[null,null,"l","LEED Registration",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Project Design Contingency",null,null,null,"Percentage:",0,null,null,{"$f":"K28*H57","v":0}]
[null,null,"l"]
[null,"TOTAL DESIGN:",null,null,null,null,null,null,null,null,{"$f":"K18+K23+K28+K32+K37+K44+K48+K51+K57","v":0}]
[null,"CONSTRUCTION "]
[null,null,"Construction: ",null,null,null,null,null,null,null,{"$f":"SUM(J62:J64)","v":0}]
[null,null,"l","Maximum Allowable Construction Cost "]
[null,null,"l","Other ",null,null,null,null,null,0]
[null,null,"l","Other ",null,null,null,null,null,0]
[null,null,"Construction Contingency",null,null,null,null,"Percentage:",null,null,{"$f":"K61*J65","v":0}]
[null,null,"l"]
[null,null,"Other ",null,null,null,null,null,null,null,{"$f":"SUM(J68)","v":0}]
[null,null,"l",null,null,null,null,null,null,0]
[null,null,"Construction Testing (Div 1):  ",null,null,null,null,null,null,null,{"$f":"SUM(J70:J74)","v":0}]
[null,null,"l","Construction Testing",null,null,null,null,null,0]
[null,null,"l","IBC - Owner's Special Testing",null,null,null,null,null,0]
[null,null,"l","Indep. Testing of Kitchen Hoods",null,null,null,null,null,0]
[null,null,"l","Indep. Testing & Balance",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Asbestos/Hazard Matl Rem:  ",null,null,null,null,null,null,null,{"$f":"SUM(J76:J78)","v":0}]
[null,null,"l","Asbestos/Hazardous Material Removal (Div 2)",null,null,null,null,null,0]
[null,null,"l","Chemical Waste Disposal",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Integration with Campus Controls (Div 25)",null,null,null,null,null,null,null,{"$f":"J80","v":0}]
[null,null,"l","Niagara System",null,null,null,null,null,0]
[null,null,"Fire / Security Alarms (Div 28):  ",null,null,null,null,null,null,null,{"$f":"SUM(J82:J85)","v":0}]
[null,null,"l","Fire Alarm (Div 28)",null,null,null,null,null,0]
[null,null,"l","Fire Inspections ",null,null,null,null,null,0]
[null,null,"l","Security Monitor Systems",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Landscaping (Div 32):  ",null,null,null,null,null,null,null,{"$f":"SUM(J87:J88)","v":0}]
[null,null,"l","Landscaping (Div 32)",null,null,null,null,null,0]
[null,null,"l","Site Clearing",null,null,null,null,null,0]
[null,null,"Utilities (Div 33):  ",null,null,null,"6 Details 6",null,null,null,{"$f":"SUM(J90:J91)","v":0}]
[null,null,"l","Utilities (Div 33)",null,null,null,null,null,0]
[null,null,"l","Temporary Utilities for Construction",null,null,null,null,null,0]
[null,null,"Infrastructure Impact Fee ",null,null,null,null,null,null,null,{"$f":"SUM(J93:J95)","v":0}]
[null,null,"l","Infrastructure Impact Fee",null,null,null,null,null,0]
[null,null,"l","Utility Meters for Non-Campus Projects",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Shop Support (Sign,Key,Locates): ",null,null,null,null,null,null,null,{"$f":"SUM(J97:J107)","v":0}]
[null,null,"l","Signs",null,null,null,null,null,0]
[null,null,"l","Keys and Access",null,null,null,null,null,0]
[null,null,"l","Locates",null,null,null,null,null,0]
[null,null,"l","Landscape and Grounds Services"]
[null,null,"l","Building Services (Incl. Structural)"]
[null,null,"l","Custodial Shop"]
[null,null,"l","Mechanical Shop"]
[null,null,"l","Electrical Shop"]
[null,null,"l","Plumbing Shop"]
[null,null,"l","Other- List"]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,null,null,null,null,"TOTAL CONSTRUCTION:",null,null,null,{"$f":"K61+K65+K67+K69+K75+K79+K81+K86+K89+K92+K96","v":0}]
[null,"Owner Cost"]
[null,null,"Moveable Equip-NIC (Div 11): ",null,null,null,null,null,null,null,{"$f":"SUM(J111:J113)","v":0}]
[null,null,"l","Moveable Equipment - Not In Contract",null,null,null,null,null,0]
[null,null,"l","OFCI Equipment",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Way Finding",null,null,null,null,null,null,null,{"$f":"SUM(J115:J116)","v":0}]
[null,null,"l","Building Plaque:",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Furnishings:  ",null,null,null,null,null,null,null,{"$f":"J118+J119","v":0}]
[null,null,"l","Furnishings",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Comm, ICT, AV:  ",null,null,null,null,null,null,null,{"$f":"SUM(J121:J123)","v":0}]
[null,null,"l","Communications/ICT",null,null,null,null,null,0]
[null,null,"l","Audio Visual",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Moving Costs:  ",null,null,null,null,null,null,null,{"$f":"SUM(J125:J128)","v":0}]
[null,null,"l","Moving Costs",null,null,null,null,null,0]
[null,null,"l","Temp. Storage of Client's Equipment",null,null,null,null,null,0]
[null,null,"l","Demolition & Structure Moving",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,null,"Temp Facilities & Controls: ",null,null,null,null,null,null,null,{"$f":"SUM(J130:J133)","v":0}]
[null,null,"l","Temporary ICT Connection",null,null,null,null,null,0]
[null,null,"l","Temporary Utilities",null,null,null,null,null,0]
[null,null,"l","Temporary Construction Facilities",null,null,null,null,null,0]
[null,null,"l","Temporary Construction ",null,null,null,null,null,0]
[null,null,"Owner Requirements: ",null,null,null,null,null,null,null,{"$f":"SUM(J135:J138)","v":0}]
[null,null,"l","Other ",null,null,null,null,null,0]
[null,null,"l","Owner-Furnished Products",null,null,null,null,null,0]
[null,null,"l","Product Storage & Handling of HazMaterials",null,null,null,null,null,0]
[null,null,"l","Other- List",null,null,null,null,null,0]
[null,"TOTAL OTHER EXPENSES:",null,null,null,null,null,null,null,null,{"$f":"K110+K114+K117+K120+K124+K129+K134","v":0}]
[null,null,null,null,null,null,null,null,"Project Subtotal",null,{"$f":"K59+K108+K139","v":0}]
[null,null,null,null,null,null,null,null,"Administration Fee",null,{"$f":"X18","v":0}]
[null,null,null,null,null,null,null,null,"Total Project Cost",null,{"$f":"SUM(K140:K141)","v":0}]
[null,null,null,null,null,null,null,null,"Available Funding ",null,{"$f":"K16","v":0}]
[null,null,null,null,null,null,null,null,"Funding Surplus/Deficit",null,{"$f":"K143-K142","v":0}]

{"sheet":"HED","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,1,5,1],[4,0,5,0],[4,4,5,4]]}
[]
[]
[]
[]
["EXPENDITURES","ITEMS INCLUDED IN TOTAL COST  FOR EACH EXPENDITURE ","ORIGINAL SUBMISSION",null,"BUDGET REVISIONS"]
[null,null,"NEW CONSTRUCTION","ALTERATIONS"]
["A. Building Cost"]
["1. General"]
["2. Mechanical/Plumbing",null,null,null,null,10]
["3. Electrical ",null,null,null,null,10]
["4. Special Systems (voice, data, other)"]
["5. Demolition"]
["Building Construction Subtotal"]
["B. Built-in Equipment"]
["C. Site Development"]
["1. Utilities, Infrastructure"]
["2. Landscape/Site Improvements "]
["3. Demolition"]
[]
["Total Construction Cost (T.C.C)"]
[]
[]
[]
[]
[]
[]
["3. Surveys/Commissioning"]
["F. Movable Equipment"]
["H. Art in Public Places (1% of State Appropriation)"]
["I. Gross Receipts Tax"]
["J. Gross Receipts Tax"]
["TOTAL PROJECT BUDGET "]