{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Gambaran Keseluruhan Projek","Butiran Tugas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Gambaran Keseluruhan Projek","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Gambaran Keseluruhan Projek"]
[]
[null,"Projek","  ","Kemajuan"," Mula"," Tamat","Nota"]
[null,"Rancang Percutian",{"$f":"IFERROR((SUMIFS(Tasks[Selesai],Tasks[Projek],Projects[[#This Row],[Projek]])/COUNTIFS(Tasks[Projek],Projects[[#This Row],[Projek]]))+0.0001,0.0001)","v":0.50009999999999999},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[Mula]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[[Mula]:[Tamat]]))","v":"2011-12-31"},"Kami akan pergi ke Belize!"]
[null,"Rancang Majlis Kejutan untuk Sara",{"$f":"IFERROR((SUMIFS(Tasks[Selesai],Tasks[Projek],Projects[[#This Row],[Projek]])/COUNTIFS(Tasks[Projek],Projects[[#This Row],[Projek]]))+0.0001,0.0001)","v":1.0001},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[Mula]))","v":"2011-09-10"},{"$f":"MAX(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[[Mula]:[Tamat]]))","v":"2011-10-03"}]
[null,"Latih untuk Maraton",{"$f":"IFERROR((SUMIFS(Tasks[Selesai],Tasks[Projek],Projects[[#This Row],[Projek]])/COUNTIFS(Tasks[Projek],Projects[[#This Row],[Projek]]))+0.0001,0.0001)","v":0.28581428571428569},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[Mula]))","v":"2011-09-01"},{"$f":"MAX(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[[Mula]:[Tamat]]))","v":"2012-04-18"},"Pecah rekod saya pada 18 April"]
[null,"Daftarkan Sara dalam Pelajaran Berenang",{"$f":"IFERROR((SUMIFS(Tasks[Selesai],Tasks[Projek],Projects[[#This Row],[Projek]])/COUNTIFS(Tasks[Projek],Projects[[#This Row],[Projek]]))+0.0001,0.0001)","v":1E-4},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[Mula]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[Projek]=Projects[[#This Row],[Projek]])*(Tasks[Mula]>0),Tasks[[Mula]:[Tamat]]))","v":"2011-10-15"}]

{"sheet":"Butiran Tugas","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Butiran Tugas"]
[]
[null,"Mula","Tamat","Projek","Tugas","Selesai","Nota"]
[null,"2011-10-01","2011-10-15","Rancang Percutian","Pilih di antara tropika & sederhana",1,"Pilih tropika. Kami akan mengunjungi Belize!"]
[null,"2011-10-15","2011-12-31","Rancang Percutian","Semak tiket penerbangan pada musim bunga dalam talian"]
[null,"2011-10-15",null,"Rancang Percutian","Belajar sejarah dan budaya Belize"]
[null,"2011-10-15","2011-10-20","Rancang Percutian","Belajar ulasan tempat peranginan",1]
[null,"2011-10-20",null,"Rancang Percutian","Buat tempahan di tempat peranginan",1,"19 April hingga 30 April"]
[null,"2011-10-20","2011-11-15","Rancang Percutian","Dapatkan pasport untuk seisi keluarga",null,"Pertimbangkan opsyen tergesa-gesa…"]
[null,"2011-09-01","2011-09-30","Latih untuk Maraton","10 batu sehari",1,"Perlumbaan adalah pada 18 April"]
[null,"2011-10-01","2011-10-31","Latih untuk Maraton","12 batu sehari",1]
[null,"2011-11-01","2011-11-30","Latih untuk Maraton","14 batu sehari"]
[null,"2011-12-01","2012-04-15","Latih untuk Maraton","15 batu sehari"]
[null,"2012-04-16",null,"Latih untuk Maraton","Bertolak ke maraton"]
[null,"2012-04-16","2012-04-17","Latih untuk Maraton","Periksa kursus",null,"Joging 10 batu setiap hari"]
[null,"2012-04-18",null,"Latih untuk Maraton","Sampai garisan tamat kurang daripada 3 jam!",null,"Sekarang pergi ke Belize!"]
[null,"2011-09-10",null,"Rancang Majlis Kejutan untuk Sara","Hantar jemputan majlis",1,"Majlis hari jadi kejutan pada 3 Oktober"]
[null,"2011-09-20",null,"Rancang Majlis Kejutan untuk Sara","Pesan katering",1]
[null,"2011-09-22",null,"Rancang Majlis Kejutan untuk Sara","Dapatkan hiburan",1]
[null,"2011-10-03",null,"Rancang Majlis Kejutan untuk Sara","Hari majlis!",1,"Begitu hebat sekali. Dia tidak terfikir!"]
[null,"2011-10-01","2011-10-15","Daftarkan Sara dalam Pelajaran Berenang","Bandingkan pusat kemasyarakatan kawasan tempatan"]