plano.xlsx

28
Punto X COTA Y i% Punto A 4750 A 1 500.0 4700 -50 0 50 1 2 714.3 4750 50 7 50 2 3 500.0 4750 0 0 0 3 4 714.3 4800 50 7 50 4 5 500.0 4800 0 0 0 5 6 714.3 4750 -50 -7 50 6 7 714.3 4700 -50 -7 50 7 8 714.3 4650 -50 -7 50 8 9 500.0 4650 0 0 0 9 10 714.3 4600 -50 -7 50 10 11 714.3 4550 -50 -7 50 11 12 714.3 4500 -50 -7 50 12 13 714.3 4450 -50 -7 50 13 14 500.0 4400 0 7 0 14 15 714.3 4350 -50 -7 50 15 16 714.3 4300 -50 -7 50 16 17 714.3 4250 -50 -7 50 17 18 714.3 4200 -50 -7 50 18 19 714.3 4150 -50 -7 50 19 20 714.3 4100 -50 -7 50 20 21 714.3 4050 -50 -7 50 21 22 714.3 4000 -50 -7 50 22 23 714.3 3950 -50 -7 50 23 24 500.0 3900 0 7 0 24 25 714.3 3850 -50 -7 50 25 26 714.3 3800 -50 -7 50 26 27 714.3 3750 -50 -7 50 27 28 714.3 3700 -50 -7 50 28 29 714.3 3650 -50 -7 50 29 30 714.3 3600 -50 -7 50 30 31 714.3 3550 -50 -7 50 31 32 714.3 3500 -50 -7 50 32 33 714.3 3450 -50 -7 50 33 34 714.3 3400 -50 -7 50 34 35 500.0 3350 -50 -7 50 35 36 714.3 3300 -50 -7 50 36 37 714.3 3250 -50 -7 50 37 38 714.3 3200 -50 -7 50 38 39 714.3 3250 50 7 50 39 40 500.0 3250 0 0 0 40 41 500.0 3250 0 0 0 41 42 833.3 3200 -50 -6 50 42 43 833.3 3150 -50 -6 50 43 44 714.3 3100 -50 -7 50 44 45 714.3 3050 -50 -7 50 45

Upload: pedrito-suarez

Post on 01-Feb-2016

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: PLANO.xlsx

Punto X COTA Y i% Punto X acum

A 4750 A 01 500.0 4700 -50 0 50 1 500.002 714.3 4750 50 7 50 2 1214.293 500.0 4750 0 0 0 3 1714.294 714.3 4800 50 7 50 4 2428.575 500.0 4800 0 0 0 5 2928.576 714.3 4750 -50 -7 50 6 3642.867 714.3 4700 -50 -7 50 7 4357.148 714.3 4650 -50 -7 50 8 5071.439 500.0 4650 0 0 0 9 5571.4310 714.3 4600 -50 -7 50 10 6285.7111 714.3 4550 -50 -7 50 11 7000.0012 714.3 4500 -50 -7 50 12 7714.2913 714.3 4450 -50 -7 50 13 8428.5714 500.0 4400 0 7 0 14 8928.5715 714.3 4350 -50 -7 50 15 9642.8616 714.3 4300 -50 -7 50 16 10357.1417 714.3 4250 -50 -7 50 17 11071.4318 714.3 4200 -50 -7 50 18 11785.7119 714.3 4150 -50 -7 50 19 12500.0020 714.3 4100 -50 -7 50 20 13214.2921 714.3 4050 -50 -7 50 21 13928.5722 714.3 4000 -50 -7 50 22 14642.8623 714.3 3950 -50 -7 50 23 15357.1424 500.0 3900 0 7 0 24 15857.1425 714.3 3850 -50 -7 50 25 16571.4326 714.3 3800 -50 -7 50 26 17285.7127 714.3 3750 -50 -7 50 27 18000.0028 714.3 3700 -50 -7 50 28 18714.2929 714.3 3650 -50 -7 50 29 19428.5730 714.3 3600 -50 -7 50 30 20142.8631 714.3 3550 -50 -7 50 31 20857.1432 714.3 3500 -50 -7 50 32 21571.4333 714.3 3450 -50 -7 50 33 22285.7134 714.3 3400 -50 -7 50 34 23000.0035 500.0 3350 -50 -7 50 35 23500.0036 714.3 3300 -50 -7 50 36 24214.2937 714.3 3250 -50 -7 50 37 24928.5738 714.3 3200 -50 -7 50 38 25642.8639 714.3 3250 50 7 50 39 26357.1440 500.0 3250 0 0 0 40 26857.14

41 500.0 3250 0 0 0 41 27357.14

42 833.3 3200 -50 -6 50 42 28190.4843 833.3 3150 -50 -6 50 43 29023.8144 714.3 3100 -50 -7 50 44 29738.1045 714.3 3050 -50 -7 50 45 30452.38

Page 2: PLANO.xlsx

46 714.3 3000 -50 -7 50 46 31166.6747 714.3 2950 -50 -7 50 47 31880.95

48 1428.6 2850 -100 -7 100 48 33309.52

49 714.3 2800 -50 -7 50 49 34023.81

50 714.3 2750 -50 -7 50 50 34738.10

51 714.3 2700 -50 -7 50 51 35452.38

52 714.3 2650 -50 -7 50 52 36166.67

53 714.3 2600 -50 -7 50 53 36880.95

54 714.3 2550 -50 -7 50 54 37595.2455 714.3 2500 -50 -7 50 55 38309.5256 714.3 2450 -50 -7 50 56 39023.8157 500.0 2400 0 7 0 57 39523.8158 714.3 2350 -50 -7 50 58 40238.1059 714.3 2300 -50 -7 50 59 40952.3860 714.3 2250 -50 -7 50 60 41666.6761 714.3 2200 -50 -7 50 61 42380.9562 714.3 2150 -50 -7 50 62 43095.2463 714.3 2100 -50 -7 50 63 43809.5264 714.3 2050 -50 -7 50 64 44523.8165 714.3 2000 -50 -7 50 65 45238.1066 714.3 1950 -50 -7 50 66 45952.3867 714.3 1900 -50 -7 50 67 46666.6768 500.0 1900 0 0 0 68 47166.6769 714.3 1950 50 7 50 69 47880.9570 714.3 2000 50 7 50 70 48595.2471 714.3 2050 50 7 50 71 49309.5272 714.3 2100 50 7 50 72 50023.8173 714.3 2150 50 7 50 73 50738.1074 714.3 2200 50 7 50 74 51452.3875 714.3 2250 50 7 50 75 52166.6776 714.3 2300 50 7 50 76 52880.9577 714.3 2350 50 7 50 77 53595.2478 714.3 2400 50 7 50 78 54309.5279 714.3 2450 50 7 50 79 55023.8180 714.3 2500 50 7 50 80 55738.1081 714.3 2550 50 7 50 81 56452.3882 714.3 2600 50 7 50 82 57166.6783 714.3 2650 50 7 50 83 57880.9584 714.3 2700 50 7 50 84 58595.2485 714.3 2750 50 7 50 85 59309.5286 714.3 2800 50 7 50 86 60023.8187 714.3 2850 50 7 50 87 60738.1088 714.3 2800 -50 -7 50 88 61452.3889 714.3 2750 -50 -7 50 89 62166.6790 714.3 2800 50 7 50 90 62880.9591 714.3 2850 50 7 50 91 63595.2492 500.0 2850 0 0 0 92 64095.24

Page 3: PLANO.xlsx

93 1428.6 2750 -100 -7 100 93 65523.8194 500.0 2800 0 7 0 94 66023.8195 714.3 2850 50 7 50 95 66738.1096 714.3 2900 50 7 50 96 67452.3897 714.3 2950 50 7 50 97 68166.6798 714.3 3000 50 7 50 98 68880.9599 714.3 3050 50 7 50 99 69595.24100 714.3 3100 50 7 50 100 70309.52101 500.0 3150 50 7 50 101 70809.52102 714.3 3200 50 7 50 102 71523.81103 714.3 3250 50 7 50 103 72238.10104 714.3 3300 50 7 50 104 72952.38105 714.3 3350 50 7 50 105 73666.67106 500.0 3400 0 7 0 106 74166.67107 714.3 3450 50 7 50 107 74880.95108 714.3 3400 -50 -7 50 108 75595.24109 714.3 3350 -50 -7 50 109 76309.52110 714.3 3300 -50 -7 50 110 77023.81111 1428.6 3200 -100 -7 100 111 78452.38112 714.3 3150 -50 -7 50 112 79166.67113 714.3 3100 -50 -7 50 113 79880.95114 714.3 3050 -50 -7 50 114 80595.24115 714.3 3000 -50 -7 50 115 81309.52116 500.0 2950 0 7 0 116 81809.52117 500.0 2950 0 0 0 117 82309.52118 714.3 2900 -50 -7 50 118 83023.81119 714.3 2950 50 7 50 119 83738.10120 714.3 3000 50 7 50 120 84452.38121 714.3 2950 -50 -7 50 121 85166.67122 714.3 3000 50 7 50 122 85880.95123 714.3 3050 50 7 50 123 86595.24124 500.0 3100 0 7 0 124 87095.24125 714.3 3150 50 7 50 125 87809.52126 714.3 3200 50 7 50 126 88523.81127 714.3 3250 50 7 50 127 89238.10128 714.3 3300 50 7 50 127 89952.38129 714.3 3350 50 7 50 128 90666.67130 714.3 3400 50 7 50 129 91380.95131 714.3 3450 50 7 50 130 92095.24132 714.3 3500 50 7 50 131 92809.52133 714.3 3550 50 7 50 132 93523.81134 714.3 3600 50 7 50 133 94238.10135 714.3 3650 50 7 50 134 94952.38136 714.3 3700 50 7 50 135 95666.67137 714.3 3750 50 7 50 136 96380.95138 500.0 3750 0 0 0 137 96880.95139 714.3 3800 50 7 50 138 97595.24140 714.3 3850 50 7 50 139 98309.52

Page 4: PLANO.xlsx

141 714.3 3900 50 7 50 140 99023.81142 714.3 3950 50 7 50 141 99738.10143 714.3 4000 50 7 50 142 100452.38144 714.3 4050 50 7 50 143 101166.67145 714.3 4100 50 7 50 144 101880.95146 714.3 4150 50 7 50 145 102595.24147 714.3 4200 50 7 50 146 103309.52148 500.0 4200 0 0 0 147 103809.52149 714.3 4150 -50 -7 50 148 104523.81150 714.3 4100 -50 -7 50 149 105238.10151 714.3 4050 -50 -7 50 150 105952.38152 714.3 4000 -50 -7 50 151 106666.67153 714.3 3950 -50 -7 50 152 107380.95154 1428.6 4050 100 7 100 153 108809.52155 1428.6 4150 100 7 100 154 110238.10156 714.3 4100 -50 -7 50 155 110952.38157 714.3 4050 -50 -7 50 156 111666.67158 714.3 4000 -50 -7 50 157 112380.95159 714.3 3950 -50 -7 50 158 113095.24160 714.3 3900 -50 -7 50 159 113809.52161 714.3 3850 -50 -7 50 160 114523.81162 714.3 3800 -50 -7 50 161 115238.10163 714.3 3750 -50 -7 50 162 115952.38164 714.3 3700 -50 -7 50 163 116666.67165 714.3 3650 -50 -7 50 164 117380.95166 714.3 3600 -50 -7 50 165 118095.24167 500.0 3600 0 0 0 166 118595.24168 714.3 3550 -50 -7 50 167 119309.52169 714.3 3500 -50 -7 50 168 120023.81170 714.3 3450 -50 -7 50 169 120738.10171 714.3 3400 -50 -7 50 170 121452.38172 714.3 3350 -50 -7 50 171 122166.67173 714.3 3300 -50 -7 50 172 122880.95174 500.0 3300 0 0 0 173 123380.95175 714.3 3350 50 7 50 174 124095.24176 714.3 3400 50 7 50 175 124809.52177 714.3 3450 50 7 50 176 125523.81178 714.3 3500 50 7 50 177 126238.10179 714.3 3550 50 7 50 178 126952.38180 714.3 3600 50 7 50 179 127666.67181 714.3 3650 50 7 50 180 128380.95182 714.3 3700 50 7 50 181 129095.24183 714.3 3750 50 7 50 182 129809.52184 714.3 3800 50 7 50 183 130523.81185 714.3 3850 50 7 50 184 131238.10186 714.3 3900 50 7 50 185 131952.38187 714.3 3950 50 7 50 186 132666.67188 714.3 4000 50 7 50 187 133380.95

Page 5: PLANO.xlsx

189 500.0 4000 0 0 0 188 133880.95190 714.3 4050 50 7 50 189 134595.24191 714.3 4100 50 7 50 190 135309.52192 714.3 4150 50 7 50 191 136023.81193 714.3 4200 50 7 50 192 136738.10194 714.3 4250 50 7 50 193 137452.38195 714.3 4300 50 7 50 194 138166.67196 714.3 4350 50 7 50 195 138880.95197 714.3 4400 50 7 50 196 139595.24198 714.3 4450 50 7 50 197 140309.52199 714.3 4500 50 7 50 198 141023.81200 714.3 4550 50 7 50 199 141738.10201 714.3 4600 50 7 50 200 142452.38202 714.3 4650 50 7 50 201 143166.67203 714.3 4700 50 7 50 202 143880.95204 714.3 4650 -50 -7 50 203 144595.24205 714.3 4700 50 7 50 204 145309.52206 714.3 4750 50 7 50 205 146023.81207 500.0 4750 0 0 0 206 146523.81208 714.3 4700 -50 -7 50 207 147238.10209 714.3 4750 50 7 50 208 147952.38210 714.3 4700 -50 -7 50 209 148666.67211 714.3 4650 -50 -7 50 210 149380.95212 714.3 4600 -50 -7 50 211 150095.24213 714.3 4550 -50 -7 50 212 150809.52214 714.3 4500 -50 -7 50 213 151523.81215 714.3 4450 -50 -7 50 214 152238.10216 714.3 4400 -50 -7 50 215 152952.38217 714.3 4350 -50 -7 50 216 153666.67218 714.3 4300 -50 -7 50 217 154380.95219 714.3 4250 -50 -7 50 218 155095.24220 714.3 4200 -50 -7 50 219 155809.52221 714.3 4250 50 7 50 220 156523.81222 714.3 4200 -50 -7 50 221 157238.10223 714.3 4250 50 7 50 222 157952.38224 1428.6 4350 100 7 100 223 159380.95225 714.3 4400 50 7 50 224 160095.24226 714.3 4350 -50 -7 50 225 160809.52227 714.3 4300 -50 -7 50 226 161523.81228 714.3 4250 -50 -7 50 227 162238.10229 714.3 4200 -50 -7 50 228 162952.38230 500.0 4200 0 0 0 229 163452.38231 714.3 4250 50 7 50 230 164166.67232 714.3 4300 50 7 50 231 164880.95233 500.0 4300 0 0 0 232 165380.95234 714.3 4350 50 7 50 233 166095.24235 714.3 4300 -50 -7 50 234 166809.52236 714.3 4250 -50 -7 50 235 167523.81

Page 6: PLANO.xlsx

237 714.3 4200 -50 -7 50 236 168238.10238 714.3 4150 -50 -7 50 237 168952.38239 714.3 4200 50 7 50 238 169666.67240 500.0 4200 0 0 0 239 170166.67241 714.3 4150 -50 -7 50 240 170880.95242 714.3 4100 -50 -7 50 241 171595.24243 714.3 4050 -50 -7 50 242 172309.52244 714.3 4000 -50 -7 50 243 173023.81245 714.3 3950 -50 -7 50 244 173738.10246 714.3 3900 -50 -7 50 245 174452.38247 714.3 3850 -50 -7 50 246 175166.67248 714.3 3800 -50 -7 50 247 175880.95249 714.3 3750 -50 -7 50 248 176595.24250 714.3 3700 -50 -7 50 249 177309.52251 714.3 3650 -50 -7 50 250 178023.81252 714.3 3600 -50 -7 50 251 178738.10253 714.3 3550 -50 -7 50 252 179452.38254 714.3 3600 50 7 50 253 180166.67255 714.3 3650 50 7 50 254 180880.95256 714.3 3600 -50 -7 50 255 181595.24257 500.0 3600 0 0 0 256 182095.24258 714.3 3550 -50 -7 50 257 182809.52259 714.3 3500 -50 -7 50 258 183523.81260 714.3 3450 -50 -7 50 259 184238.10261 714.3 3400 -50 -7 50 260 184952.38262 500.0 3400 0 0 0 261 185452.38263 714.3 3350 -50 -7 50 262 186166.67264 714.3 3300 -50 -7 50 263 186880.95265 714.3 3250 -50 -7 50 264 187595.24266 500.0 3250 0 0 0 265 188095.24267 714.3 3300 50 7 50 266 188809.52268 714.3 3250 -50 -7 50 267 189523.81269 714.3 3200 -50 -7 50 268 190238.10270 714.3 3250 50 7 50 269 190952.38271 714.3 3300 50 7 50 270 191666.67272 714.3 3350 50 7 50 271 192380.95273 714.3 3300 -50 -7 50 272 193095.24274 1250.0 3350 50 4 50 273 194345.24275 1000.0 3300 -50 -5 50 274 195345.24276 714.3 3250 -50 -7 50 275 196059.52277 714.3 3200 -50 -7 50 276 196773.81278 500.0 3200 0 0 0 277 197273.81279 714.3 3150 -50 -7 50 278 197988.10280 714.3 3100 -50 -7 50 279 198702.38281 714.3 3150 50 7 50 280 199416.67282 1666.7 3100 -50 -3 50 281 201083.33283 1000.0 3050 -50 -5 50 282 202083.33284 833.3 3000 -50 -6 50 283 202916.67

Page 7: PLANO.xlsx

285 500.0 3000 0 0 0 284 203416.67286 714.3 3050 50 7 50 285 204130.95287 714.3 3100 50 7 50 286 204845.24288 714.3 3150 50 7 50 287 205559.52289 714.3 3200 50 7 50 288 206273.81290 714.3 3250 50 7 50 289 206988.10291 714.3 3300 50 7 50 290 207702.38292 714.3 3250 -50 -7 50 291 208416.67293 500.0 3250 0 0 0 292 208916.67294 833.3 3300 50 6 50 293 209750.00295 1250.0 3250 -50 -4 50 294 211000.00296 500.0 3250 0 0 0 295 211500.00297 714.3 3300 50 7 50 296 212214.29298 714.3 3350 50 7 50 297 212928.57299 833.3 3400 50 6 50 298 213761.90300 714.3 3450 50 7 50 299 214476.19301 714.3 3400 -50 -7 50 300 215190.48302 714.3 3350 -50 -7 50 301 215904.76303 714.3 3300 -50 -7 50 302 216619.05304 1428.6 3200 -100 -7 100 303 218047.62305 714.3 3150 -50 -7 50 304 218761.90306 714.3 3100 -50 -7 50 305 219476.19307 714.3 3050 -50 -7 50 306 220190.48308 714.3 3100 50 7 50 307 220904.76309 714.3 3150 50 7 50 308 221619.05310 714.3 3100 -50 -7 50 309 222333.33310 500.0 3100 0 7 0 310 222833.33

Page 8: PLANO.xlsx

PROGRESIVA COTA

K0+000.00 4750K0+500.00 4700K1+214.29 4750K1+714.29 4750K2+428.57 4800K2+928.57 4800K3+642.86 4750K4+357.14 4700K5+071.43 4650K5+571.43 4650K6+285.71 4600K7+000.00 4550K7+714.29 4500K8+428.57 4450K8+928.57 4400K9+642.86 4350K10+357.14 4300K11+071.43 4250K11+785.71 4200K12+500.00 4150K13+214.29 4100K13+928.57 4050K14+642.86 4000K15+357.14 3950K15+857.14 3900K16+571.43 3850K17+285.71 3800K18+000.00 3750K18+714.29 3700K19+428.57 3650K20+142.86 3600K20+857.14 3550K21+571.43 3500K22+285.71 3450K23+000.00 3400K23+500.00 3350K24+214.29 3300K24+928.57 3250K25+642.86 3200K26+357.14 3250K26+857.14 3250

K27+357.14 3250K28+190.48 3200K29+023.81 3150K29+738.10 3100K30+452.38 3050

K0+000

.00

K10+00

0.00

K20+00

0.00

K30+00

0.00

K40+00

0.00

K50+00

0.00

K60+00

0.00

K70+00

0.00

K80+00

0.00

K90+00

0.00

K100

+000

.00

K110

+000

.00

K120

+000

.00

K130

+000

.00

K140

+000

.00

K150

+000

.00

K160

+000

.00

K170

+000

.001600

1700

1800

1900

2000

2100

2200

2300

2400

2500

2600

2700

2800

2900

3000

3100

3200

3300

3400

3500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

4600

4700

4800

4900

5000PERFIL LONGITUDINAL

Page 9: PLANO.xlsx

K31+166.67 3000K31+880.95 2950K33+309.52 2850K34+023.81 2800

K34+738.10 2750 METODO DE BRUCEK35+452.38 2700K36+166.67 2650K36+880.95 2600K37+595.24 2550 Xo = 723333.33K38+309.52 2500K39+023.81 2450K39+523.81 2400K40+238.10 2350K40+952.38 2300K41+666.67 2250K42+380.95 2200K43+095.24 2150K43+809.52 2100K44+523.81 2050K45+238.10 2000K45+952.38 1950K46+666.67 1900K47+166.67 1900K47+880.95 1950K48+595.24 2000K49+309.52 2050K50+023.81 2100K50+738.10 2150K51+452.38 2200K52+166.67 2250K52+880.95 2300K53+595.24 2350K54+309.52 2400K55+023.81 2450K55+738.10 2500K56+452.38 2550K57+166.67 2600K57+880.95 2650K58+595.24 2700K59+309.52 2750K60+023.81 2800K60+738.10 2850K61+452.38 2800K62+166.67 2750K62+880.95 2800K63+595.24 2850K64+095.24 2850

Xo = X + K∑y

K0+000

.00

K10+00

0.00

K20+00

0.00

K30+00

0.00

K40+00

0.00

K50+00

0.00

K60+00

0.00

K70+00

0.00

K80+00

0.00

K90+00

0.00

K100

+000

.00

K110

+000

.00

K120

+000

.00

K130

+000

.00

K140

+000

.00

K150

+000

.00

K160

+000

.00

K170

+000

.001600

1700

1800

1900

2000

2100

2200

2300

2400

2500

2600

2700

2800

2900

3000

3100

3200

3300

3400

3500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

4600

4700

4800

4900

5000PERFIL LONGITUDINAL

Page 10: PLANO.xlsx

K65+523.81 2750K66+023.81 2800K66+738.10 2850K67+452.38 2900K68+166.67 2950K68+880.95 3000K69+595.24 3050K70+309.52 3100K70+809.52 3150K71+523.81 3200K72+238.10 3250K72+952.38 3300K73+666.67 3350K74+166.67 3400K74+880.95 3450K75+595.24 3400K76+309.52 3350K77+023.81 3300K78+452.38 3200K79+166.67 3150K79+880.95 3100K80+595.24 3050K81+309.52 3000K81+809.52 2950K82+309.52 2950K83+023.81 2900K83+738.10 2950K84+452.38 3000K85+166.67 2950K85+880.95 3000K86+595.24 3050K87+095.24 3100K87+809.52 3150K88+523.81 3200K89+238.10 3250 TOTAL ∑YK89+952.38 3300K90+666.67 3350K91+380.95 3400K92+095.24 3450K92+809.52 3500K93+523.81 3550K94+238.10 3600K94+952.38 3650K95+666.67 3700K96+380.95 3750K96+880.95 3750K97+595.24 3800K98+309.52 3850

TOTAL ∑X

Page 11: PLANO.xlsx

K99+023.81 3900K99+738.10 3950K100+452.38 4000K101+166.67 4050K101+880.95 4100K102+595.24 4150K103+309.52 4200K103+809.52 4200K104+523.81 4150K105+238.10 4100K105+952.38 4050K106+666.67 4000K107+380.95 3950K108+809.52 4050K110+238.10 4150K110+952.38 4100K111+666.67 4050K112+380.95 4000K113+095.24 3950K113+809.52 3900K114+523.81 3850K115+238.10 3800K115+952.38 3750K116+666.67 3700K117+380.95 3650K118+095.24 3600K118+595.24 3600K119+309.52 3550K120+023.81 3500K120+738.10 3450K121+452.38 3400K122+166.67 3350K122+880.95 3300K123+380.95 3300K124+095.24 3350K124+809.52 3400K125+523.81 3450K126+238.10 3500K126+952.38 3550K127+666.67 3600K128+380.95 3650K129+095.24 3700K129+809.52 3750K130+523.81 3800K131+238.10 3850K131+952.38 3900K132+666.67 3950K133+380.95 4000

Page 12: PLANO.xlsx

K133+880.95 4000K134+595.24 4050K135+309.52 4100K136+023.81 4150K136+738.10 4200K137+452.38 4250K138+166.67 4300K138+880.95 4350K139+595.24 4400K140+309.52 4450K141+023.81 4500K141+738.10 4550K142+452.38 4600K143+166.67 4650K143+880.95 4700K144+595.24 4650K145+309.52 4700K146+023.81 4750K146+523.81 4750K147+238.10 4700K147+952.38 4750K148+666.67 4700K149+380.95 4650K150+095.24 4600K150+809.52 4550K151+523.81 4500K152+238.10 4450K152+952.38 4400K153+666.67 4350K154+380.95 4300K155+095.24 4250K155+809.52 4200K156+523.81 4250K157+238.10 4200K157+952.38 4250K159+380.95 4350K160+095.24 4400K160+809.52 4350K161+523.81 4300K162+238.10 4250K162+952.38 4200K163+452.38 4200K164+166.67 4250K164+880.95 4300K165+380.95 4300K166+095.24 4350K166+809.52 4300K167+523.81 4250

Page 13: PLANO.xlsx

K168+238.10 4200K168+952.38 4150K169+666.67 4200K170+166.67 4200K170+880.95 4150K171+595.24 4100K172+309.52 4050K173+023.81 4000K173+738.10 3950K174+452.38 3900K175+166.67 3850K175+880.95 3800K176+595.24 3750K177+309.52 3700K178+023.81 3650K178+738.10 3600K179+452.38 3550K180+166.67 3600K180+880.95 3650K181+595.24 3600K182+095.24 3600K182+809.52 3550K183+523.81 3500K184+238.10 3450K184+952.38 3400K185+452.38 3400K186+166.67 3350K186+880.95 3300K187+595.24 3250K188+095.24 3250K188+809.52 3300K189+523.81 3250K190+238.10 3200K190+952.38 3250K191+666.67 3300K192+380.95 3350K193+095.24 3300K194+345.24 3350K195+345.24 3300K196+059.52 3250K196+773.81 3200K197+273.81 3200K197+988.10 3150K198+702.38 3100K199+416.67 3150K201+083.33 3100K202+083.33 3050K202+916.67 3000

Page 14: PLANO.xlsx

K203+416.67 3000K204+130.95 3050K204+845.24 3100K205+559.52 3150K206+273.81 3200K206+988.10 3250K207+702.38 3300K208+416.67 3250K208+916.67 3250K209+750.00 3300K211+000.00 3250K211+500.00 3250K212+214.29 3300K212+928.57 3350K213+761.90 3400K214+476.19 3450K215+190.48 3400K215+904.76 3350K216+619.05 3300K218+047.62 3200K218+761.90 3150K219+476.19 3100K220+190.48 3050K220+904.76 3100K221+619.05 3150K222+333.33 3100K222+833.33 3100

Page 15: PLANO.xlsx

K0+000

.00

K10+00

0.00

K20+00

0.00

K30+00

0.00

K40+00

0.00

K50+00

0.00

K60+00

0.00

K70+00

0.00

K80+00

0.00

K90+00

0.00

K100

+000

.00

K110

+000

.00

K120

+000

.00

K130

+000

.00

K140

+000

.00

K150

+000

.00

K160

+000

.00

K170

+000

.001600

1700

1800

1900

2000

2100

2200

2300

2400

2500

2600

2700

2800

2900

3000

3100

3200

3300

3400

3500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

4600

4700

4800

4900

5000PERFIL LONGITUDINAL

Page 16: PLANO.xlsx

K0+000

.00

K10+00

0.00

K20+00

0.00

K30+00

0.00

K40+00

0.00

K50+00

0.00

K60+00

0.00

K70+00

0.00

K80+00

0.00

K90+00

0.00

K100

+000

.00

K110

+000

.00

K120

+000

.00

K130

+000

.00

K140

+000

.00

K150

+000

.00

K160

+000

.00

K170

+000

.001600

1700

1800

1900

2000

2100

2200

2300

2400

2500

2600

2700

2800

2900

3000

3100

3200

3300

3400

3500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

4600

4700

4800

4900

5000PERFIL LONGITUDINAL

Page 17: PLANO.xlsx

222833.3314300.00

Page 18: PLANO.xlsx

K0+000

.00

K10+00

0.00

K20+00

0.00

K30+00

0.00

K40+00

0.00

K50+00

0.00

K60+00

0.00

K70+00

0.00

K80+00

0.00

K90+00

0.00

K100

+000

.00

K110

+000

.00

K120

+000

.00

K130

+000

.00

K140

+000

.00

K150

+000

.00

K160

+000

.00

K170

+000

.001600

1700

1800

1900

2000

2100

2200

2300

2400

2500

2600

2700

2800

2900

3000

3100

3200

3300

3400

3500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

4600

4700

4800

4900

5000PERFIL LONGITUDINAL

Page 19: PLANO.xlsx

K0+000

.00

K10+00

0.00

K20+00

0.00

K30+00

0.00

K40+00

0.00

K50+00

0.00

K60+00

0.00

K70+00

0.00

K80+00

0.00

K90+00

0.00

K100

+000

.00

K110

+000

.00

K120

+000

.00

K130

+000

.00

K140

+000

.00

K150

+000

.00

K160

+000

.00

K170

+000

.001600

1700

1800

1900

2000

2100

2200

2300

2400

2500

2600

2700

2800

2900

3000

3100

3200

3300

3400

3500

3600

3700

3800

3900

4000

4100

4200

4300

4400

4500

4600

4700

4800

4900

5000PERFIL LONGITUDINAL

Page 20: PLANO.xlsx

rafaK0+000.00 4750K0+500.00 4700K1+214.29 4750K1+714.29 4750K2+428.57 4800K2+928.57 4800K3+642.86 4750K4+357.14 4700K5+071.43 4650K5+571.43 4650K6+285.71 4600K7+000.00 4550K7+714.29 4500K8+428.57 4450K8+928.57 4400K9+642.86 4350K10+357.14 4300K11+071.43 4250K11+785.71 4200K12+500.00 4150K13+214.29 4100K13+928.57 4050K14+642.86 4000K15+357.14 3950K15+857.14 3900K16+571.43 3850K17+285.71 3800K18+000.00 3750K18+714.29 3700K19+428.57 3650K20+142.86 3600K20+857.14 3550K21+571.43 3500K22+285.71 3450K23+000.00 3400K23+500.00 3350K24+214.29 3300K24+928.57 3250K25+642.86 3200K26+357.14 3250K26+857.14 3250K27+357.14 3250K28+190.48 3200K29+023.81 3150K29+738.10 3100K30+452.38 3050K31+166.67 3000

Page 21: PLANO.xlsx

K31+880.95 2950K33+309.52 2850K34+023.81 2800K34+738.10 2750K35+452.38 2700K36+166.67 2650K36+880.95 2600K37+595.24 2550K38+309.52 2500K39+023.81 2450K39+523.81 2400K40+238.10 2350K40+952.38 2300K41+666.67 2250K42+380.95 2200K43+095.24 2150K43+809.52 2100K44+523.81 2050K45+238.10 2000K45+952.38 1950K46+666.67 1900K47+166.67 1900K47+880.95 1950K48+595.24 2000K49+309.52 2050K50+023.81 2100K50+738.10 2150K51+452.38 2200K52+166.67 2250K52+880.95 2300K53+595.24 2350K54+309.52 2400K55+023.81 2450K55+738.10 2500K56+452.38 2550K57+166.67 2600K57+880.95 2650K58+595.24 2700K59+309.52 2750K60+023.81 2800K60+738.10 2850K61+452.38 2800K62+166.67 2750K62+880.95 2800K63+595.24 2850K64+095.24 2850K65+523.81 2750K66+023.81 2800

Page 22: PLANO.xlsx

K66+738.10 2850K67+452.38 2900K68+166.67 2950K68+880.95 3000K69+595.24 3050K70+309.52 3100K70+809.52 3150K71+523.81 3200K72+238.10 3250K72+952.38 3300K73+666.67 3350K74+166.67 3400K74+880.95 3450K75+595.24 3400K76+309.52 3350K77+023.81 3300K78+452.38 3200K79+166.67 3150K79+880.95 3100K80+595.24 3050K81+309.52 3000K81+809.52 2950K82+309.52 2950K83+023.81 2900K83+738.10 2950K84+452.38 3000K85+166.67 2950K85+880.95 3000K86+595.24 3050K87+095.24 3100K87+809.52 3150K88+523.81 3200K89+238.10 3250K89+952.38 3300K90+666.67 3350K91+380.95 3400K92+095.24 3450K92+809.52 3500K93+523.81 3550K94+238.10 3600K94+952.38 3650K95+666.67 3700K96+380.95 3750K96+880.95 3750K97+595.24 3800K98+309.52 3850K99+023.81 3900K99+738.10 3950

Page 23: PLANO.xlsx

### 4000### 4050### 4100### 4150### 4200### 4200### 4150### 4100### 4050### 4000### 3950### 4050### 4150### 4100### 4050### 4000### 3950### 3900### 3850### 3800### 3750### 3700### 3650### 3600### 3600### 3550### 3500### 3450### 3400### 3350### 3300### 3300### 3350### 3400### 3450### 3500### 3550### 3600### 3650### 3700### 3750### 3800### 3850### 3900### 3950### 4000### 4000### 4050

Page 24: PLANO.xlsx

### 4100### 4150### 4200### 4250### 4300### 4350### 4400### 4450### 4500### 4550### 4600### 4650### 4700### 4650### 4700### 4750### 4750### 4700### 4750### 4700### 4650### 4600### 4550### 4500### 4450### 4400### 4350### 4300### 4250### 4200### 4250### 4200### 4250### 4350### 4400### 4350### 4300### 4250### 4200### 4200### 4250### 4300### 4300### 4350### 4300### 4250### 4200### 4150

Page 25: PLANO.xlsx

### 4200### 4200### 4150### 4100### 4050### 4000### 3950### 3900### 3850### 3800### 3750### 3700### 3650### 3600### 3550### 3600### 3650### 3600### 3600### 3550### 3500### 3450### 3400### 3400### 3350### 3300### 3250### 3250### 3300### 3250### 3200### 3250### 3300### 3350### 3300### 3350### 3300### 3250### 3200### 3200### 3150### 3100### 3150### 3100### 3050### 3000### 3000### 3050

Page 26: PLANO.xlsx

### 3100### 3150### 3200### 3250### 3300### 3250### 3250### 3300### 3250### 3250### 3300### 3350### 3400### 3450### 3400### 3350### 3300### 3200### 3150### 3100### 3050### 3100### 3150### 3100### 3100