Spreadsheets are good at sums but bad at showing where the money goes. This template lays out an offsite budget as a diagram, with each category adding up its line items and the event total worked out for you. Change a number and every total updates as you type.
Team offsite budget - [*vertical] Venue -- [*+3000] Meeting room hire -- [*+450] AV equipment - [**3] Meals for 3 days -- [*+600] Lunch -- [*+250] Coffee and snacks - [**12] Travel for 12 people -- [*+180] Train fare -- [*+40] Taxis - [*vertical] Extras -- [*+300] Team activity -- [*+150] Printing and signage
[*+450]. Categories add up their lines automatically.[**3], for example for three days or three people. See values and totals.*noValue. It still counts toward the total.The full syntax is in the guide.