Is this even possible?

Soldato
Joined
19 Jan 2005
Posts
2,722
My 3rd year mech eng project is to develop a program which, on an input of a design of a wing shape and using the input of material data, can produce accurate representations of the shape and analyses of the suitability so its Yield Stresses and things of that nature.

I have to do this in Excel using VB, I did my A level computing in VB so I have some knowledge of using VB not in Excel.

Is what they're asking possible? I'm mainly confused about an input and display method for a wing shape. Can Excel plot somethin along these lines?

Sorry if its not very clear, would appreciate any help though.
 
At the moment my limit of coding prowess seems to be gettin any series of numbers plotted in a normal bar chart but even then I cant see how a curved section of wing can be represented in any less than a hundred or so coordinates to gain an accurate picture of it. I dunno, have to just keep goin with it.

Anyone done anythin remotely similar?
 
Being a physics grad i'd be inclined to use something like FORTRAN and the Dislin graphics library. Rather than Excel...
 
Last edited:
VB and Excel? :(

Wouldn't something like MATLAB be a little more suitable?

Also, by 'a design of a wing shape' do you mean a 3D model? If so, it's going to be rather too complicated to do in VB and Excel I think.
 
Last edited:
Do you want to do it for all aerofoil geometries i.e. specify chord length, thickness, camber etc. Or for generic wing shapes e.g. the NACA series?

Also if they want you to do it in VBA then its best to do it in VBA. You could generate the aerofoils geometries as graphs and then work out lift coefficients etc. Any more info on what they expect you to do? (I'm a 4th year Aero Eng Student btw...)
 
Back
Top Bottom