Demos: Typical Applications

The following demo applications give a first idea of what Pagos Spreadsheet Component is capable of. The true power of the Spreadsheet Component lies in its ability to create stand alone application quickly even from very complex Excel-based business solutions.

The code of each demo applications is available upon request. Please send an email to support@spreadsheetcomponent.com

Each demo is categorized under a specific industry:

• Accounting
  
• Banking and Finance
  
• Insurance
  
• Real Estate

Accounting

Order Form: In order to be competitive, most companies need to offer their customers creative, often complex, pricing options. Volume discounts, periodic promotions, special customer discounts, are among many pricing options companies offer their customers. It is also crucial to give customers the most competitive price as quickly as possible. Most companies build spreadsheet models to calculate product pricing for their sales people. This demo shows how a medium size company can use PSC to convert a complex Excel based pricing model into a web based order form.
See demo application

Expense Reporting: Accounting departments in companies of all sizes need to manage employee expenses. Traditionally, most companies use spreadsheets to collect and manage expense reports because of its simplicity and flexibility. Spreadsheet software allow finance professionals to incorporate various rules and calculations. This demo demonstrate how a typical travel expense form developed in Excel can be converted into a web form using PSC. With a web based form, employees can access and submit their expenses from anywhere while accounting departments maintain the control by keeping it in Excel.
See demo application

Balance Sheet: Excel is one of the most common applications used by accountants. In medium to large companies, financial departments need to collect and process data periodically from various departments through Excel files that incorporate not only data collections features but also rules and calculations. Finance executives need to run that data through complex revenue and expense forecasting models. Using PSC, developers can integrate those Excel models into enterprise budgeting applications without loosing the flexibility of using Excel.
See demo application

Banking and Finance

Risk assessment applications: Banks frequently develop Excel based models to assess the risk in loan applications through scoring algorithms. Those applications are usually very complicated. Hence rewriting them would be extremely time consuming. Preserving them in Excel format also provides the business units with control of modifying. Those Excel applications can be integrated with intranet and internet based enterprise systems as they are through using PSC.
See demo application

Retirement Calculator: Implementation of a typical retirement calculator used by financial services companies specializing in retirement products.
See demo application

Consolidated forecasting: Finance executives in companies having multiple business units or subsidiaries have to go through a tedious process of collecting financial data periodically from each unit. Data is often collected in Excel format because of its flexibility. Finance departments then consolidate the data, perform what-if analysis and evaluate possible financial scenarios. The whole process is based on Excel applications developed and maintained by finance departments. PSC can be used to develop web based applications to streamline this time-consuming and manual process without loosing the flexibility provided by using Excel.

Insurance

Web based rating and quoting applications: One of the most difficult parts of developing an insurance rating and quoting application is to code rating algorithms and business logic. Actuaries often develop and test their algorithms in Excel. Using PSC, developers can connect those Excel models into their applications by eliminating time consuming and expensive rewriting process.
See demo application

Automated Underwriting applications: One of the biggest challenges in building an insurance underwriting system is to implement the complex underwriting rules in a way that can be modified by the business units to keep up with the ever changing market conditions. Excel has been a common tool for underwriters and actuaries to build those complex underwriting rules. PSC eliminates the need to rewrite those complex rules by allowing developers to integrate those Excel rules engines into their applications as they are. As the rules still reside in Excel, business units can modify the rules as needed.
See demo application

Real Estate

Mortgage Calculator: Mortgage calculation is one of the most common calculators used in the real estate and financial services industries. This mortgage calculator is converted using Pagos Spreadsheet Component from the following Excel file.
See demo application

Seller Net Value Calculator: Considering all taxes and expenses, it is sometimes difficult to estimate the net value of your real estate. Rules and regulations on local and federal taxes make these calculations even more difficult. Excel is frequently used to incorporate such complex calculations and rules in the real estate industry. This calculator is built to estimate net value of a real estate in New York City.
See demo application

Commercial Real Estate Mortgage Qualifier: In a fast pace world, real estate agents need to have the right tools in the right moment. The ever-changing variables of the real estate marketing make it difficult to for the research team, the programmers and the sales team to synchronize latest data and information. Spreadsheet Component helps to reduce programming efforts significantly with the effect that changes in the market can instantly be integrated into sales team applications. The way it works: The research team integrates new data into the Excel engine, the programmer quickly creates a new application with Spreadsheet Component, and, finally, forwards the application via the web to the sales team.
See demo application