HardHat Workforce Solutions Converted their Excel-based Rate Calculator into a Web Application with No Code
The Challenge
HardHat Workforce Solutions built their rate calculators in Microsoft Excel since it provides them the ability to build complex calculators in an easy and straightforward manner. Originally, Excel was able to meet their business requirements. It also introduced challenges, such as ensuring that everyone is using the most up-to-date spreadsheet, questions about data security, and limited mobile access.
"For our particular calculator, we had some needs that were fairly complicated, including several VLOOKUP, IF/THEN, and CHOOSE formulas. I think the combination of meeting some of those requirements led us to Excel. For a short period of time, Excel was the perfect tool for us. Then, we wanted to build something that felt more professional than Excel, but still maintained similar capabilities. We decided to look into platforms that would allow us to solve those issues and take us to the next level".
The Solution
HardHat started looking for a different No-Code solution to easily move their rate calculator to the web platform. Before SpreadsheetWeb, they evaluated different options to help them solve their needs, but those products were not able to meet their needs for a few reasons. They came across SpreadsheetWeb through online research while trying to find a platform that specialized in web-based Excel calculations.
"The main thing with SpreadsheetWeb was preserving the ability to use a low code platform while using Excel as your supporting resource. We wanted to be able to easily make changes to the underlying excel on a frequent basis and have them easily populate into the calculator on our web-based version. SpreadsheetWeb allows us to do that. The other platforms would have been a little bit more intensive. I wanted something that was easy where I could just plug and play."
The Results
HardHat Workforce Solutions was able to build a secure online rate calculator without any programming, while keeping their Excel spreadsheet as the underlying support for their SpreadsheetWeb application over just a few hours. The SpreadsheetWeb team extended their help to make some formatting changes for the application and help out with some finishing touches.
"We created a quick application without any formatting just so that I could show the capabilities to our management team. Once we decided to go with SpreadsheetWeb, the SpreadsheetWeb team walked me through changes on the fly. I asked for additional changes via e-mail and they were able to make those within a day or so."
