mikekh wrote:
Thanks for the ideas Spike. Most things are achievable - I design and implement graphical user interfaces for the ground stations of satellite communication systems - what I don't want to do is write something based on a very small survey of requirements. I code in my day job - so doing it out of hours is sometimes a major effort. I want it 90% correct on the first iteration.
Any more ideas?
As Spike says, Olivier's Excel spreadsheet is excellent, but it pushes up against the restrictions
of Excel's use and formatting, so:
1. You can't drag and drop BGs around easily, or copy and drop them in the middle of the list, or
indeed simply insert a new item in the middle with one action.
2. It doesn't handle mixed BG's cleanly, ie as a copyable single BG.
3. Selecting capabilities involves a click to select from a dropdown, unless it's been previously
chosen. Ideally one would tab to the "cell" and type in the first letter of the dropdown item.
Do this in Excel and you get an error message.
4. Player name, club, and such like are redundant in that they should be a global configuration,
added to a print out automatically.
5. You can't sort by clicking on a column header - in Excel it's a menu item sort data, and even
then it's way to easy to mess up the entire spreadsheet.
6. Printing should automatically group BGs by quarters.
7. Click a button to email it to the organisers using your mail software (might be hard that one, if
multi-OS).
8. Excel is Windows only, so if you have a Mac, you're sunk unless you have dual-boot or
something like Fusion installed, or have bought MS Office for the Mac, and many don't (I'm
not even certain it will work then, as they messed around with scripting support in the Mac
version). There's also a smaller minority using Linux. So I'd suggest using a cross-platform
GUI framework if you know one*.
I suppose in summary it would be making chopping and changing an army design easier, so one
can experiment. I wish you luck if you try it, because the major advantage of Excel is it gives you
the calculation and formatting (albeit limited) for free.
Regards,
Peter
* Qt is by far the best cross-platform GUI framework - even if one were to use it only on Windows
it's a better GUI tool than anything Microsoft have ever produced! It also includes a 2D graphics
library easy enough to make a simple diagram layout tool.