I’ll warn you now it can get a little tedious, because you refer to the data in a spreadsheet like referencing variables in a Python script. In most fields you can type in a dimension, you can click a formula button or hit the = key and then type in a formula. Or you can reference a cell in a spreadsheet. that might look like “=spreadsheet.A4” for the contents of cell A4.
That isn’t very readable and I don’t trust it not to break if you add rows or columns or whatever, so there’s an Alias function. You can give each individual cell a name. Which is slow and tedious. In the Addon Manager you’ll find some macros, one called EasyAlias which, select a cell, click the EasyAlias button, and the cell to the right of your selected cell gets the contents of the selected cell as an alias. In other words, if Column B is a bunch of labels and column C is the actual data, highlighting B2-B17 and clicking the EasyAlias button will automatically alias C2-C17. That feature should be built-in. There’s also a macro for clicking a dimension, clicking a sketch feature, and then semi-automatically applying a dimension. It’s slightly temperamental but it works faster than typing “Dimensions.notch_height” over and over.
I’ll warn you now it can get a little tedious, because you refer to the data in a spreadsheet like referencing variables in a Python script. In most fields you can type in a dimension, you can click a formula button or hit the = key and then type in a formula. Or you can reference a cell in a spreadsheet. that might look like “=spreadsheet.A4” for the contents of cell A4.
That isn’t very readable and I don’t trust it not to break if you add rows or columns or whatever, so there’s an Alias function. You can give each individual cell a name. Which is slow and tedious. In the Addon Manager you’ll find some macros, one called EasyAlias which, select a cell, click the EasyAlias button, and the cell to the right of your selected cell gets the contents of the selected cell as an alias. In other words, if Column B is a bunch of labels and column C is the actual data, highlighting B2-B17 and clicking the EasyAlias button will automatically alias C2-C17. That feature should be built-in. There’s also a macro for clicking a dimension, clicking a sketch feature, and then semi-automatically applying a dimension. It’s slightly temperamental but it works faster than typing “Dimensions.notch_height” over and over.
That’s very helpful, thanks