Hi All,
I have created some Activity Codes to be assigned for accounting purposes. The first stage was easy as there were only 8 groups and maybe 5 or 6 codes within each group.
Sample: Code Value Description
2 Tailings/BPF Area 2.1 C-12394-01-02-05-07 2.2 C-12394-01-02-05-06 2.3 C-12394-01-02-04-04 2.4 C-12394-01-02-05-07 2.5 C-12394-01-02-05-07 2.6 C-12394-01-02-06-03 2.7 C-12394-01-02-04-06 but now the request is to expand the listing and groupings to an additional level as below:2 2Tailings/BPF Area2.1C-12394-01-02-05-062.1Bulk Earthworks BPF area2.1C-12394-01-02-05-062.1.1Bulk excavation of BPF pad & roads areas to subgrade - spoil to material to Water treatment plant area (Subject to remeasure against actual)2.1C-12394-01-02-05-062.1.2Excavate and trim Drain A2.1C-12394-01-02-05-062.1.3Excavate and trim Drain B2.1C-12394-01-02-05-062.1.4Supply, Place, Compact and trim pavement to BPF Pad & roads2.1C-12394-01-02-05-062.1.5Supply & Installation of culverts & head walls to Drain A & B2.1C-12394-01-02-05-062.1.6Supply, place geofabrics & rock works to Drain A & Drain B outlets2.1C-12394-01-02-05-062.1.7Supply and installation drain A Gabion wall2.1C-12394-01-02-05-062.1.8Form road side safety bunds2.1C-12394-01-02-05-062.1.9Excavate, form and pour concrete spoon drain2.1C-12394-01-02-05-062.1.10Drainage bund at CV10972.1C-12394-01-02-05-062.1.11Supply and Installation of conduit services (Subject to remeasure against actual)
How can I upload the codes spreadsheet?
Thanks,
Rod
yes this can do a whole lot such as creating WBS, activity code dictionary, adding resources , printing calendars etc
hi Zoltan, excellent!this tool answers some of my other questions as well.
Much appreciated.
Rod
sdk is no longer supported I use Ranga whihc is an excel add in you can build activity code dictionaries as well was a wbs
https://prevara.tech/features-planning-tools/
Hi Rodel,
Yes, I was thinking about SDK last night. I have created an odbc to my dB but haven't yet explored the connection any further than running some basic queries.
Xer parser has been difficult to run, I think I had to go back to excel v10 or something but I do have the codes already in Excel.
Excellent ideas, thanks mate, I'll let you know how I go.
There are two options that you can use.
1) Option 1 - Using SDK (excel) - you can import/ upload Global, EPS or Project if you have SDK setup on your machine.
2) Option 2 - Using XER Builder/ parser - You need to have a deep knowledge on P6 database to do this. You can build your Activity codes library Global, EPS or Project by creating XER with Activity Codes library
are the pics displaying? They are showing when I select Edit but not when posted. ???
Sorry, here are screen shots:
and
the text is the related activity name