{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INSTRUCTIONS","Section A-CC & Settings by Age","Section B-CC & Settings by RE","Section C-Child Count by Gender","Section D-At Risk Child Count","Section E-Cumulative CC","Year-to-Year Change","Failed Edit Checks and Warnings"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"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":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[8,1,8,13],[37,1,37,13],[44,1,47,13],[49,1,49,13],[40,1,43,11],[39,1,39,13],[48,1,48,13],[26,2,27,13],[50,1,50,13],[29,2,31,13],[1,1,1,13],[2,1,2,13],[36,1,36,13],[33,1,34,13],[11,1,12,1],[11,2,12,13],[14,2,15,13],[14,1,15,1],[17,2,18,13],[17,1,18,1],[20,2,21,13],[20,1,21,1],[23,2,24,13],[23,1,24,1]]}
["\n\n\n"]
[null,"Part C Child Count and Settings Data Tool"]
[null,"The Part C Child Count and Settings Data Tool is designed to be used by states as they prepare "]
[null,"their data for submission via EMAPS. The tool can identify potential format errors, validation"]
[null,"errors, and other errors in subtotals or totals. "]
[]
[null,"Data cannot be submitted using this tool. All data must be submitted following the "]
[null,"guidelines provided in the EMAPS IDEA Part C Child Count and Settings User Guide at:"]
[null,"https://www2.ed.gov/about/inits/ed/edfacts/emaps-idea-part-c-child-count-user-guide.pdf"]
[]
[null,"Please read the following basic guidelines before using this tool:"]
[null,"1.","To change the size and appearance of the text on the spreadsheet, select VIEW from the toolbar, select ZOOM, and then select the percentage increase or decrease."]
[]
[]
[null,"2.","Enter the appropriate data into each table on each tab (Sections A, B, C, D, and E) according to the EMAPS specifications for each entry."]
[]
[]
[null,"3.","Do not copy/paste values, enter values by typing them in (especially true in EMAPS online system, good to practice that here)."]
[]
[]
[null,"4.","Enter postive, whole numbers for each child count entry. Use M for Missing and only use NA for applicable cells for ages 4 and older, per EMAPs documentation."]
[]
[]
[null,"5.","RED cells indicate invalid data entries. Each error will highlight a row in the Error Messages table to the right of data entry tables. Use that information to fix all errors.  "]
[]
[]
[null,"6.","To check for any blank data entry cells, click the button labeled \"Click here to check for blank cells in Sections A, B, C, D, and E\" near the top of the Section A tab."]
[]
[]
[null,"7. ","To compare data currently entered in Sections A through E to data for a prior year, enter prior year data in the data entry cells in column C (highlighted in yellow) on the Year-to-Year Change tab. "]
[]
[]
[]
[null,"Please note this tool is currently not 508 accessible. If you would like assistance with the use of this tool, please contact DaSy at dasy-center@sri.com."]
[]
[]
[null,"Version Date: May 2023"]
[]
[]
[null,"About Us"]
[null,"The contents of this report were developed under a grant from the U.S. Department of Education, #H373Z190002. However, those contents do not necessarily represent the policy of the U.S. Department of Education, and you should not assume endorsement by the Federal Government. Project Officers, Meredith Miceli and Amy Bae."]
[]
[]
[]
[null,"The DaSy Center is a national technical assistance center funded by the U.S. Department of Education, Office of Special Education Programs. The DaSy Center works with states to support IDEA early intervention and early childhood special education state programs in the development or enhancement of coordinated early childhood longitudinal data systems."]
[]
[]
[]
[null,"To learn more about the DaSy Center, visit the DaSy Center website at "]
[null,"http://www.dasycenter.org/."]

{"sheet":"Section A-CC & Settings by Age","index":1,"n_rows":50,"n_cols":38,"rows_kept":50,"cut":false,"hidden":false,"merged":[[40,7,41,7],[34,9,35,9],[37,9,38,9],[40,9,41,9],[46,12,48,21],[36,12,39,21],[40,12,42,21],[43,12,45,21],[34,10,35,10],[37,10,38,10],[40,10,41,10],[6,12,8,21],[5,12,5,21],[9,12,9,21],[14,12,17,21],[34,1,35,1],[34,3,35,3],[34,7,35,7],[30,12,30,21],[31,12,32,21],[33,12,33,21],[34,12,34,21],[35,12,35,21],[18,12,20,21],[13,12,13,21],[10,12,10,21],[11,12,11,21],[12,12,12,21],[9,10,10,10],[12,10,13,10],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,5,16,5],[15,7,16,7],[15,10,16,10],[15,9,16,9],[12,5,13,5],[12,7,13,7],[12,9,13,9],[9,9,10,9],[9,5,10,5],[9,7,10,7],[9,1,10,1],[9,2,10,2],[9,3,10,3],[12,1,13,1],[12,2,13,2],[12,3,13,3],[49,12,49,21],[21,12,23,21],[24,12,24,21],[25,12,27,21],[21,1,21,7],[37,1,38,1],[40,1,41,1],[34,2,35,2],[37,2,38,2],[40,2,41,2],[37,3,38,3],[40,3,41,3],[34,5,35,5],[37,5,38,5],[40,5,41,5],[37,7,38,7]]}
[]
["   Section A: Child Count and Settings by Age",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas for check date,\"M\",\"NA\",special characters,\"-\""]
[null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01","2022-12-01"]
[null,"What is your state's Child Count date (MM/DD/YYYY)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(TEXT(H4,\"mm/dd\")>=(TEXT(AB3,\"mm/dd\")),TEXT(H4,\"mm/dd\")<=(TEXT(AC3,\"mm/dd\")))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas for Individual Settings Error",null,{"$f":"IF(AI6&AI7&AI8=\"\",\"[PartC-CC036a], [PartC-CC036b], [PartC-CC036c]\",\"\")","v":"[PartC-CC036a], [PartC-CC036b], [PartC-CC036c]"}]
[null,"A1. Age Group and Setting of Infants and Toddlers, Ages Birth through 2",null,null,null,null,null,null,null,null,null,null,"ERROR MESSAGES FOR SECTION A1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D10)))>0,1,0)","v":0},{"$f":"IF(OR(D10=\"M\",D13=\"M\", D16=\"M\",F10=\"M\",F13=\"M\",F16=\"M\",H10=\"M\",H13=\"M\",H16=\"M\"),1,0)","v":0},{"$f":"IF(ISNUMBER(FIND(\".\",D10)),1,0)","v":0},{"$f":"IF(OR(D10=\"NA\",D13=\"NA\", D16=\"NA\",F10=\"NA\",F13=\"NA\",F16=\"NA\",H10=\"NA\",H13=\"NA\",H16=\"NA\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT(D10),D10<>\"M\",D10<>\"NA\"),1,0)","v":0},"Home",{"$f":"IFERROR(IF(D19<>'Section B-CC & Settings by RE'!D21,\"Home\",\"\"),\"\")","v":""},{"$f":"IF(AH6=\"\",\"\",\"[PartC-CC036a]\")","v":""},null,{"$f":"IF(AH6=\"\",\"\",AH6&\" and \")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D13)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D13)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D13),D13<>\"M\",D13<>\"NA\"),1,0)","v":0},"Community-based",{"$f":"IFERROR(IF(F19<>'Section B-CC & Settings by RE'!F21,\"Community-Based\",\"\"),\"\")","v":""},{"$f":"IF(AH7=\"\",\"\",\"[PartC-CC036b]\")","v":""},null,{"$f":"IF(AH7=\"\",\"\",AH7&\" and \")","v":""}]
[null,null,null,null,null,"Community-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D16)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D16)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D16),D16<>\"M\",D16<>\"NA\"),1,0)","v":0},"Other",{"$f":"IFERROR(IF(H19<>'Section B-CC & Settings by RE'!H21,\"Other\",\"\"),\"\")","v":""},{"$f":"IF(AH8=\"\",\"\",\"[PartC-CC036c]\")","v":""}]
[null,null,null,"Home",null,"Based Setting",null,"Other Setting",null,"Total","Percentage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F10)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F10)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F10),F10<>\"M\",F10<>\"NA\"),1,0)","v":0},null,{"$f":"COUNTIF(AH6:AH8,\"\")","v":3},{"$f":"IF(AH9=3,\"____\",\"\")","v":"____"},{"$f":"IF(AH9=2,AH6&AH7&AH8,\"\")","v":""},{"$f":"IF(AND(AH9=1,AH8=\"\"),AK6&AH7,IF(AND(AH9=1,AH7=\"\"),AK6&AH8,IF(AND(AH9=1,AK7=\"\"),AK7&AH8,\"\")))","v":""},{"$f":"IF(AH9=0,\"Home, Community-Based, and Other\",\"\")","v":""}]
[null,"1."," Birth to 1",null,null,null,null,null,null,{"$f":"IF(OR(D10=\"\",F10=\"\",H10=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D10),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F10),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H10),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J10/$J$19,\"\")","v":""},"X","•  The reported Child Count date does not fall between October 1 and December 1, inclusive of those dates. [PartC-CC001]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F13)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F13)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F13),F13<>\"M\",F13<>\"NA\"),1,0)","v":0},null,null,{"$f":"AI9&AJ9&AK9&AL9","v":"____"}]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F16)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F16)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F16),F16<>\"M\",F16<>\"NA\"),1,0)","v":0},null,{"$f":"\"•  The total(s) of infants and toddlers, ages birth through 2, by age in the setting(s) \"&AI10&\" does not equal the total(s) of infants and toddlers by race/ethnicity in the setting(s) \"&AI10&\". If data are not accurate, please correct the data. If data are accurate, please create a data note for submission in EMAPS explaining the difference.\"","v":"•  The total(s) of infants and toddlers, ages birth through 2, by age in the setting(s) ____ does not equal the total(s) of infants and toddlers by race/ethnicity in the setting(s) ____. If data are not accurate, please correct the data. If data are accurate, please create a data note for submission in EMAPS explaining the difference."}]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H10)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H10)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(H10),H10<>\"M\",H10<>\"NA\"),1,0)","v":0},null,"Formula for Section A1 Errors"]
[null,"2."," 1 to 2",null,null,null,null,null,null,{"$f":"IF(OR(D13=\"\",F13=\"\",H13=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H13),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J13/$J$19,\"\")","v":""},"X","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H13)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H13)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(H13),H13<>\"M\",H13<>\"NA\"),1,0)","v":0},null,{"$f":"IF(OR(J19=\"\",J19=\"ERROR\"),\"\",J19)","v":""},{"$f":"IFERROR(IF('Section B-CC & Settings by RE'!J21=\"\",\"\",'Section B-CC & Settings by RE'!J21),\"\")","v":""},{"$f":"IFERROR(IF(AI13=\"\",\"\",ABS(($AH$13-AI13)/IF(OR($AH$13=\"\",AI13=\"\"),\"\",IF($AH$13>AI13,$AH$13,IF($AH$13<AI13,AI13,\"\"))))),\"\")","v":""},{"$f":"OR($AH$13=AI13,AJ13<=0.01)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  'NA' is not a valid value in Section A1. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H16)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H16)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(H16),H16<>\"M\",H16<>\"NA\"),1,0)","v":0},null,null,{"$f":"IFERROR(IF('Section C-Child Count by Gender'!C11=\"\",\"\",'Section C-Child Count by Gender'!C11),\"\")","v":""},{"$f":"IFERROR(IF(AI14=\"\",\"\",ABS(($AH$13-AI14)/IF(OR($AH$13=\"\",AI14=\"\"),\"\",IF($AH$13>AI14,$AH$13,IF($AH$13<AI14,AI14,\"\"))))),\"\")","v":""},{"$f":"OR($AH$13=AI14,AJ14<=0.01)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,"X",{"$f":"$AH$11&\" \"&_xlfn.TEXTJOIN(\", \",TRUE,AI5:AI8)","v":"•  The total(s) of infants and toddlers, ages birth through 2, by age in the setting(s) ____ does not equal the total(s) of infants and toddlers by race/ethnicity in the setting(s) ____. If data are not accurate, please correct the data. If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC036a], [PartC-CC036b], [PartC-CC036c]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB6:AB14)","v":0},null,{"$f":"SUM(AD6:AD14)","v":0},null,{"$f":"SUM(AF6:AF14)","v":0},null,null,{"$f":"IFERROR(IF('Section E-Cumulative CC'!E27=\"\",\"\",'Section E-Cumulative CC'!E27),\"\")","v":""},null,{"$f":"AI15>=AH13","v":true}]
[null,"3."," 2 to 3",null,null,null,null,null,null,{"$f":"IF(OR(D16=\"\",F16=\"\",H16=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D16),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F16),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H16),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J16/$J$19,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[null,"Total (Birth through 2) ",null,{"$f":"IF(OR(D10=\"\",D13=\"\",D16=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D10),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D16),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IF(OR(F10=\"\",F13=\"\",F16=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(F10),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F16),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IF(OR(H10=\"\",H13=\"\",H16=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(H10),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H16),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(IF(OR(D19=\"\",F19=\"\",H19=\"\"),\"\",(D19+F19+H19)),\"\")","v":""},{"$f":"IFERROR(J19/$J$19,\"\")","v":""},"X","•  The total number of infants and toddlers, ages birth through 2, by age in Section A1 does not equal the total number of infants and toddlers by race/ethnicity in Section B1. If data are not accurate, please correct the data.  If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC038]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D10=\"M\",0,\"\")","v":""},{"$f":"IF(F10=\"M\",0,\"\")","v":""},{"$f":"IF(H10=\"M\",0,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D13=\"M\",0,\"\")","v":""},{"$f":"IF(F13=\"M\",0,\"\")","v":""},{"$f":"IF(H13=\"M\",0,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16=\"M\",0,\"\")","v":""},{"$f":"IF(F16=\"M\",0,\"\")","v":""},{"$f":"IF(H16=\"M\",0,\"\")","v":""}]
[null,"Has your state elected under 20 U.S.C. 1432(5)(B)(ii) and 1435(c) to provide ",null,null,null,null,null,null,null,null,null,"X","•  The total number of infants and toddlers, ages birth through 2, by age in Section A1 does not equal the total number of infants and toddlers by gender Section C1. If data are not accurate, please correct the data.  If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC040]"]
[null,"parents the choice of, and the child’s parent has consented to their child,"]
[null,"continuing to receive Part C services (in lieu of FAPE) under 20 U.S.C."]
[null,"1435(c) for children ages 3 and older? (Directions: Click on the radio button",null,null,null,null,null,null,null,null,null,"X","•  The total for Section A1 - CC and Settings by Age is greater than or equal to Section E1 - Cumulative CC. [PartC-CC032]\n"]
[null," below to indicate yes or no. If yes is selected, then the data entry fields for",null,null,null,null,null,null,null,null,null,"X","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete."]
[null,"3- through 5-year-olds will appear below.)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas for check date,\"M\",\"NA\",special characters,\"-\"",null,null,null,null,"Formulas for Individual Settings Error",null,{"$f":"IF(AI31&AI32&AI33=\"\",\"[PartC-CC037a], [PartC-CC037b], [PartC-CC037c]\",\"\")","v":"[PartC-CC037a], [PartC-CC037b], [PartC-CC037c]"}]
[null,"A2. Age Group and Settings of Children, Ages 3 or Older",null,null,null,null,null,null,null,null,null,null,"ERROR MESSAGES FOR SECTION A2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D35)))>0,1,0)","v":0},{"$f":"IF(OR(D35=\"M\",D38=\"M\", D41=\"M\",F35=\"M\",F38=\"M\",F41=\"M\",H35=\"M\",H38=\"M\",H41=\"M\"),1,0)","v":0},{"$f":"IF(ISNUMBER(FIND(\".\",D35)),1,0)","v":0},{"$f":"IF(OR(D35=\"NA\",F35=\"NA\",H35=\"NA\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT(D35),D35<>\"M\",D35<>\"NA\"),1,0)","v":0},"Home",{"$f":"IFERROR(IF('Section A-CC & Settings by Age'!D44<>'Section B-CC & Settings by RE'!D41,\"Home\",\"\"),\"\")","v":""},{"$f":"IF(AH31=\"\",\"\",\"[PartC-CC037a]\")","v":""},null,{"$f":"IF(AH31=\"\",\"\",AH31&\" and \")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D38)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D38)),1,0)","v":0},{"$f":"IF(OR(D38=\"NA\", D41=\"NA\",F38=\"NA\",F41=\"NA\",H38=\"NA\",H41=\"NA\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT(D38),D38<>\"M\",D38<>\"NA\"),1,0)","v":0},"Community-based",{"$f":"IFERROR(IF(F44<>'Section B-CC & Settings by RE'!F41,\"Community-Based\",\"\"),\"\")","v":""},{"$f":"IF(AH32=\"\",\"\",\"[PartC-CC037b]\")","v":""},null,{"$f":"IF(AH32=\"\",\"\",AH32&\" and \")","v":""}]
[null,null,null,null,null,"Community-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D41)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D41)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D41),D41<>\"M\",D41<>\"NA\"),1,0)","v":0},"Other",{"$f":"IFERROR(IF(H44<>'Section B-CC & Settings by RE'!H41,\"Other\",\"\"),\"\")","v":""},{"$f":"IF(AH33=\"\",\"\",\"[PartC-CC037c]\")","v":""}]
[null,null,null,"Home",null,"Based Setting",null,"Other Setting",null,"Total","Percentage","X","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F35)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F35)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F35),F35<>\"M\",F35<>\"NA\"),1,0)","v":0},null,{"$f":"COUNTIF(AH31:AH33,\"\")","v":3},{"$f":"IF(AH34=3,\"____\",\"\")","v":"____"},{"$f":"IF(AH34=2,AH31&AH32&AH33,\"\")","v":""},{"$f":"IF(AND(AH34=1,AH33=\"\"),AK31&AH32,IF(AND(AH34=1,AH32=\"\"),AK31&AH33,IF(AND(AH34=1,AK32=\"\"),AK32&AH33,\"\")))","v":""},{"$f":"IF(AH34=0,\"Home, Community-Based, and Other\",\"\")","v":""}]
[null,"4."," 3 to 4",null,null,null,null,null,null,{"$f":"IF(OR(D35=\"\",F35=\"\",H35=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(LOWER(D35),\"m\",0)+SUBSTITUTE(LOWER(F35),\"m\",0)+SUBSTITUTE(LOWER(H35),\"m\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(_xlfn.IFS(AND(ISTEXT(D35), ISTEXT(F35),ISTEXT(H35)),\"\",OR(ISNUMBER(D35), ISNUMBER(F35),ISNUMBER(H35)),J35/$J$44),\"\")","v":""},"X","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F38)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F38)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F38),F38<>\"M\",F38<>\"NA\"),1,0)","v":0},null,null,{"$f":"AI34&AJ34&AK34&AL34","v":"____"}]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F41)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F41)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F41),F41<>\"M\",F41<>\"NA\"),1,0)","v":0},null,{"$f":"\"•  The total(s) of children, ages 3 through 5, by age in the setting(s) \"&AI35&\" does not equal the total(s) of children by race/ethnicity in the setting(s) \"&AI35&\". If data are not accurate, please correct the data. If data are accurate, please create a data note for submission in EMAPS explaining the difference.\"","v":"•  The total(s) of children, ages 3 through 5, by age in the setting(s) ____ does not equal the total(s) of children by race/ethnicity in the setting(s) ____. If data are not accurate, please correct the data. If data are accurate, please create a data note for submission in EMAPS explaining the difference."}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(OR(ISTEXT(D37), ISTEXT(F37),ISTEXT(H37)),\"NA\",OR(ISNUMBER(D37), ISNUMBER(F37),ISNUMBER(H37)),J37/$J$44),\"\")","v":""},"X",{"$f":"$AH$36&\" \"&_xlfn.TEXTJOIN(\", \",TRUE,AI30:AI33)","v":"•  The total(s) of children, ages 3 through 5, by age in the setting(s) ____ does not equal the total(s) of children by race/ethnicity in the setting(s) ____. If data are not accurate, please correct the data. If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC037a], [PartC-CC037b], [PartC-CC037c]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H35)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H35)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(H35),H35<>\"M\",H35<>\"NA\"),1,0)","v":0},null,"Formula for Section A1 Errors"]
[null,"5."," 4 to 5",null,null,null,null,null,null,{"$f":"IF(OR(D38=\"\",F38=\"\",H38=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D38),\"m\",0),\"na\",0))+(SUBSTITUTE(SUBSTITUTE(LOWER(F38),\"m\",0),\"na\",0))+(SUBSTITUTE(SUBSTITUTE(LOWER(H38),\"m\",0),\"na\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(_xlfn.IFS(AND(ISTEXT(D38), ISTEXT(F38),ISTEXT(H38)),\"\",OR(ISNUMBER(D38), ISNUMBER(F38),ISNUMBER(H38)),J38/$J$44),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H38)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H38)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(H38),H38<>\"M\",H38<>\"NA\"),1,0)","v":0},null,{"$f":"IF(OR(J44=\"\",J44=\"ERROR\"),\"\",J44)","v":""},{"$f":"IFERROR(IF('Section B-CC & Settings by RE'!J41=\"\",\"\",'Section B-CC & Settings by RE'!J41),\"\")","v":""},{"$f":"IFERROR(IF(AI38=\"\",\"\",ABS(($AH$38-AI38)/IF(OR($AH$38=\"\",AI38=\"\"),\"\",IF($AH$38>AI38,$AH$38,IF($AH$38<AI38,AI38,\"\"))))),\"\")","v":""},{"$f":"OR($AH$38=AI38,AJ38<=0.01)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H41)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H41)),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(H41),H41<>\"M\",H41<>\"NA\"),1,0)","v":0},null,null,{"$f":"IFERROR(IF('Section C-Child Count by Gender'!C24=\"\",\"\",'Section C-Child Count by Gender'!C24),\"\")","v":""},{"$f":"IFERROR(IF(AI39=\"\",\"\",ABS(($AH$13-AI39)/IF(OR($AH$13=\"\",AI39=\"\"),\"\",IF($AH$13>AI39,$AH$13,IF($AH$13<AI39,AI39,\"\"))))),\"\")","v":""},{"$f":"OR($AH$38=AI39,AJ39<=0.01)","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(OR(ISTEXT(D40), ISTEXT(F40),ISTEXT(H40)),\"NA\",OR(ISNUMBER(D40), ISNUMBER(F40),ISNUMBER(H40)),J40/$J$44),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB31:AB39)","v":0},null,{"$f":"SUM(AD31:AD39)","v":0},null,{"$f":"SUM(AF31:AF39)","v":0}]
[null,"6."," 5 or older",null,null,null,null,null,null,{"$f":"IF(OR(D41=\"\",F41=\"\",H41=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D41),\"m\",0),\"na\",0))+(SUBSTITUTE(SUBSTITUTE(LOWER(F41),\"m\",0),\"na\",0))+(SUBSTITUTE(SUBSTITUTE(LOWER(H41),\"m\",0),\"na\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(_xlfn.IFS(AND(ISTEXT(D41), ISTEXT(F41),ISTEXT(H41)),\"\",OR(ISNUMBER(D41), ISNUMBER(F41),ISNUMBER(H41)),J41/$J$44),\"\")","v":""},"X","•  The total number of children, ages 3 or older, by age in Section A2 does not equal the total number of children by race/ethnicity in Section B2. If data are not accurate as submitted, please resubmit.  If data are accurate, please submit a data note explaining the difference. [PartC-CC039]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF31,AF34,AF37)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(OR(ISTEXT(D43), ISTEXT(F43),ISTEXT(H43)),\"NA\",OR(ISNUMBER(D43), ISNUMBER(F43),ISNUMBER(H43)),J43/$J$44),\"\")","v":""}]
[null,"Total (3 or Older) ",null,{"$f":"IF(OR(D35=\"\",D38=\"\",D41=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D35),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D38),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D41),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},null,{"$f":"IF(OR(F35=\"\",F38=\"\",F41=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F35),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F38),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F41),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},null,{"$f":"IF(OR(H35=\"\",H38=\"\",H41=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H35),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H38),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H41),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(IF(OR(D44=\"\",F44=\"\",H44=\"\"),\"\",IF(OR(D44=\"NA\",F44=\"NA\",H44=\"NA\"),\"NA\",(D44+F44+H44))),\"ERROR\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AND(D44=\"\",F44=\"\",H44=\"\"),\"\",OR(ISTEXT(D44), ISTEXT(F44),ISTEXT(H44)),\"NA\",OR(ISNUMBER(D44), ISNUMBER(F44),ISNUMBER(H44)),(J35+J38+J41)/$J$44),\"\")","v":""},"X","•  The total number of children, ages 3 or older, by age in Section A2 does not equal the total number of children by gender in Section C2. If data are not accurate as submitted, please resubmit.  If data are accurate, please submit a data note explaining the difference. [PartC-CC041]"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete. NA is a valid value in Section A2."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"•  NA has been entered in row 4 for Ages 3-4. NA is not a valid value for Ages 3 to 4. [PartC-CC029]"]

{"sheet":"Section B-CC & Settings by RE","index":2,"n_rows":48,"n_cols":48,"rows_kept":48,"cut":false,"hidden":false,"merged":[[34,12,36,21],[9,12,9,21],[10,12,10,21],[11,12,11,21],[12,12,12,21],[14,12,16,21],[33,12,33,21],[32,12,32,21],[30,12,30,21],[31,12,31,21],[5,12,5,21],[6,12,8,21],[13,12,13,21],[27,12,27,21],[28,12,29,21]]}
[]
["   Section B: Child Count and Settings by Race/Ethnicity"]
[]
[null,"B1. Race/Ethnicity of Infants and Toddlers, Ages Birth through 2"]
[]
[null,null,null,"Home",null,"Community-Based Setting",null,"Other Setting",null,"Total","Percentage",null,"ERROR MESSAGES FOR SECTION B1"]
[null,"1."," Hispanic/Latino",null,null,null,null,null,null,{"$f":"IF(OR(D7=\"\",F7=\"\",H7=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D7),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F7),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H7),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J7/$J$21,\"\")","v":""},null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOME",null,"CB",null,"OTHER",null,"HOME",null,"CB",null,"OTHER",null,{"$f":"IF(OR(D7=\"M\",D9=\"M\", D11=\"M\",D13=\"M\",D15=\"M\",D17=\"M\",D19=\"M\",F7=\"M\", F9=\"M\",F11=\"M\",F13=\"M\",F15=\"M\",F17=\"M\",F19=\"M\",H7=\"M\",H9=\"M\",H11=\"M\",H13=\"M\",H15=\"M\",H17=\"M\",H19=\"M\"),1,0)","v":0},null,"HOME",null,"CB",null,"OTHER"]
[null,"2."," American Indian or Alaska Native",null,null,null,null,null,null,{"$f":"IF(OR(D9=\"\",F9=\"\",H9=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D9),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F9),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H9),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J9/$J$21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Hispanic/Latino",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D7)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F7)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H7)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D7)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F7)),1,0)","v":0},null,0,null,null,null,{"$f":"IF(AND(ISTEXT(D7),D7<>\"M\",D7<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F7),F7<>\"M\",F7<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," American Indian or Alaska Native",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D9)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F9)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H9)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D9)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F9)),1,0)","v":0},null,0,null,{"$f":"IF(OR(D7=\"NA\",D9=\"NA\", D11=\"NA\",D13=\"NA\",D15=\"NA\",D17=\"NA\",D19=\"NA\",F7=\"NA\", F9=\"NA\",F11=\"NA\",F13=\"NA\",F15=\"NA\",F17=\"NA\",F19=\"NA\",H7=\"NA\",H9=\"NA\",H11=\"NA\",H13=\"NA\",H15=\"NA\",H17=\"NA\",H19=\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D9),D9<>\"M\",D9<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F9),F9<>\"M\",F9<>\"NA\"),1,0)","v":0},null,0]
[null,"3."," Asian",null,null,null,null,null,null,"","","X","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Asian",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D11)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F11)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H11)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D11)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F11)),1,0)","v":0},null,0,null,null,null,{"$f":"IF(AND(ISTEXT(D11),D11<>\"M\",D11<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F11),F11<>\"M\",F11<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Black or African American",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D13)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F13)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H13)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D13)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F13)),1,0)","v":0},null,0,null,{"$f":"IF(OR(J21=\"\",'Section C-Child Count by Gender'!C11=\"\"),\"\",J21='Section C-Child Count by Gender'!C11)","v":""},null,{"$f":"IF(AND(ISTEXT(D13),D13<>\"M\",D13<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F13),F13<>\"M\",F13<>\"NA\"),1,0)","v":0},null,0]
[null,"4."," Black or African American",null,null,null,null,null,null,"","","X","•  'NA' is not a valid value in Section B1. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Native Hawaiian or Other Pacific Islander",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D15)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F15)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H15)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D15)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F15)),1,0)","v":0},null,0,null,null,null,{"$f":"IF(AND(ISTEXT(D15),D15<>\"M\",D15<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F15),F15<>\"M\",F15<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  The total by Race/Ethnicity in Section B1 does not match the total by Gender in Section C1. [PartC-CC042]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D17)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F17)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H17)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D17)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F17)),1,0)","v":0},null,0,null,null,null,{"$f":"IF(AND(ISTEXT(D17),D17<>\"M\",D17<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F17),F17<>\"M\",F17<>\"NA\"),1,0)","v":0},null,0]
[null,"5."," Native Hawaiian or Other Pacific Islander",null,null,null,null,null,null,"","","X","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two or more races",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D19)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F19)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H19)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D19)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F19)),1,0)","v":0},null,0,null,null,null,{"$f":"IF(AND(ISTEXT(D19),D19<>\"M\",D19<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F19),F19<>\"M\",F19<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC9:AC15+AE9:AE15+AG9:AG15)","v":0},null,null,null,null,null,{"$f":"SUM(AI9:AI15+AK9:AK15+AM9:AM15)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AQ9:AQ15+AS9:AS15+AU9:AU15)","v":0}]
[null,"6.","White",null,null,null,null,null,null,"",""]
[]
[null,"7.","Two or more races",null,null,null,null,null,null,"",{"$f":"IFERROR(J19/$J$21,\"\")","v":""}]
[]
[null,"Total (Birth through 2) ",null,{"$f":"IF(OR(D7=\"\",D9=\"\",D11=\"\",D13=\"\",D15=\"\",D17=\"\",D19=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D7),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D9),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D11),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D13),\"m\",0),\"M\",0),SUBSTITUTE(SUBSTITUTE(LOWER(D15),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D17),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D19),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IF(OR(F7=\"\",F9=\"\",F11=\"\",F13=\"\",F15=\"\",F17=\"\",F19=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(F7),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F9),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F11),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F13),\"m\",0),\"M\",0),SUBSTITUTE(SUBSTITUTE(LOWER(F15),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F17),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(F19),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IF(OR(H7=\"\",H9=\"\",H11=\"\",H13=\"\",H15=\"\",H17=\"\",H19=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(H7),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H9),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H11),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H13),\"m\",0),\"M\",0),SUBSTITUTE(SUBSTITUTE(LOWER(H15),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H17),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(H19),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(IF(OR(D21=\"\",F21=\"\",H21=\"\"),\"\",(D21+F21+H21)),\"\")","v":""},""]
[]
[]
[null,"B2. Race/Ethnicity of Children, Ages 3 or Older"]
[]
[null,null,null,"Home",null,"Community-Based Setting",null,"Other Setting",null,"Total","Percentage"]
[null,"8."," Hispanic/Latino",null,null,null,null,null,null,{"$f":"IF(OR(D27=\"\",F27=\"\",H27=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D27),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F27),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H27),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J27/$J$41,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ERROR MESSAGES FOR SECTION B2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOME",null,"CB",null,"OTHER",null,"HOME",null,"CB",null,"OTHER",null,{"$f":"IF(OR(D27=\"M\",D29=\"M\", D31=\"M\",D33=\"M\",D35=\"M\",D37=\"M\",D39=\"M\",F27=\"M\", F29=\"M\",F31=\"M\",F33=\"M\",F35=\"M\",F37=\"M\",F39=\"M\",H27=\"M\",H29=\"M\",H31=\"M\",H33=\"M\",H35=\"M\",H37=\"M\",H39=\"M\"),1,0)","v":0},null,"HOME",null,"CB",null,"OTHER"]
[null,"9."," American Indian or Alaska Native",null,null,null,null,null,null,{"$f":"IF(OR(D29=\"\",F29=\"\",H29=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D29),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F29),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H29),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},{"$f":"IFERROR(J29/$J$41,\"\")","v":""},null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Hispanic/Latino",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D27)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F27)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H27)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D27)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F27)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H27)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D27),D27<>\"M\",D27<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F27),F27<>\"M\",F27<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," American Indian or Alaska Native",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D29)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F29)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H29)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D29)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F29)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H29)),1,0)","v":0},null,{"$f":"IF(OR(D27=\"NA\",D29=\"NA\", D31=\"NA\",D33=\"NA\",D35=\"NA\",D37=\"NA\",D39=\"NA\",F27=\"NA\", F29=\"NA\",F31=\"NA\",F33=\"NA\",F35=\"NA\",F37=\"NA\",F39=\"NA\",H27=\"NA\",H29=\"NA\",H31=\"NA\",H33=\"NA\",H35=\"NA\",H37=\"NA\",H39=\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D29),D29<>\"M\",D29<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F29),F29<>\"M\",F29<>\"NA\"),1,0)","v":0},null,0]
[null,"10."," Asian",null,null,null,null,null,null,{"$f":"IF(OR(D31=\"\",F31=\"\",H31=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D31),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F31),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H31),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},"","X","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Asian",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D31)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F31)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H31)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D31)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F31)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H31)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D31),D31<>\"M\",D31<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F31),F31<>\"M\",F31<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Black or African American",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D33)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F33)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H33)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D33)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F33)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H33)),1,0)","v":0},null,{"$f":"IF(OR(J41=\"\",'Section C-Child Count by Gender'!C24=\"\"),\"\",J41='Section C-Child Count by Gender'!C24)","v":""},null,{"$f":"IF(AND(ISTEXT(D33),D33<>\"M\",D33<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F33),F33<>\"M\",F33<>\"NA\"),1,0)","v":0},null,0]
[null,"11."," Black or African American",null,null,null,null,null,null,{"$f":"IF(OR(D33=\"\",F33=\"\",H33=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D33),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F33),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H33),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},"","X","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Native Hawaiian or Other Pacific Islander",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D35)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F35)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H35)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D35)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F35)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H35)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D35),D35<>\"M\",D35<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F35),F35<>\"M\",F35<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,"X","•  The total by Race/Ethnicity in Section B2 does not match the total by Gender in Section C2. [PartC-CC043]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D37)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F37)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H37)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D37)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F37)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H37)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D37),D37<>\"M\",D37<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F37),F37<>\"M\",F37<>\"NA\"),1,0)","v":0},null,0]
[null,"12."," Native Hawaiian or Other Pacific Islander",null,null,null,null,null,null,{"$f":"IF(OR(D35=\"\",F35=\"\",H35=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D35),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F35),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H35),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},"","X","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two or more races",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D39)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},F39)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H39)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D39)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",F39)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",H39)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D39),D39<>\"M\",D39<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(F39),F39<>\"M\",F39<>\"NA\"),1,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC29:AC35+AE29:AE35+AG29:AG35)","v":0},null,null,null,null,null,{"$f":"SUM(AI29:AI35+AK29:AK35+AM29:AM35)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AQ29:AQ35+AS29:AS35+AU29:AU35)","v":0}]
[null,"13.","White",null,null,null,null,null,null,{"$f":"IF(OR(D37=\"\",F37=\"\",H37=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D37),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F37),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H37),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},""]
[]
[null,"14.","Two or more races",null,null,null,null,null,null,{"$f":"IF(OR(D39=\"\",F39=\"\",H39=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D39),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F39),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(H39),\"m\",0),\"na\",0),\"na\",0),\"NA\",0)),\"ERROR\"))","v":""},""]
[]
[null,"Total (3 or Older) ",null,{"$f":"IF(OR(D27=\"\",D29=\"\",D31=\"\",D33=\"\",D35=\"\",D37=\"\",D39=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D27),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D29),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D31),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D33),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D35),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D37),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D39),\"m\",0),\"M\",0),\"na\",0),\"NA\",0))))),\"ERROR\"))","v":""},null,{"$f":"IF(OR(F27=\"\",F29=\"\",F31=\"\",F33=\"\",F35=\"\",F37=\"\",F39=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F27),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F29),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F31),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F33),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F35),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F37),\"m\",0),\"M\",0),\"na\",0),\"NA\",0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(F39),\"m\",0),\"M\",0),\"na\",0),\"NA\",0))))),\"ERROR\"))","v":""},null,"",null,{"$f":"IFERROR(IF(OR(D41=\"\",F41=\"\",H41=\"\"),\"\",(D41+F41+H41)),\"\")","v":""},""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ISTEXT(F13)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(D9)=D9","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(D10)=D10","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(D11)=D11","v":true}]

{"sheet":"Section C-Child Count by Gender","index":3,"n_rows":29,"n_cols":30,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,9,30,18],[22,9,24,18],[25,9,27,18],[11,9,11,18],[12,9,13,18],[14,9,15,18],[19,9,19,18],[17,9,18,18],[16,9,16,18],[20,9,20,18],[21,9,21,18],[3,9,3,18],[4,9,6,18],[10,9,10,18],[7,9,7,18],[8,9,8,18],[9,9,9,18]]}
[]
["   Section C: Child Count by Gender"]
[]
[null,"C1. Gender of Infants and Toddlers, Ages Birth through 2, Receiving Early Intervention Services",null,null,null,null,null,null,null,"ERROR MESSAGES FOR SECTION C1"]
[null,null,null,null,null,null,null,null,null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary."]
[null,"Gender","Total ",null,"Percentage"]
[null,"Male",null,null,{"$f":"IFERROR(IF(AND(C7<>\"\",C9<>\"\"),(C7/C11),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"X    ","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Male",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},C7)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",C7)),1,0)","v":0},null,{"$f":"IF(OR(C7=\"M\",C9=\"M\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT(C7),C7<>\"M\",C7<>\"NA\"),1,0)","v":0}]
[null,"Female",null,null,{"$f":"IFERROR(IF(AND(C7<>\"\",C9<>\"\"),(C9/C11),\"\"),\"\")","v":""},null,null,null,"X    ","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Female",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},C9)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",C9)),1,0)","v":0},null,{"$f":"IF(OR(C7=\"NA\",C9=\"NA\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT(C9),C9<>\"M\",C9<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"X    ","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y8:Y9)","v":0},null,{"$f":"SUM(AA8:AA9)","v":0},null,{"$f":"IF(OR(C11=\"\",'Section A-CC & Settings by Age'!J19=\"\"),\"\",C11='Section A-CC & Settings by Age'!J19)","v":""},{"$f":"SUM(AD8:AD9)","v":0}]
[null,"Total (Birth through 2)",{"$f":"IF(OR(C7=\"\",C9=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(C7),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(C9),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(IF(AND(C7<>\"\",C9<>\"\"),(C11/(C7+C9)),\"\"),\"\")","v":""},null,null,null,"X    ","•  'NA' is not a valid value in Section C1. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C11=\"\",'Section B-CC & Settings by RE'!J41=\"\"),\"\",C11='Section B-CC & Settings by RE'!J41)","v":""}]
[null,null,null,null,null,null,null,null,"X    ","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete.",null,null,null,null,null,null,null,null,null,"\n\n"]
[null,null,null,null,null,null,null,null,null,"•  The total number of infants and toddlers, ages birth through 2, by age in Section A1 does not equal the total number of infants and toddlers by gender in Section C1. If data are not accurate, please correct the data.  If data are accurate, please create a data note for submission in EMAPS explaining the difference.  [PartC-CC040]",null,null,null,null,null,null,null,null,null,"\n\n"]
[]
[null,null,null,null,null,null,null,null,null,"•  The total number of infants and toddlers, ages birth through 2, by race/ethnicity in Section B1 does not equal the total number of infants and toddlers by gender in Section C1. If data are not accurate, please correct the data.  If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC042]",null,null,null,null,null,null,null,null,null,"\n"]
[]
[null,"C2. Gender of Children, Ages 3 or Older, Receiving Early Intervention Services",null,null,null,null,null,null,null,"ERROR MESSAGES FOR SECTION C2"]
[null,null,null,null,null,null,null,null,null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary."]
[null,"Gender","Total ",null,"Percentage"]
[null,"Male",null,null,{"$f":"IFERROR(IF(AND(C20<>\"\",C22<>\"\"),(C20/C24),\"\"),\"\")","v":""},null,null,null,"X    ","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]"]
[null,null,null,null,null,null,null,null,"X    ","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Male",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},C20)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",C20)),1,0)","v":0},null,{"$f":"IF(OR(C20=\"M\",C22=\"M\"),1,0)","v":0},{"$f":"IF(AND(ISTEXT(C20),C20<>\"M\",C20<>\"NA\"),1,0)","v":0}]
[null,"Female",null,null,{"$f":"IFERROR(IF(AND(C20<>\"\",C22<>\"\"),(C22/C24),\"\"),\"\")","v":""},null,null,null,"X    ","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Female",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},C22)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",C22)),1,0)","v":0},null,null,{"$f":"IF(AND(ISTEXT(C22),C22<>\"M\",C22<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"X    ","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete. NA is a valid value in Section C2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y21:Y22)","v":0},null,{"$f":"SUM(AA21:AA22)","v":0},null,{"$f":"IF(OR(C24=\"\",'Section A-CC & Settings by Age'!J44=\"\"),\"\",C24='Section A-CC & Settings by Age'!J44)","v":""},{"$f":"SUM(AD21:AD22)","v":0}]
[null,"Total (3 or Older)",{"$f":"IF(OR(C20=\"\",C22=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(C20),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(C22),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(IF(AND(C20<>\"\",C22<>\"\"),(C24/(C20+C22)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C24=\"\",'Section B-CC & Settings by RE'!J41=\"\"),\"\",C24='Section B-CC & Settings by RE'!J41)","v":""}]
[]
[null,null,null,null,null,null,null,null,"X    ","•  The total number of children, ages 3 or older, by age in Section A2 does not equal the total number of children by gender in Section C2. If data are not accurate, please correct the data.  If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC041]"]
[]
[]
[null,null,null,null,null,null,null,null,"X    ","•  The total number of children, ages 3 or older, by race/ethnicity in Section B2 does not equal the total number of children by gender in Section C2. If data are not accurate, please correct the data.  If data are accurate, please create a data note for submission in EMAPS explaining the difference. [PartC-CC043]"]

{"sheet":"Section D-At Risk Child Count","index":4,"n_rows":29,"n_cols":38,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,15,18,26],[19,15,20,26],[21,15,23,26],[3,1,3,10],[10,15,10,26],[11,15,12,26],[13,15,13,26],[14,15,14,26],[15,15,15,26]]}
[]
["   Section D: At Risk Child Count"]
[]
[null,"Has your state elected under 20 U.S.C. 1432(5)(B)(i) to serve children under the age of three and at risk of having substantial delays if early intervention services are not provided?"]
[]
[]
[]
[]
[]
[null,"At Risk Infants and Toddlers, Ages Birth through 2 (these infants and toddlers should be included in the counts for Sections A1 and B1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR MESSAGES FOR SECTION D"]
[null,null,null,"Count",null,"Percentage",null,"Birth to 1",null,"1 to 2",null,"2 to 3",null,"Total",null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary."]
[null,"1."," Hispanic/Latino",null,null,{"$f":"IFERROR(D13/$D$27,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Hispanic/Latino",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D13)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D13)),1,0)","v":0},null,{"$f":"IF(OR(D13=\"M\",D15=\"M\",D17=\"M\",D19=\"M\",D21=\"M\",D23=\"M\",D25=\"M\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D13),D13<>\"M\",D13<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X    ","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," American Indian or Alaska Native",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D15)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D15)),1,0)","v":0},null,{"$f":"IF(OR(D13=\"NA\",D15=\"NA\",D17=\"NA\",D19=\"NA\",D21=\"NA\",D23=\"NA\",D25=\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D15),D15<>\"M\",D15<>\"NA\"),1,0)","v":0}]
[null,"2."," American Indian or Alaska Native",null,null,{"$f":"IFERROR(D15/$D$27,\"\")","v":""},null,null,null,null,null,null,null,null,"X    ","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Asian",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D17)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D17)),1,0)","v":0},null,{"$f":"IF(OR(D27=\"\",N27=\"\"),\"\",D27=N27)","v":""},null,{"$f":"IF(AND(ISTEXT(D17),D17<>\"M\",D17<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X    ","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Black or African American",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D19)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D19)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D19),D19<>\"M\",D19<>\"NA\"),1,0)","v":0}]
[null,"3."," Asian",null,null,"",null,null,null,null,null,null,null,null,"X    ","•  For at risk infants and toddlers, ages birth through 2, the sum of counts reported for the three age categories does not equal the sum of the counts reported for the seven race/ethnicity categories. If data are not accurate as submitted, please resubmit.  If data are accurate, please submit a data note explaining the difference.  [PartC-CC044]",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Native Hawaiian or Other Pacific Islander",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D21)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D21)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D21),D21<>\"M\",D21<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D23)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D23)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D23),D23<>\"M\",D23<>\"NA\"),1,0)","v":0}]
[null,"4."," Black or African American",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two or more races",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},D25)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",D25)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D25),D25<>\"M\",D25<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X    ","•  A response of “NA” was incorrectly reported as a value for At Risk Infants/Toddlers. Please resubmit with the correct response, “M.” [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF13:AF19)","v":0},null,{"$f":"SUM(AH13:AH19)","v":0},null,null,null,{"$f":"SUM(AL13:AL19)","v":0}]
[null,"5."," Native Hawaiian or Other Pacific Islander",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X    ","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birth to 1",null,"1 to 2",null,"2 to 3",null,null,{"$f":"IF(OR(H27=\"M\",J27=\"M\",L27=\"M\"),1,0)","v":0}]
[null,"6.","White",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"symbol",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},H27)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},J27)))>0,1,0)","v":0},null,{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},L27)))>0,1,0)","v":0},null,{"$f":"SUM(AE23+AG23+AI23)","v":0},{"$f":"IF(OR(H27=\"NA\",J27=\"NA\",L27=\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"decimal",{"$f":"IF(ISNUMBER(FIND(\".\",H27)),1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",J27)),1,0)","v":0},null,0,null,{"$f":"SUM(AE24+AG24+AI24)","v":0}]
[null,"7.","Two or more races",null,null,{"$f":"IFERROR(D25/$D$27,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"letters",{"$f":"IF(AND(ISTEXT(H27),H27<>\"M\",H27<>\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(J27),J27<>\"M\",J27<>\"NA\"),1,0)","v":0},null,0,null,0]
[]
[null,"Total (Birth through 2) ",null,{"$f":"IF(OR(D13=\"\",D15=\"\",D17=\"\",D19=\"\",D21=\"\",D23=\"\",D25=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(D13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D15),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D17),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D19),\"m\",0),\"M\",0),SUBSTITUTE(SUBSTITUTE(LOWER(D21),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D23),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(D25),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(D27/(D13+D15+D17+D19+D21+D23+D25),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H27=\"\",J27=\"\",L27=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(H27),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(J27),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(L27),\"m\",0),\"M\",0)),\"ERROR\"))","v":""}]
[]
[null,null,null,null,null,"Percentage",null,{"$f":"IFERROR(H27/$N$27,\"\")","v":""},null,{"$f":"IFERROR(J27/$N$27,\"\")","v":""},null,{"$f":"IFERROR(L27/$N$27,\"\")","v":""},null,{"$f":"IFERROR(N27/D27,\"\")","v":""}]

{"sheet":"Section E-Cumulative CC","index":5,"n_rows":37,"n_cols":36,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,8,7,19],[6,8,6,19],[12,8,12,19],[14,8,14,19],[15,8,15,19],[19,8,21,19],[22,8,23,19],[16,8,16,19],[9,8,9,19],[10,8,11,19],[13,8,13,19],[17,8,18,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Date",null,"Current Year",null,"Prior Y1","Prior Y2","Prior Y3"]
["   Section E: Cumulative Child Count by Race/Ethnicity and Gender",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-05-30"},null,{"$f":"YEAR(TODAY())","v":2023},null,{"$f":"YEAR(TODAY())-1","v":2022},{"$f":"YEAR(TODAY())-2","v":2021},{"$f":"YEAR(TODAY())-3","v":2020},null,{"$f":"IF(AND(YEAR(C8)>=AH2,YEAR(C8)<=AD2,YEAR(E8)>=AH2,YEAR(E8)<=AD2), \"Within range\", \"Outside range\")","v":"Outside range"}]
[]
["   Cumulative Number of Infants and Toddlers Who Received Early Intervention Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"364 or 365 days?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8=\"\",\"\",EDATE(C8,12)-1)","v":""},null,{"$f":"E8-C8","v":0}]
["   Enter the start (From) and end (To) dates for your state's 12-month cumulative count period in the mm/dd/yyyy format.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E8-Z5","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,"Cumulative \"To\" date cannot exceed the date of last Wednesday in June of the reporting year."]
[null,"  From:",null,"  To:",null,null,null,null,"The \"from\" date must be less than the \"to\" date."]
[]
[null,"E1. "," Cumulative Count of Infants and Toddlers, Ages Birth through 2, by Race/Ethnicity",null,null,null,null,null,"ERROR MESSAGES FOR SECTION E1 AND E2"]
[null,null,null,null,null,null,null,null,"DIRECTIONS: If any error message below is highlighted, please read the message and correct the error in the data entry cells, if necessary."]
[null,null,null,null,"Total",null,"Percentage"]
[null,"1."," Hispanic/Latino",null,null,null,{"$f":"IFERROR(E13/$E$27,\"\")","v":""},"X    ","•   The timeframe reported for cumulative child count does not equal one year. [PartC-CC012], [PartC-CC048]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Hispanic/Latino",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E13)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E13)),1,0)","v":0},null,{"$f":"IF(OR(E13=\"M\",E15=\"M\",E17=\"M\",E19=\"M\",E21=\"M\",E23=\"M\",E25=\"M\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D13),D13<>\"M\",D13<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,"X    ","•  A negative integer is entered into a field. Please enter positive, whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," American Indian or Alaska Native",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E15)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E15)),1,0)","v":0},null,{"$f":"IF(OR(E13=\"NA\",E15=\"NA\",E17=\"NA\",E19=\"NA\",E21=\"NA\",E23=\"NA\",E25=\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D15),D15<>\"M\",D15<>\"NA\"),1,0)","v":0}]
[null,"2."," American Indian or Alaska Native",null,null,null,{"$f":"IFERROR(E15/$E$27,\"\")","v":""},"X    ","•  A number containing a decimal is entered into a field. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Asian",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E17)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E17)),1,0)","v":0},null,{"$f":"IF(OR(E27=\"\",E37=\"\"),\"\",E27=E37)","v":""},null,{"$f":"IF(AND(ISTEXT(D17),D17<>\"M\",D17<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,"X    ","•  A special character or a letter is entered in a field. Please enter only whole numbers or \"M\" for Missing. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Black or African American",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E19)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E19)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D19),D19<>\"M\",D19<>\"NA\"),1,0)","v":0}]
[null,"3."," Asian",null,null,null,"","X    ","•  'NA' is not a valid value in Sections E1 and E2. Please enter whole numbers only. [PartC-CC029]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Native Hawaiian or Other Pacific Islander",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E21)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E21)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D21),D21<>\"M\",D21<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,"X    ","•  The total for Section E - Cumulative CC is less than or equal to the total for Section A - CC and Settings by Age for ages birth through 2. [PartC-CC032]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E23)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E23)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D23),D23<>\"M\",D23<>\"NA\"),1,0)","v":0}]
[null,"4."," Black or African American",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two or more races",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E25)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E25)),1,0)","v":0},null,null,null,{"$f":"IF(AND(ISTEXT(D25),D25<>\"M\",D25<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,"X    ","•  For  the cumulative count of infants and toddlers, ages birth through 2, the sum of counts reported for the two gender categories does not equal the sum of the counts reported for the seven race/ethnicity categories.   If data are not accurate as submitted, please resubmit.  If data are accurate, please submit a data note explaining the difference. [PartC-CC045]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z13:Z19)","v":0},null,{"$f":"SUM(AB13:AB19)","v":0},null,null,null,{"$f":"SUM(AF13:AF19)","v":0}]
[null,"5."," Native Hawaiian or Other Pacific Islander",null,null,null,""]
[]
[null,"6.","White",null,null,null,"","X    ","•  If M (for Missing) is entered in any of the data entry cells, then an explanation regarding why data are Missing must be entered in the comment box in EMAPS. Data submissions with missing data elements are rated by OSEP as incomplete.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Male",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E33)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E33)),1,0)","v":0},null,{"$f":"IF(OR(E33=\"M\",E35=\"M\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D33),D33<>\"M\",D33<>\"NA\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Female",{"$f":"IF(SUMPRODUCT(--ISNUMBER(FIND({\"-\",\"/\",\"(\",\")\",\"<\",\">\",\"?\",\"!\",\"@\",\"#\",\"$\",\"%\",\"&\",\"*\"},E35)))>0,1,0)","v":0},null,{"$f":"IF(ISNUMBER(FIND(\".\",E35)),1,0)","v":0},null,{"$f":"IF(OR(E33=\"NA\",E35=\"NA\"),1,0)","v":0},null,{"$f":"IF(AND(ISTEXT(D35),D35<>\"M\",D35<>\"NA\"),1,0)","v":0}]
[null,"7.","Two or more races",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z23:Z24)","v":0},null,{"$f":"SUM(AB23:AB24)","v":0},null,null,null,{"$f":"SUM(AF23:AF24)","v":0}]
[]
[null,"Total (Birth through 2) ",null,null,{"$f":"IF(OR(E13=\"\",E15=\"\",E17=\"\",E19=\"\",E21=\"\",E23=\"\",E25=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(E13),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(E15),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(E17),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(E19),\"m\",0),\"M\",0),SUBSTITUTE(SUBSTITUTE(LOWER(E21),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(E23),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(E25),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(E27/(E13+E15+E17+E19+E21+E23+E25),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Section A-CC & Settings by Age'!J19","v":""}]
[null,"E2."," Cumulative Count of Infants and Toddlers, Ages Birth through 2, by Gender"]
[]
[null,null,null,null,"Total",null,"Percentage"]
[null,"1.","Male",null,null,null,{"$f":"IFERROR(E33/$E$37,\"\")","v":""}]
[]
[null,"2.","Female",null,null,null,{"$f":"IFERROR(E35/$E$37,\"\")","v":""}]
[]
[null,"Total (Birth through 2) ",null,null,{"$f":"IF(OR(E33=\"\",E35=\"\"),\"\",IFERROR(SUM(SUBSTITUTE(SUBSTITUTE(LOWER(E33),\"m\",0),\"M\",0)+SUBSTITUTE(SUBSTITUTE(LOWER(E35),\"m\",0),\"M\",0)),\"ERROR\"))","v":""},null,{"$f":"IFERROR(E37/(E33+E35),\"\")","v":""}]

{"sheet":"Year-to-Year Change","index":6,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"Year-to-Year Change "]
[null,"Directions: To compare the data currently entered in this data tool to the prior year data for your state, either manually type in the prior year child count data or copy/paste the prior year data from the comparison report available in EMAPS--the report named \"[state name] IDEA Part C Child Count andd Settings 20[xx]-[xx]\"."]
[null,null,"Child Count","Child Count"]
[null,"Section","Prior Year","Current Year","Difference","% Change"]
[null,"Section A - Birth through 2 Total by Home",null,{"$f":"'Section A-CC & Settings by Age'!D19","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",D6-C6)","v":""},{"$f":"IFERROR((D6-C6)/C6,\"\")","v":""}]
[null,"Section A - Birth through 2 Total by Community",null,{"$f":"'Section A-CC & Settings by Age'!F19","v":""},"",""]
[null,"Section A - Birth through 2 Total by Other Setting",null,{"$f":"'Section A-CC & Settings by Age'!H19","v":""},"",""]
[null,"Section A - 3 and Older Total by Home",null,{"$f":"'Section A-CC & Settings by Age'!D44","v":""},"",""]
[null,"Section A - 3 and Older Total by Community",null,{"$f":"'Section A-CC & Settings by Age'!F44","v":""},"",""]
[null,"Section A - 3 and Older Total by Other Setting",null,{"$f":"'Section A-CC & Settings by Age'!H44","v":""},"",""]
[null,"Section A - Total Birth to 1",null,{"$f":"'Section A-CC & Settings by Age'!J10","v":""},"",""]
[null,"Section A - Totals 1 to 2",null,{"$f":"'Section A-CC & Settings by Age'!J13","v":""},"",""]
[null,"Section A - Totals 2 to 3",null,{"$f":"'Section A-CC & Settings by Age'!J16","v":""},"",""]
[null,"Section B - Total Hispanic/Latino",null,{"$f":"'Section B-CC & Settings by RE'!J7","v":""},"",""]
[null,"Section B - Total American Indian or Alaska Native",null,{"$f":"'Section B-CC & Settings by RE'!J9","v":""},"",""]
[null,"Section B - Total Asian",null,{"$f":"'Section B-CC & Settings by RE'!J11","v":""},"",""]
[null,"Section B - Total Black or African American",null,{"$f":"'Section B-CC & Settings by RE'!J13","v":""},"",""]
[null,"Section B - Total Native Hawaiian or Other Pacific Islander",null,{"$f":"'Section B-CC & Settings by RE'!J15","v":""},"",""]
[null,"Section B - Total White",null,{"$f":"'Section B-CC & Settings by RE'!J17","v":""},"",""]
[null,"Section B - Total Two or More Races",null,{"$f":"'Section B-CC & Settings by RE'!J19","v":""},"",""]
[null,"Section D - Total Birth to 1",null,{"$f":"IF('Section D-At Risk Child Count'!H27=\"\",\"\",'Section D-At Risk Child Count'!H27)","v":""},"",""]
[null,"Section D - Totals 1 to 2",null,{"$f":"IF('Section D-At Risk Child Count'!J27=\"\",\"\",'Section D-At Risk Child Count'!J27)","v":""},"",""]
[null,"Section D - Totals 2 to 3",null,{"$f":"IF('Section D-At Risk Child Count'!L27=\"\",\"\",'Section D-At Risk Child Count'!L27)","v":""},"",""]
[null,"Section E - Total Hispanic/Latino",null,{"$f":"IF('Section E-Cumulative CC'!E13=\"\",\"\",'Section E-Cumulative CC'!E13)","v":""},"",""]
[null,"Section E - Total American Indian or Alaska Native",null,{"$f":"IF('Section E-Cumulative CC'!E15=\"\",\"\",'Section E-Cumulative CC'!E15)","v":""},"",""]
[null,"Section E - Total Asian",null,{"$f":"IF('Section E-Cumulative CC'!E17=\"\",\"\",'Section E-Cumulative CC'!E17)","v":""},"",""]
[null,"Section E - Total Black or African American",null,{"$f":"IF('Section E-Cumulative CC'!E19=\"\",\"\",'Section E-Cumulative CC'!E19)","v":""},"",""]
[null,"Section E - Total Native Hawaiian or Other Pacific Islander",null,{"$f":"IF('Section E-Cumulative CC'!E21=\"\",\"\",'Section E-Cumulative CC'!E21)","v":""},"",""]
[null,"Section E - Total White",null,{"$f":"IF('Section E-Cumulative CC'!E23=\"\",\"\",'Section E-Cumulative CC'!E23)","v":""},"",""]
[null,"Section E - Total Two or More Races",null,{"$f":"IF('Section E-Cumulative CC'!E25=\"\",\"\",'Section E-Cumulative CC'!E25)","v":""},"",""]

{"sheet":"Failed Edit Checks and Warnings","index":7,"n_rows":58,"n_cols":28,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
["    From pages 29 and 30 of the February 2022 version of the EMAPS User Guide for this data submission.",null,null,null,null,null,null,null,null,null,null,"Section A",null,null,null,null,"Section B",null,null,null,null,"Section C",null,null,"Section D",null,"Section E"]
["    https://www2.ed.gov/about/inits/ed/edfacts/emaps-idea-part-c-child-count-user-guide.pdf",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!D10),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!F10),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!H10),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D7),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F7),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H7),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section C-Child Count by Gender'!C7),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D13),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E13),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!D13),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!F13),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!H13),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D9),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F9),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H9),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section C-Child Count by Gender'!C9),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D15),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E15),1,0)","v":1}]
[null," To complete all the EMAPS edit checks for Part C Child Count and Settings ",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!D16),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!F16),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!H16),1,0)","v":1},"A1",null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D11),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F11),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H11),1,0)","v":1},null,null,{"$f":"SUM(V3:V4)","v":2},"C1",null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D17),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E17),1,0)","v":1}]
[null,"data entered in this edit check tool, please complete the following checks:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L3:L5)","v":3},{"$f":"SUM(M3:M5)","v":3},{"$f":"SUM(N3:N5)","v":3},{"$f":"SUM(L6:N6)","v":9},null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D13),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F13),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H13),1,0)","v":1},null,null,null,null,null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D19),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E19),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D15),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F15),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H15),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section C-Child Count by Gender'!C20),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D21),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E21),1,0)","v":1}]
[null,"1.  To check for blank cells in all of the required cells in Sections A ",null,null,null,null,null,null,null,null,null,"YES",{"$f":"IF('Section A-CC & Settings by Age'!AC16=TRUE,1,0)","v":1},null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D17),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F17),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H17),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section C-Child Count by Gender'!C22),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D23),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E23),1,0)","v":1}]
[null,"     through E, click on the \"Click to check for blank cells\" button.",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!D35),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!F35),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!H35),1,0)","v":1},null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D19),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F19),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H19),1,0)","v":1},"B1",null,{"$f":"SUM(V7:V8)","v":2},"C2",null,{"$f":"IF(ISBLANK('Section D-At Risk Child Count'!D25),1,0)","v":1},null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E25),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!D38),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!F38),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!H38),1,0)","v":1},null,null,{"$f":"SUM(Q3:Q9)","v":7},{"$f":"SUM(R3:R9)","v":7},{"$f":"SUM(S3:S9)","v":7},{"$f":"SUM(Q10:S10)","v":21},null,null,null,null,{"$f":"SUM(Y3:Y9)","v":7},"D",{"$f":"SUM(AA3:AA9)","v":7},"E1"]
[null,"2.  Data entry cells in Sections A1, B1, C1, D, E1, and E2 should not ",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!D41),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!F41),1,0)","v":1},{"$f":"IF(ISBLANK('Section A-CC & Settings by Age'!H41),1,0)","v":1},"A2"]
[null,"     contain \"NA.\" To check those cells for \"NA\", click on the \"Click",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L11)","v":3},{"$f":"SUM(M9:M11)","v":3},{"$f":"SUM(N9:N11)","v":3},{"$f":"SUM(L12:N12)","v":9},null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D27),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F27),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H27),1,0)","v":1},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E33),1,0)","v":1}]
[null,"     to check for 'NA'\" button.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D29),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F29),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H29),1,0)","v":1},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section E-Cumulative CC'!E35),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D31),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F31),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H31),1,0)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(AA12:AA13)","v":2},"E2"]
[null,"3.  Click button XXXX to check total counts of infants and toddlers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D33),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F33),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H33),1,0)","v":1}]
[null,"     across Sections A through E.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D35),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F35),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H35),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D37),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F37),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H37),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!D39),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!F39),1,0)","v":1},{"$f":"IF(ISBLANK('Section B-CC & Settings by RE'!H39),1,0)","v":1},"B2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q12:Q18)","v":7},{"$f":"SUM(R12:R18)","v":7},{"$f":"SUM(S12:S18)","v":7},{"$f":"SUM(Q19:S19)","v":21}]
[null,"Failed Edit Checks"]
[]
[null,null,"• A negative integer is entered into a field;",null,null,null,null,null,null,null,null,"EMAPS rule - 12 month reporting period <From or To> year is not current year or two prior years. (previous version said \"are not 2018, 2019, 2020, or 2021)"]
[null,null,"• A decimal number is entered into a field;",null,null,null,null,null,null,null,null,"Current Date",null,"Current Year",null,"Prior Y1","Prior Y2","Prior Y3"]
[null,null,"• A special character is entered into a field;",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-05-30"},null,{"$f":"YEAR(TODAY())","v":2023},null,{"$f":"YEAR(TODAY())-1","v":2022},{"$f":"YEAR(TODAY())-2","v":2021},{"$f":"YEAR(TODAY())-3","v":2020},null,{"$f":"IF(AND(YEAR('Section E-Cumulative CC'!C8)>=R24,YEAR('Section E-Cumulative CC'!C8)<=N24,YEAR('Section E-Cumulative CC'!E8)>=R24,YEAR('Section E-Cumulative CC'!E8)<=N24), \"Within range\", \"Outside range\")","v":"Outside range"}]
[null,null,"• A required data entry field has not been populated on any of the data entry forms;"]
[null,null,"• An unacceptable letter code is entered into a field; or"]
[null,null,"• NA is entered into a field, when not an accepted value."]
[]
[null,"Edit Check Warnings"]
[]
[null,null,"• The Child Count Date is not between October 1, 2021 and December 1, 2021"]
[null,null,"(inclusive);"]
[null,null,"• The total count of Infants and Toddlers by Age in Home setting does not equal"]
[null,null,"the total Infants and Toddlers by Race/Ethnicity in Home setting"]
[null,null,"• The total count of Infants and Toddlers by Age in Community setting does not"]
[null,null,"equal the total Infants and Toddlers by Race in Community setting;"]
[null,null,"• The total count of Infants and Toddlers by Age in Other setting does not equal"]
[null,null,"the total Infants and Toddlers by Race in Other setting;"]
[null,null,"• The total count of Children by Age in Home setting does not equal the total"]
[null,null,"Children by Race in Home setting;"]
[null,null,"• The total count of Children by Age in Community setting does not equal the total"]
[null,null,"Children by Race in Community setting;"]
[null,null,"• The total count of Children by Age in Other setting does not equal the total"]
[null,null,"Children by Race in Other setting;"]
[null,null,"• The totals by Age group does not match the total by Race/Ethnicity;"]
[null,null,"• The totals by Age group does not match the total by Gender;"]
[null,null,"• The total by Race/Ethnicity does not match the total by Gender;"]
[null,null,"• The total of At Risk by Age groups does not match the total of At Risk by"]
[null,null,"Race/Ethnicity;"]
[null,null,"• The timeframe for Cumulative Child Count does not equal one year;"]
[null,null,"• The Cumulative Count of Infants and Toddlers receiving early intervention"]
[null,null,"services by Race/Ethnicity does not equal the total Cumulative Count of Infants"]
[null,null,"and Toddlers receiving early intervention services by Gender;"]
[null,null,"• The Cumulative Count Infant/Toddler – R/E Total is less than or equal to Age"]
[null,null,"Group/Setting: Birth thru 2 – Total; or"]
[null,null,"• The date of the reference period for the Cumulative Count of Infant and"]
[null,null,"Toddlers, birth through 2 who received early intervention services exceeds the"]
[null,null,"last Wednesday of June for the reporting year."]