Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
White Dwarf 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 Nest
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!
EN Publishing
Twitter
BlueSky
Facebook
Instagram
EN World
BlueSky
YouTube
Facebook
Twitter
Twitch
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
*Pathfinder & Starfinder
Dynamic Excel "Wiesbaden Charactersheet" D&D (v1.11)
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="Magus Coeruleus" data-source="post: 4286262" data-attributes="member: 1704"><p>Indeed it does show, thanks. Let me make a few comments and ask a couple of questions while at it:</p><p></p><p>1) As mentioned, heavy thrown = use Str for javelin even though ranged.</p><p>2) Notice on the Attacks tab you used attack bonus 1 for ranged basic and attack bonus 2 for melee basic, which is swapped. I only mention it because the first time I tried using the sheet I made the same mistake. I believe that most people will intuitively tend to think of their primary melee weapon first and their ranged next, although that may only be for defenders while rangers and wizards, for instance, may have the opposite. The KotS pregens show melee before ranged for basic attacks. I just wonder if the incidence of mistakes would be less if melee basic came first (column E) and ranged second (column G). Maybe there is some other creative way to facilitate getting the correct attack bonus chosen on favorites/basic.</p><p>3) I notice you overrode the attack bonus for the powers, using straight-up Str rather than the BAB, which includes weapon proficiency bonus. Those bonuses do apply to powers so there's no need for the override. I looked back at the PHB and unfortunately it is not even mentioned in the Attack section of Powers in the Classes chapter that you should include it, but weapon proficiencies (Equipment chapter, how to read weapon table) says they apply to attack rolls, which is a broad category including powers. Still, I think they could/should have made this more explicit and I hope it doesn't confuse too many people.</p><p>4) So if I want to account for using something like a dagger in melee and ranged I should use 2 attack bonus columns in the Attacks tab, one entering Str and the other Dex, right?</p><p>5) I like the way that I can just change the attack bonus # (1-5) for a power and have it update the character sheet accordingly, rather than needing a separate entry.</p><p>6) Probably too much to ask, but it would be awesome if under Base attack bonuses you could just specify a weapon and based on a lookup of its properties it could determine whether it is usable for melee, ranged, or both, and accordingly calculate cell values indicating the relevant ability. Instead of having one Ability and BAB per entry it would have two, one for melee and one for ranged. If the weapon is only applicable for one or the other, an N/A could appear in the relevant cells (not to be confused with Excel's #N/A). It would use the light vs. heavy thrown properties to determine whether ranged should use Str or Dex, etc.</p><p>7) Edit: noticed something else. The Attacks tab row with drop downs to select the weapon/implement type (row 8) is called "weapon/implement type" and the one where you entered the damage die (row 10) is called weapon/implement name. I think row 8 is name, and I'm not sure either what type means or why you entered the damage die. If you do mean to put the damage then in the future you could consider letting the damage field for the favorite powers automatically calculate that based on whether it's 1[W], 2[W], 0, etc. base damage and which attack bonus (i.e. which weapon) was chosen, where appropriate. Just a thought.</p><p></p><p>Again, thanks for your hard work!!!</p></blockquote><p></p>
[QUOTE="Magus Coeruleus, post: 4286262, member: 1704"] Indeed it does show, thanks. Let me make a few comments and ask a couple of questions while at it: 1) As mentioned, heavy thrown = use Str for javelin even though ranged. 2) Notice on the Attacks tab you used attack bonus 1 for ranged basic and attack bonus 2 for melee basic, which is swapped. I only mention it because the first time I tried using the sheet I made the same mistake. I believe that most people will intuitively tend to think of their primary melee weapon first and their ranged next, although that may only be for defenders while rangers and wizards, for instance, may have the opposite. The KotS pregens show melee before ranged for basic attacks. I just wonder if the incidence of mistakes would be less if melee basic came first (column E) and ranged second (column G). Maybe there is some other creative way to facilitate getting the correct attack bonus chosen on favorites/basic. 3) I notice you overrode the attack bonus for the powers, using straight-up Str rather than the BAB, which includes weapon proficiency bonus. Those bonuses do apply to powers so there's no need for the override. I looked back at the PHB and unfortunately it is not even mentioned in the Attack section of Powers in the Classes chapter that you should include it, but weapon proficiencies (Equipment chapter, how to read weapon table) says they apply to attack rolls, which is a broad category including powers. Still, I think they could/should have made this more explicit and I hope it doesn't confuse too many people. 4) So if I want to account for using something like a dagger in melee and ranged I should use 2 attack bonus columns in the Attacks tab, one entering Str and the other Dex, right? 5) I like the way that I can just change the attack bonus # (1-5) for a power and have it update the character sheet accordingly, rather than needing a separate entry. 6) Probably too much to ask, but it would be awesome if under Base attack bonuses you could just specify a weapon and based on a lookup of its properties it could determine whether it is usable for melee, ranged, or both, and accordingly calculate cell values indicating the relevant ability. Instead of having one Ability and BAB per entry it would have two, one for melee and one for ranged. If the weapon is only applicable for one or the other, an N/A could appear in the relevant cells (not to be confused with Excel's #N/A). It would use the light vs. heavy thrown properties to determine whether ranged should use Str or Dex, etc. 7) Edit: noticed something else. The Attacks tab row with drop downs to select the weapon/implement type (row 8) is called "weapon/implement type" and the one where you entered the damage die (row 10) is called weapon/implement name. I think row 8 is name, and I'm not sure either what type means or why you entered the damage die. If you do mean to put the damage then in the future you could consider letting the damage field for the favorite powers automatically calculate that based on whether it's 1[W], 2[W], 0, etc. base damage and which attack bonus (i.e. which weapon) was chosen, where appropriate. Just a thought. Again, thanks for your hard work!!! [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Pathfinder & Starfinder
Dynamic Excel "Wiesbaden Charactersheet" D&D (v1.11)
Top