multiple jobs excel input.xls

7/27/2019 Multiple Jobs Excel input.xls

http://slidepdf.com/reader/full/multiple-jobs-excel-inputxls 1/1626



Grid Data Grid Data

X axis Z Axis

No. of Grids 17 No. of Grids 10A 0 1 0

B 26.25 2.1 23.333

C 34.5 2.2 38.917

D 58 2.7 60.583

EE 63.583 3 65.75

G 81 4 79.083

H 103 5 81.917

I 125 6.1 89.917

J 143.25 6.3 97.75

K1 154.25 6.5 26.5

L 148

M 161.5

N 173.917

O 164.083

P 203.167

Q 203.916

R 219



46 63.58 0 97.75 Rectangular 3 2 Yes

47 81 0 65.75 Rectangular 2 3 Yes





52 81 0 97.75 Rectangular 3 2 Yes53 53.35 0 106 Rectangular 2 3 Yes

54 79.75 0 109.96 Rectangular 3 2 Yes

55 106.15 0 106 Rectangular 2 3 Yes


57 28.57 0 128.5 Rectangular 2 3 Yes

58 43.97 0 134.5 Rectangular 3 2 Yes

59 79.75 0 139.7 Rectangular 2 3 Yes

60 115.54 0 134.5 Rectangular 3 2 Yes



63 173.92 0 23.33 Rectangular 2 3 Yes

64 173.92 0 38.92 Rectangular 3 2 Yes

65 173.92 0 60.58 Rectangular 2 3 Yes

66 203.17 0 81.92 Rectangular 3 2 Yes

67 203.17 0 65.75 Rectangular 2 3 Yes



Height Depth (X) Width (Z)

2 2 2

3 2 2

1.5 1.5 1.5

2 2 2

3 2 22 3 3

2 2 2

3 2 2

1.5 1.5 1.5

2 2 2

3 2 2

2 3 3

2 2 2

3 2 2

1.5 1.5 1.5

2 2 2

3 2 2

2 3 3

2 2 2

3 2 2

1.5 1.5 1.5

2 2 2

3 2 2

2 3 3

3 2 2

2 3 33 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

2 3 3

3 2 2

Pedestal Dimensions



Load Number Load Title Load Type

1 DL Primary

2 LL Primary

3 WL Primary

4 EQ Primary

101 1.000 x DL Service

102 1.000 x DL+1.000 X LL Service103 1.000 x DL+0.750 X LL Service

104 1.000 x DL+1.000 X WL Service

105 1.000 x DL+0.700 X EL Service

106 1.000 x DL+0.750 X LL+0.750 X WL Service

107 1.000 x DL+0.750 X LL+0.525 X EL Service

108 1.400 x DL Ultimate

109 1.200 x DL+1.600 X LL Ultimate

110 1.200 x DL+1.000 X LL Ultimate

111 1.200 x DL+0.800 X WL Ultimate

112 1.200 x DL+1.000 X LL+1.600 X WL Ultimate

113 1.200 x DL+1.000 X LL+1.000 X EL Ultimate

114 1.200 x DL+1.600 X WL Ultimate

115 1.200 x DL+1.000 X EL Ultimate



Support List

Assigned Load / Load

Combination List

17 No. Of Loads 20

1 101

2 102

3 103

4 104

5 105

6 106

7 107

8 108

9 109

10 110

11 111

12 112

12 113

14 114

15 115

16 116

17 117

118

119

120



Job Title

Combined Footing

No of

Supports

Design Code

US

Concrete and Rebar Value Unit

Unit Weight Of Concrete 150 lb/ft3

Minimum bar spacing 2 in

Maximum bar spacing 9 kip/in3

Strength of concrete 4 ksi

Yield strength of steel 60 ksi

Minimum bar size 3

Maximum bar size 14

Set as Default No

Cover and Soil Value Unit

Soil Type

Bottom Clear Cover 2 in

Unit weight of Soil 110 lb/ft3

Soil bearing capacity 90 kN/m2

Depth of Soil above footing 0 in

Type of Depth

Surcharge for loading 0 ksi

Depth of Water Table 120 in

Cohesion 0 kip/ft2

Undrained Shear Strength 0 N/mm2

Set as Default No

Footing Geometry Value Unit

Design Type

Input the soil depth

Drained Condition

Set Dimension



Fixed Left Overhang

Fixed Right Overhang

Fixed Width

Minimum Left Over Hang Depth 40 in

Minimum Right Over Hang Depth 40 in

Minimum Width 22 in

Minimum Thickness 24 in

Maximum Length 300 in

Maximum Width 80 in

Maximum Thickness 48 in

Length Increment 2 in

Thickness Increment 2 in

Set as Default No

Sliding and Overturning Value

Coefficient of friction 0.5

Factor of safety against sliding 1

Factor of safety against overturning 1

Yes

Yes

No



Support List


Combination List

17 No. Of Loads 20

1 101

2 102

3 103

4 104

5 105

6 106

7 107

8 108

9 109

10 110

11 111

12 112

12 113

14 114

15 115

16 116

17 117

118

119

120



Job Title

Raft Design

No of

Supports

Design Code

US

Design Parameters Value Unit

f c 4 ksi

f y 60 ksi

Mat Bottom Cover 3 in

Mat Top Cover 3 in

Maximum Bar Spacing 3 in

Minimum Bar Spacing 12 in

Consider Wood and Armer Moment No -

Ignore check for Minimum Reinforcement No -



Support List


Combination List

17 No. Of Loads 20

No of

Beams 8

1 101Unit ft

2 102 Node A Node B Depth Width

3 103 1 2 2 1

4 104 1 4 2 1

5 105 4 5 2 1

6 106 2 5 2 1

7 107 5 6 2 1

8 108 2 3 2 1

9 109 3 6 2 1

10 110 2 6 2 1

11 111

12 112

13 113

14 114

15 115

16 116

17 117

118

119

120

Physical Beam Table



No. Of

Vertices 4

Boundary

Name

Analysis

Thickness

Design

Thickness

Unit ft Unit ft Unit

X Y Z 2 2 Soil Spring

10 0 2

10 0 80

55 0 80

55 0 2

Meshing Region Slab Design Thickness Subg

B1



No. Of

Piles 10

Analysis

Thickness

Design

Thicknes Unit ft

kip/in2/in Pile X Y Z

Yes 0.305 20 0 5

30 0 10

40 0 15

50 0 20

20 0 25

30 0 30

40 0 35

50 0 40

20 0 42

20 0 70

ade Modulus Pile Position table



Job Title

Pile Cap Job

No of

Supports

Design Code

British

Design Parameters Value Unit

Strength of concrete 4 ksi

Unit weight of concrete 160 lb/ft3

Yield strength of steel 60 ksi

Side cover 2 in

Bottom cover 2 in

Pile in pile cap 2 in

Initial thickness 12 in

Minimum bar size 3

Maximum bar size 18

Set as Default No



Support List


Combination List

17 No. Of Loads 20

1 101

2 102

3 103

4 104

5 105

6 106

7 107

8 108

9 109

10 110

11 111

12 112

12 113

14 114

15 115

16 116

17 117

118

119

120

multiple jobs excel input.xls

Documents