DEV Community

#spreadsheet

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Build a Product Master Sheet Before a Thai Distributor Asks: Barcodes, Case Codes and Check Digits for 7-Eleven

Build a Product Master Sheet Before a Thai Distributor Asks: Barcodes, Case Codes and Check Digits for 7-Eleven

Comments
4 min read
How to Build a Timesheet in Google Sheets That Handles Overnight Shifts and Overtime

How to Build a Timesheet in Google Sheets That Handles Overnight Shifts and Overtime

Comments
3 min read
每周 15 分钟:三张表维护清单,月初记的账月底不用返工

每周 15 分钟:三张表维护清单,月初记的账月底不用返工

Comments
1 min read
The 8 Excel errors, explained: what #N/A, #VALUE! and #REF! actually mean

The 8 Excel errors, explained: what #N/A, #VALUE! and #REF! actually mean

Comments 1
3 min read
How does Goal Seek find a break-even point?

How does Goal Seek find a break-even point?

Comments
6 min read
How to find your break-even point with Goal Seek in a spreadsheet

How to find your break-even point with Goal Seek in a spreadsheet

Comments
3 min read
How to forecast next December's sales in a spreadsheet

How to forecast next December's sales in a spreadsheet

Comments
4 min read
How to remove duplicate customers from a spreadsheet by email address

How to remove duplicate customers from a spreadsheet by email address

Comments
3 min read
How to Clean a Messy Stripe / Shopify / Gumroad CSV Before Google Sheets (or Make)

How to Clean a Messy Stripe / Shopify / Gumroad CSV Before Google Sheets (or Make)

Comments
4 min read
Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)

Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)

Comments
2 min read
Track online orders and shipments in Excel: ship-by dates, status and profit per order

Track online orders and shipments in Excel: ship-by dates, status and profit per order

Comments
3 min read
Google Sheets vs a Real Dashboard: When It Is Time to Graduate

Google Sheets vs a Real Dashboard: When It Is Time to Graduate

Comments
3 min read
How to Build a Purchase Order in Google Sheets With the Discount, Tax and Shipping in the Right Order

How to Build a Purchase Order in Google Sheets With the Discount, Tax and Shipping in the Right Order

Comments
3 min read
The Status Column Trap: Why Your Tracker Has 12 Statuses and Nobody Updates It

The Status Column Trap: Why Your Tracker Has 12 Statuses and Nobody Updates It

1
Comments
4 min read
One Sheet vs Linked Sheets: When to Break Up a Solo-Operator Template

One Sheet vs Linked Sheets: When to Break Up a Solo-Operator Template

Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.