{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Notes and Instructions","Cover Page","Contacts List","Utility Inventory","Utility Data Origins","Conflict Matrix","Cost Estimate","Additional Comments"],"not_rendered":{"macros":1,"external_links":1,"defined_names":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Notes and Instructions","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"merged":[[0,0,0,10],[2,1,2,10],[3,0,5,0],[3,1,5,10],[6,1,6,10],[7,0,10,0],[7,1,7,10],[8,2,8,10],[9,2,9,10],[10,2,10,10],[11,1,11,10],[12,1,12,10],[13,1,13,10],[14,2,14,10],[15,2,16,10],[17,2,18,10],[19,2,20,10],[21,2,21,10],[23,0,23,10],[25,1,25,10],[26,1,26,10],[27,0,29,0],[27,1,29,10],[30,1,30,10],[31,1,31,10],[32,1,32,10]],"flags":["formulas_cached_only"]}
["Tips for the Use of Template"]
[]
["1.A)","Items marked in BOLD, BLACK TEXT will stay as written for all Utility Report submittals"]
["1.B)","Items marked in UNDERLINED, BLACK TEXT will update automatically as other portions of the report are updated by the user.  ENSURE THAT THESE PORTIONS ARE ACCURATE UPON UTILITY REPORT SUBMITTAL."]
[]
[]
["1.C)","Items marked in RED TEXT will require update by the user as the project develops"]
["1.D)","To add an entry:"]
[null,"a)","Select a Row containing a blank entry"]
[null,"b)","Copy that row"]
[null,"c)","Insert the Row copy after the selected Row"]
["1.E)","To remove an entry, delete the entire Row containing that entry"]
["1.F)","To Print the entire workbook, go to the Print menu. Under \"Print What,\" select \"Entire Workbook\""]
["1.G)","Macros have been added to this template to simplify its use."]
[null,"a)","To add a row in the Utility Inventory, press Ctrl+Shift+A from any sheet."]
[null,"b)","To add a row in the Utility Data Origins, press Ctrl+Shift+B from any sheet.  This row will not be linked to take any information from any other sheet in this workbook."]
[]
[null,"c)","To add a row in the Conflict Matrix, press Ctrl+Shift+C from any sheet.  This row will not be linked to take any information from any other sheet in this workbook."]
[]
[null,"d)","To add a new row in the Utilty Inventory, Utility Data Origins and Conflict Matrix sheets, and link all three rows together, go to any sheet and press Ctrl+Shift+D."]
[]
[null,"e)","To add a new company to the Cost Estimate, go to the Cost Estimate sheet and press Ctrl+Shift+E."]
[]
["General Notes and Instructions"]
[]
["2.A)","For more information regarding what should be included in this report, refer to the Utility Report Guidelines, Stage Submittal Checklist, Utility Coordination Guide, and Dictionary of Standardized Work Tasks  (available through the ADOT website at <http://www.azdot.gov/Highways/Utilities/index.asp> )."]
["2.B)","If information is unavailable for any entry at any given Stage, leave that entry blank"]
["2.C)","As noted in the Utility Report Guidelines, attach the following as appendices to the end of this report:  Comments & Correspondence, Meeting Minutes, Pothole Request & Completed Pothole Data and Utility Removal and Relocation Plan Sheets"]
[]
[]
["2.D)","Enter information under \"Additional Comments\" on the \"Utility Data Origins & Comments\" sheet to add any necessary details for a given entry. Enter \"See Additional Comment No. #\" in the pertinent entry. "]
["2.E)","Anywhere that a * symbol is present, there will be a note specific to that item at the bottom of that sheet."]
{"$rows_empty":16}
[{"$nulls":9},"ADOT U&RR","2012-11-16"]

{"sheet":"Cover Page","index":1,"n_rows":43,"n_cols":18,"rows_kept":43,"merged":[[0,0,0,30],[1,0,1,10],[1,11,1,12],[1,13,1,30],[2,0,2,30],[3,0,3,30],[4,0,4,30],[5,0,5,30],[6,0,6,30],[7,0,7,30],[8,0,8,30],[9,0,9,30],[10,8,10,15],[10,16,10,24],[11,0,11,30],[12,0,12,30],[14,2,34,28],[35,2,35,28],[37,2,37,14],[37,17,37,30],[39,2,39,14],[39,17,39,30],[40,2,40,14],[40,17,40,30],[41,2,41,14],[41,17,41,30],[42,2,42,14],[42,17,42,30]],"flags":["formulas_cached_only"]}
[]
["SR 000",{"$nulls":10}," - ",null,"Freeway Name"]
[" MP 00.00 to MP 00.00"]
[]
["UTILITY REPORT"]
[]
["STAGE _ (000%) Plans"]
[]
["TRACS No. 0000 XX 000 X0000 00X"]
[]
[{"$nulls":8},"Federal Aid Project No. ",{"$nulls":7},"XX-XXX-0(000)X"]
[]
["Date"]
[]
[null,null,"Project Vicinity Map, including Project Limits, Township and Range, North Arrow, TRACS No., and Project Name all per ADOT Drafting Guideline"]
{"$rows_empty":20}
[null,null,"Project Vicinity Map"]
[]
[null,null,"Submitted To:",{"$nulls":14},"Prepared By:"]
[]
[null,null,"Arizona Department of Transportation",{"$nulls":14},"Consultant Firm Name or \"In-House\""]
[null,null,"Utility and Railroad Engineering",{"$nulls":14},"Street Address (Omit if In-House)"]
[null,null,"205 S. 17th Ave. MD 618E",{"$nulls":14},"City, State Zip Code (Omit if In-House)"]
[null,null,"Phoenix, AZ  85007",{"$nulls":14},"Designer Name"]

{"sheet":"Contacts List","index":2,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,1],[3,4,3,6],[4,0,4,6],[5,2,5,5],[6,0,9,0],[6,2,6,3],[6,4,6,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[9,2,9,5],[10,0,13,0],[10,2,10,3],[10,4,10,5],[11,2,11,3],[11,4,11,5],[12,2,12,3],[12,4,12,5],[13,2,13,5],[14,0,17,0],[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[17,2,17,5],[18,0,21,0],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,4,20,5],[21,2,21,5],[22,0,25,0],[22,2,22,3],[22,4,22,5],[23,2,23,3],[23,4,23,5],[24,2,24,3],[24,4,24,5],[25,2,25,5],[26,0,29,0],[26,2,26,3],[26,4,26,5],[27,2,27,3],[27,4,27,5],[28,2,28,3],[28,4,28,5],[29,2,29,5],[30,0,33,0],[30,2,30,3],[30,4,30,5],[31,2,31,3],[31,4,31,5],[32,2,32,3],[32,4,32,5],[33,2,33,5],[34,0,37,0],[34,2,34,3],[34,4,34,5],[35,2,35,3],[35,4,35,5],[36,2,36,3],[36,4,36,5],[37,2,37,5],[38,0,41,0],[38,2,38,3],[38,4,38,5],[39,2,39,3],[39,4,39,5],[40,2,40,3],[40,4,40,5],[41,2,41,5],[42,0,45,0],[42,2,42,3],[42,4,42,5],[43,2,43,3],[43,4,43,5],[44,2,44,3],[44,4,44,5],[45,2,45,5],[46,0,49,0],[46,2,46,3],[46,4,46,5],[47,2,47,3],[47,4,47,5],[48,2,48,3],[48,4,48,5],[49,2,49,5]],"flags":["formulas_cached_only"]}
["EXHIBIT A"]
["Utility and Agency Contact List"]
["TRACS No. 0000 XX 000 X0000 00X"]
["Project Name: ",null,"SR 000"," / "," MP 00.00 to MP 00.00"]
[]
["ORGANIZATION","CONTACT ","CONTACT INFORMATION",{"$nulls":3},"MAILING ADDRESS"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"See additional comments"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]
["ORGANIZATION NAME","Contact Name","(602) 712-0000 ",null,"Primary",null,"Street Name, Room/Suite, Mail Drop"]
[null,null,"(602) 712-1111",null,"Fax",null,"City"]
[null,null,"(602) 712-2222",null,"Cell",null,"State"]
[null,null,"smithb@azdot.gov",{"$nulls":3},"Zip Code"]

{"sheet":"Utility Inventory","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,5],[3,6,3,7],[3,9,3,12],[4,0,4,12],[5,4,5,5],[5,6,5,7],[5,8,5,9],[6,4,6,5],[6,6,6,7],[6,8,6,9],[7,4,7,5],[7,6,7,7],[7,8,7,9],[8,4,8,5],[8,6,8,7],[8,8,8,9],[9,4,9,5],[9,6,9,7],[9,8,9,9],[10,4,10,5],[10,6,10,7],[10,8,10,9],[11,0,11,12],[12,0,14,12]],"flags":["formulas_cached_only"]}
["EXHIBIT B"]
["Existing Utilities Inventory"]
["TRACS No. 0000 XX 000 X0000 00X"]
["Project Name: ",{"$nulls":5},"SR 000",null," / "," MP 00.00 to MP 00.00"]
[]
["PLAN SHEET NO.","FACILITY TYPE / SIZE","FACILITY OWNER","OBSERVED ROADWAY/ PROJECT STATION","REASON FOR CONFLICT",null,"*M / R",null,"NEED ROW (Y/N)",null,"PRIOR RIGHTS (Y/N)","BETTERMENTS REQUESTED TO BE INCLUDED IN STATE PROJECT","**REMARKS / FINAL DISPOSITION "]
["U-00.02","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","Description OR \"No Conflict\"",null,"M or R",null,"Y, N or leave blank",null,"Y, N or leave blank","Y, N or leave blank","Currently in Mitigation"]
["U-00.02","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","Description OR \"No Conflict\"",null,"M or R",null,"Y, N or leave blank",null,"Y, N or leave blank","Y, N or leave blank","Protect in Place"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","Description OR \"No Conflict\"",null,"M or R",null,"Y, N or leave blank",null,"Y, N or leave blank","Y, N or leave blank","ADOT Contractor to Relocate"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","Description OR \"No Conflict\"",null,"M or R",null,"Y, N or leave blank",null,"Y, N or leave blank","Y, N or leave blank","Utility to Relocate"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","Description OR \"No Conflict\"",null,"M or R",null,"Y, N or leave blank",null,"Y, N or leave blank","Y, N or leave blank","Currently in Mitigation"]
["*M/R indicates Mitigation/Relocation"]
["** Under REMARKS / FINAL DISPOSITION, include comments regarding facilities that are to be Protected in Place, who does design and/or relocation work, who pays for design and/or relocation work, if work must be done during the Construction Phase, and any other comments that may clarify details about the corresponding conflict."]

{"sheet":"Utility Data Origins","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[0,0,1,9],[2,0,2,1],[2,2,2,9],[3,0,3,1],[3,3,3,4],[3,5,3,7],[4,0,4,1],[4,3,4,4],[4,5,4,7],[5,0,5,1],[5,3,5,4],[5,5,5,7],[6,0,6,1],[6,3,6,4],[6,5,6,7],[7,0,7,1],[7,3,7,4],[7,5,7,7],[8,0,8,1],[8,2,8,9],[9,0,9,1],[9,2,9,9],[10,0,10,1],[10,2,10,9],[11,0,12,7],[11,8,12,9]],"flags":["formulas_cached_only"]}
["Utility Data Origins"]
[]
["Utility Data Search conducted at Stage:",null,"II, III or IV"]
["Contact Development Reference:",null,"Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt",null,"Most accurate source(s) of information documenting location of facilities",null,null,"SUE QUALITY LEVEL","A, B, C, D or PH"]
["Contact Development Reference:",null,"Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt",null,"Most accurate source(s) of information documenting location of facilities",null,null,"SUE QUALITY LEVEL","A, B, C, D or PH"]
["Contact Development Reference:",null,"Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt",null,"Most accurate source(s) of information documenting location of facilities",null,null,"SUE QUALITY LEVEL","A, B, C, D or PH"]
["Contact Development Reference:",null,"Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt",null,"Most accurate source(s) of information documenting location of facilities",null,null,"SUE QUALITY LEVEL","A, B, C, D or PH"]
["Contact Development Reference:",null,"Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt",null,"Most accurate source(s) of information documenting location of facilities",null,null,"SUE QUALITY LEVEL","A, B, C, D or PH"]
["Vertical Location Performed",null,"Yes or No"]
["Locating Agency",null,"Consultant Firm Name or \"In-House\""]
["Date of Location",null,"Date"]
["Designation performed in accordance with CI/ASCE Standard 38-02 publication \"Standard Guideline for the Collection and Depiction of Existing Subsurface Utility Data?\"",{"$nulls":7},"Yes or No"]

{"sheet":"Conflict Matrix","index":5,"n_rows":13,"n_cols":14,"rows_kept":13,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,5],[3,6,3,7],[3,9,3,13],[4,0,4,13],[5,5,5,6],[5,7,5,9],[6,5,6,6],[6,7,6,9],[7,5,7,6],[7,7,7,9],[8,5,8,6],[8,7,8,9],[9,5,9,6],[9,7,9,9],[10,5,10,6],[10,7,10,9],[11,0,11,13],[12,0,14,13]],"flags":["formulas_cached_only"]}
["EXHIBIT C"]
["Utility Conflict Matrix"]
["TRACS No. 0000 XX 000 X0000 00X"]
["Project Name: ",{"$nulls":5},"SR 000",null," / "," MP 00.00 to MP 00.00"]
[]
["CONFLICT PLAN SHEET NO.","FACILITY TYPE / SIZE","FACILITY OWNER","OBSERVED ROADWAY/ PROJECT STATION RANGE","*SUE QUALITY LEVEL","OBSERVED ROADWAY/ CONFLICT STATION RANGE",null,"OBSERVED ROADWAY/ PRIOR RIGHTS STATION RANGE",null,null,"REASON FOR CONFLICT","PROTECT IN PLACE OR RELOCATE        ","RELOCATION PLANS APPROVED BY ADOT?","**REMARKS / FINAL DISPOSITION "]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","A, B, C, D or PH","SR 000 / 00+00 to 00+00 Rt/Lt",null,"SR 000 / 00+00 to 00+00 Rt/Lt",null,null,"Description OR \"No Conflict\"","Relocate OR Protect in Place","Y, N or leave blank","Currently in Mitigation"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","A, B, C, D or PH","SR 000 / 00+00 to 00+00 Rt/Lt",null,"SR 000 / 00+00 to 00+00 Rt/Lt",null,null,"Description OR \"No Conflict\"","Relocate OR Protect in Place","Y, N or leave blank","Protect in Place"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","A, B, C, D or PH","SR 000 / 00+00 to 00+00 Rt/Lt",null,"SR 000 / 00+00 to 00+00 Rt/Lt",null,null,"Description OR \"No Conflict\"","Relocate OR Protect in Place","Y, N or leave blank","ADOT Contractor to Relocate"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","A, B, C, D or PH","SR 000 / 00+00 to 00+00 Rt/Lt",null,"SR 000 / 00+00 to 00+00 Rt/Lt",null,null,"Description OR \"No Conflict\"","Relocate OR Protect in Place","Y, N or leave blank","Utility to Relocate"]
["U-00.00","Type, Size Specifications","Company / Agency","SR 000 / 00+00 to 00+00 Rt/Lt","A, B, C, D or PH","SR 000 / 00+00 to 00+00 Rt/Lt",null,"SR 000 / 00+00 to 00+00 Rt/Lt",null,null,"Description OR \"No Conflict\"","Relocate OR Protect in Place","Y, N or leave blank","Currently in Mitigation"]
["* If Potholing is required, mark the entry with \"PH.\"  For example, a facility designated at SUE Quality Level \"D\" that requires potholing will be marked \"D - PH\""]
["** Under REMARKS / FINAL DISPOSITION, include comments regarding facilities that are to be Protected in Place, who does design and/or relocation work, who pays for design and/or relocation work, if work must be done during the Construction Phase, and any other comments that may clarify details about the corresponding conflict."]

{"sheet":"Cost Estimate","index":6,"n_rows":32,"n_cols":13,"rows_kept":32,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,2],[3,5,3,9],[4,0,4,12],[5,0,7,0],[5,1,7,1],[5,2,7,5],[5,6,5,7],[5,8,5,12],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,10],[6,11,7,12],[8,2,8,5],[8,9,8,10],[9,0,9,1],[9,2,9,5],[9,9,9,10],[9,11,9,12],[10,2,10,5],[10,9,10,10],[10,11,10,12],[11,2,11,5],[11,9,11,10],[11,11,11,12],[12,2,12,5],[12,9,12,10],[12,11,12,12],[13,2,13,5],[13,9,13,10],[13,11,13,12],[14,2,14,5],[14,9,14,10],[14,11,14,12],[16,0,16,1],[16,2,16,5],[16,9,16,10],[16,11,16,12],[17,2,17,5],[17,9,17,10],[17,11,17,12],[18,2,18,5],[18,9,18,10],[18,11,18,12],[19,2,19,5],[19,9,19,10],[19,11,19,12],[20,2,20,5],[20,9,20,10],[20,11,20,12],[21,2,21,5],[21,9,21,10],[21,11,21,12],[23,0,23,8],[23,9,23,10],[23,11,23,12],[24,0,24,8],[24,9,24,10],[24,11,24,12],[25,0,25,4],[25,5,26,8],[25,9,26,10],[25,11,26,12],[27,0,27,4],[27,5,27,8],[27,9,28,10],[27,11,28,12],[28,0,28,4],[28,5,28,8],[29,0,30,8],[29,9,30,10],[29,11,30,12],[31,0,31,8],[31,9,31,12]],"flags":["formulas_cached_only"]}
["EXHIBIT D"]
["Cost Estimate"]
["TRACS No. 0000 XX 000 X0000 00X"]
["Project Name: ",null,null,"SR 000"," / "," MP 00.00 to MP 00.00"]
[]
["Agreement No.","Bid Item No.","Description",{"$nulls":5},"Construction Cost"]
[{"$nulls":6},"Unit","Estimated Quantity","Unit Price","ADOT Estimated Cost (Payable)",null,"ADOT Estimated Cost (Receivable)"]
[]
[null,null,"MAINLINE"]
["0000-00-XXXX",null,"New Company"]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"LF",null,null,0,null,0]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"EA",null,null,0,null,0]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"LF",null,null,0,null,0]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"EA",null,null,0,null,0]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"LF",null,null,0,null,0]
[{"$nulls":10},0,null,0]
["0000-00-XXXX",null,"New Company"]
["Payable","#","Bid Item Description",{"$nulls":3},"LF",15,{"v":10,"d":"$10.00"},{"v":150,"d":"$150.00"},null,0]
["Receivable","#","Bid Item Description",{"$nulls":3},"EA",11,{"v":10,"d":"$10.00"},0,null,{"v":110,"d":"$110.00"}]
[null,"#","Bid Item Description",{"$nulls":3},"LF",10,{"v":10,"d":"$10.00"},{"v":100,"d":"$100.00"},null,{"v":100,"d":"$100.00"}]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"EA",null,null,0,null,0]
["Payable or Recievable?","#","Bid Item Description",{"$nulls":3},"LF",null,null,0,null,0]
[{"$nulls":10},{"v":250,"d":"$250.00"},null,{"v":210,"d":"$210.00"}]
["COST SUMMARY",{"$nulls":8},"Payable",null,"Receivable"]
["Construction Cost Total:",{"$nulls":8},{"v":250,"d":"$250.00"},null,{"v":210,"d":"$210.00"}]
[{"v":0.1,"d":"10%"},{"$nulls":4},"Contingency (Payable ONLY):",{"$nulls":3},{"v":25,"d":"$25.00"},null,"NA"]
[]
[{"v":0.15,"d":"15%"},{"$nulls":4},"Engineering and Administration:",{"$nulls":3},"NA",null,{"v":31.5,"d":"$31.50"}]
[" ",{"$nulls":4},"(Receivable ONLY):"]
["Utility Relocation Cost Total:",{"$nulls":8},{"v":275,"d":"$275.00"},null,{"v":241.5,"d":"$241.50"}]
[]
["Overall Utility Cost to be Paid by ADOT:",{"$nulls":8},{"v":33.5,"d":"33.50"}]

{"sheet":"Additional Comments","index":7,"n_rows":8,"n_cols":6,"rows_kept":8,"merged":[[0,0,1,8],[2,5,2,8],[3,5,3,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8]],"flags":["formulas_cached_only"]}
["Additional Comments"]
[]
["Entry No.","Page Reference","Column","Row","Original Entry","Comments"]
[1,"Cover Page","C",43,"Phoenix, AZ 85007","Enter new information regarding \"Original Entry\" here."]
[2,"Contacts List","E",7,"Street Name","Enter new information regarding \"Original Entry\" here."]
[3,"Utility Inventory","D",8,"SR 000 / 00+00 to 00+00 Rt/Lt","Enter new information regarding \"Original Entry\" here."]
[4,"Conflict Matrix","N",7,"Comments from facility owner","Enter new information regarding \"Original Entry\" here."]
[5,"Cost Estimate","C",11,"Bid Item 1","Enter new information regarding \"Original Entry\" here."]