Dual Dimension in Reports

[Gaspar Potocnik]

Is there anyway to have dual dimensions in Reports? I'm looking to have X and Y coordinates of symbols in both meters and feet.

Thanks

[michaelk]

Yes.

The worksheet will always want to show dimensions in document units. So you will need to do the conversion math.

Imperial to metric is easy. It's just a conversion factor.

Metric to imperial is more difficult, but not impossible. Basically it's like this:

1. Conversion factor to get inches.

2. ## DIV 12 to get feet

3. ## MOD 12 to get inches. Square this result and take the square root to avoid a negative value. (you don't want both the feet and inches to be negative)

4. Concatenate the two values with the imperial dimension formatting.

I'll attach an example of each. If you want to see how it's done, there is a webinar that should be posted to VSS soon. Until then you can see it here: http://verysmallgroup.com/santa-barbara-vectorworks/movies-and-stuff/worksheet-webinar-3.html

hth

mk

[Gaspar Potocnik]

Michael, thanks for your answer, made it happen.

Just one thing, in your video you are using " , " to space the CONCAT values, that didn't work for me, I had to usa " ; ", the same you are using in your files, is that a version issue?

Thanks again, and BTW great videos!

[michaelk]

Gaspar

Glad you got it to work.

I've never heard of using a semi colon. Are you using a localized version? 2014? 2013?

If you go to Paste Function? and then click on CONCAT, does the message at the bottom of the window say comma or semi colon?

mk

[Gaspar Potocnik]

I'm using 2014, don't if it is localized...

When I go into the paste function it shows commas, but it doesn't work. Also, when I opened your file it had semi colons, not commas...

[michaelk]

Is your version in Spanish or English?

[Gaspar Potocnik]

English...

[michaelk]

I looked at the file you sent back to me: Commas.

Strange

mk