Scribd
Upload
15 views6 pages

Local Football Club Ticket Management Spreadsheet

This spreadsheet holds information for managing seasonal tickets for a football club. It contains tables for contact details, prices, and availability. Formulas automatically assign ticket types and prices based on age. Charts and tables organize and display the data. Buttons allow quick navigation between worksheets.

Uploaded by

joseph
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views6 pages

Local Football Club Ticket Management Spreadsheet

This spreadsheet holds information for managing seasonal tickets for a football club. It contains tables for contact details, prices, and availability. Formulas automatically assign ticket types and prices based on age. Charts and tables organize and display the data. Buttons allow quick navigation between worksheets.

Uploaded by

joseph
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Seasonal ticket

By. Boja Florian

Spreadsheet Information
In this spreadsheet the main aim is to create a local football club which works on the personal
details and purchase department to forward the idea and show the spreadsheet can manage
information of large quantities for each season ticket holder. I have made tables for each of
the data entered. The first column is named “Surname”, this is to hold the user’s surnames. I
have done the same to the second column which holds the first name of each user. In the third
column I have put the ages of each user, this will allow the program to understand in which
category the user will fall in (e.g. child, adult, concession). This will then automatically be
written in the 9th column where the “Ticket types” are located which will then correctly
assign the user to that ticket.
In the other column I have put postcodes/addresses/telephone numbers and email addresses
these which will be used to track payments of the user and locate him in case of any trouble.
The ticket types then contribute by showing the ticket types for each age group, this is very
useful as the user will know what ticket type, he has gotten and how much money he has
spent on it. Once the user purchases the ticket he will get a “ Date of application” which will
determine when he/she purchased the tickets. The column after that will show if the
application was successful or not.
The user is then required to choose the number of tickets purchased which will then allow
them to enter the personal information about all the other people attending with him. This
will then automatically assign them with the seats allocated to each person and with a unique
ticket code. Lastly each ticket will have the same expiry date which will automatically make
the ticket unavailable after that specific date.

User requirements?
The Football club have asked for a detailed spreadsheet which manages information which
specifies o the clubs. Details will usually include “Personal Information” and what (type of
ticket) criteria, the user will fall under. Also, the spreadsheet, will have to include an area
where the user can identify if the application had been successful or not. Finally, the user will
have a section where the expiry date of the ticket could be entered if at any time the applicant
would like to require into a new Season ticket, they will still have their unique ticket code.

Selected Spreadsheets
[Link] Holder spreadsheet
-This will contain the following: contact details, time and dates, seating area, prices,
application result, ticket amounts, seat availability.
2. Summary of Information
- This will contain the following: graphs, charts, pivot tables, calculations, Sand formulas.

Spreadsheet Information
This spreadsheet holds the information of each ticket and seats allocated to each person, also
there are charts and tables where the data is organized and displayed in a user-friendly way.
This worksheet holds all the formulas necessary to link the ticket types to their prices and the
ticket types to the users specified ages. This also holds the available seating area that will be
distributed when the user specifies how many seats they want.
On this worksheet there are two graphs that explain and display the statistics of the seasonal
ticket matches as the it analyses the tickets bought and the tickets approved and makes a bar
chart and a pie chart to represent this data in a organized way. I would also add to this page a
micro button to switch between the worksheets and make it faster for the user to access. `
Requirements
The user has been asked to create a reliable source of information that is determined by the
number of visits to each game and the amount of money spent at each event.

Plan Feedback
Based on the feedback that I got I will change my spreadsheet and improve it by adding
micro buttons for better accessibility and make the VLOOKUP functions work in a user-
friendly way. This will help me to improve user experience and functionality as the
worksheets will be faster and smoother to navigate then before and this will allow the user to
make better and faster decisions in changing or finding data in the database.

After considering everyone’s feedback this is what I have come up with:


In this design I have improved the accessibility system of the worksheets as I have added
micro buttons which help and benefit transport from one worksheet to another, the buttons
can also be used to faster access data types. In this design I have also improved the formulas
that help the program to automatically set the ticket types and ticket prices based on the users
age, this worked well as I have tested the formulas multiple times and also made different
backups for them.

The design can be taken a step further with a better design by adding more colour and a more
user friendly background to make the worksheet better to view. This can be done by also
adding more colour to the table which can improve the overall appearance of the spreadsheet.

The Test Plan


Test Evidence Successful?
Drop down Menu’s This will be used to hold The drop-down menu was
large amounts of data in indeed successful the first
each cell that can be easily time that it was tested. This
accessed by pressing a helped in storing large
button which then will show amounts of information in
all the available data. These one cell and distributing it
menu’s will be used in the all at any time.
requested ticket amount.
IF statements If statements were used in The IF statements were
this database to determine really helpful as the
“TRUE” or “FALSE” organisation of the seating
matters. They are also used areas are very smooth and
to assigning specific reliable, also the “true or
applicants to specific seating false” are working according
areas. to plan.
VLOOKUP The VLOOKUP I am going The VLOOKUP was
to use will require a formula successful as I have
which will connect the ticket allocated all the ages to the
prices to the age groups ticket types which then
which will then display the automatically allocated them
ticket type of (children, to the ticket prices.
adult or concession). The
user can also edit the age so
that if he/she made a
mistake then the formula
will distribute a different
ticket type.
Macro’s I thought of adding Macro’s This was successful and was
which will give me the very useful to the applicant
ability to add buttons to the as the switching between the
spreadsheet, this will give spreadsheets moved
me a faster way to switch smoothly.
between the spreadsheets.
Conditional Formatting The conditional formatting This has been proven to be
will help determine the high really help full as not only
or low probabilities between its user friendly and
scores and locations as it can colourful but also really
be used to show the helpful when checking for
availability of seats at the available seating spaces.
match.
Date of Application The date of application will This is really helpful as we
be shown in the database as can see exactly when each
I want to make the date to ticket was bought.
appear as soon as the user
writes something in the
cells. The date that will be
shown in the cells will be
the specific date it was
written on.

The Formulas used:


VLOOKUP: (=INDEX (Index! N5:N103, MATCH (D5, Index! M5:M103))
-this is used to assign the ages to the ticket type which will be displayed on the screen.)

(=INDEX (Index! C5:C7, MATCH(J5, Index!B5:B7)) -this is used to assign the ticket type
to the amount of money it costs ).
IF statements
(=IF(N5=2,”2”,IF(N5=3,”3”,IF(N5=4,”4”,IF(N5=5,”Check

availability”, IF(N5=6,”Check Availability”))))

-This will calculate the seating area and determine whether the seat is available or not.

References

[Link]

[Link]

[Link]

advanced_spreadsheets_handbook-Microsoft_Excel.pdf

Common questions

Powered by AI

The relationship between ticket types and seating allocations is managed by associating each ticket type with specific seating areas, using functions like VLOOKUP to link ticket prices to age groups. This relationship is crucial for efficiently managing seasonal tickets as it ensures that each ticket holder receives the appropriate seating based on their ticket type, optimizing seat allocation and enhancing the overall event organization .

Summarizing information through graphs, charts, and pivot tables is crucial as it provides a comprehensive visual representation of ticket sales data, allowing for quick insights into the club's operations. This benefits the football club by enabling data-driven decisions through clear analysis of statistics, such as the number of tickets bought and approved, enhancing marketing strategies, and operational efficiency .

The spreadsheet system improves user experience and decision-making by using micro buttons for better accessibility, allowing faster navigation between worksheets. This streamlined navigation helps users change or find data swiftly . Additionally, the inclusion of drop-down menus enables efficient handling and retrieval of large amounts of data in a single cell, thereby facilitating decision-making regarding seat availability and ticket requests .

The proposed improvements include adding micro buttons for better accessibility, enhancing VLOOKUP functions for ease of use, and improving the spreadsheet's design with more color and a user-friendly background. These improvements address user needs by providing a more intuitive and visually pleasant interface, optimizing performance, and ensuring that navigating and processing data is smoother and faster .

IF statements are integrated into the spreadsheet to manage functionalities such as determining seating area availability and assigning specific characteristics to applications based on 'TRUE' or 'FALSE' conditions. They address scenarios by calculating whether a seat is available and facilitating the smooth organization of seating areas, ensuring the system works reliably .

Macros are integrated to allow quick navigation through spreadsheet functions by enabling the addition of buttons for faster access to different parts of the spreadsheet. This feature is necessary as it significantly enhances the operating experience by making the system more efficient and reducing the time needed to perform functions or retrieve information, ultimately benefiting the user's workflow .

The spreadsheet tracks and displays the application date by automatically showing the date in the database as soon as the user enters information into the cells. This is significant because it provides an exact record of when each ticket was bought, helping ensure accurate tracking and management of ticket sales over time .

The visual appeal and usability of the spreadsheet have been enhanced by adding more color to the tables and the background, making it more user-friendly and visually engaging. These changes improve the overall appearance, making data easier to interpret and work with . Furthermore, adding micro buttons aids in quick navigation, thus enhancing the usability and efficacy of the spreadsheet system .

Conditional formatting in the spreadsheet provides visual cues about the availability of seats by highlighting the high or low probabilities of seat occupancy. This feature makes the data user-friendly and visually accessible, enhancing the process of checking available seating spaces for users .

The spreadsheet system classifies ticket holders by age using VLOOKUP to connect ticket prices to the specific age groups, thereby determining the ticket type (child, adult, or concession). This is implemented by allocating ages to the ticket types which then automatically assigns them to the ticket prices .

You might also like