{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["READ ME","DENSITY & THICKNESS","GRADATION & DELETERIOUS","PLASTICITY INDEX"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":11,"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":"READ ME","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["This spreadsheet may be used as a tool for determining random locations for QC & QA testing.  "]
[]
["QA testing is not required to be performed in a random manner as are the QC tests but"]
["may be at the option of the QA inspector.  QA tests shall be performed at any time and in any "]
["location that will assure: 1. That QC is doing their job properly and, 2.  That we are receiving"]
["the quality of work for which we are paying."]

{"sheet":"DENSITY & THICKNESS","index":1,"n_rows":66,"n_cols":16,"rows_kept":66,"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]]}
["DENSITY & THICKNESS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND(),4)","v":0.879},{"$f":"ROUND(RAND(),4)","v":0.79049999999999998}]
["JOB",null,null,"ROUTE",null,null,"COUNTY"]
[]
["LOT",1,null,null,null,null,"A","B"]
["TONS IN LOT",null,null,1000,null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,0]
["ENDING TONNAGE",null,null,{"$f":"D7+D6","v":1000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,24,null,{"$f":"D6","v":1000},{"$f":"G6","v":0},{"$f":"F9*G9","v":0},{"$f":"D7+H9","v":0}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D9","v":24},{"$f":"H6","v":0},null,{"$f":"F11*G11","v":0}]
[]
[]
["LOT",{"$f":"B5+1","v":2},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":1000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D8","v":1000}]
["ENDING TONNAGE",null,null,{"$f":"D8+D15","v":2000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D15","v":1000},{"$f":"G15","v":0},{"$f":"F18*G18","v":0},{"$f":"H18+D16","v":1000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D18","v":24},{"$f":"H15","v":0},null,{"$f":"F20*G20","v":0}]
[]
[]
["LOT",{"$f":"B14+1","v":3},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":1000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D17","v":2000}]
["ENDING TONNAGE",null,null,{"$f":"D25+D24","v":3000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D24","v":1000},{"$f":"G24","v":0},{"$f":"F27*G27","v":0},{"$f":"H27+D25","v":2000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D27","v":24},{"$f":"H24","v":0},null,{"$f":"F29*G29","v":0}]
[]
[]
["LOT",{"$f":"B23+1","v":4},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":1000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D26","v":3000}]
["ENDING TONNAGE",null,null,{"$f":"D34+D33","v":4000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D33","v":1000},{"$f":"G33","v":0},{"$f":"F36*G36","v":0},{"$f":"H36+D34","v":3000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D36","v":24},{"$f":"H33","v":0},null,{"$f":"F38*G38","v":0}]
[]
[]
["LOT",{"$f":"B32+1","v":5},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":1000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D35","v":4000}]
["ENDING TONNAGE",null,null,{"$f":"D43+D42","v":5000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D42","v":1000},{"$f":"G42","v":0},{"$f":"F45*G45","v":0},{"$f":"H45+D43","v":4000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D45","v":24},{"$f":"H42","v":0},null,{"$f":"F47*G47","v":0}]
[]
[]
["LOT",{"$f":"B41+1","v":6},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":1000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D44","v":5000}]
["ENDING TONNAGE",null,null,{"$f":"D52+D51","v":6000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D51","v":1000},{"$f":"G51","v":0},{"$f":"F54*G54","v":0},{"$f":"H54+D52","v":5000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D54","v":24},{"$f":"H51","v":0},null,{"$f":"F56*G56","v":0}]
[]
[]
["LOT",{"$f":"B50+1","v":7},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":1000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D53","v":6000}]
["ENDING TONNAGE",null,null,{"$f":"D61+D60","v":7000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D60","v":1000},{"$f":"G60","v":0},{"$f":"F63*G63","v":0},{"$f":"H63+D61","v":6000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D63","v":24},{"$f":"H60","v":0},null,{"$f":"F65*G65","v":0}]
["ALWAYS MEASURE OFFSET FROM SAME EDGE"]

{"sheet":"GRADATION & DELETERIOUS","index":2,"n_rows":66,"n_cols":16,"rows_kept":66,"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]]}
["GRADATION & DELETERIOUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND(),4)","v":0.86980000000000002},{"$f":"ROUND(RAND(),4)","v":0.99019999999999997}]
["JOB",{"$f":"'DENSITY & THICKNESS'!B3","v":0},null,"ROUTE",{"$f":"'DENSITY & THICKNESS'!E3","v":0},null,"COUNTY",{"$f":"'DENSITY & THICKNESS'!H3","v":0}]
[]
["LOT",1,null,null,null,null,"A","B"]
["TONS IN LOT",null,null,2000,null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,0]
["ENDING TONNAGE",null,null,{"$f":"D7+D6","v":2000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,24,null,{"$f":"D6","v":2000},{"$f":"G6","v":0},{"$f":"F9*G9","v":0},{"$f":"D7+H9","v":0}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D9","v":24},{"$f":"H6","v":0},null,{"$f":"F11*G11","v":0}]
[]
[]
["LOT",{"$f":"B5+1","v":2},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":2000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D8","v":2000}]
["ENDING TONNAGE",null,null,{"$f":"D8+D15","v":4000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D15","v":2000},{"$f":"G15","v":0},{"$f":"F18*G18","v":0},{"$f":"H18+D16","v":2000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D18","v":24},{"$f":"H15","v":0},null,{"$f":"F20*G20","v":0}]
[]
[]
["LOT",{"$f":"B14+1","v":3},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":2000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D17","v":4000}]
["ENDING TONNAGE",null,null,{"$f":"D25+D24","v":6000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D24","v":2000},{"$f":"G24","v":0},{"$f":"F27*G27","v":0},{"$f":"H27+D25","v":4000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D27","v":24},{"$f":"H24","v":0},null,{"$f":"F29*G29","v":0}]
[]
[]
["LOT",{"$f":"B23+1","v":4},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":2000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D26","v":6000}]
["ENDING TONNAGE",null,null,{"$f":"D34+D33","v":8000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D33","v":2000},{"$f":"G33","v":0},{"$f":"F36*G36","v":0},{"$f":"H36+D34","v":6000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D36","v":24},{"$f":"H33","v":0},null,{"$f":"F38*G38","v":0}]
[]
[]
["LOT",{"$f":"B32+1","v":5},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":2000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D35","v":8000}]
["ENDING TONNAGE",null,null,{"$f":"D43+D42","v":10000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D42","v":2000},{"$f":"G42","v":0},{"$f":"F45*G45","v":0},{"$f":"H45+D43","v":8000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D45","v":24},{"$f":"H42","v":0},null,{"$f":"F47*G47","v":0}]
[]
[]
["LOT",{"$f":"B41+1","v":6},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":2000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D44","v":10000}]
["ENDING TONNAGE",null,null,{"$f":"D52+D51","v":12000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D51","v":2000},{"$f":"G51","v":0},{"$f":"F54*G54","v":0},{"$f":"H54+D52","v":10000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D54","v":24},{"$f":"H51","v":0},null,{"$f":"F56*G56","v":0}]
[]
[]
["LOT",{"$f":"B50+1","v":7},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":2000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D53","v":12000}]
["ENDING TONNAGE",null,null,{"$f":"D61+D60","v":14000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D60","v":2000},{"$f":"G60","v":0},{"$f":"F63*G63","v":0},{"$f":"H63+D61","v":12000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D63","v":24},{"$f":"H60","v":0},null,{"$f":"F65*G65","v":0}]
["ALWAYS MEASURE OFFSET FROM SAME EDGE"]

{"sheet":"PLASTICITY INDEX","index":3,"n_rows":66,"n_cols":16,"rows_kept":66,"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]]}
["PLASTICITY INDEX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND(),4)","v":0.81679999999999997},{"$f":"ROUND(RAND(),4)","v":0.755}]
["JOB",{"$f":"'DENSITY & THICKNESS'!B3","v":0},null,"ROUTE",{"$f":"'DENSITY & THICKNESS'!E3","v":0},null,"COUNTY",{"$f":"'DENSITY & THICKNESS'!H3","v":0}]
[]
["LOT",1,null,null,null,null,"A","B"]
["TONS IN LOT",null,null,10000,null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,0]
["ENDING TONNAGE",null,null,{"$f":"D7+D6","v":10000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,24,null,{"$f":"D6","v":10000},{"$f":"G6","v":0},{"$f":"F9*G9","v":0},{"$f":"D7+H9","v":0}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D9","v":24},{"$f":"H6","v":0},null,{"$f":"F11*G11","v":0}]
[]
[]
["LOT",{"$f":"B5+1","v":2},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":10000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D8","v":10000}]
["ENDING TONNAGE",null,null,{"$f":"D8+D15","v":20000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D15","v":10000},{"$f":"G15","v":0},{"$f":"F18*G18","v":0},{"$f":"H18+D16","v":10000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D18","v":24},{"$f":"H15","v":0},null,{"$f":"F20*G20","v":0}]
[]
[]
["LOT",{"$f":"B14+1","v":3},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":10000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D17","v":20000}]
["ENDING TONNAGE",null,null,{"$f":"D25+D24","v":30000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D24","v":10000},{"$f":"G24","v":0},{"$f":"F27*G27","v":0},{"$f":"H27+D25","v":20000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D27","v":24},{"$f":"H24","v":0},null,{"$f":"F29*G29","v":0}]
[]
[]
["LOT",{"$f":"B23+1","v":4},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":10000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D26","v":30000}]
["ENDING TONNAGE",null,null,{"$f":"D34+D33","v":40000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D33","v":10000},{"$f":"G33","v":0},{"$f":"F36*G36","v":0},{"$f":"H36+D34","v":30000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D36","v":24},{"$f":"H33","v":0},null,{"$f":"F38*G38","v":0}]
[]
[]
["LOT",{"$f":"B32+1","v":5},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":10000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D35","v":40000}]
["ENDING TONNAGE",null,null,{"$f":"D43+D42","v":50000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D42","v":10000},{"$f":"G42","v":0},{"$f":"F45*G45","v":0},{"$f":"H45+D43","v":40000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D45","v":24},{"$f":"H42","v":0},null,{"$f":"F47*G47","v":0}]
[]
[]
["LOT",{"$f":"B41+1","v":6},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":10000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D44","v":50000}]
["ENDING TONNAGE",null,null,{"$f":"D52+D51","v":60000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D51","v":10000},{"$f":"G51","v":0},{"$f":"F54*G54","v":0},{"$f":"H54+D52","v":50000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D54","v":24},{"$f":"H51","v":0},null,{"$f":"F56*G56","v":0}]
[]
[]
["LOT",{"$f":"B50+1","v":7},null,null,null,null,"A","B"]
["TONS IN LOT",null,null,{"$f":"$D$6","v":10000},null,"RANDOM NO."]
["BEGIN TONNAGE",null,null,{"$f":"D53","v":60000}]
["ENDING TONNAGE",null,null,{"$f":"D61+D60","v":70000},null,"T","A","X=T x A","TONNAGE + T"]
["WIDTH \"W\"",null,null,{"$f":"$D$9","v":24},null,{"$f":"D60","v":10000},{"$f":"G60","v":0},{"$f":"F63*G63","v":0},{"$f":"H63+D61","v":60000}]
[null,null,null,null,null,"W","B","OFFSET = W x B"]
[null,null,null,null,null,{"$f":"D63","v":24},{"$f":"H60","v":0},null,{"$f":"F65*G65","v":0}]
["ALWAYS MEASURE OFFSET FROM SAME EDGE"]