{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["AMS Instructions","AMS Form","ABC","CONCRETE","Asphalt"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":147,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AMS Instructions","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,0,3,9],[2,0,2,9],[1,0,1,9],[9,0,12,9],[15,0,45,9],[7,0,7,9],[6,0,6,9],[5,0,5,9],[4,0,4,9]]}
[]
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LABORATORY"]
["Approved Materials Submittal  "]
[]
["The Approved Materials Submittal (AMS) form shall only be used for City of Phoenix Approved Material (ABC, Asphalt, Polymer Modified Asphalt Rubber, Concrete). No other information will be required for submittal. All other submittals, not on the Approved Materials Lists, shall follow standard submittal processes explained in the contract documents."]
[]
[]
[]
["AMS Form Instructions:"]
[]
["Selecting the Form and Project Information Instructions:\n1.Select and download the latest City of Phoenix AMS form (Excel Version) from the City of Phoenix Materials Lab web page at: https://www.phoenix.gov/streetssite/Pages/COP-MaterialsLab.aspx\n2. Print/Download copies of the City of Phoenix Approved Suppliers lists, located on the same web page above. Use these lists as a reference guide for your AMS form\n3. Open the AMS form in Microsoft Excel. \n4. Fill out all the correct project information including: City of Phoenix Project Name, Project Number, Permit Number (PDD only), Submittal Date, Contractor, Sub-Contractor, and Contractor's Submittal Number.\n5. If the project is a federal funded project, check the \"Federally Funded\" box. Once this box is checked, fill out the ADOT Tracs Number and the Federal Aid Number. \n6. If the project has other funding sources (such as grants), fill out the correct \"Other Funding Sources\" number in the box. \n\nSelecting Approved Material:\n1. Select the \"Material Type\" from the drop-down menu (Only One Material Type per AMS Form). \n2. Select the \"Material Supplier\" from the drop-down menu (Only One Material Supplier per AMS Form). \n3. Select the \"Plant Location\" from the drop-down menu (Multiple Plant Locations may be Selected).\n4. Select the \"Product Code\" from the drop-down menu (Multiple Product Codes may be Selected).\n5. Fill in the correct \"Mix Design Date\" submitted to the City of Phoenix Materials Lab (From the Corresponding Approved Materials Supplier List).\n\nCompany Logo, Remarks, Printed Name, Signature Instructions:\n1. Add any remarks or comments in the box.\n2. Print Name and Title.\n3. Add your company logo to the specified location (Cut and Paste the Logo and then resize).\n4. Review the form to make sure all information is correct.\n5. Print a copy and sign or add a copied signature to the form and print or send electronically. \n\nFinal Submittal Instructions:\n1. Submit the AMS form(s) (One AMS Form per Material Type) according to the directives in the contract documents."]

{"sheet":"AMS Form","index":1,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,10,15,12],[15,7,15,9],[17,5,17,9],[18,5,18,9],[19,5,19,9],[20,5,20,9],[21,5,21,9],[22,5,22,9],[23,5,23,9],[24,5,24,9],[25,5,25,9],[26,5,26,9],[27,5,27,9],[28,5,28,9],[17,1,17,3],[27,1,27,3],[25,1,25,3],[38,1,38,4],[0,0,1,13],[6,0,6,13],[5,0,5,13],[4,0,4,13],[3,0,3,13],[2,0,2,13],[16,13,16,14],[11,0,11,2],[13,0,13,2],[13,3,13,6],[15,1,15,2],[15,3,15,5],[7,7,7,9],[9,0,9,2],[9,3,9,6],[9,7,9,9],[10,10,10,13],[9,10,9,13],[10,7,10,9],[10,0,10,2],[10,3,10,6],[7,10,7,13],[7,0,8,1],[7,2,8,6],[8,7,8,9],[8,10,8,13],[24,1,24,3],[18,1,18,3],[28,1,28,3],[26,1,26,3],[22,1,22,3],[23,1,23,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[12,0,12,2],[11,3,11,6],[12,3,12,6],[42,1,43,12],[41,1,41,12],[35,0,37,4],[32,1,32,12],[29,1,29,3],[30,1,30,3],[33,6,40,12],[39,1,39,4],[34,1,34,4],[29,5,29,9],[30,5,30,9]]}
[]
[]
["CITY OF PHOENIX"]
["STREET TRANSPORTATION DEPARTMENT"]
["PROGRAMMING & PROJECT DELIVERY DIVISION"]
["MATERIALS LABORATORY"]
["Approved Materials Submittal  "]
["Project Name:",null,null,null,null,null,null,"Submittal Date:"]
[null,null,null,null,null,null,null,"General Contractor:"]
["Project Number:",null,null,null,null,null,null,"Sub Contractor:"]
["Permit Number (PDD):",null,null,null,null,null,null,"Submittal Number:"]
["ADOT Tracs Number:",null,null,null,null,null,null,null,null,null,false]
["Federal Aid Number:",null,null,null,null,null,null,null,null,null,false]
["Other Funding Sources:"]
[]
[null,"Material Type:",null,null,null,null,null,"Material Supplier:"]
[]
[null,"Plant Location",null,null,null,"Product Code",null,null,null,null,null,null,"Mix Design Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"I certify that the above-mentioned material(s) meet the requirements specified by the City of Phoenix Materials Lab or the contract documents and have not been modified, in any way, from the original approved material submitted."]
[null,null,null,null,null,null,"[Place Company Logo Here]"]
[null,"Respectfully Submitted,"]
["[Signature]"]
[]
[]
[null,"[Printed Name]"]
[null,"[Title]"]
[]
[null,"Contractor/Supplier Remarks:"]

{"sheet":"ABC","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":true,"merged":[[31,5,33,5],[32,4,33,4],[1,4,6,4],[10,4,11,4],[15,4,18,4],[25,4,27,4],[3,5,3,7]]}
[null,"ABC","Cemex USA",null,"Date Approved"]
["ABC","Cemex USA","Plant 4120_67th Ave.","MAG ABC","2019-01-09"]
["Concrete","Fisher Sand and Gravel","Superstition Plant 8991","MAG ABC"]
["Asphalt","Gila River Sand and Gravel","El Mirage 4115_Lime Treated","MAG ABC",null,"added + Lime / removed Glendale"]
["PMAR Asphalt","LaFarge North America Agg.","Maricopa Plant 8985","MAG ABC"]
["SBS Asphalt","Salt River Materials Group","San Tan Plant 8984","MAG ABC"]
[null,"Southwest Rock Products","Coolidge Plant 4114","MAG ABC"]
[null,"Superstition Crushing LLC.","Fisher Sand and Gravel"]
[null,"Vulcan Materials Company","Broadway and 15th Ave.","MAG ABC","2018-12-12"]
[null,"CalPortland Company","Gila River Sand and Gravel"]
[null,"Hanson Aggregates","Maricopa","MAG ABC","2019-01-03"]
[null,null,"San Tan","MAG ABC"]
[null,null,"LaFarge North America Agg."]
[null,null,"Plant 7","MAG ABC","2019-01-07"]
[null,null,"Salt River Materials Group"]
[null,null,"Beeline","MAG ABC","2019-01-04"]
[null,null,"Higley","MAG ABC"]
[null,null,"Southern and 67th Ave.","MAG ABC"]
[null,null,"Glendale","MAG ABC"]
[null,null,"Southwest Rock Products"]
[null,null,"Cave Creek and Beardsley","MAG ABC","2018-12-14"]
[null,null,"Superstition Crushing LLC."]
[null,null,"Deer Valley","MAG ABC","2019-01-02"]
[null,null,"Vulcan Materials Company"]
[null,null,"West 43rd Ave.","MAG ABC","removed 2019"]
[null,null,"Litchfield_Lime Treated","MAG ABC","2019-01-29","added + Lime"]
[null,null,"Sun City","MAG ABC"]
[null,null,"West Broadway","MAG ABC"]
[null,null,"Queen Creek","MAG ABC","removed 2019"]
[null,null,"CalPortland Company"]
[null,null,"Plant_135","MAG ABC","removed 2019"]
[null,null,"Hanson Aggregates",null,null,"added 2019"]
[null,null,"Plant 42 Queen Creek","MAG ABC","2019-02-19"]
[null,null,"Plant 65 Coolidge","MAG ABC"]

{"sheet":"CONCRETE","index":3,"n_rows":172,"n_cols":16,"rows_kept":172,"cut":false,"hidden":true,"merged":[]}
["Concrete","Arizona Materials"]
["Arizona Materials","Plant 1 Phoenix","MAG AA - 14054","MAG AA - 14054","MAG AA - 14054","MAG AA - 14054"]
["Arizona Metro Mix","Plant 3 Phoenix","MAG AA - 14004","MAG AA - 14004","MAG AA - 14004","MAG AA - 14004"]
["CalPortland","Plant 7 Glendale","MAG AA - 14005 (no ash)","MAG AA - 14005 (no ash)","MAG AA - 14005 (no ash)","MAG AA - 14005 (no ash)"]
["Cemex","Plant 12 Mesa","MAG A - 13054","MAG A - 13054","MAG A - 13054","MAG A - 13054"]
["CORE Ready Mix",null,"MAG A - 13004","MAG A - 13004","MAG A - 13004","MAG A - 13004"]
["Desert Ready Mix",null,"MAG A - 13005 (no ash)","MAG A - 13005 (no ash)","MAG A - 13005 (no ash)","MAG A - 13005 (no ash)"]
["Diamondback Materials",null,"MAG A - 13008","MAG A - 13008","MAG A - 13008","MAG A - 13008"]
["Hanson",null,"MAG B - 12504","MAG B - 12504","MAG B - 12504","MAG B - 12504"]
["Rock Solid",null,"MAG B - 12505 (no ash)","MAG B - 12505 (no ash)","MAG B - 12505 (no ash)","MAG B - 12505 (no ash)"]
[null,null,"MAG B - 12506","MAG B - 12506","MAG B - 12506","MAG B - 12506"]
[null,null,"MAG C - 12004","MAG C - 12004","MAG C - 12004","MAG C - 12004"]
[null,null,"PHCLSM","PHCLSM","PHCLSM","PHCLSM"]
[null,null,"PHCLSM1","PHCLSM1","PHCLSM1","PHCLSM1"]
[null,null,"PHCLSM1.5","PHCLSM1.5","PHCLSM1.5","PHCLSM1.5"]
[]
[null,"Arizona Metro Mix","MAG AA - 401110","MAG AA - 401110","MAG AA - 401110"]
[null,"East Plant Queen Creek","MAG AA - 401110A (w/air)","MAG AA - 401110A (w/air)","MAG AA - 401110A (w/air)"]
[null,"Central Plant 15th Avenue","MAG AA - 401120","MAG AA - 401120","MAG AA - 401120"]
[null,"West Plant Tolleson","MAG AA - 401120A (w/air)","MAG AA - 401120A (w/air)","MAG AA - 401120A (w/air)"]
[null,null,"MAG AA - 401130","MAG AA - 401130","MAG AA - 401130"]
[null,null,"MAG A - 301111","MAG A - 301111","MAG A - 301111"]
[null,null,"MAG A - 301121","MAG A - 301121","MAG A - 301121"]
[null,null,"MAG A - 301131","MAG A - 301131","MAG A - 301131"]
[null,null,"MAG B - 251112","MAG B - 251112","MAG B - 251112"]
[null,null,"MAG B - 251132","MAG B - 251132","MAG B - 251132"]
[null,null,"MAG B - 251122","MAG B - 251122","MAG B - 251122"]
[null,null,"MAG C - 201113","MAG C - 201113","MAG C - 201113"]
[null,null,"PHCLSM1/2","PHCLSM1/2","PHCLSM1/2"]
[null,null,"PHCLSM1","PHCLSM1","PHCLSM1"]
[null,null,"PHCSLM1 1/2","PHCSLM1 1/2","PHCSLM1 1/2"]
[]
[null,"CalPortland","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA","MAG AA - P4025MAA"]
["added 2019","Plant 130","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)","MAG AA - P4015MAA (no ash)"]
[null,"Plant 135","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF","MAG AA - P4025AAF"]
[null,"Plant 137","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)","MAG AA - P4015AAF (no ash)"]
[null,"Plant 147","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1","MAG AA - P4025AA1"]
[null,"Plant 150","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)","MAG AA - P4015AA1 (no ash)"]
[null,"Plant 151","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5","MAG AA - P4025AF5"]
["added 2019","Plant 152","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5","MAG AA - P4025AA5"]
[null,"Plant 154","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01","MAG A - P3025A01"]
[null,"Plant 155R","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)","MAG A - P3015A01 (no ash)"]
[null,"Plant 158","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1","MAG A - P3025AF1"]
[null,"Plant 159","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)","MAG A - P3015AF1 (no ash)"]
[null,"Plant 160","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1","MAG A - P3025MA1"]
[null,"Plant 161","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01","MAG B - P2525B01"]
[null,"MIAR Sky Harbor","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)","MAG B - P2515B01 (no ash)"]
[null,null,"MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1","MAG B - P2525MB1"]
[null,null,"MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1","MAG B - P2525BF1"]
[null,null,"MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)","MAG B - P2515BF1 (no ash)"]
[null,null,"MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01","MAG C - P2025C01"]
[null,null,"MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1","MAG C - P2015C1"]
[null,null,"PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)","PHCLSM1.5 (S15157S1)"]
[null,null,"PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2","PHCLSM 1/2"]
[null,null,"PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)","PHCLSM1 (S10157S1)"]
[null,null,"PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)","PHCLSM2 (S20157S1)"]
[]
[null,"Cemex","MAG AA - 1377687 (no ash)","MAG AA - 1377687 (no ash)","MAG AA - 1377687 (no ash)","MAG AA - 1377687 (no ash)","MAG AA - 1377687 (no ash)"]
[null,"Plant 1953","MAG AA - 1556313","MAG AA - 1556313","MAG AA - 1556313","MAG AA - 1556313","MAG AA - 1556313"]
[null,"Plant 1956","MAG AA - 1556315","MAG AA - 1556315","MAG AA - 1556315","MAG AA - 1556315","MAG AA - 1556315"]
[null,"Plant 4101","MAG AA - 1555658","MAG AA - 1555658","MAG AA - 1555658","MAG AA - 1555658","MAG AA - 1555658"]
["added 2019","Plant 4106","MAG AA - 1377688 (no ash)","MAG AA - 1377688 (no ash)","MAG AA - 1377688 (no ash)","MAG AA - 1377688 (no ash)","MAG AA - 1377688 (no ash)"]
[null,"Plant 4108","MAG A - 1385442 (no ash)","MAG A - 1385442 (no ash)","MAG A - 1385442 (no ash)","MAG A - 1385442 (no ash)","MAG A - 1385442 (no ash)"]
["removed 2019","Plant 1960","MAG A - 1555049","MAG A - 1555049","MAG A - 1555049","MAG A - 1555049","MAG A - 1555049"]
["removed 2019","Plant 4111","MAG A - 1555050","MAG A - 1555050","MAG A - 1555050","MAG A - 1555050","MAG A - 1555050"]
["removed 2019","Plant 4112","MAG A - 1555657","MAG A - 1555657","MAG A - 1555657","MAG A - 1555657","MAG A - 1555657"]
[null,null,"MAG A - 1341247 (no ash)","MAG A - 1341247 (no ash)","MAG A - 1341247 (no ash)","MAG A - 1341247 (no ash)","MAG A - 1341247 (no ash)"]
[null,null,"MAG B - 1554955","MAG B - 1554955","MAG B - 1554955","MAG B - 1554955","MAG B - 1554955"]
[null,null,"MAG B - 1555047","MAG B - 1555047","MAG B - 1555047","MAG B - 1555047","MAG B - 1555047"]
[null,null,"MAG B - 1555656","MAG B - 1555656","MAG B - 1555656","MAG B - 1555656","MAG B - 1555656"]
[null,null,"MAG C - 1555627","MAG C - 1555627","MAG C - 1555627","MAG C - 1555627","MAG C - 1555627"]
[null,null,"MAG C - 1555624","MAG C - 1555624","MAG C - 1555624","MAG C - 1555624","MAG C - 1555624"]
[null,null,"PHCLSM0.5 (1332797)","PHCLSM0.5 (1332797)","PHCLSM0.5 (1332797)","PHCLSM0.5 (1332797)","PHCLSM0.5 (1332797)"]
[null,null,"PHCLSM1 (1332774)","PHCLSM1 (1332774)","PHCLSM1 (1332774)","PHCLSM1 (1332774)","PHCLSM1 (1332774)"]
[null,null,"PHCLSM1.5 (1332772)","PHCLSM1.5 (1332772)","PHCLSM1.5 (1332772)","PHCLSM1.5 (1332772)","PHCLSM1.5 (1332772)"]
[]
[null,"CORE Ready Mix","MAG AA - 4025AA1P"]
[null,"Plant 2 Peoria","MAG AA - 402MAA1P"]
[null,null,"MAG AA - 4025AAFP"]
[null,null,"MAG AA - 4015AAFP (no ash)"]
[null,null,"MAG AA - 4015AA1P (no ash)"]
[null,null,"MAG AA - 401MAA1P (no ash)"]
[null,null,"MAG A - 3025A01P"]
[null,null,"MAG A - 3025MA1P"]
[null,null,"MAG A - 3025AF1P"]
[null,null,"MAG A - 3015AF1P (no ash)"]
[null,null,"MAG A - 3015MA1P (no ash)"]
[null,null,"MAG A - 3015A01P (no ash)"]
[null,null,"MAG B - 2525B01P"]
[null,null,"MAG B - 2525BM1P"]
[null,null,"MAG B - 2515MB1P (no ash)"]
[null,null,"MAG B - 2515B01P (no ash)"]
[null,null,"MAG C - 2025C01P"]
[null,null,"MAG C - 2015C01P (no ash)"]
[null,null,"PHCLSM 1/2"]
[null,null,"PHCLSM1 (1015700S)"]
[null,null,"PHCSLM1 1/2 (1515700S)"]
[null,null,"2015700S 2 Sack"]
[]
[null,"Desert Ready Mix","MAG AA - A204001","MAG AA - A204001","MAG AA - A204001","MAG AA - A204001","MAG AA - A204001"]
[null,"Plant 5","MAG AA - A204002","MAG AA - A204002","MAG AA - A204002","MAG AA - A204002","MAG AA - A204002"]
[null,"Plant 10","MAG AA - F204011","MAG AA - F204011","MAG AA - F204011","MAG AA - F204011","MAG AA - F204011"]
[null,"Plant 12","MAG AA - F204010 (no ash)","MAG AA - F204010 (no ash)","MAG AA - F204010 (no ash)","MAG AA - F204010 (no ash)","MAG AA - F204010 (no ash)"]
[null,"Plant 14","MAG AA - A204000 (no ash)","MAG AA - A204000 (no ash)","MAG AA - A204000 (no ash)","MAG AA - A204000 (no ash)","MAG AA - A204000 (no ash)"]
[null,"Plant 15","MAG A - A203001","MAG A - A203001","MAG A - A203001","MAG A - A203001","MAG A - A203001"]
[null,null,"MAG A - A203002","MAG A - A203002","MAG A - A203002","MAG A - A203002","MAG A - A203002"]
[null,null,"MAG A - F203011","MAG A - F203011","MAG A - F203011","MAG A - F203011","MAG A - F203011"]
[null,null,"MAG A - F203010 (no ash)","MAG A - F203010 (no ash)","MAG A - F203010 (no ash)","MAG A - F203010 (no ash)","MAG A - F203010 (no ash)"]
[null,null,"MAG A - A203000 (no ash)","MAG A - A203000 (no ash)","MAG A - A203000 (no ash)","MAG A - A203000 (no ash)","MAG A - A203000 (no ash)"]
[null,null,"MAG B - A202501","MAG B - A202501","MAG B - A202501","MAG B - A202501","MAG B - A202501"]
[null,null,"MAG B - A202502","MAG B - A202502","MAG B - A202502","MAG B - A202502","MAG B - A202502"]
[null,null,"MAG B - F202511","MAG B - F202511","MAG B - F202511","MAG B - F202511","MAG B - F202511"]
[null,null,"MAG B - F202510 (no ash)","MAG B - F202510 (no ash)","MAG B - F202510 (no ash)","MAG B - F202510 (no ash)","MAG B - F202510 (no ash)"]
[null,null,"MAG B - A202500 (no ash)","MAG B - A202500 (no ash)","MAG B - A202500 (no ash)","MAG B - A202500 (no ash)","MAG B - A202500 (no ash)"]
[null,null,"MAG C - F202011","MAG C - F202011","MAG C - F202011","MAG C - F202011","MAG C - F202011"]
[null,null,"MAG C - A202001","MAG C - A202001","MAG C - A202001","MAG C - A202001","MAG C - A202001"]
[null,null,"MAG C - F202010 (no ash)","MAG C - F202010 (no ash)","MAG C - F202010 (no ash)","MAG C - F202010 (no ash)","MAG C - F202010 (no ash)"]
[null,null,"MAG C - A202000 (no ash)","MAG C - A202000 (no ash)","MAG C - A202000 (no ash)","MAG C - A202000 (no ash)","MAG C - A202000 (no ash)"]
[null,null,"PHCLSM.5","PHCLSM.5","PHCLSM.5","PHCLSM.5","PHCLSM.5"]
[null,null,"PHCLSM1","PHCLSM1","PHCLSM1","PHCLSM1","PHCLSM1"]
[null,null,"PHCLSM1.5","PHCLSM1.5","PHCLSM1.5","PHCLSM1.5","PHCLSM1.5"]
[]
[null,"Diamondback Materials","MAG AA - 14006","MAG AA - 14006"]
[null,"Plant 17","MAG AA - 14004","MAG AA - 14004"]
[null,"Plant 18","MAG A - 13006","MAG A - 13006"]
[null,null,"MAG A - 13004","MAG A - 13004"]
[null,null,"MAG B - 12506","MAG B - 12506"]
[null,null,"MAG B - 12504","MAG B - 12504"]
[null,null,"MAG C - 12004","MAG C - 12004"]
[null,null,"PHCLSM1/2","PHCLSM1/2"]
[null,null,"PHCLSM1","PHCLSM1"]
[null,null,"PHCLSM1.5","PHCLSM1.5"]
[]
[null,"Hanson","MAG AA - 2403144","MAG AA - 2403144","MAG AA - 2403144","MAG AA - 2403144","MAG AA - 2403144"]
[null,"Plant 32","MAG AA - 2403141","MAG AA - 2403141","MAG AA - 2403141","MAG AA - 2403141","MAG AA - 2403141"]
["added 2019","Plant 40","MAG AA - 2403104 (no ash)","MAG AA - 2403104 (no ash)","MAG AA - 2403104 (no ash)","MAG AA - 2403104 (no ash)","MAG AA - 2403104 (no ash)"]
[null,"Plant 45","MAG AA - 2403101 (no ash)","MAG AA - 2403101 (no ash)","MAG AA - 2403101 (no ash)","MAG AA - 2403101 (no ash)","MAG AA - 2403101 (no ash)"]
["added 2019","Plant 65","MAG AA - 2404122","MAG AA - 2404122","MAG AA - 2404122","MAG AA - 2404122","MAG AA - 2404122"]
[null,"Plant 67","MAG A - 2303144","MAG A - 2303144","MAG A - 2303144","MAG A - 2303144","MAG A - 2303144"]
[null,null,"MAG A - 2303141","MAG A - 2303141","MAG A - 2303141","MAG A - 2303141","MAG A - 2303141"]
[null,null,"MAG A - 2304122","MAG A - 2304122","MAG A - 2304122","MAG A - 2304122","MAG A - 2304122"]
[null,null,"MAG A - 2303104  (no ash)","MAG A - 2303104  (no ash)","MAG A - 2303104  (no ash)","MAG A - 2303104  (no ash)","MAG A - 2303104  (no ash)"]
[null,null,"MAG A - 2303101  (no ash)","MAG A - 2303101  (no ash)","MAG A - 2303101  (no ash)","MAG A - 2303101  (no ash)","MAG A - 2303101  (no ash)"]
[null,null,"MAG B - 2253131","MAG B - 2253131","MAG B - 2253131","MAG B - 2253131","MAG B - 2253131"]
[null,null,"MAG B - 2253134","MAG B - 2253134","MAG B - 2253134","MAG B - 2253134","MAG B - 2253134"]
[null,null,"MAG B - 2253101  (no ash)","MAG B - 2253101  (no ash)","MAG B - 2253101  (no ash)","MAG B - 2253101  (no ash)","MAG B - 2253101  (no ash)"]
[null,null,"MAG B - 2253104  (no ash)","MAG B - 2253104  (no ash)","MAG B - 2253104  (no ash)","MAG B - 2253104  (no ash)","MAG B - 2253104  (no ash)"]
[null,null,"MAG B - 2254122","MAG B - 2254122","MAG B - 2254122","MAG B - 2254122","MAG B - 2254122"]
[null,null,"MAG C - 2203131","MAG C - 2203131","MAG C - 2203131","MAG C - 2203131","MAG C - 2203131"]
[null,null,"MAG C - 2203134","MAG C - 2203134","MAG C - 2203134","MAG C - 2203134","MAG C - 2203134"]
[null,null,"PHCLSM1 1/2","PHCLSM1 1/2","PHCLSM1 1/2","PHCLSM1 1/2","PHCLSM1 1/2"]
[null,null,"PHCLSM1","PHCLSM1","PHCLSM1","PHCLSM1","PHCLSM1"]
[null,null,"PHCLSM1/2","PHCLSM1/2","PHCLSM1/2","PHCLSM1/2","PHCLSM1/2"]
[]
[]
[null,"Rock Solid","MAG AA - A4046","MAG AA - A4046","MAG AA - A4046","MAG AA - A4046","MAG AA - A4046"]
[null,"Plant 1 Chandler","MAG AA - A4040P","MAG AA - A4040P","MAG AA - A4040P","MAG AA - A4040P","MAG AA - A4040P"]
[null,"Plant 2 Sun City","MAG AA - A4040","MAG AA - A4040","MAG AA - A4040","MAG AA - A4040","MAG AA - A4040"]
[null,"Plant 5 Mesa","MAG AA - A4041  (no ash)","MAG AA - A4041  (no ash)","MAG AA - A4041  (no ash)","MAG AA - A4041  (no ash)","MAG AA - A4041  (no ash)"]
[null,"Plant 6 Laveen","MAG A - A3046","MAG A - A3046","MAG A - A3046","MAG A - A3046","MAG A - A3046"]
[null,"Plant 10 Laveen","MAG A - A3040P","MAG A - A3040P","MAG A - A3040P","MAG A - A3040P","MAG A - A3040P"]
[null,null,"MAG A - A3040","MAG A - A3040","MAG A - A3040","MAG A - A3040","MAG A - A3040"]
[null,null,"MAG A - A3041  (no ash)","MAG A - A3041  (no ash)","MAG A - A3041  (no ash)","MAG A - A3041  (no ash)","MAG A - A3041  (no ash)"]
[null,null,"MAG B - A2546","MAG B - A2546","MAG B - A2546","MAG B - A2546","MAG B - A2546"]
[null,null,"MAG B - A2540P","MAG B - A2540P","MAG B - A2540P","MAG B - A2540P","MAG B - A2540P"]
[null,null,"MAG B - A2540","MAG B - A2540","MAG B - A2540","MAG B - A2540","MAG B - A2540"]
[null,null,"MAG B - A2541  (no ash)","MAG B - A2541  (no ash)","MAG B - A2541  (no ash)","MAG B - A2541  (no ash)","MAG B - A2541  (no ash)"]
[null,null,"MAG C - A2040","MAG C - A2040","MAG C - A2040","MAG C - A2040","MAG C - A2040"]
[null,null,"PHCLSM1/2 (A1050)","PHCLSM1/2 (A1050)","PHCLSM1/2 (A1050)","PHCLSM1/2 (A1050)","PHCLSM1/2 (A1050)"]
[null,null,"PHCSLM 1 (A1100)","PHCSLM 1 (A1100)","PHCSLM 1 (A1100)","PHCSLM 1 (A1100)","PHCSLM 1 (A1100)"]
[null,null,"PHCLSM 1 1/2 (A1150) w/ash","PHCLSM 1 1/2 (A1150) w/ash","PHCLSM 1 1/2 (A1150) w/ash","PHCLSM 1 1/2 (A1150) w/ash","PHCLSM 1 1/2 (A1150) w/ash"]
[null,null,"2 sack (A1200) w/ash","2 sack (A1200) w/ash","2 sack (A1200) w/ash","2 sack (A1200) w/ash","2 sack (A1200) w/ash"]

{"sheet":"Asphalt","index":4,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Asphalt","Hanson Asphalt",null,"PMAR Asphalt","Hanson Asphalt TR",null,"SBS Asphalt","Hanson Asphalt SBS"]
["Hanson Asphalt","Higley Plant 34","AZ3425PH A 1 1/2\" 4.3%","Hanson Asphalt TR","Higley_34","AZ3412TRPH TR 6.0 HV","Hanson Asphalt SBS","Higley34","3412TRPHSBS 6.0 HV"]
["Southwest Asphalt","Broadway Plant 35","AZ3419PH C 3/4\" 5.0%","Southwest Asphalt TR","Broadway Plant_35","AZ3412TRPL TR 6.2 LV","Southwest Asphalt SBS","Broadway35","3412TRPLSBS 6.2 LV"]
["Vulcan Asphalt",null,"AZ3419PL C 3/4\" 5.5%","Vulcan Asphalt TR",null,"AZ3512TRPH TR 6.0 HV","Vulcan Asphalt SBS",null,"3512TRPHSBS 6.0 HV"]
["Solterra Materials LLC",null,"AZ3412PH D 1/2\" 5.1%","Solterra Asphalt TR",null,"AZ3512TRPL TR 6.2 LV","Solterra Asphalt SBS",null,"3512TRPLSBS 6.2 LV"]
[null,null,"AZ3412PL D 1/2\" 5.6%"]
[null,null,"AZ3525PH A 1 1/2\" 4.3%",null,"Southwest Asphalt TR",null,null,"Southwest Asphalt SBS"]
[null,null,"AZ3519PH C 3/4\" 5.0%",null,"El Mirage_4","422CTZ TR 6.0 HV",null,"El Mirage 4","422CTS SBS 6.0 HV"]
[null,null,"AZ3519PL C 3/4\" 5.5%",null,"New River_10","422DTZ TR 6.2 LV",null,"New River 10","422DTS SBS 6.2 LV"]
[null,null,"AZ3512PH D 1/2\" 5.1%",null,null,"122CTZ TR 6.0 HV",null,null,"122CTS SBS 6.0 HV"]
[null,null,"AZ3512PL D 1/2\" 5.6%",null,null,"122DTZ TR 6.2 LV",null,null,"122DTS SBS 6.2 LV"]
[]
[null,"Southwest Asphalt",null,null,"Vulcan Asphalt TR",null,null,"Vulcan Asphalt SBS"]
[null,"El Mirage Plant 4","452CH A 1 1/2\" 4.3%",null,"Plant_19th Ave","38641H TR 6.0 HV",null,"Plant_19th Avenue","38311H SBS 6.0 HV"]
[null,"New River Plant 10","432CH C 3/4\" 5.0%",null,"W. 43rd Ave._117","38642H TR 6.2 LV",null,null,"38312H SBS 6.2 LV"]
[null,null,"432DH C 3/4\" 5.5%",null,null,"38641D TR 6.0 HV"]
[null,null,"422CH D 1/2\" 5.1%",null,null,"38642D TR 6.2 LV",null,"Solterra Asphalt SBS"]
[null,null,"422DH D 1/2\" 5.6%",null,null,null,null,"Kilauea_Plant","S20-2-2 SBS 5.7"]
[null,null,"152CH A 1 1/2\" 4.3%",null,"Solterra Asphalt TR",null,null,null,"S20-2-2V SBS 5.7"]
[null,null,"132CH C 3/4\" 5.0%",null,"Kilauea","S20-2-1 TR 5.7"]
[null,null,"132DH C 3/4\" 5.5%",null,"Coolidge","S20-2-6 TR 5.7"]
[null,null,"122CH D 1/2\" 5.1%",null,null,"S20-1-3 TR 6.3"]
[null,null,"122DH D 1/2\" 5.6%"]
[]
[null,"Vulcan Asphalt"]
[null,"Gomez","18151G A 1 1/2\" 4.3%"]
[null,"Plant_19th Ave.","28151G C 3/4\" 5.0%"]
[null,"Plant 117 43rd Ave.","28152G C 3/4\" 5.5%"]
[null,"Plant 130 Sun City","38151G D 1/2\" 5.1%"]
[null,"W. Broadway","38152G D 1/2\" 5.6%"]
[null,"Vulcan Deer Valley","18151H A 1 1/2\" 4.3%"]
[null,null,"28151H C 3/4\" 5.0%"]
[null,null,"28152H C 3/4\" 5.5%"]
[null,null,"38151H D 1/2\" 5.1%"]
[null,null,"38152H D 1/2\" 5.6%"]
[null,null,"18151D A 1 1/2\" 4.3%"]
[null,null,"28151D C 3/4\" 5.0%"]
[null,null,"28152D C 3/4\" 5.5%"]
[null,null,"38151D D 1/2\" 5.1%"]
[null,null,"38152D D 1/2\" 5.6%"]
[null,null,"18151S A 1 1/2\" 4.3%"]
[null,null,"28151S C 3/4\" 5.0%"]
[null,null,"28152S C 3/4\" 5.5%"]
[null,null,"38151S D 1/2\" 5.1%"]
[null,null,"38152S D 1/2\" 5.6%"]
[null,null,"18151W A 1 1/2\" 4.3%"]
[null,null,"28151W C 3/4\" 5.0%"]
[null,null,"28152W C 3/4\" 5.5%"]
[null,null,"38151W D 1/2\" 5.1%"]
[null,null,"38152W D 1/2\" 5.6%"]
[null,null,"18151K A 1 1/2\" 4.3%"]
[null,null,"28151K C 3/4\" 5.0%"]
[null,null,"28152K C 3/4\" 5.5%"]
[null,null,"38151K D 1/2\" 5.1%"]
[null,null,"38152K D 1/2\" 5.6%"]
[]
[null,"Solterra Materials LLC"]
[null,"Kilauea Plant","S19-2-16H C 3/4\" 5.0%"]
[null,"Coolidge Plant","S19-2-16L C 3/4\" 5.5%"]
[null,null,"S19-2-16LV-H C 3/4\" 5.5%"]
[null,null,"S19-2-17H D 1/2\" 5.1%"]
[null,null,"S19-2-17L D 1/2\" 5.6%"]
[null,null,"S19-1-16 D 1/2\" 5.1%"]
[null,null,"S19-1-16L D 1/2\" 5.6%"]