ParanetOnline

The Dresden Files => DFRPG => Topic started by: BabbageCliologic on September 24, 2013, 06:39:10 AM

Title: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 24, 2013, 06:39:10 AM
Hey Folks,

This is my first time posting here but I've been posting over at RPG.net for years and I cross-posted this over there (http://forum.rpg.net/showthread.php?703311-Dresden-Files-RPG-Spellcasting-Spreadsheet-Test-it-for-me!) as well.

I'm running a Dresden Files RPG FAE game for some friends and they're all playing White Council Wardens. Since the magic system is complex, I've come up with a spellcasting spreadsheet that I've put up on Google Drive in a zip file. If you play Dresden Files RPG, I'd appreciate a look-see and any comments you may have.

The zipped file is on Google Drive (https://docs.google.com/file/d/1R_zyb-6NWoU_2tRMLIrnbR53KVnJFoYjcXawLOtKfN8b089grrPaYkU_Kwnl/edit?usp=sharing) and it contains an .xls file (Excel 1997-2004).

I've set up two sheets, one for Evocation and another for Thaumaturgy (another two sheets are list info). Since both need Lore, Discipline and Conviction scores, the info on Evocation is ported directly to Thaumaturgy. The file includes room for Focus Items, the range of Elements and Specialties, and Bonuses. I also included space for the Refinement Power. The final thing I put in was page references for the Dresden Files RPG Volume One: Your Story book.

Any questions, comments or ideas for changes, let me know.

/Matt

The Babbage Cliological Society Asshat Paladins Blog (http://asshatpaladins.blogspot.com/)
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 24, 2013, 08:02:16 PM
One further note: the spreadsheet is protected but not password protected.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 25, 2013, 04:50:35 AM
Tried it out.

Evocation sheet worked well, but it looks like you can only use one focus. That could be a problem for people who use one focus for power and one for control.

Thaumaturgy sheet had some issues. It assumed the base duration was instant, leading to unreasonably high complexities. Also it seemed to think that Crafting was a type of ritual, and it used a base stress cost of 1 instead of 0. The one-focus thing seemed to be present here as well.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 25, 2013, 06:16:30 AM
Tried it out.

Thanks!

Evocation sheet worked well, but it looks like you can only use one focus. That could be a problem for people who use one focus for power and one for control.

OK, I'll add a second focus item slot in the calculation line.

Thaumaturgy sheet had some issues. It assumed the base duration was instant, leading to unreasonably high complexities.

I'll double check but I set up the persistence (duration) of the spell to range from instant to several mortal lifetimes. The duration value changes as a result, increasing the complexities.

Also it seemed to think that Crafting was a type of ritual,

The Crafting Bonuses don't add to Complexity or Control, instead to Frequency or Strength.

and it used a base stress cost of 1 instead of 0.

As I understand it, minimum Stress for spellcasting  is always 1, never 0.

The one-focus thing seemed to be present here as well.

I'll add that one as well.

Thanks for looking it over.

/M
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 25, 2013, 07:35:07 AM
I'll double check but I set up the persistence (duration) of the spell to range from instant to several mortal lifetimes. The duration value changes as a result, increasing the complexities.

It mostly works correctly. But the "zero value" shouldn't be instant. Going by YS266, the zero value can vary but until the next sunrise is a good default.

The Crafting Bonuses don't add to Complexity or Control, instead to Frequency or Strength.

I think the spreadsheet lets you select Crafting when designing a ritual, though.

As I understand it, minimum Stress for spellcasting  is always 1, never 0.

According to YS271, not so.

PS: We have a Downloads thread here on the forum and a Downloads page on the wiki. Want this on those?
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: PirateJack on September 25, 2013, 10:03:04 PM
Thaumaturgy doesn't cause stress as default. It's the major difference between it and evocation because you don't have time to carefully prepare the spell when using evocation.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 26, 2013, 01:47:56 PM
Working on a number of changes mentioned here and hope to post a revised version today or tomorrow.

/Matt
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 26, 2013, 01:50:52 PM
PS: We have a Downloads thread here on the forum and a Downloads page on the wiki. Want this on those?

Can we wait until the revs have been made?

/M
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 27, 2013, 12:59:28 AM
Sure, take all the time you need. I'm not going anywhere.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Todjaeger on September 27, 2013, 05:04:23 AM
It mostly works correctly. But the "zero value" shouldn't be instant. Going by YS266, the zero value can vary but until the next sunrise is a good default.

I usually have the default duration of a ritual spell set at A Scene/15 minutes, with Wards and other similar type ritual spells having a default starting duration of A Day/until the next sunrise.  If you read through YS266, it does suggest the 'default' duration for a few things (namely Wards and Curses on Locations) having a starting duration of A Day.  However, something like a spell which provides/causes a Temporary Aspect to be on a living thing (ex. Bad Luck) would only last about 15 minutes.

-Cheers
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 27, 2013, 06:39:36 AM
Hey Folks,

I've made a few changes but I'm not done yet:

* Added a Wizard Info page that all the pages read from. These include Lore, Discipline, Conviction, Elements, Specialties, and Focus Items.

* Added 2nd Focus Item on Evocation and Thaumaturgy pages.

* Set up Duration Types (Typical, Scene and Instant) on Thaumaturgy page. Typical = next sunrise (0), Scene = 15 minutes (0) and Instant = instant (0). That will give the player a chance to discuss it with the GM about which is appropriate.

* Added a Crafting page with space for Enchanted Items.

I have to check some things out but I hope to post it tomorrow or by this weekend.

/Matt
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 28, 2013, 06:24:34 AM
I've updated the spreadsheet to include more information.

The updated zipped file is on Google Drive (https://docs.google.com/file/d/1R_zyb-6NWoU_2tRMLIrnbR53KVnJFoYjcXawLOtKfN8b089grrPaYkU_Kwnl/edit?usp=sharing) and it contains an .xls file (Excel 1997-2004).

I put in page references for the Dresden Files RPG Volume One: Your Story book and provided instructions for each page.

Character information is placed on the Wizard's Info page. This page also includes spaces for Skills (Lore, Discipline and Conviction) scores, the range of Elements and Specialties and bonuses, Focus Items (for both Evocation, Thaumaturgy and Crafting), Focus Item and Enchanted Item Slots, Focus Item bonus data and Refinement Powers.

The Evocation and Thaumaturgy pages have the spell generation processes and refers to the Wizard's Info.

The Crafting page has space for up to eight enchanted items and allows users to select potion slots.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 28, 2013, 09:30:01 AM
Downloaded.

Looks better but I'm still having some problems with items. The sheet doesn't seem to want me to share slots between Evocation and Thaumaturgy, and when I tried to include focus bonuses in a spell it didn't work.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: dplanken on September 28, 2013, 03:11:50 PM
I can't seem to get the file in one piece :( When downloaded it claims it has unreadable content and rapes the data.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 28, 2013, 03:49:15 PM
Downloaded.

Looks better but I'm still having some problems with items. The sheet doesn't seem to want me to share slots between Evocation and Thaumaturgy, and when I tried to include focus bonuses in a spell it didn't work.

Hmmm, I set up Focus Items to be specific to either Evocation or Thaumaturgy/Crafting and don't mix between the two. I'll reread Crafting on YS278-282 and see if I can improve the sheet.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 28, 2013, 04:59:38 PM
I can't seem to get the file in one piece :( When downloaded it claims it has unreadable content and rapes the data.

Did you use the link I posted yesterday? I deleted the previous versions.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 29, 2013, 06:17:05 AM
Hmmm, I set up Focus Items to be specific to either Evocation or Thaumaturgy/Crafting and don't mix between the two. I'll reread Crafting on YS278-282 and see if I can improve the sheet.

That's not really the problem. The problem is that the sheet doesn't seem to want to let me use the focus slots I get from Evocation on Thaumaturgy and vice versa.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 29, 2013, 08:52:06 AM
That's not really the problem. The problem is that the sheet doesn't seem to want to let me use the focus slots I get from Evocation on Thaumaturgy and vice versa.

Sorry, I don't read that option in the text. According to YS278, Evocation Focus Items only work for Evocation and Thaumaturgy Focus Items only work for Thaumaturgy.

YS278, second column, 2nd, 3rd and 4th paragraphs, specifically the paragraphs that begin with and contain "For evocation focuses...." and "For thaumaturgy focuses...." and "Additionally, you must specify which type of evocation or thaumaturgy is enhanced by the item's bonus."
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 29, 2013, 10:25:54 AM
I don't think we're talking about the same thing. Because I don't see how that page is relevant.

I think I can explain what I'm talking about better with an example. Look at Harry's example stats on page 67 of YS. Harry has Evocation, Thaumaturgy, and no Refinements. 3 of his 4 focus slots have been spent on Evocation foci. At least one of those slots must have come from Thaumaturgy.

The sheet should allow that.

Sorry if I was unclear earlier.
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 29, 2013, 04:38:59 PM
I don't think we're talking about the same thing. Because I don't see how that page is relevant.

I think I can explain what I'm talking about better with an example. Look at Harry's example stats on page 67 of YS. Harry has Evocation, Thaumaturgy, and no Refinements. 3 of his 4 focus slots have been spent on Evocation foci. At least one of those slots must have come from Thaumaturgy.

The sheet should allow that.

Sorry if I was unclear earlier.

Ah, OK, that makes sense. Thanks for the clarification.

I'll make the change in the next version and probably put that on the Wizard Info page.

/M

Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on September 30, 2013, 02:57:48 AM
Here's the updated spreadsheet with the combined Focus Items pool to draw from.

Download the zipped file from Google Drive (https://docs.google.com/file/d/1R_zyb-6NWoU_2tRMLIrnbR53KVnJFoYjcXawLOtKfN8b089grrPaYkU_Kwnl/edit?usp=sharing).
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on September 30, 2013, 06:35:48 AM
Should I add it to the list now?
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: BabbageCliologic on October 01, 2013, 05:38:58 AM
Should I add it to the list now?

If there are no more corrections to be made in your opinion, sure. I think it works pretty well.

/Matt
Title: Re: Spellcasting Spreadsheet -- Test it for me!
Post by: Sanctaphrax on October 01, 2013, 08:16:31 AM
Aight. Doing that now.