Agents of America Financial Calculators |
 Application exposes a set of 17 calculators for the insurance annuity market segment |
| E-enabling of 17 MS Excel based spreadsheets and converting them into web based calculators |
| Integration of calculators with the eBD content management platform for seamless data exchange |
| MS Excel as a “web server” through the use of the Spreadsheet Gear component |
| Integration of Crystal Reports with the application for reporting purposes |
| Leveraging the Crystal Reports PDF output function to allow printing of output as generated |
| Seamless data transfer to and from the hosting server |
---------------------------------------------------------------------------------------------------------------------------
|
| Additional Details |
| Title |
Agents of America Financial Calculators |
| Status |
Deployed |
| Client |
Agents of America, Pembroke Pines, Florida, USA |
| Industry |
Insurance/Finance |
| Description |
Web Based for Annuity Calculators for the Insurance Industry |
| Type |
Web Application |
| Developed With |
Microsoft ASP.NET |
| Database |
No Database |
| Architecture |
2-tier Session Based Web Application |
| Hosting Platform |
Dedicated MS Windows 2003 Server |
| Other |
17 calculators completed. Application under User Acceptance Testing |
---------------------------------------------------------------------------------------------------------------------------
|
| Access Info or URL |
| http://u15191141.onlinehome-server.com/aoa/lis |
------------------------------------------------------------------------------------------------------------ |
Third Party Component Integration |
| Component |
Active-X DLL Plug-in |
| Name |
Spreadsheet Gear for .NET |
| Functionality |
Microsoft Excel compatible spreadsheet component for MS .NET that allows user to leverage all of MS Excel functions in a web environment |
| Details |
Please visit www.spreadsheetgear.com |
--------------------------------------------------------------------------------------------------------------------------- |
| Component Type |
Active-X DLL Plug-in |
| Name |
Crystal Reports PDF Writer |
| Functionality |
Allows the creation of PDF Output directly |
| Details |
Please visit www.crystalreports.com |
---------------------------------------------------------------------------------------------------------------------------
|
| Highlights |
| - |
Integration of Spreadsheet Gear with the application presented initial technical challenges that required a high level of creativity to overcome specifically for proper transfer of data from the front end to the excel based backend |
| - |
Integration of Crystal Reports with Spreadsheet Gear required data fetching cell by cell in order to produce the proper reports – queries had to be developed that obtained data individually from each cell |
| - |
PDF output using the Crystal Reports engine was highly dependent on the eBD server configuration |
| - |
Integration with eBD server presented a major challenge due to eBD’s custom configuration. However, we worked with eBD to resolve these issues and resulted in a successful application |
|
