Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

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.

Package Procurement Schedule in Excel

8 replies [Last post]
Thu, 2005-11-10 07:54
Andrew Owenson
User offline. Last seen 16 years 30 weeks ago. Offline
Joined: 10 Nov 2005
Posts: 48
Groups: None
Guys

I currently use an excel spreadsheet to obtain a matrix report for package procurement. ie tender info required, out to tender, tender return etc... about 15 activities for each package. I have at the moment about 70 packages as a library, from whic I delete to suit each project.

For each package i have three lines Planned Actual & Forecast. I have linked the baseline dates to the planned, actual to the actual, and current to the forecast. So that when I update the programme, the excel sheet reflects the changes. The linking has taken me ages, and is very slow and cumbersome. MSP as far as I know will not provide a matrix style report for this. Any ideas on either speeding up things or whether MSP can help ??

Andrew
Top

Replies

Mon, 2005-11-14 10:25
#1
Andrew Owenson
User offline. Last seen 16 years 30 weeks ago. Offline
Joined: 10 Nov 2005
Posts: 48
Groups: None
Zhang


Sounds interesting! - I will give it a go

Cheers

Andrew
Top
Sun, 2005-11-13 20:50
#2
Zhang Haixiang
User offline. Last seen 4 years 6 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
Hi Andrew,

I think you can try saving you schedule using .mdb format instead of .mpp.

you can access this .mdb file using Excel (ODBC) or Open it directly in MS-Access, then you can creat report or whatever you want. make sure not change data in this mdb file.

Because you are using the same file both in MSP and Excel, so there ’s no problem of static or dynamic.


Top
Fri, 2005-11-11 06:19
#3
Andrew Owenson
User offline. Last seen 16 years 30 weeks ago. Offline
Joined: 10 Nov 2005
Posts: 48
Groups: None
Ian

I like the sound of that - will give it a go


Cheers

Andrew
Top
Fri, 2005-11-11 06:05
#4
Ian Gray
User offline. Last seen 10 years 45 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 6
Groups: None
Andrew,
Have a look on the Microsoft Project Technet site - http://www.microsoft.com/technet/community/newsgroups/desktoppt/project.mspx and search for other answers or ask a specific question.

The best idea in my opinion would be to export (Push) the data to Excel each time using a macro or VBA. Although the data would still be static, it would be a matter of running one macro from Project which shouldn’t take too long.
The other option is to pull the data into Excel from inside the Excel spreadsheet. Best place for Excel/Access help is www.utteraccess.com.
Have fun!
Top
Fri, 2005-11-11 05:01
#5
Andrew Owenson
User offline. Last seen 16 years 30 weeks ago. Offline
Joined: 10 Nov 2005
Posts: 48
Groups: None
Sigfredo

That is what I have done. I copied the cell and did a paste link in excel. The problem being each package has about 15 activivities times 3 planned actual and forecast times that by about 70 standard packages makes that 3150 links. This really slows down the opening and saving of the excel file, also makes the file quite large.

Andrew
Top
Fri, 2005-11-11 04:56
#6
Andrew Owenson
User offline. Last seen 16 years 30 weeks ago. Offline
Joined: 10 Nov 2005
Posts: 48
Groups: None
Zhang


I could export the whole thing and use excel as a spreadsheet. I use excel as the form now. The problem with that is the information would be static, whereas by linking the information, when I update the MSP programme, the excel spreadsheet is also updated automatically.
Top
Fri, 2005-11-11 00:16
#7
Se de Leon
User offline. Last seen 3 years 15 weeks ago. Offline
Joined: 15 May 2001
Posts: 321
Groups: None
Hi Andrew,

How did you link the data of MSP to Excel?

Try this if you haven’t tried it yet. Copy the data cells you want to copy from MSP and paste it using paste special to excel.

Cheers,

Se
Top
Thu, 2005-11-10 23:55
#8
Zhang Haixiang
User offline. Last seen 4 years 6 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
why not export your programme to Excel, than do your Matrix in excel
Top