{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Welcome","1. Agency Profile","2. Key Data Input","3. Plan Information","Plan Report ","CENTRAL DATA","FILE MAINTENANCE","CENTRAL ANALYSIS","DATA EXPORT FOR NEXT FY","PRIOR DATA","DASHBOARD DATA EXPORT"],"not_rendered":{"charts":7,"images":123,"macros":1,"external_links":1,"defined_names":3,"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":"Welcome","index":0,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,3,35,5],[2,11,3,25],[5,11,7,25],[9,11,20,25],[22,0,25,9],[26,2,27,7],[22,11,24,14],[22,15,24,21],[22,22,24,25],[36,11,38,14],[36,15,38,21],[36,22,38,25],[26,11,28,14],[26,15,28,21],[26,22,28,25],[32,11,34,14],[32,15,34,21],[32,22,34,25],[29,11,31,14],[29,15,31,21],[29,22,31,25]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Purpose"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"§ 2.2-203.2:3. Policy of the Commonwealth Regarding the Employment of Individuals with Disabilities;                           Responsibilities of State Agencies; Report:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"It shall be the policy of the Commonwealth to promote and increase the employment of individuals with disabilities directly employed at all levels and occupations by state agencies, institutions, boards, and authorities of the Commonwealth. \n\nTo assist in achieving this policy, it shall be the goal of the Commonwealth to increase by five percent the level of employment of individuals with disabilities by state by fiscal year 2023. The secretary shall coordinate and lead efforts to achieve the goals of the Commonwealth established by this section. \n\nThe purpose of this tool is to guide state agencies and institutions through the Employee Opportunities Plan report using a consistent format; to better identify opportunities for the employment of individuals with disabilities. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Employment Opportunities Plan -                           Individuals with Disabilities",null,null,null,null,null,null,null,null,null,null,"Review First                             Instructions & Help",null,null,null,"Provides information on how to complete this report, calculate data input values, and other helpful information. It is recommended agencies review this prior to completing this report. ",null,null,null,null,null,null,"Written Instructions"]
[]
[]
[]
[null,null,"Report Guide and Generator Tool",null,null,null,null,null,null,null,null,"Section 1: Agency Profile",null,null,null,"Provides information regarding agency name, type, summary of efforts for individuals with disabilities, and current practices of the agency. ",null,null,null,null,null,null,"View / Update Section"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Section 2: Key Data Input",null,null,null,"Provides information regarding facts and figures, hiring and separations breakdown, and other data driven metrics.",null,null,null,null,null,null,"View / Update Section"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Section 3: Plan Information",null,null,null,"Provides agency an opportunity to outline action efforts to increase employment of individuals with disabilities. ",null,null,null,null,null,null,"View / Update Section"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Full Report",null,null,null,"The compiled report of all information entered into each section above to be printed, signed, and submitted to DHRM. ",null,null,null,null,null,null,"View / Update Section"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2020.2"]

{"sheet":"1. Agency Profile","index":1,"n_rows":80,"n_cols":38,"rows_kept":80,"cut":false,"hidden":false,"merged":[[2,7,4,26],[5,7,6,26],[9,0,9,3],[9,6,9,12],[9,14,9,20],[9,22,9,25],[20,0,23,3],[14,25,15,25],[15,6,15,12],[11,0,12,3],[11,4,11,5],[11,6,11,12],[11,22,13,25],[13,4,13,5],[13,6,13,12],[14,1,14,2],[14,6,14,12],[14,22,15,22],[14,23,15,23],[14,24,15,24],[38,6,38,24],[19,5,19,25],[21,5,32,25],[25,1,25,2],[36,5,36,25],[16,6,16,8],[16,9,16,12],[16,14,16,20],[40,20,42,25],[39,5,39,9],[39,10,39,19],[39,20,39,25],[39,0,44,3],[47,5,47,9],[43,10,45,25],[43,5,45,9],[40,5,42,9],[40,18,42,19],[40,16,42,17],[40,14,42,15],[40,12,42,13],[40,10,42,11],[47,10,47,12],[47,13,47,25],[66,5,68,9],[66,10,68,10],[66,11,68,11],[66,12,68,12],[66,13,68,25],[55,6,55,24],[48,5,50,9],[51,5,53,9],[48,10,50,10],[48,11,50,11],[48,12,50,12],[60,12,62,12],[60,13,62,25],[56,10,56,12],[56,13,56,25],[48,13,50,25],[51,10,53,10],[51,11,53,11],[51,12,53,12],[51,13,53,25],[46,1,46,2],[78,5,80,9],[73,6,73,24],[74,5,74,9],[69,5,71,9],[56,5,56,9],[75,5,77,9],[78,10,80,10],[78,11,80,11],[78,12,80,12],[78,13,80,25],[60,5,62,9],[57,5,59,9],[57,10,59,10],[57,11,59,11],[57,12,59,12],[57,13,59,25],[60,10,62,10],[63,5,65,9],[63,10,65,10],[63,11,65,11],[63,12,65,12],[63,13,65,25],[60,11,62,11],[0,21,1,26],[0,16,1,20],[0,11,1,15],[0,6,1,10],[0,0,1,5],[66,26,68,26],[69,26,71,26],[75,26,77,26],[78,26,80,26],[48,26,50,26],[51,26,53,26],[57,26,59,26],[60,26,62,26],[63,26,65,26],[69,10,71,10],[69,11,71,11],[69,12,71,12],[69,13,71,25],[75,10,77,10],[75,11,77,11],[75,12,77,12],[75,13,77,25],[74,10,74,12],[74,13,74,25]]}
["Welcome Tab",null,null,null,null,null,"Agency Profile",null,null,null,null,"Key Data",null,null,null,null,"Plan Information",null,null,null,null,"Plan Report"]
[]
[null,null,null,null,null,null,null,"Employment Opportunities Plan Report Guide"]
[]
[]
[null,null,null,null,null,null,null,"Section 1: Agency Profile"]
[]
[]
[]
["Instructions",null,null,null,null,null,"General Information",null,null,null,null,null,null,null,"Agency Logo",null,null,null,null,null,null,null,"Prior Year Data Passcode"]
[]
["Step 1: Select Agency Name from Dropdown Menu",null,null,null,"Agency Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To view the prior years' data, please enter the 4 digit agency passcode.                                **Assigned by DHRM**"]
[]
[null,null,null,null,"Agency Type:",null,{"$f":"IF($G$12=\"\",\"\",VLOOKUP($G$12,'CENTRAL DATA'!$A:$E,3,FALSE))","v":""}]
["Status:",{"$f":"IF(G12<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},null,null,null,null,{"$f":"IF($G$12=\"\",\"\",VLOOKUP($G$12,'CENTRAL DATA'!$A:$E,4,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(W15,X15,Y15,Z15)","v":""},{"$f":"IF(VLOOKUP($G$12,Table1[[Agency Name]:[FY19 Passcode (Must contain at least 1 letter)]],6,FALSE)='1. Agency Profile'!AE15,1,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"IF($G$12=\"\",\"\",VLOOKUP($G$12,'CENTRAL DATA'!$A:$E,5,FALSE))","v":""}]
[null,null,null,null,null,null,"**Agency type taken from",null,null,"https://www.virginia.gov/agencies/",null,null,null,null,"**Contact DHRM for updating Agency logo if necessary."]
[]
[]
[null,null,null,null,null,"Brief Summary of Efforts to Improve Employment of Individuals with Disabilities"]
["Step 2: Enter a brief summary of efforts to improve Employment of Individuals with Disabilities"]
[]
[]
[]
[]
["Status:",{"$f":"IF(F22<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Agency Practices Regarding Employment of Individuals with Disabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete",{"$f":"SUM(AF43,AF50:AI50,AF53:AI53,AF59:AI59,AF62:AI62,AF65:AI65,AF68:AI68,AF71:AI71,AF77:AI77,AF80:AI80)","v":0}]
[]
[null,null,null,null,null,null,"Recruitment Strategies"]
["Step 3: Indicate if the Agency utilizes the following practices or strategies by clicking on the checkboxes for the respective response. For practices the agency implements, please provide a brief description. ",null,null,null,null,"Practice",null,null,null,null,"Types of Outreach Efforts",null,null,null,null,null,null,null,null,null,"If Other, please specify. ",null,null,null,null,null,null,null,null,null,null,"Job Fair","Partnership","Internal Talent","Conference","Other","Other Filled"]
[null,null,null,null,null,"Types of Outreach Efforts Agency Utilizes to recruit Individuals with Disabilities (Select all that Apply)",null,null,null,null,"Job / Career Fairs",null,"Partnerships with Other Organizations",null,"Internal Talent",null,"Conferences",null,"Other",null,null,null,null,null,null,null,null,null,null,null,"Used",false,false,false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF41=TRUE,1,0)","v":0},{"$f":"IF(AG41=TRUE,1,0)","v":0},0,0,0,{"$f":"IF(AND(AJ42=1,U41<>\"\"),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,null,null,null,null,null,null,null,null,null,"Description",{"$f":"IF(K44<>\"\",1,0)","v":0}]
[null,null,null,null,null,"Description and Impacts from Outreach Efforts:"]
[]
[]
["Status:",{"$f":"IF(AF37=19,\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,null,"Practice",null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10,\" Update\")","v":"FY 2021 Update"},null,null,"Brief Description Practice, Changes, or Updates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continued","Started","Not Used","Not Used Description",null,null,"Error"]
[null,null,null,null,null,"Provides disability-friendly job postings and interviews",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F49","v":"Provides disability-friendly job postings and interviews"},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF49=TRUE,1,0)","v":0},{"$f":"IF(AG49=TRUE,1,0)","v":0},0,{"$f":"IF(AND(OR(AF50=1,AG50=1),N49<>\"\"),1,IF(AH50=1,1,0))","v":0},null,null,{"$f":"SUM(AF50:AH50)","v":0}]
[]
[null,null,null,null,null,"Hosts career fairs dedicated to people with disabilities",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F52","v":"Hosts career fairs dedicated to people with disabilities"},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF52=TRUE,1,0)","v":0},{"$f":"IF(AG52=TRUE,1,0)","v":0},0,{"$f":"IF(AND(OR(AF53=1,AG53=1),N52<>\"\"),1,IF(AH53=1,1,0))","v":0},null,null,{"$f":"SUM(AF53:AH53)","v":0}]
[]
[]
[null,null,null,null,null,null,"Accommodation Strategies"]
[null,null,null,null,null,"Practice",null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10,\" Update\")","v":"FY 2021 Update"},null,null,"Brief Description Practice, Changes, or Updates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continued","Started","Not Used","Not Used Description"]
[null,null,null,null,null,"Facilitates a disability-friendly workplace culture. ",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F58","v":"Facilitates a disability-friendly workplace culture. "},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF58=TRUE,1,0)","v":0},{"$f":"IF(AG58=TRUE,1,0)","v":0},{"$f":"IF(AH58=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF59=1,AG59=1),N58<>\"\"),1,IF(AH59=1,1,0))","v":0},null,null,{"$f":"SUM(AF59:AH59)","v":0}]
[]
[null,null,null,null,null,"Evaluates facility and workplace accessibility. ",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F61","v":"Evaluates facility and workplace accessibility. "},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF61=TRUE,1,0)","v":0},0,{"$f":"IF(AH61=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF62=1,AG62=1),N61<>\"\"),1,IF(AH62=1,1,0))","v":0},null,null,{"$f":"SUM(AF62:AH62)","v":0}]
[]
[null,null,null,null,null,"Evaluates website and digital accessibility. ",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F64","v":"Evaluates website and digital accessibility. "},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF64=TRUE,1,0)","v":0},{"$f":"IF(AG64=TRUE,1,0)","v":0},{"$f":"IF(AH64=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF65=1,AG65=1),N64<>\"\"),1,IF(AH65=1,1,0))","v":0},null,null,{"$f":"SUM(AF65:AH65)","v":0}]
[]
[null,null,null,null,null,"Facilitates training for leaders regarding employment of individuals with disabilities. ",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F67","v":"Facilitates training for leaders regarding employment of individuals with disabilities. "},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF67=TRUE,1,0)","v":0},{"$f":"IF(AG67=TRUE,1,0)","v":0},{"$f":"IF(AH67=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF68=1,AG68=1),N67<>\"\"),1,IF(AH68=1,1,0))","v":0},null,null,{"$f":"SUM(AF68:AH68)","v":0}]
[]
[null,null,null,null,null,"Promote interactive discussions with candidates and employees regarding accommodation needs.",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F70","v":"Promote interactive discussions with candidates and employees regarding accommodation needs."},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF70=TRUE,1,0)","v":0},{"$f":"IF(AG70=TRUE,1,0)","v":0},{"$f":"IF(AH70=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF71=1,AG71=1),N70<>\"\"),1,IF(AH71=1,1,0))","v":0},null,null,{"$f":"SUM(AF71:AH71)","v":0}]
[]
[]
[null,null,null,null,null,null,"Retention, Advancement, and Development Strategies"]
[null,null,null,null,null,"Practice",null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10,\" Update\")","v":"FY 2021 Update"},null,null,"Brief Description Practice, Changes, or Updates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continued","Started","Not Used","Not Used Description"]
[null,null,null,null,null,"Has a workplace mentoring program for employees with disabilities. ",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F76","v":"Has a workplace mentoring program for employees with disabilities. "},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF76=TRUE,1,0)","v":0},{"$f":"IF(AG76=TRUE,1,0)","v":0},{"$f":"IF(AH76=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF77=1,AG77=1),N76<>\"\"),1,IF(AH77=1,1,0))","v":0},null,null,{"$f":"SUM(AF77:AH77)","v":0}]
[]
[null,null,null,null,null,"Provides job shadowing opportunities for employees with disabilities. ",null,null,null,null,"Continued","Started","Not Used",null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR: Select Only One",null,null,null,{"$f":"F79","v":"Provides job shadowing opportunities for employees with disabilities. "},false,false,false]
[null,null,null,null,null,null,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",{"$f":"IF(AF79=TRUE,1,0)","v":0},{"$f":"IF(AG79=TRUE,1,0)","v":0},{"$f":"IF(AH79=TRUE,1,0)","v":0},{"$f":"IF(AND(OR(AF80=1,AG80=1),N79<>\"\"),1,IF(AH80=1,1,0))","v":0},null,null,{"$f":"SUM(AF80:AH80)","v":0}]

{"sheet":"2. Key Data Input","index":2,"n_rows":253,"n_cols":34,"rows_kept":253,"cut":false,"hidden":false,"merged":[[228,1,228,2],[119,0,122,3],[124,1,124,2],[190,0,191,3],[193,1,193,2],[223,0,226,3],[22,13,22,15],[22,16,22,18],[23,10,23,12],[23,13,23,15],[23,16,23,18],[127,7,127,20],[159,10,159,12],[159,13,159,15],[159,16,159,18],[160,16,160,18],[162,7,162,20],[123,10,123,12],[123,13,123,15],[123,16,123,18],[124,10,124,12],[124,13,124,15],[124,16,124,18],[125,10,125,12],[86,0,87,3],[89,1,89,2],[15,5,15,22],[16,9,16,19],[17,0,18,3],[2,7,4,23],[5,7,6,23],[21,10,21,12],[21,13,21,15],[21,16,21,18],[27,10,27,12],[27,13,27,15],[27,16,27,18],[28,10,28,12],[28,13,28,15],[28,16,28,18],[22,10,22,12],[12,5,12,22],[20,1,20,2],[20,10,20,12],[20,13,20,15],[8,5,11,22],[29,10,29,12],[29,13,29,15],[61,10,61,12],[61,13,61,15],[61,16,61,18],[0,0,1,4],[0,5,1,9],[0,10,1,14],[0,15,1,19],[0,20,1,23],[53,0,56,3],[58,1,58,2],[33,11,33,16],[40,7,40,20],[13,9,13,18],[20,16,20,18],[18,7,18,20],[25,7,25,20],[32,7,32,20],[30,13,30,15],[30,16,30,18],[29,16,29,18],[30,10,30,12],[46,16,46,18],[50,9,50,19],[38,10,38,12],[44,16,44,18],[45,10,45,12],[45,13,45,15],[45,16,45,18],[41,11,41,16],[35,10,35,12],[38,13,38,15],[38,16,38,18],[35,13,35,15],[35,16,35,18],[36,10,36,12],[36,13,36,15],[36,16,36,18],[37,10,37,12],[37,13,37,15],[37,16,37,18],[164,13,164,15],[164,16,164,18],[165,10,165,12],[173,13,173,15],[173,16,173,18],[174,10,174,12],[174,13,174,15],[175,10,175,12],[175,13,175,15],[175,16,175,18],[164,10,164,12],[160,10,160,12],[160,13,160,15],[43,10,43,12],[43,13,43,15],[43,16,43,18],[44,10,44,12],[44,13,44,15],[46,10,46,12],[46,13,46,15],[52,7,52,20],[49,5,49,22],[54,10,54,12],[54,13,54,15],[54,16,54,18],[55,10,55,12],[55,13,55,15],[55,16,55,18],[56,10,56,12],[56,13,56,15],[56,16,56,18],[57,10,57,12],[57,13,57,15],[57,16,57,18],[59,7,59,20],[62,10,62,12],[62,13,62,15],[62,16,62,18],[63,10,63,12],[63,13,63,15],[63,16,63,18],[64,10,64,12],[64,13,64,15],[64,16,64,18],[66,7,66,20],[67,11,67,16],[69,10,69,12],[69,13,69,15],[69,16,69,18],[70,10,70,12],[70,13,70,15],[70,16,70,18],[71,10,71,12],[71,13,71,15],[71,16,71,18],[72,10,72,12],[72,13,72,15],[72,16,72,18],[74,7,74,20],[75,11,75,16],[77,10,77,12],[77,13,77,15],[77,16,77,18],[78,10,78,12],[78,13,78,15],[78,16,78,18],[79,10,79,12],[79,13,79,15],[79,16,79,18],[80,10,80,12],[80,13,80,15],[80,16,80,18],[86,7,86,20],[88,10,88,12],[88,13,88,15],[88,16,88,18],[89,10,89,12],[89,13,89,15],[89,16,89,18],[83,5,83,22],[84,9,84,19],[90,10,90,12],[90,13,90,15],[90,16,90,18],[91,10,91,12],[91,13,91,15],[91,16,91,18],[93,7,93,20],[95,10,95,12],[95,13,95,15],[95,16,95,18],[96,10,96,12],[96,13,96,15],[96,16,96,18],[97,10,97,12],[97,13,97,15],[97,16,97,18],[98,10,98,12],[98,13,98,15],[98,16,98,18],[100,7,100,20],[101,11,101,16],[103,10,103,12],[103,13,103,15],[104,10,104,12],[104,13,104,15],[104,16,104,18],[105,10,105,12],[105,13,105,15],[105,16,105,18],[103,16,103,18],[106,10,106,12],[106,13,106,15],[108,7,108,20],[109,11,109,16],[111,10,111,12],[111,13,111,15],[111,16,111,18],[112,10,112,12],[112,13,112,15],[112,16,112,18],[106,16,106,18],[113,10,113,12],[113,13,113,15],[113,16,113,18],[114,10,114,12],[114,13,114,15],[114,16,114,18],[120,7,120,20],[122,10,122,12],[122,13,122,15],[122,16,122,18],[117,5,117,22],[118,9,118,19],[129,10,129,12],[129,13,129,15],[129,16,129,18],[125,13,125,15],[125,16,125,18],[130,10,130,12],[130,13,130,15],[130,16,130,18],[131,10,131,12],[131,13,131,15],[131,16,131,18],[132,10,132,12],[132,13,132,15],[132,16,132,18],[134,7,134,20],[135,11,135,16],[137,10,137,12],[137,13,137,15],[137,16,137,18],[138,10,138,12],[138,13,138,15],[138,16,138,18],[139,10,139,12],[139,13,139,15],[139,16,139,18],[140,10,140,12],[140,13,140,15],[140,16,140,18],[142,7,142,20],[143,11,143,16],[145,10,145,12],[145,13,145,15],[145,16,145,18],[146,10,146,12],[146,13,146,15],[146,16,146,18],[147,10,147,12],[147,13,147,15],[147,16,147,18],[148,10,148,12],[148,13,148,15],[148,16,148,18],[150,5,150,22],[151,9,151,19],[155,7,155,20],[157,10,157,12],[157,13,157,15],[157,16,157,18],[158,10,158,12],[158,13,158,15],[158,16,158,18],[153,16,153,18],[194,10,194,12],[165,13,165,15],[165,16,165,18],[166,10,166,12],[166,13,166,15],[166,16,166,18],[167,10,167,12],[167,13,167,15],[167,16,167,18],[182,13,182,15],[182,16,182,18],[182,10,182,12],[169,7,169,20],[170,11,170,16],[183,10,183,12],[183,13,183,15],[183,16,183,18],[181,10,181,12],[181,13,181,15],[181,16,181,18],[172,10,172,12],[172,13,172,15],[172,16,172,18],[173,10,173,12],[200,10,200,12],[200,13,200,15],[200,16,200,18],[177,7,177,20],[178,11,178,16],[174,16,174,18],[180,10,180,12],[180,13,180,15],[180,16,180,18],[201,10,201,12],[201,13,201,15],[201,16,201,18],[187,5,187,22],[188,9,188,19],[190,7,190,20],[192,10,192,12],[192,13,192,15],[192,16,192,18],[193,10,193,12],[193,13,193,15],[193,16,193,18],[194,13,194,15],[194,16,194,18],[195,10,195,12],[195,13,195,15],[195,16,195,18],[197,7,197,20],[199,10,199,12],[199,13,199,15],[199,16,199,18],[202,10,202,12],[202,13,202,15],[202,16,202,18],[204,7,204,20],[205,11,205,16],[207,10,207,12],[207,13,207,15],[207,16,207,18],[208,10,208,12],[208,13,208,15],[208,16,208,18],[209,10,209,12],[209,13,209,15],[209,16,209,18],[210,10,210,12],[210,13,210,15],[210,16,210,18],[212,7,212,20],[213,11,213,16],[215,10,215,12],[215,13,215,15],[215,16,215,18],[216,10,216,12],[216,13,216,15],[216,16,216,18],[217,10,217,12],[217,13,217,15],[217,16,217,18],[218,10,218,12],[218,13,218,15],[218,16,218,18],[221,5,221,22],[222,9,222,19],[224,7,224,20],[226,10,226,12],[226,13,226,15],[226,16,226,18],[227,10,227,12],[227,13,227,15],[227,16,227,18],[228,10,228,12],[228,13,228,15],[228,16,228,18],[229,10,229,12],[229,13,229,15],[229,16,229,18],[231,7,231,20],[233,10,233,12],[233,13,233,15],[233,16,233,18],[234,10,234,12],[234,13,234,15],[234,16,234,18],[235,10,235,12],[235,13,235,15],[235,16,235,18],[236,10,236,12],[236,13,236,15],[236,16,236,18],[238,7,238,20],[239,11,239,16],[241,10,241,12],[241,13,241,15],[241,16,241,18],[242,10,242,12],[242,13,242,15],[242,16,242,18],[243,10,243,12],[243,13,243,15],[243,16,243,18],[244,10,244,12],[244,13,244,15],[244,16,244,18],[252,10,252,12],[252,13,252,15],[252,16,252,18],[246,7,246,20],[247,11,247,16],[249,10,249,12],[249,13,249,15],[249,16,249,18],[250,10,250,12],[250,13,250,15],[250,16,250,18],[251,10,251,12],[251,13,251,15],[251,16,251,18]]}
["Welcome Tab",null,null,null,null,"Agency Profile",null,null,null,null,"Key Data Input",null,null,null,null,"Plan Information",null,null,null,null,"Plan Report"]
[]
[null,null,null,null,null,null,null,"Employment Opportunities Plan Report Guide"]
[]
[]
[null,null,null,null,null,null,null,"Section 2: Key Data Input"]
[]
[]
[null,null,null,null,null,"The key data inputs below will assist with identifying the picture of the agencies workforce regarding employees with disabilities. Data collected will assist DHRM with metrics to compare across all agencies within the Commonwealth. This comparison can help to identify trends and develop actionable items to address challenges and promote the hiring and development of individuals with disabilities. "]
[]
[]
[]
[null,null,null,null,null,"NOTE: Fiscal Year for this report is July 1 - May 31 due to the deadline being June 30th"]
[null,null,null,null,null,null,null,null,null,"**All Data Below Should Reflect Only Classified Employees**"]
[]
[null,null,null,null,null,"Agency Workforce Details - Employees With Disabilities"]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
["Step 1: Enter Data regarding Total Employees"]
[null,null,null,null,null,null,null,"Total Employees at Agency"]
[]
["Status:",{"$f":"IF(AF21=8,\"Complete\",\"Incomplete\")","v":"Incomplete"},null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N22:P23,\"yes\")","v":0},{"$f":"COUNTA(Q22:S23)","v":0},{"$f":"IF(AA21=AB21,1,0)","v":1},{"$f":"IF(Q24<>\"\",1,0)","v":0},null,{"$f":"SUM(AC21:AD21,AC28:AD28,AC36:AD36,AC44:AD44)","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,2,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,2,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,30,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,30,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Employees with Disabilities at Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N29:P30,\"yes\")","v":0},{"$f":"COUNTA(Q29:S30)","v":0},{"$f":"IF(AA28=AB28,1,0)","v":1},{"$f":"IF(Q31<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,3,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,3,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,31,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,31,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Employees with Disabilities at Agency who are Leaders/Supervisors"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N37:P38,\"yes\")","v":0},{"$f":"COUNTA(Q37:S38)","v":0},{"$f":"IF(AA36=AB36,1,0)","v":1},{"$f":"IF(Q39<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,4,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,4,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,32,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,32,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Employees with Disabilities at Agency who are Executives"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N45:P46,\"yes\")","v":0},{"$f":"COUNTA(Q45:S46)","v":0},{"$f":"IF(AA44=AB44,1,0)","v":1},{"$f":"IF(Q47<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,5,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,5,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,33,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,33,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[]
[null,null,null,null,null,"Veteran Workforce Data (related to Individuals with Disabilities) "]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
[]
[null,null,null,null,null,null,null,"Total Veterans at Agency"]
["Step 2: Enter data regarding veterans and veterans with disabilities."]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N56:P57,\"yes\")","v":0},{"$f":"COUNTA(Q56:S57)","v":0},{"$f":"IF(AA55=AB55,1,0)","v":1},{"$f":"IF(Q58<>\"\",1,0)","v":0},null,{"$f":"SUM(AC55:AD55,AC62:AD62,AC70:AD70,AC78:AD78)","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,6,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,6,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,34,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,34,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
["Status:",{"$f":"IF(AF55=8,\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,null,null,null,"Total Veterans with Disabilities at Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N63:P64,\"yes\")","v":0},{"$f":"COUNTA(Q63:S64)","v":0},{"$f":"IF(AA62=AB62,1,0)","v":1},{"$f":"IF(Q65<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,7,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,7,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,35,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,35,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Veterans with Disabilities at Agency who are Leaders/Supervisors"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N71:P72,\"yes\")","v":0},{"$f":"COUNTA(Q71:S72)","v":0},{"$f":"IF(AA70=AB70,1,0)","v":1},{"$f":"IF(Q73<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,8,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,8,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,36,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,36,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Veterans with Disabilities at Agency who are Executives"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N79:P80,\"yes\")","v":0},{"$f":"COUNTA(Q79:S80)","v":0},{"$f":"IF(AA78=AB78,1,0)","v":1},{"$f":"IF(Q81<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,9,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,9,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,37,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,37,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[]
[null,null,null,null,null,"Hiring Data for Employees with Disabilities"]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
[]
["Step 3: Enter Hiring Data for Agency and Employees with Disabilities",null,null,null,null,null,null,"Total Hires at Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N90:P91,\"yes\")","v":0},{"$f":"COUNTA(Q90:S91)","v":0},{"$f":"IF(AA89=AB89,1,0)","v":1},{"$f":"IF(Q92<>\"\",1,0)","v":0},null,{"$f":"SUM(AC89:AD89,AC96:AD96,AC104:AD104,AC112:AD112)","v":4}]
["Status:",{"$f":"IF(AF89=8,\"Complete\",\"Incomplete\")","v":"Incomplete"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,10,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,10,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,38,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,38,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Employees with Disabilities Hired at Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N97:P98,\"yes\")","v":0},{"$f":"COUNTA(Q97:S98)","v":0},{"$f":"IF(AA96=AB96,1,0)","v":1},{"$f":"IF(Q99<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,11,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,11,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,39,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,39,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Employees with Disabilities Hired at Agency to Leaders/Supervisors Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N105:P106,\"yes\")","v":0},{"$f":"COUNTA(Q105:S106)","v":0},{"$f":"IF(AA104=AB104,1,0)","v":1},{"$f":"IF(Q107<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,12,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,12,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,40,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,40,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Employees with Disabilities Hired at Agency to Executive Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N113:P114,\"yes\")","v":0},{"$f":"COUNTA(Q113:S114)","v":0},{"$f":"IF(AA112=AB112,1,0)","v":1},{"$f":"IF(Q115<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,13,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,13,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,41,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,41,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[]
[null,null,null,null,null,"Voluntary Separation Data for Employees with Disabilities"]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
["Step 4: Enter data regarding separations and separations of employees with disabilities."]
[null,null,null,null,null,null,null,"Total Voluntary Separations"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N124:P125,\"yes\")","v":0},{"$f":"COUNTA(Q124:S125)","v":0},{"$f":"IF(AA123=AB123,1,0)","v":1},{"$f":"IF(Q126<>\"\",1,0)","v":0},null,{"$f":"SUM(AC123:AD123,AC130:AD130,AC138:AD138,AC146:AD146)","v":4},null,{"$f":"SUM(AF123+AF158)","v":8}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,14,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,14,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
["Status:",{"$f":"IF(AH123=16,\"Complete\",\"Incomplete\")","v":"Incomplete"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,42,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,42,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Voluntary Separations that were Employees with Disabilities"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N131:P132,\"yes\")","v":0},{"$f":"COUNTA(Q131:S132)","v":0},{"$f":"IF(AA130=AB130,1,0)","v":1},{"$f":"IF(Q133<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,15,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,15,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,43,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,43,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Voluntary Separations who were Employees with Disabilities in Leader/Supervisor Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N139:P140,\"yes\")","v":0},{"$f":"COUNTA(Q139:S140)","v":0},{"$f":"IF(AA138=AB138,1,0)","v":1},{"$f":"IF(Q141<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,16,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,16,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,44,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,44,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Voluntary Separations who were Employees with Disabilities in Executive Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N147:P148,\"yes\")","v":0},{"$f":"COUNTA(Q147:S148)","v":0},{"$f":"IF(AA146=AB146,1,0)","v":1},{"$f":"IF(Q149<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,17,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,17,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,45,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,45,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,"Voluntary Transfer Data for Employees with Disabilities"]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is Voluntary Transfer Data (to Other State Agencies) included in the Separation Numbers above?"]
[]
[null,null,null,null,null,null,null,"Total Voluntary Transfers (to other State Agencies)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N159:P160,\"yes\")","v":0},{"$f":"COUNTA(Q159:S160)","v":0},{"$f":"IF(AA158=AB158,1,0)","v":1},{"$f":"IF(Q161<>\"\",1,0)","v":0},null,{"$f":"SUM(AC158:AD158,AC165:AD165,AC173:AD173,AC181:AD181)","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,18,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,18,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,46,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,46,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Voluntary Transfers (to Other State Agencies) that were Employees with Disabilities"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N166:P167,\"yes\")","v":0},{"$f":"COUNTA(Q166:S167)","v":0},{"$f":"IF(AA165=AB165,1,0)","v":1},{"$f":"IF(Q168<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,19,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,19,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,47,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,47,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Voluntary Transfers (to Other State Agencies) who were Employees with Disabilities in Leader/Supervisor Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N174:P175,\"yes\")","v":0},{"$f":"COUNTA(Q174:S175)","v":0},{"$f":"IF(AA173=AB173,1,0)","v":1},{"$f":"IF(Q176<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,20,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,20,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,48,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,48,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Voluntary Transfers (to Other State Agencies) who were Employees with Disabilities in Executive Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N182:P183,\"yes\")","v":0},{"$f":"COUNTA(Q182:S183)","v":0},{"$f":"IF(AA181=AB181,1,0)","v":1},{"$f":"IF(Q184<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,21,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,21,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,49,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,49,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[]
[]
[null,null,null,null,null,"Internal Transfer (with Agency)  Data for Employees with Disabilities"]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
[]
["Step 5: Enter Internal Transfer Data for Agency and Employees with Disabilities",null,null,null,null,null,null,"Total Internal Transfers (within State Agency)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N194:P195,\"yes\")","v":0},{"$f":"COUNTA(Q194:S195)","v":0},{"$f":"IF(AA193=AB193,1,0)","v":1},{"$f":"IF(Q196<>\"\",1,0)","v":0},null,{"$f":"SUM(AC193:AD193,AC200:AD200,AC208:AD208,AC216:AD216)","v":4}]
["Status:",{"$f":"IF(AF193=8,\"Complete\",\"Incomplete\")","v":"Incomplete"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,22,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,22,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,50,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,50,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Transfers (to within State Agency) that were Employees with Disabilities"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N201:P202,\"yes\")","v":0},{"$f":"COUNTA(Q201:S202)","v":0},{"$f":"IF(AA200=AB200,1,0)","v":1},{"$f":"IF(Q203<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,23,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,23,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,51,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,51,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Transfers (within State Agency) who were Employees with Disabilities in Leader/Supervisor Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N209:P210,\"yes\")","v":0},{"$f":"COUNTA(Q209:S210)","v":0},{"$f":"IF(AA208=AB208,1,0)","v":1},{"$f":"IF(Q211<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,24,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,24,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,52,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,52,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Transfers (within State Agencies) who were Employees with Disabilities in Executive Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N217:P218,\"yes\")","v":0},{"$f":"COUNTA(Q217:S218)","v":0},{"$f":"IF(AA216=AB216,1,0)","v":1},{"$f":"IF(Q219<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,25,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,25,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,53,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,53,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[]
[null,null,null,null,null,"Agency Promotion of Employees with Disabilities"]
[null,null,null,null,null,null,null,null,null,"**Calculations are defaulted to utilize DHRM prior data unless the agency indicates to use their own data.**"]
["Step 6: Enter data regarding promotions at Agency and among employees with disabilities."]
[null,null,null,null,null,null,null,"Total Promotions within Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N228:P229,\"yes\")","v":0},{"$f":"COUNTA(Q228:S229)","v":0},{"$f":"IF(AA227=AB227,1,0)","v":1},{"$f":"IF(Q230<>\"\",1,0)","v":0},null,{"$f":"SUM(AC227:AD227,AC234:AD234,AC242:AD242,AC250:AD250)","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,26,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,26,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
["Status:",{"$f":"IF(AF227=8,\"Complete\",\"Incomplete\")","v":"Incomplete"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,54,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,54,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Promotions within Agency that were Employees with Disabilities"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N235:P236,\"yes\")","v":0},{"$f":"COUNTA(Q235:S236)","v":0},{"$f":"IF(AA234=AB234,1,0)","v":1},{"$f":"IF(Q237<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,27,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,27,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,55,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,55,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Promotions within Agency that were Employees with Disabilities to Leader/Supervisor Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as having 2 or more direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N243:P244,\"yes\")","v":0},{"$f":"COUNTA(Q243:S244)","v":0},{"$f":"IF(AA242=AB242,1,0)","v":1},{"$f":"IF(Q245<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,28,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,28,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,56,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,56,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]
[]
[null,null,null,null,null,null,null,"Total Promotions within Agency that were Employees with Disabilities to Executive Positions"]
[null,null,null,null,null,null,null,null,null,null,null,"**Defined as agency head and direct reports**"]
[]
[null,null,null,null,null,null,null,null,null,null,"Prior Data",null,null,"Use Agency Data Instead?",null,null,"Agency Provided Data",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N251:P252,\"yes\")","v":0},{"$f":"COUNTA(Q251:S252)","v":0},{"$f":"IF(AA250=AB250,1,0)","v":1},{"$f":"IF(Q253<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AG$10)","v":"FY 2019"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,29,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,29,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AH$10)","v":"FY 2020"},{"$f":"IF(AND('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,57,FALSE)=\"\"),\"Data Not Captured\",IF('1. Agency Profile'!$AF$15=1,VLOOKUP('1. Agency Profile'!$G$12,'PRIOR DATA'!$A$11:$BE$200,57,FALSE),\"--\"))","v":{"$error":"#N/A"}},null,null,"No"]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!$AI$10)","v":"FY 2021"}]

{"sheet":"3. Plan Information","index":3,"n_rows":237,"n_cols":36,"rows_kept":237,"cut":false,"hidden":false,"merged":[[47,8,50,21],[42,5,45,7],[47,5,50,7],[52,6,52,21],[40,5,40,7],[40,8,40,11],[0,0,1,4],[0,5,1,9],[0,10,1,14],[0,15,1,19],[0,20,1,24],[2,6,4,24],[5,6,6,24],[9,5,11,23],[14,5,19,23],[13,5,13,23],[14,0,15,3],[17,1,17,2],[27,8,27,12],[22,5,25,23],[27,13,27,16],[22,0,23,3],[25,1,25,2],[37,1,37,2],[42,8,45,21],[34,0,35,3],[35,5,35,7],[35,8,38,21],[31,6,31,21],[33,5,33,7],[33,8,33,11],[33,14,33,16],[33,17,33,21],[68,5,71,7],[68,8,71,21],[54,5,54,7],[54,8,54,11],[54,14,54,16],[54,17,54,21],[56,5,56,7],[56,8,59,21],[77,5,77,7],[77,8,80,21],[61,5,61,7],[61,8,61,11],[63,5,66,7],[63,8,66,21],[82,5,82,7],[82,8,82,11],[84,5,87,7],[84,8,87,21],[73,6,73,21],[75,5,75,7],[75,8,75,11],[75,14,75,16],[75,17,75,21],[98,5,98,7],[98,8,101,21],[103,5,103,7],[103,8,103,11],[105,5,108,7],[105,8,108,21],[89,5,92,7],[89,8,92,21],[94,6,94,21],[96,5,96,7],[96,8,96,11],[96,14,96,16],[96,17,96,21],[119,5,119,7],[119,8,122,21],[124,5,124,7],[124,8,124,11],[126,5,129,7],[126,8,129,21],[110,5,113,7],[110,8,113,21],[115,6,115,21],[117,5,117,7],[117,8,117,11],[117,14,117,16],[117,17,117,21],[140,5,140,7],[140,8,143,21],[145,5,145,7],[145,8,145,11],[147,5,150,7],[147,8,150,21],[131,5,134,7],[131,8,134,21],[136,6,136,21],[138,5,138,7],[138,8,138,11],[138,14,138,16],[138,17,138,21],[161,5,161,7],[161,8,164,21],[166,5,166,7],[166,8,166,11],[168,5,171,7],[168,8,171,21],[152,5,155,7],[152,8,155,21],[157,6,157,21],[159,5,159,7],[159,8,159,11],[159,14,159,16],[159,17,159,21],[194,5,197,7],[194,8,197,21],[182,5,182,7],[182,8,185,21],[187,5,187,7],[187,8,187,11],[189,5,192,7],[189,8,192,21],[173,5,176,7],[173,8,176,21],[178,6,178,21],[180,5,180,7],[180,8,180,11],[180,14,180,16],[180,17,180,21],[203,5,203,7],[203,8,206,21],[208,5,208,7],[208,8,208,11],[210,5,213,7],[210,8,213,21],[199,6,199,21],[201,5,201,7],[201,8,201,11],[201,14,201,16],[201,17,201,21],[236,5,239,7],[236,8,239,21],[224,5,224,7],[224,8,227,21],[229,5,229,7],[229,8,229,11],[231,5,234,7],[231,8,234,21],[215,5,218,7],[215,8,218,21],[220,6,220,21],[222,5,222,7],[222,8,222,11],[222,14,222,16],[222,17,222,21]]}
["Welcome Tab",null,null,null,null,"Agency Profile",null,null,null,null,"Key Data Input",null,null,null,null,"Plan Information",null,null,null,null,"Plan Report"]
[]
[null,null,null,null,null,null,"Employment Opportunities Plan Report Guide"]
[]
[]
[null,null,null,null,null,null,"Section 3: Plan Information"]
[]
[]
[]
[null,null,null,null,null,"Please provide a review and update to prior plans or actions taken to increase employment of individuals with disabilities. Potential items could be a description of previous action items, current status or progress of them, potential impacts of previous action items, lessons learned, or challenges experienced. "]
[]
[]
[]
[null,null,null,null,null,"Brief Review & Progress Updates of Prior Actions"]
["Step 1: Enter a brief review of prior FY plans and progress update. "]
[]
[]
["Status:",{"$f":"IF(F15<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[]
[]
[]
[]
["Step 2: Enter the total number of action items the agency will take. ",null,null,null,null,"Please outline the action items the organization will take to expand existing efforts for the recruitment, accommodation, retention, advancement, and development of individuals with employees. "]
[]
[]
["Status:",{"$f":"IF(N28<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[]
[null,null,null,null,null,null,null,null,"Total Number of Action Items (1-10)"]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N28,AH33:AJ42,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(AE32=(N28*5),1,0)","v":{"$error":"#N/A"}},null,null,"Items","Sum"]
[null,null,null,null,null,null,null,null,null,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":"AD34","v":0},{"$f":"SUM(AI33)","v":0}]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I34=\"Other\",COUNTA(I34,R34,I36,I41,I43,I48),COUNTA(I34,I36,I41,I43,I48))","v":0},{"$f":"IF(I34=\"Other\",1,0)","v":0},{"$f":"AB34-AC34","v":0},null,null,null,2,{"$f":"AD55","v":0},{"$f":"SUM($AI$33:AI34)","v":0}]
["Step 3: Enter a brief review of prior FY plans and progress update. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"AD76","v":0},{"$f":"SUM($AI$33:AI35)","v":0}]
[null,null,null,null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AD97","v":0},{"$f":"SUM($AI$33:AI36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"AD118","v":0},{"$f":"SUM($AI$33:AI37)","v":0}]
["Status:",{"$f":"IFERROR(IF(AF32=1,\"Complete\",\"Incomplete\"),\"Incomplete\")","v":"Incomplete"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"AD139","v":0},{"$f":"SUM($AI$33:AI38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"AD160","v":0},{"$f":"SUM($AI$33:AI39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"AD181","v":0},{"$f":"SUM($AI$33:AI40)","v":0}]
[null,null,null,null,null,"Estimated Timeframe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"AD202","v":0},{"$f":"SUM($AI$33:AI41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"AD223","v":0},{"$f":"SUM($AI$33:AI42)","v":0}]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 2"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I55=\"Other\",COUNTA(I57,I62,I64,I69,R55,I55),COUNTA(I55,I57,I62,I64,I69))","v":0},{"$f":"IF(I55=\"Other\",1,0)","v":0},{"$f":"AB55-AC55","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 3"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I76=\"Other\",COUNTA(I78,I83,I85,I90,R76,I76),COUNTA(I76,I78,I83,I85,I90))","v":0},{"$f":"IF(I76=\"Other\",1,0)","v":0},{"$f":"AB76-AC76","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 4"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I97=\"Other\",COUNTA(I99,I104,I106,I111,R97,I97),COUNTA(I97,I99,I104,I106,I111))","v":0},{"$f":"IF(I97=\"Other\",1,0)","v":0},{"$f":"AB97-AC97","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 5"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I118=\"Other\",COUNTA(I120,I125,I127,I132,R118,I118),COUNTA(I118,I120,I125,I127,I132))","v":0},{"$f":"IF(I118=\"Other\",1,0)","v":0},{"$f":"AB118-AC118","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 6"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I139=\"Other\",COUNTA(I141,I146,I148,I153,R139,I139),COUNTA(I139,I141,I146,I148,I153))","v":0},{"$f":"IF(I139=\"Other\",1,0)","v":0},{"$f":"AB139-AC139","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 7"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I160=\"Other\",COUNTA(I162,I167,I169,I174,R160,I160),COUNTA(I160,I162,I167,I169,I174))","v":0},{"$f":"IF(I160=\"Other\",1,0)","v":0},{"$f":"AB160-AC160","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I179=\"Other\",COUNTA(I181,I186,I188,I193,R179,I179),COUNTA(I179,I181,I186,I188,I193))","v":0},{"$f":"IF(I179=\"Other\",1,0)","v":0},{"$f":"AB179-AC179","v":0}]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:"]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 9"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I202=\"Other\",COUNTA(I204,I209,I211,I216,R202,I202),COUNTA(I202,I204,I209,I211,I216))","v":0},{"$f":"IF(I202=\"Other\",1,0)","v":0},{"$f":"AB202-AC202","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Action Item 10"]
[]
[null,null,null,null,null,"Action Item Category",null,null,null,null,null,null,null,null,"If Other, Please Specify:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I223=\"Other\",COUNTA(I225,I230,I232,I237,R223,I223),COUNTA(I223,I225,I230,I232,I237))","v":0},{"$f":"IF(I223=\"Other\",1,0)","v":0},{"$f":"AB223-AC223","v":0}]
[]
[null,null,null,null,null,"Description"]
[]
[]
[]
[]
[null,null,null,null,null,"Estimated Timeframe"]
[]
[null,null,null,null,null,"Potential Impacts or Benefits from Action"]
[]
[]
[]
[]
[null,null,null,null,null,"Potential challenges or obstacles that may be experienced with this action"]

{"sheet":"Plan Report ","index":4,"n_rows":349,"n_cols":28,"rows_kept":349,"cut":false,"hidden":false,"merged":[[141,4,144,21],[149,4,152,21],[145,4,148,21],[53,4,55,7],[121,4,124,21],[125,4,128,21],[129,4,132,21],[133,4,136,21],[137,4,140,21],[75,4,76,21],[0,0,1,4],[0,5,1,9],[0,10,1,14],[0,15,1,19],[0,20,1,23],[344,10,344,15],[115,4,116,21],[117,4,120,21],[153,4,156,21],[158,4,159,21],[160,4,163,21],[201,4,202,21],[203,4,206,21],[244,4,245,21],[246,4,249,21],[287,4,288,21],[330,3,332,22],[336,4,337,21],[335,4,335,11],[335,12,335,21],[289,4,292,21],[321,4,324,21],[325,4,328,21],[2,7,4,23],[5,7,6,23],[12,11,14,14],[15,11,16,14],[17,3,19,22],[11,3,14,10],[15,4,16,9],[21,4,37,21],[39,3,41,22],[46,4,48,7],[43,4,45,7],[43,8,45,11],[53,18,55,21],[53,8,56,11],[43,13,45,16],[43,18,45,21],[46,8,48,11],[46,13,48,16],[113,4,114,21],[104,4,112,21],[59,4,61,21],[98,3,100,22],[102,4,103,21],[53,13,56,16],[50,4,52,7],[50,8,52,11],[50,13,52,16],[50,18,52,21],[46,18,48,21],[164,4,167,21],[168,4,171,21],[172,4,175,21],[176,4,179,21],[180,4,183,21],[184,4,187,21],[188,4,191,21],[192,4,195,21],[196,4,199,21],[207,4,210,21],[211,4,214,21],[215,4,218,21],[219,4,222,21],[223,4,226,21],[227,4,230,21],[231,4,234,21],[235,4,238,21],[239,4,242,21],[250,4,253,21],[254,4,257,21],[258,4,261,21],[262,4,265,21],[266,4,269,21],[270,4,273,21],[274,4,277,21],[313,4,316,21],[317,4,320,21],[278,4,281,21],[282,4,285,21],[301,4,304,21],[305,4,308,21],[309,4,312,21],[293,4,296,21],[297,4,300,21]]}
["Welcome Tab",null,null,null,null,"Agency Profile",null,null,null,null,"Key Data Input",null,null,null,null,"Plan Information",null,null,null,null,"Plan Report",null,null,null,null,null,null,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,1]
[null,null,null,null,null,null,null,"Employee Opportunities Plan Report Guide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,1]
[null,null,null,null,null,null,null,"Full Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,1]
[null,null,null,{"$f":"'1. Agency Profile'!$G$12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('FILE MAINTENANCE'!AI10,\" Employee Opportunities Plan\")","v":"2021 Employee Opportunities Plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,1]
[null,null,null,null,{"$f":"CONCATENATE(\"Agency Number: \",VLOOKUP(D12,'CENTRAL DATA'!A9:G142,7,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-04-13"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1]
[null,null,null,"            Summary of Efforts to Increase Employment of Individuals With Disabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,1]
[null,null,null,null,{"$f":"'1. Agency Profile'!$F$22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,1]
[null,null,null,"            Fiscal Year Workforce Breakdown and Metrics - Employees with Disabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,1]
[null,null,null,null,356,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,{"$f":"'CENTRAL ANALYSIS'!G10","v":0},null,null,null,{"$f":"'CENTRAL ANALYSIS'!G11","v":0},null,null,null,null,{"$f":"'CENTRAL ANALYSIS'!G12","v":0},null,null,null,null,{"$f":"'CENTRAL ANALYSIS'!G13","v":0},null,null,null,null,null,null,null,null,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,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,1]
[null,null,null,null,"Total Employees With Disabilities                 ",null,null,null,"Employees with Disabilities in a Leader or Supervisory Position",null,null,null,null,"Employees with Disabilities are in Executive Positions",null,null,null,null,"Employees with Disabilities                are Veterans ",null,null,null,null,null,null,null,null,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,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,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,1]
[null,null,null,null,{"$f":"'CENTRAL ANALYSIS'!H10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"'CENTRAL ANALYSIS'!H11","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"'CENTRAL ANALYSIS'!H12","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"'CENTRAL ANALYSIS'!H13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,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,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,1]
[null,null,null,null,"Percent of Workforce are              Employees with Disabilities",null,null,null,"Percent of Workforce are               Employees with Disabilities in a Leader or Supervisory Position",null,null,null,null,"Percent of Workforce are Employees with Disabilities in Executive Positions",null,null,null,null,"Percent of Workforce are              Employees with Disabilities who               are Veterans",null,null,null,null,null,null,null,null,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,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,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,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,1]
[]
[null,null,null,null,"Percent of Workforce who are Individuals with Disabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,1]
[null,null,null,null,"Three Year Workforce Trends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,1]
[null,null,null,"             Agency Actions to Be Taken to Improve Employment of Individuals with Disabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,1]
[null,null,null,null,"Brief Review and Progress Updates of Prior Actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1]
[null,null,null,null,{"$f":"'3. Plan Information'!F15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,1]
[null,null,null,null,"Organization Plan Action Items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1]
[null,null,null,null,"Recruitment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E118<>0,E122<>0,E126<>0,E130<>0,E134<>0,E138<>0,E142<>0,E146<>0,E150<>0,E154<>0),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,null,null,null,null,null,null,{"$f":"IF(OR(E118<>0,E122<>0,E126<>0,E130<>0,E134<>0,E138<>0,E142<>0,E146<>0,E150<>0,E154<>0),1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$34=\"Recruitment\",'3. Plan Information'!$I$36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E118<>0,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,null,null,null,null,null,null,{"$f":"IF(E118<>0,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,null,null,null,null,null,null,{"$f":"IF(E118<>0,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,null,null,null,null,null,null,{"$f":"IF(E118<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$55=\"Recruitment\",'3. Plan Information'!$I$57,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E122<>0,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,null,null,null,null,null,null,{"$f":"IF(E122<>0,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,null,null,null,null,null,null,{"$f":"IF(E122<>0,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,null,null,null,null,null,null,{"$f":"IF(E122<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$76=\"Recruitment\",'3. Plan Information'!$I$78,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E126<>0,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,null,null,null,null,null,null,{"$f":"IF(E126<>0,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,null,null,null,null,null,null,{"$f":"IF(E126<>0,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,null,null,null,null,null,null,{"$f":"IF(E126<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$97=\"Recruitment\",'3. Plan Information'!$I$99,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E130<>0,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,null,null,null,null,null,null,{"$f":"IF(E130<>0,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,null,null,null,null,null,null,{"$f":"IF(E130<>0,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,null,null,null,null,null,null,{"$f":"IF(E130<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$118=\"Recruitment\",'3. Plan Information'!$I$120,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E134<>0,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,null,null,null,null,null,null,{"$f":"IF(E134<>0,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,null,null,null,null,null,null,{"$f":"IF(E134<>0,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,null,null,null,null,null,null,{"$f":"IF(E134<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$139=\"Recruitment\",'3. Plan Information'!$I$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E138<>0,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,null,null,null,null,null,null,{"$f":"IF(E138<>0,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,null,null,null,null,null,null,{"$f":"IF(E138<>0,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,null,null,null,null,null,null,{"$f":"IF(E138<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$160=\"Recruitment\",'3. Plan Information'!$I$162,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E142<>0,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,null,null,null,null,null,null,{"$f":"IF(E142<>0,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,null,null,null,null,null,null,{"$f":"IF(E142<>0,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,null,null,null,null,null,null,{"$f":"IF(E142<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$181=\"Recruitment\",'3. Plan Information'!$I$183,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E146<>0,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,null,null,null,null,null,null,{"$f":"IF(E146<>0,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,null,null,null,null,null,null,{"$f":"IF(E146<>0,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,null,null,null,null,null,null,{"$f":"IF(E146<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$202=\"Recruitment\",'3. Plan Information'!$I$204,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E150<>0,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,null,null,null,null,null,null,{"$f":"IF(E150<>0,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,null,null,null,null,null,null,{"$f":"IF(E150<>0,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,null,null,null,null,null,null,{"$f":"IF(E150<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$223=\"Recruitment\",'3. Plan Information'!$I$225,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E154<>0,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,null,null,null,null,null,null,{"$f":"IF(E154<>0,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,null,null,null,null,null,null,{"$f":"IF(E154<>0,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,null,null,null,null,null,null,{"$f":"IF(E154<>0,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,null,null,null,null,null,null,{"$f":"IF(AB159=1,1,0)","v":0}]
[null,null,null,null,"Accommodations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E161<>0,E165<>0,E169<>0,E173<>0,E177<>0,E181<>0,E185<>0,E189<>0,E193<>0,E197<>0),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,null,null,null,null,null,null,{"$f":"IF(OR(E161<>0,E165<>0,E169<>0,E173<>0,E177<>0,E181<>0,E185<>0,E189<>0,E193<>0,E197<>0),1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$34=\"Accomodations\",'3. Plan Information'!$I$36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E161<>0,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,null,null,null,null,null,null,{"$f":"IF(E161<>0,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,null,null,null,null,null,null,{"$f":"IF(E161<>0,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,null,null,null,null,null,null,{"$f":"IF(E161<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$55=\"Accomodations\",'3. Plan Information'!$I$57,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E165<>0,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,null,null,null,null,null,null,{"$f":"IF(E165<>0,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,null,null,null,null,null,null,{"$f":"IF(E165<>0,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,null,null,null,null,null,null,{"$f":"IF(E165<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$76=\"Accomodations\",'3. Plan Information'!$I$78,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E169<>0,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,null,null,null,null,null,null,{"$f":"IF(E169<>0,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,null,null,null,null,null,null,{"$f":"IF(E169<>0,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,null,null,null,null,null,null,{"$f":"IF(E169<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$97=\"Accomodations\",'3. Plan Information'!$I$99,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E173<>0,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,null,null,null,null,null,null,{"$f":"IF(E173<>0,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,null,null,null,null,null,null,{"$f":"IF(E173<>0,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,null,null,null,null,null,null,{"$f":"IF(E173<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$118=\"Accomodations\",'3. Plan Information'!$I$120,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E177<>0,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,null,null,null,null,null,null,{"$f":"IF(E177<>0,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,null,null,null,null,null,null,{"$f":"IF(E177<>0,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,null,null,null,null,null,null,{"$f":"IF(E177<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$139=\"Accomodations\",'3. Plan Information'!$I$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E181<>0,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,null,null,null,null,null,null,{"$f":"IF(E181<>0,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,null,null,null,null,null,null,{"$f":"IF(E181<>0,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,null,null,null,null,null,null,{"$f":"IF(E181<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$160=\"Accomodations\",'3. Plan Information'!$I$162,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E185<>0,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,null,null,null,null,null,null,{"$f":"IF(E185<>0,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,null,null,null,null,null,null,{"$f":"IF(E185<>0,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,null,null,null,null,null,null,{"$f":"IF(E185<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$181=\"Accomodations\",'3. Plan Information'!$I$183,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E189<>0,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,null,null,null,null,null,null,{"$f":"IF(E189<>0,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,null,null,null,null,null,null,{"$f":"IF(E189<>0,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,null,null,null,null,null,null,{"$f":"IF(E189<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$202=\"Accomodations\",'3. Plan Information'!$I$204,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E193<>0,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,null,null,null,null,null,null,{"$f":"IF(E193<>0,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,null,null,null,null,null,null,{"$f":"IF(E193<>0,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,null,null,null,null,null,null,{"$f":"IF(E193<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$223=\"Accomodations\",'3. Plan Information'!$I$225,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E197<>0,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,null,null,null,null,null,null,{"$f":"IF(E197<>0,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,null,null,null,null,null,null,{"$f":"IF(E197<>0,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,null,null,null,null,null,null,{"$f":"IF(E197<>0,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,null,null,null,null,null,null,{"$f":"IF(AB202=1,1,0)","v":0}]
[null,null,null,null,"Retention",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E204<>0,E208<>0,E212<>0,E216<>0,E220<>0,E224<>0,E228<>0,E232<>0,E236<>0,E240<>0),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,null,null,null,null,null,null,{"$f":"IF(OR(E204<>0,E208<>0,E212<>0,E216<>0,E220<>0,E224<>0,E228<>0,E232<>0,E236<>0,E240<>0),1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$34=\"Retention\",'3. Plan Information'!$I$36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E204<>0,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,null,null,null,null,null,null,{"$f":"IF(E204<>0,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,null,null,null,null,null,null,{"$f":"IF(E204<>0,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,null,null,null,null,null,null,{"$f":"IF(E204<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$55=\"Retention\",'3. Plan Information'!$I$57,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E208<>0,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,null,null,null,null,null,null,{"$f":"IF(E208<>0,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,null,null,null,null,null,null,{"$f":"IF(E208<>0,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,null,null,null,null,null,null,{"$f":"IF(E208<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$76=\"Retention\",'3. Plan Information'!$I$78,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E212<>0,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,null,null,null,null,null,null,{"$f":"IF(E212<>0,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,null,null,null,null,null,null,{"$f":"IF(E212<>0,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,null,null,null,null,null,null,{"$f":"IF(E212<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$97=\"Retention\",'3. Plan Information'!$I$99,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E216<>0,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,null,null,null,null,null,null,{"$f":"IF(E216<>0,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,null,null,null,null,null,null,{"$f":"IF(E216<>0,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,null,null,null,null,null,null,{"$f":"IF(E216<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$118=\"Retention\",'3. Plan Information'!$I$120,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E220<>0,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,null,null,null,null,null,null,{"$f":"IF(E220<>0,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,null,null,null,null,null,null,{"$f":"IF(E220<>0,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,null,null,null,null,null,null,{"$f":"IF(E220<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$139=\"Retention\",'3. Plan Information'!$I$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E224<>0,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,null,null,null,null,null,null,{"$f":"IF(E224<>0,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,null,null,null,null,null,null,{"$f":"IF(E224<>0,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,null,null,null,null,null,null,{"$f":"IF(E224<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$160=\"Retention\",'3. Plan Information'!$I$162,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E228<>0,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,null,null,null,null,null,null,{"$f":"IF(E228<>0,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,null,null,null,null,null,null,{"$f":"IF(E228<>0,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,null,null,null,null,null,null,{"$f":"IF(E228<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$181=\"Retention\",'3. Plan Information'!$I$183,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E232<>0,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,null,null,null,null,null,null,{"$f":"IF(E232<>0,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,null,null,null,null,null,null,{"$f":"IF(E232<>0,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,null,null,null,null,null,null,{"$f":"IF(E232<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$202=\"Retention\",'3. Plan Information'!$I$204,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E236<>0,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,null,null,null,null,null,null,{"$f":"IF(E236<>0,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,null,null,null,null,null,null,{"$f":"IF(E236<>0,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,null,null,null,null,null,null,{"$f":"IF(E236<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$223=\"Retention\",'3. Plan Information'!$I$225,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E240<>0,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,null,null,null,null,null,null,{"$f":"IF(E240<>0,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,null,null,null,null,null,null,{"$f":"IF(E240<>0,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,null,null,null,null,null,null,{"$f":"IF(E240<>0,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,null,null,null,null,null,null,{"$f":"IF(AB245=1,1,0)","v":0}]
[null,null,null,null,"Advancement and Development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E247<>0,E251<>0,E255<>0,E259<>0,E263<>0,E267<>0,E271<>0,E275<>0,E279<>0,E283<>0),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,null,null,null,null,null,null,{"$f":"IF(OR(E247<>0,E251<>0,E255<>0,E259<>0,E263<>0,E267<>0,E271<>0,E275<>0,E279<>0,E283<>0),1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$34=\"Advancement / Development\",'3. Plan Information'!$I$36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E247<>0,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,null,null,null,null,null,null,{"$f":"IF(E247<>0,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,null,null,null,null,null,null,{"$f":"IF(E247<>0,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,null,null,null,null,null,null,{"$f":"IF(E247<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$55=\"Advancement / Development\",'3. Plan Information'!$I$57,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E251<>0,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,null,null,null,null,null,null,{"$f":"IF(E251<>0,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,null,null,null,null,null,null,{"$f":"IF(E251<>0,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,null,null,null,null,null,null,{"$f":"IF(E251<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$76=\"Advancement / Development\",'3. Plan Information'!$I$78,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E255<>0,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,null,null,null,null,null,null,{"$f":"IF(E255<>0,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,null,null,null,null,null,null,{"$f":"IF(E255<>0,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,null,null,null,null,null,null,{"$f":"IF(E255<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$97=\"Advancement / Development\",'3. Plan Information'!$I$99,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E259<>0,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,null,null,null,null,null,null,{"$f":"IF(E259<>0,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,null,null,null,null,null,null,{"$f":"IF(E259<>0,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,null,null,null,null,null,null,{"$f":"IF(E259<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$118=\"Advancement / Development\",'3. Plan Information'!$I$120,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E263<>0,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,null,null,null,null,null,null,{"$f":"IF(E263<>0,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,null,null,null,null,null,null,{"$f":"IF(E263<>0,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,null,null,null,null,null,null,{"$f":"IF(E263<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$139=\"Advancement / Development\",'3. Plan Information'!$I$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E267<>0,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,null,null,null,null,null,null,{"$f":"IF(E267<>0,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,null,null,null,null,null,null,{"$f":"IF(E267<>0,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,null,null,null,null,null,null,{"$f":"IF(E267<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$160=\"Advancement / Development\",'3. Plan Information'!$I$162,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E271<>0,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,null,null,null,null,null,null,{"$f":"IF(E271<>0,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,null,null,null,null,null,null,{"$f":"IF(E271<>0,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,null,null,null,null,null,null,{"$f":"IF(E271<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$181=\"Advancement / Development\",'3. Plan Information'!$I$183,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E275<>0,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,null,null,null,null,null,null,{"$f":"IF(E275<>0,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,null,null,null,null,null,null,{"$f":"IF(E275<>0,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,null,null,null,null,null,null,{"$f":"IF(E275<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$202=\"Advancement / Development\",'3. Plan Information'!$I$204,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E279<>0,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,null,null,null,null,null,null,{"$f":"IF(E279<>0,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,null,null,null,null,null,null,{"$f":"IF(E279<>0,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,null,null,null,null,null,null,{"$f":"IF(E279<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$223=\"Advancement / Development\",'3. Plan Information'!$I$225,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E283<>0,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,null,null,null,null,null,null,{"$f":"IF(E283<>0,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,null,null,null,null,null,null,{"$f":"IF(E283<>0,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,null,null,null,null,null,null,{"$f":"IF(E283<>0,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,null,null,null,null,null,null,{"$f":"IF(AB289=1,1,0)","v":0}]
[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,{"$f":"IF(OR(E290<>0,E294<>0,E298<>0,E302<>0,E306<>0,E310<>0,E314<>0,E318<>0,E322<>0,E326<>0),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,null,null,null,null,null,null,{"$f":"IF(OR(E290<>0,E294<>0,E298<>0,E302<>0,E306<>0,E310<>0,E314<>0,E318<>0,E322<>0,E326<>0),1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$34=\"Other\",'3. Plan Information'!$I$36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E290<>0,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,null,null,null,null,null,null,{"$f":"IF(E290<>0,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,null,null,null,null,null,null,{"$f":"IF(E290<>0,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,null,null,null,null,null,null,{"$f":"IF(E290<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$55=\"Other\",'3. Plan Information'!$I$57,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E294<>0,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,null,null,null,null,null,null,{"$f":"IF(E294<>0,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,null,null,null,null,null,null,{"$f":"IF(E294<>0,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,null,null,null,null,null,null,{"$f":"IF(E294<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$76=\"Other\",'3. Plan Information'!$I$78,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E298<>0,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,null,null,null,null,null,null,{"$f":"IF(E298<>0,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,null,null,null,null,null,null,{"$f":"IF(E298<>0,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,null,null,null,null,null,null,{"$f":"IF(E298<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$97=\"Other\",'3. Plan Information'!$I$99,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E302<>0,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,null,null,null,null,null,null,{"$f":"IF(E302<>0,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,null,null,null,null,null,null,{"$f":"IF(E302<>0,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,null,null,null,null,null,null,{"$f":"IF(E302<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$118=\"Other\",'3. Plan Information'!$I$120,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E306<>0,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,null,null,null,null,null,null,{"$f":"IF(E306<>0,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,null,null,null,null,null,null,{"$f":"IF(E306<>0,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,null,null,null,null,null,null,{"$f":"IF(E306<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$139=\"Other\",'3. Plan Information'!$I$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E310<>0,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,null,null,null,null,null,null,{"$f":"IF(E310<>0,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,null,null,null,null,null,null,{"$f":"IF(E310<>0,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,null,null,null,null,null,null,{"$f":"IF(E310<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$160=\"Other\",'3. Plan Information'!$I$162,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E314<>0,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,null,null,null,null,null,null,{"$f":"IF(E314<>0,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,null,null,null,null,null,null,{"$f":"IF(E314<>0,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,null,null,null,null,null,null,{"$f":"IF(E314<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$181=\"Other\",'3. Plan Information'!$I$183,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E318<>0,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,null,null,null,null,null,null,{"$f":"IF(E318<>0,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,null,null,null,null,null,null,{"$f":"IF(E318<>0,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,null,null,null,null,null,null,{"$f":"IF(E318<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$202=\"Other\",'3. Plan Information'!$I$204,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E322<>0,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,null,null,null,null,null,null,{"$f":"IF(E322<>0,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,null,null,null,null,null,null,{"$f":"IF(E322<>0,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,null,null,null,null,null,null,{"$f":"IF(E322<>0,1,0)","v":0}]
[null,null,null,null,{"$f":"IF('3. Plan Information'!$I$223=\"Other\",'3. Plan Information'!$I$225,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E326<>0,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,null,null,null,null,null,null,{"$f":"IF(E326<>0,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,null,null,null,null,null,null,{"$f":"IF(E326<>0,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,null,null,null,null,null,null,{"$f":"IF(E326<>0,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,null,null,null,null,null,null,1]
[null,null,null,"             Statement of Commitment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,1]
[null,null,null,null,{"$f":"'1. Agency Profile'!G12","v":0},null,null,null,null,null,null,null,"is committed to the Commonwealth's policy and its efforts to increase employment opportunities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,"for individuals with disabilities. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,1]
[null,null,null,null,null,null,"Agency Head Signature",null,null,null,null,null,null,null,"Human Resources Director",null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,1]
[null,null,null,null,null,null,null,null,null,null,"Employment Lead, Individuals with Disabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,1]

{"sheet":"CENTRAL DATA","index":5,"n_rows":142,"n_cols":16,"rows_kept":142,"cut":false,"hidden":true,"merged":[[0,2,2,17],[3,2,4,17]]}
[null,null,"Employee Opportunities Plan Report"]
[]
[]
[null,null,"Central Data"]
[]
[]
[]
["Agency Name","Agency Logo","Agency Type 1","Agency Type 2","Agency Type 3","FY19 Passcode (Must contain at least 1 letter)","Agency Number",null,null,"Action Item Lists",null,"Action Status List",null,"Action Plan Timeline",null,"Yes/No"]
["Assistive Technology Loan Fund Authority",null,"Family & Health",null,null,"CKZH",null,null,null,"Recruitment",null,"Completed",null,"Within 6 Months",null,"Yes"]
["Blue Ridge Community College",null,"Higher Education",null,null,"B7UR",291,null,null,"Accomodations",null,"Continuing",null,"6-12 Months",null,"No"]
["Board of Accountancy",null,"Finance","Economy","Licenses","S6UU",226,null,null,"Retention",null,"Modified",null,"1-2 Years"]
["Center for Innovative Technology",null,"Government",null,null,"KKLC",null,null,null,"Advancement / Development",null,"Declined",null,"2-5 Years"]
["Central Virginia Community College",null,"Higher Education",null,null,"JN21",292,null,null,"Other",null,null,null,"Ongoing (No specific time frame)"]
["Christopher Newport University",null,"Higher Education",null,null,"49LE",242]
["Commonwealth's Attorneys' Services Council",null,"Public Safety",null,null,"UIUW",957]
["Compensation Board",null,"Government","Employment","Finance","6O08",157]
["Dabney S. Lancaster Community College",null,"Higher Education",null,null,"BJI3",287]
["Danville Community College ",null,"Higher Education",null,null,"P44C",279]
["Department for the Blind and Vision Impaired",null,"Family & Health",null,null,"GVNP",702]
["Department for the Deaf and Hard of Hearing",null,"Family & Health",null,null,"GI49",751]
["Department of Accounts",null,"Government","Finance",null,"EPI5",151]
["Department of Aging and Rehabilitative Services",null,"Family & Health",null,null,"AQW8",262]
["Department of Alcoholic Beverage Control",null,"Public Safety","Economy","Licenses","UDCI"]
["Department of Aviation",null,"Transportation","Licenses",null,"28C7",841]
["Department of Behavioral Health and Developmental Services",null,"Family & Health","Licenses",null,"OKMJ",720]
["Department of Corrections",null,"Public Safety",null,null,"D61B",701]
["Department of Criminal Justice Services",null,"Public Safety",null,null,"XACU",140]
["Department of Education",null,"Education","Licenses",null,"B437",201]
["Department of Elections",null,"Government",null,null,"G6HC",132]
["Department of Emergency Management",null,"Public Safety",null,null,"L3T1",127]
["Department of Environmental Quality",null,"Environment & Natural Resources",null,null,"Y82Y",440]
["Department of Forensic Science",null,"Public Safety",null,null,"GGMT",778]
["Department of Forestry",null,"Environment & Natural Resources",null,null,"VMO3",411]
["Department of Game and Inland Fisheries",null,"Environment & Natural Resources",null,null,"ZX5T",403]
["Department of General Services",null,"Government",null,null,"PGSK",194]
["Department of Health Professions",null,"Employment","Family & Health","Licenses","KRB6",223]
["Department of Historic Resources",null,"Environment & Natural Resources",null,null,"B78Q",423]
["Department of Housing & Community Development",null,"Business","Economy",null,"JJLM",165]
["Department of Human Resources Management",null,"Government","Employment",null,"47CJ",129]
["Department of Juvenile Justice",null,"Public Safety",null,null,"S1NX",777]
["Department of Labor and Industry",null,"Business","Employment","Economy","NO0G",181]
["Department of Medical Assistance Services",null,"Family & Health",null,null,"CTE5",602]
["Department of Military Affairs",null,"Veterans and Military Affairs",null,null,"BWXW",123]
["Department of Mines, Minerals, and Energy",null,"Environment & Natural Resources",null,null,"58KJ",409]
["Department of Motor Vehicles",null,"Licenses","Transportation",null,"SB0Y",154]
["Department of Planning and Budget",null,"Finance",null,null,"9VDF",122]
["Department of Professional and Occupational Regulation",null,"Business","Employment","Licenses","AAPH",222]
["Department of Rail and Public Transportation",null,"Transportation",null,null,"7RVO",505]
["Department of Small Business and Supplier Diversity",null,"Business","Economy",null,"8GAL",350]
["Department of Social Services",null,"Family & Health",null,null,"5Q4A",765]
["Department of State Police",null,"Public Safety",null,null,"7C8D",156]
["Department of Taxation",null,"Government","Business","Finance","TG0X",161]
["Department of the Treasury",null,"Finance",null,null,"FU7E",152]
["Department of Transportation",null,"Business","Public Safety","Transportation","F0JY",501]
["Department of Veterans Services",null,"Government","Education","Family & Health","03C4",912]
["Eastern Shore Community College",null,"Higher Education",null,null,"ERFR",284]
["Foundation for Healthy Youth",null,"Family & Health",null,null,"U1DP",852]
["Frontier Culture Museum of Virginia",null,"Education","Recreation & Culture",null,"A0VF",239]
["George Mason University",null,"Higher Education",null,null,"JCLA",247]
["Germanna Community College",null,"Higher Education",null,null,"VVOP",297]
["Gunston Hall",null,"Education","Recreation & Culture",null,"XP05",417]
["Institute for Advanced Learning and Research",null,"Education",null,null,"9A5J"]
["J. Sargeant Reynolds Community College",null,"Higher Education",null,null,"7MZR",283]
["James Madison University",null,"Higher Education",null,null,"UAGF",216]
["Jamestown-Yorktown Foundation",null,"Education",null,null,"KFPS",425]
["John Tyler Community College",null,"Higher Education",null,null,"Y8RN",290]
["Library of Virginia",null,"Education",null,null,"8FR9",202]
["Longwood University",null,"Higher Education",null,null,"HE8R",214]
["Lord Fairfax Community College",null,"Higher Education",null,null,"D8HR",298]
["Marine Resources Commission",null,"Environment & Natural Resources",null,null,"PTUG",402]
["Motor Vehicle Dealer Board",null,"Transportation","Licenses",null,"O3SD",506]
["Mountain Empire Community College",null,"Higher Education",null,null,"1SJG",299]
["New College Institute",null,"Higher Education",null,null,"2HY9",938]
["New River Community College",null,"Higher Education",null,null,"9ZFW",275]
["Norfolk State University",null,"Education",null,null,"70WX",213]
["Northern Virginia Community College",null,"Higher Education",null,null,"I5IP",280]
["Northern Virginia Mental Health Institute",null,"Family & Health",null,null,"B2IR"]
["Office of Attorney General",null,"Government",null,null,"CMZ9"]
["Office of Children's Services",null,"Family & Health",null,null,"1DTM"]
["Office of Public-Private Partnerships",null,"Transportation",null,null,"KBOF"]
["Office of the Governor",null,"Government",null,null,"09Z4"]
["Office of the Lieutenant Governor",null,"Government",null,null,"65EH"]
["Office of the State Inspector General",null,"Government","Public Safety",null,"6EBG",147]
["Old Dominion University",null,"Higher Education",null,null,"RZQO",221]
["Patrick Henry Community College",null,"Higher Education",null,null,"HN4Z",285]
["Paul D. Camp Community College",null,"Higher Education",null,null,"1X6Q",277]
["Piedmont Virginia Community College",null,"Higher Education",null,null,"GNFZ",282]
["Radford University",null,"Higher Education",null,null,"V0QB",217]
["Rappahannock Community College",null,"Higher Education",null,null,"XJTT",278]
["Richard Bland College",null,"Higher Education",null,null,"MWFJ",241]
["VCCS Shared Services Center",null,"Higher Education",null,null,"LWMM",270]
["Sitter and Barfoot Veterans Care Center",null,null,null,null,"LBAE",922]
["Southern Virginia Higher Education Center",null,"Higher Education",null,null,"9CVH",937]
["Southside Virginia Community College",null,"Higher Education",null,null,"WKHE",276]
["Southwest Virginia Community College",null,"Higher Education",null,null,"6YJO",294]
["Southwest Virginia Higher Education Center",null,"Higher Education",null,null,"26LT",948]
["State Corporation Commission",null,"Government","Licenses",null,"W7VI"]
["State Council for Higher Education for Virginia",null,"Education",null,null,"MHIN",245]
["VCCS System Office",null,"Higher Education",null,null,"BOYY"]
["The College of William and Mary",null,"Higher Education",null,null,"KV8V",204]
["The Science Museum of Virginia",null,"Education","Recreation & Culture",null,"BMYZ",146]
["Thomas Nelson Community College",null,"Higher Education",null,null,"50LF",293]
["Tidewater Community College",null,"Higher Education",null,null,"C8FD",295]
["University of Mary Washington",null,"Higher Education",null,null,"LOVB",215]
["University of Virginia",null,"Higher Education",null,null,"1Y9F",207]
["University of Virginia at Wise",null,"Higher Education",null,null,"R89B",246]
["University of Virginia Medical Center",null,"Family & Health",null,null,"ZLOS"]
["Virginia Board for People with Disabilities",null,"Family & Health",null,null,"L0YR"]
["Virginia Commercial Space Flight Authority",null,"Transportation",null,null,"BIFT"]
["Virginia Commission for the Arts",null,"Education",null,null,"7IFB",148]
["Virginia Commonwealth University",null,"Higher Education",null,null,"JG9G",236]
["Virginia Commonwealth University Health Systems Authority",null,"Family & Health",null,null,"3W0V"]
["Virginia Community College System",null,"Higher Education",null,null,"2BKF",261]
["Virginia Department of Agriculture and Consumer Services",null,"Economy","Environment & Natural Resources","Licenses","T9P9",301]
["Virginia Department of Conservation and Recreation",null,"Environment & Natural Resources","Recreation & Culture",null,"8DK1",199]
["Virginia Department of Fire Programs",null,"Public Safety",null,null,"J82I",960]
["Virginia Department of Health",null,"Family & Health","Public Safety",null,"VTPT",601]
["Virginia Economic Development Partnership",null,"Business","Economy",null,"BSHW"]
["Virginia Employment Commission",null,"Business"," Employment",null,"ROUH",182]
["Virginia Highlands Community College",null,"Higher Education",null,null,"V2KR",296]
["Virginia Housing Development Authority",null,"Business","Economy",null,"TXWQ"]
["Virginia Information Technologies Agency",null,"Government",null,null,"M1LR",136]
["Virginia Lottery",null,"Recreation & Culture",null,null,"4UK6"]
["Virginia Military Institute",null,"Higher Education",null,null,"4MTO",211]
["Virginia Museum of Fine Arts",null,"Recreation & Culture",null,null,"H5LF",238]
["Virginia Museum of Natural History",null,"Recreation & Culture","Environment & Natural Resources",null,"PPI2",942]
["Virginia Parole Board",null,"Business","Economy",null,"F06H",766]
["Virginia Polytechnic Institute and State University",null,"Higher Education",null,null,"B8RL",208]
["Virginia Port Authority",null,"Transportation",null,null,"QZXF"]
["Virginia Racing Commission",null,"Recreation & Culture","Licenses",null,"IH79",405]
["Virginia Resources Authority",null,"Finance","Economy",null,"UCLJ"]
["Virginia Retirement System",null,"Employment",null,null,"IP64"]
["Virginia School for the Deaf and the Blind",null,"Education",null,null,"G0DC",218]
["Virginia State University",null,"Higher Education",null,null,"UYFJ",212]
["Virginia Tobacco Region Revitalization Commission",null,"Environment & Natural Resources","Economy",null,"ZRSM"]
["Virginia Tourism Corporation",null,"Recreation & Culture","Economy",null,"MLUL"]
["Virginia Western Community College",null,"Higher Education",null,null,"SJI0",286]
["Virginia Workers' Compensation Commission",null,"Business","Employment",null,"EF3S"]
["Virginia Workforce Connection",null,"Business ","Employment",null,"WTCO"]
["Virginia529 College Savings Plan",null,"Education",null,null,"X16Y"]
["Wilson Workforce Rehabilitation Center",null,"Employment",null,null,"0LGK"]
["Wytheville Community College",null,"Higher Education",null,null,null,288]

{"sheet":"FILE MAINTENANCE","index":6,"n_rows":25,"n_cols":35,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,23,4,28],[0,6,2,22],[3,6,4,22],[12,1,12,21],[13,1,14,21],[24,1,27,21],[18,1,21,21],[8,1,8,21],[9,1,10,21],[6,1,6,21],[23,1,23,21],[17,1,17,21],[15,7,15,10],[15,11,15,14]]}
[null,null,null,null,null,null,"Employee Opportunities Plan Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version Notes"]
[]
[]
[null,null,null,null,null,null,"DHRM File Maintenance Instructions"]
[]
[]
[null,"A new file for the report fisal year should be created before updating any of the information below. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2020.1"]
[null,"Update File Version",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial version sent to DHRM",null,null,null,null,null,null,null,"PY2","PY1","CFY"]
[null,"Before updating any data below, first update the version number of the welcome tab and save the file as the new version. To update the version, first unlock the welcome tab and then update the text in the bottom right hadn corner to the new version. This will hlep to prevent duplicate files and track the new fiscal year's report file. ",null,null,null,null,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":"YEAR(L16)","v":2021},null,{"$f":"AE10-2","v":2019},{"$f":"AE10-1","v":2020},{"$f":"AE10","v":2021}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2020.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,"Added \"speedomter\" chart to final report."]
[null,"Update Fiscal Year"]
[null,"To update or change the fiscal year, change the fiscal year in the box below. This will impact the title headings in section 6, section 7, and on the full report. "]
[]
[null,null,null,null,null,null,null,"Report Due Date",null,null,null,"2021-09-01"]
[]
[null,"Prior Year Data Export Entry"]
[null,"To add data from a prior year's report, you must first unlock the workbook using the password (acuqired from DHRM). If done correctly, you should be able to unhide the tab \"Data Export for Next FY\" in the agency's report file. Next, unlock the workbook and unhide the \"Prior Data\" tab in the file for the next fiscal year. Click on the \"add row button to add a row at the top of the chart. Click to \"copy data\" button on the Data Export for Next FY tab. Then, go back to the Prior Data Tab and click the \"Paste Data Button\" of the file for next fiscal year.  Order of the agencies does not matter. "]
[]
[]
[]
[]
[null,"Dashboard Data Export"]
[null,"To add data from a prior year's report, you must first unlock the workbook using the password (acuqired from DHRM). If done correctly, you should be able to unhide the tab \"Dashboard Data Export\" in the agency's report file.  Click to \"copy data\" button on the Data Export for Next FY tab. Then, go to the Prior Data Tab and click the \"Paste Data Button\" of the dashboard file tab.  Order of the agencies does not matter. "]

{"sheet":"CENTRAL ANALYSIS","index":7,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":true,"merged":[[79,0,79,6],[0,8,2,20],[3,8,4,20],[8,0,8,5],[7,0,7,5],[9,0,9,5],[10,0,10,5],[11,0,11,5],[12,0,12,5],[15,0,15,3],[25,0,25,3],[25,6,25,12]]}
[null,null,null,null,null,null,null,null,"Employee Opportunities Plan Report"]
[]
[]
[null,null,null,null,null,null,null,null,"Central Analysis for Final Report"]
[]
[]
[]
["Metric",null,null,null,null,null,"Number","Percent"]
["Total Employees at Agency",null,null,null,null,null,{"$f":"'2. Key Data Input'!Q24","v":0}]
["Total Employees with Disabilities",null,null,null,null,null,{"$f":"'2. Key Data Input'!Q31","v":0},{"$f":"G10/$G$9","v":{"$error":"#DIV/0!"}}]
["Employees with Disabilities who are Leaders",null,null,null,null,null,{"$f":"'2. Key Data Input'!Q39","v":0},{"$f":"G11/$G$9","v":{"$error":"#DIV/0!"}}]
["Employees with Disabilities who are Executives",null,null,null,null,null,{"$f":"'2. Key Data Input'!Q47","v":0},{"$error":"#DIV/0!"}]
["Employees with Disabilities who are Veterans",null,null,null,null,null,{"$f":"'2. Key Data Input'!Q65","v":0},{"$error":"#DIV/0!"}]
[]
[]
["Total Employees with Disabilities Graph"]
[null,{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!AG10)","v":"FY 2019"},{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!AH10)","v":"FY 2020"},{"$f":"CONCATENATE(\"FY \",'FILE MAINTENANCE'!AI10)","v":"FY 2021"}]
["Total Employees with Disabilities",{"$f":"IF('2. Key Data Input'!$N$29=\"NO\",'2. Key Data Input'!$K$29,'2. Key Data Input'!$Q$29)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$30=\"NO\",'2. Key Data Input'!$K$30,'2. Key Data Input'!$Q$29)","v":{"$error":"#N/A"}},{"$f":"'2. Key Data Input'!$Q$31","v":0}]
["Total Hires",{"$f":"IF('2. Key Data Input'!$N$97=\"NO\",'2. Key Data Input'!$K$97,'2. Key Data Input'!$Q$97)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$98=\"NO\",'2. Key Data Input'!$K$98,'2. Key Data Input'!$Q$98)","v":{"$error":"#N/A"}},{"$f":"'2. Key Data Input'!$Q$99","v":0}]
["Total Internal Transfers",{"$f":"IF('2. Key Data Input'!$N$201=\"NO\",'2. Key Data Input'!$K$201,'2. Key Data Input'!$Q$201)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$202=\"NO\",'2. Key Data Input'!$K$202,'2. Key Data Input'!$Q$202)","v":{"$error":"#N/A"}},{"$f":"'2. Key Data Input'!$Q$203","v":0}]
["Total Promotions",{"$f":"IF('2. Key Data Input'!$N$235=\"NO\",'2. Key Data Input'!$K$235,'2. Key Data Input'!$Q$235)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$236=\"NO\",'2. Key Data Input'!$K$236,'2. Key Data Input'!$Q$236)","v":{"$error":"#N/A"}},{"$f":"'2. Key Data Input'!$Q$237","v":0}]
["Total Voluntary Separations",{"$f":"IF('2. Key Data Input'!$N$131=\"NO\",'2. Key Data Input'!$K$131,'2. Key Data Input'!$Q$131)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$132=\"NO\",'2. Key Data Input'!$K$132,'2. Key Data Input'!$Q$132)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!Q154=\"Yes\",'2. Key Data Input'!$Q$133,'2. Key Data Input'!Q133+'2. Key Data Input'!Q168)","v":0}]
[]
[]
[]
["Speedometer Graph (Outline)",null,null,null,null,null,"Speedometer Graph (Outline)"]
[1,1,null,null,null,null,"Fiscal Year","Total Employees","Total Employees with Disabilities","Percentage"]
[2,1,null,null,null,null,{"$f":"'2. Key Data Input'!J22","v":"FY 2019"},{"$f":"IF('2. Key Data Input'!N22=\"no\",'2. Key Data Input'!K22,'2. Key Data Input'!Q22)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!N29=\"no\",'2. Key Data Input'!K29,'2. Key Data Input'!Q29)","v":{"$error":"#N/A"}},{"$f":"I28/H28","v":{"$error":"#N/A"}},{"$f":"IF(J28>6%,6%,J28)","v":{"$error":"#N/A"}},{"$f":"6%-K28","v":{"$error":"#N/A"}},0.06]
[3,1,null,null,null,null,{"$f":"'2. Key Data Input'!J23","v":"FY 2020"},{"$f":"IF('2. Key Data Input'!N23=\"no\",'2. Key Data Input'!K23,'2. Key Data Input'!Q23)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!N30=\"no\",'2. Key Data Input'!K30,'2. Key Data Input'!Q30)","v":{"$error":"#N/A"}},{"$f":"I29/H29","v":{"$error":"#N/A"}},{"$f":"IF(J29>6%,6%,J29)","v":{"$error":"#N/A"}},{"$f":"6%-K29","v":{"$error":"#N/A"}},0.06]
[4,1,null,null,null,null,{"$f":"'2. Key Data Input'!J24","v":"FY 2021"},{"$f":"'2. Key Data Input'!Q24","v":0},{"$f":"'2. Key Data Input'!Q31","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.06]
[5,1]
[6,1]
[7,1,null,null,null,null,null,null,null,{"$f":"G28","v":"FY 2019"},{"$f":"M28","v":0.06},{"$f":"K28","v":{"$error":"#N/A"}},1E-4,{"$f":"L28","v":{"$error":"#N/A"}}]
[8,1,null,null,null,null,null,null,null,{"$f":"G29","v":"FY 2020"},{"$f":"M29","v":0.06},{"$f":"K29","v":{"$error":"#N/A"}},1E-4,{"$f":"L29","v":{"$error":"#N/A"}}]
[9,1,null,null,null,null,null,null,null,"FY 2021",0.06,{"$error":"#DIV/0!"},1E-4,{"$error":"#DIV/0!"}]
[10,1]
[11,1]
[12,1]
[13,1]
[14,1]
[15,1]
[16,1]
[17,1]
[18,1]
[19,1]
[20,1]
[21,1]
[22,1]
[23,1]
[24,1]
[25,1]
[26,1]
[27,1]
[28,1]
[29,1]
[30,1]
[31,1]
[32,1]
[33,1]
[34,1]
[35,1]
[36,1]
[37,1]
[38,1]
[39,1]
[40,1]
[41,1]
[42,1]
[43,1]
[44,1]
[45,1]
[46,1]
[47,1]
[48,1]
[49,1]
[50,1]

{"sheet":"DATA EXPORT FOR NEXT FY","index":8,"n_rows":11,"n_cols":59,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,7,2,59],[3,7,4,59]]}
[null,null,null,null,null,null,null,"Employee Opportunities Plan Report"]
[]
[]
[null,null,null,null,null,null,null,"Data Export for Next FY Employee Opportunities Plan Report"]
[]
[]
[]
[]
[]
[null,"Agency Name","Total Employees PFY2","Total Employees with Disabilities PFY2","Total Employees with Disabilities who are Leaders PFY2","Total Employees with Disabilities who are Executives PFY2","Total Veterans PFY2","Total Veterans with Disabilities PFY2","Total Veterans with Disabilities who are Leaders PFY2","Total Veterans with Disabilities who are Executives PFY2","Total Hires PFY2","Total Hires with Disabilities PFY2","Total Hires with Disabilities who are Leaders PFY2","Total Hires with Disabilities who are Executives PFY2","Total Separations PFY2","Total Separations with Disabilities PFY2","Total Separations with Disabilities who are Leaders PFY2","Total Separations with Disabilities who are Executives PFY2","Total Transfers PFY2","Total Transfers with Disabilities PFY2","Total Transfers with Disabilities who are Leaders PFY2","Total Transfers with Disabilities who are Executives PFY2","Total Internal Transfers PFY2","Total Internal Transfers with Disabilities PFY2","Total Internal Transfers with Disabilities who are Leaders PFY2","Total Internal Transfers with Disabilities who are Executives PFY2","Total Promotions PFY2","Total Promotions with Disabilities PFY2","Total Promotions with Disabilities who are Leaders PFY2","Total Promotions with Disabilities who are Executives PFY2","Total Employees PFY","Total Employees with Disabilities PFY","Total Employees with Disabilities who are Leaders PFY","Total Employees with Disabilities who are Executives PFY","Total Veterans PFY","Total Veterans with Disabilities PFY","Total Veterans with Disabilities who are Leaders PFY","Total Veterans with Disabilities who are Executives PFY","Total Hires PFY","Total Hires with Disabilities PFY","Total Hires with Disabilities who are Leaders PFY","Total Hires with Disabilities who are Executives PFY","Total Separations PFY","Total Separations with Disabilities PFY","Total Separations with Disabilities who are Leaders PFY","Total Separations with Disabilities who are Executives PFY","Total Transfers PFY","Total Transfers with Disabilities PFY","Total Transfers with Disabilities who are Leaders PFY","Total Transfers with Disabilities who are Executives PFY","Total Internal Transfers PFY","Total Internal Transfers with Disabilities PFY","Total Internal Transfers with Disabilities who are Leaders PFY","Total Internal Transfers with Disabilities who are Executives PFY","Total Promotions PFY","Total Promotions with Disabilities PFY","Total Promotions with Disabilities who are Leaders PFY","Total Promotions with Disabilities who are Executives PFY"," "]
[null,{"$f":"'1. Agency Profile'!G12","v":0},{"$f":"IF('2. Key Data Input'!$N$23=\"no\",'2. Key Data Input'!$K$23,'2. Key Data Input'!$Q$23)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$30=\"no\",'2. Key Data Input'!$K$30,'2. Key Data Input'!$Q$30)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$38=\"no\",'2. Key Data Input'!$K$38,'2. Key Data Input'!$Q$38)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$47=\"no\",'2. Key Data Input'!$K$47,'2. Key Data Input'!$Q$47)","v":0},{"$f":"IF('2. Key Data Input'!$N$57=\"no\",'2. Key Data Input'!$K$57,'2. Key Data Input'!$Q$57)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$64=\"no\",'2. Key Data Input'!$K$64,'2. Key Data Input'!$Q$64)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$73=\"no\",'2. Key Data Input'!$K$73,'2. Key Data Input'!$Q$73)","v":0},{"$f":"IF('2. Key Data Input'!$N$80=\"no\",'2. Key Data Input'!$K$80,'2. Key Data Input'!$Q$80)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$91=\"no\",'2. Key Data Input'!$K$91,'2. Key Data Input'!$Q$91)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$98=\"no\",'2. Key Data Input'!$K$98,'2. Key Data Input'!$Q$98)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$106=\"no\",'2. Key Data Input'!$K$106,'2. Key Data Input'!$Q$106)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$114=\"no\",'2. Key Data Input'!$K$114,'2. Key Data Input'!$Q$114)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$125=\"no\",'2. Key Data Input'!$K$125,'2. Key Data Input'!$Q$125)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$132=\"no\",'2. Key Data Input'!$K$132,'2. Key Data Input'!$Q$132)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$140=\"no\",'2. Key Data Input'!$K$140,'2. Key Data Input'!$Q$140)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$148=\"no\",'2. Key Data Input'!$K$148,'2. Key Data Input'!$Q$148)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$160=\"no\",'2. Key Data Input'!$K$160,'2. Key Data Input'!$Q$160)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$167=\"no\",'2. Key Data Input'!$K$167,'2. Key Data Input'!$Q$167)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$175=\"no\",'2. Key Data Input'!$K$175,'2. Key Data Input'!$Q$175)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$183=\"no\",'2. Key Data Input'!$K$183,'2. Key Data Input'!$Q$183)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$195=\"no\",'2. Key Data Input'!$K$195,'2. Key Data Input'!$Q$195)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$202=\"no\",'2. Key Data Input'!$K$202,'2. Key Data Input'!$Q$202)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$210=\"no\",'2. Key Data Input'!$K$210,'2. Key Data Input'!$Q$210)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$218=\"no\",'2. Key Data Input'!$K$218,'2. Key Data Input'!$Q$218)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$229=\"no\",'2. Key Data Input'!$K$229,'2. Key Data Input'!$Q$229)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$236=\"no\",'2. Key Data Input'!$K$236,'2. Key Data Input'!$Q$236)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$244=\"no\",'2. Key Data Input'!$K$244,'2. Key Data Input'!$Q$244)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$252=\"no\",'2. Key Data Input'!$K$252,'2. Key Data Input'!$Q$252)","v":{"$error":"#N/A"}},{"$f":"'2. Key Data Input'!$Q$24","v":0},{"$f":"'2. Key Data Input'!$Q$31","v":0},{"$f":"'2. Key Data Input'!$Q$39","v":0},{"$f":"'2. Key Data Input'!$Q$47","v":0},{"$f":"'2. Key Data Input'!Q58","v":0},{"$f":"'2. Key Data Input'!Q65","v":0},{"$f":"'2. Key Data Input'!Q73","v":0},{"$f":"'2. Key Data Input'!Q81","v":0},{"$f":"'2. Key Data Input'!Q92","v":0},{"$f":"'2. Key Data Input'!Q99","v":0},{"$f":"'2. Key Data Input'!Q107","v":0},{"$f":"'2. Key Data Input'!Q115","v":0},{"$f":"'2. Key Data Input'!Q126","v":0},{"$f":"'2. Key Data Input'!Q133","v":0},{"$f":"'2. Key Data Input'!Q141","v":0},{"$f":"'2. Key Data Input'!Q149","v":0},{"$f":"'2. Key Data Input'!Q161","v":0},{"$f":"'2. Key Data Input'!Q168","v":0},{"$f":"'2. Key Data Input'!Q176","v":0},{"$f":"'2. Key Data Input'!Q184","v":0},{"$f":"'2. Key Data Input'!Q196","v":0},{"$f":"'2. Key Data Input'!Q203","v":0},{"$f":"'2. Key Data Input'!Q211","v":0},{"$f":"'2. Key Data Input'!Q219","v":0},{"$f":"'2. Key Data Input'!Q230","v":0},{"$f":"'2. Key Data Input'!Q237","v":0},{"$f":"'2. Key Data Input'!Q245","v":0},{"$f":"'2. Key Data Input'!Q253","v":0}]

{"sheet":"PRIOR DATA","index":9,"n_rows":145,"n_cols":58,"rows_kept":145,"cut":false,"hidden":true,"merged":[[0,3,2,57],[3,3,4,57],[6,1,7,6]]}
[null,null,null,"Employee Opportunities Plan Report"]
[]
[]
[null,null,null,"Prior Year Data Entry"]
[]
[]
[null,"Step 2: Click Copy Data Button on \"Data Export for Next FY\" Tab. "]
[]
[]
["Organization Name","Total Employees PFY2","Total Employees with Disabilities PFY2","Total Employees with Disabilities who are Leaders PFY2","Total Employees with Disabilities who are Executives PFY2","Total Veterans PFY2","Total Veterans with Disabilities PFY2","Total Veterans with Disabilities who are Leaders PFY2","Total Veterans with Disabilities who are Executives PFY2","Total Hires PFY2","Total Hires with Disabilities PFY2","Total Hires with Disabilities who are Leaders PFY2","Total Hires with Disabilities who are Executives PFY2","Total Separations PFY2","Total Separations with Disabilities PFY2","Total Separations with Disabilities who are Leaders PFY2","Total Separations with Disabilities who are Executives PFY2","Total Transfers PFY2","Total Transfers with Disabilities PFY2","Total Transfers with Disabilities who are Leaders PFY2","Total Transfers with Disabilities who are Executives PFY2","Total Internal Transfers PFY2","Total Internal Transfers with Disabilities PFY2","Total Internal Transfers with Disabilities who are Leaders PFY2","Total Internal Transfers with Disabilities who are Executives PFY2","Total Promotions PFY2","Total Promotions with Disabilities PFY2","Total Promotions with Disabilities who are Leaders PFY2","Total Promotions with Disabilities who are Executives PFY2","Total Employees PFY","Total Employees with Disabilities PFY","Total Employees with Disabilities who are Leaders PFY","Total Employees with Disabilities who are Executives PFY","Total Veterans PFY","Total Veterans with Disabilities PFY","Total Veterans with Disabilities who are Leaders PFY","Total Veterans with Disabilities who are Executives PFY","Total Hires PFY","Total Hires with Disabilities PFY","Total Hires with Disabilities who are Leaders PFY","Total Hires with Disabilities who are Executives PFY","Total Separations PFY","Total Separations with Disabilities PFY","Total Separations with Disabilities who are Leaders PFY","Total Separations with Disabilities who are Executives PFY","Total Transfers PFY","Total Transfers with Disabilities PFY","Total Transfers with Disabilities who are Leaders PFY","Total Transfers with Disabilities who are Executives PFY","Total Internal Transfers PFY","Total Internal Transfers with Disabilities PFY","Total Internal Transfers with Disabilities who are Leaders PFY","Total Internal Transfers with Disabilities who are Executives PFY","Total Promotions PFY","Total Promotions with Disabilities PFY","Total Promotions with Disabilities who are Leaders PFY","Total Promotions with Disabilities who are Executives PFY"," "]
["Assistive Technology Loan Fund Authority"]
["Blue Ridge Community College",93,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,0]
["Board of Accountancy",11,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0]
["Center for Innovative Technology"]
["Central Virginia Community College",74,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,0]
["Christopher Newport University",442,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,8,442,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
["Commonwealth's Attorneys' Services Council",4,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Compensation Board",14,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0]
["Dabney S. Lancaster Community College",40,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0]
["Danville Community College ",59,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0]
["Department for the Blind and Vision Impaired",155,157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,434,31]
["Department for the Deaf and Hard of Hearing",7,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,7,2,null,null,null,null,null,null,"8+AF13:AV14"]
["Department of Accounts",143,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,143,1]
["Department of Aging and Rehabilitative Services",1170,1017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1170,96]
["Department of Alcoholic Beverage Control",1105,1]
["Department of Aviation",33,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,33,1]
["Department of Behavioral Health and Developmental Services",6092,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6092,14]
["Department of Corrections",11046,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11046,30]
["Department of Criminal Justice Services",97,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,0]
["Department of Education",275,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,275,13]
["Department of Elections",30,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0]
["Department of Emergency Management",132,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,0]
["Department of Environmental Quality",773,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,773,0]
["Department of Forensic Science",289,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,289,1]
["Department of Forestry",233,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223,1]
["Department of Game and Inland Fisheries",434,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,434,1]
["Department of General Services",592,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,592,3]
["Department of Health Professions",209,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,209,0]
["Department of Historic Resources",39,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0]
["Department of Housing & Community Development",85,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,85,0]
["Department of Human Resources Management",100,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,0]
["Department of Juvenile Justice",1526,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1526,7]
["Department of Labor and Industry",141,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,141,1]
["Department of Medical Assistance Services",410,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,410,3]
["Department of Military Affairs",287,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,287,0]
["Department of Mines, Minerals, and Energy",187,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187,3]
["Department of Motor Vehicles",1892,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1892,29]
["Department of Planning and Budget",42,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,42,1]
["Department of Professional and Occupational Regulation",168,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,0]
["Department of Rail and Public Transportation",53,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0]
["Department of Small Business and Supplier Diversity",31,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0]
["Department of Social Services",1557,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1557,5]
["Department of State Police",2618,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2618,2]
["Department of Taxation",812,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,812,2]
["Department of the Treasury",103,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,0]
["Department of Transportation",7481,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,7481,0]
["Department of Veterans Services",430,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,430,0]
["Eastern Shore Community College",27,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0]
["Foundation for Healthy Youth",6,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0]
["Frontier Culture Museum of Virginia",31,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0]
["George Mason University",1728,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1728,3]
["Germanna Community College",133,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,113,0]
["Gunston Hall",3,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0]
["Institute for Advanced Learning and Research"]
["J. Sargeant Reynolds Community College",230,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,0]
["James Madison University",1388,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1388,1]
["Jamestown-Yorktown Foundation",119,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,119,1]
["John Tyler Community College",136,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,136,1]
["Library of Virginia",114,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,0]
["Longwood University",318,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318,7]
["Lord Fairfax Community College",115,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,1]
["Marine Resources Commission",144,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,0]
["Motor Vehicle Dealer Board"]
["Mountain Empire Community College",77,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,0]
["New College Institute",9,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0]
["New River Community College",48,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0]
["Norfolk State University",483,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,483,2]
["Northern Virginia Community College",854,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,854,2]
["Northern Virginia Mental Health Institute"]
["Office of Attorney General"]
["Office of Children's Services",13,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,13,1]
["Office of Public-Private Partnerships"]
["Office of the Governor"]
["Office of the Lieutenant Governor"]
["Office of the State Inspector General",35,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0]
["Old Dominion University",1053,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1053,13]
["Patrick Henry Community College",75,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,0]
["Paul D. Camp Community College",31,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0]
["Piedmont Virginia Community College",90,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,0]
["Radford University",523,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,523,7]
["Rappahannock Community College",55,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0]
["Richard Bland College",34,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0]
["Sitter and Barfoot Veterans Care Center",289,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,289,0]
["VCCS Shared Services Center"]
["Southern Virginia Higher Education Center",35,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0]
["Southside Virginia Community College",83,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,0]
["Southwest Virginia Community College",65,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0]
["Southwest Virginia Higher Education Center",22,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0]
["State Corporation Commission"]
["State Council for Higher Education for Virginia",34,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0]
["VCCS System Office"]
["The College of William and Mary",737,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,737,0]
["The Science Museum of Virginia",56,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,56,2]
["Thomas Nelson Community College",238,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,238,1]
["Tidewater Community College",501,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,501,1]
["University of Mary Washington",341,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,341,1]
["University of Virginia",970,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,970,0]
["University of Virginia at Wise",43,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0]
["University of Virginia Medical Center"]
["Virginia Board for People with Disabilities"]
["Virginia Commercial Space Flight Authority"]
["Virginia Commission for the Arts",3,0]
["Virginia Commonwealth University",2764,11]
["Virginia Commonwealth University Health Systems Authority"]
["Virginia Community College System",191,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191,0]
["Virginia Department of Agriculture and Consumer Services",439,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,439,2]
["Virginia Department of Conservation and Recreation",419,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,419,1]
["Virginia Department of Fire Programs",60,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0]
["Virginia 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,3207,6]
["Virginia Economic Development Partnership"]
["Virginia Employment Commission",679,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,679,46]
["Virginia Highlands Community College",46,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0]
["Virginia Housing Development Authority"]
["Virginia Information Technologies Agency",197,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,197,1]
["Virginia Lottery"]
["Virginia Institute for Marine Science",163,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,163,0]
["Virginia Military Institute",284,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,284,0]
["Virginia Museum of Fine Arts",134,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,134,1]
["Virginia Museum of Natural History",31,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0]
["Virginia Parole Board",8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["Virginia Polytechnic Institute and State University",1061,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1061,0]
["Virginia Port Authority"]
["Virginia Racing Commission",2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0]
["Virginia Resources Authority"]
["Virginia Retirement System"]
["Virginia School for the Deaf and the Blind",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,0]
["Virginia State University",317,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,317,3]
["Virginia Tobacco Region Revitalization Commission"]
["Virginia Tourism Corporation"]
["Virginia Western Community College",121,0]
["Virginia Workers' Compensation Commission"]
["Virginia Workforce Connection"]
["Virginia529 College Savings Plan"]
["Wilson Workforce Rehabilitation Center"]
["Wytheville Community College",39,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0]

{"sheet":"DASHBOARD DATA EXPORT","index":10,"n_rows":10,"n_cols":174,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,6,2,175],[3,6,4,175]]}
[null,null,null,null,null,null,"Employee Opportunities Plan Report"]
[]
[]
[null,null,null,null,null,null,"Dashboard Data Export"]
[]
[]
[]
[]
[null,"Agency Name","Brief Summary","Job Fair","Partnerships with Other Organizations","Internal Talent","Confernces","Other","Other Specicied","Description of Recruitment Strategies","Provides disability friendly job postings and interviews","Provides disability friendly job postings and interviews Description","Hosts careef fairs dedicated to people with disabilities","Hosts careef fairs dedicated to people with disabilities description","Facilitiates a disability friendly workplace culture","Facilitiates a disability friendly workplace culture description","Evaluates faciity and workplace accessibility","Evaluates faciity and workplace accessibility description","Evaluates website and digital accessibility.","Evaluates website and digital accessibility description","Facilitates training for leaders regarding employment of individuals with disabilities","Facilitates training for leaders regarding employment of individuals with disabilities description","Promote interactive discussions with candidates and emplloyees regarding accomodations needs. ","Promote interactive discussions with candidates and emplloyees regarding accomodations needs description","Has a workpalce mentoring program for employees with disabilities. ","Has a workpalce mentoring program for employees with disabilities description","Provides job shadowing opportunities for employees with disabilities. ","Provides job shadowing opportunities for employees with disabilities description","Total Employees PFY2","Total Employees with Disabilities PFY2","Total Employees with Disabilities who are Leaders PFY2","Total Employees with Disabilities who are Executives PFY2","Total Veterans PFY2","Total Veterans with Disabilities PFY2","Total Veterans with Disabilities who are Leaders PFY2","Total Veterans with Disabilities who are Executives PFY2","Total Hires PFY2","Total Hires with Disabilities PFY2","Total Hires with Disabilities who are Leaders PFY2","Total Hires with Disabilities who are Executives PFY2","Total Separations PFY2","Total Separations with Disabilities PFY2","Total Separations with Disabilities who are Leaders PFY2","Total Separations with Disabilities who are Executives PFY2","Total Transfers PFY2","Total Transfers with Disabilities PFY2","Total Transfers with Disabilities who are Leaders PFY2","Total Transfers with Disabilities who are Executives PFY2","Total Internal Transfers PFY2","Total Internal Transfers with Disabilities PFY2","Total Internal Transfers with Disabilities who are Leaders PFY2","Total Internal Transfers with Disabilities who are Executives PFY2","Total Promotions PFY2","Total Promotions with Disabilities PFY2","Total Promotions with Disabilities who are Leaders PFY2","Total Promotions with Disabilities who are Executives PFY2","Total Employees PFY2","Total Employees with Disabilities PFY2","Total Employees with Disabilities who are Leaders PFY2","Total Employees with Disabilities who are Executives PFY2","Total Veterans PFY2","Total Veterans with Disabilities PFY2","Total Veterans with Disabilities who are Leaders PFY2","Total Veterans with Disabilities who are Executives PFY2","Total Hires PFY2","Total Hires with Disabilities PFY2","Total Hires with Disabilities who are Leaders PFY2","Total Hires with Disabilities who are Executives PFY2","Total Separations PFY2","Total Separations with Disabilities PFY2","Total Separations with Disabilities who are Leaders PFY2","Total Separations with Disabilities who are Executives PFY2","Total Transfers PFY2","Total Transfers with Disabilities PFY2","Total Transfers with Disabilities who are Leaders PFY2","Total Transfers with Disabilities who are Executives PFY2","Total Internal Transfers PFY2","Total Internal Transfers with Disabilities PFY2","Total Internal Transfers with Disabilities who are Leaders PFY2","Total Internal Transfers with Disabilities who are Executives PFY2","Total Promotions PFY2","Total Promotions with Disabilities PFY2","Total Promotions with Disabilities who are Leaders PFY2","Total Promotions with Disabilities who are Executives PFY2","Total Employees PFY","Total Employees with Disabilities PFY","Total Employees with Disabilities who are Leaders PFY","Total Employees with Disabilities who are Executives PFY","Total Veterans PFY","Total Veterans with Disabilities PFY","Total Veterans with Disabilities who are Leaders PFY","Total Veterans with Disabilities who are Executives PFY","Total Hires PFY","Total Hires with Disabilities PFY","Total Hires with Disabilities who are Leaders PFY","Total Hires with Disabilities who are Executives PFY","Total Separations PFY","Total Separations with Disabilities PFY","Total Separations with Disabilities who are Leaders PFY","Total Separations with Disabilities who are Executives PFY","Total Transfers PFY","Total Transfers with Disabilities PFY","Total Transfers with Disabilities who are Leaders PFY","Total Transfers with Disabilities who are Executives PFY","Total Internal Transfers PFY","Total Internal Transfers with Disabilities PFY","Total Internal Transfers with Disabilities who are Leaders PFY","Total Internal Transfers with Disabilities who are Executives PFY","Total Promotions PFY","Total Promotions with Disabilities PFY","Total Promotions with Disabilities who are Leaders PFY","Total Promotions with Disabilities who are Executives PFY","Review of Prior Actions","Number of Actions","Action 1 Type","Other Description1","Action 1 Description","Action 1 Timeframe","Action 1 Impacts","Action 1 Obstacles","Action 2 Type","Other Description2","Action 2 Description","Action 2 Timeframe","Action 2 Impacts","Action 2 Obstacles","Action 3 Type","Other 3 Description","Action 3 Description","Action 3 Timeframe","Action 3 Impacts","Action 3 Obstacles","Action 4 Type","Other 4 Description","Action 4 Description","Action 4 Timeframe","Action 4 Impacts","Action 4 Obstacles","Action 5 Type","Other 5 Description","Action 5 Description","Action 5 Timeframe","Action 5 Impacts","Action 5 Obstacles","Action 6 Type","Other 6 Description","Action 6 Description","Action 6 Timeframe","Action 6 Impacts","Action 6 Obstacles","Action 7 Type","Other 7 Description","Action 7 Description","Action 7 Timeframe","Action 7 Impacts","Action 7 Obstacles","Action 8 Type","Other 8 Description","Action 8 Description","Action 8 Timeframe","Action 8 Impacts","Action 8 Obstacles","Action 9 Type","Other 9 Description","Action 9 Description","Action 9 Timeframe","Action 9 Impacts","Action 9 Obstacles","Action 10 Type","Other 10 Description","Action 10 Description","Action 10 Timeframe","Action 10 Impacts","Action 10 Obstacles"]
[null,{"$f":"'1. Agency Profile'!G12","v":0},{"$f":"'1. Agency Profile'!F22","v":0},{"$f":"IF('1. Agency Profile'!AF42=1,\"yes\",\"no\")","v":"no"},{"$f":"IF('1. Agency Profile'!AG42=1,\"yes\",\"no\")","v":"no"},{"$f":"IF('1. Agency Profile'!AH42=1,\"yes\",\"no\")","v":"no"},{"$f":"IF('1. Agency Profile'!AI42=1,\"yes\",\"no\")","v":"no"},{"$f":"IF('1. Agency Profile'!AJ42=1,\"yes\",\"no\")","v":"no"},{"$f":"'1. Agency Profile'!U41","v":0},{"$f":"'1. Agency Profile'!K44","v":0},{"$f":"IF('1. Agency Profile'!AF50=1,\"Continued\",IF('1. Agency Profile'!AG50=1,\"Started\",IF('1. Agency Profile'!AH50=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N49","v":0},{"$f":"IF('1. Agency Profile'!$AF53=1,\"Continued\",IF('1. Agency Profile'!$AG53=1,\"Started\",IF('1. Agency Profile'!$AH53=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N52","v":0},{"$f":"IF('1. Agency Profile'!$AF59=1,\"Continued\",IF('1. Agency Profile'!$AG59=1,\"Started\",IF('1. Agency Profile'!$AH59=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N58","v":0},{"$f":"IF('1. Agency Profile'!$AF62=1,\"Continued\",IF('1. Agency Profile'!$AG62=1,\"Started\",IF('1. Agency Profile'!$AH62=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N61","v":0},{"$f":"IF('1. Agency Profile'!$AF65=1,\"Continued\",IF('1. Agency Profile'!$AG65=1,\"Started\",IF('1. Agency Profile'!$AH65=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N64","v":0},{"$f":"IF('1. Agency Profile'!$AF68=1,\"Continued\",IF('1. Agency Profile'!$AG68=1,\"Started\",IF('1. Agency Profile'!$AH68=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N67","v":0},{"$f":"IF('1. Agency Profile'!$AF71=1,\"Continued\",IF('1. Agency Profile'!$AG71=1,\"Started\",IF('1. Agency Profile'!$AH71=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N70","v":0},{"$f":"IF('1. Agency Profile'!$AF77=1,\"Continued\",IF('1. Agency Profile'!$AG77=1,\"Started\",IF('1. Agency Profile'!$AH77=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N76","v":0},{"$f":"IF('1. Agency Profile'!$AF80=1,\"Continued\",IF('1. Agency Profile'!$AG80=1,\"Started\",IF('1. Agency Profile'!$AH80=1,\"Not Used\",0)))","v":0},{"$f":"'1. Agency Profile'!N79","v":0},{"$f":"IF('2. Key Data Input'!$N$22=\"no\",'2. Key Data Input'!$K$22,'2. Key Data Input'!$Q$22)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$29=\"no\",'2. Key Data Input'!$K$29,'2. Key Data Input'!$Q$29)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$37=\"no\",'2. Key Data Input'!$K$37,'2. Key Data Input'!$Q$37)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$46=\"no\",'2. Key Data Input'!$K$46,'2. Key Data Input'!$Q$46)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$56=\"no\",'2. Key Data Input'!$K$56,'2. Key Data Input'!$Q$56)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$63=\"no\",'2. Key Data Input'!$K$63,'2. Key Data Input'!$Q$63)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$72=\"no\",'2. Key Data Input'!$K$72,'2. Key Data Input'!$Q$72)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$79=\"no\",'2. Key Data Input'!$K$79,'2. Key Data Input'!$Q$79)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$90=\"no\",'2. Key Data Input'!$K$90,'2. Key Data Input'!$Q$90)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$97=\"no\",'2. Key Data Input'!$K$97,'2. Key Data Input'!$Q$97)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$105=\"no\",'2. Key Data Input'!$K$105,'2. Key Data Input'!$Q$105)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$113=\"no\",'2. Key Data Input'!$K$113,'2. Key Data Input'!$Q$113)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$124=\"no\",'2. Key Data Input'!$K$124,'2. Key Data Input'!$Q$124)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$131=\"no\",'2. Key Data Input'!$K$131,'2. Key Data Input'!$Q$131)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$139=\"no\",'2. Key Data Input'!$K$139,'2. Key Data Input'!$Q$139)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$147=\"no\",'2. Key Data Input'!$K$147,'2. Key Data Input'!$Q$147)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$159=\"no\",'2. Key Data Input'!$K$159,'2. Key Data Input'!$Q$159)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$166=\"no\",'2. Key Data Input'!$K$166,'2. Key Data Input'!$Q$166)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$174=\"no\",'2. Key Data Input'!$K$174,'2. Key Data Input'!$Q$174)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$182=\"no\",'2. Key Data Input'!$K$182,'2. Key Data Input'!$Q$182)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$194=\"no\",'2. Key Data Input'!$K$194,'2. Key Data Input'!$Q$194)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$201=\"no\",'2. Key Data Input'!$K$201,'2. Key Data Input'!$Q$201)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$209=\"no\",'2. Key Data Input'!$K$209,'2. Key Data Input'!$Q$209)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$217=\"no\",'2. Key Data Input'!$K$217,'2. Key Data Input'!$Q$217)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$228=\"no\",'2. Key Data Input'!$K$228,'2. Key Data Input'!$Q$228)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$235=\"no\",'2. Key Data Input'!$K$235,'2. Key Data Input'!$Q$235)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$243=\"no\",'2. Key Data Input'!$K$243,'2. Key Data Input'!$Q$243)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$251=\"no\",'2. Key Data Input'!$K$251,'2. Key Data Input'!$Q$251)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$23=\"no\",'2. Key Data Input'!$K$23,'2. Key Data Input'!$Q$23)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$30=\"no\",'2. Key Data Input'!$K$30,'2. Key Data Input'!$Q$30)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$38=\"no\",'2. Key Data Input'!$K$38,'2. Key Data Input'!$Q$38)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$47=\"no\",'2. Key Data Input'!$K$47,'2. Key Data Input'!$Q$47)","v":0},{"$f":"IF('2. Key Data Input'!$N$57=\"no\",'2. Key Data Input'!$K$57,'2. Key Data Input'!$Q$57)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$64=\"no\",'2. Key Data Input'!$K$64,'2. Key Data Input'!$Q$64)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$73=\"no\",'2. Key Data Input'!$K$73,'2. Key Data Input'!$Q$73)","v":0},{"$f":"IF('2. Key Data Input'!$N$80=\"no\",'2. Key Data Input'!$K$80,'2. Key Data Input'!$Q$80)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$91=\"no\",'2. Key Data Input'!$K$91,'2. Key Data Input'!$Q$91)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$98=\"no\",'2. Key Data Input'!$K$98,'2. Key Data Input'!$Q$98)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$106=\"no\",'2. Key Data Input'!$K$106,'2. Key Data Input'!$Q$106)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$114=\"no\",'2. Key Data Input'!$K$114,'2. Key Data Input'!$Q$114)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$125=\"no\",'2. Key Data Input'!$K$125,'2. Key Data Input'!$Q$125)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$132=\"no\",'2. Key Data Input'!$K$132,'2. Key Data Input'!$Q$132)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$140=\"no\",'2. Key Data Input'!$K$140,'2. Key Data Input'!$Q$140)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$148=\"no\",'2. Key Data Input'!$K$148,'2. Key Data Input'!$Q$148)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$160=\"no\",'2. Key Data Input'!$K$160,'2. Key Data Input'!$Q$160)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$167=\"no\",'2. Key Data Input'!$K$167,'2. Key Data Input'!$Q$167)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$175=\"no\",'2. Key Data Input'!$K$175,'2. Key Data Input'!$Q$175)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$183=\"no\",'2. Key Data Input'!$K$183,'2. Key Data Input'!$Q$183)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$195=\"no\",'2. Key Data Input'!$K$195,'2. Key Data Input'!$Q$195)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$202=\"no\",'2. Key Data Input'!$K$202,'2. Key Data Input'!$Q$202)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$210=\"no\",'2. Key Data Input'!$K$210,'2. Key Data Input'!$Q$210)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$218=\"no\",'2. Key Data Input'!$K$218,'2. Key Data Input'!$Q$218)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$229=\"no\",'2. Key Data Input'!$K$229,'2. Key Data Input'!$Q$229)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$236=\"no\",'2. Key Data Input'!$K$236,'2. Key Data Input'!$Q$236)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$244=\"no\",'2. Key Data Input'!$K$244,'2. Key Data Input'!$Q$244)","v":{"$error":"#N/A"}},{"$f":"IF('2. Key Data Input'!$N$252=\"no\",'2. Key Data Input'!$K$252,'2. Key Data Input'!$Q$252)","v":{"$error":"#N/A"}},{"$f":"'2. Key Data Input'!$Q$24","v":0},{"$f":"'2. Key Data Input'!$Q$31","v":0},{"$f":"'2. Key Data Input'!$Q$39","v":0},{"$f":"'2. Key Data Input'!$Q$47","v":0},{"$f":"'2. Key Data Input'!Q58","v":0},{"$f":"'2. Key Data Input'!Q65","v":0},{"$f":"'2. Key Data Input'!Q73","v":0},{"$f":"'2. Key Data Input'!Q81","v":0},{"$f":"'2. Key Data Input'!Q92","v":0},{"$f":"'2. Key Data Input'!Q99","v":0},{"$f":"'2. Key Data Input'!Q107","v":0},{"$f":"'2. Key Data Input'!Q115","v":0},{"$f":"'2. Key Data Input'!Q126","v":0},{"$f":"'2. Key Data Input'!Q133","v":0},{"$f":"'2. Key Data Input'!Q141","v":0},{"$f":"'2. Key Data Input'!Q149","v":0},{"$f":"'2. Key Data Input'!Q161","v":0},{"$f":"'2. Key Data Input'!Q168","v":0},{"$f":"'2. Key Data Input'!Q176","v":0},{"$f":"'2. Key Data Input'!Q184","v":0},{"$f":"'2. Key Data Input'!Q196","v":0},{"$f":"'2. Key Data Input'!Q203","v":0},{"$f":"'2. Key Data Input'!Q211","v":0},{"$f":"'2. Key Data Input'!Q219","v":0},{"$f":"'2. Key Data Input'!Q230","v":0},{"$f":"'2. Key Data Input'!Q237","v":0},{"$f":"'2. Key Data Input'!Q245","v":0},{"$f":"'2. Key Data Input'!Q253","v":0},{"$f":"'3. Plan Information'!F15","v":0},{"$f":"'3. Plan Information'!N28","v":0},{"$f":"'3. Plan Information'!I34","v":0},{"$f":"'3. Plan Information'!R34","v":0},{"$f":"'3. Plan Information'!I36","v":0},{"$f":"'3. Plan Information'!I41","v":0},{"$f":"'3. Plan Information'!I43","v":0},{"$f":"'3. Plan Information'!I48","v":0},{"$f":"'3. Plan Information'!I55","v":0},{"$f":"'3. Plan Information'!R55","v":0},{"$f":"'3. Plan Information'!I57","v":0},{"$f":"'3. Plan Information'!I62","v":0},{"$f":"'3. Plan Information'!I64","v":0},{"$f":"'3. Plan Information'!I69","v":0},{"$f":"'3. Plan Information'!I76","v":0},{"$f":"'3. Plan Information'!R76","v":0},{"$f":"'3. Plan Information'!I78","v":0},{"$f":"'3. Plan Information'!I83","v":0},{"$f":"'3. Plan Information'!I85","v":0},{"$f":"'3. Plan Information'!I90","v":0},{"$f":"'3. Plan Information'!I97","v":0},{"$f":"'3. Plan Information'!R97","v":0},{"$f":"'3. Plan Information'!I99","v":0},{"$f":"'3. Plan Information'!I104","v":0},{"$f":"'3. Plan Information'!I106","v":0},{"$f":"'3. Plan Information'!I111","v":0},{"$f":"'3. Plan Information'!I118","v":0},{"$f":"'3. Plan Information'!R118","v":0},{"$f":"'3. Plan Information'!I120","v":0},{"$f":"'3. Plan Information'!I125","v":0},{"$f":"'3. Plan Information'!I127","v":0},{"$f":"'3. Plan Information'!I132","v":0},{"$f":"'3. Plan Information'!I139","v":0},{"$f":"'3. Plan Information'!R139","v":0},{"$f":"'3. Plan Information'!I141","v":0},{"$f":"'3. Plan Information'!I146","v":0},{"$f":"'3. Plan Information'!I148","v":0},{"$f":"'3. Plan Information'!I153","v":0},{"$f":"'3. Plan Information'!I160","v":0},{"$f":"'3. Plan Information'!R160","v":0},{"$f":"'3. Plan Information'!I162","v":0},{"$f":"'3. Plan Information'!I167","v":0},{"$f":"'3. Plan Information'!I169","v":0},{"$f":"'3. Plan Information'!I174","v":0},{"$f":"'3. Plan Information'!I181","v":0},{"$f":"'3. Plan Information'!R181","v":0},{"$f":"'3. Plan Information'!I183","v":0},{"$f":"'3. Plan Information'!I188","v":0},{"$f":"'3. Plan Information'!I190","v":0},{"$f":"'3. Plan Information'!I195","v":0},{"$f":"'3. Plan Information'!I202","v":0},{"$f":"'3. Plan Information'!R202","v":0},{"$f":"'3. Plan Information'!I204","v":0},{"$f":"'3. Plan Information'!I209","v":0},{"$f":"'3. Plan Information'!I211","v":0},{"$f":"'3. Plan Information'!I216","v":0},{"$f":"'3. Plan Information'!I223","v":0},{"$f":"'3. Plan Information'!R223","v":0},{"$f":"'3. Plan Information'!I225","v":0},{"$f":"'3. Plan Information'!I230","v":0},{"$f":"'3. Plan Information'!I232","v":0},{"$f":"'3. Plan Information'!I237","v":0}]