fml
**Member** 
Posts: 14
|
Post by fml on Feb 27, 2022 16:55:41 GMT
I’m in the USA and have collected USA and German stamps since the late 1950’s. I’ve been away from the hobby for quite a few years and am now looking for a way to use Excel to both track my current collections and also conveniently list stamps I’m trying to find. I’d like to avoid having to manually enter large amounts of stamp data into the spreadsheet and would appreciate suggestions on what to do. I’d be willing to pay a reasonable price for Excel sheets displaying key stamp data for both of these countries. I’m a retired engineer with a good working knowledge of Excel and am currently using Excel 2016 (32-bit version).
|
|
banknoteguy
Member 
Posts: 287
What I collect: 19th Century US, High denomination US (> $1), 19th century covers US, Indian Feudatory States and most recently I acquired a BigBlue [with about 5,000 stamps] and pristine pages.
|
Post by banknoteguy on Feb 27, 2022 17:16:22 GMT
Hello Ohio,
You might try this link:
It appears to have excel or google docs inventory lists for most countries including US.
|
|
fml
**Member**
Posts: 14
|
Post by fml on Feb 27, 2022 18:57:44 GMT
Found the US entry in his html file .... now to figure out if it helps me.... <GRIN>
Thank you
|
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110 
|
Post by brightonpete on Feb 27, 2022 19:24:30 GMT
Thanks banknoteguy for that link to the spreadsheet. I never knew it was there! It is far too much for my needs, but gave me idea's on how to adjust my own sheets!
Peter
|
|
hrdoktorx
Member
Posts: 6,616
What I collect: France (and French territories), Africa, Canada, USA, Germany, Guatemala, stamps about science, flags, maps, stamps on stamps...
|
Post by hrdoktorx on Feb 27, 2022 19:51:03 GMT
I have organized my wish lists as Excel spreadsheets too. One spreadsheet per dealer I buy from regularly. For each, the first few columns are a description of the stamp/lot (ordering number, country, catalog number, word description), then price and number of stamps in the lots. From there I give a ranking for the country (from 1 for most interesting to 6 for least interesting), another ranking for the theme of the stamps (again from 1 for my main collection themes to 6 for stamps of no thematic interest to me), and a price ranking (on a logarithmic scale, otherwise, it's not fair). I then combine these three rankings in a variety of ways to decide what I will buy next.
|
|
dorincard
Member
Posts: 1,453
What I collect: My focus is on Wild Mammals on maximum cards. Occasionally, I get or create maximum cards with other animals, or any other topic.
|
Post by dorincard on Feb 27, 2022 21:25:17 GMT
Welcome!
I'm sure you will...excel at organizing your collection.
Excelsior!
|
|
zipper
Member
Posts: 2,649
What I collect: Classic GB, QV, France Ceres/Napoleon, Classic U.S., Cinderella & Poster Stamps
|
Post by zipper on Feb 27, 2022 23:13:26 GMT
Hi
|
|
|
|
Post by iswscwebmaster on Feb 28, 2022 1:14:58 GMT
|
|
rex
Member
Posts: 1,153
|
Post by rex on Feb 28, 2022 9:03:51 GMT
 ...to ...TSF..... fml  ....Ludovico Italy
|
|
cjoprey
Member
Scanning stamps for my website...
Posts: 1,443
What I collect: Belgium (predominantly), British Commonwealth (older ones), WW (whatever comes my way...)
|
Post by cjoprey on Feb 28, 2022 10:58:19 GMT
Welcome from the UK fml - hope you find the information you need here! |
|
angore
Member
Posts: 5,360
What I collect: WW, focus on British Empire
|
Post by angore on Feb 28, 2022 11:29:42 GMT
Howdy!
|
|
Beryllium Guy
Moderator 
Posts: 5,661
What I collect: Worldwide Stamps 1840-1930
Member is Online
|
Post by Beryllium Guy on Feb 28, 2022 11:37:55 GMT
Welcome to TSF, fml ! I am originally from Ohio myself, Cleveland to be precise. Where in Ohio are you, if you don't mind my asking? We have several members on TSF who are currently in Ohio ( djcmh, fkarl, millersville, daveg28 come to mind, but there may be others) and some who came from Ohio originally, like myself or mikeclevenger. Anyway, enjoy your time with us.... -Chris ( Beryllium Guy)  |
|
darkormex
Member
Swinging through Switzerland and getting tied up in Thailand
Posts: 2,145
What I collect: The World...just printing and mounting as I go...call me crazy!
|
Post by darkormex on Feb 28, 2022 12:43:30 GMT
Welcome from your neighbor to the north here in Michigan.
|
|
fml
**Member**
Posts: 14
|
Post by fml on Feb 28, 2022 13:35:19 GMT
I have organized my wish lists as Excel spreadsheets too. One spreadsheet per dealer I buy from regularly. For each, the first few columns are a description of the stamp/lot (ordering number, country, catalog number, word description), then price and number of stamps in the lots. From there I give a ranking for the country (from 1 for most interesting to 6 for least interesting), another ranking for the theme of the stamps (again from 1 for my main collection themes to 6 for stamps of no thematic interest to me), and a price ranking (on a logarithmic scale, otherwise, it's not fair). I then combine these three rankings in a variety of ways to decide what I will buy next. Quite an elaborate approach ... Any chance you could upload a screen snap shot of one of your most used spreadsheets?
|
|
fml
**Member**
Posts: 14
|
Post by fml on Feb 28, 2022 13:46:05 GMT
Welcome! I'm sure you will...excel at organizing your collection. Excelsior! Time will tell. 
Have begun designing a spreadsheet tailored to my needs.
Working at some how including a thumbnail for each stamp in the spreadsheet.
|
|
fml
**Member**
Posts: 14
|
Post by fml on Feb 28, 2022 13:56:59 GMT
Welcome to TSF, fml ! I am originally from Ohio myself, Cleveland to be precise. Where in Ohio are you, if you don't mind my asking? We have several members on TSF who are currently in Ohio ( djcmh , fkarl , millersville , daveg28 come to mind, but there may be others) and some who came from Ohio originally, like myself or mikeclevenger . Anyway, enjoy your time with us.... -Chris ( Beryllium Guy )  I live near Mentor close to Lake Erie.
Nice to know about other collectors nearby.
|
|
Admin
Administrator 
Posts: 2,644
|
Post by Admin on Feb 28, 2022 15:07:16 GMT
Quite an elaborate approach ... Any chance you could upload a screen snap shot of one of your most used spreadsheets?
We've already got a thread on Excel spreadsheets. Let's move this discussion out of the intro thread and into a subject matter one. Either add on to the existing thread or start a new one. |
|
fml
**Member**
Posts: 14
|
Post by fml on Feb 28, 2022 16:57:50 GMT
Wasn't aware of the Excel Spreadsheet thread.... I'll move there with future Excel posts.
|
|
|
|
Post by dgdecker on Mar 3, 2022 17:43:07 GMT
Welcome to the Forum!
David
Ottawa, Canada
|
|
oregon1234
**Member**
Just sorting away over here...
Posts: 32
What I collect: Trying to focus just on Hong Kong. Wish me luck.
|
Post by oregon1234 on Mar 10, 2022 2:47:52 GMT
Welcome to the forum and if it works for you, the spreadsheets on Google Docs make it super convenient to be able to look things up on the go and from your phone, or access it from any computer anywhere. Happy collecting!
|
|
fml
**Member**
Posts: 14
|
Post by fml on Mar 10, 2022 14:50:00 GMT
Welcome to the forum and if it works for you, the spreadsheets on Google Docs make it super convenient to be able to look things up on the go and from your phone, or access it from any computer anywhere. Happy collecting! Hmm.... that's an approach I'd not considered.
Does Google Docs offer the ability to create a spreadsheet that allows an image (picture of a stamp) within one of its cells?
I ask because I'm in the process of creating just such an Excel file with Scott Numbers next to images of corresponding pictures of the stamps that I'm interested in.
|
|
swvl
Member
Posts: 525
What I collect: FDCs, plus some US modern and new issues. Topical interests include music, art, literature, baseball, space...
|
Post by swvl on Mar 10, 2022 14:59:40 GMT
Yes, Google Docs does allow you to place an image inside a spreadsheet cell!
|
|
crisger
Member
Artist and Digital Creations
Posts: 102
What I collect: Japan 1890s -2012
|
Post by crisger on Mar 10, 2022 20:49:02 GMT
Hi and welcome in ..i joined here after 45 years away from collecting and found this site just recently and it is a great place to share with many nice and knowledgable people!
there is another tracking system and site you may find interesting i will PM you the info.
Cheers
and welcome
Chris
|
|
...to ...TSF.....
....Ludovico
