So I wanted to do it with an excel file and just do it manually. Every session is recorded with OBS, uploaded to YT, and then redownloaded so it’s compressed. You may disagree with that method, but I just care about the moments and such, so the quality is irrelevant as long as it’s 720+ and you can tell what’s going on, and Youtube does the compression for me so I don’t gotta be running handbrake 24/7.
I have over a thousand sessions since 2017, probably way more than that, just know that it’s a lot. I mostly play League and mostly with the same people, and it’s almost all organized with dates and time. Some sessions (moreso edited stuff) don’t have dates. Some stuff is not gaming related.
Now the reason I’m making this post is that I’m wondering what data you’d include. You know how excel has those columns, well I thought the first would be some sort of hex id just in case I needed it for something in the future, the second would be the date, and third would be title. I’d like to include file path and YT url/id. Maybe YT upload date as well. File size and upload date of course.
Now the more annoying stuff that I’d like to include: People I played with, what games I played, how long I played each game, the scorelines or lengths of said games. Timestamps to funny or notable moments. Now I’m not sure how I’d include that if every session only has a single row. Maybe a second sheet? Idk.
I’m not asking you for nitty gritty details, but just suggestions and such if you have any.