I use the bin & boxes system. Bins separated by part type and a smaller box to collect all the parts that are going on a particular bike. Tires, tubes and rims all get their own seperate rod hanging from the rafters.

If I had to start entering them in a spreadsheet it would take away a lot of the fun.