{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["PROJECT DATA","Summary","Staff Hour Summary-Grand Total","Staff Hour Summary - Firm","Fee Sheet - Prime","Fee Sheet - Sub","CITS Output","1. GENERAL","2. ETDM Support","3. PUBLIC INVOLVEMENT","4. ACE METHODOLOGY","5. ALTERNATIVE CORRIDORS EVAL."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":100,"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":"PROJECT DATA","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"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,"1.0 GENERAL",null,null,null,null,null,null,{"$f":"'1. GENERAL'!F19","v":0}]
[null,null,"2.0 ETDM Support",null,null,null,null,null,null,{"$f":"'2. ETDM Support'!F21","v":0}]
[null,null,"3.0 PUBLIC INVOLVEMENT",null,null,null,null,null,null,{"$f":"'3. PUBLIC INVOLVEMENT'!F82","v":0}]
[null,null,"4.0 INITIAL IDENTIFICATION OF CORRIDORS",null,null,null,null,null,null,{"$f":"'4. ACE METHODOLOGY'!F29","v":0}]
[null,null,"5.0 ALTERNATIVE CORRIDORS EVALUATION",null,null,null,null,null,null,{"$f":"'5. ALTERNATIVE CORRIDORS EVAL.'!F26","v":0}]
[]
[null,null,"PROJECT TOTAL  HOURS",null,null,null,null,null,null,{"$f":"SUM(J24:J28)","v":0}]

{"sheet":"Summary","index":1,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,0,9,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"]
[1,"General",{"$f":"'PROJECT DATA'!J24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:O5)","v":0}]
[2,"ETDM Support",{"$f":"'PROJECT DATA'!J25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[3,"Public Involvement",{"$f":"'PROJECT DATA'!J26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"Initial Identification of Corridors",{"$f":"'PROJECT DATA'!J27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"Alternative Corridors Evaluation",{"$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,{"$f":"SUM(C10:O10)","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":2,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,1,8,1],[23,0,23,16],[29,0,29,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],[25,13,25,16],[27,13,27,16],[8,14,8,15],[7,14,7,15],[19,12,19,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-08-09"},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":"General"},{"$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}]
["ETDM Support",{"$f":"Summary!C6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B7","v":"Public Involvement"},{"$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":"Initial Identification of Corridors"},{"$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":"Alternative Corridors Evaluation"},{"$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":"2018-08-09"},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":"General"},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}]
["ETDM Support",{"$f":"B14","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,1]
[{"$f":"A15","v":"Public Involvement"},{"$f":"B15","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,1]
[{"$f":"A16","v":"Initial Identification of Corridors"},{"$f":"B16","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,1]
[{"$f":"A17","v":"Alternative Corridors Evaluation"},{"$f":"B17","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,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":3,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,13,2,16],[9,11,10,11],[4,13,4,16],[25,13,25,16],[23,0,23,16],[9,10,10,10],[9,6,10,6],[9,7,10,7],[29,0,29,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],[27,13,27,16],[8,14,8,15],[7,14,7,15],[19,12,19,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-08-09"},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":"General"},{"$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}]
["ETDM Support",{"$f":"Summary!C6","v":0},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":"Public Involvement"},{"$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":"Initial Identification of Corridors"},{"$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":"Alternative Corridors Evaluation"},{"$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":"2018-08-09"},null,"Name of Consultant:  ",{"$f":"N5","v":"Enter name of consultant"}]
[]
["Staff Hour Distribution Percentages - Firm Total"]
["Work Activity","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":"Summary!B5","v":"General"},{"$f":"B13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C32:N32)","v":0}]
["ETDM Support",{"$f":"B14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B7","v":"Public Involvement"},{"$f":"B15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B8","v":"Initial Identification of Corridors"},{"$f":"B16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Summary!B9","v":"Alternative Corridors Evaluation"},{"$f":"B17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Fee Sheet - Prime","index":4,"n_rows":40,"n_cols":18,"rows_kept":40,"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-08-09T11:07:11.650"}]
["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":"General"},{"$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}]
["ETDM Support",{"$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},{"$f":"SUM(C11:N11)","v":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(+P10/O10,2)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Summary!B7","v":"Public Involvement"},{"$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":"Initial Identification of Corridors"},{"$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":"Alternative Corridors Evaluation"},{"$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,null,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":5,"n_rows":27,"n_cols":18,"rows_kept":27,"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-08-09T11:07:11.650"}]
["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":"General"},{"$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!"}}]
["ETDM Support",{"$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},{"$f":"SUM(C11:N11)","v":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":"'Staff Hour Summary - Firm'!A15","v":"Public Involvement"},{"$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":"Initial Identification of Corridors"},{"$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":"Alternative Corridors Evaluation"},{"$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":6,"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'!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":"1. GENERAL","index":7,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,0,9,6],[15,0,15,4],[16,0,16,4],[18,0,18,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"]
["NOTE:  * subject to QC"]
[1.4,"Schedule","LS",1,0,{"$f":"ROUND(D11*E11,0)","v":0}]
[1.6,"Project Coordination","LS",1,0,{"$f":"ROUND(D12*E12,0)","v":0}]
[1.1200000000000001,"Project Quality Control","LS",1,0,0]
[1.1299999999999999,"Status and Progress Reports","LS",1,0,0]
[1.1399999999999999,"Optional Services*","LS",1,0,0]
["General Subtotal",null,null,null,null,{"$f":"SUM(F11:F15)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F15)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E18*F17,0)","v":0}]
["GENERAL TOTAL HOURS",null,null,null,null,{"$f":"SUM(F16,F18)","v":0}]
[]
[]
[null,null," "]

{"sheet":"2. ETDM Support","index":8,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,18,4],[20,0,20,4],[9,0,9,6],[10,1,10,5],[17,0,17,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"]
["NOTE:  * subject to QC"]
[2,"ETDM Support"]
[null,"Preliminary Environmental Discussion*  ","LS",1,0,{"$f":"ROUND(D12*E12,0)","v":0}]
[null,"Purpose and Need * ","LS",1,0,{"$f":"ROUND(D13*E13,0)","v":0}]
[null,"Pre-screening activities *","LS",1,0,0]
[null,"Project alternative corridors in the EST  *","LS",1,0,0]
[null,"Justification of Class of Action *","LS",1,0,{"$f":"ROUND(D16*E16,0)","v":0}]
[null,"Review of Materials and Comments","LS",1,0,0]
["ETDM Support Subtotal",null,null,null,null,{"$f":"SUM(F12:F17)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F12:F16)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E20*F19,0)","v":0}]
["ETDM SUPPORT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F18,F20)","v":0}]

{"sheet":"3. PUBLIC INVOLVEMENT","index":9,"n_rows":82,"n_cols":7,"rows_kept":82,"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],[81,0,81,4],[78,0,78,4],[79,0,79,4],[9,0,9,6],[11,1,11,5],[70,1,70,5],[76,1,76,4],[69,1,69,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 Plan *","LS",1,0,{"$f":"ROUND(D11*E11,0)","v":0}]
[3.2,"Scheduled Public Meetings"]
[null,"   Project Kickoff Meeting"]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E15:E21)","v":0},{"$f":"SUM(F15:F21)","v":0}]
[null,"               Presentation*  ","LS",1,0,{"$f":"ROUND(D15*E15,0)","v":0}]
[null,"               Project Handouts * ","LS",1,0,{"$f":"ROUND(D16*E16,0)","v":0}]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Site Selection *","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(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D23*E23,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D24*E24,0)","v":0}]
[null,"Corridor Workshop "]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E27:E36)","v":0},{"$f":"SUM(F27:F36)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D27*E27,0)","v":0}]
[null,"               Presentation *","LS",1,0,{"$f":"ROUND(D28*E28,0)","v":0}]
[null,"               Project Handouts *","LS",1,0,0]
[null,"                Exhibits *","LS",1,0,0]
[null,"               Site Selection *","LS",1,0,0]
[null,"               Notification Letters *","LS",1,0,0]
[null,"               Press Release/Meeting Announcements *","LS",1,0,{"$f":"ROUND(D33*E33,0)","v":0}]
[null,"                Project Summaries *","LS",1,0,0]
[null,"                Response letters *","LS",1,0,{"$f":"ROUND(D35*E35,0)","v":0}]
[null,"               Staff Briefing *","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,"Public Information Meeting(s)"]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E42:E51)","v":0},{"$f":"SUM(F42:F51)","v":0}]
[null,"               Agenda*  ","LS",1,0,{"$f":"ROUND(D42*E42,0)","v":0}]
[null,"               Presentation *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Site Selection *","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(E53:E54)","v":0},{"$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,"Other Public and Agency Meetings or Informal Meetings"]
[null,"       Development of Meeting Materials *","LS",1,{"$f":"SUM(E57:E66)","v":0},{"$f":"SUM(F57:F66)","v":0}]
[null,"               Agenda *","LS",1,0,{"$f":"ROUND(D57*E57,0)","v":0}]
[null,"               Presentation *","LS",1,0,0]
[null,"               Project Handouts *","LS",1,0,0]
[null,"               Exhibits *","LS",1,0,0]
[null,"               Site Selection *","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(E68:E69)","v":0},{"$f":"SUM(F68:F69)","v":0}]
[null,"               Participation","LS",1,0,{"$f":"ROUND(D68*E68,0)","v":0}]
[null,"               Notes","LS",1,0,{"$f":"ROUND(D69*E69,0)","v":0}]
[null,"3.2 Scheduled Public Meetings Total",null,null,null,{"$f":"SUM(,F67,F56,F52,F41,F37,F26,F22,F14)","v":0}]
[3.3,"Communication Aids"]
[null,"Videos, simulations, rendering, visualizations*","LS",1,0,{"$f":"ROUND(D72*E72,0)","v":0}]
[null,"Frequently Asked Questions (FAQ)*","LS",1,0,0]
[null,"Social Media*","LS",1,0,0]
[null,"Project Website*","LS",1,0,0]
[null,"Radio, Television*","LS",1,0,0]
[null,"3.3 Communication Aids",null,null,null,{"$f":"SUM(F72:F76)","v":0}]
[3.4,"Public Involvement Documentation*","LS",1,0,{"$f":"ROUND(D78*E78,0)","v":0}]
["Public Involvement Subtotal",null,null,null,null,{"$f":"SUM(F78,F77,F70,F11)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F11,F56,F77,F41,F26,F78,F14)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E81*F80,0)","v":0}]
["PUBLIC INVOLVEMENT TOTAL HOURS",null,null,null,null,{"$f":"SUM(F79,F81)","v":0}]

{"sheet":"4. ACE METHODOLOGY","index":10,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,4],[25,0,25,4],[26,1,26,4],[9,0,9,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],[11,1,11,5],[14,1,14,4],[17,1,17,5],[24,1,24,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 "]
[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 Total",null,null,null,{"$f":"SUM(F13:F14)","v":0}]
[4.3,"Development of Initial Corridors for Analysis*","LS",1,0,{"$f":"ROUND((E16*D16),0)","v":0}]
[4.4000000000000004,"Methodology Memorandum*","LS",1,0,{"$f":"ROUND((E17*D17),0)","v":0}]
[4.5,"Traffic Analysis"]
[null,"4.5.1 Traffic Analysis Methodology*","LS",1,0,{"$f":"ROUND((E19*D19),0)","v":0}]
[null,"4.5.2 Traffic Counts*","LS",1,0,0]
[null,"4.5.3 Existing Traffic Analysis*","LS",1,0,0]
[null,"4.5.4 Future Demand Forecasting*","LS",1,0,0]
[null,"4.5.5 Operational Analysis of Proposed Corridors*","LS",1,0,0]
[null,"4.5.6 Safety*","LS",1,0,0]
[null,"4.5 Traffic Analysis Total",null,null,null,{"$f":"SUM(F19:F24)","v":0}]
["Engineering Analysis and Report Subtotal",null,null,null,null,{"$f":"SUM(F16,F25,F17,F15,F11)","v":0}]
[null,"Hours Subject to QC",null,null,null,{"$f":"SUM(F16,F17,F25,)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E28*F27,0)","v":0}]
["INITIAL IDENTIFICATION OF CORRIDORS TOTAL HOURS",null,null,null,null,{"$f":"SUM(F26,F28)","v":0}]

{"sheet":"5. ALTERNATIVE CORRIDORS EVAL.","index":11,"n_rows":26,"n_cols":7,"rows_kept":26,"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],[22,0,22,4],[25,0,25,4],[23,0,23,4],[10,0,10,6],[12,1,12,5],[19,1,19,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"]
[5.0999999999999996,"Purpose and Need*","LS",1,0,{"$f":"ROUND((E12*D12),0)","v":0}]
[5.2,"Alternatives Analysis"]
[null,"5.2.1 Environmental Analysis*","LS",1,0,{"$f":"ROUND((E14*D14),0)","v":0}]
[null,"5.2.2 Engineering Analysis*","LS",1,0,0]
[null,"     5.2.2.1 Conceptual Plans*","LS",1,0,0]
[null,"     5.2.2.2 Construction Cost Estimates*","LS",1,0,0]
["   ","     5.2.2.3 Right of Way Cost Estimates*","LS",1,0,0]
[null,"5.2.3 Refine Corridors","LS",1,0,0]
[null,"5.2 Corridor Development and Analysis",null,null,null,{"$f":"SUM(F14:F19)","v":0}]
[5.3,"Comparative evaluation*","LS",1,0,0]
[5.4,"Alternative Corridor Evaluation Report*","LS",1,0,0]
["Alternative Corridors Evaluation Subtotal",null,null,null,null,{"$f":"SUM(F12,F21,F22,F20)","v":0}]
["Hours Subject to QC",null,null,null,null,{"$f":"SUM(F12,F22,F20,F21)","v":0}]
[null,"Quality Assurance / Quality Control","LS","%",0,{"$f":"ROUND(E25*F24,0)","v":0}]
["ALTERNATIVE CORRIDORS EVALUATION TOTAL HOURS",null,null,null,null,{"$f":"SUM(F25+F23)","v":0}]