This project requires a developer to migrate an existing internal spreadsheet solution to a web based database. There is currently a spreadsheet per site and each site varies in the number of areas, staff etc so this must be able to be customized by administrators
Users need to be authenticated and then can submit daily trading figures.
The system must be able to capture and report changes made by users
Data input restrictions need to be in place
Admin staff can lock data once verified so that users cannot resubmit / change
Management need to be able to run basic reports based on the site and date range.
Basic calculations used in the spreadsheet solution need to be displayed in the reports i.e in spreadsheet users from each site enter figures in each day and this is calculated to produce a weekly summary per site
Administrators will be able to create, edit and delete new sites, bars, users etc
There is one additional sheet that needs to be added also that is similar to the Keno tab.
Have attached existing spreadsheet with dummy data to indicate what the site is to replicate.