Dibatalkan

Convert 2 x macro enabled Excel Spreadsheets to PHP/MySQL with new frontend

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.

Kemahiran: PHP, MySQL, Excel, Kejuruteraan Perisian, Excel Macros

Tentang Klien:
( 11 ulasan ) Hampton Park, Australia

ID Projek: #34348407

34 pekerja bebas membida secara purata $853 untuk pekerjaan ini

(179 Ulasan)
9.3
(125 Ulasan)
9.3
(241 Ulasan)
8.8
(371 Ulasan)
7.8
techplusintl

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 Lagi

$750 AUD dalam 7 hari
(294 Ulasan)
7.9
(81 Ulasan)
7.7
creativeitechpvt

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 Lagi

$600 AUD dalam 4 hari
(155 Ulasan)
6.9
webmaestro2013

Hi Before bid on this project, I read requirements and looked at attached screen shot about timesheet , reports etc, I will complete this job successfully. I know PHP, MYSQL, AJAX, javascript , jquery , css, html ve Lagi

$650 AUD dalam 20 hari
(206 Ulasan)
7.1
(50 Ulasan)
6.8
(36 Ulasan)
6.4
(40 Ulasan)
6.2
(65 Ulasan)
6.0
(39 Ulasan)
6.0
vasylivanovych

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 Lagi

$500 AUD dalam 7 hari
(5 Ulasan)
5.6
merinsinha

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 Lagi

$600 AUD dalam 7 hari
(173 Ulasan)
5.9
AlikAgaian

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 Lagi

$750 AUD dalam 7 hari
(19 Ulasan)
5.7
veljkodimcic111

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 Lagi

$500 AUD dalam 7 hari
(10 Ulasan)
5.8
(34 Ulasan)
5.7
(110 Ulasan)
5.8
rylkov

I can convert your Excel/VBA spreadsheets to PHP/MySQL. I have experience with PHP, MySQL, Excel, Macros.

$750 AUD dalam 30 hari
(86 Ulasan)
5.8