CAD展点位和点号

将点位坐标展到CAD上,可查看点位分布。

1、点位数据

如下表所示数据

点号CAD xCAD y
1-15740.8302-36648.0288
2-15740.8302-35828.0288
3-15740.8302-35008.0288
4-16570.8302-36648.0288
5-16570.8302-35828.0288
6-16570.8302-35008.0288
7-17400.8302-36648.0288
8-17400.8302-35828.0288
9-17400.8302-35008.0288

2、坐标拼接

使用如下语句

=B2 & ","&C2
点号CAD xCAD y格式(x,y)
1-15740.8302-36648.0288-15740.8302,-36648.0288
2-15740.8302-35828.0288-15740.8302,-35828.0288
3-15740.8302-35008.0288-15740.8302,-35008.0288
4-16570.8302-36648.0288-16570.8302,-36648.0288
5-16570.8302-35828.0288-16570.8302,-35828.0288
6-16570.8302-35008.0288-16570.8302,-35008.0288
7-17400.8302-36648.0288-17400.8302,-36648.0288
8-17400.8302-35828.0288-17400.8302,-35828.0288
9-17400.8302-35008.0288-17400.8302,-35008.0288

3、构造点及坐标

使用下面语句,po代表点(point),用逗号间隔

="po " &D2&""
点号CAD xCAD y格式(x,y)
1-15740.8302-36648.0288-15740.8302,-36648.0288po -15740.8302,-36648.0288
2-15740.8302-35828.0288-15740.8302,-35828.0288po -15740.8302,-35828.0288
3-15740.8302-35008.0288-15740.8302,-35008.0288po -15740.8302,-35008.0288
4-16570.8302-36648.0288-16570.8302,-36648.0288po -16570.8302,-36648.0288
5-16570.8302-35828.0288-16570.8302,-35828.0288po -16570.8302,-35828.0288
6-16570.8302-35008.0288-16570.8302,-35008.0288po -16570.8302,-35008.0288
7-17400.8302-36648.0288-17400.8302,-36648.0288po -17400.8302,-36648.0288
8-17400.8302-35828.0288-17400.8302,-35828.0288po -17400.8302,-35828.0288
9-17400.8302-35008.0288-17400.8302,-35008.0288po -17400.8302,-35008.0288

4、点号坐标

x和y都加偏移量5,即点号的位置,执行如下语句

=B2+5 &","&C2+5
点号CAD xCAD y格式(x,y)点号坐标
1-15740.8302-36648.0288-15740.8302,-36648.0288po -15740.8302,-36648.0288-15735.8302,-36643.0288
2-15740.8302-35828.0288-15740.8302,-35828.0288po -15740.8302,-35828.0288-15735.8302,-35823.0288
3-15740.8302-35008.0288-15740.8302,-35008.0288po -15740.8302,-35008.0288-15735.8302,-35003.0288
4-16570.8302-36648.0288-16570.8302,-36648.0288po -16570.8302,-36648.0288-16565.8302,-36643.0288
5-16570.8302-35828.0288-16570.8302,-35828.0288po -16570.8302,-35828.0288-16565.8302,-35823.0288
6-16570.8302-35008.0288-16570.8302,-35008.0288po -16570.8302,-35008.0288-16565.8302,-35003.0288
7-17400.8302-36648.0288-17400.8302,-36648.0288po -17400.8302,-36648.0288-17395.8302,-36643.0288
8-17400.8302-35828.0288-17400.8302,-35828.0288po -17400.8302,-35828.0288-17395.8302,-35823.0288
9-17400.8302-35008.0288-17400.8302,-35008.0288po -17400.8302,-35008.0288-17395.8302,-35003.0288

5、标记点号语句

形成CAD可执行的语句,用于在CAD上标记点号。160为字高,0为旋转角,各元素部分需有空格。

="-text "&F2&" 160 "&"0 "&A2&""
点号CAD xCAD y格式(x,y)点号坐标标记点号
1-15740.8302-36648.0288-15740.8302,-36648.0288po -15740.8302,-36648.0288-15735.8302,-36643.0288-text -15735.8302,-36643.0288 160 0 1
2-15740.8302-35828.0288-15740.8302,-35828.0288po -15740.8302,-35828.0288-15735.8302,-35823.0288-text -15735.8302,-35823.0288 160 0 2
3-15740.8302-35008.0288-15740.8302,-35008.0288po -15740.8302,-35008.0288-15735.8302,-35003.0288-text -15735.8302,-35003.0288 160 0 3
4-16570.8302-36648.0288-16570.8302,-36648.0288po -16570.8302,-36648.0288-16565.8302,-36643.0288-text -16565.8302,-36643.0288 160 0 4
5-16570.8302-35828.0288-16570.8302,-35828.0288po -16570.8302,-35828.0288-16565.8302,-35823.0288-text -16565.8302,-35823.0288 160 0 5
6-16570.8302-35008.0288-16570.8302,-35008.0288po -16570.8302,-35008.0288-16565.8302,-35003.0288-text -16565.8302,-35003.0288 160 0 6
7-17400.8302-36648.0288-17400.8302,-36648.0288po -17400.8302,-36648.0288-17395.8302,-36643.0288-text -17395.8302,-36643.0288 160 0 7
8-17400.8302-35828.0288-17400.8302,-35828.0288po -17400.8302,-35828.0288-17395.8302,-35823.0288-text -17395.8302,-35823.0288 160 0 8
9-17400.8302-35008.0288-17400.8302,-35008.0288po -17400.8302,-35008.0288-17395.8302,-35003.0288-text -17395.8302,-35003.0288 160 0 9

6、CAD中展点操作

(1)选择点样式

【格式】——【点样式】,将点大小设为200;

 

(2)复制【点】所在列的数据,粘贴在CAD的命令行,回车。

(3)复制【标记点号】栏的数据到CAD命令行,并回车。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值