sketchucation logo sketchucation
    • Login
    ℹ️ Licensed Extensions | FredoBatch, ElevationProfile, FredoSketch, LayOps, MatSim and Pic2Shape will require license from Sept 1st More Info

    Automated Excel 2 SketchUp PLUGIN

    Scheduled Pinned Locked Moved Plugins
    35 Posts 28 Posters 144.1k Views 28 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • K Offline
      Karljohan62
      last edited by

      @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

      1 Reply Last reply Reply Quote 0
      • massimoM Offline
        massimo Moderator
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • Dave RD Offline
          Dave R
          last edited by

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

          Etaoin Shrdlu

          %

          (THERE'S NO PLACE LIKE)

          G28 X0.0 Y0.0 Z0.0

          M30

          %

          1 Reply Last reply Reply Quote 0
          • R Offline
            richyeah
            last edited by

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

            1 Reply Last reply Reply Quote 0
            • J Offline
              Jim
              last edited by

              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.

              Hi

              1 Reply Last reply Reply Quote 0
              • duanekempD Offline
                duanekemp
                last edited by

                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?

                Duane Kemp

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

                1 Reply Last reply Reply Quote 0
                • D Offline
                  danxx
                  last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • aadbuildA Offline
                    aadbuild
                    last edited by

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

                    Every building designed can be affordable & buildable, to help we built PlusSpec; VDC & BIM for Sketchup

                    https://www.plusspec.com

                    1 Reply Last reply Reply Quote 0
                    • U Offline
                      unearthed
                      last edited by

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

                      Growplan - People ∩ Plants ∩ Place

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

                      1 Reply Last reply Reply Quote 0
                      • M Offline
                        mgsvinc
                        last edited by

                        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.

                        1 Reply Last reply Reply Quote 0
                        • S Offline
                          Sekar24
                          last edited by

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

                          1 Reply Last reply Reply Quote 0
                          • J Offline
                            jackmartian Newcomers
                            last edited by

                            @duanekemp said:

                            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.

                            1 Reply Last reply Reply Quote 0
                            • S Offline
                              seosambad Newcomers
                              last edited by

                              There are many state sponsored game in India like Kolkata Fatafat and Lottery Sambad .These games are legal in 13 states of India and conducted by state governments. Lottery Sambad is the biggest one of these games.

                              1 Reply Last reply Reply Quote 0
                              • V Offline
                                vcbhfg Newcomers
                                last edited by

                                GB WhatsApp Download is one of the most popular WhatsApp mods for your device. This WhatsApp mod is a multi-account-friendly mod and much more.

                                GB Whatsapp Apk allows users to share their current location with friends. To begin with, you can use the option of automatic reply whenever you wish to respond to friends.

                                One of the most exciting features of GB Whatsapp Latest Version is the ability to purchase and use company-created themes.

                                1 Reply Last reply Reply Quote 0
                                • P Offline
                                  piperthomas4765h Newcomers
                                  last edited by

                                  @farazforoozan said:

                                  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

                                  Hello, The application is designed for SketchUp designers who want to automate SketchUp through MS Excel. It allows component data to be pushed from Excel to SketchUp, performs scaling, translation, and rotation, and writes the modified data back to Excel. Some improvements are needed, such as adding rotation about the x, y, and z axes and improving the output format. Potential additions include cost analysis, bounding box envelope, and variable metric system. To install the application, copy the files to the SketchUp plugins folder, open the Excel file, and launch SketchUp.

                                  1 Reply Last reply Reply Quote 0
                                  • G Offline
                                    gbws Newcomers
                                    last edited by

                                    @renderiza said:

                                    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.

                                    [url=​https://descargarwhatsplus.app]​https://descargarwhatsplus.app[/url]

                                    1 Reply Last reply Reply Quote 0
                                    • W Offline
                                      wudier Newcomers
                                      last edited by

                                      @farazforoozan said:

                                      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.

                                      1 Reply Last reply Reply Quote 0
                                      • T Offline
                                        thomascook Newcomers
                                        last edited by

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

                                        1 Reply Last reply Reply Quote 0
                                        • H Offline
                                          hazle123 Newcomers
                                          last edited by

                                          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?

                                          1 Reply Last reply Reply Quote 0
                                          • L Offline
                                            LordSweeper Newcomers
                                            last edited by

                                            @thomascook said:

                                            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.

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 2 / 2
                                            • First post
                                              Last post
                                            Buy SketchPlus
                                            Buy SUbD
                                            Buy WrapR
                                            Buy eBook
                                            Buy Modelur
                                            Buy Vertex Tools
                                            Buy SketchCuisine
                                            Buy FormFonts

                                            Advertisement