GURPS Spell list in xls

mrtauntaun · 02-16-2009, 08:10 AM

Hi Guys. I need to rearrage the spells into new colleges for my campaign, do you know of any 4e spell lists in excel or some other easily editable format? I'd like to just see spell name and college in a column, that way I can go right down and change them.
I've tried editing the core GCA files, but those text files are a pain to edit this way. I'd just like something simple, for reference. I tried a forum search and didn't see one. I've found a few 3e ones online, but I'd like 4e if possible.

Thanks!

Diomedes · 02-16-2009, 08:22 AM

I have one I could email to you if you like.

mrtauntaun · 02-16-2009, 08:32 AM

I would love that, thanks. I'll PM you.

Huyderman · 02-16-2009, 08:37 AM

I started making one in xml, can't remember how far I came. The idea was at least to make it easy to rearrange and create sublists, as well as automagically create prerequisite trees. But my attentionspan failed. :p

jacobmuller · 02-16-2009, 12:10 PM

create it as a table in Word first and when you have everything where you want it to be, copy the table into excel to do the sorting.
Definitely a labour of love.

Dantar · 02-16-2009, 03:17 PM

Gurps Character Sheet is an open source character sheet program. You can view the list of spells and sort them by category. Maybe that'd help?

thulben · 02-16-2009, 08:11 PM

Quote:

Originally Posted by Dantar

Gurps Character Sheet is an open source character sheet program. You can view the list of spells and sort them by category. Maybe that'd help?

This. I just looked at the library file distributed with this program and the spells are all there in delicious XML. Roll up your sleeves, write a custom parser, and go nuts.

lazarwolfe · 01-11-2010, 07:22 PM

So, has anyone done this?
All I need is a table with a list of prerequisites

Mailanka · 01-11-2010, 07:28 PM

Quote:

Originally Posted by lazarwolfe

So, has anyone done this?
All I need is a table with a list of prerequisites

I personally find prerequisite count to be alot more useful, as it makes rearranging your spell charts much easier.

Ulthar88 · 09-29-2011, 02:07 PM

googling about for just such a thing when I found this thread... and the following spreadsheet

http://sites.google.com/site/nathanshomepage/Home/gurps

I don't know yet how complete or accurate it is, but looks to save me a ton of time, thanks to Nathan Whoever-he-may-be.

02-16-2009, 08:10 AM	#1
mrtauntaun Join Date: Jan 2008	GURPS Spell list in xls Hi Guys. I need to rearrage the spells into new colleges for my campaign, do you know of any 4e spell lists in excel or some other easily editable format? I'd like to just see spell name and college in a column, that way I can go right down and change them. I've tried editing the core GCA files, but those text files are a pain to edit this way. I'd just like something simple, for reference. I tried a forum search and didn't see one. I've found a few 3e ones online, but I'd like 4e if possible. Thanks!

02-16-2009, 08:22 AM	#2
Diomedes Join Date: Mar 2008 Location: Dallas, TX	Re: GURPS Spell list in xls I have one I could email to you if you like.

02-16-2009, 08:32 AM	#3
mrtauntaun Join Date: Jan 2008	Re: GURPS Spell list in xls I would love that, thanks. I'll PM you.

02-16-2009, 08:37 AM	#4
Huyderman MIB Join Date: Aug 2004 Location: Oslo, Norway	Re: GURPS Spell list in xls I started making one in xml, can't remember how far I came. The idea was at least to make it easy to rearrange and create sublists, as well as automagically create prerequisite trees. But my attentionspan failed. :p __________________ Johannes Huyderman aka. Jo-Herman Haugholt Geek and Discordian MiB#0505 http://www.huyderman.com/

02-16-2009, 12:10 PM	#5
jacobmuller Join Date: Feb 2006 Location: Not in your time zone:D	Re: GURPS Spell list in xls create it as a table in Word first and when you have everything where you want it to be, copy the table into excel to do the sorting. Definitely a labour of love. __________________ "Sanity is a bourgeois meme." Exegeek PS sorry I'm a Parthian shootist: shiftwork + out of country = not here when you are:/ It's all in the reflexes

02-16-2009, 03:17 PM	#6
Dantar Join Date: Nov 2007 Location: USA	Re: GURPS Spell list in xls Gurps Character Sheet is an open source character sheet program. You can view the list of spells and sort them by category. Maybe that'd help? __________________ _____________________________________ _____________________________________

01-11-2010, 07:22 PM	#8
lazarwolfe Join Date: Jan 2010	Re: GURPS Spell list in xls So, has anyone done this? All I need is a table with a list of prerequisites

09-29-2011, 02:07 PM	#10
Ulthar88 Join Date: May 2011 Location: high desert plains	Re: GURPS Spell list in xls googling about for just such a thing when I found this thread... and the following spreadsheet http://sites.google.com/site/nathanshomepage/Home/gurps I don't know yet how complete or accurate it is, but looks to save me a ton of time, thanks to Nathan Whoever-he-may-be.