Actuaries Utilize Pagos SpreadsheetWEB to Develop Web-Based Modeling Tool for Insurance Advisors and Brokers to Analyze Employers’ Costs under the Health Care Reform

Share Article

SpreadsheetWEB helped Verisight to transform their sophisticated spreadsheet based models to estimate future costs under key Patient Protection and Affordable Care Act (PPACA) provisions into complete web-based applications.

SpreadsheetWEB Verisight screenshot

Pagos provided us the technology and business support solution that “checked all the boxes” of providing our spreadsheet based consulting applications to a much broader marketplace in a manner that made sense for our clients and customers.

Under the PPACA, employer sponsored health insurance benefits for employees must meet certain minimum standards for plan affordability and features, or employers will face “penalties” starting in 2014. Health actuaries from Verisight, Inc. developed several sophisticated spreadsheet based models, in order to analyze employee profiles and employers’ current plans. Verisight actuaries decided to make these models available to the middle market brokerage community for a fee. While they wanted to provide advisors the option of executing the models themselves, Verisight also wanted their intellectual property protected. Tracking each advisor’s usage of the model was also necessary, in order to accurately charge their customers. Therefore, providing direct access to the spreadsheet models was out of the question.

Verisight identified SpreadsheetWEB as the optimal technology solution in the market that met all the requirements. Using SpreadsheetWEB, Verisight actuaries were able to deploy their spreadsheet models to insurance advisors and brokers efficiently and affordably.

Since the solution was deployed on Pagos data centers and fully managed by Pagos, Verisight was freed from both the hassle of dealing with the technology required and maintaining an IT team. They could concentrate on their core competencies.

Having balanced the comprehensive modeling capabilities with ease-of-use and affordability, along with the tremendous need in the market, the solution quickly achieved a very high adoption rate in the brokerage community. Due to built-in scalability features, Pagos was able to add new server capacity as needed, to handle the growing number of users with no break in service.

In addition, Verisight’s actuaries were able to take over the maintenance of the SpreadsheetWEB system after the initial deployment. Adjustments are made on the models as needed and the applications are then republished through SpreadsheetWEB’s administrative interface. In most cases, this process can be completed within hours and without further assistance or IT support.

Verisight Managing Director and Health Actuary, Brian Blalock stated, “We recognized the opportunity of providing the insurance advisory community with helpful tools necessary to add value to their employer clients. Pagos provided us the technology and business support solution that “checked all the boxes” of providing our spreadsheet based consulting applications to a much broader marketplace in a manner that made sense for our clients and customers.”

About Pagos, Inc:

Pagos, the makers of SpreadsheetWEB, is a leading technology and IT services provider, delivering software solutions and IT consulting services to clients in various industries. SpreadsheetWEB is a groundbreaking software package that allows non-technical business users to create, maintain and manage complex, enterprise-level, web-based applications. Pagos is located in Cambridge, MA. For more information, visit http://www.pagos.com.

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Ugur Kadakal
Pagos, Inc.
(860) 674-9100
Email >
Visit website