Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to upload a set of Activity Codes?

No replies
Rodney Jones
User offline. Last seen 1 day 16 hours ago. Offline
Joined: 17 Jun 2012
Posts: 62
Groups: None

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 Area
2.1C-12394-01-02-05-062.1Bulk Earthworks BPF area
2.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 A
2.1C-12394-01-02-05-062.1.3Excavate and trim Drain B
2.1C-12394-01-02-05-062.1.4Supply, Place, Compact and trim pavement to BPF Pad & roads
2.1C-12394-01-02-05-062.1.5Supply & Installation of culverts & head walls to Drain A & B
2.1C-12394-01-02-05-062.1.6Supply, place geofabrics & rock works to Drain A & Drain B outlets
2.1C-12394-01-02-05-062.1.7Supply and installation drain A Gabion wall
2.1C-12394-01-02-05-062.1.8Form road side safety bunds
2.1C-12394-01-02-05-062.1.9Excavate, form and pour concrete spoon drain
2.1C-12394-01-02-05-062.1.10Drainage bund at CV1097
2.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