- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: Serial number generator
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Serial number generator"
Collapse
-
It's not 5min if you don't want any value to be valid. I wrote one a while back with a few rules in and it was a bit of a pain. I couldn't find anything simple that already did this which surprised me.Originally posted by Sockpuppet View PostWhy not code one yourself. Doesn't look like more than 5 mins coding. How the serial works will mostly depend on how you want to put some checksums in there to stop it being cracked. Once you've worked that out the rest is easy.
Leave a comment:
-
Actually A1-D1 you need
=int(100000*rand())
Otherwise works ok.
40005-88863-01206-96417-66044
40005-42234-16137-76414-17631
40005-76773-38552-29731-96664
40005-16538-12253-66953-69267
40005-54940-53351-08973-37871
40005-46099-30337-30678-71262
40005-18516-88358-12862-57096
40005-42846-94455-42677-15131
40005-90739-15050-56630-41729
40005-46455-37635-35233-66349
40005-68477-26012-73211-89297
40005-63656-25269-36979-17348
40005-73675-84776-05998-79347
40005-72120-28980-29534-18443
40005-91312-54841-84312-77741
40005-89428-00814-65354-59513
40005-57312-89746-85147-92536
40005-94017-49069-48964-57595
It will change values when you open so for record cut n paste generated list as text.
Leave a comment:
-
Use Excel. Off top of head;
Put this in A1,B1,C1,D1:
=99999*rnd()+1
Then E1:
= "40005-" & text(A1,"00000") & "-" & text(B1,"00000") & "-" & text(C1,"00000") & "-" & text(D1,"00000")
Copy these to as many rows as needed. If that's not quite right, examples in help.
Leave a comment:
-
I'm not a coder.Originally posted by Sockpuppet View PostWhy not code one yourself. Doesn't look like more than 5 mins coding. How the serial works will mostly depend on how you want to put some checksums in there to stop it being cracked. Once you've worked that out the rest is easy.
Leave a comment:
-
Originally posted by Cliphead View PostI'm looking for an app that can generate serial numbers to a specific format something like;
40005-12345-54321-09876-34567
The first group of 5 numbers I choose via the app (this identifies the product - 40005), the rest being unique / randomly generated.
I would also like to be able to specify how many serials I want, 100, 50,000 etc.
Not having much luck searching on Google. Anybody know of such an app?
Why not code one yourself. Doesn't look like more than 5 mins coding. How the serial works will mostly depend on how you want to put some checksums in there to stop it being cracked. Once you've worked that out the rest is easy.
Leave a comment:
-
Serial number generator
I'm looking for an app that can generate serial numbers to a specific format something like;
40005-12345-54321-09876-34567
The first group of 5 numbers I choose via the app (this identifies the product - 40005), the rest being unique / randomly generated.
I would also like to be able to specify how many serials I want, 100, 50,000 etc.
Not having much luck searching on Google. Anybody know of such an app?Tags: None
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers


Leave a comment: