My company repairs customer equipment. My company's software exports a report to excel. The report produced is a list of equipment by customers zip code. The report is not organized and first needs to be sorted by sequential zip code. The customer information is included with the report. I want to be able to import the data to an excel spread sheet or other program, access, my sql or what ever is easyest that sorts the equipment by zip code.
I want be able to assign a tech for each piece of equipment. I then want to be have a maximum number of pieces of equipment a tech can be assigned. When a tech is at 5% under or over the max, the tech cell is green. When a tech is at 6-15% over the max, the tech cell is yellow. When a tech is at 16-20% over the max, the tech cell is red. When a tech is at over 21% the max, the tech cell is black with white letters. I should also be able to adjust the report so it list the tech as the header and list each customer & their equipment assigned. A sample is attached. I will pay when I get my spread sheet. My last project a down payment was given and I never heard back from the tech.