+ Reply to Thread
Results 1 to 1 of 1

Resource Tracker help, newbie, please!

  1. #1
    Registered User
    Join Date
    05-06-2020
    Location
    Ontario
    MS-Off Ver
    7
    Posts
    4

    Resource Tracker help, newbie, please!

    Hi all

    trying to put together a simple resource tracker with a dashboard. Thus far, I've used pivot tables but I am a bit stuck with using a dial to determine a person's capacity (based on 8 hours per day, 40 hours per week).
    Essentially, what I need to do is see how much time a person is spending on a project and whether the combined number of projects they are working on (based on their allocated hours per project) means that they are within or outside of capacity, Ideally, I'd also like to be able to do this by comparing individuals within a division, and compared to other divisions.
    I have mostly used pivot tables, just wanting to know if I am on the right track and how to fix the dial portion.May take a few w-mails, so thanks to those that can help me out.
    My (crude) spreadsheet sample is attached.

    Kind Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hep Building a useful Staff Resource Tracker/Reporting tool
    By leonidasbell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2018, 04:22 PM
  2. Help build a Leave tracker and Effort Time Estimation Tracker
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 02:10 PM
  3. How to Hyperlink Resource Drive Auto update for Resource File.
    By Saikrishna12345 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2015, 03:19 AM
  4. System idle time tracker / Break Tracker
    By reetika05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2014, 07:26 AM
  5. [SOLVED] Resource Tracker - Formula required
    By pauldaddyadams in forum Excel General
    Replies: 11
    Last Post: 10-28-2014, 01:13 PM
  6. Resource management - Rule for resource vs date clashing
    By gwoolley0302 in forum Excel General
    Replies: 1
    Last Post: 07-22-2014, 04:48 AM
  7. time tracker-a running tracker date wise
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2008, 03:08 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1