Aa

"Alfa"

23/01/2005 7:46 PM

Workshop inventory

I would like to compile an inventory of everything in my workshop and would
like to know if somebody, perhaps, has such a list on Excel or other
electronic format which I could copy.

Once I started with this process I realized just how long it is going to
take and is now looking for a quick solution.

Any other advice would also be appreciated.

Thanks


Anton


This topic has 12 replies

GO

"Greg O"

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 2:18 PM


"Dave W" <[email protected]> wrote in message
news:[email protected]...
> I made a shop inventory on the advise of the insurance man. I had guessed
> the ballpark total value of all tools in the shop. I made 100 photographs
> that included everything, down to drill sets, screwdriver bits ets. Next,
I
> made a list in Excel of everything in each photo and included a rough
> replacement cost for each item. Amazing how those little things add up.
My
> initial estimate was low by half!
> Dave
>

No kidding! I inventoried my tools a few years ago. I had over $10,000 in
non-powered hand tools! Then add to it all the tailed tools! I need to get
out and revise it as the collection has increased considerably.
Greg

Kc

Keith

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 3:57 PM

The pictures are a good idea. I hope the list can be password protected so my
wife doesn't add it up one day.(:>)

John Carlson <[email protected]> wrote:

>Something that you can do quickly is take a photo inventory.
>
>It's not as detailed or precise as a written inventory, but it's quick
>to do, and as thorough as you choose to make it (e.g., open cabinets
>and drawers to photograph their contents.)
>
>In the long run you'll probably want a written list, but this will get
>you started and it will provide evidence of what you own in case you
>ever need it for insurance reasons.
>
>On Sun, 23 Jan 2005 19:46:26 +0200, "Alfa" <[email protected]>
>wrote:
>
>>I would like to compile an inventory of everything in my workshop and would
>>like to know if somebody, perhaps, has such a list on Excel or other
>>electronic format which I could copy.
>>
>>Once I started with this process I realized just how long it is going to
>>take and is now looking for a quick solution.
>>
>>Any other advice would also be appreciated.
>>
>>Thanks
>>
>>
>>Anton
>>
>
>
>Published e-mail address is for spam collection only.
>If e-mailing me, use jc631 at optonline dot net
>
>-- jc

Sk

"Swingman"

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 1:20 PM

"Edwin Pawlowski" wrote in message

> column. I made mine in about five minutes. I also had a total for my
> entire purchases. Ouch!

Ditto. I also have a column for model number for those times I've needed to
order parts from the internet or by phone and didn't have immediate access
to the tool.

Tool purchases do add up ...

--
www.e-woodshop.net
Last update: 11/06/04

EP

"Edwin Pawlowski"

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 6:35 PM


"Alfa" <[email protected]> wrote in message
news:[email protected]...
>I would like to compile an inventory of everything in my workshop and would
>like to know if somebody, perhaps, has such a list on Excel or other
>electronic format which I could copy.
>
> Once I started with this process I realized just how long it is going to
> take and is now looking for a quick solution.
>
> Any other advice would also be appreciated.

What exactly do you need that is time consuming.

Just make column headings for things like:
Item
Date Purchased
Cost
Bought from
Serial number

If you want to make notations such as warranty time just make another
column. I made mine in about five minutes. I also had a total for my
entire purchases. Ouch!

Da

DIYGUY

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 1:51 PM

Look for an Excel s/s that I sent you. It is a continuing work in
progress and everyday I find something I left out ...

Alfa wrote:

> I would like to compile an inventory of everything in my workshop and would
> like to know if somebody, perhaps, has such a list on Excel or other
> electronic format which I could copy.
>
> Once I started with this process I realized just how long it is going to
> take and is now looking for a quick solution.
>
> Any other advice would also be appreciated.
>
> Thanks
>
>
> Anton
>
>

RV

"Rob V"

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 7:22 PM

What I did when I moved to my new shop was use this program called "Every
thing I own".
I recorded what it was the model, serial number then snapped a pic of it as
well.

Took a bit of time to do but worth its weight in gold in something were to
ever happen to the shop.


"Alfa" <[email protected]> wrote in message
news:[email protected]...
>I would like to compile an inventory of everything in my workshop and would
>like to know if somebody, perhaps, has such a list on Excel or other
>electronic format which I could copy.
>
> Once I started with this process I realized just how long it is going to
> take and is now looking for a quick solution.
>
> Any other advice would also be appreciated.
>
> Thanks
>
>
> Anton
>

Pg

Patriarch

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 6:33 PM

"Edwin Pawlowski" <[email protected]> wrote in
news:[email protected]:
<snip>
> If you want to make notations such as warranty time just make another
> column. I made mine in about five minutes. I also had a total for my
> entire purchases. Ouch!
>

The dollar value of just my handplanes I added up the other day scared me!

Patriarch

DW

"Dave W"

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 2:34 PM

I made a shop inventory on the advise of the insurance man. I had guessed
the ballpark total value of all tools in the shop. I made 100 photographs
that included everything, down to drill sets, screwdriver bits ets. Next, I
made a list in Excel of everything in each photo and included a rough
replacement cost for each item. Amazing how those little things add up. My
initial estimate was low by half!
Dave
"Rob V" <[email protected]> wrote in message
news:[email protected]...
> What I did when I moved to my new shop was use this program called "Every
> thing I own".
> I recorded what it was the model, serial number then snapped a pic of it
> as well.
>
> Took a bit of time to do but worth its weight in gold in something were to
> ever happen to the shop.
>
>
> "Alfa" <[email protected]> wrote in message
> news:[email protected]...
>>I would like to compile an inventory of everything in my workshop and
>>would like to know if somebody, perhaps, has such a list on Excel or other
>>electronic format which I could copy.
>>
>> Once I started with this process I realized just how long it is going to
>> take and is now looking for a quick solution.
>>
>> Any other advice would also be appreciated.
>>
>> Thanks
>>
>>
>> Anton
>>
>
>

NN

No-One

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 9:46 AM

Go to Microsoft & look at their templates:
http://office.microsoft.com/en-us/templates/default.aspx

or this page:
http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=inventory


JJS
Alfa wrote:
> I would like to compile an inventory of everything in my workshop and would
> like to know if somebody, perhaps, has such a list on Excel or other
> electronic format which I could copy.
>
> Once I started with this process I realized just how long it is going to
> take and is now looking for a quick solution.
>
> Any other advice would also be appreciated.
>
> Thanks
>
>
> Anton
>
>

Jj

Jody

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 7:47 PM

Jody wrote:
> There were several programs I found back in the mid to late 90's that I
> used a lot. One was a shop inventory program. You could list all your
> tools, model, serial, cost. I was amazed by how much money I had in
> tools when I used it. I'll look around in my archives and if I find it
> I'll post it to the wood binaries group or a web page.

Well I found it. It was The EasyShop Tool Journal. It's 1.6M and was
shareware. The company is no longer around. The program can be found:
http://www.inthewoodshop.org/software/p3u7p3.zip

JC

John Carlson

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 3:40 PM

Something that you can do quickly is take a photo inventory.

It's not as detailed or precise as a written inventory, but it's quick
to do, and as thorough as you choose to make it (e.g., open cabinets
and drawers to photograph their contents.)

In the long run you'll probably want a written list, but this will get
you started and it will provide evidence of what you own in case you
ever need it for insurance reasons.

On Sun, 23 Jan 2005 19:46:26 +0200, "Alfa" <[email protected]>
wrote:

>I would like to compile an inventory of everything in my workshop and would
>like to know if somebody, perhaps, has such a list on Excel or other
>electronic format which I could copy.
>
>Once I started with this process I realized just how long it is going to
>take and is now looking for a quick solution.
>
>Any other advice would also be appreciated.
>
>Thanks
>
>
>Anton
>


Published e-mail address is for spam collection only.
If e-mailing me, use jc631 at optonline dot net

-- jc

Jj

Jody

in reply to "Alfa" on 23/01/2005 7:46 PM

23/01/2005 7:38 PM

Alfa wrote:
> I would like to compile an inventory of everything in my workshop and would
> like to know if somebody, perhaps, has such a list on Excel or other
> electronic format which I could copy.
>
> Once I started with this process I realized just how long it is going to
> take and is now looking for a quick solution.
>
> Any other advice would also be appreciated.
>
> Thanks
>
>
> Anton
>
>
There were several programs I found back in the mid to late 90's that I
used a lot. One was a shop inventory program. You could list all your
tools, model, serial, cost. I was amazed by how much money I had in
tools when I used it. I'll look around in my archives and if I find it
I'll post it to the wood binaries group or a web page.


You’ve reached the end of replies