A realistic stadium management data generator specifically designed for Liverpool FC's Anfield Stadium. This web application generates authentic sales data for stadium events, including ticket sales, merchandise, and concessions with real-world pricing and consumption patterns.
- Realistic Ticket Types: VVIP (20,000 seats), VIP (40,000 seats), Standard (38,000 seats), Kids (2,000 seats)
- Dynamic Pricing: Variable ticket prices based on demand/supply (±30% variation from base prices)
- Seat Tracking: Total seats sold, remaining seats, and capacity management
- Revenue Calculation: Automatic calculation of total ticket sales (Price × Seats Sold)
- Jersey Sales: Real Liverpool FC merchandise pricing (€70-90 per unit) with quantity tracking
- Team Scarf Sales: Authentic Anfield scarf prices (€14-17 per unit) with quantity tracking
- Snacks Sales: Real stadium concession prices (€2.50-6.00 per unit) with quantity tracking
- Soft Drink Sales: Authentic beverage pricing (€2.50-3.50 per unit) with quantity tracking
- Alcohol Sales: Real Anfield beer prices (€2.00-6.00 per unit) with age restrictions and quantity tracking
- Age-Appropriate Sales: No alcohol sales for kids ticket holders
- Realistic Consumption: Sales volumes vary by ticket type and customer demographics
- Date Management: Chronological ordering with one entry per ticket type per match day
- UK Formatting: British date format and Euro currency
- Calculation Verification: All sales totals calculated as Unit Price × Quantity Sold for data accuracy
- Modern web browser (Chrome, Firefox, Safari, Edge)
- No installation required - runs entirely in the browser
- Open
index.htmlin your web browser - Set the number of match days (1-365)
- Click "Generate Data" to create realistic stadium sales data
- Preview the data in the scrollable table
- Click "Download Excel" to export as .xlsx file
The generator creates the following columns with unit pricing and quantity tracking:
| Column | Description | Example |
|---|---|---|
| Sale Date | Match date in UK format | 15/10/2024 |
| Ticket Type | VVIP, VIP, Standard, Kids | Standard |
| Ticket Price | Dynamic pricing with demand variation | €85 |
| Total Seats Sold | Seats sold for this ticket type | 32,450 |
| Remaining Seats | Unsold seats for this ticket type | 5,550 |
| Total Ticket Sales | Price × Seats calculation | €2,758,250 |
| Jersey Unit Price | Price per jersey | €80 |
| Jerseys Sold | Number of jerseys sold | 855 |
| Jersey Sales | Unit Price × Quantity | €68,400 |
| Scarf Unit Price | Price per scarf | €15 |
| Scarfs Sold | Number of scarfs sold | 1,213 |
| Team Scarf Sales | Unit Price × Quantity | €18,195 |
| Snack Unit Price | Price per snack item | €3.50 |
| Snacks Sold | Number of snacks sold | 7,029 |
| Snacks Sales | Unit Price × Quantity | €24,601 |
| Soft Drink Unit Price | Price per drink | €3.00 |
| Soft Drinks Sold | Number of drinks sold | 5,833 |
| Soft Drink Sales | Unit Price × Quantity | €17,499 |
| Alcohol Unit Price | Price per alcoholic beverage | €3.80 |
| Alcohol Sold | Number of alcoholic drinks sold | 2,800 |
| Alcohol Sales | Unit Price × Quantity (€0 for Kids) | €10,640 |
- VVIP: €250 base (±30% variation)
- VIP: €150 base (±30% variation)
- Standard: €75 base (±30% variation)
- Kids: €35 base (±30% variation)
- Total Stadium Capacity: 100,000 seats
- Occupancy Rate: 60-95% of capacity per ticket type
- Realistic Distribution: Higher occupancy for popular matches
-
Unit Pricing: Each item has variable pricing based on type and demand
- Jerseys: €70-90 (official Liverpool FC merchandise)
- Scarfs: €14-17 (authentic Anfield scarfs)
- Snacks: €2.50-6.00 (pies, burgers, hot dogs)
- Soft Drinks: €2.50-3.50 (sodas, water, tea)
- Alcohol: €2.00-6.00 (beer, spirits) - €0 for Kids
-
Quantity Generation: Realistic consumption patterns by ticket type
- VVIP: Higher merchandise purchases, moderate concessions
- VIP: Balanced merchandise and concession purchases
- Standard: Lower merchandise, highest concession volumes
- Kids: Age-appropriate quantities, no alcohol
-
Total Sales Calculation: All totals verified as Unit Price × Quantity Sold
-
Seasonal Variation: August to May football season dates
- HTML5: Semantic structure and accessibility
- CSS3: Modern styling with gradients and responsive design
- Vanilla JavaScript: Data generation and Excel export
- SheetJS (XLSX): Excel file generation and download
- Chrome 60+
- Firefox 55+
- Safari 12+
- Edge 79+
``` anfield-data-generator/ ├── index.html # Main application file ├── README.md # This documentation └── package.json # Project metadata ```
The application is fully responsive and works on:
- Desktop computers
- Tablets
- Mobile phones
- All screen sizes with adaptive layout
- Modern Design: Gradient backgrounds and smooth animations
- Scrollable Preview: View all data columns with horizontal/vertical scrolling
- Real-time Generation: Instant data creation and preview
- One-Click Export: Direct Excel download with timestamp
- User-Friendly: Intuitive interface with clear instructions
Perfect for:
- Stadium Management Analysis: Revenue forecasting and capacity planning
- Excel Assignments: Realistic data for spreadsheet projects with verifiable calculations
- Business Analytics: Understanding customer behavior patterns and pricing strategies
- Educational Projects: Learning data analysis with authentic datasets
- Financial Modeling: Revenue stream analysis and projections with unit economics
- Inventory Management: Track merchandise and concession quantities sold
- No Data Collection: All processing happens locally in your browser
- No Server Communication: Completely offline after initial load
- Secure Generation: Random data generation with no personal information
This is a standalone educational tool. For suggestions or improvements:
- Review the code structure in
index.html - Test changes thoroughly across different browsers
- Ensure data remains realistic and mathematically consistent
This project is open source and available for educational use.
- Liverpool FC: Inspiration for authentic Anfield Stadium data
- Real Pricing Data: Based on actual stadium concession and merchandise prices
- Stadium Management: Realistic capacity and operational constraints
- Unit Economics: Authentic per-unit pricing and consumption patterns
Generated Data Disclaimer: All data is randomly generated for educational purposes and does not represent actual Liverpool FC sales figures or stadium operations.
Copyright © 2025 flickk_