+ 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
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448

    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. IDG Tech News

  4. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    Oh and there is a sample string in there at the minute!

  5. #3

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    Birmingham
    Posts
    3,841
    Blog Entries
    2
    Thank Post
    1,682
    Thanked 307 Times in 222 Posts
    Rep Power
    244
    Ooooooooooo........

  6. #4

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    Let me know if anything should be added

  7. #5

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    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

  8. #6
    JoeBloggs's Avatar
    Join Date
    Jun 2010
    Location
    Leeds
    Posts
    474
    Thank Post
    108
    Thanked 70 Times in 48 Posts
    Rep Power
    28
    Looks good!

  9. #7

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    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

  10. #8

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    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

  11. Thanks to nephilim from:

    Little-Miss (13th October 2011)

  12. #9

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

    PM me please!

  13. #10

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    Download it from the link in the post...it still works so its all good

  14. #11

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    7,558
    Blog Entries
    9
    Thank Post
    444
    Thanked 1,910 Times in 1,624 Posts
    Rep Power
    458
    Just looking at the brands and had a chuckle, 'SGI' thats dedication to list completeness right there

  15. Thanks to SYNACK from:

    mac_shinobi (21st May 2012)

  16. #12

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    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.

  17. #13

    Join Date
    Jun 2009
    Location
    Watford
    Posts
    552
    Thank Post
    174
    Thanked 38 Times in 36 Posts
    Rep Power
    30
    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

  18. Thanks to andyturpie from:

    nephilim (24th May 2012)

  19. #14

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Bedfordshire
    Posts
    7,362
    Blog Entries
    2
    Thank Post
    921
    Thanked 1,034 Times in 791 Posts
    Rep Power
    448
    Many thanks Andyturpie Glad it has met your academies seal of approval!

  20. Thanks to nephilim from:

    andyturpie (Today)

SHARE:
+ Post New Thread

Similar Threads

  1. Asset and Inventory Management
    By Soulfish in forum How do you do....it?
    Replies: 33
    Last Post: 23rd February 2012, 07:24 PM
  2. OCS Inventory
    By Geoff in forum Downloads
    Replies: 5
    Last Post: 3rd June 2011, 08:40 AM
  3. IT asset register
    By itgeek in forum Networks
    Replies: 6
    Last Post: 18th December 2010, 03:37 PM
  4. physical inventory of assets
    By LCPSWolf in forum How do you do....it?
    Replies: 3
    Last Post: 18th March 2009, 10:32 AM
  5. Asset management software from Becta?
    By Stuart in forum School ICT Policies
    Replies: 6
    Last Post: 22nd July 2005, 05:50 PM

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
  •