Record actual quantities
In the Open Standard
Eckart SchenckMember for 21 years 4 months
- Created
- 2
- 4
0
Hi,
The activities in my schedule are loaded with different resources (up to 3 resources per activity).
For recording progress by actual quantities I’m looking for a way to do it by importing from excel (using wk1).
example:
- activity: electrical installation
- Resources: Cable Tray, Cable, Panel
Esp. which headers do I need for the columns of the .wk1 file. I couldn’t figure it out from exporting.
Any idea/help will be very appreciated!
cheers
The activities in my schedule are loaded with different resources (up to 3 resources per activity).
For recording progress by actual quantities I’m looking for a way to do it by importing from excel (using wk1).
example:
- activity: electrical installation
- Resources: Cable Tray, Cable, Panel
Esp. which headers do I need for the columns of the .wk1 file. I couldn’t figure it out from exporting.
Any idea/help will be very appreciated!
cheers
2 replies
Oldest first- 0David Kelly ·Heinz,
Because the index of the resouce assignment table is resource AND cost account, it is important that you export both of these columns when creating your template.
Given that you can import either "this period" or "to date" manhours the actual hours field you export/import is important, as is the setting "link actual and to date" in the autocost rules. - 0Jose Frade ·Hello Heinz,
Take a look in RA and you will find all you need.
Note: RA is distributed with Primavera but not installed automatically from the CD.
You have to locate the RA directory in the CD and copy it into the P3WIN directory in you computer.
You have samples to use in Excell, Acesss, etc.
BR
JMFrade
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?