{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Drop Down Lists","Instructions","Roll Up","HV1","HV2","HV3","HV4","HV5","HV6"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":"Drop Down Lists","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Typical","Typical result"]
["Monitoring required (grey)","Referred to E.I."]
["Delays indicated (black)","Connected to E.I."]
[null,"Parent decl. E.I."]
[null,"Info./act. to support dev."]

{"sheet":"Instructions","index":1,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Standard 6-6.B: ASQ's"]
[]
["As stated in the Best Practice Standard, under 6-6.B, it is the expectation that:"]
["The site ensures that the ASQ (Ages and Stages Questionnaire) is used during home visits to monitor child development at specified intervals unless developmentally inappropriate, and is administered according to the developers' instructions to ensure valid results (i.e. administered during the specified window of time)."]
["Intent: All target children are screened for potential developmental delays according to the minimum frequency recommended by the Association for the Academy of Pediatrics.  Staff are not required to screen children that are enrolled in early intervention services (special needs) and are receiving in-depth developmental assessments. "]
[]
[]
["You will enter data in the yellow highlighted AND in the \"Result\" and \"Action\" fields only"]
["*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
["Rows 10-11:  Please write in the home visitor’s name and the supervisor’s name.   "]
["Row 12: Indicates the dates (fiscal year) data should be recorded on the form."]
["Note: Do not include children who are currently enrolled prenatally, as there are no prenatal ASQ screens."]
["Beginning in row 17:"]
["1. Enter CHILD ID number in column A"]
["2. In column B, Enter an adjusted date of birth IF baby was born premature and if using ASQ intervals based on the adjusted date. If an adjusted date of birth is not applicable for the target child, leave this column blank."]
["3. In column C, enter actual DOB. If you also used an adjusted DOB (column B), the formula will switch to start tracking ASQ's according to actual DOB after the 24 month screen."]
["Note: If the target child is not caught up after 2 years, and the HV continues to use adjusted ASQ screens with the target child, please be sure to note the exception somewhere in the file."]
["4. Please select, \"Yes\" or \"No\" from the dropdown menu in column D to indicate whether the Target Child recieves early intervention."]
["5. If you selected \"Yes\" in column D, please write the date the target child began receiving early intervention services in column E."]
["6. The next 5 columns, the total ASQ's are summed up for you from year to year. You will continue to enter data starting in column L. Please list the date each ASQ was completed with the target child within the same row of information."]
["The blue columns are automatically calculating the dates each ASQ is due; the purple columns automatically calculate whether the date completed was within the parameters that the ASQ-3 defines as valid. Then, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday  that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
["After entering each screening, please indicate (from the drop down choices), the screening result and actions."]
["This latest version of the spreadsheet has a new feature - now the spreadsheet will automatically highlight the due dates that have occurred in the past 6 months. The intent here is to show more recent practice. If your site has improved practice in the past 6 months, this will be made more clear through the highlighting feature."]
["Underneath the current date, you will see \"highlight data from\" - which will autocalculate as 6 months before the current date, HOWEVER, if you'd like to narrow or widen your focus as you track activity at your site, this date is purposefully left \"unlocked\" for you to be able to do that."]
[]
["The Roll-Up tab summarizes for each home visitor, the percentage of target children that received the minimum number of developmental screens each year."]
[]
["Only developmental screens for the target child will be documented for purposes of demonstrating adherence to the standard. The target child is the child which allowed initiation of HFA services to the family. If you administer ASQs for other children in the family and would like to create additional worksheet pages to track the completion of these (but that will not be included in the Roll-Up statisitics), you are welcome to do so."]
["If you would like to track subsequent children, you can copy one of the tabs below to a new tab. To copy a tab, right click the \"HV6\" tab, and select \"Move or Copy\". A small box will appear. Please select \"HV6\" and then check the box that says \"Create a copy\"."]
["Any questions? Contact Amy: arussell@preventchildabuse.org or 860-249-9899"]
[]
["VERSION DATE: 6/24/2016-Modified by NPC per HFO request"]

{"sheet":"Roll Up","index":2,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,11],[3,1,3,11]]}
[null,null,null,null,null,null,5]
[]
[null,"ASQ Roll Up"]
[null,"DO NOT WRITE ON THIS PAGE, THIS WILL CALCULATE THE DATA YOU ENTER ON THE OTHER TABS."]
[null,"Home Visitor","Target children measured  at 1 year","YR 1","Target children measured at 2 years","YR 2","Target children measured at 3 years","YR 3 ","Target children measured at 4 years","YR 4","Target children measured at 5 years","YR 5"]
[null,{"$f":"IF(ISBLANK('HV1'!B$10),\"\",'HV1'!B$10)","v":""},{"$f":"COUNTIF('HV1'!$F$17:$F$47,\">=0\")","v":0},{"$f":"'HV1'!$F$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV1'!$G$17:$G$47,\">=0\")","v":0},{"$f":"'HV1'!$G$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV1'!$H$17:$H$47,\">=0\")","v":0},{"$f":"'HV1'!$H$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV1'!$I$17:$I$47,\">=0\")","v":0},{"$f":"'HV1'!$I$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV1'!$J$17:$J$47,\">=0\")","v":0},{"$f":"'HV1'!$J$15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISBLANK('HV2'!B$10),\"\",'HV2'!B$10)","v":""},{"$f":"COUNTIF('HV2'!$F$17:$F$47,\">=0\")","v":0},{"$f":"'HV2'!$F$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV2'!$G$17:$G$47,\">=0\")","v":0},{"$f":"'HV2'!$G$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV2'!$H$17:$H$47,\">=0\")","v":0},{"$f":"'HV2'!$H$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV2'!$I$17:$I$47,\">=0\")","v":0},{"$f":"'HV2'!$I$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV2'!$J$17:$J$47,\">=0\")","v":0},{"$f":"'HV2'!$J$15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISBLANK('HV3'!B$10),\"\",'HV3'!B$10)","v":""},{"$f":"COUNTIF('HV3'!$F$17:$F$47,\">=0\")","v":0},{"$f":"'HV3'!$F$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV3'!$G$17:$G$47,\">=0\")","v":0},{"$f":"'HV3'!$G$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV3'!$H$17:$H$47,\">=0\")","v":0},{"$f":"'HV3'!$H$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV3'!$I$17:$I$47,\">=0\")","v":0},{"$f":"'HV3'!$I$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV3'!$J$17:$J$47,\">=0\")","v":0},{"$f":"'HV3'!$J$15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISBLANK('HV4'!B$10),\"\",'HV4'!B$10)","v":""},{"$f":"COUNTIF('HV4'!$F$17:$F$47,\">=0\")","v":0},{"$f":"'HV4'!$F$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV4'!$G$17:$G$47,\">=0\")","v":0},{"$f":"'HV4'!$G$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV4'!$H$17:$H$47,\">=0\")","v":0},{"$f":"'HV4'!$H$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV4'!$I$17:$I$47,\">=0\")","v":0},{"$f":"'HV4'!$I$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV4'!$J$17:$J$47,\">=0\")","v":0},{"$f":"'HV4'!$J$15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISBLANK('HV5'!B$10),\"\",'HV5'!B$10)","v":""},{"$f":"COUNTIF('HV5'!$F$17:$F$47,\">=0\")","v":0},{"$f":"'HV5'!$F$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV5'!$G$17:$G$47,\">=0\")","v":0},{"$f":"'HV5'!$G$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV5'!$H$17:$H$47,\">=0\")","v":0},{"$f":"'HV5'!$H$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV5'!$I$17:$I$47,\">=0\")","v":0},{"$f":"'HV5'!$I$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV5'!$J$17:$J$47,\">=0\")","v":0},{"$f":"'HV5'!$J$15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISBLANK('HV6'!B$10),\"\",'HV6'!B$10)","v":""},{"$f":"COUNTIF('HV6'!$F$17:$F$47,\">=0\")","v":0},{"$f":"'HV6'!$F$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV6'!$G$17:$G$47,\">=0\")","v":0},{"$f":"'HV6'!$G$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV6'!$H$17:$H$47,\">=0\")","v":0},{"$f":"'HV6'!$H$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV6'!$I$17:$I$47,\">=0\")","v":0},{"$f":"'HV6'!$I$15","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('HV6'!$J$17:$J$47,\">=0\")","v":0},{"$f":"'HV6'!$J$15","v":{"$error":"#DIV/0!"}}]

{"sheet":"HV1","index":3,"n_rows":47,"n_cols":115,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,1,5,56],[6,1,6,56],[7,1,7,56],[9,27,9,31],[8,1,8,56]]}
[null,"6-6.B ASQ Developmental Screening Tracking"]
[]
[null,"Instructions:  ","HFA requires a minimum of two valid screens per year until the age 3, and one per year thereafter. "]
[null,"Enter in yellow highlighted fields only"]
[null,"*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
[null,"The blue columns are automatically calculating the dates each ASQ is due; the \"Valid?\" columns automatically calculate whether the date completed was within a month (before or after)"]
[null," of the due date, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday,"]
[null," that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
[null,"For each new fiscal year, beging entering new ASQ screens starting July 1. However ALSO INCLUDE (enter) the last completed ASQ from the prior fiscal year."]
["Home Visitor"]
["Supervisor:"]
["Service Year: July 1, 2016 – June 30, 2017"]
["Highlight data from:",null,{"$f":"IF(ISBLANK(C12),\"\",EDATE(C12, -6))","v":""}]
["# Target Children",null,{"$f":"COUNTA(A17:A43)","v":0}]
["Percentage Meeting Requirements",null,null,null,null,{"$f":"COUNTIF(F17:F47,\">=2\")/COUNTIF(F17:F47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G17:G47,\">=2\")/COUNTIF(G17:G47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(H17:H47,\">=2\")/COUNTIF(H17:H47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(I17:I47,\">=1\")/COUNTIF(I17:I47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J17:J47,\">=1\")/COUNTIF(J17:J47,\">=0\")","v":{"$error":"#DIV/0!"}}]
["Child ID","Adjusted DOB*","Actual DOB","Receives Early Intervention?","Date Early Invervention Began","Year One Number of Screens","Year Two Number of Screens","Year Three Number of Screens","Year Four Number of Screens","Year Five Number of Screens","2 Month","2 Month Complete","Valid?","Result","Action","4 Month","4 Month Complete","Valid?","Result","Action","6 Month","6 Month Complete","Valid?","Result","Action","8 Month","8 Month Complete","Valid?","Result","Action","9 Month","9 Month Complete","Valid?","Result","Action","10 Month ","10 Month Complete","Valid?","Result","Action","12 Month ","12 Month Complete","Valid?","Result","Action","14 Month ","14 Month Complete","Valid?","Result","Action","16 Month ","16 Month Complete","Valid?","Result","Action","18 Month ","18 Month Complete","Valid?","Result","Action","20 Month ","20 Month Complete","Valid?","Result","Action","22 Month ","22 Month Complete","Valid?","Result","Action","24 Month ","24 Month Complete","Valid?","Result","Action","27 Month ","27 Month Complete","Valid?","Result","Action","30 Month ","30 Month Complete","Valid?","Result","Action","33 Month ","33 Month Complete","Valid?","Result","Action","36 Month ","36 Month Complete","Valid?","Result","Action","42 Month","42 Month Complete","Valid?","Result","Action","48 Month ","48 Month Complete","Valid?","Result","Action","54 Month ","54 Month Complete","Valid?","Result","Action","60 Month ","60 Month Complete","Valid?","Result","Action"]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,12)>C$12,IF((COUNTIF(M17:AQ17,\"Yes\"))>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",\"N/A\")),IF(COUNTIF(M17:AQ17,\"Yes\")>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",COUNTIF(M17:AQ17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,24)>C$12,IF((COUNTIF(AV17:BU17,\"Yes\"))>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",\"N/A\")),IF(COUNTIF(AV17:BU17,\"Yes\")>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",COUNTIF(AV17:BU17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,36)>C$12,IF((COUNTIF(BZ17:CO17,\"Yes\"))>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",\"N/A\")),IF(COUNTIF(BZ17:CO17,\"Yes\")>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",COUNTIF(BZ17:CO17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,48)>C$12,IF((COUNTIF(CT17:DB17,\"Yes\"))>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",\"N/A\")),IF(COUNTIF(CT17:DB17,\"Yes\")>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",COUNTIF(CT17:DB17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,60)>C$12,IF((COUNTIF(DD17:DI17,\"Yes\"))>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",\"N/A\")),IF(COUNTIF(DD17:DI17,\"Yes\")>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",COUNTIF(DD17:DI17,\"Yes\")))))","v":"N/A"},{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,2)),(EDATE(B17,2)))","v":""},null,{"$f":"IF(L17=\"\",\"\",IF(AND(EDATE(K17,1)>=L17,EDATE(K17,-1)<=L17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,4)),(EDATE(B17,4)))","v":""},null,{"$f":"IF(Q17=\"\",\"\",IF(AND(EDATE(P17,1)>=Q17,EDATE(P17,-1)<=Q17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,6)),(EDATE(B17,6)))","v":""},null,{"$f":"IF(V17=\"\",\"\",IF(AND(EDATE(U17,1)>=V17,EDATE(U17,-1)<=V17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,8)),(EDATE(B17,8)))","v":""},null,{"$f":"IF(AA17=\"\",\"\",IF(AND(EDATE(Z17,1)>=AA17,EDATE(Z17,-1)<=AA17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,9)),(EDATE(B17,9)))","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(EDATE(AE17,1)>=AF17,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,10)),(EDATE(B17,10)))","v":""},null,{"$f":"IF(AK17=\"\",\"\",IF(AND(EDATE(AJ17,1)>=AK17,EDATE(AJ17,-1)<=AK17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,12)),(EDATE(B17,12)))","v":""},null,{"$f":"IF(AP17=\"\",\"\",IF(AND(EDATE(AO17,1)>=AP17,EDATE(AO17,-1)<=AP17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,14)),(EDATE(B17,14)))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AND(EDATE(AT17,1)>=AU17,EDATE(AT17,-1)<=AU17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,16)),(EDATE(B17,16)))","v":""},null,{"$f":"IF(AZ17=\"\",\"\",IF(AND(EDATE(AY17,1)>=AZ17,EDATE(AY17,-1)<=AZ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,18)),(EDATE(B17,18)))","v":""},null,{"$f":"IF(BE17=\"\",\"\",IF(AND(EDATE(BD17,1)>=BE17,EDATE(BD17,-1)<=BE17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,20)),(EDATE(B17,20)))","v":""},null,{"$f":"IF(BJ17=\"\",\"\",IF(AND(EDATE(BI17,1)>=BJ17,EDATE(BI17,-1)<=BJ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,22)),(EDATE(B17,22)))","v":""},null,{"$f":"IF(BO17=\"\",\"\",IF(AND(EDATE(BN17,1)>=BO17,EDATE(BN17,-1)<=BO17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,24)),(EDATE(B17,24)))","v":""},null,{"$f":"IF(BT17=\"\",\"\",IF(AND(EDATE(BS17,-1)<=BT17,(BS17+45)>=BT17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,27)))","v":""},null,{"$f":"IF(BY17=\"\",\"\",IF(AND((BX17+45)>=BY17,(BX17-45)<=BY17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,30)))","v":""},null,{"$f":"IF(CD17=\"\",\"\",IF(AND((CC17+45)>=CD17,(CC17-45)<=CD17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,33)))","v":""},null,{"$f":"IF(CI17=\"\",\"\",IF(AND((CH17+45)>=CI17,(CH17-45)<=CI17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,36)))","v":""},null,{"$f":"IF(CN17=\"\",\"\",IF(AND(EDATE(CM17,3)>=CN17,(CM17-45)<=CN17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,42)))","v":""},null,{"$f":"IF(CS17=\"\",\"\",IF(AND(EDATE(CR17,3)>=CS17,EDATE(CR17,-3)<=CS17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,48)))","v":""},null,{"$f":"IF(CX17=\"\",\"\",IF(AND(EDATE(CW17,3)>=CX17,EDATE(CW17,-3)<=CX17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,54)))","v":""},null,{"$f":"IF(DC17=\"\",\"\",IF(AND(EDATE(DB17,3)>=DC17,EDATE(DB17,-3)<=DC17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,60)))","v":""},null,{"$f":"IF(DH17=\"\",\"\",IF(AND(EDATE(DG17,6)>=DH17,EDATE(DG17,-3)<=DH17),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,2)),(EDATE(B18,2)))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(AND(EDATE(K18,1)>=L18,EDATE(K18,-1)<=L18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,4)),(EDATE(B18,4)))","v":""},null,{"$f":"IF(Q18=\"\",\"\",IF(AND(EDATE(P18,1)>=Q18,EDATE(P18,-1)<=Q18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(V18=\"\",\"\",IF(AND(EDATE(U18,1)>=V18,EDATE(U18,-1)<=V18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AA18=\"\",\"\",IF(AND(EDATE(Z18,1)>=AA18,EDATE(Z18,-1)<=AA18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AF18=\"\",\"\",IF(EDATE(AE18,1)>=AF18,\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AK18=\"\",\"\",IF(AND(EDATE(AJ18,1)>=AK18,EDATE(AJ18,-1)<=AK18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AP18=\"\",\"\",IF(AND(EDATE(AO18,1)>=AP18,EDATE(AO18,-1)<=AP18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AU18=\"\",\"\",IF(AND(EDATE(AT18,1)>=AU18,EDATE(AT18,-1)<=AU18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AZ18=\"\",\"\",IF(AND(EDATE(AY18,1)>=AZ18,EDATE(AY18,-1)<=AZ18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BE18=\"\",\"\",IF(AND(EDATE(BD18,1)>=BE18,EDATE(BD18,-1)<=BE18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BJ18=\"\",\"\",IF(AND(EDATE(BI18,1)>=BJ18,EDATE(BI18,-1)<=BJ18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BO18=\"\",\"\",IF(AND(EDATE(BN18,1)>=BO18,EDATE(BN18,-1)<=BO18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BT18=\"\",\"\",IF(AND(EDATE(BS18,-1)<=BT18,(BS18+45)>=BT18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BY18=\"\",\"\",IF(AND((BX18+45)>=BY18,(BX18-45)<=BY18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD18=\"\",\"\",IF(AND((CC18+45)>=CD18,(CC18-45)<=CD18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI18=\"\",\"\",IF(AND((CH18+45)>=CI18,(CH18-45)<=CI18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN18=\"\",\"\",IF(AND(EDATE(CM18,3)>=CN18,(CM18-45)<=CN18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS18=\"\",\"\",IF(AND(EDATE(CR18,3)>=CS18,EDATE(CR18,-3)<=CS18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX18=\"\",\"\",IF(AND(EDATE(CW18,3)>=CX18,EDATE(CW18,-3)<=CX18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC18=\"\",\"\",IF(AND(EDATE(DB18,3)>=DC18,EDATE(DB18,-3)<=DC18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH18=\"\",\"\",IF(AND(EDATE(DG18,6)>=DH18,EDATE(DG18,-3)<=DH18),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q24=\"\",\"\",IF(AND(EDATE(P24,1)>=Q24,EDATE(P24,-1)<=Q24),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q25=\"\",\"\",IF(AND(EDATE(P25,1)>=Q25,EDATE(P25,-1)<=Q25),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,{"$f":"IF(L29=\"\",\"\",IF(AND(EDATE(K29,1)>=L29,EDATE(K29,-1)<=L29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(Q29=\"\",\"\",IF(AND(EDATE(P29,1)>=Q29,EDATE(P29,-1)<=Q29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(V29=\"\",\"\",IF(AND(EDATE(U29,1)>=V29,EDATE(U29,-1)<=V29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AA29=\"\",\"\",IF(AND(EDATE(Z29,1)>=AA29,EDATE(Z29,-1)<=AA29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AF29=\"\",\"\",IF(EDATE(AE29,1)>=AF29,\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AK29=\"\",\"\",IF(AND(EDATE(AJ29,1)>=AK29,EDATE(AJ29,-1)<=AK29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AP29=\"\",\"\",IF(AND(EDATE(AO29,1)>=AP29,EDATE(AO29,-1)<=AP29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AU29=\"\",\"\",IF(AND(EDATE(AT29,1)>=AU29,EDATE(AT29,-1)<=AU29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AZ29=\"\",\"\",IF(AND(EDATE(AY29,1)>=AZ29,EDATE(AY29,-1)<=AZ29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BE29=\"\",\"\",IF(AND(EDATE(BD29,1)>=BE29,EDATE(BD29,-1)<=BE29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BJ29=\"\",\"\",IF(AND(EDATE(BI29,1)>=BJ29,EDATE(BI29,-1)<=BJ29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BO29=\"\",\"\",IF(AND(EDATE(BN29,1)>=BO29,EDATE(BN29,-1)<=BO29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BT29=\"\",\"\",IF(AND(EDATE(BS29,-1)<=BT29,(BS29+45)>=BT29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BY29=\"\",\"\",IF(AND((BX29+45)>=BY29,(BX29-45)<=BY29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD29=\"\",\"\",IF(AND((CC29+45)>=CD29,(CC29-45)<=CD29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI29=\"\",\"\",IF(AND((CH29+45)>=CI29,(CH29-45)<=CI29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN29=\"\",\"\",IF(AND(EDATE(CM29,3)>=CN29,(CM29-45)<=CN29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS29=\"\",\"\",IF(AND(EDATE(CR29,3)>=CS29,EDATE(CR29,-3)<=CS29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX29=\"\",\"\",IF(AND(EDATE(CW29,3)>=CX29,EDATE(CW29,-3)<=CX29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC29=\"\",\"\",IF(AND(EDATE(DB29,3)>=DC29,EDATE(DB29,-3)<=DC29),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH29=\"\",\"\",IF(AND(EDATE(DG29,6)>=DH29,EDATE(DG29,-3)<=DH29),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,{"$f":"IF(L33=\"\",\"\",IF(AND(EDATE(K33,1)>=L33,EDATE(K33,-1)<=L33),\"Yes\",\"No\"))","v":""},null,null,"",null,"",null,null,"",null,{"$f":"IF(V33=\"\",\"\",IF(AND(EDATE(U33,1)>=V33,EDATE(U33,-1)<=V33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AA33=\"\",\"\",IF(AND(EDATE(Z33,1)>=AA33,EDATE(Z33,-1)<=AA33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AF33=\"\",\"\",IF(EDATE(AE33,1)>=AF33,\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AK33=\"\",\"\",IF(AND(EDATE(AJ33,1)>=AK33,EDATE(AJ33,-1)<=AK33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AP33=\"\",\"\",IF(AND(EDATE(AO33,1)>=AP33,EDATE(AO33,-1)<=AP33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AU33=\"\",\"\",IF(AND(EDATE(AT33,1)>=AU33,EDATE(AT33,-1)<=AU33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(AZ33=\"\",\"\",IF(AND(EDATE(AY33,1)>=AZ33,EDATE(AY33,-1)<=AZ33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BE33=\"\",\"\",IF(AND(EDATE(BD33,1)>=BE33,EDATE(BD33,-1)<=BE33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BJ33=\"\",\"\",IF(AND(EDATE(BI33,1)>=BJ33,EDATE(BI33,-1)<=BJ33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BO33=\"\",\"\",IF(AND(EDATE(BN33,1)>=BO33,EDATE(BN33,-1)<=BO33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BT33=\"\",\"\",IF(AND(EDATE(BS33,-1)<=BT33,(BS33+45)>=BT33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(BY33=\"\",\"\",IF(AND((BX33+45)>=BY33,(BX33-45)<=BY33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD33=\"\",\"\",IF(AND((CC33+45)>=CD33,(CC33-45)<=CD33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI33=\"\",\"\",IF(AND((CH33+45)>=CI33,(CH33-45)<=CI33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN33=\"\",\"\",IF(AND(EDATE(CM33,3)>=CN33,(CM33-45)<=CN33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS33=\"\",\"\",IF(AND(EDATE(CR33,3)>=CS33,EDATE(CR33,-3)<=CS33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX33=\"\",\"\",IF(AND(EDATE(CW33,3)>=CX33,EDATE(CW33,-3)<=CX33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC33=\"\",\"\",IF(AND(EDATE(DB33,3)>=DC33,EDATE(DB33,-3)<=DC33),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH33=\"\",\"\",IF(AND(EDATE(DG33,6)>=DH33,EDATE(DG33,-3)<=DH33),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]

{"sheet":"HV2","index":4,"n_rows":47,"n_cols":115,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,27,9,31],[5,1,5,56],[6,1,6,56],[7,1,7,56],[8,1,8,56]]}
[null,"6-6.B ASQ Developmental Screening Tracking"]
[]
[null,"Instructions:  ","HFA requires a minimum of two valid screens per year until the age 3, and one per year thereafter. "]
[null,"Enter in yellow highlighted fields only"]
[null,"*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
[null,"The blue columns are automatically calculating the dates each ASQ is due; the \"Valid?\" columns automatically calculate whether the date completed was within a month (before or after)"]
[null," of the due date, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday,"]
[null," that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
[null,"For each new fiscal year, beging entering new ASQ screens starting July 1. However ALSO INCLUDE (enter) the last completed ASQ from the prior fiscal year."]
["Home Visitor"]
["Supervisor:"]
["Today's Date"]
["Highlight data from:",null,{"$f":"IF(ISBLANK(C12),\"\",EDATE(C12, -6))","v":""}]
["# Target Children",null,{"$f":"COUNTA(A17:A43)","v":0}]
["Percentage Meeting Requirements",null,null,null,null,{"$f":"COUNTIF(F17:F47,\">=2\")/COUNTIF(F17:F47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G17:G47,\">=2\")/COUNTIF(G17:G47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(H17:H47,\">=2\")/COUNTIF(H17:H47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(I17:I47,\">=1\")/COUNTIF(I17:I47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J17:J47,\">=1\")/COUNTIF(J17:J47,\">=0\")","v":{"$error":"#DIV/0!"}}]
["Family ID","Adjusted DOB*","Actual DOB","Receives Early Intervention?","Date Early Invervention Began","Year One Number of Screens","Year Two Number of Screens","Year Three Number of Screens","Year Four Number of Screens","Year Five Number of Screens","2 Month","2 Month Complete","Valid?","Result","Action","4 Month","4 Month Complete","Valid?","Result","Action","6 Month","6 Month Complete","Valid?","Result","Action","8 Month","8 Month Complete","Valid?","Result","Action","9 Month","9 Month Complete","Valid?","Result","Action","10 Month ","10 Month Complete","Valid?","Result","Action","12 Month ","12 Month Complete","Valid?","Result","Action","14 Month ","14 Month Complete","Valid?","Result","Action","16 Month ","16 Month Complete","Valid?","Result","Action","18 Month ","18 Month Complete","Valid?","Result","Action","20 Month ","20 Month Complete","Valid?","Result","Action","22 Month ","22 Month Complete","Valid?","Result","Action","24 Month ","24 Month Complete","Valid?","Result","Action","27 Month ","27 Month Complete","Valid?","Result","Action","30 Month ","30 Month Complete","Valid?","Result","Action","33 Month ","33 Month Complete","Valid?","Result","Action","36 Month ","36 Month Complete","Valid?","Result","Action","42 Month","42 Month Complete","Valid?","Result","Action","48 Month ","48 Month Complete","Valid?","Result","Action","54 Month ","54 Month Complete","Valid?","Result","Action","60 Month ","60 Month Complete","Valid?","Result","Action"]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,12)>C$12,IF((COUNTIF(M17:AQ17,\"Yes\"))>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",\"N/A\")),IF(COUNTIF(M17:AQ17,\"Yes\")>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",COUNTIF(M17:AQ17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,24)>C$12,IF((COUNTIF(AV17:BU17,\"Yes\"))>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",\"N/A\")),IF(COUNTIF(AV17:BU17,\"Yes\")>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",COUNTIF(AV17:BU17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,36)>C$12,IF((COUNTIF(BZ17:CO17,\"Yes\"))>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",\"N/A\")),IF(COUNTIF(BZ17:CO17,\"Yes\")>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",COUNTIF(BZ17:CO17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,48)>C$12,IF((COUNTIF(CT17:DB17,\"Yes\"))>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",\"N/A\")),IF(COUNTIF(CT17:DB17,\"Yes\")>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",COUNTIF(CT17:DB17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,60)>C$12,IF((COUNTIF(DD17:DI17,\"Yes\"))>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",\"N/A\")),IF(COUNTIF(DD17:DI17,\"Yes\")>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",COUNTIF(DD17:DI17,\"Yes\")))))","v":"N/A"},{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,2)),(EDATE(B17,2)))","v":""},null,{"$f":"IF(L17=\"\",\"\",IF(AND(EDATE(K17,1)>=L17,EDATE(K17,-1)<=L17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,4)),(EDATE(B17,4)))","v":""},null,{"$f":"IF(Q17=\"\",\"\",IF(AND(EDATE(P17,1)>=Q17,EDATE(P17,-1)<=Q17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,6)),(EDATE(B17,6)))","v":""},null,{"$f":"IF(V17=\"\",\"\",IF(AND(EDATE(U17,1)>=V17,EDATE(U17,-1)<=V17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,8)),(EDATE(B17,8)))","v":""},null,{"$f":"IF(AA17=\"\",\"\",IF(AND(EDATE(Z17,1)>=AA17,EDATE(Z17,-1)<=AA17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,9)),(EDATE(B17,9)))","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(EDATE(AE17,1)>=AF17,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,10)),(EDATE(B17,10)))","v":""},null,{"$f":"IF(AK17=\"\",\"\",IF(AND(EDATE(AJ17,1)>=AK17,EDATE(AJ17,-1)<=AK17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,12)),(EDATE(B17,12)))","v":""},null,{"$f":"IF(AP17=\"\",\"\",IF(AND(EDATE(AO17,1)>=AP17,EDATE(AO17,-1)<=AP17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,14)),(EDATE(B17,14)))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AND(EDATE(AT17,1)>=AU17,EDATE(AT17,-1)<=AU17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,16)),(EDATE(B17,16)))","v":""},null,{"$f":"IF(AZ17=\"\",\"\",IF(AND(EDATE(AY17,1)>=AZ17,EDATE(AY17,-1)<=AZ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,18)),(EDATE(B17,18)))","v":""},null,{"$f":"IF(BE17=\"\",\"\",IF(AND(EDATE(BD17,1)>=BE17,EDATE(BD17,-1)<=BE17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,20)),(EDATE(B17,20)))","v":""},null,{"$f":"IF(BJ17=\"\",\"\",IF(AND(EDATE(BI17,1)>=BJ17,EDATE(BI17,-1)<=BJ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,22)),(EDATE(B17,22)))","v":""},null,{"$f":"IF(BO17=\"\",\"\",IF(AND(EDATE(BN17,1)>=BO17,EDATE(BN17,-1)<=BO17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,24)),(EDATE(B17,24)))","v":""},null,{"$f":"IF(BT17=\"\",\"\",IF(AND(EDATE(BS17,-1)<=BT17,(BS17+45)>=BT17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,27)))","v":""},null,{"$f":"IF(BY17=\"\",\"\",IF(AND((BX17+45)>=BY17,(BX17-45)<=BY17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,30)))","v":""},null,{"$f":"IF(CD17=\"\",\"\",IF(AND((CC17+45)>=CD17,(CC17-45)<=CD17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,33)))","v":""},null,{"$f":"IF(CI17=\"\",\"\",IF(AND((CH17+45)>=CI17,(CH17-45)<=CI17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,36)))","v":""},null,{"$f":"IF(CN17=\"\",\"\",IF(AND(EDATE(CM17,3)>=CN17,(CM17-45)<=CN17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,42)))","v":""},null,{"$f":"IF(CS17=\"\",\"\",IF(AND(EDATE(CR17,3)>=CS17,EDATE(CR17,-3)<=CS17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,48)))","v":""},null,{"$f":"IF(CX17=\"\",\"\",IF(AND(EDATE(CW17,3)>=CX17,EDATE(CW17,-3)<=CX17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,54)))","v":""},null,{"$f":"IF(DC17=\"\",\"\",IF(AND(EDATE(DB17,3)>=DC17,EDATE(DB17,-3)<=DC17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,60)))","v":""},null,{"$f":"IF(DH17=\"\",\"\",IF(AND(EDATE(DG17,6)>=DH17,EDATE(DG17,-3)<=DH17),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,2)),(EDATE(B18,2)))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(AND(EDATE(K18,1)>=L18,EDATE(K18,-1)<=L18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,4)),(EDATE(B18,4)))","v":""},null,{"$f":"IF(Q18=\"\",\"\",IF(AND(EDATE(P18,1)>=Q18,EDATE(P18,-1)<=Q18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,6)),(EDATE(B18,6)))","v":""},null,{"$f":"IF(V18=\"\",\"\",IF(AND(EDATE(U18,1)>=V18,EDATE(U18,-1)<=V18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,8)),(EDATE(B18,8)))","v":""},null,{"$f":"IF(AA18=\"\",\"\",IF(AND(EDATE(Z18,1)>=AA18,EDATE(Z18,-1)<=AA18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,9)),(EDATE(B18,9)))","v":""},null,{"$f":"IF(AF18=\"\",\"\",IF(EDATE(AE18,1)>=AF18,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,10)),(EDATE(B18,10)))","v":""},null,{"$f":"IF(AK18=\"\",\"\",IF(AND(EDATE(AJ18,1)>=AK18,EDATE(AJ18,-1)<=AK18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,12)),(EDATE(B18,12)))","v":""},null,{"$f":"IF(AP18=\"\",\"\",IF(AND(EDATE(AO18,1)>=AP18,EDATE(AO18,-1)<=AP18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,14)),(EDATE(B18,14)))","v":""},null,{"$f":"IF(AU18=\"\",\"\",IF(AND(EDATE(AT18,1)>=AU18,EDATE(AT18,-1)<=AU18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,16)),(EDATE(B18,16)))","v":""},null,{"$f":"IF(AZ18=\"\",\"\",IF(AND(EDATE(AY18,1)>=AZ18,EDATE(AY18,-1)<=AZ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,18)),(EDATE(B18,18)))","v":""},null,{"$f":"IF(BE18=\"\",\"\",IF(AND(EDATE(BD18,1)>=BE18,EDATE(BD18,-1)<=BE18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,20)),(EDATE(B18,20)))","v":""},null,{"$f":"IF(BJ18=\"\",\"\",IF(AND(EDATE(BI18,1)>=BJ18,EDATE(BI18,-1)<=BJ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,22)),(EDATE(B18,22)))","v":""},null,{"$f":"IF(BO18=\"\",\"\",IF(AND(EDATE(BN18,1)>=BO18,EDATE(BN18,-1)<=BO18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,24)),(EDATE(B18,24)))","v":""},null,{"$f":"IF(BT18=\"\",\"\",IF(AND(EDATE(BS18,-1)<=BT18,(BS18+45)>=BT18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C18),\"\",(EDATE(C18,27)))","v":""},null,{"$f":"IF(BY18=\"\",\"\",IF(AND((BX18+45)>=BY18,(BX18-45)<=BY18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD18=\"\",\"\",IF(AND((CC18+45)>=CD18,(CC18-45)<=CD18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI18=\"\",\"\",IF(AND((CH18+45)>=CI18,(CH18-45)<=CI18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN18=\"\",\"\",IF(AND(EDATE(CM18,3)>=CN18,(CM18-45)<=CN18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS18=\"\",\"\",IF(AND(EDATE(CR18,3)>=CS18,EDATE(CR18,-3)<=CS18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX18=\"\",\"\",IF(AND(EDATE(CW18,3)>=CX18,EDATE(CW18,-3)<=CX18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC18=\"\",\"\",IF(AND(EDATE(DB18,3)>=DC18,EDATE(DB18,-3)<=DC18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH18=\"\",\"\",IF(AND(EDATE(DG18,6)>=DH18,EDATE(DG18,-3)<=DH18),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q24=\"\",\"\",IF(AND(EDATE(P24,1)>=Q24,EDATE(P24,-1)<=Q24),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q25=\"\",\"\",IF(AND(EDATE(P25,1)>=Q25,EDATE(P25,-1)<=Q25),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]

{"sheet":"HV3","index":5,"n_rows":47,"n_cols":115,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,27,9,31],[5,1,5,56],[6,1,6,56],[7,1,7,56],[8,1,8,56]]}
[null,"6-6.B ASQ Developmental Screening Tracking"]
[]
[null,"Instructions:  ","HFA requires a minimum of two valid screens per year until the age 3, and one per year thereafter. "]
[null,"Enter in yellow highlighted fields only"]
[null,"*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
[null,"The blue columns are automatically calculating the dates each ASQ is due; the \"Valid?\" columns automatically calculate whether the date completed was within a month (before or after)"]
[null," of the due date, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday,"]
[null," that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
[null,"For each new fiscal year, beging entering new ASQ screens starting July 1. However ALSO INCLUDE (enter) the last completed ASQ from the prior fiscal year."]
["Home Visitor"]
["Supervisor:"]
["Today's Date"]
["Highlight data from:",null,{"$f":"IF(ISBLANK(C12),\"\",EDATE(C12, -6))","v":""}]
["# Target Children",null,{"$f":"COUNTA(A17:A43)","v":0}]
["Percentage Meeting Requirements",null,null,null,null,{"$f":"COUNTIF(F17:F47,\">=2\")/COUNTIF(F17:F47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G17:G47,\">=2\")/COUNTIF(G17:G47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(H17:H47,\">=2\")/COUNTIF(H17:H47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(I17:I47,\">=1\")/COUNTIF(I17:I47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J17:J47,\">=1\")/COUNTIF(J17:J47,\">=0\")","v":{"$error":"#DIV/0!"}}]
["Family ID","Adjusted DOB*","Actual DOB","Receives Early Intervention?","Date Early Invervention Began","Year One Number of Screens","Year Two Number of Screens","Year Three Number of Screens","Year Four Number of Screens","Year Five Number of Screens","2 Month","2 Month Complete","Valid?","Result","Action","4 Month","4 Month Complete","Valid?","Result","Action","6 Month","6 Month Complete","Valid?","Result","Action","8 Month","8 Month Complete","Valid?","Result","Action","9 Month","9 Month Complete","Valid?","Result","Action","10 Month ","10 Month Complete","Valid?","Result","Action","12 Month ","12 Month Complete","Valid?","Result","Action","14 Month ","14 Month Complete","Valid?","Result","Action","16 Month ","16 Month Complete","Valid?","Result","Action","18 Month ","18 Month Complete","Valid?","Result","Action","20 Month ","20 Month Complete","Valid?","Result","Action","22 Month ","22 Month Complete","Valid?","Result","Action","24 Month ","24 Month Complete","Valid?","Result","Action","27 Month ","27 Month Complete","Valid?","Result","Action","30 Month ","30 Month Complete","Valid?","Result","Action","33 Month ","33 Month Complete","Valid?","Result","Action","36 Month ","36 Month Complete","Valid?","Result","Action","42 Month","42 Month Complete","Valid?","Result","Action","48 Month ","48 Month Complete","Valid?","Result","Action","54 Month ","54 Month Complete","Valid?","Result","Action","60 Month ","60 Month Complete","Valid?","Result","Action"]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,12)>C$12,IF((COUNTIF(M17:AQ17,\"Yes\"))>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",\"N/A\")),IF(COUNTIF(M17:AQ17,\"Yes\")>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",COUNTIF(M17:AQ17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,24)>C$12,IF((COUNTIF(AV17:BU17,\"Yes\"))>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",\"N/A\")),IF(COUNTIF(AV17:BU17,\"Yes\")>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",COUNTIF(AV17:BU17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,36)>C$12,IF((COUNTIF(BZ17:CO17,\"Yes\"))>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",\"N/A\")),IF(COUNTIF(BZ17:CO17,\"Yes\")>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",COUNTIF(BZ17:CO17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,48)>C$12,IF((COUNTIF(CT17:DB17,\"Yes\"))>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",\"N/A\")),IF(COUNTIF(CT17:DB17,\"Yes\")>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",COUNTIF(CT17:DB17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,60)>C$12,IF((COUNTIF(DD17:DI17,\"Yes\"))>=2,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",\"N/A\")),IF(COUNTIF(DD17:DI17,\"Yes\")>=2,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",COUNTIF(DD17:DI17,\"Yes\")))))","v":"N/A"},{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,2)),(EDATE(B17,2)))","v":""},null,{"$f":"IF(L17=\"\",\"\",IF(AND(EDATE(K17,1)>=L17,EDATE(K17,-1)<=L17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,4)),(EDATE(B17,4)))","v":""},null,{"$f":"IF(Q17=\"\",\"\",IF(AND(EDATE(P17,1)>=Q17,EDATE(P17,-1)<=Q17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,6)),(EDATE(B17,6)))","v":""},null,{"$f":"IF(V17=\"\",\"\",IF(AND(EDATE(U17,1)>=V17,EDATE(U17,-1)<=V17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,8)),(EDATE(B17,8)))","v":""},null,{"$f":"IF(AA17=\"\",\"\",IF(AND(EDATE(Z17,1)>=AA17,EDATE(Z17,-1)<=AA17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,9)),(EDATE(B17,9)))","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(EDATE(AE17,1)>=AF17,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,10)),(EDATE(B17,10)))","v":""},null,{"$f":"IF(AK17=\"\",\"\",IF(AND(EDATE(AJ17,1)>=AK17,EDATE(AJ17,-1)<=AK17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,12)),(EDATE(B17,12)))","v":""},null,{"$f":"IF(AP17=\"\",\"\",IF(AND(EDATE(AO17,1)>=AP17,EDATE(AO17,-1)<=AP17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,14)),(EDATE(B17,14)))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AND(EDATE(AT17,1)>=AU17,EDATE(AT17,-1)<=AU17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,16)),(EDATE(B17,16)))","v":""},null,{"$f":"IF(AZ17=\"\",\"\",IF(AND(EDATE(AY17,1)>=AZ17,EDATE(AY17,-1)<=AZ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,18)),(EDATE(B17,18)))","v":""},null,{"$f":"IF(BE17=\"\",\"\",IF(AND(EDATE(BD17,1)>=BE17,EDATE(BD17,-1)<=BE17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,20)),(EDATE(B17,20)))","v":""},null,{"$f":"IF(BJ17=\"\",\"\",IF(AND(EDATE(BI17,1)>=BJ17,EDATE(BI17,-1)<=BJ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,22)),(EDATE(B17,22)))","v":""},null,{"$f":"IF(BO17=\"\",\"\",IF(AND(EDATE(BN17,1)>=BO17,EDATE(BN17,-1)<=BO17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,24)),(EDATE(B17,24)))","v":""},null,{"$f":"IF(BT17=\"\",\"\",IF(AND(EDATE(BS17,-1)<=BT17,(BS17+45)>=BT17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,27)))","v":""},null,{"$f":"IF(BY17=\"\",\"\",IF(AND((BX17+45)>=BY17,(BX17-45)<=BY17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,30)))","v":""},null,{"$f":"IF(CD17=\"\",\"\",IF(AND((CC17+45)>=CD17,(CC17-45)<=CD17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,33)))","v":""},null,{"$f":"IF(CI17=\"\",\"\",IF(AND((CH17+45)>=CI17,(CH17-45)<=CI17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,36)))","v":""},null,{"$f":"IF(CN17=\"\",\"\",IF(AND(EDATE(CM17,3)>=CN17,(CM17-45)<=CN17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,42)))","v":""},null,{"$f":"IF(CS17=\"\",\"\",IF(AND(EDATE(CR17,3)>=CS17,EDATE(CR17,-3)<=CS17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,48)))","v":""},null,{"$f":"IF(CX17=\"\",\"\",IF(AND(EDATE(CW17,3)>=CX17,EDATE(CW17,-3)<=CX17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,54)))","v":""},null,{"$f":"IF(DC17=\"\",\"\",IF(AND(EDATE(DB17,3)>=DC17,EDATE(DB17,-3)<=DC17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,60)))","v":""},null,{"$f":"IF(DH17=\"\",\"\",IF(AND(EDATE(DG17,6)>=DH17,EDATE(DG17,-3)<=DH17),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,2)),(EDATE(B18,2)))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(AND(EDATE(K18,1)>=L18,EDATE(K18,-1)<=L18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,4)),(EDATE(B18,4)))","v":""},null,{"$f":"IF(Q18=\"\",\"\",IF(AND(EDATE(P18,1)>=Q18,EDATE(P18,-1)<=Q18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,6)),(EDATE(B18,6)))","v":""},null,{"$f":"IF(V18=\"\",\"\",IF(AND(EDATE(U18,1)>=V18,EDATE(U18,-1)<=V18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,8)),(EDATE(B18,8)))","v":""},null,{"$f":"IF(AA18=\"\",\"\",IF(AND(EDATE(Z18,1)>=AA18,EDATE(Z18,-1)<=AA18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,9)),(EDATE(B18,9)))","v":""},null,{"$f":"IF(AF18=\"\",\"\",IF(EDATE(AE18,1)>=AF18,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,10)),(EDATE(B18,10)))","v":""},null,{"$f":"IF(AK18=\"\",\"\",IF(AND(EDATE(AJ18,1)>=AK18,EDATE(AJ18,-1)<=AK18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,12)),(EDATE(B18,12)))","v":""},null,{"$f":"IF(AP18=\"\",\"\",IF(AND(EDATE(AO18,1)>=AP18,EDATE(AO18,-1)<=AP18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,14)),(EDATE(B18,14)))","v":""},null,{"$f":"IF(AU18=\"\",\"\",IF(AND(EDATE(AT18,1)>=AU18,EDATE(AT18,-1)<=AU18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,16)),(EDATE(B18,16)))","v":""},null,{"$f":"IF(AZ18=\"\",\"\",IF(AND(EDATE(AY18,1)>=AZ18,EDATE(AY18,-1)<=AZ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,18)),(EDATE(B18,18)))","v":""},null,{"$f":"IF(BE18=\"\",\"\",IF(AND(EDATE(BD18,1)>=BE18,EDATE(BD18,-1)<=BE18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,20)),(EDATE(B18,20)))","v":""},null,{"$f":"IF(BJ18=\"\",\"\",IF(AND(EDATE(BI18,1)>=BJ18,EDATE(BI18,-1)<=BJ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,22)),(EDATE(B18,22)))","v":""},null,{"$f":"IF(BO18=\"\",\"\",IF(AND(EDATE(BN18,1)>=BO18,EDATE(BN18,-1)<=BO18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,24)),(EDATE(B18,24)))","v":""},null,{"$f":"IF(BT18=\"\",\"\",IF(AND(EDATE(BS18,-1)<=BT18,(BS18+45)>=BT18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C18),\"\",(EDATE(C18,27)))","v":""},null,{"$f":"IF(BY18=\"\",\"\",IF(AND((BX18+45)>=BY18,(BX18-45)<=BY18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD18=\"\",\"\",IF(AND((CC18+45)>=CD18,(CC18-45)<=CD18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI18=\"\",\"\",IF(AND((CH18+45)>=CI18,(CH18-45)<=CI18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN18=\"\",\"\",IF(AND(EDATE(CM18,3)>=CN18,(CM18-45)<=CN18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS18=\"\",\"\",IF(AND(EDATE(CR18,3)>=CS18,EDATE(CR18,-3)<=CS18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX18=\"\",\"\",IF(AND(EDATE(CW18,3)>=CX18,EDATE(CW18,-3)<=CX18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC18=\"\",\"\",IF(AND(EDATE(DB18,3)>=DC18,EDATE(DB18,-3)<=DC18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH18=\"\",\"\",IF(AND(EDATE(DG18,6)>=DH18,EDATE(DG18,-3)<=DH18),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q24=\"\",\"\",IF(AND(EDATE(P24,1)>=Q24,EDATE(P24,-1)<=Q24),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q25=\"\",\"\",IF(AND(EDATE(P25,1)>=Q25,EDATE(P25,-1)<=Q25),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]

{"sheet":"HV4","index":6,"n_rows":47,"n_cols":115,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,27,9,31],[5,1,5,56],[6,1,6,56],[7,1,7,56],[8,1,8,56]]}
[null,"6-6.B ASQ Developmental Screening Tracking"]
[]
[null,"Instructions:  ","HFA requires a minimum of two valid screens per year until the age 3, and one per year thereafter. "]
[null,"Enter in yellow highlighted fields only"]
[null,"*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
[null,"The blue columns are automatically calculating the dates each ASQ is due; the \"Valid?\" columns automatically calculate whether the date completed was within a month (before or after)"]
[null," of the due date, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday,"]
[null," that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
[null,"For each new fiscal year, beging entering new ASQ screens starting July 1. However ALSO INCLUDE (enter) the last completed ASQ from the prior fiscal year."]
["Home Visitor"]
["Supervisor:"]
["Today's Date"]
["Highlight data from:",null,{"$f":"IF(ISBLANK(C12),\"\",EDATE(C12, -6))","v":""}]
["# Target Children",null,{"$f":"COUNTA(A17:A43)","v":0}]
["Percentage Meeting Requirements",null,null,null,null,{"$f":"COUNTIF(F17:F47,\">=2\")/COUNTIF(F17:F47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G17:G47,\">=2\")/COUNTIF(G17:G47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(H17:H47,\">=2\")/COUNTIF(H17:H47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(I17:I47,\">=1\")/COUNTIF(I17:I47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J17:J47,\">=1\")/COUNTIF(J17:J47,\">=0\")","v":{"$error":"#DIV/0!"}}]
["Family ID","Adjusted DOB*","Actual DOB","Receives Early Intervention?","Date Early Invervention Began","Year One Number of Screens","Year Two Number of Screens","Year Three Number of Screens","Year Four Number of Screens","Year Five Number of Screens","2 Month","2 Month Complete","Valid?","Result","Action","4 Month","4 Month Complete","Valid?","Result","Action","6 Month","6 Month Complete","Valid?","Result","Action","8 Month","8 Month Complete","Valid?","Result","Action","9 Month","9 Month Complete","Valid?","Result","Action","10 Month ","10 Month Complete","Valid?","Result","Action","12 Month ","12 Month Complete","Valid?","Result","Action","14 Month ","14 Month Complete","Valid?","Result","Action","16 Month ","16 Month Complete","Valid?","Result","Action","18 Month ","18 Month Complete","Valid?","Result","Action","20 Month ","20 Month Complete","Valid?","Result","Action","22 Month ","22 Month Complete","Valid?","Result","Action","24 Month ","24 Month Complete","Valid?","Result","Action","27 Month ","27 Month Complete","Valid?","Result","Action","30 Month ","30 Month Complete","Valid?","Result","Action","33 Month ","33 Month Complete","Valid?","Result","Action","36 Month ","36 Month Complete","Valid?","Result","Action","42 Month","42 Month Complete","Valid?","Result","Action","48 Month ","48 Month Complete","Valid?","Result","Action","54 Month ","54 Month Complete","Valid?","Result","Action","60 Month ","60 Month Complete","Valid?","Result","Action"]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,12)>C$12,IF((COUNTIF(M17:AQ17,\"Yes\"))>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",\"N/A\")),IF(COUNTIF(M17:AQ17,\"Yes\")>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",COUNTIF(M17:AQ17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,24)>C$12,IF((COUNTIF(AV17:BU17,\"Yes\"))>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",\"N/A\")),IF(COUNTIF(AV17:BU17,\"Yes\")>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",COUNTIF(AV17:BU17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,36)>C$12,IF((COUNTIF(BZ17:CO17,\"Yes\"))>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",\"N/A\")),IF(COUNTIF(BZ17:CO17,\"Yes\")>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",COUNTIF(BZ17:CO17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,48)>C$12,IF((COUNTIF(CT17:DB17,\"Yes\"))>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",\"N/A\")),IF(COUNTIF(CT17:DB17,\"Yes\")>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",COUNTIF(CT17:DB17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,60)>C$12,IF((COUNTIF(DD17:DI17,\"Yes\"))>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",\"N/A\")),IF(COUNTIF(DD17:DI17,\"Yes\")>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",COUNTIF(DD17:DI17,\"Yes\")))))","v":"N/A"},{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,2)),(EDATE(B17,2)))","v":""},null,{"$f":"IF(L17=\"\",\"\",IF(AND(EDATE(K17,1)>=L17,EDATE(K17,-1)<=L17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,4)),(EDATE(B17,4)))","v":""},null,{"$f":"IF(Q17=\"\",\"\",IF(AND(EDATE(P17,1)>=Q17,EDATE(P17,-1)<=Q17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,6)),(EDATE(B17,6)))","v":""},null,{"$f":"IF(V17=\"\",\"\",IF(AND(EDATE(U17,1)>=V17,EDATE(U17,-1)<=V17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,8)),(EDATE(B17,8)))","v":""},null,{"$f":"IF(AA17=\"\",\"\",IF(AND(EDATE(Z17,1)>=AA17,EDATE(Z17,-1)<=AA17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,9)),(EDATE(B17,9)))","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(EDATE(AE17,1)>=AF17,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,10)),(EDATE(B17,10)))","v":""},null,{"$f":"IF(AK17=\"\",\"\",IF(AND(EDATE(AJ17,1)>=AK17,EDATE(AJ17,-1)<=AK17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,12)),(EDATE(B17,12)))","v":""},null,{"$f":"IF(AP17=\"\",\"\",IF(AND(EDATE(AO17,1)>=AP17,EDATE(AO17,-1)<=AP17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,14)),(EDATE(B17,14)))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AND(EDATE(AT17,1)>=AU17,EDATE(AT17,-1)<=AU17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,16)),(EDATE(B17,16)))","v":""},null,{"$f":"IF(AZ17=\"\",\"\",IF(AND(EDATE(AY17,1)>=AZ17,EDATE(AY17,-1)<=AZ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,18)),(EDATE(B17,18)))","v":""},null,{"$f":"IF(BE17=\"\",\"\",IF(AND(EDATE(BD17,1)>=BE17,EDATE(BD17,-1)<=BE17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,20)),(EDATE(B17,20)))","v":""},null,{"$f":"IF(BJ17=\"\",\"\",IF(AND(EDATE(BI17,1)>=BJ17,EDATE(BI17,-1)<=BJ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,22)),(EDATE(B17,22)))","v":""},null,{"$f":"IF(BO17=\"\",\"\",IF(AND(EDATE(BN17,1)>=BO17,EDATE(BN17,-1)<=BO17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,24)),(EDATE(B17,24)))","v":""},null,{"$f":"IF(BT17=\"\",\"\",IF(AND(EDATE(BS17,-1)<=BT17,(BS17+45)>=BT17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,27)))","v":""},null,{"$f":"IF(BY17=\"\",\"\",IF(AND((BX17+45)>=BY17,(BX17-45)<=BY17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,30)))","v":""},null,{"$f":"IF(CD17=\"\",\"\",IF(AND((CC17+45)>=CD17,(CC17-45)<=CD17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,33)))","v":""},null,{"$f":"IF(CI17=\"\",\"\",IF(AND((CH17+45)>=CI17,(CH17-45)<=CI17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,36)))","v":""},null,{"$f":"IF(CN17=\"\",\"\",IF(AND(EDATE(CM17,3)>=CN17,(CM17-45)<=CN17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,42)))","v":""},null,{"$f":"IF(CS17=\"\",\"\",IF(AND(EDATE(CR17,3)>=CS17,EDATE(CR17,-3)<=CS17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,48)))","v":""},null,{"$f":"IF(CX17=\"\",\"\",IF(AND(EDATE(CW17,3)>=CX17,EDATE(CW17,-3)<=CX17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,54)))","v":""},null,{"$f":"IF(DC17=\"\",\"\",IF(AND(EDATE(DB17,3)>=DC17,EDATE(DB17,-3)<=DC17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,60)))","v":""},null,{"$f":"IF(DH17=\"\",\"\",IF(AND(EDATE(DG17,6)>=DH17,EDATE(DG17,-3)<=DH17),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,2)),(EDATE(B18,2)))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(AND(EDATE(K18,1)>=L18,EDATE(K18,-1)<=L18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,4)),(EDATE(B18,4)))","v":""},null,{"$f":"IF(Q18=\"\",\"\",IF(AND(EDATE(P18,1)>=Q18,EDATE(P18,-1)<=Q18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,6)),(EDATE(B18,6)))","v":""},null,{"$f":"IF(V18=\"\",\"\",IF(AND(EDATE(U18,1)>=V18,EDATE(U18,-1)<=V18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,8)),(EDATE(B18,8)))","v":""},null,{"$f":"IF(AA18=\"\",\"\",IF(AND(EDATE(Z18,1)>=AA18,EDATE(Z18,-1)<=AA18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,9)),(EDATE(B18,9)))","v":""},null,{"$f":"IF(AF18=\"\",\"\",IF(EDATE(AE18,1)>=AF18,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,10)),(EDATE(B18,10)))","v":""},null,{"$f":"IF(AK18=\"\",\"\",IF(AND(EDATE(AJ18,1)>=AK18,EDATE(AJ18,-1)<=AK18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,12)),(EDATE(B18,12)))","v":""},null,{"$f":"IF(AP18=\"\",\"\",IF(AND(EDATE(AO18,1)>=AP18,EDATE(AO18,-1)<=AP18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,14)),(EDATE(B18,14)))","v":""},null,{"$f":"IF(AU18=\"\",\"\",IF(AND(EDATE(AT18,1)>=AU18,EDATE(AT18,-1)<=AU18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,16)),(EDATE(B18,16)))","v":""},null,{"$f":"IF(AZ18=\"\",\"\",IF(AND(EDATE(AY18,1)>=AZ18,EDATE(AY18,-1)<=AZ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,18)),(EDATE(B18,18)))","v":""},null,{"$f":"IF(BE18=\"\",\"\",IF(AND(EDATE(BD18,1)>=BE18,EDATE(BD18,-1)<=BE18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,20)),(EDATE(B18,20)))","v":""},null,{"$f":"IF(BJ18=\"\",\"\",IF(AND(EDATE(BI18,1)>=BJ18,EDATE(BI18,-1)<=BJ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,22)),(EDATE(B18,22)))","v":""},null,{"$f":"IF(BO18=\"\",\"\",IF(AND(EDATE(BN18,1)>=BO18,EDATE(BN18,-1)<=BO18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,24)),(EDATE(B18,24)))","v":""},null,{"$f":"IF(BT18=\"\",\"\",IF(AND(EDATE(BS18,-1)<=BT18,(BS18+45)>=BT18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C18),\"\",(EDATE(C18,27)))","v":""},null,{"$f":"IF(BY18=\"\",\"\",IF(AND((BX18+45)>=BY18,(BX18-45)<=BY18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD18=\"\",\"\",IF(AND((CC18+45)>=CD18,(CC18-45)<=CD18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI18=\"\",\"\",IF(AND((CH18+45)>=CI18,(CH18-45)<=CI18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN18=\"\",\"\",IF(AND(EDATE(CM18,3)>=CN18,(CM18-45)<=CN18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS18=\"\",\"\",IF(AND(EDATE(CR18,3)>=CS18,EDATE(CR18,-3)<=CS18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX18=\"\",\"\",IF(AND(EDATE(CW18,3)>=CX18,EDATE(CW18,-3)<=CX18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC18=\"\",\"\",IF(AND(EDATE(DB18,3)>=DC18,EDATE(DB18,-3)<=DC18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH18=\"\",\"\",IF(AND(EDATE(DG18,6)>=DH18,EDATE(DG18,-3)<=DH18),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q24=\"\",\"\",IF(AND(EDATE(P24,1)>=Q24,EDATE(P24,-1)<=Q24),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q25=\"\",\"\",IF(AND(EDATE(P25,1)>=Q25,EDATE(P25,-1)<=Q25),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]

{"sheet":"HV5","index":7,"n_rows":47,"n_cols":115,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,27,9,31],[5,1,5,56],[6,1,6,56],[7,1,7,56],[8,1,8,56]]}
[null,"6-6.B ASQ Developmental Screening Tracking"]
[]
[null,"Instructions:  ","HFA requires a minimum of two valid screens per year until the age 3, and one per year thereafter. "]
[null,"Enter in yellow highlighted fields only"]
[null,"*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
[null,"The blue columns are automatically calculating the dates each ASQ is due; the \"Valid?\" columns automatically calculate whether the date completed was within a month (before or after)"]
[null," of the due date, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday,"]
[null," that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
[null,"For each new fiscal year, beging entering new ASQ screens starting July 1. However ALSO INCLUDE (enter) the last completed ASQ from the prior fiscal year."]
["Home Visitor"]
["Supervisor:"]
["Today's Date"]
["Highlight data from:",null,{"$f":"IF(ISBLANK(C12),\"\",EDATE(C12, -6))","v":""}]
["# Target Children",null,{"$f":"COUNTA(A17:A43)","v":0}]
["Percentage Meeting Requirements",null,null,null,null,{"$f":"COUNTIF(F17:F47,\">=2\")/COUNTIF(F17:F47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G17:G47,\">=2\")/COUNTIF(G17:G47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(H17:H47,\">=2\")/COUNTIF(H17:H47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(I17:I47,\">=1\")/COUNTIF(I17:I47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J17:J47,\">=1\")/COUNTIF(J17:J47,\">=0\")","v":{"$error":"#DIV/0!"}}]
["Family ID","Adjusted DOB*","Actual DOB","Receives Early Intervention?","Date Early Invervention Began","Year One Number of Screens","Year Two Number of Screens","Year Three Number of Screens","Year Four Number of Screens","Year Five Number of Screens","2 Month","2 Month Complete","Valid?","Result","Action","4 Month","4 Month Complete","Valid?","Result","Action","6 Month","6 Month Complete","Valid?","Result","Action","8 Month","8 Month Complete","Valid?","Result","Action","9 Month","9 Month Complete","Valid?","Result","Action","10 Month ","10 Month Complete","Valid?","Result","Action","12 Month ","12 Month Complete","Valid?","Result","Action","14 Month ","14 Month Complete","Valid?","Result","Action","16 Month ","16 Month Complete","Valid?","Result","Action","18 Month ","18 Month Complete","Valid?","Result","Action","20 Month ","20 Month Complete","Valid?","Result","Action","22 Month ","22 Month Complete","Valid?","Result","Action","24 Month ","24 Month Complete","Valid?","Result","Action","27 Month ","27 Month Complete","Valid?","Result","Action","30 Month ","30 Month Complete","Valid?","Result","Action","33 Month ","33 Month Complete","Valid?","Result","Action","36 Month ","36 Month Complete","Valid?","Result","Action","42 Month","42 Month Complete","Valid?","Result","Action","48 Month ","48 Month Complete","Valid?","Result","Action","54 Month ","54 Month Complete","Valid?","Result","Action","60 Month ","60 Month Complete","Valid?","Result","Action"]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,12)>C$12,IF((COUNTIF(M17:AQ17,\"Yes\"))>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",\"N/A\")),IF(COUNTIF(M17:AQ17,\"Yes\")>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",COUNTIF(M17:AQ17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,24)>C$12,IF((COUNTIF(AV17:BU17,\"Yes\"))>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",\"N/A\")),IF(COUNTIF(AV17:BU17,\"Yes\")>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",COUNTIF(AV17:BU17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,36)>C$12,IF((COUNTIF(BZ17:CO17,\"Yes\"))>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",\"N/A\")),IF(COUNTIF(BZ17:CO17,\"Yes\")>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",COUNTIF(BZ17:CO17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,48)>C$12,IF((COUNTIF(CT17:DB17,\"Yes\"))>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",\"N/A\")),IF(COUNTIF(CT17:DB17,\"Yes\")>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",COUNTIF(CT17:DB17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,60)>C$12,IF((COUNTIF(DD17:DI17,\"Yes\"))>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",\"N/A\")),IF(COUNTIF(DD17:DI17,\"Yes\")>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",COUNTIF(DD17:DI17,\"Yes\")))))","v":"N/A"},{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,2)),(EDATE(B17,2)))","v":""},null,{"$f":"IF(L17=\"\",\"\",IF(AND(EDATE(K17,1)>=L17,EDATE(K17,-1)<=L17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,4)),(EDATE(B17,4)))","v":""},null,{"$f":"IF(Q17=\"\",\"\",IF(AND(EDATE(P17,1)>=Q17,EDATE(P17,-1)<=Q17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,6)),(EDATE(B17,6)))","v":""},null,{"$f":"IF(V17=\"\",\"\",IF(AND(EDATE(U17,1)>=V17,EDATE(U17,-1)<=V17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,8)),(EDATE(B17,8)))","v":""},null,{"$f":"IF(AA17=\"\",\"\",IF(AND(EDATE(Z17,1)>=AA17,EDATE(Z17,-1)<=AA17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,9)),(EDATE(B17,9)))","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(EDATE(AE17,1)>=AF17,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,10)),(EDATE(B17,10)))","v":""},null,{"$f":"IF(AK17=\"\",\"\",IF(AND(EDATE(AJ17,1)>=AK17,EDATE(AJ17,-1)<=AK17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,12)),(EDATE(B17,12)))","v":""},null,{"$f":"IF(AP17=\"\",\"\",IF(AND(EDATE(AO17,1)>=AP17,EDATE(AO17,-1)<=AP17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,14)),(EDATE(B17,14)))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AND(EDATE(AT17,1)>=AU17,EDATE(AT17,-1)<=AU17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,16)),(EDATE(B17,16)))","v":""},null,{"$f":"IF(AZ17=\"\",\"\",IF(AND(EDATE(AY17,1)>=AZ17,EDATE(AY17,-1)<=AZ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,18)),(EDATE(B17,18)))","v":""},null,{"$f":"IF(BE17=\"\",\"\",IF(AND(EDATE(BD17,1)>=BE17,EDATE(BD17,-1)<=BE17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,20)),(EDATE(B17,20)))","v":""},null,{"$f":"IF(BJ17=\"\",\"\",IF(AND(EDATE(BI17,1)>=BJ17,EDATE(BI17,-1)<=BJ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,22)),(EDATE(B17,22)))","v":""},null,{"$f":"IF(BO17=\"\",\"\",IF(AND(EDATE(BN17,1)>=BO17,EDATE(BN17,-1)<=BO17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,24)),(EDATE(B17,24)))","v":""},null,{"$f":"IF(BT17=\"\",\"\",IF(AND(EDATE(BS17,-1)<=BT17,(BS17+45)>=BT17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,27)))","v":""},null,{"$f":"IF(BY17=\"\",\"\",IF(AND((BX17+45)>=BY17,(BX17-45)<=BY17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,30)))","v":""},null,{"$f":"IF(CD17=\"\",\"\",IF(AND((CC17+45)>=CD17,(CC17-45)<=CD17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,33)))","v":""},null,{"$f":"IF(CI17=\"\",\"\",IF(AND((CH17+45)>=CI17,(CH17-45)<=CI17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,36)))","v":""},null,{"$f":"IF(CN17=\"\",\"\",IF(AND(EDATE(CM17,3)>=CN17,(CM17-45)<=CN17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,42)))","v":""},null,{"$f":"IF(CS17=\"\",\"\",IF(AND(EDATE(CR17,3)>=CS17,EDATE(CR17,-3)<=CS17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,48)))","v":""},null,{"$f":"IF(CX17=\"\",\"\",IF(AND(EDATE(CW17,3)>=CX17,EDATE(CW17,-3)<=CX17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,54)))","v":""},null,{"$f":"IF(DC17=\"\",\"\",IF(AND(EDATE(DB17,3)>=DC17,EDATE(DB17,-3)<=DC17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,60)))","v":""},null,{"$f":"IF(DH17=\"\",\"\",IF(AND(EDATE(DG17,6)>=DH17,EDATE(DG17,-3)<=DH17),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,2)),(EDATE(B18,2)))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(AND(EDATE(K18,1)>=L18,EDATE(K18,-1)<=L18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,4)),(EDATE(B18,4)))","v":""},null,{"$f":"IF(Q18=\"\",\"\",IF(AND(EDATE(P18,1)>=Q18,EDATE(P18,-1)<=Q18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,6)),(EDATE(B18,6)))","v":""},null,{"$f":"IF(V18=\"\",\"\",IF(AND(EDATE(U18,1)>=V18,EDATE(U18,-1)<=V18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,8)),(EDATE(B18,8)))","v":""},null,{"$f":"IF(AA18=\"\",\"\",IF(AND(EDATE(Z18,1)>=AA18,EDATE(Z18,-1)<=AA18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,9)),(EDATE(B18,9)))","v":""},null,{"$f":"IF(AF18=\"\",\"\",IF(EDATE(AE18,1)>=AF18,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,10)),(EDATE(B18,10)))","v":""},null,{"$f":"IF(AK18=\"\",\"\",IF(AND(EDATE(AJ18,1)>=AK18,EDATE(AJ18,-1)<=AK18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,12)),(EDATE(B18,12)))","v":""},null,{"$f":"IF(AP18=\"\",\"\",IF(AND(EDATE(AO18,1)>=AP18,EDATE(AO18,-1)<=AP18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,14)),(EDATE(B18,14)))","v":""},null,{"$f":"IF(AU18=\"\",\"\",IF(AND(EDATE(AT18,1)>=AU18,EDATE(AT18,-1)<=AU18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,16)),(EDATE(B18,16)))","v":""},null,{"$f":"IF(AZ18=\"\",\"\",IF(AND(EDATE(AY18,1)>=AZ18,EDATE(AY18,-1)<=AZ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,18)),(EDATE(B18,18)))","v":""},null,{"$f":"IF(BE18=\"\",\"\",IF(AND(EDATE(BD18,1)>=BE18,EDATE(BD18,-1)<=BE18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,20)),(EDATE(B18,20)))","v":""},null,{"$f":"IF(BJ18=\"\",\"\",IF(AND(EDATE(BI18,1)>=BJ18,EDATE(BI18,-1)<=BJ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,22)),(EDATE(B18,22)))","v":""},null,{"$f":"IF(BO18=\"\",\"\",IF(AND(EDATE(BN18,1)>=BO18,EDATE(BN18,-1)<=BO18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,24)),(EDATE(B18,24)))","v":""},null,{"$f":"IF(BT18=\"\",\"\",IF(AND(EDATE(BS18,-1)<=BT18,(BS18+45)>=BT18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C18),\"\",(EDATE(C18,27)))","v":""},null,{"$f":"IF(BY18=\"\",\"\",IF(AND((BX18+45)>=BY18,(BX18-45)<=BY18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD18=\"\",\"\",IF(AND((CC18+45)>=CD18,(CC18-45)<=CD18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI18=\"\",\"\",IF(AND((CH18+45)>=CI18,(CH18-45)<=CI18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN18=\"\",\"\",IF(AND(EDATE(CM18,3)>=CN18,(CM18-45)<=CN18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS18=\"\",\"\",IF(AND(EDATE(CR18,3)>=CS18,EDATE(CR18,-3)<=CS18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX18=\"\",\"\",IF(AND(EDATE(CW18,3)>=CX18,EDATE(CW18,-3)<=CX18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC18=\"\",\"\",IF(AND(EDATE(DB18,3)>=DC18,EDATE(DB18,-3)<=DC18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH18=\"\",\"\",IF(AND(EDATE(DG18,6)>=DH18,EDATE(DG18,-3)<=DH18),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q24=\"\",\"\",IF(AND(EDATE(P24,1)>=Q24,EDATE(P24,-1)<=Q24),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q25=\"\",\"\",IF(AND(EDATE(P25,1)>=Q25,EDATE(P25,-1)<=Q25),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]

{"sheet":"HV6","index":8,"n_rows":47,"n_cols":115,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,27,9,31],[5,1,5,56],[6,1,6,56],[7,1,7,56],[8,1,8,56]]}
[null,"6-6.B ASQ Developmental Screening Tracking"]
[]
[null,"Instructions:  ","HFA requires a minimum of two valid screens per year until the age 3, and one per year thereafter. "]
[null,"Enter in yellow highlighted fields only"]
[null,"*There is enough space to enter data for 30 families for 6 HV's. If you require more space for data entry, please contact Amy: arussell@preventchildabuse.org*"]
[null,"The blue columns are automatically calculating the dates each ASQ is due; the \"Valid?\" columns automatically calculate whether the date completed was within a month (before or after)"]
[null," of the due date, the grey columns take those into account when calculating the total number of screens per year. If the target child has not reached their next birthday,"]
[null," that column will be marked \"N/A\". You will also notice there are embedded calculations specificying the percentage of children at each age who are meeting the 6-6.B requirements."]
[null,"For each new fiscal year, beging entering new ASQ screens starting July 1. However ALSO INCLUDE (enter) the last completed ASQ from the prior fiscal year."]
["Home Visitor"]
["Supervisor:"]
["Today's Date"]
["Highlight data from:",null,{"$f":"IF(ISBLANK(C12),\"\",EDATE(C12, -6))","v":""}]
["# Target Children",null,{"$f":"COUNTA(A17:A43)","v":0}]
["Percentage Meeting Requirements",null,null,null,null,{"$f":"COUNTIF(F17:F47,\">=2\")/COUNTIF(F17:F47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G17:G47,\">=2\")/COUNTIF(G17:G47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(H17:H47,\">=2\")/COUNTIF(H17:H47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(I17:I47,\">=1\")/COUNTIF(I17:I47,\">=0\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J17:J47,\">=1\")/COUNTIF(J17:J47,\">=0\")","v":{"$error":"#DIV/0!"}}]
["Family ID","Adjusted DOB*","Actual DOB","Receives Early Intervention?","Date Early Invervention Began","Year One Number of Screens","Year Two Number of Screens","Year Three Number of Screens","Year Four Number of Screens","Year Five Number of Screens","2 Month","2 Month Complete","Valid?","Result","Action","4 Month","4 Month Complete","Valid?","Result","Action","6 Month","6 Month Complete","Valid?","Result","Action","8 Month","8 Month Complete","Valid?","Result","Action","9 Month","9 Month Complete","Valid?","Result","Action","10 Month ","10 Month Complete","Valid?","Result","Action","12 Month ","12 Month Complete","Valid?","Result","Action","14 Month ","14 Month Complete","Valid?","Result","Action","16 Month ","16 Month Complete","Valid?","Result","Action","18 Month ","18 Month Complete","Valid?","Result","Action","20 Month ","20 Month Complete","Valid?","Result","Action","22 Month ","22 Month Complete","Valid?","Result","Action","24 Month ","24 Month Complete","Valid?","Result","Action","27 Month ","27 Month Complete","Valid?","Result","Action","30 Month ","30 Month Complete","Valid?","Result","Action","33 Month ","33 Month Complete","Valid?","Result","Action","36 Month ","36 Month Complete","Valid?","Result","Action","42 Month","42 Month Complete","Valid?","Result","Action","48 Month ","48 Month Complete","Valid?","Result","Action","54 Month ","54 Month Complete","Valid?","Result","Action","60 Month ","60 Month Complete","Valid?","Result","Action"]
[null,null,null,null,null,{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,12)>C$12,IF((COUNTIF(M17:AQ17,\"Yes\"))>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",\"N/A\")),IF(COUNTIF(M17:AQ17,\"Yes\")>=2,COUNTIF(M17:AQ17,\"Yes\"),IF(AND(D17=\"Yes\",E17<AO17),\"EI\",COUNTIF(M17:AQ17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,24)>C$12,IF((COUNTIF(AV17:BU17,\"Yes\"))>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",\"N/A\")),IF(COUNTIF(AV17:BU17,\"Yes\")>=2,COUNTIF(AV17:BU17,\"Yes\"),IF(AND(D17=\"Yes\",E17<BS17),\"EI\",COUNTIF(AV17:BU17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,36)>C$12,IF((COUNTIF(BZ17:CO17,\"Yes\"))>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",\"N/A\")),IF(COUNTIF(BZ17:CO17,\"Yes\")>=2,COUNTIF(BZ17:CO17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CM17),\"EI\",COUNTIF(BZ17:CO17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,48)>C$12,IF((COUNTIF(CT17:DB17,\"Yes\"))>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",\"N/A\")),IF(COUNTIF(CT17:DB17,\"Yes\")>=1,COUNTIF(CT17:DB17,\"Yes\"),IF(AND(D17=\"Yes\",E17<CW17),\"EI\",COUNTIF(CT17:DB17,\"Yes\")))))","v":"N/A"},{"$f":"IF(C17=\"\",\"N/A\",IF(EDATE(C17,60)>C$12,IF((COUNTIF(DD17:DI17,\"Yes\"))>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",\"N/A\")),IF(COUNTIF(DD17:DI17,\"Yes\")>=1,COUNTIF(DD17:DI17,\"Yes\"),IF(AND(D17=\"Yes\",E17<DG17),\"EI\",COUNTIF(DD17:DI17,\"Yes\")))))","v":"N/A"},{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,2)),(EDATE(B17,2)))","v":""},null,{"$f":"IF(L17=\"\",\"\",IF(AND(EDATE(K17,1)>=L17,EDATE(K17,-1)<=L17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,4)),(EDATE(B17,4)))","v":""},null,{"$f":"IF(Q17=\"\",\"\",IF(AND(EDATE(P17,1)>=Q17,EDATE(P17,-1)<=Q17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,6)),(EDATE(B17,6)))","v":""},null,{"$f":"IF(V17=\"\",\"\",IF(AND(EDATE(U17,1)>=V17,EDATE(U17,-1)<=V17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,8)),(EDATE(B17,8)))","v":""},null,{"$f":"IF(AA17=\"\",\"\",IF(AND(EDATE(Z17,1)>=AA17,EDATE(Z17,-1)<=AA17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,9)),(EDATE(B17,9)))","v":""},null,{"$f":"IF(AF17=\"\",\"\",IF(EDATE(AE17,1)>=AF17,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,10)),(EDATE(B17,10)))","v":""},null,{"$f":"IF(AK17=\"\",\"\",IF(AND(EDATE(AJ17,1)>=AK17,EDATE(AJ17,-1)<=AK17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,12)),(EDATE(B17,12)))","v":""},null,{"$f":"IF(AP17=\"\",\"\",IF(AND(EDATE(AO17,1)>=AP17,EDATE(AO17,-1)<=AP17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,14)),(EDATE(B17,14)))","v":""},null,{"$f":"IF(AU17=\"\",\"\",IF(AND(EDATE(AT17,1)>=AU17,EDATE(AT17,-1)<=AU17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,16)),(EDATE(B17,16)))","v":""},null,{"$f":"IF(AZ17=\"\",\"\",IF(AND(EDATE(AY17,1)>=AZ17,EDATE(AY17,-1)<=AZ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,18)),(EDATE(B17,18)))","v":""},null,{"$f":"IF(BE17=\"\",\"\",IF(AND(EDATE(BD17,1)>=BE17,EDATE(BD17,-1)<=BE17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,20)),(EDATE(B17,20)))","v":""},null,{"$f":"IF(BJ17=\"\",\"\",IF(AND(EDATE(BI17,1)>=BJ17,EDATE(BI17,-1)<=BJ17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,22)),(EDATE(B17,22)))","v":""},null,{"$f":"IF(BO17=\"\",\"\",IF(AND(EDATE(BN17,1)>=BO17,EDATE(BN17,-1)<=BO17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B17),IF(ISBLANK(C17),\"\",EDATE(C17,24)),(EDATE(B17,24)))","v":""},null,{"$f":"IF(BT17=\"\",\"\",IF(AND(EDATE(BS17,-1)<=BT17,(BS17+45)>=BT17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,27)))","v":""},null,{"$f":"IF(BY17=\"\",\"\",IF(AND((BX17+45)>=BY17,(BX17-45)<=BY17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,30)))","v":""},null,{"$f":"IF(CD17=\"\",\"\",IF(AND((CC17+45)>=CD17,(CC17-45)<=CD17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,33)))","v":""},null,{"$f":"IF(CI17=\"\",\"\",IF(AND((CH17+45)>=CI17,(CH17-45)<=CI17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,36)))","v":""},null,{"$f":"IF(CN17=\"\",\"\",IF(AND(EDATE(CM17,3)>=CN17,(CM17-45)<=CN17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,42)))","v":""},null,{"$f":"IF(CS17=\"\",\"\",IF(AND(EDATE(CR17,3)>=CS17,EDATE(CR17,-3)<=CS17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,48)))","v":""},null,{"$f":"IF(CX17=\"\",\"\",IF(AND(EDATE(CW17,3)>=CX17,EDATE(CW17,-3)<=CX17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,54)))","v":""},null,{"$f":"IF(DC17=\"\",\"\",IF(AND(EDATE(DB17,3)>=DC17,EDATE(DB17,-3)<=DC17),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C17),\"\",(EDATE(C17,60)))","v":""},null,{"$f":"IF(DH17=\"\",\"\",IF(AND(EDATE(DG17,6)>=DH17,EDATE(DG17,-3)<=DH17),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,2)),(EDATE(B18,2)))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(AND(EDATE(K18,1)>=L18,EDATE(K18,-1)<=L18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,4)),(EDATE(B18,4)))","v":""},null,{"$f":"IF(Q18=\"\",\"\",IF(AND(EDATE(P18,1)>=Q18,EDATE(P18,-1)<=Q18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,6)),(EDATE(B18,6)))","v":""},null,{"$f":"IF(V18=\"\",\"\",IF(AND(EDATE(U18,1)>=V18,EDATE(U18,-1)<=V18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,8)),(EDATE(B18,8)))","v":""},null,{"$f":"IF(AA18=\"\",\"\",IF(AND(EDATE(Z18,1)>=AA18,EDATE(Z18,-1)<=AA18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,9)),(EDATE(B18,9)))","v":""},null,{"$f":"IF(AF18=\"\",\"\",IF(EDATE(AE18,1)>=AF18,\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,10)),(EDATE(B18,10)))","v":""},null,{"$f":"IF(AK18=\"\",\"\",IF(AND(EDATE(AJ18,1)>=AK18,EDATE(AJ18,-1)<=AK18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,12)),(EDATE(B18,12)))","v":""},null,{"$f":"IF(AP18=\"\",\"\",IF(AND(EDATE(AO18,1)>=AP18,EDATE(AO18,-1)<=AP18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,14)),(EDATE(B18,14)))","v":""},null,{"$f":"IF(AU18=\"\",\"\",IF(AND(EDATE(AT18,1)>=AU18,EDATE(AT18,-1)<=AU18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,16)),(EDATE(B18,16)))","v":""},null,{"$f":"IF(AZ18=\"\",\"\",IF(AND(EDATE(AY18,1)>=AZ18,EDATE(AY18,-1)<=AZ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,18)),(EDATE(B18,18)))","v":""},null,{"$f":"IF(BE18=\"\",\"\",IF(AND(EDATE(BD18,1)>=BE18,EDATE(BD18,-1)<=BE18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,20)),(EDATE(B18,20)))","v":""},null,{"$f":"IF(BJ18=\"\",\"\",IF(AND(EDATE(BI18,1)>=BJ18,EDATE(BI18,-1)<=BJ18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,22)),(EDATE(B18,22)))","v":""},null,{"$f":"IF(BO18=\"\",\"\",IF(AND(EDATE(BN18,1)>=BO18,EDATE(BN18,-1)<=BO18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(B18),IF(ISBLANK(C18),\"\",EDATE(C18,24)),(EDATE(B18,24)))","v":""},null,{"$f":"IF(BT18=\"\",\"\",IF(AND(EDATE(BS18,-1)<=BT18,(BS18+45)>=BT18),\"Yes\",\"No\"))","v":""},null,null,{"$f":"IF(ISBLANK(C18),\"\",(EDATE(C18,27)))","v":""},null,{"$f":"IF(BY18=\"\",\"\",IF(AND((BX18+45)>=BY18,(BX18-45)<=BY18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CD18=\"\",\"\",IF(AND((CC18+45)>=CD18,(CC18-45)<=CD18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CI18=\"\",\"\",IF(AND((CH18+45)>=CI18,(CH18-45)<=CI18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CN18=\"\",\"\",IF(AND(EDATE(CM18,3)>=CN18,(CM18-45)<=CN18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CS18=\"\",\"\",IF(AND(EDATE(CR18,3)>=CS18,EDATE(CR18,-3)<=CS18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(CX18=\"\",\"\",IF(AND(EDATE(CW18,3)>=CX18,EDATE(CW18,-3)<=CX18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DC18=\"\",\"\",IF(AND(EDATE(DB18,3)>=DC18,EDATE(DB18,-3)<=DC18),\"Yes\",\"No\"))","v":""},null,null,"",null,{"$f":"IF(DH18=\"\",\"\",IF(AND(EDATE(DG18,6)>=DH18,EDATE(DG18,-3)<=DH18),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q24=\"\",\"\",IF(AND(EDATE(P24,1)>=Q24,EDATE(P24,-1)<=Q24),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/A","",null,"",null,null,"",null,{"$f":"IF(Q25=\"\",\"\",IF(AND(EDATE(P25,1)>=Q25,EDATE(P25,-1)<=Q25),\"Yes\",\"No\"))","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,"",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,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]
[null,null,null,null,null,"N/A","N/A","N/A","N/A","N/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,"",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,"",null,"",null,null,"",null,""]