The forum is a place to speak about our games, make suggestions, report bugs, and so on. To post a message, you need to be logged in.

BlckKnght


(killer user)
Last login: 10d 14h
Last forum reset: 98d 14h
Membership: 4366d

VP Defense Optimizer Spreadsheet

Message 2207, 2797d 5h ago.
Hi TakeAPlayers,

For many months I've been using a spreadsheet to pick out the best armor and shield combinations for my custom VP fighter designs. I've recently converted the spreadsheet into a Google document, so now anyone can try it out. You can find the sheet at: https://spreadsheets.google.com/ccc?key=0AhKA2D8hkS2adFBQMjBvSE5UMEZLT3Rmc2NCWlgwdkE&hl=en

The document is set up to only allow me to edit it, but if you have a Google account you can create a copy for yourself with just a couple of clicks. If don't have an account, or if you'd prefer to work offline, you can also download the spreadsheet as a Excel or Open Office document. While I haven't tested that that it converts perfectly, everything (except perhaps the conditional formatting) should work in any modern spreadsheet program.

I hope that the way to use the spreadsheet is clear, given the directions at the bottom of the main page. Just fill out the yellow boxes and it will show the legal defense options in the grey boxes. When it use it, I often find myself tweaking various design parameters on the fighter design page and feeding the power, weight and budget values back into the spreadsheet to find what armor and shields are available. Eventually I figure out an optimal design that doesn't waste much left over performance or money.

I think there may be a few cases where you can spend exactly 1000 credits in the game, but where my spreadsheet thinks you'd have used 1001 (and so it doesn't allow it), but that's the only unfixed bug I know of at the moment (it's due to rounding issues, especially with armor). Let me know if you find other buts or things that don't work as expected and I'll try to fix them.

AshayRey

is a VP addict

(ice user)
"Please don't move if i shoot at you"
Lives in my cockpit
Last login: 2044d 21h
Last forum reset: 2167d 18h
Membership: 3415d 14h

VP Defense Optimizer Spreadsheet

Message 2208, 2797d 1h ago. In reply to message 2207.
Thanks,
That is a nice piece of work!

Copyright

It is understood that in submitting material (like suggestions, comments and proposals on our games) on this forum you are giving up any copyright claims, allowing us at takeaplay.net to freely display, copy, distribute, alter, transform, and build on this material, for the purpose of improving our site and games. We cannot guarantee that all proposals and requests will be developed, of course. In addition, we cannot guarantee that your contribution will be credited esplicitly, though we usually try to do that. However, we intend to keep the forum publicly available, so other players will always be able to know how and when you contributed to this site's growth. It is understood that we will make use of your suggestions to improve the site to the best of our abilities and time available. Your contributions will be rewarded with big smiles, , warm hugs, and no money.