{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Notes","Random","RT","CT","Accept"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Note","Details"]
[1,"A minimum of 4 test sets by the Residency is needed for initialization accepatance."]
[2,"All tests for the initialization comparisons must be split and tested by Residnecy and Contractor.  Roadway cores must be shared."]
[3,"Formulas on Accept sheet update when any test set is modified.  Press the Calc button or Shift+F9 on the sheet if data is added or modified in the others sheets to update Accept."]
[4,"Match Residency and Contractor Set numbers as the same.  In other words, Sets should be paired by Lot/Sublot numbers whether samples were split or independent or none taken."]
[5,"Randomly pick and delete two of the four Set numbers on the RT sheet for the first F&T comparison for Lot 1.  RT Sets would then have 2 tests from Lot 1 and 1 test from Lot 2."]
[6,"Delete the other two Set numbers from the initilization CT sets for the first F&T comparsion after initialization."]
[7,"Delete Set numbers on the Contractor test sheet (CT) if it was a split sample with the Residency. Do not delete if matching Residency sample was independent and not split."]
[]
[]
["Date","Changes"]
["2015-03-23","Created file."]

{"sheet":"Random","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Note","Block Size","Random","Date",null,null,"Random"]
[null,null,null,null,null,"Block Size (3-6)","Pick(s)/Block (25%)","No. of Blocks"]
[null,null,null,null,null,4,1,1]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Note: For PWL, a Block (lot) size is typically 4 sublots. "]
[null,null,null,null,null,"Note: Random picks/block is usually 1 per block size of 4."]
[null,null,null,null,null,"Note: No. of blocks is the expected number 4,000 ton lots for PWL.  "]
[null,null,null,null,null,"e.g. 20,000 tons for a mix, number of blocks are 5."]
[]
[null,null,null,null,null,"Example Run 1: 4, 2, 1.  Generates 2 random numbers for RT initilization random set to use for the first F&T."]
[null,null,null,null,null,"Example Run 2: 4, 1, 5.  Generates random numbers for 5 set blocks of size 4."]
[null,null,null,null,null,"Example Run 3: 5, 1, 5.  Generates random numbers for block sizes of 5, for 5 block sets."]
[null,null,null,null,null,"Example Run 4: 6, 2, 5.  Generates 2 random numbers for block sizes of 6, for each of 5 block sets."]

{"sheet":"RT","index":2,"n_rows":83,"n_cols":38,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,37,2,37],[1,15,2,15],[1,17,2,17],[1,19,2,19],[1,26,2,26],[1,36,2,36]]}
["RESIDENCY'S STATISTICAL VALIDATION WORKSHEET"]
[null,"Gradation","Sieve Size",null,null,null,null,null,null,null,null,null,null,null,null,"AC",null,"Air\nVoids",null,"VMA",null,"Roadway","Roadway","Roadway","Roadway",null,"Date",null,"Gradation",null,"AC Content",null,"Air Voids",null,"Roadway Density",null,"SiteManager ID","Notes"]
["Set","Residency  Lot / Sub-Lot","1-1/2\"     37.5 mm","1\"           25 mm","3/4\"        19 mm","1/2\"        12.5 mm","3/8\"          9.5 mm","#4             4.75 mm","#8             2.36 mm","#16           1.18 mm","#30            .600 mm","#50            .300 mm","#100          .150 mm","#200          .075 mm",null,null,null,null,null,null,null,"Density #1","Density #2","Density #3","Avg. Dens.",null,null,null,"Technician or ID","Equip. ID","Technician or ID","Equip. ID","Technician or ID","Equip. ID","Technician or ID","Equip. ID"]
[null,null,100,100,96.9,84.2,76.900000000000006,63.6,46.8,32.200000000000003,24,15.5,7.6,4.66,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V4:X4)),\"\",ROUND(AVERAGE(V4:X4),1))","v":""}]
[null,null,100,100,96.8,84.9,80.900000000000006,66.3,48.5,34.5,26.1,17.100000000000001,8.1999999999999993,4.93,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V5:X5)),\"\",ROUND(AVERAGE(V5:X5),1))","v":""}]
[null,null,100,100,94.2,81.7,75.099999999999994,63.1,46.5,32.4,24.4,15.7,7.5,4.26,null,null,null,null,null,null,null,null,null,null,""]
[null,null,100,100,98.3,88.6,81.099999999999994,66.2,48.3,33.9,25.8,17.2,8.6999999999999993,4.8099999999999996,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,100,100,98.4,85.7,81.099999999999994,68.8,52.1,36.200000000000003,27.3,17.7,8.8000000000000007,5.12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V9:X9)),\"\",ROUND(AVERAGE(V9:X9),1))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,100,100,91.7,76.099999999999994,69.8,57.6,44,31.1,23.6,15.4,7.6,4.4800000000000004,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V14:X14)),\"\",ROUND(AVERAGE(V14:X14),1))","v":""}]
[]
[]
[null,null,100,100,95.4,80.599999999999994,73.5,60.2,45.9,32.700000000000003,24.9,16.399999999999999,8.1,4.74,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V17:X17)),\"\",ROUND(AVERAGE(V17:X17),1))","v":""}]
[]
[null,null,100,100,95.6,82.4,74.099999999999994,62.7,47.7,33.5,25.3,16.3,7.6,4.08,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(N30=\"\",\"\",+AC29)","v":""},{"$f":"IF(AC30=\"\",\"\",+AD29)","v":""},{"$f":"IF(P30=\"\",\"\",+AC29)","v":""},{"$f":"IF(AE30=\"\",\"\",+AF29)","v":""},{"$f":"IF($AC$4=\"\",\"\",+AE30)","v":""},{"$f":"IF(AG30=\"\",\"\",+AH29)","v":""},{"$f":"IF($AA30=\"\",\"\",+AG29)","v":""},{"$f":"IF(AI30=\"\",\"\",+AJ29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V69:X69)),\"\",ROUND(AVERAGE(V69:X69),1))","v":""},null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(N70=\"\",\"\",+AC69)","v":""},{"$f":"IF(AC70=\"\",\"\",+AD69)","v":""},{"$f":"IF(P70=\"\",\"\",+AC69)","v":""},{"$f":"IF(AE70=\"\",\"\",+AF69)","v":""},{"$f":"IF($AC$4=\"\",\"\",+AE70)","v":""},{"$f":"IF(AG70=\"\",\"\",+AH69)","v":""},{"$f":"IF($AA70=\"\",\"\",+AG69)","v":""},{"$f":"IF(AI70=\"\",\"\",+AJ69)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V83:X83)),\"\",ROUND(AVERAGE(V83:X83),1))","v":""},null,null,null,"","","","","","","",""]

{"sheet":"CT","index":3,"n_rows":83,"n_cols":38,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,37,2,37],[1,15,2,15],[1,17,2,17],[1,19,2,19],[1,26,2,26],[1,36,2,36]]}
["CONTRACTOR'S STATISTICAL VALIDATION WORKSHEET"]
[null,"Gradation","Sieve Size",null,null,null,null,null,null,null,null,null,null,null,null,"AC",null,"Air\nVoids",null,"VMA",null,"Roadway","Roadway","Roadway","Roadway",null,"Date",null,"Gradation",null,"AC Content",null,"Air Voids",null,"Roadway Density",null,"SiteManager ID","Notes"]
["Set","Contractor  Lot / Sub-Lot","1-1/2\"\n37.5 mm","1\"           25 mm","3/4\"        19 mm","1/2\"        12.5 mm","3/8\"          9.5 mm","#4             4.75 mm","#8             2.36 mm","#16           1.18 mm","#30            .600 mm","#50            .300 mm","#100          .150 mm","#200          .075 mm",null,null,null,null,null,null,null,"Density #1","Density #2","Density #3","Avg. Dens.",null,null,null,"Technician or ID","Equip. ID","Technician or ID","Equip. ID","Technician or ID","Equip. ID","Technician or ID","Equip. ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V4:X4)),\"\",ROUND(AVERAGE(V4:X4),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V5:X5)),\"\",ROUND(AVERAGE(V5:X5),1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," ",null," ",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," ",null," ",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," ",null," ",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," ",null," ",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(N26=\"\",\"\",+AC25)","v":""},{"$f":"IF(AC26=\"\",\"\",+AD25)","v":""},{"$f":"IF(P26=\"\",\"\",+AC25)","v":""},{"$f":"IF(AE26=\"\",\"\",+AF25)","v":""},{"$f":"IF(RT!$AC$4=\"\",\"\",+AE26)","v":""},{"$f":"IF(AG26=\"\",\"\",+AH25)","v":""},{"$f":"IF($Y26=\"\",\"\",+AG25)","v":""},{"$f":"IF(AI26=\"\",\"\",+AJ25)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE27)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE28)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE29)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE30)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE31)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE32)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE33)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE34)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE35)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE36)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE37)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE38)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE39)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE40)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE41)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE42)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE43)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE44)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE45)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE46)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE47)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE48)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE49)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE50)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE51)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE52)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE53)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE54)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE55)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE56)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE57)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE58)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE59)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE60)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE61)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE62)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE63)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE64)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE65)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE66)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE67)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE68)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V69:X69)),\"\",ROUND(AVERAGE(V69:X69),1))","v":""},null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE69)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(N70=\"\",\"\",+AC69)","v":""},{"$f":"IF(AC70=\"\",\"\",+AD69)","v":""},{"$f":"IF(P70=\"\",\"\",+AC69)","v":""},{"$f":"IF(AE70=\"\",\"\",+AF69)","v":""},{"$f":"IF(RT!$AC$4=\"\",\"\",+AE70)","v":""},{"$f":"IF(AG70=\"\",\"\",+AH69)","v":""},{"$f":"IF($Y70=\"\",\"\",+AG69)","v":""},{"$f":"IF(AI70=\"\",\"\",+AJ69)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE71)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE72)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE73)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE74)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE75)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE76)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE77)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE78)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE79)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE80)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE81)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE82)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(AVERAGE(V83:X83)),\"\",ROUND(AVERAGE(V83:X83),1))","v":""},null,null,null,"","","","",{"$f":"IF(RT!$AC$4=\"\",\"\",+AE83)","v":""},"","",""]

{"sheet":"Accept","index":4,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[6,1,6,4],[6,6,6,8],[6,9,6,10],[6,11,6,13],[0,1,0,13],[1,1,1,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[7,1,7,4],[7,6,7,8],[7,9,7,10],[7,11,7,13],[8,1,8,4],[8,6,8,8],[8,9,8,10],[8,11,8,13]]}
["v 0.9","SUMMARY OF TEST RESULTS FOR ACCEPTANCE"]
[null,"SUPERPAVE"]
[]
[null,"Use of Contractor's Test Results for Acceptance Purposes"]
[null,"Construction Control Directive No. 20020215"]
[]
[" Project No. "," ",null,null,null,"J.P. No.",null,null,null,"Contract No. "]
[" Contractor ",null,null,null,null,"Producer",null,null,null," Plant Location "]
["ID or Note",null,null,null,null,"Mix Type",null,null,null,"Design No. "]
[]
[null,"Qual. Char.","LOT/ID","Begin Set","End Set","x̅p","Np","Df","sp","tcrit","tp","Accept","Date"]
[null,"Rdy. Dens.",null,null,null,{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",xbarp(rtct(CT!$A$1,$B12,$D12,$E12,FALSE),rtct(RT!$A$1,$B12,$D12,$E12,FALSE)))","v":""},{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",E12-D12+1)","v":""},{"$f":"IF(G12=\"\",\"\",G12-1)","v":""},{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",sp(rtct(RT!$A$1,$B12,$D12,$E12,FALSE),rtct(CT!$A$1,$B12,$D12,$E12,FALSE)))","v":""},{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",tcrit(rtct(RT!$A$1,$B12,$D12,$E12,FALSE),rtct(CT!$A$1,$B12,$D12,$E12,FALSE),TRUE))","v":""},{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",tp(rtct(RT!$A$1,$B12,$D12,$E12,FALSE),rtct(CT!$A$1,$B12,$D12,$E12,FALSE)))","v":""},{"$f":"IF(K12=\"\",\"\",IF(K12<=J12,TRUE,FALSE))","v":""}]
[null,"AV",null,null,null,{"$f":"IF(OR(D13=\"\",E13=\"\"),\"\",xbarp(rtct(CT!$A$1,$B13,$D13,$E13,FALSE),rtct(RT!$A$1,$B13,$D13,$E13,FALSE)))","v":""},{"$f":"IF(OR(D13=\"\",E13=\"\"),\"\",E13-D13+1)","v":""},{"$f":"IF(G13=\"\",\"\",G13-1)","v":""},{"$f":"IF(OR(D13=\"\",E13=\"\"),\"\",sp(rtct(RT!$A$1,$B13,$D13,$E13,FALSE),rtct(CT!$A$1,$B13,$D13,$E13,FALSE)))","v":""},{"$f":"IF(OR(D13=\"\",E13=\"\"),\"\",tcrit(rtct(RT!$A$1,$B13,$D13,$E13,FALSE),rtct(CT!$A$1,$B13,$D13,$E13,FALSE),TRUE))","v":""},{"$f":"IF(OR(D13=\"\",E13=\"\"),\"\",tp(rtct(RT!$A$1,$B13,$D13,$E13,FALSE),rtct(CT!$A$1,$B13,$D13,$E13,FALSE)))","v":""},{"$f":"IF(K13=\"\",\"\",IF(K13<=J13,TRUE,FALSE))","v":""}]
[null,"AC",null,null,null,{"$f":"IF(OR(D14=\"\",E14=\"\"),\"\",xbarp(rtct(CT!$A$1,$B14,$D14,$E14,FALSE),rtct(RT!$A$1,$B14,$D14,$E14,FALSE)))","v":""},"","",{"$f":"IF(OR(D14=\"\",E14=\"\"),\"\",sp(rtct(RT!$A$1,$B14,$D14,$E14,FALSE),rtct(CT!$A$1,$B14,$D14,$E14,FALSE)))","v":""},{"$f":"IF(OR(D14=\"\",E14=\"\"),\"\",tcrit(rtct(RT!$A$1,$B14,$D14,$E14,FALSE),rtct(CT!$A$1,$B14,$D14,$E14,FALSE),TRUE))","v":""},{"$f":"IF(OR(D14=\"\",E14=\"\"),\"\",tp(rtct(RT!$A$1,$B14,$D14,$E14,FALSE),rtct(CT!$A$1,$B14,$D14,$E14,FALSE)))","v":""},""]
[null,"VMA",null,null,null,{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",xbarp(rtct(CT!$A$1,$B15,$D15,$E15,FALSE),rtct(RT!$A$1,$B15,$D15,$E15,FALSE)))","v":""},"","",{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",sp(rtct(RT!$A$1,$B15,$D15,$E15,FALSE),rtct(CT!$A$1,$B15,$D15,$E15,FALSE)))","v":""},{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",tcrit(rtct(RT!$A$1,$B15,$D15,$E15,FALSE),rtct(CT!$A$1,$B15,$D15,$E15,FALSE),TRUE))","v":""},{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",tp(rtct(RT!$A$1,$B15,$D15,$E15,FALSE),rtct(CT!$A$1,$B15,$D15,$E15,FALSE)))","v":""},""]
[]
[null,"Qual. Char.","LOT/ID","Begin Set","End Set","F","Fcrit","F ≤ Fcrit","t","tcrit","t ≤ tcrit","Accept","Date"]
[null,"Rdy. Dens.",null,null,null,{"$f":"IF(OR(D18=\"\",E18=\"\"),\"\",fstat(rtct(RT!$A$1,$B18,$D18,$E18),rtct(CT!$A$1,$B18,$D18,$E18)))","v":""},{"$f":"IF(OR(D18=\"\",E18=\"\"),\"\",fcrit(rtct(RT!$A$1,$B18,$D18,$E18),rtct(CT!$A$1,$B18,$D18,$E18)))","v":""},{"$f":"IF(AND(F18<>\"\",F18<>0,G18<>\"\",G18<>0),F18<=G18,\"\")","v":""},{"$f":"IF(OR(D18=\"\",E18=\"\"),\"\",tstat(rtct(RT!$A$1,$B18,$D18,$E18),rtct(CT!$A$1,$B18,$D18,$E18)))","v":""},{"$f":"IF(OR(D18=\"\",E18=\"\"),\"\",tcrit(rtct(RT!$A$1,$B18,$D18,$E18),rtct(CT!$A$1,$B18,$D18,$E18)))","v":""},{"$f":"IF(AND(I18<>\"\",I18<>0,J18<>\"\",J18<>0),I18<=J18,\"\")","v":""},{"$f":"IF(OR(H18=\"\",K18=\"\"),\"\",IF(AND(H18=TRUE,K18=TRUE),TRUE,FALSE))","v":""}]
[null,"AV",null,null,null,{"$f":"IF(OR(D19=\"\",E19=\"\"),\"\",fstat(rtct(RT!$A$1,$B19,$D19,$E19),rtct(CT!$A$1,$B19,$D19,$E19)))","v":""},{"$f":"IF(OR(D19=\"\",E19=\"\"),\"\",fcrit(rtct(RT!$A$1,$B19,$D19,$E19),rtct(CT!$A$1,$B19,$D19,$E19)))","v":""},{"$f":"IF(AND(F19<>\"\",F19<>0,G19<>\"\",G19<>0),F19<=G19,\"\")","v":""},{"$f":"IF(OR(D19=\"\",E19=\"\"),\"\",tstat(rtct(RT!$A$1,$B19,$D19,$E19),rtct(CT!$A$1,$B19,$D19,$E19)))","v":""},{"$f":"IF(OR(D19=\"\",E19=\"\"),\"\",tcrit(rtct(RT!$A$1,$B19,$D19,$E19),rtct(CT!$A$1,$B19,$D19,$E19)))","v":""},{"$f":"IF(AND(I19<>\"\",I19<>0,J19<>\"\",J19<>0),I19<=J19,\"\")","v":""},{"$f":"IF(OR(H19=\"\",K19=\"\"),\"\",IF(AND(H19=TRUE,K19=TRUE),TRUE,FALSE))","v":""}]
[null,"AC",null,null,null,{"$f":"IF(OR(D20=\"\",E20=\"\"),\"\",fstat(rtct(RT!$A$1,$B20,$D20,$E20),rtct(CT!$A$1,$B20,$D20,$E20)))","v":""},{"$f":"IF(OR(D20=\"\",E20=\"\"),\"\",fcrit(rtct(RT!$A$1,$B20,$D20,$E20),rtct(CT!$A$1,$B20,$D20,$E20)))","v":""},"",{"$f":"IF(OR(D20=\"\",E20=\"\"),\"\",tstat(rtct(RT!$A$1,$B20,$D20,$E20),rtct(CT!$A$1,$B20,$D20,$E20)))","v":""},{"$f":"IF(OR(D20=\"\",E20=\"\"),\"\",tcrit(rtct(RT!$A$1,$B20,$D20,$E20),rtct(CT!$A$1,$B20,$D20,$E20)))","v":""},"",""]
[null,"VMA",null,null,null,{"$f":"IF(OR(D21=\"\",E21=\"\"),\"\",fstat(rtct(RT!$A$1,$B21,$D21,$E21),rtct(CT!$A$1,$B21,$D21,$E21)))","v":""},{"$f":"IF(OR(D21=\"\",E21=\"\"),\"\",fcrit(rtct(RT!$A$1,$B21,$D21,$E21),rtct(CT!$A$1,$B21,$D21,$E21)))","v":""},"",{"$f":"IF(OR(D21=\"\",E21=\"\"),\"\",tstat(rtct(RT!$A$1,$B21,$D21,$E21),rtct(CT!$A$1,$B21,$D21,$E21)))","v":""},{"$f":"IF(OR(D21=\"\",E21=\"\"),\"\",tcrit(rtct(RT!$A$1,$B21,$D21,$E21),rtct(CT!$A$1,$B21,$D21,$E21)))","v":""},"",""]
[]
[null,"Qual. Char.","LOT/ID","Begin Set","End Set","F","Fcrit","F ≤ Fcrit","t","tcrit","t ≤ tcrit","Accept","Date"]
[null,"Rdy. Dens.",null,null,null,{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",fstat(rtct(RT!$A$1,$B24,$D24,$E24),rtct(CT!$A$1,$B24,$D24,$E24)))","v":""},{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",fcrit(rtct(RT!$A$1,$B24,$D24,$E24),rtct(CT!$A$1,$B24,$D24,$E24)))","v":""},{"$f":"IF(AND(F24<>\"\",F24<>0,G24<>\"\",G24<>0),F24<=G24,\"\")","v":""},{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",tstat(rtct(RT!$A$1,$B24,$D24,$E24),rtct(CT!$A$1,$B24,$D24,$E24)))","v":""},{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",tcrit(rtct(RT!$A$1,$B24,$D24,$E24),rtct(CT!$A$1,$B24,$D24,$E24)))","v":""},{"$f":"IF(AND(I24<>\"\",I24<>0,J24<>\"\",J24<>0),I24<=J24,\"\")","v":""},{"$f":"IF(OR(H24=\"\",K24=\"\"),\"\",IF(AND(H24=TRUE,K24=TRUE),TRUE,FALSE))","v":""}]
[null,"AV",null,null,null,{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",fstat(rtct(RT!$A$1,$B25,$D25,$E25),rtct(CT!$A$1,$B25,$D25,$E25)))","v":""},{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",fcrit(rtct(RT!$A$1,$B25,$D25,$E25),rtct(CT!$A$1,$B25,$D25,$E25)))","v":""},{"$f":"IF(AND(F25<>\"\",F25<>0,G25<>\"\",G25<>0),F25<=G25,\"\")","v":""},{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",tstat(rtct(RT!$A$1,$B25,$D25,$E25),rtct(CT!$A$1,$B25,$D25,$E25)))","v":""},{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",tcrit(rtct(RT!$A$1,$B25,$D25,$E25),rtct(CT!$A$1,$B25,$D25,$E25)))","v":""},{"$f":"IF(AND(I25<>\"\",I25<>0,J25<>\"\",J25<>0),I25<=J25,\"\")","v":""},{"$f":"IF(OR(H25=\"\",K25=\"\"),\"\",IF(AND(H25=TRUE,K25=TRUE),TRUE,FALSE))","v":""}]
[null,"AC",null,null,null,{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",fstat(rtct(RT!$A$1,$B26,$D26,$E26),rtct(CT!$A$1,$B26,$D26,$E26)))","v":""},{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",fcrit(rtct(RT!$A$1,$B26,$D26,$E26),rtct(CT!$A$1,$B26,$D26,$E26)))","v":""},"",{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",tstat(rtct(RT!$A$1,$B26,$D26,$E26),rtct(CT!$A$1,$B26,$D26,$E26)))","v":""},{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",tcrit(rtct(RT!$A$1,$B26,$D26,$E26),rtct(CT!$A$1,$B26,$D26,$E26)))","v":""},"",""]
[null,"VMA",null,null,null,{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",fstat(rtct(RT!$A$1,$B27,$D27,$E27),rtct(CT!$A$1,$B27,$D27,$E27)))","v":""},{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",fcrit(rtct(RT!$A$1,$B27,$D27,$E27),rtct(CT!$A$1,$B27,$D27,$E27)))","v":""},"",{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",tstat(rtct(RT!$A$1,$B27,$D27,$E27),rtct(CT!$A$1,$B27,$D27,$E27)))","v":""},{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",tcrit(rtct(RT!$A$1,$B27,$D27,$E27),rtct(CT!$A$1,$B27,$D27,$E27)))","v":""},"",""]
[]
[null,"Qual. Char.","LOT/ID","Begin Set","End Set","F","Fcrit","F ≤ Fcrit","t","tcrit","t ≤ tcrit","Accept","Date"]
[null,"Rdy. Dens.",null,null,null,{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",fstat(rtct(RT!$A$1,$B30,$D30,$E30),rtct(CT!$A$1,$B30,$D30,$E30)))","v":""},{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",fcrit(rtct(RT!$A$1,$B30,$D30,$E30),rtct(CT!$A$1,$B30,$D30,$E30)))","v":""},{"$f":"IF(AND(F30<>\"\",F30<>0,G30<>\"\",G30<>0),F30<=G30,\"\")","v":""},{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",tstat(rtct(RT!$A$1,$B30,$D30,$E30),rtct(CT!$A$1,$B30,$D30,$E30)))","v":""},{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",tcrit(rtct(RT!$A$1,$B30,$D30,$E30),rtct(CT!$A$1,$B30,$D30,$E30)))","v":""},{"$f":"IF(AND(I30<>\"\",I30<>0,J30<>\"\",J30<>0),I30<=J30,\"\")","v":""},{"$f":"IF(OR(H30=\"\",K30=\"\"),\"\",IF(AND(H30=TRUE,K30=TRUE),TRUE,FALSE))","v":""}]
[null,"AV",null,null,null,{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",fstat(rtct(RT!$A$1,$B31,$D31,$E31),rtct(CT!$A$1,$B31,$D31,$E31)))","v":""},{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",fcrit(rtct(RT!$A$1,$B31,$D31,$E31),rtct(CT!$A$1,$B31,$D31,$E31)))","v":""},{"$f":"IF(AND(F31<>\"\",F31<>0,G31<>\"\",G31<>0),F31<=G31,\"\")","v":""},{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",tstat(rtct(RT!$A$1,$B31,$D31,$E31),rtct(CT!$A$1,$B31,$D31,$E31)))","v":""},{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",tcrit(rtct(RT!$A$1,$B31,$D31,$E31),rtct(CT!$A$1,$B31,$D31,$E31)))","v":""},{"$f":"IF(AND(I31<>\"\",I31<>0,J31<>\"\",J31<>0),I31<=J31,\"\")","v":""},{"$f":"IF(OR(H31=\"\",K31=\"\"),\"\",IF(AND(H31=TRUE,K31=TRUE),TRUE,FALSE))","v":""}]
[null,"AC",null,null,null,{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",fstat(rtct(RT!$A$1,$B32,$D32,$E32),rtct(CT!$A$1,$B32,$D32,$E32)))","v":""},{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",fcrit(rtct(RT!$A$1,$B32,$D32,$E32),rtct(CT!$A$1,$B32,$D32,$E32)))","v":""},"",{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",tstat(rtct(RT!$A$1,$B32,$D32,$E32),rtct(CT!$A$1,$B32,$D32,$E32)))","v":""},{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",tcrit(rtct(RT!$A$1,$B32,$D32,$E32),rtct(CT!$A$1,$B32,$D32,$E32)))","v":""},"",""]
[null,"VMA",null,null,null,{"$f":"IF(OR(D33=\"\",E33=\"\"),\"\",fstat(rtct(RT!$A$1,$B33,$D33,$E33),rtct(CT!$A$1,$B33,$D33,$E33)))","v":""},{"$f":"IF(OR(D33=\"\",E33=\"\"),\"\",fcrit(rtct(RT!$A$1,$B33,$D33,$E33),rtct(CT!$A$1,$B33,$D33,$E33)))","v":""},"",{"$f":"IF(OR(D33=\"\",E33=\"\"),\"\",tstat(rtct(RT!$A$1,$B33,$D33,$E33),rtct(CT!$A$1,$B33,$D33,$E33)))","v":""},{"$f":"IF(OR(D33=\"\",E33=\"\"),\"\",tcrit(rtct(RT!$A$1,$B33,$D33,$E33),rtct(CT!$A$1,$B33,$D33,$E33)))","v":""},"",""]
[]
[null,"Qual. Char.","LOT/ID","Begin Set","End Set","F","Fcrit","F ≤ Fcrit","t","tcrit","t ≤ tcrit","Accept","Date"]
[null,"Rdy. Dens.",null,null,null,{"$f":"IF(OR(D36=\"\",E36=\"\"),\"\",fstat(rtct(RT!$A$1,$B36,$D36,$E36),rtct(CT!$A$1,$B36,$D36,$E36)))","v":""},{"$f":"IF(OR(D36=\"\",E36=\"\"),\"\",fcrit(rtct(RT!$A$1,$B36,$D36,$E36),rtct(CT!$A$1,$B36,$D36,$E36)))","v":""},{"$f":"IF(AND(F36<>\"\",F36<>0,G36<>\"\",G36<>0),F36<=G36,\"\")","v":""},{"$f":"IF(OR(D36=\"\",E36=\"\"),\"\",tstat(rtct(RT!$A$1,$B36,$D36,$E36),rtct(CT!$A$1,$B36,$D36,$E36)))","v":""},{"$f":"IF(OR(D36=\"\",E36=\"\"),\"\",tcrit(rtct(RT!$A$1,$B36,$D36,$E36),rtct(CT!$A$1,$B36,$D36,$E36)))","v":""},{"$f":"IF(AND(I36<>\"\",I36<>0,J36<>\"\",J36<>0),I36<=J36,\"\")","v":""},{"$f":"IF(OR(H36=\"\",K36=\"\"),\"\",IF(AND(H36=TRUE,K36=TRUE),TRUE,FALSE))","v":""}]
[null,"AV",null,null,null,{"$f":"IF(OR(D37=\"\",E37=\"\"),\"\",fstat(rtct(RT!$A$1,$B37,$D37,$E37),rtct(CT!$A$1,$B37,$D37,$E37)))","v":""},{"$f":"IF(OR(D37=\"\",E37=\"\"),\"\",fcrit(rtct(RT!$A$1,$B37,$D37,$E37),rtct(CT!$A$1,$B37,$D37,$E37)))","v":""},{"$f":"IF(AND(F37<>\"\",F37<>0,G37<>\"\",G37<>0),F37<=G37,\"\")","v":""},{"$f":"IF(OR(D37=\"\",E37=\"\"),\"\",tstat(rtct(RT!$A$1,$B37,$D37,$E37),rtct(CT!$A$1,$B37,$D37,$E37)))","v":""},{"$f":"IF(OR(D37=\"\",E37=\"\"),\"\",tcrit(rtct(RT!$A$1,$B37,$D37,$E37),rtct(CT!$A$1,$B37,$D37,$E37)))","v":""},{"$f":"IF(AND(I37<>\"\",I37<>0,J37<>\"\",J37<>0),I37<=J37,\"\")","v":""},{"$f":"IF(OR(H37=\"\",K37=\"\"),\"\",IF(AND(H37=TRUE,K37=TRUE),TRUE,FALSE))","v":""}]
[null,"AC",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\"),\"\",fstat(rtct(RT!$A$1,$B38,$D38,$E38),rtct(CT!$A$1,$B38,$D38,$E38)))","v":""},{"$f":"IF(OR(D38=\"\",E38=\"\"),\"\",fcrit(rtct(RT!$A$1,$B38,$D38,$E38),rtct(CT!$A$1,$B38,$D38,$E38)))","v":""},"",{"$f":"IF(OR(D38=\"\",E38=\"\"),\"\",tstat(rtct(RT!$A$1,$B38,$D38,$E38),rtct(CT!$A$1,$B38,$D38,$E38)))","v":""},{"$f":"IF(OR(D38=\"\",E38=\"\"),\"\",tcrit(rtct(RT!$A$1,$B38,$D38,$E38),rtct(CT!$A$1,$B38,$D38,$E38)))","v":""},"",""]
[null,"VMA",null,null,null,{"$f":"IF(OR(D39=\"\",E39=\"\"),\"\",fstat(rtct(RT!$A$1,$B39,$D39,$E39),rtct(CT!$A$1,$B39,$D39,$E39)))","v":""},{"$f":"IF(OR(D39=\"\",E39=\"\"),\"\",fcrit(rtct(RT!$A$1,$B39,$D39,$E39),rtct(CT!$A$1,$B39,$D39,$E39)))","v":""},"",{"$f":"IF(OR(D39=\"\",E39=\"\"),\"\",tstat(rtct(RT!$A$1,$B39,$D39,$E39),rtct(CT!$A$1,$B39,$D39,$E39)))","v":""},{"$f":"IF(OR(D39=\"\",E39=\"\"),\"\",tcrit(rtct(RT!$A$1,$B39,$D39,$E39),rtct(CT!$A$1,$B39,$D39,$E39)))","v":""},"",""]