School ICT Policies Thread, Inventory / Asset Register in School Administration; I present to you the asset register I spent a few days working on
Automatically adjusts dates based on when ...
12th October 2011, 08:16 PM #1
Inventory / Asset Register
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
3 Thanks to nephilim:
jcs808 (24th November 2011), newpersn (16th May 2012), simpsonj (13th October 2011)
IDG Tech News
12th October 2011, 08:26 PM #2
Oh and there is a sample string in there at the minute!
12th October 2011, 08:27 PM #3
12th October 2011, 08:58 PM #4
Let me know if anything should be added
13th October 2011, 10:44 AM #5
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
13th October 2011, 10:57 AM #6
13th October 2011, 11:03 AM #7
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
13th October 2011, 11:33 AM #8
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
Thanks to nephilim from:
Little-Miss (13th October 2011)
16th May 2012, 12:37 PM #9
- Rep Power
Old thread but i would be very interested for a copy to have a look at. can anyone forward me copy?
PM me please!
20th May 2012, 02:11 PM #10
Download it from the link in the post...it still works so its all good
20th May 2012, 09:29 PM #11
Just looking at the brands and had a chuckle, 'SGI' thats dedication to list completeness right there
Thanks to SYNACK from:
mac_shinobi (21st May 2012)
21st May 2012, 05:58 AM #12
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.
24th May 2012, 10:42 AM #13
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
Thanks to andyturpie from:
24th May 2012, 04:22 PM #14
Many thanks Andyturpie Glad it has met your academies seal of approval!
Thanks to nephilim from:
andyturpie (28th May 2012)
By Stuart in forum School ICT Policies
Last Post: 1st June 2013, 01:24 AM
By Soulfish in forum How do you do....it?
Last Post: 23rd February 2012, 07:24 PM
By Geoff in forum Downloads
Last Post: 3rd June 2011, 09:40 AM
By itgeek in forum Wireless Networks
Last Post: 18th December 2010, 03:37 PM
By LCPSWolf in forum How do you do....it?
Last Post: 18th March 2009, 10:32 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)