Magic-Sheet Coverage

Audit magic-sheet lighting-channel coverage.

Description

A lighting magic sheet provides a compact view of channels and their functions.

A lighting magic sheet provides a compact view of channels and their functions. Channel coverage helps locate omissions in that reference before operating from it.^[1]

Audit magic-sheet lighting-channel coverage.

When to use Magic-Sheet Coverage

Use this tool to audit magic-sheet lighting-channel coverage.

Prepare production measurements or checklist records for one planning period. Confirm units, staffing assumptions and caller-selected criteria before running the calculation.

How to use Magic-Sheet Coverage and understand its results

Prepare production measurements or checklist records for one planning period. Confirm units, staffing assumptions and caller-selected criteria before running the calculation.
Enter requiredChannels, documentedChannels using the field table and calculation rules, then run the tool.
Read coveragePercent, matched, missing, unexpected. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
requiredChannels	Required lighting channels	list of string	Required
documentedChannels	Documented channels	list of string	Required

Enter requiredChannels and documentedChannels label lists. Trim labels, reject blank entries and match case-insensitively with en-US lowercase. Deduplicate each list, requiring at least one distinct required item; an empty observed list is allowed. Return matched, missing, unexpected labels and coverage. Duplicate normalized labels keep their last trimmed spelling at the first key position.

coverage%=100 matchedDistinctRequirements/distinctRequirements

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
coveragePercent	Coverage (%)	number; minimum: 0; maximum: 100
matched	Matched items	list of string
missing	Missing items	list of string
unexpected	Unexpected items	list of string

json

{
  "input": {
    "requiredChannels": [
      "alpha",
      "beta",
      "gamma"
    ],
    "documentedChannels": [
      "beta",
      "alpha",
      "extra"
    ]
  },
  "output": {
    "coveragePercent": 66.66666666666666,
    "matched": [
      "alpha",
      "beta"
    ],
    "missing": [
      "gamma"
    ],
    "unexpected": [
      "extra"
    ]
  }
}

Limitations and assumptions

It does not inspect channel functions, patching, positions or the rendered sheet. Spelling differences beyond case and outer whitespace remain distinct.

Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Focus-Chart Coverage: Audit focus-chart instrument coverage. For a complementary task, use Show-Control Trigger Coverage: Audit show-control trigger mappings.

References

Magic-Sheet Coverage — tool.io

Similar or alternative tools

Focus-Chart Coverage
Audit focus-chart instrument coverage.
Show-Control Trigger Coverage
Audit show-control trigger mappings.