Back to blog
MEAL COUNTER 10 Aug 2026 · excel-to-web

From Excel to MessMax: why we rebuilt MAY MEAL COUNTER

A paper or Excel meal counter usually records the date, daily bazar cost, every member’s meals, deposits and final balance. MessMax keeps that familiar structure online so the manager and members work from one current sheet instead of forwarded files.

How the meal counter calculates your meal rate

The monthly formula is simple: Meal Rate = Total Bazar Expense ÷ Total Meals. For example, ৳14,098 of bazar divided by 269 meals gives a ৳52.41 meal rate. MessMax applies that rate to each member’s meal count, includes shared extras, then compares spend with deposits to show who should pay or receive money.

Daily meals, guest meals and meal-off requests

Members can record decimal meals, request a meal off and add guest meals. Approved changes feed the same monthly count, helping a mess manager avoid retyping totals at settlement time.

From Excel meal sheet to one live ledger

The original MAY MEAL COUNTER.xlsx proved the formula. The web version adds auto-save, email invitations, member roles and monthly manager handover while preserving the calculation people already understand.

May 2026 verified · Bazar 14,098 · Meals 269 · Rate 52.41 · Sample balances: +167, +30, +354, +41, −457, −136