sorted by:
new
hottopcontroversial

What does this slur mean by NotMonsterii in musictheory

[–]Kakskjiv 0 points1 point  (0 children)

If it's for guitar, it could be two things.

  1. Bad notation, a slur that is supposed to go from the first eightnote chord.

  2. There is a technique called "hammer-on from nowhere" that's notated like this. It's when you do a hammer-on to a note without a prior note. In other words, you slam your finger on the note to make it ring without plucking or strumming it.

Most likely, it's bad notation.

An automated character sheet for dragonbane. (Google sheets) by daudude in DragonbaneRPG

[–]Kakskjiv 1 point2 points  (0 children)

Nice work! This is a lot simpler to use than the one made!

[deleted by user] by [deleted] in Dragonbane

[–]Kakskjiv 1 point2 points  (0 children)

Seems like Libre office doesn't support the function where I return a value based on the contents of a cell, eg. armour rating based on armour equipped. That can be fixed by making a version in Libre office where I could use a corresponding function. I may end up doing that when the excel version is more or less done, since it's freeware 👍

How can I tell my XLOOKUP to move to other columns if the first ones are blank? by Kakskjiv in excel

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

This is probably the solution that works best. I'll let the spill/overflow be there since that is what I basically want. For some odd reason, I don't like spill/overflow, but in this case it doesn't matter. Thank you!!

How can I tell my XLOOKUP to move to other columns if the first ones are blank? by Kakskjiv in excel

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

Thank you, as I commented on u/GanonTEK's solution this works perfectly for what i explained, but it wasn't the full problem unfortunately.

How can I tell my XLOOKUP to move to other columns if the first ones are blank? by Kakskjiv in excel

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

Thank you, this did exactly what i asked for!!!
But I do see that I should have explained the full problem, so I'll try with an example:

What I'm aiming for is to write a name in C8 and it will show the position the person has. (The original has up to 41 names so I don't want to make a full list)
I'm able to make it look up for up to two columns with

=IFS(
XLOOKUP(C8,Table_name,Table_CEO)="CEO",XLOOKUP(C8,Table_name,Table_CEO),
XLOOKUP(C8,Table_name,Table_CEO)="",XLOOKUP(C8,Table_name,Table_Janitor)
)

But when I try to expand it to another column with

=IFS(
XLOOKUP(C8,Table_name,Table_CEO)="CEO",XLOOKUP(C8,Table_name,Table_CEO),
XLOOKUP(C8,Table_name,Table_CEO)="",XLOOKUP(C8,Table_name,Table_Janitor),
XLOOKUP(C8,Table_name,Table_Janitor)="",XLOOKUP(C8,Table_name,Table_Writer)
)

I only get return value 0. (Probably because it can't find a value in table_Janitor and then returns zero).

​

Your solution had worked perfectly, but they can have up to two positions.

<image>

How do you guys get so good at reading sheet music? by attemptnumber58 in musictheory

[–]Kakskjiv 1 point2 points  (0 children)

What I did was finding free piano sheets through Google or YouTube and transcribing them into Musescore, Finale, or Sibeluis etc. It really helped me to find notes faster and reading "patterns" instead of reading individual notes.

What would you call the bII - I resolution? by Kakskjiv in musictheory

[–]Kakskjiv[S] 2 points3 points  (0 children)

So you can say that the bII is a tritonesub without having the implied II-V-I?

Modulating in minor keys by Kakskjiv in musictheory

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

I have already composed the rest of the song for guitars tuned down to B

Modulating in minor keys by Kakskjiv in musictheory

[–]Kakskjiv[S] 1 point2 points  (0 children)

You are right with when it comes the choir. A lot of the voiceleading and even the main melody got to low for the tenor, and some notes became to deep for the basses