digital data base for collectors (1 Viewer)

[hsm]

Hello all,
anyone know of or have a program that a collector could use to track and and record collections? Although it would be generally easy to track going forward, has anyone ever built something like this? Im not going to lie, a ledger book is cool and fun too, but an excell spread sheet with pics must have been doen by someone at sometime.
Any thoughts on the subject?
G

 

[BobZ]

Hello all,
anyone know of or have a program that a collector could use to track and and record collections? Although it would be generally easy to track going forward, has anyone ever built something like this? Im not going to lie, a ledger book is cool and fun too, but an excell spread sheet with pics must have been doen by someone at sometime.
Any thoughts on the subject?
G

I use an Excel spreadsheet. It has columns for the bin # where the empty box is stored, manufacturer, item number, item name, cost, # of figures in the set, and a link to a photo of the item, which I store on my laptop. That way I can sort it as needed. From time to time I total up the costs and the # of figures, then delete it before my wife sees it!

 

[hsm]

that sounds great. can you Pm a screen shot? Have you ever considered adding photos to help with getting figures back to boxes? do you mark the bottom of your figures with the box or item number? Do you hve somehting you can toake to shows in cse you need to double check if you already have something or not?

Thanks For replying

GL

 

[Arnhemjim]

Hello hsm aka GL,
Have tried to post this reply at least a half dozen times. Frustrated by both my own apparent lack of computer skills, and the forum's various protocols/idiosyncrasies, unsuccessfully. Also use Excel. Cells left to right as follows. Obviously use more, less or different. Mine were chosen, as core collection is W. Britains Ltd.
[FONT=&quot]-SET NO:[/FONT]
[FONT=&quot]-ACQ DATE:[/FONT]
[FONT=&quot]-ACQ PRICE:[/FONT]
[FONT=&quot]-CURRENT EST
VALUE:[/FONT]
[FONT=&quot]-REVISED PRICE RANGE 2008-2009 AUCTIONS[/FONT]
[FONT=&quot]-CROSS REF
SET NO:[/FONT]
[FONT=&quot]-EST
-MANUFACTURE
DATE:[/FONT]
[FONT=&quot]-J OPIE
RARITY INDEX:[/FONT]
[FONT=&quot]-SPAN OF
MANUFACTURE:[/FONT]
[FONT=&quot]-SET TITLE:[/FONT]
[FONT=&quot]-NO OF
PIECES:[/FONT]
[FONT=&quot]-MANUFACTURER OTHER
THAN W BRITAINS:[/FONT]
[FONT=&quot]-BOX CONDITION
AND LABEL TYPE:[/FONT]
[FONT=&quot]-OVERALL CONDITION; G VG M:[/FONT]
[FONT=&quot]-DETAILED CONDITION; FIG MISSING BROKEN RETOUCH PERCENT ETC:[/FONT]
[FONT=&quot]-REGIMENTS
OF ALL NATIONS
-WALLIS PAGE NO:[/FONT]
[FONT=&quot]-ARMIES OF THE
-WORLD WALLIS PAGE NO:[/FONT]
[FONT=&quot]COLLECTORS GUIDE TO BRITAINS MODEL SOLDIERS RUDDLE PAGE NO:[/FONT]
[FONT=&quot]OTHER REFERENCES:

[/FONT]

SET NO:	ACQ DATE:	ACQ PRICE:	CURRENT EST VALUE:	REVISED PRICE RANGE 2008-2009 AUCTIONS	CROSS REF SET NO:	EST MANUFACTURE DATE:	J OPIE RARITY INDEX:	SPAN OF MANUFACTURE:	SET TITLE:
2	1953	$2.00	$300.00	$160.00	9209, 53, 2081	1953	23	1953-1966	ROYAL HORSE GUARDS (THE BLUES), OFFICER AND TROOPERS MOUNTED AT THE WALK, FULL STATE DRESS
11	1948	$2.00	$135.00		9135, 2036, 2126	1948	27	1946-1966	BLACK WATCH (42ND ROYAL HIGHLAND REGIMENT), CHARGING WITH PIPER
17	1989	$120.00	$130.00	$118.00	9143	1961	20	1952-1966	SOMERSET LIGHT INFANTRY (PRINCE ALBERT'S), STANDING AND KNEELING ON GUARD, WITH OFFICER
24	1986	$130.00	$225.00	$153.40	9216, 9345	1959	28	1954-1966	NINTH QUEEN'S ROYAL LANCERS, MOUNTED AT THE HALT, SLUNG LANCES, WITH OFFICER
28	1952	$4.50	$560.00	$354.00	9420	1952	33	1952-1965	MOUNTAIN GUN OF THE ROYAL ARTILLERY, WITH DETACHMENT, OFFICER AND MULES
30	1949	$2.00	$350.00	$94.40	9137	1949	35	1946-1965	DRUM AND BUGLES OF THE LINE
32	1949	$2.00	$275.00	$240.00	9210	1949	27	1946-1966	ROYAL SCOTS GREYS (2ND DRAGOONS), MOUNTED AT THE WALK, WITH OFFICER
33	1949	$2.00	$350.00	$212.40	NONE	1949	36	1946-1952	SIXTEENTH AND FIFTH LANCERS, MOUNTED AT ATTENTION WITH LANCES, WITH OFFICER
35	1951	$2.00	$325.00	$240.00	9140, 1284	1951	32	1946-1964	ROYAL MARINES, MARCHING AT SLOPE ARMS, WITH OFFICER
39	1950	$6.00	$725.00	$284.00	9419	1950	45	1948-1965	KING'S TROOP, ROYAL HORSE ARTILLERY WITH GUN, LIMBER, TEAM AND ESCORT GALLOPING
44	1949	$2.00	$375.00	$324.50	NONE	1949	41	1946-1952	QUEEN'S BAYS (2ND DRAGOON GUARDS), GALLOPING WITH LANCES, WITH TRUMPETER
47	1950	$2.00	$275.00	$153.40	9261	1950	28	1946-1966	SKINNER'S HORSE (1ST DUKE OF YORK'S OWN CAVALRY), REVIEW ORDER WITH LANCES, GALLOPING WITH TRUMPETER (1ST BENGAL LANCERS)
48	1983	$125.00	$500.00	$188.80	9265	1960	30	1957-1966	EGYPTIAN CAMEL CORPS

Best regards,
Arnhemjim
Arizona Territory

 

[BobZ]

that sounds great. can you Pm a screen shot? Have you ever considered adding photos to help with getting figures back to boxes? do you mark the bottom of your figures with the box or item number? Do you hve somehting you can toake to shows in cse you need to double check if you already have something or not?

Thanks For replying

GL

Here's a screen shot. The Photo column has a cross-reference link to a photo of the figure, which is stored in the same folder as the spreadsheet. Clicking it displays the photo. I'm not perfect at keeping this up and forget from time to time to add a figure.

Adding a label to the base would have been a great idea, but there's too many to start now. Wish I'd thought of it then.

I store the spreadsheet in my Google drive, so if I need to check on a figure at a show I can look it up on my phone.

Take care.

 

[paxtoysoldier]

Good thread. A reason to visit the Forum.
Paddy

 

[marco55]

There was a Canadian forum years ago that started a collection program but the forum shut down not long after they started it.
Mark

 

[The Military Workshop]

There was a Canadian forum years ago that started a collection program but the forum shut down not long after they started it.
Mark

Fond memories !

 

[marco55]

Fond memories !

Yes I remember you on it discussing things with Harry.^&grin
Mark

 

[jazzeum]

I use a word file that lists the range, number and item.

I have several docs, one for K & C and other makers.

 

[hsm]

excellent all and thanks for sharing!