{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Title","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 ANALYSES & CONSIDERATION","5. ENV ANALYSIS & REPORTS","6. ENVIRONMENTAL DOCUMENT"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":34,"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":"Title","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FDOT STAFF HOUR ESTIMATION"]
["WORKSHEET PACKAGE"]
[]
["PD&E STANDARD SCOPE OF SERVICES"]
[]
[]
["February 2024"]
["File Version: 2024.01"]

{"sheet":"PROJECT DATA","index":1,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["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'!F35","v":0}]
[null,null,"3.0 PUBLIC INVOLVEMENT",null,null,null,null,null,null,{"$f":"'3. PUBLIC INVOLVEMENT'!F200","v":0}]
[null,null,"4.0 ENGINEERING ANALYSIS AND CONSIDERATIONS",null,null,null,null,null,null,{"$f":"'4. ENG ANALYSES & CONSIDERATION'!F123","v":0}]
[null,null,"5.0 ENVIRONMENTAL ANALYSIS AND REPORTS",null,null,null,null,null,null,{"$f":"'5. ENV ANALYSIS & REPORTS'!F103","v":0}]
[null,null,"6.0 ENVIRONMENTAL DOCUMENT",null,null,null,null,null,null,{"$f":"'6. ENVIRONMENTAL DOCUMENT'!F28","v":0}]
[]
[null,null,"PROJECT TOTAL  HOURS",null,null,null,null,null,null,{"$f":"SUM(J24:J28)","v":0}]

{"sheet":"Summary","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["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 Analyses and Considerations",{"$f":"'PROJECT DATA'!J26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"Environmental Analysis and 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]
["Project Total",null,{"$f":"SUM(C5:C9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,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":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["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":"2024-02-26"},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*C32,0)","v":0},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*C33,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 Analyses and Considerations"},{"$f":"Summary!P7","v":0},{"$f":"ROUND($B15*C34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B8","v":"Environmental Analysis and Reports"},{"$f":"Summary!P8","v":0},{"$f":"ROUND($B16*C35,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*C36,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTALS ",{"$f":"SUM(B13:B17)","v":0},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," (Prime Consultant)",null,{"$f":"O18","v":0},{"$f":"P18","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":"2024-02-26"},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"},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(C32:N32)","v":1}]
["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]
["Engineering Analyses and Considerations",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]
["Environmental Analysis and 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]
["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]
[]
["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":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,1,10,1]]}
["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":"2024-02-26"},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 \nTotal",{"$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"]
[]
[" ","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*C32,0)","v":0},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*C33,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B7","v":"Engineering Analyses and Considerations"},{"$f":"Summary!C7","v":0},{"$f":"ROUND($B15*C34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B8","v":"Environmental Analysis and Reports"},{"$f":"Summary!C8","v":0},{"$f":"ROUND($B16*C35,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*C36,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTALS ",{"$f":"SUM(B13:B17)","v":0},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":"O18","v":0},{"$f":"P18","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":"2024-02-26"},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"},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C32:N32)","v":0}]
["Public Involvement",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Engineering Analyses and Considerations",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Environmental Analysis and 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]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Fee Sheet - Prime","index":5,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["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":"2024-02-26T07:26:21.620"}]
["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},{"$f":"ROUND(+P11/O11,2)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Summary!B7","v":"Engineering Analyses and Considerations"},{"$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,{"$f":"ROUND(+P12/O12,2)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Summary!B8","v":"Environmental Analysis and 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!"}]
["Total Staff Hours",{"$f":"SUM(B10:B14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Staff Cost",null,{"$f":"C15*C9","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(P10:P14),2)","v":0},{"$f":"ROUND(SUM(+P16/O15),2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check =",{"$f":"SUM(C16:N16)","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":"P16","v":0}]
[null,null,null,null,null,null,null,null,null,null,"OVERHEAD: ",null,null,0,null,null,{"$f":"ROUND(Q$18*N19,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$18*N20,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$18*N21,2)","v":0}]
[null,"Notes:",null,null,null,null,null,null,null,null,"EXPENSES:",null,null,0,null,null,{"$f":"ROUND(Q$18*N22,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(Q18:Q22),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(O24*M24,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":"Q23+Q24","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(Q25:Q37),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(Q38:Q39)","v":0}]

{"sheet":"Fee Sheet - Sub","index":6,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["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":"2024-02-26T07:26:21.620"}]
["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,{"$f":"ROUND(+P11/O11,2)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Staff Hour Summary - Firm'!A15","v":"Engineering Analyses and Considerations"},{"$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 and 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!"}]
["Total Staff Hours",{"$f":"SUM(B10:B14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Staff Cost",null,{"$f":"C15*C9","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(P10:P14),2)","v":0},{"$f":"ROUND(SUM(+P16/O15),2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check =",{"$f":"SUM(C16:N16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SALARY RELATED COSTS:",null,null,null,null,null,{"$f":"P16","v":0}]
[null,null,null,null,null,null,null,null,null,null,"OVERHEAD: ",null,null,0,null,null,{"$f":"ROUND(Q$18*N19,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"OPERATING MARGIN:",null,null,0,null,null,{"$f":"ROUND(Q$18*N20,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$18*N21,2)","v":0}]
[null,"Note:",null,null,null,null,null,null,null,null,"EXPENSES:",null,null,0,null,null,{"$f":"ROUND(Q$18*N22,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(Q18:Q22),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(O24*M24,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SUBTOTAL - SUBCONSULTANT",null,null,null,null,null,{"$f":"Q23+Q24","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(Q25:Q26)","v":0}]

{"sheet":"CITS Output","index":7,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["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'!C18","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'!D18","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'!E18","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'!F18","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'!G18","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'!H18","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'!I18","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'!J18","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'!K18","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'!L18","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'!M18","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'!N18","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":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[[64,0,65,0],[31,0,31,4],[32,0,32,4],[34,0,34,4],[61,0,63,0],[42,0,44,0],[39,0,41,0],[46,0,60,0]]}
["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"]
[""]
["2.0","PROJECT DESCRIPTION AND OBJECTIVES"]
[2.2000000000000002,"Project Requirements and Provisions for Work"]
[null,"     2.2.6 Meetings and Presentations","LS",null,null,{"$f":"F74","v":0},"see table below"]
[null,"     2.2.7 Communication","LS",1,0,{"$f":"ROUND((E14*D14),0)","v":0}]
[null,"     2.2.9 Schedule*","LS",1,0,{"$f":"ROUND((E15*D15),0)","v":0}]
[null,"     2.2.10 Submittals","LS",1,0,{"$f":"ROUND((E16*D16),0)","v":0}]
[null,"2.2 Project Requirements and Provisions Work Total",null,null,null,{"$f":"SUM(F13:F16)","v":0}]
[2.2999999999999998,"Coordination with Other Consultants and Entities","LS",1,0,{"$f":"ROUND(D18*E18,0)","v":0}]
[2.4,"Contract Management","LS",1,0,{"$f":"ROUND(D19*E19,0)","v":0}]
[2.5,"Additional Services"]
[null,"     2.5.1 Alternative Corridor Evaluation*","LS",1,0,{"$f":"ROUND((E21*D21),0)","v":0}]
[null,"     2.5.2 Advance Notification"]
[null,"               Advance Notification*","LS",1,0,{"$f":"ROUND((E23*D23),0)","v":0}]
[null,"               Preliminary Environmental Discussion*","LS",1,0,{"$f":"ROUND((E24*D24),0)","v":0}]
[null,"     2.5.3 Scoping (EIS Only)"]
[null,"               Set up/Scoping Package*","LS",1,0,{"$f":"ROUND((E26*D26),0)","v":0}]
[null,"               Participation and notes","LS",1,0,{"$f":"ROUND((E27*D27),0)","v":0}]
[null,"     2.5.4 Notice of Intent (EIS Only)*","LS",1,0,{"$f":"ROUND((E28*D28),0)","v":0}]
[null,"     2.5.5 Miscellaneous Services*","LS",1,0,{"$f":"ROUND((E29*D29),0)","v":0}]
[null,"2.5 Additional Services Total",null,null,null,{"$f":"SUM(F21:F29)","v":0}]
[2.7,"Optional Services","LS",1,0,{"$f":"ROUND(D31*E31,0)","v":0}]
["Project Description and Objectives Subtotal",null,null,null,null,{"$f":"SUM(F30:F31,F19,F18,F17)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F15,F21,F23,F24,F26,F28,F29)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E34*F33,0)","v":0}]
["PROJECT DESCRIPTION AND OBJECTIVES TOTAL HOURS",null,null,null,null,{"$f":"SUM(F32,F34)","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":"E40*D40","v":0}]
[null,"Access Management","EA",1,0,{"$f":"E41*D41","v":0}]
[null,"Concepts","EA",1,0,0]
["Drainage","WATERSS/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":"E52*D52","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":"E64*D64","v":0}]
["Utilities and Railroad","UAO & DUO","EA",1,0,{"$f":"E65*D65","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(F40:F68)","v":0}]
[null,"Notice to Proceed","EA",1,0,{"$f":"E70*D70","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":"E73*D73","v":0}]
[null,"Total Meetings",null,null,null,{"$f":"SUM(F69:F73)","v":0},"Carry to task 2.2.6"]
[null,null," "]

{"sheet":"3. PUBLIC INVOLVEMENT","index":9,"n_rows":200,"n_cols":8,"rows_kept":200,"cut":false,"hidden":false,"merged":[[160,7,161,7],[196,0,196,4],[197,0,197,4],[199,0,199,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"]
[""]
["3.0","PUBLIC INVOLVEMENT"]
[3.1,"Public Involvement Plan Elements"]
[null,"     3.1.1 Public Involvement Plan *","LS",1,0,{"$f":"ROUND(D13*E13,0)","v":0}]
[null,"     3.1.2 Project Website and Social Media *","LS",null,null,{"$f":"SUM(F15:F16)","v":0}]
[null,"Development *","LS",1,0,{"$f":"ROUND(D15*E15,0)","v":0}]
[null,"               Maintenance *  ","LS",1,0,{"$f":"ROUND(D16*E16,0)","v":0}]
[null,"     3.1.3 Public Involvement Data Collection (incl. site selection)","LS",1,0,{"$f":"ROUND(D17*E17,0)","v":0}]
[null,"     3.1.4 Public Involvement Comment Tracking *","LS",1,0,{"$f":"ROUND(D18*E18,0)","v":0}]
[null,"3.1 Public Involvement Plan Elements Total",null,null,null,{"$f":"SUM(F13,F14,F17,F18)","v":0}]
[3.2,"Scheduled Public Meetings"]
[null,"   Scoping Meeting with Key Agencies (EIS only)"]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F23:F26)","v":0}]
[null,"Agenda *","LS",1,0,{"$f":"ROUND(D23*E23,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics) *  ","LS",1,0,{"$f":"ROUND(D24*E24,0)","v":0}]
[null,"Project Handouts *","LS",1,0,{"$f":"ROUND(D25*E25,0)","v":0}]
[null,"Exhibits *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F28:F29)","v":0}]
[null,"Participation","LS",1,0,{"$f":"ROUND(D28*E28,0)","v":0}]
[null,"Notes","LS",1,0,{"$f":"ROUND(D29*E29,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D30*E30,0)","v":0}]
[null,"   Project Kickoff Meeting"]
[null,"       Virtual / Hybrid Component ","LS",1,0,{"$f":"ROUND(D32*E32,0)","v":0}]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F34:F42)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D34*E34,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *  ","LS",1,0,{"$f":"ROUND(D35*E35,0)","v":0}]
[null,"               Project Handouts * ","LS",1,0,{"$f":"ROUND(D36*E36,0)","v":0}]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Notification Letters/Emails *","LS",1,0,0]
[null,"               Display Advertisements *","LS",1,0,{"$f":"ROUND(D39*E39,0)","v":0}]
[null,"               News Release/Fact Sheets *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,{"$f":"ROUND(D41*E41,0)","v":0}]
[null,"               Meeting Summaries *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F44:F45)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D44*E44,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D45*E45,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D46*E46,0)","v":0}]
[null,"   Presentation to Local MPOs/TPOs/TPAs (incl. Associated Technical and Citizen Committees) and Affected Local Governments"]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F49:F51)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *  ","LS",1,0,{"$f":"ROUND(D49*E49,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D50*E50,0)","v":0}]
[null,"               Exhibits *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F53:F54)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D53*E53,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D54*E54,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D55*E55,0)","v":0}]
[null,"   Coordination Meetings with Key Agencies"]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F58:F60)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *  ","LS",1,0,{"$f":"ROUND(D58*E58,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D59*E59,0)","v":0}]
[null,"               Exhibits *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F62:F63)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D62*E62,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D63*E63,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D64*E64,0)","v":0}]
[null,"   Corridor Workshop(s) or Public Informational Meeting(s)"]
[null,"       Virtual / Hybrid Component ","LS",1,0,{"$f":"ROUND(D66*E66,0)","v":0}]
[null,"       Development of Meeting Materials*","LS",null,null,{"$f":"SUM(F68:F76)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D68*E68,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *  ","LS",1,0,{"$f":"ROUND(D69*E69,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,0]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Notification Letters/Emails *","LS",1,0,0]
[null,"               Display Advertisements *","LS",1,0,0]
[null,"               News Release/Fact Sheets *","LS",1,0,{"$f":"ROUND(D74*E74,0)","v":0}]
[null,"                Meeting Summaries *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F78:F79)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D78*E78,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D79*E79,0)","v":0}]
[null,"       Response to Comments *","LS",1,{"$f":"SUM(E81:E83)","v":0},{"$f":"ROUND(D80*E80,0)","v":0}]
[null,"   Alternatives Public Information Meeting(s)"]
[null,"       Virtual / Hybrid Component ","LS",1,0,{"$f":"ROUND(D82*E82,0)","v":0}]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F84:F92)","v":0}]
[null,"               Agenda*  ","LS",1,0,{"$f":"ROUND(D84*E84,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *  ","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Notification Letters/Emails *","LS",1,0,0]
[null,"               Display Advertisements *","LS",1,0,0]
[null,"               News Release/Fact Sheets *","LS",1,0,0]
[null,"               Meeting Summaries *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F94:F95)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D94*E94,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D95*E95,0)","v":0}]
[null,"       Response to Comments *","LS",1,{"$f":"SUM(E97:E100)","v":0},{"$f":"ROUND(D96*E96,0)","v":0}]
[null,"   Additional Coordination and Consensus Building Meeting(s)"]
[null,"       Virtual / Hybrid Component ","LS",1,{"$f":"SUM(E100:E109)","v":0},{"$f":"ROUND(D98*E98,0)","v":0}]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F100:F101)","v":0}]
[null,"               Meeting preparation *","LS",1,0,{"$f":"ROUND(D100*E100,0)","v":0}]
[null,"               Create or Update Presentation *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F103:F104)","v":0}]
[null,"               Participation","LS",1,{"$f":"0*(0+0)","v":0},{"$f":"ROUND(D103*E103,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D104*E104,0)","v":0}]
[null,"       Response to Comments *","LS",1,{"$f":"SUM(E106:E109)","v":0},{"$f":"ROUND(D105*E105,0)","v":0}]
[null,"   Community / Stakeholder Forum(s)"]
[null,"       Virtual / Hybrid Component ","LS",1,{"$f":"SUM(E109:E118)","v":0},{"$f":"ROUND(D107*E107,0)","v":0}]
[null,"       Development of Meeting Materials*","LS",null,null,{"$f":"SUM(F109:F117)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D109*E109,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Notification Letters/Emails *","LS",1,0,0]
[null,"               Display Advertisements *","LS",1,0,0]
[null,"               News Release/Fact Sheets *","LS",1,0,0]
[null,"               Meeting Summaries *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F119:F120)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D119*E119,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D120*E120,0)","v":0}]
[null,"       Response to Comments *","LS",1,{"$f":"SUM(E122:E126)","v":0},{"$f":"ROUND(D121*E121,0)","v":0}]
[null,"   Environmental Forum(s)"]
[null,"       Virtual / Hybrid Component ","LS",1,{"$f":"SUM(E125:E135)","v":0},{"$f":"ROUND(D123*E123,0)","v":0}]
[null,"       Development of Meeting Materials*","LS",null,null,{"$f":"SUM(F125:F133)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D125*E125,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Notification Letters/Emails *","LS",1,0,0]
[null,"               Display Advertisements *","LS",1,0,0]
[null,"               News Release/Fact Sheets *","LS",1,0,0]
[null,"               Meeting Summaries *","LS",1,0,0]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F135:F136)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D135*E135,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D136*E136,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D137*E137,0)","v":0}]
[null,"   Other Public and Agency Meetings (Specify) or Informal Meetings"]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F140:F142)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics) *","LS",1,0,{"$f":"ROUND(D140*E140,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D141*E141,0)","v":0}]
[null,"               Exhibits *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F144:F145)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D144*E144,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D145*E145,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D146*E146,0)","v":0}]
[null,"   Local Advisory Group Meetings"]
[null,"       Virtual / Hybrid Component ","LS",1,0,{"$f":"ROUND(D148*E148,0)","v":0}]
[null,"       Development of Meeting Materials *","LS",null,null,{"$f":"SUM(F150:F152)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics) *","LS",1,0,{"$f":"ROUND(D150*E150,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,{"$f":"ROUND(D151*E151,0)","v":0}]
[null,"               Exhibits *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F154:F155)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D154*E154,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D155*E155,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D156*E156,0)","v":0}]
[null,"3.2 Scheduled Public Meetings Total",null,null,null,{"$f":"SUM(F139,F143,F134,F124,F118,F108,F102,F99,F93,F83,F77,F67,F57,F61,F52,F48,F43,F33,F156,F153,F149,F148,F121,F123,F107,F105,F96,F82,F80,F66,F55,F46,F32,F30,F27,F22,F64,F98,F137,F146)","v":0}]
[3.3,"Public Hearing",null,null,null,null,null,""]
[null,"       Virtual / Hybrid Component ","LS",1,0,{"$f":"ROUND(D159*E159,0)","v":0}]
[null,"       Public Hearing Materials","LS",null,null,{"$f":"SUM(F161:F177)","v":0}]
[null,"               Public Officials and Regulatory Agency Letters/Emails *","LS",1,0,{"$f":"ROUND(D161*E161,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(D163*E163,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(D165*E165,0)","v":0}]
[null,"               Presentation (scripts/pre-recorded/graphics/rehearsal/revisions) *","LS",1,0,0]
[null,"              Display boards and exhibits *","LS",1,0,{"$f":"ROUND(D167*E167,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,"               Newspaper Advertisements/ press releases *","LS",1,0,{"$f":"ROUND(D174*E174,0)","v":0}]
[null,"               Transcript, errata sheet and certification *","LS",1,0,0]
[null,"               Court Reporter","LS",1,0,{"$f":"ROUND(D176*E176,0)","v":0}]
[null,"               Staff Briefing *","LS",1,0,0]
[null,"       Participation and Notes","LS",null,null,{"$f":"SUM(F179:F180)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D179*E179,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D180*E180,0)","v":0}]
[null,"       Response to Comments *","LS",1,0,{"$f":"ROUND(D181*E181,0)","v":0}]
[null,"3.3 Public Hearing Total",null,null,null,{"$f":"SUM(F159,F178,F160,F181)","v":0}]
[3.4,"Comments and Coordination Report *","LS",1,0,{"$f":"ROUND(D183*E183,0)","v":0}]
[3.5,"Notification of Approved Environmental Document *","LS",1,0,{"$f":"ROUND(D184*E184,0)","v":0}]
[3.6,"Additional Public Involvement Requirements"]
[null,"               General Public Correspondence *","LS",1,0,{"$f":"ROUND(D186*E186,0)","v":0}," "]
[null,"               Newsletters/Fact Sheets * ","LS",1,0,0]
[null,"               Frequently Asked Questions (FAQs) *","LS",1,0,{"$f":"ROUND(D188*E188,0)","v":0}]
[null,"               FDOT's Project Website *","LS",1,0,{"$f":"ROUND(D189*E189,0)","v":0}]
[null,"               Surveys or Questionnaires *","LS",1,0,0]
[null,"               Videos, Renderings, Fly-Throughs, 3-Dimensional (3D) Visualization *","LS",1,0,{"$f":"ROUND(D191*E191,0)","v":0}]
[null,"               Microsimulation *","LS",1,0,{"$f":"ROUND(D192*E192,0)","v":0}]
[null,"               Speakers Bureau *","LS",1,0,{"$f":"ROUND(D193*E193,0)","v":0}]
[null,"               Design Charettes *","LS",1,0,{"$f":"ROUND(D194*E194,0)","v":0}]
[null,"               Other *","LS",1,0,0]
[null,"3.6 Additional Public Involvement Requirements Total",null,null,null,{"$f":"SUM(F186:F195)","v":0}]
["Public Involvement Subtotal",null,null,null,null,{"$f":"SUM(F196,F184,F183,F182,F157,F19)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F186:F195,F184,F183,F30, F161:F167,F149, F139,F169:F172,F174:F174,F175:F175,F177,F124,F108,F99,F83,F67,F57,F48,F33, F22,F14,F18,F13,F46,F55,F64,F80,F96,F105,F121,F137,F146,F156,F181)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E199*F198,0)","v":0}]
["PUBLIC INVOLVEMENT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F197,F199)","v":0}]

{"sheet":"4. ENG ANALYSES & CONSIDERATION","index":10,"n_rows":123,"n_cols":7,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
["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"]
[""]
["4.0","ENGINEERING ANALYSES AND CONSIDERATIONS"]
[4.0999999999999996,"Review of Previous Studies","LS",1,0,{"$f":"ROUND((E12*D12),0)","v":0}]
[4.2,"Existing Conditions Analysis"]
[null,"       Data Collection","LS",1,0,{"$f":"ROUND((E14*D14),0)","v":0}]
[null,"       Field Review","LS",1,0,{"$f":"ROUND((E15*D15),0)","v":0}]
[null,"       Analysis *","LS",1,0,{"$f":"ROUND((E16*D16),0)","v":0}]
[null,"4.2 Existing Conditions Analysis Total",null,null,null,{"$f":"SUM(F14:F16)","v":0}]
[4.3,"Survey"]
[null,"     4.3.1 Survey Design *","LS",1,0,{"$f":"ROUND((E19*D19),0)","v":0}]
[null,"               Survey Coordination","LS",1,0,{"$f":"ROUND((E20*D20),0)","v":0}]
[null,"     4.3.2 Photogrammetry (Optional) *","LS",1,0,{"$f":"ROUND((E21*D21),0)","v":0}]
[null,"               Aerial Photography","LS",1,0,{"$f":"ROUND((E22*D22),0)","v":0}]
[null,"4.3 Survey Total",null,null,null,{"$f":"SUM(F19:F22)","v":0}]
[4.4000000000000004,"Geotechnical Investigation"]
[null,"     Geotechnical Design Services *  ","LS",1,0,{"$f":"ROUND((E25*D25),0)","v":0}]
[null,"     Geotechnical Review","LS",1,0,{"$f":"ROUND((E26*D26),0)","v":0}]
[null,"     Geotechnical Coordination","LS",1,0,{"$f":"ROUND((E27*D27),0)","v":0}]
[null,"4.4 Geotechnical Investigation Total",null,null,null,{"$f":"SUM(F25:F27)","v":0}]
[4.5,"Traffic Analysis"]
[null,"     Traffic Analysis Review","LS",1,0,{"$f":"ROUND((E30*D30),0)","v":0}]
[null,"     4.5.1 Traffic Analysis Methodology *","LS",1,0,{"$f":"ROUND((E31*D31),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 for Microsimulation (Optional) * ","LS",1,0,0]
[null,"     4.5.6 Existing Traffic Operational Analysis * ","LS",1,0,0]
[null,"     4.5.7 Future Demand Forecasting * ","LS",1,0,0]
[null,"     4.5.8 No-Build Analysis * ","LS",1,0,0]
[null,"     4.5.9 Development and Screening of Build Alternatives * ","LS",1,0,0]
[null,"     4.5.10 Intersection Control Evaluation (ICE) * ","LS",1,0,{"$f":"ROUND((E40*D40),0)","v":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,{"$f":"ROUND((E43*D43),0)","v":0}]
[null,"     4.5.14 Traffic Data for Noise Study * ","EA",0,0,{"$f":"ROUND((E44*D44),0)","v":0}]
[null,"     4.5.15 Traffic Data for Air Quality Analysis * ","EA",0,0,0]
[null,"     4.5.16 Signalization Analysis (Optional) * ","LS",1,0,{"$f":"ROUND((E46*D46),0)","v":0}]
[null,"4.5 Traffic Analysis Total",null,null,null,{"$f":"SUM(F30:F46)","v":0}]
[4.5999999999999996,"Signage (Optional) *","LS",1,0,{"$f":"ROUND((E48*D48),0)","v":0}]
[4.7,"Tolling Concepts (Optional) *","LS",1,0,{"$f":"ROUND((E49*D49),0)","v":0}]
[4.8,"Safety"]
[null,"     4.8.1 Existing Conditions Analysis *","LS",1,0,{"$f":"ROUND((E51*D51),0)","v":0}]
[null,"     4.8.2 Future Conditions Analysis *","LS",1,0,{"$f":"ROUND((E52*D52),0)","v":0}]
[null,"     4.8.3 Documentation of Safety Analysis *","LS",1,0,{"$f":"ROUND((E53*D53),0)","v":0}]
[null,"4.8 Safety Total",null,null,null,{"$f":"SUM(F51:F53)","v":0}]
[4.9000000000000004,"Utilities and Railroads"]
[null,"     4.9.1 Utilities *","EA",1,0,{"$f":"ROUND((E56*D56),0)","v":0}]
[null,"    4.9.2  Railroads *","EA",1,0,{"$f":"ROUND((E57*D57),0)","v":0}]
[null,"4.9 Utilities and Railroads Total",null,null,null,{"$f":"SUM(F56:F57)","v":0}]
["4.10","Roadway Analysis"]
[null,"     4.10.1 Design Controls and Criteria *","LS",1,0,{"$f":"ROUND((E60*D60),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 Lighting *","LS",1,0,0]
[null,"        4.10.7.1       Lighting Justification Report *","LS",1,0,{"$f":"ROUND((E67*D67),0)","v":0}]
[null,"4.10 Roadway Total",null,null,null,{"$f":"SUM(F60:F67)","v":0}]
[4.1100000000000003,"Identify Construction Segments *","LS",1,0,{"$f":"ROUND((E69*D69),0)","v":0}]
[4.12,"Transportation Systems Management and Operations *","LS",1,0,{"$f":"ROUND((E70*D70),0)","v":0}]
[4.13,"Structures "]
[null,"     4.13.1 Existing Structures*","EA",0,0,{"$f":"ROUND((E72*D72),0)","v":0}]
[null,"     4.13.2 Structure Typical Sections *","EA",0,0,{"$f":"ROUND((E73*D73),0)","v":0}]
[null,"     4.13.3 Proposed Structure *","EA",0,0,{"$f":"ROUND((E74*D74),0)","v":0}]
[null,"     4.13.4 Structures over Navigable Waters *","EA",0,0,{"$f":"ROUND((E75*D75),0)","v":0}]
[null,"4.13 Structures Total",null,null,null,{"$f":"SUM(F72:F75)","v":0}]
[4.1399999999999997,"Drainage"]
[null,"     4.14.1 Floodplain and Drainage Data Collection *","LS",1,0,{"$f":"ROUND((E78*D78),0)","v":0}]
[null,"     4.14.2 Drainage Analysis *","Per Basin",0,0,{"$f":"ROUND((E79*D79),0)","v":0}]
[null,"     4.14.3 Floodplain Compensation Analysis *","Per Encroach.",0,0,0]
[null,"     4.14.4 Sea Level Rise Analysis *","LS",1,0,0]
[null,"     4.14.5 Stormwater Management Analysis "]
[null,"               Watershed Approach to Evaluating Regional Stormwater Solutions (WATERSS) *","LS",1,0,{"$f":"ROUND((E83*D83),0)","v":0}]
[null,"               Stormwater Management *","Per Basin",0,0,{"$f":"ROUND((E84*D84),0)","v":0}]
[null,"     4.14.6 Drainage Design (Optional) *","LS",1,0,0]
[null,"    4.14.7 Location Hydraulics Report *","LS",1,0,0]
[null,"    4.14.8 Bridge Hydraulics Report (Optional) *","EA",0,0,0]
[null,"4.14 Drainage Total",null,null,null,{"$f":"SUM(F78:F87)","v":0}]
[4.1500000000000004,"Landscaping Analysis (Optional) *","LS",1,0,{"$f":"ROUND((E89*D89),0)","v":0}]
[4.16,"Project Cost Estimates "]
[null,"     4.16.1 Construction Cost Estimates *","LS",1,0,{"$f":"ROUND((E91*D91),0)","v":0}]
[null,"     4.16.2 Right of Way Cost Estimates"]
[null,"               Right of Way Cost Estimate Support *","LS",1,0,{"$f":"ROUND((E93*D93),0)","v":0}]
[null,"               Right of Way Cost Estimate Coordination","LS",1,0,0]
[null,"               Right of Way Cost Estimate Preparation *","LS",1,0,0]
[null,"     4.16.3 Other Cost Estimates *","LS",1,0,0]
[null,"4.16 Construction and Right of Way Cost Estimates Total",null,null,null,{"$f":"SUM(F91:F96)","v":0}]
[4.17,"Alternatives Evaluation "]
[null,"     4.17.1 Comparative Alternatives Evaluation *","LS",1,0,{"$f":"ROUND((E99*D99),0)","v":0}]
[null,"     4.17.2 Selection of Preferred Alternative *","LS",1,0,{"$f":"ROUND((E100*D100),0)","v":0}]
[null,"     4.17.3 Value Engineering (Optional) *","LS",1,0,{"$f":"ROUND((E101*D101),0)","v":0}]
[null,"4.17 Alternatives Evaluation Total",null,null,null,{"$f":"SUM(F99:F101)","v":0}]
[4.18,"Concept Plans "]
[null,"     4.18.1 Base Map *","Sheet",0,0,{"$f":"ROUND((E104*D104),0)","v":0}]
[null,"     4.18.2 Alternatives Concept Plans *","Sheet",0,0,{"$f":"ROUND((E105*D105),0)","v":0}]
[null,"     4.18.3 Preferred Alternative *","Sheet",0,0,{"$f":"ROUND((E106*D106),0)","v":0}]
[null,"     4.18.4 Typical Section Package *","LS",1,0,{"$f":"ROUND((E107*D107),0)","v":0}]
[null,"     4.18.5 Design Exceptions and Design Variations *","EA",0,0,{"$f":"ROUND((E108*D108),0)","v":0}]
[null,"4.18 Concept Plans Total",null,null,null,{"$f":"SUM(F104:F108)","v":0}]
[4.1900000000000004,"Transportation Management Plan *","LS",1,0,{"$f":"ROUND((E110*D110),0)","v":0}]
[4.2,"Risk Management (Optional)"]
[null,"     Meeting Materials *","LS",1,0,{"$f":"ROUND((E112*D112),0)","v":0}]
[null,"     Meeting Participation","LS",1,0,{"$f":"ROUND((E113*D113),0)","v":0}]
[null,"4.20 Risk Management Total",null,null,null,{"$f":"SUM(F112:F113)","v":0}]
[4.21,"Engineering Analysis Documentation "]
[null,"     Draft Preliminary Engineering Report *","LS",1,0,{"$f":"ROUND((E116*D116),0)","v":0}]
[null,"     Final Preliminary Engineering Report *","LS",1,0,{"$f":"ROUND((E117*D117),0)","v":0}]
[null,"     4.21.1 Constructability Review *","LS",1,0,{"$f":"ROUND((E118*D118),0)","v":0}]
[null,"4.21 Engineering Analysis Documentation Total",null,null,null,{"$f":"SUM(F116:F118)","v":0}]
["Engineering Analysis and Report Subtotal",null,null,null,null,{"$f":"SUM(F119,F114,F110,F109,F102,F97,F89,F88,F76,F70,F69,F68,F58,F54,F49,F48,F47,F28,F23,F17,F12)","v":0}]
[null,"Hours Subject to QC",null,null,null,{"$f":"SUM(F16,F116:F118,F112,F110,F109,F102,F91,F89,F87,F86,F85,F83:F84,F80:F81,F79,F78,F76,F70,F69,F68,F58,F54,F49,F48,F31:F46,F25,F21,F19, F93,F95:F96)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E122*F121,0)","v":0}]
["ENGINEERING ANALYSIS AND REPORT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F120,F122)","v":0}]

{"sheet":"5. ENV ANALYSIS & REPORTS","index":11,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[[102,0,102,4],[100,0,100,4],[99,0,99,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"]
[]
[""]
["5.0","ENVIRONMENTAL ANALYSIS AND REPORTS"]
[5.0999999999999996,"Sociocultural Effects"]
[null,"     5.1 Sociocultural Effects Evaluation *","LS",1,0,{"$f":"ROUND((E14*D14),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((E18*D18),0)","v":0}]
[null,"     5.1.5 Aesthetic Effects *","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.7 Farmland *","LS",1,0,0]
[null,"5.1 Sociocultural Effects Total",null,null,null,{"$f":"SUM(F14:F23)","v":0}]
[5.2,"Cultural Resources"]
[null,"     5.2.1 Archaeological and Historical Resources"]
[null,"               Research Design and Survey Methodology *","LS",1,0,{"$f":"ROUND((E27*D27),0)","v":0}]
[null,"               Cultural Resources Assessment Survey (CRAS) *","LS",1,0,{"$f":"ROUND((E28*D28),0)","v":0}]
[null,"               Pond Sites Desktop Assessment *","LS",1,0,0]
[null,"               Determinations of Eligibility (DOE) (As Required)","LS",1,0,0]
[null,"               Section 106 Case Report *","LS",1,0,0]
[null,"               Memorandum of Agreement (MOA) *","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 Areas and Protected Lands"]
[null,"              Data Collection and Analysis","LS",1,0,{"$f":"ROUND((E38*D38),0)","v":0}]
[null,"              Coordination","LS",1,0,{"$f":"ROUND((E39*D39),0)","v":0}]
[null,"              Documentation"]
[null,"              Section 4(f) Evaluation *","LS",1,0,{"$f":"ROUND((E41*D41),0)","v":0}]
[null,"              Recreational Areas Not Subject to Section 4(f) *","LS",1,0,{"$f":"ROUND((E42*D42),0)","v":0}]
[null,"              State Owned Lands *","LS",1,0,0]
[null,"     5.2.3 Section 4(f) and Concurrent Requirements (Optional)"]
[null,"              Section 4(f) Determination of Applicability *","EA",0,0,{"$f":"ROUND((E45*D45),0)","v":0}]
[null,"              Section 4(f) \"de minimis\" Documentation *","EA",0,0,0]
[null,"              Individual Section 4(f) Evaluation *","EA",0,0,0]
[null,"5.2 Cultural Resources Total",null,null,null,{"$f":"SUM(F27:F47)","v":0}]
[5.3,"Natural Resources"]
[null,"     5.3.1 Wetlands and Other Surface Waters"]
[null,"               Data Collection","LS",1,0,{"$f":"ROUND((E51*D51),0)","v":0}]
[null,"               Analysis *","LS",1,0,{"$f":"ROUND((E52*D52),0)","v":0}]
[null,"               Conceptual Mitigation *","LS",1,0,0]
[null,"     5.3.2 Essential Fish Habitat"]
[null,"               Data Collection","LS",1,0,{"$f":"ROUND((E55*D55),0)","v":0}]
[null,"               Analysis *","LS",1,0,0]
[null,"     5.3.3 Protected Species and Habitat"]
[null,"              Data Collection and Agency Coordination","LS",1,0,{"$f":"ROUND((E58*D58),0)","v":0}]
[null,"              Specific Survey","LS",1,0,0]
[null,"              Analysis *","LS",1,0,0]
[null,"              Conservation Measures and Mitigation Plan *","LS",1,0,{"$f":"ROUND((E61*D61),0)","v":0}]
[null,"     5.3.4 Natural Resource Documentation"]
[null,"              Wetlands or Other Surface Waters Documentation *","LS",1,0,{"$f":"ROUND((E63*D63),0)","v":0}]
[null,"              Essential Fish Habitat (EFH) Assessment *","LS",1,0,{"$f":"ROUND((E64*D64),0)","v":0}]
[null,"              Protected Species and Habitat Documentation and Biological Assessment *","LS",1,0,{"$f":"ROUND((E65*D65),0)","v":0}]
[null,"     5.3.5 Water Resources"]
[null,"              Analysis ","LS",1,0,{"$f":"ROUND((E67*D67),0)","v":0}]
[null,"              Documentation *","LS",1,0,{"$f":"ROUND((E68*D68),0)","v":0}]
[null,"     5.3.6 Wild and Scenic Rivers"]
[null,"              Analysis ","LS",1,0,{"$f":"ROUND((E70*D70),0)","v":0}]
[null,"              Documentation *","LS",1,0,0]
[null,"     5.3.7 Floodplains","LS",1,0,{"$f":"ROUND((E72*D72),0)","v":0}]
[null,"     5.3.8 Coastal Zone Consistency","LS",1,0,{"$f":"ROUND((E73*D73),0)","v":0}]
[null,"     5.3.9 Coastal Barrier Resources","LS",1,0,{"$f":"ROUND((E74*D74),0)","v":0}]
[null,"5.3 Natural Resources Total",null,null,null,{"$f":"SUM(F51:F74)","v":0}]
[5.4,"Physical Effects"]
[null,"     5.4.1 Highway Traffic Noise"]
[null,"              Methodology Meeting *","LS",1,0,{"$f":"ROUND((E78*D78),0)","v":0}]
[null,"              Data Collection","LS",1,0,0]
[null,"              Traffic Data Review and Formatting","LS",1,0,{"$f":"ROUND((E80*D80),0)","v":0}]
[null,"              Field Measurement and Noise Model Validation *","LS",1,0,0]
[null,"              Construction Noise and Vibration Assessment *","LS",1,0,{"$f":"ROUND((E82*D82),0)","v":0}]
[null,"              Noise Analysis ","LS",1,0,{"$f":"ROUND((E83*D83),0)","v":0}]
[null,"              Noise Abatement Evaluation *","EA",0,0,0]
[null,"              Noise Study Report (NSR) *","LS",1,0,0]
[null,"              Public Meetings Support","LS",1,0,{"$f":"ROUND((E86*D86),0)","v":0}]
[null,"     5.4.2 Transit Noise and Vibration Impact Analysis *","LS",1,0,{"$f":"ROUND((E87*D87),0)","v":0}]
[null,"     5.4.3 Air Quality"]
[null,"              Data Collection","LS",1,0,{"$f":"ROUND((E89*D89),0)","v":0}]
[null,"              Screening Analysis *","LS",1,0,{"$f":"ROUND((E90*D90),0)","v":0}]
[null,"              Air Quality Modeling * ","LS",1,0,{"$f":"ROUND((E91*D91),0)","v":0}]
[null,"              Air Quality Technical Memorandum (AQTM) * ","LS",1,0,{"$f":"ROUND((E92*D92),0)","v":0}]
[null,"     5.4.4 Construction *","LS",1,0,{"$f":"ROUND((E93*D93),0)","v":0}]
[null,"     5.4.5 Contamination"]
[null,"              Data Collection","LS",1,0,{"$f":"ROUND((E95*D95),0)","v":0}]
[null,"              Analysis and Report  *","LS",1,0,{"$f":"ROUND((E96*D96),0)","v":0}]
[null,"5.4 Physical Effects Total",null,null,null,{"$f":"SUM(F78:F96)","v":0}]
[5.5,"Cumulative Effects Evaluation (When Applicable)*","EA",0,0,{"$f":"ROUND((E98*D98),0)","v":0}]
[5.6,"Project Commitments *","LS",1,0,{"$f":"ROUND((E99*D99),0)","v":0}]
["Environmental Analysis and Report Subtotal",null,null,null,null,{"$f":"SUM(F97:F99,F75,F48,F24)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F98:F99,F96,F93,F90:F92,F87,F85,F84,F82,F81,F63:F65,F68,F71,F60:F61,F56:F56,F53,F45:F47,F36,F32,F31,F29,F27:F28,F21:F23,F14:F19,F41:F43,F52,F78)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E102*F101,0)","v":0}]
["ENVIRONMENTAL ANALYSIS AND REPORT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F102+F100)","v":0}]

{"sheet":"6. ENVIRONMENTAL DOCUMENT","index":12,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,4],[25,0,25,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"]
[]
[""]
["6.0","ENVIRONMENTAL DOCUMENT"]
[null,"     Type 2 Categorical Exclusion (CE) *","LS",1,0,{"$f":"ROUND((E13*D13),0)","v":0}]
[null,"     Environmental Assessment (EA) *","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,0]
[null,"6.0 Environmental Document Total",null,null,null,{"$f":"SUM(F13:F20)","v":0}]
[6.1,"Planning Consistency"]
[null,"     6.1.1 Transportation Plans","LS",1,0,{"$f":"ROUND((E23*D23),0)","v":0}]
[null,"     6.1.2 Planning Consistency Form *","LS",1,0,{"$f":"ROUND((E24*D24),0)","v":0}]
[null,"6.1 Planning Consistency Total",null,null,null,{"$f":"SUM(F23:F24)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F13:F20,F24)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(F26*E27,0)","v":0}]
["ENVIRONMENTAL DOCUMENT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F27+F25+F21)","v":0}]