Shapes of Airfoil for Hand launched Glider

Started by JuneTheSecond, April 09, 2013, 10:53:44 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

JuneTheSecond

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.
Best Regards,

Junichi Yoda
http://june.minibird.jp/

JuneTheSecond

Best Regards,

Junichi Yoda
http://june.minibird.jp/

JuneTheSecond

Best Regards,

Junichi Yoda
http://june.minibird.jp/

vojo

Nice job!!!

So like should we now start to call you the virtual Orvil or Wilbur of the 21st century???

cliff50

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?

JuneTheSecond

#5
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.

Best Regards,

Junichi Yoda
http://june.minibird.jp/

cliff50

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  :)