Using powerful 3rd party Excel library and Microsoft Excel itself, we've build and provided a dynamic web-based fee calculator hosting in the current website using role based and page based security and more. Technology used: Microsoft Excel, Spreadsheet Gear (spreadsheetgear.com), IIS, and ASP.Net.
Automation reduces a two days, two person, labor intensive process, which wasn't enjoyed by anyone, to a 5 to 10 minute process. At the end of the day, the professionals that used to gather, organize and build the presentation were freed up to do other things. The technology used: Microsoft SQL Server, Microsoft Task Scheduler, Microsoft SSIS, Datawatch Data Pump, Microsoft VBA, and Microsoft Excel.