Luke, I don't know how you are determining each item's depreciation rate, but there's a few things that determine it which would impact on the design of your spreadsheet.
1.
depreciation is worked out by the formula
Decline in Value = Base Value * Days Held / 365 * 150% / Effective Life
for...