{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Tentang"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["Buat Bagan Gantt di lembar kerja ini.\nMasukkan judul proyek ini di sel B1. \nJudul legenda ada di sel I1.\nInformasi tentang cara menggunakan lembar kerja ini, termasuk instruksi untuk pembaca layar dan pembuat buku kerja ini ada di lembar kerja Tentang.\nLanjutkan menavigasi turun dalam kolom A untuk mengetahui instruksi lebih lanjut.","JUDUL PROYEK",{"$nulls":6},"Legenda:"]
["Masukkan Nama Perusahaan di sel B2.\nLegenda ada di sel I2 hingga AC2.","Nama Perusahaan",{"$nulls":6},"Sesuai Rencana",{"$nulls":4},"Risiko Rendah",{"$nulls":4},"Risiko Sedang",{"$nulls":4},"Risiko Tinggi",{"$nulls":4},"Belum Ditugaskan"]
["Masukkan nama Pemimpin Proyek di sel B3. Masukkan Tanggal Mulai proyek di sel F3 atau izinkan rumus sampel menemukan nilai tanggal terkecil dari tabel Data Gantt.  \nTanggal Mulai Proyek: label ada di sel D3.","Pemimpin Proyek",null,"Tanggal Mulai Proyek:",null,{"$f":"IFERROR(IF(MIN(Pencapaian[Mulai])=0,TODAY(),MIN(Pencapaian[Mulai])),TODAY())","v":"2018-07-07"}]
["Pertambahan Pengguliran ada di sel F4. \nBulan untuk tanggal di baris 5 ditampilkan mulai dari sel I4 hingga sel BL4.\nJangan ubah sel ini. Sel ini diperbarui secara otomatis berdasarkan tanggal mulai proyek di sel F3.",null,null,"Pertambahan Pengguliran:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"Juli"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"mmmm\")=I4,\"\",TEXT(P5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"mmmm\")=P4,TEXT(W5,\"mmmm\")=I4),\"\",TEXT(W5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"mmmm\")=W4,TEXT(AD5,\"mmmm\")=P4,TEXT(AD5,\"mmmm\")=I4),\"\",TEXT(AD5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"mmmm\")=AD4,TEXT(AK5,\"mmmm\")=W4,TEXT(AK5,\"mmmm\")=P4,TEXT(AK5,\"mmmm\")=I4),\"\",TEXT(AK5,\"mmmm\"))","v":"Agustus"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"mmmm\")=AK4,TEXT(AR5,\"mmmm\")=AD4,TEXT(AR5,\"mmmm\")=W4,TEXT(AR5,\"mmmm\")=P4),\"\",TEXT(AR5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"mmmm\")=AR4,TEXT(AY5,\"mmmm\")=AK4,TEXT(AY5,\"mmmm\")=AD4,TEXT(AY5,\"mmmm\")=W4),\"\",TEXT(AY5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"mmmm\")=AY4,TEXT(BF5,\"mmmm\")=AR4,TEXT(BF5,\"mmmm\")=AK4,TEXT(BF5,\"mmmm\")=AD4),\"\",TEXT(BF5,\"mmmm\"))","v":""}]
["Sel I5 hingga BL5 berisi jumlah hari dalam sebulan untuk Bulan yang dicantumkan di blok sel di atas setiap sel tanggal dan dihitung secara otomatis.\nJangan ubah sel ini.\nTanggal hari ini memiliki garis luar berwarna Merah (hex #AD3815) dari tanggal hari ini di baris 5 hingga seluruh kolom tanggal sampai akhir jadwal proyek.",{"$nulls":7},{"$f":"IFERROR(Proyek_Mulai+Pertambahan_Pengguliran,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["Bilah gulir ada di sel I6 hingga BL6. Pertambahan untuk pengaturan halaman di seluruh data ditetapkan sebagai 2 halaman sekaligus dan dapat dikonfigurasi dalam pengaturan untuk bilah kontrol. \nUntuk maju atau mundur dalam garis waktu, masukkan nilai 0 atau lebih besar di sel F4.\nNilai 0 akan membawa Anda ke awal bagan."]
["Baris ini berisi header untuk jadwal proyek yang mengikuti di bawahnya. \nNavigasikan dari B7 hingga BL7 untuk melihat konten. Huruf pertama dari setiap hari dalam seminggu bagi tanggal di atas judul tersebut, dimulai dari sel I7 dan berlanjut hingga sel BL7.\nSemua bagan garis waktu proyek dibuat secara otomatis berdasarkan kategori, tanggal mulai, dan jumlah hari yang dimasukkan dalam tabel Pencapaian.","Deskripsi Pencapaian","Kategori","Ditugaskan Kepada","Kemajuan","Mulai","Jumlah Hari",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"S"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"M"},"S","S","R","K","J","S","M","S","S","R","K","J","S","M","S","S","R","K","J","S","M","S","S","R","K","J","S","M","S","S","R","K","J","S",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"M"},"S","S","R","K","J","S","M","S","S","R","K","J","S","M","S","S","R","K","J"]
["Jangan hapus baris ini. Baris ini disembunyikan guna mempertahankan rumus yang digunakan untuk menyoroti hari ini dalam jadwal proyek. "]
["Masukkan informasi Proyek, dimulai dari sel B9 hingga sel G9. \nData sampel ada di sel B9 hingga G33.\nMasukkan Deskripsi Pencapaian, pilih Kategori dari daftar menurun, tugaskan seseorang pada item, masukkan kemajuan, tanggal mulai, dan jumlah hari bagi tugas untuk membuat bagan.\nInstruksi selanjutnya ada di sel A34.","Judul 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Tujuan\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Pencapaian\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Tujuan\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Pencapaian\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Tujuan\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Pencapaian\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Tujuan\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Pencapaian\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Tugas 1","Tujuan","Nama",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-09-04"},3,null,{"$f":"IF(AND($C10=\"Tujuan\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Pencapaian\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 2","Pencapaian",null,null,{"$f":"TODAY()+5","v":"2019-09-09"},1,null,{"$f":"IF(AND($C11=\"Tujuan\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Pencapaian\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 3","Risiko Rendah",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-09-01"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 4","Pencapaian",null,null,{"$f":"F10+20","v":"2019-09-24"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 5","Risiko Sedang",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-09-10"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Judul 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 1","Risiko Tinggi",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-09-10"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 2","Sesuai Rencana",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-09-12"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 3","Risiko Rendah",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-09-17"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 4","Pencapaian",null,null,{"$f":"F18+2","v":"2019-09-19"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 5",{"$nulls":3},{"$f":"F19+1","v":"2019-09-20"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Judul 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 1","Sesuai Rencana",null,null,{"$f":"F10+15","v":"2019-09-19"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 2","Risiko Sedang",null,null,{"$f":"F22+3","v":"2019-09-22"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 3","Sesuai Rencana",null,null,{"$f":"F23+15","v":"2019-10-07"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Tujuan\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Pencapaian\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Tujuan\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Pencapaian\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Tugas 4","Tujuan",null,null,{"$f":"F19+22","v":"2019-10-11"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Tujuan\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Pencapaian\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 5","Risiko Rendah",null,null,{"$f":"F14","v":"2019-09-10"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Judul 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Tujuan\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Pencapaian\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 1",{"$nulls":3},{"$f":"F25+3","v":"2019-10-14"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 3","Pencapaian",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tugas 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Baris ini kosong",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Baris ini merupakan akhir data pencapaian Gantt. JANGAN masukkan apa pun dalam baris ini. \nUntuk menambahkan item, sisipkan baris baru di atas baris ini.","Untuk menambahkan data, Sisipkan baris baru DI ATAS baris ini"]

{"sheet":"Tentang","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Tentang Templat Ini"]
["Templat ini memberikan cara yang mudah untuk membuat bagan Gantt guna membantu memvisualkan dan memantau proyek Anda. Cukup masukkan deskripsi tugas Anda, pilih kategori Tujuan, Pencapaian, Sesuai Rencana, Risiko Rendah, Risiko Sedang, Risiko Tinggi, Kemajuan sebagai persentase penyelesaian tugas, Tanggal Mulai, dan Jumlah hari untuk menyelesaikan tugas. Bagan Gantt akan terisi dan diberi kode warna untuk membantu membedakan berbagai kategori. Gunakan bilah gulir untuk menggulir garis waktu. Sisipkan tugas baru dengan menyisipkan baris baru.\n"]
["Panduan untuk Pembaca Layar"]
["Terdapat 2 lembar kerja dalam buku kerja ini. \n\nBagan Gantt\nTentang\n\nInstruksi untuk setiap lembar kerja terletak dalam kolom A dimulai di sel A1 dari setiap lembar kerja. Instruksi dituliskan dengan teks yang tersembunyi. Setiap langkah akan memandu Anda memahami informasi dalam baris tersebut. Setiap langkah berikutnya berlanjut di sel A2, A3, dan selanjutnya, kecuali dijelaskan sebaliknya dengan jelas. Misalnya, teks instruksi mungkin mengatakan \"lanjutkan ke sel A6\" untuk langkah berikutnya. \n\nTeks tersembunyi ini tidak akan dicetak.\n\nUntuk menghapus instruksi berikut dari lembar kerja, cukup hapus kolom A."]
["Ini adalah instruksi terakhir di lembar kerja ini."]