Closed Thread
Results 1 to 2 of 2

Engineer Project Allocation App

  1. 06-16-2020, 07:57 AM #1
    MonkeyBrunt
    MonkeyBrunt is offline
    Registered User
    Join Date
    06-15-2020
    Location
    UK
    MS-Off Ver
    365 v1902
    Posts
    6

    Question Engineer Project Allocation App

    Reposting quuestion as I didnt include an attachment last time
    Hi I am new here, and I am writing an Excel workbook to track the project allocation per engineer.
    All is going well, except I have run into a problem...

    I assign role/skill to each of my engineers (Network, Server, VMware etc) - On the 'Resource' Tab

    I am trying to total the use per skill and demonstrate in a table as I can quite easily do per engineer. - On the 'Staff' tab

    At the bottom of the 'Staff' I wold like to display a consolidated view per skill category (network/storage/etc) but I am a loss to how to get the engineers assigned to the category and then how to then calculate the group's %utilisation


    Unfortunately, I am unable to use any VBA in this workbook.. or it would be finished weeks ago!

    TIA
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-16-2020, 09:10 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Engineer Project Allocation App

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ation-app.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Engineer Project Allocation App
    By MonkeyBrunt in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-17-2020, 04:30 AM
  2. Get the start date and end date of project in a range of Project Allocation
    By juan.doe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2018, 09:54 AM
  3. Hour Allocation based on project phases
    By Samgrindrod in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2017, 03:07 PM
  4. Resource allocation Per Project
    By excelhelpexcel in forum Excel General
    Replies: 0
    Last Post: 04-07-2014, 05:14 PM
  5. Solver for personnel project allocation
    By sunrise85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2011, 11:20 AM
  6. [SOLVED] Project allocation
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 03-21-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1