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.
34 freelances font une offre moyenne de 853 $ pour ce travail
Hi there, ★★★ PHP / MySQL / Excel / VBA / Macros Expert ★★★ 5+ Years of Experience ★★★ I've read requirements and ready to create web app for 2 x macro enabled Excel Spreadsheets. I provide complete ranges of solution Plus
Hello, I have reviewed your requirements, and I believe that with my experience and skills, I can deliver to you as per your expectation. i have been working with USA base company, onwards i'm available full time for Plus
Hi, I just read your job posting and it sounds like you need MySQL, PHP, Excel, Excel Macros and Software Architecture. I am a senior developer and have been working in this field 4+ years. I'm very interested in your Plus
Senior PHP, Mysql expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anti Plus
Hi, there. My name is Alik and as you can see my profile, I am a tailent developer. I read your description carefully and I analyzed your requirements. As a excellent developer, I’ve been working for 10 years perfect Plus
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 Plus
I can convert your Excel/VBA spreadsheets to PHP/MySQL. I have experience with PHP, MySQL, Excel, Macros.