{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Sample of Master List","Month 1"],"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":"Instructions","index":0,"n_rows":66,"n_cols":1,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[" CACFP AUTOMATED MASTER LIST INSTRUCTIONS"]
["Setting up the Original Master List :"]
["Step 1. Name this original blank Master List spreadsheet with a name you will remember and SAVE (\"File\" \"Save As\")."]
["Step 2. Print these instructions to follow as you proceed through this process."]
["Step 3. Click on the \"First Month\" tab at the bottom of the screen and begin Step 4."]
["Step 4. Enter the date, institutioin name, facility name, and license capacity. Do not type into the shaded boxes.  "]
["Step 5. Enter the following information when setting up the center original Master List for the first month:"]
["Child's last name à      Child's first name à   Whether the child is actively enrolled - enter an x in the column (if the child \n"]
["is inactive leave this column blank and the child will not be included in any of the calculations).   IEF renewal date (m/d/yy) à"]
["Benefit Category: child's Free, Reduced, or Paid status - enter an X in the appropriate column à  Title XX (Subsidized "]
["care payment by DWS if appropriate – enter an x in the column  à Civil Rights information if using this form to report data à    "]
["Ethnicity, limited to: H=Hispanic or N=non-Hispanic  à  Race (choose one): AI=American Indian/Alaskan Native, "]
["A=Asian, B= Black or African American,  \nNH= Native Hawaiian or Pacific Islander, W=White,"]
["Step 6. Right click on the First Month tab.  Click on Rename. Type in the current month name and year."]
["Step 7. Save your work by clicking on the save icon ( < ) on the tool bar. "]
["Step 8. As new children enter during the month, repeat Step 5, adding them at the bottom of the list."]
["Step 9. Sort the list as described below, \"Sorting the List.\""]
["Step 10. Save your work by clicking on the save icon ( < ) on the tool bar."]
[]
["Monthly Master List Updating and Maintainence:"]
["Step 1: Ensure all children that are actively enrolled in the center have an X in the apropriate column.  For-profit or "]
["Title XX Center Eligibility: to claim each month, a minimum of 25% of license capacity or total enrolled children "]
["must be either free/reduced price or paid for with Title XX  funds from the Department of Workforce Services (DWS). "]
["(If qualifying by Title XX, enter an X on the Title XX column for each child). The total current number enrolled, total "]
["free/reduced price and total Title XX enrollees will be automatically calculated. The percentage of children free/reduced"]
["price and children paid for using Title XX funds will be automatically calculated for both license capacity and total "]
["enrolled to determine center eligibility."]
["Step 2: Determine whether new/updated CACFP required information or income eligibility (IEF) information is needed "]
["by sorting the list as described below, Sorting the List."]
["Step 3: Right click in the tab for the month.  Click on Move or Copy.  Click the Create a copy box. Click on"]
["(move to end). Click OK.  Right click on the newly-copied tab (it will have a (2) following the name). Click Rename."]
["Type in the name of the new month. Save your work by clicking on the save icon ( < ) on the tool bar. "]
[]
["Sorting the List"]
["To Sort the Children Alphabetically by Last Name:"]
["A. Select the complete area that you want to sort by highlighting the cells from row 18 and columns A-J"]
["to the end of the rows where children's names are entered."]
["B. On the Tool Bar, select the following in this order:"]
[" àData"]
["  (A window will appear)"]
["    àSelect :Sort"]
["   (A Sort window will open with several options)"]
["    àSelect: Sort by:  Column A (CHILD'S LAST NAME) "]
["    àSelect: Ascending (this will sort from A-Z))"]
[" à At Then by, click the drop-down arrow and select (none)"]
["    àSelect: OK (this will do the sort)"]
["C. Then Save and print"]
["ll. To Sort the Children by Benefit Category then Alphabetically by Last Name:"]
["A.Select the complete area that you want to sort by highlighting the cells from row  8 and columns"]
[" A-N to the end of the rows where children's names are entered."]
["B. On the Tool Bar select the following in this order:"]
[" àData"]
["  (A window will appear)"]
["    àSelect :Sort"]
["  ( A Sort window will open with several options)"]
["    àSelect: Sort by: Column F (Free Benefit Category)"]
["    àSelect: Ascending (this will sort from A-Z))"]
["    àSelect: Then by: Column G  (Reduced Price Category)"]
["    àSelect: Ascending (this will sort from A-Z))"]
["    àSelect: OK (this will do the sort)"]
["C. Then Save and print"]
["III. To sort by any other category, follow the same basic pattern."]
["Note:  There are 200 rows (through row 218) to enter child information. If you need more rows, please contact "]
["USOE for instructions. When a child leaves, the row with her/his information may be deleted without harm"]
["to the spreadsheet. However, rows cannot be inserted without special instruction. Add new children to the"]
["end of the list and sort them alphabetically later."]

{"sheet":"Sample of Master List","index":1,"n_rows":218,"n_cols":13,"rows_kept":218,"cut":false,"hidden":false,"merged":[]}
["                                                      ","MASTER LIST OF ENROLLED CHILDREN"]
[null,"PROGRAM ELIGIBILITY AND/OR CIVIL RIGHTS ROSTER"]
[null,null,null,null,null,null,"Participant Race/Ethnicity Summary"]
[null,null,null,null,null,null,"Ethnicity ","Hispanic = (H)",null,{"$f":"COUNTIFS(C18:C218,\"x\", I18:I218,\"H\")","v":4}]
["Date: 1/1/2015",null,null,null,null,null,null,"Non-Hispanic = (N)",null,{"$f":"COUNTIFS(C18:C218,\"x\", I18:I218,\"N\")","v":7}]
[null,null,null,null,null,null,"Race","A. Ind/AK Nat. = (AI)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"AI\")","v":2}]
["Institution Name: Healthy Kids LLC",null,null,null,null,null,null,"Asian = (A)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"A\")","v":1}]
[null,null,null,null,null,null,null,"Black/AF A. = (B)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"B\")","v":2}]
["Facility Name: Healthy Kids SLC",null,null,null,null,null,null,"Nat. HI/ Pac Is. = (NH)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"NH\")","v":1}]
[null,null,null,null,null,null,null,"White = (W) ",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"W\")","v":5}]
[null,null,null,null,"Enrol/Free","Enrol/Red","Enrol/Paid","Total Ethnicity",null,{"$f":"J5+J4","v":11}]
["License capacity:",100,null,null,{"$f":"COUNTIF(K18:K218,\"TRUE\")","v":6},{"$f":"COUNTIF(L18:L218,\"TRUE\")","v":2},{"$f":"COUNTIF(M18:M218,\"TRUE\")","v":3},"Total Race",null,{"$f":"SUM(J6:J10)","v":11}]
["Currently Enrolled ",{"$f":"COUNTIF(C18:C218,\"x\")","v":11},null,null,null,"% of enrolled",null,null,"% of Capacity "]
["Actively Enrolled Free/Reduced:",{"$f":"E12+F12","v":8},"Percent F/R:",null,null,{"$f":"B14/B13","v":0.72727272727272729},null,null,{"$f":"B14/B12","v":0.08}]
[" DWS Funded (Title XX):",{"$f":"COUNTIFS(C18:C218,\"x\",H18:H218,\"x\")","v":8},"% DWS Funded (Title XX):",null,null,{"$f":"B15/B13","v":0.72727272727272729},null,null,{"$f":"B15/B12","v":0.08}]
[null,null,null,null,"Benefit Category",null,null,null,"Civil Rights"]
["CHILD'S LAST NAME","CHILD'S FIRST NAME","Actively Enrolled","IEF renewal date","Free","Red","Paid","Title XX","Ethnicity","Race","F\\Enrolled","R/Enrolled","P/Enrolled"]
["Allen","Sam","x","2015-01-01","x",null,null,"x","N","W",{"$f":"IF(C18=\"x\", E18=\"x\")","v":true},{"$f":"IF(C18=\"x\", F18=\"x\")","v":false},{"$f":"IF(C18=\"x\", G18=\"x\")","v":false}]
["Baker","Michael","x","2015-01-02","x",null,null,"x","N","AI",{"$f":"IF(C19=\"x\", E19=\"x\")","v":true},{"$f":"IF(C19=\"x\", F19=\"x\")","v":false},{"$f":"IF(C19=\"x\", G19=\"x\")","v":false}]
["Christensen","Mitchell ","x","2015-01-03","x",null,null,"x","H","A",{"$f":"IF(C20=\"x\", E20=\"x\")","v":true},false,false]
["Dunn","Sara","x","2015-01-04",null,"x",null,"x","N","B",false,true,false]
["Ellsworth","Beth","x","2015-01-05","x",null,null,"x","N","NH",true,false,false]
["Franson","Becky","x","2015-01-06",null,null,"x",null,"N","W",false,false,true]
["Grimm","Jane ","x","2015-01-07","x",null,null,"x","H","W",true,false,false]
["Hanson","Janica","x","2014-12-25",null,"x",null,"x","H","B",false,true,false]
["Ison","Suzy","x","2015-01-09","x",null,null,"x","N","AI",true,false,false]
["Jackson","Frankie","x","2015-01-10",null,null,"x",null,"H","W",false,false,true]
["Kershaw","Danica","x","2015-01-11",null,null,"x",null,"N","W",false,false,true]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(C83=\"x\", F83=\"x\")","v":false},{"$f":"IF(C83=\"x\", G83=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C84=\"x\", E84=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(C147=\"x\", F147=\"x\")","v":false},{"$f":"IF(C147=\"x\", G147=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C148=\"x\", E148=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(C211=\"x\", F211=\"x\")","v":false},{"$f":"IF(C211=\"x\", G211=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C212=\"x\", E212=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]

{"sheet":"Month 1","index":2,"n_rows":218,"n_cols":13,"rows_kept":218,"cut":false,"hidden":false,"merged":[]}
[null,"              MASTER LIST OF ENROLLED CHILDREN                           "]
[null,"PROGRAM ELIGIBILITY AND/OR CIVIL RIGHTS ROSTER"]
[null,null,null,null,null,null,"Participant Race/Ethnicity Summary"]
[null,null,null,null,null,null,"Ethnicity ","Hispanic = (H)",null,{"$f":"COUNTIFS(C18:C218,\"x\", I18:I218,\"H\")","v":0}]
["Date: ",null,null,null,null,null,null,"Non-Hispanic = (N)",null,{"$f":"COUNTIFS(C18:C218,\"x\", I18:I218,\"N\")","v":0}]
[null,null,null,null,null,null,"Race","A. Ind/AK Nat. = (AI)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"AI\")","v":0}]
["Institution Name:",null,null,null,null,null,null,"Asian = (A)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"A\")","v":0}]
[null,null,null,null,null,null,null,"Black/AF A. = (B)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"B\")","v":0}]
["Facility Name: ",null,null,null,null,null,null,"Nat. HI/ Pac Is. = (NH)",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"NH\")","v":0}]
[null,null,null,null,null,null,null,"White = (W) ",null,{"$f":"COUNTIFS(C18:C218,\"x\", J18:J218,\"W\")","v":0}]
[null,null,null,null,"Enrol/Free","Enrol/Red","Enrol/Paid","Total Ethnicity",null,{"$f":"J5+J4","v":0}]
["License capacity:",null,null,null,{"$f":"COUNTIF(K18:K218,\"TRUE\")","v":0},{"$f":"COUNTIF(L18:L218,\"TRUE\")","v":0},{"$f":"COUNTIF(M18:M218,\"TRUE\")","v":0},"Total Race",null,{"$f":"SUM(J6:J10)","v":0}]
["Currently Enrolled ",{"$f":"COUNTIF(C18:C218,\"x\")","v":0},null,null,null,"% of enrolled",null,null,"% of Capacity "]
["Actively Enrolled Free/Reduced:",{"$f":"E12+F12","v":0},"Percent F/R:",null,null,{"$f":"B14/B13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"B14/B12","v":{"$error":"#DIV/0!"}}]
[" DWS Funded (Title XX):",{"$f":"COUNTIFS(C18:C218,\"x\",H18:H218,\"x\")","v":0},"% DWS Funded (Title XX):",null,null,{"$f":"B15/B13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"B15/B12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Benefit Category",null,null,null,"Civil Rights"]
["CHILD'S LAST NAME","CHILD'S FIRST NAME","Actively Enrolled","IEF renewal date","Free","Red","Paid","Title XX","Ethnicity","Race","F\\Enrolled","R/Enrolled","P/Enrolled"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18=\"x\", E18=\"x\")","v":false},{"$f":"IF(C18=\"x\", F18=\"x\")","v":false},{"$f":"IF(C18=\"x\", G18=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19=\"x\", E19=\"x\")","v":false},{"$f":"IF(C19=\"x\", F19=\"x\")","v":false},{"$f":"IF(C19=\"x\", G19=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=\"x\", E20=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(C83=\"x\", F83=\"x\")","v":false},{"$f":"IF(C83=\"x\", G83=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C84=\"x\", E84=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(C147=\"x\", F147=\"x\")","v":false},{"$f":"IF(C147=\"x\", G147=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C148=\"x\", E148=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(C211=\"x\", F211=\"x\")","v":false},{"$f":"IF(C211=\"x\", G211=\"x\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C212=\"x\", E212=\"x\")","v":false},false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,false,false,false]