{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","UC Component Cost Summary","Cost Plan Summary","P or W Submit. Cost Plan Summ","Cost Conversion to CIB Format","Areas & Control Quantities"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[[18,1,18,9],[20,1,20,9],[25,1,25,9],[32,1,32,9],[37,1,37,9],[30,1,30,9],[16,1,16,9],[6,1,6,9],[8,1,8,9],[10,1,10,9],[12,1,12,9],[14,1,14,9]]}
["Cost Plan Workbook"]
["Instructions"]
[]
[]
["UC Component Cost Summary"]
[]
[null,"Insert Project Title in Cell A1."]
[]
[null,"Insert Plant Account number in Cell E1."]
[]
[null,"Insert Date of Estimate in Cell E2."]
[]
[null,"Leave the CCCI in Cell E4 as XXXX, until information is provided by UCOP."]
[]
[null,"Insert Overall Gross Square Feet (OGSF) for project in Cell G6."]
[]
[null,"In the shaded cells of Column E, enter construction cost from the cost estimate in thousands-of-dollars ($,000)."]
[]
[null,"Complete the shaded inflation calculations using project schedule and estimated percentages for annual inflation."]
[]
[null,"Specify the design contingency assumptions incorporated in the base component costs, as a percentage in Cell B64."]
[]
[]
["Cost Plan Summary and P or W Submit. Cost Plan Summ"]
[]
[null,"These forms are completed automatically with the information provided in the Component Cost Summary worksheet and require no input."]
[]
[]
["Cost Conversion to CIB Format"]
[]
[null,"In the shaded cells of Columns D, F, H, and J, enter the construction cost for those items that are outside the construction contract and will be completed by the campus (i.e., telecommunications, builder’s risk insurance, etc.).  Provide the description of the cost in Column A."]
[]
[null,"The totals in Row 32 should match Lines 0, 1, 2, and 4 on your CIB."]
[]
[]
["Area and Control Quantities"]
[]
[null,"Insert in the shaded areas of Column D the unit values of key control quantities (i.e., enclosed area, volume, elevators, etc.).  This information needs to be provided either in this worksheet or in the detailed cost estimate."]

{"sheet":"UC Component Cost Summary","index":1,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3]]}
["<Project Title>",null,"Plant Account Number:",null,999999]
["<Bid Package>",null,null,"Date of Estimate:","1955-05-05"]
[" ",null,"Budget Year:",null,"2007-08"]
["<Campus>",null,"CCCI of Budget Year:",null,"XXXX"]
[]
[null,null,null,null,null,"OGSF:",100000]
["UC COMPONENT COST SUMMARY WORKSHEET"]
["P or W Submittal - State Funded Projects",null,null,"Construction Cost with",null,"Construction Cost with markups"]
[null,null,null,"markups broken out",null,"incl. escalation rolled up"]
[null,null,null,"$/OGSF","Cost ($x1,000)","$/OGSF","Cost ($x1,000)"]
["1. Foundations",null,null,{"$f":"(E11*1000)/$G$6","v":20},2000,{"$f":"(G11*1000)/$G$6","v":26.193024000000005},{"$f":"E11*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":2619.3024000000005}]
["2. Vertical Structure",null,null,{"$f":"(E12*1000)/$G$6","v":10},1000,13.096512000000002,1309.6512000000002]
["3. Floor & Roof Structures",null,null,{"$f":"(E13*1000)/$G$6","v":10},1000,13.096512000000002,1309.6512000000002]
["4. Exterior Cladding",null,null,{"$f":"(E14*1000)/$G$6","v":10},1000,13.096512000000002,1309.6512000000002]
["5. Roofing & Waterproofing",null,null,{"$f":"(E15*1000)/$G$6","v":10},1000,13.096512000000002,1309.6512000000002]
["Shell (1-5)",null,null,{"$f":"SUM(D11:D15)","v":60},{"$f":"SUM(E11:E15)","v":6000},78.579072000000011,7857.9072000000015]
[]
["6. Interior Partitions, Doors & Glazing",null,null,{"$f":"(E18*1000)/$G$6","v":10},1000,{"$f":"(G18*1000)/$G$6","v":13.096512000000002},{"$f":"E18*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["7. Floor, Wall & Ceiling Finishes",null,null,{"$f":"(E19*1000)/$G$6","v":10},1000,{"$f":"(G19*1000)/$G$6","v":13.096512000000002},{"$f":"E19*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["Interiors (6-7)",null,null,{"$f":"SUM(D18:D19)","v":20},{"$f":"SUM(E18:E19)","v":2000},{"$f":"(G20*1000)/$G$6","v":26.193024000000005},{"$f":"E20*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":2619.3024000000005}]
[]
["8. Function Equipment & Specialties",null,null,{"$f":"(E22*1000)/$G$6","v":10},1000,{"$f":"(G22*1000)/$G$6","v":13.096512000000002},{"$f":"E22*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["9. Stairs & Vertical Transportation",null,null,{"$f":"(E23*1000)/$G$6","v":10},1000,{"$f":"(G23*1000)/$G$6","v":13.096512000000002},{"$f":"E23*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["Equipment &Vertical Transportation",null,null,{"$f":"SUM(D22:D23)","v":20},{"$f":"SUM(E22:E23)","v":2000},{"$f":"(G24*1000)/$G$6","v":26.193024000000005},{"$f":"E24*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":2619.3024000000005}]
[]
["10. Plumbing Systems",null,null,{"$f":"(E26*1000)/$G$6","v":10},1000,{"$f":"(G26*1000)/$G$6","v":13.096512000000002},{"$f":"E26*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["1 1. Heating, Ventilating & Air Conditioning",null,null,{"$f":"(E27*1000)/$G$6","v":10},1000,{"$f":"(G27*1000)/$G$6","v":13.096512000000002},{"$f":"E27*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["12. Electric Lighting, Power & Communications",null,null,{"$f":"(E28*1000)/$G$6","v":10},1000,{"$f":"(G28*1000)/$G$6","v":13.096512000000002},{"$f":"E28*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["13. Fire Protection Systems",null,null,{"$f":"(E29*1000)/$G$6","v":10},1000,{"$f":"(G29*1000)/$G$6","v":13.096512000000002},{"$f":"E29*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["Mechanical & Electrical",null,null,{"$f":"SUM(D26:D29)","v":40},{"$f":"SUM(E26:E29)","v":4000},{"$f":"(G30*1000)/$G$6","v":52.386048000000009},{"$f":"E30*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":5238.604800000001}]
[]
["Total Building Construction (1-13)","(Sub 1)",null,{"$f":"D16+D20+D24+D30","v":140},{"$f":"E16+E20+E24+E30","v":14000},{"$f":"F16+F20+F24+F30","v":183.35116800000003},{"$f":"G16+G20+G24+G30","v":18335.116800000003}]
[]
["14. Site Preparation & Demolition","(Sub 0)",null,{"$f":"(E34*1000)/$G$6","v":10},1000,{"$f":"(G34*1000)/$G$6","v":13.096512000000002},{"$f":"E34*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1309.6512000000002}]
["15. Site Paving, Structures & Landscaping","(Sub 4)",null,{"$f":"(E35*1000)/$G$6","v":15},1500,{"$f":"(G35*1000)/$G$6","v":19.644768000000003},{"$f":"E35*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":1964.4768000000004}]
["16. Utilities on Site","(Sub 2)",null,{"$f":"(E36*1000)/$G$6","v":25},2500,{"$f":"(G36*1000)/$G$6","v":32.741280000000003},{"$f":"E36*(1+$C$42)*(1+$C$43)*(1+($B$49*$C$49))*(1+($B$57*$C$57))*(1+($B$59*$C$59))","v":3274.1280000000002}]
[]
["Total Site Construction (14-16)",null,null,{"$f":"SUM(D34:D36)","v":50},{"$f":"SUM(E34:E36)","v":5000},{"$f":"(G38*1000)/$G$6","v":65.482560000000007},{"$f":"SUM(G34:G36)","v":6548.2560000000012}]
[]
["TOTAL BUILDING & SITE (1-16)*",null,null,{"$f":"D32+D38","v":190},{"$f":"E32+E38","v":19000},{"$f":"(G40*1000)/$G$6","v":248.83372800000004},{"$f":"G32+G38","v":24883.372800000005}]
[]
["General Conditions",null,0.08,{"$f":"(E42*1000)/$G$6","v":15.2},{"$f":"E40*C42","v":1520}]
["Contractor's Overhead & Profit or Fee",null,0.04,{"$f":"(E43*1000)/$G$6","v":8.208000000000002},{"$f":"(E40+E42)*C43","v":820.80000000000007}]
[]
["Budget bid price as of date of estimate",null,null,{"$f":"D40+D41+D42+D43","v":213.40799999999999},{"$f":"E40+E41+E42+E43","v":21340.799999999999}]
[]
["Escalation to Start of Budget Year","Years","Annual Inflation"]
["Escalation from date of estimate to July 1  "]
["of the Budget Year",1,0.1,{"$f":"(E49*1000)/$G$6","v":21.340800000000002},{"$f":"B49*C49*E45","v":2134.08}]
[]
["Escalation from Budget Year to C Approp. Year"]
["Anticipated CCCI escalation from July 1 of Budget  "]
["Yr.  to July 1 of C Appropriation Yr. ",2,0.05]
["Anticipated actual escalation from July 1 of Budget  "]
["Yr.  to July 1 of C Appropriation Yr. ",2,0.08]
["Anticipated difference between CCCI"]
["adjustment and inflation",{"$f":"B55","v":2},{"$f":"C55-C53","v":0.03},{"$f":"(E57*1000)/$G$6","v":14.084927999999998},{"$f":"B57*C57*(E45+E49)","v":1408.4927999999998}]
["Escalation from July 1 of  C Appropriation Yr. to"]
["planned bid date (if any)",0,7.0000000000000007E-2,{"$f":"(E59*1000)/$G$6","v":0},{"$f":"B59*C59*(E45+E49+E57)","v":0}]
["Total Adjustment for escalation",null,null,null,{"$f":"+E49+E57+E59","v":3542.5727999999999}]
[]
["ESTIMATED CONSTRUCTION BUDGET ",null,null,{"$f":"(E62*1000)/$G$6","v":248.83372799999998},{"$f":"E45+E49+E57+E59","v":24883.372799999997}]
[]
["*Above component costs include a design contingency of:",0]
[]
["Note - above component costs include escalation to the midpoint of construction. "]

{"sheet":"Cost Plan Summary","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,3],[2,2,2,3]]}
[{"$f":"'UC Component Cost Summary'!A1","v":"<Project Title>"},null,"Plant Account Number:",null,{"$f":"'UC Component Cost Summary'!E1","v":999999}]
[{"$f":"'UC Component Cost Summary'!A2","v":"<Bid Package>"},null,null,"Date of Estimate:",{"$f":"'UC Component Cost Summary'!E2","v":"1955-05-05"}]
[null,null,"Budget Year:",null,{"$f":"+'UC Component Cost Summary'!E3","v":"2007-08"}]
[{"$f":"'UC Component Cost Summary'!A4","v":"<Campus>"},null,null,"CCCI:",{"$f":"+'UC Component Cost Summary'!E4","v":"XXXX"}]
[]
[]
["COST PLAN SUMMARY"]
[]
[null,"Construction Cost ($X1,000)"]
[]
["1. Foundations",null,{"$f":"'UC Component Cost Summary'!G11","v":2619.3024000000005}]
["2. Vertical Structure",null,{"$f":"'UC Component Cost Summary'!G12","v":1309.6512000000002}]
["3. Floor & Roof Structures",null,{"$f":"'UC Component Cost Summary'!G13","v":1309.6512000000002}]
["4. Exterior Cladding",null,{"$f":"'UC Component Cost Summary'!G14","v":1309.6512000000002}]
["5. Roofing & Waterproofing",null,{"$f":"'UC Component Cost Summary'!G15","v":1309.6512000000002}]
["Shell (1-5)",null,{"$f":"'UC Component Cost Summary'!G16","v":7857.9072000000015}]
[]
["6. Interior Partitions, Doors & Glazing",null,{"$f":"'UC Component Cost Summary'!G18","v":1309.6512000000002}]
["7. Floor, Wall & Ceiling Finishes",null,{"$f":"'UC Component Cost Summary'!G19","v":1309.6512000000002}]
["Interiors (6-7)",null,{"$f":"'UC Component Cost Summary'!G20","v":2619.3024000000005}]
[]
["8. Function Equipment & Specialties",null,{"$f":"'UC Component Cost Summary'!G22","v":1309.6512000000002}]
["9. Stairs & Vertical Transportation",null,{"$f":"'UC Component Cost Summary'!G23","v":1309.6512000000002}]
["Equipment &Vertical Transportation",null,{"$f":"'UC Component Cost Summary'!G24","v":2619.3024000000005}]
[]
["10. Plumbing Systems",null,{"$f":"'UC Component Cost Summary'!G26","v":1309.6512000000002}]
["1 1. Heating, Ventilating & Air Conditioning",null,{"$f":"'UC Component Cost Summary'!G27","v":1309.6512000000002}]
["12. Electric Lighting, Power & Communications",null,{"$f":"'UC Component Cost Summary'!G28","v":1309.6512000000002}]
["13. Fire Protection Systems",null,{"$f":"'UC Component Cost Summary'!G29","v":1309.6512000000002}]
["Mechanical & Electrical",null,{"$f":"'UC Component Cost Summary'!G30","v":5238.604800000001}]
[]
["Total Building Construction (1-13)","(Sub 1)",{"$f":"'UC Component Cost Summary'!G32","v":18335.116800000003}]
[]
["14. Site Preparation & Demolition","(Sub 0)",{"$f":"'UC Component Cost Summary'!G34","v":1309.6512000000002}]
["15. Site Paving, Structures & Landscaping","(Sub 4)",{"$f":"'UC Component Cost Summary'!G35","v":1964.4768000000004}]
["16. Utilities on Site","(Sub 2)",{"$f":"'UC Component Cost Summary'!G36","v":3274.1280000000002}]
[]
["Total Site Construction (14-16)",null,{"$f":"'UC Component Cost Summary'!G38","v":6548.2560000000012}]
[]
["ESTIMATED CONSTRUCTION BUDGET",null,{"$f":"'UC Component Cost Summary'!G40","v":24883.372800000005}]

{"sheet":"P or W Submit. Cost Plan Summ","index":3,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,2,0,5],[1,2,1,5],[2,2,2,5],[3,2,3,5]]}
[{"$f":"'UC Component Cost Summary'!A1","v":"<Project Title>"},null,"Plant Account Number:",null,null,null,{"$f":"'UC Component Cost Summary'!E1","v":999999}]
[{"$f":"'UC Component Cost Summary'!A2","v":"<Bid Package>"},null,"Date of Estimate:",null,null,null,{"$f":"'UC Component Cost Summary'!E2","v":"1955-05-05"}]
[null,null,"Budget Year:",null,null,null,{"$f":"'UC Component Cost Summary'!E3","v":"2007-08"}]
[{"$f":"'UC Component Cost Summary'!A4","v":"<Campus>"},null,"CCCI:",null,null,null,{"$f":"'UC Component Cost Summary'!E4","v":"XXXX"}]
[]
["COST PLAN SUMMARY"]
["P or W Submittal"]
[null,"Construction Cost ($X1,000)"]
[]
["1. Foundations",null,{"$f":"'UC Component Cost Summary'!E11","v":2000}]
["2. Vertical Structure",null,{"$f":"'UC Component Cost Summary'!E12","v":1000}]
["3. Floor & Roof Structures",null,{"$f":"'UC Component Cost Summary'!E13","v":1000}]
["4. Exterior Cladding",null,{"$f":"'UC Component Cost Summary'!E14","v":1000}]
["5. Roofing & Waterproofing",null,{"$f":"'UC Component Cost Summary'!E15","v":1000}]
["Shell (1-5)",null,{"$f":"'UC Component Cost Summary'!E16","v":6000}]
[]
["6. Interior Partitions, Doors & Glazing",null,{"$f":"'UC Component Cost Summary'!E18","v":1000}]
["7. Floor, Wall & Ceiling Finishes",null,{"$f":"'UC Component Cost Summary'!E19","v":1000}]
["Interiors (6-7)",null,{"$f":"'UC Component Cost Summary'!E20","v":2000}]
[]
["8. Function Equipment & Specialties",null,{"$f":"'UC Component Cost Summary'!E22","v":1000}]
["9. Stairs & Vertical Transportation",null,{"$f":"'UC Component Cost Summary'!E23","v":1000}]
["Equipment &Vertical Transportation",null,{"$f":"'UC Component Cost Summary'!E24","v":2000}]
[]
["10. Plumbing Systems",null,{"$f":"'UC Component Cost Summary'!E26","v":1000}]
["1 1. Heating, Ventilating & Air Conditioning",null,{"$f":"'UC Component Cost Summary'!E27","v":1000}]
["12. Electric Lighting, Power & Communications",null,{"$f":"'UC Component Cost Summary'!E28","v":1000}]
["13. Fire Protection Systems",null,{"$f":"'UC Component Cost Summary'!E29","v":1000}]
["Mechanical & Electrical",null,{"$f":"'UC Component Cost Summary'!E30","v":4000}]
[null,null,null,null,null,"CIB lines incl. Markups"]
["Total Building Construction (1-13)",null,{"$f":"'UC Component Cost Summary'!E32","v":14000},null,"(Sub 1)",{"$f":"+'UC Component Cost Summary'!G32","v":18335.116800000003}]
[]
["14. Site Preparation & Demolition",null,{"$f":"'UC Component Cost Summary'!E34","v":1000},null,"(Sub 0)",{"$f":"+'UC Component Cost Summary'!G34","v":1309.6512000000002}]
["15. Site Paving, Structures & Landscaping",null,{"$f":"'UC Component Cost Summary'!E35","v":1500},null,"(Sub 4)",{"$f":"+'UC Component Cost Summary'!G35","v":1964.4768000000004}]
["16. Utilities on Site",null,{"$f":"'UC Component Cost Summary'!E36","v":2500},null,"(Sub 2)",{"$f":"+'UC Component Cost Summary'!G36","v":3274.1280000000002}]
[]
["Total Site Construction (14-16)",null,{"$f":"'UC Component Cost Summary'!E38","v":5000},null,null,{"$f":"+F33+F34+F35","v":6548.2560000000012}]
[]
["TOTAL BUILDING & SITE (1-16)",null,{"$f":"'UC Component Cost Summary'!$E$40","v":19000},null,null,{"$f":"+F31+F37","v":24883.372800000005}]
[]
["General Conditions",{"$f":"'UC Component Cost Summary'!$C$42","v":0.08},{"$f":"'UC Component Cost Summary'!$E$42","v":1520}]
["Contractor's Overhead & Profit or Fee",{"$f":"'UC Component Cost Summary'!$C$43","v":0.04},{"$f":"'UC Component Cost Summary'!$E$43","v":820.80000000000007}]
["Adjustment for escalation",null,{"$f":"'UC Component Cost Summary'!$E$60","v":3542.5727999999999}]
[]
["ESTIMATED CONSTRUCTION BUDGET",null,{"$f":"+C31+C37+C41+C42+C43","v":24883.372799999997}]

{"sheet":"Cost Conversion to CIB Format","index":4,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'UC Component Cost Summary'!A1","v":"<Project Title>"},null,null,null,null,"Plant Account Number:",null,{"$f":"'UC Component Cost Summary'!E1","v":999999}]
[{"$f":"'UC Component Cost Summary'!A2","v":"<Bid Package>"},null,null,null,null,"Date of Estimate:",null,{"$f":"'UC Component Cost Summary'!E2","v":"1955-05-05"}]
[null,null,null,null,null,"Budget Year:",null,{"$f":"'UC Component Cost Summary'!E3","v":"2007-08"}]
[{"$f":"'UC Component Cost Summary'!A4","v":"<Campus>"},null,null,null,null,"CCCI:",null,{"$f":"'UC Component Cost Summary'!E4","v":"XXXX"}]
[]
[]
["Cost Conversion to CIB Format"]
[]
[null,"Total",null,"Sub 0",null,"Sub 1",null,"Sub 2",null,"Sub 4"]
["Construction Cost Estimate ",{"$f":"'UC Component Cost Summary'!$G$40","v":24883.372800000005},null,{"$f":"'UC Component Cost Summary'!$G$34","v":1309.6512000000002},null,{"$f":"'UC Component Cost Summary'!$G$32","v":18335.116800000003},null,{"$f":"'UC Component Cost Summary'!$G$36","v":3274.1280000000002},null,{"$f":"'UC Component Cost Summary'!$G$35","v":1964.4768000000004}]
["Additional Construction Items not covered "]
["in above Estimate: "]
["<example>Hazardous materials abatement",{"$f":"SUM(D13:J13)","v":35},null,10,null,25]
["<example>Telecommunications work by campus",{"$f":"SUM(D14:J14)","v":75},null,null,null,75]
["<example>Builder's Risk Insurance",{"$f":"SUM(D15:J15)","v":40},null,null,null,null,null,40]
["<etc.>",{"$f":"SUM(D16:J16)","v":0}]
[null,{"$f":"SUM(D17:J17)","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
["SubTotal - Add. Const. Costs.",{"$f":"SUM(B13:B37)","v":150},null,{"$f":"SUM(D13:D37)","v":10},null,{"$f":"SUM(F13:F37)","v":100},null,{"$f":"SUM(H13:H37)","v":40},null,{"$f":"SUM(J13:J37)","v":0}]
[]
["TOTAL ",{"$f":"+B39+B10","v":25033.372800000005},null,{"$f":"+D39+D10","v":1319.6512000000002},null,{"$f":"+F39+F10","v":18435.116800000003},null,{"$f":"+H39+H10","v":3314.1280000000002},null,{"$f":"+J39+J10","v":1964.4768000000004}]
[null,"Total",null,"Sub 0",null,"Sub 1",null,"Sub 2",null,"Sub 4"]

{"sheet":"Areas & Control Quantities","index":5,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
[{"$f":"'UC Component Cost Summary'!A1","v":"<Project Title>"},{"$f":"'UC Component Cost Summary'!C1","v":"Plant Account Number:"},null,{"$f":"'UC Component Cost Summary'!E1","v":999999}]
[{"$f":"+'UC Component Cost Summary'!A2","v":"<Bid Package>"},{"$f":"'UC Component Cost Summary'!D2","v":"Date of Estimate:"},null,{"$f":"'UC Component Cost Summary'!E2","v":"1955-05-05"}]
[{"$f":"+'UC Component Cost Summary'!A3","v":" "},{"$f":"'UC Component Cost Summary'!C3","v":"Budget Year:"},null,{"$f":"'UC Component Cost Summary'!E3","v":"2007-08"}]
[{"$f":"'UC Component Cost Summary'!A4","v":"<Campus>"},{"$f":"'UC Component Cost Summary'!C4","v":"CCCI of Budget Year:"},null,{"$f":"'UC Component Cost Summary'!E4","v":"XXXX"}]
[]
["AREAS & CONTROL QUANTITIES"]
[]
[]
["TOTAL GROSS AREA (ogsf)",null,null,100000]
[]
["Control Quantities  *",null,null,null,null,"Ratio to"]
[null,null,null,null,null,"Gross Area"]
["Gross Area",null,null,100000,"SF",{"$f":"+D13/$D$9","v":1}]
["Enclosed Area",null,null,99111,"SF",0.99111000000000005]
["Covered-Unenclosed Area",null,null,1778,"SF",1.7780000000000001E-2]
["Volume",null,null,1200000,"CF",12]
["Crawl Space Volume",null,null,0,"CF",0]
["Gross Wall Area",null,null,75000,"SF",0.75]
["Retaining Wall Area",null,null,0,"SF",0]
["Finished Wall Area",null,null,50000,"SF",0.5]
["Interstitial Floor Area        ","Included in OGSF?  ","Yes or No",0,"SF",0]
["Exterior Windows or Glazing Area",null,null,10000,"SF",0.1]
["Roof Area - Flat",null,null,20000,"SF",0.2]
["Roof Area - Sloping",null,null,0,"SF",0]
["Roof Glazing Area",null,null,0,"SF",0]
["Interior Partition Length",null,null,8000,"LF",0.08]
["Finished Area",null,null,100000,"SF",1]
["Fume Hoods (x 1,000)",null,null,40,"EA",4.0000000000000002E-4]
["Laboratory Casework (Base, Wall, Standing)",null,null,2000,"LF",0.02]
["Elevators (x10,000)",null,null,2,"EA",{"$f":"+D30/$D$9*10000","v":0.2}]
["Plumbing Fixtures (x l,000)",null,null,95,"EA",{"$f":"+D31/$D$9*1000","v":0.95}]
["Electrical Connected Load (x 1,000)",null,null,4000,"KW",{"$f":"+D32/$D$9*1000","v":40}]
[]
["*  For preliminary estimates, use best available data and explain on following sheets"]
[]
[{"$f":"A1","v":"<Project Title>"},null,{"$f":"C1","v":0}]
[{"$f":"A4","v":"<Campus>"},null,{"$f":"C4","v":0}]
[]
[]
["Breakdown of asf by functional use",null,null,null,null,"Ratio toTotal"]
["(define as most appropriate for your project based on the PPG)",null,null,null,null,"Assignable  Area"]
[]
["\"High Intensity\" Wet Lab/Service",null,null,10000,"asf",{"$f":"+D43/$D$58","v":0.16666666666666666}]
["\"Low Intensity\" Wet Lab/Service",null,null,10000,"asf",{"$f":"+D44/$D$58","v":0.16666666666666666}]
["Generic Dry Lab",null,null,5000,"asf",{"$f":"+D45/$D$58","v":8.3333333333333329E-2}]
["Engineering Lab - complex",null,null,0,"asf"]
["Engineering Lab - simple",null,null,0,"asf"]
["Classroom",null,null,8000,"asf",{"$f":"+D48/$D$58","v":0.13333333333333333}]
["Generic Dry Office/Other ",null,null,15000,"asf",0.25]
["Other Specialized uses:",null,null,0,"asf",0]
["Vivaria",null,null,12000,"asf",0.2]
["NMR",null,null,0,"asf",0]
["Clean Room",null,null,0,"asf",0]
["Library",null,null,0,"asf",0]
["Lecture Hall",null,null,0,"asf",0]
["    ___________  (Other - define)",null,null,0,"asf",{"$f":"+D56/$D$58","v":0}]
[]
["TOTAL ASF",null,null,{"$f":"SUM(D43:D56)","v":60000},"asf",{"$f":"SUM(F43:F56)","v":1}]