Another way is to organize the activities by resources.
Then, put a column for budgeted quantities. There, you can easily input the activities in the column provided and you can also use the Fill Cell feature if there are many similar quantities.
in addition to Shahul, 1st multi select the activities you want to add resources using ctrl+click or u can use ctrl+A to select all the activities then click Insert and Resource Assignment.
We are on the same boat when dealing with the latest version of Excel which it doesn’t support any of the output files of P3. Hence, we cannot utilize the import/export facility of P3 which is surely the quickest and easiest way to load resources. This is the reason I am still using MS Excel 2003 (its crude though)until now because it works both with P3 as well as with P6.
My suggestion: stick with MS Excel 2003 when using P3 to save a lot of headache.
There is a way if the activities have same resources you could use insert option , select resource assignment ,choose resource you want to enter followed by units per day or budgeted quantity . which is very easy step
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
Another way is to organize the activities by resources.
Then, put a column for budgeted quantities. There, you can easily input the activities in the column provided and you can also use the Fill Cell feature if there are many similar quantities.
Good luck
you are correct Neastor
hi shareff,
in addition to Shahul, 1st multi select the activities you want to add resources using ctrl+click or u can use ctrl+A to select all the activities then click Insert and Resource Assignment.
nes
Hi Shareef,
We are on the same boat when dealing with the latest version of Excel which it doesn’t support any of the output files of P3. Hence, we cannot utilize the import/export facility of P3 which is surely the quickest and easiest way to load resources. This is the reason I am still using MS Excel 2003 (its crude though)until now because it works both with P3 as well as with P6.
My suggestion: stick with MS Excel 2003 when using P3 to save a lot of headache.
Regards,
Louie
Hi shareef
There is a way if the activities have same resources you could use insert option , select resource assignment ,choose resource you want to enter followed by units per day or budgeted quantity . which is very easy step
Hai Shareef
Option 1
U Can Use RA Application Activity.Xls(U Can Find it in P3 Installtion CD) Which Will Work in New & Old Version
Option 2
If u Save the Export File in .DBF it Will work in Excel 2003
Regards
Anbin