Question

the excavation volume for problem 3 using in cubic yards the the excavation volume for Problem 3 using the modified-average-end method 6. footing (26'x 16' x8) below supports a 2 x2 column of height 12, determine the volume of backfill that needs to be placed after the footing has been constructed. After backfilling operation is finished how much excavated soil may remain to be exported ? Shrinkage factor is 5% and the swelling factor is 30% for the excavated soil A truckload sol wil have 20 yd Determine the excavation volume for the pit below using the Cross-Sectional Method with the help of the Grid. If the capacity. How many truck loads are needed to remove the excess soil from the site? 50 IOİO 8 50

Answer 1

problem 6 is solved in excel clearly. but all the formulas used are also shown in the screen shots.

you can easily understand with out any problem.

Home Insert Page Layout Formulas Data Review View Σ AutoSum =1,ー ーー ヨWrap Text 'll, AA | General Copy Fil- Paste B I Li-Q a-쇼 % , 'i e Conditional Format Cell Insert Delete Format Formatting as Table Styles Fort & Select Sort &Find & #ミ涅涅 S Merge & Center 2 Clear, Clear, Filter. Select Number Cells Clipboard Alignment Styles Editing L2 左| Fort Size Change the font size 27 ft31 yd 2 Foundation Dimensio Column Dimensions 2 feet 26 feet side 1 3 Length 4 Breadth 16 feet Side 2 2 feet Volume of soil remained after swelling for exporting, x150.0195 yd 5 Thickness 8 feet 12 feet Height 20 yd Load carrying capacity of 1 truck- 6 7. Total Depth of excavation = 8417- 20 feet Number of truck loads rewuired Vx 207.500975 9 Volume of excavation, w,-26' x 16' x 12.67' = 8320 ft e 8 truck loads 10 Volume of footing, V 26' x 16' x 8" 3328 ft 11 | Volume of column, Vc- 2' x 2' × 12" 48 ft 12 3 Volume of backfill, VV.-V-V 4944ft 14 Shrinkage factor, S 5% 15 Volume of backfill required after shrinking, Vo,reV1-S)5204.2105 ft 16 17 Volume of soll remained, V.-Ve - Vare3115.789 ft 18 Swelling or Bulking factor, B- 3096 19 Volume of soil remained after swelling for exporting, VV, x (1+B)-4050.526 ft Sheet2 Sheet3 11 1 ト 커 Sheet1 Sheet2·Sheet3 12:49 PM 419/05/2019

Shrinkoge Vol ex avated- Vol. Compaded Vol excauated Ve -Ve Ve Ve Ne Volume of backf" Required : l-S Losse volum Excande l n tar Ex cavated Ve Volume to be exported) Vume remalrig o ume

Home Insert Page Layout Formulas Data Review View Σ AutoSum At A = = = 9-1 ll Wrap Text General Copy Fill Past e J Format Painter B 1 표 ·▲. ===- 组Merge & Center, s-% ,s a Conditional asoma. styles , inst Delete Format Sort & Filter. Find & ロー Clear, Select Cells Clipboard Alignment Styles Editing A12 2 Foundation Dimensi Column Dimensions feet 3 Length feet Side 1 26 With 4 Breadth feet Side 2 feet 16 Height 5 Thickness feet feet 12 Formulas 6 7 Total Depth of excava 8'+12' 20 feet 26' x 16' x 12.67 Volume of excavation, V.- ft2 10 Volume offooting, V, 26' x 16' x 8"- -B3 B4 B5 2x2x12"= Volume of column, V- 12 Volume of backfill, Vb Shrinkage factor, S 13 #F9-F10-F11 14 0.05 15 Volume of backfill required after shrinking, Vb,re F13/(1-D14) 16 17 Volume of soil remained, V -F9-G15 e b,req Swelling or Bulking factor, B- 0.3 18 v, x (1+8) = F17*(1+D18) 19 Volume of soil remained after swelling for exporting, Vx 21 Sheet2· Sheet3 1252 PM