import modified excel sheet to p3e
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Hi,
A lot of Training Institution in your place. However, most of them are not teaching the quick methods & techniques. If you are really interested and willing to learn more especially the tricks you should hire a good one. Of course, it will cost you a lot.
Well, my advise to you if you have time to spend in playing you must also have time to spend in learning (Primavera).
Try to experiment, compare one thing to another. Open all the examples in P6 and try to observe how they did it. Try to read the function of each icon by using hint help and apply it. A lot of things you can do.
The most important thing, always visit www.planningplanet.com
Cheers,
Arnold
Hello Arnold,
Thanks alot man, this is awesome, I am wondering where I can find good tutorial for p3e.
regards
abdesalam
Hi Abdesalam,
I received your sample files. To get rid of confusion in modifying only Budgted Units in Excel Sheet, try to export "Resource Assignments" only as Export Type. Do not include other unnecessary Activities.
I already sent to your e-mail the steps with screenshot attached.
Hope this helps.
Arnold
Hi Abdesalam,
If you dont mind, can you please send me a screenshot showing what you really need or you can send me your .xer file and I will show you how to do it. My email address is [email protected]
Thanks.
Arnold
Hi Arnold,
actualy I am selecting resource assignment, do I need to select resource assignment only and it will be oki, or I need to selct other tabs in export dialogue.
so far it didnot work out.
abdesalam
Hi Abdesalam,
I assumed that you select Export Type is “Activities” instead of “Resource Assignments”. If this is so, then it doesn’t work. You must select Resource Assignments as Export Type.
Thanks alot, I will try it and hope it works out.
abd
Hi,
When you expert to excel and wish to change budgeted units you will need to include the resource assignment data which will appear on a separate tab. (You must specify which fields you wish to export in the export dialogue) If you are using multiple resources per task then there will be a row per resource so you will get the same task ID several times. The Task budgeted units will be made up as the total of these resource rows.
Most importantly, when you change the budgeted units in the assignments tab note that they are NOT numbers. The figures are text/charaters and are thus preceeded by a
If you just type in 10 for ten hours you will not succeed. You must enter 10
I suggest creating a dummy project with a few simple tasks and experiment with the process until you understand what works and what doesnt.
thank you very much for your response, what happened is that I iexported from p3e to xls file, I changed the budher hours in the xls sheet and imported it again into p3e, but no changes happened, I have not changed in the format, all I did is changeing the values,
this is the format of the heading when exported to Xls file. Budgeted Units(h)
the opostrophy is always at the left of the numbers only.
Hi,
If you are trying to export to excel sheet and import again to p3e, make sure that the format did not change especially for " " apostrophy in the beginning of the text & numbers.
Can u please cite an example what really happen in order for us to easily understand.
Arnold