spreadsheets 4 lifeee

THE FOLLOWING FACTS ARE BETTER READ ON MY NEOCITIES WEBSITE! 👉👉👉👉GO HERE👈👈👈👈👈

Happy New Year!

For the fourth year running, my stubbornness has sucked hundreds of hours of my life and turned it into a daily nerdy titbit of uselessness. The years seem to drag on, yet it seems only last week that I was writing this very similar message at the end of 2023. I'll try not to get too deep on you right now.Somehow, I've managed yet again to keep going for 365 days - in spite of the leap year! This year, #aFactADay2024 has comprised roughly 55 thousand words and 330 thousand characters. This is almost double 2022 and 2023! And to celebrate, I've procrastinated written four articles about me! Think of it as a "Me Wrapped" - that's trendy, right? I mean, the most interesting facts aren't actually about me: there's lots of ordinary-style facting, and the NCS article is quite mathsy. It's all really an excuse to stop thinking about the worries, whether they be 2024 or 2025. Here's what we have in store for you:

A report on my hair! (Neocities (better) / Tumblr)

A report on my nails! (Neocities (better) / Tumblr)

A report on my... bowel movements........... (Neocities (better) / Tumblr)

And a mathematical-style article on statistics, in which lots of facts about me are mentioned, including my timetables, my socks and my Anki flashcards. Read the PDF here or visit the landing page (this one is not available as a Tumblr post).

Here's to another year! Hopefully we can learn from what 2024 threw at us to survive and maybe even thrive. 🥂These webpages are part of the Fact of the Day run by someone who unfortunately goes by too many names to bother putting anything here.

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...

B)

i mean it's not that impressive because i have so many pairs of socks and it's not really an integral and noticeable part of the outfit. but still

i can't be bothered to check this with spreadsheet, although i definitely could (maybe i should upgrade it acc to do it automatically) so i use google's api and a discord bot haha

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)

i could have a "shadow" table where the values are all multiplied by the weighting - this would be very easy to set up because of autofill and could be hidden from view in another worksheet or hidden column/rows. but part of the fun of spreadsheeting is in not doing that.

this is a pretty easy setup, using simplified data: the shadow table is just autofilled, which is why i put the $ on the C (for good practice - in case i was planning on having multiple columns of data, but a common weighting (in case you don't know, the $ means that when you drag it, that specific reference (just the letter or number; if you want both you'd need to do $C$4) doesn't increment)). then the bottom line is just a SUM, pretty standard stuff.

let's work on reducing the number of formulae to the point where we don't need extra rows at all. the first is using ARRAYFORMULA: currently, i wrote one formula and dragged it down so there's 4 formulae, but with ARRAYFORMULA() i can do basically the same thing with a single formula.

the magic of ARRAYFORMULA is such that you can input arrays (a list/grid of values) to another formula that usually doesn't accept arrays, and you get an array back.

like so! when a cell evaluates to an array, it just prints out the entire array in a line. because the cells B10:B12 are controlled by the formula in B9, i can try to delete their contents all i want and it keeps coming back.

^ this is what happens if there's already a formula/value in that cell :P

and of course, SUM takes an array as input, and we already have an array in a single cell! if you want to leave the shadow table there for info purposes, sure, but i think it's far too many numbers that aren't really contributing anything, so we can just combine what we have so far into one formula:

B9:B12=ARRAYFORMULA(B4:B7*$C4:$C7) and =SUM(B9:B12), just converts into one beautiful formula: =SUM(ARRAYFORMULA(B4:B7*$C4:$C7))

i prefer to actually do this the other way round: because ARRAYFORMULA just means that anywhere within that formula you can use arrays, i prefer to have it surround as outmostly as possible. ie, =ARRAFORMULA(SUM( ... )), as in the original worksheet:

that last little multiplication is just to strike it off the leaderboard once i've decided that i can't/don't want to consider a university. lovely stuff

it's quite an inelegant solution. here's a quick breakdown:

COUNTIF(<the entire table>, 1) to see how many 1s there are -> COUNTIF(<the entire table>, B33) and then put 1 in B33, so i can drag both of these across fivefold and i don't need to rewrite it out five times -> ARRAYFORMULA(<the entire table>, B33:F33) then put 1 through 5 in B33:F33, so there's only one formula

this entire league table at the bottom, of 2x14 rows, i'm a big fan of. basically:

we take the list of destinations (B1:N1 - i can't remember why i put all those $s in) and concatenate it with their scores. this has to happen before we sort them, so they get paired up. curly brackets { } can take ranges and stick them one-after-another - but only horizontally (afaik). so we transpose the ranges (flip them around the diagonal so now we're dealing with vertical ranges) for concatenation

then we sort by the scores range (B29:N29) which also has to be transposed so it's the same length as the range we're sorting. FALSE is for descending, and then we transpose the result back so it fits nicely into our boxes. because SORT returns the whole range, we can print the whole league table with just one formula! not even an arrayformula!

there's probably a slightly complicated way of not using {} so you don't have to transpose and back, but i can't be bothered to do that - i like {} anyway.

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)

i could have a "shadow" table where the values are all multiplied by the weighting - this would be very easy to set up because of autofill and could be hidden from view in another worksheet or hidden column/rows. but part of the fun of spreadsheeting is in not doing that.

this is a pretty easy setup, using simplified data: the shadow table is just autofilled, which is why i put the $ on the C (for good practice - in case i was planning on having multiple columns of data, but a common weighting (in case you don't know, the $ means that when you drag it, that specific reference (just the letter or number; if you want both you'd need to do $C$4) doesn't increment)). then the bottom line is just a SUM, pretty standard stuff.

let's work on reducing the number of formulae to the point where we don't need extra rows at all. the first is using ARRAYFORMULA: currently, i wrote one formula and dragged it down so there's 4 formulae, but with ARRAYFORMULA() i can do basically the same thing with a single formula.

the magic of ARRAYFORMULA is such that you can input arrays (a list/grid of values) to another formula that usually doesn't accept arrays, and you get an array back.

like so! when a cell evaluates to an array, it just prints out the entire array in a line. because the cells B10:B12 are controlled by the formula in B9, i can try to delete their contents all i want and it keeps coming back.

^ this is what happens if there's already a formula/value in that cell :P

and of course, SUM takes an array as input, and we already have an array in a single cell! if you want to leave the shadow table there for info purposes, sure, but i think it's far too many numbers that aren't really contributing anything, so we can just combine what we have so far into one formula:

B9:B12=ARRAYFORMULA(B4:B7*$C4:$C7) and =SUM(B9:B12), just converts into one beautiful formula: =SUM(ARRAYFORMULA(B4:B7*$C4:$C7))

i prefer to actually do this the other way round: because ARRAYFORMULA just means that anywhere within that formula you can use arrays, i prefer to have it surround as outmostly as possible. ie, =ARRAFORMULA(SUM( ... )), as in the original worksheet:

that last little multiplication is just to strike it off the leaderboard once i've decided that i can't/don't want to consider a university. lovely stuff

it's quite an inelegant solution. here's a quick breakdown:

COUNTIF(<the entire table>, 1) to see how many 1s there are -> COUNTIF(<the entire table>, B33) and then put 1 in B33, so i can drag both of these across fivefold and i don't need to rewrite it out five times -> ARRAYFORMULA(<the entire table>, B33:F33) then put 1 through 5 in B33:F33, so there's only one formula

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)

i could have a "shadow" table where the values are all multiplied by the weighting - this would be very easy to set up because of autofill and could be hidden from view in another worksheet or hidden column/rows. but part of the fun of spreadsheeting is in not doing that.

this is a pretty easy setup, using simplified data: the shadow table is just autofilled, which is why i put the $ on the C (for good practice - in case i was planning on having multiple columns of data, but a common weighting (in case you don't know, the $ means that when you drag it, that specific reference (just the letter or number; if you want both you'd need to do $C$4) doesn't increment)). then the bottom line is just a SUM, pretty standard stuff.

let's work on reducing the number of formulae to the point where we don't need extra rows at all. the first is using ARRAYFORMULA: currently, i wrote one formula and dragged it down so there's 4 formulae, but with ARRAYFORMULA() i can do basically the same thing with a single formula.

the magic of ARRAYFORMULA is such that you can input arrays (a list/grid of values) to another formula that usually doesn't accept arrays, and you get an array back.

like so! when a cell evaluates to an array, it just prints out the entire array in a line. because the cells B10:B12 are controlled by the formula in B9, i can try to delete their contents all i want and it keeps coming back.

^ this is what happens if there's already a formula/value in that cell :P

and of course, SUM takes an array as input, and we already have an array in a single cell! if you want to leave the shadow table there for info purposes, sure, but i think it's far too many numbers that aren't really contributing anything, so we can just combine what we have so far into one formula:

B9:B12=ARRAYFORMULA(B4:B7*$C4:$C7) and =SUM(B9:B12), just converts into one beautiful formula: =SUM(ARRAYFORMULA(B4:B7*$C4:$C7))

i prefer to actually do this the other way round: because ARRAYFORMULA just means that anywhere within that formula you can use arrays, i prefer to have it surround as outmostly as possible. ie, =ARRAFORMULA(SUM( ... )), as in the original worksheet:

that last little multiplication is just to strike it off the leaderboard once i've decided that i can't/don't want to consider a university. lovely stuff