Fluent Essays

Need help solving for the excel functions. The instruction is listed on the datasheet inside excel. DAA1 Instructions Data Analytics Assignment 1 Instructions DUE DATE: Wednesday, September 15th at 11:59PM NOTE: This is an individual-based assessment, which means you must work on this and submit a version on your own before the deadline. Complete the steps necessary in Excel to answer all of the questions on the DAA1 Questions worksheet using the data from DAA1 Data worksheet. Please make sure to input answers (preferably the formulas themselves or a cell reference to those formulas) in all yellow cells on the DAA1 Questions worksheet. Save your Excel file with the name "Last Name.First Name - ACCT 307 - DAA 1". Submit your final version on Canvas before the deadline. Double check that you have named the file properly and followed all steps to the best of your ability. If you have questions before completion, please do not hesitate to let me know! DAA1 Questions Data Analytics Assignment 1 QUESTIONS: ANSWERS: NOTES: 1) Use a DATE/TIME function to generate the current date and time in cell B3. 9/5/21 Please enter your formula or cell reference in the yellow cell. Ctrl+;, & Ctrl + Shift +; 2) Sort the data by Product [from PROD-001 to PROD-200] and then by Date [from oldest to newest]. Note that the dataset should be sorted by both Product and Date at the same time. Complete the steps as requested. 3) Use a statistical formula to find the second largest sale. 1074000 Please enter your formula or cell reference in the yellow cell. 4) Use one of statistical formula to find the total number of transactions where PROD-053 was sold. Please enter your formula or cell reference in the yellow cell. 5) Use SUMIFS to find and calculate the following. All number formatting should be in Currency. 5a) Find sales of CUST-146 only. Please enter your formula or cell reference in the yellow cell. 5b) Find sales of PROD-070 during Quarter 1 (January, February, March) only. 6) Use Pivot Tables to calculate the following. All number formatting should be in Accounting. Please enter your formulas/answers in the yellow cells and leave your Pivot Table work for verification. 6a) Find sales of MSA-63 only. 6b) Find sales of SP-08 during Quarter 4 (October, November, December) only. 6c) Find sales of PROD-166 to CUST-041 only. Then divide by sales of all transactions. Your final answer should be expressed as a percentage. 7) Use Pivot Tables and Pivot Charts to create charts for the following. Charts should be meaningful and easy to understand. Complete the steps as requested. 7a) Create a Pivot Chart that displays sales of each size. 7b) Create a Pivot Chart that displays sales of each material and each salesperson (at the same time). 7c) Create a Pivot Chart that displays sales of each material and each salesperson over time (at the same time). 8) Using as many columns as you would like, calculate Commissions. In order to calculate it, you must first find Collections divided by Sales as a percentage for each transaction. There are three different calculations for Commissions depending on the Collections divided by Sales result. If Collection divided by Sales is greater than or equal to 75%, Commissions is 2% x Sales. If Collection divided by Sales is greater than or equal to 50% but less than 75%, Commissions is 1% x Sales. For all other transactions, Commissions is $0. You should consider logical formulas to help you solve this question. Complete the steps as requested. 9) Set up the following spreadsheet security options: Complete the steps as requested. 9a) Protect the DAA1 Data worksheet with the option to allow users to only select locked and unlocked cells. Please use the password "acct307". 9b) Protect your file so that a password must be entered to open and view the file. Please use the password "acct307". DAA1 Data Date Salesperson Customer Product Material Size Warehouse # Units Sales COGS Collections 1/1/19 SP-20 CUST-035 PROD-005 MATL-Citrine SIZE-S MSA-13 100 524020 373708 524020 1/1/19 SP-17 CUST-021 PROD-008 MATL-Aquamarine SIZE-S MSA-42 82 415680 286510 415680 1/1/19 SP-05 CUST-130 PROD-009 MATL-Emerald SIZE-S MSA-61 88 456541 254174 228269 1/1/19 SP-08 CUST-019 PROD-012 MATL-Moonstone SIZE-L MSA-06 89 21720 9222 21720 1/1/19 SP-08 CUST-076 PROD-016 MATL-Copper SIZE-L MSA-16 3 35134 24258 35134 1/1/19 SP-21 CUST-085 PROD-023 MATL-Jasper SIZE-S MSA-74 48 53816 35859 53816 1/1/19 SP-02 CUST-146 PROD-053 MATL-Silver SIZE-XS MSA-31 79 870232 519937 870232 1/1/19 SP-19 CUST-048 PROD-053 MATL-Silver SIZE-M MSA-35 85 352612 241911 352612 1/1/19 SP-12 CUST-053 PROD-059 MATL-Amethyst SIZE-S MSA-39 64 5568 1806 5568 1/1/19 SP-17 CUST-072 PROD-065 MATL-Moonstone SIZE-XL MSA-01 80 399050 248241 399050 1/1/19 SP-05 CUST-051 PROD-072 MATL-Garnet SIZE-XS MSA-42 52 387309 298717 387309 1/1/19 SP-12 CUST-123 PROD-073 MATL-Tanzanite SIZE-S MSA-32 30 911271 704058 911271 1/1/19 SP-07 CUST-012 PROD-076 MATL-Ruby SIZE-XL MSA-02 46 3204 1643 3204 1/1/19 SP-04 CUST-145 PROD-086 MATL-Silver SIZE-S MSA-57 22 711134 452503 711134 1/1/19 SP-09 CUST-037 PROD-087 MATL-Quartz SIZE-S MSA-11 86 166804 121723 166804 1/1/19 SP-01 CUST-060 PROD-090 MATL-Silver SIZE-S MSA-10 76 431104 278177 431104 1/1/19 SP-15 CUST-128 PROD-093 MATL-Opal SIZE-XS MSA-49 53 287850 120680 287850 1/1/19 SP-16 CUST-145 PROD-097 MATL-Opal SIZE-XL MSA-62 71 141082 63237 141082 1/1/19 SP-13 CUST-078 PROD-103 MATL-Citrine SIZE-L MSA-44 46 91372 44960 91372 1/1/19 SP-11 CUST-143 PROD-111 MATL-Quartz SIZE-M MSA-32 22 762734 607032 762734 1/1/19 SP-05 CUST-133 PROD-116 MATL-Opal SIZE-L MSA-18 12 242465 99286 242465 1/1/19 SP-16 CUST-026 PROD-138 MATL-Jasper SIZE-L MSA-20 44 305712 169770 305712 1/1/19 SP-04 CUST-146 PROD-144 MATL-Sapphire SIZE-XS MSA-36 8 225254 143700 225254 1/1/19 SP-19 CUST-001 PROD-145 MATL-Emerald SIZE-XS MSA-35 92 151280 70374 151280 1/1/19 SP-01 CUST-121 PROD-146 MATL-Bronze SIZE-XL MSA-03 40 501840 277006 501840 1/1/19 SP-02 CUST-083 PROD-148 MATL-Bronze SIZE-S MSA-70 15 238556 139282 238556 1/1/19 SP-15 CUST-007 PROD-158 MATL-Ruby SIZE-XS MSA-08 98 560300 443720 560300 1/1/19 SP-07 CUST-122 PROD-165 MATL-Emerald SIZE-M MSA-02 39 477216 294475 477216 1/1/19 SP-21 CUST-110 PROD-194 MATL-Garnet SIZE-M MSA-38 96 899040 560683 899040 1/2/19 SP-23 CUST-140 PROD-009 MATL-Sapphire SIZE-XL MSA-07 54 235996 131543 235996 1/2/19 SP-23 CUST-075 PROD-011 MATL-Copper SIZE-S MSA-65 20 231570 134532 231570 1/2/19 SP-18 CUST-122 PROD-016 MATL-Ruby SIZE-M MSA-44 70 739530 376253 739530 1/2/19 SP-15 CUST-015 PROD-018 MATL-Topaz SIZE-XS MSA-58 39 416583 241677 416583 1/2/19 SP-14 CUST-087 PROD-021 MATL-Silver SIZE-XL MSA-50 42 442560 196738 442560 1/2/19 SP-16 CUST-035 PROD-037 MATL-Silver SIZE-XL MSA-39 58 132658 90175 132658 1/2/19 SP-15 CUST-125 PROD-038 MATL-Topaz SIZE-XS MSA-47 90 305340 221390 305340 1/2/19 SP-20 CUST-076 PROD-040 MATL-Topaz SIZE-XL MSA-10 22 130093 89266 130093 1/2/19 SP-18 CUST-140 PROD-041 MATL-Garnet SIZE-S MSA-18 89 368806 200452 368806 1/2/19 SP-12 CUST-119 PROD-045 MATL-Sapphire SIZE-XL MSA-45 78 19035 7539 19035 1/2/19 SP-01 CUST-076 PROD-053 MATL-Amethyst SIZE-XS MSA-34 41 9864 6307 9864 1/2/19 SP-08 CUST-073 PROD-053 MATL-Copper SIZE-L MSA-34 61 664794 448055 664794 1/2/19 SP-06 CUST-072 PROD-056 MATL-Opal SIZE-M MSA-31 96 517089 354520 517089 1/2/19 SP-17 CUST-087 PROD-066 MATL-Ruby SIZE-XS MSA-05 96 51624 28188 51624 1/2/19 SP-07 CUST-026 PROD-070 MATL-Jasper SIZE-XL MSA-17 30 234612 136291 234612 1/2/19 SP-21 CUST-084 PROD-070 MATL-Moonstone SIZE-XS MSA-65 52 41664 22955 41664 1/2/19 SP-06 CUST-137 PROD-077 MATL-Jade SIZE-M MSA-25 19 337428 228364 0 1/2/19 SP-07 CUST-020 PROD-077 MATL-Opal SIZE-XS MSA-42 19 26190 15301 26190 1/2/19 SP-17 CUST-045 PROD-077 MATL-Copper SIZE-S MSA-75 8 10578 5695 10578 1/2/19 SP-13 CUST-089 PROD-082 MATL-Garnet SIZE-S MSA-48 9 188895 79205 188895 1/2/19 SP-21 CUST-111 PROD-096 MATL-Quartz SIZE-S MSA-32 34 464986 259465 464986 1/2/19 SP-20 CUST-123 PROD-097 MATL-Aquamarine SIZE-M MSA-09 89 501216 254756 501216 1/2/19 SP-14 CUST-119 PROD-102 MATL-Sapphire SIZE-XL MSA-49 7 55216 37778 55216 1/2/19 SP-05 CUST-026 PROD-113 MATL-Moonstone SIZE-M MSA-20 81 63490 36089 63490 1/2/19 SP-12 CUST-146 PROD-119 MATL-Emerald SIZE-L MSA-45 51 827433 420353 827433 1/2/19 SP-20 CUST-021 PROD-122 MATL-Jade SIZE-L MSA-56 18 113004 65645 113004 1/2/19 SP-02 CUST-114 PROD-142 MATL-Amethyst SIZE-XS MSA-06 81 215336 136450 215336 1/2/19 SP-15 CUST-069 PROD-145 MATL-Citrine SIZE-XL MSA-65 3 231044 93346 231044 1/2/19 SP-19 CUST-097 PROD-145 MATL-Emerald SIZE-S MSA-19 43 124740 66888 124740 1/2/19 SP-21 CUST-006 PROD-145 MATL-Quartz SIZE-XS MSA-14 49 479908 363196 479908 1/2/19 SP-01 CUST-150 PROD-151 MATL-Amethyst SIZE-L MSA-43 93 180608 100362 0 1/2/19 SP-09 CUST-104 PROD-174 MATL-Gold SIZE-XS MSA-46 18 126175 73571 126175 1/2/19 SP-15 CUST-014 PROD-181 MATL-Emerald SIZE-XS MSA-49 49 583632 339729 583632 1/2/19 SP-08 CUST-118 PROD-190 MATL-Peridot SIZE-M MSA-66 47 68140 46215 68140 1/3/19 SP-21 CUST-086 PROD-004 MATL-Amethyst SIZE-M MSA-03 26 9858 6871 9858 1/3/19 SP-05 CUST-090 PROD-007 MATL-Quartz SIZE-M MSA-16 83 190575 101195 190575 1/3/19 SP-21 CUST-037 PROD-011 MATL-Silver SIZE-XL MSA-35 7 918946 689773 918946 1/3/19 SP-14 CUST-098 PROD-012 MATL-Sapphire SIZE-XS MSA-73 3 490336 310573 490336 1/3/19 SP-20 CUST-149 PROD-012 MATL-Emerald SIZE-S MSA-60 9 60736 28475 60736 1/3/19 SP-14 CUST-004 PROD-014 MATL-Moonstone SIZE-XS MSA-75 34 59618 43051 59618 1/3/19 SP-08 CUST-038 PROD-021 MATL-Garnet SIZE-M MSA-19 13 361512 207763 361512 1/3/19 SP-10 CUST-110 PROD-023 MATL-Gold SIZE-XS MSA-58 24 550935 348767 550935 1/3/19 SP-08 CUST-110 PROD-024 MATL-Moonstone SIZE-M MSA-52 99 164921 103619 164921 1/3/19 SP-12 CUST-142 PROD-029 MATL-Peridot SIZE-XL MSA-15 3 117162 82454 117162 1/3/19 SP-04 CUST-066 PROD-044 MATL-Quartz SIZE-L MSA-58 52 315886 159050 315886 1/3/19 SP-11 CUST-004 PROD-044 MATL-Garnet SIZE-L MSA-11 88 156650 83840 156650 1/3/19 SP-10 CUST-108 PROD-046 MATL-Bronze SIZE-XL MSA-37 62 115520 68744 115520 1/3/19 SP-15 CUST-057 PROD-047 MATL-Ruby SIZE-XL MSA-41 60 784944 414195 784944 1/3/19 SP-07 CUST-037 PROD-052 MATL-Opal SIZE-M MSA-38 21 106092 50276 106092 1/3/19 SP-15 CUST-142 PROD-054 MATL-Peridot SIZE-XS MSA-17 48 61581 37433 61581 1/3/19 SP-11 CUST-004 PROD-063 MATL-Brass SIZE-L MSA-69 28 497475 202331 497475 1/3/19 SP-06 CUST-048 PROD-066 MATL-Bronze SIZE-M MSA-08 59 15360 10360 15360 1/3/19 SP-02 CUST-083 PROD-070 MATL-Bronze SIZE-M MSA-27 98 622500 466428 622500 1/3/19 SP-04 CUST-064 PROD-071 MATL-Jasper SIZE-S MSA-33 26 64080 29057 64080 1/3/19 SP-09 CUST-092 PROD-071 MATL-Brass SIZE-L MSA-10 6 238968 147478 238968 1/3/19 SP-17 CUST-010 PROD-071 MATL-Jade SIZE-XL MSA-59 75 586768 360871 586768 1/3/19 SP-22 CUST-109 PROD-071 MATL-Gold SIZE-XL MSA-47 98 104104 48840 104104 1/3/19 SP-21 CUST-148 PROD-081 MATL-Bronze SIZE-L MSA-08 66 266000 171684 266000 1/3/19 SP-06 CUST-075 PROD-096 MATL-Silver SIZE-XL MSA-29 25 388720 180627 388720 1/3/19 SP-04 CUST-059 PROD-102 MATL-Opal SIZE-S MSA-08 72 31083 13583 31083 1/3/19 SP-09 CUST-067 PROD-106 MATL-Amethyst SIZE-L MSA-46 75 134872 67511 134872 1/3/19 SP-06 CUST-042 PROD-109 MATL-Silver SIZE-M MSA-36 64 251785 139720 251785 1/3/19 SP-17 CUST-126 PROD-110 MATL-Ruby SIZE-M MSA-55 54 29928 23539 29928 1/3/19 SP-01 CUST-092 PROD-119 MATL-Topaz SIZE-XS MSA-38 1 256802 196712 256802 1/3/19 SP-01 CUST-031 PROD-122 MATL-Silver SIZE-XL MSA-62 25 465420 292027 465420 1/3/19 SP-02 CUST-058 PROD-132 MATL-Ruby SIZE-M MSA-62 56 406656 307590 406656 1/3/19 SP-04 CUST-052 PROD-132 MATL-Peridot SIZE-M MSA-70 63 523069 333227 523069 1/3/19 SP-17 CUST-149 PROD-133 MATL-Silver SIZE-S MSA-44 65 129616 80970 129616 1/3/19 SP-15 CUST-068 PROD-140 MATL-Opal SIZE-XS MSA-11 67 241500 153356 241500 1/3/19 SP-15 CUST-114 PROD-140 MATL-Ruby SIZE-L MSA-43 16 271836 165633 271836 1/3/19 SP-18 CUST-057 PROD-142 MATL-Quartz SIZE-S MSA-47 21 586690 465588 586690 1/3/19 SP-18 CUST-092 PROD-145 MATL-Quartz SIZE-XL MSA-75 60 192129 97605 192129 1/3/19 SP-11 CUST-063 PROD-154 MATL-Tanzanite SIZE-M MSA-47 80 211500 113817 211500 1/3/19 SP-13 CUST-108 PROD-167 MATL-Jade SIZE-L MSA-41 37 603345 353846 603345 1/3/19 SP-06 CUST-034 PROD-169 MATL-Silver SIZE-XL MSA-65 72 340861 176552 340861 1/3/19 SP-05 CUST-035 PROD-170 MATL-Gold SIZE-L MSA-63 18 90063 70731 90063 1/3/19 SP-12 CUST-116 PROD-174 MATL-Sapphire SIZE-XL MSA-11 92 39380 22474 39380 1/3/19 SP-18 CUST-004 PROD-191 MATL-Quartz SIZE-L MSA-33 73 138606 72487 138606 1/3/19 SP-21 CUST-078 PROD-192 MATL-Garnet SIZE-XS MSA-46 34 30345 18896 30345 1/3/19 SP-20 CUST-117 PROD-196 MATL-Amethyst SIZE-XS MSA-01 44 325710 248197 325710 1/3/19 SP-18 CUST-014 PROD-199 MATL-Brass SIZE-XS MSA-53 43 273292 130806 273292 1/3/19 SP-09 CUST-033 PROD-200 MATL-Citrine SIZE-XL MSA-49 24 319284 202008 319284 1/4/19 SP-11 CUST-115 PROD-008 MATL-Silver SIZE-S MSA-33 8 526568 393392 526568 1/4/19 SP-11 CUST-075 PROD-012 MATL-Emerald SIZE-L MSA-26 45 759825 400045 759825 1/4/19 SP-05 CUST-048 PROD-029 MATL-Aquamarine SIZE-S MSA-28 56 321650 199936 321650 1/4/19 SP-17 CUST-080 PROD-037 MATL-Moonstone SIZE-S MSA-02 39 58818 33963 58818 1/4/19 SP-13 CUST-114 PROD-046 MATL-Tanzanite SIZE-XL MSA-29 7 529144 232228 223755 1/4/19 SP-11 CUST-021 PROD-052 MATL-Topaz SIZE-XS MSA-37 79 26880 13174 26880 1/4/19 SP-07 CUST-046 PROD-056 MATL-Moonstone SIZE-XS MSA-09 89 594965 325380 594965 1/4/19 SP-03 CUST-069 PROD-067 MATL-Gold SIZE-XL MSA-53 75 584868 451929 584868 1/4/19 SP-04 CUST-003 PROD-089 MATL-Sapphire SIZE-L MSA-32 70 129888 77117 129888 1/4/19 SP-04 CUST-047 PROD-091 MATL-Jasper SIZE-S MSA-13 6 4275 1769 4275 1/4/19 SP-05 CUST-113 PROD-093 MATL-Silver SIZE-S MSA-35 15 399076 178752 399076 1/4/19 SP-02 CUST-080 PROD-098 MATL-Quartz SIZE-XS MSA-72 56 328887 230015 328887 1/4/19 SP-07 CUST-057 PROD-111 MATL-Brass SIZE-XL MSA-45 39 176256 121113 176256 1/4/19 SP-06 CUST-016 PROD-116 MATL-Aquamarine SIZE-S MSA-23 19 96435 61371 96435 1/4/19 SP-05 CUST-127 PROD-122 MATL-Amethyst SIZE-S MSA-72 89 859392 496799 859392 1/4/19 SP-07 CUST-116 PROD-134 MATL-Quartz SIZE-L MSA-06 27 22192 14122 22192 1/4/19 SP-12 CUST-117 PROD-152 MATL-Aquamarine SIZE-S MSA-73 25 461340 356442 461340 1/4/19 SP-05 CUST-067 PROD-166 MATL-Moonstone SIZE-S MSA-65 94 390102 186264 390102 1/4/19 SP-10 CUST-022 PROD-172 MATL-Citrine SIZE-XL MSA-72 9 167025 81443 167025 1/4/19 SP-23 CUST-102 PROD-176 MATL-Bronze SIZE-S MSA-09 76 66108 40680 66108 1/4/19 SP-21 CUST-091 PROD-184 MATL-Citrine SIZE-XS MSA-27 30 275652 158888 0 1/4/19 SP-21 CUST-108 PROD-184 MATL-Copper SIZE-XL MSA-22 98 150297 78370 150297 1/4/19 SP-05 CUST-100 PROD-191 MATL-Tanzanite SIZE-M MSA-15 16 144570 103340 144570 1/4/19 SP-10 CUST-138 PROD-191 MATL-Topaz SIZE-XL MSA-17 96 567812 377492 567812 1/4/19 SP-18 CUST-008 PROD-195 MATL-Jade SIZE-XL MSA-24 21 753616 427657 753616 1/5/19 SP-05 CUST-134 PROD-007 MATL-Moonstone SIZE-S MSA-63 94 87084 65605 87084 1/5/19 SP-13 CUST-053 PROD-007 MATL-Tanzanite SIZE-M MSA-39 76 287408 157359 287408 1/5/19 SP-13 CUST-140 PROD-021 MATL-Peridot SIZE-XS MSA-15 79 291825 156520 291825 1/5/19 SP-12 CUST-061 PROD-039 MATL-Emerald SIZE-XL MSA-55 4 178788 114860 178788 1/5/19 SP-05 CUST-139 PROD-048 MATL-Jade SIZE-L MSA-60 5 12690 8793 12690 1/5/19 SP-12 CUST-142 PROD-048 MATL-Brass SIZE-M MSA-30 11 420800 294556 420793 1/5/19 SP-07 CUST-071 PROD-055 MATL-Sapphire SIZE-L MSA-20 7 199980 142478 199980 1/5/19 SP-04 CUST-106 PROD-075 MATL-Jade SIZE-XL MSA-22 45 286440 179767 286440 1/5/19 SP-03 CUST-110 PROD-078 MATL-Garnet SIZE-XS MSA-10 44 67179 33056 67179 1/5/19 SP-15 CUST-014 PROD-089 MATL-Opal SIZE-L MSA-53 39 248589 101057 248589 1/5/19 SP-09 CUST-005 PROD-097 MATL-Topaz SIZE-S MSA-48 99 149300 97845 149300 1/5/19 SP-23 CUST-091 PROD-100 MATL-Gold SIZE-XS MSA-64 3 38108 25500 38108 1/5/19 SP-06 CUST-112 PROD-111 MATL-Peridot SIZE-XL MSA-12 50 26323 19012 26323 1/5/19 SP-01 CUST-041 PROD-120 MATL-Sapphire SIZE-XS MSA-56 18 27495 16795 27495 1/5/19 SP-09 CUST-065 PROD-131 MATL-Opal SIZE-S MSA-05 20 10198 5415 10198 1/5/19 SP-21 CUST-063 PROD-134 MATL-Citrine SIZE-S MSA-36 65 151620 95315 151620 1/5/19 SP-12 CUST-019 PROD-136 MATL-Silver SIZE-S MSA-39 15 363874 223948 363874 1/5/19 SP-13 CUST-100 PROD-141 MATL-Silver SIZE-M MSA-09 75 452850 332894 452850 1/5/19 SP-15 CUST-043 PROD-149 MATL-Garnet SIZE-M MSA-55 74 389888 215553 389888 1/5/19 SP-17 CUST-003 PROD-153 MATL-Tanzanite SIZE-M MSA-10 46 178581 110969 178581 1/5/19 SP-06 CUST-120 PROD-161 MATL-Peridot SIZE-XL MSA-15 44 153032 101683 153032 1/5/19 SP-12 CUST-027 PROD-169 MATL-Moonstone SIZE-L MSA-75 1 160819 82616 160819 1/5/19 SP-13 CUST-096 PROD-183 MATL-Amethyst SIZE-M MSA-58 64 368874 172180 368874 1/5/19 SP-15 CUST-099 PROD-193 MATL-Jade SIZE-XS MSA-70 73 408460 287630 408460 1/5/19 SP-06 CUST-098 PROD-194 MATL-Garnet SIZE-XS MSA-07 31 16017 8748 16017 1/6/19 SP-18 CUST-066 PROD-030 MATL-Peridot SIZE-M MSA-67 50 251618 174750 251618 1/6/19 SP-06 CUST-117 PROD-040 MATL-Bronze SIZE-L MSA-38 11 564606 411749 564606 1/6/19 SP-17 CUST-049 PROD-054 MATL-Garnet SIZE-M MSA-66 88 62293 45553 62293 1/6/19 SP-20 CUST-057 PROD-055 MATL-Quartz SIZE-XS MSA-72 86 24045 15394 24045 1/6/19 SP-16 CUST-103 PROD-067 MATL-Copper SIZE-L MSA-62 52 100419 64781 100419 1/6/19 SP-17 CUST-014 PROD-072 MATL-Ruby SIZE-M MSA-22 19 60940 36763 60940 1/6/19 SP-21 CUST-032 PROD-080 MATL-Jasper SIZE-L MSA-70 85 605787 349162 605787 1/6/19 SP-13 CUST-042 PROD-083 MATL-Amethyst SIZE-S MSA-39 91 490516 260077 490516 1/6/19 SP-12 CUST-051 PROD-084 MATL-Jasper SIZE-XL MSA-07 20 757064 567845 757064 1/6/19 SP-02 CUST-073 PROD-104 MATL-Sapphire SIZE-S MSA-65 97 131309 89308 131309 1/6/19 SP-20 CUST-035 PROD-104 MATL-Tanzanite SIZE-XS MSA-38 80 477350 255698 477350 1/6/19 SP-04 CUST-027 PROD-106 MATL-Tanzanite SIZE-XL MSA-06 63 675033 485335 675033 1/6/19 SP-21 CUST-052 PROD-107 MATL-Tanzanite SIZE-S MSA-46 16 799370 398619 799370 1/6/19 SP-19 CUST-138 PROD-111 MATL-Sapphire SIZE-L MSA-24 87 203600 142559 203600 1/6/19 SP-04 CUST-064 PROD-114 MATL-Jade SIZE-L MSA-52 7 475405 306932 475405 1/6/19 SP-21 CUST-047 PROD-139 MATL-Silver SIZE-XS MSA-65 34 158592 83757 158592 1/6/19 SP-05 CUST-074 PROD-186 MATL-Jasper SIZE-S MSA-27 21 294678 210989 294678 1/7/19 SP-03 CUST-093 PROD-003 MATL-Garnet SIZE-XL MSA-62 39 84825 56474 84825 1/7/19 SP-01 CUST-092 PROD-020 MATL-Brass SIZE-S MSA-59 9 258780 165883 258780 1/7/19 SP-07 CUST-080 PROD-024 MATL-Topaz SIZE-XS MSA-54 15 651888 363480 651888 1/7/19 SP-02 CUST-052 PROD-031 MATL-Amethyst SIZE-S MSA-51 72 530990 342148 530990 1/7/19 SP-08 CUST-120 PROD-032 MATL-Topaz SIZE-M MSA-57 50 57002 25127 57002 1/7/19 SP-11 CUST-075 PROD-039 MATL-Tanzanite SIZE-XL MSA-17 58 280488 191974 280488 1/7/19 SP-02 CUST-006 PROD-040 MATL-Gold SIZE-L MSA-72 58 562757 364182 562757 1/7/19 SP-09 CUST-148 PROD-045 MATL-Opal SIZE-L MSA-33 56 327210 199373 195810 1/7/19 SP-01 CUST-100 PROD-059 MATL-Quartz SIZE-M MSA-16 38 246470 149997 246470 1/7/19 SP-09 CUST-031 PROD-061 MATL-Copper SIZE-L MSA-25 18 285450 204572 285450 1/7/19 SP-05 CUST-107 PROD-063 MATL-Moonstone SIZE-L MSA-52 59 559261 361253 559261 1/7/19 SP-03 CUST-074 PROD-076 MATL-Jasper SIZE-XS MSA-61 73 131225 78375 131225 1/7/19 SP-14 CUST-004 PROD-080 MATL-Moonstone SIZE-L MSA-37 70 391500 276958 391500 1/7/19 SP-02 CUST-112 PROD-099 MATL-Gold SIZE-M MSA-44 22 73680 30103 73680 1/7/19 SP-14 CUST-071 PROD-102 MATL-Quartz SIZE-L MSA-37 88 248620 190478 248620 1/7/19 SP-07 CUST-064 PROD-106 MATL-Amethyst SIZE-XS MSA-62 31 432650 328663 432650 1/7/19 SP-04 CUST-089 PROD-110 MATL-Ruby SIZE-M MSA-48 65 438872 303101 438872 1/7/19 SP-04 CUST-121 PROD-110 MATL-Jade SIZE-M MSA-75 49 159102 69002 159102 1/7/19 SP-21 CUST-140 PROD-115 MATL-Opal SIZE-L MSA-44 93 737200 566134 737200 1/7/19 SP-12 CUST-096 PROD-116 MATL-Jade SIZE-S MSA-07 74 551986 369351 551986 1/7/19 SP-09 CUST-117 PROD-118 MATL-Topaz SIZE-M MSA-64 97 16946 7031 16946 1/7/19 SP-12 CUST-056 PROD-118 MATL-Tanzanite SIZE-L MSA-60 42 325332 246471 325332 1/7/19 SP-15 CUST-012 PROD-123 MATL-Aquamarine SIZE-S MSA-17 96 246150 134691 246150 1/7/19 SP-20 CUST-061 PROD-125 MATL-Sapphire SIZE-XS MSA-54 32 391580 252793 391580 1/7/19 SP-05 CUST-110 PROD-127 MATL-Moonstone SIZE-L MSA-17 25 462880 259230 462880 1/7/19 SP-06 CUST-124 PROD-130 MATL-Tanzanite SIZE-XL MSA-47 58 928416 719651 928416 1/7/19 SP-17 CUST-001 PROD-132 MATL-Quartz SIZE-XS MSA-23 19 20889 14916 20889 1/7/19 SP-13 CUST-147 PROD-136 MATL-Copper SIZE-XL MSA-42 90 559176 301184 559176 1/7/19 SP-04 CUST-038 PROD-139 MATL-Sapphire SIZE-XS MSA-15 33 163609 104315 163609 1/7/19 SP-15 CUST-118 PROD-185 MATL-Garnet SIZE-S MSA-48 3 309664 228175 309664 1/7/19 SP-15 CUST-006 PROD-189 MATL-Emerald SIZE-L MSA-15 69 924606 419250 924606 1/8/19 SP-12 CUST-131 PROD-006 MATL-Aquamarine SIZE-M MSA-21 91 603201 479309 603201 1/8/19 SP-10 CUST-145 PROD-007 MATL-Quartz SIZE-M MSA-34 97 916608 548458 916608 1/8/19 SP-03 CUST-130 PROD-008 MATL-Ruby SIZE-L MSA-06 88 318009 130383 318009 1/8/19 SP-02 CUST-093 PROD-009 MATL-Ruby SIZE-XS MSA-54 93 56130 25440 56130 1/8/19 SP-14 CUST-120 PROD-010 MATL-Tanzanite SIZE-L MSA-13 66 27489 17720 27489 1/8/19 SP-20 CUST-019 PROD-013 MATL-Quartz SIZE-XL MSA-53 89 264000 160371 264000 1/8/19 SP-18 CUST-132 PROD-014 MATL-Peridot SIZE-M MSA-52 95 488280 234489 488280 1/8/19 SP-13 CUST-106 PROD-017 MATL-Aquamarine SIZE-XL MSA-58 12 9296 5433 9296 1/8/19 SP-18 CUST-133 PROD-034 MATL-Brass SIZE-XS MSA-70 25 595595 337385 595595 1/8/19 SP-21 CUST-127 PROD-038 MATL-Bronze SIZE-XL MSA-02 79 397488 289127 397488 1/8/19 SP-15 CUST-070 PROD-041 MATL-Brass SIZE-XL MSA-75 53 36330 21219 36330 1/8/19 SP-14 CUST-104 PROD-043 MATL-Garnet SIZE-S MSA-51 89 198400 108043 198400 1/8/19 SP-04 CUST-075 PROD-074 MATL-Sapphire SIZE-XS MSA-01 16 592098 431895 592098 1/8/19 SP-02 CUST-143 PROD-079 MATL-Ruby SIZE-L MSA-36 71 43212 30545 43212 1/8/19 SP-02 CUST-014 PROD-103 MATL-Opal SIZE-XL MSA-38 15 12628 5323 12628 1/8/19 SP-07 CUST-028 PROD-111 MATL-Peridot SIZE-M MSA-36 78 13548 6576 13548 1/8/19 SP-20 CUST-006 PROD-112 MATL-Peridot SIZE-XS MSA-13 43 192739 121097 192739 1/8/19 SP-09 CUST-046 PROD-116 MATL-Ruby SIZE-XL MSA-12 11 328451 153230 328451 1/8/19 SP-03 CUST-020 PROD-117 MATL-Bronze SIZE-L MSA-23 65 185976 135629 185976 1/8/19 SP-06 CUST-043 PROD-120 MATL-Quartz SIZE-L MSA-65 78 137592 58589 137592 1/8/19 SP-07 CUST-149 PROD-121 MATL-Citrine SIZE-XS MSA-36 39 60204 28042 60204 1/8/19 SP-02 CUST-013 PROD-124 MATL-Copper SIZE-M MSA-04 17 324588 205532 324588 1/8/19 SP-01 CUST-056 PROD-133 MATL-Amethyst SIZE-S MSA-17 67 45746 27086 45746 1/8/19 SP-06 CUST-013 PROD-145 MATL-Ruby SIZE-XS MSA-34 14 541819 270799 299801 1/8/19 SP-23 CUST-031 PROD-151 MATL-Gold SIZE-XS MSA-38 91 729790 553765 729790 1/8/19 SP-09 CUST-047 PROD-152 MATL-Garnet SIZE-M MSA-10 2 166050 113805 166050 1/8/19 SP-11 CUST-087 PROD-153 MATL-Quartz SIZE-M MSA-70 41 520643 309329 388953 1/8/19 SP-05 CUST-014 PROD-167 MATL-Citrine SIZE-S MSA-43 91 38556 13419 38556 1/8/19 SP-18 CUST-037 PROD-171 MATL-Aquamarine SIZE-L MSA-54 71 338645 151193 338645 1/8/19 SP-20 CUST-116 PROD-178 MATL-Quartz SIZE-M MSA-34 84 155488 115330 155488 1/8/19 SP-11 CUST-143 PROD-180 MATL-Bronze SIZE-M MSA-58 84 585900 238812 585900 1/8/19 SP-06 CUST-149 PROD-189 MATL-Moonstone SIZE-M MSA-03 25 98908 45297 98908 1/8/19 SP-18 CUST-075 PROD-190 MATL-Jade SIZE-L MSA-64 68 150960 73193 150960 1/8/19 SP-21 CUST-044 PROD-193 MATL-Tanzanite SIZE-XL MSA-49 48 204568 126187 204568 1/9/19 SP-13 CUST-090 PROD-003 MATL-Brass SIZE-XL MSA-49 84 271050 180979 0 1/9/19 SP-20 CUST-025 PROD-005 MATL-Topaz SIZE-L MSA-34 44 777606 502240 777606 1/9/19 SP-12 CUST-013 PROD-012 MATL-Aquamarine SIZE-XL MSA-13 28 87498 61577 87498 1/9/19 SP-18 CUST-073 PROD-012 MATL-Sapphire SIZE-XL MSA-55 19 9419 6278 9419 1/9/19 SP-07 CUST-126 PROD-020 MATL-Ruby SIZE-S MSA-70 1 333234 189591 333234 1/9/19 SP-13 CUST-076 PROD-030 MATL-Aquamarine SIZE-L MSA-65 96 106612 78141 106612 1/9/19 SP-18 CUST-011 PROD-031 MATL-Quartz SIZE-XS MSA-70 40 259998 179416 259998 1/9/19 SP-15 CUST-098 PROD-032 MATL-Jasper SIZE-M MSA-32 53 253236 117989 0 1/9/19 SP-02 CUST-066 PROD-034 MATL-Gold SIZE-L MSA-72 39 70862 43474 70862 1/9/19 SP-15 CUST-079 PROD-042 MATL-Ruby SIZE-XS MSA-57 47 305648 230594 305648 1/9/19 SP-02 CUST-124 PROD-063 MATL-Peridot SIZE-L MSA-10 82 605052 413780 605052 1/9/19 SP-17 CUST-101 PROD-068 MATL-Tanzanite SIZE-XS MSA-42 53 931680 494300 839873 1/9/19 SP-07 CUST-004 PROD-091 MATL-Gold SIZE-L MSA-34 33 457920 348120 408917 1/9/19 SP-20 CUST-021 PROD-091 MATL-Amethyst SIZE-S MSA-38 81 390805 311131 390805 1/9/19 SP-08 CUST-140 PROD-093 MATL-Copper SIZE-XL MSA-52 94 243480 144474 243480 1/9/19 SP-07 CUST-003 PROD-098 MATL-Peridot SIZE-L MSA-21 11 12031 6376 12031 1/9/19 SP-08 CUST-122 PROD-143 MATL-Peridot SIZE-XS MSA-26 22 207594 156597 207594 1/9/19 SP-02 CUST-072 PROD-146 MATL-Bronze SIZE-L MSA-07 9 360120 201027 360120 1/9/19 SP-07 CUST-079 PROD-184 MATL-Quartz SIZE-L MSA-23 51 258016 198206 194717 1/9/19 SP-15 CUST-002 PROD-191 MATL-Opal SIZE-M MSA-49 30 795015 459155 795015 1/10/19 SP-13 CUST-020 PROD-009 MATL-Aquamarine SIZE-S MSA-21 28 467610 353258 467610 1/10/19 SP-23 CUST-116 PROD-025 MATL-Jasper SIZE-XL MSA-64 32 486719 256609 486719 1/10/19 SP-21 CUST-102 PROD-041 MATL-Emerald SIZE-M MSA-71 16 477675 341651 477675 1/10/19 SP-16 CUST-118 PROD-045 MATL-Opal SIZE-M MSA-08 24 189926 120215 189926 1/10/19 SP-21 CUST-123 PROD-045 MATL-Bronze SIZE-XS MSA-27 33 80070 46796 80070 1/10/19 SP-05 CUST-131 PROD-046 MATL-Sapphire SIZE-M MSA-57 22 36975 15509 36975 1/10/19 SP-01 CUST-003 PROD-054 MATL-Silver SIZE-XS MSA-46 55 388024 277856 388024 1/10/19 SP-13 CUST-125 PROD-059 MATL-Jasper SIZE-S MSA-18 63 369399 194570 369399 1/10/19 SP-20 CUST-121 PROD-061 MATL-Copper SIZE-XL MSA-34 59 529230 256721 529230 1/10/19 SP-12 CUST-021 PROD-064 MATL-Moonstone SIZE-S MSA-64 77 526295 246250 526295 1/10/19 SP-15 CUST-115 PROD-084 MATL-Copper SIZE-L MSA-72 56 276724 165257 262888 1/10/19 SP-18 CUST-121 PROD-094 MATL-Brass SIZE-XS MSA-40 17 423612 273325 423612 1/10/19 SP-13 CUST-104 PROD-099 MATL-Jasper SIZE-XL MSA-42 68 228888 100194 228888 1/10/19 SP-07 CUST-025 PROD-100 MATL-Brass SIZE-XL MSA-63 59 208828 137135 0 1/10/19 SP-14 CUST-079 PROD-104 MATL-Moonstone SIZE-L MSA-74 74 134344 85590 134344 1/10/19 SP-21 CUST-048 PROD-109 MATL-Jasper SIZE-M MSA-71 30 184368 129106 184368 1/10/19 SP-20 CUST-023 PROD-122 MATL-Peridot SIZE-XS MSA-10 45 127262 75965 127262 1/10/19 SP-03 CUST-025 PROD-139 MATL-Sapphire SIZE-S MSA-34 55 490091 307619 490091 1/10/19 SP-11 CUST-032 PROD-152 MATL-Brass SIZE-M MSA-55 78 70840 39671 70840 1/10/19 SP-02 CUST-135 PROD-164 MATL-Topaz SIZE-S MSA-36 61 561031 245105 561031 1/10/19 SP-05 CUST-096 PROD-171 MATL-Jade SIZE-XL MSA-02 10 298935 163689 298935 1/10/19 SP-06 CUST-026 PROD-185 MATL-Amethyst SIZE-XS MSA-73 56 150240 76111 150240 1/10/19 SP-05 CUST-127 PROD-190 MATL-Gold SIZE-XL MSA-36 29 250107 176582 250107 1/10/19 SP-18 CUST-028 PROD-194 MATL-Sapphire SIZE-XS MSA-75 53 53100 31712 53100 1/10/19 SP-18 CUST-124 PROD-196 MATL-Opal SIZE-S MSA-62 77 171680 119098 171680 1/11/19 SP-08 CUST-142 PROD-004 MATL-Citrine SIZE-XS MSA-17 96 300352 200444 300352 1/11/19 SP-07 CUST-138 PROD-017 MATL-Citrine SIZE-M MSA-08 46 548464 273548 548464 1/11/19 SP-02 CUST-087 PROD-020 MATL-Sapphire SIZE-XS MSA-25 32 192326 90988 192326 1/11/19 SP-15 CUST-054 PROD-023 MATL-Garnet SIZE-XL MSA-41 29 498336 262829 498336 1/11/19 SP-21 CUST-072 PROD-025 MATL-Brass SIZE-L MSA-08 38 108912 71546 108912 1/11/19 SP-18 CUST-089 PROD-027 MATL-Jasper SIZE-M MSA-35 12 214414 144556 214414 1/11/19 SP-09 CUST-039 PROD-047 MATL-Ruby SIZE-XS MSA-51 16 206520 98579 206520 1/11/19 SP-18 CUST-091 PROD-051 MATL-Sapphire SIZE-XS MSA-31 95 315172 189172 315172 1/11/19 SP-05 CUST-133 PROD-055 MATL-Citrine SIZE-XS MSA-21 59 545227 297849 545227 1/11/19 SP-21 CUST-072 PROD-076 MATL-Aquamarine SIZE-S MSA-04 8 753393 391051 753393 1/11/19 SP-15 CUST-046 PROD-078 MATL-Topaz SIZE-S MSA-70 83 134272 56244 134272 1/11/19 SP-11 CUST-038 PROD-105 MATL-Sapphire SIZE-XS MSA-03 60 67176 46168 67176 1/11/19 SP-09 CUST-072 PROD-112 MATL-Moonstone SIZE-XL MSA-57 47 336300 167122 336300 1/11/19 SP-23 CUST-112 PROD-121 MATL-Jade SIZE-XL MSA-33 98 179246 129576 179246 1/11/19 SP-16 CUST-061 PROD-129 MATL-Copper SIZE-L MSA-40 93 62016 40046 62016 1/11/19 SP-17 CUST-073 PROD-173 MATL-Emerald SIZE-S MSA-07 32 203154 116178 203154 1/12/19 SP-13 CUST-056 PROD-006 MATL-Quartz SIZE-L MSA-24 85 22019 11670 22019 1/12/19 SP-18 CUST-093 PROD-021 MATL-Jade SIZE-S MSA-06 42 70944 45128 70944 1/12/19 SP-18 CUST-083 PROD-025 MATL-Jade SIZE-XL MSA-13 8 220131 136838 220131 1/12/19 SP-09 CUST-122 PROD-029 MATL-Sapphire SIZE-L MSA-68 81 7632 4321 7632 1/12/19 SP-04 CUST-004 PROD-038 MATL-Peridot SIZE-S MSA-44 24 341768 194692 341768 1/12/19 SP-01 CUST-003 PROD-068 MATL-Tanzanite SIZE-XS MSA-05 97 151130 76660 151130 1/12/19 SP-12 CUST-123 PROD-071 MATL-Jasper SIZE-L MSA-34 48 29727 19434 29727 1/12/19 SP-02 CUST-126 PROD-085 MATL-Garnet SIZE-M MSA-64 31 691470 473404 691470 1/12/19 SP-01 CUST-086 PROD-089 MATL-Amethyst SIZE-M MSA-33 16 491169 313041 491169 1/12/19 SP-04 CUST-018 PROD-091 MATL-Tanzanite SIZE-L MSA-23 34 70263 42064 70263 1/12/19 SP-13 …