Please check your email
The Pub Command Centre is a complete pub management SOFTWARE built by a pub landlord for pub landlords.
This isn't just a spreadsheet — it's a fully automated system built in Google Sheets with custom scripts that do the heavy lifting for you. One click to set weekly targets. One click to compare this year vs last year. One click to archive your figures.
Inside you get:
✓ 23 automated Google Sheets
✓ Built-in OPERATOR TOOLS menu (5 automated functions)
✓ Staff shift logging sidebar
✓ One-click weekly target setting (+10% on last year)
✓ Live daily performance vs. last year comparison
✓ Automatic sales archiving to your data vault
✓ Financial tracking (revenue, costs, profit)
✓ Labor cost management & optimization
✓ Stock inventory control & ordering system
✓ Profitability analysis by drink type
✓ Weekly rota & wage planning with labor % tracking
✓ Energy cost tracking by equipment
✓ Kitchen & food safety compliance
✓ Fire safety, cleaning & garden compliance logs
✓ Pricing engine with GP% calculations
✓ Completely customizable to your pub
✓ Sample data from a real pub operation (The Teal Farm)
AUTOMATED OPERATOR TOOLS (built-in scripts):
🎯 FETCH TARGETS — One click to set weekly targets from last year +10%
📝 BUILD DAILY OPS — Instant live vs. last year comparison
💾 COMMIT TO VAULT — One click to archive weekly figures
🛠️ STAFF DASHBOARD — Rebuild staff view instantly
📦 STOCK AUDIT — Generate stock audit tool
What Makes This Different:
• Not a template — a working SOFTWARE with automation built in
• Custom Google Apps Script does the repetitive work for you
• Staff shift logger sidebar — enter shifts without touching the rota
• One-click workflows replace hours of manual spreadsheet work
• Built from real pub operations, not theory
Perfect For:
→ Pub owners who want control of their numbers WITHOUT spreadsheet skills
→ Managers tracking performance weekly with minimal effort
→ New landlords who need a complete system from day one
→ Anyone who wants automated pub management, not another template
Time to set up: 30 minutes
Time to see results: 1 week
Money saved by tracking: £1,000s annually
Includes:
• Pub Command Centre Google Sheet (23 sheets + automation scripts)
• Installation Guide PDF (23 pages)
• Quick Reference Card (1-page cheat sheet)
• Script Documentation (full guide to the automation)
• Email support
PRICE: $97.00 USD (one-time payment)
UPSELL OPTION:
Setup Call with Shaun ($50)
30-60 minutes of personalized help to get everything installed, scripts authorized, and running perfectly.
b command centre scripts · TXTTextEdit
PUB COMMAND CENTRE - GOOGLE APPS SCRIPT DOCUMENTATION
=======================================================
OVERVIEW
--------
These scripts automate data syncing, performance comparisons, and archiving
so you spend less time on spreadsheets and more time running your pub.
HOW TO ACCESS
-------------
When you open the Pub Command Centre in Google Sheets, you'll see a
custom menu appear: 🚀 OPERATOR TOOLS
This menu contains 5 automated tools:
1. 🎯 FETCH YEAR_3_TARGETS (+10%) - Syncs targets and live sales
2. 📝 BUILD DAILY OPS (Live vs. Last Year) - Creates performance comparison
3. 💾 COMMIT DAILY SALES TO VAULT - Archives your figures
4. 🛠️ REBUILD STAFF DASHBOARD - Resets staff data view
5. 📦 BUILD COMPLETE AUDIT TOOL - Generates stock audit tool
SCRIPT 1: FETCH YEAR 3 TARGETS
-------------------------------
What it does:
- Reads the current Week ID from Weekly_Rota (cell B1)
- Finds last year's matching week (e.g., Week 423 → looks up Week 323)
- Calculates +10% targets from last year's actual figures
- Pushes targets to Row 3 of Weekly_Rota
- Pushes live current-year sales to Row 4 (highlighted yellow)
- Splits daily figures across AM/PM columns
When to use: Start of each week to set your targets and see live data.
SCRIPT 2: BUILD DAILY OPS
--------------------------
What it does:
- Creates/refreshes the Daily_Ops sheet
- Side-by-side comparison: Last Year vs This Year
- Calculates growth % for each day (Sun-Sat)
- Color codes: Row 3 (last year) in grey, Row 4 (this year) in yellow
- Row 5 shows growth percentage with +/- formatting
When to use: Daily, to see how you're tracking against last year.
SCRIPT 3: COMMIT DAILY SALES TO VAULT
--------------------------------------
What it does:
- Takes your live figures from Daily_Ops Row 4
- Finds or creates the matching week in DATA_VAULT
- Saves the figures permanently
- If the week already exists, updates it; if not, creates a new row
When to use: End of each week to lock in your final figures.
SCRIPT 4: REBUILD STAFF DASHBOARD
----------------------------------
What it does:
- Resets the Staff_DB view
- Useful if data gets jumbled or you need a fresh layout
When to use: Occasionally, when staff data needs tidying up.
SCRIPT 5: BUILD STOCK PAR TOOL
-------------------------------
What it does:
- Generates the stock audit framework
- Sets up PAR level tracking for your inventory
When to use: When setting up stock management for the first time or resetting.
STAFF SHIFT LOGGER (HTML SIDEBAR)
----------------------------------
The product also includes an HTML-based shift logging tool that appears
as a sidebar in Google Sheets:
Features:
- Select the shift day (Sunday through Saturday)
- Add up to 14 staff members per shift
- Enter name and hours for each person
- Click "COMMIT ALL TO COCKPIT" to log shifts directly into the rota
How it works:
- The sidebar sends data to the logStaffShifts() function
- Staff names and hours are written to the Weekly_Rota sheet
- This feeds into labor % calculations and wage cost estimates
FIRST-TIME SETUP
-----------------
When you first open the Pub Command Centre:
1. Google will ask you to AUTHORIZE the scripts
→ Click "Continue" then "Allow" (this is normal for custom scripts)
→ The scripts only access YOUR spreadsheet, nothing else
2. The 🚀 OPERATOR TOOLS menu will appear at the top
3. Start with: OPERATOR TOOLS → FETCH YEAR_3_TARGETS
This syncs your first week of data
4. Enter daily sales as they come in
5. At end of week: OPERATOR TOOLS → COMMIT DAILY SALES TO VAULT
WEEKLY WORKFLOW WITH SCRIPTS
-----------------------------
Monday morning:
1. Open Pub Command Centre
2. Click OPERATOR TOOLS → FETCH YEAR_3_TARGETS
→ This sets your weekly targets (+10% on last year)
→ It also pulls in any sales already entered
During the week:
3. Enter daily sales into DATA_VAULT as they come in
4. Use the Staff Shift Logger sidebar to log shifts
5. Click OPERATOR TOOLS → BUILD DAILY OPS to see live comparisons
End of week (Saturday night or Sunday morning):
6. Click OPERATOR TOOLS → COMMIT DAILY SALES TO VAULT
→ This permanently archives the week's figures
Monthly:
7. Review Weekly_Cockpit dashboard
8. Check labor % in Weekly_Rota
9. Update Pricing_Engine if costs have changed
TROUBLESHOOTING
----------------
Q: The OPERATOR TOOLS menu doesn't appear
A: Refresh the page. The menu loads via onOpen() which runs when you
open the sheet. If it's your first time, you may need to authorize.
Q: "Authorization required" popup
A: Click Continue → choose your Google account → click Allow.
The scripts only access this spreadsheet.
Q: Script says "Week not found in Vault"
A: Make sure DATA_VAULT has a row with last year's matching week ID.
E.g., if current week is 425, you need a row for week 325.
Q: Shift logger isn't saving
A: Make sure you've authorized the scripts. Try closing and reopening
the sidebar.
TECHNICAL NOTES
----------------
- Scripts are written in Google Apps Script (JavaScript-based)
- All automation runs server-side within Google's infrastructure
- No external APIs or services are called
- Data stays entirely within your Google Sheet
- Scripts are viewable via Extensions → Apps Script
SUPPORT
--------
Email: info@smartpubtools.com
Setup Call: $50 (30-60 minutes, we'll configure everything together)