{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["JumpStartInputTool","Master","Provenance"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"JumpStartInputTool","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,3],[16,1,16,3],[1,2,2,2]]}
[null,"Department of Behavioral Health and Developmental Services"]
[null,"Division of Developmental Services"]
[null,"JumpStart Calculator",null,null,null,"crisis support services",1]
[null,null,null,null,null,"private duty nursing",1]
[null,"Select City or County","Shenandoah County",null,null,"skilled nursing",1]
[null,null,null,null,null,"sponsored residential",1]
[null,"Select Service","Community Engagement",{"$f":"IFERROR(VLOOKUP(C7,F3:G6,2,0),\"\")","v":""}]
[]
[null,"Waiver Enrollees (All waivers)",{"$f":"IF(C5=\"\",\"Please Select a City/County\",CONCATENATE(VLOOKUP(C5,Master!A:B,2,0),\" individual(s) were enrolled on a waiver in \",C5, \" as of \", \"June 1, 2018.\"))","v":"102 individual(s) were enrolled on a waiver in Shenandoah County as of June 1, 2018."}]
[]
[null,"Building Independence Waiver",{"$f":"IF(C5=\"\",\"Please Select a City/County\",CONCATENATE(VLOOKUP(C5,Master!A:C,3,0),\" individual(s) are enrolled on a BI waiver in \",C5, \" as of June 1, 2018.\"))","v":"5 individual(s) are enrolled on a BI waiver in Shenandoah County as of June 1, 2018."}]
[]
[null,"Total Providers of Selected Service in Selected City/County",{"$f":"IF(OR(C5=\"\",C7=\"\"),\"Please Select Both a City/County and a Service\",INDEX(Master!B2:R134,MATCH(JumpStartInputTool!C5,CityCounty,1),MATCH(JumpStartInputTool!C7,Master!B1:R1,0)))","v":3}]
[null,null,{"$f":"IF(D7=1,\"Not Eligible\",IF(OR(C5=\"\",C7=\"\"),\"Please Select Both a City/County and a Service\",INDEX(Master!B2:R134,MATCH(JumpStartInputTool!C5,CityCounty,1),MATCH(JumpStartInputTool!C7,Master!B1:R1,0))))","v":3}]
[null,"Recommendations for JumpStart Application:"]
[null,{"$f":"IF(C14=\"Not Eligible\",\"This service is not eligible for JumpStart Funding.\",\"\")","v":""}]
[null,"Providers are insufficient in this area. Applications will be considered."]
[null,"There are sufficient providers in this area. You may: (1) Proceed with submission knowing that an increased amount of justification will be necessary, or (2) select a different City/County and/or Service."]

{"sheet":"Master","index":1,"n_rows":152,"n_cols":18,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
[" City/County","All waivers total","BI waiver total","Benefits Planning","Community Coaching","Community Engagement","Community Guide","Electronic Home-Based Services","Employment and Community Transportation","Independent Living Supports","In-home Supports","Peer Mentoring","Shared Living","Supported Living","Crisis Support Services","Private Duty Nursing","Skilled Nursing","Sponsored Residential"]
["Accomack County",65,0,0,0,1,0,0,0,0,1,0,0,1,0,0,0,1]
["Albemarle County",112,1,0,2,3,0,0,0,0,3,0,0,0,0,1,3,3]
["Alexandria City",94,4,0,0,1,0,0,0,0,1,0,0,1,0,2,2,0]
["Alleghany County",48,1,0,1,1,0,0,0,0,2,0,0,0,0,0,0,0]
["Amelia County",12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Amherst County",147,0,0,0,2,0,0,0,0,0,0,0,0,0,0,1,2]
["Appomattox County",35,1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,1]
["Arlington County",137,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Augusta County",148,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,2]
["Bath County",8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bedford County",174,1,0,1,4,0,0,0,0,2,0,0,0,0,0,1,6]
["Bland County",12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Botetourt County",45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0]
["Bristol City",40,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
["Brunswick County",35,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Buchanan County",34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Buckingham County",16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Buena Vista City",7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Campbell County",147,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Caroline County",46,2,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Carroll County",156,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
["Charles City County",6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Charlotte County",34,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Charlottesville City",90,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Chesapeake City",328,8,0,3,5,0,0,0,0,3,0,0,0,0,5,2,4]
["Chesterfield County",965,21,0,2,11,0,0,0,0,4,0,0,2,1,4,5,4]
["Clarke County",14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Colonial Heights City",16,1,0,0,1,0,0,0,0,2,0,0,0,0,0,0,1]
["Covington City",11,0,0,1,1,0,0,0,0,1,0,0,0,0,0,1,0]
["Craig County",7,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
["Culpeper County",85,0,0,1,2,0,0,0,0,0,0,0,0,0,0,1,0]
["Cumberland County",29,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Danville City",163,7,0,1,3,0,0,0,0,7,0,0,1,0,1,2,2]
["Dickenson County",27,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Dinwiddie County",68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Emporia City",5,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0]
["Essex County",17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fairfax City",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fairfax County",1071,18,0,5,8,0,0,0,1,12,0,0,2,3,30,21,1]
["Falls Church City",2,0,0,0,0,0,0,0,0,0,0,0,0,0,2,1,0]
["Fauquier County",74,0,0,0,0,0,0,0,0,1,0,0,0,0,1,2,0]
["Floyd County",54,0,0,2,2,0,0,0,0,2,0,0,0,0,1,1,1]
["Fluvanna County",19,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Franklin City",26,0,0,1,2,0,0,0,0,1,0,0,0,0,2,2,1]
["Franklin County",106,6,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Frederick County",136,3,0,1,2,0,0,0,0,1,0,0,0,0,0,2,1]
["Fredericksburg City",49,0,0,1,1,0,0,0,0,1,0,0,1,0,3,0,2]
["Galax City",29,0,0,2,1,0,0,0,0,1,0,0,0,0,0,0,3]
["Giles County",35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gloucester County",80,0,0,1,1,0,0,0,0,1,0,0,0,0,3,2,0]
["Goochland County",26,1,0,0,1,0,0,0,0,1,0,0,0,0,0,0,1]
["Grayson County",34,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Greene County",22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Greensville County",11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Halifax County",76,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Hampton City",270,10,0,2,5,0,0,0,0,4,0,0,1,1,2,2,5]
["Hanover County",211,15,0,0,4,0,0,0,0,1,0,0,1,0,2,1,0]
["Harrisonburg City",72,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Henrico County",580,16,0,4,9,0,0,0,2,7,0,0,3,0,2,2,4]
["Henry County",83,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Highland County",5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hopewell City",27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Isle of Wight County",26,2,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0]
["James City County",41,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
["King and Queen County",6,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["King George County",24,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["King William County",25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lancaster County",7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lee County",32,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lexington City",4,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Loudoun County",218,6,0,0,1,0,0,0,0,1,0,0,0,0,5,0,0]
["Louisa County",38,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lunenburg County",9,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lynchburg City",215,1,0,0,4,0,0,0,1,3,0,0,0,0,0,1,8]
["Madison County",12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
["Manassas City",20,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Manassas Park City",4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Martinsville City",41,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0]
["Mathews County",43,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Mecklenburg County",90,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1]
["Middlesex County",24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Montgomery County",102,0,0,1,3,0,0,0,0,4,0,0,0,1,2,2,2]
["Nelson County",32,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0]
["New Kent County",30,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0]
["Newport News City",221,16,0,1,4,0,0,0,1,8,0,0,0,0,5,8,7]
["Norfolk City",389,21,0,1,4,0,0,0,1,7,0,0,0,0,1,1,2]
["Northampton County",47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Northumberland County",7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Norton City",5,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Nottoway County",16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Orange County",54,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,0]
["Page County",24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Patrick County",31,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0]
["Petersburg City",135,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,2]
["Pittsylvania County",162,7,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0]
["Poquoson City",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Portsmouth City",274,3,0,2,5,0,0,0,1,4,0,0,0,0,0,2,3]
["Powhatan County",27,1,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0]
["Prince Edward County",77,0,0,0,2,0,0,0,0,3,0,0,0,0,0,0,0]
["Prince George County",53,0,0,0,1,0,0,0,0,2,0,0,0,0,1,2,0]
["Prince William County",424,10,0,2,3,0,0,0,0,5,0,0,0,2,12,11,1]
["Pulaski County",54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Radford City",22,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,1]
["Rappahannock County",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Richmond City",322,10,0,2,2,0,0,0,0,2,0,0,0,1,3,3,1]
["Richmond County",50,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Roanoke City",148,7,0,0,3,0,0,0,1,0,0,0,0,0,0,1,3]
["Roanoke County",211,4,0,1,3,0,0,0,1,3,0,0,0,0,1,2,3]
["Rockbridge County",59,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rockingham County",137,4,0,2,3,0,0,0,1,3,0,0,1,0,0,1,2]
["Russell County",62,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Salem City",25,0,0,1,2,0,0,0,0,2,0,0,0,1,1,3,0]
["Scott County",66,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Shenandoah County",102,5,0,2,3,0,0,0,0,0,0,0,0,0,0,0,1]
["Smyth County",78,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1]
["Southampton County",17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Spotsylvania County",229,3,0,0,4,0,0,0,0,0,0,0,0,0,0,1,1]
["Stafford County",220,6,0,1,1,0,0,0,0,1,0,0,0,0,1,1,0]
["Staunton City",63,0,0,1,2,0,0,0,0,2,0,0,0,0,0,0,2]
["Suffolk City",157,0,0,3,3,0,0,0,0,3,0,0,0,0,1,1,1]
["Surry County",2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sussex County",34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tazewell County",74,1,0,0,1,0,0,0,0,1,0,0,0,0,2,2,0]
["Virginia Beach City",773,13,0,2,6,0,0,0,2,12,0,0,2,0,7,10,6]
["Warren County",34,1,0,1,1,0,0,0,0,1,0,0,0,0,0,0,0]
["Washington County",91,1,0,0,2,0,0,0,0,0,0,0,0,0,2,2,1]
["Waynesboro City",75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
["Westmoreland County",16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Williamsburg City",14,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,1]
["Winchester City",94,1,0,2,3,0,0,0,0,0,0,0,1,0,0,1,0]
["Wise County",93,0,0,0,5,0,0,0,0,1,0,0,0,0,1,1,1]
["Wythe County",68,0,0,1,1,0,0,0,0,0,0,0,1,0,1,1,1]
["York County",44,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0]
[]
[]
[]
["Benefits Planning"]
["Community Coaching"]
["Community Engagement"]
["Community Guide"]
["Electronic Home-Based Services"]
["Employment and Community Transportation"]
["Independent Living Supports"]
["In-home Supports"]
["Peer Mentoring"]
["Shared Living"]
["Supported Living"]
["Crisis Support Services"]
["Private Duty Nursing"]
["Skilled Nursing"]
["Sponsored Residential"]

{"sheet":"Provenance","index":2,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Provenance"]
[null,"T1091"]
[]
[null,null,"What","Who","Date"]
[null,null,"Original","ew","2018-05-31"]
[null,null,"Received file 'Provider Data Summary Gap Chart 5.31.18 for OISS.xlsx' from Eric in email 6/1 8:48 am","kh","2018-06-01"]
[null,null,"Copied to 'Provider Data Summary Gap Chart20180601.xlsx' (this file)","kh","2018-06-01"]
[null,null,"Generated new columns 2 and 3 using Eric's data for # on Waiver, via Text to Columns","kh","2018-06-01"]
[null,null,"Charlottesville=0 Waivers is inaccurate, attribute to manual copy-paste, so replaced waiver counts:\n   EricW 6/1 said to only include Active on Waiver.  So that's what I did.  Looked up by County Pivot from C_Wide20180601","kh","2018-06-01"]
[null,null,"Removed fill and replaced with automatic Conditional Formatting (same result)","kh","2018-06-01"]
[null,null,"Filled unique Pid counts from T1054integrated1 20180510 SOS Maps.xlsb Pivot Sheet","kh","2018-06-01"]
[null,12946,"C_Wide20180601 Active","kh","2018-06-01"]
[null,12917,"    Master Active (shy 29 no C.County)","kh","2018-06-01"]
[null,267,"C_Wide20180601 Active AND BI (no missing C.County here)","kh","2018-06-01"]
[]
[null,"T1104 6/13/2018:",null,"kh"]
[null,null,"EricW requests to change the #People from SA-restricted to ALL #People Active,Hold as of the same date (20180510-1), and the calculator On Waiver to agree."]
[null,null,"Calculator on Waiver was 12,917.  Now EricW wants #people Active,Hold (not from SAL as before)."]
[null,null,"So we agreed to change both the map #People and the Calculator col 2, 3 #Waiver(now Active+Hold), #BI(Active+Hold)."]
[null,12956,"C_Wide20180510.Status=Active,Hold"]
[null,12922,"C_Wide20180510.Status=Active,Hold AND C.County<>'Other'"]
[null,12922,null,"This differs from 12917, because we used Provider Service location from the SA/SALs for the 12917 (it's amazing the 2 #s are so close!)."]
[null,12922,"Pivot (tabular, all items).  Pivot2 for BI (Col 3 below)"]
[null,null,null,"Had to pay special attention to Bedford (174)."]
[null,12922,"Copy to PersonsWaiverActiveHold20180510.csv for Maps"]
[null,12922,null,"Changed Col 2,3 (Waiver total by CntyCity) of the JumpStart Calculator to agree:  it is called 'NewProvider Data Summary Gap Chart20180601_withJumpStartCalc20180613.xlsm'"]
[null,"end"]
[]
[null,"T1106 6/14/2018:",null,"kh"]
[null,null,"EricW requests to change from ProviderId to TaxIdentifier (Salem City had 8 Community Engagement providers, really has only 2 -- this is what fixes this)."]
[null,null,null,"Change Provider data in both Maps and Calculator. (Should reduce # providers by more than half?)"]
[null,null,"vloookup TaxIdentifier from P20180510 to JumpStartProvs sheet here"]
[null,null,null,"Repivot based on TaxIDentifier rather than ProviderId!"]
[null,"1019 -> 739",null,"To 'NewerProvider Data Summary Gap Chart20180601_withJumpStartCalc20180614.xlsm'"]
[null,null,"completely changed method of getting Providers (Key, S.Name, Lat, Lon) for the maps:"]
[null,null,null,"vlooked up S.Zip5.Lat,Lon from P20180510 to sheet JumpStartProvs here"]
[null,null,null,"Pivot2 (merely gets unique list of same 739 as for Calculator)"]
[null,"1009 -> 739",null,"To 'NewerProvidersServicesLatLon20180510.csv'"]
[null,null,null,"vlookup Lat, Lon by TaxIdentifier from JumpStartProvs S.Zip5.Lat,Lon"]
[null,null,"(note: 1019 and 1009 should have been the same - this has been corrected by using a better parallel method this time)"]
[null,null,"Remake map main file:  now 'NewerIntegratedServices20180510.xlsx'"]
[null,"end"]