Beam times

[Pigrider02]

I want to be able to automatically add the values from the chart to the right. Based on 1) beam size then length over 15' and then the items below the Main piece. which all have unique values based on the beam size. I'm probably confusing myself. My first post although I've used a lot of the formulas on here

B_28

1​

MAIN

BEAM

Field Skewed connection

Skew connection

stiffeners

Moment Connection

Splice Welded

Splice bolted

Splice combination

w1793

1​

W

14 x 26

11'- 9 3/8

=1.5+3 rows below​

Beam size

Base unit

Length(1) Pieces

wt (max)

F/fsk

skc

stiff

MC

SPW

SPB

SPC

a3

1​

L

4 x 3 1/2 x 5/16

0'-10

0.25​

W 4-6

1.00​

0.15​

0.15​

(0.15)​

0.25​

0.50​

1.00​

1.25​

1.00​

a4

1​

L

4 x 3 1/2 x 5/16

0'-10

0.25​

W 8-10

1.25​

0.15​

30​

0.15​

0.18​

(0.15)​

0.30​

0.75​

1.25​

1.50​

1.25​

em1

2​

PL

3/4 x 12

1'- 6

0.8​

W 12-14

1.50​

0.25​

38​

0.20​

0.21​

(0.15)​

0.40​

1.00​

1.50​

1.75​

1.50​

3​

BOLT

3/4" Dia.

0'- 2

W 16-18

1.75​

0.25​

50​

0.20​

0.24​

(0.20)​

0.50​

1.00​

1.50​

2.00​

1.75​

6​

BOLT

3/4" Dia.

0'- 2

W21

2.00​

0.30​

57​

0.25​

0.27​

(0.20)​

1.00​

1.25​

1.75​

2.75​

2.25​

B_29

1​

MAIN

BEAM

This will be different based on chart to the right

W24

2.25​

0.30​

62​

0.40​

0.30​

(0.20)​

1.00​

2.00​

2.50​

4.00​

3.50​

w1336

1​

W

18 x 65

28'- 8 1/4

=1.75+1 row below​

W27

2.75​

0.40​

94​

0.40​

0.33​

(0.20)​

1.20​

2.25​

2.75​

4.10​

3.75​

p484

1​

PL

3/8 x 5

1'- 2 1/2

1​

W30

3.50​

0.40​

132​

0.50​

0.36​

(0.25)​

1.30​

2.50​

3.00​

4.20​

4.25​

10​

BOLT

7/8" Dia.

0'- 2 1/4

W33

4.25​

0.50​

152​

0.50​

0.39​

(0.25)​

1.40​

3.00​

3.50​

4.30​

4.50​

B_32

1​

MAIN

BEAM

W36

5.00​

0.50​

210​

0.50​

0.42​

(0.30)​

1.50​

3.50​

4.00​

4.50​

4.50​

w2095

1​

W

18 x 35

28'- 9 1/16

=1.75+ no rows below but the length is over 15' so add.25

3​

BOLT

3/4" Dia.

0'- 1 3/4

B_33

1​

MAIN

BEAM

w2129

1​

W

18 x 35

29'- 3

p459

1​

PL

3/8 x 5 1/2

0'- 9

7​

BOLT

3/4" Dia.

0'- 1 3/4

B_34

1​

MAIN

BEAM

w2130

1​

W

18 x 35

6'- 9 3/4

a270

2​

L

4 x 3 x 5/16

1'- 2 1/2

p485

2​

PL

3/16 x 4 1/2

1'- 3

5​

BOLT

1" Dia.

0'- 2

10​

BOLT

3/4" Dia.

0'- 1 3/4

B_35

1​

MAIN

BEAM

w2121

1​

W

14 x 22

19'- 2 1/2

a3

1​

L

4 x 3 1/2 x 5/16

0'-10

a4

1​

L

4 x 3 1/2 x 5/16

0'-10

a53

2​

L

4 x 3 x 5/16

0'- 8 1/2

 

[PeteWright]

Well, I have absolutely no idea what you're trying to achieve. Your table doesn't have formulas as well.

One example tells more then thousand words, so maybe you could make a little table with minimum sample data and the desired result directly in Excel and post a screenshot.