Va Business – Propel Your Brand Upwards – Make 800$ per day – Work From Home – Beginner Friendly

HOW IT WORKS

VIRTUAL ASSISTANT RESELLER SITE

No headaches completely outsourced. Virtual Assistant & Social Media Posting Service is completed by the Suppliers included with the sale of this website.

Very reliable Suppliers with a proven track record, together with 4 backup Suppliers.

This site runs on Autopilot if you have reasonable communication skills. No Phone contact with Customers is required. Just forwarding emails. No Skype Calls, just Skype Text Chat or exchange of…

Va Business – Propel Your Brand Upwards – Make 800$ per day – Work From Home – Beginner Friendly

Can thunderwave push upwards?

Imagine this scenario: You are a 2nd level wizard of the evocation school. Someone messed up (may have been you, but let’s not point fingers) and you are now surrounded by enemies. Then you have a brilliant idea: let’s cast thunderwave on all of them! Since you can sculpt the spell you will be perfectly safe. So you choose as the point of origin where your feet touch the ground and direct the cube upwards from there. You say the magic words and then … ?

I see two possibilities:

  • Those surrounding you are pushed upwards if they fail the save, as that is still “away from you”. They then fall, taking 1d6 damage and likely landing prone.
  • Those in the area are pushed radially if they fail the save, the basic premise of “away from you” overriding the positioning of the effect. You may have room to breathe, but getting away is still problematic.

Is either one supported by the rules? Is there a 3rd option?

Sum upwards until another column’s value is met

I found a handful solutions for summing down, but nothing for summing up.

Example table:

type | value A    | - B    | 5 C    | 10 D    | 7 A    | [SUM1 = 7+10+5 = 22] B    | 4 B    | 2 C    | 3 C    | 5 A    | [SUM2 = 5+3+2+4 = 14] 

Goal: Each SUM cell (type A) is summing upwards until the next A is seen in the “type” column.

You can open and edit this example as Google Sheet here.

I have tried MATCH, VLOOKUP, INDEX and others without success.

=MATCH("A";A2:A11;0) would give me always the position of the first “A” from top.

=INDEX(B2:B11;MATCH("A";A2:A11;0);0) would give me the value, not the cell index.

A similiar question Sum the value of the cells above going up until blank cell only shows how to do this by hand.

Another similar question does not answer the case above: Getting a sum of cells (bottom to top) in Google Sheets until a specific value is matched

This post on Google Groups proposes something I don’t grasp:

=if(trim(A9)="TOTALS:",sum(arrayformula(index(B8):index(B:B,min(arrayformula(if(isnumber(B1:B8),row(B1:B8))))))),iferror(1/0))

Melee attacking upwards (enemy on 10ft ceiling)


We encountered a Vampire Spawn in the 10 feet high basement of an old church. The first strike was mine, after which the creature attacked my ally and retreated onto the ceiling as the thundering roar of my Booming Blade punished it’s retreat. Still inexperienced and unsure about my reach, after a short consultation with my mind, I decided to spend my turn switching to my trusty crossbow and make some distance.

However this turned out to be a mistake, since right after, the creature was in in my face trying to gauge out my eyes. Due to my nimbleness I managed to avoid it’s attacks. Regretting my earlier choice to change weapons I was left with the options to switch weapons and miss another turn, attack with disadvantage, or use my crossbow as an improvised melee weapon and trust in Booming Blade to hold the enemy in place after I disengaged.

Perhaps I should have switched weapons, but I decided that 1d4 (improvised weapon) + 1 (magic ring) + 1d8 (booming blade) was good enough. I missed.

On the plus side, it was my crossbows sneak attack assisted bolt that finally slayed the Vampire by pierced it’s heart.

In this situation, would it have been possible to just attack upwards instead of changing to the crossbow?

In session, this was something to be looked up later and decided against, but I haven’t found any rules on attacking in 3D.

With me being more than 5 feet in height and my melee attack range considered to be 5 feet, I should have been able to reach the ceiling itself, not to mention the Vampire Spawn hanging from it.


As for exact measurements, (read this part only if you enjoy pointlessly over-analyzing things)

my character is 5 feet 6 inches/5.5 feet, which gives an estimated standing reach of 7 feet 4 inches/7.3 feet (for a human, my character is a Kenku), the blade of a short sword is 12 to 20 inches / 1 to 1.6 feet. This should give me a height of 8.3 to 8.9 feet from standing statically.

Testing it in real life, my estimated and standing reach match to less than 0.2 inches of the estimation on the site and I’m just shy of reaching my ceiling standing statically. As a test I tried moving as if I was attacking my ceiling and based on where I could feel my hand touch the ceiling, the length of my fingers and how much distance I lacked to reach my ceiling, I estimate about 0.4 feet in additional height. Considering that I’m taller than my character, let’s say that gives 0.3 feet, increasing the height to 8.6 – 9.2 feet and that’s still without changing how you hold the handle of the sword. In addition, just lying on the ground, my torso and legs measure about 0.6 feet.

Because my Kenku isn’t a Human, only a humanoid, it’s impossible to estimate arm length which influences standing reach, however, considering that Birds usually have a high wingspan and long legs, I think it’s reasonable to assume that the arms should be as long, if not longer than, a humans.


So that would require the Vampire Spawn to be flat against the ceiling without any parts hanging down more than 0.2 to 0.8 feet for it to be outside of my reach. I consider that unlikely.

What are the actual rules for this type of scenario, or how do you handle it in your group? Should I be allowed to melee attack an enemy that’s on a ceiling or low in the air?

Can the Pushing Attack Maneuver push someone upwards?

The Battle Master’s Pushing Attack can push the target up to 15 ft away from the user if the target fails their save. Ordinarily, this would mean the target is driven back 15 feet away on the ground, as with the Shove attack.

However, I was thinking of a scenario that involved two characters falling: one Battle Master and his target.

If the BM strikes his target, hits, and uses Pushing Attack, he would reasonably be able to drive the target 15 ft in any direction, because there’s no floor that anchors our mind to a horizontal surface, unlike the regular “shove” attack. In fact, pushing someone directly perpendicular to the floor in this situation is much harder than pushing someone sideways but with some up/down elevation.

Taken to the extreme, in this case, the BM could even shove the target upwards. If they hadn’t fallen more than 15 ft yet, the target could “return to safety” by being thrown back up to the platform they fell from. Pushed downwards and the target would now be falling faster than the BM.

Now, keep that falling scenario in mind as we translate the same mechanics to the BM and his target on the ground. Going back to the question: would Pushing Attack allow the BM to push someone 15ft in the air?