ANDMETÖÖTLUS EXCELIS (0)

Overview

Tellimused
Kliendid
Tooted ja soodustus

Sheet 1: Tellimused

Kuupäev Tellija Toode Kogus Tellimuse
summa Toote
ühiku hind Summa
soodustusteta Soodustus
tellitud kogusest Kliendi
soodustus Soodustus %
kokku Soodustus
kokku



2/22/2013 MegaMart Leib 58 42.98 € 0.78 € 45.24 € 0.00% 5.00% 5.00% 2.26 €

Kuupäev Tellija Toode Kogus
3/17/2013 FoodMart Leib 101 74.84 € 0.78 € 78.78 € 2.00% 3.00% 5.00% 3.94 €
Kõige suurem
tellimuse summa 2,022.72 € 1/3/2013 SuperMart Pasta 958 4/10/2013 SuperMart Leib 127 90.14 € 0.78 € 99.06 € 2.00% 7.00% 9.00% 8.92 €
Kõige väiksem
tellimuse summa 42.98 € 2/22/2013 MegaMart Leib 58 3/28/2013 SuperMart Pasta 56 119.78 € 2.30 € 128.80 € 0.00% 7.00% 7.00% 9.02 €


4/25/2013 FoodMart Küpsised 66 128.04 € 2.00 € 132.00 € 0.00% 3.00% 3.00% 3.96 €


3/31/2013 SuperMart Piim 122 133.22 € 1.20 € 146.40 € 2.00% 7.00% 9.00% 13.18 €


4/11/2013 SuperMart Piim 144 157.25 € 1.20 € 172.80 € 2.00% 7.00% 9.00% 15.55 €


2/4/2013 MiniMart Piim 147 167.58 € 1.20 € 176.40 € 2.00% 3.00% 5.00% 8.82 €


3/29/2013 MiniMart Leib 228 168.24 € 0.78 € 177.84 € 2.40% 3.00% 5.40% 9.60 €


1/3/2013 FoodMart Pasta 77 171.79 € 2.30 € 177.10 € 0.00% 3.00% 3.00% 5.31 €


3/6/2013 SuperMart Küpsised 112 201.60 € 2.00 € 224.00 € 3.00% 7.00% 10.00% 22.40 €


1/21/2013 MegaMart Leib 302 218.13 € 0.78 € 235.56 € 2.40% 5.00% 7.40% 17.43 €


1/3/2013 MiniMart Leib 322 237.60 € 0.78 € 251.16 € 2.40% 3.00% 5.40% 13.56 €


3/19/2013 FoodMart Leib 328 242.02 € 0.78 € 255.84 € 2.40% 3.00% 5.40% 13.82 €


3/13/2013 SuperMart Leib 352 248.75 € 0.78 € 274.56 € 2.40% 7.00% 9.40% 25.81 €


3/28/2013 FoodMart Leib 340 250.88 € 0.78 € 265.20 € 2.40% 3.00% 5.40% 14.32 €


4/2/2013 MegaMart Piim 233 258.91 € 1.20 € 279.60 € 2.40% 5.00% 7.40% 20.69 €


4/22/2013 SuperMart Pasta 123 263.10 € 2.30 € 282.90 € 0.00% 7.00% 7.00% 19.80 €


4/25/2013 FoodMart Leib 358 264.16 € 0.78 € 279.24 € 2.40% 3.00% 5.40% 15.08 €


2/7/2013 MiniMart Küpsised 145 272.60 € 2.00 € 290.00 € 3.00% 3.00% 6.00% 17.40 €


3/26/2013 SuperMart Küpsised 152 273.60 € 2.00 € 304.00 € 3.00% 7.00% 10.00% 30.40 €


4/26/2013 MegaMart Pasta 128 279.68 € 2.30 € 294.40 € 0.00% 5.00% 5.00% 14.72 €


3/11/2013 FoodMart Küpsised 150 282.00 € 2.00 € 300.00 € 3.00% 3.00% 6.00% 18.00 €


4/27/2013 SuperMart Pasta 133 284.49 € 2.30 € 305.90 € 0.00% 7.00% 7.00% 21.41 €


3/2/2013 SuperMart Leib 426 299.45 € 0.78 € 332.28 € 2.88% 7.00% 9.88% 32.83 €


4/5/2013 MiniMart Leib 411 301.73 € 0.78 € 320.58 € 2.88% 3.00% 5.88% 18.85 €


4/11/2013 MiniMart Leib 422 309.81 € 0.78 € 329.16 € 2.88% 3.00% 5.88% 19.35 €


3/10/2013 SuperMart Leib 452 317.73 € 0.78 € 352.56 € 2.88% 7.00% 9.88% 34.83 €


3/6/2013 SuperMart Pasta 156 333.68 € 2.30 € 358.80 € 0.00% 7.00% 7.00% 25.12 €


3/21/2013 FoodMart Piim 297 337.15 € 1.20 € 356.40 € 2.40% 3.00% 5.40% 19.25 €


3/13/2013 MegaMart Leib 472 339.15 € 0.78 € 368.16 € 2.88% 5.00% 7.88% 29.01 €


3/9/2013 MegaMart Piim 306 340.03 € 1.20 € 367.20 € 2.40% 5.00% 7.40% 27.17 €


4/28/2013 MiniMart Küpsised 182 342.16 € 2.00 € 364.00 € 3.00% 3.00% 6.00% 21.84 €


4/10/2013 SuperMart Pasta 168 359.35 € 2.30 € 386.40 € 0.00% 7.00% 7.00% 27.05 €


4/24/2013 MiniMart Leib 496 364.13 € 0.78 € 386.88 € 2.88% 3.00% 5.88% 22.75 €


1/20/2013 MegaMart Piim 328 364.47 € 1.20 € 393.60 € 2.40% 5.00% 7.40% 29.13 €


3/23/2013 MegaMart Leib 531 381.54 € 0.78 € 414.18 € 2.88% 5.00% 7.88% 32.64 €


1/26/2013 MiniMart Piim 338 383.70 € 1.20 € 405.60 € 2.40% 3.00% 5.40% 21.90 €


4/8/2013 SuperMart Küpsised 226 404.09 € 2.00 € 452.00 € 3.60% 7.00% 10.60% 47.91 €


3/17/2013 MegaMart Leib 580 416.75 € 0.78 € 452.40 € 2.88% 5.00% 7.88% 35.65 €


3/12/2013 MiniMart Leib 571 419.19 € 0.78 € 445.38 € 2.88% 3.00% 5.88% 26.19 €


3/2/2013 SuperMart Pasta 198 423.52 € 2.30 € 455.40 € 0.00% 7.00% 7.00% 31.88 €


1/25/2013 MegaMart Küpsised 232 424.10 € 2.00 € 464.00 € 3.60% 5.00% 8.60% 39.90 €


2/17/2013 MiniMart Piim 374 424.56 € 1.20 € 448.80 € 2.40% 3.00% 5.40% 24.24 €


4/10/2013 MiniMart Leib 592 434.61 € 0.78 € 461.76 € 2.88% 3.00% 5.88% 27.15 €


3/28/2013 MegaMart Leib 616 442.62 € 0.78 € 480.48 € 2.88% 5.00% 7.88% 37.86 €


3/22/2013 MegaMart Küpsised 243 444.20 € 2.00 € 486.00 € 3.60% 5.00% 8.60% 41.80 €


2/8/2013 MiniMart Piim 392 445.00 € 1.20 € 470.40 € 2.40% 3.00% 5.40% 25.40 €


3/10/2013 MegaMart Leib 622 446.93 € 0.78 € 485.16 € 2.88% 5.00% 7.88% 38.23 €


4/11/2013 MegaMart Küpsised 251 458.83 € 2.00 € 502.00 € 3.60% 5.00% 8.60% 43.17 €


3/16/2013 FoodMart Leib 671 492.61 € 0.78 € 523.38 € 2.88% 3.00% 5.88% 30.77 €


3/12/2013 MiniMart Küpsised 264 493.15 € 2.00 € 528.00 € 3.60% 3.00% 6.60% 34.85 €


3/22/2013 MiniMart Leib 728 534.45 € 0.78 € 567.84 € 2.88% 3.00% 5.88% 33.39 €


4/4/2013 SuperMart Küpsised 308 550.70 € 2.00 € 616.00 € 3.60% 7.00% 10.60% 65.30 €


4/21/2013 SuperMart Leib 796 559.54 € 0.78 € 620.88 € 2.88% 7.00% 9.88% 61.34 €


3/9/2013 MegaMart Leib 800 571.23 € 0.78 € 624.00 € 3.46% 5.00% 8.46% 52.77 €


2/17/2013 MegaMart Leib 807 576.23 € 0.78 € 629.46 € 3.46% 5.00% 8.46% 53.23 €


1/26/2013 MiniMart Pasta 264 588.98 € 2.30 € 607.20 € 0.00% 3.00% 3.00% 18.22 €


4/27/2013 FoodMart Leib 809 590.28 € 0.78 € 631.02 € 3.46% 3.00% 6.46% 40.74 €


4/17/2013 FoodMart Leib 819 597.58 € 0.78 € 638.82 € 3.46% 3.00% 6.46% 41.24 €


1/20/2013 MegaMart Küpsised 329 601.41 € 2.00 € 658.00 € 3.60% 5.00% 8.60% 56.59 €


3/18/2013 MegaMart Küpsised 337 616.04 € 2.00 € 674.00 € 3.60% 5.00% 8.60% 57.96 €


3/25/2013 FoodMart Piim 563 635.87 € 1.20 € 675.60 € 2.88% 3.00% 5.88% 39.73 €


3/16/2013 FoodMart Küpsised 348 650.06 € 2.00 € 696.00 € 3.60% 3.00% 6.60% 45.94 €


4/4/2013 FoodMart Leib 902 658.14 € 0.78 € 703.56 € 3.46% 3.00% 6.46% 45.42 €


4/17/2013 MiniMart Leib 990 722.35 € 0.78 € 772.20 € 3.46% 3.00% 6.46% 49.85 €


1/25/2013 MiniMart Piim 689 778.18 € 1.20 € 826.80 € 2.88% 3.00% 5.88% 48.62 €


1/11/2013 FoodMart Pasta 360 803.16 € 2.30 € 828.00 € 0.00% 3.00% 3.00% 24.84 €


4/28/2013 MegaMart Piim 748 826.87 € 1.20 € 897.60 € 2.88% 5.00% 7.88% 70.73 €


1/21/2013 FoodMart Pasta 384 856.70 € 2.30 € 883.20 € 0.00% 3.00% 3.00% 26.50 €


2/23/2013 MegaMart Piim 777 858.93 € 1.20 € 932.40 € 2.88% 5.00% 7.88% 73.47 €


3/26/2013 MiniMart Piim 791 893.39 € 1.20 € 949.20 € 2.88% 3.00% 5.88% 55.81 €


3/13/2013 SuperMart Pasta 427 903.53 € 2.30 € 982.10 € 1.00% 7.00% 8.00% 78.57 €


4/14/2013 SuperMart Piim 866 930.54 € 1.20 € 1,039.20 € 3.46% 7.00% 10.46% 108.66 €


2/3/2013 MiniMart Piim 848 951.90 € 1.20 € 1,017.60 € 3.46% 3.00% 6.46% 65.70 €


4/4/2013 MiniMart Pasta 432 953.86 € 2.30 € 993.60 € 1.00% 3.00% 4.00% 39.74 €


4/21/2013 FoodMart Pasta 455 1,004.64 € 2.30 € 1,046.50 € 1.00% 3.00% 4.00% 41.86 €


1/1/2013 MegaMart Küpsised 570 1,033.75 € 2.00 € 1,140.00 € 4.32% 5.00% 9.32% 106.25 €


3/18/2013 SuperMart Piim 996 1,070.23 € 1.20 € 1,195.20 € 3.46% 7.00% 10.46% 124.97 €


4/27/2013 SuperMart Pasta 509 1,077.04 € 2.30 € 1,170.70 € 1.00% 7.00% 8.00% 93.66 €


4/5/2013 SuperMart Pasta 512 1,083.39 € 2.30 € 1,177.60 € 1.00% 7.00% 8.00% 94.21 €


4/21/2013 FoodMart Piim 992 1,113.55 € 1.20 € 1,190.40 € 3.46% 3.00% 6.46% 76.85 €


3/27/2013 FoodMart Pasta 514 1,134.91 € 2.30 € 1,182.20 € 1.00% 3.00% 4.00% 47.29 €


1/11/2013 MegaMart Pasta 570 1,232.34 € 2.30 € 1,311.00 € 1.00% 5.00% 6.00% 78.66 €


2/3/2013 SuperMart Küpsised 718 1,273.44 € 2.00 € 1,436.00 € 4.32% 7.00% 11.32% 162.56 €


4/19/2013 MegaMart Küpsised 704 1,276.77 € 2.00 € 1,408.00 € 4.32% 5.00% 9.32% 131.23 €


3/28/2013 SuperMart Pasta 628 1,328.85 € 2.30 € 1,444.40 € 1.00% 7.00% 8.00% 115.55 €


2/23/2013 MiniMart Küpsised 751 1,392.05 € 2.00 € 1,502.00 € 4.32% 3.00% 7.32% 109.95 €


4/11/2013 MegaMart Küpsised 847 1,521.48 € 2.00 € 1,694.00 € 5.18% 5.00% 10.18% 172.52 €


4/17/2013 SuperMart Küpsised 871 1,529.75 € 2.00 € 1,742.00 € 5.18% 7.00% 12.18% 212.25 €


2/28/2013 MegaMart Küpsised 876 1,573.58 € 2.00 € 1,752.00 € 5.18% 5.00% 10.18% 178.42 €


3/8/2013 MiniMart Pasta 714 1,576.51 € 2.30 € 1,642.20 € 1.00% 3.00% 4.00% 65.69 €


3/14/2013 MiniMart Pasta 725 1,600.80 € 2.30 € 1,667.50 € 1.00% 3.00% 4.00% 66.70 €


1/4/2013 MegaMart Küpsised 906 1,627.47 € 2.00 € 1,812.00 € 5.18% 5.00% 10.18% 184.53 €


4/5/2013 MegaMart Küpsised 985 1,769.38 € 2.00 € 1,970.00 € 5.18% 5.00% 10.18% 200.62 €


4/18/2013 SuperMart Pasta 871 1,839.03 € 2.30 € 2,003.30 € 1.20% 7.00% 8.20% 164.27 €


4/20/2013 MiniMart Pasta 870 1,916.96 € 2.30 € 2,001.00 € 1.20% 3.00% 4.20% 84.04 €


3/18/2013 SuperMart Pasta 926 1,955.16 € 2.30 € 2,129.80 € 1.20% 7.00% 8.20% 174.64 €


1/18/2013 MiniMart Pasta 889 1,958.82 € 2.30 € 2,044.70 € 1.20% 3.00% 4.20% 85.88 €


1/3/2013 SuperMart Pasta 958 2,022.72 € 2.30 € 2,203.40 € 1.20% 7.00% 8.20% 180.68 €

Sheet 2: Kliendid

Tellija Aadress Soodustus % MegaMart Mega tn. 10 5% MiniMart Mini tn. 12 3% SuperMart Super tn. 121 7% FoodMart Food tn. 13 3%

Sheet 3: Tooted ja soodustus

Soodustus alates tellitud kogusest
Toode Ühiku hind 0 100 200 400 800 1600 Küpsised 2.00 € 0.00 € 3% 3.60% 4.32% 5.18% 6.22% Leib 0.78 € 0.00 € 2% 2.40% 2.88% 3.46% 4.15% Pasta 2.30 € 0.00 € 0% 0.00% 1.00% 1.20% 1.44% Piim 1.20 € 0.00 € 2% 2.40% 2.88% 3.46% 4.15%