-
Type
Web Application
-
Sectors
Employment, Staffing
-
Technologies
Javascript, PHP, CodeIgniter, MySQL
Using Excel to manage staffing solutions is a bad idea
Masa is a leading staffing solutions provider in South Africa, recognised as a labour powerhouse that places thousands of staff across the country. With a strong presence in both blue- and white-collar staffing, Masa serves corporate clients by providing efficient, large-scale workforce solutions. Their expertise lies in ensuring businesses have access to the right talent while managing the complexities of workforce placement.
As a company managing thousands of staffing placements across multiple industries, Masa relied on Excel spreadsheets to track shifts, rates, and client-specific requirements.
Why Masa Needed a Custom Solution
Using Excel to manage complex data and flow processes may have seemed like a smart choice, however, this approach led to significant inefficiencies:
Data Sharing Limitations: Excel files were difficult to manage across departments, leading to information silos and security risks.
Manual Calculations: Payroll, rates, and timesheet calculations were time-consuming and prone to human error.
Inefficient Workflows: Staff had to manually generate timesheets for each employee, creating unnecessary complexity.
Security Concerns: Sensitive data was either fully shared or inaccessible, with no granular control over permissions.
These inefficiencies resulted in wasted time, errors, and an overall lack of scalability. Masa needed a tailored software solution to automate and optimise their workforce management process.
The Fix: A Tailored Web Platform Built for Efficiency.
To address these challenges, Masa partnered with Elemental to design and develop a powerful, custom web-based platform that streamlined staffing operations. The solution was built from the ground up, incorporating industry-specific functionality to ensure a seamless transition from Excel-based management to a more structured and automated system.
Key Features:
Role-Based Access & Permissions: Multiple user types with specific permissions to control access to data and functionalities.
Efficient Data Capture & Management: Quick creation of records such as employee timesheets, with duplication and template upload features to save time.
Error-Detection & Previews: Validation mechanisms to highlight potential issues before data is finalized.
Secure Data Management: Granular control over who can access and modify specific data, reducing security risks.
Automated Calculations: Cost, leave, and charge calculations are performed automatically, improving efficiency and accuracy.
Seamless Data Export: Payroll-ready reports generated in the correct format for administrators without direct system access.
Custom Reporting & Summaries: Consolidated data presented in an easy-to-interpret format for better decision-making.
The platform was designed with future scalability in mind, allowing for further feature development and third-party integrations as needed.
Do you need the services of a solid web development agency?
Companies around the world choose Elemental as their tech partner for the design and development of custom websites, web apps, software, and mobile apps. We work with businesses of all sizes, from agile startups to well-established enterprises, to bring their ideas to life. Let's discuss your vision and explore how we can turn it into reality.
Transforming Operations With a Bespoke Web App
While specific quantifiable data is unavailable, the implementation of the custom web application brought significant operational improvements:
Faster Processes: Data capture and reporting became significantly quicker, reducing time spent on administrative tasks.
Enhanced User Experience: Employees found the system more intuitive and efficient, improving overall satisfaction.
Reduced Errors: Automated calculations and approval processes minimised human errors.
Improved Security: Data sharing controls ensured that sensitive information was only accessible to authorised personnel.
Future-Ready System: The platform was built to accommodate future functionality, integrations, and expansions as Masa’s needs evolve.
By replacing an outdated, manual system with a robust, scalable web application, Masa was able to enhance efficiency, reduce administrative overhead, and improve workforce management. This case study highlights how a well-structured digital transformation can lead to significant operational improvements, positioning businesses for long-term success.
INTERESTING FACTS
There are various user roles which each play a vital role in the process of capturing times. The timesheet has complex functionality to ensure data is always captured accurately - for example:
-check if times overlap
-check if hours captured make sense
-check if too much overtime was was captured
-warns users if changing the shift for a day that already has data captured
-warns users if changing the employee for the given week.
The system also show the total hours captured and the charges that it amounts to.
CHALLENGES
When it comes to staffing, we needed to create the web app to be as flexible and robust as possible to cater for all the different scenarios that happen in the real world.
A complex challenge for us was to incorporate how overtime, night shifts and public holiday rules would apply to captured timesheets and to the accurate calculation of costs and leave.
Luckily this wasn’t our first rodeo and through trial and error, we were able to get this to work to the client’s exact expectations.
Do you need the services of a solid web development agency?
Companies around the world choose Elemental as their tech partner for the design and development of custom websites, web apps, software, and mobile apps. We work with businesses of all sizes, from agile startups to well-established enterprises, to bring their ideas to life. Let's discuss your vision and explore how we can turn it into reality.
Zeal Surf