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-day, two-person, labor-intensive process (that wasn't enjoyed by anyone) to a 5-10 minute process. At the end of the day, the professionals who 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.