Lead Adventure Forum

Miniatures Adventure => VSF Adventures => In Her Majesty's Name => Topic started by: pixelgeek on 12 March 2014, 03:04:14 AM

Title: IHMN in Numbers
Post by: pixelgeek on 12 March 2014, 03:04:14 AM
Just been fooling around in Numbers to build a tool to help me create IHMN companies. Still working on some features but it calculates the point costs correctly.

Title: Re: IHMN in Numbers
Post by: Craig on 12 March 2014, 05:44:58 AM
I may be a dull old Luddite stuck in 1895, but what pray is 'Numbers'?
Title: Re: IHMN in Numbers
Post by: pixelgeek on 12 March 2014, 12:59:33 PM
I may be a dull old Luddite stuck in 1895, but what pray is 'Numbers'?

It is the spreadsheet app that comes with Macs. Works on iOS as well. I just don't own a copy of Excel
Title: Re: IHMN in Numbers
Post by: vsfguthroth on 12 March 2014, 01:01:53 PM
Interesting idea, sadly I don't have a Mac  :(
Title: Re: IHMN in Numbers
Post by: Joe Fish on 12 March 2014, 02:07:37 PM
You can do rougly the same in Excel, the spreadsheet in Microsoft's Office.  I think you can also come pretty close using the Open Office version of a spreadsheet program.
Title: Re: IHMN in Numbers
Post by: freewargamesrules on 12 March 2014, 02:57:11 PM
Yes you can do the same in OpenOffice and LibreOffice spreadsheets, just use lookup function.
Title: Re: IHMN in Numbers
Post by: stonedzep on 12 March 2014, 03:15:02 PM
Up for the Numbers version!!! Ready to use it on my old donkey macbook!! Then surely someone will know how to export it for Excel here.
Title: Re: IHMN in Numbers
Post by: pixelgeek on 12 March 2014, 04:15:19 PM
No-one has built anything like this for Excel?
Title: Re: IHMN in Numbers
Post by: stonedzep on 12 March 2014, 04:18:15 PM
Not that I know, I've been looking for something like that but nothing so far!
Title: Re: IHMN in Numbers
Post by: pixelgeek on 12 March 2014, 06:26:50 PM
Let me see if I can convert it to Excel

Craig, are you okay with people distributing something like this? Maybe via the IHMN website?
Title: Re: IHMN in Numbers
Post by: Dewbakuk on 12 March 2014, 07:01:27 PM
I've (mostly my wife actually) done a complete one with drop down options etc for Excel that Craig's had for ages. I think he was intending to put it up closer to the release of the next book but if you ask nicely...
Title: Re: IHMN in Numbers
Post by: Craig on 12 March 2014, 07:28:13 PM
The Excel Spreadsheet created by Dewbakuk's wife is one of two that Charles and I have used throughout the development of the three books. The other was by a chap called Aonghus.

We kept wishing to release it and then thought of new things we wanted in it as we released more materials through the blog and wrote each book. We shall probably release the latest Happy-Wifey version close to the publication of SDRS.

In the meantime if anyone wishes to create spread sheets/army builders in any format for IHMN we are happy for them to do so and publish them through their own blogs. We shall even link to them from the IHMN blog.

Our only concern about releasing one through the IHMN blog is that we do not know how thorough the testing has been, and if we release it then it shall be seen as 'official'. As Dewbakuk can attest even a small mistake in the data entry for the look-up tables or formulae can have unforeseen consequences. His wife's creation has been tested to death by the authors  :D
Title: Re: IHMN in Numbers
Post by: vsfguthroth on 12 March 2014, 08:41:21 PM
It's a shame you feel constrained like that Craig.

For a ruleset like Fog Of War where the emphasis is 100% competition gaming it's understandable, but I would have thought less so for a set like IHMN.  8)

Games are enjoyable things and variety and 'Unofficialness' lies at the heart of the best adaptations. I see the love of (or lust for) 'Official' books as an unfortunate side effect of GW.  :(
Title: Re: IHMN in Numbers
Post by: stonedzep on 12 March 2014, 09:05:23 PM
Hello Craig: first, I'll take this chance to say how much I'm enjoying IHMN, it's a real gem and the constant attention and participation with loads of material, tips, updates and everything in your blog is amazing!!

Concerning the excel spreadsheet might be of help locking it with a password(not to be revealed of course) the "data" cells so only the input ones will be active cells for the users? Probably was something you already considered but I'm just asking!

Title: Re: IHMN in Numbers
Post by: Conquistador on 13 March 2014, 02:19:11 AM
It is the spreadsheet app that comes with Macs. Works on iOS as well. I just don't own a copy of Excel

Drat, My second hand (from son #2) MacBook Air doesn't have an application called numbers.  I guess this notebook preceded "Numbers" - for a second there I was excited.

Gracias,

Glenn
Title: Re: IHMN in Numbers
Post by: Craig on 13 March 2014, 05:49:02 AM
It's a shame you feel constrained like that Craig.
For a ruleset like Fog Of War where the emphasis is 100% competition gaming it's understandable, but I would have thought less so for a set like IHMN.  8)
Games are enjoyable things and variety and 'Unofficialness' lies at the heart of the best adaptations. I see the love of (or lust for) 'Official' books as an unfortunate side effect of GW.  :(

It's more a case of not wanting to disappoint people with a faulty or incomplete generator. We know that for many the ability to create your own companies is very important, so costing these is also important. If the generator is not perfect that could lead to people relying on something that lets them down.

As I have said we will publish a generator closer to the release date of SDRS.
Title: Re: IHMN in Numbers
Post by: Conquistador on 13 March 2014, 10:53:59 AM
It's more a case of not wanting to disappoint people with a faulty or incomplete generator. We know that for many the ability to create your own companies is very important, so costing these is also important. If the generator is not perfect that could lead to people relying on something that lets them down.

As I have said we will publish a generator closer to the release date of SDRS.

So there will not be more supplements after the next one?  Not that such a decision brings anything but joy to my pocketbook and heart (I hate constant updates of a system.)

Law of Unintended Consequences applies:

You publish a generator - a supplement is written - now you need to update the generator - someone doesn't know that - they can't create their team member(s) because it doesn't include the supplemental material - You 'achieve' the  "... a case of not wanting to disappoint people with a faulty or incomplete generator..." - you tell them they need to replace or update their generator - back to "... you publish..."

Not that you should never generate such a tool (pun unintended) but there are potential consequences that you should consciously decide are worth the cost.  I see these type of events from my job almost daily somewhere in the world where it truly was "unintended" for events to unfold as they do.

A classic major example is WW1/WW2/Cold War/today.

Gracias,

Glenn
Title: Re: IHMN in Numbers
Post by: Craig on 13 March 2014, 12:06:31 PM
So there will not be more supplements after the next one?  Not that such a decision brings anything but joy to my pocketbook and heart (I hate constant updates of a system.)

I can neither confirm nor deny your conclusion. Charles and I shall not write supplements just for the sake of doing so, like some series we could mention but won't.

We shall be talking to our publishers about a number of options  and projects going forwards and once we have an agreement we shall let you know :)
Title: Re: IHMN in Numbers
Post by: Roddy on 13 March 2014, 05:42:53 PM
No-one has built anything like this for Excel?

Don't know about Excel but I do know that someone was/is working on a battlescribe catalogue file (great app).

http://inhermajestysname.wordpress.com/additional-material/
Just scroll to the comments section and find the user Nysse
Title: Re: IHMN in Numbers
Post by: freewargamesrules on 14 March 2014, 06:14:59 PM
I have written a calculator in Open Document Spreadsheet format in about an hour very easy to do. ;)
Title: Re: IHMN in Numbers
Post by: Craig on 15 March 2014, 08:01:36 AM
I have written a calculator in Open Document Spreadsheet format in about an hour very easy to do. ;)

Have you tested it? We recommend taking ten companies at random, noting the fact that some companies in IHMN are incorrect as shown in the Errata.
Title: Re: IHMN in Numbers
Post by: pixelgeek on 16 March 2014, 02:51:21 AM
Did a quick bit of work on an Applescript that will take all the tables that you create for the characters in your company and then build a printable list of them. This is also the first version of my company for tomorrow's game

Title: Re: IHMN in Numbers
Post by: freewargamesrules on 16 March 2014, 10:41:32 PM
Have you tested it? We recommend taking ten companies at random, noting the fact that some companies in IHMN are incorrect as shown in the Errata.

Written 2 versions original rule book version and rules with errata version. Need time to test it now so won't put it on my blog until fully tested.
Title: Re: IHMN in Numbers
Post by: Craig on 18 March 2014, 06:33:43 PM
Written 2 versions original rule book version and rules with errata version. Need time to test it now so won't put it on my blog until fully tested.

I shall look forward to it Pete  :D