1 / 14

Comprehensive Management for Bands, Venues, and Technical Teams

Streamline your event management process with our comprehensive system encompassing bands, venues, lighting technicians, and sound technicians. This detailed framework includes dynamic data validation to ensure seamless updates while avoiding data insertion issues. With an emphasis on expenditure tracking and conditional formatting for easy visualization, easily analyze your profits and costs. Enhanced with advertising revenues and programme sales projections, this system provides a clear overview of income and expenses, fostering informed decision-making for successful event planning.

dora
Télécharger la présentation

Comprehensive Management for Bands, Venues, and Technical Teams

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