Home » SIRTECH CLASSICS » Jagged Alliance 2 » The A.I.M. Library » The most complete Excel merc chart so far (or so I think)
The most complete Excel merc chart so far (or so I think)[message #150167] Sat, 21 July 2007 14:24 Go to next message
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

Re: The most complete Excel merc chart so far (or so I think)[message #150171] Sat, 21 July 2007 15:08 Go to previous messageGo to next message
DNA from the Lowlands

 
Messages:339
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...
Re: The most complete Excel merc chart so far (or so I think)[message #150215] Sat, 21 July 2007 20:53 Go to previous messageGo to next message
themglman

 
Messages:74
Registered:October 2001
Location: Texas
Very nice , thank you . :luckystrike:
Re: The most complete Excel merc chart so far (or so I think)[message #150438] Mon, 23 July 2007 18:02 Go to previous messageGo to next message
Ledtim

 
Messages:24
Registered:June 2007
I've made some minor changes and additions since I first posted the chart, namely:
* added mercs in UB
* some formatting corrections
* added how interrupt points is calculated in the 1.13 patch
Re: The most complete Excel merc chart so far (or so I think)[message #155814] Wed, 05 September 2007 11:18 Go to previous messageGo to next message
Ledtim

 
Messages:24
Registered:June 2007
Some small changes
* Added the fact that Flo, with her arms dealing experince, gets a 10% price discount/bonus to buying/selling guns and ammos.
* Added various values for melee combat, such as knifing attack accuracy and knifing dodge etc.
* Some layout clutter cleanup
Re: The most complete Excel merc chart so far (or so I think)[message #155845] Wed, 05 September 2007 15:51 Go to previous messageGo to next message
DNA from the Lowlands

 
Messages:339
Registered:July 2003
Oh now that you mention it.
Flo, Wolf and I thought there was another (?Didn't LucasSan post it somewhere?)
Re: The most complete Excel merc chart so far (or so I think)[message #155921] Thu, 06 September 2007 00:28 Go to previous messageGo to next message
Ledtim

 
Messages:24
Registered:June 2007
You are probably thinking of this thread.

The discussion at the end says hated nationalities of the merchants affect the selling/buying price and that Flo pays more at the shops. Which is completely wrong...

(Hmm, Isn't that post plagiarized from this handy site?
Re: The most complete Excel merc chart so far (or so I think)[message #212339] Tue, 07 April 2009 17:08 Go to previous messageGo to next message
Off_Topic

 
Messages:1052
Registered:January 2009
Just came across this thread, it's a brilliant reference for anyone that wants to put together the perfect Merc team or just get to know the nitty gritty details of every Merc.


Re: The most complete Excel merc chart so far (or so I think)[message #212354] Tue, 07 April 2009 19:00 Go to previous messageGo to next message
Shanga

 
Messages:3531
Registered:January 2000
Location: Danubia
Sniped and Saved:

http://www.esnips.com/doc/d9ad995c-5a71-43f7-9823-7e2ef4a478d5/Ledtim-Mercs-Chart


Re: The most complete Excel merc chart so far (or so I think)[message #212355] Tue, 07 April 2009 19:03 Go to previous messageGo to next message
Off_Topic

 
Messages:1052
Registered:January 2009
That list is nearly worth putting in to 1.13 as a bonus folder or something. It's very handy for seeing who actually can do what with regards grenade throwing, disarming bombs etc...


Re: The most complete Excel merc chart so far (or so I think)[message #212357] Tue, 07 April 2009 19:19 Go to previous messageGo to next message
lockie

 
Messages:3968
Registered:February 2006
Location: Scotland
Never mind the topic , what about the HAT !!! Very Happy


Re: The most complete Excel merc chart so far (or so I think)[message #212369] Tue, 07 April 2009 19:44 Go to previous messageGo to next message
Off_Topic

 
Messages:1052
Registered:January 2009
Yeah, i'm going for a communist dictator image :devilaugh:


Re: The most complete Excel merc chart so far (or so I think)[message #214368] Mon, 27 April 2009 22:57 Go to previous messageGo to next message
howareyou32

 
Messages:453
Registered:March 2009
Location: New York, New York
thanks man. great help
Re: The most complete Excel merc chart so far (or so I think)[message #217016] Sun, 17 May 2009 13:06 Go to previous messageGo to next message
MikeThePro

 
Messages:178
Registered:November 2007
Location: Bulgaria

Thanks for the work, that's one heck of a chart.
Re: The most complete Excel merc chart so far (or so I think)[message #226312] Wed, 08 July 2009 19:58 Go to previous messageGo to next message
Kordanor

 
Messages:28
Registered:March 2008
Links seem to be dead. Sad
Re: The most complete Excel merc chart so far (or so I think)[message #226315] Wed, 08 July 2009 20:35 Go to previous messageGo to next message
gmonk

 
Messages:646
Registered:April 2002
Location: Newfoundland, Canada
Thanks to Shanga it's still available on esnips. Go back and read the thread again. Smile
Re: The most complete Excel merc chart so far (or so I think)[message #231611] Tue, 25 August 2009 03:15 Go to previous messageGo to next message
hal900x

 
Messages:58
Registered:August 2009
Quick question, for those of us who don't have the full version of Excel (I use the free reader, or OpenOffice). What does it mean when a regular, hirable non-UB merc has their second trait in red? Danny, Fidel, Igor and Nails are listed this way.
Re: The most complete Excel merc chart so far (or so I think)[message #243488] Mon, 08 February 2010 00:42 Go to previous messageGo to next message
goc_man

 
Messages:107
Registered:November 2007
Location: Croatia
@Ledtim:
Great work I've been using your table a lot. Can you please answer my PM? Sorry for offtopic, but it's been 5 days :whistle:
Re: The most complete Excel merc chart so far (or so I think)[message #243489] Mon, 08 February 2010 00:44 Go to previous messageGo to next message
Tao

 
Messages:2225
Registered:August 2009
Location: The Known Universe
@goc man
I haven't seen ledtim for a LONG time here.
Re: The most complete Excel merc chart so far (or so I think)[message #243540] Mon, 08 February 2010 20:11 Go to previous messageGo to next message
goc_man

 
Messages:107
Registered:November 2007
Location: Croatia
Thanks craigmsandy, guess he's gone :bawling:
Re: The most complete Excel merc chart so far (or so I think)[message #243542] Mon, 08 February 2010 20:20 Go to previous messageGo to next message
Tao

 
Messages:2225
Registered:August 2009
Location: The Known Universe
Thank you Goc man for all of the one click installers!
Re: The most complete Excel merc chart so far (or so I think)[message #249978] Fri, 23 April 2010 09:03 Go to previous messageGo to next message
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.
Re: The most complete Excel merc chart so far (or so I think)[message #250001] Fri, 23 April 2010 13:31 Go to previous messageGo to next message
Logisteric

 
Messages:3474
Registered:December 2008
Location: B
welcome to the pit - i'm sure you'll make a lot of friends here easily

so how many ap does ivan have? if you think it's crap why don't you update it - to be honest i never used it - there ain't no quality-gestapo here
Re: The most complete Excel merc chart so far (or so I think)[message #250029] Fri, 23 April 2010 16:48 Go to previous messageGo to next message
Ddass

 
Messages:26
Registered:April 2010
Nah this whole spreadsheet is fundamentally wrong, being static while everything in game is dynamic. Danny heals better than Spider, but thats not because he is a better healer, but because he is lvl3 and Spider lvl1 and that certainly does not stay that way. Improving&checking that is a total rewrite, easier to do from scratch. (although i do have a program which calculates relevant values depending on input merc stats, perks and level. )

thanks for welcome, but im not here to make friends. Very Happy (or enemies)
Re: The most complete Excel merc chart so far (or so I think)[message #250171] Sat, 24 April 2010 12:40 Go to previous messageGo to next message
Kaerar

 
Messages:2089
Registered:January 2003
Location: Australia :D
Errm Ddass I do believe that is based on out of date data now. Also based on vanilla if my memory serves me correctly. Having said that this section hasn't been cleaned of topics for a long time Wink

Thing is all the data can be viewed in ProEdit, and even then Headrock made Profex which moves it all into an external XML file for easier viewing and editing. I never used this because I was using proedit years ago!


Re: The most complete Excel merc chart so far (or so I think)[message #334948] Mon, 11 August 2014 22:48 Go to previous message
Huberclim

 
Messages:34
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

Previous Topic: Stealing Kingpin's Money
Goto Forum:
  


Current Time: Thu Oct 19 21:01:07 EEST 2017

Total time taken to generate the page: 0.01839 seconds