Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Next
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
Twitch
YouTube
Facebook (EN Publishing)
Facebook (EN World)
Twitter
Instagram
TikTok
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Community
General Tabletop Discussion
*Dungeons & Dragons
ForgedAnvil D&D 5E Character Generator
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="elandy" data-source="post: 6752830" data-attributes="member: 70918"><p><strong>Ranger with No Spells</strong></p><p></p><p>I've been playing a bit with the v1.61 beta, and as I thought it won't be useful to make the variant ranger with no spells from the UA article. Thanks anyway for the great job, this sheet is awesome (and it gets even better with each update!).</p><p></p><p>So I've been trying to use the "Additional Details" from the start sheet to put the Ranger with No Spells features and playing with some formulas and named variables to try to automatize it. And I think I got it! I leave it here if anyone is interested in it and wants to try it. Just copy the code below in the "additional details" section of the start sheet and it should work. I've got the Spanish version of excel, so I had to translate the formulas to put them here (I hope all is well translated). If you try it I would be glad to hear your feedback.</p><p></p><p><strong>Ranger with No Spells</strong></p><p>[CODE]="VARIANT: Ranger with No Spells"&IF(RangerLevel>=2;"</p><p>• Combat Superiority</p><p> - Superiority Dice - "&IF(RangerLevel<9;"4d8";IF(RangerLevel<17;"5d8";"6d8"))&"</p><p> - "&IF(RangerLevel<5;2;IF(RangerLevel<9;3;IF(RangerLevel<13;4;IF(RangerLevel<17;5;6))))&" Maneuvers - use only one maneuver per attack (DC"&8+ProfBonus+MAX(DEXMod;STRMod)&")</p><p>»Maneuver 1</p><p> Maneuver 1 text"&"</p><p>»Maneuver 2</p><p> Maneuver 2 text"&IF(RangerLevel>=5;"</p><p>»Maneuver 3</p><p> Maneuver 3 text";"")&IF(RangerLevel>=9;"</p><p>»Maneuver 4</p><p> Maneuver 4 text";"")&IF(RangerLevel>=13;"</p><p>»Maneuver 5</p><p> Maneuver 5 text";"")&IF(RangerLevel>=17;"</p><p>»Maneuver 6</p><p> Maneuver 6 text";"");"")&IF(RangerLevel>=3;"</p><p>• Poultices</p><p> Spend one hour gathering herbs to prepare "&IF(WISMod>1;WISMod;1)&" healing poultices that last 24 hours. Spend 1 minute </p><p> applying one poultice to a creature and it regains "&ROUNDUP(RangerLevel/2;0)&"d6 hit points";"")&IF(RangerLevel>=9;"</p><p>• Natural Antivenom</p><p> You have advantage on saving throws against poison and have resistance to poison damage.</p><p> Your poultices cure one poison effect in addition to restoring hit points";"")&IF(RangerLevel>=13;"</p><p>• Call Natural Allies</p><p> When you are in a "&J110&", "&J111&" or "&J112&" you can call creatures from that terrain to</p><p> fight on your side for 1 hour. They attack any creature hostile to you and are friendly to you and</p><p> your comrades. DM chosses type and number of beasts in one of the following groups:"&"</p><p> - One beasts up to CR 2</p><p> - Two beasts up to CR1</p><p> - Four beasts up to CR 1/2</p><p> - Eight beasts up to CR 1/4";"")&IF(RangerBeastMasterLevel>=15;"</p><p>• Beastly Coordination (Replaces Share Spells)</p><p> When an attacker that you can see hits your beast companion with an attack, you can call out a</p><p> warning."&" If your beast companion can hear you, it can use its reaction to halve the attack’s</p><p> damage against it";"")&IF(RangerLevel>=17;"</p><p>• Relentless</p><p> When you roll initiative and have no superiority dice remaining, you regain 1 superiority die";"")[/CODE]</p><p></p><p>It's not optimal, and I think it would be quite long for high level rangers (but I think probably many classes won't fit completely in the CSII at high levels).</p><p></p><p>The only thing I couldn't automatize is the manuevers. They will have to be typed where it says "Maneuver 1", "Maneuver 1 text", "Maneuver 2", etc.</p><p>Regarding that: would it be possible to have the maneuvers as named variables for this purpose? Or at least could you give us a reference of the cell in witch they are typed, so we wouldn't have to type them again?</p><p></p><p></p><p>On an unrelated matter: would it be possible to add a way to introduce new fighting styles to this sheet (as the ones in the UA Underdark Characters article)? As part of the Custom Subclass, or even better in a separate part on the custom sheet. And also I think it would be nice to have some custom feats as well (because they sure will appear some in the future). I know putting the possible bonuses of those in the sheet would be quite complicate, but at least if we could have the text added and the name in the dropdown list would be nice (the rest I think we can work it out with the overrides).</p><p></p><p>Once again, congratulations for your great sheet and many thanks for your excellent work!!!!</p></blockquote><p></p>
[QUOTE="elandy, post: 6752830, member: 70918"] [b]Ranger with No Spells[/b] I've been playing a bit with the v1.61 beta, and as I thought it won't be useful to make the variant ranger with no spells from the UA article. Thanks anyway for the great job, this sheet is awesome (and it gets even better with each update!). So I've been trying to use the "Additional Details" from the start sheet to put the Ranger with No Spells features and playing with some formulas and named variables to try to automatize it. And I think I got it! I leave it here if anyone is interested in it and wants to try it. Just copy the code below in the "additional details" section of the start sheet and it should work. I've got the Spanish version of excel, so I had to translate the formulas to put them here (I hope all is well translated). If you try it I would be glad to hear your feedback. [B]Ranger with No Spells[/B] [CODE]="VARIANT: Ranger with No Spells"&IF(RangerLevel>=2;" • Combat Superiority - Superiority Dice - "&IF(RangerLevel<9;"4d8";IF(RangerLevel<17;"5d8";"6d8"))&" - "&IF(RangerLevel<5;2;IF(RangerLevel<9;3;IF(RangerLevel<13;4;IF(RangerLevel<17;5;6))))&" Maneuvers - use only one maneuver per attack (DC"&8+ProfBonus+MAX(DEXMod;STRMod)&") »Maneuver 1 Maneuver 1 text"&" »Maneuver 2 Maneuver 2 text"&IF(RangerLevel>=5;" »Maneuver 3 Maneuver 3 text";"")&IF(RangerLevel>=9;" »Maneuver 4 Maneuver 4 text";"")&IF(RangerLevel>=13;" »Maneuver 5 Maneuver 5 text";"")&IF(RangerLevel>=17;" »Maneuver 6 Maneuver 6 text";"");"")&IF(RangerLevel>=3;" • Poultices Spend one hour gathering herbs to prepare "&IF(WISMod>1;WISMod;1)&" healing poultices that last 24 hours. Spend 1 minute applying one poultice to a creature and it regains "&ROUNDUP(RangerLevel/2;0)&"d6 hit points";"")&IF(RangerLevel>=9;" • Natural Antivenom You have advantage on saving throws against poison and have resistance to poison damage. Your poultices cure one poison effect in addition to restoring hit points";"")&IF(RangerLevel>=13;" • Call Natural Allies When you are in a "&J110&", "&J111&" or "&J112&" you can call creatures from that terrain to fight on your side for 1 hour. They attack any creature hostile to you and are friendly to you and your comrades. DM chosses type and number of beasts in one of the following groups:"&" - One beasts up to CR 2 - Two beasts up to CR1 - Four beasts up to CR 1/2 - Eight beasts up to CR 1/4";"")&IF(RangerBeastMasterLevel>=15;" • Beastly Coordination (Replaces Share Spells) When an attacker that you can see hits your beast companion with an attack, you can call out a warning."&" If your beast companion can hear you, it can use its reaction to halve the attack’s damage against it";"")&IF(RangerLevel>=17;" • Relentless When you roll initiative and have no superiority dice remaining, you regain 1 superiority die";"")[/CODE] It's not optimal, and I think it would be quite long for high level rangers (but I think probably many classes won't fit completely in the CSII at high levels). The only thing I couldn't automatize is the manuevers. They will have to be typed where it says "Maneuver 1", "Maneuver 1 text", "Maneuver 2", etc. Regarding that: would it be possible to have the maneuvers as named variables for this purpose? Or at least could you give us a reference of the cell in witch they are typed, so we wouldn't have to type them again? On an unrelated matter: would it be possible to add a way to introduce new fighting styles to this sheet (as the ones in the UA Underdark Characters article)? As part of the Custom Subclass, or even better in a separate part on the custom sheet. And also I think it would be nice to have some custom feats as well (because they sure will appear some in the future). I know putting the possible bonuses of those in the sheet would be quite complicate, but at least if we could have the text added and the name in the dropdown list would be nice (the rest I think we can work it out with the overrides). Once again, congratulations for your great sheet and many thanks for your excellent work!!!! [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
ForgedAnvil D&D 5E Character Generator
Top