从Excel导入到MS Project [英] Import from Excel to MS Project

问题描述

首先是问题:我只是想将MS Project计划导出为Excel，然后再将其导入到项目中.大部分情况下一切正常(我根据任务ID创建具有主键的映射).但是，如果我的任务在完成百分比"字段中说20％，则在导入时，MS Project会将其标记为完成100％".当我查看导出时，它在％complete字段中包含.2000000001，我尝试将其更改为.2、20％等，但我认为该字段甚至都不会起作用.

我认为问题在于存在带有日期值的实际开始日期"，但完成日期"是12:00:00 AM(与其他没有值的实际值相同).由于某些原因，MS Project会添加实际的完成日期以匹配计划的完成日期.如果我将值更改为0，空白或不适用"，则它不会提取实际的开始日期，并且会将任务标记为0％完成.我认为完整百分比％并不是真正导入的，只是根据实际日期计算得出的.任何帮助或解释将不胜感激！

我正在尝试做的事情的背景，以防万一有人对如何做到这一点有更好的想法:我的团队有一个SharePoint列表，可用于跟踪可交付成果.在此列表中，有不同类型的评论(同行，团队负责人，签字)的计划日期和实际日期.我要在这些列表项之间创建一个映射，以该列表的Excel摘录，以项目计划的Excel摘录，用VBA更新任务完成百分比，然后将excel项目计划重新导入MS项目.

(顺便说一句，所有软件均为2010版)

解决方案

找到答案，您需要将项目任务导出到excel，至少包括实际工期，唯一任务ID和％完成字段.最好以编程方式执行此操作，以便您可以在excel工作簿中包括一个公式，以便更改您的完成百分比可以正确地更新实际持续时间.然后，将任务列表重新导入到项目中.

导入时:

1. 合并任务
2. 使唯一的任务ID为键
3. 仅导入实际持续时间

您的完成百分比是根据实际持续时间计算得出的，因此应立即进行更新.

First the problem: I am simply trying to export an MS Project plan to excel and then import it back into project. Everything works fine for the most part (I create a mapping with primary key based on the task IDs). However, if I have a task that has lets say 20% in the % complete field, upon import MS Project marks it as 100% complete. When I look at the export, it contains .2000000001 in the % complete field I've tried changing it to .2, 20%, etc., but I don't think this field even makes a difference.

I believe the problem is that there is an Actual Start Date with a date value, but the Finish Date is 12:00:00 AM (the same as other actuals with no value). For some reason MS Project adds in an actual finish date to match the planned finish date. If I change the value to 0, blank, or ‘NA’, it doesn’t pull the actual start date and marks the task as 0% complete. I’m thinking that the % complete values aren’t actually imported and just calculated based off the actual dates. Any help or explanation would be appreciated!

Background on what I'm trying to do, in case anyone has any better ideas of how to go about this: My team has a SharePoint list that we use to track deliverables. Within this list there are Planned and Actual dates of different types of reviews (peer, team lead, sign-off). I want to create a mapping between these list items, take an Excel extract of this list, take an Excel extract of the project plan, update the task completion percentages with VBA, and then import the excel project plan back into MS project.

(BTW, all software is 2010 version)

解决方案

Found the answer, you need to export the project tasks to excel including, at least, the actual duration, unique task ID, and % complete fields. It is preferable to do this programmatically so that you can include a formula in the excel workbook so that changing your % complete will properly update the actual duration. Then, import the task list back into project.

When importing:

1. Merge the tasks
2. Make unique task ID the key
3. Only import the actual duration

Your % complete is calculated based off the actual duration, so it should now be updated.

这篇关于从Excel导入到MS Project的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！