How do you count Connects spent on proposals that never win?

I made a manual Excel tracker for Upwork proposal costs, and I'm interested in how other freelancers keep their records useful.

One distinction matters: the cost of a winning proposal is not the total spent applying for work.

For a hypothetical completed set of 10 proposals, suppose each uses 14 purchased Connects, none are returned, and exactly one leads to a contract. At USD 0.15 per Connect, the set uses USD 21 in Connects, while the winning proposal alone uses USD 2.10. This is an illustration, not a typical win rate or earnings forecast. It excludes boosts, membership, other fees, taxes and time.

That's why my approach is to log every proposal, keep its status separate, and record earnings and withdrawals separately from contracts.

The tool is a USD 5 Excel workbook with a PDF quick-start guide. It tracks manual proposal records, fee inputs, earnings and withdrawals. Checked for the documented scenarios in Excel 2021 on Windows; other spreadsheet apps have not been validated. No Upwork connection, macros or earnings guarantee. Not affiliated with Upwork.

Product and previews: https://straightgate.gumroad.com/l/rztmxo?utm_source=producthunt&utm_medium=forum&utm_campaign=firstsale-proposal-log

Official Connects reference: https://support.upwork.com/hc/en-us/articles/211062898-Understanding-and-using-Connects

If you already use a spreadsheet, what is hardest to keep current: proposals with no reply, boosting actually charged, or the final outcome? I'd like to learn which part of that workflow needs the most help.