Jump to content

Excel Mech Lab V1.80.4 (Updated 9/03/13) Now With Pheonix Inc Saber


398 replies to this topic

#81 3rdworld

    Member

  • PipPipPipPipPipPipPipPipPip
  • 3,562 posts

Posted 08 November 2012 - 11:07 AM

View PostKryptic57, 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.


#82 Aware

    Member

  • PipPipPipPipPip
  • Knight Errant
  • Knight Errant
  • 146 posts
  • LocationCanada

Posted 08 November 2012 - 11:13 AM

Thanks for the update. Love the sheet.

#83 Aware

    Member

  • PipPipPipPipPip
  • Knight Errant
  • Knight Errant
  • 146 posts
  • LocationCanada

Posted 08 November 2012 - 01:03 PM

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

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

#84 Cutsman

    Member

  • PipPip
  • 46 posts
  • LocationChicago

Posted 08 November 2012 - 01:08 PM

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

#85 3rdworld

    Member

  • PipPipPipPipPipPipPipPipPip
  • 3,562 posts

Posted 08 November 2012 - 01:33 PM

View PostAware, 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.

View PostCutsman, 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.

#86 Cutsman

    Member

  • PipPip
  • 46 posts
  • LocationChicago

Posted 08 November 2012 - 01:53 PM

View Post3rdworld, 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.


#87 Deathshade

    Member

  • PipPipPipPipPipPipPip
  • FP Veteran - Beta 1
  • FP Veteran - Beta 1
  • 558 posts
  • Locationplaying Planetary / Community Warfare / Faction Warfare / Faction Play

Posted 08 November 2012 - 02:30 PM

Cool! Great work! :)

#88 Darkblood

    Member

  • PipPipPipPipPipPip
  • The Patron
  • The Patron
  • 370 posts
  • LocationBrazil

Posted 08 November 2012 - 07:07 PM

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.


#89 Kmieciu

    Member

  • PipPipPipPipPipPipPipPipPip
  • Urban Commando
  • Urban Commando
  • 3,437 posts
  • LocationPoland

Posted 09 November 2012 - 12:00 AM

View Post3rdworld, 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.


#90 3rdworld

    Member

  • PipPipPipPipPipPipPipPipPip
  • 3,562 posts

Posted 09 November 2012 - 04:47 AM

View PostDarkblood, 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.

View PostKmieciu, 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.


#91 Wyseman76

    Rookie

  • 6 posts

Posted 09 November 2012 - 07:35 AM

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

#92 Rotaugen

    Member

  • PipPipPipPipPipPipPip
  • 539 posts
  • LocationSouthern CA

Posted 09 November 2012 - 07:47 AM

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.

#93 Marzepans

    Member

  • PipPipPipPipPipPip
  • 273 posts

Posted 09 November 2012 - 08:39 AM

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.


#94 TimoWasTaken

    Member

  • PipPip
  • Bad Company
  • Bad Company
  • 48 posts
  • LocationLake Forest Park, WA, USA

Posted 09 November 2012 - 09:09 AM

Excellent work. Great tool. Sticky please.

#95 TheMightyWashburn

    Member

  • PipPipPipPipPipPip
  • Overlord
  • Overlord
  • 281 posts
  • LocationUSA

Posted 09 November 2012 - 12:19 PM

View PostAware, 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.

#96 3rdworld

    Member

  • PipPipPipPipPipPipPipPipPip
  • 3,562 posts

Posted 09 November 2012 - 12:50 PM

View PostTheMightyWashburn, 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.

#97 Darkblood

    Member

  • PipPipPipPipPipPip
  • The Patron
  • The Patron
  • 370 posts
  • LocationBrazil

Posted 09 November 2012 - 05:05 PM

View Post3rdworld, 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 :)

#98 Kryptic57

    Member

  • PipPipPip
  • 55 posts

Posted 09 November 2012 - 10:21 PM

View Post3rdworld, 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


View Post3rdworld, 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

#99 GODzillaGSPB

    Member

  • PipPipPipPipPipPipPipPipPip
  • 2,030 posts
  • LocationGermany

Posted 10 November 2012 - 03:20 AM

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. ^^

#100 3rdworld

    Member

  • PipPipPipPipPipPipPipPipPip
  • 3,562 posts

Posted 10 November 2012 - 07:51 AM

View PostGODzillaGSPB, 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.






10 user(s) are reading this topic

0 members, 10 guests, 0 anonymous users