Upgraded Ship Builder & After-action reports

[James Eggleston]

Been working on an upgrade to the old ship-building spreadsheet, found here: https://docs.google.com/spreadsheet/ccc?key=0Au0RXtO6hFPzdGVoZ2l1WGVqRFdNUGdwdUxxYVNka3c&usp=sharing

Thanks to Jaron for showing me how to do the drop-down lists - the main improvements are centered around being able to select your weapons and the math filling in from there.  So, for example, if you selected a medium laser and opted to upgrade the range, it would fill in power costs appropriately and deduct them from your power calculations above.  I've also (hopefully) made the power allocation a bit more intuitive: the top row is what you actually spend, the lower "effective power" row is your functional level once bonuses/penalties are factored in.  The last major change I made was an indication of how much you can change speed and heading by to the left of your hull/armor/shield levels.

So, how does this look to you guys?  It alludes to ammo-based upgrades for Rate of Fire and Acceleration, which were discussed today but won't be implemented until after the next game (to be scheduled.)  So those values don't exist yet, but the math for them is built in right now.  I've also added the possibility of putting defenses on that dropdown, but perhaps that would be too much?  (Especially since you'd need the exact name.)

-----

It was great to get together today - the rules remain crystalized as-is, but we discussed a great many interesting ideas, proposals, and tactics.  Steve's tactical prowess was once again on display, and the Victor's Cup of Victory remains decidedly in Jovian space.  Josh was assuredly missed, but car troubles happen, and life takes priority over playing Legos (though some would append 'all too often.')  Jaron, maybe we'll have to come your way soon and play some Galactic Lazer Tag as well as MFW.  Pictures forthcoming, and lots more spitballing of potential improvements, rest assured.

[James Eggleston]

I should mention, if you want to play with that sheet, you'll have to File->Make a Copy for yourself; the master isn't editable.  (I worked hard on those maths!  I can't just let any paste-eater overwrite cells and break the thing, after all.)  But yes, hope it works and makes sense to you guys - lemme know.

[Jaron Janson]

James, the ship builder looks awesome! This is exactly what I was describing. Thanks for your hard work on making it a reality. I am going through and recreating my ships in the sheets now. Do missiles have to be manually priced? Whenever I choose a projectile weapon it doesn't automatically price it out for me, I assume this is on purpose so multiples can be added. 

Sounds like the Jovians are in a good position moving into this summer and the imminent BrickFair showdown. ISDA will be showing up in force, too. I assure you that our forces haven't been complacent since the last enagement against Pantops and YourCurian forces. 

_________________________________
Jaron Janson
435-669-1987
jaron....@gmail.com

--
You received this message because you are subscribed to the Google Groups "Lego Microfleet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lego-microfle...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[James Eggleston]

Thanks, man - the ammo-based weapons should price out correctly based on the number in the ammo column, yes.

[Steve V]

Pretty cool James.  This should definitely help avoid any accounting errors in the future. :-o  

The Jovians are indeed in a good position, although the battle was far from one-sided.  We will not, however, be sending an official delegation to BrickFair this year, for many reasons.  We would delight in entering battle before then, should the opportunity arise, even if it means a trip up north.  Our tacticians are busy analyzing the latest battle and revising our battle plans even as we speak.... 

---

From: James Eggleston <egglest...@gmail.com>
To: lego-mi...@googlegroups.com
Sent: Tuesday, May 21, 2013 5:41 PM
Subject: Re: [Lego Microfleet] Re: Upgraded Ship Builder & After-action reports