| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Item_Clientes | Operacion_Clientes | Codigo_Cliente | Codigo_Mercaderia | Fecha_Venta | Mes_Venta | Año_Venta | Valor_Venta_Mercaderia | Cantidad_Ventas | Total_Valor_Ventas_Mercaderia | IGV_Ventas | Total_Ventas |
2 | 000001 | OPCL000001 | CLIE000001 | MER000001 | 1/2/2024 | 1 | 2024 | $ 440.62 | 4 | $ 1,762.49 | $ 317.25 | $ 2,079.74 |
3 | 000002 | OPCL000002 | CLIE000002 | MER000002 | 1/2/2024 | 1 | 2024 | $ 398.50 | 8 | $ 3,188.02 | $ 573.84 | $ 3,761.86 |
4 | 000003 | OPCL000003 | CLIE000003 | MER000003 | 1/2/2024 | 1 | 2024 | $ 384.53 | 8 | $ 3,076.27 | $ 553.73 | $ 3,630.00 |
5 | 000004 | OPCL000004 | CLIE000004 | MER000004 | 1/2/2024 | 1 | 2024 | $ 366.23 | 4 | $ 1,464.91 | $ 263.68 | $ 1,728.59 |
6 | 000005 | OPCL000005 | CLIE000005 | MER000005 | 1/2/2024 | 1 | 2024 | $ 307.55 | 4 | $ 1,230.19 | $ 221.43 | $ 1,451.62 |
7 | 000006 | OPCL000006 | CLIE000006 | MER000006 | 1/2/2024 | 1 | 2024 | $ 435.40 | 8 | $ 3,483.22 | $ 626.98 | $ 4,110.20 |
8 | 000007 | OPCL000007 | CLIE000007 | MER000007 | 1/2/2024 | 1 | 2024 | $ 434.41 | 4 | $ 1,737.65 | $ 312.78 | $ 2,050.43 |
9 | 000008 | OPCL000008 | CLIE000008 | MER000008 | 1/2/2024 | 1 | 2024 | $ 379.01 | 4 | $ 1,516.03 | $ 272.89 | $ 1,788.92 |
10 | 000009 | OPCL000009 | CLIE000009 | MER000009 | 1/2/2024 | 1 | 2024 | $ 275.89 | 8 | $ 2,207.09 | $ 397.28 | $ 2,604.37 |
11 | 000010 | OPCL000010 | CLIE000010 | MER000010 | 1/2/2024 | 1 | 2024 | $ 350.69 | 8 | $ 2,805.55 | $ 505.00 | $ 3,310.55 |
12 | 000011 | OPCL000011 | CLIE000010 | MER000011 | 1/3/2024 | 1 | 2024 | $ 325.01 | 4 | $ 1,300.03 | $ 234.01 | $ 1,534.04 |
13 | 000012 | OPCL000012 | CLIE000010 | MER000012 | 1/3/2024 | 1 | 2024 | $ 304.69 | 4 | $ 1,218.74 | $ 219.37 | $ 1,438.11 |
14 | 000013 | OPCL000013 | CLIE000010 | MER000013 | 1/3/2024 | 1 | 2024 | $ 307.73 | 4 | $ 1,230.91 | $ 221.56 | $ 1,452.47 |
15 | 000014 | OPCL000014 | CLIE000010 | MER000014 | 1/3/2024 | 1 | 2024 | $ 368.24 | 4 | $ 1,472.98 | $ 265.14 | $ 1,738.12 |
16 | 000015 | OPCL000015 | CLIE000010 | MER000015 | 1/3/2024 | 1 | 2024 | $ 377.73 | 4 | $ 1,510.92 | $ 271.97 | $ 1,782.89 |
17 | 000016 | OPCL000016 | CLIE000010 | MER000016 | 1/3/2024 | 1 | 2024 | $ 362.25 | 8 | $ 2,898.00 | $ 521.64 | $ 3,419.64 |
18 | 000017 | OPCL000017 | CLIE000017 | MER000017 | 1/3/2024 | 1 | 2024 | $ 291.22 | 8 | $ 2,329.78 | $ 419.36 | $ 2,749.14 |
19 | 000018 | OPCL000018 | CLIE000018 | MER000018 | 1/3/2024 | 1 | 2024 | $ 366.75 | 4 | $ 1,467.00 | $ 264.06 | $ 1,731.06 |
20 | 000019 | OPCL000019 | CLIE000019 | MER000019 | 1/3/2024 | 1 | 2024 | $ 364.72 | 4 | $ 1,458.86 | $ 262.59 | $ 1,721.45 |
21 | 000020 | OPCL000020 | CLIE000020 | MER000020 | 1/3/2024 | 1 | 2024 | $ 306.09 | 8 | $ 2,448.72 | $ 440.77 | $ 2,889.49 |
22 | 000021 | OPCL000021 | CLIE000021 | MER000021 | 1/4/2024 | 1 | 2024 | $ 393.26 | 8 | $ 3,146.11 | $ 566.30 | $ 3,712.41 |
23 | 000022 | OPCL000022 | CLIE000022 | MER000022 | 1/4/2024 | 1 | 2024 | $ 441.25 | 4 | $ 1,765.01 | $ 317.70 | $ 2,082.71 |
24 | 000023 | OPCL000023 | CLIE000023 | MER000023 | 1/4/2024 | 1 | 2024 | $ 288.45 | 8 | $ 2,307.60 | $ 415.37 | $ 2,722.97 |
25 | 000024 | OPCL000024 | CLIE000024 | MER000024 | 1/4/2024 | 1 | 2024 | $ 285.26 | 8 | $ 2,282.11 | $ 410.78 | $ 2,692.89 |
26 | 000025 | OPCL000025 | CLIE000025 | MER000025 | 1/4/2024 | 1 | 2024 | $ 447.08 | 8 | $ 3,576.67 | $ 643.80 | $ 4,220.47 |
27 | 000026 | OPCL000026 | CLIE000026 | MER000026 | 1/4/2024 | 1 | 2024 | $ 299.21 | 4 | $ 1,196.86 | $ 215.43 | $ 1,412.29 |
28 | 000027 | OPCL000027 | CLIE000027 | MER000027 | 1/4/2024 | 1 | 2024 | $ 438.05 | 4 | $ 1,752.19 | $ 315.39 | $ 2,067.58 |
29 | 000028 | OPCL000028 | CLIE000028 | MER000028 | 1/4/2024 | 1 | 2024 | $ 338.08 | 4 | $ 1,352.30 | $ 243.41 | $ 1,595.71 |
30 | 000029 | OPCL000029 | CLIE000029 | MER000029 | 1/4/2024 | 1 | 2024 | $ 345.62 | 8 | $ 2,764.94 | $ 497.69 | $ 3,262.63 |
31 | 000030 | OPCL000030 | CLIE000030 | MER000030 | 1/4/2024 | 1 | 2024 | $ 321.57 | 8 | $ 2,572.56 | $ 463.06 | $ 3,035.62 |
32 | 000031 | OPCL000031 | CLIE000031 | MER000031 | 1/5/2024 | 1 | 2024 | $ 359.84 | 8 | $ 2,878.70 | $ 518.17 | $ 3,396.87 |
33 | 000032 | OPCL000032 | CLIE000032 | MER000032 | 1/5/2024 | 1 | 2024 | $ 330.97 | 8 | $ 2,647.73 | $ 476.59 | $ 3,124.32 |
34 | 000033 | OPCL000033 | CLIE000033 | MER000033 | 1/5/2024 | 1 | 2024 | $ 300.44 | 4 | $ 1,201.75 | $ 216.32 | $ 1,418.07 |
35 | 000034 | OPCL000034 | CLIE000034 | MER000034 | 1/5/2024 | 1 | 2024 | $ 278.24 | 4 | $ 1,112.98 | $ 200.34 | $ 1,313.32 |
36 | 000035 | OPCL000035 | CLIE000035 | MER000035 | 1/5/2024 | 1 | 2024 | $ 350.06 | 4 | $ 1,400.26 | $ 252.05 | $ 1,652.31 |
37 | 000036 | OPCL000036 | CLIE000036 | MER000036 | 1/5/2024 | 1 | 2024 | $ 347.99 | 4 | $ 1,391.98 | $ 250.56 | $ 1,642.54 |
38 | 000037 | OPCL000037 | CLIE000037 | MER000037 | 1/5/2024 | 1 | 2024 | $ 367.83 | 4 | $ 1,471.32 | $ 264.84 | $ 1,736.16 |
39 | 000038 | OPCL000038 | CLIE000038 | MER000038 | 1/5/2024 | 1 | 2024 | $ 345.44 | 8 | $ 2,763.50 | $ 497.43 | $ 3,260.93 |
40 | 000039 | OPCL000039 | CLIE000039 | MER000039 | 1/5/2024 | 1 | 2024 | $ 321.91 | 4 | $ 1,287.65 | $ 231.78 | $ 1,519.43 |
41 | 000040 | OPCL000040 | CLIE000040 | MER000040 | 1/5/2024 | 1 | 2024 | $ 320.08 | 8 | $ 2,560.61 | $ 460.91 | $ 3,021.52 |
42 | 000041 | OPCL000041 | CLIE000001 | MER000041 | 1/6/2024 | 1 | 2024 | $ 343.67 | 8 | $ 2,749.39 | $ 494.89 | $ 3,244.28 |
43 | 000042 | OPCL000042 | CLIE000002 | MER000042 | 1/6/2024 | 1 | 2024 | $ 343.33 | 4 | $ 1,373.33 | $ 247.20 | $ 1,620.53 |
44 | 000043 | OPCL000043 | CLIE000003 | MER000043 | 1/6/2024 | 1 | 2024 | $ 317.29 | 4 | $ 1,269.14 | $ 228.45 | $ 1,497.59 |
45 | 000044 | OPCL000044 | CLIE000004 | MER000044 | 1/6/2024 | 1 | 2024 | $ 272.97 | 4 | $ 1,091.88 | $ 196.54 | $ 1,288.42 |
46 | 000045 | OPCL000045 | CLIE000005 | MER000045 | 1/6/2024 | 1 | 2024 | $ 439.78 | 4 | $ 1,759.10 | $ 316.64 | $ 2,075.74 |
47 | 000046 | OPCL000046 | CLIE000006 | MER000046 | 1/6/2024 | 1 | 2024 | $ 414.50 | 8 | $ 3,316.03 | $ 596.89 | $ 3,912.92 |
48 | 000047 | OPCL000047 | CLIE000007 | MER000047 | 1/6/2024 | 1 | 2024 | $ 290.86 | 8 | $ 2,326.90 | $ 418.84 | $ 2,745.74 |
49 | 000048 | OPCL000048 | CLIE000008 | MER000048 | 1/6/2024 | 1 | 2024 | $ 312.82 | 4 | $ 1,251.29 | $ 225.23 | $ 1,476.52 |
50 | 000049 | OPCL000049 | CLIE000009 | MER000049 | 1/6/2024 | 1 | 2024 | $ 418.27 | 8 | $ 3,346.13 | $ 602.30 | $ 3,948.43 |
51 | 000050 | OPCL000050 | CLIE000010 | MER000050 | 1/6/2024 | 1 | 2024 | $ 405.43 | 4 | $ 1,621.73 | $ 291.91 | $ 1,913.64 |
52 | 000051 | OPCL000051 | CLIE000011 | MER000051 | 1/7/2024 | 1 | 2024 | $ 292.93 | 8 | $ 2,343.46 | $ 421.82 | $ 2,765.28 |
53 | 000052 | OPCL000052 | CLIE000012 | MER000052 | 1/7/2024 | 1 | 2024 | $ 293.47 | 8 | $ 2,347.78 | $ 422.60 | $ 2,770.38 |
54 | 000053 | OPCL000053 | CLIE000013 | MER000053 | 1/7/2024 | 1 | 2024 | $ 331.45 | 4 | $ 1,325.81 | $ 238.65 | $ 1,564.46 |
55 | 000054 | OPCL000054 | CLIE000014 | MER000054 | 1/7/2024 | 1 | 2024 | $ 283.64 | 4 | $ 1,134.58 | $ 204.22 | $ 1,338.80 |
56 | 000055 | OPCL000055 | CLIE000015 | MER000055 | 1/7/2024 | 1 | 2024 | $ 394.94 | 8 | $ 3,159.50 | $ 568.71 | $ 3,728.21 |
57 | 000056 | OPCL000056 | CLIE000016 | MER000056 | 1/7/2024 | 1 | 2024 | $ 356.71 | 4 | $ 1,426.82 | $ 256.83 | $ 1,683.65 |
58 | 000057 | OPCL000057 | CLIE000017 | MER000057 | 1/7/2024 | 1 | 2024 | $ 324.49 | 4 | $ 1,297.94 | $ 233.63 | $ 1,531.57 |
59 | 000058 | OPCL000058 | CLIE000018 | MER000058 | 1/7/2024 | 1 | 2024 | $ 272.61 | 4 | $ 1,090.44 | $ 196.28 | $ 1,286.72 |
60 | 000059 | OPCL000059 | CLIE000019 | MER000059 | 1/7/2024 | 1 | 2024 | $ 404.08 | 8 | $ 3,232.66 | $ 581.88 | $ 3,814.54 |
61 | 000060 | OPCL000060 | CLIE000020 | MER000060 | 1/7/2024 | 1 | 2024 | $ 277.51 | 4 | $ 1,110.02 | $ 199.80 | $ 1,309.82 |
62 | 000061 | OPCL000061 | CLIE000021 | MER000061 | 1/8/2024 | 1 | 2024 | $ 417.15 | 8 | $ 3,337.20 | $ 600.70 | $ 3,937.90 |
63 | 000062 | OPCL000062 | CLIE000022 | MER000062 | 1/8/2024 | 1 | 2024 | $ 292.57 | 8 | $ 2,340.58 | $ 421.30 | $ 2,761.88 |
64 | 000063 | OPCL000063 | CLIE000023 | MER000063 | 1/8/2024 | 1 | 2024 | $ 403.90 | 8 | $ 3,231.22 | $ 581.62 | $ 3,812.84 |
65 | 000064 | OPCL000064 | CLIE000024 | MER000064 | 1/8/2024 | 1 | 2024 | $ 398.93 | 8 | $ 3,191.47 | $ 574.46 | $ 3,765.93 |
66 | 000065 | OPCL000065 | CLIE000025 | MER000065 | 1/8/2024 | 1 | 2024 | $ 311.42 | 8 | $ 2,491.34 | $ 448.44 | $ 2,939.78 |
67 | 000066 | OPCL000066 | CLIE000026 | MER000066 | 1/8/2024 | 1 | 2024 | $ 397.93 | 4 | $ 1,591.70 | $ 286.51 | $ 1,878.21 |
68 | 000067 | OPCL000067 | CLIE000027 | MER000067 | 1/8/2024 | 1 | 2024 | $ 432.09 | 8 | $ 3,456.72 | $ 622.21 | $ 4,078.93 |
69 | 000068 | OPCL000068 | CLIE000028 | MER000068 | 1/8/2024 | 1 | 2024 | $ 290.05 | 4 | $ 1,160.21 | $ 208.84 | $ 1,369.05 |
70 | 000069 | OPCL000069 | CLIE000029 | MER000069 | 1/8/2024 | 1 | 2024 | $ 301.57 | 4 | $ 1,206.29 | $ 217.13 | $ 1,423.42 |
71 | 000070 | OPCL000070 | CLIE000030 | MER000070 | 1/8/2024 | 1 | 2024 | $ 330.08 | 8 | $ 2,640.67 | $ 475.32 | $ 3,115.99 |
72 | 000071 | OPCL000071 | CLIE000031 | MER000071 | 1/9/2024 | 1 | 2024 | $ 354.80 | 8 | $ 2,838.38 | $ 510.91 | $ 3,349.29 |
73 | 000072 | OPCL000072 | CLIE000032 | MER000072 | 1/9/2024 | 1 | 2024 | $ 281.47 | 8 | $ 2,251.73 | $ 405.31 | $ 2,657.04 |
74 | 000073 | OPCL000073 | CLIE000010 | MER000073 | 1/9/2024 | 1 | 2024 | $ 397.17 | 8 | $ 3,177.36 | $ 571.92 | $ 3,749.28 |
75 | 000074 | OPCL000074 | CLIE000010 | MER000074 | 1/9/2024 | 1 | 2024 | $ 361.03 | 4 | $ 1,444.10 | $ 259.94 | $ 1,704.04 |
76 | 000075 | OPCL000075 | CLIE000010 | MER000075 | 1/9/2024 | 1 | 2024 | $ 367.85 | 4 | $ 1,471.39 | $ 264.85 | $ 1,736.24 |
77 | 000076 | OPCL000076 | CLIE000010 | MER000076 | 1/9/2024 | 1 | 2024 | $ 401.40 | 4 | $ 1,605.60 | $ 289.01 | $ 1,894.61 |
78 | 000077 | OPCL000077 | CLIE000010 | MER000077 | 1/9/2024 | 1 | 2024 | $ 401.24 | 4 | $ 1,604.95 | $ 288.89 | $ 1,893.84 |
79 | 000078 | OPCL000078 | CLIE000010 | MER000078 | 1/9/2024 | 1 | 2024 | $ 285.30 | 4 | $ 1,141.20 | $ 205.42 | $ 1,346.62 |
80 | 000079 | OPCL000079 | CLIE000010 | MER000079 | 1/9/2024 | 1 | 2024 | $ 271.39 | 8 | $ 2,171.09 | $ 390.80 | $ 2,561.89 |
81 | 000080 | OPCL000080 | CLIE000040 | MER000080 | 1/9/2024 | 1 | 2024 | $ 296.64 | 4 | $ 1,186.56 | $ 213.58 | $ 1,400.14 |
82 | 000081 | OPCL000081 | CLIE000001 | MER000081 | 1/10/2024 | 1 | 2024 | $ 271.24 | 4 | $ 1,084.97 | $ 195.29 | $ 1,280.26 |
83 | 000082 | OPCL000082 | CLIE000002 | MER000082 | 1/10/2024 | 1 | 2024 | $ 395.95 | 8 | $ 3,167.57 | $ 570.16 | $ 3,737.73 |
84 | 000083 | OPCL000083 | CLIE000003 | MER000083 | 1/10/2024 | 1 | 2024 | $ 306.81 | 8 | $ 2,454.48 | $ 441.81 | $ 2,896.29 |
85 | 000084 | OPCL000084 | CLIE000004 | MER000084 | 1/10/2024 | 1 | 2024 | $ 366.25 | 4 | $ 1,464.98 | $ 263.70 | $ 1,728.68 |
86 | 000085 | OPCL000085 | CLIE000005 | MER000085 | 1/10/2024 | 1 | 2024 | $ 366.71 | 4 | $ 1,466.86 | $ 264.03 | $ 1,730.89 |
87 | 000086 | OPCL000086 | CLIE000006 | MER000086 | 1/10/2024 | 1 | 2024 | $ 343.66 | 8 | $ 2,749.25 | $ 494.87 | $ 3,244.12 |
88 | 000087 | OPCL000087 | CLIE000007 | MER000087 | 1/10/2024 | 1 | 2024 | $ 349.40 | 8 | $ 2,795.18 | $ 503.13 | $ 3,298.31 |
89 | 000088 | OPCL000088 | CLIE000008 | MER000088 | 1/10/2024 | 1 | 2024 | $ 305.53 | 8 | $ 2,444.26 | $ 439.97 | $ 2,884.23 |
90 | 000089 | OPCL000089 | CLIE000009 | MER000089 | 1/10/2024 | 1 | 2024 | $ 443.99 | 8 | $ 3,551.90 | $ 639.34 | $ 4,191.24 |
91 | 000090 | OPCL000090 | CLIE000010 | MER000090 | 1/10/2024 | 1 | 2024 | $ 342.97 | 8 | $ 2,743.78 | $ 493.88 | $ 3,237.66 |
92 | 000091 | OPCL000091 | CLIE000011 | MER000091 | 1/11/2024 | 1 | 2024 | $ 270.54 | 4 | $ 1,082.16 | $ 194.79 | $ 1,276.95 |
93 | 000092 | OPCL000092 | CLIE000012 | MER000092 | 1/11/2024 | 1 | 2024 | $ 323.42 | 4 | $ 1,293.70 | $ 232.87 | $ 1,526.57 |
94 | 000093 | OPCL000093 | CLIE000013 | MER000093 | 1/11/2024 | 1 | 2024 | $ 353.20 | 4 | $ 1,412.78 | $ 254.30 | $ 1,667.08 |
95 | 000094 | OPCL000094 | CLIE000014 | MER000094 | 1/11/2024 | 1 | 2024 | $ 322.90 | 4 | $ 1,291.61 | $ 232.49 | $ 1,524.10 |
96 | 000095 | OPCL000095 | CLIE000015 | MER000095 | 1/11/2024 | 1 | 2024 | $ 368.60 | 4 | $ 1,474.42 | $ 265.40 | $ 1,739.82 |
97 | 000096 | OPCL000096 | CLIE000016 | MER000096 | 1/11/2024 | 1 | 2024 | $ 401.53 | 4 | $ 1,606.10 | $ 289.10 | $ 1,895.20 |
98 | 000097 | OPCL000097 | CLIE000017 | MER000097 | 1/11/2024 | 1 | 2024 | $ 278.39 | 8 | $ 2,227.10 | $ 400.88 | $ 2,627.98 |
99 | 000098 | OPCL000098 | CLIE000018 | MER000098 | 1/11/2024 | 1 | 2024 | $ 332.15 | 8 | $ 2,657.23 | $ 478.30 | $ 3,135.53 |
100 | 000099 | OPCL000099 | CLIE000019 | MER000099 | 1/11/2024 | 1 | 2024 | $ 301.54 | 4 | $ 1,206.14 | $ 217.11 | $ 1,423.25 |