Advanced Excel VBA Roster and Pay Calculator
Budget: $1,500 – $3,000 AUD
I'm in need of an Excel VBA specialist to create an easy-to-use workbook for data entry and validation purposes. This application will require the following features:
- The ability to enter random rosters
- Setting of pay parameters including different percent premiums for various shifts, such as afternoon (15% loading), night, Saturday, Sunday, Overtime and Public Holidays
- Automated calculation of payroll based on the defined parameters and the entered roster
The perfect candidate will have a solid understanding of Excel VBA programming, especially in creating automated calculations and formulas, as well as report generation. Familiarity with payroll calculations would be a great plus.
This is a straightforward project for an adept Excel VBA coder. I look forward to seeing your bids.
- The ability to enter random rosters
- Setting of pay parameters including different percent premiums for various shifts, such as afternoon (15% loading), night, Saturday, Sunday, Overtime and Public Holidays
- Automated calculation of payroll based on the defined parameters and the entered roster
The perfect candidate will have a solid understanding of Excel VBA programming, especially in creating automated calculations and formulas, as well as report generation. Familiarity with payroll calculations would be a great plus.
This is a straightforward project for an adept Excel VBA coder. I look forward to seeing your bids.