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.

how much time you work on excel !

8 replies [Last post]
Wed, 2010-01-27 13:52
mimoune djouallah
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
how much time you work on excel comparing to other tool !

Top

Replies

Mon, 2019-08-26 21:37
#1
Susanna Kate
User offline. Last seen 4 years 2 weeks ago. Offline
Joined: 20 Aug 2019
Posts: 14
Groups: None

Hi,

Nature of work changes over the time and the same is eventually true for the precentages of different tools in use. Currently my split is as follows:

  1. Excel: 40%
  2. Words: 30%
  3. WordPress: 20%
  4. Research work: 5%
  5. Other: 5%
Top
Sat, 2010-01-30 00:16
#2
JV Amande
User offline. Last seen 12 years 25 weeks ago. Offline
Joined: 7 Mar 2008
Posts: 17
Groups: Civil Engineering


Excel is one of the best medium to illustrate and let your superiors understand the flow/progress of your project.

Excel = 40%
Planning Software = 30%
Site Inspection = 10%
Other Application = 10%
Research = 5%
RESERVE = 5%


Top
Thu, 2010-01-28 20:48
#3
Jay S
User offline. Last seen 9 years 39 weeks ago. Offline
Joined: 10 Jun 2008
Posts: 36
Groups: Petro-Chem / Oil & Gas
Meetings / Team Interaction - 40 %
Word - 20 %
Excel - 10 %
Planning Software - 5 %
Other System - 5 %
Coffee Shop - 15 % (Could be part of team interaction)

And the missing 5 % I Don’t Know
Top
Thu, 2010-01-28 10:38
#4
Mike Testro
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Mimoune

I have moved this from the Trivia section.

A serious answer to your question - In delay analysis the time breakdown is something likee this:

Spreadsheets 60%
Programming 30%
PowerPoint 10%
Word 10%

Best regards

Mike Testro
Top
Thu, 2010-01-28 05:34
#5
mimoune djouallah
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
saha escander, happy to hear from you again.

of course it will not replace a scheduling package for sure, but i was (on purpose) a little ironic in my original post,starting from a middle size project, the volume of data manipulated is very huge (and frustrating),
a planner should have enough skills in database theory and tools in order to survive, updating the schedule now is the easy part, of course once you aggregated all those information in a useful format ( man hour burned by activity, actual start,finish forecast, physical progress, status of drawing, equipments arrived on site ....)

i am not including financial data here, which is a challenge apart.

best regards.


Top
Wed, 2010-01-27 18:16
#6
mimoune djouallah
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
eh what still using lotus, i wonder how it was your experience "upgrading" from p3 to p6 !

i asked about excel usage, because as planner we are supposed to work on p3, but i found myself ( with my colleagues)spending nearly all our time on excel.

one guy from construction department interested in changing the job asked me, what’s the tool he need to learn, P3 or Ms project. my reply was, excel & access.

best regards
Top
Wed, 2010-01-27 16:40
#7
Mike Testro
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Mimoune

Zero time on excell - I use Lotus 123.

I was once asked "How many people work in your firm?" I said "On average about 40%"

Best regards

Mike T.
Top