How to add cost expended, cost allowed, hours expended withoutactual resources
in [Project]
|
Prev: How to add cost expended, cost allowed, hours expended without actual resources
Next: Progress line is not in line with progress bar
From: Rob Schneider on 17 Nov 2009 10:19 First, before going any further, why do you want to put this data in Project. You state you have all that data in Excel ... most of which we would be expecting Project to compute *for* you, e.g. start date, end date, etc. I don't quite understand what you get out using Project. There is really no value in putting all this info into Project if you already know the schedule, cost, and status. If your purpose is to get a Gantt Chart view of the project, you are better off using Excel or Visio (or something similar) to do that. That being said, a great way to figure out how to get info from Excel into Project is to first create small plan in Project with the information you want to import. Then export that info out to Excel. Inspect the result and then put your date into that same exact format and then import it. --rms www.rmschneider.com scottsoo9 wrote: > I have a spreadsheet from excel with numbers such as start and end date, > % complete, % funds expended, hours expended, dollars authenticated, and > dollars expended, travel costs, subcontractor costs, and amount invoiced > and amount paid but with no actual resources. I need to put this into > project. > > My problem besides being relatively new to project is that I do not > know how to put that data in without supplying the actual resources in > the resource sheet. (which i do not have) I can do things such as start > and end date, and percent complete but after that it gets much more > challenging for me. Any guidance on how I would go about doing this > would be greatly appreciated. > > Thanks, Scott > > |