We have a large pricing dataset in Excel. We need to allow our customers to manipulate the data making certain pre-specified charts and tables showing, for example, tables of optimal price points and price elasticity graphs. They need to be able to change the rows and columns of the tables and charts they create by pulling in various variable and applying filters. In theory Pivot Tables should provide all the functionality we need. But they allow too much 'freedom' to our clients. We need to modify the pivot table functionality so it is easier to use, produces standard charts every time and the whole thing needs to look great -- very inviting to use.
In addition to the scripting requirements (probably visual basic?) bidders will be better off if they have a decent understanding of statistics and pricing data (or similar) (our dataset is basically the outputs from a Van Westendorp analysis questionnaire)