{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Reporting","October","November","December","January","February","March","April","May","June","July","August","September","VALUES"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"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":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Making Excel Work for Your Community"]
[null,null,null,null,"Sample CPS Intake Spreadsheet"]
[]
[]
[null,null,null,null,"Welcome to the Making Excel Work for Your Community learning series and toolkit! This Excel workbook is intended to be used"]
[null,null,null,null,"with the learning series as a way to practice building your Excel skills and to see examples of formulas and drop-down lists in action. "]
[null,null,null,null,"This example is based on spreadsheets the Center for Tribes has worked on with several child welfare programs. "]
[]
[null,null,null,null,"Looking for the full Excel learning series? You can find it at "]
[null,null,null,null,"https://tribalinformationexchange.org/index.php/making-excel-work-for-your-tribal-community"]
[]
[null,null,"In this workbook, you'll find the following features:"]
[]
[null,null,null,"1. Reporting Sheet - This worksheet contains all the data elements needed for quarterly BIA reporting (part B).    "]
[null,null,null,"Try adding data into the monthly spreadsheets and see how the counts are automatically tallied in the Reporting sheet. The Reporting sheet also shows"]
[null,null,null,"an example of how you can look at counts involving more than one data element - in this case, boys and girls who are in certain age groups. Try replicating"]
[null,null,null,"these formulas for other data elements that might interest you, such as how many teenagers are placed with a relative."]
[]
[null,null,null,"2. Monthly Intake Sheets - This workbook contains monthly intake sheets for a full federal fiscal year (for your reporting convenience).  Look at the "]
[null,null,null,"data elements and think through what changes you would make to fit your practice. "]
[]
[null,null,null,"3. Values Sheet - The last tab in this workbook contains the values used for the drop-down lists in the monthly intake sheets. You can change "]
[null,null,null,"or add lists of values to match your language and practice."]
[]
[]
[null,"Need more data help? Email us any time at info@cbc4tribes.org and keep an eye on the Tribal Information Exchange for more"]
[null,"resources and learning opportunities around data and many other topics that can support the work you do in your community."]
[]
[null,"Disclaimer: This is a sample document provided for instructional purposes only. All attempts have been made to provide accurate information. The Children's Bureau and the Capacity Building Center for Tribes cannot be held responsible for any errors. Please contact the CBCT for any assistance in using this tool at info@cbc4tribes.org or 1-800-871-8702.  "]
[]
[]
[]
[]
["__-"]

{"sheet":"Reporting","index":1,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,17]]}
["FFY 2019","Oct","Nov","Dec","Q1 Total","Jan","Feb","Mar","Q2 Total","Apr","May","Jun","Q3 Total","Jul","Aug","Sep","Q4 Total","Year-to-Date"]
["BIA Quarterly and Annual Report - Part B Tribal Child Abuse and Neglect Data"]
["Total Reports/Referrals Received",{"$f":"COUNTIF(October!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(November!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(December!A2:A500,\"*\")","v":0},{"$f":"SUM(B3:D3)","v":0},{"$f":"COUNTIF(January!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(February!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(March!A2:A500,\"*\")","v":0},{"$f":"SUM(F3:H3)","v":0},{"$f":"COUNTIF(April!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(May!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(June!A2:A500,\"*\")","v":0},{"$f":"SUM(J3:L3)","v":0},{"$f":"COUNTIF(July!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(August!A2:A500,\"*\")","v":0},{"$f":"COUNTIF(September!A2:A500,\"*\")","v":0},{"$f":"SUM(N3:P3)","v":0},{"$f":"SUM(Q3,M3,I3,E3)","v":0}]
["Substantiated",{"$f":"COUNTIF(October!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(November!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(December!AD2:AD500,\"Sub\")","v":0},0,{"$f":"COUNTIF(January!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(February!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(March!AD2:AD500,\"Sub\")","v":0},0,{"$f":"COUNTIF(April!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(May!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(June!AD2:AD500,\"Sub\")","v":0},0,{"$f":"COUNTIF(July!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(August!AD2:AD500,\"Sub\")","v":0},{"$f":"COUNTIF(September!AD2:AD500,\"Sub\")","v":0},0,{"$f":"SUM(E4,I4,M4,Q4)","v":0}]
["Unsubstantiated",{"$f":"COUNTIF(October!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(November!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(December!AD2:AD500,\"Unsub\")","v":0},0,{"$f":"COUNTIF(January!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(February!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(March!AD2:AD500,\"Unsub\")","v":0},0,{"$f":"COUNTIF(April!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(May!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(June!AD2:AD500,\"Unsub\")","v":0},0,{"$f":"COUNTIF(July!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(August!AD2:AD500,\"Unsub\")","v":0},{"$f":"COUNTIF(September!AD2:AD500,\"Unsub\")","v":0},0,0]
["Sexual Abuse",{"$f":"COUNTIF(October!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(November!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(December!R2:R500,\"Sex*\")","v":0},0,{"$f":"COUNTIF(January!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(February!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(March!R2:R500,\"Sex*\")","v":0},0,{"$f":"COUNTIF(April!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(May!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(June!R2:R500,\"Sex*\")","v":0},0,{"$f":"COUNTIF(July!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(August!R2:R500,\"Sex*\")","v":0},{"$f":"COUNTIF(September!R2:R500,\"Sex*\")","v":0},0,0]
["Physical Abuse",{"$f":"COUNTIF(October!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(November!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(December!R2:R500,\"Phys*\")","v":0},0,{"$f":"COUNTIF(January!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(February!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(March!R2:R500,\"Phys*\")","v":0},0,{"$f":"COUNTIF(April!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(May!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(June!R2:R500,\"Phys*\")","v":0},0,{"$f":"COUNTIF(July!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(August!R2:R500,\"Phys*\")","v":0},{"$f":"COUNTIF(September!R2:R500,\"Phys*\")","v":0},0,0]
["Neglect",{"$f":"COUNTIF(October!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(November!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(December!R2:R500,\"Negl*\")","v":0},0,{"$f":"COUNTIF(January!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(February!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(March!R2:R500,\"Negl*\")","v":0},0,{"$f":"COUNTIF(April!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(May!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(June!R2:R500,\"Negl*\")","v":0},0,{"$f":"COUNTIF(July!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(August!R2:R500,\"Negl*\")","v":0},{"$f":"COUNTIF(September!R2:R500,\"Negl*\")","v":0},0,0]
["Alcohol Involved",{"$f":"COUNTIF(October!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(November!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(December!U2:U500,\"Yes\")","v":0},0,{"$f":"COUNTIF(January!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(February!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(March!U2:U500,\"Yes\")","v":0},0,{"$f":"COUNTIF(April!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(May!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(June!U2:U500,\"Yes\")","v":0},0,{"$f":"COUNTIF(July!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(August!U2:U500,\"Yes\")","v":0},{"$f":"COUNTIF(September!U2:U500,\"Yes\")","v":0},0,0]
["Drugs and/or Inhalants",{"$f":"COUNTIF(October!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(November!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(December!T2:T500,\"Yes\")","v":0},0,{"$f":"COUNTIF(January!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(February!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(March!T2:T500,\"Yes\")","v":0},0,{"$f":"COUNTIF(April!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(May!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(June!T2:T500,\"Yes\")","v":0},0,{"$f":"COUNTIF(July!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(August!T2:T500,\"Yes\")","v":0},{"$f":"COUNTIF(September!T2:T500,\"Yes\")","v":0},0,0]
["Recurring Cases",{"$f":"COUNTIF(October!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(November!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(December!X2:X500,\"Yes\")","v":0},0,{"$f":"COUNTIF(January!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(February!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(March!X2:X500,\"Yes\")","v":0},0,{"$f":"COUNTIF(April!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(May!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(June!X2:X500,\"Yes\")","v":0},0,{"$f":"COUNTIF(July!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(August!X2:X500,\"Yes\")","v":0},{"$f":"COUNTIF(September!X2:X500,\"Yes\")","v":0},0,0]
["Cases of Siblings Involved",{"$f":"COUNTIF(October!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(November!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(December!M2:M500,\"Yes\")","v":0},0,{"$f":"COUNTIF(January!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(February!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(March!M2:M500,\"Yes\")","v":0},0,{"$f":"COUNTIF(April!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(May!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(June!M2:M500,\"Yes\")","v":0},0,{"$f":"COUNTIF(July!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(August!M2:M500,\"Yes\")","v":0},{"$f":"COUNTIF(September!M2:M500,\"Yes\")","v":0},0,0]
["Placement Out of Home",{"$f":"COUNTIF(October!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(November!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(December!AH2:AH500,\"Yes*\")","v":0},0,{"$f":"COUNTIF(January!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(February!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(March!AH2:AH500,\"Yes*\")","v":0},0,{"$f":"COUNTIF(April!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(May!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(June!AH2:AH500,\"Yes*\")","v":0},0,{"$f":"COUNTIF(July!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(August!AH2:AH500,\"Yes*\")","v":0},{"$f":"COUNTIF(September!AH2:AH500,\"Yes*\")","v":0},0,0]
["Petition to Tribal Court",{"$f":"COUNTIF(October!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(November!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(December!AE2:AE500,\"Pet*\")","v":0},0,{"$f":"COUNTIF(January!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(February!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(March!AE2:AE500,\"Pet*\")","v":0},0,{"$f":"COUNTIF(April!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(May!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(June!AE2:AE500,\"Pet*\")","v":0},0,{"$f":"COUNTIF(July!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(August!AE2:AE500,\"Pet*\")","v":0},{"$f":"COUNTIF(September!AE2:AE500,\"Pet*\")","v":0},0,0]
["Referral to Tribal Social Services",{"$f":"COUNTIF(October!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(November!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(December!AG2:AG500,\"Yes\")","v":0},0,{"$f":"COUNTIF(January!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(February!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(March!AG2:AG500,\"Yes\")","v":0},0,{"$f":"COUNTIF(April!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(May!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(June!AG2:AG500,\"Yes\")","v":0},0,{"$f":"COUNTIF(July!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(August!AG2:AG500,\"Yes\")","v":0},{"$f":"COUNTIF(September!AG2:AG500,\"Yes\")","v":0},0,0]
["Domestic Violence Involved",{"$f":"COUNTIF(October!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(November!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(December!V2:V500,\"Yes\")","v":0},0,{"$f":"COUNTIF(January!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(February!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(March!V2:V500,\"Yes\")","v":0},0,{"$f":"COUNTIF(April!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(May!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(June!V2:V500,\"Yes\")","v":0},0,{"$f":"COUNTIF(July!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(August!V2:V500,\"Yes\")","v":0},{"$f":"COUNTIF(September!V2:V500,\"Yes\")","v":0},0,0]
[]
["Age/Gender"]
["Age 0-5",{"$f":"SUM(B20:B21)","v":0},{"$f":"SUM(C20:C21)","v":0},{"$f":"SUM(D20:D21)","v":0},{"$f":"SUM(B19:D19)","v":0},{"$f":"SUM(F20:F21)","v":0},{"$f":"SUM(G20:G21)","v":0},0,{"$f":"SUM(F19:H19)","v":0},{"$f":"SUM(J20:J21)","v":0},{"$f":"SUM(K20:K21)","v":0},0,{"$f":"SUM(J19:L19)","v":0},{"$f":"SUM(N20:N21)","v":0},{"$f":"SUM(O20:O21)","v":0},0,{"$f":"SUM(N19:P19)","v":0},{"$f":"SUM(E19,I19,M19,Q19)","v":0}]
["Male",{"$f":"COUNTIFS(October!L2:L500,\"M*\",October!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"M*\",November!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"M*\",December!K2:K500,\"<6\")","v":0},{"$f":"SUM(B20:D20)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"M*\",January!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"M*\",February!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"M*\",March!K2:K500,\"<6\")","v":0},{"$f":"SUM(F20:H20)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"M*\",April!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"M*\",May!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"M*\",June!K2:K500,\"<6\")","v":0},{"$f":"SUM(J20:L20)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"M*\",July!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"M*\",August!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"M*\",September!K2:K500,\"<6\")","v":0},{"$f":"SUM(N20:P20)","v":0},{"$f":"SUM(E20,I20,M20,Q20)","v":0}]
["Female",{"$f":"COUNTIFS(October!L2:L500,\"F*\",October!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"F*\",November!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"F*\",December!K2:K500,\"<6\")","v":0},{"$f":"SUM(B21:D21)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"F*\",January!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"F*\",February!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"F*\",March!K2:K500,\"<6\")","v":0},{"$f":"SUM(F21:H21)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"F*\",April!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"F*\",May!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"F*\",June!K2:K500,\"<6\")","v":0},{"$f":"SUM(J21:L21)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"F*\",July!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"F*\",August!K2:K500,\"<6\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"F*\",September!K2:K500,\"<6\")","v":0},{"$f":"SUM(N21:P21)","v":0},{"$f":"SUM(E21,I21,M21,Q21)","v":0}]
["Age 6-10"]
["Male",{"$f":"COUNTIFS(October!L2:L500,\"M*\",October!K2:K500,\">5\",October!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"M*\",November!K2:K500,\">5\",November!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"M*\",December!K2:K500,\">5\",December!K2:K500,\"<11\")","v":0},{"$f":"SUM(B23:D23)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"M*\",January!K2:K500,\">5\",January!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"M*\",February!K2:K500,\">5\",February!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"M*\",March!K2:K500,\">5\",March!K2:K500,\"<11\")","v":0},{"$f":"SUM(F23:H23)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"M*\",April!K2:K500,\">5\",April!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"M*\",May!K2:K500,\">5\",May!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"M*\",June!K2:K500,\">5\",June!K2:K500,\"<11\")","v":0},{"$f":"SUM(J23:L23)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"M*\",July!K2:K500,\">5\",July!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"M*\",August!K2:K500,\">5\",August!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"M*\",September!K2:K500,\">5\",September!K2:K500,\"<11\")","v":0},{"$f":"SUM(N23:P23)","v":0},{"$f":"SUM(E23,I23,M23,Q23)","v":0}]
["Female",{"$f":"COUNTIFS(October!L2:L500,\"F*\",October!K2:K500,\">5\",October!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"F*\",November!K2:K500,\">5\",November!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"F*\",December!K2:K500,\">5\",December!K2:K500,\"<11\")","v":0},{"$f":"SUM(B24:D24)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"F*\",January!K2:K500,\">5\",January!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"F*\",February!K2:K500,\">5\",February!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"F*\",March!K2:K500,\">5\",March!K2:K500,\"<11\")","v":0},{"$f":"SUM(F24:H24)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"F*\",April!K2:K500,\">5\",April!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"F*\",May!K2:K500,\">5\",May!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"F*\",June!K2:K500,\">5\",June!K2:K500,\"<11\")","v":0},{"$f":"SUM(J24:L24)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"F*\",July!K2:K500,\">5\",July!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"F*\",August!K2:K500,\">5\",August!K2:K500,\"<11\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"F*\",September!K2:K500,\">5\",September!K2:K500,\"<11\")","v":0},{"$f":"SUM(N24:P24)","v":0},{"$f":"SUM(E24,I24,M24,Q24)","v":0}]
["Age 11-15"]
["Male",{"$f":"COUNTIFS(October!L2:L500,\"M*\",October!K2:K500,\">10\",October!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"M*\",November!K2:K500,\">10\",November!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"M*\",December!K2:K500,\">10\",December!K2:K500,\"<16\")","v":0},{"$f":"SUM(B26:D26)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"M*\",January!K2:K500,\">10\",January!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"M*\",February!K2:K500,\">10\",February!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"M*\",March!K2:K500,\">10\",March!K2:K500,\"<16\")","v":0},{"$f":"SUM(F26:H26)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"M*\",April!K2:K500,\">10\",April!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"M*\",May!K2:K500,\">10\",May!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"M*\",June!K2:K500,\">10\",June!K2:K500,\"<16\")","v":0},{"$f":"SUM(J26:L26)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"M*\",July!K2:K500,\">10\",July!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"M*\",August!K2:K500,\">10\",August!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"M*\",September!K2:K500,\">10\",September!K2:K500,\"<16\")","v":0},{"$f":"SUM(N26:P26)","v":0},{"$f":"SUM(E26,I26,M26,Q26)","v":0}]
["Female",{"$f":"COUNTIFS(October!L2:L500,\"F*\",October!K2:K500,\">10\",October!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"M*\",November!K2:K500,\">10\",November!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"F*\",December!K2:K500,\">10\",December!K2:K500,\"<16\")","v":0},{"$f":"SUM(B27:D27)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"F*\",January!K2:K500,\">10\",January!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"F*\",February!K2:K500,\">10\",February!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"F*\",March!K2:K500,\">10\",March!K2:K500,\"<16\")","v":0},{"$f":"SUM(F27:H27)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"F*\",April!K2:K500,\">10\",April!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"F*\",May!K2:K500,\">10\",May!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"F*\",June!K2:K500,\">10\",June!K2:K500,\"<16\")","v":0},{"$f":"SUM(J27:L27)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"F*\",July!K2:K500,\">10\",July!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"F*\",August!K2:K500,\">10\",August!K2:K500,\"<16\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"F*\",September!K2:K500,\">10\",September!K2:K500,\"<16\")","v":0},{"$f":"SUM(N27:P27)","v":0},{"$f":"SUM(E27,I27,M27,Q27)","v":0}]
["Age 16-18"]
["Male",{"$f":"COUNTIFS(October!L2:L500,\"M*\",October!K2:K500,\">15\",October!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"M*\",November!K2:K500,\">15\",November!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"M*\",December!K2:K500,\">15\",December!K2:K500,\"<19\")","v":0},{"$f":"SUM(B29:D29)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"M*\",January!K2:K500,\">15\",January!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"M*\",February!K2:K500,\">15\",February!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"M*\",March!K2:K500,\">15\",March!K2:K500,\"<19\")","v":0},{"$f":"SUM(F29:H29)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"M*\",April!K2:K500,\">15\",April!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"M*\",May!K2:K500,\">15\",May!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"M*\",June!K2:K500,\">15\",June!K2:K500,\"<19\")","v":0},{"$f":"SUM(J29:L29)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"M*\",July!K2:K500,\">15\",July!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"M*\",August!K2:K500,\">15\",August!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"M*\",September!K2:K500,\">15\",September!K2:K500,\"<19\")","v":0},{"$f":"SUM(N29:P29)","v":0},{"$f":"SUM(E29,I29,M29,Q29)","v":0}]
["Female",{"$f":"COUNTIFS(October!L2:L500,\"F*\",October!K2:K500,\">15\",October!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(November!L2:L500,\"M*\",November!K2:K500,\">15\",November!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(December!L2:L500,\"F*\",December!K2:K500,\">15\",December!K2:K500,\"<19\")","v":0},{"$f":"SUM(B30:D30)","v":0},{"$f":"COUNTIFS(January!L2:L500,\"F*\",January!K2:K500,\">15\",January!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(February!L2:L500,\"F*\",February!K2:K500,\">15\",February!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(March!L2:L500,\"F*\",March!K2:K500,\">15\",March!K2:K500,\"<19\")","v":0},{"$f":"SUM(F30:H30)","v":0},{"$f":"COUNTIFS(April!L2:L500,\"F*\",April!K2:K500,\">15\",April!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(May!L2:L500,\"F*\",May!K2:K500,\">15\",May!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(June!L2:L500,\"F*\",June!K2:K500,\">15\",June!K2:K500,\"<19\")","v":0},{"$f":"SUM(J30:L30)","v":0},{"$f":"COUNTIFS(July!L2:L500,\"F*\",July!K2:K500,\">15\",July!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(August!L2:L500,\"F*\",August!K2:K500,\">15\",August!K2:K500,\"<19\")","v":0},{"$f":"COUNTIFS(September!L2:L500,\"F*\",September!K2:K500,\">15\",September!K2:K500,\"<19\")","v":0},{"$f":"SUM(N30:P30)","v":0},{"$f":"SUM(E30,I30,M30,Q30)","v":0}]

{"sheet":"October","index":2,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"November","index":3,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"December","index":4,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"January","index":5,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"February","index":6,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"March","index":7,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"April","index":8,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"May","index":9,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"June","index":10,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"July","index":11,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"August","index":12,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"September","index":13,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Case ID#","Case Name","Date of Report","Time of Report","Report Source","Priority","Assigned to","Date of Initial Contact","Time of Initial Contact","Name of Child","Child Age","Child Gender","Siblings Involved","Total # Children in Home","Name of Perpetrator","Perp In Home?","Relationship to Child(ren)","Type of Allegation","If Neglect, Type of Neglect","Drugs","Alcohol","DV","MH Issues","Prior Reports","Family Names of Mother","Family Names of Father","Street Address","City or Town","Zip Code","Finding","Disposition","Initial Hearing Date","Referred to Services","Emergency Placement","Placement Licensed"]

{"sheet":"VALUES","index":14,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Male",null,null,null,null,null,null,"Family resides outside agency jurisdiction"]
["Female","Physical","Meth",null,null,null,null,"Incident outdated (historical)"]
[null,"Medical","Subox",null,null,null,null,"Insufficient information to locate family"]
[1,"Educational","Marijuana",null,null,null,null,"No specific allegation or insufficient information"]
[2,null,"Other",null,null,null,null,"Perp is not a parent or guardian"]
[3,null,null,null,null,null,null,"Report citing injury already being investigated"]
[4,null,"Field Visit",null,null,null,null,"Report citing same incident"]
[null,"Physical Abuse","Mail/Referral",null,null,"Yes"]
[null,"Sexual Abuse","Office Visit",null,null,"No",null,"Centralized Intake"]
[null,"Neglect","Telephone",null,null,null,null,"Tribal Law Enforcement"]
[null,"Born Drug Affected",null,null,null,null,"January","IHS "]
[null,"Suicide Attempt (Child)",null,"Arrest Made",null,null,"February","School"]
[null,"School Attendance",null,"Domestic Violence",null,1,"March","Walk-in/Phone"]
[null,"Custody Matter",null,"Homeless",null,2,"April","Anonymous"]
[null,"Other/Off Res",null,"Juvenile-Alcohol use",null,3,"May","Other Source"]
[null,null,null,"Juvenile-Drug use",null,4,"June"]
[null,null,null,"Parent-Alcohol use",null,null,"July","Missing"]
[null,null,null,"Parent-Drug use",null,null,"August","On File"]
[null,null,null,null,null,null,"September","Pending"]
[null,"In-home services",null,"Sub",null,null,"October"]
[null,"Petition filed",null,"Unsub",null,null,"November"]
[null,"No Further Action",null,null,null,null,"December"]
[null,null,null,"Licensed","IV-E"]
[null,null,null,"Unlicensed","IV-B",null,"Complete"]
[null,null,null,"Pending",null,null,"In Progress"]
[]
[]
[null,null,null,"Yes-Relative","Yes"]
[null,null,null,"Yes-Non-Relative","No"]
[null,null,null,"Yes-Shelter"]
[null,null,null,"Not Placed"]