Automated Excel 2 SketchUp PLUGIN

Automated Excel 2 SketchUp PLUGIN

Postby farazforoozan » Sun Feb 24, 2013 8:48 pm

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
3
Last edited by farazforoozan on Sun Jun 02, 2013 5:20 pm, edited 6 times in total.

farazforoozan 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby farazforoozan » Tue Mar 05, 2013 11:31 pm

0
Last edited by farazforoozan on Wed Mar 06, 2013 9:13 pm, edited 1 time in total.

farazforoozan 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby srx » Wed Mar 06, 2013 9:36 am

Interesting new way to make things...its like space programming lenguage :thumb:
0
www.saurus.rs
User avatar
srx 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby renderiza » Wed Mar 06, 2013 12:16 pm

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.
0
User avatar
renderiza 
Premium Member
Premium Member
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby farazforoozan » Wed Mar 06, 2013 1:06 pm

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

farazforoozan 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby farazforoozan » Wed Mar 06, 2013 2:59 pm

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

farazforoozan 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby pilou » Wed Mar 06, 2013 3:28 pm

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

0
Frenchy Pilou
Is beautiful that please without concept!
Speedy Galerie
User avatar
pilou 
Top SketchUcator
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby Aerilius » Wed Mar 06, 2013 8:51 pm

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

Aerilius 
PluginStore Author
PluginStore Author
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby pilou » Wed Mar 06, 2013 9:22 pm

Lasagne = hedgehog ? ;)
0
Frenchy Pilou
Is beautiful that please without concept!
Speedy Galerie
User avatar
pilou 
Top SketchUcator
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby danielrohde » Thu Apr 18, 2013 11:33 am

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
0

danielrohde 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby Dave R » Thu Apr 18, 2013 12:57 pm

Pilou wrote:Lasagne = hedgehog ? ;)


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

Interesting plugin idea. Hmmmm....
0
%

(THERE'S NO PLACE LIKE)

G28 X0.0 Y0.0 Z0.0

M30

%
User avatar
Dave R 
Global Moderator
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby mitcorb » Thu Apr 18, 2013 1:06 pm

Just asking:
Should the title of this thread follow the format for other plugins? Like [Plugin], beta or not, numerical revision, date?
0
I take the slow, deliberate approach in my aimless wandering.
User avatar
mitcorb 
Top SketchUcator
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby skillz » Thu May 16, 2013 4:08 am

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

skillz 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby farazforoozan » Sun Jun 02, 2013 5:22 pm

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

farazforoozan 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby farazforoozan » Wed Jun 12, 2013 10:02 pm

New tutorial video on my youtube channel.

0

farazforoozan 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby Karljohan62 » Wed Jul 31, 2013 8:58 am

farazforoozan wrote: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
0

Karljohan62 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby massimo » Wed Jul 31, 2013 9:41 am

.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.
0
User avatar
massimo 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby Dave R » Wed Jul 31, 2013 10:48 am

Karljohan62 wrote: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.
0
%

(THERE'S NO PLACE LIKE)

G28 X0.0 Y0.0 Z0.0

M30

%
User avatar
Dave R 
Global Moderator
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby richyeah » Wed Mar 05, 2014 3:53 am

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

richyeah 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby Jim » Wed Mar 05, 2014 9:55 am

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

Jim 
Global Moderator
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby duanekemp » Sat Apr 18, 2015 12:13 pm

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?
0
Duane Kemp

Kemp Productions
Puidoux, Switzerland
Gallery:
https://duanekemp.artstation.com/
User avatar
duanekemp 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby danxx » Mon Sep 07, 2015 11:37 pm

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

danxx 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby aadbuild » Tue Feb 23, 2016 10:34 am

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.
0
Every building designed can be affordable & buildable, to help we built PlusSpec; VDC & BIM for Sketchup

https://www.plusspec.com
User avatar
aadbuild 
Premium Member
Premium Member
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby unearthed » Tue Feb 23, 2016 11:38 am

Great work Faraz, Can't wait to see how it runs
0
Growplan - People ∩ Plants ∩ Place

windows 7 64b, 4GB RAM, SU 8.0.16846
Gimp, QGIS, Vectorworks 12, Bricscad 11

unearthed 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby mgsvinc » Tue Apr 03, 2018 2:52 pm

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

mgsvinc 
 

Re: Automated Excel 2 SketchUp PLUGIN

Postby Sekar24 » Wed Mar 20, 2019 6:06 pm

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

Sekar24 
 

SketchUcation One-Liner Adverts

by Ad Machine » 5 minutes ago



Ad Machine 
Robot
 



 

Return to Plugins

Who is online

Users browsing this forum: 20ness78, amkdm, bc_arkitekt, fab taf, Gaudi1985, kostiaarh and 32 guests

Visit our sponsors: