Event Workspace · Deal 39060198511
ASUG - SAP for Utilities 2026
10/6/2026 · Cody Price · ASUG · San Antonio Marriott Rivercenter · Active
✅Workbook — ASUG - SAP for Utilities 2026✅Sales quote — 6 areas✅Vendor quotes — PRG
✅Workbook
ASUG - SAP for Utilities 2026 · linked by Cody Price on 09/17/2026 6:04 PM
Unlink this workbook
Stops this event reading crew, times and budget from ASUG - SAP for Utilities 2026, and takes the sales push's quoted gear and shipping back off ROY. The workbook itself is not touched; the master Bookings and Conflicts tabs are rebuilt without it straight away. Link the right one afterwards.
✅Sales quote
Pushed — 99 charge lines across 6 areas.
✅Vendor quotes
1 vendor current: PRG
Vendor quote runs (current runs only)
| Vendor | Run date | Grand total | Overcharged | Saved | Matched / unmatched | Reaching margins |
|---|---|---|---|---|---|---|
| PRG | 09/16/2026 | $78,270 | $90 | $5,416 | 49 / 25 | $63,864 |
Reaching margins is this event's spend on that vendor's current Category Breakdown rows (14 rows in total). A dash means the run recorded none.
Sales quote by area (Clarity Charge History, 99 lines)
| Area | Last push | Gear (Clarity Charge History) | Whole quote (event tab, labor in) | No cost recorded | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Items | Charged | Cost | Gear GP | Revenue | Cost | Labor sold | Quote GP | |||
| General Session | 2026-09-17 | 62 | $169,205 | $50,753 | 70.0% | — | — | — | — | 2 items · $6,774 |
| Breakout | 2026-09-17 | 25 | $56,248 | $15,992 | 71.6% | — | — | — | — | 1 item · $96 |
| Unassigned 1 | 2026-09-17 | 1 | $23,940 | $6,840 | 71.4% | — | — | — | — | — |
| Unassigned 2 | 2026-09-17 | 1 | $15,750 | $4,500 | 71.4% | — | — | — | — | — |
| SAP Booth | 2026-09-17 | 3 | $9,000 | $2,522 | 72.0% | — | — | — | — | 1 item · $2,160 |
| SAP Meeting | 2026-09-17 | 7 | $2,535 | $768 | 69.7% | $4,035 | $2,234 | $1,500 | 44.6% | — |
| ASUG UTL GS 9.8 (event tab only) | — | — | — | — | — | $222,845 | $154,216 | $105,816 | 30.8% | — |
| ASUG UTL 2026 BO 7.9 xlsm (event tab only) | — | — | — | — | — | $98,932 | $58,447 | $43,755 | 40.9% | — |
| ASUG UTL Exhall 8.28 (event tab only) | — | — | — | — | — | $63,549 | $34,258 | $20,620 | 46.1% | — |
| SAP Booth 9.8 (event tab only) | — | — | — | — | — | $23,339 | $15,479 | $10,550 | 33.7% | — |
| ASUG SAP for Utilities 2026 Gear List (event tab only) | — | — | — | — | — | $0 | $0 | $0 | — | — |
| Whole show | 6 columns on the tab | — | — | — | — | $412,700 | $264,634 | $182,241 | 35.9% | — |
Blended GP of the whole show: 35.9% — $148,065 gross profit on $412,700 sold, with labor, cable and delivery in. Gross profit over revenue across the show, which is not the average of the areas' percentages. From the ASUG - SAP for Utilities 2026 tab on the master Budget Builder.
Two questions. Gear GP is Clarity Charge History — equipment lines only, what each was charged against what it costs — so it says whether the gear is marked up enough. Quote GP is the quote's own forecast summary with labor, cable and delivery in, so it says what the area, and the show, actually earn.
3 areas with line items quoted at no cost
Cost here is Total Cost on Clarity Charge History, written by the sales push from the Quote tab's cost column — one row per line item. A line with no cost on the Quote tab can still be costed on that quote's Forecast tab: the Quote cost column above carries the Forecast tab's total, so the area is not necessarily short a cost. These are the lines to check against the rate card.
| Item | Lines | Revenue with no cost |
|---|---|---|
| Steel Deck Riser | 1 | $6,720 |
| Spandex - Speaker Stand Cover - Black | 1 | $54 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| Monitor Mount | 1 | $2,160 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| Spandex - Speaker Stand Cover - Black | 1 | $96 |
Sales quote pushes (Budget Paste WS)
Something on Budget Paste WS is not counted below
**1 quote on the Budget Paste WS tab has no name against it.** It is at rows 6-67, worth $222,845.02 against $154,215.81 of cost. The app finds a quote by the name in column F, so it cannot see this one. It is left out of the per-quote table (which lists the 3 it can find), and pushing that quote again would add a second copy rather than replace it — overstating this show by $222,845.02, and nothing else would say so. **To fix it, put the quote's FILE NAME in F6.** That is the same name the app writes itself when you push a quote. The quotes it has already named here are called "ASUG UTL 2026 BO 7.9 xlsm", "ASUG UTL Exhall 8.28", "SAP Booth 9.8", which is the shape to match. NOT the words down the left of it ("Technology", "General Session", "Labor") — those are line labels that turn up on every quote in the show, and a push never matches on them, so one of those gets you a THIRD copy next time instead of a replacement. A version suffix does not matter: `v2` and `(3)` are ignored when the app looks a quote up. **If you cannot tell which file it came from**, delete rows 6-67 and push that quote again: you get one correctly named copy and no duplicate. Nothing here can guess the name for you — the wrong one makes the next push overwrite a different area.
| Area | Revenue | Cost | Gross profit | Sold-at GP % | Forecast GP % |
|---|---|---|---|---|---|
| ASUG UTL 2026 BO 7.9 xlsm | $98,931.75 | $58,446.81 | $40,484.94 | 40.9% | — |
| ASUG UTL Exhall 8.28 | $63,548.75 | $34,258.43 | $29,290.32 | 46.1% | — |
| SAP Booth 9.8 | $23,338.75 | $15,478.67 | $7,860.08 | 33.7% | — |
| Whole show | $185,819.25 | $108,183.91 | $77,635.34 | 41.8% | 38.2% |
Forecast GP % is the producer's forecast for the whole show — the PRODUCER ESTIMATE block at the top of the Budget tab, every cost centre they have entered, labor included. A show figure, so it is on the show row only.
Read 12s ago; served from the 60s window without touching the Sheets quota