Spreadsheet: 217295d1362038719-help-with-excel-sheet-to-get-output-sales-3-feb-9-feb-2013
Sheet: Sheet1

2/11/2013 @ 2:36 PM
Page: 1
SALES Report: [NAME]
[NAME]: Full Detail
Sort: Rcpt#|Document SID
Filter: Store: 001 (001) Include | Receipt Date: 2/3/2013@12:00a..2/9/2013@11:59p Include
Item detail: Associate|Desc2|Style #
Str | Rcpt# | Rcpt Date | Time | Cashier | Ext O P$ | Disc % | Ext D$ | Ext P$ | Rcpt Total | Tender | Sold #
1 | 2488 | 2013-02-03 00:00:00 | 12:38p | karima | 2156 | 0 | 0 | 2156 | 2587.2 | Cash | 1
 | karima | Blue | DP214
 | 2489 | 2013-02-03 00:00:00 | 1:22p | karima | 2156 | 69.99 | 1509 | 647 | 776.4 | CrCd | 1
 | karima | Orange | GP124
 | 2490 | 2013-02-03 00:00:00 | 2:12p | karima | 2156 | 69.99 | 1509 | 647 | 776.4 | Cash | 1
 | karima | Multicolour | [NAME]
 | 2491 | 2013-02-03 00:00:00 | 2:14p | karima | 2156 | 50 | 1078 | 1078 | 1293.6 | Cash | 1
 | karima | Red | DP244
 | 2492 | 2013-02-03 00:00:00 | 2:58p | karima | 2695 | 0 | 0 | 2695 | 3234 | CrCd | 1
 | karima | Black/Multi | [NAME]
 | 2493 | 2013-02-03 00:00:00 | 4:13p | karima | 4081 | 69.98 | 2856 | 1225 | 1470 | Cash | 2
 | karima | Black/Multi | [NAME]
 | karima | Multicolour | [NAME]
 | 2494 | 2013-02-03 00:00:00 | 4:36p | karima | 2464 | 70.01 | 1725 | 739 | 886.8 | Cash | 1
 | karima | Purple/Multi | DP180
 | 2495 | 2013-02-03 00:00:00 | 5:08p | karima | 1925 | 69.97 | 1347 | 578 | 693.6 | CrCd | 1
 | karima | [NAME] | DP116
 | 2496 | 2013-02-03 00:00:00 | 5:27p | karima | 1925 | 69.97 | 1347 | 578 | 693.6 | CrCd | 1
 | karima | [NAME] | DP116
 | 2497 | 2013-02-03 00:00:00 | 5:30p | karima | 3219 | 14.2 | 457 | 2762 | 3314.4 | CrCd | 2
 | karima | Black | KP148
 | karima | Ivory | TP187
 | 2498 | 2013-02-03 00:00:00 | 5:35p | karima | 12844 | 27.84 | 3576 | 9268 | 11121.6 | CrCd | 6
 | karima | Black | JP070
 | karima | Red | DP326
 | karima | Ivory | TP061
 | karima | Cream/Multi | HP040
 | karima | Pewter | DP158
 | karima | Black | PP100
 | 2499 | 2013-02-03 00:00:00 | 6:01p | karima | 1694 | 50 | 847 | 847 | 1016.4 | Cash | 1
 | karima | Pewter | SP094
 | 2500 | 2013-02-03 00:00:00 | 6:02p | karima | 616 | 69.97 | 431 | 185 | 222 | Cash | 1
 | karima | Teal | TP082
 | 2501 | 2013-02-03 00:00:00 | 7:46p | karima | 3850 | 38.81 | 1494 | 2356 | 2827.2 | CrCd | 3
 | karima | Blue/Multi | KP179
 | karima | Black | KP178
 | karima | Black/Multi | TP166
 | 2502 | 2013-02-03 00:00:00 | 9:03p | karima | 3850 | 30 | 1155 | 2695 | 3234 | Split | 1
 | karima | Black | JP009
 | 2503 | 2013-02-04 00:00:00 | 11:57a | karima | 1617 | 49.04 | 793 | 824 | 988.8 | CrCd | 2
 | karima | Ivory | TP093
 | karima | Black | TP204
 | 2504 | 2013-02-04 00:00:00 | 12:28p | karima | 616 | 69.97 | 431 | 185 | 222 | Cash | 1
 | karima | Teal | TP082
 | 2505 | 2013-02-04 00:00:00 | 12:52p | karima | 1694 | 70.01 | 1186 | 508 | 609.6 | Cash | 1
 | karima | Brown/Multi | PP004
 | 2506 | 2013-02-04 00:00:00 | 5:50p | karima | 1525 | 29.97 | 457 | 1068 | 1281.6 | CrCd | 1
 | karima | Purple/Multi | [NAME]
 | 2507 | 2013-02-04 00:00:00 | 5:52p | karima | 770 | 50 | 385 | 385 | 462 | CrCd | 1
 | karima | Cream/Multi | KP207
 | 2508 | 2013-02-04 00:00:00 | 5:59p | karima | 1309 | 69.98 | 916 | 393 | 471.6 | Cash | 1
 | karima | Yellow | SP036
 | 2509 | 2013-02-04 00:00:00 | 7:02p | karima | 2695 | 49.98 | 1347 | 1348 | 1617.6 | Cash | 1
 | karima | Teal | DP152
 | 2510 | 2013-02-04 00:00:00 | 7:57p | karima | 4851 | 11.89 | 577 | 4274 | 5128.8 | Cash | 2
 | karima | Black | PP079
 | karima | Black | JP070
 | 2511 | 2013-02-05 00:00:00 | 11:10a | karima | 4620 | 0 | 0 | 4620 | 5544 | CrCd | 2
 | karima | Blue | DP333
 | karima | Pink/Multi | DP159
 | 2512 | 2013-02-05 00:00:00 | 11:16a | karima | 1001 | 70.03 | 701 | 300 | 360 | Cash | 1
 | karima | Black & White | TP064
 | 2513 | 2013-02-05 00:00:00 | 11:55a | karima | -1525 | 49.97 | -762 | -763 | -915.6 | S/C | -1
 | karima | Black | [NAME]
 | 2514 | 2013-02-05 00:00:00 | 3:42p | karima | 2464 | 70.01 | 1725 | 739 | 886.8 | CrCd | 1
 | karima | Purple | DP229
 | 2515 | 2013-02-05 00:00:00 | 5:34p | karima | 3619 | 30.01 | 1086 | 2533 | 3039.6 | CrCd | 1
 | karima | Khaki | JP025
 | 2516 | 2013-02-05 00:00:00 | 6:10p | karima | 7007 | 54.83 | 3842 | 3165 | 3798 | Cash | 4
 | karima | [NAME] | GP032
 | karima | [NAME] | GP031
 | karima | Black & White | KP179
 | karima | Black | DP177
 | 2517 | 2013-02-05 00:00:00 | 6:14p | karima | 770 | 70 | 539 | 231 | 277.2 | Cash | 1
 | karima | Ivory | TP093
 | 2518 | 2013-02-05 00:00:00 | 7:06p | karima | 13090 | 57.64 | 7545 | 5545 | 6654 | Split | 3
 | karima | Black | [NAME]
 | karima | Pewter | DP158
 | karima | Black | FP038
 | 2519 | 2013-02-05 00:00:00 | 8:21p | karima | 6083 | 38.11 | 2318 | 3765 | 4518 | CrCd | 2
 | karima | Black & White | [NAME]
 | karima | Black | JP050
 | 2520 | 2013-02-06 00:00:00 | 12:05p | karima | 2926 | 50 | 1463 | 1463 | 1755.6 | Cash | 1
 | karima | Black | DP168
 | 2521 | 2013-02-06 00:00:00 | 1:01p | karima | 1694 | 70.01 | 1186 | 508 | 609.6 | Cash | 1
 | karima | Black & White | SP029
 | 2522 | 2013-02-06 00:00:00 | 1:55p | karima | 3850 | 0 | 0 | 3850 | 4620 | Cash | 1
 | karima | Black | DP308
 | 2523 | 2013-02-06 00:00:00 | 2:05p | karima | 5159 | 49.99 | 2579 | 2580 | 3096 | Cash | 2
 | karima | Red/Multi | DP123
 | karima | Cream/Multi | DP083
 | 2524 | 2013-02-06 00:00:00 | 3:03p | karima | 7454 | 6.13 | 457 | 6997 | 8396.4 | CrCd | 3
 | karima | Stone | KP238
 | karima | Black | PP057
 | karima | Neutral | CP036
 | 2525 | 2013-02-06 00:00:00 | 3:44p | karima | 4759 | 31.37 | 1493 | 3266 | 3919.2 | Cash | 3
 | karima | Black | PP084
 | karima | Teal | KP101
 | karima | [NAME] | KP232
 | 2526 | 2013-02-06 00:00:00 | 4:15p | karima | 5005 | 49.99 | 2502 | 2503 | 3003.6 | CrCd | 1
 | karima | Taupe | CP039
 | 2527 | 2013-02-06 00:00:00 | 8:36p | karima | 616 | 69.97 | 431 | 185 | 222 | Cash | 1
 | karima | Pale Blue | TP005
 | 2528 | 2013-02-07 00:00:00 | 11:00a | karima | 2695 | 49.98 | 1347 | 1348 | 1617.6 | CrCd | 1
 | karima | Orange | WP001
 | 2529 | 2013-02-07 00:00:00 | 12:23p | karima | 5005 | 49.99 | 2502 | 2503 | 3003.6 | Cash | 1
 | karima | Taupe | CP039
 | 2530 | 2013-02-07 00:00:00 | 12:53p | karima | 0 | 0 | 0 | 0 | 0 | Cash | 0
 | karima | Red/Multi | DP123
 | karima | Red/Multi | DP123
 | 2531 | 2013-02-07 00:00:00 | 1:17p | karima | 3003 | 58.71 | 1763 | 1240 | 1488 | CrCd | 2
 | karima | Pewter | SP094
 | karima | Pewter | HP041
 | 2532 | 2013-02-07 00:00:00 | 1:34p | karima | 1155 | 69.96 | 808 | 347 | 416.4 | Cash | 1
 | karima | Pale Blue | PP088
 | 2533 | 2013-02-07 00:00:00 | 2:10p | karima | 1309 | 49.96 | 654 | 655 | 786 | CrCd | 1
 | karima | Silver | FP168
 | 2534 | 2013-02-07 00:00:00 | 3:31p | karima | 4312 | 38.91 | 1678 | 2634 | 3160.8 | Cash | 2
 | karima | Black/Multi | FP185
 | karima | Black | FP107
 | 2535 | 2013-02-07 00:00:00 | 6:22p | karima | 2464 | 70.01 | 1725 | 739 | 886.8 | Cash | 1
 | karima | Purple/Multi | DP180
 | 2536 | 2013-02-07 00:00:00 | 6:53p | karima | 5082 | 50 | 2541 | 2541 | 3049.2 | CrCd | 2
 | karima | Blue | [NAME]
 | karima | Champagne | DP228
 | 2537 | 2013-02-07 00:00:00 | 6:56p | karima | 3619 | 49.99 | 1809 | 1810 | 2172 | Cash | 1
 | karima | Red/Multi | DP058
 | 2538 | 2013-02-08 00:00:00 | 1:45p | karima | 5390 | 0 | 0 | 5390 | 4527.6 | CrCd | 1
 | karima | Khaki | CP035
 | 2539 | 2013-02-08 00:00:00 | 2:28p | karima | 770 | 70 | 539 | 231 | 277.2 | Cash | 1
 | karima | Ivory | TP093
 | 2540 | 2013-02-08 00:00:00 | 2:30p | karima | 1155 | 69.96 | 808 | 347 | 416.4 | Cash | 1
 | karima | Pale Blue | PP088
 | 2541 | 2013-02-08 00:00:00 | 3:30p | karima | 2849 | 49.98 | 1424 | 1425 | 1710 | CrCd | 1
 | karima | Orange | GP214
 | 2542 | 2013-02-08 00:00:00 | 3:50p | karima | 3619 | 49.99 | 1809 | 1810 | 2172 | Cash | 1
 | karima | Orange | CP032
 | 2543 | 2013-02-08 00:00:00 | 4:00p | karima | 5159 | 49.99 | 2579 | 2580 | 3096 | CrCd | 2
 | karima | Black & White | [NAME]
 | karima | Black & White | DP213
 | 2544 | 2013-02-08 00:00:00 | 6:33p | karima | 1309 | 49.96 | 654 | 655 | 786 | Cash | 1
 | karima | Cream/Multi | HP040
 | 2545 | 2013-02-08 00:00:00 | 7:26p | karima | 5144 | 55.02 | 2830 | 2314 | 2776.8 | CrCd | 3
 | karima | Black | KP161
 | karima | Black & White | SP061
 | karima | Black & White | HP046
 | 2546 | 2013-02-08 00:00:00 | 8:25p | karima | 2926 | 30.01 | 878 | 2048 | 2457.6 | CrCd | 1
 | karima | Black/Multi | JP017
 | 2547 | 2013-02-09 00:00:00 | 12:06p | karima | 2849 | 49.98 | 1424 | 1425 | 1710 | Cash | 1
 | karima | Neutral | [NAME]
 | 2548 | 2013-02-09 00:00:00 | 12:14p | karima | 5005 | 49.99 | 2502 | 2503 | 3003.6 | Cash | 1
 | karima | Taupe | CP039
 | 2549 | 2013-02-09 00:00:00 | 12:38p | karima | 1525 | 49.97 | 762 | 763 | 915.6 | Cash | 1
 | karima | Black/Multi | HP018
 | 2550 | 2013-02-09 00:00:00 | 1:15p | karima | 1309 | 30.02 | 393 | 916 | 1099.2 | CrCd | 1
 | karima | Black/Multi | KP199
 | 2551 | 2013-02-09 00:00:00 | 4:59p | karima | 1309 | 49.96 | 654 | 655 | 786 | CrCd | 1
 | karima | Stone | KP061
 | 2552 | 2013-02-09 00:00:00 | 5:03p | karima | 1925 | 69.97 | 1347 | 578 | 693.6 | CrCd | 1
 | karima | Black/Multi | [NAME]
 | 2553 | 2013-02-09 00:00:00 | 5:35p | karima | 1525 | 49.97 | 762 | 763 | 915.6 | Cash | 1
 | karima | Red/Multi | [NAME]
 | 2554 | 2013-02-09 00:00:00 | 9:05p | karima | 5159 | 0 | 0 | 5159 | 6190.8 | Cash | 2
 | karima | Red | DP156
 | karima | Black/Multi | KP255
 | 2555 | 2013-02-09 00:00:00 | 9:18p | karima | 3773 | 49.99 | 1886 | 1887 | 2264.4 | Cash | 2
 | karima | Black & White | [NAME]
 | karima | Black/Multi | [NAME]
 |  |  |  |  | 212800 | 41.64 | 88606 | 124194 | 147092.4 |  | 96