{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Algus","Kanali turunduseelarve"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Algus","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"TEAVE SELLE MALLI KOHTA"]
[null,"Selle malli abil saate luua kanali turunduseelarve."]
[null,"Sisestage tabelitesse iga kuu prognoositud müük ja muud üksikasjad."]
[null,"Kogusummad arvutatakse ja minigraafikud värskendatakse automaatselt."]
[null,"Märkus. "]
[null,"Täiendavad juhised leiate töölehe KANALI TURUNDUSEELARVE veerust A. See tekst on tahtlikult peidetud. Teksti eemaldamiseks valige veerg A ja seejärel käsk KUSTUTA. Teksti kuvamiseks valige veerg A ja muutke seejärel fondi värvi."]
[null,"Tabelite kohta lisateabe saamiseks vajutage tabelis tõstuklahvi (SHIFT) ja seejärel klahvi F10, valige TABEL suvand ja seejärel käsk ASETEKST."]

{"sheet":"Kanali turunduseelarve","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Sellel töölehel saate luua kanali turunduseelarve. Paremal olevas lahtris on selle töölehe pealkiri. Selle veeru lahtritest leiate kasulikke juhiseid. Liikuge alustamiseks noolega alla. Paremal olevas lahtris on selle töölehe pealkiri.","KANALI TURUNDUSEELARVE"]
["Tasumäära ja kuude sildid on selle rea lahtrites C2–O2, kokku silt on lahtris Q2."," ","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu",null,"Kokku"]
["Prognoositud müük kokku silt on parempoolses lahtris. Sisestage lahtritesse D3–O3 iga kuu prognoositud müük. Kokku arvutatakse lahtris Q3 automaatselt.","PROGNOOSITUD MÜÜK KOKKU (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Töötajad. Töötajate kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q9. Minigraafik värskendatakse lahtris S9. Järgmised juhised on toodud lahtris A10.","Töötajate üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"TÖÖTAJAD (% KOGUMÜÜGIST)",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,"Personal – arv",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Personal – kulu",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('Kanali turunduseelarve'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Vahendustasu",{"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('Kanali turunduseelarve'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Töötajad kokku (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}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Otseturundus. Telefoniturundus kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q17. Minigraafik värskendatakse lahtris S17. Järgmised juhised on toodud lahtris A18.","Otseturunduse üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"OTSETURUNDUS (% KOGUMÜÜGIST)",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,"Telefoniturundus (% otsemüügist)",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,"Personal – arv",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('Kanali turunduseelarve'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Tugitaristu",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Kanali turunduseelarve'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Vahendustasu",{"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('Kanali turunduseelarve'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Koolitus",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Kanali turunduseelarve'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Telefoniturundus kokku (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Interneti-turundus. Interneti-turunduse kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q24. Minigraafik värskendatakse lahtris S24. Järgmised juhised on toodud lahtris A25.","Interneti-turunduse üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"Interneti-turundus (% otsemüügist)",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,"Personal – arv",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('Kanali turunduseelarve'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Veebilehe arendamine (ühekordne kulu)",null,500,{"$nulls":12},{"$f":"SUM('Kanali turunduseelarve'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Majutamine",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Kanali turunduseelarve'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Tugi ja hooldus",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Kanali turunduseelarve'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Interneti-turundus kokku (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Otsepost. Otseposti kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q30. Järgmised juhised on toodud lahtris A31."," Otseposti üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"Otsepost (% otsemüügist)"]
[null,"Personal – kulu",{"$nulls":14},{"$f":"SUM('Kanali turunduseelarve'!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Materjalid",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Kanali turunduseelarve'!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Postikulu",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Kanali turunduseelarve'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Otsepost kokku (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"}}]
["Otseturunduse kokku arvutatakse selle rea lahtrites D31–O31 ja aastane kokku lahtris Q31. Minigraafik värskendatakse lahtris S31.","Otseturundus kokku (000) €",null,{"$f":"SUM(Otsepost[[#Totals],[1. kuu]],Internetiturundus[[#Totals],[1. kuu]],Otseturundus[[#Totals],[1. kuu]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(Otsepost[[#Totals],[2. kuu]],Internetiturundus[[#Totals],[2. kuu]],Otseturundus[[#Totals],[2. kuu]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(Otsepost[[#Totals],[3. kuu]],Internetiturundus[[#Totals],[3. kuu]],Otseturundus[[#Totals],[3. kuu]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(Otsepost[[#Totals],[4. kuu]],Internetiturundus[[#Totals],[4. kuu]],Otseturundus[[#Totals],[4. kuu]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(Otsepost[[#Totals],[5. kuu]],Internetiturundus[[#Totals],[5. kuu]],Otseturundus[[#Totals],[5. kuu]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(Otsepost[[#Totals],[6. kuu]],Internetiturundus[[#Totals],[6. kuu]],Otseturundus[[#Totals],[6. kuu]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(Otsepost[[#Totals],[7. kuu]],Internetiturundus[[#Totals],[7. kuu]],Otseturundus[[#Totals],[7. kuu]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(Otsepost[[#Totals],[8. kuu]],Internetiturundus[[#Totals],[8. kuu]],Otseturundus[[#Totals],[8. kuu]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(Otsepost[[#Totals],[9. kuu]],Internetiturundus[[#Totals],[9. kuu]],Otseturundus[[#Totals],[9. kuu]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(Otsepost[[#Totals],[10. kuu]],Internetiturundus[[#Totals],[10. kuu]],Otseturundus[[#Totals],[10. kuu]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(Otsepost[[#Totals],[11. kuu]],Internetiturundus[[#Totals],[11. kuu]],Otseturundus[[#Totals],[11. kuu]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(Otsepost[[#Totals],[12. kuu]],Internetiturundus[[#Totals],[12. kuu]],Otseturundus[[#Totals],[12. kuu]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Agent ja Maakler. Agendi ja maakleri kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q39. Minigraafik värskendatakse lahtris S39. Järgmised juhised on toodud lahtris A40.","Agendi/maakleri üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"AGENT/MAAKLER (% KOGUMÜÜGIST)",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,"Suhtlemine",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanali turunduseelarve'!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Koolitus",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('Kanali turunduseelarve'!$D35:$O35)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kampaaniad",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('Kanali turunduseelarve'!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Allahindlused",{"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('Kanali turunduseelarve'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Vahendustasu (% agendi müügist)",{"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('Kanali turunduseelarve'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Agendid/maaklerid kokku (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Turustajad. Turustaja kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q46. Minigraafik värskendatakse lahtris S46. Järgmised juhised on toodud lahtris A47.","Turustaja üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"TURUSTAJAD (% KOGUMÜÜGIST)",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,"Suhtlemine",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanali turunduseelarve'!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Koolitus",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(Turustajad[[#This Row],[1. kuu]:[12. kuu]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kampaaniad",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(Turustajad[[#This Row],[1. kuu]:[12. kuu]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Vahendustasu/allahindlused (% turustajate müügist)",{"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(Turustajad[[#This Row],[1. kuu]:[12. kuu]])","v":666.75}]
[null,"Turustajad kokku (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Jaemüüja. Jaemüüjad kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q53. Minigraafik värskendatakse lahtris S53. Järgmised juhised on toodud lahtris A54.","Jaemüüja üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"JAEMÜÜJA (% KOGUMÜÜGIST)",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,"Suhtlemine",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Koolitus",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('Kanali turunduseelarve'!$D49:$O49)","v":{"v":600,"d":"600.00"}}]
[null,"Kampaaniad",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('Kanali turunduseelarve'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Vahendustasu/soodustused (% jaemüügist)",{"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('Kanali turunduseelarve'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Jaemüüjad kokku (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Klientide hankimine ja hoidmine (KHH). KHH kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q59. Minigraafik värskendatakse lahtris S59. Järgmised juhised on toodud lahtris A60.","Klientide hankimise ja säilitamise (KHH) üksused","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"KLIENTIDE HANKIMINE JA SÄILITAMINE (KHH)"]
[null,"Personal",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanali turunduseelarve'!$D56:$O56)","v":{"v":600,"d":"600.00"}}]
[null,"Suhtlus",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('Kanali turunduseelarve'!$D57:$O57)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kampaaniad/kupongid",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Kanali turunduseelarve'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"KHH kokku (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"}}]
["Sisestage üksikasjad parempoolsest lahtrist algavasse tabelisse Muud kulud. Muude kulude kokku arvutatakse iga kuu jaoks automaatselt tabeli lõpus ja aastane kokku lahtris Q65. Minigraafik värskendatakse lahtris S65. Järgmised juhised on toodud lahtris A67.","Muud kuluartiklid ","Tasumäär","1. kuu","2. kuu","3. kuu","4. kuu","5. kuu","6. kuu","7. kuu","8. kuu","9. kuu","10. kuu","11. kuu","12. kuu"]
[null,"MUUD KULUD"]
[null,"Reisimine",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Kanali turunduseelarve'!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Taristu (arvuti, telefoni jne).",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('Kanali turunduseelarve'!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kanali tugi",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Kanali turunduseelarve'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Muud kulud kokku (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"}}]
[]
["Turunduseelarve kokku arvutatakse iga kuu jaoks automaatselt selle rea lahtrites D67–O67 ja aastane kogusumma lahtris Q67. Minigraafik värskendatakse lahtris S67.","TURUNDUSEELARVE KOKKU:",null,{"$f":"SUM(MuudKulud[[#Totals],[1. kuu]],KHH[[#Totals],[1. kuu]],Jaemüüja[[#Totals],[1. kuu]],Turustajad[[#Totals],[1. kuu]],AgentJaMaakler[[#Totals],[1. kuu]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(MuudKulud[[#Totals],[2. kuu]],KHH[[#Totals],[2. kuu]],Jaemüüja[[#Totals],[2. kuu]],Turustajad[[#Totals],[2. kuu]],AgentJaMaakler[[#Totals],[2. kuu]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(MuudKulud[[#Totals],[3. kuu]],KHH[[#Totals],[3. kuu]],Jaemüüja[[#Totals],[3. kuu]],Turustajad[[#Totals],[3. kuu]],AgentJaMaakler[[#Totals],[3. kuu]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(MuudKulud[[#Totals],[4. kuu]],KHH[[#Totals],[4. kuu]],Jaemüüja[[#Totals],[4. kuu]],Turustajad[[#Totals],[4. kuu]],AgentJaMaakler[[#Totals],[4. kuu]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(MuudKulud[[#Totals],[5. kuu]],KHH[[#Totals],[5. kuu]],Jaemüüja[[#Totals],[5. kuu]],Turustajad[[#Totals],[5. kuu]],AgentJaMaakler[[#Totals],[5. kuu]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(MuudKulud[[#Totals],[6. kuu]],KHH[[#Totals],[6. kuu]],Jaemüüja[[#Totals],[6. kuu]],Turustajad[[#Totals],[6. kuu]],AgentJaMaakler[[#Totals],[6. kuu]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(MuudKulud[[#Totals],[7. kuu]],KHH[[#Totals],[7. kuu]],Jaemüüja[[#Totals],[7. kuu]],Turustajad[[#Totals],[7. kuu]],AgentJaMaakler[[#Totals],[7. kuu]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(MuudKulud[[#Totals],[8. kuu]],KHH[[#Totals],[8. kuu]],Jaemüüja[[#Totals],[8. kuu]],Turustajad[[#Totals],[8. kuu]],AgentJaMaakler[[#Totals],[8. kuu]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(MuudKulud[[#Totals],[9. kuu]],KHH[[#Totals],[9. kuu]],Jaemüüja[[#Totals],[9. kuu]],Turustajad[[#Totals],[9. kuu]],AgentJaMaakler[[#Totals],[9. kuu]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(MuudKulud[[#Totals],[10. kuu]],KHH[[#Totals],[10. kuu]],Jaemüüja[[#Totals],[10. kuu]],Turustajad[[#Totals],[10. kuu]],AgentJaMaakler[[#Totals],[10. kuu]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(MuudKulud[[#Totals],[11. kuu]],KHH[[#Totals],[11. kuu]],Jaemüüja[[#Totals],[11. kuu]],Turustajad[[#Totals],[11. kuu]],AgentJaMaakler[[#Totals],[11. kuu]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(MuudKulud[[#Totals],[12. kuu]],KHH[[#Totals],[12. kuu]],Jaemüüja[[#Totals],[12. kuu]],Turustajad[[#Totals],[12. kuu]],AgentJaMaakler[[#Totals],[12. kuu]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]