App to analyze list with sequential numbers ...

  • Thread starter Thread starter Galaxy
  • Start date Start date
G

Galaxy

.... that reports what numbers are missing. Is there any such animal?

Need it to allow me to find out what files I'm missing. I'll get
files names in a folder and run through such an app to know what I
need to go hunting for. Thx.
 
... that reports what numbers are missing. Is there any such animal?

Need it to allow me to find out what files I'm missing. I'll get
files names in a folder and run through such an app to know what I
need to go hunting for. Thx.
Click to expand...

Is there anything out there that we can dump a list into and that can
tell us what is missing? Just a list analyzer, don't need to analyze
anything other than that.
 
Galaxy said:
Is there anything out there that we can dump a list into and that can
tell us what is missing? Just a list analyzer, don't need to analyze
anything other than that.
Click to expand...

It's not as simple as *dumping in a list* but you can do this in a
spreadsheet - easier to do than to explain . . . . If only a few
numbers are are missing this method will find them quickly.

http://www.sover.net/~wysiwygx/Apps2.html

Sphygmic Spreadsheet

http://www.ds.unifi.it/~stefanin/AGR_2001/SH/SSSHEET.ZIP

918Kb

Paste your list into column A and sort in numerical order. Make a
consecutive list of similar numbers in column B (first number in cell B1
is the same as the number in cell A1) then in cell B2 write this formula
[ =B1+1 } copy and paste the formula into the cells below in column B.
In cell C1 write this formula [ =(A1=B1) ] then copy and paste that
formula into the cells below in column C.

If the numbers match you will see *true* in column C, if they don't you
will see *false*. Insert a new line wherever the numbers don't match,
and recopy the formula in column B from a cell above into the cell where
you inserted the new row and all the cells below that.

Repeat this process whenever you come to a false statement. When you are
done Column A will have blank spaces where the missing reports are.

Apologies if you knew all that already. :)

Susan
 
Galaxy said:
Is there anything out there that we can dump a list into and that can
tell us what is missing? Just a list analyzer, don't need to analyze
anything other than that.
Click to expand...

It's not as simple as *dumping in a list* but you can do this in a
spreadsheet - easier to do than to explain . . . . If only a few
numbers are are missing this method will find them quickly.

http://www.sover.net/~wysiwygx/Apps2.html

Sphygmic Spreadsheet

http://www.ds.unifi.it/~stefanin/AGR_2001/SH/SSSHEET.ZIP

918Kb

Paste your list into column A and sort in numerical order. Make a
consecutive list of similar numbers in column B (first number in cell B1
is the same as the number in cell A1) then in cell B2 write this formula
[ =B1+1 } copy and paste the formula into the cells below in column B.
In cell C1 write this formula [ =(A1=B1) ] then copy and paste that
formula into the cells below in column C.

If the numbers match you will see *true* in column C, if they don't you
will see *false*. Insert a new line wherever the numbers don't match,
and recopy the formula in column B from a cell above into the cell where
you inserted the new row and all the cells below that.

Repeat this process whenever you come to a false statement. When you are
done Column A will have blank spaces where the missing reports are.

Apologies if you knew all that already. :)

Susan
Click to expand...

No, I didn't know this. But this is way too labour intensive a
method. Darn.

Well, I'll keep looking.

Thanks.
 
perhaps i'm not quite understanding...

you have a folder of files and you have file containing filenames and
you want to see which files in the list are not present in the folder?


in dos get a file containing the file list that you do have:

Dir/b >files.txt

then run files.txt and your original list through some file comparison
program, such as examdiff.

yes, there might be a bit of editing at the start to make the file
formats match.


does that do it?


jack
overmoused
[The mail address is a dud. Reply here or nowhere.]
 
Galaxy said:
SNIP

No, I didn't know this. But this is way too labour intensive a
method. Darn.
Click to expand...

I was doing it the hard way. :(

This should be much easier. Paste your numerical list into column A and
sort it. In Column B write this formula in cell B1:

=A2-1

Copy the formula in cell B1 down to the end of the list. You will see
*false* in the Col. B cells where the sequence breaks.

*If* (not sure) Sphygmic supports copying the Col B formulas and the
pasting them in the same place as data you could do that and then sort
the data on Col B (true-false). The places where the sequence breaks
would sort to the top of the list.

HTH

Susan
 
Paste your list into column A and sort in numerical order. Make a
consecutive list of similar numbers in column B (first number in cell B1
is the same as the number in cell A1) then in cell B2 write this formula
[ =B1+1 } copy and paste the formula into the cells below in column B.
In cell C1 write this formula [ =(A1=B1) ] then copy and paste that
formula into the cells below in column C.
Click to expand...
Click to expand...
No, I didn't know this. But this is way too labour intensive a
method. Darn.
Click to expand...

I don't know if this works in the freeware spreadsheets, I use excel,
but it very well may do if they are clones.

In excel when you click a cell you get bold box with a square in the
bottom right corner. Click and drag that square and you will copy the
cell into all the cells you cover. In fact if the cell has say 1,
then you will get 1,2,3... so if what you really want is 1,1,1... then
hold the ctrl key down as you drag, or select two cells then drag. If
the 2 cells are 1,1 then you get 1,1,1,1.... if they are 1,3 then you
will get 1,3,5,7...

....malcolm


--

....malcolm

Malcolm Reeves BSc CEng MIEE MIRSE, Full Circuit Ltd, Chippenham, UK
([email protected], (e-mail address removed) or (e-mail address removed)).
Design Service for Analogue/Digital H/W & S/W Railway Signalling and Power
electronics. More details plus freeware, Win95/98 DUN and Pspice tips, see:

http://www.fullcircuit.com or http://www.fullcircuit.co.uk

NEW - Desktop ToDo/Reminder program (free)
 
Paste your list into column A and sort in numerical order. Make a
consecutive list of similar numbers in column B (first number in cell B1
is the same as the number in cell A1) then in cell B2 write this formula
[ =B1+1 } copy and paste the formula into the cells below in column B.
In cell C1 write this formula [ =(A1=B1) ] then copy and paste that
formula into the cells below in column C.
Click to expand...
Click to expand...
No, I didn't know this. But this is way too labour intensive a
method. Darn.
Click to expand...

I don't know if this works in the freeware spreadsheets, I use excel,
but it very well may do if they are clones.

In excel when you click a cell you get bold box with a square in the
bottom right corner. Click and drag that square and you will copy the
cell into all the cells you cover. In fact if the cell has say 1,
then you will get 1,2,3... so if what you really want is 1,1,1... then
hold the ctrl key down as you drag, or select two cells then drag. If
the 2 cells are 1,1 then you get 1,1,1,1.... if they are 1,3 then you
will get 1,3,5,7...

...malcolm
Click to expand...

Thanks everyone for your replies. It all sounds complicated a bit,
still, but will give it a try.
 
Back
Top