Zook,
i fiddled around in excel and indexed all spells in your file
i also made it filterable by class (it's not the prettiest way, but it works as far as i can tell)
check your PM
-Selie
EDIT:
looking at the class filter right now and i'm seeing a lot of possible errors, will be working on the VBA a little and i'll get back to y'all on that.
EDIT EDIT:
i think it's complete, ran into a boat load of misinput in the previous file, but now i think i'm getting either close to done, or done entirely.
Excel file is now filterable by class/ level, components, school, etc.
EDIT EDIT EDIT:
i'm still cleaning the file up while i have some spare time left.
making things like "Close (25ft. + 5ft / 2 CL.)" uniform so it doesn't show up 25 times in the filter with an extra space or a missing '.'