David's Daily Bread
News and Scripture each morning. Practical tools each evening. Loved by God.
Start here tonight
worth an evening Trending workflowHow-To Geek front page, Sep 2

Build a six-column Excel subscription tracker that flags each renewal before the card is charged

The subscriptions that quietly renew themselves are the ones nobody has ever written down in one place.

How-To Geek's Tony Phillips starts the sheet with three columns, Service, Cost in Accounting format, and Last Paid as a date, then adds Category and Billing as data validation drop-downs so that cloud storage and cloud never get counted as two different things. Three formulas do the rest of the work: annual cost multiplies a monthly payment by 12 and a quarterly one by 4, EDATE projects the next renewal date from the billing frequency, and an IF statement compares that date to today and returns Check now inside three days, Upcoming inside seven, and OK otherwise, with a slicer to filter the whole table down to one category. Laid out that way the overlaps show themselves. Google One and Dropbox were duplicating storage already covered by Microsoft 365, worth $140 a year; YouTube Premium went for $200 and Adobe Acrobat Pro for $240; and renegotiated insurance and service providers returned more than $450, over $1,000 in a single year.

✎
The tool shelf new tonight

Every shelf item is available today; no waitlists, no vaporware.

✎
The workflows follow along at home
Mary of Nazareth

Keep and Ponder

The useful work is finished. Keep what is true, ponder what matters, and entrust the rest to God.

Keep

Casting all your care upon him; for he careth for you.
1 Peter 5:7, KJV

Ponder

Put one worry into words, then entrust it to God.

Entrust

Father, receive what troubles me and remind me that I am held in your care. Amen.

A practice shaped by Luke 2:19Guided by the biblical witness of Mary of Nazareth.
Page notes
✎