En cours

PHP Script or Exe File to Organize Excel Data

I need a program created either as a web script or an EXE program. I need the script to take the data in any of the attached InvoiceReports files and split the data up for each representative. If you view the [url removed, login to view] file, I'll explain how each entry is made up. Each entry is two rows and nine columns.

Row 1 Column 1 - Client Name

Row 1 Column 2 - The word "Adjustment"

Row 1 Column 3 - The representatives name

Row 1 Column 4 - blank

Row 1 Column 5 - Staffed Hours

Row 1 Column 6 - Amount of Calls

Row 1 Column 7 - ACD Minutes

Row 1 Column 8 - Rate

Row 1 Column 9 - Amount

Row 2 Column 1 - The word "Memo"

Row 2 Column 2 - Memo information

Row 2 Column 3 - blank

Row 2 Column 4 - blank

Row 2 Column 5 - blank

Row 2 Column 6 - blank

Row 2 Column 7 - blank

Row 2 Column 8 - blank

Row 2 Column 9 - blank

I need the info from each two rows pulled and put into reports for each specific representative. So all charges for "Dallas Kirk" will go into one report which includes all that info, and so on. You can use whichever InvoiceReport that is easiest for you. After the data is put into the reports for each representative, I need our fee subtracted from the total which will be on an additional line. As you can see in the [url removed, login to view] image, our fee is either a percentage or a flat fee. Once completed, I need another report run with all the representatives names, the amount they made, and the amount that our IBO (Independent Business) made. These reports can be Excel Files, PDFs, or Word Files. If you create this as a web script, I would like the program to create a folder with today's date and then put all the reports under that folder.

If you have any questions, please feel free to ask before bidding.

Compétences : Programmation C++, PHP

Voir plus : php programming questions, php programming pdfs, php dallas, mockup web free, independent data entry, how to create free web, how to create free php, excel data programming, dallas php, dallas data entry, programming with excel, excel split columns, another word for data entry, web programming php, data entry representative, xlsx, web script, web exe, memo, flat line, exe, exe file, excel or word , split file php script, file split php script

Concernant l'employeur :
( 18 commentaires ) Kannapolis, United States

N° du projet : #2342339

Décerné à :

Karsticum

I can implement your excel manipulation task in python or php. I can start right now. No milestone payment required.

70 $ USD en 1 jour
(26 Commentaires)
4.3

4 freelance ont fait une offre moyenne de 109 $ pour ce travail

sureshdevi

I can create windows application to organize csv file in required format. I can complete this work in 2 days. Thanks, Suresh

64 $ USD en 2 jours
(660 Commentaires)
7.5
ZeusMan

Looking forward to working with you...

100 $ USD en 2 jours
(7 Commentaires)
3.8
baldok

Ok, no problem for me on this project. I can create it as a web script. Let me know if it's ok to start... Best reagrds

200 $ USD en 7 jours
(0 Commentaires)
0.0