Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2022, 08:58 AM
mporre02 mporre02 is offline Rolling Resource Utilization and Tracking Windows 10 Rolling Resource Utilization and Tracking Office 2021
Novice
Rolling Resource Utilization and Tracking
 
Join Date: Sep 2022
Posts: 1
mporre02 is on a distinguished road
Default Rolling Resource Utilization and Tracking

Hi There,



Hoping to get some help. I have created a resource and capacity tracker with several formulas and conditional formatting built in to detect changes in capacity on a week to week basis.

However, the problem I am trying to solve is, that when I update the utilization(that is in %), I only want it to update for the current week. For instance. If I change someone's utilization from 10% to 20% I would like it to update for that current week, but leave the previous weeks unchanged so I can have a rolling history. I have attached a couple of screen shots of what I mean. Hopefully someone can help.

Thanks in advance.
Attached Images
File Type: png Utilization.PNG (1.6 KB, 10 views)
File Type: png Weeks.PNG (6.3 KB, 9 views)
Reply With Quote
  #2  
Old 09-19-2022, 11:28 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Rolling Resource Utilization and Tracking Windows 10 Rolling Resource Utilization and Tracking Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet ( no pics please). Pictures are quite useless. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to have one task with people rolling on/rolling off at different times? waileong Project 1 10-23-2021 07:20 PM
Rolling Resource Utilization and Tracking automatically calculating employee utilization makaveli80 Excel 7 03-08-2018 03:46 PM
Rolling Resource Utilization and Tracking Resource Reports not showing Sub project Resource group hours RichB Project 3 02-24-2017 08:55 AM
Rolling Resource Utilization and Tracking Under utilization of resources c991257 Project 1 04-17-2016 07:24 AM
Adding resource name to Tracking Gantt bar raminraiszadeh Project 5 09-28-2014 07:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft