I need a weight engineering database , used to keep calculate the total weight , CG and Inertia of an Aircraft . It must be able to also have different codes in order to be able to create su-assemblies and sub-groups, for these su-assemblies and su-groups it must be able to add up the total weight and work out the CG and inertia.
I have attached a file that shows some of the applications , I needed to shorten the file and remove some of the formulas so as to make it small enough to be uploaded.
This program should also be able to keep control of weight reduction .. see right hand side part of spread-sheet .
The cost should include all necessary source codes for patenting program and for possible future up-dates.
I will make all formulas required available ..
Also the Aircraft is initially broken up into major assemblies , later into smaller assemblies and so on upto the last rivet is accounted for. Each of these components will need to be in a database where the weight of each is recorded and later when an assy is created , the quantity and CG of each or group is added ./ The inertia is initially worked out as a shape and position , later it must be able to be addedat assembly level the as teh detail becomes more available , must be able to be added for each component or set of components.. (eg rivets (500 off) etc.
Weight reduction must be able to be kept as a document number , with it relative other company identification number , must be able to linked to a component or item as required and must have a estimated weight and an achieved weight reduction.. (or possible weight .. achieved weight)
I would prefer this program, to be in a ACCESS database unless I can be convinced that another system would give me a better result.
Graphs must be able to be created by creating queries.... etc
More info available on demand ..
thank you .