{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["software "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"software ","index":0,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8]]}
["Medical Trend Calculator"]
["Use this software to calculate an estimate of the annualized medical cost trend. Include the \"Date\" and \"Incurred Medical Claims\" on a PMPM (Per Month Per Member) basis for the data set. Claims data can be either annual or monthly. Data that is not PMPM, will provide invalid results. The steps to use the software are as follows:  \nOne: Import the data set into the spread sheet\nTwo: Click the \"ENTER\" button to display the trend analysis interface  \nThree: In the interface, type the cell range for the claims data; \nFour: choose Data Type: Annual or Monthly; Finally\nFive: Click \"RUN\" to show trend estimates from linear regression, exponential regression,   \n         rolling average, and simple average methods of calculation"]
[]
["Year","PMPM/claim",null,"Year","PMPM"]
["CY 2002",73.037983118613951,null,"2008-04-01",217.880382573227]
["CY 2003",279.15000889205049,null,"2008-05-01",222.82114590894585]
["CY 2004",615.06502281502287,null,"2008-06-01",215.54201822060998]
["CY 2005",813.02251730167552,null,"2008-07-01",228.7330271268728]
["CY 2006",885.35743747866786,null,"2008-08-01",229.57068508285329]
["CY 2007",892.50041086348074,null,"2008-09-01",227.87850362925741]
["CY 2008",952.85699548476111,null,"2008-10-01",245.84434914497507]
["CY 2009",1061.3978410173286,null,"2008-11-01",214.76633233841548]
["CY 2010",1144.7174095016353,null,"2008-12-01",250.93928472464634]
["CY 2011",1169.686973465122,null,"2009-01-01",192.54582600880028]
["YTD 2012",1190.1493286155589,null,"2009-02-01",198.28097903171562]
[null,null,null,"2009-03-01",223.90008093591348]
[null,null,null,"2009-04-01",230.16356194739456]
[null,null,null,"2009-05-01",221.34536109178643]
[null,null,null,"2009-06-01",230.36795102307681]
[null,null,null,"2009-07-01",238.53980624319243]
[null,null,null,"2009-08-01",241.45546708517577]
[null,null,null,"2009-09-01",245.93505445368314]
[null,null,null,"2009-10-01",254.35750237274962]
[null,null,null,"2009-11-01",246.68548311400627]
[null,null,null,"2009-12-01",277.80449176353403]
[null,null,null,"2010-01-01",194.58386542424378]
[null,null,null,"2010-02-01",206.13700763968416]
[null,null,null,"2010-03-01",241.46443955994366]
[null,null,null,"2010-04-01",233.61632992025667]
[null,null,null,"2010-05-01",221.2338401640506]
[null,null,null,"2010-06-01",240.25618138235177]
[null,null,null,"2010-07-01",238.43231026044728]
[null,null,null,"2010-08-01",252.59447618647644]
[null,null,null,"2010-09-01",249.83399277580295]
[null,null,null,"2010-10-01",254.82947556511965]
[null,null,null,"2010-11-01",259.97551242867019]
[null,null,null,"2010-12-01",277.43633432534909]
[null,null,null,"2011-01-01",194.55771553027532]
[null,null,null,"2011-02-01",203.95047588832486]
[null,null,null,"2011-03-01",238.57328158411434]
[null,null,null,"2011-04-01",228.0075673300646]
[null,null,null,"2011-05-01",243.44881499243058]
[null,null,null,"2011-06-01",247.65228477152286]
[null,null,null,"2011-07-01",247.54204003927538]
[null,null,null,"2011-08-01",263.72447806800005]
[null,null,null,"2011-09-01",250.392821368282]
[null,null,null,"2011-10-01",258.48028246660533]
[null,null,null,"2011-11-01",259.89319605078691]
[null,null,null,"2011-12-01",278.05699963489604]
[null,null,null,"2012-01-01",201.57550792925002]
[null,null,null,"2012-02-01",225.05683816327254]
[null,null,null,"2012-03-01",238.82507234109565]