Automated Excel 2 SketchUp PLUGIN

[farazforoozan]

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

[farazforoozan]

Video

[srx]

Interesting new way to make things...its like space programming lenguage

[renderiza]

Hi, currently making a game for SketchUp and I am asking if this could be best solution for storing data. I have yet to workout how to store game stats, achievements & high-scores. Anyhow thanks for posting this I will experiment with it and see.

[farazforoozan]

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.

[farazforoozan]

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

[pilou]

Does this plug can works also with Open Office, or it's strictly Excel ?

Seems will be terrific also for any deformation of curves!
Morphing etc...

[Aerilius]

Looks like seahorse-lasagne morphing into a seahorse?

OLE is a Microsoft technology for interprocess communication. It seems Open/LibreOffice has some support for OLE (probably the other object linking and embedding) on the Windows platform to some extent, but I don't know if it's possible to extend this plugin to be less dependend on specific software.

Anyways, the description of the plugin could include requirements (I guess Microsoft Windows (version xy) and Microsoft Office Excel) and version. The video can be nicely embedded using the video tag.

[pilou]

Lasagne = hedgehog ?

[danielrohde]

Hi Faraz,

Great plugin, thanks a lot for sharing!
This could be really useful for me if the multiple component option works, what is the status on that? Looking forward to the next version...

Daniel

[Dave R]

Lasagne = hedgehog ?

I guess you could have hedgehog lasagne. I wonder how many it would take to feed a family of four

Interesting plugin idea. Hmmmm....

[mitcorb]

Just asking:
Should the title of this thread follow the format for other plugins? Like [Plugin], beta or not, numerical revision, date?

[skillz]

farazforoozan,

Thank you for developing this script! There's a lot of potential here, specially if you get pretty savy with the excel formulas. I am personally hoping to use this as a space planning tool.

It would be awesome if by simply imputting an area (M2, geometries can automatically be created. Also if the boxes can automatically be color coded according to a type or name.
great job! do you plan to continue its development?

Would you be open to collaboration on this particular script? I am not all that savy with code, but have very specific ideas on what I hope it can do. Please let me know if you can share your script and collaborate.

[farazforoozan]

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.

[farazforoozan]

New tutorial video on my youtube channel.

Video

[Karljohan62]

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

Hi and thanks for sharing this plugin with us.

I am new to Sketchup and I just wonder how the extention cab install via the Sketchup since the script has a .rbs ending and the only extention files Sketchup 2013 accepts are .rbz.

Is there something I have misunderstood here.

Cheers!~jmk

[massimo]

.rbs is a "scrambled" version of .rb, so you can just unzip the folder and put the content in SU's plugins folder like you do with a "normal" .rb file.
Also .rbz is a zipped .rb, so if you want you can rename it as .zip and then unzip it and put the content in plugins folder.

[Dave R]

and the only extention files Sketchup 2013 accepts are .rbz.

I wonder where this notion comes from. You aren't the first person who has written that here on the SCF forms. It isn't true, though. As Massimo wrote, you can drop the .rb file directly into the Plugins folder and restart SketchUp and it'll work.

In order to install the plugin via the Install Extension button, you do need a .rbz file.

You could rename the zip file to .rbz and use Install Extension, too.

[richyeah]

Does anyone know how to get this working for SketchUp 2014?

[Jim]

Because the source is scrambled, so no one can fix it except the author.

I've sent a message to the author about upgrading the extension, and hopefully he will reply here

In its current form, there is no reason to install this in 2014 because it will never work.

[duanekemp]

Can this be used to select/deselect layers on scenes?

For example: Keyframe animation of 400 frames at 25 fps. Animation is perfect. I want to add a blinking light on/off every half second. Can this be used to add that light component on/off to a group of 14 frames and off for 14 frames via this type of programming?

[danxx]

I would like to see this in action on 2015. Can I contact the author. please email me on mr.dpg[at]virgin.net

[aadbuild]

Hi guys this is cool. We just added excel export to Plusspec. There is a webinar on tomorrow at www.plusspec.com of you'd like to check it out.

[unearthed]

Great work Faraz, Can't wait to see how it runs

[mgsvinc]

Hello, i would like to use your plugin to control the positioning of my models.
The objects remain the same (there is no change of dimensions within those objects), the only values which I want to pilot from Excel are the positioning of these objects.

Could your plugin help me do this ?
If not, do you know a way to do this with your plugin (maybe by modifying the code)?
Or even better, do you know a plugin that can do it ?

Thank you for your time and for your work.

[Sekar24]

Hi, I am unable to use, as there was no menu in su 2017

[jackmartian]

Can this be used to select/deselect layers on scenes?
gb whatsapp
For example: Keyframe animation of 400 frames at 25 fps. Animation is perfect. I want to add a blinking light on/off every half second. Can this be used to add that light component on/off to a group of 14 frames and off for 14 frames via this type of programming?

May be I think you can adjust keyframe little bit more instead of 25 fps.

[wudier]

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

Thank you so much for sharing.

[thomascook]

Does this only work with MS Excel? Or it is comfortable with others. .

[LordSweeper]

Does this only work with MS Excel? Or it is comfortable with others. .

It does work with other software as well. But for better and suitable performance I would suggest you to use MS only.