{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Priority 1","Priority 2","Priority 3","Priority 4","Priority 5","Priority 6","Supporting Activites","Drop downs"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":4,"n_cols":25,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,0,210,23]]}
[]
["Instructions"]
[]
["These instructions provide information on the prevention work plan templated developed for Regional Behavioral Health Authorities. The work plan template is designed to provide a comprehensive view of prevention work completed throughout each region. \n\nStructure:\nUsers can navigate through the template by clicking the worksheet tabs at the bottom of the screen. Below is an example of the worksheet's tabs:\n\n\n\nWork Plan Template\nA work plan represents the formal road map for a project. It should clearly articulate the required steps to achieve a stated goal by setting demonstrable activities and measurable deliverables that can be transformed into concrete actions. As reflected in the template’s worksheet tabs, the work plan is divided into six tabs: Priorities 1 through 6 and Supporting Activities. Each Priority tab will allow you to enter work plan activities by priority. Each Region is required to work on Priorities 1, 2, and 3. Priorities 4, 5, and 6 are optional and provide Regions the opportunity to select additional targeted substances to focus prevention efforts within the Region's geographic area. Substances that can be targeted with Substance Use Prevention Treatement Recovery Service Block Grant (SUPTRS BG) funds include: Alcohol, Tobacco, Marijuana, Prescription Drugs, Heroin, Inhalants, and Synthetic Drugs. \n\nRegional Goal Statement: \nFor each priority, a regional goal statement should be developed. This statement should focus on what the Region would like to accomplish. A goal statement defines the specific goal you wish to achieve, how you will achieve it, and why you are pursuing this goal. A goal statement serves as a guideline on how to achieve your goal. It is crucial since it will help you plan the measures you need to take to get there. \n\nSMART Activity: \nList the key activities you are proposing to do during the grant year to accomplish the performance measures for each priority. Activities should be specific, measurable, achievable, relevant and time-bound. Enough detail should be provided about the work proposed in the next year so DHHS is clear on the critical actions you will take toward the achievement of major milestones. Regions will need to report out on all the activities listed under each priority. \n\n\n\n\n\n\n\n\n\n\n\n\nNPIRS Activity: \nUse the drop down to select the specific NPIRS activity corresponding to the previously answered SMART activity. When reporting completed prevention activity data later in the year, NPIRS users should report the activity as indicated in this column. If the activity is not in the drop-down, select “Other”. Please do not attempt to overwrite the drop-down column with text.  \n\n\n\n\n\n\n\n\n\n\n\n\nReporting Organization:\nFor each activity, identify the organization, either the region or coalition, that will report the data in NPIRS.  \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nActivity Location: \nIdentify the county or counties where the activity will take place. \n\n\n\n\n\n\n\n\n\n\nTimeframe Start and End Quarter:\nSelect Q1, Q2, Q3, or Q4 from the drop down menu for the timeframe. If the activity is ongoing, select the quarters in which it will be active. Even if the activity will continue into future years, only include the quarters in this current year when it will be active. Year 1 will only include quarters 2 through 4.\n\n\n\n\n\n\n\n\n\n\n\n\nProcess and Outcome Measures:\nPlease provide at least two types of measures. One measure, called a process measure, should indicate how many people were served or reached by the activity. Another measure, known as an outcome measure, should indicate the impact of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. \n\n\n\n\n\n\n\n\n\n\n\n\n\n\nSupporting Activities\nIn this worksheet tab, please report activities that support the Region's efforts towards SAPTBG Priorities but are not funded by SAPTBG funds. List the supporting activity, provide a description of the activity, and the contributing partners/coalitions. List the funding sources that pay for that activity and identify the select from the drop down options provided which SAPTBG priority the supportive activity helps support. \n\n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These instructions provide information on the prevention work plan templated developed for Regional Behavioral Health Authorities. The work plan template is designed to provide a comprehensive view of prevention work completed throughout each region. \n\nStructure:\nUsers can navigate through the template by clicking the worksheet tabs at the bottom of the screen. Below is an example of the worksheet's tabs:\n\n\n\nWork Plan Template\nA work plan represents the formal road map for a project. It should clearly articulate the required steps to achieve a stated goal by setting demonstrable activities and measurable deliverables that can be transformed into concrete actions. As reflected in the template’s worksheet tabs, the work plan is divided into six tabs: Priorities 1 through 6 and Supporting Activities. Each Priority tab will allow you to enter work plan activities by priority. Each Region is required to work on Priorities 1, 2, and 3. Priorities 4, 5, and 6 are optional and provide Regions the opportunity to select additional targeted substances to focus prevention efforts within the Region's geographic area. Substances that can be targeted with Substance Use Prevention Treatement Recovery Service Block Grant (SUPTRS BG) funds include: Alcohol, Tobacco, Marijuana, Prescription Drugs, Heroin, Inhalants, and Synthetic Drugs. \n\nRegional Goal Statement: \nFor each priority, a regional goal statement should be developed. This statement should focus on what the Region would like to accomplish. A goal statement defines the specific goal you wish to achieve, how you will achieve it, and why you are pursuing this goal. A goal statement serves as a guideline on how to achieve your goal. It is crucial since it will help you plan the measures you need to take to get there. \n\nActivity Description: \nList the key activities you are proposing to do during the grant year to accomplish the performance measures for each priority. Activities should be specific, measurable, achievable, relevant and time-bound. Enough detail should be provided about the work proposed in the next year so DHHS is clear on the critical actions you will take toward the achievement of major milestones. Regions will need to report out on all the activities listed under each priority. \n\n\n\n\n\n\n\n\n\n\n\n\nNPIRS Activity: \nFor each SMART Activity indicate from the drop down options the NPIRS activity description that will be used when reporting activities in NPIRS. All activities must be entered into NPIRS 30 days after its completion. NPIRS training is available upon request for Regions and coalitions. If the activity is not in NPRIS select 'other' from the drop down menu. \n\n\n\n\n\n\n\n\n\n\n\n\nRegion, Coalition or Partner:\nFor each activity, identify who will be responsible for carrying out the activity. All coalitions, contractors, etc. listed in the budget section should be reflected in the activities in the work plan. If an activity is shared by more than one organization, coalition, etc., separate activities should be created for each. For example, if both Coalition A and Coalition B are implementing the same evidence-based program/practice then Coalition A and Coalition B will  need  separate activities created. This is due to potentially different outcomes experienced by each coalition. Coalition A might get one result whereas, Coalition B might get another. \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nActivity Location: \nIdentify the county or counties where the activity will take place. \n\n\n\n\n\n\n\n\n\n\nTimeframe Start and End Quarter:\nSelect Q1, Q2, Q3, or Q4 from the drop down menu for the timeframe. If the activity is ongoing, select the quarters in which it will be active. Even if the activity will continue into future years, only include the quarters in this current year when it will be active. Year 1 will only include quarters 2 through 4.\n\n\n\n\n\n\n\n\n\n\n\n\nDesired Outcomes (data driven):\nA performance measure is a numeric description of the activity and the results of that work. Performance measures are based on data, and tell a story about whether an agency or activity is achieving its objectives and if progress is being made toward the goal.  Consider available data sources and metrics when writing a desired outcome statement. At least one performance outcome should be developed for each activity.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nSupporting Activities\nIn this worksheet tab, please report activities that support the Region's efforts towards SAPTBG Priorities but are not funded by SAPTBG funds. List the supporting activity, provide a description of the activity, and the contributing partners/coalitions. List the funding sources that pay for that activity and identify the select from the drop down options provided which SAPTBG priority the supportive activity helps support. \n\n\n"]

{"sheet":"Priority 1","index":1,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[53,27,53,30],[49,19,53,20],[49,21,49,24],[49,27,49,30],[50,15,50,16],[50,21,50,24],[50,27,50,30],[51,15,51,16],[51,21,51,24],[51,27,51,30],[52,15,52,16],[49,1,53,1],[49,2,53,5],[49,6,53,8],[49,11,53,14],[49,15,49,16],[49,17,53,18],[47,15,47,16],[47,21,47,24],[47,27,47,30],[48,15,48,16],[48,21,48,24],[48,27,48,30],[44,17,48,18],[44,19,48,20],[44,21,44,24],[44,27,44,30],[45,15,45,16],[45,21,45,24],[45,27,45,30],[46,15,46,16],[46,21,46,24],[46,27,46,30],[52,21,52,24],[52,27,52,30],[44,1,48,1],[44,2,48,5],[44,6,48,8],[44,11,48,14],[44,15,44,16],[39,19,43,20],[39,21,39,24],[39,27,39,30],[40,15,40,16],[40,21,40,24],[40,27,40,30],[41,15,41,16],[41,21,41,24],[41,27,41,30],[42,15,42,16],[39,1,43,1],[39,2,43,5],[39,6,43,8],[39,11,43,14],[39,15,39,16],[39,17,43,18],[42,21,42,24],[42,27,42,30],[43,15,43,16],[37,27,37,30],[38,15,38,16],[38,21,38,24],[38,27,38,30],[35,15,35,16],[35,21,35,24],[35,27,35,30],[36,15,36,16],[36,21,36,24],[36,27,36,30],[43,27,43,30],[33,27,33,30],[34,1,38,1],[34,2,38,5],[34,6,38,8],[34,11,38,14],[34,15,34,16],[34,17,38,18],[34,19,38,20],[34,21,34,24],[34,27,34,30],[29,19,33,20],[30,15,30,16],[31,15,31,16],[31,21,31,24],[31,27,31,30],[32,15,32,16],[32,21,32,24],[32,27,32,30],[33,15,33,16],[33,21,33,24],[29,1,33,1],[29,2,33,5],[37,15,37,16],[29,6,33,8],[29,11,33,14],[29,15,29,16],[29,17,33,18],[24,15,24,16],[24,17,28,18],[24,19,28,20],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[24,9,28,9],[24,10,28,10],[29,9,33,9],[29,10,33,10],[30,27,30,30],[7,6,13,8],[7,11,13,14],[14,11,18,14],[14,6,18,8],[27,21,27,24],[27,27,27,30],[28,21,28,24],[28,27,28,30],[29,21,29,24],[29,27,29,30],[22,21,22,24],[22,27,22,30],[23,21,23,24],[23,27,23,30],[19,21,19,24],[19,27,19,30],[20,21,20,24],[20,27,20,30],[21,21,21,24],[21,27,21,30],[13,21,13,24],[13,27,13,30],[23,15,23,16],[7,10,13,10],[14,9,18,9],[1,1,1,30],[2,1,2,30],[3,1,3,30],[4,1,6,30],[7,1,13,5],[7,17,12,20],[7,21,12,30],[16,21,16,24],[16,27,16,30],[7,15,13,16],[14,15,14,16],[15,15,15,16],[7,9,13,9],[14,10,18,10],[13,17,13,18],[14,17,18,18],[13,19,13,20],[14,19,18,20],[14,1,18,1],[14,2,18,5],[16,15,16,16],[17,15,17,16],[18,27,18,30],[14,21,14,24],[14,27,14,30],[15,21,15,24],[15,27,15,30],[17,21,17,24],[17,27,17,30],[24,1,28,1],[24,2,28,5],[24,6,28,8],[24,11,28,14],[24,21,24,24],[24,27,24,30],[25,21,25,24],[25,27,25,30],[26,21,26,24],[26,27,26,30],[19,1,23,1],[19,2,23,5],[19,6,23,8],[19,11,23,14],[19,17,23,18],[22,15,22,16],[19,15,19,16],[34,9,38,9],[34,10,38,10],[39,9,43,9],[39,10,43,10],[44,9,48,9],[44,10,48,10],[49,9,53,9],[49,10,53,10],[18,21,18,24],[30,21,30,24],[19,19,23,20],[20,15,20,16],[21,15,21,16],[18,15,18,16],[19,9,23,9],[19,10,23,10],[43,21,43,24],[37,21,37,24],[53,15,53,16],[53,21,53,24]]}
[]
[null,"Priority #1: Maintain the Annual Compliance Rate of Tobacco Retailer Violations "]
[null,"Regional Goal Statement: "]
[null,"A goal statement is a clear picture view of what is to be accomplished and represents the priority. The goal statement should clearly and unmistakably point at the benefits that will be gained. "]
[]
[]
[]
[null,"SMART Activity \n      Specific = Who and What?\n      Measurable = By how much?\n      Achievable = How?\n      Relevant = Why?\n      Time-Bound = When?",null,null,null,null,"NPIRS Activity\nFor each activity select the corresponding NPIRS activity from the drop down options provided. If there is no NPIRS activity then select other. \n\nPlease do not overwrite the dropdown menu by typing text into this column.",null,null,"Work Plan ID\nLeave this field blank. DBH will populate this field after reviewing. NPIRS users will indicate the work plan ID when reporting the activity.","Strategy\nThis field populates based on the selection of the NPIRS Activity and identifies the activity's strategy type. ","Reporting Organization\nIdentify the organization that will report the activity in NPIRS. ",null,null,null,"Activity Location\nIdentify the county or counties where the activity will take place.",null,"Timeframe\nSelect Q1, Q2, Q3, or Q4 from the drop down menu. If the activity is ongoing, select the quarters in which it will be active.",null,null,null,"Process and Outcome Metrics\nIdentify at least one process measure and one outcome measure for each activity - along with a baseline and target for each. The process measure should indicate the number of persons served or reached by the activity. The outcome measure should provide evidence about the effectiveness of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,"Measures",null,null,null,"Baseline","Target","Data Source"]
[null,"1)",null,null,null,null,null,null,null,null,{"$f":"IF(G15 = \"\",\"\",VLOOKUP(G15,'Drop downs'!A2:H174,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"2)",null,null,null,null,null,null,null,null,{"$f":"IF(G20 = \"\",\"\",VLOOKUP(G20,'Drop downs'!A7:H179,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"3)",null,null,null,null,null,null,null,null,{"$f":"IF(G25 = \"\",\"\",VLOOKUP(G25,'Drop downs'!A12:H184,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"4)",null,null,null,null,null,null,null,null,{"$f":"IF(G30 = \"\",\"\",VLOOKUP(G30,'Drop downs'!A17:H189,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"5)",null,null,null,null,null,null,null,null,{"$f":"IF(G35 = \"\",\"\",VLOOKUP(G35,'Drop downs'!A22:H194,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"6)",null,null,null,null,null,null,null,null,{"$f":"IF(G40 = \"\",\"\",VLOOKUP(G40,'Drop downs'!A27:H199,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"7)",null,null,null,null,null,null,null,null,{"$f":"IF(G45 = \"\",\"\",VLOOKUP(G45,'Drop downs'!A32:H204,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"8)",null,null,null,null,null,null,null,null,{"$f":"IF(G50 = \"\",\"\",VLOOKUP(G50,'Drop downs'!A37:H209,2,FALSE))","v":""}]

{"sheet":"Priority 2","index":2,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,19,53,20],[49,21,49,24],[49,27,49,30],[50,15,50,16],[50,21,50,24],[50,27,50,30],[51,15,51,16],[51,21,51,24],[51,27,51,30],[52,15,52,16],[52,21,52,24],[52,27,52,30],[53,15,53,16],[53,21,53,24],[53,27,53,30],[49,17,53,18],[44,19,48,20],[44,21,44,24],[44,27,44,30],[45,15,45,16],[45,21,45,24],[45,27,45,30],[46,15,46,16],[46,21,46,24],[46,27,46,30],[47,15,47,16],[47,21,47,24],[47,27,47,30],[48,15,48,16],[48,21,48,24],[48,27,48,30],[39,19,43,20],[39,21,39,24],[39,27,39,30],[40,15,40,16],[40,21,40,24],[40,27,40,30],[41,15,41,16],[41,21,41,24],[41,27,41,30],[42,15,42,16],[42,21,42,24],[42,27,42,30],[43,15,43,16],[43,21,43,24],[43,27,43,30],[34,19,38,20],[34,21,34,24],[34,27,34,30],[35,15,35,16],[35,21,35,24],[35,27,35,30],[36,15,36,16],[36,21,36,24],[36,27,36,30],[37,15,37,16],[37,21,37,24],[37,27,37,30],[38,15,38,16],[38,21,38,24],[38,27,38,30],[34,17,38,18],[29,19,33,20],[29,21,29,24],[29,27,29,30],[30,15,30,16],[30,21,30,24],[30,27,30,30],[31,15,31,16],[31,21,31,24],[31,27,31,30],[32,15,32,16],[32,21,32,24],[32,27,32,30],[33,15,33,16],[33,21,33,24],[33,27,33,30],[24,19,28,20],[24,21,24,24],[24,27,24,30],[25,15,25,16],[25,21,25,24],[25,27,25,30],[26,15,26,16],[26,21,26,24],[26,27,26,30],[27,15,27,16],[27,21,27,24],[27,27,27,30],[28,15,28,16],[28,21,28,24],[28,27,28,30],[19,19,23,20],[19,21,19,24],[19,27,19,30],[20,15,20,16],[20,21,20,24],[20,27,20,30],[21,15,21,16],[21,21,21,24],[21,27,21,30],[22,15,22,16],[22,21,22,24],[22,27,22,30],[23,15,23,16],[23,21,23,24],[23,27,23,30],[14,19,18,20],[14,21,14,24],[14,27,14,30],[15,15,15,16],[15,21,15,24],[15,27,15,30],[16,15,16,16],[16,21,16,24],[16,27,16,30],[17,15,17,16],[17,21,17,24],[17,27,17,30],[18,15,18,16],[18,21,18,24],[18,27,18,30],[49,1,53,1],[49,2,53,5],[49,6,53,8],[44,17,48,18],[44,1,48,1],[44,2,48,5],[44,6,48,8],[39,17,43,18],[39,1,43,1],[39,2,43,5],[39,6,43,8],[39,9,43,9],[39,10,43,10],[39,11,43,14],[39,15,39,16],[44,9,48,9],[44,10,48,10],[44,11,48,14],[44,15,44,16],[49,9,53,9],[49,10,53,10],[49,11,53,14],[49,15,49,16],[34,1,38,1],[34,2,38,5],[34,6,38,8],[29,17,33,18],[29,1,33,1],[29,2,33,5],[29,6,33,8],[24,17,28,18],[24,1,28,1],[24,2,28,5],[24,6,28,8],[24,9,28,9],[24,10,28,10],[24,11,28,14],[24,15,24,16],[29,9,33,9],[29,10,33,10],[29,11,33,14],[29,15,29,16],[34,9,38,9],[34,10,38,10],[34,11,38,14],[34,15,34,16],[19,1,23,1],[19,2,23,5],[19,6,23,8],[19,17,23,18],[19,9,23,9],[19,10,23,10],[19,11,23,14],[14,1,18,1],[14,2,18,5],[14,6,18,8],[14,17,18,18],[14,9,18,9],[14,10,18,10],[14,11,18,14],[14,15,14,16],[19,15,19,16],[7,1,13,5],[7,6,13,8],[13,17,13,18],[1,1,1,30],[2,1,2,30],[3,1,3,30],[4,1,6,30],[7,9,13,9],[7,10,13,10],[7,11,13,14],[7,15,13,16],[7,17,12,20],[7,21,12,30],[13,19,13,20],[13,21,13,24],[13,27,13,30]]}
[]
[null,"Priority #2: Decrease the Prevalence of Binge Drinking Across the Lifespan"]
[null,"Regional Goal Statement: "]
[null,"A goal statement is a clear picture view of what is to be accomplished and represents the priority. The goal statement should clearly and unmistakably point at the benefits that will be gained. "]
[]
[]
[]
[null,"SMART Activity \n      Specific = Who and What?\n      Measurable = By how much?\n      Achievable = How?\n      Relevant = Why?\n      Time-Bound = When?",null,null,null,null,"NPIRS Activity\nFor each activity select the corresponding NPIRS activity from the drop down options provided. If there is no NPIRS activity then select other. \n\nPlease do not overwrite the dropdown menu by typing text into this column.",null,null,"Work Plan ID\nLeave this field blank. DBH will populate this field after reviewing. NPIRS users will indicate the work plan ID when reporting the activity.","Strategy\nThis field populates based on the selection of the NPIRS Activity and identifies the activity's strategy type. ","Reporting Organization\nIdentify the organization that will report the activity in NPIRS. ",null,null,null,"Activity Location\nIdentify the county or counties where the activity will take place.",null,"Timeframe\nSelect Q1, Q2, Q3, or Q4 from the drop down menu. If the activity is ongoing, select the quarters in which it will be active.",null,null,null,"Process and Outcome Metrics\nIdentify at least one process measure and one outcome measure for each activity - along with a baseline and target for each. The process measure should indicate the number of persons served or reached by the activity. The outcome measure should provide evidence about the effectiveness of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,"Measures",null,null,null,"Baseline","Target","Data Source"]
[null,"1)",null,null,null,null,null,null,null,null,{"$f":"IF(G15 = \"\",\"\",VLOOKUP(G15,'Drop downs'!A2:H174,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"2)",null,null,null,null,null,null,null,null,{"$f":"IF(G20 = \"\",\"\",VLOOKUP(G20,'Drop downs'!A7:H179,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"3)",null,null,null,null,null,null,null,null,{"$f":"IF(G25 = \"\",\"\",VLOOKUP(G25,'Drop downs'!A12:H184,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"4)",null,null,null,null,null,null,null,null,{"$f":"IF(G30 = \"\",\"\",VLOOKUP(G30,'Drop downs'!A17:H189,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"5)",null,null,null,null,null,null,null,null,{"$f":"IF(G35 = \"\",\"\",VLOOKUP(G35,'Drop downs'!A22:H194,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"6)",null,null,null,null,null,null,null,null,{"$f":"IF(G40 = \"\",\"\",VLOOKUP(G40,'Drop downs'!A27:H199,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"7)",null,null,null,null,null,null,null,null,{"$f":"IF(G45 = \"\",\"\",VLOOKUP(G45,'Drop downs'!A32:H204,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"8)",null,null,null,null,null,null,null,null,{"$f":"IF(G50 = \"\",\"\",VLOOKUP(G50,'Drop downs'!A37:H209,2,FALSE))","v":""}]

{"sheet":"Priority 3","index":3,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,19,53,20],[49,21,49,24],[49,27,49,30],[50,15,50,16],[50,21,50,24],[50,27,50,30],[51,15,51,16],[51,21,51,24],[51,27,51,30],[52,15,52,16],[52,21,52,24],[52,27,52,30],[53,15,53,16],[53,21,53,24],[53,27,53,30],[49,17,53,18],[44,19,48,20],[44,21,44,24],[44,27,44,30],[45,15,45,16],[45,21,45,24],[45,27,45,30],[46,15,46,16],[46,21,46,24],[46,27,46,30],[47,15,47,16],[47,21,47,24],[47,27,47,30],[48,15,48,16],[48,21,48,24],[48,27,48,30],[39,19,43,20],[39,21,39,24],[39,27,39,30],[40,15,40,16],[40,21,40,24],[40,27,40,30],[41,15,41,16],[41,21,41,24],[41,27,41,30],[42,15,42,16],[42,21,42,24],[42,27,42,30],[43,15,43,16],[43,21,43,24],[43,27,43,30],[34,19,38,20],[34,21,34,24],[34,27,34,30],[35,15,35,16],[35,21,35,24],[35,27,35,30],[36,15,36,16],[36,21,36,24],[36,27,36,30],[37,15,37,16],[37,21,37,24],[37,27,37,30],[38,15,38,16],[38,21,38,24],[38,27,38,30],[34,17,38,18],[29,19,33,20],[29,21,29,24],[29,27,29,30],[30,15,30,16],[30,21,30,24],[30,27,30,30],[31,15,31,16],[31,21,31,24],[31,27,31,30],[32,15,32,16],[32,21,32,24],[32,27,32,30],[33,15,33,16],[33,21,33,24],[33,27,33,30],[24,19,28,20],[24,21,24,24],[24,27,24,30],[25,15,25,16],[25,21,25,24],[25,27,25,30],[26,15,26,16],[26,21,26,24],[26,27,26,30],[27,15,27,16],[27,21,27,24],[27,27,27,30],[28,15,28,16],[28,21,28,24],[28,27,28,30],[19,19,23,20],[19,21,19,24],[19,27,19,30],[20,15,20,16],[20,21,20,24],[20,27,20,30],[21,15,21,16],[21,21,21,24],[21,27,21,30],[22,15,22,16],[22,21,22,24],[22,27,22,30],[23,15,23,16],[23,21,23,24],[23,27,23,30],[14,19,18,20],[14,21,14,24],[14,27,14,30],[15,15,15,16],[15,21,15,24],[15,27,15,30],[16,15,16,16],[16,21,16,24],[16,27,16,30],[17,15,17,16],[17,21,17,24],[17,27,17,30],[18,15,18,16],[18,21,18,24],[18,27,18,30],[49,1,53,1],[49,2,53,5],[49,6,53,8],[44,17,48,18],[44,1,48,1],[44,2,48,5],[44,6,48,8],[39,17,43,18],[39,1,43,1],[39,2,43,5],[39,6,43,8],[39,9,43,9],[39,10,43,10],[39,11,43,14],[39,15,39,16],[44,9,48,9],[44,10,48,10],[44,11,48,14],[44,15,44,16],[49,9,53,9],[49,10,53,10],[49,11,53,14],[49,15,49,16],[34,1,38,1],[34,2,38,5],[34,6,38,8],[29,17,33,18],[29,1,33,1],[29,2,33,5],[29,6,33,8],[24,17,28,18],[24,1,28,1],[24,2,28,5],[24,6,28,8],[24,9,28,9],[24,10,28,10],[24,11,28,14],[24,15,24,16],[29,9,33,9],[29,10,33,10],[29,11,33,14],[29,15,29,16],[34,9,38,9],[34,10,38,10],[34,11,38,14],[34,15,34,16],[19,1,23,1],[19,2,23,5],[19,6,23,8],[19,17,23,18],[19,9,23,9],[19,10,23,10],[19,11,23,14],[14,1,18,1],[14,2,18,5],[14,6,18,8],[14,17,18,18],[14,9,18,9],[14,10,18,10],[14,11,18,14],[14,15,14,16],[19,15,19,16],[7,1,13,5],[7,6,13,8],[13,17,13,18],[1,1,1,30],[2,1,2,30],[3,1,3,30],[4,1,6,30],[7,9,13,9],[7,10,13,10],[7,11,13,14],[7,15,13,16],[7,17,12,20],[7,21,12,30],[13,19,13,20],[13,21,13,24],[13,27,13,30]]}
[]
[null,"Priority #3: Decrease Underage Alcohol Use"]
[null,"Regional Goal Statement: "]
[null,"A goal statement is a clear picture view of what is to be accomplished and represents the priority. The goal statement should clearly and unmistakably point at the benefits that will be gained. "]
[]
[]
[]
[null,"SMART Activity \n      Specific = Who and What?\n      Measurable = By how much?\n      Achievable = How?\n      Relevant = Why?\n      Time-Bound = When?",null,null,null,null,"NPIRS Activity\nFor each activity select the corresponding NPIRS activity from the drop down options provided. If there is no NPIRS activity then select other. \n\nPlease do not overwrite the dropdown menu by typing text into this column.",null,null,"Work Plan ID\nLeave this field blank. DBH will populate this field after reviewing. NPIRS users will indicate the work plan ID when reporting the activity.","Strategy\nThis field populates based on the selection of the NPIRS Activity and identifies the activity's strategy type. ","Reporting Organization\nIdentify the organization that will report the activity in NPIRS. ",null,null,null,"Activity Location\nIdentify the county or counties where the activity will take place.",null,"Timeframe\nSelect Q1, Q2, Q3, or Q4 from the drop down menu. If the activity is ongoing, select the quarters in which it will be active.",null,null,null,"Process and Outcome Metrics\nIdentify at least one process measure and one outcome measure for each activity - along with a baseline and target for each. The process measure should indicate the number of persons served or reached by the activity. The outcome measure should provide evidence about the effectiveness of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,"Measures",null,null,null,"Baseline","Target","Data Source"]
[null,"1)",null,null,null,null,null,null,null,null,{"$f":"IF(G15 = \"\",\"\",VLOOKUP(G15,'Drop downs'!A2:H174,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"2)",null,null,null,null,null,null,null,null,{"$f":"IF(G20 = \"\",\"\",VLOOKUP(G20,'Drop downs'!A7:H179,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"3)",null,null,null,null,null,null,null,null,{"$f":"IF(G25 = \"\",\"\",VLOOKUP(G25,'Drop downs'!A12:H184,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"4)",null,null,null,null,null,null,null,null,{"$f":"IF(G30 = \"\",\"\",VLOOKUP(G30,'Drop downs'!A17:H189,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"5)",null,null,null,null,null,null,null,null,{"$f":"IF(G35 = \"\",\"\",VLOOKUP(G35,'Drop downs'!A22:H194,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"6)",null,null,null,null,null,null,null,null,{"$f":"IF(G40 = \"\",\"\",VLOOKUP(G40,'Drop downs'!A27:H199,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"7)",null,null,null,null,null,null,null,null,{"$f":"IF(G45 = \"\",\"\",VLOOKUP(G45,'Drop downs'!A32:H204,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"8)",null,null,null,null,null,null,null,null,{"$f":"IF(G50 = \"\",\"\",VLOOKUP(G50,'Drop downs'!A37:H209,2,FALSE))","v":""}]

{"sheet":"Priority 4","index":4,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[53,15,53,16],[53,21,53,24],[53,27,53,30],[1,29,1,30],[49,1,53,1],[49,2,53,5],[49,6,53,8],[49,9,53,9],[49,10,53,10],[49,11,53,14],[49,15,49,16],[49,17,53,18],[49,19,53,20],[50,15,50,16],[51,15,51,16],[42,15,42,16],[42,21,42,24],[42,27,42,30],[43,15,43,16],[43,21,43,24],[45,27,45,30],[46,15,46,16],[46,21,46,24],[46,27,46,30],[47,15,47,16],[51,27,51,30],[52,15,52,16],[52,21,52,24],[52,27,52,30],[44,1,48,1],[44,2,48,5],[44,6,48,8],[44,9,48,9],[44,10,48,10],[44,11,48,14],[44,15,44,16],[44,17,48,18],[44,19,48,20],[45,15,45,16],[39,1,43,1],[39,2,43,5],[39,6,43,8],[39,9,43,9],[39,10,43,10],[39,11,43,14],[39,15,39,16],[39,17,43,18],[39,19,43,20],[40,15,40,16],[41,15,41,16],[34,1,38,1],[34,2,38,5],[34,6,38,8],[34,9,38,9],[34,10,38,10],[34,11,38,14],[34,15,34,16],[34,17,38,18],[34,19,38,20],[35,15,35,16],[36,15,36,16],[37,15,37,16],[38,15,38,16],[27,27,27,30],[28,15,28,16],[28,21,28,24],[28,27,28,30],[29,1,33,1],[29,2,33,5],[29,6,33,8],[29,9,33,9],[29,10,33,10],[29,11,33,14],[29,15,29,16],[29,17,33,18],[29,19,33,20],[29,21,29,24],[29,27,29,30],[30,15,30,16],[30,21,30,24],[30,27,30,30],[31,15,31,16],[31,21,31,24],[31,27,31,30],[32,15,32,16],[32,21,32,24],[32,27,32,30],[22,21,22,24],[22,27,22,30],[23,15,23,16],[23,21,23,24],[23,27,23,30],[24,1,28,1],[24,2,28,5],[24,6,28,8],[24,9,28,9],[24,10,28,10],[24,11,28,14],[24,15,24,16],[24,17,28,18],[24,19,28,20],[24,21,24,24],[24,27,24,30],[25,15,25,16],[25,21,25,24],[25,27,25,30],[26,15,26,16],[26,21,26,24],[26,27,26,30],[27,15,27,16],[27,21,27,24],[19,1,23,1],[19,2,23,5],[19,6,23,8],[19,9,23,9],[19,10,23,10],[19,11,23,14],[19,15,19,16],[19,17,23,18],[19,19,23,20],[20,15,20,16],[21,15,21,16],[22,15,22,16],[14,21,14,24],[14,27,14,30],[15,15,15,16],[15,21,15,24],[15,27,15,30],[16,15,16,16],[16,21,16,24],[16,27,16,30],[17,15,17,16],[17,21,17,24],[17,27,17,30],[14,1,18,1],[14,2,18,5],[14,6,18,8],[14,9,18,9],[14,10,18,10],[14,11,18,14],[14,15,14,16],[14,17,18,18],[14,19,18,20],[18,15,18,16],[7,10,13,10],[7,11,13,14],[7,15,13,16],[7,17,12,20],[7,21,12,30],[13,17,13,18],[13,19,13,20],[13,21,13,24],[13,27,13,30],[1,1,1,3],[47,21,47,24],[47,27,47,30],[48,15,48,16],[48,21,48,24],[48,27,48,30],[49,21,49,24],[49,27,49,30],[50,21,50,24],[50,27,50,30],[18,21,18,24],[18,27,18,30],[19,21,19,24],[19,27,19,30],[20,21,20,24],[20,27,20,30],[21,21,21,24],[21,27,21,30],[2,1,2,30],[3,1,3,30],[4,1,6,30],[7,1,13,5],[7,6,13,8],[7,9,13,9],[51,21,51,24],[33,15,33,16],[33,21,33,24],[33,27,33,30],[34,21,34,24],[34,27,34,30],[35,21,35,24],[35,27,35,30],[36,21,36,24],[36,27,36,30],[37,21,37,24],[37,27,37,30],[38,21,38,24],[38,27,38,30],[39,21,39,24],[39,27,39,30],[40,21,40,24],[40,27,40,30],[41,21,41,24],[41,27,41,30],[43,27,43,30],[44,21,44,24],[44,27,44,30],[45,21,45,24]]}
[]
[null,"Priority #4 (optional): "]
[null,"Regional Goal Statement: "]
[null,"A goal statement is a clear picture view of what is to be accomplished and represents the priority. The goal statement should clearly and unmistakably point at the benefits that will be gained. "]
[]
[]
[]
[null,"SMART Activity \n      Specific = Who and What?\n      Measurable = By how much?\n      Achievable = How?\n      Relevant = Why?\n      Time-Bound = When?",null,null,null,null,"NPIRS Activity\nFor each activity select the corresponding NPIRS activity from the drop down options provided. If there is no NPIRS activity then select other. \n\nPlease do not overwrite the dropdown menu by typing text into this column.",null,null,"Work Plan ID\nLeave this field blank. DBH will populate this field after reviewing. NPIRS users will indicate the work plan ID when reporting the activity.","Strategy\nThis field populates based on the selection of the NPIRS Activity and identifies the activity's strategy type. ","Reporting Organization\nIdentify the organization that will report the activity in NPIRS. ",null,null,null,"Activity Location\nIdentify the county or counties where the activity will take place.",null,"Timeframe\nSelect Q1, Q2, Q3, or Q4 from the drop down menu. If the activity is ongoing, select the quarters in which it will be active.",null,null,null,"Process and Outcome Metrics\nIdentify at least one process measure and one outcome measure for each activity - along with a baseline and target for each. The process measure should indicate the number of persons served or reached by the activity. The outcome measure should provide evidence about the effectiveness of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,"Measures",null,null,null,"Baseline","Target","Data Source"]
[null,"1)",null,null,null,null,null,null,null,null,{"$f":"IF(G15 = \"\",\"\",VLOOKUP(G15,'Drop downs'!A3:H175,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"2)",null,null,null,null,null,null,null,null,{"$f":"IF(G20 = \"\",\"\",VLOOKUP(G20,'Drop downs'!A8:H180,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"3)",null,null,null,null,null,null,null,null,{"$f":"IF(G25 = \"\",\"\",VLOOKUP(G25,'Drop downs'!A13:H185,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"4)",null,null,null,null,null,null,null,null,{"$f":"IF(G30 = \"\",\"\",VLOOKUP(G30,'Drop downs'!A18:H190,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"5)",null,null,null,null,null,null,null,null,{"$f":"IF(G35 = \"\",\"\",VLOOKUP(G35,'Drop downs'!A23:H195,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"6)",null,null,null,null,null,null,null,null,{"$f":"IF(G40 = \"\",\"\",VLOOKUP(G40,'Drop downs'!A28:H200,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"7)",null,null,null,null,null,null,null,null,{"$f":"IF(G45 = \"\",\"\",VLOOKUP(G45,'Drop downs'!A33:H205,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"8)",null,null,null,null,null,null,null,null,{"$f":"IF(G50 = \"\",\"\",VLOOKUP(G50,'Drop downs'!A38:H210,2,FALSE))","v":""}]

{"sheet":"Priority 5","index":5,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,19,53,20],[49,21,49,24],[49,27,49,30],[50,15,50,16],[50,21,50,24],[50,27,50,30],[51,15,51,16],[51,21,51,24],[51,27,51,30],[52,15,52,16],[52,21,52,24],[52,27,52,30],[53,15,53,16],[53,21,53,24],[53,27,53,30],[49,17,53,18],[44,19,48,20],[44,21,44,24],[44,27,44,30],[45,15,45,16],[45,21,45,24],[45,27,45,30],[46,15,46,16],[46,21,46,24],[46,27,46,30],[47,15,47,16],[47,21,47,24],[47,27,47,30],[48,15,48,16],[48,21,48,24],[48,27,48,30],[39,19,43,20],[39,21,39,24],[39,27,39,30],[40,15,40,16],[40,21,40,24],[40,27,40,30],[41,15,41,16],[41,21,41,24],[41,27,41,30],[42,15,42,16],[42,21,42,24],[42,27,42,30],[43,15,43,16],[43,21,43,24],[43,27,43,30],[34,19,38,20],[34,21,34,24],[34,27,34,30],[35,15,35,16],[35,21,35,24],[35,27,35,30],[36,15,36,16],[36,21,36,24],[36,27,36,30],[37,15,37,16],[37,21,37,24],[37,27,37,30],[38,15,38,16],[38,21,38,24],[38,27,38,30],[34,17,38,18],[29,19,33,20],[29,21,29,24],[29,27,29,30],[30,15,30,16],[30,21,30,24],[30,27,30,30],[31,15,31,16],[31,21,31,24],[31,27,31,30],[32,15,32,16],[32,21,32,24],[32,27,32,30],[33,15,33,16],[33,21,33,24],[33,27,33,30],[24,19,28,20],[24,21,24,24],[24,27,24,30],[25,15,25,16],[25,21,25,24],[25,27,25,30],[26,15,26,16],[26,21,26,24],[26,27,26,30],[27,15,27,16],[27,21,27,24],[27,27,27,30],[28,15,28,16],[28,21,28,24],[28,27,28,30],[18,15,18,16],[18,21,18,24],[18,27,18,30],[19,9,23,9],[19,10,23,10],[19,11,23,14],[19,15,19,16],[19,19,23,20],[19,21,19,24],[19,27,19,30],[20,15,20,16],[20,21,20,24],[20,27,20,30],[21,15,21,16],[21,21,21,24],[21,27,21,30],[22,15,22,16],[22,21,22,24],[22,27,22,30],[23,15,23,16],[23,27,23,30],[19,17,23,18],[1,29,1,30],[2,1,2,30],[3,1,3,30],[4,1,6,30],[7,9,13,9],[7,10,13,10],[7,11,13,14],[7,15,13,16],[7,17,12,20],[7,21,12,30],[13,19,13,20],[13,21,13,24],[13,27,13,30],[1,1,1,3],[7,1,13,5],[7,6,13,8],[13,17,13,18],[49,1,53,1],[49,2,53,5],[49,6,53,8],[44,17,48,18],[44,1,48,1],[44,2,48,5],[44,6,48,8],[39,17,43,18],[39,1,43,1],[39,2,43,5],[39,6,43,8],[39,9,43,9],[39,10,43,10],[39,11,43,14],[39,15,39,16],[44,9,48,9],[44,10,48,10],[44,11,48,14],[44,15,44,16],[49,9,53,9],[49,10,53,10],[49,11,53,14],[49,15,49,16],[34,1,38,1],[34,2,38,5],[34,6,38,8],[29,17,33,18],[29,1,33,1],[29,2,33,5],[29,6,33,8],[24,17,28,18],[24,1,28,1],[24,2,28,5],[24,6,28,8],[24,9,28,9],[24,10,28,10],[24,11,28,14],[24,15,24,16],[29,9,33,9],[29,10,33,10],[29,11,33,14],[29,15,29,16],[34,9,38,9],[34,10,38,10],[34,11,38,14],[34,15,34,16],[19,1,23,1],[14,17,18,18],[14,11,18,14],[14,15,14,16],[14,19,18,20],[14,21,14,24],[14,27,14,30],[15,15,15,16],[15,21,15,24],[15,27,15,30],[16,15,16,16],[16,21,16,24],[14,1,18,1],[14,2,18,5],[14,6,18,8],[19,2,23,5],[19,6,23,8],[14,9,18,9],[14,10,18,10],[23,21,23,24],[16,27,16,30],[17,15,17,16],[17,21,17,24],[17,27,17,30]]}
[]
[null,"Priority #5 (optional): "]
[null,"Regional Goal Statement: "]
[null,"A goal statement is a clear picture view of what is to be accomplished and represents the priority. The goal statement should clearly and unmistakably point at the benefits that will be gained. "]
[]
[]
[]
[null,"SMART Activity \n      Specific = Who and What?\n      Measurable = By how much?\n      Achievable = How?\n      Relevant = Why?\n      Time-Bound = When?",null,null,null,null,"NPIRS Activity\nFor each activity select the corresponding NPIRS activity from the drop down options provided. If there is no NPIRS activity then select other. \n\nPlease do not overwrite the dropdown menu by typing text into this column.",null,null,"Work Plan ID\nLeave this field blank. DBH will populate this field after reviewing. NPIRS users will indicate the work plan ID when reporting the activity.","Strategy\nThis field populates based on the selection of the NPIRS Activity and identifies the activity's strategy type. ","Reporting Organization\nIdentify the organization that will report the activity in NPIRS. ",null,null,null,"Activity Location\nIdentify the county or counties where the activity will take place.",null,"Timeframe\nSelect Q1, Q2, Q3, or Q4 from the drop down menu. If the activity is ongoing, select the quarters in which it will be active.",null,null,null,"Process and Outcome Metrics\nIdentify at least one process measure and one outcome measure for each activity - along with a baseline and target for each. The process measure should indicate the number of persons served or reached by the activity. The outcome measure should provide evidence about the effectiveness of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,"Measures",null,null,null,"Baseline","Target","Data Source"]
[null,"1)",null,null,null,null,null,null,null,null,{"$f":"IF(G15 = \"\",\"\",VLOOKUP(G15,'Drop downs'!A3:H175,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"2)",null,null,null,null,null,null,null,null,{"$f":"IF(G20 = \"\",\"\",VLOOKUP(G20,'Drop downs'!A8:H180,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"3)",null,null,null,null,null,null,null,null,{"$f":"IF(G25 = \"\",\"\",VLOOKUP(G25,'Drop downs'!A13:H185,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"4)",null,null,null,null,null,null,null,null,{"$f":"IF(G30 = \"\",\"\",VLOOKUP(G30,'Drop downs'!A18:H190,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"5)",null,null,null,null,null,null,null,null,{"$f":"IF(G35 = \"\",\"\",VLOOKUP(G35,'Drop downs'!A23:H195,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"6)",null,null,null,null,null,null,null,null,{"$f":"IF(G40 = \"\",\"\",VLOOKUP(G40,'Drop downs'!A28:H200,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"7)",null,null,null,null,null,null,null,null,{"$f":"IF(G45 = \"\",\"\",VLOOKUP(G45,'Drop downs'!A33:H205,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"8)",null,null,null,null,null,null,null,null,{"$f":"IF(G50 = \"\",\"\",VLOOKUP(G50,'Drop downs'!A38:H210,2,FALSE))","v":""}]

{"sheet":"Priority 6","index":6,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,19,53,20],[49,21,49,24],[49,27,49,30],[50,15,50,16],[50,21,50,24],[50,27,50,30],[51,15,51,16],[51,21,51,24],[51,27,51,30],[52,15,52,16],[52,21,52,24],[52,27,52,30],[53,15,53,16],[53,21,53,24],[53,27,53,30],[49,17,53,18],[44,19,48,20],[44,21,44,24],[44,27,44,30],[45,15,45,16],[45,21,45,24],[45,27,45,30],[46,15,46,16],[46,21,46,24],[46,27,46,30],[47,15,47,16],[47,21,47,24],[47,27,47,30],[48,15,48,16],[48,21,48,24],[48,27,48,30],[39,19,43,20],[39,21,39,24],[39,27,39,30],[40,15,40,16],[40,21,40,24],[40,27,40,30],[41,15,41,16],[41,21,41,24],[41,27,41,30],[42,15,42,16],[42,21,42,24],[42,27,42,30],[43,15,43,16],[43,21,43,24],[43,27,43,30],[34,19,38,20],[34,21,34,24],[34,27,34,30],[35,15,35,16],[35,21,35,24],[35,27,35,30],[36,15,36,16],[36,21,36,24],[36,27,36,30],[37,15,37,16],[37,21,37,24],[37,27,37,30],[38,15,38,16],[38,21,38,24],[38,27,38,30],[34,17,38,18],[29,19,33,20],[29,21,29,24],[29,27,29,30],[30,15,30,16],[30,21,30,24],[30,27,30,30],[31,15,31,16],[31,21,31,24],[31,27,31,30],[32,15,32,16],[32,21,32,24],[32,27,32,30],[33,15,33,16],[33,21,33,24],[33,27,33,30],[24,19,28,20],[24,21,24,24],[24,27,24,30],[25,15,25,16],[25,21,25,24],[25,27,25,30],[26,15,26,16],[26,21,26,24],[26,27,26,30],[27,15,27,16],[27,21,27,24],[27,27,27,30],[28,15,28,16],[28,21,28,24],[28,27,28,30],[18,15,18,16],[18,21,18,24],[18,27,18,30],[19,9,23,9],[19,10,23,10],[19,11,23,14],[19,15,19,16],[19,19,23,20],[19,21,19,24],[19,27,19,30],[20,15,20,16],[20,21,20,24],[20,27,20,30],[21,15,21,16],[21,21,21,24],[21,27,21,30],[22,15,22,16],[22,21,22,24],[22,27,22,30],[23,15,23,16],[23,27,23,30],[19,17,23,18],[1,29,1,30],[2,1,2,30],[3,1,3,30],[4,1,6,30],[7,9,13,9],[7,10,13,10],[7,11,13,14],[7,15,13,16],[7,17,12,20],[7,21,12,30],[13,19,13,20],[13,21,13,24],[13,27,13,30],[1,1,1,3],[7,1,13,5],[7,6,13,8],[13,17,13,18],[49,1,53,1],[49,2,53,5],[49,6,53,8],[44,17,48,18],[44,1,48,1],[44,2,48,5],[44,6,48,8],[39,17,43,18],[39,1,43,1],[39,2,43,5],[39,6,43,8],[39,9,43,9],[39,10,43,10],[39,11,43,14],[39,15,39,16],[44,9,48,9],[44,10,48,10],[44,11,48,14],[44,15,44,16],[49,9,53,9],[49,10,53,10],[49,11,53,14],[49,15,49,16],[34,1,38,1],[34,2,38,5],[34,6,38,8],[29,17,33,18],[29,1,33,1],[29,2,33,5],[29,6,33,8],[24,17,28,18],[24,1,28,1],[24,2,28,5],[24,6,28,8],[24,9,28,9],[24,10,28,10],[24,11,28,14],[24,15,24,16],[29,9,33,9],[29,10,33,10],[29,11,33,14],[29,15,29,16],[34,9,38,9],[34,10,38,10],[34,11,38,14],[34,15,34,16],[19,1,23,1],[14,17,18,18],[14,11,18,14],[14,15,14,16],[14,19,18,20],[14,21,14,24],[14,27,14,30],[15,15,15,16],[15,21,15,24],[15,27,15,30],[16,15,16,16],[16,21,16,24],[14,1,18,1],[14,2,18,5],[14,6,18,8],[19,2,23,5],[19,6,23,8],[14,9,18,9],[14,10,18,10],[23,21,23,24],[16,27,16,30],[17,15,17,16],[17,21,17,24],[17,27,17,30]]}
[]
[null,"Priority #6 (optional): "]
[null,"Regional Goal Statement: "]
[null,"A goal statement is a clear picture view of what is to be accomplished and represents the priority. The goal statement should clearly and unmistakably point at the benefits that will be gained. "]
[]
[]
[]
[null,"SMART Activity \n      Specific = Who and What?\n      Measurable = By how much?\n      Achievable = How?\n      Relevant = Why?\n      Time-Bound = When?",null,null,null,null,"NPIRS Activity\nFor each activity select the corresponding NPIRS activity from the drop down options provided. If there is no NPIRS activity then select other. \n\nPlease do not overwrite the dropdown menu by typing text into this column.",null,null,"Work Plan ID\nLeave this field blank. DBH will populate this field after reviewing. NPIRS users will indicate the work plan ID when reporting the activity.","Strategy\nThis field populates based on the selection of the NPIRS Activity and identifies the activity's strategy type. ","Reporting Organization\nIdentify the organization that will report the activity in NPIRS. ",null,null,null,"Activity Location\nIdentify the county or counties where the activity will take place.",null,"Timeframe\nSelect Q1, Q2, Q3, or Q4 from the drop down menu. If the activity is ongoing, select the quarters in which it will be active.",null,null,null,"Process and Outcome Metrics\nIdentify at least one process measure and one outcome measure for each activity - along with a baseline and target for each. The process measure should indicate the number of persons served or reached by the activity. The outcome measure should provide evidence about the effectiveness of the activity. The best outcome metrics are program-level instruments. But if this is unavailable, identify a community-level outcome metric from available survey or administrative that the activity attempts to modify. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,"Measures",null,null,null,"Baseline","Target","Data Source"]
[null,"1)",null,null,null,null,null,null,null,null,{"$f":"IF(G15 = \"\",\"\",VLOOKUP(G15,'Drop downs'!A3:H175,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"2)",null,null,null,null,null,null,null,null,{"$f":"IF(G20 = \"\",\"\",VLOOKUP(G20,'Drop downs'!A8:H180,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"3)",null,null,null,null,null,null,null,null,{"$f":"IF(G25 = \"\",\"\",VLOOKUP(G25,'Drop downs'!A13:H185,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"4)",null,null,null,null,null,null,null,null,{"$f":"IF(G30 = \"\",\"\",VLOOKUP(G30,'Drop downs'!A18:H190,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"5)",null,null,null,null,null,null,null,null,{"$f":"IF(G35 = \"\",\"\",VLOOKUP(G35,'Drop downs'!A23:H195,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"6)",null,null,null,null,null,null,null,null,{"$f":"IF(G40 = \"\",\"\",VLOOKUP(G40,'Drop downs'!A28:H200,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"7)",null,null,null,null,null,null,null,null,{"$f":"IF(G45 = \"\",\"\",VLOOKUP(G45,'Drop downs'!A33:H205,2,FALSE))","v":""}]
[]
[]
[]
[]
[null,"8)",null,null,null,null,null,null,null,null,{"$f":"IF(G50 = \"\",\"\",VLOOKUP(G50,'Drop downs'!A38:H210,2,FALSE))","v":""}]

{"sheet":"Supporting Activites","index":7,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[[11,9,11,11],[12,9,12,11],[13,9,13,11],[22,9,22,11],[23,9,23,11],[24,9,24,11],[25,9,25,11],[26,9,26,11],[27,9,27,11],[16,9,16,11],[17,9,17,11],[18,9,18,11],[19,9,19,11],[20,9,20,11],[21,9,21,11],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[29,14,29,15],[30,14,30,15],[6,12,6,13],[7,12,7,13],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[22,14,22,15],[11,14,11,15],[12,14,12,15],[13,14,13,15],[14,14,14,15],[15,14,15,15],[16,14,16,15],[29,2,29,4],[29,5,29,8],[30,2,30,4],[30,5,30,8],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[26,2,26,4],[26,5,26,8],[27,2,27,4],[27,5,27,8],[28,2,28,4],[28,5,28,8],[23,2,23,4],[23,5,23,8],[24,2,24,4],[24,5,24,8],[25,2,25,4],[14,9,14,11],[15,9,15,11],[28,9,28,11],[29,9,29,11],[30,9,30,11],[25,5,25,8],[20,2,20,4],[20,5,20,8],[21,2,21,4],[21,5,21,8],[22,2,22,4],[22,5,22,8],[17,2,17,4],[17,5,17,8],[18,2,18,4],[18,5,18,8],[19,2,19,4],[19,5,19,8],[14,2,14,4],[14,5,14,8],[15,2,15,4],[15,5,15,8],[16,2,16,4],[16,5,16,8],[11,2,11,4],[11,5,11,8],[12,2,12,4],[12,5,12,8],[13,2,13,4],[13,5,13,8],[1,2,1,15],[2,2,3,15],[8,2,8,4],[8,5,8,8],[9,2,9,4],[9,5,9,8],[10,2,10,4],[10,5,10,8],[6,2,6,4],[6,5,6,8],[7,2,7,4],[7,5,7,8],[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,14,9,15],[10,14,10,15],[4,12,5,13],[4,14,5,15],[4,2,5,4],[4,5,5,8],[4,9,5,11],[10,9,10,11]]}
[]
[null,null,"Supporting Activities"]
[null,null,"List the supporting activity, provide a description of the activity, and the contributing partners/coalitions. List the funding sources that pay for that activity and identify the select from the drop down options provided which SAPTBG priority the supportive activity helps support. "]
[]
[null,null,"Supportive Activity ",null,null,"Supportive Activity Description",null,null,null,"Contributing Partner(s)/Coalitions",null,null,"Funding Source",null,"SAPTBG Priority \n(select all that apply)"]

{"sheet":"Drop downs","index":8,"n_rows":169,"n_cols":6,"rows_kept":169,"cut":false,"hidden":true,"merged":[]}
["Activity","Strategy","Target Type","Time Period",null,"SAPTBG Priorities"]
["3rd Millennium Alcohol Wise College - General","Education","Individual","Q1",null,1]
["3rd Millennium Alcohol Wise College - Infraction","Education","Individual","Q2",null,2]
["3rd Millennium Alcohol Wise High School - General","Education","Individual","Q3",null,3]
["3rd Millennium Alcohol Wise High School - Infraction","Education","Individual","Q4",null,4]
["3rd Millennium Marijuana Wise College - General ","Education","Individual",null,null,5]
["3rd Millennium Marijuana Wise College - Infraction","Education","Individual",null,null,6]
["3rd Millennium Marijuana Wise High School - General","Education","Individual"]
["3rd Millennium Marijuana Wise High School - Infraction","Education","Individual"]
["3rd Millennium Nicotine 101 - General","Education","Individual"]
["3rd Millennium Nicotine 101 - Infraction","Education","Individual"]
["3rd Millennium Other Drugs - General","Education","Individual"]
["3rd Millennium Other Drugs - Infraction","Education","Individual"]
["3rd Millennium Parent Wise High School - General","Education","Individual"]
["3rd Millennium Parent Wise High School - Infraction","Education","Individual"]
["3rd Millennium Respect and Resolve High School - General","Education","Individual"]
["7 Habits of Successful Teens","Education","Individual"]
["8 to Great","Education","Individual"]
["Across Ages","Alternative Activities","Individual"]
["Alcohol Inspections","Environmental","Individual"]
["Alcohol Literacy Challenge - College","Education","Individual"]
["Alcohol Literacy Challenge - High School","Education","Individual"]
["Alcohol: True Stories 2 - 50 min","Education","Individual"]
["Alcohol: True Stories 4 - 25 min","Education","Individual"]
["All Stars","Education","Individual"]
["AMSR Training","Community Based Process","Individual"]
["Anti Bullying Initiative","Education","Individual"]
["Assets","Education","Individual"]
["BASE Education ","Education","Individual"]
["Behavior Intervention Support Team (BIST)","Education","Individual"]
["Big Brothers/Big Sisters (mentoring)","Alternative Activities","Individual"]
["Brief Alcohol Screening and Intervention of College Students ","Problem Identification and Referral","Individual"]
["Brief Motivational Interviewing (BMI)","Education","Individual"]
["Bystander Intervention","Education","Individual"]
["Camp G.R.I.T.","Education","Individual"]
["CAMS Training","Community Based Process","Population"]
["CASASTART","Education","Individual"]
["CATCH My Breath","Education","Individual"]
["Challenging College Alcohol Abuse","Information Dissemination","Individual"]
["Changing the Conditions of Availability","Environmental","Individual"]
["Character Counts","Education","Individual"]
["Child Development Project","Education","Individual"]
["CHOICES","Problem Identification and Referral","Individual"]
["Circle of Security","Education","Individual"]
["Class Action 10 Sessions","Education","Individual"]
["Class Action 8 Sessions","Education","Individual"]
["Coalition Meetings","Community Based Process","Individual"]
["College Behavior Profile (CBP)","Problem Identification and Referral","Individual"]
["Common Sense Parenting","Education","Individual"]
["Communities Mobilizing for Change on Alcohol - Action Team Meetings","Community Based Process","Individual"]
["Communities Mobilizing for Change on Alcohol - Media","Information Dissemination","Individual"]
["Communities Mobilizing for Change on Alcohol - One on One Interviews","Environmental","Individual"]
["Communities Mobilizing for Change on Alcohol - Policy","Environmental","Individual"]
["Communities That Care - Coalition Meeting","Community Based Process","Individual"]
["Communities That Care - Coalition Recruitment","Community Based Process","Individual"]
["Communities That Care - Coalition Training","Community Based Process","Individual"]
["Communities That Care - Data Collection/Analysis","Community Based Process","Individual"]
["Communities That Care - Media Outreach","Information Dissemination","Population"]
["Community Readiness Assessment","Community Based Process","Individual"]
["Community Trials","Community Based Process","Individual"]
["Compass for Courage","Education","Individual"]
["Compliance Checks ","Environmental","Individual"]
["Connect with Kids","Education","Individual"]
["Coordinating Group/Board Meetings","Community Based Process","Population"]
["CRC Ally Training","Education","Individual"]
["CRC Member Meeting","Community Based Process","Individual"]
["CRC Recovery Community","Alternative Activities","Individual"]
["CRC Social Events","Alternative Activities","Population"]
["Creating Lasting Family Connections 8 - 120 min","Education","Individual"]
["DARE to Be You","Education","Individual"]
["DECA","Problem Identification and Referral","Individual"]
["DESSA-Full","Problem Identification and Referral","Individual"]
["DESSA-Mini","Problem Identification and Referral","Individual"]
["Drug Free Event ","Alternative Activities","Individual"]
["Drugs: True Stories","Education","Individual"]
["Electronic Resources","Information Dissemination","Individual"]
["Environmental Scan","Environmental","Population"]
["Find Your Grind","Education","Individual"]
["Fixed Displays","Information Dissemination","Individual"]
["Generation Rx","Education","Individual"]
["Girls Circle","Education","Individual"]
["Girls on the Run","Alternative Activities","Individual"]
["Habitudes","Education","Individual"]
["HALO","Education","Individual"]
["Health Rocks","Education","Individual"]
["Hope Squad Team Action","Education","Population"]
["Hope Squad Team Training","Education","Individual"]
["Human Performance Project","Environmental","Individual"]
["keepin' it REAL/D.A.R.E (The Drug Abuse Resistance Education)","Education","Individual"]
["Late Night Programming","Alternative Activities","Population"]
["Lead and Seed","Environmental","Individual"]
["Life Skills","Education","Individual"]
["Lion's Quest","Education","Individual"]
["Living Well","Education","Individual"]
["Love and Logic","Education","Individual"]
["Me 360","Education","Individual"]
["Means Restriction Lock Boxes","Community Based Process","Individual"]
["Media Ready","Education","Individual"]
["Medical Amnesty Policy","Environmental","Individual"]
["Mentoring Program","Alternative Activities","Individual"]
["Movimiento Ascendencia","Education","Individual"]
["Multi-Component School-Linked Community Approaches","Community Based Process","Individual"]
["MyStudentBody","Education","Individual"]
["Operation Prevention","Education","Individual"]
["Parent and Family Skills Training","Education","Individual"]
["Parent Letter Mailings","Information Dissemination","Individual"]
["Parenting Wisely","Education","Individual"]
["Party Patrol","Environmental","Individual"]
["Phoenix Curriculum","Education","Individual"]
["Photo Voice","Alternative Activities","Individual"]
["Policy Development","Environmental","Individual"]
["Positive Action","Education","Individual"]
["Prescription Drug Disposal","Environmental","Individual"]
["Prescription Lock Boxes","Community Based Process","Individual"]
["Presentation","Education","Individual"]
["PreVenture","Education","Population"]
["Prime for Life 2 - 360 min","Problem Identification and Referral","Individual"]
["Prime for Life 4 - 180 min","Problem Identification and Referral","Individual"]
["Printed Materials","Information Dissemination","Individual"]
["Project ALERT","Education","Individual"]
["Project Northland 8 Sessions","Education","Individual"]
["Project Safe Home","Education","Individual"]
["Protecting You/Protecting Me","Education","Individual"]
["PSAs","Information Dissemination","Individual"]
["QPR Training","Community Based Process","Population"]
["Red Ribbon Week","Education","Individual"]
["Responsible Beverage Server Training","Environmental","Individual"]
["Responsible Hosting","Environmental","Individual"]
["Retailer-Directed Interventions","Environmental","Individual"]
["Risk Reduction","Community Based Process","Population"]
["Rob Turrisi's Parent Handbook","Information Dissemination","Population"]
["Safe Dates","Education","Individual"]
["SBIRT","Problem Identification and Referral","Individual"]
["ScreenU","Problem Identification and Referral","Individual"]
["Second Step ","Education","Individual"]
["Seeking Safety ","Education","Individual"]
["Shoulder Tap","Environmental","Individual"]
["Slick Tracy","Education","Individual"]
["Sobriety Check Points","Environmental","Individual"]
["Social Norms Campaign","Information Dissemination","Population"]
["SPORT Prevention Plus Wellness","Education","Individual"]
["SPORT-Marijuana Prevention Plus Wellness","Education","Individual"]
["SPORT-Vaping Prevention Plus Wellness","Education","Individual"]
["Stay on Track","Education","Individual"]
["Sticker Shock","Information Dissemination","Individual"]
["Strengthening Families (12-16)","Education","Individual"]
["Strengthening Families DVD","Education","Individual"]
["Strengthening Families Program (10-14)","Education","Individual"]
["Student Assistance Team Action","Problem Identification and Referral","Individual"]
["Student Assistance Team Training","Problem Identification and Referral","Individual"]
["Targeted Enforcement","Environmental","Population"]
["Team Mates (mentoring)","Alternative Activities","Individual"]
["Technical Assistance","Community Based Process","Individual"]
["Too Good for Drugs & Violence - High School","Education","Individual"]
["Too Good for Drugs & Violence K-8","Education","Individual"]
["Too Smart to Start Drugs","Information Dissemination","Individual"]
["Training","Community Based Process","Individual"]
["Tutoring","Community Based Process","Individual"]
["VapeEducate","Education","Individual"]
["Vector Solutions Courses","Education","Individual"]
["Vision Impairment Education (Goggles)","Education","Individual"]
["W.A.I.T. (Abstinence Education)","Education","Individual"]
["Well Initiatives for Senior Education (WISE)","Education","Individual"]
["Why Try","Education","Individual"]
["Workgroup","Community Based Process","Individual"]
["WRAP","Education","Individual"]
["Year One College Behavior Profile (Year One CBP)","Problem Identification and Referral","Individual"]
["Youth Frontiers","Education","Individual"]
["Other","Please reach out to DBH for strategy"]