{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Mulai","1","2","3","4","5","6","7","8","9","10","Pelajari selengkapnya"],"not_rendered":{"charts":7,"images":17,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Mulai","index":0,"n_rows":3,"n_cols":1,"rows_kept":3}
["Selamat Datang\nInstruksi untuk pembaca layar: Setelah membaca lembar tips dalam tutorial ini, Anda akan mempelajari cara memahami elemen bagan. Instruksi untuk setiap lembar dimulai dari sel A1, dan setiap langkah selanjutnya ada di sel A2, A3, dan seterusnya. \nInstruksi akan menunjukkan sel mana yang harus dinavigasikan untuk menggunakan suatu fitur, atau pembacaan lebih lanjut.\nUntuk memulai, tekan CTRL+PAGE DOWN."]
["Sepuluh tips bagan"]
["Setelah melewati sepuluh tips pembuatan bagan ini, Anda \nlebih cepat dan lebih efisien dari sebelumnya."]

{"sheet":"1","index":1,"n_rows":16,"n_cols":3,"rows_kept":16}
{"$rows_empty":11}
[null,"Staf penjualan","Jumlah yang dijual"]
[null,"Kania",500]
[null,"Deni",800]
[null,"Bambang",{"v":1000,"d":"1,000"}]
[null,"Santi",200]

{"sheet":"2","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
{"$rows_empty":11}
[null,"Staf penjualan","Penjualan","Komisi"]
[null,"Kania",{"v":500,"d":"Rp500"},{"$f":"0.05*DataBaganYangDianjurkan3[[#This Row],[Penjualan]]","v":{"v":25,"d":"Rp25"}}]
[null,"Deni",{"v":800,"d":"Rp800"},{"$f":"0.05*DataBaganYangDianjurkan3[[#This Row],[Penjualan]]","v":{"v":40,"d":"Rp40"}}]
[null,"Bambang",{"v":1000,"d":"Rp1,000"},{"$f":"0.05*DataBaganYangDianjurkan3[[#This Row],[Penjualan]]","v":{"v":50,"d":"Rp50"}}]
[null,"Santi",{"v":200,"d":"Rp200"},{"$f":"0.05*DataBaganYangDianjurkan3[[#This Row],[Penjualan]]","v":{"v":10,"d":"Rp10"}}]

{"sheet":"3","index":3,"n_rows":16,"n_cols":5,"rows_kept":16}
{"$rows_empty":12}
[null,null,"Staf penjualan","Jan","Feb"]
[null,null,"Kania",400,500]
[null,null,"Deni",200,800]
[null,null,"Bambang",234,1000]

{"sheet":"4","index":4,"n_rows":105,"n_cols":7,"rows_kept":105}
{"$rows_empty":99}
[null,null,"Staf penjualan","Jan","Feb","Mar","Apr"]
[null,null,"Kania",800,500,850,123]
[null,null,"Deni",200,800,350,523]
[null,null,"Bambang",234,1000,450,574]
[null,null,"Santi",350,550,150,234]
[null,null,"Doris",440,142,645,988]

{"sheet":"5","index":5,"n_rows":18,"n_cols":3,"rows_kept":18}
[]
[]
[]
[]
["4) Tekan ALT+JT, V untuk membuka panel Bidang PivotChart. Secara default, fokus akan terletak pada kotak teks Pencarian. Jangan ketik apa pun, tetapi tekan TAB satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JT, V lagi. Tekan tombol panah untuk memilih bidang Produk. Setelah dipilih, tekan SPACEBAR untuk menambahkan bidang Produk ke area Baris. Ulangi untuk bidang Jumlah, dan Excel akan otomatis menambahkannya ke bagian Nilai. Jika tidak puas dengan penempatan PivotChart, Anda dapat menekan ALT+H+IL+N untuk membuka panel Pilihan. Kemudian, gunakan tombol TAB untuk memilih PivotChart, dan gunakan tombol Panah untuk memindahkan bagan ke area yang diinginkan. "]
{"$rows_empty":7}
[null,"Produk","Jumlah"]
[null,"Apel",500]
[null,"Apel",800]
[null,"Apel",800]
[null,"Jeruk",1000]
[null,"Jeruk",200]

{"sheet":"6","index":6,"n_rows":18,"n_cols":9,"rows_kept":18}
{"$rows_empty":12}
[{"$nulls":6},"Departemen","Produk","Jumlah"]
[{"$nulls":7},"Apel",500]
[{"$nulls":7},"Jeruk",800]
[{"$nulls":7},"Pisang",800]
[{"$nulls":7},"Asparagus",600]
[{"$nulls":7},"Brokoli",1000]

{"sheet":"7","index":7,"n_rows":18,"n_cols":9,"rows_kept":18}
[]
[]
[]
[]
[]
["MENGAPA MENGGUNAKAN SUMBU SEKUNDER?\nKetika dua kolom berisi tipe angka yang berbeda, Anda mungkin perlu menggunakan sumbu sekunder. Dalam contoh ini, kolom Penjualan berisi nilai dolar. Tetapi, kolom % Laba berisi persentase. Karena kedua kolom data sangat berbeda, menggunakan bagan kombo dengan sumbu sekunder memungkinkan Anda membandingkan keduanya dengan elemen bagan yang berbeda: kolom untuk Penjualan, dan garis untuk % Laba."]
[]
[]
[]
[]
[]
[{"$nulls":6},"Tanggal","Penjualan","% Laba"]
[{"$nulls":6},"2018-01-01",{"v":900,"d":"Rp900"},{"v":0.33754898404938316,"d":"34%"}]
[{"$nulls":6},"2018-01-02",{"v":600,"d":"Rp600"},{"v":0.27,"d":"27%"}]
[{"$nulls":6},"2018-01-03",{"v":500,"d":"Rp500"},{"v":0.42,"d":"42%"}]
[{"$nulls":6},"2018-01-04",{"v":900,"d":"Rp900"},{"v":0.29,"d":"29%"}]
[{"$nulls":6},"2018-01-05",{"v":700,"d":"Rp700"},{"v":0.32,"d":"32%"}]
[{"$nulls":6},"2018-01-06",{"v":800,"d":"Rp800"},{"v":0.23900536726791932,"d":"24%"}]

{"sheet":"8","index":8,"n_rows":18,"n_cols":9,"rows_kept":18}
{"$rows_empty":11}
[{"$nulls":6},"Minggu 1"]
[{"$nulls":6},"Tanggal","Peserta","Penjualan makanan"]
[{"$nulls":6},"2018-01-01",599,900]
[{"$nulls":6},"2018-01-02",201,400]
[{"$nulls":6},"2018-01-03",459,500]
[{"$nulls":6},"2018-01-04",234,900]
[{"$nulls":6},"2018-01-05",622,900]

{"sheet":"9","index":9,"n_rows":18,"n_cols":7,"rows_kept":18}
[]
[]
["2) Tekan ALT+H+IL+N untuk membuka panel Pilihan, lalu gunakan TAB dan tombol Panah untuk menavigasi ke bagan terkait. Berikutnya, tekan ALT+JC+C untuk membuka dialog Ubah Tipe Bagan. Pai akan dipilih, dan Anda dapat menekan tombol Tab dua kali, lalu Panah Kanan untuk memilih opsi Pai dari Pai. Tekan enter untuk mengonfirmasi pilihan Anda."]
[]
["4) Sekarang, tekan ALT+JA+O, diikuti dengan F6, lalu Tab hingga Anda mencapai opsi \"Pisahkan Seri Menurut\". Gunakan tombol Panah bawah, lalu pilih opsi Nilai. Tab lagi ke opsi \"Nilai kurang dari\", masukkan 1000, lalu tekan Enter. Saat menekan Enter, Kiwi, Anggur, dan Pir dibagi menjadi pai masing-masing, karena jumlahnya kurang dari 1000.   "]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Produk","Jumlah"]
[{"$nulls":5},"Apel",2500]
[{"$nulls":5},"Pir",30]
[{"$nulls":5},"Anggur",10]
[{"$nulls":5},"Kiwi",15]
[{"$nulls":5},"Jeruk",1800]
[{"$nulls":5},"Prem",1200]

{"sheet":"10","index":10,"n_rows":103,"n_cols":6,"rows_kept":103}
{"$rows_empty":99}
[null,"Staf penjualan","Jan","Feb","Mar","Apr"]
[null,"Kania",800,1400,1100,1500]
[null,"Deni",200,200,350,523]
[null,"Bambang",400,1000,600,800]

{"sheet":"Pelajari selengkapnya","index":11,"n_rows":0,"n_cols":0,"rows_kept":0}