Blockpad has hundreds of built-in functions, ranging from basic functions like Sqrt() to those made specifically for engineering, like VlookupInterpolate().
This deep dive page is not an exhaustive list of all Blockpad functions, but it gives an overview of commonly used functions and an idea of how to use them.
The majority of Blockpad functions are made to work like conventional spreadsheet functions, e.g. If(), Vlookup(), AverageIf(), or Concat(). For these functions, you can typically reference the large amount of online content covering how best to work with them, in addition to Blockpad documentation.
Blockpad also makes it easy to define your own custom functions. Learn more in the calculations section of the deep dive.
Blockpad functions are stored in different libraries that are included in the program by default. You can view the libraries, and see all of the functions they contain, on the Blockpad library page under the Built-in section.
Further documentation on each function can be found on it's respective library page. The link provided in the tables below will take you to the page for that function.
Blockpad functions are built to work with units intelligence. In practice, this means different things for different functions.
For example, Sum() or Average() will automatically convert all inputs to the same output unit, but they need to all be compatible with each other (e.g. ft and m, or psi and MPa).
Other functions will only take specific units as an input. For example, the inputs for Sin() must have angular-compatible units.
The way functions work with units should be intuitive, but you can check the function documentation or the units page for information.
Blockpad includes standard, basic math functions like Sqrt(), Log(), and Abs(). Some of these are listed below.
|Sqrt()||Returns the square root of a number.|
|Log()||Returns the log of a number, given a base.|
|Ln()||Returns the natural log of a number.|
|Abs()||Returns the absolute value of a number.|
Blockpad includes built-in values. Unlike conventional spreadsheets, they are stored as values, not functions, so there's no need to follow them with parentheses.
|pi or π||The value for pi, i.e. 3.14159...|
|e||The value for Euler's number, i.e. 2.71828...|
|i or j||The imaginary number, i.e. the square root of negative one.|
Blockpad includes all trigonometric and and hyperbolic functions.
The inputs for trig functions are expected to have an angular unit (rad or deg). If no unit is provided, the input will be interpreted as radians.
The inputs for inverse trig functions are expected to be unitless and in the range acceptable for that function (e.g. between -1 and 1 for acos()). The outputs for inverse trig functions are given as radians, but can be converted to degrees using the to keyword.
Trigonometric functions also work with complex numbers.
|Sin()||Returns the sine of an angle.|
|Cos()||Returns the cosine of an angle.|
|Tan()||Returns the tangent of an angle.|
|Asin()||Returns the arcsine of a number as an angle between -pi/2 and pi/2.|
|Acos()||Returns the arccosine of a number as an angle between 0 and pi.|
|Atan()||Returns the arctangent of a number as an angle between -pi/2 and pi/2.|
|Atan2()||Returns the arctangent of given (x, y) coordinates as an angle between -pi and pi, not including -pi.|
|Csc()||Returns the cosecant of an angle.|
|Sec()||Returns the secant of an angle.|
|Cot()||Returns the cotangent of an angle.|
|Sinh()||Returns the hyperbolic sine of an angle.|
|Cosh()||Returns the hyperbolic cosine of an angle.|
|Tanh()||Returns the hyperbolic tangent of an angle.|
|Asinh()||Returns the hyperbolic arcsine of a number as an angle between -pi/2 and pi/2.|
|Acosh()||Returns the hyperbolic arccosine of a number as an angle between 0 and pi.|
|Atanh()||Returns the hyperbolic arctangent of a number as an angle between -pi/2 and pi/2.|
|Compatible()||Tests if two numbers have compatible units (e.g. both are lengths) and returns true or talse.
|Magnitude()||Returns the unitless magnitude of a number with units.
***The preferred method for "stripping" units is found on the units page
|Unit()||Returns the units stored with a number.|
|UnitConvert()||Converts a number to different units. (e.g.
The to keyword is typically preferable (e.g.
|Round()||Returns a value rounded to a specified number of digits.|
|RoundDown()||Returns a value rounded down to a specified number of digits.|
|RoundUp()||Returns a value rounded up to a specified number of digits.|
|RoundSigFigs()||Returns a value rounded to the specified number of significant figures.|
|Derivative()||Returns the derivative of a function.
|Integral()||Returns the definite integral of a function, given start and end points.
The output for Derivate() is a function that can be used in formulas. Just reference the result, and use it like a normal function.
Also note that the units of the bounds for the Integral() function have an impact on the result, but you must make sure the units of the function all work out.
|Interpolate()||Classic interpolation - returns a y value given an x value and pairs of x and y (x1, x2, y1, y2).
|VlookupInterpolate()||Returns an interpolated value, given a lookup value, an array or range, and a column index.
|HlookupInterpolate()||Returns an interpolated value, given a lookup value, an array or range, and a row index.
|Interpolate2D()||Returns a value given a row lookup value, a column lookup value, and an array or range.|
Note: VlookupInterpolate() and HlookupInterpolate() are stored in the Lookup library, and not the Math library.
In addition to solver sections, Blockpad has a GoalSeek() function for finding numerical solutions to single variable functions.
|GoalSeek()||Returns the value that when plugged into the given function, yields the desired solution.
The first input for GoalSeek() is a single variable function, which can be either a named custom function or an inline function. The second input is the desired result for that function, and the output is a value of the function variable that would yield that result.
Because GoalSeek() is a numerical solver, it does not provide all solutions to an equation, only one.
For the most part, Blockpad logic functions work like conventional spreadsheet logic functions.
You can read more about boolean operations in the Logic and boolean values section of the deep dive.
|Not()||Returns true if given false, and false if given true.
|And()||Returns true if all inputs are true, and false if any are false.
|Or()||Returns true if any inputs are true, and false if none are true.
|Xor()||Returns true if there are an odd number of true inputs.
The Blockpad If() function
works just like the If() function in conventional spreadsheets.
Given a boolean value, it returns one thing if true, and another thing if false.
If(5>0, "positive", "negative") = "positive"
When used in dynamic equations, the If() function is displayed as a logic table.
When chained If() functions are used, the logic table continues.
If(condition1, result1, If(condition2, result2, resultIfConditionsNotMet))
These logic tables can be read as "Return A, if X condition is met; Return B if Y condition is met; etc". The example below could be read as "k_c = 1 if loading type is bending; k_c = 0.85 if loading type is axial; etc."
The actual formulas for chained If() functions can get very long. To break them up and make them easier to read, you can use shift+enter in the formula to create a new line.
It can also be helpful to use the visual editor.
Blockpad text functions are mostly modeled after conventional spreadsheet text functions, with some different functions available.
Find more on text values in the text values section of the deep dive.
|Concat()||Returns the given text values combined as one text value.
|Left()||Returns a specified number of characters from the left of a given text value.
|Right()||Returns a specified number of characters from the right of a given text value.
|Mid()||Returns a specified number of characters from the middle of a text value, given a starting point.
|Len()||Returns the number of characters in a given text value.
|Text()||Returns the given value as text.
|Value()||Returns a parsed number value from a given text value.
|Trim()||Returns all spaces from a text value except single spaces between characters.
|Upper()||Returns a given text value in all upper case letters.
|Lower()||Returns a given text value in all lower case letters.
|Replace()||Returns a text value with a given sub-string replaced with a different sub-string.
|Find()||Returns the starting location of a text sub-string in a given text value. Case sensitive.
|Search()||Returns the starting location of a text sub-string in a given text value. Not case sensitive.
|TextJoin()||Returns a text value created from a given array, with a delimiter between each item.
|TextJoin2()||Returns a text value created from a given array, with a different delimiter between columns and rows.
|TextSplit()||Returns a one dimensional array created from splitting a text value at the given delimiter.
|TextSplit2()||Returns two dimensional array created from splitting a text value into columns and rows based on the given delimiters.
|Unicode()||Returns the unicode value of the first character in a given text value.
|Char()||Returns the character of a unicode value (given as a unitless number).
Table of Contents
- Start a new document
- Dynamic equations
- Unit tracking
- Value names
- Reference unnamed values
- Text values
- Other value types
- Referencing a value
- Value name rules
- Names used multiple times
- Renaming and auto-updated references
- Built in values
- Visual editor
- Math layout options
- Show steps and more
- Value formatting
- Text values
- Date and time arithmetic
- Logic and Boolean values
- Matrices and arrays
- Enter an array or matrix
- Array names
- Matrix calculations
- Arrays - more than just numbers
- Array formulas in spreadsheets
- Array parentheses lookup
- Advanced array functions
- Complex numbers
- Spreadsheet in a file
- Sort and filter
- Conditional formatting
- Blockpad specific features
- Open a CSV file
- Mini-spreadsheets in a document
- Reports in a file
- Reference values from other reports in a file
- Header and footer
- Misc. document formatting
- Start a drawing
- Drawing objects
- Lines, points, and shapes
- Text labels
- Linear dimension labels
- Selecting multiple objects
- Ordering objects
- Using the point snapping
- Points you can snap to
- Horizontal and vertical from points
- Parallel or perpendicular lines
- Point snap options
- Transformations - resizing and moving
- Format drawings
- Keyboard input and canvas scales
- Notebooks in a file
- Reference values from other top level frames
- Working in a notebook
- Notebook pages
- Top level frames
- Frames in Frames
- Value containers and location
- Frames and sections are containers
- Containers inside containers
- Dot notation to specify a value in a container
- Capture values
- What is a block?
- Block example
- Use the block results
- Block inputs
- View block as table
- Block instances and block definitions
- More examples
- Create a block
- When to make a block
- Make a block with Blockpad calculations
- Update a block definition
- Create a block using scripts
- Block tables
- Examples library
- Use library items in a document
- Use the long form library item name
- Assign a shortcut name to the library
- Include a library in a file
- Use a library number value
- Use a library function
- Use items in a library frame
- Use a library data table as function
- Use library blocks
- Core, built-in, and subscription libraries
- Create personal libraries
- Save items to your library
- Manage your library online
- Library subscriptions
- Console basics
- Read values from the console
- Overwrite values from the console
- Use read and write to manipulate values
- Assign units to numbers in a cell range
- Stemscript basics for scripts
- Module functions
- Accessing Blockpad
- Using the app
- The online environment
- The desktop environment
- Other file types
- Program updates
- Company management