Glitched Company Sales Log
April: Glitched Company Sales Log
ClaimedCorporate has discovered a glitch in the sales logging system: any time a customer cancels an order, the system incorrectly records 404 units sold for the responsible sales representative.
To address this issue, the CEO has offered a Discord Nitro link to anyone on the IT team who can provide a comma-separated list of employees, sorted from highest to lowest total units sold for the month, excluding any sales entries where the number of units sold is exactly 404.
Your task is to process the sales data, correctly calculate the total units sold by each employee (ignoring all 404-unit entries), and return a list of their names in descending order of total sales.
Example 1:
John sold 100 units Jane sold 200 units John sold 150 units Jill sold 404 units Jill sold 100 units
In this example, Johns total was 250 units, Jane was 200 units and Jill was only 100 units. Jill's log with 404 units is ingored.
Puzzle input
Bob sold 562 unitsGary sold 6 unitsBob sold 736 unitsCarl sold 404 unitsGary sold 832 unitsHelen sold 750 unitsBob sold 336 unitsCarl sold 584 unitsAlice sold 404 unitsHelen sold 599 unitsHelen sold 194 unitsEthan sold 264 unitsBob sold 461 unitsDanny sold 404 unitsBob sold 102 unitsFred sold 803 unitsEthan sold 404 unitsHelen sold 296 unitsCarl sold 827 unitsEthan sold 111 unitsHelen sold 298 unitsBob sold 707 unitsEthan sold 153 unitsDanny sold 370 unitsCarl sold 404 unitsEthan sold 659 unitsFred sold 564 unitsGary sold 647 unitsHelen sold 717 unitsHelen sold 819 unitsHelen sold 334 unitsGary sold 427 unitsHelen sold 461 unitsFred sold 93 unitsGary sold 863 unitsDanny sold 156 unitsHelen sold 316 unitsHelen sold 437 unitsBob sold 640 unitsAlice sold 914 unitsBob sold 229 unitsCarl sold 325 unitsGary sold 516 unitsGary sold 842 unitsGary sold 404 unitsAlice sold 731 unitsCarl sold 274 unitsCarl sold 404 unitsDanny sold 357 unitsEthan sold 57 unitsAlice sold 228 unitsFred sold 404 unitsGary sold 371 unitsGary sold 62 unitsFred sold 330 unitsFred sold 391 unitsEthan sold 36 unitsEthan sold 877 unitsAlice sold 404 unitsBob sold 828 unitsBob sold 944 unitsFred sold 887 unitsCarl sold 175 unitsHelen sold 622 unitsAlice sold 661 unitsBob sold 568 unitsDanny sold 647 unitsAlice sold 593 unitsEthan sold 102 unitsAlice sold 607 unitsFred sold 552 unitsDanny sold 518 unitsDanny sold 292 unitsFred sold 399 unitsGary sold 888 unitsDanny sold 469 unitsHelen sold 219 unitsGary sold 232 unitsCarl sold 267 unitsFred sold 776 unitsEthan sold 667 unitsDanny sold 666 unitsBob sold 404 unitsDanny sold 332 unitsDanny sold 282 unitsDanny sold 917 unitsCarl sold 899 unitsCarl sold 202 unitsEthan sold 241 unitsDanny sold 922 unitsAlice sold 777 unitsCarl sold 917 unitsHelen sold 108 unitsBob sold 229 unitsBob sold 88 unitsBob sold 273 unitsHelen sold 599 unitsHelen sold 24 unitsAlice sold 423 unitsGary sold 482 unitsCarl sold 398 unitsAlice sold 58 unitsDanny sold 404 unitsCarl sold 811 unitsEthan sold 904 unitsAlice sold 993 unitsHelen sold 268 unitsHelen sold 107 unitsDanny sold 495 unitsGary sold 909 unitsBob sold 628 unitsFred sold 844 unitsCarl sold 399 unitsFred sold 662 unitsHelen sold 805 unitsDanny sold 867 unitsHelen sold 48 unitsFred sold 678 unitsHelen sold 603 unitsFred sold 703 unitsBob sold 454 unitsBob sold 483 unitsHelen sold 588 unitsAlice sold 109 unitsAlice sold 927 unitsCarl sold 404 unitsCarl sold 404 unitsAlice sold 404 unitsCarl sold 989 unitsAlice sold 700 unitsFred sold 404 unitsAlice sold 636 unitsDanny sold 440 unitsAlice sold 852 unitsCarl sold 997 unitsBob sold 404 unitsAlice sold 438 unitsCarl sold 268 unitsEthan sold 788 unitsAlice sold 13 unitsDanny sold 40 unitsEthan sold 619 unitsEthan sold 38 unitsHelen sold 162 unitsFred sold 982 unitsDanny sold 439 unitsCarl sold 894 unitsGary sold 110 unitsFred sold 372 unitsHelen sold 786 unitsFred sold 971 unitsBob sold 439 unitsDanny sold 119 unitsHelen sold 117 unitsBob sold 27 unitsDanny sold 963 unitsAlice sold 978 unitsEthan sold 404 unitsEthan sold 323 unitsFred sold 732 unitsFred sold 860 unitsEthan sold 186 unitsFred sold 735 unitsEthan sold 726 unitsFred sold 232 unitsAlice sold 918 unitsFred sold 670 unitsHelen sold 229 unitsEthan sold 67 unitsBob sold 101 unitsHelen sold 741 unitsCarl sold 495 unitsDanny sold 360 unitsFred sold 850 unitsAlice sold 196 unitsDanny sold 930 unitsDanny sold 103 unitsCarl sold 278 unitsAlice sold 533 unitsGary sold 620 unitsGary sold 404 unitsBob sold 144 unitsHelen sold 287 unitsCarl sold 53 unitsBob sold 820 unitsFred sold 571 unitsFred sold 802 unitsDanny sold 603 unitsDanny sold 404 unitsDanny sold 631 unitsFred sold 615 unitsHelen sold 834 unitsFred sold 816 unitsDanny sold 880 unitsCarl sold 862 unitsHelen sold 980 unitsHelen sold 448 unitsGary sold 404 unitsEthan sold 740 unitsEthan sold 145 unitsGary sold 972 unitsCarl sold 127 unitsFred sold 818 unitsCarl sold 999 unitsGary sold 308 unitsEthan sold 947 unitsDanny sold 896 unitsFred sold 750 unitsGary sold 625 unitsFred sold 926 unitsHelen sold 432 unitsFred sold 495 unitsFred sold 750 unitsFred sold 657 unitsCarl sold 936 unitsDanny sold 936 unitsBob sold 589 unitsCarl sold 532 unitsEthan sold 488 unitsFred sold 122 unitsCarl sold 229 unitsCarl sold 456 unitsCarl sold 243 unitsAlice sold 894 unitsDanny sold 636 unitsDanny sold 288 unitsCarl sold 13 unitsFred sold 975 unitsCarl sold 929 unitsEthan sold 676 unitsEthan sold 404 unitsHelen sold 976 unitsEthan sold 697 unitsHelen sold 461 unitsGary sold 786 unitsCarl sold 442 unitsFred sold 743 unitsEthan sold 933 unitsFred sold 798 unitsAlice sold 455 unitsBob sold 207 unitsBob sold 188 unitsEthan sold 779 unitsGary sold 47 unitsGary sold 508 unitsAlice sold 599 unitsDanny sold 9 unitsBob sold 745 unitsFred sold 397 unitsHelen sold 276 unitsDanny sold 704 unitsEthan sold 692 unitsBob sold 515 unitsDanny sold 133 unitsGary sold 613 unitsEthan sold 948 unitsEthan sold 765 unitsGary sold 420 unitsBob sold 96 unitsGary sold 30 unitsFred sold 419 unitsGary sold 787 unitsDanny sold 621 unitsEthan sold 404 unitsFred sold 410 unitsGary sold 502 unitsAlice sold 487 unitsHelen sold 861 unitsAlice sold 517 unitsFred sold 350 unitsGary sold 404 unitsEthan sold 286 unitsCarl sold 899 unitsCarl sold 639 unitsBob sold 965 unitsDanny sold 203 unitsGary sold 404 unitsEthan sold 858 unitsBob sold 790 unitsEthan sold 745 unitsDanny sold 662 unitsCarl sold 556 unitsBob sold 511 unitsBob sold 751 unitsAlice sold 876 unitsAlice sold 790 unitsHelen sold 616 unitsGary sold 712 unitsAlice sold 248 unitsAlice sold 822 unitsDanny sold 871 unitsHelen sold 883 unitsCarl sold 12 unitsAlice sold 616 unitsCarl sold 37 unitsDanny sold 404 unitsDanny sold 332 unitsCarl sold 202 unitsCarl sold 265 unitsGary sold 243 units