Filters

XLSX to JSON Converter

Select an XLSX file. Each sheet will be converted. The output JSON will be an object with sheet names as keys.

Generated JSON Preview (first 3 records of first sheet):

Simulation Mode

Interactive Diagram Tutorial

Introduction

Welcome to the Interactive Process Diagram! This tool helps you visualize, analyze, and understand complex process flows and their dependencies. Use this guide to learn about its features.

Loading Data

There are a few ways to get your process data into the diagram:

• From SharePoint (Recommended for initial load):
  1. Go to Menu > Load > Load from SharePoint. This will initiate the download of the latest process definitions in an XLSX file.
  2. Once the download is complete, return to the diagram's menu and navigate to Menu > Load.
  3. In the Load Excel section, click the 'Choose Excel File' button and select the file you just downloaded.
  4. After selecting the file, click the 'Load to Diagram' button to display the data.
• Load JSON File: If you have a pre-formatted JSON file, use Menu > Load > Load JSON.
• Load Excel File: If you have an XLSX file (not from SharePoint), use Menu > Load > Load Excel. Choose your file, then either load it directly to the diagram or convert and download as JSON.

The diagram expects specific column headers in your data (e.g., "ID", "Short name", "WD", "Due time", "Dependencies", "Process Type").

Understanding Process Nodes & Diagram Area

• Each box (node) represents a process. It displays the "Short name".
• "WD" (Working Day) and "Due time" determine its position on the X (time/day) and Y (time of day) axes.
• Nodes can be of type "Standard", "Blocking" (B), "Informational" (I), or the new "Standard-Blocking" (S/B) which has a dashed border. This affects dependency interpretation.
• Sticky axes (top and left) help you understand the timeline even when scrolled.

Navigating the Diagram

• Zoom: Use your mouse wheel to zoom in and out.
• Pan: Click and drag the diagram background to move around.
• Mini-Map: Toggle the Mini-Map using the 'M' button in the top right.
• Reset View: Click 'Reset View' to return to the default zoom and position.

Filtering and Searching

• Filters: Click the 'Filters' button to filter processes based on attributes like "Company Codes", "WD", etc.
• Search: Use the "Search processes..." bar to find nodes by ID, Short name, or Description.
• Axis Filtering: Click on a WD label on the top axis or a time label on the left axis to quickly filter for that day/hour.

Interacting with Nodes

• Selection: Click a node to select it, highlight its dependencies, and dim other nodes.
• Process Details: When a node is selected, its details appear at the bottom. From here, you can edit it or start a simulation.
• Dependency Tree: With a node selected, use Menu > Show Dependencies to open a side panel showing its input/output hierarchy.

Editing Dependencies

1. Go to Menu > Enable Dependency Editing.
2. Click on a source node. A green '+' handle appears on its right.
3. Drag this '+' handle to a target node.
4. On release, a context menu will appear. Choose the dependency type ("Standard", "Blocking", or "Informational").
5. To remove a dependency, click the red '–' handle that appears on a linked output node.

Simulation Mode (Multi-Process)

This powerful mode allows you to see the potential impact of changing multiple processes at once without altering your actual data.

1. Select a process and click the 'Simulate Impact' button in the details panel to start.
2. The Simulation Panel opens with the first process on a "card". Here you can choose to Shift its WD/Time or Remove it from the flow.
3. You can add more processes to the simulation using the "Add another process" dropdown at the bottom of the panel. Each will get its own card.
4. After making your changes on the cards, you must click the 'Run / Update Simulation' button to see the effects on the diagram.
5. The diagram will highlight the target processes and color-code any dependent nodes that are at risk or have timing conflicts. A summary appears in the panel.
6. Use the 'End Simulation' button to exit and return to the normal view.
7. You can also save the current set of changes as a named scenario for later use.

Presentation Mode

Click the 'Presentation' button for a clean, full-screen view ideal for showcasing the diagram. Most UI controls are hidden. Click 'Presentation' again to exit.

View Configurations

• Save View: After setting up desired filters and colors, go to Menu > Save View Config to save this setup with a name.
• Load/Delete View: Use the "Load View:" dropdown and the adjacent trash icon in the Menu to apply or delete saved configurations.