BattleTech - The Board Game of Armored Combat

BattleTech Player Boards => Fan Designs and Rules => Non-Combat Vehicles => Topic started by: Cryhavok101 on 18 July 2017, 23:06:41

Title: Support Vehicle Calculator
Post by: Cryhavok101 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.
Title: Re: Support Vehicle Calculator
Post by: kato on 25 July 2017, 17:11:43
Question: Has anyone gotten it to work in OpenOffice?
Title: Re: Support Vehicle Calculator
Post by: Cryhavok101 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.
Title: Re: Support Vehicle Calculator
Post by: kato 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.
Title: Re: Support Vehicle Calculator
Post by: Cryhavok101 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.
Title: Re: Support Vehicle Calculator
Post by: Hptm. Streiger 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)
Title: Re: Support Vehicle Calculator
Post by: Cryhavok101 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.
Title: Re: Support Vehicle Calculator
Post by: I am Belch II on 21 August 2017, 13:46:44
THank you for the updates.
Title: Re: Support Vehicle Calculator
Post by: Colt Ward on 17 August 2018, 12:06:08
Does this work for large ships?
Title: Re: Support Vehicle Calculator
Post by: Siegfried Marcus on 18 December 2018, 00:18:42
I love your spreadsheets Cryhavok101.  I've gotten good use out of an earlier one, and I'm just playing around with the upgrade.  I can't seem to find the plain old machine gun.  I tried turning off the filter, and I can find various arrays, light machine guns, etc., but I don't see the classic half-ton machine gun.
Title: Re: Support Vehicle Calculator
Post by: beachhead1985 on 19 December 2018, 11:28:36
Awesome!
Title: Re: Support Vehicle Calculator
Post by: Cryhavok101 on 08 January 2019, 18:58:30
I'm pretty inactive on the forums these days, and I turned over all my spreadsheets to Alsadius, but since I am here and saw this, i figured I'd answer:

Does this work for large ships?

Yes, it should. I used it to create https://bg.battletech.com/forums/index.php?topic=60556.0 and https://bg.battletech.com/forums/index.php?topic=58006.0 among others.
Title: Re: Support Vehicle Calculator
Post by: Daryk on 08 January 2019, 19:29:43
Sorry to hear you've reduced your activity here... You've done some really good work!  :thumbsup:
Title: Re: Support Vehicle Calculator
Post by: beachhead1985 on 10 February 2019, 12:54:16
Seconded!