Atatched drawing and stencil include a set of airfoils.
They are applied to the main wing of hand launched gliders.
Each shape has a link to outside database that explaines characters of the air foil.
Each shape has right click menu to hide and show the code line that is horizontal straigh line, base line.
This drawing has a macro that is used to draw shapes on this drawing from excel data gotten from the data base.
Here is a stencil.
This is an image of drawing.
Nice job!!!
So like should we now start to call you the virtual Orvil or Wilbur of the 21st century???
Hi,
How is the data in the spreadsheet or database acquired initially ?
Am I to understand that this application can autodraw to foil profile from the database?
Is the applications purpose to therefore allow, the database contents can be altered and manipulated and thus alter the foil's image profile?
My macro reads an Excel data
from one of listed in my macro.
The Excel data were made by my hands
importing from outside data base
that my each shape has link to.
Each outside database provides text data or csv data.
They may including airfoil data and camber data.
I selected only airfoil data out of them.
Most airfoil data gives x and y value
for upper and lower surfaces each.
In many database x begins from 100
and ends at 0 for upper surface, and
continues from 0 to 100 for lower
surface.
In some of database x begins from 1
and ends once at 0, and restarts from 0
and ends at 1.
My macro can only read Excel data
that has such an imported data.
I atatched example Excel data and text data.
Hi Junichi
thankyou for your insight.
There are two aspects to this I find interesting.
1. The automated airfoil image production is occuring via your macros, the macros are driving the "pencil" to screen X and Y positions based upon X Y numeric data from aspreadsheet . I have an interest in macro drawing functionality from data.
2 The data itself in the spreadsheet is interesting to me because it seems to me, you must have a mathematical function /algorithm to produce the numbers associated with an airfoil surface, more over, many different airfoil surfaces :o
This range of mathematics would not be commonly available to most people.
Anyways... I think it is a great application of VBA coding and the marriage of Visio to a data source
Thankyou for sharing :)