{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title Sheet","1.1 Engineering","2.1 Labor and Materials","3.1 Easements & Inspection","4.1 Relocation Estimate ","5.1 Move Prior Obligation","6.1 Calendar Days","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title Sheet","index":0,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,0,59,5],[42,2,42,4],[46,2,46,4],[48,2,48,4],[50,2,50,4],[52,2,52,4],[44,1,44,4],[26,2,26,4],[28,2,28,4],[34,2,34,4],[38,2,38,4],[40,2,40,4],[32,2,32,4],[30,1,30,4],[13,0,13,5],[18,2,18,4],[20,2,20,4],[24,2,24,4],[16,1,16,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["UTILITY ENGINEERING AND RELOCATION ESTIMATE"]
[]
[]
[null,"UTILITY INFORMATION"]
[]
[null,"Utility Name:"]
[]
[null,"Utility Address:"]
[]
[null,"City, State:",null,"Zip Code:"]
[]
[null,"Phone:"]
[]
[null,"Contact Name:"]
[]
[null,"Email:"]
[]
[null,"CONSULTANT INFORMATION"]
[]
[null,"Consultant Name:"]
[]
[null,"Consultant Address:"]
[]
[null,null,null,"Zip Code:"]
[]
[null,"Phone:"]
[]
[null,"Contact Name:"]
[]
[null,"Email:"]
[]
[null,"TDOT PROJECT INFORMATION"]
[]
[null,"Project Description:"]
[]
[null,"Federal Project No.:"]
[]
[null,"State Project No.:"]
[]
[null,"County(ies):"]
[]
[]
[]
[]
[]
[]
["Revision 04/12/2024"]

{"sheet":"1.1 Engineering","index":1,"n_rows":101,"n_cols":20,"rows_kept":101,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[8,1,8,2],[8,10,8,11],[8,7,8,9],[6,0,6,4],[7,0,7,4],[88,7,88,9],[88,11,88,13],[91,7,91,9],[91,11,91,13],[0,1,1,13],[11,0,11,13],[62,0,62,13],[82,1,82,3],[83,1,83,3],[84,1,84,3],[88,0,88,1],[88,3,88,5],[64,3,64,5],[64,7,64,9],[64,11,64,13],[75,0,75,1],[77,3,77,5],[77,7,77,9],[77,11,77,13],[3,7,3,8],[6,7,6,13],[7,7,7,13],[3,9,3,13],[30,11,30,13],[41,11,41,13],[55,9,55,13],[44,3,44,5],[47,0,47,13],[44,7,44,9],[44,11,44,13],[49,7,49,9],[49,11,49,13],[28,0,28,1],[15,11,15,13],[15,7,15,9],[14,5,14,6],[15,3,15,5],[44,0,44,1],[30,7,30,9],[35,1,35,3],[36,1,36,3],[41,3,41,5],[41,0,41,1],[30,3,30,5],[41,7,41,9],[37,1,37,3]]}
[null,"ESTIMATE OF ENGINEERING COST"]
[]
[]
["TDOT Project Number(s):",{"$f":"T('Title Sheet'!C49)","v":""},null,{"$f":"T('Title Sheet'!C51)","v":""},null,null,null,"County(ies):",null,{"$f":"T('Title Sheet'!C53)","v":""}]
[]
["Utility Name & Address:",null,null,null,null,null,null,"Consultant Name & Address:"]
[{"$f":"T('Title Sheet'!C19)","v":""},null,null,null,null,null,null,{"$f":"T('Title Sheet'!C33)","v":""}]
[{"$f":"T('Title Sheet'!C21)","v":""},null,null,null,null,null,null,{"$f":"T('Title Sheet'!C35)","v":""}]
[{"$f":"T('Title Sheet'!C23)","v":""},{"$f":"'Title Sheet'!E23","v":0},null,null,null,null,null,{"$f":"T('Title Sheet'!C37)","v":""},null,null,{"$f":"('Title Sheet'!E37)","v":0}]
[]
[]
["CONSULTANT ENGINEERING ESTIMATE"]
[]
["Place an \"X\" in the appropriate box:",null,null,"Standard Contract",null,null,"x","Continuing Contract (attach copy of Contract for TDOT verification)",null,null,null,null,null,null,null,null,null,null,null,"x"]
[]
["I. ENGINEERING SERVICES",null,null,"PRE-CONSTRUCTION",null,null,null,"CONSTRUCTION",null,null,null,"CONSTRUCTION INSPECTION"]
["Classification","Rate/Hr",null,"Hours",null,"Total",null,"Hours",null,"Total",null,"Hours",null,"Total"]
["Principal",null,null,null,null,{"$f":"B18*D18","v":0},null,null,null,{"$f":"B18*H18","v":0},null,null,null,{"$f":"B18*L18","v":0}]
["Project Manager",null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"B19*L19","v":0}]
["Design Engineer",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Designer / Senior Designer",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Techician / Draftsperson",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Administrative",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Field Inspector",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Licensed Surveyor",null,null,null,null,{"$f":"B25*D25","v":0},null,null,null,0,null,null,null,0]
["Rod Person",null,null,null,null,{"$f":"B26*D26","v":0},null,null,null,0,null,null,null,0]
[null,0,null,null,null,{"$f":"B27*D27","v":0},null,null,null,0,null,null,null,0]
[]
["Total Engineering Services",null,null,{"$f":"SUM(D18:D27)","v":0},null,{"$f":"SUM(F18:F27)","v":0},null,{"$f":"SUM(H18:H27)","v":0},null,{"$f":"SUM(J18:J27)","v":0},null,{"$f":"SUM(L18:L27)","v":0},null,{"$f":"SUM(N18:N27)","v":0}]
[]
["II. REIMBURSABLE EXPENSES"]
[null,"Cost/Unit",null,"Quantity",null,"Total",null,"Quantity",null,"Total",null,"Quantity",null,"Total"]
["Transportation / Mile:",0.65500000000000003,"X",null,"=",{"$f":"B33*D33","v":0},null,null,null,{"$f":"SUM(B33*H33)","v":0},null,null,"=",{"$f":"B33*L33","v":0}]
["Meals / Day:",null,"X",null,"=",{"$f":"B34*D34","v":0},null,null,null,{"$f":"SUM(B34*H34)","v":0},null,null,"=",{"$f":"B34*L34","v":0}]
["Lodging / Day:",null,"X",null,"=",{"$f":"B35*D35","v":0},null,null,null,{"$f":"SUM(B35*H35)","v":0},null,null,"=",{"$f":"B35*L35","v":0}]
["Printing / Shipping:"]
["Other (Specify):"]
["Other (Specify):"]
[]
["Total Reimbursable Expenses",null,null,null,null,{"$f":"SUM(F33:F38)","v":0},null,null,null,{"$f":"SUM(J33:J38)","v":0},null,null,null,{"$f":"SUM(N33:N38)","v":0}]
[]
["III. INDIRECT / OVERHEAD EXPENSES"]
["Indirect/Overhead Rate (not to exceed 145%):",null,null,1.25,null,{"$f":"IF(C14=\"x\",F29*D43,0)","v":0},null,1.25,null,{"$f":"IF(C14=\"x\",J29*H43,0)","v":0},null,1.25,null,{"$f":"IF(C14=\"x\",N29*L43,0)","v":0}]
[]
["IV. PROFIT: (2.35x(1,2,3)x ALLOWABLE RATE)"]
["Allowable Rate (Maximum of 13%):",null,null,0.1,null,{"$f":"IF(C14=\"x\",2.35*(F29)*D46,0)","v":0},null,0.1,null,{"$f":"IF(C14=\"x\",2.35*(J29)*H46,0)","v":0},null,0.1,null,{"$f":"IF(C14=\"x\",2.35*(N29)*L46,0)","v":0}]
[]
["(Expenses for Sections III and IV only apply to Consultant Engineering Services without a Continuing Contract agreement with the Utility)"]
[]
["TOTAL ENGINEERING / SURVEY COST:",null,null,null,null,null,null,"INSPECTION (Standard)",null,null,null,"INSPECTION (Continuing)"]
[]
["Standard Consultant: (I+II+III+IV) =",null,null,null,null,{"$f":"IF(C14=\"x\",F29+F40+F43+F46+J29+J40+J43+J46,0)","v":0},null,"Private:",null,{"$f":"ROUND(IF(C14=\"x\",N29+N40+N43+N46)*'4.1 Relocation Estimate '!C15,2)","v":0},null,"Private:",null,{"$f":"ROUND(IF(G14=\"x\",N29+N40)*'4.1 Relocation Estimate '!C15,2)","v":0}]
[]
["Continuing Contract: (I+II) =",null,null,null,null,{"$f":"IF(G14=\"x\",F29+J29+F40+J40,0)","v":0},null,"Public:",null,{"$f":"ROUND(IF(C14=\"x\",N29+N40+N43+N46)*'4.1 Relocation Estimate '!C16,2)","v":0},null,"Public:",null,{"$f":"ROUND(IF(G14=\"x\",N29+N40)*'4.1 Relocation Estimate '!C16,2)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL COST (Engineering and Inspection)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Standard Consultant:",null,{"$f":"SUM(F52,J52,J54)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Continuing Contract:",null,{"$f":"SUM(F54,N52,N54)","v":0}]
[]
[]
["IN-HOUSE ENGINEERING ESTIMATE"]
[]
["I. ENGINEERING SERVICES",null,null,"PRE-CONSTRUCTION",null,null,null,"CONSTRUCTION",null,null,null,"CONSTRUCTION INSPECTION"]
["Classification","Rate/Hr",null,"Hours",null,"Total",null,"Hours",null,"Total",null,"Hours",null,"Total"]
["Project Manager",null,null,null,null,{"$f":"B67*D67","v":0},null,null,null,{"$f":"B67*H67","v":0},null,null,null,{"$f":"B67*L67","v":0}]
["Engineer",null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"B68*L68","v":0}]
["Draftperson",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Administrative",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Field Inspector",null,null,null,null,0,null,null,null,0,null,null,null,0]
["Licensed Surveyor",null,null,null,null,{"$f":"B72*D72","v":0},null,null,null,0,null,null,null,0]
["Rod Person",null,null,null,null,{"$f":"B73*D73","v":0},null,null,null,0,null,null,null,0]
[null,0,null,null,null,{"$f":"B74*D74","v":0},null,null,null,0,null,null,null,0]
[]
["Total Engineering Services",null,null,{"$f":"SUM(D67:D74)","v":0},null,{"$f":"SUM(F67:F74)","v":0},null,{"$f":"SUM(H67:H74)","v":0},null,{"$f":"SUM(J67:J74)","v":0},null,{"$f":"SUM(L67:L74)","v":0},null,{"$f":"SUM(N67:N74)","v":0}]
[]
["II. REIMBURSABLE EXPENSES"]
[null,"Cost/Unit",null,"Quantity",null,"Total",null,"Quantity",null,"Total",null,"Quantity",null,"Total"]
["Transportation / Mile:",null,"X",null,"=",{"$f":"B80*D80","v":0},null,null,null,{"$f":"SUM(B80*H80)","v":0},null,null,"=",{"$f":"B80*L80","v":0}]
["Meals / Day:",null,"X",null,"=",{"$f":"B81*D81","v":0},null,null,null,{"$f":"SUM(B81*H81)","v":0},null,null,"=",{"$f":"B81*L81","v":0}]
["Lodging / Day:",null,"X",null,"=",{"$f":"B82*D82","v":0},null,null,null,{"$f":"SUM(B82*H82)","v":0},null,null,"=",0]
["Printing / Shipping:"]
["Other (Specify):"]
["Other (Specify):"]
[]
["Total Reimbursable Expenses",null,null,null,null,{"$f":"SUM(F80:F85)","v":0},null,null,null,{"$f":"SUM(J80:J85)","v":0},null,null,null,{"$f":"SUM(N80:N85)","v":0}]
[]
["III. INDIRECT / OVERHEAD EXPENSES"]
["Indirect/Overhead Rate (not to exceed 145%):",null,null,0,null,{"$f":"F76*D90","v":0},null,0,null,{"$f":"J76*H90","v":0},null,0,null,{"$f":"N76*L90","v":0}]
[]
[null,null,null,null,null,null,null,"TOTAL ENGINEERING COST:",null,null,null,"TOTAL INSPECTION COST:"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"(F76+F87+F90+J76+J87+J90)","v":0},null,"Private:",null,{"$f":"(N76+N87+N90)*'4.1 Relocation Estimate '!C15","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Public:",null,{"$f":"(N76+N87+N90)*'4.1 Relocation Estimate '!C16","v":0}]
[]
[]
[]
["Revision 07-03-2015",null,null,null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1.1"]

{"sheet":"2.1 Labor and Materials","index":2,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[64,11,64,12],[62,11,62,12],[0,0,0,13],[40,0,40,9],[42,12,43,13],[3,12,4,12],[3,13,4,13],[2,12,2,13],[40,12,40,13],[2,3,2,6],[3,3,3,4],[3,5,3,6],[2,8,2,10],[3,8,4,8],[43,3,43,4],[42,3,42,6],[3,9,4,9],[3,10,4,10],[42,8,42,9],[43,8,44,8],[43,5,43,6],[43,9,44,9]]}
["INSTALLATION LABOR AND MATERIALS; BETTERMENT; MATERIALS PROVIDED TO THE STATE"]
[]
[null,"EQUIPMENT COST INCLUDED WITH INSTALLATION COST",null,"LABOR",null,null,null,null,"MATERIAL",null,null,null,"BETTERMENT"]
[null,null,null,"In House \nCost",null,"Contract (Bid/Continuing)",null,null,"Unit Cost","Provided to State","Install\nExtended ",null,"Labor","Material"]
["TDOT Item No.","Item Description","Qty","Unit Cost","Extended","Unit Cost","Extended"]
[null,null,null,null,{"$f":"SUM(C6*D6)","v":0},null,{"$f":"SUM(C6*F6)","v":0},null,null,null,{"$f":"I6*C6","v":0}]
[null,null,null,null,{"$f":"SUM(C7*D7)","v":0},null,{"$f":"SUM(C7*F7)","v":0},null,null,null,{"$f":"I7*C7","v":0}]
[null,null,null,null,0,null,0,null,null,null,{"$f":"I8*C8","v":0}]
[null,null,null,null,0,null,0,null,null,null,{"$f":"I9*C9","v":0}]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,{"$f":"I26*C26","v":0}]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,{"$f":"SUM(C31*F31)","v":0},null,null,null,0]
[null,null,null,null,{"$f":"SUM(C32*D32)","v":0},null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
[null,null,null,null,0,null,0,null,null,null,0]
["TOTAL INSTALLATION COSTS",null,null,null,{"$f":"SUM(E6:E37)","v":0},null,{"$f":"SUM(G6:G37)","v":0},null,null,{"$f":"SUM(J6:J37)","v":0},{"$f":"SUM(K6:K37)","v":0},null,{"$f":"SUM(M6:M37)","v":0},{"$f":"SUM(N6:N37)","v":0}]
[null,null,null,null,"(To Page 4.1; F44)",null,"(To Page 4.1; F44)",null,null,"( To Page 4.1; F48)","(To Page 4.1; F45)",null,"(To Page 4.1; F56)","( To Page 4.1; F57)"]
[]
["REMOVAL LABOR; SALVAGE AND NON-USABLE (JUNKED) MATERIALS",null,null,null,null,null,null,null,null,null,null,null,"SITE COSTS"]
[]
[null,null,null,"LABOR",null,null,null,null,"MATERIAL",null,null,null,"(Move Prior Only)"]
[null,null,null,"In House \nCost",null,"Contract (Bid/Continuing)",null,null,"Salvage / Reused","Junked / Scrapped"]
["TDOT Item No.","Item Description","Qty","Unit Cost","Extended","Unit Cost","Extended",null,null,null,null,null,"Clearing & Grubbing:  "]
[null,null,null,null,{"$f":"SUM(C46*D46)","v":0},null,{"$f":"SUM(C46*F46)","v":0},null,null,null,null,null,"Traffic Control:  "]
[null,null,null,null,{"$f":"SUM(C47*D47)","v":0},null,{"$f":"SUM(C47*F47)","v":0},null,null,null,null,null,"Erosion Control:  "]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0,null,null,null,null,null,"TOTAL SITE COST  ",{"$f":"SUM(N45:N48)","v":0}]
[null,null,null,null,0,null,0,null,null,null,null,null,null,"(To Page 4.1; F47)"]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
["TOTAL REMOVAL COSTS",null,null,null,{"$f":"SUM(E46:E64)","v":0},null,{"$f":"SUM(G46:G64)","v":0},null,{"$f":"SUM(I46:I64)","v":0},{"$f":"SUM(J46:J64)","v":0}]
[null,null,null,null,"(To Page 4.1; F46)",null,"(To Page 4.1; F46)",null,"(To Page 4.1; F49)","(To Page 4.1; F50)"]
["Revision 10-25-2013",null,null,null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 2.1"]

{"sheet":"3.1 Easements & Inspection","index":3,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[[42,1,42,8],[40,1,40,8],[18,0,18,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[12,0,12,1],[13,0,13,1],[34,0,34,1],[23,0,23,1],[21,0,21,1],[25,0,25,1],[33,0,33,1],[24,0,24,1],[22,0,22,1],[0,0,0,8],[29,0,29,3],[31,2,31,3],[31,0,32,1],[31,6,32,6],[26,4,26,6],[2,0,2,1],[3,0,3,1],[19,0,19,1],[20,0,20,1],[31,7,31,8],[29,6,29,8],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1]]}
["Replacement Easement Acquisition Expenses"]
[]
["SHEET NUMBER",null,"EXISTING EASEMENT (SF)","PROPOSED EASEMENT (SF)","SURVEY & ENGINEERING COST","ATTORNEYS FEES","RECORDING & OFFICE COST","EASEMENT COST","SHEET SUBTOTAL COST"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(E4:H4)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,{"$f":"SUM(E21:H21)","v":0}]
[null,null,null,null,0,0,0,0,{"$f":"SUM(E22:H22)","v":0}]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,{"$f":"SUM(E24:H24)","v":0}]
[null,null,null,null,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0]
["Total Easement Acquisition Expenses",null,null,null,"Attached Additional Sheets: Y / N",null,null,"TOTAL",{"$f":"SUM(I4:I26)","v":0}]
[null,null,null,null,null,null,null,null,"(To Page 4.1; F61)",null,"X"]
[]
["INSPECTION COSTS (PUBLIC)",null,null,null,null,null,"INSPECTION COSTS (PRIVATE)"]
[]
["IN-HOUSE",null,"CONSULTANT",null,null,null,"IN-HOUSE","CONSULTANT"]
[null,null,"STANDARD","CONTINUING",null,null,null,"STANDARD","CONTINUING"]
[{"$f":"'1.1 Engineering'!N96","v":0},null,{"$f":"'1.1 Engineering'!J54","v":0},{"$f":"'1.1 Engineering'!N54","v":0},null,null,{"$f":"'1.1 Engineering'!N94","v":0},{"$f":"'1.1 Engineering'!J52","v":0},{"$f":"'1.1 Engineering'!N52","v":0}]
[]
[]
[null,null,null,{"$f":"SUM(A34:D35)","v":0},null,null,null,null,{"$f":"SUM(G34:I35)","v":0}]
[]
[]
[]
["X"," YES - the utility will seek reimbursement of eligible inspection expenses (PRIVATE) incurred in accordance with  TCA 54-5-804 (a)(3)"]
[]
[null," NO - the utility will not seek reimbursement of eligible inspection expenses (PRIVATE) incurred in accordance with  TCA 54-5-804 (a)(3)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revision 10-25-2013",null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,"Sheet 3.1"]

{"sheet":"4.1 Relocation Estimate ","index":4,"n_rows":143,"n_cols":21,"rows_kept":143,"cut":false,"hidden":false,"merged":[[9,6,9,8],[94,2,94,3],[94,5,94,6],[94,9,94,10],[72,3,72,12],[39,1,39,4],[42,1,42,2],[53,1,53,5],[51,1,51,4],[42,8,42,11],[43,8,43,11],[36,8,36,11],[38,8,38,11],[40,8,40,11],[41,1,41,5],[32,8,32,12],[0,9,0,12],[1,9,1,12],[2,9,2,12],[33,1,33,2],[7,2,7,4],[9,2,9,4],[12,2,12,5],[8,2,8,8],[20,1,20,10],[6,10,7,12],[17,1,17,5],[18,1,18,12],[7,6,7,8],[23,8,23,11],[23,2,23,4],[32,1,32,5],[128,2,128,7],[130,2,130,7],[10,2,10,8],[11,2,11,8],[6,2,6,8],[120,2,120,7],[122,2,122,7],[124,2,124,7],[126,2,126,7],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[110,2,110,12],[114,11,114,12],[114,2,114,7],[116,2,116,7],[118,2,118,7],[0,2,0,7],[1,2,1,7],[2,2,2,7],[96,1,96,12],[92,1,92,12],[81,2,81,5],[4,0,4,13],[35,1,35,2],[36,1,36,2],[37,1,37,2],[43,1,43,2],[90,1,90,12],[34,8,34,11],[61,1,61,5],[46,8,46,12],[55,1,55,2],[56,1,56,2],[54,1,54,2],[38,1,38,2],[83,2,83,5],[66,1,66,12],[75,1,75,12],[58,1,58,4],[60,1,60,4],[112,1,112,12],[25,15,25,22],[27,18,27,21],[27,16,27,17],[30,21,63,21],[30,15,63,15],[30,16,63,16],[30,17,63,17],[30,19,63,19],[30,20,63,20],[30,18,63,18],[88,1,88,12],[79,2,79,5],[79,9,79,11],[81,9,81,11],[83,9,83,11]]}
[null,null,null,null,null,null,null,null,"Project No:",{"$f":"T('Title Sheet'!C51)","v":""}]
[null,null,null,null,null,null,null,null,"County:",{"$f":"T('Title Sheet'!C53)","v":""}]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2024-04-12"}]
[]
["**Submittal and completion of this form is required for consideration of reimbursement on this project.**"]
[]
[null,"Primary Contact:",{"$f":"T('Title Sheet'!C27)","v":""},null,null,null,null,null,null,null,"TDOT USE ONLY"]
[null,"E-mail:",{"$f":"T('Title Sheet'!C29)","v":""},null,null,"Phone:",{"$f":"T('Title Sheet'!C25)","v":""}]
[null,"Secondary Contact:",null,null,null,null,null,null,null,null,"RG Approval and Date:"]
[null,"E-mail:",null,null,null,"Phone:"]
[null,"Utility Name:",{"$f":"T('Title Sheet'!C19)","v":""},null,null,null,null,null,null,null,"Consult Appr. Date:     /     /"]
[null,"Address:",{"$f":"T('Title Sheet'!C21)","v":""},null,null,null,null,null,null,null,"Amount Approved:",null,0]
[null,"City, State:",{"$f":"T('Title Sheet'!C23)","v":""},null,null,null,null,"Zip:",{"$f":"('Title Sheet'!E23)","v":0},null,"HQ Approval and Date:"]
[]
[null,"Percent On Private:",{"$f":"IF(I15=0,0,ROUND((I15/I17),2))","v":0},null,null,null,null,"Private ROW - #Poles / Length of facility:",null,null,"CH86  Y / N ","PIN#:"]
[null,"Percent On Public:",{"$f":"IF(I16=0,0,ROUND((I16/I17),2))","v":0},null,null,null,null,"Public ROW - #Poles / Length of facility:",null,null,"LET:     /     /     ","Contract #:"]
[null,"Total Percentage:",{"$f":"SUM(C15:C16)","v":0},null,null,null,null,"Total #Poles / Length of facility:",{"$f":"SUM(I15:I16)","v":0},null,"Easement Contract #"]
[null,"Is Utility Chapter 86 Certified (Obtained from Certification Sheet)?",null,null,null,null,{"$f":"IF(AND(E95=\"\",H95=\"\",L95=\"\"),\"N\",\"Y\")","v":"N"},null,null,null,null,null,null,null,"Rev 06-18-2008"]
[null,"(If project does not qualify for Chapter 86 Reimbursement, then \"Percent on Private\" will be used to calculate total amount due to Utility)"]
[]
[null,"NO COST / NO REIMBURSEMENT (STOP HERE, REMAINDER OF FORM IS NOT REQUIRED)",null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-30",0.75,0.5,0.25]
[]
[]
[null,null,"CHAPTER 86",null,null,null,null,null,"NON-CHAPTER 86"]
[]
[null,"REIMBURSEMENT",null,"MOVE PRIOR",null,null,null,null,null,null,"% Private / Public Relocation",null,null,null,"ADDED WORK","WORKSHEET AREA"]
[]
[null,"REQUESTED",null,"MOVE IN State Contract",null,null,null,null,null,null,"% Private / Public MOVE IN State Contract","X",null,null,"SHEET AREA",null,"CH86",null,"NOT CH86"]
[]
[null,"(Please check ONE)",null,"Move Again",null,null,null,null,null,null," Utility Replacement Easement Reimbursement",null,null,null,null,null," MOVE IN","MOVE PRIOR","MOVE IN","% PVT","MOVE PRIOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract Amount\n= A+B+C",{"$f":"F40+F52+F61","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C15","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"ENGINEERING",null,null,null,null,null,null,"UTILITY REIMBURSEMENT"]
[null,"Description",null,null,null,"Amount"]
[null,"Pre-Construction",null,null,null,{"$f":"IF('1.1 Engineering'!C14=\"x\",'1.1 Engineering'!F29+'1.1 Engineering'!F43+'1.1 Engineering'!F46,0)+('1.1 Engineering'!F76+'1.1 Engineering'!F90)+IF('1.1 Engineering'!G14=\"x\",'1.1 Engineering'!F29,0)","v":0},null,null,"CHAPTER 86 MOVE-IN CONTRACT:",null,null,null,{"$f":"IF(AND(E28=\"X\",G18=\"Y\"),(F40+F48-F38),(IF(AND(E28=\"X\",G18=\"N\"),((((F40+F48-F38)*C16)*0.75)+(F40*C15)),0)))","v":0}]
[null,"Construction",null,null,null,{"$f":"IF('1.1 Engineering'!C14=\"x\",'1.1 Engineering'!J29+'1.1 Engineering'!J43+'1.1 Engineering'!J46,0)+('1.1 Engineering'!J76+'1.1 Engineering'!J90)+IF('1.1 Engineering'!G14=\"x\",'1.1 Engineering'!J29,0)","v":0}]
[null,"Construction Inspection",null,"Private",null,{"$f":"IF('3.1 Easements & Inspection'!A41=\"x\",'3.1 Easements & Inspection'!I37,0)","v":0},null,null,"CHAPTER 86 MOVE PRIOR:",null,null,null,{"$f":"IF(AND(E26=\"X\",G18=\"Y\"),((((F40-F38)+F52)*C16)*Q21)+(((F40-F38)+F52)*C15),IF(AND(E26=\"X\",G18=\"N\"),((((F40-F38)+F52)*C16)*R21)+(((F40-F38)+F52)*C15),0))","v":0}]
[null,"Construction Inspection",null,"Public",null,{"$f":"IF('3.1 Easements & Inspection'!A41=\"x\",'3.1 Easements & Inspection'!D37,0)","v":0}]
[null,"Reimbursable Expenses",null,null,null,{"$f":"'1.1 Engineering'!F40+'1.1 Engineering'!J40+'1.1 Engineering'!F87+'1.1 Engineering'!J87","v":0},null,null,{"$f":"IF(E30=\"X\",IF(D30=\"Move-In Move Again\",\"MOVE-IN MOVE AGAIN:\",\"NON-CHAPTER 86 MOVE-IN CONTRACT:\"),\"NON-CHAPTER 86 MOVE-IN CONTRACT:\")","v":"NON-CHAPTER 86 MOVE-IN CONTRACT:"},null,null,null,{"$f":"IF(L28=\"X\",((F35+F36+F39)*C15)+F37,IF(E30=\"X\",IF(D30=\"Move-In Move Again\",(F40+F48),0),0))","v":0}]
[null,"ENGINEERING COST: ",null,null,null,{"$f":"ROUND(SUM(F35:F39),2)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E30=\"X\",IF(D30=\"Move Again\",\"MOVE AGAIN CONTRACT:\",\"NON-CHAPTER 86 % PUBLIC/PRIVATE:\"),\"NON-CHAPTER 86 % PUBLIC/PRIVATE:\")","v":"NON-CHAPTER 86 % PUBLIC/PRIVATE:"},null,null,null,{"$f":"IF(L26=\"X\",(F40+F52-F59)*C15,IF(E30=\"X\",IF(D30=\"Move Again\",(F40+F52-F59),0),0))","v":0}]
[null,"CONSTRUCTION (LABOR & MATERIAL)"]
[null,"Description",null,null,null,"Amount",null,null,"Does Estimate Exceed $1.75M Cap? - ",null,null,null,{"$f":"IF((F64*C16)>1750000,\"Y\",\"N\")","v":"N"}]
[null,"Installation Labor",null,null,null,{"$f":"'2.1 Labor and Materials'!E38+'2.1 Labor and Materials'!G38","v":0},null,null,"Does Estimate Require 75% Cap? - ",null,null,null,{"$f":"IF(AND(E95=\"\",H95=\"\",L95=\"\"),\"Y\",\"N\")","v":"Y"}]
[null,"Installation Materials",null,null,null,{"$f":"'2.1 Labor and Materials'!K38","v":0}]
[null,"Removal Labor",null,null,null,{"$f":"'2.1 Labor and Materials'!E65+'2.1 Labor and Materials'!G65","v":0}]
[null,"Site Costs",null,null,null,{"$f":"'2.1 Labor and Materials'!N49","v":0},null,null,"UTLITY DEPOSIT (IF APPLICABLE)"]
[null,"Material Provided to State",null,null,null,{"$f":"'2.1 Labor and Materials'!J38","v":0}]
[null,"Salvage Materials",null,null,null,{"$f":"'2.1 Labor and Materials'!I65","v":0},null,null,"RELOCATION EXCEEDS $1.75M CAP:",null,null,null,{"$f":"IF(AND(G18=\"Y\",E28=\"X\",(((F64-F59)*C16)>1750000)),(((F64-F59-F37-F38)*C16)-1750000),IF(AND(G18=\"N\",E28=\"X\",(((F64*C16)*0.75)>1750000)),((((F64-F59)*C16)*0.75)-1750000),0))","v":0}]
[null,"Non-Usable Materials",null,null,null,{"$f":"'2.1 Labor and Materials'!J65","v":0}]
[null,null,null,null,null,null,null,null,"AMOUNT OVER 75% REIMBURSEMENT:",null,null,null,{"$f":"IF(AND(G18=\"N\",E28=\"X\"),(0.25*C16*(F52-F48-F59)),0)","v":0}]
[null,"ESTIMATED CONSTRUCTION COST: ",null,null,null,{"$f":"ROUND(SUM(F44:F48)-SUM(F49:F50),2)","v":0}]
[null,null,null,null,null,null,null,null,"ESTIMATED UTILITY BETTERMENT COST:",null,null,null,{"$f":"IF(E28=\"X\",(F59),IF(L28=\"X\",(F59),IF(E30=\"X\",IF(D30=\"Move-In Move Again\",(F59),0),0)))","v":0}]
[null,"BETTERMENT"]
[null,"Description",null,null,null,"Amount",null,null,"NON-CHAPTER 86 MOVE-IN CONS'T COST:",null,null,null,{"$f":"IF(L28=\"X\",(((F52-F48-F59)*C16)),0)","v":0}]
[null,"Installation Labor",null,null,null,{"$f":"'2.1 Labor and Materials'!M38","v":0}]
[null,"Installation Materials",null,null,null,{"$f":"'2.1 Labor and Materials'!N38","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL UTILITY DEPOSIT:",null,null,null,{"$f":"M49+M51+M53+M55","v":0}]
[null,"ESTIMATED UTILITY BETTERMENT COST: ",null,null,null,{"$f":"ROUND(SUM(F56:F58),2)","v":0}]
[]
[null,"ESTIMATED REPLACEMENT EASEMENT COST:",null,null,null,{"$f":"'3.1 Easements & Inspection'!I27","v":0}]
[null,"If cost is listed above, separate Easement Contract is needed"]
[]
[null,"ESTIMATED TOTAL CONSTRUCTION COST:",null,null,null,{"$f":"F40+F52","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max reimb for certified util",null,{"$f":"MIN(1750000,#REF!)","v":{"$error":"#REF!"}}]
[null,"The Utility will reference the page number where designated on the form when other Detail Cost Estimate sheets are attached."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max reimb for non certified util",null,{"$f":"MIN(1750000,#REF!)","v":{"$error":"#REF!"}}]
["Revision 10-25-2013",null,null,null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4.1"]
[]
[null,null,null,"Chapter 86 Certification"]
[]
[]
[null,"In accordance with Tennessee Department of Transportation policy number 340-07, the following information is provided with regards to required compliance documentation for utility relocation reimbursement in accordance with TCA 54-5-804 and TCA 54-5-854."]
[]
[]
[]
[null,"PROJECT #/S:",{"$f":"T('Title Sheet'!C51)","v":""},null,null,null,null,null,"COUNTY/S:",{"$f":"T('Title Sheet'!C53)","v":""}]
[]
[]
[]
[null,"FEDERAL:",{"$f":"T('Title Sheet'!C49)","v":""},null,null,null,null,null,"PIN:"]
[]
[]
[null,"1. The utility is seeking reimbursement under provisions of TCA 54-5-804 as ameneded by Public Acts 2003, Chapter number 86."]
[]
[null,"2. To the best of my knowledge the utility is in compliance with TCA § 54-5-804(a)(1) and this policy in that the utility has returned its \n    relocation plan, schedule, and cost estimate to the Department within 120 days after receipt of the Department’s project plans, or \n    within such additional time as may be allowed in accordance with TCA § 54-5-854(b). "]
[]
[null,"3. To the best of my knowledge the utility is in compliance with TCA 54-5-804(b) in that the utility has a valid permit to locate its utility\n    facility on the public highway right-of-way."]
[]
[null,"4. The utility is eligible for reimbursement in accordance with the Limitation provisions of the TDOT Policy 340-07 in that it is:"]
[]
[null,null,"Municipally Owned",null,null,"Utility District",null,null,null,"Utility Cooperative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"5. The utility is considered to be a specific utility category listed in accordance with the Limitation provisions of the TDOT Policy 340-07:"]
[]
[null,"      Water"]
[]
[null,"      Waste Water"]
[]
[null,"      Gas",null,"Distribution",null,"Transmission"]
[]
[null,"      Electric",null,"Distribution",null,"Transmission"]
[]
[null,"      Communication",null,"CATV",null,"Phone",null,null,"Fiberoptic",null,"Broadband"]
[]
[null,"      Street Lighting"]
[]
[null,"      Other"]
[]
[null,"Signature indicates this individual has the legal authority to sign contracts and agreements to obligate the utility."]
[]
[null,"Signature:",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Print Name:"]
[]
[null,"Title:"]
[]
[null,"Utility Name:"]
[]
[null,"Utility Address:"]
[]
[null,"City, State, Zip:"]
[]
[null,"Phone Number:"]
[]
[null,"Fax Number:"]
[]
[null,"Email Address:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revision 10-25-2013",null,null,null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4.2"]

{"sheet":"5.1 Move Prior Obligation","index":5,"n_rows":144,"n_cols":13,"rows_kept":144,"cut":false,"hidden":false,"merged":[[108,1,109,12],[95,2,95,12],[92,11,92,12],[92,2,92,3],[96,1,97,12],[98,1,99,12],[100,1,101,12],[104,1,105,12],[92,5,92,10],[106,1,107,12],[32,2,32,7],[46,2,46,7],[66,4,66,7],[40,2,40,7],[7,2,7,5],[9,2,9,8],[11,2,11,8],[36,2,36,7],[44,2,44,7],[89,5,89,10],[88,2,88,3],[87,2,87,3],[38,2,38,7],[86,11,86,12],[86,5,86,10],[82,2,84,3],[85,2,85,3],[85,5,85,10],[82,11,84,12],[48,2,48,7],[1,4,1,12],[30,1,30,12],[51,2,52,11],[14,9,14,11],[4,2,4,3],[44,11,44,12],[42,2,42,7],[16,2,16,5],[18,2,18,5],[20,2,20,11],[22,3,22,5],[24,5,24,6],[16,9,16,11],[14,2,14,5],[18,9,18,11],[34,2,34,7],[110,1,111,12],[32,11,32,12],[91,5,91,10],[90,5,90,10],[82,5,84,10],[78,1,80,12],[85,11,85,12],[86,2,86,3],[87,11,87,12],[88,11,88,12],[90,11,90,12],[89,11,89,12],[82,1,84,1],[89,2,89,3],[87,5,87,10],[88,5,88,10],[112,1,113,12],[134,2,134,12],[102,1,103,12],[91,11,91,12],[90,2,90,3],[91,2,91,3],[131,2,131,12],[122,1,123,12],[124,1,125,12],[126,2,126,12],[127,2,127,12],[130,2,130,12],[114,1,115,12],[116,1,117,12],[118,1,119,12],[120,1,121,12],[139,2,139,12],[128,2,128,12],[129,2,129,12],[140,2,140,12],[135,2,135,12],[136,2,136,12],[137,2,137,12],[138,2,138,12],[132,2,132,12],[133,2,133,12]]}
[]
[null,null,null,null,"Certification Contract Obligation"]
[]
[]
[null,"Date:",null,null,null,null,null,null,null,"TDOT Region",null,"Construction Office"]
[null,null,null,null,null,null,null,null,null,null,"(Region)"]
[]
[null,"Attn:",null,null,null,null,",Project Engineer"]
[]
[null,"Address:"]
[]
[]
[null,null,"(information is provided on the Utility Begin Work Authorization letter)"]
[]
[null,"PROJECT #/S:",null,null,null,null,null,null,"COUNTY/S:"]
[]
[]
[]
[null,"FEDERAL:",null,null,null,null,null,null,"PIN:"]
[]
[null,"DESCRIPTION:"]
[]
[null,"UTILITY CONTRACT #:"]
[]
[null,null,null,null,"The Utility completed their utility relocation on",null,null,"(date of completion) in accordance with the approved relocation"]
[null,"plans for the above referenced project number prior to the date specified and in accordance with the executed contract referenced."]
[]
[null,"NOTE EXCEPTIONS:"]
[null,"Maintaining services to business and/or residences is attached."]
[]
[null,"Signature indicates this individual has the legal authority to sign contracts and agreements to obligate the utility."]
[]
[null,"Signed:",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Print Name:"]
[]
[null,"Title:"]
[]
[null,"Utility Name:",null,null,null,null,null,null,null,null,"Water",null,"Telephone"]
[]
[null,"Address:",null,null,null,null,null,null,null,null,"Sewer",null,"CATV"]
[]
[null,"City, State, Zip:",null,null,null,null,null,null,null,null,"Power",null,"Other:"]
[]
[null,"Phone No:",null,null,null,null,null,null,null,null,"Gas"]
[]
[null,"Fax No:"]
[]
[null,"Email:"]
[]
[]
[null,null,"TDOT USE ONLY:"]
[]
[]
[null,null,null,null,"This Certification Letter is accepted."]
[]
[null,null,null,null,"This Certification Letter is accepted pending Final Verification by"]
[null,null,null,null,"project staking."]
[]
[null,null,null,null,"This Certification is not accepted.  Reason:"]
[]
[]
[]
[]
[]
[null,null,null,"Signed:",null,null,null,null,null,"Date:"]
[null,null,null,null,"TDOT Construction office representative"]
[]
[null,null,"CC:","TDOT Construction Project File"]
[null,null,null,"TDOT Regional Utility Office"]
[]
[]
["Revision 07-03-2015",null,null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page 5.1"]
[]
[]
[]
[null,"CERTIFICATION EXCEPTIONS:"]
[null,"The following business and/or residences on proposed State right-of-way have not been vacated at the time of the relocation, and utility services are being maintained temporarily.  Upon written notice to the utility contact listed below, the utility will "]
[]
[]
[]
[null,"State Project Tract No.","Type of Occupied Property",null,"Type of Utility Service","Address",null,null,null,null,null,"Period of time utility obligates to remove facility (Calendar Days)"]
[null,null,null,null,"(water, sewer, gas,"]
[null,null,null,null,"electric, CATV)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Remarks:"]
[]
[]
[1]
[]
[2]
[]
[3]
[]
[4]
[]
[5]
[]
[6]
[]
[7]
[]
[8]
[]
[9]
[]
[10]
[]
[11]
[]
[12]
[]
[13]
[]
[14]
[]
[15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revision 07-03-2015",null,null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page 5.2"]

{"sheet":"6.1 Calendar Days","index":6,"n_rows":105,"n_cols":12,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,2,1,11],[34,0,34,11],[35,0,35,11],[36,0,36,11],[30,0,30,11],[31,0,31,11],[32,0,32,11],[33,0,33,11],[9,1,9,11],[4,1,4,4],[5,1,5,11],[6,1,6,4],[4,9,4,11],[8,1,8,11],[10,1,10,7],[10,9,10,11],[11,1,11,5],[11,9,11,11],[19,0,19,11],[27,3,27,6],[24,7,24,11],[25,7,25,11],[26,7,26,11],[11,7,11,8],[20,0,20,11],[21,0,21,11],[44,0,44,11],[52,0,77,11],[80,0,88,11],[50,0,50,11],[17,5,17,11],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[24,3,24,6],[27,7,27,11],[23,0,23,2],[23,7,23,11],[23,3,23,6],[25,3,25,6],[26,3,26,6]]}
[]
[null,null,"Declaration of Scheduled Calendar Days"]
[]
[]
["Project Number:",{"$f":"T('Title Sheet'!C51)","v":""},null,null,null,null,null,null,"Date:"]
["Description:",{"$f":"T('Title Sheet'!C47)","v":""}]
["County:",{"$f":"T('Title Sheet'!C53)","v":""}]
[]
["Utility Name:",{"$f":"T('Title Sheet'!C19)","v":""}]
["Address:",{"$f":"T('Title Sheet'!C21)","v":""}]
["City, State:",{"$f":"T('Title Sheet'!C23)","v":""},null,null,null,null,null,null,"Zip Code:",{"$f":"'Title Sheet'!E23","v":0}]
["Phone Number:",{"$f":"T('Title Sheet'!C25)","v":""},null,null,null,null,null,"Fax Number:"]
[]
["Type of Facilities:",null,"Water",null,"Sewer",null,"Gas",null,"Telephone",null,"Electric"]
[]
[null,null,"CATV",null,"Fiberoptic",null,"Other"]
[]
["Required Period services cannot be interrupted:"]
[]
["All estimated days should be expresses in \"Calendar\" days to complete installation, relocation or"]
["adjustment of the utility facilities on the above referenced project. The utility can as an option submit an "]
["\"On or Before\" date all work will be completed. In accordance with provisions set forth in TCA 54-5-854."]
[]
["Task",null,null,"Days to Complete",null,null,null,"Special Conditions"]
["Stock Pile Material (Including ordering material)"]
["Mobilize Work Force (including Bidding process if Required)"]
["Complete Relocation"]
["Total Days To Complete",null,null,{"$f":"SUM(D25:G27)","v":0}]
[]
["Special Conditions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Signature of submitting",null,null,null,"Date",null,"Signature of submitting",null,null,null,null,"Date"]
["Utility Representative",null,null,null,null,null,"State Representative"]
[]
["Subject to provisions of the TDOT Utility Office Maintenance of Traffic Procedures."]
[]
[]
["Revisioin 07-03-2015",null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,"Page 6.1"]
[]
["TDOT Utility Office Maintenance of Traffic Procedures."]
[]
["Except in emergencies, no lane closures will be permitted on any state routes with 30,000 or greater Average Daily\ntraffic or any interstate routes, without the explicit consent of the TDOT Project Engineer. On projects where work \nis required in traffic lane(s) or where a lane closure is necessary for public safety, the Utility must submit a request \nto the Department at least seven (7) working days prior to the date of the anticipated lane closure(s).  All requests \nfor lane closure(s) must list the exact location, the time that the closure will begin, the estimated duration and \nreasons for the proposed lane closure(s).\nIf all lanes in one or both directions on an interstate route are to be closed for any length of time, the Utility \nmust submit their request at least fourteen (14) calendar days before the anticipated event. \nNo lane closures or traffic restrictions will be allowed on the following days \n\nGood Friday\n\nEaster\nAfter 6:00 pm on the Thursday preceding Good Friday through and including Easter Sunday\nMemorial Day\nAfter 12:00 noon on the preceding Friday through Memorial Day\nJuly 4\nThe observed holiday and preceding day plus weekend days either preceding or following these two days\nLabor Day\nAfter 12:00 noon on the preceding Friday through Labor Day\nThanksgiving\nAfter 12:00 noon on Wednesday before Thanksgiving through Sunday following Thanksgiving \nChristmas/New year’s Day\nDecember 24 through January 1 and any preceding and/or following days that fall on a weekend\n\nOffroad work will be allowed but only to the extent that NO impact will be caused to the highway users. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["During any suspension of work, the Utility shall make passable and shall open to traffic such portions of the \nproject and temporary roadways or portions thereof as may be directed by the TDOT Project Engineer for the \ntemporary accommodation of necessary traffic during the anticipated period of suspension. Thereafter, and \nuntil issuance of an order for the resumption of construction operations, the maintenance of the temporary \nroute or line of travel will be by the Utility. When work is resumed, the Utility will replace or renew any work \nor materials lost or damaged because of such temporary use of the project; shall remove, to the extent \ndirected by the TDOT Project Engineer, any work or materials used in the temporary maintenance, and shall \ncomplete the project in every respect as though its prosecution had been continuous."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revision 07-03-2015",null,null,null,null,null,null,null,null,null,null,"TDOT Utility Form 2013-16"]
[null,null,null,null,null,null,null,null,null,null,null,"Page 6.2"]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}