Sem título

Página 1

Nome: Gabriel Cavalli de SouzaNUSP 9839381Tabela 2: XTabela 3: III

Grupo 13 Componente 1FC1.15

Estacas Inteiras (módulos de 20m)Volumes Geométricos (m³)Volume HomogêneoDiagrama de Massas (m³)Volume Acumulado

Escavação (+)Aterro(-)

Aterro x FC (-)

Escavação(+)Aterro x FC (-)

10150800=C6*C2=(G6-H6)0920

101601270=C7*C2=(G7-H7)0=H6+D7

101702400=C8*1.15=(G8-H8)0=H7+D8

101803280=C9*1.15=(G9-H9)0=H8+D9

101904560=C10*1.15=(G10-H10)0=H9+D10

102005640=C11*1.15=(G11-H11)0=H10+D11

102107890=C12*1.15=(G12-H12)0=H11+D12

102207560=C13*1.15=(G13-H13)0=H12+D13

102309870=C14*1.15=(G14-H14)0=H13+D14

1024010240=C15*1.15=(G15-H15)0=H14+D15

102509450=C16*1.15=(G16-H16)0=H15+D16

102608750=C17*1.15=(G17-H17)0=H16+D17

102707980=C18*1.15=(G18-H18)0=H17+D18

102806450=C19*1.15=(G19-H19)0=H18+D19

102905640=C20*1.15=(G20-H20)0=H19+D20

103005200=C21*1.15=(G21-H21)0=H20+D21

103104630=C22*1.15=(G22-H22)0=H21+D22

103203120=C23*1.15=(G23-H23)500=H22+D23

1033840910=C24*1.15=(G24-H24)=G23+B24=H23+D24

103423000=C25*1.15=(G25-H25)=G24+B25=H24+D25

103535400=C26*1.15=(G26-H26)=G25+B26=H25+D26

103656200=C27*1.15=(G27-H27)=G26+B27=H26+D27

103761300=C28*1.15=(G28-H28)=G27+B28=H27+D28

103868400=C29*1.15=(G29-H29)=G28+B29=H28+D29

103985300=C30*1.15=(G30-H30)=G29+B30=H29+D30

1040113400=C31*1.15=(G31-H31)=G30+B31=H30+D31

1041115200=C32*1.15=(G32-H32)=G31+B32=H31+D32

104299100=C33*1.15=(G33-H33)=G32+B33=H32+D33

104383200=C34*1.15=(G34-H34)=G33+B34=H33+D34

104463500=C35*1.15=(G35-H35)=G34+B35=H34+D35

104545200=C36*1.15=(G36-H36)=G35+B36=H35+D36

104623100=C37*1.15=(G37-H37)=G36+B37=H36+D37

104723000=C38*1.15=(G38-H38)=G37+B38=H37+D38

10480200=C39*1.15=(G39-H39)=G38+B39=H38+D39

104901200=C40*1.15=(G40-H40)=G39+B40=H39+D40

105002220=C41*1.15=(G41-H41)=G40+B41=H40+D41

105104520=C42*1.15=(G42-H42)=G41+B42=H41+D42

105204560=C43*1.15=(G43-H43)=G42+B43=H42+D43

105307840=C44*1.15=(G44-H44)=G43+B44=H43+D44

105409450=C45*1.15=(G45-H45)=G44+B45=H44+D45

1055010360=C46*1.15=(G46-H46)=G45+B46=H45+D46

1056012450=C47*1.15=(G47-H47)=G46+B47=H46+D47

1057010940=C48*1.15=(G48-H48)=G47+B48=H47+D48

105808990=C49*1.15=(G49-H49)=G48+B49=H48+D49

105906520=C50*1.15=(G50-H50)=G49+B50=H49+D50

106005420=C51*1.15=(G51-H51)=G50+B51=H50+D51

106103420=C52*1.15=(G52-H52)=G51+B52=H51+D52

106201200=C53*1.15=(G53-H53)=G52+B53=H52+D53

10630450=C54*1.15=(G54-H54)=G53+B54=H53+D54

106412000=C55*1.15=(G55-H55)=G54+B55=H54+D55

106525400=C56*1.15=(G56-H56)=G55+B56=H55+D56

106636500=C57*1.15=(G57-H57)=G56+B57=H56+D57

106764500=C58*1.15=(G58-H58)=G57+B58=H57+D58

106878200=C59*1.15=(G59-H59)=G58+B59=H58+D59

106989400=C60*1.15=(G60-H60)=G59+B60=H59+D60

107098600=C61*1.15=(G61-H61)=G60+B61=H60+D61

1071103200=C62*1.15=(G62-H62)=G61+B62=H61+D62

1072124500=C63*1.15=(G63-H63)=G62+B63=H62+D63

1073136500=C64*1.15=(G64-H64)=G63+B64=H63+D64

1074124500=C65*1.15=(G65-H65)=G64+B65=H64+D65

1075118600=C66*1.15=(G66-H66)=G65+B66=H65+D66

1076108700=C67*1.15=(G67-H67)=G66+B67=H66+D67

1077109800=C68*1.15=(G68-H68)=G67+B68=H67+D68

107891300=C69*1.15=(G69-H69)=G68+B69=H68+D69

107987500=C70*1.15=(G70-H70)=G69+B70=H69+D70

108065200=C71*1.15=(G71-H71)=G70+B71=H70+D71

108175100=C72*1.15=(G72-H72)=G71+B72=H71+D72

108269500=C73*1.15=(G73-H73)=G72+B73=H72+D73

108362100=C74*1.15=(G74-H74)=G73+B74=H73+D74

108451200=C75*1.15=(G75-H75)=G74+B75=H74+D75

108542100=C76*1.15=(G76-H76)=G75+B76=H75+D76

108632100=C77*1.15=(G77-H77)=G76+B77=H76+D77

108724000=C78*1.15=(G78-H78)=G77+B78=H77+D78

108813000=C79*1.15=(G79-H79)=G78+B79=H78+D79

10899000=C80*1.15=(G80-H80)=G79+B80=H79+D80

Total =SUM(E6:E80)=SUM(G6:G80)=SUM(H6:H80)

2)

MT1 (km)=-SUM(E6:E34)*0.02

dm1 (km)=B84/-E23

MT2(km)=SUM(E35:E80)

dm2(km)=B86/(E46+E66)

3)

=SUM(B35:B80)=SUM(D35:D80)

Volume de bota-fora (m³)=B90-C90