We’ve developed a graphic programming tool for Revit, and decided it was time to update our Grasshopper Graphic Programming tool to work with similar spreadsheet formatting. The biggest change that we made is to be more forgiving in how the spreadsheet is formatted. The previous version required the spreadsheet to have certain columns present, markers to specify the start and end of data, and the definition would produce nothing if it came across a blank in the spreadsheet. The new version requires only a column named Room Name to be present in the spreadsheet and will then start producing masses once data is entered in that column. If the timer component is active in Grasshopper then the definition will dynamically update as information is entered into the spreadsheet.
Currently the definition is setup to search for columns named:
- Room Name
- Room Type
- Room Number
- Program Area
The column names are not case sensitive but spelling and spaces need to match. Additional column names can be added by modifying the format program data cluster. There are default values specified for all of the columns, and these values are used when no data is present. If Program Area is provided then the square root of the area is used if there are no Length and Width columns. If Length and Width are provided then these values will be used and the mass tag will show the Target Area (spreadsheet supplied value) versus the Actual area. There is also now the ability to sort the masses based on column names.
We’re currently using the TTToolbox Addin for Grasshopper to Read the Excel data. Other spreadsheet importers could be used but the data needs to be formatted into Columns as Paths. Take a look and let us know if you have any suggestions. Happy Programming!
Note: Make sure that the [Ws] input of the TTToolbox ReadExcel component is set to the appropriate sheet of the Excel file.