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

BigDuke66 · « **Reply #120 on:** 28 August 2011, 05:58:34 »

Makes me scratch my head, not sure but I think the using of a defined name for the area that should be searched is the problem, looks like OO wants a normal defined area A:2;D:30 for example but I don't have a clue how I should work that in as the name is needed for defining a sheet at all.

Best way to solve this is go to the official OO forum and show them the file, maybe they have an idea and if so you can try it right away and check if it works, if you find something I will see if I can incorporate it so that the file runs like it should in Excel & OpenOffice.
Sorry for not being any help.

Daryk · « **Reply #121 on:** 28 August 2011, 06:37:14 »

The AToW spreadsheet I built does look ups on a different worksheet and works fine in Open Office. I used the 'worksheetname'!<range> notation, and it translated like a champ.

ralgith · « **Reply #122 on:** 28 August 2011, 08:55:42 »

Yeah, I know nothing about the formulas or anything ;)

Also, I'm not a member of the OO.org forums... so I'd have to join to ask. Maybe later this week when I'm not busy. Thanks for looking into it though.

Onisuzume · « **Reply #123 on:** 29 August 2011, 09:49:45 »

Quote from: BigDuke66 on 28 August 2011, 05:58:34

Makes me scratch my head, not sure but I think the using of a defined name for the area that should be searched is the problem, looks like OO wants a normal defined area A:2;D:30 for example but I don't have a clue how I should work that in as the name is needed for defining a sheet at all.

Best way to solve this is go to the official OO forum and show them the file, maybe they have an idea and if so you can try it right away and check if it works, if you find something I will see if I can incorporate it so that the file runs like it should in Excel & OpenOffice.
Sorry for not being any help.

Couldn't you just make the thing in OpenOffice instead?

ralgith · « **Reply #124 on:** 29 August 2011, 10:30:57 »

I've posted on OO.o forums:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=43617

Hopefully they come back with an answer quickly!

ralgith · « **Reply #125 on:** 29 August 2011, 19:11:54 »

BigDuke, I can't make heads nor tails of the stuff they're rambling on about. Perhaps you could (assuming you can work past the insults about us spending more time gaming than on perfecting our skills at spreadsheets) figure out what they're trying to say and work it into the sheets so that they function correctly. Thanks :|

BigDuke66 · « **Reply #126 on:** 29 August 2011, 19:56:31 »

I get the feeling they didn't even look exactly how the generator page work or else they would make such obvious wrong statements.
I think I'll approach it a different way, I go into a German OO forum and see if someone can help me there.

ralgith · « **Reply #127 on:** 29 August 2011, 20:22:48 »

Actually, I've got it worked out. I sifted through all their bull**** and figured out what was wrong.
You're missing some defines. When the one guy talks about doing ctrl-F3 and not seeing anything defined for MerPerGen30283050 I realized you didn't have data ranges defined for those things. Once I started defining data ranges for them, it worked just fine. I'm almost done with the mech sheet now. I also added an enhancement for when you select the wrong Era it gives you an Incorrect Era message in place of the generic error of the software. Do you want me to just post the links to the corrected files here, or do you want me to PM the links to you directly?

BigDuke66 · « **Reply #128 on:** 29 August 2011, 20:37:57 »

Good to hear, yes please pm the links to me I would like to take a look at what you have done.
You also should pm them to XOTL so he can put them in the first post so OO users will find them where it is best.

ralgith · « **Reply #129 on:** 29 August 2011, 20:40:36 »

Will do, and its OO.o, LibreOffice, StarOffice, Gnumeric, and Excel 2000/XP/2K3 (This is the file format I used)
I've got 3 more sheets to do, and then all the incorrect era settings... unless I skip doing those for now to get a working set of sheets out for those of us who have these other office softwares ;)

ralgith · « **Reply #130 on:** 30 August 2011, 16:40:53 »

File link sent by PM, so those others waiting for it will hopefully see it soon.

Xotl · « **Reply #131 on:** 31 August 2011, 05:31:09 »

I've replaced the mech file in the first post with the one adjusted by ralgith to work on OpenOffice and the like. Give it a try and let me know if something isn't working for you.

Thanks ralgith.

EDIT: Also, Battlemaster, who is involved with the MegaMek project, was kind enough to offer to insert Netzilla's conversion of my tables into MegaMek itself, so soon you won't need to download them separately. Big thanks to Battlemaster.

Sandslice · « **Reply #132 on:** 04 September 2011, 19:48:41 »

A quick question, which came up due to Netzilla's conversions.

Given the way BT's core rules tend to use "F is better" (maintenance in Strat Ops, availability tables from TM/TO/aToW, etc) what led you to use "A is better" ? I'm thinking Dragoon rating, but I'm not sure. :)

Xotl · « **Reply #133 on:** 04 September 2011, 19:53:49 »

That's the more modern usage. A = best reflects the older Field Manual usage, which is the series of books I'm referring to in my tables anyways.

Sandslice · « **Reply #134 on:** 04 September 2011, 19:54:56 »

Quote from: Xotl on 04 September 2011, 19:53:49

That's the more modern useage. A = best reflects the older Field Manual useage, which is the series of books I'm referring to in my tables anyways.

Ahh, makes sense then. Thanks! :)

ralgith · « **Reply #135 on:** 04 September 2011, 19:56:43 »

Xotl,

Have you, or are you, considered doing AeroSpace tables as well? AeroSpace tables in general are very lacking imo, and I'd like to see them done in your style.

Xotl · « **Reply #136 on:** 04 September 2011, 20:29:14 »

I've been asked a few times, but I'm still of the opinion that, when you break the available aerospace fighters down by era and faction and weight class, that there's too few to really make a useful series of tables. As such, I've never had the intention of making them.

greywolf79 · « **Reply #137 on:** 29 December 2011, 16:04:22 »

I think I said this before but it is worth saying again...

This is awesome! Also, thanks a ton for the hard work. I had a system restore and lost the original copy I downloaded so now I have it again... I love it.

1 quick question though... Is there any plans on expanding it with newer designs/TRO units?

Xotl · « **Reply #138 on:** 29 December 2011, 16:34:01 »

I have a tiny revision lying around with just a few quirk updates and a fixed typo or two that I might send up in the next few days. As for more than that...

Our forum's own Cyttorak offered to take care of the 3050 Inner Sphere tables for me, which is the next series to be done. I'd done preliminary work on them, but he has done about 95% of the work so far and has them finished. However, I've yet to proof them, which I feel is needed in order to keep a consistent vision. He's been patiently waiting for me to get to it.

It's not so much that I don't have the time as it is that I don't have the Battletech time - I only want to donate so much of my life to this game. I spent weeks working on RATs for FM 3085 and another project, and have 50 pages of TacOps errata to go through, plus general errata duties and some other stuff I can't talk about. I'd really like to move on with this, which got me started with Catalyst in the first place, but it's easy to burn out, and I want to avoid that. Grad school and my fiancee must take priority.

Thanks for your interest.

Hersh67 · « **Reply #139 on:** 29 December 2011, 21:09:03 »

Quote from: Xotl on 29 December 2011, 16:34:01

It's not so much that I don't have the time as it is that I don't have the Battletech time - I only want to donate so much of my life to this game. I spent weeks working on RATs for FM 3085 and another project, and have 50 pages of TacOps errata to go through, plus general errata duties and some other stuff I can't talk about. I'd really like to move on with this, which got me started with Catalyst in the first place, but it's easy to burn out, and I want to avoid that. Grad school and my fiancee must take priority.

Thanks for your interest.

I'll echo the thanks and appreciation for what you did. I'm glad it got you noticed by CGL and put you in a position to make this universe a better one. By all means, school and the lady take priority! If you take care of them as well as you did the tables, you will have a successful life.

ANS Kamas P81 · « **Reply #140 on:** 29 December 2011, 22:20:16 »

Quote from: Xotl on 29 December 2011, 16:34:01

Thanks for your interest.

BZZZZZT

We are the ones who have YOU to thank for the incredible efforts.

Xotl · « **Reply #141 on:** 30 December 2011, 01:12:38 »

I've posted that minor update I discussed: just a typo fix or two and a few quirks updates I've noted down over the past few months, mostly dealing with the new stuff from TR Prototypes.

EDIT: The latest versions of BigDuke's spreadsheets have also been added - OpenOffice compatibility has been improved.

Cheers.

Daryk · « **Reply #142 on:** 30 December 2011, 06:55:30 »

So what do we have to do to get this thread a sticky? Your RATs may be fanon, but they're fanon that got you noticed by TPTB. Maybe a sticky at the top of one of the Fan Boards would be less objectionable? As always, thanks for your great work!

skiltao · « **Reply #143 on:** 30 December 2011, 13:46:17 »

Quote from: Xotl on 29 December 2011, 16:34:01

as it is that I don't have the Battletech time - I only want to donate so much of my life to this game. <snip> it's easy to burn out, and I want to avoid that. Grad school and my fiancee must take priority.

No kidding. Here's hoping that your other duties go smoothly for you in the meantime.

BigDuke66 · « **Reply #144 on:** 31 December 2011, 18:53:18 »

Finally found time to make the Excel files compatible with OpenOffice(at least I hope it works now, if not please tell me).
Here are the files for the XOTLs 8.07:
Mechs 8.07 PDF: http://www.mediafire.com/?ncc44gm84800j9a
Mechs 8.07 Excel: http://www.mediafire.com/?y2vrog2q2ru7oyp
Vehicles 8.07 PDF: http://www.mediafire.com/?h1t6x4knuh64h79
Vehicles 8.07 Excel: http://www.mediafire.com/?903ad0qf1dguz1j

Not sure if this Hoster is good so if anyone knows a better place please post.

Styker · « **Reply #145 on:** 01 February 2012, 15:33:46 »

Any chance you might consider doing any earlier tables for the succession wars? The 1st, 2nd, and 3rd have no tables that I'm aware of for these periods.

Xotl · « **Reply #146 on:** 01 February 2012, 16:02:59 »

Not likely: there's even less info there than for the Star League era, which is pretty spotty as it is.

It would be fun as a totally make-stuff-up exercise, but I generally prefer to have more canon backing, and other eras need to take priority anyways. Hell, I just found I have more updates to do for the lists I already have out.

Kit deSummersville · « **Reply #147 on:** 01 February 2012, 16:20:17 »

Quote from: Daryk on 30 December 2011, 06:55:30

So what do we have to do to get this thread a sticky? Your RATs may be fanon, but they're fanon that got you noticed by TPTB. Maybe a sticky at the top of one of the Fan Boards would be less objectionable? As always, thanks for your great work!

Edgads! Next you'll be suggesting my fanfic from rec.games.mecha be stickied because that's how I was noticed. ;)

Daryk · « **Reply #148 on:** 01 February 2012, 19:30:29 »

Not necessarily... as good as that fanfic may be (never having read it), it doesn't exactly have direct application in game, like Xotl's RATs do.

snowridr · « **Reply #149 on:** 05 April 2012, 21:23:42 »

Just curious to know if there has been any progress on the 3050 charts, or if this will be handed off to someone else. The charts have been the basis of mech and vehicles for our local Battletech 3040 era+ campaign and have been extremely useful.

Thanks again.