398 replies to this topic

[Ethidium]

thanks 3rdworld, I strongly prefer this to the other options

[GodziIIa]

Thanks alot for this! I also prefer this option as opposed to the others. no more pencil and notebook for me! great work!

[DrNick]

Thanks for all your hard work on this spreadsheet 3dWorld!!! Awesome tool for designing a mech that will help me stay alive for WAY longer than when I use a trial mech- now I should be able to live for at least a minute!

Are the hero mechs in there? If not, would it be difficult to add them? (i'm new to the game- do most veterans just not mess with hero mechs?)

[3rdworld]

DrNick, on 21 February 2013 - 05:27 AM, said:

Thanks for all your hard work on this spreadsheet 3dWorld!!! Awesome tool for designing a mech that will help me stay alive for WAY longer than when I use a trial mech- now I should be able to live for at least a minute!

Are the hero mechs in there? If not, would it be difficult to add them? (i'm new to the game- do most veterans just not mess with hero mechs?)

They are in there. For example to work with the Pretty Baby:

Select "Awesome" with the Mech Drop Down. And AWS-PB for the Model.

All of the Heroes can be found in their same Chassis. So Ilya (CTF-IM) in the Cataphract, Death's Knell (COM-TDK) in Commando, Yen Lo Wang (CN9-YLW) in Centurion, Fang (DRG-Fang) and Flame (DRG-Flame) under dragon.

The only really relevant Hero is the Ilya Muromets. The Flame & Wang aren't bad. I would stay way from the Fang, Pretty Baby and The Death's Knell, some of their none hero models for that chassis are as good or better.

In 8's Ilya's are not uncommon. In tournament play I can't remember ever seeing a Hero Mech. If I did I would guarantee it was a Ilya Muromets.

Edited by 3rdworld, 21 February 2013 - 08:22 AM.

[GODzillaGSPB]

GodziIIa, on 20 February 2013 - 06:35 PM, said:

Thanks alot for this! I also prefer this option as opposed to the others. no more pencil and notebook for me! great work!

Damn...I knew I left the door open. My clone escaped!

@3rdworld: Looking forward to new features. Take your time.

Edited by GODzillaGSPB, 21 February 2013 - 01:04 PM.

[DrNick]

Thanks 3rdworld!

Hey, when opening with excel 2010 I get the following unreadable content error:



<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error060400_03.xml</logFileName><summary>Errors were detected in file 'E:\Temp\Mech Lab v1.79.3.xlsm'</summary>-<removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart></removedParts></recoveryLog>


Something on my computer causing this do you think? Is it significant as far as the functionality of the spreadsheet?

[3rdworld]

DrNick, on 21 February 2013 - 06:47 PM, said:

Thanks 3rdworld!

Hey, when opening with excel 2010 I get the following unreadable content error:



<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error060400_03.xml</logFileName><summary>Errors were detected in file 'E:\Temp\Mech Lab v1.79.3.xlsm'</summary>-<removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart></removedParts></recoveryLog>


Something on my computer causing this do you think? Is it significant as far as the functionality of the spreadsheet?

Looks like it is removing the VBA from the file. Ya it is 90% of the functionality. My guess is some sort of virus detection or something like that.

Did you make sure you clicked "enable content"?

Edited by 3rdworld, 21 February 2013 - 08:45 PM.

[DrNick]

3rdworld, on 21 February 2013 - 08:45 PM, said:

Looks like it is removing the VBA from the file. Ya it is 90% of the functionality. My guess is some sort of virus detection or something like that. Did you make sure you clicked "enable content"?

I'm pretty sure I did enable content, and I had to lower the macro security setting too. If I figure out what fixes it, I'll post back.

[DrNick]

DrNick, on 22 February 2013 - 10:51 AM, said:

I'm pretty sure I did enable content, and I had to lower the macro security setting too. If I figure out what fixes it, I'll post back.

I found out why I got that error- I didn't have Visual Basic for Applications installed- once I re-ran Office setup and added this, it worked fine.

Thanks again 3rdworld!

[Goose]

In case 3rdworld didn't think he was appreciated …

[3rdworld]

Excel Mech lab v1.79.4.xlsm

Added the CDA-X5

Also added the Highlander 322b

Edited by 3rdworld, 07 March 2013 - 10:03 AM.

[3rdworld]

Messing around this morning.

I accidentally added the Urbanmech if you want to download to play around with it.

[GODzillaGSPB]

3rdworld, on 10 March 2013 - 11:47 AM, said:

Messing around this morning.

I accidentally added the Urbanmech if you want to download to play around with it.

HA. Brilliant accident. Will give it a go and build the UBER-URBIE! xD

[MustrumRidcully]

3rdworld, on 10 March 2013 - 11:47 AM, said:

Messing around this morning.

I accidentally added the Urbanmech if you want to download to play around with it.

How did this happen accidentally?

In the end, it must now be in the game's code since the Jagermech is coming. We all know that the Jagermech is just a power armour for the Urbanmech.

[3rdworld]

Excel Mech Lab v1.79.5.xlsm

Updated the Jager Mech Hardpoints

MustrumRidcully, on 18 March 2013 - 12:00 AM, said:

How did this happen accidentally?

In the end, it must now be in the game's code since the Jagermech is coming. We all know that the Jagermech is just a power armour for the Urbanmech.

Actually I was playing around with it, and it was so much work to put it in, I decided to share.

[Goose]

So there was a change to heat …

[3rdworld]

Goose, on 19 March 2013 - 12:24 PM, said:

So there was a change to heat …

?

[Goose]

Someone had said, the patch-before-last, that heat for some lasers had changed; I then took a Jenner-F onto the training grounds, and would overheat on the forth salvo instead of the seventh, like your sheet said.

At the time of that last post, I though the new sheet was telling me any such Jenner did indeed have less salvos, but I was miss reading it …

[Ethidium]

Thanks for the hard work as always!

[3rdworld]

If you would like the updated missile damage please re-download.

I have also added the Highlander Rhonda Snord based on the recent trailer. I don't know that the loadout is 100% accurate, but I tried to get it as close as possible.