Insurance inventory?

I'm inventorying my collection (ugh!) for a stamp insurance policy. I'm
putting the Scott numbers in text files for each country - like

5, 7 - 10, 32*, etc.

where 7 - 10 means 7, 8, 9 & 10 and the asterisk means unused/mint. No
prices.

I'm thinking of writing a little utility program to reformat this raw
information into columns. What do you think would be a good display/print
format? Or just leave the text files alone?

I could probably ask the insurance company but that would take all the
fun out of it.

I have MANY countries to go!

Hopefully I'll never need these files.

TIA

Ken


--
"When you choose the lesser of two evils, always
remember that it is still an evil." - Max Lerner

What stamp insurance carrier requires an inventory?

Mine (APS/Hugh Wood) only requires a schedule of individual
items valued at $25,000 or more.

Jay Carrigan see web site for email address
www.jaypex.com


In article ,
says...

I'm inventorying my collection (ugh!) for a stamp insurance policy. I'm
putting the Scott numbers in text files for each country - like

5, 7 - 10, 32*, etc.

where 7 - 10 means 7, 8, 9 & 10 and the asterisk means unused/mint. No
prices.

I'm thinking of writing a little utility program to reformat this raw
information into columns. What do you think would be a good display/print
format? Or just leave the text files alone?

I could probably ask the insurance company but that would take all the
fun out of it.

I have MANY countries to go!

Hopefully I'll never need these files.

TIA

Ken


--
"When you choose the lesser of two evils, always
remember that it is still an evil." - Max Lerner

Hi KenK,

It is not all that simple to expand the raw data. Contact me privately
as I have VBA programs to do exactly what you need. The VBA programs
are written for MS WORD 2000 and may need tweaking for any other
version of WORD. Please put RCSD in your subject line so I won't
delete your message.

Jerry B

Collectibles Insurance Services, LLC

(Jay T. Carrigan) wrote in
news:aQBkm.13540$5n1.6096@attbi_s21:

What stamp insurance carrier requires an inventory?

Mine (APS/Hugh Wood) only requires a schedule of individual
items valued at $25,000 or more.

Jay Carrigan see web site for email address
www.jaypex.com


In article ,
says...

I'm inventorying my collection (ugh!) for a stamp insurance policy.
I'm putting the Scott numbers in text files for each country - like

5, 7 - 10, 32*, etc.

where 7 - 10 means 7, 8, 9 & 10 and the asterisk means unused/mint. No
prices.

I'm thinking of writing a little utility program to reformat this raw
information into columns. What do you think would be a good
display/print format? Or just leave the text files alone?

I could probably ask the insurance company but that would take all the
fun out of it.

I have MANY countries to go!

Hopefully I'll never need these files.

TIA

Ken


--
"When you choose the lesser of two evils, always
remember that it is still an evil." - Max Lerner











--
"When you choose the lesser of two evils, always
remember that it is still an evil." - Max Lerner

jerry wrote in news:6cebdc78-60fb-45b3-84a9-
:

Hi KenK,

It is not all that simple to expand the raw data. Contact me privately
as I have VBA programs to do exactly what you need. The VBA programs
are written for MS WORD 2000 and may need tweaking for any other
version of WORD. Please put RCSD in your subject line so I won't
delete your message.

Jerry B


Thanks but I'm using the opportunity to teach myself AWK (I speak several
languages already and AWK looks appropriate to the task and doesn't look
very difficult to learn). If that fails, then ...

Also, I'm using a very old version of Word; I rarely need a word
processor except to write a short simple letter once or twice a month and
don't use the other Office stuff at all.

Ken


--
"When you choose the lesser of two evils, always
remember that it is still an evil." - Max Lerner

KenK wrote:
I'm inventorying my collection (ugh!) for a stamp insurance policy. I'm
putting the Scott numbers in text files for each country - like

5, 7 - 10, 32*, etc.

where 7 - 10 means 7, 8, 9 & 10 and the asterisk means unused/mint. No
prices.

I'm thinking of writing a little utility program to reformat this raw
information into columns. What do you think would be a good display/print
format? Or just leave the text files alone?

I could probably ask the insurance company but that would take all the
fun out of it.

I have MANY countries to go!

Hopefully I'll never need these files.

TIA

Ken



My first stamp inventory program was a Lotus 123 spreadsheet with 3
columns headed Scott, Mint, Used.
The first column held the Scott number, the second and third had x's if
I owned the stamp and blanks if I didn't.
It's very easy to put a list of numbers in column A automatically.
OpenOffice.org's Calc is a great free spreadsheet program. It's a pretty
big download, though.

Bill

Bill Sharpe wrote in
news


KenK wrote:
I'm inventorying my collection (ugh!) for a stamp insurance policy.
I'm putting the Scott numbers in text files for each country - like

5, 7 - 10, 32*, etc.

where 7 - 10 means 7, 8, 9 & 10 and the asterisk means unused/mint.
No prices.

I'm thinking of writing a little utility program to reformat this raw
information into columns. What do you think would be a good
display/print format? Or just leave the text files alone?

I could probably ask the insurance company but that would take all
the fun out of it.

I have MANY countries to go!

Hopefully I'll never need these files.

TIA

Ken



My first stamp inventory program was a Lotus 123 spreadsheet with 3
columns headed Scott, Mint, Used.
The first column held the Scott number, the second and third had x's
if I owned the stamp and blanks if I didn't.
It's very easy to put a list of numbers in column A automatically.
OpenOffice.org's Calc is a great free spreadsheet program. It's a
pretty big download, though.

Bill


I have a general collection to 1990 with big gaps after 1970 so that
wouldn't work. Too many countries. Too many big files with many unused
lines. I could use it for my US though, which is by far my country with
the most stamps.

Thanks for the idea. Spreadsheets had crossed my mind but just for
numbers I have - but after trying it I found entry to my raw data files
is much faster. Your system would be great though for a more specialized
collection.

Ken



--
"When you choose the lesser of two evils, always
remember that it is still an evil." - Max Lerner

KenK wrote:
Bill Sharpe wrote in
news

My first stamp inventory program was a Lotus 123 spreadsheet with 3
columns headed Scott, Mint, Used.
The first column held the Scott number, the second and third had x's
if I owned the stamp and blanks if I didn't.
It's very easy to put a list of numbers in column A automatically.
OpenOffice.org's Calc is a great free spreadsheet program. It's a
pretty big download, though.

Bill


I have a general collection to 1990 with big gaps after 1970 so that
wouldn't work. Too many countries. Too many big files with many unused
lines. I could use it for my US though, which is by far my country with
the most stamps.

Thanks for the idea. Spreadsheets had crossed my mind but just for
numbers I have - but after trying it I found entry to my raw data files
is much faster. Your system would be great though for a more specialized
collection.

Ken



My simple Lotus spreadsheet worked fine with my US stamps back in 1985
-- there were only about 2000 Scott numbers then. You could also easily
delete the rows for stamps you don't have. You could use the approach
for multiple countries by adding worksheets for each additional one.

Of course, with your approach if you own the whole set of Presidential
issues it's much easier to type in 803-834 than it is to make an entry
for each stamp.

Bill

"Bill Sharpe" wrote in message ...


KenK wrote:
Bill Sharpe wrote in
news

My first stamp inventory program was a Lotus 123 spreadsheet with 3 columns headed Scott, Mint, Used.
The first column held the Scott number, the second and third had x's
if I owned the stamp and blanks if I didn't.
It's very easy to put a list of numbers in column A automatically.
OpenOffice.org's Calc is a great free spreadsheet program. It's a
pretty big download, though.

Bill


I have a general collection to 1990 with big gaps after 1970 so that wouldn't work. Too many countries. Too many big
files with many unused lines. I could use it for my US though, which is by far my country with the most stamps.

Thanks for the idea. Spreadsheets had crossed my mind but just for numbers I have - but after trying it I found entry
to my raw data files is much faster. Your system would be great though for a more specialized collection.

Ken



My simple Lotus spreadsheet worked fine with my US stamps back in 1985 -- there were only about 2000 Scott numbers
then. You could also easily delete the rows for stamps you don't have. You could use the approach for multiple
countries by adding worksheets for each additional one.

Of course, with your approach if you own the whole set of Presidential issues it's much easier to type in 803-834 than
it is to make an entry for each stamp.

Bill

Personally, I find MSWorks the ideal vehicle.
A Flat file database of 30,000 records and 156 fields

My Database of US holds 7,056 records and turns in at just over 1Mb

You can split screen, hide records, and search, all of which is a doddle.
If your "want list" is a blank you can search only for blank
records (for that field) and print out when you are off to the stamp bourse.

For data entry you can fill down sequentially, or CTRL " to copy the above cell
which is good for entering a set, without a lot of manual input.

MSWorks should be available for around $10 on ebay Vers 4.5a is the best.




"Bill Sharpe"
My first stamp inventory program was a Lotus 123 spreadsheet with 3 columns headed Scott, Mint, Used.
The first column held the Scott number, the second and third had x's
if I owned the stamp and blanks if I didn't.
It's very easy to put a list of numbers in column A automatically.
OpenOffice.org's Calc is a great free spreadsheet program. It's a
pretty big download, though.

Bill


I have a general collection to 1990 with big gaps after 1970 so that wouldn't work. Too many countries. Too many big
files with many unused lines. I could use it for my US though, which is by far my country with the most stamps.

Thanks for the idea. Spreadsheets had crossed my mind but just for numbers I have - but after trying it I found entry
to my raw data files is much faster. Your system would be great though for a more specialized collection.

Ken



My simple Lotus spreadsheet worked fine with my US stamps back in 1985 -- there were only about 2000 Scott numbers
then. You could also easily delete the rows for stamps you don't have. You could use the approach for multiple
countries by adding worksheets for each additional one.

Of course, with your approach if you own the whole set of Presidential issues it's much easier to type in 803-834 than
it is to make an entry for each stamp.

Bill