Author Topic: 3028-3057 Random Assignment & Rarity Tables - 12 June v10.64  (Read 281732 times)

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #90 on: 22 May 2011, 12:54:51 »
Back early to see you've found yet more errors.  Doh.

Typos corrected and 8.05 upped.  Thanks.
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0


BrokenMnemonic

  • Lieutenant
  • *
  • Posts: 1447
Re: 3025-3050 Faction Assignment & Rarity Tables - 20 May v8.04
« Reply #92 on: 23 May 2011, 03:14:02 »
And the 3 Periphery tables seem to have a wrong date at the top right, shouldn't it be PERIPHERY 3028-3039 instead of PERIPHERY 3028-3057?
Looking at Mercenaries Supplemental II, the Periphery States didn't begin manufacturing Level 2 tech until the 3060s in a lot of cases, with Ferro-fibrous Armour, Double Heat Sinks, Pulse Lasers and the Streak SRM 2 arriving in the mid to late 3050s in most Periphery States other than the Taurian Concordat, which snagged them a few years earlier. I'm guessing that the dates on the Periphery table reflects the late start these nations got on manufacturing 'Mechs featuring new tech, rather than the small quantities purchased earlier.

It's more interesting than optimal, and therefore better. O0 - Weirdo

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #93 on: 23 May 2011, 10:58:43 »
You're correct: the tables for these states will continue to be the same whenever I get to 3057.  The error was that I have no 3057 tables yet, so it shouldn't read "3057" until I do.  That was a leftover reference from an earlier draft that did have later-era tables.
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

eldrwyrm

  • Corporal
  • *
  • Posts: 89
  • Sometimes the Dragon wins.
    • The Wyrm's Rumblings
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #94 on: 23 May 2011, 18:00:14 »
 [notworthy]
Xotl and BigDuke, you guys are awesome.  Can't wait to get home and update to the new versions.
Check out my Klondike Campaign blog at http://eldrwyrm.blogspot.com/

M-Rex

  • Lieutenant
  • *
  • Posts: 973
  • In Ferro, Veritas.
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #95 on: 23 May 2011, 19:26:26 »
I can't get the PDF versions to open.  Adobe keeps saying 'not a supported file type' or that it's damaged.  Anyone else?


"Oh bother", said Pooh, as he chambered his last round...

"Carrying stuff may be a sign of improper utilization of your minions." - 'Freelance Writer' Paul

Frabby

  • Major
  • *
  • Posts: 4242
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #96 on: 23 May 2011, 19:29:46 »
You're correct: the tables for these states will continue to be the same whenever I get to 3057.  The error was that I have no 3057 tables yet, so it shouldn't read "3057" until I do.  That was a leftover reference from an earlier draft that did have later-era tables.
I was going to suggest that with the Periphery being the Periphery, the 3025 tables would likely be valid all through 3057...  :)
Sarna.net BattleTechWiki Admin
Author of the BattleCorps stories Feather vs. Mountain, Rise and Shine, Proprietary, Trial of Faith & scenario Twins

BigDuke66

  • Master Sergeant
  • *
  • Posts: 233
  • Last of the Wilds!
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #97 on: 23 May 2011, 19:56:12 »
I can't get the PDF versions to open.  Adobe keeps saying 'not a supported file type' or that it's damaged.  Anyone else?
If you mean one if my PDFs it could be that it's a PDF 1.7 so only compatible with Acrobat 8.0 or higher, maybe you use an old Reader or one of the other free PDF readers, that could be the problem.
Or the download is really damaged, Mech table is 898.041 Bytes and Vehicle table 503.429 Bytes big.

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #98 on: 23 May 2011, 20:49:21 »
Also make sure you go to the address in the links rather than trying to save it as a file: you have to do the full Rapidshare wait thing to get the actual files.

EDIT: or just use the links in my first post, which are direct downloads.
« Last Edit: 24 May 2011, 07:34:28 by Xotl »
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

Col.Hengist

  • Lieutenant Colonel
  • *
  • Posts: 9189
  • Konrad ' Hengist " Littman Highlander 732b
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #99 on: 24 May 2011, 00:09:12 »
all very interesting. i need to save this to my gaming computer.
Lyran Commonwealth,6th Donegal Guards-Nightstar
Marian Hegemony, II Legio-Cataphract
Clan Hell's Horses, Gamma Galaxy-Summoner
Clan Grinch goat- gamma goat.

TJHairball

  • Master Sergeant
  • *
  • Posts: 325
    • Ravings of an Ivory Tower Lunatic
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #100 on: 24 May 2011, 04:10:01 »
One small oddity that caught my attention in 3028 - everybody else gets a small handful of Gladiators except for Kurita? Awww  :-\

Love the detailed work, though. Looks great. ;)
President-designate of the Dead World Collective. We control more worlds than any faction since the Star League!
Khan of Clan Iron Elephant. We remember. And if you know who we are, we're going to have to make you disappear.
I'm a numbers guy. Please don't tempt me to do the math, I just might.

Onisuzume

  • Lieutenant
  • *
  • Posts: 1010
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #101 on: 24 May 2011, 05:11:40 »
House Kurita made it an issue to make sure that such a tainted machine wouldn't be found in the combine (strict orders not to salvage them, etc.).
Besides, all Gladiators in the other realms would date back to at least 2490 (last production run).
Quote
Also make sure you go to the address in the links rather than trying to save it as a file: you have to do the full Rapidshare wait thing to get the actual files.
Link leads to the file, not the rapidshare page... (the ones in the OP do, at least)

Glory to the Combine Snow Lily Empire!

BigDuke66

  • Master Sergeant
  • *
  • Posts: 233
  • Last of the Wilds!
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #102 on: 24 May 2011, 13:14:45 »
@XOTL
Maybe it would be good to put my PDF links in the first post too, not sure how many really use office or open office so PDF is the easiest way for them to get the charts.
They are just "graphical enhanced" but I hope those charts can trigger more feedback as one can instantly see how numerous a mech is.
« Last Edit: 24 May 2011, 13:16:19 by BigDuke66 »

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #103 on: 24 May 2011, 22:25:59 »
I would think everyone has office in one version or another.  I'll be glad to put the pdfs up if you like, but they seem to defeat the purpose, since they presumably don't allow you to create a regiment or some other random force like the excel ones do.
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

Frabby

  • Major
  • *
  • Posts: 4242
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #104 on: 09 June 2011, 17:35:02 »
Random find: Housebook Liao, p. 47 (right column) tells how the CC lost a lot of 'Mechs on Chesterton in 2812 "including Capella's only batallion of Wolverines".
Given that the CC has no production facility for this 'Mech, this would indicate the WVR to be rarer in the CC than elsewhere, although probably still relatively numerous. Your list has it at 7; I suggest dropping it to 5 or 4 for the CC.
Sarna.net BattleTechWiki Admin
Author of the BattleCorps stories Feather vs. Mountain, Rise and Shine, Proprietary, Trial of Faith & scenario Twins

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #105 on: 09 June 2011, 18:52:10 »
One battalion in the CapCon would be Av 5 (I love that I can calculate that sort of thing now with the new system I'm using).  However, I'm reluctant to rely on any specific mech info from the House books - they're often rather badly put together in this regard and have frequently been retconned to boot.  In this case, TR3039 gives the CapCon a Wolverine production line on Nanking, which the FedSuns took in the 4th War.
« Last Edit: 13 August 2015, 01:52:13 by Xotl »
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

Daryk

  • Lieutenant General
  • *
  • Posts: 37046
  • The Double Deuce II/II-σ
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #106 on: 09 June 2011, 20:29:53 »
Random find: Housebook Liao, p. 47 (right column) tells how the CC lost a lot of 'Mechs on Chesterton in 2812 "including Capella's only batallion of Wolverines".
Given that the CC has no production facility for this 'Mech, this would indicate the WVR to be rarer in the CC than elsewhere, although probably still relatively numerous. Your list has it at 7; I suggest dropping it to 5 or 4 for the CC.
Does "Capella's only" in that context mean "the Capellan Confederation's only"?

BigDuke66

  • Master Sergeant
  • *
  • Posts: 233
  • Last of the Wilds!
Re: 3025-3050 Faction Assignment & Rarity Tables - 22 May v8.05
« Reply #107 on: 09 June 2011, 22:18:18 »
I guess it was intended that way but now with the info from TRO39 it would be better to take it as Capella's(the planet) only Wolverine battalion that leaves the door open for the existence of Wolverines for the CC and a production facility on Nanking.

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #108 on: 27 June 2011, 23:47:43 »
Minor update to add Quirks for the new units found in Era Digest Age of War and Historical Reunification War.  Age of War in particular adds a new Quirk, Obsolete.

No other changes.

Also, despite rolling back to Office 2007 and Acrobat 9 (which I used forever), I can't make tables the way I used to, wherein Acrobat would actually recognize the columns as actual columns, and a simple copy and paste was all it took to paste the data with all formatting intact into Excel.  If anyone knows what setting(s) I need, or where I can go to get help, I'd be very grateful.
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

Onisuzume

  • Lieutenant
  • *
  • Posts: 1010
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #109 on: 28 June 2011, 03:42:17 »
OpenOffice, perhaps?

Glory to the Combine Snow Lily Empire!

Daryk

  • Lieutenant General
  • *
  • Posts: 37046
  • The Double Deuce II/II-σ
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #110 on: 28 June 2011, 04:35:20 »
Have you tried "Paste Special"?  It might be an option there...

Hersh67

  • Captain
  • *
  • Posts: 2692
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #111 on: 28 June 2011, 11:23:50 »
Will there be a new location for the Star League set?  I've tried the link and keep getting 404ed.  :(

BigDuke66

  • Master Sergeant
  • *
  • Posts: 233
  • Last of the Wilds!
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #112 on: 28 June 2011, 12:33:31 »
@XOTL
Could you please correct the links to the Vehicles pdf? You have 2x a link to the Excel tables.

Not sure what it is in English but try to copy it with the format, that looks strange in Excel but at least you get each entry in in one line, after that use the Text in column option to split this cell over as many cells as you want.

breakdaddy

  • Sergeant
  • *
  • Posts: 111
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #113 on: 28 June 2011, 16:48:39 »
Thank you for your efforts and for sharing. These tables have been invaluable to me in the short time I've been playing Battletech. I generally prefer playing in 3025 or 3039 so these tables are very useful!

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #114 on: 28 June 2011, 19:08:45 »
Have you tried "Paste Special"?  It might be an option there...

Yeah, that's how I have to do it now: Copy With Formating followed by Paste Special.  The problem is I never had to bother with that: it used to just work.

Will there be a new location for the Star League set?  I've tried the link and keep getting 404ed.  :(

That's because the Star League tables are now (as of v8) in the full document, so I discontinued the separate download.

Could you please correct the links to the Vehicles pdf? You have 2x a link to the Excel tables.

Oops: fixed.

Thank you for your efforts and for sharing. These tables have been invaluable to me in the short time I've been playing Battletech. I generally prefer playing in 3025 or 3039 so these tables are very useful!

Glad I could help.  Thanks!
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

ralgith

  • Captain
  • *
  • Posts: 2251
    • Dylan's BattleTech Emporium
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #115 on: 27 August 2011, 17:09:09 »
1. I love these. Very well done, thanks/kudos to Xotl
2. I love the spreadsheets. Thanks BigDuke66.
3. One Small Problem/Oversight: The spreadsheets are for Excel 2007 and beyond (file format) and while they can be converted in several different ways, they're also incompatible (post-conversion to standard xls) with OpenOffice/LibreOffice because the final VLOOKUP is invalid in the generators for those softwares. Which means you're leaving out a LARGE number of users.

Despite the minor issue of not being able to use the generator, I'm very impressed with the work done here. I'm about 5% done with putting the Mechs into RUS, when I'm done I'll post here.

Xotl

  • Dominus Erratorum
  • BattleTech Developer
  • Lieutenant Colonel
  • *
  • Posts: 11642
  • Professor of Errata
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #116 on: 27 August 2011, 17:15:43 »
Spreadsheets are all BigDuke, so you'll have to see what he says on that.

Thanks for the interest, and I look forward to seeing the results of your work.

Also, on a related note, Netzilla has been kind enough to code everything for MegaMek, so you can use my files in that program.  I'll add the link to the first post, but here it is as well:

http://megamek.info/forums/index.php?topic=217.0

Also, I'll probably put out an update in the next few weeks with a small Quirks update - I'm too busy for much else though I'm afraid.
3028-3057 Random Assignment Tables -
Also contains faction deployment & rarity info.

http://bg.battletech.com/forums/index.php?topic=1219.0

ralgith

  • Captain
  • *
  • Posts: 2251
    • Dylan's BattleTech Emporium
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #117 on: 27 August 2011, 17:21:46 »
Also, on a related note, Netzilla has been kind enough to code everything for MegaMek, so you can use my files in that program.  I'll add the link to the first post, but here it is as well:

This is actually how I found your project to begin with. ;)

BigDuke66

  • Master Sergeant
  • *
  • Posts: 233
  • Last of the Wilds!
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #118 on: 27 August 2011, 18:26:00 »
What do you mean exactly by "invalid"?
Do you get an error message?

ralgith

  • Captain
  • *
  • Posts: 2251
    • Dylan's BattleTech Emporium
Re: 3025-3050 Faction Assignment & Rarity Tables - 27 June v8.06
« Reply #119 on: 27 August 2011, 19:00:35 »
Aye, Error 502. Sorry for forgetting it ;)
I believe its the embedded function call, I can't remember which you were using... started with an I (I can't open the sheets atm to check, or I would)
The suggested work-a-around on the OpenOffice forums is to use INDEX(MATCH()), however this doesn't work across sheets I don't think.

 

Register