P1TS Excel Live

Live race data from your P1TS server streamed directly into Excel

What you need

Files

FilePurpose
P1TS-Excel.ps1Main refresh engine – run this to start live data
P1TS-Excel-Common.ps1Shared helpers (required, loaded automatically)
P1TS-Excel-Create-Shortcut.ps1Creates a desktop shortcut for easy launching
P1TS-Excel-Create-MyLeaderboard.ps1Builds an optional My.Leaderboard formula sheet
P1TS-Excel-Create-MyRunSheet.ps1Builds an optional My.RunSheet formula sheet
favicon.icoIcon used by the desktop shortcut

Setup steps

1

Download all files to one folder

Open PowerShell and run the block below. It creates C:\P1Software\P1TS-Excel and downloads every file in one go.

$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"
    Write-Host "Downloaded $f"
}
Write-Host "Done. Files saved to $dest"
If you see a security warning about running scripts, see Step 2.
2

Allow PowerShell scripts to run (one-time)

Windows blocks unsigned scripts by default. Run these once in a normal PowerShell window (not As Administrator):

Set-ExecutionPolicy -Scope CurrentUser RemoteSigned

Then unblock the downloaded files so Windows trusts them:

Get-ChildItem "C:\P1Software\P1TS-Excel\*.ps1" | Unblock-File
3

Create a desktop shortcut (optional but recommended)

This creates a P1TS Excel Live shortcut on your Desktop so you can launch it with one click:

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

Open Excel and start the live refresh

Open (or create) an Excel workbook, then double-click the P1TS Excel Live desktop shortcut created in Step 3.

Or, if you skipped the shortcut, run from PowerShell:

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

On first run it creates a P1.Excel sheet in your workbook with these settings:

Edit those cells, save, and the script picks up the new values on the next cycle – no restart needed.

The script creates P1.Leaderboard, P1.Laps and P1.Stints sheets automatically and keeps them up to date.
5

Optional: build formula sheets

These scripts add pre-built formula sheets (e.g., MyLeaderboard, MyRunSheet) that pull from the live tables (P1.Leaderboard, P1.Laps). Run them once with the P1TS workbook active in Excel:

Excel must be open with your workbook active before running these scripts. Also run them after the refresh script has populated the live tables at least once, or with the refresh script already running.

Overall leaderboard with car-class color coding and hero-car highlight:

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

Per-lap run sheet for the hero car:

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

Stopping the refresh

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

Troubleshooting