CreateBlockTableTool
Tool |
With the create block table tool, you can create a live spreadsheet table of inputs and outputs based on normal Blockpad equations or a published block definition.
Block Tables are useful to explore different input scenarios with complicated equations. Instead of equations hidden away in many different spreadsheet cells, you can have the equations in normal Blockpad math notation and then transpose those equations to rows of different inputs and outputs in a table.
Create a block table from existing calculations:
- Have your calculations ready in a frame or section.
- In the toolbar, go to Blocks>Create Block Table.
- In the window that appears, select the file that contains the frame or section.
- On the right side of the window, select the frame or section that contains your calculations.
- Click OK.
- Specify the inputs and outputs.
- Click Create Block Table.
Create a block table from a published block definition:
- In the toolbar, go to Blocks>Create Block Table.
- In the window that appears, select the library that contains the block definition.
- On the right side of the window, select the block definition.
- Click Create Block Table.
Notes:
- Block tables are only available in Excel, using the Blockpad Excel add-in.
- Only certain kinds of library block definitions will work with block tables. Most scenario blocks will work.
See also:
You can refer to this tool in any formula, macro, module, or other script in Blockpad. You can use either its name or its full path:
-
To refer to it by name, use
CreateBlockTableTool
(make sure the library Library.Tools.Blocks is included with Include Libaries) - To refer to it by its full path, use
Library.Tools.Blocks.CreateBlockTableTool
See also: