Automated Excel 2 SketchUp PLUGIN
-
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
- Copy all files in the rar file to the plugins folder of SketchUp.
- Open the Excel file.
- Open SketchUp.
Sincerely,
Faraz
-
Interesting new way to make things...its like space programming lenguage
-
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.
-
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.
-
Update: now the input rotations also work. The file is now downloadable as an extension package. You install the package via Sketchup.
-
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...
-
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.
-
-
Lasagne = hedgehog ?
-
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
-
@unknownuser said:
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....
-
Just asking:
Should the title of this thread follow the format for other plugins? Like [Plugin], beta or not, numerical revision, date? -
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.
-
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.
-
New tutorial video on my youtube channel.
-
@farazforoozan said:
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
-
.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. -
@karljohan62 said:
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.
-
Does anyone know how to get this working for SketchUp 2014?
-
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.
Advertisement