What is the highest minimum and maximum roll possible on a (Dex) sleight of hand/pickpocket check? [closed]


FOR THE KLEPTOMANIACS OUT THERE:

Let’s say we’re attempting to pickpocket something from someone and would like to reduce our chances of failure as much as possible. What is the highest minimum roll and maximum roll reliably possible in the game? In order to make this easier to replicate for others, I’m going to offer some restrictions:

  • Things that are not largely guaranteed in most games, such as: Boons, Artifacts, and Manuals.
  • This can be any level character up to 20th level, all that matters is that it still remains the highest min and max roll for the check.
  • Must be acting alone and receive assistance only from themselves, their items, feats, racial abilities, class features, etc.

These restrictions should ensure that the check can be performed reliably any time it is made by anyone with the proposed build in nearly any campaign with the average amount of magical items and quest rewards, etc.

I will post my own findings as an answer below. Feel free to use it as a frame for further answers, or offer one all your own.

What is the highest value a condition could reach?

I’m making a Pathfinder 2e character sheet on Google sheet to automate as much number-crunching as possible. Currently, I’m making a dropdown list for conditions, as well as formulas for calculating their penalties.

I find adding conditions with pre-determined values much simpler than conditions with fillable values. For example, instead of clumsy and a blank slot for its value, the dropdown list will have clumsy 1, clumsy 2, clumsy 3, and so on. It’s ugly, but it greatly simplifies the formula. However, if a condition’s value could reach a really high number, then it will be too cumbersome to use.

The highest I have found is stupefied 4 from feeblemind and unfathomable song. I’m also pretty sure I’ve seen an ancestry/heritage/feat which could increase the maximum value of dying to 5.

So what is the highest value/penalty a condition could reach? For the supremely meticulous: what is the highest value each condition could reach?

Whats the highest racial or template charisma boost you can get for a +1 LA?

I’m currently working on a Sha’ir Gish character that will eventually PrC into Zhentarim Skymage(LoD) and I need to buff my charisma as much as possible. Skymage has a gimmick of giving you a paladin mount, or at least a close facially thereof, which can be any creature that’s a size larger than you and has no more hit die than your Skymage level + Charisma mod + 1. I already have Spark(Dragon Mag) for +2. I’m also considering Prestige Races (also Dragon) for another +1. Unseelie Fey is unfortunately banned so that’s not an option. Other than that just about anything official is allowed. I’d prefer to stay at or below LA +1 is possible. Some other options i considered were Athasian Human (also Dragon mag) +2 to two stats, Draconic Creature for +2 to strength, con, and charisma, and savage progression half fey. Spark was ruled to only work on PHB races and not variants like Athasian so that’s probably off the table, and it kind of negates the benefits of any +2 charisma LA 0 race like Spellscale and Savage Progression Aasimar.

I could use magic items like tomes eventually to raise it farther, but i can’t rely on temporary boosts like cloaks of charisma because if my charisma gets lowered, like taking the cloak off, my mount might rebell and attack or abandon me, and that’s not fun for anyone. I’d prefer human for story reasons in the setting and to open up Human paragon as an option for another +2 untyped bonus, though small races aren’t a bad choice either because that opens up a medium mount. I’m aiming for a Wyvern to be my first mount with a True dragon of some kind as my final. Mostly likely a 11-14 hit dice gold dragon for general power and the ability to turn into a smaller animal for easy transportation. Though if anyone want’s to make a better suggestion id be happy to hear it.

Why is the Halting problem decidable for Goto languages limited on the highest value of constants and variables?

This is taken from an old exam of my university that I am using to prepare myself for the coming exam:

Given is a language $ \text{Goto}_{17}^c \subseteq \text{Goto}$ . This language contains exactly those $ \text{Goto}$ programs in which no constant is ever above $ 17$ nor any variable ever above $ c$ .

$ Goto$ here describes the set of all programs written in the $ Goto$ language made up of the following elements:

With variables $ v_i \in \mathbb{N}$ and constants $ c \in \mathbb{N}$
Assignment: $ x_i := c, x_i := x_i \pm c$
Conditional Jump: if(Comparison) goto $ L_i$
Haltcommand: halt

I am currently struggling with the formalization of a proof, but this is what I have come to so far, phrased very casually: For any given program in this set we know that it is finite. A finite program contains a finite amount of variables and a finite amount of states, or lines to be in. As such, there is a finite amount of configurations in which this process can be. If we let this program run, we can keep a list of all configurations we have seen. That is, the combination of all used variable-values and the state of the program. If we let the program run, there must be one of two things that happens eventually: The program halts. In this case, we return YES and have decided that it halts. The program reaches a configuration that has been recorded before. As the language is deterministic, this means that we must have gone a full loop which will exactly repeat now.

No other case can exist as that would mean that we keep running forever on finite code without repeating a configuration. This means after every step, among our list of infinite steps, there is a new configuration. This would mean that there are infinite configurations, which is a contradiction.

Is this correct? Furthermore, how would a more formal proof look if it is? If not, how would a correct proof look?

How to get the registers in the highest time of period

I have 2 tables all with relations and i want to get the contracts in the highest time of period in order to do a hystorical report wheter if the tima of period is closed or active

This is the code that i have or that ive been trying

Select a.id, a.ordinalperiod,b.name, a.fecin,a.fecend,b.dtend,a.contrato

From historiccontrat a Left join periodo b On a.id=b.id And a.ordinalperiod=b.ordinalperiod Where a.fecend in(select max(b.dtend)where a.id=b.id and a.ordinalperiod=b.ordinalperiod and b.dtend <>’4000-01-01′)

Th thing is that the employee have 5 period of times taht works in the company liket this

Id período dt_start dt_end 000 1 2012-01-01 2012-04-01

000 2 2013-05-01 2016-04-03

…. …. ….

And in each of these períods of time have diferente type of contrats

With this say what i want is that the filter show me Just the contrats in the Last period

But the result with my query is the row with the data of the period 2 but no the contrats

Thank for your help

What is the highest average damage that a level 10 character can deal in response to being hit or damaged?


Premise

Typically, you deal damage by hitting the other guy with a stick (or a fireball) [citation needed]; however, spells like fire shield damage enemies who hit you:

In addition, whenever a creature within 5 feet of you hits you with a melee attack, the shield erupts with flame. The attacker takes 2d8 fire damage from a warm shield, or 2d8 cold damage from a cold shield.

Similarly, hellish rebuke allows you to damage enemies in response to them damaging you. Either way, the enemy wouldn’t have taken damage if they chose to just ignore you. This leads to my question: what is the highest average damage that a level 10 character can deal in response to being hit or damaged?

Restrictions

Character

  • Level 10.
  • May use the PHB and one of the following: EE, MToF, SCAG, VGtM, or XGtE. This restriction extends to spells, as well. (If the spell is one your build allows you to copy from a scroll or spellbook, however, you may pick it from any of those sources.)
  • No variant rules besides multiclassing, feats, and variant human.
  • Up to three magic items from DMG Tables F or G with a maximum rarity of Rare.

Combat

  • Four encounters; Combat 1, Combat 2, Short Rest, Combat 3, Combat 4 (each of these events is separated by 30 minutes). The Short Rest is mandatory.
  • Each combat encounter has you face off against two earth elementals. These elementals do not have any damage vulnerabilities, damage immunities, or condition immunities. They keep their damage resistances.
  • Each combat lasts three rounds. All participants get a turn in each round.
  • Enemies move next to the PC and attack normally.
  • Enemies do not make opportunity attacks.
  • For the sake of simplicity, treat enemies and the PC as if they had infinite health.
  • You may not use the Ready action. (Mainly to prevent "I ready blight for when I get damaged" from being the best answer.)
  • Any spell or ability that lasts 10 minutes or longer may be activated before entering combat. Any spell or ability that lasts longer than 8 hours may be activated the day before.
  • You may not spend more than 100 gp on spells that consume costly material components. (So casting identify and find familiar is fine, because identify doesn’t consume its costly component, but casting glyph of warding is not.)
  • You never lose concentration as a result of taking damage.
  • Allies cannot help you, unless you summon/create them yourself (via conjure animals, animate dead, etc.)

Damage calculation

  • Damage should be the average damage per round over the course of the adventuring day.
  • Only count damage dealt to enemies (the earth elementals) in direct response to, and in the same turn as, being hit or damaged. Hellish rebuke is fine. The extra damage dealt by absorb elements is not. You may still deal damage in other ways (in case it’s necessary for setup), you just can’t count it in the total.

What’s the highest amount of ranged attacks a pure fighter can make in one turn consistently?

I’ve been working on a 20th level character concept for a while and trying to optimize it for use in a future game, the requirements would be as follows:

  • Only 3.X WotC handbooks (No 3rd party books, no magazines, no online-only content except for web enhancements of handbooks, no adventure-specific content).
  • Only handbooks from the D&D 3E standard setting/Greyhawk (no eberron, faerun, dragonlance, etc).
  • The only base class used must be fighter, any prestige class is ok as long as it doesn’t grant any magical abilities (includes psionics, incarnum, etc), also no martial powers.
  • Optimized for ranged damage output, without relying on allies, consumables, or very low frequency abilities (1/day stuff and the like).

Given that, the concept I’ve got so far is a pure SAD dexterity fighter dual wielding auto-realoading hand-crossbows, boosting damage with feats Dead Eye and Crossbow Sniper, plus specialization and mastery feats. The damage per attack is not too bad (1d4+31), and I’m now looking for ways to increment the number of attacks I could make.

So far I get 4 attacks from BAB, 3 from TWF, 1 from Rapid Shot, and 1 from Haste, for a total of 9 attacks.

I’m specifically looking for methods to increase the number of attacks per full attack action. But I’d also welcome any general advice to improve the build given the previous requirements.

What is the highest hit point that one character can have?

By reading others questions like Highest damage in one melee attack and Highest AC possible.

How many hit points can a character have, and also highest achievable hit points possible in an instant?

Conditions :

We’re looking at a level 20 character and no multiclass.
Feats are allowed.
Magic items are those on the tables in the D&D 5th Edition DMG.
Spells, skills, feats and abilities available to a player character are eligible for use/consideration.
No other help from an ally.

How to find the square with the highest total sum

I have an integer matrix of size 4n x 4n. I need to select a part of the matrix of size n^2 from which adds up to the most.

For example if n = 3. I have a matrix of size 12 x 12. In the below picture, you can clearly see that n^2 square (outlined in red) adds up to the most. For simplicities sake, I made all the numbers 5, expect for 9 of the boxes which are 9999 so its clear that that is the n^2 squares that add up to the most.

enter image description here

My approach to solving this problem was to essentially create a n^2 square and brute force the entire 4n x 4n matrix. However, that runs in O(n^4) time complexity. How can I do it in O(n^2)?