{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Senarai Utk Dilakukan Projek 1","Seting & Pengiraan"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Senarai Utk Dilakukan Projek 1","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Senarai Untuk Dilakukan Projek"]
[]
[null,"Untuk diselesaikan oleh:",null,null,"Tarikh akhir:",null,"Aktiviti Sorotan"]
[null,"Kim Abercrombie",null,null,{"$f":"TODAY()+95","v":"2013-01-19"},null,"     Minggu Ini [18 Jun - 24 Jun]"]
[]
[null,"Projek 1"]
[null,"Aktiviti","Siap Sebelum","Bajet","% Selesai","Kemajuan","Nota"," "]
[null,"Perancangan",{"$f":"TODAY()-90","v":"2012-07-18"},{"v":476,"d":"RM476"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0.25,"d":"25%"}}]
[null,"Penyediaan",{"$f":"TODAY()-2","v":"2012-10-14"},{"v":301,"d":"RM301"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0.1,"d":"10%"}}]
[null,"Tugas A",{"$f":"TODAY()-7","v":"2012-10-09"},{"v":429,"d":"RM429"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0,"d":"0%"}}]
[null,"Tugas B",{"$f":"TODAY()+20","v":"2012-11-05"},{"v":332,"d":"RM332"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0.7,"d":"70%"}}]
[null,"Tugas C",{"$f":"TODAY()+40","v":"2012-11-25"},{"v":471,"d":"RM471"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0.1,"d":"10%"}}]
[null,"Tugas D",{"$f":"TODAY()+45","v":"2012-11-30"},{"v":418,"d":"RM418"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":1,"d":"100%"}}]
[null,"Kertas kerja",{"$f":"TODAY()+55","v":"2012-12-10"},{"v":150,"d":"RM150"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0,"d":"0%"}},"Mula Selepas Tugas B S"]
[null,"Serahan",{"$f":"TODAY()+70","v":"2012-12-25"},{"v":330,"d":"RM330"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0.25,"d":"25%"}}]
[null,"Susulan",{"$f":"TODAY()+90","v":"2013-01-14"},{"v":353,"d":"RM353"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[% Selesai]]","v":{"v":0.5,"d":"50%"}}]
[{"$nulls":4},{"$f":"+B6","v":"Kim Abercrombie"}]

{"sheet":"Seting & Pengiraan","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Seting Sorotan"]
[null,"Jadual berikut menyimpan seting dan pengiraan bagi senarai juntai bawah Aktiviti Serlahan.\n"]
[null,"Tiada Sorotan",null,null,{"$f":"B5","v":"Tiada Sorotan"}]
[null,"Selang:","Mula:","Tamat:","Siap:"]
[null,"     Minggu Ini",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-10-15"},{"$f":"C7+6","v":"2012-10-21"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"     Minggu Ini [15 Okt - 21 Okt]"}]
[null,"     Bulan Ini",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-10-01"},{"$f":"EDATE(C8,1)-1","v":"2012-10-31"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":"     Bulan Ini [1 - 31, Okt]"}]
[null,"     Suku Tahun Ini",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-04-01"},{"$f":"EDATE(C9,4)-1","v":"2012-07-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     Suku Tahun Ini [1 Apr - 31 Jul]"}]
[null,"     Tahun Ini",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     Tahun Ini [2012]"}]
[null,"Selang:",null,null,{"$f":"B11","v":"Selang:"}]
[null,"     Minggu Lepas",{"$f":"C7-7","v":"2012-10-08"},{"$f":"C12+6","v":"2012-10-14"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"     Minggu Lepas [8 Okt - 14 Okt]"}]
[null,"     Bulan Lepas",{"$f":"EDATE(C8,-1)","v":"2012-09-01"},{"$f":"EDATE(C13,1)-1","v":"2012-09-30"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":"     Bulan Lepas [1 - 30, Sept]"}]
[null,"     Suku Tahun Lepas",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"     Suku Tahun Lepas [1 Jan - 31 Mac]"}]
[null,"     Tahun Lepas",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Tahun Lepas"}]
[]
[null,"Sorotan Terpilih:",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")-1","v":{"$error":"#VALUE!"}},{"$f":"HighlightActivities","v":"     Minggu Ini [18 Jun - 24 Jun]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Mula Sorotan",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Tamat Sorotan",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]