検索PP練習元1.xlsx

	B	C	D	E	F	G	H
1
2
3	売上日	商品	売上個数	価格	税込み価格	担当者	担当者インセンティブ
4	45665	S0006	1	210000	231000	A0006	2100
5	45661	S0007	4	300	330	A0007	3
6	45674	S0003	8	125000	137500	A0003	1250
7	45658	S0007	10	300	330	A0007	3
8	45668	S0008	8	100	110	A0008	1
9	45660	S0010	1	9800	10780	A00010	98
10	45674	S0008	7	100	110	A0008	1
11	45660	S0007	8	300	330	A0007	3
12	45666	S0001	10	120000	132000	A0001	1200
13	45667	S0002	10	78000	85800	A0002	780
14	45660	S0003	1	125000	137500	A0003	1250
15	45668	S0010	10	9800	10780	A00010	98
16	45672	S0007	5	300	330	A0007	3
17	45671	S0001	9	120000	132000	A0001	1200
18	45665	S0010	3	9800	10780	A00010	98
19	45674	S0007	8	300	330	A0007	3
20	45667	S0002	9	78000	85800	A0002	780
21	45664	S0003	5	125000	137500	A0003	1250
22	45660	S0003	3	125000	137500	A0003	1250
23	45672	S0010	3	9800	10780	A00010	98
24	45660	S0001	3	120000	132000	A0001	1200
25	45658	S0001	5	120000	132000	A0001	1200
26	45660	S0007	2	300	330	A0007	3
27	45675	S0005	8	27000	29700	A0005	270
28	45667	S0009	4	1500	1650	A0009	15
29	45669	S0003	7	125000	137500	A0003	1250
30	45667	S0001	9	120000	132000	A0001	1200
31	45666	S0005	1	27000	29700	A0005	270
32	45667	S0006	6	210000	231000	A0006	2100
33	45659	S0005	1	27000	29700	A0005	270
34	45668	S0007	1	300	330	A0007	3
35	45666	S0001	5	120000	132000	A0001	1200
36	45668	S0004	8	86000	94600	A0004	860
37	45676	S0010	3	9800	10780	A00010	98
38	45672	S0009	5	1500	1650	A0009	15
39	45668	S0002	10	78000	85800	A0002	780
40	45673	S0005	3	27000	29700	A0005	270
41	45666	S0001	4	120000	132000	A0001	1200
42	45664	S0004	7	86000	94600	A0004	860
43	45660	S0007	8	300	330	A0007	3
44	45658	S0005	6	27000	29700	A0005	270
45	45666	S0004	3	86000	94600	A0004	860
46	45668	S0007	9	300	330	A0007	3
47	45668	S0003	6	125000	137500	A0003	1250
48	45671	S0004	3	86000	94600	A0004	860
49	45668	S0005	4	27000	29700	A0005	270
50	45664	S0001	2	120000	132000	A0001	1200
51	45661	S0009	3	1500	1650	A0009	15
52	45674	S0005	3	27000	29700	A0005	270
53	45676	S0009	9	1500	1650	A0009	15
54	45672	S0001	7	120000	132000	A0001	1200
55	45667	S0007	4	300	330	A0007	3
56	45676	S0006	2	210000	231000	A0006	2100
57	45661	S0005	4	27000	29700	A0005	270
58	45665	S0009	3	1500	1650	A0009	15
59	45659	S0002	10	78000	85800	A0002	780
60	45671	S0003	4	125000	137500	A0003	1250
61	45674	S0003	1	125000	137500	A0003	1250
62	45676	S0006	3	210000	231000	A0006	2100
63	45663	S0006	1	210000	231000	A0006	2100
64	45669	S0010	3	9800	10780	A00010	98
65	45672	S0001	6	120000	132000	A0001	1200
66	45658	S0005	5	27000	29700	A0005	270
67	45666	S0003	8	125000	137500	A0003	1250
68	45668	S0009	7	1500	1650	A0009	15
69	45669	S0006	7	210000	231000	A0006	2100
70	45668	S0006	9	210000	231000	A0006	2100
71	45668	S0010	5	9800	10780	A00010	98
72	45660	S0005	9	27000	29700	A0005	270
73	45668	S0010	9	9800	10780	A00010	98
74	45667	S0009	6	1500	1650	A0009	15
75	45675	S0006	4	210000	231000	A0006	2100
76	45667	S0007	8	300	330	A0007	3
77	45667	S0007	5	300	330	A0007	3
78	45666	S0010	8	9800	10780	A00010	98
79	45672	S0009	5	1500	1650	A0009	15
80	45658	S0002	9	78000	85800	A0002	780
81	45668	S0002	8	78000	85800	A0002	780
82	45665	S0009	10	1500	1650	A0009	15
83	45665	S0006	6	210000	231000	A0006	2100
84	45674	S0002	2	78000	85800	A0002	780
85	45658	S0003	1	125000	137500	A0003	1250
86	45666	S0007	7	300	330	A0007	3
87	45663	S0009	9	1500	1650	A0009	15
88	45668	S0002	8	78000	85800	A0002	780
89	45672	S0006	2	210000	231000	A0006	2100
90	45658	S0005	8	27000	29700	A0005	270
91	45669	S0002	10	78000	85800	A0002	780
92	45675	S0010	8	9800	10780	A00010	98
93	45665	S0009	1	1500	1650	A0009	15
94	45659	S0002	9	78000	85800	A0002	780
95	45674	S0004	1	86000	94600	A0004	860
96	45658	S0009	2	1500	1650	A0009	15
97	45659	S0010	9	9800	10780	A00010	98
98	45675	S0006	8	210000	231000	A0006	2100
99	45659	S0007	7	300	330	A0007	3
100	45658	S0009	4	1500	1650	A0009	15