Tag Archives: artificial-intelligence

Top 10 Excel VBA Patterns Explained

Posted on January 24, 2026 by chanmingman

1) Boilerplate: Speed & Safe Cleanup What it does: Temporarily turns off slow UI features (screen updates, auto calculation, event firing) to speed up your macro, then restores them even if an error happens. Why it’s useful: Big performance gains … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, Microsoft Office, Office 365, programming | Tagged , , , , , | Leave a comment

The Strategy Pattern in Python

Posted on January 18, 2026 by chanmingman

Explaining Bubble Sort, Quick Sort, and Merge Sort with the Strategy design pattern, complete with code, trade-offs, and a runnable demo. ─────────────────────────────────────────────────────────── TL;DR – What: Strategy pattern decouples what you do (sorting) from how you do it (bubble/quick/merge). – Why: … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, programming | Tagged , , , , , | Leave a comment

Inserting Nodes After a Given Value in a Singly Linked List C++

Posted on January 11, 2026 by chanmingman

If you’re working with singly linked lists, the ability to insert a new node after a node containing a specific value is both common and crucial. In this post, we’ll dive deep into the bool insertAfter(int afterValue, int newValue) method—its … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, programming | Tagged , , , , | Leave a comment

Building a Clean, Testable Python Calculator

Posted on January 4, 2026 by chanmingman

Introduction When you’re teaching (or refreshing) foundational Python, few examples are more approachable than a calculator. But beyond simple arithmetic, a great learning artifact demonstrates clean design, defensive programming, and unit testing. In this post, we’ll explore a minimal yet … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, programming | Tagged , , , , , , | 1 Comment

Sorting Smarter: A Gentle Walkthrough of the Strategy Pattern (with C# Code)

Posted on December 11, 2025 by chanmingman

If you’ve ever found yourself hard‑coding ‘how’ a task should be done—only to realize you’ll need three other ways tomorrow—the Strategy pattern is your friend. It helps you encapsulate interchangeable behaviors, so you can pick the best one at runtime … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming | Tagged , , , , , | 1 Comment

Understanding the Prototype Design Pattern in C++

Posted on November 30, 2025 by chanmingman

What is the Prototype Pattern? The Prototype Pattern is a creational design pattern that enables object duplication through cloning rather than instantiation. Instead of calling constructors repeatedly, you create a prototype object and copy it whenever needed. This approach is … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, programming | Tagged , , , , , | 1 Comment

Getting Started with the Google Gemini API: A Python Developer’s Guide

Posted on November 28, 2025 by chanmingman

Have you been curious about integrating powerful large language models (LLMs) into your Python applications? Google’s Gemini API offers a straightforward way to access state-of-the-art AI capabilities. In this blog post, we’ll walk through a practical Python script that demonstrates … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, data science, programming | Tagged , , , , , | 1 Comment

Automating Excel Data Updates with VBA: A Practical Example

Posted on November 23, 2025 by chanmingman

When working with large datasets in Excel, repetitive tasks like cleaning text and updating marks can be time-consuming. Fortunately, VBA (Visual Basic for Applications) allows us to automate these processes efficiently. In this post, we’ll break down a practical VBA … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, programming | Tagged , , , , , | Leave a comment

Enhancing Semantic Search with SPECTER2 and ChromaDB

Posted on November 11, 2025 by chanmingman

In the world of natural language processing (NLP), semantic search has become a cornerstone for building intelligent applications that understand meaning beyond keywords. One powerful way to achieve this is by combining SPECTER2, a transformer-based model designed for scientific document … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming | Tagged , , , , , | Leave a comment

Classification Using Python

Posted on October 11, 2025 by chanmingman

This blog article explores a machine learning pipeline implemented using Python’s scikit-learn library. The pipeline includes preprocessing steps for both numerical and categorical data, followed by model training and evaluation using cross-validation techniques. Data Preparation The dataset consists of features … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming | Tagged , , , , , | 1 Comment