May 2020 Archive
Character-Perfect Fixed Width Import Files
- May 25, 2020
- 4 minutes
- automation, php, tech
One of my springtime projects at work was to button up a recently-refreshed process to transmit some billing data between systems. By 'recently-refreshed,' I mean 'finally made a process whereby a human doesn't have to manually generate a file which had been the de-facto process for the better part of twelve years. Due to the cascading effects of some staff turnover in the unit in question, IT was brought into the loop to help find a better way to work this process.
Read MoreShaking The GnuCash Account Tree
- May 18, 2020
- 5 minutes
- finance, inspiration, personal
Over the years I've developed a habit where a short part (~30 minutes on average) of most weekends are dedicated to entering the week's receipts, reconciling (or balancing) accounts, updating investment fund values, and so forth. Once familiar with GnuCash, this process is pretty straightforward and easy to do.
Read MoreSimple, Yet Powerful Excel/Sheets Functions
- May 11, 2020
- 3 minutes
- inspiration, tech
As a reflection exercise for a project I wrapped up a bit ago, combined as an exercise to make Future Me's life a Better Place, I pulled together a simple Google Sheets workbook to make a quick 'calculator' and balancing mechanism to help keep track of a couple datasets. And in so doing, I again befriended a couple of super simple, and super powerful functions:
Read MoreGnuCash For The Win
- May 04, 2020
- 6 minutes
- finance, inspiration, personal
As I wrote about a couple months back, GnuCash is my accounting software of choice since ~2010. I wasn't exactly "sold" on it from the start, but it was a free and open-source solution that seemed robust enough to handle pretty much anything I could throw at it, from managing business finances and whatnot to a whole mess of personal accounts.
Read MoreRecent Posts
Past Speaking Engagements
I was a speaker at MMS Flamingo Edition, October 20-23, 2024!
I was a speaker at TCSMUG OSD Day, July 31, 2024!
I was a speaker at NWSCUG, July 19, 2024!
I was a speaker at MMSMOA, May 5-9, 2024!
I was a speaker at BrainStorm K20 Wisconsin Dells, March 10-12, 2024!
I was a speaker at MMS Miami Beach, October 29-November 1, 2023
