DEV Community

#spreadsheets

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to Build a Debt Payoff Calculator in Excel or Google Sheets (NPER, FV and PMT, Tested)

How to Build a Debt Payoff Calculator in Excel or Google Sheets (NPER, FV and PMT, Tested)

Comments
7 min read
How to Set Up Payment Due Date Reminders in a Spreadsheet

How to Set Up Payment Due Date Reminders in a Spreadsheet

Comments
4 min read
How to Add an Order Status Dropdown That Colours Itself

How to Add an Order Status Dropdown That Colours Itself

Comments
4 min read
How to See Your Best and Repeat Customers in a Spreadsheet

How to See Your Best and Repeat Customers in a Spreadsheet

Comments
4 min read
How to Clean Amounts Pasted from a Bank or Payment Export

How to Clean Amounts Pasted from a Bank or Payment Export

Comments
3 min read
How to Track Sales in USD, GBP and EUR in One Spreadsheet

How to Track Sales in USD, GBP and EUR in One Spreadsheet

Comments
4 min read
The RBI Reference Rate in Python and Google Sheets, From One URL (No API Key)

The RBI Reference Rate in Python and Google Sheets, From One URL (No API Key)

Comments
2 min read
How to Build an Accounts Receivable Aging Report in Excel or Google Sheets

How to Build an Accounts Receivable Aging Report in Excel or Google Sheets

1
Comments
2 min read
My spreadsheet-to-Markdown API taught me that 'the table' is a social construct — cells have opinions

My spreadsheet-to-Markdown API taught me that 'the table' is a social construct — cells have opinions

Comments
2 min read
When Is an Invoice Overdue? A Spreadsheet Setup That Tells You, and What to Send

When Is an Invoice Overdue? A Spreadsheet Setup That Tells You, and What to Send

Comments
3 min read
Spreadsheet or Invoicing App? An Honest Checklist for Freelancers

Spreadsheet or Invoicing App? An Honest Checklist for Freelancers

Comments
2 min read
How to Sort Unpaid Invoices into Overdue Groups in a Spreadsheet

How to Sort Unpaid Invoices into Overdue Groups in a Spreadsheet

Comments
4 min read
I built a free bookkeeping spreadsheet for freelancers (no macros, 17 tabs)

I built a free bookkeeping spreadsheet for freelancers (no macros, 17 tabs)

Comments
1 min read
Job Management App vs Spreadsheet for Small Tradies

Job Management App vs Spreadsheet for Small Tradies

Comments
1 min read
My XLSX converter taught me that a merged cell isn't a cell — it's a lie Excel tells

My XLSX converter taught me that a merged cell isn't a cell — it's a lie Excel tells

Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.