How would I get excel to figure the Hardware required for the number of treads (4 per tread) in the hardware box, with hardware listed, 3/8" bolts, nuts & washers. I need this box to reamin N/A if no hardware is required.
<colgroup><col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;" width="180"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" width="60"> <col style="width: 139pt; mso-width-source: userset; mso-width-alt: 6765;" width="185"> <tbody>
</tbody>
TREAD SHEET | |||||
GRATING TYPE: | 1 1/4" x 3/16" PLAIN | ||||
NOSING TYPE: | CHECKER PLATE | ||||
FINISH: | GALVANIZED | ||||
HARDWARE: | N.A. | ||||
NO. OF | TREAD SIZE | "A" DIM. | HOLE | TRD. WT. | REFERENCE DRAWING |
TREADS | DIAMETER | ||||
100 | 1'-0 1/8" X 3'-0" | 31 | |||
10 | 10 15/16" X 2'-6" | 28 | |||
110 | PCS. TOTAL | TOTAL WT. : | 3380 | ||
<colgroup><col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;" width="180"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" width="60"> <col style="width: 139pt; mso-width-source: userset; mso-width-alt: 6765;" width="185"> <tbody>
</tbody>