{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["YDE Tool"],"not_rendered":{"charts":0,"images":0,"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":"YDE Tool","index":0,"n_rows":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,16,0,19],[0,13,0,14],[0,7,0,11],[11,6,11,7],[11,0,11,1],[11,4,11,5],[7,0,8,5],[0,0,2,5],[11,20,12,20],[11,10,11,11],[1,18,1,19],[1,7,2,11],[11,12,11,13],[11,18,11,19],[11,8,11,9],[10,0,10,19],[11,2,11,3],[11,14,11,15],[1,13,2,13],[11,16,11,17],[1,16,1,17],[1,14,2,14]]}
["Youth Demographic Estimation Tool",null,null,null,null,null,null,null,null,null,null,null,null,"Participant\nSNAP Status",null,null,"Participant Age and Gender",null,null,null,null,"FY15 YDE tool"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Totals Must All be Equal for:\", CHAR(10), \"Participant SNAP Status = \", W4, CHAR(10),\"Participant Age and Gender = \", U4, CHAR(10),\"Participant Race and Ethnicity = \", U14)","v":"Totals Must All be Equal for:\nParticipant SNAP Status = 100\nParticipant Age and Gender = 100\nParticipant Race and Ethnicity = 100"},null,null,null,null,null,"SNAP","NON SNAP",null,"0 - 4 Yrs",null,"5 - 17 Yrs",null,"Age/\nGender\nTotal",null,"SNAP\nTotal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","F","M","F"]
[null,null,null,"Enter number of current participants:   ",15,null,null,null,null,null,null,null,"Enter site demographic data:   ",50,50,null,25,25,25,25,{"$f":"SUM(Q4:T4)","v":100},null,{"$f":"SUM(N4,O4)","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(N4/W4)","v":0.5},null,null,{"$f":"(Q4/U4)","v":0.25},{"$f":"(R4/U4)","v":0.25},{"$f":"(S4/U4)","v":0.25},{"$f":"(T4/U4)","v":0.25},{"$f":"SUM(Q5:T5)","v":1},{"$f":"(O4/W4)","v":0.5},{"$f":"SUM(N5,V5)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N5*$E$4","v":7.5},null,null,{"$f":"Q5*$E$4","v":3.75},{"$f":"R5*$E$4","v":3.75},{"$f":"S5*$E$4","v":3.75},{"$f":"T5*$E$4","v":3.75},{"$f":"SUM(Q6:T6)","v":15},{"$f":"V5*$E$4","v":7.5},{"$f":"SUM(N6,V6)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Current estimated participant demographic:   ",7.5,null,null,3.75,3.75,3.75,3.75]
["Current participants (cell E4) must not be greater than\nSNAP Status, Age and Gender, or Race and Ethnicity totals."]
[]
[]
["Participant Race and Ethnicity"]
["American Indian or Alaskan Native",null,"Asian",null,"Black or African American",null,"Native Hawaiian or Other Pacific Islander",null,"White",null,"American Indian or Alaska Native and White",null,"Asian and White",null,"Black or African American and White",null,"American Indian or Alaska Native and Black or African American",null,"All Others Reporting More than One Race",null,"Race and Ethnicity Total"]
["Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino","Hispanic/\nLatino","Non Hispanic/\nLatino"]
[5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"SUM(A14:T14)","v":100}]
[{"$f":"(A14/$U$14)","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,{"$f":"SUM(A15:T15)","v":1.0000000000000002}]
[{"$f":"A15*$E$4","v":0.75},0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,{"$f":"SUM(A16:T16)","v":15}]
[0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version: 2-29-2024"]