ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Instructions
3
4
Random Number Generator
5
6
First:
You MUST have the Excel's "Analysis ToolPak - VBA" installed before this program will run.
7
8
Go to: Tools, Add-Ins.
9
Select "Analysis ToolPak - VBA" from the list and click the OK button to install it.
10
11
The macros will not run with out this installed
12
13
14
Using:
Enter information into the green shaded cells ONLY.
15
DO NOT modify any of the other cells.
16
DO NOT reformat the worksheet.
17
18
Buttons, use the buttons to:
19
Clear any random numbers previously generated
20
Generate a new set of random numbers.
21
Print the worksheet.
22
23
Offset number:
24
When needed, use the offset number to find transverse locations, example mat density testing.
25
Multiply the width by the random number to determine the transverse distance.
26
The default setting is to generate offset numbers. Switch this cell to No if offset numbers are not required.
27
28
Transverse Convert Worksheet for Offset numbers
29
A table of conversion factors is supplied on the Transverse_Convert worksheet to convert
30
decimal places to inches. Example: Multiply the width times the offset number. The whole number is feet.
31
Use the table to find the range that contains the decimal value. The equivalent inch measurement is then given.
32
33
Random Numbers Greater than 70:
34
The maximum number of random numbers this program can generate at a time is 70.
35
For a random number schedule above 70 tests set the "Start Value" to: 70 X the Frequency.
36
Set the "Start Number" to the next numbered test in the series.
37
Example, mat density set "Start Value" to 35,000 (70 X frequency [500] = 35,000), "Start Number" equals 71.
38
39
Note:
The "Start Value" and "Start Number" can be set to any value to generate a random number schedule
40
based on the inputted values.
41
42
Required Test That Fall Outside of the Generated Schedule:
43
Required tests that fall outside of the generated schedule still need to be taken.
44
Example, tests at the end of a run of production in which the produced material is less than the random number.
45
The fractional quantity still requires testing.
46
Generate a new random number that covers the fractional quantity and take the test.
47
Also, tests that fall into a Defined Nontesting area by specification.
48
Generate a new random number which is within the specified testing area.
49
50
Contact:
Eric Chavez if you have any problems: 303 398-6565, eric.chavez@dot.state.co.us.
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100