 |
|  |
 |
|
Drogue
|
 |
Omnipresent conscience
Oct 2002 time: 05:35
|
|
Sadly, my parents have been very discouraging of my internet use lately (logging when I'm on, etc. ) and so it looks as if I won't be able to compete in this gladiator However I have done the spreadsheet template for J Bytheway.
It's pretty straightforward, in the columns W and A (B and C) put the gladiator's weapon and armour rating; in the columns At, D and P (D, E and F) put their attack, defense and power orders. Then the next three columns, marked Attack, Defense and Power (G, H and I) it will work out each of those, including weapons. The column marked damage (K) will give 0 if they have not hit, and a number, the damage hit, if they do hit. L works out the HP left after each round. Column M is marked Tied Hits, and when attack and defense are equal, it will go in here, and will be half strength. It is part of damage, but needs two columns, and is already included in the formula for the HP left column. Win and Draw (N and O) will give you the points scored, 3 for win, 1 for a draw. Points (P) is the amount of attack, defense and power points used in that hit, and Total Points (Q) adds the total of these, so you can quickly check that everyone has used 100. The table next to it updates itself with the scores for that round.
It looks complicated, but once you see it, it's pretty simple. Put in their orders, and the weapon and armour rating, and it'll do the rest. Since I won't be competing, if you need any help, just ask.
Actually, 'Poly won't let me post the spreadsheet I can easily email it, given an address to send it too 
|
|
|  |
 |
|  |
All times are GMT. The time now is 05:35. Apolyton Time is 00:35. |
top of page
|
| archivepost |
|
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
|
|
|
|
|
|