Synygy
I built the tool I wished the process had.
A monthly process asked every employee to fetch their own payment details from the company's intranet, then complete an invoice by hand.
I built a VBScript inside the Excel template that did both: it retrieved each employee's details and completed their invoice, which until then was filled in by hand.
The technology was simple. The useful part was recognizing that the process itself didn't need to remain manual.
By hand
- Fetch the payment details
- Complete the invoice
replaced by
In the template
Retrieves the details and completes the invoice