作者topgunguy (上面的槍手)
看板Office
標題[算表] 座標運算
時間Sun Nov 2 09:24:21 2014
軟體:excel
版本:2010
各位版友大家好,我想請教有關座標運算的問題。
請問要怎麼把附檔A到B範圍裡只有Y軸後面的數字加上5呢?
http://ppt.cc/r82J
內容如下。
%
O0100
G40G49G90G80
G17G00G55X0.Y0.
/G05.1 Q1
(TOOL: R3_SC23)
M03S8000
G43Z77.066H1
M8
G00X-3.537Y-32.185
Z50.
Z46.933
Z36.933
G01Z26.933F3000.
X-59.338
X-59.774Y-32.174
X-60.212Y-32.139
X60.951Y-32.027
X60.45Y-32.11
(----------A--------------)
X59.947Y-32.162
X59.338Y-32.185
X-4.137
Z36.986
X69.797Y-4.643Z37.19
Z27.137
X69.801Y-9.886Z27.135
X69.82Y-15.771Z27.129
X69.86Y-20.655Z27.117
X69.909Y-23.534Z27.105
X69.905Y-23.985Z27.104
X69.852Y-24.918Z27.097
X69.817Y-25.385Z27.087
X69.747Y-26.094Z27.066
X69.645Y-26.813Z27.037
X69.556Y-27.293Z27.015
X69.445Y-27.772Z26.99
X69.308Y-28.247Z26.966
X69.144Y-28.716Z26.942
X68.953Y-29.176Z26.919
X68.735Y-29.624Z26.899
X68.489Y-30.059Z26.884
X68.214Y-30.477Z26.873
X67.909Y-30.875Z26.869
X67.577Y-31.251Z26.871
X67.217Y-31.602Z26.881
X66.836Y-31.929Z26.894
X66.441Y-32.242Z26.905
X66.041Y-32.548Z26.91
X65.774Y-32.715Z26.923
X65.293Y-32.998Z26.94
X64.672Y-33.32Z26.959
X64.036Y-33.603Z26.976
X63.388Y-33.847Z26.991
X62.729Y-34.051Z27.005
(----------------B--------------)
X62.062Y-34.215Z27.017
X61.39Y-34.338Z27.027
X60.714Y-34.421Z27.036
X60.067Y-34.462Z27.043
X59.359Y-34.465Z27.05
X57.354Y-34.415Z27.065
X55.349Y-34.393Z27.072
X52.922Y-34.394
X51.665Y-34.403Z27.069
X49.923Y-34.428Z27.061
X46.921Y-34.5Z27.038
X44.169Y-34.594Z27.006
X41.169Y-34.723Z26.957
X38.419Y-34.861Z26.896
X36.419Y-34.971Z26.842
X32.669Y-35.19Z26.718
X28.669Y-35.424Z26.557
X24.92Y-35.626Z26.391
X20.671Y-35.826Z26.195
X18.171Y-35.926Z26.082
X15.422Y-36.021Z25.965
X12.423Y-36.104Z25.852
X9.673Y-36.162Z25.764
X6.674Y-36.209Z25.69
X4.799Y-36.229Z25.657
X2.925Y-36.243Z25.634
X-.075Y-36.251Z25.619
X-2.002Y-36.248Z25.625
X-5.001Y-36.229Z25.658
X-6.965Y-36.207Z25.693
X-10.428Y-36.151Z25.782
X-13.391Y-36.083Z25.881
X-16.354Y-35.996Z25.997
X-18.817Y-35.908Z26.104
X-22.78Y-35.738Z26.285
X-26.707Y-35.541Z26.465
X-30.67Y-35.317Z26.634
X-34.633Y-35.083Z26.781
X-38.561Y-34.862Z26.896
X-40.561Y-34.759Z26.941
X-43.491Y-34.627Z26.994
X-46.491Y-34.518Z27.033
X-49.422Y-34.441Z27.057
X8.005Y-39.021Z21.134
X8.411Y-39.055Z21.067
X8.806Y-39.086Z21.013
X9.193Y-39.112Z20.976
X9.667Y-39.139Z20.964
X9.967Y-39.152Z20.973
Z37.12
X.225Y38.546Z37.992
Z21.845
X-.342Y38.548Z21.809
X-2.042Y38.556Z21.814
X-4.846Y38.597Z21.84
Z31.84
G00Z41.84
Z50.
X0.Y0.
/G05.1 Q0
M09
G00Z77.066
X0.Y0.
M05
M30
%
感謝~
--
錢會變薄,資產會縮水。
通通花光才有100%的享受,
這就是活在當下。
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.234.41.103
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1414891465.A.6BB.html
→ topgunguy: 太神了 11/02 13:35
→ topgunguy: 請問S大,這篇如果要用在2003需要做什麼設定呢?我用 11/07 00:12
→ topgunguy: 2010開起後存成2003版但是不行。 11/07 00:12
→ topgunguy: 感謝 11/09 12:54