HOMEPAGE

Hey everyone,

I’ve just uploaded a new tutorial showing how to use my Paperwork Organiser macro. This one is designed to sort and back up everything that comes through during the dailies process.

It’s mainly built for lab delivered editorial packages, where ALEs, sound, H264s and department paperwork arrive inside structured folders. Instead of manually creating folders across multiple backup locations and copying everything yourself, the macro reads the folder names, matches them to keywords, and sends the contents to the right destinations in just a couple of clicks.

In the video, I explain why the macro reads folders rather than individual files, and how that makes it easier to use across different shows with different naming conventions. I also show how the macro can adapt to however you name your block subfolders, whether that’s “B1”, “Block 1”, or something else entirely, and what happens if a subfolder can’t be found.

I also cover some optional features, including automatically creating empty folders across all your backup locations so you only have to type the folder name once, adding extra blocks to the drop down menu, and switching the action from Copy to Move.

You can watch the full walkthrough on the Paperwork Organiser page. If you want to check out more of my macros, head over to the I’ve Got a Macro for That page, where you’ll also find a contact form if there’s something you’d like help building.

And if this is your first time importing a macro for Keyboard Maestro and you’re not sure what to do, I’ve put together a simple guide you can follow here.

I’ve recently realised that the original script attached to the music list combiner spreadsheet I posted here in September 2025 wasn’t quite as tight as it needed to be, specifically when it came to how it interacted with different sorts of fades. Although I showed it working in my tutorial with a simple transition, it turns out it didn’t handle crossfades or fades overlapping other music very well. I’ve updated the Google Apps Script to handle these properly, so if you’re using the old version, I definitely recommend swapping it out for this one.

Get the Updated Script by clicking here

Key Improvements:

• The Bridge Rule: The old script did merge songs, but this version is much smarter at bridging the gaps caused by complex fades and overlaps. It is more bulletproof to make sure we get the results we need: one single, continuous entry on your cue sheet from the very first frame to the last, including fades into the song or a fade out of the song if there are any involved.
• Selectable Frame Rates: You aren’t stuck with 25fps anymore. When you run the script, it asks for your project’s frame rate (23.98, 24, 25, etc.), so your durations stay accurate.

• Transition Snapping: It now automatically cleans up those 1-frame overlaps that usually happen with fades, ensuring your start and end times are frame-perfect every time.

Note for anyone watching the tutorial video: The video is still the best way to see how to bring the script into Apps Script within Google Sheets and get it running. However, this updated version is much more efficient. It removes the need for manual column placement and includes smarter merging logic to handle transitions and fades automatically. Watch the tutorial here.

Hey everyone,

I’ve just uploaded a new tutorial showing how to use another one of my macros. This one automatically renames temp music using metadata, which is really useful when you’re dealing with score for an entire film or TV show, or a lot of commercial tracks.

A lot of editors I’ve worked with like having the track number included in the filename for score. The problem is, when you download temp music, the track numbers are often missing, leaving only the track name. Normally, that means comparing each track against Spotify and renaming them manually. This macro takes care of that by pulling the track number straight from the metadata and adding it to the filename for you.

The macro can also rename files in a slightly different way than just adding track numbers. I originally designed this version for an editor who preferred their commercial tracks to be handled differently to their score, with the artist name at the start of the filename followed by the song title in capitals.

In the video, I walk through how the macro works, how it pulls information from the metadata, and how to set everything up properly. There are two macros included: a one-off setup macro that installs what’s needed to read the metadata, and the main macro that actually does the renaming. I also show how the original filenames are stored in the file’s comment metadata before the file is renamed, so nothing is lost and the original name still comes through into Avid if you need it.

You can watch the tutorial on the Music Renaming page. And if these naming conventions don’t quite match your workflow, but the information for how you want your tracks renamed exists in the metadata, feel free to get in touch and I can adapt the macro for you. And if you want to check out more of my macros, head over to the I’ve Got a Macro for That! page. There’s also a contact form there so you can get in touch if there is a macro you would like me to help you build.