Roofing Works Management Application
A works management program running out of Microsoft Access for use in the roof plumbing industry.
This software allows for the management of ongoing and archived work, as well as management of contractors, customers, employees, material items, labour items and suppliers. This application connects with Microsoft Excel to produce reports and client output data. This is software developed for one use case and was not developed for third party replication. The database layout is also featured in the slideshow below.
Electrical Industry Works Management Tool
A complete software solution for the management of electrical industry-based projects which was fully customised to fit the specific workflow and the clients of the client’s workflow. This program takes in bulk Excel spreadsheets and processes them, transforming them into a format which is then uploaded to a cloud MySQL database which was hosted within Amazon Web Services. This data could then be updated by workers remotely in the field. The technology which allowed this was PHP pages hosted on an Apache server within AWS – The remote workers would enter the data within a web application we developed. This allowed data to be summarised into useful information for decision makers, who could view summarised data and make workflow decisions from a Microsoft Access DB application. Upon project completion, the data was then exported in bulk to Microsoft Excel and converted to a zip file which was then sent to the client.
The main menu of the application which would users view upon logging into the application. The logging in of the application is handled within an embedded site within Access and PHP algorithms to handle the log-in process.
There are options for management of every stage of the workflow form importing of packs, data entry, reporting right through to production of bulk excel files within the specified client format. This application also used live data from SharePoint which synchronised the scheduling process for staff.
Pictured above is the bulk Excel workbook importing tool. This tool uses VBA code between Microsoft Excel and Access applications to redistribute and reformat the data received from the client in the correct fashion within the cloud database. This tool takes client Excel files and transforms them into data within the cloud which was then accessed and updated by remote users on mobile devices within the web app.
The scheduling function allowed for scheduling management for staff to be conducted either from the Microsoft Access application or from within internal SharePoint.
The two images above show one example of how data is exported in a very specific format to also send to the client.
Upon project completion, a series of invoice Excel documents are created and filed within dynamic folders and compressed to be sent to the client. This entire process is dynamic, scalable and fully automated. This reduced the previous workflow greatly.
The web app portion of the application was programmed in PHP.
The Microsoft and Access and Excel portions of the wider system were programmed using Microsoft Visual Basic for Applications and were made to be dynamic and scalable.
Electrical Industry Excel Billing Template
This billing template, which was developed from an Excel spreadsheet with automation being delivered via Visual Basic for Applications programming. This would process all data dynamically regardless of the volume of data within the workbook.
On the first sheet of the application is a large button to import and process a special sheet which contains data extracted from JotForm online form tool.
Selecting the import button causes a file picking dialogue to appear whereby the user can select the specialised data file they would like to be processed.
After choosing the correct file, the program will sort through the data based on programmed VBA parameters and rules. The sheet list shown above includes newly created dynamic sheets which appear once the import is complete. Upon completion of the import this various data can be used for external and internal purposes.
Pictured above is an excerpt of the VBA code which was used to power the functionality of this application.