{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Main","State ID","Sch A","A-Data","Sch B","B-Data","Sch C","C-Data","Sch D","D-Data","Sch E","E-Data","Sch F","F-Data","Sch G","G-Data","Sch H","H-Data","Sch I","I-Data","Admin Dec","Admin Dec-Data","Error","Info","Tips"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":2084,"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":"Main","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,15,1,35],[2,0,2,35],[22,0,22,35],[35,0,35,35],[27,0,27,35],[28,0,28,35],[24,0,24,35],[25,0,25,35],[0,0,0,35],[29,0,29,35],[36,0,36,35],[31,0,31,35],[32,0,32,35],[33,0,33,35],[34,0,34,35],[26,0,26,35],[30,0,30,35],[4,0,21,7],[4,28,21,35],[13,8,21,27],[23,0,23,35],[1,0,1,3],[1,4,1,8],[1,9,1,14]]}
["Provisional   Provisional"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TENNESSEE DEPARTMENT OF HEALTH\nHealth Statistics\n2nd Floor, Andrew Johnson Tower\n710 James Robertson Parkway\nNashville, TN 37243\nTelephone: (615) 741-584  Fax: (615) 253-1688"]
[]
[]
[]
[]
[]
[]
[]
[]
["JOINT ANNUAL REPORT OF\nAssisted-Care Living Facilities\n2020"]
[]
["Schedule A - Identification"]
["Schedule B - Ownership of Business"]
["Schedule C - Facilities and Services"]
["Schedule D - Beds"]
["Schedule E - Utilization"]
["Schedule F - Personnel"]
["Schedule G - Skilled Care Procedures"]
["Schedule H - Activities of Daily Living (ADL)"]
["Schedule I - Financial Data"]
["Administrator Declaration (Electronic Signature)"]
["State ID Listing"]
["Tips"]
["Error Listing / Comments"]

{"sheet":"State ID","index":1,"n_rows":335,"n_cols":8,"rows_kept":335,"cut":false,"hidden":false,"merged":[]}
["STATE\nID","LICENSE\nNUMBER","COUNTY","NAME","ADDRESS","CITY","STATE","ZIP"]
[]
["010123",14,"Anderson","Commonwealth Senior Living at Oak Ridge","360 Laboratory Road","Oak Ridge","TN",37830]
["010423",128,"Anderson","Navion BKE Oak Ridge, LLC","734 Emory Valley Road","Oak Ridge","TN",37830]
["010323",201,"Anderson","Morning Pointe of Clinton","960 S. Charles G Seivers Boulevard","Clinton","TN",37716]
["010523",344,"Anderson","Meadow View Senior Living Community","111 Acuff Lane","Clinton","TN",37716]
["010623",346,"Anderson","The Courtyards Senior Living Briarcliff","300 Briarcliff Avenue Bldg. #1","Oak Ridge","TN",37830]
["010823",399,"Anderson","Canterfield of Oak Ridge","200 Bus Terminal Road","Oak Ridge","TN",37830]
["010923",444,"Anderson","Alexander Guest House","83 Kentucky Avenue","Oak Ridge","TN",37830]
["020143",5,"Bedford","Celebration Way","895 Union Street","Shelbyville","TN",37160]
["020243",260,"Bedford","Carriage House Inn","311 Colloredo Boulevard","Shelbyville","TN",37160]
["050223",76,"Blount","Brookdale Sandy Springs","511 Pearson Springs Road","Maryville","TN",37803]
["050123",95,"Blount","Brookdale Browns Creek","1869 Crest Road","Maryville","TN",37804]
["050423",209,"Blount","Morningview Village","2304 E. Lamar Alexander Parkway","Maryville","TN",37804]
["050523",224,"Blount","Asbury Place Maryville","2648 Sevierville Road","Maryville","TN",37804]
["050623",238,"Blount","Shannondale of Maryville Assisted Living Center","805 Shannondale Way","Maryville","TN",37803]
["050723",423,"Blount","Clover Hill Senior Living","2317 Highway 411 South","Maryville","TN",37801]
["050823",527,"Blount","Liberty Assisted Living, LLC","312 McMaster Place","Maryville","TN",37801]
["060233",115,"Bradley","Morningside of Cleveland","2900 Westside Drive, N.W.","Cleveland","TN",37312]
["060433",143,"Bradley","Garden Plaza of Cleveland","3500 Keith Street","Cleveland","TN",37312]
["060333",242,"Bradley","Brookdale Mount Vernon Drive","1775 Mt. Vernon Drive Nw","Cleveland","TN",37311]
["060533",326,"Bradley","Brookdale Cleveland","2745 Executive Park, Nw","Cleveland","TN",37312]
["060633",481,"Bradley","Legacy Village of Cleveland","2255 Candies Lane NW","Cleveland","TN",37312]
["070133",217,"Campbell","Lafollette Court Assisted Living Community","139 Massachusetts Avenue","Lafollette","TN",37766]
["090153",107,"Carroll","Harmony Hill","100 Jerry F. Adkins Lane","Huntingdon","TN",38344]
[100113,398,"Carter","Sycamore Springs Senior Living Community","1504 West Elk Avenue","Elizabethton","TN",37643]
[110143,380,"Cheatham","Vantage Pointe Village at Ashland City","2035 Vantage Pointe Road","Ashland City","TN",37015]
[120153,197,"Chester","Southern Oaks","558 White Avenue","Henderson","TN",38340]
[150223,153,"Cocke","Wellington Manor","375 Hedrick Drive","Newport","TN",37821]
[160243,16,"Coffee","Brookdale Tullahoma","801 Wilson Avenue","Tullahoma","TN",37388]
[160143,80,"Coffee","Morning Pointe of Tullahoma","711 Kings Lane","Tullahoma","TN",37388]
[160343,113,"Coffee","Autumn Oaks","1621 Mcminnville Highway","Manchester","TN",37355]
[160443,268,"Coffee","Bailey Manor","1707 Mcminnville Highway","Manchester","TN",37355]
[160543,303,"Coffee","McArthur Manor Assisted Living","119 Bryan Avenue","Manchester","TN",37355]
[170153,57,"Crockett","Bells Assisted-Care Living","276 Herndon Drive","Bells","TN",38006]
[180143,68,"Cumberland","Elizabeth Fletcher House","40 Fletcher Drive","Pleasant Hill","TN",38578]
[180243,172,"Cumberland","Cumberland Ridge Assisted Living Center","458 Wayne Avenue","Crossville","TN",38555]
[180343,320,"Cumberland","Good Samaritan Society-Fairfield Glade","100 Samaritan Way","Fairfield Glade","TN",38555]
[180443,422,"Cumberland","Dominion Senior Living of Crossville","887 Woodland Road","Crossville","TN",38555]
[180543,482,"Cumberland","Memory Assisted Living at Uplands Village","880 West Main Street","Pleasant Hill","TN",38578]
[190443,29,"Davidson","Burton Court at the Blakeford","11 Burton Hills Boulevard","Nashville","TN",37215]
[190643,40,"Davidson","Maybelle Carter Senior Adult Home","208 West Due West Avenue","Madison","TN",37115]
[190943,59,"Davidson","Belmont Village","4206 Stammer Place","Nashville","TN",37215]
[190543,64,"Davidson","Elmcroft of Brentwood","5436 Edmondson Pike","Nashville","TN",37211]
[191143,66,"Davidson","Cadence at Rivergate","94 Twin Hills Drive","Madison","TN",37115]
[190143,79,"Davidson","J.B. Knowles Home Assisted Living","1010 Camilla Caldwell Lane","Nashville","TN",37218]
[190243,97,"Davidson","Morningside of Belmont","1710 Magnolia Boulevard","Nashville","TN",37212]
[190343,161,"Davidson","The Health Center at Richland Place","504 Elmington Avenue","Nashville","TN",37205]
[191443,175,"Davidson","Barton House","6961 U.S. Highway 70 South","Nashville","TN",37221]
[191743,196,"Davidson","Navion BKE Bellevue, LLC","8118-B Sawyer Brown Road","Nashville","TN",37221]
[191343,199,"Davidson","Brookdale Belle Meade","6767 Brookmont Terrace","Nashville","TN",37205]
[191543,218,"Davidson","Mary, Queen of Angels","34 White Bridge Road","Nashville","TN",37205]
[191843,237,"Davidson","McKendree Village","4347 Lebanon Road","Hermitage","TN",37076]
[192043,248,"Davidson","Hickory Gardens Assisted Living by Americare","527 Old Hickory Boulevard.","Madison","TN",37115]
[191943,259,"Davidson","David Jones, Jr. Assisted Living Center","1204 Schrader Acres Drive","Nashville","TN",37208]
[192143,270,"Davidson","Charter Senior Living at Hermitage","4131 Andrew Jackson Parkway","Hermitage","TN",37076]
[192243,294,"Davidson","Brookdale Green Hills Cumberland","15 Burton Hills Boulevard","Nashville","TN",37215]
[192343,325,"Davidson","Grace Manor","1420 Old Hickory Boulevard","Nashville","TN",37207]
[192443,353,"Davidson","Abe's Garden/Park Manor Apartments","115 Woodmont Boulevard","Nashville","TN",37205]
[192743,360,"Davidson","The Bridge at Hickory Woods","4220 Murfreesboro Pike","Antioch","TN",37013]
[192643,367,"Davidson","The Lodge at Natchez Trace","8207 Highway 100","Nashville","TN",37221]
[192543,390,"Davidson","Azalea Trace Assisted Living","4107 Gallatin Road","Nashville","TN",37216]
[192943,447,"Davidson","NHC Place at the Trace","8353 Highway 100","Nashville","TN",37221]
[193043,448,"Davidson","Opal At Music City","2733 Mccampbell Avenue","Nashville","TN",37214]
[193143,463,"Davidson","Kempton of Hermitage","3778 Central Pike","Hermitage","TN",37076]
[193243,478,"Davidson","Jubilee Hills","322 North Creek Boulevard","Goodlettsvlle","TN",37072]
["193343",491,"Davidson","Clarendale at Bellvue Place","7632 Highway 70 South","Nashville","TN",37221]
[200153,417,"Decatur","Green Crest Assisted Living Centers, Inc.","55 Herbert Volner Lane","Parsons","TN",38363]
[210143,35,"DeKalb","The Webb House Retirement Center","115 Jennings Lane","Smithville","TN",37166]
[210343,189,"DeKalb","NHC HealthCare, Smithville","825 Fisher Avenue","Smithville","TN",37166]
[220143,81,"Dickson","Olive Branch Assisted Living","110 Luther Road","Dickson","TN",37055]
[220243,84,"Dickson","NHC HealthCare, Dickson","812 N. Charlotte Street","Dickson","TN",37055]
[220343,233,"Dickson","Optimum Senior Living","1104 Old Charlotte Road","White Bluff","TN",37187]
[230153,212,"Dyer","Maple Ridge Manor","705 Lake Road","Dyersburg","TN",38024]
[240163,164,"Fayette","NHC HealthCare, Somerville","308 Lake Drive","Somerville","TN",38068]
[240263,343,"Fayette","Someroak Senior Living","10790 Highway 64 West","Somerville","TN",38068]
[260143,191,"Franklin","Franklin Manor, an Inspirit Senior Living Community","3619 Cowan Highway","Winchester","TN",37398]
[260243,262,"Franklin","Bailey Manor","300 Hospital Road","Winchester","TN",37398]
[260343,373,"Franklin","Rockgate Assisted Living Facility, LLC","328 Cumberland Street West","Cowan","TN",37318]
[270153,39,"Gibson","The Arbors At Dogwood Pointe","2080 Craig Drive","Milan","TN",38358]
[270243,397,"Gibson","Cades Center of Humboldt","1632 Highway 45 West By-Pass N","Humboldt","TN",38343]
[270353,468,"Gibson","Dogwood Pointe ","9001 Telecom Drive","Milan","TN",38358]
[280243,1,"Giles","Ivy Crest Assisted Care Living Facility","101 Ivy Lane","Pulaski","TN",38478]
[280143,108,"Giles","Austin Hewitt House","322 East Washington Street","Pulaski","TN",38478]
[300113,85,"Greene","Morning Pointe of Greeneville","324 Mt. Bethel Road","Greeneville","TN",37745]
[300213,151,"Greene","Brookdale Greeneville","155 Serral Drive","Greeneville","TN",37743]
[310113,492,"Grundy","Sheltering Arms","265 Turner Road","Palmer","TN",37365]
[310213,522,"Grundy","Tree of Life ResidentialCare, LLC","293 King Road","Tracy City","TN",37387]
[320223,198,"Hamblen","Dewitt Place","2131 Walters Drive","Morristown","TN",37814]
[320323,288,"Hamblen","Regency Retirement Village","739 East 2Nd North Street","Morristown","TN",37814]
[330333,63,"Hamilton","Elmcroft Of Shallowford C/O Eclipse Senior Living","7127 Lee Highway Suite 500","Chattanooga","TN",37421]
[331133,72,"Hamilton","Elmcroft of Hamilton Place","1502 Gunbarrel Road","Chattanooga","TN",37421]
[331033,137,"Hamilton","Morning Pointe of Chattanooga","7620 Shallowford Road","Chattanooga","TN",37421]
[330833,150,"Hamilton","Regency House","2062 Hamill Road","Hixson","TN",37343]
[330633,177,"Hamilton","Martin-Boyd Christian Home","6845 Standifer Gap Road","Chattanooga","TN",37421]
[330733,183,"Hamilton","Manorhouse Assisted Living","1148 Mountain Creek Road","Chattanooga","TN",37405]
[330933,226,"Hamilton","Assisted Living at Standifer Place","2636 Walker Road","Chattanooga","TN",37421]
[331233,257,"Hamilton","The Terrace at Mountain Creek","1005 Mountain Creek Road","Chattanooga","TN",37405]
[331333,273,"Hamilton","Morning Pointe of Collegedale at Greenbriar Cove","9650 Leyland Drive","Ooltewah","TN",37363]
[331433,286,"Hamilton","The Lantern Alzheimer's Center at Morning Pointe","9300 Messinger Lane","Ooltewah","TN",37363]
[331533,292,"Hamilton","Rose of Sharon's Senior Villa","5410 Lee Avenue","Chattanooga","TN",37410]
[331933,311,"Hamilton","Morning Pointe of Hixson","5501 Old Hixson Pike","Hixson","TN",37343]
[331733,318,"Hamilton","Eagle Crest Assisted Living","8248 Standifer Gap Road","Chattanooga","TN",37421]
[331633,324,"Hamilton","Summit View","825 Runyan Drive","Chattanooga","TN",37405]
[331833,327,"Hamilton","Brookdale Hixson","2515 Hixson Pike","Hixson","TN",37343]
[332033,381,"Hamilton","The Bridge at Ooltewah","5901 Snow Hill Road","Ooltewah","TN",37363]
[332133,387,"Hamilton","Alexian Village of Tennessee","622 Alexian Way","Signal Mountain","TN",37377]
[332233,400,"Hamilton","Morning Pointe of Chattanooga at Shallowford","7719 Shallowford Road","Chattanooga","TN",37421]
[332333,429,"Hamilton","Dominion Senior Living of Hixson","2143 Northpoint Boulevard","Chattanooga","TN",37343]
[332433,499,"Hamilton","Morning Pointe of East Hamilton","9730 East Brainerd Road","Ooltewah","TN",37363]
[360133,200,"Hardin","River Wick","1545 Florence Road","Savannah","TN",38372]
[370113,239,"Hawkins","The Village at Allandale","100 Strickland Court","Kingsport","TN",37660]
[370213,427,"Hawkins","Signature Lifestyles","1341 East Main Street","Rogersville","TN",37857]
[380153,293,"Haywood","Sugar Creek Retirement Center","1169 Dupree Avenue","Brownsville","TN",38012]
[390253,106,"Henderson","Heritage Place of Lexington","1735 N. Broad Street","Lexington","TN",38351]
[390153,118,"Henderson","Oak Haven Assisted Care Living Facility","1460 Crucifer Road","Huron","TN",38345]
[390353,369,"Henderson","Northcliff Assisted Living","14691 Highway 22 North","Lexington","TN",38351]
[400153,30,"Henry","Morningside of Paris","350 Volunteer Drive","Paris","TN",38242]
[400253,49,"Henry","Eiffel Gardens","1025 Volunteer Drive","Paris","TN",38242]
[400453,357,"Henry","Towne Square Care Assisted Living of Puryear","220 College Street","Puryear","TN",38251]
[430143,225,"Humphreys","Magnolia Place","811 West Main Street","Waverly","TN",37185]
[440143,254,"Jackson","Mabry Assisted Living","100 Jettie Mabry Lane","Gainesboro","TN",38562]
[450123,185,"Jefferson","Chandler House","550 Deerview Way","Jefferson City","TN",37760]
[450223,424,"Jefferson","Signature Lifestyle","129 Mosey Creek Drive","Jefferson City","TN",37760]
[460223,497,"Johnson","Sunset Gardens","3683 Highway 421 South","Mountain City","TN",37683]
[470923,6,"Knox","NHC Place, Farragut","122 Cavett Hill Lane","Knoxville","TN",37934]
[470623,18,"Knox","Arbor Terrace of Knoxville","9051 Cross Park Drive","Knoxville","TN",37923]
[470823,28,"Knox","Elmcroft of Halls","7521 Andersonville Pike","Knoxville","TN",37938]
[470523,70,"Knox","Heritage Assisted Living","273 S. Peters Road","Knoxville","TN",37923]
[470723,88,"Knox","Deane Hill Place","401 Catherine Mcauley Way","Knoxville","TN",37919]
[470223,89,"Knox","Williamsburg Villas","3020 Heatherton Way","Knoxville","TN",37920]
[470423,100,"Knox","Atria Weston Place","2900 Lake Brook Boulevard","Knoxville","TN",37909]
[471223,126,"Knox","Elmcroft of West Knoxville","8024 Gleason Drive","Knoxville","TN",37919]
[470123,135,"Knox","Shannondale Assisted Living Center","7350 Middlebrook Pike","Knoxville","TN",37909]
[471023,156,"Knox","Windsor Gardens Assisted Living Center","5611 Central Avenue Pike","Knoxville","TN",37912]
[471123,163,"Knox","Manorhouse Assisted Living","8501 S. Northshore Drive","Knoxville","TN",37922]
[471523,277,"Knox","Renaissance Terrace","215 Bearden Place","Knoxville","TN",37917]
[471423,284,"Knox","Trinity Hills of Knoxville","4611 Asheville Highway","Knoxville","TN",37914]
[471623,310,"Knox","Autumn Care","3222 Byington Beaver Ridge Road","Knoxville","TN",37931]
[471923,348,"Knox","Avenir Memory Care at Knoxville","901 Concord Road","Farragut","TN",37934]
[471723,361,"Knox","Raintree Terrace","555 Rain Forest Road","Knoxville","TN",37923]
[471823,377,"Knox","The CourtYards Senior Living-Knoxville","801 E. Inskip Drive","Knoxville","TN",37912]
[472223,382,"Knox","Autumn Care II, LLC","136 Canton Hollow Road","Knoxville","TN",37922]
[472023,388,"Knox","Maple Court","7545 Thunder Lane","Powell","TN",37849]
[472123,389,"Knox","Morning Pointe of Powell","7700 Dannaher Drive","Powell","TN",37849]
[472323,391,"Knox","Oakwood Senior Living","232 East Churchwell Avenue","Knoxville","TN",37917]
[472623,431,"Knox","Prosperity Pointe","214 Prosperity Drive","Knoxville","TN",37923]
[472523,445,"Knox","The Courtyards Senior Living-Knoxville","1029 W. Parkway Avenue","Knoxville","TN",37912]
[472823,451,"Knox","The Point at Lifespring","4371 Lifespring Lane","Knoxville","TN",37918]
[473223,457,"Knox","Beehive Homes of Powell","1301 West Beaver Creek Drive","Powell","TN",37849]
[473023,459,"Knox","Autumn Care III, LLC","400 Herron Road","Farragut","TN",37984]
[472723,467,"Knox","Northshore Senior Living, LLC","8804 S. Northshore Drive","Knoxville","TN",37922]
[472923,475,"Knox","The Pinnacle on Schaeffer","10520 Waterville Lane","Knoxville","TN",37923]
[473123,484,"Knox","Morning Pointe of Knoxville","9649 Westland Drive","Knoxville","TN",37922]
[473323,488,"Knox","NHC Place, Cavette Hill","121 Cavette Hill Lane","Knoxville","TN",37934]
["473423",495,"Knox","The Lantern at Morning Pointe of Knoxville Alzheimer's Center","9645 Westland Drive","Knoxville","TN",37922]
["473523",514,"Knox","South High Senior Living","835 Tipton Avenue","Knoxville","TN",37920]
[490123,195,"Lauderdale","Asbury Cove","315 Asbury Avenue","Ripley","TN",38063]
[500243,167,"Lawrence","The Sumit of Lawrenceburg","186 Prosser Road","Lawrenceburg","TN",38464]
[500143,168,"Lawrence","Country Cottage - Lawrenceburg","469 Weakley Creek Road","Lawrenceburg","TN",38464]
[500343,295,"Lawrence","Keestone Senior Community","322 Kennedy Street","Lawrenceburg","TN",38464]
[520343,215,"Lincoln","Lincoln Manor, an Inspirit Senior Living Community","115 Medical Center Boulevard","Fayetteville","TN",37334]
[520443,261,"Lincoln","Bailey Manor","113 Medical Center Boulevard","Fayetteville","TN",37334]
[530323,41,"Loudon","River Oaks Place","100 Fifth Avenue","Lenoir City","TN",37771]
[530423,52,"Loudon","River Oaks Place - Loudon","1101 Grove Street","Loudon","TN",37774]
[530523,216,"Loudon","The Neighborhood at Tellico Village","100 Chatuga Drive W","Loudon","TN",37774]
[530623,265,"Loudon","Lakewood Place","1125 Grove Street","Loudon","TN",37774]
[530723,304,"Loudon","Morning Pointe of Lenoir City","198 Morning Pointe Drive","Lenoir City","TN",37772]
[530823,362,"Loudon","The Lantern at Morning Pointe Alzheimer's Center","155 Morning Pointe Drive","Lenoir City","TN",37772]
[560143,23,"Macon","The White House Assisted Living","405 Red Boiling Springs Road","Lafayette","TN",37083]
[560243,302,"Macon","Stonecrest","2861 Hwy 52 By-Pass East","Lafayette","TN",37083]
[570453,2,"Madison","Morningside of Jackson","1200 North Parkway","Jackson","TN",38305]
[570153,21,"Madison","Alexandria Place","108 Physicians Drive","Jackson","TN",38305]
[570253,36,"Madison","Elmcroft of Jackson","911 Old Humboldt Road","Jackson","TN",38305]
[570553,124,"Madison","Regency Retirement Village of Jackson","420 Cheyenne Drive","Jackson","TN",38305]
[570613,328,"Madison","Brookdale Jackson Oaks","3131 N. Highland Avenue","Jackson","TN",38305]
[570713,350,"Madison","Cades Center, Inc.","82 Will Mcknight Drive","Jackson","TN",38301]
[580133,219,"Marion","Valley View Assisted Living","101 North Maple St","Whitwell","TN",37397]
[590143,145,"Marshall","The Village Manor","101 Tiger Boulevard","Lewisburg","TN",37091]
[600143,77,"Maury","Poplar Estates Retirement Center","1310 Rosewood Drive","Columbia","TN",38401]
[600243,92,"Maury","Morning Pointe of Columbia","2050 Union Place","Columbia","TN",38401]
[600443,139,"Maury","Brookdale Columbia","5011 Trotwood Avenue","Columbia","TN",38401]
[600343,165,"Maury","The Bridge Assisted Living at Life Care Center of Columbia","851 W. James Campbell Boulevard","Columbia","TN",38401]
[600543,305,"Maury","Willow Springs Assisted Living and Alzheimers Care by Americare","1040 Campbell Station Parkway","Spring Hill","TN",37174]
[600843,450,"Maury","Morning Pointe of Spring Hill","1001 Mccutheon Creek Lane","Spring Hill","TN",37174]
[600643,456,"Maury","The Reserve At Spring Hill","2000 Reserve Boulevard","Spring Hill","TN",37174]
["600943",507,"Maury","The Lantern at Morning Pointe Alzheimer's Center","1003 McCutcheon Creek Lane","Spring Hill","TN",37174]
[540133,96,"McMinn","Morning Pointe of Athens","1025 Crestway Drive","Athens","TN",37303]
[540233,149,"McMinn","Athens Place","120 Keith Lane","Athens","TN",37303]
[540333,443,"McMinn","Dominion Senior Living of Athens","2090 West Madison Avenue","Athens","TN",37303]
[550153,222,"McNairy","Lynnfield Place Assisted Care Living Facility","150 High School Road","Selmer","TN",38375]
[620123,159,"Monroe","The Lodge at Wood Village","524 Old Highway 68","Sweetwater","TN",37874]
[620223,291,"Monroe","Sweetwater Living, LLC","245 Butler Drive","Sweetwater","TN",37874]
[630243,32,"Montgomery","Dogwood Bend","160 Hillcrest","Clarksville","TN",37043]
[630443,47,"Montgomery","Brookdale Clarksville","2183 Memorial Drive","Clarksville","TN",37043]
[630343,48,"Montgomery","Walking Horse Meadows","207 Uffelman Drive","Clarksville","TN",37043]
[630543,255,"Montgomery","Fieldstone Place","51 Patel Way","Clarksville","TN",37043]
[630643,458,"Montgomery","Arcadia Senior Living Clarksville","175 Chesapeake Drive","Clarksville","TN",37040]
[630743,512,"Montgomery","Jubilee House at Warfield","475 Bellamy Lane","Clarksville","TN",37043]
[660153,20,"Obion","The Etheridge House","701 Sherrill","Union City","TN",38261]
[660253,234,"Obion","Magnolia Place","1620 N. Clover Street","Union City","TN",38261]
[660353,426,"Obion","The Arbors at the Etheridge House","1400 South Home Street","Union City","TN",38261]
[710143,82,"Putnam","Cedar Hills Retirement Center","1250 Cedar Hills Drive","Cookeville","TN",38506]
[710243,91,"Putnam","Morningside of Cookeville","1010 East Spring Street","Cookeville","TN",38501]
[710343,278,"Putnam","Heritage Pointe Senior Living","1030 South Maple Avenue","Cookeville","TN",38501]
[710443,465,"Putnam","Bailey Manor","580 East Veteran'S Boulevard","Cookeville","TN",38501]
[720133,378,"Rhea","The Bridge at Rhea County","10055 Rhea County Highway","Dayton","TN",37321]
[730123,37,"Roane","Jamestowne Assisted Living","851 Lawnville Road","Kingston","TN",37763]
[730323,147,"Roane","Victorian Square Assisted Living","241 S. Chamberlain Avenue","Rockwood","TN",37854]
[730223,152,"Roane","Sycamore Trace","1098 Bradford Way","Kingston","TN",37763]
[740243,51,"Robertson","Morningside of Springfield","205 Westgate Drive","Springfield","TN",37172]
[740143,160,"Robertson","Whitehaven Assisted Care Living Facility","403 South Church Street","Adams","TN",37010]
[740343,240,"Robertson","Springfield Heights Assisted Living Facility","2540 South Main Street","Springfield","TN",37172]
["740443",470,"Robertson","The Arbors at Springfield Heights","2530 South Main Street","Springfield","TN",37172]
[750143,83,"Rutherford","Azalea Court","207 Commerce Drive","Smyrna","TN",37167]
[750343,117,"Rutherford","Park View Meadows","240 Mtcs Road","Murfreesboro","TN",37129]
[750243,127,"Rutherford","Elmcroft of Murfreesboro","3211 Memorial Boulevard","Murfreesboro","TN",37129]
[750443,142,"Rutherford","Stones River Manor","205 Haynes Drive","Murfreesboro","TN",37129]
[750543,169,"Rutherford","Adams Place","1927 Memorial Boulevard","Murfreesboro","TN",37129]
[750643,213,"Rutherford","The Rutherford Assisted Living","1658 Lacassas Pike","Murfreesboro","TN",37130]
[750743,274,"Rutherford","The Rutherford Memory Care","2045 Gold Valley Drive","Murfreesboro","TN",37130]
[750843,296,"Rutherford","The Waterford in Smyrna","10540 Cedar Grove Road","Smyrna","TN",37167]
[750943,308,"Rutherford","Creekside at Three Rivers","2744 Ashers Fork Road","Murfreesboro","TN",37128]
[751243,453,"Rutherford","Harmony at Victory Station","211 Fortress Boulevard","Murfreesboro","TN",37128]
[751443,494,"Rutherford","Traditions of Smyrna","800 Great Circle","Smyrna","TN",37167]
[751343,498,"Rutherford","The Village of Murfreesboro","2550 Willowoak Trail","Murfreesboro","TN",37129]
[780123,13,"Sevier","Mountainbrook Assisted Living","700 Markhill Drive","Sevierville","TN",37862]
[780723,188,"Sevier","Brookdale Sevierville","1020 Middle Creek Road","Sevierville","TN",37862]
[780823,392,"Sevier","Dominion Senior Living of Sevierville","1102 Medical Park Court","Sevierville","TN",37862]
[780923,466,"Sevier","Freedom Senior Living, LLC","2951 Boyds Creek Highway","Sevierville","TN",37876]
[790263,15,"Shelby","Foxbridge Assisted Living and Memory Care","2180 Mangum Road","Memphis","TN",38134]
[790463,22,"Shelby","The Village at Primacy Place","6015 Primacy Parkway","Memphis","TN",38119]
[790363,26,"Shelby","Shelby Gardens Place","1535 Appling Care Lane","Cordova","TN",38018]
[790663,34,"Shelby","Assisted Living at Trezevant","177 N. Highland Avenue","Memphis","TN",38111]
[791463,56,"Shelby","Ave Maria Home Assisted Living","2805 Charles Bryan Road","Bartlett","TN",38134]
[790563,61,"Shelby","Carriage Court of Memphis","1645 West Massey","Memphis","TN",38120]
[791263,62,"Shelby","Elmcroft of Bartlett","3345 Kirby Whitten Parkway","Bartlett","TN",38134]
[790863,73,"Shelby","Brookdale Germantown","7701 Poplar Avenue","Germantown","TN",38138]
[791363,102,"Shelby","Belmont Village","6605 Quail Hollow Road","Memphis","TN",38120]
[791163,131,"Shelby","The Pointe at Kirby Gate","6480 Quince Road","Memphis","TN",38119]
[790963,166,"Shelby","Fireside Villa/Providence Place","3535 Kirby Road","Memphis","TN",38115]
[791563,251,"Shelby","Germantown Plantation Senior Living Community","9293 Poplar Avenue","Germantown","TN",38139]
[791763,253,"Shelby","The Village at Germantown","8020 Walking Horse Circle","Germantown","TN",38138]
[791663,272,"Shelby","Kennington Pointe","6301 Village Grove Drive","Memphis","TN",38115]
[791863,279,"Shelby","Legacy Assisted Living & Memory Care at Lenox Park (Suspended)",null,null,"TN"]
[792163,290,"Shelby","Schilling Gardens Assisted Living by Americare","15 Schilling Bend Commons","Collierville","TN",38017]
[792063,301,"Shelby","Apple Grove Alzheimer's and Dementia Residence","3575 Hacks Cross Road","Memphis","TN",38125]
[791963,312,"Shelby","Ridgemont Manor #2","3815 Ridgemont Avenue","Memphis","TN",38128]
[792263,314,"Shelby","The Glenmary at Evergreen","1550 N. Parkway","Memphis","TN",38112]
[792463,317,"Shelby","Gardens of Germantown","3179 Professional Plaza Drive","Germantown","TN",38138]
[792363,319,"Shelby","Ridgemont Manor #1","3805 Ridgemont Avenue","Memphis","TN",38128]
[792763,352,"Shelby","Brookdale Dogwood Creek","8199 Poplar Avenue","Germantown","TN",38138]
[792863,363,"Shelby","Southbreeze Assisted Living","3168 Hacks Cross Road","Memphis","TN",38125]
[792663,365,"Shelby","Heritage at Irene Woods","4580 S. Forest Hill Irene Road","Memphis","TN",38125]
[792563,370,"Shelby","Riverdale Assisted Living Facility","6880 East Raines Road","Memphis","TN",38115]
[792963,383,"Shelby","Heartside Senior Living at Collierville","601 Wolf River Boulevard","Collierville","TN",38017]
[793163,393,"Shelby","Hearthside Senior Living of  Bartlett","7480 U.S. Highway 70","Bartlett","TN",38133]
[793063,407,"Shelby","Quail Ridge Alzheimer's Special Care Center","2820 Kirby Whitten Parkway","Bartlett","TN",38134]
[793363,471,"Shelby","Springhouse Village of Collierville Assisted Living and Memory Care","1633 E. Winchester Boulevard","Collierville","TN",38017]
[793263,474,"Shelby","Sycamore Place Alzheimer's Special Care Center","8722 Winchester Road","Memphis","TN",38125]
["793463",496,"Shelby","Harborchase of Germantown","6300 Briarcrest Avenue","Memphis","TN",38120]
[800123,405,"Smith","Carthage Assisted Living, LLC","130 Lebanon Highway","Carthage","TN",37030]
[820413,3,"Sullivan","Preston Place Suites","2001 N. John B Dennis Hwy","Kingsport","TN",37660]
[820513,17,"Sullivan","Brookdale Rock Springs","640 Rock Springs Road","Kingsport","TN",37664]
[820213,33,"Sullivan","Asbury Place at Steadman Hill","1300 Bloomingdale Pike","Kingsport","TN",37660]
[820113,38,"Sullivan","Crown Cypress","2424 East Stone Drive","Kingsport","TN",37660]
[820613,94,"Sullivan","Brookdale Kingsport","2424 John B Dennis Highway","Kingsport","TN",37660]
[820813,119,"Sullivan","Elmcroft of Bristol","826 Meadow View Road","Bristol","TN",37620]
[820913,121,"Sullivan","Elmcroft of Kingsport","901 Teasel Drive","Kingsport","TN",37660]
[820313,148,"Sullivan","Brookdale Colonial Heights","400 Professional Park Dr","Kingsport","TN",37663]
[820713,155,"Sullivan","Wellmont Madison House","2000 Greenway Street","Kingsport","TN",37660]
[821013,280,"Sullivan","Preston Place II","2303 N. John B. Dennis Highway","Kingsport","TN",37660]
[821113,437,"Sullivan","Dominion Senior Living of Bristol","425 Shelby Lane","Bristol","TN",37620]
[821213,518,"Sullivan","The Blake at Kingsport","915 Holston Hills Drive","Kingsport","TN",37664]
[830343,50,"Sumner","Morningside of Gallatin","1085 Hartsville Pike","Gallatin","TN",37066]
[830143,75,"Sumner","Park Place Retirement Community","31 Executive Park Drive","Hendersonville","TN",37075]
[830743,86,"Sumner","Brookdale Goodlettsville","2025 Caldwell Drive","Goodlettsville","TN",37072]
[830543,123,"Sumner","Elmcroft of Hendersonville","1020 Carrington Place","Hendersonville","TN",37075]
[830443,140,"Sumner","Brookdale Gallatin","400 Hancock Road","Gallatin","TN",37066]
[830843,141,"Sumner","Main Street Senior Living","674 East Main Street","Hendersonville","TN",37075]
[830643,178,"Sumner","Brookdale Goodlettsville","3001 Business Park Circle","Goodlettsville","TN",37072]
[830943,299,"Sumner","Richland Place Senior Living Center","201 Richland Lake Drive","Portland","TN",37148]
[831143,321,"Sumner","Hearth at Hendersonville","419 East Main Street","Hendersonville","TN",37075]
[831043,329,"Sumner","Red Cedar Glen","202 Walton Ferry Road","Hendersonville","TN",37075]
[831243,372,"Sumner","The Meadows at Halltown, Inc.","711 Halltown Road","Portland","TN",37148]
[831343,401,"Sumner","NHC Place Sumner","140 Thorne Boulevard","Gallatin","TN",37066]
[831443,432,"Sumner","Hickory Hills Alzeheimer's Special Care Centr","162 Indian Lake Boulevard","Hendersonville","TN",37075]
[831643,472,"Sumner","Clarendale at Indian Lake","195 Indian Lake Boulevard","Hendersonville","TN",37075]
[831543,503,"Sumner","Maple Cottage Assisted Living","101 Maple Drive","Hendersonville","TN",37075]
[831743,510,"Sumner","The Place at Crossfield","111 Crossfield Drive","Hendersonville","TN",37075]
[840163,45,"Tipton","Parkway Cove","805 Bert Johnston","Covington","TN",38019]
[850143,276,"Trousdale","Trousdale Senior Living Center","263 W. Mcmurry Boulevard","Hartsville","TN",37074]
[860113,341,"Unicoi","Governor's Bend Retirement & Assisted Living","1631 Zane Whitson Drive","Erwin","TN",37650]
[890143,114,"Warren","Riverview Terrace","114 Highland Drive","McMinnville","TN",37110]
[890243,170,"Warren","McMinnville Boarding Home for the Elderly","345 Garfield Street","McMinnville","TN",37110]
[890443,368,"Warren","The Web House Retirement Center of McMinnville Inc.","3877 Manchester Highway","McMinnville","TN",37110]
[900113,4,"Washington","Family Ministries John M. Reed Center, LLC","124 John M. Reed Home Road","Limestone","TN",37681]
[900213,78,"Washington","Cornerstone Village South Assisted Living","213 University Parkway","Johnson City","TN",37604]
[900413,125,"Washington","Elmcroft of Johnson City","406 E. Mountain View Road","Johnson City","TN",37604]
[900313,154,"Washington","Brookdale Johnson City","2003 Water'S Edge Drive","Johnson City","TN",37604]
[900513,263,"Washington","Cornerstone Village North Assisted Living","2012 Sherwood Drive","Johnson City","TN",37601]
[900613,376,"Washington","The CourtYards Senior Living-Johnson City","2111 E. Lakeview Drive","Johnson City","TN",37601]
[900713,402,"Washington","Dominion Senior Living of Johnson City","2412 Knob Creek Road","Johnson City","TN",37604]
[900813,486,"Washington","Princeton Transitional Care & Assisted Living","401 Princeton Road","Johnson City","TN",37601]
[910143,227,"Wayne","Boyd Cottages Assisted Living","210 Fairlane Drive","Waynesboro","TN",38485]
[920153,46,"Weakley","Greenbrier Meadows","436 Hannings Lane","Martin","TN",38237]
[930143,208,"White","The Bridge Assisted Living at Life Care Center of Sparta","508 Mose Drive","Sparta","TN",38583]
[940543,7,"Williamson","Southern Care","3595 Carothers Parkway","Franklin","TN",37067]
[940343,87,"Williamson","Morningside of Franklin","105 Sunrise Circle","Franklin","TN",37067]
[940243,103,"Williamson","Brighton Gardens of Brentwood","103 Arcaro Place","Brentwood","TN",37027]
[940443,157,"Williamson","Belvedere Commons of Franklin","303 South Royal Oaks Boulevard","Franklin","TN",37064]
[940743,245,"Williamson","NHC Place at Cool Springs","211 Cool Springs Boulevard","Franklin","TN",37069]
[940843,300,"Williamson","Southerland Place","200 Winners Circle South","Brentwood","TN",37027]
[940943,307,"Williamson","The Maristone of Franklin","347 Riverside Drive","Franklin","TN",37064]
[941143,364,"Williamson","Morning Pointe of Brentwood","1522 Wilson Pike","Brentwood","TN",37027]
[941043,371,"Williamson","Wellington Place","209 Ward Circle","Brentwood","TN",37027]
[941343,384,"Williamson","The Hearth at Franklin","1035 Fulton Greer Lane","Franklin","TN",37064]
[941243,395,"Williamson","Fountains of Franklin","4100 Murfreesboro Road","Franklin","TN",37067]
[941443,415,"Williamson","Morning Pointe of Franklin","1005 Generations Way","Franklin","TN",37064]
[941543,434,"Williamson","Somberby of Franklin","870 Oak Meadow Drive","Franklin","TN",37064]
[941743,449,"Williamson","Canterfield of Franklin","7015 Moores Lane","Brentwood","TN",37027]
[941643,455,"Williamson","Traditions of Spring Hill","3056 Miles Johnson Parkwy","Spring Hill","TN",37174]
[942043,460,"Williamson","Harmony at Brentwood","9045 Church Street East","Brentwood","TN",37027]
[941943,485,"Williamson","Somerfield at the Heritage","900 Heritage Way","Brentwood","TN",37027]
["942143",493,"Williamson","Traditions of Mill Creek","7119 South Pointe Parkway","Brentwood","TN",37027]
[941843,502,"Williamson","The Lantern at Morning Pointe of Franklin","1015 Generations Way","Franklin","TN",37064]
[950343,138,"Wilson","Elmcroft of Lebanon","801 West Main Street","Lebanon","TN",37087]
[950243,158,"Wilson","Wilson Manor, an Inspirit Senior Living Community","900 Coles Ferry Pike","Lebanon","TN",37087]
[950843,173,"Wilson","Hearthside at Castle Heights","215 Castle Heights Avenue North","Lebanon","TN",37087]
[950543,174,"Wilson","Providence Place of Mount Juliet","1020 Charlie Daniels Parkway","Mount Juliet","TN",37122]
[950643,230,"Wilson","Bellwood Assisted Living","3190 Carthage Highway","Lebanon","TN",37087]
[950943,285,"Wilson","The Gardens at Providence Place","1016 Charlie Daniels Parkway","Mount Juliet","TN",37122]
[951043,347,"Wilson","Carrick Glen Senior Living","100 Carrick Court","Mount Juliet","TN",37122]
[951143,359,"Wilson","Maristone of Providence","140 Providence Trail","Mount Juliet","TN",37122]
[951243,480,"Wilson","The Pavilion Assisted living, LLC","1409 Medical Center Drive","Lebanon","TN",37087]

{"sheet":"Sch A","index":2,"n_rows":32,"n_cols":48,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,33,1,35],[1,15,1,32],[9,12,9,35],[10,37,12,37],[11,39,13,39],[6,37,7,37],[2,0,2,35],[12,27,12,35],[11,12,11,20],[12,12,12,20],[12,21,12,26],[11,21,11,26],[12,5,12,11],[11,27,11,35],[8,33,8,35],[6,5,6,11],[16,39,18,39],[17,38,19,38],[14,5,14,32],[17,21,17,26],[17,27,17,35],[17,12,17,20],[16,12,16,35],[14,33,14,35],[15,5,15,11],[16,5,16,11],[17,5,17,11],[23,30,23,35],[18,5,18,11],[19,5,19,11],[20,5,20,11],[18,21,18,26],[25,30,25,35],[25,5,25,29],[5,5,5,11],[5,12,5,35],[6,12,6,35],[7,5,7,11],[10,12,10,35],[9,5,9,11],[7,12,7,35],[8,5,8,32],[10,5,10,11],[24,30,24,35],[18,12,18,20],[23,21,23,29],[22,5,22,32],[22,33,22,35],[0,37,0,39],[27,5,27,11],[28,5,28,11],[27,12,27,35],[28,12,28,35],[0,0,0,35],[26,37,27,37],[22,38,24,38],[24,21,24,29],[23,5,24,20],[26,5,26,11],[26,0,28,4],[1,0,1,3],[1,4,1,8],[1,9,1,14],[3,0,3,35],[26,12,26,35],[21,0,25,4],[21,5,21,35],[31,0,31,35],[6,38,7,38],[29,0,29,35],[30,0,30,35],[11,5,11,11],[13,12,13,35],[15,12,15,35],[18,0,20,4],[5,0,17,4],[18,27,18,35],[13,5,13,11],[19,12,19,35],[20,12,20,35]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
["Schedule A - Identification"]
["According to the Department of Health Rules and Regulations Section 1200-8-25.13(2), \"The Joint Annual Report of\nAssisted Care Living Facilities shall be filed with the department. The forms… must be completed and returned to the\ndepartment as required.\" Please read all information carefully before completing your Joint Annual Report with data\nfor the year specified above. Please complete all items, using 0 (zero) when appropriate and checking all appropriate\ncheck boxes. Any items which appear to be inconsistent will be queried. Facilities will be reported to the Board\nfor Licensing Health Care Facilities for failure to timely file a complete report or respond to queries."]
[]
["Facility",null,null,null,null,"State ID",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,{"$f":"IF(A_StAddr<>\"\",1,0)","v":0},{"$f":"SUM(AO6:AO11)","v":0}]
[null,null,null,null,null,"License Number",null,null,null,null,null,null,{"$f":"AU7","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No\nQuestion","Prior\nName",null,{"$f":"IF(A_City<>\"\",1,0)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,2,FALSE)), \"-\",VLOOKUP(A_StateID,'State ID'!A:H,2,FALSE))","v":"-"}]
[null,null,null,null,null,"ACLF Name",null,null,null,null,null,null,{"$f":"AU8","v":"-"},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,{"$f":"IF(A_County<>\"\",1,0)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,4,FALSE)), \"-\",VLOOKUP(A_StateID,'State ID'!A:H,4,FALSE))","v":"-"}]
[null,null,null,null,null,"Did the facility's name change during the reporting period?                                     Yes/No",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,{"$f":"IF(A_NameChangeYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AP9=AP10,\"Ok\",\"Error\")","v":"Error"},null,{"$f":"IF(A_State<>\"\",1,0)","v":0},{"$f":"IF(A_NameChangeYN=\"No\",1,0)","v":0}]
[null,null,null,null,null,"If Yes, Prior Name",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,{"$f":"IF(A_ZipCode<>\"\",1,0)","v":0},{"$f":"IF(A_PriorName<>\"\",0,1)","v":1}]
[null,null,null,null,null,"Street Address",null,null,null,null,null,null,{"$f":"AU11","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street\nAddress\ndata\nprovided",null,null,{"$f":"IF(LEN(A_Phone)=10,1,0)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,5,FALSE)), \"\",VLOOKUP(A_StateID,'State ID'!A:H,5,FALSE))","v":""}]
[null,null,null,null,null,"City",null,null,null,null,null,null,{"$f":"AU12","v":""},null,null,null,null,null,null,null,null,"County",null,null,null,null,null,{"$f":"AV12","v":""},null,null,null,null,null,null,null,null,null,null,null,"Mailing\nAddress\nYes/No\nQuestion",null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,6,FALSE)), \"\",VLOOKUP(A_StateID,'State ID'!A:H,6,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,3,FALSE)), \"\",VLOOKUP(A_StateID,'State ID'!A:H,3,FALSE))","v":""}]
[null,null,null,null,null,"State   ",null,null,null,null,null,null,{"$f":"AU13","v":""},null,null,null,null,null,null,null,null,"Zip Code (5 digit)",null,null,null,null,null,{"$f":"AU14","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,7,FALSE)), \"\",VLOOKUP(A_StateID,'State ID'!A:H,7,FALSE))","v":""}]
[null,null,null,null,null,"Phone (10 digit)",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,{"$f":"IF(AP6=6,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(A_Preparer<>\"\",1,0)","v":0},{"$f":"SUM(AO14:AO21)","v":0},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A_StateID,'State ID'!A:H,8,FALSE)), \"\",VLOOKUP(A_StateID,'State ID'!A:H,8,FALSE))","v":""}]
[null,null,null,null,null,"Mailing Address same as Street Address?  If Yes, proceed to next section.              Yes/No",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,{"$f":"IF(A_MailAddYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Mailing Address",null,null,null,null,null,null,{"$f":"IF(AH15=\"Yes\",M11,\"\")","v":""}]
[null,null,null,null,null,"City",null,null,null,null,null,null,{"$f":"IF(AH15=\"Yes\",M12,\"\")","v":""},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,"Mailing\nAddress\ndata\nprovided"]
[null,null,null,null,null,"State",null,null,null,null,null,null,{"$f":"IF(AH15=\"Yes\",M13,\"\")","v":""},null,null,null,null,null,null,null,null,"Zip Code (5 digit)",null,null,null,null,null,{"$f":"IF(AH15=\"Yes\",AB13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Preparer\ndata\nprovided"]
["Preparer",null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_PreparerTitle<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Title",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,{"$f":"IF(AND(A_Mailadd<>\"\", A_MailAddCity<>\"\",A_MailAddState<>\"\",A_MailAddZip<>\"\"),\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(A_PreparerPhone<>\"\",1,0)","v":0},{"$f":"IF(A_MailAddYN=\"Yes\",1,0)","v":0}]
[null,null,null,null,null,"E-Mail",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,{"$f":"IF(AP14=4,\"Ok\",\"Error\")","v":"Error"},null,{"$f":"IF(A_PreparerEmail<>\"\",1,0)","v":0},{"$f":"IF(A_Mailadd<>\"\",1,0)","v":0}]
["Reporting\nPeriod",null,null,null,null,"If you are reporting for less than one full year, utilization and financial data should be presented for\ndays reported only.",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,"Yes/No\nQuestion",null,null,null,{"$f":"IF(A_MailAddCity<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Is the reporting period from January 1 through December 31?                                   Yes/No",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,{"$f":"IF(A_RepPedYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},"Reporting\nPeriod\nEnd date\nafter\nBeginning\ndate",null,null,{"$f":"IF(A_MailAddState<>\"\",1,0)","v":0}]
[null,null,null,null,null,"If unable to report based on above dates, provide\nthe beginning and ending dates (used for all\nutilization and financial data)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beginning     (mm/dd/yyyy)",null,null,null,null,null,null,null,null,{"$f":"IF(AH23=\"Yes\",\"01/01/2020\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A_MailAddZip<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ending         (mm/dd/yyyy)",null,null,null,null,null,null,null,null,{"$f":"IF(AH23=\"Yes\",\"12/31/2020\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP20:AP24)","v":0}]
[null,null,null,null,null,"Number of days in reporting period (System Calculated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(A_EReportP-A_BReportP+1), \"\", A_EReportP-A_BReportP+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(A_DaysReported>=0,A_DaysReported<>\"\"),\"OK\",\"Error\")","v":"Error"}]
["Administration",null,null,null,null,"Name of\nAdministrator",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,"Admin\ndata\nprovided",null,null,{"$f":"IF(A_Admin<>\"\",1,0)","v":0},{"$f":"SUM(AO27:AO29)","v":0}]
[null,null,null,null,null,"Administrator\nEmail Address",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,{"$f":"IF(A_AdminEmail<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Name of Medical\nDirector",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,{"$f":"IF(AP27=3,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(A_AdminMedDir<>\"\",1,0)","v":0}]
["Return to Main Menu"]
["Go to Next Schedule"]
["Error Listing"]

{"sheet":"A-Data","index":3,"n_rows":4,"n_cols":30,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,null,"Facility",null,null,"Facility (Continued)",null,null,"Facility (Continued)",null,null,null,null,null,null,null,null,"Preparer","Preparer (Continued)",null,null,"Reporting Period",null,null,null,"Administration"]
[]
["State\nID","Facility Name","County","State\nID","License\nNumber","Facility Name","Name\nChange\nYes/No","Prior Name","Street\nAddress","City","County","State","Zip\nCode","Phone","Mailing\nAddress\nYes/No","Mailing\nAddess","Mailing\nCity","Mailing\nState","Mailing\nZip","Name","Title","Phone","Email address","Yes/No","Beginning\nDate","Ending\nDate","Number\nof Days","Administrator\nName","Facility\nEmail","Medical\nDirector"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"A_StateID","v":0},{"$f":"A_LicenseNum","v":"-"},{"$f":"A_FacilityName","v":"-"},{"$f":"A_NameChangeYN","v":"-"},{"$f":"A_PriorName","v":0},{"$f":"A_StAddr","v":""},{"$f":"A_City","v":""},{"$f":"A_County","v":""},{"$f":"A_State","v":""},{"$f":"A_ZipCode","v":""},{"$f":"A_Phone","v":0},{"$f":"A_MailAddYN","v":"-"},{"$f":"A_Mailadd","v":""},{"$f":"A_MailAddCity","v":""},{"$f":"A_MailAddState","v":""},{"$f":"A_MailAddZip","v":""},{"$f":"A_Preparer","v":0},{"$f":"A_PreparerTitle","v":0},{"$f":"A_PreparerPhone","v":0},{"$f":"A_PreparerEmail","v":0},{"$f":"A_RepPedYN","v":"-"},{"$f":"A_BReportP","v":""},{"$f":"A_EReportP","v":""},{"$f":"A_DaysReported","v":""},{"$f":"A_Admin","v":0},{"$f":"A_AdminEmail","v":0},{"$f":"A_AdminMedDir","v":0}]

{"sheet":"Sch B","index":4,"n_rows":34,"n_cols":54,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,37,0,38],[1,33,1,35],[1,0,1,3],[1,4,1,8],[1,9,1,14],[1,15,1,32],[0,0,0,35],[2,0,2,35],[3,0,3,35],[5,9,5,35],[4,7,4,8],[8,9,8,35],[4,0,17,3],[4,4,9,6],[13,4,17,6],[9,9,9,35],[11,9,11,35],[12,9,12,35],[12,7,12,8],[4,9,4,35],[5,7,5,8],[7,9,7,35],[6,7,6,8],[20,18,20,21],[23,13,26,17],[23,22,23,35],[24,22,24,35],[27,13,30,17],[30,31,30,35],[27,18,27,21],[28,18,28,21],[29,18,29,21],[23,18,23,21],[27,7,30,9],[24,18,24,21],[25,18,25,21],[30,18,30,21],[7,7,7,8],[8,7,8,8],[27,10,30,12],[18,7,18,12],[18,13,18,35],[23,10,26,12],[23,7,26,9],[26,18,26,21],[26,27,26,30],[25,22,25,35],[26,22,26,26],[26,31,26,35],[6,9,6,35],[10,9,10,35],[17,7,17,8],[17,16,17,35],[9,7,9,8],[10,7,10,8],[11,7,11,8],[13,7,13,8],[18,38,21,38],[13,9,13,35],[14,9,14,35],[15,9,15,35],[16,9,16,35],[21,22,21,35],[19,13,22,17],[22,31,22,35],[22,27,22,30],[22,22,22,26],[22,18,22,21],[21,18,21,21],[19,10,22,12],[19,18,19,21],[19,22,19,35],[12,38,16,38],[10,4,12,6],[33,0,33,35],[17,9,17,15],[14,7,14,8],[15,7,15,8],[20,22,20,35],[31,0,31,35],[32,0,32,35],[16,7,16,8],[19,7,22,9],[18,0,30,6],[30,27,30,30],[27,22,27,35],[28,22,28,35],[29,22,29,35],[30,22,30,26]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020}]
["Schedule B - Ownership of Business"]
["Please select one item in each category that best describes your facility."]
["Type of\nOwner\n(select only\none)",null,null,null,"For\nProfit",null,null,"-",null," (For Profit) Proprietorship – a business owned by one person.",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,{"$f":"IF(B_ProProp=\"X\",1,0)","v":0},{"$f":"SUM(AO5:AO18)","v":0}]
[null,null,null,null,null,null,null,"-",null," (For Profit) Partnership – an association of two or more persons to carry on as \n co-owners of a business or other undertaking for profit formed under  61-1-202, \n predecessor law, or comparable law of another jurisdiction. TCA Title 61 Chapter 1.",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,{"$f":"IF(B_ProPart=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null," (For Profit) Limited Partnership (LP) – a partnership formed by two or more persons \n under the law of the state of Tennessee, and having one or more general partners \n and one or more limited partners. TCA Title 61 Chapter 2.",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,{"$f":"IF(B_ProLP=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null," (For Profit) Limited Liability Partnership (LLP) – is governed by TCA § 61-1-106(C).  \n The law of this state governs relations among the partners and between the partners \n and the partnership and the liability of partners for an obligation of a limited liability \n partnership that has filed an application as a limited liability partnership in this state.",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,"Type of\nOwner\n(Check 1)",null,null,{"$f":"IF(B_ProLLP=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null," (For Profit) Limited Liability Company (LLC) – established by “The Tennessee \n Limited Liability Company Act” found in the TCA § 48-201-101 through § 48-248-606.",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,{"$f":"IF(AP5=1,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(B_ProLLC=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null," (For Profit) Corporation – defined by the Tennessee Business Corporation Act \n codified in TCA Title 48 Chapters 11-27.",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,{"$f":"IF(B_ProCorp=\"X\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Not\nFor\nProfit",null,null,"-",null," (Not For Profit) Non-Religious Corporation or Association – defined by \n “Tennessee Nonprofit Corporation Act” codified in TCA Title 48 Chapters 51-68.",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,{"$f":"IF(B_NFPNonRel=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null," (Not For Profit) Religious Corporation or Association – either a corporation or \n association that is organized and operated primarily or exclusively for religious \n purposes. Most of the provisions of the Tennessee Nonprofit Corporation Act \n apply to a religious corporation. Exceptions are specified in TCA § 48-67.",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,{"$f":"IF(B_NFPRel=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null," (Not For Profit) Limited Liability Company (LLC) – a company that is disregarded as  \n an entity for federal income tax purposes, and whose sole member is a nonprofit \n corporation, foreign or domestic, incorporated under or subject to the provisions of \n the Tennessee Nonprofit Corporation Act and who is exempt from franchise and \n excise tax as not-for-profit as defined in TCA § 67-4-1004(15).",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,"Other\nGovt\nSelected,\nProvide\nAdditional\nData",null,{"$f":"IF(B_NFPLLC=\"X\",1,0)","v":0}]
[null,null,null,null,"Govern-\nment",null,null,"-",null,"City",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,{"$f":"IF(B_GovCity=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null,"County",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,{"$f":"IF(B_GovCounty=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null,"State",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,{"$f":"IF(B_GovState=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null,"Federal",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,{"$f":"IF(B_GovFederal=\"X\",1,0)","v":0}]
[null,null,null,null,null,null,null,"-",null,"Other Government,\nspecify",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,{"$f":"IF(AND(B_GovOtherGov=\"-\",B_GovOtherSpecify=\"\"),\"Ok\",IF(AND(B_GovOtherGov=\"X\",B_GovOtherSpecify<>\"\"),\"OK\",\"Error\"))","v":"Ok"},null,{"$f":"IF(B_GovOtherGov=\"X\",1,0)","v":0}]
["Owner\nand\nBusiness\nInformation",null,null,null,null,null,null," Name of Owner\n(legal entity)",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,"Yes/No\nquestion","Yes\nIndicated,\nadditional\ndata\nprovided"]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Chain",null,null,null,null," Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnCHName<>\"\",1,0)","v":0},{"$f":"IF(B_OwnCHState<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnCHYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(B_OwnCHStreet<>\"\",1,0)","v":0},{"$f":"IF(B_OwnCHZip<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnCHCity<>\"\",1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," State",null,null,null,null,null,null,null,null," Zip Code",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B_OwnCHYN=\"No\",AO23=0),\"Ok\",IF(AND(B_OwnCHYN=\"Yes\",AO23=5),\"Ok\",\"Error\"))","v":"Error"},null,{"$f":"SUM(AO20:AP22)","v":0}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Holding\nCompany/\nParent\nCorporation",null,null,null,null," Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnHCName<>\"\",1,0)","v":0},{"$f":"IF(B_OwnHCState<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnHCYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(B_OwnHCStreet<>\"\",1,0)","v":0},{"$f":"IF(B_OwnHCZip<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnHCCity<>\"\",1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," State",null,null,null,null,null,null,null,null," Zip Code",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B_OwnHCYN=\"No\",AO27=0),\"Ok\",IF(AND(B_OwnHCYN=\"Yes\",AO27=5),\"Ok\",\"Error\"))","v":"Error"},null,{"$f":"SUM(AO24:AP26)","v":0}]
[null,null,null,null,null,null,null,"Yes/No",null,null,"-",null,null,"Contract with\nManagement\nFirm",null,null,null,null," Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnFirmName<>\"\",1,0)","v":0},{"$f":"IF(B_OwnFirmState<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnFirmYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(B_OwnFirmStreet<>\"\",1,0)","v":0},{"$f":"IF(B_OwnFirmZip<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B_OwnFirmCity<>\"\",1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," State",null,null,null,null,null,null,null,null," Zip Code",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B_OwnFirmYN=\"No\",AO31=0),\"Ok\",IF(AND(B_OwnFirmYN=\"Yes\",AO31=5),\"Ok\",\"Error\"))","v":"Error"},null,{"$f":"SUM(AO28:AP30)","v":0}]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"B-Data","index":5,"n_rows":4,"n_cols":37,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Type of Owner (select only one)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner and Business Information"]
[null,null,null,"For Profit",null,null,null,null,null,"Not For Profit",null,null,"Government",null,null,null,null,null,null,"Chain",null,null,null,null,null,"Holding Company/Parent Corporation",null,null,null,null,null,"Contract with Management Firm"]
["State\nID","Facility Name","County","Proprietor-\nship","Partner-\nship","Limited\nPartner-\nship","Limited\nLiability\nPartner-\nship","Limited\nLiability\nCompany","Corp-\noration","Non-\nReligious\nCorp","Religious\nCorp","Limited\nLiability\nCompany","City","County","State","Federal","Other","Specify","Name of\nOwner","Yes/No","Name","Street","City","State","Zip\nCode","Yes/No","Name","Street","City","State","Zip\nCode","Yes/No","Name","Street","City","State","Zip\nCode"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"B_ProProp","v":"-"},{"$f":"B_ProPart","v":"-"},{"$f":"B_ProLP","v":"-"},{"$f":"B_ProLLP","v":"-"},{"$f":"B_ProLLC","v":"-"},{"$f":"B_ProCorp","v":"-"},{"$f":"B_NFPNonRel","v":"-"},{"$f":"B_NFPRel","v":"-"},{"$f":"B_NFPLLC","v":"-"},{"$f":"B_GovCity","v":"-"},{"$f":"B_GovCounty","v":"-"},{"$f":"B_GovState","v":"-"},{"$f":"B_GovFederal","v":"-"},{"$f":"B_GovOtherGov","v":"-"},{"$f":"B_GovOtherSpecify","v":0},{"$f":"B_OwnLglName","v":0},{"$f":"B_OwnCHYN","v":"-"},{"$f":"B_OwnCHName","v":0},{"$f":"B_OwnCHStreet","v":0},{"$f":"B_OwnCHCity","v":0},{"$f":"B_OwnCHState","v":0},{"$f":"B_OwnCHZip","v":0},{"$f":"B_OwnHCYN","v":"-"},{"$f":"B_OwnHCName","v":0},{"$f":"B_OwnHCStreet","v":0},{"$f":"B_OwnHCCity","v":0},{"$f":"B_OwnHCState","v":0},{"$f":"B_OwnHCZip","v":0},{"$f":"B_OwnFirmYN","v":"-"},{"$f":"B_OwnFirmName","v":0},{"$f":"B_OwnFirmStreet","v":0},{"$f":"B_OwnFirmCity","v":0},{"$f":"B_OwnFirmState","v":0},{"$f":"B_OwnFirmZip","v":0}]

{"sheet":"Sch C","index":6,"n_rows":13,"n_cols":40,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,0,12,35],[10,0,10,35],[11,0,11,35],[5,0,6,4],[7,0,9,4],[5,8,5,10],[6,8,6,10],[6,11,6,35],[7,8,8,10],[9,5,9,7],[5,5,5,7],[6,5,6,7],[7,5,8,7],[9,8,9,10],[7,11,7,35],[8,11,8,22],[8,23,8,35],[1,4,1,8],[1,9,1,14],[5,11,5,35],[9,11,9,35],[2,0,2,35],[0,37,0,39],[1,37,2,37],[3,0,4,4],[3,5,4,7],[3,8,4,10],[3,11,3,35],[4,11,4,22],[4,23,4,35],[1,38,2,38],[1,0,1,3],[0,0,0,35],[1,39,2,39],[1,33,1,35],[1,15,1,32]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020},null,null,null,"Yes/No\nQuestion","Additional\nData\nProvided",""]
["Schedule C - Facilities and Services"]
["Facilities",null,null,null,null,"Yes/No",null,null,"-",null,null," Did your facility have new construction and/or services during the year that\n resulted  in a change of the facility's licensed bed count?",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,{"$f":"IF(C_FAcConsYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null," Cost of new construction",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,{"$f":"IF(AND(C_FAcConsYN=\"No\",C_FacConsSpec=\"\"),\"Ok\",IF(AND(C_FAcConsYN=\"No\",C_FacConsSpec=0),\"Ok\",IF(AND(C_FAcConsYN=\"Yes\",C_FacConsSpec>=1),\"Ok\",\"Error\")))","v":"Error"}]
["Services",null,null,null,null,"Yes/No",null,null,"-",null,null," Does the facility operate an adult day care center?\n This program generally has minimal medical and social supervision for the older\n person who has help at home during the evening, but whose family or spouse\n is employed during the day.  Services can include general assistance with the\n needs of daily living, socialization and lunches.  In some instances, restorative\n and therapeutic programs may be included.",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,{"$f":"IF(C_SerDayCYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Yes/No",null,null,"-",null,null," Does the facility provide respite care?\n This program provides overnight accommodations as well as some minimal\n medical and social supervision for older persons whose families may be\n temporarily unable to provide care for them.",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,{"$f":"IF(C_SerResCYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
["Alzheimer's\nServices",null,null,null,null,"Yes/No",null,null,"-",null,null," Does the facility have a specialized unit for Alzheimer's residents?",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,{"$f":"IF(C_SerAlzUYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null," If yes, number of beds in that unit",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,{"$f":"IF(AND(C_SerAlzUYN=\"No\",C_SerAlzUBed=\"\"),\"Ok\",IF(AND(C_SerAlzUYN=\"No\",C_SerAlzUBed=0),\"Ok\",IF(AND(C_SerAlzUYN=\"Yes\",C_SerAlzUBed>=1),\"Ok\",\"Error\")))","v":"Error"}]
[null,null,null,null,null,"Yes/No",null,null,"-",null,null," Does the facility have specialized programs for Alzheimer's residents?",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,{"$f":"IF(C_SerAlzPYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"C-Data","index":7,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Facilities",null,"Services"]
[null,null,null,"New Construction",null,"","","","",""]
["State\nID","Facility Name","County","Yes/No","Cost","Adult Day\nCare\nCenter\nYes/No","Respite\nCare\nYes/No","Alzheimer\nUnit\nYes/No","Alzheimer\nUnit\nnumber\nof beds","Specialized\nprograms\nfor\nAlzheimer\nresidents"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"C_FAcConsYN","v":"-"},{"$f":"C_FacConsSpec","v":0},{"$f":"C_SerDayCYN","v":"-"},{"$f":"C_SerResCYN","v":"-"},{"$f":"C_SerAlzUYN","v":"-"},{"$f":"C_SerAlzUBed","v":0},{"$f":"C_SerAlzPYN","v":"-"}]

{"sheet":"Sch D","index":8,"n_rows":16,"n_cols":40,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,8,9,10],[7,11,7,35],[8,30,8,35],[7,5,9,7],[3,0,9,4],[15,0,15,35],[13,0,13,35],[14,0,14,35],[11,30,11,35],[10,0,10,4],[10,5,10,29],[12,30,12,35],[11,24,11,29],[12,24,12,29],[11,5,12,23],[10,30,10,35],[11,0,12,4],[0,37,0,39],[1,37,2,37],[4,5,6,7],[4,8,6,10],[4,11,4,35],[1,38,2,38],[1,39,2,39],[2,0,2,35],[1,0,1,3],[1,9,1,14],[1,4,1,8],[3,30,3,35],[3,5,3,29],[0,0,0,35],[1,33,1,35],[1,15,1,32],[5,39,9,39],[9,11,9,17],[9,24,9,29],[9,30,9,35],[8,11,8,17],[8,18,8,23],[5,11,5,17],[5,18,5,23],[5,24,5,29],[5,30,5,35],[6,30,6,35],[6,24,6,29],[6,18,6,23],[6,11,6,17],[8,24,8,29],[9,18,9,23]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020},null,null,null,"Yes/No\nQuestion","Additional\nData\nProvided",""]
["Schedule D - Beds"]
["Licensed\nBeds",null,null,null,null," Number of beds licensed as of the last day of the reporting period.\n The number of licensed beds should equal the number of beds that you have\n been licensed to operate in the facility by the Tennessee Department of Health.",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,{"$f":"IF(D_LBedNum>=1,\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Yes/No",null,null,"-",null,null," Did your facility have an increase in the number of licensed beds during the year?\n If yes, please provide the number of beds increased.",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,{"$f":"IF(D_LBedIYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null," Date 1\n (MM/DD/YYYY)",null,null,null,null,null,null,null,null,null,null,null,null," Number of Beds 1",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D_LBedIYN=\"No\",D_LBedIDat1=\"\",D_LBedINum1=\"\"),\"Ok\",IF(AND(D_LBedIYN=\"Yes\",D_LBedIDat1<>\"\",D_LBedINum1>=1),\"Ok\",\"Error\"))","v":"Error"},"Set up &\nstaffed\nbeds\nequal to\nPrivate &\nSemi-\nPrivate\nbeds"]
[null,null,null,null,null,null,null,null,null,null,null," Date 2\n (MM/DD/YYYY)",null,null,null,null,null,null,null,null,null,null,null,null," Number of Beds 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AM6=\"Ok\",D_LBedIDat2=\"\",D_LBedINum2=\"\"),\"Ok\",IF(AND(D_LBedIYN=\"Yes\",D_LBedIDat2<>\"\",D_LBedINum2<>\"\",D_LBedIDat1<>\"\",D_LBedINum1>=1),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,"Yes/No",null,null,"-",null,null," Did your facility have a decrease in the number of licensed beds during the year?\n If yes, please provide the number of beds decreased.",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,{"$f":"IF(D_LBedDYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null," Date 1\n (MM/DD/YYYY)",null,null,null,null,null,null,null,null,null,null,null,null," Number of Beds 1",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D_LBedDYN=\"No\",D_LBedDDat1=\"\",D_LBedDNum1=\"\"),\"Ok\",IF(AND(D_LBedDYN=\"Yes\",D_LBedDDat1<>\"\",D_LBedDNum1>=1),\"Ok\",\"Error\"))","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null," Date 2\n (MM/DD/YYYY)",null,null,null,null,null,null,null,null,null,null,null,null," Number of Beds 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AM9=\"Ok\",D_LBedDDat2=\"\",D_LBedDNum2=\"\"),\"Ok\",IF(AND(D_LBedDYN=\"Yes\",D_LBedDDat2<>\"\",D_LBedDNum2<>\"\",D_LBedDDat1<>\"\",D_LBedDNum1>=1),\"Ok\",\"Error\"))","v":"Error"}]
["Staffed\nBeds",null,null,null,null," If the full complement of licensed beds is not available for use or does not have \n staff available to provide care, the number of staffed beds will be less than the \n number of licensed beds.\n Number of beds set up and staffed on the last day of the reporting period.",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,{"$f":"IF(D_SBeds>=1,\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(D_SBeds=(D_BTypePri+D_BTypeSPri),\"Ok\",\"Error\")","v":"Ok"}]
["Bed Type",null,null,null,null," On the last day of the reporting period how many Staffed \n beds in your facility were in each of the following types?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Private beds",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D_BTypePri<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Semi-Private beds",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D_BTypeSPri<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"D-Data","index":9,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Licensed Beds",null,null,null,null,null,null,null,null,null,null,"Staffed","Bed type"]
[null,null,null,"","Increase Beds",null,null,null,null,"Decrease Beds",null,null,null,null,"Beds"]
["State\nID","Facility Name","County","Licensed Beds","Yes/No","Date\n1","Number\nof Beds\n1","Date\n2","Number\nof Beds\n2","Yes/No","Date\n1","Number\nof Beds\n1","Date\n2","Number\nof Beds\n2","Staffed\nBeds","Private\nbeds","Semi-\nPrivate\nbeds"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"D_LBedNum","v":0},{"$f":"D_LBedIYN","v":"-"},{"$f":"IF(D_LBedIDat1 = \"\", \"0\", D_LBedIDat1)","v":"0"},{"$f":"D_LBedINum1","v":0},{"$f":"IF(D_LBedIDat2 = \"\", \"0\", D_LBedIDat2)","v":"0"},{"$f":"D_LBedINum2","v":0},{"$f":"D_LBedDYN","v":"-"},{"$f":"IF(D_LBedDDat1 = \"\", \"0\", D_LBedDDat1)","v":"0"},{"$f":"D_LBedDNum1","v":0},{"$f":"IF(D_LBedDDat2 = \"\", \"0\", D_LBedDDat2)","v":"0"},{"$f":"D_LBedDNum2","v":0},{"$f":"D_SBeds","v":0},{"$f":"D_BTypePri","v":0},{"$f":"D_BTypeSPri","v":0}]

{"sheet":"Sch E","index":10,"n_rows":84,"n_cols":44,"rows_kept":84,"cut":false,"hidden":false,"merged":[[32,24,32,26],[32,21,32,23],[35,18,35,20],[34,5,34,11],[34,15,34,17],[33,5,33,11],[32,5,32,11],[35,12,35,14],[32,18,32,20],[32,15,32,17],[34,18,34,20],[32,12,32,14],[33,12,33,14],[67,39,78,39],[35,5,35,11],[36,5,36,11],[33,24,33,26],[34,12,34,14],[33,18,33,20],[33,21,33,23],[34,24,34,26],[34,21,34,23],[34,27,34,29],[33,27,33,29],[34,30,34,32],[36,21,36,23],[36,24,36,26],[36,27,36,29],[36,30,36,32],[36,33,36,35],[35,33,35,35],[34,33,34,35],[36,12,36,14],[33,33,33,35],[35,15,35,17],[35,30,35,32],[35,27,35,29],[28,5,28,11],[29,5,29,11],[30,5,30,11],[31,5,31,11],[30,30,30,32],[31,30,31,32],[27,27,27,29],[27,30,27,32],[30,24,30,26],[30,27,30,29],[31,27,31,29],[29,30,29,32],[29,12,29,14],[30,12,30,14],[31,12,31,14],[29,18,29,20],[30,15,30,17],[28,24,28,26],[27,24,27,26],[29,21,29,23],[29,27,29,29],[31,24,31,26],[30,21,30,23],[31,15,31,17],[36,15,36,17],[28,27,28,29],[28,30,28,32],[28,33,28,35],[28,12,28,14],[28,15,28,17],[28,18,28,20],[28,21,28,23],[33,30,33,32],[36,18,36,20],[35,21,35,23],[35,24,35,26],[33,15,33,17],[29,24,29,26],[29,15,29,17],[31,21,31,23],[30,18,30,20],[31,18,31,20],[32,27,32,29],[32,30,32,32],[29,33,29,35],[32,33,32,35],[30,33,30,35],[31,33,31,35],[26,5,26,11],[25,12,25,14],[25,15,25,17],[25,18,25,20],[26,18,26,20],[26,15,26,17],[26,12,26,14],[27,33,27,35],[27,12,27,14],[27,15,27,17],[27,18,27,20],[27,21,27,23],[25,33,25,35],[26,21,26,23],[26,33,26,35],[26,30,26,32],[26,27,26,29],[27,5,27,11],[26,24,26,26],[24,12,24,17],[24,18,24,23],[24,24,24,29],[24,30,24,35],[25,21,25,23],[25,24,25,26],[25,27,25,29],[25,30,25,32],[13,5,13,30],[14,5,14,30],[15,5,15,30],[2,0,2,35],[1,0,1,3],[18,5,18,30],[17,5,17,30],[21,31,21,35],[19,5,19,15],[19,16,19,30],[20,16,20,30],[20,5,20,15],[20,31,20,35],[1,33,1,35],[1,15,1,32],[51,6,51,11],[51,12,51,15],[48,22,48,25],[49,6,49,11],[49,12,49,15],[49,16,49,21],[49,22,49,25],[50,12,50,15],[48,6,48,11],[48,12,48,15],[47,6,47,11],[47,12,47,15],[45,6,45,11],[9,31,9,35],[10,31,10,35],[48,26,48,31],[50,16,50,21],[48,16,48,21],[50,6,50,11],[47,26,47,31],[16,5,16,35],[17,31,17,35],[18,31,18,35],[14,31,14,35],[15,31,15,35],[50,22,50,25],[50,26,50,31],[45,12,45,15],[46,6,46,11],[46,12,46,15],[42,32,42,35],[44,26,44,31],[44,32,44,35],[44,22,44,25],[51,32,51,35],[48,32,48,35],[49,26,49,31],[49,32,49,35],[50,32,50,35],[47,32,47,35],[45,16,45,21],[45,22,45,25],[45,26,45,31],[45,32,45,35],[46,26,46,31],[46,32,46,35],[46,16,46,21],[46,22,46,25],[47,16,47,21],[47,22,47,25],[51,16,51,21],[51,22,51,25],[51,26,51,31],[43,22,43,25],[43,32,43,35],[42,22,42,25],[42,26,42,31],[44,12,44,15],[44,16,44,21],[43,6,43,11],[42,12,42,15],[42,16,42,21],[42,6,42,11],[43,12,43,15],[43,16,43,21],[44,6,44,11],[40,32,40,35],[41,6,41,11],[41,22,41,25],[41,26,41,31],[40,26,40,31],[41,32,41,35],[41,12,41,15],[41,16,41,21],[39,0,73,5],[39,6,39,35],[40,6,40,11],[40,12,40,15],[40,16,40,21],[40,22,40,25],[53,6,53,11],[53,12,53,15],[53,16,53,21],[53,22,53,25],[52,26,52,31],[52,32,52,35],[53,26,53,31],[53,32,53,35],[52,6,52,11],[52,12,52,15],[52,16,52,21],[52,22,52,25],[54,26,54,31],[54,32,54,35],[55,16,55,21],[55,22,55,25],[54,16,54,21],[54,22,54,25],[55,26,55,31],[55,32,55,35],[57,6,57,11],[57,12,57,15],[57,16,57,21],[57,22,57,25],[56,26,56,31],[56,32,56,35],[57,26,57,31],[57,32,57,35],[54,6,54,11],[54,12,54,15],[55,6,55,11],[55,12,55,15],[56,6,56,11],[56,12,56,15],[56,16,56,21],[56,22,56,25],[59,26,59,31],[59,32,59,35],[58,6,58,11],[58,12,58,15],[59,6,59,11],[59,12,59,15],[59,16,59,21],[59,22,59,25],[58,16,58,21],[58,22,58,25],[58,32,58,35],[58,26,58,31],[60,26,60,31],[60,32,60,35],[61,26,61,31],[61,32,61,35],[63,26,63,31],[63,32,63,35],[62,26,62,31],[62,32,62,35],[63,6,63,11],[63,12,63,15],[63,16,63,21],[63,22,63,25],[62,16,62,21],[62,22,62,25],[60,6,60,11],[60,12,60,15],[60,16,60,21],[60,22,60,25],[61,6,61,11],[61,12,61,15],[61,16,61,21],[61,22,61,25],[62,6,62,11],[62,12,62,15],[64,6,64,11],[64,12,64,15],[64,16,64,21],[64,22,64,25],[66,26,66,31],[66,32,66,35],[65,6,65,11],[65,12,65,15],[65,16,65,21],[65,22,65,25],[64,26,64,31],[64,32,64,35],[65,26,65,31],[65,32,65,35],[67,26,67,31],[67,32,67,35],[66,6,66,11],[66,12,66,15],[67,6,67,11],[67,12,67,15],[67,16,67,21],[67,22,67,25],[66,16,66,21],[66,22,66,25],[70,16,70,21],[70,22,70,25],[68,6,68,11],[68,12,68,15],[68,16,68,21],[68,22,68,25],[70,26,70,31],[70,32,70,35],[69,6,69,11],[69,12,69,15],[69,16,69,21],[69,22,69,25],[68,26,68,31],[68,32,68,35],[69,26,69,31],[69,32,69,35],[70,6,70,11],[70,12,70,15],[73,6,73,31],[73,32,73,35],[72,6,72,11],[72,12,72,15],[72,16,72,21],[72,22,72,25],[71,26,71,31],[71,32,71,35],[72,26,72,31],[71,6,71,11],[71,12,71,15],[71,16,71,21],[71,22,71,25],[75,12,75,15],[76,16,76,21],[0,37,0,39],[79,0,79,31],[79,32,79,35],[75,32,75,35],[76,6,76,11],[76,26,76,31],[75,6,75,11],[75,16,75,21],[77,22,77,25],[77,26,77,31],[37,24,37,29],[75,26,75,31],[76,32,76,35],[5,5,5,30],[1,37,2,37],[16,38,18,38],[8,39,14,39],[6,31,6,35],[76,22,76,25],[75,22,75,25],[76,12,76,15],[72,32,72,35],[81,0,81,35],[82,0,82,35],[83,0,83,35],[80,0,80,35],[77,32,77,35],[78,6,78,31],[78,32,78,35],[12,31,12,35],[11,31,11,35],[38,0,38,35],[74,0,74,35],[37,30,37,35],[24,5,25,11],[24,0,37,4],[37,5,37,11],[37,12,37,17],[37,18,37,23],[23,0,23,35],[19,31,19,35],[21,5,21,30],[75,0,78,5],[77,6,77,11],[77,12,77,15],[77,16,77,21],[0,0,0,35],[3,0,7,4],[7,5,7,30],[7,31,7,35],[16,0,22,4],[22,5,22,30],[22,31,22,35],[13,31,13,35],[5,31,5,35],[4,5,4,30],[8,31,8,35],[3,5,3,30],[6,5,6,30],[3,31,3,35],[4,31,4,35],[1,4,1,8],[1,9,1,14],[8,0,8,4],[8,5,8,30],[9,0,15,4],[9,5,9,30],[10,5,10,30],[11,5,11,30],[12,5,12,30]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020},null,null,null,"Data\nprovided"]
["Schedule E - Utilization"]
["Admissions\nand\nDischarges",null,null,null,null," Admissions: all residents admitted to the facility during the reporting period",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,1,{"$f":"IF(E_ADAdmin<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," Discharges including Deaths: all residents discharged from the facility during the\n reporting period, including those who died during their stay",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,{"$f":"IF(E_ADDisDea<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," Deaths",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,{"$f":"IF(E_ADDeath<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," Number of Discharge Days: the total number of days that each discharged resident\n stayed in the facility.\n Include days only for those residents who were discharged or died during the\n reporting  period.  This figure would include days for those residents who were\n admitted prior to or during the reporting period and were discharged during the\n reporting period  (e.g., admitted 01/11 and discharged in the same year, on 6/30 = \n 171 days, the number of days that resident had been at the facility at the time of\n discharge; another resident admitted one year earlier on 1/11 and discharged on\n 6/30 the next year would be counted as 536 days).  Do not include the day of\n discharge in the calculation unless the resident was discharged the same day as\n admitted.  To make the calculations of the number of days a resident has stayed,\n you may wish to use the website, http://www.timeanddate.com/date/timeduration.html ",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,{"$f":"IF(E_ADDisDay<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," (System Calculation)                                                              Average Length of Stay",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,{"$f":"IF(ISERROR(E_ADDisDay/E_ADDisDea=0),\"\",(E_ADDisDay/E_ADDisDea))","v":""}]
["Transfers",null,null,null,null," How many residents have you transferred to a hospital (excluding deaths) during the\n reporting period?\n A resident, transferred to a hospital, is one expected to return to the assisted-care\n living facility, and a bed in the facility is held for the resident.",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,{"$f":"IF(E_TrTran<>\"\",\"Ok\",\"Error\")","v":"Error"},null,"Discharges\nincluding\ndeaths (line 5)\nminus\nDeaths (line 6)\nis equal\nto\nDischarges\nexcluding\ndeaths (line 16)"]
["Discharges\n(excluding\ndeaths)",null,null,null,null," To Hospital (or transferred and did not return)",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,{"$f":"IF(E_DisHos<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," To Home (private residence)",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,{"$f":"IF(E_DisHom<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," To Residential Home for Aged",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,{"$f":"IF(E_DisRes<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," To Nursing Home",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,{"$f":"IF(E_DisNH<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," To Other Assisted-Care Living Facility",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,{"$f":"IF(E_DisACLF<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," To All other",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,{"$f":"IF(E_DisOth<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," (System Calculation)                                                                                       Total",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,{"$f":"SUM(AF10:AJ15)","v":0},null,null,null,null,null,null,null,{"$f":"IF((E_ADDisDea-E_ADDeath)=E_DisTot,\"Ok\",\"Error\")","v":"Ok"}]
["Payer type",null,null,null,null," How many resident days of care did you provide in the following categories?\n A resident day is a period of service between the census-taking hours on two successive \n calendar  days.  Count only the days of care provided during the reporting period.  Report\n resident days according to the appropriate payment sources.  For example, if a resident\n is admitted with a payment source of self pay and after 60 days is covered by long term care\n insurance, allocate 60 days to self pay and the remaining days to long term care insurance.",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,"Additional\ndata\nprovided"]
[null,null,null,null,null," Self-Pay",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,{"$f":"IF(E_PTSelf<>\"\",\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(ISERROR(E_PTTot/(AO23*AP23)=0),\" \",(E_PTTot/(AO23*AP23)))","v":" "}]
[null,null,null,null,null," Long-Term Care Insurance",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,{"$f":"IF(E_PTLTCI<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null," Other 1, Specify",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,{"$f":"IF(E_PTOth1<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AR20=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,{"$f":"IF(E_PTOth1Spe<>\"\",1,0)","v":0},{"$f":"IF(E_PTOth1>=1,1,0)","v":0},{"$f":"SUM(AO20:AP20)","v":0},{"$f":"OR(AQ20=0,AQ20=2)","v":true}]
[null,null,null,null,null," Other 2, Specify",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,{"$f":"IF(E_PTOth2<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AR21=TRUE,\"Ok\",\"Error\")","v":"Ok"},null,{"$f":"IF(Q21<>\"\",1,0)","v":0},{"$f":"IF(E_PTOth2>=1,1,0)","v":0},{"$f":"SUM(AO21:AP21)","v":0},{"$f":"OR(AQ21=0,AQ21=2)","v":true}]
[null,null,null,null,null," (System Calculation)                                                      Total Resident Days of Care",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,{"$f":"SUM(AF18:AJ21)","v":0}]
[null,null,null,null,null," (System Calculation)                                                                         Occupancy Rate",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,{"$f":"IF(ISERROR(E_PTTot/(AO23*AP23)=0),\" \",(E_PTTot/(AO23*AP23)))","v":" "},null,null,null,null,null,null,null,null,{"$f":"A_DaysReported","v":""},{"$f":"D_LBedNum","v":0}]
["Do not enter zero.  Blank fields will represent zero residents."]
["Number of\nResidents\nserved\nduring this\nreporting\nperiod\n by Age,\nGender and\nRace",null,null,null,null,null,null,null,null,null,null,null,"White",null,null,null,null,null,"Black",null,null,null,null,null,"Other",null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Male",null,null,"Female",null,null,"Male",null,null,"Female",null,null,"Male",null,null,"Female",null,null,"Male",null,null,"Female"]
[null,null,null,null,null," Under 60 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_U60WM+E_U60BM+E_U60OM)","v":0},null,null,{"$f":"(E_U60WF+E_U60BF+E_U60OF)","v":0}]
[null,null,null,null,null," 60 to 64 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_60WM+E_60BM+E_60OM)","v":0},null,null,{"$f":"(E_60WF+E_60BF+E_60OF)","v":0}]
[null,null,null,null,null," 65 to 69 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_65WM+E_65BM+E_65OM)","v":0},null,null,{"$f":"(E_65WF+E_65BF+E_65OF)","v":0}]
[null,null,null,null,null," 70 to 74 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_70WM+E_70BM+E_70OM)","v":0},null,null,{"$f":"(E_70WF+E_70BF+E_70OF)","v":0}]
[null,null,null,null,null," 75 to 79 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_75WM+E_75BM+E_75OM)","v":0},null,null,{"$f":"(E_75WF+E_75BF+E_75OF)","v":0}]
[null,null,null,null,null," 80 to 84 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_80WM+E_80BM+E_80OM)","v":0},null,null,{"$f":"(E_80WF+E_80BF+E_80OF)","v":0}]
[null,null,null,null,null," 85 to 89 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_85WM+E_85BM+E_85OM)","v":0},null,null,{"$f":"(E_85WF+E_85BF+E_85OF)","v":0}]
[null,null,null,null,null," 90 to 94 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_90WM+E_90BM+E_90OM)","v":0},null,null,{"$f":"(E_90WF+E_90BF+E_90OF)","v":0}]
[null,null,null,null,null," 95 to 99 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_95WM+E_95BM+E_95OM)","v":0},null,null,{"$f":"(E_95WF+E_95BF+E_95OF)","v":0}]
[null,null,null,null,null," Over 99 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E_O99WM+E_O99BM+E_O99OM)","v":0},null,null,{"$f":"(E_O99WF+E_O99BF+E_O99OF)","v":0}]
[null,null,null,null,null," (System Calculation)\n          Total Residents\n                  by Gender",null,null,null,null,null,null,{"$f":"SUM(M27:O36)","v":0},null,null,{"$f":"SUM(P27:R36)","v":0},null,null,{"$f":"SUM(S27:U36)","v":0},null,null,{"$f":"SUM(V27:X36)","v":0},null,null,{"$f":"SUM(Y27:AA36)","v":0},null,null,{"$f":"SUM(AB27:AD36)","v":0},null,null,{"$f":"SUM(AE27:AG36)","v":0},null,null,{"$f":"SUM(AH27:AJ36)","v":0}]
[null,null,null,null,null," (System Calculation)\n          Total Residents\n                     by Race",null,null,null,null,null,null,{"$f":"(E_TotWM+E_TotWF)","v":0},null,null,null,null,null,{"$f":"(E_TotBM+E_TotBF)","v":0},null,null,null,null,null,{"$f":"(E_TotOM+E_TotOF)","v":0},null,null,null,null,null,{"$f":"(E_TotTM+E_TotFT)","v":0}]
["Do not enter zero.  Blank fields will represent zero residents."]
["Resident Origin\n\nTennessee\nCounties",null,null,null,null,null," Please enter the number of residents from each county who received services during the reporting\n period."]
[null,null,null,null,null,null,"County",null,null,null,null,null,"Number of\nResidents",null,null,null,"County",null,null,null,null,null,"Number of\nResidents",null,null,null,"County",null,null,null,null,null,"Number of\nResidents"]
[null,null,null,null,null,null," 01 Anderson",null,null,null,null,null,null,null,null,null," 33 Hamilton",null,null,null,null,null,null,null,null,null," 65 Morgan"]
[null,null,null,null,null,null," 02 Bedford",null,null,null,null,null,null,null,null,null," 34 Hancock",null,null,null,null,null,null,null,null,null," 66 Obion"]
[null,null,null,null,null,null," 03 Benton",null,null,null,null,null,null,null,null,null," 35 Hardeman",null,null,null,null,null,null,null,null,null," 67 Overton"]
[null,null,null,null,null,null," 04 Bledsoe",null,null,null,null,null,null,null,null,null," 36 Hardin",null,null,null,null,null,null,null,null,null," 68 Perry"]
[null,null,null,null,null,null," 05 Blount",null,null,null,null,null,null,null,null,null," 37 Hawkins",null,null,null,null,null,null,null,null,null," 69 Pickett"]
[null,null,null,null,null,null," 06 Bradley",null,null,null,null,null,null,null,null,null," 38 Haywood",null,null,null,null,null,null,null,null,null," 70 Polk"]
[null,null,null,null,null,null," 07 Campbell",null,null,null,null,null,null,null,null,null," 39 Henderson",null,null,null,null,null,null,null,null,null," 71 Putnam"]
[null,null,null,null,null,null," 08 Cannon",null,null,null,null,null,null,null,null,null," 40 Henry",null,null,null,null,null,null,null,null,null," 72 Rhea"]
[null,null,null,null,null,null," 09 Carroll",null,null,null,null,null,null,null,null,null," 41 Hickman",null,null,null,null,null,null,null,null,null," 73 Roane"]
[null,null,null,null,null,null," 10 Carter",null,null,null,null,null,null,null,null,null," 42 Houston",null,null,null,null,null,null,null,null,null," 74 Robertson"]
[null,null,null,null,null,null," 11 Cheatham",null,null,null,null,null,null,null,null,null," 43 Humphreys",null,null,null,null,null,null,null,null,null," 75 Rutherford"]
[null,null,null,null,null,null," 12 Chester",null,null,null,null,null,null,null,null,null," 44 Jackson",null,null,null,null,null,null,null,null,null," 76 Scott"]
[null,null,null,null,null,null," 13 Claiborne",null,null,null,null,null,null,null,null,null," 45 Jefferson",null,null,null,null,null,null,null,null,null," 77 Sequatchie"]
[null,null,null,null,null,null," 14 Clay",null,null,null,null,null,null,null,null,null," 46 Johnson",null,null,null,null,null,null,null,null,null," 78 Sevier"]
[null,null,null,null,null,null," 15 Cocke",null,null,null,null,null,null,null,null,null," 47 Knox",null,null,null,null,null,null,null,null,null," 79 Shelby"]
[null,null,null,null,null,null," 16 Coffee",null,null,null,null,null,null,null,null,null," 48 Lake",null,null,null,null,null,null,null,null,null," 80 Smith"]
[null,null,null,null,null,null," 17 Crockett",null,null,null,null,null,null,null,null,null," 49 Lauderdale",null,null,null,null,null,null,null,null,null," 81 Stewart"]
[null,null,null,null,null,null," 18 Cumberland",null,null,null,null,null,null,null,null,null," 50 Lawrence",null,null,null,null,null,null,null,null,null," 82 Sullivan"]
[null,null,null,null,null,null," 19 Davidson",null,null,null,null,null,null,null,null,null," 51 Lewis",null,null,null,null,null,null,null,null,null," 83 Sumner"]
[null,null,null,null,null,null," 20 Decatur",null,null,null,null,null,null,null,null,null," 52 Lincoln",null,null,null,null,null,null,null,null,null," 84 Tipton"]
[null,null,null,null,null,null," 21 DeKalb",null,null,null,null,null,null,null,null,null," 53 Loudon",null,null,null,null,null,null,null,null,null," 85 Trousdale"]
[null,null,null,null,null,null," 22 Dickson",null,null,null,null,null,null,null,null,null," 54 McMinn",null,null,null,null,null,null,null,null,null," 86 Unicoi"]
[null,null,null,null,null,null," 23 Dyer",null,null,null,null,null,null,null,null,null," 55 McNairy",null,null,null,null,null,null,null,null,null," 87 Union"]
[null,null,null,null,null,null," 24 Fayette",null,null,null,null,null,null,null,null,null," 56 Macon",null,null,null,null,null,null,null,null,null," 88 Van Buren"]
[null,null,null,null,null,null," 25 Fentress",null,null,null,null,null,null,null,null,null," 57 Madison",null,null,null,null,null,null,null,null,null," 89 Warren"]
[null,null,null,null,null,null," 26 Franklin",null,null,null,null,null,null,null,null,null," 58 Marion",null,null,null,null,null,null,null,null,null," 90 Washington"]
[null,null,null,null,null,null," 27 Gibson",null,null,null,null,null,null,null,null,null," 59 Marshall",null,null,null,null,null,null,null,null,null," 91 Wayne",null,null,null,null,null,null,null,null,null,null,null,null,"Number\nof\nResidents\nserved\nby Age,\nGender &\nRace\nequal to\nTotal TN\nand other\nStates/\nCountries"]
[null,null,null,null,null,null," 28 Giles",null,null,null,null,null,null,null,null,null," 60 Maury",null,null,null,null,null,null,null,null,null," 92 Weakley"]
[null,null,null,null,null,null," 29 Grainger",null,null,null,null,null,null,null,null,null," 61 Meigs",null,null,null,null,null,null,null,null,null," 93 White"]
[null,null,null,null,null,null," 30 Greene",null,null,null,null,null,null,null,null,null," 62 Monroe",null,null,null,null,null,null,null,null,null," 94 Williamson"]
[null,null,null,null,null,null," 31 Grundy",null,null,null,null,null,null,null,null,null," 63 Montgomery",null,null,null,null,null,null,null,null,null," 95 Wilson"]
[null,null,null,null,null,null," 32 Hamblen",null,null,null,null,null,null,null,null,null," 64 Moore",null,null,null,null,null,null,null,null,null," 96 Unknown"]
[null,null,null,null,null,null,"(System Calculation)                                                   Total Tennessee Residents: ",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,{"$f":"(((SUM(E_TN01:E_TN32))+(SUM(E_TN33:E_TN64))+(SUM(E_TN65:E_TN96))))","v":0}]
["Do not enter zero.  Blank fields will represent zero residents."]
["Resident Origin\n\nOut of State",null,null,null,null,null," 01 Alabama",null,null,null,null,null,null,null,null,null," 18 Kentucky",null,null,null,null,null,null,null,null,null," 34 North Carolina"]
[null,null,null,null,null,null," 04 Arkansas",null,null,null,null,null,null,null,null,null," 25 Mississippi",null,null,null,null,null,null,null,null,null," 47 Virginia"]
[null,null,null,null,null,null," 11 Georgia",null,null,null,null,null,null,null,null,null," 26 Missouri",null,null,null,null,null,null,null,null,null," 55 Other States/\n      Countries"]
[null,null,null,null,null,null,"(System Calculation)                 Total Residents from Other States and Countries: ",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,{"$f":"((SUM(M76:P78))+(SUM(W76:Z78))+(SUM(AG76:AJ78)))","v":0}]
[" (System Calculation)       Total Tennessee and Other States/Countries Residents: ",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,{"$f":"(E_TNTot+E_STot)","v":0},null,null,null,null,null,null,{"$f":"IF(E_TotT=E_TNSTot,\"Ok\",\"Error\")","v":"Ok"}]
[" * Total Tennessee and Other States/Countries Residents should match Total number of Residents Served \n   by Age, Gender, and Race section (Schedule E)"]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"E-Data","index":11,"n_rows":4,"n_cols":224,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Admissions and Discharges",null,null,null,null,"Transfers","Discharges (excluding deaths)",null,null,null,null,null,null,"Payer type resident days",null,null,null,null,null,null,null,"Residents served",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Origin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Under 60 Years",null,null,null,null,null,null,null,"60 to 64 Years",null,null,null,null,null,null,null,"65 to 69 Years",null,null,null,null,null,null,null,"70 to74 Years",null,null,null,null,null,null,null,"75 to 79 Years",null,null,null,null,null,null,null,"80 to 84 Years",null,null,null,null,null,null,null,"85 to 89 Years",null,null,null,null,null,null,null,"90 to 94 Years",null,null,null,null,null,null,null,"95 to 99 Years",null,null,null,null,null,null,null,"Over 99 Years",null,null,null,null,null,null,null,"Total Residents by Gender",null,null,null,null,null,null,null,"Total Residents by Race",null,null,null,"Tennessee Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tennessee Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tennessee Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tennessee Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tennessee Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tennessee Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN","Non-TN/Out of State",null,null,null,null,null,null,null,null,null,"Total   "]
["State\nID","Facility Name","County","Admissions\n all\nresidents","Discharges\nincluding\ndeaths","Deaths","Number\nof \nDischarge\nDays","Average\nLength\nof\nStay","Residents\nTransferred\nto a\nhospital","Hospital","Home\n(private\nresidence)","Residential\nHome for\nAged","Nursing\nHome","Other\nACLF","All\nOther\nDischarges","Total\n","Self-Pay","Long-\nTerm\nCare\nIns","Other 1\nSpecify","Other 1","Other 2\nSpecify","Other 2","Total","Occup-\nancy \nRates","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","White\nMale","White\nFemale","Black\nMale","Black\nFemale","Other\nMale","Other\nFemale","Total\nMale","Total\nFemale","Total\nWhite\nMale &\nFemale","Total\nBlack\nMale &\nFemale","Total\nOther\nMale &\nFemale","Total\nMale &\nFemale\nby Race","Anderson","Bedford","Benton","Bledsoe","Blount","Bradley","Campbell","Cannon","Carroll","Carter","Cheatham","Chester","Claiborne","Clay","Cocke","Coffee","Crockett","Cumberland","Davidson","Decatur","DeKalb","Dickson","Dyer","Fayette","Fentress","Franklin","Gibson","Giles","Grainger","Greene","Grundy","Hamblen","Hamilton","Hancock","Hardeman","Hardin","Hawkins","Haywood","Henderson","Henry","Hickman","Houston","Humphreys","Jackson","Jefferson","Johnson","Knox","Lake","Lauderdale","Lawrence","Lewis","Lincoln","Loudon","McMinn","McNairy","Macon","Madison","Marion","Marshall","Maury","Meigs","Monroe","Montgomery","Moore","Morgan","Obion","Overton","Perry","Pickett","Polk","Putnam","Rhea","Roane","Robertson","Rutherford","Scott","Sequatchie","Sevier","Shelby","Smith","Stewart","Sullivan","Sumner","Tipton","Trousdale","Unicoi","Union","VanBuren","Warren","Washington","Wayne","Weakley","White","Williamson","Wilson","Unknown\nCounty","Total\nTN\npatients","Alabama","Arkansas","Georgia","Kentucky","Mississippi","Missouri","North\nCarolina","Virginia","Other\nStates","Total\nNon-TN\npatients","Total TN\nand Non-TN\npatients"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"IF(E_ADAdmin>=1,E_ADAdmin,\"\")","v":""},{"$f":"IF(E_ADDisDea>=1,E_ADDisDea,\"\")","v":""},{"$f":"IF(E_ADDeath>=1,E_ADDeath,\"\")","v":""},{"$f":"IF(E_ADDisDay>=1,E_ADDisDay,\"\")","v":""},{"$f":"IF(E_ADALS>=1,E_ADALS,\"\")","v":""},{"$f":"IF(E_TrTran>=1,E_TrTran,\"\")","v":""},{"$f":"IF(E_DisHos>=1,E_DisHos,\"\")","v":""},{"$f":"IF(E_DisHom>=1,E_DisHom,\"\")","v":""},{"$f":"IF(E_DisRes>=1,E_DisRes,\"\")","v":""},{"$f":"IF(E_DisNH>=1,E_DisNH,\"\")","v":""},{"$f":"IF(E_DisACLF>=1,E_DisACLF,\"\")","v":""},{"$f":"IF(E_DisOth>=1,E_DisOth,\"\")","v":""},{"$f":"IF(E_DisTot>=1,E_DisTot,\"\")","v":""},{"$f":"IF(E_PTSelf>=1,E_PTSelf,\"\")","v":""},{"$f":"IF(E_PTLTCI>=1,E_PTLTCI,\"\")","v":""},{"$f":"E_PTOth1Spe","v":0},{"$f":"IF(E_PTOth1>=1,E_PTOth1,\"\")","v":""},{"$f":"E_PTOth2Spe","v":0},{"$f":"IF(E_PTOth2>=1,E_PTOth2,\"\")","v":""},{"$f":"IF(E_PTTot>=1,E_PTTot,\"\")","v":""},{"$f":"E_PTORate","v":" "},{"$f":"IF(E_U60WM>=1,E_U60WM,\"\")","v":""},{"$f":"IF(E_U60WF>=1,E_U60WF,\"\")","v":""},{"$f":"IF(E_U60BM>=1,E_U60BM,\"\")","v":""},{"$f":"IF(E_U60BF>=1,E_U60BF,\"\")","v":""},{"$f":"IF(E_U60OM>=1,E_U60OM,\"\")","v":""},{"$f":"IF(E_U60OF>=1,E_U60OF,\"\")","v":""},{"$f":"IF(E_U60TM>=1,E_U60TM,\"\")","v":""},{"$f":"IF(E_U60TF>=1,E_U60TF,\"\")","v":""},{"$f":"IF(E_60WM>=1,E_60WM,\"\")","v":""},{"$f":"IF(E_60WF>=1,E_60WF,\"\")","v":""},{"$f":"IF(E_60BM>=1,E_60BM,\"\")","v":""},{"$f":"IF(E_60BF>=1,E_60BF,\"\")","v":""},{"$f":"IF(E_60OM>=1,E_60OM,\"\")","v":""},{"$f":"IF(E_60OF>=1,E_60OF,\"\")","v":""},{"$f":"IF(E_60TM>=1,E_60TM,\"\")","v":""},{"$f":"IF(E_60TF>=1,E_60TF,\"\")","v":""},{"$f":"IF(E_65WM>=1,E_65WM,\"\")","v":""},{"$f":"IF(E_65WF>=1,E_65WF,\"\")","v":""},{"$f":"IF(E_65BM>=1,E_65BM,\"\")","v":""},{"$f":"IF(E_65BF>=1,E_65BF,\"\")","v":""},{"$f":"IF(E_65OM>=1,E_65OM,\"\")","v":""},{"$f":"IF(E_65OF>=1,E_65OF,\"\")","v":""},{"$f":"IF(E_65TM>=1,E_65TM,\"\")","v":""},{"$f":"IF(E_65TF>=1,E_65TF,\"\")","v":""},{"$f":"IF(E_70WM>=1,E_70WM,\"\")","v":""},{"$f":"IF(E_70WF>=1,E_70WF,\"\")","v":""},{"$f":"IF(E_70BM>=1,E_70BM,\"\")","v":""},{"$f":"IF(E_70BF>=1,E_70BF,\"\")","v":""},{"$f":"IF(E_70OM>=1,E_70OM,\"\")","v":""},{"$f":"IF(E_70OF>=1,E_70OF,\"\")","v":""},{"$f":"IF(E_70TM>=1,E_70TM,\"\")","v":""},{"$f":"IF(E_70TF>=1,E_70TF,\"\")","v":""},{"$f":"IF(E_75WM>=1,E_75WM,\"\")","v":""},{"$f":"IF(E_75WF>=1,E_75WF,\"\")","v":""},{"$f":"IF(E_75BM>=1,E_75BM,\"\")","v":""},{"$f":"IF(E_75BF>=1,E_75BF,\"\")","v":""},{"$f":"IF(E_75OM>=1,E_75OM,\"\")","v":""},{"$f":"IF(E_75OF>=1,E_75OF,\"\")","v":""},{"$f":"IF(E_75TM>=1,E_75TM,\"\")","v":""},{"$f":"IF(E_75TF>=1,E_75TF,\"\")","v":""},{"$f":"IF(E_80WM>=1,E_80WM,\"\")","v":""},{"$f":"IF(E_80WF>=1,E_80WF,\"\")","v":""},{"$f":"IF(E_80BM>=1,E_80BM,\"\")","v":""},{"$f":"IF(E_80BF>=1,E_80BF,\"\")","v":""},{"$f":"IF(E_80OM>=1,E_80OM,\"\")","v":""},{"$f":"IF(E_80OF>=1,E_80OF,\"\")","v":""},{"$f":"IF(E_80TM>=1,E_80TM,\"\")","v":""},{"$f":"IF(E_80TF>=1,E_80TF,\"\")","v":""},{"$f":"IF(E_85WM>=1,E_85WM,\"\")","v":""},{"$f":"IF(E_85WF>=1,E_85WF,\"\")","v":""},{"$f":"IF(E_85BM>=1,E_85BM,\"\")","v":""},{"$f":"IF(E_85BF>=1,E_85BF,\"\")","v":""},{"$f":"IF(E_85OM>=1,E_85OM,\"\")","v":""},{"$f":"IF(E_85OF>=1,E_85OF,\"\")","v":""},{"$f":"IF(E_85TM>=1,E_85TM,\"\")","v":""},{"$f":"IF(E_85TF>=1,E_85TF,\"\")","v":""},{"$f":"IF(E_90WM>=1,E_90WM,\"\")","v":""},{"$f":"IF(E_90WF>=1,E_90WF,\"\")","v":""},{"$f":"IF(E_90BM>=1,E_90BM,\"\")","v":""},{"$f":"IF(E_90BF>=1, E_90BF,\"\")","v":""},{"$f":"IF(E_90OM>=1,E_90OM,\"\")","v":""},{"$f":"IF(E_90OF>=1,E_90OF,\"\")","v":""},{"$f":"IF(E_90TM>=1,E_90TM,\"\")","v":""},{"$f":"IF(E_90TF>=1,E_90TF,\"\")","v":""},{"$f":"IF(E_95WM>=1,E_95WM,\"\")","v":""},{"$f":"IF(E_95WF>=1,E_95WF,\"\")","v":""},{"$f":"IF(E_95BM>=1,E_95BM,\"\")","v":""},{"$f":"IF(E_95BF>=1,E_95BF,\"\")","v":""},{"$f":"IF(E_95OM>=1,E_95OM,\"\")","v":""},{"$f":"IF(E_95OF>=1,E_95OF,\"\")","v":""},{"$f":"IF(E_95TM>=1,E_95TM,\"\")","v":""},{"$f":"IF(E_95TF>=1,E_95TF,\"\")","v":""},{"$f":"IF(E_O99WM>=1,E_O99WM,\"\")","v":""},{"$f":"IF(E_O99WF>=1,E_O99WF,\"\")","v":""},{"$f":"IF(E_O99BM>=1,E_O99BM,\"\")","v":""},{"$f":"IF(E_O99BF>=1,E_O99BF,\"\")","v":""},{"$f":"IF(E_O99OM>=1,E_O99OM,\"\")","v":""},{"$f":"IF(E_O99OF>=1,E_O99OF,\"\")","v":""},{"$f":"IF(E_O99TM>=1,E_O99TM,\"\")","v":""},{"$f":"IF(E_O99TF>=1,E_O99TF,\"\")","v":""},{"$f":"IF(E_TotWM>=1,E_TotWM,\"\")","v":""},{"$f":"IF(E_TotWF>=1,E_TotWF,\"\")","v":""},{"$f":"IF(E_TotBM>=1,E_TotBM,\"\")","v":""},{"$f":"IF(E_TotBF>=1,E_TotBF,\"\")","v":""},{"$f":"IF(E_TotOM>=1,E_TotOM,\"\")","v":""},{"$f":"IF(E_TotOF>=1,E_TotOF,\"\")","v":""},{"$f":"IF(E_TotTM>=1,E_TotTM,\"\")","v":""},{"$f":"IF(E_TotFT>=1,E_TotFT,\"\")","v":""},{"$f":"IF(E_TotW>=1,E_TotW,\"\")","v":""},{"$f":"IF(E_TotB>=1,E_TotB,\"\")","v":""},{"$f":"IF(E_TotO>=1,E_TotO,\"\")","v":""},{"$f":"IF(E_TotT>=1,E_TotT,\"\")","v":""},{"$f":"IF(E_TN01>=1,E_TN01,\"\")","v":""},{"$f":"IF(E_TN02>=1,E_TN02,\"\")","v":""},{"$f":"IF(E_TN03>=1,E_TN03,\"\")","v":""},{"$f":"IF(E_TN04>=1,E_TN04,\"\")","v":""},{"$f":"IF(E_TN05>=1,E_TN05,\"\")","v":""},{"$f":"IF(E_TN06>=1,E_TN06,\"\")","v":""},{"$f":"IF(E_TN07>=1,E_TN07,\"\")","v":""},{"$f":"IF(E_TN08>=1,E_TN08,\"\")","v":""},{"$f":"IF(E_TN09>=1,E_TN09,\"\")","v":""},{"$f":"IF(E_TN10>=1,E_TN10,\"\")","v":""},{"$f":"IF(E_TN11>=1,E_TN11,\"\")","v":""},{"$f":"IF(E_TN12>=1,E_TN12,\"\")","v":""},{"$f":"IF(E_TN13>=1,E_TN13,\"\")","v":""},{"$f":"IF(E_TN14>=1,E_TN14,\"\")","v":""},{"$f":"IF(E_TN15>=1,E_TN15,\"\")","v":""},{"$f":"IF(E_TN16>=1,E_TN16,\"\")","v":""},{"$f":"IF(E_TN17>=1,E_TN17,\"\")","v":""},{"$f":"IF(E_TN18>=1,E_TN18,\"\")","v":""},{"$f":"IF(E_TN19>=1,E_TN19,\"\")","v":""},{"$f":"IF(E_TN20>=1,E_TN20,\"\")","v":""},{"$f":"IF(E_TN21>=1,E_TN21,\"\")","v":""},{"$f":"IF(E_TN22>=1,E_TN22,\"\")","v":""},{"$f":"IF(E_TN23>=1,E_TN23,\"\")","v":""},{"$f":"IF(E_TN24>=1,E_TN24,\"\")","v":""},{"$f":"IF(E_TN25>=1,E_TN25,\"\")","v":""},{"$f":"IF(E_TN26>=1,E_TN26,\"\")","v":""},{"$f":"IF(E_TN27>=1,E_TN27,\"\")","v":""},{"$f":"IF(E_TN28>=1,E_TN28,\"\")","v":""},{"$f":"IF(E_TN29>=1,E_TN29,\"\")","v":""},{"$f":"IF(E_TN30>=1,E_TN30,\"\")","v":""},{"$f":"IF(E_TN31>=1,E_TN31,\"\")","v":""},{"$f":"IF(E_TN32>=1,E_TN32,\"\")","v":""},{"$f":"IF(E_TN33>=1,E_TN33,\"\")","v":""},{"$f":"IF(E_TN34>=1,E_TN34,\"\")","v":""},{"$f":"IF(E_TN35>=1,E_TN35,\"\")","v":""},{"$f":"IF(E_TN36>=1,E_TN36,\"\")","v":""},{"$f":"IF(E_TN37>=1,E_TN37,\"\")","v":""},{"$f":"IF(E_TN38>=1,E_TN38,\"\")","v":""},{"$f":"IF(E_TN39>=1,E_TN39,\"\")","v":""},{"$f":"IF(E_TN40>=1,E_TN40,\"\")","v":""},{"$f":"IF(E_TN41>=1,E_TN41,\"\")","v":""},{"$f":"IF(E_TN42>=1,E_TN42,\"\")","v":""},{"$f":"IF(E_TN43>=1,E_TN43,\"\")","v":""},{"$f":"IF(E_TN44>=1,E_TN44,\"\")","v":""},{"$f":"IF(E_TN45>=1,E_TN45,\"\")","v":""},{"$f":"IF(E_TN46>=1,E_TN46,\"\")","v":""},{"$f":"IF(E_TN47>=1,E_TN47,\"\")","v":""},{"$f":"IF(E_TN48>=1,E_TN48,\"\")","v":""},{"$f":"IF(E_TN49>=1,E_TN49,\"\")","v":""},{"$f":"IF(E_TN50>=1,E_TN50,\"\")","v":""},{"$f":"IF(E_TN51>=1,E_TN51,\"\")","v":""},{"$f":"IF(E_TN52>=1,E_TN52,\"\")","v":""},{"$f":"IF(E_TN53>=1,E_TN53,\"\")","v":""},{"$f":"IF(E_TN54>=1,E_TN54,\"\")","v":""},{"$f":"IF(E_TN55>=1,E_TN55,\"\")","v":""},{"$f":"IF(E_TN56>=1,E_TN56,\"\")","v":""},{"$f":"IF(E_TN57>=1,E_TN57,\"\")","v":""},{"$f":"IF(E_TN58>=1,E_TN58,\"\")","v":""},{"$f":"IF(E_TN59>=1,E_TN59,\"\")","v":""},{"$f":"IF(E_TN60>=1,E_TN60,\"\")","v":""},{"$f":"IF(E_TN61>=1,E_TN61,\"\")","v":""},{"$f":"IF(E_TN62>=1,E_TN62,\"\")","v":""},{"$f":"IF(E_TN63>=1,E_TN63,\"\")","v":""},{"$f":"IF(E_TN64>=1,E_TN64,\"\")","v":""},{"$f":"IF(E_TN65>=1,E_TN65,\"\")","v":""},{"$f":"IF(E_TN66>=1,E_TN66,\"\")","v":""},{"$f":"IF(E_TN67>=1,E_TN67,\"\")","v":""},{"$f":"IF(E_TN68>=1,E_TN68,\"\")","v":""},{"$f":"IF(E_TN69>=1,E_TN69,\"\")","v":""},{"$f":"IF(E_TN70>=1,E_TN70,\"\")","v":""},{"$f":"IF(E_TN71>=1,E_TN71,\"\")","v":""},{"$f":"IF(E_TN72>=1,E_TN72,\"\")","v":""},{"$f":"IF(E_TN73>=1,E_TN73,\"\")","v":""},{"$f":"IF(E_TN74>=1,E_TN74,\"\")","v":""},{"$f":"IF(E_TN75>=1,E_TN75,\"\")","v":""},{"$f":"IF(E_TN76>=1,E_TN76,\"\")","v":""},{"$f":"IF(E_TN77>=1,E_TN77,\"\")","v":""},{"$f":"IF(E_TN78>=1,E_TN78,\"\")","v":""},{"$f":"IF(E_TN79>=1,E_TN79,\"\")","v":""},{"$f":"IF(E_TN80>=1,E_TN80,\"\")","v":""},{"$f":"IF(E_TN81>=1,E_TN81,\"\")","v":""},{"$f":"IF(E_TN82>=1,E_TN82,\"\")","v":""},{"$f":"IF(E_TN83>=1,E_TN83,\"\")","v":""},{"$f":"IF(E_TN84>=1,E_TN84,\"\")","v":""},{"$f":"IF(E_TN85>=1,E_TN85,\"\")","v":""},{"$f":"IF(E_TN86>=1,E_TN86,\"\")","v":""},{"$f":"IF(E_TN87>=1,E_TN87,\"\")","v":""},{"$f":"IF(E_TN88>=1,E_TN88,\"\")","v":""},{"$f":"IF(E_TN89>=1,E_TN89,\"\")","v":""},{"$f":"IF(E_TN90>=1,E_TN90,\"\")","v":""},{"$f":"IF(E_TN91>=1,E_TN91,\"\")","v":""},{"$f":"IF(E_TN92>=1,E_TN92,\"\")","v":""},{"$f":"IF(E_TN93>=1,E_TN93,\"\")","v":""},{"$f":"IF(E_TN94>=1,E_TN94,\"\")","v":""},{"$f":"IF(E_TN95>=1,E_TN95,\"\")","v":""},{"$f":"IF(E_TN96>=1,E_TN96,\"\")","v":""},{"$f":"E_TNTot","v":0},{"$f":"IF(E_S01>=1,E_S01,\"\")","v":""},{"$f":"IF(E_S04>=1,E_S04,\"\")","v":""},{"$f":"IF(E_S11>=1,E_S11,\"\")","v":""},{"$f":"IF(E_S18>=1,E_S18,\"\")","v":""},{"$f":"IF(E_S25>=1,E_S25,\"\")","v":""},{"$f":"IF(E_S26>=1,E_S26,\"\")","v":""},{"$f":"IF(E_S34>=1,E_S34,\"\")","v":""},{"$f":"IF(E_S47>=1,E_S47,\"\")","v":""},{"$f":"IF(E_S55>=1,E_S55,\"\")","v":""},{"$f":"IF(E_STot>=1,E_STot,\"\")","v":""},{"$f":"E_TNSTot","v":0}]

{"sheet":"Sch F","index":12,"n_rows":62,"n_cols":42,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,33,1,35],[1,15,1,32],[29,31,29,35],[42,0,42,35],[52,8,52,11],[52,12,52,17],[52,18,52,23],[52,24,52,29],[52,30,52,35],[31,26,31,30],[29,21,29,25],[30,21,30,25],[36,5,36,15],[29,26,29,30],[30,26,30,30],[30,16,30,20],[31,16,31,20],[32,16,32,20],[35,5,35,15],[30,5,30,15],[31,5,31,15],[32,5,32,15],[29,5,29,15],[28,0,32,4],[34,5,34,15],[38,0,41,4],[43,12,43,17],[43,4,43,7],[61,0,61,35],[43,0,52,3],[60,0,60,35],[53,4,53,6],[53,7,53,9],[57,4,57,11],[56,4,56,11],[55,4,55,11],[49,12,49,17],[59,0,59,35],[43,18,43,23],[44,4,49,7],[47,8,47,11],[44,8,44,11],[45,8,45,11],[46,8,46,11],[48,8,48,11],[49,8,49,11],[43,8,43,11],[50,4,52,7],[53,0,58,3],[58,4,58,11],[22,24,22,27],[24,24,24,27],[28,21,28,25],[28,16,28,20],[57,24,57,29],[51,18,51,23],[51,24,51,29],[56,18,56,23],[24,28,24,31],[23,24,23,27],[28,5,28,15],[32,21,32,25],[32,26,32,30],[32,31,32,35],[31,31,31,35],[29,16,29,20],[28,31,28,35],[33,0,37,4],[33,5,33,15],[48,12,48,17],[46,12,46,17],[47,12,47,17],[28,26,28,30],[49,30,49,35],[48,30,48,35],[50,18,50,23],[50,24,50,29],[50,30,50,35],[49,18,49,23],[49,24,49,29],[48,18,48,23],[48,24,48,29],[40,31,40,35],[38,31,38,35],[39,31,39,35],[37,31,37,35],[38,21,38,26],[39,21,39,26],[40,21,40,26],[41,21,41,26],[43,24,43,29],[41,27,41,30],[18,32,18,35],[19,32,19,35],[20,32,20,35],[21,32,21,35],[19,28,19,31],[20,28,20,31],[21,28,21,31],[18,28,18,31],[20,24,20,27],[21,24,21,27],[17,32,17,35],[16,5,16,19],[16,20,16,23],[16,28,16,31],[16,24,16,27],[21,5,21,11],[20,12,20,19],[21,20,21,23],[7,5,7,19],[7,20,7,23],[15,32,15,35],[14,5,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[15,5,15,19],[7,24,7,27],[7,28,7,31],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,32,8,35],[10,24,10,27],[10,32,10,35],[1,0,1,3],[1,4,1,8],[1,9,1,14],[3,0,3,35],[5,5,6,19],[5,20,5,27],[53,38,54,38],[54,30,54,35],[53,10,53,35],[11,5,11,19],[12,5,12,19],[37,5,37,15],[33,16,33,20],[22,5,22,11],[22,12,22,19],[22,20,22,23],[5,28,5,35],[6,20,6,23],[6,24,6,27],[11,20,11,23],[9,32,9,35],[9,20,9,23],[10,20,10,23],[9,24,9,27],[0,37,0,39],[14,37,19,37],[6,28,6,31],[6,32,6,35],[4,0,4,35],[5,0,24,4],[7,32,7,35],[8,5,8,19],[15,24,15,27],[2,0,2,35],[20,20,20,23],[17,20,17,23],[17,24,17,27],[19,24,19,27],[19,20,19,23],[20,5,20,11],[12,20,12,23],[13,5,13,19],[17,5,17,19],[18,5,18,19],[19,5,19,19],[15,20,15,23],[9,5,9,19],[10,5,10,19],[9,28,9,31],[10,28,10,31],[23,5,23,11],[21,12,21,19],[23,12,23,19],[25,0,25,35],[24,32,24,35],[23,32,23,35],[22,32,22,35],[23,28,23,31],[24,5,24,19],[22,28,22,31],[13,32,13,35],[13,20,13,23],[18,20,18,23],[14,32,14,35],[18,24,18,27],[15,28,15,31],[13,28,13,31],[13,24,13,27],[16,32,16,35],[17,28,17,31],[11,32,11,35],[12,24,12,27],[12,28,12,31],[12,32,12,35],[11,28,11,31],[11,24,11,27],[36,16,36,20],[35,16,35,20],[34,16,34,20],[23,20,23,23],[24,20,24,23],[31,21,31,25],[27,0,27,35],[26,0,26,35],[30,31,30,35],[33,31,33,35],[34,31,34,35],[35,31,35,35],[35,21,35,25],[34,21,34,25],[33,26,37,30],[33,21,33,25],[36,31,36,35],[36,21,36,25],[37,16,37,20],[37,21,37,25],[55,18,55,23],[57,18,57,23],[57,12,57,17],[44,24,44,29],[54,4,54,11],[46,30,46,35],[47,30,47,35],[46,18,46,23],[47,18,47,23],[46,24,46,29],[47,24,47,29],[51,8,51,11],[50,8,50,11],[54,12,54,17],[55,30,55,35],[54,18,54,23],[55,24,55,29],[51,12,51,17],[56,30,56,35],[57,30,57,35],[51,30,51,35],[56,24,56,29],[0,0,0,35],[30,38,34,38],[58,24,58,29],[58,30,58,35],[54,24,54,29],[43,30,43,35],[41,31,41,35],[38,27,38,30],[39,27,39,30],[40,27,40,30],[34,37,37,37],[44,12,44,17],[45,12,45,17],[44,30,44,35],[45,30,45,35],[44,18,44,23],[45,18,45,23],[45,24,45,29],[38,5,41,20],[58,12,58,17],[50,12,50,17],[58,18,58,23],[55,12,55,17],[56,12,56,17]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020}]
["Schedule F - Personnel"]
["Please indicate the number of personnel on the last day of the reporting period. Leave the item blank if the value is\nunknown.\nFull-time employees are those whose regularly scheduled workweek is usually 40 hours or more per week or at least \n80 hours within a two week period.\nFull Time Equivalent (FTE) = number of hours worked by part-time employees per week/40 hours per week, rounded\nto two decimal places.  For example, three Registered Nurses, each working 20 hours a week, the FTE would be \n(3x20)/40=1.5.  For two medical records employees, one working 10 hours per week and the other working 15 hours \nper week, the FTE would be (10+15)/40=.63."]
["Do not enter zero.  Blank fields will represent zero employees."]
["Type of\nEmployee\nby Service",null,null,null,null,"Type of Employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Employees",null,null,null,null,null,null,null,"Employee Pool/\nConsultant/Contract"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full-Time",null,null,null,"Part-Time\nin FTE",null,null,null,"Full-Time",null,null,null,"Part-Time\nin FTE"]
[null,null,null,null,null,"Administrator"]
[null,null,null,null,null,"Assistant Administrators"]
[null,null,null,null,null,"Registered Nurses"]
[null,null,null,null,null,"Licensed Practical Nurses"]
[null,null,null,null,null,"Nurses Aides and Orderlies"]
[null,null,null,null,null,"Dietary Managers"]
[null,null,null,null,null,"Registered Dieticians"]
[null,null,null,null,null,"Dietetic Technicians",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,"Type of\nemployee\nservice\nSpecified\nAdditional\ndata\nprovided"]
[null,null,null,null,null,"Medical Social Workers"]
[null,null,null,null,null,"Social Workers"]
[null,null,null,null,null,"Activity Coordinators"]
[null,null,null,null,null,"Maintenance"]
[null,null,null,null,null,"Housekeeping"]
[null,null,null,null,null,"Other (1), Specify:",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,{"$f":"IF(AND(AO21=0,AP21=0),\"Ok\",IF(AND(AO21=1,AP21>=0.001),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"IF(F_OT1Spec<>\"\",1,0)","v":0},{"$f":"SUM(U21:AJ21)","v":0}]
[null,null,null,null,null,"Other (2), Specify:",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,{"$f":"IF(AND(AO22=0,AP22=0),\"Ok\",IF(AND(AO22=1,AP22>=0.01),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"IF(F_OT2Spec<>\"\",1,0)","v":0},{"$f":"SUM(U22:AJ22)","v":0}]
[null,null,null,null,null,"Other (3), Specify:",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,{"$f":"IF(AND(AO23=0,AP23=0),\"Ok\",IF(AND(AO23=1,AP23>=0.01),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"IF(F_OT3Spec<>\"\",1,0)","v":0},{"$f":"SUM(U23:AJ23)","v":0}]
[null,null,null,null,null,"Other (4), Specify:",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,{"$f":"IF(AND(AO24=0,AP24=0),\"Ok\",IF(AND(AO24=1,AP24>=0.01),\"Ok\",\"Error\"))","v":"Ok"},null,null,{"$f":"IF(F_OT4Spec<>\"\",1,0)","v":0},{"$f":"SUM(U24:AJ24)","v":0}]
[null,null,null,null,null,"(System Calculation)                              Total: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U8:X24)","v":0},null,null,null,{"$f":"SUM(Y8:AB24)","v":0},null,null,null,{"$f":"SUM(AC8:AF24)","v":0},null,null,null,{"$f":"SUM(AG8:AJ24)","v":0}]
["Please indicate below the number of personnel during the reporting period."]
["Do not enter zero.  Blank fields will represent zero employees."]
["Please indicate the number of nursing personnel on duty on the last day of the reporting period (that is, on the premises and routinely serving the residents) for each shift.  Do not include a person who is merely \"on call.\"\nUse the section for the three-shift pattern or for the two-shift pattern depending on your facility, or both if your facility uses a mix of 8 and 12 hours shifts."]
["Nursing\nThree Shifts\nper Day\nPatterns",null,null,null,null,"Three Shifts",null,null,null,null,null,null,null,null,null,null,"Shift # 1\n(day)",null,null,null,null,"Shift # 2\n(evening)",null,null,null,null,"Shift # 3\n(night)",null,null,null,null,"(System\nCalculation)\nTotal"]
[null,null,null,null,null,"Registered Nurses",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,{"$f":"SUM(Q30:AE30)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Q30:AE32)","v":0}]
[null,null,null,null,null,"Licensed Practical Nurses",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,{"$f":"SUM(Q31:AE31)","v":0},null,null,null,null,null,null,"Nursing\ntwo\nand/or\nthree\nshifts\ndata\nprovided",null,{"$f":"SUM(Q35:Z37)","v":0}]
[null,null,null,null,null,"Aides and/or Orderlies",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,{"$f":"SUM(Q32:AE32)","v":0},null,null,null,null,null,null,null,null,{"$f":"(AO30+AO31)","v":0}]
[null,null,null,null,null,"(System Calculation)           Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q30:U32)","v":0},null,null,null,null,{"$f":"SUM(V30:Z32)","v":0},null,null,null,null,{"$f":"SUM(AA30:AE32)","v":0},null,null,null,null,{"$f":"SUM(Q33:AE33)","v":0}]
["Nursing\nTwo Shifts\nper Day\nPatterns",null,null,null,null,"Two Shifts",null,null,null,null,null,null,null,null,null,null,"Shift # 1\n(day)",null,null,null,null,"Shift # 2\n(evening)",null,null,null,null,null,null,null,null,null,"(System\nCalculation)\nTotal"]
[null,null,null,null,null,"Registered Nurses",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,{"$f":"SUM(Q35:Z35)","v":0},null,null,null,null,null,"Benefits\ndata\nprovided"]
[null,null,null,null,null,"Licensed Practical Nurses",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,{"$f":"SUM(Q36:Z36)","v":0},null,null,null,null,null,null,{"$f":"IF(AO32>=1,\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Aides and/or Orderlies",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,{"$f":"SUM(Q37:Z37)","v":0}]
[null,null,null,null,null,"(System Calculation)           Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q35:U37)","v":0},null,null,null,null,{"$f":"SUM(V35:Z37)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q38:Z38)","v":0}]
["Benefits",null,null,null,null,"Does your facility provide the following benefits?\nIf you offer any of the listed benefits, report (yes) \nfor that benefit whether or not you pay for all or \nany portion of the benefit for your employees.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"401 K Plan",null,null,null,null,null,"Yes/No",null,null,null,"-",null,null,null,null,null,{"$f":"IF(F_401YN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retirement Plan",null,null,null,null,null,"Yes/No",null,null,null,"-",null,null,null,null,null,{"$f":"IF(F_RPYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health Insurance",null,null,null,null,null,"Yes/No",null,null,null,"-",null,null,null,null,null,{"$f":"IF(F_HIYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Life Insurance",null,null,null,null,null,"Yes/No",null,null,null,"-",null,null,null,null,null,{"$f":"IF(F_LIYN<>\"-\",\"Ok\",\"Error\")","v":"Error"}]
["Do not enter zero.  Blank fields will represent zero employees."]
["Nurses",null,null,null,"Nurse\nType",null,null,null,"Highest\nEducation\nLevel",null,null,null,"FTE Number\nCurrently\nEmployed",null,null,null,null,null,"Number of \nBudgeted\nVacancies",null,null,null,null,null,"Number of\nPositions Added in\nthe Past 12\nMonths",null,null,null,null,null,"Number of\nPositions\nEliminated in the\nPast 12 Months"]
[null,null,null,null,"Registered",null,null,null,"Associate\nDegree"]
[null,null,null,null,null,null,null,null,"Diploma\nNurse"]
[null,null,null,null,null,null,null,null,"Bachelors\nDegree"]
[null,null,null,null,null,null,null,null,"Masters\nDegree"]
[null,null,null,null,null,null,null,null,"Doctorate\nDegree"]
[null,null,null,null,null,null,null,null,"(System\nCalc)\n       Total",null,null,null,{"$f":"SUM(M45:R49)","v":0},null,null,null,null,null,{"$f":"SUM(S45:X49)","v":0},null,null,null,null,null,{"$f":"SUM(Y45:AD49)","v":0},null,null,null,null,null,{"$f":"SUM(AE45:AJ49)","v":0}]
[null,null,null,null,"LPNs and\nAncillary\nNursing",null,null,null,"LPN"]
[null,null,null,null,null,null,null,null,"Nurses\nAides"]
[null,null,null,null,null,null,null,null,"(System\nCalc)\n       Total",null,null,null,{"$f":"SUM(M51:R52)","v":0},null,null,null,null,null,{"$f":"SUM(S51:X52)","v":0},null,null,null,null,null,{"$f":"SUM(Y51:AD52)","v":0},null,null,null,null,null,{"$f":"SUM(AE51:AJ52)","v":0}]
["Contract\nNursing\nPersonnel",null,null,null,"Yes/No",null,null,"-",null,null,"Does your organization use contract nursing personnel?  If yes, indicate the number\nof contract personnel in the following categories in the past 12 months.",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,"Contract\nnursing\nYes,\nAdditional\ndata\nprovided"]
[null,null,null,null,"Type",null,null,null,null,null,null,null,"Number of\nContract\nPersonnel",null,null,null,null,null,"Number of\nContract\nBudgeted\nVacancies",null,null,null,null,null,"Number of\nContract\nPositions Added in\nthe Past 12\nMonths",null,null,null,null,null,"Number of\nContract\nPositions\nEliminated in the\nPast 12 Months",null,null,null,null,null,null,"Contract\nNursing\nYes/No"]
[null,null,null,null,"Registered Nurses",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,{"$f":"IF(F_CNPYN<>\"-\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(AND(F_CNPYN=\"No\",AO56=0),\"Ok\",IF(AND(F_CNPYN=\"Yes\",AO56>=1),\"Ok\",\"Error\"))","v":"Error"},null,{"$f":"SUM(M56:AJ58)","v":0}]
[null,null,null,null,"Licensed Practical \nNurses"]
[null,null,null,null,"Certified Nurses Aides"]
[null,null,null,null,"(System Calculation)\n                           Total",null,null,null,null,null,null,null,{"$f":"SUM(F_CNPRNPer:F_CNPNAPer)","v":0},null,null,null,null,null,{"$f":"SUM(S56:X58)","v":0},null,null,null,null,null,{"$f":"SUM(Y56:AD58)","v":0},null,null,null,null,null,{"$f":"SUM(AE56:AJ58)","v":0}]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"F-Data","index":13,"n_rows":4,"n_cols":164,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Employee by Service",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,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,null,"Type of Employee by Service",null,null,null,"Nursing Three Shifts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nursing Two Sifts",null,null,null,null,null,null,null,null,null,null,null,"Benefits",null,null,null,"Registered Nurses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LPNs and Ancillary Nursing",null,null,null,null,null,null,null,null,null,null,null,"Contract Nursing Personnel"]
[null,null,null,"Administrators",null,null,null,"Assistant Administrators",null,null,null,"Registered Nurses",null,null,null,"Licensed Practical Nurses",null,null,null,"Nurses Aides and Orderlies",null,null,null,"Dietary Managers",null,null,null,"Registered Dieticians",null,null,null,"Dietetic Technicians",null,null,null,"Medical Social Workers",null,null,null,"Social Workers",null,null,null,"Activity Coordinators",null,null,null,"Maintenance",null,null,null,"Housekeeping",null,null,null,"Other 1",null,null,null,null,"Other 2",null,null,null,null,"Other 3",null,null,null,null,"Other 4",null,null,null,null,"Total",null,null,null,"Registered Nurses",null,null,null,"Licensed Practical Nurses",null,null,null,"Aides and/or Orderlies",null,null,null,"Total",null,null,null,"Registered Nurses",null,null,"Licensed Preactical Nurses",null,null,"Aides and/or Orderlies",null,null,"Total",null,null,"",null,null,null,"Associate Degree",null,null,null,"Diploma Nurse",null,null,null,"Bachelors Degree",null,null,null,"Masters Degree",null,null,null,"Doctorate Degree",null,null,null,"Total",null,null,null,"Licensed Pratical Nurses",null,null,null,"Nurses Aides",null,null,null,"Total",null,null,null,null,"Registered Nurses",null,null,null,"Licensed Practical Nurses",null,null,null,"Certified Nurses Aides",null,null,null,"Total"]
["State\nID","Facility Name","County","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Specify 1","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Specify 2","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Specify 3","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Specify 4","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Employee\nFull-Time","Employee\nPart-Time","Contract\nFull-Time","Contract\nPart-Time","Shift #1\n(Day)","Shift #2\n(Evening)","Shift #3\n(Night)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Shift #3\n(Night)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Shift #3\n(Night)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Shift #3\n(Night)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Total","Shift #1\n(Day)","Shift #2\n(Evening)","Total","401 K","Retirement","Health\nInsurance","Life\nInsurance","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","Contract\nYes/No","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated","FTE \nEmployed","Budgeted\nVacancies","Positions\nadded","Positions\nEliminated"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"IF(F_AdmEFT>=0.01,F_AdmEFT,\"\")","v":""},{"$f":"IF(F_AdmEPT>=0.01,F_AdmEPT,\"\")","v":""},{"$f":"IF(F_AdmCFT>=0.01,F_AdmCFT,\"\")","v":""},{"$f":"IF(F_AdmCPT>=0.01,F_AdmCPT,\"\")","v":""},{"$f":"IF(F_AAdmEFT>=0.01,F_AAdmEFT,\"\")","v":""},{"$f":"IF(F_AAdmEPT>=0.01,F_AAdmEPT,\"\")","v":""},{"$f":"IF(F_AAdmCFT>=0.01,F_AAdmCFT,\"\")","v":""},{"$f":"IF(F_AAdmCPT>=0.01,F_AAdmCPT,\"\")","v":""},{"$f":"IF(F_RNEFT>=0.01,F_RNEFT,\"\")","v":""},{"$f":"IF(F_RNEPT>=0.01,F_RNEPT,\"\")","v":""},{"$f":"IF(F_RNCFT>=0.01,F_RNCFT,\"\")","v":""},{"$f":"IF(F_RNCPT>=0.01,F_RNCPT,\"\")","v":""},{"$f":"IF(F_LPNEFT>=0.01,F_LPNEFT,\"\")","v":""},{"$f":"IF(F_LPNEPT>=0.01,F_LPNEPT,\"\")","v":""},{"$f":"IF(F_LPNCFT>=0.01,F_LPNCFT,\"\")","v":""},{"$f":"IF(F_LPNCPT>=0.01,F_LPNCPT,\"\")","v":""},{"$f":"IF(F_NAOEFT>=0.01,F_NAOEFT,\"\")","v":""},{"$f":"IF(F_NAOEPT>=0.01,F_NAOEPT,\"\")","v":""},{"$f":"IF(F_NAOCFT>=0.01,F_NAOCFT,\"\")","v":""},{"$f":"IF(F_NAOCPT>=0.01,F_NAOCPT,\"\")","v":""},{"$f":"IF(F_DMEFT>=0.01,F_DMEFT,\"\")","v":""},{"$f":"IF(F_DMEPT>=0.01,F_DMEPT,\"\")","v":""},{"$f":"IF(F_DMCFT>=0.01,F_DMCFT,\"\")","v":""},{"$f":"IF(F_DMCPT>=0.01,F_DMCPT,\"\")","v":""},{"$f":"IF(F_RDEFT>=0.01,F_RDEFT,\"\")","v":""},{"$f":"IF(F_RDEPT>=0.01,F_RDEPT,\"\")","v":""},{"$f":"IF(F_RDCFT>=0.01,F_RDCFT,\"\")","v":""},{"$f":"IF(F_RDCPT>=0.01,F_RDCPT,\"\")","v":""},{"$f":"IF(F_DTEFT>=0.01,F_DTEFT,\"\")","v":""},{"$f":"IF(F_DTEPT>=0.01,F_DTEPT,\"\")","v":""},{"$f":"IF(F_DTCFT>=0.01,F_DTCFT,\"\")","v":""},{"$f":"IF(F_DTCPT>=0.01,F_DTCPT,\"\")","v":""},{"$f":"IF(F_MSWEFT>=0.01,F_MSWEFT,\"\")","v":""},{"$f":"IF(F_MSWEPT>=0.01,F_MSWEPT,\"\")","v":""},{"$f":"IF(F_MSWCFT>=0.01,F_MSWCFT,\"\")","v":""},{"$f":"IF(F_MSWCPT>=0.01,F_MSWCPT,\"\")","v":""},{"$f":"IF(F_SWEFT>=0.01,F_SWEFT,\"\")","v":""},{"$f":"IF(F_SWEPT>=0.01,F_SWEPT,\"\")","v":""},{"$f":"IF(F_SWCFT>=0.01,F_SWCFT,\"\")","v":""},{"$f":"IF(F_SWCPT>=0.01,F_SWCPT,\"\")","v":""},{"$f":"IF(F_ACEFT>=0.01,F_ACEFT,\"\")","v":""},{"$f":"IF(F_ACEPT>=0.01,F_ACEPT,\"\")","v":""},{"$f":"IF(F_ACCFT>=0.01,F_ACCFT,\"\")","v":""},{"$f":"IF(F_ACCPT>=0.01,F_ACCPT,\"\")","v":""},{"$f":"IF(F_MEFT>=0.01,F_MEFT,\"\")","v":""},{"$f":"IF(F_MEPT>=0.01,F_MEPT,\"\")","v":""},{"$f":"IF(F_MCFT>=0.01,F_MCFT,\"\")","v":""},{"$f":"IF(F_MCPT>=0.01,F_MCPT,\"\")","v":""},{"$f":"IF(F_HEFT>=0.01,F_HEFT,\"\")","v":""},{"$f":"IF(F_HEPT>=0.01,F_HEPT,\"\")","v":""},{"$f":"IF(F_HCFT>=0.01,F_HCFT,\"\")","v":""},{"$f":"IF(F_HCPT>=0.01,F_HCPT,\"\")","v":""},{"$f":"F_OT1Spec","v":0},{"$f":"IF(F_OT1EFT>=0.01,F_OT1EFT,\"\")","v":""},{"$f":"IF(F_OT1EPT>=0.01,F_OT1EPT,\"\")","v":""},{"$f":"IF(F_OT1CFT>=0.01,F_OT1CFT,\"\")","v":""},{"$f":"IF(F_OT1CPT>=0.01,F_OT1CPT,\"\")","v":""},{"$f":"F_OT2Spec","v":0},{"$f":"IF(F_OT2EFT>=0.01,F_OT2EFT,\"\")","v":""},{"$f":"IF(F_OT2EPT>=0.01,F_OT2EPT,\"\")","v":""},{"$f":"IF(F_OT2CFT>=0.01,F_OT2CFT,\"\")","v":""},{"$f":"IF(F_OT2CPT>=0.01,F_OT2CPT,\"\")","v":""},{"$f":"F_OT3Spec","v":0},{"$f":"IF(F_OT3EFT>=0.01,F_OT3EFT,\"\")","v":""},{"$f":"IF(F_OT3EPT>=0.01,F_OT3EPT,\"\")","v":""},{"$f":"IF(F_OT3CFT>=0.01,F_OT3CFT,\"\")","v":""},{"$f":"IF(F_OT3CPT>=0.01,F_OT3CPT,\"\")","v":""},{"$f":"F_OT4Spec","v":0},{"$f":"IF(F_OT4EFT>=0.01,F_OT4EFT,\"\")","v":""},{"$f":"IF(F_OT4EPT>=0.01,F_OT4EPT,\"\")","v":""},{"$f":"IF(F_OT4CFT>=0.01,F_OT4CFT,\"\")","v":""},{"$f":"IF(F_OT4CPT>=0.01,F_OT4CPT,\"\")","v":""},{"$f":"IF(F_TotEFT>=0.01,F_TotEFT,\"\")","v":""},{"$f":"IF(F_TotEPT>=0.01,F_TotEPT,\"\")","v":""},{"$f":"IF(F_TotCFT>=0.01,F_TotCFT,\"\")","v":""},{"$f":"IF(F_TotCPT>=0.01,F_TotCPT,\"\")","v":""},{"$f":"IF(F_3RND>=1,F_3RND,\"\")","v":""},{"$f":"IF(F_3RNE>=1,F_3RNE,\"\")","v":""},{"$f":"IF(F_3RNN>=1,F_3RNN,\"\")","v":""},{"$f":"F_3RNTot","v":0},{"$f":"IF(F_3LPND>=1,F_3LPND,\"\")","v":""},{"$f":"IF(F_3LPNE>=1,F_3LPNE,\"\")","v":""},{"$f":"IF(F_3LPNN>=1,F_3LPNN,\"\")","v":""},{"$f":"F_3LPNTot","v":0},{"$f":"IF(F_3AidD>=1,F_3AidD,\"\")","v":""},{"$f":"IF(F_3AidE>=1,F_3AidE,\"\")","v":""},{"$f":"IF(F_3AidN>=1,F_3AidN,\"\")","v":""},{"$f":"F_3AidTot","v":0},{"$f":"F_3TotD","v":0},{"$f":"F_3TotE","v":0},{"$f":"F_3TotN","v":0},{"$f":"F_3TotTot","v":0},{"$f":"IF(F_2RND>=1,F_2RND,\"\")","v":""},{"$f":"IF(F_2RNE>=1,F_2RNE,\"\")","v":""},{"$f":"IF(F_2RNTot>=1,F_2RNTot,\"\")","v":""},{"$f":"IF(F_2LPND>=1, F_2LPND,\"\")","v":""},{"$f":"IF(F_2LPNE>=1,F_2LPNE,\"\")","v":""},{"$f":"F_2LPNTot","v":0},{"$f":"IF(F_2AidD>=1,F_2AidD,\"\")","v":""},{"$f":"IF(F_2AidE>=1,F_2AidE,\"\")","v":""},{"$f":"F_2AidTot","v":0},{"$f":"F_2TotD","v":0},{"$f":"F_2TotE","v":0},{"$f":"F_2TotTot","v":0},{"$f":"F_401YN","v":"-"},{"$f":"F_RPYN","v":"-"},{"$f":"F_HIYN","v":"-"},{"$f":"F_LIYN","v":"-"},{"$f":"IF(F_RNADEmp>=1,F_RNADEmp,\"\")","v":""},{"$f":"IF(F_RNADVac>=1,F_RNADVac,\"\")","v":""},{"$f":"IF(F_RNADAdd>=1,F_RNADAdd,\"\")","v":""},{"$f":"IF(F_RNADElm>=1,F_RNADElm,\"\")","v":""},{"$f":"IF(F_RNDNEmp>=1,F_RNDNEmp,\"\")","v":""},{"$f":"IF(F_RNDNVac>=1, F_RNDNVac,\"\")","v":""},{"$f":"IF(F_RNDNAdd>=1,F_RNDNAdd,\"\")","v":""},{"$f":"IF(F_RNDNElm>=1,F_RNDNElm,\"\")","v":""},{"$f":"IF(F_RNBDEmp>=1,F_RNBDEmp,\"\")","v":""},{"$f":"IF(F_RNBDVac>=1,F_RNBDVac,\"\")","v":""},{"$f":"IF(F_RNBDAdd>=1,F_RNBDAdd,\"\")","v":""},{"$f":"IF(F_RNBDElm>=1,F_RNBDElm,\"\")","v":""},{"$f":"IF(F_RNMDEmp>=1,F_RNMDEmp,\"\")","v":""},{"$f":"IF(F_RNMDVac>=1,F_RNMDVac,\"\")","v":""},{"$f":"IF(F_RNMDAdd>=1,F_RNMDAdd,\"\")","v":""},{"$f":"IF(F_RNMDElm>=1,F_RNMDElm,\"\")","v":""},{"$f":"IF(F_RNDDEmp>=1,F_RNDDEmp,\"\")","v":""},{"$f":"IF(F_RNDDVac>=1,F_RNDDVac,\"\")","v":""},{"$f":"IF(F_RNDDAdd>=1,F_RNDDAdd,\"\")","v":""},{"$f":"IF(F_RNDDElm>=1,F_RNDDElm,\"\")","v":""},{"$f":"F_RNTotEmp","v":0},{"$f":"F_RNTotVac","v":0},{"$f":"F_RNTotAdd","v":0},{"$f":"F_RNTotElm","v":0},{"$f":"IF(F_LPNEmp>=1,F_LPNEmp,\"\")","v":""},{"$f":"IF(F_LPNVac>=1,F_LPNVac,\"\")","v":""},{"$f":"IF(F_LPNAdd>=1,F_LPNAdd,\"\")","v":""},{"$f":"IF(F_LPNElm>=1,F_LPNElm,\"\")","v":""},{"$f":"IF(F_AidEmp>=1,F_AidEmp,\"\")","v":""},{"$f":"IF(F_AidVac>=1,F_AidVac,\"\")","v":""},{"$f":"IF(F_AidAdd>=1,F_AidAdd,\"\")","v":""},{"$f":"IF(F_AidElm>=1,F_AidElm,\"\")","v":""},{"$f":"F_LPNAidTotEmp","v":0},{"$f":"F_LPNAidTotVac","v":0},{"$f":"F_LPNAidTotAdd","v":0},{"$f":"F_LPNAidTotElm","v":0},{"$f":"F_CNPYN","v":"-"},{"$f":"IF(F_CNPRNPer>=1,F_CNPRNPer,\"\")","v":""},{"$f":"IF(F_CNPRNVac>=1,F_CNPRNVac,\"\")","v":""},{"$f":"IF(F_CNPRNAdd>=1,F_CNPRNAdd,\"\")","v":""},{"$f":"IF(F_CNPRNElm>=1,F_CNPRNElm,\"\")","v":""},{"$f":"IF(F_CNPLPNPer>=1,F_CNPLPNPer,\"\")","v":""},{"$f":"IF(F_CNPLPNVac>=1,F_CNPLPNVac,\"\")","v":""},{"$f":"IF(F_CNPLPNAdd>=1,F_CNPLPNAdd,\"\")","v":""},{"$f":"IF(F_CNPLPNElm>=1,F_CNPLPNElm,\"\")","v":""},{"$f":"IF(F_CNPNAPer>=1,F_CNPNAPer,\"\")","v":""},{"$f":"IF(F_CNPNAVac>=1,F_CNPNAVac,\"\")","v":""},{"$f":"IF(F_CNPNAAdd>=1,F_CNPNAAdd,\"\")","v":""},{"$f":"IF(F_CNPNAElm>=1,F_CNPNAElm,\"\")","v":""},{"$f":"F_CNPTotPer","v":0},{"$f":"F_CNPTotVac","v":0},{"$f":"F_CNPTotAdd","v":0},{"$f":"F_CNPTotElm","v":0}]

{"sheet":"Sch G","index":14,"n_rows":36,"n_cols":38,"rows_kept":36,"cut":false,"hidden":false,"merged":[[23,5,23,30],[23,31,23,35],[11,31,11,35],[4,5,6,9],[7,5,8,9],[9,31,9,35],[9,10,9,30],[10,10,10,30],[12,10,12,30],[12,31,12,35],[10,31,10,35],[11,10,11,30],[14,10,14,30],[14,31,14,35],[5,10,5,30],[6,31,6,35],[32,31,32,35],[27,5,29,9],[30,5,32,9],[31,10,31,30],[32,10,32,30],[27,31,27,35],[28,31,28,35],[29,10,29,30],[29,31,29,35],[31,31,31,35],[30,31,30,35],[30,10,30,30],[1,0,1,3],[1,4,1,8],[1,9,1,14],[1,33,1,35],[1,15,1,32],[3,31,3,35],[17,31,17,35],[18,31,18,35],[18,10,18,30],[0,37,0,39],[0,0,0,35],[7,31,7,35],[8,31,8,35],[13,10,13,30],[13,31,13,35],[4,31,4,35],[7,10,7,30],[8,10,8,30],[5,31,5,35],[4,10,4,30],[6,10,6,30],[34,0,34,35],[19,31,19,35],[20,31,20,35],[21,31,21,35],[22,31,22,35],[23,0,32,4],[20,5,22,9],[20,10,20,30],[21,10,21,30],[15,5,19,9],[15,10,15,30],[16,10,16,30],[19,10,19,30],[24,10,24,35],[15,31,15,35],[16,31,16,35],[35,0,35,35],[2,0,2,35],[26,31,26,35],[26,10,26,30],[24,5,26,9],[27,10,27,30],[22,10,22,30],[28,10,28,30],[17,10,17,30],[3,5,3,30],[33,0,33,35],[25,10,25,30],[25,31,25,35],[3,0,22,4],[13,5,14,9],[9,5,12,9]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020}]
["Schedule G - Skilled Care Procedures"]
["Procedures\nProvided",null,null,null,null,"Please report the number of residents receiving the following procedures on the \nlast day of the reporting period.",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,"Number of\nResidents"]
[null,null,null,null,null,"Medication",null,null,null,null,"Given by intravenous injections"]
[null,null,null,null,null,null,null,null,null,null,"Given by intramuscular injections"]
[null,null,null,null,null,null,null,null,null,null,"Given by insulin pump"]
[null,null,null,null,null,"Intravenous\nFeeding",null,null,null,null,"IV antibiotic therapy"]
[null,null,null,null,null,null,null,null,null,null,"IV chemotherapy"]
[null,null,null,null,null,"Tube\nFeedings",null,null,null,null,"Gastrostomy: care of a surgical creation of an artificial opening into\n the stomach."]
[null,null,null,null,null,null,null,null,null,null,"Jejunostomy: care of a surgical creation of a permanent opening \nbetween the jejunum and the surface of the abdominal wall."]
[null,null,null,null,null,null,null,null,null,null,"Enteral nutrition: A form of nutrition that is delivered into the \ndigestive system as a liquid.  Drinking nutrition beverages or \nformulas and tube feeding are forms of enteral nutrition.  Tube \nfeeding can be used to add to what a person is able to eat or \ncan be the only source of nutrition.  A small feeding tube may \nbe placed through the nose into the stomach or the small \nintestine, or it may be surgically placed into the stomach or the \nintestinal tract through an opening made on the outside of the \nabdomen, depending on how long it will be used."]
[null,null,null,null,null,null,null,null,null,null,"Parenteral nutrition: A form of nutrition that is delivered into a vein.  \nParenteral nutrition does not use the digestive system.  It may be \ngiven to people who are unable to absorb nutrients through the \nintestinal tract because of vomiting that won't stop, severe diarrhea, \nor intestinal disease.  It may also be given to those undergoing \nhigh-dose chemotherapy or radiation and bone marrow \ntransplantation.  It is possible to give all of the protein, calories, \nvitamins and minerals a person needs using parenteral nutrition.  \nAlso known as hyper alimentation or total parenteral nutrition (TPN)."]
[null,null,null,null,null,"Respiratory\nTherapy",null,null,null,null,"IPPB treatments: Intermittent Positive Pressure Breathing"]
[null,null,null,null,null,null,null,null,null,null,"Oxygen"]
[null,null,null,null,null,"Wound\nCare",null,null,null,null,"Ducebitus Ulcer care: Care for an ulceration caused by prolonged \npressure in a resident allowed to lie too still in bed for a long \nperiod of time; also called bed sore and pressure sore."]
[null,null,null,null,null,null,null,null,null,null,"Sterile dressings with prescription medicine"]
[null,null,null,null,null,null,null,null,null,null,"Wound irrigations"]
[null,null,null,null,null,null,null,null,null,null,"Hemovac care"]
[null,null,null,null,null,null,null,null,null,null,"Diabetic wound care"]
[null,null,null,null,null,"Catheter\nCare",null,null,null,null,"Hickman"]
[null,null,null,null,null,null,null,null,null,null,"Port-a-cath"]
[null,null,null,null,null,null,null,null,null,null,"Subclavian"]
["Procedures\nProvided",null,null,null,null,"Please report the number of residents receiving the following procedures on the \nlast day of the reporting period.",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,"Number of\nResidents"]
[null,null,null,null,null,"Enterostomy\nCare",null,null,null,null,"Enterostomy: The formation of a permanent opening into the intestine through the\nabdominal wall; usually by surgical means; also, the opening so created."]
[null,null,null,null,null,null,null,null,null,null,"Irrigation and care for a Colostomy (The surgical creation of an \nopening between the colon and the surface of the body; also \nused to refer to the opening, or stoma, so created)"]
[null,null,null,null,null,null,null,null,null,null,"Care for an Ileostomy (The surgical creation of an opening into the\nileum, usually by establishing an ileal stoma on the abdominal wall)"]
[null,null,null,null,null,"Genital/\nUrinary\nCare",null,null,null,null,"Indwelling foley catheter maintenance and care"]
[null,null,null,null,null,null,null,null,null,null,"Intermittent bladder irrigations"]
[null,null,null,null,null,null,null,null,null,null,"Bladder irrigations, continuous with medication instillation"]
[null,null,null,null,null,"Therapy",null,null,null,null,"Physical Therapy"]
[null,null,null,null,null,null,null,null,null,null,"Occupational Therapy"]
[null,null,null,null,null,null,null,null,null,null,"Speech Therapy"]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"G-Data","index":15,"n_rows":4,"n_cols":30,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info"]
[null,null,null,"Medication",null,null,"Intravenous Feeding",null,"Tube Feedings",null,null,null,"Respiratory Therapy",null,"Wound Care",null,null,null,null,"Catheter Care",null,null,"Enterostomy Care",null,"Genital/Urinary Care",null,null,"Therapy"]
["State\nID","Facility Name","County","Intravenous\ninjections","Intramuscular\ninjections","Insulin\npump","IV\nantibiotic","IV\nchemotherapy","Gastrostomy","Jejunostomy","Enteral\nnutrition","Parenteral\nnutrition","IPPB","Oxygen","Ducubitus\nUlcer","Sterile\ndressings","Wound\nirrigations","Hemovac\ncare","Diabetic","Hickman","Port-a-cath","Subclavian","Colostomy\nirrigation","Ileostomy","Indwelling\nfoley\ncatheter","Intermittent\nbladder\nirrigations","Bladder\nirrigations","Physical","Occupational","Speech"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"G_MInvInj","v":0},{"$f":"G_MInmInj","v":0},{"$f":"G_MInP","v":0},{"$f":"G_IFAT","v":0},{"$f":"G_IFC","v":0},{"$f":"G_TFG","v":0},{"$f":"G_TFJ","v":0},{"$f":"G_TFEN","v":0},{"$f":"G_TFPN","v":0},{"$f":"G_RTIPPB","v":0},{"$f":"G_RTOxy","v":0},{"$f":"G_WCDU","v":0},{"$f":"G_WCSD","v":0},{"$f":"G_WCWI","v":0},{"$f":"G_WCHC","v":0},{"$f":"G_WCDWC","v":0},{"$f":"G_CCH","v":0},{"$f":"G_CCP","v":0},{"$f":"G_CCS","v":0},{"$f":"G_ECCI","v":0},{"$f":"G_ECI","v":0},{"$f":"G_GInd","v":0},{"$f":"G_GInt","v":0},{"$f":"G_GBi","v":0},{"$f":"G_PT","v":0},{"$f":"G_OT","v":0},{"$f":"G_ST","v":0}]

{"sheet":"Sch H","index":16,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,31,14,35],[3,10,3,35],[4,31,4,35],[13,31,13,35],[7,31,7,35],[8,31,8,35],[6,10,6,30],[10,31,10,35],[2,0,2,35],[1,0,1,3],[1,4,1,8],[0,37,0,39],[1,9,1,14],[0,0,0,35],[1,33,1,35],[1,15,1,32],[24,10,24,30],[21,31,21,35],[19,31,19,35],[15,10,15,35],[16,10,16,30],[17,10,17,30],[16,31,16,35],[17,31,17,35],[18,31,18,35],[28,0,28,35],[30,0,30,35],[22,5,27,9],[27,10,27,30],[27,31,27,35],[15,0,27,4],[26,10,26,30],[22,10,22,35],[20,31,20,35],[26,31,26,35],[29,0,29,35],[15,5,21,9],[20,10,20,30],[18,10,18,30],[21,10,21,30],[19,10,19,30],[4,37,7,37],[10,37,13,37],[23,37,26,37],[16,37,20,37],[25,10,25,30],[23,31,23,35],[24,31,24,35],[25,31,25,35],[23,10,23,30],[7,10,7,30],[5,31,5,35],[6,31,6,35],[8,10,8,30],[11,31,11,35],[12,31,12,35],[9,10,9,35],[3,0,14,4],[3,5,8,9],[9,5,14,9],[4,10,4,30],[5,10,5,30],[13,10,13,30],[11,10,11,30],[14,10,14,30],[12,10,12,30],[10,10,10,30]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020}]
["Schedule H - Activities of Daily Living (ADL)"]
["Activities\nof Daily\nLiving\n(ADLs)",null,null,null,null,"ADLs",null,null,null,null,"Number of residents on the last day of the reporting period that require assistance  \nwith activities of daily living (ADL) \n(Residents will be duplicated and should be counted in every category that applies.)"]
[null,null,null,null,null,null,null,null,null,null,"Bathing",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,"ADL\ndata\nprovided",null,null,{"$f":"IF(H_ADLB<>\"\",1,0)","v":0},{"$f":"SUM(AO5:AO9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Toileting",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,{"$f":"IF(H_ADLT<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dressing",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,{"$f":"IF(H_ADLD<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Eating",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,{"$f":"IF(H_ADLE<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Transferring (in and out of bed to chair)",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,{"$f":"IF(AP5=5,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(H_ADLTr<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Multiple\nADLs",null,null,null,null,"Number of residents on the last day of the reporting period \nby the number of ADLs requiring Assistance."]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 1 ADL",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,"Multiple\nADL\ndata\nprovided",null,null,{"$f":"IF(H_MADL1<>\"\",1,0)","v":0},{"$f":"SUM(AO11:AO15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 2 ADLs",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,{"$f":"IF(H_MADL2<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 3 ADLs",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,{"$f":"IF(H_MADL3<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 4 ADLs",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,{"$f":"IF(H_MADL4<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 5 ADLs",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,{"$f":"IF(AP11=5,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(H_MADL5<>\"\",1,0)","v":0}]
["Instrumental\nActivities\nof Daily\nLiving\n(IADLs)",null,null,null,null,"IADLs",null,null,null,null,"Number of residents on the last day of the reporting period that require assistance\nwith instrumental activities of daily living (IADL) \n(Residents will be duplicated and should be counted in every category that applies.)"]
[null,null,null,null,null,null,null,null,null,null,"Money management",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,"IADL\ndata\nprovided",null,null,{"$f":"IF(H_IADLMM<>\"\",1,0)","v":0},{"$f":"SUM(AO17:AO22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Shopping",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,{"$f":"IF(H_IADLS<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Preparing meals",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,{"$f":"IF(H_IADLPM<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Using phones",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,{"$f":"IF(H_IADLUP<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Doing light housework",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,{"$f":"IF(H_IADLDLH<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Taking medication",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,{"$f":"IF(AP17=6,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(H_IADLTM<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Multiple\nIADLs",null,null,null,null,"Number of residents on the last day of the reporting period \nby the number of IADLs requiring assistance."]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 1 IADL",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,"Multiple\nIADL\ndata\nprovided",null,null,{"$f":"IF(H_IADL1<>\"\",1,0)","v":0},{"$f":"SUM(AO24:AO28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 2 IALDs",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,{"$f":"IF(H_IADL2<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 3 IALDs",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,{"$f":"IF(H_IADL3<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 4 IADLs",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,{"$f":"IF(H_IADL4<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Require assistance with 5 or more IADLs",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,{"$f":"IF(AP24=5,\"Ok\",\"Error\")","v":"Error"},null,null,{"$f":"IF(H_IADL5<>\"\",1,0)","v":0}]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"H-Data","index":17,"n_rows":4,"n_cols":24,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Activities of Daily Living (ALDs)",null,null,null,null,null,null,null,null,null,"Instrumental Activities of Daily Living (IADLs)"]
[null,null,null,"",null,null,null,null,"Multiple ADLs",null,null,null,null,null,null,null,null,null,null,"Multiple IADLs"]
["State\nID","Facility Name","County","Bathing","Toileting","Dressing","Eating","Transferring","1 ADL","2 ADLs","3ADLs","4 ADLs","5 or\nmore\nADLs","Money\nMgmt","Shopping","Preparing\nmeals","Using\nphone","Light\nhousework","Taking\nmedication","1 IALD","2 IALDs","3 IALDs","4 IADLs","5 or \nmore\nIADLs"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"H_ADLB","v":0},{"$f":"H_ADLT","v":0},{"$f":"H_ADLD","v":0},{"$f":"H_ADLE","v":0},{"$f":"H_ADLTr","v":0},{"$f":"H_MADL1","v":0},{"$f":"H_MADL2","v":0},{"$f":"H_MADL3","v":0},{"$f":"H_MADL4","v":0},{"$f":"H_MADL5","v":0},{"$f":"H_IADLMM","v":0},{"$f":"H_IADLS","v":0},{"$f":"H_IADLPM","v":0},{"$f":"H_IADLUP","v":0},{"$f":"H_IADLDLH","v":0},{"$f":"H_IADLTM","v":0},{"$f":"H_IADL1","v":0},{"$f":"H_IADL2","v":0},{"$f":"H_IADL3","v":0},{"$f":"H_IADL4","v":0},{"$f":"H_IADL5","v":0}]

{"sheet":"Sch I","index":18,"n_rows":36,"n_cols":45,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,37,0,39],[3,30,4,35],[3,5,3,29],[4,5,4,29],[2,0,2,35],[1,0,1,3],[1,4,1,8],[1,9,1,14],[2,38,4,38],[2,39,4,39],[1,37,4,37],[32,5,32,35],[20,21,20,22],[12,0,12,4],[3,0,11,4],[6,5,6,29],[9,5,9,29],[10,5,10,29],[11,5,11,29],[5,5,5,29],[31,0,31,4],[31,5,31,35],[32,0,32,4],[5,30,5,35],[6,30,6,35],[7,30,7,35],[8,30,8,35],[7,5,7,29],[8,5,8,29],[17,10,17,15],[16,13,16,15],[19,0,23,4],[17,21,17,25],[25,0,25,4],[25,31,25,35],[33,0,33,35],[34,0,34,35],[13,0,18,4],[18,31,18,35],[14,31,14,35],[14,26,14,30],[20,5,20,15],[17,16,17,20],[18,5,18,15],[13,16,14,20],[15,16,15,20],[13,21,14,25],[17,26,17,30],[17,31,17,35],[16,16,16,20],[27,5,27,30],[28,5,28,30],[29,5,29,30],[16,5,16,9],[15,10,15,12],[16,10,16,12],[24,0,24,4],[15,13,15,15],[17,5,17,9],[35,0,35,35],[26,0,30,4],[28,31,28,35],[29,31,29,35],[26,31,26,35],[27,31,27,35],[18,21,18,25],[22,23,22,27],[22,28,22,30],[23,5,23,15],[18,16,18,20],[18,26,18,30],[20,16,20,20],[21,16,21,20],[22,21,22,22],[23,16,23,20],[30,31,30,35],[24,5,24,30],[25,5,25,30],[30,5,30,30],[26,5,26,30],[21,28,21,30],[22,5,22,15],[21,5,21,15],[12,39,14,39],[6,38,8,38],[6,39,8,39],[21,21,21,22],[23,23,23,27],[23,28,23,30],[19,39,21,39],[24,31,24,35],[21,31,21,35],[12,38,14,38],[10,30,10,35],[11,30,11,35],[12,30,12,35],[9,30,9,35],[13,26,13,35],[12,5,12,29],[19,23,19,27],[22,16,22,20],[21,23,21,27],[23,31,23,35],[23,21,23,22],[20,31,20,35],[20,28,20,30],[15,5,15,9],[19,16,19,20],[19,5,19,15],[20,23,20,27],[22,31,22,35],[19,31,19,35],[19,28,19,30],[0,0,0,35],[13,5,14,15],[1,33,1,35],[1,15,1,32],[19,38,21,38],[17,37,20,37],[13,37,15,37],[15,26,15,30],[16,26,16,30],[15,31,15,35],[16,31,16,35],[15,21,15,25],[16,21,16,25],[19,21,19,22]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020},null,null,null,"Data\nprovided"]
["Schedule I - Financial Data",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,null,null,"Building\nOwn/\nLease","Equipment\nOwn/\nLease"]
["Expenses",null,null,null,null,"Type of Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount"]
[null,null,null,null,null,"(Exclude all depreciation and round figures to the nearest dollar)"]
[null,null,null,null,null,"Administration: Include all expenses associated with administration in this item\nincluding payroll.  Do not duplicate any administrative expenses in the other\ncategories of expense.",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,{"$f":"IF(I_ExpAdm<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CABOL=\"-\",\"Error\",\"Ok\")","v":"Error"},{"$f":"IF(I_CAEOL=\"-\",\"Error\",\"Ok\")","v":"Error"}]
[null,null,null,null,null,"Payroll: Include salaries for all full-time and part-time personnel.",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,{"$f":"IF(I_ExpPay<>\"\",\"Ok\",\"Error\")","v":"Error"},"Cost\nData\nProvided","Market\nValue\nData\nProvided"]
[null,null,null,null,null,"Fringe Benefits: Social Security, group insurance, retirement benefit, etc.",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,{"$f":"IF(I_ExpFB<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Contract and Professional Fees.",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,{"$f":"IF(I_ExpCPF<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Other Operating Expenses: Expenses for all energy expense (oil, natural gas,\nelectricity, etc.), and all other operating expenses.",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,{"$f":"IF(I_ExpOOE<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CABCO<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CABMV<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Non-operating Expenses: Expenses for interest, taxes (even though they are\nlisted below), real estate lease expenses, and other non-operating expenses.",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,{"$f":"IF(I_ExpNOE<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CAECO<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CAEMV<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"(System Calculation)                                                                               Total:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE6:AJ11)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AND(I_CAOSP = \"\", I_CAOCO = \"\"), \"Ok\", IF(AND(I_CAOSP <> \"\", I_CAOCO = \"\"), \"Error\", \"Ok\"))","v":"Ok"},{"$f":"IF(AND(I_CAOSP = \"\", I_CAOMV = \"\"), \"Ok\", IF(AND(I_CAOSP <> \"\", I_CAOMV = \"\"), \"Error\", \"Ok\"))","v":"Ok"}]
["Taxes",null,null,null,null,"Taxes (should also have been included in Expenses, above)",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,{"$f":"IF(I_Taxes<>\"\",\"Ok\",\"Error\")","v":"Error"},"Dep\nAnnual\nData\nProvided","Dep\nAccum\nData\nProvided"]
["Capital\nAssets",null,null,null,null,"Capital Assets",null,null,null,null,null,null,null,null,null,null,"Cost",null,null,null,null,"Market Value",null,null,null,null,"Depreciation",null,null,null,null,null,null,null,null,null,null,"Other,\nspecify\ndata\nProvided"]
[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,"Annual",null,null,null,null,"Accumulated"]
[null,null,null,null,null,"Building",null,null,null,null,"Own or\nLease",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,{"$f":"IF(I_CABAN<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CABAC<>\"\",\"Ok\",\"Error\")","v":"Error"},null,{"$f":"IF(OR(I_CAOCO, I_CAOMV, I_CAOAN, I_CAOAC <> \"\"), 1, 0)","v":0},{"$f":"IF(I_CAOSP<>\"\",1,0)","v":0},{"$f":"AP16+AQ16","v":0},{"$f":"OR(AR16=0,AR16=2)","v":true}]
[null,null,null,null,null,"Equipment",null,null,null,null,"Own or\nLease",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,{"$f":"IF(AS16=TRUE,\"Ok\",\"Error\")","v":"Ok"},{"$f":"IF(I_CAEAN<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_CAEAC<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Other, \nSpecify",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,"Gross\nResident\nCharges\ngreater\nthan\nAdjust-\nMents",{"$f":"IF(AND(I_CAOSP = \"\", I_CAOAN = \"\"), \"Ok\", IF(AND(I_CAOSP <> \"\", I_CAOAN = \"\"), \"Error\", \"Ok\"))","v":"Ok"},{"$f":"IF(AND(I_CAOSP = \"\", I_CAOAC = \"\"), \"Ok\", IF(AND(I_CAOSP <> \"\", I_CAOAC = \"\"), \"Error\", \"Ok\"))","v":"Ok"}]
[null,null,null,null,null,"(System Calculation)           Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q16:U18)","v":0},null,null,null,null,{"$f":"SUM(V16:Z18)","v":0},null,null,null,null,{"$f":"SUM(AA16:AE18)","v":0},null,null,null,null,{"$f":"SUM(AF16:AJ18)","v":0}]
["Revenue\nfrom\nCharges",null,null,null,null,"Revenue Source",null,null,null,null,null,null,null,null,null,null,"Gross Resident\nCharges",null,null,null,null,"Minus",null,"Adjustment to\nCharges",null,null,null,null,"Equals",null,null,"Net Resident\nRevenue",null,null,null,null,null,null,"Gross\nResident\nCharges\nData\nProvided","Adj to\nCharges\nData\nProvided"]
[null,null,null,null,null,"Self-Pay",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,null,{"$f":"(I_RCSPGRC-I_RCSPAC)","v":0}]
[null,null,null,null,null,"Long-Term Care Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,null,{"$f":"(I_RCLTCIGRC-I_RCLTCIAC)","v":0},null,null,null,null,null,{"$f":"IF(I_RCSPAC>I_RCSPGRC,\"Error\",\"Ok\")","v":"Ok"}]
[null,null,null,null,null,"Other   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,"=",null,null,{"$f":"(I_RCOthGRC-I_RCOthAC)","v":0},null,null,null,null,null,{"$f":"IF(I_RCLTCIAC>I_RCLTCIGRC,\"Error\",\"Ok\")","v":"Ok"},{"$f":"IF(I_RCSPGRC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_RCSPAC<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"(System Calculation)           Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q21:U23)","v":0},null,null,null,null,"-",null,{"$f":"SUM(X21:AB23)","v":0},null,null,null,null,"=",null,null,{"$f":"(I_RCTotGRC-I_RCTotAC)","v":0},null,null,null,null,null,{"$f":"IF(I_RCOthAC>I_RCOthGRC,\"Error\",\"Ok\")","v":"Ok"},{"$f":"IF(I_RCLTCIGRC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_RCLTCIAC<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Other Revenue",null,null,null,null,"All Other Revenue",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,{"$f":"IF(I_OthRev<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_RCOthGRC<>\"\",\"Ok\",\"Error\")","v":"Error"},{"$f":"IF(I_RCOthAC<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Total Revenue",null,null,null,null,"(System Calculation)                 Grand Total Revenue:                                                                                \n                                               Total Revenue from Charges plus All Other Revenue",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,{"$f":"SUM(I_RCTotNRR+I_OthRev)","v":0}]
["Detail of\nAdjustments\nto Charges",null,null,null,null,"Bad Debt",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,{"$f":"IF(I_DACBad<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Charity Care",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,{"$f":"IF(I_DACCha<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Non-Government Contractual",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,{"$f":"IF(I_DACNGC<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"Other",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,{"$f":"IF(I_DACOth<>\"\",\"Ok\",\"Error\")","v":"Error"}]
[null,null,null,null,null,"(System Calculation)                                                                     Total Adjustments",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,{"$f":"SUM(AF27:AJ30)","v":0}]
["Bad\nDebts",null,null,null,null,"(1) Bad debts are amounts considered to be uncollectible from accounts and notes receivable which \nare created or acquired in providing services. \"Accounts receivable\" and \"notes receivable\" are \ndesignations for claims arising from rendering services and are collectible in money in the relatively \nnear future.\n(A) A debt must meet these criteria: (i) The provider must be able to establish that reasonable \ncollection efforts were made. (ii) The debt was actually uncollectible when claimed as worthless. \n(iii) Sound business judgment established that there was no likelihood of recovery at any time in the \nfuture.  (iv) Accounts turned over to a collection agency should be classified as bad debt.\n(B) If after reasonable and customary attempts to collect a bill, the debt remains unpaid more than \none hundred twenty (120) days from the date the first bill is mailed to the patient, the debt may be \ndeemed uncollectible. Bankrupt accounts shall be considered bad debts, unless there is \ndocumented evidence that the medical bill caused bankruptcy. Such accounts would then be \ncounted as charity."]
["Charity\nCare",null,null,null,null,"(2) Charity care is reductions in charges made by the provider of services because of the indigence \nor medical indigence of the patient. The provider should apply the following guidelines for making a \ndetermination of indigence or medical indigence:\n(A) The patient's indigence must be determined by the provider, not by the patient; i.e., a patient's\nsigned declaration of his inability to pay his medical bills cannot be considered proof of indigence;\n(B) The provider should take into account a patient's total resources which would include, but are not \nlimited to, an analysis of assets (only those convertible to cash and unnecessary for the patient's \ndaily living), liabilities, and income and expenses. Indigence income means an amount not to exceed \none hundred percent (100%) of the federal poverty guidelines. Medical indigence is a status reached \nwhen a person uses or commits all available current and expected resources to pay for medical bills \nand is not limited to a defined percent of the federal poverty guidelines. In making this analysis the \nprovider should take into account any extenuating circumstances that would affect the determination \nof the patient's indigence;\n(C) The provider must determine that no source other than the patient would be legally responsible\nfor  the patient's medical bill; e.g., Title XIX, local welfare agency and guardian; and \n(D) The patient's file should contain documentation of the method by which indigence was \ndetermined in addition to all backup information to substantiate the determination.\n(E) Once indigence is determined and the provider concludes that there had been no improvement in \nthe beneficiary's financial condition, the debt may be deemed uncollectible without applying the bad \ndebt collection criteria."]
["Return to Main Menu"]
["Next Schedule"]
["Error Listing"]

{"sheet":"I-Data","index":19,"n_rows":4,"n_cols":49,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,11,1,15],[1,16,1,20],[1,21,1,25]]}
["Facility ID Info",null,null,"Expenses",null,null,null,null,null,null,"Taxes",null,null,null,null,null,"Capital Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue from Charges",null,null,null,null,null,null,null,null,null,null,null,"Other","Total","Detail of Adjustments to Charges"]
[null,null,null,null,null,null,null,null,null,null,null,"Building",null,null,null,null,"Equipment",null,null,null,null,"Other",null,null,null,null,"Total",null,null,null,"Self-Pay",null,null,"Long-Term Care Insurance",null,null,"Other",null,null,"Total",null,null,"Revenue","Revenue"]
["State\nID","Facility Name","County","Administration","Payroll","Fringe\nBenefits","Contract\n& Prof\nFees","Other\nOperating","Non-\nOperating","Total","Taxes","Own/\nLease","Cost","Market\nValue","Annual\nDepreciation","Accumulated\nDepreciation","Own/\nLease","Cost","Market\nValue","Annual\nDepreciation","Accumulated\nDepreciation","Specify","Cost","Market\nValue","Annual\nDepreciation","Accumulated\nDepreciation","Cost","Market\nValue","Annual\nDepreciation","Accumulated\nDepreciation","Gross\nResident\nCharges","Adjustment \nto\nCharges","Net\nResident\nRevenue","Gross\nResident\nCharges","Adjustment \nto\nCharges","Net\nResident\nRevenue","Gross\nResident\nCharges","Adjustment \nto\nCharges","Net\nResident\nRevenue","Gross\nResident\nCharges","Adjustment \nto\nCharges","Net\nResident\nRevenue","All\nOther\nRevenue","Grand\nTotal\nRevenue","Bad \nDebt","Charity\nCare","Non-\nGovt\nContractual","Other","Total"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"I_ExpAdm","v":0},{"$f":"I_ExpPay","v":0},{"$f":"I_ExpFB","v":0},{"$f":"I_ExpCPF","v":0},{"$f":"I_ExpOOE","v":0},{"$f":"I_ExpNOE","v":0},{"$f":"I_ExpTot","v":0},{"$f":"I_Taxes","v":0},{"$f":"I_CABOL","v":"-"},{"$f":"I_CABCO","v":0},{"$f":"I_CABMV","v":0},{"$f":"I_CABAN","v":0},{"$f":"I_CABAC","v":0},{"$f":"I_CAEOL","v":"-"},{"$f":"I_CAECO","v":0},{"$f":"I_CAEMV","v":0},{"$f":"I_CAEAN","v":0},{"$f":"I_CAEAC","v":0},{"$f":"I_CAOSP","v":0},{"$f":"I_CAOCO","v":0},{"$f":"I_CAOMV","v":0},{"$f":"I_CAOAN","v":0},{"$f":"I_CAOAC","v":0},{"$f":"I_CATotCos","v":0},{"$f":"I_CATotMV","v":0},{"$f":"I_CATotDAN","v":0},{"$f":"I_CATotDAC","v":0},{"$f":"I_RCSPGRC","v":0},{"$f":"I_RCSPAC","v":0},{"$f":"I_RCSPNRR","v":0},{"$f":"I_RCLTCIGRC","v":0},{"$f":"I_RCLTCIAC","v":0},{"$f":"I_RCLTCINRR","v":0},{"$f":"I_RCOthGRC","v":0},{"$f":"I_RCOthAC","v":0},{"$f":"I_RCOthNRR","v":0},{"$f":"I_RCTotGRC","v":0},{"$f":"I_RCTotAC","v":0},{"$f":"I_RCTotNRR","v":0},{"$f":"I_OthRev","v":0},{"$f":"I_TotRev","v":0},{"$f":"I_DACBad","v":0},{"$f":"I_DACCha","v":0},{"$f":"I_DACNGC","v":0},{"$f":"I_DACOth","v":0},{"$f":"I_DACTot","v":0}]

{"sheet":"Admin Dec","index":20,"n_rows":9,"n_cols":39,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,35],[5,9,5,35],[6,0,6,8],[6,9,6,17],[6,18,6,35],[5,0,5,5],[7,0,7,35],[5,6,5,8],[0,37,0,39],[3,37,4,37],[2,0,2,35],[1,0,1,3],[1,4,1,8],[0,0,0,35],[3,2,3,35],[4,0,4,1],[4,2,4,35],[3,0,3,1],[1,9,1,14],[1,33,1,35],[1,15,1,32]]}
["Provisional   Provisional",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,null,"'Ok' = Likely no Error\n'Error' - Maybe Error\nin data provided"]
["State ID:",null,null,null,{"$f":"A_StateID","v":0},null,null,null,null,"Facility Name:",null,null,null,null,null,{"$f":"A_FacilityName","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Sch A'!AH2:AJ2","v":2020}]
["Administrator Declaration"]
["-",null,"Have you Saved and Renamed the report with your State ID and Facility name as instructed?\nExample: \"12345 ABC Assisted Living\"",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,"Admin\nDec\nChecked"]
["-",null,"Have you Checked and Corrected all Errors on the Error Tab?  "]
["Administrator's Declaration",null,null,null,null,null,"-",null,null," I, the administrator, declare that I have examined this report and to the best of my\n knowledge and belief, it is true, correct, and complete.",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,{"$f":"IF(AD_AdminDec<>\"-\",\"Ok\",\"Error\")","v":"Error"},"Admin\nDec\nDate"]
[" Date (mm/dd/yyyy)\n (use slashes)",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,null,null,{"$f":"IF(AD_AdDecDate<>\"\",\"Ok\",\"Error\")","v":"Error"}]
["Return to Main Menu"]
["Error Listing"]

{"sheet":"Admin Dec-Data","index":21,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Facility ID Info",null,null,"Administrator Declaration"]
[]
["State\nID","Facility Name","County","Administrator\nDeclaration\nCheck","Administrator\nDeclaration\nDate"]
[{"$f":"A_StateID","v":0},{"$f":"A_FacilityName","v":"-"},{"$f":"A_County","v":""},{"$f":"AD_AdminDec","v":"-"},{"$f":"IF(AD_AdDecDate = \"\", \"0\", AD_AdDecDate)","v":"0"}]

{"sheet":"Error","index":22,"n_rows":119,"n_cols":6,"rows_kept":119,"cut":false,"hidden":false,"merged":[[118,0,118,5],[112,0,112,5],[115,0,115,5],[117,0,117,5],[116,0,116,5],[114,0,114,5],[108,0,108,5],[109,0,109,5],[110,0,110,5],[111,0,111,5],[113,0,113,5]]}
["State \nID","Ok/\nError","Return to\nschedule","Error\nNumber","Error message","Please provide an explanation of why the data cannot be changed (why an error may remain) for all error messages that are marked \"Error\" Comments: "]
[{"$f":"A_StateID","v":0},{"$f":"'Sch A'!AL9","v":"Error"},"A_NameChangeYN","A-01-01","Did not answer the Yes/No Question concerning Name Change during reporting period."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch A'!AL14","v":"Error"},"A_StAddr","A-01-02","Provide complete address information (street, city, county, state, zip, phone)"]
[{"$f":"A_StateID","v":0},{"$f":"'Sch A'!AL23","v":"Error"},"A_RepPedYN","A-01-03","Did not answer the Yes/No Question concerning reporting period."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch A'!AL29","v":"Error"},"A_Admin","A-01-04","Provide names of both administrator and medical director."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch A'!AM9","v":"Error"},"A_NameChangeYN","A-02-01","If Yes is indicated for Name Change during reporting period, please provide the prior name."]
[0,{"$f":"'Sch A'!AM21","v":"Error"},"A_Preparer","A-02-02","Provide complete preparer information (name, title, phone, email)"]
[0,{"$f":"'Sch A'!AM26","v":"Error"},"A_BReportP","A-02-03","The ending date of the Reporting Period must be after the beginning date."]
[0,{"$f":"'Sch A'!AN15","v":"Error"},"A_MailAddYN","A-03-01","Did not answer the Yes/No Question concerning street and mailing address being the same."]
[0,{"$f":"'Sch A'!AN20","v":"Error"},"A_MailAddYN","A-03-02","Provide complete mailing address information (address, city, state, zip)"]
[0,{"$f":"'Sch B'!AL9","v":"Error"},"B_ProProp","B-01-01","Please indicate one and only one answer for the selection that best describes your situation concerning Type of Owner"]
[0,{"$f":"'Sch B'!AL21","v":"Error"},"B_OwnCHYN","B-01-02","Did not answer the Yes/No Question concerning Owner and Business Information Chain."]
[0,{"$f":"'Sch B'!AL25","v":"Error"},"B_OwnHCYN","B-01-03","Did not answer the Yes/No Question concerning Owner and Business Information Holding Company/Parent Corporation."]
[0,{"$f":"'Sch B'!AL29","v":"Error"},"B_OwnFirmYN","B-01-04","Did not answer the Yes/No Question concerning Owner and Business Information Contract with Management Firm."]
[0,{"$f":"'Sch B'!AM18","v":"Ok"},"B_GovOtherSpecify","B-02-01","Other Government, specify should be filled out if Other Government is checked."]
[0,{"$f":"'Sch B'!AM23","v":"Error"},"B_OwnCHName","B-02-02","Yes was indicated, provide complete Chain ownership information (name, street, city, state, zip)"]
[0,{"$f":"'Sch B'!AM27","v":"Error"},"B_OwnHCName","B-02-03","Yes was indicated, provide complete Holding Company/Parent Corporation ownership information (name, street, city, state, zip)"]
[0,{"$f":"'Sch B'!AM31","v":"Error"},"B_OwnFirmName","B-02-04","Yes was indicated, provide complete Contract with Management Firm ownership information (name, street, city, state, zip)"]
[0,{"$f":"'Sch C'!AL4","v":"Error"},"C_FAcConsYN","C-01-01","Did not answer the Yes/No Question concerning new construction."]
[0,{"$f":"'Sch C'!AL6","v":"Error"},"C_SerDayCYN","C-01-02","Did not answer the Yes/No Question concerning adult day care center."]
[0,{"$f":"'Sch C'!AL7","v":"Error"},"C_SerResCYN","C-01-03","Did not answer the Yes/No Question concerning respite care."]
[0,{"$f":"'Sch C'!AL8","v":"Error"},"C_SerAlzUYN","C-01-04","Did not answer the Yes/No Question concerning specialized unit for Alzheimer's residents."]
[0,{"$f":"'Sch C'!AL10","v":"Error"},"C_SerAlzPYN","C-01-05","Did not answer the Yes/No Question concerning specialized programs for Alzheimer's residents."]
[0,{"$f":"'Sch C'!AM5","v":"Error"},"C_FacConsSpec","C-02-01","Yes was indicated, provide cost of new construction."]
[0,{"$f":"'Sch C'!AM9","v":"Error"},"C_SerAlzUBed","C-02-02","Yes was indicated, provide number of beds in unit."]
[0,{"$f":"'Sch D'!AL5","v":"Error"},"D_LBedIYN","D-01-01","Did not answer the Yes/No Question concerning increase in number of licensed  beds."]
[0,{"$f":"'Sch D'!AL8","v":"Error"},"D_LBedDYN","D-01-02","Did not answer the Yes/No Question concerning decrease in number of licensed beds."]
[0,{"$f":"'Sch D'!AM4","v":"Error"},"D_LBedNum","D-02-01","Please indicate number of licensed beds on last day of reporting period."]
[0,{"$f":"'Sch D'!AM6","v":"Error"},"D_LBedIDat1","D-02-02","Yes was indicated, provide increase bed additional data for date & bed 1."]
[0,{"$f":"'Sch D'!AM7","v":"Error"},"D_LBedIDat2","D-02-03","Yes was indicated, provide increase bed additional data for date & bed 2."]
[0,{"$f":"'Sch D'!AM9","v":"Error"},"D_LBedDDat1","D-02-04","Yes was indicated, provide decrease bed additional data for date & bed 1."]
[0,{"$f":"'Sch D'!AM10","v":"Error"},"D_LBedDDat2","D-02-05","Yes was indicated, provide decrease bed additional data for date & bed 2."]
[0,{"$f":"'Sch D'!AM11","v":"Error"},"D_SBeds","D-02-06","Please indicate number of Staffed beds on last day of reporting period."]
[0,{"$f":"'Sch D'!AM12","v":"Error"},"D_BTypePri","D-02-07","Please indicate number of Private beds on last day of reporting period."]
[0,{"$f":"'Sch D'!AM13","v":"Error"},"D_BTypeSPri","D-02-08","Please indicate number of Semi-Private beds on last day of reporting period."]
[0,{"$f":"'Sch D'!AN11","v":"Ok"},"D_SBeds","D-03-01","Set up and staffed beds equal to the number of Private and Semi-Private beds."]
[0,{"$f":"'Sch E'!AL4","v":"Error"},"E_ADAdmin","E-01-01","Please indicate number of admissions."]
[0,{"$f":"'Sch E'!AL5","v":"Error"},"E_ADDisDea","E-01-02","Please indicate number of discharges including deaths."]
[0,{"$f":"'Sch E'!AL6","v":"Error"},"E_ADDeath","E-01-03","Please indicate number of deaths."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch E'!AL7","v":"Error"},"E_ADDisDay","E-01-04","Please indicate number of discharge days."]
[0,{"$f":"'Sch E'!AL9","v":"Error"},"E_TrTran","E-01-05","Please indicate number of residents transferred to a hospital."]
[0,{"$f":"'Sch E'!AL10","v":"Error"},"E_DisHos","E-01-06","Please indicate number of discharges to hospital."]
[0,{"$f":"'Sch E'!AL11","v":"Error"},"E_DisHom","E-01-07","Please indicate number of discharges to home."]
[0,{"$f":"'Sch E'!AL12","v":"Error"},"E_DisRes","E-01-08","Please indicate number of discharges to residential home for aged."]
[0,{"$f":"'Sch E'!AL13","v":"Error"},"E_DisNH","E-01-09","Please indicate number of discharges to nursing home."]
[0,{"$f":"'Sch E'!AL14","v":"Error"},"E_DisACLF","E-01-10","Please indicate number of discharges to other ACLF."]
[0,{"$f":"'Sch E'!AL15","v":"Error"},"E_DisOth","E-01-11","Please indicate number of other discharges."]
[0,{"$f":"'Sch E'!AL18","v":"Error"},"E_PTSelf","E-01-12","Please indicate number of Payer type Self-Pay."]
[0,{"$f":"'Sch E'!AL19","v":"Error"},"E_PTLTCI","E-01-13","Please indicate number of Payer type Long-Term Care Insurance."]
[0,{"$f":"'Sch E'!AL20","v":"Error"},"E_PTOth1","E-01-14","Please indicate number of Payer type Other 1."]
[0,{"$f":"'Sch E'!AL21","v":"Error"},"E_PTOth2","E-01-15","Please indicate number of Payer type Other 2."]
[0,{"$f":"'Sch E'!AM20","v":"Ok"},"E_PTOth1Spe","E-02-01","Other (1) Payer type was specified but additional data was not provided, or data was provided but Payer type was not specified."]
[0,{"$f":"'Sch E'!AM21","v":"Ok"},"E_PTOth2Spe","E-02-02","Other (2) Payer type was specified but additional data was not provided, or data was provided but Payer type was not specified."]
[0,{"$f":"'Sch E'!AN16","v":"Ok"},"E_ADDisDea","E-03-01","Discharges including deaths minus deaths is not equal to the total discharges section excluding deaths."]
[0,{"$f":"'Sch E'!AN80","v":"Ok"},"E_U60WM","E-03-02","Number of residents served by Age, Gender, & Race is not equal to the Total number of Tennessee residents & Total residents from other states and countries."]
[0,{"$f":"'Sch F'!AL21","v":"Ok"},"F_OT1Spec","F-01-01","Other (1) type of employee by service was specified but additional data was not provided, or data was provided but other type of employee by services was not specified."]
[0,{"$f":"'Sch F'!AL22","v":"Ok"},"F_OT2Spec","F-01-02","Other (2) type of employee by service was specified but additional data was not provided, or data was provided but other type of employee by services was not specified."]
[0,{"$f":"'Sch F'!AL23","v":"Ok"},"F_OT3Spec","F-01-03","Other (3) type of employee by service was specified but additional data was not provided, or data was provided but other type of employee by services was not specified."]
[0,{"$f":"'Sch F'!AL24","v":"Ok"},"F_OT4Spec","F-01-04","Other (4) type of employee by service was specified but additional data was not provided, or data was provided but other type of employee by services was not specified."]
[0,{"$f":"'Sch F'!AL39","v":"Error"},"F_401YN","F-01-05","Did not answer the Yes/No Question concerning Benefits 401 K Plan."]
[0,{"$f":"'Sch F'!AL40","v":"Error"},"F_RPYN","F-01-06","Did not answer the Yes/No Question concerning Benefits Retirement Plan."]
[0,{"$f":"'Sch F'!AL41","v":"Error"},"F_HIYN","F-01-07","Did not answer the Yes/No Question concerning Benefits Health Insurance."]
[0,{"$f":"'Sch F'!AL42","v":"Error"},"F_LIYN","F-01-08","Did not answer the Yes/No Question concerning Benefits Life Insurance."]
[0,{"$f":"'Sch F'!AL56","v":"Error"},"F_CNPYN","F-01-09","Did not answer the Yes/No Question concerning contract nursing personnel."]
[0,{"$f":"'Sch F'!AM36","v":"Error"},"F_3RND","F-02-01","Data not provided for 3 shift and/or 2 shift nursing patterns."]
[0,{"$f":"'Sch F'!AM56","v":"Error"},"F_CNPRNPer","F-02-02","Yes was indicated, provide contract nursing additional data."]
[0,{"$f":"'Sch H'!AL9","v":"Error"},"H_ADLB","H-01-01","Provide data for ADL's bathing, toileting, dressing, eating, & transferring."]
[0,{"$f":"'Sch H'!AL15","v":"Error"},"H_MADL1","H-01-02","Provide data for assistance with multiple ADL's (1 through 5)."]
[0,{"$f":"'Sch H'!AL22","v":"Error"},"H_IADLMM","H-01-03","Provide data for IADL's money management, shopping, preparing meals, using phones, doing light housework, & taking medication."]
[0,{"$f":"'Sch H'!AL28","v":"Error"},"H_IADL1","H-01-04","Provide data for assistance with Multiple IADL's (1 through 5)."]
[0,{"$f":"'Sch I'!AL6","v":"Error"},"I_ExpAdm","I-01-01","Provide data concerning Administration Expenses."]
[{"$f":"A_StateID","v":0},{"$f":"'Sch I'!AL7","v":"Error"},"I_ExpPay","I-01-02","Provide data concerning Payroll Expenses."]
[0,{"$f":"'Sch I'!AL8","v":"Error"},"I_ExpFB","I-01-03","Provide data concerning Fringe Benefits Expenses."]
[0,{"$f":"'Sch I'!AL9","v":"Error"},"I_ExpCPF","I-01-04","Provide data concerning Contract and Professional fees Expenses."]
[0,{"$f":"'Sch I'!AL10","v":"Error"},"I_ExpOOE","I-01-05","Provide data concerning Other Operating Expenses."]
[0,{"$f":"'Sch I'!AL11","v":"Error"},"I_ExpNOE","I-01-06","Provide data concerning Non-operating Expenses."]
[0,{"$f":"'Sch I'!AL13","v":"Error"},"I_Taxes","I-01-07","Provide data concerning Taxes."]
[0,{"$f":"'Sch I'!AL17","v":"Ok"},"I_CAOSP","I-01-08","Provide data concerning Other Capital Assets."]
[0,{"$f":"'Sch I'!AL22","v":"Ok"},"I_RCSPGRC","I-01-09","Self-Pay Gross Resident Charges should be greater than Adjustments. "]
[0,{"$f":"'Sch I'!AL23","v":"Ok"},"I_RCLTCIGRC","I-01-10","Long-Term Care Insurance Gross Resident Charges should be greater than Adjustments. "]
[0,{"$f":"'Sch I'!AL24","v":"Ok"},"I_RCOthGRC","I-01-11","Other Gross Resident Charges should be greater than Adjustments. "]
[0,{"$f":"'Sch I'!AL25","v":"Error"},"I_OthRev","I-01-12","Provide data concerning Other Revenue."]
[0,{"$f":"'Sch I'!AL27","v":"Error"},"I_DACBad","I-01-13","Provide data concerning Bad Debt."]
[0,{"$f":"'Sch I'!AL28","v":"Error"},"I_DACCha","I-01-14","Provide data concerning Charity Care."]
[0,{"$f":"'Sch I'!AL29","v":"Error"},"I_DACNGC","I-01-15","Provide data concerning Non-Government Contractual."]
[0,{"$f":"'Sch I'!AL30","v":"Error"},"I_DACOth","I-01-16","Provide data concerning Other detail of adjustments to charges."]
[0,{"$f":"'Sch I'!AM6","v":"Error"},"I_CABOL","I-02-01","Did not answer building question conerning own or lease building."]
[0,{"$f":"'Sch I'!AM10","v":"Error"},"I_CABCO","I-02-02","Provide Cost data concerning Building."]
[0,{"$f":"'Sch I'!AM10","v":"Error"},"I_CAECO","I-02-03","Provide Cost data concerning Equipment."]
[0,{"$f":"'Sch I'!AM12","v":"Ok"},"I_CABAN","I-02-04","Provide Cost data concerning All Other."]
[0,{"$f":"'Sch I'!AM16","v":"Error"},"I_CABEDAN","I-02-05","Provide Annual Depreciation data concerning Building."]
[0,{"$f":"'Sch I'!AM17","v":"Error"},"I_CAEAN","I-02-06","Provide Annual Depreciation data concerning Equipment."]
[0,{"$f":"'Sch I'!AM18","v":"Ok"},"I_CAALDAN","I-02-07","Provide Annual Depreciation data concerning All Other."]
[0,{"$f":"'Sch I'!AM23","v":"Error"},"I_RCSPGRC","I-02-08","Provide Gross Resident charges data for Self-Pay."]
[0,{"$f":"'Sch I'!AM24","v":"Error"},"I_RCLTCIGRC","I-02-09","Provide Gross Resident charges data for Long-Term Care Insurance."]
[0,{"$f":"'Sch I'!AM25","v":"Error"},"I_RCOthGRC","I-02-10","Provide Gross Resident charges data for Other."]
[0,{"$f":"'Sch I'!AN6","v":"Error"},"I_CAEOL","I-03-01","Did not answer equipment question concerning own or lease equipment."]
[0,{"$f":"'Sch I'!AN10","v":"Error"},"I_CABMV","I-03-02","Provide Market Value data concerning Building."]
[0,{"$f":"'Sch I'!AN11","v":"Error"},"I_CAEMV","I-03-03","Provide Market Value data concerning Equipment."]
[0,{"$f":"'Sch I'!AN12","v":"Ok"},"I_CAOMV","I-03-04","Provide Market Value data concerning All Other."]
[0,{"$f":"'Sch I'!AN16","v":"Error"},"I_CABAC","I-03-05","Provide Accumulated Depreciation concerning Building."]
[0,{"$f":"'Sch I'!AN17","v":"Error"},"I_CAEAC","I-03-06","Provide Accumulated Depreciation concerning Equipment."]
[0,{"$f":"'Sch I'!AN18","v":"Ok"},"I_CAOAC","I-03-07","Provide Accumulated Depreciation Concerning All Other."]
[0,{"$f":"'Sch I'!AN23","v":"Error"},"I_RCSPAC","I-03-08","Provide Adjustment to Charges data for Self-Pay."]
[0,{"$f":"'Sch I'!AN24","v":"Error"},"I_RCLTCIAC","I-03-09","Provide Adjustment to Charges data for Long-Term Care Insurance."]
[0,{"$f":"'Sch I'!AN25","v":"Error"},"I_RCOthAC","I-03-10","Provide Adjustment to Charges data for Other."]
[0,{"$f":"'Admin Dec'!AL6","v":"Error"},"AD_AdminDec","Admin Dec-01-01","Administrator's Declaration was not marked."]
[0,{"$f":"'Admin Dec'!AM7","v":"Error"},"AD_AdDecDate","Admin Dec-02-01","Administrator's Declaration was not dated."]
["Return to Main Menu"]
["Return to Schedule A"]
["Return to Schedule B"]
["Return to Schedule C"]
["Return to Schedule D"]
["Return to Schedule E"]
["Return to Schedule F"]
["Return to Schedule G"]
["Return to Schedule H"]
["Return to Schedule I"]
["Return to Schedule Admin Dec"]

{"sheet":"Info","index":23,"n_rows":98,"n_cols":2,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
["County_List","State_IDS"]
["Anderson","TN"]
["Bedford","AL"]
["Benton","AK"]
["Bledsoe","AZ"]
["Blount","AR"]
["Bradley","CA"]
["Campbell","CO"]
["Cannon","CT"]
["Carroll","DE"]
["Carter","DC"]
["Cheatham","FL"]
["Chester","GA"]
["Claiborne","HI"]
["Clay","ID"]
["Cocke","IL"]
["Coffee","IN"]
["Crockett","IA"]
["Cumberland","KS"]
["Davidson","KY"]
["Decatur","LA"]
["DeKalb","ME"]
["Dickson","MD"]
["Dyer","MA"]
["Fayette","MI"]
["Fentress","MN"]
["Franklin","MS"]
["Gibson","MO"]
["Giles","MT"]
["Grainger","NE"]
["Greene","NV"]
["Grundy","NH"]
["Hamblen","NJ"]
["Hamilton","NM"]
["Hancock","NY"]
["Hardeman","NC"]
["Hardin","ND"]
["Hawkins","OH"]
["Haywood","OK"]
["Henderson","OR"]
["Henry","PA"]
["Hickman","RI"]
["Houston","SC"]
["Humphreys","SD"]
["Jackson","TX"]
["Jefferson","UT"]
["Johnson","VT"]
["Knox","VA"]
["Lake","WA"]
["Lauderdale","WV"]
["Lawrence","WI"]
["Lewis","WY"]
["Lincoln"]
["Loudon"]
["McMinn"]
["McNairy"]
["Macon"]
["Macison"]
["Marion"]
["Marshall"]
["Maury"]
["Meigs"]
["Monroe"]
["Montgomery"]
["Moore"]
["Morgan"]
["Obion"]
["Overton"]
["Perry"]
["Pickett"]
["Polk"]
["Putnam"]
["Rhea"]
["Roane"]
["Robertson"]
["Rutherford"]
["Scott"]
["Sequatchie"]
["Sevier"]
["Shelby"]
["Smith"]
["Stewart"]
["Sullivan"]
["Sumner"]
["Tipton"]
["Trousdale"]
["Unicoi"]
["Union"]
["VanBuren"]
["Warren"]
["Washington"]
["Wayne"]
["Weakley"]
["White"]
["Williamson"]
["Wilson"]
["Out-of-State"]
["Unknown"]

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