Download the decathlon points calculator for Excel
The template has a Men sheet and a Women sheet, each with the ten events in order, the official A, B and C constants and a formula in every points cell. Type a mark in column B and the points, Day 1 and Day 2 subtotals and total fill in by themselves. It opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice.
⬇ Download decathlon-points-calculator.xlsx
The live sheet beside this text works the same way. Click any points cell to see its formula in the formula bar, export your own marks as a CSV that Excel opens with the formulas intact, or copy the whole sheet and paste it into cell A1 of Google Sheets.
The Excel formulas, explained
Each event uses one of three formulas, depending on whether it's a race, a jump or a throw. In every case B is the mark, D, E and F are the A, B and C constants, and ROUNDDOWN cuts the result to a whole number, the way official results do.
| Event type | Excel formula (row 2) |
|---|---|
| Running events | =IF(B2="","",IF(B2>=E2,0,ROUNDDOWN(D2*(E2-B2)^F2+1E-9,0))) |
| Jumps and pole vault | =IF(B3="","",IF(ROUND(B3*100,0)<=E3,0,ROUNDDOWN(D3*(ROUND(B3*100,0)-E3)^F3+1E-9,0))) |
| Throws | =IF(B4="","",IF(B4<=E4,0,ROUNDDOWN(D4*(B4-E4)^F4+1E-9,0))) |
| Total | =SUM(G2:G11) |
The ROUND(B3*100,0) part turns a jump in metres into centimetres, because the jump constants were set in centimetres. The tiny +1E-9 stops floating-point error from knocking a score that lands exactly on a whole number down by one point.
How to build your own decathlon scoring spreadsheet
- Put the events in column A in competition order, and leave column B for marks.
- Copy the A, B and C constants for each event into columns D, E and F. The full men's and women's constants are on the decathlon calculator page.
- Paste the right formula from the table above into column G for each event, changing the row numbers.
- Add
=SUM(G2:G6)for Day 1,=SUM(G7:G11)for Day 2 and=SUM(G2:G11)for the total.
Common Excel mistakes
- Using ROUND instead of ROUNDDOWN. Official scores are always rounded down. ROUND will sometimes give you one point too many per event.
- Leaving jumps in metres. Without the ×100, jump scores come out as nonsense while the throws look fine.
- Typing the 1500m as a time. Excel stores 4:36.11 as a fraction of a day. Enter the 1500m in seconds (276.11), or as
=4*60+36.11. If you already have a time cell, multiply it by 86400 to get seconds. - Forgetting hand times. Add 0.24 seconds to a hand-timed 100m or 110m hurdles and 0.14 seconds to a 400m, after rounding up to the tenth, before you type it in.
FAQs
Is there a decathlon points calculator for Excel?
Yes. Download the free template on this page. It has men's and women's sheets with the official constants and a formula in every points cell, so totals update as you type.
Does the decathlon spreadsheet work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or use Copy for Google Sheets on this page and paste into cell A1 of a new sheet.
How do I enter the 1500m in Excel?
Enter it in seconds, such as 276.11 for 4:36.11, or type =4*60+36.11. Excel stores times like 4:36.11 as a fraction of a day, which breaks the formula unless you multiply by 86400.
Why does the Excel formula use ROUNDDOWN?
Official decathlon scoring cuts every event score down to a whole number before adding them. ROUNDDOWN matches that. ROUND would sometimes add a point.
Does the Excel template include the women's decathlon?
Yes. The second sheet uses the women's event order and constants.