• Advertisement

Make a small donation to Ye Olde Inn!

Donate via Paypal

Every cent received goes toward Ye Olde Inn's maintenance and allows us to continue providing the best resources for HeroQuest and Fantasy Gaming fans.

Questimator - An Excel and VBA-based difficulty approximator

Have a HeroQuest related project and need community assistance? Create a thread about your project here and the type of aid you require. Other community members searching this room may be able to assist, or join you on your adventure.

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Count Mohawk » Friday January 29th, 2016 4:02pm

Just you wait, Excel junkies. I'm reasonably sure the Excel version is 90-95% caught up with the VBA version, but there are so many bugs and errors to catch that it's taking forever!!
Image
The above image is about how far I've got so far. No link yet; that comes later. Back to coding!
Image


Rewards:
Grin's Stone Map Created a Hot Topic. Shattered a Skeleton! Destroyed a Zombie! Crushed a powerful Chaos Warrior! Smashed a massive Gargoyle!
User avatar
Marquis of Math
Count Mohawk

Elven Warrior
Elven Warrior
 
Posts: 662
Joined: Thursday July 11th, 2013 5:18pm
Location: New England, USA
Forum Language: English (United States)
Evil Sorcerer: Zargon
Hero:
Usergroups:
Champion Group Member

Advertisement

Ye Olde Inn is proudly hosted by

Proudly Hosted by MDD Hosting

Host your Website at MDD Hosting by clicking the logo above and Ye Olde Inn will receive a commission that we'll put toward keeping Ye Olde Inn online for everyone to enjoy!

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Anderas » Sunday January 31st, 2016 9:27am

Looks good :)

I will not continue on this topic. Not sufficient time, sorry! The more i appreciate your work on this!


Some feedback in case you want it. If not, don't read it :)

hard failures:

* a secret door across a hallway (doors across hallways - ok. Secret doors across hallways - nok)
* A door ending in a blocked field
* A door in the middle of a room

Suggestions:
* A room filled to more than 50%; the small 3x2 Room. That's of course possible, but i would consider that a style error, except exceptions :)
* No entry nor exit (maybe that one door at the blocked square was intended as entry?)
* Tree structure labyrinth with lots of branches (again, this is possible but shall be considered part of the story; e.g. as option tickbox or such. Options could be: Loops or not? Main way with Branches, and how many? "Bush" labyrinth without main way?)
* No furniture, double doors or other more-than-one-field stuff (i guess that is on the worklist?)


Rewards:
Hosted a Play-by-Post game. Played a turn in a Play-by-Post game. Created a Hot Topic. Participated in four (4) Miniature Exchanges. Zealot Miniatures: Twisting Catacombs Kickstarter Backer Destroyed a Zombie! Encountered a menacing Chaos Warlock!
User avatar
Anderas
NOT Andreas!

Yeti
Yeti
 
Posts: 2827
Images: 33
Joined: Saturday September 20th, 2014 7:02am
Forum Language: British English
Evil Sorcerer: Morcar
Hero:
Usergroups:
Adventurers' Guild Group Member Artists Group Member
Champion Group Member

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Count Mohawk » Wednesday February 10th, 2016 1:08pm

I believe I've fixed all the door issues now, so I chose to upload v0.9 of the Excel Questimator, which is now just about caught up functionality-wise with the VBA version. Check the first post for the download links.

That said, although there are a number of improvements I still want to make to both Questimators, I will be setting this project down for a while in favor of some of the other hobbies I've been neglecting over the past few months. So don't expect anything new on this front before April at least.


Rewards:
Grin's Stone Map Created a Hot Topic. Shattered a Skeleton! Destroyed a Zombie! Crushed a powerful Chaos Warrior! Smashed a massive Gargoyle!
User avatar
Marquis of Math
Count Mohawk

Elven Warrior
Elven Warrior
 
Posts: 662
Joined: Thursday July 11th, 2013 5:18pm
Location: New England, USA
Forum Language: English (United States)
Evil Sorcerer: Zargon
Hero:
Usergroups:
Champion Group Member

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Anderas » Thursday February 11th, 2016 1:37am

I was downloading that last version. It is really cool!
Thanks to have let the code open.


Rewards:
Hosted a Play-by-Post game. Played a turn in a Play-by-Post game. Created a Hot Topic. Participated in four (4) Miniature Exchanges. Zealot Miniatures: Twisting Catacombs Kickstarter Backer Destroyed a Zombie! Encountered a menacing Chaos Warlock!
User avatar
Anderas
NOT Andreas!

Yeti
Yeti
 
Posts: 2827
Images: 33
Joined: Saturday September 20th, 2014 7:02am
Forum Language: British English
Evil Sorcerer: Morcar
Hero:
Usergroups:
Adventurers' Guild Group Member Artists Group Member
Champion Group Member

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Count Mohawk » Thursday April 14th, 2016 5:25pm

Greetings, fellow calculators! (by which I mostly mean Anderas, but whatever)

April has arrived, and so I have decided to pick up where I left off on this project. New to the Excel version is the following feature:
Image
Image
That's right, you can now add traps and furniture to your randomly-generated Quests! Each room is currently capable of parsing up to four items of furniture and up to 12 traps. Bug testing is, as always, a work in progress, but furniture should not block doorways, and monsters should not share squares with furniture or traps.

I'll update the first post later, but for now, here's a link to the current Excel document. Warning: probably requires xl2007 or hire.


Rewards:
Grin's Stone Map Created a Hot Topic. Shattered a Skeleton! Destroyed a Zombie! Crushed a powerful Chaos Warrior! Smashed a massive Gargoyle!
User avatar
Marquis of Math
Count Mohawk

Elven Warrior
Elven Warrior
 
Posts: 662
Joined: Thursday July 11th, 2013 5:18pm
Location: New England, USA
Forum Language: English (United States)
Evil Sorcerer: Zargon
Hero:
Usergroups:
Champion Group Member

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Anderas » Friday April 15th, 2016 1:53am

Hey cool!
You know what? We should find a way to integrate all that into Heroscribe as a menu option. Is the code of Heroscribe available or hidden?

Here in my company that integration would not cost more than 100 000 Euro. :D
Maybe it's better not to do it in my company. :D


Rewards:
Hosted a Play-by-Post game. Played a turn in a Play-by-Post game. Created a Hot Topic. Participated in four (4) Miniature Exchanges. Zealot Miniatures: Twisting Catacombs Kickstarter Backer Destroyed a Zombie! Encountered a menacing Chaos Warlock!
User avatar
Anderas
NOT Andreas!

Yeti
Yeti
 
Posts: 2827
Images: 33
Joined: Saturday September 20th, 2014 7:02am
Forum Language: British English
Evil Sorcerer: Morcar
Hero:
Usergroups:
Adventurers' Guild Group Member Artists Group Member
Champion Group Member

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Anderas » Saturday April 29th, 2017 4:01am

While working on Kellar's Keep, i was fed up that the Excel Based Questimator took more than 10 seconds to calculate a quest.
So i accepted the challenge and translated your dice probabilities and your RSC sheets into pure VBA code.

Now i know why you were thinking about using Python for it! You are absolutely right, in Python it would have been A LOT EASIER. The code that i have now is not very long, but to get my brain around all the indexing was not easy at all. However, that made me appreciating your work twice as much than before! |_P Do you know if one could call an ironPython module from within Excel VBA? The other way round it workds, ironPython can call Excel.

Well. Another day maybe.

Now that i have the dice calculation in VBA, i add options for rerolling dice.

Sarcasm: Yes. I am so much working on Kellars Keep. /Sarcasm I think i would have already finished that book if i wouldn't update the Questimator. :mrgreen:
I will publish my version as soon as it is ready.


Rewards:
Hosted a Play-by-Post game. Played a turn in a Play-by-Post game. Created a Hot Topic. Participated in four (4) Miniature Exchanges. Zealot Miniatures: Twisting Catacombs Kickstarter Backer Destroyed a Zombie! Encountered a menacing Chaos Warlock!
User avatar
Anderas
NOT Andreas!

Yeti
Yeti
 
Posts: 2827
Images: 33
Joined: Saturday September 20th, 2014 7:02am
Forum Language: British English
Evil Sorcerer: Morcar
Hero:
Usergroups:
Adventurers' Guild Group Member Artists Group Member
Champion Group Member

Re: Questimator - An Excel and VBA-based difficulty approxim

Postby Jade » Monday August 7th, 2017 11:02am

So, I downloaded the excel version, but I don't see any way to generate random quests? Have I misunderstood what you were talking about when you referred to the program being able to add things to random quests?
Jade

Skeleton
Skeleton
 
Posts: 21
Joined: Sunday August 6th, 2017 10:05pm
Forum Language: English (United States)
Evil Sorcerer: Zargon
Hero:
Usergroups:
Champion Group Member

Previous

Return to Project Forge

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests