|
|
发表于 2023-12-31 13:32:21
|
显示全部楼层
Brief description
1. This Excel macro workbook has one ruler per table, which is divided into four categories: "benchmark, normal, text, and mirror window".
4. The reference ruler should be a DC linear ruler, and the text ruler should not draw scale lines or arcs.
2. Hidden tables do not participate in drawing. You can use Ctrl+drag to copy existing tables and add new rulers.
3. Each ruler has one layer, including the scale lines, arcs, and text readings of the ruler.
6. Prioritize calculating the drawing angle based on the measured angle on the current page, otherwise use the benchmark ruler.
5. The graduation function is in the theoretical angle column, and the data in the small table on the left should be corrected according to the specific circuit.
7. Please do not modify the table structure and do not insert/delete/move columns in the data area.
8. There is no limit to the number of lines in the tick mark data. The program starts reading data from the fourth line and stops when it encounters an empty [number].
9. An invalid theoretical angle prompt appears, usually indicating that the theoretical angle exceeds the full deviation angle, and the reading range should be reduced.
Operation steps
S1. Based on the flat scan photos of the dial, use CAD to measure the following data:
The full deviation angle of the pointer, the distance between the centers of two circles, and the radius of each ruler circle.
S2. Drive with standard current and measure the measured angle using a reference scale and a scale without a graduation function.
S3. Click "Calibrate All Rulers" to recalculate the 【 Draw Angle 】 of each ruler (all rulers will be automatically calibrated during drawing). Click the "Calculate" button to only calculate this page.
S4. Click the "Draw" button on the floating window to execute the drawing. Check "All" to draw all rulers at once, otherwise only the selected single ruler will be drawn.
S5. Modify the generated CAD document (content can be added to a new drawing layer, and do not check "All" when redrawing the ruler).
1. If there is an increase or decrease in the number of Excel tables or CAD documents or a change in their names, you should click "Refresh" in the small window.
2. If there is a security prompt in Excel, you should click "Enable Content".
3. CAD should be printed in a 1:1 ratio. |
-
评分
-
1
查看全部评分
-
|
[复制链接]
IP卡
狗仔卡
显身卡
楼主
，刚才查了下，SVG使用XML格式定义图形，貌似不能通过VBA引用其对象。aCAD比较大众化，安装也很方便。
