William Smith

Excel VBA integration for VS Code - Tree View / Full Direct VBA Read+Write / LiveShare Compatible / Direct Agentic AI Integrations

Pure-Python reader/writer for VBA macros embedded in Excel / PowerPoint / Word files. Zero dependencies, deterministic round-trip, safe on protected and signed projects.

A Python library for reading, editing, and writing back VBA macros in Excel files without needing Excel installed, enabling version control and scripted automation of Excel macro code.

Turn JSON (and CSV / XML) text into clean Excel tables with one VBA module. Pick the part of the JSON you want, and it creates or updates a table for you. Keeps columns in a stable order and prevents accidental layout changes. No add-ins or extra libraries required. Just paste into Excel and run. Supports deep object and array nesting.

MudProto is a ground-up implementation of a Multi-User Dungeon (MUD) Framework developed in Python.

Extract and ships VBA / Office COM reference data in tool-friendly formats.

AI-powered Excel editor. Chat naturally with .xlsx/.xlsm files (including VBA generation + dynamic arrays). Safe previews, automatic backups, and a single portable .exe.

This repository demonstrates the real power of the ModernJsonInVBA VBA library through a practical Excel + VBA case study. It shows how to quickly turn a public JSON API into a clean, interactive product dashboard with minimal vba code complexity.

A simple, lightweight way to work with JSON as dynamic objects or lists, while still giving you type safety when you need it.

SQLServerInteraction is a C# library that wraps the functionality included in Microsoft's "Microsoft.Data.SqlClient" library.

Transformer is a C# library that helps you better interact with and transform data from one type into another.

VB.Net code for interfacing with Avaya's CMS Supervisor call center management software.

A self-hostable, in-memory multidimensional OLAP server with a clean REST API and a React + TypeScript web UI built in rust.

No description.

No description.

An MCP server that lets AI agents talk to SSH servers, with safety guardrails.

Local Scripture research workspace centered on learning more about Jesus Christ and seeking truth carefully.

Arcane EDR is a lightweight Windows service for making unattended agent workstations safer while still allowing fast, bleeding-edge work.

AndromedaTM1Sharp is a .Net API interface for IBM's TM1 and Planning Analytics with Watson OData v4 REST APIs.

AI-powered Weekly Macro Market Brief • Python + NewsAPI + OpenAI (structured JSON) • Auto-generates professional HTML & PDF reports with DJIA/S&P 500 bias, sentiment scores & positioning guidance. Live on GitHub Pages.

No description.

A light-weight wrapper utility library for alerting with the SIGNL4 platform

Example of "lazy loading" data into a static object from a database.

SharpAutomation is a C# library that helps you build smarter automation and workflows.

Create advanced Excel spreadsheets using .NET

This project is a python library that can be used to query against OpenDataSoft's US city demographics API.

Exceleration is a C# library that wraps ExcelDataReader. It helps you better interact with Excel files by simplifying the development experience.

Big Brain Blitz is a re-imagination of my daughter's favorite boardgame "MASTERMIND." This game runs in the browser using bootstrap UI and Javascript/JQuery.

The primary goal of this repository is to document the process of engaging with an established Flask tutorial series, emphasizing the systematic exploration of the provided code examples.

Prototype created from a mentoring session focusing on error handling, generic collections, delegates and lambda expressions. Demonstrates how logic can be passed into a delegate parameter, and used to trap error conditions over an iteration in order to "fail gracefully."

Excel DNA add-in for interacting with SQLServer.

The purpose of this project is to model the real world hive-mind logic of ants as they search for food sources.

Support library that interfaces with the JSON endpoints included in the Chrome for Testing project.

Solution to a Code Wars 4 Kyu-Kata challenge. The objective is when given two strings s1 and s2, we want to visualize how different the two strings are. We will only take into account the lowercase letters (a to z).

As a solution to an EdaBit expert level challenge, this program is designed to model allergy profile for patients using object oriented design patterns.

As a solution to an EdaBit expert level challenge, this program is designed to translate English words and sentences into Pig Latin.

As a solution to an EdaBit expert level challenge, this program is designed to determine if a number or its descendants (formed by summing pairs of adjacent digits) are palindromic.

This mentoring example demonstrates functional programming patterns by accepting a user's first and last name via console, and then output their full name in a user specified format.

As a solution to a CodeWars programming challenge, the purpose of this program is to sum two potentially very large numbers represented as strings.

Mentoring example used to demonstrate the fundamentals of recursion and application to real world scenarios.

The purpose of this project is to demonstrate programming principles and syntax in Python for someone who is generally familiar with programming in another language.

Mentoring example, used to demonstrate scraping of data log entries on a list of jobs from a data source, then using extension methods to transform and output the data.

Mentoring example, used to demonstrate dependency injection and IoC design pattern concepts.

Mentoring demonstration application modeling the real-world logic of a television interfacing with audio/visual devices, focusing on object oriented design patterns.

Python + RaspberryPI + GPIO testing.