CODING PROJECTS
Over the years, I noticed inefficiencies in our processes that I happen to know how to fix with code. Here's 2 examples.
AutoCAD Automation
Early on with Cisco-Eagle I began to think there were several procedures we did in AutoCAD that could be easily handled with a few lines of code. Well, a few hundred lines later and I accomplished several of my goals. But first I had to learn AutoLISP, a 38 year old language based on a 64 year old language. LISP, often called Lost In Stupid Parenthesis because of the overwhelming number of parenthesis required.
It was fun.
Enhanced Count Sheet
When I arrived at Cisco-Eagle, I found them using 3 to 4 copies of a spreadsheet so that each relevant person could count the hardware needed for a project, then someone had to compare these copies and reconcile the differences. I was able to build a single spreadsheet that could take in 4 separate datasets and do the comparison automatically. This made the process much cleaner and more efficient. I also threw in an automatically generated order sheet for the PMs.