{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["0-Acronyms+Abbreviations","1-INFORMATION","2-PD-SD-ESTIMATE SUMMARY","2-PD-SD-LABOR","2-PD-SD-OTHER DIRECT COSTS","3-RFP-ESTIMATE SUMMARY","3-RFP-LABOR","3-RFP-OTHER DIRECT COSTS","4-DD-CD-ESTIMATE SUMMARY","4-DD-CD-LABOR","4-DD-CD-OTHER DIRECT COSTS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"0-Acronyms+Abbreviations","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Acronyms and Abbreviations used in this Workbook"]
["#","Number"]
["AE or A/E","Architect/Engineer"]
["Arch.","Architect"]
["CAD","Computer Aided Design"]
["CD","Construction Documents"]
["DD","Design Development"]
["DSC","Denver Service Center"]
["Engr.","Engineer"]
["Est.","Estimator"]
["IDIQ","Indefinite Delivery / Indefinite Quantity"]
["IGE","Independent Government Estimate"]
["IRB","Investment Review Board"]
["LA / Land. Arch.","Landscape Architect"]
["NPS","National Park Service"]
["PD","Pre Design"]
["PM","Project Manager"]
["PMIS","Project Management Information System"]
["PS","Project Specialist"]
["RFP","Request for Proposals"]
["SD","Schematic Design"]
["Tech","Technician"]
["TO","Task Order"]

{"sheet":"1-INFORMATION","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Welcome to the Government Estimate and Architect & Engineer Cost Task Order Template for Pre-Design, Schematic Design, Request for Proposal, Design Development, and Construction Documents.                                                             "]
["READ THIS PAGE BEFORE USING THIS ESTIMATE TEMPLATE"]
[1,"This template is intended to be a guiding tool. It is not intended to catch every possible line item requiring an estimate. It is the user's responsibility to modify this template to fit their needs. "]
[{"$f":"A3+1","v":2},"The template includes estimate templates for PD/SD, PD/SD/RFP, and DD/CD. Each has two lines for supplemental services. "]
[{"$f":"A4+1","v":3},"The light gray cells are those requiring input of values."]
[4,"The dark gray cells can be changed as needed. The current value in those cell are what has been typically used."]
[5,"Each worksheet is locked. This is to protect the functionality of this formulas in this template. When protected the cells that have been formatted to be locked can not be modified. "]
[6,"When adding rows or columns formulas may become broken. It is the user's responsibility to understand how the formulas work and modify them as appropriate for any changes. "]
[7,"The NPS Project Manager or Project Specialist can unlock and modify this template as they see appropriate. Once modified, the PM or PS can protect the worksheet again then share with the AE. This ensures the IGE and AE are estimating the same line items."]
[8,"AE's should not modify this template unless directed to do so. "]
[9,"The password used for protecting each sheet is 'DSC'."]
[]
["DISCLAIMERS"]
[1,"The developers of this template can not guarantee all formulas function properly. It is the user's responsibility to ensure formulas function correctly and produce correct numbers. "]
[2,"The Denver Services Center is not responsible for inaccurate estimates produced by this template. It is the AE's responsibility to ensure this template provides an accurate cost. "]
["By using this template you acknowledge it is your responsibility to ensure all numbers produced are correct and accurate. "]
["Form Updated 8-31-26"]

{"sheet":"2-PD-SD-ESTIMATE SUMMARY","index":2,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Task Order Price Estimate or Proposal - Pre-Design + Schematic Design"]
["Park:",null,null,null,"PMIS:",null,null,null,null,"Prepared By:"]
["IDIQ Firm:",null,null,null,"Contract #",null,null,null,null,"Task Order #"]
["Project Title:"]
[]
["Please use this template as a guide and verify math and calculations prior to submittal."]
[]
["Numbers, percentages, or items to be completed on this sheet are highlighted in RED. All other numbers are automatically transferred from the Labor and Other Direct Costs worksheets."]
[]
[]
["Predesign (PD) + Schematic Design (SD)"]
["Work Tasks",null,null,null,null,null,null,"Direct Labor",null,"Other Direct Costs","Amount"]
[{"$f":"'2-PD-SD-LABOR'!A10","v":"1.1 Prepare Contextual Analysis"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP10","v":0},null,{"$f":"SUM('2-PD-SD-OTHER DIRECT COSTS'!AP20,'2-PD-SD-OTHER DIRECT COSTS'!AP28,'2-PD-SD-OTHER DIRECT COSTS'!AP31,'2-PD-SD-OTHER DIRECT COSTS'!AP34,'2-PD-SD-OTHER DIRECT COSTS'!AP37,'2-PD-SD-OTHER DIRECT COSTS'!AP40,'2-PD-SD-OTHER DIRECT COSTS'!AP43,'2-PD-SD-OTHER DIRECT COSTS'!AP46)","v":0},{"$f":"H13+J13","v":0}]
[{"$f":"'2-PD-SD-LABOR'!A11","v":"1.2 Prepare Project Program"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP11","v":0},null,null,{"$f":"H14","v":0}]
[{"$f":"'2-PD-SD-LABOR'!A12","v":"1.3 Prepare Integrated Design Narrative"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP12","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A13","v":"1.4 Complete Contextual Analysis Template"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP13","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A14","v":"1.5.1 Prepare Permitting Assessment Form (PAF)"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP14","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A15","v":"1.6 Prepare Class C Construction Cost Estimate"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP15","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A16","v":"1.7.1 Submit 100% Draft Predesign Documents for Review"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP16","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A17","v":"1.7.2 Submit Final Predesign Documents"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP17","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A19","v":"2.1 Design Concepts Assessment"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP19","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A20","v":"2.2 Develop Schematic Design Alternatives"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP20","v":0},null,{"$f":"SUM('2-PD-SD-OTHER DIRECT COSTS'!AP21,'2-PD-SD-OTHER DIRECT COSTS'!AP50,'2-PD-SD-OTHER DIRECT COSTS'!AP53,'2-PD-SD-OTHER DIRECT COSTS'!AP56,'2-PD-SD-OTHER DIRECT COSTS'!AP59,'2-PD-SD-OTHER DIRECT COSTS'!AP62,'2-PD-SD-OTHER DIRECT COSTS'!AP65,'2-PD-SD-OTHER DIRECT COSTS'!AP68)","v":0},{"$f":"H22+J22","v":0}]
[{"$f":"'2-PD-SD-LABOR'!A21","v":"2.3 Conduct Value Methodology"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP21","v":0},null,null,{"$f":"H23","v":0}]
[{"$f":"'2-PD-SD-LABOR'!A22","v":"2.4 Fully Develop Schematic Design Preferred Alternative"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP22","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A23","v":"2.5 Prepare Basis of Design Report (BDR)"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP23","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A24","v":"2.6 Initiate NPS Constructability Checklist (SD Comments)"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP24","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A25","v":"2.7 Prepare Class B Construction Cost Estimate"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP25","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A26","v":"2.8.1 Finalize Permitting Assessment Form (PAF)"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP26","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A27","v":"2.8.2 Prepare Permitting Road Map"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP27","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A28","v":"2.8.3 Prepare Permit Plans"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP28","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A29","v":"2.9.1 Submit 100% Draft Schematic Design Documents for Review"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP29","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A30","v":"2.9.2 Submit Final Schematic Design Documents"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP30","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A31","v":"2.9.2.1 Prepare and Submit Investment Review Board (IRB) Support Documents"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP31","v":0},null,null,0]
[{"$f":"'2-PD-SD-LABOR'!A32","v":"2.9.3 Prepare and Submit Response Memorandum"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP32","v":0},null,null,0]
[null,null,null,null,null,null,null,"Total PD +SD",null,null,{"$f":"SUM(K13:K34)","v":0}]
[]
["Supplemental Services",null,null,null,null,null,null,"Direct Labor",null,"Other Direct Costs","Amount"]
[{"$f":"'2-PD-SD-LABOR'!A36","v":"Supplemental Services 1"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP36","v":0},null,{"$f":"SUM('2-PD-SD-OTHER DIRECT COSTS'!AP22,'2-PD-SD-OTHER DIRECT COSTS'!AP72,'2-PD-SD-OTHER DIRECT COSTS'!AP75,'2-PD-SD-OTHER DIRECT COSTS'!AP78,'2-PD-SD-OTHER DIRECT COSTS'!AP81,'2-PD-SD-OTHER DIRECT COSTS'!AP84,'2-PD-SD-OTHER DIRECT COSTS'!AP87,'2-PD-SD-OTHER DIRECT COSTS'!AP90)","v":0},{"$f":"SUM(H38:J38)","v":0}]
[{"$f":"'2-PD-SD-LABOR'!A37","v":"Supplemental Services 2"},null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AP37","v":0},null,{"$f":"SUM('2-PD-SD-OTHER DIRECT COSTS'!AP23,'2-PD-SD-OTHER DIRECT COSTS'!AP94,'2-PD-SD-OTHER DIRECT COSTS'!AP97,'2-PD-SD-OTHER DIRECT COSTS'!AP100,'2-PD-SD-OTHER DIRECT COSTS'!AP103,'2-PD-SD-OTHER DIRECT COSTS'!AP106,'2-PD-SD-OTHER DIRECT COSTS'!AP109,'2-PD-SD-OTHER DIRECT COSTS'!AP112)","v":0},{"$f":"SUM(H39:J39)","v":0}]
[null,null,null,null,null,null,null,"Total Supplemental Services",null,null,{"$f":"SUM(K38:K39)","v":0}]
[]
[]
["Project Net Cost of Construction ",null,null,null,null,null,"$",null,null,"(Net Cost is net dollars available in "]
[null,null,null,null,null,null,null,null,null,"the year the project will be obligated.)"]
[]
[null,null,null,"PD equals:",{"$f":"IF(K35=0,\"\",(SUM(K13:K20)/H43)*100)","v":""},"% of Net Construction Costs"]
[null,null,null,"SD equals:",{"$f":"IF(K35=0,\"\",(SUM(K21:K34)/H43)*100)","v":""},"% of Net Construction Costs"]
[]
[null,null,null,null,null,null,"TOTAL TASK ORDER ESTIMATED COST",null,null,null,{"$f":"SUM(K35,K40)","v":0}]
[]
["Signature:"]
["Date:"]

{"sheet":"2-PD-SD-LABOR","index":3,"n_rows":38,"n_cols":43,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Predesign and Schematic Design Direct Labor"]
["Park:",{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!B2","v":0},null,null,null,null,null,null,"PMIS:",null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!G2","v":0},null,null,null,null,null,null,"Project Title:",null,null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!B4","v":0},null,null,null,null,null,null,null,null,null,null,"Estimated By:",null,null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!K2","v":0}]
["IDIQ Firm:",{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!B3","v":0},null,null,null,null,null,null,"Contract #",null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!G3","v":0},null,null,null,null,null,null,"Task Order #",null,null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!K3","v":0},null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,"Landscape Architect",null,null,null,null,"Architecture",null,null,null,null,"Civil Engineering",null,null,null,null,"Structural Engineer",null,null,null,null,"Mechanical Engineer",null,null,null,null,"Electrical Engineer",null,null,null,null,"Estimating",null,null,null,"Other"]
[null,null,"Firm Name"]
[null,null,null,"Principal - ","Project LA - ","Land. Arch. -","CAD Tech - ","Clerical -","Principal -","Project Arch. -","Architect - ","CAD Tech. - ","Clerical -","Principal - ","Project Engr. - ","Civil Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Str. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Mech. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Elect. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Est. - ","Estimator -","Clerical. -","Principal - "]
[null,null,"Hourly Rate"]
["WORK TASKS",null,null,"TIME TO COMPLETE TASK IN HOURS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT LABOR COST","COMMENTS & NOTES"]
["PREDESIGN (PD) "]
["1.1 Prepare Contextual Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D10:AO10)","v":0}]
["1.2 Prepare Project Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D11:AO11)","v":0}]
["1.3 Prepare Integrated Design Narrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D12:AO12)","v":0}]
["1.4 Complete Contextual Analysis Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D13:AO13)","v":0}]
["1.5.1 Prepare Permitting Assessment Form (PAF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D14:AO14)","v":0}]
["1.6 Prepare Class C Construction Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D15:AO15)","v":0}]
["1.7.1 Submit 100% Draft Predesign Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D16:AO16)","v":0}]
["1.7.2 Submit Final Predesign Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D17:AO17)","v":0}]
["SCHEMATIC DESIGN (SD)"]
["2.1 Design Concepts Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D19:AO19)","v":0}]
["2.2 Develop Schematic Design Alternatives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D20:AO20)","v":0}]
["2.3 Conduct Value Methodology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D21:AO21)","v":0}]
["2.4 Fully Develop Schematic Design Preferred Alternative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D22:AO22)","v":0}]
["2.5 Prepare Basis of Design Report (BDR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D23:AO23)","v":0}]
["2.6 Initiate NPS Constructability Checklist (SD Comments)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D24:AO24)","v":0}]
["2.7 Prepare Class B Construction Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D25:AO25)","v":0}]
["2.8.1 Finalize Permitting Assessment Form (PAF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D26:AO26)","v":0}]
["2.8.2 Prepare Permitting Road Map",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D27:AO27)","v":0}]
["2.8.3 Prepare Permit Plans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D28:AO28)","v":0}]
["2.9.1 Submit 100% Draft Schematic Design Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D29:AO29)","v":0}]
["2.9.2 Submit Final Schematic Design Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D30:AO30)","v":0}]
["2.9.2.1 Prepare and Submit Investment Review Board (IRB) Support Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D31:AO31)","v":0}]
["2.9.3 Prepare and Submit Response Memorandum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D32:AO32)","v":0}]
["Total Hours for PD and SD",null,null,{"$f":"SUM(D10:D17,D19:D32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Supplemental Services"]
["Supplemental Services 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D36:AO36)","v":0}]
["Supplemental Services 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D37:AO37)","v":0}]
["Total Hours for Supplemental Services",null,null,{"$f":"SUM(D36:D37)","v":0},{"$f":"SUM(E36:E37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO36:AO37)","v":0}]

{"sheet":"2-PD-SD-OTHER DIRECT COSTS","index":4,"n_rows":112,"n_cols":43,"rows_kept":112,"cut":false,"hidden":false,"merged":[[20,21,20,22],[8,42,9,42],[20,38,20,39],[20,34,20,35],[19,31,19,32],[19,21,19,22],[20,26,20,27],[20,24,20,25],[20,29,20,30],[20,31,20,32],[19,29,19,30],[19,24,19,25],[19,26,19,27],[8,41,9,41],[19,38,19,39],[19,34,19,35],[20,19,20,20],[20,11,20,12],[20,16,20,17],[19,4,19,5],[19,6,19,7],[20,4,20,5],[19,11,19,12],[20,6,20,7],[19,9,19,10],[20,9,20,10],[19,14,19,15],[20,14,20,15],[19,16,19,17],[19,19,19,20]]}
["OTHER DIRECT COSTS"]
["Park:",{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!B2","v":0},null,null,null,null,null,null,"PMIS:",null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!G2","v":0},null,null,null,null,null,null,"Project Title:",null,null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!B4","v":0},null,null,null,null,null,null,null,null,null,null,"Estimated By:",null,null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!K2","v":0}]
["IDIQ Firm:",{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!B3","v":0},null,null,null,null,null,null,"Contract #",null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!G3","v":0},null,null,null,null,null,null,"Task Order #",null,null,null,{"$f":"'2-PD-SD-ESTIMATE SUMMARY'!K3","v":0},null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,{"$f":"'2-PD-SD-LABOR'!AL3","v":"00:00:00"}]
[]
[null,null,null,{"$f":"'2-PD-SD-LABOR'!D4","v":"Landscape Architect"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!I4","v":"Architecture"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!N4","v":"Civil Engineering"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!S4","v":"Structural Engineer"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!X4","v":"Mechanical Engineer"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AC4","v":"Electrical Engineer"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AH4","v":"Estimating"},null,null,null,{"$f":"'2-PD-SD-LABOR'!AL4","v":"Other"}]
[null,null,{"$f":"'2-PD-SD-LABOR'!C5","v":"Firm Name"},{"$f":"'2-PD-SD-LABOR'!D5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!I5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!N5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!S5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!X5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AC5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AH5","v":0},null,null,null,{"$f":"'2-PD-SD-LABOR'!AL5","v":0}]
[null,null,null,{"$f":"'2-PD-SD-LABOR'!D6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!E6","v":"Project LA - "},{"$f":"'2-PD-SD-LABOR'!F6","v":"Land. Arch. -"},{"$f":"'2-PD-SD-LABOR'!G6","v":"CAD Tech - "},{"$f":"'2-PD-SD-LABOR'!H6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!I6","v":"Principal -"},{"$f":"'2-PD-SD-LABOR'!J6","v":"Project Arch. -"},{"$f":"'2-PD-SD-LABOR'!K6","v":"Architect - "},{"$f":"'2-PD-SD-LABOR'!L6","v":"CAD Tech. - "},{"$f":"'2-PD-SD-LABOR'!M6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!N6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!O6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!P6","v":"Civil Engr. -"},{"$f":"'2-PD-SD-LABOR'!Q6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!R6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!S6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!T6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!U6","v":"Str. Engr. -"},{"$f":"'2-PD-SD-LABOR'!V6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!W6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!X6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!Y6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!Z6","v":"Mech. Engr. -"},{"$f":"'2-PD-SD-LABOR'!AA6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!AB6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!AC6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!AD6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!AE6","v":"Elect. Engr. -"},{"$f":"'2-PD-SD-LABOR'!AF6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!AG6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!AH6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!AI6","v":"Project Est. - "},{"$f":"'2-PD-SD-LABOR'!AJ6","v":"Estimator -"},{"$f":"'2-PD-SD-LABOR'!AK6","v":"Clerical. -"},{"$f":"'2-PD-SD-LABOR'!AL6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!AM6","v":0},{"$f":"'2-PD-SD-LABOR'!AN6","v":0},{"$f":"'2-PD-SD-LABOR'!AO6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAVEL COSTS"]
[null,null,"Number of Trips at Predesign"]
[null,null,"Number of Trips at Schematic Design"]
[null,null,{"$f":"\"Number of Trips for \"&'2-PD-SD-LABOR'!A36","v":"Number of Trips for Supplemental Services 1"}]
[null,null,{"$f":"\"Number of Trips for \"&'2-PD-SD-LABOR'!A37","v":"Number of Trips for Supplemental Services 2"}]
[null,null,"POV/Taxi Fare"]
[null,null,"Air Fare"]
[null,null,"Auto rental (Adjust auto rental costs if more than one person shares the car)"]
[null,null,"Lodging"]
[null,null,"Per Diem"]
[null,null,"Miscellaneous"]
[null,null,"Total Cost per Trip",{"$f":"SUM(D13:D17)","v":0},null,null,null,null,{"$f":"SUM(I13:I18)","v":0},null,null,null,null,{"$f":"SUM(N13:N18)","v":0},null,null,null,null,{"$f":"SUM(S13:S18)","v":0},null,null,null,null,{"$f":"SUM(X13:X18)","v":0},null,null,null,null,{"$f":"SUM(AC13:AC18)","v":0},null,null,null,null,{"$f":"SUM(AH13:AH18)","v":0},null,null,null,{"$f":"SUM(AL13:AL18)","v":0},null,null,null,"TOTAL OTHER DIRECT COSTS","COMMENTS & NOTES"]
[null,null,"Total PD Travel Costs",{"$f":"SUM(D9:H9)*D$19","v":0},null,null,null,null,{"$f":"SUM(I9:M9)*$I$19","v":0},null,null,null,null,{"$f":"SUM(N9:R9)*$N$19","v":0},null,null,null,null,{"$f":"SUM(S9:W9)*$S$19","v":0},null,null,null,null,{"$f":"SUM(X9:AB9)*$X$19","v":0},null,null,null,null,{"$f":"SUM(AC9:AG9)*$AC$19","v":0},null,null,null,null,{"$f":"SUM(AH9:AK9)*$AH$19","v":0},null,null,null,{"$f":"SUM(AL9:AO9)*$AL$19","v":0},null,null,null,{"$f":"SUM(D20:AO20)","v":0}]
[null,null,"Total SD Travel Costs",{"$f":"SUM(D10:H10)*D$19","v":0},null,null,null,null,{"$f":"SUM(I10:M10)*$I$19","v":0},null,null,null,null,{"$f":"SUM(N10:R10)*$N$19","v":0},null,null,null,null,{"$f":"SUM(S10:W10)*$S$19","v":0},null,null,null,null,{"$f":"SUM(X10:AB10)*$X$19","v":0},null,null,null,null,{"$f":"SUM(AC10:AG10)*$AC$19","v":0},null,null,null,null,{"$f":"SUM(AH10:AK10)*$AH$19","v":0},null,null,null,{"$f":"SUM(AL10:AO10)*$AL$19","v":0},null,null,null,{"$f":"SUM(D21:AO21)","v":0}]
[null,null,{"$f":"\"Total \"&'2-PD-SD-LABOR'!A36&\" Travel Cost\"","v":"Total Supplemental Services 1 Travel Cost"},0,null,null,null,null,{"$f":"SUM(I11:M11)*I$19","v":0},null,null,null,null,{"$f":"SUM(N11:R11)*N$19","v":0},null,null,null,null,{"$f":"SUM(S11:W11)*S$19","v":0},null,null,null,null,{"$f":"SUM(X11:AB11)*X$19","v":0},null,null,null,null,{"$f":"SUM(AC11:AG11)*AC$19","v":0},null,null,null,null,{"$f":"SUM(AH11:AK11)*AH$19","v":0},null,null,null,{"$f":"SUM(AL11:AO11)*AL$19","v":0},null,null,null,{"$f":"SUM(D22:AO22)","v":0}]
[null,null,{"$f":"\"Total \"&'2-PD-SD-LABOR'!A37&\" Travel Cost\"","v":"Total Supplemental Services 2 Travel Cost"},{"$f":"SUM(D12:H12)*D$19","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,{"$f":"SUM(AH12:AK12)*AH$19","v":0},null,null,null,{"$f":"SUM(AL12:AO12)*AL$19","v":0},null,null,null,{"$f":"SUM(D23:AO23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER DIRECT COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PD"]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D26:H26)*D27","v":0},null,null,null,null,{"$f":"SUM(I26:M26)*I27","v":0},null,null,null,null,{"$f":"SUM(N26:R26)*N27","v":0},null,null,null,null,{"$f":"SUM(S26:W26)*S27","v":0},null,null,null,null,{"$f":"SUM(X26:AB26)*X27","v":0},null,null,null,null,{"$f":"SUM(AC26:AG26)*AC27","v":0},null,null,null,null,{"$f":"SUM(AH26:AL26)*AH27","v":0},null,null,null,{"$f":"SUM(AL26:AP26)*AL27","v":0},null,null,null,{"$f":"SUM(D28:AO28)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D29:H29)*D30","v":0},null,null,null,null,{"$f":"SUM(I29:M29)*I30","v":0},null,null,null,null,{"$f":"SUM(N29:R29)*N30","v":0},null,null,null,null,{"$f":"SUM(S29:W29)*S30","v":0},null,null,null,null,{"$f":"SUM(X29:AB29)*X30","v":0},null,null,null,null,{"$f":"SUM(AC29:AG29)*AC30","v":0},null,null,null,null,{"$f":"SUM(AH29:AL29)*AH30","v":0},null,null,null,{"$f":"SUM(AL29:AP29)*AL30","v":0},null,null,null,{"$f":"SUM(D31:AO31)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D32:H32)*D33","v":0},null,null,null,null,{"$f":"SUM(I32:M32)*I33","v":0},null,null,null,null,{"$f":"SUM(N32:R32)*N33","v":0},null,null,null,null,{"$f":"SUM(S32:W32)*S33","v":0},null,null,null,null,{"$f":"SUM(X32:AB32)*X33","v":0},null,null,null,null,{"$f":"SUM(AC32:AG32)*AC33","v":0},null,null,null,null,{"$f":"SUM(AH32:AL32)*AH33","v":0},null,null,null,{"$f":"SUM(AL32:AP32)*AL33","v":0},null,null,null,{"$f":"SUM(D34:AO34)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D35:H35)*D36","v":0},null,null,null,null,{"$f":"SUM(I35:M35)*I36","v":0},null,null,null,null,{"$f":"SUM(N35:R35)*N36","v":0},null,null,null,null,{"$f":"SUM(S35:W35)*S36","v":0},null,null,null,null,{"$f":"SUM(X35:AB35)*X36","v":0},null,null,null,null,{"$f":"SUM(AC35:AG35)*AC36","v":0},null,null,null,null,{"$f":"SUM(AH35:AL35)*AH36","v":0},null,null,null,{"$f":"SUM(AL35:AP35)*AL36","v":0},null,null,null,{"$f":"SUM(D37:AO37)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D38:H38)*D39","v":0},null,null,null,null,{"$f":"SUM(I38:M38)*I39","v":0},null,null,null,null,{"$f":"SUM(N38:R38)*N39","v":0},null,null,null,null,{"$f":"SUM(S38:W38)*S39","v":0},null,null,null,null,{"$f":"SUM(X38:AB38)*X39","v":0},null,null,null,null,{"$f":"SUM(AC38:AG38)*AC39","v":0},null,null,null,null,{"$f":"SUM(AH38:AL38)*AH39","v":0},null,null,null,{"$f":"SUM(AL38:AP38)*AL39","v":0},null,null,null,{"$f":"SUM(D40:AO40)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D41:H41)*D42","v":0},null,null,null,null,{"$f":"SUM(I41:M41)*I42","v":0},null,null,null,null,{"$f":"SUM(N41:R41)*N42","v":0},null,null,null,null,{"$f":"SUM(S41:W41)*S42","v":0},null,null,null,null,{"$f":"SUM(X41:AB41)*X42","v":0},null,null,null,null,{"$f":"SUM(AC41:AG41)*AC42","v":0},null,null,null,null,{"$f":"SUM(AH41:AL41)*AH42","v":0},null,null,null,{"$f":"SUM(AL41:AP41)*AL42","v":0},null,null,null,{"$f":"SUM(D43:AO43)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D44:H44)*D45","v":0},null,null,null,null,{"$f":"SUM(I44:M44)*I45","v":0},null,null,null,null,{"$f":"SUM(N44:R44)*N45","v":0},null,null,null,null,{"$f":"SUM(S44:W44)*S45","v":0},null,null,null,null,{"$f":"SUM(X44:AB44)*X45","v":0},null,null,null,null,{"$f":"SUM(AC44:AG44)*AC45","v":0},null,null,null,null,{"$f":"SUM(AH44:AL44)*AH45","v":0},null,null,null,{"$f":"SUM(AL44:AP44)*AL45","v":0},null,null,null,{"$f":"SUM(D46:AO46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D48:H48)*D49","v":0},null,null,null,null,{"$f":"SUM(I48:M48)*I49","v":0},null,null,null,null,{"$f":"SUM(N48:R48)*N49","v":0},null,null,null,null,{"$f":"SUM(S48:W48)*S49","v":0},null,null,null,null,{"$f":"SUM(X48:AB48)*X49","v":0},null,null,null,null,{"$f":"SUM(AC48:AG48)*AC49","v":0},null,null,null,null,{"$f":"SUM(AH48:AL48)*AH49","v":0},null,null,null,{"$f":"SUM(AL48:AP48)*AL49","v":0},null,null,null,{"$f":"SUM(D50:AO50)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D51:H51)*D52","v":0},null,null,null,null,{"$f":"SUM(I51:M51)*I52","v":0},null,null,null,null,{"$f":"SUM(N51:R51)*N52","v":0},null,null,null,null,{"$f":"SUM(S51:W51)*S52","v":0},null,null,null,null,{"$f":"SUM(X51:AB51)*X52","v":0},null,null,null,null,{"$f":"SUM(AC51:AG51)*AC52","v":0},null,null,null,null,{"$f":"SUM(AH51:AL51)*AH52","v":0},null,null,null,{"$f":"SUM(AL51:AP51)*AL52","v":0},null,null,null,{"$f":"SUM(D53:AO53)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D54:H54)*D55","v":0},null,null,null,null,{"$f":"SUM(I54:M54)*I55","v":0},null,null,null,null,{"$f":"SUM(N54:R54)*N55","v":0},null,null,null,null,{"$f":"SUM(S54:W54)*S55","v":0},null,null,null,null,{"$f":"SUM(X54:AB54)*X55","v":0},null,null,null,null,{"$f":"SUM(AC54:AG54)*AC55","v":0},null,null,null,null,{"$f":"SUM(AH54:AL54)*AH55","v":0},null,null,null,{"$f":"SUM(AL54:AP54)*AL55","v":0},null,null,null,{"$f":"SUM(D56:AO56)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D57:H57)*D58","v":0},null,null,null,null,{"$f":"SUM(I57:M57)*I58","v":0},null,null,null,null,{"$f":"SUM(N57:R57)*N58","v":0},null,null,null,null,{"$f":"SUM(S57:W57)*S58","v":0},null,null,null,null,{"$f":"SUM(X57:AB57)*X58","v":0},null,null,null,null,{"$f":"SUM(AC57:AG57)*AC58","v":0},null,null,null,null,{"$f":"SUM(AH57:AL57)*AH58","v":0},null,null,null,{"$f":"SUM(AL57:AP57)*AL58","v":0},null,null,null,{"$f":"SUM(D59:AO59)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D60:H60)*D61","v":0},null,null,null,null,{"$f":"SUM(I60:M60)*I61","v":0},null,null,null,null,{"$f":"SUM(N60:R60)*N61","v":0},null,null,null,null,{"$f":"SUM(S60:W60)*S61","v":0},null,null,null,null,{"$f":"SUM(X60:AB60)*X61","v":0},null,null,null,null,{"$f":"SUM(AC60:AG60)*AC61","v":0},null,null,null,null,{"$f":"SUM(AH60:AL60)*AH61","v":0},null,null,null,{"$f":"SUM(AL60:AP60)*AL61","v":0},null,null,null,{"$f":"SUM(D62:AO62)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D63:H63)*D64","v":0},null,null,null,null,{"$f":"SUM(I63:M63)*I64","v":0},null,null,null,null,{"$f":"SUM(N63:R63)*N64","v":0},null,null,null,null,{"$f":"SUM(S63:W63)*S64","v":0},null,null,null,null,{"$f":"SUM(X63:AB63)*X64","v":0},null,null,null,null,{"$f":"SUM(AC63:AG63)*AC64","v":0},null,null,null,null,{"$f":"SUM(AH63:AL63)*AH64","v":0},null,null,null,{"$f":"SUM(AL63:AP63)*AL64","v":0},null,null,null,{"$f":"SUM(D65:AO65)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D66:H66)*D67","v":0},null,null,null,null,{"$f":"SUM(I66:M66)*I67","v":0},null,null,null,null,{"$f":"SUM(N66:R66)*N67","v":0},null,null,null,null,{"$f":"SUM(S66:W66)*S67","v":0},null,null,null,null,{"$f":"SUM(X66:AB66)*X67","v":0},null,null,null,null,{"$f":"SUM(AC66:AG66)*AC67","v":0},null,null,null,null,{"$f":"SUM(AH66:AL66)*AH67","v":0},null,null,null,{"$f":"SUM(AL66:AP66)*AL67","v":0},null,null,null,{"$f":"SUM(D68:AO68)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!A36","v":"Supplemental Services 1"}]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D70:H70)*D71","v":0},null,null,null,null,{"$f":"SUM(I70:M70)*I71","v":0},null,null,null,null,{"$f":"SUM(N70:R70)*N71","v":0},null,null,null,null,{"$f":"SUM(S70:W70)*S71","v":0},null,null,null,null,{"$f":"SUM(X70:AB70)*X71","v":0},null,null,null,null,{"$f":"SUM(AC70:AG70)*AC71","v":0},null,null,null,null,{"$f":"SUM(AH70:AL70)*AH71","v":0},null,null,null,{"$f":"SUM(AL70:AP70)*AL71","v":0},null,null,null,{"$f":"SUM(D72:AO72)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D73:H73)*D74","v":0},null,null,null,null,{"$f":"SUM(I73:M73)*I74","v":0},null,null,null,null,{"$f":"SUM(N73:R73)*N74","v":0},null,null,null,null,{"$f":"SUM(S73:W73)*S74","v":0},null,null,null,null,{"$f":"SUM(X73:AB73)*X74","v":0},null,null,null,null,{"$f":"SUM(AC73:AG73)*AC74","v":0},null,null,null,null,{"$f":"SUM(AH73:AL73)*AH74","v":0},null,null,null,{"$f":"SUM(AL73:AP73)*AL74","v":0},null,null,null,{"$f":"SUM(D75:AO75)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D76:H76)*D77","v":0},null,null,null,null,{"$f":"SUM(I76:M76)*I77","v":0},null,null,null,null,{"$f":"SUM(N76:R76)*N77","v":0},null,null,null,null,{"$f":"SUM(S76:W76)*S77","v":0},null,null,null,null,{"$f":"SUM(X76:AB76)*X77","v":0},null,null,null,null,{"$f":"SUM(AC76:AG76)*AC77","v":0},null,null,null,null,{"$f":"SUM(AH76:AL76)*AH77","v":0},null,null,null,{"$f":"SUM(AL76:AP76)*AL77","v":0},null,null,null,{"$f":"SUM(D78:AO78)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D79:H79)*D80","v":0},null,null,null,null,{"$f":"SUM(I79:M79)*I80","v":0},null,null,null,null,{"$f":"SUM(N79:R79)*N80","v":0},null,null,null,null,{"$f":"SUM(S79:W79)*S80","v":0},null,null,null,null,{"$f":"SUM(X79:AB79)*X80","v":0},null,null,null,null,{"$f":"SUM(AC79:AG79)*AC80","v":0},null,null,null,null,{"$f":"SUM(AH79:AL79)*AH80","v":0},null,null,null,{"$f":"SUM(AL79:AP79)*AL80","v":0},null,null,null,{"$f":"SUM(D81:AO81)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D82:H82)*D83","v":0},null,null,null,null,{"$f":"SUM(I82:M82)*I83","v":0},null,null,null,null,{"$f":"SUM(N82:R82)*N83","v":0},null,null,null,null,{"$f":"SUM(S82:W82)*S83","v":0},null,null,null,null,{"$f":"SUM(X82:AB82)*X83","v":0},null,null,null,null,{"$f":"SUM(AC82:AG82)*AC83","v":0},null,null,null,null,{"$f":"SUM(AH82:AL82)*AH83","v":0},null,null,null,{"$f":"SUM(AL82:AP82)*AL83","v":0},null,null,null,{"$f":"SUM(D84:AO84)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D85:H85)*D86","v":0},null,null,null,null,{"$f":"SUM(I85:M85)*I86","v":0},null,null,null,null,{"$f":"SUM(N85:R85)*N86","v":0},null,null,null,null,{"$f":"SUM(S85:W85)*S86","v":0},null,null,null,null,{"$f":"SUM(X85:AB85)*X86","v":0},null,null,null,null,{"$f":"SUM(AC85:AG85)*AC86","v":0},null,null,null,null,{"$f":"SUM(AH85:AL85)*AH86","v":0},null,null,null,{"$f":"SUM(AL85:AP85)*AL86","v":0},null,null,null,{"$f":"SUM(D87:AO87)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D88:H88)*D89","v":0},null,null,null,null,{"$f":"SUM(I88:M88)*I89","v":0},null,null,null,null,{"$f":"SUM(N88:R88)*N89","v":0},null,null,null,null,{"$f":"SUM(S88:W88)*S89","v":0},null,null,null,null,{"$f":"SUM(X88:AB88)*X89","v":0},null,null,null,null,{"$f":"SUM(AC88:AG88)*AC89","v":0},null,null,null,null,{"$f":"SUM(AH88:AL88)*AH89","v":0},null,null,null,{"$f":"SUM(AL88:AP88)*AL89","v":0},null,null,null,{"$f":"SUM(D90:AO90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2-PD-SD-LABOR'!A37","v":"Supplemental Services 2"}]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D92:H92)*D93","v":0},null,null,null,null,{"$f":"SUM(I92:M92)*I93","v":0},null,null,null,null,{"$f":"SUM(N92:R92)*N93","v":0},null,null,null,null,{"$f":"SUM(S92:W92)*S93","v":0},null,null,null,null,{"$f":"SUM(X92:AB92)*X93","v":0},null,null,null,null,{"$f":"SUM(AC92:AG92)*AC93","v":0},null,null,null,null,{"$f":"SUM(AH92:AL92)*AH93","v":0},null,null,null,{"$f":"SUM(AL92:AP92)*AL93","v":0},null,null,null,{"$f":"SUM(D94:AO94)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D95:H95)*D96","v":0},null,null,null,null,{"$f":"SUM(I95:M95)*I96","v":0},null,null,null,null,{"$f":"SUM(N95:R95)*N96","v":0},null,null,null,null,{"$f":"SUM(S95:W95)*S96","v":0},null,null,null,null,{"$f":"SUM(X95:AB95)*X96","v":0},null,null,null,null,{"$f":"SUM(AC95:AG95)*AC96","v":0},null,null,null,null,{"$f":"SUM(AH95:AL95)*AH96","v":0},null,null,null,{"$f":"SUM(AL95:AP95)*AL96","v":0},null,null,null,{"$f":"SUM(D97:AO97)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D98:H98)*D99","v":0},null,null,null,null,{"$f":"SUM(I98:M98)*I99","v":0},null,null,null,null,{"$f":"SUM(N98:R98)*N99","v":0},null,null,null,null,{"$f":"SUM(S98:W98)*S99","v":0},null,null,null,null,{"$f":"SUM(X98:AB98)*X99","v":0},null,null,null,null,{"$f":"SUM(AC98:AG98)*AC99","v":0},null,null,null,null,{"$f":"SUM(AH98:AL98)*AH99","v":0},null,null,null,{"$f":"SUM(AL98:AP98)*AL99","v":0},null,null,null,{"$f":"SUM(D100:AO100)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D101:H101)*D102","v":0},null,null,null,null,{"$f":"SUM(I101:M101)*I102","v":0},null,null,null,null,{"$f":"SUM(N101:R101)*N102","v":0},null,null,null,null,{"$f":"SUM(S101:W101)*S102","v":0},null,null,null,null,{"$f":"SUM(X101:AB101)*X102","v":0},null,null,null,null,{"$f":"SUM(AC101:AG101)*AC102","v":0},null,null,null,null,{"$f":"SUM(AH101:AL101)*AH102","v":0},null,null,null,{"$f":"SUM(AL101:AP101)*AL102","v":0},null,null,null,{"$f":"SUM(D103:AO103)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D104:H104)*D105","v":0},null,null,null,null,{"$f":"SUM(I104:M104)*I105","v":0},null,null,null,null,{"$f":"SUM(N104:R104)*N105","v":0},null,null,null,null,{"$f":"SUM(S104:W104)*S105","v":0},null,null,null,null,{"$f":"SUM(X104:AB104)*X105","v":0},null,null,null,null,{"$f":"SUM(AC104:AG104)*AC105","v":0},null,null,null,null,{"$f":"SUM(AH104:AL104)*AH105","v":0},null,null,null,{"$f":"SUM(AL104:AP104)*AL105","v":0},null,null,null,{"$f":"SUM(D106:AO106)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D107:H107)*D108","v":0},null,null,null,null,{"$f":"SUM(I107:M107)*I108","v":0},null,null,null,null,{"$f":"SUM(N107:R107)*N108","v":0},null,null,null,null,{"$f":"SUM(S107:W107)*S108","v":0},null,null,null,null,{"$f":"SUM(X107:AB107)*X108","v":0},null,null,null,null,{"$f":"SUM(AC107:AG107)*AC108","v":0},null,null,null,null,{"$f":"SUM(AH107:AL107)*AH108","v":0},null,null,null,{"$f":"SUM(AL107:AP107)*AL108","v":0},null,null,null,{"$f":"SUM(D109:AO109)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D110:H110)*D111","v":0},null,null,null,null,{"$f":"SUM(I110:M110)*I111","v":0},null,null,null,null,{"$f":"SUM(N110:R110)*N111","v":0},null,null,null,null,{"$f":"SUM(S110:W110)*S111","v":0},null,null,null,null,{"$f":"SUM(X110:AB110)*X111","v":0},null,null,null,null,{"$f":"SUM(AC110:AG110)*AC111","v":0},null,null,null,null,{"$f":"SUM(AH110:AL110)*AH111","v":0},null,null,null,{"$f":"SUM(AL110:AP110)*AL111","v":0},null,null,null,{"$f":"SUM(D112:AO112)","v":0}]

{"sheet":"3-RFP-ESTIMATE SUMMARY","index":5,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Task Order Price Estimate or Proposal - Pre-Design + Schematic Design + Request for Proposals Summary Sheet"]
["Park:",null,null,null,"PMIS:",null,null,null,null,"Prepared By:"]
["IDIQ Firm:",null,null,null,"Contract #",null,null,null,null,"Task Order #"]
["Project Title:"]
[]
["Please use this template as a guide and verify math and calculations prior to submittal."]
[]
["Numbers, percentages, or items to be completed on this sheet are highlighted in RED. All other numbers are automatically transferred from the Labor and Other Direct Costs worksheets."]
[]
[]
["Predesign (PD) + Schematic Design (SD) + Request for Proposal (RFP)"]
["Work Tasks",null,null,null,null,null,null,"Direct Labor",null,"Other Direct Costs","Amount"]
[{"$f":"'3-RFP-LABOR'!$A$10","v":"1.1 Prepare Contextual Analysis"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP10","v":0},null,{"$f":"'3-RFP-OTHER DIRECT COSTS'!AP21+'3-RFP-OTHER DIRECT COSTS'!AP30+'3-RFP-OTHER DIRECT COSTS'!AP33+'3-RFP-OTHER DIRECT COSTS'!AP36+'3-RFP-OTHER DIRECT COSTS'!AP39+'3-RFP-OTHER DIRECT COSTS'!AP42+'3-RFP-OTHER DIRECT COSTS'!AP45+'3-RFP-OTHER DIRECT COSTS'!AP48","v":0},{"$f":"H13+J13","v":0}]
[{"$f":"'3-RFP-LABOR'!A11","v":"1.2 Prepare Project Program"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP11","v":0},null,null,{"$f":"H14","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$12","v":"1.3 Prepare Integrated Design Narrative"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP12","v":0},null,null,{"$f":"H15","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$13","v":"1.4 Complete Contextual Analysis Template"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP13","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$14","v":"1.5.1 Prepare Permitting Assessment Form (PAF)"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP14","v":0},null,null,{"$f":"H17","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$15","v":"1.6 Prepare Class C Construction Cost Estimate"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP15","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$16","v":"1.7.1 Submit 100% Draft Predesign Documents for Review"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP16","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$17","v":"1.7.2 Submit Final Predesign Documents"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP17","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$19","v":"2.1 Design Concepts Assessment"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP19","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$20","v":"2.2 Develop Schematic Design Alternatives"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP20","v":0},null,{"$f":"'3-RFP-OTHER DIRECT COSTS'!AP22+'3-RFP-OTHER DIRECT COSTS'!AP52+'3-RFP-OTHER DIRECT COSTS'!AP55+'3-RFP-OTHER DIRECT COSTS'!AP58+'3-RFP-OTHER DIRECT COSTS'!AP61+'3-RFP-OTHER DIRECT COSTS'!AP64+'3-RFP-OTHER DIRECT COSTS'!AP67+'3-RFP-OTHER DIRECT COSTS'!AP70","v":0},{"$f":"H22+J22","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$21","v":"2.3 Conduct Value Methodology"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP21","v":0},null,null,{"$f":"H23","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$22","v":"2.4 Fully Develop Schematic Design Preferred Alternative"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP22","v":0},null,null,{"$f":"H24","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$23","v":"2.5 Prepare Basis of Design Report (BDR)"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP23","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$24","v":"2.6 Initiate NPS Constructability Checklist (SD Comments)"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP24","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$25","v":"2.7 Prepare Class B Construction Cost Estimate"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP25","v":0},null,null,{"$f":"H27","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$26","v":"2.8.1 Finalize Permitting Assessment Form (PAF)"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP26","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$27","v":"2.8.2 Prepare Permitting Road Map"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP27","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$28","v":"2.8.3 Prepare Permit Plans"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP28","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$29","v":"2.9.1 Submit 100% Draft Schematic Design Documents for Review"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP29","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$30","v":"2.9.2 Submit Final Schematic Design Documents"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP30","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$31","v":"2.9.2.1 Prepare and Submit Investment Review Board (IRB) Support Documents"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP31","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$32","v":"2.9.3 Prepare and Submit Response Memorandum"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP32","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$34","v":"3.1 Prepare Request for Proposal (RFP)"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP34","v":0},null,{"$f":"'3-RFP-OTHER DIRECT COSTS'!AP23+'3-RFP-OTHER DIRECT COSTS'!AP74+'3-RFP-OTHER DIRECT COSTS'!AP77+'3-RFP-OTHER DIRECT COSTS'!AP80+'3-RFP-OTHER DIRECT COSTS'!AP83+'3-RFP-OTHER DIRECT COSTS'!AP86+'3-RFP-OTHER DIRECT COSTS'!AP89+'3-RFP-OTHER DIRECT COSTS'!AP92","v":0},{"$f":"H35+J35","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$35","v":"3.2 Prepare Contract Price Schedule"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP35","v":0},null,null,{"$f":"H36","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$36","v":"3.3 Develop In-Depth & Finalize NPS Constructability Checklist (RFP Comments & Resolution)"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP36","v":0},null,null,{"$f":"H37","v":0}]
[{"$f":"'3-RFP-LABOR'!$A$37","v":"3.4.1 Submit 100% Draft RFP Documents for Review"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP37","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$38","v":"3.4.2 Submit 100% Complete RFP Documents for Final Approval"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP38","v":0},null,null,0]
[{"$f":"'3-RFP-LABOR'!$A$39","v":"3.4.3 Submit Final RFP Documents"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP39","v":0},null,null,0]
[null,null,null,null,null,null,null,"Total PD +SD + RFP",null,null,{"$f":"SUM(K13:K40)","v":0}]
[]
["Supplemental Services",null,null,null,null,null,null,"Direct Labor",null,"Other Direct Costs","Amount"]
[{"$f":"'3-RFP-LABOR'!A43","v":"Supplemental Services 1"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP43","v":0},null,{"$f":"SUM('3-RFP-OTHER DIRECT COSTS'!AP24,'3-RFP-OTHER DIRECT COSTS'!AP96,'3-RFP-OTHER DIRECT COSTS'!AP99,'3-RFP-OTHER DIRECT COSTS'!AP102,'3-RFP-OTHER DIRECT COSTS'!AP105,'3-RFP-OTHER DIRECT COSTS'!AP108,'3-RFP-OTHER DIRECT COSTS'!AP111,'3-RFP-OTHER DIRECT COSTS'!AP114)","v":0},{"$f":"SUM(H44:J44)","v":0}]
[{"$f":"'3-RFP-LABOR'!A44","v":"Supplemental Services 2"},null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!AP44","v":0},null,{"$f":"SUM('3-RFP-OTHER DIRECT COSTS'!AP25,'3-RFP-OTHER DIRECT COSTS'!AP118,'3-RFP-OTHER DIRECT COSTS'!AP121,'3-RFP-OTHER DIRECT COSTS'!AP124,'3-RFP-OTHER DIRECT COSTS'!AP127,'3-RFP-OTHER DIRECT COSTS'!AP130,'3-RFP-OTHER DIRECT COSTS'!AP133,'3-RFP-OTHER DIRECT COSTS'!AP136)","v":0},{"$f":"SUM(H45:J45)","v":0}]
[null,null,null,null,null,null,null,"Total Supplemental Services",null,null,{"$f":"SUM(K44:K45)","v":0}]
[]
[]
["Project Net Cost of Construction ",null,null,null,null,null,"$",null,null,"(Net Cost is net dollars available in "]
[null,null,null,null,null,null,null,null,null,"the year the project will be obligated.)"]
[]
[null,null,null,"PD equals:",{"$f":"IF(K41=0,\"\",(SUM(K13:K20)/H49)*100)","v":""},"% of Net Construction Costs"]
[null,null,null,"SD equals:",{"$f":"IF(K41=0,\"\",(SUM(K21:K34)/H49)*100)","v":""},"% of Net Construction Costs"]
[null,null,null,"RFP equals:",{"$f":"IF(K41=0,\"\",(SUM(K35:K40)/H49)*100)","v":""},"% of Net Construction Costs"]
[]
[null,null,null,null,null,null,"TOTAL TASK ORDER ESTIMATED COST",null,null,null,{"$f":"SUM(K41,K46)","v":0}]
[]
["Signature:"]
["Date:"]

{"sheet":"3-RFP-LABOR","index":6,"n_rows":45,"n_cols":43,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Request for Proposals Direct Labor"]
["Park:",{"$f":"'3-RFP-ESTIMATE SUMMARY'!C2","v":0},null,null,null,null,null,null,"PMIS:",null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!G2","v":0},null,null,null,null,null,null,"Project Title:",null,null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!C4","v":0},null,null,null,null,null,null,null,null,null,null,"Estimated By:",null,null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!K2","v":0}]
["IDIQ Firm:",{"$f":"'3-RFP-ESTIMATE SUMMARY'!C3","v":0},null,null,null,null,null,null,"Contract #",null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!G3","v":0},null,null,null,null,null,null,"Task Order #",null,null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!K3","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,"Landscape Architect",null,null,null,null,"Architecture",null,null,null,null,"Civil Engineering",null,null,null,null,"Structural Engineer",null,null,null,null,"Mechanical Engineer",null,null,null,null,"Electrical Engineer",null,null,null,null,"Estimating",null,null,null,"Other"]
[null,null,"Firm Name"]
[null,null,null,"Principal - ","Project LA - ","Land. Arch. -","CAD Tech - ","Clerical -","Principal -","Project Arch. -","Architect - ","CAD Tech. - ","Clerical -","Principal - ","Project Engr. - ","Civil Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Str. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Mech. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Elect. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Est. - ","Estimator -","Clerical. -","Principal - "]
[null,null,"Hourly Rate"]
["WORK TASKS",null,null,"TIME TO COMPLETE TASK IN HOURS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT LABOR COST","COMMENTS & NOTES"]
["PREDESIGN (PD) "]
["1.1 Prepare Contextual Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D10:AO10)","v":0}]
["1.2 Prepare Project Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D11:AO11)","v":0}]
["1.3 Prepare Integrated Design Narrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D12:AO12)","v":0}]
["1.4 Complete Contextual Analysis Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D13:AO13)","v":0}]
["1.5.1 Prepare Permitting Assessment Form (PAF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D14:AO14)","v":0}]
["1.6 Prepare Class C Construction Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D15:AO15)","v":0}]
["1.7.1 Submit 100% Draft Predesign Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D16:AO16)","v":0}]
["1.7.2 Submit Final Predesign Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D17:AO17)","v":0}]
["SCHEMATIC DESIGN (SD)"]
["2.1 Design Concepts Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D19:AO19)","v":0}]
["2.2 Develop Schematic Design Alternatives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D20:AO20)","v":0}]
["2.3 Conduct Value Methodology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D21:AO21)","v":0}]
["2.4 Fully Develop Schematic Design Preferred Alternative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D22:AO22)","v":0}]
["2.5 Prepare Basis of Design Report (BDR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D23:AO23)","v":0}]
["2.6 Initiate NPS Constructability Checklist (SD Comments)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D24:AO24)","v":0}]
["2.7 Prepare Class B Construction Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D25:AO25)","v":0}]
["2.8.1 Finalize Permitting Assessment Form (PAF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D26:AO26)","v":0}]
["2.8.2 Prepare Permitting Road Map",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D27:AO27)","v":0}]
["2.8.3 Prepare Permit Plans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D28:AO28)","v":0}]
["2.9.1 Submit 100% Draft Schematic Design Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D29:AO29)","v":0}]
["2.9.2 Submit Final Schematic Design Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D30:AO30)","v":0}]
["2.9.2.1 Prepare and Submit Investment Review Board (IRB) Support Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D31:AO31)","v":0}]
["2.9.3 Prepare and Submit Response Memorandum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D32:AO32)","v":0}]
["Request for Proposal (RFP)"]
["3.1 Prepare Request for Proposal (RFP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D34:AO34)","v":0}]
["3.2 Prepare Contract Price Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D35:AO35)","v":0}]
["3.3 Develop In-Depth & Finalize NPS Constructability Checklist (RFP Comments & Resolution)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D36:AO36)","v":0}]
["3.4.1 Submit 100% Draft RFP Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D37:AO37)","v":0}]
["3.4.2 Submit 100% Complete RFP Documents for Final Approval",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D38:AO38)","v":0}]
["3.4.3 Submit Final RFP Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D39:AO39)","v":0}]
["Total Hours for PD SD RFP",null,null,{"$f":"SUM(D10:D17,D19:D32,D34:D39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Supplemental Services"]
["Supplemental Services 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D43:AO43)","v":0}]
["Supplemental Services 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D44:AO44)","v":0}]
["Total Hours for Supplemental Services",null,null,{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO43:AO44)","v":0}]

{"sheet":"3-RFP-OTHER DIRECT COSTS","index":7,"n_rows":136,"n_cols":43,"rows_kept":136,"cut":false,"hidden":false,"merged":[[21,11,21,12],[21,16,21,17],[21,21,21,22],[20,4,20,5],[20,6,20,7],[21,4,21,5],[20,11,20,12],[21,6,21,7],[20,9,20,10],[8,41,10,41],[8,42,10,42],[21,9,21,10],[21,34,21,35],[20,31,20,32],[20,21,20,22],[20,16,20,17],[20,19,20,20],[20,29,20,30],[20,24,20,25],[20,26,20,27],[20,38,20,39],[20,34,20,35],[21,19,21,20],[20,14,20,15],[21,14,21,15],[22,16,22,17],[22,34,22,35],[22,38,22,39],[22,19,22,20],[22,21,22,22],[22,24,22,25],[22,26,22,27],[22,29,22,30],[22,31,22,32],[22,4,22,5],[22,6,22,7],[22,9,22,10],[22,11,22,12],[22,14,22,15],[21,26,21,27],[21,24,21,25],[21,38,21,39],[21,29,21,30],[21,31,21,32]]}
["Request for Proposals Other Direct Costs"]
["Park:",{"$f":"'3-RFP-ESTIMATE SUMMARY'!C2","v":0},null,null,null,null,null,null,"PMIS:",null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!G2","v":0},null,null,null,null,null,null,"Project Title:",null,null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!C4","v":0},null,null,null,null,null,null,null,null,null,null,"Estimated By:",null,null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!K2","v":0}]
["IDIQ Firm:",{"$f":"'3-RFP-ESTIMATE SUMMARY'!C3","v":0},null,null,null,null,null,null,"Contract #",null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!G3","v":0},null,null,null,null,null,null,"Task Order #",null,null,null,{"$f":"'3-RFP-ESTIMATE SUMMARY'!K3","v":0},null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,{"$f":"'3-RFP-LABOR'!AL3","v":"00:00:00"}]
[]
[null,null,null,{"$f":"'3-RFP-LABOR'!D4","v":"Landscape Architect"},null,null,null,null,{"$f":"'3-RFP-LABOR'!I4","v":"Architecture"},null,null,null,null,{"$f":"'3-RFP-LABOR'!N4","v":"Civil Engineering"},null,null,null,null,{"$f":"'3-RFP-LABOR'!S4","v":"Structural Engineer"},null,null,null,null,{"$f":"'3-RFP-LABOR'!X4","v":"Mechanical Engineer"},null,null,null,null,{"$f":"'3-RFP-LABOR'!AC4","v":"Electrical Engineer"},null,null,null,null,{"$f":"'3-RFP-LABOR'!AH4","v":"Estimating"},null,null,null,{"$f":"'3-RFP-LABOR'!AL4","v":"Other"}]
[null,null,{"$f":"'3-RFP-LABOR'!C5","v":"Firm Name"},{"$f":"'3-RFP-LABOR'!D5","v":0},null,null,null,null,{"$f":"'3-RFP-LABOR'!I5","v":0},null,null,null,null,{"$f":"'3-RFP-LABOR'!N5","v":0},null,null,null,null,{"$f":"'3-RFP-LABOR'!S5","v":0},null,null,null,null,{"$f":"'3-RFP-LABOR'!X5","v":0},null,null,null,null,{"$f":"'3-RFP-LABOR'!AC5","v":0},null,null,null,null,{"$f":"'3-RFP-LABOR'!AH5","v":0},null,null,null,{"$f":"'3-RFP-LABOR'!AL5","v":0}]
[null,null,null,{"$f":"'3-RFP-LABOR'!D6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!E6","v":"Project LA - "},{"$f":"'3-RFP-LABOR'!F6","v":"Land. Arch. -"},{"$f":"'3-RFP-LABOR'!G6","v":"CAD Tech - "},{"$f":"'3-RFP-LABOR'!H6","v":"Clerical -"},{"$f":"'3-RFP-LABOR'!I6","v":"Principal -"},{"$f":"'3-RFP-LABOR'!J6","v":"Project Arch. -"},{"$f":"'3-RFP-LABOR'!K6","v":"Architect - "},{"$f":"'3-RFP-LABOR'!L6","v":"CAD Tech. - "},{"$f":"'3-RFP-LABOR'!M6","v":"Clerical -"},{"$f":"'3-RFP-LABOR'!N6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!O6","v":"Project Engr. - "},{"$f":"'3-RFP-LABOR'!P6","v":"Civil Engr. -"},{"$f":"'3-RFP-LABOR'!Q6","v":"CAD Tech. -"},{"$f":"'3-RFP-LABOR'!R6","v":"Clerical -"},{"$f":"'3-RFP-LABOR'!S6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!T6","v":"Project Engr. - "},{"$f":"'3-RFP-LABOR'!U6","v":"Str. Engr. -"},{"$f":"'3-RFP-LABOR'!V6","v":"CAD Tech. -"},{"$f":"'3-RFP-LABOR'!W6","v":"Clerical -"},{"$f":"'3-RFP-LABOR'!X6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!Y6","v":"Project Engr. - "},{"$f":"'3-RFP-LABOR'!Z6","v":"Mech. Engr. -"},{"$f":"'3-RFP-LABOR'!AA6","v":"CAD Tech. -"},{"$f":"'3-RFP-LABOR'!AB6","v":"Clerical -"},{"$f":"'3-RFP-LABOR'!AC6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!AD6","v":"Project Engr. - "},{"$f":"'3-RFP-LABOR'!AE6","v":"Elect. Engr. -"},{"$f":"'3-RFP-LABOR'!AF6","v":"CAD Tech. -"},{"$f":"'3-RFP-LABOR'!AG6","v":"Clerical -"},{"$f":"'3-RFP-LABOR'!AH6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!AI6","v":"Project Est. - "},{"$f":"'3-RFP-LABOR'!AJ6","v":"Estimator -"},{"$f":"'3-RFP-LABOR'!AK6","v":"Clerical. -"},{"$f":"'3-RFP-LABOR'!AL6","v":"Principal - "},{"$f":"'3-RFP-LABOR'!AM6","v":0},{"$f":"'3-RFP-LABOR'!AN6","v":0},{"$f":"'3-RFP-LABOR'!AO6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAVEL COSTS"]
[null,null,"Number of Trips at Predesign"]
[null,null,"Number of Trips at Schematic Design"]
[null,null,"Number of Trips for RFP"]
[null,null,{"$f":"\"Number of Trips for \"&'3-RFP-LABOR'!A43","v":"Number of Trips for Supplemental Services 1"}]
[null,null,{"$f":"\"Number of Trips for \"&'3-RFP-LABOR'!A44","v":"Number of Trips for Supplemental Services 2"}]
[null,null,"POV/Taxi Fare"]
[null,null,"Air Fare"]
[null,null,"Auto rental (Adjust auto rental costs if more than one person shares the car)"]
[null,null,"Lodging"]
[null,null,"Per Diem"]
[null,null,"Miscellaneous"]
[null,null,"Total Cost per Trip",{"$f":"SUM(D14:D18)","v":0},null,null,null,null,{"$f":"SUM(I14:I19)","v":0},null,null,null,null,{"$f":"SUM(N14:N19)","v":0},null,null,null,null,{"$f":"SUM(S14:S19)","v":0},null,null,null,null,{"$f":"SUM(X14:X19)","v":0},null,null,null,null,{"$f":"SUM(AC14:AC19)","v":0},null,null,null,null,{"$f":"SUM(AH14:AH19)","v":0},null,null,null,{"$f":"SUM(AL14:AL19)","v":0},null,null,null,"TOTAL OTHER DIRECT COSTS","COMMENTS & NOTES"]
[null,null,"Total PD Travel Costs",{"$f":"SUM(D9:H9)*$D$20","v":0},null,null,null,null,{"$f":"SUM(I9:M9)*$I$20","v":0},null,null,null,null,{"$f":"SUM(N9:R9)*$N$20","v":0},null,null,null,null,{"$f":"SUM(S9:W9)*$S$20","v":0},null,null,null,null,{"$f":"SUM(X9:AB9)*$X$20","v":0},null,null,null,null,{"$f":"SUM(AC9:AG9)*$AC$20","v":0},null,null,null,null,{"$f":"SUM(AH9:AK9)*$AH$20","v":0},null,null,null,{"$f":"SUM(AL9:AO9)*$AL$20","v":0},null,null,null,{"$f":"SUM(D21:AO21)","v":0}]
[null,null,"Total SD Travel Costs",{"$f":"SUM(D10:H10*D20)","v":0},null,null,null,null,{"$f":"SUM(I10:M10)*$I$20","v":0},null,null,null,null,{"$f":"SUM(N10:R10)*$N$20","v":0},null,null,null,null,{"$f":"SUM(S10:W10)*$S$20","v":0},null,null,null,null,{"$f":"SUM(X10:AB10)*$X$20","v":0},null,null,null,null,{"$f":"SUM(AC10:AG10)*$AC$20","v":0},null,null,null,null,{"$f":"SUM(AH10:AK10)*$AH$20","v":0},null,null,null,{"$f":"SUM(AL10:AO10)*$AL$20","v":0},null,null,null,{"$f":"SUM(D22:AO22)","v":0}]
[null,null,"Total RFP Travel Costs",{"$f":"SUM(D11:H11)*D20","v":0},null,null,null,null,{"$f":"SUM(I11:M11)*$I$20","v":0},null,null,null,null,{"$f":"SUM(N11:R11)*$N$20","v":0},null,null,null,null,{"$f":"SUM(S11:W11)*$S$20","v":0},null,null,null,null,{"$f":"SUM(X11:AB11)*$X$21","v":0},null,null,null,null,{"$f":"SUM(AC11:AG11)*$AC$21","v":0},null,null,null,null,{"$f":"SUM(AH11:AK11)*$AH$21","v":0},null,null,null,{"$f":"SUM(AL11:AO11)*$AL$21","v":0},null,null,null,0]
[null,null,{"$f":"\"Total \"&'3-RFP-LABOR'!A43&\" Travel Cost\"","v":"Total Supplemental Services 1 Travel Cost"},{"$f":"SUM(D12:H12)*D20","v":0},null,null,null,null,{"$f":"SUM(I12:M12)*I20","v":0},null,null,null,null,{"$f":"SUM(N12:R12)*N20","v":0},null,null,null,null,{"$f":"SUM(S12:W12)*S20","v":0},null,null,null,null,{"$f":"SUM(X12:AB12)*X20","v":0},null,null,null,null,{"$f":"SUM(AC12:AG12)*AC20","v":0},null,null,null,null,{"$f":"SUM(AH12:AK12)*AH20","v":0},null,null,null,{"$f":"SUM(AL12:AO12)*AL20","v":0},null,null,null,{"$f":"SUM(D24:AO24)","v":0}]
[null,null,{"$f":"\"Total \"&'3-RFP-LABOR'!A44&\" Travel Cost\"","v":"Total Supplemental Services 2 Travel Cost"},{"$f":"SUM(D13:H13)*D20","v":0},null,null,null,null,{"$f":"SUM(I13:M13)*I20","v":0},null,null,null,null,{"$f":"SUM(N13:R13)*N20","v":0},null,null,null,null,{"$f":"SUM(S13:W13)*S20","v":0},null,null,null,null,{"$f":"SUM(X13:AB13)*X20","v":0},null,null,null,null,{"$f":"SUM(AC13:AG13)*AC20","v":0},null,null,null,null,{"$f":"SUM(AH13:AK13)*AH20","v":0},null,null,null,{"$f":"SUM(AL13:AO13)*AL20","v":0},null,null,null,{"$f":"SUM(D25:AO25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER DIRECT COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PD"]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D28:H28)*D29","v":0},null,null,null,null,{"$f":"SUM(I28:M28)*I29","v":0},null,null,null,null,{"$f":"SUM(N28:R28)*N29","v":0},null,null,null,null,{"$f":"SUM(S28:W28)*S29","v":0},null,null,null,null,{"$f":"SUM(X28:AB28)*X29","v":0},null,null,null,null,{"$f":"SUM(AC28:AG28)*AC29","v":0},null,null,null,null,{"$f":"SUM(AH28:AL28)*AH29","v":0},null,null,null,{"$f":"SUM(AL28:AP28)*AL29","v":0},null,null,null,{"$f":"SUM(D30:AO30)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D31:H31)*D32","v":0},null,null,null,null,{"$f":"SUM(I31:M31)*I32","v":0},null,null,null,null,{"$f":"SUM(N31:R31)*N32","v":0},null,null,null,null,{"$f":"SUM(S31:W31)*S32","v":0},null,null,null,null,{"$f":"SUM(X31:AB31)*X32","v":0},null,null,null,null,{"$f":"SUM(AC31:AG31)*AC32","v":0},null,null,null,null,{"$f":"SUM(AH31:AL31)*AH32","v":0},null,null,null,{"$f":"SUM(AL31:AP31)*AL32","v":0},null,null,null,{"$f":"SUM(D33:AO33)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D34:H34)*D35","v":0},null,null,null,null,{"$f":"SUM(I34:M34)*I35","v":0},null,null,null,null,{"$f":"SUM(N34:R34)*N35","v":0},null,null,null,null,{"$f":"SUM(S34:W34)*S35","v":0},null,null,null,null,{"$f":"SUM(X34:AB34)*X35","v":0},null,null,null,null,{"$f":"SUM(AC34:AG34)*AC35","v":0},null,null,null,null,{"$f":"SUM(AH34:AL34)*AH35","v":0},null,null,null,{"$f":"SUM(AL34:AP34)*AL35","v":0},null,null,null,{"$f":"SUM(D36:AO36)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D37:H37)*D38","v":0},null,null,null,null,{"$f":"SUM(I37:M37)*I38","v":0},null,null,null,null,{"$f":"SUM(N37:R37)*N38","v":0},null,null,null,null,{"$f":"SUM(S37:W37)*S38","v":0},null,null,null,null,{"$f":"SUM(X37:AB37)*X38","v":0},null,null,null,null,{"$f":"SUM(AC37:AG37)*AC38","v":0},null,null,null,null,{"$f":"SUM(AH37:AL37)*AH38","v":0},null,null,null,{"$f":"SUM(AL37:AP37)*AL38","v":0},null,null,null,{"$f":"SUM(D39:AO39)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D40:H40)*D41","v":0},null,null,null,null,{"$f":"SUM(I40:M40)*I41","v":0},null,null,null,null,{"$f":"SUM(N40:R40)*N41","v":0},null,null,null,null,{"$f":"SUM(S40:W40)*S41","v":0},null,null,null,null,{"$f":"SUM(X40:AB40)*X41","v":0},null,null,null,null,{"$f":"SUM(AC40:AG40)*AC41","v":0},null,null,null,null,{"$f":"SUM(AH40:AL40)*AH41","v":0},null,null,null,{"$f":"SUM(AL40:AP40)*AL41","v":0},null,null,null,{"$f":"SUM(D42:AO42)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D43:H43)*D44","v":0},null,null,null,null,{"$f":"SUM(I43:M43)*I44","v":0},null,null,null,null,{"$f":"SUM(N43:R43)*N44","v":0},null,null,null,null,{"$f":"SUM(S43:W43)*S44","v":0},null,null,null,null,{"$f":"SUM(X43:AB43)*X44","v":0},null,null,null,null,{"$f":"SUM(AC43:AG43)*AC44","v":0},null,null,null,null,{"$f":"SUM(AH43:AL43)*AH44","v":0},null,null,null,{"$f":"SUM(AL43:AP43)*AL44","v":0},null,null,null,{"$f":"SUM(D45:AO45)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D46:H46)*D47","v":0},null,null,null,null,{"$f":"SUM(I46:M46)*I47","v":0},null,null,null,null,{"$f":"SUM(N46:R46)*N47","v":0},null,null,null,null,{"$f":"SUM(S46:W46)*S47","v":0},null,null,null,null,{"$f":"SUM(X46:AB46)*X47","v":0},null,null,null,null,{"$f":"SUM(AC46:AG46)*AC47","v":0},null,null,null,null,{"$f":"SUM(AH46:AL46)*AH47","v":0},null,null,null,{"$f":"SUM(AL46:AP46)*AL47","v":0},null,null,null,{"$f":"SUM(D48:AO48)","v":0}]
[]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D50:H50)*D51","v":0},null,null,null,null,{"$f":"SUM(I50:M50)*I51","v":0},null,null,null,null,{"$f":"SUM(N50:R50)*N51","v":0},null,null,null,null,{"$f":"SUM(S50:W50)*S51","v":0},null,null,null,null,{"$f":"SUM(X50:AB50)*X51","v":0},null,null,null,null,{"$f":"SUM(AC50:AG50)*AC51","v":0},null,null,null,null,{"$f":"SUM(AH50:AL50)*AH51","v":0},null,null,null,{"$f":"SUM(AL50:AP50)*AL51","v":0},null,null,null,{"$f":"SUM(D52:AO52)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D53:H53)*D54","v":0},null,null,null,null,{"$f":"SUM(I53:M53)*I54","v":0},null,null,null,null,{"$f":"SUM(N53:R53)*N54","v":0},null,null,null,null,{"$f":"SUM(S53:W53)*S54","v":0},null,null,null,null,{"$f":"SUM(X53:AB53)*X54","v":0},null,null,null,null,{"$f":"SUM(AC53:AG53)*AC54","v":0},null,null,null,null,{"$f":"SUM(AH53:AL53)*AH54","v":0},null,null,null,{"$f":"SUM(AL53:AP53)*AL54","v":0},null,null,null,{"$f":"SUM(D55:AO55)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D56:H56)*D57","v":0},null,null,null,null,{"$f":"SUM(I56:M56)*I57","v":0},null,null,null,null,{"$f":"SUM(N56:R56)*N57","v":0},null,null,null,null,{"$f":"SUM(S56:W56)*S57","v":0},null,null,null,null,{"$f":"SUM(X56:AB56)*X57","v":0},null,null,null,null,{"$f":"SUM(AC56:AG56)*AC57","v":0},null,null,null,null,{"$f":"SUM(AH56:AL56)*AH57","v":0},null,null,null,{"$f":"SUM(AL56:AP56)*AL57","v":0},null,null,null,{"$f":"SUM(D58:AO58)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D59:H59)*D60","v":0},null,null,null,null,{"$f":"SUM(I59:M59)*I60","v":0},null,null,null,null,{"$f":"SUM(N59:R59)*N60","v":0},null,null,null,null,{"$f":"SUM(S59:W59)*S60","v":0},null,null,null,null,{"$f":"SUM(X59:AB59)*X60","v":0},null,null,null,null,{"$f":"SUM(AC59:AG59)*AC60","v":0},null,null,null,null,{"$f":"SUM(AH59:AL59)*AH60","v":0},null,null,null,{"$f":"SUM(AL59:AP59)*AL60","v":0},null,null,null,{"$f":"SUM(D61:AO61)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D62:H62)*D63","v":0},null,null,null,null,{"$f":"SUM(I62:M62)*I63","v":0},null,null,null,null,{"$f":"SUM(N62:R62)*N63","v":0},null,null,null,null,{"$f":"SUM(S62:W62)*S63","v":0},null,null,null,null,{"$f":"SUM(X62:AB62)*X63","v":0},null,null,null,null,{"$f":"SUM(AC62:AG62)*AC63","v":0},null,null,null,null,{"$f":"SUM(AH62:AL62)*AH63","v":0},null,null,null,{"$f":"SUM(AL62:AP62)*AL63","v":0},null,null,null,{"$f":"SUM(D64:AO64)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D65:H65)*D66","v":0},null,null,null,null,{"$f":"SUM(I65:M65)*I66","v":0},null,null,null,null,{"$f":"SUM(N65:R65)*N66","v":0},null,null,null,null,{"$f":"SUM(S65:W65)*S66","v":0},null,null,null,null,{"$f":"SUM(X65:AB65)*X66","v":0},null,null,null,null,{"$f":"SUM(AC65:AG65)*AC66","v":0},null,null,null,null,{"$f":"SUM(AH65:AL65)*AH66","v":0},null,null,null,{"$f":"SUM(AL65:AP65)*AL66","v":0},null,null,null,{"$f":"SUM(D67:AO67)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D68:H68)*D69","v":0},null,null,null,null,{"$f":"SUM(I68:M68)*I69","v":0},null,null,null,null,{"$f":"SUM(N68:R68)*N69","v":0},null,null,null,null,{"$f":"SUM(S68:W68)*S69","v":0},null,null,null,null,{"$f":"SUM(X68:AB68)*X69","v":0},null,null,null,null,{"$f":"SUM(AC68:AG68)*AC69","v":0},null,null,null,null,{"$f":"SUM(AH68:AL68)*AH69","v":0},null,null,null,{"$f":"SUM(AL68:AP68)*AL69","v":0},null,null,null,{"$f":"SUM(D70:AO70)","v":0}]
[]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D72:H72)*D73","v":0},null,null,null,null,{"$f":"SUM(I72:M72)*I73","v":0},null,null,null,null,{"$f":"SUM(N72:R72)*N73","v":0},null,null,null,null,{"$f":"SUM(S72:W72)*S73","v":0},null,null,null,null,{"$f":"SUM(X72:AB72)*X73","v":0},null,null,null,null,{"$f":"SUM(AC72:AG72)*AC73","v":0},null,null,null,null,{"$f":"SUM(AH72:AL72)*AH73","v":0},null,null,null,{"$f":"SUM(AL72:AP72)*AL73","v":0},null,null,null,{"$f":"SUM(D74:AO74)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D75:H75)*D76","v":0},null,null,null,null,{"$f":"SUM(I75:M75)*I76","v":0},null,null,null,null,{"$f":"SUM(N75:R75)*N76","v":0},null,null,null,null,{"$f":"SUM(S75:W75)*S76","v":0},null,null,null,null,{"$f":"SUM(X75:AB75)*X76","v":0},null,null,null,null,{"$f":"SUM(AC75:AG75)*AC76","v":0},null,null,null,null,{"$f":"SUM(AH75:AL75)*AH76","v":0},null,null,null,{"$f":"SUM(AL75:AP75)*AL76","v":0},null,null,null,{"$f":"SUM(D77:AO77)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D78:H78)*D79","v":0},null,null,null,null,{"$f":"SUM(I78:M78)*I79","v":0},null,null,null,null,{"$f":"SUM(N78:R78)*N79","v":0},null,null,null,null,{"$f":"SUM(S78:W78)*S79","v":0},null,null,null,null,{"$f":"SUM(X78:AB78)*X79","v":0},null,null,null,null,{"$f":"SUM(AC78:AG78)*AC79","v":0},null,null,null,null,{"$f":"SUM(AH78:AL78)*AH79","v":0},null,null,null,{"$f":"SUM(AL78:AP78)*AL79","v":0},null,null,null,{"$f":"SUM(D80:AO80)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D81:H81)*D82","v":0},null,null,null,null,{"$f":"SUM(I81:M81)*I82","v":0},null,null,null,null,{"$f":"SUM(N81:R81)*N82","v":0},null,null,null,null,{"$f":"SUM(S81:W81)*S82","v":0},null,null,null,null,{"$f":"SUM(X81:AB81)*X82","v":0},null,null,null,null,{"$f":"SUM(AC81:AG81)*AC82","v":0},null,null,null,null,{"$f":"SUM(AH81:AL81)*AH82","v":0},null,null,null,{"$f":"SUM(AL81:AP81)*AL82","v":0},null,null,null,{"$f":"SUM(D83:AO83)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D84:H84)*D85","v":0},null,null,null,null,{"$f":"SUM(I84:M84)*I85","v":0},null,null,null,null,{"$f":"SUM(N84:R84)*N85","v":0},null,null,null,null,{"$f":"SUM(S84:W84)*S85","v":0},null,null,null,null,{"$f":"SUM(X84:AB84)*X85","v":0},null,null,null,null,{"$f":"SUM(AC84:AG84)*AC85","v":0},null,null,null,null,{"$f":"SUM(AH84:AL84)*AH85","v":0},null,null,null,{"$f":"SUM(AL84:AP84)*AL85","v":0},null,null,null,{"$f":"SUM(D86:AO86)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D87:H87)*D88","v":0},null,null,null,null,{"$f":"SUM(I87:M87)*I88","v":0},null,null,null,null,{"$f":"SUM(N87:R87)*N88","v":0},null,null,null,null,{"$f":"SUM(S87:W87)*S88","v":0},null,null,null,null,{"$f":"SUM(X87:AB87)*X88","v":0},null,null,null,null,{"$f":"SUM(AC87:AG87)*AC88","v":0},null,null,null,null,{"$f":"SUM(AH87:AL87)*AH88","v":0},null,null,null,{"$f":"SUM(AL87:AP87)*AL88","v":0},null,null,null,{"$f":"SUM(D89:AO89)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D90:H90)*D91","v":0},null,null,null,null,{"$f":"SUM(I90:M90)*I91","v":0},null,null,null,null,{"$f":"SUM(N90:R90)*N91","v":0},null,null,null,null,{"$f":"SUM(S90:W90)*S91","v":0},null,null,null,null,{"$f":"SUM(X90:AB90)*X91","v":0},null,null,null,null,{"$f":"SUM(AC90:AG90)*AC91","v":0},null,null,null,null,{"$f":"SUM(AH90:AL90)*AH91","v":0},null,null,null,{"$f":"SUM(AL90:AP90)*AL91","v":0},null,null,null,{"$f":"SUM(D92:AO92)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!A43","v":"Supplemental Services 1"}]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D94:H94)*D95","v":0},null,null,null,null,{"$f":"SUM(I94:M94)*I95","v":0},null,null,null,null,{"$f":"SUM(N94:R94)*N95","v":0},null,null,null,null,{"$f":"SUM(S94:W94)*S95","v":0},null,null,null,null,{"$f":"SUM(X94:AB94)*X95","v":0},null,null,null,null,{"$f":"SUM(AC94:AG94)*AC95","v":0},null,null,null,null,{"$f":"SUM(AH94:AL94)*AH95","v":0},null,null,null,{"$f":"SUM(AL94:AP94)*AL95","v":0},null,null,null,{"$f":"SUM(D96:AO96)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D97:H97)*D98","v":0},null,null,null,null,{"$f":"SUM(I97:M97)*I98","v":0},null,null,null,null,{"$f":"SUM(N97:R97)*N98","v":0},null,null,null,null,{"$f":"SUM(S97:W97)*S98","v":0},null,null,null,null,{"$f":"SUM(X97:AB97)*X98","v":0},null,null,null,null,{"$f":"SUM(AC97:AG97)*AC98","v":0},null,null,null,null,{"$f":"SUM(AH97:AL97)*AH98","v":0},null,null,null,{"$f":"SUM(AL97:AP97)*AL98","v":0},null,null,null,{"$f":"SUM(D99:AO99)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D100:H100)*D101","v":0},null,null,null,null,{"$f":"SUM(I100:M100)*I101","v":0},null,null,null,null,{"$f":"SUM(N100:R100)*N101","v":0},null,null,null,null,{"$f":"SUM(S100:W100)*S101","v":0},null,null,null,null,{"$f":"SUM(X100:AB100)*X101","v":0},null,null,null,null,{"$f":"SUM(AC100:AG100)*AC101","v":0},null,null,null,null,{"$f":"SUM(AH100:AL100)*AH101","v":0},null,null,null,{"$f":"SUM(AL100:AP100)*AL101","v":0},null,null,null,{"$f":"SUM(D102:AO102)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D103:H103)*D104","v":0},null,null,null,null,{"$f":"SUM(I103:M103)*I104","v":0},null,null,null,null,{"$f":"SUM(N103:R103)*N104","v":0},null,null,null,null,{"$f":"SUM(S103:W103)*S104","v":0},null,null,null,null,{"$f":"SUM(X103:AB103)*X104","v":0},null,null,null,null,{"$f":"SUM(AC103:AG103)*AC104","v":0},null,null,null,null,{"$f":"SUM(AH103:AL103)*AH104","v":0},null,null,null,{"$f":"SUM(AL103:AP103)*AL104","v":0},null,null,null,{"$f":"SUM(D105:AO105)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D106:H106)*D107","v":0},null,null,null,null,{"$f":"SUM(I106:M106)*I107","v":0},null,null,null,null,{"$f":"SUM(N106:R106)*N107","v":0},null,null,null,null,{"$f":"SUM(S106:W106)*S107","v":0},null,null,null,null,{"$f":"SUM(X106:AB106)*X107","v":0},null,null,null,null,{"$f":"SUM(AC106:AG106)*AC107","v":0},null,null,null,null,{"$f":"SUM(AH106:AL106)*AH107","v":0},null,null,null,{"$f":"SUM(AL106:AP106)*AL107","v":0},null,null,null,{"$f":"SUM(D108:AO108)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D109:H109)*D110","v":0},null,null,null,null,{"$f":"SUM(I109:M109)*I110","v":0},null,null,null,null,{"$f":"SUM(N109:R109)*N110","v":0},null,null,null,null,{"$f":"SUM(S109:W109)*S110","v":0},null,null,null,null,{"$f":"SUM(X109:AB109)*X110","v":0},null,null,null,null,{"$f":"SUM(AC109:AG109)*AC110","v":0},null,null,null,null,{"$f":"SUM(AH109:AL109)*AH110","v":0},null,null,null,{"$f":"SUM(AL109:AP109)*AL110","v":0},null,null,null,{"$f":"SUM(D111:AO111)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D112:H112)*D113","v":0},null,null,null,null,{"$f":"SUM(I112:M112)*I113","v":0},null,null,null,null,{"$f":"SUM(N112:R112)*N113","v":0},null,null,null,null,{"$f":"SUM(S112:W112)*S113","v":0},null,null,null,null,{"$f":"SUM(X112:AB112)*X113","v":0},null,null,null,null,{"$f":"SUM(AC112:AG112)*AC113","v":0},null,null,null,null,{"$f":"SUM(AH112:AL112)*AH113","v":0},null,null,null,{"$f":"SUM(AL112:AP112)*AL113","v":0},null,null,null,{"$f":"SUM(D114:AO114)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3-RFP-LABOR'!A44","v":"Supplemental Services 2"}]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D116:H116)*D117","v":0},null,null,null,null,{"$f":"SUM(I116:M116)*I117","v":0},null,null,null,null,{"$f":"SUM(N116:R116)*N117","v":0},null,null,null,null,{"$f":"SUM(S116:W116)*S117","v":0},null,null,null,null,{"$f":"SUM(X116:AB116)*X117","v":0},null,null,null,null,{"$f":"SUM(AC116:AG116)*AC117","v":0},null,null,null,null,{"$f":"SUM(AH116:AL116)*AH117","v":0},null,null,null,{"$f":"SUM(AL116:AP116)*AL117","v":0},null,null,null,{"$f":"SUM(D118:AO118)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D119:H119)*D120","v":0},null,null,null,null,{"$f":"SUM(I119:M119)*I120","v":0},null,null,null,null,{"$f":"SUM(N119:R119)*N120","v":0},null,null,null,null,{"$f":"SUM(S119:W119)*S120","v":0},null,null,null,null,{"$f":"SUM(X119:AB119)*X120","v":0},null,null,null,null,{"$f":"SUM(AC119:AG119)*AC120","v":0},null,null,null,null,{"$f":"SUM(AH119:AL119)*AH120","v":0},null,null,null,{"$f":"SUM(AL119:AP119)*AL120","v":0},null,null,null,{"$f":"SUM(D121:AO121)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D122:H122)*D123","v":0},null,null,null,null,{"$f":"SUM(I122:M122)*I123","v":0},null,null,null,null,{"$f":"SUM(N122:R122)*N123","v":0},null,null,null,null,{"$f":"SUM(S122:W122)*S123","v":0},null,null,null,null,{"$f":"SUM(X122:AB122)*X123","v":0},null,null,null,null,{"$f":"SUM(AC122:AG122)*AC123","v":0},null,null,null,null,{"$f":"SUM(AH122:AL122)*AH123","v":0},null,null,null,{"$f":"SUM(AL122:AP122)*AL123","v":0},null,null,null,{"$f":"SUM(D124:AO124)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D125:H125)*D126","v":0},null,null,null,null,{"$f":"SUM(I125:M125)*I126","v":0},null,null,null,null,{"$f":"SUM(N125:R125)*N126","v":0},null,null,null,null,{"$f":"SUM(S125:W125)*S126","v":0},null,null,null,null,{"$f":"SUM(X125:AB125)*X126","v":0},null,null,null,null,{"$f":"SUM(AC125:AG125)*AC126","v":0},null,null,null,null,{"$f":"SUM(AH125:AL125)*AH126","v":0},null,null,null,{"$f":"SUM(AL125:AP125)*AL126","v":0},null,null,null,{"$f":"SUM(D127:AO127)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D128:H128)*D129","v":0},null,null,null,null,{"$f":"SUM(I128:M128)*I129","v":0},null,null,null,null,{"$f":"SUM(N128:R128)*N129","v":0},null,null,null,null,{"$f":"SUM(S128:W128)*S129","v":0},null,null,null,null,{"$f":"SUM(X128:AB128)*X129","v":0},null,null,null,null,{"$f":"SUM(AC128:AG128)*AC129","v":0},null,null,null,null,{"$f":"SUM(AH128:AL128)*AH129","v":0},null,null,null,{"$f":"SUM(AL128:AP128)*AL129","v":0},null,null,null,{"$f":"SUM(D130:AO130)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D131:H131)*D132","v":0},null,null,null,null,{"$f":"SUM(I131:M131)*I132","v":0},null,null,null,null,{"$f":"SUM(N131:R131)*N132","v":0},null,null,null,null,{"$f":"SUM(S131:W131)*S132","v":0},null,null,null,null,{"$f":"SUM(X131:AB131)*X132","v":0},null,null,null,null,{"$f":"SUM(AC131:AG131)*AC132","v":0},null,null,null,null,{"$f":"SUM(AH131:AL131)*AH132","v":0},null,null,null,{"$f":"SUM(AL131:AP131)*AL132","v":0},null,null,null,{"$f":"SUM(D133:AO133)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D134:H134)*D135","v":0},null,null,null,null,{"$f":"SUM(I134:M134)*I135","v":0},null,null,null,null,{"$f":"SUM(N134:R134)*N135","v":0},null,null,null,null,{"$f":"SUM(S134:W134)*S135","v":0},null,null,null,null,{"$f":"SUM(X134:AB134)*X135","v":0},null,null,null,null,{"$f":"SUM(AC134:AG134)*AC135","v":0},null,null,null,null,{"$f":"SUM(AH134:AL134)*AH135","v":0},null,null,null,{"$f":"SUM(AL134:AP134)*AL135","v":0},null,null,null,{"$f":"SUM(D136:AO136)","v":0}]

{"sheet":"4-DD-CD-ESTIMATE SUMMARY","index":8,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Task Order Price Estimate or Proposal - Design Development + Construction Documents + Supplemental Services Summary Sheet"]
["Park:",null,null,null,"PMIS:",null,null,null,null,"Prepared By:"]
["IDIQ Firm:",null,null,null,"Contract #:",null,null,null,null,"Task Order #:"]
["Project Title:"]
[]
["Please use this template as a guide and verify math and calculations prior to submittal."]
[]
["Numbers, percentages, or items to be completed on this sheet are highlighted in RED. All other numbers are automatically transferred from the Labor and Other Direct Costs worksheets."]
[]
[]
["Design Development (DD) + Construction Documents (CD)"]
["Work Tasks",null,null,null,null,null,null,"Direct Labor",null,"Other Direct Costs","Amount"]
[{"$f":"'4-DD-CD-LABOR'!A10","v":"3.1 Prepare Design Development Documents"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP10","v":0},null,{"$f":"SUM('4-DD-CD-OTHER DIRECT COSTS'!AP20,'4-DD-CD-OTHER DIRECT COSTS'!AP28,'4-DD-CD-OTHER DIRECT COSTS'!AP31,'4-DD-CD-OTHER DIRECT COSTS'!AP34,'4-DD-CD-OTHER DIRECT COSTS'!AP37,'4-DD-CD-OTHER DIRECT COSTS'!AP40,'4-DD-CD-OTHER DIRECT COSTS'!AP43,'4-DD-CD-OTHER DIRECT COSTS'!AP46)","v":0},{"$f":"SUM(H13:J13)","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A11","v":"3.2 Develop In-Depth NPS Constructability Checklist (DD Comments)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP11","v":0},null,null,{"$f":"H14","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A12","v":"3.3 Draft Contract Price Schedule"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP12","v":0},null,null,{"$f":"H15","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A13","v":"3.4 Update Class B Construction Cost Estimate and Construction Schedule"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP13","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A14","v":"3.5 Conduct Value Methodology (VM)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP14","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A15","v":"3.6.1.1 Prepare & Finalize Permitting Assessment Form (PAF) (if required)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP15","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A16","v":"3.6.1.2 Prepare Permitting Road Map (if required)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP16","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A17","v":"3.6.1.3 Prepare Permit Plans (if required)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP17","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A18","v":"3.6.2.1 Prepare Permit Schedule (if required)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP18","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A19","v":"3.6.2.2 Develop Application for each Design (Government-Furnished (GF) Permit (if required)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP19","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A20","v":"3.6.2.3 Provide Permit Status and/or Final Permits (if required)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP20","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A21","v":"3.7.1 Submit Design Development Documents for Review"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP21","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A22","v":"3.7.2 Submit Design Development Documents Review Comments"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP22","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A23","v":"3.8.1 Prepare and Submit Compliance Drawings and Narratives for Permits"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP23","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A25","v":"4.1 Prepare 100% Draft Construction Documents"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP25","v":0},null,{"$f":"SUM('4-DD-CD-OTHER DIRECT COSTS'!AP21,'4-DD-CD-OTHER DIRECT COSTS'!AP50,'4-DD-CD-OTHER DIRECT COSTS'!AP53,'4-DD-CD-OTHER DIRECT COSTS'!AP56,'4-DD-CD-OTHER DIRECT COSTS'!AP59,'4-DD-CD-OTHER DIRECT COSTS'!AP62,'4-DD-CD-OTHER DIRECT COSTS'!AP65,'4-DD-CD-OTHER DIRECT COSTS'!AP68)","v":0},{"$f":"SUM(H27:J27)","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A26","v":"4.2 Prepare Submittal List "},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP26","v":0},null,null,{"$f":"H28","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A27","v":"4.3 Prepare Closeout and Operation & Maintenance (O&M) Requirements "},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP27","v":0},null,null,{"$f":"H29","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A28","v":"4.4 Finalize NPS Constructability Checklist (CD Resolution)"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP28","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A29","v":"4.5 Update Value Methodology Report"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP29","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A30","v":"4.6 Prepare Class A Construction Cost Estimate and Construction Schedule"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP30","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A31","v":"4.7 Format Supplemental Design Reports"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP31","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A32","v":"4.8.1 Submit 100% Draft Construction Documents for Review"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP32","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A33","v":"4.8.2 Submit 100% Complete Construction Documents for Final Approval"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP33","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A34","v":"4.8.3 Submit Final Construction Documents Stamped & Signed"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP34","v":0},null,null,0]
[{"$f":"'4-DD-CD-LABOR'!A35","v":"4.9 Update Class A Construction Cost Estimate and Construction Schedule"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP35","v":0},null,null,0]
[null,null,null,null,null,null,null,"Total DD +CD",null,null,{"$f":"SUM(K13:K37)","v":0}]
[]
["Supplemental Services",null,null,null,null,null,null,"Direct Labor",null,"Other Direct Costs","Amount"]
[{"$f":"'4-DD-CD-LABOR'!A39","v":"Supplemental Services 1"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP39","v":0},null,{"$f":"SUM('4-DD-CD-OTHER DIRECT COSTS'!AP22,'4-DD-CD-OTHER DIRECT COSTS'!AP72,'4-DD-CD-OTHER DIRECT COSTS'!AP75,'4-DD-CD-OTHER DIRECT COSTS'!AP78,'4-DD-CD-OTHER DIRECT COSTS'!AP81,'4-DD-CD-OTHER DIRECT COSTS'!AP84,'4-DD-CD-OTHER DIRECT COSTS'!AP87,'4-DD-CD-OTHER DIRECT COSTS'!AP90)","v":0},{"$f":"SUM(H41:J41)","v":0}]
[{"$f":"'4-DD-CD-LABOR'!A40","v":"Supplemental Services 2"},null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!AP40","v":0},null,{"$f":"SUM('4-DD-CD-OTHER DIRECT COSTS'!AP23,'4-DD-CD-OTHER DIRECT COSTS'!AP94,'4-DD-CD-OTHER DIRECT COSTS'!AP97,'4-DD-CD-OTHER DIRECT COSTS'!AP100,'4-DD-CD-OTHER DIRECT COSTS'!AP103,'4-DD-CD-OTHER DIRECT COSTS'!AP106,'4-DD-CD-OTHER DIRECT COSTS'!AP109,'4-DD-CD-OTHER DIRECT COSTS'!AP112)","v":0},{"$f":"SUM(H42:J42)","v":0}]
[null,null,null,null,null,null,null,"Total Supplemental Services",null,null,{"$f":"SUM(K41:K42)","v":0}]
[]
[]
["Project Net Cost of Construction ",null,null,null,null,null,"$",null,null,"(Net Cost is net dollars available in "]
[null,null,null,null,null,null,null,null,null,"the year the project will be obligated.)"]
[]
[null,null,null,"DD equals:",{"$f":"IF(K38=0,\"\",(SUM(K13:K26)/$H$46)*100)","v":""},"% of Net Construction Costs"]
[null,null,null,"CD equals:",{"$f":"IF($K$38=0,\"\",(SUM(K27:K37)/$H$46)*100)","v":""},"% of Net Construction Costs"]
[]
[null,null,null,null,null,null,"TOTAL TASK ORDER ESTIMATED COST",null,null,null,{"$f":"K38+K43","v":0}]
[]
["Signature:"]
["Date:"]

{"sheet":"4-DD-CD-LABOR","index":9,"n_rows":41,"n_cols":43,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Design Development and Construction Documents Direct Labor "]
["Park:",{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!C2","v":0},null,null,null,null,null,null,"PMIS:",null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!G2","v":0},null,null,null,null,null,null,"Project Title:",null,null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!C4","v":0},null,null,null,null,null,null,null,null,null,null,"Estimated By:",null,null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!K2","v":0}]
["IDIQ Firm:",{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!C3","v":0},null,null,null,null,null,null,"Contract #:",null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!G3","v":0},null,null,null,null,null,null,"Task Order #:",null,null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!K3","v":0},null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,"Landscape Architect",null,null,null,null,"Architecture",null,null,null,null,"Civil Engineering",null,null,null,null,"Structural Engineer",null,null,null,null,"Mechanical Engineer",null,null,null,null,"Electrical Engineer",null,null,null,null,"Estimating",null,null,null,"Other"]
[null,null,"Firm Name"]
[null,null,null,"Principal - ","Project LA - ","Land. Arch. -","CAD Tech - ","Clerical -","Principal -","Project Arch. -","Architect - ","CAD Tech. - ","Clerical -","Principal - ","Project Engr. - ","Civil Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Str. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Mech. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Engr. - ","Elect. Engr. -","CAD Tech. -","Clerical -","Principal - ","Project Est. - ","Estimator -","Clerical. -","Principal - "]
[null,null,"Hourly Rate"]
["WORK TASKS",null,null,"TIME TO COMPLETE TASK IN HOURS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT LABOR COST","COMMENTS & NOTES"]
["Design Development (DD) "]
["3.1 Prepare Design Development Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D10:AO10)","v":0}]
["3.2 Develop In-Depth NPS Constructability Checklist (DD Comments)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D11:AO11)","v":0}]
["3.3 Draft Contract Price Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D12:AO12)","v":0}]
["3.4 Update Class B Construction Cost Estimate and Construction Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D13:AO13)","v":0}]
["3.5 Conduct Value Methodology (VM)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D14:AO14)","v":0}]
["3.6.1.1 Prepare & Finalize Permitting Assessment Form (PAF) (if required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D15:AO15)","v":0}]
["3.6.1.2 Prepare Permitting Road Map (if required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D16:AO16)","v":0}]
["3.6.1.3 Prepare Permit Plans (if required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D17:AO17)","v":0}]
["3.6.2.1 Prepare Permit Schedule (if required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D18:AO18)","v":0}]
["3.6.2.2 Develop Application for each Design (Government-Furnished (GF) Permit (if required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D19:AO19)","v":0}]
["3.6.2.3 Provide Permit Status and/or Final Permits (if required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D20:AO20)","v":0}]
["3.7.1 Submit Design Development Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D21:AO21)","v":0}]
["3.7.2 Submit Design Development Documents Review Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D22:AO22)","v":0}]
["3.8.1 Prepare and Submit Compliance Drawings and Narratives for Permits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D23:AO23)","v":0}]
["Construction Documents (CD)"]
["4.1 Prepare 100% Draft Construction Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D25:AO25)","v":0}]
["4.2 Prepare Submittal List ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D26:AO26)","v":0}]
["4.3 Prepare Closeout and Operation & Maintenance (O&M) Requirements ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D27:AO27)","v":0}]
["4.4 Finalize NPS Constructability Checklist (CD Resolution)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D28:AO28)","v":0}]
["4.5 Update Value Methodology Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D29:AO29)","v":0}]
["4.6 Prepare Class A Construction Cost Estimate and Construction Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D30:AO30)","v":0}]
["4.7 Format Supplemental Design Reports",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D31:AO31)","v":0}]
["4.8.1 Submit 100% Draft Construction Documents for Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D32:AO32)","v":0}]
["4.8.2 Submit 100% Complete Construction Documents for Final Approval",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D33:AO33)","v":0}]
["4.8.3 Submit Final Construction Documents Stamped & Signed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D34:AO34)","v":0}]
["4.9 Update Class A Construction Cost Estimate and Construction Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D35:AO35)","v":0}]
["Total Hours for DD, CD, and Supplemental Services",null,null,{"$f":"SUM(D10:D23,D25:D35)","v":0},{"$f":"SUM(E10:E23,E25:E35)","v":0},{"$f":"SUM(F10:F23,F25:F35)","v":0},{"$f":"SUM(G10:G23,G25:G35)","v":0},{"$f":"SUM(H10:H23,H25:H35)","v":0},{"$f":"SUM(I10:I23,I25:I35)","v":0},{"$f":"SUM(J10:J23,J25:J35)","v":0},{"$f":"SUM(K10:K23,K25:K35)","v":0},{"$f":"SUM(L10:L23,L25:L35)","v":0},{"$f":"SUM(M10:M23,M25:M35)","v":0},{"$f":"SUM(N10:N23,N25:N35)","v":0},{"$f":"SUM(O10:O23,O25:O35)","v":0},{"$f":"SUM(P10:P23,P25:P35)","v":0},{"$f":"SUM(Q10:Q23,Q25:Q35)","v":0},{"$f":"SUM(R10:R23,R25:R35)","v":0},{"$f":"SUM(S10:S23,S25:S35)","v":0},{"$f":"SUM(T10:T23,T25:T35)","v":0},{"$f":"SUM(U10:U23,U25:U35)","v":0},{"$f":"SUM(V10:V23,V25:V35)","v":0},{"$f":"SUM(W10:W23,W25:W35)","v":0},{"$f":"SUM(X10:X23,X25:X35)","v":0},{"$f":"SUM(Y10:Y23,Y25:Y35)","v":0},{"$f":"SUM(Z10:Z23,Z25:Z35)","v":0},{"$f":"SUM(AA10:AA23,AA25:AA35)","v":0},{"$f":"SUM(AB10:AB23,AB25:AB35)","v":0},{"$f":"SUM(AC10:AC23,AC25:AC35)","v":0},{"$f":"SUM(AD10:AD23,AD25:AD35)","v":0},{"$f":"SUM(AE10:AE23,AE25:AE35)","v":0},{"$f":"SUM(AF10:AF23,AF25:AF35)","v":0},{"$f":"SUM(AG10:AG23,AG25:AG35)","v":0},{"$f":"SUM(AH10:AH23,AH25:AH35)","v":0},{"$f":"SUM(AI10:AI23,AI25:AI35)","v":0},{"$f":"SUM(AJ10:AJ23,AJ25:AJ35)","v":0},{"$f":"SUM(AK10:AK23,AK25:AK35)","v":0},{"$f":"SUM(AL10:AL23,AL25:AL35)","v":0},{"$f":"SUM(AM10:AM23,AM25:AM35)","v":0},{"$f":"SUM(AN10:AN23,AN25:AN35)","v":0},{"$f":"SUM(AO10:AO23,AO25:AO35)","v":0}]
[]
["Supplemental Services"]
["Supplemental Services 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D39:AO39)","v":0}]
["Supplemental Services 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D$7:$AO$7*D40:AO40)","v":0}]
["Total Hours for Supplemental Services",null,null,{"$f":"SUM(D39:D40)","v":0},{"$f":"SUM(E39:E40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"4-DD-CD-OTHER DIRECT COSTS","index":10,"n_rows":112,"n_cols":43,"rows_kept":112,"cut":false,"hidden":false,"merged":[[8,41,9,41],[8,42,9,42]]}
["Design Development and Construction Documents Other Direct Costs"]
["Park:",{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!C2","v":0},null,null,null,null,null,null,"PMIS:",null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!G2","v":0},null,null,null,null,null,null,"Project Title:",null,null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!C4","v":0},null,null,null,null,null,null,null,null,null,null,"Estimated By:",null,null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!K2","v":0}]
["IDIQ Firm:",{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!C3","v":0},null,null,null,null,null,null,"Contract #:",null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!G3","v":0},null,null,null,null,null,null,"Task Order #:",null,null,null,{"$f":"'4-DD-CD-ESTIMATE SUMMARY'!K3","v":0},null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,{"$f":"'4-DD-CD-LABOR'!AL3","v":"00:00:00"}]
[]
[null,null,null,{"$f":"'2-PD-SD-LABOR'!D4","v":"Landscape Architect"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!I4","v":"Architecture"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!N4","v":"Civil Engineering"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!S4","v":"Structural Engineer"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!X4","v":"Mechanical Engineer"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AC4","v":"Electrical Engineer"},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AH4","v":"Estimating"},null,null,null,{"$f":"'2-PD-SD-LABOR'!AL4","v":"Other"}]
[null,null,{"$f":"'2-PD-SD-LABOR'!C5","v":"Firm Name"},{"$f":"'2-PD-SD-LABOR'!D5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!I5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!N5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!S5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!X5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AC5","v":0},null,null,null,null,{"$f":"'2-PD-SD-LABOR'!AH5","v":0},null,null,null,{"$f":"'2-PD-SD-LABOR'!AL5","v":0}]
[null,null,null,{"$f":"'2-PD-SD-LABOR'!D6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!E6","v":"Project LA - "},{"$f":"'2-PD-SD-LABOR'!F6","v":"Land. Arch. -"},{"$f":"'2-PD-SD-LABOR'!G6","v":"CAD Tech - "},{"$f":"'2-PD-SD-LABOR'!H6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!I6","v":"Principal -"},{"$f":"'2-PD-SD-LABOR'!J6","v":"Project Arch. -"},{"$f":"'2-PD-SD-LABOR'!K6","v":"Architect - "},{"$f":"'2-PD-SD-LABOR'!L6","v":"CAD Tech. - "},{"$f":"'2-PD-SD-LABOR'!M6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!N6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!O6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!P6","v":"Civil Engr. -"},{"$f":"'2-PD-SD-LABOR'!Q6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!R6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!S6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!T6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!U6","v":"Str. Engr. -"},{"$f":"'2-PD-SD-LABOR'!V6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!W6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!X6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!Y6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!Z6","v":"Mech. Engr. -"},{"$f":"'2-PD-SD-LABOR'!AA6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!AB6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!AC6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!AD6","v":"Project Engr. - "},{"$f":"'2-PD-SD-LABOR'!AE6","v":"Elect. Engr. -"},{"$f":"'2-PD-SD-LABOR'!AF6","v":"CAD Tech. -"},{"$f":"'2-PD-SD-LABOR'!AG6","v":"Clerical -"},{"$f":"'2-PD-SD-LABOR'!AH6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!AI6","v":"Project Est. - "},{"$f":"'2-PD-SD-LABOR'!AJ6","v":"Estimator -"},{"$f":"'2-PD-SD-LABOR'!AK6","v":"Clerical. -"},{"$f":"'2-PD-SD-LABOR'!AL6","v":"Principal - "},{"$f":"'2-PD-SD-LABOR'!AM6","v":0},{"$f":"'2-PD-SD-LABOR'!AN6","v":0},{"$f":"'2-PD-SD-LABOR'!AO6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAVEL COSTS"]
[null,null,"Number of Trips at Design Development"]
[null,null,"Number of Trips at Construction Documents"]
[null,null,{"$f":"\"Number of Trips for \"&'4-DD-CD-LABOR'!A39","v":"Number of Trips for Supplemental Services 1"}]
[null,null,{"$f":"\"Number of Trips for \"&'4-DD-CD-LABOR'!A40","v":"Number of Trips for Supplemental Services 2"}]
[null,null,"POV/Taxi Fare"]
[null,null,"Air Fare"]
[null,null,"Auto rental (Adjust auto rental costs if more than one person shares the car)"]
[null,null,"Lodging"]
[null,null,"Per Diem"]
[null,null,"Miscellaneous"]
[null,null,"Total Cost per Trip",{"$f":"SUM(D13:D17)","v":0},null,null,null,null,{"$f":"SUM(I13:I18)","v":0},null,null,null,null,{"$f":"SUM(N13:N18)","v":0},null,null,null,null,{"$f":"SUM(S13:S18)","v":0},null,null,null,null,{"$f":"SUM(X13:X18)","v":0},null,null,null,null,{"$f":"SUM(AC13:AC18)","v":0},null,null,null,null,{"$f":"SUM(AH13:AH18)","v":0},null,null,null,{"$f":"SUM(AL13:AL18)","v":0},null,null,null,"TOTAL OTHER DIRECT COSTS","COMMENTS & NOTES"]
[null,null,"Total DD Travel Costs",{"$f":"SUM(D9:H9)*$D$19","v":0},null,null,null,null,{"$f":"SUM(I9:M9)*$I$19","v":0},null,null,null,null,{"$f":"SUM(N9:R9)*$N$19","v":0},null,null,null,null,{"$f":"SUM(S9:W9)*$S$19","v":0},null,null,null,null,{"$f":"SUM(X9:AB9)*$X$19","v":0},null,null,null,null,{"$f":"SUM(AC9:AG9)*$AC$19","v":0},null,null,null,null,{"$f":"SUM(AH9:AK9)*$AH$19","v":0},null,null,null,{"$f":"SUM(AL9:AO9)*$AL$19","v":0},null,null,null,{"$f":"SUM(D20:AO20)","v":0}]
[null,null,"Total CD Travel Costs",{"$f":"SUM(D10:H10*$D$19)","v":0},null,null,null,null,{"$f":"SUM(I10:M10)*$I$19","v":0},null,null,null,null,{"$f":"SUM(N10:R10)*$N$19","v":0},null,null,null,null,{"$f":"SUM(S10:W10)*$S$19","v":0},null,null,null,null,{"$f":"SUM(X10:AB10)*$X$19","v":0},null,null,null,null,{"$f":"SUM(AC10:AG10)*$AC$19","v":0},null,null,null,null,{"$f":"SUM(AH10:AK10)*$AH$19","v":0},null,null,null,{"$f":"SUM(AL10:AO10)*$AL$19","v":0},null,null,null,{"$f":"SUM(D21:AO21)","v":0}]
[null,null,{"$f":"\"Total \"&'4-DD-CD-LABOR'!A39&\" Travel Cost\"","v":"Total Supplemental Services 1 Travel Cost"},{"$f":"SUM(D11:H11*$D$19)","v":0},null,null,null,null,{"$f":"SUM(I11:M11*$D$19)","v":0},null,null,null,null,{"$f":"SUM(N11:R11*$D$19)","v":0},null,null,null,null,{"$f":"SUM(S11:W11*$D$19)","v":0},null,null,null,null,{"$f":"SUM(X11:AB11*$D$19)","v":0},null,null,null,null,{"$f":"SUM(AC11:AG11*$D$19)","v":0},null,null,null,null,{"$f":"SUM(AH11:AK11*$D$19)","v":0},null,null,null,{"$f":"SUM(AL11:AO11*$D$19)","v":0},null,null,null,{"$f":"SUM(D22:AO22)","v":0}]
[null,null,{"$f":"\"Total \"&'4-DD-CD-LABOR'!A40&\" Travel Cost\"","v":"Total Supplemental Services 2 Travel Cost"},{"$f":"SUM(D12:H12*$D$19)","v":0},null,null,null,null,{"$f":"SUM(I12:M12*$D$19)","v":0},null,null,null,null,{"$f":"SUM(N12:R12*$D$19)","v":0},null,null,null,null,{"$f":"SUM(S12:W12*$D$19)","v":0},null,null,null,null,{"$f":"SUM(X12:AB12*$D$19)","v":0},null,null,null,null,{"$f":"SUM(AC12:AG12*$D$19)","v":0},null,null,null,null,{"$f":"SUM(AH12:AK12*$D$19)","v":0},null,null,null,{"$f":"SUM(AL12:AO12*$D$19)","v":0},null,null,null,{"$f":"SUM(D23:AO23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER DIRECT COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D26:H26)*D27","v":0},null,null,null,null,{"$f":"SUM(I26:M26)*$I$27","v":0},null,null,null,null,{"$f":"SUM(N26:R26)*$N$27","v":0},null,null,null,null,{"$f":"SUM(S26:W26)*$S$27","v":0},null,null,null,null,{"$f":"SUM(X26:AB26)*$X$27","v":0},null,null,null,null,{"$f":"SUM(AC26:AG26)*$AC$27","v":0},null,null,null,null,{"$f":"SUM(AH26:AK26)*$AH$27","v":0},null,null,null,{"$f":"SUM(AL26:AO26)*$AL$27","v":0},null,null,null,{"$f":"SUM(D28:AO28)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D29:H29)*D30","v":0},null,null,null,null,{"$f":"SUM(I29:M29)*I$30","v":0},null,null,null,null,{"$f":"SUM(N29:R29)*N$30","v":0},null,null,null,null,{"$f":"SUM(S29:W29)*S$30","v":0},null,null,null,null,{"$f":"SUM(X29:AB29)*X$30","v":0},null,null,null,null,{"$f":"SUM(AC29:AG29)*AC$30","v":0},null,null,null,null,{"$f":"SUM(AH29:AL29)*AH$30","v":0},null,null,null,{"$f":"SUM(AL29:AP29)*AL$30","v":0},null,null,null,{"$f":"SUM(D31:AO31)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D32:H32)*D33","v":0},null,null,null,null,{"$f":"SUM(I32:M32)*I$33","v":0},null,null,null,null,{"$f":"SUM(N32:R32)*N$33","v":0},null,null,null,null,{"$f":"SUM(S32:W32)*S$33","v":0},null,null,null,null,{"$f":"SUM(X32:AB32)*X$33","v":0},null,null,null,null,{"$f":"SUM(AC32:AG32)*AC$33","v":0},null,null,null,null,{"$f":"SUM(AH32:AL32)*AH$33","v":0},null,null,null,{"$f":"SUM(AL32:AP32)*AL$33","v":0},null,null,null,{"$f":"SUM(D34:AO34)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D35:H35)*D36","v":0},null,null,null,null,{"$f":"SUM(I35:M35)*I$36","v":0},null,null,null,null,{"$f":"SUM(N35:R35)*N$36","v":0},null,null,null,null,{"$f":"SUM(S35:W35)*S$36","v":0},null,null,null,null,{"$f":"SUM(X35:AB35)*X$36","v":0},null,null,null,null,{"$f":"SUM(AC35:AG35)*AC$36","v":0},null,null,null,null,{"$f":"SUM(AH35:AL35)*AH$36","v":0},null,null,null,{"$f":"SUM(AL35:AP35)*AL$36","v":0},null,null,null,{"$f":"SUM(D37:AO37)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D38:H38)*D39","v":0},null,null,null,null,{"$f":"SUM(I38:M38)*I$39","v":0},null,null,null,null,{"$f":"SUM(N38:R38)*N$39","v":0},null,null,null,null,{"$f":"SUM(S38:W38)*S$39","v":0},null,null,null,null,{"$f":"SUM(X38:AB38)*X$39","v":0},null,null,null,null,{"$f":"SUM(AC38:AG38)*AC$39","v":0},null,null,null,null,{"$f":"SUM(AH38:AL38)*AH$39","v":0},null,null,null,{"$f":"SUM(AL38:AP38)*AL$39","v":0},null,null,null,{"$f":"SUM(D40:AO40)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D41:H41)*D42","v":0},null,null,null,null,{"$f":"SUM(I41:M41)*I$42","v":0},null,null,null,null,{"$f":"SUM(N41:R41)*N$42","v":0},null,null,null,null,{"$f":"SUM(S41:W41)*S$42","v":0},null,null,null,null,{"$f":"SUM(X41:AB41)*X$42","v":0},null,null,null,null,{"$f":"SUM(AC41:AG41)*AC$42","v":0},null,null,null,null,{"$f":"SUM(AH41:AL41)*AH$42","v":0},null,null,null,{"$f":"SUM(AL41:AP41)*AL$42","v":0},null,null,null,{"$f":"SUM(D43:AO43)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D44:H44)*D45","v":0},null,null,null,null,{"$f":"SUM(I44:M44)*I45","v":0},null,null,null,null,{"$f":"SUM(N44:R44)*N45","v":0},null,null,null,null,{"$f":"SUM(S44:W44)*S45","v":0},null,null,null,null,{"$f":"SUM(X44:AB44)*X45","v":0},null,null,null,null,{"$f":"SUM(AC44:AG44)*AC45","v":0},null,null,null,null,{"$f":"SUM(AH44:AL44)*AH45","v":0},null,null,null,{"$f":"SUM(AL44:AP44)*AL45","v":0},null,null,null,{"$f":"SUM(D46:AO46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD"]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D48:H48)*D49","v":0},null,null,null,null,{"$f":"SUM(I48:M48)*I49","v":0},null,null,null,null,{"$f":"SUM(N48:R48)*N49","v":0},null,null,null,null,{"$f":"SUM(S48:W48)*S49","v":0},null,null,null,null,{"$f":"SUM(X48:AB48)*X49","v":0},null,null,null,null,{"$f":"SUM(AC48:AG48)*AC49","v":0},null,null,null,null,{"$f":"SUM(AH48:AL48)*AH49","v":0},null,null,null,{"$f":"SUM(AL48:AP48)*AL49","v":0},null,null,null,{"$f":"SUM(D50:AO50)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D51:H51)*D52","v":0},null,null,null,null,{"$f":"SUM(I51:M51)*I52","v":0},null,null,null,null,{"$f":"SUM(N51:R51)*N52","v":0},null,null,null,null,{"$f":"SUM(S51:W51)*S52","v":0},null,null,null,null,{"$f":"SUM(X51:AB51)*X52","v":0},null,null,null,null,{"$f":"SUM(AC51:AG51)*AC52","v":0},null,null,null,null,{"$f":"SUM(AH51:AL51)*AH52","v":0},null,null,null,{"$f":"SUM(AL51:AP51)*AL52","v":0},null,null,null,{"$f":"SUM(D53:AO53)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D54:H54)*D55","v":0},null,null,null,null,{"$f":"SUM(I54:M54)*I55","v":0},null,null,null,null,{"$f":"SUM(N54:R54)*N55","v":0},null,null,null,null,{"$f":"SUM(S54:W54)*S55","v":0},null,null,null,null,{"$f":"SUM(X54:AB54)*X55","v":0},null,null,null,null,{"$f":"SUM(AC54:AG54)*AC55","v":0},null,null,null,null,{"$f":"SUM(AH54:AL54)*AH55","v":0},null,null,null,{"$f":"SUM(AL54:AP54)*AL55","v":0},null,null,null,{"$f":"SUM(D56:AO56)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D57:H57)*D58","v":0},null,null,null,null,{"$f":"SUM(I57:M57)*I58","v":0},null,null,null,null,{"$f":"SUM(N57:R57)*N58","v":0},null,null,null,null,{"$f":"SUM(S57:W57)*S58","v":0},null,null,null,null,{"$f":"SUM(X57:AB57)*X58","v":0},null,null,null,null,{"$f":"SUM(AC57:AG57)*AC58","v":0},null,null,null,null,{"$f":"SUM(AH57:AL57)*AH58","v":0},null,null,null,{"$f":"SUM(AL57:AP57)*AL58","v":0},null,null,null,{"$f":"SUM(D59:AO59)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D60:H60)*D61","v":0},null,null,null,null,{"$f":"SUM(I60:M60)*I61","v":0},null,null,null,null,{"$f":"SUM(N60:R60)*N61","v":0},null,null,null,null,{"$f":"SUM(S60:W60)*S61","v":0},null,null,null,null,{"$f":"SUM(X60:AB60)*X61","v":0},null,null,null,null,{"$f":"SUM(AC60:AG60)*AC61","v":0},null,null,null,null,{"$f":"SUM(AH60:AL60)*AH61","v":0},null,null,null,{"$f":"SUM(AL60:AP60)*AL61","v":0},null,null,null,{"$f":"SUM(D62:AO62)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D63:H63)*D64","v":0},null,null,null,null,{"$f":"SUM(I63:M63)*I64","v":0},null,null,null,null,{"$f":"SUM(N63:R63)*N64","v":0},null,null,null,null,{"$f":"SUM(S63:W63)*S64","v":0},null,null,null,null,{"$f":"SUM(X63:AB63)*X64","v":0},null,null,null,null,{"$f":"SUM(AC63:AG63)*AC64","v":0},null,null,null,null,{"$f":"SUM(AH63:AL63)*AH64","v":0},null,null,null,{"$f":"SUM(AL63:AP63)*AL64","v":0},null,null,null,{"$f":"SUM(D65:AO65)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D66:H66)*D67","v":0},null,null,null,null,{"$f":"SUM(I66:M66)*I67","v":0},null,null,null,null,{"$f":"SUM(N66:R66)*N67","v":0},null,null,null,null,{"$f":"SUM(S66:W66)*S67","v":0},null,null,null,null,{"$f":"SUM(X66:AB66)*X67","v":0},null,null,null,null,{"$f":"SUM(AC66:AG66)*AC67","v":0},null,null,null,null,{"$f":"SUM(AH66:AL66)*AH67","v":0},null,null,null,{"$f":"SUM(AL66:AP66)*AL67","v":0},null,null,null,{"$f":"SUM(D68:AO68)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!A39","v":"Supplemental Services 1"}]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D70:H70)*D71","v":0},null,null,null,null,{"$f":"SUM(I70:M70)*I71","v":0},null,null,null,null,{"$f":"SUM(N70:R70)*N71","v":0},null,null,null,null,{"$f":"SUM(S70:W70)*S71","v":0},null,null,null,null,{"$f":"SUM(X70:AB70)*X71","v":0},null,null,null,null,{"$f":"SUM(AC70:AG70)*AC71","v":0},null,null,null,null,{"$f":"SUM(AH70:AL70)*AH71","v":0},null,null,null,{"$f":"SUM(AL70:AP70)*AL71","v":0},null,null,null,{"$f":"SUM(D72:AO72)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D73:H73)*D74","v":0},null,null,null,null,{"$f":"SUM(I73:M73)*I74","v":0},null,null,null,null,{"$f":"SUM(N73:R73)*N74","v":0},null,null,null,null,{"$f":"SUM(S73:W73)*S74","v":0},null,null,null,null,{"$f":"SUM(X73:AB73)*X74","v":0},null,null,null,null,{"$f":"SUM(AC73:AG73)*AC74","v":0},null,null,null,null,{"$f":"SUM(AH73:AL73)*AH74","v":0},null,null,null,{"$f":"SUM(AL73:AP73)*AL74","v":0},null,null,null,{"$f":"SUM(D75:AO75)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D76:H76)*D77","v":0},null,null,null,null,{"$f":"SUM(I76:M76)*I77","v":0},null,null,null,null,{"$f":"SUM(N76:R76)*N77","v":0},null,null,null,null,{"$f":"SUM(S76:W76)*S77","v":0},null,null,null,null,{"$f":"SUM(X76:AB76)*X77","v":0},null,null,null,null,{"$f":"SUM(AC76:AG76)*AC77","v":0},null,null,null,null,{"$f":"SUM(AH76:AL76)*AH77","v":0},null,null,null,{"$f":"SUM(AL76:AP76)*AL77","v":0},null,null,null,{"$f":"SUM(D78:AO78)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D79:H79)*D80","v":0},null,null,null,null,{"$f":"SUM(I79:M79)*I80","v":0},null,null,null,null,{"$f":"SUM(N79:R79)*N80","v":0},null,null,null,null,{"$f":"SUM(S79:W79)*S80","v":0},null,null,null,null,{"$f":"SUM(X79:AB79)*X80","v":0},null,null,null,null,{"$f":"SUM(AC79:AG79)*AC80","v":0},null,null,null,null,{"$f":"SUM(AH79:AL79)*AH80","v":0},null,null,null,{"$f":"SUM(AL79:AP79)*AL80","v":0},null,null,null,{"$f":"SUM(D81:AO81)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D82:H82)*D83","v":0},null,null,null,null,{"$f":"SUM(I82:M82)*I83","v":0},null,null,null,null,{"$f":"SUM(N82:R82)*N83","v":0},null,null,null,null,{"$f":"SUM(S82:W82)*S83","v":0},null,null,null,null,{"$f":"SUM(X82:AB82)*X83","v":0},null,null,null,null,{"$f":"SUM(AC82:AG82)*AC83","v":0},null,null,null,null,{"$f":"SUM(AH82:AL82)*AH83","v":0},null,null,null,{"$f":"SUM(AL82:AP82)*AL83","v":0},null,null,null,{"$f":"SUM(D84:AO84)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D85:H85)*D86","v":0},null,null,null,null,{"$f":"SUM(I85:M85)*I86","v":0},null,null,null,null,{"$f":"SUM(N85:R85)*N86","v":0},null,null,null,null,{"$f":"SUM(S85:W85)*S86","v":0},null,null,null,null,{"$f":"SUM(X85:AB85)*X86","v":0},null,null,null,null,{"$f":"SUM(AC85:AG85)*AC86","v":0},null,null,null,null,{"$f":"SUM(AH85:AL85)*AH86","v":0},null,null,null,{"$f":"SUM(AL85:AP85)*AL86","v":0},null,null,null,{"$f":"SUM(D87:AO87)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D88:H88)*D89","v":0},null,null,null,null,{"$f":"SUM(I88:M88)*I89","v":0},null,null,null,null,{"$f":"SUM(N88:R88)*N89","v":0},null,null,null,null,{"$f":"SUM(S88:W88)*S89","v":0},null,null,null,null,{"$f":"SUM(X88:AB88)*X89","v":0},null,null,null,null,{"$f":"SUM(AC88:AG88)*AC89","v":0},null,null,null,null,{"$f":"SUM(AH88:AL88)*AH89","v":0},null,null,null,{"$f":"SUM(AL88:AP88)*AL89","v":0},null,null,null,{"$f":"SUM(D90:AO90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4-DD-CD-LABOR'!A40","v":"Supplemental Services 2"}]
[null,null,"Reproducible (Number of Sheets)"]
[null,null,"Cost per Sheet"]
[null,null,"Total Reproducible",{"$f":"SUM(D92:H92)*D93","v":0},null,null,null,null,{"$f":"SUM(I92:M92)*I93","v":0},null,null,null,null,{"$f":"SUM(N92:R92)*N93","v":0},null,null,null,null,{"$f":"SUM(S92:W92)*S93","v":0},null,null,null,null,{"$f":"SUM(X92:AB92)*X93","v":0},null,null,null,null,{"$f":"SUM(AC92:AG92)*AC93","v":0},null,null,null,null,{"$f":"SUM(AH92:AL92)*AH93","v":0},null,null,null,{"$f":"SUM(AL92:AP92)*AL93","v":0},null,null,null,{"$f":"SUM(D94:AO94)","v":0}]
[null,null,"Photocopy (Number of Copies)"]
[null,null,"Cost per Copy"]
[null,null,"Total Copy Costs",{"$f":"SUM(D95:H95)*D96","v":0},null,null,null,null,{"$f":"SUM(I95:M95)*I96","v":0},null,null,null,null,{"$f":"SUM(N95:R95)*N96","v":0},null,null,null,null,{"$f":"SUM(S95:W95)*S96","v":0},null,null,null,null,{"$f":"SUM(X95:AB95)*X96","v":0},null,null,null,null,{"$f":"SUM(AC95:AG95)*AC96","v":0},null,null,null,null,{"$f":"SUM(AH95:AL95)*AH96","v":0},null,null,null,{"$f":"SUM(AL95:AP95)*AL96","v":0},null,null,null,{"$f":"SUM(D97:AO97)","v":0}]
[null,null,"Photography (Number of developed photos)"]
[null,null,"Cost to Develop Each Photo"]
[null,null,"Total Cost to Develop Photos",{"$f":"SUM(D98:H98)*D99","v":0},null,null,null,null,{"$f":"SUM(I98:M98)*I99","v":0},null,null,null,null,{"$f":"SUM(N98:R98)*N99","v":0},null,null,null,null,{"$f":"SUM(S98:W98)*S99","v":0},null,null,null,null,{"$f":"SUM(X98:AB98)*X99","v":0},null,null,null,null,{"$f":"SUM(AC98:AG98)*AC99","v":0},null,null,null,null,{"$f":"SUM(AH98:AL98)*AH99","v":0},null,null,null,{"$f":"SUM(AL98:AP98)*AL99","v":0},null,null,null,{"$f":"SUM(D100:AO100)","v":0}]
[null,null,"Plotting (Number of Sheets)"]
[null,null,"Cost to Plot Each Sheet"]
[null,null,"Total Cost of Plotting",{"$f":"SUM(D101:H101)*D102","v":0},null,null,null,null,{"$f":"SUM(I101:M101)*I102","v":0},null,null,null,null,{"$f":"SUM(N101:R101)*N102","v":0},null,null,null,null,{"$f":"SUM(S101:W101)*S102","v":0},null,null,null,null,{"$f":"SUM(X101:AB101)*X102","v":0},null,null,null,null,{"$f":"SUM(AC101:AG101)*AC102","v":0},null,null,null,null,{"$f":"SUM(AH101:AL101)*AH102","v":0},null,null,null,{"$f":"SUM(AL101:AP101)*AL102","v":0},null,null,null,{"$f":"SUM(D103:AO103)","v":0}]
[null,null,"Number of Deliveries"]
[null,null,"Cost per Delivery"]
[null,null,"Total Cost of Deliveries",{"$f":"SUM(D104:H104)*D105","v":0},null,null,null,null,{"$f":"SUM(I104:M104)*I105","v":0},null,null,null,null,{"$f":"SUM(N104:R104)*N105","v":0},null,null,null,null,{"$f":"SUM(S104:W104)*S105","v":0},null,null,null,null,{"$f":"SUM(X104:AB104)*X105","v":0},null,null,null,null,{"$f":"SUM(AC104:AG104)*AC105","v":0},null,null,null,null,{"$f":"SUM(AH104:AL104)*AH105","v":0},null,null,null,{"$f":"SUM(AL104:AP104)*AL105","v":0},null,null,null,{"$f":"SUM(D106:AO106)","v":0}]
[null,null,"Number of Printed Pages"]
[null,null,"Cost to Print per Page"]
[null,null,"Total Printing Costs",{"$f":"SUM(D107:H107)*D108","v":0},null,null,null,null,{"$f":"SUM(I107:M107)*I108","v":0},null,null,null,null,{"$f":"SUM(N107:R107)*N108","v":0},null,null,null,null,{"$f":"SUM(S107:W107)*S108","v":0},null,null,null,null,{"$f":"SUM(X107:AB107)*X108","v":0},null,null,null,null,{"$f":"SUM(AC107:AG107)*AC108","v":0},null,null,null,null,{"$f":"SUM(AH107:AL107)*AH108","v":0},null,null,null,{"$f":"SUM(AL107:AP107)*AL108","v":0},null,null,null,{"$f":"SUM(D109:AO109)","v":0}]
[null,null,"Number of Facsimiles"]
[null,null,"Cost per Facsimiles"]
[null,null,"Total Cost of Facsimiles",{"$f":"SUM(D110:H110)*D111","v":0},null,null,null,null,{"$f":"SUM(I110:M110)*I111","v":0},null,null,null,null,{"$f":"SUM(N110:R110)*N111","v":0},null,null,null,null,{"$f":"SUM(S110:W110)*S111","v":0},null,null,null,null,{"$f":"SUM(X110:AB110)*X111","v":0},null,null,null,null,{"$f":"SUM(AC110:AG110)*AC111","v":0},null,null,null,null,{"$f":"SUM(AH110:AL110)*AH111","v":0},null,null,null,{"$f":"SUM(AL110:AP110)*AL111","v":0},null,null,null,{"$f":"SUM(D112:AO112)","v":0}]