I wasn't sure what to title this, but I've been working on an excel spreadsheet that contains information about not only wads, but the maps within those wads. I wanted a way to be able to quickly load up maps by a particular author, or in a particular series.
(I used excel because I have to do vba stuff for school, and this seemed like a good way to work my way through it. I know it's not a perfect solution for this type of thing, but eh, it works for now and is within my ability.)
How this works:
1) Click the button in the "Main" tab to search for map criteria (implemented to check the map tab only, and far from perfect, see below) in order to generate a list of maps.
2) This list copied into a "results" tab, which you can then order or adjust as you like.
3) Press the "generate batch file" button on the main tab and that creates a list of batch files.
4) Copy into a text file and run as a batch. (Assuming you have correctly inputted your port path and skill level on the "main" tab.)
To run a series like the Odessa series, for example, you would search for all the Odessa maps, and the batch file will automatically load each wad appropriately and direct you to the correct map.)
Things I'm still working on:
More maps / wads. At the moment, there are only 180 wads and ~2750 individual maps. There are obviously thousands more maps, if not wads, to go. I should also probably include vanilla / limit removing compatibility (as well as other source port specific stuff).
Better search functionality. Searching the wads as well.
Better implementation of port selection.
How to use the search:
Searching currently only filters the map tab - just type in whatever you want to the search box and it will filter based on that. It looks for inclusion, not exact matches. So doom would match to doom, doom 2, doom the way id did, etc. You can be more specific by using "" ie. "doom the way id did" would only find those maps.
You can use - to filter your results. ie ("ultimate doom" -romero) would result in all the ultimate doom maps that romero did not do.
You can use + to force a field. ie ("doom 2" + romero) would only result in the "doom 2" matches that romero is involved in.
You can use +/- with "", but you need to enclose the +/- inside the quotes. ie. "+doom 2"
Anyway... still working on it, but figured it was decent enough to toss out there.
Download link: http://s000.tinyupload.com/index.ph...990283184777582
(I'm using Excel 2013. I have no idea if this works in previous versions. If you do test it out in an earlier version and it works / doesn't work, let me know.)
edit: I forgot to mention that the batch info that is generated works under the assumption that the batch file is in the parent folder, and that the parent folder contains all the wads. I have my own file structure for storing wads, but as I work through them to add them to this db, I copy the .wad file into a separate folder where I store the batch.
EDIT: An important assumption that is made with the batch files is that the wads are all stored in a single directory (at least the ones that you are referencing), AND that a sub-directory holds the ports.
In other words, to get this working I have copied out wads into a DoomWads folder, and inside of that folder have placed my port installs. You could also use shortcuts I think. So far if you include all the listed wads and the three source ports, the directory is about 4 gigs.
Last edited by 7hm on 12-01-14 at 05:27