Mentahan Simplification of Data TIK X.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Order ID	Order Date	Product Name	Categories Name	Unit Price	Quantity	Discount	total	Employee Name	Customers Name	Customer Country
2	10248	10/1/2022	Queso Cabrales	Dairy Products		12	0	166	Buchanian, Steven	Vins et Alcools Chevalier	France
3	10248	10/2/2022	Singaporean Hokkien Fried Mee	Grains/Cereals	14	10	0	98	Buchanian, Steven	Vins et Alcools Chevalier	France
4	10248	10/3/2022	Mozarella di Glovanni	Produce	34,8	5	0	174	Buchanian, Steven	Vins et Alcools Chevalier	France
5	10249	10/4/2022	tofu	Produce	18,6	9	0	167,4	Suyama, Michael	Toms Spezialitation	Germany
6	10249	10/5/2022	Manjimup Dired Apples	Seafood	42,4	40	0	1696	Suyama, Michael	Toms Spezialitation	Germany
7	10250	10/6/2022	Jakc's New England Clam Chowder	Produce	7,7	10	0	77	Peacock, Margaret	Hanarl Carries	Brazil
8	10250	10/7/2022	Manjimup Dired Apples	Condiments	40	35	0	1261,4	Peacock, Margaret	Hanarl Carries	Brazil
9	10250	10/8/2022	Lousiana Fiery Hot pepper Sauce	Grains/Cereals	30	15	0,15	214,2	Peacock, Margaret	Hanarl Carries	Brazil
10	10251	10/9/2022	gustaf's Knackebrod	Grains/Cereals	32	6	0,15	95,76	Leverling, Janet	Victuallies en stock	France
11	10251	10/10/2022	Ravioli Angelo	Condiments	15,6	15	0,05	222,3	Leverling, Janet	Victuallies en stock	France
12	10251	10/11/2022	Lousiana Fiery Hot pepper Sauce	Confections	24	20	0,05	336	Leverling, Janet	Victuallies en stock	France
13	10252	10/12/2022	Sir Rodney's Marmalade	Confections	16,8	40	0	2462,4	Peacock, Margaret	Supreme Delices	Belgium
14	10252	10/13/2022	Geitost	Dairy Products	64,8	25	0,05	47,5	Peacock, Margaret	Supreme Delices	Belgium
15	10252	10/14/2022	Camembert Pierrot	Dairy Products	2	40	0,05	1088	Peacock, Margaret	Supreme Delices	Belgium
16	10252	10/15/2022	Gorgonzola Telino	Dairy Products	27,2	20	0	200	Leverling, Janet	Hanarl Carries	Brazil
17	10252	10/16/2022	Chartreuse Verte	Beverages	10	12	0	604,8	Leverling, Janet	Hanarl Carries	Brazil
18	10252	10/17/2022	Maxilaku	Confections	14,4	40	0	640	Leverling, Janet	Hanarl Carries	Brazil
19	10253	10/18/2022	guarana Fantastica	Beverages	16	15	0,15	45,9	Buchanian, Steven	Chop suey Chinese	Switzerland
20	10253	10/19/2022	Pate Chinois	Meat/Poultry	19,2	21	0,15	342,72	Buchanian, Steven	Chop suey Chinese	Switzerland
21	10248	10/1/2023	Queso Cabrales	Dairy Products	15	12	0	166	Buchanian, Steven	Vins et Alcools Chevalier	France
22	10248	10/2/2023	Singaporean Hokkien Fried Mee	Grains/Cereals	9,8	10	0	98	Buchanian, Steven	Vins et Alcools Chevalier	France
23	10248	10/3/2023	Mozarella di Glovanni	Produce	34,8	5	0	174	Buchanian, Steven	Vins et Alcools Chevalier	France
24	10249	10/4/2023	tofu	Produce	18,6	9	0	167,4	Suyama, Michael	Toms Spezialitation	Germany
25	10249	10/5/2023	Manjimup Dired Apples	Seafood	22	40	0	1696	Suyama, Michael	Toms Spezialitation	Germany
26	10250	10/6/2023	Jakc's New England Clam Chowder	Produce	7,7	10	0	77	Peacock, Margaret	Hanarl Carries	Brazil
27	10250	10/7/2023	Manjimup Dired Apples	Condiments	42,4	35	0	1261,4	Peacock, Margaret	Hanarl Carries	Brazil
28	10250	10/8/2023	Lousiana Fiery Hot pepper Sauce	Grains/Cereals	16,8	15	0,15	214,2	Peacock, Margaret	Hanarl Carries	Brazil
29	10251	10/9/2023	gustaf's Knackebrod	Grains/Cereals	16,8	6	0,15	95,76	Leverling, Janet	Victuallies en stock	France
30	10251	10/10/2023	Ravioli Angelo	Condiments	20	15	0,05	222,3	Leverling, Janet	Victuallies en stock	France
31	10251	10/11/2023	Lousiana Fiery Hot pepper Sauce	Confections	33	20	0,05	336	Leverling, Janet	Victuallies en stock	France
32	10252	10/12/2023	Sir Rodney's Marmalade	Confections	14	40	0	2462,4	Peacock, Margaret	Supreme Delices	Belgium
33	10252	10/13/2023	Geitost	Dairy Products	45	25	0,05	47,5	Peacock, Margaret	Supreme Delices	Belgium
34	10252	10/14/2023	Camembert Pierrot	Dairy Products	2	40	0,05	1088	Peacock, Margaret	Supreme Delices	Belgium
35	10252	10/15/2023	Gorgonzola Telino	Dairy Products	27,2	20	0	200	Leverling, Janet	Hanarl Carries	Brazil
36	10252	10/16/2023	Chartreuse Verte	Beverages	10	12	0	604,8	Leverling, Janet	Hanarl Carries	Brazil
37	10252	10/17/2023	Maxilaku	Confections	14,4	40	0	640	Leverling, Janet	Hanarl Carries	Brazil
38	10253	10/18/2024	guarana Fantastica	Beverages	16	15	0,15	45,9	Buchanian, Steven	Chop suey Chinese	Switzerland
39	10253	10/19/2024	Pate Chinois	Meat/Poultry	19,2	21	0,15	342,72	Buchanian, Steven	Chop suey Chinese	Switzerland
40	10248	10/20/2024	Queso Cabrales	Dairy Products	14	12	0	166	Buchanian, Steven	Vins et Alcools Chevalier	France
41	10248	10/21/2024	Singaporean Hokkien Fried Mee	Grains/Cereals	9,8	10	0	98	Buchanian, Steven	Vins et Alcools Chevalier	France
42	10248	10/22/2024	Mozarella di Glovanni	Produce	34,8	5	0	174	Buchanian, Steven	Vins et Alcools Chevalier	France
43	10249	10/23/2024	tofu	Produce	18,6	9	0	167,4	Suyama, Michael	Toms Spezialitation	Germany
44	10249	10/24/2024	Manjimup Dired Apples	Seafood	42,4	40	0	1696	Suyama, Michael	Toms Spezialitation	Germany
45	10250	10/25/2024	Jakc's New England Clam Chowder	Produce	7,7	10	0	77	Peacock, Margaret	Hanarl Carries	Brazil
46	10250	10/26/2024	Manjimup Dired Apples	Condiments	89	35	0	1261,4	Peacock, Margaret	Hanarl Carries	Brazil
47	10250	10/27/2024	Lousiana Fiery Hot pepper Sauce	Grains/Cereals	99	15	0,15	214,2	Peacock, Margaret	Hanarl Carries	Brazil
48	10251	10/28/2024	gustaf's Knackebrod	Grains/Cereals	34	6	0,15	95,76	Leverling, Janet	Victuallies en stock	France
49	10251	10/29/2024	Ravioli Angelo	Condiments	32	15	0,05	222,3	Leverling, Janet	Victuallies en stock	France
50	10251	10/30/2024	Lousiana Fiery Hot pepper Sauce	Confections	33	20	0,05	336	Leverling, Janet	Victuallies en stock	France
51	10252	10/31/2024	Sir Rodney's Marmalade	Confections	34	40	0	2462,4	Peacock, Margaret	Supreme Delices	Belgium
52	10252	11/1/2024	Geitost	Dairy Products	21	25	0,05	47,5	Peacock, Margaret	Supreme Delices	Belgium
53	10252	11/2/2024	Camembert Pierrot	Dairy Products	2	40	0,05	1088	Peacock, Margaret	Supreme Delices	Belgium
54	10252	11/3/2024	Gorgonzola Telino	Dairy Products	30	20	0	200	Leverling, Janet	Hanarl Carries	Brazil
55	10252	11/4/2024	Chartreuse Verte	Beverages	10	12	0	604,8	Leverling, Janet	Hanarl Carries	Brazil
56	10252	11/5/2024	Maxilaku	Confections	15	40	0	640	Leverling, Janet	Hanarl Carries	Brazil
57	10253	11/6/2024	guarana Fantastica	Beverages	16	15	0,15	45,9	Buchanian, Steven	Chop suey Chinese	Switzerland
58	10253	11/7/2024	Pate Chinois	Meat/Poultry	29	21	0,15	342,72	Buchanian, Steven	Chop suey Chinese	Switzerland
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100