All topics

I am building up a library of notes on topics related to risk management frameworks in the financial services industry, operational risk and user-developed software. They are grouped by theme; a single note might belong to several themes.

Good software

• Criteria for good software • Correctness • Usability • Maintainability • Usefulness • Availability • What is a bug? • Performance • Spreadsheet error rates • The true significance of bugs in spreadsheets

Spreadsheet errors

• Nevada City budget problems • TransAlta Corporation • Pasting error • Project financing spreadsheets • Kodak earnings restatement • Fannie Mae $1.2bn honest mistake • Provident Financial modelling problem • Spreadsheet error rates • What is a bug? • RAND() in Excel 2003

Risk management

• Risk management process • Risk maps • Risk indicators • Risk identification • Enterprise risk management • Risk classification • The FSA and risk based capital • Operational Risk • Future regulation of insurance briefing • Financial Services Authority

Excel techniques

• Defining Names • Lookups in Excel • Using Names in charts • Dynamic Ranges • Using Names for formulae • Names can be local to worksheets • Bookmarks in Excel • Statistical functions in Excel 2003 • RAND() in Excel 2003

Software Engineering concepts

• Abstraction • Modularity • User-developed software • What is a bug? • Spreadsheet error rates • Types of user • Criteria for good software • The true significance of bugs in spreadsheets

Names in Excel

• Defining Names • Using Names for formulae • Names can be local to worksheets • Using Names in charts • Bookmarks in Excel • Dynamic Ranges

Operational Risk

• Operational Risk • Software Risk • The FSA and operational risk • User-developed software • The FSA and risk based capital • Risk identification

Abstraction

• Abstraction • Defining Names • Maintainability • Using Names for formulae • Names can be local to worksheets

Documentation

• What documentation does • Who benefits from documentation • Forms of documentation • Who is helped by what documentation? • Types of user

Modelling problems

• SunTrust earnings restatement • Kodak earnings restatement • Columbia space shuttle • Provident Financial modelling problem • Fannie Mae $1.2bn honest mistake

FSA

• Financial Services Authority • ARROW risk assessment framework • The FSA and risk based capital • Future regulation of insurance briefing • The FSA and operational risk

Charts in Excel

• Using Names in charts • Dynamic Ranges

Modularity

• Modularity • Maintainability

This web site

• This web site • Struts doEndTag error

Excel statistical functions

• Statistical functions in Excel 2003 • RAND() in Excel 2003

	:: About :: Blog :: Notes :: All topics :: All links :: Publications :: Downloads :: Contact New Types of user What documentation does Who benefits from documentation Forms of documentation Who is helped by what documentation? Read my blog. Is your software use Competent, Complacent or Compromised? Take my 30 second quiz now, and find out! Read past issues of my newsletter. Tools download a simple code profiler for Excel VBA. Automated spreadsheet testing, documentation and more. Download now, or find out more at http://www.xlsior.com. Search WWW Search louisepryor.com
All topics I am building up a library of notes on topics related to risk management frameworks in the financial services industry, operational risk and user-developed software. They are grouped by theme; a single note might belong to several themes. Good software • Criteria for good software • Correctness • Usability • Maintainability • Usefulness • Availability • What is a bug? • Performance • Spreadsheet error rates • The true significance of bugs in spreadsheets Spreadsheet errors • Nevada City budget problems • TransAlta Corporation • Pasting error • Project financing spreadsheets • Kodak earnings restatement • Fannie Mae $1.2bn honest mistake • Provident Financial modelling problem • Spreadsheet error rates • What is a bug? • RAND() in Excel 2003 Risk management • Risk management process • Risk maps • Risk indicators • Risk identification • Enterprise risk management • Risk classification • The FSA and risk based capital • Operational Risk • Future regulation of insurance briefing • Financial Services Authority Excel techniques • Defining Names • Lookups in Excel • Using Names in charts • Dynamic Ranges • Using Names for formulae • Names can be local to worksheets • Bookmarks in Excel • Statistical functions in Excel 2003 • RAND() in Excel 2003 Software Engineering concepts • Abstraction • Modularity • User-developed software • What is a bug? • Spreadsheet error rates • Types of user • Criteria for good software • The true significance of bugs in spreadsheets Names in Excel • Defining Names • Using Names for formulae • Names can be local to worksheets • Using Names in charts • Bookmarks in Excel • Dynamic Ranges Operational Risk • Operational Risk • Software Risk • The FSA and operational risk • User-developed software • The FSA and risk based capital • Risk identification Abstraction • Abstraction • Defining Names • Maintainability • Using Names for formulae • Names can be local to worksheets Documentation • What documentation does • Who benefits from documentation • Forms of documentation • Who is helped by what documentation? • Types of user Modelling problems • SunTrust earnings restatement • Kodak earnings restatement • Columbia space shuttle • Provident Financial modelling problem • Fannie Mae $1.2bn honest mistake FSA • Financial Services Authority • ARROW risk assessment framework • The FSA and risk based capital • Future regulation of insurance briefing • The FSA and operational risk Charts in Excel • Using Names in charts • Dynamic Ranges Modularity • Modularity • Maintainability This web site • This web site • Struts doEndTag error Excel statistical functions • Statistical functions in Excel 2003 • RAND() in Excel 2003
Copyright © 2003-2008 Louise Pryor. All rights reserved. Site developed by Louise Pryor. Louise Pryor is no longer practising as a consultant — the site is maintained as an archive, and is not updated.