Complete the spreadsheat, by calculating the amount of cut, fill, and either excess or shortage of material with totals shown at the bottom

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

 Complete the spreadsheat, by calculating the amount of cut, fill, and either excess or shortage of material with totals shown at the bottom.

Station
1A
1B
1C
1D
1E
1F
1G
2A
2B
2C
2D
2E
2F
2G
3A
3B
3C
3D
3E
3F
3G
4A
4B
4C
4D
4E
4F
4G
5A
5B
5C
5D
5E
5F
5G
Mass Excavation Calculations by the Grid Method (Grid X
New
Quad Area
Depth Cut
Depth Fill
Frequency
Elevation
Constant
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
100'
Existing
Elevation
101
101.9
1012
100
100.9
101
100
99.7
1012
1000
100
101
100
99.7
100
201
101
0
976
102
99.8
973
100
1023
99.7
99.7
0
101
101
1000
99.7
100
100
99.7
100
1
1.9
0
0
0.9
1
0
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
912
0
0
0
0
0
912
900
0
0
0
0
0
101
0
0
876
2
0
이
0
923
0
0
0
0
0
900
0
0
0
0
1100FT²
1100FT
1/100FT²
1/100FT²
1100FT²
1100FT
1/100FT
1/100FT
1/100FT²
1100FT
1/100FT
1/100FT
1/100FT
1/100FT²
1100FT
1100FT²
1100FT
1100FT
1/100FT²
1100FT²
1100FT
1100FT²
1/100FT²
1100FT
1100FT
1100FT
1100FT²
1/100FT²
1100FT²
1100FT
1100FT
1/100FT
1/100FT²
1100FT²
100FT
Totals
Totals
Volume Cut Voulme Fill
100FT^3
190FT^3
90FT^3
100FT^3
cu ft FT³
0
cut
0
cu yd YD³
91200FT^3
91200FT^3
cu ft FT³
0
cu yd YD³
fill
Transcribed Image Text:Station 1A 1B 1C 1D 1E 1F 1G 2A 2B 2C 2D 2E 2F 2G 3A 3B 3C 3D 3E 3F 3G 4A 4B 4C 4D 4E 4F 4G 5A 5B 5C 5D 5E 5F 5G Mass Excavation Calculations by the Grid Method (Grid X New Quad Area Depth Cut Depth Fill Frequency Elevation Constant 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' 100' Existing Elevation 101 101.9 1012 100 100.9 101 100 99.7 1012 1000 100 101 100 99.7 100 201 101 0 976 102 99.8 973 100 1023 99.7 99.7 0 101 101 1000 99.7 100 100 99.7 100 1 1.9 0 0 0.9 1 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 912 0 0 0 0 0 912 900 0 0 0 0 0 101 0 0 876 2 0 이 0 923 0 0 0 0 0 900 0 0 0 0 1100FT² 1100FT 1/100FT² 1/100FT² 1100FT² 1100FT 1/100FT 1/100FT 1/100FT² 1100FT 1/100FT 1/100FT 1/100FT 1/100FT² 1100FT 1100FT² 1100FT 1100FT 1/100FT² 1100FT² 1100FT 1100FT² 1/100FT² 1100FT 1100FT 1100FT 1100FT² 1/100FT² 1100FT² 1100FT 1100FT 1/100FT 1/100FT² 1100FT² 100FT Totals Totals Volume Cut Voulme Fill 100FT^3 190FT^3 90FT^3 100FT^3 cu ft FT³ 0 cut 0 cu yd YD³ 91200FT^3 91200FT^3 cu ft FT³ 0 cu yd YD³ fill
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Lateral earth pressure distribution against retaining walls
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning