{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Başlangıç","Kanal Pazarlama Bütçesi"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Başlangıç","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"BU ŞABLON HAKKINDA"]
[null,"Kanal Pazarlama Bütçesi oluşturmak için bu şablonu kullanın."]
[null,"Tablolara her bir ay için Beklenen Satışları ve diğer ayrıntıları girin."]
[null,"Toplamlar otomatik olarak hesaplanır ve mini grafikler güncelleştirilir."]
[null,"Not: "]
[null,"KANAL PAZARLAMA BÜTÇESİ çalışma sayfasının A sütununda ek yönergeler sağlanmıştır. Bu metin özellikle gizlendi. Metni kaldırmak için A sütununu ve ardından SİL seçeneğini belirleyin. Metni göstermek için A sütununu seçin ve yazı tipi rengini değiştirin."]
[null,"Tablolar hakkında daha fazla bilgi edinmek için bir tabloda sırasıyla SHIFT ve F10 tuşlarına basıp TABLO seçeneğini belirleyin, ardından ALTERNATİF METİN’i seçin."]

{"sheet":"Kanal Pazarlama Bütçesi","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," ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay",null,"Toplam"]
[null,"BEKLENEN SATIŞLAR TOPLAMI ₺(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"}}]
["Sağdaki hücrede başlayan Personel tablosuna ayrıntıları girin. Her bir ay için Personel Toplamı tablo sonunda ve yıllık Toplam Q9 hücresinde otomatik olarak hesaplanır. Mini grafik S9 hücresinde güncelleştirilir. Sonraki yönerge A10 hücresindedir.","Personel Öğeleri","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"PERSONEL (TOPLAM SATIŞLARIN YÜZDESİ)",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,"İnsan Kaynakları - Çalışan Sayısı",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"İnsan Kaynakları - Maliyet",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('Kanal Pazarlama Bütçesi'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Komisyon",{"v":0.001,"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('Kanal Pazarlama Bütçesi'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Personel Toplamı ₺(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,"DOĞRUDAN PAZARLAMA ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"DOĞRUDAN PAZARLAMA (TOPLAM SATIŞLARIN YÜZDESİ)",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,"Telefonla Pazarlama (Doğrudan Satışların Yüzdesi)",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,"İnsan Kaynakları - Çalışan Sayısı",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('Kanal Pazarlama Bütçesi'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Altyapı Desteği",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Komisyon",{"v":0.001,"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('Kanal Pazarlama Bütçesi'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Eğitim",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Telefonla Pazarlama Toplamı ₺(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,"İNTERNET PAZARLAMACILIĞI ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"İNTERNET PAZARLAMACILIĞI (DOĞRUDAN SATIŞLARIN YÜZDESİ)",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,"İnsan Kaynakları - Çalışan Sayısı",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('Kanal Pazarlama Bütçesi'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Web Sitesi Geliştirme (tek seferlik maliyet)",null,500,{"$nulls":12},{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Barındırma",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Destek ve Bakım",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$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('Kanal Pazarlama Bütçesi'!$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('Kanal Pazarlama Bütçesi'!$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('Kanal Pazarlama Bütçesi'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Internet Pazarlamacılığı Toplamı ₺(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,"DOĞRUDAN POSTA ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"DOĞRUDAN POSTA (DOĞRUDAN SATIŞLARIN YÜZDESİ)"]
[null,"İnsan Kaynakları - Maliyet",{"$nulls":14},{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D30:$O30)","v":{"v":0,"d":"0.00"}}]
[null,"Malzeme",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D31:$O31)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Posta",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Doğrudan Posta Toplamı ₺(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,"Doğrudan Pazarlama Toplamı ₺(000)",null,{"$f":"SUM(DoğrudanPosta[[#Totals],[1. Ay]],İnternetPazarlamacılığı[[#Totals],[1. Ay]],DoğrudanPazarlama[[#Totals],[1. Ay]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[2. Ay]],İnternetPazarlamacılığı[[#Totals],[2. Ay]],DoğrudanPazarlama[[#Totals],[2. Ay]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[3. Ay]],İnternetPazarlamacılığı[[#Totals],[3. Ay]],DoğrudanPazarlama[[#Totals],[3. Ay]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[4. Ay]],İnternetPazarlamacılığı[[#Totals],[4. Ay]],DoğrudanPazarlama[[#Totals],[4. Ay]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[5. Ay]],İnternetPazarlamacılığı[[#Totals],[5. Ay]],DoğrudanPazarlama[[#Totals],[5. Ay]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[6. Ay]],İnternetPazarlamacılığı[[#Totals],[6. Ay]],DoğrudanPazarlama[[#Totals],[6. Ay]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[7. Ay]],İnternetPazarlamacılığı[[#Totals],[7. Ay]],DoğrudanPazarlama[[#Totals],[7. Ay]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[8. Ay]],İnternetPazarlamacılığı[[#Totals],[8. Ay]],DoğrudanPazarlama[[#Totals],[8. Ay]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[9. Ay]],İnternetPazarlamacılığı[[#Totals],[9. Ay]],DoğrudanPazarlama[[#Totals],[9. Ay]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[10. Ay]],İnternetPazarlamacılığı[[#Totals],[10. Ay]],DoğrudanPazarlama[[#Totals],[10. Ay]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[11. Ay]],İnternetPazarlamacılığı[[#Totals],[11. Ay]],DoğrudanPazarlama[[#Totals],[11. Ay]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(DoğrudanPosta[[#Totals],[12. Ay]],İnternetPazarlamacılığı[[#Totals],[12. Ay]],DoğrudanPazarlama[[#Totals],[12. Ay]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
[null,"ARACI ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"ARACI (TOPLAM SATIŞLARIN YÜZDESİ)",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,"İletişim",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D37:$O37)","v":{"v":600,"d":"600.00"}}]
[null,"Eğitim",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('Kanal Pazarlama Bütçesi'!$D38:$O38)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promosyonlar",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('Kanal Pazarlama Bütçesi'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"İndirimler",{"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('Kanal Pazarlama Bütçesi'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Komisyon (Aracının Satışlarının Yüzdesi)",{"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('Kanal Pazarlama Bütçesi'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Aracı Toplamı ₺(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,"DAĞITIMCI ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"DAĞITIMCILAR (TOPLAM SATIŞLARIN YÜZDESİ)",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,"İletişim",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D45:$O45)","v":{"v":600,"d":"600.00"}}]
[null,"Eğitim",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(Dağıtımcılar[[#This Row],[1. Ay]:[12. Ay]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promosyonlar",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(Dağıtımcılar[[#This Row],[1. Ay]:[12. Ay]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Komisyon/İndirimler (Dağıtımcının Satışlarının Yüzdesi)",{"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(Dağıtımcılar[[#This Row],[1. Ay]:[12. Ay]])","v":666.75}]
[null,"Dağıtımcı Toplamı ₺(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,"PERAKENDE ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"PERAKENDECİ (TOPLAM SATIŞLARIN YÜZDESİ)",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,"İletişim",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Eğitim",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('Kanal Pazarlama Bütçesi'!$D52:$O52)","v":{"v":600,"d":"600.00"}}]
[null,"Promosyonlar",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('Kanal Pazarlama Bütçesi'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Komisyon/İndirimler (Perakende Satışların Yüzdesi)",{"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('Kanal Pazarlama Bütçesi'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Perakendeci Toplamı ₺(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,"MÜŞTERİ KAZANMA VE ELDE TUTMA (MKE) ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"MÜŞTERİ ALIMI VE BEKLETMESİ (MAB)"]
[null,"İnsan Kaynakları",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D59:$O59)","v":{"v":600,"d":"600.00"}}]
[null,"İletişim",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('Kanal Pazarlama Bütçesi'!$D60:$O60)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promosyonlar/Kuponlar",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"MAB Toplamı ₺(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,"DİĞER GİDER ÖĞELERİ","Ücret","1. Ay","2. Ay","3. Ay","4. Ay","5. Ay","6. Ay","7. Ay","8. Ay","9. Ay","10. Ay","11. Ay","12. Ay"]
[null,"DİĞER GİDERLER"]
[null,"Seyahat",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D65:$O65)","v":{"v":600,"d":"600.00"}}]
[null,"Altyapı (bilgisayar, telefon vb.)",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('Kanal Pazarlama Bütçesi'!$D66:$O66)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kanal Desteği",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Kanal Pazarlama Bütçesi'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Diğer Giderler Toplamı ₺(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,"TOPLAM PAZARLAMA BÜTÇESİ:",null,{"$f":"SUM(D34,Aracı[[#Totals],[1. Ay]],Dağıtımcılar[[#Totals],[1. Ay]],Perakendeci[[#Totals],[1. Ay]],ARABA[[#Totals],[1. Ay]],DiğerGiderler[[#Totals],[1. Ay]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(DiğerGiderler[[#Totals],[2. Ay]],ARABA[[#Totals],[2. Ay]],Perakendeci[[#Totals],[2. Ay]],Dağıtımcılar[[#Totals],[2. Ay]],Aracı[[#Totals],[2. Ay]],E34)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(DiğerGiderler[[#Totals],[3. Ay]],ARABA[[#Totals],[3. Ay]],Perakendeci[[#Totals],[3. Ay]],Dağıtımcılar[[#Totals],[3. Ay]],Aracı[[#Totals],[3. Ay]],F34)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(DiğerGiderler[[#Totals],[4. Ay]],ARABA[[#Totals],[4. Ay]],Perakendeci[[#Totals],[4. Ay]],Dağıtımcılar[[#Totals],[4. Ay]],Aracı[[#Totals],[4. Ay]],G34)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(DiğerGiderler[[#Totals],[5. Ay]],ARABA[[#Totals],[5. Ay]],Perakendeci[[#Totals],[5. Ay]],Dağıtımcılar[[#Totals],[5. Ay]],Aracı[[#Totals],[5. Ay]],H34)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(DiğerGiderler[[#Totals],[6. Ay]],ARABA[[#Totals],[6. Ay]],Perakendeci[[#Totals],[6. Ay]],Dağıtımcılar[[#Totals],[6. Ay]],Aracı[[#Totals],[6. Ay]],I34)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(DiğerGiderler[[#Totals],[7. Ay]],ARABA[[#Totals],[7. Ay]],Perakendeci[[#Totals],[7. Ay]],Dağıtımcılar[[#Totals],[7. Ay]],Aracı[[#Totals],[7. Ay]],J34)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(DiğerGiderler[[#Totals],[8. Ay]],ARABA[[#Totals],[8. Ay]],Perakendeci[[#Totals],[8. Ay]],Dağıtımcılar[[#Totals],[8. Ay]],Aracı[[#Totals],[8. Ay]],K34)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(DiğerGiderler[[#Totals],[9. Ay]],ARABA[[#Totals],[9. Ay]],Perakendeci[[#Totals],[9. Ay]],Dağıtımcılar[[#Totals],[9. Ay]],Aracı[[#Totals],[9. Ay]],L34)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(DiğerGiderler[[#Totals],[10. Ay]],ARABA[[#Totals],[10. Ay]],Perakendeci[[#Totals],[10. Ay]],Dağıtımcılar[[#Totals],[10. Ay]],Aracı[[#Totals],[10. Ay]],M34)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(DiğerGiderler[[#Totals],[11. Ay]],ARABA[[#Totals],[11. Ay]],Perakendeci[[#Totals],[11. Ay]],Dağıtımcılar[[#Totals],[11. Ay]],Aracı[[#Totals],[11. Ay]],N34)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(DiğerGiderler[[#Totals],[12. Ay]],ARABA[[#Totals],[12. Ay]],Perakendeci[[#Totals],[12. Ay]],Dağıtımcılar[[#Totals],[12. Ay]],Aracı[[#Totals],[12. Ay]],O34)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]