Skip to main content

Excel

P1TS Excel Live polls your P1TS server and refreshes an Excel workbook with live leaderboard, lap, and stint data - no add-in required, just PowerShell scripts driving Excel directly.

What you need​

  • Windows 10 or 11
  • Microsoft Excel (desktop, not the web version)
  • PowerShell 5.1 (built into Windows - nothing to install)
  • A P1TS server URL, username, and password

Setup​

1. Download the scripts​

Open PowerShell and run:

$dest = "C:\P1Software\P1TS-Excel"
New-Item -ItemType Directory -Force -Path $dest | Out-Null
$base = "http://www.p1ts.com/p1ts-excel"
$files = @(
    "P1TS-Excel.ps1",
    "P1TS-Excel-Common.ps1",
    "P1TS-Excel-Create-Shortcut.ps1",
    "P1TS-Excel-Create-MyLeaderboard.ps1",
    "P1TS-Excel-Create-MyRunSheet.ps1",
    "favicon.ico"
)
foreach ($f in $files) {
    Invoke-WebRequest "$base/$f" -OutFile "$dest\$f"
}

This creates C:\P1Software\P1TS-Excel and downloads every file in one go.

2. Allow the scripts to run (one time)​

Windows blocks unsigned scripts by default. In a normal (not "Run as Administrator") PowerShell window:

Set-ExecutionPolicy -Scope CurrentUser RemoteSigned
Get-ChildItem "C:\P1Software\P1TS-Excel\*.ps1" | Unblock-File

3. Create a desktop shortcut (optional)​

& "C:\P1Software\P1TS-Excel\P1TS-Excel-Create-Shortcut.ps1"

Creates a P1TS Excel Live shortcut so you can launch it with one click.

4. Open Excel and start the live refresh​

Open (or create) a workbook, then double-click the shortcut - or, without one, run:

& "C:\P1Software\P1TS-Excel\P1TS-Excel.ps1"

On first run it creates a P1.Excel sheet with these settings cells:

  • P1.URL - your P1TS server URL (e.g. http://sro.p1ts.com)
  • P1.USERNAME / P1.PASSWORD - your login credentials
  • P1.HEROCAR - car number to follow in the P1.Laps sheet
  • P1.REFRESH - poll interval in seconds (default 5)
  • P1.TIMEOUT - network timeout in seconds (default 5)

Edit those cells and save - the script picks up new values on the next cycle, no restart needed. It also creates and keeps updated P1.Leaderboard, P1.Laps, and P1.Stints sheets.

5. Optional: formula sheets​

With the workbook open and the refresh script running at least once:

& "C:\P1Software\P1TS-Excel\P1TS-Excel-Create-MyLeaderboard.ps1"
& "C:\P1Software\P1TS-Excel\P1TS-Excel-Create-MyRunSheet.ps1"

MyLeaderboard builds an overall leaderboard with car-class color coding and a hero-car highlight; MyRunSheet builds a per-lap run sheet for the hero car. Both pull from the live tables, so run them after those tables have populated at least once.

Stopping the refresh​

Close the PowerShell window, or press Ctrl+C inside it. The workbook is unaffected - data stays until the next refresh.

Troubleshooting​

  • Excel is not open - start Excel with a workbook open first. If Excel is already open and you still see this, your PowerShell window may be running "As Administrator" - use a normal window instead.
  • Login failed / bad credentials - edit P1.USERNAME / P1.PASSWORD in the P1.Excel sheet.
  • Server not found - check P1.URL and your network connection.
  • Script won't run - confirm you completed the execution-policy and Unblock-File step above.