{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["COVER SHEET","AERIAL ESTIMATE","PHOTO LABOR & DIRECT EXPENSES","FEE PROPOSAL","Net Fee Calculator","PHOTO FORM REVISIONS","Module1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":6,"reason":"part_missing"}],"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":"COVER SHEET","index":0,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,1,10,7],[44,0,44,1],[41,0,41,1],[38,0,38,1],[23,0,23,8],[13,1,13,7],[15,1,15,7],[17,2,17,6],[24,0,29,8],[19,2,19,6],[36,3,36,6],[39,0,39,1],[42,0,42,1],[45,0,45,1],[38,3,38,6],[39,3,39,6],[34,3,34,6],[35,3,35,6],[37,3,37,6]]}
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"Instructions:\")","v":""}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"(Enter state route number, project description,county, consultant's name,\")","v":""}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"prepared by name, and date prepared.  This information will be transferred\")","v":""}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"to all other sheets. The date prepared must be entered in the appropriate\")","v":""}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"cell on this sheet to remove these instructions prior to printing.)\")","v":""}]
[]
["TENNESSEE DEPARTMENT OF TRANSPORTATION"]
[]
["MANDAY ESTIMATE AND FEE PROPOSAL"]
[]
[null,"for PHOTOGRAMMETRY "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click Here to Select Type of Proposal from Drop Down List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Design Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Survey and Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Signal Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Survey Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Full Location Survey Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Proposed ROW and Easement Staking"]
["General Comments:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Geotechnical Staking"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For A Survey Update"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Additional Survey"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Prepared By:"]
[]
[]
["Date prepared:"]
[]
[]
["Project No.:"]
[null,null,null,null,null,null,"Version 1.10"]

{"sheet":"AERIAL ESTIMATE","index":1,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[[5,9,5,10]]}
["ESTIMATE FOR AERIAL SURVEY PROJECT"]
["PROJECT DESCRIPTION:",null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 1.10"}]
["Route:",{"$f":"'COVER SHEET'!B14","v":0}]
["Description:",{"$f":"'COVER SHEET'!B16","v":0}]
["County:",{"$f":"'COVER SHEET'!C18","v":0},null,null,null,null,null,null,"Prepared By:",{"$f":"'COVER SHEET'!A40","v":0}]
["Consultant:",{"$f":"'COVER SHEET'!D35","v":0},null,null,null,null,null,null,"Date prepared:",{"$f":"'COVER SHEET'!A43","v":"00:00:00"}]
["Project No.:",{"$f":"'COVER SHEET'!A46","v":0}]
[]
[]
[]
["ACTIVITY","Flight Crew","Project Manager","Sensor Operator","Lead Photogrammetrist","Photogrammetrist","Lead LiDAR Specialist","LiDAR Specialist","Map/Data Editor","Ortho Analyst","Photo Lab Processor"," Party Chief","Instrument Person","Rod Person","Clerical","Reserved","Man Hours"]
[null,"FC","PM","SO","LP","PH ","LLS","LS","MDE","OA","PLP","PC","IP","RP","CL ","RV","Total"]
["Pre-Flight Operations"]
["1. Pre-Flight Preparation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14:P14)","v":0}]
["2. Control Point Coordination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15:P15)","v":0}]
["Mobilization"]
["3. Turbine Airplane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B17:P17)","v":0}]
["4. Piston Airplane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:P18)","v":0}]
["5. Helicopter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["6. Mobile Mapping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Flight Operations"]
["7. Turbine Airplane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B22:P22)","v":0}]
["8. Piston Airplane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["9. Helicopter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["10. Mobile Mapping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Post-Flight Data Processing"]
["11. Film Processing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B27:P27)","v":0}]
["12. Digital Imagery Processing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["13. LiDAR Processing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["14. Airborne GPS Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["15. Field Survey Control (Field & Office)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Photogrammetry"]
["16. Triangulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B33:P33)","v":0}]
["17. Topography Creation (3D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["18. Planimetric Creation (2D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Surface Creation"]
["19. Digital Elevation Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B37:P37)","v":0}]
["20. Digital Terrain Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Orthophotography"]
["21. Ortho Generation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B40:P40)","v":0}]
["22. Georeferenced Digital Imagery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["23. Mosaicking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["24. Tile Clipping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Electronic File Editing"]
["25. CADD Editing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B45:P45)","v":0}]
["26. Data Merging",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Training"]
["27. Developing Training Materials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B48:P48)","v":0}]
["28. Performing Training Class",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["29. Developing Software Applications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Miscellaneous Items"]
["30. Reserved for Future Activity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B52:P52)","v":0}]
["31. Technical Meetings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["32. Quality Assurance / Quality Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["33. Supervision",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["34. Coordination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTALS (Man Hours)",{"$f":"SUM(B14:B56)","v":0},{"$f":"SUM(C14:C56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null," "," "]

{"sheet":"PHOTO LABOR & DIRECT EXPENSES","index":2,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[34,4,34,8],[35,4,35,8],[23,13,23,14],[24,13,24,14],[25,13,25,14],[26,13,26,14],[27,13,27,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[34,13,34,14],[35,13,35,14],[41,13,41,14],[42,13,42,14],[43,13,43,14],[44,13,44,14],[45,13,45,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[46,13,46,14],[47,13,47,14],[48,13,48,14],[49,13,49,14],[53,13,53,17],[51,13,51,16],[50,13,50,14]]}
[]
[]
[null,null,"PHOTPGRAMMETRY DIRECT LABOR COST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 1.10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PHOTOGRAMMETRY DIRECT EXPENSES"]
[]
[null,"PROJECT DESCRIPTION:",null,null,null,null,null,null,null,null,null,null,"PROJECT DESCRIPTION:"]
[null,"ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":0},null,null,null,null,null,null,null,null,"ROUTE:",{"$f":"D7","v":0}]
[null,"DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":0},null,null,null,null,null,null,null,null,"DESCRIPTION:",{"$f":"D8","v":0}]
[null,"COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":0},null,null,null,null,null,null,null,null,"COUNTY:",{"$f":"D9","v":0},null,null,"Prepared By:",{"$f":"H10","v":0}]
[null,"CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":0},null,null,"Prepared By:",{"$f":"'COVER SHEET'!A40","v":0},null,null,null,null,"CONSULTANT:",{"$f":"D10","v":0},null,null,"Date Prepared:",{"$f":"H11","v":"00:00:00"}]
[null,"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":0},null,null,"Date Prepared:",{"$f":"'COVER SHEET'!A43","v":"00:00:00"},null,null,null,null,"Project No.:",{"$f":"D11","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item Subtotal","Item Total Cost"]
[]
[null,null,null,"Abbrv.","Personnel Classification"," Man Hours",null,"Rate Per Man-Hour",null,"Direct Labor (Man Hours)"]
[null,null,1,{"$f":"'AERIAL ESTIMATE'!B12","v":"FC"},{"$f":"'AERIAL ESTIMATE'!B11","v":"Flight Crew"},{"$f":"'AERIAL ESTIMATE'!B57","v":0},null,0,null,{"$f":"F16*H16","v":0}]
[null,null,2,{"$f":"'AERIAL ESTIMATE'!C12","v":"PM"},{"$f":"'AERIAL ESTIMATE'!C11","v":"Project Manager"},{"$f":"'AERIAL ESTIMATE'!C57","v":0},null,null,null,{"$f":"F17*H17","v":0}]
[null,null,3,{"$f":"'AERIAL ESTIMATE'!D12","v":"SO"},{"$f":"'AERIAL ESTIMATE'!D11","v":"Sensor Operator"},{"$f":"'AERIAL ESTIMATE'!D57","v":0},null,0,null,0,null,null,"Travel"," Travel Calculations"]
[null,null,4,{"$f":"'AERIAL ESTIMATE'!E12","v":"LP"},{"$f":"'AERIAL ESTIMATE'!E11","v":"Lead Photogrammetrist"},{"$f":"'AERIAL ESTIMATE'!E57","v":0},null,null,null,0]
[null,null,5,{"$f":"'AERIAL ESTIMATE'!F12","v":"PH "},{"$f":"'AERIAL ESTIMATE'!F11","v":"Photogrammetrist"},{"$f":"'AERIAL ESTIMATE'!F57","v":0},null,null,null,0,null,null,"From:"]
[null,null,6,{"$f":"'AERIAL ESTIMATE'!G12","v":"LLS"},{"$f":"'AERIAL ESTIMATE'!G11","v":"Lead LiDAR Specialist"},{"$f":"'AERIAL ESTIMATE'!G57","v":0},null,null,null,0,null,null,"To:"]
[null,null,7,{"$f":"'AERIAL ESTIMATE'!H12","v":"LS"},{"$f":"'AERIAL ESTIMATE'!H11","v":"LiDAR Specialist"},{"$f":"'AERIAL ESTIMATE'!H57","v":0},null,null,null,0]
[null,null,8,{"$f":"'AERIAL ESTIMATE'!I12","v":"MDE"},{"$f":"'AERIAL ESTIMATE'!I11","v":"Map/Data Editor"},{"$f":"'AERIAL ESTIMATE'!I57","v":0},null,0,null,0]
[null,null,9,{"$f":"'AERIAL ESTIMATE'!J12","v":"OA"},{"$f":"'AERIAL ESTIMATE'!J11","v":"Ortho Analyst"},{"$f":"'AERIAL ESTIMATE'!J57","v":0},null,null,null,0,null,null,null,"Number of Trips",null,"No. of Miles/No. of People","* RATE"]
[null,null,10,{"$f":"'AERIAL ESTIMATE'!K12","v":"PLP"},{"$f":"'AERIAL ESTIMATE'!K11","v":"Photo Lab Processor"},{"$f":"'AERIAL ESTIMATE'!K57","v":0},null,0,null,{"$f":"F25*H25","v":0},null,null,"Travel Day Per Diem  ",0,null,2,45.75,{"$f":"N25*P25*Q25","v":0}]
[null,null,11,{"$f":"'AERIAL ESTIMATE'!L12","v":"PC"},{"$f":"'AERIAL ESTIMATE'!L11","v":" Party Chief"},{"$f":"'AERIAL ESTIMATE'!L57","v":0},null,null,null,0,null,null,"Non Travel Day Per Diem",0,null,2,61,{"$f":"N26*P26*Q26","v":0}]
[null,null,12,{"$f":"'AERIAL ESTIMATE'!M12","v":"IP"},{"$f":"'AERIAL ESTIMATE'!M11","v":"Instrument Person"},{"$f":"'AERIAL ESTIMATE'!M57","v":0},null,null,null,0,null,null,"Transportation",0,null,240,0.47,{"$f":"N27*P27*Q27","v":0}]
[null,null,13,{"$f":"'AERIAL ESTIMATE'!N12","v":"RP"},{"$f":"'AERIAL ESTIMATE'!N11","v":"Rod Person"},{"$f":"'AERIAL ESTIMATE'!N57","v":0},null,0,null,0,null,null,"Lodging  ",0,null,2,93,{"$f":"N28*P28*Q28","v":0}]
[null,null,14,{"$f":"'AERIAL ESTIMATE'!O12","v":"CL "},{"$f":"'AERIAL ESTIMATE'!O11","v":"Clerical"},{"$f":"'AERIAL ESTIMATE'!O57","v":0},null,0,null,0,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(R25:R28)","v":0}]
[null,null,15,{"$f":"'AERIAL ESTIMATE'!P12","v":"RV"},{"$f":"'AERIAL ESTIMATE'!P11","v":"Reserved"},{"$f":"'AERIAL ESTIMATE'!P57","v":0},null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(ROUNDUP('AERIAL ESTIMATE'!C57*0.2,0))*P25*Q25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Item Description",null,"Number / Unit","Unit Price",null,null,null,null,null,null,null,{"$f":"ROUNDUP('AERIAL ESTIMATE'!C57*0.8,0)*P26*Q26","v":0}]
[null,null,null,null,"TOTALS",{"$f":"SUM(F16:F30)","v":0},null,null,null,{"$f":"SUM(J16:J30)","v":0},null,null,null,null,null,0,0,{"$f":"P32*Q32","v":0},null,null,null,null,null,null,{"$f":"ROUNDUP('AERIAL ESTIMATE'!C57,0)*P27*Q27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,{"$f":"ROUNDUP('AERIAL ESTIMATE'!C57*4/5,0)*P28*Q28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,{"$f":"SUM(Y30:Y33)","v":0}]
[null,null,null,null,"Direct Labor Cost Per Man Hour ",{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"J32/F32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,0,0,0,null,null,null,null,null,null,{"$f":"S21+Y34+S44+S52","v":0}]
[null,null,null,null,"Direct Labor Cost Per Man Day",{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&#REF!&\" HR MAN-DAYS)\")","v":{"$error":"#REF!"}},{"$f":"J35*8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"P41*Q41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"P45*Q45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(R32:R51)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT EXPENSES",null,null,null,null,{"$f":"SUM(S52,S29)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*  Rate must agree with most current State of Tennessee travel regulations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"    First and last day of travel must be at the 75% Per Diem Rate."]
[null,null,null,null,{"$f":"'AERIAL ESTIMATE'!J2","v":"Version 1.10"}]

{"sheet":"FEE PROPOSAL","index":3,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[26,0,26,2],[26,3,26,6],[14,0,14,2]]}
["FEE PROPOSAL"]
[]
["ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":0},null,null,null,"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":0}]
["DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":0},null,null,null,"PIN No.:",null,{"$f":"'COVER SHEET'!C20","v":0}]
["COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":0}]
["CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":0}]
["Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"00:00:00"}]
["Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"00:00:00"}]
[]
[{"$f":"IF(ISBLANK(A28),\"Overhead Rate used is depended on the project funding source  and must be identified by staff prior to submission of proposal.\",\"\")","v":"Overhead Rate used is depended on the project funding source  and must be identified by staff prior to submission of proposal."}]
[{"$f":"IF(ISBLANK(A29),\"This sheet computes percent net fee and performs fee proposal calculations for the project.\",\"\")","v":""}]
[{"$f":"IF(ISBLANK(A29),\"Enter the appropriate overhead rate & fill in shaded boxes that apply for each phase.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 1.10"}]
[]
["Data For Fee Calculations"]
["Overhead Rate  =",null,null,null,"**",null,{"$f":"IF('COVER SHEET'!F37=\"Sub:\",\"Overhead Rate** =\",\"\")","v":""}]
["**  (State Project Maximum overhead rate = 1.45)"]
["**  (Federal Project Maximum overhead rate per External Audit Report)"]
[]
["Photogrammetry Direct Labor  =",null,null,{"$f":"'PHOTO LABOR & DIRECT EXPENSES'!J32","v":0}]
["Total Direct Labor =",null,null,{"$f":"D18+D19","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(ISBLANK(A29),\"NOTE: Net Fee for Supplements/Addendums shall be\",\"\")","v":""}]
["Net Fee (Refer to \"Net Fee Calculator\")",null,null,{"$f":"'Net Fee Calculator'!G45","v":0.08},null,{"$f":"IF(ISBLANK(A29),\"            the same as the original contract.  It may be necessary\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(A29),\"            to modify net fee calculated on supplement requests.\",\"\")","v":""}]
[]
[]
[]
[]
["x",{"$f":"IF(ISBLANK(A29),\"(Place X in adjacent box to remove instructions prior to printing.)\",\"Remove X to display instructions.\")","v":"Remove X to display instructions."}]
[]
[]
["PHOTOGRAMMETRY"]
[]
[1,"Direct Labor",null,null,null,null,null,"=",{"$f":"'PHOTO LABOR & DIRECT EXPENSES'!J32","v":0}]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"$f":"$D$15","v":0},")","=",{"$f":"ROUND(I34*$D$15,2)","v":0}]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",null,null,null,null,"=",{"$f":"ROUND(I34+I36,2)","v":0}]
[]
[4,"Net Fee =",{"$f":"$D$23","v":0.08},null,null,null,"(Rounded to nearest $10.)","=",{"$f":"ROUND((I34+I36)*$D$23,-1)","v":0}]
[null,"(Direct labor + overhead) X 0.NF)"]
[]
[5,null,"Subtotal    3    +    4    ",null,null,null,null,"=",{"$f":"ROUND(I39+I41,2)","v":0}]
[]
[6,"Direct Expense",null,null,null,null,null,"=",{"$f":"ROUND('PHOTO LABOR & DIRECT EXPENSES'!S54,2)","v":0}]
[]
[7,"Premium Labor",null,null,null,null,null,"=",0]
[null,"(Premium Labor is only eligible if the staff works greater than a 40 hour work week.)"]
[8,null,"Total  Photogrammetry ",null,null,null,null,"=",{"$f":"ROUND(I44+I46+I48,2)","v":0}]
[null,null,"(Total  5 +  6  +  7)    "]

{"sheet":"Net Fee Calculator","index":4,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,5,5,7],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,5,4,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[9,1,9,2],[10,0,10,5],[10,6,10,7],[11,0,11,5],[16,6,16,7],[17,0,17,5],[17,6,17,7],[18,0,18,5],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,0,23,5],[23,6,23,7],[32,6,32,7],[24,0,24,5],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,0,29,5],[29,6,29,7],[30,0,30,5],[30,6,30,7],[31,6,31,7],[44,0,44,5],[45,0,45,5],[46,0,46,5],[47,1,47,5],[33,6,33,7],[34,6,34,7],[35,0,35,5],[35,6,35,7],[36,0,36,5],[36,6,36,7]]}
[null,"Tennessee Department of Transportation"]
[null,"Fixed Fee Worksheet"]
[null," ( 8% base plus)"]
[null,"Project Description:"]
[null,"Route:"]
[null,"Terminii:"]
[null,"County:"]
[null,"Consultant:"]
[null,"Other:"]
[]
["Size of Contract",null,null,null,null,null,"The smaller the phase(s) of work negotiated in a project specific type contract or the smaller the work order negotiated in an on-call type contract, the higher the additional fixed fee percentage."]
["% Additional Fee",null,null,null,null,null,"     Qualifier"]
[null,null,0,false,{"$f":"IF(AND(D13=TRUE,D14=FALSE,D15=FALSE,D16=FALSE),C13)","v":false},22222222,"More than $2,000,000"]
[null,null,0.5,false,{"$f":"IF(AND(D14=TRUE,D13=FALSE,D15=FALSE,D16=FALSE),C14)","v":false},111,"Less than $2,000,000"]
[null,null,1,false,{"$f":"IF(AND(D15=TRUE,D13=FALSE,D14=FALSE,D16=FALSE),C15)","v":false},"ddddddddddddd","Less than $500,000"]
[null,null,2,false,{"$f":"IF(AND(D16=TRUE,D13=FALSE,D14=FALSE,D15=FALSE),C16)","v":false},"ddddddddddddd","Less than $50,000"]
[null,null,null,null,null,{"$f":"SUM(E13:E16)","v":0}]
["Complexity",null,null,null,null,null,"The higher the complexity, the higher the additional fixed fee percentage."]
["% Additional Fee",null,null,null,null,null,"     Qualifier"]
[null,null,0,false,{"$f":"IF(AND(D20=TRUE,D21=FALSE,D22=FALSE),C20)","v":false},null,"Resurfacing, No Plans Contracts, CEI On-Call Work Orders"]
[null,null,0.5,false,{"$f":"IF(AND(D21=TRUE,D20=FALSE,D22=FALSE),C21)","v":false},null,"Rural widening project, Freeway widening,  New alignment,  NEPA,  Natural Stream Design,  Tech. Studies, CEI Project Specific Contracts, TPR, Bridge Approach Project, Signal Project, Intersection Widening, Standard Geotechnical Investigations and Designs, Railroad Projects"]
[null,null,1,false,{"$f":"IF(AND(D22=TRUE,D20=FALSE,D21=FALSE),C22)","v":false},null,"Interchange, Urban widening, ITS, Bridge Design, Retaining wall design or evaluations involving soldier piles or soldier piles with anchor walls,  seismic evaluations, and rockfall/landslide designs"]
[null,null,null,null,null,{"$f":"SUM(E20:E22)","v":0}]
["Contract Duration",null,null,null,null,null,"The longer the duration for the phase(s) negotiated in a project specific type contract or for the work order duration in an on-call type contract, the higher the additional fixed fee percentage."]
["% Additional Fee",null,null,null,null,null,"     Qualifier"]
[null,null,0,false,{"$f":"IF(AND(D26=TRUE,D27=FALSE,D28=FALSE),C26)","v":false},null,"less than two years"]
[null,null,0.5,false,{"$f":"IF(AND(D27=TRUE,D26=FALSE,D28=FALSE),C27)","v":false},null,"from two to four years"]
[null,null,1,false,{"$f":"IF(AND(D28=TRUE,D26=FALSE,D27=FALSE),C28)","v":false},null,"four years or more"]
[null,null,null,null,null,{"$f":"SUM(E26:E28)","v":0}]
["Subcontracting",null,null,null,null,null,"The less work subcontracted, the higher the additional fixed fee percentage"]
["% Additional Fee",null,null,null,null,null,"     Qualifier"]
[null,null,0,false,{"$f":"IF(AND(D32=TRUE,D33=FALSE,D34=FALSE),C32)","v":false},null,"More than 40% of job"]
[null,null,0.5,false,{"$f":"IF(AND(D33=TRUE,D32=FALSE,D34=FALSE),C33)","v":false},null,"Less than 40% of job"]
[null,null,1,false,{"$f":"IF(AND(D34=TRUE,D32=FALSE,D33=FALSE),C34)","v":false},null,"Less than 20% of job"]
[null,null,null,null,null,{"$f":"SUM(E32:E34)","v":0}]
["Overhead",null,null,null,null,null,"The lower the overhead the higher the additional fixed fee percentage"]
["% Additional Fee",null,null,null,null,null,"     Qualifier"]
[null,null,0,false,{"$f":"IF(AND(D38=TRUE,D39=FALSE,D40=FALSE,D41=FALSE,D42=FALSE,D43=FALSE),C38)","v":false},null,"Office Overhead > 200%   or ","Field (CEI) Overhead > 150%"]
[null,null,0.5,false,{"$f":"IF(AND(D39=TRUE,D38=FALSE,D40=FALSE,D41=FALSE,D42=FALSE,D43=FALSE),C39)","v":false},null,"Office Overhead > 180% and ≤ 200%  or","Field (CEI) Overhead > 130% and ≤ 150%"]
[null,null,1,false,{"$f":"IF(AND(D40=TRUE,D38=FALSE,D39=FALSE,D41=FALSE,D42=FALSE,D43=FALSE),C40)","v":false},null,"Office Overhead > 160% and ≤ 180%  or","Field (CEI) Overhead > 120% and ≤ 130%"]
[null,null,2,false,{"$f":"IF(AND(D41=TRUE,D38=FALSE,D39=FALSE,D40=FALSE,D42=FALSE,D43=FALSE),C41)","v":false},null,"Office Overhead > 140% and ≤ 160%  or","Field (CEI) Overhead > 110% and ≤ 120%"]
[null,null,3,false,{"$f":"IF(AND(D42=TRUE,D39=FALSE,D40=FALSE,D41=FALSE,D43=FALSE,D44=FALSE),C42)","v":false},null,"Office Overhead > 120% and ≤140%  or","Field (CEI) Overhead >  90% and ≤ 110%"]
[null,null,4,false,{"$f":"IF(AND(D43=TRUE,D38=FALSE,D39=FALSE,D40=FALSE,D41=FALSE,D42=FALSE),C43)","v":false},null,"Office Overhead ≤ 120%  or","Field (CEI) Overhead ≤ 90%"]
[null,null,null,null,null,{"$f":"SUM(E38:E43)","v":0}]
["Total Fixed Fee  =",null,null,null,null,null,{"$f":"(8+SUM(F23,F17,F29,F35,F44))/100","v":0.08}]
["Completed By",null,null,null,null,null," Firm"," Date"]

{"sheet":"PHOTO FORM REVISIONS","index":5,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'COVER SHEET'!G46","v":"Version 1.10"}]
["REVISIONS TO EXCEL MAN-DAY SPREADSHEET"]
["SURVEY FORMS"]
["Date ",null,"Worksheet Revised","Version","Description",null,null,null,null,null,null,null,"Revised By"]