{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Start","Project Information","Item Lists","Fuel Index Calculations","Bit Index Calculations","Summary","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Overview","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Overview"]
[]
[null,"Purpose for the Spreadsheet"]
[null,"- Fuel Adjustment"]
[null,"· Computes payment adjustment for fuel price changes"]
[null,"·The Aviation Special Provision 109A (ASP 109A) requires the use of this tool to calculate the Fuel adjustment for all Tennessee Aeronautics Division projects that include the special provision"]
[null,"·Refer to Fuel Indexing Payment Adjustment One Pager on TAD Website"]
[null,"- Bituminous Materials Adjustment"]
[null,"·Computes price adjustment for items using Bituminous materials "]
[null,"·The Aviation Special Provision 109B (ASP 109B) requires the use of this tool to calculate the bituminous adjustment for all Tennessee Aeronautics Division projects that include the special provision"]
[null,"·Refer to Bituminous Indexing Payment Adjustment One Pager on TAD Website"]
[null,"Why use the Spreadsheet? "]
[null,"·Calculates additional compensation to the prime contractor or cost savings to Airport Sponsors (Owners) depending on cost fluctuations "]
[null,"·Promotes risk sharing for contractors and project sponsors"]
[null,"·Reduce risks and uncertainty for contractors and project sponsors due to petroleum price volatility "]
[]
[null,"What items are applicable to the special provision and this spreadsheet? "]
[null,"- Fuel Adjustment"]
[null,"· Excavation and embankment items"]
[null,"· Aggregate Base"]
[null,"· Bituminous mix base and surface"]
[null,"· Portland cement concrete"]
[null,"· Other items as outlined in the ASP 109A"]
[null,"- Bituminous Materials Adjustment"]
[null,"·Virgin asphalt mixtures"]
[null,"·Asphalt mixtures containing reclaimed asphalt pavement (RAP)"]
[null,"·Asphalt cement"]
[null,"·Asphalt emulsion "]
[null,"·Prime and Tack Coats"]
[null,"·Bituminous materials used for paving and surface treatments"]
[]
[null,"Questions? "]
[null,"·Reach out to assigned TDOT Aeronautics Division Project Manager with any questions"]

{"sheet":"Start","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"     About this Spreadsheet"]
[null,"Tab Description"]
[null,"Different sheets, or tabs, both provide information about the function of this spreadsheet and are where inputs are entered and outputs are displayed. A brief description of each tab follows:\n"]
[null,"• Overview tab – An introduction to the tool’s purpose and application according to the applicable special provision."]
[null,"• Item Lists tab – A table of typical items used in Tennessee Aeronautics Division (TAD) contracts to which cost adjustments are applied. These items are referenced in either the ASP 109A or ASP 109B special provisions based their applicability for either fuel or bituminous adjustment or both."]
[null,"• Fuel Index Calculations tab – A spreadsheet where fuel adjustments are calculated for each applicable item accepted during the\npay estimate period using project information provided by the contract and project records."]
[null,"• Bit Index Calculations tab – A spreadsheet where bituminous adjustments are calculated for each applicable item accepted during the\npay estimate period using project information provided by the contract and project records."]
[null,"• Summary tab – A project history of price adjustments based on accepted quantities of work for\neach estimate for fuel and bituminous material adjustments."]
[]
[null,"Instructions for Adjustment Calculation "]
[null,"The following step-by-step procedures are provided to assist in using the workbook and in understanding how the series of worksheets fit together. Be sure to follow these directions in sequence to allow the calculations to work properly. Avoid using the cut and paste feature as this can write over any functions, commands, or equations. Make sure to “Enable Content” in Excel when the file is opened so that functions work properly."]
[null,"1. Update the item list in the \"Item Lists\" worksheet according to the scope of the project. Use either the \"Add Items\" button, which should open a form to fill, or manually enter information into the last row of the list. The form contains additional instructions to complete. If entering information manually, please check pop up notes on each column headings for additional instructions. The list is dynamic, so all cells that are dependent on the list are updated automatically. Each item row may be edited to fit specific items in the contract.  Information can be edited, deleted, or updated. Note: This step is completed at the beginning of the project."]
[null,"2. Go to the Project Information tab worksheet and enter the relevant information in cells E5 through E15.  This is general information (such as the Project ID, TAD Proj. No., and so on), the bid fuel index (bid date, fuel index and fuel price) and bituminous index (Bid date and bid index) needed to identify the project and to complete the cost adjustment computations. If any of the items are not applicable, enter zero. If the project applies to multiple airports, enter Multiple as Airport ID and enter the Airport Names, Regions, and County names manually. Note: This information is project specific and should only require entry at the beginning of the project. The project information entered should automatically populate the project information in the \"Bit Index Calculations\" and \"Fuel Index Calculations\" spreadsheet. "]
[null,"-Fuel Adjustment (ASP 109A)"]
[null,"3. Go to the 'Fuel Index' section in the \"Fuel Index Calculations\" worksheet and enter the relevant items in cells I7 to I9.  The TDOT Fuel Index Information can be obtained using the source file links in the cell titles. Also enter the pay estimate date for the corresponding pay adjustment and the pay estimate number. Note: These components of the adjustment are likely to change each month with changing Fuel index values."]
[null,"4.  In the \"Fuel Index Calculations\" worksheet, enter the project-specific item information in the item table.  More information for entering the table values are found as pop-up instructions in the column headings. "]
[null,"5. In the \"Fuel Index Calculations\" worksheet, enter the date of the estimate in Row 14. The cost adjustment is summarized in Row 15. Enter the user's name in row 16. "]
[null,"6.  After all inputs in the \"Fuel Index Calculations\" worksheet are entered, click on the \"Print Summary\" button and the itemized results will be exported to the \"Summary\" tab ."]
[null,"7. Press 'CTRL'+'P' to print the \"Fuel Index Calculations\" worksheet. The print settings are set to print the \"Fuel Index Calculations\" worksheet of all fuel adjustment items included."]
[null,"-Bituminous Material Adjustment (ASP 109B)"]
[null,"8. Then go to the \"Bituminous Index\" section in the \"Bit Index Calculations\" worksheet and enter the relevant items in cells I6 to I8.  The TDOT Bituminous Index Information can be obtained using the source file links in the cell titles. Also enter the pay estimate date for the corresponding pay adjustment and  the pay estimate number. Note: These components of the adjustment are likely to change each month with changing bituminous index values."]
[null,"9. In the \"Bit Index Calculations\" worksheet, enter the project-specific item information in either the Virgin or Recycled Mix table.  A summary of the tables is included below. Links to the applicable FAA advisory circulars (when available) are provided, but users should also consider the project specifications to complete the item descriptions and terms. More information for entering the table values are found as pop-up instructions in the column headings. "]
[null,"Payment Adjustment 1 - Virgin Mix (Row 19 to 55)"]
[null,"• Table 1- P-4.. FAA Flexible Pavements (Virgin)"]
[null,"• Table 2 - P-6.. FAA Surface Treatments"]
[null,"• Table 3 - P-6.. FAA Prime and Tack Coats"]
[null,"Payment Adjustment 2 - Recycled Mix (Row 56 - 64)"]
[null,"• Table 4-P-4.. Recycled Bituminous Material"]
[null,"10. In the \"Bit Index Calculations\" worksheet, enter the date of the estimate in Row 14. The cost adjustment is summarized in Row 15. Enter the user's name in row 16. "]
[null,"11.  After all inputs in the \"Bit Index Calculations\" worksheet are entered, click on the \"Print Summary\" button and the itemized results will be exported to the \"Summary\" tab ."]
[null,"12. Press 'CTRL'+'P' to print the \"Bit Index Calculation\" worksheet. The print settings are set to print the \"Bit Index Calculations\" worksheet as a two-page summary of all bituminous adjustment items included."]
[null,"-Summary "]
[null,"13. In the \"Summary\" sheet, calculated pay adjustments are added, and the a running total is calculated starting from the first estimate. The sheet also contains a list of items that had price adjustments and the corresponding adjustment amounts. "]
[]
[null,"Note: "]
[null,"• In the \"Bit Index Calculations\" tab, \"Fuel Index Calculations\" tab  and \"Summary\" tabs, in order to delete cells, select the cells and press 'delete'. Only specified cells (Highlighted in a note in the respective tabs) can be deleted. The protection in the sheets prevents deleting non input cells. Alternatively, a 'Clear' button can be used in the calculation and summary sheets to clear all specified cells to begin with a blank page. "]
[null,"• Please perform any updates on the item description in the \"Item Lists\" tab."]
[null,"• Read the pop up instructions in each column heading in the tables before filling out the details."]
[null,"• For recycled bituminous materials, the payment adjustment formulas account for the appropriate pay adjustment process."]
[null,"• Fuel adjustment and Bituminous adjustments are calculated only if the variation is more than 5 percent in accordance with the TAD special provisions."]
[null,"• This spreadsheet makes the process of adding items and calculations easier; however, if the programming of the sheet needs to be updated, the hidden sheet - \"Sheet1\"- contains the cells/arrays/information that feed into the main workbook. The description for each table in the hidden sheet is listed in comments at the heading."]
[null,"• Additional instructions have been provided in column A in the \"Bit Index Calculations\" and \"Fuel Index Calculations\" worksheet. "]
[null,"• If there are any issues with or questions about the use of the workbook, please contact the TAD Project Manager."]
[null,"• Estimated Residue Table - Refer this table to fill in the estimated residue field in \"Item Lists\" tab."]

{"sheet":"Project Information","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[6,2,6,3],[6,4,6,5],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[10,2,10,3],[10,4,10,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[9,2,9,3],[9,4,9,5],[13,2,13,3],[13,4,13,5],[14,2,14,3],[11,2,11,3],[11,4,11,5],[12,2,12,3],[14,4,14,5],[12,4,12,5]]}
[]
[null,"Project Information"]
[]
[]
[null,null,"Project Title"]
[null,null,"TAD Proj. No."]
[null,null,"Airport ID"]
[null,null,"Airport Name"]
[null,null,"County"]
[null,null,"Region"]
[null,null,"Prime Contractor"]
[null,null,"Base Bidding Date"]
[null,null,"Fuel Bidding Value (gal)"]
[null,null,"Fuel Price ($/ Gallon)"]
[null,null,"Bituminous Bidding Index ($/ton)"]

{"sheet":"Item Lists","index":3,"n_rows":199,"n_cols":14,"rows_kept":199,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["LIST OF ITEMS"]
["Serial Number","Item Number","Descriptions ","Treatment Type ","Virgin/Recycled ","Application Number","Estimated Application Rate (gal/sy)","Estimated Volumetric Density (lb/gal)","Estimated Residue (%)","Unique ID","Conversion factor (SY to TONS)","Conversion factor (GAL to TONS)","Fuel Factor","Fuel Factor Unit of Measure"]
[1,"P-602-5.1-a","Emulsified Asphalt Prime Coat","FAA Prime and Tack Coats","Virgin","N/A",null,9,54,{"$f":"_xlfn.CONCAT(B3,F3)","v":"P-602-5.1-aN/A"},{"$f":"IFERROR(_xlfn.SWITCH(F3,2,SUMPRODUCT(IF($B$3:$B$100=B3,1,0),IF($F$3:$F$100<=F3,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B3,1,0),IF($F$3:$F$100<=F3,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G3=\"\",1,G3)*H3/2000),\"N/A\")","v":4.4999999999999997E-3},{"$f":"IFERROR(H3/2000,\"N/A\")","v":4.4999999999999997E-3},"N/A","N/A"]
[2,"P-603-5.1-a","Emulsified Asphalt Tack Coat","FAA Prime and Tack Coats","Virgin","N/A",null,9,63,"P-603-5.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F4,2,SUMPRODUCT(IF($B$3:$B$100=B4,1,0),IF($F$3:$F$100<=F4,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B4,1,0),IF($F$3:$F$100<=F4,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G4=\"\",1,G4)*H4/2000),\"N/A\")","v":4.4999999999999997E-3},4.4999999999999997E-3,"N/A","N/A"]
[3,"P-602-5.1-b","Emulsified Asphalt Prime Coat","FAA Prime and Tack Coats","Virgin","N/A",null,9,54,4.4999999999999997E-3,4.4999999999999997E-3,"N/A","N/A"]
[4,"P-603-5.1-b","Emulsified Asphalt Tack Coat","FAA Prime and Tack Coats","Virgin","N/A",null,9,63,4.4999999999999997E-3,4.4999999999999997E-3,"N/A","N/A"]
[5,"P-608-8.1-a","Emulsified Asphalt Surface Treatment","FAA Surface Treatments","Virgin",1,0.13500000000000001,9,28.5,"P-608-8.1-a1",{"$f":"IFERROR(_xlfn.SWITCH(F7,2,SUMPRODUCT(IF($B$3:$B$100=B7,1,0),IF($F$3:$F$100<=F7,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B7,1,0),IF($F$3:$F$100<=F7,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G7=\"\",1,G7)*H7/2000),\"N/A\")","v":6.0750000000000008E-4},4.4999999999999997E-3,"N/A","N/A"]
[6,"P-608-R-8.1-a","Rapid Cure Seal Coat","FAA Surface Treatments","Virgin",1,0.115,9,37.5,"P-608-R-8.1-a1",{"$f":"IFERROR(_xlfn.SWITCH(F8,2,SUMPRODUCT(IF($B$3:$B$100=B8,1,0),IF($F$3:$F$100<=F8,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B8,1,0),IF($F$3:$F$100<=F8,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G8=\"\",1,G8)*H8/2000),\"N/A\")","v":5.1750000000000006E-4},4.4999999999999997E-3,"N/A","N/A"]
[7,"P-609-5.1-a","Asphalt Cement,  Type 1 Chip Seal ","FAA Surface Treatments","Virgin","N/A",0.4,7.71,100,"P-609-5.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F9,2,SUMPRODUCT(IF($B$3:$B$100=B9,1,0),IF($F$3:$F$100<=F9,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B9,1,0),IF($F$3:$F$100<=F9,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G9=\"\",1,G9)*H9/2000),\"N/A\")","v":1.542E-3},3.8549999999999999E-3,"N/A","N/A"]
[8,"P-609-5.2-a","Emulsified Asphalt, Type 1 Chip Seal","FAA Surface Treatments","Virgin","N/A",0.45,9,69,"P-609-5.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F10,2,SUMPRODUCT(IF($B$3:$B$100=B10,1,0),IF($F$3:$F$100<=F10,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B10,1,0),IF($F$3:$F$100<=F10,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G10=\"\",1,G10)*H10/2000),\"N/A\")","v":2.0249999999999999E-3},4.4999999999999997E-3,"N/A","N/A"]
[9,"P-623-8.1-a","Emulsified Asphalt Spray Seal Coat","FAA Surface Treatments","Virgin",1,0.17,9,44,{"$f":"_xlfn.CONCAT(B11,F11)","v":"P-623-8.1-a1"},{"$f":"IFERROR(_xlfn.SWITCH(F11,2,SUMPRODUCT(IF($B$3:$B$100=B11,1,0),IF($F$3:$F$100<=F11,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B11,1,0),IF($F$3:$F$100<=F11,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G11=\"\",1,G11)*H11/2000),\"N/A\")","v":7.6500000000000005E-4},4.4999999999999997E-3,"N/A","N/A"]
[10,"P-623-8.1-a","Emulsified Asphalt Spray Seal Coat","FAA Surface Treatments","Virgin",2,0.15,9,44,{"$f":"_xlfn.CONCAT(B12,F12)","v":"P-623-8.1-a2"},{"$f":"IFERROR(_xlfn.SWITCH(F12,2,SUMPRODUCT(IF($B$3:$B$100=B12,1,0),IF($F$3:$F$100<=F12,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B12,1,0),IF($F$3:$F$100<=F12,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G12=\"\",1,G12)*H12/2000),\"N/A\")","v":1.4399999999999999E-3},4.4999999999999997E-3,"N/A","N/A"]
[11,"P-623-8.1-a","Emulsified Asphalt Spray Seal Coat","FAA Surface Treatments","Virgin",3,0.115,9,44,"P-623-8.1-a3",{"$f":"IFERROR(_xlfn.SWITCH(F13,2,SUMPRODUCT(IF($B$3:$B$100=B13,1,0),IF($F$3:$F$100<=F13,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B13,1,0),IF($F$3:$F$100<=F13,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G13=\"\",1,G13)*H13/2000),\"N/A\")","v":1.9575E-3},4.4999999999999997E-3,"N/A","N/A"]
[12,"P-626-6.1-a","Emulsified Asphalt for Slurry Coat","FAA Surface Treatments","Virgin","N/A",null,9,65,"P-626-6.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F14,2,SUMPRODUCT(IF($B$3:$B$100=B14,1,0),IF($F$3:$F$100<=F14,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B14,1,0),IF($F$3:$F$100<=F14,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G14=\"\",1,G14)*H14/2000),\"N/A\")","v":4.4999999999999997E-3},4.4999999999999997E-3,"N/A","N/A"]
[13,"P-626-6.3-a","Emulsified Asphalt for Slurry Coat Tack","FAA Surface Treatments","Virgin","N/A",0.1,9,63,"P-626-6.3-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F15,2,SUMPRODUCT(IF($B$3:$B$100=B15,1,0),IF($F$3:$F$100<=F15,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B15,1,0),IF($F$3:$F$100<=F15,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G15=\"\",1,G15)*H15/2000),\"N/A\")","v":4.4999999999999999E-4},4.4999999999999997E-3,"N/A","N/A"]
[14,"P-626-6.1-b","Emulsified Asphalt for Slurry Coat","FAA Surface Treatments","Virgin","N/A",null,9,65,{"$f":"_xlfn.CONCAT(B16,F16)","v":"P-626-6.1-bN/A"},{"$f":"IFERROR(_xlfn.SWITCH(F16,2,SUMPRODUCT(IF($B$3:$B$100=B16,1,0),IF($F$3:$F$100<=F16,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B16,1,0),IF($F$3:$F$100<=F16,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G16=\"\",1,G16)*H16/2000),\"N/A\")","v":4.4999999999999997E-3},{"$f":"IFERROR(H16/2000,\"N/A\")","v":4.4999999999999997E-3},"N/A","N/A"]
[15,"P-626-6.3-b","Emulsified Asphalt for Slurry Coat Tack","FAA Surface Treatments","Virgin","N/A",0.1,9,63,"P-626-6.3-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F17,2,SUMPRODUCT(IF($B$3:$B$100=B17,1,0),IF($F$3:$F$100<=F17,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B17,1,0),IF($F$3:$F$100<=F17,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G17=\"\",1,G17)*H17/2000),\"N/A\")","v":4.4999999999999999E-4},4.4999999999999997E-3,"N/A","N/A"]
[16,"P-401-8.6-a","State Aviation Asphalt Surface Course","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.6-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F18,2,SUMPRODUCT(IF($B$3:$B$100=B18,1,0),IF($F$3:$F$100<=F18,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B18,1,0),IF($F$3:$F$100<=F18,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G18=\"\",1,G18)*H18/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[17,"P-401-8.7-a","State Aviation Asphalt Surface Course w/ RAP","FAA Flexible Pavements","Recycled","N/A",null,null,100,"P-401-8.7-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F19,2,SUMPRODUCT(IF($B$3:$B$100=B19,1,0),IF($F$3:$F$100<=F19,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B19,1,0),IF($F$3:$F$100<=F19,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G19=\"\",1,G19)*H19/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[18,"P-609-5.1-b","Asphalt Cement,  Type 2 Chip Seal ","FAA Surface Treatments","Virgin","N/A",0.2,7.71,100,"P-609-5.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F20,2,SUMPRODUCT(IF($B$3:$B$100=B20,1,0),IF($F$3:$F$100<=F20,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B20,1,0),IF($F$3:$F$100<=F20,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G20=\"\",1,G20)*H20/2000),\"N/A\")","v":7.7099999999999998E-4},3.8549999999999999E-3,"N/A","N/A"]
[19,"P-609-5.2-b","Emulsified Asphalt, Type 2 Chip Seal","FAA Surface Treatments","Virgin","N/A",0.28000000000000003,9,69,"P-609-5.2-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F21,2,SUMPRODUCT(IF($B$3:$B$100=B21,1,0),IF($F$3:$F$100<=F21,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B21,1,0),IF($F$3:$F$100<=F21,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G21=\"\",1,G21)*H21/2000),\"N/A\")","v":1.2600000000000003E-3},4.4999999999999997E-3,"N/A","N/A"]
[20,"P-609-5.2-c","Emulsified Asphalt, Type 3 Chip Seal","FAA Surface Treatments","Virgin","N/A",0.18,9,69,"P-609-5.2-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F22,2,SUMPRODUCT(IF($B$3:$B$100=B22,1,0),IF($F$3:$F$100<=F22,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B22,1,0),IF($F$3:$F$100<=F22,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G22=\"\",1,G22)*H22/2000),\"N/A\")","v":8.0999999999999996E-4},4.4999999999999997E-3,"N/A","N/A"]
[21,"P-152-4.1-a","Any Road and Drainage Excavation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F23,2,SUMPRODUCT(IF($B$3:$B$100=B23,1,0),IF($F$3:$F$100<=F23,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B23,1,0),IF($F$3:$F$100<=F23,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G23=\"\",1,G23)*H23/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[22,"P-152-4.1-b","Any Borrow Excavation (Rock)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F24,2,SUMPRODUCT(IF($B$3:$B$100=B24,1,0),IF($F$3:$F$100<=F24,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B24,1,0),IF($F$3:$F$100<=F24,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G24=\"\",1,G24)*H24/2000),\"N/A\")","v":"N/A"},"N/A",0.36,"Cubic Yard"]
[23,"P-152-4.1-c","Any Borrow Excavation (Other than Solid Rock)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.1-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F25,2,SUMPRODUCT(IF($B$3:$B$100=B25,1,0),IF($F$3:$F$100<=F25,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B25,1,0),IF($F$3:$F$100<=F25,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G25=\"\",1,G25)*H25/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[24,"P-152-4.1-d","Any Borrow Excavation (Rock)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.1-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F26,2,SUMPRODUCT(IF($B$3:$B$100=B26,1,0),IF($F$3:$F$100<=F26,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B26,1,0),IF($F$3:$F$100<=F26,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G26=\"\",1,G26)*H26/2000),\"N/A\")","v":"N/A"},"N/A",0.16,"Ton"]
[25,"P-152-4.1-e","Any Borrow Excavation (Other than Solid Rock)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.1-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F27,2,SUMPRODUCT(IF($B$3:$B$100=B27,1,0),IF($F$3:$F$100<=F27,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B27,1,0),IF($F$3:$F$100<=F27,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G27=\"\",1,G27)*H27/2000),\"N/A\")","v":"N/A"},"N/A",0.11,"Ton"]
[26,"P-152-4.1-f","Undercutting","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.1-fN/A",{"$f":"IFERROR(_xlfn.SWITCH(F28,2,SUMPRODUCT(IF($B$3:$B$100=B28,1,0),IF($F$3:$F$100<=F28,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B28,1,0),IF($F$3:$F$100<=F28,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G28=\"\",1,G28)*H28/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[27,"P-152-4.2-a","Any Embankment (in-place)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-152-4.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F29,2,SUMPRODUCT(IF($B$3:$B$100=B29,1,0),IF($F$3:$F$100<=F29,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B29,1,0),IF($F$3:$F$100<=F29,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G29=\"\",1,G29)*H29/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[28,"P-207-5.2-a","Any Aggregate Base","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F30,2,SUMPRODUCT(IF($B$3:$B$100=B30,1,0),IF($F$3:$F$100<=F30,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B30,1,0),IF($F$3:$F$100<=F30,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G30=\"\",1,G30)*H30/2000),\"N/A\")","v":"N/A"},"N/A",0.79,"Ton"]
[29,"P-307-7.1-a","Cement-treated permeable base course (CTPB)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-307-7.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F31,2,SUMPRODUCT(IF($B$3:$B$100=B31,1,0),IF($F$3:$F$100<=F31,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B31,1,0),IF($F$3:$F$100<=F31,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G31=\"\",1,G31)*H31/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[30,"P-501-8.1-a","Any Portland Cement Concrete Pavement ≤ 10 in. thickness","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",{"$f":"_xlfn.CONCAT(#REF!,F32)","v":{"$error":"#REF!"}},{"$f":"IFERROR(_xlfn.SWITCH(F32,2,SUMPRODUCT(IF($B$3:$B$100=#REF!,1,0),IF($F$3:$F$100<=F32,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=#REF!,1,0),IF($F$3:$F$100<=F32,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G32=\"\",1,G32)*H32/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[31,"P-501-8.1-b","Any Portland Cement Concrete Pavement > 10 in. thickness","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",{"$f":"_xlfn.CONCAT(B32,F33)","v":"P-501-8.1-aN/A"},{"$f":"IFERROR(_xlfn.SWITCH(F33,2,SUMPRODUCT(IF($B$3:$B$100=B32,1,0),IF($F$3:$F$100<=F33,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B32,1,0),IF($F$3:$F$100<=F33,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G33=\"\",1,G33)*H33/2000),\"N/A\")","v":"N/A"},"N/A",0.3,"Square Yard"]
[32,"P-152-4.3-a","Unclassified Excavation to Off-Site Disposal","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",{"$f":"_xlfn.CONCAT(B33,F34)","v":"P-501-8.1-bN/A"},{"$f":"IFERROR(_xlfn.SWITCH(F34,2,SUMPRODUCT(IF($B$3:$B$100=B33,1,0),IF($F$3:$F$100<=F34,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B33,1,0),IF($F$3:$F$100<=F34,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G34=\"\",1,G34)*H34/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[33,"P-401-8.1-a","Asphalt Surface Course (Gradation 1, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,{"$f":"_xlfn.CONCAT(B35,F35)","v":"P-401-8.1-aN/A"},{"$f":"IFERROR(_xlfn.SWITCH(F35,2,SUMPRODUCT(IF($B$3:$B$100=B35,1,0),IF($F$3:$F$100<=F35,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B35,1,0),IF($F$3:$F$100<=F35,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G35=\"\",1,G35)*H35/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[34,"P-401-8.1-b","Asphalt Surface Course (Gradation 1, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F36,2,SUMPRODUCT(IF($B$3:$B$100=B36,1,0),IF($F$3:$F$100<=F36,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B36,1,0),IF($F$3:$F$100<=F36,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G36=\"\",1,G36)*H36/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[35,"P-401-8.1-c","Asphalt Surface Course (Gradation 1, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F37,2,SUMPRODUCT(IF($B$3:$B$100=B37,1,0),IF($F$3:$F$100<=F37,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B37,1,0),IF($F$3:$F$100<=F37,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G37=\"\",1,G37)*H37/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[36,"P-401-8.1-d","Asphalt Surface Course (Gradation 2, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F38,2,SUMPRODUCT(IF($B$3:$B$100=B38,1,0),IF($F$3:$F$100<=F38,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B38,1,0),IF($F$3:$F$100<=F38,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G38=\"\",1,G38)*H38/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[37,"P-401-8.1-e","Asphalt Surface Course (Gradation 2, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F39,2,SUMPRODUCT(IF($B$3:$B$100=B39,1,0),IF($F$3:$F$100<=F39,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B39,1,0),IF($F$3:$F$100<=F39,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G39=\"\",1,G39)*H39/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[38,"P-401-8.1-f","Asphalt Surface Course (Gradation 2, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-fN/A",{"$f":"IFERROR(_xlfn.SWITCH(F40,2,SUMPRODUCT(IF($B$3:$B$100=B40,1,0),IF($F$3:$F$100<=F40,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B40,1,0),IF($F$3:$F$100<=F40,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G40=\"\",1,G40)*H40/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[39,"P-401-8.1-g","Asphalt Surface Course (Gradation 2, PG 82-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-gN/A",{"$f":"IFERROR(_xlfn.SWITCH(F41,2,SUMPRODUCT(IF($B$3:$B$100=B41,1,0),IF($F$3:$F$100<=F41,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B41,1,0),IF($F$3:$F$100<=F41,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G41=\"\",1,G41)*H41/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[40,"P-401-8.1-h","Asphalt Surface Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.1-hN/A",{"$f":"IFERROR(_xlfn.SWITCH(F42,2,SUMPRODUCT(IF($B$3:$B$100=B42,1,0),IF($F$3:$F$100<=F42,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B42,1,0),IF($F$3:$F$100<=F42,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G42=\"\",1,G42)*H42/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[41,"P-401-8.2-a","Asphalt Base Course (Thickness 1, Gradation 1, Binder Grade 1)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F43,2,SUMPRODUCT(IF($B$3:$B$100=B43,1,0),IF($F$3:$F$100<=F43,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B43,1,0),IF($F$3:$F$100<=F43,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G43=\"\",1,G43)*H43/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[42,"P-401-8.3-a","Asphalt Binder Course  (Thickness 1, Gradation 1, Binder Grade 1)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.3-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F44,2,SUMPRODUCT(IF($B$3:$B$100=B44,1,0),IF($F$3:$F$100<=F44,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B44,1,0),IF($F$3:$F$100<=F44,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G44=\"\",1,G44)*H44/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[43,"P-401-8.4-a","Asphalt Levelling Course  (Thickness 1, Gradation 1, Binder Grade 1)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-401-8.4-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F45,2,SUMPRODUCT(IF($B$3:$B$100=B45,1,0),IF($F$3:$F$100<=F45,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B45,1,0),IF($F$3:$F$100<=F45,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G45=\"\",1,G45)*H45/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[44,"P-403-8.1-a","Asphalt Surface Course (Gradation 1, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F46,2,SUMPRODUCT(IF($B$3:$B$100=B46,1,0),IF($F$3:$F$100<=F46,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B46,1,0),IF($F$3:$F$100<=F46,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G46=\"\",1,G46)*H46/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[45,"P-403-8.1-b","Asphalt Surface Course (Gradation 1, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F47,2,SUMPRODUCT(IF($B$3:$B$100=B47,1,0),IF($F$3:$F$100<=F47,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B47,1,0),IF($F$3:$F$100<=F47,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G47=\"\",1,G47)*H47/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[46,"P-403-8.1-c","Asphalt Surface Course (Gradation 1, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F48,2,SUMPRODUCT(IF($B$3:$B$100=B48,1,0),IF($F$3:$F$100<=F48,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B48,1,0),IF($F$3:$F$100<=F48,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G48=\"\",1,G48)*H48/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[47,"P-403-8.1-d","Asphalt Surface Course (Gradation 2, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F49,2,SUMPRODUCT(IF($B$3:$B$100=B49,1,0),IF($F$3:$F$100<=F49,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B49,1,0),IF($F$3:$F$100<=F49,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G49=\"\",1,G49)*H49/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[48,"P-403-8.1-e","Asphalt Surface Course (Gradation 2, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F50,2,SUMPRODUCT(IF($B$3:$B$100=B50,1,0),IF($F$3:$F$100<=F50,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B50,1,0),IF($F$3:$F$100<=F50,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G50=\"\",1,G50)*H50/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[49,"P-403-8.1-f","Asphalt Surface Course (Gradation 2, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-fN/A",{"$f":"IFERROR(_xlfn.SWITCH(F51,2,SUMPRODUCT(IF($B$3:$B$100=B51,1,0),IF($F$3:$F$100<=F51,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B51,1,0),IF($F$3:$F$100<=F51,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G51=\"\",1,G51)*H51/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[50,"P-403-8.1-g","Asphalt Surface Course (Gradation 2, PG 82-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-gN/A",{"$f":"IFERROR(_xlfn.SWITCH(F52,2,SUMPRODUCT(IF($B$3:$B$100=B52,1,0),IF($F$3:$F$100<=F52,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B52,1,0),IF($F$3:$F$100<=F52,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G52=\"\",1,G52)*H52/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[51,"P-403-8.1-h","Asphalt Surface Course (Desc)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-hN/A",{"$f":"IFERROR(_xlfn.SWITCH(F53,2,SUMPRODUCT(IF($B$3:$B$100=B53,1,0),IF($F$3:$F$100<=F53,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B53,1,0),IF($F$3:$F$100<=F53,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G53=\"\",1,G53)*H53/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[52,"P-403-8.1-i","Asphalt Surface Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.1-iN/A",{"$f":"IFERROR(_xlfn.SWITCH(F54,2,SUMPRODUCT(IF($B$3:$B$100=B54,1,0),IF($F$3:$F$100<=F54,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B54,1,0),IF($F$3:$F$100<=F54,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G54=\"\",1,G54)*H54/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[53,"P-403-8.2-a","Asphalt Base Course (Gradation 1, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F55,2,SUMPRODUCT(IF($B$3:$B$100=B55,1,0),IF($F$3:$F$100<=F55,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B55,1,0),IF($F$3:$F$100<=F55,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G55=\"\",1,G55)*H55/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[54,"P-403-8.2-b","Asphalt Base Course (Gradation 1, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F56,2,SUMPRODUCT(IF($B$3:$B$100=B56,1,0),IF($F$3:$F$100<=F56,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B56,1,0),IF($F$3:$F$100<=F56,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G56=\"\",1,G56)*H56/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[55,"P-403-8.2-c","Asphalt Base Course (Gradation 1, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F57,2,SUMPRODUCT(IF($B$3:$B$100=B57,1,0),IF($F$3:$F$100<=F57,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B57,1,0),IF($F$3:$F$100<=F57,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G57=\"\",1,G57)*H57/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[56,"P-403-8.2-d","Asphalt Base Course (Gradation 2, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F58,2,SUMPRODUCT(IF($B$3:$B$100=B58,1,0),IF($F$3:$F$100<=F58,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B58,1,0),IF($F$3:$F$100<=F58,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G58=\"\",1,G58)*H58/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[57,"P-403-8.2-e","Asphalt Base Course (Gradation 2, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F59,2,SUMPRODUCT(IF($B$3:$B$100=B59,1,0),IF($F$3:$F$100<=F59,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B59,1,0),IF($F$3:$F$100<=F59,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G59=\"\",1,G59)*H59/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[58,"P-403-8.2-f","Asphalt Base Course (Gradation 2, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-fN/A",{"$f":"IFERROR(_xlfn.SWITCH(F60,2,SUMPRODUCT(IF($B$3:$B$100=B60,1,0),IF($F$3:$F$100<=F60,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B60,1,0),IF($F$3:$F$100<=F60,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G60=\"\",1,G60)*H60/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[59,"P-403-8.2-g","Asphalt Base Course (Gradation 2, PG 82-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-gN/A",{"$f":"IFERROR(_xlfn.SWITCH(F61,2,SUMPRODUCT(IF($B$3:$B$100=B61,1,0),IF($F$3:$F$100<=F61,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B61,1,0),IF($F$3:$F$100<=F61,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G61=\"\",1,G61)*H61/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[60,"P-403-8.2-h","Asphalt Base Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-hN/A",{"$f":"IFERROR(_xlfn.SWITCH(F62,2,SUMPRODUCT(IF($B$3:$B$100=B62,1,0),IF($F$3:$F$100<=F62,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B62,1,0),IF($F$3:$F$100<=F62,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G62=\"\",1,G62)*H62/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[61,"P-403-8.2-i","Asphalt Base Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.2-iN/A",{"$f":"IFERROR(_xlfn.SWITCH(F63,2,SUMPRODUCT(IF($B$3:$B$100=B63,1,0),IF($F$3:$F$100<=F63,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B63,1,0),IF($F$3:$F$100<=F63,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G63=\"\",1,G63)*H63/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[62,"P-403-8.3-a","Asphalt Binder Course (Gradation 1, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F64,2,SUMPRODUCT(IF($B$3:$B$100=B64,1,0),IF($F$3:$F$100<=F64,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B64,1,0),IF($F$3:$F$100<=F64,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G64=\"\",1,G64)*H64/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[63,"P-403-8.3-b","Asphalt Binder Course (Gradation 1, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F65,2,SUMPRODUCT(IF($B$3:$B$100=B65,1,0),IF($F$3:$F$100<=F65,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B65,1,0),IF($F$3:$F$100<=F65,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G65=\"\",1,G65)*H65/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[64,"P-403-8.3-c","Asphalt Binder Course (Gradation 1, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F66,2,SUMPRODUCT(IF($B$3:$B$100=B66,1,0),IF($F$3:$F$100<=F66,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B66,1,0),IF($F$3:$F$100<=F66,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G66=\"\",1,G66)*H66/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[65,"P-403-8.3-d","Asphalt Binder Course (Gradation 2, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F67,2,SUMPRODUCT(IF($B$3:$B$100=B67,1,0),IF($F$3:$F$100<=F67,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B67,1,0),IF($F$3:$F$100<=F67,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G67=\"\",1,G67)*H67/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[66,"P-403-8.3-e","Asphalt Binder Course (Gradation 2, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F68,2,SUMPRODUCT(IF($B$3:$B$100=B68,1,0),IF($F$3:$F$100<=F68,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B68,1,0),IF($F$3:$F$100<=F68,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G68=\"\",1,G68)*H68/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[67,"P-403-8.3-f","Asphalt Binder Course (Gradation 2, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-fN/A",{"$f":"IFERROR(_xlfn.SWITCH(F69,2,SUMPRODUCT(IF($B$3:$B$100=B69,1,0),IF($F$3:$F$100<=F69,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B69,1,0),IF($F$3:$F$100<=F69,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G69=\"\",1,G69)*H69/2000),\"N/A\")","v":0},{"$f":"IFERROR(H69/2000,\"N/A\")","v":0},"N/A","N/A"]
[68,"P-403-8.3-g","Asphalt Binder Course (Gradation 2, PG 82-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-gN/A",{"$f":"IFERROR(_xlfn.SWITCH(F70,2,SUMPRODUCT(IF($B$3:$B$100=B70,1,0),IF($F$3:$F$100<=F70,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B70,1,0),IF($F$3:$F$100<=F70,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G70=\"\",1,G70)*H70/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[69,"P-403-8.3-h","Asphalt Binder Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-hN/A",{"$f":"IFERROR(_xlfn.SWITCH(F71,2,SUMPRODUCT(IF($B$3:$B$100=B71,1,0),IF($F$3:$F$100<=F71,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B71,1,0),IF($F$3:$F$100<=F71,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G71=\"\",1,G71)*H71/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[70,"P-403-8.3-i","Asphalt Binder Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.3-iN/A",{"$f":"IFERROR(_xlfn.SWITCH(F72,2,SUMPRODUCT(IF($B$3:$B$100=B72,1,0),IF($F$3:$F$100<=F72,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B72,1,0),IF($F$3:$F$100<=F72,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G72=\"\",1,G72)*H72/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[71,"P-403-8.4-a","Asphalt Levelling Course  (Thickness 1, Gradation 1, Binder Grade 1)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-403-8.4-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F73,2,SUMPRODUCT(IF($B$3:$B$100=B73,1,0),IF($F$3:$F$100<=F73,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B73,1,0),IF($F$3:$F$100<=F73,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G73=\"\",1,G73)*H73/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[72,"P-404-8.1-a","Fuel Resistant Asphalt Mix Pavement Surface Course","FAA Flexible Pavements","Virgin","N/A",null,null,100,"P-404-8.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F74,2,SUMPRODUCT(IF($B$3:$B$100=B74,1,0),IF($F$3:$F$100<=F74,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B74,1,0),IF($F$3:$F$100<=F74,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G74=\"\",1,G74)*H74/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[73,"TNP-401-8.1-a","Asphalt Surface Course (TDOT D Mix, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F75,2,SUMPRODUCT(IF($B$3:$B$100=B75,1,0),IF($F$3:$F$100<=F75,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B75,1,0),IF($F$3:$F$100<=F75,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G75=\"\",1,G75)*H75/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[74,"TNP-401-8.1-b","Asphalt Surface Course (TDOT D Mix, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F76,2,SUMPRODUCT(IF($B$3:$B$100=B76,1,0),IF($F$3:$F$100<=F76,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B76,1,0),IF($F$3:$F$100<=F76,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G76=\"\",1,G76)*H76/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[75,"TNP-401-8.1-c","Asphalt Surface Course (TDOT D Mix, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.1-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F77,2,SUMPRODUCT(IF($B$3:$B$100=B77,1,0),IF($F$3:$F$100<=F77,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B77,1,0),IF($F$3:$F$100<=F77,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G77=\"\",1,G77)*H77/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[76,"TNP-401-8.1-d","Asphalt Surface Course (TDOT D Mix, PG 82-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.1-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F78,2,SUMPRODUCT(IF($B$3:$B$100=B78,1,0),IF($F$3:$F$100<=F78,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B78,1,0),IF($F$3:$F$100<=F78,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G78=\"\",1,G78)*H78/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[77,"TNP-401-8.1-e","Asphalt Surface Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.1-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F79,2,SUMPRODUCT(IF($B$3:$B$100=B79,1,0),IF($F$3:$F$100<=F79,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B79,1,0),IF($F$3:$F$100<=F79,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G79=\"\",1,G79)*H79/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[78,"TNP-401-8.2-a","Asphalt Binder Course (TDOT BM2 Mix, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F80,2,SUMPRODUCT(IF($B$3:$B$100=B80,1,0),IF($F$3:$F$100<=F80,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B80,1,0),IF($F$3:$F$100<=F80,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G80=\"\",1,G80)*H80/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[79,"TNP-401-8.2-b","Asphalt Binder Course (TDOT BM2 Mix, PG 70-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.2-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F81,2,SUMPRODUCT(IF($B$3:$B$100=B81,1,0),IF($F$3:$F$100<=F81,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B81,1,0),IF($F$3:$F$100<=F81,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G81=\"\",1,G81)*H81/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[80,"TNP-401-8.2-c","Asphalt Binder Course (TDOT BM2 Mix, PG 76-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.2-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F82,2,SUMPRODUCT(IF($B$3:$B$100=B82,1,0),IF($F$3:$F$100<=F82,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B82,1,0),IF($F$3:$F$100<=F82,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G82=\"\",1,G82)*H82/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[81,"TNP-401-8.2-d","Asphalt Binder Course (TDOT BM2 Mix, PG 82-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.2-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F83,2,SUMPRODUCT(IF($B$3:$B$100=B83,1,0),IF($F$3:$F$100<=F83,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B83,1,0),IF($F$3:$F$100<=F83,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G83=\"\",1,G83)*H83/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[82,"TNP-401-8.2-e","Asphalt Binder Course (Desc.)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.2-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F84,2,SUMPRODUCT(IF($B$3:$B$100=B84,1,0),IF($F$3:$F$100<=F84,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B84,1,0),IF($F$3:$F$100<=F84,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G84=\"\",1,G84)*H84/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[83,"TNP-401-8.2-g","Asphalt Binder Course (TDOT BM2 Mix, PG 64-22)","FAA Flexible Pavements","Virgin","N/A",null,null,100,"TNP-401-8.2-gN/A",{"$f":"IFERROR(_xlfn.SWITCH(F85,2,SUMPRODUCT(IF($B$3:$B$100=B85,1,0),IF($F$3:$F$100<=F85,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B85,1,0),IF($F$3:$F$100<=F85,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G85=\"\",1,G85)*H85/2000),\"N/A\")","v":0},0,"N/A","N/A"]
[84,"TNP-209-5.1-a","Crushed Aggregate Base Course Type A Grading D","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","TNP-209-5.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F86,2,SUMPRODUCT(IF($B$3:$B$100=B86,1,0),IF($F$3:$F$100<=F86,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B86,1,0),IF($F$3:$F$100<=F86,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G86=\"\",1,G86)*H86/2000),\"N/A\")","v":"N/A"},"N/A",0.79,"Ton"]
[85,"TNP-209-5.1-b","Crushed Aggregate Base Course FAA P-209 Grading ","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","TNP-209-5.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F87,2,SUMPRODUCT(IF($B$3:$B$100=B87,1,0),IF($F$3:$F$100<=F87,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B87,1,0),IF($F$3:$F$100<=F87,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G87=\"\",1,G87)*H87/2000),\"N/A\")","v":"N/A"},"N/A",0.79,"Ton"]
[86,"P-207-5.1-a","In-Place Full Depth Reclamation (FDR) Recycled Asphalt Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F88,2,SUMPRODUCT(IF($B$3:$B$100=B88,1,0),IF($F$3:$F$100<=F88,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B88,1,0),IF($F$3:$F$100<=F88,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G88=\"\",1,G88)*H88/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[87,"P-207-5.1-b","12\" Depth Fdr Cement Treated Base","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",{"$f":"_xlfn.CONCAT(B89,F89)","v":"P-207-5.1-bN/A"},{"$f":"IFERROR(_xlfn.SWITCH(F89,2,SUMPRODUCT(IF($B$3:$B$100=B89,1,0),IF($F$3:$F$100<=F89,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B89,1,0),IF($F$3:$F$100<=F89,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G89=\"\",1,G89)*H89/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H89/2000,\"N/A\")","v":"N/A"},0.1,"Square Yard"]
[88,"P-207-5.1-c","In-Place Full Depth Recycled (FDR) Asphalt Aggregate Base Course (12 Inch Min. Pulverization Depth, Excavation to Grade, 5 Inch Min. FDR Layer Depth) for","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.1-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F90,2,SUMPRODUCT(IF($B$3:$B$100=B90,1,0),IF($F$3:$F$100<=F90,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B90,1,0),IF($F$3:$F$100<=F90,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G90=\"\",1,G90)*H90/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[89,"P-207-5.1-d","In-Place Full Depth Reclamation (FDR) Recycled Asphalt Aggregate Base Course (5\" - 12\" Depth)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.1-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F91,2,SUMPRODUCT(IF($B$3:$B$100=B91,1,0),IF($F$3:$F$100<=F91,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B91,1,0),IF($F$3:$F$100<=F91,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G91=\"\",1,G91)*H91/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[90,"P-207-5.1-e","In-Place Full Depth Reclamation (FDR) Recycled Asphalt Aggregate Base Course (8\" - 14\" Depth)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.1-eN/A",{"$f":"IFERROR(_xlfn.SWITCH(F92,2,SUMPRODUCT(IF($B$3:$B$100=B92,1,0),IF($F$3:$F$100<=F92,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B92,1,0),IF($F$3:$F$100<=F92,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G92=\"\",1,G92)*H92/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[91,"P-207-5.1-f","In-Place Full Depth Reclamation (FDR) Asphalt Aggregate Base Course (16 Inch Min. Pulverization Depth, Excavated to Grade, 12 Inch Min. Mix Depth)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.1-fN/A",{"$f":"IFERROR(_xlfn.SWITCH(F93,2,SUMPRODUCT(IF($B$3:$B$100=B93,1,0),IF($F$3:$F$100<=F93,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B93,1,0),IF($F$3:$F$100<=F93,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G93=\"\",1,G93)*H93/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[92,"P-207-5.1-g","In-Place Full Depth Recycled (FDR) Asphalt Aggregate Base Course (12 Inch Min. Pulverization Depth, Excavation to Grade, 7 Inch Min. FDR Layer Depth) for","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.1-gN/A",{"$f":"IFERROR(_xlfn.SWITCH(F94,2,SUMPRODUCT(IF($B$3:$B$100=B94,1,0),IF($F$3:$F$100<=F94,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B94,1,0),IF($F$3:$F$100<=F94,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G94=\"\",1,G94)*H94/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[93,"P-207-5.2-a","Cement (Full Depth Reclamation)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.2-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F95,2,SUMPRODUCT(IF($B$3:$B$100=B95,1,0),IF($F$3:$F$100<=F95,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B95,1,0),IF($F$3:$F$100<=F95,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G95=\"\",1,G95)*H95/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[94,"P-207-5.2-b","Corrective Aggregate (Full Depth Reclamation)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.2-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F96,2,SUMPRODUCT(IF($B$3:$B$100=B96,1,0),IF($F$3:$F$100<=F96,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B96,1,0),IF($F$3:$F$100<=F96,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G96=\"\",1,G96)*H96/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[95,"P-207-5.2-c","Corrective Aggregate (Full Depth Reclamation)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.2-cN/A",{"$f":"IFERROR(_xlfn.SWITCH(F97,2,SUMPRODUCT(IF($B$3:$B$100=B97,1,0),IF($F$3:$F$100<=F97,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B97,1,0),IF($F$3:$F$100<=F97,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G97=\"\",1,G97)*H97/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[96,"P-207-5.2-d","Stockpiled FDR Base Course Material (Hauled Offsite)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-207-5.2-dN/A",{"$f":"IFERROR(_xlfn.SWITCH(F98,2,SUMPRODUCT(IF($B$3:$B$100=B98,1,0),IF($F$3:$F$100<=F98,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B98,1,0),IF($F$3:$F$100<=F98,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G98=\"\",1,G98)*H98/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[97,"P-208-5.1-a","Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-208-5.1-aN/A",{"$f":"IFERROR(_xlfn.SWITCH(F99,2,SUMPRODUCT(IF($B$3:$B$100=B99,1,0),IF($F$3:$F$100<=F99,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B99,1,0),IF($F$3:$F$100<=F99,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G99=\"\",1,G99)*H99/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[98,"P-208-5.1-b","Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A","P-208-5.1-bN/A",{"$f":"IFERROR(_xlfn.SWITCH(F100,2,SUMPRODUCT(IF($B$3:$B$100=B100,1,0),IF($F$3:$F$100<=F100,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B100,1,0),IF($F$3:$F$100<=F100,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G100=\"\",1,G100)*H100/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[99,"P-209-5.1-a","Crushed Aggregate Base Course (6\" Depth)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F101,2,SUMPRODUCT(IF($B$3:$B$100=B101,1,0),IF($F$3:$F$100<=F101,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B101,1,0),IF($F$3:$F$100<=F101,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G101=\"\",1,G101)*H101/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H101/2000,\"N/A\")","v":"N/A"},0.1,"Square Yard"]
[100,"P-209-5.1-b","Crushed Aggregate Base Course (6\" Depth) (For Poor Subgrade Areas)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F102,2,SUMPRODUCT(IF($B$3:$B$100=B102,1,0),IF($F$3:$F$100<=F102,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B102,1,0),IF($F$3:$F$100<=F102,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G102=\"\",1,G102)*H102/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[101,"P-209-5.1-c","Crushed Aggregate Base Course Full Strength (12.5 in)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F103,2,SUMPRODUCT(IF($B$3:$B$100=B103,1,0),IF($F$3:$F$100<=F103,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B103,1,0),IF($F$3:$F$100<=F103,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G103=\"\",1,G103)*H103/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[102,"P-209-5.1-d","Crushed Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F104,2,SUMPRODUCT(IF($B$3:$B$100=B104,1,0),IF($F$3:$F$100<=F104,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B104,1,0),IF($F$3:$F$100<=F104,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G104=\"\",1,G104)*H104/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[103,"P-209-5.1-e","Crushed Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F105,2,SUMPRODUCT(IF($B$3:$B$100=B105,1,0),IF($F$3:$F$100<=F105,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B105,1,0),IF($F$3:$F$100<=F105,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G105=\"\",1,G105)*H105/2000),\"N/A\")","v":"N/A"},"N/A",0.79,"Ton"]
[104,"P-210-5.1-a","Caliche Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F106,2,SUMPRODUCT(IF($B$3:$B$100=B106,1,0),IF($F$3:$F$100<=F106,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B106,1,0),IF($F$3:$F$100<=F106,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G106=\"\",1,G106)*H106/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[105,"P-210-5.1-b","Caliche Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F107,2,SUMPRODUCT(IF($B$3:$B$100=B107,1,0),IF($F$3:$F$100<=F107,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B107,1,0),IF($F$3:$F$100<=F107,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G107=\"\",1,G107)*H107/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[106,"P-211-5.1-a","Lime Rock Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F108,2,SUMPRODUCT(IF($B$3:$B$100=B108,1,0),IF($F$3:$F$100<=F108,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B108,1,0),IF($F$3:$F$100<=F108,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G108=\"\",1,G108)*H108/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[107,"P-211-5.1-b","Lime Rock Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F109,2,SUMPRODUCT(IF($B$3:$B$100=B109,1,0),IF($F$3:$F$100<=F109,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B109,1,0),IF($F$3:$F$100<=F109,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G109=\"\",1,G109)*H109/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[108,"P-213-5.1-a","Sand-Clay Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F110,2,SUMPRODUCT(IF($B$3:$B$100=B110,1,0),IF($F$3:$F$100<=F110,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B110,1,0),IF($F$3:$F$100<=F110,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G110=\"\",1,G110)*H110/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[109,"P-213-5.1-b","Sand-Clay Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F111,2,SUMPRODUCT(IF($B$3:$B$100=B111,1,0),IF($F$3:$F$100<=F111,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B111,1,0),IF($F$3:$F$100<=F111,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G111=\"\",1,G111)*H111/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[110,"P-217-5.1-a","Soil Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F112,2,SUMPRODUCT(IF($B$3:$B$100=B112,1,0),IF($F$3:$F$100<=F112,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B112,1,0),IF($F$3:$F$100<=F112,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G112=\"\",1,G112)*H112/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[111,"P-217-5.1-b","Soil Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F113,2,SUMPRODUCT(IF($B$3:$B$100=B113,1,0),IF($F$3:$F$100<=F113,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B113,1,0),IF($F$3:$F$100<=F113,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G113=\"\",1,G113)*H113/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[112,"P-217-5.2-a","Stabilizer Aggregate","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F114,2,SUMPRODUCT(IF($B$3:$B$100=B114,1,0),IF($F$3:$F$100<=F114,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B114,1,0),IF($F$3:$F$100<=F114,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G114=\"\",1,G114)*H114/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H114/2000,\"N/A\")","v":"N/A"},0.25,"Cubic Yard"]
[113,"P-217-5.2-b","Stabilizer Aggregate","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F115,2,SUMPRODUCT(IF($B$3:$B$100=B115,1,0),IF($F$3:$F$100<=F115,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B115,1,0),IF($F$3:$F$100<=F115,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G115=\"\",1,G115)*H115/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[114,"P-217-5.3-a","Conditioning Operation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F116,2,SUMPRODUCT(IF($B$3:$B$100=B116,1,0),IF($F$3:$F$100<=F116,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B116,1,0),IF($F$3:$F$100<=F116,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G116=\"\",1,G116)*H116/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[115,"P-219-5.1-a","Recycled Concrete Aggregate Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F117,2,SUMPRODUCT(IF($B$3:$B$100=B117,1,0),IF($F$3:$F$100<=F117,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B117,1,0),IF($F$3:$F$100<=F117,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G117=\"\",1,G117)*H117/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[116,"P-220-6.1-a","Cement treated soil Base Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F118,2,SUMPRODUCT(IF($B$3:$B$100=B118,1,0),IF($F$3:$F$100<=F118,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B118,1,0),IF($F$3:$F$100<=F118,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G118=\"\",1,G118)*H118/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[117,"P-220-6.2-a","Cement (Treated soil Base Course)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F119,2,SUMPRODUCT(IF($B$3:$B$100=B119,1,0),IF($F$3:$F$100<=F119,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B119,1,0),IF($F$3:$F$100<=F119,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G119=\"\",1,G119)*H119/2000),\"N/A\")","v":"N/A"},"N/A",0.79,"Ton"]
[118,"P-304-8.1-a","Cement-treated base course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F120,2,SUMPRODUCT(IF($B$3:$B$100=B120,1,0),IF($F$3:$F$100<=F120,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B120,1,0),IF($F$3:$F$100<=F120,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G120=\"\",1,G120)*H120/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[119,"P-306-8.1-a","Lean concrete base course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F121,2,SUMPRODUCT(IF($B$3:$B$100=B121,1,0),IF($F$3:$F$100<=F121,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B121,1,0),IF($F$3:$F$100<=F121,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G121=\"\",1,G121)*H121/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[120,"P-501-8.1-a","Concrete Pavement (Plain)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F122,2,SUMPRODUCT(IF($B$3:$B$100=B122,1,0),IF($F$3:$F$100<=F122,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B122,1,0),IF($F$3:$F$100<=F122,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G122=\"\",1,G122)*H122/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H122/2000,\"N/A\")","v":"N/A"},0.9,"Cubic Yard"]
[121,"P-501-8.1-b","Concrete Pavement (Reinforced)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F123,2,SUMPRODUCT(IF($B$3:$B$100=B123,1,0),IF($F$3:$F$100<=F123,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B123,1,0),IF($F$3:$F$100<=F123,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G123=\"\",1,G123)*H123/2000),\"N/A\")","v":"N/A"},"N/A",0.9,"Cubic Yard"]
[122,"P-501-8.2-a","Concrete Pavement (Plain, Thickness 1)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F124,2,SUMPRODUCT(IF($B$3:$B$100=B124,1,0),IF($F$3:$F$100<=F124,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B124,1,0),IF($F$3:$F$100<=F124,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G124=\"\",1,G124)*H124/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[123,"P-501-8.2-b","Concrete Pavement (Reinforced, Thickness 1)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F125,2,SUMPRODUCT(IF($B$3:$B$100=B125,1,0),IF($F$3:$F$100<=F125,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B125,1,0),IF($F$3:$F$100<=F125,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G125=\"\",1,G125)*H125/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[124,"P-501-8.2-c","Concrete Pavement (Plain, 5 in. minimum)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F126,2,SUMPRODUCT(IF($B$3:$B$100=B126,1,0),IF($F$3:$F$100<=F126,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B126,1,0),IF($F$3:$F$100<=F126,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G126=\"\",1,G126)*H126/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[125,"P-501-8.2-d","Concrete Pavement (Plain, 7 in. minimum)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F127,2,SUMPRODUCT(IF($B$3:$B$100=B127,1,0),IF($F$3:$F$100<=F127,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B127,1,0),IF($F$3:$F$100<=F127,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G127=\"\",1,G127)*H127/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[126,"P-501-8.2-e","Concrete Pavement (Plain, 6 in. Thickness)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F128,2,SUMPRODUCT(IF($B$3:$B$100=B128,1,0),IF($F$3:$F$100<=F128,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B128,1,0),IF($F$3:$F$100<=F128,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G128=\"\",1,G128)*H128/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[127,"P-501-8.2-f","Concrete Pavement (Plain, 8 in. Thickness)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F129,2,SUMPRODUCT(IF($B$3:$B$100=B129,1,0),IF($F$3:$F$100<=F129,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B129,1,0),IF($F$3:$F$100<=F129,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G129=\"\",1,G129)*H129/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[128,"P-501-8.2-g","Concrete Pavement (Plain, 10 in. Thickness)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F130,2,SUMPRODUCT(IF($B$3:$B$100=B130,1,0),IF($F$3:$F$100<=F130,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B130,1,0),IF($F$3:$F$100<=F130,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G130=\"\",1,G130)*H130/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Square Yard"]
[129,"P-501-8.2-h","Concrete Pavement (Plain, 12 in. Thickness)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F131,2,SUMPRODUCT(IF($B$3:$B$100=B131,1,0),IF($F$3:$F$100<=F131,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B131,1,0),IF($F$3:$F$100<=F131,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G131=\"\",1,G131)*H131/2000),\"N/A\")","v":"N/A"},"N/A",0.3,"Square Yard"]
[130,"P-154-5.1-a","Subbase Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F132,2,SUMPRODUCT(IF($B$3:$B$100=B132,1,0),IF($F$3:$F$100<=F132,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B132,1,0),IF($F$3:$F$100<=F132,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G132=\"\",1,G132)*H132/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H132/2000,\"N/A\")","v":"N/A"},0.25,"Cubic Yard"]
[131,"P-154-5.1-b","Subbase Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F133,2,SUMPRODUCT(IF($B$3:$B$100=B133,1,0),IF($F$3:$F$100<=F133,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B133,1,0),IF($F$3:$F$100<=F133,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G133=\"\",1,G133)*H133/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[132,"P-155-8.1-a","Lime Treated subgrade","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F134,2,SUMPRODUCT(IF($B$3:$B$100=B134,1,0),IF($F$3:$F$100<=F134,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B134,1,0),IF($F$3:$F$100<=F134,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G134=\"\",1,G134)*H134/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[133,"P-156-8.1-a","Cement treated subgrade","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F135,2,SUMPRODUCT(IF($B$3:$B$100=B135,1,0),IF($F$3:$F$100<=F135,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B135,1,0),IF($F$3:$F$100<=F135,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G135=\"\",1,G135)*H135/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[134,"P-157-8.1-a","Kiln dust treated subgrade","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F136,2,SUMPRODUCT(IF($B$3:$B$100=B136,1,0),IF($F$3:$F$100<=F136,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B136,1,0),IF($F$3:$F$100<=F136,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G136=\"\",1,G136)*H136/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[135,"P-158-8.1-a","Fly ash treated subgrade","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F137,2,SUMPRODUCT(IF($B$3:$B$100=B137,1,0),IF($F$3:$F$100<=F137,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B137,1,0),IF($F$3:$F$100<=F137,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G137=\"\",1,G137)*H137/2000),\"N/A\")","v":"N/A"},"N/A",0.1,"Square Yard"]
[136,"P-152-4.1-a","Unclassified Excavation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F138,2,SUMPRODUCT(IF($B$3:$B$100=B138,1,0),IF($F$3:$F$100<=F138,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B138,1,0),IF($F$3:$F$100<=F138,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G138=\"\",1,G138)*H138/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H138/2000,\"N/A\")","v":"N/A"},0.25,"Cubic Yard"]
[137,"P-152-4.1-b","Rock Excavation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F139,2,SUMPRODUCT(IF($B$3:$B$100=B139,1,0),IF($F$3:$F$100<=F139,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B139,1,0),IF($F$3:$F$100<=F139,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G139=\"\",1,G139)*H139/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[138,"P-152-4.1-c","Muck Excavation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F140,2,SUMPRODUCT(IF($B$3:$B$100=B140,1,0),IF($F$3:$F$100<=F140,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B140,1,0),IF($F$3:$F$100<=F140,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G140=\"\",1,G140)*H140/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[139,"P-152-4.1-d","Borrow Excavation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F141,2,SUMPRODUCT(IF($B$3:$B$100=B141,1,0),IF($F$3:$F$100<=F141,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B141,1,0),IF($F$3:$F$100<=F141,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G141=\"\",1,G141)*H141/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[140,"P-152-4.1-e","Drainage Excavation","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F142,2,SUMPRODUCT(IF($B$3:$B$100=B142,1,0),IF($F$3:$F$100<=F142,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B142,1,0),IF($F$3:$F$100<=F142,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G142=\"\",1,G142)*H142/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[141,"P-152-4.2-a","Embankment in Place","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F143,2,SUMPRODUCT(IF($B$3:$B$100=B143,1,0),IF($F$3:$F$100<=F143,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B143,1,0),IF($F$3:$F$100<=F143,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G143=\"\",1,G143)*H143/2000),\"N/A\")","v":"N/A"},"N/A",0.25,"Cubic Yard"]
[142,"P-152-4.2-b","Embankment in Place (Shot Rock)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F144,2,SUMPRODUCT(IF($B$3:$B$100=B144,1,0),IF($F$3:$F$100<=F144,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B144,1,0),IF($F$3:$F$100<=F144,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G144=\"\",1,G144)*H144/2000),\"N/A\")","v":"N/A"},"N/A",0.11,"Ton"]
[143,"P-401-8.1-a","Asphalt Surface Course (Gradation 1, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F145,2,SUMPRODUCT(IF($B$3:$B$100=B145,1,0),IF($F$3:$F$100<=F145,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B145,1,0),IF($F$3:$F$100<=F145,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G145=\"\",1,G145)*H145/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H145/2000,\"N/A\")","v":"N/A"},2.98,"Ton"]
[144,"P-401-8.1-b","Asphalt Surface Course (Gradation 1, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F146,2,SUMPRODUCT(IF($B$3:$B$100=B146,1,0),IF($F$3:$F$100<=F146,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B146,1,0),IF($F$3:$F$100<=F146,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G146=\"\",1,G146)*H146/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[145,"P-401-8.1-c","Asphalt Surface Course (Gradation 1, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F147,2,SUMPRODUCT(IF($B$3:$B$100=B147,1,0),IF($F$3:$F$100<=F147,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B147,1,0),IF($F$3:$F$100<=F147,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G147=\"\",1,G147)*H147/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[146,"P-401-8.1-d","Asphalt Surface Course (Gradation 2, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F148,2,SUMPRODUCT(IF($B$3:$B$100=B148,1,0),IF($F$3:$F$100<=F148,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B148,1,0),IF($F$3:$F$100<=F148,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G148=\"\",1,G148)*H148/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[147,"P-401-8.1-e","Asphalt Surface Course (Gradation 2, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F149,2,SUMPRODUCT(IF($B$3:$B$100=B149,1,0),IF($F$3:$F$100<=F149,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B149,1,0),IF($F$3:$F$100<=F149,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G149=\"\",1,G149)*H149/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[148,"P-401-8.1-f","Asphalt Surface Course (Gradation 2, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F150,2,SUMPRODUCT(IF($B$3:$B$100=B150,1,0),IF($F$3:$F$100<=F150,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B150,1,0),IF($F$3:$F$100<=F150,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G150=\"\",1,G150)*H150/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[149,"P-401-8.1-g","Asphalt Surface Course (Gradation 2, PG 82-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F151,2,SUMPRODUCT(IF($B$3:$B$100=B151,1,0),IF($F$3:$F$100<=F151,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B151,1,0),IF($F$3:$F$100<=F151,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G151=\"\",1,G151)*H151/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[150,"P-401-8.1-h","Asphalt Surface Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F152,2,SUMPRODUCT(IF($B$3:$B$100=B152,1,0),IF($F$3:$F$100<=F152,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B152,1,0),IF($F$3:$F$100<=F152,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G152=\"\",1,G152)*H152/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[151,"P-401-8.2-a","Asphalt Base Course (Thickness 1, Gradation 1, Binder Grade 1)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F153,2,SUMPRODUCT(IF($B$3:$B$100=B153,1,0),IF($F$3:$F$100<=F153,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B153,1,0),IF($F$3:$F$100<=F153,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G153=\"\",1,G153)*H153/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[152,"P-401-8.3-a","Asphalt Binder Course  (Thickness 1, Gradation 1, Binder Grade 1)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F154,2,SUMPRODUCT(IF($B$3:$B$100=B154,1,0),IF($F$3:$F$100<=F154,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B154,1,0),IF($F$3:$F$100<=F154,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G154=\"\",1,G154)*H154/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[153,"P-401-8.4-a","Asphalt Levelling Course  (Thickness 1, Gradation 1, Binder Grade 1)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F155,2,SUMPRODUCT(IF($B$3:$B$100=B155,1,0),IF($F$3:$F$100<=F155,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B155,1,0),IF($F$3:$F$100<=F155,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G155=\"\",1,G155)*H155/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[154,"P-403-8.1-a","Asphalt Surface Course (Gradation 1, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F156,2,SUMPRODUCT(IF($B$3:$B$100=B156,1,0),IF($F$3:$F$100<=F156,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B156,1,0),IF($F$3:$F$100<=F156,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G156=\"\",1,G156)*H156/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[155,"P-403-8.1-b","Asphalt Surface Course (Gradation 1, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F157,2,SUMPRODUCT(IF($B$3:$B$100=B157,1,0),IF($F$3:$F$100<=F157,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B157,1,0),IF($F$3:$F$100<=F157,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G157=\"\",1,G157)*H157/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[156,"P-403-8.1-c","Asphalt Surface Course (Gradation 1, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F158,2,SUMPRODUCT(IF($B$3:$B$100=B158,1,0),IF($F$3:$F$100<=F158,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B158,1,0),IF($F$3:$F$100<=F158,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G158=\"\",1,G158)*H158/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[157,"P-403-8.1-d","Asphalt Surface Course (Gradation 2, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F159,2,SUMPRODUCT(IF($B$3:$B$100=B159,1,0),IF($F$3:$F$100<=F159,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B159,1,0),IF($F$3:$F$100<=F159,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G159=\"\",1,G159)*H159/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[158,"P-403-8.1-e","Asphalt Surface Course (Gradation 2, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F160,2,SUMPRODUCT(IF($B$3:$B$100=B160,1,0),IF($F$3:$F$100<=F160,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B160,1,0),IF($F$3:$F$100<=F160,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G160=\"\",1,G160)*H160/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[159,"P-403-8.1-f","Asphalt Surface Course (Gradation 2, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F161,2,SUMPRODUCT(IF($B$3:$B$100=B161,1,0),IF($F$3:$F$100<=F161,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B161,1,0),IF($F$3:$F$100<=F161,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G161=\"\",1,G161)*H161/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[160,"P-403-8.1-g","Asphalt Surface Course (Gradation 2, PG 82-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F162,2,SUMPRODUCT(IF($B$3:$B$100=B162,1,0),IF($F$3:$F$100<=F162,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B162,1,0),IF($F$3:$F$100<=F162,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G162=\"\",1,G162)*H162/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[161,"P-403-8.1-h","Asphalt Surface Course (Desc)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F163,2,SUMPRODUCT(IF($B$3:$B$100=B163,1,0),IF($F$3:$F$100<=F163,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B163,1,0),IF($F$3:$F$100<=F163,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G163=\"\",1,G163)*H163/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[162,"P-403-8.1-i","Asphalt Surface Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F164,2,SUMPRODUCT(IF($B$3:$B$100=B164,1,0),IF($F$3:$F$100<=F164,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B164,1,0),IF($F$3:$F$100<=F164,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G164=\"\",1,G164)*H164/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[163,"P-403-8.2-a","Asphalt Base Course (Gradation 1, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F165,2,SUMPRODUCT(IF($B$3:$B$100=B165,1,0),IF($F$3:$F$100<=F165,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B165,1,0),IF($F$3:$F$100<=F165,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G165=\"\",1,G165)*H165/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[164,"P-403-8.2-b","Asphalt Base Course (Gradation 1, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F166,2,SUMPRODUCT(IF($B$3:$B$100=B166,1,0),IF($F$3:$F$100<=F166,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B166,1,0),IF($F$3:$F$100<=F166,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G166=\"\",1,G166)*H166/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[165,"P-403-8.2-c","Asphalt Base Course (Gradation 1, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F167,2,SUMPRODUCT(IF($B$3:$B$100=B167,1,0),IF($F$3:$F$100<=F167,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B167,1,0),IF($F$3:$F$100<=F167,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G167=\"\",1,G167)*H167/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[166,"P-403-8.2-d","Asphalt Base Course (Gradation 2, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F168,2,SUMPRODUCT(IF($B$3:$B$100=B168,1,0),IF($F$3:$F$100<=F168,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B168,1,0),IF($F$3:$F$100<=F168,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G168=\"\",1,G168)*H168/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[167,"P-403-8.2-e","Asphalt Base Course (Gradation 2, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F169,2,SUMPRODUCT(IF($B$3:$B$100=B169,1,0),IF($F$3:$F$100<=F169,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B169,1,0),IF($F$3:$F$100<=F169,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G169=\"\",1,G169)*H169/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[168,"P-403-8.2-f","Asphalt Base Course (Gradation 2, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F170,2,SUMPRODUCT(IF($B$3:$B$100=B170,1,0),IF($F$3:$F$100<=F170,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B170,1,0),IF($F$3:$F$100<=F170,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G170=\"\",1,G170)*H170/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[169,"P-403-8.2-g","Asphalt Base Course (Gradation 2, PG 82-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F171,2,SUMPRODUCT(IF($B$3:$B$100=B171,1,0),IF($F$3:$F$100<=F171,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B171,1,0),IF($F$3:$F$100<=F171,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G171=\"\",1,G171)*H171/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[170,"P-403-8.2-h","Asphalt Base Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F172,2,SUMPRODUCT(IF($B$3:$B$100=B172,1,0),IF($F$3:$F$100<=F172,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B172,1,0),IF($F$3:$F$100<=F172,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G172=\"\",1,G172)*H172/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[171,"P-403-8.2-i","Asphalt Base Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F173,2,SUMPRODUCT(IF($B$3:$B$100=B173,1,0),IF($F$3:$F$100<=F173,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B173,1,0),IF($F$3:$F$100<=F173,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G173=\"\",1,G173)*H173/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[172,"P-403-8.3-a","Asphalt Binder Course (Gradation 1, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F174,2,SUMPRODUCT(IF($B$3:$B$100=B174,1,0),IF($F$3:$F$100<=F174,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B174,1,0),IF($F$3:$F$100<=F174,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G174=\"\",1,G174)*H174/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[173,"P-403-8.3-b","Asphalt Binder Course (Gradation 1, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F175,2,SUMPRODUCT(IF($B$3:$B$100=B175,1,0),IF($F$3:$F$100<=F175,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B175,1,0),IF($F$3:$F$100<=F175,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G175=\"\",1,G175)*H175/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[174,"P-403-8.3-c","Asphalt Binder Course (Gradation 1, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F176,2,SUMPRODUCT(IF($B$3:$B$100=B176,1,0),IF($F$3:$F$100<=F176,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B176,1,0),IF($F$3:$F$100<=F176,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G176=\"\",1,G176)*H176/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[175,"P-403-8.3-d","Asphalt Binder Course (Gradation 2, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F177,2,SUMPRODUCT(IF($B$3:$B$100=B177,1,0),IF($F$3:$F$100<=F177,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B177,1,0),IF($F$3:$F$100<=F177,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G177=\"\",1,G177)*H177/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[176,"P-403-8.3-e","Asphalt Binder Course (Gradation 2, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F178,2,SUMPRODUCT(IF($B$3:$B$100=B178,1,0),IF($F$3:$F$100<=F178,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B178,1,0),IF($F$3:$F$100<=F178,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G178=\"\",1,G178)*H178/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[177,"P-403-8.3-f","Asphalt Binder Course (Gradation 2, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F179,2,SUMPRODUCT(IF($B$3:$B$100=B179,1,0),IF($F$3:$F$100<=F179,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B179,1,0),IF($F$3:$F$100<=F179,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G179=\"\",1,G179)*H179/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[178,"P-403-8.3-g","Asphalt Binder Course (Gradation 2, PG 82-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F180,2,SUMPRODUCT(IF($B$3:$B$100=B180,1,0),IF($F$3:$F$100<=F180,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B180,1,0),IF($F$3:$F$100<=F180,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G180=\"\",1,G180)*H180/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[179,"P-403-8.3-h","Asphalt Binder Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F181,2,SUMPRODUCT(IF($B$3:$B$100=B181,1,0),IF($F$3:$F$100<=F181,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B181,1,0),IF($F$3:$F$100<=F181,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G181=\"\",1,G181)*H181/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[180,"P-403-8.3-i","Asphalt Binder Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F182,2,SUMPRODUCT(IF($B$3:$B$100=B182,1,0),IF($F$3:$F$100<=F182,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B182,1,0),IF($F$3:$F$100<=F182,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G182=\"\",1,G182)*H182/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[181,"P-403-8.4-a","Asphalt Levelling Course  (Thickness 1, Gradation 1, Binder Grade 1)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F183,2,SUMPRODUCT(IF($B$3:$B$100=B183,1,0),IF($F$3:$F$100<=F183,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B183,1,0),IF($F$3:$F$100<=F183,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G183=\"\",1,G183)*H183/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[182,"P-404-8.1-a","Fuel Resistant Asphalt Mix Pavement Surface Course","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F184,2,SUMPRODUCT(IF($B$3:$B$100=B184,1,0),IF($F$3:$F$100<=F184,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B184,1,0),IF($F$3:$F$100<=F184,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G184=\"\",1,G184)*H184/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[183,"TNP-401-8.1-a","Asphalt Surface Course (TDOT D Mix, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F185,2,SUMPRODUCT(IF($B$3:$B$100=B185,1,0),IF($F$3:$F$100<=F185,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B185,1,0),IF($F$3:$F$100<=F185,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G185=\"\",1,G185)*H185/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[184,"TNP-401-8.1-b","Asphalt Surface Course (TDOT D Mix, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F186,2,SUMPRODUCT(IF($B$3:$B$100=B186,1,0),IF($F$3:$F$100<=F186,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B186,1,0),IF($F$3:$F$100<=F186,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G186=\"\",1,G186)*H186/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[185,"TNP-401-8.1-c","Asphalt Surface Course (TDOT D Mix, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F187,2,SUMPRODUCT(IF($B$3:$B$100=B187,1,0),IF($F$3:$F$100<=F187,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B187,1,0),IF($F$3:$F$100<=F187,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G187=\"\",1,G187)*H187/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[186,"TNP-401-8.1-d","Asphalt Surface Course (TDOT D Mix, PG 82-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F188,2,SUMPRODUCT(IF($B$3:$B$100=B188,1,0),IF($F$3:$F$100<=F188,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B188,1,0),IF($F$3:$F$100<=F188,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G188=\"\",1,G188)*H188/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[187,"TNP-401-8.1-e","Asphalt Surface Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F189,2,SUMPRODUCT(IF($B$3:$B$100=B189,1,0),IF($F$3:$F$100<=F189,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B189,1,0),IF($F$3:$F$100<=F189,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G189=\"\",1,G189)*H189/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[188,"TNP-401-8.2-a","Asphalt Binder Course (TDOT BM2 Mix, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F190,2,SUMPRODUCT(IF($B$3:$B$100=B190,1,0),IF($F$3:$F$100<=F190,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B190,1,0),IF($F$3:$F$100<=F190,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G190=\"\",1,G190)*H190/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[189,"TNP-401-8.2-b","Asphalt Binder Course (TDOT BM2 Mix, PG 70-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F191,2,SUMPRODUCT(IF($B$3:$B$100=B191,1,0),IF($F$3:$F$100<=F191,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B191,1,0),IF($F$3:$F$100<=F191,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G191=\"\",1,G191)*H191/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[190,"TNP-401-8.2-c","Asphalt Binder Course (TDOT BM2 Mix, PG 76-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F192,2,SUMPRODUCT(IF($B$3:$B$100=B192,1,0),IF($F$3:$F$100<=F192,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B192,1,0),IF($F$3:$F$100<=F192,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G192=\"\",1,G192)*H192/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[191,"TNP-401-8.2-d","Asphalt Binder Course (TDOT BM2 Mix, PG 82-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F193,2,SUMPRODUCT(IF($B$3:$B$100=B193,1,0),IF($F$3:$F$100<=F193,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B193,1,0),IF($F$3:$F$100<=F193,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G193=\"\",1,G193)*H193/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[192,"TNP-401-8.2-e","Asphalt Binder Course (Desc.)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F194,2,SUMPRODUCT(IF($B$3:$B$100=B194,1,0),IF($F$3:$F$100<=F194,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B194,1,0),IF($F$3:$F$100<=F194,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G194=\"\",1,G194)*H194/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[193,"TNP-401-8.2-g","Asphalt Binder Course (TDOT BM2 Mix, PG 64-22)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F195,2,SUMPRODUCT(IF($B$3:$B$100=B195,1,0),IF($F$3:$F$100<=F195,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B195,1,0),IF($F$3:$F$100<=F195,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G195=\"\",1,G195)*H195/2000),\"N/A\")","v":"N/A"},"N/A",2.98,"Ton"]
[194,"P-153-6.1-a","Controlled low-strength material (CLSM)","Fuel Adjustment","N/A","N/A","N/A","N/A","N/A",null,{"$f":"IFERROR(_xlfn.SWITCH(F196,2,SUMPRODUCT(IF($B$3:$B$100=B196,1,0),IF($F$3:$F$100<=F196,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B196,1,0),IF($F$3:$F$100<=F196,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G196=\"\",1,G196)*H196/2000),\"N/A\")","v":"N/A"},{"$f":"IFERROR(H196/2000,\"N/A\")","v":"N/A"},0.25,"Cubic Yard"]
[195,"P-609-5.2-d","Emulsified Asphalt, Type 1 Chip Seal","FAA Surface Treatments","Virgin","N/A",0.45,9,69,2.0249999999999999E-3,{"$f":"IFERROR(_xlfn.SWITCH(F197,2,SUMPRODUCT(IF($B$3:$B$100=B197,1,0),IF($F$3:$F$100<=F197,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B197,1,0),IF($F$3:$F$100<=F197,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G197=\"\",1,G197)*H197/2000),\"N/A\")","v":2.0249999999999999E-3},4.4999999999999997E-3,"N/A","N/A"]
[196,"P-609-5.2-e","Emulsified Asphalt, Type 2 Chip Seal","FAA Surface Treatments","Virgin","N/A",0.28000000000000003,9,69,1.2600000000000003E-3,{"$f":"IFERROR(_xlfn.SWITCH(F198,2,SUMPRODUCT(IF($B$3:$B$100=B198,1,0),IF($F$3:$F$100<=F198,1,0),$G$3:$G$100,$H$3:$H$100)/2000,3,SUMPRODUCT(IF($B$3:$B$100=B198,1,0),IF($F$3:$F$100<=F198,1,0),$G$3:$G$100,$H$3:$H$100)/2000,IF(G198=\"\",1,G198)*H198/2000),\"N/A\")","v":1.2600000000000003E-3},4.4999999999999997E-3,"N/A","N/A"]
[197,"P-609-5.2-f","Emulsified Asphalt, Type 3 Chip Seal","FAA Surface Treatments","Virgin","N/A",0.18,9,69,8.0999999999999996E-4,4.4999999999999997E-3,{"$f":"IFERROR(H199/2000,\"N/A\")","v":4.4999999999999997E-3},"N/A","N/A"]

{"sheet":"Fuel Index Calculations","index":4,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,6,4,7],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[15,2,15,4],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[9,1,9,2],[10,3,10,4],[13,2,13,4],[14,2,14,4],[8,1,8,2],[26,2,26,5],[5,6,5,7],[5,1,5,2],[5,3,5,4],[6,6,6,7],[27,2,27,5],[42,1,42,9],[13,5,13,6],[14,5,14,6],[15,5,15,6],[8,3,8,4],[28,2,28,5],[29,2,29,5],[30,2,30,5],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[1,2,1,8],[2,1,2,4],[2,6,2,8],[9,6,9,7],[6,1,6,2],[6,3,6,4],[7,6,7,7],[7,1,7,2],[7,3,7,4],[8,6,8,7],[4,1,4,2],[4,3,4,4],[9,3,9,4],[3,1,3,2],[3,3,3,4],[3,6,3,7]]}
[]
[null,null,"TAD Fuel Price Adjustment Spreadsheet"]
[null,"Project Information",null,null,null,null,"Fuel Index"]
[null,"Project Title",null,{"$f":"'Project Information'!E5","v":0},null,null,"Base Bidding Date",null,{"$f":"'Project Information'!$E$12","v":"00:00:00"}]
[null,"TAD Proj. No.",null,{"$f":"'Project Information'!E6","v":0},null,null,"Fuel Price (Fp)",null,{"$f":"'Project Information'!$E$14","v":0}]
[null,"Airport ID",null,{"$f":"'Project Information'!E7","v":0},null,null,"Bidding Index (Ib)",null,{"$f":"'Project Information'!$E$13","v":0}]
[null,"Airport Name",null,{"$f":"'Project Information'!E8","v":0},null,null," Date Calculation Performed (i.e., Current Date)"]
[null,"County",null,{"$f":"'Project Information'!E9","v":0},null,null,"Fuel Index (Ic) for Fuel Index Month"]
[null,"Region",null,{"$f":"'Project Information'!E10","v":0},null,null,"Pay Estimate Number"]
[null,"Prime Contractor",null,{"$f":"'Project Information'!E11","v":0},null,null,"Percent Change",null,{"$f":"IF(I8=0,0,(I8/I6-1))","v":0}]
[]
[]
[]
[null,null,"Fuel Index Month"]
[null,null,"Total Fuel Payment Adjustment \n(Paid using item TNP-109-8.1a)",null,null,{"$f":"K43","v":0}]
[null,null,"Computed by"]
[]
[]
[null,"Payment Adjustment",null,null,null,null,null,null,null,null,"s","PA1 =[Ic-Ib]x T"]
[]
[]
[]
[null,"Item Number","Item Descriptions",null,null,null,"Fuel Factor","Unit of Measure","Quantity","Fe","Fuel Adjustment, $"]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B24='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B24='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B24='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,{"$f":"IFERROR($G24*$I24,0)","v":0},{"$f":"IFERROR(IF(ABS($I$10)<0.05,0,IF(ABS($I$10)>=0.05,(($I$8/$I$6-1)*J24*$I$5))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B25='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B25='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B25='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,{"$f":"IFERROR($G25*$I25,0)","v":0},{"$f":"IFERROR(IF(ABS($I$10)<0.05,0,IF(ABS($I$10)>=0.05,(($I$8/$I$6-1)*J25*$I$5))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B26='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B26='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B26='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B27='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B27='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B27='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B28='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B28='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B28='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B29='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B29='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B29='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B30='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B30='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B30='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B31='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B31='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B31='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B32='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B32='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B32='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B33='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B33='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B33='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B34='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B34='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B34='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B35='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B35='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B35='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B36='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B36='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B36='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B37='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B37='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B37='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B38='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B38='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B38='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B39='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B39='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B39='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B40='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B40='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B40='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B41='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B41='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B41='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,(B42='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$M$3:$M$491,MATCH(1,(B42='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$N$3:$N$491,MATCH(1,(B42='Item Lists'!$B$3:$B$491)*(\"N/A\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,0,0]
[null,"Total Fuel Adjustment , $",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,$K$24:$K$42)","v":0}]

{"sheet":"Bit Index Calculations","index":5,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,2,1,8],[2,6,2,8],[3,6,3,7],[4,6,4,7],[5,6,5,7],[2,1,2,4],[5,3,5,4],[4,3,4,4],[3,3,3,4],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,6,6,7],[8,6,8,7],[6,3,6,4],[7,3,7,4],[59,2,59,5],[24,2,24,5],[8,1,8,2],[9,1,9,2],[7,6,7,7],[8,3,8,4],[14,2,14,4],[14,5,14,6],[13,5,13,6],[26,2,26,5],[27,2,27,5],[28,2,28,5],[6,1,6,2],[7,1,7,2],[15,2,15,4],[69,1,69,4],[23,2,23,5],[60,2,60,5],[62,2,62,5],[29,2,29,5],[61,2,61,5],[30,2,30,5],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[15,5,15,6],[13,2,13,4],[25,2,25,5],[22,2,22,5],[9,3,9,4],[10,3,10,4]]}
[]
[null,null,"TAD Bituminous Materials Adjustment Spreadsheet"]
[null,"Project Information",null,null,null,null,"Bituminous Index"]
[null,"Project Title",null,{"$f":"'Project Information'!E5","v":0},null,null,"Base Bidding Date",null,{"$f":"'Project Information'!E12","v":"00:00:00"}]
[null,"TAD Proj. No.",null,{"$f":"'Project Information'!E6","v":0},null,null,"Bidding Index (Ib)",null,{"$f":"'Project Information'!E15","v":0}]
[null,"Airport ID",null,{"$f":"'Project Information'!E7","v":0},null,null," Date Calculation Performed (i.e., Current Date)"]
[null,"Airport Name",null,{"$f":"'Project Information'!E8","v":0},null,null,"Bituminous Index (Ic) for Bituminous Index Month"]
[null,"County",null,{"$f":"'Project Information'!E9","v":0},null,null,"Pay Estimate Number"]
[null,"Region",null,{"$f":"'Project Information'!E10","v":0},null,null,"Percent Change",null,{"$f":"IF(I7=0,0,(I7/I5-1))","v":0}]
[null,"Prime Contractor",null,{"$f":"'Project Information'!E11","v":0}]
[]
[]
[]
[null,null,"Bituminous Index Month"]
[null,null,"Total Bituminous Payment Adjustment \n(Paid using item TNP-109-8.1b)",null,null,{"$f":"SUM('Bit Index Calculations'!$J$31,'Bit Index Calculations'!$J$45,'Bit Index Calculations'!$J$54,'Bit Index Calculations'!$J$64)","v":0}]
[null,null,"Computed by"]
[]
[]
[null,"Payment Adjustment 1 - Virgin Mix",null,null,null,null,null,null,null,null,"s","PA1 =[Ic-Ib]x T"]
[]
[null,"Flexible Pavements (Virgin)"]
[]
[null,"Item Number","Flexible Pavement Descriptions",null,null,null,"Mixture Materials, ton","Mix Design AC, Percent","Bituminous Material, ton","Payment Adjustment, $"]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B24='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G24*'Bit Index Calculations'!$H24,0)","v":0},{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,(($I$7-$I$5)*I24))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B25='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G25*'Bit Index Calculations'!$H25,0)","v":0},{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,(($I$7-$I$5)*I25))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B26='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G26*'Bit Index Calculations'!$H26,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B27='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G27*'Bit Index Calculations'!$H27,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B28='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G28*'Bit Index Calculations'!$H28,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B29='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G29*'Bit Index Calculations'!$H29,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B30='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR('Bit Index Calculations'!$G30*'Bit Index Calculations'!$H30,0)","v":0},0]
[null,"Subtotal",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,'Bit Index Calculations'!$J$24:$J$30)","v":0}]
[]
[]
[null,"Surface Treatments",null,null,null,null,"Current Date",{"$f":"I6","v":"00:00:00"}]
[]
[null,"Item Number"," Surface Treatment Description","Application Number based on Specification or Mix Measurement Type","Unit of Measure","Quantity","Estimated Applied Material, ton"," Estimated Residue, Percent","Estimated Bituminous Material, ton","Payment Adjustment, $"]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B37='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E37,\"TONS\",'Bit Index Calculations'!$F37,\"SY\",'Bit Index Calculations'!$F37*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B37,'Bit Index Calculations'!$D37),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F37*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B37,'Bit Index Calculations'!$D37),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B37,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G37*'Bit Index Calculations'!$H37,0)","v":0},{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,(($I$7-$I$5)*I37))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B38='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E38,\"TONS\",'Bit Index Calculations'!$F38,\"SY\",'Bit Index Calculations'!$F38*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B38,'Bit Index Calculations'!$D38),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F38*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B38,'Bit Index Calculations'!$D38),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B38,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G38*'Bit Index Calculations'!$H38,0)","v":0},{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,(($I$7-$I$5)*I38))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B39='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E39,\"TONS\",'Bit Index Calculations'!$F39,\"SY\",'Bit Index Calculations'!$F39*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B39,'Bit Index Calculations'!$D39),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F39*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B39,'Bit Index Calculations'!$D39),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B39,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G39*'Bit Index Calculations'!$H39,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B40='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E40,\"TONS\",'Bit Index Calculations'!$F40,\"SY\",'Bit Index Calculations'!$F40*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B40,'Bit Index Calculations'!$D40),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F40*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B40,'Bit Index Calculations'!$D40),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B40,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G40*'Bit Index Calculations'!$H40,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B41='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E41,\"TONS\",'Bit Index Calculations'!$F41,\"SY\",'Bit Index Calculations'!$F41*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B41,'Bit Index Calculations'!$D41),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F41*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B41,'Bit Index Calculations'!$D41),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B41,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G41*'Bit Index Calculations'!$H41,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B42='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E42,\"TONS\",'Bit Index Calculations'!$F42,\"SY\",'Bit Index Calculations'!$F42*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B42,'Bit Index Calculations'!$D42),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F42*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B42,'Bit Index Calculations'!$D42),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B42,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G42*'Bit Index Calculations'!$H42,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B43='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E43,\"TONS\",'Bit Index Calculations'!$F43,\"SY\",'Bit Index Calculations'!$F43*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B43,'Bit Index Calculations'!$D43),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F43*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B43,'Bit Index Calculations'!$D43),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B43,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G43*'Bit Index Calculations'!$H43,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B44='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.SWITCH('Bit Index Calculations'!$E44,\"TONS\",'Bit Index Calculations'!$F44,\"SY\",'Bit Index Calculations'!$F44*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B44,'Bit Index Calculations'!$D44),'Item Lists'!$J$2:$K$491,2,FALSE),\"GAL\",'Bit Index Calculations'!$F44*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B44,'Bit Index Calculations'!$D44),'Item Lists'!$J$2:$L$491,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B44,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G44*'Bit Index Calculations'!$H44,0)","v":0},0]
[null,"Subtotal",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,'Bit Index Calculations'!$J$37:$J$44)","v":0}]
[]
[null,"Prime and Tack Coats"]
[]
[null,"Item Number","Prime and Tack Coat Description",null,"Unit of Measure","Quantity","Materials, ton","Asphalt Residue, Percent","Bituminous Material, ton","Payment Adjustment, $"]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B50='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(IF('Bit Index Calculations'!$E50=\"TONS\",'Bit Index Calculations'!$F50,'Bit Index Calculations'!$F50*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B50,\"N/A\"),'Item Lists'!$J$2:$K$491,2,FALSE)),0)","v":0},{"$f":"IFERROR(VLOOKUP(B50,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G50*'Bit Index Calculations'!$H50,0)","v":0},{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,(($I$7-$I$5)*I50))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B51='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(IF('Bit Index Calculations'!$E51=\"TONS\",'Bit Index Calculations'!$F51,'Bit Index Calculations'!$F51*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B51,\"N/A\"),'Item Lists'!$J$2:$K$491,2,FALSE)),0)","v":0},{"$f":"IFERROR(VLOOKUP(B51,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G51*'Bit Index Calculations'!$H51,0)","v":0},{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,(($I$7-$I$5)*I51))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B52='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(IF('Bit Index Calculations'!$E52=\"TONS\",'Bit Index Calculations'!$F52,'Bit Index Calculations'!$F52*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B52,\"N/A\"),'Item Lists'!$J$2:$K$491,2,FALSE)),0)","v":0},{"$f":"IFERROR(VLOOKUP(B52,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G52*'Bit Index Calculations'!$H52,0)","v":0},0]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B53='Item Lists'!$B$3:$B$491)*(\"Virgin\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(IF('Bit Index Calculations'!$E53=\"TONS\",'Bit Index Calculations'!$F53,'Bit Index Calculations'!$F53*VLOOKUP(_xlfn.CONCAT('Bit Index Calculations'!$B53,\"N/A\"),'Item Lists'!$J$2:$K$491,2,FALSE)),0)","v":0},{"$f":"IFERROR(VLOOKUP(B53,'Item Lists'!$B$3:$I$1048576,8,FALSE)/100,0)","v":0},{"$f":"IFERROR('Bit Index Calculations'!$G53*'Bit Index Calculations'!$H53,0)","v":0},0]
[null,"Subtotal",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,'Bit Index Calculations'!$J$50:$J$53)","v":0}]
[]
[null,"Payment Adjustment - 2 - Recycled Mix"]
[]
[null,"Recycled Bituminous Material"]
[]
[null,"Item Number","Description",null,null,null,"Mixture Materials, Ton","Job-mix Formula AC (JA), Percent","Reclaimed AC (RA) Mix Contribution, Percent","Payment Adjustment, $"]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B61='Item Lists'!$B$3:$B$491)*(\"Recycled\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,((($I$7-$I$5)*(H61-I61)*G61)))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B62='Item Lists'!$B$3:$B$491)*(\"Recycled\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(IF(ABS($I$9)<0.05,0,IF(ABS($I$9)>=0.05,((($I$7-$I$5)*(H62-I62)*G62)))),0)","v":0}]
[null,null,{"$f":"_xlfn.IFNA(INDEX('Item Lists'!$C$3:$C$491,MATCH(1,('Bit Index Calculations'!B63='Item Lists'!$B$3:$B$491)*(\"Recycled\"='Item Lists'!$E$3:$E$491),0)),\"\")","v":""},null,null,null,null,null,null,0]
[null,"Subtotal",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,'Bit Index Calculations'!$J$61:$J$63)","v":0}]

{"sheet":"Summary","index":6,"n_rows":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,3],[24,0,24,3]]}
["Bituminous Adjustment"]
[]
["Months","Monthly Payment Adjustment","Computed by",null,"Bituminous Adjustment Running Total",null,"Items with payment adjustments [Item Number($ Adjustment)]"]
["   ","   ","   ",null,{"$f":"SUM(B$4:B$21)","v":0},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fuel Adjustment"]
[]
["Months","Monthly Payment Adjustment","Computed by",null,"Fuel Adjustment Running Total",null,"Items with payment adjustments [Item Number($ Adjustment)]"]
["  "," ","  ",null,{"$f":"SUM(B29:B51)","v":0},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Adjustments"]
[null,null,null,null,{"$f":"E28+E4","v":0}]

{"sheet":"Sheet1","index":7,"n_rows":187,"n_cols":32,"rows_kept":187,"cut":false,"hidden":true,"merged":[[183,1,183,25],[178,1,178,25],[0,28,0,31],[17,9,17,16],[1,1,1,4],[2,9,2,16],[1,7,1,16],[160,1,160,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AIRPORT LIST"]
[null,"ITEM NUMBERS",null,null,null,null,null,"SURFACE TREATMENTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Airport ID","Airport Name","County","Region"]
[null,"Table 1","Table 3","Table 2","Table 4","Fuel Adjustment",null,"Row no","FAA AC 150/5370-10H Flexible Pavement Descriptions","NO OF COATS/ COAT TYPE"]
[null,"Virgin",null,null,"Recycled",null,null,1,{"$f":"'Bit Index Calculations'!C37","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,'Item Lists'!$C$3:$C$491=Sheet1!I4,\"N/A\")))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0A3","Smithville Municipal Airport","Dekalb",2]
[null,"FAA Flexible Pavements","FAA Surface Treatments","FAA Prime and Tack Coats","FAA Flexible Pavements","Fuel Adjustment",null,2,{"$f":"'Bit Index Calculations'!C38","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I5))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0A9","Elizabethton Municipal Airport","Carter",1]
[null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!B3:B491,('Item Lists'!D3:D491=Sheet1!B5)*('Item Lists'!E3:E491=Sheet1!B4)))","v":"P-401-8.6-a"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!B3:B491,('Item Lists'!D3:D491=Sheet1!C5)*('Item Lists'!E3:E491=Sheet1!B4)))","v":"P-608-8.1-a"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!B3:B491,('Item Lists'!D3:D491=Sheet1!D5)*('Item Lists'!E3:E491=Sheet1!B4)))","v":"P-602-5.1-a"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!B3:B491,('Item Lists'!D3:D491=Sheet1!E5)*('Item Lists'!E3:E491=Sheet1!E4)))","v":"P-401-8.7-a"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!B3:B491,('Item Lists'!D3:D491=Sheet1!F5)))","v":"P-152-4.1-a"},null,3,{"$f":"'Bit Index Calculations'!C39","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I6))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0M2","State owned","Lake",4]
[null,"P-401-8.1-a","P-608-R-8.1-a","P-603-5.1-a",null,"P-152-4.1-b",null,4,{"$f":"'Bit Index Calculations'!C40","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I7))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0M3","John A. Baker Field","Lewis",3]
[null,"P-401-8.1-b","P-609-5.1-a","P-602-5.1-b",null,"P-152-4.1-c",null,5,{"$f":"'Bit Index Calculations'!C41","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I8))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0M4","Benton County Airport","Benton",4]
[null,"P-401-8.1-c","P-609-5.2-a","P-603-5.1-b",null,"P-152-4.1-d",null,6,{"$f":"'Bit Index Calculations'!C42","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I9))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0M5","Humphreys County Airport","Humphreys",3]
[null,"P-401-8.1-d","P-623-8.1-a",null,null,"P-152-4.1-e",null,7,{"$f":"'Bit Index Calculations'!C43","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I10))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1A0","Dallas Bay Skypark","Hamilton",2]
[null,"P-401-8.1-e","P-626-6.1-a",null,null,"P-152-4.1-f",null,8,{"$f":"'Bit Index Calculations'!C44","v":""},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I11))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1A3","Martin Campbell Field","Polk",2]
[null,"P-401-8.1-f","P-626-6.3-a",null,null,"P-152-4.2-a",null,9,{"$f":"'Bit Index Calculations'!C45","v":0},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I12))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1A7","Jackson County Airport","Jackson",2]
[null,"P-401-8.1-g","P-626-6.1-b",null,null,"P-207-5.2-a",null,10,{"$f":"'Bit Index Calculations'!C46","v":0},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1M5","Portland Municipal Airport","Sumner",3]
[null,"P-401-8.1-h","P-626-6.3-b",null,null,"P-307-7.1-a",null,11,{"$f":"'Bit Index Calculations'!C47","v":0},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I14))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2A0","Mark Anton Airport","Rhea",2]
[null,"P-401-8.2-a","P-609-5.1-b",null,null,"P-501-8.1-a",null,12,{"$f":"'Bit Index Calculations'!C48","v":0},{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.FILTER('Item Lists'!$F$3:$F$491,('Item Lists'!$C$3:$C$491=Sheet1!I15))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2A1","Jamestown Municipal Airport","Fentress",2]
[null,"P-401-8.3-a","P-609-5.2-b",null,null,"P-501-8.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2M2","Lawrenceburg-Lawrence County Airport","Lawrence",3]
[null,"P-401-8.4-a","P-609-5.2-c",null,null,"P-152-4.3-a",null,null,null,"P-626",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2M8","Charles W. Baker Field","Shelby",4]
[null,"P-403-8.1-a","P-609-5.2-d",null,null,"TNP-209-5.1-a",null,"Row no","FAA AC 150/5370-10H Flexible Pavement Descriptions","Input unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3A2","New Tazewell Municipal","Claiborne",1]
[null,"P-403-8.1-b","P-609-5.2-e",null,null,"TNP-209-5.1-b",null,1,{"$f":"'Bit Index Calculations'!B37","v":0},{"$f":"TRANSPOSE(IF(LEFT(I19,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3M7","Lafayette Municipal Airport","Macon",3]
[null,"P-403-8.1-c","P-609-5.2-f",null,null,"P-207-5.1-a",null,2,{"$f":"'Bit Index Calculations'!B38","v":0},{"$f":"TRANSPOSE(IF(LEFT(I20,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"54M","Wolf River","Fayette",4]
[null,"P-403-8.1-d",null,null,null,"P-207-5.1-b",null,3,{"$f":"'Bit Index Calculations'!B39","v":0},{"$f":"TRANSPOSE(IF(LEFT(I21,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6A4","Johnson County Airport","Johnson",3]
[null,"P-403-8.1-e",null,null,null,"P-207-5.1-c",null,4,{"$f":"'Bit Index Calculations'!B40","v":0},{"$f":"TRANSPOSE(IF(LEFT(I22,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8A3","Livingston Municipal Airport","Overton",2]
[null,"P-403-8.1-f",null,null,null,"P-207-5.1-d",null,5,{"$f":"'Bit Index Calculations'!B41","v":0},{"$f":"TRANSPOSE(IF(LEFT(I23,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"92A","Chilhowee Gliderport","Polk",2]
[null,"P-403-8.1-g",null,null,null,"P-207-5.1-e",null,6,{"$f":"'Bit Index Calculations'!B42","v":0},{"$f":"TRANSPOSE(IF(LEFT(I24,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APT","Marion County - Brown Field","Marion",2]
[null,"P-403-8.1-h",null,null,null,"P-207-5.1-f",null,7,{"$f":"'Bit Index Calculations'!B43","v":0},{"$f":"TRANSPOSE(IF(LEFT(I25,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGF","Winchester Municipal Airport","Franklin",2]
[null,"P-403-8.1-i",null,null,null,"P-207-5.1-g",null,8,{"$f":"'Bit Index Calculations'!B44","v":0},{"$f":"TRANSPOSE(IF(LEFT(I26,5)=$J$17,$E$163:$E$164,$E$163:$E$165))","v":"GAL"},"TONS","SY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BNA","Nashville International Airport","Davidson",3]
[null,"P-403-8.2-a",null,null,null,"P-207-5.2-b",null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHA","Chattanooga Metropolitan Airport (Lovell Field)","Hamilton",2]
[null,"P-403-8.2-b",null,null,null,"P-207-5.2-c",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CKV","Clarksville Regional Airport","Montgomery",3]
[null,"P-403-8.2-c",null,null,null,"P-207-5.2-d",null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSV","Crossville Memorial Airport (Whitson Field)","Cumberland",2]
[null,"P-403-8.2-d",null,null,null,"P-208-5.1-a",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DKX","Downtown Island Airport","Knox",1]
[null,"P-403-8.2-e",null,null,null,"P-208-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DYR","Dyersburg Municipal Airport","Dyer",4]
[null,"P-403-8.2-f",null,null,null,"P-209-5.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FGU","Collegedale Municipal Airport","Hamilton",2]
[null,"P-403-8.2-g",null,null,null,"P-209-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FYE","Fayette County Airport","Fayette",4]
[null,"P-403-8.2-h",null,null,null,"P-209-5.1-c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FYM","Fayetteville Municipal Airport","Lincoln",3]
[null,"P-403-8.2-i",null,null,null,"P-209-5.1-d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GCY","Greeneville-Greene County Municipal Airport","Greene",1]
[null,"P-403-8.3-a",null,null,null,"P-209-5.1-e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GHM","Centerville Municipal Airport","Hickman",3]
[null,"P-403-8.3-b",null,null,null,"P-210-5.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GKT","Gatlinburg-Pigeon Forge Airport","Sevier",1]
[null,"P-403-8.3-c",null,null,null,"P-210-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GZS","Abernathy Field","Giles",3]
[null,"P-403-8.3-d",null,null,null,"P-211-5.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HZD","Carroll County Airport","Carroll",4]
[null,"P-403-8.3-e",null,null,null,"P-211-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAU","Campbell County Airport","Campbell",1]
[null,"P-403-8.3-f",null,null,null,"P-213-5.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JWN","John C. Tune Airport","Davidson",1]
[null,"P-403-8.3-g",null,null,null,"P-213-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LUG","Ellington Airport","Marshall",3]
[null,"P-403-8.3-h",null,null,null,"P-217-5.1-a"]
[null,"P-403-8.3-i",null,null,null,"P-217-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M01","General Dewitt Spain Airport","Shelby",4]
[null,"P-403-8.4-a",null,null,null,"P-217-5.2-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M02","Dickson Municipal Airport","Dickson",3]
[null,"P-404-8.1-a",null,null,null,"P-217-5.2-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M04","Covington Municipal Airport","Tipton",4]
[null,"TNP-401-8.1-a",null,null,null,"P-217-5.3-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M08","William L.Whitehurst Field","Hardeman",4]
[null,"TNP-401-8.1-b",null,null,null,"P-219-5.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M15","Perry County Airport","Perry",3]
[null,"TNP-401-8.1-c",null,null,null,"P-220-6.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M29","Clifton Airport (Hassell Field)","Wayne",3]
[null,"TNP-401-8.1-d",null,null,null,"P-220-6.2-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M31","Arnold Field","Lauderdale",4]
[null,"TNP-401-8.1-e",null,null,null,"P-304-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M53","Humboldt Municipal Airport","Gibson",4]
[null,"TNP-401-8.2-a",null,null,null,"P-306-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M54","Lebanon Municipal Airport","Wilson",3]
[null,"TNP-401-8.2-b",null,null,null,"P-501-8.2-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M91","Springfield-Robertson County Airport","Robertson",3]
[null,"TNP-401-8.2-c",null,null,null,"P-501-8.2-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M93","Houston County Airport","Houston",3]
[null,"TNP-401-8.2-d",null,null,null,"P-501-8.2-c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MBT","Murfreesboro Municipal Airport","Rutherford",3]
[null,"TNP-401-8.2-e",null,null,null,"P-501-8.2-d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEM","Memphis International Airport","Shelby",4]
[null,"TNP-401-8.2-g",null,null,null,"P-501-8.2-e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MKL","McKellar-Sipes Regional Airport","Madison",4]
[null,null,null,null,null,"P-501-8.2-f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MMI","McMinn County airport","Mcminn",2]
[null,null,null,null,null,"P-501-8.2-g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MNV","Monroe County Airport","Monroe",1]
[null,null,null,null,null,"P-501-8.2-h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOR","Moore-Murrell Field","Hamblen",1]
[null,null,null,null,null,"P-154-5.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MQY","Smyrna Airport","Rutherford",3]
[null,null,null,null,null,"P-154-5.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRC","Maury County Regional Airport","Maury",3]
[null,null,null,null,null,"P-155-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NQA","Millington Regional Jetport","Shelby",4]
[null,null,null,null,null,"P-156-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHT","Henry County Airport","Henry",4]
[null,null,null,null,null,"P-157-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PVE","Beech River Regional","Henderson",4]
[null,null,null,null,null,"P-158-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RKW","Rockwood Municipal Airport","Morgan",1]
[null,null,null,null,null,"P-152-4.2-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RNC","Warren County Memorial Airport","Warren",2]
[null,null,null,null,null,"P-401-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RVN","Hawkins County Airport","Hawkins",1]
[null,null,null,null,null,"P-401-8.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RZR","Cleveland Regional Jetport","Bradley",2]
[null,null,null,null,null,"P-401-8.1-c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCX","Scott Municipal Airport","Scott",1]
[null,null,null,null,null,"P-401-8.1-d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SNH","Savannah-Hardin County Airport","Hardin",4]
[null,null,null,null,null,"P-401-8.1-e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRB","Upper Cumberland Regional Airport","White",2]
[null,null,null,null,null,"P-401-8.1-f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYI","Shelbyville Municipal Airport (Bomar Field)","Bedford",3]
[null,null,null,null,null,"P-401-8.1-g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SZY","Robert Sibley Airport","Mcnairy",4]
[null,null,null,null,null,"P-401-8.1-h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TGC","Gibson County Airport","Gibson",4]
[null,null,null,null,null,"P-401-8.2-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THA","Tullahoma Regional Airport","Coffee",2]
[null,null,null,null,null,"P-401-8.3-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRI","Tri-Cities Regional Airport","Sullivan",1]
[null,null,null,null,null,"P-401-8.4-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYS","McGhee Tyson Airport","Blount",1]
[null,null,null,null,null,"P-403-8.1-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCY","Everett-Stewart Airport","Obion",4]
[null,null,null,null,null,"P-403-8.1-b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UOS","University of the South-Franklin County Airport","Franklin",2]
[null,null,null,null,null,"P-403-8.1-c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XNX","Music City Executive Airport","Sumner",3]
[null,null,null,null,null,"P-403-8.1-d"]
[null,null,null,null,null,"P-403-8.1-e"]
[null,null,null,null,null,"P-403-8.1-f"]
[null,null,null,null,null,"P-403-8.1-g"]
[null,null,null,null,null,"P-403-8.1-h"]
[null,null,null,null,null,"P-403-8.1-i"]
[null,null,null,null,null,"P-403-8.2-a"]
[null,null,null,null,null,"P-403-8.2-b"]
[null,null,null,null,null,"P-403-8.2-c"]
[null,null,null,null,null,"P-403-8.2-d"]
[null,null,null,null,null,"P-403-8.2-e"]
[null,null,null,null,null,"P-403-8.2-f"]
[null,null,null,null,null,"P-403-8.2-g"]
[null,null,null,null,null,"P-403-8.2-h"]
[null,null,null,null,null,"P-403-8.2-i"]
[null,null,null,null,null,"P-403-8.3-a"]
[null,null,null,null,null,"P-403-8.3-b"]
[null,null,null,null,null,"P-403-8.3-c"]
[null,null,null,null,null,"P-403-8.3-d"]
[null,null,null,null,null,"P-403-8.3-e"]
[null,null,null,null,null,"P-403-8.3-f"]
[null,null,null,null,null,"P-403-8.3-g"]
[null,null,null,null,null,"P-403-8.3-h"]
[null,null,null,null,null,"P-403-8.3-i"]
[null,null,null,null,null,"P-403-8.4-a"]
[null,null,null,null,null,"P-404-8.1-a"]
[null,null,null,null,null,"TNP-401-8.1-a"]
[null,null,null,null,null,"TNP-401-8.1-b"]
[null,null,null,null,null,"TNP-401-8.1-c"]
[null,null,null,null,null,"TNP-401-8.1-d"]
[null,null,null,null,null,"TNP-401-8.1-e"]
[null,null,null,null,null,"TNP-401-8.2-a"]
[null,null,null,null,null,"TNP-401-8.2-b"]
[null,null,null,null,null,"TNP-401-8.2-c"]
[null,null,null,null,null,"TNP-401-8.2-d"]
[null,null,null,null,null,"TNP-401-8.2-e"]
[null,null,null,null,null,"TNP-401-8.2-g"]
[null,null,null,null,null,"P-153-6.1-a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"User Form Choices "]
[null,"Row Source","Virgin/Recycled","Coat Type","Unit of Measure","Fuel Units of Measure"]
[null,"FAA Flexible Pavements","Virgin",1,"GAL","Cubic Yard"]
[null,"FAA Prime and Tack Coats","Recycled",2,"TONS","Square Yard"]
[null,"FAA Surface Treatments","N/A",3,"SY","Ton"]
[null,"Fuel Adjustment",null,"N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[null,"Estimated Residue Table"]
[null,"Item Groups","Estimated Residue"]
[null,"Asphalt Mixtures (P-401, P-403 etc) ",1]
[null,"Emulsified Asphalt Treatments (e.g. P-602, P-603, P-608, P-623, and P-626)","Enter based on estimated residue based on ASP 109B"]
[null,"Fuel Adjustment Items (P-100, P-300, P-500)","N/A"]
[]
[null,"Items with payment adjustment "]
[null,"Individual Items ",{"$f":"IFERROR(TRANSPOSE(_xlfn._xlws.FILTER('Bit Index Calculations'!B24:B64,('Bit Index Calculations'!I24:I64<>0)*('Bit Index Calculations'!B24:B64<>\"Subtotal\")*('Bit Index Calculations'!B24:B64<>\"Item Number\"))),\"\")","v":""}]
[null,"Individual Costs ",{"$f":"TRANSPOSE(_xlfn._xlws.FILTER('Bit Index Calculations'!J24:J64,('Bit Index Calculations'!I24:I64<>0)*('Bit Index Calculations'!B24:B64<>\"Subtotal\")*('Bit Index Calculations'!B24:B64<>\"Item Number\")))","v":{"$error":"#VALUE!"}}]
[null,"Items + Costs ",{"$f":"IF(C180=\"\",\"\",_xlfn.CONCAT(C180,\" ($\",ROUND(C181,2),\")\"))","v":""},{"$f":"IF(D180=\"\",\"\",_xlfn.CONCAT(D180,\" ($\",ROUND(D181,2),\")\"))","v":""},{"$f":"IF(E180=\"\",\"\",_xlfn.CONCAT(E180,\" ($\",ROUND(E181,2),\")\"))","v":""},{"$f":"IF(F180=\"\",\"\",_xlfn.CONCAT(F180,\" ($\",ROUND(F181,2),\")\"))","v":""},"","","","",{"$f":"IF(K180=\"\",\"\",_xlfn.CONCAT(K180,\" ($\",ROUND(K181,2),\")\"))","v":""},{"$f":"IF(L180=\"\",\"\",_xlfn.CONCAT(L180,\" ($\",ROUND(L181,2),\")\"))","v":""},{"$f":"IF(M180=\"\",\"\",_xlfn.CONCAT(M180,\" ($\",ROUND(M181,2),\")\"))","v":""},{"$f":"IF(N180=\"\",\"\",_xlfn.CONCAT(N180,\" ($\",ROUND(N181,2),\")\"))","v":""},"",{"$f":"IF(P180=\"\",\"\",_xlfn.CONCAT(P180,\" ($\",ROUND(P181,2),\")\"))","v":""},{"$f":"IF(Q180=\"\",\"\",_xlfn.CONCAT(Q180,\" ($\",ROUND(Q181,2),\")\"))","v":""},{"$f":"IF(R180=\"\",\"\",_xlfn.CONCAT(R180,\" ($\",ROUND(R181,2),\")\"))","v":""},{"$f":"IF(S180=\"\",\"\",_xlfn.CONCAT(S180,\" ($\",ROUND(S181,2),\")\"))","v":""},"",{"$f":"IF(U180=\"\",\"\",_xlfn.CONCAT(U180,\" ($\",ROUND(U181,2),\")\"))","v":""},{"$f":"IF(V180=\"\",\"\",_xlfn.CONCAT(V180,\" ($\",ROUND(V181,2),\")\"))","v":""},{"$f":"IF(W180=\"\",\"\",_xlfn.CONCAT(W180,\" ($\",ROUND(W181,2),\")\"))","v":""},{"$f":"IF(X180=\"\",\"\",_xlfn.CONCAT(X180,\" ($\",ROUND(X181,2),\")\"))","v":""},"",{"$f":"IF(Z180=\"\",\"\",_xlfn.CONCAT(Z180,\" ($\",ROUND(Z181,2),\")\"))","v":""}]
[]
[null,"Items with payment adjustment "]
[null,"Individual Items ",{"$f":"IFERROR(TRANSPOSE(_xlfn._xlws.FILTER('Fuel Index Calculations'!B23:B44,('Fuel Index Calculations'!J23:J44<>0)*('Fuel Index Calculations'!B23:B44<>\"Subtotal\")*('Fuel Index Calculations'!B23:B44<>\"Item Number\"))),\"\")","v":""}]
[null,"Individual Costs ",{"$f":"TRANSPOSE(_xlfn._xlws.FILTER('Fuel Index Calculations'!K23:K44,('Fuel Index Calculations'!J23:J44<>0)*('Fuel Index Calculations'!B23:B44<>\"Subtotal\")*('Fuel Index Calculations'!B23:B44<>\"Item Number\")))","v":{"$error":"#VALUE!"}}]
[null,"Items + Costs ",{"$f":"IF(C185=\"\",\"\",_xlfn.CONCAT(C185,\" ($\",ROUND(C186,2),\")\"))","v":""},{"$f":"IF(D185=\"\",\"\",_xlfn.CONCAT(D185,\" ($\",ROUND(D186,2),\")\"))","v":""},"","",{"$f":"IF(G185=\"\",\"\",_xlfn.CONCAT(G185,\" ($\",ROUND(G186,2),\")\"))","v":""},"","","","","","","","","","","","","","","","","","",""]