Worksheet Automation

[rowbear97]

I'm working on a worksheet that has to pull data from existing parametric objects and various records attached to smart objects like borders and site models. I've been able to create a cells that pull information such as project name and project address from the Titleblock Manager yet I can't seem to crack the code on pulling the "Site Model" Cut, Fill, Net C&F Volumes. Any help in this matter would be greatly appreciated.

 

Thanks in advance for your time and consideration!

[Pat Stanford]

Parameter Fields for PIO: DTM6		
		
Display Name			Field Type	
__version				'DTM6'.'__version'						Integer
__UUID					'DTM6'.'__UUID'							Text
__messageID				'DTM6'.'__messageID'					Integer
2D Display				'DTM6'.'2D Display'						Text - Popup Menu Item
2D Style				'DTM6'.'2D Style'						Text - Popup Menu Item
3D Display				'DTM6'.'3D Display'						Text - Popup Menu Item
3D Style				'DTM6'.'3D Style'						Text - Popup Menu Item
Area Display Type		'DTM6'.'Area Display Type'				Text - Popup Menu Item
Projected Area			'DTM6'.'Projected Area (Existing)'		Static Text
Surface Area (Existing)	'DTM6'.'Surface Area (Existing)'		Static Text
Surface Area (Proposed)	'DTM6'.'Surface Area (Proposed)'		Static Text
Volume Display Type		'DTM6'.'Volume Display Type'			Text - Popup Menu Item
Volume (Existing)		'DTM6'.'Volume (Existing)'				Static Text
Volume (Proposed)		'DTM6'.'Volume (Proposed)'				Static Text
Cut Volume				'DTM6'.'Cut Volume'						Static Text
Fill Volume				'DTM6'.'Fill Volume'					Static Text
Net C&&F Volume			'DTM6'.'Net C&F Volume'					Static Text
Total C&&F Volume		'DTM6'.'Total C&F Volume'				Static Text
Total C&&F Volume		'DTM6'.'dontShowErrors'					Boolean
Total C&&F Volume		'DTM6'.'Site Model Name'				Static Text
Modifier Conflict Count	'DTM6'.'Error Count'					Static Text
Show Modifier Conflicts	'DTM6'.'Show Errors'					Boolean
Geometry Lowest Z		'DTM6'.'Geometry Zref'					Real - Coordinate Displacement

Note that all of the field are static text (probably with the unit marks included) so you will not be able to use them for calculation directly. You will need to strip the units and convert to a number to do calculations.

 

Sorry for the bad formatting.

 

 

[rowbear97]

@Pat Stanford Thanks. I will give this a go.