I sell an issue tracking system with a lot of data about tickets. Such as
Hours worked, Hours open, Rate, Caller category, Date, Priority, Problem category, Responsible handler, weekday etc.
Right now I have built a report generator that supplies 16 pre-defined reports that the user can customize and add to. The report generator works well. However there are a few problems
1. It is slightly complex to get started with
2. It doesn't do printing well
3. It is built using the Office Web Components, which are no longer included in Office 2007.
Thus I am looking for someone who can build at least 16 advanced pivot table report in Excel one Excel template that would replace my existing report generator tool. The issue tracking system outputs a .cub file which is to be used as a datasource. One report in the report generator consists of a graph and a data table. To replace this functionality the Excel template will most likely need to contain at least 32 tabs. The pivot-tables should not be connected to each other. Thus changing a filter etc in one should not affect the others.
Since the issue tracking system is sold in 12 languages the Excel reports also needs to be properly translated to all those languages. I suggest that this should be done by a script (perhaps with some hands on work too make sure it all looks right)
I am looking for a very nice modern (Excel 2007) look to these reports so I would like bidders to supply samples of Excel reports they have done in the past. We will supply grahics as needed.
You will find the reports and report engine I currenty use attached. Please unzip all of them to a new directory and run the .exe.
## Deliverables
1) 1 Excel template compatible with Excel 2000 - 2007 with all language strings written as constants. The templates should not contain any VBA code
2) VB 6 or VBA code snippet that will do set the data source for the pivot tables
3) VB 6 or VBA code that changes all the constants in the template to the correct phrases for a specified language. We will supply translations.
4) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
5) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
6) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
7) I will expect daily reports sent via email during this project
8) Bidder will be online and communicative using Skype during every hour of work done for me.
## Platform
Excel 2000
Excel XP
Excel 2003
Excel 2007