{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["counties","premiums","chip_premium","income","affordablecalculator","countylocator","operations"],"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":"counties","index":0,"n_rows":116,"n_cols":2,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Counties","Region"]
["Andrew","64501 - NW MO"]
["Atchison","64501 - NW MO"]
["Buchanan","64501 - NW MO"]
["Caldwell","64501 - NW MO"]
["Carroll","64501 - NW MO"]
["Clinton","64501 - NW MO"]
["Daviess","64501 - NW MO"]
["Dekalb","64501 - NW MO"]
["Gentry","64501 - NW MO"]
["Grundy","64501 - NW MO"]
["Harrison","64501 - NW MO"]
["Holt","64501 - NW MO"]
["Linn","64501 - NW MO"]
["Livingston","64501 - NW MO"]
["Mercer","64501 - NW MO"]
["Nodaway","64501 - NW MO"]
["Putnam","64501 - NW MO"]
["Sullivan","64501 - NW MO"]
["Worth","64501 - NW MO"]
["Cass","64109 - KC Metro"]
["Clay","64109 - KC Metro"]
["Jackson","64109 - KC Metro"]
["Johnson","64109 - KC Metro"]
["Lafayette","64109 - KC Metro"]
["Platte","64109 - KC Metro"]
["Ray","64109 - KC Metro"]
["Barry","65807 - SW MO"]
["Barton","65807 - SW MO"]
["Bates","65807 - SW MO"]
["Cedar","65807 - SW MO"]
["Christian","65807 - SW MO"]
["Dade","65807 - SW MO"]
["Dallas","65807 - SW MO"]
["Douglas","65807 - SW MO"]
["Greene","65807 - SW MO"]
["Henry","65807 - SW MO"]
["Hickory","65807 - SW MO"]
["Howell","65807 - SW MO"]
["Jasper","65807 - SW MO"]
["Laclede","65807 - SW MO"]
["Lawrence","65807 - SW MO"]
["McDonald","65807 - SW MO"]
["Newton","65807 - SW MO"]
["Ozark","65807 - SW MO"]
["Polk","65807 - SW MO"]
["Pulaski","65807 - SW MO"]
["St. Clair","65807 - SW MO"]
["Stone","65807 - SW MO"]
["Taney","65807 - SW MO"]
["Texas","65807 - SW MO"]
["Vernon","65807 - SW MO"]
["Webster","65807 - SW MO"]
["Wright","65807 - SW MO"]
["Audrain","65201 - Mid MO"]
["Benton","65201 - Mid MO"]
["Boone","65201 - Mid MO"]
["Callaway","65201 - Mid MO"]
["Camden","65201 - Mid MO"]
["Cole","65201 - Mid MO"]
["Cooper","65201 - Mid MO"]
["Gasconade","65201 - Mid MO"]
["Howard","65201 - Mid MO"]
["Maries","65201 - Mid MO"]
["Miller","65201 - Mid MO"]
["Moniteau","65201 - Mid MO"]
["Montgomery","65201 - Mid MO"]
["Morgan","65201 - Mid MO"]
["Osage","65201 - Mid MO"]
["Pettis","65201 - Mid MO"]
["Phelps","65201 - Mid MO"]
["Saline","65201 - Mid MO"]
["Adair","63401 - NE MO"]
["Chariton","63401 - NE MO"]
["Clark","63401 - NE MO"]
["Knox","63401 - NE MO"]
["Lewis","63401 - NE MO"]
["Lincoln","63401 - NE MO"]
["Macon","63401 - NE MO"]
["Marion","63401 - NE MO"]
["Monroe","63401 - NE MO"]
["Pike","63401 - NE MO"]
["Ralls","63401 - NE MO"]
["Randolph","63401 - NE MO"]
["Schuyler","63401 - NE MO"]
["Scotland","63401 - NE MO"]
["Shelby","63401 - NE MO"]
["Franklin","63107 - StL Metro"]
["Jefferson","63107 - StL Metro"]
["St. Charles","63107 - StL Metro"]
["St. Louis City","63107 - StL Metro"]
["St. Louis County","63107 - StL Metro"]
["Warren","63107 - StL Metro"]
["Bollinger","63701 - SE MO"]
["Butler","63701 - SE MO"]
["Cape Girardeau","63701 - SE MO"]
["Carter","63701 - SE MO"]
["Crawford","63701 - SE MO"]
["Dent","63701 - SE MO"]
["Dunklin","63701 - SE MO"]
["Iron","63701 - SE MO"]
["Madison","63701 - SE MO"]
["Mississippi","63701 - SE MO"]
["New Madrid","63701 - SE MO"]
["Oregon","63701 - SE MO"]
["Pemiscot","63701 - SE MO"]
["Perry","63701 - SE MO"]
["Reynolds","63701 - SE MO"]
["Ripley","63701 - SE MO"]
["Scott","63701 - SE MO"]
["Shannon","63701 - SE MO"]
["St. Francois","63701 - SE MO"]
["Ste. Genevieve","63701 - SE MO"]
["Stoddard","63701 - SE MO"]
["Washington","63701 - SE MO"]
["Wayne","63701 - SE MO"]

{"sheet":"premiums","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Region","Age","High","Low"]
["64501 - NW MO",19,243,220]
["64501 - NW MO",25,384,348]
["64501 - NW MO",30,434,393]
["64501 - NW MO",35,467,423]
["64501 - NW MO",100,488,443]
["64109 - KC Metro",19,221,205]
["64109 - KC Metro",25,350,324]
["64109 - KC Metro",30,395,366]
["64109 - KC Metro",35,426,394]
["64109 - KC Metro",100,445,412]
["65807 - SW MO",19,232,230]
["65807 - SW MO",25,366,364]
["65807 - SW MO",30,414,411]
["65807 - SW MO",35,446,443]
["65807 - SW MO",100,467,463]
["65201 - Mid MO",19,248,246]
["65201 - Mid MO",25,392,390]
["65201 - Mid MO",30,444,440]
["65201 - Mid MO",35,478,474]
["65201 - Mid MO",100,500,496]
["63401 - NE MO",19,300,279]
["63401 - NE MO",25,475,441]
["63401 - NE MO",30,537,499]
["63401 - NE MO",35,578,537]
["63401 - NE MO",100,604,562]
["63107 - StL Metro",19,210,209]
["63107 - StL Metro",25,333,330]
["63107 - StL Metro",30,376,373]
["63107 - StL Metro",35,405,402]
["63107 - StL Metro",100,423,420]
["63701 - SE MO",19,306,271]
["63701 - SE MO",25,484,428]
["63701 - SE MO",30,548,484]
["63701 - SE MO",35,590,521]
["63701 - SE MO",100,617,544]

{"sheet":"chip_premium","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Region","Age","High","Low"]
["64501 - NW MO",1,243,220]
["64501 - NW MO",2,485,439]
["64501 - NW MO",3,728,659]
["64109 - KC Metro",1,221,205,null,null,"Chip Premium Chart"]
["64109 - KC Metro",2,442,409]
["64109 - KC Metro",3,664,614]
["65807 - SW MO",1,232,230]
["65807 - SW MO",2,464,460]
["65807 - SW MO",3,695,690]
["65201 - Mid MO",1,248,246]
["65201 - Mid MO",2,496,493]
["65201 - Mid MO",3,745,739]
["63401 - NE MO",1,300,279]
["63401 - NE MO",2,601,558]
["63401 - NE MO",3,901,837]
["63107 - StL Metro",1,210,209]
["63107 - StL Metro",2,421,418]
["63107 - StL Metro",3,631,627]
["63701 - SE MO",1,306,271]
["63701 - SE MO",2,613,541]
["63701 - SE MO",3,919,812]

{"sheet":"income","index":3,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Income%FPL","Premium",null,null,null,null,"Income%FPL","Premium"]
["150% – 185%",77,null,null,null,null,"150% – 185%",75]
["186% - 225%",126,null,null,null,null,"186% - 225%",124]
["226% - 300%",192,null,null,null,null,"226% - 300%",189]
[]
[2017,null,null,null,null,null,2016]

{"sheet":"affordablecalculator","index":4,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,13,1,14],[32,1,32,18],[42,0,42,5],[43,0,43,5],[45,0,45,5],[15,1,15,18],[27,1,27,2],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,15,27,16],[27,17,27,18],[0,0,0,18],[1,1,1,2],[1,15,1,16],[1,17,1,18],[10,1,10,2],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,15,10,16],[10,17,10,18],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
["affordable"]
[null,"64501 - NW MO           Monthly Premiums",null,64116,null,"64109 - KC Metro            Monthly Premiums",null,"65807 - SW MO            Monthly Premiums",null,"65201 - Mid MO            Monthly Premiums",null,"63401 - NE MO            Monthly Premiums",null,63033,null,"63107 - StL Metro            Monthly Premiums",null,"63701 - SE MO            Monthly Premiums"]
["Applicant Characteristic","High","2nd High","High","2nd High","High","2nd High","High","2nd High","High","2nd High","High","2nd High","High","2nd High","High","2nd High","High","2nd High"]
["Pregnant Woman Age 19",243,220,221,205,221,205,232,230,248,246,300,279,210,209,210,209,306,271]
["Pregnant Woman Age 25",384,348,350,324,350,324,366,364,392,390,475,441,333,330,333,330,484,428]
["Pregnant Woman Age 30",434,393,395,366,395,366,414,411,444,440,537,499,376,373,376,373,548,484]
["Pregnant Woman Age 35",467,423,426,394,426,394,446,443,478,474,578,537,405,402,405,402,590,521]
["Pregnant Woman Age 35+",488,443,445,412,445,412,467,463,500,496,604,562,423,420,423,420,617,544]
["Use age break closest to actual age "]
[]
[null,"Average Annual",null,null,null,"Average Annual",null,"Average Annual",null,"Average Annual",null,"Average Annual",null,null,null,"Average Annual",null,"Average Annual"]
["Out of Pocket Maximum",4100,null,null,null,2750,null,6525,null,6525,null,5925,null,null,null,6525,null,5925]
["Deductible",2000,null,null,null,1500,null,1050,null,1050,null,1200,null,null,null,1050,null,1200]
["Actuarial Value",0.8,null,null,null,0.8,null,0.8,null,0.8,null,0.8,null,null,null,0.8,null,0.8]
[]
[null,"Select the geographic area in closest proximity to the residence of the applicant"]
["One Child Age 2",243,220,null,null,221,205,232,230,248,246,300,279,null,null,210,209,306,271]
["Two Children Ages 2 & 4",485,439,null," ",442,409,464,460,496,493,601,558,null,null,421,418,613,541]
["Three Children Ages 2, 4 & 6 ",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Four Children Ages 2, 4, 6 & 8",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Five Children Ages 2, 4, 6, 8 & 10",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Six Children Ages 2, 4, 6, 8, 10 & 12",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Seven Children Ages 2, 4, 6, 8, 10, 12 & 14",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Eight Children Ages 2, 4, 6, 8, 10, 12, 14 & 16",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Nine Children Ages 2, 4, 6, 8, 10, 12, 14, 16 & 18",728,659,null,null,664,614,695,690,745,739,901,837,null,null,631,627,919,812]
["Use age break closest to actual age "]
[]
[null,"Average Annual",null,null,null,"Average Annual",null,"Average Annual",null,"Average Annual",null,"Average Annual",null,null,null,"Average Annual",null,"Average Annual"]
["Out of Pocket Maximum",7375,null,null,null,4583.33,null,10875,null,10875,null,9875,null,null,null,10875,null,9875]
["Deductible",1666.67,null,null,null,2500,null,1750,null,1750,null,2000,null,null,null,1750,null,2000]
["Actuarial Value",0.8,null,null,null,0.8,null,0.8,null,0.8,null,0.8,null,null,null,0.8,null,0.8]
[]
[null,"Select the geographic area in closest proximity to the residence of the applicant"]
[]
["CHIP Affordability Test Effective April 1, 2016:","CHIP Affordability Limit","Enter Appropriate Premium from Above",null,null,"(Under)/Over"]
[]
["151% - 185% FPL CHIP 73",75,0,null,null,{"$f":"C37-B37","v":-75}]
[]
["186% - 225%FPL CHIP 74",124,0,null,null,{"$f":"C39-B39","v":-124}]
[]
["226% - 300% FPL CHIP 75",189,0,null,null,{"$f":"C41-B41","v":-189}]
[]
["Negative number means private coverage is affordable"]
["Positive number means private coverage is not affordable and CHIP coverage is awarded"]
[]
["Complete this spreadsheet for each SMHB application and file in VFR"]

{"sheet":"countylocator","index":5,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,2,1,3],[1,12,1,13]]}
["County Locator for Affordability Test"]
["64501 - NW MO",null,64116,null,"64109 - KC Metro",null,"65807 - SW MO",null,"65201 - Mid MO",null,"63401 - NE MO",null,63033,null,"63107 - StL Metro",null,"63701 - SE MO"]
[]
["Andrew",null,null,null,"Cass",null,"Barry",null,"Audrain",null,"Adair",null,null,null,"Franklin",null,"Bollinger"]
["Atchison",null,null,null,"Clay",null,"Barton",null,"Benton",null,"Chariton",null,null,null,"Jefferson",null,"Butler"]
["Buchanan",null,null,null,"Jackson",null,"Bates",null,"Boone",null,"Clark",null,null,null,"St. Charles",null,"Cape Girardeau"]
["Caldwell",null,null,null,"Johnson",null,"Cedar",null,"Callaway",null,"Knox",null,null,null,"St. Louis City",null,"Carter"]
["Carroll",null,null,null,"Lafayette",null,"Christian",null,"Camden",null,"Lewis",null,null,null,"St. Louis County",null,"Crawford"]
["Clinton",null,null,null,"Platte",null,"Dade",null,"Cole",null,"Lincoln",null,null,null,"Warren",null,"Dent"]
["Daviess",null,null,null,"Ray",null,"Dallas",null,"Cooper",null,"Macon",null,null,null,6,null,"Dunklin"]
["Dekalb",null,null,null,7,null,"Douglas",null,"Gasconade",null,"Marion",null,null,null,null,null,"Iron"]
["Gentry",null,null,null,null,null,"Greene",null,"Howard",null,"Monroe",null,null,null,null,null,"Madison"]
["Grundy",null,null,null,null,null,"Henry",null,"Maries",null,"Pike",null,null,null,null,null,"Mississippi"]
["Harrison",null,null,null,null,null,"Hickory",null,"Miller",null,"Ralls",null,null,null,null,null,"New Madrid"]
["Holt",null,null,null,null,null,"Howell",null,"Moniteau",null,"Randolph",null,null,null,null,null,"Oregon"]
["Linn",null,null,null,null,null,"Jasper",null,"Montgomery",null,"Schuyler",null,null,null,null,null,"Pemiscot"]
["Livingston",null,null,null,null,null,"Laclede",null,"Morgan",null,"Scotland",null,null,null,null,null,"Perry"]
["Mercer",null,null,null,null,null,"Lawrence",null,"Osage",null,"Shelby",null,null,null,null,null,"Reynolds"]
["Nodaway",null,null,null,null,null,"McDonald",null,"Pettis",null,15,null,null,null,null,null,"Ripley"]
["Putnam",null,null,null,null,null,"Newton",null,"Phelps",null,null,null,null,null,null,null,"Scott"]
["Sullivan",null,null,null,null,null,"Ozark",null,"Saline",null,null,null,null,null,null,null,"Shannon"]
["Worth",null,null,null,null,null,"Polk",null,18,null,null,null,null,null,null,null,"St. Francois"]
[19,null,null,null,null,null,"Pulaski",null,null,null,null,null,null,null,null,null,"Ste. Genevieve"]
[null,null,null,null,null,null,"St. Clair",null,null,null,null,null,null,null,null,null,"Stoddard"]
[null,null,null,null,null,null,"Stone",null,null,null,null,null,null,null,null,null,"Washington"]
[null,null,null,null,null,null,"Taney",null,null,null,null,null,null,null,null,null,"Wayne"]
[null,null,null,null,null,null,"Texas",null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,"Vernon"]
[null,null,null,null,null,null,"Webster"]
[null,null,null,null,null,null,"Wright"]
[null,null,null,null,null,null,27]

{"sheet":"operations","index":6,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Sharepoint Address"]
["http://moteam.state.mo.us/dss03/Documents/"]