I’ve seen several posts on other blogs lately about inventory and tracking of projects. I thought I’d share how I handle it. I’m on a Mac and use Bento (a small database program that is no longer sold by Apple, unfortunately). But these first screen shots can be duplicated with Tables in any Word Processing program or in a Spreadsheet program.
This first screen shot shows the top of my list. These are projects that I want to work on this year – there are always more projects than I can realistically handle in a year, but it gives me options and choices. The 4th column always shows where that project is – started, being designed, or ready to start. Ready to start means it has been kitted up and ready to be stitched. You can see that I have 29 projects to work on this year. This part keeps growing throughout the year as I design more things myself.
There is a blank row that has Temp in the 4th column. This makes sorting my list easy – keeping current projects above the rest of the list. Z- projects are in my stash in various stages of readiness – projects to do in the future. They start with Z so they will fall below current projects since everything is listed alphabetically. You should be able to do this in the other programs mentioned above as well.
This is at the bottom of the list. I started this database in 2009 and the list is now at 177 rows, 82 of which are completed projects. Column 5 shows the completion date for each project and I also have a space for a photo of the finished project. I can easily add or delete projects right on this list page. I always sort the list by the 5th column – Completed. Any project that is not completed will automatically appear at the top of the list, like the screen shot at the top of the post.
Bento has an additional screen for each project where you can add lots of additional information, if you wish. I designed this database page myself.
I haven’t used the Notes section as much as I intended. I thought it would be good to list the cost of supplies, etc. But I haven’t done that yet. The photo is the completeld project, but I will replace it with a new photo when this has been made into a stocking.
I have other “libraries” in Bento as well. There is one for each thread brand, fabric (not a complete inventory yet), books, etc. I’m very good about updating the projects library, but never seem to be able to keep up with the threads. I’m also creating one for stitches with how each stitch can be used and I’m creating stitch diagrams for them as well. Wish I had more time in the day for all these things.
I’ve always liked to be organized, but as I get older I seem to lose a little of that skill. I wish I had every one of the databases up to date, but I feel it’s a losing game. Hope this gives you ideas of what you can also do to get organized.