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
The
VOIDRUNNER'S CODEX
is coming! Explore new worlds, fight oppressive empires, fend off fearsome aliens, and wield deadly psionics with this comprehensive boxed set expansion for 5E and A5E!
Community
Playing the Game
Play by Post
Living Worlds
Living 4th Edition
New Wiki Working Group
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="weldon" data-source="post: 4982092" data-attributes="member: 18817"><p>The google doc spreadsheet is coming along. There's a lot that can be done with the math. Here is a view-only link to the sheet...</p><p></p><p><a href="https://spreadsheets.google.com/ccc?key=0Avus1s5lh50BdGVka2ZHZHhTR0oxOHFOYWdGajRveHc&hl=en" target="_blank">https://spreadsheets.google.com/ccc?key=0Avus1s5lh50BdGVka2ZHZHhTR0oxOHFOYWdGajRveHc&hl=en</a></p><p></p><p>Because of the way that protecting the sheet from changes works, I have been rethinking how it would be used with judges. Here's how I think it would work...</p><p></p><ul> <li data-xf-list-type="ul">Create a "submission" form for players to fill out with all the relevant scores. This form populates a new row in a spreadsheet with all the "raw" scores for that PC.</li> <li data-xf-list-type="ul">This sheet and the template belongs to the l4w.judges google account so that they can be managed by any judge.</li> <li data-xf-list-type="ul">The first judge creates a new copy of the "checker" template which does all the math and creates a sheet for judges to compare to the character sheet in the wiki. This checker sheet would be created for each level review for a character.</li> <li data-xf-list-type="ul">The first judge then copies the raw scores from the submission form into the checker sheet, which then does all the math automagically and calculates the final scores.</li> <li data-xf-list-type="ul">The first judge shares the "checker" sheet so that player's can view (but not edit) the sheet the judge is using to double-check math. This link can be inserted into the judge's approval comments in the wiki too.</li> <li data-xf-list-type="ul">The second judge reviews the link to the checker sheet and also compares to the wiki page.</li> </ul><p></p><p>I think this process provides the right amount of control for judges to be certain that no one has changed the math, either by accident or design. It also gives players an easy way to fill out the basic info for judges to plug into the checker. And everything is linked to the existing gmail account that the judges use for email notices about character submissions. They can share the finished sheets view-only and provide a URL that anyone at L4W can see what is going on, so the process is still transparent.</p><p></p><p>The disadvantage over the current method is that it is external to the ENworld site. This process also relies on the judges to perform a few extra steps that will take 5-10 minutes for each character review.</p><p></p><p>What do you think?</p></blockquote><p></p>
[QUOTE="weldon, post: 4982092, member: 18817"] The google doc spreadsheet is coming along. There's a lot that can be done with the math. Here is a view-only link to the sheet... [url]https://spreadsheets.google.com/ccc?key=0Avus1s5lh50BdGVka2ZHZHhTR0oxOHFOYWdGajRveHc&hl=en[/url] Because of the way that protecting the sheet from changes works, I have been rethinking how it would be used with judges. Here's how I think it would work... [LIST] [*]Create a "submission" form for players to fill out with all the relevant scores. This form populates a new row in a spreadsheet with all the "raw" scores for that PC. [*]This sheet and the template belongs to the l4w.judges google account so that they can be managed by any judge. [*]The first judge creates a new copy of the "checker" template which does all the math and creates a sheet for judges to compare to the character sheet in the wiki. This checker sheet would be created for each level review for a character. [*]The first judge then copies the raw scores from the submission form into the checker sheet, which then does all the math automagically and calculates the final scores. [*]The first judge shares the "checker" sheet so that player's can view (but not edit) the sheet the judge is using to double-check math. This link can be inserted into the judge's approval comments in the wiki too. [*]The second judge reviews the link to the checker sheet and also compares to the wiki page. [/LIST] I think this process provides the right amount of control for judges to be certain that no one has changed the math, either by accident or design. It also gives players an easy way to fill out the basic info for judges to plug into the checker. And everything is linked to the existing gmail account that the judges use for email notices about character submissions. They can share the finished sheets view-only and provide a URL that anyone at L4W can see what is going on, so the process is still transparent. The disadvantage over the current method is that it is external to the ENworld site. This process also relies on the judges to perform a few extra steps that will take 5-10 minutes for each character review. What do you think? [/QUOTE]
Insert quotes…
Verification
Post reply
Community
Playing the Game
Play by Post
Living Worlds
Living 4th Edition
New Wiki Working Group
Top