ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Instructions for using this program
3
4
Overview:
5
6
This program calculates price reductions according to 105.03 and other sections of the Standard Specifications.
7
It is intended to replace the earlier DOS programs with one program that does the same calculations.
8
For more information on the calculations please refer to the Standard Specifications book.
9
If you find errors in the program or have comments please e-mail or call Eric Chavez at (303) 398-6565.
10
11
The program uses six worksheets to calculate price reductions according to the materials involved.
12
They are as follows:
13
14
1 Lot
Three to Seven tests all with the same element out.
15
16
1 Lot - 2 & 3 E
Three to Seven tests with 2 and 3 elements out.
17
18
1 Test
One test with 1 element out.
19
20
1 Test - 2 & 3 E
One test with 2 & 3 elements out.
21
22
Manual
Three to Seven tests with one element out but allows the user to input any; Item, Element,
23
"F" factor, and "Pit" factor. Used when the factors have not been defined. See 105.03.
24
25
Concrete
Calculates the price reduction on concrete items, excluding gradation, according to 601.17.
26
27
The "Factors" worksheet displays the established factors that the calculations use. For information purposes.
28
29
30
VERY IMPORTANT!!!
31
You MUST have the Excel's "Analysis ToolPak - VBA" installed before this program will run.
32
33
Go to: Tools, Add-Ins.
34
Select "Analysis ToolPak - VBA" from the list and click the OK button to install it.
35
36
The macros will not run with out this installed
37
38
Using the program:
39
40
Select the appropriate worksheet for the type of deviation(s) that you have. Click on the tab for that
41
worksheet to move to it.
42
43
Click on the "Clear Worksheet" button to clear the contents of the worksheet, if needed.
44
45
Enter the project data into the green cells of the worksheet.
46
Some of the cells are setup with a dropdown list attached. When in these cells, click on the down arrow
47
to reveal the list. Scroll through the list and click on the appropriate selection. You can type directly
48
into these cells but they must match exactly the validation list. Using the dropdown list eliminates the typing.
49
50
The calculations will automatically be completed when all the required cells are filled in.
51
52
Look for error messages on the screen that will indicate problems.
53
54
Check over the data. Click on the "Goto Printable Form" button to preview what the printout will look like.
55
Click on the "Home" button to return to the input screen.
56
57
If there are no errors, click on the "Print" icon on the toolbar to print the form.
58
59
60
If you need additional help contact Eric Chavez at 303 398-6565 or via E-mail.
61
62
63
Release Notes:
64
65
Version 2.01 is the same as version 2.0 with one exception. The formatting for the Region cell
66
was changed to allow the input of any number combination. The cell now allows the input of
67
number combinations like 3-2. The previous version would convert this into a date format.
68
69
Version 3_00 was developed to account for the changes that occurred with the release of the
70
revision of section 105 dated August 23, 2001. The tables and program were modified to match the
71
new standard special provision.
72
73
Version 3_01 of this program corrects a reference error on the report for one sample with
74
two & three elements out. The final calculations shown on this report have always been correct.
75
76
Version 3_02 of this program adds the Lottman test and its factors into the program. The factors
77
for the Lottman element come from revision of section 401. Program checks were also updated.
78
79
Version 3_03 of this program correct an error on the printout for the concrete price reductions.
80
The price reduction calculations in the previous versions are correct. The Pay Factor reference
81
on the printed report was not always correct.
82
83
Version 3_04 of this program corrects a cell protection error on the Manual worksheet. This cell was
84
not used in any calculations. All calculations in the previous version are correct.
85
86
Version 4_01 of this program was developed to account for the changes to subsection 105.03
87
with the release of the Standard Special Provision dated May 26, 2005. Six elements were added
88
to the price reduction calculations in the standard special. None of the calculations in the superseded
89
specification were modified with the release of the modified one. Also, the rounding in the spreadsheet
90
was modified to more accurately match the specification. The signature section of the reports was
91
also modified.
92
93
94
95
96
97
98
99
100