Full spell list

[PlzBreakMyCampaign]

I take it you don't use excel. Don't duplicate the work. You already having a list of all spells that the various classes can cast, it's just not formatted correctly.

All we have to do is split up the cell that contains all the casting lists with their level and voila it becomes another sortable criteria. I guess I'll go whore for some excel macro help in Q&A...

[zook1shoe]

Never really needed it before. My wife does, and had to help when making a chart about selling my car

[KellKheraptis]

-casts Raise Thread-

Got a question : I have a couple freebie subdomains knocking around, and as long as these don't exceed bandwidth limits when put up as a post/table, I could probably convert the entirety of the xls files into a searchable database within a WordPress install.  If this would be a helpful resource (and I would nofollow and noindex the unholy fuck out of it to prevent Google from seeing it, and by extension, the Edition Nazis that nuked dndtools), let me know and I'll see about building it.

[zook1shoe]

Sure.... I haven't touched 3.x in awhile. PFS is what's going on right now. But might jump into an old pvp gladiator reboot

[nijineko]

Sure.... I haven't touched 3.x in awhile. PFS is what's going on right now. But might jump into an old pvp gladiator reboot

interesting. no one i game with will touch pathfinder. they pick 3.x over pathfinder every time that discussion comes up. despite that i've mentioned it a couple of times to at least try it out, no one is interested.

[KellKheraptis]

That being said, PlzBreakMyCampaign can you PM me the most recent versions of the xls files?  I've already got the subdomain put together with a decent responsive theme on WordPress - just need to start the process of porting content (and seeing how I want to do the sorting - most likely by tag and category).

[zook1shoe]

if i want human interaction in a town i have little human contact with.... i had to go PFS.

had a couple 3.x groups that collapsed a couple years ago

[The_Laughing_Man]

I created .csv version from the Captnq's THE SPELL BOOK days back, that maybe useful to you. At least I've had fun with it

[PlzBreakMyCampaign]

That being said, PlzBreakMyCampaign can you PM me the most recent versions of the xls files?  I've already got the subdomain put together with a decent responsive theme on WordPress - just need to start the process of porting content (and seeing how I want to do the sorting - most likely by tag and category).

I hope you're happy with yourself: I just poured another 8 hours into the thing. I rewrote the entire macro that I couldn't get much help with. Then I wrote a cleanup one. I tested each entry after redoing the original sort several times. Ug what a load of work. So PM me with instructions on getting this to you.

In my opinion, WotC needs to make crunch entries in a spreadsheet format natively if they want to be taken seriously. How else is someone going to instantly know all the xth level things for class y and z?

Edit: wordpress? Why would you want it in any other format besides a spreadsheet?

[KellKheraptis]

That being said, PlzBreakMyCampaign can you PM me the most recent versions of the xls files?  I've already got the subdomain put together with a decent responsive theme on WordPress - just need to start the process of porting content (and seeing how I want to do the sorting - most likely by tag and category).

I hope you're happy with yourself: I just poured another 8 hours into the thing. I rewrote the entire macro that I couldn't get much help with. Then I wrote a cleanup one. I tested each entry after redoing the original sort several times. Ug what a load of work. So PM me with instructions on getting this to you.

In my opinion, WotC needs to make crunch entries in a spreadsheet format natively if they want to be taken seriously. How else is someone going to instantly know all the xth level things for class y and z?

Edit: wordpress? Why would you want it in any other format besides a spreadsheet?

WordPress - index and categorize all the things.  Anything you can do in Excel/Calc, you can do better with the wizardry of Taxonomy

[PlzBreakMyCampaign]

So it can check inside cells for a certain row and then output the minimum or maximum single number it found? That would be very useful for finding spell level ranges.

PS. I'm done on the cleanup side, although I don't fully trust A) the original source (some mistakes) B) my massive data input into excel and C) my softing. I mean, I can't find any more mistakes, but I have slight suspicions.

[sollyus]

I'm preparing the spell list to be inserted in a database, and making the adjustments are taking a long time...

So, I've found more than 200 spells (268 to be precise) contained in the Captnq's THE SPELL BOOK and not contained in the zook1shoe's Spell list.
Including basic spells like Bull's Strength. Can anyone confirm that I'm not confusing things? I'm asking because it seems a bit odd...

Also, Kelgore's Fire Bolt was wrongly named as "Kelgore's Fire Mist".

[zook1shoe]

here is a refresh for the link to my dropbox

figured after a few years, i should re-upload them. i haven't touched them since

[sollyus]

here is a refresh for the link to my dropbox

figured after a few years, i should re-upload them. i haven't touched them since

Shouldn't this zip contain the spellsV5 file?

[zook1shoe]

I'll check it out during the day

[zook1shoe]

the "All" one is the v5.0

[the_dark_wad]

Hmmm, are you sure that this is the full document? The "All" file you mentioned is only a page long...

In any case, do you happen to have a key for what abbreviations you are using for which books? I'm trying to track down some spells in "PGSL", but I can't figure out what book PGSL is!

[Stratovarius]

PGSL is Kingdom of Kalamar's Player's Guide to the Sovereign Lands

[zook1shoe]

i haven't re-uploaded this in a year and the previous one was 2014

i'll update the link on the 1st post

[Nunkuruji]

Link is broken again