{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["UPDATES","PROJECT DATA","Summary","Staff Hour Summary-Grand Total","Staff Hour Summary - Firm","Fee Sheet - Prime","Fee Sheet - Sub","CITS Output","2. PROJECT DESCRIP & OBJECTIVES","3. PUBLIC INVOLVEMENT","4. ENG ANALYSIS & REPORTS","5. ENVIRON. ANALYSIS & REPORTS","6. ENVIRONMENTAL DOCUMENT","8. DESIGN SERVICES"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":117,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"UPDATES","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[2,0,2,4]]}
["Activity","Task","Revision Descriptions"]
[null,null,"PD&E Scope of Services","Staff Hour Estimation Forms","Staff Hour Guidelines"]
["File Version Number: v.2018.01\nRevision Date: 04/03/2018"]
["File Name","- -","- -",null,"- -"]
["Updates worksheet","- -","- -",null,"- -"]
["Project Description & Objectives",2,"- -","Updated the task names to match scope of services. Verified and updated tasks that require QA/QC. Form updated to include the meeting summary table","Verified and update task that require QA/QC. Meetings for specific tasks are now consolidated under task 2.2.6. Removed preparation and execution of sub-agreeement as a it is an overhead activity"]
["Public Involvement",3,"- -","Updated the task names to match scope of services. Verified and updated tasks that require QA/QC","Verified and update task that require QA/QC. Added tasks to match the Scope of Services"]
["Engineering Analysis & Reports",4,"- -","Updated the task names to match scope of services. Verified and updated tasks that require QA/QC","Verified and update task that require QA/QC. Included hours to estimate Context Classfication in 4.10.1"]
["Environmental Analysis & Reports",5,"- -","Updated the task names to match scope of services. Verified and updated tasks that require QA/QC","- -"]
["Environmental Document",6,"- -",null,"- -"]
["Design Services",8,"- -","Item 8 has been added to reflect the revised staff hours estimate guideline and scope of services template","- -"]
["Project Data","- -","- -",null,"- -"]
["Summary","- -","- -",null,"- -"]
["Staff Hour Summary Grand Total","- -","- -",null,"- -"]
["Staff Hour Summary - Firm","- -","- -",null,"- -"]
["Fee Sheet - Prime","- -","- -",null,"- -"]
["Fee Sheet - Sub","- -","- -",null,"- -"]
[null,null,"- -",null,"- -"]

{"sheet":"PROJECT DATA","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[17,2,17,13],[5,5,5,9],[15,4,15,5],[13,3,13,7],[3,0,3,4],[7,0,7,1],[5,0,5,4],[7,2,7,13],[3,5,3,9],[11,10,11,11],[9,2,9,5],[11,2,11,4],[11,5,11,7],[11,8,11,9]]}
[]
[]
[]
["Financial Project Identification Number:",null,null,null,null,"123456-7-89-10"]
[]
["Federal Aid Project Identification Number:",null,null,null,null,54321]
[]
["Project Description:",null,"Enter project name and description"]
[]
["County:",null,"Enter name of county"]
[]
["Begin Milepost:",null,null,null,null,"End Milepost:",null,null,null,null,"Project Length:",null,null,"Miles"]
[]
["FDOT Project Manager:"]
[]
["Prepared By:",null,"FDOT",null,"Consultant",null,null,"Final"]
[]
["Consultant Name:",null,"Enter name of consultant"]
[]
[]
[]
[null,null,"SUMMARY"]
[]
[null,null,"2.0 PROJECT DESCRIPTION AND OBJECTIVES",null,null,null,null,null,null,{"$f":"'2. PROJECT DESCRIP & OBJECTIVES'!F33","v":0}]
[null,null,"3.0 PUBLIC INVOLVEMENT",null,null,null,null,null,null,{"$f":"'3. PUBLIC INVOLVEMENT'!F158","v":0}]
[null,null,"4.0 ENGINEERING ANALYSIS AND REPORTS",null,null,null,null,null,null,{"$f":"'4. ENG ANALYSIS & REPORTS'!F137","v":0}]
[null,null,"5.0 ENVIRONMENTAL ANALYSIS AND REPORTS",null,null,null,null,null,null,{"$f":"'5. ENVIRON. ANALYSIS & REPORTS'!F87","v":0}]
[null,null,"6.0 ENVIRONMENTAL DOCUMENT",null,null,null,null,null,null,{"$f":"'6. ENVIRONMENTAL DOCUMENT'!F24","v":0}]
[null,null,"8.0 DESIGN SERVICES",null,null,null,null,null,null,{"$f":"'8. DESIGN SERVICES'!F11","v":0}]
[]
[null,null,"PROJECT TOTAL  HOURS",null,null,null,null,null,null,{"$f":"SUM(J24:J29)","v":0}]

{"sheet":"Summary","index":2,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,0,10,1],[0,13,0,15],[1,13,1,15],[2,2,2,15]]}
["Name of Consultant:",null,{"$f":"'PROJECT DATA'!C18:N18","v":"Enter name of consultant"},null,null,null,null,null,null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[null,null,"Project Staff Hours"]
["Activity No.","Activity",{"$f":"C1","v":"Enter name of consultant"},"Enter Name Sub 1","Sub 2","Sub 3","Sub 4","Sub 5","Sub 6","Sub 7","Sub 8","Sub 9","Sub 10","Sub 11","Sub 12","Total Hours"]
[2,"Project Description and Objectives",{"$f":"'PROJECT DATA'!J24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:O5)","v":0}]
[3,"Public Involvement",{"$f":"'PROJECT DATA'!J25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C6:O6)","v":0}]
[4,"Engineering Analysis & Report",{"$f":"'PROJECT DATA'!J26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"Environmental Analysis & Reports",{"$f":"'PROJECT DATA'!J27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[6,"Environmental Document",{"$f":"'PROJECT DATA'!J28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0,"check"]
[8,"Design Services",{"$f":"'PROJECT DATA'!J29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0,"check"]
["Project Total",null,{"$f":"SUM(C5:C10)","v":0},{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P5:P10)","v":0},{"$f":"SUM(C11:O11)","v":0}]
[]
["Notes: ","1.  Staff hours for consultant come directly from each discipline's worksheet."]
[null,"2.  Staff hours for subconsultants are to be entered manually into columns D through O."]
[null,"3.  For workbooks prepared by subconsultants, their project hours will be totaled in column C. "]

{"sheet":"Staff Hour Summary-Grand Total","index":3,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[6,1,8,1],[24,0,24,16],[30,0,30,14],[0,0,0,16],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,11,10,11],[9,10,10,10],[9,12,10,12],[9,8,10,8],[9,9,10,9],[2,13,2,16],[4,13,4,16],[26,13,26,16],[28,13,28,16],[8,14,8,15],[7,14,7,15],[20,12,20,13],[9,13,10,13],[9,14,9,15]]}
["ESTIMATE OF WORK EFFORT FOR TECHNICAL PROPOSALS - GRAND TOTAL"]
[]
["Financial Project Number:",{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"},null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[]
["FAP Number:",{"$f":"'PROJECT DATA'!F6","v":54321},null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2018-04-03"},null,"Name of Consultant:",{"$f":"'PROJECT DATA'!C18","v":"Enter name of consultant"}]
[]
[null,"Hours from \"Summary\" sheet",null,null,null,null,null,null,null,null,null,null,null,null," "]
["WORK",null,null,null,null,null,null,"EMPLOYEE CLASSIFICATION",null,null,null,null,null,null,"TOTAL"]
["ACTIVITY",null,null,null,null,null,null,null,null,null,null,null,null,null,"STAFF HOURS",null,"ON CADD"]
[null,"Grand","Project Manager","Staff Classification 2","Staff Classification 3","Staff Classification 4","Staff Classification 5","Staff Classification 6","Staff Classification 7","Staff Classification 8","Staff Classification 9","Staff Classification 10","Staff Classification 11","Staff Classification 12","RANGE"]
[null,"Total"]
[" ","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours",null,null,"PERCENT"]
[{"$f":"Summary!B5","v":"Project Description and Objectives"},{"$f":"Summary!P5","v":0},{"$f":"ROUND($B13*C33,0)","v":0},{"$f":"ROUND($B13*D33,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C13:N13)","v":0},{"$f":"ROUND(SUM(C13:N13)*1.1,0)","v":0}]
[{"$f":"Summary!B6","v":"Public Involvement"},{"$f":"Summary!P6","v":0},{"$f":"ROUND($B14*C34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C14:N14)","v":0},{"$f":"ROUND(SUM(C14:N14)*1.1,0)","v":0}]
[{"$f":"Summary!B7","v":"Engineering Analysis & Report"},{"$f":"Summary!P7","v":0},{"$f":"ROUND($B15*C35,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B8","v":"Environmental Analysis & Reports"},{"$f":"Summary!P8","v":0},{"$f":"ROUND($B16*C36,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B9","v":"Environmental Document"},{"$f":"Summary!P9","v":0},{"$f":"ROUND($B17*C37,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B10","v":"Design Services"},{"$f":"Summary!P10","v":0},{"$f":"ROUND($B18*C38,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTALS ",{"$f":"SUM(B13:B18)","v":0},{"$f":"SUM(C13:C18)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O13:O18)","v":0},{"$f":"SUM(P13:P18)","v":0}]
[null,null,null,null,null,null,null,null,null,"Field Survey Estimate:"]
[null,null,null,null,null,null,null,null,null,null,"4-man crew days",null," (Prime Consultant)",null,{"$f":"O19","v":0},{"$f":"P19","v":0}]
[]
[]
[]
["ESTIMATE OF WORK EFFORT FOR TECHNICAL PROPOSALS - GRAND TOTAL"]
[]
["Financial Project Number:",{"$f":"B3","v":"123456-7-89-10"},null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"N3","v":"Enter project name and description"}]
[]
["FAP Number:",{"$f":"B5","v":54321},null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2018-04-03"},null,"Name of Consultant:  ",{"$f":"N5","v":"Enter name of consultant"}]
[]
["Staff Hour Distribution Percentages - Grand Total"]
[null,"Hours from \"Summary\" sheet         Grand Total",{"$f":"C10","v":"Project Manager"},"Staff Classification 2","Staff Classification 3","Staff Classification 4","Staff Classification 5","Staff Classification 6","Staff Classification 7","Staff Classification 8","Staff Classification 9","Staff Classification 10","Staff Classification 11","Staff Classification 12","Total"]
[{"$f":"A13","v":"Project Description and Objectives"},{"$f":"B13","v":0},0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,{"$f":"SUM(C33:N33)","v":1}]
[{"$f":"A14","v":"Public Involvement"},0,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,1]
[{"$f":"A15","v":"Engineering Analysis & Report"},0,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,1]
[{"$f":"A16","v":"Environmental Analysis & Reports"},0,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,1]
[{"$f":"A17","v":"Environmental Document"},0,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,1]
[{"$f":"A18","v":"Design Services"},0,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,1]
[]
["Note:  ","This spreadsheet to be used in Technical Proposal for Districts requiring the Grand Total hours be provided along with percentage distribution by classification."]
[]
[]
[]
[]
[" "]

{"sheet":"Staff Hour Summary - Firm","index":4,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,16],[9,11,10,11],[4,13,4,16],[26,13,26,16],[24,0,24,16],[9,10,10,10],[9,6,10,6],[9,7,10,7],[30,0,30,14],[0,0,0,16],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[6,1,8,1],[9,12,10,12],[9,8,10,8],[9,9,10,9],[28,13,28,16],[8,14,8,15],[7,14,7,15],[20,12,20,13],[9,13,10,13],[9,14,9,15]]}
["ESTIMATE OF WORK EFFORT FOR TECHNICAL PROPOSALS - FIRM TOTAL"]
[]
["Financial Project Number:",{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"},null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[]
["FAP Number:",{"$f":"'PROJECT DATA'!F6","v":54321},null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2018-04-03"},null,"Name of Consultant:  ",{"$f":"'PROJECT DATA'!C18","v":"Enter name of consultant"}]
[]
[null,"Hours from \"Summary\" sheet",null,null,null,null,null,null,null,null,null,null,null,null," "]
["WORK",null,null,null,null,null,null,"EMPLOYEE CLASSIFICATION",null,null,null,null,null,null,"TOTAL"]
["ACTIVITY",null,null,null,null,null,null,null,null,null,null,null,null,null,"STAFF HOURS",null,"ON CADD"]
[null,"Firm",{"$f":"'Staff Hour Summary-Grand Total'!C10","v":"Project Manager"},{"$f":"'Staff Hour Summary-Grand Total'!D10","v":"Staff Classification 2"},{"$f":"'Staff Hour Summary-Grand Total'!E10","v":"Staff Classification 3"},{"$f":"'Staff Hour Summary-Grand Total'!F10","v":"Staff Classification 4"},{"$f":"'Staff Hour Summary-Grand Total'!G10","v":"Staff Classification 5"},{"$f":"'Staff Hour Summary-Grand Total'!H10","v":"Staff Classification 6"},{"$f":"'Staff Hour Summary-Grand Total'!I10","v":"Staff Classification 7"},{"$f":"'Staff Hour Summary-Grand Total'!J10","v":"Staff Classification 8"},{"$f":"'Staff Hour Summary-Grand Total'!K10","v":"Staff Classification 9"},{"$f":"'Staff Hour Summary-Grand Total'!L10","v":"Staff Classification 10"},{"$f":"'Staff Hour Summary-Grand Total'!M10","v":"Staff Classification 11"},{"$f":"'Staff Hour Summary-Grand Total'!N10","v":"Staff Classification 12"},"RANGE"]
[null,"Total"]
[" ","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours","Hours",null,null,"PERCENT"]
[{"$f":"Summary!B5","v":"Project Description and Objectives"},{"$f":"Summary!C5","v":0},{"$f":"ROUND($B13*C33,0)","v":0},{"$f":"ROUND($B13*D33,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C13:N13)","v":0},{"$f":"ROUND(SUM(C13:N13)*1.1,0)","v":0}]
[{"$f":"Summary!B6","v":"Public Involvement"},{"$f":"Summary!C6","v":0},{"$f":"ROUND($B14*C34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B7","v":"Engineering Analysis & Report"},{"$f":"Summary!C7","v":0},{"$f":"ROUND($B15*C35,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B8","v":"Environmental Analysis & Reports"},{"$f":"Summary!C8","v":0},{"$f":"ROUND($B16*C36,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B9","v":"Environmental Document"},{"$f":"Summary!C9","v":0},{"$f":"ROUND($B17*C37,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B10","v":"Design Services"},{"$f":"Summary!C10","v":0},{"$f":"ROUND($B18*C38,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTALS ",{"$f":"SUM(B13:B18)","v":0},{"$f":"SUM(C13:C18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Field Survey Estimate:"]
[null,null,null,null,null,null,null,null,null,null,"4-man crew days",null,"FIRM TOTAL",null,{"$f":"O19","v":0},{"$f":"P19","v":0}]
[]
[]
[]
["ESTIMATE OF WORK EFFORT FOR TECHNICAL PROPOSALS - FIRM TOTAL"]
[]
["Financial Project Number:",{"$f":"B3","v":"123456-7-89-10"},null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"N3","v":"Enter project name and description"}]
[]
["FAP Number:",{"$f":"B5","v":54321},null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2018-04-03"},null,"Name of Consultant:  ",{"$f":"N5","v":"Enter name of consultant"}]
[]
["Staff Hour Distribution Percentages - Firm Total"]
[null,"Hours from \"Summary\" sheet             Firm Total",{"$f":"C10","v":"Project Manager"},"Staff Classification 2","Staff Classification 3","Staff Classification 4","Staff Classification 5","Staff Classification 6","Staff Classification 7","Staff Classification 8","Staff Classification 9","Staff Classification 10","Staff Classification 11","Staff Classification 12","Total"]
[{"$f":"A13","v":"Project Description and Objectives"},{"$f":"B13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C33:N33)","v":0}]
[{"$f":"A14","v":"Public Involvement"},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Engineering Analysis & Report",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Environmental Analysis & Reports",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Environmental Document",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Design Services",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Fee Sheet - Prime","index":5,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,13,7,13],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,0,7,0],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,1,8,1]]}
["ESTIMATE OF WORK EFFORT AND COST - PRIME CONSULTANT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Name of Project: ",{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"},null,null,null,null,null,null,null,null,null,null,"Consult. Name:",{"$f":"'PROJECT DATA'!C18","v":"Enter name of consultant"}]
["County:",{"$f":"'PROJECT DATA'!C10","v":"Enter name of county"},null,null,null,null,null,null,null,null,null,null,"Consult. No.","enter consultants proj. number"]
["FPN:   ",{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"},null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"NOW()","v":"2018-04-03T15:37:55.100"}]
["FAP No.:",{"$f":"'PROJECT DATA'!F6","v":54321},null,null,null,null,null,null,null,null,null,null,"Estimator: ","insert name"]
["Staff Classification","Total Staff Hours From \"SH Summary - Firm\"",{"$f":"'Staff Hour Summary-Grand Total'!C10","v":"Project Manager"},{"$f":"'Staff Hour Summary-Grand Total'!D10","v":"Staff Classification 2"},{"$f":"'Staff Hour Summary-Grand Total'!E10","v":"Staff Classification 3"},{"$f":"'Staff Hour Summary-Grand Total'!F10","v":"Staff Classification 4"},{"$f":"'Staff Hour Summary-Grand Total'!G10","v":"Staff Classification 5"},{"$f":"'Staff Hour Summary-Grand Total'!H10","v":"Staff Classification 6"},{"$f":"'Staff Hour Summary-Grand Total'!I10","v":"Staff Classification 7"},{"$f":"'Staff Hour Summary-Grand Total'!J10","v":"Staff Classification 8"},{"$f":"'Staff Hour Summary-Grand Total'!K10","v":"Staff Classification 9"},{"$f":"'Staff Hour Summary-Grand Total'!L10","v":"Staff Classification 10"},{"$f":"'Staff Hour Summary-Grand Total'!M10","v":"Staff Classification 11"},{"$f":"'Staff Hour Summary-Grand Total'!N10","v":"Staff Classification 12"},"SH","Salary","Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By","Cost By","Rate Per"]
[null,null,0,0,0,0,0,0,0,0,0,0,10,0,"Activity","Activity","Task"]
[{"$f":"Summary!B5","v":"Project Description and Objectives"},{"$f":"'Staff Hour Summary - Firm'!B13","v":0},{"$f":"'Staff Hour Summary - Firm'!C13","v":0},{"$f":"'Staff Hour Summary - Firm'!D13","v":0},{"$f":"'Staff Hour Summary - Firm'!E13","v":0},{"$f":"'Staff Hour Summary - Firm'!F13","v":0},{"$f":"'Staff Hour Summary - Firm'!G13","v":0},{"$f":"'Staff Hour Summary - Firm'!H13","v":0},{"$f":"'Staff Hour Summary - Firm'!I13","v":0},{"$f":"'Staff Hour Summary - Firm'!J13","v":0},{"$f":"'Staff Hour Summary - Firm'!K13","v":0},{"$f":"'Staff Hour Summary - Firm'!L13","v":0},{"$f":"'Staff Hour Summary - Firm'!M13","v":0},{"$f":"'Staff Hour Summary - Firm'!N13","v":0},{"$f":"SUM(C10:N10)","v":0},{"$f":"C10*$C$9+D10*$D$9+E10*$E$9+F10*$F$9+G10*$G$9+H10*$H$9+I10*$I$9+J10*$J$9+K10*$K$9+L10*$L$9+M10*$M$9+N10*$N$9","v":0},{"$f":"ROUND(+P10/O10,2)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Summary!B6","v":"Public Involvement"},{"$f":"'Staff Hour Summary - Firm'!B14","v":0},{"$f":"'Staff Hour Summary - Firm'!C14","v":0},{"$f":"'Staff Hour Summary - Firm'!D14","v":0},{"$f":"'Staff Hour Summary - Firm'!E14","v":0},{"$f":"'Staff Hour Summary - Firm'!F14","v":0},{"$f":"'Staff Hour Summary - Firm'!G14","v":0},{"$f":"'Staff Hour Summary - Firm'!H14","v":0},{"$f":"'Staff Hour Summary - Firm'!I14","v":0},{"$f":"'Staff Hour Summary - Firm'!J14","v":0},{"$f":"'Staff Hour Summary - Firm'!K14","v":0},{"$f":"'Staff Hour Summary - Firm'!L14","v":0},{"$f":"'Staff Hour Summary - Firm'!M14","v":0},{"$f":"'Staff Hour Summary - Firm'!N14","v":0},0,{"$f":"C11*$C$9+D11*$D$9+E11*$E$9+F11*$F$9+G11*$G$9+H11*$H$9+I11*$I$9+J11*$J$9+K11*$K$9+L11*$L$9+M11*$M$9+N11*$N$9","v":0},{"$error":"#DIV/0!"}]
[{"$f":"Summary!B7","v":"Engineering Analysis & Report"},{"$f":"'Staff Hour Summary - Firm'!B15","v":0},{"$f":"'Staff Hour Summary - Firm'!C15","v":0},{"$f":"'Staff Hour Summary - Firm'!D15","v":0},{"$f":"'Staff Hour Summary - Firm'!E15","v":0},{"$f":"'Staff Hour Summary - Firm'!F15","v":0},{"$f":"'Staff Hour Summary - Firm'!G15","v":0},{"$f":"'Staff Hour Summary - Firm'!H15","v":0},{"$f":"'Staff Hour Summary - Firm'!I15","v":0},{"$f":"'Staff Hour Summary - Firm'!J15","v":0},{"$f":"'Staff Hour Summary - Firm'!K15","v":0},{"$f":"'Staff Hour Summary - Firm'!L15","v":0},{"$f":"'Staff Hour Summary - Firm'!M15","v":0},{"$f":"'Staff Hour Summary - Firm'!N15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"Summary!B8","v":"Environmental Analysis & Reports"},{"$f":"'Staff Hour Summary - Firm'!B16","v":0},{"$f":"'Staff Hour Summary - Firm'!C16","v":0},{"$f":"'Staff Hour Summary - Firm'!D16","v":0},{"$f":"'Staff Hour Summary - Firm'!E16","v":0},{"$f":"'Staff Hour Summary - Firm'!F16","v":0},{"$f":"'Staff Hour Summary - Firm'!G16","v":0},{"$f":"'Staff Hour Summary - Firm'!H16","v":0},{"$f":"'Staff Hour Summary - Firm'!I16","v":0},{"$f":"'Staff Hour Summary - Firm'!J16","v":0},{"$f":"'Staff Hour Summary - Firm'!K16","v":0},{"$f":"'Staff Hour Summary - Firm'!L16","v":0},{"$f":"'Staff Hour Summary - Firm'!M16","v":0},{"$f":"'Staff Hour Summary - Firm'!N16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"Summary!B9","v":"Environmental Document"},{"$f":"'Staff Hour Summary - Firm'!B17","v":0},{"$f":"'Staff Hour Summary - Firm'!C17","v":0},{"$f":"'Staff Hour Summary - Firm'!D17","v":0},{"$f":"'Staff Hour Summary - Firm'!E17","v":0},{"$f":"'Staff Hour Summary - Firm'!F17","v":0},{"$f":"'Staff Hour Summary - Firm'!G17","v":0},{"$f":"'Staff Hour Summary - Firm'!H17","v":0},{"$f":"'Staff Hour Summary - Firm'!I17","v":0},{"$f":"'Staff Hour Summary - Firm'!J17","v":0},{"$f":"'Staff Hour Summary - Firm'!K17","v":0},{"$f":"'Staff Hour Summary - Firm'!L17","v":0},{"$f":"'Staff Hour Summary - Firm'!M17","v":0},{"$f":"'Staff Hour Summary - Firm'!N17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"Summary!B10","v":"Design Services"},{"$f":"'Staff Hour Summary - Firm'!B18","v":0},{"$f":"'Staff Hour Summary - Firm'!C18","v":0},{"$f":"'Staff Hour Summary - Firm'!D18","v":0},{"$f":"'Staff Hour Summary - Firm'!E18","v":0},{"$f":"'Staff Hour Summary - Firm'!F18","v":0},{"$f":"'Staff Hour Summary - Firm'!G18","v":0},{"$f":"'Staff Hour Summary - Firm'!H18","v":0},{"$f":"'Staff Hour Summary - Firm'!I18","v":0},{"$f":"'Staff Hour Summary - Firm'!J18","v":0},{"$f":"'Staff Hour Summary - Firm'!K18","v":0},{"$f":"'Staff Hour Summary - Firm'!L18","v":0},{"$f":"'Staff Hour Summary - Firm'!M18","v":0},{"$f":"'Staff Hour Summary - Firm'!N18","v":0},0,0,{"$error":"#DIV/0!"}]
["Total Staff Hours",{"$f":"SUM(B10:B15)","v":0},{"$f":"SUM(C10:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Total Staff Cost",null,{"$f":"C16*C9","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(P10:P15),2)","v":0},{"$f":"ROUND(SUM(+P17/O16),2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check =",{"$f":"SUM(C17:N17)","v":0}]
[null,null,null,null,null,null,"Survey Field Days by Subconsultant",null,null,null,"SALARY RELATED COSTS:",null,null,null,null,null,{"$f":"P17","v":0}]
[null,null,null,null,null,null,null,null,null,null,"OVERHEAD: ",null,null,0,null,null,{"$f":"ROUND(Q$19*N20,2)","v":0}]
[null,null,null,null,null,null,"4 - Person Crew:",null,null,null,"OPERATING MARGIN:",null,null,0,null,null,{"$f":"ROUND(Q$19*N21,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"FCCM (Facilities Capital Cost Money):",null,null,0,null,null,{"$f":"ROUND(Q$19*N22,2)","v":0}]
[null,"Notes:",null,null,null,null,null,null,null,null,"EXPENSES:",null,null,0,null,null,{"$f":"ROUND(Q$19*N23,2)","v":0}]
[null,"1.  This sheet to be used by Prime Consultant to calculate the Grand Total fee.",null,null,null,null,null,null,null,null,"SALARY RELATED SUBTOTAL:",null,null,null,null,null,{"$f":"ROUND(SUM(Q19:Q23),2)","v":0}]
[null,"2.  Manually enter fee from each subconsultant.  Unused subconsultant rows may be hidden.",null,null,null,null,null,null,null,null,"Survey (Field - if by Prime)",null,0,"4-man crew days @",0," / day",{"$f":"ROUND(O25*M25,2)","v":0}]
[null,"3. Enter the rate for each classification in Row 9.",null,null,null,null,null,null,null,null,"SUBTOTAL - PRIME",null,null,null,null,null,{"$f":"Q24+Q25","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!D4","v":"Enter Name Sub 1"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!E4","v":"Sub 2"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!F4","v":"Sub 3"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!G4","v":"Sub 4"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!H4","v":"Sub 5"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!I4","v":"Sub 6"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!J4","v":"Sub 7"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!K4","v":"Sub 8"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!L4","v":"Sub 9"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!M4","v":"Sub 10"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!N4","v":"Sub 11"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Subconsultant: ",{"$f":"Summary!O4","v":"Sub 12"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"SUBTOTAL ESTIMATED FEE:",null,null,null,null,null,{"$f":"ROUND(SUM(Q26:Q38),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Optional Services",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL ESTIMATED FEE:",null,null,null,null,null,{"$f":"SUM(Q39:Q40)","v":0}]

{"sheet":"Fee Sheet - Sub","index":6,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,13,7,13],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,0,7,0],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,1,8,1]]}
["ESTIMATE OF WORK EFFORT AND COST - SUBCONSULTANT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Name of Project: ",{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"},null,null,null,null,null,null,null,null,null,null,"Consult. Name:",{"$f":"'PROJECT DATA'!C18","v":"Enter name of consultant"}]
["County:",{"$f":"'PROJECT DATA'!C10","v":"Enter name of county"},null,null,null,null,null,null,null,null,null,null,"Consult. No.","enter consultants proj. number"]
["FPN:   ",{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"},null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"NOW()","v":"2018-04-03T15:37:55.100"}]
["FAP No.:",{"$f":"'PROJECT DATA'!F6","v":54321},null,null,null,null,null,null,null,null,null,null,"Estimator: ","insert name"]
["Staff Classification","Total Staff Hours From \"SH Summary - Firm\"",{"$f":"'Staff Hour Summary - Firm'!C10","v":"Project Manager"},{"$f":"'Staff Hour Summary - Firm'!D10","v":"Staff Classification 2"},{"$f":"'Staff Hour Summary - Firm'!E10","v":"Staff Classification 3"},{"$f":"'Staff Hour Summary - Firm'!F10","v":"Staff Classification 4"},{"$f":"'Staff Hour Summary - Firm'!G10","v":"Staff Classification 5"},{"$f":"'Staff Hour Summary - Firm'!H10","v":"Staff Classification 6"},{"$f":"'Staff Hour Summary - Firm'!I10","v":"Staff Classification 7"},{"$f":"'Staff Hour Summary - Firm'!J10","v":"Staff Classification 8"},{"$f":"'Staff Hour Summary - Firm'!K10","v":"Staff Classification 9"},{"$f":"'Staff Hour Summary - Firm'!L10","v":"Staff Classification 10"},{"$f":"'Staff Hour Summary - Firm'!M10","v":"Staff Classification 11"},{"$f":"'Staff Hour Summary - Firm'!N10","v":"Staff Classification 12"},"SH","Salary","Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By","Cost By","Rate Per"]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,"Activity","Activity","Task"]
[{"$f":"'Staff Hour Summary - Firm'!A13","v":"Project Description and Objectives"},{"$f":"'Staff Hour Summary - Firm'!B13","v":0},{"$f":"'Staff Hour Summary - Firm'!C13","v":0},{"$f":"'Staff Hour Summary - Firm'!D13","v":0},{"$f":"'Staff Hour Summary - Firm'!E13","v":0},{"$f":"'Staff Hour Summary - Firm'!F13","v":0},{"$f":"'Staff Hour Summary - Firm'!G13","v":0},{"$f":"'Staff Hour Summary - Firm'!H13","v":0},{"$f":"'Staff Hour Summary - Firm'!I13","v":0},{"$f":"'Staff Hour Summary - Firm'!J13","v":0},{"$f":"'Staff Hour Summary - Firm'!K13","v":0},{"$f":"'Staff Hour Summary - Firm'!L13","v":0},{"$f":"'Staff Hour Summary - Firm'!M13","v":0},{"$f":"'Staff Hour Summary - Firm'!N13","v":0},{"$f":"SUM(C10:N10)","v":0},{"$f":"C10*$C$9+D10*$D$9+E10*$E$9+F10*$F$9+G10*$G$9+H10*$H$9+I10*$I$9+J10*$J$9+K10*$K$9+L10*$L$9+M10*$M$9+N10*$N$9","v":0},{"$f":"ROUND(+P10/O10,2)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Staff Hour Summary - Firm'!A14","v":"Public Involvement"},{"$f":"'Staff Hour Summary - Firm'!B14","v":0},{"$f":"'Staff Hour Summary - Firm'!C14","v":0},{"$f":"'Staff Hour Summary - Firm'!D14","v":0},{"$f":"'Staff Hour Summary - Firm'!E14","v":0},{"$f":"'Staff Hour Summary - Firm'!F14","v":0},{"$f":"'Staff Hour Summary - Firm'!G14","v":0},{"$f":"'Staff Hour Summary - Firm'!H14","v":0},{"$f":"'Staff Hour Summary - Firm'!I14","v":0},{"$f":"'Staff Hour Summary - Firm'!J14","v":0},{"$f":"'Staff Hour Summary - Firm'!K14","v":0},{"$f":"'Staff Hour Summary - Firm'!L14","v":0},{"$f":"'Staff Hour Summary - Firm'!M14","v":0},{"$f":"'Staff Hour Summary - Firm'!N14","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Staff Hour Summary - Firm'!A15","v":"Engineering Analysis & Report"},{"$f":"'Staff Hour Summary - Firm'!B15","v":0},{"$f":"'Staff Hour Summary - Firm'!C15","v":0},{"$f":"'Staff Hour Summary - Firm'!D15","v":0},{"$f":"'Staff Hour Summary - Firm'!E15","v":0},{"$f":"'Staff Hour Summary - Firm'!F15","v":0},{"$f":"'Staff Hour Summary - Firm'!G15","v":0},{"$f":"'Staff Hour Summary - Firm'!H15","v":0},{"$f":"'Staff Hour Summary - Firm'!I15","v":0},{"$f":"'Staff Hour Summary - Firm'!J15","v":0},{"$f":"'Staff Hour Summary - Firm'!K15","v":0},{"$f":"'Staff Hour Summary - Firm'!L15","v":0},{"$f":"'Staff Hour Summary - Firm'!M15","v":0},{"$f":"'Staff Hour Summary - Firm'!N15","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Staff Hour Summary - Firm'!A16","v":"Environmental Analysis & Reports"},{"$f":"'Staff Hour Summary - Firm'!B16","v":0},{"$f":"'Staff Hour Summary - Firm'!C16","v":0},{"$f":"'Staff Hour Summary - Firm'!D16","v":0},{"$f":"'Staff Hour Summary - Firm'!E16","v":0},{"$f":"'Staff Hour Summary - Firm'!F16","v":0},{"$f":"'Staff Hour Summary - Firm'!G16","v":0},{"$f":"'Staff Hour Summary - Firm'!H16","v":0},{"$f":"'Staff Hour Summary - Firm'!I16","v":0},{"$f":"'Staff Hour Summary - Firm'!J16","v":0},{"$f":"'Staff Hour Summary - Firm'!K16","v":0},{"$f":"'Staff Hour Summary - Firm'!L16","v":0},{"$f":"'Staff Hour Summary - Firm'!M16","v":0},{"$f":"'Staff Hour Summary - Firm'!N16","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Staff Hour Summary - Firm'!A17","v":"Environmental Document"},{"$f":"'Staff Hour Summary - Firm'!B17","v":0},{"$f":"'Staff Hour Summary - Firm'!C17","v":0},{"$f":"'Staff Hour Summary - Firm'!D17","v":0},{"$f":"'Staff Hour Summary - Firm'!E17","v":0},{"$f":"'Staff Hour Summary - Firm'!F17","v":0},{"$f":"'Staff Hour Summary - Firm'!G17","v":0},{"$f":"'Staff Hour Summary - Firm'!H17","v":0},{"$f":"'Staff Hour Summary - Firm'!I17","v":0},{"$f":"'Staff Hour Summary - Firm'!J17","v":0},{"$f":"'Staff Hour Summary - Firm'!K17","v":0},{"$f":"'Staff Hour Summary - Firm'!L17","v":0},{"$f":"'Staff Hour Summary - Firm'!M17","v":0},{"$f":"'Staff Hour Summary - Firm'!N17","v":0},0,0,{"$error":"#DIV/0!"}]
[{"$f":"'Staff Hour Summary - Firm'!A18","v":"Design Services"},{"$f":"'Staff Hour Summary - Firm'!B18","v":0},{"$f":"'Staff Hour Summary - Firm'!C18","v":0},{"$f":"'Staff Hour Summary - Firm'!D18","v":0},{"$f":"'Staff Hour Summary - Firm'!E18","v":0},{"$f":"'Staff Hour Summary - Firm'!F18","v":0},{"$f":"'Staff Hour Summary - Firm'!G18","v":0},{"$f":"'Staff Hour Summary - Firm'!H18","v":0},{"$f":"'Staff Hour Summary - Firm'!I18","v":0},{"$f":"'Staff Hour Summary - Firm'!J18","v":0},{"$f":"'Staff Hour Summary - Firm'!K18","v":0},{"$f":"'Staff Hour Summary - Firm'!L18","v":0},{"$f":"'Staff Hour Summary - Firm'!M18","v":0},{"$f":"'Staff Hour Summary - Firm'!N18","v":0},0,0,{"$error":"#DIV/0!"}]
["Total Staff Hours",{"$f":"SUM(B10:B15)","v":0},{"$f":"SUM(C10:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Total Staff Cost",null,{"$f":"C16*C9","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(P10:P15),2)","v":0},{"$f":"ROUND(SUM(+P17/O16),2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check =",{"$f":"SUM(C17:N17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SALARY RELATED COSTS:",null,null,null,null,null,{"$f":"P17","v":0}]
[null,null,null,null,null,null,null,null,null,null,"OVERHEAD: ",null,null,0,null,null,{"$f":"ROUND(Q$19*N20,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"OPERATING MARGIN:",null,null,0,null,null,{"$f":"ROUND(Q$19*N21,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"FCCM (Facilities Capital Cost Money):",null,null,0,null,null,{"$f":"ROUND(Q$19*N22,2)","v":0}]
[null,"Note:",null,null,null,null,null,null,null,null,"EXPENSES:",null,null,0,null,null,{"$f":"ROUND(Q$19*N23,2)","v":0}]
[null,"1.  This sheet to be used by Subconsultant to calculate its fee.",null,null,null,null,null,null,null,null,"SALARY RELATED SUBTOTAL:",null,null,null,null,null,{"$f":"ROUND(SUM(Q19:Q23),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Survey (Field - if by Sub)",null,0,"4-man crew days @",0," / day",{"$f":"ROUND(O25*M25,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SUBTOTAL - SUBCONSULTANT",null,null,null,null,null,{"$f":"Q24+Q25","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Optional Services",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"SUBCONSULTANT TOTAL ESTIMATED FEE:",null,null,null,null,null,{"$f":"SUM(Q26:Q27)","v":0}]

{"sheet":"CITS Output","index":7,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,14],[3,1,3,14]]}
["Project Summary for CITS Output"]
["Name of Prime Consultant:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[null,"Number of Hours"]
["Staff Classification","Prime Consultant",{"$f":"Summary!D4","v":"Enter Name Sub 1"},{"$f":"Summary!E4","v":"Sub 2"},{"$f":"Summary!F4","v":"Sub 3"},{"$f":"Summary!G4","v":"Sub 4"},{"$f":"Summary!H4","v":"Sub 5"},{"$f":"Summary!I4","v":"Sub 6"},{"$f":"Summary!J4","v":"Sub 7"},{"$f":"Summary!K4","v":"Sub 8"},{"$f":"Summary!L4","v":"Sub 9"},{"$f":"Summary!M4","v":"Sub 10"},{"$f":"Summary!N4","v":"Sub 11"},{"$f":"Summary!O4","v":"Sub 12"},"Total Hours"]
[{"$f":"'Staff Hour Summary-Grand Total'!C10","v":"Project Manager"},{"$f":"'Staff Hour Summary - Firm'!C19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6:N6)","v":0}]
[{"$f":"'Staff Hour Summary-Grand Total'!D10","v":"Staff Classification 2"},{"$f":"'Staff Hour Summary - Firm'!D19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!E10","v":"Staff Classification 3"},{"$f":"'Staff Hour Summary - Firm'!E19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!F10","v":"Staff Classification 4"},{"$f":"'Staff Hour Summary - Firm'!F19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!G10","v":"Staff Classification 5"},{"$f":"'Staff Hour Summary - Firm'!G19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!H10","v":"Staff Classification 6"},{"$f":"'Staff Hour Summary - Firm'!H19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!I10","v":"Staff Classification 7"},{"$f":"'Staff Hour Summary - Firm'!I19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!J10","v":"Staff Classification 8"},{"$f":"'Staff Hour Summary - Firm'!J19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!K10","v":"Staff Classification 9"},{"$f":"'Staff Hour Summary - Firm'!K19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!L10","v":"Staff Classification 10"},{"$f":"'Staff Hour Summary - Firm'!L19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!M10","v":"Staff Classification 11"},{"$f":"'Staff Hour Summary - Firm'!M19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Staff Hour Summary-Grand Total'!N10","v":"Staff Classification 12"},{"$f":"'Staff Hour Summary - Firm'!N19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total",{"$f":"SUM(B6:B17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"2. PROJECT DESCRIP & OBJECTIVES","index":8,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[62,0,63,0],[59,0,61,0],[44,0,58,0],[40,0,42,0],[37,0,39,0],[29,0,29,4],[30,0,30,4],[32,0,32,4],[21,1,21,5],[27,1,27,4],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[13,1,13,4],[10,1,10,5],[16,1,16,5],[18,1,18,5],[9,0,9,6]]}
["Estimator:",null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[]
["Representing",null,"Print Name",null,null,null,"Signature / Date"]
[]
[]
["NOTE: Signature Block is optional, per District preference"]
[]
["Task\nNo.","Task","Units","# of Units","Hours / Unit","Hours","Comments"]
["NOTE:  * subject to QC"]
[2.2000000000000002,"Project Requirements and Provisions for Work"]
[null,"     2.2.6 Meetings and Presentations","LS",null,null,{"$f":"F71","v":0},"see table below"]
[null,"     2.2.9 Schedule *","LS",1,0,{"$f":"ROUND((E13*D13),0)","v":0}]
[null,"2.2 Project Requirements and Provisions Work Total",null,null,null,{"$f":"SUM(F12:F13)","v":0}]
[2.2999999999999998,"Coordination with Other Consultants and Entities","LS",1,0,{"$f":"ROUND(D15*E15,0)","v":0}]
[2.4,"Contract Management","LS",1,0,{"$f":"ROUND(D16*E16,0)","v":0}]
[2.5,"Additional Services"]
[null,"     2.5.1 Alternative Corridor Evaluation *","LS",1,0,{"$f":"ROUND((E18*D18),0)","v":0}]
[null,"     2.5.2 Advance Notification"]
[null,"               Advance Notification *","LS",1,0,{"$f":"ROUND((E20*D20),0)","v":0}]
[null,"               Preliminary Environmental Discussion *","LS",1,0,{"$f":"ROUND((E21*D21),0)","v":0}]
[null,"     2.5.3 Scoping (EIS Only)"]
[null,"               Set up/Scoping Package*","LS",1,0,{"$f":"ROUND((E23*D23),0)","v":0}]
[null,"               Participation and notes","LS",1,0,{"$f":"ROUND((E24*D24),0)","v":0}]
[null,"     2.5.4 Notice of Intent (EIS Only) *","LS",1,0,{"$f":"ROUND((E25*D25),0)","v":0}]
[null,"     2.5.5 Transit Coordination Plan *","LS",1,0,{"$f":"ROUND((E26*D26),0)","v":0}]
[null,"     2.5.6 Miscellaneous Services *","LS",1,0,{"$f":"ROUND((E27*D27),0)","v":0}]
[null,"2.5 Additional Services Total",null,null,null,{"$f":"SUM(F18:F27)","v":0}]
[2.7,"Optional Services","LS",1,0,{"$f":"ROUND(D29*E29,0)","v":0}]
["Project Description and Objectives Subtotal",null,null,null,null,{"$f":"SUM(F28:F29,F16,F15,F14)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F13,F18,F20,F21,F23,F25,F26,F27)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E32*F31,0)","v":0}]
["PROJECT DESCRIPTION AND OBJECTIVES TOTAL HOURS",null,null,null,null,{"$f":"SUM(F30,F32)","v":0}]
[]
[]
[null,"Use the following table to assist with task 2.2.6 Meetings and Presentations"]
[null,"Technical Meetings","Units","No of Units","Hours/ Unit","Total Hours","Comments"]
["Roadway","Typical Section","EA",1,0,{"$f":"E38*D38","v":0}]
[null,"Access Management","EA",1,0,{"$f":"E39*D39","v":0}]
[null,"Concepts","EA",1,0,0]
["Drainage","Pond Siting","EA",1,0,0]
[null,"FDOT Drainage","EA",1,0,0]
[null,"Agency (Drainage)","EA",1,0,0]
["Structures","FDOT Structures","EA",1,0,0]
["Environmental","WMD","EA",1,0,0]
[null,"NMFS","EA",1,0,0]
[null,"USACE","EA",1,0,0]
[null,"USCG","EA",1,0,0]
[null,"USFWS","EA",1,0,0]
[null,"NPS","EA",1,0,{"$f":"E50*D50","v":0}]
[null,"SHPO","EA",1,0,0]
[null,"USFS","EA",1,0,0]
[null,"FFWCC","EA",1,0,0]
[null,"USDA & NRCS","EA",1,0,0]
[null,"USDOI","EA",1,0,0]
[null,"Noise Coordination","EA",1,0,0]
[null,"Cultural Resources Coordination","EA",1,0,0]
[null,"FDEP","EA",1,0,0]
[null,"FDOT Environmental","EA",1,0,0]
["Traffic","Traffic Methodology","EA",1,0,0]
[null,"Traffic Design","EA",1,0,0]
[null,"Traffic Analysis","EA",1,0,{"$f":"E62*D62","v":0}]
["Utilities and Railroad","UAO & DUO","EA",1,0,{"$f":"E63*D63","v":0}]
[null,"Railroad Office","EA",1,0,0]
["Tolls","Tolls","EA",1,0,0]
["PM / EMO","Local Governments (cities, counties, MPO)","EA",1,0,0]
[null,"Subtotal Technical Meetings",null,null,null,{"$f":"SUM(F38:F66)","v":0}]
[null,"Progress Meetings (if required by FDOT)","EA",1,0,0]
[null,"Phase Review Meetings","EA",1,0,0]
[null,"Misc. Review Meetings","EA",1,0,{"$f":"E70*D70","v":0}]
[null,"Total Meetings",null,null,null,{"$f":"SUM(F67:F70)","v":0},"Carry to task 2.2.6"]
[null,null," "]

{"sheet":"3. PUBLIC INVOLVEMENT","index":9,"n_rows":158,"n_cols":7,"rows_kept":158,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,5],[5,2,5,5],[4,2,4,5],[5,0,5,1],[4,0,4,1],[157,0,157,4],[154,0,154,4],[155,0,155,4],[146,1,146,5],[9,0,9,6],[18,1,18,5],[119,1,119,5],[153,1,153,4],[143,1,143,4],[118,1,118,4],[10,1,10,5],[17,1,17,4]]}
["Estimator:",null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[]
["Representing",null,"Print Name",null,null,null,"Signature / Date"]
[]
[]
["NOTE: Signature Block is optional, per District preference"]
[]
["Task\nNo.","Task","Units","# of Units","Hours / Unit","Hours","Comments"]
["NOTE:  * subject to QC"]
[3.1,"Public Involvement"]
[null,"     3.1.1 Public Involvement Plan*","LS",1,0,{"$f":"SUM(F13:F16)","v":0}]
[null,"               Public Involvement Plan*  ","LS",1,0,{"$f":"ROUND(D13*E13,0)","v":0}]
[null,"               Project Plan*  ","LS",1,0,0]
[null,"               Web Site Development *","LS",1,0,0]
[null,"               Web Site Content Updates *","LS",1,0,0]
[null,"     3.1.2 Public Involvement Data Collection (incl. site selection)","LS",1,0,0]
[null,"3.1 Public Involvement Total",null,null,null,{"$f":"SUM(F12,F17)","v":0}]
[3.2,"Scheduled Public Meetings"]
[null,"   Project Kickoff Meeting"]
[null,"       Development of Meeting Materials*","LS",1,{"$f":"SUM(E23:E28)","v":0},{"$f":"SUM(F22:F28)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D22*E22,0)","v":0}]
[null,"               Presentation*  ","LS",1,0,{"$f":"ROUND(D23*E23,0)","v":0}]
[null,"               Project Handouts * ","LS",1,0,{"$f":"ROUND(D24*E24,0)","v":0}]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Notification Letters *","LS",1,0,0]
[null,"               Press Release/Meeting Announcements *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E30:E31)","v":0},{"$f":"SUM(F30:F31)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D30*E30,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D31*E31,0)","v":0}]
[null,"   Presentation to Local MPOs and Associated Technical and Citizen Committees"]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E34:E36)","v":0},{"$f":"SUM(F34:F36)","v":0}]
[null,"               Presentation *","LS",1,0,{"$f":"ROUND(D34*E34,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D35*E35,0)","v":0}]
[null,"                Exhibits *","LS",1,0,0]
[null,"       Participation and notes","LS",1,{"$f":"SUM(E38:E39)","v":0},{"$f":"SUM(F38:F39)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D38*E38,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D39*E39,0)","v":0}]
[null,"Coordination Meetings with Key Agencies"]
[null,"       Development or Updates of Meeting Materials *","LS",1,{"$f":"SUM(E42:E44)","v":0},{"$f":"SUM(F42:F44)","v":0}]
[null,"               Presentation *","LS",1,0,{"$f":"ROUND(D42*E42,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D43*E43,0)","v":0}]
[null,"                Exhibits *","LS",1,0,0]
[null,"       Participation and notes","LS",1,{"$f":"SUM(E46:E47)","v":0},{"$f":"SUM(F46:F47)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D46*E46,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D47*E47,0)","v":0}]
[null,"   Corridor Workshop(s) or Public Informational Meeting(s)"]
[null,"       Development of Meeting Materials*","LS",1,{"$f":"SUM(E50:E58)","v":0},{"$f":"SUM(F50:F58)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D50*E50,0)","v":0}]
[null,"               Presentation *","LS",1,0,{"$f":"ROUND(D51*E51,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,0]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Notification Letters *","LS",1,0,0]
[null,"               Press Release/Meeting Announcements *","LS",1,0,{"$f":"ROUND(D55*E55,0)","v":0}]
[null,"                Project Summaries *","LS",1,0,0]
[null,"                Response letters *","LS",1,0,{"$f":"ROUND(D57*E57,0)","v":0}]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E60:E61)","v":0},{"$f":"SUM(F60:F61)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D60*E60,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D61*E61,0)","v":0}]
[null,"   Alternatives Public Information Meeting(s)"]
[null,"       Development of Meeting Materials*","LS",1,{"$f":"SUM(E64:E72)","v":0},{"$f":"SUM(F64:F72)","v":0}]
[null,"               Agenda*  ","LS",1,0,{"$f":"ROUND(D64*E64,0)","v":0}]
[null,"               Presentation *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Notification Letters *","LS",1,0,0]
[null,"               Press Release/Meeting Announcements *","LS",1,0,0]
[null,"                Project Summaries *","LS",1,0,0]
[null,"                Response letters *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E74:E75)","v":0},{"$f":"SUM(F74:F75)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D74*E74,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D75*E75,0)","v":0}]
[null,"   Additional Coordination and Consensus Building Meeting(s)"]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E78:E79)","v":0},{"$f":"SUM(F78:F79)","v":0}]
[null,"               Meeting preparation *","LS",1,0,{"$f":"ROUND(D78*E78,0)","v":0}]
[null,"               Create or Update Presentation *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E81:E82)","v":0},{"$f":"SUM(F81:F82)","v":0}]
[null,"               Participation","LS",1,{"$f":"0*(0+0)","v":0},{"$f":"ROUND(D81*E81,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D82*E82,0)","v":0}]
[null,"   Community / Stakeholder Forum(s)"]
[null,"       Development of Meeting Materials*","LS",1,{"$f":"SUM(E85:E93)","v":0},{"$f":"SUM(F85:F93)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D85*E85,0)","v":0}]
[null,"               Presentation *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Notification Letters *","LS",1,0,0]
[null,"               Press Release/Meeting Announcements *","LS",1,0,0]
[null,"                Project Summaries *","LS",1,0,0]
[null,"                Response letters *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E95:E96)","v":0},{"$f":"SUM(F95:F96)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D95*E95,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D96*E96,0)","v":0}]
[null,"   Environmental Forum(s)"]
[null,"       Development of Meeting Materials*","LS",1,{"$f":"SUM(E99:E107)","v":0},{"$f":"SUM(F99:F107)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D99*E99,0)","v":0}]
[null,"               Presentation *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Notification Letters *","LS",1,0,0]
[null,"               Press Release/Meeting Announcements *","LS",1,0,0]
[null,"                Project Summaries *","LS",1,0,0]
[null,"                Response letters *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E109:E110)","v":0},{"$f":"SUM(F109:F110)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D109*E109,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D110*E110,0)","v":0}]
[null,"Other Public and Agency Meetings (Specify) or informal meetings"]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E113:E115)","v":0},{"$f":"SUM(F113:F115)","v":0}]
[null,"               Presentation *","LS",1,0,{"$f":"ROUND(D113*E113,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D114*E114,0)","v":0}]
[null,"                Exhibits *","LS",1,0,0]
[null,"       Participation and notes","LS",1,{"$f":"SUM(E117:E118)","v":0},{"$f":"SUM(F117:F118)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D117*E117,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D118*E118,0)","v":0}]
[null,"3.2 Scheduled Public Meetings Total",null,null,null,{"$f":"SUM(F112,F116,F108,F98,F94,F84,F80,F77,F73,F63,F59,F49,F41,F45,F37,F33,F29,F21)","v":0}]
[3.3,"Public Hearing"]
[null,"       Public Hearing Materials","LS",1,{"$f":"SUM(E122:E141)","v":0},{"$f":"SUM(F122:F141)","v":0}]
[null,"               Public Officials and Regulatory Agency Letters *","LS",1,0,{"$f":"ROUND(D122*E122,0)","v":0}]
[null,"               Property Owner Letters *","LS",1,0,0]
[null,"               Public Hearing Notices and publication in the FAR *","LS",1,0,{"$f":"ROUND(D124*E124,0)","v":0}]
[null,"               Notification on the Department's Public Notice webpages through the District PIO *","LS",1,0,0]
[null,"               Identify website(s) and/or locations for document public availability *","LS",1,0,{"$f":"ROUND(D126*E126,0)","v":0}]
[null,"               Presentation with Script *","LS",1,0,0]
[null,"              Proposed typical sections and aerials *","LS",1,0,{"$f":"ROUND(D128*E128,0)","v":0}]
[null,"              Hard copies of technical reports and Environmental Documents","LS",1,0,0]
[null,"               Meeting Location Signs *","LS",1,0,0]
[null,"               Brochures or handouts *","LS",1,0,0]
[null,"              Title VI compliance signs *","LS",1,0,0]
[null,"              NEPA Assignment compliance signs *","LS",1,0,0]
[null,"               Security","LS",1,0,0]
[null,"               Advertisements *","LS",1,0,0]
[null,"               Press Releases *","LS",1,0,{"$f":"ROUND(D136*E136,0)","v":0}]
[null,"               Meeting Site Selection","LS",1,0,0]
[null,"               Written Responses to Comments *","LS",1,0,0]
[null,"               Transcript, errata sheet and certification *","LS",1,0,0]
[null,"               Arrange for Court Reporter","LS",1,0,{"$f":"ROUND(D140*E140,0)","v":0}]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",1,{"$f":"SUM(E143)","v":0},{"$f":"SUM(F143)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D143*E143,0)","v":0}]
[null,"3.3 Public Hearing Total",null,null,null,{"$f":"SUM(F142,F121)","v":0}]
[3.4,"Comments and Coordination Report *","LS",1,0,{"$f":"ROUND(D145*E145,0)","v":0}]
[3.5,"Notification of Approved Environmental Document *","LS",1,0,{"$f":"ROUND(D146*E146,0)","v":0}]
[3.6,"Additional Public Involvement Requirements"]
[null,"               General Public Correspondence *","LS",1,0,{"$f":"ROUND(D148*E148,0)","v":0}," "]
[null,"               News Letters, Fact Sheets, Preparation / Distribution *","LS",1,0,0]
[null,"               Frequently Asked Questions (FAQs) *","LS",1,0,{"$f":"ROUND(D150*E150,0)","v":0}]
[null,"               Videos, Renderings, Fly-through, 3-D Visualization *","LS",1,0,0]
[null,"               Design Charrettes *","LS",1,0,{"$f":"ROUND(D152*E152,0)","v":0}]
[null,"               Other *","LS",1,0,0]
[null,"3.6 Additional Public Involvement Requirements Total",null,null,null,{"$f":"SUM(F148:F153)","v":0}]
["Public Involvement Subtotal",null,null,null,null,{"$f":"SUM(F154,F146,F145,F144,F119,F18)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F148:F153,F146,F145,F122:F128,F112,F130:F133,F135:F136,F138:F139,F141,F98,F84,F77,F63,F49,F41,F33,F21,F12)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E157*F156,0)","v":0}]
["PUBLIC INVOLVEMENT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F155,F157)","v":0}]

{"sheet":"4. ENG ANALYSIS & REPORTS","index":10,"n_rows":137,"n_cols":7,"rows_kept":137,"cut":false,"hidden":false,"merged":[[104,1,104,5],[53,1,53,5],[26,1,26,5],[20,1,20,4],[15,1,15,5],[91,1,91,5],[43,1,43,4],[52,1,52,4],[56,1,56,4],[74,1,74,5],[69,1,69,5],[57,1,57,5],[66,1,66,4],[73,1,73,4],[136,0,136,4],[133,0,133,4],[85,1,85,4],[102,1,102,4],[111,1,111,4],[115,1,115,4],[134,1,134,4],[112,1,112,5],[108,1,108,5],[96,1,96,5],[87,1,87,5],[90,1,90,4],[95,1,95,4],[116,1,116,5],[132,1,132,4],[107,1,107,4],[9,0,9,6],[21,1,21,5],[46,1,46,5],[25,1,25,4],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[11,1,11,5],[14,1,14,4]]}
["Estimator:",null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[]
["Representing",null,"Print Name",null,null,null,"Signature / Date"]
[]
[]
["NOTE: Signature Block is optional, per District preference"]
[]
["Task\nNo.","Task","Units","# of Units","Hours / Unit","Hours","Comments"]
["NOTE:  * subject to QC"]
[4.0999999999999996,"Review of Previous Studies","LS",1,0,{"$f":"ROUND((E11*D11),0)","v":0}]
[4.2,"Existing Conditions Analysis"]
[null,"       Data Collection","LS",1,0,{"$f":"ROUND((E13*D13),0)","v":0}]
[null,"       Field Review","LS",1,0,{"$f":"ROUND((E14*D14),0)","v":0}]
[null,"4.2 Existing Conditions Analysis Total",null,null,null,{"$f":"SUM(F13:F14)","v":0}]
[4.3,"Survey"]
[null,"     4.3.1 Survey Design *","LS",1,0,{"$f":"ROUND((E17*D17),0)","v":0}]
[null,"               Survey Coordination","LS",1,0,{"$f":"ROUND((E18*D18),0)","v":0}]
[null,"     4.3.2 Photogrammetry *","LS",1,0,{"$f":"ROUND((E19*D19),0)","v":0}]
[null,"               Aerial Photography","LS",1,0,{"$f":"ROUND((E20*D20),0)","v":0}]
[null,"4.3 Survey Total",null,null,null,{"$f":"SUM(F17:F20)","v":0}]
[4.4000000000000004,"Geotechnical Investigation"]
[null,"     Soils","LS",1,0,{"$f":"ROUND((E23*D23),0)","v":0}]
[null,"     Geotechnical Coordination","LS",1,0,{"$f":"ROUND((E24*D24),0)","v":0}]
[null,"     Geotechnical Design Services *  ","LS",1,0,{"$f":"ROUND((E25*D25),0)","v":0}]
[null,"4.4 Geotechnical Investigation Total",null,null,null,{"$f":"SUM(F23:F25)","v":0}]
[4.5,"Traffic Analysis"]
[null,"     4.5.1 Traffic Analysis Methodology *","LS",1,0,{"$f":"ROUND((E28*D28),0)","v":0}]
[null,"     4.5.2 Traffic Counts * ","LS",1,0,0]
[null,"     4.5.3 Vehicle Class. Counts on Roadway Segments and Ramps * ","LS",1,0,0]
[null,"     4.5.4 Pedestrian, Bicycle, and Other Multimodal Data * ","LS",1,0,0]
[null,"     4.5.5 Calibration and Validation Data * ","LS",1,0,0]
[null,"     4.5.6 Existing Traffic Operational Analysis * ","LS",1,0,0]
[null,"     4.5.7 Model Calibration and Validation * ","LS",1,0,0]
[null,"     4.5.8 Future Demand Forecasting * ","LS",1,0,0]
[null,"     4.5.9 No-Build Analysis * ","LS",1,0,0]
[null,"     4.5.10 Development and Screening of Alternatives * ","LS",1,0,0]
[null,"     4.5.11 Operational Evaluation of Build Alternatives * ","LS",1,0,0]
[null,"     4.5.12 Project Traffic Analysis Report * ","LS",1,0,0]
[null,"     4.5.13 Interchange Access Request * ","LS",1,0,0]
[null,"     4.5.14 Traffic Data for Noise Study * ","EA",0,0,0]
[null,"     4.5.15 Traffic Data for Air Quality Analysis * ","EA",0,0,0]
[null,"     4.5.16 Signalization Analysis * ","LS",1,0,0]
[null,"4.5 Traffic Analysis Total",null,null,null,{"$f":"SUM(F28:F43)","v":0}]
[4.5999999999999996,"Signage *","LS",1,0,{"$f":"ROUND((E45*D45),0)","v":0}]
[4.7,"Tolling Concepts *","LS",1,0,{"$f":"ROUND((E46*D46),0)","v":0}]
[4.8,"Safety"]
[null,"     4.8.1 Crash Data *","LS",1,0,{"$f":"ROUND((E48*D48),0)","v":0}]
[null,"     4.8.2 Safety Analysis "]
[null,"               Historical Crash Analysis *","LS",1,0,{"$f":"ROUND((E50*D50),0)","v":0}]
[null,"               HSM Safety Analysis *","LS",1,0,{"$f":"ROUND((E51*D51),0)","v":0}]
[null,"     4.8.3 Documentation of Safety Analysis *","LS",1,0,{"$f":"ROUND((E52*D52),0)","v":0}]
[null,"4.8 Safety Total",null,null,null,{"$f":"SUM(F48:F52)","v":0}]
[4.9000000000000004,"Utilities and Railroads"]
[null,"     4.9.1 Utilities *","EA",1,0,{"$f":"ROUND((E55*D55),0)","v":0}]
[null,"    4.9.2  Railroad *","EA",1,0,{"$f":"ROUND((E56*D56),0)","v":0}]
[null,"4.9 Utilities and Railroads Total",null,null,null,{"$f":"SUM(F55:F56)","v":0}]
["4.10","Roadway Analysis"]
[null,"     4.10.1 Design Controls and Criteria *","LS",1,0,{"$f":"ROUND((E59*D59),0)","v":0}]
[null,"     4.10.2 Typical Section Analysis *","EA",0,0,0]
[null,"     4.10.3 Geometric Design*","LS",1,0,0]
[null,"     4.10.4 Intersections and Interchange Evaluation *","EA",0,0,0]
[null,"     4.10.5 Access Management *","LS",1,0,0]
[null,"     4.10.6 Multimodal Accommodations *","LS",1,0,0]
[null,"     4.10.7 Maintenance of Traffic *","LS",1,0,0]
[null,"     4.10.8 Lighting *","LS",1,0,0]
[null,"4.10 Roadway Total",null,null,null,{"$f":"SUM(F59:F66)","v":0}]
[4.1100000000000003,"Identify Construction Segments *","LS",1,0,{"$f":"ROUND((E68*D68),0)","v":0}]
[4.12,"Transportation Systems Management and Operations *","LS",1,0,{"$f":"ROUND((E69*D69),0)","v":0}]
[4.13,"Structures "]
[null,"     4.13.1 Existing Structures*","EA",0,0,{"$f":"ROUND((E71*D71),0)","v":0}]
[null,"     4.13.2 Structure Typical Sections *","EA",0,0,{"$f":"ROUND((E72*D72),0)","v":0}]
[null,"     4.13.3 Structure Design Alternatives *","EA",0,0,{"$f":"ROUND((E73*D73),0)","v":0}]
[null,"4.13 Structures Total",null,null,null,{"$f":"SUM(F71:F73)","v":0}]
[4.1399999999999997,"Drainage"]
[null,"     4.14.1 Floodplain and Environmental Permit Data Collection *","LS",1,0,{"$f":"ROUND((E76*D76),0)","v":0}]
[null,"     4.14.2 Drainage Analysis *","Per Basin",0,0,{"$f":"ROUND((E77*D77),0)","v":0}]
[null,"     4.14.3 Floodplain Compensation Analysis *","Per Encroach.",0,0,0]
[null,"     4.14.4 Stormwater Management Analysis "]
[null,"               Enviro. Look Around (ELA) Meeting and Pond Siting Meeting","LS",1,0,{"$f":"ROUND((E80*D80),0)","v":0}]
[null,"               Stormwater Management *","Per Basin",0,0,{"$f":"ROUND((E81*D81),0)","v":0}]
[null,"               Pond Siting Report or Conceptual Drainage Design Report*","LS",1,0,0]
[null,"     4.14.5 Drainage Design *","LS",1,0,0]
[null,"    4.14.6 Location Hydraulic Report *","LS",1,0,0]
[null,"    4.14.7 Bridge Hydraulic Evaluation*","EA",0,0,0]
[null,"4.14 Drainage Total",null,null,null,{"$f":"SUM(F76:F85)","v":0}]
[4.1500000000000004,"Landscaping Analysis *","LS",1,0,{"$f":"ROUND((E87*D87),0)","v":0}]
[4.16,"Construction and Right of Way Cost Estimates "]
[null,"     4.16.1 Construction Cost Estimates *","LS",1,0,{"$f":"ROUND((E89*D89),0)","v":0}]
[null,"     4.16.2 Right of Way Cost Estimates *","LS",1,0,0]
[null,"4.16 Construction and Right of Way Cost Estimates Total",null,null,null,{"$f":"SUM(F89:F90)","v":0}]
[4.17,"Alternatives Evaluation "]
[null,"     4.17.1 Comparative Alternatives Evaluation *","LS",1,0,{"$f":"ROUND((E93*D93),0)","v":0}]
[null,"     4.17.2 Selection of Recommended Alternative *","LS",1,0,{"$f":"ROUND((E94*D94),0)","v":0}]
[null,"     4.17.3 Value Engineering *","LS",1,0,{"$f":"ROUND((E95*D95),0)","v":0}]
[null,"4.17 Alternatives Evaluation Total",null,null,null,{"$f":"SUM(F93:F95)","v":0}]
[4.18,"Concept Plans "]
[null,"     4.18.1 Base Map *","Sheet",1,0,{"$f":"ROUND((E98*D98),0)","v":0}]
[null,"     4.18.2 Alternatives Concept Plans *","Sheet",0,0,{"$f":"ROUND((E99*D99),0)","v":0}]
[null,"     4.18.3 Preferred Alternative *","Sheet",0,0,{"$f":"ROUND((E100*D100),0)","v":0}]
[null,"     4.18.4 Typical Section Package *","LS",1,0,{"$f":"ROUND((E101*D101),0)","v":0}]
[null,"     4.18.5 Design Exceptions and Design Variations *","EA",0,0,{"$f":"ROUND((E102*D102),0)","v":0}]
[null,"4.18 Concept Plans Total",null,null,null,{"$f":"SUM(F98:F102)","v":0}]
[4.1900000000000004,"Transportation Management Plan  *","LS",1,0,{"$f":"ROUND((E104*D104),0)","v":0}]
[4.2,"Risk Management"]
[null,"     Meeting Materials*","LS",1,0,{"$f":"ROUND((E106*D106),0)","v":0}]
[null,"     Meeting Participation","LS",1,0,{"$f":"ROUND((E107*D107),0)","v":0}]
[null,"4.20 Risk Management Total",null,null,null,{"$f":"SUM(F106:F107)","v":0}]
[4.21,"Engineering Analysis Documentation "]
[null,"     Draft Engineering Analysis Documentation*","LS",1,0,{"$f":"ROUND((E110*D110),0)","v":0}]
[null,"     Final Engineering Analysis Documentation *","LS",1,0,{"$f":"ROUND((E111*D111),0)","v":0}]
[null,"4.21 Engineering Analysis Documentation Total",null,null,null,{"$f":"SUM(F110:F111)","v":0}]
[4.22,"Planning Consistency"]
[null,"     4.22.1 Transportation Plans ","LS",1,0,{"$f":"ROUND((E114*D114),0)","v":0}]
[null,"     4.22.2 Planning Consistency Form  *","LS",1,0,{"$f":"ROUND((E115*D115),0)","v":0}]
[null,"4.22 Planning Consistency Total",null,null,null,{"$f":"SUM(F114:F115)","v":0}]
[4.2300000000000004,"Transit Systems and Service"]
[null,"     4.23.1 Transit Concepts and Alternatives"]
[null,"               Review of Transit Concepts and Alternatives Report (TCAR)","LS",1,0,{"$f":"ROUND((E119*D119),0)","v":0}]
[null,"               Review of Bicycle/Greenway plans","LS",1,0,{"$f":"ROUND((E120*D120),0)","v":0}]
[null,"               Develop Transit Concepts and Alternatives Report *","LS",1,0,0]
[null,"     4.23.2 Existing and Planned Transit Infrastructure and Services *","LS",1,0,{"$f":"ROUND((E122*D122),0)","v":0}]
[null,"     4.23.3 Connectivity and Accessibility *","LS",1,0,{"$f":"ROUND((E123*D123),0)","v":0}]
[null,"     4.23.4 Transit Operational Analysis * ","LS",1,0,{"$f":"ROUND((E124*D124),0)","v":0}]
[null,"     4.23.5 Ridership and Revenue Estimations "]
[null,"               Ridership and Revenue Forecasts *","LS",1,0,{"$f":"ROUND((E126*D126),0)","v":0}]
[null,"               Operating and Ridership Sensitivity Testing *","LS",1,0,0]
[null,"               Ridership and Revenue Results Documentation *","LS",1,0,0]
[null,"     4.23.6 Transit Cost Estimates and Financial Commitments *","LS",1,0,0]
[null,"     4.23.7 Proposed Transit Service and Operations Plan * ","LS",1,0,0]
[null,"     4.23.8 Transit Infrastructure Alternatives * ","LS",1,0,0]
[null,"     4.23.9 Constructability Review * ","LS",1,0,0]
[null,"4.23 Transit Systems, Service, and Design Total",null,null,null,{"$f":"SUM(F119:F132)","v":0}]
["Engineering Analysis and Report Subtotal",null,null,null,null,{"$f":"SUM(F133,F116,F112,F108,F104,F103,F96,F91,F87,F86,F74,F69,F68,F67,F57,F53,F46,F45,F44,F26,F21,F15,F11)","v":0}]
[null,"Hours Subject to QC",null,null,null,{"$f":"SUM(F129:F132,F126:F128,F124,F123,F121:F122,F115,F112,F106,F104,F103,F96,F91,F87,F85,F84,F83,F82,F81,F78,F77,F76,F74,F69,F68,F67,F57,F53,F46,F45,F44,F25,F19,F17)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E136*F135,0)","v":0}]
["ENGINEERING ANALYSIS AND REPORT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F134,F136)","v":0}]

{"sheet":"5. ENVIRON. ANALYSIS & REPORTS","index":11,"n_rows":87,"n_cols":7,"rows_kept":87,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[83,0,83,4],[86,0,86,4],[84,0,84,4],[10,0,10,6],[11,1,11,5],[22,1,22,4],[23,1,23,5],[40,1,40,4],[58,1,58,4],[59,1,59,5],[80,1,80,4],[41,1,41,5]]}
["Estimator:",null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[]
["Representing",null,"Print Name",null,null,null,"Signature / Date"]
[]
[]
["NOTE: Signature Block is optional, per District preference"]
[]
["Task\nNo.","Task","Units","# of Units","Hours / Unit","Hours","Comments"]
[]
["NOTE:  * subject to QC"]
[5.0999999999999996,"Sociocultural Effects"]
[null,"     5.1 Sociocultural Effects Evaluation or Report  *","LS",1,0,{"$f":"ROUND((E13*D13),0)","v":0}]
[null,"     5.1.1 Social  *","LS",1,0,0]
[null,"     5.1.2 Economic  *","LS",1,0,0]
[null,"     5.1.3 Land Use Changes  *","LS",1,0,0]
[null,"     5.1.4 Mobility  *","LS",1,0,{"$f":"ROUND((E17*D17),0)","v":0}]
[null,"               Transit Only  *","LS",1,0,0]
[null,"     5.1.5 Aesthetics  *","LS",1,0,{"$f":"ROUND((E19*D19),0)","v":0}]
[null,"     5.1.6 Relocation Potential"]
[null,"               Review and Impact Determination  *","LS",1,0,0]
[null,"               Conceptual Stage Relocation Plan (CSRP)  *","LS",1,0,{"$f":"ROUND((E22*D22),0)","v":0}]
[null,"5.1 Sociocultural Effects Total",null,null,null,{"$f":"SUM(F13:F22)","v":0}]
[5.2,"Cultural Resources"]
[null,"               Research Design and Survey Methodology *","LS",1,0,{"$f":"ROUND((E25*D25),0)","v":0}]
[null,"     5.2.1 Archaeological and Historic Resources"]
[null,"               Cultural Resource Assessment Survey (CRAS) *","LS",1,0,{"$f":"ROUND((E27*D27),0)","v":0}]
[null,"               CRAS Addendum or Technical Memo. for Pond Sites *","LS",1,0,0]
[null,"               Determination of Eligibility (DOE) As Required","LS",1,0,0]
[null,"               Case Study Report *","LS",1,0,0]
[null,"               Memorandum of Agreement (MOA) *","LS",1,0,0]
[null,"               Section 4(f) Evaluation for Historic Resources *","LS",1,0,0]
[null,"               Section 106 Consultation Meetings","LS",1,0,0]
[null,"               Native American Coordination Meeting","LS",1,0,0]
[null,"               Section 106 Public Involvement","LS",1,0,0]
[null,"               Florida Master Site File Form*","LS",1,0,{"$f":"ROUND((E36*D36),0)","v":0}]
[null,"     5.2.2 Recreational, Section 4(f) *"]
[null,"               Section 4(f) Determination of Applicability *","EA",0,0,{"$f":"ROUND((E38*D38),0)","v":0}]
[null,"               Section 4(f) \"de minimis\" documentation *","EA",0,0,0]
[null,"               Section 4(f) Evaluation *","EA",0,0,0]
[null,"5.2 Cultural Resources Total",null,null,null,{"$f":"SUM(F25:F40)","v":0}]
[5.3,"Natural Resources"]
[null,"     5.3.1 Wetlands"]
[null,"               Wetlands - Data Collection","LS",1,0,{"$f":"ROUND((E44*D44),0)","v":0}]
[null,"               Wetlands - Evaluation *","LS",1,0,0]
[null,"     5.3.2 Essential Fish Habitat"]
[null,"               Essential Fish Habitat - Data Collection","LS",1,0,{"$f":"ROUND((E47*D47),0)","v":0}]
[null,"               Essential Fish Habitat Assessment *","LS",1,0,0]
[null,"     5.3.3 Wildlife and Habitat"]
[null,"              Data Collection","LS",1,0,{"$f":"ROUND((E50*D50),0)","v":0}]
[null,"              Specific Survey and Consultation","LS",1,0,0]
[null,"              Analysis  *","LS",1,0,0]
[null,"              Conservation Measures and Mitigation Plan *","LS",1,0,{"$f":"ROUND((E53*D53),0)","v":0}]
[null,"     5.3.4 Natural Resource Evaluation (NRE) Report *","LS",1,0,{"$f":"ROUND((E54*D54),0)","v":0}]
[null,"     5.3.5 Water Quality *","LS",1,0,{"$f":"ROUND((E55*D55),0)","v":0}]
[null,"     5.3.6 Special Designations *","LS",1,0,{"$f":"ROUND((E56*D56),0)","v":0}]
[null,"     5.3.7 Identify Permit Needs *","LS",1,0,{"$f":"ROUND((E57*D57),0)","v":0}]
[null,"     5.3.8 Farmland *","LS",1,0,{"$f":"ROUND((E58*D58),0)","v":0}]
[null,"5.3 Natural Resources Total",null,null,null,{"$f":"SUM(F44:F58)","v":0}]
[5.4,"Physical Effects"]
[null,"     5.4.1 Noise"]
[null,"              Methodology Meeting","LS",1,0,{"$f":"ROUND((E62*D62),0)","v":0}]
[null,"              Data Collection","LS",1,0,0]
[null,"              Land Use Field Review/Outdoor Advertising Identification","LS",1,0,0]
[null,"              Field Measurement and Model Validation *","LS",1,0,0]
[null,"              Outdoor Advertising Identification","LS",1,0,{"$f":"ROUND((E66*D66),0)","v":0}]
[null,"              Construction Noise and Vibration Assessment *","LS",1,0,{"$f":"ROUND((E67*D67),0)","v":0}]
[null,"              Analysis and Noise Abatement Evaluation *","EA",0,0,0]
[null,"              Noise Report *","LS",1,0,0]
[null,"     5.4.2 Transit Noise and Vibration Analysis *","LS",1,0,{"$f":"ROUND((E70*D70),0)","v":0}]
[null,"     5.4.3 Air Quality"]
[null,"              Data Collection","LS",1,0,{"$f":"ROUND((E72*D72),0)","v":0}]
[null,"              Screening Analysis *","LS",1,0,{"$f":"ROUND((E73*D73),0)","v":0}]
[null,"              Air Quality Modeling * ","LS",1,0,{"$f":"ROUND((E74*D74),0)","v":0}]
[null,"              Air Quality Technical Memorandum * ","LS",1,0,{"$f":"ROUND((E75*D75),0)","v":0}]
[null,"             Mobile Air Toxics Analysis * ","LS",1,0,{"$f":"ROUND((E76*D76),0)","v":0}]
[null,"     5.4.4 Construction Impact Analysis *","LS",1,0,{"$f":"ROUND((E77*D77),0)","v":0}]
[null,"     5.4.5 Contamination"]
[null,"              Field Data","LS",1,0,{"$f":"ROUND((E79*D79),0)","v":0}]
[null,"              Analysis and Report  *","LS",1,0,{"$f":"ROUND((E80*D80),0)","v":0}]
[null,"5.4 Physical Effects Total",null,null,null,{"$f":"SUM(F62:F80)","v":0}]
[5.5,"Cumulative Effects Evaluation *","EA",0,0,{"$f":"ROUND((E82*D82),0)","v":0}]
[5.6,"Project Commitments Record *","LS",1,0,{"$f":"ROUND((E83*D83),0)","v":0}]
["Environmental Analysis and Report Subtotal",null,null,null,null,{"$f":"SUM(F81:F83,F59,F41,F23)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F82:F83,F80,F77,F73:F76,F70,F69,F68,F67,F65,F54:F58,F52:F53,F48:F48,F45,F38:F40,F36,F32,F31,F30,F28,F27,F25,F21:F22,F13:F19)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E86*F85,0)","v":0}]
["ENVIRONMENTAL ANALYSIS AND REPORT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F86+F84)","v":0}]

{"sheet":"6. ENVIRONMENTAL DOCUMENT","index":12,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,0,21,4],[23,0,23,4],[20,0,20,4],[10,0,10,6],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5]]}
["Estimator:",null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[]
["Representing",null,"Print Name",null,null,null,"Signature / Date"]
[]
[]
["NOTE: Signature Block is optional, per District preference"]
[]
["Task\nNo.","Task","Units","# of Units","Hours / Unit","Hours","Comments"]
[]
["NOTE:  * subject to QC"]
[6,"Environmental Document"]
[null,"     Categorical Exclusion Type 2 *","LS",1,0,{"$f":"ROUND((E13*D13),0)","v":0}]
[null,"     Environmental Assessment *","LS",1,0,{"$f":"ROUND((E14*D14),0)","v":0}]
[null,"     Finding of No Significant Impact (FONSI) *","LS",1,0,{"$f":"ROUND((E15*D15),0)","v":0}]
[null,"     Draft Environmental Impact Statement (DEIS) *","LS",1,0,{"$f":"ROUND((E16*D16),0)","v":0}]
[null,"     Final Environmental Impact Statement (FEIS) *","LS",1,0,{"$f":"ROUND((E17*D17),0)","v":0}]
[null,"     Record of Decision (ROD) *","LS",1,0,{"$f":"ROUND((E18*D18),0)","v":0}]
[null,"     Combined FEIS/ROD  *","LS",1,0,{"$f":"ROUND((E19*D19),0)","v":0}]
[null,"     State Environmental Impact Report  *","LS",1,0,{"$f":"ROUND((E20*D20),0)","v":0}]
["Environmental Document Subtotal",null,null,null,null,{"$f":"SUM(F13:F20)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F13:F20)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(F22*E23,0)","v":0}]
["ENVIRONMENTAL DOCUMENT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F23+F21)","v":0}]

{"sheet":"8. DESIGN SERVICES","index":13,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[10,0,10,4],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5]]}
["Estimator:",null,null,null,null,null,{"$f":"'PROJECT DATA'!C8","v":"Enter project name and description"}]
[null,null,null,null,null,null,{"$f":"'PROJECT DATA'!F4","v":"123456-7-89-10"}]
[]
["Representing",null,"Print Name",null,null,null,"Signature / Date"]
[]
[]
["NOTE: Signature Block is optional, per District preference"]
[]
["Task\nNo.","Task","Units","# of Units","Hours / Unit","Hours","Comments"]
[8,"Design Services","LS",1,0,{"$f":"SUM(D10*E10)","v":0}]
["DESIGN SERVICES TOTAL HOURS",null,null,null,null,{"$f":"F10","v":0}]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[]
[null,null," "]
[]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[]
[]
[]
[null,null," "]
[null,null," "]
[null,null," "]
[]
[null,null," "]
[null,null," "]
[null,null," "]
[]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "," "," "," "," "]