Drop Calculator on Google Docs - Final Edition

[thEClaw]

Perfect, both of the files. Nice work, again.

Now I understand why you were thinking about performance before. I didn't really get that somebody might use this spreadsheet online - the downloaded version of course runs like a charm. And Google Docs feels very slow and unresponsive for me. It even looks strange, maybe I should use another browser if I ever wanted to use your calculator online...

PS: You might consider adding some version number to your calculator in the future. "0.5.4 Beta 7" would work. Or even "0.5.4.a". Just so that somebody checking the first post immediately sees whether there is a new version or not.

I really like how the new calculator basically only has two tabs/sheets. It is a lot easier to pick up and use than the older version, I think.

[Snyp3r]

Yeah, Google Docs runs kind of crappy, and the formatting doesn't import 100% correctly, but the reason we made it for GDocs in the first place was because (1) you could use it from almost any computer with a web browser and because (2) it made it really easy for drop commanders to share configurations in real-time. Anyway, I posted the .XLSX versions in the OP now. Might be better to use those if you just want a local spreadsheet, since I'm sure GDocs loses some stuff in translation.

On version numbers, I just left it BETA for now because I was updating it and tweaking it so frequently, once I get a little more testing and make sure this version is okay, I'll advance it to 0.5.4c.

I thought about adding the mini calculators back, but those are kind of unnecessary since you can just zoom in/out of the default ones are too big. And having just two, like you said, is a lot cleaner and easier to work with. I kind of got carried away with it before, heh. Decoupling the reference sheets (now that they're not needed for the calculators) is also nice, since that gives me more tabs to work with so I was able to split them into weight classes without worrying about the number of tabs.

[Az]

Data updated for 0.5.5.

Simple one-line change, the whole chassis pricing hasn't been tweaked yet. Don't forget to add the APC.

[Snyp3r]

Updated the OP with new versions. Sorry this is late, they only just posted about the new version on Facebook, looks like I need to find a better way to get notified about new releases.

[thEClaw]

Shame on you for not checking mechlivinglegends.net ten times a day!


Thanks for the update.

PS: OpenOffice seems to be able to read the .xlsx-files. There is a message about links to files when I open the file, but everything else seems to work (if I click "No" in that message).

[Snyp3r]

Hmm, can you copy and paste the exact error here for me? I'd like to make sure it's not some reference to another file that accidentally slipped in, although Excel should have given me an error about that.

I'm subscribed to this thread now, so I'll try to stay on the ball in the future.

[thEClaw]

The error-message itself is pretty useless. And I don't know if there is a way to get more information.

[Snyp3r]

Yep, I did have some references to another file that made their way in somehow, should be fixed now. New files are in the OP.

[thEClaw]

It is indeed. Thanks

[Snyp3r]

With Diablo 3, Mechwarrior: Online, moving to a new apartment and going back to school all coming up, I can't see myself keeping this updated anymore. I posted the master .xlsx file I used as an attachment in the OP, along with a few pages of documentation I typed up to try to explain the formulas and functions. If anyone wants to use it for their own project, feel free. I've still got email notifications for private messages and for new replies to this thread, so if anyone has any questions about anything I'll do my best to answer them.

Thanks to the other Aces guys, and especially Az and thEClaw for helping with this project. It's been fun, educational, and somewhat productive!

[thEClaw]

Thanks to you, Snyp3r for all the work you put into the final and previous versions of this calculator. It probably has served many people. Hope to meet you in MW:O some day.
(PS: Read your documentation for the calculator. Didn't expect you to go into that much detail - thanks for that.)

Now let's get this thing up-to-date.

Az? I haven't found a downloadable version of the script you are using. If there really is none: Could you please upload it or create new files for 0.5.6? I was about to update Snyp3rs DropCalculator, but the data I can get using other scripts is not compatible.

It seems updating would be really easy with the current DropCalculator. Copied the content of the prices.txt into the spreadsheet without a problem and I expect the rest to go as smooth as that. Snyp3r has done a great job. (Az, you still have to convince me of the quality of your work. )

[Az]

Here's the 0.5.6 data. Amazingly enough, no errors showed up this time! So I didn't check anything in-game but it's probably all good.
The only price discrepancy I have is about the Morrigu B and its Heavy Coolant Pod.
Remember that you'll have to add the APC manually, as always.


I'd like to thank Snyp3r too not only for his work on the spreadsheet, but especially for the huge effort that went into documenting it before he left. Documentation is a tedious and often thankless task, coding is much more fun! Am I the only one that have a little nerd rage at every MWLL patch note that's a tenth the length it should be?

And thank you thEClaw for not letting that effort go to waste.

Az, you still have to convince me of the quality of your work.

Well, I still have to convince myself of the quality of my work . But it works! That's the main thing.

[Bloodycrow]

Thanks for all the effort guys! We really appreciate the work you put into doing this and keeping it updated.

[thEClaw]

Thanks to Az I was able to (easily) update the drop calculator. Hopefully everything works - if not, somebody tell me.

I will attach two files:
The "USER"-version for all the people who only want to use the calculator. All the confusing calculations are hidden, no documentation is included.
Then there is the "DEV"-version: No hidden tabs, the documentation is included. 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 USER-spreadsheets are available as .xlsx, .xls and .odf. Hopefully everybody will be able to use one of those. Also, I did not split the spreadsheet into information- and calculation-part. I wanted to minimize the amount of work necessary to get the update done.

Now I will sit down and start praying. Maybe Snyp3r will notice it somehow and add the updated drop calculator to the first post.

[Snyp3r]

You should probably just start a new thread about it, especially since I already said I was abandoning it in the OP, and the new version isn't on Google Docs anywhere. I'll just update the OP with a link to the new thread and then you can do whatever you want with it. Glad to see the documentation helped you guys get it all updated!