PANC Dispatch Command Center — how to use

Turn your dispatch Excel file into dashboards, charts and reports in a few clicks. Open the dashboard →

1

Open the link

Open the dashboard link in Chrome or Edge on your laptop. Nothing needs to be installed.

2

Load your Excel file

Click 📂 Data source then Import Excel and choose your dispatch file (or drag it onto the box).

You'll see a short summary first: years found, latest month, and species. Click ✔ Load this data.

Your file stays on your laptop. It is read inside the browser and never uploaded.

3

Read the dashboard

  • Executive Summary: totals, change vs last year, best and latest month, key findings.
  • Commercial / Internal: species detail, monthly charts, the year-by-year table, and actual vs forecast.
  • Year vs Year: every year side by side, with growth %.
  • Exceptions & Checks: unusual months, species that stopped, and places where the Excel file's own totals don't add up.
  • Data: every number with the Excel cell it came from.

Use the filter bar (Year, vs, Period, Channel, Species) to change what you see. Click any bar or tile to drill into the detail; ◂ Back returns you to where you were.

4

Make a report

📑 PowerPoint creates a ready deck. ⬇ Excel creates a workbook with all tables. 🖨 PDF prints every tab (choose “Save as PDF” as the printer). Each one uses the filters you have selected.

5

Every month

Update your Excel file as usual, then click ⟳ Reload (or Data source → Import Excel) and choose the updated file. Everything refreshes.

Keep the same layout: one sheet per channel (Commercial, Internal), each year as a block with the year in column A and Jan … Dec across, one row per species. New species rows and new years are picked up automatically.

Good to know
• The dashboard remembers your last file on this laptop and browser only. On another laptop, import the file once there.
• Totals and averages are always recalculated from the monthly numbers, so they stay right even if a total in the Excel file is off.
• To refresh automatically instead of importing a file: put the file in Google Sheets, use File → Share → Publish to web → Microsoft Excel (.xlsx), and paste that link under Data source.
• Data source → Clear data removes it from the laptop. Your Excel file is not touched.