Inventory / Asset Register

[nephilim]

I present to you the asset register I spent a few days working on

Automatically adjusts dates based on when something was bought and how long is left in renewal cycle (based on a renewal cycle of 1 - 7 years depending on object)
Automatically calculates monthly and yearly depreciation based on starting value and the estimated value you assign at the end of the renewal cycle

Has 5 "Conditions" - New, Good, Aging, Old, Must Replace
Has 4 "Status" - In Use, Scrapped, Spares and Repairs, To Be Scrapped
Has 61 "Vendors" - Acer, HP, IBM, Toshiba etc
Has "Conditional Filter" - Narrows down items by Brand, Model, Date etc

It is based on Excel 2010 so you must have the compatibility pack and is located in the link below

Nephilim's Edugeek Sky Drive Folder

[nephilim]

Oh and there is a sample string in there at the minute!

[Little-Miss]

Ooooooooooo........

[nephilim]

Let me know if anything should be added

[nephilim]

As above, let me know if anything is missing please

*edit*

I know that some of you use SIMS or your MIS, so don't worry if you are one of those

[JoeBloggs]

Looks good!

[nephilim]

One thing I am looking at doing is auto filling in the expected depreciation value based on how many years the item is used. I have a rough formula for it so will add it in and see how it works

[nephilim]

Updated so that the expected value at end of period is automatically adjusted

Did that just for you @Little-Miss as you said you can't do math type stuff.

Use the same link as the first post as it is just the updated version of the spreadsheet

[Ryan233]

Old thread but i would be very interested for a copy to have a look at. can anyone forward me copy?

PM me please!

[nephilim]

Download it from the link in the post...it still works so its all good

[SYNACK]

Just looking at the brands and had a chuckle, 'SGI' thats dedication to list completeness right there

[nephilim]

you'd be surprised at what kit floats about in schools....i took the time to ask a few places for the most obscure brand they have in their schools.

[andyturpie]

Just to say we have just introduced the spreadsheet at the school and last week we recieved our first financial audit as an academy. The auditors were shown our processes and procedures and were very impressed with the spreadsheet functionality.

@nephilim - Thanks for sharing this, it ticks all the boxes and then more

[nephilim]

Many thanks Andyturpie Glad it has met your academies seal of approval!