I used to just have vitamins on a shelf and now it's turned into a price-tracking spreadsheet

Your spreadsheet sounds very relatable. The column that changed things for me was “cost per actually taken serving,” not cost per bottle.

I logged each morning whether I used an item, then divided my weekly supplement spend by that number. It was humbling: one powder worked out to about $4.60 per real use because I skipped it so often.

I also marked reorder status after a bottle emptied—if I did not replace it within two weeks, it got cut. July was my cheapest month for the same reason. Do you track usage versus purchase in your sheet, or just spending? I would be curious whether all 7 products are truly earning their shelf space.

Gummies are candy with a markup, respect the spreadsheet grind though.

Been there. My leak wasn't gummies, it was auto-ship. Forgot to pause one month and got double. I added columns for cost per actual dose and expiration date. Big difference. On night shifts I skip days, so per-serving price lies.

My May was ugly for the same panic reason: two tubs of protein powder I didn't need because I saw "low stock." Now I check the closet before ordering. Also count shipping and tax. That $2.10 average can jump fast.

Question: are you tracking what you toss? That number made me cut from 7 products to 4.

Expired stuff is the real worst value.

At maintenance, my spreadsheet rule is simple: no more than one sealed backup of anything, and only two “experiment” items per quarter. If an experiment isn’t finished by the end of the quarter, that category gets frozen until I use it up.

The hidden cost for me wasn’t gummies or subscriptions; it was stuff that expired or got gifted because I bought it for a version of myself I wasn’t actually living. Adding a “tossed/gifted?” column was humbling. Does your sheet track that, or just purchases?

The column I’d add is “actually finished.” I had one bottle that looked fine per serving, then it got shoved behind the granola bars and I used it maybe 9 days. My July was cheap because I did a pantry no-buy and made snack-drawer bags on Sunday.

May was rough for the same out-of-stock panic, except mine was two kids home sick and me grabbing whatever was closest. Are you tracking finished vs. purchased, or just what left the shelf?

I tried a tea spreadsheet once; it lasted one grocery run. Respct for six months of vitamin math.

I feel this. I added a “travel tax” column: aisle-seat pharmacy water, overpriced single-serve packets, and the graveyard of vitamins that rolled under hotel beds. My July was also low because I was home; May was airport kiosk panic.

The spreadsheet got more useful when I started logging cost per trip instead of per month — three days in Vegas can wreck a tidy average. Question: do you count the ones you abandon in a hotel minibar fridge? I’ve donated a small fortune to lost-and-found electrolyte tabs.

The gummy row is always the villain in my budget spreadsheet too 😅

Your spreadsheet is basically a trend line for your habits. I added a “would I rebuy?” column instead of only tracking spend.

Anything without a yes after one full bottle gets purged. My last purge freed about $22/month and I genuinely didn’t notice.

The noise is the one-off panic buys; the signal is what keeps earning a spot.

Do you have kill criteria for products, or do they just linger until the bottle is gone?

The auto-ship pause button is my mortal enemy—my spreadsheet would need a therapy colun 😂

Now that I’m maintaining, the metric that finally helped me was finish rate, not cost per serving. I Sharpie the open date on every bottle and only repurchase if I actually emptied it.

My real leak wasn’t gummies; it was “backup” bottles bought during panic sales, then never opened. I also keep a tiny do-not-rebuy list. Does your sheet have a column for whether you’d buy it again? That split my 8 products into 3 staples and 5 experiments, and my monthly average dropped without chasing coupons.

The out-of-stock panic is what gets me too. I run a cafe, so my version is a “waste” column: day-old muffins I eat instead of sell.

What helped was adding a “trigger” column to my own spreadsheet — sale, stress, bad shift — and my priciest month wasn’t supply, it was just a rough week. Do you track why you bought each thing, or only what it cost?

Also, did July’s $41 feel like a win, or just a month you forgot to reorder?

My spreadsheet lives in airport Wi-Fi now and still judges my gummy phse 😅

The missing column is inventory runway. Purchase spend is just cash timing; actual consumption is the cost.

I log unopened units + avg servings/week, then flag when runway < 21 days. That killed my panic buys: I can see I have 63 days of something before the “out of stock” anxiety hits.

Do you track cost per purchase or cost per serving consumed? Those two trends tell different stories.

Tbh i’m week one and my note app is still innocent... for now 😅

Respect. My spreadsheet died when I realized the gummy row was basically my snack budget 😅

Your July versus May split is interesting. I started tagging each purchase as planned or reactive, then reviewing a four-week rolling average every Sunday.

That kept me from over-correcting after a stock scare. One concrete thing that helped: I set a 72-hour pause on anything I want to buy because of a low-stock alert.

If I still want it after that, I add it, but most of the urgency fades. Do you track planned versus panic buys separately?

It might explain May without making the

I added a “why did I buy this?” column after realizing my worst spending months weren’t about price — they were restock anxiety. Now I track cost per day of actual use, not per serving, because an abandoned cheap tub costs more than the pricier one I finish.

In the trials I’ve read, adherence is the boring variable that decides value. I also use a two-week rule: if a new product sits untouched, it goes on the cut/donate list.

Do you split your seven into “core” vs “experimental”? That’s when my spreadsheet

Mine turned into a stock tracker and I still refreh it like a package 😅