In the PARAMETRIC BOOKCASE tutorial, we covered how to create equations to use the parametric ability of Alibre to our advantage. In this tutorial we will link those separate parts--the back, the side and the shelf--to a common spreadsheet in order to easily change the overall dimensions of our bookcase.
This will take what would be a cumbersome model to use, and make it into a cohesive model that will allow us to crank out bookcase designs with amazing ease. Once you have completed this tutorial, you can take the bookcase model and make it your own by changing the construction to suit your construction methods. You will then have a re-usable template for designing bookcases.
You need to have a copy of the Microsoft Excel spreadsheet program on your computer. We use Excel versions 2000 and 2003 with Alibre, and the documentation states that Excel XP & 2007 will also work.. You need to install the Alibre Add-In for Excel using the information on page 220 of the Alibre Design 9.2 Users Guide.
You can drive multiple Parts and Assemblies in Alibre with Excel, as the information that links Alibre to the Spreadsheet is stored in the Parameter data inside the Alibre files. You can see the link to the external information if you export a parameter from the Equation Editor. You can not change this information internally to Alibre, but you can Relink again to the spreadsheet from Alibre if necessary. This is helpful if you save the model to a new location and want to point to a new copy of the spreadsheet, or a new spreadsheet all together.
The interface within Excel only allows you to specify the external link information within the Alibre file, and the spreadsheet has no record of what has been linked. While you can drive multiple Alibre files with a single spreadsheet, there can be only one spreadsheet specified for a particular parameter. However you can specify a different spreadsheet for another parameter should you have a need. You can also drive multiple parameters from the same spreadsheet cell, and you can select those multiple parameters for linking at the same time (see Users Guide).
When you use the Add-in within Excel, it compares the Alibre file you select with the values in the Spreadsheet (based on the cell mapping within Alibre). If a difference is found, the APPLY button becomes active, and by pressing the APPLY button, the values in the Spreadsheet are then applied to the linked parameter(s) in Alibre. Note that this is 'Spreadsheet Driven' design, where the spreadsheet can 'drive' values in Alibre. It is a 'one way' transfer of information and not a 'link' to between Alibre and a Spreadsheet. It is a method where a value within Alibre can be updated externally. The concept being that the user only needs to work with a simple columnar interface (a.k.a Excel Spreadsheet) to easily manipulate the data that determines the characteristics of the Alibre model.
We will now create a spreadsheet that will drive the values for our 5 defining parameters that determine the characteristics of our Parametric Bookcase. For all of our parts and the bookcase assembly as well.
Step 1: Create An Excel Spreadsheet
Create a new folder called SPREADSHEET BOOKCASE, open your Parametric Bookcase Assembly and use Save As to make a copy of the entire bookcase in the new folder. It is important that you make a copy of your model before proceeding, because once you link the Spreadsheet to your model, you will NOT be able to modify the Driving Parameters manually. You will want to retain a non-spreadsheet version for further lessons.
Create a new Excel Spreadsheet and Save it in the SPREADSHEET BOOKCASE folder as Bookcase.xls. I created a very simple spreadsheet with the Driving Parameter labels in Column A, and the values for those labels in Column B.
Before you can use the Excel add-in, you need SAVE the spreadsheet to the file system. The pathname has to be established BEFORE it can be used to fill in the Alibre parameter information. So Save the spreadsheet to the SPREADSHEET BOOKCASE folder.
You can create significantly more complex spreadsheets that will have all the values for every aspect of an entire cabinet job--or single cabinet. The same techniques will apply as with this simple example for the tutorial.
Once we have created and saved the spreadsheet to the file system, we now need to link the Alibre files to the spreadsheet and the appropriate cells. REMEMBER, we are linking Alibre to this spreadsheet, and not the spreadsheet to Alibre. However you use the Alibre Add-in to accomplish this task from within the Excel program.
I will briefly cover the material on pages 222 thru 224 of the Alibre Users Guide, with emphasis on the important points. Please refer to the Users Guide for more detailed information on this process.
You do not need to have Alibre Design running while initially setting up the spreadsheet--Alibre Design HAS to be running for the Add-in to function, so start Alibre Design if it is not currently running.
While it is useful to be able to set up the link to Alibre files from 'Active Sessions' button, or the 'Repository' button for the Professional and Expert versions, we will rely on the 'File System' button for this tutorial. The other methods work exactly the same, with the 'Active Sessions' working on already open files. When you select the 'File System' button, you can browse to locate the Alibre file you wantâI chose the Side to startâthen it will open automatically so you can link the parameters.