Our job tracking system generate an excel file of all the job data. We would like to use excel pivot table, graph and some basic programming to make the data more visually easy to know the status and in printable format. 1) The data is generated from a job tracking system and will be written to a file every 4 hours. All the pivot chart or pivot table is generated from 1 data source file. Currently, the data is inside a tab. The final version will be in an excel file with the same name. The report excel file can use a different name. 2) The users are not excel expert. Different people will get different excel with different tab(s) depending on their role. 3) The report should be easy to see and printable in A4 paper format. 4) Certain filter should be in the form of pull-down. 5) To minimize columns in the report, we would like to use different color font or shading to show things like Process Status (ex: color the font green to show process has been completed, yellow for pending and red for not completed). 6) Possible to press a button to refresh the report? The reports are of the following: 1) All open job 2) Open Job Sticker & Inkjet 3) Open Job Name Card 4) Open Job Digital Printing & Oth 5) Process Consolidation 6) Open Job by Supplier 7) Completed Process Supplier Month
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
excel 2007