Discussion: View Thread

  • 1.  Project Management Software

    Posted 08-13-2012 17:59
    Hi all,

    First time posting--my apologies for any poor etiquette that results!

    This message is aimed primarily at those who manage a group of consultants, especially a group of student consultants, but anyone with any thoughts on the issue is more than welcome to reply.

    At present, at UGA's Statistical Consulting Center (which operates on a fee-based system where clients pay per hour of consulting work beyond an initial consultation--see http://www.stat.uga.edu/consulting/consulting-fees for more information), we have had our graduate consultants record their hours through a paper-based system. That is, they write down the time they spend on a consulting project, preferably but not necessarily as they work, and at the end of the project they turn in the sheet. This can lead to problems, as it is sometimes difficult to remember to record hours (ask me how I know!), and it is hard to make a habit of it. Encouraging accurate reporting is especially important to our clients because we do charge for our time.

    I would like to move to a computer-based system for students to record their hours. Ideally, on each occasion on which a student works on a project, that student would be able to log in to the system, select from a list of his or her specific projects, record his or her hours (when and how many), classify those hours into one of several pre-chosen categories, make any additional notes about how that time was spent, and save the information. I would then ideally be able to summarize this information as I choose, by project, by consultant, etc., and/or be able to produce a spreadsheet I could then import into another program to work with.

    My question for the group is, what software have you encountered that could help with this type of project management? What software has proven useful, and what has not? Note that I am not looking for "time tracking" software, where the user basically runs a timer while he or she is working (this is what my current resources have turned up).

    I am definitely open to schemes that would accomplish the same end goal, even if they do not match my "ideal" as I have described above. At present, I do have a master sheet as a Google spreadsheet where I record time spent as well as other aspects of each project, and the consultants can view it, but it would not be practical to allow every consultant to be able to edit the sheet. I am hoping for something more foolproof, but also unified.

    I appreciate any assistance anyone is able to offer. Thank you!

    Kim

    -------------------------------------------
    Kimberly Love-Myers
    Associate Director, UGA SCC
    -------------------------------------------


  • 2.  RE:Project Management Software

    Posted 08-13-2012 18:33
    Hi Kimberly,

    What's the budget limitation for the software. Or must it be freeware. Also, there must be other software in use at the University for this sort of thing. Perhaps you can get added to the license.

    -------------------------------------------
    Patrick Spagon
    -------------------------------------------








  • 3.  RE:Project Management Software

    Posted 08-13-2012 19:10
    Hi Kimberly,

    Here at Wake we went the custom route of creating a web-based database. We have a front-end where investigators can enter projects and our staff can log hours and other info we like to track. The nice thing is that I can then just use SAS to generate any reports by linking to the database. Admittedly, given that my department's bread and butter is coordinating centers, we have people who have developed these types of systems several times over, so the time involved in creating it was probably negligible for us. I'm not sure how much effort it would take to develop from scratch. But, it does serve us nicely in terms of tracking hours for billing as well as some other data that is good for annual reporting. So, if this sounds interesting at all, I'd be happy to find out the details of what's actually involved on the back-end in terms of programming. Perhaps it's somewhat portable.     

    Nick


    -------------------------------------------
    Nicholas Pajewski
    Assistant Professor
    Wake Forest University School of Medicine
    npajewsk@wakehealth.edu
    -------------------------------------------








  • 4.  RE:Project Management Software

    Posted 08-14-2012 11:45

    Patrick,

    It doesn't need to be free, though that would be a bonus! I think for really excellent software, the budget would be similar to what we are currently paying yearly for our center's licenses for our statistical software, < $200. Asking around at our university is what resulted in the "time tracking"-type software, not really what we are looking for.

    Thanks all, for some thoughtful responses! I feel I have several reasonable options to explore.

    Kim

    -------------------------------------------
    Kimberly Love-Myers
    Associate Director, UGA SCC
    -------------------------------------------








  • 5.  RE:Project Management Software

    Posted 08-13-2012 19:19
    I don't know anything about pricing but I use Journyx ProjectXecute (http://journyx.com/) when I consult for one of my clients. It's web-based and seems to work well and have the features you're looking for. I only see it from the consultant's end so I can't attest to its overall performance.

    -- Tom

    -------------------------------------------
    Thomas Sexton
    Professor and Associate Dean
    Stony Brook University
    -------------------------------------------








  • 6.  RE:Project Management Software

    Posted 08-13-2012 19:25
    Hi Kimberly,

    I use a product called Basecamp for managing my consultant's hours.  It is one of the most user friendly and foolproof systems I've ever had.  There are many more capacities than the ones you listed - it's great for managing many aspects of each consulting project - but it definitely does all the ones you're looking for. The pricing plans vary depending on how many people you want involved, but it's relatively inexpensive.  

    http://basecamp.com/

    Good Luck.

    -------------------------------------------
    Heather Krause
    Data Science for the Nonprofit World
    Datassist
    -------------------------------------------








  • 7.  RE:Project Management Software

    Posted 08-14-2012 09:50
    Hi, Kimberly!

    One thought ... my hospital uses CA Clarity as a PM tool, with detail project planning performed in Open Workbench.  Clarity is, I believe, a per-seat license but I don't know what sort of prices are attached; Open Workbench is freeware. The two work hand-in-hand, and may be ideal with student consultants as you can configure various levels of approvals and track time on a very granular level according to projects, services, admin time, etc.

    Alternatively, you could find ClockingIT useful; it was designed by a consultant for consultants. I've never used it but I've heard others say good things about it -- in particular, its time-tracking function.

    Hope this helps!

    -------------------------------------------
    Jason E. Gillikin, CPHQ
    Team Lead, Revenue Cycle Informatics
    Spectrum Health Hospitals
    ASA Q&P Webmaster
    -------------------------------------------








  • 8.  RE:Project Management Software

    Posted 08-14-2012 10:40
    Hi Kim,

    At LISA (Virginia Tech's Laboratory for Interdisciplinary Statistical Analysis) we log our hours by logging into our website, clicking on the project, and inputting our hours plus some comments. LISA clients log on to our website to request a collaboration meeting (to initiate a project), so the projects are already in a database that we update with our hours and comments.

    I don't recommend our tracking system because it can be infuriatingly slow going. I have devolved into creating a spreadsheet of my projects and total hours spent, which I forward to our Administrative Specialist who inputs it into our system and tallies the results.

    -------------------------------------------
    Eric Vance
    LISA (Virginia Tech's Laboratory for Interdisciplinary Statistical Analysis)
    Director and Assistant Research Professor
    Blacksburg VA, United States
    -------------------------------------------