# MultiStatus

Inserts an array of simulated LED status lights into the spreadsheet. The function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications. displays the specified bits from a control value as a single LED with two color states.

Inputs

The MultiStatus function has the following syntax:

MultiStatus(Value, Start Bit, Number of Bits, Reverse Order, Color 0, Color 1)

See the table for a description of the available parameters:

Parameter | Description
Value | Specifies the control value (-2147483648 to 2147483647; Default = 0). Note: Any number outside this value range is treated as 0 but does not cause the function to return #ERR.
Start Bit | Specifies the first bit of the control value (0 to 31; Default = 0).
Number of Bits | Specifies how many bits to display (1 to 32; Default = 10). Each bit corresponds to one LED.
Reverse Order | Determines which bit represents the least- significant bit of the array.
0 = OFF (default) | Right-most bit is the least-significant bit.
1 = ON | Left-most bit is the least-significant bit.
Color 0 | Sets the LED color used to represent a zero bit. (Default = 0xFF0000 (red), Max: 0xFFFFFF)
Color 1 | Sets the LED color used to represent a one bit. (Default = 0x00FF00 (lime), Max: 0xFFFFFF)

Note:

- Named colors can be selected using the color picker control in the Property Sheet. The color can also be specified as Cell References to another cell that returns a color value as a 24-bit number.
- Given red, green, and blue values in the range 0-255, an RGB color value can be calculated using the formula (red * 65536) + (green * 256) + blue. Expressed in hexadecimal, this is in the 0xRRGGBB format. For example, the hexadecimal constant 0xFF8020 translates to: red=255, green=128, blue=32.

Outputs

Results | LED status light elements.

## MultiStatus Example

A spreadsheet is configured as follows:

- A1 = EditInt(0,255)

- A2 = MultiStatus(A1,0,8,0,0xFF0000,0x00FF00)

If you increment the EditInt control in cell A1, you can observe how the MultiStatus function displays the binary representation of the cell it references (in this case, A1):