# English (UK) event registration workbook for consulting firms
Workbook for sales, attendee check-in, and event revenue visibility.
Audience: Event ops, ticketing, and venue team
## Sales
Track ticket orders, channels, quantities, and payment collection.
Columns: Order ID, Buyer, Tier, Qty, Unit Price, Gross, Paid, Channel, Status
- Order ID: ORD-1001 | Buyer: Chen Studio | Tier: VIP | Qty: 2 | Unit Price: 899 | Gross: =D5*E5 | Paid: 1798 | Channel: Direct | Status: Paid
- Order ID: ORD-1002 | Buyer: 秒搭 Labs | Tier: General | Qty: 4 | Unit Price: 299 | Gross: =D6*E6 | Paid: 1196 | Channel: Partner | Status: Paid
- Order ID: ORD-1003 | Buyer: Open Demo | Tier: Student | Qty: 3 | Unit Price: 149 | Gross: =D7*E7 | Paid: 0 | Channel: Web | Status: Pending
- Order ID: ORD-1004 | Buyer: North Harbor | Tier: Booth | Qty: 1 | Unit Price: 3000 | Gross: =D8*E8 | Paid: 1500 | Channel: Sales | Status: Deposit
## CheckIn
Run check-in, seating, and on-site exception handling.
Columns: Ticket ID, Attendee, Tier, Zone, Check-In Time, Verified, Note
- Ticket ID: VIP-001 | Attendee: A. Chen | Tier: VIP | Zone: Front A | Check-In Time: 2026-03-20 09:10 | Verified: true | Note: Welcome kit delivered
- Ticket ID: VIP-002 | Attendee: M. Lee | Tier: VIP | Zone: Front A | Check-In Time:  | Verified: false | Note: Expected arrival 09:30
- Ticket ID: GEN-101 | Attendee: J. Park | Tier: General | Zone: Main Hall | Check-In Time: 2026-03-20 09:28 | Verified: true | Note: 
- Ticket ID: BOOTH-01 | Attendee: North Harbor | Tier: Booth | Zone: B2 | Check-In Time:  | Verified: false | Note: Needs power setup
## Summary
Use this as the command sheet for ticketing and event operations.
Columns: Metric, Value, Notes
- Metric: Orders | Value: =COUNTA(Sales!A5:A8) | Notes: Order count
- Metric: Tickets sold | Value: =SUM(Sales!D5:D8) | Notes: Total units sold
- Metric: Gross revenue | Value: =SUM(Sales!F5:F8) | Notes: Before refunds
- Metric: Collected | Value: =SUM(Sales!G5:G8) | Notes: Cash already received
- Metric: Pending orders | Value: =COUNTIF(Sales!I5:I8,"Pending") | Notes: Needs collection follow-up