General Business Automation

  • All
  • Articles
  • Blog Post
  • General Business Automation
  • Portfolio
  • Stock Market & Finance

January 19, 2026

As part of a larger NLP project focused on analyzing shareholder communications, I needed a clean, consistent corpus of historical letters to shareholders. One obvious and valuable dataset is the collection of Chairman’s Letters from Berkshire Hathaway, which spans nearly five decades. While the letters are publicly available on Berkshire’s website, assembling them into a single, NLP-ready dataset isn’t quite as simple as it sounds. Here’s a link...

January 7, 2026

One of the most effective uses of large language models (LLMs) is helping people get up to speed on unfamiliar code. Excel models don’t get that benefit. As spreadsheets grow, logic becomes harder to reason about: If you didn’t build the model — or if enough time has passed — understanding how it works can be surprisingly slow. A simple shift in approach Instead of asking an LLM...

December 29, 2025

Introduction This Small Business Finance Template Suite was built for owners who want visibility into their business without adopting complex software or changing how they already work. The goal is simple: clear structure, realistic data flow, and decision support. Not automation for its own sake. Each template works on its own, but together they form a lightweight system for managing clients, revenue, commissions, and cash flow using Google...

December 29, 2025

Lines of credit and bridge loans rarely follow clean schedules. They often involve: Because of this, traditional amortization calculators often fall short. They require assumptions that don’t reflect what actually happens over time. This Line Of Credit template is designed for tracking, not forecasting. What This Template Does The template functions as a transaction level ledger for a revolving line of credit. You enter: From there, the template...

December 10, 2025

Most Microsoft Access databases hide years of business logic inside saved queries and VBA modules. When you’re ready to modernize—whether that’s moving processes into Power BI Dataflows, SQL Server, Fabric, or a Python-based pipeline—the first problem is usually: “How do I extract all of this logic from Access without opening every query manually?” To make that easier, I worked with ChatGPT to build a lightweight VBA utility that:...

September 30, 2025

Blackjack is one of the most widely studied games in both casinos and academia. The rules are simple, but the strategy is subtle, and the possibility of card counting has made it a fascinating testbed for probability, game theory, and decision-making. The question at the heart of this project: can a machine, using reinforcement learning (RL), teach itself how to play blackjack — and even rediscover professional strategies...

July 6, 2025

Can AI really beat the house in a game mathematically designed for the casino to win? Over the course of 100,000 simulated bets, I set out to test that question — by building and training reinforcement learning agents to outplay American-style roulette. This is the launchpad for a 5-part blog series where I explore the math, psychology, and algorithms behind roulette strategies — from classic betting systems to...

June 24, 2025

Why I Did This I’ve been experimenting with automation and AI for a while, and I wanted to see if I could create a fully autonomous blog publishing system — one that generates content, adds SEO metadata, creates visuals, and publishes to WordPress without me lifting a finger. This post documents a real test: 11 blog posts, created and published in one day, entirely by a Python-based AI...

May 7, 2025

Ever wanted your Python scripts to run automatically — every hour, every morning, or after reboot? You don’t need to keep your terminal open or build a full app for that. Windows Task Scheduler can handle it for you — and you can even run your scripts silently in the background. In this post, we’ll cover: Step 1: Yes, You Can Schedule Python Scripts! Windows Task Scheduler is...

March 20, 2025

I recently came across a forum post where someone asked about creating a scheduling system using Google Sheets. As I thought about it, I realized that while scheduling is important, why stop there? A complete system should also handle time-off requests, payroll calculations, and paystub distribution—all while keeping things simple and automated. That idea led to this restaurant workforce automation system, which uses Google Sheets and Google Apps...

Prev
123