#spreadsheetblr

i hear studyblr is popular? here's a spreadsheetblr i used to use for my studyblrs:

last exam season, i wrote down the marks to all my practice papers on a spreadsheet. initially just for the helpfulness of not having to add the scores, then i started building the spreadsheet a bit just cos

(ava is available.) i marked each practice paper thrice, once really harshly, once really generously and once normally. then a quick summary of the papers at the end of the week was easy:

and of course a graph to track progress long-term:

i don't need to use this one anymore (thank god). at one point i was doing over 20 practice papers a week on average, and at some point i managed 6 in a day. type 2 fun

it's pretty simple, and very much subjective. but there are some cool formulae going on that i might talk about another time. (grey boxes are ones i'm not entirely certain on so i just guessed lol)

the actual spreadsheet of this is really simple. just a big table that i add to once a day with what i'm currently wearing - four items (each with a unique name/id and conditional formatting so ik whether i wrote the name properly)

the actual spreadsheet doesn't have much to it: just this big long table and a counting thing at the top

that's just the top of the counting - i have over 40 pairs of socks in at the top there, but most are too holey to wear (i need to start darning them...). there's 522 days in the log so far (top-left cell) so apparently i wear blue jeans on 32% of all days...

it's a timesheet for tube challenging (see here if you don't know what that is) - it's basically a really weird timetable made by splicing all the existing timetables together, so i can see what trains i ought to be taking. every now and then i split the branches because you can never be sure whether you're going to make a connection (perhaps you're running a little slowly or the trains are early/late)

italicised times are rough because most of the time the tube runs frequently enough that timetables don't mean much.

it's not very well-presented (just botched some colours onto the default theme) because i made it really quickly and it's meant to be read really quickly, but i think it's quite a cool (and useful) way of having an in-depth plan to hand and having all your alternatives laid out legibly