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.

Excel

15 replies [Last post]
Wed, 2005-06-22 06:49
John Smitt
User offline. Last seen 17 years 28 weeks ago. Offline
Joined: 30 Jan 2005
Posts: 38
Groups: Petro-Chem / Oil & Gas
How about under the forum discussion categories have Excel as a section. Most of us use it and sharing knowledge and improving the look of the data we show in meetings etc is all going to help us and make planning easier on the eye.
Top

Replies

Fri, 2005-09-16 03:22
#1
Charleston-Joseph...
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hello,

Excel for planning. Waste of time.

There is a danger in presenting excel as planning tool, generally colorful graphs and bars that come in with excel drawing tools. The problem will start the moment the client or PMT will like the colorful presentation of excel and feel that the project is doing fine because the colors look pleasing to look at.

Believe me guys, in this environment, you will end up doing both excel planning and primavera planning. In addition you will reconcile the figures generated by the two software. As the project moves on, you will look at the contract to ascertain which planning software to use. If the contract require to use P3, then, you will ask "why are we doing excel planning?". At this period, it is too late to back out and use only P3 because you establish a precedent (P3 planning and excel planning).

I do believe excel got a place in planning, as a worksheet to do preliminary planning computation, export import, etc.

Only an idea. IMHO.

Cheers,

Charlie
Top
Fri, 2005-09-16 01:03
#2
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
Hoping the category for "Excel" would be started soon.

May we hear from PP Admin?
Top
Wed, 2005-09-14 05:27
#3
Katalin Hovanyi
User offline. Last seen 9 years 43 weeks ago. Offline
Joined: 18 Apr 2003
Posts: 38
Groups: Petro-Chem / Oil & Gas
Hi,
The Excel is good to do "global changes" outside the Primavera and load back to the Primavera database. A lot of tedious work can be eliminated this way. In this forum we can share little tricks about this database management not about the Excel as a planning tool.
Best Regards
Katalin
Top
Wed, 2005-08-03 14:33
#4
Philip Jonker
User offline. Last seen 15 years 21 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Bill,

Will e-mail it tomorrow, it is an experience in formatiing, maybe someboby has a use for it
Top
Wed, 2005-07-13 23:16
#5
Bill Guthrie
User offline. Last seen 7 years 50 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
Hi Philip

Wold appreciate your spreadsheet. love using excel and p3 togethere
cheers bill
Top
Wed, 2005-07-13 13:55
#6
Philip Jonker
User offline. Last seen 15 years 21 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Bill/Alex,

If you guys are interested, I could e-mail you an excel spreadsheet, that will blow your minds, and could have been done so simplistically but we have to have the experts.

The point is KISS (Keep it simple stupid) It takes a whole day to update this file, and more, and it robs me of time to walk around and sort out problems. The point is do not develope reporting systems that hook you up to your computor permanently, and if you want these systems, rather employ a data capturer, as it is more than likely you are not looking after the project.

Excel is a tool as is P3, however, P3 or whatever programme you are using is supposed to give the answers. So how can a survey tell us what we need to use. Polls are for politicians, not for engineers.
Top
Tue, 2005-07-12 06:40
#7
Ismail Vandeliwala
User offline. Last seen 11 years 26 weeks ago. Offline
Joined: 11 May 2004
Posts: 23
Groups: None
Agree with Alex,

Excel is mostly a presentation tool and cannot be used for planning.

Also a platform to discuss issues regarding the various features and options of excel for better presentation sounds like a great idea.
Top
Wed, 2005-06-29 09:14
#8
Andrew Edwards
User offline. Last seen 6 years 27 weeks ago. Offline
Joined: 9 Nov 2004
Posts: 15
Groups: None
Sounds like a good idea to me. I’m forever handing out tips on how best to use Excel to compliment what P3 / P3e do. Especially to the poor Engineer who came to me with 3 sheets of A2 paper stapled together and a fantastically coloured set of bars.....
Top
Wed, 2005-06-29 09:04
#9
Bill Guthrie
User offline. Last seen 7 years 50 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
Ha Ha outstanding Alex, love it.

And many forget PRIMAVERA FOR PLANNING
MS EXCEL TO ASSIST IN MANAGMENT OF INFORMATION AFTER THE SCHEDULE IS DEVELOPED.

Would hate to resoruce load a 14000 activity in Excel and try to manage the forecast time line and then progress it

cheers bill
Top
Wed, 2005-06-29 08:48
#10
Alex Wong
User offline. Last seen 11 years 5 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Dear PP

Excel - Interesting Topic

I went to a conference here in Australia, Primavera biggest competitor - guess who - MS Excel

I see engineer try to put together a project report in a excel chart, with activity bars, drawing ...

the first report look great, they try to replicate it for 40 projects, still look very good and management love it.

However, the down turn came when management want to group the projects together, try to find out the critical resource, need to update their progress, then the engineer found out that they are screw up badly. It will take them 3 months to produce such report.

The point I try to make in here is, Excel is good for begineers, when you only have 10 activity you can manage, because it is only a presentation tools that why management love it. When you increase the complexity just a little bit, Excel will fail, fail as a scheduling tool, may be still good as a presentation tool.

Excel skill is needed for presentation of data, scheduling power is require to back up the "Pretty" looking report

In term of having a area to discuss EXCEL for REPORT PRESENTATION I agree, for PLANNING, I totally disagree.

Cheers

Alex
Top
Mon, 2005-06-27 08:32
#11
John Smitt
User offline. Last seen 17 years 28 weeks ago. Offline
Joined: 30 Jan 2005
Posts: 38
Groups: Petro-Chem / Oil & Gas
I’m no expert with excel or planning, infact I’m new to the game, can’t you tell with all the questions. I thought it was a good idea for people to post back when someone asks a question on how to present data. I could have done with this last week doing macros and pivot tables.


Top
Mon, 2005-06-27 04:02
#12
Sunil Kumar
User offline. Last seen 8 years 3 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Agree with all and where do we start and who starts it !!!

Cheers

Sunil
Top
Thu, 2005-06-23 15:18
#13
Philip Jonker
User offline. Last seen 15 years 21 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi guys,

It is probably the most practical tool we have at hand to use to prevent the tedium of trying to use planning programs, and improve everybody (those with the concept) by 500% Agree with Bill
Top
Thu, 2005-06-23 01:14
#14
Shahzad Munawar
User offline. Last seen 8 years 51 weeks ago. Offline
Joined: 2 Jul 2003
Posts: 551
Groups: None
This idea should be implemented coz most of the engineering working is carried out in Excel.

Also P3 and Excel both are interlinked in planning and Excel is basic tool before starting P3.
Top
Wed, 2005-06-22 07:05
#15
Bill Guthrie
User offline. Last seen 7 years 50 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
OUTSTANDING IDEA JOHN, this would help the wannabee planners who are experts with no experience.

regards bill
Top