Excel Mech Lab V1.80.4 (Updated 9/03/13) Now With Pheonix Inc Saber
#201
Posted 11 December 2012 - 08:52 AM
You sure this a real issue, Al Bert?
#202
Posted 12 December 2012 - 07:13 PM
#203
Posted 13 December 2012 - 07:16 AM
I have one request: Could you add in something that shows how much ammo per ton a weapon has?
I understand if not, I don't know how easy it would be to do.
Thanks again!
#204
Posted 13 December 2012 - 08:36 AM
Darwins Dog, on 13 December 2012 - 07:16 AM, said:
Ya, I can add it. Just never thought about it, but shouldn't be hard.
You will see it in the next version after the patch on the 18th.
#205
Posted 13 December 2012 - 07:59 PM
#206
Posted 14 December 2012 - 06:42 AM
I think it will work if I clear the whole sheet manually and start from scratch but I don't know the standard loadouts of any of the mechs. Developer, don't forget to actually play the game once and a while...you know what they say about all work and no play :-)
S
#207
Posted 14 December 2012 - 07:33 AM
Feetwet, on 14 December 2012 - 06:42 AM, said:
I think it will work if I clear the whole sheet manually and start from scratch but I don't know the standard loadouts of any of the mechs. Developer, don't forget to actually play the game once and a while...you know what they say about all work and no play :-)
S
I don't have a Mac to test it on. But my understanding is that Macs can't run VBA code. So all of the sheets finer functionality will not work (Save/Load/Stock/Clear/Temp/Price Check). The only thing that will work is the basic loadout. You will have to clear it manually as you say.
#208
Posted 14 December 2012 - 10:46 AM
#209
Posted 14 December 2012 - 12:15 PM
3rdworld, on 14 December 2012 - 07:33 AM, said:
I don't have a Mac to test it on. But my understanding is that Macs can't run VBA code. So all of the sheets finer functionality will not work (Save/Load/Stock/Clear/Temp/Price Check). The only thing that will work is the basic loadout. You will have to clear it manually as you say.
This is correct, you can't use VBA on a mac. There may be a 3rd party add-on for it, but that would be at your own risk.
#210
Posted 16 December 2012 - 06:42 AM
I need some help. I need someone to help me with the VBA. An idea I have is proving above my knowledge level. If you are willing to help with some coding, please send me a PM.
Thanks.
#211
Posted 18 December 2012 - 10:15 AM
Just thought I would give a quick rundown on how this works on v1.77 going forward.
On the "Saves" worksheet, you will see the current saved mech information. Above this there will be another button "Load Previous".
After pressing the button, you will be prompted to select a file. You may select any Mech Lab version v1.76 or higher. The actual name of the file is irrelevant, so if you rename it to something else it will not effect this process. If you select a version below v1.76 you will receive a message box explaining that file is not compatible and the process will end.
And that is it! The sheet will overwrite all the saved information in the new sheet with the older version saved data.
Note: the VBA code must open the workbook to read the data, so it may take a bit longer than what you might expect. However, it will not shift focus and will immediately close the file and clear the memory.
Edited by 3rdworld, 18 December 2012 - 10:45 AM.
#212
Posted 18 December 2012 - 03:26 PM
They have discounted the UAC/5 from 25% to 62.5%!!! Guess they really want people to equip the UAC
They also discounted the LRM-5 from 25% to 55%. Not sure why.
Any who,
Excel Mech Lab v1.77.xlsm
- Added Load Previous versions saved data
- Correct MWO Heat Scale
- Updated Stalker Hardpoints and Price
- Updated TAG range
- Added Ammo/ton for Ballistics & Missile
- Added Flame/Fang
Edited by 3rdworld, 18 December 2012 - 03:29 PM.
#213
Posted 18 December 2012 - 11:37 PM
https://docs.google....bU55N2NLZFVqQzA
#214
Posted 19 December 2012 - 04:55 AM
Edited by LethalRose, 19 December 2012 - 04:55 AM.
#215
Posted 19 December 2012 - 06:04 AM
Kmieciu, on 18 December 2012 - 11:37 PM, said:
https://docs.google....bU55N2NLZFVqQzA
Hrmm, it worked perfectly on my machine. Can you tell me what is happening?
Edited by 3rdworld, 19 December 2012 - 06:41 AM.
#216
Posted 19 December 2012 - 06:54 AM
Translation:
Error 1004 during execution
The program or the object defined the error
Continue (greyed out) - End - Error detection (greyed out) - Help
I tried importing files from the 1.76 edition
Hope this can help you
Edited by Yami Kero, 19 December 2012 - 06:55 AM.
#217
Posted 19 December 2012 - 07:37 AM
Yami Kero, on 19 December 2012 - 06:54 AM, said:
Translation:
Error 1004 during execution
The program or the object defined the error
Continue (greyed out) - End - Error detection (greyed out) - Help
I tried importing files from the 1.76 edition
Hope this can help you
Are you getting the error before or after selecting the file?
#218
Posted 19 December 2012 - 07:41 AM
#219
Posted 19 December 2012 - 07:45 AM
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users