DEV Community

#excel

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Spreadsheet Formulas for an Australian GST/BAS Quarter Tracker

Spreadsheet Formulas for an Australian GST/BAS Quarter Tracker

Comments
5 min read
Stochastic 3-Point PERT: Beta Distribution, CLT & P90 Project Buffers

Stochastic 3-Point PERT: Beta Distribution, CLT & P90 Project Buffers

Comments
17 min read
Where Part 3 Submittals Hide in MEP Specs and 4 Procore Excel Import Traps

Where Part 3 Submittals Hide in MEP Specs and 4 Procore Excel Import Traps

Comments
5 min read
Why Excel Turns Your IDs into 9.01E+09 — and How to Import a CSV Without Losing Data

Why Excel Turns Your IDs into 9.01E+09 — and How to Import a CSV Without Losing Data

Comments
3 min read
How I checked a rental-property spreadsheet before selling it: three bugs a clean test run missed

How I checked a rental-property spreadsheet before selling it: three bugs a clean test run missed

Comments
2 min read
Your revenue total is low because some of the numbers are text

Your revenue total is low because some of the numbers are text

Comments
4 min read
Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook

Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook

Comments
4 min read
Consolidating Multi-Currency Stripe Settlement Reports: Beyond Brittle Excel Macros

Consolidating Multi-Currency Stripe Settlement Reports: Beyond Brittle Excel Macros

Comments
3 min read
How to Move Columns in Excel Without Dragging

How to Move Columns in Excel Without Dragging

2
Comments
10 min read
Test the Business Asset Disposal Relief conditions in a spreadsheet

Test the Business Asset Disposal Relief conditions in a spreadsheet

Comments
12 min read
Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys

Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys

Comments
4 min read
Estimación PERT de 3 Puntos: Distribución Beta, CLT y Project Buffers P90

Estimación PERT de 3 Puntos: Distribución Beta, CLT y Project Buffers P90

Comments
23 min read
One semantic model, four tools: the same numbers and the same permissions

One semantic model, four tools: the same numbers and the same permissions

Comments
5 min read
Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds

Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds

Comments 2
6 min read
How to Ingest NetSuite Journal Entries into SQL Databases Cleanly

How to Ingest NetSuite Journal Entries into SQL Databases Cleanly

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