Instructions

General Information:

1The purpose of this sheet is to make anchor and floor to floor rod specification more efficient. The Holdown Models and Quantities can be copied from the final tally sheet, and pasted into the appropriate tab.asd;lfja;lkj as asasdfdf2Required cells.

Do not change these cells.

3The Holdown Model must match the model in the Holdown Information page. This can be chosen using the drop down, manually typed in, or pasted from the tally sheet.asd;lfja;lkj as 4There are some holdowns that have multiple anchor diameters. These models are indicated by a dash - and then the anchor diameter in decimal format. If pasting from the tally sheet, these models will have to be corrected by using the drop down, or manually typing the dash and anchor diameter.asd;lfja;lkj as asasdfd ASDFfAnchor Rods tab:1Paste or type in the Quantity and Model information. Quantity must be greater than 0.2The Anchor Diameter is automatically populated. 3The Hole Diameter by default is 1/8" over the Anchor Diameter. This can be changed manually, but must be done in decimal format.asd;lfja;lkj 4Type the Plate Thickness into the green cells. If the anchor is being installed through a raised floor, you must add the floor height, and sheathing thickness to the Plate Thickness.asd;lfja;lkj 5Type the Embedment into the green cells.6The Item column shows the item as we would like it shown in the tally sheet. This combines the diameter of the rod with the minimum length. The model will be chosen by the branch.asd;lfja;lkj 7The Nut column shows the size of the nut. The model will be chosen by the branch.a.The Nut sizes should have their own rows in the tally sheet. The quantities should be totaled. The Note field in the tally sheet does not need to be filled in.asd;lfja;lkj 8The Washer column shows the size of the washer. The model will be chosen by the branch.b.The Washer sizes should have their own rows in the tally sheet. The quantities should be totaled. The Note field in the tally sheet does not need to be filled in.asd;lfja;lkj 9The Notes column combines the model of the holdown with the words "Foundation Anchor" This should be copied into the tally sheet notes column.asd;lfja;lkj a.If multiple holdowns have the same rod requirements, all models shall be listed in the tally sheet note. I.E. "HDU2-SDS2.5 and HDU4-SDS2.5 Foundation Anchor". This can be abbreviated to HDU2 and HDU4 Foundation Anchor. The tally for each model shall be totaled.asd;lfja;lasasd 321fdf 65465410The sheet automatically calculates the adhesive requirements and totals it. A line will need to be added to the tally sheet for the adhesive model, and the cartridge quantity from this sheet will be pasted in.asd;lfja;lkj as asasdfdf

Floor to Floor Rods tab:

1Paste or type in the Quantity and Model information. Quantity must be greater than 0.2The Anchor Diameter is automatically populated. 3Type the Plate Thickness into the green cells. This is typically 4.5 ((2) 2x top plate, plus (1) 2x bottom plate)asd;lfja;lkj 4Type the Floor Sheathing Thickness into the green cells. This must be in decimal format.5Type the Floor Height into the green cells.6The Item column shows the item as we would like it shown in the tally sheet. This combines the diameter of the rod with the minimum length. The model will be chosen by the branch.asd;lfja;lkj 7The Rod Quantity column devides the number of holdowns by two, since there will be one rod for every two holdowns.asd;lfja;lkj 8The Nut column shows the size of the nut. The model will be chosen by the branch.a.The Nut sizes should have their own rows in the tally sheet. The quantities should be totaled. This cell doubles the quantities of the holdowns to tally the nuts. The Note field in the tally sheet does not need to be filled in.asd;lfja;lkj as asasdfdf9The Washer column shows the size of the washer. The model will be chosen by the branch.b.The Washer sizes should have their own rows in the tally sheet. The quantities should be totaled. The Note field in the tally sheet does not need to be filled in.asd;lfja;lkj 10The Notes column combines the model of the holdown with the words "Floor to Floor Anchor". This should be copied into the tally sheet notes column.asd;lfja;lkj a.If multiple holdowns have the same rod requirements, all models shall be listed in the tally sheet note. I.E. "HDU2-SDS2.5 and HDU4-SDS2.5 Floor to Floor Anchor". This can be abbreviated to HDU2 and HDU4 Floor to Floor Anchor. The tally for each model shall be totaled.asd;lfja;lkj as asasdf asdfdf

V16/26/13V27/1/13Added Washers for holdowns that use multiple anchor diameters.V37/23/13Fixed an error with HD19-1.25 on Anchor Rods pageV49/4/13Fixed an error in the anchor volume calculation.

Anchor RodsHide these columnsHide these columnsAnchor Hole Area - AAnchor Rod Area - BEpoxyEpoxyEpoxyAcrylicAcrylicNominal Hole Diameter (Inches)Area of Hole (Sq. Inches)Threaded Rod Diameter (Inches)Basic Pitch Diameter
Russ Anderson: http://www.portlandbolt.com/technicalinformation/thread-pitch.htmlBasic Pitch AreaTPIAnchor Rods5/160.0771/40.21750.0372207/160.1505/160.27640.060018Qty
Russ Anderson: This is a required field!Holdown Model
Russ Anderson: The model must be typed to match the Holdown Information sheet.Anchor DiameterHole Diameter
Russ Anderson: By default this is 1/8" over the anchor size. If you wish to change the hole size, enter the new size in decimal format.

Hole VolumeAnchor VolumeRequired Anchor VolumeCubic Inches Per HoleAdhesive per hole
Russ Anderson: Russ Anderson:This cell converts the cubic inches into ounces.Adhesive for this rowS.O. MeasurementNut ThicknessPlate Thickness
Russ Anderson: This is typically 1.5, but any measurement can be used.EmbedmentMinimum Rod LengthItemItemNut
Russ Anderson: Use the Holdown quantity as the nut quantity.Washer
Russ Anderson: This column will list a cut washer if one is required. Match the Nut quantity for these washers.

Notes
Russ Anderson: Adds " Foundation Anchor" to the holdown model. This can be copied into the take-off sheet.22. Oz56. Oz9. Oz30. Oz13. Oz1/20.1963/80.33440.087816RFB45HD7B0.87510.78539816340.50617956590.27921859751.88472553331.0447.0020.8751.5
Russ Anderson: The cells below match this cell.6 3/411.125ATR 7/8 xATR 7/8 x 11.125 Min.7/8" NutN/AHD7B Foundation Anchor2.561.016.631.884.349/160.2497/160.39110.12011410LTT19-.750.750.8750.60132046890.36852845320.23279201561.57134610550.878.710.31250.750
Russ Anderson: The cells below match this cell.6 3/47.8125ATR 3/4 xATR 3/4 x 7.8125 Min.3/4" NutN/ALTT19-.75 Foundation Anchor0.470.191.230.350.805/80.3071/20.450.159013498HD7B0.87510.78539816340.50617956590.27921859751.88472553331.04520.0920.8753
Russ Anderson: The cells below match this cell.6 3/412.625ATR 7/8 xATR 7/8 x 12.625 Min.7/8" NutN/AHD7B Foundation Anchor28.3711.1473.4220.8048.013/40.4429/160.50840.2030121645LTT19-.750.750.8750.60132046890.36852845320.23279201561.57134610550.871432.310.31250.753
Russ Anderson: The cells below match this cell.6 3/410.8125ATR 3/4 xATR 3/4 x 10.8125 Min.3/4" NutN/ALTT19-.75 Foundation Anchor78.1330.69202.2157.29132.217/80.6015/80.5660.251611ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A310.7853/40.6850.368510ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A31 1/160.8877/80.80280.50629ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A31 1/80.99410.91880.66308ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A31 1/41.2271 1/81.03220.83687ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A31 3/81.4851 1/41.15721.05177ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A31 1/21.7671 3/81.26671.26026109.5343.03283.5080.32185.36Total1 5/82.0741 1/21.39171.521261 3/42.4051 3/41.62012.0615523.14221.85572.70464.52 1/83.5472 1/42.10573.48244.52 3/45.9402 1/22.33764.29174.537.0692 3/42.58765.25884.532.83766.324043 1/43.08767.487443 1/23.33768.749043 3/43.587610.1088443.837611.56674

Floor to Floor Rods

Floor to Floor Rods

QtyHoldown ModelAnchor DiameterS.O. MeasurementNut ThicknessPlate ThicknessFloor Sheathing Thickness
Russ Anderson: Enter in decimal format.Floor HeightMinimum Rod LengthItemItemRod Quantity
Russ Anderson: This is half of the number of holdowns, since there will be two holdowns per rod.Nut
Russ Anderson: Use the Holdown quantity as the nut quantity.Washer
Russ Anderson: This column will list a cut washer if one is required. Match the Nut quantity for these washers.

Notes
Russ Anderson: Adds " Floor to Floor Anchor" to the holdown model. This can be copied into the take-off sheet.

ERROR:#N/AERROR:#N/A4.5
Russ Anderson: The cells below match this cell.0.75
Russ Anderson: The cells below match this cell.18
Russ Anderson: The cells below match this cell.ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518ERROR:#N/AERROR:#N/A4.50.7518

Holdown Information

Highlighted models have multiple anchor diameters available.

ModelSOAnchor DiaNut TNutItemWasherDTT2Z-SDS2.50.18750.50000.50001/2" NutATR 1/2 xN/AHD12-13.62501.00001.00001" NutATR 1 x1" Cut WasherHD12-1.1253.62501.12501.12501 1/8" NutATR 1 1/8 x N/AHD19-1.1253.62501.12501.12501 1/8" NutATR 1 1/8 x 1 1/8" Cut WasherHD19-1.253.62501.25001.25001 1/4" NutATR 1 1/4 x N/AIf new models are added, the data validation drop down boxes on the green tabs will need to be updated to include the added rows.HD3B0.37500.62500.62505/8" NutATR 5/8 xN/AHD5B2.00000.62500.62505/8" NutATR 5/8 xN/AHD7B2.00000.87500.87507/8" NutATR 7/8 xN/AHD9B2.37500.87500.87507/8" NutATR 7/8 xN/AHDQ8-SDS32.37500.87500.87507/8" NutATR 7/8 xN/AHDU11-SDS2.51.50001.00001.00001" NutATR 1 xN/AHDU14-SDS2.51.56251.00001.00001" NutATR 1 xN/AHDU2-SDS2.51.37500.62500.62505/8" NutATR 5/8 xN/AHDU4-SDS2.51.37500.62500.62505/8" NutATR 5/8 xN/AHDU5-SDS2.51.37500.62500.62505/8" NutATR 5/8 xN/AHDU8-SDS2.51.50000.87500.87507/8" NutATR 7/8 xN/AHHDQ11-SDS2.50.87501.00001.00001" NutATR 1 xN/AHHDQ14-SDS2.50.87501.00001.00001" NutATR 1 xN/AHTT40.43750.62500.62505/8" NutATR 5/8 xN/AHTT50.43750.62500.62505/8" NutATR 5/8 xN/ALTT19-.50.31250.50000.50001/2" NutATR 1/2 x1/2" Cut WasherLTT19-.6250.31250.62500.62505/8" NutATR 5/8 x5/8" Cut WasherLTT19-.750.31250.75000.75003/4" NutATR 3/4 xN/ALTT20B-.50.31250.50000.50001/2" NutATR 1/2 x1/2" Cut WasherLTT20B-.6250.31250.62500.62505/8" NutATR 5/8 x5/8" Cut WasherLTT20B-.750.31250.75000.75003/4" NutATR 3/4 xN/ALTTI310.25000.62500.62505/8" NutATR 5/8 xN/A