Re: Import datas from MS Access/Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob Schneider (rmschne_at_removetheones_b1e1e1b.net.net)
Date: 05/26/04 

Date: Wed, 26 May 2004 20:40:47 +0100

Well, I'm not exactly sure what the issue is here. A few suggestions:

1. You seem to be using Project 2002 (V 10). Good.
2. The Help files are good. But get your organisation to buy for you a
book or two on Microsoft Project. I like the "Inside Project" series
from Microsoft Press. Even better get them to send you on a training
course.
3. Build a model of all the projects in Project. Define the project
plan per the project plans. Baseline it.
4. The import from the people should be limited to only "actuals"
against the plan. You seem to be importing plans and actuals ... I'm
not sure...I conclude this from the nuggets of info you provide. keep
it simple.
5. Clarify and document the report work process with the people working
on projects.
6. Clarify and document your deliverables, e.g. the output of your
analysis. (with this more easy to figure out what you are doing).

Hope this is useful to you. Let us know.

rms

Nico wrote:
> Thanks for answering. I will try to be more specific
>
> Well, actually I have been spending several days (weeks?) with Project, trying to import data.
>
> I use Office XP (MS Project v10 I guess) in a company where I only have the basic installation with no hope to improve because everything is under control and regulated. I mean that I have no documentation but the very basic help file which always try to install other module but can not, while I investigate too deep.
>
> I am working in a department where à hundred people work on several differents projects. I am trying to use Project in order to analyse data collected from these people. The department is divided in groups that are my ressources. The number of people in it defines my 'Units', the capacity.
> I want to be able to mainly analyse the 'Use Rate', and the 'Cost' monthly or Yearly, and compare 'Actual Work' from 'Budgeted'
>
> From that, the main summary task stands for the 'Activity'. Then every projects are listed, divided in phases that use the differents ressouces at a specific 'Work'. I mean a task may last 1 month with only 1 people working on it 2 hours a week, or may last 2 months with 3 or more people working the whole weeks...
>
> There are my troubles coming from. I started importing data from Excel with a few fields, letting Project calculate the others, but didn't work, using many differents mapping more or less complex. Then I am using the whole DataBase and tryed to fill only some fields, or many. But in every cases, conflicts between 'Duration' and 'Work' in Assignments occured, even though I used 'Effort Driven' and/or 'Fixed Duration'. I tryed to let Project calculate the 'Units' used for a task or not, but it didn't work.
>
> The last test I tried was to create a task and assign it, then save as a .mdb, then change the 'EXT_EDIT_REF_DATA' field to '1', and eventually reload the project from the .mdb. The datas were wrong...
>
> Any help or suggestion for another way is Wecome :)
> See you tommorow, it's time to leave work in France :)
>
> Best regards
>
> Nico

Relevant Pages

  • Distribution of a split db as a runtime
    ... I have a database that I plan to distribute ... Splitting it allows for code module upgrades while keeping the ... and MS' help files in this area ... ...
    (microsoft.public.access.devtoolkits)
  • Re: Updates
    ... Enquire, plan and execute. ... Please tell the newsgroup how any ... > in the help files and what is there is beyond my ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Found Old Encryption Software _ Plan to re-program my own version
    ... Absolute Privacy and I plan to write my own implementation of it using ... the detailed descriptions included in its help files. ... Uh, well, before investing much effort, I'd suggest doing some Internet/Usenet searches for info on that product. ...
    (sci.crypt)
  • Re: UNMOUNTABLE_BOOT_VOLUME
    ... Please clarify? ... Gerry ... Enquire, plan and execute ...
    (microsoft.public.windowsxp.general)
  • Re: Progress with Help?
    ... to the Help files we can install as they get produced? ... Our plan is to continuously improve and frequently update the help. ...
    (borland.public.delphi.non-technical)