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
Oh and there is a sample string in there at the minute!
Let me know if anything should be added
As above, let me know if anything is missing please
I know that some of you use SIMS or your MIS, so don't worry if you are one of those
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
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
Little-Miss (13th October 2011)
Old thread but i would be very interested for a copy to have a look at. can anyone forward me copy?
PM me please!
Download it from the link in the post...it still works so its all good
Just looking at the brands and had a chuckle, 'SGI' thats dedication to list completeness right there
mac_shinobi (21st May 2012)
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.
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 (24th May 2012)
Many thanks Andyturpie Glad it has met your academies seal of approval!
andyturpie (28th May 2012)
There are currently 1 users browsing this thread. (0 members and 1 guests)