{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cases"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Cases","index":0,"n_rows":26,"n_cols":24,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,8,0,14],[9,8,9,14],[18,8,18,14],[0,17,0,23],[9,17,9,23],[18,17,18,23]]}
["PK","Client","Case","Deadline","Progress","Time Spent",null,"Wk",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2017-11-01"},null,null,null,null,null,null,null,"Wk",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+3,1)","v":"2018-02-01"}]
[1,"Reddit","Post on /r/excel","2017-11-15","Right-Click here to expand this cell\nAdd examples in this sheet\r\nHost on personal website\r\nMake code publicly available\r\nThink of a good title\r\nAdd short explanation\nRight-Click again to go back to normal row height",null,null,null,{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3)))","v":43052},{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3))+1)","v":43053},{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3))+2)","v":43054},{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3))+3)","v":43055},{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3))+4)","v":43056},{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3))+5)","v":43057},{"$f":"DATE(YEAR(I1),MONTH(I1),DAY(TODAY()-WEEKDAY(TODAY(),3))+6)","v":43058},null,null,{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3)))","v":43144},{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3))+1)","v":43145},{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3))+2)","v":43146},{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3))+3)","v":43147},{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3))+4)","v":43148},{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3))+5)","v":43149},{"$f":"DATE(YEAR(R1),MONTH(R1),DAY(TODAY()-WEEKDAY(TODAY(),3))+6)","v":43150}]
[4,"You","Explore this tool","2017-11-16","Track me! Double click to edit\r\nClick all the buttons!\r\nTrack your life to the fullest!\r\nTracking will automatically expand the cell\nGo into the code by hitting alt f11, don't be shy, play around for a bit\n",null,null,{"$f":"WEEKNUM(O3,2)","v":45},{"$f":"IF(J3=\"\",\"\",IF(DAY(J3)-1>0,J3-1,\"\"))","v":""},"","2017-11-01","2017-11-02","2017-11-03","2017-11-04",{"$f":"I1+6-WEEKDAY(I1,3)","v":"2017-11-05"},null,{"$f":"WEEKNUM(X3,2)","v":5},{"$f":"IF(S3=\"\",\"\",IF(DAY(S3)-1>0,S3-1,\"\"))","v":""},"","","2018-02-01","2018-02-02","2018-02-03",{"$f":"R1+6-WEEKDAY(R1,3)","v":"2018-02-04"}]
[5,"You","Tips on Adding cases","2017-11-17","Use shift enter to add a line break in the dialog box\r\nIn regular cells it's alt enter\r\nYou can fill in as little or as much as you want\nYear and month are optional for the deadline, Excel will figure it out\nNew cases are sorted automatically according to the deadline",null,null,{"$f":"IF(I4=\"\",\"\",WEEKNUM(I4,2))","v":46},{"$f":"IF(O3=\"\",\"\",IF(DAY(O3)+1<DAY(DATE(YEAR(TODAY()),MONTH(O3)+1,0))+1,O3+1,\"\"))","v":"2017-11-06"},{"$f":"IF(I4=\"\",\"\",IF(DAY(I4)+1<DAY(DATE(YEAR(TODAY()),MONTH(I4)+1,0))+1,I4+1,\"\"))","v":"2017-11-07"},"2017-11-08","2017-11-09","2017-11-10","2017-11-11","2017-11-12",null,{"$f":"IF(R4=\"\",\"\",WEEKNUM(R4,2))","v":6},{"$f":"IF(X3=\"\",\"\",IF(DAY(X3)+1<DAY(DATE(YEAR(TODAY()),MONTH(X3)+1,0))+1,X3+1,\"\"))","v":"2018-02-05"},{"$f":"IF(R4=\"\",\"\",IF(DAY(R4)+1<DAY(DATE(YEAR(TODAY()),MONTH(R4)+1,0))+1,R4+1,\"\"))","v":"2018-02-06"},"2018-02-07","2018-02-08","2018-02-09","2018-02-10","2018-02-11"]
[6,"You","Tips on Tracking","2017-11-18","Tracking one case stops immediately when you track another case\nUsing the Stop Time button is optional\nTracking continues even when you exit the sheet\r\nIf you don't want this to happen either press Stop Time OR\r\nDive into the code and remove the comment under SaveandClose()\n('Call StopTime should become Call StopTime)",null,null,{"$f":"IF(I5=\"\",\"\",WEEKNUM(I5,2))","v":47},{"$f":"IF(O4=\"\",\"\",IF(DAY(O4)+1<DAY(DATE(YEAR(TODAY()),MONTH(O4)+1,0))+1,O4+1,\"\"))","v":"2017-11-13"},"2017-11-14","2017-11-15","2017-11-16","2017-11-17","2017-11-18","2017-11-19",null,{"$f":"IF(R5=\"\",\"\",WEEKNUM(R5,2))","v":7},{"$f":"IF(X4=\"\",\"\",IF(DAY(X4)+1<DAY(DATE(YEAR(TODAY()),MONTH(X4)+1,0))+1,X4+1,\"\"))","v":"2018-02-12"},"2018-02-13","2018-02-14","2018-02-15","2018-02-16","2018-02-17","2018-02-18"]
[7,"You","Tips on Conditional Formatting","2017-11-19","Be sure to explore the conditional formatting\r\nYou might want to add your own rules",null,null,{"$f":"IF(I6=\"\",\"\",WEEKNUM(I6,2))","v":48},{"$f":"IF(O5=\"\",\"\",IF(DAY(O5)+1<DAY(DATE(YEAR(TODAY()),MONTH(O5)+1,0))+1,O5+1,\"\"))","v":"2017-11-20"},"2017-11-21","2017-11-22","2017-11-23","2017-11-24","2017-11-25","2017-11-26",null,{"$f":"IF(R6=\"\",\"\",WEEKNUM(R6,2))","v":8},{"$f":"IF(X5=\"\",\"\",IF(DAY(X5)+1<DAY(DATE(YEAR(TODAY()),MONTH(X5)+1,0))+1,X5+1,\"\"))","v":"2018-02-19"},"2018-02-20","2018-02-21","2018-02-22","2018-02-23","2018-02-24","2018-02-25"]
[8,"You","Other Tips","2017-11-20","Saving happens whenever you exit the sheet, you don't get a message\r\nEdit the Sub SaveandClose if you want to change this behaviour\nYou can still track resolved cases, this is intentional\nIf you want resolved cases to dissapear completely,\nchange it in the code, you can use ClearContents\n(Google it if you don't know what this means)",null,null,{"$f":"IF(I7=\"\",\"\",WEEKNUM(I7,2))","v":49},{"$f":"IF(O6=\"\",\"\",IF(DAY(O6)+1<DAY(DATE(YEAR(TODAY()),MONTH(O6)+1,0))+1,O6+1,\"\"))","v":"2017-11-27"},"2017-11-28","2017-11-29","2017-11-30","","","",null,{"$f":"IF(R7=\"\",\"\",WEEKNUM(R7,2))","v":9},{"$f":"IF(X6=\"\",\"\",IF(DAY(X6)+1<DAY(DATE(YEAR(TODAY()),MONTH(X6)+1,0))+1,X6+1,\"\"))","v":"2018-02-26"},"2018-02-27","2018-02-28","","","",""]
[3,"Me","Get a girlfriend","2024-08-25","Waiting for a good oppurtinity\r\n'Waiting' will trigger the conditional formatting",6.9444444444444447E-4,null,{"$f":"IF(I8=\"\",\"\",WEEKNUM(I8,2))","v":""},{"$f":"IF(O7=\"\",\"\",IF(DAY(O7)+1<DAY(DATE(YEAR(TODAY()),MONTH(O7)+1,0))+1,O7+1,\"\"))","v":""},"","","","","","",null,{"$f":"IF(R8=\"\",\"\",WEEKNUM(R8,2))","v":""},{"$f":"IF(X7=\"\",\"\",IF(DAY(X7)+1<DAY(DATE(YEAR(TODAY()),MONTH(X7)+1,0))+1,X7+1,\"\"))","v":""},"","","","","",""]
[2,"Me","Create Time Tracker",null,"Case resolved on Tuesday 14/11/2017",0.41666666666666669]
[null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2017-12-01"},null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+4,1)","v":"2018-03-01"}]
[null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3)))","v":43082},{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3))+1)","v":43083},{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3))+2)","v":43084},{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3))+3)","v":43085},{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3))+4)","v":43086},{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3))+5)","v":43087},{"$f":"DATE(YEAR(I10),MONTH(I10),DAY(TODAY()-WEEKDAY(TODAY(),3))+6)","v":43088},null,null,{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3)))","v":43172},{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3))+1)","v":43173},{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3))+2)","v":43174},{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3))+3)","v":43175},{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3))+4)","v":43176},{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3))+5)","v":43177},{"$f":"DATE(YEAR(R10),MONTH(R10),DAY(TODAY()-WEEKDAY(TODAY(),3))+6)","v":43178}]
[null,null,null,null,null,null,null,{"$f":"WEEKNUM(O12,2)","v":49},{"$f":"IF(J12=\"\",\"\",IF(DAY(J12)-1>0,J12-1,\"\"))","v":""},"","","","2017-12-01","2017-12-02",{"$f":"I10+6-WEEKDAY(I10,3)","v":"2017-12-03"},null,{"$f":"WEEKNUM(X12,2)","v":9},{"$f":"IF(S12=\"\",\"\",IF(DAY(S12)-1>0,S12-1,\"\"))","v":""},"","","2018-03-01","2018-03-02","2018-03-03",{"$f":"R10+6-WEEKDAY(R10,3)","v":"2018-03-04"}]
[null,null,null,null,null,null,null,{"$f":"IF(I13=\"\",\"\",WEEKNUM(I13,2))","v":50},{"$f":"IF(O12=\"\",\"\",IF(DAY(O12)+1<DAY(DATE(YEAR(TODAY()),MONTH(O12)+1,0))+1,O12+1,\"\"))","v":"2017-12-04"},{"$f":"IF(I13=\"\",\"\",IF(DAY(I13)+1<DAY(DATE(YEAR(TODAY()),MONTH(I13)+1,0))+1,I13+1,\"\"))","v":"2017-12-05"},"2017-12-06","2017-12-07","2017-12-08","2017-12-09","2017-12-10",null,{"$f":"IF(R13=\"\",\"\",WEEKNUM(R13,2))","v":10},{"$f":"IF(X12=\"\",\"\",IF(DAY(X12)+1<DAY(DATE(YEAR(TODAY()),MONTH(X12)+1,0))+1,X12+1,\"\"))","v":"2018-03-05"},{"$f":"IF(R13=\"\",\"\",IF(DAY(R13)+1<DAY(DATE(YEAR(TODAY()),MONTH(R13)+1,0))+1,R13+1,\"\"))","v":"2018-03-06"},"2018-03-07","2018-03-08","2018-03-09","2018-03-10","2018-03-11"]
[null,null,null,null,null,null,null,{"$f":"IF(I14=\"\",\"\",WEEKNUM(I14,2))","v":51},{"$f":"IF(O13=\"\",\"\",IF(DAY(O13)+1<DAY(DATE(YEAR(TODAY()),MONTH(O13)+1,0))+1,O13+1,\"\"))","v":"2017-12-11"},"2017-12-12","2017-12-13","2017-12-14","2017-12-15","2017-12-16","2017-12-17",null,{"$f":"IF(R14=\"\",\"\",WEEKNUM(R14,2))","v":11},{"$f":"IF(X13=\"\",\"\",IF(DAY(X13)+1<DAY(DATE(YEAR(TODAY()),MONTH(X13)+1,0))+1,X13+1,\"\"))","v":"2018-03-12"},"2018-03-13","2018-03-14","2018-03-15","2018-03-16","2018-03-17","2018-03-18"]
[null,null,null,null,null,null,null,{"$f":"IF(I15=\"\",\"\",WEEKNUM(I15,2))","v":52},{"$f":"IF(O14=\"\",\"\",IF(DAY(O14)+1<DAY(DATE(YEAR(TODAY()),MONTH(O14)+1,0))+1,O14+1,\"\"))","v":"2017-12-18"},"2017-12-19","2017-12-20","2017-12-21","2017-12-22","2017-12-23","2017-12-24",null,{"$f":"IF(R15=\"\",\"\",WEEKNUM(R15,2))","v":12},{"$f":"IF(X14=\"\",\"\",IF(DAY(X14)+1<DAY(DATE(YEAR(TODAY()),MONTH(X14)+1,0))+1,X14+1,\"\"))","v":"2018-03-19"},"2018-03-20","2018-03-21","2018-03-22","2018-03-23","2018-03-24","2018-03-25"]
[null,null,null,null,null,null,null,{"$f":"IF(I16=\"\",\"\",WEEKNUM(I16,2))","v":53},{"$f":"IF(O15=\"\",\"\",IF(DAY(O15)+1<DAY(DATE(YEAR(TODAY()),MONTH(O15)+1,0))+1,O15+1,\"\"))","v":"2017-12-25"},"2017-12-26","2017-12-27","2017-12-28","2017-12-29","2017-12-30","2017-12-31",null,{"$f":"IF(R16=\"\",\"\",WEEKNUM(R16,2))","v":13},{"$f":"IF(X15=\"\",\"\",IF(DAY(X15)+1<DAY(DATE(YEAR(TODAY()),MONTH(X15)+1,0))+1,X15+1,\"\"))","v":"2018-03-26"},"2018-03-27","2018-03-28","2018-03-29","2018-03-30","2018-03-31",""]
[null,null,null,null,null,null,null,{"$f":"IF(I17=\"\",\"\",WEEKNUM(I17,2))","v":""},{"$f":"IF(O16=\"\",\"\",IF(DAY(O16)+1<DAY(DATE(YEAR(TODAY()),MONTH(O16)+1,0))+1,O16+1,\"\"))","v":""},"","","","","","",null,{"$f":"IF(R17=\"\",\"\",WEEKNUM(R17,2))","v":""},{"$f":"IF(X16=\"\",\"\",IF(DAY(X16)+1<DAY(DATE(YEAR(TODAY()),MONTH(X16)+1,0))+1,X16+1,\"\"))","v":""},"","","","","",""]
[]
[null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+2,1)","v":"2018-01-01"},null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+5,1)","v":"2018-04-01"}]
[null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3)))","v":43113},{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3))+1)","v":43114},{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3))+2)","v":43115},{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3))+3)","v":43116},{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3))+4)","v":43117},{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3))+5)","v":43118},{"$f":"DATE(YEAR(I19),MONTH(I19),DAY(TODAY()-WEEKDAY(TODAY(),3))+6)","v":43119},null,null,{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3)))","v":43203},{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3))+1)","v":43204},{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3))+2)","v":43205},{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3))+3)","v":43206},{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3))+4)","v":43207},{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3))+5)","v":43208},{"$f":"DATE(YEAR(R19),MONTH(R19),DAY(TODAY()-WEEKDAY(TODAY(),3))+6)","v":43209}]
[null,null,null,null,null,null,null,{"$f":"WEEKNUM(O21,2)","v":1},{"$f":"IF(J21=\"\",\"\",IF(DAY(J21)-1>0,J21-1,\"\"))","v":"2018-01-01"},"2018-01-02","2018-01-03","2018-01-04","2018-01-05","2018-01-06",{"$f":"I19+6-WEEKDAY(I19,3)","v":"2018-01-07"},null,{"$f":"WEEKNUM(X21,2)","v":13},{"$f":"IF(S21=\"\",\"\",IF(DAY(S21)-1>0,S21-1,\"\"))","v":""},"","","","","",{"$f":"R19+6-WEEKDAY(R19,3)","v":"2018-04-01"}]
[null,null,null,null,null,null,null,{"$f":"IF(I22=\"\",\"\",WEEKNUM(I22,2))","v":2},{"$f":"IF(O21=\"\",\"\",IF(DAY(O21)+1<DAY(DATE(YEAR(TODAY()),MONTH(O21)+1,0))+1,O21+1,\"\"))","v":"2018-01-08"},{"$f":"IF(I22=\"\",\"\",IF(DAY(I22)+1<DAY(DATE(YEAR(TODAY()),MONTH(I22)+1,0))+1,I22+1,\"\"))","v":"2018-01-09"},"2018-01-10","2018-01-11","2018-01-12","2018-01-13","2018-01-14",null,{"$f":"IF(R22=\"\",\"\",WEEKNUM(R22,2))","v":14},{"$f":"IF(X21=\"\",\"\",IF(DAY(X21)+1<DAY(DATE(YEAR(TODAY()),MONTH(X21)+1,0))+1,X21+1,\"\"))","v":"2018-04-02"},{"$f":"IF(R22=\"\",\"\",IF(DAY(R22)+1<DAY(DATE(YEAR(TODAY()),MONTH(R22)+1,0))+1,R22+1,\"\"))","v":"2018-04-03"},"2018-04-04","2018-04-05","2018-04-06","2018-04-07","2018-04-08"]
[null,null,null,null,null,null,null,{"$f":"IF(I23=\"\",\"\",WEEKNUM(I23,2))","v":3},{"$f":"IF(O22=\"\",\"\",IF(DAY(O22)+1<DAY(DATE(YEAR(TODAY()),MONTH(O22)+1,0))+1,O22+1,\"\"))","v":"2018-01-15"},"2018-01-16","2018-01-17","2018-01-18","2018-01-19","2018-01-20","2018-01-21",null,{"$f":"IF(R23=\"\",\"\",WEEKNUM(R23,2))","v":15},{"$f":"IF(X22=\"\",\"\",IF(DAY(X22)+1<DAY(DATE(YEAR(TODAY()),MONTH(X22)+1,0))+1,X22+1,\"\"))","v":"2018-04-09"},"2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14","2018-04-15"]
[null,null,null,null,null,null,null,{"$f":"IF(I24=\"\",\"\",WEEKNUM(I24,2))","v":4},{"$f":"IF(O23=\"\",\"\",IF(DAY(O23)+1<DAY(DATE(YEAR(TODAY()),MONTH(O23)+1,0))+1,O23+1,\"\"))","v":"2018-01-22"},"2018-01-23","2018-01-24","2018-01-25","2018-01-26","2018-01-27","2018-01-28",null,{"$f":"IF(R24=\"\",\"\",WEEKNUM(R24,2))","v":16},{"$f":"IF(X23=\"\",\"\",IF(DAY(X23)+1<DAY(DATE(YEAR(TODAY()),MONTH(X23)+1,0))+1,X23+1,\"\"))","v":"2018-04-16"},"2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21","2018-04-22"]
[null,null,null,null,null,null,null,{"$f":"IF(I25=\"\",\"\",WEEKNUM(I25,2))","v":5},{"$f":"IF(O24=\"\",\"\",IF(DAY(O24)+1<DAY(DATE(YEAR(TODAY()),MONTH(O24)+1,0))+1,O24+1,\"\"))","v":"2018-01-29"},"2018-01-30","2018-01-31","","","","",null,{"$f":"IF(R25=\"\",\"\",WEEKNUM(R25,2))","v":17},{"$f":"IF(X24=\"\",\"\",IF(DAY(X24)+1<DAY(DATE(YEAR(TODAY()),MONTH(X24)+1,0))+1,X24+1,\"\"))","v":"2018-04-23"},"2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28","2018-04-29"]
[null,null,null,null,null,null,null,{"$f":"IF(I26=\"\",\"\",WEEKNUM(I26,2))","v":""},{"$f":"IF(O25=\"\",\"\",IF(DAY(O25)+1<DAY(DATE(YEAR(TODAY()),MONTH(O25)+1,0))+1,O25+1,\"\"))","v":""},"","","","","","",null,{"$f":"IF(R26=\"\",\"\",WEEKNUM(R26,2))","v":18},{"$f":"IF(X25=\"\",\"\",IF(DAY(X25)+1<DAY(DATE(YEAR(TODAY()),MONTH(X25)+1,0))+1,X25+1,\"\"))","v":"2018-04-30"},"","","","","",""]