Automation by VBA in Excel
Developed algorithm and coding in Visual Basic for Application for the following calculations/schedules:
- Complete Cable sizing and reports preparation based on available vendor data and sizing criteria.
- Tray Sizing, Trench Sizing, DRUM sizing report.
- Interconnection Diagrams, Trouble Shooting Diagrams in excel.
- Cable Schedule.
- Various BOM i.e. Gland BOM, Conduit BOM etc.