{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TEMPLATE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TEMPLATE","index":0,"n_rows":149,"n_cols":13,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
[" ","CAA Module X19",null,null,null,"Part 1",{"$f":"part1","v":41},{"$f":"C5","v":"of 41"}]
[null,"ARN :",{"$f":"MID(CELL(\"filename\",C2),FIND(\"]\",CELL(\"filename\",C2))+1,LEN(CELL(\"filename\",C2)))","v":"TEMPLATE"},null,null,"Part 2",{"$f":"part2","v":59},"out of 59"]
[null,"Go to Marks sheet",null,null,null,"TOTAL",{"$f":"G1+G2","v":100},"out of 100"]
[]
[null,{"$f":"i+ii+iii+iv+v+vi+vii+viii+ix+x+xi+xii+xiii+xiv","v":41},"of 41","PART 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,{"$f":"MIN(SUM(B9:B11),2)","v":2},null,"PART (i) (max 2)",null,null,null,null,null,null,null,null,0]
[null,1,1,"Spreadsheet has separate worksheets for parameters/data, calculations and audit trail (or audit trail in a separate document)",null,null,null,null,null,null,null,null,0.5]
[null,1,1,"Named ranges have been used for parameter cells",null,null,null,null,null,null,null,null,1]
[null,1,1,"All worksheets have meaningful/sensible titles",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,{"$f":"MIN(SUM(B14:B19),5)","v":5},null,"PART (ii) (max 5)",null,null,null,null,null,null,null,null,2]
[null,2,2,"Check  max/min reasonable for probability values (between 0 and 1)",null,null,null,null,null,null,null,null,2.5]
[null,2,2," Check that there is smooth progression of values (graphically or otherwise)",null,null,null,null,null,null,null,null,3]
[null,2,2,"Check that failiure rates increase with age",null,null,null,null,null,null,null,null,3.5]
[null,2,2,"Check failure rate at limiting age equal to 1",null,null,null,null,null,null,null,null,4]
[null,1,1,"Check there are no blanks or zero values"]
[null,1,1,"Any other distinct, valid check"]
[]
[null,{"$f":"MIN(SUM(B22:B22),3)","v":1},null,"PART (iii) (max 1)"]
[null,1,1,"The correct formula has been used to convert failure rates to survival rates"]
[]
[null,{"$f":"MIN(SUM(B25:B27),3)","v":3},null,"PART (iv) (max 3)"]
[null,1,1,"0px set to zero for base scenario"]
[null,1,1,"Correct calculation of cumulative probability of survival for a car aged 10 for base scenario"]
[null,1,1,"Correct calculation of cumulative probability of survival for a car aged 15 for base scenario"]
[]
[null,{"$f":"MIN(2,SUM(B30:B31))","v":2},null,"PART (v) (max 2)"]
[null,1,1,"Correct calculation of life expectancy until failure for a car aged 10 for base scenario"]
[null,1,1,"Correct calculation of life expectancy until failure for a car aged 15 for base scenario"]
[]
[null,{"$f":"MIN(3,SUM(B34:B36))","v":3},null,"PART (vi) (max 3)"]
[null,1,1,"Correctly improvement rate at each age linked from parameters tab"]
[null,1,1,"Cumulative improvements at each age correctly calculated"]
[null,1,1,"Failure rate set to 1 at age 50"]
[]
[null,{"$f":"MIN(4,SUM(B39:B40))","v":4},null,"PART (vii) (max 4)"]
[null,2,2,"Correct calclation of cumulative improvement rates at all future ages for car currently 10 years old"]
[null,2,2,"Correct calculation of life expectancy until failure for car currently 10 years old"]
[]
[null,{"$f":"MIN(4,SUM(B43:B45))","v":4},null,"PART (viii) (max 4)"]
[null,1,1,"Correctly improvement rate at each age linked from parameters tab for car currently 15 years old"]
[null,1,1,"Cumulative improvements at each age correctly calculated for car currently 15 years old"]
[null,2,2,"Correct calculation of cumulative improvmeent rates and life expectancy until failure for car currently 15 years old"]
[]
[null,{"$f":"MIN(2,SUM(B48:B49))","v":2},null,"PART (ix) (max 2)"]
[null,1,1,"Initial and ultimate improvements correct"]
[null,1,1,"Linear interpolation of rates for intermediate years correct."]
[]
[null,{"$f":"MIN(SUM(B52:B53),3)","v":3},null,"PART (x) (max 3)"]
[null,2,2,"Correct calculation of cumulative improvement rates at all future ages for car currently 10 years old"]
[null,1,1,"Correct calculation of life expectancy until failure for car currently 10 years old"]
[]
[null,{"$f":"MIN(2,SUM(B56:B56))","v":2},null,"PART (xi) (max 2)"]
[null,2,2,"Correct calculation of cumulative improvement rates and life expectancy until failure for car currently 10 years old"]
[]
[null,{"$f":"MIN(4,SUM(B59:B60))","v":4},null,"PART (xii) (max 4)"]
[null,2,2,"Correct calculation of cumulative improvement rates at all future ages for car currently 15 years old"]
[null,2,2,"Correct calculation of cumulative improvmeent rates and life expectancy until failure for car currently 15 years old"]
[]
[null,{"$f":"MIN(3,SUM(B63:B65))","v":3},null,"PART (xiii) (max 3)"]
[null,1,1,"Correct type of chart selected"]
[null,1,1,"Chart has meaningful title and labelled axes"]
[null,1,1,"Correct data displayed on chart"]
[]
[null,{"$f":"MIN(3,SUM(B68:B70))","v":3},null,"PART (xiv) (max 3)"]
[null,1,1,"Correct type of chart selected"]
[null,1,1,"Chart has meaningful title and labelled axes"]
[null,1,1,"Correct data displayed on chart"]
[]
[]
[null,{"$f":"fellow_analyst+clear_english+logical_order+audit_content","v":59},"of 59","PART 2"]
[]
[null,{"$f":"B77+B85+B90","v":15},"of 15","Audit Approach"]
[]
[null,{"$f":"MIN(8,SUM(B78:B83))","v":8},"of 8","Fellow Analyst student can review, check and modify the model"]
[null,2,2,"For a newcomer, the audit trail is easy to follow i.e. the marker does not have to look at the model directly to understand what has been done"]
[null,2,2,"All the steps are correctly and clearly described"]
[null,1,1,"There is sufficient technical detail"]
[null,1,1,"The workbook is well labelled and is easy to navigate through"]
[null,1,1,"Where there are, or could be errors, the audit trail would enable the student to identify and correct errors"]
[null,1,1,"Danger areas in the spreadsheet are appropriately flagged (e.g. goal seek)"]
[]
[null,{"$f":"MIN(4,SUM(B86:B88))","v":4},"of 4","Written in clear English"]
[null,2,2,"The audit trail is written in clear, crisp and flowing English"]
[null,1,1,"Accurate spelling"]
[null,1,1,"The audit trail is laid out well, with good formatting to aid clarity"]
[]
[null,{"$f":"MIN(3,SUM(B91:B93))","v":3},"of 3","Written in a logical order"]
[null,1,1,"Data is introduced before referring to it"]
[null,1,1,"Assumptions are stated before using them"]
[null,1,1,"The methodology is described in a logical order, ie nothing is introduced which would require that the reader has read ahead"]
[]
[]
[null,{"$f":"B98+B120+B128+B137","v":44},"of 46","Audit Content"]
[]
[null,{"$f":"MIN(24,SUM(B99:B118))","v":24},"of 24","All model steps  accurately covered (1 or 2 each, max of 23)"]
[null,2,2,"Overview"]
[null,1,1,"List of parameters used"]
[null,1,1,"Description of the data used (car failure rates (qx), at age x exact from ages 65 to 105 inclusive)"]
[null,1,1,"Description of the assumptions made (limiting age of 50, improvements do not vary by age etc.)"]
[null,1,1,"Description of how improvement rates at intermediate years are calculated under tyre change scenario"]
[null,1,1,"Description of how the probability of survival is calculated at each age for base scenario"]
[null,2,2,"Description of how cumulative probability of survival is calculated for a car aged 10 for base scenario"]
[null,1,1,"Description of how cumulative probability of survival is calculated for a car aged 15 for base scenario"]
[null,1,1,"Description of how life expectancy before failure is calculated for base scenario"]
[null,2,2,"Description of how adjusted failure rates are calculated for a car aged 10 under oil change scenario"]
[null,1,1,"Statement that failure rate set to 1 at age 50"]
[null,1,1,"Description of how the adjusted probability of survival is calculated at each age for oil change scenario"]
[null,1,1,"Description of how cumulative probability of survival is calculated for a car aged 10 for oil change scenario"]
[null,1,1,"Description of how cumulative probability of survival is calculated for a car aged 15 for oil change scenario"]
[null,1,1,"Description of how life expectancy before failure is calculated for oil change scenario"]
[null,2,2,"Description of how the adjusted probability of survival is calculated at each age for tyre change scenario"]
[null,1,1,"Description of how cumulative probability of survival is calculated for a car aged 10 for tyre change scenario"]
[null,1,1,"Description of how cumulative probability of survival is calculated for a car aged 15 for tyre change scenario"]
[null,1,1,"Description of how life expectancy before failure is calculated for oil change scenario"]
[null,1,1,"Clear reporting of which numbers are plotted on the charts in results worksheet"]
[]
[null,{"$f":"MIN(7,SUM(B121:B126))","v":7},"of 7","All checks clearly recorded / described"]
[null,null,null,"(1 each - maximum of 8)"]
[null,1,1,"Description of the check that all numbers are included in a return range"]
[null,4,4,"Description of all checks on initial data (one mark per check documented, max 4)"]
[null,null,null,"e.g. Checks on max/min reasonable, smooth progression of values, values increase with age, value set to 1 at maximum age"]
[null,4,4,"Description of reasonableness and auto checks, (one mark per check documented, max 4)"]
[null,1,1,"Any other distinct, valid check"]
[]
[null,{"$f":"MIN(7,SUM(B129:B135))","v":7},"of 7","All steps clearly explained"]
[null,1,1,"The level of detail in the audit trail is appropriate for a newcomer to understand what has been done"]
[null,1,1,"All the methodology steps are set out clearly"]
[null,1,1,"Data source and format is described adequately and clearly."]
[null,1,1,"Items for double-checking are highlighted, with justification (given that no data adjustments are required)"]
[null,1,1,"All reasonableness checks applied are adequately documented"]
[null,1,1,"Areas where manual intervention or caution is required are well flagged (eg goalseeks or non-standard model areas)"]
[null,1,1,"The marker does not need to look directly at the model to understand what has been performed"]
[]
[null,{"$f":"MIN(6,SUM(B138:B143))","v":6},"of 6","Clear signposting/labelling"]
[null,1,1,"The audit trail allows the user to follow the model through"]
[null,1,1,"The audit trail allows the user to understand each calculation easily"]
[null,1,1,"There is adequate signposting in the audit trail to describe the purpose of each tab"]
[null,1,1,"There is adequate signposting in the audit trail to describe the general direction of the model"]
[null,1,1,"There is adequate signposting to indicate where in each sheet to look for the information / calculations / checks"]
[null,1,1,"Model labelling is consistent with the audit trail (data, parameters, analysis, results)"]
[]
[]
[null,"Overall Marks & P/F Assessment"]
[]
[null,null,"Total Marks:",{"$f":"part1+part2","v":100},{"$f":"D148/100","v":1}]
[null,null,null,{"$f":"D148=P1_TOTAL","v":true}]