弯沉值随机自动计算表格(原创)

工程信息 工程名称： 乐清市经济开发区二期道路工程I标段 施工单位： 宁波市华东建设工程有限公司 公路等级 二级道路 保证系数： 高速公路、一级公路 2 二级公路 1.645 二级以下公路 1.5 试验位置： 路基 水泥稳定层 沥青面层 弯沉 210 100 87 起止桩号 纬七路K0+700-K1+160 纬七路K0+700-K1+160 纬七路K0+700-K1+160 说明： 只需填写绿色部分，根据不同的设计弯沉值填写对应。公路等级不同，后表的弯沉代表值公式要做一些不同的修改！！ 希望高手帮忙修改下，把三个表格合为一个；根据不同的设计弯沉值自动计算；路基回弹弯沉记录 桩号 D1 D2 1/100(mm) D1 D2 1/100(mm) D1 D2 1/100(mm) k8+510 左1 386.4041813488 342.4041813488 44 474.3330220261 408.3330220261 66 k8+530 左1 455.6650260369 405.6650260369 50 394.0624039566 326.0624039566 68 k8+550 左1 440.889287328 382.889287328 58 383.5520308237 345.5520308237 38 k8+570 左1 436.9908252908 406.9908252908 30 457.8990592437 405.8990592437 52 k8+590 左1 401.2803084017 343.2803084017 58 435.4467255929 367.4467255929 68 k8+610 左1 452.3526923505 420.3526923505 32 479.0276576744 429.0276576744 50 k8+630 左1 388.435705869 346.435705869 42 432.5501501043 388.5501501043 44 k8+650 左1 376.283502119 320.283502119 56 446.9260042558 388.9260042558 58 k8+670 左1 411.2322565297 343.2322565297 68 473.5056485447 427.5056485447 46 k8+690 左1 432.6539870741 394.6539870741 38 415.5381068074 365.5381068074 50 k8+510 左2 435.6583792432 379.6583792432 56 434.4211450012 390.4211450012 44 k8+530 左2 372.7075596456 304.7075596456 68 407.5792272958 371.5792272958 36 k8+550 左2 372.7630717693 332.7630717693 40 384.9379380803 342.9379380803 42 k8+570 左2 420.4963692331 352.4963692331 68 461.2226745632 409.2226745632 52 k8+590 左2 466.276087954 402.276087954 64 425.977638836 365.977638836 60 k8+610 左2 417.5507694199 357.5507694199 60 383.2687289002 331.2687289002 52 k8+630 左2 383.882187845 351.882187845 32 479.2824640894 431.2824640894 48 k8+650 左2 458.8207323568 422.8207323568 36 393.0600829825 333.0600829825 60 k8+670 左2 461.0422710214 423.0422710214 38 449.3604571827 407.3604571827 42 k8+690 左2 455.0081363595 393.0081363595 62 403.4746112646 357.4746112646 46 k8+510 右1 422.6428489452 356.6428489452 66 387.2706513797 355.2706513797 32 k8+530 右1 418.7701548066 366.7701548066 52 386.8909753776 356.8909753776 30 k8+550 右1 403.0165682402 371.0165682402 32 431.4350964459 375.4350964459 56 k8+570 右1 419.3653386885 387.3653386885 32 435.6182562357 389.6182562357 46 k8+590 右1 460.160964426 400.160964426 60 452.2523013903 406.2523013903 46 k8+610 右1 390.4895723109 332.4895723109 58 446.3145775809 380.3145775809 66 k8+630 右1 467.750713528 415.750713528 52 399.4934023122 331.4934023122 68 k8+650 右1 423.1995433227 357.1995433227 66 435.0358152158 401.0358152158 34 k8+670 右1 372.6819306574 334.6819306574 38 439.7820347517 387.7820347517 52 k8+690 右1 389.0561260549 321.0561260549 68 384.5750583274 332.5750583274 52 k8+510 右2 400.9784661847 346.9784661847 54 402.8178622202 372.8178622202 30 k8+530 右2 456.8797201737 400.8797201737 56 451.8703582494 399.8703582494 52 k8+550 右2 370.4456656909 310.4456656909 60 404.2406511188 356.2406511188 48 k8+570 右2 391.6823372267 327.6823372267 64 400.4353529798 338.4353529798 62 k8+590 右2 400.5939428051 358.5939428051 42 397.2375994228 365.2375994228 32 k8+610 右2 447.097230967 401.097230967 46 468.6353391171 408.6353391171 60 k8+630 右2 444.6038158774 382.6038158774 62 469.6315456566 407.6315456566 62 k8+650 右2 452.4708287262 408.4708287262 44 468.0379345951 414.0379345951 54 k8+670 右2 437.4062579389 387.4062579389 50 454.417425208 424.417425208 30 k8+690 右2 405.3790482751 343.3790482751 62 405.2020390024 353.2020390024 52 21 左 395.3843123265 363.3843123265 32 388.6762210797 326.6762210797 62 右 468.9879484479 400.9879484479 68 451.2220094382 393.2220094382 58 22 左 407.9380304537 371.9380304537 36 415.4795928918 347.4795928918 68 右 376.3819575074 344.3819575074 32 400.4909345758 338.4909345758 62 23 左 448.1073000161 394.1073000161 54 453.9878356017 397.9878356017 56 右 371.121115466 319.121115466 52 438.6402874719 408.6402874719 30 24 左 434.4578943039 376.4578943039 58 400.6871801865 334.6871801865 66 右 467.9847993019 407.9847993019 60 417.5228640841 367.5228640841 50 25 左 414.5660751554 356.5660751554 58 448.7238304115 394.7238304115 54 右 443.8865722102 397.8865722102 46 462.8566276511 400.8566276511 62 26 左 375.4081489601 345.4081489601 30 431.5574119954 391.5574119954 40 右 437.2268385273 405.2268385273 32 403.6092585901 337.6092585901 66 27 左 419.5005176457 383.5005176457 36 386.6467301772 340.6467301772 46 右 466.4297602848 404.4297602848 62 414.2185270234 352.2185270234 62 28 左 372.60164307 328.60164307 44 425.8530281303 367.8530281303 58 右 402.1476294936 342.1476294936 60 457.1093122915 399.1093122915 58 29 左 370.2781021029 328.2781021029 42 441.3929735239 375.3929735239 66 右 413.2812893892 347.2812893892 66 440.3205226357 384.3205226357 56 30 左 402.102984051 350.102984051 52 469.7552420999 405.7552420999 64 右 372.8682497183 308.8682497183 64 387.8965043144 335.8965043144 52 31 左 405.751882988 339.751882988 66 383.2513552524 341.2513552524 42 右 415.8023233852 367.8023233852 48 424.3761074723 380.3761074723 44 32 左 409.6522613312 361.6522613312 48 408.4557073678 366.4557073678 42 右 435.8702039107 369.8702039107 66 460.1858083025 408.1858083025 52 33 左 405.0204203958 351.0204203958 54 469.0066964461 409.0066964461 60 右 467.2774767373 431.2774767373 36 395.5771591496 351.5771591496 44 34 左 397.2937953982 339.2937953982 58 409.1420628061 371.1420628061 38 右 416.3646534623 380.3646534623 36 384.4342713814 320.4342713814 64 35 左 434.814043234 384.814043234 50 404.4547219075 372.4547219075 32 右 401.6294682228 337.6294682228 64 395.6609931059 353.6609931059 42 36 左 441.5187631474 389.5187631474 52 451.7321168967 401.7321168967 50 右 444.7578007122 382.7578007122 62 460.1492657749 400.1492657749 60 37 左 380.3097146647 312.3097146647 68 466.9551974265 418.9551974265 48 右 461.187077954 401.187077954 60 433.4718707286 403.4718707286 30 38 左 439.708561367 391.708561367 48 404.3759237306 368.3759237306 36 右 386.6269975683 346.6269975683 40 466.8152342678 398.8152342678 68 39 左 424.8001279806 374.8001279806 50 474.8103262026 422.8103262026 52 右 452.2793147833 408.2793147833 44 385.7452443343 355.7452443343 30 40 左 395.6592317085 337.6592317085 58 413.3242635128 369.3242635128 44 右 372.3817248321 322.3817248321 50 393.1334774355 343.1334774355 50 41 左 389.0040527684 349.0040527684 40 384.5214385103 330.5214385103 54 右 440.2339565608 384.2339565608 56 449.1720561968 419.1720561968 30 42 D1 D2 1/100(mm) D1 D2 1/100(mm) D1 D2 1/100(mm) 左 466.4657377101 436.4657377101 30 442.2536836669 410.2536836669 32 43 右 383.5805294268 353.5805294268 30 385.0301335551 347.0301335551 38 左 417.7405258869 349.7405258869 68 451.6436233659 403.6436233659 48 44 右 435.1801101543 371.1801101543 64 448.9112212652 402.9112212652 46 左 415.6386527815 367.6386527815 48 431.1362363457 373.1362363457 58 45 右 396.3878205878 358.3878205878 38 385.8011256819 319.8011256819 66 左 451.7129216858 397.7129216858 54 469.1696433495 423.1696433495 46 46 右 443.5645518736 409.5645518736 34 454.7538637632 418.7538637632 36 左 414.1923234108 384.1923234108 30 472.6370541717 424.6370541717 48 47 右 414.4753693234 378.4753693234 36 435.6112309281 371.6112309281 64 左 420.163683405 366.163683405 54 413.8397752622 361.8397752622 52 48 右 435.0863778413 389.0863778413 46 448.0991430199 390.0991430199 58 左 406.6291500007 364.6291500007 42 385.688387017 325.688387017 60 49 右 409.3166911777 357.3166911777 52 441.2129432974 377.2129432974 64 左 449.5826101205 403.5826101205 46 438.2470649535 408.2470649535 30 50 右 441.2262430979 381.2262430979 60 396.9064441683 350.9064441683 46 左 464.668776799 420.668776799 44 470.0461363232 408.0461363232 62 51 右 446.0489949682 388.0489949682 58 384.5892515345 320.5892515345 64 左 378.7707737343 318.7707737343 60 406.6646765313 376.6646765313 30 52 右 448.1199806855 408.1199806855 40 397.8373971466 341.8373971466 56 左 453.3719484088 385.3719484088 68 405.2419903349 373.2419903349 32 53 右 455.2313457447 389.2313457447 66 476.1923926054 428.1923926054 48 左 421.5609000731 361.5609000731 60 389.4853696178 353.4853696178 36 54 右 430.4122772845 396.4122772845 34 452.7557247978 386.7557247978 66 左 387.197735655 343.197735655 44 435.3447625417 399.3447625417 36 55 右 396.1453358993 342.1453358993 54 457.8149846869 403.8149846869 54 左 435.9988474652 381.9988474652 54 435.5710990694 399.5710990694 36 56 右 429.492536555 389.492536555 40 394.644190478 348.644190478 46 左 466.0730722682 422.0730722682 44 464.3294877186 422.3294877186 42 57 右 395.6122641037 347.6122641037 48 460.226363685 426.226363685 34 左 394.4511316741 348.4511316741 46 401.0061653974 357.0061653974 44 58 右 437.7642115515 369.7642115515 68 459.3766165283 395.3766165283 64 左 459.2915776226 399.2915776226 60 479.2463763541 441.2463763541 38 59 右 469.4284538948 411.4284538948 58 393.0293866742 355.0293866742 38 左 415.073774451 373.073774451 42 438.9357340921 384.9357340921 54 60 右 438.5491873905 388.5491873905 50 415.2592478037 349.2592478037 66 左 429.4168001208 361.4168001208 68 398.2328748861 354.2328748861 44 61 右 410.4993746254 352.4993746254 58 471.9420871006 439.9420871006 32 左 425.8973539112 385.8973539112 40 445.3186540407 387.3186540407 58 62 右 444.6669035334 400.6669035334 44 453.5875431808 419.5875431808 34 D1 D2 1/100(mm) D1 D2 1/100(mm) D1 D2 1/100(mm) 63 左 462.2133413894 408.2133413894 54 448.0631431891 418.0631431891 30 右 446.9627602633 412.9627602633 34 471.7473410937 431.7473410937 40 64 左 409.1399692464 369.1399692464 40 382.487549199 344.487549199 38 右 380.2757332392 316.2757332392 64 446.7040401821 384.7040401821 62 65 左 441.2533285184 397.2533285184 44 406.0898392969 348.0898392969 58 右 412.2341498076 346.2341498076 66 469.8446673282 437.8446673282 32 66 左 455.332037742 393.332037742 62 432.4549147771 390.4549147771 42 右 443.5759178194 409.5759178194 34 466.4791272435 418.4791272435 48 67 左 379.4032952165 313.4032952165 66 380.6318183002 320.6318183002 60 右 460.8279778042 416.8279778042 44 389.0327923869 321.0327923869 68 68 左 396.6477113276 342.6477113276 54 431.6779149397 377.6779149397 54 右 395.3654979176 361.3654979176 34 407.9504349867 351.9504349867 56 69 左 413.3400016352 371.3400016352 42 471.7428793345 415.7428793345 56 右 383.8287594605 337.8287594605 46 391.4702155045 355.4702155045 36 70 D1 D2 1/100(mm) D1 D2 1/100(mm) D1 D2 1/100(mm) 左 457.4518196436 407.4518196436 50 396.5354214881 358.5354214881 38 71 右 457.3035559709 421.3035559709 36 412.5213590129 380.5213590129 32 左 463.0408701402 431.0408701402 32 475.9535631713 419.9535631713 56 72 右 406.9897386952 372.9897386952 34 393.9072050779 349.9072050779 44 左 391.9015448903 351.9015448903 40 391.4127047014 361.4127047014 30 73 右 376.564877655 312.564877655 64 384.7223342268 324.7223342268 60 左 419.468263666 379.468263666 40 424.0927765461 380.0927765461 44 74 右 412.7117741888 382.7117741888 30 387.3691268218 345.3691268218 42 左 437.1846402011 397.1846402011 40 469.8852867393 439.8852867393 30 75 右 395.5239198687 355.5239198687 40 456.2152021663 390.2152021663 66 左 457.9514677971 425.9514677971 32 413.9950508451 351.9950508451 62 76 右 442.4724783564 384.4724783564 58 457.3222831339 405.3222831339 52 左 449.2024288683 401.2024288683 48 431.0413916754 363.0413916754 68 77 右 460.9489077443 410.9489077443 50 430.0524579596 398.0524579596 32 左 439.1081628097 385.1081628097 54 470.2867987523 428.2867987523 42 78 右 375.0249366273 309.0249366273 66 409.6745922794 353.6745922794 56 左 450.4490241172 396.4490241172 54 425.9138685235 359.9138685235 66 79 右 444.9458268133 408.9458268133 36 450.5621388564 382.5621388564 68 左 403.7004106646 367.7004106646 36 381.7430359709 313.7430359709 68 80 右 457.3019174336 403.3019174336 54 424.3398272439 372.3398272439 52 左 419.7776181058 381.7776181058 38 406.2717398031 350.2717398031 56 81 右 397.9449710505 329.9449710505 68 415.1938047043 363.1938047043 52 左 440.9735026926 382.9735026926 58 458.5922632433 398.5922632433 60 82 右 422.5317868276 370.5317868276 52 384.909968672 330.909968672 54 左 391.8209291794 351.8209291794 40 438.9401602801 402.9401602801 36 83 右 430.9411448748 396.9411448748 34 448.6436803425 418.6436803425 30 左 399.1869596838 357.1869596838 42 456.82467215 422.82467215 34 84 右 378.183113304 316.183113304 62 389.694466056 349.694466056 40 左 455.8058675242 409.8058675242 46 433.6924664199 375.6924664199 58 85 右 429.8167967808 387.8167967808 42 416.5139492234 350.5139492234 66 左 444.0834041239 400.0834041239 44 397.4991871381 341.4991871381 56 86 右 387.2647765576 333.2647765576 54 389.3845827649 343.3845827649 46 左 450.0842036572 396.0842036572 54 453.7541902597 393.7541902597 60 87 右 436.1040557486 406.1040557486 30 432.9379392068 376.9379392068 56 D1 D2 1/100(mm) D1 D2 1/100(mm) D1 D2 1/100(mm) 88 左 370.54995584 318.54995584 52 442.5294830799 386.5294830799 56 右 462.2512215562 432.2512215562 30 396.470991407 364.470991407 32 89 左 396.0057521563 352.0057521563 44 417.0656819921 361.0656819921 56 右 372.0818453741 324.0818453741 48 466.8118762697 434.8118762697 32 90 左 404.9095165558 336.9095165558 68 418.3632668847 378.3632668847 40 右 415.1359575339 351.1359575339 64 451.464957269 403.464957269 48 91 左 394.7312026625 352.7312026625 42 435.8025213121 367.8025213121 68 右 387.2286408407 329.2286408407 58 467.8255257838 401.8255257838 66 92 左 446.7263738099 402.7263738099 44 440.7726022571 408.7726022571 32 右 410.3517033302 380.3517033302 30 420.448215484 366.448215484 54 93 左 371.6198517952 331.6198517952 40 387.8365861283 357.8365861283 30 右 453.2778165346 411.2778165346 42 415.6295672903 355.6295672903 60 94 左 437.4954445963 379.4954445963 58 388.0155826273 348.0155826273 40 右 377.4464924328 345.4464924328 32 418.9304684776 372.9304684776 46 95 左 436.636620289 386.636620289 50 473.181019612 417.181019612 56 右 428.2366292223 386.2366292223 42 463.2180572314 401.2180572314 62 96 左 393.8018161385 351.8018161385 42 387.7350779243 347.7350779243 40 右 456.2896315895 398.2896315895 58 397.4687154802 349.4687154802 48 97 左 427.9013060262 379.9013060262 48 398.6587501715 348.6587501715 50 右 435.6633546695 379.6633546695 56 463.9893970752 401.9893970752 62 98 左 411.3439881276 343.3439881276 68 423.9310148494 379.9310148494 44 右 374.6996837131 316.6996837131 58 439.7797372078 399.7797372078 40 99 左 404.6490091179 366.6490091179 38 390.2241108377 330.2241108377 60 右 373.1015621906 323.1015621906 50 460.8144590526 408.8144590526 52 100 左 396.5245495052 336.5245495052 60 387.1750231522 343.1750231522 44 右 391.4567893807 327.4567893807 64 431.2341679559 387.2341679559 44 101 左 376.9299023654 320.9299023654 56 424.0662754552 360.0662754552 64 右 444.8799021634 398.8799021634 46 472.5606195982 432.5606195982 40 102 左 450.5707631601 410.5707631601 40 452.644370341 398.644370341 54 右 370.2287340214 308.2287340214 62 421.0858434427 389.0858434427 32 103 左 444.6082918225 376.6082918225 68 434.4526389985 372.4526389985 62 右 397.8365379799 341.8365379799 56 448.6868523275 410.6868523275 38 104 左 417.5392219837 385.5392219837 32 383.4761860521 325.4761860521 58 右 375.6525680342 309.6525680342 66 438.0353861188 406.0353861188 32&R&10第&P页共&N页水稳层回弹弯沉记录 水泥稳定层 回弹弯沉记录 实验表34 工程名称： 乐清市经济开发区二期道路工程I标段 施工单位： 宁波市华东建设工程有限公司 试验位置： 水泥稳定层 起止桩号： 纬七路K0+700-K1+160 试验时间： 设计弯沉： 100 试验车型： 东风 后轴重： 100KN 序号 桩号 轮位 行车道（左） 行车道（右） 行车道（） 百分表读数 百分表读数 百分表读数 D1 D2 1/100(mm) D1 D2 1/100(mm) D1 D2 1/100(mm) 1 K0+700 左 437.5500540619 401.5500540619 72 404.7854061077 359.7854061077 90 右 412.7306191183 378.7306191183 68 449.234677016 417.234677016 64 2 K0+720 左 385.1895002399 337.1895002399 96 380.9339774283 339.9339774283 82 右 430.2500654508 382.2500654508 96 437.0166532436 403.0166532436 68 3 K0+740 左 435.8123888812 392.8123888812 86 445.7945838433 415.7945838433 60 右 436.5685614754 401.5685614754 70 402.1951870303 368.1951870303 68 4 K0+760 左 388.5894247921 353.5894247921 70 426.3543735386 380.3543735386 92 右 389.9592766311 354.9592766311 70 441.0734928313 394.0734928313 94 5 K0+780 左 447.3817082802 404.3817082802 86 383.0177280835 349.0177280835 68 右 393.7742423893 350.7742423893 86 413.5273697253 378.5273697253 70 6 K0+800 左 406.6350435786 372.6350435786 68 439.8635541563 393.8635541563 92 右 433.8765206612 400.8765206612 66 408.4879007636 370.4879007636 76 7 K0+820 左 404.1182284862 359.1182284862 90 400.7305083643 365.7305083643 70 右 394.2373472167 363.2373472167 62 420.4017468484 375.4017468484 90 8 K0+840 左 425.4643542535 390.4643542535 70 444.8955579192 407.8955579192 74 右 399.411728641 355.411728641 88 389.8236660586 345.8236660586 88 9 K0+860 左 414.500702092 378.500702092 72 405.6571424726 369.6571424726 72 右 435.0016078915 397.0016078915 76 440.6940983813 391.6940983813 98 10 K0+880 左 394.8169116204 348.8169116204 92 392.5268371928 362.5268371928 60 右 412.2489492604 366.2489492604 92 443.2288728576 397.2288728576 92 11 K0+900 左 431.2591067379 397.2591067379 68 446.730801946 415.730801946 62 右 407.5643058163 366.5643058163 82 387.7118420197 350.7118420197 74 12 K0+920 左 390.5270803741 354.5270803741 72 428.6800873381 395.6800873381 66 右 422.5913924165 385.5913924165 74 424.356312387 384.356312387 80 13 K0+940 左 412.4052008239 370.4052008239 84 441.9598471478 403.9598471478 76 右 415.0389738379 378.0389738379 74 445.024169452 413.024169452 64 14 K0+960 左 404.0089546554 368.0089546554 72 419.8139247565 382.8139247565 74 右 402.4527825419 369.4527825419 66 400.8279996563 368.8279996563 64 15 K0+980 左 385.9115354918 346.9115354918 78 441.8851073515 393.8851073515 96 右 391.3256547531 350.3256547531 82 427.2695479674 380.2695479674 94 16 K1+000 左 449.6634239081 419.6634239081 60 384.1000476146 348.1000476146 72 右 441.9449987885 411.9449987885 60 439.9617389443 409.9617389443 60 17 K1+020 左 421.3663925368 376.3663925368 90 385.4621009231 338.4621009231 94 右 425.3563746118 393.3563746118 64 437.4289180783 389.4289180783 96 水泥稳定层 回弹弯沉记录 实验表34 工程名称： 乐清市经济开发区二期道