{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","User's Guide","Project Information","Estimates Report","Estimates Details"],"not_rendered":{"charts":2,"images":47,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,1048575,18]]}

{"sheet":"User's Guide","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Project Information","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Estimates Report","index":3,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[[39,1,39,5],[71,1,71,5],[68,1,69,5],[36,1,37,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If the project is a combination of four types of facilities, administration; operation, maintenance; and vehicle storage, the percentage breakdown for each construction system is shown as follows:"]
[]
[]
[null,"Construction cost for each construction system "]
[null,"Construction System","%","Lower Boundary ($)","Most Likeyly Value ($)","Upper Boundary ($)"]
[null,"Building Sitework",20.04458087367178,{"$f":"ROUND(C42/100*$D$49,-1)","v":0},{"$f":"ROUND(C42/100*$E$49, -1)","v":0},{"$f":"ROUND(C42/100*$F$49, -1)","v":0}]
[null,"Substructure",12.872195985832349,{"$f":"ROUND(C43/100*$D$49,-1)","v":0},{"$f":"ROUND(C43/100*$E$49, -1)","v":0},{"$f":"ROUND(C43/100*$F$49, -1)","v":0}]
[null,"Shell",29.253624557260924,0,0]
[null,"Interior",13.292195985832349,0,0,0]
[null,"Services",17.993116883116883,0,0,0]
[null,"Equipment & Furnishing",5.6828571428571433,0,0,0]
[null,"Special Construction & Demolition",1,0,0,0]
[null,"Total Construction Cost",100.13857142857142]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If the project includes two or three types of following facilities: administration; operation; maintenance; and vehicle storage, the percentage breakdown for each construction system is shown as follows:"]
[]
[]
[null,"Construction cost for each construction system "]
[null,"Construction System","%","Lower Boundary ($)","Most Likeyly Value ($)","Upper Boundary ($)"]
[null,"Building Sitework",13.666666666666666,{"$f":"ROUND(C74*$D$81/100,-1)","v":0},{"$f":"ROUND(C74*$E$81/100,-1)","v":0},{"$f":"ROUND(C74*$F$81/100,-1)","v":0}]
[null,"Substructure",12.579042658819489,{"$f":"ROUND(C75*$D$81/100,-1)","v":0},{"$f":"ROUND(C75*$E$81/100,-1)","v":0},{"$f":"ROUND(C75*$F$81/100,-1)","v":0}]
[null,"Shell",34.832976752618229,0,0,0]
[null,"Interior",9.696406338732471,0,0,0]
[null,"Services",26.724907583163144,0,0,0]
[null,"Equipment & Furnishing",2,{"$f":"ROUND(C79*$D$81/100,-1)","v":0},0,0]
[null,"Special Construction & Demolition",0.5,0,0,0]
[null,"Total Construction Cost",{"$f":"SUM(C74:C80)","v":100}]

{"sheet":"Estimates Details","index":4,"n_rows":97,"n_cols":3,"rows_kept":97,"cut":false,"hidden":false,"merged":[[97,1,104,2],[96,1,96,2],[94,1,94,2],[28,0,28,1],[11,0,11,1],[22,0,22,1],[21,0,21,1],[13,0,13,1],[15,0,15,1],[18,0,18,1],[19,0,19,1],[14,0,14,1],[17,0,17,1],[20,0,20,1],[10,2,10,3],[10,0,10,1],[8,0,8,1],[9,0,9,1],[16,0,16,1]]}
[]
[]
[]
[]
[1,"Detailed calculations of construction cost based on regression analysis."]
["Estimated Design Start Year"]
["Estimated Construction Start Year"]
["Estimated Order of Magnitude of Project Size (sf)"]
["Cost Index for Design"]
["Cost Index for Construction"]
["Construction Location"]
["Location Factor"]
["Base Cost Estimates of Construction ($)",null,{"$f":"ROUND(172.6989 *C8*C10/202.7*C12/100,-2)","v":0}]
["Lower Boundary of Contingency (%)"]
["Most Likely Contingency (%)"]
["Upper Boundary of Contingency (%)"]
["Estiamted Contingency (Lower Boundary)($)",null,{"$f":"ROUND(C14*C13,-2)","v":0}]
["Estiamted Contingency (Most Likely Value)($)",null,{"$f":"ROUND(C13*C15,-2)","v":0}]
["Estiamted Contingency (Upper Boundary)($)",null,{"$f":"ROUND(C16*C13,-2)","v":0}]
["Total Construction Cost (Lower Boundar) ($)",null,{"$f":"ROUND(C17+C13,-3)","v":0}]
["Total Construction Cost (Most Likely Value) ($)",null,{"$f":"ROUND(C18+C13,-3)","v":0}]
["Total Construction Cost (Upper Boundary) ($)",null,{"$f":"ROUND(C19+C13,-3)","v":0}]
["Total Design Cost ($)",null,{"$f":"ROUND(31.635567 *C8*C9/202.7*C12/100,-3)","v":0}]
[]
[]
[]
[]
[2,"Historical Index"]
["Inflation rate"]
["Year","Year from 2014","Cost Index"]
[2014,0,202.7]
[2015,1,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2016,2,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2017,3,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2018,4,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2019,5,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2020,6,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2021,7,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2022,8,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2023,9,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2024,10,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[2025,11,{"$f":"$C$31*(1+$C$29)^Table2[[#This Row],[Year from 2014]]","v":202.7}]
[]
[]
[]
[]
[]
[]
[3,"Location Factor "]
[]
[null,"Region's Name","Location Factor"]
[null,"Region I: Connecticut,Maine,Massachusetts,New Hampshire,Rhode Island,Vermont",103.08499999999999]
[null,"Region II: New Jersey, New York, Puerto Rico, Virgin Islands",107.56500000000001]
[null,"Region III: Delaware, District of Columbia, Maryland, Pennsylvania, Virginia, West Virginia",96.01]
[null,"Region IV:Alabama,Florida,Georgia,Kentucky,Mississippi,North Carolina,South Carolina,Tennessee",84.325000000000003]
[null,"Region V: Illinois, Indiana, Michigan, Minnesota, Ohio, Wisconsin",99.495000000000005]
[null,"Region VI: Arkansas, Louisiana, New Mexico, Oklahoma, Texas",83.295000000000002]
[null,"Region VII: Iowa, Kansas, Missouri, Nebraska",91.580000000000013]
[null,"Region VIII: Colorado, Montana, North Dakota, South Dakota, Utah, Wyoming",86.73]
[null,"Region IX: Arizona, California, Hawaii, Nevada",102.005]
[null,"Region X: Alaska, Idaho, Oregon, Washington",102.12499999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,"Ranking of Risk Factors"]
[null,"Ranking","Risk Factors"]
[null,1,"Soil conditions "]
[null,2,"Unexpected underground conditions "]
[null,3,"Environmental issues "]
[null,4,"Increased scope "]
[null,5,"High project complexity "]
[null,6,"Lack of bidding competition "]
[null,7,"Higher transportation expenses "]
[null,8,"Omissions and errors in design "]
[null,9,"Unexpected weather conditions "]
[null,10,"Bidding time "]
[null,11,"Complaint from neighborhood "]
[null,12,"Lack of funding "]
[null,13,"Buy America compliance  "]
[null,14,"Material "]
[null,15,"Archaeological requirements "]
[]
["Note:  "]
[]
[null,"The user's comments on risk factors and contingency setting:"]