2066. Farid Program: Streamlines Spreadsheet Database to Satisfy All Required Weight Section Output

Paper

Abstract

The stage is set. The contract has been awarded and the preliminary design accelerates. Technical reviews and presentations abound while timely weight reporting remains as a sustaining requirement – unfettered by additional time restrained requirements. Time management becomes crucial for completing each managerial milestone. Time management becomes crucial for finding time needed to effectively control weight reflected in all output. This paper presents a ”case study” solution for this early design challenge. The solution presented is an automated LOTUS spreadsheet macro program called FARID combined with linked spreadsheet worksheets and charts. It has become a successful tool in achieving all weight resource goals and objectives. This paper will show an effective way of producing report tables and charts, viewgraphs, output to other disciplines, and output for internal weight optimization studies. Each is derived from a single database and the tool to achieve this is orchestrated with minimal effort and will eliminate error which could be created from repetitive work. This paper is not a solution to controlling weight but a tool to allow better command of it. The paper will not provide a definitive method but will open a series of possibilities for the time constrained engineer.