Blockpad add-in for Excel

At this time, the Blockpad add-in for Excel has two main features:

  • The Blockpad custom Excel function
  • Block tables

Blockpad function

The Blockpad function runs Blockpad formulas within Excel. For example:

 

Note that due to limitations with Excel, only a raw number (without units) or text can be returned with the result. Be careful that you are getting the result units you expect. It's a good idea to specify a result unit by adding ... to m, ... to kip*ft, etc. to the end of each formula.

You can also pass outside values into the Blockpad function, internally using variable names p1, p2, etc. For example:

Block tables

A block table is a feature to quickly run a batch of Blockpad calculations. See the getting started page for instructions.