{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Začetek","Proračun za tržni kanal"],"not_rendered":{"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,"S to predlogo lahko ustvarite 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, znotraj tabele pritisnite SHIFT in nato F10, izberite možnost TABELA in nato izberite še NADOMESTNO BESEDILO."]

{"sheet":"Proračun za tržni kanal","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["V tem delovnem listu ustvarite proračun za tržni kanal. Naslov tega delovnega lista je v celici na desni strani. Navodila so v celicah v tem stolpcu. Puščica dol za začetek dela. Naslov tega delovnega lista je v celici na desni strani.","PRORAČUN ZA TRŽNI KANAL"]
["Oznake za stopnja in mesece so v tej vrstici, v celicah C2– O2, oznaka za skupni znesek pa je v celici Q2."," ","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,"Vsota"]
["Oznaka za pričakovani skupni znesek prodaje je v celici na desni strani. Pričakovano prodajo za posamezne mesece vnesite v celice D3–O3. Skupni znesek je samodejno izračunan v celici Q3.","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 vsota 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+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,"Č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}]
["Podrobnosti vnesite v tabelo »Neposredno trženje«, ki se začne v celici na desni. Skupni znesek telemarketinga za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q17. Grafikon sparkline je posodobljen v celici S17. Naslednje navodilo je v celici A18.","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"}}]
["Podrobnosti vnesite v tabelo »Interno trženje«, ki se začne v celici na desni. Skupni znesek internega trženja za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q24. Grafikon sparkline je posodobljen v celici S24. Naslednje navodilo je v celici A25.","Elementi internega 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,"Interno 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",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,"Skupni znesek internega trženja (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"}}]
["Podrobnosti vnesite v tabelo »Neposredna pošta«, ki se začne v celici na desni. Skupni znesek neposredne pošte za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q30. Naslednje navodilo je v celici A31."," 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'!$D27:$O27)","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'!$D28:$O28)","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'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Skupni znesek neposredne pošte (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"}}]
["Skupni znesek neposrednega trženja je samodejno izračunan v tej vrstici, v celicah D31–O31, letni skupni znesek pa v celici Q31. Grafikon sparkline je posodobljen v celici S31.","Skupni znesek neposrednega trženja (000) €",null,{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 1]],Interno_trženje[[#Totals],[Mesec 1]],Neposredno_trženje[[#Totals],[Mesec 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 2]],Interno_trženje[[#Totals],[Mesec 2]],Neposredno_trženje[[#Totals],[Mesec 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 3]],Interno_trženje[[#Totals],[Mesec 3]],Neposredno_trženje[[#Totals],[Mesec 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 4]],Interno_trženje[[#Totals],[Mesec 4]],Neposredno_trženje[[#Totals],[Mesec 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 5]],Interno_trženje[[#Totals],[Mesec 5]],Neposredno_trženje[[#Totals],[Mesec 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 6]],Interno_trženje[[#Totals],[Mesec 6]],Neposredno_trženje[[#Totals],[Mesec 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 7]],Interno_trženje[[#Totals],[Mesec 7]],Neposredno_trženje[[#Totals],[Mesec 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 8]],Interno_trženje[[#Totals],[Mesec 8]],Neposredno_trženje[[#Totals],[Mesec 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 9]],Interno_trženje[[#Totals],[Mesec 9]],Neposredno_trženje[[#Totals],[Mesec 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 10]],Interno_trženje[[#Totals],[Mesec 10]],Neposredno_trženje[[#Totals],[Mesec 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 11]],Interno_trženje[[#Totals],[Mesec 11]],Neposredno_trženje[[#Totals],[Mesec 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(Neposredna_pošta[[#Totals],[Mesec 12]],Interno_trženje[[#Totals],[Mesec 12]],Neposredno_trženje[[#Totals],[Mesec 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Podrobnosti vnesite v tabelo »Zastopnik in posrednik«, ki se začne v celici na desni. Skupni znesek zastopnika in posrednika za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q39. Grafikon sparkline je posodobljen v celici S39. Naslednje navodilo je v celici A40.","Elementi zastopnika in 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'!$D34:$O34)","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'!$D35:$O35)","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'!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Popusti",{"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('Proračun za tržni kanal'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Provizija (% prodaje zastopnika)",{"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('Proračun za tržni kanal'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Skupni znesek zastopnika/posrednika (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"}}]
["Podrobnosti vnesite v tabelo »Distributerji«, ki se začne v celici na desni. Skupni znesek distributerja za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q46. Grafikon sparkline je posodobljen v celici S46. Naslednje navodilo je v celici A47.","Elementi distributerja","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'!$D42:$O42)","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*D41*$C$45","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(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"}}]
["Podrobnosti vnesite v tabelo za prodajalce, ki se začne v celici na desni. Skupni znesek prodajalca za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q53. Grafikon sparkline je posodobljen v celici S53. Naslednje navodilo je v celici A54.","Elementi prodajalca","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'!$D49:$O49)","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'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Provizija/popusti (% prodaje v trgovini)",{"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('Proračun za tržni kanal'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Skupni znesek prodajalca (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"}}]
["Podrobnosti vnesite v tabelo »Pridobivanje in ohranjanje strank«, ki se začne v celici na desni. Skupni znesek pridobivanja in ohranjanja strank za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q59. Grafikon sparkline je posodobljen v celici S59. Naslednje navodilo je v celici A60.","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'!$D56:$O56)","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'!$D57:$O57)","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'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Skupni znesek pridobivanja in ohranjanja strank (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"}}]
["Podrobnosti vnesite v tabelo »Drugi stroški«, ki se začne v celici na desni. Skupni znesek drugih stroškov za posamezne mesece je samodejno izračunan na koncu tabele, letni vsota znesek pa je izračunan v celici Q65. Grafikon sparkline je posodobljen v celici S65. Naslednje navodilo je v celici A67.","Elementi drugih 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'!$D62:$O62)","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'!$D63:$O63)","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'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Skupni znesek drugih stroškov (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"}}]
[]
["Skupni proračun za trženje za posamezne mesece je samodejno izračunan v tej vrstici, v celicah D67–O67, letni skupni znesek pa v celici Q67. Grafikon sparkline je samodejno posodobljen v celici S67.","SKUPNI PRORAČUN ZA TRŽENJE:",null,{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 1]],Avtomobil[[#Totals],[Mesec 1]],Prodajalec[[#Totals],[Mesec 1]],Distributorji[[#Totals],[Mesec 1]],ZastopnikInPosrednik[[#Totals],[Mesec 1]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 2]],Avtomobil[[#Totals],[Mesec 2]],Prodajalec[[#Totals],[Mesec 2]],Distributorji[[#Totals],[Mesec 2]],ZastopnikInPosrednik[[#Totals],[Mesec 2]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 3]],Avtomobil[[#Totals],[Mesec 3]],Prodajalec[[#Totals],[Mesec 3]],Distributorji[[#Totals],[Mesec 3]],ZastopnikInPosrednik[[#Totals],[Mesec 3]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 4]],Avtomobil[[#Totals],[Mesec 4]],Prodajalec[[#Totals],[Mesec 4]],Distributorji[[#Totals],[Mesec 4]],ZastopnikInPosrednik[[#Totals],[Mesec 4]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 5]],Avtomobil[[#Totals],[Mesec 5]],Prodajalec[[#Totals],[Mesec 5]],Distributorji[[#Totals],[Mesec 5]],ZastopnikInPosrednik[[#Totals],[Mesec 5]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 6]],Avtomobil[[#Totals],[Mesec 6]],Prodajalec[[#Totals],[Mesec 6]],Distributorji[[#Totals],[Mesec 6]],ZastopnikInPosrednik[[#Totals],[Mesec 6]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 7]],Avtomobil[[#Totals],[Mesec 7]],Prodajalec[[#Totals],[Mesec 7]],Distributorji[[#Totals],[Mesec 7]],ZastopnikInPosrednik[[#Totals],[Mesec 7]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 8]],Avtomobil[[#Totals],[Mesec 8]],Prodajalec[[#Totals],[Mesec 8]],Distributorji[[#Totals],[Mesec 8]],ZastopnikInPosrednik[[#Totals],[Mesec 8]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 9]],Avtomobil[[#Totals],[Mesec 9]],Prodajalec[[#Totals],[Mesec 9]],Distributorji[[#Totals],[Mesec 9]],ZastopnikInPosrednik[[#Totals],[Mesec 9]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 10]],Avtomobil[[#Totals],[Mesec 10]],Prodajalec[[#Totals],[Mesec 10]],Distributorji[[#Totals],[Mesec 10]],ZastopnikInPosrednik[[#Totals],[Mesec 10]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 11]],Avtomobil[[#Totals],[Mesec 11]],Prodajalec[[#Totals],[Mesec 11]],Distributorji[[#Totals],[Mesec 11]],ZastopnikInPosrednik[[#Totals],[Mesec 11]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(Drugi_stroški[[#Totals],[Mesec 12]],Avtomobil[[#Totals],[Mesec 12]],Prodajalec[[#Totals],[Mesec 12]],Distributorji[[#Totals],[Mesec 12]],ZastopnikInPosrednik[[#Totals],[Mesec 12]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]