Previous 1 2 Next 15 Replies Latest reply: Jun 17, 2008 3:14 PM by Eric Dalzell
John Butt Level 1 Level 1 (80 points)
Have been looking for a home inventory template to replace my old Apple Works data base inventory. Cannot find one searching these discussions or elsewhere. Anyone have one?? Would like one for Numbers that would accomodate photo. Can design one but someone must already have done a nice one!! John

G5 2dual and Powerbook G3 Series, Mac OS X (10.4.11), Mac OS X 10.2.8 on Powerbook
  • Peggy Level 8 Level 8 (38,480 points)
    I looked for a template at iWork Community & didn't find one. I'm sure you could try a Google search for "home inventory spreadsheet" & find some made for Excel that would open in Numbers.

    But, I did a little searching of my hard drives & found one someone had made for AppleWorks (probably AppleWorks 5, but it could have been an earlier ClarisWorks file ). I converted it to AppleWorks 6 & then opened it in Numbers. I have saved it as a template & placed it on my iDisk for anyone to download. It is a .zip file named inventory.nmbtemplate.zip. Click the little arrow to the right of the file to download it.

  • John Butt Level 1 Level 1 (80 points)
    Thanks Peggy. Appreciate your help. Trying to find a clever way to add photos without making cells/rows so large the spreadsheet becomes unweildy. Actually Apple Works data base is still my favorite. John
  • John Hendy Level 1 Level 1 (105 points)
    John,

    You might try thinking outside your original box. While Numbers might give you a decent fix, you also might try a different program designed for just your project. I searched in the Apple Downloads for 'Inventory' and found a program called 'Home Inventory' (too easy, right?). Check it out here: http://binaryformations.com/

    Some features:
    --Nice user interface
    --Categorization by type, location, etc.
    --Nearly unlimited photos can be associated with your items
    --Ability to create detailed reports for your records
    --Shareware: only $22 (try before you buy and record 25 items with trial)

    I realize Numbers is a great program for many tasks, but I think that from the looks of it, this program will do a better job at your specific task.

    If you really wanted to pursue the Numbers solution, you could go about your inventory using a Numbers table and then list the location of each photo (/Photos/Home Inventory/12345.jpg) in a separate column. That way, you have all the functionality of a sortable, searchable table with the convenience of the photos somewhere else (non-bogged-down file as you desire). Perhaps you could print your photos in a thumbnail view where the names are listed; combine the smaller pictures with your table and you now have an all-in-one record of your possessions. Backup both for security and you should be good to go. If you ever need an item photo, just find the corresponding photo name for the item on your chart and then easily find it in your Home Inventory photo folder.

    Just my thoughts. Hope they help!



    -John
  • jaxjason Level 4 Level 4 (3,460 points)
    have you looked at Bento yet? Very simple Database for about $49 I think. ($99 for the family pack of 5 licenses)

    [http://www.filemaker.com/products/bento]

    I know its good for basic inventory, and can store photos as well.

    I just moved a friends recipe database over to it and was fairly impressed for a DB for beginners.

    Jason
  • Level 8 Level 8 (41,780 points)
    Hello

    I just moved a friends recipe database over to it and was fairly impressed for a DB for beginners.


    For beginners or for Dummies ?

    Yvan KOENIG (from FRANCE jeudi 15 mai 2008 19:18:32)
  • jaxjason Level 4 Level 4 (3,460 points)
    for both. It does support queries in its own way, basic form creation, data entry, very simplified joins between 'tables', etc...

    For a home inventory where you really don't need complicated sql to work with the data, just basic search capabilities, its not too bad at all.

    For people like me who work sql and ms Access all day long, of course it seems very simple, but for $50US its pretty good (oh and they used CoreAnimation when switching views, really looked cool).

    Jason
  • Level 8 Level 8 (41,780 points)
    Hello

    I tested it when it was introduced.

    I feel that even compared to the old AW6's database modulus, it's a toy.

    Maybe I'm biased because I uses AW6-DB for years and know it quite well but don't understand how someone may store everything in the same box.

    About the cost, AppleWorks was available for less than 100$ and made much more.

    When I was informed that FileMaker was preparing a wide public DB tool, I was hoping for a single user FileMaker, not for this really stripped product.

    I'm really surprised when I read quite daily that Numbers is missing this or that and that Bento is a satisfying product. Of course, I'm old fashioned.

    Yvan KOENIG (from FRANCE jeudi 15 mai 2008 22:15:38)
  • John Butt Level 1 Level 1 (80 points)
    That is probably a good solution, but it has a price. Also want ease in storing it so others without the special progam can open. Have developed a spread sheet that will work ok. I will just use small pictures which can be expanded if the need arises. Thanks for your help. John
  • John Butt Level 1 Level 1 (80 points)
    Yes Bento looks like a replacement for Appleworks data base, but I am on Tiger and it requires Leopard. Thanks though for your suggestion. John
  • John Butt Level 1 Level 1 (80 points)
    Yes, I too am a Claris Works, Appleworks fan. The AW data base is still my favorite and does the inventory I want just right. But no one else is using it so I am trying to adapt to Numbers or Excel. Bento might be a good replacement too but costs and requires Leopard--I am still behind on Tiger.

    I can make Numbers work for what I want ok.

    John
  • John Butt Level 1 Level 1 (80 points)
    Thanks Peggy, I downloaded and also borrowed a couple your other items. Thanks for sharing. I made some modifications and have a Numbers ss inventory form now that will work for me. Still not as good as Appleworks Data base, but it is more shareable with others. Appreciate your help and sharing.
    John
  • jaxjason Level 4 Level 4 (3,460 points)
    Maybe I'm biased because I uses AW6-DB for years and know it quite well but don't understand how someone may store everything in the same box.


    yeah, me too (long DB history), but we are not the basic user that has never used a database before, relational to them has something to do with how they treat their wife, not how their inventory talks to their replacement cost table.

    Its for those people. Like my friend that has the recipe "database". Its really just two big tables, one that has the books listed and one that has her favorites listed. thats it.

    Jason
  • Peggy Level 8 Level 8 (38,480 points)
    Bento is not a viable replacement for AppleWorks' database. The moderator of the Bento forums has admitted the programmers never even looked at AppleWorks when developing Bento. It was developed for those who gave feedback to FileMaker that FileMaker was "over kill." Bento puts a "pretty face" on iCal & Address Book.

  • Level 8 Level 8 (41,780 points)
    Thanks Peggy.

    Glad to read that they recognize what I wrote from the beginning.

    Yvan KOENIG (from FRANCE vendredi 16 mai 2008 19:38:36)
Previous 1 2 Next