{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Model"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":62,"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":"Instructions","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,null,null,null,null,null,null,"Instructions"]
[null,null,"Triangle Size",null,5,null,null,"1) Enter the size of the triangle and click on the 'Resize Triangle\" button."]
[null,null,null,null,null,null,null,"2) Go to \"Model\" sheet and enter earned premium and incremental payments in cells highlighted in yellow under \"All Claims\"."]
[null,null,null,null,null,null,null,"3) Enter estimated earned premium for the next accident period."]
[null,null,null,null,null,null,null,"4) Enter estimated unearned premium."]
[null,null,null,null,null,null,null,"5) Run the solver to calculated alpha and beta parameters by clicking \"Run Solver\" button."]
[null,null,null,null,null,null,null,"6) If required, reset parameters and run the solver again."]
[null,null,null,null,null,null,null,"7) Final results will be presented in the section highlighted in Green."]

{"sheet":"Model","index":1,"n_rows":165,"n_cols":23,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
["All Claims"]
[]
[null,"Earned Premium",1,2,3,4,5]
[1,null,null,null,null,null,null,{"$f":"SUM(C4:G4)","v":0}]
[2,null,null,null,null,null,null,{"$f":"SUM(C5:G5)","v":0}]
[3,null,null,null,null,null,null,{"$f":"SUM(C6:G6)","v":0}]
[4,null,null,null,null,null,null,{"$f":"SUM(C7:G7)","v":0}]
[5,null,null,null,null,null,null,{"$f":"SUM(C8:G8)","v":0}]
[]
[]
["All Claims: Incurred per $1m Earned"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":" C4/B$4*1000000","v":{"$error":"#DIV/0!"}},{"$f":" D4/B$4*1000000","v":{"$error":"#DIV/0!"}},{"$f":" E4/B$4*1000000","v":{"$error":"#DIV/0!"}},{"$f":" F4/B$4*1000000","v":{"$error":"#DIV/0!"}},{"$f":" G4/B$4*1000000","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":" C5/B$5*1000000","v":{"$error":"#DIV/0!"}},{"$f":" D5/B$5*1000000","v":{"$error":"#DIV/0!"}},{"$f":" E5/B$5*1000000","v":{"$error":"#DIV/0!"}},{"$f":" F5/B$5*1000000","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":" C6/B$6*1000000","v":{"$error":"#DIV/0!"}},{"$f":" D6/B$6*1000000","v":{"$error":"#DIV/0!"}},{"$f":" E6/B$6*1000000","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":" C7/B$7*1000000","v":{"$error":"#DIV/0!"}},{"$f":" D7/B$7*1000000","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":" C8/B$8*1000000","v":{"$error":"#DIV/0!"}}]
[]
["Mean",null,{"$f":"AVERAGE(C14:C18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D14:D18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E14:E18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F14:F18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G14:G18)","v":{"$error":"#DIV/0!"}}]
[]
["Residuals"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":" C14-C$20","v":{"$error":"#DIV/0!"}},{"$f":" D14-D$20","v":{"$error":"#DIV/0!"}},{"$f":" E14-E$20","v":{"$error":"#DIV/0!"}},{"$f":" F14-F$20","v":{"$error":"#DIV/0!"}},{"$f":" G14-G$20","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":" C15-C$20","v":{"$error":"#DIV/0!"}},{"$f":" D15-D$20","v":{"$error":"#DIV/0!"}},{"$f":" E15-E$20","v":{"$error":"#DIV/0!"}},{"$f":" F15-F$20","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":" C16-C$20","v":{"$error":"#DIV/0!"}},{"$f":" D16-D$20","v":{"$error":"#DIV/0!"}},{"$f":" E16-E$20","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":" C17-C$20","v":{"$error":"#DIV/0!"}},{"$f":" D17-D$20","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":" C18-C$20","v":{"$error":"#DIV/0!"}}]
[]
["StDev",null,{"$f":"STDEV(C25:C29)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D25:D29)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(E25:E29)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(F25:F29)","v":{"$error":"#DIV/0!"}}]
[]
["Standardised Residuals"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":" C25/C$31","v":{"$error":"#DIV/0!"}},{"$f":" D25/D$31","v":{"$error":"#DIV/0!"}},{"$f":" E25/E$31","v":{"$error":"#DIV/0!"}},{"$f":" F25/F$31","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":" C26/C$31","v":{"$error":"#DIV/0!"}},{"$f":" D26/D$31","v":{"$error":"#DIV/0!"}},{"$f":" E26/E$31","v":{"$error":"#DIV/0!"}},{"$f":" F26/F$31","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":" C27/C$31","v":{"$error":"#DIV/0!"}},{"$f":" D27/D$31","v":{"$error":"#DIV/0!"}},{"$f":" E27/E$31","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":" C28/C$31","v":{"$error":"#DIV/0!"}},{"$f":" D28/D$31","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":" C29/C$31","v":{"$error":"#DIV/0!"}}]
[]
["Expected Values"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":" B$4/1000000*C$20","v":{"$error":"#DIV/0!"}},{"$f":" B$4/1000000*D$20","v":{"$error":"#DIV/0!"}},{"$f":" B$4/1000000*E$20","v":{"$error":"#DIV/0!"}},{"$f":" B$4/1000000*F$20","v":{"$error":"#DIV/0!"}},{"$f":" B$4/1000000*G$20","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":" B$5/1000000*C$20","v":{"$error":"#DIV/0!"}},{"$f":" B$5/1000000*D$20","v":{"$error":"#DIV/0!"}},{"$f":" B$5/1000000*E$20","v":{"$error":"#DIV/0!"}},{"$f":" B$5/1000000*F$20","v":{"$error":"#DIV/0!"}},{"$f":" B$5/1000000*G$20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G46:G46)","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":" B$6/1000000*C$20","v":{"$error":"#DIV/0!"}},{"$f":" B$6/1000000*D$20","v":{"$error":"#DIV/0!"}},{"$f":" B$6/1000000*E$20","v":{"$error":"#DIV/0!"}},{"$f":" B$6/1000000*F$20","v":{"$error":"#DIV/0!"}},{"$f":" B$6/1000000*G$20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F47:G47)","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":" B$7/1000000*C$20","v":{"$error":"#DIV/0!"}},{"$f":" B$7/1000000*D$20","v":{"$error":"#DIV/0!"}},{"$f":" B$7/1000000*E$20","v":{"$error":"#DIV/0!"}},{"$f":" B$7/1000000*F$20","v":{"$error":"#DIV/0!"}},{"$f":" B$7/1000000*G$20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E48:G48)","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":" B$8/1000000*C$20","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*D$20","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*E$20","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*F$20","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*G$20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D49:G49)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"SUM(H45:H49)","v":{"$error":"#DIV/0!"}}]
[]
[]
["One Factor Model"]
["Scale",1,null,null,"Function to minimise",null,{"$f":"D107","v":{"$error":"#DIV/0!"}}]
["Alpha",1]
["Beta",1]
[]
[]
["Sigma(ij)"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":"SQRT((C45/$B$54)^2 *($B$55)^2 + (C45/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((D45/$B$54)^2 *($B$55)^2 + (D45/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((E45/$B$54)^2 *($B$55)^2 + (E45/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((F45/$B$54)^2 *($B$55)^2 + (F45/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((G45/$B$54)^2 *($B$55)^2 + (G45/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":"SQRT((C46/$B$54)^2 *($B$55)^2 + (C46/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((D46/$B$54)^2 *($B$55)^2 + (D46/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((E46/$B$54)^2 *($B$55)^2 + (E46/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((F46/$B$54)^2 *($B$55)^2 + (F46/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"SQRT((C47/$B$54)^2 *($B$55)^2 + (C47/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((D47/$B$54)^2 *($B$55)^2 + (D47/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((E47/$B$54)^2 *($B$55)^2 + (E47/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"SQRT((C48/$B$54)^2 *($B$55)^2 + (C48/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((D48/$B$54)^2 *($B$55)^2 + (D48/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"SQRT((C49/$B$54)^2 *($B$55)^2 + (C49/$B$54)*$B$56)","v":{"$error":"#DIV/0!"}}]
[]
["Standardised Residuals"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":"(C4-C45)/C62","v":{"$error":"#DIV/0!"}},{"$f":"(D4-D45)/D62","v":{"$error":"#DIV/0!"}},{"$f":"(E4-E45)/E62","v":{"$error":"#DIV/0!"}},{"$f":"(F4-F45)/F62","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":"(C5-C46)/C63","v":{"$error":"#DIV/0!"}},{"$f":"(D5-D46)/D63","v":{"$error":"#DIV/0!"}},{"$f":"(E5-E46)/E63","v":{"$error":"#DIV/0!"}},{"$f":"(F5-F46)/F63","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"(C6-C47)/C64","v":{"$error":"#DIV/0!"}},{"$f":"(D6-D47)/D64","v":{"$error":"#DIV/0!"}},{"$f":"(E6-E47)/E64","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"(C7-C48)/C65","v":{"$error":"#DIV/0!"}},{"$f":"(D7-D48)/D65","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"(C8-C49)/C66","v":{"$error":"#DIV/0!"}}]
[]
["Squared Standardised Residuals"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":"(C71)^2","v":{"$error":"#DIV/0!"}},{"$f":"(D71)^2","v":{"$error":"#DIV/0!"}},{"$f":"(E71)^2","v":{"$error":"#DIV/0!"}},{"$f":"(F71)^2","v":{"$error":"#DIV/0!"}},{"$f":"(G71)^2","v":0}]
[2,null,{"$f":"(C72)^2","v":{"$error":"#DIV/0!"}},{"$f":"(D72)^2","v":{"$error":"#DIV/0!"}},{"$f":"(E72)^2","v":{"$error":"#DIV/0!"}},{"$f":"(F72)^2","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"(C73)^2","v":{"$error":"#DIV/0!"}},{"$f":"(D73)^2","v":{"$error":"#DIV/0!"}},{"$f":"(E73)^2","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"(C74)^2","v":{"$error":"#DIV/0!"}},{"$f":"(D74)^2","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"(C75)^2","v":{"$error":"#DIV/0!"}}]
[]
["Likelihoods"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":"NORMDIST(C71,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(D71,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(E71,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(F71,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(G71,0,1,FALSE)","v":0.39894228040143265}]
[2,null,{"$f":"NORMDIST(C72,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(D72,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(E72,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(F72,0,1,FALSE)","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"NORMDIST(C73,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(D73,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(E73,0,1,FALSE)","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"NORMDIST(C74,0,1,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"NORMDIST(D74,0,1,FALSE)","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"NORMDIST(C75,0,1,FALSE)","v":{"$error":"#DIV/0!"}}]
[]
["Likelihoods"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":"LN(C89)","v":{"$error":"#DIV/0!"}},{"$f":"LN(D89)","v":{"$error":"#DIV/0!"}},{"$f":"LN(E89)","v":{"$error":"#DIV/0!"}},{"$f":"LN(F89)","v":{"$error":"#DIV/0!"}},{"$f":"LN(G89)","v":-0.91893853320467278}]
[2,null,{"$f":"LN(C90)","v":{"$error":"#DIV/0!"}},{"$f":"LN(D90)","v":{"$error":"#DIV/0!"}},{"$f":"LN(E90)","v":{"$error":"#DIV/0!"}},{"$f":"LN(F90)","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"LN(C91)","v":{"$error":"#DIV/0!"}},{"$f":"LN(D91)","v":{"$error":"#DIV/0!"}},{"$f":"LN(E91)","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"LN(C92)","v":{"$error":"#DIV/0!"}},{"$f":"LN(D92)","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"LN(C93)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Sum of log-likelihood",null,{"$f":"SUM(C98:G102)","v":{"$error":"#DIV/0!"}}]
[null,"Sum of squared standardised residuals",null,{"$f":"SUM(C80:G84)","v":{"$error":"#DIV/0!"}}]
[null,"n",null,{"$f":"COUNT(C80:G84)","v":1}]
[null,"function to minimise",null,{"$f":"-D104+1000*(D105-D106)^2","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Implied Claim Counts"]
[]
[null,null,1,2,3,4,5]
[1,null,{"$f":"C4/$B$54","v":0},{"$f":"D4/$B$54","v":0},{"$f":"E4/$B$54","v":0},{"$f":"F4/$B$54","v":0},{"$f":"G4/$B$54","v":0},null,{"$f":"SUM(C114:G114)","v":0}]
[2,null,{"$f":"C5/$B$54","v":0},{"$f":"D5/$B$54","v":0},{"$f":"E5/$B$54","v":0},{"$f":"F5/$B$54","v":0},{"$f":" B$5/1000000*G$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G115:G115)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C115:G115)","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"C6/$B$54","v":0},{"$f":"D6/$B$54","v":0},{"$f":"E6/$B$54","v":0},{"$f":" B$6/1000000*F$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":" B$6/1000000*G$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F116:G116)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C116:G116)","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"C7/$B$54","v":0},{"$f":"D7/$B$54","v":0},{"$f":" B$7/1000000*E$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":" B$7/1000000*F$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":" B$7/1000000*G$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E117:G117)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C117:G117)","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"C8/$B$54","v":0},{"$f":" B$8/1000000*D$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*E$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*F$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":" B$8/1000000*G$20/$B$54","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D118:G118)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C118:G118)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,"Projected Implied Claim Counts","Ultimate Implied Claim Counts","Earned Premium","Implied Average Claim Size"]
[1,null,{"$f":"H114","v":0},{"$f":"I114","v":0},{"$f":"B4","v":0},{"$f":"E124/D124","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":"H115","v":{"$error":"#DIV/0!"}},{"$f":"I115","v":{"$error":"#DIV/0!"}},{"$f":"B5","v":0},{"$f":"E125/D125","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"H116","v":{"$error":"#DIV/0!"}},{"$f":"I116","v":{"$error":"#DIV/0!"}},{"$f":"B6","v":0},{"$f":"E126/D126","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"H117","v":{"$error":"#DIV/0!"}},{"$f":"I117","v":{"$error":"#DIV/0!"}},{"$f":"B7","v":0},{"$f":"E127/D127","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"H118","v":{"$error":"#DIV/0!"}},{"$f":"I118","v":{"$error":"#DIV/0!"}},{"$f":"B8","v":0},{"$f":"E128/D128","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Average",{"$f":"SUM(E124:E128)/SUM(D124:D128)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Estimated Earned Premium For Accident Period 6"]
[null,null,"Na",{"$f":"D132/F129","v":{"$error":"#DIV/0!"}}]
[]
["Estimated Unearned Premium"]
[null,null,"Np",{"$f":"D135/F129","v":{"$error":"#DIV/0!"}}]
[]
[]
["alpha^2",{"$f":"B55^2","v":1}]
["beta^2",{"$f":"B56^2","v":1}]
[]
["Calculations"]
["Accident Period",null,"Z","Z^2","X","X^2","alpha^2+beta^2/x","z^2*(alpha^2+beta^2/x)","sigmai^2","Di","Di^2","Di^2+Sigma^2","(1/n(sum(Di)))^2","1/n(sum(Di^2+Sigma^2))","1/n(sum(Di^2+Sigma^2))-(1/n(sum(Di)))^2","sigmap^2","z*(x+z)","z*(x+z)*(alpha^2+beta^2/x)","(x+z)^2*(alpha^2+beta^2/x)","alpha^2*np*na","alpha^2*np^2+beta^2*np","alpha^2*na^2+beta^2*na"]
[1,null,{"$f":"C124","v":0},{"$f":"C144^2","v":0},{"$f":"D124-C144","v":0},{"$f":"E144^2","v":0},{"$f":"$B$139+B$140/E144","v":{"$error":"#DIV/0!"}},{"$f":"D144*G144","v":{"$error":"#DIV/0!"}},{"$f":"D144*$B$139+C144*$B$140","v":0},{"$f":"H4+H45","v":0},{"$f":"J144^2","v":0},{"$f":"K144+I144","v":0},null,null,null,null,{"$f":"C144*(E144+C144)","v":0},{"$f":"Q144*G144","v":{"$error":"#DIV/0!"}},{"$f":"(E144+C144)^2*G144","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":"C125","v":{"$error":"#DIV/0!"}},{"$f":"C145^2","v":{"$error":"#DIV/0!"}},{"$f":"D125-C145","v":{"$error":"#DIV/0!"}},{"$f":"E145^2","v":{"$error":"#DIV/0!"}},{"$f":"$B$139+B$140/E145","v":{"$error":"#DIV/0!"}},{"$f":"D145*G145","v":{"$error":"#DIV/0!"}},{"$f":"D145*$B$139+C145*$B$140","v":{"$error":"#DIV/0!"}},{"$f":"H5+H46","v":{"$error":"#DIV/0!"}},{"$f":"J145^2","v":{"$error":"#DIV/0!"}},{"$f":"K145+I145","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C145*(E145+C145)","v":{"$error":"#DIV/0!"}},{"$f":"Q145*G145","v":{"$error":"#DIV/0!"}},{"$f":"(E145+C145)^2*G145","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"C126","v":{"$error":"#DIV/0!"}},{"$f":"C146^2","v":{"$error":"#DIV/0!"}},{"$f":"D126-C146","v":{"$error":"#DIV/0!"}},{"$f":"E146^2","v":{"$error":"#DIV/0!"}},{"$f":"$B$139+B$140/E146","v":{"$error":"#DIV/0!"}},{"$f":"D146*G146","v":{"$error":"#DIV/0!"}},{"$f":"D146*$B$139+C146*$B$140","v":{"$error":"#DIV/0!"}},{"$f":"H6+H47","v":{"$error":"#DIV/0!"}},{"$f":"J146^2","v":{"$error":"#DIV/0!"}},{"$f":"K146+I146","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C146*(E146+C146)","v":{"$error":"#DIV/0!"}},{"$f":"Q146*G146","v":{"$error":"#DIV/0!"}},{"$f":"(E146+C146)^2*G146","v":{"$error":"#DIV/0!"}}]
[4,null,{"$f":"C127","v":{"$error":"#DIV/0!"}},{"$f":"C147^2","v":{"$error":"#DIV/0!"}},{"$f":"D127-C147","v":{"$error":"#DIV/0!"}},{"$f":"E147^2","v":{"$error":"#DIV/0!"}},{"$f":"$B$139+B$140/E147","v":{"$error":"#DIV/0!"}},{"$f":"D147*G147","v":{"$error":"#DIV/0!"}},{"$f":"D147*$B$139+C147*$B$140","v":{"$error":"#DIV/0!"}},{"$f":"H7+H48","v":{"$error":"#DIV/0!"}},{"$f":"J147^2","v":{"$error":"#DIV/0!"}},{"$f":"K147+I147","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C147*(E147+C147)","v":{"$error":"#DIV/0!"}},{"$f":"Q147*G147","v":{"$error":"#DIV/0!"}},{"$f":"(E147+C147)^2*G147","v":{"$error":"#DIV/0!"}}]
[5,null,{"$f":"C128","v":{"$error":"#DIV/0!"}},{"$f":"C148^2","v":{"$error":"#DIV/0!"}},{"$f":"D128-C148","v":{"$error":"#DIV/0!"}},{"$f":"E148^2","v":{"$error":"#DIV/0!"}},{"$f":"$B$139+B$140/E148","v":{"$error":"#DIV/0!"}},{"$f":"D148*G148","v":{"$error":"#DIV/0!"}},{"$f":"D148*$B$139+C148*$B$140","v":{"$error":"#DIV/0!"}},{"$f":"H8+H49","v":{"$error":"#DIV/0!"}},{"$f":"J148^2","v":{"$error":"#DIV/0!"}},{"$f":"K148+I148","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C148*(E148+C148)","v":{"$error":"#DIV/0!"}},{"$f":"Q148*G148","v":{"$error":"#DIV/0!"}},{"$f":"(E148+C148)^2*G148","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C144:C148)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D144:D148)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(H144:H148)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(J144:J148)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K144:K148)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L144:L148)","v":{"$error":"#DIV/0!"}},{"$f":"(J149/COUNT(J144:J148))^2","v":{"$error":"#DIV/0!"}},{"$f":"L149/COUNT(J144:J148)","v":{"$error":"#DIV/0!"}},{"$f":"N149-M149","v":{"$error":"#DIV/0!"}},{"$f":"(D136^2*$B$139+D136*$B$140)/(D133^2*$B$139+D133*$B$140)*O149","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(R144:R148)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(S144:S148)","v":{"$error":"#DIV/0!"}},{"$f":"D136*D133*$B$139","v":{"$error":"#DIV/0!"}},{"$f":"D136^2*$B$139+D136*$B$140","v":{"$error":"#DIV/0!"}},{"$f":"D133^2*$B$139+D133*$B$140","v":{"$error":"#DIV/0!"}},{"$f":"T149/(SQRT(U149)*SQRT(V149))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(P149)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"R149/(SQRT(S149)*SQRT(H149))","v":{"$error":"#DIV/0!"}}]
["Outstanding Claims",null,null,null,null,"Outstanding Claims",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corr",{"$f":"W149*W150","v":{"$error":"#DIV/0!"}}]
["Central Estimate",{"$f":"H50","v":{"$error":"#DIV/0!"}},null,null,null,"mean",{"$f":"LN(B152-0.5*G153^2)","v":{"$error":"#DIV/0!"}}]
["CoV",{"$f":"SQRT(H149)/B152","v":{"$error":"#DIV/0!"}},null,null,null,"stdev",{"$f":"SQRT(LN(B153^2+1))","v":{"$error":"#DIV/0!"}}]
["Risk Margin",{"$f":"MAX(B153/2,G155)","v":{"$error":"#DIV/0!"}},null,null,null,"75th Percentile",{"$f":"LOGINV(0.75,G152,G153)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Risk Margin",{"$f":"(G154-B152)/B152","v":{"$error":"#DIV/0!"}}]
["Premium Liability - Variance Estimate"]
["Central Estimate",{"$f":"D136*F129","v":{"$error":"#DIV/0!"}}]
["CoV",{"$f":"SQRT(P149)/B157","v":{"$error":"#DIV/0!"}},null,null,null,"Premium Liabilities"]
["Risk Margin",{"$f":"MAX(B158/2,G162)","v":{"$error":"#DIV/0!"}},null,null,null,"mean",{"$f":"LN(B157-0.5*G160^2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"stdev",{"$f":"SQRT(LN(B158^2+1))","v":{"$error":"#DIV/0!"}}]
["Correlation Coefficient Between Premium Liability and Outstanding Claim Liability",null,null,null,null,"75th Percentile",{"$f":"LOGINV(0.75,G159,G160)","v":{"$error":"#DIV/0!"}}]
["Corr",{"$f":"W151","v":{"$error":"#DIV/0!"}},null,null,null,"Risk Margin",{"$f":"(G161-B157)/B157","v":{"$error":"#DIV/0!"}}]
[]
["Maximum Possible Correlation of OSC to other lines"]
[null,{"$f":"SQRT(B139*D149)/SQRT(B139*D149+B140*C149)","v":{"$error":"#DIV/0!"}}]