A colleague has passed me the below data and asked if the numbers either side of each "=" can be swapped.
I wondered about doing a text split to break down each cell and then just building it back together again, but came a bit unstuck when I realised that some cells have more than one of the "|" which I believe is acting as text separator for another piece of software where the data will be sent.
To help with clarity, cell A2 should be "1=15.38|3=13.85" and cell A15 (the first cell with 3 sets of data instead of 2) should be "1=4.25|40=1.76|120=1.65"
Please can someone advise on the best way to correct the data.
Thank you in advance!
I wondered about doing a text split to break down each cell and then just building it back together again, but came a bit unstuck when I realised that some cells have more than one of the "|" which I believe is acting as text separator for another piece of software where the data will be sent.
To help with clarity, cell A2 should be "1=15.38|3=13.85" and cell A15 (the first cell with 3 sets of data instead of 2) should be "1=4.25|40=1.76|120=1.65"
Please can someone advise on the best way to correct the data.
Thank you in advance!
Wholesale.csv | |||
---|---|---|---|
A | |||
1 | FINAL DATA | ||
2 | 15.38=1|13.85=3 | ||
3 | 21.05=1|18.94=3 | ||
4 | 23.56=1|21.21=3 | ||
5 | 31.84=1|28.66=3 | ||
6 | 48.35=1|43.51=3 | ||
7 | 53.32=1|48=3 | ||
8 | 81.61=1|73.44=3 | ||
9 | 96.72=1|87.05=3 | ||
10 | 12.14=1|10.92=10 | ||
11 | 13.34=1|12=10 | ||
12 | 4.64=1|4.18=10 | ||
13 | 1.45=1|1.2=5 | ||
14 | 3.08=1|2.36=70 | ||
15 | 4.25=1|1.76=40|1.65=120 | ||
16 | 6.31=1|5.49=10 | ||
17 | 6.36=1|5.52=12|5.26=36 | ||
18 | 15.95=1|13.87=12|13.27=36 | ||
19 | 3.08=1|2.36=60 | ||
20 | 15.26=1|11.51=12 | ||
21 | 1.9=1|1.7=100 | ||
22 | 3.08=1|2.36=60|2.16=120 | ||
23 | 6.36=1|5.52=12|5.26=36 | ||
24 | 0.93=1|0.84=100 | ||
25 | 37.25=1|33.53=5 | ||
26 | 1.2=1|1.08=100 | ||
27 | 1.47=1|1.3=100 | ||
28 | 1.45=1|1.29=100 | ||
29 | 2.33=1|2.09=120 | ||
30 | 1.28=1|1.17=100 | ||
31 | 2.27=1|2.03=50 | ||
32 | 22.4=1|20.15=5 | ||
33 | 22.93=1|21.62=5 | ||
34 | 1.62=1|1.45=100 | ||
35 | 3.26=1|2.93=50 | ||
36 | 2.64=1|2.37=50 | ||
37 | 1.62=1|1.45=50 | ||
38 | 1.7=1|1.53=100 | ||
39 | 5.17=1|4.64=12 | ||
40 | 5.17=1|4.64=12 | ||
41 | 5.17=1|4.64=12 | ||
42 | 5.17=1|4.64=12 | ||
43 | 5.17=1|4.64=12 | ||
44 | 7.15=1|6.45=12 | ||
45 | 5.17=1|4.64=12 | ||
46 | 5.17=1|4.64=12 | ||
47 | 5.17=1|4.64=12 | ||
48 | 5.17=1|4.64=10 | ||
49 | 1.8=1|1.62=60 | ||
50 | 2.52=1|2.3=25 | ||
51 | 7.36=1|6.63=10 | ||
52 | 2.06=1|1.85=50 | ||
53 | 1.56=1|1.41=10 | ||
54 | 17.26=1|15.54=10|12.43=20 | ||
55 | 17.26=1|15.54=10|12.43=20 | ||
56 | 17.26=1|15.54=10|12.43=20 | ||
57 | 18.99=1|17.1=10|13.67=20 | ||
58 | 9.25=1|8.31=10 | ||
59 | 10.12=1|9.1=10 | ||
60 | 11.18=1|10.07=10 | ||
61 | 13.38=1|12.03=10 | ||
62 | 22.8=1|20.52=10 | ||
63 | 27.51=1|24.76=10 | ||
64 | 11.54=1|10.38=56 | ||
65 | 14.09=1|12.68=48 | ||
66 | 20.04=1|16.18=48 | ||
67 | 14.83=1|13.38=56 | ||
68 | 17.52=1|14.78=56 | ||
69 | 6.72=1|6.05=12 | ||
70 | 6.72=1|6.05=12 | ||
71 | 8.25=1|7.41=4 | ||
72 | 8.25=1|7.41=4 | ||
73 | 8.25=1|7.41=4 | ||
74 | 8.25=1|7.41=4 | ||
75 | 8.25=1|7.41=4 | ||
76 | 7.19=1|6.46=4 | ||
77 | 7.19=1|6.46=4 | ||
78 | 25.78=1|27.42=1 | ||
79 | 27.42=1|27.42=1 | ||
80 | 27.42=1|27.42=1 | ||
81 | 27.42=1|17.66=1 | ||
82 | 17.66=1|15.89=56 | ||
83 | 21.73=1|19.55=56 | ||
84 | 7.87=1|7.51=60 | ||
85 | 39.55=1|35.86=3 | ||
86 | 13.57=1 | ||
87 | 19.46=1|17.51=4 | ||
88 | 6.18=1|5.49=10 | ||
89 | 4.27=1|3.85=25 | ||
90 | 4.27=1|3.85=25 | ||
91 | 4.27=1|3.85=25 | ||
92 | 3.26=1|2.93=25 | ||
93 | 4.74=1 | ||
94 | 7.66=1|6.97=6 | ||
95 | 16.61=1|14.93=3 | ||
96 | 5.13=1 | ||
97 | 16.37=1|14.76=4 | ||
98 | 16.37=1|14.76=4 | ||
99 | 16.37=1|14.76=4 | ||
100 | 16.37=1|14.76=4 | ||
101 | 17.88=1|16.08=50 | ||
102 | 22.24=1|20.02=56 | ||
103 | 12.23=1|11.02=12 | ||
104 | 2.05=1|1.85=100 | ||
105 | 2.05=1|1.85=100 | ||
106 | 1.66=1|1.5=100 | ||
107 | 1.66=1|1.5=100 | ||
108 | 1.66=1|1.5=100 | ||
109 | 1.66=1|1.5=100 | ||
110 | 1.66=1|1.5=100 | ||
111 | 1.66=1|1.5=100 | ||
112 | 1.66=1|1.5=100 | ||
113 | 1.66=1|1.5=100 | ||
114 | 16.49=1|14.91=10 | ||
115 | 16.49=1|14.91=10 | ||
116 | 16.49=1|14.91=10 | ||
117 | 16.49=1|14.91=10 | ||
118 | 16.49=1|14.91=10 | ||
119 | 16.49=1|14.91=10 | ||
120 | 16.49=1|14.91=10 | ||
121 | 16.49=1|14.91=10 | ||
122 | 8.99=1|8.08=10 | ||
123 | 4.64=1|4.18=50 | ||
124 | 5.73=1|5.13=50 | ||
125 | 8.13=1|7.31=20 | ||
126 | 7.13=1|6.42=20 | ||
127 | 10.07=1|9.05=20 | ||
128 | 9.02=1|8.13=20 | ||
129 | 2.43=1|1.78=1 | ||
130 | 1.78=1 | ||
131 | 8.74=1|7.88=20 | ||
132 | 9.56=1|8.62=20 | ||
133 | 9.56=1|8.62=20 | ||
134 | 6.4=1|5.77=5 | ||
135 | 6.67=1|6.01=5 | ||
136 | 6.67=1|6.01=5 | ||
137 | 6.33=1|5.7=20 | ||
138 | 7.86=1|7.07=20 | ||
139 | 6.33=1|5.7=20 | ||
140 | 6.67=1|6.01=20 | ||
141 | 7.86=1|7.07=20 | ||
142 | 4.9=1|4.41=20 | ||
143 | 4.9=1|4.41=20 | ||
144 | 31.5=35|25.99=65|22.5=130|20.99=325 | ||
145 | 40.41=1|31.99=50|29.99=100|28.5=250 | ||
146 | 36.5=1|32.86=10 | ||
147 | 0.79=1|0.62=220 | ||
148 | 37.65=10|33.9=60 | ||
149 | 8.62=1|7.76=10|5.59=150|5.33=300 | ||
150 | 8.62=1|7.76=10|5.95=150|5.67=300 | ||
151 | 9.09=1|8.2=10|6.56=150|6.25=300 | ||
152 | 8.62=1|7.76=10|6.14=150|5.85=300 | ||
153 | 7.56=1|6.71=10|6.15=50 | ||
154 | 70.03=1 | ||
155 | 141.61=1 | ||
156 | 151.23=1 | ||
157 | 97.01=1 | ||
158 | 118.21=1 | ||
159 | 125.73=1 | ||
160 | 140.73=1 | ||
161 | 155.72=1 | ||
162 | 178.22=1 | ||
163 | 200.71=1 | ||
164 | 0.89=1|0.77=1000 | ||
165 | 10.5=79|10.1=158|9.8=395 | ||
166 | 10.7=75|10.4=150|9.99=375 | ||
167 | 22.36=50|21.23=100|20.78=250 | ||
168 | 26.53=40|25.21=80|24.66=200 | ||
169 | 36.99=35|35.99=70|34.99=175 | ||
170 | 9=1|8.39=10 | ||
171 | 23.51=1|19.59=6 | ||
172 | 54.35=1|46.88=8 | ||
173 | 7.49=75|6.5=150|6.19=300|5.98=750 | ||
174 | 38.58=1|34.72=32 | ||
175 | 7.9=12|7.02=24|6.33=60|5.96=120 | ||
176 | 33.57=1|30.41=5 | ||
177 | 6.03=1|5.42=12 | ||
178 | 6.03=1|5.42=12 | ||
179 | 22.87=1|20.58=32 | ||
180 | 2.58=1|2.35=18 | ||
181 | 5.57=1|5.29=12 | ||
182 | 6.63=8|5.98=16|5.48=32|4.98=48 | ||
183 | 2.97=1|2.67=18 | ||
184 | 7.39=8|6.72=16|6.16=32|5.6=48 | ||
185 | 14.6=1|13.13=70 | ||
186 | 2.6=1|2.33=10 | ||
187 | 6.02=1|5.42=10 | ||
188 | 103.29=1|90.52=3 | ||
189 | 57.48=1|51.73=3 | ||
190 | 58.04=1 | ||
191 | 119.09=1|107.16=3 | ||
192 | 58.04=1 | ||
193 | 58.04=1 | ||
194 | 13.09=1|11.79=2 | ||
195 | 245.72=1|219.4=3 | ||
196 | 258.77=1|231.07=3 | ||
197 | 306.62=1|273.76=3 | ||
198 | 258.77=1|231.07=3 | ||
199 | 271.82=1|242.7=3 | ||
200 | 319.66=1|285.42=3 | ||
201 | 22.44=1|20.19=10 | ||
202 | 27.44=1|24.71=10 | ||
203 | 128.8=1|119.14=3 | ||
204 | 19.96=1|18.46=10 | ||
205 | 16.74=1|15.48=10 | ||
206 | 7.94=1 | ||
207 | 7.94=1 | ||
208 | 58.05=1|51.73=3 | ||
209 | 58.05=1|51.73=3 | ||
210 | 91.26=1|79.85=3 | ||
211 | 106.26=1|95.64=3 | ||
212 | 148.36=1|127.18=5 | ||
213 | 156.3=1|133.98=5 | ||
214 | 178.95=1|153.38=5 | ||
215 | 172.15=1|147.56=5 | ||
216 | 174.74=1|152.9=5 | ||
217 | 6.88=1|6.2=30 | ||
218 | 122.61=1|110.24=3 | ||
219 | 6.18=1|5.55=10 | ||
220 | 6.18=1|5.55=10 | ||
221 | 10.51=1|9.45=10 | ||
222 | 9.23=1|8.3=10 | ||
223 | 11.49=1|10.35=10 | ||
224 | 16.84=1|15.18=10 | ||
225 | 23.31=1|20.97=10 | ||
226 | 27.14=1|24.44=10 | ||
227 | 35.48=1|31.93=10 | ||
228 | 42.47=1|38.21=10 | ||
229 | 62.38=1|56.15=10 | ||
230 | 38.18=1|36.27=5|34.36=10 | ||
231 | 39.87=1|37.88=5|35.72=10 | ||
232 | 10.53=1|9.49=10 | ||
233 | 11.46=1|10.31=10|8.25=20 | ||
234 | 13.66=1|12.3=10|9.84=20 | ||
235 | 17.16=1|15.44=10 | ||
236 | 23.65=1|21.29=10 | ||
237 | 26.65=1|23.99=10 | ||
238 | 34.88=1|31.41=10 | ||
239 | 62.92=1|56.62=10 | ||
240 | 94.49=1|85.04=10 | ||
241 | 116.61=1|104.97=10 | ||
242 | 51.93=1|46.74=10 | ||
243 | 60.57=1|54.51=10 | ||
244 | 69.24=1|62.32=10 | ||
245 | 3.45=1|3.09=10 | ||
246 | 3.45=1|3.09=10 | ||
247 | 3.45=1|3.09=10 | ||
248 | 3.45=1|3.09=10 | ||
249 | 3.45=1|3.09=10 | ||
250 | 3.45=1|3.09=10 | ||
251 | 6.1=150|5.78=300|5.35=750 | ||
252 | 9.03=1|8.14=100|7.49=500 | ||
253 | 66.6=1 | ||
254 | 24.76=1 | ||
255 | 37.12=1 | ||
256 | 61.89=1 | ||
257 | 74.27=1 | ||
258 | 94.31=1 | ||
259 | 148.53=1 | ||
260 | 198.05=1 | ||
261 | 247.56=1 | ||
262 | 297.1=1 | ||
263 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
264 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
265 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
266 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
267 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
268 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
269 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
270 | 4.84=1|4.15=25|3.45=100 | ||
271 | 4.84=1|4.15=25|3.45=100 | ||
272 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
273 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
274 | 4.23=1|3.8=50 |3.33=100|2.92=150 | ||
275 | 4.84=1|4.15=25|3.45=100 | ||
276 | 4.23=1|3.79=25|3.16=100 | ||
277 | 6.04=1|5.43=25 | ||
278 | 4.23=1|3.79=25|3.16=100 | ||
279 | 4.84=1|4.15=25|3.45=100 | ||
280 | 4.84=1|4.15=25|3.45=100 | ||
281 | 4.84=1|4.15=25|3.45=100 | ||
282 | 4.84=1|4.15=25|3.45=100 | ||
283 | 4.84=1|4.15=25|3.45=100 | ||
284 | 4.84=1|4.15=25|3.45=100 | ||
285 | 4.84=1|4.15=25|3.45=100 | ||
286 | 4.84=1|4.15=25|3.45=100 | ||
287 | 4.84=1|4.15=25|3.45=100 | ||
288 | 4.84=1|4.15=25|3.45=100 | ||
289 | 4.84=1|4.15=25|3.45=100 | ||
290 | 4.84=1|4.15=25|3.45=100 | ||
291 | 5.83=1|5.26=5 | ||
292 | 5.83=1|5.26=5 | ||
293 | 5.83=1|5.26=5 | ||
294 | 5.83=1|5.26=5 | ||
295 | 5.83=1|5.26=5 | ||
296 | 5.83=1|5.26=5 | ||
297 | 5.83=1|5.26=5 | ||
298 | 5.83=1|5.26=5 | ||
299 | 5.83=1|5.26=5 | ||
300 | 5.83=1|5.26=5 | ||
301 | 5.83=1|5.26=5 | ||
302 | 5.83=1|5.26=5 | ||
303 | 5.83=1|5.26=5 | ||
304 | 5.83=1|5.26=5 | ||
305 | 5.83=1|5.26=5 | ||
306 | 5.83=1|5.26=5 | ||
307 | 5.83=1|5.26=5 | ||
308 | 5.83=1|5.26=5 | ||
309 | 5.83=1|5.26=5 | ||
310 | 5.83=1|5.26=5 | ||
311 | 5.83=1|5.26=5 | ||
312 | 0.91=1|0.82=100 | ||
313 | 0.98=1|0.86=100 | ||
314 | 1.08=1|0.96=100 | ||
315 | 0.92=1|0.83=100 | ||
316 | 1.05=1|0.93=100 | ||
317 | 1.11=1|1=100 | ||
318 | 6.04=1|4.87=50|4.39=100 | ||
319 | 6.04=1|4.87=50|4.39=100 | ||
320 | 6.64=1|5.97=20|5.36=50 | ||
321 | 6.64=1|5.97=20|5.36=50 | ||
322 | 5.83=1|5.26=5 | ||
323 | 5.83=1|5.26=5 | ||
324 | 6.64=1|5.97=20|5.36=50 | ||
325 | 6.64=1|5.97=20|5.36=50 | ||
326 | 5.83=1|5.26=5 | ||
327 | 5.83=1|5.26=5 | ||
328 | 6.64=1|5.97=20|5.36=50 | ||
329 | 6.64=1|5.97=20|5.36=50 | ||
330 | 5.83=1|5.26=5 | ||
331 | 5.83=1|5.26=5 | ||
332 | 6.64=1|5.97=20|5.36=50 | ||
333 | 6.64=1|5.97=20|5.36=50 | ||
334 | 5.83=1|5.26=5 | ||
335 | 5.83=1|5.26=5 | ||
336 | 5.31=1|4.77=5 | ||
337 | 5.31=1|4.77=5 | ||
338 | 6.64=1|5.97=20|5.36=50 | ||
339 | 6.64=1|5.97=20|5.36=50 | ||
340 | 5.83=1|5.26=5 | ||
341 | 5.83=1|5.26=5 | ||
342 | 6.04=1|4.87=50|4.39=100 | ||
343 | 6.04=1|4.87=50|4.39=100 | ||
344 | 5.31=1|4.77=5 | ||
345 | 5.31=1|4.77=5 | ||
346 | 4.23=1|3.8=50|3.33=100|2.92=150 | ||
347 | 4.23=1|3.8=50|3.33=100|2.92=150 | ||
348 | 4.23=1|3.8=50|3.33=100|2.92=150 | ||
349 | 3.09=1|2.78=5 | ||
350 | 3.09=1|2.78=5 | ||
351 | 3.09=1|2.78=5 | ||
352 | 5.6=1|5.03=20 | ||
353 | 5.6=1|5.03=20 | ||
354 | 15.53=1|13.99=10 | ||
355 | 0.78=1|0.71=100 | ||
356 | 0.98=1|0.86=100 | ||
357 | 1.11=1|1=100 | ||
358 | 1.11=1|1=100 | ||
359 | 0.98=1|0.86=100 | ||
360 | 1.16=1|1.03=100 | ||
361 | 1.28=1|1.17=100 | ||
362 | 0.98=1|0.86=100 | ||
363 | 1.16=1|1.03=100 | ||
364 | 21.58=1|19.41=20 | ||
365 | 21.58=1|19.41=20 | ||
366 | 21.58=1|19.41=20 | ||
367 | 21.58=1|19.41=20 | ||
368 | 21.58=1|19.41=20 | ||
369 | 21.58=1|19.41=20 | ||
370 | 7.75=1|6.97=5 | ||
371 | 7.35=1|6.62=5 | ||
372 | 7.35=1|6.62=5 | ||
373 | 186.19=1 | ||
374 | 214.32=1 | ||
375 | 234.9=1 | ||
376 | 254.36=1 | ||
377 | 273.85=1 | ||
378 | 314.98=1 | ||
379 | 353.97=1 | ||
380 | 16.23=1 | ||
381 | 46.54=1 | ||
382 | 110.4=1 | ||
383 | 120.15=1 | ||
384 | 180.76=1 | ||
385 | 20.19=1|18.17=6 | ||
386 | 316.73=1|291.39=3 | ||
387 | 61.17=1 | ||
388 | 85.08=1 | ||
389 | 107.76=1 | ||
390 | 135.04=1 | ||
391 | 153.34=1 | ||
392 | 173.27=1 | ||
393 | 189.87=1 | ||
394 | 238.72=1 | ||
395 | 258.51=1 | ||
396 | 286.94=1 | ||
397 | 323.09=1 | ||
398 | 340.26=1 | ||
399 | 410.52=1 | ||
400 | 495.21=1 | ||
401 | 526.01=1 | ||
402 | 36.19=1 | ||
403 | 149.48=1 | ||
404 | 122.61=1|110.24=6 | ||
405 | 51.15=1 | ||
406 | 211.22=1 | ||
407 | 422.43=1 | ||
408 | 41.1=1|37.81=5 | ||
409 | 24.83=1|22.2=5 | ||
410 | 5.17=1|4.64=12 | ||
411 | 66.38=1 | ||
412 | 117.9=1|98.25=3 | ||
413 | 183.39=1|157.19=3 | ||
414 | 117.9=1|98.26=3 | ||
415 | 183.39=1|157.19=9 | ||
416 | 654.34=1 | ||
417 | 294.08=1 | ||
418 | 7.3=12|6.53=24|5.59=60 | ||
419 | 21.14=1|19.01=6|16.93=48 | ||
420 | 10.09=1|8.77=6|7.74=12 | ||
421 | 14.85=1|12.92=6|12.39=12 | ||
422 | 7.84=1|7.2=10 | ||
423 | 5.24=20|5.03=200|4.84=1000 | ||
424 | 9.68=100|8.75=320|7.84=960 | ||
425 | 1.95=500|1.64=2000|1.42=6000 | ||
426 | 9.15=24|7.84=96|7.32=240 | ||
427 | 58.96=2|51.09=10|47.03=164 | ||
428 | 78.58=1|73.34=5|72.04=10 | ||
429 | 1.64=1|1.25=1000|1.17=3000|1.05=6000 | ||
430 | 286.44=1|276.42=5 | ||
431 | 9.15=24|7.84=48|6.53=96 | ||
432 | 78.58=1|73.34=5|72.04=10 | ||
433 | 15.39=1|14.61=10 | ||
434 | 78.58=1|73.34=5|72.04=10 | ||
435 | 78.58=1|73.34=5|72.04=10 | ||
436 | 238.03=1|226.13=5 | ||
437 | 168.98=1|152.09=5 | ||
438 | 144.08=1|137.52=5 | ||
439 | 370.61=1|357.65=5 | ||
440 | 15.71=10 | ||
441 | 15.71=10 | ||
442 | 155.89=1|142.78=5 | ||
443 | 10.8=1|9.1=12|8.06=24 | ||
444 | 6.22=12|5.24=24 | ||
445 | 13.43=50|13.09=100|12.45=250 | ||
446 | 13.43=50|13.09=100|12.45=250 | ||
447 | 13.43=50|13.09=100|12.45=250 | ||
448 | 332.75=1|313.09=3 | ||
449 | 332.75=1|313.09=3 | ||
450 | 5.85=1 | ||
451 | 4.84=1|4.15=25|3.45=100 | ||
452 | 4.84=1|4.15=25|3.45=100 | ||
453 | 4.84=1|4.15=25|3.45=100 | ||
454 | 4.84=1|4.15=25|3.45=100 | ||
455 | 4.84=1|4.15=25|3.45=100 | ||
456 | 4.84=1|4.15=25|3.45=100 | ||
457 | 4.84=1|4.15=25|3.45=100 | ||
458 | 4.84=1|4.15=25|3.45=100 | ||
459 | 4.84=1|4.15=25|3.45=100 | ||
460 | 4.84=1|4.15=25|3.45=100 | ||
461 | 4.84=1|4.15=25|3.45=100 | ||
462 | 4.84=1|4.15=25|3.45=100 | ||
463 | 20.15=1|17.47=50 | ||
464 | 24.01=1|20.15=40 | ||
465 | 220.29=0 | ||
466 | 23.02=0 | ||
467 | 41.74=0 | ||
468 | 27.35=0 | ||
469 | 21.59=0 | ||
470 | 8.68=1|7.6=12|6.71=24 | ||
471 | 7.73=1|7.27=12|6.71=24 | ||
472 | 485.97=1 | ||
473 | 902.21=1 | ||
474 | 232.47=1 | ||
475 | 15=1|12.41=12|11.75=24 | ||
476 | 9.99=75 | ||
477 | 12.87=1|12.31=12 | ||
478 | 3.24=1|0.75=1000|0.6=10000 | ||
479 | 35.79=85|32.79=170|31=255 | ||
480 | 152.73=1 | ||
481 | 173.23=1 | ||
482 | 408.98=1 | ||
483 | 562.73=1 | ||
484 | 179.38=1 | ||
485 | 1331.48=1 | ||
486 | 2.2=1000|2=2000 | ||
487 | 25=1 | ||
488 | 45=1 | ||
489 | 10.83=1|9.84=5|8.4=10 | ||
490 | 460.23=1|408.98=3|378.23=6 | ||
491 | 11=1|10.38=7|10.16=35|9.64=70 | ||
492 | 19.45=1|18.43=7|17.4=35|16.38=70 | ||
493 | 29.61=35 | ||
494 | 13.66=1|12.3=10|9.84=20 | ||
495 | 17.16=1|15.44=10 | ||
496 | 26.65=1|23.99=10 | ||
497 | 17.26=1|15.54=10|12.43=20 | ||
498 | 17.26=1|15.54=10|12.43=20 | ||
499 | 17.26=1|15.54=10|12.43=20 | ||
500 | 18.7=1|17.51=10|16.91=20 | ||
501 | 27.51=1|24.76=10 | ||
502 | 11.79=1|9.74=10|8.68=20 | ||
503 | 7.01=1|5.59=40 | ||
504 | 6.36=1|5.52=12|5.26=36 | ||
505 | 6.36=1|5.52=12|5.26=36 | ||
506 | 15.95=1|13.87=12|13.27=36 | ||
507 | 17.02=1|8.62=40|7.98=120 | ||
508 | 48.91=1|45.74=8|41.17=20|37.05=40 | ||
Wholesale |