New tutorial video on my youtube channel.

http://www.youtube.com/watch?v=s5sDVXEpvaM

Added a new rar file because the loader script is messing up a little bit. Soon I will be adding new options to the plugin if you have any good improvement advice I'll gladly hear it and consider it.

http://www.youtube.com/watch?v=KPMyWt8Rvps

Update: now the input rotations also work. The file is now downloadable as an extension package. You install the package via Sketchup.

The easiest way I can think of for storing information in an entity itself would be storing it in a dictionary. That is how I stored entity ID's. Hope it helps.

@glro said:

@farazforoozan said:

This is a brief manual if you're interested.

http://sketchucation.com/forums/viewtopic.php?f=323&p=459125#p459125

would it be convenient to enlarge the use of the plugin to openoffice spreadsheets?

The library does not support Open Office. Perhaps something to look in to for the future.

Domain Specific Tool SketchUp Manager

Latest update: 02-06-2013

This application is developed for SketchUp designers that want to automate SketchUp through MS Excel. Component data specified in Excel is pushed to SketchUp. After performing scaling, translation and rotation, the component data can be written back to Excel. Previously created shapes can be re-added in SketchUp and also written back to Excel.

Application improvements:
-Input rotation about the x, y and z axis does not work yet.
-Input number of items of a component does not work yet.
-Rotation output is still in radians.
-Dimension output is still of the bounding box of objects.
-Cone input parameters were Dim(y) and Dim(z). Needed to be Dim(x) and Dim(y)
-Rotation output seems different than input. I suspect because the rotations are merged in a transformation product and they are performed sequentially and the bounding box transformation object may be different. Performing rotation about x and y axis results also in a z rotation.

Potentially added to application:

• Cost analysis functionality.
• Bounding box envelope
• Variable metric system

1. Copy all files in the rar file to the plugins folder of SketchUp.
2. Open the Excel file.
3. Open SketchUp.

Sincerely,

Faraz

This is a brief manual if you're interested.

http://sketchucation.com/forums/viewtopic.php?f=323&p=459125#p459125

Domain Specific Tools SketchUp Manager.pdf

Dear SketchUp community,

I have developed a plugin where Excel and SketchUp are automated. Component information from Excel is fed to SketchUp and after performing functions on the components this data can be then fed back to Excel. I need some serious experienced sketchup developers to test this out and I just wanted to see how this plugin would be received in the community. You can contact me for information.

Within the file are enclosed an Excel Worksheet, an encrypted ruby file and a brief manual.

P.S. This is a beta version not all functionalities work as they are supposed to.

Faraz,