m****a 发帖数: 2593 | 3 Community Wiki
Last Edited by Preon November 27, 2017 at 09:40 AM
December Master codes (as of 11/27):
$20 off $100 - 9381 (exp 12/27)
$40 off $200 - 9387 (exp 12/27)
$60 off $400 - 9393 (exp 12/27)
November Master codes (as of 11/6):
10% off - 0017, 0018, 0019 (exp 11/30)
$10 off $50 - 9216, 9217
$15 off $75 - 9343, 9344
$20 off $100 - 0014, 0015, 0048 (exp 11/30)
$40 off $200 - 9387 (exp 11/30)
$60 off $400 - 9393
**There are no $50 off $250 or $15 off $50 at this time - they have been
discontinued**
Pretend this is cell A1. Basically here is an example of the first 14 digits
of the $15 off $50:
Code:
=47000&TEXT(RANDBETWEEN(0,55000),"00000")&7119
Replace the last 4 digits as necessary with new expiration codes (from the
wiki part on top half of page). Also 10% off codes can use 99999 instead of
55000.
Pretend this is cell A2. This code generates the 3x weighted average check
bit (last digit), same principle as UPC, ISBN, and just about every other
barcode out there...
Code:
=A1&RIGHT(10-MOD(SUMPRODUCT(MID(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14},1)*{1,
3,1,3,1,3,1,3,1,3,1,3,1,3}),10))
Press F9 in excel to refresh cells and generate a new code. Saves time
instead of fumbling around and trying every last digit to determine which is
the correct one. |