+ Post New Thread
Results 1 to 14 of 14
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 ...
  1. #1

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400

    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

  2. 3 Thanks to nephilim:

    jcs808 (24th November 2011), newpersn (16th May 2012), simpsonj (13th October 2011)

  3. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    Oh and there is a sample string in there at the minute!

  4. #3

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    London
    Posts
    5,508
    Thank Post
    2,371
    Thanked 741 Times in 454 Posts
    Blog Entries
    2
    Rep Power
    541
    Ooooooooooo........

  5. #4

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    Let me know if anything should be added

  6. #5

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    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

  7. #6
    JoeBloggs's Avatar
    Join Date
    Jun 2010
    Location
    Leeds
    Posts
    544
    Thank Post
    160
    Thanked 75 Times in 52 Posts
    Rep Power
    35
    Looks good!

  8. #7

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    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

  9. #8

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    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

  10. Thanks to nephilim from:

    Little-Miss (13th October 2011)

  11. #9

    Join Date
    Apr 2012
    Posts
    97
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    5
    Old thread but i would be very interested for a copy to have a look at. can anyone forward me copy?

    PM me please!

  12. #10

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    Download it from the link in the post...it still works so its all good

  13. #11

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    Just looking at the brands and had a chuckle, 'SGI' thats dedication to list completeness right there

  14. Thanks to SYNACK from:

    mac_shinobi (21st May 2012)

  15. #12

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    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.

  16. #13

    Join Date
    Jun 2009
    Location
    Watford
    Posts
    876
    Thank Post
    381
    Thanked 113 Times in 73 Posts
    Rep Power
    62
    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

  17. Thanks to andyturpie from:

    nephilim (24th May 2012)

  18. #14

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,668
    Thank Post
    1,614
    Thanked 1,867 Times in 1,385 Posts
    Blog Entries
    2
    Rep Power
    400
    Many thanks Andyturpie Glad it has met your academies seal of approval!

  19. Thanks to nephilim from:

    andyturpie (28th May 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. Asset management software from Becta?
    By Stuart in forum School ICT Policies
    Replies: 8
    Last Post: 11th April 2014, 08:41 AM
  2. Asset and Inventory Management
    By Soulfish in forum How do you do....it?
    Replies: 33
    Last Post: 23rd February 2012, 06:24 PM
  3. OCS Inventory
    By Geoff in forum Downloads
    Replies: 5
    Last Post: 3rd June 2011, 08:40 AM
  4. IT asset register
    By itgeek in forum Wireless Networks
    Replies: 6
    Last Post: 18th December 2010, 02:37 PM
  5. physical inventory of assets
    By LCPSWolf in forum How do you do....it?
    Replies: 3
    Last Post: 18th March 2009, 09:32 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •