Menu
Home
Post new thread
What's new
Latest activity
Authors
Community
Post new thread
Create wiki page
Community supporters
All threads
Latest threads
Hot threads
New posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Wiki
Pages
Latest activity
Resources
Latest reviews
Search resources
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
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
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
Chat/Discord
EN Publishing
EN5ider
Level Up: Advanced 5E
Podcast
Log in
Register
What's new
Search
Search
Search titles only
By:
Post new thread
Create wiki page
Community supporters
All threads
Latest threads
Hot threads
New posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Menu
Log in
Register
Install the app
Install
NOW LIVE FOR 14 DAYS ONLY! --
Enchanted Trinkets II for D&D 5th Edition
on Kickstarter! More enchanted trinkets for your 5th Edition game in a new softcover compilation!
log in
or
register
to remove this ad
Home
Community
General Tabletop Discussion
*Dungeons & Dragons
Halivar's 4E auto-calculating character sheet v.2.03 (OpenOffice, Excel & blank PDF)
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="PrecociousApprentice" data-source="post: 4265523" data-attributes="member: 61449"><p>So here is my contribution.</p><p></p><p>If you change the first Misc box in the fort, reflex, and will defenses to race you could add these lines to that cell.</p><p></p><p>Fort- =IF(B12="Human",1,0)</p><p>Reflex- =IF(B12="Human",1,0)</p><p>Will- =IF(OR(B12="Human",B12="Eladrin"),1,0)</p><p></p><p>This will autocalculate the effect of race on defenses.</p><p></p><p>If you add these lines to the Class box for each defense you can autocalculate for each classes effect on defenses.</p><p></p><p>Fort- =IF(AO9="Fighter",2,IF(NOT(OR(AO9="Cleric",AO9="Warlock",AO9="Wizard")),1,0))</p><p>Reflex- =IF(AO9="Rogue",2,IF(NOT(OR(AO9="Fighter",AO9="Cleric",AO9="Warlord", AO9="Wizard")),1,0))</p><p></p><p>Will- =IF(OR(AO9="Wizard",AO9="Cleric"),2,IF(NOT(OR(AO9="Fighter",AO9="Rogue",AO9="Ranger")),1,0))</p><p></p><p>These will just calculate for you if you enter your race and class in the appropriate boxes. I have attached a mod of your excel sheet to test if you like.</p></blockquote><p></p>
[QUOTE="PrecociousApprentice, post: 4265523, member: 61449"] So here is my contribution. If you change the first Misc box in the fort, reflex, and will defenses to race you could add these lines to that cell. Fort- =IF(B12="Human",1,0) Reflex- =IF(B12="Human",1,0) Will- =IF(OR(B12="Human",B12="Eladrin"),1,0) This will autocalculate the effect of race on defenses. If you add these lines to the Class box for each defense you can autocalculate for each classes effect on defenses. Fort- =IF(AO9="Fighter",2,IF(NOT(OR(AO9="Cleric",AO9="Warlock",AO9="Wizard")),1,0)) Reflex- =IF(AO9="Rogue",2,IF(NOT(OR(AO9="Fighter",AO9="Cleric",AO9="Warlord", AO9="Wizard")),1,0)) Will- =IF(OR(AO9="Wizard",AO9="Cleric"),2,IF(NOT(OR(AO9="Fighter",AO9="Rogue",AO9="Ranger")),1,0)) These will just calculate for you if you enter your race and class in the appropriate boxes. I have attached a mod of your excel sheet to test if you like. [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Community
General Tabletop Discussion
*Dungeons & Dragons
Halivar's 4E auto-calculating character sheet v.2.03 (OpenOffice, Excel & blank PDF)
Top