I hope these tools are helpful for other composers and welcome any feedback to improve them, thanks. (And nothing I could find worked across both Google Sheets and Excel). To convert a timecode to a different frame rate, the total number of frames is multiplied by (target frame rate / source frame rate). The (recovering former) software engineer in me couldn't resist putting together this set of timecode custom functions, since I wasn't really happy with any of the existing timecode + spreadsheets code floating around. setting up any statuses you want), and then adds a few more features I was looking for (like letting you list out specific working days, rather than assuming you are working 7 days a week - maybe naively optimistic ). The above formula contains two DATEDIF functions. Below is the formula that will do this: DATEDIF (B2,C2,'y')&' Years '&DATEDIF (B2,C2,'ym')&' Months'. only one status column rather than separate checklists), doesn't have anything about licensing music, is a little more customizable ( e.g. Below I again have the same data set and I want to calculate the duration of service of each employee in years and months. Differences in short: this Music Log simplifies a few things ( e.g. ![]() To calculate hours worked, you need to find the difference between 2 times. 24 hours, 60 minutes, and 60 seconds, when adding or subtracting minutes and seconds they cannot be treated like regular numbers. Spreadsheet users should absolutely also check out Shie Rozow's excellent Show Cue Manager spreadsheet (linked at the bottom of that post), which I borrowed a few great ideas from. Excel treats date and time formats differently from numbers and text. I also know CueDB has many outspoken happy users, so awesome if that's already working well for you. Googling for excel timecode didn’t produce any results which met my requirements: support 29. I tried to set something up with solid essentials but that was then very customizable. Here's an overview video that shows all of that:Īs I mention in the video, I'm certainly not trying to create the one-and-only Music Log template here, since different projects will have different tracking needs. TC Calc is a timecode calculator which enables you to add or subtract two different timecodes. Google Sheets (gsheets-timecode on GitHub).For use in any of your own spreadsheets, a set of custom functions that handle all the complexities of timecode math at different frame rates and drop standards. (Or download Excel version from GitHub project linked below).With RapidCue cue sheet for export at the end. Music Log spreadsheet template for day-to-day cue tracking - customizable statuses, how much music left to write per day, etc. ![]() Hey folks, for anyone who works with timecode (or plans to) in Google Sheets or Excel, I put together a couple of tools for myself and some colleagues - sharing here in case they are useful to anyone else:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |