398 replies to this topic

[Darwins Dog]

Thanks for this! I only wish I knew about it a month ago. It would have saved a couple million cbills.

One thing I noticed:
The Centurion AL stock build only shows 49.56 tons used. I don't know what/ if anything is missing.

[3rdworld]

Darwins Dog, on 05 December 2012 - 09:54 AM, said:

Thanks for this! I only wish I knew about it a month ago. It would have saved a couple million cbills.

One thing I noticed:
The Centurion AL stock build only shows 49.56 tons used. I don't know what/ if anything is missing.

Nothing is missing. That mech comes stock with Full armor which works out to a wonky tonnage. 338/32 = 10.5625 tons. That is why it appears to be .44 tons light. There are a couple of them like that.

[AlexWildeagle]

Thanks 3rdworld. A lot of work you do for this.

ECM shows up for most mechs?

[Kmieciu]

3rdworld, on 05 December 2012 - 07:26 AM, said:

EDIT: Just thought of this, how about a display that shows all save mech data? then you could just look for the mech you want?

That would be even better!

[3rdworld]

AlexWildeagle, on 05 December 2012 - 12:04 PM, said:

Thanks 3rdworld. A lot of work you do for this.

ECM shows up for most mechs?

It should be showing up on all mechs. I haven't add a check to see if the mech is capable of mounting it yet.

[GODzillaGSPB]

I'd like to suggest a feature / addition:

When I change configurations it's a bit of a discomfort having to type the name of that configuration again and again, every time I change something and save it.

Instead it should take the current name as the standard instead of an empty field, so if I don't intend to change the name I can just click "ok" and be done with it.

What do you think?

Another idea would be a "quicksave" button, which simply saves the current changes to the save and name that is active. It should be, however, a few fields away from the normal save button as to avoid accidentical overwriting of saves. But it would allow for quick changes and quick saving them.

[3rdworld]

GODzillaGSPB, on 05 December 2012 - 01:07 PM, said:

I'd like to suggest a feature / addition:

When I change configurations it's a bit of a discomfort having to type the name of that configuration again and again, every time I change something and save it.

Instead it should take the current name as the standard instead of an empty field, so if I don't intend to change the name I can just click "ok" and be done with it.

What do you think?

Another idea would be a "quicksave" button, which simply saves the current changes to the save and name that is active. It should be, however, a few fields away from the normal save button as to avoid accidentical overwriting of saves. But it would allow for quick changes and quick saving them.

How about it auto fills with the previous description?

[3rdworld]

Kmieciu, on 05 December 2012 - 12:37 PM, said:

That would be even better!

If you redownlaod it will have it on the "Saves" sheet.

Just a note: I will be adding the ability to import all previous version saves once I release 1.77.

If you have 24 saves I can imagine not wanting to bring them over or redo them 1 at a time.

3rdworld, on 05 December 2012 - 02:03 PM, said:

How about it auto fills with the previous description?

It will do this now.

Edited by 3rdworld, 05 December 2012 - 02:37 PM.

[GaussDragon]

Why hasn't this been pinned?

[Kmieciu]

3rdworld, on 05 December 2012 - 02:36 PM, said:

If you redownlaod it will have it on the "Saves" sheet.

Just a note: I will be adding the ability to import all previous version saves once I release 1.77.

If you have 24 saves I can imagine not wanting to bring them over or redo them 1 at a time.

It will do this now.

You read my mind, man! You even added the default description when overwriting a save. Before I asked for it :-)

[GODzillaGSPB]

3rdworld, on 05 December 2012 - 02:03 PM, said:

How about it auto fills with the previous description?

Not sure...but I think that's what I meant. You just managed something I can't: Be specific, short sentences, to the point.

[Springbok]

Thanks for this - it is extremely helpful and I use it constantly! Keep up the good work.

Questions: Maybe I'm just missing it but is there a way to see the number of shots per ton of ammo?

and...9000+ views and no sticky? C'mon mods... do it!

[3rdworld]

Springbok, on 06 December 2012 - 11:09 AM, said:

Thanks for this - it is extremely helpful and I use it constantly! Keep up the good work.

Questions: Maybe I'm just missing it but is there a way to see the number of shots per ton of ammo?

and...9000+ views and no sticky? C'mon mods... do it!

no, I will try to get it added though.

[Temptis]

another minor bug,
DPS Value for Large Laser and ER Large Laser is to low,
9 DMG 3.25 CD -> 2.77 dps
the sheet calculates with 2.12 for some odd reason
same for LPL
10 DMG 3.25 CD -> 3.07 dps, listed is 2.50

Edith says:
SL 3 damage 2.25 CD -> 1.33, listed as 1.0
SPL 3 damage, 2.25 CD -> 1.33 listed as 1.09
ML 5 damage, 3.0 CD -> 1.66 listed as 1.50
MPL 6 damage, 3.0 CD -> 2.0 listed as 1.6
Flamer 0.4 damage 0.5 CD -> 0.8 listed as 0.4

Balistiic and LRM are correct

Edited by Temptis, 07 December 2012 - 03:37 AM.

[3rdworld]

Temptis, on 07 December 2012 - 01:47 AM, said:

another minor bug,
DPS Value for Large Laser and ER Large Laser is to low,
9 DMG 3.25 CD -> 2.77 dps
the sheet calculates with 2.12 for some odd reason
same for LPL
10 DMG 3.25 CD -> 3.07 dps, listed is 2.50

Edith says:
SL 3 damage 2.25 CD -> 1.33, listed as 1.0
SPL 3 damage, 2.25 CD -> 1.33 listed as 1.09
ML 5 damage, 3.0 CD -> 1.66 listed as 1.50
MPL 6 damage, 3.0 CD -> 2.0 listed as 1.6
Flamer 0.4 damage 0.5 CD -> 0.8 listed as 0.4

Balistiic and LRM are correct

As Thontor said

Those DPS numbers you list are not taking duration into consideration. I don't know what edith is, but their numbers are wrong.

[Temptis]

Thontor, on 07 December 2012 - 04:58 AM, said:

lasers cooldown doesn't start until after they are finished firing, so their true cooldown is duration+cooldown

uh didn't know that, thanks for the correction.
than only the Flamer is wrong (it has a "beam" duration of 0.5 and a cooldown of 0.5 that starts right away, i.e. you can continualy fire it)

3rdworld, on 07 December 2012 - 05:25 AM, said:

I don't know what edith is, but their numbers are wrong.

Edit is the name of the girl that gets mentioned when you alter a post, it's just spelled wrong

Edited by Temptis, 07 December 2012 - 06:16 AM.

[3rdworld]

Temptis, on 07 December 2012 - 06:14 AM, said:

uh didn't know that, thanks for the correction.
than only the Flamer is wrong (it has a "beam" duration of 0.5 and a cooldown of 0.5 that starts right away, i.e. you can continualy fire it)




Edit is the name of the girl that gets mentioned when you alter a post, it's just spelled wrong

The Flamer is just kind of a place holder right now. You cannot divide by zero or infinity, so I just calculated them with a half second CD and figured their DPS/HPS to be the same as their dmg & heat.

[Al Bert]

when i try opening the file, first message i get is "Excel found unreadable content in [...] Do you want to restore [..]?". so i trust the author here and click YES, Excel responds with a repair message like "removed dataset: .../xl/woekbook.xml-Part [...]

I researched a bit on the web and found out it has to do with different language packages (i have a german version of excel 2010). The general advice was to avoid names which start with something like „Cx“, „Rx“ and „Lx“ were "x" is a number. Also, compatibility mode was suggested to be used. Here is the (german) site i found these informations http://www.excel-tic...n-und-sprachen/

I will test the nice tool anyway and try to watch out for potential errors

Al Bert

[CosMoe]

Thanks for this great tool, helped me a lot to find out nice builds.

[3rdworld]

Al Bert, on 08 December 2012 - 08:20 AM, said:

when i try opening the file, first message i get is "Excel found unreadable content in [...] Do you want to restore [..]?". so i trust the author here and click YES, Excel responds with a repair message like "removed dataset: .../xl/woekbook.xml-Part [...]

I researched a bit on the web and found out it has to do with different language packages (i have a german version of excel 2010). The general advice was to avoid names which start with something like „Cx“, „Rx“ and „Lx“ were "x" is a number. Also, compatibility mode was suggested to be used. Here is the (german) site i found these informations http://www.excel-tic...n-und-sprachen/

I will test the nice tool anyway and try to watch out for potential errors

Al Bert

That is going to be an issue. The formulas produce Named ranges based on Hardpoints and weapons selected so far.

These have the format of E2B1A0, which would mean: 2 Energy, 1 Ballistic, 0 AMS. If converting from English-> German has trouble with that sort of name, I cannot do much to help you.

Sorry.