Booking System

                                                                MY BLOGG (:

For this project,  we will focus on exploring and using excel.

We started with doing an 'introduction' by creating a booking system for a show for our rockband. The system included a wecome page, booking page, finance page and a records page.

 Here is a screen capture of it:

Then the real challenge came in, our aim is to create a booking system on excel for people to join our rock school. I experimented with 2 methods, trying out how I was going to create my booking system.

<-- My first idea was to create something like this:

 My second idea was to create a drop box. However, I ended up choosing the first idea as I thought it would be easier to just click macros to book.

I then improved my first idea and it ended up looking like this: 

I recorded a macro which will add one to the table to book. However, I had to make many macros as each page had 31 macros! I recorded many MANY macros as I often made mistakes... :S Also, sometimes the macros wouldn't work and I would have to redo them..

Here are a list of macros I had made:

• book student (x6)
• book adult (x6)
• book seniors (people over 60 years old) (x6)
• class canceled (x6)
• master reset (x1)
• go to records (x1)
• go to bookings (week 2,3 and 4) (x1)
• go to welcome page (x1) 
• go to finance (x1) 

I colour coded the page so it matches the colour of the macros and Uncle Bo will know at once which page he is on. I also added something that will let Uncle Bo know when the class is full using Conditional Formatting.

I then did my finance page and as I had 4 weeks which lessons can be booked, I had to create 4 finance pages. I didn't want to do the bother of creating more macros, I did a finance 'main page' and put all the macros for the finance there, that way I didn't have to do as many macros.

For the finance page, again I only did one page and copied and pasted it 3 times and altered it.

As you can see, I also colour coded the pages. 

For the Total Classes the tutor is coming, I used the formula 'IF statement'. 

I typed in something like this: =IF('Bookings Week 3'!E10>11,1,0) Then I added them all together in the "Total Classes" column.

For the Days Tutor is coming, I also used the 'IF statement' formula and typed in something like this:

=IF(I35<1,0,1)

Finally, I did my records page. For that, I made 4 different pages for each week and I made macros which copied the values from the finance page and pastes it on the records page.

I also did a welcome page:

For this unit, I have also used a few links and tutorials to help with my booking system. I had had trouble trying to use conditional formatting as I had forgotten how to use it, fortunately this link helped me 'revive' my memory of how to use it. It was quite useful as it included screen captures, however, I thought it included a little more text than I would have liked.

http://www.timeatlas.com/5_minute_tips/general/how_to_use_conditional_formatting_to_highlight_data 

This is also a very useful site on the formulas on excel. It is very clear and include screen captures. This site has helped me a lot during this project.

http://spreadsheets.about.com/od/excelfunctions/Using_Excel_Functions_in_Spreadsheets.htm