AYSSAR DATA LENS™USER GUIDE
TABLE & COLUMN SELECTION
TABLE NAME
List all Table Names within the Scanned Worksheet, including both visible and hidden
Tables.
Scanning a Worksheet is required before its Tables can be loaded into the Table
Drop-Down List.
Table Names are obtained from Table Design Tab ➜
Table Name.
Table Names are displayed in the Table Drop-Down List according to their internal
Order (Index) within Microsoft Excel.
Clicking the Locate Button locates the selected Table within the Worksheet, selects
the entire Table (including the Header Row, Data Body Cells, and Total Row, if
present), and brings it into view.
COLUMN NAME
Lists all Column Names within the selected Table, including both visible and hidden
Columns.
Selecting a Table is required before its Columns can be loaded into the Column
Drop-Down List.
Column Names are obtained from Table Header Row.
Column Names are displayed in the Column Drop-Down List according to their Order
(Index) within the Table, from first to last.
Completely hidden Columns are displayed in
Orange.
Clicking the Locate Button locates the selected Column within the Table, selects the
entire Column (including its Header Cell (Column Name), Data Body Cells, and Total
Cell, if present), and brings it into view.
THINGS TO KNOW ABOUT SELECTIONS
✔ Symbol indicates the currently selected Table
or Column.
Hovering over a Table or Column whose name is too long to fit within the available
space will automatically scroll the complete name, allowing it to be viewed in full.
Changing the selected Table or Column from Drop-Down Lists does not clear the
currently displayed Analysis Results, if any.
Changes made to Worksheet, Tables, or Columns after scanning the Worksheet are not
reflected automatically in the Drop-Down Lists. New Scan is required.
Table or Column cannot be located (selected) if:
Worksheet is no longer the Active Worksheet.
Worksheet has been renamed or protected.
Table has been deleted or renamed.
Table Structure has been modified by adding or deleting Rows or Columns.
Table has been repositioned within the same Worksheet or moved to a different
Worksheet.
Column has been deleted or renamed.
Column has been repositioned within the same Table or moved to a different Table.
Table or Column is completely hidden.
Connection between AYSSAR DATA LENS™ and Microsoft Excel is interrupted.
An unexpected error occurs during the Locating Process.
ACTION BUTTONS
SCAN WORKSHEET
Scans the currently Active Worksheet and detects all Structured Tables available
within it, including visible and hidden Tables.
Loads all detected Table Names into the Table Drop-Down List and loads the
corresponding Columns into the Column Drop-Down List.
Worksheet Scanning may not be completed if:
AYSSAR DATA LENS™ is not running within a recognized and valid Microsoft Excel
Worksheet.
Worksheet contains no Structured Tables.
Connection between AYSSAR DATA LENS™ and Microsoft Excel is interrupted.
An unexpected error occurs during the Scanning Process.
Only Structured Tables are recognized during Worksheet Scanning. Cell Ranges are not
treated as Structured Tables.
Structured Table is inserted from Insert Tab ➜
Tables.
Changing the Active Worksheet may require performing a New Scan on the newly Active
Worksheet.
ANALYZE COLUMN
Analyzes the currently selected Column within the selected Table.
Analysis is performed on all Cells within the selected Column, including visible,
hidden, and filtered-out Cells.
Header Cell (Column Name) and Total Cell, if present, are excluded from the
Analysis.
Analysis Modes:
Quick Analysis:
Default Analysis Mode; Optimized for speed and everyday use.
Evaluates and displays the overall uniformity of Format Types, Formula Expressions,
and Data Validation Rules without collecting detailed information.
Does not identify individual Format Types, Formula Expressions, or Data Validation
Rules, nor the ranges in which they occur.
Requires less time and memory than Deep Analysis.
Recommended when an overall and rapid investigation of a Column is required.
Deep Analysis:
Advanced Analysis Mode; Optimized for comprehensive structural Analysis.
Evaluates and displays the overall uniformity of Format Types, Formula Expressions,
and Data Validation Rules while collecting detailed information.
Identifies each Format Type, Formula Expression, and Data Validation Rule, together
with the corresponding Cell Ranges and Cell Counts.
Requires more time and memory than Quick Analysis.
Recommended when a detailed investigation of a Column is required.
Column Analyzing may not be completed if:
Table or Column is not selected.
Scanned Worksheet is no longer the Active Worksheet.
Scanned Worksheet has been renamed.
Table has been deleted or renamed.
Table Structure has been modified by adding or deleting Rows or Columns.
Table has been repositioned within the same Worksheet or moved to a different
Worksheet.
Column has been deleted or renamed.
Column has been repositioned within the same Table or moved to a different Table.
Connection between AYSSAR DATA LENS™ and Microsoft Excel is interrupted.
An unexpected error occurs during the Analysis Process.
Changes made to Worksheet, Table, Column, Cell Contents, Cell Formats, or Cell
Elements after analyzing the Column are not reflected automatically in the currently
displayed Analysis Results. New Analyze is required.
GENERATE REPORT
Generates a comprehensive
HTML Analysis Report containing complete
Analysis Results for the Analyzed Column.
Analysis Report is automatically downloaded and opened using the Web Browser's
Default Download Settings.
Analysis Report is intended for
Paperless Reference and is not designed to be
printed or saved as a PDF.
Analysis Report generation may not be completed if:
Web Browser blocks or prevents the Analysis Report from downloading.
Connection between AYSSAR DATA LENS™ and Web Browser is interrupted.
An unexpected error occurs while generating or downloading the Analysis Report.
Analysis Report can be viewed or shared independently without requiring Microsoft
Excel or Ayssar Data Lens.
Analysis Report is a snapshot of the Analysis Results at the time of generation.
Changes made afterward to the Worksheet, Table, Column, Cell Contents, Cell Formats,
or Cell Elements are not reflected in the Analysis Report.
Analysis Report generated in Deep Analysis Mode contain more detailed information
than Analysis Report generated in Quick Analysis Mode.
RESET FIELDS
Resets Table and Column selections and clears all currently displayed Analysis
Results, if present.
Restores all Analysis Fields, Counters, Indicators, and Navigation Controls to their
Default State.
Previously loaded Tables and Columns remain available for selection after resetting
the fields.
Does not perform a new Worksheet Scan or remove previously loaded Scan Results.
Does not modify the Workbook, Worksheet, Table, Column, or any Cell Data.
USER GUIDE
Generates a comprehensive
HTML User Guide containing complete guidance on
using Ayssar Data Lens.
User Guide is automatically opened using the Default Web Browser's.
User Guide is intended for Online Reference and
is not designed to be downloaded, printed, or saved as a PDF.
User Guide provides comprehensive information about all Features, Fields,
Indicators, Buttons, Panels, Analysis Results, and Reports available in Ayssar Data
Lens.
User Guide generation may not be completed if:
Web Browser blocks or prevents the User Guide from downloading.
Connection between AYSSAR DATA LENS™ and Web Browser is interrupted.
An unexpected error occurs while generating or downloading the User Guide.
User Guide can be viewed or shared independently without requiring Microsoft Excel
or Ayssar Data Lens.
COLUMN LOCATION
WORKBOOK NAME
Name of workbook containing the Analyzed Column.
Workbook Name is displayed without its Extension
(xls, xlsx, xlsb, xlsm, etc.).
Hovering over a Workbook whose name is too long to fit within the available space
will automatically scroll the complete name, allowing it to be viewed in full.
WORKSHEET NAME
Name of Worksheet containing the Analyzed Column.
Worksheet Name is obtained from Sheet Tabs.
Hovering over a Worksheet whose name is too long to fit within the available space
will automatically scroll the complete name, allowing it to be viewed in full.
WORKSHEET PROTECTION
Protection Status of Worksheet containing the Analyzed Column.
Worksheet Protection Status is obtained from
Review Tab ➜
Protect.
Worksheet Protection States:
Unprotected: Tables, Columns, and Ranges can be
located.
Protected: Tables, Columns, and Ranges
cannot be located.
WORKSHEET POSITION
Position of Worksheet containing the Analyzed Column within the Workbook.
Worksheet Position is determined according to its Order (Index) in Sheet Tabs, from
first to last.
Worksheet Position is displayed as X OF
Y, where:
X: Worksheet Order.
Y: Total Number of Worksheets in Workbook,
including hidden Worksheets.
TABLE NAME
Name of Table containing the Analyzed Column.
Table Name is obtained from Table Design Tab ➜
Table Name.
Hovering over a Table whose name is too long to fit within the available space will
automatically scroll the complete name, allowing it to be viewed in full.
COLUMN NAME
Name of the Analyzed Column.
Column Name is obtained from Table Header Row.
Hovering over a Column whose name is too long to fit within the available space will
automatically scroll the complete name, allowing it to be viewed in full.
TABLE POSITION
Position of Table containing the Analyzed Column within the Worksheet.
Table Position is determined according to its internal Order (Index) in Microsoft
Excel.
Table Position is displayed as X OF
Y, where:
X: Table Order.
Y: Total Number of Tables in Worksheet,
including hidden Tables.
COLUMN POSITION
Position of Analyzed Column within the Table.
Column Position is determined according to its Order (Index) in Table Header Row,
from first to last.
Column Position is displayed as X OF
Y, where:
X: Column Order.
Y: Total Number of Columns in Table, including
hidden Columns.
TABLE RANGE
Cell Range occupied by Table containing the Analyzed Column.
Table Range includes the Header Row, Data Body Cells, and Total Row, if present.
Table Range is displayed as X :
Y, where:
X: Address of First Cell in Table.
Y: Address of Last Cell in Table.
COLUMN RANGE
Cell Range occupied by the Analyzed Column.
Column Range includes the Header Cell (Column Name), Data Body Cells, and Total
Cell, if present.
Column Range is displayed as X :
Y, where:
X: Address of Top Cell in Column.
Y: Address of Bottom Cell in Column.
COLUMN CHARACTERISTICS
COLUMN VISIBILITY
Visibility Status of the Analyzed Column.
Column Visibility Status is determined based on the Visibility of the entire Column,
including the Header Cell (Column Name), Data Body Cells, and Total Cell, if
present.
Column Visibility States:
Visible: Entire Column is Visible. No Cells are
manually hidden or filtered out.
Partially Hidden: One or more Cells are manually
hidden or filtered out.
Hidden: Entire Column is Completely Hidden. All
Cells are manually hidden or filtered out.
COLUMN INTEGRITY
Structural Health of Key Characteristics across all Data Body Cells within the
Analyzed Column.
Column Integrity helps identify whether the Analyzed Column follows a consistent
structure or contains unexpected variations that may require review.
Manually hidden and filtered-out Cells are included in evaluating the Column
Integrity.
Header Cell (Column Name) and Total Cell, if present, are excluded when evaluating
the Column Integrity.
Key Characteristics:
Data Type Integrity:
All Cells have the same Data Type.
Multiple Data Types exist, but one Data Type is Dominant and occurs in at least
60% of Cells.
Multiple Data Types exist, but no Data Type is Dominant and occurs in at least
60% of Cells.
Format Type Integrity:
All Cells have the same Format Type.
Multiple Format Types exist, but one Format Type is Dominant and occurs in at least
60% of Cells.
Multiple Format Types exist, but no Format Type is Dominant and occurs in at least
60% of Cells
Formula Integrity:
All Cells contain Formulas, and all Formula Expressions are identical.
Cells contain different Formula Expressions, or some Cells contain Formula
Expressions while others do not.
Cells contain no Formula Expressions.
Data Validation Integrity:
All Cells contain Data Validation, and all Data Validation Rules are identical.
Cells contain different Data Validation Rules, or some Cells contain Data Validation
Rules while others do not.
Cells contain no Data Validation Rules.
Included when evaluating the Integrity Status:
Manually hidden and filtered-out Cells.
Excluded when evaluating the Integrity Status:
Header Cell (Column Name) and Total Cell, if present.
TOTAL CELLS
Total Number of Data Body Cells within the Analyzed Column.
Included when counting Total Cells:
Manually hidden and filtered-out Cells.
Excluded when counting Total Cells:
Header Cell (Column Name) and Total Cell, if present.
FILLED CELLS
Total Number of Non-Empty Cells within the Analyzed Column.
Included when counting Filled Cells:
Manually hidden and filtered-out Cells.
Cells containing Constant Values, Formulas, Images, or Checkboxes.
Excluded when counting Filled Cells:
Header Cell (Column Name) and Total Cell, if present.
Empty Cells and Cells containing only Sparklines.
DISTINCT VALUES
Total Number of Unique Values within the Analyzed Column.
Each Unique Value is counted only once, regardless of how many times it appears
within the Analyzed Column.
Example: A |
A | a |
A | 1.01 |
1.011 |
1.01 ➜ Distinct Values =
4
Distinct Values are Case-Sensitive. Values that
differ only in Letter Capitalization are considered different Values.
Example: Ayssar and
ayssar are treated as different Values.
Actual Cell Values (Underlying Values) are used to identify Distinct Values,
regardless of how they appear due to Cell Formatting.
Example: 1.01 and
1.011 are treated as different Values, even if
both are formatted to be displayed as 1.01.
Actual Cell Value (Underlying Value) can be obtained from the
Formula Bar when a Cell is selected.
Included when identifying Distinct Values:
Manually hidden and filtered-out Cells.
Cells containing Constant Values, Non-Blank Formula Results, or Checkboxes.
Excluded when identifying Distinct Values:
Header Cell (Column Name) and Total Cell, if present.
Empty Cells, Blank Formula Results, and Cells containing only Images or only
Sparklines.
DUPLICATE VALUES
Total Number of Values that appear at least twice within the Analyzed Column.
Each repeated Value is counted only once, regardless of how many times it appears
within the Analyzed Column.
Example: A |
A | a |
A | 1.01 |
1.011 |
1.01 ➜ Duplicate Values =
2
Duplicate Values are Case-Sensitive. Values that
differ only in Letter Capitalization are considered different Values.
Example: Ayssar and
ayssar are treated as different Values.
Actual Cell Values (Underlying Values) are used to identify Duplicate Values,
regardless of how they appear due to Cell Formatting.
Example: 1.01 and
1.011 are treated as different Values, even if
both are formatted to be displayed as 1.01.
Actual Cell Value (Underlying Value) can be obtained from the
Formula Bar when a Cell is selected.
Included when identifying Duplicate Values:
Manually hidden and filtered-out Cells.
Cells containing Constant Values, Non-Blank Formula Results, or Checkboxes.
Excluded when identifying Duplicate Values:
Header Cell (Column Name) and Total Cell, if present.
Empty Cells, Blank Formula Results, and Cells containing only Images or only
Sparklines.
DOMINANT DATA TYPE
Data Type that occurs most frequently within the Analyzed Column.
Dominant Data Type is determined based on the Percentage of Cells of each Data Type:
One Data Type represents at least 60% of Total
Cells, that Data Type is identified as Dominant.
No Data Type represents at least 60% of Total
Cells, the Data Type result is identified as
Mixed.
Included when identifying Dominant Data Type:
Manually hidden and filtered-out Cells.
Excluded when identifying Dominant Data Type:
Header Cell (Column Name) and Total Cell, if present.
DATA TYPE CONSISTENCY
Percentage of Cells belonging to the Dominant Data Type relative to the Total Cells
within the Analyzed Column.
If no Dominant Data Type is identified, Data Type Consistency is displayed as
N/A.
AYSSAR DATA LENS™ assumes that an ideal Column Structure contains a single Data
Type, although multiple Data Types may be appropriate depending on the purpose of
the Column.
DOMINANT FORMAT TYPE
Format Type that occurs most frequently within the Analyzed Column.
Dominant Format Type is determined based on the Percentage of Cells of each Format
Type:
One Format Type represents at least 60% of Total
Cells, that Format Type is identified as
Dominant.
No Format Type represents at least 60% of Total
Cells, the Format Type result is identified as
Mixed.
Included when identifying Dominant Format Type:
Manually hidden and filtered-out Cells.
Excluded when identifying Dominant Format Type:
Header Cell (Column Name) and Total Cell, if present.
Hovering over a Format type that is too long to fit within the available space will
automatically scroll the complete type, allowing it to be viewed in full.
A simplified Format Type is displayed, while the complete Type is available in the
Current Value within the Hint Box.
FORMAT TYPE CONSISTENCY
Percentage of Cells belonging to the Dominant Format Type relative to the Total
Cells within the Analyzed Column.
If no Dominant Format Type is identified, Format Type Consistency is displayed as
N/A.
AYSSAR DATA LENS™ assumes that an ideal Column Structure contains a single Format
Type, although multiple Format Types may be appropriate depending on the purpose of
the Column.
THINGS TO KNOW ABOUT COLUMN CHARACTERISTICS
Column Integrity Report is available during Deep Analysis and provides advanced
exploration of the Data Types, Format Types, Data Validation Rules, and Formula
Expressions contributing to the reported Integrity State.
Format Types Explorer Panel is available during Deep Analysis.
Explorer Panel:
Format Type Section:
Type Navigation Arrows: Navigate between unique Format Types (Format Type X
of Format Types in Column).
Cells Figure: Number of Cells containing the selected Format Type (Cells in Format Type).
Type Box: Displays the selected Format Type.
Format Range Section:
Range Navigation Arrows: Navigate between Ranges containing the selected Format Type
(Range X of
Ranges in Format Type).
Auto Select: When enabled, the selected Range is automatically located, selected,
and brought into view.
Range Address: Address of the selected Range.
Cells Figure: Number of Cells contained within the selected Range, out of the Cells
Figure (Cells in Range X out of
Cells in Format Type).
Auto Select Mechanism:
Clicking Auto Select automatically selects the currently displayed Cell Range.
While Auto Select is enabled, navigating between Cell Ranges automatically selects
the corresponding Cell Range.
Changing the selected Format Type resets Auto Select. Click Auto Select again to
re-enable automatic Cell Range selection.
Range of Format Types cannot be located
(selected) if:
Worksheet is no longer the Active Worksheet.
Worksheet has been renamed or protected.
Table has been deleted or renamed.
Table Structure has been modified by adding or deleting Rows or Columns.
Table has been repositioned within the same Worksheet or moved to a different
Worksheet.
Column has been deleted or renamed.
Column has been repositioned within the same Table or moved to a different Table.
Table or Column is completely hidden.
Range is completely hidden.
Connection between AYSSAR DATA LENS™ and Microsoft Excel is interrupted.
An unexpected error occurs during the Locating Process.
CELL TYPES
TEXT
Values stored and treated by Microsoft Excel as Text Strings, whether:
Entered Manually.
Returned by Formula.
Evaluated by Formula.
Text Values include:
Text-Based Values such as Words, Labels, Codes, or Mixed-Content Strings. Samples:
ABC | A101 |
00-101-00 |
!101& |
Ayssar Jamal
Values containing only Whitespace.
Values that look like valid Numeric, Boolean, Date-Time, Date, Time, or Error values
but are stored and treated by Excel as Text.
Invalid Numeric, Percentage, Currency, Scientific Notation, or Fraction values.
Samples:
10.10.1 |
%% 2.5 |
$ 2.01 $ |
2.02EE+00 |
2 2//3
Invalid Boolean, Date-Time, Date, or Time values. Samples:
TRUEE |
31-Jon-2025 21:11 |
30 Feb 2026 |
21:63
Any value is stored and treated by Microsoft Excel as Text, even if it looks like
valid Numeric, Boolean, Date-Time, Date, Time, or Error Value, if:
Value is entered after formatting the Cell as Text.
Value is prefixed with an Apostrophe '.
Value is originally stored as Text in another Cell and is returned by a Formula.
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Text Manipulation, Formatting,
Concatenation, or other Text Operations. Samples:
=" " |
=TEXT( ) |
=LEFT( )
NUMERIC
Values stored and treated by Microsoft Excel as Numbers, whether:
Entered Manually.
Returned by Formula.
Evaluated by Formula.
Numeric Values include:
Values formatted as Number. Samples:
103 |
1.0322 |
2,600.01 |
-202.33 |
(1.0322)
Values formatted as Currency or Accounting. Samples:
$10.22 |
SAR 10.22 |
JOR 1,500.001
Values formatted as Percentage. Samples:
10% |
%120.23
Values formatted as Scientific Notation. Samples:
2.02E+00 |
2.55E-02
Values formatted as Fraction. Samples:
1 2/9 |
3 159/713
Values formatted using Custom Number Formats to display Measurement Units or Labels.
Samples:
10.5 KG |
100 PCS |
22.3 °C |
101.22 JORDAN DINAR
Number Values formatted as Special (ZIP Code, Phone Number, Social Security Number)
are classified as Numeric.
Number Values formatted as Date-Time, Date, or Time are
not classified as Numeric.
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Calculation, Aggregation, Counting, or
other Numeric Operations. Samples:
=SUM( ) |
=COUNTIF( ) |
=MAX( )
BOOLEAN
Values stored and treated by Microsoft Excel as Boolean Values, whether:
Entered Manually.
Returned by Formula.
Evaluated by Formula.
Recognized Boolean Values:
TRUE and
FALSE Values.
☑ and
☐ Checkboxes.
Checkbox is inserted from Insert Tab ➜
Checkbox.
Values used to represent Logical States are
not classified as Boolean. Samples:
Yes | No |
1 | 0
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Comparison, Logical Evaluation, or
Boolean Testing. Samples:
=A1>B1 |
A1=B1 |
=ISBLANK( )
DATE-TIME
Values stored and treated by Microsoft Excel as Numbers, and formatted as Date-Time
using both Date and Time Components, whether:
Entered Manually.
Returned by Formula.
Evaluated by Formula.
Recognized Date-Time Format Rules:
Date Format must include at least one Day Component
d, one Month Component
m, and a Year Component
yy or yyyy.
Time Format must include at least one Hour Component
h or hh, and
one Minute Component m or
mm.
Optional Second Component s or
ss, and an optional Time Period Indicator
AM/PM may be used.
Recognized Separator Characters:
Date: Whitespace ( ␣ ), Comma (
, ), Dash (
- ), Slash (
/ ), and Dot (
. ).
Time: Whitespace ( ␣ ), Colon (
: ), and Dot (
. ).
Values formatted using Custom Date-Time Formats to display Labels or Customized Text
are classified as Date-Time. Samples:
01-Jan-2026 08:30 AM Shift A |
Day 22 Month 10 Year 26 Hour 22 Minute 16
Date-Time values formatted using Unrecognized Date-Time Format Rules are classified
as Undefined. Samples:
22 Apr 2026 11 AM |
22 Apr 11:22 |
Apr 2026 11:22
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Date-Time, Date, or Time Calculations
and Operations. Samples:
=NOW( ) |
=DATE( ) |
=A1+1
DATE
Values stored and treated by Microsoft Excel as Numbers, and formatted as Date using
only Date Components, whether:
Entered Manually.
Returned by Formula.
Evaluated by Formula.
Recognized Date Format Rules:
Date Format must include at least one Day Component
d, one Month Component
m, and a Year Component
yy or yyyy.
Recognized Separator Characters:
Date: Whitespace ( ␣ ), Comma (
, ), Dash (
- ), Slash (
/ ), and Dot (
. ).
Values formatted using Custom Date Formats to display Labels or Customized Text are
classified as Date. Samples:
01-10-2026 Date |
Monday, 01-Jan-2026 |
Day 22 Month 10 Year 26
Date values formatted using Unrecognized Date Format Rules are classified as
Undefined. Samples:
22 Apr |
Apr 2026 |
June
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Date-Time, Date, or Time Calculations
and Operations. Samples:
=NOW( ) |
=DATE( ) |
=A1+1
TIME
Values stored and treated by Microsoft Excel as Numbers, and formatted as Time using
only Time Components, whether:
Entered Manually.
Returned by Formula.
Evaluated by Formula.
Recognized Time Format Rules:
Time Format must include at least one Hour Component
h or hh, and
one Minute Component m or
mm.
Optional Second Component s or
ss, and an optional Time Period Indicator
AM/PM may be used.
Recognized Separator Characters:
Time: Whitespace ( ␣ ), Colon (
: ), and Dot (
. ).
Values formatted using Custom Time Formats to display Labels or Customized Text are
classified as Time. Samples:
08:30 AM Shift A |
14:45 UTC |
Hour 22 Minute 20
Time values formatted using Unrecognized Time Format Rules are classified as
Undefined. Samples:
11 AM | 22
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Date-Time, Date, or Time Calculations
and Operations. Samples:
=NOW( ) |
=DATE( ) |
=A1+1
UNDEFINED
Cells whose contents cannot be classified as
Text, Numeric, Boolean, Date-Time, Date, Time, Error, or Blank. Includes:
Numeric Values formatted using Unrecognized Date-Time Formats.
Numeric Values formatted using Unrecognized Date Formats.
Numeric Values formatted using Unrecognized Time Formats.
Cells containing only Images (Picture In Cell).
ERROR
Values stored and treated by Microsoft Excel as Error, whether:
Returned by Formula.
Evaluated by Formula.
Recognized Error Values:
#DIV/0! |
#NAME? |
#NUM! |
#N/A |
#VALUE! |
#NULL! |
#REF! |
#SPILL! |
#CALC!
Error-like Values entered manually are
not classified as Error.
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Evaluation that results in an Error.
Samples:
=1/0 |
=NA( ) |
=SQRT(-1)
BLANK
Values stored and treated by Microsoft Excel as Blank, whether:
Returned by Formula.
Evaluated by Formula.
Empty Cells are not classified as Blank.
Formulas Terminology:
Returned by Formula: Value retrieved from another Cell as it is. Samples:
=A1 |
=VLOOKUP( ) |
=INDEX( )
Evaluated by Formula: Value generated through Evaluation that results in an Empty
String. Samples:
=IFERROR(A1,"") |
=IF(A1="","",A1) |
=""
EMPTY
Cells containing no stored Value, Formula, Image, or any other content (Truly
Empty).
Empty Cells with Sparkline are classified as
Empty.
THINGS TO KNOW ABOUT CELL TYPES
Cell Type Classification is determined by the Cell Contents and, where applicable,
the applied Cell Format.
The same Numeric Value may be classified as Numeric, Date-Time, Date, Time, or
Undefined depending on the applied Cell Format.
A Cell may contain only one Data Type and one Format Type at a time.
Cell Content (Underlying Value) can be viewed and modified from the
Formula Bar when a Cell is selected.
Cell Format can be viewed and modified from
Home Tab ➜
Number Format when a Cell is selected:
Built-in Format Categories (such as Number, Currency, Date, and Time) display
simplified representations of the applied Cell Format.
Custom Format Category displays the exact Format String used by Microsoft Excel.
Each Cell Type is presented using a Summary Panel and, where applicable, a Details
Panel:
Summary Panel: Default Panel, available for all Cell Types.
Details Panel: Available only when the corresponding Cell Type is present in the
Analyzed Column.
Summary Panel:
Count Figure: Number of Cells containing the corresponding Type (Cells in Data Type).
Percentage Figure: Percentage of the Count Figure relative to the Total Cells in the
Analyzed Column (Cells in Data Type ÷
Total Cells in Column).
Expand Button: Opens the Details when the Count Figure is greater than Zero.
Details Panel:
Range Navigation Arrows: Navigate between Ranges containing the corresponding Type.
(Range X of
Ranges in Data Type).
Auto Select: When enabled, each selected Range is automatically located, selected,
and brought into view.
Range Address: Address of the selected Range.
Cells Figure: Number of Cells contained within the selected Range, out of the Count
Figure (Cells in Range X out of
Cells in Data Type).
Auto Select Mechanism:
Clicking Auto Select automatically selects the currently displayed Cell Range.
While Auto Select is enabled, navigating between Cell Ranges automatically selects
the corresponding Cell Range.
Range of Cell Types cannot be located (selected)
if:
Worksheet is no longer the Active Worksheet.
Worksheet has been renamed or protected.
Table has been deleted or renamed.
Table Structure has been modified by adding or deleting Rows or Columns.
Table has been repositioned within the same Worksheet or moved to a different
Worksheet.
Column has been deleted or renamed.
Column has been repositioned within the same Table or moved to a different Table.
Table or Column is completely hidden.
Range is completely hidden.
Connection between AYSSAR DATA LENS™ and Microsoft Excel is interrupted.
An unexpected error occurs during the Locating Process.
CELL ELEMENTS
DATA VALIDATION
Cells containing Data Validation Rules.
Recognized Data Validation Rules:
Whole Number |
Decimal |
List |
Date |
Time |
Text Length |
Custom
Data Validation Rule restricts the values that can be entered into Cell.
A Cell cannot contain more than one Data
Validation Rule at a time.
Data Validation Rule can be viewed and modified from
Data Tab ➜
Data Validation.
CONDITIONAL FORMATTING
Cells containing Conditional Formatting Rules.
Recognized Conditional Formatting Rules:
Highlight Cells Rules |
Top/Bottom Rules |
Data Bars |
Color Scales |
Icon Sets |
Formula
Conditional Formatting Rule changes the appearance of Cell.
A Cell can contain more than one Conditional
Formatting Rule at a time.
Conditional Formatting Rule can be viewed and modified from
Home Tab ➜
Styles.
CHECKBOX
Cells containing Checkboxes.
Recognized CheckBoxes:
☑ CHECKBOX |
☐ CHECKBOX
Cells containing CheckBoxes are classified as Boolean.
A Cell cannot contain more than one Checkbox at
a time.
Checkbox can be inserted from Insert Tab ➜
Checkbox.
IMAGE IN CELL
Cells containing Images (Picture in Cell).
Cells containing Images are classified as Undefined.
A Cell cannot contain more than one Image at a
time.
Image can be inserted from Insert Tab ➜
Illustrations.
FORMULA
Cells containing Formula Expressions.
Formulas may return Text, Numeric, Boolean, Date-Time, Date, Time, Undefined, Error,
or Blank Values.
A Cell cannot contain more than one Formula
Expression at a time.
Formula can be inserted by typing an Equal Sign
=, followed by
Formula Expression.
Formula Expression can be viewed and modified from
Formula Bar.
THINGS TO KNOW ABOUT CELL ELEMENTS
Each Cell Element is presented using a Summary Panel and, where applicable, a
Details Panel or an Explorer Panel:
Summary Panel: Default Panel, available for all Cell Elements.
Details Panel: Available only when the corresponding Cell Element is present in the
Analyzed Column.
Explorer Panel: Replaces the Details Panel for Data Validation and Formula Elements
during Deep Analysis.
Form Controls, such as Buttons, Combo Boxes, Check Boxes, Spin Buttons, List Boxes,
Option Buttons, and Labels, are not recognized as Cell Elements because Microsoft
Excel stores them as floating objects, not as part of the Cell, even when they
appear to be inside a Cell.
Summary Panel:
Count Figure: Number of Cells containing the corresponding Element (Cells in Element Type).
Percentage Figure: Percentage of the Count Figure relative to the Total Cells in the
Analyzed Column (Cells in Element Type ÷
Total Cells in Column).
Expand Button: Opens the Details Panel or, where applicable, the Explorer Panel when
the Count Figure is greater than Zero.
Details Panel:
Range Navigation Arrows: Navigate between Ranges containing the corresponding
Element (Range X of
Ranges in Element Type).
Auto Select: When enabled, each selected Range is automatically located, selected,
and brought into view
Range Address: Address of the selected Range.
Cells Figure: Number of Cells contained within the selected Range, out of the Count
Figure. (Cells in Range X out of
Cells in Element Type).
Explorer Panel:
Element Section:
Element Navigation Arrows: Navigate between unique Validation Rules or Formula
Expressions (Rule/Expression X of
Rules/Expressions in Column).
Cells Figure: Number of Cells containing the selected Validation Rule or Formula
Expression (Cells in Rule/Expression).
Element Box: Displays the selected Validation Rule or Formula Expression.
Range Section:
Range Navigation Arrows: Navigate between Ranges containing the selected Validation
Rule or Formula Expression (Range X of
Ranges in Rule/Expression).
Auto Select: When enabled, each selected Range is automatically located, selected,
and brought into view.
Range Address: Address of the selected Range.
Cells Figure: Number of Cells contained within the selected Range, out of the Cells
Figure (Cells in Range X out of
Cells in Rule/Expressio).
Auto Select Mechanism:
Clicking Auto Select automatically selects the currently displayed Cell Range.
While Auto Select is enabled, navigating between Cell Ranges automatically selects
the corresponding Cell Range.
Changing the selected Formuala Expression or Data Validation Rule resets Auto
Select. Click Auto Select again to re-enable automatic Cell Range selection.
Range of Cell Elements cannot be located
(selected) if:
Worksheet is no longer the Active Worksheet.
Worksheet has been renamed or protected.
Table has been deleted or renamed.
Table Structure has been modified by adding or deleting Rows or Columns.
Table has been repositioned within the same Worksheet or moved to a different
Worksheet.
Column has been deleted or renamed.
Column has been repositioned within the same Table or moved to a different Table.
Table or Column is completely hidden.
Range is completely hidden.
Connection between AYSSAR DATA LENS™ and Microsoft Excel is interrupted.
An unexpected error occurs during the Locating Process.
GENERAL INFORMATION
HINT BUTTONS
Hint Buttons (Bulbs) provide quick explanations
for the corresponding Fields.
Click a Hint Button to display a brief explanation without leaving the current
Analysis Screen.
For more Comprehensive Information, click the HUser Guide Button to open the
complete Documentation.
Hint Buttons are available throughout AYSSAR DATA LENS™ wherever additional guidance
may be helpful.
SCROLL BUTTONS
Scroll Buttons (Handles) provide quick
navigation between Analysis Sections.
Four Scroll Buttons, each corresponding to one of the Analysis Sections.
Clicking a Scroll Button immediately scrolls to the corresponding Analysis Section.
First Scroll Button is highlighted automatically when the beginning of the Analysis
Results is in view.
Last Scroll Button is highlighted automatically when the end of the Analysis Results
is in view.
While scrolling, Scroll Buttons are dimmed unless the beginning or end of the
Analysis Results is in view.
TOAST MESSAGES
Toast Messages provide Important Information, Confirmations, Warnings, and Error
Notifications while using Ayssar Data Lens:
Information Toast: Notifies users when there is no need to perform the requested
operation.
Success Toast: Notifies users of completed operations or provides general
information.
Confirmation Toast: Requests confirmation before performing an operation or
selecting an Analysis Mode.
Warning Toast: Explains why an operation could not be completed and, whenever
possible, provides guidance for resolving the issue.
Error Toast: Notifies users of unexpected errors that prevent the requested
operation from being completed.
Toast Messages are displayed automatically whenever user attention, acknowledgment,
or confirmation is required.
Read each Toast Message carefully before proceeding, as it may contain important
Information, recommended Actions, or recovery Instructions.
GENERAL ERROR
General Error indicates that an unexpected condition prevented AYSSAR DATA LENS™
from completing the requested operation.
Click the Print Button in General Error Toast to
generate HTML Error Ticket containing diagnostic
information that can assist in troubleshooting the issue.
Error Ticket is automatically downloaded and opened using the Web Browser's Default
Download Settings.
Error Ticket is intended for
Online Technical Support and is not designed to
be printed or saved as a PDF.
Error Ticket includes Technical Information such as Error Code, Product Name and
Version, Host Application, Operating System, and other Diagnostic Information.
Providing the Error Ticket when contacting AYSSAR TECHWORKS™ Technical Support helps
identify and resolve the issue more efficiently.
Error Ticket generation may not be completed if:
Web Browser blocks or prevents the Error Ticket from downloading.
Connection between AYSSAR DATA LENS™ and Web Browser is interrupted.
An unexpected error occurs while generating or downloading the Error Ticket.
If the Error Ticket cannot be generated, the Error Code displayed in the General
Error Toast can be shared with AYSSAR TECHWORKS™ Technical Support.