I have 2 x excel spreadsheets here that are used to calculate pay rates for drivers based on where they drive etc.
The main spreadsheet itself is only 127kb but has a pile of macros etc, then there is a driver timesheet spreadsheet (108kb) which has the rates for each run (no macros in this one).
What we want to do is get rid of Excel altogether and create a new web based (php) frontend with MySQL to run the whole process instead.
What we need is a an excel expert who can decipher all the macros and convert them to php/mysql queries and design a new http php based front end for the payroll operator to use instead of excel.
I will create and give successful applicant the mysql hosting space and php space info/passwords for hosting on for dev (if required) and ultimately for production.
Ive added a few screen shots of the current excel spreadsheet below to show what it looks like.
The payroll operator currently does the following :
1 / Import Data - This imports data from a MS SQL database (driver info / employee ID / email address etc)
2 / Edits and selects Driver spreadsheets / trips descriptions by selecting drop downs for each driver
3 / Report Check
4 / CSV - outputs to csvs to re-import back into payroll system
5 / emails to drivers
We need to have all functionality of current excel spreadsheet redeveloped and working in mySQL/PHP.
Bu iş için 34 freelancer ortalamada $853 teklif veriyor
Hi [login to view URL] Availability: 40+ hours/week. Ready to start work immediately. The coding is just my life. As you can see from my profile, I have worked several companys. so I have rich experience web development. If you a Daha Fazla