EXCEL计算施工坐标及大地坐标转换

轴线

轴间距

坐标

轴线1234坐标0360048006600轴间距

M 170020000L 390018300H 150014400G 420012900E 36008700C 39005100B 12001200A 00

桩号部位参考桩号

Y主轴X主轴Y轴偏移3-1#E 3187004800-2803-2#E 318700480017203-3#H 331440048001853-4#H 3314400480021853-5#G 45129006600-1003-6#E 468700660017153-7#E 4687006600-2853-8#H 581440078001503-9#L 59183007800-18903-10#L 591830078001103-11#G 6111290010800-1003-12#E 6128700108002003-13#H 71314400114001003-14#L 7141830011400-1503-15#L 8151830015000-2003-16#H 81614400150001003-17#G 8171290015000-1503-18#E 8188700150003253-19#C 919510016150-2003-20#B 9201200161504853-21#B 920120016150-15153-22#B 1024120018450-30003-23#B 1024120018450-6753-24#B 10241200184509003-25#C 1025510018450-1503-26#E 10268700184504503-27#G 10271290018450-2003-28#H 112814400189005053-29#H 1128144001890030053-30#M 11302000018900-953-31#M 12312000020100-953-32#

3314400201003005

Y轴X轴

3-33#H12331440020100505 3-34#E1334870021300-800 3-35#E1334870021300-800 3-36#B1/12361200205501570 3-37#B1/1236120020550-430 3-38#B1538120025200-425 3-39#B15381200252001575 3-40#G13401290021300-300 3-41#H14411440023250150 3-42#M14422000023250-150 3-43#M16432000028200-200 3-44#L16441830028200-150 3-45#H16451440028200200 3-46#G17461290029400-200 3-47#E1747870029400450 3-48#C1748510029400-150 3-49#B17491200294001560 3-50#B1749120029400-440 3-51#C1851510032400-100 3-52#E1952870033600325 3-53#G19531290033600-150 3-54#H19541440033600150 3-55#L19551830033600-200 3-56#L20561830035400-100 3-57#H20571440035400100 3-58#G21581290036600-100 3-59#E2159870036600200 3-60#E06087000-290 3-61#E060870001710 3-62#G062129000-100 3-63#H22631440040200150 3-64#L22641830040200-1890 3-65#L22641830040200110 3-66#H0671440002140 3-67#H067144000140 3-68#E068870001475 3-69#E06887000-525

56789101112 780010800114001500016150184501890020100

X轴偏移Y X桩号X Y 125E轴交 3轴842049253-11258419 125E轴交 3轴1042049253-212510419 195H轴交 3轴1458549953-319514584 195H轴交 3轴1658549953-419516584 100G轴交 4轴1280067003-5370012799 -90E轴交 4轴1041565103-6351010414 -90E轴交 4轴841565103-735108414 0H轴交 5轴1455078003-8480014549 10L轴交 5轴1641078103-9480016409 10L轴交 5轴1841078103-10480018409 100G轴交 6轴12800109003-11670012799 200E轴交 6轴8900110003-1268008899 100H轴交 7轴14500115003-137******** 150L轴交 7轴181********-14795018149 -200L轴交 8轴181********-151060018099 150H轴交 8轴14500151503-161095014499 100G轴交 8轴12750151003-171090012749 -100E轴交 8轴9025149003-181******** 300C轴交 9轴4900164503-19117004899 70B轴交 9轴1685162203-20114701684 70B轴交 9轴-315162203-2111470-316 -1065B轴交 10轴-1800173853-2213935-1801 1705B轴交 10轴525201553-2316705525 -1065B轴交 10轴2100173853-24139352099 100C轴交 10轴4950185503-25151004949 -150E轴交 10轴9150183003-26148509149 -150G轴交 10轴12700183003-271485012699 -220H轴交 11轴14905186803-281593014904 -220H轴交 11轴17405186803-291593017404 -220M轴交 11轴199********-301593019904 -120M轴交 12轴199********-311833019904 -120H轴交 12轴17405199803-321833017404

-120H轴交 12轴14905199803-331833014904 -1350E轴交 13轴7900199503-34187507899 1350E轴交 13轴7900226503-35214507899 -155B轴交 1/12轴2770203953-36187452769 -155B轴交 1/12轴770203953-3718745769 165B轴交 15轴775253653-3821465774 165B轴交 15轴2775253653-39214652774 0G轴交 13轴12600213003-402010012599 100H轴交 14轴14550233503-412065014549 150M轴交 14轴198********-422070019849 0M轴交 16轴198********-432325019799 100L轴交 16轴181********-442335018149 -150H轴交 16轴14600280503-452310014599 150G轴交 17轴12700295503-462535012699 150E轴交 17轴9150295503-47253509149 150C轴交 17轴4950295503-48253504949 -130B轴交 17轴2760292703-49250702759 -130B轴交 17轴760292703-5025070759 -200C轴交 18轴5000322003-51280004999 0E轴交 19轴9025336003-52294009024 -100G轴交 19轴12750335003-532930012749 -200H轴交 19轴14550334003-542920014549 100L轴交 19轴181********-552950018099 -100L轴交 20轴182********-563230018199 -100H轴交 20轴14500353003-573230014499 -100G轴交 21轴12800365003-583350012799 -150E轴交 21轴8900364503-59334508899 95E轴交 0轴8410953-60366958409 95E轴交 0轴10410953-613669510409 -100G轴交 0轴12800-1003-623650012799 0H轴交 22轴14550402003-633540014549 -10L轴交 22轴16410401903-643540016409 -10L轴交 22轴184********-653540018409 -195H轴交 0轴16540-1953-664000516539 -195H轴交 0轴14540-1953-674000514539 -185E轴交 0轴10175-1853-684001510174 -185E轴交 0轴8175-1853-69400158174

1/121314151617181920 205502130023250252002820029400324003360035400

Z X差Y差参考桩号对应桩号

0-4800112

0-4800134

0-48001

0-30001

0-30101

0-42001

0-36001

0-42001

0-47501

0-34501

0-34500

0-34501

0-27501

0-16501

0-16501 0-12001 0-12001 0-16501 0-16501 0-39001 0-39001 0-12001 0-27001 0-27001 0-49501 0-49501 0-49501 0-42001 0-42001 0-42001 0-42001 0-42001 0-42001 0-42001 0-42001 0-42001 0-42001 0-30001 0-30001 0-30001 0-30001 0366001 0366001 0366001 0-48001 0-47901 0-47901 0402001 0402001 0402001 0402001

2122 3660040200