The most complete Excel merc chart so far (or so I think)[message #150167]
|
Sat, 21 July 2007 14:24
|
|
Ledtim |
|
Messages:24
Registered:June 2007 |
|
|
Using Terminus Est's merc and weapon chart as a starting point, I created a more complete chart of characters available in JA2.
It contains info on all mercs and recruitable characters available in JA2. Mercs and traits added in 1.13 patch are listed in red.
Other than the basic data such as the characters' stats and wages, I added some analysis, such as the sum of their stats etc.
Then, I added more useful info using the formulae from the source codes, such as the APs, militia training rate, repair rate, doctoring rate, stealth value, lockpick, disarm ability, h2h fighting ability, throwing ability, throwing range, grenade launcher accuracy etc.
The effect of traits, such as martial art's effect on melee and teaching's effect on militia training is accounted for in the formulae of the appropriate headings.
Tips for Usage:
**1. In Excel menu, go to view --> comments to see explanations for various headings etc. **
2. Click on the little down-arrow in each heading and select the appropriate option to sort the chart according to your needs. For example, you want to find the character with the highest repair rate, go to the repair heading and click on the down arrow and select "sort descending".
3. The chart is fully programmed so you can modify the characters' stats & traits and get immediate updates to their repair rate, stealth value etc. etc.
4. Similarly, you can check out calculated values for your IMP or characters from a MOD by adding a new row. Copy one of the rows in the chart, paste it in a new row and enter the new data such as the character's name, stats, wages.
5. Expert characters, such as Dimitri who is a throwing expert, have their traits highlighted in a bold font so you can pick them out quickly. The highlighting is done automatically. For example, so if you change a character's traits so he becomes a stealth expert, his traits will be highlighted in bold and italics automatically.
6. If you can't see the full heading, you can expand the heading size by dragging it or by clicking in the heading cell to see the value in the Excel status bar.
Who do you call if you've locked yourself out of your house? Trevor!
Download the Chart here
[Updated on: Sat, 07 November 2015 02:33] by Moderator Report message to a moderator
|
Private 1st Class
|
|
|
Re: The most complete Excel merc chart so far (or so I think)[message #150171]
|
Sat, 21 July 2007 15:08
|
|
DNA from the Lowlands |
|
Messages:337
Registered:July 2003 |
|
|
Downloaded it, immediatly after reading:
I added more useful info using formulae from the source codes, such as the APs, militia training rate, repair rate, doctoring rate, stealth value, lockpick, disarm ability, h2h fighting ability, throwing ability, throwing range etc. etc.
That got me excited, stats & effects.
Thanks.
ghehe ...I could be stuck planning for days...
Report message to a moderator
|
Master Sergeant
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: The most complete Excel merc chart so far (or so I think)[message #249978]
|
Fri, 23 April 2010 09:03
|
|
Ddass |
|
Messages:26
Registered:April 2010 |
|
|
Dear god, what an awful chart full of wrong and worthless info. The ja-galaxy forum is among the noobiest I have ever seen. Dont get me wrong there are real experts here, but for every useful post there are 20 of pure BS and this thread easily tops it. The fact that it is stickied for several? years and nobody corrected it speaks for itself. Ivan has 22 AP??, Danny is a better doctor than Spider?? Len costs $840?? Etc etc. And whichever info is not downright wrong(not much) deals with things depending on level and thus worthless. Buns is a better fighter than Gus, because she has more gunfighting stats?? Yeah lets count apples and oranges and whichever is numerically more is "Better". Apparently he doesnt know what a medical deposit is, and that it is a one time investment, some mercs have it and some dont, so his cost modifiers are all wrong too, as well as other things.
/rant
Really, what the hell. Game has source code published.
Report message to a moderator
|
Private 1st Class
|
|
|
|
|
|
Re: The most complete Excel merc chart so far (or so I think)[message #334948]
|
Mon, 11 August 2014 22:48
|
|
Huberclim |
|
Messages:29
Registered:May 2011 Location: Germany |
|
|
Ohh all file links down =(
Any re-uploads?
Thanks!
Edit by Scheinworld:
-re-uploaded Ledtim's Excel merc chart; fixed download link in first/release post!
[Updated on: Sat, 07 November 2015 02:36] by Moderator Report message to a moderator
|
Private 1st Class
|
|
|