|
Zelc
|
 |
« on: April 12, 2011, 10:47:52 pm » |
|
A couple Excel sheets for BGFW: Attack Calculator: Put in the attack and defense lines, along with modifiers, and it not only spits out the expected damage, but also graphs the damage distribution for you. Contains most of the common combat modifiers. Light Army Builder: Pretty much the same as the one previously made by uberursine. It's easier to sort, and more importantly it works on DocsToGo for the iPad. These are both in beta, let me know if you see something weird. |
|
|
|
« Last Edit: March 04, 2012, 09:14:51 pm by Zelc »
|
Logged
|
|
|
|
RushAss
Playtester
Hero Member
Posts: 2260
Eat your beets - Recycle!
|
|
« Reply #1 on: April 13, 2011, 10:32:45 am » |
|
Basically proving that you need to get yourself a girlfriend or something  Seriously, these are pretty cool. The damage calculator will certainly be helpful for many folks here. The Light Army Builder works well, but I'm not sure if I'll ever use it because I have been using Ubersine's for so long. That being said, it offers a quick alternative to the other one. Good work! |
|
|
|
|
Logged
|
"The world weighs on my shoulders but what am I to do?"
-Rush, Distant Early Warning
|
|
|
|
Zelc
|
|
« Reply #2 on: April 13, 2011, 11:27:50 am » |
|
FYI, I noticed I forgot to fix the overkill rule for the To Hit roll. I'll fix that tonight and re-upload. I'm pretty sure the overkill rule for the To Wound roll works.
Also, I think I have an idea of how to model Nets...
|
|
|
|
|
Logged
|
|
|
|
gull2112
Administrator
Hero Member
Posts: 3342
From the RUSH faction
|
|
« Reply #3 on: April 13, 2011, 04:56:02 pm » |
|
Basically proving that you need to get yourself a girlfriend or something All you need is a right hand, man.  Seriously though, pretty cool. Its useful just to throw numbers in and give yourself a quick feel for the potentials. |
|
|
|
|
Logged
|
|
|
|
|
Zelc
|
|
« Reply #4 on: April 13, 2011, 08:41:57 pm » |
|
OK, I think I fixed the attack calculator. These things aren't that hard to make either!
|
|
|
|
|
Logged
|
|
|
|
|
Zelc
|
|
« Reply #5 on: April 17, 2011, 10:23:39 pm » |
|
Basically proving that you need to get yourself a girlfriend or something Possibly validating this statement , I got bored and am now about 70% of the way complete with the first draft of a 1v1 combat simulator, which will simulate the results of an arbitrary number of combats and tell me who wins and how much damage each unit did. It's programmed in VBA because it's more convenient for me. I'm hoping I'll eventually port this over to Python, which will give me an excuse to learn Python. EDIT: I actually got it done last night, but I haven't tested for bugs. I'm going to guarantee there has to be some bugs; there's no way I got it perfect in one shot. I don't have many good ideas on testing though  . |
|
|
|
« Last Edit: April 18, 2011, 08:17:57 am by Zelc »
|
Logged
|
|
|
|
RushAss
Playtester
Hero Member
Posts: 2260
Eat your beets - Recycle!
|
|
« Reply #6 on: April 18, 2011, 09:19:30 am » |
|
Basically proving that you need to get yourself a girlfriend or something Possibly validating this statement , I got bored and am now about 70% of the way complete with the first draft of a 1v1 combat simulator, which will simulate the results of an arbitrary number of combats and tell me who wins and how much damage each unit did. It's programmed in VBA because it's more convenient for me. I'm hoping I'll eventually port this over to Python, which will give me an excuse to learn Python. EDIT: I actually got it done last night, but I haven't tested for bugs. I'm going to guarantee there has to be some bugs; there's no way I got it perfect in one shot. I don't have many good ideas on testing though . You keep this up and nobody is going to want to actually play the games anymore Advice - sit on this until AFTER the tournament  |
|
|
|
|
Logged
|
"The world weighs on my shoulders but what am I to do?"
-Rush, Distant Early Warning
|
|
|
Niko White
Celestial Guard
Administrator
Hero Member
Posts: 2389
A tíro nin, Fanuilos!
|
|
« Reply #7 on: April 18, 2011, 11:28:16 am » |
|
You keep this up and nobody is going to want to actually play the games anymore Advice - sit on this until AFTER the tournament No man, if we encourage him, we'll probably end up with the online play client everyone's always wanted! |
|
|
|
|
Logged
|
|
|
|
|
Zelc
|
|
« Reply #8 on: April 18, 2011, 11:18:43 pm » |
|
Don't hold your breath :p. VASSAL is sort of annoying to figure out, actually.
|
|
|
|
|
Logged
|
|
|
|
Niko White
Celestial Guard
Administrator
Hero Member
Posts: 2389
A tíro nin, Fanuilos!
|
|
« Reply #9 on: April 18, 2011, 11:27:45 pm » |
|
Don't hold your breath :p. VASSAL is sort of annoying to figure out, actually.
Oh yeah I meant from the ground up obv. But I was also, perhaps, joking a bit |
|
|
|
|
Logged
|
|
|
|
RushAss
Playtester
Hero Member
Posts: 2260
Eat your beets - Recycle!
|
|
« Reply #10 on: April 19, 2011, 09:15:02 am » |
|
I was telling him to sit on it so that other players won't have the same insight he may have and thus give him a slight edge in the tournament. I was being a nice guy, you see  |
|
|
|
|
Logged
|
"The world weighs on my shoulders but what am I to do?"
-Rush, Distant Early Warning
|
|
|
|
Moose
|
|
« Reply #11 on: April 24, 2011, 01:46:43 pm » |
|
Just an FYI- In your light army builder you left a unit out from the Dark Elves- The Dusk Lord is not on there.
|
|
|
|
|
Logged
|
|
|
|
BubblePig
Prince of Shadow
Administrator
Hero Member
Posts: 1213
Belkar Rules!!!
|
|
« Reply #12 on: April 24, 2011, 04:33:08 pm » |
|
Thanks, Zelc. Also, per Kevin's fix the Lashmistress Spell causes the unit to move whether or not it causes damage. The Lashmistress loses an attack die, going to (4) 6/5 for both her spell and her regular (engaged) attack. (She
still can make a regular attack if her "Siren Song" causes an enemy unit to final rush that turn.) However her
"Siren Song" spell effect is automatic (like the Coven Spells currently are): she no longer needs to do a point
of damage for the spell to take effect. I used this text in my version: Fearsome. Spell: Siren Song (Attack) A(4) 6/5 Range: 10.5" Line of Sight. Cast at the end of your Movement and Command Phase. No penalty for Move and Shoot. Damage from this attack can't cause rout checks. If the target of Siren Song is a non-routing unit, move it immediately towards this unit as if it had a Close order targeting it. This movement can cause a Final Rush. |
|
|
|
« Last Edit: April 24, 2011, 04:41:36 pm by BubblePig »
|
Logged
|
|
|
|
|
Zelc
|
|
« Reply #13 on: April 28, 2011, 08:23:17 pm » |
|
I added the Dusk Lord, and changed the Lashmistress wording to this:
Fearsome. Spell: Siren Song (Attack) A(4) 6/5 Range: 10.5" Line of Sight. Cast at the end of your Movement and Command Phase. No penalty for Move and Shoot. Damage from this attack can't cause rout checks. The first time a non-routing unit is attacked by Siren Song in a phase, move it immediately towards this unit as if it had a Close order targeting it. This movement can cause a Final Rush.
|
|
|
|
|
Logged
|
|
|
|
BubblePig
Prince of Shadow
Administrator
Hero Member
Posts: 1213
Belkar Rules!!!
|
|
« Reply #14 on: June 26, 2011, 01:27:20 pm » |
|
Nice job, Zelc. I had a messier version for crunching numbers, but am going to start using yours.
I am confused about the purpose of sumproduct function in the [to hit] and [to dmg] final numbers, though.
It seems to be throwing off the [to dmg.] For example with attacker numbers 5/6 and defender numbers 2/3 I get 3's and 4's.
|
|
|
|
|
Logged
|
|
|
|
|
