398 replies to this topic

[3rdworld]

Kryptic57, on 08 November 2012 - 10:55 AM, said:

@ V1.72

Ravens are capped to 245 in the sheet but I believe their true cap is up to a 300 engine, same as the jenner. CDA-3C the single energy hard point is in the right torso not the left.

They must have changed the Ravens. They had been reduced to the computed cap (175*1.4)=245 or the 3L (210*1.4)=295. You are saying the reverted it back to all of them can use a 300 again?

I'll check out the CDA-3C

Edited by 3rdworld, 08 November 2012 - 11:08 AM.

[Aware]

Thanks for the update. Love the sheet.

[Aware]

Dmg/15 secs
Dmg/30 sec
Dmg/1 min
Dmg/15 min

All of those don't seem to be calculating correctly.

[Cutsman]

FYI, the AS7-K is coming up with an XL330 engine when it comes stock with a XL300.

[3rdworld]

Aware, on 08 November 2012 - 01:03 PM, said:

Dmg/15 secs
Dmg/30 sec
Dmg/1 min
Dmg/15 min

All of those don't seem to be calculating correctly.

You're right, I am going to have to take a look at it, all these HS changes are killing me!

Probably tomorrow, after I hear word on whether the bugged EHS are intended or not.

Cutsman, on 08 November 2012 - 01:08 PM, said:

FYI, the AS7-K is coming up with an XL330 engine when it comes stock with a XL300.

That is just the engine that the sheet was saved with. It does not update the engine or stock variants when you switch, you have to do it manually.

[Cutsman]

3rdworld, on 08 November 2012 - 01:33 PM, said:

That is just the engine that the sheet was saved with. It does not update the engine or stock variants when you switch, you have to do it manually.

Ah, I see, my mistake!

Edited by Cutsman, 08 November 2012 - 01:53 PM.

[Deathshade]

Cool! Great work!

[Darkblood]

Thanks for the MWO-like heat efficiency


I've been using your export/import string to pass configurations from one file to another. But it seems you included something else there:

[v1.71] :

80011,18,60,38,48,20,48,20,48,48,66,66,203,103,101,103,103,103,103,103,103,103,103,103,402,103,103,101,101,101,101,101,101,103,103,103,201,903,903,402,103,103,101,101,101,101,101,101,103,103,103,101,101,103,103,103,103,103,103,103,103,103,103,101,101,101,101,103,103,103,103,103,103,a1,b3,c3,d2,e0,f0,g0,h0,i0,j0,k0,l0,1240

[v1.72]:

80011,18,60,38,48,20,48,20,48,48,66,66,203,0,101,0,0,0,0,0,0,0,0,0,402,0,0,101,101,101,101,101,101,0,0,0,201,903,903,402,0,0,101,101,101,101,101,101,0,0,0,101,101,0,0,0,0,0,0,0,0,0,0,101,101,101,101,0,0,0,0,0,0,a1,b3,c3,d2,e,f,g,h,i,j,k,l,1240

There's an extra number in the second one. In which position should I insert a zero (or any other number if that matters) in order to be able to import my configs in the new sheet?

Edited by Darkblood, 08 November 2012 - 07:24 PM.

[Kmieciu]

3rdworld, on 08 November 2012 - 01:33 PM, said:

You're right, I am going to have to take a look at it, all these HS changes are killing me!

Probably tomorrow, after I hear word on whether the bugged EHS are intended or not.

Would you kindly externalize the EHS and DHS parameters in your spreadsheet? It would be cool if we could play with the numbers and find out exactly how changing the heat dissipation affects out builds?

After the last hotfix EHS are still 2.0 and DHS 1.4 (both heat dissipation per 10 seconds and heat threshold), so these should be the default numbers.

BTW:

AC10 has heat="3.0" cooldown="2.5 now.

Edited by Kmieciu, 09 November 2012 - 03:27 AM.

[3rdworld]

Darkblood, on 08 November 2012 - 07:07 PM, said:

Thanks for the MWO-like heat efficiency


I've been using your export/import string to pass configurations from one file to another. But it seems you included something else there:

[v1.71] :

80011,18,60,38,48,20,48,20,48,48,66,66,203,103,101,103,103,103,103,103,103,103,103,103,402,103,103,101,101,101,101,101,101,103,103,103,201,903,903,402,103,103,101,101,101,101,101,101,103,103,103,101,101,103,103,103,103,103,103,103,103,103,103,101,101,101,101,103,103,103,103,103,103,a1,b3,c3,d2,e0,f0,g0,h0,i0,j0,k0,l0,1240

[v1.72]:

80011,18,60,38,48,20,48,20,48,48,66,66,203,0,101,0,0,0,0,0,0,0,0,0,402,0,0,101,101,101,101,101,101,0,0,0,201,903,903,402,0,0,101,101,101,101,101,101,0,0,0,101,101,0,0,0,0,0,0,0,0,0,0,101,101,101,101,0,0,0,0,0,0,a1,b3,c3,d2,e,f,g,h,i,j,k,l,1240

There's an extra number in the second one. In which position should I insert a zero (or any other number if that matters) in order to be able to import my configs in the new sheet?

I think it would need a ,0, before the a1 reference. I added in another parameter to pick up all the upgrades. Sorry about that should have mentioned that in the change log.

Kmieciu, on 09 November 2012 - 12:00 AM, said:

Would you kindly externalize the EHS and DHS parameters in your spreadsheet? It would be cool if we could play with the numbers and find out exactly how changing the heat dissipation affects out builds?

After the last hotfix EHS are still 2.0 and DHS 1.4 (both heat dissipation per 10 seconds and heat threshold), so these should be the default numbers.

BTW:

AC10 has heat="3.0" cooldown="2.5 now.

I was hoping to get some sort of Dev confirmation or the like. What do you mean by externalize? somewhere for you to input different dissipation values?

I will update the AC/10. Thanks for the catch.

Edited by 3rdworld, 09 November 2012 - 06:22 AM.

[Wyseman76]

Do you have any plans to have the default armor values show up when selecting various mechs to work on?

[Rotaugen]

If I could like this 100 times, I would. Now I spend more time in this than ingame! Thanks to you, and everyone you listed on the credits tab. I'm glad you gave credit where credit is due.

[Marzepans]

Looks like Engine Heat Sinks are functioning as doubles, at least the first ten are.

Edit: In game I meant, not in the spreadsheet

Edited by Marzepans, 09 November 2012 - 09:26 AM.

[TimoWasTaken]

Excellent work. Great tool. Sticky please.

[TheMightyWashburn]

Aware, on 08 November 2012 - 01:03 PM, said:

Dmg/15 secs
Dmg/30 sec
Dmg/1 min
Dmg/15 min

All of those don't seem to be calculating correctly.

Indeed, my 30s, 1m, and 15m are all the same. And those are what I use to reckon my mech setup. I love this btw!

I use these to determine if I a mech is more first engagement effective or long term effective. The lighter the more (dmg/30s)/ton I want (if im harassing) and so on.

[3rdworld]

TheMightyWashburn, on 09 November 2012 - 12:19 PM, said:

Indeed, my 30s, 1m, and 15m are all the same. And those are what I use to reckon my mech setup. I love this btw!

I use these to determine if I a mech is more first engagement effective or long term effective. The lighter the more (dmg/30s)/ton I want (if im harassing) and so on.

Well they could be all the same in theory. If you run out of ammo after 30sec of firing, you will not do any more damage after a minute than you did after 30secs.

But ya, they are messed up. I would have them fixed but work is killing me atm.

[Darkblood]

3rdworld, on 09 November 2012 - 04:47 AM, said:

I think it would need a ,0, before the a1 reference. I added in another parameter to pick up all the upgrades. Sorry about that should have mentioned that in the change log.

No problem man! Thanks for the great work

[Kryptic57]

3rdworld, on 08 November 2012 - 11:07 AM, said:

They must have changed the Ravens. They had been reduced to the computed cap (175*1.4)=245 or the 3L (210*1.4)=295. You are saying the reverted it back to all of them can use a 300 again?

I'll check out the CDA-3C

3rdworld, on 08 November 2012 - 11:07 AM, said:

They must have changed the Ravens. They had been reduced to the computed cap (175*1.4)=245 or the 3L (210*1.4)=295. You are saying the reverted it back to all of them can use a 300 again?

I'll check out the CDA-3C

Hmm you are right about the engine sizes

[GODzillaGSPB]

There seems to be some kind of bug with the crit-remaining-calculation. I was working on a Hunchback 4SP and got 4 crits left, with Endo-Steel enabled. I saved inside the document and loaded another variant ("Load Mech 2") of the same 4SP model which then showed me 0 crits left. I was shure there were some left before. And when I then loaded the first configuration again ("Load Mech 2") it showed 0 crits left, too. Remember, it was the one from the beginning with 4 left.

I then save and exit the whole document. I load it again and voilá, my 4 crits left are back. But only as long as I load up another config inside the document.

Sometimes it bugs out so strange that it shows me "-3 crits left" and the whole configuration in red. This was again for the config which has normally 4 crits left...

Hope my description helps in tracking down the bug. Just say the word if you need more testing. ^^

[3rdworld]

GODzillaGSPB, on 10 November 2012 - 03:20 AM, said:

There seems to be some kind of bug with the crit-remaining-calculation. I was working on a Hunchback 4SP and got 4 crits left, with Endo-Steel enabled. I saved inside the document and loaded another variant ("Load Mech 2") of the same 4SP model which then showed me 0 crits left. I was shure there were some left before. And when I then loaded the first configuration again ("Load Mech 2") it showed 0 crits left, too. Remember, it was the one from the beginning with 4 left.

I then save and exit the whole document. I load it again and voilá, my 4 crits left are back. But only as long as I load up another config inside the document.

Sometimes it bugs out so strange that it shows me "-3 crits left" and the whole configuration in red. This was again for the config which has normally 4 crits left...

Hope my description helps in tracking down the bug. Just say the word if you need more testing. ^^

Thanks, the legs were just checking to see if the value was blank. When you load a mech it puts a "-" in there, so it was counting it as a crit. The effect was losing 4 crits when you loaded a mech because of the 4 spots in the legs (wouldn't happen if you actually had equipment in there).

the upcoming v1.73 has been corrected. Thanks for the find! BTW I am working on the code to clear the "-" out of the mech when you load, I think it will look cleaner.


Edit: Wow that was actually really simple. It makes me cry to see how easy some of these things really are with VBA.

Edited by 3rdworld, 10 November 2012 - 08:30 AM.