Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2014, 04:08 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default Finding gaps in a programme


I'm putting together a programme for our painters to paint buildings.

The can only paint the buildings when the price has been agreed, which is different times of the year for different buildings - January, April and September so far.

So I've programmed 3 buildings after January, 5 buildings after April and 2 in September. The durations are different for each building but I've made it so as soon as they finish one building they start on the next.

How can I find out, quickly, either using a column or something indicative on the ganntt chart how much time is spare once the lads have finished painting please?

The way it lies at the moment is Januarys buildings are done by mid Feb, so I need to send the guys to paint or go mend something somewhere else til Aprils painting is ready to kick off, but I would like to see easily how many days there are between batches of painting.

Many thanks
Reply With Quote
  #2  
Old 11-05-2014, 06:34 AM
JulieS JulieS is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm don't think the Gantt chart view is the best choice to discover this information. The only timescaled view is the graphic on the right. Certainly collapsing the summary tasks (assuming you have created summaries for each of the runs) will show you the gap.

I suggest looking at the Task Usage view (with the Project Summary tasks visible) zoom out to weeks or months and look for the gaps.

The Resource Usage view with Remaining Availability added to the timescaled side (right) will also show you when your crew is available for other work.
Reply With Quote
  #3  
Old 11-05-2014, 06:45 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Ah the thing with the summaries is, on some of them, I have a bar for "Tender period", then a bar straight after for the painting works, because for *some* of the works there may be a consulatation required.

So when I roll up the summaries, they overlap...



Im not entirely sure what task usage/ resource usage view is, but I wll start looking at them now.



Is there no other way like, putting in a column on my sheet that will say how many days are between 2 tasks?
Reply With Quote
  #4  
Old 11-05-2014, 07:00 AM
JulieS JulieS is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

No, you cannot calculate values in a custom field comparing two tasks. You can filter the list of tasks to show tasks only assigned to the resources of interest to help discover gaps.
Reply With Quote
  #5  
Old 11-19-2014, 03:43 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
No, you cannot calculate values in a custom field comparing two tasks. You can filter the list of tasks to show tasks only assigned to the resources of interest to help discover gaps.
Its all the same resource - 2 painters.

I really am stuck
Reply With Quote
  #6  
Old 11-19-2014, 05:32 AM
JulieS JulieS is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Again, look at the Resource usage view. Add the Remaining Availability field to view when the resources have availability.
Reply With Quote
  #7  
Old 11-19-2014, 05:37 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Hi Julie, its not the gaps in rescources I'm looking for, its gaps between tasks.

Or will this tell me the same thing?
Reply With Quote
  #8  
Old 11-19-2014, 06:12 AM
JulieS JulieS is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

If the resources are assigned to the tasks, they will have availability in the Resource Usage view.
Reply With Quote
  #9  
Old 11-19-2014, 06:30 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
If the resources are assigned to the tasks, they will have availability in the Resource Usage view.
Hi

sorry if I'm being thick, but where do I find remaining availability? I went to insert a column and cant see it?

ETA - found it, its a tick box at the top. I will see if this helps me, thank you for your help
Reply With Quote
  #10  
Old 11-19-2014, 08:26 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Hi,

I think I found a solution, Ive switched on "show slack" on the gant chart and changed it to red and a thicker line to help it stand out. This is showing me where there's gaps.

Thanks for your help.
Reply With Quote
  #11  
Old 11-20-2014, 04:58 AM
JulieS JulieS is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Slack shows gaps in tasks - but not necessarily with a specific resource. However, if it works for you - great
Reply With Quote
  #12  
Old 11-20-2014, 06:26 AM
Peasy Peasy is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Novice
Finding gaps in a programme
 
Join Date: Sep 2014
Posts: 16
Peasy is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
Slack shows gaps in tasks - but not necessarily with a specific resource. However, if it works for you - great
Hi Julie

Yeah its just the gaps in tasks not the resource as its the same two guys all the time.
Reply With Quote
  #13  
Old 11-20-2014, 03:31 PM
JulieS JulieS is offline Finding gaps in a programme Windows 7 64bit Finding gaps in a programme Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Ah, sorry. I guess I missed that part.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Programme not levelling - MSP 2013 Peasy Project 8 10-23-2014 07:35 AM
Close the gaps with Bar Graphs Alaska1 Excel 0 05-17-2013 11:55 AM
Finding gaps in a programme Gaps in address mail merging Trixz_D Mail Merge 2 08-05-2012 04:23 AM
Finding gaps in a programme How to get rid of Huge Gaps in my 300 pages Document? SpaceMuppet Word 7 05-04-2011 12:26 PM
Finding gaps in a programme How to copy contact list to another programme ksimmonds Outlook 2 01-13-2011 06:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 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