Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

the MS Excel schedule template you have seen? EASY ONES & COOL ONES

12 replies [Last post]
John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

Excel Schedules have their uses.  (I am a 33 year P3/P6 user also)  What is the best one we can get a copy of that you have seen? - price not being an issue either.  For example from the MS template database etc.  CATEGORY 1 - EASY FOR CONSTRUCTION SUPERINTENDANTS COULD USE.  CATEGORY 2 - SLICK/COOLEST, DIFFICULTY NOT AN ISSUE.  (can even include smartsheets etc, but i would think excel could beat it, maybe not?)

Replies

Zoltan Palffy
User offline. Last seen 1 day 22 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2891
Groups: None

Stephen 

I sent you an email here asking your email address please respond.

I am right behind you I am 63 and I stil have a few more years to work before I semi - retire 

Stephen Devaux
User offline. Last seen 2 weeks 3 days ago. Offline
Joined: 23 Mar 2005
Posts: 650

Zoltan, as usual you are very kind. I'd be happy to see your Excel spreadsheet and, knowing you, I'm sure it's thorough in design and helpful for what practitioners ARE doing. I'd be happy--and interested--to see it.

But I'm mostly interested in seeing things that practitioners AREN'T doing: like DIPP and DPI metrics and analysis; value breakdown structure (VBS); cost of leveling w/ unresolved bottlenecks (CLUB); critical path drag and drag cost; and most of all, techniques and tools that OTHERS may be using that I don't know about for approaching projects, and planning and tracking them as the investments they are.

As you know, my major concern is with improving project management as an important and rigorous discipline: the theory, science, metrics and implementation of such. Although so many bright people are doing a great job in many industries, the bulk of  project management is driven by organizations that have other, conflicting goals: costly organizational membership, certifications, and software sales. As we've clearly seen in the past year, the ignorance and inefficiencies they promulgate cost not just dollars but human lives: in emergency response, vaccine & pharma development and distribution, in shelter construction, in software systems intended to facilitate distribution of life-saving tools... How many people in the organizations that "run" PM, even now, understand that project management ignoranc e is at the root of manufacturing and supply chain bottlenecks that have cost, and continue to cost, so many lives?

At age 71, I'm semi-retired--I'll present or teach or consult on projects and in situations where I think there may be people or an organization ready to start doing things properly. But in almost 40 years, not only have I seen almost no progress, but I've observed the BACKWARDS march caused by the "agilistas" who (1) can't take the trouble to understand critical path and thus don't recognize that EVERY project is as long as its critical path, whether they try to plan and optimize it or not; (2) won't make the effort (or take the risk of being wrong) to plan a project using the REMARKABLY supple and "agile" techniques of what they call "waterfall"; and (3) have brought about an insurrection against the project management "discipline" and created an environment that truly illustrates "the death of expertise".

So though I am assuming that your spreadsheet does not include drag and drag cost (I mean, where wouldthe spreadsheet get those data from?), I'd be happy to see it, and give feedback if you want it. (Sorry if I sound cynical.)

Fraternally in project management,

Steve the Bajan

Zoltan Palffy
User offline. Last seen 1 day 22 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2891
Groups: None

I have an excel spreadsheet that has 7 differnt bar chart format all in one excel file let me know if you want it. I wll send it to John and Stephen if you want it but I am not sending it to the world so everyone else dont ask me please because I know how this goes. 

Stephen Devaux
User offline. Last seen 2 weeks 3 days ago. Offline
Joined: 23 Mar 2005
Posts: 650

"Lets leave P6 out of it"

Hi, John.

I'm not disputing your knowledge, as it is based on 30+ years in one of the most scheduling-mature industries.

However, neither Excel, P6, nor P3 compute THE "critical" metrics for schedule compression/optimization: critical path drag and drag cost. And as these can both change on a daily basis as further planning is done, work is performed or slippage/acceleration occurs, they need to be in a software package that can compute and provide updates instantaneously.

And no metric encourages and facilitates schedule acceleration/recovery more than these two! In 30+ years of consulting in many industries, I have often used these to realize the ability to compress a schedule by 15% to 40% (the lower number in more mature industries like nuke & oil/gas refinery projects).

As far as I know, only Spider Project and Asta Powerproject compute critical path drag. It is a travesty that in 2021 a product like Primavera (which markets itself as kinda the Cadillac of PM) does not perform what should be basic CPM computations.

Fraternally in project management,

Steve the Bajan

John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

Lets leave P6 out of it - that is overkill in different scenarios.  In a basic excel gantt schedule, the below formula draws a black bar from the date. 

=IF(AND((OR($Q2340=AG$2,$Q2340<AG$2)),(OR($S2340=AG$2,$S2340>AG$2)))=TRUE,$AC2340,0)

I want to draw a format bar that uses format, fill, fill effect, from center.  - it looks better, but I cannot figure out how to do it.

John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

Lets leave primavera out of it.  We all have seen PM and Superintendent 3 - 5 week excel schedules.  I am looking at simply drawing the bars using the dates.  I am able to do it using the following formula, but it draws a black bar which does not look good.  I want to draw a blue bar that use "Format, Fill, effect, shade center" which is the only way I can figure out how to seperate the lines and make it look better other than go every other line which I do not want to do because a hassle and waste of space etc.

=IF(AND((OR($Q2340=AG$2,$Q2340<AG$2)),(OR($S2340=AG$2,$S2340>AG$2)))=TRUE,$AC2340,0)

 

John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

Lets leave primavera out of it.  We all have seen PM and Superintendent 3 - 5 week excel schedules.  I am looking at simply drawing the bars using the dates.  I am able to do it using the following formula, but it draws a black bar which does not look good.  I want to draw a blue bar that use "Format, Fill, effect, shade center" which is the only way I can figure out how to seperate the lines and make it look better other than go every other line which I do not want to do because a hassle and waste of space etc.

=IF(AND((OR($Q2340=AG$2,$Q2340<AG$2)),(OR($S2340=AG$2,$S2340>AG$2)))=TRUE,$AC2340,0)

 

John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

Lets leave primavera out of it.  We all have seen PM and Superintendent 3 - 5 week excel schedules.  I am looking at simply drawing the bars using the dates.  I am able to do it using the following formula, but it draws a black bar which does not look good.  I want to draw a blue bar that use "Format, Fill, effect, shade center" which is the only way I can figure out how to seperate the lines and make it look better other than go every other line which I do not want to do because a hassle and waste of space etc.

=IF(AND((OR($Q2340=AG$2,$Q2340<AG$2)),(OR($S2340=AG$2,$S2340>AG$2)))=TRUE,$AC2340,0)

 

Zoltan Palffy
User offline. Last seen 1 day 22 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2891
Groups: None

not sure we have our own custom report writer and tracking tools

John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

yes, the SDK and RA and whatever else are OK - and then they abandon it.  P3P6 became worse for AEC when they chased the IT and MRP worlds which largely ignores P6.  It is crazy how every contractor re-invents the basic 5 week look-ahead schedule instead of the industry using some shared basic templates that work better than starting from 0 everytime.  Does anyone know of a current system that can pull information out of 20 different dailies and summarize them into reports etc.  There use to Monarch and Pipeline etc but then they turn from a utility to a system and become to pricy and specific.  It is crazy that P3 is still better than P6 in many regards and the turle pace P6 has evolved.

Zoltan Palffy
User offline. Last seen 1 day 22 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2891
Groups: None

sdk was the best had everythng including thr capablility to add dictionaries went to the waysde since it is only on 32 bit version.

The one I use a lot is the ability to import 

activity id

activity status

wbs

original duration

remaining duration

activity name

predcessor id # 

relationship TYPE

lag 

 

John Reeves
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 10 May 2013
Posts: 124
Groups: None

AACE library - if you search it nothing comes up for IMP - Integrated Mgt Plan, lets start with the schedule.  Excel is where all our systems meet (sorry E-Builders of the word)  If AACE wants to become more a component of people's careers we should work on some best of basic templates, for example a simple spreadsheet that can be stand alone for superintendants but then also be easily importable into P6.  I think an essential element of a spreadsheet would be one that can be used graphically with X's or shading OR typing in dates.  I will post some info I have on some, it will just taking some digging through old projects - tends to change job to job.