Ideas on generating membership numbers [closed]
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
We have 5 clients. Members have a prefix that identifies what client they are part of. For example, if a member is part of the first client, their membership number will start with an A. If they are part of the second client, their membership number will start with B and so on. Our concern now is that we will run out of alphabets to prefix membership numbers with when we have more than 26 clients. What ideas do you all have to solve this problem? We want it to be something simple because these are distributed to the end user, but we also want them to be flexible enough for our needs.
random
asked Jan 3 at 20:14
AaronAaron
3201210
closed as too broad by anothermh, orde, halfelf, Dave Cousineau, Billal Begueradj Jan 4 at 3:58
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
We have 5 clients. Members have a prefix that identifies what client they are part of. For example, if a member is part of the first client, their membership number will start with an A. If they are part of the second client, their membership number will start with B and so on. Our concern now is that we will run out of alphabets to prefix membership numbers with when we have more than 26 clients. What ideas do you all have to solve this problem? We want it to be something simple because these are distributed to the end user, but we also want them to be flexible enough for our needs.
random
asked Jan 3 at 20:14
AaronAaron
3201210
closed as too broad by anothermh, orde, halfelf, Dave Cousineau, Billal Begueradj Jan 4 at 3:58
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
We have 5 clients. Members have a prefix that identifies what client they are part of. For example, if a member is part of the first client, their membership number will start with an A. If they are part of the second client, their membership number will start with B and so on. Our concern now is that we will run out of alphabets to prefix membership numbers with when we have more than 26 clients. What ideas do you all have to solve this problem? We want it to be something simple because these are distributed to the end user, but we also want them to be flexible enough for our needs.
random
asked Jan 3 at 20:14
AaronAaron
3201210
We have 5 clients. Members have a prefix that identifies what client they are part of. For example, if a member is part of the first client, their membership number will start with an A. If they are part of the second client, their membership number will start with B and so on. Our concern now is that we will run out of alphabets to prefix membership numbers with when we have more than 26 clients. What ideas do you all have to solve this problem? We want it to be something simple because these are distributed to the end user, but we also want them to be flexible enough for our needs.
random
random
asked Jan 3 at 20:14
AaronAaron
3201210
asked Jan 3 at 20:14
AaronAaron
3201210
asked Jan 3 at 20:14
AaronAaron
3201210
asked Jan 3 at 20:14
AaronAaron
3201210
asked Jan 3 at 20:14
AaronAaron
3201210
3201210
closed as too broad by anothermh, orde, halfelf, Dave Cousineau, Billal Begueradj Jan 4 at 3:58
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by anothermh, orde, halfelf, Dave Cousineau, Billal Begueradj Jan 4 at 3:58
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If the prefix to identify clients can be two digits and the first prefix must be the capital letter, the maximum number of combination can cover 936 cases.
676=26x26 (e.g. AA, AB, ..., ZZ)
260=26x10 (e.g. A0, A1, ..., Z9)
936=676+260
If only one prefix is allowed, you can consider using small letters as well. Then it can cover 52 clients. Hope this is helpful.
answered Jan 3 at 20:36
TK KimTK Kim
261
add a comment |
Since your case sounds like a business-professional setting, it is strongly advised to stay away from inconsistent naming conventions such as mixing both uppercase and lowercase. Instead, try and use another naming convention eg
CLIENT 1 - 0001
...
CLIENT 2,452 - 2452
answered Jan 3 at 20:49
Muga S.Muga S.
225
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
If the prefix to identify clients can be two digits and the first prefix must be the capital letter, the maximum number of combination can cover 936 cases.
676=26x26 (e.g. AA, AB, ..., ZZ)
260=26x10 (e.g. A0, A1, ..., Z9)
936=676+260
If only one prefix is allowed, you can consider using small letters as well. Then it can cover 52 clients. Hope this is helpful.
answered Jan 3 at 20:36
TK KimTK Kim
261
add a comment |
If the prefix to identify clients can be two digits and the first prefix must be the capital letter, the maximum number of combination can cover 936 cases.
676=26x26 (e.g. AA, AB, ..., ZZ)
260=26x10 (e.g. A0, A1, ..., Z9)
936=676+260
If only one prefix is allowed, you can consider using small letters as well. Then it can cover 52 clients. Hope this is helpful.
answered Jan 3 at 20:36
TK KimTK Kim
261
add a comment |
If the prefix to identify clients can be two digits and the first prefix must be the capital letter, the maximum number of combination can cover 936 cases.
676=26x26 (e.g. AA, AB, ..., ZZ)
260=26x10 (e.g. A0, A1, ..., Z9)
936=676+260
If only one prefix is allowed, you can consider using small letters as well. Then it can cover 52 clients. Hope this is helpful.
answered Jan 3 at 20:36
TK KimTK Kim
261
If the prefix to identify clients can be two digits and the first prefix must be the capital letter, the maximum number of combination can cover 936 cases.
676=26x26 (e.g. AA, AB, ..., ZZ)
260=26x10 (e.g. A0, A1, ..., Z9)
936=676+260
If only one prefix is allowed, you can consider using small letters as well. Then it can cover 52 clients. Hope this is helpful.
answered Jan 3 at 20:36
TK KimTK Kim
261
answered Jan 3 at 20:36
TK KimTK Kim
261
answered Jan 3 at 20:36
TK KimTK Kim
261
answered Jan 3 at 20:36
TK KimTK Kim
261
261
add a comment |
add a comment |
Since your case sounds like a business-professional setting, it is strongly advised to stay away from inconsistent naming conventions such as mixing both uppercase and lowercase. Instead, try and use another naming convention eg
CLIENT 1 - 0001
...
CLIENT 2,452 - 2452
answered Jan 3 at 20:49
Muga S.Muga S.
225
add a comment |
Since your case sounds like a business-professional setting, it is strongly advised to stay away from inconsistent naming conventions such as mixing both uppercase and lowercase. Instead, try and use another naming convention eg
CLIENT 1 - 0001
...
CLIENT 2,452 - 2452
answered Jan 3 at 20:49
Muga S.Muga S.
225
add a comment |
Since your case sounds like a business-professional setting, it is strongly advised to stay away from inconsistent naming conventions such as mixing both uppercase and lowercase. Instead, try and use another naming convention eg
CLIENT 1 - 0001
...
CLIENT 2,452 - 2452
answered Jan 3 at 20:49
Muga S.Muga S.
225
Since your case sounds like a business-professional setting, it is strongly advised to stay away from inconsistent naming conventions such as mixing both uppercase and lowercase. Instead, try and use another naming convention eg
CLIENT 1 - 0001
...
CLIENT 2,452 - 2452
answered Jan 3 at 20:49
Muga S.Muga S.
225
answered Jan 3 at 20:49
Muga S.Muga S.
225
answered Jan 3 at 20:49
Muga S.Muga S.
225
answered Jan 3 at 20:49
Muga S.Muga S.
225
225
add a comment |
add a comment |
