The objective of this project was to create a tool through a Wordpress plugin that would allow security line installers to calculate the characteristics of an installation using a web form added to an existing Wordpress page.
The company provided me with a spreadsheet that listed a series of parameters that were necessary to carry out an analysis to determine the appropriate product. The sheet also contained the arithmetic formulas necessary to perform the calculations.
I completed the project in 3 steps:
- Create a password-protected Wordpress page with a form to collect the necessary parameters for the calculation, and validate them before passing them to the next step.
- Convert the spreadsheet formulas into PHP code that could be executed on the client's server and calculate the result.
- Present the results on screen and also in PDF.
As an additional step, I programmed a section inside the admin panel (wp-admin) to save the results and show a log, where management could review the generated calculations, see the errors and view the generated PDFs.
With this plugin the company has been able to offer a service to its installers in the field, and to their customers - who can review the system needed for the job they are planning in real time.