{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Početak","Budžet marketinga kanala"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Početak","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"OSNOVNI PODACI O OVOM PREDLOŠKU"]
[null,"Koristite ovaj predložak da biste kreirali budžet marketinga kanala."]
[null,"Unesite očekivanu prodaju za svaki mesec i druge detalje u tabelama."]
[null,"Ukupne vrednosti se automatski izračunavaju i mini-grafikoni se ažuriraju."]
[null,"Napomena: "]
[null,"Dodatna uputstva navedena su u koloni A na radnom listu „BUDŽET MARKETINGA KANALA“. Taj tekst je namerno skriven. Da biste uklonili tekst, izaberite kolonu A, a zatim izaberite stavku „IZBRIŠI“. Da biste otkrili tekst, izaberite kolonu A, a zatim promenite boju fonta."]
[null,"Da biste saznali više o tabelama, pritisnite taster SHIFT, a zatim unutar tabele pritisnite taster F10, izaberite opciju „TABELA“, a zatim stavku „ALTERNATIVNI TEKST“."]

{"sheet":"Budžet marketinga kanala","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Kreiranje budžet marketinga kanala u ovom radnom listu. Naslov ovog radnog lista nalazi se u ćeliji sa desne strane. Korisna uputstva su u ćelijama u ovoj koloni. Pritisnite strelicu nadole da biste počeli. Naslov ovog radnog lista nalazi se u ćeliji sa desne strane.","BUDŽET MARKETINGA KANALA"]
["Cena Stopa i Mesec nalaze se u ovom redu, od ćelija C2 do O2 i oznaka Zbir u ćeliji Q2."," ","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec",null,"Zbir"]
["Oznaka Zbir vrednost očekivane prodaje nalazi se u ćeliji u desnom uglu. Unesite očekivanu prodaju za svaki mesec u ćelije D3 do O3. Zbir se automatski izračunava u ćeliji Q3.","Zbir VREDNOST OČEKIVANE PRODAJE RSD(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"}}]
["Unesite detalje u tabelu Osoblje počevši od ćelije sa desne strane. Zbir osoblje za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost za osobile u ćeliji Q9. Mini-grafikon se ažurira u ćeliji S9. Sledeće uputstvo se nalazi u ćeliji A10.","Stavke osoblja","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"OSOBLJE (% UKUPNE 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,"Ljudski resursi – brojanje",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Ljudski resursi – trošak",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('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Zbir vrednost za osoblje RSD(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}]
["Unesite detalje u tabelu Direktni marketing počevši od ćelije sa desne strane. Zbir za reklamiranje preko telefona za svaki mesec automatski se izračunava na kraju tabele i godišnja zbir vrednost u ćeliji Q17. Mini-grafikon se ažurira u ćeliji S17. Sledeće uputstvo se nalazi u ćeliji A18.","Stavke direktnog marketinga","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"DIREKTNI MARKETING (% UKUPNE 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,"Reklamiranje preko telefona (% direktne 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,"Ljudski resursi – brojanje",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('Budžet marketinga kanala'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Podrška infrastrukture",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Obuka",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Budžet marketinga kanala'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Zbir za reklamiranje preko telefona RSD(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"}}]
["Unesite detalje u tabelu Internet marketing počevši od ćelije sa desne strane. Zbir vrednost za internet marketing za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q24. Mini-grafikon se ažurira u ćeliji S24. Sledeće uputstvo se nalazi u ćeliji A25.","Stavke internet marketinga","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"Internet Marketing (% direktne 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,"Ljudski resursi – brojanje",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('Budžet marketinga kanala'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Izrada veb sajtova (jednokratni trošak)",null,500,{"$nulls":12},{"$f":"SUM('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Podrška i održavanje",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Budžet marketinga kanala'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Zbir vrednost za internet marketing RSD(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"}}]
["Unesite detalje u tabelu Direktna pošta počevši od ćelije sa desne strane. Zbir vrednost direktne pošte za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q30. Sledeće uputstvo se nalazi u ćeliji A31."," Stavke direktne pošte","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"Direktna pošta (% direktne prodaje)"]
[null,"Ljudski resursi – trošak",{"$nulls":14},{"$f":"SUM('Budžet marketinga kanala'!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Materijal",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Budžet marketinga kanala'!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Poštarina",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Budžet marketinga kanala'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Zbir vrednost direktne pošte RSD(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"}}]
["Zbir vrednost direktnog marketinga automatski se izračunava u ovom redu, od ćelija D31 do O31, a godišnja Zbir vrednost u ćeliji Q31. Mini-grafikon se ažurira u ćeliji S31.","Zbir vrednost direktnog marketinga RSD(000)",null,{"$f":"SUM(Direktna_pošta[[#Totals],[1. mesec]],Internet_marketing[[#Totals],[1. mesec]],Direktni_marketing[[#Totals],[1. mesec]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(Direktna_pošta[[#Totals],[2. mesec]],Internet_marketing[[#Totals],[2. mesec]],Direktni_marketing[[#Totals],[2. mesec]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(Direktna_pošta[[#Totals],[3. mesec]],Internet_marketing[[#Totals],[3. mesec]],Direktni_marketing[[#Totals],[3. mesec]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(Direktna_pošta[[#Totals],[4. mesec]],Internet_marketing[[#Totals],[4. mesec]],Direktni_marketing[[#Totals],[4. mesec]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(Direktna_pošta[[#Totals],[5. mesec]],Internet_marketing[[#Totals],[5. mesec]],Direktni_marketing[[#Totals],[5. mesec]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(Direktna_pošta[[#Totals],[6. mesec]],Internet_marketing[[#Totals],[6. mesec]],Direktni_marketing[[#Totals],[6. mesec]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(Direktna_pošta[[#Totals],[7. mesec]],Internet_marketing[[#Totals],[7. mesec]],Direktni_marketing[[#Totals],[7. mesec]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(Direktna_pošta[[#Totals],[8. mesec]],Internet_marketing[[#Totals],[8. mesec]],Direktni_marketing[[#Totals],[8. mesec]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(Direktna_pošta[[#Totals],[9. mesec]],Internet_marketing[[#Totals],[9. mesec]],Direktni_marketing[[#Totals],[9. mesec]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(Direktna_pošta[[#Totals],[10. mesec]],Internet_marketing[[#Totals],[10. mesec]],Direktni_marketing[[#Totals],[10. mesec]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(Direktna_pošta[[#Totals],[11. mesec]],Internet_marketing[[#Totals],[11. mesec]],Direktni_marketing[[#Totals],[11. mesec]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(Direktna_pošta[[#Totals],[12. mesec]],Internet_marketing[[#Totals],[12. mesec]],Direktni_marketing[[#Totals],[12. mesec]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Unesite detalje u tabelu Agent i broker počevši od ćelije sa desne strane. Zbir vrednost za agente i brokere za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q39. Mini-grafikon se ažurira u ćeliji S39. Sledeće uputstvo se nalazi u ćeliji A40.","Stavke Agent/broker","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"AGENT/BROKER (% UKUPNE 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('Budžet marketinga kanala'!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Obuka",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('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Provizija (% prodaje agenta)",{"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('Budžet marketinga kanala'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Zbir vrednost u RSD(000) za agente/brokere",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"}}]
["Unesite detalje u tabelu Distributeri počevši od ćelije sa desne strane. Zbir vrednost za distributere za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q46. Mini-grafikon se ažurira u ćeliji S46. Sledeće uputstvo se nalazi u ćeliji A47.","Stavke distributera","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"DISTRIBUTERI (% UKUPNE 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('Budžet marketinga kanala'!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Obuka",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(Distributeri[[#This Row],[1. mesec]:[12. mesec]])","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(Distributeri[[#This Row],[1. mesec]:[12. mesec]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Provizije/popusti (% prodaje distributera)",{"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(Distributeri[[#This Row],[1. mesec]:[12. mesec]])","v":666.75}]
[null,"Zbir vrednost za distributere RSD(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"}}]
["Unesite detalje u tabelu Prodavac počevši od ćelije sa desne strane. Zbir vrednost za prodavca za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q53. Mini-grafikon se ažurira u ćeliji S53. Sledeće uputstvo se nalazi u ćeliji A54.","Stavke prodavca","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"PRODAVAC (% UKUPNE 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,"Obuka",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('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Provizije/popusti (% od prodaje)",{"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('Budžet marketinga kanala'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Zbir vrednost za prodavca RSD(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"}}]
["Unesite detalje u tabelu Pribavljanje i zadržavanje klijenata počevši od ćelije u desnom uglu. Zbir vrednost za CAR za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q59. Mini-grafikon se ažurira u ćeliji S59. Sledeće uputstvo se nalazi u ćeliji A60.","Stavke kupca akvizicija i zadržavanje (auto)","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"PRONALAŽENJE I ZADRŽAVANJE KLIJENATA (CAR)"]
[null,"Ljudski resursi",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$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('Budžet marketinga kanala'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Zbir vrednost za CAR RSD(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"}}]
["Unesite detalje u tabelu Ostali troškovi počevši od ćelije sa desne strane. Zbir vrednost za ostale troškove za svaki mesec se automatski izračunava na kraju tabele i godišnja Zbir vrednost u ćeliji Q65. Mini-grafikon se ažurira u ćeliji S65. Sledeće uputstvo se nalazi u ćeliji A67.","Stavke drugih troškova ","Cena","1. mesec","2. mesec","3. mesec","4. mesec","5. mesec","6. mesec","7. mesec","8. mesec","9. mesec","10. mesec","11. mesec","12. mesec"]
[null,"OSTALI TROŠKOVI"]
[null,"Putovanja",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Budžet marketinga kanala'!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastruktura (računar, 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('Budžet marketinga kanala'!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Podrška kanala",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Budžet marketinga kanala'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Zbir vrednost za ostale troškove RSD(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"}}]
[]
["Zbir vrednost budžeta marketinga se automatski izračunava za svaki mesec u ovom redu, od ćelija D67 do O67, a Zbir godišnja vrednost u ćeliji Q67. Mini-grafikon se automatski ažurira u ćeliji S67.","Zbir VREDNOST BUDŽETA MARKETINGA:",null,{"$f":"SUM(Drugi_troškovi[[#Totals],[1. mesec]],AUTOMOBIL[[#Totals],[1. mesec]],Prodavac[[#Totals],[1. mesec]],Distributeri[[#Totals],[1. mesec]],Agenti_i_brokeri[[#Totals],[1. mesec]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[2. mesec]],AUTOMOBIL[[#Totals],[2. mesec]],Prodavac[[#Totals],[2. mesec]],Distributeri[[#Totals],[2. mesec]],Agenti_i_brokeri[[#Totals],[2. mesec]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[2. mesec]],AUTOMOBIL[[#Totals],[2. mesec]],Prodavac[[#Totals],[2. mesec]],Distributeri[[#Totals],[2. mesec]],Agenti_i_brokeri[[#Totals],[2. mesec]],F31)","v":{"v":5815.9375,"d":"5,815.94"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[3. mesec]],AUTOMOBIL[[#Totals],[3. mesec]],Prodavac[[#Totals],[3. mesec]],Distributeri[[#Totals],[3. mesec]],Agenti_i_brokeri[[#Totals],[3. mesec]],G31)","v":{"v":5804.55,"d":"5,804.55"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[3. mesec]],AUTOMOBIL[[#Totals],[3. mesec]],Prodavac[[#Totals],[3. mesec]],Distributeri[[#Totals],[3. mesec]],Agenti_i_brokeri[[#Totals],[3. mesec]],H31)","v":{"v":5834.448,"d":"5,834.45"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[4. mesec]],AUTOMOBIL[[#Totals],[4. mesec]],Prodavac[[#Totals],[4. mesec]],Distributeri[[#Totals],[4. mesec]],Agenti_i_brokeri[[#Totals],[4. mesec]],I31)","v":{"v":5901.9375,"d":"5,901.94"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[4. mesec]],AUTOMOBIL[[#Totals],[4. mesec]],Prodavac[[#Totals],[4. mesec]],Distributeri[[#Totals],[4. mesec]],Agenti_i_brokeri[[#Totals],[4. mesec]],J31)","v":{"v":5931.9,"d":"5,931.90"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[5. mesec]],AUTOMOBIL[[#Totals],[5. mesec]],Prodavac[[#Totals],[5. mesec]],Distributeri[[#Totals],[5. mesec]],Agenti_i_brokeri[[#Totals],[5. mesec]],K31)","v":{"v":5886.24,"d":"5,886.24"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[5. mesec]],AUTOMOBIL[[#Totals],[5. mesec]],Prodavac[[#Totals],[5. mesec]],Distributeri[[#Totals],[5. mesec]],Agenti_i_brokeri[[#Totals],[5. mesec]],L31)","v":{"v":5916.2,"d":"5,916.20"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[6. mesec]],AUTOMOBIL[[#Totals],[6. mesec]],Prodavac[[#Totals],[6. mesec]],Distributeri[[#Totals],[6. mesec]],Agenti_i_brokeri[[#Totals],[6. mesec]],M31)","v":{"v":5935.55,"d":"5,935.55"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[6. mesec]],AUTOMOBIL[[#Totals],[6. mesec]],Prodavac[[#Totals],[6. mesec]],Distributeri[[#Totals],[6. mesec]],Agenti_i_brokeri[[#Totals],[6. mesec]],N31)","v":{"v":5990.55,"d":"5,990.55"}},{"$f":"SUM(Drugi_troškovi[[#Totals],[7. mesec]],AUTOMOBIL[[#Totals],[7. mesec]],Prodavac[[#Totals],[7. mesec]],Distributeri[[#Totals],[7. mesec]],Agenti_i_brokeri[[#Totals],[7. mesec]],O31)","v":{"v":5946.8,"d":"5,946.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71103.963,"d":"71,103.96"}}]