{"text_format":"3","workbook":"xls","n_sheets":14,"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","SURVEY FORMS REVISIONS","DESIGN FORM REVISIONS","SURVEY MANDAY FORM INSTRUCTIONS","Module1"],"not_rendered":{"images":13,"macros":1,"external_links":4,"defined_names":17},"unopened":[{"sheet":"Module1","index":13,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"COVER SHEET","index":0,"n_rows":84,"n_cols":19,"rows_kept":84,"merged":[[10,0,10,8],[13,1,13,7],[15,1,15,7],[17,2,17,6],[19,2,19,6],[23,0,23,8],[24,0,29,8],[34,3,34,6],[35,3,35,6],[36,3,36,6],[37,3,37,6],[38,0,38,1],[38,3,38,6],[39,0,39,1],[39,3,39,6],[41,0,41,1],[42,0,42,1],[44,0,44,1],[45,0,45,1],[47,0,47,8],[49,0,49,2],[50,0,50,2],[52,0,52,2],[54,0,54,2],[55,0,55,8],[57,0,57,2],[60,0,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[64,0,64,2]],"flags":["formulas_cached_only"]}
[null,"Instructions:"]
[null,"(Enter state route number, project description,county, consultant's name,"]
[null,"prepared by name, and date prepared.  This information will be transferred"]
[null,"to all other sheets. The date prepared must be entered in the appropriate"]
[null,"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>"]
[{"$nulls":18},"Click Here to Select Type of Proposal from Drop Down List"]
[null,null,"<County>",{"$nulls":15},"For Design Only"]
[{"$nulls":18},"For Survey and Design"]
[null,null,"<000000.00>",{"$nulls":15},"For Signal Design"]
[{"$nulls":18},"For Survey Only"]
[{"$nulls":18},"For Full Location Survey Only"]
[{"$nulls":18},"For Proposed ROW and Easement Staking"]
["General Comments:",{"$nulls":17},"For Geotechnical Staking"]
[{"$nulls":18},"For A Survey Update"]
[{"$nulls":18},"For Additional Survey"]
{"$rows_empty":8}
[{"$nulls":3},"<Consultant>"]
[{"$nulls":3},"<Consultant Contact Person>"]
[{"$nulls":3},"<address>"]
[{"$nulls":3},"<phone>"]
["Prepared By:",null,null,"<fax>"]
["<Name>",null,null,"<e-mail>"]
[]
["Date prepared:"]
["<Date>"]
[]
["Project No.:"]
["<00000-0000-00>",{"$nulls":5},"Version 2.22"]
[]
["Checklist of discussion items for TDOT Consultant Survey Projects"]
[]
["TDOT Project Name:"]
["Geopak Job Number (GPK): "]
[]
["Survey Manual:",null,null,"Second Edition (Revised 5-25-04)"]
[]
["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 "]
[{"$nulls":3},"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,"merged":[[5,5,6,6],[28,2,28,3],[35,2,35,3]],"flags":["formulas_cached_only"]}
[]
["Survey Summary"]
["Route:","<Route>",null,"<Date>"]
["Description:","<Description>"]
["County:","<County>"]
["Consultant:","<Consultant>",{"$nulls":3},"INPUT SIDEROADS LT & RT OF CENTERLINE"]
["Prepared By:","<Name>"]
["Project No.:","<00000-0000-00>",{"$nulls":3},"Sideroad Name","Length (feet)"]
["Mainline Project Length:",{"v":0,"d":"0.00"},"(miles)"]
["Number of Sideroads:",0,"Length:",0,"(feet)"]
["Office Travel Time per day (hrs):",{"v":0,"d":"0.00"}]
["Crew Travel Time per day (hrs):",{"v":0,"d":"0.00"}]
["Crew Work per day (hrs):",8]
[]
["Number of Existing Lanes:",0,"Proposed:",0]
["Number of Driveways/Ramps:",0]
[]
["Location:"]
["Existing Road:",{"v":1,"d":"100%"},"Rural:",{"v":0.5,"d":"50%"}]
["New Alignment:",{"v":0,"d":"0%"},"     Urban:",{"v":0.5,"d":"50%"}]
[null,null," Business:",{"v":0,"d":"0%"}]
[]
["Rural Land Character:     Woods:",{"v":0.3,"d":"30%"},"Terrain:   Flat",{"v":0,"d":"0%"}]
["   Pasture:",{"v":0.7,"d":"70%"},"     Rolling:",{"v":0.6,"d":"60%"}]
["Cultivated:",{"v":0,"d":"0%"},"        Hilly:",{"v":0.4,"d":"40%"}]
[null,null,"Mountains:",{"v":0,"d":"0%"}]
[]
["Distance to Nearest Benchmark:",{"v":0,"d":"0.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:",{"v":1,"d":"100%"},"    Use 100% if no mapping is available."]
["Proposed DTM Width:",0,"(ft)",null,null,"Total Length",0]
[null,null,"Geotechnical Staking:"]
["Drainage:",null,"Points",0]
["    Approx. Number of Culvert Sites:",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:",{"$nulls":3},"Petroleum Pipeline:"]
[]
[{"$nulls":3},"Comments on Difficulty, Conditions or Other Considerations:"]
[]
[]
[]
[]
[{"$nulls":3},"Version 2.22"]

{"sheet":"SURVEY MANDAY ESTIMATE","index":2,"n_rows":39,"n_cols":18,"rows_kept":39,"merged":[[10,11,11,11],[10,12,11,12]],"flags":["formulas_cached_only"]}
["ESTIMATE FOR FIELD SURVEYS"]
["PROJECT DESCRIPTION:",{"$nulls":7},"Version 2.22",null,"PROJECT DESCRIPTION:",{"$nulls":6},"Version 2.22"]
["Route:","<Route>",{"$nulls":10},"Route:","<Route>"]
["Description:","<Description>",{"$nulls":10},"Description:","<Description>"]
["County:","<County>",{"$nulls":3},"Prepared By:","<Name>",{"$nulls":5},"County:","<County>"]
["Consultant:","<Consultant>",{"$nulls":5},"Date Prepared:","<Date>",{"$nulls":3},"Consultant:","<Consultant>"]
["Project No.:","<00000-0000-00>",{"$nulls":10},"Project No.:","<00000-0000-00>"]
["TOTAL LENGTH(miles):",{"v":0,"d":"0.00"},{"$nulls":11},"TOTAL LENGTH(miles):",{"v":0,"d":"0.00"}]
["OFFICE TRAVEL TIME PER DAY(hrs):",{"v":0,"d":"0.00"},{"$nulls":10},"Date Prepared:","<Date>",null,"Prepared By:","<Name>"]
["CREW TRAVEL TIME PER DAY(hrs):",{"v":0,"d":"0.00"}]
["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",{"$nulls":4},"REMARKS"]
["1.Establish & Stake Alignments",0,0,0,0,0,0,null,null,0,"Align.",0.5,0.5]
["2. Update Survey",0,0,0,0,0,0,null,null,0,"Update",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},0,"Survey Updates"]
["3. Control Traverses",0,0,0,0,0,0,null,null,0,"Control",{"v":1,"d":"1.0"},0.5]
["4. Set Aerial Control",0,0,0,0,0,0,null,null,0,"Aerial",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},0,0,"NUMBER HORIZONTAL  & NUMBER VERTICAL POINTS"]
["5. Bench Levels",0,0,0,0,0,0,null,null,0,"Levels",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},"ZERO IF NOT REQUIRED"]
["6. Develop Digital Terrain Model",0,0,0,0,0,0,null,null,0,"DTM",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"100%"},"PERCENT SKIPS",null,0,"DTM WIDTH(feet)"]
["7. R.O.W.,Deed & Utility Research"," ",0,{"$nulls":6},0,"Research",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},0,"NUMBER OF TRACTS"]
["8. Property Owner Contact"," ",null," ",{"$nulls":5},0,"Contacts",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
["9. Locate Property & Pres. R.O.W. Lines"," "," "," "," "," "," ",null,null,0,"Property",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},1,"DO NOT EDIT THESE CELLS"]
["10. Obtain Topo/Verify Aerial",0,0,0,0,0,0,null,null,0,"Topo",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["11. Drainage Surveys (Culverts)",0,0,0,0,0,0,null,null,0,"Culverts",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
["12. Bridge Surveys (bridge details, stream alignment, topo, profile, flood plain sections, high water, etc.",0,null,0,0,0,0,null,null,0,"Bridges",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},0,0,0,"NUMBER OF SMALL, MEDIUM, LARGE BRIDGES"]
["13. Railroad Surveys"," "," "," "," "," "," ",null,null,0,"RR",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},0,"NUMBER OF RR CROSSINGS"]
["14. Utilities",0,0,0,0,0,0,null,null,0,"Utilities",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},5,"Number of Different Utilities Involved"]
["15. Stake R.O.W. & Easements",0,0,0,0,0,0,null,null,0,"R.O.W.",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},false,true,true,true,"DO NOT EDIT THESE CELLS"]
["16. Stake Sounding Holes",0,0,0,0,0,0,null,null,0,"Geotech.",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},true,true,false,false]
["17. Note Reduction & other Calculations",0,{"$nulls":7},0,null,{"v":1,"d":"1.0"},null,0,0,0,"Number of IP's, 1-stake, 2-stakes"]
["18. Plot Plan, Profiles, Property Map, Drainage Map, Bridge Survey, Control Point Table, etc."," ",0,{"$nulls":6},0,"Plotting",{"v":1,"d":"1.0"},{"$nulls":3},0,"Number of Geotechnical Staking Points"]
["19. Supervision",0,{"$nulls":7},0,null,{"v":1,"d":"1.0"},null,{"$error":"#DIV/0!"},"8 - Hr MD/MILE not including travel"]
["20. Travel Time (8 HOUR MAN-DAYS)",0,0,0,0,0,0,0,0,0,null,{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"$error":"#DIV/0!"},"8 - Hr MD/MILE"]
["TOTALS (8 HOUR MAN-DAYS)",0,0,0,0,0,0,0,0,0,{"$nulls":3},"",""]
["","","","","","","","","","",{"$nulls":3},"",""]
["",null,null,"","","","","","",""]
["",null,null,"","","","","",""]
[]
[]
[{"$nulls":3}," ",null," "]

{"sheet":"SURVEY LABOR & DIRECT EXPENSES","index":3,"n_rows":60,"n_cols":25,"rows_kept":60,"merged":[[27,4,27,8],[28,4,28,8]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"SURVEY DIRECT LABOR COST",{"$nulls":15},"Version 2.22"]
[{"$nulls":12},"SURVEY DIRECT EXPENSES"]
[]
[null,"PROJECT DESCRIPTION:",{"$nulls":10},"PROJECT DESCRIPTION:"]
[null,"ROUTE:",null,"<Route>",{"$nulls":8},"ROUTE:","<Route>"]
[null,"DESCRIPTION:",null,"<Description>",{"$nulls":8},"DESCRIPTION:","<Description>"]
[null,"COUNTY:",null,"<County>",{"$nulls":8},"COUNTY:","<County>",null,"Prepared By:","<Name>"]
[null,"CONSULTANT:",null,"<Consultant>",null,"Prepared By:","<Name>",{"$nulls":5},"CONSULTANT:","<Consultant>",null,"Date Prepared:","<Date>"]
[null,"TOTAL LENGTH(miles):",null,{"v":0,"d":"0.00"},null,"Date Prepared:","<Date>",{"$nulls":5},"TOTAL LENGTH(miles):",{"v":0,"d":"0.00"},null,"Project No.:","<00000-0000-00>"]
[]
[{"$nulls":17},"Item Subtotal","Item Total Cost"]
[{"$nulls":12},"Reproduction Costs"]
[{"$nulls":3},"Abbrv.","Personnel Classification"," 8 - Hr Man-Days","","Approved Hours","Rate Per Hr","Direct Labor",""]
[null,null,1,"PM","PROJECT MANAGER",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,null,"Item Description",null,"Number / Unit","Unit Price"]
[null,null,2,"O","OFFICE CADD TECH.",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,null,"Xerographic Bond",null,0,0,0]
[null,null,3,"P","PARTY CHIEF",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,null,"Blueline Fullsize",null,0,0,0]
[null,null,4,"I","INSTR. MAN",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,null,"Photo-Copies",null,0,0,0]
[null,null,5,"R","RODMAN",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,null,"Deeds",null,0,0,0]
[null,null,6,"R","RODMAN",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",{"$nulls":6},"Subtotal",0]
[null,null,7,"F","FLAGGER",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,"Travel"]
[null,null,8,"F","FLAGGER",{"v":0,"d":"0.0"},"",{"v":8,"d":"8.0"},0,0,"",null,null,"Survey Crew Travel Calculations"]
[{"$nulls":12},"From:"]
[{"$nulls":4},"TOTALS",{"v":0,"d":"0.0"},"",null,null,0,"",null,"To:"]
[{"$nulls":4},"",null,""]
[]
[{"$nulls":4},"Direct Labor Cost Per   8 - Hour Man-Day","                          NA","                          NA","                          NA","                          NA",{"$error":"#DIV/0!"},{"$nulls":4},"Number of Trips","No. of Miles/No. of People","* RATE"]
[{"$nulls":4},"","NOT USED","NOT USED","NOT USED","NOT USED","",null,null,"Travel Day Per Diem  ",null,{"v":0,"d":" 0.00  Man-Days"},{"v":0,"d":"X       0.00  People    X"},{"v":0,"d":"$0.00  Per Day"},0,{"$nulls":6},0]
[{"$nulls":12},"Non Travel Day Per Diem",null,{"v":0,"d":" 0.00  Man-Days"},{"v":0,"d":"X       0.00  People    X"},{"v":0,"d":"$0.00  Per Day"},0,{"$nulls":6},0]
[{"$nulls":12},"Transportation",null,{"v":0,"d":" 0.00  Man-Days"},{"v":0,"d":"X       0.00  Miles        X"},{"v":0,"d":"$0.00  Per Mile"},0,{"$nulls":6},0]
[{"$nulls":6},"",{"$nulls":5},"Lodging  ",null,{"v":0,"d":"     0.00  Nights"},{"v":0,"d":"X       0.00  People    X"},{"v":0,"d":"$0.00  Per Person"},0,{"$nulls":6},0]
[{"$nulls":17},"Subtotal",0,{"$nulls":5},0]
[{"$nulls":13},"Office Personnel Travel Calculations",{"$nulls":10},0]
[{"$nulls":12},"From:"]
[{"$nulls":12},"To:"]
[]
[{"$nulls":14},"Number of Trips","No. of Miles/No. of People","* RATE"]
[{"$nulls":12},"Travel Day Per Diem  ",null,{"v":0,"d":" 0.00  Man-Days"},{"v":0,"d":"X       0.00  People    X"},{"v":0,"d":"$0.00  Per Day"},0]
[{"$nulls":12},"Non Travel Day Per Diem",null,{"v":0,"d":" 0.00  Man-Days"},{"v":0,"d":"X       0.00  People    X"},{"v":0,"d":"$0.00  Per Day"},0]
[{"$nulls":12},"Transportation ",null,{"v":0,"d":" 0.00  Round Trips"},{"v":0,"d":"X       0.00  Miles        X"},{"v":0,"d":"$0.00  Per Mile"},0]
[{"$nulls":12},"Lodging  ",null,{"v":0,"d":"     0.00  Nights"},{"v":0,"d":"X       0.00  People    X"},{"v":0,"d":"$0.00  Per Person"},0]
[{"$nulls":12},"Other Expenses",{"$nulls":4},"Subtotal",0]
[{"$nulls":13},"Item Description",null,"Number / Unit","Unit Price"]
[{"$nulls":15},0,0,0]
[{"$nulls":15},0,0,0]
[{"$nulls":15},0,0,0]
[{"$nulls":15},0,0,0]
[{"$nulls":15},0,0,0]
[{"$nulls":15},0,0,0]
[{"$nulls":15},0,0,0]
[{"$nulls":17},"Subtotal",0]
[]
[{"$nulls":12},"TOTAL DIRECT EXPENSES",{"$nulls":5},0]
[{"$nulls":4},"Version 2.22"]
[]
[]
[]
[{"$nulls":13},"*  Rate must agree with most current State of Tennessee travel regulations."]
[{"$nulls":13},"    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,"flags":["formulas_cached_only"]}
[null,"DESIGN MANDAY ESTIMATE",null,"PAGE A"]
[]
[null,"ROUTE:",null,"<Route>"]
[null,"DESCRIPTION:",null,"<Description>"]
[null,"COUNTY:",null,"<County>"]
[null,"CONSULTANT:",null,"<Consultant>"]
[null,"Prepared By:",null,"<Name>"]
[null,"Date Prepared:",null,"<Date>"]
[null,"Project No.:",null,"<00000-0000-00>",null,null,"Version 2.22"]
[]
["I.","PROJECT LENGTH",null,null,"(enter project length in miles)",null,"MILES"]
[]
[]
["II.","TYPICAL SECTIONS","(enter length of appropriate section or sections)"]
[null,"A.  NEW ALIGNMENT"]
[null,"      1.  Freeway - Controlled Access",null,"140 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Non - CA  (w/shoulders)",null,"140 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  Street (curb & gutter)",null,"150 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[]
[]
[null,"B.  WIDENING"]
[null,"      1.  Freeway - Controlled Access",null,"150 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[" ","      2.  Rural Roadway (w/shoulders)",null,"140 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  Street (curb & gutter)",null,"155 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[]
[]
[null,"C.  MISCELLANEOUS"]
[null,"      1.  Bridge replacement - rural",null,"110 M.D./Mile   (min. 75)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Bridge replacement - urban",null,"130 M.D./Mile   (w/c&g)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[]
[null,"TOTAL SECTION II",{"$nulls":3},{"v":0,"d":"0.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,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  8-12 Tracts/mile",null,"ADD 5%",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  13-16 Tracts/mile",null,"ADD 10%",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      4.  17-20 Tracts/mile",null,"ADD 15%",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      5.  > 20 Tracts/mile",null,"ADD 15% +",null,{"v":0,"d":"0.0"},"MANDAYS"]
[" ",null,null,"(1/2%/Tracts >20)"]
[null,"B.  TERRAIN"]
[" ","      1.  Mountainous or Rolling"]
[null,"           with high cuts/fills",null,"ADD 15%",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"C.  PLAN SCALE"]
[null,"     1.    100 Scale",null,"DEDUCT 10%",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"     2.      50 Scale",null,"NO CHANGE",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"     3.      20 Scale",null,"ADD 10%",null,{"v":0,"d":"0.0"},"MANDAYS"]
[]
[]
[null,"Subtotal Mandays (page A)",{"$nulls":3},{"v":0,"d":"0.0"},"MANDAYS"]
[]
[null,"(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":62,"n_cols":7,"rows_kept":62,"flags":["formulas_cached_only"]}
[null,"DESIGN MANDAY ESTIMATE",null,"PAGE B"]
[]
[null,"ROUTE:",null,"<Route>"]
[null,"DESCRIPTION:",null,"<Description>"]
[null,"COUNTY:",null,"<County>"]
[null,"CONSULTANT:",null,"<Consultant>"]
[null,"Prepared By:",null,"<Name>"]
[null,"Date Prepared:",null,"<Date>"]
[null,"Project No.:",null,"<00000-0000-00>",null,null,"Version 2.22"]
[]
["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,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"E.  RIGHT-OF-WAY"]
[null,"      1.  Prop. ROW calls on Pres. Layout",null,"NO CHANGE",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  ROW Detail Sheets Required",null,"2 M.D./ Sheet",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"F.  PUBLIC INVOLVEMENT"]
[null,"      1.  Additional meetings",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Special displays & renderings",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  Newsletters",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"G.  DRAINAGE"]
[null,"      1.  Retention/Detention Ponds",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Special details",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"H.  EROSION CONTROL PLANS"]
[null,"      1.  Additional EC phases",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Contour Sheets",null,"5 M.D./Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  Detention basin design",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      4.  Special details",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"I.  PERMITS"]
[null,"      1.  Permit drawings",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Mitigation plans",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  Revisions to plans",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"J.  GEOLOGY      "]
[null,"      1.  Retaining Wall Concept sheets",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Soils and Geology sheets",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"K.  TRAFFIC CONTROL PLANS"]
[null,"      1.  Complex traffic control design",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Special details - TMP",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"L.  INTERCHANGES  "]
[null,"      1.  Length of ramps",null,"100 M.D./ Mile",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"    (Length being start of separate profile)"]
[null,"      2.  Urban interchange design",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"M.  NO. OF CONSTRUCTION PROJECTS"]
[null,"      1.  One construction project",null,"NO CHANGE",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Additional construction projects",null,"20 M.D./ Project",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"N.  MISCELLANEOUS FACTORS"]
[null,"      1.  Value Engineering Reviews",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      2.  Constructability Reviews",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      3.  Signal Design",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      4.  Lighting Design",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"      5.  Signing Design",null,"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[{"$nulls":3},"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[{"$nulls":3},"(enter no. of mandays)",null,{"v":0,"d":"0.0"},"MANDAYS"]
[null,"Subtotal Mandays (page B)",{"$nulls":3},{"v":0,"d":"0.0"},"MANDAYS"]
[null,"Subtotal Mandays (page A)",{"$nulls":3},{"v":0,"d":"0.0"},"MANDAYS"]
[]
["VI.","TOTAL MANDAYS",{"$nulls":3},{"v":0,"d":"0.0"},"MANDAYS"]
[]
[null,"(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 LABOR & AVG. M.D.","index":6,"n_rows":69,"n_cols":7,"rows_kept":69,"flags":["formulas_cached_only"]}
["LABOR RATES"]
[]
[null,"ROUTE:",null,"<Route>","Project No.:",null,"<00000-0000-00>"]
[null,"DESCRIPTION:",null,"<Description>","PIN No.:",null,"<000000.00>"]
[null,"COUNTY:",null,"<County>"]
[null,"CONSULTANT:",null,"<Name>"]
[null,"Prepared By:",null,"<Name>"]
[null,"Date Prepared:",null,"<Date>"]
[null,"This sheet calculates the average mandays, labor cost, and average manday rate for each phase of a project."]
[null,"In the shaded blocks, enter the manday rate for each classification of personnel and the estimated percentage"]
[null,"for both the total project and the individual phases."]
[null,"Boxes that are not applicable should be left blank.",{"$nulls":4},"Version 2.22"]
["PERSONNEL",{"$nulls":3},"MANDAY RATE"]
["PROJECT MANAGER",{"$nulls":3},0]
["PROJECT ENGINEER",{"$nulls":3},0]
["ENGINEER",{"$nulls":3},0]
["CADD TECHNICIAN",{"$nulls":3},0]
["CAD DRAFTER",{"$nulls":3},0]
[]
["TOTAL MANDAYS",null,null," ",{"v":0,"d":"0.00"},"M.D."]
[]
["PERCENTAGE OF TOTAL PROJECT"]
["PRELIMINARY PLANS",{"$nulls":3},{"v":0,"d":"0.0"},"%"]
["RIGHT-OF-WAY PLANS ",{"$nulls":3},{"v":0,"d":"0.0"},"%"]
["CONSTRUCTION PLANS",{"$nulls":3},{"v":0,"d":"0.0"},"%"]
["TOTAL PROJECT",{"$nulls":3},{"v":0,"d":"0.0"},"%"]
[]
[]
["PRELIMINARY PLANS",null,{"v":0,"d":"0.0"},"% OF TOTAL PROJECT"," "," "," "]
[{"$nulls":4},"MANDAYS",null,"LABOR COSTS"]
[null,"PROJECT MANAGER",{"v":0,"d":"0.0"},"% PREL. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"PROJECT ENGINEER",{"v":0,"d":"0.0"},"% PREL. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"ENGINEER",{"v":0,"d":"0.0"},"% PREL. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"CADD TECHNICIAN",{"v":0,"d":"0.0"},"% PREL. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"CAD DRAFTER",{"v":0,"d":"0.0"},"% PREL. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,null,{"v":0,"d":"0.0"},"%"]
[]
[null,"TOTALS PRELIMINARY PLANS",null,null,{"v":0,"d":"0.0"},"M.D.",0]
[null,"PRELIMINARY PLANS AVERAGE RATE PER MANDAY ",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
["RIGHT-OF-WAY PLANS",null,{"v":0,"d":"0.0"},"% OF TOTAL PROJECT"]
[{"$nulls":4},"MANDAYS",null,"LABOR COSTS"]
[null,"PROJECT MANAGER",{"v":0,"d":"0.0"},"% R.O.W. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"PROJECT ENGINEER",{"v":0,"d":"0.0"},"% R.O.W. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"ENGINEER",{"v":0,"d":"0.0"},"% R.O.W. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"CADD TECHNICIAN",{"v":0,"d":"0.0"},"% R.O.W. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"CAD DRAFTER",{"v":0,"d":"0.0"},"% R.O.W. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,null,{"v":0,"d":"0.0"},"%"]
[]
[null,"TOTALS RIGHT-OF-WAY PLANS",null,null,{"v":0,"d":"0.0"},"M.D.",0]
[null,"RIGHT-OF-WAY PLANS AVERAGE RATE PER MANDAY",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
["CONSTRUCTION PLANS",null,{"v":0,"d":"0.0"},"% OF TOTAL PROJECT"]
[{"$nulls":4},"MANDAYS",null,"LABOR COSTS"]
[null,"PROJECT MANAGER",{"v":0,"d":"0.0"},"% CONST. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"PROJECT ENGINEER",{"v":0,"d":"0.0"},"% CONST. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"ENGINEER",{"v":0,"d":"0.0"},"% CONST. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"CADD TECHNICIAN",{"v":0,"d":"0.0"},"% CONST. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,"CAD DRAFTER",{"v":0,"d":"0.0"},"% CONST. PLANS",{"v":0,"d":"0.0"},"M.D.",0]
[null,null,{"v":0,"d":"0.0"},"%"]
[]
[null,"TOTAL MANDAYS CONSTRUCTION PLANS",null,null,{"v":0,"d":"0.0"},"M.D.",0]
[null,"CONSTRUCTION PLANS AVG. RATE PER MANDAY",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
[null,"TOTAL LABOR COSTS",{"$nulls":4},0]
[null,"AVERAGE RATE PER MANDAY",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
[]
[null,"(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,"flags":["formulas_cached_only"]}
[]
[]
["DESIGN DIRECT EXPENSES                                                                                                                                        "]
[{"$nulls":6},"Version 2.22"]
["ROUTE:",null,"<Route>","Project No.:",null,"<00000-0000-00>"]
["DESCRIPTION:",null,"<Description>","PIN No.:",null,"<000000.00>"]
["COUNTY:",null,"<County>"]
["CONSULTANT:",null,"<Consultant>"]
["Prepared By:",null,"<Name>"]
["Date Prepared:",null,"<Date>"]
[]
[{"$nulls":5},"Item Subtotal","Item Total Cost"]
["Reproduction Costs:"]
[{"$nulls":3},"(Enter quantity and unit price)"]
[null,"Item Description",null,"Number / Unit","Unit Price"]
[null,"Photo-copies",{"$nulls":3},0]
[null,"Full size bond",{"$nulls":3},0]
[null,"Half size bond",{"$nulls":3},0]
[null,"Full size vellum",{"$nulls":3},0]
[null,"Half size vellum",{"$nulls":3},0]
[null,"Full size mylar",{"$nulls":3},0,0]
[]
["Travel:"]
[{"$nulls":3},"(Enter number of trips, people or milage, and rate)"]
[null,null,"Number of Trips","No. of Miles/No. of People","RATE  *"]
["Per Diem (75%) ",{"$nulls":3},{"v":0,"d":"$0.00  Per Day"},0]
["Per Diem  ",{"$nulls":3},{"v":0,"d":"$0.00  Per Day"},0]
["Transportation",{"$nulls":3},{"v":0,"d":"$0.00  Per Day"},0]
["Lodging  ",{"$nulls":3},{"v":0,"d":"$0.00  Per Person"},0,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:"]
[{"$nulls":3},"(Enter description, number and unit price.)"]
[null,"Item Description",null,"Number / Unit","Unit Price"]
[{"$nulls":3},0,0,0]
[{"$nulls":3},0,0,0]
[{"$nulls":3},0,0,0]
[{"$nulls":3},0,0,0]
[{"$nulls":3},0,0,0]
[{"$nulls":3},0,0,0]
[{"$nulls":3},0,0,0,0]
[]
[]
["TOTAL DIRECT EXPENSES",{"$nulls":5},0]
[]
[null,"(Place X in adjacent box if allocation of direct expenses is to be different than total project allocation percentage.)"]
[]
[""]
["",null,""]
["",null,""]
["",null,""]
[]
["DIRECT EXPENSES PRELIMINARY PLANS",{"$nulls":3},{"v":0,"d":"0.0"},"% ",0]
["DIRECT EXPENSES RIGHT-OF-WAY PLAN",{"$nulls":3},{"v":0,"d":"0.0"},"% ",0]
["DIRECT EXPENSES CONSTRUCTION PLANS",{"$nulls":3},{"v":0,"d":"0.0"},"% ",0]
[{"$nulls":4},{"v":0,"d":"0.0"},"%"]
[null,null,"( Place X in box to remove instructions prior to printing."]
[]
[{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},"(Do not edit or place data in these cells.)"]
[{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]

{"sheet":"FEE PROPOSAL","index":8,"n_rows":155,"n_cols":11,"rows_kept":155,"merged":[[14,0,14,2]],"flags":["formulas_cached_only"]}
["FEE PROPOSAL"]
[]
["ROUTE:",null,"<Route>",{"$nulls":3},"Project No.:",null,"<00000-0000-00>"]
["DESCRIPTION:",null,"<Description>",{"$nulls":3},"PIN No.:",null,"<000000.00>"]
["COUNTY:",null,"<County>"]
["CONSULTANT:",null,"<Consultant>"]
["Prepared By:",null,"<Name>"]
["Date Prepared:",null,"<Date>"]
["COMPLETE SURVEY SHEETS FIRST IF SURVEY IS INCLUDED IN THE CONTRACT."]
["PROCEED WITH FEE PROPOSAL IF SURVEY IS NOT INCLUDED."]
["This sheet computes percent net fee and performs fee proposal calculations for each phase of the project and total project."]
["Enter the appropriate overhead rate & fill in shaded boxes that apply for each phase.",{"$nulls":7},"Version 2.22"]
[]
["Data For Fee Calculations"]
["Overhead Rate  =",{"$nulls":3},"**",null,""]
["**  (State Project Maximum overhead rate = 1.45)"]
["**  (Federal Project Maximum overhead rate per External Audit Report)"]
["Design Direct Labor =",null,null,0]
["Survey Direct Labor  =",null,null,0]
["Total Direct Labor =",null,null,0]
[]
["Cost for net fee basis =",null,null,0,"*","NOTE: Net Fee for Supplements shall be the same"]
["Net Fee = (Rounded to Nearest Tenth)",null,null,{"v":0,"d":"0.0%"},"*","            as the original contract.  It may be necessary"]
[{"$nulls":5},"            to modify net fee calculated on supplement requests."]
["*  Net fee is based on cost of contract not including direct cost and net fee as follows:"]
[]
["Survey & Design / Design Only Rates",{"$nulls":5},"Survey Only Rates"]
["   $         0 - $ 100,000 =",null,{"v":0.13,"d":"13.0%"},null,null,"   $            0 - $ 50,000 =",{"v":0.13,"d":"13.0%"}]
["  $100000 - $ 500,000 =",null,{"v":0.125,"d":"12.5%"},null,null,"        $ 50,000 - $ 200,000 =",{"v":0.125,"d":"12.5%"}]
["> $ 500,000                  =",null,{"v":0.12,"d":"12.0%"},null,null,"   > $200,000                   =",{"v":0.12,"d":"12.0%"}]
[]
[null,"(Place X in adjacent box to remove instructions prior to printing.)"]
[]
[]
["SURVEYS",{"$nulls":7},"","",""]
[{"$nulls":8},"","",""]
[1,"Direct Labor",{"$nulls":5},"=",0,"",""]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"v":0,"d":"0.0000"},")","=",0,"",""]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",{"$nulls":4},"=",0,"",""]
[]
[4,"Net Fee =",{"v":0,"d":"0.0%"},{"$nulls":3},"(Rounded to nearest $10.)","=",0,"",""]
[null,"(Direct labor X 2.35 X 0.NF)"]
[]
[5,null,"Subtotal    3    +    4    ",{"$nulls":4},"=",0,"",""]
[]
[6,"Direct Expense",{"$nulls":5},"=",0,"",""]
[]
[7,"Premium Labor",{"$nulls":5},"=",0,"",""]
[null,"(Premium Labor is only eligible if the survey crew works greater than a 40 hour work week.)"]
[8,null,"Total Survey",{"$nulls":4},"=",0,"",""]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
[{"$nulls":8},"Version 2.22"]
["Preliminary Design"]
[]
[1,"Direct Labor",{"$nulls":5},"=",0]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"v":0,"d":"0.0000"},")","=",0]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",{"$nulls":4},"=",0]
[]
[4,"Net Fee =",{"v":0,"d":"0.0%"},{"$nulls":3},"(Rounded to nearest $10.)","=",0]
[null,"(Direct labor X 2.35 X 0.NF)"]
[]
[5,null,"Subtotal    3    +    4    ",{"$nulls":4},"=",0]
[]
[6,"Direct Expense",{"$nulls":5},"=",0]
[]
[7,"Premium Labor",{"$nulls":5},"=",0]
[]
[8,null,"Total Preliminary Plans",{"$nulls":4},"=",0]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
["Right-of-Way Design"]
[]
[1,"Direct Labor",{"$nulls":5},"=",0]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"v":0,"d":"0.0000"},")","=",0]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",{"$nulls":4},"=",0]
[]
[4,"Net Fee =",{"v":0,"d":"0.0%"},{"$nulls":3},"(Rounded to nearest $10.)","=",0]
[null,"(Direct labor X 2.35 X 0.NF)"]
[]
[5,null,"Subtotal    3    +    4    ",{"$nulls":4},"=",0]
[]
[6,"Direct Expense",{"$nulls":5},"=",0]
[]
[7,"Premium Labor",{"$nulls":5},"=",0]
[]
[8,null,"Total Right-of-Way Plans",{"$nulls":4},"=",0]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
[{"$nulls":8},"Version 2.22"]
["Construction Design"]
[]
[1,"Direct Labor",{"$nulls":5},"=",0]
[]
[2,"Overhead",null,"(Overhead Rate  =",null,{"v":0,"d":"0.0000"},")","=",0]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",{"$nulls":4},"=",0]
[]
[4,"Net Fee =",{"v":0,"d":"0.0%"},{"$nulls":3},"(Rounded to nearest $10.)","=",0]
[null,"(Direct labor X 2.35 X 0.NF)"]
[]
[5,null,"Subtotal    3    +    4    ",{"$nulls":4},"=",0]
[]
[6,"Direct Expense",{"$nulls":5},"=",0]
[]
[7,"Premium Labor",{"$nulls":5},"=",0]
[]
[8,null,"Total Construction Plans",{"$nulls":4},"=",0]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
["Total Project"]
[]
[1,"Direct Labor",{"$nulls":5},"=",0]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Direct Labor)"]
[2,"Overhead",null,"(Overhead Rate  =",null,{"v":0,"d":"0.0000"},")","=",0]
[" ","(Overhead rate X direct labor)"]
[]
[3,null,"Subtotal    1    +    2    ",{"$nulls":4},"=",0]
[]
[4,"Net Fee =",{"v":0,"d":"0.0%"},{"$nulls":3},"(Rounded to nearest $10.)","=",0]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Net Fee)"]
[]
[5,null,"Subtotal    3    +    4    ",{"$nulls":4},"=",0]
[]
[6,"Direct Expense",null,"( Itemize and attach )",{"$nulls":3},"=",0]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Direct Expenses)"]
[7,"Premium Labor",{"$nulls":5},"=",0]
[null,"(Sum of Survey, Prel., R.O.W., & Const. Premium Labor)"]
[8,null,"Total Project",{"$nulls":4},"=",0]
[null,null,"(Total  5 +  6  +  7)    "]
[]
[]
[{"$nulls":5},"Total Contract",null,null,0]
[]
[]
[]
[{"$nulls":3},"DESIGN COST PER MILE",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
[{"$nulls":3},"SURVEY COST PER MILE",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
[{"$nulls":3},"TOTAL COST PER MILE",{"$nulls":4},{"$error":"#DIV/0!"}]

{"sheet":"FEE PROPOSAL SUMMARY","index":9,"n_rows":54,"n_cols":11,"rows_kept":54,"flags":["formulas_cached_only"]}
[null,"FEE PROPOSAL SUMMARY"]
[]
[null,"ROUTE:",null,"<Route>",null,"Project No.:",null,"<00000-0000-00>"]
[null,"DESCRIPTION:",null,"<Description>",null,"PIN No.:",null,"<000000.00>"]
[null,"COUNTY:",null,"<County>"]
[null,"CONSULTANT:",null,"<Consultant>"]
[null,"Prepared By:",null,"<Name>"]
[null,"Date Prepared:",null,"<Date>"]
[null,"mark the appropriate box below an values for the initial ceiling will be calculated."]
[{"$nulls":10},"Version 2.22"]
[null,"Survey Fee Proposal Summary"]
[null,null,"Direct Labor","Overhead","Subtotal","Net Fee","Subtotal","Direct ","Premium ","Total"]
[{"$nulls":4},"Direct Labor &",null,"Direct Labor,","Expense","Labor","Phase"]
[{"$nulls":4},"Overhead",null,"Overhead, &"]
[{"$nulls":6},"Net Fee"]
[null,"SURVEY",0,0,0,0,0,0,0,0]
[]
[]
[null,"Design Fee Proposal Summary"]
[null,null,"Direct Labor","Overhead","Subtotal","Net Fee","Subtotal","Direct ","Premium ","Total"]
[{"$nulls":4},"Direct Labor &",null,"Direct Labor,","Expense","Labor","Phase"]
[{"$nulls":4},"Overhead",null,"Overhead, &"]
[{"$nulls":6},"Net Fee"]
[null,"PRELIMINARY PLANS",0,0,0,0,0,0,0,0]
[null,"RIGHT-OF-WAY PLANS",0,0,0,0,0,0,0,0]
[null,"Subtotal Preliminary &",0,0,0,0,0,0,0,0]
[null,"Right-of-Way Plans"]
[null,"CONSTRUCTION PLANS",0,0,0,0,0,0,0,0]
[null,"Subtotal Preliminary, R.O.W.,",0,0,0,0,0,0,0,0]
[null,"& Construction Plans"]
[]
[null,"Total Survey & Design",0,0,0,0,0,0,0,0]
[]
[null,"(Place a X in appropriate box indicating the point of the initial contract ceiling.  Only one (1) block should have an X placed.)"]
[null,"(Note: (Survey thru Const. Plans) can be checked if no initial contract ceiling is to be set.)"]
[null,"Survey","","","","","","","",""]
[null,"Survey thru Prel. Plans","","","","","","","",""]
[null,"Survey thru R.O.W. Plans","","","","","","","",""]
[null,"Survey thru Const. Plans","","","","","","","",""]
[null,"Prel. Plans","","","","","","","",""]
[null,"Prel & R.O.W. Plans","","","","","","","",""]
[null,"Prel. Thru Const. Plans","","","","","","","",""]
[]
[null,"INITIAL CONTRACT CEILING"]
[null,null,"Direct Labor","Overhead","Subtotal","Net Fee","Subtotal","Direct ","Premium ","Total"]
[{"$nulls":4},"Direct Labor &",null,"Direct Labor,","Expense","Labor","Ceiling"]
[{"$nulls":4},"Overhead",null,"Overhead, &"]
[{"$nulls":6},"Net Fee"]
[null,"Contract will initially be"]
[null,"authorized for:"]
[null,"","","","","","","","",""]
[]
[]
[null,"(Place X in adjacent box to remove instructions prior to printing.)"]

{"sheet":"SURVEY FORMS REVISIONS","index":10,"n_rows":38,"n_cols":13,"rows_kept":38,"flags":["formulas_cached_only"]}
["Version 2.22"]
["REVISIONS TO EXCEL MAN-DAY SPREADSHEET"]
["SURVEY FORMS"]
["Date ",null,"Worksheet Revised","Version","Description",{"$nulls":7},"Revised By"]
[{"$nulls":12},"JHW"]
["1998-06-01",null,"Survey Manday",null,"Changed travel time equations to match discussion at meeting of May 4, 1998.",{"$nulls":7},"JHW"]
["1998-06-01",null,"Survey Manday Form Instructions",null,"Changed travel time equations to match discussion at meeting of May 4, 1998.",{"$nulls":7},"JRG"]
["1998-06-01",null,"All Sheets",null,"Changed gray background to a lighter shade of gray for copying and faxing.",{"$nulls":7},"JHW"]
["1998-06-01",null,"Survey Summary",null,"Changed the number of decimal places on the English project length to two.",{"$nulls":7},"JHW"]
["1998-06-01",null,"Survey Summary",null,"Changed culvert site background to gray with red text to prompt for allowable manual input.",{"$nulls":7},"JHW"]
["1998-06-01",null,"Survey Labor & Direct Expenses",null,"Changed default values and some of the format of profit rate.",{"$nulls":7},"JHW"]
["1998-06-08",null,"Survey Manday",null,"Changed equation for mandays/km &mandays/mile to include only mainline length.",{"$nulls":7},"JHW"]
["1998-06-22",null,"Survey Summary & Survey Manday",null,"Changed travel time to allow for crew and aoofce varying rates.",{"$nulls":7},"JHW"]
["1998-06-22",null,"All Sheets",null,"Added Version Number on all pages except for Instructions Page.",{"$nulls":7},"JHW"]
["1998-06-22",null,"Survey Manday Form Instructions",null,"Modified Equations to match travel.",{"$nulls":7},"JHW"]
["1998-06-30",null,"Survey Summary",1.01,"Added Round command to stop rounding problems. (Changed to version 1.01)",{"$nulls":7},"JHW"]
["1998-09-28",null,"Survey Summary",1.02,"Modified to allow English Units Input (Changed to version 1.02)",{"$nulls":7},"JRG/JHW"]
["1999-01-07",null,"All Sheets",1.02,"Eliminated metric, Combined with Design, Incorporated Invoice Sheet",{"$nulls":7},"JRG/JHW"]
["1999-02-22",null,"Several Sheets",{"v":2,"d":"2.00"},"See Design Comments",{"$nulls":7},"JHW"]
["1999-04-15",null,"Summary,Estimate, & Instructions",2.01,"Modified Equations for Rounding Errors, Modified Mapping Check Box Errors, Updated Instructions. (Version 2.01)",{"$nulls":7},"JHW"]
["2000-04-04",null,"All Sheets",2.02,"Duplicated row headings on page 2 of estimate, Removed page protection, Added sideroad list, ",{"$nulls":7},"JRG/JHW"]
[{"$nulls":4},"Added MD per mile less travel for information, Added contact person information,"]
[{"$nulls":4},"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 ",{"$nulls":7},"JHW"]
[null,null,"Cover Sheet",null,"New Print Button For In-House Use. Added Difficulty for Property Owner Contacts., Added Checklist Sheet for "]
[{"$nulls":4},"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",{"v":2.1,"d":"2.10"},"(Changed to version 2.10)",{"$nulls":7},"JHW/WJG"]
["2004-03-05",null,"All Sheets",2.11,"Changed TDOT logo to new logo",{"$nulls":7},"JHW/WJG"]
["2004-03-08",null,"Survey Invoice ",2.11,"Deleted Invoice Sheet",{"$nulls":7},"JHW "]
["2007-03-30",null,null,2.2,"Updated entire template",{"$nulls":7},"FMM/JHW"]
["2010-03-03",null,"Cover Sheet, Survey Summary,",2.22,"Changed to version 2.22, Changed default crew work per day hours to 8, Revised default rural land character percentages,  ",{"$nulls":7},"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,"and reproduction unit prices, Added footnote pertaining to the use of the most current travel rates  "]

{"sheet":"DESIGN FORM REVISIONS","index":11,"n_rows":49,"n_cols":12,"rows_kept":49,"flags":["formulas_cached_only"]}
[]
["REVISIONS TO EXCEL MAN-DAY SPREADSHEET"]
["DESIGN FORMS & FEE PROPOSAL SHEETS"]
[]
[{"$nulls":11},"Version 2.22"]
["Date ",null,"Worksheet Revised","Version","Description",{"$nulls":6},"Revised By"]
[]
["1998-07-21",null,"All sheets",1.01,"1) Add cover sheet, design direct expenses sheet, design form revisions sheet.",{"$nulls":6},"MA"]
[{"$nulls":4},"2) Added survey manday estimate sheets (Equations and factors match"]
[{"$nulls":4},"survey estimate version 1.01.)"]
[{"$nulls":4},"3) Added version to all sheets."]
[{"$nulls":4},"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 ",{"$nulls":6},"MA"]
[{"$nulls":4},"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.",{"$nulls":6},"MA"]
["1998-07-28",null,"All Sheets",1.02,"1) Changed version No. to 1.02.",{"$nulls":6},"MA"]
["1998-07-28",null,"Design Mandays",1.02,"1) Added round command to total mandays column. ",{"$nulls":6},"MA"]
[{"$nulls":4},"2) Add 3-5 lane curb and gutter typicals to section II (Typical Sections)."]
[{"$nulls":4},"3) Deleted curb and gutter factors from section III (Other Factors)."]
[{"$nulls":4},"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.",{"$nulls":6},"MA"]
["1998-10-20",null,"Design Mandays",1.03,"1) Changed project length input from metric to English.",{"$nulls":6},"MA"]
["1998-10-20",null,"All Sheets",1.03,"1) Changed version to 1.03.",{"$nulls":6},"MA"]
["1998-10-20",null,"Cover Sheet",1.03,"1) Added Two Print Macro Buttons",{"$nulls":6},"MA"]
["1998-12-14",null,"Fee Proposal",1.04,"1)Corrected Survey direct labor equation in cell D18.",{"$nulls":6},"MA"]
[{"$nulls":4},"2)Added round command to formulas",{"$nulls":6},"MA"]
["1998-12-14",null,"Fee Proposal Summary",1.04,"1)Added sheet to workbook.",{"$nulls":6},"MA"]
["1998-12-14",null,"All Sheets",1.04,"1) Changed version to 1.04",{"$nulls":6},"MA"]
[{"$nulls":4},"2)Minor modifictions to sheets.",{"$nulls":6},"MA"]
[{"$nulls":4},"3) Changed location to input project description to cover sheet .",{"$nulls":6},"MA"]
[{"$nulls":4},"4) Changed shading for input areas.",{"$nulls":6},"MA"]
["1998-12-14",null,"Design Mandays",1.04,"1) Changed plan scales to English.",{"$nulls":6},"MA"]
[{"$nulls":4},"2) Modified instructions in other factors section.",{"$nulls":6},"MA"]
["1998-12-14",null,"Design Direct Expenses",1.04,"1) Add option to vary percentage of direct expense percentage.",{"$nulls":6},"MA"]
["1998-12-14",null,"Design Manday Breakdown",1.04,"1) Incorporated design labor into design labor & M.D. rate sheet and deleted.",{"$nulls":6},"MA"]
["1999-01-07",null,"several",1.04,"Referenced Project Summary for Header Information",{"$nulls":6},"JRG"]
["1999-02-22",null,"Several",1.04,"Modified Fee Proposal, Cover Sheet, Corrected Estimate Equations",{"$nulls":6},"JHW"]
["1999-02-23",null,"All sheets",{"v":2,"d":"2.00"},"Changed version to 2.00",{"$nulls":6},"MA"]
["1999-04-15",null,"All sheets",2.01,"Changed version to 2.01",{"$nulls":6},"MA"]
["1999-04-15",null,"Fee Proposal ",2.01,"Changed information under total project ",{"$nulls":6},"MA"]
["2000-04-04",null,"All sheets",2.02,"Changed version to 2.02",{"$nulls":6},"MA"]
["2000-04-04",null,"Design Direct Expenses",2.02,"Changed travel expense rates block.",{"$nulls":6},"MA"]
["2000-04-04",null,"Design Mandays",2.02,"Changed curb and gutter descriptions",{"$nulls":6},"MA"]
["2000-04-04",null,"Fee Proposal",2.02,"Added instruction regarding net fee calculation.",{"$nulls":6},"MA"]
["2004-03-05",null,"All Sheets",2.11,"Changed TDOT logo to new logo",{"$nulls":6},"JHW/WJG"]
["2004-03-08",null,"Design Invoice",2.11,"Deleted Design Invoice Sheet",{"$nulls":6},"JHW"]
["2007-03-30",null,null,2.2,"Updated entire template",{"$nulls":6},"FMM/JHW"]
["2008-04-09",null,"Design Mandays",2.21,"Minor updates to shts A & B (formerly 7 & 7A); changed version to 2.21",{"$nulls":6},"FMM"]
["2010-03-03",null,"Design Mandays B",2.22,"Changed contour sheets criteria from 20 md/mile to 5 md/mile",{"$nulls":6},"FMM/JHW"]

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