View Poll Results: How does your department track assets

Voters
12. You may not vote on this poll
  • Online Database

    1 8.33%
  • Excel Spreadsheet

    3 25.00%
  • Pencil and Paper

    5 41.67%
  • We don't bother with it.

    3 25.00%
  1. #1
    Forum Member

    Join Date
    Sep 2010
    Posts
    1

    Post Databases and Spreadsheets for Vol FDs

    Having just retired from the military and joining a local volunteer FD I have discovered a lack of accountability and maintenance for equipment and personnel.

    I have several spreadsheets and databases that I used to manage my Soldiers records for things such as Name, Address Info, Physicals, Training, and Equipment Assigned. I also used a database to log all gear they were assigned including serial numbers, who it was assigned to, maintenance schedules, etc.

    Currently, our department has no accountability even for radios that were given out. We have people in our community that have had radios for several years but have never made a run in the same amount of time. We also have gear that is well over fifteen years old but is still in service.

    In this tight economic times I am 100% for accountability. Not only does it make a department more efficient it also makes it safer.

    I guess what I am asking the community is, "What do you guys use." Remember we are a small vol department in rural Ohio so we have zero funds to invest in this. I am really hoping that someone out there has something we can use. Thanks and I look forward to your input.

  2. #2
    Forum Member
    HuntPA's Avatar
    Join Date
    May 2010
    Location
    Northwest PA
    Posts
    503

    Default

    I don't know if you ever created a database for this, but if you did, I would be very interested in seeing it. I am trying to build one, but as this is my first foray into Access, any assistance would be greatly appreciated.

  3. #3
    Forum Member
    DeputyMarshal's Avatar
    Join Date
    Apr 2005
    Location
    Connecticut, USA
    Posts
    2,638

    Default

    Quote Originally Posted by HuntPA View Post
    I don't know if you ever created a database for this, but if you did, I would be very interested in seeing it. I am trying to build one, but as this is my first foray into Access, any assistance would be greatly appreciated.
    FWIW, spend a lot of time designing your database before you start trying to build it. A well designed database is a real timesaver. A badly designed database will just create nightmares. (Random thought: don't get bogged down in asset tags but do come up with a good system for uniquely identifying durable assets. Settle on a naming/numbering system that works for you and can be expanded as you come up with new classes of asset.)

    Think hierarchies of assets and set realistic goals about how granular you really want to make your asset tracking. (This applies to tracking things like training as well, BTW.) Don't forget that some assets will also want to be attached to (multiple) maintenance records.

    All the time you spend up front designing your database and really determining what you want it to do will pay off in the end. Part of the process should be in determining what reports you want to get out of your database and making sure all the information needed to generate them is present in the system

    Good luck!
    "Nemo Plus Voluptatis Quam Nos Habant"

    The Code is more what you'd call "guidelines" than actual rules.

  4. #4
    Forum Member
    Picc.93Truck's Avatar
    Join Date
    May 2010
    Posts
    207

    Default

    Has anything been made of this?
    Firefighter 1/ PA EMT-B

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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

Log in

Click here to log in or register