On excel sheet "LVL Test Data pg 1" cells J8, K8 & L8 are sample test times.
If an "X" is in cells J9, K9 or L9 (only one cell can have an "X") it needs to reference excel sheet "Patterns" rows: E thru M
"Patterns" Excel Sheet Name Relation on Excel Sheet "LVL Test Data pg 1"
Columns Test name
E EdgeBend Edge Bending A6
F FlatBend Flat Bending C6
G Tension Tension D6
H MC Moisture Content E6
I GlueBond Glue Bond Durability G6
J ABond A Bond Durability I6
K 10H2 10" H2 Specimen K6
There is a numerical code in the columns listed above associated with each pattern in row A they are:
0 = Never
1 = 24 hr, Start Up or C/O
2 = Always
If the thickness in row "D" "SpecBilletThick" on patterns is greater than "1.75" then a Tension test is not needed from row "G" from sheet "Patterns"
Based on whether there is a 0, 1 or 2 in the rows E thru M in excel sheet "Patterns"
an " X " needs to appear in excel sheet "LVL Test Data pg 1"
In cells A7, C7, D7, E7, G7, I7 or K7 in their name relation under the cell above.
Password to view VBA code is: tyrannis