Has anyone took the effort to make a monster spreadsheet - so we can easily answer questions like "what is the mode AC for humanoid monsters of CR 1?" Or, "what is the mode bonus to Wisdom saves for Abominations between CR 5 and CR 7?" That kind of thing?
I do not have access to the digital MM, but this sounds like a great feature for filtering lists of monsters if it's not a feature already. (I haven't done anything with encounter building, either. It might already be there.)
Rollback Post to RevisionRollBack
Human. Male. Possibly. Don't be a divider. My characters' backgrounds are written like instruction manuals rather than stories. My opinion and preferences don't mean you're wrong. I am 99.7603% convinced that the digital dice are messing with me. I roll high when nobody's looking and low when anyone else can see.🎲 “It's a bit early to be thinking about an epitaph. No?” will be my epitaph.
As a stats fan, when the time comes for me to start DMing again, which may be a long way off, I would love a tool like this. I wouldn’t use it or check it while being just a player (to avoid spoilers) but as a DM, it would be quite useful.
Rollback Post to RevisionRollBack
WOTC lies. We know that WOTC lies. WOTC knows that we know that WOTC lies. We know that WOTC knows that we know that WOTC lies. And still they lie.
Because of the above (a paraphrase from Orwell) I no longer post to the forums -- PM me if you need help or anything.
I did it for the beasts that my Circle of the Moon Druid can Wild Shape into and the Fey that he can summon and yes, it’s a lot of work. I’ll never do it for anything more than a small sub set of monsters for a specific purpose!
It could be done programmatically. Using Excel, VBA, and a little JavaScript you can scrape data from a website. It essentially would be a data mining tool that scrapes data directly from the HTML. I just tested it to make sure it would work and it does. You'd still need to own the source material on DnD Beyond for it to work.
It's complicated work but it's doable. It would be much much faster than manually entering all the data.
It could be done programmatically. Using Excel, VBA, and a little JavaScript you can scrape data from a website. It essentially would be a data mining tool that scrapes data directly from the HTML. I just tested it to make sure it would work and it does. You'd still need to own the source material on DnD Beyond for it to work.
It's complicated work but it's doable. It would be much much faster than manually entering all the data.
Scrapers don't usually work, they are supposed to be blocked.
Not sure why it worked for you. Maybe it only works with SRD content? Try it on something behind a pay wall.
*scratches head* how would you even go about blocking scrapers? If you can sit the HTML in your local browser, you ought to be able to scrape it. Its just a bit stream.
It could be done programmatically. Using Excel, VBA, and a little JavaScript you can scrape data from a website. It essentially would be a data mining tool that scrapes data directly from the HTML. I just tested it to make sure it would work and it does. You'd still need to own the source material on DnD Beyond for it to work.
It's complicated work but it's doable. It would be much much faster than manually entering all the data.
Scrapers don't usually work, they are supposed to be blocked.
Not sure why it worked for you. Maybe it only works with SRD content? Try it on something behind a pay wall.
It works for everything I've tried in the MM. Oddly enough it didn't work for Volos. It's possible they have something set up to stop scraping for Volos. They might be protecting it but I don't know why Volos would be protecting it and they wouldn't with the MM. It might bea bug or oversight on their part. I think it's more likely that the HTML is formatted differently in Volos and I only have it set up to work on the format of the MM. Just eyeballing it super fast it looks the same though so who knows.
*scratches head* how would you even go about blocking scrapers? If you can sit the HTML in your local browser, you ought to be able to scrape it. Its just a bit stream.
I think it had to do with detecting bot like browsing patterns and hitting them with captchas. Or it could have to do with blocking access to certain types of data. I don't actually know how scrapers work or how they are blocked, I just remember hearing or reading that they were blocked.
It works for everything I've tried in the MM. Oddly enough it didn't work for Volos. It's possible they have something set up to stop scraping for Volos. They might be protecting it but I don't know why Volos would be protecting it and they wouldn't with the MM. It might bea bug or oversight on their part. I think it's more likely that the HTML is formatted differently in Volos and I only have it set up to work on the format of the MM. Just eyeballing it super fast it looks the same though so who knows.
That's hilarious! It just so happened that the 15 or so things I tried were all free. I even tried to pick weird ones but I guess I have no idea what is free and what isn't. You figured it out!
I am fairly certain that it is possible to have Excel log in to a secure site though. That should enable me to scrape it.
Has anyone took the effort to make a monster spreadsheet - so we can easily answer questions like "what is the mode AC for humanoid monsters of CR 1?" Or, "what is the mode bonus sip calculatorcrossword solverepfo to Wisdom saves for Abominations between CR 5 and CR 7?" That kind of thing?
I just tested it to make sure it would work and it does. You'd still need to own the source material on DnD Beyond for it to work.
Has anyone took the effort to make a monster spreadsheet - so we can easily answer questions like "what is the mode AC for humanoid monsters of CR 1?" Or, "what is the mode bonus to Wisdom saves for Abominations between CR 5 and CR 7?" That kind of thing?
I don't believe anyone has. Data mining tools are blocked, so this would have to be done manually, and that is a lot to do manually.
I do not have access to the digital MM, but this sounds like a great feature for filtering lists of monsters if it's not a feature already. (I haven't done anything with encounter building, either. It might already be there.)
Human. Male. Possibly. Don't be a divider.
My characters' backgrounds are written like instruction manuals rather than stories. My opinion and preferences don't mean you're wrong.
I am 99.7603% convinced that the digital dice are messing with me. I roll high when nobody's looking and low when anyone else can see.🎲
“It's a bit early to be thinking about an epitaph. No?” will be my epitaph.
As a stats fan, when the time comes for me to start DMing again, which may be a long way off, I would love a tool like this. I wouldn’t use it or check it while being just a player (to avoid spoilers) but as a DM, it would be quite useful.
WOTC lies. We know that WOTC lies. WOTC knows that we know that WOTC lies. We know that WOTC knows that we know that WOTC lies. And still they lie.
Because of the above (a paraphrase from Orwell) I no longer post to the forums -- PM me if you need help or anything.
I found this http://www.giantitp.com/forums/showthread.php?562144-D-amp-D-5e-MM-Monster-Defences-(AC-vs-Saving-Throws)
I did it for the beasts that my Circle of the Moon Druid can Wild Shape into and the Fey that he can summon and yes, it’s a lot of work. I’ll never do it for anything more than a small sub set of monsters for a specific purpose!
Professional computer geek
It could be done programmatically. Using Excel, VBA, and a little JavaScript you can scrape data from a website. It essentially would be a data mining tool that scrapes data directly from the HTML. I just tested it to make sure it would work and it does. You'd still need to own the source material on DnD Beyond for it to work.
It's complicated work but it's doable. It would be much much faster than manually entering all the data.
Scrapers don't usually work, they are supposed to be blocked.
Not sure why it worked for you. Maybe it only works with SRD content? Try it on something behind a pay wall.
*scratches head* how would you even go about blocking scrapers? If you can sit the HTML in your local browser, you ought to be able to scrape it. Its just a bit stream.
It works for everything I've tried in the MM. Oddly enough it didn't work for Volos. It's possible they have something set up to stop scraping for Volos. They might be protecting it but I don't know why Volos would be protecting it and they wouldn't with the MM. It might bea bug or oversight on their part. I think it's more likely that the HTML is formatted differently in Volos and I only have it set up to work on the format of the MM. Just eyeballing it super fast it looks the same though so who knows.
I think it had to do with detecting bot like browsing patterns and hitting them with captchas. Or it could have to do with blocking access to certain types of data. I don't actually know how scrapers work or how they are blocked, I just remember hearing or reading that they were blocked.
A lot of MM monsters are also free. Try something like adult blue dracolich.
That's hilarious! It just so happened that the 15 or so things I tried were all free. I even tried to pick weird ones but I guess I have no idea what is free and what isn't. You figured it out!
I am fairly certain that it is possible to have Excel log in to a secure site though. That should enable me to scrape it.
I don't know how to scrape with Excel. I'd use XSLT and C#. But, I'd have no trouble scraping from that Adult Blue Dracolich page.
I just tested it to make sure it would work and it does. You'd still need to own the source material on DnD Beyond for it to work.
I think what you are looking for is this. Monster Spreadsheet