• Corpus ID: 24556932

Transforming Critical Spreadsheets into Web Applications at Zurich Financial

@article{Dewhurst2010TransformingCS,
  title={Transforming Critical Spreadsheets into Web Applications at Zurich Financial},
  author={Sebastian Dewhurst},
  journal={ArXiv},
  year={2010},
  volume={abs/1009.1407}
}
In the insurance industry, spreadsheets have emerged as an invaluable tool to for product pricing, because it is relatively straightforward to create and maintain complex pricing models using Excel. In fact, Excel is often preferred to "hard-code" whenever there are frequent changes to the calculations and business logic which under-pin the pricing of an insurance product. However, problems arise as soon as spreadsheets are deployed to end-users: version control, security of intellectual… 
1 Citations

Figures from this paper

Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function
TLDR
Even without a corporate mandated effort to improve spreadsheet controls, finance functions can take simple yet effective steps to start managing the risk of errors in key spreadsheets by strategically selecting controls that complement existing user practice.

References

SHOWING 1-7 OF 7 REFERENCES
A New Approach to Spreadsheet Analytics Management in Financial Markets
TLDR
This paper focuses on the rapid creation and centralised deployment of statistical analytics within a software system now in use by major investment banks, and presents a novel technique for the manipulation in spreadsheets of high volumes of intraday market data.
Enterprise Spreadsheet Management: A Necessary Good
TLDR
This paper presents the arguments and supporting business metrics for Enterprise Spreadsheet Management to be seen as a necessary good and the good that may be delivered to business spreadsheet users involved in repetitive manual processes.
Making the Leap from Spreadsheets to Models " , http://tdwi.org/articles/2009/08/12/qa- making-the-leap-from-spreadsheets-to-models.aspx 3:45pm
  • Making the Leap from Spreadsheets to Models " , http://tdwi.org/articles/2009/08/12/qa- making-the-leap-from-spreadsheets-to-models.aspx 3:45pm
  • 2009
“ Making the Leap from Spreadsheets to Models ”
  • 2009
Improving Productivity by Managing Technical Expertise
  • DCI Conference
  • 2003
Taming the cells: automated spreadsheet control can help insurers breeze through regulatory compliance standards
  • Taming the cells: automated spreadsheet control can help insurers breeze through regulatory compliance standards
  • 2006
A Streamlined Approach to Knowledge Capture, Retention and Communication for Wind Turbine Suitability Analysis
  • 2nd International Conference on Knowledge Generation, Communication and Management
  • 2008