398 replies to this topic

[3rdworld]

Excel Mech Lab v1.79.6.xlsm

HGH-HM (previously HGH-732RS)

• updated stock loadout
  
• increased engine limit (730 vs 725)

[Sly Sly]

Thx for updating. Best tool around!

Would love to see DPS/ton in weapon stats.

[3rdworld]

Sly Sly, on 02 April 2013 - 01:37 PM, said:

Thx for updating. Best tool around!

Would love to see DPS/ton in weapon stats.

on the weapon groups or weapon lookup or both?

[RockWolf]

Srms are not the right slot size!

[3rdworld]

RockWolf, on 06 April 2013 - 12:55 AM, said:

Srms are not the right slot size!

Verify your artemis upgrade on the sheet and the mech you are looking at.

[Jalthibuster]

neeeeeed! update please

[Goose]

He'll get to it!

Jeez …

[3rdworld]

Sorry about that guys. We had some pretty bad storms last night and I did not get a chance to post it.

Excel Mech Lab v1.79.7.xlsm

• Added HGN-733C & HGN-733P
  
• Updated Highlander Hardpoints.

[Jalthibuster]

Thank you for your good work, Sir!

[3rdworld]

Just giving a heads up.

I am currently working on adding Clan tech. I don't plan on adding any clan mechs ATM as I don't know how they are going to handle omni pods. (my guess capped on crit size). But without any info I don't feel like putting in tons of work without any guarantee it will be of any use or even comparable to in game mechanics.

Any how. When v1.80.0 comes you guys should be able to mount clan weapons and upgrades on your mech.

[Ethidium]

Cool, keep up the good work!

[Sigmund Floyd]

did you really have to lock the spreadsheet?

[3rdworld]

Sigmund Floyd, on 26 April 2013 - 07:01 AM, said:

did you really have to lock the spreadsheet?

No. The lock just lets you move around without messing up formulas and such (they are everywhere and the seem to be breeding).

Also it is to hide the 800+ rows of embarrassment. To make it compatible with 2007, I had to conglomerate things into a giant mess. At this point I don't really feel like cleaning it up, it is the dirty dog, I have accepted that I must live with until it dies.

Edited by 3rdworld, 26 April 2013 - 02:15 PM.

[3rdworld]

Updated for the Misery.

No new version, just re-download if you want the Misery.

[3rdworld]

Excel Mech Lab v1.80.0.xlsm

Alright guys, the first big update in a while.

Clan Tech!

Below the upgrades section you will see at "tech" dropdown. Select "Clan" and now all your weapons & upgrades have the stats of their clan counterparts.

Note: Do not use upgraded versions of the weapons. Example: If you want a Clan UAC/20, just select Clan on the tech section and install an AC/20, it will produce the size and damage of a clan UAC/20.

Likewise ERPPCs, UAC/5 and SSRM-2 are all their IS stats, to get clan versions select the non-lostech version, ie. PPC, AC/5, SRM-2 with "Clan" selected in the tech dropdown.

Enjoy!

PS: Let me know if you see weapons that don't change to the correct size when selecting Clan tech. or any bugs from loading/ saving variants.

Thanks.

[Goose]

O_o

[Kiiyor]

This is very, very nice!

Issue: Clan ERPPCs take up 2 crit slots, not three, and weigh 6 tonnes.

Edit: I think the UACs are off in tonnage and crits too, the clan version of the UAC5 takes up 3 slots and weighs 7 tonnes.

Ah, makes me remember how nightmarish clan tech is. I can get 4 clan ERPPCs in my Awesome 9M. The Yager can mount 4 clan UAC5s and a few ERMLAS and be viable. Sweet Jesus

I also can't get the other clan tech to load in the dropdown lists - UAC2s and the like. The other tech seems to change. Am I doing it wrong?

Edited by Kiiyor, 09 May 2013 - 06:42 AM.

[3rdworld]

Kiiyor, on 09 May 2013 - 06:36 AM, said:

This is very, very nice!

Issue: Clan ERPPCs take up 2 crit slots, not three, and weigh 6 tonnes.

Edit: I think the UACs are off in tonnage and crits too, the clan version of the UAC5 takes up 3 slots and weighs 7 tonnes.

Ah, makes me remember how nightmarish clan tech is. I can get 4 clan ERPPCs in my Awesome 9M. The Yager can mount 4 clan UAC5s and a few ERMLAS and be viable. Sweet Jesus

I also can't get the other clan tech to load in the dropdown lists - UAC2s and the like. The other tech seems to change. Am I doing it wrong?

Ya. Don't select lostech versions for clans. To get a Clan UAC/2 select "Clan" in the tech, and install a regular AC/2, it will have clan weight and clan size & DPS.

Like the ERPPC in your question. To get a Clan ERPPC, install a standard PPC with the Clan option selected. Hope this clears it up. To get a Clan UAC/5 select an AC/5. I know it is confusing. At the time I put it in, it seemed to be the best way.

[Goose]

But the problem is the two weapon-stat drop-downs don't seem to respond to the tech-base drop-down.

Thanks for the update, all the same …

[3rdworld]

Goose, on 09 May 2013 - 07:10 AM, said:

But the problem is the two weapon-stat drop-downs don't seem to respond to the tech-base drop-down.

Thanks for the update, all the same …

Okay, the PPC was messed up. That should be fixed. redownload for the correct stats.

I can make it change the names, the problem comes that when you switch tech bases it produces #N/A results when the names change.

Thanks