Be sure to fill in the green fields only. Enter tips and hours for each bartender that worked a particular shift, even if charge tips and hours are zero. That’s important for the formulas. For a straight pool, enter the number of hours for each bartender anyway – it won’t matter what the actual numbers are in that instance. The spreadsheet will calculate the rest automagically.