| View Question |
|
|
 | ||
|
| Subject:
Number Generating Software in this Format 2117 8389 7231
Category: Computers > Software Asked by: scottrichards-ga List Price: $2.00 |
Posted:
11 Feb 2006 06:40 PST
Expires: 13 Mar 2006 06:40 PST Question ID: 444497 |
I would like to get information about a number generating software to generate numbers. The format for the number is 2117 8389 7231. I know of a software company or software I guess, Gen-IT, but I dont how to get the software. Please help me out. |
| ||
|
| There is no answer at this time. |
| ||
|
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: bbustudentanswer-ga on 11 Feb 2006 14:08 PST |
I can make you such a program, that generates such numbers randomly and save them to a txt file if you want |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: scottrichards-ga on 12 Feb 2006 10:51 PST |
If that would be possible, I would be readily available to entertain discussions with you. Kindly let me know how to get in touch with you. |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: brix24-ga on 12 Feb 2006 15:54 PST |
The site for Gen-IT is http://www.namitech.com/products/GenIT.htm but their brochure is under revision. They do list an email address for further information, though. ---------------- You can generate random numbers of the form you want in Excel if you don't find the specific software you want, though. One solution in Excel would be the following; it uses ten cells. Step 1: In a cell, say, A1, put in the formula =TEXT(TRUNC(RAND()*9999.9999),0) to get a random integer between 0 and 9999. Step 2: You'll need the length of the digit for numbers like "24," which need leading zeros to get the four-digit form you require. In cell A2, put in =LEN(A1) Step 3: In cell A3, add leading zeros if necessary: =LEFT("0000", 4-A2) & A1 Step 4: Copy cells A1 through A3 to columns B and C to get two more 4 digit numbers. Step 5: Combine these numbers and intervening spaces in cell D3 =A3 & " " & B3 & " " & C3 -------- Forcing a recalculation will generate a new random number in cell D3. ("CMD =" does this in Excel on a Mac). -------- You can copy each number to another application, such as Word; but, if you want to copy each number to another cell in Excel, you'll need to use "Paste Special" in the Edit menu and then select "Values." |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: brix24-ga on 12 Feb 2006 16:02 PST |
I assumed that you wanted random numbers. However, if you want consecutive serial numbers, you can also generate these in Excel. |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: scottrichards-ga on 13 Feb 2006 00:12 PST |
I actually wanted random numbers. However I didnt quite get the excel idea. Could you do a little more on a generating software. |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: kalt-ga on 13 Feb 2006 03:42 PST |
You can also generate random numbers in HTML using javascript.
--------------
<HTML>
<HEAD></HEAD>
<BODY>
<SCRIPT LANGUAGE="JavaScript">
<!--
function rand4() {
var totalDigits = 4;
var n = Math.random()*10000;
n = Math.round(n);
n = n.toString();
var pd = '';
if (totalDigits > n.length) {
for (i=0; i < (totalDigits-n.length); i++) {
pd += '0';
}
}
return pd + n.toString();
}
function num_gen() {
var num = rand4()+" "+rand4()+" "+rand4();
document.frm1.num.value = num;
}
//-->
</SCRIPT>
<FORM name="frm1" onSubmit="num_gen();return false;">
<INPUT TYPE="text" NAME="num">
<INPUT TYPE="submit" value="Generate">
</FORM>
</BODY></HTML> |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: brix24-ga on 13 Feb 2006 17:49 PST |
scottrichards,
To generate a random number in your format in Excel,
Open a new Excel spreadsheet.
Go back to your browser, highlight and copy the following 3 lines:
=TEXT(TRUNC(RAND()*9999.9999),0)
=LEN(A1)
=LEFT("0000", 4-A2) & A1
Go to cell A1 in Excel and paste (ctrl-V in Windows); numbers should
appear in cells A1, A2, and A3.
These cells should already be highlighted; copy them (ctrl-C).
Highlight cells B1 and C1; then paste (ctrl-V).
You should now have numbers in 9 cells. The last line is the one you
are interested in. Press F9; the numbers should change. Upon pressing
F9, you will occasionally get a number less than 1000; note that
leading zero(s) have been added.
The next step is to combine the three numbers in row 3. To do that,
copy the line below and paste it in cell D3.
=A3 & " " & B3 & " " & C3
Now when you press F9, the number in D3 changes each time and should
be in the format you want.
------
You can copy the numbers in D3 individually or you can use a macro to
generate 100 at a time. But first, see if the above works for you.
Ignore the following; I'm just testing for unexpected line breaks in
case you decide to go the macro route.
Sub CopyValues()
Range("D3").Select
Application.CutCopyMode = False
Selection.Copy
Range("E6").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
For i = 1 To 99
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Next
End Sub |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: scottrichards-ga on 14 Feb 2006 10:02 PST |
Thanks for the comments, I was made to understand that there is a logrithm that goes with number generators(ions) I want to know, having taking into consideration the number format above, if there is a script or a generator that can generate in line with the number above. Thank you |
| Subject:
Re: Number Generating Software in this Format 2117 8389 7231
From: brix24-ga on 14 Feb 2006 18:34 PST |
I'm lost at your comment about a logarithm. You should probably contact the Gen-IT email address and see if you can purchase the software you want. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |