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.

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 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

--------------------------------------------
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

--------------------------------------------
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 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

#--------------------------------------------
# R affinity / market-basket analysis
#--------------------------------------------
# if someone picks X, how likely would they
# be to pick Y or YZ. Or, if they picked XY
# together, how likely they'd pick Z. Etc.
#
# This serves two fold purpose..
# 1) we can make a recommender system.. based on
#    things they picked together, or picked one and

ccritchfield

----------------------------------------------
Windows Command-line MS Access DB Compact Automation
----------------------------------------------

DOS / Windows Command-line script that compacts MS Access databases.
Checks if db is open (.ldb file exists) and skips compacting that db
if it does. Can task schedule to run after-hours for maintenance.

Purpose ...

ccritchfield

----------------------------------------------
Windows Command-line Folder Copy Automation
----------------------------------------------

DOS / Windows Commandline script to automate folder copies / backups.
Can task schedule to do folder archiving after-hours.

IT would have a nightly backup of things, but created some backup
scripts to copy whole project folders into backups. This let me
quickly restore something if I was working on things or someone

ccritchfield

--------------------------------------------
Windows Command-line Zip Automation 
--------------------------------------------

VBS / VBScript / WScript that uses FBZip.exe to automate zipping
up folders and archiving them into a folder. Runs from DOS commandline,
and can task schedule to fire off and run after-hours for archiving /
back-ups.

Uses FBZip, b/c it's a small free zip program that has easy-to-use