Can I import data from excel into project

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Predecessor Driven Completion I am attempting to drive completion of a task by marking the completion of its predecessor tasks. That is, given task A with predecessors 1-8, I would like task A to show incremental increases in completion % whenever I check off one of the predecessor tasks as 100% complete. Is this possible to do or could someone help me write a macro for it? Thanks! Mike Tag: Can I import data from excel into project Tag: 92474
  - 2
    - time phased network diagram I can see how to line up the network diagram in columns of days, weeks, or months. I can't see how to label each column. Is there a way. jlb Tag: Can I import data from excel into project Tag: 92470
  - 3
    - enable copy and paste function When I try to copy and paste, I get function disable! How do I correct this? Tag: Can I import data from excel into project Tag: 92469
  - 4
    - PPBES and Project All of the threads I have looked at deal with Project doing projects. I am trying to use Project to look at dependencies in the PPBES. My almost totally ignorant "MS Project perspective" is that Project is round peg and PPBES is a round hole as PPBES is an ongoing process, ad infinitum. Does anyone have insight, or can point me in the direction to get some help? thanks in advance. Tag: Can I import data from excel into project Tag: 92465
  - 5
    - Hiding Subproject summary tasks? Is there an option in MS Pro 2003 to only show some summary tasks that I want? I don't want the Project Summary Task to show so I uncheck this in Options>View. I have a massive master project with lots of subprojects and when you look at the Gannt View there are many summary tasks. I only want to show the summary tasks within the subproject (Tasks) and not the 'mini' project summary task for the overall subproject if that makes sense. If you want more info please ask. Sorry to be so inconvenient with my questions. Thanks Tag: Can I import data from excel into project Tag: 92456
  - 6
    - No work vs. zero work- how to erase? Greetings again! When work has never been assigned to a resource on a particular day that the task usage view shows no value for that day. However, it appears that once work is assigned, it can then be zeroed out, but I can't figure out how to blank it out (meaning restoring it to the original state before work was assigned, where it wasn't zero on a particular day but rather was nothing, blank). Anyone know how? Thanks, George Tag: Can I import data from excel into project Tag: 92451
  - 7
    - Task splitting - a process, not a parameter? Greetings! This is to check my understanding from observation of how task splitting works. (1) It would appear that when a task is split, which can only be done graphically, Project moves the work for the assigned resources from the start of split out to the end of the split-off portion of the task as you pull the split over. This achieves the same result as manually zeroing out a resource's work in the middle of a task assignment and moving it to the end. (2) Different than (for example) a delay, there is no parameter to record a split point or duration. As a result, in order to adjust a split, you must grab the task bar and move it, or fiddle with the daily work assignments. Also, there isn't a parameter that can be tested to check for a split. Does this sound about right? Thanks, George Tag: Can I import data from excel into project Tag: 92450
  - 8
    - Find all timephased data for a particular local resource in Project 2003 Hi All, Does anybody know how to find all timephased data for a particular local resource in Project 2003? Regards, Ronen Tag: Can I import data from excel into project Tag: 92447
  - 9
    - Colour Coding! Hi there, I have recently set up a Project in the 2003 version, to track all development jobs passing through the IT department. I have set up a customised field which has a drop down listing, of items such as , 'To Be Quoted, In Progress, On Hold, LIVE, Cancelled......etc'. What i am trying to achieve is that when i select a particular value from the drop down list, i want the relevant Gantt bar to change colour. I have tried to do this from within the 'bar styles', dialog box, but it doesn't seem to be able to cater for criteria such as 'If 'Ref Status', equal to 'LIVE', (then colour should be set to Green)! etc. Any help would be greatly appreciated. Kind Regards Nicholas J H Evans Tag: Can I import data from excel into project Tag: 92446
  - 10
    - (Pool) resource calendar v project calendar Hi, I have a resource pool and a calendar for the resources in the pool. I want to assign a resource to a project and have the working time result from the overlap between the resource calendar and the project calendar. I know I can do this by using task calendars but is there any other way besides setting a calendar for every task in the project? TIA Zuri Tag: Can I import data from excel into project Tag: 92445
  - 11
    - MS Project Template for PBX replacement Starting a project to replace a SIEMENS PBX. MS-Project template of project from an actual project would be useful. Tag: Can I import data from excel into project Tag: 92439
  - 12
    - Actual work incorect in Project Pro when importing from MSP_TIMEPHASED_DATA table App Name: Microsoft Project Server 2003 We have an external process that populates the MSP_TIMEPHASED_DATA table with actual work for project plans on a weekly basis. We use the "EXT_EDITED" flags as suggested by Microsoft. I have confirmed that what we want to push into the TIMEPHASED_DATE table and what makes its way into it are in sync. The following is an example of the behavior we are noticing. I have verified that the timephased_data table contains actuals of: 1000hours for Resource A assigned to Task 1 2000 hours for Resource B assigned to Task 1 0 hours for Resource C assigned to Task 1 (this is indicated by NO rows for this specific Resource and task existing in the table). The task is set to Fixed Duration and has a Start Date of Sept 1 2005 and a Finish date of Dec 31st 2005. When the file is opened I will notice something like this: Resource A has a total of 1200 hours of Actual Work. Resource B has a total of 2100 hours of Actual Work. Resource C has a total of 900 hours of Actual Work. In addition, assume the last date actuals have been entered in is the last week of November of 2005. I will notice that end dates being extended out a couple of months and work being spread across that time. The problem is two fold. Additional actuals have been manufactured and Finish dates have changed when they should not have. If I close the file without saving (so that I don't overwrite the timephased_Data table data) and change the task to fixed work or fixed units by modifying the task_type field in the MSP_Tasks table, I notice the correct actuals when I open the file again. The dates have off course re adjusted but the total actuals and the individual values in the weeks are correct to the decimal point. I have also tried to manually replicate the issue by creating a fixed duration and entering all the data manually (work and actual work) in the timephased buckets. In this case I noticed the correct behavior where the finish date remains constand and the remaining work is re-spread accordingly. Can anyone explain this weird behavior? Thank you, Jason Elios Tag: Can I import data from excel into project Tag: 92435
  - 13
    - Level of Effort tasks How can I set up a "Level of Effort" task that starts at the beginning of a project and ends at the end of the project and will automatically extend and contract to stay equal to the project lenght if the project lenght changes due to additional tasks, overruns, etc? The LOE task is a bucket for things like answering phone calls, misc meetings, filling out time tickets, etc. Tag: Can I import data from excel into project Tag: 92433
  - 14
    - Import Calendar from Outlook Can you import a calendar from Outlook??? Thanks, Barb Tag: Can I import data from excel into project Tag: 92418
  - 15
    - Converting between mpx and mpd Anyone know of any tools that will convert mpx files to mpd files and back (other than MS-P that is). I have a visual planning tool that exports in mpx and a webbase Project Management Info System that is mpd based. It would be expensive to buy everyone a copy of MS-P just to be a peice of middleware. Simon Tag: Can I import data from excel into project Tag: 92415
  - 16
    - Hiding Resource Rates I have a Resouce Pool with 2000+ resources. It contains the hourly rates for all the resources to allow me to generate cost data from project plans. However for HR reasons I need to hide the rate information from plans that are linked to this pool. Tried a few idea's but short of having two versions of the Pool with and without rates and linking/unlinking from ALL the sub-projects when i need to do budget work (tried it and takes a couple of hours) I'm at a loss. Help Simon Tag: Can I import data from excel into project Tag: 92414
  - 17
    - Maximum number of hours allowed per day I would like to know what is the standard used by other users when setting up a Maximum number of hours allowed per day. We were thinking of leaving it with about 16 hours (just in case), but if someone needs to enter more hours, is there a way to override that value on the fly? or the default will need to be changed?. I am just curious. Thanks in advance! Tag: Can I import data from excel into project Tag: 92408
  - 18
    - how to test a formuala The formula i wrote isn't getting the results I thought, how do you go about debugging a formula? Tag: Can I import data from excel into project Tag: 92405
  - 19
    - Resource Assignment and Levelling Hi, I've been using MS Project for only a little while, and used to do all levelling manually. Since my current project involves too many resources, I'd like to find better ways. I have a few questions... 1) Can MS Project assign resources from a group of resources? For example, I have 3 PLSQL programmers and 8 Java programmers. The PLSQL tasks can be completed by either one of the PLSQL developers. Is there a way to tell MS Project to select the best resource to optimize the result? 2) Our company uses multiple project plans, all linked to a master plan and a single master resource file. If I decide to use automatic levelling of my plan, will it affect the dates on the other plans? If yes, is there a way to prevent it? I don't believe the owners of the other plans would like it very much. --> Most of the resources on my plan are mine alone, but a few are shared. Tag: Can I import data from excel into project Tag: 92399
  - 20
    - need template to handle vast information for search and rescue i need to get or develope a template/program to handle vast amount of information on volunteer workers for search and rescue HELP please Tag: Can I import data from excel into project Tag: 92397
  - 21
    - Remaining work for in progress task I have an in progress task and I'm entering updates on a daily bases (via View / Task Usage). Two questions: 1) what is the status date and how does it relate to how I am entering data? 2) how can I add time remaining to a task without project rescheduling everything? Ie, I don't care about resource overallocations due to added required work. -------------- Justin Tag: Can I import data from excel into project Tag: 92392
  - 22
    - What is the best way to cancel a task What's the best way to represent a task or set of tasks that were originally planned, but then not executed (canceled)? I don't want to indicate that they were completed, I don't want to show that they're still waiting for work to be done, but I don't want them to disappear (they were planned tasks that show a history of what happened). Tag: Can I import data from excel into project Tag: 92389
  - 23
    - How to Automatically Mark a Milestone Complete if All Predecessors are Complete Hi, If I have a milestone, and it has one or more predecessors, how can I mark the milestone complete when all its predecessors are complete? It seems like a very simple thing to do, or at least something which must have already been thought about in the past. I've searched high and low for an answer. Thank you! Joe Tag: Can I import data from excel into project Tag: 92388
  - 24
    - Reports - Can you segment by individual resources? Good Morning, I'm trying to breakdown the To Do list down to individual resources, so that I may distribute personalized reports. So far, I can only get tasks segmented to individual resources, but still encompasses the entire project. Any suggestions? Thanks, Howard Tag: Can I import data from excel into project Tag: 92387
  - 25
    - Problems with Custom Fields I'm trying to have a custom text field that displays a resource's initials and then the percentage of work assigned to them. We are assigning resources to summary tasks, not individual tasks, but I'd like something similar to the text on the gantt chart that you get with the individual tasks. Anyway, I've taken Text1, and to test it, simply set the formula equal to [Resource Initials]. Then I added Text1 to the Bar Styles for Summary, instead of Resource Initials. Now, nothing is showing up to the right of the summary bar on the gantt chart. Ideally, I'd like to have the field say: [Resource Initials] & "[" & [Actual Work] & "]" But I can't even get just the initials to show up. Any ideas? Thanks, Dave Tag: Can I import data from excel into project Tag: 92380
- Next
  - 1
    - % Availability and Days per month in Tools/Options Situation: I have a 100 days of Business Analyst (BA) resource in January and 120 days in Febuary. January has 20 working days in it and February 19 working days. In order to understand the BA resource's availability for Jan and Feb, I have divided 100 by 20 and 120 by 19 respectively. This gives me Monthly % availibilities of 500% and 632% respectively. I am now creating tasks and BA assigments within January and February in order to see if I exceed the monthly % availibilities... Question - what bearing if at all does the Days per month figure in Tools/Options have on what I am doing? Tag: Can I import data from excel into project Tag: 92379
  - 2
    - Request Status: 9603 We are running Project Server 2003 sp 2 with Project Professional 2003. When we try to check-in an enterprise project in the Project Web Access screen, we receive the following VBSript error message "Request Status: 9603" and we are not able to check in the project. Has anyone run across this issue before? If so how did you fix it? Thank you Tag: Can I import data from excel into project Tag: 92378
  - 3
    - Duration driving Finish based on which calendar? Thought I'd cracked Durations but it's got me again! I'm using Fixed Duration with a shorter than Standard resource calendar and I'm not getting expected Finish dates. To demonstrate, if I have a single task, Fixed Duration, 75 days, starting 1 Feb 06. With the default Tools/Options/Calendar settings (8 hrs/day, 40 hrs/week, 20 days/month), the end date is 17 May 06. This is 75 working days (weekdays), entirely as expected. However, the Resource I want to allocate to it has a 32 hour working week (and this is reflected in the Resourceâ??s own calendar). I therefore change Tools/Options/Calendar settings to be consistent with this (6.4 hrs/day, 32 hrs/week, 20 days/month). The Duration changes to 93.75 days and the end date stays at 17 May 06. If I set the Duration back to 75 the end date goes to 26 April 06, which is wrong for the Resourceâ??s shorter working day calendar. The behaviour above results whether or not I have a Resource allocated to the task, and whether or not that Resourceâ??s calendar is based on Standard, or something with less then 40 hours/week. So the issue is with the Tools/Options/Calendar settings, not with the resource or its calendar. I want to be able to enter a duration in terms of my real, shorter than standard 8 hour, working days and for it to calculate the end date as 17 May. If I apply a Task Calendar defined as 32 hours/week, the end date is OK (16 May 75 days duration). The problem is, I donâ??t want to have to apply a Task calendar to every Task in my schedule. It could also be very confusing to other people using the schedule, because Task Calendars are a little bit esoteric. If I apply a Resource which is based on the shorter calendar, it makes no difference (the shorter calendar of the resource does not affect the end date). I know Duration is Work/Resource units, but if there is 0 Work and no resources allocated, on what basis does MSP calculate the end date from a Duration? It looks like the Duration drives the end date using the Standard calendar, regardless of the calendars of any Resources applied to the task. The only thing I can think of is to change the Standard calendar Working Time to 32 hrs/week. I donâ??t really want to do this because I am using a resource pool used by several projects and I donâ??t want the shorter week applied to all projects, just those tasks which have resources with a shorter calendar. Does anyone know any alternative to applying task calendars en masse, which seems the least bad option at the moment? Apologies if the above is confused. I have an example project if anyone needs it. Thanks Martin Tag: Can I import data from excel into project Tag: 92367
  - 4
    - Can you filter unassigned projects? Is there a way to filter unassigned projects? I've been clicking around on MS Pro but still have not found anything yet. Sorry if this is so obvious and I don't know how to do it. Thanks Tag: Can I import data from excel into project Tag: 92366
  - 5
    - Manufacturing Firm We are a manufacturing firm specializing in cement products. We do not use any machines as resources, all our products are hand layed into a mold. I need help setting up my shops' resources and schedules. I have used excel until now, but now I need something more complex to help me know when I am overscheduling a certain resource or department. My resources are employees, cement, and molds themselves. How would I set it up to know when a mold I need to use is going to be available? Any help setting this up or if anyone knows any templates designed towards what I am looking for would be a huge help. Thank you. Tag: Can I import data from excel into project Tag: 92360
  - 6
    - Exporting reports from MS Project Good Afternoon, I've read many postings on the Office Discussion Groups website about exporting reports from MS Project. I need to pass out reports to folks who don't have project, but are listed a resources and task owners. Without having to recreate the wheel in another program or become a programmer, is there a way to create a report that could be distributed via another program (i.e. Excel, Word)? Thanks, Howard ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=167c5845-0ce9-4872-bb9b-7df54f12f30c&dg=microsoft.public.project Tag: Can I import data from excel into project Tag: 92354
  - 7
    - Precedence question Ok, I don't know if this his possible... I have two tasks: Task1 Task2 Task2's precedence is Task1. Let's say it takes Task1 4 days to complete and Task2 has to begin only when Task1 is complete. So if Task1 takes 6 days, Task2's start date and bar in the Gantt Chart should move to the right. I can't get this to happen. What usually happens is that Task1's bar completion runs over the start of Task2's bar and the arrow snakes around to the start of Task2. How can I have Task2's start change when Task1 is late? Tag: Can I import data from excel into project Tag: 92353
  - 8
    - critical path not calculating I have a project in 2003 that shows no critical path I recreated that project in 2002 and it shows the critical path just fine I thought that perhaps the project was messed up in 2003 so what I did was recreate the project with all the default settings. First I created the task list (50) tasks - the critical path looked okay BUT periodically I would get an activex error and have to quit out and come back into project. But some of the dates looked wrong (i.e. the last task was set at 2 days but had a start date of 3/30/05 and a finish date of 7/28/06 - HUH!!) After getting my tasks set up (with the one strange date problem) I then added main tasks and made my other tasks subtasks so that this was easier to summarize. Like so.... MAIN TASK 1 subtask 1 subtask 2 subtask 3 MAIN TASK 2 subtask 1 subtask 2 etc. As soon as I did this the critical path go all messed up - when I did the same thing in project 2002 there were no issues at all. I installed service pack 2 for 2003 (which has an activex fix in it) and now the dates look right (albeit 2 months different from the original file) but the critical path still won't calculate. Can anyone help me with this please? Am I doing something wrong? Tag: Can I import data from excel into project Tag: 92352
  - 9
    - Master Projects I have created a master project with links to 2 projects. When I look at the resource usage in the master project it shows the 2 projects and the work associated with each project - one line per linked project. If I go into either of the 2 linked projects and add/change/delete a task and then go to the master project I no longer see a summary line for the project that I added/chanegd/deleted the task, but see all tasks from that linked project for that resource. How do I keep the summary level resource usage for the project that has been adde/changed/deleted tasks and not see all tasks? Tag: Can I import data from excel into project Tag: 92345
  - 10
    - Disabling Resource Pool additions Hello, I am using project 2003. I have a master project, with many projects inserted into it all sharing one resource pool. I would like to prevent inadvertant changes to the resource pool, that seem to be caused by typing a name instead of using the drop down box when assigning resources to a task. I have used tools> options > general and turned off the option of adding resources and tasks. However, it still allowed me to resource names. When saving, error messages popped up, but I could say okay and bypass the error message. What have I done wrong? Could it be that the individual project files have to have the setting tools> options > general and turned off the option of adding resources and tasks done first? Any help would be appreciated. Thanks, -- Tina S. Tag: Can I import data from excel into project Tag: 92343
  - 11
    - BCWP <> BCWS w/ Project Status @ 100% A customer of mine has asked me to graph when we can expect our project to catch up with the baseline. I've adjusted some durations and task relationships on how we plan to catch up. I then set the "Status Date" to the end project date and set all tasks to 100%. My thinking is that if we complete all the tasks based on the new schedule, I should see BCWP catch up to BCWS. However, when I do this and export the values to Excel, the time phased BCWP doesn't equal the BCWS. I thought when all the tasks were complete, the BCWP would equal the BCWS? What's going on? Thanks, Tag: Can I import data from excel into project Tag: 92335
  - 12
    - Filter for multiple resources? Hello, glad to find this board. I am trying to display a few kinds of tasks in the calendar view: one resource plus some milestones that have no resource assigned to it (such as client submissions, client feedback expected, etc). The goal is to have a calendar for each resource that shows their own tasks PLUS some major common milestones. Applying the "Using Resrouce" filter does almost what i want but I don't know how get the client submission milestones on there. I was thinking I could create a new resource called "submissions" and then try to filter for 2 resources in calendar view, but I can't see how to filter for more than one resource. (Actually for a different purpose I would like to be able to filter for more than one resource - would that be done using resource groups??) There might be something useful in reports but since I don't have a printer connection this function is not available to me. Also, I'm running Project through Virtual PC on a Mac (creative company!!) and there are many inherent printing problems. Any suggestions to filter either by multiple resources OR showing a resource + certain other tasks? Many thanks, Christa Tag: Can I import data from excel into project Tag: 92333
  - 13
    - partial access of one file I am using MS project professional 2002. I have one master tracking that needs to be updated further by the other people. At present, the entire file is password protected and only one person can update it. Can I give partial access(few columns only) to some people but not all? If the answere is no. Can I insert the updated file to the old file that overwrites the old inforlation only. please advice the best solution thank you Majid Tag: Can I import data from excel into project Tag: 92332
  - 14
    - Import Resource Cost Data I have an excel spreadsheet that has 4 fields: employee name, hrly cost for Project 1, hrly cost for Project 2, and hrly cost for Project 3. I would like to be able to import these costs into the A, B, & C sub tabs in the resource form under the cost tab. Is this doable? TIA! Tag: Can I import data from excel into project Tag: 92323
  - 15
    - Linked Workbooks I have a huge project with many different areas that each have their own Microsoft project file to manager their particular area. I have inserted a text link into a master project to each workbook so that when they update their files the master file will update. What I have found though is that when I open the master file first it shows that it is "opening" the other files to update the links and then in return other people can't get into their files b/c it says that I have it open. But when I look on my computer, it shows that I have my master file open but no others. What is the best way to do what I'm trying to do? Which is basicly have one master workbnok that is linked to all the other workbooks but does not interfear with them using their workbooks. Maybe I am completely on the wrong track, but I'm a little lost. Thank you for your help, Stephanie Tag: Can I import data from excel into project Tag: 92322
  - 16
    - allocating resources messes up work spread I have several 3 month fixed duration task and have spread the work out across the months using the task usage view. In some cases the work does not start until the 2nd month. When I assign a resource to the task, it pulls the work in the 2nd month forward to the 1st month which was showing zero work. Is the way around this to always ensure fixed duration tasks have some work at the beginning of the period ie I should have set the start date to conincide with month 2? Tag: Can I import data from excel into project Tag: 92319
  - 17
    - Equating resources problem Hello Can I set up that when two resources are working, if one is occupied, (for whatever hours) the next one is also occupied for the same duration? Milind Tag: Can I import data from excel into project Tag: 92314
  - 18
    - Position Gant Chart for viewing I am using ole automation to create an MS Project chart. Just before I auto save the project I send the Project Start Date. This however dose not reposition the gant chart to bring the task bars into focus. If I manually type in the Project Start date the bars will move into focus. What is an OLE command I could use to get this to happen in autmation. Tag: Can I import data from excel into project Tag: 92313
  - 19
    - text separator in Project 2000 Is there a way to force a space as the text separator in the 'predecessors' column rather than the comma? Since the task numbers and commas are jammed together, the text won't wrap. Tag: Can I import data from excel into project Tag: 92304
  - 20
    - Deadline How can I calculate the time left from the end of a task and a project deadline? And can this be shown in a column? Thanks in advance! Tag: Can I import data from excel into project Tag: 92300
  - 21
    - Sorting issue with customer report I am trying to sort a "who does what" report by resource name (first sort) and task start time (second sort). Additionally, I wanted to have a third sort by task ID...is this the "ID" in the drop down selection? When I choose these items in the sort tab my tasks that are listed for each resource ARE NOT sorted in chronological order. WHY?? I have one person with 6 tasks. Their tasks are not sorted in chronological time order. It has the first task in the 4th row, 2nd task in the 5th row, 3rd task in 1st row, 4th task in 6th row, 5th task in 3rd row, and 6th task in 2nd row. Please help me out. I have to have this report done before the end of the day to distribute to the resources so I can freeze my implementation plan. Thank you, Dave Tag: Can I import data from excel into project Tag: 92295
  - 22
    - Resource Pool problem Hello A resource charges 200/hr in one project, but later charges 300/hr in another. If I change the rate, the new one gets reflected in both the projects which is wrong, he has signed the contract at the old rates for old project. How do I use him from the resource pool? Milind Tag: Can I import data from excel into project Tag: 92294
  - 23
    - Task Dependences Between Summary Task Microsoft Project Application, does pop the message saying "the predecessors of a summary task or predecessors of an inserted project summary task must have a finish-to-start or start-to-start dependency" while defining task dependencies (type = start-to-finish or finish-to-finish) between two summary task. Can anyone explain me the functional reasoning (with an example) as to why such a restriction is present. Tag: Can I import data from excel into project Tag: 92293
  - 24
    - Resource Graph Baseline View? Connected to my previous question...can I show a baseline work line on the Resource Graph as well as work? Tag: Can I import data from excel into project Tag: 92292
  - 25
    - Filter Resource Graph I have several hundred tasks with resources assigned. I can then review the overallocations in the Resource Graph view. I now want to be able to exclude certain tasks by setting a Flag (in Task fields) to yes so that the Resource overallocations exclude the assignements on those tasks with the falg set to Yes - is this possible? Tag: Can I import data from excel into project Tag: 92291

I need to import selective data from an oracle data base into MS Project.
This information is downloadable through an interface that will dump it into
an Excel spreadsheet. It is just raw data. I need it formatted properly for
MS Project (with indentions and links). What are my options? I could possibly
have the data sent to me in a different way (from the data warehouse). I need
guidance. Could I create a template in project that would contain the correct
format? Could I take the data directly to Project with out the Excel step?
Any ideas?

Top

Re: Can I import data from excel into project by Brian

Brian
Fri Oct 28 11:48:24 CDT 2005

Tony F wrote:

>I need to import selective data from an oracle data base into MS Project.
>This information is downloadable through an interface that will dump it
>into
>an Excel spreadsheet. It is just raw data. I need it formatted properly for
>MS Project (with indentions and links). What are my options? I could
>possibly
>have the data sent to me in a different way (from the data warehouse). I
>need
>guidance. Could I create a template in project that would contain the
>correct
>format? Could I take the data directly to Project with out the Excel step?
>Any ideas?

Export a project with links and indentations and then export it to Excel.
Export Tasks, Resource and Assignments.

Then look at the spreadsheet it creates. That is how it should look. :-)

--
Brian K - Project MVP
http://www.projectified.com
--
Senior Trainer - Electronic Arts
--
QuantumPM Associate
http://www.quantumpm.com

Top