#google excel sheet

[delta-lethonomia]

There's a reddit thread on the BG3 sub where the user u/InklingRain posted a spreadsheet they made with all the companion approvals. Super useful in general both for playing the game and for fic, so I thought I'd post it on tumblr and play around a little!

There's a top row with the average approval by companion, but I didn't find that very useful, so I changed it to the count of approvals (i.e. count of approvals & disapproval total, how often a companion had a reaction to something). We all know Astarion gives a lot of disapprovals here and there, but they're only -1 at a time, so no big deal, right?

No. Minsc has the least at only 45 reactions, Halsin at 95, Minthara at 145, and of the main companions, Gale is pretty average at 198, Lae'zel at 224, and Shadowheart, rather opinionated at 258...

but that's nothing compared to Astarion's 406. That's almost 150 more than the next person!!! That's more than Minthara and Shadowheart combined! Babygirl really woke up one day and decided to get in a snit over everything that happens 😂

(Longer post about count of positive and negative opinions, sum of approvals and disapprovals, and some major outliers below. Picture with values at the very end.)

But that's a bit disingenuous. If we look at the ratio of positive to negative opinions (not taking value into account), Astarion's pretty average at 30% (negative count over sum count, so let's call that negativity). This is similar to Gale (31%), Karlach (30%), and Lae'zel (32%). In theory, getting Astarion's approval or disapproval is just as easy as any of theirs, with a 20% bias towards positive approvals. Later companions are weighted heavily towards the lower end of the spectrum, with Jaheira at 13% negativity and Minsc at 9%. As you only get them very late, it's pretty clear that the game gives you a lot of opportunities to get their approvals and thus open up more of their quests and dialogue.

However. We have an outlier. Wyll Ravenguard, clocking in at an indecent 38% negativity! Which really just goes to show, while Astarion is the most opinionated, Wyll has the most disapprovals, making him the judgiest companion of all 🤣

However, this really wouldn't be a good post if we didn't look at the value of approvals. Karlach, for instance, has the strongest disapproval value of -100 (given if you sleep with her and then call it a mistake). Ouch. This is clearly at outlier and doesn't say much about Karlach's changeability of opinion in general. If we look at the sum of positive and negative opinions, this is a very heavy swing, making up 100 points of her total 191 disapproval points possible to her 281 approvals total. Another outlier is Minsc, who currently possesses a 43% disapproval percentage (a heavy -50 disapproval given if you sacrifice him to Sarevok. Jaheira, by contrast, apparently doesn't give a damn, or her value might simply not be included in the dateset.)

Removing outliers is really a matter of opinion here, so I'll only remove the most extreme swings, such as the above mentioned disapprovals.

The otherwise strongest swings are Astarion (-15 for telling him it was a mistake preventing him from drinking Araj's blood, or saying you only wanted to sleep with him, not deal with his trauma) and Wyll (+20 for siding with Karlach during his confrontation with her, which really shows he didn't really want to kill her and is very grateful you stopped him). Halsin gives +40 for reuniting Oliver with Thaniel, which...lifting the shadow curse is sort of his life's mission, and a bit of a unique case, so while it makes sense, I think it's such a unique event that can't be topped by anything else and will remove it. Jaheira give +20 for extending the Emperor's protection to Minsc, and, for funsies, Minthara's heaviest disapproval is -5 for donating to Lolth at the Stormshore Tabernacle. (lol)

I only chose to remove the aforementioned Karlach, Minsc, and Halsin values, as they're all very large swings and rather character-defining or personal to the individuals mentioned, so I don't think it says much about them in a more general day-to-day sense.

Now, using the sums of our negative and positive values, Gale is our most Negative Nancy, clocking in at 37%, which goes to show that while he's pretty average for the amount of things he cares about, when he disapproves, it's a strong one. Next up is Astarion at 35%, and Wyll at 34%. Lowest are Jaheira and Minsc at 7% and 4% respectively, which makes an intuitive sort of sense: Jaheira is old and just over being upset by the players poor choices, and Minsc is an insanely positive person overall. The next most positive companion is Halsin at 13%, which also matches with his vibe pretty well, followed by Minthara at 17%, Karlach at 24%, Lae'zel at 26%, and Shadowheart at 28%.

Tl;dr: Astarion has many, many opinions, but Wyll is the most judgemental (most disapprovals compared to approvals possible). However, when it comes to the strength of those disapprovals, Gale reigns supreme, followed by Astarion.

If don't break Karlach's heart, help Halsin achieve his life's ambition, or sacrifice Minsc, then they're pretty positive overall. Later companions are heavily weighted to approve of your actions, and Minthara is comparatively judgemental, but overall far more easy to gain approval than disapproval from.

If you take the average of all these values and include the later companions to look at as a personality "baseline" of how judgy and how strong those disapprovals may be, then...the Act 1 companions are all dramatic af, which really should come to no ones' surprise, while Karlach is the most willing to give the benefit of the doubt imo.

[dsudis]

View this post on Instagram

A post shared by Matty McTech (@setupspawn)

[thatcorridorman]

I archived the magnus archives

idk link to the full thing is here https://docs.google.com/spreadsheets/d/1vA6kin0H5bk_Nu15WTnwmAEPTAx9MLVO/edit?usp=sharing&ouid=117712544114786577413&rtpof=true&sd=true

I genuinely don't know what anyone would use this for, and honestly doing recreational paperwork is crazy and i need to sit with myself for a bit and think about this one

anyway john's case numbering system sucks so i made a new one, not really that good but it acts better as a call number system. In real life there would be albums and catalogue numbers but thank god the magnus institute archive does NOT exist so that's not an issue

[doiefy]

ateez discography stats?? (preview lmfao)

(freak in the spreadsheets that's what)

work has been chill lately so I've taken to developing an excessively large and detailed spreadsheet that analyzes ateez's discography and line distribution from debut until present... will be posting my full summary soon because as a STEM and spreadsheet nerd I think this is super fun and interesting LOL (if you hate math get off my page (just kidding pls stay))

yes I went through ateez's entire fucking discography to record their total line time for this, shout out to the four line distribution channels I ripped shit from (HEXA6ON, random_k, k_line distribution and others doing the most for this fandom)

my favourite finding so far:

this is a trend most kpop fans know about but I'm showing graphically here. we see a lot of groups start out with line distributions that rely on one or two vocal powerhouses to carry the rest of the group (debate all you fucking want about this, I'm not getting involved in that shit I'm just saying it as it is); then the distribution becomes more "fair" as time goes on and members all get more experience.

in the graph above, there's a lot of variance in 2018, but all the lines have converged recently, indicating a more equal line distribution. the distribution was most equal in 2023 and we've diverged a little bit since then, but 2024 isn't over yet!

some other nerd shit:

hongjoong starts the most songs out of all the members, with 17 songs in which he sang the first line. he's closely followed by yunho, seonghwa, and then san.

yeosang's share of lines has increased by a net 76% since debut, while jongho's has decreased by a net 77%.

13.7% of ateez's total songs are remixes and 12.3% are a Japanese/Korean/English version of an existing song.

on average, ateez songs run for 3 minutes and 12 seconds

whenever a future song is teased in a previous song, we typically wait 3 months for the full song to be released... with the exception of "Sector 1," which was teased in "Outro: Long Journey" back in January of 2020, and wasn't released in full until almost 3 years later.

and a peak at the spreadsheet madness behind all this:

will be posting the rest soon, stay tuned ✌🏻

[nixcraft]

Them: Why not use Google Sheets or MS Excel as a Database? Me: You are right. Go ahead and use it. Have a nice day. PS - You reach that stage in life where you just don't have any will or power left to fight stupidity. You know what? Forget the fight. It's about keeping my peace. There, I said it.

[netscapenavigator-official]

Currently trying to figure out how to make a calculator in LibreOffice that can take the "yes or no" answers of four questions and turn them into values for this horrendous formula I've mustered up:

(B1+G1(D1*C1)/P)+(B2+G2(D2*C2))=F

But I've never used spreadsheet formulas outside of basic adding, subtracting, multiplying, dividing, etc., so using IF/ELSE statements in a LibreOffice Calc document terrifies me. I barely know any Swift from Apple's Swift Playgrounds, but I feel like I could write a better script in Swift than the monstrosity I'm about to make in LibreCalc.

[bestiainfinita]

English:

So for the last couple of months I´ve been working on an Excel Presentation which objective is organize "all" of the "EPIC: The Musical" Full Fan-Animatics (that meet a certain criteria, which I´ll comment later).

It´s currently unfinished but I really wanted to share it and it would be helpfull if y´all tell me if everything is working properly, or if you have any form of feed-back about it. Also if you have a full animatic that I haven´t found and added yet send it to me so I can do that.

Español:

Así que durante los últimos meses he estado trabajando en una presentación de Excel cuyo objetivo es organizar "todos" los Fan-Animatics Completos de "EPIC: The Musical" (que cumplan con ciertos criterios que comentaré más adelante).

Actualmente no está terminado, pero realmente quería compartirlo y me sería muy útil si me dijeran si todo funciona correctamente o si tienen cualquier tipo de recomendación. Además, si conocen / tienen algún animatic completo que aún no he encontrado ni agregado, envíenmelo para que lo haga.

English

So my criteria of what animatics were added here was;

1) The animatic must be about EPIC, not about any other fandom. (This one is obligatory)

2) The animatic must be using a released version of the song, so animatics using snippets aren’t here.

3) The animatic must be of the full song, there is room for a couple of seconds missing, like 10 or something depending on the song.

Also, you might notice how the songs are indicated by either green, yellow or red(ish), each color have a meaning.

• Green: It follows all of the criteria previously mentioned.

• Yellow: It doesn’t follow one or two points of the criteria, the specifics would be:

- Because it’s using a non-oficial or non-released version of the song.

- Because it’s missing about 20 to 40 seconds (this variates from song to song).

- Because it’s (stated to be) un-finished.

- Because it’s set on a non-canon moment of the lore or is putting the song on an incorrect moment of the history.

• Red-ish: This one just shouldn’t be there but I putted there either way because I felt like it, they shouldn’t be there because:

- Any of the reasons in the criteria and in yellow, with atleast two at the same time.

- I wasn’t able to find the animatic or creator.

- It straight up doesn’t exist anymore.

Español:

Entonces, mi criterio sobre qué animatics entraban o no a la presentación es la siguiente:

1) El animatic debe ser de EPIC, es decir, no es de ningún otro fandom diferente. (Este es el único obligatorio)

2) El animatic debe usar una versión publicada de forma oficial, es decir, no se incluirán animatics que usan snippets.

3) El animatic debe ser la canción completa, hay un cierto margen de como 10 segundos dependiendo de la canción.

De seguro notarán que las celdas que indican los animatics vienen en verde, amarillo o rojo (o similar), cada color tiene su significado.

• Verde: Cumple adecuadamente con todos los puntos del criterio.

• Amarillo: No cumple con uno o dos de Los puntos del criterio, de forma más específica sería;

- Porque está usando una versión no oficial y/o no terminada de la canción.

- Porque le faltan de 20 a 40 segundos de la canción (este número varía de canción a canción).

- Porque (se indicó que) está incompleto.

- Porque está situado fuera del canon de EPIC o en un momento cronológicamente incorrecto.

• Rojo: Estos animatics genuinamente no deberían de haber sido incluidos pero los agregué de todos modos, estos no deberían de estar aquí por:

- Cualquiera de las razones de la criteria o el punto “amarillo”, con por lo menos dos de estás a la vez.

- No fui capaz de encontrar el animatic o al creador.

- De plano, el animatic ya no existe.

[hmmfr0g]

Anyone else got the kinda autism that makes you wanna live in a spreadsheet?

[woolpines]

idk what im doing but im doing something

[seveneyesoup]

HATE it when you’re talking to someone about excel and then it turns out this whole time they’ve been saying excel and meaning google sheets, like it’s the same thing instead of a vastly vastly inferior product

[fuck-yeah-spreadsheets]

Sorry but you can't stop me feeling like a god when I've cracked something in Excel. (Not sorry)

[autumnfrolic]

ello everyone ! small announcement // request from the mun !!! ♥ i hope you guys had a good holiday season ! last time i was on tumblr i belieeve i finished most of my drafts, but I probably missed something while i was away. if you're still waiting on something from me, could you kindly remind me ? things get lost in my likes !!! i'm gonna need to make a system of cataloguing threads lmfao... alsoo, i've mainly had muse for art stuff more than writing the last few weeks, so i've been over on my clangen blog ; @flutterclangen !!! i'm making a goal of trying to post on it semi-regularly , so that's where u can also find me for the time being !!!! ( shameless comic plug heehee ♥ ) hope you all are doing well and cheers ! ♥

[electropneumatic]

Have you ever thought about swapping excel for something more... Serious and able to handle larger datasets?

Or are you the type of engineer who writes Visual Basic Macros in 2024?

The one time I was analyzing a database of any real size I used R, as instructed by my boss. However, for personal projects, I like to use Google Sheets. Is it the best software for whatever I'm trying to do? Hell no. But that's half the fun for me. The structure of the language means I have to think outside the boax and get really creative sometimes (you can somewhat replace if and for loops with arrayFormula, but watch out! It's definitely not 1:1). And I really like the look that CS majors make when I tell them "my Google Sheet supports STL files."

Basically- for larger applications at work, I don't use spreadsheets. For personal projects? Absolutely!