Interactive Google Sheets Seat Map for Music Venue
- or -
Post a project like this£250(approx. $312)
- Posted:
- Proposals: 3
- Remote
- #2116719
- OPPORTUNITY
- PRE-FUNDED
- Expired
Description
Experience Level: Intermediate
Context
The commission is for the build of an interactive venue seat map, built in Google Sheets, with a reporting function for allocation and sale of seats.
My client is ~2,000 capacity music and sports entertainment venue.
The venue has a number of configurations, but for the purpose of this commission there will be just one version which is all seater.
The venue is divided into a number of named sections, each containing multiple seats.
Each seat should hold the following attributes
* Row & Seat number (e.g. A1)
* Price (e.g £10)
* Sold or Unsold
* Designation
* This is the Ticketing Company responsible for selling the seat, example possible designations are:
* Number 1 Ticket Co.
* Best Tickets
* Tickets for You
* Holds
* NB: in the case of the the Booths each seat will hold a slightly different format to signify that a seat is located within a specific numbered booth (Booth and Seat e.g. B10S3)
There are three core requirements for this commission
1. To build out the Venue Seat Map to the specifications provided
2. To allow the user to assign attributes to a pre-built seat map
- The expectation here is that a combination of lookups and formatting be used to allow cells to carry multiple attributes, and for add ons / macros to be used to allow for these attributes to be easily assigned by the user
3. To allow the user to report on the designations and sales of all seats contained within the map
Seat Map Build
* Below is a link to a google sheet of the seat map itself which should be used as the basis for the commission
* You will see that there are a number of sections
* Circle Block 1
* Circle Block 2
* Circle Block 3
* Circle Block 4
* Circle Booths
* Circle Front Row
* Ground Floor Seating
* Accessible Ground Floor Seating
* Lower Ground Floor Seating
* The value of each cell in the map is the seat number, the rows can be seen in columns A and BM
Assigning of Attributes Requirements
* In order to perform the following, the user should not have to edit the contents of cells directly
* User should have the ability to select a range of cells and assign a PRICE to all the seats represented by those cells
* User should have the ability to select a range of cells and assign a DESIGNATION to all the seats represented by those cells
* User should have the ability to select a range of cells and mark the seats represented by those cells as SOLD or UNSOLD
* User should NOT have the ability to add or remove seats from the map
Reporting Requirements
The second core requirement of the commission is for the built seat map (once the user has finished assigning attributes to the seats) can be automatically evaluated such that the following metrics are calculated:
* Number of seats assigned to each designation
* Number of seats sold by designation
* Number of seats unsold by designation
* Value of seats assigned to each designation
* Value of seats sold by each designation
* Value of seats unsold by designation
* Total number of seats sold by Venue section
* Total number of seats unsold by Venue section
* Total number of seats sold
* Total number of seats unsold
* Total value of seats sold
* Total value of seats unsold
These metrics should be organised in a dedicated sheet such that they can be easily referred to and exported by the user.
The deadline for this work is 5pm Monday 27th August, with a first draft/ progress update requested by 12pm Friday 24th August.
The budget is £250
https://docs.google.com/spreadsheets/d/114Egb6XC8vtjtyMb1cqc2Q13mz9YKT4pJfgDp2z0qBw/edit?usp=sharing
The commission is for the build of an interactive venue seat map, built in Google Sheets, with a reporting function for allocation and sale of seats.
My client is ~2,000 capacity music and sports entertainment venue.
The venue has a number of configurations, but for the purpose of this commission there will be just one version which is all seater.
The venue is divided into a number of named sections, each containing multiple seats.
Each seat should hold the following attributes
* Row & Seat number (e.g. A1)
* Price (e.g £10)
* Sold or Unsold
* Designation
* This is the Ticketing Company responsible for selling the seat, example possible designations are:
* Number 1 Ticket Co.
* Best Tickets
* Tickets for You
* Holds
* NB: in the case of the the Booths each seat will hold a slightly different format to signify that a seat is located within a specific numbered booth (Booth and Seat e.g. B10S3)
There are three core requirements for this commission
1. To build out the Venue Seat Map to the specifications provided
2. To allow the user to assign attributes to a pre-built seat map
- The expectation here is that a combination of lookups and formatting be used to allow cells to carry multiple attributes, and for add ons / macros to be used to allow for these attributes to be easily assigned by the user
3. To allow the user to report on the designations and sales of all seats contained within the map
Seat Map Build
* Below is a link to a google sheet of the seat map itself which should be used as the basis for the commission
* You will see that there are a number of sections
* Circle Block 1
* Circle Block 2
* Circle Block 3
* Circle Block 4
* Circle Booths
* Circle Front Row
* Ground Floor Seating
* Accessible Ground Floor Seating
* Lower Ground Floor Seating
* The value of each cell in the map is the seat number, the rows can be seen in columns A and BM
Assigning of Attributes Requirements
* In order to perform the following, the user should not have to edit the contents of cells directly
* User should have the ability to select a range of cells and assign a PRICE to all the seats represented by those cells
* User should have the ability to select a range of cells and assign a DESIGNATION to all the seats represented by those cells
* User should have the ability to select a range of cells and mark the seats represented by those cells as SOLD or UNSOLD
* User should NOT have the ability to add or remove seats from the map
Reporting Requirements
The second core requirement of the commission is for the built seat map (once the user has finished assigning attributes to the seats) can be automatically evaluated such that the following metrics are calculated:
* Number of seats assigned to each designation
* Number of seats sold by designation
* Number of seats unsold by designation
* Value of seats assigned to each designation
* Value of seats sold by each designation
* Value of seats unsold by designation
* Total number of seats sold by Venue section
* Total number of seats unsold by Venue section
* Total number of seats sold
* Total number of seats unsold
* Total value of seats sold
* Total value of seats unsold
These metrics should be organised in a dedicated sheet such that they can be easily referred to and exported by the user.
The deadline for this work is 5pm Monday 27th August, with a first draft/ progress update requested by 12pm Friday 24th August.
The budget is £250
https://docs.google.com/spreadsheets/d/114Egb6XC8vtjtyMb1cqc2Q13mz9YKT4pJfgDp2z0qBw/edit?usp=sharing
ALASTAIR G.
100% (13)Projects Completed
13
Freelancers worked with
11
Projects awarded
40%
Last project
18 Dec 2023
Australia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies