This section provides link tips to navigate faster in the JZR report and be more efficient in the report high level reading or deep study.
Excel back and forward buttons
Strong recommendation : enable the back and forward navigation shortcuts in the Quick Access Toolbar of Excel.
It will permit you to move in the JZR report like in a browser.
To add the shortcuts, right click on the green top bar of Excel, on the save location button for example, select then “Customize Quick Access Toolbar..”.
It will open the Excel options in which you will select the Back and Forward commands.
JZR report links
The JZR report contains the following links:
Sheet | Element | Location | Destination | Other sheet |
Navigation | Sheet name | Target sheet | Yes | |
All sheets | Jeyzer | Top left | Navigation sheet | Yes |
Task Sequence | Header math function value | Headers | Header value | No |
Time stamp | Timeline | First action cell below that time stamp | No | |
Date | Timeline | Next sheet at the same date position | Yes | |
Row header | First action cell on the same row | No | ||
Action | Cell at the left of any action | Action on the next sheet | Yes | |
Legend | Top left | Legend section | No | |
Headers | Headers with symbol | Chart | No | |
Monitoring Sequence | Header math function value | Headers | Header value | No |
Time stamp | Timeline | First event cell below that time stamp | No | |
Date | Timeline | Next sheet at the same date position | Yes | |
Row header | First event on the same row | No | ||
Event | First event cell and repeated labelled ones | Action on the next sheet if any or top action under the same time stamp | Yes | |
Headers | Headers with symbol | Chart | Yes | |
Monitoring Events Journal of Events | Sequence links | Letter links | Action on the next Task sequence | Yes |
Sequence links | Letter links (M) | Event on the next Monitoring Sequence | Yes | |
Graph | Symbols | Function or Contention graph picture | No | |
Action Dashboard | Executor | On the left | Action on the next sheet | Yes |
Up / Down | Up / Down arrow | Next / previous action | No | |
Action List | Action principal | Action on the next sheet | Yes | |
Task Sequence links | Letter links | Action on the Task sequence | Yes | |
Top Stack | Graph | Symbols | Function or Contention graph picture | No |
Action Distinct Histogram | Action principal | Action on the next sheet | Yes | |
Task Sequence links | Letter links | Action on the Task sequence | Yes | |
Graph | Symbols | Function or Contention graph picture | No | |
Action Histogram Function Histogram | Graph | Symbols | Function or Contention graph picture | No |
Action Distinct Profiling | Action principal | Action on the next sheet | Yes | |
Task Sequence links | Letter links | Action on the Task sequence | Yes | |
Graph | Symbols | Function or Contention graph picture | No | |
Up / Down | Up / Down arrow | Navigate vertically in the action tree | No | |
Right / Left | Right / Left arrow | Navigate transversely in the action tree | No | |
Action Profiling | Graph | Symbols | Function or Contention graph picture | No |
Up / Down | Up / Down arrow | Navigate vertically in the action tree | No | |
Right / Left | Right / Left arrow | Navigate transversely in the action tree | No | |
Modules | Graph | Symbol | Modules graph picture | No |
Monitoring Rules | Hit | Sheet using the monitoring rule | Yes |