Contains Python Console App and VBA Excel Macro
Macro reduces the generation of payment certificates to its raw inputs. Useful for users having low desire to adopt new technology.
Python console app does the same with added features such as:
- Remembering users
- Searching existing contracts and sub-contractors
- Automatically fulfilling known information
- Automatic signing
Identified that the creation of payment certificates had automatable components and was prone to human error.
Self-taught VBA to develop a macro that standardized the certificate and reduced human interaction to the fundamental inputs with smart prompts and error checking.
Implemented the macro through multiple mediums, reducing human interaction by 66%.
Further realised automatable components through python console app.
- Minimises Human Interaction
- Reduces Human Error