Cost Per Nut Spreadsheet Template (Copy-and-Paste Ready)

Open a new Google Sheet. Row 1 is headers: Date, Person, Spend, Time, Outcome. Row 2 onward is data.

Column A: ISO date, like 2026-05-16. Column B: name or initials. Column C: total dollars on this date, all-in. Column D: total hours, including travel. Column E: 1 if your defined outcome happened, 0 otherwise.

That's the whole template. No formatting required. No fancy formulas. The minimal structure is the point — anything more elaborate gets abandoned by week three.

Cell G1: =SUM(C2:C). This is your total spend.

Cell G2: =SUM(E2:E). This is your total outcomes.

Cell G3: =G1/G2. This is your CPN. Hide the rest of the sheet if you want — that one cell tells you most of what you need to know.

Highlight your data range. Insert → Pivot table. Rows: Person. Values: SUM of Spend, SUM of Outcome, and a calculated field for SUM(Spend)/SUM(Outcome).

What you'll see is per-girl CPN, ranked. The first time most guys run this pivot, they discover the person they thought was their favorite has the worst ROI in their portfolio. The data is unsentimental.

Re-run the pivot monthly. The shape of the distribution will change. The action items become obvious as the distribution evolves.

Logging only successful dates. Half the value of the sheet is in the zero rows. Skip them and your CPN looks fake.

Stopping after the first painful month. The first month's number is supposed to be painful. By month three, the actions you've taken in response will be visible in the trend.

Sharing the sheet. The sheet is for you. If you want to compare numbers with wingmen, do it verbally or use a private group-chat. The sheet leaving your laptop is a privacy disaster waiting to happen.

The spreadsheet phase usually lasts thirty to sixty days. After that, friction starts to win — you stop opening the file, the data gets stale, the pivot table is two months old. That's the moment to graduate to an app.

We built one for exactly this moment. Same minimal data model — five fields per date — but with friction removed. Start with a 3-day free trial. The trend line keeps moving even when the spreadsheet would have stalled.