Re: Scroll Of The Monk Pdf To Excel
Roseanne Devon
With the forms scrollbar you can easily link its value to a cell, but not its min and max value, and those you will want to link to the number of records in your set (minus the number of records shown in your table)... With the ActiveX control it looks like the same story. You will have to set the min and max properties through some code in which case I always prefer the ActiveX control as it interacts with VBA much easier (imho).
I have a spreadsheet where I'm tracking inventory on misc electronics that we keep in stock. I have set up a table that holds all the printers. When I scroll down I know that I can use Freeze Panes to freeze the top row (or any row/column), but I would like the table header to cover the sheet header.
For me, in Excel 2016, the default behaviour is what you want. If I do not freeze panes, then any time I scroll down past the table header, the headers overlay the column letters as shown in your second picture. If I scroll down past the bottom of the table, then the headers disappear again.
I understand the core reason for removing the incremental arrows and I love my magic mouse but could kill every time I end up at the wrong side of a spreadsheet by catching the mouse surface... fine control is always better to have even if lots of users don't need it. Let's also hope the contrast of the scroll bars will become adjustable at some time. Oh the joy of being at the bleeding edge of new OS use :o)
Surely if you are scrolling through a large document you do not want to scroll one line at a time using the arrows, but scroll through a screen at a time by clicking above or below what we used to call the "elevator"?
Have only just joined and I too was wondering about the missing arrows. After reading the previous comments about the space bar etc etc I tried the up and down arrows on the keypad and I have been scrolling up and down this site from top to bottom and back again without the aid of the mouse. It is the same as using the arrows on the bottom of the scroll bar except you use your finger on the keyboard arrows. Hopefully it will work the same on other web sites where you have to scroll through many pages.
I'm thinking that the lack of arrows may be the thing that sends me back to Snow Leopard. In the 30-40 minutes it has taken me to find a definitive answer the the original poster's question, I've developed an ache in my "mouse" shoulder from having to move the mouse around to scroll. I've tried scroll wheels and don't like them. Likewise, there are things I'm not comfortable doing with a trackpad, even after years of practice. I'm not interested in spending money on one for my desktop. A fingertip touch on the mouse is less motion then a swipe, scrollwheel, or spacebar, and provides excellent control. Between the missing arrows and the Launchpad, I feel like I've taken a giant step back time.
I use several applications where the arrows on the scroll bar allow small movement as one line, especially important when copying several different sections of several paragraphs in Word, picking and choosing file movement in Spring Cleaning, or seeing just how far your object is off the printable field in Visio.
Although the Versions and Autosave stuff and the Automatic Termination thing bother me even more, I also miss the fine control of the scroll bar arrows, and it's one of the reasons I won't "upgrade" to Lion until I must.
My GM has created a NPC CR 9 monk that we've been encountering intermediately. Our party has one level 5, two level 6s, and one level 7. 3 casters and a rogue. The monk has fought us to a standstill several times (usually because the GM doesn't just send a squad of fodder with him, but a full squad of CR 6+ fighters, all with Quick Draw and light crossbows. All our casters can fly / levitate, but none of us can cast protection from arrows.
All this said you should expect this monk to have some sort of item of bullcrap that lets him teleport away when he gets too low on HP or something. Once you get the "Wall of" spells you can defeat him simply by mass walling him in somewhere so he burns to death.
Monks are a spell casters nightmare, especially an arcane caster. The trick to beating the monk is to be in control of the battle field. You should try to make it so he has to come to you instead of you coming to him. This will give you a chance to prepare and buff your selves up. Start by summoning some allies to help deal with the minions. After you have some decent allies cast spells that will boost all of them. Haste, Prayer and Protection form Law Communal would all be good spells to cast. These will mainly be dealing the minions but some may also help with the monk.
The rest of the party can still attack the monk while the summoned creatures are dealing with the minions. Avoid spells that allow a saving throw or target touch attacks. If the monk is using any kind of metal weapon use the spell burning disarm. It does allow a saving throw, but the saving throw is to drop the object.
If you can afford, fly for all, then scribe scroll for magic missile, a lot of them ( best if you can afford a cl 9 wand) and fill remaining slots with magic missile. Give the rogue greater invisibility, iirc monk don't get uncanny dodge, so his ac should drop a bit. Then, if you can grapple him, he cannot escape from magic missile.
How do you kill a monk like this (other than just fly up and use lots of area effects...)?
Another thing to look at. Sometimes the best spells to case in this situation are not directly at said Monk. Have you looked at Buffs?
I don't think you will manage to defeat this guy; GM just likes his monk too much. That said... summon nature's ally III for 1d4+1 stirges. Do that multiple times. This is what I'd suggest, especially the part about calling your DM out on bulls***.Get all the other players on your side on this first, so you can guarantee some changes.
This is obviously a very frustrating enemy for your group and I'll second what's been said before by others; you won't defeat him. It's obvioius that your GM likes the monk very much and won't let him get taken down. The most effective thing to do in such a situation is to have your characters realize that fighting him is pointless and find ways to avoid/run away from him.
There are two or three advantages to this. First: you don't have to waste ressources on a hopeless battle. Second: if you ignore him, your gm will get bored with him and maybe retire him. And/or third: He'll get as frustrated as you are now and make some mistakes that will allow you to finally defeat his monk.
Yep too bad about that village, we cannot save it because that monk Overlord is too much for us. We'll go beat up some goblin raiders or bandits instead. Oh look there's the monk ahead of us...well time for us to drink our potions of Fly and fly in the opposite direction, etc.
That being said if you guys enjoy to campaign so much you want to salvage it, try having a conversation with your GM first. If the GM still thinks this level of challenge is normal, have you players play monk and escorts and he can play your party.
To be fair, he only has to jump 25', and use his 5' reach, so that would 'only' be DC 100. AUC.register('auc_MessageboardPostRowDisplay'); AjaxBusy.register('masked', 'busy', 'auc_MessageboardPostRowDisplay', null, null) Dabbler Sep 10, 2013, 10:04 am Archonus1 wrote: My GM has created a NPC CR 9 monk that we've been encountering intermediately. Our party has one level 5, two level 6s, and one level 7. 3 casters and a rogue.Why are you such disparate levels? the party should all be around the same level.Archonus1 wrote: The monk has fought us to a standstill several times (usually because the GM doesn't just send a squad of fodder with him, but a full squad of CR 6+ fighters, all with Quick Draw and light crossbows. All our casters can fly / levitate, but none of us can cast protection from arrows. Web, black tentacles, and if all else fails, fireball?Archonus1 wrote:Further, the monk was built such that he can use a qi point to jump to 30 feet (max levitate height) and get in 4 attacks if he hits. If this is legal I want to know what supplement it's in! A leap is movement and you cannot move and flurry/full attack, by RAW. If he's not getting that leap from a spell or item, then he's cheating outrageously because your maximum leap distance is Acrobatics check/4 in feet. That means he's scoring a 120...Also, 30' is not maximum levitation height; you can levitate at 30' per round as high as you like.
Monks can be hard to kill, but he hasn't killed you yet either. What you will probably find is that his flat-footed AC is rather more hitable. An invisible rogue will do him serious damage. Magic missiles, attacks that bleed his hit points that he doesn't get saves against, that kind of thing will make him a sad monk.Archonus1 wrote:How do you kill a monk like this (other than just fly up and use lots of area effects...)?
Why is everyone a different level? It's hard to run a game like that, let alone play one.Quote:
The monk has fought us to a standstill several times (usually because the GM doesn't just send a squad of fodder with him, but a full squad of CR 6+ fighters, all with Quick Draw and light crossbows. So your party's APL is 6, and he's regularly attacking you with a CR 9-10+ encounter...Quote:All our casters can fly / levitate, but none of us can cast protection from arrows. Do any of you have spells that alter weather or create concealment or obscure vision completely? You can't shoot something you don't have line of sight to -- something that can be fixed even with a smokestick if you don't have a spell -- and spells like gust of wind and the like can also make ranged attacks go wonky.Quote:
Further, the monk was built such that he can use a qi point to jump to 30 feet (max levitate height) and get in 4 attacks if he hits. Others have pointed it out but I just want to be neat and get this all in one response...1. Monks can spend a ki point to get a +20 to an Acrobatics check to jump. As others point out, he still needs to beat an impossibly high DC to get to 30 feet.