{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Pradžia","Rinkodaros kanalo biudžetas"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Pradžia","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"APIE ŠĮ ŠABLONĄ"]
[null,"Naudokite šį šabloną, norėdami sukurti rinkodaros kanalo biudžetą."]
[null,"Lentelėse įveskite kiekvieno mėnesio numatomą pardavimo apimtį ir kitą informaciją."]
[null,"Sumos apskaičiuojamos automatiškai ir atnaujinamos miniatiūrinės diagramos."]
[null,"Pastaba. "]
[null,"Papildomos instrukcijos pateikiamos darbalapio RINKODAROS KANALO BIUDŽETAS A stulpelyje. Šis tekstas buvo specialiai paslėptas. Norėdami pašalinti tekstą, pasirinkite A stulpelį, tada pasirinkite Naikinti. Norėdami nebeslėpti teksto, pasirinkite A stulpelį, tada pakeiskite šrifto spalvą."]
[null,"Norėdami sužinoti daugiau apie lenteles, lentelėje paspauskite SHIFT, tada – F10, pasirinkite parinktį LENTELĖ, tada pasirinkite ALTERNATYVUSIS TEKSTAS."]

{"sheet":"Rinkodaros kanalo biudžetas","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," ","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo",null,"Iš viso"]
[null,"NUMATOMA PARDAVIMO SUMA, (000) EUR"," ",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"}}]
["Lentelėje Darbuotojai, prasidedančioje langelyje dešinėje, įveskite informaciją. Kiekvieno mėnesio darbuotojų suma automatiškai apskaičiuojama lentelės pabaigoje, o metinė suma – Q9 langelyje. Miniatiūrinė diagrama atnaujinama S9 langelyje. Kitas nurodymas yra A10 langelyje.","Darbuotojų elementai","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"DARBUOTOJAI (PARDAVIMO SUMOS PROCENTAS)",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,"Žmogiškieji ištekliai – darbuotojų skaičius",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Žmogiškieji ištekliai – išlaidos",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('Rinkodaros kanalo biudžetas'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Komisiniai",{"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('Rinkodaros kanalo biudžetas'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Darbuotojų suma, (000) EUR",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,"TIESIOGINĖS RINKODAROS ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"TIESIOGINĖ RINKODARA (PARDAVIMO SUMOS PROCENTAS)",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,"Rinkodara telefonu (tiesioginio pardavimo procentas)",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,"Žmogiškieji ištekliai – darbuotojų skaičius",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('Rinkodaros kanalo biudžetas'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Infrastruktūros aptarnavimas",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Komisiniai",{"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('Rinkodaros kanalo biudžetas'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Mokymas",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Rinkodaros telefonu suma, (000) EUR",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,"INTERNETINĖS RINKODAROS ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"INTERNETINĖ RINKODARA (TIESIOGINIO PARDAVIMO PROCENTAS)",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,"Žmogiškieji ištekliai – darbuotojų skaičius",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('Rinkodaros kanalo biudžetas'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Svetainės kūrimas (vienkartinės išlaidos)",null,500,{"$nulls":12},{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Išteklių nuoma",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Palaikymas ir priežiūra",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$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('Rinkodaros kanalo biudžetas'!$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('Rinkodaros kanalo biudžetas'!$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('Rinkodaros kanalo biudžetas'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Internetinės rinkodaros suma, (000) EUR",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,"REKLAMINIO PAŠTO ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"REKLAMINIS PAŠTAS (TIESIOGINIO PARDAVIMO PROCENTAS)"]
[null,"Žmogiškieji ištekliai – išlaidos",{"$nulls":14},{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D30:$O30)","v":{"v":0,"d":"0.00"}}]
[null,"Medžiagos",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D31:$O31)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Pašto išlaidos",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Reklaminio pašto suma, EUR (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,"Tiesioginės rinkodaros suma, (000) EUR",null,{"$f":"SUM(ReklaminisPaštas[[#Totals],[1 mėnuo]],InternetinėRinkodara[[#Totals],[1 mėnuo]],TiesioginėRinkodara[[#Totals],[1 mėnuo]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[2 mėnuo]],InternetinėRinkodara[[#Totals],[2 mėnuo]],TiesioginėRinkodara[[#Totals],[2 mėnuo]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[3 mėnuo]],InternetinėRinkodara[[#Totals],[3 mėnuo]],TiesioginėRinkodara[[#Totals],[3 mėnuo]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[4 mėnuo]],InternetinėRinkodara[[#Totals],[4 mėnuo]],TiesioginėRinkodara[[#Totals],[4 mėnuo]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[5 mėnuo]],InternetinėRinkodara[[#Totals],[5 mėnuo]],TiesioginėRinkodara[[#Totals],[5 mėnuo]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[6 mėnuo]],InternetinėRinkodara[[#Totals],[6 mėnuo]],TiesioginėRinkodara[[#Totals],[6 mėnuo]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[7 mėnuo]],InternetinėRinkodara[[#Totals],[7 mėnuo]],TiesioginėRinkodara[[#Totals],[7 mėnuo]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[8 mėnuo]],InternetinėRinkodara[[#Totals],[8 mėnuo]],TiesioginėRinkodara[[#Totals],[8 mėnuo]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[9 mėnuo]],InternetinėRinkodara[[#Totals],[9 mėnuo]],TiesioginėRinkodara[[#Totals],[9 mėnuo]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[10 mėnuo]],InternetinėRinkodara[[#Totals],[10 mėnuo]],TiesioginėRinkodara[[#Totals],[10 mėnuo]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[11 mėnuo]],InternetinėRinkodara[[#Totals],[11 mėnuo]],TiesioginėRinkodara[[#Totals],[11 mėnuo]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(ReklaminisPaštas[[#Totals],[12 mėnuo]],InternetinėRinkodara[[#Totals],[12 mėnuo]],TiesioginėRinkodara[[#Totals],[12 mėnuo]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
[null,"AGENTO / BROKERIO ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"AGENTAS / BROKERIS (PARDAVIMO SUMOS PROCENTAS)",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,"Bendravimas",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D37:$O37)","v":{"v":600,"d":"600.00"}}]
[null,"Mokymas",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('Rinkodaros kanalo biudžetas'!$D38:$O38)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Reklama",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('Rinkodaros kanalo biudžetas'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Nuolaidos",{"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('Rinkodaros kanalo biudžetas'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Komisiniai (agento pardavimo procentas)",{"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('Rinkodaros kanalo biudžetas'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Agento / brokerio suma, (000) EUR",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,"PLATINTOJŲ ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"PLATINTOJAI (PARDAVIMO SUMOS PROCENTAS)",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,"Bendravimas",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D45:$O45)","v":{"v":600,"d":"600.00"}}]
[null,"Mokymas",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(Platintojai[[#This Row],[1 mėnuo]:[12 mėnuo]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Reklama",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(Platintojai[[#This Row],[1 mėnuo]:[12 mėnuo]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Komisiniai / nuolaidos (platintojų pardavimo procentas)",{"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(Platintojai[[#This Row],[1 mėnuo]:[12 mėnuo]])","v":666.75}]
[null,"Platintojų suma, (000) EUR",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,"MAŽMENINĖS PREKYBOS ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"PARDAVĖJAS (PARDAVIMO SUMOS PROCENTAS)",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,"Bendravimas",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Mokymas",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('Rinkodaros kanalo biudžetas'!$D52:$O52)","v":{"v":600,"d":"600.00"}}]
[null,"Reklama",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('Rinkodaros kanalo biudžetas'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Komisiniai / nuolaidos (pardavėjo pardavimo procentas)",{"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('Rinkodaros kanalo biudžetas'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Pardavėjo suma, (000) EUR",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,"KLIENTŲ ĮGIJIMO IR IŠLAIKYMO (KĮI) ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"KLIENTŲ ĮGIJIMAS IR IŠLAIKYMAS (KĮI)"]
[null,"Žmogiškieji ištekliai",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D59:$O59)","v":{"v":600,"d":"600.00"}}]
[null,"Ryšiai",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('Rinkodaros kanalo biudžetas'!$D60:$O60)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Akcijos / kuponai",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"KĮI suma, (000) EUR",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,"KITŲ IŠLAIDŲ ELEMENTAI","Tarifas","1 mėnuo","2 mėnuo","3 mėnuo","4 mėnuo","5 mėnuo","6 mėnuo","7 mėnuo","8 mėnuo","9 mėnuo","10 mėnuo","11 mėnuo","12 mėnuo"]
[null,"KITOS IŠLAIDOS"]
[null,"Kelionės",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D65:$O65)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastruktūra (kompiuteriai, telefonai ir kt.)",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('Rinkodaros kanalo biudžetas'!$D66:$O66)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kanalo palaikymas",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Rinkodaros kanalo biudžetas'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Kitų išlaidų suma, EUR (000)",null,{"$f":"SUM(D65:D67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E65:E67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(F65:F67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(G65:G67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(H65:H67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(I65:I67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(J65:J67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(K65:K67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(L65:L67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(M65:M67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(N65:N67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(O65:O67)","v":{"v":900,"d":"900.00"}},null,{"$f":"SUM(Q65:Q67)","v":{"v":10800,"d":"10,800.00"}}]
[]
[null,"BENDRAS RINKODAROS BIUDŽETAS:",null,{"$f":"SUM(D34,AgentasIrBrokeris[[#Totals],[1 mėnuo]],Platintojai[[#Totals],[1 mėnuo]],Pardavėjas[[#Totals],[1 mėnuo]],KĮI[[#Totals],[1 mėnuo]],Kitos_išlaidos[[#Totals],[1 mėnuo]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[2 mėnuo]],KĮI[[#Totals],[2 mėnuo]],Pardavėjas[[#Totals],[2 mėnuo]],Platintojai[[#Totals],[2 mėnuo]],AgentasIrBrokeris[[#Totals],[2 mėnuo]],E34)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[3 mėnuo]],KĮI[[#Totals],[3 mėnuo]],Pardavėjas[[#Totals],[3 mėnuo]],Platintojai[[#Totals],[3 mėnuo]],AgentasIrBrokeris[[#Totals],[3 mėnuo]],F34)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[4 mėnuo]],KĮI[[#Totals],[4 mėnuo]],Pardavėjas[[#Totals],[4 mėnuo]],Platintojai[[#Totals],[4 mėnuo]],AgentasIrBrokeris[[#Totals],[4 mėnuo]],G34)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[5 mėnuo]],KĮI[[#Totals],[5 mėnuo]],Pardavėjas[[#Totals],[5 mėnuo]],Platintojai[[#Totals],[5 mėnuo]],AgentasIrBrokeris[[#Totals],[5 mėnuo]],H34)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[6 mėnuo]],KĮI[[#Totals],[6 mėnuo]],Pardavėjas[[#Totals],[6 mėnuo]],Platintojai[[#Totals],[6 mėnuo]],AgentasIrBrokeris[[#Totals],[6 mėnuo]],I34)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[7 mėnuo]],KĮI[[#Totals],[7 mėnuo]],Pardavėjas[[#Totals],[7 mėnuo]],Platintojai[[#Totals],[7 mėnuo]],AgentasIrBrokeris[[#Totals],[7 mėnuo]],J34)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[8 mėnuo]],KĮI[[#Totals],[8 mėnuo]],Pardavėjas[[#Totals],[8 mėnuo]],Platintojai[[#Totals],[8 mėnuo]],AgentasIrBrokeris[[#Totals],[8 mėnuo]],K34)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[9 mėnuo]],KĮI[[#Totals],[9 mėnuo]],Pardavėjas[[#Totals],[9 mėnuo]],Platintojai[[#Totals],[9 mėnuo]],AgentasIrBrokeris[[#Totals],[9 mėnuo]],L34)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[10 mėnuo]],KĮI[[#Totals],[10 mėnuo]],Pardavėjas[[#Totals],[10 mėnuo]],Platintojai[[#Totals],[10 mėnuo]],AgentasIrBrokeris[[#Totals],[10 mėnuo]],M34)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[11 mėnuo]],KĮI[[#Totals],[11 mėnuo]],Pardavėjas[[#Totals],[11 mėnuo]],Platintojai[[#Totals],[11 mėnuo]],AgentasIrBrokeris[[#Totals],[11 mėnuo]],N34)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(Kitos_išlaidos[[#Totals],[12 mėnuo]],KĮI[[#Totals],[12 mėnuo]],Pardavėjas[[#Totals],[12 mėnuo]],Platintojai[[#Totals],[12 mėnuo]],AgentasIrBrokeris[[#Totals],[12 mėnuo]],O34)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]