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.