{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Verif Random Plan"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Verif Random Plan","index":0,"n_rows":63,"n_cols":25,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,"Clicking \"Enable Content\" allows the random number generator macro to run when you enter <Ctlr> + the \"w\" key.   You may choose to disable this, then enter your own random numbers."]
[null,null,null,null,null,"     Caltrans Stratified Random Sampling Plan",null,null,null,"Revision:","04/22/2020"]
[null,null,null,null,null,"For verification sampling on projects using Statistical Pay Factor Specifications"]
[null,null,null,null,null,null,"Contract Number:"]
[null,null,null,null,null,null,"Contractor:"]
["This plan covers verification of the following Pay Factor Quality Characteristics:",null,null,null,null,null,"HMA Producer:"]
[null,null,null,null,null,null,"JMF Number:"]
[null,null,null,null,null,null,"HMA Plant:"]
[null,null,null,null,null,null,"Lot Number:",1]
[null,null,null,null,null,null,"HMA Type:"]
[]
[null,null,null,null,"See \"Instructions\".",null,"Min Verification Tests Needed.  Except always use 3 for Air Voids.","Quantity / minimum number of required verification samples\n(tons)"]
[null,null,null,"Contractor's Planned Final Lot Quantity:",15000,"tons",{"$f":"MAX(3,(ROUNDUP(contractorq/3750,0)))","v":4},{"$f":"ROUND(contractorq/G13,0)","v":3750},"tons"]
[null,null,null,"Potential Lot Termination at:",11000,"tons",{"$f":"MAX(3,(ROUNDUP(potlq/3750,0)))","v":3},{"$f":"ROUND(potlq/G14,0)","v":3667},"tons"]
[null,null,null,null,null,null,"Lowest of above two values:",{"$f":"MIN(H13:H14)","v":3667},"tons"]
[null,null,"Recommended Stratified Quantity:",{"$f":"ROUND((contractorq/recommendedq),0)&\" each\"","v":"5 each"},{"$f":"\"parts of\"","v":"parts of"},{"$f":"recommendedq&\" tons\"","v":"3000 tons"},"         per stratified quantity for a total of ",null,{"$f":"ROUND((contractorq/recommendedq),0)*recommendedq","v":15000},"± tons in the lot"]
[null,null,null,null,null,null,"Enter Stratified Quantity to be used in stratified random sampling plan below:",3000,"tons"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(R22:R39,COUNTIF(R22:R39,\">\"&H15)+1)","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The info below used to build the text in Col G"]
["Lot Number","Verification\ntest number","Beginning Ton in Stratified Portion","Ending Ton in Stratified Portion","Random Numbers \nPress <Ctrl> + w \nto generate new set","Verification Milestone Tonnage","Approx. location of engineer's stratified random sample milestone referenced to the contractor sublot.","Engineers Estimated Sampling date / time (see Note 1)",null,null,null,null,null,null,null,null,"number of samples","Stratified Quantity options if completing at Contractors Q","Random Numbers Equation used to generate a value to 4 decimal pts between 0 and 1. This changes after every cell entry, but the values in column E do not, becuase the macro takes these values, and pastest only the value below, not the equation into column E.   After it does that , these values below change again, but not in column E.  At least not until the macro is run again.","Random Number from Column E after pasting values used to values into column E when macro runs.","Verification Milestone, from column F","Equiv Contractor sublot No. Column U / 750","Integer, the sublot before the referenced sublot in Column G","Fraction","tons  into lot"]
[{"$f":"lotno","v":1},1,0,{"$f":"MIN(contractorq,(C22+stratq))","v":3000},0.39989999999999998,{"$f":"ROUND(C22+((D22-C22)*E22),0)","v":1200},{"$f":"Y22&\" tons into sublot \"&(W22+1)","v":"450 tons into sublot 2"},null,null,null,null,null,null,null,null,null,3,{"$f":"ROUND(contractorq/Q22,2)","v":5000},{"$f":"ROUND(RAND(),4)","v":0.64900000000000002},{"$f":"E22","v":0.39989999999999998},{"$f":"F22","v":1200},{"$f":"U22/750","v":1.6},{"$f":"INT(V22)","v":1},{"$f":"V22-W22","v":0.60000000000000009},{"$f":"ROUND(X22*750,0)","v":450}]
[1,2,{"$f":"D22","v":3000},6000,0.60499999999999998,{"$f":"ROUND(C23+((D23-C23)*E23),0)","v":4815},{"$f":"Y23&\" tons into sublot \"&(W23+1)","v":"315 tons into sublot 7"},null,null,null,null,null,null,null,null,null,4,3750,{"$f":"ROUND(RAND(),4)","v":0.21490000000000001},{"$f":"E23","v":0.60499999999999998},{"$f":"F23","v":4815},{"$f":"U23/750","v":6.42},{"$f":"INT(V23)","v":6},{"$f":"V23-W23","v":0.41999999999999993},{"$f":"ROUND(X23*750,0)","v":315}]
[1,3,{"$f":"D23","v":6000},9000,0.43669999999999998,7310,"560 tons into sublot 10",null,null,null,null,null,null,null,null,null,5,3000,0.42299999999999999,0.43669999999999998,7310,9.7466666666666661,9,0.74666666666666615,560]
[1,4,9000,12000,0.26919999999999999,9808,"58 tons into sublot 14",null,null,null,null,null,null,null,null,null,6,2500,0.42059999999999997,0.26919999999999999,9808,13.077333333333334,13,7.7333333333333698E-2,58]
[1,5,12000,15000,0.92200000000000004,14766,"516 tons into sublot 20",null,null,null,null,null,null,null,null,null,7,2142.86,0.84199999999999997,0.92200000000000004,14766,19.687999999999999,19,0.68799999999999883,516]
[1,6,15000,15000,3.2300000000000002E-2,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,8,1875,0.72870000000000001,3.2300000000000002E-2,15000,20,20,0,0]
[1,7,15000,15000,5.2499999999999998E-2,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,9,1666.67,0.32269999999999999,5.2499999999999998E-2,15000,20,20,0,0]
[1,8,15000,15000,8.7499999999999994E-2,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,10,1500,0.64880000000000004,8.7499999999999994E-2,15000,20,20,0,0]
[1,9,15000,15000,0.192,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,11,1363.64,0.25269999999999998,0.192,15000,20,20,0,0]
[1,10,15000,15000,0.30449999999999999,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,12,1250,0.37359999999999999,0.30449999999999999,15000,20,20,0,0]
[1,11,15000,15000,0.10009999999999999,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,13,1153.8499999999999,0.77759999999999996,0.10009999999999999,15000,20,20,0,0]
[1,12,15000,15000,0.1663,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,14,1071.43,0.80010000000000003,0.1663,15000,20,20,0,0]
[1,13,15000,15000,0.7742,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,15,1000,8.8599999999999998E-2,0.7742,15000,20,20,0,0]
[1,14,15000,15000,0.99009999999999998,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,16,937.5,0.92520000000000002,0.99009999999999998,15000,20,20,0,0]
[1,15,15000,15000,0.69940000000000002,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,17,882.35,0.53369999999999995,0.69940000000000002,15000,20,20,0,0]
[1,16,15000,15000,0.67979999999999996,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,18,833.33,0.59350000000000003,0.67979999999999996,15000,20,20,0,0]
[1,17,15000,15000,0.77580000000000005,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,19,789.47,0.80649999999999999,0.77580000000000005,15000,20,20,0,0]
[1,18,15000,15000,0.86070000000000002,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,20,750,0.33679999999999999,0.86070000000000002,15000,20,20,0,0]
[1,19,15000,15000,0.66990000000000005,{"$f":"ROUND(C40+((D40-C40)*E40),0)","v":15000},{"$f":"Y40&\" tons into sublot \"&(W40+1)","v":"0 tons into sublot 21"},null,null,null,null,null,null,null,null,null,"don't extend the above two cols.",null,0.31759999999999999,{"$f":"E40","v":0.66990000000000005},{"$f":"F40","v":15000},20,20,{"$f":"V40-W40","v":0},0]
[1,20,15000,15000,0.2843,15000,"0 tons into sublot 21",null,null,null,null,null,null,null,null,null,null,null,0.32300000000000001,0.2843,15000,20,20,0,0]
[]
["NOTES:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For necessary changes, send email to: HQ.Construction.Engineering@dot.ca.gov",null,null,null,null,null,null,null,null,null,"© Copyright 2020 California Department of Transportation"]