{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ACTION ITEMS","Month View","Week View","ACTIVITIES"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":28,"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":"ACTION ITEMS","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,3,2]]}
[]
[]
[]
[]
[null,"ACTIVITIES","MONTH VIEW","WEEK VIEW"]
[null,"ACTION ITEMS"]
[null,"TO DO ITEMS","DEADLINES THIS MONTH","NOTES","PROJECT","MONTH","YEAR"]
[null,"Internal Operations Example Language\nConference Example Language","Internal Operations Sample Deadline - 8/11/2023\nSample Conference - 8/25/2023","Sample Notes","Project 1","AUGUST",2023]
[null,"Sample Item 1",null,"Additional Notes","Project 2","AUGUST",2023]
[null,"Sample Item 1",null,"More Notes","Project 3","AUGUST",2023]
[null,"Sample Item 1",null,"More Sample Notes","Project 4","AUGUST",2023]
[null,"Sample Item 1","Training Workshop Deadline - 8/25/2023","More Sample Notes","Project 5","AUGUST",2023]

{"sheet":"Month View","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,3,4]]}
[]
[]
[]
[]
[null,"ACTION ITEMS","ACTIVITIES","WEEK VIEW"]
[null,"Select Month:","Enter Year:"]
[null,"August",2023]
[null," MONTH VIEW"]
[null,"SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"IF(WEEKDAY(DATEVALUE(MoMonth&\" 1, \"&MoYear))=COLUMN(A$6),1,IF(LEN(A10)>0,A10+1,\"\"))","v":""},{"$f":"IF(WEEKDAY(DATEVALUE(MoMonth&\" 1, \"&MoYear))=COLUMN(B$6),1,IF(LEN(B10)>0,B10+1,\"\"))","v":""},1,2,3,4,5]
[null,{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(B10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H10&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""}]
[null,{"$f":"IF(LEN(H10)>0,IF(H10=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H10+1),\"\")","v":6},{"$f":"IF(LEN(B12)>0,IF(B12=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B12+1),\"\")","v":7},8,9,10,11,12]
[null,{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(B12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":"This is a sample item from the Activities Tab"},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H12&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""}]
[null,{"$f":"IF(LEN(H12)>0,IF(H12=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H12+1),\"\")","v":13},{"$f":"IF(LEN(B14)>0,IF(B14=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B14+1),\"\")","v":14},15,16,17,18,19]
[null,{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(B14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H14&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""}]
[null,{"$f":"IF(LEN(H14)>0,IF(H14=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H14+1),\"\")","v":20},{"$f":"IF(LEN(B16)>0,IF(B16=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B16+1),\"\")","v":21},22,23,24,25,26]
[null,{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(B16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":"This is another different sample item"},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":"Yet another sample activity"},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H16&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""}]
[null,{"$f":"IF(LEN(H16)>0,IF(H16=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H16+1),\"\")","v":27},{"$f":"IF(LEN(B18)>0,IF(B18=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B18+1),\"\")","v":28},29,30,31,"",""]
[null,"",{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C18&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D18&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E18&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F18&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G18&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H18&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""}]
[null,{"$f":"IF(LEN(H18)>0,IF(H18=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H18+1),\"\")","v":""},{"$f":"IF(LEN(B20)>0,IF(B20=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B20+1),\"\")","v":""},"","","","",""]
[null,{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(B20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H20&\"-\"&MoMonth&\"-\"&MoYear)),\"\")),\"\")","v":""}]

{"sheet":"Week View","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,3,4]]}
[]
[]
[]
[]
[null,"ACTION ITEMS","ACTIVITIES","MONTH VIEW"]
[null,"Select month:","Enter year:","Select week #:"]
[null,"August",{"$f":"YEAR(TODAY())","v":2023},"Week 4"]
[null," WEEK VIEW"]
[null,{"$f":"IF(WEEKDAY(DATEVALUE(WkMonth&\" 1, \"&WkYear))=COLUMN(A$6),1,IF(LEN(A9)>0,A9+1,\"\"))","v":""},"",1,2,3,4,5]
[null,{"$f":"IF(LEN(H9)>0,IF(H9=LastDayOfMonth_Week,\"\",H9+1),\"\")","v":6},{"$f":"IF(LEN(B10)>0,IF(B10=LastDayOfMonth_Week,\"\",B10+1),\"\")","v":7},8,9,10,11,12]
[null,{"$f":"IF(LEN(H10)>0,IF(H10=LastDayOfMonth_Week,\"\",H10+1),\"\")","v":13},14,15,16,17,18,19]
[null,{"$f":"IF(LEN(H11)>0,IF(H11=LastDayOfMonth_Week,\"\",H11+1),\"\")","v":20},21,22,23,24,25,26]
[null,{"$f":"IF(LEN(H12)>0,IF(H12=LastDayOfMonth_Week,\"\",H12+1),\"\")","v":27},28,29,30,31,"",""]
[null,{"$f":"IF(LEN(H13)>0,IF(H13=LastDayOfMonth_Week,\"\",H13+1),\"\")","v":""},"","","","","",""]
[null,"SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,{"$f":"IF(B18=\"\",IF(AND(ISNUMBER(A16),A16<LastDayOfMonth_Week),A16+1,\"\"),IF(B18<=7,\"\",INDEX(WkMonthView,WkWeek,COLUMN(A$6))-7))","v":13},14,15,16,17,18,19]
[null,{"$f":"IF(LEN(B16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,B16))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(C16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,C16))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(D16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,D16))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(E16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,E16))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(F16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,F16))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(G16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,G16))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(H16)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,H16))>0,\"Activity Deadline\",\"\"))","v":""}]
[null,{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(A$6))","v":20},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(B$6))","v":21},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(C$6))","v":22},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(D$6))","v":23},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(E$6))","v":24},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(F$6))","v":25},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(G$6))","v":26}]
[null,{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(B18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(C18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(D18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(E18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":"This is another different sample item"},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(F18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":""},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(G18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":"Yet another sample activity"},{"$f":"IFERROR(_xlfn.TEXTJOIN(REPT(CHAR(10),2),TRUE,_xlfn._xlws.FILTER(Assignments[[ITEM]:[ITEM]],Assignments[[DUE DATE]:[DUE DATE]]=(DATEVALUE(H18&\"-\"&WkMonth&\"-\"&WkYear)),\"\")),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(B18=\"\",IF(AND(ISNUMBER(A20),A20<LastDayOfMonth_Week),A20+1,$H$18+COLUMN(A$6)),IF(B18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(A$6))+7)),\"\")","v":27},{"$f":"IFERROR(IF(C18=\"\",IF(AND(ISNUMBER(B20),B20<LastDayOfMonth_Week),B20+1,$H$18+COLUMN(B$6)),IF(C18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(B$6))+7)),\"\")","v":28},{"$f":"IFERROR(IF(D18=\"\",IF(AND(ISNUMBER(C20),C20<LastDayOfMonth_Week),C20+1,$H$18+COLUMN(C$6)),IF(D18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(C$6))+7)),\"\")","v":29},{"$f":"IFERROR(IF(E18=\"\",IF(AND(ISNUMBER(D20),D20<LastDayOfMonth_Week),D20+1,$H$18+COLUMN(D$6)),IF(E18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(D$6))+7)),\"\")","v":30},{"$f":"IFERROR(IF(F18=\"\",IF(AND(ISNUMBER(E20),E20<LastDayOfMonth_Week),E20+1,$H$18+COLUMN(E$6)),IF(F18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(E$6))+7)),\"\")","v":31},{"$f":"IFERROR(IF(G18=\"\",IF(AND(ISNUMBER(F20),F20<LastDayOfMonth_Week),F20+1,$H$18+COLUMN(F$6)),IF(G18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(F$6))+7)),\"\")","v":""},{"$f":"IFERROR(IF(H18=\"\",IF(AND(ISNUMBER(G20),G20<LastDayOfMonth_Week),G20+1,$H$18+COLUMN(G$6)),IF(H18+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(G$6))+7)),\"\")","v":""}]
[null,{"$f":"IF(LEN(B20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,B20))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(C20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,C20))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(D20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,D20))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(E20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,E20))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(F20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,F20))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(G20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,G20))>0,\"Activity Deadline\",\"\"))","v":""},{"$f":"IF(LEN(H20)=0,\"\",IF(COUNTIF(Assignments[TIMELINE],DATE(WkYear,WkMonthNum,H20))>0,\"Activity Deadline\",\"\"))","v":""}]

{"sheet":"ACTIVITIES","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,9,2,9],[0,0,7,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8]]}
[]
[null,null,null,null,"ALL PROJECTS","Project 1","Project 2","Project 3","Project 4","Project 5"]
[]
[]
[]
[null,null,null,null,"ALL LANES OF WORK","CONFERENCES","WORKSHOPS/TRAININGS","TRAVEL","INTERNAL OPERATIONS","PERSONNEL"]
[null,null,null,null,"ALL TIMELINES","Fall 2023 (Before 9/30/2023)","Fall 2023 (After 10/1/2023)","Spring 2024","Fall 2024 (Before 9/30/2024)","Communications | Show ALL"]
[]
[null,"ACTION ITEMS","MONTH VIEW","WEEK VIEW"]
[null,"ACTIVITIES"]
[null,"ITEM","TIMELINE","DUE DATE","LANE OF WORK","STATUS","PROJECT","LEAD","NOTES","COMMUNICATIONS"]
[null,"This is a sample item from the Activities Tab","Fall 2023 (Before 9/30/2023)","2023-08-11","Internal Operations","Completed","Project 1","Person 1"]
[null,"This is another different sample item","Fall 2023 (Before 9/30/2023)","2023-08-23","Workshop/Training","Completed","Project 5","Person 5",null,"Email flier to districts"]
[null,"Yet another sample activity","Fall 2023 (Before 9/30/2023)","2023-08-25","Conference","Completed","Project 1","Person 1",null,"Social Media Support, Event Photos, Press Release"]
[null,"Sample item","Fall 2023 (After 10/1/2023)","2023-10-02","Out of State Travel","In Progress","Project 3","Person 3"]
[null,"Sample item","Spring 2024","2024-03-05","In-State Travel","Not Started","Project 2","Person 2"]
[null,"Sample item","Fall 2024 (Before 9/30/2024)","2024-08-28","Conference","Not Started","Project 4","Person 4"]
[null,"Yet again - another sample activity","Fall 2024 (Before 9/30/2024)","2024-09-02","Personnel","Not Started","Project 4","Person 4"]