Jump to content
  • 0

Worksheet Automation


rowbear97

Question

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!

Link to comment

2 answers to this question

Recommended Posts

  • 0
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.

 

 

  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...