User Manual — System Scope Overview SVG Generator

Overview

This tool reads a single Excel workbook and generates up to 7 publication-ready SVG diagrams directly in your browser — no server or software installation required. All processing happens locally; your file is never uploaded anywhere.

Supported browsers: Chrome, Edge, Firefox (desktop). Safari is not recommended due to SVG download limitations.

How to Use the Generator

1

Open the Generator

Open index.html in your browser. No internet connection is required after the page has loaded once (SheetJS library is loaded from CDN on first load).

2

Upload the Excel File

Click the upload area (or drag and drop) to select your Excel workbook.
The file must meet these requirements:

Format: .xlsx
Contains a sheet named exactly: System Scope Overview Diagram
The file must not be open in Excel at the same time

3

Click "▶ Generate SVG Diagrams"

The tool parses the Excel data, runs a validation check, and generates all 7 diagrams. The Output Log shows any data warnings.

4

Download the SVG Files

Click any diagram button in the Download section to save it as an .svg file. Use the preview tabs to inspect diagrams before downloading.

Required Excel Structure

The sheet System Scope Overview Diagram must use a two-row merged header (rows 1 and 2) followed by one data row per system starting from row 3.

Header Layout

Row 1 contains the main header categories. Row 2 contains sub-headers. Merged cells are supported and automatically expanded by the tool.

Column (Row 1)	Column (Row 2)	Required?	Description
`System`	(any or empty)	Required	Full system name. Must be the first column containing the word "System" (case-insensitive). Each row is one system.
`Stage 0 …`	`R-Value SST`	Required	R-value for Systems Supporting Testing at Stage 0. Use values like `R02`, `R04`, `R08`, or `0` for none.
`Stage 0 …`	`R-Value SUT`	Required	R-value for Systems Under Test at Stage 0.
`Stage 0 …`	`System Scenario`	Required	Scenario number: `1`, `2.1`, `3`, `3.1`, `3.2`, `4`, or `5`. Determines which diagram column a system appears in.
`Stage 1 …`	`R-Value SST / SUT / System Scenario`	Required	Same structure as Stage 0, repeated for Stages 1–4.
`Stage 0 - System Maturity Description`	(any or empty)	Optional	Free-text description of the system's maturity status at Stage 0. Used in the Stage 0+1 & Desc combined diagram. Long text is automatically wrapped to two lines.

The column header matching is flexible: the tool ignores spaces, hyphens, and case differences. R-Value SST, R Value SST, and RVALUE SST all match.

Valid System Names

Each data row must have a system name that matches (or closely matches) one of the 26 recognised systems below. The tool uses partial matching and pre-defined aliases.

ETCSCIVIL (Track & Tunnels)NGR TRACTION POWERENHANCED RADIOPLATFORM SCREEN DOORS POWER SYSTEMSGOV WIRELESS NETWORKFIRE SYSTEMS TUNNEL VENTILATIONPUMPED DRAINAGESTATION HYDRAULICS STATION CLIMATE CONTROLEACSCCTV PMCSOMCSMOBILE TELECOMS INFORMATION SYSTEMSPA & HALVERTICAL TRANSPORT PASSENGER MONITORINGUNIVERSAL TRAFFIC CONTROLCSN T&S NETWORKQRON

Aliases: UTC is accepted for Universal Traffic Control, PLATFORM SCREEN for Platform Screen Doors, STATION CLIMATE for Station Climate Control.

Valid R-Values and Colour Coding

R-Value	Colour	Meaning
`0`	Light grey	Not applicable / no data
`R00`	Red	Lowest readiness
`R02`	Amber
`R03`	Light green
`R04`	Light yellow
`R06`	Light yellow
`R08`	Green
`R09`	Mid green
`R10`	Dark green
`R11`	Deep green	Highest readiness
`T`	Blue	Temporary
`P`	Pink	Provisional

Scenario Numbers

The System Scenario column determines which section of the Stage 0–4 split diagrams a system appears in.

Scenario	Column	Description
`1`	Systems Under Test (SUT)	Non-Safety System Under Test – No Temporary Test Controls Required
`2.1`	Systems Under Test (SUT)	Safety-Reliant System Under Test – Temporary Test Controls Required
`3`	Systems Supporting Testing (SST)	Safety-Reliant System – No Temporary Test Controls Required
`3.1`	Systems Supporting Testing (SST)	Safety-Reliant System – Temporary Test Controls Required (Not Under Test)
`3.2`	Systems Supporting Testing (SST)	Temporary Test Controls Provide Safety – System Not Relied Upon
`4`	Systems Under Test (SUT) — Future Use	Non-Safety System – No Temporary Test Controls Required. System Installed, Not Used or Tested
`5`	Systems Supporting Testing (SST)	System Supporting Operations (SSO) – No Temporary Test Controls Required
`0` or blank	(not shown)	System excluded from this stage's split diagram

If a Scenario value is set to 1 or 2.1 but no SUT R-value is provided, or set to 3/3.1 but no SST R-value is provided, the Output Log will show a data inconsistency warning.

Output SVG Files

File	Contents
All Stages	Single table showing all 26 systems × 5 stages (Stage 0–4), SST and SUT columns for each.
Stage 0	Split view: Systems Under Test vs. Systems Supporting Testing for Stage 0 only.
Stage 1	Same split view for Stage 1.
Stage 2	Same split view for Stage 2.
Stage 3	Same split view for Stage 3.
Stage 4	Same split view for Stage 4.
Stage 0+1 & Desc	Combined view: Stage 0 and Stage 1 R-value table on the left, plus a Stage 0 - System Maturity Description text panel on the right. Cell background colours are read from the Excel fill colour; optional alternating row background can be configured. Requires the description column to be present.

Stage 0+1 & Desc — Configuration Panel

Click the ⚙ Stage 0+1 Description — Configuration panel (between the upload area and the Output Log) to expand the settings. Changes take effect on the next generation run.

Setting	Default	Description
PPT Aspect Ratio	`17:9 (1.8889)`	Controls SVG width relative to height so the diagram fills the slide with no blank side bars. Choose a preset (16:9, 17:9, 18:9) or enter a custom value.
Description Panel Width (px)	`0 (auto)`	Fixed width for the description column. `0` lets the tool calculate the width automatically to fill the aspect ratio. Enter a positive number to override.
Column Title	`Stage 0 - System Maturity Description`	Header text displayed at the top of the description column.
Description Font Size (px)	`23`	Font size for the description text in each row cell.
Alternating Row Background	Off	When enabled, every other description cell (rows 1, 3, 5…) is rendered with the chosen colour instead of the default row colour. Excel fill colours always take priority over this setting.

Excel cell fill colours (e.g. yellow or orange highlights in the spreadsheet) are read automatically and always override the alternating background setting for that specific row.

Troubleshooting

Sheet not found

The tool reports all sheet names found. Confirm the sheet is named exactly System Scope Overview Diagram (check for extra spaces or different capitalisation).

Systems show as "0" for all stages

The system name in the Excel file does not match the expected list. Check for typos or extra spaces in the System column.

"Stage 0 - System Maturity Description" column not found

The description column header in Row 1 must contain the word "Maturity" and "Description" (case- and space-insensitive). Example: Stage 0 - System Maturity Description. If missing, the Stage 0+1 & Desc diagram will show empty description cells.

Download button does nothing

Some browsers (especially Safari) block Blob downloads. Use Chrome or Edge.

File is open in Excel

Close the file in Excel before uploading. An open file may be locked and fail to parse.