Super MACRO 08 November 2017 Super MACRO topic

Super MACRO 08 November 2017

Super MACRO topic points… • Development • Assumptions • Best Practices • Basic Workflow Rules • Order of Table Entry • Future Developments

Development • Omega. PS as the LSAR tool – navigation by EIAC and LCN • Bulk data entry – time consuming due to multiple screen navigation, validation issues • GEIA-STD-0007 -B is XML driven, so scripts can be utilized • Provides analyst with more up-front time for research, analysis and data validation

Assumptions • Structure, RAM and FMECA data have been uploaded (first iteration of Super. MACRO) • Starting point is certain Tables already have data • With updated Super. MACRO minimal table population required • Wise to verify what Table fields have been preloaded before running the Macro

Best Practices • Instructions are quite well written - read, understand follow the instructions • Re-visit the Instructions occasionally, so that any nuance will not be forgotten • Back-up the LSAR before performing any major upload • If unsure of what Table data field is being populated, FIND OUT! • Be aware that once an “ADD” file has been run, a “CHANGE” file must be run to update or change any data. • Prudent to ensure no blanks or spaces are present in the “CHANGE” file, as this may overwrite good existing data.

Instructions

Basic Workflow Rules • Backup LSAR under analysis • Create a “Test” macro with 1 (or a small number) records • Test the upload file using the “Validate File” function • The “Validate File” MUST be performed prior to running the Macro. This checks the business rules; therefore, anything other than an “OK” MUST be rectified. • Verify data has been entered correctly & into the proper Table • ONLY after ensuring the process worked, repeat with full data set

Order Of Table Entry • AA HA CA BA • AB HF CB BD • AC HG CD BE • AG -- CG BF • -- -- **CH/XI** BH • -- -- CI XI Table needs to have Technical Manual entered before CH Table macro can be performed CL Table can be loaded anytime, but usually after MTA is complete, thus capturing all required C-W-N (Cautions-Warnings-Notes)

Future Development • Multi-Table macro • Allows two tables to be populated in one file upload • Currently the RCM and FMECA tables • Canadian Provisioning • Entry of weights & volumes, including Unit of Measure

Super Macro Demonstration

Questions?