Import Cost from excel to primavera 6

Did you like this Video? Join us in Planning Engineer Website where we have specialized training courses for planning and scheduling. courses link: bit.ly/2yVJ3z2
How to import budget cost from excel to primavera and avoid common mistakes.
---------------
Keep in Touch:
Join our email Newsletter, we send useful free content regularly: planningengineer.net/newsletter/
WhatsApp: [phone]
Email: [e-mail]
Linked in: / planning-engineer-est
FaceBook Page: / planningengineerdotnet
FaceBook Group: / 1138400132963230
Twitter: / planningeest
Instagram: / planningengineerest
---------------

[@motorcycle.journal]

Helpful video, thanks for sharing.

[@peterharbman]

Good job! This is very helpful. So updating the budgeted units updates the budgeted cost.

[@ahmedayoub8105]

Very Excellent 🌺🌹

[@mothilalkanagaraj7820]

Thanks - i did and complete my job

[@318482]

Omar , you need to go to your setting in resource and select unit and change it to 1 instead of 8 per hour and also make sure your max uni is 1

[@magedmetry6575]

thanks too much for the review and valued information

[@muthuxs]

Very Nice regd MuthuPMP

[@aminalmosharaf9675]

very nice

[@PlanningengineerNet]

Thanks

[@racielbautista6510]

Hi, I believe that you should order the ID activities for copy the dates

[@318482]

Hello , In order to avoid changing duration you need to go to the project before assigning resource and in resource setting , uptick Drive activity be default

[@benaragon12]

So do you add an additional resource (CostPlanning) on top of the resource that is aleady assigned? Or can you use the reosurce that ois already in there?

[@serkanbal847]

Omar, probably your resource isnt "material" resource type. then it multiples with 8 hours.

[@MUHAMMADQASIM-kk1ts]

Hello! i am a young planner and i have a couple of questions regarding this topic;
1. Would you please elaborate the difference between the expense loaded from BOQ and the cost loaded for resources.

[@STCRM78]

Hello, nice work! Congratulations!!
Please, let me ask you this: In your excel file "WBS-Activity-List-Full.xlsx"
Q1. What is the complete name of the cell A3 ("BOQ..?")? And what it is referred to those letters ("A, B, C", etc)?
Q2. What information do you have in the column B, "DIV"? Why is it useful?
Thank you!

[@fas-yt765]

i got a better idea by watching this

[@AK2Auburn]

Is there any reason you wouldn't want to do this with something as simple as the default "budgeted total cost" or something like that?

[@carlodigma5128]

Hello, Thanks for the information again, but why when I export from p6 to excel the arrangement of activity ID was not in order, Do I need to fix the save excel before importing to P6. Its says the application has been intercepted please note the event code for reference. Event code TP CAT-3080-C. Thanks and God bless.

[@OmarShahin.]

When im importing the budgeted total cost , the budgeted total cost in primavera is multiplying by 8 i dont know why ? Please help . Thank you

[@albertthomas398]

But, is this the right way to add cost to activities? Typically it has to be by adding labor / material / Expenses to each activity. And that will drive the cost of the activities.

[@rajeshsukumar1087]

hi ,i need a help ,when iam importing an excel file to primavera iam geting an error message that "The User Preferences used to create this Excel file are not the same as your current preferences. Importing this file could corrupt your data"

[@qobla_worgbah]

Am getting the same message ,when i try importing same.Any Help

[@archiemaddy5122]

My budgeted cost shows 0 after importing. Please help.

[@ilichsalazar9019]

I have the same problem????

[@colleeno4929]

When I get to the end of this video, at time 6:51 when I try to import from excel to Primavera, I do not have any options for Projects to import to. Does anyone know how to remedy this?

[@MrAgummer]

you need to be an administrator on the OBS for that project.

[@adacorte1]

Co

[@muhammadsarkar4778]

Brother, How can I get all of your lessons?

[@jechp1344]

It does not work with decimals... Any suggestion?

[@nisanthchaithanyasasidhara8697]

How to import manhours from excel to primavera

[@ahmadaltayeb1983]

Dear Sir
I had a problem in Primavera P6, the problem is Performance % Complete and Schedule % Complete, can not roll up to Project level, but it is already rolling up to WBS Level, and please note that I already assign materials on activities.
Please anyone can give advice, to solve this problem, I use Ver. 19.12 and Ver. 21.12.
Thanks

[@sohambandyopadhyay1911]

The moment I assign a 0 bugeted hour resource , all durations come to 0