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.
    • F Offline
      farazforoozan
      last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • F Offline
        farazforoozan
        last edited by

        New tutorial video on my youtube channel.

        1 Reply Last reply Reply Quote 0
        • 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
                                            • 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