{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Pick Lists","Plant Inspection","Loose Mix","Density","LongDensity","Properties","Help","Summary"],"not_rendered":{"charts":0,"images":40,"macros":1,"external_links":0,"defined_names":25,"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":"Menu","index":0,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,1,7,5],[12,1,12,5],[9,6,9,10],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5]]}
[]
[]
[]
[]
[]
[]
[]
["Date"]
["Mix #"]
["Lot #",null,null,null,null,null,"Sublot Designations:",null,null,null,null,"A","B","C","D"]
["Contract",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drum Plant"]
["Job ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch Plant"]
["Route"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample Types"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name ","Code"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QA Quality Management","QA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC Contractor Data","QCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA Contractor and MoDOT Data","QCQA"]

{"sheet":"Pick Lists","index":1,"n_rows":450,"n_cols":11,"rows_kept":450,"cut":false,"hidden":false,"merged":[]}
["Plant Identification",{"$f":"COUNTIF(A3:A400,\"<> - \")","v":398},null,null,null,null,null,"Mixture Types"]
[null,null,null,null,null,null,null,"New",null,"Old"]
[{"$f":"B3&\" - \"&C3","v":"Producer Supplier Name - Plant ID"},"Producer Supplier Name","Plant ID","Plant Type","Producer Supplier Code","Status",null,"Material Short Name","Material Code","Material Short NameO","Material Code"]
["APAC - Asphalt Plants  - Agency         ","APAC - Asphalt Plants ","Agency         ","3176700025     ","DRUM","A   ",null,"Asphalt Stab PB","0302PBAS","Asphalt Stab PB","0302PBAS"]
["APAC - Asphalt Plants  - Auxvasse       ","APAC - Asphalt Plants ","Auxvasse       ","3176700025     ","DRUM","A   ",null,"Comm Mix PMBB","0401BPCMBB","Comm Mix PMBB","0401BPCMBB"]
["APAC - Asphalt Plants  - Bear Hollow    ","APAC - Asphalt Plants ","Bear Hollow    ","3176700025     ","DRUM","A   ",null,"Comm Mix PMBP","0401BPCMBP","Comm Mix PMBP","0401BPCMBP"]
["APAC - Asphalt Plants  - Boonville      ","APAC - Asphalt Plants ","Boonville      ","3176700025     ","DRUM","A   ",null,"Micro-Surfacing T2","0413MST2","Commercial Mix PMBP","0401BPCM"]
["APAC - Asphalt Plants  - Branson        ","APAC - Asphalt Plants ","Branson        ","3176700025     ","DRUM","A   ",null,"Micro-Surfacing T3","0413MST3","Plant Mix Bit Base","0301SBBI"]
["APAC - Asphalt Plants  - Brookfield     ","APAC - Asphalt Plants ","Brookfield     ","3176700025     ","DRUM","A   ",null,"Plt Mix Bit Base","0401BPPMBB","Plt Mix for BP-1","0401BPPMBP..1"]
["APAC - Asphalt Plants  - Butler         ","APAC - Asphalt Plants ","Butler         ","3176700025     ","DRUM","A   ",null,"Plt Mix for BP-1","0401BPPMBP..1","Plt Mix for BP-2","0401BPPMBP..2"]
["APAC - Asphalt Plants  - Cameron        ","APAC - Asphalt Plants ","Cameron        ","3176700025     ","DRUM","A   ",null,"Plt Mix for BP-2","0401BPPMBP..2","Plt Mix for BP-3","0401BPPMBP..3"]
["APAC - Asphalt Plants  - Chesapeake     ","APAC - Asphalt Plants ","Chesapeake     ","3176700025     ","DRUM","A   ",null,"Plt Mix for BP-3","0401BPPMBP..3","Plt Mix for Surf Lev","0402SLPMSL"]
["APAC - Asphalt Plants  - Cole Camp      ","APAC - Asphalt Plants ","Cole Camp      ","3176700025     ","DRUM","A   ",null,"Plt Mix for Surf Lev","0402SLPMSL","Plt Mx Srf Lvl Slag","0402SLPMWS"]
["APAC - Asphalt Plants  - Cole Camp-2    ","APAC - Asphalt Plants ","Cole Camp-2    ","3176700025     ","DRUM","A   ",null,"Plt Mx Srf Lvl Slag","0402SLPMWS","SP125 HB","0403SP125HB"]
["APAC - Asphalt Plants  - Danville       ","APAC - Asphalt Plants ","Danville       ","3176700025     ","DRUM","A   ",null,"SP048 F","0403SP048F","SP125 HB - SM","0403SP125HBSM"]
["APAC - Asphalt Plants  - Dresden        ","APAC - Asphalt Plants ","Dresden        ","3176700025     ","DRUM","A   ",null,"SP048 FLP","0403SP048FLP","SP125 HB w/LP","0403SP125HBLP"]
["APAC - Asphalt Plants  - Edina          ","APAC - Asphalt Plants ","Edina          ","3176700025     ","DRUM","A   ",null,"SP095 B","0403SP095B","SP125 MC","0403SP125MC"]
["APAC - Asphalt Plants  - El Dorado Sprng","APAC - Asphalt Plants ","El Dorado Sprng","3176700025     ","DRUM","A   ",null,"SP095 BSM","0403SP095BSM","SP125 MC w/LP","0403SP125MCLP"]
["APAC - Asphalt Plants  - Harrisonville  ","APAC - Asphalt Plants ","Harrisonville  ","3176700025     ","DRUM","A   ",null,"SP095 BSM R","0403SP095BSMR","SP125 LD","0403SP125LD"]
["APAC - Asphalt Plants  - Harrisonville-2","APAC - Asphalt Plants ","Harrisonville-2","3176700025     ","DRUM","A   ",null,"SP095 C","0403SP095C","SP125 LD - SM","0403SP125LDSM"]
["APAC - Asphalt Plants  - Higginsville   ","APAC - Asphalt Plants ","Higginsville   ","3176700025     ","DRUM","A   ",null,"SP095 C 80Gyro","0403SP095CLG","SP125 LD w/LP","0403SP125LDLP"]
["APAC - Asphalt Plants  - Holts Summit   ","APAC - Asphalt Plants ","Holts Summit   ","3176700025     ","DRUM","A   ",null,"SP095 CLP 80Gyro","0403SP095CLGLP","SP125 MC","0403SP125MC"]
["APAC - Asphalt Plants  - Jasper         ","APAC - Asphalt Plants ","Jasper         ","3176700025     ","DRUM","A   ",null,"SP095 E","0403SP095E","SP125 MC - SM","0403SP125MCSM"]
["APAC - Asphalt Plants  - Joplin         ","APAC - Asphalt Plants ","Joplin         ","3176700025     ","DRUM","A   ",null,"SP125 B","0403SP125B","SP190 HB","0403SP190HB"]
["APAC - Asphalt Plants  - Kirksville     ","APAC - Asphalt Plants ","Kirksville     ","3176700025     ","DRUM","A   ",null,"SP125 BLP","0403SP125BLP","SP190 MC","0403SP190MC"]
["APAC - Asphalt Plants  - Lamar          ","APAC - Asphalt Plants ","Lamar          ","3176700025     ","DRUM","A   ",null,"SP125 BSM","0403SP125BSM","SP190 LE","0403SP190LE"]
["APAC - Asphalt Plants  - Linn           ","APAC - Asphalt Plants ","Linn           ","3176700025     ","DRUM","A   ",null,"SP125 BSM R","0403SP125BSMR","SP190 LD","0403SP190LD"]
["APAC - Asphalt Plants  - Linn Creek     ","APAC - Asphalt Plants ","Linn Creek     ","3176700025     ","DRUM","A   ",null,"SP125 C","0403SP125C","SP250 HB","0403SP250HB"]
["APAC - Asphalt Plants  - Linn Creek #2  ","APAC - Asphalt Plants ","Linn Creek #2  ","3176700025     ","DRUM","A   ",null,"SP125 C 80Gyro","0403SP125CLG","SP250 MC","0403SP250MC"]
["APAC - Asphalt Plants  - Loose Creek    ","APAC - Asphalt Plants ","Loose Creek    ","3176700025     ","DRUM","A   ",null,"SP125 CLP","0403SP125CLP","SP250 LE","0403SP250LE"]
["APAC - Asphalt Plants  - Louisburg, KS  ","APAC - Asphalt Plants ","Louisburg, KS  ","3176700025     ","DRUM","A   ",null,"SP125 CLP 80Gyro","0403SP125CLGLP","SP250 LD","0403SP250LD"]
["APAC - Asphalt Plants  - Macon          ","APAC - Asphalt Plants ","Macon          ","3176700025     ","DRUM","A   ",null,"SP190 B","0403SP190B","SP250 MC","0403SP250MC"]
["APAC - Asphalt Plants  - Mansfield      ","APAC - Asphalt Plants ","Mansfield      ","3176700025     ","DRUM","A   ",null,"SP190 C","0403SP190C","SP250 MD","0403SP250MD"]
["APAC - Asphalt Plants  - Marshall       ","APAC - Asphalt Plants ","Marshall       ","3176700025     ","DRUM","A   ",null,"SP190 C 80Gyro","0403SP190CLG","Ultra Thn Type A","0413UBWSACTA"]
[{"$f":"B35&\" - \"&C35","v":"APAC - Asphalt Plants  - Millersb2      "},"APAC - Asphalt Plants ","Millersb2      ","3176700025     ","DRUM","A   ",null,"SP190 E","0403SP190E","Ultra Thn Type B","0413UBWSACTB"]
["APAC - Asphalt Plants  - Montevallo     ","APAC - Asphalt Plants ","Montevallo     ","3176700025     ","DRUM","A   ",null,"SP250 B","0403SP250B","Ultra Thn Type C","0413UBWSACTC"]
["APAC - Asphalt Plants  - Mound City     ","APAC - Asphalt Plants ","Mound City     ","3176700025     ","DRUM","A   ",null,"SP250 C","0403SP250C"]
["APAC - Asphalt Plants  - Mt. Airy       ","APAC - Asphalt Plants ","Mt. Airy       ","3176700025     ","BATC","A   ",null,"SP250 C 80Gyro","0403SP250CLG"]
["APAC - Asphalt Plants  - Osage Beach    ","APAC - Asphalt Plants ","Osage Beach    ","3176700025     ","DRUM","A   ",null,"SP250 E","0403SP250E"]
["APAC - Asphalt Plants  - Purdy          ","APAC - Asphalt Plants ","Purdy          ","3176700025     ","DRUM","A   ",null,"Ultra Thn Type A","0413UBWSACTA"]
["APAC - Asphalt Plants  - Quinn          ","APAC - Asphalt Plants ","Quinn          ","3176700025     ","DRUM","A   ",null,"Ultra Thn Type B","0413UBWSACTB"]
["APAC - Asphalt Plants  - Rayville       ","APAC - Asphalt Plants ","Rayville       ","3176700025     ","DRUM","A   ",null,"Ultra Thn Type C","0413UBWSACTC"]
["APAC - Asphalt Plants  - Rocky Fork     ","APAC - Asphalt Plants ","Rocky Fork     ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Sereno         ","APAC - Asphalt Plants ","Sereno         ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Springfield    ","APAC - Asphalt Plants ","Springfield    ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Stanley, KS    ","APAC - Asphalt Plants ","Stanley, KS    ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Sugar Creek 430","APAC - Asphalt Plants ","Sugar Creek 430","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Tipton         ","APAC - Asphalt Plants ","Tipton         ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Warsaw         ","APAC - Asphalt Plants ","Warsaw         ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Waverly        ","APAC - Asphalt Plants ","Waverly        ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Westphalia     ","APAC - Asphalt Plants ","Westphalia     ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Wheatland      ","APAC - Asphalt Plants ","Wheatland      ","3176700025     ","DRUM","A   "]
["APAC - Asphalt Plants  - Willard        ","APAC - Asphalt Plants ","Willard        ","3176700025     ","DRUM","A   "]
["ASA Asphalt Inc. - Advance        ","ASA Asphalt Inc.","Advance        ","3241300220     ","DRUM","A   "]
["Apex Paving Co. (Girardeau Contractors) - Cape Girardeau ","Apex Paving Co. (Girardeau Contractors)","Cape Girardeau ","3200700120     ","BATC","A   "]
["Apex Paving Co. (Girardeau Contractors) - Dexter         ","Apex Paving Co. (Girardeau Contractors)","Dexter         ","3200700120     ","BATC","A   "]
["Apex Paving Co. (Girardeau Contractors) - PoplarBluff    ","Apex Paving Co. (Girardeau Contractors)","PoplarBluff    ","3200700120     ","DRUM","A   "]
["Blevins Asphalt Construction - Brookline      ","Blevins Asphalt Construction","Brookline      ","3132800027     ","DRUM","A   "]
["Blevins Asphalt Construction - Carmar         ","Blevins Asphalt Construction","Carmar         ","3132800027     ","DRUM","A   "]
["Blevins Asphalt Construction - Carthage       ","Blevins Asphalt Construction","Carthage       ","3132800027     ","DRUM","A   "]
["Blevins Asphalt Construction - Republic       ","Blevins Asphalt Construction","Republic       ","3132800027     ","DRUM","A   "]
["Bross Construction, Asphalt - Amazonia       ","Bross Construction, Asphalt","Amazonia       ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Arcadia Valley ","Bross Construction, Asphalt","Arcadia Valley ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Ashley         ","Bross Construction, Asphalt","Ashley         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Auburn         ","Bross Construction, Asphalt","Auburn         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Auxvasse       ","Bross Construction, Asphalt","Auxvasse       ","3008600023     ","DRUM","A   "]
[{"$f":"B67&\" - \"&C67","v":"Bross Construction, Asphalt - Barber         "},"Bross Construction, Asphalt","Barber         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Bates City     ","Bross Construction, Asphalt","Bates City     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Bloomsdale     ","Bross Construction, Asphalt","Bloomsdale     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Blue Mound     ","Bross Construction, Asphalt","Blue Mound     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Boliver        ","Bross Construction, Asphalt","Boliver        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Bonne Terre    ","Bross Construction, Asphalt","Bonne Terre    ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Boonville      ","Bross Construction, Asphalt","Boonville      ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Butler         ","Bross Construction, Asphalt","Butler         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Canton         ","Bross Construction, Asphalt","Canton         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Concordia      ","Bross Construction, Asphalt","Concordia      ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Cooper         ","Bross Construction, Asphalt","Cooper         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Corning        ","Bross Construction, Asphalt","Corning        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Danville       ","Bross Construction, Asphalt","Danville       ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Edina          ","Bross Construction, Asphalt","Edina          ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - El Dorado      ","Bross Construction, Asphalt","El Dorado      ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Elk Prair(Rolla","Bross Construction, Asphalt","Elk Prair(Rolla","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Elm            ","Bross Construction, Asphalt","Elm            ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Ely            ","Bross Construction, Asphalt","Ely            ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Ewing          ","Bross Construction, Asphalt","Ewing          ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Fairplay       ","Bross Construction, Asphalt","Fairplay       ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Fremont        ","Bross Construction, Asphalt","Fremont        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Gilliam        ","Bross Construction, Asphalt","Gilliam        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Higginsville   ","Bross Construction, Asphalt","Higginsville   ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Houstonia      ","Bross Construction, Asphalt","Houstonia      ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Huntington     ","Bross Construction, Asphalt","Huntington     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Independence   ","Bross Construction, Asphalt","Independence   ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Jane           ","Bross Construction, Asphalt","Jane           ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Laquey         ","Bross Construction, Asphalt","Laquey         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Lodi           ","Bross Construction, Asphalt","Lodi           ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Martin Marietta","Bross Construction, Asphalt","Martin Marietta","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Millersburg    ","Bross Construction, Asphalt","Millersburg    ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Moscow Mills   ","Bross Construction, Asphalt","Moscow Mills   ","3008600023     ","DRUM","A   "]
[{"$f":"B99&\" - \"&C99","v":"Bross Construction, Asphalt - Mount Airy     "},"Bross Construction, Asphalt","Mount Airy     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Mt. Grove      ","Bross Construction, Asphalt","Mt. Grove      ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - New London     ","Bross Construction, Asphalt","New London     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Old Appleton   ","Bross Construction, Asphalt","Old Appleton   ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Old Monroe     ","Bross Construction, Asphalt","Old Monroe     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Osceola        ","Bross Construction, Asphalt","Osceola        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Overton        ","Bross Construction, Asphalt","Overton        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Owensville     ","Bross Construction, Asphalt","Owensville     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Palmyra        ","Bross Construction, Asphalt","Palmyra        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Perry          ","Bross Construction, Asphalt","Perry          ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Rayville       ","Bross Construction, Asphalt","Rayville       ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Richmond       ","Bross Construction, Asphalt","Richmond       ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Rt E & I-55    ","Bross Construction, Asphalt","Rt E & I-55    ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Rte 210/291    ","Bross Construction, Asphalt","Rte 210/291    ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Scott City     ","Bross Construction, Asphalt","Scott City     ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Sedalia        ","Bross Construction, Asphalt","Sedalia        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Shelbina       ","Bross Construction, Asphalt","Shelbina       ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Taylor         ","Bross Construction, Asphalt","Taylor         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Warrensburg    ","Bross Construction, Asphalt","Warrensburg    ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Warsaw         ","Bross Construction, Asphalt","Warsaw         ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Wayland        ","Bross Construction, Asphalt","Wayland        ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Wheatland      ","Bross Construction, Asphalt","Wheatland      ","3008600023     ","DRUM","A   "]
["Bross Construction, Asphalt - Willow Springs ","Bross Construction, Asphalt","Willow Springs ","3008600023     ","DRUM","A   "]
["Christensen Asphalt Plant - Millersburg    ","Christensen Asphalt Plant","Millersburg    ","3402400125     ","DRUM","A   "]
["Delta Asphalt - Cape Girardeau ","Delta Asphalt","Cape Girardeau ","3012400020     ","BATC","A   "]
["Delta Asphalt - Caruthersville ","Delta Asphalt","Caruthersville ","3012400020     ","DRUM","A   "]
["Delta Asphalt - Dexter         ","Delta Asphalt","Dexter         ","3012400020     ","DRUM","A   "]
["Delta Asphalt - Dexter - 807   ","Delta Asphalt","Dexter - 807   ","3012400020     ","DRUM","A   "]
["Delta Asphalt - Luxora, AR     ","Delta Asphalt","Luxora, AR     ","3012400020     ","DRUM","A   "]
["Delta Asphalt - Marston        ","Delta Asphalt","Marston        ","3012400020     ","DRUM","A   "]
["Delta Asphalt - New Madrid     ","Delta Asphalt","New Madrid     ","3012400020     ","BATC","A   "]
["Delta Asphalt - Paragould, AR  ","Delta Asphalt","Paragould, AR  ","3012400020     ","BATC","A   "]
[{"$f":"B131&\" - \"&C131","v":"Delta Asphalt - Poplar Bluff   "},"Delta Asphalt","Poplar Bluff   ","3012400020     ","BATC","A   "]
["Delta Asphalt - Sikeston       ","Delta Asphalt","Sikeston       ","3012400020     ","DRUM","A   "]
["ECO Recycling Inc. - Stockpile 1    ","ECO Recycling Inc.","Stockpile 1    ","3406900116     ","FOMR","A   "]
["Fahey Constr. - Asphalt Plants - Kansas -Holiday","Fahey Constr. - Asphalt Plants","Kansas -Holiday","3056600024     ","DRUM","A   "]
["Fahey Constr. - Asphalt Plants - Kansas City    ","Fahey Constr. - Asphalt Plants","Kansas City    ","3056600024     ","DRUM","A   "]
["G & M Asphalt - Troy           ","G & M Asphalt","Troy           ","3017000023     ","DRUM","A   "]
["Herzog Asphalt - Bethany        ","Herzog Asphalt","Bethany        ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Elwood Asphalt ","Herzog Asphalt","Elwood Asphalt ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Gallatin       ","Herzog Asphalt","Gallatin       ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Maryville      ","Herzog Asphalt","Maryville      ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Nettleton      ","Herzog Asphalt","Nettleton      ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Princeton      ","Herzog Asphalt","Princeton      ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Savannah       ","Herzog Asphalt","Savannah       ","3020400021     ","DRUM","A   "]
["Herzog Asphalt - Trenton        ","Herzog Asphalt","Trenton        ","3020400021     ","DRUM","A   "]
["Higgins Asphalt & Paving - Loose Creek    ","Higgins Asphalt & Paving","Loose Creek    ","3197300125     ","DRUM","A   "]
["Hilty Asphalt - Butler         ","Hilty Asphalt","Butler         ","3020600024     ","DRUM","A   "]
["Hilty Asphalt - Montrose       ","Hilty Asphalt","Montrose       ","3020600024     ","DRUM","A   "]
["Hilty Asphalt - Tightwad       ","Hilty Asphalt","Tightwad       ","3020600024     ","DRUM","A   "]
["Hilty Asphalt - Warrensburg    ","Hilty Asphalt","Warrensburg    ","3020600024     ","DRUM","A   "]
["Hutchens Asphalt plants - Bella Vista    ","Hutchens Asphalt plants","Bella Vista    ","3021500027     ","DRUM","A   "]
["Hutchens Asphalt plants - Gravette       ","Hutchens Asphalt plants","Gravette       ","3021500027     ","DRUM","A   "]
["Hutchens Asphalt plants - Purdy          ","Hutchens Asphalt plants","Purdy          ","3021500027     ","DRUM","A   "]
["Hutchens Asphalt plants - Shell Knob     ","Hutchens Asphalt plants","Shell Knob     ","3021500027     ","DRUM","A   "]
["Ideker Asphalt - Adrian         ","Ideker Asphalt","Adrian         ","3298500021     ","DRUM","A   "]
["Ideker Asphalt - Grandview      ","Ideker Asphalt","Grandview      ","3298500021     ","DRUM","A   "]
["Ideker Asphalt - Lake Lanawana  ","Ideker Asphalt","Lake Lanawana  ","3298500021     ","DRUM","A   "]
["Ideker Asphalt - Mosby          ","Ideker Asphalt","Mosby          ","3298500021     ","DRUM","A   "]
["Ideker Asphalt - Watson         ","Ideker Asphalt","Watson         ","3298500021     ","DRUM","A   "]
["Jefferson Asphalt/A.P.I. Asphalt Products. Inc. - Highway 54     ","Jefferson Asphalt/A.P.I. Asphalt Products. Inc.","Highway 54     ","3057100025     ","DRUM","A   "]
["Jefferson Asphalt/A.P.I. Asphalt Products. Inc. - Jefferson City ","Jefferson Asphalt/A.P.I. Asphalt Products. Inc.","Jefferson City ","3057100025     ","DRUM","A   "]
["Jefferson Asphalt/A.P.I. Asphalt Products. Inc. - Jerome         ","Jefferson Asphalt/A.P.I. Asphalt Products. Inc.","Jerome         ","3057100025     ","DRUM","A   "]
["Jefferson Asphalt/A.P.I. Asphalt Products. Inc. - Loose Creek    ","Jefferson Asphalt/A.P.I. Asphalt Products. Inc.","Loose Creek    ","3057100025     ","BATC","A   "]
[{"$f":"B163&\" - \"&C163","v":"Jefferson Asphalt/A.P.I. Asphalt Products. Inc. - Rolla-Drum     "},"Jefferson Asphalt/A.P.I. Asphalt Products. Inc.","Rolla-Drum     ","3057100025     ","DRUM","A   "]
["Jefferson Asphalt/A.P.I. Asphalt Products. Inc. - Sullivan       ","Jefferson Asphalt/A.P.I. Asphalt Products. Inc.","Sullivan       ","3057100025     ","DRUM","A   "]
["Jokerst Paving & Contracting, Inc. - Bonne Terre    ","Jokerst Paving & Contracting, Inc.","Bonne Terre    ","3281200026     ","DRUM","A   "]
["Journagan Asphalt - Aldrich        ","Journagan Asphalt","Aldrich        ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Buffalo        ","Journagan Asphalt","Buffalo        ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Butler         ","Journagan Asphalt","Butler         ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Dever          ","Journagan Asphalt","Dever          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Greenfield     ","Journagan Asphalt","Greenfield     ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Hilda          ","Journagan Asphalt","Hilda          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Hollister      ","Journagan Asphalt","Hollister      ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Jane           ","Journagan Asphalt","Jane           ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Jasper         ","Journagan Asphalt","Jasper         ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Macks Creek    ","Journagan Asphalt","Macks Creek    ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Madry          ","Journagan Asphalt","Madry          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Marshfield     ","Journagan Asphalt","Marshfield     ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - McCracken      ","Journagan Asphalt","McCracken      ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Montevallo     ","Journagan Asphalt","Montevallo     ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Nemo           ","Journagan Asphalt","Nemo           ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Neosho         ","Journagan Asphalt","Neosho         ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Ozark          ","Journagan Asphalt","Ozark          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Purdy          ","Journagan Asphalt","Purdy          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Reeds          ","Journagan Asphalt","Reeds          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Spencer        ","Journagan Asphalt","Spencer        ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Stockton       ","Journagan Asphalt","Stockton       ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Thayer         ","Journagan Asphalt","Thayer         ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Wheatland      ","Journagan Asphalt","Wheatland      ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Willow Springs ","Journagan Asphalt","Willow Springs ","3027400028     ","DRUM","A   "]
["Lead Belt Asphalt - Desloge        ","Lead Belt Asphalt","Desloge        ","3027000020     ","DRUM","A   "]
["Lead Belt Asphalt - Elvins         ","Lead Belt Asphalt","Elvins         ","3027000020     ","DRUM","A   "]
["Leavenworth Asphalt Materials, LLC - Kansas         ","Leavenworth Asphalt Materials, LLC","Kansas         ","3433100124     ","DRUM","A   "]
["Magruder Paving, LLC - Arab           ","Magruder Paving, LLC","Arab           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Auxvasse       ","Magruder Paving, LLC","Auxvasse       ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Big Spring     ","Magruder Paving, LLC","Big Spring     ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - BonneTerre     ","Magruder Paving, LLC","BonneTerre     ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Bourbon        ","Magruder Paving, LLC","Bourbon        ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Brickey Stone  ","Magruder Paving, LLC","Brickey Stone  ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Desloge        ","Magruder Paving, LLC","Desloge        ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Eldon          ","Magruder Paving, LLC","Eldon          ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Fisk           ","Magruder Paving, LLC","Fisk           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Gravois Mills  ","Magruder Paving, LLC","Gravois Mills  ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Greenville     ","Magruder Paving, LLC","Greenville     ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Havin Materials","Magruder Paving, LLC","Havin Materials","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Hayti          ","Magruder Paving, LLC","Hayti          ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - High Hill      ","Magruder Paving, LLC","High Hill      ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Holt Summit    ","Magruder Paving, LLC","Holt Summit    ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Knob Lick      ","Magruder Paving, LLC","Knob Lick      ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Lincoln        ","Magruder Paving, LLC","Lincoln        ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Linn           ","Magruder Paving, LLC","Linn           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - LinnCreek      ","Magruder Paving, LLC","LinnCreek      ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Lodi           ","Magruder Paving, LLC","Lodi           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Malden         ","Magruder Paving, LLC","Malden         ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Old Monroe     ","Magruder Paving, LLC","Old Monroe     ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Patton         ","Magruder Paving, LLC","Patton         ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Rolla          ","Magruder Paving, LLC","Rolla          ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Salem          ","Magruder Paving, LLC","Salem          ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Shelbina       ","Magruder Paving, LLC","Shelbina       ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - St. Mary       ","Magruder Paving, LLC","St. Mary       ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Stover         ","Magruder Paving, LLC","Stover         ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Troy           ","Magruder Paving, LLC","Troy           ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Union          ","Magruder Paving, LLC","Union          ","3029700023     ","DRUM","A   "]
["Mid Missouri Asphalt - St. Clair      ","Mid Missouri Asphalt","St. Clair      ","3261500026     ","BATC","A   "]
["Mineral Area Asphalt, Bonne Terre - Bonne Terre    ","Mineral Area Asphalt, Bonne Terre","Bonne Terre    ","3271900020     ","DRUM","A   "]
["N.B. West Asphalt - Bourbon        ","N.B. West Asphalt","Bourbon        ","3116900026     ","BATC","A   "]
["N.B. West Asphalt - Cuba           ","N.B. West Asphalt","Cuba           ","3116900026     ","DRUM","A   "]
[{"$f":"B227&\" - \"&C227","v":"N.B. West Asphalt - House Springs  "},"N.B. West Asphalt","House Springs  ","3116900026     ","DRUM","A   "]
["N.B. West Asphalt - Pacific        ","N.B. West Asphalt","Pacific        ","3116900026     ","DRUM","A   "]
["N.B. West Asphalt - Rolla          ","N.B. West Asphalt","Rolla          ","3116900026     ","DRUM","A   "]
["Norris Asphalt Paving - Bethany        ","Norris Asphalt Paving","Bethany        ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Maryville      ","Norris Asphalt Paving","Maryville      ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Princeton      ","Norris Asphalt Paving","Princeton      ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Trenton        ","Norris Asphalt Paving","Trenton        ","3062100021     ","DRUM","A   "]
["Pace Construction, Asphalt  - Antonia        ","Pace Construction, Asphalt ","Antonia        ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Ashley         ","Pace Construction, Asphalt ","Ashley         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Burfordville   ","Pace Construction, Asphalt ","Burfordville   ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Danville       ","Pace Construction, Asphalt ","Danville       ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - Doniphan       ","Pace Construction, Asphalt ","Doniphan       ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Eminence       ","Pace Construction, Asphalt ","Eminence       ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Eureka         ","Pace Construction, Asphalt ","Eureka         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Florrisant     ","Pace Construction, Asphalt ","Florrisant     ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Florrisant-Sand","Pace Construction, Asphalt ","Florrisant-Sand","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Houston        ","Pace Construction, Asphalt ","Houston        ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Jackson        ","Pace Construction, Asphalt ","Jackson        ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Jerome         ","Pace Construction, Asphalt ","Jerome         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Moscow Mills   ","Pace Construction, Asphalt ","Moscow Mills   ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Patterson      ","Pace Construction, Asphalt ","Patterson      ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Potosi         ","Pace Construction, Asphalt ","Potosi         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Salem          ","Pace Construction, Asphalt ","Salem          ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Sereno         ","Pace Construction, Asphalt ","Sereno         ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - St. Charles    ","Pace Construction, Asphalt ","St. Charles    ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - St. Louis      ","Pace Construction, Asphalt ","St. Louis      ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - Thayer         ","Pace Construction, Asphalt ","Thayer         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Van Buren      ","Pace Construction, Asphalt ","Van Buren      ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Warrenton      ","Pace Construction, Asphalt ","Warrenton      ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - West Plains    ","Pace Construction, Asphalt ","West Plains    ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Willow Springs ","Pace Construction, Asphalt ","Willow Springs ","3035900026     ","DRUM","A   "]
["Rolla Asphalt - Cuba           ","Rolla Asphalt","Cuba           ","3410800029     ","DRUM","A   "]
["Rolla Asphalt - Rolla          ","Rolla Asphalt","Rolla          ","3410800029     ","DRUM","A   "]
["Simpson Construction Materials, Asphalt - ValleyPark     ","Simpson Construction Materials, Asphalt","ValleyPark     ","3042400326     ","DRUM","A   "]
["Superior Bowen Asphalt - 38th St North  ","Superior Bowen Asphalt","38th St North  ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Ferrelview     ","Superior Bowen Asphalt","Ferrelview     ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Hickman Mills  ","Superior Bowen Asphalt","Hickman Mills  ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - KCI            ","Superior Bowen Asphalt","KCI            ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Lee s S-Barber ","Superior Bowen Asphalt","Lee s S-Barber ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Lee s S-Colburn","Superior Bowen Asphalt","Lee s S-Colburn","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Manchester     ","Superior Bowen Asphalt","Manchester     ","3056900024     ","DRUM","A   "]
["Swift Asphalt, Joplin - Joplin         ","Swift Asphalt, Joplin","Joplin         ","3132700027     ","BATC","A   "]
["W. L. Miller Asphalt - Hamilton       ","W. L. Miller Asphalt","Hamilton       ","3048700023     ","BATC","A   "]
["W. L. Miller Asphalt - Kahoka         ","W. L. Miller Asphalt","Kahoka         ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - Kirksville     ","W. L. Miller Asphalt","Kirksville     ","3048700023     ","BATC","A   "]
["W. L. Miller Asphalt - Kirksville     ","W. L. Miller Asphalt","Kirksville     ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - MonroeCity     ","W. L. Miller Asphalt","MonroeCity     ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - Paris          ","W. L. Miller Asphalt","Paris          ","3048700023     ","DRUM","A   "]
["Weber Asphalt plants - Festus         ","Weber Asphalt plants","Festus         ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - Fredericktown  ","Weber Asphalt plants","Fredericktown  ","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - I-55 @ St.Louis","Weber Asphalt plants","I-55 @ St.Louis","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - Kingshighway   ","Weber Asphalt plants","Kingshighway   ","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - Missouri Valley","Weber Asphalt plants","Missouri Valley","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - North (New)    ","Weber Asphalt plants","North (New)    ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - North (Old)    ","Weber Asphalt plants","North (Old)    ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - O Fallon       ","Weber Asphalt plants","O Fallon       ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - Pevely         ","Weber Asphalt plants","Pevely         ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - South (old)    ","Weber Asphalt plants","South (old)    ","3016400026     ","BATC","A   "]
["Willard Constr. Asphalt Plants - Sleeper        ","Willard Constr. Asphalt Plants","Sleeper        ","3050100028     ","DRUM","A   "]
["Willard Constr. Asphalt Plants - St. Roberts    ","Willard Constr. Asphalt Plants","St. Roberts    ","3050100028     ","DRUM","A   "]
["Journagan Asphalt - Ozark          ","Journagan Asphalt","Ozark          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Purdy          ","Journagan Asphalt","Purdy          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Reeds          ","Journagan Asphalt","Reeds          ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Reeds Spring   ","Journagan Asphalt","Reeds Spring   ","3027400028     ","DRUM","I   "]
[{"$f":"B291&\" - \"&C291","v":"Journagan Asphalt - Spencer        "},"Journagan Asphalt","Spencer        ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Stockton       ","Journagan Asphalt","Stockton       ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Thayer         ","Journagan Asphalt","Thayer         ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Wheatland      ","Journagan Asphalt","Wheatland      ","3027400028     ","DRUM","A   "]
["Journagan Asphalt - Willow Springs ","Journagan Asphalt","Willow Springs ","3027400028     ","DRUM","A   "]
["Lafarge Asphalt Plants - Dresden        ","Lafarge Asphalt Plants","Dresden        ","3026600025     ","BATC","I   "]
["Lead Belt Asphalt - Desloge        ","Lead Belt Asphalt","Desloge        ","3027000020     ","DRUM","A   "]
["Lead Belt Asphalt - Elvins         ","Lead Belt Asphalt","Elvins         ","3027000020     ","DRUM","A   "]
["Leavenworth Asphalt Materials, LLC - Kansas         ","Leavenworth Asphalt Materials, LLC","Kansas         ","3433100124     ","DRUM","A   "]
["Magruder Paving, LLC - Arab           ","Magruder Paving, LLC","Arab           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Auxvasse       ","Magruder Paving, LLC","Auxvasse       ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Big Spring     ","Magruder Paving, LLC","Big Spring     ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Bourbon        ","Magruder Paving, LLC","Bourbon        ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Brickey Stone  ","Magruder Paving, LLC","Brickey Stone  ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Eldon          ","Magruder Paving, LLC","Eldon          ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Fisk           ","Magruder Paving, LLC","Fisk           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Gravois Mills  ","Magruder Paving, LLC","Gravois Mills  ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Greenville     ","Magruder Paving, LLC","Greenville     ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Hayti          ","Magruder Paving, LLC","Hayti          ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Holt Summit    ","Magruder Paving, LLC","Holt Summit    ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Knob Lick      ","Magruder Paving, LLC","Knob Lick      ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Linn           ","Magruder Paving, LLC","Linn           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Lodi           ","Magruder Paving, LLC","Lodi           ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Malden         ","Magruder Paving, LLC","Malden         ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Old Monroe     ","Magruder Paving, LLC","Old Monroe     ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Patton         ","Magruder Paving, LLC","Patton         ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Rolla          ","Magruder Paving, LLC","Rolla          ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Salem          ","Magruder Paving, LLC","Salem          ","3029700023     ","DRUM","A   "]
["Magruder Paving, LLC - Shelbina       ","Magruder Paving, LLC","Shelbina       ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Troy           ","Magruder Paving, LLC","Troy           ","3029700023     ","BATC","A   "]
["Magruder Paving, LLC - Union          ","Magruder Paving, LLC","Union          ","3029700023     ","DRUM","A   "]
["Mid Missouri Asphalt - St. Clair      ","Mid Missouri Asphalt","St. Clair      ","3261500026     ","BATC","A   "]
["Mineral Area Asphalt, Bonne Terre - Bonne Terre    ","Mineral Area Asphalt, Bonne Terre","Bonne Terre    ","3271900020     ","DRUM","A   "]
["N.B. West Asphalt - Bourbon        ","N.B. West Asphalt","Bourbon        ","3116900026     ","BATC","A   "]
["N.B. West Asphalt - Cuba           ","N.B. West Asphalt","Cuba           ","3116900026     ","DRUM","A   "]
["N.B. West Asphalt - Desloge        ","N.B. West Asphalt","Desloge        ","3116900026     ","DRUM","I   "]
["N.B. West Asphalt - House Springs  ","N.B. West Asphalt","House Springs  ","3116900026     ","DRUM","A   "]
["N.B. West Asphalt - Owensville     ","N.B. West Asphalt","Owensville     ","3116900026     ","DRUM","I   "]
["N.B. West Asphalt - Pacific        ","N.B. West Asphalt","Pacific        ","3116900026     ","DRUM","A   "]
["N.B. West Asphalt - Rolla          ","N.B. West Asphalt","Rolla          ","3116900026     ","DRUM","A   "]
["N.B. West Asphalt - Warrenton      ","N.B. West Asphalt","Warrenton      ","3116900026     ","DRUM","I   "]
["Norris Asphalt Paving - Bethany        ","Norris Asphalt Paving","Bethany        ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Blue Mound     ","Norris Asphalt Paving","Blue Mound     ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Corning AC     ","Norris Asphalt Paving","Corning AC     ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Craig          ","Norris Asphalt Paving","Craig          ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Gallatin       ","Norris Asphalt Paving","Gallatin       ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Graham         ","Norris Asphalt Paving","Graham         ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Jct I-29 &Rt111","Norris Asphalt Paving","Jct I-29 &Rt111","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Jct I-35 & Rt 6","Norris Asphalt Paving","Jct I-35 & Rt 6","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Maitland       ","Norris Asphalt Paving","Maitland       ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Maryville      ","Norris Asphalt Paving","Maryville      ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Mercer         ","Norris Asphalt Paving","Mercer         ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Milan          ","Norris Asphalt Paving","Milan          ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Nettleton      ","Norris Asphalt Paving","Nettleton      ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - New Point      ","Norris Asphalt Paving","New Point      ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Paris          ","Norris Asphalt Paving","Paris          ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Princeton      ","Norris Asphalt Paving","Princeton      ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Queen City     ","Norris Asphalt Paving","Queen City     ","3062100021     ","DRUM","I   "]
["Norris Asphalt Paving - Trenton        ","Norris Asphalt Paving","Trenton        ","3062100021     ","DRUM","A   "]
["Norris Asphalt Paving - Winston        ","Norris Asphalt Paving","Winston        ","3062100021     ","DRUM","I   "]
["Pace Construction, Asphalt  - Antonia        ","Pace Construction, Asphalt ","Antonia        ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Ashley         ","Pace Construction, Asphalt ","Ashley         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Burfordville   ","Pace Construction, Asphalt ","Burfordville   ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Chesterfield   ","Pace Construction, Asphalt ","Chesterfield   ","3035900026     ","DRUM","I   "]
[{"$f":"B355&\" - \"&C355","v":"Pace Construction, Asphalt  - Danville       "},"Pace Construction, Asphalt ","Danville       ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - Danville2      ","Pace Construction, Asphalt ","Danville2      ","3035900026     ","DRUM","I   "]
["Pace Construction, Asphalt  - Doniphan       ","Pace Construction, Asphalt ","Doniphan       ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - El Dorado Sprin","Pace Construction, Asphalt ","El Dorado Sprin","3035900026     ","DRUM","I   "]
["Pace Construction, Asphalt  - Eminence       ","Pace Construction, Asphalt ","Eminence       ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Eureka         ","Pace Construction, Asphalt ","Eureka         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Florrisant     ","Pace Construction, Asphalt ","Florrisant     ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Florrisant-Sand","Pace Construction, Asphalt ","Florrisant-Sand","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Houston        ","Pace Construction, Asphalt ","Houston        ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Jerome         ","Pace Construction, Asphalt ","Jerome         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Moscow Mills   ","Pace Construction, Asphalt ","Moscow Mills   ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Patterson      ","Pace Construction, Asphalt ","Patterson      ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Poplar Bluff   ","Pace Construction, Asphalt ","Poplar Bluff   ","3035900026     ","BATC","I   "]
["Pace Construction, Asphalt  - Potosi         ","Pace Construction, Asphalt ","Potosi         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Salem          ","Pace Construction, Asphalt ","Salem          ","3035900026     ","DRUM","I   "]
["Pace Construction, Asphalt  - Sereno         ","Pace Construction, Asphalt ","Sereno         ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - St. Charles    ","Pace Construction, Asphalt ","St. Charles    ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - St. Louis      ","Pace Construction, Asphalt ","St. Louis      ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - Thayer         ","Pace Construction, Asphalt ","Thayer         ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Van Buren      ","Pace Construction, Asphalt ","Van Buren      ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Warrenton      ","Pace Construction, Asphalt ","Warrenton      ","3035900026     ","BATC","A   "]
["Pace Construction, Asphalt  - West Plains    ","Pace Construction, Asphalt ","West Plains    ","3035900026     ","DRUM","A   "]
["Pace Construction, Asphalt  - Willow Springs ","Pace Construction, Asphalt ","Willow Springs ","3035900026     ","DRUM","A   "]
["Rolla Asphalt - Cuba           ","Rolla Asphalt","Cuba           ","3410800029     ","DRUM","A   "]
["Rolla Asphalt - Rolla          ","Rolla Asphalt","Rolla          ","3410800029     ","DRUM","A   "]
["Superior Bowen Asphalt - 38th St North  ","Superior Bowen Asphalt","38th St North  ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Bowen-Lee s Sum","Superior Bowen Asphalt","Bowen-Lee s Sum","3056900024     ","DRUM","I   "]
["Superior Bowen Asphalt - Ferrelview     ","Superior Bowen Asphalt","Ferrelview     ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Hickman Mills  ","Superior Bowen Asphalt","Hickman Mills  ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - KCI            ","Superior Bowen Asphalt","KCI            ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Lee s S-Barber ","Superior Bowen Asphalt","Lee s S-Barber ","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Lee s S-Colburn","Superior Bowen Asphalt","Lee s S-Colburn","3056900024     ","DRUM","A   "]
["Superior Bowen Asphalt - Manchester     ","Superior Bowen Asphalt","Manchester     ","3056900024     ","DRUM","A   "]
["Swift Asphalt, Joplin - Joplin         ","Swift Asphalt, Joplin","Joplin         ","3132700027     ","BATC","A   "]
["W. L. Miller Asphalt - Bethel         ","W. L. Miller Asphalt","Bethel         ","3048700023     ","DRUM","I   "]
["W. L. Miller Asphalt - Edina          ","W. L. Miller Asphalt","Edina          ","3048700023     ","DRUM","I   "]
["W. L. Miller Asphalt - Hamilton       ","W. L. Miller Asphalt","Hamilton       ","3048700023     ","BATC","I   "]
["W. L. Miller Asphalt - Kahoka         ","W. L. Miller Asphalt","Kahoka         ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - Kirksville     ","W. L. Miller Asphalt","Kirksville     ","3048700023     ","BATC","A   "]
["W. L. Miller Asphalt - Kirksville     ","W. L. Miller Asphalt","Kirksville     ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - Louisiana      ","W. L. Miller Asphalt","Louisiana      ","3048700023     ","DRUM","I   "]
["W. L. Miller Asphalt - Macon          ","W. L. Miller Asphalt","Macon          ","3048700023     ","DRUM","I   "]
["W. L. Miller Asphalt - MonroeCity     ","W. L. Miller Asphalt","MonroeCity     ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - Mt. Airy       ","W. L. Miller Asphalt","Mt. Airy       ","3048700023     ","DRUM","I   "]
["W. L. Miller Asphalt - Paris          ","W. L. Miller Asphalt","Paris          ","3048700023     ","DRUM","A   "]
["W. L. Miller Asphalt - Princeton      ","W. L. Miller Asphalt","Princeton      ","3048700023     ","DRUM","I   "]
["Weber Asphalt plants - Festus         ","Weber Asphalt plants","Festus         ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - Festus (Drum)  ","Weber Asphalt plants","Festus (Drum)  ","3016400026     ","DRUM","I   "]
["Weber Asphalt plants - Fredericktown  ","Weber Asphalt plants","Fredericktown  ","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - I-44 @ Allenton","Weber Asphalt plants","I-44 @ Allenton","3016400026     ","DRUM","I   "]
["Weber Asphalt plants - I-55 @ St.Louis","Weber Asphalt plants","I-55 @ St.Louis","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - Kingshighway   ","Weber Asphalt plants","Kingshighway   ","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - Missouri Valley","Weber Asphalt plants","Missouri Valley","3016400026     ","DRUM","A   "]
["Weber Asphalt plants - North (New)    ","Weber Asphalt plants","North (New)    ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - North (Old)    ","Weber Asphalt plants","North (Old)    ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - O Fallon       ","Weber Asphalt plants","O Fallon       ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - Pevely         ","Weber Asphalt plants","Pevely         ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - South (Drum)   ","Weber Asphalt plants","South (Drum)   ","3016400026     ","DRUM","I   "]
["Weber Asphalt plants - South (old)    ","Weber Asphalt plants","South (old)    ","3016400026     ","BATC","A   "]
["Weber Asphalt plants - Union          ","Weber Asphalt plants","Union          ","3016400026     ","DRUM","I   "]
["Willard Constr. Asphalt Plants - Lebanon        ","Willard Constr. Asphalt Plants","Lebanon        ","3050100028     ","DRUM","I   "]
["Willard Constr. Asphalt Plants - Sleeper        ","Willard Constr. Asphalt Plants","Sleeper        ","3050100028     ","DRUM","A   "]
["Willard Constr. Asphalt Plants - St. Roberts    ","Willard Constr. Asphalt Plants","St. Roberts    ","3050100028     ","DRUM","A   "]
[" - "]
[{"$f":"B419&\" - \"&C419","v":" - "}]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]
[" - "]

{"sheet":"Plant Inspection","index":2,"n_rows":124,"n_cols":41,"rows_kept":124,"cut":false,"hidden":false,"merged":[[69,10,69,11],[43,20,43,21],[41,9,41,10],[42,9,42,10],[43,9,43,10],[51,7,51,10],[65,10,65,11],[65,12,65,13],[66,12,66,13],[66,10,66,11],[67,10,67,11],[6,26,6,31],[63,5,63,7],[53,13,53,24],[59,7,59,8],[52,7,52,8],[53,7,53,8],[49,15,49,24],[61,8,61,13],[62,10,62,11],[62,12,62,13],[63,10,63,11],[50,13,50,24],[51,13,51,24],[52,13,52,24],[41,20,41,21],[42,20,42,21],[80,0,83,1],[45,13,48,14],[44,13,44,15],[46,1,46,5],[70,5,70,7],[63,0,63,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[67,5,67,7],[64,5,64,7],[65,5,65,7],[54,14,54,24],[68,5,68,7],[64,10,64,11],[3,31,3,32],[2,28,2,30],[2,19,2,21],[2,23,2,24],[3,28,3,29],[2,25,2,27],[3,20,3,26],[3,17,3,19],[2,17,2,18],[2,15,2,16],[3,14,3,16],[63,2,63,4],[64,2,64,4],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[64,12,64,13],[63,8,63,9],[63,12,63,13],[64,8,64,9],[54,7,54,8],[68,0,68,1],[69,0,69,1],[70,0,70,1],[67,2,67,4],[68,2,68,4],[69,2,69,4],[70,2,70,4],[70,10,70,11],[68,8,68,9],[67,12,67,13],[68,12,68,13],[65,2,65,4],[66,2,66,4],[69,5,69,7],[66,5,66,7],[70,8,70,9],[66,8,66,9],[67,8,67,9],[65,8,65,9],[69,8,69,9],[69,12,69,13],[70,12,70,13],[68,10,68,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MISSOURI DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Menu!I8=TRUE,\"Warm Mix\",\"\")","v":""},null,null,"SHEET",{"$f":"E5","v":1},"OF",{"$f":"H4","v":1}]
[null,null,"              TYPE IN BLUE SPACES ONLY",null,null,null,null,null,null,null,null,null,null,"PLANT INSPECTOR'S WORKSHEET"]
["INSPECTOR",null,null,null,null,null,null,null,null,null,null,null,null,"Contract",null,{"$f":"Menu!B11","v":0},null,"Job Number",null,{"$f":"Menu!B12","v":0},null,null,"Route",{"$f":"Menu!B13","v":0},null,"Bituminous Mix No.",null,null,{"$f":"UPPER(Menu!B9)","v":{"$error":"#VALUE!"}},null,null,null,"   Report No.",null,{"$f":"E4","v":1}]
["REPORT    NUMBER",null,null,null,1,null,"Total Sheets",1,null,null,null,null,null,"County",{"$f":"Menu!B14","v":0},null,null,"     Plant & Location",null,null,{"$f":"Menu!B18","v":0},null,null,null,null,null,null,"Date",{"$f":"Menu!B8","v":"00:00:00"},null,"Smpl ID",{"$f":"UPPER(Menu!B7)","v":{"$error":"#VALUE!"}},null,"Time",{"$f":"E6","v":0}]
["SHEET    NUMBER",null,null,null,1]
["TIME",null,null,null,null,null,null,null,null,null,null,null,null,"Gradation of Bin Materials ",null,null,null,null,null,null,null,null,null,null,null,null,"Gradation of Final Mix"]
["ASPHALT CEMENT SOURCE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bin No. 1",null,"Bin No. 2",null,"Bin No. 3",null,"Bin No. 4",null,{"$f":"J23","v":"RAP*"},null,{"$f":"IF($K$23=\"RAS\",\"RAS\",(IF($K$23=\"HydLim\",\"Hydrated Lime\",IF($K$23=\"MinFill\",\"Mineral Filler\",\"\"))))","v":"RAS"},null,"Proportions (% Used)"]
["ASPHALT CEMENT GRADE",null,null,null,null,null,null,null,null,null,null,null,null,"Sieve","Wt.","Per-","Wt.","Per-","Wt.","Per-","Wt.","Per-","Wt.","Per-","Wt.","Per-","Bin 1","Bin 2","Bin 3","Bin 4",{"$f":"J23","v":"RAP*"},{"$f":"IF($K$23=\"HydLim\",\"Hyd.Lime\",IF($K$23=\"MinFill\",\"Min.Filler\",\"\"))","v":"Hyd.Lime"},"Combined ","Combined","Deviation"]
["TOTAL AC %",null,null,null,null,null,null,null,null,null,null,null,null,"Size","Grams","cent","Grams","cent","Grams","cent","Grams","cent","Grams","cent","Grams","cent",{"$f":"B44","v":0},0,0,0,{"$f":"IF(C44=\"\",F44,\"\")","v":0},0,"Gradation","Job Mix"]
["MINERAL AGGRAGATE %",null,null,null,{"$f":"100-E9-J44","v":100},null,null,null,null,null,null,null,null,null,{"$f":"B24","v":0}," ",{"$f":"D24","v":0}," ",{"$f":"F24","v":0}," ",{"$f":"H24","v":0}," ",{"$f":"J24","v":0}," ",null," ",null,null,null,null,null," "]
["AC % IN RAP",null,null,null,null,null,null,null,null,null,null,null,null,1.5,{"$f":"IF(O$35>0,(O35-O10),\" \")","v":" "},{"$f":"IF($B$48>0,((O11/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q10),\" \")","v":" "},{"$f":"IF(AND($B$48>0,$C$44>0),((Q11/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S10),\" \")","v":" "},{"$f":"IF(AND($B$48>0,$D$44>0),((S11/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U10),\" \")","v":" "},{"$f":"IF(AND($B$48>0,$E$44>0),((U11/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W10),\" \")","v":" "},{"$f":"IF(AND($B$48>0,$F$44>0),((W11/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y32-Y7),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B48>0),$K24,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P11),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R11),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T11),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V11),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X11),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z11),\" \")","v":" "},{"$f":"TRUNC(SUM(AA11:AF11),1)","v":0},{"$f":"B48","v":0},{"$f":"IF(B48=\"\",\"\",IF(AG11-AH11<>0,AG11-AH11,\"0.0\"))","v":""}]
["LBS. PER BATCH",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B25","v":0}," ",{"$f":"D25","v":0}," ",{"$f":"F25","v":0}," ",{"$f":"H25","v":0}," ",{"$f":"J25","v":0}," ",null," ",null,null,null,null,null," "]
["Tons per Hour",null,null,null,null,null,null,null,null,null,null,null,null,"1",{"$f":"IF(O$35>0,(O35-O12),\" \")","v":" "},{"$f":"IF($B$49>0,((O13/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q12),\" \")","v":" "},{"$f":"IF(AND($B$49>0,$C$44>0),((Q13/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S12),\" \")","v":" "},{"$f":"IF(AND($B$49>0,$D$44>0),((S13/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U12),\" \")","v":" "},{"$f":"IF(AND($B$49>0,$E$44>0),((U13/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W12),\" \")","v":" "},{"$f":"IF(AND($B$49>0,$F$44>0),((W13/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y34-Y9),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B49>0),$K25,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P13),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R13),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T13),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V13),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X13),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z13),\" \")","v":" "},{"$f":"TRUNC(SUM(AA13:AF13),1)","v":0},{"$f":"B49","v":0},{"$f":"IF(B49=\"\",\"\",IF(AG13-AH13<>0,AG13-AH13,\"0.0\"))","v":""}]
["Gmm from JMF (leave blank for SP)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B26","v":0}," ",{"$f":"D26","v":0}," ",{"$f":"F26","v":0}," ",{"$f":"H26","v":0}," ",{"$f":"J26","v":0}," ",null," "," "," "," "," ",null," "]
["Sample Thickness",null,null,null,null,null,null,null,null,null,null,null,null,"3/4",{"$f":"IF(O$35>0,(O35-O14),\" \")","v":" "},{"$f":"IF($B$50>0,((O15/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q14),\" \")","v":" "},{"$f":"IF(AND($B$50>0,$C$44>0),((Q15/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S14),\" \")","v":" "},{"$f":"IF(AND($B$50>0,$D$44>0),((S15/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U14),\" \")","v":" "},{"$f":"IF(AND($B$50>0,$E$44>0),((U15/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W14),\" \")","v":" "},{"$f":"IF(AND($B$50>0,$F$44>0),((W15/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y13-Y14),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B50>0),$K26,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P15),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R15),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T15),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V15),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X15),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z15),\" \")","v":" "},{"$f":"TRUNC(SUM(AA15:AF15),1)","v":0},{"$f":"B50","v":0},{"$f":"IF(B50=\"\",\"\",IF(AG15-AH15<>0,AG15-AH15,\"0.0\"))","v":""}]
["Dry Wt. in Air ( \"A\" )",null,null,null,null,null,null,null,"Use for Section 401",null,null,null,null,null,{"$f":"B27","v":0}," ",{"$f":"D27","v":0}," ",{"$f":"F27","v":0}," ",{"$f":"H27","v":0}," ",{"$f":"J27","v":0}," ",null," "," ",null,null,null,null," "]
["Wet Wt. in H2O (\"B\")",null,null,null,null,null,null,null,"Mixtures.  Individual or As",null,null,null,null,"1/2",{"$f":"IF(O$35>0,(O35-O16),\" \")","v":" "},{"$f":"IF($B$51>0,((O17/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q16),\" \")","v":" "},{"$f":"IF(AND($B$51>0,$C$44>0),((Q17/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S16),\" \")","v":" "},{"$f":"IF(AND($B$51>0,$D$44>0),((S17/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U16),\" \")","v":" "},{"$f":"IF(AND($B$51>0,$E$44>0),((U17/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W16),\" \")","v":" "},{"$f":"IF(AND($B$51>0,$F$44>0),((W17/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y15-Y16),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B51>0),$K27,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P17),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R17),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T17),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V17),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X17),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z17),\" \")","v":" "},{"$f":"TRUNC(SUM(AA17:AF17),1)","v":0},{"$f":"B51","v":0},{"$f":"IF(B51=\"\",\"\",IF(AG17-AH17<>0,AG17-AH17,\"0.0\"))","v":""}]
["Wet Wt. in Air (\"C\")",null,null,null,null,null,null,null,"One Sample.",null,null,null,null,null,{"$f":"B28","v":0}," ",{"$f":"D28","v":0}," ",{"$f":"F28","v":0}," ",{"$f":"H28","v":0}," ",{"$f":"J28","v":0}," ",null," "," ",null,null,null,null," "]
["Gmc",null,null,null,{"$f":"IF(E16=\"\",\"\",ROUND(E16/(E18-E17),3))","v":""},{"$f":"IF(F16=\"\",\"\",ROUND(F16/(F18-F17),3))","v":""},{"$f":"IF(G16=\"\",\"\",ROUND(G16/(G18-G17),3))","v":""},{"$f":"IF(H16=\"\",\"\",ROUND(H16/(H18-H17),3))","v":""},null,null,null,null,null,"3/8",{"$f":"IF(O$35>0,(O35-O18),\" \")","v":" "},{"$f":"IF($B$52>0,((O19/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q18),\" \")","v":" "},{"$f":"IF(AND($B$52>0,$C$44>0),((Q19/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S18),\" \")","v":" "},{"$f":"IF(AND($B$52>0,$D$44>0),((S19/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U18),\" \")","v":" "},{"$f":"IF(AND($B$52>0,$E$44>0),((U19/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W18),\" \")","v":" "},{"$f":"IF(AND($B$52>0,$F$44>0),((W19/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y17-Y18),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B52>0),$K28,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P19),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R19),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T19),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V19),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X19),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z19),\" \")","v":" "},{"$f":"TRUNC(SUM(AA19:AF19),1)","v":0},{"$f":"B52","v":0},{"$f":"IF(B52=\"\",\"\",IF(AG19-AH19<>0,AG19-AH19,\"0.0\"))","v":""}]
["Required Density",null,null,null,"92% Min.",null,null,null,null,"Wts.","Enter ",null,null,null,{"$f":"B29","v":0}," ",{"$f":"D29","v":0}," ",{"$f":"F29","v":0}," ",{"$f":"H29","v":0}," ",{"$f":"J29","v":0}," ",null," "," ",null,null,null,null," "]
["Nuclear Gauge Serial #",null,null,null,null,null,null,null,null,"From","Gradation",null,null,"4",{"$f":"IF(O$35>0,(O35-O20),\" \")","v":" "},{"$f":"IF($B$53>0,((O21/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q20),\" \")","v":" "},{"$f":"IF(AND($B$53>0,$C$44>0),((Q21/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S20),\" \")","v":" "},{"$f":"IF(AND($B$53>0,$D$44>0),((S21/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U20),\" \")","v":" "},{"$f":"IF(AND($B$53>0,$E$44>0),((U21/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W20),\" \")","v":" "},{"$f":"IF(AND($B$53>0,$F$44>0),((W21/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y19-Y20),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B53>0),$K29,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P21),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R21),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T21),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V21),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X21),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z21),\" \")","v":" "},{"$f":"TRUNC(SUM(AA21:AF21),1)","v":0},{"$f":"B53","v":0},{"$f":"IF(B53=\"\",\"\",IF(AG21-AH21<>0,AG21-AH21,\"0.0\"))","v":""}]
[null,"Retained    Weights",null,null,"Cumulative Gradation Spreadsheet",null,null,null,null,"Residue","From JMF",null,null,null,{"$f":"B30","v":0}," ",{"$f":"D30","v":0}," ",{"$f":"F30","v":0}," ",{"$f":"H30","v":0}," ",{"$f":"J30","v":0}," ",null," "," ",null,null,null,null," "]
[null,"Bin #1",null,"Bin #2",null,"Bin #3",null,"Bin #4",null,"RAP*",null,"HydLim",null,"8",{"$f":"IF(O$35>0,(O35-O22),\" \")","v":" "},{"$f":"IF($B$54>0,((O23/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q22),\" \")","v":" "},{"$f":"IF(AND($B$54>0,$C$44>0)>0,((Q23/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S22),\" \")","v":" "},{"$f":"IF(AND($B$54>0,$D$44>0)>0,((S23/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U22),\" \")","v":" "},{"$f":"IF(AND($B$54>0,$E$44>0)>0,((U23/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W22),\" \")","v":" "},{"$f":"IF(AND($B$54>0,$F$44>0)>0,((W23/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y21-Y22),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B54>0),$K30,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P23),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R23),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T23),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V23),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X23),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z23),\" \")","v":" "},{"$f":"TRUNC(SUM(AA23:AF23),1)","v":0},{"$f":"B54","v":0},{"$f":"IF(B54=\"\",\"\",IF(AG23-AH23<>0,AG23-AH23,\"0.0\"))","v":""}]
["1 1/2\"",null,null,null,null,null,null,null,null,null,100,"MinFill",null,null,{"$f":"B31","v":0}," ",{"$f":"D31","v":0}," ",{"$f":"F31","v":0}," ",{"$f":"H31","v":0}," ",{"$f":"J31","v":0}," ",null," "," ",null,null,null,null," "]
["1\"",0,0,null,null,null,null,null,null,null,100,"RAS",null,"16",{"$f":"IF(O$35>0,(O35-O24),\" \")","v":" "},{"$f":"IF($B$55>0,((O25/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q24),\" \")","v":" "},{"$f":"IF(AND($B$55>0,$C$44>0)>0,((Q25/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S24),\" \")","v":" "},{"$f":"IF(AND($B$55>0,$D$44>0)>0,((S25/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U24),\" \")","v":" "},{"$f":"IF(AND($B$55>0,$E$44>0)>0,((U25/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W24),\" \")","v":" "},{"$f":"IF(AND($B$55>0,$F$44>0)>0,((W25/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y23-Y24),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B55>0),$K31,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P25),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R25),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T25),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V25),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X25),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z25),\" \")","v":" "},{"$f":"TRUNC(SUM(AA25:AF25),1)","v":0},{"$f":"B55","v":0},{"$f":"IF(B55=\"\",\"\",IF(AG25-AH25<>0,AG25-AH25,\"0.0\"))","v":""},null,null,null,null,null,{"$f":"100-F44","v":100}]
["3/4\"",0,null,null,null,null,null,0,null,0,100,null,null,null,{"$f":"B32","v":0}," ",{"$f":"D32","v":0}," ",{"$f":"F32","v":0}," ",{"$f":"H32","v":0}," ",{"$f":"J32","v":0}," ",null," "," ",null,null,null,null," "]
["1/2\"",null,null,null,null,null,null,null,null,null,100,null,null,"30",{"$f":"IF(O$35>0,(O35-O26),\" \")","v":" "},{"$f":"IF($B$56>0,((O27/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q26),\" \")","v":" "},{"$f":"IF(AND($B$56>0,$C$44>0),((Q27/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S26),\" \")","v":" "},{"$f":"IF(AND($B$56>0,$D$44>0),((S27/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U26),\" \")","v":" "},{"$f":"IF(AND($B$56>0,$E$44>0),((U27/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W26),\" \")","v":" "},{"$f":"IF(AND($B$56>0,$F$44>0),((W27/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y25-Y26),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B56>0),$K32,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P27),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R27),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T27),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V27),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X27),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z27),\" \")","v":" "},{"$f":"TRUNC(SUM(AA27:AF27),1)","v":0},{"$f":"B56","v":0},{"$f":"IF(B56=\"\",\"\",IF(AG27-AH27<>0,AG27-AH27,\"0.0\"))","v":""}]
["3/8\"",null,null,null,null,null,null,null,null,null,100,null,null,null,{"$f":"B33","v":0}," ",{"$f":"D33","v":0}," ",{"$f":"F33","v":0}," ",{"$f":"H33","v":0}," ",{"$f":"J33","v":0}," ",null," "," ",null,null,null,null," "]
["#4",null,null,null,null,null,null,null,null,null,100,null,null,"50",{"$f":"IF(O$35>0,(O35-O28),\" \")","v":" "},{"$f":"IF($B$57>0,((O29/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q28),\" \")","v":" "},{"$f":"IF(AND($B$57>0,$C$44>0),((Q29/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S28),\" \")","v":" "},{"$f":"IF(AND($B$57>0,$D$44>0),((S29/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U28),\" \")","v":" "},{"$f":"IF(AND($B$57>0,$E$44>0),((U29/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W28),\" \")","v":" "},{"$f":"IF(AND($B$57>0,$F$44>0),((W29/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y27-Y28),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B57>0),$K33,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P29),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R29),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T29),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V29),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X29),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z29),\" \")","v":" "},{"$f":"TRUNC(SUM(AA29:AF29),1)","v":0},{"$f":"B57","v":0},{"$f":"IF(B57=\"\",\"\",IF(AG29-AH29<>0,AG29-AH29,\"0.0\"))","v":""}]
["#8",null,null,null,null,null,null,null,null,null,100,null,null,null,{"$f":"B34","v":0}," ",{"$f":"D34","v":0}," ",{"$f":"F34","v":0}," ",{"$f":"H34","v":0}," ",{"$f":"J34","v":0}," ",null," "," ",null,null,null,null," "]
["#16",null,null,null,null,null,null,null,null,null,100,null,null,"100",{"$f":"IF(O$35>0,(O35-O30),\" \")","v":" "},{"$f":"IF($B$58>0,((O31/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q30),\" \")","v":" "},{"$f":"IF(AND($B$58>0,$C$44>0),((Q31/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S30),\" \")","v":" "},{"$f":"IF(AND($B$58>0,$D$44>0),((S31/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U30),\" \")","v":" "},{"$f":"IF(AND($B$58>0,$E$44>0),((U31/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W30),\" \")","v":" "},{"$f":"IF(AND($B$58>0,$F$44>0),((W31/W$35)*100),\" \")","v":" "},{"$f":"IF($Y$35>0,(Y29-Y30),\" \")","v":" "},{"$f":"IF(AND($G$44>0,B58>0),$K34,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P31),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R31),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T31),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V31),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X31),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z31),\" \")","v":" "},{"$f":"TRUNC(SUM(AA31:AF31),1)","v":0},{"$f":"B58","v":0},{"$f":"IF(B58=\"\",\"\",IF(AG31-AH31<>0,AG31-AH31,\"0.0\"))","v":""}]
["#30",null,null,null,null,null,null,null,null,null,100,null,null,null,{"$f":"B35","v":0}," ",{"$f":"D35","v":0}," ",{"$f":"F35","v":0}," ",{"$f":"H35","v":0}," ",{"$f":"J35","v":0}," "," "," "," ",null,null,null,null," "]
["#50",null,null,null,null,null,null,null,null,null,100,null,null,"200",{"$f":"IF(O$35>0,(O34+O37),\" \")","v":" "},{"$f":"IF($B$59>0,((O33/O$35)*100),\" \")","v":" "},{"$f":"IF(Q$35>0,(Q35-Q32),\" \")","v":" "},{"$f":"IF(AND($B$59>0,$C$44>0),((Q33/Q$35)*100),\" \")","v":" "},{"$f":"IF(S$35>0,(S35-S32),\" \")","v":" "},{"$f":"IF(AND($B$59>0,$D$44>0),((S33/S$35)*100),\" \")","v":" "},{"$f":"IF(U$35>0,(U35-U32),\" \")","v":" "},{"$f":"IF(AND($B$59>0,$E$44>0),((U33/U$35)*100),\" \")","v":" "},{"$f":"IF(W$35>0,(W35-W32),\" \")","v":" "},{"$f":"IF(AND($B$59>0,$F$44>0),((W33/W$35)*100),\" \")","v":" "},null,{"$f":"IF(AND($G$44>0,B59>0),$K35,\" \")","v":" "},{"$f":"IF($O$35>0,(($AA$9/100)*P33),\" \")","v":" "},{"$f":"IF($Q$35>0,(($AB$9/100)*R33),\" \")","v":" "},{"$f":"IF($S$35>0,(($AC$9/100)*T33),\" \")","v":" "},{"$f":"IF($U$35>0,(($AD$9/100)*V33),\" \")","v":" "},{"$f":"IF($AE$9>0,(($AE$9/100)*X33),\" \")","v":" "},{"$f":"IF($AF$9>0,(($AF$9/100)*Z33),\" \")","v":" "},{"$f":"TRUNC(SUM(AA33:AF33),1)","v":0},{"$f":"B59","v":0},{"$f":"IF(B59=\"\",\"\",IF(AG33-AH33<>0,AG33-AH33,\"0.0\"))","v":""}]
["#100",null,null,null,null,null,null,null,null,null,100,null,null,"Pan",{"$f":"B36","v":0},null,{"$f":"D36","v":0},null,{"$f":"F36","v":0},null,{"$f":"H36","v":0},null,{"$f":"J36","v":0},null,null,null,"A.C.Grade",null,{"$f":"E8","v":0},null,"AC SOURCE",null,{"$f":"E7","v":0}]
["#200",null,null,null,null,null,null,null,null,null,100,null,null,"Dry Wt.",{"$f":"B38","v":0},null,{"$f":"D38","v":0},null,{"$f":"F38","v":0},null,{"$f":"H38","v":0},null,{"$f":"J38","v":0},null,null,null,"Date Rec'd.",null,"Quantity(Tons)",null,null,"Invoice No."]
["Pan",null,null,null,null,null,null,null,null,null,null,null,null,"Wash Wt.",{"$f":"B39","v":0},{"$f":"IF(OR(B41>O36+10,B41<O36-10),B41,\"\")","v":""},{"$f":"D39","v":0},{"$f":"IF(OR(D41>Q36+10,D41<Q36-10),D41,\"\")","v":""},{"$f":"F39","v":0},{"$f":"IF(OR(F41>S36+10,F41<S36-10),F41,\"\")","v":""},{"$f":"H39","v":0},{"$f":"IF(OR(H41>U36+10,H41<U36-10),H41,\"\")","v":""},{"$f":"J39","v":0},{"$f":"IF(OR(J41>W36+10,J41<W36-10),J41,\"\")","v":""},null,null,{"$f":"A64","v":0},null,{"$f":"C64","v":0},null,null,{"$f":"F64","v":0}]
["Orig.Wt.",null,null,null,null,null,null,null,null,null,null,null,null,"P-200",{"$f":"IF(O$35>0,(O35-O36),\" \")","v":" "},null,{"$f":"IF(Q$35>0,(Q35-Q36),\" \")","v":" "},null,{"$f":"IF(S$35>0,(S35-S36),\" \")","v":" "},null,{"$f":"IF(U$35>0,(U35-U36),\" \")","v":" "},null,{"$f":"IF(W$35>0,(W35-W36),\" \")","v":" "},null,null,null,{"$f":"A65","v":0},null,{"$f":"C65","v":0},null,null,{"$f":"F65","v":0}]
["Dry Wt.",null,null,null,null,null,null,null,null,null,null,null,null,"% Moisture of Aggregates",null,null,null,{"$f":"I77","v":""},null,null,{"$f":"IF(E11=\"\",\"\",\"Pecent AC in RAP\")","v":""},null,null,{"$f":"IF(E11=\"\",\"\",E11)","v":""},null,null,0,null,0,null,null,0]
["Wsh.Wt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonnage of Mixture",null,null,0,null,0,null,null,0]
["%Moist.",{"$f":"IF(B37=\"\",\"\",ROUND((B37-B38)/B38*100,1))","v":""},null,{"$f":"IF(D37=\"\",\"\",ROUND((D37-D38)/D38*100,1))","v":""},null,{"$f":"IF(F37=\"\",\"\",ROUND((F37-F38)/F38*100,1))","v":""},null,{"$f":"IF(H37=\"\",\"\",ROUND((H37-H38)/H38*100,1))","v":""},null,{"$f":"IF(J37=\"\",\"\",ROUND((J37-J38)/J38*100,1))","v":""},null,null,null,"Field Density Test",null,null,null,null,null,null,null,null,null,"    Tons/hr.",null,{"$f":"E13","v":0},0,null,0,null,null,0]
[null,{"$f":"B35+B36","v":0},null,{"$f":"D35+D36","v":0},null,{"$f":"F35+F36","v":0},null,{"$f":"H35+H36","v":0},null,{"$f":"J35+J36","v":0},null,null,null,null,null,"Dry Wt."," Wt. In","Wet Wt."," Sp. G","Den.",null,null,null,"Lbs./Batch",null,{"$f":"E12","v":0},0,null,0,null,null,0]
[null,null,null,"    Hot    Bin  or   Cold   Feed    Percentages",null,null,null,null,null,"SMA Fibers",null,null,null,"Gmm =",{"$f":"E14","v":0},"In Air","Water","In Air","    A   ","Sp. G.","Required",null,"  Sample","Previous",null,{"$f":"C93","v":0},0,null,0,null,null,0]
[null,"Bin #1","Bin #2","Bin #3","Bin #4","RAP*",{"$f":"K23","v":0},"Total",null,"Total Mixture",null,null,null,null,null,"\"A\"","\"B\"","\"C\""," C - B","Gmm","Compact",null,"Thick.","Today",null,{"$f":"F93","v":0},{"$f":"A71","v":0},null,{"$f":"C71","v":0},null,null,{"$f":"F71","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(C44=\"\",SUM(B44:G44),SUM(B44:E44,G44))","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E16:H16)","v":0},{"$f":"SUM(E17:H17)","v":0},{"$f":"SUM(E18:H18)","v":0},{"$f":"IF($P$44>0,(P44/(R44-Q44)),\" \")","v":" "},{"$f":"TRUNC(IF($P$44>0,((S44/O42)*100),\" \"),1)","v":0},{"$f":"E20","v":"92% Min."},null,{"$f":"IF(E15=\"\",\"\",AVERAGE(E15:H15))","v":""},"Total",null,{"$f":"(C93+F93)","v":0},"Temperatures",null,null,null,null,"Asphalt Content",null,null,{"$f":"IF(E11=\"\",\" \",\"Virgin\")","v":" "}]
[null,{"$f":"IF(E11=\"\",\"\",\"* Percent RAP required for batch plants adding RAP to the hot elevator,\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Sample Locations:",null,null,{"$f":"D80","v":0},null,null,null,null,null,null,null,null,null,"Time",{"$f":"B73","v":0},0,0,0,"Count","% A.C.","BKG",{"$f":"IF(E11=\"\",\" \",\"AC\")","v":" "}]
[null,{"$f":"IF(E11=\"\",\"\",\"however, gradation is included in hot bins.\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Density Sample Locations",null,"Core #1",{"$f":"D81","v":0},null,null,null,null,null,null,null,null,null,"A.C.",0,0,0,0,{"$f":"F74","v":0},0,0,{"$f":"IF(E11=\"\",\" \",ROUND(((10000-(100-F44)*E11)*E9/100/(100-E11))-((100-(100-F44))*E11)/(100-E11),1))","v":" "}]
[null,"Job Mix / QC            Comb. Grad.        Deviation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Core #2",{"$f":"D82","v":0},null,null,null,null,null,null,null,null,null,"Mix",0,0,0,0,0,0,0]
["1 1/2\"",null,null,{"$f":"AG11","v":0},null,{"$f":"IF(D48=\"\",\"\",ROUND(AI11,1))","v":""},null,null,null,null,null,null,null,null,null,"Core #3",{"$f":"D83","v":0},null,null,null,null,null,null,null,null,null,"Air","Min.",{"$f":"C76","v":0},"Max.",{"$f":"E76","v":0},0,0,0,null,null,null,{"$f":"SUM(AA51:AF51)","v":0}]
["1\"",null,null,{"$f":"AG13","v":0},null,{"$f":"IF(D49=\"\",\"\",ROUND(AI13,1))","v":""},"Gradation within Specification? (Y/N)",null,null,null,null,null,null,null,null,"Core #4",{"$f":"D84","v":0},null,null,null,null,null,null,null,null,"% Moisture of Mixture",null,null,null,{"$f":"D77","v":0},"Gauge Sr.No.",null,{"$f":"E21","v":0},{"$f":"F21","v":0},null,null,null,null,{"$f":"AM51/5.2","v":0}]
["3/4\"",null,null,{"$f":"AG15","v":0},null,{"$f":"IF(D50=\"\",\"\",ROUND(AI15,1))","v":""},null,"N",null,null,null,null,null,"Remarks:",null,{"$f":"C85","v":0},null,null,null,null,null,null,null,null,null,null,"BIN#1","BIN#2","BIN#3","BIN#4",{"$f":"J23","v":"RAP*"},{"$f":"IF($K$23=\"HydLim\",\"Hyd.Lime\",IF($K$23=\"MinFill\",\"Min.Filler\",\"\"))","v":"Hyd.Lime"},"FIBERS","ASPH.","TOTAL"]
["1/2\"",null,null,{"$f":"AG17","v":0},null,{"$f":"IF(D51=\"\",\"\",ROUND(AI17,1))","v":""},null,null,null,null,null,null,null,{"$f":"A86","v":0},null,null,null,null,null,null,null,null,null,null,null,"Plant %",{"$f":"ROUND(IF($E$11=\"\",(AA9/100)*$E$10,IF($C$44=\"\",AA9/($AA$9+$AF$9+$J$44)*((100-$F$44)-(100-$F$44)*$E$9/100),AA9/100*(100-$AI$46-$J$44))),1)","v":0},{"$f":"ROUND(IF($E$11=\"\",(AB9/100)*$E$10,IF($C$44=\"\",0,AB9/100*(100-$AI$46-$J$44))),1)","v":0},{"$f":"ROUND(IF($E$11=\"\",(AC9/100)*$E$10,IF($C$44=\"\",0,AC9/100*(100-$AI$46-$J$44))),1)","v":0},{"$f":"ROUND(IF($E$11=\"\",(AD9/100)*$E$10,IF($C$44=\"\",0,AD9/100*(100-$AI$46-$J$44))),1)","v":0},{"$f":"ROUND(IF($E$11=\"\",(AE9/100)*$E$10,IF($C$44=\"\",(100*(100-(100-$F$44))/(100-$E$11))-((100-(100-$F$44))*$E$9/(100-$E$11)),0)),1)","v":0},{"$f":"ROUND(IF($E$11=\"\",(AF9/100)*$E$10,IF($C$44=\"\",AF9/($AA$9+$AF$9+$J$44)*((100-$F$44)-(100-$F$44)*$E$9/100),AF9/100*(100-$AI$46-$J$44))),1)","v":0},{"$f":"J44","v":0},{"$f":"IF(E11=\"\",E9,AI46)","v":0},{"$f":"SUM(AA51:AH51)","v":0}]
["3/8\"",null,null,{"$f":"AG19","v":0},null,{"$f":"IF(D52=\"\",\"\",ROUND(AI19,1))","v":""},null,"Deleterious Material",null,null,null,null,null,{"$f":"A87","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tons"]
["#4",null,null,{"$f":"AG21","v":0},null,{"$f":"IF(D53=\"\",\"\",ROUND(AI21,1))","v":""},null,"Original Dry Weight",null,null,null,null,null,{"$f":"A88","v":0},null,null,null,null,null,null,null,null,null,null,null,"1 T Batch",{"$f":"(AA51*20)","v":0},0,0,0,0,0,{"$f":"(AG51*20)","v":0},{"$f":"(AH51*20)","v":0},{"$f":"SUM(AA53:AH53)/2000","v":0}]
["#8",null,null,{"$f":"AG23","v":0},null,{"$f":"IF(D54=\"\",\"\",ROUND(AI23,1))","v":""},null,"Del. Rock",null,null,{"$f":"IF(J54=\"\",\"\",ROUND(J54/$J$53*100,1))","v":""},null,null,{"$f":"A89","v":0},null,null,null,null,null,null,null,null,null,null,null,"BATCH",{"$f":"(AA51*($Z$41/100))","v":0},0,0,0,0,0,{"$f":"(AG51*($Z$41/100))","v":0},{"$f":"(AH51*($Z$41/100))","v":0},{"$f":"SUM(AA54:AH54)/2000","v":0}]
["#16",null,null,{"$f":"AG25","v":0},null,{"$f":"IF(D55=\"\",\"\",ROUND(AI25,1))","v":""},null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Shale & Mud Balls\",\"Shale\"))","v":""},null,null,{"$f":"IF(J55=\"\",\"\",ROUND(J55/$J$53*100,1))","v":""},null,null,null,{"$f":"IF(Menu!N11=\"\",IF(Menu!K11=\"\",\"\",\"Additional Project: \"&Menu!K11&\", \"&Menu!K12),\"Additional Projects: \"&Menu!K11&\", \"&Menu!K12&\"; \"&Menu!N11&\", \"&Menu!N12)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"E3","v":0},null,null,null,null,null,null,"     INSPECTOR"]
["#30",null,null,{"$f":"AG27","v":0},null,{"$f":"IF(D56=\"\",\"\",ROUND(AI27,1))","v":""},null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Clay,Disp.\",\"\"))","v":""},null,null,{"$f":"IF(J56=\"\",\"\",ROUND(J56/$J$53*100,1))","v":""}]
["#50",null,null,{"$f":"AG29","v":0},null,{"$f":"IF(D57=\"\",\"\",ROUND(AI29,1))","v":""},null,"OFM",null,null,{"$f":"IF(J57=\"\",\"\",ROUND(J57/$J$53*100,1))","v":""}]
["#100",null,null,{"$f":"AG31","v":0},null,{"$f":"IF(D58=\"\",\"\",ROUND(AI31,1))","v":""},null,"Total Del.",null,{"$f":"SUM(J54:J57)","v":0},{"$f":"IF(J53=\"\",\"\",ROUND(J58/$J$53*100,1))","v":""}]
["#200",null,null,{"$f":"AG33","v":0},null,{"$f":"IF(D59=\"\",\"\",ROUND(AI33,1))","v":""}]
[null,null,null,null,null,null,null,"Chert",null,null,{"$f":"IF(J60=\"\",\"\",ROUND(J60/$J$53*100,1))","v":""}]
[null,"Start typing at the far left of each box only."]
[null,null,null,"               ASPHALT  DELIVERY  INVOICES",null,null,null,null,"FIBER INVOICES"]
["Date Rec'd.",null,"          Quantity(Tons)",null,null,null,"Invoice No.",null,"Date Rec'd",null,"Quantity (lbs.)",null,"Invoice No."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Temperatures",null,null,null,"Asphalt Content"]
["Time",null,null,null,null,"Count","% A.C.","BKG"]
["A.C."]
["Mix"]
["Air","min",null,"max"]
["% Moisture of Mixture",null,null,null,"% Moisture of Comb. Aggregates",null,null,null,{"$f":"IF(F44>0,ROUND(((B40*B44)+(D40*C44)+(F40*D44)+(H40*E44)+(J40*F44))/100,1),IF(E44>0,ROUND(((B40*B44)+(D40*C44)+(F40*D44)+(H40*E44))/100,1),IF(D44>0,ROUND(((B40*B44)+(D40*C44)+(F40*D44))/100,1),IF(C44>0,ROUND(((B40*B44)+(D40*C44))/100,1),IF(B40=\"\",\"\",ROUND(B40*B44/100,1))))))","v":""}]
[]
["Start Typing at the far left of each line only."]
["Sample Location:"]
["Density Sample Locations",null,"Core #1"]
[null,null,"Core #2"]
[null,null,"Core #3"]
[null,null,"Core #4"]
["Remarks:"]
[]
[]
[]
[]
[]
[]
["Tonnage of Mixture"]
["Previous",null,null,null,"Today",{"$f":"Summary!B7","v":0},null,"Total",{"$f":"C93+F93","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]
[null,null,null,null,null,null,null,"Macro for erasing retained weights"]
[null,"{D} {D} {D} {D} {D} {D} {R 2} {U} {U} "]
[null,"{U} {U} {U} {U} {U} {U} {U} {U} {U} {U} "]
[null,"{U} {R 2} {D} {D} {D} {D} {D} {D} {D} "]
[null,"{D} {D} {D} {D} {D} {D} {R 2} {U} {U} "]
[null,"{U} {U} {U} {U} {U} {U} {U} {U} {U} {U} "]
[null,"{U} {R 2} {D} {D} {D} {D} {D} {D} {D} "]
[null,"{D} {D} {D} {D} {D} {D} ~"]
[]
[" "]
[]
[]
[" "]
[]
[null," ",null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Macro for saving files to a job directory"]

{"sheet":"Loose Mix","index":3,"n_rows":98,"n_cols":20,"rows_kept":98,"cut":false,"hidden":false,"merged":[[11,1,11,3],[21,10,21,11],[6,5,6,6],[10,10,10,11],[17,5,17,6],[33,10,33,11],[93,10,93,11],[81,10,81,11],[69,10,69,11],[57,10,57,11],[45,10,45,11]]}
[null,null,null,null,"LOOSE MIX"]
["No. Tons",3000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND(),4)","v":0.63300000000000001},{"$f":"ROUND(RAND(),4)","v":0.1024}]
["Tons per Sublot",null,null,null,"JOB",{"$f":"Menu!B12","v":0},null,"ROUTE",{"$f":"Menu!B13","v":0},"MIX NO.",{"$f":"UPPER(Menu!B9)","v":{"$error":"#VALUE!"}},null,"LOT NO.",{"$f":"Menu!B10","v":0}]
[{"$f":"Menu!L10","v":"A"},750]
[{"$f":"Menu!M10","v":"B"},750,null,null,"NO. TONS",{"$f":"IF(B2=\"\",\"\",B2)","v":3000},null,"QA SAMPLE",null,"TONS  \"T\"",null,null,{"$f":"B2","v":3000}]
[{"$f":"Menu!N10","v":"C"},750,null,null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,0]
[{"$f":"Menu!O10","v":"D"},750,null,null,"TECHNICIAN","mrm",null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M5+M6","v":3000}]
[{"$f":"Menu!P10","v":0},null,null,null,null,null,null,null,null,"WIDTH",null,null,12]
[{"$f":"Menu!Q10","v":0}]
[{"$f":"Menu!R10","v":0},null,null,null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,{"$f":"SUM(B4:B10)","v":3000},null,null,"A","B",null,{"$f":"M5","v":3000},{"$f":"E12","v":0},{"$f":"H11*I11","v":0},{"$f":"IF(F5=\"\",\"\",M6+J11)","v":0},null,"QA SAMPLE"]
["Unconfined Edge","Beginning and Ending \nStations/Log Miles"]
["Enter 0, 1, or 2",null,{"$f":"Menu!D10","v":0},null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[0,200,"to",300,null,null,null,{"$f":"M8","v":12},{"$f":"F12","v":0},null,{"$f":"H14-2","v":10},{"$f":"K14*I14","v":0},null,{"$f":"IF(F5=\"\",\"\",L14+1)","v":1}]
[null,null,"to",null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[null,null,"to",null,"SUBLOT",{"$f":"IF(Menu!L10=\"\",\"\",Menu!L10)","v":"A"},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B4","v":750}]
[null,null,"to",null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M6","v":0}]
[null,null,"to",null,"TECHNICIAN",null,null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M16+M17","v":750}]
[null,null,"to",null,null,null,null,null,null,"WIDTH",null,null,12]
[null,null,{"$f":"Menu!E10","v":0}]
[0,{"$f":"IF(ISBLANK(D15),D14,IF(ISBLANK(D16),D15,IF(ISBLANK(D17),D16,IF(ISBLANK(D18),D17,IF(ISBLANK(D19),D18,D19)))))","v":300},"to",400,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,"to",null,"A","B",null,{"$f":"M16","v":750},{"$f":"E23","v":0},{"$f":"H22*I22","v":0},{"$f":"IF(F16=\"\",\"\",M17+J22)","v":0}]
[null,null,"to"]
[null,null,"to",null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[null,null,"to",null,null,null,null,{"$f":"M19","v":12},{"$f":"F23","v":0},null,{"$f":"H25-2","v":10},{"$f":"K25*I25","v":0},null,{"$f":"IF(F16=\"\",\"\",L25+1)","v":1}]
[null,null,"to",null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[null,null,{"$f":"Menu!F10","v":0}]
[0,{"$f":"IF(ISBLANK(D22),D21,IF(ISBLANK(D23),D22,IF(ISBLANK(D24),D23,IF(ISBLANK(D25),D24,IF(ISBLANK(D26),D25,D26)))))","v":400},"to",500,"SUBLOT",{"$f":"IF(Menu!M10=\"\",\"\",Menu!M10)","v":"B"},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B5","v":750}]
[null,null,"to",null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M18","v":750}]
[null,null,"to",null,"TECHNICIAN",{"$f":"IF($F$18=\"\",\"\",$F$18)","v":""},null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M28+M29","v":1500}]
[null,null,"to",null,null,null,null,null,null,"WIDTH",null,null,{"$f":"IF($M$19=\"\",\"\",$M$19)","v":12}]
[null,null,"to"]
[null,null,"to",null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,{"$f":"Menu!G10","v":"Sublot Designations:"},null,"A","B",null,{"$f":"M28","v":750},{"$f":"E35","v":0},{"$f":"H34*I34","v":0},{"$f":"IF(F28=\"\",\"\",M29+J34)","v":750}]
[0,{"$f":"IF(ISBLANK(D29),D28,IF(ISBLANK(D30),D29,IF(ISBLANK(D31),D30,IF(ISBLANK(D32),D31,IF(ISBLANK(D33),D32,D33)))))","v":500},"to",610]
[null,null,"to",null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[null,null,"to",null,null,null,null,{"$f":"M31","v":12},{"$f":"F35","v":0},null,{"$f":"H37-2","v":10},{"$f":"K37*I37","v":0},null,{"$f":"IF(F28=\"\",\"\",L37+1)","v":1}]
[null,null,"to",null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[null,null,"to"]
[null,null,"to",null,"SUBLOT",{"$f":"IF(Menu!N10=\"\",\"\",Menu!N10)","v":"C"},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B6","v":750}]
[null,null,{"$f":"Menu!H10","v":0},null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M30","v":1500}]
[0,{"$f":"IF(ISBLANK(D36),D35,IF(ISBLANK(D37),D36,IF(ISBLANK(D38),D37,IF(ISBLANK(D39),D38,IF(ISBLANK(D40),D39,D40)))))","v":610},"to",null,"TECHNICIAN",{"$f":"IF($F$18=\"\",\"\",$F$18)","v":""},null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M40+M41","v":2250}]
[null,null,"to",null,null,null,null,null,null,"WIDTH",null,null,{"$f":"IF($M$19=\"\",\"\",$M$19)","v":12}]
[null,null,"to"]
[null,null,"to",null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,"to",null,"A","B",null,{"$f":"M40","v":750},{"$f":"E47","v":0},{"$f":"H46*I46","v":0},{"$f":"IF(F40=\"\",\"\",M41+J46)","v":1500}]
[null,null,"to"]
[null,null,{"$f":"Menu!I10","v":0},null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[0,{"$f":"IF(ISBLANK(D43),D42,IF(ISBLANK(D44),D43,IF(ISBLANK(D45),D44,IF(ISBLANK(D46),D45,IF(ISBLANK(D47),D46,D47)))))","v":0},"to",null,null,null,null,{"$f":"M43","v":12},{"$f":"F47","v":0},null,{"$f":"H49-2","v":10},{"$f":"K49*I49","v":0},null,{"$f":"IF(F40=\"\",\"\",L49+1)","v":1}]
[null,null,"to",null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[null,null,"to"]
[null,null,"to",null,"SUBLOT",{"$f":"IF(Menu!O10=\"\",\"\",Menu!O10)","v":"D"},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B7","v":750}]
[null,null,"to",null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M42","v":2250}]
[null,null,"to",null,"TECHNICIAN",{"$f":"IF($F$18=\"\",\"\",$F$18)","v":""},null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M52+M53","v":3000}]
[null,null,{"$f":"Menu!J10","v":0},null,null,null,null,null,null,"WIDTH",null,null,{"$f":"IF($M$19=\"\",\"\",$M$19)","v":12}]
[0,{"$f":"IF(ISBLANK(D50),D49,IF(ISBLANK(D51),D50,IF(ISBLANK(D52),D51,IF(ISBLANK(D53),D52,IF(ISBLANK(D54),D53,D54)))))","v":0},"to"]
[null,null,"to",null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,"to",null,"A","B",null,{"$f":"M52","v":750},{"$f":"E59","v":0},{"$f":"H58*I58","v":0},{"$f":"IF(F52=\"\",\"\",M53+J58)","v":2250}]
[null,null,"to"]
[null,null,"to",null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[null,null,"to",null,null,null,null,{"$f":"M55","v":12},{"$f":"F59","v":0},null,{"$f":"H61-2","v":10},{"$f":"K61*I61","v":0},null,{"$f":"IF(F52=\"\",\"\",L61+1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[]
[null,null,null,null,"SUBLOT",{"$f":"IF(Menu!P10=\"\",\"\",Menu!P10)","v":""},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B8","v":0}]
[null,null,null,null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M54","v":3000}]
[null,null,null,null,"TECHNICIAN",{"$f":"IF($F$18=\"\",\"\",$F$18)","v":""},null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M64+M65","v":3000}]
[null,null,null,null,null,null,null,null,null,"WIDTH",null,null,{"$f":"IF($M$19=\"\",\"\",$M$19)","v":12}]
[]
[null,null,null,null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,null,null,"A","B",null,{"$f":"M64","v":0},{"$f":"E71","v":0},{"$f":"H70*I70","v":0},{"$f":"IF(F64=\"\",\"\",M65+J70)","v":""}]
[]
[null,null,null,null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[null,null,null,null,null,null,null,{"$f":"M67","v":12},{"$f":"F71","v":0},null,{"$f":"H73-2","v":10},{"$f":"K73*I73","v":0},null,{"$f":"IF(F64=\"\",\"\",L73+1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[]
[null,null,null,null,"SUBLOT",{"$f":"IF(Menu!Q10=\"\",\"\",Menu!Q10)","v":""},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B9","v":0}]
[null,null,null,null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M66","v":3000}]
[null,null,null,null,"TECHNICIAN",{"$f":"IF($F$18=\"\",\"\",$F$18)","v":""},null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M76+M77","v":3000}]
[null,null,null,null,null,null,null,null,null,"WIDTH",null,null,{"$f":"IF($M$19=\"\",\"\",$M$19)","v":12}]
[]
[null,null,null,null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,null,null,"A","B",null,{"$f":"M76","v":0},{"$f":"E83","v":0},{"$f":"H82*I82","v":0},{"$f":"IF(F76=\"\",\"\",M77+J82)","v":""}]
[]
[null,null,null,null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[null,null,null,null,null,null,null,{"$f":"M79","v":12},{"$f":"F83","v":0},null,{"$f":"H85-2","v":10},{"$f":"K85*I85","v":0},null,{"$f":"IF(F76=\"\",\"\",L85+1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"To Center of Sample"]
[]
[null,null,null,null,"SUBLOT",{"$f":"IF(Menu!R10=\"\",\"\",Menu!R10)","v":""},null,null,null,"TONS IN SUBLOT  \"T\"",null,null,{"$f":"B10","v":0}]
[null,null,null,null,null,null,null,null,null,"BEGINNING TONS \"BT\"",null,null,{"$f":"M78","v":3000}]
[null,null,null,null,"TECHNICIAN",{"$f":"IF($F$18=\"\",\"\",$F$18)","v":""},null,null,null,"ENDING TONS \"ET\"",null,null,{"$f":"M88+M89","v":3000}]
[null,null,null,null,null,null,null,null,null,"WIDTH",null,null,{"$f":"IF($M$19=\"\",\"\",$M$19)","v":12}]
[]
[null,null,null,null,"     RANDOM NO.",null,null,"T","A","X=T x A","TONS = BT + X"]
[null,null,null,null,"A","B",null,{"$f":"M88","v":0},{"$f":"E95","v":0},{"$f":"H94*I94","v":0},{"$f":"IF(F88=\"\",\"\",M89+J94)","v":""}]
[]
[null,null,null,null,null,null,null,"WIDTH","B","W = WIDTH - 2'",null,"W x B","OFFSET = 1+W x B"]
[null,null,null,null,null,null,null,{"$f":"M91","v":12},{"$f":"F95","v":0},null,{"$f":"H97-2","v":10},{"$f":"K97*I97","v":0},null,{"$f":"IF(F88=\"\",\"\",L97+1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"To Center of Sample"]

{"sheet":"Density","index":4,"n_rows":68,"n_cols":24,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,8,44,9],[53,8,53,9],[62,8,62,9],[8,8,8,9],[17,8,17,9],[26,8,26,9],[35,8,35,9],[44,14,44,15],[53,14,53,15],[62,14,62,15],[8,14,8,15],[17,14,17,15],[26,14,26,15],[35,14,35,15]]}
["MAT COMPACTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND(),4)","v":5.7099999999999998E-2},{"$f":"ROUND(RAND(),4)","v":0.69040000000000001}]
["JOB",{"$f":"Properties!B3","v":0},null,"ROUTE",{"$f":"Properties!E3","v":0},"MIX NO.",{"$f":"UPPER(Properties!G3)","v":{"$error":"#VALUE!"}},null,"LOT NO.",{"$f":"Properties!J3","v":0}]
[]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F16=\" \",\" \",+'Loose Mix'!F16)","v":"A"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,null,null,null,1]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M16","v":750},null,"RANDOM NO.",null,null,{"$f":"W8","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X8","v":0},null,null,null,null,null,null,{"$f":"ROUND(H9-IF(AND(0<=H9,H9<=V9),V8,IF(AND(V9<H9,H9<=V10),V9,IF(AND(V10<H9,H9<=V11),V10,IF(AND(V11<H9,H9<=V12),V11,IF(AND(V12<H9,H9<=V13),V12,V13))))),0)","v":0},{"$f":"ROUND(N9-IF(AND(0<=N9,N9<=V9),V8,IF(AND(V9<N9,N9<=V10),V9,IF(AND(V10<N9,N9<=V11),V10,IF(AND(V11<N9,N9<=V12),V11,IF(AND(V12<N9,N9<=V13),V12,V13))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B14","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V6+IF(AND(V8<=H9,H9<=V9),'Loose Mix'!B14,IF(AND(V9<H9,H9<=V10),'Loose Mix'!B15,IF(AND(V10<H9,H9<=V11),'Loose Mix'!B16,IF(AND(V11<H9,H9<=V12),'Loose Mix'!B17,IF(AND(V12<H9,H9<=V13),'Loose Mix'!B18,'Loose Mix'!B19)))))","v":200},{"$f":"W6+IF(AND(V8<=N9,N9<=V9),'Loose Mix'!B14,IF(AND(V9<N9,N9<=V10),'Loose Mix'!B15,IF(AND(V10<N9,N9<=V11),'Loose Mix'!B16,IF(AND(V11<N9,N9<=V12),'Loose Mix'!B17,IF(AND(V12<N9,N9<=V13),'Loose Mix'!B18,'Loose Mix'!B19)))))","v":200}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D14:'Loose Mix'!D19,COUNT('Loose Mix'!D14:'Loose Mix'!D19),1)","v":300},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V8<=H9,H9<=V9),S9,IF(AND(V9<H9,H9<=V10),S10,IF(AND(V10<H9,H9<=V11),S11,IF(AND(V11<H9,H9<=V12),S12,IF(AND(V12<H9,H9<=V13),S13,S14)))))","v":0},{"$f":"IF(AND(V8<=N9+F9,N9+F9<=V9),S9,IF(AND(V9<N9+F9,N9+F9<=V10),S10,IF(AND(V10<F9,F9<=V11),S11,IF(AND(V11<F9,F9<=V12),S12,IF(AND(V12<F9,F9<=V13),S13,S14)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V14","v":100},null,{"$f":"IF($V$5=2,ROUND(D9/2,0),ROUND(D9,0))","v":100},{"$f":"G6","v":0},{"$f":"F9*G9","v":0},{"$f":"IF(B5=\"\",\"\",V7)","v":200},null,null,{"$f":"IF($V$5=2,ROUND(D9/2,0),0)","v":0},{"$f":"M6","v":0},{"$f":"IF($V$5=2,F9+L9*M9,0)","v":0},{"$f":"IF(AND($V$5=2,B5<>\"\"),W7,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A14","v":0},null,{"$f":"'Loose Mix'!D14-'Loose Mix'!B14","v":100},{"$f":"U9","v":100}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M19","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I6>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O6>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A15","v":0},null,{"$f":"'Loose Mix'!D15-'Loose Mix'!B15","v":0},{"$f":"U10+V9","v":100}]
[null,null,null,null,null,{"$f":"D10-I6*0.5","v":12},{"$f":"H6","v":0},null,{"$f":"F11*G11+IF(I6>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D10-O6*0.5,0)","v":0},{"$f":"N6","v":0},null,{"$f":"L11*M11+IF(O6>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A16","v":0},null,{"$f":"'Loose Mix'!D16-'Loose Mix'!B16","v":0},{"$f":"U11+V10","v":100}]
[null,null,null,null,null,{"$f":"IF(I6>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O6>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A17","v":0},null,{"$f":"'Loose Mix'!D17-'Loose Mix'!B17","v":0},{"$f":"U12+V11","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A18","v":0},null,{"$f":"'Loose Mix'!D18-'Loose Mix'!B18","v":0},{"$f":"U13+V12","v":100}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F28=\" \",\" \",+'Loose Mix'!F28)","v":"B"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A19","v":0},null,{"$f":"'Loose Mix'!D19-'Loose Mix'!B19","v":0},{"$f":"U14+V13","v":100}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M28","v":750},null,"RANDOM NO.",null,null,{"$f":"W17","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X17","v":0},null,null,null,null,null,null,{"$f":"ROUND(H18-IF(AND(0<=H18,H18<=V18),V17,IF(AND(V18<H18,H18<=V19),V18,IF(AND(V19<H18,H18<=V20),V19,IF(AND(V20<H18,H18<=V21),V20,IF(AND(V21<H18,H18<=V22),V21,V22))))),0)","v":0},{"$f":"ROUND(N18-IF(AND(0<=N18,N18<=V18),V17,IF(AND(V18<N18,N18<=V19),V18,IF(AND(V19<N18,N18<=V20),V19,IF(AND(V20<N18,N18<=V21),V20,IF(AND(V21<N18,N18<=V22),V21,V22))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B21","v":300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V15+IF(AND(V17<=H18,H18<=V18),'Loose Mix'!B21,IF(AND(V18<H18,H18<=V19),'Loose Mix'!B22,IF(AND(V19<H18,H18<=V20),'Loose Mix'!B23,IF(AND(V20<H18,H18<=V21),'Loose Mix'!B24,IF(AND(V21<H18,H18<=V22),'Loose Mix'!B25,'Loose Mix'!B26)))))","v":300},{"$f":"W15+IF(AND(V17<=N18,N18<=V18),'Loose Mix'!B21,IF(AND(V18<N18,N18<=V19),'Loose Mix'!B22,IF(AND(V19<N18,N18<=V20),'Loose Mix'!B23,IF(AND(V20<N18,N18<=V21),'Loose Mix'!B24,IF(AND(V21<N18,N18<=V22),'Loose Mix'!B25,'Loose Mix'!B26)))))","v":300}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D21:'Loose Mix'!D26,COUNT('Loose Mix'!D21:'Loose Mix'!D26),1)","v":400},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V17<=H18,H18<=V18),S18,IF(AND(V18<H18,H18<=V19),S19,IF(AND(V19<H18,H18<=V20),S20,IF(AND(V20<H18,H18<=V21),S21,IF(AND(V21<H18,H18<=V22),S22,S23)))))","v":0},{"$f":"IF(AND(V17<=N18+F18,N18+F18<=V18),S18,IF(AND(V18<N18+F18,N18+F18<=V19),S19,IF(AND(V19<F18,F18<=V20),S20,IF(AND(V20<F18,F18<=V21),S21,IF(AND(V21<F18,F18<=V22),S22,S23)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V23","v":100},null,{"$f":"IF($V$5=2,ROUND(D18/2,0),ROUND(D18,0))","v":100},{"$f":"G15","v":0},{"$f":"F18*G18","v":0},{"$f":"IF(B14=\"\",\"\",V16)","v":300},null,null,{"$f":"IF($V$5=2,ROUND(D18/2,0),0)","v":0},{"$f":"M15","v":0},{"$f":"IF($V$5=2,F18+L18*M18,0)","v":0},{"$f":"IF(AND($V$5=2,B14<>\"\"),W16,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A21","v":0},null,{"$f":"'Loose Mix'!D21-'Loose Mix'!B21","v":100},{"$f":"U18","v":100}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M31","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I15>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O15>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A22","v":0},null,{"$f":"'Loose Mix'!D22-'Loose Mix'!B22","v":0},{"$f":"U19+V18","v":100}]
[null,null,null,null,null,{"$f":"D19-I15*0.5","v":12},{"$f":"H15","v":0},null,{"$f":"F20*G20+IF(I15>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D19-O15*0.5,0)","v":0},{"$f":"N15","v":0},null,{"$f":"L20*M20+IF(O15>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A23","v":0},null,{"$f":"'Loose Mix'!D23-'Loose Mix'!B23","v":0},{"$f":"U20+V19","v":100}]
[null,null,null,null,null,{"$f":"IF(I15>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O15>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A24","v":0},null,{"$f":"'Loose Mix'!D24-'Loose Mix'!B24","v":0},{"$f":"U21+V20","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A25","v":0},null,{"$f":"'Loose Mix'!D25-'Loose Mix'!B25","v":0},{"$f":"U22+V21","v":100}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F40=\" \",\" \",+'Loose Mix'!F40)","v":"C"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A26","v":0},null,{"$f":"'Loose Mix'!D26-'Loose Mix'!B26","v":0},{"$f":"U23+V22","v":100}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M40","v":750},null,"RANDOM NO.",null,null,{"$f":"W26","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X26","v":0},null,null,null,null,null,null,{"$f":"ROUND(H27-IF(AND(0<=H27,H27<=V27),V26,IF(AND(V27<H27,H27<=V28),V27,IF(AND(V28<H27,H27<=V29),V28,IF(AND(V29<H27,H27<=V30),V29,IF(AND(V30<H27,H27<=V31),V30,V31))))),0)","v":0},{"$f":"ROUND(N27-IF(AND(0<=N27,N27<=V27),V26,IF(AND(V27<N27,N27<=V28),V27,IF(AND(V28<N27,N27<=V29),V28,IF(AND(V29<N27,N27<=V30),V29,IF(AND(V30<N27,N27<=V31),V30,V31))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B28","v":400},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V24+IF(AND(V26<=H27,H27<=V27),'Loose Mix'!B28,IF(AND(V27<H27,H27<=V28),'Loose Mix'!B29,IF(AND(V28<H27,H27<=V29),'Loose Mix'!B30,IF(AND(V29<H27,H27<=V30),'Loose Mix'!B31,IF(AND(V30<H27,H27<=V31),'Loose Mix'!B32,'Loose Mix'!B33)))))","v":400},{"$f":"W24+IF(AND(V26<=N27,N27<=V27),'Loose Mix'!B28,IF(AND(V27<N27,N27<=V28),'Loose Mix'!B29,IF(AND(V28<N27,N27<=V29),'Loose Mix'!B30,IF(AND(V29<N27,N27<=V30),'Loose Mix'!B31,IF(AND(V30<N27,N27<=V31),'Loose Mix'!B32,'Loose Mix'!B33)))))","v":400}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D28:'Loose Mix'!D33,COUNT('Loose Mix'!D28:'Loose Mix'!D33),1)","v":500},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V26<=H27,H27<=V27),S27,IF(AND(V27<H27,H27<=V28),S28,IF(AND(V28<H27,H27<=V29),S29,IF(AND(V29<H27,H27<=V30),S30,IF(AND(V30<H27,H27<=V31),S31,S32)))))","v":0},{"$f":"IF(AND(V26<=N27+F27,N27+F27<=V27),S27,IF(AND(V27<N27+F27,N27+F27<=V28),S28,IF(AND(V28<F27,F27<=V29),S29,IF(AND(V29<F27,F27<=V30),S30,IF(AND(V30<F27,F27<=V31),S31,S32)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V32","v":100},null,{"$f":"IF($V$5=2,ROUND(D27/2,0),ROUND(D27,0))","v":100},{"$f":"G24","v":0},{"$f":"F27*G27","v":0},{"$f":"IF(B23=\"\",\"\",V25)","v":400},null,null,{"$f":"IF($V$5=2,ROUND(D27/2,0),0)","v":0},{"$f":"M24","v":0},{"$f":"IF($V$5=2,F27+L27*M27,0)","v":0},{"$f":"IF(AND($V$5=2,B23<>\"\"),W25,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A28","v":0},null,{"$f":"'Loose Mix'!D28-'Loose Mix'!B28","v":100},{"$f":"U27","v":100}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M43","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I24>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O24>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A29","v":0},null,{"$f":"'Loose Mix'!D29-'Loose Mix'!B29","v":0},{"$f":"U28+V27","v":100}]
[null,null,null,null,null,{"$f":"D28-I24*0.5","v":12},{"$f":"H24","v":0},null,{"$f":"F29*G29+IF(I24>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D28-O24*0.5,0)","v":0},{"$f":"N24","v":0},null,{"$f":"L29*M29+IF(O24>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A30","v":0},null,{"$f":"'Loose Mix'!D30-'Loose Mix'!B30","v":0},{"$f":"U29+V28","v":100}]
[null,null,null,null,null,{"$f":"IF(I24>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O24>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A31","v":0},null,{"$f":"'Loose Mix'!D31-'Loose Mix'!B31","v":0},{"$f":"U30+V29","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A32","v":0},null,{"$f":"'Loose Mix'!D32-'Loose Mix'!B32","v":0},{"$f":"U31+V30","v":100}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F52=\" \",\" \",+'Loose Mix'!F52)","v":"D"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A33","v":0},null,{"$f":"'Loose Mix'!D33-'Loose Mix'!B33","v":0},{"$f":"U32+V31","v":100}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M52","v":750},null,"RANDOM NO.",null,null,{"$f":"W35","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X35","v":0},null,null,null,null,null,null,{"$f":"ROUND(H36-IF(AND(0<=H36,H36<=V36),V35,IF(AND(V36<H36,H36<=V37),V36,IF(AND(V37<H36,H36<=V38),V37,IF(AND(V38<H36,H36<=V39),V38,IF(AND(V39<H36,H36<=V40),V39,V40))))),0)","v":0},{"$f":"ROUND(N36-IF(AND(0<=N36,N36<=V36),V35,IF(AND(V36<N36,N36<=V37),V36,IF(AND(V37<N36,N36<=V38),V37,IF(AND(V38<N36,N36<=V39),V38,IF(AND(V39<N36,N36<=V40),V39,V40))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B35","v":500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V33+IF(AND(V35<=H36,H36<=V36),'Loose Mix'!B35,IF(AND(V36<H36,H36<=V37),'Loose Mix'!B36,IF(AND(V37<H36,H36<=V38),'Loose Mix'!B37,IF(AND(V38<H36,H36<=V39),'Loose Mix'!B38,IF(AND(V39<H36,H36<=V40),'Loose Mix'!B39,'Loose Mix'!B40)))))","v":500},{"$f":"W33+IF(AND(V35<=N36,N36<=V36),'Loose Mix'!B35,IF(AND(V36<N36,N36<=V37),'Loose Mix'!B36,IF(AND(V37<N36,N36<=V38),'Loose Mix'!B37,IF(AND(V38<N36,N36<=V39),'Loose Mix'!B38,IF(AND(V39<N36,N36<=V40),'Loose Mix'!B39,'Loose Mix'!B40)))))","v":500}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D35:'Loose Mix'!D40,COUNT('Loose Mix'!D35:'Loose Mix'!D40),1)","v":610},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V35<=H36,H36<=V36),S36,IF(AND(V36<H36,H36<=V37),S37,IF(AND(V37<H36,H36<=V38),S38,IF(AND(V38<H36,H36<=V39),S39,IF(AND(V39<H36,H36<=V40),S40,S41)))))","v":0},{"$f":"IF(AND(V35<=N36+F36,N36+F36<=V36),S36,IF(AND(V36<N36+F36,N36+F36<=V37),S37,IF(AND(V37<F36,F36<=V38),S38,IF(AND(V38<F36,F36<=V39),S39,IF(AND(V39<F36,F36<=V40),S40,S41)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V41","v":110},null,{"$f":"IF($V$5=2,ROUND(D36/2,0),ROUND(D36,0))","v":110},{"$f":"G33","v":0},null,{"$f":"IF(B32=\"\",\"\",V34)","v":500},null,null,{"$f":"IF($V$5=2,ROUND(D36/2,0),0)","v":0},{"$f":"M33","v":0},{"$f":"IF($V$5=2,F36+L36*M36,0)","v":0},{"$f":"IF(AND($V$5=2,B32<>\"\"),W34,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A35","v":0},null,{"$f":"'Loose Mix'!D35-'Loose Mix'!B35","v":110},{"$f":"U36","v":110}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M55","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I33>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O33>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A36","v":0},null,{"$f":"'Loose Mix'!D36-'Loose Mix'!B36","v":0},{"$f":"U37+V36","v":110}]
[null,null,null,null,null,{"$f":"D37-I33*0.5","v":12},{"$f":"H33","v":0},null,{"$f":"F38*G38+IF(I33>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D37-O33*0.5,0)","v":0},{"$f":"N33","v":0},null,{"$f":"L38*M38+IF(O33>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A37","v":0},null,{"$f":"'Loose Mix'!D37-'Loose Mix'!B37","v":0},{"$f":"U38+V37","v":110}]
[null,null,null,null,null,{"$f":"IF(I33>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O33>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A38","v":0},null,{"$f":"'Loose Mix'!D38-'Loose Mix'!B38","v":0},{"$f":"U39+V38","v":110}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A39","v":0},null,{"$f":"'Loose Mix'!D39-'Loose Mix'!B39","v":0},{"$f":"U40+V39","v":110}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F64=\" \",\" \",+'Loose Mix'!F64)","v":""},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A40","v":0},null,{"$f":"'Loose Mix'!D40-'Loose Mix'!B40","v":0},{"$f":"U41+V40","v":110}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M64","v":0},null,"RANDOM NO.",null,null,{"$f":"W44","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X44","v":0},null,null,null,null,null,null,{"$f":"ROUND(H45-IF(AND(0<=H45,H45<=V45),V44,IF(AND(V45<H45,H45<=V46),V45,IF(AND(V46<H45,H45<=V47),V46,IF(AND(V47<H45,H45<=V48),V47,IF(AND(V48<H45,H45<=V49),V48,V49))))),0)","v":610},{"$f":"ROUND(N45-IF(AND(0<=N45,N45<=V45),V44,IF(AND(V45<N45,N45<=V46),V45,IF(AND(V46<N45,N45<=V47),V46,IF(AND(V47<N45,N45<=V48),V47,IF(AND(V48<N45,N45<=V49),V48,V49))))),0)","v":610}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B42","v":610},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V42+IF(AND(V44<=H45,H45<=V45),'Loose Mix'!B42,IF(AND(V45<H45,H45<=V46),'Loose Mix'!B43,IF(AND(V46<H45,H45<=V47),'Loose Mix'!B44,IF(AND(V47<H45,H45<=V48),'Loose Mix'!B45,IF(AND(V48<H45,H45<=V49),'Loose Mix'!B46,'Loose Mix'!B47)))))","v":610},{"$f":"W42+IF(AND(V44<=N45,N45<=V45),'Loose Mix'!B42,IF(AND(V45<N45,N45<=V46),'Loose Mix'!B43,IF(AND(V46<N45,N45<=V47),'Loose Mix'!B44,IF(AND(V47<N45,N45<=V48),'Loose Mix'!B45,IF(AND(V48<N45,N45<=V49),'Loose Mix'!B46,'Loose Mix'!B47)))))","v":610}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D42:'Loose Mix'!D47,COUNT('Loose Mix'!D42:'Loose Mix'!D47),1)","v":0},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V44<=H45,H45<=V45),S45,IF(AND(V45<H45,H45<=V46),S46,IF(AND(V46<H45,H45<=V47),S47,IF(AND(V47<H45,H45<=V48),S48,IF(AND(V48<H45,H45<=V49),S49,S50)))))","v":0},{"$f":"IF(AND(V44<=N45+F45,N45+F45<=V45),S45,IF(AND(V45<N45+F45,N45+F45<=V46),S46,IF(AND(V46<F45,F45<=V47),S47,IF(AND(V47<F45,F45<=V48),S48,IF(AND(V48<F45,F45<=V49),S49,S50)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V50","v":-610},null,{"$f":"IF($V$5=2,ROUND(D45/2,0),ROUND(D45,0))","v":-610},{"$f":"G42","v":0},{"$f":"F45*G45","v":0},{"$f":"IF(B41=\"\",\"\",V43)","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D45/2,0),0)","v":0},{"$f":"M42","v":0},{"$f":"IF($V$5=2,F45+L45*M45,0)","v":0},{"$f":"IF(AND($V$5=2,B41<>\"\"),W43,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A42","v":0},null,{"$f":"'Loose Mix'!D42-'Loose Mix'!B42","v":-610},{"$f":"U45","v":-610}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M67","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I42>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O42>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A43","v":0},null,{"$f":"'Loose Mix'!D43-'Loose Mix'!B43","v":0},{"$f":"U46+V45","v":-610}]
[null,null,null,null,null,{"$f":"D46-I42*0.5","v":12},{"$f":"H42","v":0},null,{"$f":"F47*G47+IF(I42>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D46-O42*0.5,0)","v":0},{"$f":"N42","v":0},null,{"$f":"L47*M47+IF(O42>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A44","v":0},null,{"$f":"'Loose Mix'!D44-'Loose Mix'!B44","v":0},{"$f":"U47+V46","v":-610}]
[null,null,null,null,null,{"$f":"IF(I42>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O42>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A45","v":0},null,{"$f":"'Loose Mix'!D45-'Loose Mix'!B45","v":0},{"$f":"U48+V47","v":-610}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A46","v":0},null,{"$f":"'Loose Mix'!D46-'Loose Mix'!B46","v":0},{"$f":"U49+V48","v":-610}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F76=\" \",\" \",+'Loose Mix'!F76)","v":""},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A47","v":0},null,{"$f":"'Loose Mix'!D47-'Loose Mix'!B47","v":0},{"$f":"U50+V49","v":-610}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M76","v":0},null,"RANDOM NO.",null,null,{"$f":"W53","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X53","v":0},null,null,null,null,null,null,{"$f":"ROUND(H54-IF(AND(0<=H54,H54<=V54),V53,IF(AND(V54<H54,H54<=V55),V54,IF(AND(V55<H54,H54<=V56),V55,IF(AND(V56<H54,H54<=V57),V56,IF(AND(V57<H54,H54<=V58),V57,V58))))),0)","v":0},{"$f":"ROUND(N54-IF(AND(0<=N54,N54<=V54),V53,IF(AND(V54<N54,N54<=V55),V54,IF(AND(V55<N54,N54<=V56),V55,IF(AND(V56<N54,N54<=V57),V56,IF(AND(V57<N54,N54<=V58),V57,V58))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V51+IF(AND(V53<=H54,H54<=V54),'Loose Mix'!B49,IF(AND(V54<H54,H54<=V55),'Loose Mix'!B50,IF(AND(V55<H54,H54<=V56),'Loose Mix'!B51,IF(AND(V56<H54,H54<=V57),'Loose Mix'!B52,IF(AND(V57<H54,H54<=V58),'Loose Mix'!B53,'Loose Mix'!B54)))))","v":0},{"$f":"W51+IF(AND(V53<=N54,N54<=V54),'Loose Mix'!B49,IF(AND(V54<N54,N54<=V55),'Loose Mix'!B50,IF(AND(V55<N54,N54<=V56),'Loose Mix'!B51,IF(AND(V56<N54,N54<=V57),'Loose Mix'!B52,IF(AND(V57<N54,N54<=V58),'Loose Mix'!B53,'Loose Mix'!B54)))))","v":0}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D49:'Loose Mix'!D54,COUNT('Loose Mix'!D49:'Loose Mix'!D54),1)","v":0},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V53<=H54,H54<=V54),S54,IF(AND(V54<H54,H54<=V55),S55,IF(AND(V55<H54,H54<=V56),S56,IF(AND(V56<H54,H54<=V57),S57,IF(AND(V57<H54,H54<=V58),S58,S59)))))","v":0},{"$f":"IF(AND(V53<=N54+F54,N54+F54<=V54),S54,IF(AND(V54<N54+F54,N54+F54<=V55),S55,IF(AND(V55<F54,F54<=V56),S56,IF(AND(V56<F54,F54<=V57),S57,IF(AND(V57<F54,F54<=V58),S58,S59)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V59","v":0},null,{"$f":"IF($V$5=2,ROUND(D54/2,0),ROUND(D54,0))","v":0},{"$f":"G51","v":0},{"$f":"F54*G54","v":0},{"$f":"IF(B50=\"\",\"\",V52)","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D54/2,0),0)","v":0},{"$f":"M51","v":0},{"$f":"IF($V$5=2,F54+L54*M54,0)","v":0},{"$f":"IF(AND($V$5=2,B50<>\"\"),W52,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A49","v":0},null,{"$f":"'Loose Mix'!D49-'Loose Mix'!B49","v":0},{"$f":"U54","v":0}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M79","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I51>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O51>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A50","v":0},null,{"$f":"'Loose Mix'!D50-'Loose Mix'!B50","v":0},{"$f":"U55+V54","v":0}]
[null,null,null,null,null,{"$f":"D55-I51*0.5","v":12},{"$f":"H51","v":0},null,{"$f":"F56*G56+IF(I51>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D55-O51*0.5,0)","v":0},{"$f":"N51","v":0},null,{"$f":"L56*M56+IF(O51>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A51","v":0},null,{"$f":"'Loose Mix'!D51-'Loose Mix'!B51","v":0},{"$f":"U56+V55","v":0}]
[null,null,null,null,null,{"$f":"IF(I51>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O51>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A52","v":0},null,{"$f":"'Loose Mix'!D52-'Loose Mix'!B52","v":0},{"$f":"U57+V56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A53","v":0},null,{"$f":"'Loose Mix'!D53-'Loose Mix'!B53","v":0},{"$f":"U58+V57","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F88=\" \",\" \",+'Loose Mix'!F88)","v":""},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A54","v":0},null,{"$f":"'Loose Mix'!D54-'Loose Mix'!B54","v":0},{"$f":"U59+V58","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M88","v":0},null,"RANDOM NO.",null,null,{"$f":"W62","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X62","v":0},null,null,null,null,null,null,{"$f":"ROUND(H63-IF(AND(0<=H63,H63<=V63),V62,IF(AND(V63<H63,H63<=V64),V63,IF(AND(V64<H63,H63<=V65),V64,IF(AND(V65<H63,H63<=V66),V65,IF(AND(V66<H63,H63<=V67),V66,V67))))),0)","v":0},{"$f":"ROUND(N63-IF(AND(0<=N63,N63<=V63),V62,IF(AND(V63<N63,N63<=V64),V63,IF(AND(V64<N63,N63<=V65),V64,IF(AND(V65<N63,N63<=V66),V65,IF(AND(V66<N63,N63<=V67),V66,V67))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V60+IF(AND(V62<=H63,H63<=V63),'Loose Mix'!B56,IF(AND(V63<H63,H63<=V64),'Loose Mix'!B57,IF(AND(V64<H63,H63<=V65),'Loose Mix'!B58,IF(AND(V65<H63,H63<=V66),'Loose Mix'!B59,IF(AND(V66<H63,H63<=V67),'Loose Mix'!B60,'Loose Mix'!B61)))))","v":0},{"$f":"W60+IF(AND(V62<=N63,N63<=V63),'Loose Mix'!B56,IF(AND(V63<N63,N63<=V64),'Loose Mix'!B57,IF(AND(V64<N63,N63<=V65),'Loose Mix'!B58,IF(AND(V65<N63,N63<=V66),'Loose Mix'!B59,IF(AND(V66<N63,N63<=V67),'Loose Mix'!B60,'Loose Mix'!B61)))))","v":0}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D56:'Loose Mix'!D61,COUNT('Loose Mix'!D56:'Loose Mix'!D61),1)","v":{"$error":"#VALUE!"}},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V62<=H63,H63<=V63),S63,IF(AND(V63<H63,H63<=V64),S64,IF(AND(V64<H63,H63<=V65),S65,IF(AND(V65<H63,H63<=V66),S66,IF(AND(V66<H63,H63<=V67),S67,S68)))))","v":0},{"$f":"IF(AND(V62<=N63+F63,N63+F63<=V63),S63,IF(AND(V63<N63+F63,N63+F63<=V64),S64,IF(AND(V64<F63,F63<=V65),S65,IF(AND(V65<F63,F63<=V66),S66,IF(AND(V66<F63,F63<=V67),S67,S68)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V68","v":0},null,{"$f":"IF($V$5=2,ROUND(D63/2,0),ROUND(D63,0))","v":0},{"$f":"G60","v":0},{"$f":"F63*G63","v":0},{"$f":"IF(B59=\"\",\"\",V61)","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D63/2,0),0)","v":0},{"$f":"M60","v":0},{"$f":"IF($V$5=2,F63+L63*M63,0)","v":0},{"$f":"IF(AND($V$5=2,B59<>\"\"),W61,\"\")","v":""},null,null,null,{"$f":"'Loose Mix'!A56","v":0},null,{"$f":"'Loose Mix'!D56-'Loose Mix'!B56","v":0},{"$f":"U63","v":0}]
["WIDTH \"W\"",null,null,{"$f":"'Loose Mix'!M91","v":12},null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(I60>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O60>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A57","v":0},null,{"$f":"'Loose Mix'!D57-'Loose Mix'!B57","v":0},{"$f":"U64+V63","v":0}]
[null,null,null,null,null,{"$f":"D64-I60*0.5","v":12},{"$f":"H60","v":0},null,{"$f":"F65*G65+IF(I60>0,0.5,0)","v":0},null,null,{"$f":"IF($V$5=2,D64-O60*0.5,0)","v":0},{"$f":"N60","v":0},null,{"$f":"L65*M65+IF(O60>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A58","v":0},null,{"$f":"'Loose Mix'!D58-'Loose Mix'!B58","v":0},{"$f":"U65+V64","v":0}]
["ALWAYS MEASURE OFFSET FROM SAME EDGE",null,null,null,null,{"$f":"IF(I60>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O60>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A59","v":0},null,{"$f":"'Loose Mix'!D59-'Loose Mix'!B59","v":0},{"$f":"U66+V65","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A60","v":0},null,{"$f":"'Loose Mix'!D60-'Loose Mix'!B60","v":0},{"$f":"U67+V66","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A61","v":0},null,{"$f":"'Loose Mix'!D61-'Loose Mix'!B61","v":0},{"$f":"U68+V67","v":0}]

{"sheet":"LongDensity","index":5,"n_rows":68,"n_cols":24,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,8,44,9],[53,8,53,9],[62,8,62,9],[8,8,8,9],[17,8,17,9],[26,8,26,9],[35,8,35,9],[44,14,44,15],[53,14,53,15],[62,14,62,15],[8,14,8,15],[17,14,17,15],[26,14,26,15],[35,14,35,15]]}
["LONGITUDINAL JOINT DENSITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND(),4)","v":0.7258},{"$f":"ROUND(RAND(),4)","v":0.8478}]
["JOB",{"$f":"Properties!B3","v":0},null,"ROUTE",{"$f":"Properties!E3","v":0},"MIX NO.",{"$f":"UPPER(Properties!G3)","v":{"$error":"#VALUE!"}},null,"LOT NO.",{"$f":"Properties!J3","v":0}]
[]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F16=\" \",\" \",+'Loose Mix'!F16)","v":"A"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE"]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M16","v":750},null,"RANDOM NO.",null,null,{"$f":"W8","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X8","v":0},null,null,null,null,null,null,{"$f":"ROUND(H9-IF(AND(0<=H9,H9<=V9),V8,IF(AND(V9<H9,H9<=V10),V9,IF(AND(V10<H9,H9<=V11),V10,IF(AND(V11<H9,H9<=V12),V11,IF(AND(V12<H9,H9<=V13),V12,V13))))),0)","v":0},{"$f":"ROUND(N9-IF(AND(0<=N9,N9<=V9),V8,IF(AND(V9<N9,N9<=V10),V9,IF(AND(V10<N9,N9<=V11),V10,IF(AND(V11<N9,N9<=V12),V11,IF(AND(V12<N9,N9<=V13),V12,V13))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B14","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V6+IF(AND(V8<=H9,H9<=V9),'Loose Mix'!B14,IF(AND(V9<H9,H9<=V10),'Loose Mix'!B15,IF(AND(V10<H9,H9<=V11),'Loose Mix'!B16,IF(AND(V11<H9,H9<=V12),'Loose Mix'!B17,IF(AND(V12<H9,H9<=V13),'Loose Mix'!B18,'Loose Mix'!B19)))))","v":200},{"$f":"W6+IF(AND(V8<=N9,N9<=V9),'Loose Mix'!B14,IF(AND(V9<N9,N9<=V10),'Loose Mix'!B15,IF(AND(V10<N9,N9<=V11),'Loose Mix'!B16,IF(AND(V11<N9,N9<=V12),'Loose Mix'!B17,IF(AND(V12<N9,N9<=V13),'Loose Mix'!B18,'Loose Mix'!B19)))))","v":200}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D14:'Loose Mix'!D19,COUNT('Loose Mix'!D14:'Loose Mix'!D19),1)","v":300},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V8<=H9,H9<=V9),S9,IF(AND(V9<H9,H9<=V10),S10,IF(AND(V10<H9,H9<=V11),S11,IF(AND(V11<H9,H9<=V12),S12,IF(AND(V12<H9,H9<=V13),S13,S14)))))","v":0},{"$f":"IF(AND(V8<=N9+F9,N9+F9<=V9),S9,IF(AND(V9<N9+F9,N9+F9<=V10),S10,IF(AND(V10<F9,F9<=V11),S11,IF(AND(V11<F9,F9<=V12),S12,IF(AND(V12<F9,F9<=V13),S13,S14)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V14","v":0},null,{"$f":"IF($V$5=2,ROUND(D9/2,0),ROUND(D9,0))","v":0},{"$f":"G6","v":0},{"$f":"F9*G9","v":0},{"$f":"IF(I6>0,V7,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D9/2,0),0)","v":0},{"$f":"M6","v":0},{"$f":"IF($V$5=2,F9+L9*M9,0)","v":0},{"$f":"IF($V$5=2,W7,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A14","v":0},null,{"$f":"IF(S9>0,'Loose Mix'!D14-'Loose Mix'!B14,0)","v":0},{"$f":"U9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I6=2,H6>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O6>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A15","v":0},null,{"$f":"IF(S10>0,'Loose Mix'!D15-'Loose Mix'!B15,0)","v":0},{"$f":"U10+V9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D10-O6*0.5,0)","v":0},{"$f":"N6","v":0},null,{"$f":"L11*M11+IF(O6>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A16","v":0},null,{"$f":"IF(S11>0,'Loose Mix'!D16-'Loose Mix'!B16,0)","v":0},{"$f":"U11+V10","v":0}]
[null,null,null,null,null,{"$f":"IF(I6>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O6>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A17","v":0},null,{"$f":"IF(S12>0,'Loose Mix'!D17-'Loose Mix'!B17,0)","v":0},{"$f":"U12+V11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A18","v":0},null,{"$f":"IF(S13>0,'Loose Mix'!D18-'Loose Mix'!B18,0)","v":0},{"$f":"U13+V12","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F28=\" \",\" \",+'Loose Mix'!F28)","v":"B"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A19","v":0},null,{"$f":"IF(S14>0,'Loose Mix'!D19-'Loose Mix'!B19,0)","v":0},{"$f":"U14+V13","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M28","v":750},null,"RANDOM NO.",null,null,{"$f":"W17","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X17","v":0},null,null,null,null,null,null,{"$f":"ROUND(H18-IF(AND(0<=H18,H18<=V18),V17,IF(AND(V18<H18,H18<=V19),V18,IF(AND(V19<H18,H18<=V20),V19,IF(AND(V20<H18,H18<=V21),V20,IF(AND(V21<H18,H18<=V22),V21,V22))))),0)","v":0},{"$f":"ROUND(N18-IF(AND(0<=N18,N18<=V18),V17,IF(AND(V18<N18,N18<=V19),V18,IF(AND(V19<N18,N18<=V20),V19,IF(AND(V20<N18,N18<=V21),V20,IF(AND(V21<N18,N18<=V22),V21,V22))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B21","v":300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V15+IF(AND(V17<=H18,H18<=V18),'Loose Mix'!B21,IF(AND(V18<H18,H18<=V19),'Loose Mix'!B22,IF(AND(V19<H18,H18<=V20),'Loose Mix'!B23,IF(AND(V20<H18,H18<=V21),'Loose Mix'!B24,IF(AND(V21<H18,H18<=V22),'Loose Mix'!B25,'Loose Mix'!B26)))))","v":300},{"$f":"W15+IF(AND(V17<=N18,N18<=V18),'Loose Mix'!B21,IF(AND(V18<N18,N18<=V19),'Loose Mix'!B22,IF(AND(V19<N18,N18<=V20),'Loose Mix'!B23,IF(AND(V20<N18,N18<=V21),'Loose Mix'!B24,IF(AND(V21<N18,N18<=V22),'Loose Mix'!B25,'Loose Mix'!B26)))))","v":300}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D21:'Loose Mix'!D26,COUNT('Loose Mix'!D21:'Loose Mix'!D26),1)","v":400},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V17<=H18,H18<=V18),S18,IF(AND(V18<H18,H18<=V19),S19,IF(AND(V19<H18,H18<=V20),S20,IF(AND(V20<H18,H18<=V21),S21,IF(AND(V21<H18,H18<=V22),S22,S23)))))","v":0},{"$f":"IF(AND(V17<=N18+F18,N18+F18<=V18),S18,IF(AND(V18<N18+F18,N18+F18<=V19),S19,IF(AND(V19<F18,F18<=V20),S20,IF(AND(V20<F18,F18<=V21),S21,IF(AND(V21<F18,F18<=V22),S22,S23)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V23","v":0},null,{"$f":"IF($V$5=2,ROUND(D18/2,0),ROUND(D18,0))","v":0},{"$f":"G15","v":0},{"$f":"F18*G18","v":0},{"$f":"IF(I15>0,V16,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D18/2,0),0)","v":0},{"$f":"M15","v":0},{"$f":"IF($V$5=2,F18+L18*M18,0)","v":0},{"$f":"IF($V$5=2,W16,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A21","v":0},null,{"$f":"IF(S18>0,'Loose Mix'!D21-'Loose Mix'!B21,0)","v":0},{"$f":"U18","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I15=2,H15>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O15>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A22","v":0},null,{"$f":"IF(S19>0,'Loose Mix'!D22-'Loose Mix'!B22,0)","v":0},{"$f":"U19+V18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D19-O15*0.5,0)","v":0},{"$f":"N15","v":0},null,{"$f":"L20*M20+IF(O15>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A23","v":0},null,{"$f":"IF(S20>0,'Loose Mix'!D23-'Loose Mix'!B23,0)","v":0},{"$f":"U20+V19","v":0}]
[null,null,null,null,null,{"$f":"IF(I15>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O15>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A24","v":0},null,{"$f":"IF(S21>0,'Loose Mix'!D24-'Loose Mix'!B24,0)","v":0},{"$f":"U21+V20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A25","v":0},null,{"$f":"IF(S22>0,'Loose Mix'!D25-'Loose Mix'!B25,0)","v":0},{"$f":"U22+V21","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F40=\" \",\" \",+'Loose Mix'!F40)","v":"C"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A26","v":0},null,{"$f":"IF(S23>0,'Loose Mix'!D26-'Loose Mix'!B26,0)","v":0},{"$f":"U23+V22","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M40","v":750},null,"RANDOM NO.",null,null,{"$f":"W26","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X26","v":0},null,null,null,null,null,null,{"$f":"ROUND(H27-IF(AND(0<=H27,H27<=V27),V26,IF(AND(V27<H27,H27<=V28),V27,IF(AND(V28<H27,H27<=V29),V28,IF(AND(V29<H27,H27<=V30),V29,IF(AND(V30<H27,H27<=V31),V30,V31))))),0)","v":0},{"$f":"ROUND(N27-IF(AND(0<=N27,N27<=V27),V26,IF(AND(V27<N27,N27<=V28),V27,IF(AND(V28<N27,N27<=V29),V28,IF(AND(V29<N27,N27<=V30),V29,IF(AND(V30<N27,N27<=V31),V30,V31))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B28","v":400},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V24+IF(AND(V26<=H27,H27<=V27),'Loose Mix'!B28,IF(AND(V27<H27,H27<=V28),'Loose Mix'!B29,IF(AND(V28<H27,H27<=V29),'Loose Mix'!B30,IF(AND(V29<H27,H27<=V30),'Loose Mix'!B31,IF(AND(V30<H27,H27<=V31),'Loose Mix'!B32,'Loose Mix'!B33)))))","v":400},{"$f":"W24+IF(AND(V26<=N27,N27<=V27),'Loose Mix'!B28,IF(AND(V27<N27,N27<=V28),'Loose Mix'!B29,IF(AND(V28<N27,N27<=V29),'Loose Mix'!B30,IF(AND(V29<N27,N27<=V30),'Loose Mix'!B31,IF(AND(V30<N27,N27<=V31),'Loose Mix'!B32,'Loose Mix'!B33)))))","v":400}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D28:'Loose Mix'!D33,COUNT('Loose Mix'!D28:'Loose Mix'!D33),1)","v":500},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V26<=H27,H27<=V27),S27,IF(AND(V27<H27,H27<=V28),S28,IF(AND(V28<H27,H27<=V29),S29,IF(AND(V29<H27,H27<=V30),S30,IF(AND(V30<H27,H27<=V31),S31,S32)))))","v":0},{"$f":"IF(AND(V26<=N27+F27,N27+F27<=V27),S27,IF(AND(V27<N27+F27,N27+F27<=V28),S28,IF(AND(V28<F27,F27<=V29),S29,IF(AND(V29<F27,F27<=V30),S30,IF(AND(V30<F27,F27<=V31),S31,S32)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V32","v":0},null,{"$f":"IF($V$5=2,ROUND(D27/2,0),ROUND(D27,0))","v":0},{"$f":"G24","v":0},{"$f":"F27*G27","v":0},{"$f":"IF(I24>0,V25,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D27/2,0),0)","v":0},{"$f":"M24","v":0},{"$f":"IF($V$5=2,F27+L27*M27,0)","v":0},{"$f":"IF($V$5=2,W25,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A28","v":0},null,{"$f":"IF(S27>0,'Loose Mix'!D28-'Loose Mix'!B28,0)","v":0},{"$f":"U27","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I24=2,H24>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O24>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A29","v":0},null,{"$f":"IF(S28>0,'Loose Mix'!D29-'Loose Mix'!B29,0)","v":0},{"$f":"U28+V27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D28-O24*0.5,0)","v":0},{"$f":"N24","v":0},null,{"$f":"L29*M29+IF(O24>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A30","v":0},null,{"$f":"IF(S29>0,'Loose Mix'!D30-'Loose Mix'!B30,0)","v":0},{"$f":"U29+V28","v":0}]
[null,null,null,null,null,{"$f":"IF(I24>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O24>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A31","v":0},null,{"$f":"IF(S30>0,'Loose Mix'!D31-'Loose Mix'!B31,0)","v":0},{"$f":"U30+V29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A32","v":0},null,{"$f":"IF(S31>0,'Loose Mix'!D32-'Loose Mix'!B32,0)","v":0},{"$f":"U31+V30","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F52=\" \",\" \",+'Loose Mix'!F52)","v":"D"},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A33","v":0},null,{"$f":"IF(S32>0,'Loose Mix'!D33-'Loose Mix'!B33,0)","v":0},{"$f":"U32+V31","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M52","v":750},null,"RANDOM NO.",null,null,{"$f":"W35","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X35","v":0},null,null,null,null,null,null,{"$f":"ROUND(H36-IF(AND(0<=H36,H36<=V36),V35,IF(AND(V36<H36,H36<=V37),V36,IF(AND(V37<H36,H36<=V38),V37,IF(AND(V38<H36,H36<=V39),V38,IF(AND(V39<H36,H36<=V40),V39,V40))))),0)","v":0},{"$f":"ROUND(N36-IF(AND(0<=N36,N36<=V36),V35,IF(AND(V36<N36,N36<=V37),V36,IF(AND(V37<N36,N36<=V38),V37,IF(AND(V38<N36,N36<=V39),V38,IF(AND(V39<N36,N36<=V40),V39,V40))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B35","v":500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V33+IF(AND(V35<=H36,H36<=V36),'Loose Mix'!B35,IF(AND(V36<H36,H36<=V37),'Loose Mix'!B36,IF(AND(V37<H36,H36<=V38),'Loose Mix'!B37,IF(AND(V38<H36,H36<=V39),'Loose Mix'!B38,IF(AND(V39<H36,H36<=V40),'Loose Mix'!B39,'Loose Mix'!B40)))))","v":500},{"$f":"W33+IF(AND(V35<=N36,N36<=V36),'Loose Mix'!B35,IF(AND(V36<N36,N36<=V37),'Loose Mix'!B36,IF(AND(V37<N36,N36<=V38),'Loose Mix'!B37,IF(AND(V38<N36,N36<=V39),'Loose Mix'!B38,IF(AND(V39<N36,N36<=V40),'Loose Mix'!B39,'Loose Mix'!B40)))))","v":500}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D35:'Loose Mix'!D40,COUNT('Loose Mix'!D35:'Loose Mix'!D40),1)","v":610},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V35<=H36,H36<=V36),S36,IF(AND(V36<H36,H36<=V37),S37,IF(AND(V37<H36,H36<=V38),S38,IF(AND(V38<H36,H36<=V39),S39,IF(AND(V39<H36,H36<=V40),S40,S41)))))","v":0},{"$f":"IF(AND(V35<=N36+F36,N36+F36<=V36),S36,IF(AND(V36<N36+F36,N36+F36<=V37),S37,IF(AND(V37<F36,F36<=V38),S38,IF(AND(V38<F36,F36<=V39),S39,IF(AND(V39<F36,F36<=V40),S40,S41)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V41","v":0},null,{"$f":"IF($V$5=2,ROUND(D36/2,0),ROUND(D36,0))","v":0},{"$f":"G33","v":0},{"$f":"F36*G36","v":0},{"$f":"IF(I33>0,V34,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D36/2,0),0)","v":0},{"$f":"M33","v":0},{"$f":"IF($V$5=2,F36+L36*M36,0)","v":0},{"$f":"IF($V$5=2,W34,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A35","v":0},null,{"$f":"IF(S36>0,'Loose Mix'!D35-'Loose Mix'!B35,0)","v":0},{"$f":"U36","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I33=2,H33>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O33>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A36","v":0},null,{"$f":"IF(S37>0,'Loose Mix'!D36-'Loose Mix'!B36,0)","v":0},{"$f":"U37+V36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D37-O33*0.5,0)","v":0},{"$f":"N33","v":0},null,{"$f":"L38*M38+IF(O33>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A37","v":0},null,{"$f":"IF(S38>0,'Loose Mix'!D37-'Loose Mix'!B37,0)","v":0},{"$f":"U38+V37","v":0}]
[null,null,null,null,null,{"$f":"IF(I33>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O33>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A38","v":0},null,{"$f":"IF(S39>0,'Loose Mix'!D38-'Loose Mix'!B38,0)","v":0},{"$f":"U39+V38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A39","v":0},null,{"$f":"IF(S40>0,'Loose Mix'!D39-'Loose Mix'!B39,0)","v":0},{"$f":"U40+V39","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F64=\" \",\" \",+'Loose Mix'!F64)","v":""},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A40","v":0},null,{"$f":"IF(S41>0,'Loose Mix'!D40-'Loose Mix'!B40,0)","v":0},{"$f":"U41+V40","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M64","v":0},null,"RANDOM NO.",null,null,{"$f":"W44","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X44","v":0},null,null,null,null,null,null,{"$f":"ROUND(H45-IF(AND(0<=H45,H45<=V45),V44,IF(AND(V45<H45,H45<=V46),V45,IF(AND(V46<H45,H45<=V47),V46,IF(AND(V47<H45,H45<=V48),V47,IF(AND(V48<H45,H45<=V49),V48,V49))))),0)","v":0},{"$f":"ROUND(N45-IF(AND(0<=N45,N45<=V45),V44,IF(AND(V45<N45,N45<=V46),V45,IF(AND(V46<N45,N45<=V47),V46,IF(AND(V47<N45,N45<=V48),V47,IF(AND(V48<N45,N45<=V49),V48,V49))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B42","v":610},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V42+IF(AND(V44<=H45,H45<=V45),'Loose Mix'!B42,IF(AND(V45<H45,H45<=V46),'Loose Mix'!B43,IF(AND(V46<H45,H45<=V47),'Loose Mix'!B44,IF(AND(V47<H45,H45<=V48),'Loose Mix'!B45,IF(AND(V48<H45,H45<=V49),'Loose Mix'!B46,'Loose Mix'!B47)))))","v":610},{"$f":"W42+IF(AND(V44<=N45,N45<=V45),'Loose Mix'!B42,IF(AND(V45<N45,N45<=V46),'Loose Mix'!B43,IF(AND(V46<N45,N45<=V47),'Loose Mix'!B44,IF(AND(V47<N45,N45<=V48),'Loose Mix'!B45,IF(AND(V48<N45,N45<=V49),'Loose Mix'!B46,'Loose Mix'!B47)))))","v":610}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D42:'Loose Mix'!D47,COUNT('Loose Mix'!D42:'Loose Mix'!D47),1)","v":0},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V44<=H45,H45<=V45),S45,IF(AND(V45<H45,H45<=V46),S46,IF(AND(V46<H45,H45<=V47),S47,IF(AND(V47<H45,H45<=V48),S48,IF(AND(V48<H45,H45<=V49),S49,S50)))))","v":0},{"$f":"IF(AND(V44<=N45+F45,N45+F45<=V45),S45,IF(AND(V45<N45+F45,N45+F45<=V46),S46,IF(AND(V46<F45,F45<=V47),S47,IF(AND(V47<F45,F45<=V48),S48,IF(AND(V48<F45,F45<=V49),S49,S50)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V50","v":0},null,{"$f":"IF($V$5=2,ROUND(D45/2,0),ROUND(D45,0))","v":0},{"$f":"G42","v":0},{"$f":"F45*G45","v":0},{"$f":"IF(I42>0,V43,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D45/2,0),0)","v":0},{"$f":"M42","v":0},{"$f":"IF($V$5=2,F45+L45*M45,0)","v":0},{"$f":"IF($V$5=2,W43,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A42","v":0},null,{"$f":"IF(S45>0,'Loose Mix'!D42-'Loose Mix'!B42,0)","v":0},{"$f":"U45","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I42=2,H42>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O42>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A43","v":0},null,{"$f":"IF(S46>0,'Loose Mix'!D43-'Loose Mix'!B43,0)","v":0},{"$f":"U46+V45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D46-O42*0.5,0)","v":0},{"$f":"N42","v":0},null,{"$f":"L47*M47+IF(O42>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A44","v":0},null,{"$f":"IF(S47>0,'Loose Mix'!D44-'Loose Mix'!B44,0)","v":0},{"$f":"U47+V46","v":0}]
[null,null,null,null,null,{"$f":"IF(I42>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O42>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A45","v":0},null,{"$f":"IF(S48>0,'Loose Mix'!D45-'Loose Mix'!B45,0)","v":0},{"$f":"U48+V47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A46","v":0},null,{"$f":"IF(S49>0,'Loose Mix'!D46-'Loose Mix'!B46,0)","v":0},{"$f":"U49+V48","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F76=\" \",\" \",+'Loose Mix'!F76)","v":""},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A47","v":0},null,{"$f":"IF(S50>0,'Loose Mix'!D47-'Loose Mix'!B47,0)","v":0},{"$f":"U50+V49","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M76","v":0},null,"RANDOM NO.",null,null,{"$f":"W53","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X53","v":0},null,null,null,null,null,null,{"$f":"ROUND(H54-IF(AND(0<=H54,H54<=V54),V53,IF(AND(V54<H54,H54<=V55),V54,IF(AND(V55<H54,H54<=V56),V55,IF(AND(V56<H54,H54<=V57),V56,IF(AND(V57<H54,H54<=V58),V57,V58))))),0)","v":0},{"$f":"ROUND(N54-IF(AND(0<=N54,N54<=V54),V53,IF(AND(V54<N54,N54<=V55),V54,IF(AND(V55<N54,N54<=V56),V55,IF(AND(V56<N54,N54<=V57),V56,IF(AND(V57<N54,N54<=V58),V57,V58))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V51+IF(AND(V53<=H54,H54<=V54),'Loose Mix'!B49,IF(AND(V54<H54,H54<=V55),'Loose Mix'!B50,IF(AND(V55<H54,H54<=V56),'Loose Mix'!B51,IF(AND(V56<H54,H54<=V57),'Loose Mix'!B52,IF(AND(V57<H54,H54<=V58),'Loose Mix'!B53,'Loose Mix'!B54)))))","v":0},{"$f":"W51+IF(AND(V53<=N54,N54<=V54),'Loose Mix'!B49,IF(AND(V54<N54,N54<=V55),'Loose Mix'!B50,IF(AND(V55<N54,N54<=V56),'Loose Mix'!B51,IF(AND(V56<N54,N54<=V57),'Loose Mix'!B52,IF(AND(V57<N54,N54<=V58),'Loose Mix'!B53,'Loose Mix'!B54)))))","v":0}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D49:'Loose Mix'!D54,COUNT('Loose Mix'!D49:'Loose Mix'!D54),1)","v":0},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V53<=H54,H54<=V54),S54,IF(AND(V54<H54,H54<=V55),S55,IF(AND(V55<H54,H54<=V56),S56,IF(AND(V56<H54,H54<=V57),S57,IF(AND(V57<H54,H54<=V58),S58,S59)))))","v":0},{"$f":"IF(AND(V53<=N54+F54,N54+F54<=V54),S54,IF(AND(V54<N54+F54,N54+F54<=V55),S55,IF(AND(V55<F54,F54<=V56),S56,IF(AND(V56<F54,F54<=V57),S57,IF(AND(V57<F54,F54<=V58),S58,S59)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V59","v":0},null,{"$f":"IF($V$5=2,ROUND(D54/2,0),ROUND(D54,0))","v":0},{"$f":"G51","v":0},{"$f":"F54*G54","v":0},{"$f":"IF(I51>0,V52,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D54/2,0),0)","v":0},{"$f":"M51","v":0},{"$f":"IF($V$5=2,F54+L54*M54,0)","v":0},{"$f":"IF($V$5=2,W52,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A49","v":0},null,{"$f":"IF(S54>0,'Loose Mix'!D49-'Loose Mix'!B49,0)","v":0},{"$f":"U54","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I51=2,H51>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O51>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A50","v":0},null,{"$f":"IF(S55>0,'Loose Mix'!D50-'Loose Mix'!B50,0)","v":0},{"$f":"U55+V54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D55-O51*0.5,0)","v":0},{"$f":"N51","v":0},null,{"$f":"L56*M56+IF(O51>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A51","v":0},null,{"$f":"IF(S56>0,'Loose Mix'!D51-'Loose Mix'!B51,0)","v":0},{"$f":"U56+V55","v":0}]
[null,null,null,null,null,{"$f":"IF(I51>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O51>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A52","v":0},null,{"$f":"IF(S57>0,'Loose Mix'!D52-'Loose Mix'!B52,0)","v":0},{"$f":"U57+V56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A53","v":0},null,{"$f":"IF(S58>0,'Loose Mix'!D53-'Loose Mix'!B53,0)","v":0},{"$f":"U58+V57","v":0}]
["SUBLOT",{"$f":"IF(+'Loose Mix'!F88=\" \",\" \",+'Loose Mix'!F88)","v":""},null,null,null,null,"A","B","EDGE",null,null,null,"A","B","EDGE",null,null,null,{"$f":"'Loose Mix'!A54","v":0},null,{"$f":"IF(S59>0,'Loose Mix'!D54-'Loose Mix'!B54,0)","v":0},{"$f":"U59+V58","v":0}]
["TONS IN SUBLOT",null,null,{"$f":"'Loose Mix'!M88","v":0},null,"RANDOM NO.",null,null,{"$f":"W62","v":0},null,null,"RANDOM NO.",null,null,{"$f":"X62","v":0},null,null,null,null,null,null,{"$f":"ROUND(H63-IF(AND(0<=H63,H63<=V63),V62,IF(AND(V63<H63,H63<=V64),V63,IF(AND(V64<H63,H63<=V65),V64,IF(AND(V65<H63,H63<=V66),V65,IF(AND(V66<H63,H63<=V67),V66,V67))))),0)","v":0},{"$f":"ROUND(N63-IF(AND(0<=N63,N63<=V63),V62,IF(AND(V63<N63,N63<=V64),V63,IF(AND(V64<N63,N63<=V65),V64,IF(AND(V65<N63,N63<=V66),V65,IF(AND(V66<N63,N63<=V67),V66,V67))))),0)","v":0}]
["BEGIN STA./LM",null,null,{"$f":"'Loose Mix'!B56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V60+IF(AND(V62<=H63,H63<=V63),'Loose Mix'!B56,IF(AND(V63<H63,H63<=V64),'Loose Mix'!B57,IF(AND(V64<H63,H63<=V65),'Loose Mix'!B58,IF(AND(V65<H63,H63<=V66),'Loose Mix'!B59,IF(AND(V66<H63,H63<=V67),'Loose Mix'!B60,'Loose Mix'!B61)))))","v":0},{"$f":"W60+IF(AND(V62<=N63,N63<=V63),'Loose Mix'!B56,IF(AND(V63<N63,N63<=V64),'Loose Mix'!B57,IF(AND(V64<N63,N63<=V65),'Loose Mix'!B58,IF(AND(V65<N63,N63<=V66),'Loose Mix'!B59,IF(AND(V66<N63,N63<=V67),'Loose Mix'!B60,'Loose Mix'!B61)))))","v":0}]
["ENDING STA./LM",null,null,{"$f":"INDEX('Loose Mix'!D56:'Loose Mix'!D61,COUNT('Loose Mix'!D56:'Loose Mix'!D61),1)","v":{"$error":"#VALUE!"}},null,"L","A","X=L x A","STA + X",null,null,"L2","A","X=L+L2xA","STA + X",null,null,null,null,null,null,0,{"$f":"IF(AND(V62<=H63,H63<=V63),S63,IF(AND(V63<H63,H63<=V64),S64,IF(AND(V64<H63,H63<=V65),S65,IF(AND(V65<H63,H63<=V66),S66,IF(AND(V66<H63,H63<=V67),S67,S68)))))","v":0},{"$f":"IF(AND(V62<=N63+F63,N63+F63<=V63),S63,IF(AND(V63<N63+F63,N63+F63<=V64),S64,IF(AND(V64<F63,F63<=V65),S65,IF(AND(V65<F63,F63<=V66),S66,IF(AND(V66<F63,F63<=V67),S67,S68)))))","v":0}]
["LENGTH \"L\"",null,null,{"$f":"V68","v":0},null,{"$f":"IF($V$5=2,ROUND(D63/2,0),ROUND(D63,0))","v":0},{"$f":"G60","v":0},{"$f":"F63*G63","v":0},{"$f":"IF(I60>0,V61,\"\")","v":""},null,null,{"$f":"IF($V$5=2,ROUND(D63/2,0),0)","v":0},{"$f":"M60","v":0},{"$f":"IF($V$5=2,F63+L63*M63,0)","v":0},{"$f":"IF($V$5=2,W61,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A56","v":0},null,{"$f":"IF(S63>0,'Loose Mix'!D56-'Loose Mix'!B56,0)","v":0},{"$f":"U63","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(I60=2,H60>=0.5),\"OPPOSITE SIDE\",\"\")","v":""},null,null,"W2","B",{"$f":"\"OFFSET=\"&TEXT(IF(O60>0,0.5,0),\"0.0\")&\"+W2XB\"","v":"OFFSET=0.0+W2XB"},null,null,null,null,{"$f":"'Loose Mix'!A57","v":0},null,{"$f":"IF(S64>0,'Loose Mix'!D57-'Loose Mix'!B57,0)","v":0},{"$f":"U64+V63","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($V$5=2,D64-O60*0.5,0)","v":0},{"$f":"N60","v":0},null,{"$f":"L65*M65+IF(O60>0,0.5,0)","v":0},null,null,null,{"$f":"'Loose Mix'!A58","v":0},null,{"$f":"IF(S65>0,'Loose Mix'!D58-'Loose Mix'!B58,0)","v":0},{"$f":"U65+V64","v":0}]
[null,null,null,null,null,{"$f":"IF(I60>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(O60>0,\"Measure from unconfined edge.\",\"\")","v":""},null,null,null,null,null,null,{"$f":"'Loose Mix'!A59","v":0},null,{"$f":"IF(S66>0,'Loose Mix'!D59-'Loose Mix'!B59,0)","v":0},{"$f":"U66+V65","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A60","v":0},null,{"$f":"IF(S67>0,'Loose Mix'!D60-'Loose Mix'!B60,0)","v":0},{"$f":"U67+V66","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Loose Mix'!A61","v":0},null,{"$f":"IF(S68>0,'Loose Mix'!D61-'Loose Mix'!B61,0)","v":0},{"$f":"U68+V67","v":0}]

{"sheet":"Properties","index":6,"n_rows":144,"n_cols":19,"rows_kept":144,"cut":false,"hidden":false,"merged":[]}
["SUPERPAVE MIXTURE PROPERTIES"]
[]
["JOB",{"$f":"'Loose Mix'!F3","v":0},null,"ROUTE",{"$f":"'Loose Mix'!I3","v":0},"MIX NO.",{"$f":"'Loose Mix'!K3","v":{"$error":"#VALUE!"}},null,"LOT NO.",{"$f":"'Loose Mix'!N3","v":0}]
[]
["SUBLOT",null,null,null,null,{"$f":"IF(+'Loose Mix'!F16=\" \",\" \",+'Loose Mix'!F16)","v":"A"},{"$f":"IF('Loose Mix'!F28=\" \",\" \",+'Loose Mix'!F28)","v":"B"},{"$f":"IF('Loose Mix'!F40=\" \",\" \",+'Loose Mix'!F40)","v":"C"},{"$f":"IF('Loose Mix'!F52=\" \",\" \",+'Loose Mix'!F52)","v":"D"},{"$f":"IF('Loose Mix'!F64=\" \",\" \",+'Loose Mix'!F64)","v":""},{"$f":"IF('Loose Mix'!F76=\" \",\" \",+'Loose Mix'!F76)","v":""},{"$f":"IF('Loose Mix'!F88=\" \",\" \",+'Loose Mix'!F88)","v":""}]
["DATE"]
["AASHTO T 209",null,null,null,null,"A2 required when T85 absorption >2.0% on any aggregate fraction."]
["TECHNICIAN"]
["A = Wt. of sample:"]
["A2=Wt. of sample (dry-back):"]
["D = Wt. of flask filled with water:"]
["X = A + D (A2 used in lieu of A for dry-back)",null,null,null,null,{"$f":"IF(F10=\"\",F9,F10)+F11","v":0},{"$f":"IF(G10=\"\",G9,G10)+G11","v":0},0,0,0,0,0]
["E = Wt. of flask filled with water and sample:"]
["Y = X - E",null,null,null,null,{"$f":"F12-F13","v":0},0,0,0,0,0,0]
["Gmm = MAX. SPECIFIC GRAVITY = A / Y",null,null,null,null,{"$f":"IF(ISERR(F9/F14),0,ROUND(F9/F14,3))","v":0},{"$f":"IF(G5=\" \",\" \",IF(G9=\" \",+F15,ROUND(G9/G14,3)))","v":0},0,0,0,0,0]
[]
["AASHTO T 166"]
["TECHNICIAN"]
["MOLDING TEMPERATURE"]
["A = Weight of sample in air:"]
["B = Weight of sample in water:"]
["C = Weight of surface dry sample:"]
["Gmb = BULK SP. G. = A / (C-B)",null,null,null,null,{"$f":"IF(ISERR(F20/(F22-F21)),0,ROUND(F20/(F22-F21),3))","v":0},0,0,0,0,0,0]
["A = Weight of sample in air:"]
["B = Weight of sample in water:"]
["C = Weight of surface dry sample:"]
["Gmb = BULK SP. G. = A / (C-B)",null,null,null,null,{"$f":"IF(ISERR(F24/(F26-F25)),0,ROUND(F24/(F26-F25),3))","v":0},0,0,0,0,0,0]
["AVG. Gmb",null,null,null,null,{"$f":"IF(F27=0,F23,ROUND(AVERAGE(F23,F27),3))","v":0},{"$f":"IF(G27=0,G23,ROUND(AVERAGE(G23,G27),3))","v":0},0,0,0,0,0]
[]
[]
["TECHNICIAN"]
["MoDOT TM54  (NUCLEAR)"]
["SAMPLE WEIGHT",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41,\">0\")","v":0},{"$f":"F41","v":""},{"$f":"IFERROR(VLOOKUP(1,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["BACKGROUND",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41:$G$41,\">0\")","v":0},{"$f":"G41","v":""},{"$f":"IFERROR(VLOOKUP(2,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["COUNTS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41:$H$41,\">0\")","v":0},{"$f":"H41","v":""},{"$f":"IFERROR(VLOOKUP(3,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["GAUGE % AC",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41:$I$41,\">0\")","v":0},{"$f":"I41","v":""},{"$f":"IFERROR(VLOOKUP(4,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["AASHTO T 308   (IGNITION)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41:$J$41,\">0\")","v":0},{"$f":"J41","v":""},{"$f":"IFERROR(VLOOKUP(5,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["GAUGE %AC",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41:$K$41,\">0\")","v":0},{"$f":"K41","v":""},{"$f":"IFERROR(VLOOKUP(6,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["NUCLEAR OR IGNITION",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$41:$L$41,\">0\")","v":0},{"$f":"L41","v":""},{"$f":"IFERROR(VLOOKUP(7,$O$33:$P$39,2,FALSE),\"\")","v":""}]
["% MOISTURE"]
["% AC BY IGNITION OR NUCLEAR",null,null,null,null,{"$f":"IF(ISBLANK(F40),\"\",IF(F36=0,ROUND(F38-F40,1),ROUND(F36-F40,1)))","v":""},{"$f":"IF(ISBLANK(G40),\"\",IF(G36=0,ROUND(G38-G40,1),ROUND(G36-G40,1)))","v":""},"","","","",""]
[]
["AASHTO R 35"]
["A = Gmm (FIELD)",null,null,null,null,{"$f":"F15","v":0},0,0,0,0,0,0]
["B = Gmb (FIELD) (Avg.)",null,null,null,null,{"$f":"F28","v":0},0,0,0,0,0,0]
["C = Gsb (Job Mix)",null,null,null,null,null,{"$f":"$F$46","v":0},0,0,0,0,0]
["D = Ps = Percent Agg. in mix",null,null,null,null,{"$f":"100-F41","v":100},100,100,100,100,100,100]
["VMA = 100 - (B X D / C)",null,null,null,null,{"$f":"IF(ISERR(F47/F46),0,ROUND(100-(F45*F47/F46),1))","v":0},0,0,0,0,0,0]
["Va = 100 X ((A - B) / A)",null,null,null,null,{"$f":"IF(ISERR(F45/F44),0,ROUND(100*(F44-F45)/F44,1))","v":0},0,0,0,0,0,0]
["VFA = (VMA-Va) / VMA",null,null,null,null,{"$f":"IF(ISERR(F49/F48),0,ROUND(100*(F48-F49)/F48,1))","v":0},0,0,0,0,0,0,null,null,{"$f":"COUNTIF($F$59,\">0\")","v":0},{"$f":"F59","v":0},{"$f":"IFERROR(VLOOKUP(1,$O$50:$P$56,2,FALSE),\"\")","v":""},null,{"$f":"IF(Q111<>\"\",Q111,IF(Q79<>\"\",Q79,IF(Q50<>\"\",Q50,\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$59:$G$59,\">0\")","v":0},{"$f":"G59","v":0},{"$f":"IFERROR(VLOOKUP(2,$O$50:$P$56,2,FALSE),\"\")","v":""},null,{"$f":"IF(Q112<>\"\",Q112,IF(Q80<>\"\",Q80,IF(Q51<>\"\",Q51,\"\")))","v":""}]
["AASHTO T 166",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$59:$H$59,\">0\")","v":0},{"$f":"H59","v":0},{"$f":"IFERROR(VLOOKUP(3,$O$50:$P$56,2,FALSE),\"\")","v":""},null,{"$f":"IF(Q113<>\"\",Q113,IF(Q81<>\"\",Q81,IF(Q52<>\"\",Q52,\"\")))","v":""}]
["TECHNICIAN",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$59:$I$59,\">0\")","v":0},{"$f":"I59","v":0},{"$f":"IFERROR(VLOOKUP(4,$O$50:$P$56,2,FALSE),\"\")","v":""}]
["A = Mass of sample in air:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$59:$J$59,\">0\")","v":0},{"$f":"J59","v":0},{"$f":"IFERROR(VLOOKUP(5,$O$50:$P$56,2,FALSE),\"\")","v":""}]
["B = Mass in water:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$59:$K$59,\">0\")","v":0},{"$f":"K59","v":0},{"$f":"IFERROR(VLOOKUP(6,$O$50:$P$56,2,FALSE),\"\")","v":""}]
["C = Mass of surface dry sample:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$59:$L$59,\">0\")","v":0},{"$f":"L59","v":0},{"$f":"IFERROR(VLOOKUP(7,$O$50:$P$56,2,FALSE),\"\")","v":""}]
["Gmc = CORE SPECIFIC GRAVITY = A / (C - B)",null,null,null,null,{"$f":"IF(ISERR(F54/(F56-F55)),0,ROUND(F54/(F56-F55),3))","v":0},0,0,0,0,0,0]
["Gmm = MAX. SPECIFIC GRAVITY (T209)",null,null,null,null,{"$f":"F$15","v":0},{"$f":"G$15","v":0},0,0,0,0,0]
["% COMPACTION OF CORE = 100 x (Gmc / Gmm) ",null,null,null,null,{"$f":"IF(ISERR(F57/F58),0,TRUNC(100*F57/F58,2))","v":0},{"$f":"IF(ISERR(G57/G58),0,TRUNC(100*G57/G58,2))","v":0},0,0,0,0,0]
["WATER ABS. = 100 x ((C-A)/(C-B))",null,null,null,null,{"$f":"IF(ISERR(F56-F54/F56-F55),0,TRUNC(100*(F56-F54)/(F56-F55),2))","v":0},{"$f":"IF(ISERR(G56-G54/G56-G55),0,TRUNC(100*(G56-G54)/(G56-G55),2))","v":0},0,0,0,0,0]
["THICKNESS"]
["SUBLOT",null,null,null,null,{"$f":"IF(Density!$B$5=\" \",\" \",+Density!$B$5)","v":"A"},{"$f":"IF(Density!$B$14=\" \",\" \",+Density!$B$14)","v":"B"},{"$f":"IF(Density!$B$23=\" \",\" \",+Density!$B$23)","v":"C"},{"$f":"IF(Density!$B$32=\" \",\" \",+Density!$B$32)","v":"D"},{"$f":"IF(Density!$B$41=\" \",\" \",+Density!$B$41)","v":""},{"$f":"IF(Density!$B$50=\" \",\" \",+Density!$B$50)","v":""},{"$f":"IF(Density!$B$59=\" \",\" \",+Density!$B$59)","v":""}]
[]
["FOR 2ND CORE SUBLOT WHEN DENOTED IN QC PLAN"]
["TECHNICIAN",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$71,\">0\")","v":0},{"$f":"F71","v":0},{"$f":"IFERROR(VLOOKUP(1,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["A = Weight of sample in air:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$71:$G$71,\">0\")","v":0},{"$f":"G71","v":0},{"$f":"IFERROR(VLOOKUP(2,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["B = Weight in water:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$71:$H$71,\">0\")","v":0},{"$f":"H71","v":0},{"$f":"IFERROR(VLOOKUP(3,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["C = Weight of surface dry sample:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$71:$I$71,\">0\")","v":0},{"$f":"I71","v":0},{"$f":"IFERROR(VLOOKUP(4,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["Gmc = CORE SPECIFIC GRAVITY = A / (C - B)",null,null,null,null,{"$f":"IF(ISERR(F66/(F68-F67)),0,ROUND(F66/(F68-F67),3))","v":0},0,0,0,0,0,0,null,null,{"$f":"COUNTIF($F$71:$J$71,\">0\")","v":0},{"$f":"J71","v":0},{"$f":"IFERROR(VLOOKUP(5,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["Gmm = MAX. SPECIFIC GRAVITY (T209)",null,null,null,null,{"$f":"F$15","v":0},{"$f":"G$15","v":0},0,0,0,0,0,null,null,{"$f":"COUNTIF($F$71:$K$71,\">0\")","v":0},{"$f":"K71","v":0},{"$f":"IFERROR(VLOOKUP(6,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["% COMPACTION OF CORE = 100 x (Gmc / Gmm) ",null,null,null,null,{"$f":"IF(ISERR(F69/F70),0,TRUNC(100*F69/F70,2))","v":0},0,0,0,0,0,0,null,null,{"$f":"COUNTIF($F$71:$L$71,\">0\")","v":0},{"$f":"L71","v":0},{"$f":"IFERROR(VLOOKUP(7,$O$65:$P$71,2,FALSE),\"\")","v":""}]
["WATER ABS. = 100 x ((C-A)/(C-B))",null,null,null,null,{"$f":"IF(ISERR(F68-F66/F68-F67),0,TRUNC(100*(F68-F66)/(F68-F67),2))","v":0},{"$f":"IF(ISERR(G68-G66/G68-G67),0,TRUNC(100*(G68-G66)/(G68-G67),2))","v":0},0,0,0,0,0]
["THICKNESS"]
["SUBLOT",null,null,null,null,{"$f":"IF(Density!$M$6=\" \",\" \",+Density!$B$5)","v":" "},{"$f":"IF(Density!$M$15=\" \",\" \",+Density!$B$14)","v":" "},{"$f":"IF(Density!$M$24=\" \",\" \",+Density!$B$23)","v":" "},{"$f":"IF(Density!$M$33=\" \",\" \",+Density!$B$32)","v":" "},{"$f":"IF(Density!$M$42=\" \",\" \",+Density!$B$41)","v":" "},{"$f":"IF(Density!$M$51=\" \",\" \",+Density!$B$50)","v":" "},{"$f":"IF(Density!$M$60=\" \",\" \",+Density!$B$59)","v":" "}]
[]
["AASHTO T 331"]
["TECHNICIAN"]
["A = Mass of sample in air:"]
["      Bag Mass",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$86,\">0\")","v":0},{"$f":"F86","v":0},{"$f":"IFERROR(VLOOKUP(1,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["B = Mass sealed sample:",null,null,null,null,{"$f":"F78+F79","v":0},{"$f":"G78+G79","v":0},0,0,0,0,0,null,null,{"$f":"COUNTIF($F$86:$G$86,\">0\")","v":0},{"$f":"G86","v":0},{"$f":"IFERROR(VLOOKUP(2,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["C = Mass sample removed from bag:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$86:$H$86,\">0\")","v":0},{"$f":"H86","v":0},{"$f":"IFERROR(VLOOKUP(3,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["E = Mass of sealed sample in water:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$86:$I$86,\">0\")","v":0},{"$f":"I86","v":0},{"$f":"IFERROR(VLOOKUP(4,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["F = Bag specific gravity:",null,null,"(0.932 green InstroTek bag)",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$86:$J$86,\">0\")","v":0},{"$f":"J86","v":0},{"$f":"IFERROR(VLOOKUP(5,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["Gmc = A / ((C + (B - A)) - E - ((B - A) / F))",null,null,null,null,{"$f":"IF(ISERR(F78/(F82-F81)),0,ROUND(F78/((F81+F80-F78)-F82-((F80-F78)/F83)),3))","v":0},{"$f":"IF(ISERR(G78/(G82-G81)),0,ROUND(G78/((G81+G80-G78)-G82-((G80-G78)/G83)),3))","v":0},0,0,0,0,0,null,null,{"$f":"COUNTIF($F$86:$K$86,\">0\")","v":0},{"$f":"K86","v":0},{"$f":"IFERROR(VLOOKUP(6,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["Gmm = MAX. SPECIFIC GRAVITY (T209)",null,null,null,null,{"$f":"F$15","v":0},{"$f":"G$15","v":0},0,0,0,0,0,null,null,{"$f":"COUNTIF($F$86:$L$86,\">0\")","v":0},{"$f":"L86","v":0},{"$f":"IFERROR(VLOOKUP(7,$O$79:$P$85,2,FALSE),\"\")","v":""}]
["% COMPACTION OF CORE = 100 x (Gmc / Gmm) ",null,null,null,null,{"$f":"IF(ISERR(F84/F85),0,ROUND(TRUNC(100*F84/F85,2),1))","v":0},0,0,0,0,0,0]
["CHECK (%)",null,null,null,null,{"$f":"IF(F81=\"\",\"\",ROUND((F81-F78)/F78,4)*100)","v":""},{"$f":"IF(G81=\"\",\"\",ROUND((G81-G78)/G78,4)*100)","v":""},"","","","",""]
["THICKNESS"]
["SUBLOT",null,null,null,null,{"$f":"IF(Density!$B$5=\" \",\" \",+Density!$B$5)","v":"A"},{"$f":"IF(Density!$B$14=\" \",\" \",+Density!$B$14)","v":"B"},{"$f":"IF(Density!$B$23=\" \",\" \",+Density!$B$23)","v":"C"},{"$f":"IF(Density!$B$32=\" \",\" \",+Density!$B$32)","v":"D"},{"$f":"IF(Density!$B$41=\" \",\" \",+Density!$B$41)","v":""},{"$f":"IF(Density!$B$50=\" \",\" \",+Density!$B$50)","v":""},{"$f":"IF(Density!$B$59=\" \",\" \",+Density!$B$59)","v":""}]
[]
["FOR 2ND CORE SUBLOT WHEN DENOTED IN QC PLAN"]
["TECHNICIAN"]
["A = Mass of sample in air:"]
["      Bag Mass",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$101,\">0\")","v":0},{"$f":"F101","v":0},{"$f":"IFERROR(VLOOKUP(1,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["B = Mass sealed sample:",null,null,null,null,{"$f":"F93+F94","v":0},0,0,0,0,0,0,null,null,{"$f":"COUNTIF($F$101:$G$101,\">0\")","v":0},{"$f":"G101","v":0},{"$f":"IFERROR(VLOOKUP(2,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["C = Mass sample removed from bag:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$101:$H$101,\">0\")","v":0},{"$f":"H101","v":0},{"$f":"IFERROR(VLOOKUP(3,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["E = Mass of sealed sample in water:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$101:$I$101,\">0\")","v":0},{"$f":"I101","v":0},{"$f":"IFERROR(VLOOKUP(4,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["F = Bag specific gravity:",null,null,"(0.932 green InstroTek bag)",null,0.93200000000000005,{"$f":"F98","v":0.93200000000000005},{"$f":"F98","v":0.93200000000000005},{"$f":"F98","v":0.93200000000000005},{"$f":"F98","v":0.93200000000000005},{"$f":"F98","v":0.93200000000000005},{"$f":"F98","v":0.93200000000000005},null,null,{"$f":"COUNTIF($F$101:$J$101,\">0\")","v":0},{"$f":"J101","v":0},{"$f":"IFERROR(VLOOKUP(5,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["Gmc = A / ((C + (B - A)) - E - ((B - A) / F))",null,null,null,null,{"$f":"IF(ISERR(F93/(F97-F96)),0,ROUND(F93/((F96+F95-F93)-F97-((F95-F93)/F98)),3))","v":0},0,0,0,0,0,0,null,null,{"$f":"COUNTIF($F$101:$K$101,\">0\")","v":0},{"$f":"K101","v":0},{"$f":"IFERROR(VLOOKUP(6,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["Gmm = MAX. SPECIFIC GRAVITY (T209)",null,null,null,null,{"$f":"F$15","v":0},{"$f":"G$15","v":0},0,0,0,0,0,null,null,{"$f":"COUNTIF($F$101:$L$101,\">0\")","v":0},{"$f":"L101","v":0},{"$f":"IFERROR(VLOOKUP(7,$O$94:$P$100,2,FALSE),\"\")","v":""}]
["% COMPACTION OF CORE = 100 x (Gmc / Gmm) ",null,null,null,null,{"$f":"IF(ISERR(F99/F100),0,ROUND(TRUNC(100*F99/F100,2),1))","v":0},0,0,0,0,0,0]
["CHECK (%)",null,null,null,null,{"$f":"IF(F96=\"\",\"\",ROUND((F96-F93)/F93,4)*100)","v":""},{"$f":"IF(G96=\"\",\"\",ROUND((G96-G93)/G93,4)*100)","v":""},"","","","",""]
["THICKNESS"]
["SUBLOT",null,null,null,null,{"$f":"IF(Density!$M$6=\" \",\" \",+Density!$B$5)","v":" "},{"$f":"IF(Density!$M$15=\" \",\" \",+Density!$B$14)","v":" "},{"$f":"IF(Density!$M$24=\" \",\" \",+Density!$B$23)","v":" "},{"$f":"IF(Density!$M$33=\" \",\" \",+Density!$B$32)","v":" "},{"$f":"IF(Density!$M$42=\" \",\" \",+Density!$B$41)","v":" "},{"$f":"IF(Density!$M$51=\" \",\" \",+Density!$B$50)","v":" "},{"$f":"IF(Density!$M$60=\" \",\" \",+Density!$B$59)","v":" "}]
[]
["MoDOT TM-83"]
[null,null,null,null,null,"Tier 1","Tier 2","Tier 3","Tier 4","Test"]
["Area  (cm2)",null,null,null,null,2.85,15.52,38.32,167.53,167.53]
["TECHNICIAN"]
["THICKNESS"]
["TIER",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$124,\">0\")","v":0},{"$f":"F124","v":""},{"$f":"IFERROR(VLOOKUP(1,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["STANDPIPE AREA",null,null,"TEST 1",null,{"$f":"IF(F111=1,$F$108,IF(F111=2,$G$108,IF(F111=3,$H$108,IF(F111=4,$I$108,\"\"))))","v":""},{"$f":"IF(G111=1,$F$108,IF(G111=2,$G$108,IF(G111=3,$H$108,IF(G111=4,$I$108,\"\"))))","v":""},"","","","","",null,null,{"$f":"COUNTIF($F$124:$G$124,\">0\")","v":0},{"$f":"G124","v":""},{"$f":"IFERROR(VLOOKUP(2,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["H1 (cm)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$124:$H$124,\">0\")","v":0},{"$f":"H124","v":""},{"$f":"IFERROR(VLOOKUP(3,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["H2 (cm)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$124:$I$124,\">0\")","v":0},{"$f":"I124","v":""},{"$f":"IFERROR(VLOOKUP(4,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["TIME (min) = mm.ssss, e.g. 1.0039 = 1 min. 0.39 sec.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$124:$J$124,\">0\")","v":0},{"$f":"J124","v":""},{"$f":"IFERROR(VLOOKUP(5,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["TEST 1 (k X 10-5 cm/sec)",null,null,null,null,{"$f":"IF(F115=\"\",\"\",ROUND(F112*F110*2.54/$J$108/(INT(F115)*60+(F115-INT(F115))*100)*LN(F113/F114)*100000,0))","v":""},{"$f":"IF(G115=\"\",\"\",ROUND(G112*G110*2.54/$J$108/(INT(G115)*60+(G115-INT(G115))*100)*LN(G113/G114)*100000,0))","v":""},"","","","","",null,null,{"$f":"COUNTIF($F$124:$K$124,\">0\")","v":0},{"$f":"K124","v":""},{"$f":"IFERROR(VLOOKUP(6,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["TIER",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$124:$L$124,\">0\")","v":0},{"$f":"L124","v":""},{"$f":"IFERROR(VLOOKUP(7,$O$111:$P$117,2,FALSE),\"\")","v":""}]
["STANDPIPE AREA",null,null,"TEST 2",null,{"$f":"IF(F117=1,$F$108,IF(F117=2,$G$108,IF(F117=3,$H$108,IF(F117=4,$I$108,\"\"))))","v":""},"","","","","",""]
["H1 (cm)"]
["H2 (cm)"]
["TIME (min) = mm.ssss, e.g. 1.0039 = 1 min. 0.39 sec."]
["TEST 2 (k X 10-5 cm/sec)",null,null,null,null,{"$f":"IF(F121=\"\",\"\",ROUND(F118*F110*2.54/$J$108/(INT(F121)*60+(F121-INT(F121))*100)*LN(F119/F120)*100000,0))","v":""},{"$f":"IF(G121=\"\",\"\",ROUND(G118*G110*2.54/$J$108/(INT(G121)*60+(G121-INT(G121))*100)*LN(G119/G120)*100000,0))","v":""},"","","","",""]
["AVERAGE",null,null,null,null,{"$f":"IF(F116=\"\",\"\",AVERAGE(F116,F122))","v":""},{"$f":"IF(G116=\"\",\"\",AVERAGE(G116,G122))","v":""},"","","","",""]
["PERMEABILITY (ft/day)",null,null,null,null,{"$f":"IF(F123=\"\",\"\",ROUND(2823*F123*0.00001,1))","v":""},{"$f":"IF(G123=\"\",\"\",ROUND(2823*G123*0.00001,1))","v":""},"","","","",""]
["SUBLOT",null,null,null,null,{"$f":"IF(Density!$B$5=\" \",\" \",+Density!$B$5)","v":"A"},{"$f":"IF(Density!$B$14=\" \",\" \",+Density!$B$14)","v":"B"},{"$f":"IF(Density!$B$23=\" \",\" \",+Density!$B$23)","v":"C"},{"$f":"IF(Density!$B$32=\" \",\" \",+Density!$B$32)","v":"D"},{"$f":"IF(Density!$B$41=\" \",\" \",+Density!$B$41)","v":""},{"$f":"IF(Density!$B$50=\" \",\" \",+Density!$B$50)","v":""},{"$f":"IF(Density!$B$59=\" \",\" \",+Density!$B$59)","v":""}]
[]
["FOR 2ND HALF SUBLOT"]
["TECHNICIAN"]
["THICKNESS"]
["TIER",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$143,\">0\")","v":0},{"$f":"F143","v":""},{"$f":"IFERROR(VLOOKUP(1,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["STANDPIPE AREA",null,null,"TEST 1",null,{"$f":"IF(F130=1,$F$108,IF(F130=2,$G$108,IF(F130=3,$H$108,IF(F130=4,$I$108,\"\"))))","v":""},"","","","","","",null,null,{"$f":"COUNTIF($F$143:$G$143,\">0\")","v":0},{"$f":"G143","v":""},{"$f":"IFERROR(VLOOKUP(2,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["H1 (cm)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$143:$H$143,\">0\")","v":0},{"$f":"H143","v":""},{"$f":"IFERROR(VLOOKUP(3,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["H2 (cm)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$143:$I$143,\">0\")","v":0},{"$f":"I143","v":""},{"$f":"IFERROR(VLOOKUP(4,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["TIME (min) = mm.ssss, e.g. 1.0039 = 1 min. 0.39 sec.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$143:$J$143,\">0\")","v":0},{"$f":"J143","v":""},{"$f":"IFERROR(VLOOKUP(5,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["TEST 1 (k X 10-5 cm/sec)",null,null,null,null,{"$f":"IF(F134=\"\",\"\",ROUND(F131*F129*2.54/$J$108/(INT(F134)*60+(F134-INT(F134))*100)*LN(F132/F133)*100000,0))","v":""},"","","","","","",null,null,{"$f":"COUNTIF($F$143:$K$143,\">0\")","v":0},{"$f":"K143","v":""},{"$f":"IFERROR(VLOOKUP(6,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["TIER",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($F$143:$L$143,\">0\")","v":0},{"$f":"L143","v":""},{"$f":"IFERROR(VLOOKUP(7,$O$130:$P$136,2,FALSE),\"\")","v":""}]
["STANDPIPE AREA",null,null,"TEST 2",null,{"$f":"IF(F136=1,$F$108,IF(F136=2,$G$108,IF(F136=3,$H$108,IF(F136=4,$I$108,\"\"))))","v":""},"","","","","",""]
["H1 (cm)"]
["H2 (cm)"]
["TIME (min) = mm.ssss, e.g. 1.0039 = 1 min. 0.39 sec."]
["TEST 2 (k X 10-5 cm/sec)",null,null,null,null,{"$f":"IF(F140=\"\",\"\",ROUND(F137*F129*2.54/$J$108/(INT(F140)*60+(F140-INT(F140))*100)*LN(F138/F139)*100000,0))","v":""},"","","","","",""]
["AVERAGE",null,null,null,null,{"$f":"IF(F135=\"\",\"\",AVERAGE(F135,F141))","v":""},"","","","","",""]
["PERMEABILITY (ft/day)",null,null,null,null,{"$f":"IF(F142=\"\",\"\",ROUND(2823*F142*0.00001,1))","v":""},"","","","","",""]
["SUBLOT",null,null,null,null,{"$f":"IF(Density!$M$6=\" \",\" \",+Density!$B$5)","v":" "},{"$f":"IF(Density!$M$15=\" \",\" \",+Density!$B$14)","v":" "},{"$f":"IF(Density!$M$24=\" \",\" \",+Density!$B$23)","v":" "},{"$f":"IF(Density!$M$33=\" \",\" \",+Density!$B$32)","v":" "},{"$f":"IF(Density!$M$42=\" \",\" \",+Density!$B$41)","v":" "},{"$f":"IF(Density!$M$51=\" \",\" \",+Density!$B$50)","v":" "},{"$f":"IF(Density!$M$60=\" \",\" \",+Density!$B$59)","v":" "}]

{"sheet":"Help","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":8,"n_rows":152,"n_cols":10,"rows_kept":152,"cut":false,"hidden":false,"merged":[[133,8,133,9],[129,8,129,9],[130,8,130,9],[131,8,131,9],[132,8,132,9],[123,8,123,9],[124,8,124,9],[125,8,125,9],[127,8,127,9],[128,8,128,9],[94,8,94,9],[95,8,95,9],[96,8,96,9],[97,8,97,9],[99,8,99,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[57,8,57,9],[56,8,56,9],[55,8,55,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[0,0,0,3],[21,8,21,9],[22,8,22,9],[23,8,23,9],[25,8,25,9],[90,8,90,9],[60,8,60,9],[61,8,61,9],[91,8,91,9],[93,8,93,9],[59,8,59,9],[62,8,62,9],[63,8,63,9],[65,8,65,9],[89,8,89,9]]}
["INSPECTOR WORKSHEET SUMMARY"]
["SMPL_ID",{"$f":"UPPER(Menu!B7)","v":""},"Updated","No"]
["SMPLD_BY",{"$f":"LOWER(Menu!H7)","v":""}]
["MATL_CD",{"$f":"IF(OR(Menu!B19=\"Material Short Name\",ISERR(Menu!B19)),VLOOKUP(Menu!B20,'Pick Lists'!J3:K60,2,FALSE),VLOOKUP(Menu!B19,'Pick Lists'!H3:I65,2,FALSE))","v":{"$error":"#N/A"}}]
["PRODR_SUPP_CD",{"$f":"VLOOKUP(Menu!B18,Producer_Supplier,4,FALSE)","v":{"$error":"#N/A"}}]
["PLANT_ID",{"$f":"VLOOKUP(Menu!B18,Producer_Supplier,3,FALSE)","v":{"$error":"#N/A"}}]
["REPR_QTY",{"$f":"SUM(B17:J17)","v":0}]
["SMPL_DT",{"$f":"Menu!B8","v":0}]
["SMPL_MIX-_ID",{"$f":"UPPER(Menu!B9)","v":""}]
["STD_RMRKS_IND",{"$f":"IF(Menu!$I$8=TRUE,\"Y\",\" \")","v":" "},"(Warm Mix)"]
[]
[]
["SMPL_T",{"$f":"VLOOKUP(Menu!L7,Sample_Type,2)","v":{"$error":"#N/A"}}]
["CONT_ID",{"$f":"UPPER(Menu!B11)","v":""},null,null,{"$f":"Menu!K11","v":0},null,null,{"$f":"Menu!N11","v":0}]
["PRJ_NBR",{"$f":"UPPER(Menu!B12)","v":""},null,null,{"$f":"UPPER(Menu!K12)","v":""},null,null,{"$f":"UPPER(Menu!N12)","v":""}]
["LN_ITM_NBR",{"$f":"Menu!B15","v":0},{"$f":"Menu!B16","v":0},{"$f":"Menu!B17","v":0},{"$f":"Menu!K15","v":0},{"$f":"Menu!K16","v":0},{"$f":"Menu!K17","v":0},{"$f":"Menu!N15","v":0},{"$f":"Menu!N16","v":0},{"$f":"Menu!N17","v":0}]
["REPR_QTY",{"$f":"Menu!H15","v":0},{"$f":"Menu!H16","v":0},{"$f":"Menu!H17","v":0},{"$f":"Menu!M15","v":0},{"$f":"Menu!M16","v":0},{"$f":"Menu!M17","v":0},{"$f":"Menu!P15","v":0},{"$f":"Menu!P16","v":0},{"$f":"Menu!P17","v":0}]
[]
[]
[]
[]
["TST_METH",{"$f":"IF('Plant Inspection'!B41<>0,\"SAA400AB\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"SAA001CB\",\"SAA001AB\"))","v":"SAA001AB"}]
["SMPL_TST_NBR",{"$f":"'Plant Inspection'!E$5","v":1},null,null,null,null,null,null,{"$f":"IF(AND(I22=\"SAA001AB\",I29<>\"\"),1,IF(AND(I22=\"SAA001CB\",I30<>\"\"),1,\"\"))","v":""}]
["LAB_ID","\"Fld Lab R\"",null,null,null,null,null,null,"\"Fld Lab R\""]
[]
["LOT NO.",{"$f":"Menu!B$10","v":0},null,null,null,null,null,"Deleterious Rock",{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),'Plant Inspection'!K54,'Plant Inspection'!K54))","v":""}]
["GRADATION PASS",{"$f":"UPPER('Plant Inspection'!$H$50)","v":"N"},null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Shale & Mud Balls\",\"Shale\"))","v":"Shale"},{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),'Plant Inspection'!K55,'Plant Inspection'!K55))","v":""}]
[null,"Job Mix",null,"Comb. Grad.",null,"Deviation",null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Clay, Dispersed\",\"OFM\"))","v":"OFM"},{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),'Plant Inspection'!K56,'Plant Inspection'!K57))","v":""}]
["1 1/2\"",{"$f":"'Plant Inspection'!B48","v":0},{"$f":"'Plant Inspection'!C48","v":0},{"$f":"'Plant Inspection'!D48","v":0},{"$f":"'Plant Inspection'!E48","v":0},{"$f":"IF('Plant Inspection'!F48=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F48,3),1))","v":""},null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"OFM\",\"Total Deleterious\"))","v":"Total Deleterious"},{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),'Plant Inspection'!K57,'Plant Inspection'!K58))","v":""}]
["1\"",{"$f":"'Plant Inspection'!B49","v":0},{"$f":"'Plant Inspection'!C49","v":0},{"$f":"'Plant Inspection'!D49","v":0},{"$f":"'Plant Inspection'!E49","v":0},{"$f":"IF('Plant Inspection'!F49=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F49,3),1))","v":""},null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Total Deleterious\",\"\"))","v":""},{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),'Plant Inspection'!K58,\"\"))","v":""}]
["3/4\"",{"$f":"'Plant Inspection'!B50","v":0},{"$f":"'Plant Inspection'!C50","v":0},{"$f":"'Plant Inspection'!D50","v":0},{"$f":"'Plant Inspection'!E50","v":0},{"$f":"IF('Plant Inspection'!F50=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F50,3),1))","v":""}]
["1/2\"",{"$f":"'Plant Inspection'!B51","v":0},{"$f":"'Plant Inspection'!C51","v":0},{"$f":"'Plant Inspection'!D51","v":0},{"$f":"'Plant Inspection'!E51","v":0},{"$f":"IF('Plant Inspection'!F51=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F51,3),1))","v":""},null,"Chert",{"$f":"'Plant Inspection'!$K$60","v":""}]
["3/8\"",{"$f":"'Plant Inspection'!B52","v":0},{"$f":"'Plant Inspection'!C52","v":0},{"$f":"'Plant Inspection'!D52","v":0},{"$f":"'Plant Inspection'!E52","v":0},{"$f":"IF('Plant Inspection'!F52=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F52,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#4",{"$f":"'Plant Inspection'!B53","v":0},{"$f":"'Plant Inspection'!C53","v":0},{"$f":"'Plant Inspection'!D53","v":0},{"$f":"'Plant Inspection'!E53","v":0},{"$f":"IF('Plant Inspection'!F53=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F53,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#8",{"$f":"'Plant Inspection'!B54","v":0},{"$f":"'Plant Inspection'!C54","v":0},{"$f":"'Plant Inspection'!D54","v":0},{"$f":"'Plant Inspection'!E54","v":0},{"$f":"IF('Plant Inspection'!F54=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F54,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#16",{"$f":"'Plant Inspection'!B55","v":0},{"$f":"'Plant Inspection'!C55","v":0},{"$f":"'Plant Inspection'!D55","v":0},{"$f":"'Plant Inspection'!E55","v":0},{"$f":"IF('Plant Inspection'!F55=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F55,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#30",{"$f":"'Plant Inspection'!B56","v":0},{"$f":"'Plant Inspection'!C56","v":0},{"$f":"'Plant Inspection'!D56","v":0},{"$f":"'Plant Inspection'!E56","v":0},{"$f":"IF('Plant Inspection'!F56=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F56,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#50",{"$f":"'Plant Inspection'!B57","v":0},{"$f":"'Plant Inspection'!C57","v":0},{"$f":"'Plant Inspection'!D57","v":0},{"$f":"'Plant Inspection'!E57","v":0},{"$f":"IF('Plant Inspection'!F57=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F57,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#100",{"$f":"'Plant Inspection'!B58","v":0},{"$f":"'Plant Inspection'!C58","v":0},{"$f":"'Plant Inspection'!D58","v":0},{"$f":"'Plant Inspection'!E58","v":0},{"$f":"IF('Plant Inspection'!F58=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F58,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
["#200",{"$f":"'Plant Inspection'!B59","v":0},{"$f":"'Plant Inspection'!C59","v":0},{"$f":"'Plant Inspection'!D59","v":0},{"$f":"'Plant Inspection'!E59","v":0},{"$f":"IF('Plant Inspection'!F59=\"\",\"\",ROUND(TRUNC('Plant Inspection'!F59,3),1))","v":""},null,null,{"$f":"Menu!I$10","v":0}]
[]
["ASPHALT CONTENT",{"$f":"IF('Plant Inspection'!G$74>0,'Plant Inspection'!G$74,IF(Properties!O$33=1,Properties!F$41,IF(Properties!O$34=1,Properties!G$41,IF(Properties!O$35=1,Properties!H$41,IF(Properties!O$36=1,Properties!I$41,IF(Properties!O$37=1,Properties!J$41,IF(Properties!O$38=1,Properties!K$41,IF(Properties!O$39=1,Properties!L$41,\"\"))))))))","v":""}]
[null,{"$f":"IF('Plant Inspection'!G$75>0,'Plant Inspection'!G$75,IF(Properties!O$34=2,Properties!G$41,IF(Properties!O$35=2,Properties!H$41,IF(Properties!O$36=2,Properties!I$41,IF(Properties!O$37=2,Properties!J$41,IF(Properties!O$38=2,Properties!K$41,IF(Properties!O$39=2,Properties!L$41,\"\")))))))","v":""}]
[null,{"$f":"IF('Plant Inspection'!G$76>0,'Plant Inspection'!G$76,IF(Properties!O$35=3,Properties!H$41,IF(Properties!O$36=3,Properties!I$41,IF(Properties!O$37=3,Properties!J$41,IF(Properties!O$38=3,Properties!K$41,IF(Properties!O$39=3,Properties!L$41,\"\"))))))","v":""}]
[]
["DENSITY",{"$f":"IF('Plant Inspection'!T$44>0,'Plant Inspection'!T$44,IF(Properties!S$50>0,Properties!S$50,\"\"))","v":""}]
[null,{"$f":"IF(Properties!S$51>0,Properties!S$51,\"\")","v":""}]
[null,{"$f":"IF(Properties!S$52>0,Properties!S$52,\"\")","v":""}]
[]
["REMARKS",{"$f":"IF('Plant Inspection'!C$85=\"\",\"\",'Plant Inspection'!C$85)","v":""}]
[null,{"$f":"IF('Plant Inspection'!A$86=\"\",\"\",'Plant Inspection'!A$86)","v":""}]
[null,{"$f":"IF('Plant Inspection'!A$87=\"\",\"\",'Plant Inspection'!A$87)","v":""}]
[null,{"$f":"IF('Plant Inspection'!A$88=\"\",\"\",'Plant Inspection'!A$88)","v":""}]
[null,{"$f":"IF('Plant Inspection'!A$89=\"\",\"\",'Plant Inspection'!A$89)","v":""}]
[]
["TST_METH","SAA400AB",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"SAA001CB\",\"SAA001AB\"))","v":"SAA001AB"}]
["SMPL_TST_NBR",null,null,null,null,null,null,null,{"$f":"IF(AND(I56=\"SAA001AB\",I63<>\"\"),2,IF(AND(I56=\"SAA001CB\",I64<>\"\"),2,\"\"))","v":""}]
["LAB_ID","\"Fld Lab R\"",null,null,null,null,null,null,"\"Fld Lab R\""]
[]
["LOT NO.",null,null,null,null,null,null,"Deleterious Rock"]
["GRADATION PASS",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Shale & Mud Balls\",\"Shale\"))","v":"Shale"}]
[null,"Job Mix",null,"Comb. Grad.",null,"Deviation",null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Clay, Dispersed\",\"OFM\"))","v":"OFM"}]
["1 1/2\"",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"OFM\",\"Total Deleterious\"))","v":"Total Deleterious"}]
["1\"",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Total Deleterious\",\"\"))","v":""}]
["3/4\""]
["1/2\"",null,null,null,null,null,null,"Chert"]
["3/8\""]
["#4"]
["#8"]
["#16"]
["#30"]
["#50"]
["#100"]
["#200"]
[]
["ASPHALT CONTENT"]
[]
[]
[]
["DENSITY"]
[]
[]
[]
["REMARKS"]
[]
[]
[]
[]
[]
["TST_METH","SAA400AB",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"SAA001CB\",\"SAA001AB\"))","v":"SAA001AB"}]
["SMPL_TST_NBR",null,null,null,null,null,null,null,{"$f":"IF(AND(I90=\"SAA001AB\",I97<>\"\"),3,IF(AND(I90=\"SAA001CB\",I98<>\"\"),3,\"\"))","v":""}]
["LAB_ID","\"Fld Lab R\"",null,null,null,null,null,null,"\"Fld Lab R\""]
[]
["LOT NO.",null,null,null,null,null,null,"Deleterious Rock"]
["GRADATION PASS",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Shale & Mud Balls\",\"Shale\"))","v":"Shale"}]
[null,"Job Mix",null,"Comb. Grad.",null,"Deviation",null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Clay, Dispersed\",\"OFM\"))","v":"OFM"}]
["1 1/2\"",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"OFM\",\"Total Deleterious\"))","v":"Total Deleterious"}]
["1\"",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Total Deleterious\",\"\"))","v":""}]
["3/4\""]
["1/2\"",null,null,null,null,null,null,"Chert"]
["3/8\""]
["#4"]
["#8"]
["#16"]
["#30"]
["#50"]
["#100"]
["#200"]
[]
["ASPHALT CONTENT"]
[]
[]
[]
["DENSITY"]
[]
[]
[]
["REMARKS"]
[]
[]
[]
[]
[]
["TST_METH","SAA400AB",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"SAA001CB\",\"SAA001AB\"))","v":"SAA001AB"}]
["SMPL_TST_NBR",null,null,null,null,null,null,null,{"$f":"IF(AND(I124=\"SAA001AB\",I131<>\"\"),4,IF(AND(I124=\"SAA001CB\",I132<>\"\"),4,\"\"))","v":""}]
["LAB_ID","\"Fld Lab R\"",null,null,null,null,null,null,"\"Fld Lab R\""]
[]
["LOT NO.",null,null,null,null,null,null,"Deleterious Rock"]
["GRADATION PASS",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Shale & Mud Balls\",\"Shale\"))","v":"Shale"}]
[null,"Job Mix",null,"Comb. Grad.",null,"Deviation",null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Clay, Dispersed\",\"OFM\"))","v":"OFM"}]
["1 1/2\"",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"OFM\",\"Total Deleterious\"))","v":"Total Deleterious"}]
["1\"",null,null,null,null,null,null,{"$f":"IF(ISERR(LEFT(Menu!$B$9)),\"\",IF(OR(LEFT(Menu!$B$9,2)=\"SL\",LEFT(Menu!$B$9,2)=\"BP\",LEFT(Menu!$B$9,2)=\"BB\"),\"Total Deleterious\",\"\"))","v":""}]
["3/4\""]
["1/2\"",null,null,null,null,null,null,"Chert"]
["3/8\""]
["#4"]
["#8"]
["#16"]
["#30"]
["#50"]
["#100"]
["#200"]
[]
["ASPHALT CONTENT"]
[]
[]
[]
["DENSITY"]
[]
[]
[]
["REMARKS"]