{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Začetek","Proračun za tržni kanal"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Začetek","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"O TEJ PREDLOGI"]
[null,"To predlogo uporabite, če želite ustvariti proračun za tržni kanal."]
[null,"V tabele vnesite pričakovano prodajo in druge podrobnosti za posamezne mesece."]
[null,"Skupni zneski so samodejno izračunani in grafikoni sparkline so posodobljeni."]
[null,"Opomba: "]
[null,"Dodatna navodila so na voljo v stolpcu A na delovnem listu PRORAČUN ZA TRŽNI KANAL. To besedilo je bilo skrito namenoma. Če želite besedilo premakniti, izberite stolpec A, nato izberite še IZBRIŠI. Če želite besedilo razkriti, izberite stolpec A, nato zamenjajte barvo pisave."]
[null,"Če želite izvedeti več o tabelah, v tabeli pritisnite tipko SHIFT in nato F10, izberite možnost TABELA, nato pa še NADOMESTNO BESEDILO."]

{"sheet":"Proračun za tržni kanal","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," ","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12",null,"Skupaj"]
[null,"PRIČAKOVANI SKUPNI ZNESEK PRODAJE (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"}}]
["Podrobnosti vnesite v tabelo »Osebje«, ki se začne v celici na desni. Skupni znesek osebja za posamezne mesece je samodejno izračunan na koncu tabele, letni skupni znesek pa je izračunan v celici Q9. Grafikon sparkline je posodobljen v celici S9. Naslednje navodilo je v celici A10.","Elementi osebja","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"OSEBJE (% SKUPNE PRODAJE)",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,"Človeški viri – število",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Človeški viri – stroški",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('Proračun za tržni kanal'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Provizija",{"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('Proračun za tržni kanal'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Skupni znesek osebja (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,"ELEMENTI NEPOSREDNEGA TRŽENJA","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"NEPOSREDNO TRŽENJE (% SKUPNE PRODAJE)",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 (% neposredne prodaje)",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,"Človeški viri – število",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('Proračun za tržni kanal'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Infrastruktura",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Proračun za tržni kanal'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Provizija",{"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('Proračun za tržni kanal'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Izobraževanje",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Proračun za tržni kanal'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Skupni znesek telemarketinga (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,"ELEMENTI INTERNETNEGA TRŽENJA","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"INTERNETNO TRŽENJE (% NEPOSREDNE PRODAJE)",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,"Človeški viri – število zaposlenih",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('Proračun za tržni kanal'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Razvoj spletnih mest (enkratni strošek)",null,500,{"$nulls":12},{"$f":"SUM('Proračun za tržni kanal'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Gostovanje",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Proračun za tržni kanal'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Podpora in vzdrževanje",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Proračun za tržni kanal'!$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('Proračun za tržni kanal'!$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('Proračun za tržni kanal'!$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('Proračun za tržni kanal'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Skupni znesek internega trženja (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,"ELEMENTI NEPOSREDNE POŠTE","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"NEPOSREDNA POŠTA (% NEPOSREDNE PRODAJE)"]
[null,"Človeški viri – stroški",{"$nulls":14},{"$f":"SUM('Proračun za tržni kanal'!$D30:$O30)","v":{"v":0,"d":"0.00"}}]
[null,"Gradivo",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Proračun za tržni kanal'!$D31:$O31)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Poštnina",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Proračun za tržni kanal'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Skupni znesek neposredne pošte (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,"Skupni znesek neposrednega trženja (000) €",null,{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 1]],Spletni_marketing[[#Totals],[Mesec 1]],Neposredni_marketing[[#Totals],[Mesec 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 2]],Spletni_marketing[[#Totals],[Mesec 2]],Neposredni_marketing[[#Totals],[Mesec 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 3]],Spletni_marketing[[#Totals],[Mesec 3]],Neposredni_marketing[[#Totals],[Mesec 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 4]],Spletni_marketing[[#Totals],[Mesec 4]],Neposredni_marketing[[#Totals],[Mesec 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 5]],Spletni_marketing[[#Totals],[Mesec 5]],Neposredni_marketing[[#Totals],[Mesec 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 6]],Spletni_marketing[[#Totals],[Mesec 6]],Neposredni_marketing[[#Totals],[Mesec 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 7]],Spletni_marketing[[#Totals],[Mesec 7]],Neposredni_marketing[[#Totals],[Mesec 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 8]],Spletni_marketing[[#Totals],[Mesec 8]],Neposredni_marketing[[#Totals],[Mesec 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 9]],Spletni_marketing[[#Totals],[Mesec 9]],Neposredni_marketing[[#Totals],[Mesec 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 10]],Spletni_marketing[[#Totals],[Mesec 10]],Neposredni_marketing[[#Totals],[Mesec 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 11]],Spletni_marketing[[#Totals],[Mesec 11]],Neposredni_marketing[[#Totals],[Mesec 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 12]],Spletni_marketing[[#Totals],[Mesec 12]],Neposredni_marketing[[#Totals],[Mesec 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,"ELEMENTI ZASTOPNIKA/POSREDNIKA","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"ZASTOPNIK/POSREDNIK (% SKUPNE PRODAJE)",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,"Komunikacija",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Proračun za tržni kanal'!$D37:$O37)","v":{"v":600,"d":"600.00"}}]
[null,"Izobraževanje",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('Proračun za tržni kanal'!$D38:$O38)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promocije",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('Proračun za tržni kanal'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Popusti",{"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('Proračun za tržni kanal'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Provizija (% prodaje zastopnika)",{"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('Proračun za tržni kanal'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Skupni znesek zastopnika/posrednika (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,"ELEMENTI DISTRIBUTERJEV","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"DISTRIBUTERJI (% SKUPNE PRODAJE)",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,"Komunikacija",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Proračun za tržni kanal'!$D45:$O45)","v":{"v":600,"d":"600.00"}}]
[null,"Izobraževanje",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(Distributorji[[#This Row],[Mesec 1]:[Mesec 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promocije",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(Distributorji[[#This Row],[Mesec 1]:[Mesec 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Provizija/popusti (% prodaje distributerjev)",{"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(Distributorji[[#This Row],[Mesec 1]:[Mesec 12]])","v":666.75}]
[null,"Skupni znesek distributerja (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,"MALOPRODAJNI IZDELKI","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"PRODAJALEC (% SKUPNE PRODAJE)",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,"Komunikacija",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Izobraževanje",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('Proračun za tržni kanal'!$D52:$O52)","v":{"v":600,"d":"600.00"}}]
[null,"Promocije",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('Proračun za tržni kanal'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Provizija/popusti (% prodaje v trgovini)",{"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('Proračun za tržni kanal'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Skupni znesek prodajalca (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,"ELEMENTI PRIDOBIVANJA IN OHRANJANJA STRANK ","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"PRIDOBIVANJE IN OHRANJANJE STRANK"]
[null,"Človeški viri",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Proračun za tržni kanal'!$D59:$O59)","v":{"v":600,"d":"600.00"}}]
[null,"Komunikacija",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('Proračun za tržni kanal'!$D60:$O60)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promocije/kuponi",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Proračun za tržni kanal'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Skupni znesek pridobivanja in ohranjanja strank (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,"DRUGI ELEMENTI STROŠKOV","Stopnja","Mesec 1","Mesec 2","Mesec 3","Mesec 4","Mesec 5","Mesec 6","Mesec 7","Mesec 8","Mesec 9","Mesec 10","Mesec 11","Mesec 12"]
[null,"DRUGI STROŠKI"]
[null,"Potovanja",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Proračun za tržni kanal'!$D65:$O65)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastruktura (računalnik, telefon itd.)",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('Proračun za tržni kanal'!$D66:$O66)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Podpora za kanal",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Proračun za tržni kanal'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Skupni znesek drugih stroškov (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,"SKUPNI PRORAČUN ZA TRŽENJE:",null,{"$f":"SUM(D34,Zastopnik_in_posrednik[[#Totals],[Mesec 1]],Distributorji[[#Totals],[Mesec 1]],Prodajalec[[#Totals],[Mesec 1]],CAR[[#Totals],[Mesec 1]],Drugi_stroški[[#Totals],[Mesec 1]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(E34,Zastopnik_in_posrednik[[#Totals],[Mesec 2]],Distributorji[[#Totals],[Mesec 2]],Prodajalec[[#Totals],[Mesec 2]],CAR[[#Totals],[Mesec 2]],Drugi_stroški[[#Totals],[Mesec 2]])","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(F34,Zastopnik_in_posrednik[[#Totals],[Mesec 3]],Distributorji[[#Totals],[Mesec 3]],Prodajalec[[#Totals],[Mesec 3]],CAR[[#Totals],[Mesec 3]],Drugi_stroški[[#Totals],[Mesec 3]])","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(G34,Zastopnik_in_posrednik[[#Totals],[Mesec 4]],Distributorji[[#Totals],[Mesec 4]],Prodajalec[[#Totals],[Mesec 4]],CAR[[#Totals],[Mesec 4]],Drugi_stroški[[#Totals],[Mesec 4]])","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(H34,Zastopnik_in_posrednik[[#Totals],[Mesec 5]],Distributorji[[#Totals],[Mesec 5]],Prodajalec[[#Totals],[Mesec 5]],CAR[[#Totals],[Mesec 5]],Drugi_stroški[[#Totals],[Mesec 5]])","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(I34,Zastopnik_in_posrednik[[#Totals],[Mesec 6]],Distributorji[[#Totals],[Mesec 6]],Prodajalec[[#Totals],[Mesec 6]],CAR[[#Totals],[Mesec 6]],Drugi_stroški[[#Totals],[Mesec 6]])","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(J34,Zastopnik_in_posrednik[[#Totals],[Mesec 7]],Distributorji[[#Totals],[Mesec 7]],Prodajalec[[#Totals],[Mesec 7]],CAR[[#Totals],[Mesec 7]],Drugi_stroški[[#Totals],[Mesec 7]])","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(K34,Zastopnik_in_posrednik[[#Totals],[Mesec 8]],Distributorji[[#Totals],[Mesec 8]],Prodajalec[[#Totals],[Mesec 8]],CAR[[#Totals],[Mesec 8]],Drugi_stroški[[#Totals],[Mesec 8]])","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(L34,Zastopnik_in_posrednik[[#Totals],[Mesec 9]],Distributorji[[#Totals],[Mesec 9]],Prodajalec[[#Totals],[Mesec 9]],CAR[[#Totals],[Mesec 9]],Drugi_stroški[[#Totals],[Mesec 9]])","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(M34,Zastopnik_in_posrednik[[#Totals],[Mesec 10]],Distributorji[[#Totals],[Mesec 10]],Prodajalec[[#Totals],[Mesec 10]],CAR[[#Totals],[Mesec 10]],Drugi_stroški[[#Totals],[Mesec 10]])","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(N34,Zastopnik_in_posrednik[[#Totals],[Mesec 11]],Distributorji[[#Totals],[Mesec 11]],Prodajalec[[#Totals],[Mesec 11]],CAR[[#Totals],[Mesec 11]],Drugi_stroški[[#Totals],[Mesec 11]])","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(O34,Zastopnik_in_posrednik[[#Totals],[Mesec 12]],Distributorji[[#Totals],[Mesec 12]],Prodajalec[[#Totals],[Mesec 12]],CAR[[#Totals],[Mesec 12]],Drugi_stroški[[#Totals],[Mesec 12]])","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]