Author Topic: StratOps/IntOps Warship/JumpShip/Space Station Calculator  (Read 4011 times)

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: Strategic Operations Warship/JumpShip Calculator
« Reply #30 on: 06 May 2017, 13:09:53 »
I almost forgot, I also added a second sheet that displays info in a several blocks, in more of a TRO style display. This is a work in progress. Right now it doesn't copy paste well, without needing some formatting, however as it is, it has made my life easier when putting things in such a format. There are more blocks of info going off to the side, so scroll until you get to the last one to see them all.

The only thing I wasn't able to add was the cargo bays section of a TRO style entry, because of the nature of them and how they can be split in any number of ways, I can't set this up to make them populate like the rest of it. Still, that is a easy part to type out yourself when transferring this info into a document.

I am Belch II

  • Lieutenant Colonel
  • *
  • Posts: 6814
  • It's a gator with a nuke, whats the problem.
Re: Strategic Operations Warship/JumpShip Calculator
« Reply #31 on: 08 May 2017, 11:27:01 »
Thank you for all the updates on this calculator of this.
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.

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: Strategic Operations Warship/JumpShip Calculator
« Reply #32 on: 09 May 2017, 01:27:27 »
Found a problem preventing people from selecting primitive K-F drives, and fixed it.

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: Strategic Operations Warship/JumpShip Calculator
« Reply #33 on: 11 May 2017, 16:34:42 »
For anyone who didn't know, this sheet doesn't work in other spreadsheet programs. It uses formulas that don't translate from one to another. Here is a link to instructions on using google sheets offline.

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: Strategic Operations Warship/JumpShip Calculator
« Reply #34 on: 20 July 2017, 22:34:45 »
Most Current Link 7-20-17
https://docs.google.com/spreadsheets/d/1-CDKf4BJghLS2B52_9O5q4deG8h5G2A9W-hDcBHGcUY/edit?usp=sharing

Now supports making Space Stations.

To do so, on the K-F Drive type select "None."

Added Energy Storage Batteries to the weapons and equipment list.

Updated C-bill and BV2 costs to accommodate space stations.

Note: If you try to use this feature to create a monitor, be aware that the controls weight calculation will be off, and the resultant difference in c-bill costs as well.

As usual if you notice something wrong, please let me know.

assaultdoor

  • Recruit
  • *
  • Posts: 19
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #35 on: 30 December 2017, 21:24:11 »
Should adding a NCSS (Large or Small) reduce the number of crew (cell D20)? Adding one increases the number of officers and the number of gunners/other, which I would expect, but it also reduces the number of crew. The NCSS Large adds 2 officers and 12 gunners/other, and reduces the number of crew by 2. The NCSS Small adds 1 officer and 6 gunners/other, and reduces the number of crew by 1. I assume it's taking the additional officer(s) from the crew.

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #36 on: 03 January 2018, 09:53:44 »
Yes, that is working as intended, and yes it is simply taking the number of officers needed for the additional people from the crew total. I did this so it was easier to see crew needed to operate equipment all together, since some people consider those optional, and may run the ship without those crew just without using that equipment. The ship still has the correct number of officers, and if you count gunners, other, and normal crew as the same, the same number of those as well.

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #37 on: 03 March 2018, 20:34:49 »
Thanks to Alsadius's suggestions in another thread, I made some improvements to the TRO Workup section of this sheet. The weapons sections now include the defensive weapons, and the ammo now includes the defensive ammo.

He had another suggestion that I did not implement:

His sugegstion was to add they launch and cargo bays to the general equipment section, by adding the following formula to cell V2 on the TRO Workup sheet:
Code: [Select]
=IFERROR(FILTER(EquipedName,(EquipedType="Equipment")+(EquipedType="Bay")),"None")
I did not implement it, because bays need to be assigned doors and arranged how you want them. The massive variety of ways they can be set up makes it inappropriate, in my opinion, to add them to the general equipment... however, I provided his formula for that cell in case any of you prefer doing it the way Alsadius suggested.

Psyckosama

  • Warrant Officer
  • *
  • Posts: 539
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #38 on: 16 April 2018, 00:32:40 »
How would one add things like custom weapons?

Alsadius

  • Master Sergeant
  • *
  • Posts: 266
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #39 on: 16 April 2018, 09:49:24 »
Once you've made your own copy, just un-hide all hidden tabs, go to the weapons tab, and add in whatever you want. The format is pretty self-explanatory.

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #40 on: 16 April 2018, 11:26:37 »
Once you've made your own copy, just un-hide all hidden tabs, go to the weapons tab, and add in whatever you want. The format is pretty self-explanatory.

What he said.

As long as the numbers don't have weird complex equations it should be fine. The weirder it is to figure out your weapon's weight, the more hoops you'll have to jump through.

I am Belch II

  • Lieutenant Colonel
  • *
  • Posts: 6814
  • It's a gator with a nuke, whats the problem.
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #41 on: 18 April 2018, 15:54:31 »
Thanks for the update..going to give it a try soon.
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.

Psyckosama

  • Warrant Officer
  • *
  • Posts: 539
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #42 on: 19 April 2018, 18:00:36 »
What he said.

As long as the numbers don't have weird complex equations it should be fine. The weirder it is to figure out your weapon's weight, the more hoops you'll have to jump through.

Fair enough. I just house rule that Light Vehicles use Battle Armor weapons rather than infantry because of how strange the infantry weapons rules are.

marauder648

  • Major
  • *
  • Posts: 4969
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #43 on: 05 May 2018, 03:16:07 »
This is awesome :D I've figured out how to use it (kind of) but I have spotted an error, the NAC ammo seems to be coming in light, I had 120 rounds of NAC-10 ammo weigh 24 tons not the 240 tons it should.  I dunno if i'm doing something wrong (probably am) or its a hiccup on the sheet.  Or am I doing it wrong, it seems to be actual numbers of shots, not tons of ammo, is that where I'm going wrong?
« Last Edit: 05 May 2018, 04:57:24 by marauder648 »
Ghost Bears: Cute and cuddly. Until you remember its a BLOODY BEAR!

Alsadius

  • Master Sergeant
  • *
  • Posts: 266
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #44 on: 05 May 2018, 05:54:12 »
This is awesome :D I've figured out how to use it (kind of) but I have spotted an error, the NAC ammo seems to be coming in light, I had 120 rounds of NAC-10 ammo weigh 24 tons not the 240 tons it should.  I dunno if i'm doing something wrong (probably am) or its a hiccup on the sheet.  Or am I doing it wrong, it seems to be actual numbers of shots, not tons of ammo, is that where I'm going wrong?

Per my copy of TacOps(pg. 408), NAC/10 ammo is 5 shots per ton, same as an AC/20. That's the correct value, unless there's been errata.

marauder648

  • Major
  • *
  • Posts: 4969
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #45 on: 05 May 2018, 06:29:49 »
Yeah I've been faffing around with it, the thing calculates the weight per shot, not per ton, so you need to add say 96 shots for some LRM ammo for example to get the right tonnage. 
Ghost Bears: Cute and cuddly. Until you remember its a BLOODY BEAR!

Cryhavok101

  • Captain
  • *
  • Posts: 1823
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #46 on: 05 May 2018, 10:31:57 »
Yeah I had to go with weight per shot so that ammo calculations didn't have to use entirely different calculations for things when the ammo weighs more than a ton per shot. Plus the sheet is sort of set up to allow for Fractional accounting.

marauder648

  • Major
  • *
  • Posts: 4969
Re: StratOps/IntOps Warship/JumpShip/Space Station Calculator
« Reply #47 on: 05 May 2018, 10:35:45 »
it still works superbly :) Its very easy to use!
Ghost Bears: Cute and cuddly. Until you remember its a BLOODY BEAR!