first name last name address
James Butt 6649 N Blue Gum St
Josephine Darakjy 4 B Blue Ridge Blvd
Art Venere 8 W Cerritos Ave #54
Lenna Paprocki 639 Main St
Donette Foller 34 Center St
Simona Morasca 3 Mcauley Dr
Mitsue Tollner 7 Eads St
Leota Dilliard 7 W Jackson Blvd
Sage Wieser 5 Boston Ave #88
Kris Marrier 228 Runamuck Pl #2808
Minna Amigon 2371 Jerrold Ave
Abel Maclead 37275 St Rt 17m M
Kiley Caldarera 25 E 75th St #69
Graciela Ruta 98 Connecticut Ave Nw
Cammy Albares 56 E Morehead St
Mattie Poquette 73 State Road 434 E
Meaghan Garufi 69734 E Carrillo St
Gladys Rim 322 New Horizon Blvd
Yuki Whobrey 1 State Route 27
Fletcher Flosi 394 Manchester Blvd
Bette Nicka 6 S 33rd St
Veronika Inouye 6 Greenleaf Ave
Willard Kolmetz 618 W Yakima Ave
Maryann Royster 74 S Westgate St
Alisha Slusarski 3273 State St
Allene Iturbide 1 Central Ave
Chanel Caudy 86 Nw 66th St #8673
Ezekiel Chui 2 Cedar Ave #84
Willow Kusko 90991 Thorburn Ave
Bernardo Figeroa 386 9th Ave N
Ammie Corrio 74874 Atlantic Ave
Francine Vocelka 366 South Dr
Ernie Stenseth 45 E Liberty St
Albina Glick 4 Ralph Ct
Alishia Sergi 2742 Distribution Way
Solange Shinko 426 Wolf St
Jose Stockham 128 Bransten Rd
Rozella Ostrosky 17 Morena Blvd
Valentine Gillian 775 W 17th St
Kati Rulapaugh 6980 Dorsett Rd
Youlanda Schemmer 2881 Lewis Rd
Dyan Oldroyd 7219 Woodfield Rd
Roxane Campain 1048 Main St
Lavera Perin 678 3rd Ave
Erick Ferencz 20 S Babcock St
Fatima Saylors 2 Lighthouse Ave
Jina Briddick 38938 Park Blvd
Kanisha Waycott 5 Tomahawk Dr
Emerson Bowley 762 S Main St
Blair Malet 209 Decker Dr
city state zip phone
New Orleans LA 70116 504-621-8927
Brighton MI 48116 810-292-9388
Bridgeport NJ 8014 856-636-8749
Anchorage AK 99501 907-385-4412
Hamilton OH 45011 513-570-1893
Ashland OH 44805 419-503-2484
Chicago IL 60632 773-573-6914
San Jose CA 95111 408-752-3500
Sioux Falls SD 57105 605-414-2147
Baltimore MD 21224 410-655-8723
Kulpsville PA 19443 215-874-1229
Middle Island NY 11953 631-335-3414
Los Angeles CA 90034 310-498-5651
Chagrin Falls OH 44023 440-780-8425
Laredo TX 78045 956-537-6195
Phoenix AZ 85013 602-277-4385
Mc Minnville TN 37110 931-313-9635
Milwaukee WI 53207 414-661-9598
Taylor MI 48180 313-288-7937
Rockford IL 61109 815-828-2147
Aston PA 19014 610-545-3615
San Jose CA 95111 408-540-1785
Irving TX 75062 972-303-9197
Albany NY 12204 518-966-7987
Middlesex NJ 8846 732-658-3154
Stevens Point WI 54481 715-662-6764
Shawnee KS 66218 913-388-2079
Easton MD 21601 410-669-1642
New York NY 10011 212-582-4976
Conroe TX 77301 936-336-3951
Columbus OH 43215 614-801-9788
Las Cruces NM 88011 505-977-3911
Ridgefield Park NJ 7660 201-709-6245
Dunellen NJ 8812 732-924-7882
New York NY 10025 212-860-1579
Metairie LA 70002 504-979-9175
New York NY 10011 212-675-8570
Camarillo CA 93012 805-832-6163
San Antonio TX 78204 210-812-9597
Abilene KS 67410 785-463-7829
Prineville OR 97754 541-548-8197
Overland Park KS 66204 913-413-4604
Fairbanks AK 99708 907-231-4722
Miami FL 33196 305-606-7291
Fairbanks AK 99712 907-741-1044
Hopkins MN 55343 952-768-2416
Boston MA 2128 617-399-5124
Los Angeles CA 90006 323-453-2780
Madison WI 53711 608-336-7444
Philadelphia PA 19132 215-907-9111
email
jbutt@gmail.com
josephine_darakjy@darakjy.org
art@venere.org
lpaprocki@hotmail.com
donette.foller@cox.net
simona@morasca.com
mitsue_tollner@yahoo.com
leota@hotmail.com
sage_wieser@cox.net
kris@gmail.com
minna_amigon@yahoo.com
amaclead@gmail.com
kiley.caldarera@aol.com
gruta@cox.net
calbares@gmail.com 190
mattie@aol.com
meaghan@hotmail.com
gladys.rim@rim.org
yuki_whobrey@aol.com
fletcher.flosi@yahoo.com
bette_nicka@cox.net 11
vinouye@aol.com
willard@hotmail.com 0
mroyster@royster.com
alisha@slusarski.com
allene_iturbide@cox.net
chanel.caudy@caudy.org
ezekiel@chui.com
wkusko@yahoo.com
bfigeroa@aol.com
ammie@corrio.com
francine_vocelka@vocelka.com
ernie_stenseth@aol.com
albina@glick.com
asergi@gmail.com
solange@shinko.com
jose@yahoo.com
rozella.ostrosky@ostrosky.com
valentine_gillian@gmail.com
kati.rulapaugh@hotmail.com
youlanda@aol.com
doldroyd@aol.com
roxane@hotmail.com
lperin@perin.org
erick.ferencz@aol.com
fsaylors@saylors.org
jina_briddick@briddick.com
kanisha_waycott@yahoo.com
emerson.bowley@bowley.org
bmalet@yahoo.com
School Name
Hogwarts School of Witchcraft and Wizardry
Beauxbatons Academy of Magic
Castelobruxo
Durmstrang Institute
Ilvermorny School of Witchcraft and Wizardry
Mahoutokoro School of Magic
Uagadou
Location Phone Number
Scotland 343-345-2342
France 965-839-1234
Central Brazil 544-564-5334
Nothern Europe 545-234-5830
Eastern North America 639-098-3456
Japan 654-789-1234
Uganda 904-898-7293
Filter Basics
with sum: 8167
with subtotal: 8167
Channel Product Date Sales Value
Website Shirt blue 1/8/2018 200
Store Shirt white 1/8/2018 250
Affiliate site Pants Blue 1/11/2018 300
Store Shirt blue 2/10/2018 260
Affiliate site Shirt yellow 2/10/2018 270
Website Shirt blue 12/20/2017 280
Store Pants Blue 11/1/2017 100
Store Shirt blue 11/1/2017 500
Website Shirt yellow 11/1/2017 410
Store Pants Black 11/10/2017 266
Store Shirt blue 11/10/2017 425
Store Pants Blue 12/10/2017 260
Affiliate site Shirt white 12/10/2017 415
Store Pants Black 12/20/2017 300
Affiliate site Pants Blue 12/20/2017 400
Store Shirt white 12/20/2017 100
Store Pants Black 1/8/2018 401
Affiliate site Pants Blue 1/8/2018 430
Store Shirt blue 1/8/2018 285
Affiliate site Shirt white 1/8/2018 429
Store Pants Blue 1/10/2018 431
Affiliate site Shirt yellow 1/10/2018 298
Store Shirt yellow 1/10/2018 258
Store Pants Black 1/10/2018 251
Affiliate site Shirt white 1/11/2018 344
Store Shirt white 2/10/2018 304
Advanced Filter
Channel Product Date Sales Value
Website Shirt blue 1/8/2018 200
Store Shirt white 1/8/2018 250
Affiliate site Pants Blue 1/11/2018 300
Store Shirt blue 2/10/2018 260
Affiliate site Shirt yellow 2/10/2018 266
Website Shirt blue 12/20/2017 280
Store Pants Blue 11/1/2017 100
Store Shirt blue 11/1/2017 500
Website Shirt yellow 11/1/2017 410
Store Pants Black 12/20/2017 300
Affiliate site Pants Blue 12/20/2017 400
Store Shirt white 12/20/2017 100
Store Pants Black 1/8/2018 401
Affiliate site Pants Blue 1/8/2018 430
Store Shirt blue 1/8/2018 285
Affiliate site Shirt white 1/11/2018 344
Store Shirt white 2/10/2018 304
Store Pants Blue 1/10/2018 431
Affiliate site Shirt yellow 1/10/2018 298
Store Shirt yellow 1/10/2018 258
Store Pants Black 1/10/2018 251
Store Pants Blue 12/10/2017 260
Affiliate site Shirt white 12/10/2017 415
Store Pants Black 11/10/2017 270
Store Shirt blue 11/10/2017 425
Affiliate site Shirt white 1/8/2018 429
channel product sales value sales value
store *pants* >200 <400
store shirt white >200 <400
Product Date Sales Value
Shirt blue 8-Jan-18 $ 200.00
Shirt white 8-Jan-18 $ 250.00
Pants Blue 11-Jan-18 $ 300.00
Shirt blue 10-Feb-18 $ 260.00 1/28/1908
Shirt yellow 10-Feb-18 $ 270.00
Shirt blue 20-Dec-17 $ 280.00
Pants Blue 1-Nov-17 $ 100.00
Shirt blue 1-Nov-17 $ 500.00
Shirt yellow 1-Nov-17 $ 410.00
Pants Black 20-Dec-17 $ 300.00
Pants Blue 20-Dec-17 $ 400.00
Shirt white 20-Dec-17 $ 100.00
Pants Black 8-Jan-18 $ 401.00
Pants Blue 8-Jan-18 $ 430.00
Shirt blue 8-Jan-18 $ 285.00
Shirt white 11-Jan-18 $ 344.00
Shirt white 10-Feb-18 $ 304.00
Pants Blue 10-Jan-18 $ 431.00
Shirt yellow 10-Jan-18 $ 298.00
Shirt yellow 10-Jan-18 $ 258.00
Pants Black 10-Jan-18 $ 251.00
Pants Blue 10-Dec-17 $ 260.00
Shirt white 10-Dec-17 $ 415.00
Pants Black 10-Nov-17 $ 266.00
Shirt blue 10-Nov-17 $ 425.00
Shirt white 8-Jan-18 $ 429.00
Channel Product Date Sales Value
Website Shirt blue 1/8/2018 200
Store Shirt white 1/8/2018 250
Affiliate site Pants Blue 1/11/2018 300
Store Shirt blue 2/10/2018 260 16
Affiliate site Shirt yellow 2/10/2018 270
Website Shirt blue 12/20/2017 280
Store Pants Blue 11/1/2017 100
Store Shirt blue 11/1/2017 500 0
Website Shirt yellow 11/1/2017 410
Store Pants Black 12/20/2017 300
Affiliate site Pants Blue 12/20/2017 400
Store Shirt white 12/20/2017 100
Store Pants Black 1/8/2018 401
Affiliate site Pants Blue 1/8/2018 430
Store Shirt blue 1/8/2018 285
Affiliate site Shirt white 1/11/2018 344
Store Shirt white 2/10/2018 304
Store Pants Blue 1/10/2018 431
Affiliate site Shirt yellow 1/10/2018 298
Store Shirt yellow 1/10/2018 258
Store Pants Black 1/10/2018 251
Store Pants Blue 12/10/2017 260
Affiliate site Shirt white 12/10/2017 415
Store Pants Black 11/10/2017 266
Store Shirt blue 11/10/2017 425
Affiliate site Shirt white 1/8/2018 429
Reg.No. First Name Surname
EH/22/20 Grant Sapala
EH/09/20 Spencer Mlongoti
EH/12/20 Ruth Chabwera
EH/15/20 Chikondi Paul
EH/20/20 Sphiwe Chirwa
National ID NAME SEX GRADE DEPARTMENT BASIC PAY
BGY24 Senzani M A Accounts 500000
SC41Z Chimwemwe F A Sales 508000
ZYX22 Yankho M B Research 477200
PQR66 Aziel M C Security 461000
STU41 Madalitso F C Catering 452000
EAX29 Jabez M D Human resource 411000
CITY100 Suzgo M E Audit 371000
QZT88 Gomelia F G Housing 307000
PAYE 11%
NET PAY
ID No. STUDENT NAME SCORE (%) REMARK
M001 Annie Fred 86
M002 Kesten Phiri 34
M003 Horace Soko 73
M004 Jane Staliko 79
M005 Harry Fulani 61
M006 Alex Thom 47
M007 Michael Sinjani 69
M008 Moda Alfred 25
Daily Consumption Value Per Person
Item Unit (MWK) No.of Persons Consumption per person
Sugar 700 28
Tissue 250 28
YEARLY COMPANIES PERFORMANCE
YEAR HONDA MAZDA TOYOTA
2017 560 700 800
2018 120 260 600
2019 700 550 540
2020 500 1020 430
TOTAL SALES
Year English Maths Biology Chichewa P/Science
2005 25 31 44 17 08
2006 42 34 45 48 38
2007 49 48 47 38 49
2008 49 24 41 31 26
2009 38 29 29 34 50
17
Agriculture Average
16
07
19
33
45
Date Product Quantity Sales
Laptop bag
6/1/2023 48 1800
black
Women type T
6/1/2023 140 1680 Date
simple white
Smartphone
6/1/2023 60 4230 count 96
case diamond
6/1/2023 Laptop bag red 60 1970 mean 45146.90625
Women type T
6/2/2023 140 1680 min 45078
simple white
Women type T
6/3/2023 120 1440 25% 45110.75
simple white
Smartphone
6/3/2023 60 4230 50% 45149.5
case diamond
Smartphone
6/4/2023 50 3520 75% 45183
case diamond
Women crop
6/4/2023 190 1900 max 45229
top black
Women type T
6/7/2023 130 1560
simple black
Women type T
6/10/2023 140 1680
simple black
Women crop
6/10/2023 130 1300
top black
6/10/2023 Men basics 60 300
6/11/2023 Laptop bag red 60 1970
6/13/2023 Women basics 120 600
Smartphone
6/15/2023 50 3520
case diamond
Women type T
6/17/2023 120 1440
simple white
Women type T
6/27/2023 120 1440
simple white
Women type T
6/27/2023 150 1800
simple black
Women type T
7/1/2023 170 2040
simple white
Women type T
7/1/2023 140 1680
simple black
7/1/2023 Men basics 20 100
7/1/2023 Laptop bag red 70 2300
Laptop bag
7/3/2023 50 1640
black
Smartphone
7/4/2023 50 3520
case diamond
Women crop
7/6/2023 100 1000
top black
Smartphone
7/6/2023 50 3520
case diamond
7/9/2023 Laptop bag red 80 2630
7/10/2023 Laptop bag red 50 1640
Smartphone
7/10/2023 70 4930
case diamond
Men shorts
7/14/2023 70 1260
black
7/14/2023 Men shorts grey 80 1440
7/17/2023 Women basics 190 950
Men shorts
7/19/2023 70 1260
black
7/20/2023 Laptop bag red 60 1970
Laptop bag
7/22/2023 60 1970
black
Women type T
7/23/2023 130 1560
simple black
Women type T
7/29/2023 150 1800
simple black
Laptop bag
7/29/2023 60 1970
black
Men type T
7/31/2023 10 120
simple black
8/1/2023 Men basics 70 350
8/2/2023 Laptop bag red 70 2300
Smartphone
8/2/2023 60 1410
case simple
Women type T
8/3/2023 120 1440
simple white
8/3/2023 Women basics 170 850
Women crop
8/10/2023 140 1400
top black
Smartphone
8/10/2023 60 4230
case diamond
8/11/2023 Laptop bag red 60 1970
Women type T
8/12/2023 200 2400
simple white
8/12/2023 Laptop bag red 60 1970
Laptop bag
8/13/2023 60 1970
black
Laptop bag
8/14/2023 70 2300
black
Women crop
8/17/2023 190 1900
top black
Women type T
8/19/2023 180 2160
simple black
Women type T
8/19/2023 120 1440
simple black
8/20/2023 Laptop bag red 70 2300
Women type T
8/22/2023 110 1320
simple black
Women crop
8/23/2023 140 1400
top black
Women type T
8/24/2023 140 1680
simple black
Laptop bag
8/27/2023 60 1970
black
8/28/2023 Laptop bag red 60 1970
Laptop bag
8/28/2023 80 2630
black
Men dress shirt
8/31/2023 50 1250
grey
Women crop
9/2/2023 120 1200
top black
Women type T
9/2/2023 160 1920
simple black
Women crop
9/4/2023 140 1400
top black
Men type T
9/4/2023 70 840
simple black
Unisex tank top
9/4/2023 60 360
white
Men type T
9/8/2023 30 360
simple black
Men type T
9/11/2023 100 1200
simple white
Men shorts
9/11/2023 70 1260
black
Women type T
9/14/2023 120 1440
simple white
Men type T
9/14/2023 130 1560
simple white
9/14/2023 Laptop bag red 70 2300
Men type T
9/16/2023 40 480
simple white
Women type T
9/17/2023 150 1800
simple black
Women type T
9/18/2023 140 1680
simple black
Smartphone
9/20/2023 80 1880
case simple
9/22/2023 Laptop bag red 60 1970
Laptop bag
9/26/2023 70 2300
black
9/27/2023 Laptop bag red 60 1970
9/28/2023 Men shorts grey 80 1440
Laptop bag
9/28/2023 50 1640
black
Women crop
10/1/2023 120 1200
top black
Smartphone
10/2/2023 60 1410
case simple
Women type T
10/3/2023 160 1920
simple black
Women type T
10/4/2023 140 1680
simple white
10/5/2023 Women basics 160 800
Women type T
10/6/2023 190 2280
simple black
Laptop bag
10/7/2023 60 1970
black
Women type T
10/20/2023 140 1680
simple white
Smartphone
10/21/2023 80 1880
case simple
Women type T
10/22/2023 190 2280
simple white
Smartphone
10/23/2023 60 4230
case diamond
Laptop bag
10/30/2023 80 2240
black
10/30/2023 Laptop bag red 60 1970
1817.8125
Inventory ID Name Description Unit price Quantity in stock
IN0001 Item 1 Desc 1 $51.00 25
IN0002 Item 2 Desc 2 $93.00 132
IN0003 Item 3 Desc 3 $57.00 151
IN0004 Item 4 Desc 4 $19.00 186
IN0005 Item 5 Desc 5 $75.00 62
IN0006 Item 6 Desc 6 $11.00 5
IN0007 Item 7 Desc 7 $56.00 58
IN0008 Item 8 Desc 8 $38.00 101
IN0009 Item 9 Desc 9 $59.00 122
IN0010 Item 10 Desc 10 $50.00 175
IN0011 Item 11 Desc 11 $59.00 176
IN0012 Item 12 Desc 12 $18.00 22
IN0013 Item 13 Desc 13 $26.00 72
IN0014 Item 14 Desc 14 $42.00 62
IN0015 Item 15 Desc 15 $32.00 46
IN0016 Item 16 Desc 16 $90.00 96
IN0017 Item 17 Desc 17 $97.00 57
IN0018 Item 18 Desc 18 $12.00 6
IN0019 Item 19 Desc 19 $82.00 143
IN0020 Item 20 Desc 20 $16.00 124
IN0021 Item 21 Desc 21 $19.00 112
IN0022 Item 22 Desc 22 $24.00 182
IN0023 Item 23 Desc 23 $29.00 106
IN0024 Item 24 Desc 24 $75.00 173
IN0025 Item 25 Desc 25 $14.00 28
Inventory value Reorder level Reorder time in days Quantity in reorder
$1,275.00 29 13 50
$12,276.00 231 4 50
$8,607.00 114 11 150
$3,534.00 158 6 50
$4,650.00 39 12 50
$55.00 9 13 150
$3,248.00 109 7 100
$3,838.00 162 3 100
$7,198.00 82 3 150
$8,750.00 283 8 150
$10,384.00 229 1 100
$396.00 36 12 50
$1,872.00 102 9 100
$2,604.00 83 2 100
$1,472.00 23 15 50
$8,640.00 180 3 50
$5,529.00 98 12 50
$72.00 7 13 50
$11,726.00 164 12 150
$1,984.00 113 14 50
$2,128.00 75 11 50
$4,368.00 132 15 150
$3,074.00 142 1 150
$12,975.00 127 9 100
$392.00 21 8 50
Discontinued?
You're under budget by $130.64
Item Description Cost Qty Amount
Airfare Tickets $300.00 1 $300.00
Airfare Tickets $350.00 1 $350.00
Hotel Room $125.00 3 $375.00
Hotel Room $150.00 3 $450.00
Car rental Cost per day $52.00 6 $312.00
Gas Cost per gallon $1.74 14 $24.36
Entertainment Amount $130.00 1 $130.00
Gifts Amount $85.00 1 $85.00
Miscellaneous Amount $55.00 1 $55.00
Food Cost per day $48.00 6 $288.00
Total $2,369.36
Unit,What It Does,Example (Start: 2023-03-09, End: 2025-03-09),Result
Y,Full years between two dates.,=DATEDIF(DATE(2023,3,9), DATE(2025,3,9), "Y"),2 yea
M,Full months between two dates.,=DATEDIF(DATE(2023,3,9), DATE(2025,3,9), "M"),24
D,Total days between two dates.,=DATEDIF(DATE(2023,3,9), DATE(2025,3,9), "D"),731
YM,Months ignoring years.,=DATEDIF(DATE(2023,3,9), DATE(2025,3,9), "YM"),0 months
YD,Days ignoring years.,=DATEDIF(DATE(2023,3,9), DATE(2025,3,9), "YD"),0 days
MD,Days ignoring months and years.,=DATEDIF(DATE(2025,3,1), DATE(2025,3,9), "MD"
DATEDIF(DATE(2020, 1, 15), TODAY(), "Y") & " years and " & DATEDIF(DATE(2020, 1, 15), TODAY()
DATEDIF(TODAY(), DATE(YEAR(TODAY()), 8, 15), "YD")
DATEDIF(DATE(2020, 1, 15), TODAY(), "Y") & " years and " & DATEDIF(DATE(2020, 1, 15), TODAY()
79
5 years and 3 months
Err:501
09),Result
DATE(2025,3,9), "Y"),2 years
, DATE(2025,3,9), "M"),24 months
DATE(2025,3,9), "D"),731 days
2025,3,9), "YM"),0 months
25,3,9), "YD"),0 days
,1), DATE(2025,3,9), "MD"),8 days
F(DATE(2020, 1, 15), TODAY(), "YM") & " months
F(DATE(2020, 1, 15), TODAY(), "YM") & " months"
19
Err:501
19 years and 14days
DATEDIF(DATE(2020, 1, 15), TODAY(), "Y") & " years and " &
Y") & " years and " & DATEDIF(DATE(2020, 1, 15), TODAY(), "YM") & " months
