Archived - FusionSheeter

Important Notice:

**Due to a number of factors including updates to Google Security Policy, this has been "migrated."

You can find the new download here

I am still working on a few things and then will probably make the "new" source available as well.

Also looking to make some "installers" and a few other upgrades, but just getting to this point has been A TON of work.

For posterity:

Connect a Fusion 360 design to Google Sheets

NOTE: This sample is provided "As-is" with no guarantee of performance, reliability or warranty.

Installation

Download the add-in.

After downloading the zip file follow the installation instructions here for your particular OS version of Fusion 360

Usage

Documentation to come later. For now:

See a video here: https://youtu.be/dwWDpQSrz7o

There are 4 tabs (sheets) in the Sheets Document:

• Parameters
  • Header row defines parameter name in Fusion design
• BOM
  • If the design is an assembly you can edit Description and Number for all components
  • Note: It is based on name so you CANNOT rename components here
  • There is no concept of sizes or 'configurations' at the assembly level... yet
• Features
  • Allows you to control suppression state of features in a given 'size'
  • Note this is still a work in progress and may not always be reliable.
  • The biggest limitation is that if you add new features they cannot automatically be added to the sheet yet.
  • To add new features you need to add a column to the sheet that matches the feature name in the time line
• Display
  • You can create different sets of displayed/hidden combinations here
  • All parts should be listed in the header (with their 'full path' including parent and occurrence number
  • Note if you were using an older version of Sheeter you may not have this tab

Link Design to a Google Sheet

• Link to an existing sheet or create a new one.
• Choose either User Parameters or All Parameters. (All parameters is every dimension in the model)
• Link will persist with design document in Fusion 360

Sync with Google Sheet

• Select to Pull data from the Sheet document or Push data
• Push Data:
  • Select parameters and or BOM data
  • Parameters you can update the current size or create a new size
  • BOM data will over-write existing sheet data with current model data

Open Sheet

• Opens Sheet document in browser

Open Sheet in Fusion 360

• Opens the sheet document in the Fusion 360 window
• It can be convenient at times to do this, but it is sometimes difficult to navigate the sheets interface in this small window. I recomend using the external window.

Change Size

• At any given time, the current design is 'associated' to a row in the sheet.
• To change the associated row use this command to select another size
• The values you see in the drop down are driven from the 'Description' field

Change Display

• At any given time, the current design is 'associated' to a row in the Display sheet.
• To change the associated row use this command to select another display configuration
• Note if you were using an older version of Sheeter you may not have this tab

Capture Current Display

• This will capture the current hide/show state of all 'occurrences'
• Note: Hidden BODIES are not affected by this command
• You can create a new capture (row in the sheet) or update the existing one
• Also note the values in the spreadsheet are case sensitive TRUE and FALSE

Generate G Code for all sizes

• Will generate output nc code for all sizes in the associated Google Sheet
• Manually type in the name of the post to use (sorry)
• Select an output folder
• Choose the setups, Folders, or operations to export

Create Fusion 360 Design for all Sizes

• Creates a unique Fusion 360 design in your current project for each size
• Useful if you need to use the different sizes in individual drawings or assemblies

Export local file for all sizes

• Export 1 or more neutral file format types to a local directory
• Each size in the sheet will be exported

TODO / Enhancements:

• Push changes to time line to feature sheet
• Drop downs for post names in G Code

License

Samples are licensed under the terms of the MIT License. Please see the LICENSE file for full details.

Written by

Written by Patrick Rainsberry
(Autodesk Fusion 360 Business Development)

See more useful Fusion 360 Utilities