Trimble Business Center

A customer has asked for the following:

Would like to generate an Excel utilities report from TBC to go into Tilos. The alignments he refers to would be road CL as opposed to the Utility run itself. The following info is required:

Manhole

1. Task ID
2. Manhole Name
3. Manhole Chainage (Require offset either side of CL by a custom distance, this is so it visually shows in the Tilos programme
4. Manhole Alignment to report against
5. Network Name
6. Manhole Dia
7. Manhole Depth
8. WBS
9. Template Name (Determined from depth)

Pipe

1. Task ID
2. Pipe Name (From MH 1 = MH2)
3. Pipe Chainage against alignment Tilos programme
4. Pipe Alignment to report against (project area)
5. Pipe Dia
6. Trench width
7. Network Name
8. Average Pipe Depth
9. WBS
10. Templated name determined by the depth

Could use excel to do custom lookups & formulas to make the following fields

1. Task Name
2. Links from low to high inverts

Note that you can have a network on two or three different alignments.

The format would look like this:

Note that the customer has posted on the community already:

TBC Utilities Export to Tilos  

Perhaps a macro is the way to go?

Paul

Paul

It is possible to create an output like this, I guess the questions I have are the following

1) When do they need this

2) Are they prepared to pay for it to be developed

3)Is this related to a single project or is it something they want for many projects in the future?

All the data is there to be able to generate this type of report, so it is purely a resource availability, resource vs value question.

Alan 

Hi Alan,

There are potentially more projects. I'll PM you to discuss further.

Paul