Indroduction
This spreadsheet is designed to assist in the management of the London Millennium Eye.
Basic Features
- Waiting Times
- Total takings from a day
- Total number of people going through the system.
Opening the spreadsheet
- Double click on the ‘Millennium Eye’ excel file.
Navigating the spreadsheet
At the bottom of the screen you will see the above buttons. Click the button of which screen you want to view or edit.
Using the Main Ticket management system
Other information about the design and what happens when certain data is entered
This column is the total number of people in the group and will automatically change colour depending on whether they will be charged the Individual rate or the group reduced rate.
The colour will automatically change depending on the attracting rating (See the section about Other Attractions for further information)
Entering a new party’s information into the spreadsheet
Using the Capsule Availability sheet
When ever there is a private booking or a capsule becomes unavailable this needs to be entered in to the spreadsheet.
When you want to add a private booking or show a capsule as unavailable. The engineers have to fill in this form.
- Select which Capsule you want to edit
- Type in a letter in the column next to the number
-
A = Avilable
- P = Private Booking
- U = Unavilable
-
Then you need to put the number ‘1’ in the correct column and remove the ‘1’ from the other column.
Setting Prices of Admission and Guide Books
This can all be done from the same sheet.
All you need to do on this screen is change the prices for the different denominations of people. You can also change the price of the guide book.
Other Attractions feature
This feature will tell people have to wait a long time what other attractions that they will have time to do. The suggestions are split up into 3 blocks, A,B & C.
The colour of the waiting time will change according to the section they can choose from.
End-User Feedback Form
Please fill in the form below by circling the correct number and writing your comments in the box.
Appearance
Ease of understanding of main interface 1 2 3 4 5 6 7 8 9 10
Colour scheme 1 2 3 4 5 6 7 8 9 10
Sheet general appearance 1 2 3 4 5 6 7 8 9 10
Comments of appearance of spreadsheet………………………………………………..
………………………………………………..
Ease of Use
Using the main interface 1 2 3 4 5 6 7 8 9 10
Entering data into the sheets 1 2 3 4 5 6 7 8 9 10
Using the Pricing & Availability sheets 1 2 3 4 5 6 7 8 9 10
Comments on how easy to use ………………………………………………..
the spreadsheet is to use
………………………………………………..
User Guide
Understanding level 1 2 3 4 5
1=Hard to Understand 5=Easy to Understand
Appearance of user guide 1 2 3 4 5 6 7 8 9 10
Colour scheme of user guide 1 2 3 4 5 6 7 8 9 10
Comments on the user guide ………………………………………………..
………………………………………………..
Other comments on the spreadsheet ………………………………………………..
interface
………………………………………………..
………………………………………………..
Evaluation of User Feed-back form
My tester used both the program and the user guide and found that it was easy to understand. My tester has hardly ever used a computer before. Although she did find a problem with the theory of the system. This is that the spreadsheet will not delete customers after that have travelled on the eye. This is something I would try and solve if I could implement a clock into the system. My tester also thinks the program and the user guide had good design and were easy to use.
How I made my system
I used Microsoft Excel 2002 to make and manage my system. I am now going to show you how I designed and implemented formulas into my spreadsheet.
- First of all you will need to run Microsoft Excel. Double Click on the excel icon in your start menu.
- Click on ‘Start’
- Open the ‘Microsoft Office’ folder
- Click on ‘Microsoft Excel’
Or you can double click on the icon on your desktop.
Once in Excel I had to create different ‘sheets’ for each part of the system.
Adding Worksheets to a Workbook
- Right click on ‘Sheet1’ at the bottom of the sheet and the select Insert
-
Select ‘Worksheet’ from the dialogue box which appears.
- Repeat this process 4 times so you will have 5 Sheets for
- Ticket Issues
- Prices
- Availability
- Other Attractions
- LED Clock
Note: You can also colour these items by right clicking on each one and selecting ‘Tab Colour’
As I was designing a system for the London Millennium Eye I thought I had better include the company logo somewhere in the system. I downloaded this from the London eye website (www.londoneye.co.uk)
Inserting a picture into a worksheet
- Click on the cell in your worksheet that you want to insert this into (A)
-
Go to the ‘Insert’ menu and select ‘Picture’ and Click ‘From File’ (B)
- The insert picture dialogue will appear.
- Select the location of the picture you would like to insert using the ‘Look in’ Dialogue box (shown in Red)
- Then double click on the picture you would like to insert and it will be added to your worksheet.
Then I added the main screen for adding new people into the system
As you can probably see I have a created 5 different columns. I have resized these using the bars at the top of the page (not shown on this picture). The Total people column has a formula in which will automatically work out the number of people by adding together all the 4 columns before it. (Adult, Child, Senior and Diab.) This will automatically change colour depending whether the party will count as a Family or a Large Group. I have done this using ‘Conditional Formatting’.
Making a cell change colour when the value is Greater than or less than a certain number.
- Select the cells which you want to be automatically formatted.
-
Click ‘Format’ and the ‘Conditional Formatting’
-
Fill in the dialogue as appropriate
-
Click ‘Format’ to select what happens when the condition is true
Explaination of Formulas
The main formula in my spreadsheet is the one that works out the waiting time. This is found at the top of the main Sheet.
This formula is split in to two parts. One part shows the waiting time in seconds and then the other part converts this to minutes (rounded up).
PART 1 (into Seconds)
This is where the formula is worked out in seconds. The formula is
=SUM (I6*4) + (I10*30)
PART 2 (into Minutes)
=SUM (I2/60)
This formula just takes the total waiting time in seconds (I2) and divides it my 60 which is the number of seconds in a minute.
Another main but basic formula within my spreadsheet is the one which adds up the total cost of entry by getting data from the main sheet and the prices sub-sheet.
This is the cost of entry sheet.
This is the indivual party information row. This displays the total number of people in the party and also shows a total cost for the party.
The spreadsheet will show the prices for both types of ticket Indivudual and Group tickets. If there are over ten people in a party it will be charged the group price (shown in the blue column) and if there are under 10 people you will be changed the individual price (shown in the orange column). The Total People column will change colour according to which price category they should be in. Making it easier for the cashier selling tickets.
Looking at prices for Individuals parties.
The formulae I am looking at is in this column for individuals/parties.
The formula times the number of adults, children, senior citizens and disabled people with the cost for that particular person in the prices sheet.
For example
Adults are charged the adult price (5 x £9.50)
Children are charged the children price (3 x £5.00)
Seniors are charged the Seniors price (1 x £7.50)
Disabled people are changed the disabled price. (0 x £7.50)
The same happens with the group party column but it times the number of people by prices in the group section.
Entire System Evaluation
When I originally had the idea for my system, some of my ideas were far to complicated to achieve. So I tried to design a more basic system with less complicated things in. If I had been able to I would have added a clock into the system so the spreadsheet could automatically remove peoples information from the list after they have travelled on the eye. I would also like, if time, to try and add a feature for mangers to print a full report of people who have come though the millennium eye over a period of a day, a week etc.