{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Mulai","Anggaran Pemasaran Saluran"],"not_rendered":{"images":1,"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, lalu F10 di dalam tabel, pilih opsi TABEL, lalu pilih TEKS ALTERNATIF."]

{"sheet":"Anggaran Pemasaran Saluran","index":1,"n_rows":70,"n_cols":17,"rows_kept":70,"merged":[[0,1,0,19],[1,16,1,19],[2,16,2,19],[4,16,4,19],[5,16,5,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[38,16,38,19],[39,16,39,19],[40,16,40,19],[41,16,41,17]]}
[]
[null," ","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"]
[null,"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 di 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+D36+D44+D51","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"$f":"F11+F36+F44+F51","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":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}]
[null,"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"}}]
[null,"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 Pegawai",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,"Facebook",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D24:$O24)","v":{"v":600,"d":"600.00"}}]
[null,"Twitter",null,100,null,100,null,100,null,100,null,100,null,100,null,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D25:$O25)","v":{"v":600,"d":"600.00"}}]
[null,"YouTube",null,null,100,null,100,100,{"$nulls":3},100,100,null,100,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Total Pemasaran Internet Rp(000)",null,{"$f":"SUM(D20:D23)","v":535.25},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"}}]
[null,"ITEM EMAIL 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,"EMAIL LANGSUNG (% DARI PENJUALAN LANGSUNG)"]
[null,"Sumber Daya Manusia - Biaya",{"$nulls":14},{"$f":"SUM('Anggaran Pemasaran Saluran'!$D30:$O30)","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'!$D31:$O31)","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'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Total Korespondensi Langsung Rp(000)",null,{"$f":"SUM(D30:D32)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E30:E32)","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(Q30:Q32)","v":{"v":15000,"d":"15,000.00"}}]
[null,"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(Q33,Q27,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
[null,"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'!$D37:$O37)","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'!$D38:$O38)","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'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Diskon",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$40","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'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Komisi (% dari Penjualan Agen)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$41","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'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Total Agen/Broker Rp(000)",null,{"$f":"SUM(D37:D41)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E37:E41)","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(Q37:Q41)","v":{"v":11139,"d":"11,139.00"}}]
[null,"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'!$D45:$O45)","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(Distributor[[#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(Distributor[[#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*D44*$C$48","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(Distributor[[#This Row],[Bulan 1]:[Bulan 12]])","v":666.75}]
[null,"Total Distributor Rp(000)",null,{"$f":"SUM(D45:D48)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E45:E48)","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(Q45:Q48)","v":{"v":11466.75,"d":"11,466.75"}}]
[null,"ITEM RITEL","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'!$D52:$O52)","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'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Komisi/Diskon (% dari Penjualan Ritel)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D51*$C$55","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Total Peritel Rp(000)",null,{"$f":"SUM(D52:D55)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E52:E55)","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(Q53:Q55)","v":{"v":4292.9,"d":"4,292.90"}}]
[null,"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'!$D59:$O59)","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'!$D60:$O60)","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'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total CAR Rp(000)",null,{"$f":"SUM(D59:D61)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E59:E61)","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(Q59:Q61)","v":{"v":10800,"d":"10,800.00"}}]
[null,"ITEM PENGELUARAN 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,"PENGELUARAN LAINNYA"]
[null,"Perjalanan",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Anggaran Pemasaran Saluran'!$D65:$O65)","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'!$D66:$O66)","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'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total Biaya Lainnya Rp(000)",null,{"$f":"SUM(D65:D67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E65:E67)","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(Q65:Q67)","v":{"v":10800,"d":"10,800.00"}}]
[]
[null,"TOTAL ANGGARAN PEMASARAN:",null,{"$f":"SUM(D34,AgenDanPerantara[[#Totals],[Bulan 1]],Distributor[[#Totals],[Bulan 1]],Retailer[[#Totals],[Bulan 1]],MOBIL[[#Totals],[Bulan 1]],PengeluaranLain[[#Totals],[Bulan 1]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 2]],MOBIL[[#Totals],[Bulan 2]],Retailer[[#Totals],[Bulan 2]],Distributor[[#Totals],[Bulan 2]],AgenDanPerantara[[#Totals],[Bulan 2]],E34)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 3]],MOBIL[[#Totals],[Bulan 3]],Retailer[[#Totals],[Bulan 3]],Distributor[[#Totals],[Bulan 3]],AgenDanPerantara[[#Totals],[Bulan 3]],F34)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 4]],MOBIL[[#Totals],[Bulan 4]],Retailer[[#Totals],[Bulan 4]],Distributor[[#Totals],[Bulan 4]],AgenDanPerantara[[#Totals],[Bulan 4]],G34)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 5]],MOBIL[[#Totals],[Bulan 5]],Retailer[[#Totals],[Bulan 5]],Distributor[[#Totals],[Bulan 5]],AgenDanPerantara[[#Totals],[Bulan 5]],H34)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 6]],MOBIL[[#Totals],[Bulan 6]],Retailer[[#Totals],[Bulan 6]],Distributor[[#Totals],[Bulan 6]],AgenDanPerantara[[#Totals],[Bulan 6]],I34)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 7]],MOBIL[[#Totals],[Bulan 7]],Retailer[[#Totals],[Bulan 7]],Distributor[[#Totals],[Bulan 7]],AgenDanPerantara[[#Totals],[Bulan 7]],J34)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 8]],MOBIL[[#Totals],[Bulan 8]],Retailer[[#Totals],[Bulan 8]],Distributor[[#Totals],[Bulan 8]],AgenDanPerantara[[#Totals],[Bulan 8]],K34)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 9]],MOBIL[[#Totals],[Bulan 9]],Retailer[[#Totals],[Bulan 9]],Distributor[[#Totals],[Bulan 9]],AgenDanPerantara[[#Totals],[Bulan 9]],L34)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 10]],MOBIL[[#Totals],[Bulan 10]],Retailer[[#Totals],[Bulan 10]],Distributor[[#Totals],[Bulan 10]],AgenDanPerantara[[#Totals],[Bulan 10]],M34)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 11]],MOBIL[[#Totals],[Bulan 11]],Retailer[[#Totals],[Bulan 11]],Distributor[[#Totals],[Bulan 11]],AgenDanPerantara[[#Totals],[Bulan 11]],N34)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(PengeluaranLain[[#Totals],[Bulan 12]],MOBIL[[#Totals],[Bulan 12]],Retailer[[#Totals],[Bulan 12]],Distributor[[#Totals],[Bulan 12]],AgenDanPerantara[[#Totals],[Bulan 12]],O34)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]