What are the 4 principles of good spreadsheet practice in the business environment
Understand role of spreadsheet
Adopt organisation standard
Ensure those involved have an appropriate level of knowledge
Shared ownership, collaboration
What are the 10 principles of good spreadsheet practice in the building of the spreadsheet
Do a calculation once and refer back to it
Consistent structure and formulae
Longevity
Embed - DONT EMBED
Avoid advanced features
Focus on required outputs
Welcome sheet
Identify audience
Short and simple formulae
Separate inputs / outputs and calculations
What are the 4 principles of good spreadsheet practice in Risk and Controls
Rigorous testing
Protect certain cells
Backup versions
Built-in checks
What does nPx denote
The probability that a life aged x will survive for at least n years
What does nQx denote
The probability that a life aged x will die within n years
