Division Region App Actual Sales

Productivity Asia Kind Ape $1,757.00

Game Australia Kryptis $4,469.00
Productivity Australia Right App $1,171.00
Productivity Australia Sleops $0.00
Productivity Europe Halotot $5,465.00
Productivity Europe Pet Feed $2,732.00
Utility Europe Scrap $437.00
Game Europe deRamblr $0.00
Productivity Europe Inkly $0.00
Game North America deRamblr $7,148.00
Productivity North America Rehire $6,148.00
Utility North America Mosquit $884.00
Productivity South America Blend $1,220.00
Game South America Aviatrr $0.00
Productivity South America Silvrr $0.00

Division Region App Actual Sales

Game Australia Kryptis 4469
Game North America deRamblr 7148
Productivity Asia Kind Ape 1757
Productivity Australia Right App 1171
Productivity Europe Halotot 5465
Productivity Europe Pet Feed 2732
Productivity Europe Inkly 0
Productivity North America Rehire 6148
Productivity South America Blend 1220
Productivity South America Silvrr 0
Utility Europe Scrap 437
Utility North America Mosquit 884
Game South America Aviatrr 0
Game Europe deRamblr 0
Productivity Australia Sleops 0
 Dataset 1
Name Date Investment
Rifki Dita Wahyu 8-Jan-1980 Rp1,687,149.00 Berapa banyak nama Frederick data dataset 1?
Jeceline Suryadi 9-Jan-1980 Rp1,138,351.00
Molia Muler 10-Jan-1980 Rp1,744,965.00
Frederick 11-Jan-1980 Rp1,110,735.00
Scanny Miller 12-Jan-1980 Rp1,404,843.00
Molia Muler 13-Jan-1980 Rp1,631,095.00
Scanny Miller 14-Jan-1980 Rp1,406,288.00
Scanny Miller 15-Jan-1980 Rp1,030,998.00
Ari Prabowo 16-Jan-1980 Rp1,536,855.00
Jeceline Suryadi 17-Jan-1980 Rp1,407,371.00
Molia Muler 18-Jan-1980 Rp1,520,038.00
Ari Prabowo 19-Jan-1980 Rp1,616,597.00
Jeceline Suryadi 20-Jan-1980 Rp1,506,588.00
Ari Prabowo 21-Jan-1980 Rp1,541,731.00
Frederick 22-Jan-1980 Rp1,971,908.00
Total Jumlah Investasi Rp22,255,512.00
Rata-rata investasi Rp2,781,939.00
Nilai tengah investasi (median) Rp1,520,038.00
maksimum investasi Rp1,971,908.00
minimum investasi Rp1,030,998.00

Name Date Birth Money

Ari Prabowo 8-Jan-1980 14000
Jeceline Suryadi 20-May-1990 235000
Dataset 2 Molia Muler missing 12412000
Frederick 10-Apr-1985
Scanny Miller 10-Jan-1980 10000
COUNT
COUNTA
COUNTBLANK
 Dataset 3
Division Region App Actual Sales Category
Productivity Asia Kind Ape 1757 Focused Category
Productivity Australia Sleops 0 Not Focused Category
Productivity Australia Right App 1171 Total Actual Sale
Game Australia Kryptis 4469
Game Europe deRamblr 0
Productivity Europe Inkly 0
Utility Europe Scrap 437
Productivity Europe Pet Feed 2732
Productivity Europe Halotot 5465
Utility North America Mosquit 884
Productivity North America Rehire 6148
Game North America deRamblr 7148
Game South America Aviatrr 0
Productivity South America Silvrr 0
Productivity South America Blend 1220

Practice Time
Sales
Company Company Name Region Document Date Customer Code Customer Name
Document
1010US Urban Right America 66030 6/27/2019 8010 Dellicia
1010US Urban Right America 66030 6/11/2019 8010 Dellicia
1010US Urban Right America 66032 8/8/2019 8010 Dellicia
1010US Urban Right America 66032 6/23/2019 8010 Dellicia
1010US Urban Right America 66031 5/31/2019 8020 Erma
1010US Urban Right America 66031 7/29/2019 8020 Erma
1010US Urban Right America 66031 7/6/2019 8020 Erma
1010US Urban Right America 68112 8/19/2019 8010 Dellicia
1010US Urban Right America 68112 9/2/2019 8010 Dellicia
1010US Urban Right America 68116 9/17/2019 8020 Erma
1010US Urban Right America 68116 6/4/2019 8020 Erma
1010US Urban Right America 68116 10/5/2019 8020 Erma
1010US Urban Right America 68116 10/2/2019 8010 Dellicia
1010US Urban Right America 68116 8/17/2019 8010 Dellicia
1010US Urban Right America 65662 9/14/2019 8020 Erma
1010US Urban Right America 65662 8/22/2019 8020 Erma
1010US Urban Right America 65666 8/3/2019 8010 Dellicia
1010US Urban Right America 65666 8/24/2019 8010 Dellicia
1010US Urban Right America 65666 6/19/2019 8010 Dellicia
1010US Urban Right America 65666 6/13/2019 8020 Erma
1010US Urban Right America 65666 8/12/2019 8020 Erma
1010US Urban Right America 66015 10/3/2019 8010 Dellicia
1010US Urban Right America 66015 6/10/2019 8010 Dellicia
1010US Urban Right America 66017 5/29/2019 8010 Dellicia
1010US Urban Right America 66017 6/28/2019 8010 Dellicia
1010US Urban Right America 66016 5/31/2019 8020 Erma
1010US Urban Right America 66016 7/23/2019 8020 Erma
1010US Urban Right America 66016 10/1/2019 8020 Erma
1010US Urban Right America 68097 9/18/2019 8010 Dellicia
1010US Urban Right America 68097 6/10/2019 8010 Dellicia
1010US Urban Right America 68099 8/19/2019 8020 Erma
1010US Urban Right America 68099 9/4/2019 8020 Erma
1010US Urban Right America 68099 8/3/2019 8020 Erma
1010US Urban Right America 68101 10/5/2019 8010 Dellicia
1010US Urban Right America 68101 8/10/2019 8010 Dellicia
1010US Urban Right America 65627 10/7/2019 8020 Erma
1010US Urban Right America 65627 9/2/2019 8020 Erma
1010US Urban Right America 65629 10/9/2019 8010 Dellicia
1010US Urban Right America 65629 6/7/2019 8010 Dellicia
1010US Urban Right America 65629 8/23/2019 8010 Dellicia
1010US Urban Right America 65631 7/17/2019 8020 Erma
1010US Urban Right America 65631 6/17/2019 8020 Erma
1020US Meta Creations America 24030 9/14/2019 8020 Erma
1020US Meta Creations America 24030 9/8/2019 8020 Erma
1020US Meta Creations America 24030 6/10/2019 8020 Erma
1020US Meta Creations America 24030 10/11/2019 8020 Erma
1020US Meta Creations America 24031 9/11/2019 8020 Erma
1020US Meta Creations America 24031 6/23/2019 8020 Erma
1020US Meta Creations America 24031 6/17/2019 8020 Erma
1020US Meta Creations America 28112 8/31/2019 8020 Erma
1020US Meta Creations America 28112 6/22/2019 8020 Erma
1020US Meta Creations America 28112 9/4/2019 8020 Erma
1020US Meta Creations America 28112 8/1/2019 8020 Erma
1020US Meta Creations America 28112 5/27/2019 8020 Erma
1020US Meta Creations America 28112 9/28/2019 8020 Erma
1020US Meta Creations America 28112 7/19/2019 8020 Erma
1020US Meta Creations America 25442 7/14/2019 8010 Dellicia
1020US Meta Creations America 25442 7/14/2019 8010 Dellicia
1020US Meta Creations America 25442 9/11/2019 8010 Dellicia
1020US Meta Creations America 25442 9/4/2019 8010 Dellicia
1020US Meta Creations America 25442 6/29/2019 8010 Dellicia
1020US Meta Creations America 25442 9/16/2019 8010 Dellicia
1020US Meta Creations America 25442 7/31/2019 8010 Dellicia
1040DE Lucas Basics Europe 44030 10/5/2019 8060 Liebher
1040DE Lucas Basics Europe 44030 9/27/2019 8060 Liebher
1040DE Lucas Basics Europe 44032 7/29/2019 8060 Liebher
1040DE Lucas Basics Europe 44032 8/20/2019 8060 Liebher
1040DE Lucas Basics Europe 44031 8/27/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 44031 7/10/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 44031 6/1/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48112 5/30/2019 8060 Liebher
1040DE Lucas Basics Europe 48112 6/2/2019 8060 Liebher
1040DE Lucas Basics Europe 48114 10/11/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48114 10/9/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48114 9/20/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48116 8/11/2019 8060 Liebher
1040DE Lucas Basics Europe 48116 6/22/2019 8060 Liebher
1040DE Lucas Basics Europe 45442 9/28/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 45442 6/11/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 45444 5/28/2019 8060 Liebher
1040DE Lucas Basics Europe 45444 8/2/2019 8060 Liebher
1040DE Lucas Basics Europe 45444 5/29/2019 8060 Liebher
1040DE Lucas Basics Europe 45446 10/7/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 45446 7/3/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 44015 8/13/2019 8060 Liebher
1040DE Lucas Basics Europe 44015 7/1/2019 8060 Liebher
1040DE Lucas Basics Europe 44017 6/17/2019 8060 Liebher
1040DE Lucas Basics Europe 44017 9/14/2019 8060 Liebher
1040DE Lucas Basics Europe 44016 8/14/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 44016 9/22/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 44016 6/15/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48097 8/28/2019 8060 Liebher
1040DE Lucas Basics Europe 48097 7/10/2019 8060 Liebher
1040DE Lucas Basics Europe 48099 7/20/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48099 8/10/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48099 10/1/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 48101 8/12/2019 8060 Liebher
1040DE Lucas Basics Europe 48101 7/4/2019 8060 Liebher
1040DE Lucas Basics Europe 45427 9/26/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 45427 6/18/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 45429 8/28/2019 8060 Liebher
1040DE Lucas Basics Europe 45429 7/9/2019 8060 Liebher
1040DE Lucas Basics Europe 45429 7/6/2019 8060 Liebher
1040DE Lucas Basics Europe 45431 8/2/2019 8050 Aida GmbH
1040DE Lucas Basics Europe 45431 7/22/2019 8050 Aida GmbH
 IFERROR IFNA Pertanyaan:
0 #NAME? 1. Buatlah pengkategorian baru, jika divisi = Productivity, maka menjadi "Focus
sed Category 2. Jumlah penjualan (sales) hanya Focused Category saja
0 #NAME? 3. Berapa total penjualan dari Australia saja?

0 #NAME? Jawaban 2 0
Jawaban 3 5640

IF(AND(A36="Productivity";B36="Asia");"Asia Juara";

Article Code Article DesReject Quantity Sales USD Discount Sales after Discount New Category Quantity
103 Women type T simple 120 1440 0%
104 Women type T simple 150 1800 10%
103 Women type T simple 170 2040 10%
104 Women type T simple 140 1680 0%
103 Women type 1 140 1680 0%
104 Women type T simple 150 1800 10%
105 Women crop top blac 100 1000 0%
104 Women type 4 180 2160 10%
105 Women crop top blac 120 1200 0%
104 Women type T simple 150 1800 10%
105 Women crop top blac 190 1900 10%
107 Women bas 2 160 800 10%
104 Women type T simple 160 1920 10%
105 Women crop top blac 190 1900 10%
103 Women type T simple 120 1440 0%
104 Women type T simple 110 1320 0%
103 Women type T simple 120 1440 0%
104 Women type T simple 140 1680 0%
105 Women crop top blac 160 1600 10%
107 Women basics 120 600 0%
103 Women type T simple 200 2400 10%
103 Women type T simple 140 1680 0%
104 Women type T simple 140 1680 0%
103 Women type T simple 140 1680 0%
104 Women type T simple 140 1680 0%
103 Women type T simple 120 1440 0%
104 Women type T simple 130 1560 0%
105 Women crop top blac 120 1200 0%
104 Women type T simple 140 1680 0%
105 Women crop top blac 130 1300 0%
104 Women type T simple 120 1440 0%
105 Women crop 2 140 1400 0%
107 Women basics 170 850 10%
104 Women type T simple 190 2280 10%
105 Women crop top blac 140 1400 0%
103 Women type T simple 140 1680 0%
104 Women type 3 160 1920 10%
103 Women type T simple 190 2280 10%
104 Women type T simple 130 1560 0%
105 Women crop top blac 140 1400 0%
107 Women basics 190 950 10%
103 Women type T simple 120 1440 0%
101 Men type T 1 130 1560 0%
102 Men type T simple bla 30 360 0%
106 Men basics 60 300 0%
108 Laptop bag black 80 2240 0%
101 Men type T simple wh 100 1200 0%
108 Laptop bag black 20 560 0%
113 Men dress shirt black 100 2500 0%
114 Men dress s 1 50 1250 0%
101 Men type T simple wh 40 480 0%
102 Men type T simple bla 70 840 0%
106 Men basics 70 350 0%
108 Laptop bag black 10 280 0%
117 Men shorts grey 80 1440 0%
118 Men shorts black 70 1260 0%
118 Men shorts black 70 1260 0%
117 Men shorts 6 80 1440 0%
118 Men shorts black 70 1260 0%
116 Unisex tan 1 60 360 0%
106 Men basics 20 100 0%
101 Men type T simple wh 40 480 0%
102 Men type T simple bla 10 120 0%
108 Laptop bag black 60 1970 0%
109 Laptop bag 1 60 1970 0%
108 Laptop bag black 60 1970 0%
109 Laptop bag red 70 2300 0%
108 Laptop bag black 60 1970 0%
109 Laptop bag red 50 1640 0%
110 Smartphone case dia 60 4230 0%
109 Laptop bag red 60 1970 0%
110 Smartphone case dia 50 3520 0%
109 Laptop bag red 60 1970 0%
110 Smartphone case dia 60 4230 0%
111 Smartphone case simp 80 1880 0%
109 Laptop bag red 60 1970 0%
110 Smartphone case dia 60 4230 0%
108 Laptop bag black 50 1640 0%
109 Laptop bag 1 60 1970 0%
108 Laptop bag black 60 1970 0%
109 Laptop bag red 70 2300 0%
110 Smartphone case dia 60 4230 0%
111 Smartphone case simp 80 1880 0%
108 Laptop bag black 50 1640 0%
108 Laptop bag black 60 1970 0%
109 Laptop bag red 70 2300 0%
108 Laptop bag black 70 2300 0%
109 Laptop bag red 70 2300 0%
108 Laptop bag black 70 2300 0%
109 Laptop bag 1 60 1970 0%
110 Smartphone case dia 50 3520 0%
109 Laptop bag red 60 1970 0%
110 Smartphone case dia 70 4930 0%
109 Laptop bag 1 60 1970 0%
110 Smartphone case dia 60 4230 0%
111 Smartphone case simp 60 1410 0%
109 Laptop bag red 60 1970 0%
110 Smartphone case dia 50 3520 0%
108 Laptop bag black 70 2300 0%
109 Laptop bag red 60 1970 0%
108 Laptop bag black 80 2630 0%
109 Laptop bag 2 80 2630 0%
110 Smartphone case dia 50 3520 0%
111 Smartphone case simp 60 1410 0%
108 Laptop bag black 60 1970 0%
6148 7148 0 0 1220
ctivity, maka menjadi "Focused Category" selain itu "Not Focused Category"

";B36="Asia");"Asia Juara"; "Non Asia Juara")

New Category Quantity Jumlah Data

low quantity
medium quantity
high quantity
COUNTIF
xxxIF(range, criteria, range hasil)

Low Quantity < 80

Medium Quantity between 81 - 120
High Quantity > 120

Fungsi IF
>
<
Order ID Order Date Ship Date Ship Mode Customer ID Customer NamSegment City Postal Code Region Product ID
CA-2016-1521 11/8/2016 11/11/2016 Second Class CG-12520 Claire Gute Consumer Henderson 42420 South FUR-BO-10001
CA-2016-1521 11/8/2016 11/11/2016 Second Class CG-12520 Claire Gute Consumer Henderson 42420 South FUR-CH-10000
CA-2016-1386 6/12/2016 6/16/2016 Second Class DV-13045 Darrin Van HufCorporate Los Angeles 90036 West OFF-LA-10000
US-2015-1089 10/11/2015 10/18/2015 Standard ClassSO-20335 Sean O'DonnelConsumer Fort Lauderdal 33311 South FUR-TA-10000
US-2015-1089 10/11/2015 10/18/2015 Standard ClassSO-20335 Sean O'DonnelConsumer Fort Lauderdal 33311 South OFF-ST-100007
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West FUR-FU-10001
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West OFF-AR-10002
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West TEC-PH-10002
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West OFF-BI-100039
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West OFF-AP-10002
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West FUR-TA-10001
CA-2014-1158 6/9/2014 6/14/2014 Standard ClassBH-11710 Brosina Hoffm Consumer Los Angeles 90032 West TEC-PH-10002
CA-2017-1144 4/15/2017 4/20/2017 Standard ClassAA-10480 Andrew Allen Consumer Concord 28027 South OFF-PA-10002
CA-2016-1613 12/5/2016 12/10/2016 Standard ClassIM-15070 Irene Maddox Consumer Seattle 98103 West OFF-BI-100036
US-2015-1189 11/22/2015 11/26/2015 Standard ClassHP-14815 Harold PawlanHome Office Fort Worth 76106 Central OFF-AP-10002
US-2015-1189 11/22/2015 11/26/2015 Standard ClassHP-14815 Harold PawlanHome Office 76106 Central OFF-BI-100007
CA-2014-1058 11/11/2014 11/18/2014 Standard ClassPK-19075 Pete Kriz Consumer Madison 53711 Central OFF-ST-100041
CA-2014-1671 5/13/2014 5/15/2014 Second Class AG-10270 Alejandro Gro Consumer West Jordan 84084 West OFF-ST-100001
CA-2014-1433 8/27/2014 9/1/2014 Second Class ZD-21925 Zuschuss DonatConsumer San Francisco 94109 West OFF-AR-10003
CA-2014-1433 8/27/2014 9/1/2014 Second Class ZD-21925 Zuschuss DonatConsumer San Francisco 94109 West TEC-PH-10001
CA-2014-1433 8/27/2014 9/1/2014 Second Class ZD-21925 Zuschuss DonatConsumer San Francisco 94109 West OFF-BI-100022
CA-2016-1373 12/9/2016 12/13/2016 Standard ClassKB-16585 Corporate Fremont 68025 Central OFF-AR-10000
CA-2016-1373 12/9/2016 12/13/2016 Standard ClassKB-16585 Ken Black Corporate Fremont 68025 Central OFF-AP-10001
US-2017-1569 7/16/2017 7/18/2017 Second Class SF-20065 Sandra Flanag Consumer Philadelphia 19140 East FUR-CH-10002
CA-2015-1063 9/25/2015 9/30/2015 Standard ClassEB-13870 Emily Burns Consumer Orem 84057 West FUR-TA-10000
CA-2016-1217 1/16/2016 1/20/2016 Second Class EH-13945 Eric Hoffmann Consumer Los Angeles 90049 West OFF-BI-100016
CA-2016-1217 1/16/2016 1/20/2016 Second Class EH-13945 Eric Hoffmann Consumer Los Angeles 90049 West TEC-AC-10003
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East FUR-BO-10004
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East OFF-BI-100004
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East FUR-FU-10004
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East OFF-EN-10001
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East OFF-AR-10004
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East OFF-BI-100015
US-2015-1506 9/17/2015 9/21/2015 Standard ClassTB-21520 Tracy BlumsteiConsumer Philadelphia 19140 East OFF-AR-10001
CA-2017-1077 10/19/2017 10/23/2017 Second Class MA-17560 Matt Abelman Home Office Houston 77095 Central OFF-PA-10000
CA-2016-1175 12/8/2016 12/10/2016 First Class GH-14485 Gene Hale Corporate Richardson 75080 Central TEC-PH-10004
CA-2016-1175 12/8/2016 12/10/2016 First Class GH-14485 Gene Hale Corporate Richardson 75080 Central FUR-FU-10003
CA-2015-1174 12/27/2015 12/31/2015 Standard ClassSN-20710 Steve Nguyen Home Office Houston 77041 Central OFF-EN-10002
CA-2015-1174 12/27/2015 12/31/2015 Standard ClassSN-20710 Steve Nguyen Home Office Houston 77041 Central FUR-BO-10002
CA-2015-1174 12/27/2015 12/31/2015 Standard ClassSN-20710 Steve Nguyen Home Office Houston 77041 Central FUR-CH-10004
CA-2015-1174 12/27/2015 12/31/2015 Standard ClassSN-20710 Steve Nguyen Home Office Houston 77041 Central TEC-PH-10000
CA-2017-1209 9/10/2017 9/15/2017 Standard ClassLC-16930 Linda Cazamia Corporate Naperville 60540 Central TEC-PH-10004
CA-2016-1013 7/17/2016 7/22/2016 Standard ClassRA-19885 Ruben AusmanCorporate Los Angeles 90049 West OFF-ST-100034
CA-2017-1396 9/19/2017 9/23/2017 Standard ClassES-14080 Erin Smith Corporate Melbourne 32935 South OFF-ST-100032
CA-2016-1182 3/11/2016 3/13/2016 First Class ON-18715 Odella Nelson Corporate Eagan 55122 Central TEC-AC-10000
CA-2016-1182 3/11/2016 3/13/2016 First Class ON-18715 Odella Nelson Corporate Eagan 55122 Central OFF-BI-100032
CA-2014-1467 10/20/2014 10/25/2014 Second Class PO-18865 Patrick O'DonnConsumer Westland 48185 Central OFF-ST-100017
CA-2016-1691 6/20/2016 6/25/2016 Standard ClassLH-16900 Lena HernandeConsumer Dover 19901 East TEC-AC-10002
CA-2016-1691 6/20/2016 6/25/2016 Standard ClassLH-16900 Lena HernandeConsumer Dover 19901 East TEC-PH-10003
CA-2015-1157 4/18/2015 4/22/2015 Standard ClassDP-13000 Darren PowersConsumer New Albany 47150 Central OFF-BI-100044
CA-2015-1157 4/18/2015 4/22/2015 Standard ClassDP-13000 Darren PowersConsumer New Albany 47150 Central OFF-LA-10002
CA-2015-1157 4/18/2015 4/22/2015 Standard ClassDP-13000 Darren PowersConsumer New Albany 47150 Central FUR-FU-10001
CA-2015-1157 4/18/2015 4/22/2015 Standard ClassDP-13000 Darren PowersConsumer New Albany 47150 Central FUR-CH-10003
CA-2016-1058 12/11/2016 12/17/2016 Standard ClassJM-15265 Janet Molinari Corporate New York City 10024 East OFF-FA-10000
CA-2016-1058 12/11/2016 12/17/2016 Standard ClassJM-15265 Janet Molinari Corporate New York City 10024 East TEC-PH-10002
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East OFF-ST-100006
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East OFF-PA-10001
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East FUR-CH-10003
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East OFF-PA-10000
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East TEC-AC-10002
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East OFF-BI-100014
CA-2016-1116 6/17/2016 6/18/2016 First Class TB-21055 Ted ButterfieldConsumer Troy 12180 East OFF-AR-10001
CA-2015-1355 11/24/2015 11/30/2015 Standard ClassKM-16720 Kunst Miller Consumer Los Angeles 90004 West TEC-AC-10004
CA-2015-1355 11/24/2015 11/30/2015 Standard ClassKM-16720 Kunst Miller Consumer Los Angeles 90004 West OFF-BI-100010
CA-2015-1355 11/24/2015 11/30/2015 Standard ClassKM-16720 Kunst Miller Consumer Los Angeles 90004 West OFF-PA-10003
CA-2015-1355 11/24/2015 11/30/2015 Standard ClassKM-16720 Kunst Miller Consumer Los Angeles 90004 West FUR-FU-10000
US-2015-1641 4/30/2015 5/5/2015 Standard ClassPS-18970 Paul Stevenso Home Office Chicago 60610 Central FUR-CH-10001
CA-2014-1063 12/5/2014 12/10/2014 Standard ClassBS-11590 Brendan SweeCorporate Gilbert 85234 West OFF-AR-10002
CA-2015-135 11/24/2015 11/30/2015 Standard ClasKM-16720 Kunst Miller Consumer Los Angeles 90004 West TEC-AC-1000
US-2015-164 4/30/2015 5/5/2015 Standard ClasPS-18970 Paul Stevens Home Office Chicago 60610 Central FUR-CH-1000
Category Sub-Category Product NameSales Quantity Discount Profit
Furniture Bookcases Bush Somerset 261.96 2 0 41.9136
Furniture Chairs Hon Deluxe Fab 731.94 3 0 219.582
Office SuppliesLabels Self-Adhesive 14.62 2 0 6.8714
Furniture Tables Bretford CR450 957.58 5 0.45 -383.031
Office SuppliesStorage Eldon Fold 'N R 22.37 2 0.2 2.5164
Furniture Furnishings Eldon Expressi 48.86 7 0 14.1694
Office SuppliesArt Newell 322 7.28 4 1.9656
Technology Phones Mitel 5320 IP 907.15 6 0.2 90.7152
Office SuppliesBinders DXL Angle-View 18.50 3 0.2 5.7825
Office SuppliesAppliances Belkin F5C206V 114.90 5 0 34.47
Furniture Tables Chromcraft Rec 1706.18 9 0.2 85.3092
Technology Phones Konftel 250 Conference
911.42
phone - Charcoal black
4 0.2 68.3568
Office SuppliesPaper Xerox 1967 15.55 3 0.2 5.4432
Office SuppliesBinders Fellowes PB200 407.98 3 0.2 132.5922
Office SuppliesAppliances Holmes Replace 68.81 5 0.8 -123.858
Office SuppliesBinders Storex DuraTec 2.54 3 0.8 -3.816
Office SuppliesStorage Stur-D-Stor She 665.88 6 13.3176
Office SuppliesStorage Fellowes Super 55.50 2 0 9.99
Office SuppliesArt Newell 341 8.56 2 0 2.4824
Technology Phones Cisco SPA 501G 213.48 3 0.2 16.011
Office SuppliesBinders 22.72 4 0.2 7.384
Office SuppliesArt Newell 318 19.46 7 0 5.0596
Office SuppliesAppliances Acco Six-Outlet 60.34 7 0 15.6884
Furniture Chairs Global Deluxe 71.37 2 0.3 -1.0196
Furniture Bretford CR450 1044.63 3 0 240.2649
Office SuppliesBinders Wilson Jones A 11.65 2 4.2224
Technology Accessories Imation 8GB Mini TravelDrive
90.57 USB 2.0 Flash
3 Drive 0 11.7741
Furniture Bookcases Riverside Pala 3083.43 7 0.5 -1665.0522
Office Supplies Avery Recycled 9.62 2 0.7 -7.0532
Furniture Furnishings Howard Miller 124.20 3 0.2 15.525
Office SuppliesEnvelopes Poly String Tie 3.26 2 1.1016
Office SuppliesArt 86.30 6 0.2 9.7092
Office SuppliesBinders Acco Pressboar 6.86 6 0.7 -5.715
Office SuppliesArt Lumber Crayon 15.76 2 0.2 3.546
Office SuppliesPaper Easy-staple pa 29.47 3 0.2 9.9468
Technology Phones GE 30524EE4 1097.54 7 0.2 123.4737
Furniture Furnishings Electrix Archi 190.92 5 0.6 -147.963
Office SuppliesEnvelopes #10-4 1/8" x 9 113.33 9 0.2 35.415
Furniture Bookcases Atlantic Metal 532.40 3 0.32 -46.9764
Furniture Chairs Global Fabric 212.06 3 -15.147
Technology Phones Plantronics HL 371.17 4 0.2 41.7564
Technology Phones Panasonic Kx- 147.17 4 0.2 16.5564
Office SuppliesStorage Eldon Base for 77.88 2 0 3.894
Office SuppliesStorage Advantus 10-D 95.62 2 0.2 9.5616
Technology Accessories Verbatim 25 GB 45.98 2 0 19.7714
Office SuppliesBinders Wilson Jones L 17.46 2 0 8.2062
Office SuppliesStorage Gould Plastics 211.96 4 0 8.4784
Technology Accessories Imation 8gb Micro Traveldrive
45.00 Usb 2.0 Flash
3 Drive 0 4.95
Technology Phones LF Elite 3D Daz 21.80 2 0 6.104
Office SuppliesBinders C-Line Peel & S 38.22 6 0 17.9634
Office SuppliesLabels Avery 485 75.18 6 0 35.3346
Furniture Furnishings Longer-Life So 6.16 2 0 2.9568
Furniture Chairs Global Leather 89.99 1 0 17.0981
Office SuppliesFasteners Advantus Push 15.26 7 0 6.2566
Technology Phones AT&T CL83451 1029.95 5 0 298.6855
Office SuppliesStorage Home/Office Pe 208.56 6 0 52.14
Office SuppliesPaper Xerox 232 32.40 5 0 15.552
Furniture Chairs Novimex Turbo 319.41 5 0.1 7.098
Office SuppliesPaper Array Parchmen 14.56 2 0 6.9888
Technology Accessories Imation 8gb Micro Traveldrive
30.00 Usb 2.0 Flash
2 Drive 0 3.3
Office SuppliesBinders Plastic Bindin 48.48 4 0.2 16.362
Office SuppliesArt Prang Dustless 1.68 1 0 0.84
Technology Accessories Verbatim 25 GB 13.98 2 0 6.1512
Office SuppliesBinders Acco PRESSTEX 25.82 6 0.2 9.3612
Office SuppliesPaper Xerox 1943 146.73 3 0 68.9631
Furniture Furnishings Luxo Economy 79.76 4 0 22.3328
Furniture Chairs Global Value M 213.12 5 0.3 -15.2225
Office SuppliesArt Hunt BOSTON Mo 1113.02 8 0.2 111.3024
Technology Accessories Verbatim 25 G 13.98 2 0 6.1512
Furniture Chairs Global Value 213.12 5 0.3 -15.2225
Cek Kualitas Data
Nama Kolom Jumlah Cell Terisi Jumlah Cell Kosong Total Data
Ship Mode 70 0 70
Customer ID 70 0 70
Customer Name 69 1 70
Presentase
0.000%
0.000%
1.429%
No Penjualan Nama Produk Harga Penjualan Tanggal Penjualan (Tanggal/Bulan/Tahun)
Apple Iphone 15 5/2/2025
Microwave
Monitor
Excel
Kumpulan Produk
Hidroponik Wick
Apple Iphone 15
Mixer
Microwave
Laptop
Photo
Kamera
Buku
Kacamata
Monitor
Excel