{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["A","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"A","index":0,"n_rows":330,"n_cols":40,"rows_kept":330,"cut":false,"hidden":false,"merged":[[43,0,43,12],[292,0,292,12],[293,0,293,12],[294,0,294,12],[295,0,295,12],[251,0,251,12],[252,0,252,12],[253,0,253,12],[254,0,254,12],[87,0,87,12],[210,0,210,12],[211,0,211,12],[212,0,212,12],[213,0,213,12],[44,0,44,12],[45,0,45,12],[0,0,0,12],[3,0,3,12],[1,0,1,12],[2,0,2,12],[42,0,42,12],[84,0,84,12],[85,0,85,12],[86,0,86,12],[170,0,170,12],[171,0,171,12],[126,0,126,12],[127,0,127,12],[128,0,128,12],[129,0,129,12],[168,0,168,12],[169,0,169,12]]}
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["State Employees Standard w/o Grad Asst"]
["2013-09-01"]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,2362,1792684.1,1,1792684.1,0,0,0,758.96871295512278,758.96871295512278]
[201111,2356,2155102.69,1,2155102.69,0,0,0,914.72949490662131,914.72949490662131]
[201112,2334,2831512.11,1,2831512.11,0,0,0,1213.1585732647814,1213.1585732647814,961.32996313102672]
[201201,2048,1554311.23,1.0000999735426219,1554466.62,155.39000000013039,155.39000000013039,1000,758.94103027343749,759.01690429687505,970.77492134164436," "," "]
[201202,2013,1467789.18,1.0000999666723256,1467935.91,146.72999999998137,302.12000000011176,1000,729.15508196721305,729.22797317436653,915.3893103987491," "," "]
[201203,1995,1744404,1.0006000100894059,1745450.66,1046.6599999999162,1348.7800000000279,2000,874.38796992481207,874.91261152882203,787.29411988110974,880.92402273420805," "]
[201204,1981,1752495.68,1.0005999615359966,1753547.11,1051.4300000001676,2400.2100000001956,3000,884.65203432609792,885.18279151943466,829.34274169310402,904.22056258348391]
[201205,1971,1528022.96,1.0005999648068116,1528939.72,916.76000000000931,3316.9700000002049,4000,775.25264332825975,775.71776763064429,845.45779216411643,881.69276697455848]
[201206,1957,1611397.4,1.0006000382028668,1612364.3,966.9000000001397,4283.8700000003446,5000,823.40183955033206,823.89591211037305,828.37216618717207,807.58080401170082]
[201207,1929,1381573.6700000002,1.0005999824822949,1382402.59,828.91999999992549,5112.7900000002701,6000,716.21237428719553,716.64208916537075,772.35899095099887,801.16835134222515]
[201208,1916,1632817.19,1.0009999710990305,1634449.96,1632.7700000000186,6745.5600000002887,8000,852.20103862212943,853.05321503131518,797.86571009996544,821.95542939824668]
[201209,1925,1454023.85,1.001000011107108,1455477.89,1454.0399999998044,8199.6000000000931,10000,755.33706493506497,756.09241038961034,775.10059618717492,802.05339241373406,843.76220034695621]
[201210,1912,1714464.7,1.0010999701539496,1716350.56,1885.8600000001024,10085.460000000196,12000,896.68655857740589,897.67288702928874,835.43862506518337,803.6162807924203,856.2271487857995]
[201211,1898,1941862.2999999998,1.0010999904576139,1943998.33,2136.0300000002608,12221.490000000456,15000,1023.1097471022127,1024.2351580611171,892.0360557977333,844.67744040911839,863.80902717869253]
[201212,1892,1826853.03,1.001100000912498,1828862.5699999998,2009.5399999998044,14231.030000000261,17000,965.56714059196622,966.62926532769552,962.68177130831282,868.33524232914931,837.31903485941041]
[201301,1779,1035904.4500000001,1.0048000662609373,1040876.86,4972.4099999999162,19203.440000000177,23000,582.29592467678469,585.09098369870708,864.38099479260188,849.67463080727782,824.87294803176803]
[201302,1788.14,1275705.67,1.0069000006874627,1284508.04,8802.3700000001118,28005.810000000289,33000,713.42605724383986,718.34869752927625,760.9710448898544,828.11848431411443,824.96243277947133]
[201303,1774,1681833.89,1.0082999932888737,1695793.1,13959.210000000196,41965.020000000484,49000,948.04616121758727,955.91493799323564,752.86886320148881,861.20337693808119,830.8007533621394]
[201304,1773.63,1366768.53,1.0198999606758576,1393967.17,27198.639999999898,69163.660000000382,80000,770.60521642056119,785.94022992394116,819.80076165202024,842.5676167401972,822.48191254007941]
[201305,1771.51,1464858.35,1.0310999968017385,1510415.44,45557.089999999851,114720.75000000023,132000,826.89815468159941,852.61468464756058,864.83448640193706,812.22822008706396,829.00446734255627]
[201306,1747.27,1121934.02,1.0798000046384189,1211464.3599999999,89530.339999999851,204251.09000000008,235000,642.10684095760814,693.34696984438574,777.68860878125463,765.22186569866108,818.73406768888367]
[201307,1717,1266726.3700000001,1.1649999991710915,1475736.22,209009.84999999986,413260.93999999994,476000,737.75560279557374,859.48527664531161,801.71741746215457,810.84460935246011,830.92511264733218]
[201308,1723,1010525.2,1.3827987664236381,1397353,386827.80000000005,800088.74,921000,586.49170052234467,811,787.41873471016538,826.61244801982787,827.3893306851669]
[201309,1738.03,358039.13,3.9368387751361147,1409542.33,1051503.2000000002,1851591.9400000002,2130000,206.00284805210498,811,827.07739236736757,802.11323688402774,832.4448083489591]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,1852000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,2130000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["State Employees Standard Grad Asst"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","y","ln(y)","x^2","x*ln(y)"]
[201110,299,123385.75,1,123385.75,0,0,0,412.66137123745818,412.66137123745818]
[201111,288,73555.539999999994,1,73555.539999999994,0,0,0,255.40118055555553,255.40118055555553]
[201112,286,135831.85999999999,1,135831.85999999999,0,0,0,474.93657342657337,474.93657342657337,381.18344788087052]
[201201,272,67574.850000000006,1.0000998892339383,67581.600000000006,6.75,6.75,1000,248.43694852941178,248.46176470588239,327.38652482269504," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,459.89531194295904,6.130998880849563,1,6.130998880849563]
[201202,285,84172.800000000003,1.0000997947080292,84181.2,8.3999999999941792,15.149999999994179,1000,295.34315789473686,295.37263157894733,341.15618030842228," "," "]
[201203,267,46689.31,1.00059992319441,46717.32,28.010000000002037,43.159999999996217,1000,174.86632958801496,174.97123595505619,240.87393203883494,313.05437242192107," "]
[201204,264,63060.04,1.0006000630510223,63097.88,37.839999999996508,80.999999999992724,1000,238.86378787878789,239.00712121212121,237.74068627450978,283.37268351383875]
[201205,253,95025.93,1.0006000467451359,95082.95,57.020000000004075,138.0199999999968,1000,375.59656126482213,375.82193675889329,261.349681122449,302.69994468346653]
[201206,232,81696.429999999993,1.0006001486233855,81745.460000000006,49.030000000013388,187.05000000001019,1000,352.13978448275861,352.3511206896552,320.32882510013349,278.70719008264467]
[201207,227,107883.22,1.0005999079374901,107947.94,64.720000000001164,251.77000000001135,1000,475.25647577092514,475.54158590308373,399.96678370786515,313.33295157068062]
[201208,216,72520.570000000007,1.0009999921401609,72593.09,72.519999999989523,324.29000000000087,1000,335.74337962962966,336.07912037037033,388.57257777777778,320.20880054832077]
[201209,230,62641.85,1.000999970467028,62704.49,62.639999999999418,386.93000000000029,1000,272.3558695652174,272.62821739130436,361.43465081723622,339.78327004219403,325.24048733568452]
[201210,226,40011.589999999997,1.0010999312949074,40055.599999999999,44.010000000002037,430.94000000000233,1000,177.04243362831858,177.23716814159292,260.94223214285711,332.46353323699418,305.67791529875245]
[201211,219,70553.58,1.0011001567886419,70631.199999999997,77.619999999995343,508.55999999999767,1000,322.16246575342467,322.51689497716893,256.87598518518513,322.72428148148146,311.78051394020821]
[201212,213,39420.879999999997,1.0010999247099508,39464.240000000005,43.360000000007858,551.92000000000553,1000,185.07455399061033,185.27812206572773,228.19306990881455,295.56465815176557,286.43352961432504]
[201301,204,41053.65,1.0047998168250569,41250.699999999997,197.04999999999563,748.97000000000116,1000,201.24338235294118,202.20931372549018,237.96562893081764,249.77012232415902,284.01694992947807]
[201302,195,42421.55,1.0068997950334204,42714.25,292.69999999999709,1041.6699999999983,2000,217.54641025641027,219.04743589743589,201.68168300653596,230.62974358974358,278.22473415877636]
[201303,202.06,241941.54,1.0082999802348946,243949.65,2008.109999999986,3049.7799999999843,4000,1197.3747401761852,1207.3129268534099,545.56050976607992,379.70044318777502,358.52888409808054]
[201304,206,73748.39,1.0198998242537904,75215.97,1467.5800000000017,4517.359999999986,6000,358.00189320388347,365.12606796116506,600.07274566378146,414.20593837263732,371.07635357178253]
[201305,206,62685.91,1.0310999712694606,64635.44,1949.5299999999988,6466.8899999999849,8000,304.30053398058254,313.76427184466019,625.02208253265155,413.70752654845597,366.02720045340561]
[201306,186.67,31564.43,1.0798002688469266,34083.279999999999,2518.8499999999985,8985.7399999999834,11000,169.0921412117641,182.58573954036535,290.53516962600435,418.30185958507326,353.75004445357666]
[201307,183,22762.68,1.1650003426661535,26518.53,3755.8499999999985,12741.589999999982,15000,124.38622950819672,144.91,217.55041951117829,413.25589405546646,327.26369167541304]
[201308,183.87,36861.14,2.0700946850802771,76306.05,39444.910000000003,52186.499999999985,61000,200.47392179257082,415,247.33146656068214,445.96515930113054,333.06013199706678]
[201309,210,13004.44,6.7015573142711258,87150,74145.56,126332.05999999998,146000,61.925904761904768,415,329.31956940038486,309.5677475883424,345.8370615296148]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,127000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,146000]
[]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["State Employees SMP w/o Grad Assist"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,223,133161.24,1,133161.24,0,0,0,597.13560538116587,597.13560538116587]
[201111,221,187046.47,1,187046.47,0,0,0,846.36411764705883,846.36411764705883]
[201112,221,106286.64,1,106286.64,0,0,0,480.9350226244344,480.9350226244344,641.34488721804507]
[201201,194,63793.29,1.0001000105183475,63799.67,6.3799999999973807,6.3799999999973807,1000,328.8313917525773,328.86427835051546,561.52952830188678," "," "]
[201202,189,61503.75,1.0001001564945227,61509.91,6.1600000000034925,12.540000000000873,1000,325.41666666666669,325.44925925925929,383.43745033112583," "," "]
[201203,183,110809.14,1.0006001310000241,110875.64,66.5,79.040000000000873,1000,605.51442622950822,605.87781420765032,417.28837455830387,538.32621445978873," "]
[201204,183,147738.64000000001,1.0005999784484274,147827.28,88.639999999984866,167.67999999998574,1000,807.31497267759573,807.79934426229511,576.96005405405401,568.72007556675067]
[201205,178,158612.63,1.0006000152699062,158707.79999999999,95.169999999983702,262.84999999996944,1000,891.08219101123598,891.61685393258415,767.29911764705878,565.33705574912892]
[201206,178,47005.5,1.000600355277574,47033.72,28.220000000001164,291.06999999997061,1000,264.07584269662919,264.23438202247189,655.97179962894234,533.71404524886884]
[201207,177,21228.98,1.0006001230393549,21241.72,12.740000000001601,303.80999999997221,1000,119.93774011299435,120.0097175141243,425.85973733583489,502.93756433823523]
[201208,178,24217.61,1.0010000986885164,24241.83,24.220000000001164,328.02999999997337,1000,136.05398876404496,136.1900561797753,173.57836772983114,473.47074280408538]
[201209,164,64504.1,1.0010002464959591,64568.619999999995,64.519999999996799,392.54999999997017,1000,393.31768292682926,393.71109756097559,212.04657032755298,438.20507561436665,492.04916557448666]
[201210,164,51058.64,1.0010999117877013,51114.799999999996,56.159999999996217,448.70999999996639,1000,311.3331707317073,311.67560975609751,276.53211462450594,353.13617901828678,468.27538116591921]
[201211,158,51603.21,1.0010997377876298,51659.96,56.75,505.45999999996639,1000,326.60259493670884,326.96177215189874,344.32794238683124,255.01535819430813,419.4128241808952]
[201212,158,88695.91,1.0010998252343315,88793.46,97.55000000000291,603.0099999999693,1000,561.36651898734181,561.98392405063294,399.10045833333334,301.92231231231233,423.65703897338398]
[201301,108,189587.52,1.0048000522397256,190497.55,910.02999999999884,1513.0399999999681,2000,1755.4399999999998,1763.8662037037036,780.54474056603772,506.31851612903222,504.4956838453914]
[201302,108,127998.83,1.006899984945175,128882.02,883.19000000000233,2396.2299999999705,3000,1185.174351851852,1193.352037037037,1091.3717379679144,669.2051279069766,560.37398038203401]
[201303,107,27582.94,1.0082996953914269,27811.870000000003,228.93000000000393,2625.1599999999744,4000,257.78448598130842,259.9240186915888,1074.8960990712073,670.93357409713576,538.62473401397085]
[201304,106,19292.939999999999,1.0199000256052215,19676.870000000003,383.93000000000393,3009.0899999999783,4000,182.00886792452829,185.63084905660381,549.44161993769478,680.96876510067113,490.03936098654708]
[201305,106,11808.62,1.0311010092627249,12175.88,367.2599999999984,3376.3499999999767,4000,111.40207547169813,114.86679245283018,187.03642633228841,675.09040404040411,425.057418224299]
[201306,110.8,36015.21,1.0797998956551969,38889.22,2874.010000000002,6250.3599999999788,8000,325.04702166064982,350.98574007220219,219.15108426270135,647.15610096004968,437.47191147859917]
[201307,114,12329.939999999999,1.1650008029236152,14364.39,2034.4500000000007,8284.8099999999795,10000,108.15736842105262,126.00342105263158,197.79168681983069,370.97307456274933,450.54777468706538]
[201308,114,9729.7199999999993,4.3351710018376686,42180,32450.28,40735.089999999982,47000,85.348421052631579,370,281.68125737898464,235.78326238978411,481.36423771247854]
[201309,113,1778.8,23.504609849336632,41810,40031.199999999997,80766.289999999979,93000,15.741592920353982,370,288.42929618768329,254.73992166315153,482.58523316062178]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,81000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,93000]
[]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["State Employees SMP Grad Assist"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,5,0,0,0,0,0,0,0,0]
[201111,5,0,0,0,0,0,0,0,0]
[201112,5,0,1,0,0,0,0,0,0,0]
[201201,5,513.03,1,513.08000000000004,5.0000000000068212E-2,5.0000000000068212E-2,1000,102.60599999999999,102.61600000000001,34.205333333333336," "," "]
[201202,5,0,0,0,0,5.0000000000068212E-2,1000,0,0,34.205333333333336," "," "]
[201203,5,686.21,1.0005974847349937,686.62,0.40999999999996817,0.46000000000003638,1000,137.24200000000002,137.32400000000001,79.98,39.99," "]
[201204,5,771.27,1.0005964188935133,771.73,0.46000000000003638,0.92000000000007276,1000,154.25399999999999,154.346,97.223333333333329,65.714333333333329]
[201205,5,1483.2,1.0006000539374325,1484.09,0.88999999999987267,1.8099999999999454,1000,296.64,296.81799999999998,196.16266666666664,115.184]
[201206,1,0,0,0,0,1.8099999999999454,1000,0,0,205.07454545454542,132.9046153846154]
[201207,1,0,0,0,0,1.8099999999999454,1000,0,0,212.01285714285714,133.7472727272727]
[201208,1,0,1,0,0,1.8099999999999454,1000,0,0,0,163.46888888888887]
[201209,1,0,0,0,0,1.8099999999999454,1000,0,0,0,161.12999999999997,78.534545454545452]
[201210,1,0,0,0,0,1.8099999999999454,1000,0,0,0,148.40899999999999,86.388000000000005]
[201211,1,0,0,0,0,1.8099999999999454,1000,0,0,0,0,95.986666666666665]
[201212,1,0,0,0,0,1.8099999999999454,1000,0,0,0,0,107.985]
[201301,1,0,0,0,0,1.8099999999999454,1000,0,0,0,0,105.08714285714284]
[201302,1,0,1,0,0,1.8099999999999454,1000,0,0,0,0,122.60166666666665]
[201303,1,0,0,0,0,1.8099999999999454,1000,0,0,0,0,112.79099999999998]
[201304,1,0,0,0,0,1.8099999999999454,1000,0,0,0,0,92.755624999999995]
[201305,0,0,1,0,0,1.8099999999999454,1000,0,0,0,0,0]
[201306,0,0,0,0,0,1.8099999999999454,1000,0,0,0,0,0]
[201307,0,0,1,0,0,1.8099999999999454,1000,0,0,0,0,0]
[201308,0,0,0,0,0,1.8099999999999454,1000,0,500,0,0,0]
[201309,0,0,0,0,0,1.8099999999999454,1000,0,500,0,0,0]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,1000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,1000]
[]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["State Employees Medicare Plus"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,8954,1311597.3799999999,1,1311597.3799999999,0,0,0,146.48172660263569,146.48172660263569]
[201111,8947,1273860.99,1,1273860.99,0,0,0,142.37856152900414,142.37856152900414]
[201112,8923,1219796.31,1.0000999511139692,1219918.23,121.91999999992549,121.91999999992549,1000,136.70248907318168,136.7161526392469,141.86462123471517]
[201201,9144,1767673.14,1.0001000184909752,1767849.9400000002,176.8000000002794,298.72000000020489,1000,193.31508530183726,193.3344203849519,157.75631746501816," "," "]
[201202,9127,1511388.93,1.0001000205817308,1511540.1,151.17000000015832,449.89000000036322,1000,165.59536868631531,165.61193163142326,165.452242038685," "," "]
[201203,9111,1400653.7799999998,1.000099946183703,1400793.77,139.99000000022352,589.88000000058673,1000,153.7321677093623,153.74753265283724,170.92191257030169,156.54282570195181," "]
[201204,9071,1389698.18,1.0005000222422398,1390393.06,694.88000000012107,1284.7600000007078,2000,153.20231286517472,153.27891742916989,157.55710315280675,157.65616939417924]
[201205,9014,1469571.11,1.0005000030246918,1470305.9,734.78999999980442,2019.5500000005122,3000,163.03207344131351,163.11358997115596,156.69557030445657,161.07374517374518]
[201206,8978,1323701.0699999998,1.0004999920412545,1324362.9099999999,661.84000000008382,2681.390000000596,4000,147.43830140343059,147.51201938070838,154.64146140487011,162.82938157773904]
[201207,8966,1294338.81,1.0011999562927423,1295891.9600000002,1553.1500000001397,4234.5400000007357,5000,144.36078630381442,144.53401293776491,151.73828807775055,154.66651371920321]
[201208,8941,1302725.6400000001,1.0016999972457745,1304940.27,2214.6299999998882,6449.170000000624,8000,145.70245386422101,145.95014763449279,145.9994472754324,151.37826353062999]
[201209,8927,1271906.0799999998,1.0027999866153641,1275467.3999999999,3561.3200000000652,10010.490000000689,12000,142.47855718606473,142.87749523916207,144.45478236565552,149.5697626955118,153.06626004828729]
[201210,8897,1372149.3,1.0045999950588469,1378461.1800000002,6311.8800000001211,16322.37000000081,19000,154.22606496571879,154.93550410250648,147.91215580048572,149.83209463358335,153.76585630194546]
[201211,8892,1248151.24,1.0067000053615296,1256513.8599999999,8362.6199999998789,24684.990000000689,29000,140.36788573999101,141.30835132703552,146.37080550980684,146.18454096005672,153.6835345538054]
[201212,8893,1224220.01,1.008799962353172,1234993.0999999999,10773.089999999851,35458.08000000054,41000,137.66108287417069,138.8724952209603,145.0404070159658,144.7467630241423,153.86587239836609]
[201301,9076.32,1918136.9300000002,1.0111000052535353,1939428.26,21291.329999999842,56749.410000000382,66000,211.33421144252299,213.68002229978671,164.95597461331013,156.4493716891258,155.55264932064375]
[201302,9038.07,1324062.6500000001,1.0144000059211697,1343129.16,19066.509999999776,75815.920000000158,88000,146.49838405765834,148.60796165553043,167.27090326018174,156.87753434770218,154.11877781600543]
[201303,9009,1289619.26,1.0166000079744466,1311026.95,21407.689999999944,97223.610000000102,112000,143.14788100788101,145.52413697413698,169.35878479791796,157.2993432442363,153.4312656385805]
[201304,8968,1298062.23,1.0222999863419491,1327009,28946.770000000019,126170.38000000012,146000,144.74378122212309,147.97156556645851,147.36830628238238,156.13704500245842,152.98906387852193]
[201305,8909.7099999999991,1320540.58,1.035800028197543,1367815.97,47275.389999999898,173445.77000000002,200000,148.21364331723481,153.51969592725243,148.99003708523654,158.15093748666365,152.18405322661218]
[201306,8883,1298871.44,1.0529999951342377,1367711.62,68840.180000000168,242285.95000000019,279000,146.21990768884385,153.96956208488123,151.80974607923332,160.64332446862807,152.72228545411036]
[201307,8871.74,1169396.5699999998,1.0947000126740583,1280138.4400000002,110741.87000000034,353027.82000000053,406000,131.81141129023166,144.29395361000212,150.59999474956359,148.97359626166556,152.70963080853753]
[201308,8858.94,755831.3899999999,1.6643519925786625,1257969.48,502138.09000000008,855165.91000000061,984000,85.318490699790246,142,146.75984456114301,147.88063152436834,152.38843864672555]
[201309,8850,47464.53,26.476613167769703,1256700,1209235.47,2064401.3800000006,2375000,5.3632237288135594,142,142.76564482172765,147.30295760946612,152.3227951413939]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,2065000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,2375000]
[]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["Local ETF Standard"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,56,69858.7,1,69858.7,0,0,0,1247.4767857142856,1247.4767857142856]
[201111,51,42514.02,1,42514.02,0,0,0,833.60823529411755,833.60823529411755]
[201112,49,21629.99,1,21629.99,0,0,0,441.42836734693878,441.42836734693878,858.99173076923068]
[201201,40,11568.45,1.0001002727245223,11569.61,1.1599999999998545,1.1599999999998545,1000,289.21125000000001,289.24025,540.81157142857137," "," "]
[201202,40,45479.199999999997,1.0001004854966666,45483.77,4.569999999999709,5.7299999999995634,1000,1136.98,1137.0942499999999,609.94860465116278," "," "]
[201203,39,86777.91,1.0006000374980222,86829.98,52.069999999992433,57.799999999991996,1000,2225.0746153846153,2226.4097435897434,1209.1038655462185,1010.4948000000001]
[201204,39,26786.18,1.0005999362357754,26802.25,16.069999999999709,73.869999999991705,1000,686.82512820512818,687.23717948717945,1348.4406779661017,910.19232558139538]
[201205,40,12969.28,1.0005998790989168,12977.06,7.7799999999988358,81.649999999990541,1000,324.23200000000003,324.42649999999998,1072.9600847457627,831.14437246963553," "]
[201206,40,46013.84,1.0005996022066406,46041.43,27.590000000003783,109.23999999999432,1000,1150.346,1151.03575,721.18268907563015,965.1432773109243," "]
[201207,37,48441.65,1.0005996905555445,48470.7,29.049999999995634,138.28999999998996,1000,1309.2337837837838,1310.0189189189189,918.71102564102569,1134.4901702127659]
[201208,34,13973.19,1.0010004873618694,13987.17,13.979999999999563,152.26999999998952,1000,410.97617647058826,411.38735294117646,977.47117117117125,1026.6750655021833]
[201209,34,19373.830000000002,1.0010003184708443,19393.21,19.379999999997381,171.6499999999869,1000,569.81852941176476,570.38852941176469,779.53409523809512,748.53491071428573,892.90158316633267]
[201210,33,91431.54,1.0010998392895931,91532.1,100.56000000001222,272.20999999999913,1000,2770.6527272727271,2773.7000000000003,1236.7572277227723,1066.0627064220184,981.57834033613449]
[201211,32,11449.73,1.0010987158649156,11462.31,12.579999999999927,284.78999999999905,1000,357.80406249999999,358.19718749999998,1236.2385858585858,1099.4615238095239,954.44109409190378]
[201212,32,11272.96,1.0011026385261723,11285.39,12.430000000000291,297.21999999999935,1000,352.28,352.66843749999998,1178.1422680412372,970.94495049504951,967.8067727272728]
[201301,41,30170.81,1.0048000037121974,30315.63,144.81999999999971,442.03999999999905,1000,735.87341463414634,739.40560975609753,505.36504761904763,863.96024271844658,1008.1201814058958]
[201302,41,33706.26,1.0069002019209485,33938.839999999997,232.57999999999447,674.61999999999352,1000,822.10390243902441,827.77658536585352,662.630350877193,929.23699530516433,979.71961538461551]
[201303,40,87685.56,1.0082996561805617,88413.32,727.76000000000931,1402.3800000000028,2000,2192.1390000000001,2210.3330000000001,1251.3753278688525,1218.9387671232876,981.082189616253]
[201304,40,76320.17,1.0199002439328948,77838.960000000006,1518.7900000000081,2921.170000000011,4000,1908.00425,1945.9740000000002,1654.4720661157025,1120.5949115044248,1093.8200900900902]
[201305,40,5898.71,1.0310983248879839,6082.15,183.4399999999996,3104.6100000000106,4000,147.46775,152.05374999999998,1436.1202500000002,1059.2918376068376,1078.2910135135137]
[201306,40,14750.55,1.0798010921626651,15927.66,1177.1100000000006,4281.7200000000112,5000,368.76374999999996,398.19150000000002,832.07308333333333,1043.4568595041321,1010.4672072072074]
[201307,39,75434.22,1.1650000490493571,87880.87,12446.649999999994,16728.370000000006,20000,1934.2107692307693,2253.355641025641,923.4510924369747,1292.0074999999999,1094.2995739910314]
[201308,39,57999.040000000001,1.2776073535010235,74100,16100.96,32829.33,38000,1487.1548717948717,1900,1507.6994067796611,1471.6090756302522,1215.4555210643016]
[201309,39,6442.21,6.6228825201289618,42666,36223.79,69053.119999999995,80000,165.18487179487178,1094,1749.118547008547,1284.791729957806,1253.1649780701755]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,70000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,80000]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["Local ETF SMP"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,157,52885.52,1,52885.52,0,0,0,336.85044585987259,336.85044585987259]
[201111,152,70397.509999999995,1,70397.509999999995,0,0,0,463.14151315789468,463.14151315789468," "]
[201112,152,74983.75,1,74983.75,0,0,0,493.31414473684208,493.31414473684208,430.07978308026031]
[201201,171,29864.560000000001,1.0000994489789905,29867.53,2.9699999999975262,2.9699999999975262,1000,174.64654970760236,174.66391812865496,368.9448210526316," "," "]
[201202,169,65958.86,1.0001002139818669,65965.47,6.6100000000005821,9.5799999999981083,1000,390.2891124260355,390.328224852071,347.1885162601626," "," "]
[201203,170,42029.25,1.0006002962222738,42054.48,25.230000000003201,34.81000000000131,1000,247.23088235294117,247.37929411764708,270.36760784313725,346.19388259526261," "]
[201204,169,21878.720000000001,1.0005996694504979,21891.84,13.119999999998981,47.930000000000291,1000,129.45988165680475,129.5375147928994,255.73187007874017,310.43802644964398," "]
[201205,172,161737.29999999999,1.0005999234561229,161834.32999999999,97.029999999998836,144.95999999999913,1000,940.33313953488368,940.89726744186044,441.84080234833658,395.41116650049855," "]
[201206,171,134962.32999999999,1.0006000192794537,135043.31,80.980000000010477,225.9400000000096,1000,789.2533918128654,789.7269590643275,622.59664062499996,446.82677103718203," "]
[201207,169,102263.54,1.0006001161313212,102324.91,61.370000000009895,287.3100000000195,1000,605.10970414201176,605.47284023668647,779.69248046875009,518.73954901960781," "]
[201208,169,48367.64,1.0010000487929533,48416.01,48.370000000002619,335.68000000002212,1000,286.19905325443784,286.48526627218934,561.46214145383101,501.53419607843136]
[201209,163,84687.84,1.0010001435861393,84772.54,84.69999999999709,420.38000000001921,1000,519.55730061349686,520.07693251533738,470.08674650698606,547.16973346495558,448.80907258064519]
[201210,165,91552.58,1.0010999143879942,91653.28,100.69999999999709,521.0800000000163,1000,554.86412121212118,555.47442424242422,452.39804828973843,618.47807730426177,466.46835341365465]
[201211,165,82781.179999999993,1.0011002500809967,82872.259999999995,91.080000000001746,612.16000000001804,1000,501.70412121212115,502.25612121212117,525.95959432048687,543.99432135728534,469.66569077306735]
[201212,164,71838.2,1.0010996934778433,71917.2,79,691.16000000001804,1000,438.03780487804875,438.51951219512193,498.87194331983801,484.37809045226129,465.35109568666337]
[201301,171,40033.9,1.0047999320575811,40226.06,192.15999999999622,883.32000000001426,2000,234.11637426900586,235.24011695906432,390.03103999999996,421.12071213640922,470.4867079821517]
[201302,171,25950.25,1.006900126203023,26129.31,179.06000000000131,1062.3800000000156,2000,151.75584795321637,152.80298245614037,273.26594861660078,397.96861861861862,450.29000990589401]
[201303,172,49832.36,1.0083000283350017,50245.97,413.61000000000058,1475.9900000000162,2000,289.72302325581398,292.12773255813954,226.85085603112839,360.16277777777776,453.89758535378525]
[201304,174,50767.850000000006,1.0199001927400904,51778.14,1010.2899999999936,2486.2800000000097,3000,291.76925287356323,297.57551724137932,247.87895551257253,317.76690265486724,467.52878578479772]
[201305,170,70935.5,1.0310999429058791,73141.59,2206.0899999999965,4692.3700000000063,6000,417.26764705882351,430.24464705882349,339.46841085271319,306.69106653620355,424.17024703557303]
[201306,170,106669.66,1.0798001981069407,115181.92000000001,8512.2600000000093,13204.630000000016,16000,627.46858823529419,677.540705882353,467.12383268482495,346.98734435797667,414.56213049925856]
[201307,169,153945.26,1.1650000136412124,179346.23,25400.97,38605.60000000002,45000,910.91869822485216,1061.2202958579883,722.33740667976417,483.25844054580898,452.63495304003953]
[201308,170,43287.57,1.7751054170977951,76840,33552.43,72158.030000000028,83000,254.63276470588235,452,729.60343811394898,533.20375609756093,466.45479249011856]
[201309,169,6454.82,11.834257190750478,76388,69933.179999999993,142091.21000000002,164000,38.19420118343195,452,654.67368110236214,560.34821917808222,460.94579310344824]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,143000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,164000]
[]
[]
[]
["Wisconsin Physicians Service "]
["Reserve Estimate Worksheet"]
["Local ETF Medicare"]
[{"$f":"A4","v":"2013-09-01"}]
[]
[null,null,null,null,null,null,null,"Aggregate"]
["Effective",null,null,null,"Completed",null,"Aggregate","Recommended","Paid",null,"Rolling $/memb"]
["Date","Members","Claims","Lag","Claims","Reserve","Reserve","Reserve","$/memb","$/memb","3M","6M","12M"]
[]
[201110,267,30789.55,1,30789.55,0,0,0,115.31666666666666,115.31666666666666]
[201111,269,37966.050000000003,1,37966.050000000003,0,0,0,141.13773234200744,141.13773234200744]
[201112,268,34066.11,1,34066.11,0,0,0,127.11235074626866,127.11235074626866,127.88769900497513]
[201201,261,58403.74,1.000100164818212,58409.59,5.8499999999985448,5.8499999999985448,1000,223.76911877394636,223.79153256704979,163.4608395989975," "," "]
[201202,260,43096.04,1.0000995451090171,43100.33,4.2900000000008731,10.139999999999418,1000,165.75399999999999,165.7705,171.83273764258556," "," "]
[201203,259,44614.26,1.0005998082227521,44641.02,26.759999999994761,36.899999999994179,1000,172.25583011583012,172.35915057915057,187.37299999999999,157.17970328282829," "]
[201204,258,47590.31,1.0005992816604894,47618.83,28.520000000004075,65.419999999998254,1000,184.45856589147286,184.56910852713179,174.20872586872585,168.76313015873015," "]
[201205,257,53914.29,1.0006005828881359,53946.67,32.379999999997381,97.799999999995634,1000,209.78322957198444,209.90922178988328,188.89731266149875,180.28314139475367]
[201206,257,49390.8,1.0005997068279922,49420.42,29.619999999995343,127.41999999999098,1000,192.18210116731518,192.2973540856031,195.57761658031086,191.454162371134]
[201207,258,41991.72,1.0005994038824797,42016.89,25.169999999998254,152.58999999998923,1000,162.75860465116278,162.85616279069768,188.3212176165803,181.24219496449319]
[201208,260,55178.02,1.0009993109575155,55233.16,55.140000000006694,207.72999999999593,1000,212.22315384615382,212.43523076923077,189.2522193548387,189.07488056810845]
[201209,253,32965.83,1.0009992164614085,32998.769999999997,32.939999999995052,240.66999999999098,1000,130.29972332015811,130.4299209486166,168.93491569390403,182.26489954633828,169.55784777742247]
[201210,250,30939.01,1.0011002291282107,30973.05,34.040000000000873,274.70999999999185,1000,123.75604,123.8922,156.23195281782438,172.370657980456,170.54369453376205]
[201211,248,34881.94,1.0011008562023784,34920.339999999997,38.399999999994179,313.10999999998603,1000,140.65298387096774,140.80782258064514,131.68063914780291,160.91915465268676,170.71711880867596]
[201212,243,32400.51,1.0010996740483407,32436.14,35.630000000001019,348.73999999998705,1000,133.33543209876544,133.48205761316873,132.69842105263157,151.1761574074074,171.5780711488251]
[201301,241,78020.340000000011,1.0111004386804772,78886.399999999994,866.05999999998312,1214.7999999999702,2000,323.7358506224067,327.32946058091284,199.78535519125683,177.55709698996654,179.43233245729303]
[201302,240,36293.14,1.01440024202921,36815.770000000004,522.63000000000466,1737.4299999999748,2000,151.22141666666667,153.39904166666668,204.61092541436463,167.47828474576269,178.54082671957676]
[201303,240,39223.81,1.0166003761490789,39874.94,651.13000000000466,2388.5599999999795,3000,163.43254166666665,166.14558333333335,215.77962552011093,173.67075239398085,178.08365391014979]
[201304,238,39797.910000000003,1.0223009198221713,40685.439999999995,887.52999999999156,3276.089999999971,4000,167.21810924369748,170.94722689075627,163.47653203342617,181.80622758620692,176.95410050251255]
[201305,236,39017.07,1.0357999716534327,40413.880000000005,1396.8100000000049,4672.899999999976,6000,165.32656779661016,171.24525423728815,169.43173669467788,187.14365090403339,173.64210526315787]
[201306,234,38163.990000000005,1.0529999614820147,40186.68,2022.6899999999951,6695.589999999971,8000,163.09397435897438,171.73794871794871,171.30790960451978,193.74605318404477,171.86040802448147]
[201307,234,35586.450000000004,1.0946998084945252,38956.480000000003,3370.0299999999988,10065.61999999997,12000,152.07884615384617,166.48068376068377,169.82534090909093,166.6196835443038,172.22524854302364]
[201308,232,23823.510000000002,1.752890317169888,41760,17936.489999999998,28002.109999999968,33000,102.68754310344829,180,172.71880000000002,171.05899575671853,169.23083766008997]
[201309,234,1720.1200000000001,22.446108411041088,38610,36889.879999999997,64891.989999999962,75000,7.3509401709401718,165,170.46640000000002,170.88954545454547,172.30631358885017]
[]
[null,null,null,null,null,null,null,"09/13"]
[null,null,null,null,"Estimated Reserve.....................",null,null,65000]
[]
[null,null,null,null,"Recommended Reserve..........",null,null,75000]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}