Chinese In North America(北美华人e网)

注册
发新话题 回复该主题

1#

用excel算Lowes $60 off $400的coupon code


https://slickdeals.net/f/9549456-lowe-s-10-15-50-off-online-coupons-sharing-only-no-off-topic?p=99447632#post99447632


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.

试了完全work
转发
TOP
0
0
2#

膜拜一个先
TOP
0
0
3#


omg...
<娛樂金魚眼>*勁攪笑
TOP
0
0
4#

太厉害了啊
TOP
0
0
5#

佩服佩服
TOP
0
0
6#

膜拜大神!!!
TOP
0
0
7#

回复 1楼俗人乙的帖子

Is it legal?

☆ 发自 iPhone 华人一网 1.12.02
TOP
0
0
发新话题 回复该主题