MS Project 2007

G

Guest

Could you please help me? I have two questions that bothering me and cannot
find the answer.

1. How can I export timescaled data to Excel? I know that the previous
version do that very easy but the 2007 version can only produce reports and
export some data but it has several limitations (in my opinion).
2. Let’s say that I have to distribute my budget in several working days
(for example 30% the first day, 20% the 10th day and so on). How can I do
that? How can I perform a cost (or budget) constraint in my project?

Thank you very much in advance.

Regards
 
J

JulieS

Hello,

Question 1: -- the only option without code is to use the visual
reports or save one of the cubes and use the cube to create pivot
tables in Excel.

Question 2: -- you can edit cost distribution in the Task Usage
view. Show cost in the timescaled portion and once you have
assigned the cost resource, edit the cost distribution on the
assignment row.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
 
G

Guest

Julie thank you very much,

But before feeding back to you I'm trying to understand your respionse.
Could you please explain to me your answers?
 
J

JulieS

You're welcome. I'll try to explain a bit further.

To the question of saving timescaled data in Excel:

As you noted, the "Analyze timescaled data in Excel" Wizard which
was in previous releases (before 2007) is gone. You've apparently
experimented with using the Visual Reports, and found them limited.
The other options:
- You can save the data from the reporting database through Report
Visual Reports, Save data, Save database. That process saves the
information from the reporting database (including timescaled data)
as an Access file (.mdb). See the Project 2007 SDK for information
on using the reporting database.
- Another option is to use VBA to extract the data to excel. That
is a bit more complicated and requires knowledge of both VBA and the
Project object model. If you have some skills with VBA, try
searching the Project developer newsgroup through Google groups.
You will likely find some sample code there to get you started in
the right direction. Post any questions concerning VBA and project
to the Project developer newsgroup.
- Another option is to save data from one or more of the cubes
through Report > Visual Reports, Save data, Save data, Save cube.
Open the cube file and create your own pivot table reports in Excel.

To the question of editing the cost:

Assign the cost resources to the tasks. Show the Task Usage view
and add the Cost field to the right side (timescaled) through Format
Detail Styles. You can edit where the costs are applied in the
right side.

I hope this helps.

Julie
 
G

Guest

Dear Julie,

Thank you again. The first question is very clear to me now. But please let
me ask you to dedicate a little more of your time to me to explain to second
one.

I can not understand in which task should I associate the budget. For
example I know that in the first day there is an incoming budget equals with
the 30% of the whole budget (lets say 200 euros). With this budget I can
initiate several tasks, but how can I undrastand which one exactly? Where can
I associate this. Continuing there is an incoming ammount of money at the
10th day (lets say 150 euros) which task should I finance or support?

Regards
 
S

Steve House

Jumping in, in Project there is no such thing as an "incoming budget."
Project is not an accounting application and does not deal in any way with
revenues. Budgets, in Project, are estimates of the internal COST of doing
the work in each task. If I have to paint a wall, we expect the painter to
take 40 man-hours to do it and use $100 worth of paint, the painter earns
$10/hour, the BUDGET of the painting task is $10 * 40 + $100 or $500.
Project doesnb't know or care when or if we get any revenue from it. It's
job is scheduling the work and estimating the expenses.
 
G

Guest

Steve you are right. But because I have to explain these matters to myself
please let post a more detailed version of my queries:

Please forget what I said because I can see why I confuse you.

I have a simple project. My data include: tasks, durations, predecessors and
cost.

The issues of concern are:

1. Assuming that the developer is obliged to pay the costs of implementation
of each activity daily as work progresses, construct a cost-duration graph
for the earliest start. Then, plan activities where the contractor has the
following revenue streams:
• 150 € 1 day of work
• 120 € on the 10th day of the project
• 240 € 15 days of the project
• the remaining funds on the 25th day of the project.
It is assumed that there is no possibility of a loan and that the costs of
each activity uniformly distributed in duration.
2. On the 13th day and all go smoothly, we learn that the supply of
electrical equipment will be the 27th day. How affected the timetable
outlined in the above question?

That is the whole thing.

Thank you all again for your kind interest.

Regards

Loukas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top