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]
mimoune djouallah
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 388
how much time you work on excel comparing to other tool !

Replies

Susanna Kate
User offline. Last seen 2 weeks 2 days ago. Offline
Joined: 20 Aug 2019
Posts: 10
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%
JV Amande
User offline. Last seen 7 years 46 weeks ago. Offline
Joined: 7 Mar 2008
Posts: 17


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%


Jay S
User offline. Last seen 5 years 9 weeks ago. Offline
Joined: 10 Jun 2008
Posts: 36
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
Mike Testro
User offline. Last seen 5 days 18 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4393
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
mimoune djouallah
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 388
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.


Alexandre Faulx-B...
User offline. Last seen 3 days 17 hours ago. Offline
Joined: 20 Jan 2003
Posts: 1252
hi mimoune, ouash rak?
I guess you are working most of your time on Excel and much less on P3 because P3 is a (excellent and efficient but) old looking piece of software; when you want to enter a large quantity of activities or any other data in a P3 schedule, it is much easier to enter the data in a Excel file and then import them into P3.
I am sure you would work less in Excel if you were using P6 or Sciforma PSN (not to mention MSP), because entering data with these software is much easier and quicker.
Also, using a spreadsheet or maybe a small database app like MS Access (difficult to find another one today, when Lotus Approach is long dead and Apple FileMaker such a niche app) is 100% mandatory today; 25 years ago you would have used a huge Olivetti calculating machine!
You have to be able to work with a spreadsheet app and possibly with a database (and why not a report generating software like Crystal Reports) when you are a planner; but none of these apps will ever replace a scheduling software when analysis work is over and you have to schedule!
By the way, how is life in Bethioua?
Mike, congratulations for being still working with Lotus 123; it was my spreadsheet of choice for years, until I switched to Excel both because I was working on Excel with my customers and because the new interface is so ugly.
Alexandre
mimoune djouallah
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 388
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
Mike Testro
User offline. Last seen 5 days 18 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4393
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.