{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Tool Overview","EBP Observation Calculator","Observation Log","Table 1. Required Observations","Table 2. Completed by EBP","Table 3. Completed by Facilitat","Table 4. Completed by Setting","Table 5. Completed by Location","Table 6. By EBP and Setting","Dropdown data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":23,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tool Overview","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Logo: OASH Office of Population Affairs"]
["TPP Tier 1 Grant: Observation Planning Tool"]
["Tool overview"]
["Welcome to the TPP Tier 1 Grant Observation Planning Tool! This tool is designed to help you plan, log, and track the evidence-based program (EBP) observations required by your TPP Tier 1 grant. The goal of this tool is to ensure you are planning to observe at least the minimum number of sessions per EBP and facilitator as required by the Office of Population Affairs (OPA). \n\nThis tool is optional, but it is designed to help you plan the number of observations required to meet your grant requirements. "]
["For additional support or resources, please contact:"]
["- Your PO if you have questions about your grant's observation requirements.\n- The Mathematica Eval TA team at TPPEvalTA@mathematica-mpr.com if you have questions about using this tool.  "]
["End of worksheet"]

{"sheet":"EBP Observation Calculator","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[1,4,1,5]]}
["TPP Tier 1 Grant: Observation Planning Tool"]
["EBP Observation Calculator","blank","blank","Time period:","2024-25 Grant Year (Year 2)"]
["User notes: \n- Double check and, if needed, update the time period for this template (Cell E2). We recommend creating a separate workbook for each grant period. \n- Enter data in white cells (entering data for the setting (column B) is optional). \n- Do not enter data in green cells (columns E and F). The data within those cells are automatically calculated for you. Column F reflects the # of sessions to observe for an EBP given the requirement to observe 5 percent of all implemented sessions of the EBP."]
["EBP name\nUse dropdown","Setting (optional)\nUse dropdown","# sessions to be completed","# sections/groups planned","Total # of sessions to be offered","# sessions required to observe"]
["Making Proud Choices!","Residential or group home",8,30,{"$f":"IFERROR(C5*D5,\"\")","v":240},{"$f":"CEILING((E5*0.05),1)","v":12}]
["Making Proud Choices!","High school",14,3,42,{"$f":"CEILING((E6*0.05),1)","v":3}]
["AIM 4 Teen Moms","Home-based",8,7,56,3]
["FLASH (high school)","High school",15,12,180,9]
["Love Notes ","Community-based organization",13,15,195,10]
["Healthy Futures","Middle school",24,10,240,12]
["IN·clued","School-based health clinic",1,8,8,1]
["Familias Unidas","High school",18,77,1386,70]
["Making Proud Choices! Out-of-Home Youth","School-based health clinic",22,22,484,25]
["Get Real (middle School)","Middle school",121,33,3993,200]
["End of worksheet"]

{"sheet":"Observation Log","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,0,2,12],[3,0,3,12]]}
["TPP Tier 1 Grant: Observation Planning Tool"]
["Observation log","blank","blank","blank","blank","blank","blank","Time Period:",null,null,null,null,"2024-25 Grant Year (Year 2)"]
["User notes: \n- Double check and, if needed, update the time period for this template (Cell M2). We recommend creating a separate workbook for each grant period. \n- Manually enter data in Columns A-H and M, though setting (column F), location (column G) and notes (column M) are optional.\n- Use the dropdowns in Columns E, F and H, though column F is optional.\n- Feel free to increase the width of the observation notes column or use additional columns to track information about the observations, if that's useful for you.\n- You can sort each column by clicking on the arrow by the column header."]
["Observation details"]
["Observation date","Observation time","Observer","Facilitator observed","EBP name\nUse dropdown","Setting (optional)\nUse dropdown","Location (optional)","Observation status","Observation complete - num","Observation overdue","Observation planned","Total observations","Observation notes"]
["2024-11-20","9am","Ash","Grey","AIM 4 Teen Moms","Home-based","Hopkins","Completed",{"$f":"IF(H6=\"Completed\",1,0)","v":1},{"$f":"AND(AND($H6<>\"Completed\",$A6<TODAY()),$H6<>\"\")","v":false},{"$f":"IF(AND(H6<>\"Completed\",H6<>\"Canceled\"), 1, 0)","v":0},{"$f":"SUM(I6,K6)","v":1},"The facilitator and classroom was very organized. There was a fire drill that prevented the last activity from being completed. The facilitator will add the missed activity to the next class session."]
["2024-11-22","10am","Katie","Mia","Making Proud Choices!","High school","Medford","Completed",1,false,0,1]
["2024-11-28","11am","Ash","Lauren","FLASH (high school)","High school","Medford","Canceled",0,true,0,0,"The facilitator was sick and we needed to reschedule. "]
["2024-12-12","12pm","Ash","Mira","Healthy Futures","Middle school","Cambridge","Completed",1,false,0,1,"The facilitator was able to engage the room effectively. The faciltiator was able to complete all the planned lessons. "]
["2024-12-19","2pm","Katie","Mike","IN·clued","School-based health clinic","Brookfield","Completed",1,false,0,1,"It was difficult to engage this group of students. The facilitator was able to work with the teacher to keep students on task and focused."]
["2025-01-12","9am","Katie","Lexi","Love Notes ","Community-based organization","Cambridge","Canceled",0,true,0,0,"Organization asked to reschedule. "]
["2025-01-15","1pm","Ash","Asher","Making Proud Choices!","Residential or group home","Brookfield","Completed",1,false,0,1,"The facilitator was able to engage the room effectively. The faciltiator was able to complete all the planned lessons. "]
["2025-01-17","10am","Katie","Lou","FLASH (high school)","High school","Medford","Scheduled",0,true,1,1]
["2025-01-20","12pm","Katie","Mia","Making Proud Choices!","High school","Medford","Scheduled",0,true,1,1]
["2025-02-13","12pm","Ash","Mia","Healthy Futures","Middle school","Cambridge","Scheduled",{"$f":"IF(H15=\"Completed\",1,0)","v":0},true,{"$f":"IF(AND(H15<>\"Completed\",H15<>\"Canceled\"), 1, 0)","v":1},{"$f":"SUM(I15,K15)","v":1}]
["End of worksheet"]

{"sheet":"Table 1. Required Observations","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,2,11],[4,0,4,2],[1,0,1,1]]}
["TPP Tier 1 Grant: Observation Planning Tool"]
["Observation tracking summary tables",null,"blank","blank","blank","blank","blank",null,"Time Period:","2024-25 Grant Year (Year 2)"]
["User notes (applicable to Tables 1-6): \n- Double check and, if needed, update the time period for this template (Cell J2). We recommend creating a separate workbook for each grant period. \n- This tab uses the data entered in EBP Observation Calculator and Observation Log to provide you with summary tables that display the number of observations planned and completed so far. \n- Do not manually edit the data in the tables below. These tables should only be updated by adding or editing data entered in the EBP Observation Calculator and Observation Log. \n- If this file is saved as a .xlms (macro-enabled Excel file) it will automatically refresh Tables 1-6. If the file is used without macros enabled (.xlsx) \n   you can refresh manually by right clicking any cell in the table and selecting “Refresh.” "]
["Blank"]
["Table 1. Sessions required to observe and schedule by EBP"]
["EBP Name","Sessions required to observe","Sessions remaining to schedule"]
["AIM 4 Teen Moms",3,2]
["Familias Unidas",70,70]
["FLASH (high school)",9,9]
["Get Real (middle school)",200,200]
["Healthy Futures",12,11]
["IN·clued",1,0]
["Love Notes ",10,10]
["Making Proud Choices!",15,13]
["Making Proud Choices! Out-of-Home Youth",25,25]
["Grand Total",345,340]
["End of worksheet"]

{"sheet":"Table 2. Completed by EBP","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Table 2. Observations completed by EBP"]
["EBP Name","Observations scheduled","Observations completed","Total"]
["AIM 4 Teen Moms",0,1,1]
["FLASH (high school)",1,0,1]
["Healthy Futures",1,1,2]
["IN·clued",0,1,1]
["Love Notes ",0,0,0]
["Making Proud Choices!",1,2,3]
["Grand Total",3,5,8]
["End of worksheet"]

{"sheet":"Table 3. Completed by Facilitat","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Table 3. Observations completed by facilitator"]
["Facilitator","Observations scheduled","Observations completed","Total"]
["Asher",0,1,1]
["Grey",0,1,1]
["Lauren",0,0,0]
["Lexi",0,0,0]
["Lou",1,0,1]
["Mia",2,1,3]
["Mike",0,1,1]
["Mira",0,1,1]
["Grand Total",3,5,8]
["End of worksheet"]

{"sheet":"Table 4. Completed by Setting","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Table 4. Observations completed by setting"]
["Setting","Observations scheduled","Observations completed","Total"]
["Community-based organization",0,0,0]
["High school",2,1,3]
["Middle school",1,1,2]
["Residential or group home",0,1,1]
["School-based health clinic",0,1,1]
["Home-based",0,1,1]
["Grand Total",3,5,8]
["End of worksheet"]

{"sheet":"Table 5. Completed by Location","index":7,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Table 5. Observations completed by location"]
["Location","Observations scheduled","Observations completed","Total"]
["Cambridge",1,1,2]
["Hopkins",0,1,1]
["Medford",2,1,3]
["Brookfield",0,2,2]
["Grand Total",3,5,8]
["End of worksheet"]

{"sheet":"Table 6. By EBP and Setting","index":8,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Table 6. Observations completed by EBP and setting"]
["blank","Community-based organization",null,"High school",null,"Middle school",null,"Residential or group home",null,"School-based health clinic",null,"Home-based",null,"Total Observations scheduled","Total Observations completed"]
["EBP","Community-based organization: \nObservations scheduled","Community-based organization: \nObservations completed","High school: \nObservations scheduled","High school: \nObservations completed","Middle school: \nObservations scheduled","Middle school: \nObservations completed","Residential or group home: \nObservations scheduled","Residential or group home: \nObservations completed","School-based health clinic: \nObservations scheduled","School-based health clinic: \nObservations completed","Home-based: \nObservations scheduled","Home-based: \nObservations completed","Total Observations scheduled","Total Observations completed"]
["AIM 4 Teen Moms",null,null,null,null,null,null,null,null,null,null,0,1,0,1]
["FLASH (high school)",null,null,1,0,null,null,null,null,null,null,null,null,1,0]
["Healthy Futures",null,null,null,null,1,1,null,null,null,null,null,null,1,1]
["IN·clued",null,null,null,null,null,null,null,null,0,1,null,null,0,1]
["Love Notes ",0,0,null,null,null,null,null,null,null,null,null,null,0,0]
["Making Proud Choices!",null,null,1,1,null,null,0,1,null,null,null,null,1,2]
["Grand Total",0,0,2,1,1,1,0,1,0,1,0,1,3,5]
["End of worksheet"]

{"sheet":"Dropdown data","index":9,"n_rows":73,"n_cols":4,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["EBPs","Population ","Setting"]
["2gether","Youth ","After school","Scheduled"]
["Adult Identity Mentoring (Project AIM)","Adults","Alternative school","Canceled"]
["AIM 4 Teen Moms","Families","Elementary school","Completed"]
["All4You!","LGBTQ youth","Middle school"]
["All4You2!","Expectant and parenting youth","High school"]
["Children's Aid Society (CAS)-Carrera Program","Sexually active youth","Postsecondary"]
["Choosing the Best JOURNEY","Youth at-risk of or experiencing homelessness","School-based health clinic"]
["Crossroads","Youth involved in the child welfare system","Community-based organization"]
["Familias Unidas","Youth involved in the juvenile justice system","Faith-based organization"]
["Families Talking Together","Youth with developmental disabilities","Health clinic or medical facility"]
["FLASH (high school)","Youth-serving professionals","Mental health clinic"]
["Get Real (middle school)","Males only","Correctional facility"]
["Generations","Females only","Home-based"]
["Girl2Girl","Nonbinary youth","Residential or group home"]
["Health-E you","Transgender youth","Mobile app"]
["Healthy Futures","Youth of any gender","Texting"]
["Health Improvement Project for Teens","African American or Black youth","Website"]
["Heritage Keepers Abstinence Education I ","American Indian or Alaska Native youth","Rural "]
["HORIZONS","Asian","Suburban"]
["IN·clued","Hispanic or Latino of any race","Urban"]
["It's Your Game: Keep It Real","White"]
["LeadHer","Youth of any race or ethnicity"]
["Linking Families and Teens ","6th grade "]
["Love Notes ","7th grade"]
["Making Proud Choices!","8th grade"]
["Making Proud Choices! Out-of-Home Youth","9th grade"]
["Making Proud Choices! California Edition","10th grade"]
["Me&You","11th grade"]
["MyPEEPS Mobile","12th grade"]
["Motivational Interviewing","Mixed grade"]
["Parenting in 2 Worlds"]
["Peer Group Connection – High School "]
["Plan A"]
["Positive Prevention PLUS – High School"]
["Positive Potential "]
["Possessing Your Power"]
["Power Through Choices"]
["Prime Time"]
["Project IMAGE"]
["Promoting Health Among Teens! Abstinence-Only Intervention"]
["Promoting Health Among Teens! Comprehensive Abstinence and Safer Sex Intervention"]
["Pulse"]
["Raising Healthy Children "]
["Reducing the Risk"]
["Relationship Smarts Plus"]
["Safer Choices"]
["Safer Sex Intervention"]
["Seventeen Days "]
["Sexual Health and Adolescent Risk Prevention "]
["Sisters Saving Sisters"]
["STRIVE"]
["Teen Options to Prevent Pregnancy (T.O.P.P.)"]
["Teen Outreach Program (TOP)"]
["Vision of You"]
["Your Move"]
[]
[]
["¡Cuídate! - INACTIVE"]
["Aban Aya Youth Project - INACTIVE"]
["Assisting in Rehabilitating Kids (ARK) - INACTIVE"]
["Be Proud! Be Responsible! - INACTIVE"]
["Be Proud! Be Responsible! Be Protective! - INACTIVE"]
["Becoming a Responsible Teen (BART) - INACTIVE"]
["Draw the Line/Respect the Line - INACTIVE"]
["FOCUS - INACTIVE"]
["Guy2Guy - INACTIVE"]
["Making a Difference! - INACTIVE"]
["Project TALC - INACTIVE"]
["Respeto/Proteger - INACTIVE"]
["Rikers Health Advocacy Program (RHAP) - INACTIVE"]
["SiHLE - INACTIVE"]
["Teen Health Project - INACTIVE"]