?
Solved

Pasting Excel Data into Microsoft Projet

Posted on 2013-11-14
5
Medium Priority
?
219 Views
Last Modified: 2014-03-06
I'm desperately trying to paste data from an excel file into a Microsoft Project plan. Microsoft Project always seems to do some sort of calculations which is overriding the real data. For example :

Excel Source Data :
    Start     |Actual Work|Remaining Work|Actual Duration|Remaining Dur|  Finish |
11/26/13  |           5           |           20               |           2                |              1            |11/28/13 |

Once inserted into Microsoft Projet Data
    Start     |Actual Work|Remaining Work|Actual Duration|Remaining Dur|  Finish |
11/26/13  |      18.33         |         6.67              |           2                |              1            |11/28/13|

Task type is currently set to Fixed Work but I tried all sorts of trickery (all task types / manual vs auto shceduling) and it always does the same thing.

How to make this work? I realize the 20h in a single day, this is just an example. Bottom line is I want Project to trust the data and not override anything.

Thanks
0
Comment
Question by:STIWasabi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:regmigrant
ID: 39677509
the changed information is because (probably) you are mixing the various tables project maintains when pasting the data. The Gantt chart view shows a mix of data from Task, Assignment, Resource, Calendar and when you past the mix project is trying to balance all the various elements.

It looks like you are trying to bring Actuals information into the sheet so you should setup all the tasks then swtich to view, table:tracking  and do the paste there.

However this can still be modified if your calendar and resources enforce any changes so turn off auto calculation and auto levelling until the paste is complete


If this doesn't work then a copy of the file(s) would help

Reg
0
 

Author Comment

by:STIWasabi
ID: 39681744
Attached a sample excel projet and the related project file (rename extension to mpp) into which I'd like to paste my excel projet data.

Please let me know, This is getting critical as I wasn't able to find a solution yet.

Thanks
MASTER.xlsx
MASTER.doc
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39685137
apologies, I don't have access to that version of project during working hours, I will look at it later today

Reg
0
 

Author Comment

by:STIWasabi
ID: 39685404
Attached a 2000-2003 version, hoping it will react the same as my 2013 version.
MASTER-2003.doc
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 1500 total points
ID: 39685501
I think the problem is that your spread sheet has actual values summed on all outline levels - the summary figures have to be calculated by adding the lower levels together and rolling up.

Try with the attached where I  have cleared down the actuals from the summary tasks

Reg
MASTER1.xlsx
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question