{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intructions","FSW#1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Intructions","index":0,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[16,0,16,8],[15,0,15,8],[10,0,10,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[28,0,28,8],[29,0,29,8]]}
["Tickler/Ticket Report"]
["Instructions for Use"]
[]
["To Enter Tools"]
["* Enter the date the tool was completed in the Admin Date column"]
["* If the tool was due but not completed, the OnTime? column will display \"Incomplete\""]
["* If the tool was completed within the expected timeframe, the OnTime? column will display \"Yes\""]
["* If the tool was completed outside the expected timeframe, the OnTime? column will display \"No\""]
["* If the tool was excused (e.g. the family is on Level X and the tool could not be completed), enter \"Missed\" in the Admin Date column. The OnTime? column will display \"Missed\". The tool is still counted as not completed for the completion calculations but is distinguished from tools that were forgotten or accidentally missed."]
[]
["To Add A New Family:"]
["* Click the Add Client Rows button. The macro will insert 44 new rows and copy the Tool and Time Frame columns."]
["* Enter Name and ID# in the first row of the new client. Copy the information down to fill all 44 rows."]
["* Enter the BA's DOB and Enrollment Date information. Copy the information down to fill all 44 rows. (Make sure to copy, instead of fill. Filling will result in the dates increasing as it fills down.)"]
[]
["To Run a Tickler Report (tools that are due)"]
["* Enter the start and end dates of the desired time frame in Row 1. "]
["* Enter the month/range in Row 6."]
["* Filter the Due? column to show only \"Yes\" "]
["* Press the Tickler (Due) button. This will hide the columns that aren't needed and the Tickler Report can be printed."]
["* Press the Show All Columns button when finished to unhide all columns"]
["* Un-filter the Due? column to show all rows"]
[]
["To Run a Ticket Report (tools that have been completed)"]
["* Enter the start and end dates of the desired time frame in Row 1. "]
["* Enter the month/range in Row 6."]
["* Filter the Due? column to show only \"Yes\" "]
["* Press the Ticket (Done) button. This will hide the columns that aren't needed and the Ticket Report can be printed."]
["* Press the Show All Columns button when finished to unhide all columns"]
["* Un-filter the Due? column to show all rows"]

{"sheet":"FSW#1","index":1,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,3,4,4],[5,3,5,4]]}
[null,null,null,null,"Healthy Families Rappahannock Area",null,null,null,null,"Start Date:","2017-02-01","End Date:","2017-03-31"]
[null,null,null,null,"Tools Due Tickler",null,null,null,null,"Today:",{"$f":"TODAY()","v":"2017-03-01"}]
[null,null,null,null,"Tools Completed Ticket"]
[]
[null,null,"FSW:","FSW#1"]
[null,null,"Month:","2017-02-01"]
[]
[null,null,null,null,null,null,null,null,null,"Missed:",{"$f":"COUNTIFS(CarmenLopez[Due?],\"yes\",CarmenLopez[OnTime?],\"missed\")","v":0}]
["Tools Due:",{"$f":"COUNTIF(CarmenLopez[Due?],\"yes\")","v":5},null,null,null,"All","Minus Level X"]
["Tools Completed:",{"$f":"COUNTIFS(CarmenLopez[Due?],\"yes\",CarmenLopez[OnTime?],\"yes\")+COUNTIFS(CarmenLopez[Due?],\"yes\",CarmenLopez[OnTime?],\"no\")","v":0},null,"Completion Rate:",null,{"$f":"B10/B9","v":0},{"$f":"B10/(B9-B12)","v":0}]
["Completed On Time:",{"$f":"COUNTIFS(CarmenLopez[Due?],\"yes\",CarmenLopez[OnTime?],\"yes\")","v":0},null,"On-Time Completion Rate:",null,{"$f":"B11/B9","v":0},{"$f":"B11/(B9-B12)","v":0}]
["Level X Tools Due:",{"$f":"COUNTIFS(CarmenLopez[Due?],\"yes\",CarmenLopez[Level X],\"yes\")","v":0},null,"Missing Tools Forms:",null,{"$f":"K8","v":0}]
[]
["Name","ID #","Tool","Time Frame","Due Date","Admin Date","OnTime?","Done?","Turned In?","BA's DOB","Enrollment Date","Due?","Level X"]
["Jane Doe",1234,"Medical",1,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-02-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E15>=Start,E15<=End),IF(F15=\"\",\"Incomplete\",IF(AND(F15<EDATE(E15,1),F15>EDATE(E15,-1)),\"Yes\",\"No\")),\"-\"))","v":"Incomplete"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"Yes"}]
["Jane Doe",1234,"Medical",2,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-03-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E16>=Start,E16<=End),IF(F16=\"\",\"Incomplete\",IF(AND(F16<EDATE(E16,1),F16>EDATE(E16,-1)),\"Yes\",\"No\")),\"-\"))","v":"Incomplete"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"Yes"}]
["Jane Doe",1234,"Medical",4,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-05-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E17>=Start,E17<=End),IF(F17=\"\",\"Incomplete\",IF(AND(F17<EDATE(E17,1),F17>EDATE(E17,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",6,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-07-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E18>=Start,E18<=End),IF(F18=\"\",\"Incomplete\",IF(AND(F18<EDATE(E18,1),F18>EDATE(E18,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",9,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-10-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E19>=Start,E19<=End),IF(F19=\"\",\"Incomplete\",IF(AND(F19<EDATE(E19,1),F19>EDATE(E19,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",12,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E20>=Start,E20<=End),IF(F20=\"\",\"Incomplete\",IF(AND(F20<EDATE(E20,1),F20>EDATE(E20,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",15,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-04-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E21>=Start,E21<=End),IF(F21=\"\",\"Incomplete\",IF(AND(F21<EDATE(E21,1),F21>EDATE(E21,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",18,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-07-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E22>=Start,E22<=End),IF(F22=\"\",\"Incomplete\",IF(AND(F22<EDATE(E22,1),F22>EDATE(E22,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",24,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2019-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E23>=Start,E23<=End),IF(F23=\"\",\"Incomplete\",IF(AND(F23<EDATE(E23,1),F23>EDATE(E23,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",36,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2020-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E24>=Start,E24<=End),IF(F24=\"\",\"Incomplete\",IF(AND(F24<EDATE(E24,1),F24>EDATE(E24,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",48,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2021-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E25>=Start,E25<=End),IF(F25=\"\",\"Incomplete\",IF(AND(F25<EDATE(E25,1),F25>EDATE(E25,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Medical",60,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2022-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E26>=Start,E26<=End),IF(F26=\"\",\"Incomplete\",IF(AND(F26<EDATE(E26,1),F26>EDATE(E26,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",4,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-05-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E27>=Start,E27<=End),IF(F27=\"\",\"Incomplete\",IF(AND(F27<EDATE(E27,1),F27>EDATE(E27,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",6,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-07-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E28>=Start,E28<=End),IF(F28=\"\",\"Incomplete\",IF(AND(F28<EDATE(E28,1),F28>EDATE(E28,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",9,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-10-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E29>=Start,E29<=End),IF(F29=\"\",\"Incomplete\",IF(AND(F29<EDATE(E29,1),F29>EDATE(E29,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",12,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E30>=Start,E30<=End),IF(F30=\"\",\"Incomplete\",IF(AND(F30<EDATE(E30,1),F30>EDATE(E30,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",16,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-05-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E31>=Start,E31<=End),IF(F31=\"\",\"Incomplete\",IF(AND(F31<EDATE(E31,1),F31>EDATE(E31,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",20,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-09-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E32>=Start,E32<=End),IF(F32=\"\",\"Incomplete\",IF(AND(F32<EDATE(E32,1),F32>EDATE(E32,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",24,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2019-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E33>=Start,E33<=End),IF(F33=\"\",\"Incomplete\",IF(AND(F33<EDATE(E33,1),F33>EDATE(E33,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",30,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2019-07-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E34>=Start,E34<=End),IF(F34=\"\",\"Incomplete\",IF(AND(F34<EDATE(E34,1),F34>EDATE(E34,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",36,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2020-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E35>=Start,E35<=End),IF(F35=\"\",\"Incomplete\",IF(AND(F35<EDATE(E35,1),F35>EDATE(E35,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"ASQ",48,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2021-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E36>=Start,E36<=End),IF(F36=\"\",\"Incomplete\",IF(AND(F36<EDATE(E36,1),F36>EDATE(E36,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",4,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-05-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E37>=Start,E37<=End),IF(F37=\"\",\"Incomplete\",IF(AND(F37<EDATE(E37,1),F37>EDATE(E37,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",6,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-07-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E38>=Start,E38<=End),IF(F38=\"\",\"Incomplete\",IF(AND(F38<EDATE(E38,1),F38>EDATE(E38,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",12,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E39>=Start,E39<=End),IF(F39=\"\",\"Incomplete\",IF(AND(F39<EDATE(E39,1),F39>EDATE(E39,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",24,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2019-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E40>=Start,E40<=End),IF(F40=\"\",\"Incomplete\",IF(AND(F40<EDATE(E40,1),F40>EDATE(E40,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",36,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2020-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E41>=Start,E41<=End),IF(F41=\"\",\"Incomplete\",IF(AND(F41<EDATE(E41,1),F41>EDATE(E41,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",48,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2021-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E42>=Start,E42<=End),IF(F42=\"\",\"Incomplete\",IF(AND(F42<EDATE(E42,1),F42>EDATE(E42,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PICCOLO",60,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2022-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E43>=Start,E43<=End),IF(F43=\"\",\"Incomplete\",IF(AND(F43<EDATE(E43,1),F43>EDATE(E43,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"HOME",2,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-03-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E44>=Start,E44<=End),IF(F44=\"\",\"Incomplete\",IF(AND(F44<EDATE(E44,1),F44>EDATE(E44,-1)),\"Yes\",\"No\")),\"-\"))","v":"Incomplete"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"Yes"}]
["Jane Doe",1234,"HOME",6,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-07-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E45>=Start,E45<=End),IF(F45=\"\",\"Incomplete\",IF(AND(F45<EDATE(E45,1),F45>EDATE(E45,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"HOME",12,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E46>=Start,E46<=End),IF(F46=\"\",\"Incomplete\",IF(AND(F46<EDATE(E46,1),F46>EDATE(E46,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"HOME",24,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2019-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E47>=Start,E47<=End),IF(F47=\"\",\"Incomplete\",IF(AND(F47<EDATE(E47,1),F47>EDATE(E47,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"HOME",36,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2020-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E48>=Start,E48<=End),IF(F48=\"\",\"Incomplete\",IF(AND(F48<EDATE(E48,1),F48>EDATE(E48,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"HOME",48,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2021-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E49>=Start,E49<=End),IF(F49=\"\",\"Incomplete\",IF(AND(F49<EDATE(E49,1),F49>EDATE(E49,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"HOME",60,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2022-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E50>=Start,E50<=End),IF(F50=\"\",\"Incomplete\",IF(AND(F50<EDATE(E50,1),F50>EDATE(E50,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Safety",9,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-10-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E51>=Start,E51<=End),IF(F51=\"\",\"Incomplete\",IF(AND(F51<EDATE(E51,1),F51>EDATE(E51,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Safety",12,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2018-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E52>=Start,E52<=End),IF(F52=\"\",\"Incomplete\",IF(AND(F52<EDATE(E52,1),F52>EDATE(E52,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Safety",24,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2019-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E53>=Start,E53<=End),IF(F53=\"\",\"Incomplete\",IF(AND(F53<EDATE(E53,1),F53>EDATE(E53,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Safety",36,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2020-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E54>=Start,E54<=End),IF(F54=\"\",\"Incomplete\",IF(AND(F54<EDATE(E54,1),F54>EDATE(E54,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Safety",48,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2021-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E55>=Start,E55<=End),IF(F55=\"\",\"Incomplete\",IF(AND(F55<EDATE(E55,1),F55>EDATE(E55,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"Safety",60,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2022-01-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E56>=Start,E56<=End),IF(F56=\"\",\"Incomplete\",IF(AND(F56<EDATE(E56,1),F56>EDATE(E56,-1)),\"Yes\",\"No\")),\"-\"))","v":"-"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"-"}]
["Jane Doe",1234,"PHQ9-Pre",1,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-03-02"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E57>=Start,E57<=End),IF(F57=\"\",\"Incomplete\",IF(AND(F57<EDATE(E57,1),F57>EDATE(E57,-1)),\"Yes\",\"No\")),\"-\"))","v":"Incomplete"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"Yes"}]
["Jane Doe",1234,"PHQ9",2,{"$f":"IF(CarmenLopez[[#This Row],[Time Frame]]=\"N/A\",\"N/A\",IF(CarmenLopez[[#This Row],[Tool]]=\"PHQ9-Pre\",EDATE(CarmenLopez[[#This Row],[Enrollment Date]],CarmenLopez[[#This Row],[Time Frame]]),IF(CarmenLopez[[#This Row],[BA''s DOB]]=\"pre\",\"N/A\",EDATE(CarmenLopez[[#This Row],[BA''s DOB]],CarmenLopez[[#This Row],[Time Frame]]))))","v":"2017-03-01"},null,{"$f":"IF(CarmenLopez[[#This Row],[Admin Date]]=\"missed\",\"Missed\",IF(AND(E58>=Start,E58<=End),IF(F58=\"\",\"Incomplete\",IF(AND(F58<EDATE(E58,1),F58>EDATE(E58,-1)),\"Yes\",\"No\")),\"-\"))","v":"Incomplete"},"¨","¨","2017-01-01","2017-02-02",{"$f":"IF(AND(CarmenLopez[[#This Row],[Due Date]]>=Start,CarmenLopez[[#This Row],[Due Date]]<=End),\"Yes\",\"-\")","v":"Yes"}]