{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["COVER SHEET","SURVEY SUMMARY","SURVEY MANDAY ESTIMATE","SURVEY LABOR & DIRECT EXPENSES","DESIGN MANDAYS A","DESIGN MANDAYS B","DESIGN LABOR & AVG. M.D.","DESIGN DIRECT EXPENSES","FEE PROPOSAL","FEE PROPOSAL SUMMARY","Net Fee Calculator","SURVEY FORMS REVISIONS","DESIGN FORM REVISIONS","SURVEY MANDAY FORM INSTRUCTIONS","Module1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":14,"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":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[63,0,63,2],[64,0,64,2],[55,0,55,8],[57,0,57,2],[60,0,60,2],[61,0,61,2],[10,0,10,8],[24,0,29,8],[62,0,62,2],[54,0,54,2],[47,0,47,8],[49,0,49,2],[50,0,50,2],[52,0,52,2],[15,1,15,7],[13,1,13,7],[36,3,36,6],[39,0,39,1],[38,0,38,1],[42,0,42,1],[17,2,17,6],[19,2,19,6],[23,0,23,8],[34,3,34,6],[35,3,35,6],[37,3,37,6],[45,0,45,1],[44,0,44,1],[41,0,41,1],[38,3,38,6],[39,3,39,6]]}
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"Instructions:\")","v":"Instructions:"}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"(Enter state route number, project description,county, consultant's name,\")","v":"(Enter state route number, project description,county, consultant's name,"}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"prepared by name, and date prepared.  This information will be transferred\")","v":"prepared by name, and date prepared.  This information will be transferred"}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"to all other sheets. The date prepared must be entered in the appropriate\")","v":"to all other sheets. The date prepared must be entered in the appropriate"}]
[null,{"$f":"IF(ISNONTEXT(A43),\"\",\"cell on this sheet to remove these instructions prior to printing.)\")","v":"cell on this sheet to remove these instructions prior to printing.)"}]
[]
["TENNESSEE DEPARTMENT OF TRANSPORTATION"]
[]
["MANDAY ESTIMATE AND FEE PROPOSAL"]
[]
["Click Here to Select Type of Proposal from Drop Down List"]
[]
[]
[null,"<Route>"]
[]
[null,"<Description>"]
[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,"<County>",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,"<000000.00>",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"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"<Consultant>"]
[null,null,null,"<Consultant Contact Person>"]
[null,null,null,"<address>"]
[null,null,null,"<phone>"]
["Prepared By:",null,null,"<fax>"]
["<Name>",null,null,"<e-mail>"]
[]
["Date prepared:"]
["<Date>"]
[]
["Project No.:"]
["<00000-0000-00>",null,null,null,null,null,"Version 2.27"]
[]
["Checklist of discussion items for TDOT Consultant Survey Projects"]
[]
["TDOT Project Name:"]
["Geopak Job Number (GPK): "]
[]
["Survey Manual:"]
[]
["CADD Standards:",null,null,"As shown in latest revision of CADD Guidelines published at "]
["http://www.tdot.state.tn.us/Chief_Engineer/assistant_engineer_design/design/design.htm"]
[]
["Scope:",null,null,"As outlined in Manday Estimate Spreadsheet (ver2.21) as "]
[null,null,null,"negotiated for this project outlined below:"]
[]
["Completions Dates: "]
["FSR Phase:"]
["Phase 1:"]
["Phase 2:"]
["Phase 3:"]
[]
["Coordination with other projects and points of contact:"]
[]
["Utilities:  Will SUE firm be employed?  If yes, identify firm and list SUE responsibilities."]
[]
[]
[]
[]
[null,"List of utilities in this county that may be located on this project."]
[]
[]
[]
[]
[]
["Tax Maps:"]
[]
[]
[]
["Other Considerations:"]

{"sheet":"SURVEY SUMMARY","index":1,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,5,6,6],[28,2,28,3],[35,2,35,3]]}
[]
[]
["Route:",{"$f":"'COVER SHEET'!B14","v":"<Route>"},null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
["Description:",{"$f":"'COVER SHEET'!B16","v":"<Description>"}]
["County:",{"$f":"'COVER SHEET'!C18","v":"<County>"}]
["Consultant:",{"$f":"'COVER SHEET'!D35","v":"<Consultant>"},null,null,null,"INPUT SIDEROADS LT & RT OF CENTERLINE"]
["Prepared By:",{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
["Project No.:",{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"},null,null,null,"Sideroad Name","Length (feet)"]
["Mainline Project Length:",0,"(miles)"]
["Number of Sideroads:",{"$f":"26-COUNTBLANK(F9:F34)","v":0},"Length:",{"$f":"G35","v":0},"(feet)"]
["Office Travel Time per day (hrs):",0]
["Crew Travel Time per day (hrs):",0]
["Crew Work per day (hrs):",8]
[]
["Number of Existing Lanes:",0,"Proposed:",0]
["Number of Driveways/Ramps:",0]
[]
["Location:"]
["Existing Road:",1,"Rural:",0.5]
["New Alignment:",{"$f":"100%-B19","v":0},"     Urban:",0.5]
[null,null," Business:",{"$f":"1-D19-D20","v":0}]
[]
["Rural Land Character:     Woods:",0.3,"Terrain:   Flat",0]
["   Pasture:",0.7,"     Rolling:",0.6]
["Cultivated:",{"$f":"100%-B23-B24","v":0},"        Hilly:",0.4]
[null,null,"Mountains:",{"$f":"100%-D23-D24-D25","v":0}]
[]
["Distance to Nearest Benchmark:",0,"miles"]
["Number of Survey Updates",0,"R.O.W. Staking:"]
[null,null,"Iron Pins",0]
["Aerial Mapping Available:",null,"1 Stake Points",0]
[null,null,"2 Stake Points",0]
[]
["Approximate Obscured Area:",1,"    Use 100% if no mapping is available."]
["Proposed DTM Width:",0,"(ft)",null,null,"Total Length",{"$f":"SUM(G9:G34)","v":0}]
[null,null,"Geotechnical Staking:"]
["Drainage:",null,"Points",0]
["    Approx. Number of Culvert Sites:",{"$f":"B9*5280/500","v":0}]
["Number of Bridges:  Small:",0,"Medium",0,"      Large:",0]
[]
["Approx. Number of Property Tracts:",0,null,null,"Number of Railroad Crossings:",0]
[]
["Indicate Utilities Present:","Elect.:",null,"Telephone:",null,"Cable TV:"]
[null,"Water:",null,"                                                Sewer:",null,"Gas:"]
[null,"Fiber Optic:",null,null,null,"Petroleum Pipeline:"]
[]
[null,null,null,"Comments on Difficulty, Conditions or Other Considerations:"]
[]
[]
[]
[]
[null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]

{"sheet":"SURVEY MANDAY ESTIMATE","index":2,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,11,11,11],[10,12,11,12]]}
["ESTIMATE FOR FIELD SURVEYS"]
["PROJECT DESCRIPTION:",null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"},null,"PROJECT DESCRIPTION:",null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["Route:",{"$f":"'SURVEY SUMMARY'!B3","v":"<Route>"},null,null,null,null,null,null,null,null,null,null,"Route:",{"$f":"'SURVEY SUMMARY'!B3","v":"<Route>"}]
["Description:",{"$f":"'SURVEY SUMMARY'!B4","v":"<Description>"},null,null,null,null,null,null,null,null,null,null,"Description:",{"$f":"'SURVEY SUMMARY'!B4","v":"<Description>"}]
["County:",{"$f":"'SURVEY SUMMARY'!B5","v":"<County>"},null,null,null,"Prepared By:",{"$f":"'SURVEY SUMMARY'!B7","v":"<Name>"},null,null,null,null,null,"County:",{"$f":"'SURVEY SUMMARY'!B5","v":"<County>"}]
["Consultant:",{"$f":"'SURVEY SUMMARY'!B6","v":"<Consultant>"},null,null,null,null,null,"Date Prepared:",{"$f":"'SURVEY SUMMARY'!D3","v":"<Date>"},null,null,null,"Consultant:",{"$f":"'SURVEY SUMMARY'!B6","v":"<Consultant>"}]
["Project No.:",{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"},null,null,null,null,null,null,null,null,null,null,"Project No.:",{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"}]
["TOTAL LENGTH(miles):",{"$f":"ROUND('SURVEY SUMMARY'!B9+('SURVEY SUMMARY'!D10/5280)-(O22/5280),3)","v":0},null,null,null,null,null,null,null,null,null,null,null,"TOTAL LENGTH(miles):",{"$f":"'SURVEY SUMMARY'!B9+('SURVEY SUMMARY'!D10/5280)-(('SURVEY SUMMARY'!B10*0.5*'SURVEY SUMMARY'!B35)/5280)","v":0}]
["OFFICE TRAVEL TIME PER DAY(hrs):",{"$f":"'SURVEY SUMMARY'!B11","v":0},null,null,null,null,null,null,null,null,null,null,"Date Prepared:",{"$f":"'SURVEY SUMMARY'!D3","v":"<Date>"},null,"Prepared By:",{"$f":"'SURVEY SUMMARY'!B7","v":"<Name>"}]
["CREW TRAVEL TIME PER DAY(hrs):",{"$f":"'SURVEY SUMMARY'!B12","v":0}]
["ACTIVITY","PROJECT MANAGER","OFFICE CADD TECH.","PARTY CHIEF"," INSTRUMENT MAN","RODMAN","RODMAN","FLAGGER","FLAGGER",null,null,"OFFICE DIFFICULTY","FIELD    DIFFICULTY"]
[null,"PM","O","P","I","R","R","F","F","Total",null,null,null,null,"REMARKS"]
["1.Establish & Stake Alignments",{"$f":"ROUND(L13*B8/2.48548,1)","v":0},{"$f":"ROUND(L13*B8/3.7282,1)","v":0},{"$f":"ROUND(M13*B8/0.497096,1)","v":0},{"$f":"D13","v":0},{"$f":"D13","v":0},{"$f":"D13","v":0},null,null,{"$f":"ROUND(SUM(B13:I13),1)","v":0},"Align.",0.5,0.5]
["2. Update Survey",{"$f":"ROUND(0.5*D14*L14,1)","v":0},{"$f":"ROUND(0.5*D14*L14,1)","v":0},{"$f":"ROUND(3*'SURVEY SUMMARY'!B29*M14,1)","v":0},0,0,0,null,null,0,"Update",1,1,{"$f":"'SURVEY SUMMARY'!B29","v":0},"Survey Updates"]
["3. Control Traverses",{"$f":"ROUND(L15*B8/1.8641098,1)","v":0},{"$f":"ROUND(L15*B8/6.213699,1)","v":0},{"$f":"ROUND(M15*B8/1.49128787,1)","v":0},0,0,0,null,null,0,"Control",1,0.5]
["4. Set Aerial Control",{"$f":"ROUND(IF(SUM(N16:O16),1,0),1)","v":0},0,{"$f":"ROUND((N16+O16)/6*M16,1)","v":0},0,0,0,null,null,0,"Aerial",0,0,0,0,"NUMBER HORIZONTAL  & NUMBER VERTICAL POINTS"]
["5. Bench Levels",{"$f":"ROUND(L17*B8/6.213699,1)","v":0},{"$f":"ROUND(L17*B8/6.213699,1)","v":0},{"$f":"ROUND(M17*B8/1.8641098,1)","v":0},0,0,0,null,null,0,"Levels",1,1,"ZERO IF NOT REQUIRED"]
["6. Develop Digital Terrain Model",{"$f":"ROUND((B8*L18)/1.8641098+(2-N21)*0.05*(B8*L18)/1.8641098,1)","v":0},{"$f":"ROUND((B8*L18)/1.242739898+(2-N21)*0.2*(B8*L18)/1.242739898,1)","v":0},{"$f":"ROUND((M18*N18*B8*Q18/328.083333/0.09320549)-(2-N21)*0.4*(M18*N18*B8*Q18/328.833333/0.09320549),1)","v":0},0,0,0,null,null,0,"DTM",1,1,{"$f":"'SURVEY SUMMARY'!B34","v":1},"PERCENT SKIPS",null,{"$f":"'SURVEY SUMMARY'!B35","v":0},"DTM WIDTH(feet)"]
["7. R.O.W.,Deed & Utility Research",{"$f":"IF(B8=0,\" \",ROUND(N19/20*L19,1))","v":" "},{"$f":"ROUND(N19/30*L19,1)","v":0},null,null,null,null,null,null,0,"Research",1,1,{"$f":"'SURVEY SUMMARY'!B41","v":0},"NUMBER OF TRACTS"]
["8. Property Owner Contact",{"$f":"IF(B9=0,\" \",(ROUND((L20*(N19/15)),1)))","v":" "},null,{"$f":"IF(B9=0,\" \",(ROUND((M20*(N19/15)),1)))","v":" "},null,null,null,null,null,0,"Contacts",1,1]
["9. Locate Property & Pres. R.O.W. Lines",{"$f":"IF(B9=0,\" \",ROUND(N19/10*L21,1))","v":" "},{"$f":"IF(B9=0,\" \",ROUND(N19/10*L21,1))","v":" "},{"$f":"IF(B9=0,\" \",ROUND(N19/6*(M21),1))","v":" "},{"$f":"D21","v":" "},{"$f":"D21","v":" "},{"$f":"D21","v":" "},null,null,0,"Property",1,1,1,"DO NOT EDIT THESE CELLS"]
["10. Obtain Topo/Verify Aerial",{"$f":"ROUND((B8*L22)/3.106849,1)","v":0},{"$f":"ROUND((B8*L22)/1.5534249+(2-N21)*0.65*B8*L22/1.5534249,1)","v":0},{"$f":"ROUND((B8*M22)/0.3106849+(2-N21)*0.5*(B8*M22)/0.3106849,1)","v":0},0,0,0,null,null,0,"Topo",1,1,{"$f":"'SURVEY SUMMARY'!B10*'SURVEY SUMMARY'!B35*0.5","v":0},{"$f":"MIN('SURVEY SUMMARY'!G35,N22)","v":0}]
["11. Drainage Surveys (Culverts)",{"$f":"ROUND('SURVEY SUMMARY'!B38*L23/15,1)","v":0},{"$f":"ROUND('SURVEY SUMMARY'!B38*L23/15,1)","v":0},{"$f":"ROUND('SURVEY SUMMARY'!B38*M23/4,1)","v":0},0,0,0,null,null,0,"Culverts",1,1]
["12. Bridge Surveys (bridge details, stream alignment, topo, profile, flood plain sections, high water, etc.",{"$f":"ROUND(((N24+O24+P24)/2)*L24,1)","v":0},null,{"$f":"ROUND((N24+O24*1.5+P24*2)*M24,1)","v":0},0,0,0,null,null,0,"Bridges",1,1,{"$f":"'SURVEY SUMMARY'!B39","v":0},{"$f":"'SURVEY SUMMARY'!D39","v":0},{"$f":"'SURVEY SUMMARY'!F39","v":0},"NUMBER OF SMALL, MEDIUM, LARGE BRIDGES"]
["13. Railroad Surveys",{"$f":"IF(B9=0,\" \",ROUND(N25*L25/3,1))","v":" "},{"$f":"IF(B9=0,\" \",ROUND(N25*L25/3,1))","v":" "},{"$f":"IF(B9=0,\" \",ROUND((N25*M25/1.5),1))","v":" "}," "," "," ",null,null,0,"RR",1,1,{"$f":"'SURVEY SUMMARY'!F41","v":0},"NUMBER OF RR CROSSINGS"]
["14. Utilities",{"$f":"ROUND(B8*L26/6.213699,1)","v":0},{"$f":"ROUND(B8*L26/2.485479,1)","v":0},{"$f":"ROUND(B8*M26/0.37282196,1)","v":0},0,0,0,null,null,0,"Utilities",1,1,{"$f":"N27+O27+P27+Q27+N28+O28+P28+Q28","v":5},"Number of Different Utilities Involved"]
["15. Stake R.O.W. & Easements",{"$f":"ROUND(C27/8+D27/7,1)*L27","v":0},{"$f":"ROUND(('SURVEY SUMMARY'!D30+'SURVEY SUMMARY'!D31+'SURVEY SUMMARY'!D32)/150,1)*L27","v":0},{"$f":"ROUND((('SURVEY SUMMARY'!D30/25+'SURVEY SUMMARY'!D31/40+'SURVEY SUMMARY'!D32/35)*M27),1)","v":0},0,{"$f":"E27","v":0},{"$f":"F27","v":0},null,null,0,"R.O.W.",1,1,false,true,true,true,"DO NOT EDIT THESE CELLS"]
["16. Stake Sounding Holes",{"$f":"ROUND((L28*'SURVEY SUMMARY'!D37)/300,1)","v":0},{"$f":"ROUND((L28*'SURVEY SUMMARY'!D37)/150,1)","v":0},{"$f":"ROUND((M28*'SURVEY SUMMARY'!D37)/40,1)","v":0},0,{"$f":"E28","v":0},{"$f":"F28","v":0},null,null,0,"Geotech.",1,1,true,true,false,false]
["17. Note Reduction & other Calculations",{"$f":"ROUND(B8*1,1)*L29","v":0},null,null,null,null,null,null,null,0,null,1,null,{"$f":"'SURVEY SUMMARY'!D30","v":0},{"$f":"'SURVEY SUMMARY'!D31","v":0},{"$f":"'SURVEY SUMMARY'!D32","v":0},"Number of IP's, 1-stake, 2-stakes"]
["18. Plot Plan, Profiles, Property Map, Drainage Map, Bridge Survey, Control Point Table, etc.",{"$f":"IF(B9=0,\" \",ROUND(0.25*C30*L30,1))","v":" "},{"$f":"ROUND(B8*L30*1.6093472,1)","v":0},null,null,null,null,null,null,{"$f":"SUM(B30:I30)","v":0},"Plotting",1,null,null,null,{"$f":"'SURVEY SUMMARY'!D37","v":0},"Number of Geotechnical Staking Points"]
["19. Supervision",{"$f":"ROUND(B8 * 1*L31,1)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(B31:I31)","v":0},null,1,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,SUM(J13:J31)/'SURVEY SUMMARY'!$B$9,(J35-J34)/'SURVEY SUMMARY'!$B$9)","v":{"$error":"#DIV/0!"}},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"8 - Hr MD/MILE not including travel\",(('SURVEY SUMMARY'!$B$13&\" - Hr MD/MILE not including travel\")))","v":"8 - Hr MD/MILE not including travel"}]
["20. Travel Time (8 HOUR MAN-DAYS)",{"$f":"ROUND((((B9/8)*3)*L32),1)","v":0},{"$f":"ROUND(((B9/8)*1*L32),1)","v":0},{"$f":"ROUND((SUM(D13:D28) *(B10/8)/((8-B10)/8))*M32,1)","v":0},{"$f":"ROUND(((SUM(E13:E28) *(B10/8)/((8-B10)/8))*M32),1)","v":0},{"$f":"E32","v":0},{"$f":"E32","v":0},{"$f":"ROUND(((SUM(H13:H28)*B10/8)*M32),1)","v":0},{"$f":"ROUND(((SUM(I13:I28)*B10/8)*M32),1)","v":0},{"$f":"ROUND(SUM(B32:I32),1)","v":0},null,1,1,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,J33/'SURVEY SUMMARY'!$B$9,J35/'SURVEY SUMMARY'!$B$9)","v":{"$error":"#DIV/0!"}},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"8 - Hr MD/MILE\",(('SURVEY SUMMARY'!$B$13&\" - Hr MD/MILE\")))","v":"8 - Hr MD/MILE"}]
["TOTALS (8 HOUR MAN-DAYS)",{"$f":"ROUND(SUM(B13:B32),1)","v":0},0,{"$f":"ROUND(SUM(D13:D32),1)","v":0},0,0,0,0,0,{"$f":"ROUND(SUM(B33:I33),1)","v":0},null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13>8,SUM(J13:J31)/'SURVEY SUMMARY'!$B$9,\"\")","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13>8,\"8 - Hr MD/MILE not including travel\",\"\")","v":""}]
[{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((\"21. Travel Time (\"))&'SURVEY SUMMARY'!$B$13&\" HOUR MAN-DAYS)\")","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((B9/8)*3,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((B9/8)*1,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(SUM(D13:D28)*(B10/'SURVEY SUMMARY'!B13)/(('SURVEY SUMMARY'!B13-B10)/'SURVEY SUMMARY'!B13),1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(SUM(E13:E28)*(B10/'SURVEY SUMMARY'!B13)/(('SURVEY SUMMARY'!B13-B10)/'SURVEY SUMMARY'!B13),1))","v":""},{"$f":"E34","v":""},{"$f":"F34","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(SUM(H13:H28)*B10/'SURVEY SUMMARY'!B13,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(SUM(I13:I28)*B10/'SURVEY SUMMARY'!B13,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(SUM(B34:I34),1))","v":""},null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13>8,J33/'SURVEY SUMMARY'!$B$9,\"\")","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13>8,\"8 - Hr MD/MILE\",\"\")","v":""}]
[{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((\"TOTALS (ADJ. TO 8 & \"))&'SURVEY SUMMARY'!$B$13&\" HR MAN-DAYS)\")","v":""},null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((((D33-D32)*8/'SURVEY SUMMARY'!B13)+D34)*0.96,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((((E33-E32)*8/'SURVEY SUMMARY'!$B$13)+E34)*0.96,1))","v":""},{"$f":"E35","v":""},{"$f":"E35","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((((H33-H32)*8/'SURVEY SUMMARY'!$B$13)+H34)*0.96,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((((I33-I32)*8/'SURVEY SUMMARY'!$B$13)+I34)*0.96,1))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(SUM(D35:I35),1)+B33+C33)","v":""}]
[{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((\"TOTAL CALENDAR DAYS SAVED\")))","v":""},null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",D33-D35)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",E33-E35)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",F33-F35)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",G33-G35)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",H33-H35)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",I33-I35)","v":""}]
[]
[]
[null,null,null," ",null," "]

{"sheet":"SURVEY LABOR & DIRECT EXPENSES","index":3,"n_rows":60,"n_cols":25,"rows_kept":60,"cut":false,"hidden":false,"merged":[[27,4,27,8],[28,4,28,8]]}
[]
[]
[null,null,"SURVEY DIRECT LABOR COST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"SURVEY DIRECT EXPENSES"]
[]
[null,"PROJECT DESCRIPTION:",null,null,null,null,null,null,null,null,null,null,"PROJECT DESCRIPTION:"]
[null,"ROUTE:",null,{"$f":"'SURVEY SUMMARY'!B3","v":"<Route>"},null,null,null,null,null,null,null,null,"ROUTE:",{"$f":"'SURVEY SUMMARY'!B3","v":"<Route>"}]
[null,"DESCRIPTION:",null,{"$f":"'SURVEY SUMMARY'!B4","v":"<Description>"},null,null,null,null,null,null,null,null,"DESCRIPTION:",{"$f":"'SURVEY SUMMARY'!B4","v":"<Description>"}]
[null,"COUNTY:",null,{"$f":"'SURVEY SUMMARY'!B5","v":"<County>"},null,null,null,null,null,null,null,null,"COUNTY:",{"$f":"'SURVEY SUMMARY'!B5","v":"<County>"},null,"Prepared By:",{"$f":"'SURVEY SUMMARY'!B7","v":"<Name>"}]
[null,"CONSULTANT:",null,{"$f":"'SURVEY SUMMARY'!B6","v":"<Consultant>"},null,"Prepared By:",{"$f":"'SURVEY SUMMARY'!B7","v":"<Name>"},null,null,null,null,null,"CONSULTANT:",{"$f":"'SURVEY SUMMARY'!B6","v":"<Consultant>"},null,"Date Prepared:",{"$f":"'SURVEY SUMMARY'!D3","v":"<Date>"}]
[null,"TOTAL LENGTH(miles):",null,{"$f":"'SURVEY SUMMARY'!B9+'SURVEY SUMMARY'!D10/5280","v":0},null,"Date Prepared:",{"$f":"'SURVEY SUMMARY'!D3","v":"<Date>"},null,null,null,null,null,"TOTAL LENGTH(miles):",{"$f":"'SURVEY SUMMARY'!B9+'SURVEY SUMMARY'!D10/5280","v":0},null,"Project No.:",{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"}]
[]
[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,null,null,null,null,null,null,null,null,null,"Reproduction Costs"]
[null,null,null,"Abbrv.","Personnel Classification"," 8 - Hr Man-Days",{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",(('SURVEY SUMMARY'!$B$13&\" - Hr Man-Days\")))","v":""},"Approved Hours","Rate Per Hr","Direct Labor",{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"* Premium\")","v":""}]
[null,null,1,"PM","PROJECT MANAGER",{"$f":"'SURVEY MANDAY ESTIMATE'!B33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"\")","v":""},8,0,{"$f":"F16*8*I16","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"\")","v":""},null,null,"Item Description",null,"Number / Unit","Unit Price"]
[null,null,2,"O","OFFICE CADD TECH.",{"$f":"'SURVEY MANDAY ESTIMATE'!C33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"\")","v":""},8,0,{"$f":"F17*8*I17","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"\")","v":""},null,null,"Xerographic Bond",null,0,0,{"$f":"Q17*P17","v":0}]
[null,null,3,"P","PARTY CHIEF",{"$f":"'SURVEY MANDAY ESTIMATE'!D33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",('SURVEY MANDAY ESTIMATE'!$D$35))","v":""},{"$f":"'SURVEY SUMMARY'!$B$13","v":8},0,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,F18*8*I18,G18*H18*I18)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((G18*('SURVEY SUMMARY'!$B$13-8))*(0.5*I18)))","v":""},null,null,"Blueline Fullsize",null,0,0,{"$f":"Q18*P18","v":0}]
[null,null,4,"I","INSTR. MAN",{"$f":"'SURVEY MANDAY ESTIMATE'!E33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",('SURVEY MANDAY ESTIMATE'!$E$35))","v":""},{"$f":"'SURVEY SUMMARY'!$B$13","v":8},0,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,(F19*8*I19),(G19*H19*I19))","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((G19*('SURVEY SUMMARY'!$B$13-8))*(0.5*I19)))","v":""},null,null,"Photo-Copies",null,0,0,{"$f":"Q19*P19","v":0}]
[null,null,5,"R","RODMAN",{"$f":"'SURVEY MANDAY ESTIMATE'!F33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",('SURVEY MANDAY ESTIMATE'!$F$35))","v":""},{"$f":"'SURVEY SUMMARY'!$B$13","v":8},0,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,(F20*8*I20),(G20*H20*I20))","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((G20*('SURVEY SUMMARY'!$B$13-8))*(0.5*I20)))","v":""},null,null,"Deeds",null,0,0,{"$f":"Q20*P20","v":0}]
[null,null,6,"R","RODMAN",{"$f":"'SURVEY MANDAY ESTIMATE'!G33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",('SURVEY MANDAY ESTIMATE'!$G$35))","v":""},{"$f":"'SURVEY SUMMARY'!$B$13","v":8},0,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,(F21*8*I21),(G21*H21*I21))","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((G21*('SURVEY SUMMARY'!$B$13-8))*(0.5*I21)))","v":""},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(R17:R20)","v":0}]
[null,null,7,"F","FLAGGER",{"$f":"'SURVEY MANDAY ESTIMATE'!H33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",('SURVEY MANDAY ESTIMATE'!$H$35))","v":""},{"$f":"'SURVEY SUMMARY'!$B$13","v":8},0,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,(F22*8*I22),(G22*H22*I22))","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((G22*('SURVEY SUMMARY'!$B$13-8))*(0.5*I22)))","v":""},null,"Travel"]
[null,null,8,"F","FLAGGER",{"$f":"'SURVEY MANDAY ESTIMATE'!I33","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",('SURVEY MANDAY ESTIMATE'!$I$35))","v":""},{"$f":"'SURVEY SUMMARY'!$B$13","v":8},0,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,(F23*8*I23),(G23*H23*I23))","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",((G23*('SURVEY SUMMARY'!$B$13-8))*(0.5*I23)))","v":""},null,null,"Survey Crew Travel Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"From:"]
[null,null,null,null,"TOTALS",{"$f":"SUM(F16:F23)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",SUM(G18:G23))","v":""},null,null,{"$f":"SUM(J16:J23)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",SUM(K18:K23))","v":""},null,"To:"]
[null,null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"TOTALS (Combined 8 & 10 Hour Days)\")","v":""},null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",'SURVEY MANDAY ESTIMATE'!J35)","v":""}]
[]
[null,null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"Direct Labor Cost Per   8 - Hour Man-Day\",((\"Average Direct Labor Cost Per (Combined 8 - Hour & \"))&'SURVEY SUMMARY'!$B$13&\" - Hour) Man-Day\")","v":"Direct Labor Cost Per   8 - Hour Man-Day"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&'SURVEY SUMMARY'!$B$13&\" HR MAN-DAYS)\")","v":"                          NA"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&'SURVEY SUMMARY'!$B$13&\" HR MAN-DAYS)\")","v":"                          NA"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&'SURVEY SUMMARY'!$B$13&\" HR MAN-DAYS)\")","v":"                          NA"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"                          NA\",((\"TOTALS (ADJ. TO \"))&'SURVEY SUMMARY'!$B$13&\" HR MAN-DAYS)\")","v":"                          NA"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,J25/F25,J25/(F16+F17+G25))","v":{"$error":"#DIV/0!"}},null,null,null,null,"Number of Trips","No. of Miles/No. of People","* RATE"]
[null,null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",(\"Modified 8 - Hour Labor Cost Per Man-Day\"))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"NOT USED\",(('SURVEY SUMMARY'!$B$13&\" - Hr Man-Days\")))","v":"NOT USED"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"NOT USED\",(('SURVEY SUMMARY'!$B$13&\" - Hr Man-Days\")))","v":"NOT USED"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"NOT USED\",(('SURVEY SUMMARY'!$B$13&\" - Hr Man-Days\")))","v":"NOT USED"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"NOT USED\",(('SURVEY SUMMARY'!$B$13&\" - Hr Man-Days\")))","v":"NOT USED"},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J25/((((SUM(G18:G23))*'SURVEY SUMMARY'!$B$13)/8)+(F16+F17)))","v":""},null,null,"Travel Day Per Diem  ",null,{"$f":"IF('SURVEY SUMMARY'!B13=8,ROUNDUP(0.2*'SURVEY MANDAY ESTIMATE'!D33,0),ROUNDUP(0.2*'SURVEY MANDAY ESTIMATE'!D$35,0))","v":0},0,0,{"$f":"O29*P29*Q29","v":0},null,null,null,null,null,null,{"$f":"(ROUNDUP('SURVEY MANDAY ESTIMATE'!D33*0.2,0))*P29*Q29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non Travel Day Per Diem",null,{"$f":"IF('SURVEY SUMMARY'!B13=8,ROUNDUP(0.8*'SURVEY MANDAY ESTIMATE'!D33,0),ROUNDUP(0.8*'SURVEY MANDAY ESTIMATE'!D$35,0))","v":0},0,0,{"$f":"O30*P30*Q30","v":0},null,null,null,null,null,null,{"$f":"ROUNDUP('SURVEY MANDAY ESTIMATE'!D33*0.8,0)*P30*Q30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transportation",null,{"$f":"IF('SURVEY SUMMARY'!B13=8,ROUNDUP('SURVEY MANDAY ESTIMATE'!D33,0),ROUNDUP('SURVEY MANDAY ESTIMATE'!D$35,0))","v":0},0,0,{"$f":"O31*P31*Q31","v":0},null,null,null,null,null,null,{"$f":"ROUNDUP('SURVEY MANDAY ESTIMATE'!D33,0)*P31*Q31","v":0}]
[null,null,null,null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"* Premium Labor is only eligible if the survey crew works greater than a 40 hour work week.\")","v":""},null,null,null,null,null,"Lodging  ",null,{"$f":"IF('SURVEY SUMMARY'!B13=8,ROUNDUP(('SURVEY MANDAY ESTIMATE'!D33)*(4/5),0),ROUNDUP(('SURVEY MANDAY ESTIMATE'!D$35)*(4/5),0))","v":0},0,0,{"$f":"O32*P32*Q32","v":0},null,null,null,null,null,null,{"$f":"ROUNDUP('SURVEY MANDAY ESTIMATE'!D33*4/5,0)*P32*Q32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(R29:R32)","v":0},null,null,null,null,null,{"$f":"SUM(Y29:Y32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Office Personnel Travel Calculations",null,null,null,null,null,null,null,null,null,null,{"$f":"S21+Y33+S43+S52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"From:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"To:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Trips","No. of Miles/No. of People","* RATE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Travel Day Per Diem  ",null,0,0,0,{"$f":"O39*P39*Q39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non Travel Day Per Diem",null,0,0,0,{"$f":"O40*P40*Q40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transportation ",null,0,0,0,{"$f":"O41*P41*Q41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lodging  ",null,0,0,0,{"$f":"O42*P42*Q42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other Expenses",null,null,null,null,"Subtotal",{"$f":"SUM(R39:R42)","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,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(R45:R51)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT EXPENSES",null,null,null,null,null,{"$f":"SUM(S21,S43,S33,S52)","v":0}]
[null,null,null,null,{"$f":"'SURVEY MANDAY ESTIMATE'!I2","v":"Version 2.27"}]
[]
[]
[]
[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."]

{"sheet":"DESIGN MANDAYS A","index":4,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"DESIGN MANDAY ESTIMATE",null,"PAGE A"]
[]
[null,"ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":"<Route>"}]
[null,"DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":"<Description>"}]
[null,"COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":"<County>"}]
[null,"CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":"<Consultant>"}]
[null,"Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
[null,"Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
[null,"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"},null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
[]
["I.","PROJECT LENGTH",null,null,{"$f":"IF(ISBLANK(A53),\"(enter project length in miles)\",\"\")","v":"(enter project length in miles)"},null,"MILES"]
[]
[]
["II.","TYPICAL SECTIONS",{"$f":"IF(ISBLANK(A53),\"(enter length of appropriate section or sections)\",\"\")","v":"(enter length of appropriate section or sections)"}]
[null,"A.  NEW ALIGNMENT"]
[null,"      1.  Freeway - Controlled Access",null,"140 M.D./Mile",null,{"$f":"IF(ISBLANK(E16),0,PRODUCT(E16,140))","v":0},"MANDAYS"]
[null,"      2.  Non - CA  (w/shoulders)",null,"140 M.D./Mile",null,{"$f":"IF(ISBLANK(E17),0,PRODUCT(E17,140))","v":0},"MANDAYS"]
[null,"      3.  Street (curb & gutter)",null,"150 M.D./Mile",null,{"$f":"IF(ISBLANK(E18),0,PRODUCT(E18,150))","v":0},"MANDAYS"]
[]
[]
[null,"B.  WIDENING"]
[null,"      1.  Freeway - Controlled Access",null,"150 M.D./Mile",null,{"$f":"IF(ISBLANK(E22),0,PRODUCT(E22,150))","v":0},"MANDAYS"]
[" ","      2.  Rural Roadway (w/shoulders)",null,"140 M.D./Mile",null,{"$f":"IF(ISBLANK(E23),0,PRODUCT(E23,140))","v":0},"MANDAYS"]
[null,"      3.  Street (curb & gutter)",null,"155 M.D./Mile",null,{"$f":"IF(ISBLANK(E24),0,PRODUCT(E24,155))","v":0},"MANDAYS"]
[]
[]
[null,"C.  MISCELLANEOUS"]
[null,"      1.  Bridge replacement - rural",null,"110 M.D./Mile   (min. 75)",null,{"$f":"IF(ISBLANK(E28),0,PRODUCT(E28,110))","v":0},"MANDAYS"]
[null,"      2.  Bridge replacement - urban",null,"130 M.D./Mile   (w/c&g)",null,{"$f":"IF(ISBLANK(E29),0,PRODUCT(E29,130))","v":0},"MANDAYS"]
[]
[null,"TOTAL SECTION II",null,null,null,{"$f":"SUM(F16:F29)","v":0},"MANDAYS"]
[null,null,"Place X in applicable sections. If over 20 properties/mile, "]
["III.","OTHER FACTORS","enter actual number of properties/mile in row III-A-5.  "]
[null,null,"(Do not mark more than one block per section.)"]
[null,"A.  PROPERTIES/MILE"]
[null,"      1.  < 8 Tracts/mile",null,"NO CHANGE",null,{"$f":"IF(ISBLANK(E36),0,0*$F$31)","v":0},"MANDAYS"]
[null,"      2.  8-12 Tracts/mile",null,"ADD 5%",null,{"$f":"IF(ISBLANK(E37),0,0.05*$F$31)","v":0},"MANDAYS"]
[null,"      3.  13-16 Tracts/mile",null,"ADD 10%",null,{"$f":"IF(ISBLANK(E38),0,0.1*$F$31)","v":0},"MANDAYS"]
[null,"      4.  17-20 Tracts/mile",null,"ADD 15%",null,{"$f":"IF(ISBLANK(E39),0,0.15*$F$31)","v":0},"MANDAYS"]
[null,"      5.  > 20 Tracts/mile",null,"ADD 15% +",null,{"$f":"(IF(ISBLANK(E40),0,0.15*$F$31+((E40)-20)*0.005*$F$31))","v":0},"MANDAYS"]
[" ",null,null,"(1/2%/Tracts >20)"]
[null,"B.  TERRAIN"]
[" ","      1.  Mountainous or Rolling"]
[null,"           with high cuts/fills",null,"ADD 15%",null,{"$f":"IF(ISBLANK(E44),0,0.15*$F$31)","v":0},"MANDAYS"]
[null,"C.  PLAN SCALE"]
[null,"     1.    100 Scale",null,"DEDUCT 10%",null,{"$f":"IF(ISBLANK(E46),0,-0.1*$F$31)","v":0},"MANDAYS"]
[null,"     2.      50 Scale",null,"NO CHANGE",null,{"$f":"IF(ISBLANK(E47),0,0*$F$31)","v":0},"MANDAYS"]
[null,"     3.      20 Scale",null,"ADD 10%",null,{"$f":"IF(ISBLANK(E48),0,0.1*$F$31)","v":0},"MANDAYS"]
[]
[]
[null,"Subtotal Mandays (page A)",null,null,null,{"$f":"ROUND(SUM(F31,F36:F41,F44,F46:F48),1)","v":0},"MANDAYS"]
[]
[null,{"$f":"IF(ISBLANK(A53),\"(Place X in adjacent block to remove instructions prior to printing.)\",\"Remove X to display instructions.\")","v":"(Place X in adjacent block to remove instructions prior to printing.)"}]
[]
["User Notice: It is the user's responsibility to verify information in this program is correct."]

{"sheet":"DESIGN MANDAYS B","index":5,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,"DESIGN MANDAY ESTIMATE",null,"PAGE B"]
[]
[null,"ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":"<Route>"}]
[null,"DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":"<Description>"}]
[null,"COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":"<County>"}]
[null,"CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":"<Consultant>"}]
[null,"Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
[null,"Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
[null,"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"},null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
[]
["IV.","ADDITIONAL FACTORS"]
[null,"Note:  Consultant to provide supplemental information for items listed below as deemed necessary."]
[null,"A.  SIDEROADS"]
[null,"       (Measure from end of radius return)",null,"110 M.D./ Mile",null,{"$f":"IF(ISBLANK(E14),0,E14*110)","v":0},"MANDAYS"]
[null,"E.  RIGHT-OF-WAY"]
[null,"      1.  Prop. ROW calls on Pres. Layout",null,"NO CHANGE",null,{"$f":"IF(ISBLANK(E16),0,0*E16)","v":0},"MANDAYS"]
[null,"      2.  ROW Detail Sheets Required",null,"2 M.D./ Sheet",null,{"$f":"IF(ISBLANK(E17),0,2*E17)","v":0},"MANDAYS"]
[null,"F.  PUBLIC INVOLVEMENT"]
[null,"      1.  Additional meetings",null,"(enter no. of mandays)",null,{"$f":"IF(ISBLANK(E19),0,E19)","v":0},"MANDAYS"]
[null,"      2.  Special displays & renderings",null,"(enter no. of mandays)",null,{"$f":"IF(ISBLANK(E20),0,E20)","v":0},"MANDAYS"]
[]
[null,"G.  DRAINAGE"]
[null,"      1.  Retention/Detention Ponds",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"      2.  Special details",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"H.  EROSION CONTROL PLANS"]
[null,"      1.  Additional EC phases",null,"5 M.D./Mile",null,{"$f":"IF(ISBLANK(E26),0,E26*5)","v":0},"MANDAYS"]
[null,"      2.  Detention basin design",null,"(enter no. of mandays)",null,{"$f":"IF(ISBLANK(E27),0,E27)","v":0},"MANDAYS"]
[null,"      3.  Special details",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[]
[null,"I.  PERMITS"]
[null,"      1.  Permit drawings",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"      2.  Mitigation plans",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"      3.  Revisions to plans",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"J.  GEOLOGY      "]
[null,"      1.  Retaining Wall Concept sheets",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"      2.  Soils and Geology sheets",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"K.  TRAFFIC CONTROL PLANS"]
[null,"      1.  Complex traffic control design",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"                       (See Note 1)"]
[null,"L.  INTERCHANGES  "]
[null,"      1.  Length of ramps",null,"100 M.D./ Mile",null,{"$f":"IF(ISBLANK(E41),0,E41*100)","v":0},"MANDAYS"]
[null,"    (Length being start of separate profile)"]
[null,"      2.  Urban interchange design",null,"(enter no. of mandays)",null,{"$f":"IF(ISBLANK(E43),0,E43)","v":0},"MANDAYS"]
[null,"M.  NO. OF CONSTRUCTION PROJECTS"]
[null,"      1.  One construction project",null,"NO CHANGE",null,{"$f":"IF(ISBLANK(E45),0,0*E45)","v":0},"MANDAYS"]
[null,"      2.  Additional construction projects",null,"20 M.D./ Project",null,{"$f":"IF(ISBLANK(E46),0,E46*20)","v":0},"MANDAYS"]
[null,"N.  MISCELLANEOUS FACTORS (See Note 2)"]
[null,"      1.  Signal Design",null,"(enter no. of mandays)",null,{"$f":"IF(ISBLANK(E48),0,E48)","v":0},"MANDAYS"]
[null,"      2.  Lighting Design",null,"(enter no. of mandays)",null,{"$f":"IF(ISBLANK(E49),0,E49)","v":0},"MANDAYS"]
[null,"      3.  Signing Design",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"      4.  Constructability Reviews",null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,null,null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,null,null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,null,null,"(enter no. of mandays)",null,0,"MANDAYS"]
[null,"Subtotal Mandays (page B)",null,null,null,{"$f":"ROUND(SUM(F14,F16:F17,F19:F21,F23:F24,F26:F29,F31:F33,F35:F36,F38:F39,F41,F43,F45:F46,F48:F54),1)","v":0},"MANDAYS"]
[null,"Subtotal Mandays (page A)",null,null,null,{"$f":"'DESIGN MANDAYS A'!F51","v":0},"MANDAYS"]
[]
["VI.","TOTAL MANDAYS",null,null,null,{"$f":"F55+F56","v":0},"MANDAYS"]
[]
[null,{"$f":"IF(ISBLANK(A60),\"(Place X in adjacent block to remove instructions prior to printing.)\",\"Remove X to display instructions.\")","v":"(Place X in adjacent block to remove instructions prior to printing.)"}]
[]
[null,"1 - Not to be used without pre-approval by Assistant Director."]
[null,"2 - Mandays for signal, lighting, and signing design, if applicaple, must be pre-approved."]
[null,"     A separate proposal is to be submitted for review by the appropriate TDOT personnel."]
[]
["User Notice: It is the user's responsibility to verify information in this program is correct."]

{"sheet":"DESIGN LABOR & AVG. M.D.","index":6,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["LABOR RATES"]
[]
[null,"ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":"<Route>"},"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"}]
[null,"DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":"<Description>"},"PIN No.:",null,{"$f":"'COVER SHEET'!C20","v":"<000000.00>"}]
[null,"COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":"<County>"}]
[null,"CONSULTANT:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
[null,"Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
[null,"Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
[null,{"$f":"IF(ISBLANK($A$69),\"This sheet calculates the average mandays, labor cost, and average manday rate for each phase of a project.\",\"\")","v":"This sheet calculates the average mandays, labor cost, and average manday rate for each phase of a project."}]
[null,{"$f":"IF(ISBLANK(A69),\"In the shaded blocks, enter the manday rate for each classification of personnel and the estimated percentage\",\"\")","v":"In the shaded blocks, enter the manday rate for each classification of personnel and the estimated percentage"}]
[null,{"$f":"IF(ISBLANK(A69),\"for both the total project and the individual phases.\",\"\")","v":"for both the total project and the individual phases."}]
[null,{"$f":"IF(ISBLANK($A$69),\"Boxes that are not applicable should be left blank.\",\"\")","v":"Boxes that are not applicable should be left blank."},null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["PERSONNEL",null,null,null,"MANDAY RATE"]
["PROJECT MANAGER"]
["PROJECT ENGINEER"]
["ENGINEER"]
["CADD TECHNICIAN"]
["CAD DRAFTER"]
[]
["TOTAL MANDAYS",null,null," ",{"$f":"'DESIGN MANDAYS B'!F58","v":0},"M.D."]
[]
["PERCENTAGE OF TOTAL PROJECT"]
["PRELIMINARY PLANS",null,null,null,null,"%"]
["RIGHT-OF-WAY PLANS ",null,null,null,null,"%"]
["CONSTRUCTION PLANS",null,null,null,null,"%"]
["TOTAL PROJECT",null,null,null,{"$f":"ROUND((SUM(E23:E25)),4)","v":0},"%"]
[]
[]
["PRELIMINARY PLANS",null,{"$f":"E23","v":0},"% OF TOTAL PROJECT"," "," "," "]
[null,null,null,null,"MANDAYS",null,"LABOR COSTS"]
[null,"PROJECT MANAGER",null,"% PREL. PLANS",{"$f":"ROUND( $E$20*($C$29/100)*(C31/100),4)","v":0},"M.D.",{"$f":"E14*ROUND(E31,1)","v":0}]
[null,"PROJECT ENGINEER",null,"% PREL. PLANS",{"$f":"ROUND( $E$20*($C$29/100)*(C32/100),4)","v":0},"M.D.",{"$f":"E15*ROUND(E32,1)","v":0}]
[null,"ENGINEER",null,"% PREL. PLANS",{"$f":"ROUND( $E$20*($C$29/100)*(C33/100),4)","v":0},"M.D.",{"$f":"E16*ROUND(E33,1)","v":0}]
[null,"CADD TECHNICIAN",null,"% PREL. PLANS",{"$f":"ROUND($E$20*($C$29/100)*(C34/100),4)","v":0},"M.D.",{"$f":"E17*ROUND(E34,1)","v":0}]
[null,"CAD DRAFTER",null,"% PREL. PLANS",{"$f":"ROUND($E$20*($C$29/100)*(C35/100),4)","v":0},"M.D.",{"$f":"E18*ROUND(E35,1)","v":0}]
[null,null,{"$f":"ROUND(SUM(C31:C35),4)","v":0},"%"]
[]
[null,"TOTALS PRELIMINARY PLANS",null,null,{"$f":"ROUND(SUM(E31:E35),4)","v":0},"M.D.",{"$f":"SUM(G31:G35)","v":0}]
[null,"PRELIMINARY PLANS AVERAGE RATE PER MANDAY ",null,null,null,null,{"$f":"G38/ROUND(E38,1)","v":{"$error":"#DIV/0!"}}]
[]
["RIGHT-OF-WAY PLANS",null,{"$f":"E24","v":0},"% OF TOTAL PROJECT"]
[null,null,null,null,"MANDAYS",null,"LABOR COSTS"]
[null,"PROJECT MANAGER",null,"% R.O.W. PLANS",{"$f":" ROUND($E$20*($C$41/100)*(C43/100),4)","v":0},"M.D.",{"$f":"E14*ROUND(E43,1)","v":0}]
[null,"PROJECT ENGINEER",null,"% R.O.W. PLANS",{"$f":" ROUND($E$20*($C$41/100)*(C44/100),4)","v":0},"M.D.",{"$f":"E15*ROUND(E44,1)","v":0}]
[null,"ENGINEER",null,"% R.O.W. PLANS",{"$f":" ROUND($E$20*($C$41/100)*(C45/100),4)","v":0},"M.D.",{"$f":"E16*ROUND(E45,1)","v":0}]
[null,"CADD TECHNICIAN",null,"% R.O.W. PLANS",{"$f":" ROUND($E$20*($C$41/100)*(C46/100),4)","v":0},"M.D.",{"$f":"E17*ROUND(E46,1)","v":0}]
[null,"CAD DRAFTER",null,"% R.O.W. PLANS",{"$f":" ROUND($E$20*($C$41/100)*(C47/100),4)","v":0},"M.D.",{"$f":"E18*ROUND(E47,1)","v":0}]
[null,null,{"$f":"ROUND(SUM(C43:C47),4)","v":0},"%"]
[]
[null,"TOTALS RIGHT-OF-WAY PLANS",null,null,{"$f":"ROUND(SUM(E43:E47),1)","v":0},"M.D.",{"$f":"SUM(G43:G47)","v":0}]
[null,"RIGHT-OF-WAY PLANS AVERAGE RATE PER MANDAY",null,null,null,null,{"$f":"G50/ROUND(E50,1)","v":{"$error":"#DIV/0!"}}]
[]
["CONSTRUCTION PLANS",null,{"$f":"E25","v":0},"% OF TOTAL PROJECT"]
[null,null,null,null,"MANDAYS",null,"LABOR COSTS"]
[null,"PROJECT MANAGER",null,"% CONST. PLANS",{"$f":" ROUND($E$20*($C$53/100)*(C55/100),4)","v":0},"M.D.",{"$f":"E14*ROUND(E55,1)","v":0}]
[null,"PROJECT ENGINEER",null,"% CONST. PLANS",{"$f":" ROUND($E$20*($C$53/100)*(C56/100),4)","v":0},"M.D.",{"$f":"E15*ROUND(E56,1)","v":0}]
[null,"ENGINEER",null,"% CONST. PLANS",{"$f":" ROUND($E$20*($C$53/100)*(C57/100),4)","v":0},"M.D.",{"$f":"E16*ROUND(E57,1)","v":0}]
[null,"CADD TECHNICIAN",null,"% CONST. PLANS",{"$f":" ROUND($E$20*($C$53/100)*(C58/100),4)","v":0},"M.D.",{"$f":"E17*ROUND(E58,1)","v":0}]
[null,"CAD DRAFTER",null,"% CONST. PLANS",{"$f":" ROUND($E$20*($C$53/100)*(C59/100),4)","v":0},"M.D.",{"$f":"E18*ROUND(E59,1)","v":0}]
[null,null,{"$f":"ROUND(SUM(C55:C59),4)","v":0},"%"]
[]
[null,"TOTAL MANDAYS CONSTRUCTION PLANS",null,null,{"$f":"SUM(E55:E59)","v":0},"M.D.",{"$f":"SUM(G55:G59)","v":0}]
[null,"CONSTRUCTION PLANS AVG. RATE PER MANDAY",null,null,null,null,{"$f":"G62/ROUND(E62,1)","v":{"$error":"#DIV/0!"}}]
[]
[null,"TOTAL LABOR COSTS",null,null,null,null,{"$f":"SUM($G$38,$G$50,$G$62)","v":0}]
[null,"AVERAGE RATE PER MANDAY",null,null,null,null,{"$f":"($G$65/ROUND((E38+E50+E62),1))","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,{"$f":"IF(ISBLANK(A69),\"(Place X in adjacent block to remove instructions prior to printing.)\",\"Remove X to display instructions.\")","v":"(Place X in adjacent block to remove instructions prior to printing.)"}]

{"sheet":"DESIGN DIRECT EXPENSES","index":7,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
["DESIGN DIRECT EXPENSES                                                                                                                                        "]
[null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":"<Route>"},"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"}]
["DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":"<Description>"},"PIN No.:",null,{"$f":"'COVER SHEET'!C20","v":"<000000.00>"}]
["COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":"<County>"}]
["CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":"<Consultant>"}]
["Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
["Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
[]
[null,null,null,null,null,"Item Subtotal","Item Total Cost"]
["Reproduction Costs:"]
[null,null,null,{"$f":"IF(ISBLANK(B57),\"(Enter quantity and unit price)\",\"\")","v":"(Enter quantity and unit price)"}]
[null,"Item Description",null,"Number / Unit","Unit Price"]
[null,"Photo-copies",null,null,null,{"$f":"E16*D16","v":0}]
[null,"Full size bond",null,null,null,0]
[null,"Half size bond",null,null,null,0]
[null,"Full size vellum",null,null,null,0]
[null,"Half size vellum",null,null,null,0]
[null,"Full size mylar",null,null,null,0,{"$f":"SUM(F16:F21)","v":0}]
[]
["Travel:"]
[null,null,null,{"$f":"IF(ISBLANK(B57),\"(Enter number of trips, people or milage, and rate)\",\"\")","v":"(Enter number of trips, people or milage, and rate)"}]
[null,null,"Number of Trips","No. of Miles/No. of People","RATE  *"]
["Per Diem (75%) ",null,null,null,0,{"$f":"C26*D26*E26","v":0}]
["Per Diem  ",null,null,null,0,{"$f":"C27*D27*E27","v":0}]
["Transportation",null,null,null,0,{"$f":"C28*D28*E28","v":0}]
["Lodging  ",null,null,null,0,{"$f":"C29*D29*E29","v":0},{"$f":"SUM(F26:F29)","v":0}]
[null,null,"*  Rate must agree with most current State of Tennessee travel regulations."]
[null,null,"    First and last day of travel must be at the 75% Per Diem Rate."]
["Other Expenses:"]
[null,null,null,{"$f":"IF(ISBLANK(B57),\"(Enter description, number and unit price.)\",\"\")","v":"(Enter description, number and unit price.)"}]
[null,"Item Description",null,"Number / Unit","Unit Price"]
[null,null,null,0,0,{"$f":"D35*E35","v":0}]
[null,null,null,0,0,{"$f":"D36*E36","v":0}]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0,{"$f":"SUM(F35:F41)","v":0}]
[]
[]
["TOTAL DIRECT EXPENSES",null,null,null,null,null,{"$f":"SUM(G21,G29,G41)","v":0}]
[]
[null,{"$f":"IF(ISBLANK(B57),\"(Place X in adjacent box if allocation of direct expenses is to be different than total project allocation percentage.)\",\"\")","v":"(Place X in adjacent box if allocation of direct expenses is to be different than total project allocation percentage.)"}]
[]
[{"$f":"IF(ISBLANK(A46),\"\",\"           MODIFIED DIRECT EXPENSE PERCENTAGES\")","v":""}]
[{"$f":"IF(ISBLANK(A46),\"\",\"Preliminary Plans=\")","v":""},null,{"$f":"IF(ISBLANK(A46),\"\",\"%\")","v":""}]
[{"$f":"IF(ISBLANK(A46),\"\",\"R.O.W. Plans=\")","v":""},null,{"$f":"IF(ISBLANK(A46),\"\",\"%\")","v":""}]
[{"$f":"IF(ISBLANK(A46),\"\",\"Construction Plans=\")","v":""},null,{"$f":"IF(ISBLANK(A46),\"\",\"%\")","v":""}]
[]
["DIRECT EXPENSES PRELIMINARY PLANS",null,null,null,{"$f":"B59","v":0},"% ",{"$f":"ROUND($G$44*(E53/100),4)","v":0}]
["DIRECT EXPENSES RIGHT-OF-WAY PLAN",null,null,null,{"$f":"B60","v":0},"% ",{"$f":"ROUND($G$44*(E54/100),4)","v":0}]
["DIRECT EXPENSES CONSTRUCTION PLANS",null,null,null,{"$f":"B61","v":0},"% ",{"$f":"ROUND($G$44*(E55/100),4)","v":0}]
[null,null,null,null,{"$f":" SUM(E53:E55)","v":0},"%"]
[null,null,{"$f":"IF(ISBLANK(B57),\"( Place X in box to remove instructions prior to printing.\",\"(Remove x to display instructions.)\")","v":"( Place X in box to remove instructions prior to printing."}]
[]
[{"$f":"'DESIGN LABOR & AVG. M.D.'!E23","v":0},{"$f":"IF(ISBLANK(A46),A59,B49)","v":0},{"$f":"IF(ISBLANK(B57),\"(Do not edit or place data in these cells.)\",\"\")","v":"(Do not edit or place data in these cells.)"}]
[{"$f":"'DESIGN LABOR & AVG. M.D.'!E24","v":0},{"$f":"IF(ISBLANK(A46),A60,B50)","v":0}]
[{"$f":"'DESIGN LABOR & AVG. M.D.'!E25","v":0},{"$f":"IF(ISBLANK(A46),A61,B51)","v":0}]

{"sheet":"FEE PROPOSAL","index":8,"n_rows":148,"n_cols":11,"rows_kept":148,"cut":false,"hidden":false,"merged":[[14,0,14,2],[21,5,21,8],[22,5,22,8]]}
["FEE PROPOSAL"]
[]
["ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":"<Route>"},null,null,null,"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"}]
["DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":"<Description>"},null,null,null,"PIN No.:",null,{"$f":"'COVER SHEET'!C20","v":"<000000.00>"}]
["COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":"<County>"}]
["CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":"<Consultant>"}]
["Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
["Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
[{"$f":"IF(ISBLANK(A25),\"COMPLETE SURVEY SHEETS FIRST IF SURVEY IS INCLUDED IN THE CONTRACT.\",\"\")","v":"COMPLETE SURVEY SHEETS FIRST IF SURVEY IS INCLUDED IN THE CONTRACT."}]
[{"$f":"IF(ISBLANK(A25),\"PROCEED WITH FEE PROPOSAL IF SURVEY IS NOT INCLUDED.\",\"\")","v":"PROCEED WITH FEE PROPOSAL IF SURVEY IS NOT INCLUDED."}]
[{"$f":"IF(ISBLANK(A25),\"This sheet perfoms fee proposal calculations for each phase of the project and total project. Net Fee is computed by Net Fee Calculator \",\"\")","v":"This sheet perfoms fee proposal calculations for each phase of the project and total project. Net Fee is computed by Net Fee Calculator "}]
[{"$f":"IF(ISBLANK(A25),\"Enter the appropriate overhead rate & fill in shaded boxes that apply for each phase.\",\"\")","v":"Enter the appropriate overhead rate & fill in shaded boxes that apply for each phase."},null,null,null,null,null,null,null,{"$f":"I50","v":"Version 2.27"}]
[]
["Data For Fee Calculations"]
["Overhead Rate  =",null,null,null,"**",null,{"$f":"IF('COVER SHEET'!F37=\"Sub:\",\"Overhead Rate** =\",\"\")","v":""}]
["**  (State Project Maximum overhead rate = 145%)"]
["**  (Federal Project Maximum overhead rate per External Audit Report)"]
["Design Direct Labor =",null,null,{"$f":"'DESIGN LABOR & AVG. M.D.'!G65","v":0}]
["Survey Direct Labor  =",null,null,{"$f":"'SURVEY LABOR & DIRECT EXPENSES'!J25","v":0}]
["Total Direct Labor =",null,null,{"$f":"D18+D19","v":0}]
[]
[]
["Net Fee (Refer to \"Net Fee Calculator\")",null,null,{"$f":"'Net Fee Calculator'!G44","v":0.08}]
[]
[null,{"$f":"IF(ISBLANK(A25),\"(Place X in adjacent box to remove instructions prior to printing.)\",\"Remove X to display instructions.\")","v":"(Place X in adjacent box to remove instructions prior to printing.)"}]
[]
[]
["SURVEYS",null,null,null,null,null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"COST FOR\")","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"COST FOR\")","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"SAVINGS FOR\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",(('SURVEY SUMMARY'!$B$13&\" - Hr Days\")))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",\"8-HR DAY\")","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",(('SURVEY SUMMARY'!$B$13&\" - Hr Days\")))","v":""}]
[1,"Direct Labor",null,null,null,null,null,"=",{"$f":"'SURVEY LABOR & DIRECT EXPENSES'!J25","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((('SURVEY LABOR & DIRECT EXPENSES'!F16*'SURVEY LABOR & DIRECT EXPENSES'!H16*'SURVEY LABOR & DIRECT EXPENSES'!I16)+('SURVEY LABOR & DIRECT EXPENSES'!F17*'SURVEY LABOR & DIRECT EXPENSES'!H17*'SURVEY LABOR & DIRECT EXPENSES'!I17)+('SURVEY LABOR & DIRECT EXPENSES'!F18*8*'SURVEY LABOR & DIRECT EXPENSES'!I18)+('SURVEY LABOR & DIRECT EXPENSES'!F19*8*'SURVEY LABOR & DIRECT EXPENSES'!I19)+('SURVEY LABOR & DIRECT EXPENSES'!F20*8*'SURVEY LABOR & DIRECT EXPENSES'!I20)+('SURVEY LABOR & DIRECT EXPENSES'!F21*8*'SURVEY LABOR & DIRECT EXPENSES'!I21)+('SURVEY LABOR & DIRECT EXPENSES'!F22*8*'SURVEY LABOR & DIRECT EXPENSES'!I22)+('SURVEY LABOR & DIRECT EXPENSES'!F23*8*'SURVEY LABOR & DIRECT EXPENSES'!I23)),4))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(J30-I30,2))","v":""}]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"$f":"$D$15","v":0},")","=",{"$f":"ROUND(I30*$D$15,2)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND((J30*$D$15),2))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J32-I32)","v":""}]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",null,null,null,null,"=",{"$f":"ROUND(I30+I32,2)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(J30+J32,2))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J35-I35)","v":""}]
[]
[4,"Net Fee =",{"$f":"$D$23","v":0.08},null,null,null,"(Rounded to nearest $10.)","=",{"$f":"ROUND(I30*(1+$D$15)*$D$23,-1)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(J30*2.35*D23,10))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J37-I37)","v":""}]
[null,"(Direct labor + Overhead) X 0.NF"]
[]
[5,null,"Subtotal    3    +    4    ",null,null,null,null,"=",{"$f":"ROUND(I35+I37,2)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(J35+J37,24))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J40-I40)","v":""}]
[]
[6,"Direct Expense",null,null,null,null,null,"=",{"$f":"ROUND('SURVEY LABOR & DIRECT EXPENSES'!S54,2)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",'SURVEY LABOR & DIRECT EXPENSES'!Y34)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J42-I42)","v":""}]
[]
[7,"Premium Labor",null,null,null,null,null,"=",{"$f":"IF('SURVEY SUMMARY'!$B$13=8,0,'SURVEY LABOR & DIRECT EXPENSES'!K25)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",0)","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J44-I44)","v":""}]
[null,"(Premium Labor is only eligible if the survey crew works greater than a 40 hour work week.)"]
[8,null,"Total Survey",null,null,null,null,"=",{"$f":"ROUND(I40+I42+I44,2)","v":0},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",ROUND(J40+J42+J44,2))","v":""},{"$f":"IF('SURVEY SUMMARY'!$B$13=8,\"\",J46-I46)","v":""}]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["Preliminary Design"]
[]
[1,"Direct Labor",null,null,null,null,null,"=",{"$f":"ROUND('DESIGN LABOR & AVG. M.D.'!G38,2)","v":0}]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"$f":"$D$15","v":0},")","=",{"$f":"ROUND(I53*$D$15,2)","v":0}]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",null,null,null,null,"=",{"$f":"ROUND(I53+I55,2)","v":0}]
[]
[4,"Net Fee =",{"$f":"$D$23","v":0.08},null,null,null,"(Rounded to nearest $10.)","=",{"$f":"ROUND(I53*(1+$D$15)*$D$23,-1)","v":0}]
[null,"(Direct labor + Overhead) X 0.NF"]
[]
[5,null,"Subtotal    3    +    4    ",null,null,null,null,"=",{"$f":"ROUND(I58+I60,2)","v":0}]
[]
[6,"Direct Expense",null,null,null,null,null,"=",{"$f":"ROUND('DESIGN DIRECT EXPENSES'!G53,2)","v":0}]
[]
[7,"Premium Labor",null,null,null,null,null,"=",0]
[]
[8,null,"Total Preliminary Plans",null,null,null,null,"=",{"$f":"ROUND(I63+I65+I67,2)","v":0}]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
["Right-of-Way Design"]
[]
[1,"Direct Labor",null,null,null,null,null,"=",{"$f":"ROUND('DESIGN LABOR & AVG. M.D.'!G50,2)","v":0}]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"$f":"$D$15","v":0},")","=",{"$f":"ROUND(I75*$D$15,2)","v":0}]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",null,null,null,null,"=",{"$f":"ROUND(I75+I77,2)","v":0}]
[]
[4,"Net Fee =",{"$f":"$D$23","v":0.08},null,null,null,"(Rounded to nearest $10.)","=",{"$f":"ROUND(I75*(1+$D$15)*$D$23,-1)","v":0}]
[null,"(Direct labor + Overhead) X 0.NF"]
[]
[5,null,"Subtotal    3    +    4    ",null,null,null,null,"=",{"$f":"ROUND(I80+I82,2)","v":0}]
[]
[6,"Direct Expense",null,null,null,null,null,"=",{"$f":"ROUND('DESIGN DIRECT EXPENSES'!G54,2)","v":0}]
[]
[7,"Premium Labor",null,null,null,null,null,"=",0]
[]
[8,null,"Total Right-of-Way Plans",null,null,null,null,"=",{"$f":"ROUND(I85+I87+I89,2)","v":0}]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["Construction Design"]
[]
[1,"Direct Labor",null,null,null,null,null,"=",{"$f":"ROUND('DESIGN LABOR & AVG. M.D.'!G62,2)","v":0}]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"$f":"$D$15","v":0},")","=",{"$f":"ROUND(I98*$D$15,2)","v":0}]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",null,null,null,null,"=",{"$f":"ROUND(I98+I100,2)","v":0}]
[]
[4,"Net Fee =",{"$f":"$D$23","v":0.08},null,null,null,"(Rounded to nearest $10.)","=",{"$f":"ROUND(I98*(1+$D$15)*$D$23,-1)","v":0}]
[null,"(Direct labor + Overhead) X 0.NF"]
[]
[5,null,"Subtotal    3    +    4    ",null,null,null,null,"=",{"$f":"ROUND(I103+I105,2)","v":0}]
[]
[6,"Direct Expense",null,null,null,null,null,"=",{"$f":"ROUND('DESIGN DIRECT EXPENSES'!G55,2)","v":0}]
[]
[7,"Premium Labor",null,null,null,null,null,"=",0]
[]
[8,null,"Total Construction Plans",null,null,null,null,"=",{"$f":"ROUND(I108+I110+I112,2)","v":0}]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
["Total Project"]
[]
[1,"Direct Labor",null,null,null,null,null,"=",{"$f":"ROUND(SUM(I30,I53,I75,I98),2)","v":0}]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Direct Labor)"]
[2,"Overhead",null,"(Overhead Rate  =",null,{"$f":"$D$15","v":0},")","=",{"$f":"ROUND(I120*$D$15,2)","v":0}]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",null,null,null,null,"=",{"$f":"ROUND(I120+I122,2)","v":0}]
[]
[4,"Net Fee =",{"$f":"$D$23","v":0.08},null,null,null,"(Rounded to nearest $10.)","=",{"$f":"ROUND(SUM(I37,I60,I82,I105),-1)","v":0}]
[null,"(Direct labor + Overhead) X 0.NF"]
[]
[5,null,"Subtotal    3    +    4    ",null,null,null,null,"=",{"$f":"ROUND(I125+I127,2)","v":0}]
[]
[6,"Direct Expense",null,"( Itemize and attach )",null,null,null,"=",{"$f":"ROUND(SUM(I42,I65,I87,I110),2)","v":0}]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Direct Expenses)"]
[7,"Premium Labor",null,null,null,null,null,"=",{"$f":"ROUND(SUM(I44,I67,I89,I112),2)","v":0}]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Premium Labor)"]
[8,null,"Total Project",null,null,null,null,"=",{"$f":"ROUND(I130+I132+I134,2)","v":0}]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
[null,null,null,null,null,"Total Contract",null,null,{"$f":"I136","v":0}]
[]
[]
[]
[null,null,null,"DESIGN COST PER MILE",null,null,null,null,{"$f":"(I63+I85+I108)/'DESIGN MANDAYS A'!F11","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"SURVEY COST PER MILE",null,null,null,null,{"$f":"I40/'SURVEY SUMMARY'!B9","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"TOTAL COST PER MILE",null,null,null,null,{"$f":"I130/'DESIGN MANDAYS A'!F11","v":{"$error":"#DIV/0!"}}]

{"sheet":"FEE PROPOSAL SUMMARY","index":9,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"FEE PROPOSAL SUMMARY"]
[]
[null,"ROUTE:",null,{"$f":"'COVER SHEET'!B14","v":"<Route>"},null,"Project No.:",null,{"$f":"'COVER SHEET'!A46","v":"<00000-0000-00>"}]
[null,"DESCRIPTION:",null,{"$f":"'COVER SHEET'!B16","v":"<Description>"},null,"PIN No.:",null,{"$f":"'COVER SHEET'!C20","v":"<000000.00>"}]
[null,"COUNTY:",null,{"$f":"'COVER SHEET'!C18","v":"<County>"}]
[null,"CONSULTANT:",null,{"$f":"'COVER SHEET'!D35","v":"<Consultant>"}]
[null,"Prepared By:",null,{"$f":"'COVER SHEET'!A40","v":"<Name>"}]
[null,"Date Prepared:",null,{"$f":"'COVER SHEET'!A43","v":"<Date>"}]
[null,{"$f":"IF(ISBLANK(A54),\"mark the appropriate box below an values for the initial ceiling will be calculated.\",\"\")","v":"mark the appropriate box below an values for the initial ceiling will be calculated."}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
[null,"Survey Fee Proposal Summary"]
[null,null,"Direct Labor","Overhead","Subtotal","Net Fee","Subtotal","Direct ","Premium ","Total"]
[null,null,null,null,"Direct Labor &",null,"Direct Labor,","Expense","Labor","Phase"]
[null,null,null,null,"Overhead",null,"Overhead, &"]
[null,null,null,null,null,null,"Net Fee"]
[null,"SURVEY",{"$f":"'FEE PROPOSAL'!I30","v":0},{"$f":"'FEE PROPOSAL'!I32","v":0},{"$f":"'FEE PROPOSAL'!I35","v":0},{"$f":"'FEE PROPOSAL'!I37","v":0},{"$f":"'FEE PROPOSAL'!I40","v":0},{"$f":"'FEE PROPOSAL'!I42","v":0},{"$f":"'FEE PROPOSAL'!I44","v":0},{"$f":"'FEE PROPOSAL'!I46","v":0}]
[]
[]
[null,"Design Fee Proposal Summary"]
[null,null,"Direct Labor","Overhead","Subtotal","Net Fee","Subtotal","Direct ","Premium ","Total"]
[null,null,null,null,"Direct Labor &",null,"Direct Labor,","Expense","Labor","Phase"]
[null,null,null,null,"Overhead",null,"Overhead, &"]
[null,null,null,null,null,null,"Net Fee"]
[null,"PRELIMINARY PLANS",{"$f":"'FEE PROPOSAL'!I53","v":0},{"$f":"'FEE PROPOSAL'!I55","v":0},{"$f":"'FEE PROPOSAL'!I58","v":0},{"$f":"'FEE PROPOSAL'!I60","v":0},{"$f":"'FEE PROPOSAL'!I63","v":0},{"$f":"'FEE PROPOSAL'!I65","v":0},{"$f":"'FEE PROPOSAL'!I67","v":0},{"$f":"'FEE PROPOSAL'!I69","v":0}]
[null,"RIGHT-OF-WAY PLANS",{"$f":"'FEE PROPOSAL'!I75","v":0},{"$f":"'FEE PROPOSAL'!I77","v":0},{"$f":"'FEE PROPOSAL'!I80","v":0},{"$f":"'FEE PROPOSAL'!I82","v":0},{"$f":"'FEE PROPOSAL'!I85","v":0},{"$f":"'FEE PROPOSAL'!I87","v":0},{"$f":"'FEE PROPOSAL'!I89","v":0},{"$f":"'FEE PROPOSAL'!I91","v":0}]
[null,"Subtotal Preliminary &",{"$f":"ROUND(SUM(,C24,C25),4)","v":0},0,0,0,0,0,0,0]
[null,"Right-of-Way Plans"]
[null,"CONSTRUCTION PLANS",{"$f":"'FEE PROPOSAL'!I98","v":0},{"$f":"'FEE PROPOSAL'!I100","v":0},{"$f":"'FEE PROPOSAL'!I103","v":0},{"$f":"'FEE PROPOSAL'!I105","v":0},{"$f":"'FEE PROPOSAL'!I108","v":0},{"$f":"'FEE PROPOSAL'!I110","v":0},{"$f":"'FEE PROPOSAL'!I112","v":0},{"$f":"'FEE PROPOSAL'!I114","v":0}]
[null,"Subtotal Preliminary, R.O.W.,",{"$f":"ROUND(SUM(,C24,C25,C28),4)","v":0},0,0,0,0,0,0,0]
[null,"& Construction Plans"]
[]
[null,"Total Survey & Design",{"$f":"ROUND(SUM(C16,C24,C25,C28),4)","v":0},0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(ISBLANK(A54),\"(Place a X in appropriate box indicating the point of the initial contract ceiling.  Only one (1) block should have an X placed.)\",\"\")","v":"(Place a X in appropriate box indicating the point of the initial contract ceiling.  Only one (1) block should have an X placed.)"}]
[null,{"$f":"IF(ISBLANK(A54),\"(Note: (Survey thru Const. Plans) can be checked if no initial contract ceiling is to be set.)\",\"\")","v":"(Note: (Survey thru Const. Plans) can be checked if no initial contract ceiling is to be set.)"}]
[null,"Survey",{"$f":"IF(ISBLANK($A36),\"\",C16)","v":""},"","","","","","",""]
[null,"Survey thru Prel. Plans",{"$f":"IF(ISBLANK($A37),\"\",SUM(C16,C24))","v":""},"","","","","","",""]
[null,"Survey thru R.O.W. Plans",{"$f":"IF(ISBLANK($A38),\"\",SUM(C16,C26))","v":""},"","","","","","",""]
[null,"Survey thru Const. Plans",{"$f":"IF(ISBLANK($A39),\"\",SUM(C16,C29))","v":""},"","","","","","",""]
[null,"Prel. Plans",{"$f":"IF(ISBLANK($A40),\"\",C24)","v":""},"","","","","","",""]
[null,"Prel & R.O.W. Plans",{"$f":"IF(ISBLANK($A41),\"\",C26)","v":""},"","","","","","",""]
[null,"Prel. Thru Const. Plans",{"$f":"IF(ISBLANK($A42),\"\",SUM(C16,C29))","v":""},"","","","","","",""]
[]
[null,"INITIAL CONTRACT CEILING"]
[null,null,"Direct Labor","Overhead","Subtotal","Net Fee","Subtotal","Direct ","Premium ","Total"]
[null,null,null,null,"Direct Labor &",null,"Direct Labor,","Expense","Labor","Ceiling"]
[null,null,null,null,"Overhead",null,"Overhead, &"]
[null,null,null,null,null,null,"Net Fee"]
[null,"Contract will initially be"]
[null,"authorized for:"]
[null,{"$f":"IF(ISTEXT($A36),B36,IF(ISTEXT($A37),B37,IF(ISTEXT($A38),B38,IF(ISTEXT($A39),B39,IF(ISTEXT($A40),B40,IF(ISTEXT($A41),B41,IF(ISTEXT($A42),B42,\"\")))))))","v":""},{"$f":"IF(ISTEXT($A36),C36,IF(ISTEXT($A37),C37,IF(ISTEXT($A38),C38,IF(ISTEXT($A39),C39,IF(ISTEXT($A40),C40,IF(ISTEXT($A41),C41,IF(ISTEXT($A42),C42,\"\")))))))","v":""},{"$f":"IF(ISTEXT($A36),D36,IF(ISTEXT($A37),D37,IF(ISTEXT($A38),D38,IF(ISTEXT($A39),D39,IF(ISTEXT($A40),D40,IF(ISTEXT($A41),D41,IF(ISTEXT($A42),D42,\"\")))))))","v":""},"","","","","",""]
[]
[]
[null,{"$f":"IF(ISBLANK(A54),\"(Place X in adjacent box to remove instructions prior to printing.)\",\"(Remove X to display instructions.)\")","v":"(Place X in adjacent box to remove instructions prior to printing.)"}]

{"sheet":"Net Fee Calculator","index":10,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[45,0,45,5],[46,1,46,5],[34,0,34,5],[34,6,34,7],[35,0,35,5],[35,6,35,7],[43,0,43,5],[44,0,44,5],[29,0,29,5],[29,6,29,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,0,28,5],[28,6,28,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,0,22,5],[22,6,22,7],[23,0,23,5],[23,6,23,7],[15,6,15,7],[16,0,16,5],[16,6,16,7],[17,0,17,5],[17,6,17,7],[18,6,18,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[9,0,9,5],[9,6,9,7],[10,0,10,5],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,5,4,7],[5,5,5,7]]}
[null,"Tennessee Department of Transportation"]
[null,"Fixed Fee Worksheet"]
[null," ( 8% base plus)"]
[null,"Project Description:"]
[null,"Route:"]
[null,"Termini:"]
[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(D12=TRUE,D13=FALSE,D14=FALSE,D15=FALSE),C12)","v":false},22222222,"More than $2,000,000"]
[null,null,0.5,false,{"$f":"IF(AND(D13=TRUE,D12=FALSE,D14=FALSE,D15=FALSE),C13)","v":false},111,"Less than $2,000,000"]
[null,null,1,false,{"$f":"IF(AND(D14=TRUE,D12=FALSE,D13=FALSE,D15=FALSE),C14)","v":false},"ddddddddddddd","Less than $500,000"]
[null,null,2,false,{"$f":"IF(AND(D15=TRUE,D12=FALSE,D13=FALSE,D14=FALSE),C15)","v":false},"ddddddddddddd","Less than $50,000"]
[null,null,null,null,null,{"$f":"SUM(E12:E15)","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(D19=TRUE,D20=FALSE,D21=FALSE),C19)","v":false},null,"Resurfacing, No Plans Contracts, CEI On-Call Work Orders"]
[null,null,0.5,false,{"$f":"IF(AND(D20=TRUE,D19=FALSE,D21=FALSE),C20)","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, Roadway Lighting and Utility Coordination"]
[null,null,1,false,{"$f":"IF(AND(D21=TRUE,D19=FALSE,D20=FALSE),C21)","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(E19:E21)","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(D25=TRUE,D26=FALSE,D27=FALSE),C25)","v":false},null,"less than two years"]
[null,null,0.5,false,{"$f":"IF(AND(D26=TRUE,D25=FALSE,D27=FALSE),C26)","v":false},null,"from two to four years"]
[null,null,1,false,{"$f":"IF(AND(D27=TRUE,D25=FALSE,D26=FALSE),C27)","v":false},null,"four years or more"]
[null,null,null,null,null,{"$f":"SUM(E25:E27)","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(D31=TRUE,D32=FALSE,D33=FALSE),C31)","v":false},null,"More than 40% of job"]
[null,null,0.5,false,{"$f":"IF(AND(D32=TRUE,D31=FALSE,D33=FALSE),C32)","v":false},null,"Less than 40% of job"]
[null,null,1,false,{"$f":"IF(AND(D33=TRUE,D31=FALSE,D32=FALSE),C33)","v":false},null,"Less than 20% of job"]
[null,null,null,null,null,{"$f":"SUM(E31:E33)","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(D37=TRUE,D38=FALSE,D39=FALSE,D40=FALSE,D41=FALSE,D42=FALSE),C37)","v":false},null,"Office Overhead > 200%   or ","Field (CEI) Overhead > 150%"]
[null,null,0.5,false,{"$f":"IF(AND(D38=TRUE,D37=FALSE,D39=FALSE,D40=FALSE,D41=FALSE,D42=FALSE),C38)","v":false},null,"Office Overhead > 180% and ≤ 200%  or","Field (CEI) Overhead > 130% and ≤ 150%"]
[null,null,1,false,{"$f":"IF(AND(D39=TRUE,D37=FALSE,D38=FALSE,D40=FALSE,D41=FALSE,D42=FALSE),C39)","v":false},null,"Office Overhead > 160% and ≤ 180%  or","Field (CEI) Overhead > 120% and ≤ 130%"]
[null,null,2,false,{"$f":"IF(AND(D40=TRUE,D37=FALSE,D38=FALSE,D39=FALSE,D41=FALSE,D42=FALSE),C40)","v":false},null,"Office Overhead > 140% and ≤ 160%  or","Field (CEI) Overhead > 110% and ≤ 120%"]
[null,null,3,false,{"$f":"IF(AND(D41=TRUE,D38=FALSE,D39=FALSE,D40=FALSE,D42=FALSE,D43=FALSE),C41)","v":false},null,"Office Overhead > 120% and ≤140%  or","Field (CEI) Overhead >  90% and ≤ 110%"]
[null,null,4,false,{"$f":"IF(AND(D42=TRUE,D37=FALSE,D38=FALSE,D39=FALSE,D40=FALSE,D41=FALSE),C42)","v":false},null,"Office Overhead ≤ 120%  or","Field (CEI) Overhead ≤ 90%"]
[null,null,null,null,null,{"$f":"SUM(E37:E42)","v":0}]
["Total Fixed Fee  =",null,null,null,null,null,{"$f":"(8+SUM(F22,F16,F28,F34,F43))/100","v":0.08}]
["Completed By",null,null,null,null,null," Firm"," Date"]

{"sheet":"SURVEY FORMS REVISIONS","index":11,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["REVISIONS TO EXCEL MAN-DAY SPREADSHEET"]
["SURVEY FORMS"]
["Date ",null,"Worksheet Revised","Version","Description",null,null,null,null,null,null,null,"Revised By"]
[null,null,null,null,null,null,null,null,null,null,null,null,"JHW"]
["1998-06-01",null,"Survey Manday",null,"Changed travel time equations to match discussion at meeting of May 4, 1998.",null,null,null,null,null,null,null,"JHW"]
["1998-06-01",null,"Survey Manday Form Instructions",null,"Changed travel time equations to match discussion at meeting of May 4, 1998.",null,null,null,null,null,null,null,"JRG"]
["1998-06-01",null,"All Sheets",null,"Changed gray background to a lighter shade of gray for copying and faxing.",null,null,null,null,null,null,null,"JHW"]
["1998-06-01",null,"Survey Summary",null,"Changed the number of decimal places on the English project length to two.",null,null,null,null,null,null,null,"JHW"]
["1998-06-01",null,"Survey Summary",null,"Changed culvert site background to gray with red text to prompt for allowable manual input.",null,null,null,null,null,null,null,"JHW"]
["1998-06-01",null,"Survey Labor & Direct Expenses",null,"Changed default values and some of the format of profit rate.",null,null,null,null,null,null,null,"JHW"]
["1998-06-08",null,"Survey Manday",null,"Changed equation for mandays/km &mandays/mile to include only mainline length.",null,null,null,null,null,null,null,"JHW"]
["1998-06-22",null,"Survey Summary & Survey Manday",null,"Changed travel time to allow for crew and aoofce varying rates.",null,null,null,null,null,null,null,"JHW"]
["1998-06-22",null,"All Sheets",null,"Added Version Number on all pages except for Instructions Page.",null,null,null,null,null,null,null,"JHW"]
["1998-06-22",null,"Survey Manday Form Instructions",null,"Modified Equations to match travel.",null,null,null,null,null,null,null,"JHW"]
["1998-06-30",null,"Survey Summary",1.01,"Added Round command to stop rounding problems. (Changed to version 1.01)",null,null,null,null,null,null,null,"JHW"]
["1998-09-28",null,"Survey Summary",1.02,"Modified to allow English Units Input (Changed to version 1.02)",null,null,null,null,null,null,null,"JRG/JHW"]
["1999-01-07",null,"All Sheets",1.02,"Eliminated metric, Combined with Design, Incorporated Invoice Sheet",null,null,null,null,null,null,null,"JRG/JHW"]
["1999-02-22",null,"Several Sheets",2,"See Design Comments",null,null,null,null,null,null,null,"JHW"]
["1999-04-15",null,"Summary,Estimate, & Instructions",2.0099999999999998,"Modified Equations for Rounding Errors, Modified Mapping Check Box Errors, Updated Instructions. (Version 2.01)",null,null,null,null,null,null,null,"JHW"]
["2000-04-04",null,"All Sheets",2.02,"Duplicated row headings on page 2 of estimate, Removed page protection, Added sideroad list, ",null,null,null,null,null,null,null,"JRG/JHW"]
[null,null,null,null,"Added MD per mile less travel for information, Added contact person information,"]
[null,null,null,null,"Modified total length to exclude length of sideroad included in mainline width"]
["2000-04-04",null,"Survey Labor & Direct Expenses",2.02,"Modified Direct Expenses to Update Travel Regulations, 20% of Per Diem is Travel Day, 80 %  is not. Added ",null,null,null,null,null,null,null,"JHW"]
[null,null,"Cover Sheet",null,"New Print Button For In-House Use. Added Difficulty for Property Owner Contacts., Added Checklist Sheet for "]
[null,null,null,null,"Survey Items at Bottom of Cover Sheet"]
["2001-02-21",null,"Cover Sheet, Survey Summary,"]
[null,null,"Survey Manday Estimate,"]
[null,null,"Survey Labor & Direct Expenses &"]
[null,null,"Fee Proposal",null,"Added Crew Hour Workday Option to Work Sheets, split difficulty factor to office and field, and Made General Corrections  "]
["2001-02-21",null,"All Sheets",2.1,"(Changed to version 2.10)",null,null,null,null,null,null,null,"JHW/WJG"]
["2004-03-05",null,"All Sheets",2.11,"Changed TDOT logo to new logo",null,null,null,null,null,null,null,"JHW/WJG"]
["2004-03-08",null,"Survey Invoice ",2.11,"Deleted Invoice Sheet",null,null,null,null,null,null,null,"JHW "]
["2007-03-30",null,null,2.2000000000000002,"Updated entire template",null,null,null,null,null,null,null,"FMM/JHW"]
["2010-03-03",null,"Cover Sheet, Survey Summary,",2.2200000000000002,"Changed to version 2.22, Changed default crew work per day hours to 8, Revised default rural land character percentages,  ",null,null,null,null,null,null,null,"JHW/JKH"]
[null,null,"Survey Manday, Survey Labor,",null,"Changed approximate obscured area default to 100%, Modified manday equations for line items 17 & 19 on project manager, "]
[null,null,"Direct Expenses, Fee Proposal ",null,"Added difficulty factors to office and field travel time, Added footnote pertaining to premium labor, Removed travel rates "]
[null,null,null,null,"and reproduction unit prices, Added footnote pertaining to the use of the most current travel rates  "]
["2011-11-07",null,"All Sheets",2.23,"Changed TDOT logo to new logo",null,null,null,null,null,null,null,"JHW"]
["2012-05-30",null,"All Sheets",2.2400000000000002,"Fixed bug related to linked documents in spreadsheet.",null,null,null,null,null,null,null,"JHW"]
["2015-09-30",null,"All Sheets",2.25,"Changed TDOT logo to new logo; changed to version 2.25",null,null,null,null,null,null,null,"AEP"]
[null,null,"All Sheets",2.27,"Revised version number."]

{"sheet":"DESIGN FORM REVISIONS","index":12,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["REVISIONS TO EXCEL MAN-DAY SPREADSHEET"]
["DESIGN FORMS & FEE PROPOSAL SHEETS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'COVER SHEET'!G46","v":"Version 2.27"}]
["Date ",null,"Worksheet Revised","Version","Description",null,null,null,null,null,null,"Revised By"]
[]
["1998-07-21",null,"All sheets",1.01,"1) Add cover sheet, design direct expenses sheet, design form revisions sheet.",null,null,null,null,null,null,"MA"]
[null,null,null,null,"2) Added survey manday estimate sheets (Equations and factors match"]
[null,null,null,null,"survey estimate version 1.01.)"]
[null,null,null,null,"3) Added version to all sheets."]
[null,null,null,null,"4) Added instructions to design sheets."]
["1998-07-21",null,"Fee Proposal",1.01,"Added equations eliminating need to input survey direct labor and direct ",null,null,null,null,null,null,"MA"]
[null,null,null,null,"expenses seperately."]
["1998-07-28",null,"Design Labor & Avg. M.D. Rate",1.02,"1) Added round command to labor cost and Avg. M.D. rate formulas.",null,null,null,null,null,null,"MA"]
["1998-07-28",null,"All Sheets",1.02,"1) Changed version No. to 1.02.",null,null,null,null,null,null,"MA"]
["1998-07-28",null,"Design Mandays",1.02,"1) Added round command to total mandays column. ",null,null,null,null,null,null,"MA"]
[null,null,null,null,"2) Add 3-5 lane curb and gutter typicals to section II (Typical Sections)."]
[null,null,null,null,"3) Deleted curb and gutter factors from section III (Other Factors)."]
[null,null,null,null,"4) Changed Section III A 5 from \"Add 20%+(1/2%/tract>20)."]
["1998-07-28",null,"Fee Proposal",1.02,"1) Rounded net fee to nearest $ 10 for Preliminary, R.O.W., Const, & Total.",null,null,null,null,null,null,"MA"]
["1998-10-20",null,"Design Mandays",1.03,"1) Changed project length input from metric to English.",null,null,null,null,null,null,"MA"]
["1998-10-20",null,"All Sheets",1.03,"1) Changed version to 1.03.",null,null,null,null,null,null,"MA"]
["1998-10-20",null,"Cover Sheet",1.03,"1) Added Two Print Macro Buttons",null,null,null,null,null,null,"MA"]
["1998-12-14",null,"Fee Proposal",1.04,"1)Corrected Survey direct labor equation in cell D18.",null,null,null,null,null,null,"MA"]
[null,null,null,null,"2)Added round command to formulas",null,null,null,null,null,null,"MA"]
["1998-12-14",null,"Fee Proposal Summary",1.04,"1)Added sheet to workbook.",null,null,null,null,null,null,"MA"]
["1998-12-14",null,"All Sheets",1.04,"1) Changed version to 1.04",null,null,null,null,null,null,"MA"]
[null,null,null,null,"2)Minor modifictions to sheets.",null,null,null,null,null,null,"MA"]
[null,null,null,null,"3) Changed location to input project description to cover sheet .",null,null,null,null,null,null,"MA"]
[null,null,null,null,"4) Changed shading for input areas.",null,null,null,null,null,null,"MA"]
["1998-12-14",null,"Design Mandays",1.04,"1) Changed plan scales to English.",null,null,null,null,null,null,"MA"]
[null,null,null,null,"2) Modified instructions in other factors section.",null,null,null,null,null,null,"MA"]
["1998-12-14",null,"Design Direct Expenses",1.04,"1) Add option to vary percentage of direct expense percentage.",null,null,null,null,null,null,"MA"]
["1998-12-14",null,"Design Manday Breakdown",1.04,"1) Incorporated design labor into design labor & M.D. rate sheet and deleted.",null,null,null,null,null,null,"MA"]
["1999-01-07",null,"several",1.04,"Referenced Project Summary for Header Information",null,null,null,null,null,null,"JRG"]
["1999-02-22",null,"Several",1.04,"Modified Fee Proposal, Cover Sheet, Corrected Estimate Equations",null,null,null,null,null,null,"JHW"]
["1999-02-23",null,"All sheets",2,"Changed version to 2.00",null,null,null,null,null,null,"MA"]
["1999-04-15",null,"All sheets",2.0099999999999998,"Changed version to 2.01",null,null,null,null,null,null,"MA"]
["1999-04-15",null,"Fee Proposal ",2.0099999999999998,"Changed information under total project ",null,null,null,null,null,null,"MA"]
["2000-04-04",null,"All sheets",2.02,"Changed version to 2.02",null,null,null,null,null,null,"MA"]
["2000-04-04",null,"Design Direct Expenses",2.02,"Changed travel expense rates block.",null,null,null,null,null,null,"MA"]
["2000-04-04",null,"Design Mandays",2.02,"Changed curb and gutter descriptions",null,null,null,null,null,null,"MA"]
["2000-04-04",null,"Fee Proposal",2.02,"Added instruction regarding net fee calculation.",null,null,null,null,null,null,"MA"]
["2004-03-05",null,"All Sheets",2.11,"Changed TDOT logo to new logo",null,null,null,null,null,null,"JHW/WJG"]
["2004-03-08",null,"Design Invoice",2.11,"Deleted Design Invoice Sheet",null,null,null,null,null,null,"JHW"]
["2007-03-30",null,null,2.2000000000000002,"Updated entire template",null,null,null,null,null,null,"FMM/JHW"]
["2008-04-09",null,"Design Mandays",2.21,"Minor updates to shts A & B (formerly 7 & 7A); changed version to 2.21",null,null,null,null,null,null,"FMM"]
["2010-03-03",null,"Design Mandays B",2.2200000000000002,"Changed contour sheets criteria from 20 md/mile to 5 md/mile",null,null,null,null,null,null,"FMM/JHW"]
["2011-11-07",null,"All sheets",2.23,"Changed TDOT logo to new logo",null,null,null,null,null,null,"JHW"]
["2012-05-30",null,"All Sheets",2.2400000000000002,"Fixed bug related to linked documents in spreadsheet.",null,null,null,null,null,null,"JHW"]
["2015-09-30",null,"All sheets",2.25,"Changed TDOT logo to new logo; changed version to 2.25",null,null,null,null,null,null,"AEP"]
["2015-09-30",null,"Design Mandays B",2.25,"Added notes 1 & 2.",null,null,null,null,null,null,"AEP"]
["2015-09-30",null,"Fee Proposal",2.25,"Revised note regarding net fee for supplements.",null,null,null,null,null,null,"AEP"]
["2018-01-09",null,"All  sheets",2.2599999999999998,"Changed version to 2.26",null,null,null,null,null,null,"AEP"]
["2018-01-09",null,null,2.2599999999999998,"Added Net Fee Calculator",null,null,null,null,null,null,"AEP"]
["2018-01-09",null,"Fee Proposal",2.2599999999999998,"Reviised Net Fee calculation and notes.",null,null,null,null,null,null,"AEP"]
["2020-09-15",null,"All sheets",2.27,"Changed version to 2.27",null,null,null,null,null,null,"AEP"]
["2020-09-15",null,"Net Fee Calculator",2.27,"Replaced sheet with new version.",null,null,null,null,null,null,"AEP"]
["2020-09-15",null,"Fee Proposal",2.27,"Revised net fee calculation.",null,null,null,null,null,null,"AEP"]
["2020-10-06",null,"Net Fee Calculator",2.27,"Added Utility Coordination to Complexity Description (0.50)",null,null,null,null,null,null,"AEP"]

{"sheet":"SURVEY MANDAY FORM INSTRUCTIONS","index":13,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[23,21,24,28]]}
[]
["Information regarding use of Project Summary/Manday Estimate form.",null,null,null,null,null,null,null,null,null,"1. Establish and stake alignments:"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineer - L * DF / 2.48 miles per manday",null,null,null,null,null,null,null,null,"12. Bridge Surveys:"]
["Definition of a project with a 1.0 Difficulty Factor",null,null,null,null,null,null,null,null,null,null,"CADD - L * DF / 3.72 miles per manday",null,null,null,null,null,null,null,null,null,"Engineer - sum of all bridge crossings*DF / 2 bridges per manday"]
[null,null,null,null,null,null,null,null,null,null,null,"crew - L * DF / 0.5 miles per manday",null,null,null,null,null,null,null,null,null,"crew - 1 crewday per small crossing * DF"]
["1. Land lays flat to rolling.",null,null,null,null,null,null,null,null,null,"2. Update Survey:",null,null,null,null,null,null,null,null,null,"               1.5 crewdays per medium crossing * DF"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineer - 1/2 * Party Chief Mandays * DF",null,null,null,null,null,null,null,null,"               2 crewdays per large crossing * DF"]
["2. Project is semi-rural (Urban portion = 50% residential, 5% business, 45% rural)",null,null,null,null,null,null,null,null,null,null,"CADD - 1/2 * Party Chief Mandays * DF",null,null,null,null,null,null,null,null,null,"       "]
[null,null,null,null,null,null,null,null,null,null,null,"crew -Number of Updates * 3 crew days per update * DF",null,null,null,null,null,null,null,null,"   A small bridge is 20ft to 60ft long"]
["3. Rural portion is 50% wooded.",null,null,null,null,null,null,null,null,null,"3. Control Traverse:",null,null,null,null,null,null,null,null,null,"   A medium bridge is 60ft to 150ft long"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineer - L * DF / 1.86 miles per manday",null,null,null,null,null,null,null,null,"   A large bridge is greater than 150ft"]
["4. 10% DTM skips",null,null,null,null,null,null,null,null,null,null,"CADD - L * DF / 6.21 miles per manday",null,null,null,null,null,null,null,null,"   "]
[null,null,null,null,null,null,null,null,null,null,null,"crew - L * DF / 1.49 miles per manday",null,null,null,null,null,null,null,null,"13. Railroad Surveys:"]
["5. No severe wetlands or other environmental concerns.",null,null,null,null,null,null,null,null,null,"4. Set Aerial Control:",null,null,null,null,null,null,null,null,null,null,"Engineer - 1/3/ manday per railroad crossing * DF"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineer - 1 day if there are any H or V points",null,null,null,null,null,null,null,null,null,"CADD - 1/3 manday per railroad crossing * DF"]
["6. Project is in proximity to existing roadways requiring pavement",null,null,null,null,null,null,null,null,null,null,"CADD - zero",null,null,null,null,null,null,null,null,null,"crew - 2/3 crew day per railroad crossing * DF"]
[null,"checks of the aerial mapping.",null,null,null,null,null,null,null,null,null,"crew - 6 H points per day + 6 V points per day times DF",null,null,null,null,null,null,null,null,"14. Utilities:"]
[null,null,null,null,null,null,null,null,null,null,"5. Bench Levels:",null,null,null,null,null,null,null,null,null,null,"Engineer - L * DF / 6.21 miles per manday"]
["7. Aerial mapping is available.",null,null,null,null,null,null,null,null,null,null,"Engineer - L * DF / 6.21 miles per manday",null,null,null,null,null,null,null,null,null,"CADD - L * DF / 2.48 miles per manday"]
[null,null,null,null,null,null,null,null,null,null,null,"CADD - L * DF / 6.21 miles per manday",null,null,null,null,null,null,null,null,null,"crew - L * DF / 0.37 miles per manday"]
["8. Three or fewer underground utilities.",null,null,null,null,null,null,null,null,null,null,"crew - L * DF / 1.86 miles per manday",null,null,null,null,null,null,null,null,"15. Stake R.O.W. and easements:"]
[null,null,null,null,null,null,null,null,null,null,"6. Develop DTM:",null,null,null,null,null,null,null,null,null,null,"Engineer - (Cadd Tech mandays/8 + Party Chief Mandays/7) * DF"]
["Input is required only in the gray cells with red text.  Replace the red text with",null,null,null,null,null,null,null,null,null,null,"Engineer - L / 1.86 miles per manday + add 10% if no mapping is available",null,null,null,null,null,null,null,null,null,"CADD -(Iron Pin Points + 1 Stake Points + 2 Stake Points) * 150 Pts. Per manday * DF"]
["values appropriate to the project.",null,null,null,null,null,null,null,null,null,null,"CADD - L / 1.24 miles per manday + add 10% if no mapping is available",null,null,null,null,null,null,null,null,null,"crew - (Iron Pin Points/25 Points per day + 1 Stake Points/40 Points per day + 2 Stake Points/35 Points per day) * 150 Pts. Per manday * DF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"crew - 500 feet per manday per 300 feet of DTM width",null,null,null,null,null,null,null,null,"16. Stake Soundings:"]
["Following is an explaination of the formulae used in the spreadsheets:",null,null,null,null,null,null,null,null,null,null,null,"A reduction in mandays of 40% is required when there is no mapping available",null,null,null,null,null,null,null,null,"Engineer - (Number of Points /300 points per manday)*DF"]
["DF = difficulty factor, L = Total length of project = Mainline length + Side road length",null,null,null,null,null,null,null,null,null,"        ","and the assumption of 100% skip areas is used. (The assumption is that simply",null,null,null,null,null,null,null,null,null,"CADD - (Number of Points /150 points per manday)*DF"]
[null,null,null,null,null,null,null,null,null,null,null,null,"picking up DTM skips is much more dificult that picking up 100% of an",null,null,null,null,null,null,null,null,"crew - (Number of Points /40 points per manday)*DF"]
["Engineer = The person responsible for the day to day supervision of the project.",null,null,null,null,null,null,null,null,null,null,null,"average project)(If you have no mapping, input 100% for the skip area",null,null,null,null,null,null,null,"17. Note Reduction:"]
[null,"This person likely will use CADD software for engineering/survey calculations.",null,null,null,null,null,null,null,null,null,null,"which results in far too much time, thus the reduction)",null,null,null,null,null,null,null,null,"Project Manager - L * DF* 1.0 mandays per 1 mile"]
[null,null,null,null,null,null,null,null,null,null,"7. R.O.W. Utility Research:",null,null,null,null,null,null,null,null,null,"18. Plotting: Plotting time is for creating paper plots only."]
["CADD = Office CADD Technician = The person or functions pertaining to drafting",null,null,null,null,null,null,null,null,null,null,"Engineer - 1 day per 30 tracts",null,null,null,null,null,null,null,null,null,"Engineer - .25 * Cadd Tech mandays * DF"]
[null,"type duties.",null,null,null,null,null,null,null,null,null,"CADD - 1 day per 30 tracts",null,null,null,null,null,null,null,null,null,"CADD - L * DF* 1.61 mandays per 1 mile"]
[null,null,null,null,null,null,null,null,null,null,"8. Property Owner Contact:",null,null,null,null,null,null,null,null,null,"19. Supervision:"]
["Crew = A party chief, an instrumentman, two rodmen and occasional flagmen when needed.",null,null,null,null,null,null,null,null,null,null,"Engineer - 1 day per 15 tracts",null,null,null,null,null,null,null,null,null,"Engineer - 1.0 mandays per 1 mile * DF"]
[null,"These designations are used to show survey functions. Actual party size may",null,null,null,null,null,null,null,null,null,"Party Chief - 1 day per 15 tracts",null,null,null,null,null,null,null,null,"20. Travel:"]
[null,"vary.",null,null,null,null,null,null,null,null,"9. Locate property & row lines:",null,null,null,null,null,null,null,null,null,null,"Engineer - (Office daily travel time / 8hrs in a working day )* 3 total trips to the project"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineer - # tracts * DF * 10 tracts per manday",null,null,null,null,null,null,null,null,null,"CADD - (Office daily travel time / 8hrs in a working day )* 1 total trip to the project"]
[null,"Each formula assigned to the crew is used for each of the four crew members.",null,null,null,null,null,null,null,null,null,"CADD - # tracts * DF * 10 tracts per manday",null,null,null,null,null,null,null,null,null,"crew - ((crew daily travel time / 8hrs in a working day) * sum of days as calculated"]
[null,null,null,null,null,null,null,null,null,null,null,"crew - # tracts * DF * 6 tracts per crewday",null,null,null,null,null,null,null,null,null,"in items 1-16.) divided by ((8 hours in a working day - crew daily travel time) / 8 hours "]
[null,"No formulae are given for flagging.  Input the number of days needed directly",null,null,null,null,null,null,null,null,"10. Obtain topo verify aerial:",null,null,null,null,null,null,null,null,null,null,"in a working day))"]
[null,"into the spreadsheet.",null,null,null,null,null,null,null,null,null,"Engineer - L / 3.11 miles per manday"]
[null,null,null,null,null,null,null,null,null,null,null,"CADD - L * DF / 1.55 miles per manday + add 65% if no mapping is available"]
[null,null,null,null,null,null,null,null,null,null,null,"crew - L * DF / 0.31 miles per crewday + add 50% if no mapping is available"]
[null,null,null,null,null,null,null,null,null,null,"11. Drainage Surveys (Culverts)(Q<500 cfs):"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineer - L / 1.55 miles per manday   (Approx. 17 culverts per manday)"]
[null,null,null,null,null,null,null,null,null,null,null,"CADD - L  / 1.55 miles per manday  (Approx. 17 culverts per manday)"]
[null,null,null,null,null,null,null,null,null,null,null,"crew - L * DF / 0.5 miles per manday  (Approx. 5 culverts per manday)"]
[null,null,null,null,null,null,null,null,null,null,null,"(The underlying assumption is one pipe culvert every 500 feet)"]