Register Register

Author Topic: Support Vehicle Calculator  (Read 1637 times)

Cryhavok101

  • Captain
  • *
  • Posts: 1837
Support Vehicle Calculator
« on: 18 July 2017, 23:06:41 »
Most Current Link: https://docs.google.com/spreadsheets/d/1FG8gbws9gKoMRzpG0AgNS75IFiY1s2MhotHH0uK9zSo/edit?usp=sharing

The sheet is set to view only. Inside the link, click file, and select "Make a Copy" to create your own version you can use.

You can use this link to make the spreadsheet usable offline: https://support.google.com/drive/answer/2375012?co=GENIE.Platform%3DDesktop&hl=en

Like my other calculators, green is cell that can have user input, light grey is a formula that you should leave alone. On this sheet Yellow is an important total.

It does not yet calculate BV2 or C-bill cost, but will in the future.

Like my other sheets, there is only so much I can do on a spreadsheet, and if you want to make legal designs, you will need to be familiar with the rules. I can't really restrict you from putting things on one chassis that shouldn't be there, and I wasn't able to set a minimum engine weight, due to the complexity of all the different possibly chassis and engine types. I am working on fixing the minimum engine weight problem, but anything else you will need to know the rules on.

Like the other ones you can select weapons and equipment in the dropdown menus, then assign the number of them, and then the location. You need to assign any turrets the vehicle has in the "Turrets" section at the top. It is large enough to accommodate even the largest of Large Naval Support Vehicles' maximum number of turrets. If you don't assign what turrets you have here it will mess up calculations in several places.

Unlike the other calculators, I figured out how to do a filter function on this one's weapon and equipment lists. You will see a filter box with a trio of dropdown menus. The first dropdown is a simple yes no, yes means you want to use the filter, no means you don't. You can select an option for each box, and the options will change in the third one depending on what you select in the second one. Because of these filters, as long as the rest of the line fills in with the right info, ignore any warnings that appear on the weapon name column. There are a lot of things you can filter for, but if you just want it to be the list of everything a support vehicle can equip, set the first dropdown to 'No'.

As always, please let me know if you find anything wrong with it. This hasn't had as much testing as my other sheets.

kato

  • Lieutenant
  • *
  • Posts: 1429
Re: Support Vehicle Calculator
« Reply #1 on: 25 July 2017, 17:11:43 »
Question: Has anyone gotten it to work in OpenOffice?

Cryhavok101

  • Captain
  • *
  • Posts: 1837
Re: Support Vehicle Calculator
« Reply #2 on: 25 July 2017, 17:20:16 »
It will never ever ever work in open office. You use it in a browser. If you use chrome, you can even set it for use offline, but you just use a browser. One of the major reasons I use it over other spreadsheet programs is because of that: it has the absolutely easiest requirements out of all of them, you need no more software than a browser to use it.

kato

  • Lieutenant
  • *
  • Posts: 1429
Re: Support Vehicle Calculator
« Reply #3 on: 26 July 2017, 01:55:00 »
The sheet apparently works in Excel once you let it attempt to "repair" Google Docs' .xslx output on loading. Problem is mostly of a technical nature - Google Docs in its export wraps every function call in xIUDF native calls for .xslx and can't handle its own defined namespace for .ods.

Cryhavok101

  • Captain
  • *
  • Posts: 1837
Re: Support Vehicle Calculator
« Reply #4 on: 26 July 2017, 08:26:31 »
Also a lot of the formula I use don't work in excel, they would have to be set up entirely different there, so the sheet wouldn't work there anyway... or any other spreadsheet program that I am aware of.

Hptm. Streiger

  • Warrant Officer
  • *
  • Posts: 579
Re: Support Vehicle Calculator
« Reply #5 on: 15 August 2017, 02:16:07 »
Hey there great work....
this really helps a lot
(Recognized a small mistake you might need to check the Weight Values for the BAR 9-10 ratings in the Core)

Cryhavok101

  • Captain
  • *
  • Posts: 1837
Re: Support Vehicle Calculator
« Reply #6 on: 15 August 2017, 18:29:08 »
Hey there great work....
this really helps a lot

Thanks!

(Recognized a small mistake you might need to check the Weight Values for the BAR 9-10 ratings in the Core)

Thanks for catching that, fixed now. Decimal place in the wrong spot.

I am Belch II

  • Lieutenant Colonel
  • *
  • Posts: 7158
  • It's a gator with a nuke, whats the problem.
Re: Support Vehicle Calculator
« Reply #7 on: 21 August 2017, 13:46:44 »
THank you for the updates.
Walking the fine line between sarcasm and being a smart-ass

500 is the number of Warships Now. 500 looks like it will stay for a long time.

Colt Ward

  • Colonel
  • *
  • Posts: 13470
  • Gott Mit Uns
    • Merc Periphery Guide- Bakunin
Re: Support Vehicle Calculator
« Reply #8 on: 17 August 2018, 12:06:08 »
Does this work for large ships?
Colt Ward

Beware the vengeance of a patient man.

 

Register