Spreadsheets, etc. listing DFRPG spells?

[tbone]

Hi all. There are a couple of things I'd be interested in having or making for personal use, but which I suspect someone has already made available. (No luck yet in finding these on fan sites, or noted in the DFRPG Resources sub-forum.)

1) List of spells
The same sort of master list found in Spells itself, but in text file or spreadsheet form.

2) List of wizardly spells available by Magery level
A cleric or druid player can look at Spells and say "okay, with my PI 2, these are the spells I can choose." Wizards can't do that. Prerequisite chains make selection more complicated, of course, but it'd still be useful to have a handy list telling wizards (and elves/half-elves) what's (potentially) available at each level of Magery. Is there already a list floating around out there?

Thanks -

[DaosusLeghki]

I wouldn't feel comfortable posting such a spreadsheet online, but you can make your own with a copy-paste and a few minutes of editing.

[tbone]

Originally Posted by DaosusLeghki

I wouldn't feel comfortable posting such a spreadsheet online, but you can make your own with a copy-paste and a few minutes of editing.

Unfortunately, copy-paste from PDF tables often results in a mess, and experimentation suggests that the table in Spells is no exception. Oh well!

[Celjabba]

Originally Posted by tbone

Unfortunately, copy-paste from PDF tables often results in a mess, and experimentation suggests that the table in Spells is no exception. Oh well!

It is not fast but I had good result with :

Selection by column (using alt) in the PDF
copy/paste in a text file to delete the unwanted line feed
copy/paste to excel

repeat for each column / each page

then split of the prerequisites column on • and a bit of sorting

[tbone]

Originally Posted by Celjabba

Selection by column (using alt) in the PDF
copy/paste in a text file to delete the unwanted line feed
copy/paste to excel

I had been trying that sort of column-by-column work, but still without good results.

Reading your message, though, I decided to give it another try, experimenting with different combinations of software. I hit upon a combo that works well enough. There's still some cleanup required, but I think I'll have my spreadsheet without too much trouble. Thanks!