DEV Community

#spreadsheets

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to Build a Monthly Budget Spreadsheet with Formulas

How to Build a Monthly Budget Spreadsheet with Formulas

Comments
5 min read
Flattening a 40-sheet workbook taught me that sheet order is a promise, not a layout

Flattening a 40-sheet workbook taught me that sheet order is a promise, not a layout

1
Comments
1 min read
How to Track Your Etsy Search Rank in a Spreadsheet

How to Track Your Etsy Search Rank in a Spreadsheet

Comments
6 min read
#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero

#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero

Comments
2 min read
ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

Comments
2 min read
How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

Comments
6 min read
How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

Comments
7 min read
VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Comments
2 min read
How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

Comments
7 min read
Invoice format in Excel: a simple layout with an optional tax % column

Invoice format in Excel: a simple layout with an optional tax % column

Comments
3 min read
Salary slip format in Excel: a printable payslip you fill from one register

Salary slip format in Excel: a printable payslip you fill from one register

Comments
3 min read
Order Tracking Spreadsheet for Online Sellers: Ship-By Dates, Late Orders and Profit per Order

Order Tracking Spreadsheet for Online Sellers: Ship-By Dates, Late Orders and Profit per Order

Comments
4 min read
A simple order and shipping tracker spreadsheet for small online sellers

A simple order and shipping tracker spreadsheet for small online sellers

Comments
2 min read
How to Build an Inventory Reorder Sheet for Resellers in Excel

How to Build an Inventory Reorder Sheet for Resellers in Excel

Comments
4 min read
A freelance income tracker spreadsheet: invoices, unpaid clients, and money set aside for tax

A freelance income tracker spreadsheet: invoices, unpaid clients, and money set aside for tax

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