Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
excel
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Spreadsheet Formulas for an Australian GST/BAS Quarter Tracker
Aussie Money Templates
Aussie Money Templates
Aussie Money Templates
Follow
Nov 20
Spreadsheet Formulas for an Australian GST/BAS Quarter Tracker
#
spreadsheet
#
excel
#
productivity
#
beginners
Comments
Add Comment
5 min read
Moderation
Stochastic 3-Point PERT: Beta Distribution, CLT & P90 Project Buffers
Daniel
Daniel
Daniel
Follow
for
Datalaria
Nov 20
Stochastic 3-Point PERT: Beta Distribution, CLT & P90 Project Buffers
#
projectmanagement
#
pert
#
operations
#
excel
Comments
Add Comment
17 min read
Moderation
Where Part 3 Submittals Hide in MEP Specs and 4 Procore Excel Import Traps
RickZhang
RickZhang
RickZhang
Follow
Nov 20
Where Part 3 Submittals Hide in MEP Specs and 4 Procore Excel Import Traps
#
construction
#
excel
#
automation
#
engineering
Comments
Add Comment
5 min read
Moderation
Why Excel Turns Your IDs into 9.01E+09 — and How to Import a CSV Without Losing Data
Thedaybreak0117
Thedaybreak0117
Thedaybreak0117
Follow
Nov 20
Why Excel Turns Your IDs into 9.01E+09 — and How to Import a CSV Without Losing Data
#
excel
#
csv
#
data
#
productivity
Comments
Add Comment
3 min read
Moderation
How I checked a rental-property spreadsheet before selling it: three bugs a clean test run missed
Mohammed Samaan
Mohammed Samaan
Mohammed Samaan
Follow
Nov 19
How I checked a rental-property spreadsheet before selling it: three bugs a clean test run missed
#
excel
#
testing
#
python
#
spreadsheet
Comments
Add Comment
2 min read
Moderation
Your revenue total is low because some of the numbers are text
Jack
Jack
Jack
Follow
Nov 19
Your revenue total is low because some of the numbers are text
#
python
#
pandas
#
excel
#
datascience
Comments
Add Comment
4 min read
Moderation
Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook
ActvKey Official
ActvKey Official
ActvKey Official
Follow
Nov 19
Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook
#
excel
#
performance
#
python
#
sysadmin
Comments
Add Comment
4 min read
Moderation
Consolidating Multi-Currency Stripe Settlement Reports: Beyond Brittle Excel Macros
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 19
Consolidating Multi-Currency Stripe Settlement Reports: Beyond Brittle Excel Macros
#
excel
#
stripe
#
datacleaning
#
accounting
Comments
Add Comment
3 min read
Moderation
How to Move Columns in Excel Without Dragging
Chloe
Chloe
Chloe
Follow
Nov 19
How to Move Columns in Excel Without Dragging
#
productivity
#
csharp
#
excel
#
tutorial
2
 reactions
Comments
Add Comment
10 min read
Moderation
Test the Business Asset Disposal Relief conditions in a spreadsheet
Key Ledgers Global
Key Ledgers Global
Key Ledgers Global
Follow
Nov 19
Test the Business Asset Disposal Relief conditions in a spreadsheet
#
tax
#
spreadsheets
#
excel
#
finance
Comments
Add Comment
12 min read
Moderation
Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys
Adan Potyondy
Adan Potyondy
Adan Potyondy
Follow
Nov 18
Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys
#
dataengineering
#
etl
#
dataquality
#
excel
Comments
Add Comment
4 min read
Moderation
Estimación PERT de 3 Puntos: Distribución Beta, CLT y Project Buffers P90
Daniel
Daniel
Daniel
Follow
for
Datalaria
Nov 19
Estimación PERT de 3 Puntos: Distribución Beta, CLT y Project Buffers P90
#
projectmanagement
#
pert
#
operations
#
excel
Comments
Add Comment
23 min read
Moderation
One semantic model, four tools: the same numbers and the same permissions
Sergei Semenkov
Sergei Semenkov
Sergei Semenkov
Follow
Nov 18
One semantic model, four tools: the same numbers and the same permissions
#
security
#
powerbi
#
excel
#
mcp
Comments
Add Comment
5 min read
Moderation
Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds
RickZhang
RickZhang
RickZhang
Follow
Nov 18
Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds
#
excel
#
manufacturing
#
supplychain
#
hardware
Comments
2
 comments
6 min read
Moderation
How to Ingest NetSuite Journal Entries into SQL Databases Cleanly
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 18
How to Ingest NetSuite Journal Entries into SQL Databases Cleanly
#
netsuite
#
sql
#
excel
#
dataengineering
Comments
Add Comment
3 min read
Moderation
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account