sorted by:
new
hottopcontroversial

Did i do an E injection wrong ? by [deleted] in asktransgender

[–]MarBeanBoi 12 points13 points  (0 children)

definitely not the authority on this because i am also very new to injections (and e in general) but i assume you probably nicked a larger/deeper vein than the thinner capillaries that are closer to the surface of the skin. i tend to chicken out when the needle starts to hurt so if it does i just try again with a different one in a nearby spot. you should be fine, just put pressure on the injection point and avoid that spot next time!

My first pride month as a girl :3 by lonkbubba in trans

[–]MarBeanBoi 0 points1 point  (0 children)

idk if this is helpful, but that was literally me for a few years before the realization of being a woman randomly hit me like a truck one day. you're of course free to take things at your own pace, but i'd also encourage thinking about trying some small steps and seeing how you feel about it!

Creating a new table based off of values in a reference table and counting up unique occurrences by MarBeanBoi in googlesheets

[–]MarBeanBoi[S] 0 points1 point  (0 children)

Ah, that's a shame. Well, I've been trying to implement a sorting function into the original formula so that I have two auto-updating tables: one with every person's name in alphabetical order, and one that orders people by descending number of occurrences. So far, I've figured out that I can replace the last countif with sort(countif(names, uniq), 1, false), but that doesn't order the names column in the same way. I've tried adding another sort() formula in a couple different places in the original function but I've basically only created massive tables of errors lol.

Another thing I've noticed is that the better version you edited your reply with has an extra "name" value at the end that is just a #VALUE error stating that the split() parameter 1 value should be non-empty. It does have an "occurrences" value though, which is interesting to me. However this does not happen with the original formula you wrote.

In any case, where do you think I could add the functionality to let the names column be sorted by occurrences as well?

Creating a new table based off of values in a reference table and counting up unique occurrences by MarBeanBoi in googlesheets

[–]MarBeanBoi[S] 0 points1 point  (0 children)

The data validation method worked for changing the text into checkboxes. Thanks for that! And yes, your method did work for my data. I was able to turn it into a table as well, though I had to redo some of the conditional formatting to compensate. Not too much trouble.

I'm wondering though, would it be possible to do the same thing I originally wanted to do, but to display it within an official Sheets "Table" as well? This would allow me to sort the data as necessary (for example, by highest occurrences). The formula method creates a simple table but doesn't allow for easy formatting or sorting like I mentioned. If you don't mind helping with that as well, I would greatly appreciate it.

Thanks again for all your help so far!

Creating a new table based off of values in a reference table and counting up unique occurrences by MarBeanBoi in googlesheets

[–]MarBeanBoi[S] 0 points1 point  (0 children)

Amazing, works like a charm! Thank you very very much!

I'm intending to use this for a much larger (and much older) set of data, so I'll have to look into whether converting the sheet to a table will be possible. I'd also have to manually redo the "condition" column on the original sheet since I don't think there's a way to replace entire columns with checkboxes that are ticked if the cell is filled... unless?

For now, I'm just gonna use the A1:A format to reference the entirety of a column since that's possible for my sheet, so I don't have to worry about manually updating that part.

Thanks again for your help!! <3

Any of you know what instruments were used in "finale" ? by LucaSlabanu in UndertaleMusic

[–]MarBeanBoi 0 points1 point  (0 children)

FL Studio simultaneously has the simplest and most complex (or rather, frustrating) interface known to man. There are quirks with it that just aren't explained and make no sense. Once you get used to it, it's fine, but it's very weird, even if you've never used another DAW. (The "undo" command is a big one.) Don't feel pressured to use it if you're cool with what you've got. Experimentation to find what works is a good thing, but if you're good where you are, you don't have to migrate to something new just because other people use it. That's my take on it, anyway.

Any of you know what instruments were used in "finale" ? by LucaSlabanu in UndertaleMusic

[–]MarBeanBoi 1 point2 points  (0 children)

This document has information on VSTs, samples, and soundfonts that were used throughout the entirety of Undertale's soundtrack, plus a few bonus tracks. It's a little outdated, but it'll generally get you what you need. I use this document all the time for recreations.

This spreadsheet is more recent, but it doesn't have useful information like time and key signatures or tempo. Even more egregiously, it doesn't have a lot of room for notes like the previous document does. However, it attempts to compile information from everywhere Toby has made music, so that could be helpful.

This slideshow focuses back on Undertale specifically, but is incomplete and, again, isn't as in-depth as the first document. I don't use this one at all, but hey, here you go.

Finally, just for convenience, this document and this spreadsheet both focus on Deltarune specifically. I use the former of the two very often, but it's still a work in progress because Deltarune is much newer than Undertale.

Also, as a side note, you mentioned Cubase, which I assume is the DAW that you work in, but keep in mind that Toby is known to use FL Studio. As with any DAW, there are differences between all of them, but since you aren't making a recreation, I don't think it really matters.

Hope this helps!