Queries on huge number sequential generator

[nuke_shanc]

i'm trying to generate sequential number from the range of millions to billions..to be exact up to 500 billion.

exp.
>2345678-7898968<
>101818292823-497263741759<

I would like to know if there is any freeware or free server provider available for me to do this computation fast..and if possible,any advice on computer system requirement for this process to be done at a reasonable fast speed..because with my hp mini and remaining ms excel trials,i think im pretty much screwed..=p..hehe..thankz in advance everyone..have a great day ahead..😀

 

[Crusty]

Your example isn't really helpful.

Are you trying to generate a list like
1
2
3
4
5
...
100
101
102
103
...
100,000,000,000
100,000,000,001

Or are you trying to generate a number that has 500 billion digits in it?

 

[mpo]

Would =randbetween(1M,500B) in A1, then =A1+1 in B1 (repeat as necessary) generate the sequences you need?

 

[nuke_shanc]

Your example isn't really helpful.

Are you trying to generate a list like
1
2
3
4
5
...
100
101
102
103
...
100,000,000,000
100,000,000,001

Or are you trying to generate a number that has 500 billion digits in it?

Crusty its the 1st type u mentioned..

1
2
3
...

400,000,000,000
400,000,000,001

...


it has to be in a defined range with increase of +1..not a random sequence..

exp.

>2345678-5678901<

2345678
2345679
...

4567881
4567882
...

5678900
5678901.

hope this extra info helps..thankz..:biggrin:

 

[Ken g6]

for /l %i in (2345678,1,5678901) do @echo %i

works. But it fails above 2^31, roughly 2 billion. It might work better on Win64.

Otherwise, you need a version of "seq" or "jot" that works with 64-bit numbers. I once modified a BSD jot to work with Cygwin; but it doesn't do 64-bit numbers.

 

[Ken g6]

Oh, snap, I figured out how to do it!

First you need seq.exe from here.

Now, supposing you need 101818292823-497263741759, in a batch file, write:

jot -f "10181&#37;07.0f" 8292823 9999999
for /l %%i in (10182,1,49725) do jot -f "%%i%07.0f" 0 9999999
jot -f "49726%07.0f" 0 3741759

Will that work for you?