{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Tugasan","Pandangan Bulan","Pandangan Minggu"],"not_rendered":{"images":2,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Tugasan","index":0,"n_rows":25,"n_cols":3,"rows_kept":25}
[]
[]
[]
[null,"TUGASAN","TARIKH SIAP"]
[null,"Tugasan 1","2016-03-29"]
[null,"Tugasan 2","2016-04-05"]
[null,"Tugasan 3","2016-04-08"]
[null,"Tugasan 4","2016-04-09"]
[null,"Tugasan 5","2016-04-11"]
[null,"Tugasan 6","2016-04-12"]
[null,"Tugasan 7","2016-04-15"]
[null,"Tugasan 8","2016-04-17"]
[null,"Tugasan 9","2016-04-19"]
[null,"Tugasan 10","2016-04-24"]
[null,"Tugasan 11","2016-04-25"]
[null,"Tugasan 12","2016-04-29"]
[null,"Tugasan 13","2016-04-30"]
[null,"Tugasan 14","2016-05-02"]
[null,"Tugasan 15","2016-05-06"]
[null,"Tugasan 16","2016-05-08"]
[null,"Tugasan 17","2016-05-10"]
[null,"Tugasan 18","2016-05-14"]
[null,"Tugasan 19","2016-05-17"]
[null,"Tugasan 20","2016-05-22"]
[null,"Tugasan 21","2016-06-03"]

{"sheet":"Pandangan Bulan","index":1,"n_rows":37,"n_cols":9,"rows_kept":37,"merged":[[3,1,3,7]]}
[]
[null,{"$f":"UPPER(CHOOSE(MoMonthNum,\"Januari\",\"Februari\",\"Mac\",\"April\",\"Mei\",\"Jun\",\"Julai\",\"Ogos\",\"September\",\"Oktober\",\"November\",\"Disember\"))","v":"MAC"},2016,null,null,3]
[]
[null,"PANDANGAN BULAN"]
[null,"ISNIN","SELASA","RABU","KHAMIS","JUMAAT","SABTU","AHAD"]
[null,{"$f":"IF(WEEKDAY(DATEVALUE(\"1 \"&MoMonth&\"/\"&MoYear),2)=COLUMN(A$1),1,IF(LEN(A6)>0,A6+1,\"\"))","v":""},1,2,3,4,5,6,{"$f":"IF(WEEKDAY(DATEVALUE(\"1 \"&MoMonth&\"/\"&MoYear))=COLUMN(I$1),1,IF(LEN(H6)>0,H6+1,\"\"))","v":7}]
[null,{"$f":"IF(LEN(B6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,B6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,C6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,D6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,E6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,F6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,G6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H6)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,H6))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(LEN(H6)>0,IF(H6=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H6+1),\"\")","v":7},{"$f":"IF(LEN(B12)>0,IF(B12=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B12+1),\"\")","v":8},9,10,11,12,13]
[null,{"$f":"IF(LEN(B12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,B12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,C12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,D12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,E12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,F12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,G12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,H12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(LEN(H12)>0,IF(H12=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H12+1),\"\")","v":14},{"$f":"IF(LEN(B18)>0,IF(B18=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B18+1),\"\")","v":15},16,17,18,19,20]
[null,{"$f":"IF(LEN(B18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,B18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,C18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,D18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,E18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,F18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,G18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H18)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,H18))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(LEN(H18)>0,IF(H18=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H18+1),\"\")","v":21},{"$f":"IF(LEN(B24)>0,IF(B24=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B24+1),\"\")","v":22},23,24,25,26,27]
[null,{"$f":"IF(LEN(B24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,B24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,C24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,D24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,E24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,F24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,G24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H24)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,H24))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(LEN(H24)>0,IF(H24=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H24+1),\"\")","v":28},{"$f":"IF(LEN(B30)>0,IF(B30=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B30+1),\"\")","v":29},30,31,"",{"$f":"IF(LEN(F30)>0,IF(F30=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",F30+1),\"\")","v":""},{"$f":"IF(LEN(G30)>0,IF(G30=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",G30+1),\"\")","v":""}]
[null,{"$f":"IF(LEN(B30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,B30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,C30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":"Tarikh hantar tugasan!"},{"$f":"IF(LEN(D30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,D30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,E30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,F30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,G30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,H30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
[]
[]
[]
[]
[null,{"$f":"IF(LEN(H30)>0,IF(H30=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",H30+1),\"\")","v":""},{"$f":"IF(LEN(B36)>0,IF(B36=DAY(DATE(MoYear,MoMonthNum+1,0)),\"\",B36+1),\"\")","v":""},"","","","",""]
[null,{"$f":"IF(LEN(B36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,B36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,C36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,D36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,E36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,F36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,G36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H36)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(MoYear,MoMonthNum,H36))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]

{"sheet":"Pandangan Minggu","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[3,1,3,7]]}
[]
[null,{"$f":"UPPER(CHOOSE(WkMonthNum,\"Januari\",\"Februari\",\"Mac\",\"April\",\"Mei\",\"Jun\",\"Julai\",\"Ogos\",\"September\",\"Oktober\",\"November\",\"Disember\"))","v":"MAC"},2016,{"$f":"UPPER(CHOOSE(WkWeek,\"Minggu 1\",\"Minggu 2\",\"Minggu 3\",\"Minggu 4\", \"Minggu 5\", \"Minggu 6\"))","v":"MINGGU 5"},5,3]
[]
[null,"PANDANGAN MINGGU"]
[null,{"$f":"IF(WEEKDAY(DATEVALUE(\"1\"&WkMonth&WkYear),2)=COLUMN(A$1),1,IF(LEN(A5)>0,A5+1,\"\"))","v":""},1,2,3,4,5,6]
[null,{"$f":"IF(LEN(H5)>0,IF(H5=LastDayOfMonth_Week,\"\",H5+1),\"\")","v":7},{"$f":"IF(LEN(B6)>0,IF(B6=LastDayOfMonth_Week,\"\",B6+1),\"\")","v":8},9,10,11,12,13]
[null,{"$f":"IF(LEN(H6)>0,IF(H6=LastDayOfMonth_Week,\"\",H6+1),\"\")","v":14},15,16,17,18,19,20]
[null,{"$f":"IF(LEN(H7)>0,IF(H7=LastDayOfMonth_Week,\"\",H7+1),\"\")","v":21},22,23,24,25,26,27]
[null,{"$f":"IF(LEN(H8)>0,IF(H8=LastDayOfMonth_Week,\"\",H8+1),\"\")","v":28},29,30,31,"","",""]
[null,{"$f":"IF(LEN(H9)>0,IF(H9=LastDayOfMonth_Week,\"\",H9+1),\"\")","v":""},"","","","","",""]
[null,"ISNIN","SELASA","RABU","KHAMIS","JUMAAT","SABTU","AHAD"]
[null,{"$f":"IF(B14=\"\",IF(AND(ISNUMBER(A12),A12<LastDayOfMonth_Week),A12+1,\"\"),IF(B14<=7,\"\",INDEX(WkMonthView,WkWeek,COLUMN(A$1))-7))","v":21},22,23,24,25,26,27]
[null,{"$f":"IF(LEN(B12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,B12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,C12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,D12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,E12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,F12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,G12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H12)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,H12))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
[null,{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(A$1))","v":28},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(B$1))","v":29},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(C$1))","v":30},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(D$1))","v":31},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(E$1))","v":""},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(F$1))","v":""},{"$f":"INDEX(WkMonthView,WkWeek,COLUMN(G$1))","v":""}]
[null,{"$f":"IF(LEN(B14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,B14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,C14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":"Tarikh hantar tugasan!"},{"$f":"IF(LEN(D14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,D14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,E14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,F14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,G14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H14)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,H14))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]
{"$rows_empty":14}
[null,{"$f":"IF(B14=\"\",IF(AND(ISNUMBER(H14),H14<LastDayOfMonth_Week),H14+1,\"\"),IF(B14+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(A$1))+7))","v":""},{"$f":"IF(C14=\"\",IF(AND(ISNUMBER(B30),B30<LastDayOfMonth_Week),B30+1,\"\"),IF(C14+7>LastDayOfMonth_Week,\"\",INDEX(WkMonthView,WkWeek,COLUMN(B$1))+7))","v":""},"","","","",""]
[null,{"$f":"IF(LEN(B30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,B30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(C30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,C30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(D30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,D30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(E30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,E30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(F30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,F30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(G30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,G30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""},{"$f":"IF(LEN(H30)=0,\"\",IF(COUNTIF(Assignments[TARIKH SIAP],DATE(WkYear,WkMonthNum,H30))>0,\"Tarikh hantar tugasan!\",\"\"))","v":""}]