{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Simulations"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Simulations","index":0,"n_rows":101,"n_cols":34,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Reinsurance Proposal Evaluation"]
[null,null,null,"Sample",{"$f":"VLOOKUP(RAND(),$D$4:$E$100,2,TRUE)","v":3400},null,"Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings by Simulation"]
[null,"Claims frequency","Annual Claim","Claims cdf","Annual Claim",null,"# of Simulations",1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simulation","Proposal 1","Proposal 2","Proposal 3","No Reinsurance",null,null,null,"Boxplot Data"]
[null,null,null,0,{"$f":"C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,112000,-189800,-283600,0,null,null,null,null,"Proposal 1","Proposal 2","Proposal 3","Quartile"]
[null,0.13295634798487799,0,{"$f":"B5","v":0.13295634798487799},{"$f":"C6","v":10},null,"Government mms",1000,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2787000,3265200,3516400,0,null,null,null,"Min",{"$f":"_xlfn.QUARTILE.INC(W$4:W$23,$AH5)","v":-213000},{"$f":"_xlfn.QUARTILE.INC(X$4:X$23,$AH5)","v":-364800},{"$f":"_xlfn.QUARTILE.INC(Y$4:Y$23,$AH5)","v":-483600},0]
[null,2.454157593832168E-2,10,{"$f":"B6+D5","v":0.15749792392319967},{"$f":"C7","v":40},null,"Commercial mms",9000,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1087000,1195200,1276400,0,null,null,null,"Q1",{"$f":"_xlfn.QUARTILE.INC(W$4:W$23,$AH6)","v":318250},98950,46400,1]
[null,2.0571275938321681E-2,40,0.17806919986152134,{"$f":"C8","v":70},null,"TOTAL # of Members",{"$f":"SUM(H5:H6)","v":10000},null,null,null,null,null,null,null,null,null,null,null,null,null,4,-113000,-364800,-483600,0,null,null,null,"Median",937000,685200,716400,2]
[null,2.5609975938321681E-2,70,0.20367917579984302,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2237000,2385200,2636400,0,null,null,null,"Q3",2162000,2265200,2516400,3]
[null,2.6023475938321682E-2,100,0.2297026517381647,130,null,"Proposal 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,3762000,3960200,4436400,0,null,null,null,"Max",4962000,5880200,6356400,4]
[null,1.8230724061678319E-2,130,0.24793337579984304,150,null,"Deductible",600000,null,"Reinsurnace",1950000,null,null,null,null,null,null,null,null,null,null,7,387000,195200,156400,0]
[null,2.2647975938321682E-2,150,0.27058135173816472,180,null,"Maximum 1",5000000,null,"Insurance",46640400,null,null,null,null,null,null,null,null,null,null,8,112000,-189800,-283600,0,null,null,null,"Box 1-hidden",{"$f":"AE6","v":318250},{"$f":"AF6","v":98950},{"$f":"AG6","v":46400}]
[null,2.0995875938321681E-2,180,0.29157722767648642,210,null,"% of Maximum 1",0.5,null,"Check ",48590400,{"$f":"K12=K11+K10","v":true},null,null,null,null,null,null,null,null,null,9,387000,195200,156400,0,null,null,null,"Box 2-lower",{"$f":"AE7-AE6","v":618750},586250,670000]
[null,1.996037593832168E-2,210,0.31153760361480809,240,null,"Maximum 2",0,null,"Premium",{"$f":"H15*$H$5*12+H16*$H$6*12","v":213000},null,null,null,null,null,null,null,null,null,null,10,2137000,2225200,2476400,0,null,null,null,"Box 3-upper",1225000,1580000,1800000]
[null,1.2767624061678322E-2,240,0.3243052276764864,260,null,"% of Maximum 2",0,null,"Save",{"$f":"K10-K13","v":1737000},null,null,null,null,null,null,null,null,null,null,11,712000,370200,356400,0]
[null,1.1923124061678321E-2,260,0.33622835173816473,310,null,"PMPM-government",2,null,null,null,null,null,null,null,null,null,null,null,null,null,12,1512000,1370200,1476400,0,null,null,null,"Whisker Top",{"$f":"AE9-AE8","v":2800000},{"$f":"AF9-AF8","v":3615000},{"$f":"AG9-AG8","v":3840000}]
[null,2.486992406167832E-2,310,0.36109827579984305,360,null,"PMPM-commercial",1.75,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1037000,545200,556400,0,null,null,null,"Whisker Bottom",{"$f":"AE6-AE5","v":531250},{"$f":"AF6-AF5","v":463750},{"$f":"AG6-AG5","v":530000}]
[null,2.8756475938321681E-2,360,0.38985475173816475,410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,2287000,3435200,3516400,0]
[null,2.6643275938321682E-2,410,0.41649802767648642,470,null,"Proposal 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,-113000,-364800,-483600,0]
[null,1.836382406167832E-2,470,0.43486185173816472,520,null,"Deductible",1000000,null,"Reinsurance",2440000,null,null,null,null,null,null,null,null,null,null,16,387000,195200,156400,0]
[null,2.302147593832168E-2,520,0.45788332767648637,580,null,"Maximum 1",2000000,null,"Insurance",46150400,null,null,null,null,null,null,null,null,null,null,17,-213000,-364800,-483600,0]
[null,1.5216224061678321E-2,580,0.4730995517381647,630,null,"% of Maximum 1",0.7,null,"Check",48590400,{"$f":"K21=K20+K19","v":true},null,null,null,null,null,null,null,null,null,18,4962000,5880200,6356400,0]
[null,1.388442406167832E-2,630,0.48698397579984304,690,null,"Maximum 2",3000000,null,"Premium",{"$f":"H24*$H$5*12+H25*$H$6*12","v":364800},null,null,null,null,null,null,null,null,null,null,19,837000,825200,876400,0]
[null,1.9024675938321682E-2,690,0.50600865173816467,750,null,"% of Maximum 2",0.8,null,"Save",{"$f":"K19-K22","v":2075200},null,null,null,null,null,null,null,null,null,null,20,1737000,2075200,2156400,0]
[null,1.8032075938321679E-2,750,0.52404072767648635,800,null,"PMPM-government",3.4]
[null,1.7075675938321679E-2,800,0.54111640361480806,860,null,"PMPM-commercial",3]
[null,9.9389240616783205E-3,860,0.55105532767648635,910]
[null,1.5331175938321678E-2,910,0.56638650361480802,970,null,"Proposal 3"]
[null,8.3517240616783218E-3,970,0.5747382276764863,1000,null,"Deductible",1000000,null,"Reinsurance",2640000]
[null,7.7444240616783219E-3,1000,0.5824826517381646,1100,null,"Maximum 1",2000000,null,"Insurance",45950400]
[null,7.1898240616783213E-3,1100,0.58967247579984294,1200,null,"% of Maximum 1",0.8,null,"Check",48590400,{"$f":"K30=K29+K28","v":true}]
[null,2.0471424061678321E-2,1200,0.61014389986152129,1300,null,"Maximum 2",3000000,null,"Premium",{"$f":"H33*$H$5*12+H34*$H$6*12","v":483600}]
[null,1.752372406167832E-2,1300,0.62766762392319964,1500,null,"% of Maximum 2",0.8,null,"Save",{"$f":"K28-K31","v":2156400}]
[null,2.1631875938321679E-2,1500,0.64929949986152136,1600,null,"PMPM-government",4.3]
[null,1.3498924061678323E-2,1600,0.66279842392319965,1700,null,"PMPM-commercial",4]
[null,1.8285275938321681E-2,1700,0.68108369986152129,1900]
[null,1.6906975938321678E-2,1900,0.69799067579984297,2000]
[null,9.4584240616783204E-3,2000,0.70744909986152127,2100]
[null,8.3566240616783204E-3,2100,{"$f":"B38+D37","v":0.71580572392319963},2300]
[null,1.3752475938321679E-2,2300,0.72955819986152126,2400]
[null,1.3076275938321679E-2,2400,0.74263447579984299,2600]
[null,5.9684240616783204E-3,2600,0.74860289986152129,2700]
[null,1.1675675938321679E-2,2700,0.76027857579984293,2900]
[null,1.232742406167832E-2,2900,0.77260599986152123,3200]
[null,1.6804175938321678E-2,3200,0.78941017579984296,3400]
[null,1.5429975938321679E-2,3400,0.80484015173816459,3700]
[null,1.4163875938321678E-2,3700,0.81900402767648628,4000]
[null,6.7540240616783213E-3,4000,0.82575805173816463,4300]
[null,5.7725240616783215E-3,4300,0.83153057579984291,4500]
[null,4.9482240616783215E-3,4500,0.83647879986152118,4800]
[null,4.2769240616783201E-3,4800,0.84075572392319953,5100]
[null,7.6603165561459716E-3,5100,0.84841604047934549,5400]
[null,5.4701834438540282E-3,5400,0.85388622392319957,5800]
[null,1.0386283443854028E-2,5800,0.86427250736705363,6300]
[null,1.0469016556145972E-2,6300,0.87474152392319959,6900]
[null,7.6578834438540272E-3,6900,0.88239940736705358,7400]
[null,6.7024834438540286E-3,7400,0.88910189081090762,8000]
[null,7.6277165561459727E-3,8000,0.89672960736705365,8900]
[null,1.3323283443854028E-2,8900,0.91005289081090768,10000]
[null,1.0550383443854028E-2,10000,0.92060327425476174,12000]
[null,8.5886834438540279E-3,12000,0.92919195769861573,13000]
[null,6.9264834438540288E-3,13000,0.93611844114246978,14000]
[null,5.6566834438540273E-3,14000,0.94177512458632384,16000]
[null,6.3619165561459717E-3,16000,0.94813704114246977,18000]
[null,7.9677834438540273E-3,18000,0.95610482458632384,24000]
[null,5.1055834438540285E-3,24000,0.96121040803017788,27000]
[null,5.3757165561459722E-3,27000,0.96658612458632387,30000]
[null,4.3459165561459713E-3,30000,0.97093204114246989,33000]
[null,3.6497165561459721E-3,33000,0.97458175769861588,36000]
[null,3.1486165561459721E-3,36000,0.97773037425476184,39000]
[null,2.7831165561459717E-3,39000,{"$f":"B70+D69","v":0.98051349081090777},{"$f":"C71","v":42000}]
[null,8.1628344385402808E-4,42000,0.98132977425476176,46000]
[null,6.0158344385402812E-4,46000,0.98193135769861584,49000]
[null,1.6701165561459699E-3,49000,0.98360147425476185,53000]
[null,2.8416165561459721E-3,53000,0.98644309081090786,60000]
[null,2.394716556145972E-3,60000,0.98883780736705384,68000]
[null,3.0559165561459718E-3,68000,0.99189372392319985,80000]
[null,2.3269165561459722E-3,80000,0.99422064047934577,92000]
[null,2.6558344385402798E-4,92000,0.99448622392319985,100000]
[null,1.6363165561459718E-3,100000,0.99612254047934579,110000]
[null,6.5483988016475699E-4,110000,0.99677738035951058,130000]
[null,4.6256011983524306E-4,130000,0.99723994047934583,140000]
[null,4.1513988016475697E-4,140000,0.99765508035951056,150000]
[null,4.928601198352431E-4,150000,0.99814794047934585,170000]
[null,4.3273988016475701E-4,170000,0.99858068035951064,200000]
[null,2.9786011983524307E-4,200000,0.99887854047934588,230000]
[null,2.5023988016475692E-4,230000,0.99912878035951058,260000]
[null,1.9103988016475694E-4,260000,0.99931982023967536,290000]
[null,1.4436011983524305E-4,290000,0.99946418035951057,340000]
[null,1.8253988016475695E-4,340000,0.99964672023967538,390000]
[null,7.3660119835243043E-5,390000,0.99972038035951061,450000]
[null,3.9960119835243057E-5,450000,0.99976034047934581,600000]
[null,2.2960119835243051E-5,600000,0.99978330059918108,800000]
[null,4.8060119835243051E-5,800000,0.99983136071901635,1100000]
[null,1.3260119835243052E-5,1100000,0.99984462083885162,1250000]
[null,4.2339880164756944E-5,1250000,0.99988696071901639,1800000]
[null,3.0539880164756949E-5,1800000,0.99991750059918116,2700000]
[null,2.8139880164756944E-5,2700000,0.99994564047934587,3000000]
[null,2.4539880164756901E-5,3000000,0.99997018035951057,3200000]
[null,1.11398801647569E-5,3200000,0.99998132023967534,4300000]
[null,1.03398801647569E-5,4300000,{"$f":"B100+D99","v":0.99999166011984009},6300000]
[null,8.3398801600000004E-6,6300000,{"$f":"B101+D100","v":1}]