Monster Statblock for Google Sheets

Condense the following monster stat block into a two-line format using the following formula:

 

=TRANSPOSE({"Name","Type";"AC","HP";"Hit","PP";"Attack","Attack";"Special","Special";"Taking Damage","Taking Damage";"Str","mod";"Dex","(save)";"Con","-";"Int","-";"Wis","-";"Cha","-";"M1","M2";"HD","(CR) XP"})

 

Enter the monster's data in the following format:

 

=TRANSPOSE({"[name]","[size and type]";"[AC]","[HP]";"[hit bonus]","[Passive Perception]";"[attack 1]","[attack 2]";"[special ability cell 1]","[special ability cell 2]";"[Taking Damage cell 1]","[Taking Damage cell 2]";"[Str score]","[Str mod (Str Save if app.)]";"[Dex score]","[Dex mod (Dex Save if app.)]";"[Con score]","[Con mod (Con Save if app.)]";"[Int score]","[Int mod (Int Save if app.)]";"[Wis score]","[Wis mod (Wis Save if app.)]";"[Cha score]","[Cha mod (Cha Save if app.)]";"[L/S/M cell 1]","[L/S/M cell 2]";"[HD]","[XP]"})

 

Using the following instructions:

 

Unique Data: Use unique data for each creature. Do not copy information from other creatures.

Maintain Format: Keep the same column order and format as specified. If a cell does not apply to a particular creature, use a single space ("-") to hold a blank cell.

Concise Entries: Keep entries brief and to the point. Avoid unnecessary words or phrases.

Standard Terms and Abbreviations: Use standard abbreviations for abilities, skills, and game concepts (e.g., "Str" for Strength, "Dex" for Dexterity, etc.).

Format Numbers Consistently: Use parentheses for secondary values (e.g., "45 (22)" for hit points) and maintain a consistent format for numbers.

To Hit Format: Format the "Hit" field as "=+[value]" to include the plus sign in the spreadsheet.

Interpret Stat Blocks Accurately: Understand the game language and conventions used in the stat block, and be sensitive to the game language of 5E or other variations of 5E.

Aggressive Conciseness: Abbreviate ability names to fit the available space while maintaining clarity. Remove redundant information, use the shortest known abbreviations for abilities and skills, and omit unnecessary words.

Attributes, Attribute Mods, and Saves:

 

Attribute Format: Use the following format for attributes: "Score, Mod (Save if applicable)" (e.g., "16, 3 (5)").

Passive Perception: Calculate Passive Perception as 10 + the stated Perception skill.

Additional Guidelines:

 

Complex Creatures and NPCs: For creatures with multiple attacks, special features, or complex abilities, consider using additional lines or a separate section to summarize their stat block.

Attack Notation: Format attacks as "[rolled damage + modifier] [(average damage)] ([attack name])". If a creature has a multi-attack, indicate this by adding a multiplier after the attack name (e.g., "slam (x2)") or a trailing "+" sign to indicate that it may be followed by the second attack.

Damage Notation: Use standard notation for damage immunity, resistance, and vulnerability (e.g., "I- poison", "R- fire", "V- radiant").

Special Abilities and Features: List special abilities, features, or traits that are not attacks, and use clear and concise language to describe them.

Paired Cells: When generating text for split output columns, Minimize max(len(cell1), len(cell2)) over all possible assignments of [column-specific values] to cell1 and cell2

 

useful abbreviations

 

b: bludgeoning

p: piercing

s: slashing

!: non (e.g., "!mag" for non-magical, "!admt" for non-adamantine)

I-: immune to

R-: resistant to

V-: vulnerable to

S: Small

M: Medium

L: Large

H: Huge

G: Gargantuan

T: Tiny