DE Start a challenge

Free weight loss challenge spreadsheet template

A spreadsheet for up to 12 people and 8 weigh-ins, with a ready-made formula for percentage change. Download it, open it in Excel, Google Sheets or Numbers and get going.

Weight loss challenge template (CSV, 1 KB)

For Excel, Google Sheets, Numbers and LibreOffice. Comma separated, decimal point.

Download template

What is in the template

  • Name and starting weight for up to 12 people.
  • 8 columns for weigh-ins, week 1 to week 8.
  • Current: the weight from the latest weigh-in.
  • Change in %: ready-made formula =(B2-K2)/B2*100, already filled in for the example rows.

How to use it

Excel

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

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

  • Leaderboard: sort descending by the Change column.
  • Weekly winner: for each week, work out the difference to the previous week as a percentage of the starting weight.
  • If one person maintains the sheet, they see every weight. If that is a problem, enter percentages only.

Where a spreadsheet hits its limits

Collect weights every week, type them in, 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, weekly winners, duels and badges. The direct comparison is in spreadsheet or app.

FAQ

Frequently asked questions

Is the template free?

Yes, with no sign-up and no email address. Just download it.

Does it work with Google Sheets?

Yes. Open it in Google Sheets with File, Import, Upload.

How does the spreadsheet calculate the percentage?

With (starting weight minus current weight) divided by starting weight times 100, that is =(B2-K2)/B2*100.

Why a CSV file?

Every spreadsheet app opens CSV, with no macros and no extra software. Save it in your app’s own format afterwards.

Is there a German version?

Yes, on the German page, with semicolons and decimal commas for German Excel.

Keep reading

Spreadsheet or app?Spreadsheet or Lossboard: effort, privacy and fun compared.Percentage calculatorA leaderboard for the whole group by percentage, right in your browser.Rules and ideasBasic rules, winners by percentage, weekly winners, duels and theme weeks.

Create a challenge, drop the link in your group chat and start the race for first place.

No account needed. Free for up to 3 people, participants never pay.

Start in your browser