Author Topic: Drop Calculator v0.8.0 (MWLL v0.8.0)  (Read 13411 times)

0 Members and 1 Guest are viewing this topic.

Offline thEClaw

  • Star Captain
  • ***
  • Posts: 976
  • l33tp0intz: +75/-0
Drop Calculator v0.8.0 (MWLL v0.8.0)
« on: April 27, 2012, 11:41:10 PM »
After Snyp3r abandoned his project, me and Az will try to keep his DropCalculator up-to-date. At least as long as updating stays simple. And for nostalgic reasons here some quotes from Snyp3rs original post:

[...]
VictorMorson came up with the idea of having a drop calculator spreadsheet on Google Documents. The reasoning was that it would be an easy way to save drop lists and share/edit them with the entire unit. So with that in mind, we set about making one which you can find right here:

[...]

05/12/2011 - v0.1: Initial version for 0.4.9.
05/18/2011 - v0.2: Added ammo calculators.
05/19/2011 - v0.2.1: Added "Full (Mini)" calculator with tiny fonts and full features (great for netbooks!)
05/30/2011 - v0.3: Updated all information for MWLL v0.5.1, various changes to calculator formatting.
07/01/2011 - v0.3.1: Fixed Thor A loadout data missing CDSRM6.
07/19/2011 - v0.4.0: Added tonnage calculators, added equipment lookups to calculators, improved formatting on all sheets.
01/26/2012 - v0.5.4 BETA: Overhauled and updated for MWLL 0.5.4. Thanks Az, thEClaw! Following MWLL version numbers now.
01/30/2012 - v0.5.4c: Advanced version number to non-beta.
02/08/2012 - v0.5.5a: Updated for MWLL 0.5.5.
02/08/2012 - v0.5.5b: Fixed small reference error in Excel spreadsheets. Google Docs sheets were not affected.
03/17/2012 - v0.5.5 FINAL: Identical to v0.5.5b. The master spreadsheet with all sheets included is now available in a .zip attachment, along with documentation about how it works.
04/27/2012 - v0.5.6: Updated for MWLL 0.5.6. The Google Docs-version will not be maintained.
05/15/2012 - v0.5.6b: Fixed another tiny bug.
07/30/2012 - v0.6.1: Updated to newest version of MWLL. Fixed (and probably introduced) a number of problems. Switched format of the source-file from .xlsx to .ods.
07/31/2012 - v0.6.1a: Removed the Stormcrow from all sheets and replaced its occurrence with the Ryoken.
01/19/2013 - v0.7.0: Updated to newest version of MWLL.
01/29/2013 - v0.7.1: Updated to newest version of MWLL, included differentiation between standard and improved jump jets. Fixed a bug concerning jumpjets of assault 'Mechs.
08/26/2013 - v0.7.1b: Fixed a bug where no prices of vehicles etc. were shown.
02/06/2014 - v0.7.1c: Added total armor values to lookup-sheets. Also added a graph to visualize individual components armor ("Lookup"-sheet only).
02/15/2014 - v0.7.1d: A wrong name for the Madcat MKII in the tonnage table prevented its tonnage from being shown accurately.
11/07/2016 - v0.8.0: Updated all the data as best as I could. Though the readout-scripts are getting a bit old by now.
11/08/2016 - v0.8.0a: Moved the Ares to Clan-vehicles and adjusted some column-widths so things are a little prettier.

What the package contains:
The drop calculator (with sheets the standard user will not need being hidden), and the documentation (which informs you about how to update the calculator...not that you would need to do that :'( ). I also added a page to the docs to describe how to update the calculator in a few words. Although this description remains somewhat useless until Az releases the script he uses to read out the data.

The spreadsheets are available as .xls and .odf. Hopefully everybody will be able to use one of those.

PS: Sorry if I miss somebody, but I only know of two people I should mention here: Thanks to Snyp3r for creating this expedient tool (especially the part where he made it easily updatable) and to Az for writing a script that feeds the spreadsheet with data. Have a smile: ;D

PPS: Please don't download the older versions unless you need them. I would like to have them preserved here, just in case. But normally you really shouldn't need them.

Offline ELH_KillThemALL

  • Alphatester
  • MechWarrior
  • *
  • Posts: 289
  • l33tp0intz: +20/-4
  • Eridani Light Horse
    • Eridani Light Horse
Re: Drop Calculator - MWLL v0.5.6
« Reply #1 on: April 28, 2012, 10:34:05 AM »
Thank u guys! Very helpful tool!!




Pubs are boring! Twinkletoes
Fundrops are fun!
Planetary League will makes me into ecstasy!

Offline Warlord Kentax

  • Lance Sergeant
  • **
  • Posts: 461
  • l33tp0intz: +37/-1
    • 12th Vegan Rangers Forum
Re: Drop Calculator - MWLL v0.5.6
« Reply #2 on: May 12, 2012, 10:37:06 PM »
I've never used a drop calculator before, but I'm pretty sure that that raven doesnt have MRMs and that that Vulture doesnt have LBX.

Member of the 12th Vegan Rangers
http://twelfthvr.freeforums.org/index.php

See who is playing MWLL right now, without having to start the game: http://stats.spikx.net/mwll.html

Offline Az

  • MechWarrior
  • **
  • Posts: 274
  • l33tp0intz: +49/-0
Re: Drop Calculator - MWLL v0.5.6
« Reply #3 on: May 13, 2012, 12:35:45 AM »
To be fair, the spreadsheet isn't saying there's a LBX20 on the Vulture B. It merely suggest that you might want to buy some LBX20 ammo...

Hmm, so I checked my script's output, seems accurate. The error must lie somewhere in the spreadsheet.

It looks like the import from dropcalc056.txt went wrong. Not very hard to fix if you get the data from this post. Or wait for thEClaw to update the calculator.

Offline thEClaw

  • Star Captain
  • ***
  • Posts: 976
  • l33tp0intz: +75/-0
Re: Drop Calculator - MWLL v0.5.6
« Reply #4 on: May 13, 2012, 02:14:51 AM »
To be fair, the spreadsheet isn't saying there's a LBX20 on the Vulture B. It merely suggest that you might want to buy some LBX20 ammo...

Hmm, so I checked my script's output, seems accurate. The error must lie somewhere in the spreadsheet.

It looks like the import from dropcalc056.txt went wrong. Not very hard to fix if you get the data from this post. Or wait for thEClaw to update the calculator.
Sorry for the trouble. I didn't notice that your script does not come with empty columns for the ammo-types. So when I tried to overwrite the old data, some cells were not refilled with new data but kept the old stuff. Nothing serious, as Az described. But it is now fixed in 0.5.6a.

Offline Warlord Kentax

  • Lance Sergeant
  • **
  • Posts: 461
  • l33tp0intz: +37/-1
    • 12th Vegan Rangers Forum
Re: Drop Calculator - MWLL v0.5.6
« Reply #5 on: May 14, 2012, 12:07:46 PM »
Thanks for the update. Found another issue. Raven prime is listed with 15dhs. Pretty sure it doesnt have any.
Member of the 12th Vegan Rangers
http://twelfthvr.freeforums.org/index.php

See who is playing MWLL right now, without having to start the game: http://stats.spikx.net/mwll.html

Offline Az

  • MechWarrior
  • **
  • Posts: 274
  • l33tp0intz: +49/-0
Re: Drop Calculator - MWLL v0.5.6
« Reply #6 on: May 15, 2012, 12:52:34 AM »
It is the same issue. For asset with no (D)HS, some cells are empty in my text file. Even if they are explicitly empty, unlike the ammo cells, it will keep the old data in those cells when you import the new one. Looks like it will be required to clear the sheet each time.

Offline thEClaw

  • Star Captain
  • ***
  • Posts: 976
  • l33tp0intz: +75/-0
Re: Drop Calculator - MWLL v0.5.6
« Reply #7 on: May 15, 2012, 07:42:03 AM »
Sorry. I actually thought I erased the old data properly. Update will be available in a couple of minutes.

Offline Az

  • MechWarrior
  • **
  • Posts: 274
  • l33tp0intz: +49/-0
Re: Drop Calculator v0.5.6b (MWLL v0.5.6)
« Reply #8 on: July 30, 2012, 05:16:39 AM »
Here's the data for 0.6.1, sorry for being late.

The only fix required for the script was to ignore internal leg armour. You might also notice that the new assets will advertise their Radar in the equipment cell; older assets won't output anything if they don't have C3.

A small suggestion:
I tried to update the spreadsheet with my data to check it and it wouldn't work. I spent quite some time tracking my stupid mistake: when importing prices.txt it left a leading space on the second column, which caused prices_parsed not to match with the asset names typed in the calculator. A small tweak in the (humongous substitute) formula used in prices_parsed would make it fool-proof.

Offline thEClaw

  • Star Captain
  • ***
  • Posts: 976
  • l33tp0intz: +75/-0
Re: Drop Calculator v0.5.6b (MWLL v0.5.6)
« Reply #9 on: July 30, 2012, 08:13:37 AM »
I ran into that same problem, but I just changed the delimiter symbol to ", " instead of implementing an automated fix. I also had to adapt a lot of formulas since LibreOffices newest version messed up the import from .xlsx. Now the source-file is a native .ods-file - if there are any errors in the other formats provided, somebody please tell me.

Once again, this thing is up-to-date. Download is to be found in the first post. Thanks, Az. (And don't forget: If you ever decide to depart from MWLL completely, please send me your script beforehand, ok? ;) )

Offline Warlord Kentax

  • Lance Sergeant
  • **
  • Posts: 461
  • l33tp0intz: +37/-1
    • 12th Vegan Rangers Forum
Re: Drop Calculator v0.6.1 (MWLL v0.6.1)
« Reply #10 on: July 30, 2012, 07:41:00 PM »
Rocking dude! Thanks for the update!
Member of the 12th Vegan Rangers
http://twelfthvr.freeforums.org/index.php

See who is playing MWLL right now, without having to start the game: http://stats.spikx.net/mwll.html

Offline Warlord Kentax

  • Lance Sergeant
  • **
  • Posts: 461
  • l33tp0intz: +37/-1
    • 12th Vegan Rangers Forum
Re: Drop Calculator v0.6.1 (MWLL v0.6.1)
« Reply #11 on: July 31, 2012, 11:34:27 AM »
I'm looking over the spread sheet, prepping for the upcoming planetary league and I noticed that the Ryoken is entered in as the Stormcrow and there is also no information other than Cbills for each variant.
Member of the 12th Vegan Rangers
http://twelfthvr.freeforums.org/index.php

See who is playing MWLL right now, without having to start the game: http://stats.spikx.net/mwll.html

Offline thEClaw

  • Star Captain
  • ***
  • Posts: 976
  • l33tp0intz: +75/-0
Re: Drop Calculator v0.6.1 (MWLL v0.6.1)
« Reply #12 on: July 31, 2012, 02:24:33 PM »
I'm looking over the spread sheet, prepping for the upcoming planetary league and I noticed that the Ryoken is entered in as the Stormcrow and there is also no information other than Cbills for each variant.
The use of "Stormcrow" and "Ryoken" is a little schizophrenic in the game. Until now the devs avoided using different names for the same asset, but in this case the list of prices generated by the game and the data for each asset contain different names. I didn't notice it, but it probably will lead to problems when calculating stuff. Easy fix seems to be to replace every occurrence of "Ryoken" with "Stormcrow" in the document (or the other way around, I don't know which name is the correct one). I will take a look at what problems it can cause and upload a corrected version - if I find out which name should be used.

EDIT: I assume that "Ryoken" is the term that should be used. The problems are indeed caused by the dual nature in naming the new 'Mechs inside MWLL. The data in the calculator seems to be fine and I removed the word "Stormcrow" from it. Will upload a fixed version soon.

Offline thEClaw

  • Star Captain
  • ***
  • Posts: 976
  • l33tp0intz: +75/-0
Re: Drop Calculator v0.6.1a (MWLL v0.6.1)
« Reply #13 on: January 18, 2013, 11:46:59 AM »
It seems that this will get an update. Either very soon or within a couple of days. :)

Offline Warlord Kentax

  • Lance Sergeant
  • **
  • Posts: 461
  • l33tp0intz: +37/-1
    • 12th Vegan Rangers Forum
Re: Drop Calculator v0.6.1a (MWLL v0.6.1)
« Reply #14 on: January 18, 2013, 05:59:25 PM »
Lotta work cut out for you. Good luck!
Member of the 12th Vegan Rangers
http://twelfthvr.freeforums.org/index.php

See who is playing MWLL right now, without having to start the game: http://stats.spikx.net/mwll.html