A hash is a function that converts one value to another. Hashing is used to index and retrieve items in a database because it is faster to find the item using the shorter hashed key than to find it using the original values. Hashing is a natural fit for cryptography because it masks the original data with another value. A hash function can be used to generate a value that can only be decoded by looking up the value from a hash table.
Sheetkraft has its own .sk function – ComputeHash.sk which creates hash from an input using a specified hash algorithm.
How to use the function ComputeHash.sk?
Suppose you want to create hash for a specific input. (See figure below)
In your preferred cell (where you want the hash value to be generated) type “ =ComputeHash.sk( ” and press the Function(fx) button . The following dialogue box opens up.
In the section Value, browse and choose the cell which contains your input. (Cell B2 in this case)
In the section Algorithm, input the type of algorithm that would be used to hash. (Some of the different types of algorithms are SHA1, MD5, SHA256, SHA384, SHA512)
In the section Input Type, you need to need enter input format type. Generally it defaults to text.(Other types of Input supported are – Base64, Hex.)
In the section Output Type, you need to enter output format type. Generally it defaults to Base64. (Other types of Output supported are – Hex.) Following the above steps the dialogue box should look like the following. (See figure below)
Clicking on OK generates our output, i.e. our hash.