{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Items","Unit Cost Analysis","Item Disaggregation Analysis","Cost Category Summary","Cost Categories","Definitions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Items","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,4,3],[0,0,0,3]]}
["Items"]
[]
[]
[]
[]
[null,"Item No.","Group/Item Name","Item Description"]
[null,null,"General"]
[]
[]
[null,null,"Earth Work"]
[]
[]
[null,null,"Lines, Pipes, and Other Linear Features"]
[]
[]
[null,null,"Appurtenances"]
[]
[]
[null,null,"Other"]

{"sheet":"Unit Cost Analysis","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Unit Cost Analysis"]
[]
[]
[]
[]
["Item No.","Item Name","Unit","Quantity","Unit Cost\n($/unit)","Amount\n($)",null,"Imported Amount\n($)","Validated\nUnit Cost\n($)"]
["Total"]

{"sheet":"Item Disaggregation Analysis","index":2,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,10],[3,0,3,10]]}
["Item Disaggregation Analysis"]
[]
[]
[]
[]
["Item",null,"Component","Item/Component Name","Cost Category","Unit","Quantity","Rate or Unit Price ($/unit)","Amount\n($)",null,"Imported Amount\n($)"]
["Total"]

{"sheet":"Cost Category Summary","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,0,6,0],[5,1,6,1],[0,0,0,6],[5,2,5,6],[5,7,6,7]]}
["Cost Category Summary"]
[]
[]
[]
[]
["Item No.","Item Name","Cost Category",null,null,null,null,"Amount\n($)"]
[null,null,"Materials and \nSupplies","Labor","Traffic Control","Overhead","Transportation \nand Equipment"]
["Total"]

{"sheet":"Cost Categories","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1],[11,0,11,1]]}
["Cost Categories"]
[]
[]
[]
[]
["Cost Category","Description"]
["Materials and Supplies","This category includes materials and supplies needed for the utility adjustment."]
["Labor","This category includes wages and salaries of personnel involved in the utility adjustment, including supervisory labor, preparation of plans, and estimate and agreement documents."]
["Overhead","This category includes overhead amounts in connection with other categories. Overhead charges must be detailed separately."]
["Transportation and Equipment","This category includes transportation, meals, and lodging expenses required by a utility company’s workforces in remote areas.  Equipment and rental costs include equipment type, size, and actual rates."]
[]
["Note: See the TxDOT ROW Utility Manual for additional information about allowable charges under each category."]

{"sheet":"Definitions","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Definitions"]
[]
["Element","Definition"]
["Item","An item is a logical division of the utility work to be conducted in the field, which has the following properties:\n• It can be measured directly in the field or by using plan quantities.\n• It is directly relevant and needed for the production of the work.\n• It provides a reasonable elvel of disaggregation that addresses the needs of all parties involved."]
["Component","A component is one of the cost elements that makes up an item and can be associated with a cost category."]
["Cost Category","A cost category is a grouping of cost components that are needed for the production of work at the item, group of items, or project level that provide a reasonable level of aggregation of cost components."]