{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Mulai","Anggaran Pemasaran Saluran"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Mulai","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"TENTANG TEMPLAT INI"]
[null,"Gunakan templat ini untuk membuat Anggaran Pemasaran Saluran."]
[null,"Masukkan Perkiraan Penjualan untuk setiap bulan dan detail lainnya dalam tabel."]
[null,"Total dihitung secara otomatis dan grafik mini akan diperbarui."]
[null,"Catatan: "]
[null,"Instruksi tambahan telah tersedia dalam kolom A di lembar kerja ANGGARAN PEMASARAN SALURAN. Teks ini sengaja disembunyikan. Untuk menghapus teks, pilih kolom A, lalu pilih HAPUS. Untuk memperlihatkan teks, pilih kolom A, lalu ubah warna font."]
[null,"Untuk mempelajari selengkapnya tentang tabel, tekan SHIFT kemudian F10 di dalam tabel, pilih opsi TABEL, lalu pilih TEKS ALTERNATIF."]

{"sheet":"Anggaran Pemasaran Saluran","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Buat Anggaran Pemasaran Saluran dalam lembar kerja ini. Judul lembar kerja ini terletak dalam sel di sebelah kanan. Instruksi yang berguna berada dalam sel di kolom ini. Tekan panah bawah untuk memulai. Judul lembar kerja ini terletak dalam sel di sebelah kanan.","ANGGARAN PEMASARAN SALURAN"]
["Label Tarif dan Bulan terletak di baris ini, dari sel C2 hingga O2, dan label Total berada di sel Q2."," ","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12",null,"Total"]
["Label Total Perkiraan Penjualan berada dalam sel di sebelah kanan. Masukkan Perkiraan Penjualan untuk setiap bulan di sel D3 hingga O3. Total dihitung secara otomatis dalam sel Q3.","TOTAL PERKIRAAN PENJUALAN Rp(000)"," ",750,200,500,{"v":1500,"d":"1,500"},{"v":1200,"d":"1,200"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1800,"d":"1,800"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},null,{"$f":"SUM(D3:O3)","v":{"v":16950,"d":"16,950"}}]
["Masukkan detail dalam tabel Pegawai dimulai dari sel di sebelah kanan. Total Pegawai untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q9. Grafik mini akan diperbarui dalam sel S9. Instruksi berikutnya ada dalam sel A10.","Item Pegawai","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"PEGAWAI (% DARI TOTAL PENJUALAN)",null,{"$f":"D11+D33+D41+D48","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"}]
[null,"Sumber Daya Manusia - Jumlah Orang",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Sumber Daya Manusia - Biaya",null,{"$f":"$C$6*D6","v":{"v":25,"d":"25.00"}},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Komisi",{"v":1E-3,"d":"0.10%"},{"$f":"D3*$C$8","v":0.75},{"v":0.2,"d":"0.20"},{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":1.8,"d":"1.80"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Total Pegawai Rp(000)",null,{"$f":"SUM(D7:D8)","v":25.75},{"$f":"SUM(E7:E8)","v":{"v":25.2,"d":"25.20"}},{"v":25.5,"d":"25.50"},{"v":26.5,"d":"26.50"},{"v":26.2,"d":"26.20"},{"v":26.5,"d":"26.50"},{"v":26.5,"d":"26.50"},{"v":26.8,"d":"26.80"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},null,{"$f":"SUM(Q7:Q8)","v":316.95}]
["Masukkan detail dalam tabel Pemasaran Langsung dimulai dari sel di sebelah kanan. Total Telemarketing untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q17. Grafik mini akan diperbarui dalam sel S17. Instruksi berikutnya ada dalam sel A18.","Item Pemasaran Langsung","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"PEMASARAN LANGSUNG (% DARI TOTAL PENJUALAN)",null,{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":0.75,"d":"75%"},{"v":0.4,"d":"40%"},{"v":0.33,"d":"33%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Telemarketing (% dari Penjualan Langsung)",null,{"v":1,"d":"100%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[null,"Sumber Daya Manusia - Jumlah Orang",3,{"$f":"$C$13*D12","v":3},1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Dukungan Infrastruktur",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Komisi",{"v":1E-3,"d":"0.10%"},{"$f":"$C$15*D3*D11*D12","v":0.75},{"v":0.1,"d":"0.10"},{"v":0.1875,"d":"0.19"},{"v":0.30000000000000004,"d":"0.30"},{"v":0.198,"d":"0.20"},{"v":0.1875,"d":"0.19"},{"v":0.15000000000000002,"d":"0.15"},{"v":0.09000000000000001,"d":"0.09"},0.05,0.05,0.05,0.05,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Pelatihan",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Total Telemarketing Rp(000)",null,{"$f":"SUM(D13:D16)","v":53.75},{"$f":"SUM(E13:E16)","v":{"v":21.6,"d":"21.60"}},{"$f":"SUM(F13:F16)","v":{"v":51.6875,"d":"51.69"}},{"v":21.8,"d":"21.80"},{"v":51.698,"d":"51.70"},{"v":21.6875,"d":"21.69"},51.65,21.59,51.55,21.55,51.55,21.55,null,{"$f":"SUM(Q13:Q16)","v":{"v":441.663,"d":"441.66"}}]
["Masukkan detail dalam tabel Pemasaran Internet dimulai dari sel di sebelah kanan. Total Pemasaran Internet untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q24. Grafik mini akan diperbarui dalam sel S24. Instruksi berikutnya ada dalam sel A25.","Item Pemasaran Internet","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"Pemasaran Internet (% dari Penjualan Langsung)",null,{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"}]
[null,"Sumber Daya Manusia - Jumlah Orang",1,{"$f":"$C$20*D19","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Pengembangan Situs Web (biaya satu kali)",null,500,{"$nulls":12},{"$f":"SUM('Anggaran Pemasaran Saluran'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Hosting",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Dukungan & Pemeliharaan",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Total Pemasaran Internet Rp(000)",null,{"$f":"SUM(D20:D23)","v":535.25},{"$f":"SUM(E20:E23)","v":10.25},10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,35.25,10.25,null,{"$f":"SUM(Q20:Q23)","v":{"v":673,"d":"673.00"}}]
["Masukkan detail dalam tabel Korespondensi Langsung dimulai dari sel di sebelah kanan. Total Korespondensi Langsung untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q30. Instruksi berikutnya ada dalam sel A31."," Item Korespondensi Langsung","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"Korespondensi Langsung (% dari Penjualan Langsung)"]
[null,"Sumber Daya Manusia - Biaya",{"$nulls":14},{"$f":"SUM('Anggaran Pemasaran Saluran'!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Materi",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Ongkos kirim",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Total Korespondensi Langsung Rp(000)",null,{"$f":"SUM(D27:D29)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E27:E29)","v":{"v":1250,"d":"1,250.00"}},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},null,{"$f":"SUM(Q27:Q29)","v":{"v":15000,"d":"15,000.00"}}]
["Total Pemasaran Langsung dihitung secara otomatis dalam baris ini, dari sel D31 hingga O31, dan Total Tahunan di sel Q31. Grafik mini akan diperbarui dalam sel S31.","Total Pemasaran Langsung Rp(000)",null,{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 1]],PemasaranInternet[[#Totals],[Bulan 1]],PemasaranLangsung[[#Totals],[Bulan 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 2]],PemasaranInternet[[#Totals],[Bulan 2]],PemasaranLangsung[[#Totals],[Bulan 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 3]],PemasaranInternet[[#Totals],[Bulan 3]],PemasaranLangsung[[#Totals],[Bulan 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 4]],PemasaranInternet[[#Totals],[Bulan 4]],PemasaranLangsung[[#Totals],[Bulan 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 5]],PemasaranInternet[[#Totals],[Bulan 5]],PemasaranLangsung[[#Totals],[Bulan 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 6]],PemasaranInternet[[#Totals],[Bulan 6]],PemasaranLangsung[[#Totals],[Bulan 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 7]],PemasaranInternet[[#Totals],[Bulan 7]],PemasaranLangsung[[#Totals],[Bulan 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 8]],PemasaranInternet[[#Totals],[Bulan 8]],PemasaranLangsung[[#Totals],[Bulan 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 9]],PemasaranInternet[[#Totals],[Bulan 9]],PemasaranLangsung[[#Totals],[Bulan 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 10]],PemasaranInternet[[#Totals],[Bulan 10]],PemasaranLangsung[[#Totals],[Bulan 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 11]],PemasaranInternet[[#Totals],[Bulan 11]],PemasaranLangsung[[#Totals],[Bulan 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(KorespondensiLangsung[[#Totals],[Bulan 12]],PemasaranInternet[[#Totals],[Bulan 12]],PemasaranLangsung[[#Totals],[Bulan 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Masukkan detail dalam tabel Agen dan Broker dimulai dari sel di sebelah kanan. Total Agen dan Broker untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q39. Grafik mini akan diperbarui dalam sel S39. Instruksi berikutnya ada dalam sel A40.","Item Agen/Broker","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"AGEN/BROKER (% DARI TOTAL PENJUALAN)",null,{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"}]
[null,"Komunikasi",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Pelatihan",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D35:$O35)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promosi",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Diskon",{"v":0.1,"d":"10.00%"},{"$f":"D3*D33*$C$37","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Komisi (% dari Penjualan Agen)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D33*$C$38","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Total Agen/Broker Rp(000)",null,{"$f":"SUM(D34:D38)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E34:E38)","v":{"v":904,"d":"904.00"}},{"v":910,"d":"910.00"},{"v":930,"d":"930.00"},{"v":924,"d":"924.00"},{"v":930,"d":"930.00"},{"v":930,"d":"930.00"},{"v":936,"d":"936.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},null,{"$f":"SUM(Q34:Q38)","v":{"v":11139,"d":"11,139.00"}}]
["Masukkan detail dalam tabel Distributor, dimulai dari sel di sebelah kanan. Total Distributor untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q46. Grafik mini akan diperbarui dalam sel S46. Instruksi berikutnya ada dalam sel A47.","Item Distributor","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"DISTRIBUTOR (% DARI TOTAL PENJUALAN)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"Komunikasi",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Pelatihan",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Dstributor[[#This Row],[Bulan 1]:[Bulan 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promosi",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM(Dstributor[[#This Row],[Bulan 1]:[Bulan 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Komisi/Diskon (% dari Penjualan Distributor)",{"v":0.15,"d":"15.00%"},{"$f":"D3*D41*$C$45","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(Dstributor[[#This Row],[Bulan 1]:[Bulan 12]])","v":666.75}]
[null,"Total Distributor Rp(000)",null,{"$f":"SUM(D42:D45)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E42:E45)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},933.75,{"v":945,"d":"945.00"},{"v":1008,"d":"1,008.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},null,{"$f":"SUM(Q42:Q45)","v":{"v":11466.75,"d":"11,466.75"}}]
["Masukkan detail dalam tabel Peritel dimulai dari sel di sebelah kanan. Total Peritel untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q53. Grafik mini akan diperbarui dalam sel S53. Instruksi berikutnya ada dalam sel A54.","Item Peritel","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"PERITEL (% DARI TOTAL PENJUALAN)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.25,"d":"25%"},{"v":0.6,"d":"60%"},{"v":0.67,"d":"67%"},{"v":0.6,"d":"60%"},{"v":0.6,"d":"60%"},{"v":0.5,"d":"50%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
[null,"Komunikasi",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Pelatihan",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D49:$O49)","v":{"v":600,"d":"600.00"}}]
[null,"Promosi",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Komisi/Diskon (% dari Penjualan Ritel)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D48*$C$52","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Total Peritel Rp(000)",null,{"$f":"SUM(D49:D52)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E49:E52)","v":{"v":900,"d":"900.00"}},{"v":912.5,"d":"912.50"},{"v":990,"d":"990.00"},{"v":980.4,"d":"980.40"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},null,{"$f":"SUM(Q50:Q52)","v":{"v":4292.9,"d":"4,292.90"}}]
["Masukkan detail dalam tabel Akuisisi & Retensi Pelanggan dimulai dari sel di sebelah kanan. Total CAR untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q59. Grafik mini akan diperbarui dalam sel S59. Instruksi berikutnya ada dalam sel A60.","Item Akuisisi & Retensi Pelanggan (CAR)","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"AKUISISI & RETENSI PELANGGAN (CAR)"]
[null,"Sumber Daya Manusia",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D56:$O56)","v":{"v":600,"d":"600.00"}}]
[null,"Komunikasi",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D57:$O57)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promosi/Kupon",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total CAR Rp(000)",null,{"$f":"SUM(D56:D58)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E56:E58)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q56:Q58)","v":{"v":10800,"d":"10,800.00"}}]
["Masukkan detail dalam tabel Biaya lainnya dimulai dari sel di sebelah kanan. Total Biaya Lainnya untuk setiap bulan dihitung secara otomatis di akhir tabel dan Total tahunan di sel Q65. Grafik mini akan diperbarui dalam sel S65. Instruksi berikutnya ada dalam sel A67.","Item Biaya Lainnya ","Tarif","Bulan 1","Bulan 2","Bulan 3","Bulan 4","Bulan 5","Bulan 6","Bulan 7","Bulan 8","Bulan 9","Bulan 10","Bulan 11","Bulan 12"]
[null,"BIAYA LAINNYA"]
[null,"Perjalanan",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastruktur (komputer, telepon, dll.)",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Dukungan Saluran",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total Biaya Lainnya Rp(000)",null,{"$f":"SUM(D62:D64)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E62:E64)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q62:Q64)","v":{"v":10800,"d":"10,800.00"}}]
[]
["Total Anggaran Pemasaran dihitung secara otomatis untuk setiap bulan dalam baris ini, dari sel D67 hingga O67, dan Total Tahunan di sel Q67. Grafik mini diperbarui secara otomatis dalam sel S67.","TOTAL ANGGARAN PEMASARAN:",null,{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 1]],CAR[[#Totals],[Bulan 1]],Peritel[[#Totals],[Bulan 1]],Dstributor[[#Totals],[Bulan 1]],AgenDanBroker[[#Totals],[Bulan 1]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 2]],CAR[[#Totals],[Bulan 2]],Peritel[[#Totals],[Bulan 2]],Dstributor[[#Totals],[Bulan 2]],AgenDanBroker[[#Totals],[Bulan 2]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 3]],CAR[[#Totals],[Bulan 3]],Peritel[[#Totals],[Bulan 3]],Dstributor[[#Totals],[Bulan 3]],AgenDanBroker[[#Totals],[Bulan 3]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 4]],CAR[[#Totals],[Bulan 4]],Peritel[[#Totals],[Bulan 4]],Dstributor[[#Totals],[Bulan 4]],AgenDanBroker[[#Totals],[Bulan 4]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 5]],CAR[[#Totals],[Bulan 5]],Peritel[[#Totals],[Bulan 5]],Dstributor[[#Totals],[Bulan 5]],AgenDanBroker[[#Totals],[Bulan 5]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 6]],CAR[[#Totals],[Bulan 6]],Peritel[[#Totals],[Bulan 6]],Dstributor[[#Totals],[Bulan 6]],AgenDanBroker[[#Totals],[Bulan 6]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 7]],CAR[[#Totals],[Bulan 7]],Peritel[[#Totals],[Bulan 7]],Dstributor[[#Totals],[Bulan 7]],AgenDanBroker[[#Totals],[Bulan 7]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 8]],CAR[[#Totals],[Bulan 8]],Peritel[[#Totals],[Bulan 8]],Dstributor[[#Totals],[Bulan 8]],AgenDanBroker[[#Totals],[Bulan 8]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 9]],CAR[[#Totals],[Bulan 9]],Peritel[[#Totals],[Bulan 9]],Dstributor[[#Totals],[Bulan 9]],AgenDanBroker[[#Totals],[Bulan 9]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 10]],CAR[[#Totals],[Bulan 10]],Peritel[[#Totals],[Bulan 10]],Dstributor[[#Totals],[Bulan 10]],AgenDanBroker[[#Totals],[Bulan 10]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 11]],CAR[[#Totals],[Bulan 11]],Peritel[[#Totals],[Bulan 11]],Dstributor[[#Totals],[Bulan 11]],AgenDanBroker[[#Totals],[Bulan 11]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(BiayaLainnya[[#Totals],[Bulan 12]],CAR[[#Totals],[Bulan 12]],Peritel[[#Totals],[Bulan 12]],Dstributor[[#Totals],[Bulan 12]],AgenDanBroker[[#Totals],[Bulan 12]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]