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.