{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["YDE Tool"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,4],[6,0,6,4]]}
["Youth Demographic Estimation Tool"]
[]
[null,null,"Enter number of current participants:",100]
[]
["Current participants (cell D3) must not be greater than Gender, Race, or Ethnicity totals."]
[]
[{"$f":"CONCATENATE(\"Totals Must All be Equal for Participant: \", CHAR(10), \"Gender = \", E11, CHAR(10), \" | Race = \", H19, CHAR(10), \" | Ethnicity = \", E27)","v":"Totals Must All be Equal for Participant: \nGender = 100\n | Race = 100\n | Ethnicity = 100"}]
[]
[null,null,"Participant Gender"]
["Male","Female","Prefer not to respond","Unknown","Gender Total"]
[25,25,25,25,{"$f":"SUM(A11:D11)","v":100}]
[{"$f":"A11/$E$11","v":0.25},{"$f":"B11/$E$11","v":0.25},{"$f":"C11/$E$11","v":0.25},{"$f":"D11/$E$11","v":0.25},{"$f":"SUM(A12:D12)","v":1}]
[{"$f":"A12*$D$3","v":25},{"$f":"B12*$D$3","v":25},{"$f":"C12*$D$3","v":25},{"$f":"D12*$D$3","v":25},{"$f":"SUM(A13:D13)","v":100}]
[25,25,25,25]
[]
[]
[null,null,"Participant Race"]
["American Indian or Alaskan Native","Asian","Black or African American","Native Hawaiian or Other Pacific Islander","White","Prefer not to respond","Unknown","Race Total"]
[10,10,10,10,20,20,20,{"$f":"SUM(A19:G19)","v":100}]
[{"$f":"A19/$H$19","v":0.1},0.1,0.1,0.1,0.2,0.2,0.2,{"$f":"SUM(A20:G20)","v":1}]
[{"$f":"A20*$D$3","v":10},10,10,10,20,20,20,{"$f":"SUM(A21:G21)","v":100}]
[10,10,10,10,20,20,20]
[]
[]
[null,null,"Participant Ethnicity"]
["Hispanic/Latino","Non-Hispanic/Latino","Prefer not to respond","Unknown","Ethnicity Total"]
[25,25,25,25,{"$f":"SUM(A27:D27)","v":100}]
[{"$f":"A27/$E$27","v":0.25},{"$f":"B27/$E$27","v":0.25},{"$f":"C27/$E$27","v":0.25},{"$f":"D27/$E$27","v":0.25},{"$f":"SUM(A28:D28)","v":1}]
[{"$f":"A28*$D$3","v":25},{"$f":"B28*$D$3","v":25},{"$f":"C28*$D$3","v":25},{"$f":"D28*$D$3","v":25},{"$f":"SUM(A29:D29)","v":100}]
[25,25,25,25,null,null,"Version: 01-09-2025"]