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
*Dungeons & Dragons
Spreadsheet
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="Melatuis" data-source="post: 5727242" data-attributes="member: 17290"><p>"That looks like what Nookie was after, and I'm thinking it could be handy for me too - if I can figure out how Excel works.</p><p>Cleon"</p><p></p><p>I will try explain how the sheet works.</p><p></p><p>On the Data Input sheet</p><p>NAME: Green box type name of monster</p><p></p><p>SEX: yellow drop down box choose sex</p><p></p><p>ALIGNMENT: Green box type monsters alignment</p><p></p><p>RACE: Green box type race (like Wood Elf, this is miss leading sorry)</p><p></p><p>RACIAL HD: Green box number race HD (Gnolls have 2)</p><p></p><p>RACE: yellow drop down box choose race (Humanoid, Monsters Humanoid, Ooze, this is miss leading again)</p><p></p><p>Light Blue Boxs: select the dark blue boxs of the race you chose, copy and paste them into the light blue boxs.</p><p></p><p>RED BOXs are auto, do not touch.</p><p></p><p>CLASS: yellow drop down, choose PC or NPC class</p><p></p><p>LEVEL: green box type in class lvl (1,or 8 ect.)</p><p></p><p>LIGHT BLUE boxs, paste dark blue boxs for class chosen</p><p></p><p>SIZE: paste dark blue boxs of size chosen into light blue boxs</p><p></p><p>ABILITIES: in green boxs but monster's base abilities (I inputed the elite aray, they can be changed)</p><p></p><p>ABILITIES, Racial Adjustments: green boxs, input racical adjustments (ie. half-orc, +2 STR, -2 INT, -2 CHA) do not put adjustments for size (ie: halfling, -2 STR, this will taken care of by SIZE seclection)</p><p></p><p>SKILLS: skill points alotted are at the bottom of the skills block under each HD or LVL, skill points are ajusted for Racial HD plus Int Modifier (under MONSTER RACIAL HIT DIE), and Class Skill Points are awarded by class LVL plus Int Modifier, x4 at first lvl.</p><p></p><p>Player Sheet</p><p>alto filles from Data Input Sheet </p><p></p><p>Only the GREEN Boxs need info, and at this time any adjustments they make need to hand edited. (Feats like Weapon Focus)</p><p></p><p>I then copy all the filled boxs to a word doc and convert table to text, using para.</p><p></p><p>Format Para (drop down), form mate Left with Hanging .1.</p><p></p><p>Then close up spaces by deleting</p><p></p><p>I hope this understandable.</p></blockquote><p></p>
[QUOTE="Melatuis, post: 5727242, member: 17290"] "That looks like what Nookie was after, and I'm thinking it could be handy for me too - if I can figure out how Excel works. Cleon" I will try explain how the sheet works. On the Data Input sheet NAME: Green box type name of monster SEX: yellow drop down box choose sex ALIGNMENT: Green box type monsters alignment RACE: Green box type race (like Wood Elf, this is miss leading sorry) RACIAL HD: Green box number race HD (Gnolls have 2) RACE: yellow drop down box choose race (Humanoid, Monsters Humanoid, Ooze, this is miss leading again) Light Blue Boxs: select the dark blue boxs of the race you chose, copy and paste them into the light blue boxs. RED BOXs are auto, do not touch. CLASS: yellow drop down, choose PC or NPC class LEVEL: green box type in class lvl (1,or 8 ect.) LIGHT BLUE boxs, paste dark blue boxs for class chosen SIZE: paste dark blue boxs of size chosen into light blue boxs ABILITIES: in green boxs but monster's base abilities (I inputed the elite aray, they can be changed) ABILITIES, Racial Adjustments: green boxs, input racical adjustments (ie. half-orc, +2 STR, -2 INT, -2 CHA) do not put adjustments for size (ie: halfling, -2 STR, this will taken care of by SIZE seclection) SKILLS: skill points alotted are at the bottom of the skills block under each HD or LVL, skill points are ajusted for Racial HD plus Int Modifier (under MONSTER RACIAL HIT DIE), and Class Skill Points are awarded by class LVL plus Int Modifier, x4 at first lvl. Player Sheet alto filles from Data Input Sheet Only the GREEN Boxs need info, and at this time any adjustments they make need to hand edited. (Feats like Weapon Focus) I then copy all the filled boxs to a word doc and convert table to text, using para. Format Para (drop down), form mate Left with Hanging .1. Then close up spaces by deleting I hope this understandable. [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
Spreadsheet
Top