Excellence
Prerequisites
- Microsoft® Windows®
- Microsoft® Excel® 2010 or later
- Compliance in the Cloud's Excellence add-in
Enable obfuscated layers
- Highlight the range of cells for which you wish to enable the obfuscation layer capability.
-
From the ribbon, click on the Enable Obfuscation icon.
-
Provide information for how this data should be obfuscated:
- Obfuscation Rule Name
- Identifies this set of layers within your workbook. It is recommended the name should reflect the nature of the data it is protected.
- Obfuscation Mode
- Serial number
- Replaces each unique value with a serial number. You have the option to define a prefix and/or a suffix to the serial number.
- Mask
- Replaces the value with a value that hides some or all of the data.
- Properties
- Allows you to customize how the obfuscation mode is to be applied to the original values in the worksheet.
-
Click on the button.
-
Select the desired protection method
-
If applicable, provide additional information in the box to the right of protection method selections.
-
Click on the button.
Serial number properties
- Prefix
- This is a text value that will appear before the serial number.
- Digits
- The number of digits in the serial number. For example, if you specify three digits, the resulting serial number will be a minimum of three digits long, using leading zeros when applicable.
- Suffix
- This is a text value that will appear after the serial number.
- Case Sensitive
- Consider you have two items, such as "Compliance in the Cloud" and "compliance in the cloud", which read the same but have different case characters. If this checkbox is enabled, the system will assign a unique serial number to each version, whereas if the checkbox is disabled, the system will assign the same serial number to both values.
Mask properties
The first two values are combined to split the original value into a number of segments, each of which can then be masked indepdently.
- Minimum Segments
- Allows you to define the minimum number of segements you expect to extract from each original value.
If the system finds more segments than you define here, the rule for the last segment is repeated for each additional segment.
- Segment Separator
- Specifies the character used to split the original value into segments.
- Mask Character
- Specifies the character that will replace a character character in the original value, when applicable.
The table allows you to define how to treat each segment of the original value.
- Segment
- Identifies the segment that the other fields in the row apply to.
- Keep First
- Specifies the number of characters from the beginning of the segment that will remain untouched.
- If Keep First = 5, the original value "AaBbCc123!#$" will retain the first five characters ("AaBbC") and only consider the remaining characters for obfuscation.
- Keep Last
- Specifies the number of characters from the end of the segment that will remain untouched.
- If Keep Last = 4, the original value "AaBbCc123!#$" will retain the last five characters ("23!#$") and only consider the remaining characters for obfuscation.
- Mask Uppercase
- Specifies whether uppercase characters are replaced (checked) or retained (unchecked).
- If Mask Uppercase = Selected, the original value "AaBbCc123!#$" will have the uppercase characters "A", "B", and "C" each replaced with defined mask character.
- Mask Lowercase
- Specifies whether lowercase characters are replaced (checked) or retained (unchecked).
- If Mask Lowercase = Selected, the original value "AaBbCc123!#$" will have the lowercase characters "a", "b", and "c" each replaced with defined mask character.
- Mask Digits
- Specifies whether digit characters are replaced (checked) or retained (unchecked).
- If Mask Digits = Selected, the original value "AaBbCc123!#$" will have the digit characters "1", "2", and "3" each replaced with defined mask character.
- Mask Special
- Specifies whether non-alpha/digit characters are replaced (checked) or retained (unchecked).
- If Mask Special = Selected, the original value "AaBbCc123!#$" will have the non-alpha/digts characters "!", "#", and "$" each replaced with defined mask character.