ccritchfield

--------------------------------------------
Python Object-Oriented Programming Walk-Thru
--------------------------------------------

.py files that demonstrate Object-Oriented programming
in Python in step-by-step fashion.

Python class in college was mix of undergrads and grads,
because Python was turned into the Intro to Programming
class for undergrads (due to push towards data sci), but

ccritchfield

--------------------------------------------
Python User-Defined-Function (UDF) Walk-Thru
--------------------------------------------

.py files that test out making (and breaking) functions in Python.

Python class in college was taught in "sink or swim" fashion,
so I took it upon myself to be an unofficial TA for the class.
Prof would blow through code, then I'd head home to hammer out
samples for the class, find issues, resolve them, and explain

ccritchfield

--------------------------------------------
Python Code Timer
--------------------------------------------

Quick-n-dirty Python code timer. Add a line of code
before and after the code you want to time to kick
off a timer then return it when done processing.
Can have multiple timers going to test speed / 
bottlenecks of various parts of code.

ccritchfield

----------------------------------
VBA Excel Spreadsheet to Array (and back)
----------------------------------

Func's to push a spreadsheet into a VBA array for processing,
then dump an array back to a spreadsheet.

Purpose ...

Had a coding interview challenge where I needed to take a year's

ccritchfield

----------------------------------
VBA Holiday Creation & Determination
----------------------------------

Various Holiday Func's that determine what date a holiday
is on based on the year you pass them. EG: Pass the Memorial
Day function the year 2025, and it will figure out when Memorial
Day is in 2025.

HolidayCheck func leverages these "when's the holiday date?"

ccritchfield

----------------------------------
VBA Process Timer Utility
----------------------------------
wrote this years back when I was doing a lot of vba work.
basically creates a process timer stack to add / pop timers
from, making it easy to add timers to code and track multiple
ones to see how multiple parts of a process are running.
.. test for speed, see where bottleneck is, etc.
You can also make it return the time as a string,
so you can use it to quickly create log files of code runs.