note

A story about trying out the causes and solutions for when formula cells cannot be retrieved (become None) in openpyxl

Have you ever had trouble with Excel automation because you couldn't get the results of formulas? I also hit that wall during my first automation project and panicked. Let's look at the causes and ...
note

[New Chapter, Part 38] Cut your losses on the illusion that 'VBA is dead.' The 'VBA x Python Ultimate Hybrid Architecture' to maximize net profit.

'The future is Python, not VBA.' If you are being swayed by such shallow dualism (a bug), cut your losses on that way of thinking right now. There is no superiority or inferiority in languages. There ...
GitHub

Data analytics portfolio project demonstrating data cleaning, exploratory data analysis, visualization, and business intelligence using Python, Pandas, Matplotlib, and Seaborn.

This project analyzes retail sales performance using the Sample Superstore dataset. The objective is to explore business performance, identify sales and profitability trends, evaluate regional ...
GitHub

Automated Pre-Processing Validation for U.S. Multi-State Payroll Operations

In companies with field-based workforces, payroll processing follows a flow that no single software fully covers: Field Supervisors → Timecards (external system) → Export CSV → [GAP] → Import to ...