1 / 14

Main Menu

Main Menu. Macro Navigation. Tabs – Menu / Admin / Bands / Venue / Lighting Technicians / Sound Technicians / Bookings / Expenditure. Bands. Area defined as Bands from A2:H100. Venues. Area defined as Venues from A2:I100. Lighting technicians. Area defined as Light from A4:C100.

dora
Download Presentation

Main Menu

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Main Menu Macro Navigation Tabs – Menu / Admin / Bands / Venue / Lighting Technicians / Sound Technicians / Bookings / Expenditure

  2. Bands Area defined as Bands from A2:H100

  3. Venues Area defined as Venues from A2:I100

  4. Lighting technicians Area defined as Light from A4:C100

  5. Sound technicians Area defined as Sound from A4:C100

  6. Booking Details Data Validated to a list from Sound Data Validated to a list from Venues Data Validated to a list from Bands Data Validated to a list from Light Data validation has to be set to INDIRECT to avoid problems with inserting new data

  7. Expenditure

  8. Expenditure

  9. Expenditure Conditional Formatting – colours – Green, red and blue.

  10. Extension - Programmes Area defined as Programmesfrom A3:C100

  11. Extension - Programmes Inserted next to Total Cost Formula for Programme Cost – Assuming half the people will buy a programme =VLOOKUP(Bookings!H3,Programmes,2,FALSE) * (VLOOKUP(C3,Venues,8,FALSE) / 2)

  12. Extension - Programmes Total cost adjusted - =SUM(D3:H3)

  13. Extension - Advertising 2 new columns Advertising charge - Manual entry Advertising revenue - =L3*VLOOKUP(Bookings!H3,Programmes,3,FALSE)

  14. Extension - Advertising Total Income Adjusted - =(K3*Bookings!I3)+M3

More Related