Free weight loss group spreadsheet template

What is in the template

• Name and week: one row per person and weigh-in.
• Last week’s weight and the weigh-in weight.
• Change in %: ready-made formula =(C2-D2)/C2*100, positive means less.
• Weight points: enter them from the corridor table below, enter 0 if someone did not weigh in.
• Weighed in: 1 if weighed in on weigh-in day, otherwise 0.
• Step days: days the step goal was reached, 0 to 5 (more count as 5).
• Weekly points: ready-made formula =F2+G2*20+H2*6.

Look up the weight points

The points calculator works out values in between exactly, for the whole group at once.

How to use it

Excel

Double-click to open and save it as an Excel workbook. Drag the formulas from row 2 down as you add rows.

Google Sheets

Create a new spreadsheet, then File, Import, Upload. Afterwards you can share the sheet with your group.

Numbers and LibreOffice

Open the file and choose comma as the separator if asked.

Spreadsheet tips

• Overall ranking: sum the weekly points per person, for example with a pivot table, and sort descending.
• Most consistent of the week: in each week, the row with the most weekly points.
• If one person maintains the sheet, they see every weight. If that is a problem, everyone works out their own change and only reports percent and points.

Where a spreadsheet hits its limits

Collect numbers every week, look up points, sort, post a screenshot to the group: it takes time, and by week 4 someone is missing. Lossboard does it automatically, with weigh-in reminders, steps from Apple Health or Health Connect, most consistent of the week, a buddy and badges. The direct comparison is in spreadsheet or app.