We have a specific need to take data from an SQL Server and create a series of Excel reports - using templates. Then email the generated files to a number of people as per a configured list in a database (some people get some/all reports). The number of rows per section will be dynamic so the solution needs to be clever and not be too rigid.
The solution must be delivered as a stand alone class that can be initiated and run. Configurable options in the [url removed, login to view] must be:
1. The templates location
2. The Database connection string
3. The file output location (for temp storage)
You will be provided with sample reports (drafts attached) and a sample template but you would be expected to work out all calculations, SQL queries and coding challenges to complete the work.
Solid documented code is required.
We would need a test release within 7 business days of project award with a further 5 in duration to complete any bugs. 2-3 one hour code walk throughs should also be planned for (in English).
This project is complex and is best suited to those who have demonstrable experience in a similar task - so please describe a similar project using C# and Excel you have completed. Those without specific experience will not be considered.
These are the reports that will be required. One template for each. And each can be emailed to indviduals.
Detail by Region
Performance League Table
Internal calls - top calls per week by duration
External Outbound - most frequent numbers per week. Cumulative per week by duration.
Daily abandoned calls report