{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":87,"n_cols":8,"rows_kept":87,"cut":false,"hidden":false,"merged":[[6,8,7,11],[86,0,86,7],[80,0,80,7],[83,0,83,7],[81,0,81,7],[79,0,79,7],[84,0,84,7],[85,0,85,7],[82,0,82,7],[74,0,74,7],[75,0,75,7],[77,0,77,7],[78,0,78,7],[71,0,71,4],[72,0,72,7],[73,1,73,2],[73,4,73,7],[65,1,65,2],[67,4,67,6],[68,1,68,2],[68,4,68,6],[69,0,69,6],[70,0,70,6],[62,1,62,2],[62,4,62,6],[63,1,63,2],[63,4,63,6],[64,1,64,2],[64,4,64,6],[19,0,19,1],[19,3,19,6],[20,0,20,1],[20,3,20,6],[24,0,24,1],[24,3,24,6],[23,3,23,6],[23,0,23,1],[17,3,17,6],[18,0,18,1],[18,3,18,6],[16,0,16,1],[16,3,16,6],[17,0,17,1],[8,4,8,6],[0,0,0,7],[1,1,1,2],[1,3,1,6],[2,0,2,6],[5,0,5,7],[6,0,12,0],[9,1,9,2],[17,11,17,12],[3,0,3,6],[4,0,4,7],[15,0,15,2],[15,3,15,7],[6,1,6,2],[6,4,6,6],[7,1,7,2],[7,4,7,6],[8,1,8,2],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[18,11,18,12],[19,11,19,12],[37,0,37,1],[38,0,38,1],[21,0,21,1],[21,3,21,6],[22,0,22,1],[22,3,22,6],[33,0,33,1],[32,0,32,1],[25,0,25,2],[25,3,25,7],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[12,1,12,2],[12,4,12,6],[13,0,13,6],[14,0,14,6],[9,4,9,6],[10,1,10,2],[10,4,10,6],[11,1,11,2],[11,4,11,6],[36,0,36,1],[35,3,35,7],[33,3,33,6],[34,3,34,6],[34,0,34,1],[36,3,36,6],[35,0,35,2],[39,0,39,1],[40,0,40,1],[41,0,41,1],[41,3,41,6],[46,0,46,1],[47,0,47,1],[44,0,44,1],[45,0,45,1],[43,0,43,2],[76,0,76,7],[42,0,42,1],[43,3,43,7],[65,4,65,6],[66,1,66,2],[66,4,66,6],[67,1,67,2],[47,3,47,6],[61,0,61,7],[62,0,68,0],[46,3,46,6],[45,3,45,6],[44,3,44,6],[50,3,50,6],[42,3,42,6],[50,0,50,1],[55,1,55,2],[55,4,55,6],[56,1,56,2],[48,0,48,1],[49,0,49,1],[49,3,49,6],[48,3,48,6],[32,3,32,6],[56,4,56,6],[57,1,57,2],[57,4,57,6],[58,1,58,2],[58,4,58,6],[52,1,52,2],[52,4,52,6],[53,1,53,2],[53,4,53,6],[26,3,26,6],[27,3,27,6],[28,3,28,6],[29,3,29,6],[30,3,30,6],[31,3,31,6],[37,3,37,6],[38,3,38,6],[39,3,39,6],[40,3,40,6],[59,0,59,6],[60,0,60,6],[51,0,51,7],[52,0,58,0],[54,1,54,2],[54,4,54,6]],"flags":["formulas_cached_only"]}
["MONTHLY FUEL COST ADJUSTMENT  WORKSHEET"]
["Estimate Date: ",null,null,"Estimate Number "]
["Price index for the cal month prior to the cal month in which bids are opened(BP), $/gal",{"$nulls":6},1]
["Price index for the cal month prior to the cal month in which the partial est pay period ends(EP), $/gal",{"$nulls":6},1.051]
["Quantities paid on current month estimate"]
["202 - Rotomilling items only (FF=0.006 gal/sy inch)"]
[null,"Item Description",null,"Square Yards","Depth (inches)",null,null,"Square Yard - Inches"]
[null,null,null,100000,2,null,null,200000]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["Total Square Yard - Inches",{"$nulls":6},200000]
["Fuel Cost Adjustment",{"$nulls":6},1.1999999999998678]
["203 items (except rock excavation) - Earthwork (muck excavation, unclassified excavation), embankment, borrow (FF = 0.29 gal/cy)",null,null,"203 - Rock Excavation items only (FF = 0.39 gal/cy)"]
["Item Description",null,"Cubic Yards","Item Description",null,null,null,"Cubic Yards"]
[null,null,100000,{"$nulls":4},15000]
[]
[]
[]
[]
[]
["Total Cubic Yards ",null,100000,"Total Cubic Yards ",null,null,null,15000]
["Fuel Cost Adjustment",null,28.999999999996803,"Fuel Cost Adjustment",null,null,null,5.849999999999356]
["206 items - Structure Excavation and Backfill (FF = 0.29 gal/cy)",null,null,"304 items - Aggregate Base Course (all classes) (FF = 0.85 gal/cy)"]
["Item Description",null,"Cubic Yards","Item Description",null,null,null,"Cubic Yards"]
[null,null,22000,{"$nulls":4},34000]
[]
[]
[]
[]
[]
["Total Cubic Yards",null,22000,"Total Cubic Yards",null,null,null,34000]
["Fuel Cost Adjustment",null,6.379999999999297,"Fuel Cost Adjustment",null,null,null,28.899999999996815]
["307 - Processing Lime Treated Subgrade (all depths) items (FF = 0.12 gal/sy)",null,null,"310 - Full Depth Reclamation of HMA Pavement items (all depths) (FF = 0.06 gal/sy)"]
["Item Description",null,"Square Yards","Item Description",null,null,null,"Square Yards"]
[null,null,11000,{"$nulls":4},150000]
[]
[]
[]
["Total Square Yards ",null,11000,"Total Square Yards ",null,null,null,150000]
["Fuel Cost Adjustment",null,1.3199999999998546,"Fuel Cost Adjustment",null,null,null,8.999999999999009]
["403 items - Hot Mix Asphalt (HMA), including Stone Mastic Asphalt (SMA) (FF = 2.47 gal/ton)",null,null,"405 - Heating & Scarifying items only (FF = 0.44 gal/sy)"]
["Item Description",null,"Tons","Item Description",null,null,null,"Square yards"]
[null,null,55000,{"$nulls":4},75000]
[]
[]
[]
["Total Tons",null,55000,"Total Square Yards",null,null,null,75000]
["Fuel Cost Adjustment",null,135.84999999998504,"Fuel Cost Adjustment",null,null,null,32.99999999999637]
["406 items - Cold Bituminous Pavement (Recycle) (FF = 0.01 gal/sy inch)"]
[null,"Item Description",null,"Square Yards","Depth (inches)",null,null,"Square Yard - Inches"]
[null,null,null,15000,6,null,null,90000]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["Total Square Yard - Inches",{"$nulls":6},90000]
["Fuel Cost Adjustment",{"$nulls":6},0.8999999999999009]
["412 items - Portland Cement Concrete Pavement (PCCP) (FF = 0.03 gal/sy inch)"]
[null,"Item Description",null,"Square Yards","Thickness (inches)",null,null,"Square Yard - Inches"]
[null,null,null,100000,9.5,null,null,950000]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["Total Square Yard - Inches",{"$nulls":6},950000]
["Fuel Cost Adjustment",{"$nulls":6},28.499999999996863]
["Total Fuel Cost Adjustment (FA) for Estimate",{"$nulls":4},0,"=",279.89999999996917]
["Prepared by:"]
["Date Prepared:",null,null,"Reference #"]
[]
["Instructions:  Enter data in the yellow cells to calculate the fuel cost adjustment"]
["  -  This spreadsheet calculates adjustments for fuel cost changes only"]
["  -  Enter the estimate cutoff date and estimate number (date may be entered as xx/xx/xx, xx-xx-xx, or as Month xx, xxxx - the worksheet will convert the format)."]
[" Ave fuel price index for the calendar month prior to the calendar month in which bids are opened(BP). "]
["Ave fuel price index for the calendar month prior to the calendar month in which the partial est pay period ends(EP)."]
["  -  For fuel cost-adjustable items (see specification),  enter the item description and the quantity paid for each item on the current estimate."]
["  -  Check to see how Aggregate Base Course is paid.  If it is paid for by the ton, convert to cubic yards by multiplying ton quantity by 0.557."]
["  -  This form automatically takes the +/- 5% \"trigger\" shown in the spec into account."]
["  -  If the total fuel cost adjustment is positive or negative, enter the amount shown as a fuel cost adjustment pay item on the estimate (negative numbers are red and in parentheses)."]
["  -  Enter the Date Prepared and the Reference # (The reference number is determined by"]
["     the Project Engineer to reference the report)."]
["  -  Print this form, sign it, and include it in your project documentation."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}