{"text_format":"2","workbook":"xlsx","n_sheets":25,"sheets":["InstructionsCredits","Build","Statblock","Ship Sheet","Armor","Computer Countermeasures","Crew Quarters","Defensive Countermeasures","Drift Engines","Expansion Bays","ICM","Power Cores","Security","Sensors","Shields","Ship Frames","Starship Base Stats","Starship Scale","Thrusters","Upgrades","Maneuverability","Weapons","Example MakesModels","Version History","TO DO"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":286,"comments":19,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"InstructionsCredits","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,1,8,2],[9,1,9,2],[5,1,5,2],[3,1,3,2],[1,1,1,2],[0,1,0,2],[10,1,10,2],[11,1,11,2],[6,1,6,2],[7,1,7,2]]}
[null,"NICKELA'S STARFINDER SHIP CALCULATOR"]
[null,"This sheet was made by Nick Lambert using rules and materials from the Starfinder Core Rulebook, copyright Paizo Inc."]
[]
[null,"Instructions"]
[null,"To use this sheet, hit the MAKE A COPY link to copy this to your own Drive.",{"$f":"HYPERLINK(\"https://docs.google.com/spreadsheets/d/1Gcz_bgHHPlevAZqunlVA6zq-Ev24NSKyTn5Huz4m-2Y/copy\",\"MAKE A COPY\")","v":"MAKE A COPY"}]
[null,"On the Build tab, fill in your choices to create your starship. The sheet will not allow you to do anything you're not allowed to (for instance putting cabins on a tiny fighter), so if a dropdown is empty, you can't put anything there. If you change your mind and want to start over, hit the RESET button at the top of the sheet to delete ALL the choices you've made."]
[null,"Some choices are dependent on other addons. For instance, you cannot install a secondary core unless you buy the expansion bay upgrade \"Power Core Housing.\""]
[null,"Budget for Build Points, Power Core Units, and Expansion Bays is tracked in the upper left. If you go over budget on any of them, a warning will appear up top informing you that you've created an illegal build. You can technically create a build with too much PCU, but you have to decide which systems to turn on and off (THIS FUNCTIONALITY WILL BE ADDED IN A FUTURE UPDATE)."]
[null,"Once you're done building your ship, you can see the stas as a traditional Statblock or view it on the player's Ship Sheet."]
[null,"To get an accurate reflection of your ship's current AC, navigate to the Ship Sheet and enter your Pilot's ranks in Piloting into the blue box under Pilot Bonus."]
[]
[null,"Credits"]
[null,"Created by Nick Lambert using material from the Starfinder Core Rulebook, copyright Paizo Inc. Thanks go to my understanding wife, the troubleshooters from the Paizo forums who keep breaking my sheet, and Paizo for making an awesome game. If you feel like you have a few extra bucks laying around, feel free to hit up the donate link so I can buy another 52 oz. refill of Diet Dr. Pepper from Casey's.",{"$f":"HYPERLINK(\"http://cash.me/$nicholasdeanlambert\",\"Make a donation\")","v":"Make a donation"}]
[]
[null,"This sheet is","v1.42"]
[null,"The latest version is",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IMPORTRANGE(\"\"1Gcz_bgHHPlevAZqunlVA6zq-Ev24NSKyTn5Huz4m-2Y\"\",\"\"'Version History'!A2\"\")\n\"),\"v1.42\")","v":"v1.42"}]
[null,"Your sheet is",{"$f":"if(C15=C16,\"up to date.\",hyperlink(\"https://docs.google.com/spreadsheets/d/1Gcz_bgHHPlevAZqunlVA6zq-Ev24NSKyTn5Huz4m-2Y/edit#gid=2079391524\",\"out of date. Go here to get the latest version.\"))","v":"up to date."}]
[null,"More Starfinder Resources",{"$f":"HYPERLINK(\"https://docs.google.com/document/d/1iU_U_UN4gGpfpLUdM-Ec6PprBkD5vRfQ2PvRlOpCN9A/edit\",\"HERE\")","v":"HERE"}]

{"sheet":"Build","index":1,"n_rows":106,"n_cols":14,"rows_kept":106,"cut":false,"hidden":false,"merged":[[17,6,17,8],[9,6,9,8],[15,6,15,8],[7,4,7,8],[6,5,6,8],[8,4,8,8],[21,6,21,8],[22,5,22,8],[24,4,24,8],[9,3,19,3],[20,4,20,8],[18,6,18,8],[19,6,19,8],[4,4,4,8],[5,5,5,8],[3,2,4,2],[3,1,4,1],[13,6,13,8],[14,6,14,8],[3,0,4,0],[5,0,6,2],[7,0,7,2],[3,4,3,8],[2,4,2,8],[57,6,57,8],[56,4,56,8],[57,0,59,0],[54,0,55,0],[54,6,54,8],[54,2,55,2],[54,1,55,1],[50,5,50,8],[49,5,49,8],[54,3,55,3],[57,3,59,3],[59,4,59,8],[55,6,55,8],[53,4,53,8],[68,5,68,8],[69,5,69,8],[62,5,62,8],[63,5,63,8],[75,5,75,8],[76,5,76,8],[77,5,77,8],[78,5,78,8],[79,5,79,8],[80,4,80,8],[80,1,81,1],[80,0,81,0],[70,5,70,8],[74,5,74,8],[72,5,72,8],[73,5,73,8],[71,5,71,8],[58,6,58,8],[67,5,67,8],[80,2,81,2],[80,3,81,3],[64,5,64,8],[61,5,61,8],[60,5,60,8],[43,5,43,8],[42,5,42,8],[48,5,48,8],[44,5,44,8],[45,4,45,8],[46,5,46,8],[47,5,47,8],[37,4,37,8],[40,4,40,8],[41,5,41,8],[9,1,19,1],[9,0,19,0],[32,0,33,0],[32,2,33,2],[32,1,33,1],[32,3,33,3],[29,3,30,3],[29,0,30,0],[29,1,30,1],[57,1,59,1],[57,2,59,2],[9,2,19,2],[25,3,27,3],[25,2,27,2],[25,0,27,0],[25,1,27,1],[29,2,30,2],[34,4,34,8],[35,4,35,8],[38,6,38,8],[39,6,39,8],[31,4,31,8],[32,6,32,8],[33,6,33,8],[27,4,27,8],[28,4,28,8],[36,6,36,8],[1,4,1,8],[0,4,0,8],[51,5,51,8],[52,5,52,8],[65,5,65,8],[66,5,66,8],[38,3,40,3],[38,2,40,2],[38,1,40,1],[38,0,40,0],[26,6,26,8],[25,6,25,8],[30,6,30,8],[29,6,29,8],[12,6,12,8],[11,6,11,8],[10,6,10,8],[16,6,16,8],[23,6,23,8]]}
[{"$f":"iferror(index(TierBP,match(Tier,TierChoice,0)),0)","v":0},{"$f":"Core1PCU+Core2PCU","v":0},{"$f":"FrameBay","v":0},"TOTAL",{"$f":"if(BPremaining<0,\"Warning, negative Build Points\",\"\")","v":""}]
[{"$f":"SUM(A5:A106)","v":0},0,0,"SPENT",{"$f":"if(PCUremaining<0,\"Danger, Power Core Unit overdraw; remove or disable systems to prevent core overload\",\"\")","v":""}]
[{"$f":"A1-A2","v":0},0,0,"REMAINING",{"$f":"if(BayRemaining<0,\"Overflow error; remove excess expansion bay(s).\",\"\")","v":""}]
["COST (IN BP)","PCU COST","BAYS USED","CHOICES","NICKELA'S\nSTARFINDER SHIP CALCULATOR",{"$nulls":4},"hide this column","hide this column","hide this column","hide this column ","hide this column "]
[null,null,null,"please only edit the fields in this column","STEP 1: CONCEPTUALIZE"]
[{"$nulls":5},"STARSHIP NAME"]
[{"$nulls":5},"MAKE AND MODEL"]
["Select Tier",null,null,null,"STEP 2: DETERMINE TIER AND BUILD POINTS"]
[{"$f":"iferror(index(FrameBPCost,match(Frame,FrameChoice,0)),0)","v":0},"-","-",null,"STEP 3: SELECT A FRAME"]
[{"$nulls":5},"SIZE",{"$f":"iferror(index(FrameSize,match(Frame,FrameChoice,0)),\"-\")","v":"-"}]
[{"$nulls":5},"MANEUVERABILITY",{"$f":"iferror(index(FrameManueverability,match(Frame,FrameChoice,0)),\"-\")","v":"-"}]
[{"$nulls":5},"BASE HP",{"$f":"iferror(index(FrameHP,match(Frame,FrameChoice,0)),0)","v":0}]
[{"$nulls":5},"HP INCREMENT",{"$f":"iferror(index(FrameIncrement,match(Frame,FrameChoice,0)),0)","v":0}]
[{"$nulls":5},"DT",{"$f":"iferror(index(FrameDT,match(Frame,FrameChoice,0)),\"-\")","v":"-"}]
[{"$nulls":5},"BASE CT",{"$f":"iferror(index(FrameCT,match(Frame,FrameChoice,0)),\"-\")","v":"-"}]
[{"$nulls":5},"MOUNTS",{"$f":"iferror(index(FrameMountsT,match(Frame,FrameChoice,0)),\"-\")","v":"-"}]
[{"$nulls":5},"EXPANSION BAYS",{"$f":"IFERROR(index(FrameBays,match(Frame,FrameChoice,0)),0)","v":0}]
[{"$nulls":5},"MINIMUM CREW",{"$f":"iferror(index(FrameCrewMin,match(Frame,FrameChoice,0)),0)","v":0}]
[{"$nulls":5},"MAXIMUM CREW",{"$f":"iferror(index(FrameCrewMax,match(Frame,FrameChoice,0)),0)","v":0}]
[{"$nulls":5},"NOTES",{"$f":"iferror(index(FrameNotes,match(Frame,FrameChoice,0)),\"-\")","v":"-"}]
[{"$f":"iferror(index(CoreBPCost,match(Core1,CoreChoice,0)),0)","v":0},"-","-",null,"STEP 4: SELECT A POWER CORE"]
[{"$nulls":5},"PCU GAIN",{"$f":"iferror(index(CorePCUCost,match(Core1,CoreChoice,0)),0)","v":0}]
[{"$f":"iferror(index(CoreBPCost,match(Core2,CoreChoice,0)),0)","v":0},"-","-",null,null,"SECONDARY CORE? (must select POWER CORE HOUSING from expansion bays)"]
[{"$nulls":5},"PCU GAIN",{"$f":"iferror(index(CorePCUCost,match(Core2,CoreChoice,0)),0)","v":0}]
[{"$f":"iferror(index(ThrusterBPCost,match(Thruster,ThrusterEligible,0)),0)","v":0},{"$f":"IFERROR(index(ThrusterPCUCost,match(Thruster,ThrusterEligible,0)),0)","v":0},"-",null,"STEP 5: SELECT THRUSTERS"]
[{"$nulls":5},"Speed (in Hexes)",{"$f":"iferror(index(ThrusterSpeed,match(Thruster,ThrusterEligible,0)),0)","v":0}]
[{"$nulls":5},"Piloting Mod",{"$f":"iferror(index(ThrusterPiloting,match(Thruster,ThrusterEligible,0)),0)","v":0}]
[{"$nulls":4},"STEP 6: SELECT OTHER SYSTEMS"]
[{"$f":"iferror(index(ArmorBPCost,match(Armor,ArmorChoice,0)),0)","v":0},"-","-",null,"ARMOR"]
[{"$nulls":5},"BONUS TO AC",{"$f":"iferror(index(ArmorAC,match(Armor,ArmorChoice,0)),0)","v":0}]
[{"$nulls":5},"SPECIAL",{"$f":"iferror(index(ArmorSpecial,match(Armor,ArmorChoice,0)),\"-\")","v":"-"}]
[{"$f":"iferror(index(ICMBPCost,match(ICM,ICMChoice,0)),0)","v":0},{"$f":"iferror(index(ICMPCUCost,match(ICM,ICMChoice,0)),0)","v":0},"-",null,"COMPUTER OR INTEGRATED CONTROL MODULE"]
[{"$nulls":5},"BONUS",{"$f":"iferror(index(ICMBonusT,match(ICM,ICMChoice,0)),0)","v":0}]
[{"$nulls":5},"NODES",{"$f":"iferror(index(ICMNodes,match(ICM,ICMChoice,0)),0)","v":0}]
[{"$f":"IFERROR(index(CrewBPCost,match(Crew,CrewChoice,0)),0)","v":0},"-","-",null,"CREW QUARTERS"]
[{"$f":"iferror(index(DefensiveBPCost,match(DefCounter,DefensiveChoice,0)),0)","v":0},{"$f":"iferror(index(DefensivePCUCost,match(DefCounter,DefensiveChoice,0)),0)","v":0},"-",null,"DEFENSIVE COUNTERMEASURES"]
[{"$nulls":5},"BONUS TO TL",{"$f":"iferror(index(DefensiveTL,match(DefCounter,DefensiveChoice,0)),0)","v":0}]
[{"$f":"iferror(index(DriftBPCost,match(Drift,DriftChoice,0)),0)","v":0},"-","-",null,"DRIFT ENGINE"]
[{"$nulls":5},"MINIMUM PCU",{"$f":"iferror(index(DriftPCUMin,match(Drift,DriftChoice,0)),0)","v":0}]
[{"$nulls":5},"ENGINE RATING",{"$f":"iferror(index(DriftRatingT,match(Drift,DriftChoice,0)),0)","v":0}]
[{"$nulls":4},"SECURITY"]
[{"$f":"iferror(index(AntiHackingBPCost,match(AntiHacking,AntiHackingChoice,0)),0)","v":0},"-","-",null,null,"anti-hacking system",null,null,null,"-"]
[{"$f":"iferror(index(AntipersonnelBPCost,match(Antipersonnel,AntipersonnelChoice,0)),0)","v":0},"-","-",null,null,"antipersonnel weapon",null,null,null,"-"]
[{"$f":"if(Biometric=F44, 5, 0)","v":0},"-","-",null,null,"biometric locks",null,null,null,"-"]
[{"$f":"if(SelfDestruct=F45,5*ShipSizeNum,0)","v":0},"-","-",null,null,"self-destruct system",null,null,null,"-"]
[{"$nulls":4},"COMPUTER COUNTERMEASURES"]
[{"$f":"if(D47=F47,ICMTier, 0)","v":0},"-","-",null,null,"alarm",null,null,null,"-"]
[{"$f":"if(D48=F48,ICMTier, 0)","v":0},"-","-",null,null,"fake shell",null,null,null,"-"]
[{"$f":"if(D49=F49,ICMTier, 0)","v":0},"-","-",null,null,"feedback",null,null,null,"-"]
[{"$f":"if(D50=F50,ICMTier, 0)","v":0},"-","-",null,null,"firewall",null,null,null,"-"]
[{"$f":"if(D51=F51,ICMTier, 0)","v":0},"-","-",null,null,"lockout",null,null,null,"-"]
[{"$f":"iferror(index(CounterShockBPCost,match(ComCounterShock,CounterShockChoice,0)),0)","v":0},"-","-",null,null,"shock grid",null,null,null,"-"]
[{"$f":"if(D53=F53,ICMTier, 0)","v":0},"-","-",null,null,"wipe",null,null,null,"-"]
[{"$f":"iferror(index(SensorBPCost,match(Sensor,SensorChoice,0)),0)","v":0},"-","-",null,"SENSORS"]
[{"$nulls":5},"RANGE",{"$f":"iferror(index(SensorRange,match(Sensor,SensorChoice,0)),0)","v":0}]
[{"$nulls":5},"MODIFIER",{"$f":"iferror(index(SensorMod,match(Sensor,SensorChoice,0)),0)","v":0}]
[{"$f":"IFERROR(index(ShieldBPCost,match(Shield,ShieldChoice,0)),0)","v":0},{"$f":"iferror(index(ShieldPCUCost,match(Shield,ShieldChoice,0)),0)","v":0},"-",null,"SHIELDS"]
[{"$nulls":5},"TOTAL SP",{"$f":"iferror(index(ShieldSP,match(Shield,ShieldChoice,0)),0)","v":0}]
[{"$nulls":5},"REGEN.",{"$f":"iferror(index(ShieldRegen,match(Shield,ShieldChoice,0)),0)","v":0}]
[{"$nulls":4},"EXPANSION BAYS (empty bays will be converted to cargo holds)"]
[{"$f":"iferror(index(BayBPCost,match(D61,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D61,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D61,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=1,\"bay 1\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D62,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D62,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D62,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=2,\"bay 2\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D63,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D63,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D63,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=3,\"bay 3\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D64,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D64,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D64,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=4,\"bay 4\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D65,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D65,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D65,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=5,\"bay 5\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D66,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D66,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D66,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=6,\"bay 6\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D67,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D67,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D67,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=7,\"bay 7\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D68,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D68,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D68,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=8,\"bay 8\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D69,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D69,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D69,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=9,\"bay 9\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D70,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D70,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D70,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=10,\"bay 10\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D71,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D71,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D71,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=11,\"bay 11\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D72,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D72,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D72,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=12,\"bay 12\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D73,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D73,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D73,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=13,\"bay 13\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D74,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D74,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D74,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=14,\"bay 14\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D75,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D75,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D75,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=15,\"bay 15\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D76,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D76,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D76,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=16,\"bay 16\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D77,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D77,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D77,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=17,\"bay 17\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D78,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D78,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D78,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=18,\"bay 18\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D79,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D79,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D79,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=19,\"bay 19\",\"\")","v":""}]
[{"$f":"iferror(index(BayBPCost,match(D80,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayPCUCost,match(D80,BayChoice,0)),0)","v":0},{"$f":"iferror(index(BayUsed,match(D80,BayChoice,0)),0)","v":0},null,"⏣",{"$f":"if(FrameBay>=20,\"bay 20\",\"\")","v":""}]
[{"$nulls":4},"WEAPONS",{"$nulls":4},"upgrade cost","linkage cost","link test for data val.","arraytest for linking arrays","showing weapons for the stablock"]
[{"$nulls":5},{"$f":"transpose(upgradeSlots)","v":"Weapons (forward)"},"UPGRADE OR ADD MOUNT","LINK","DAMAGE"]
[{"$f":"ifERROR(index(WeaponBPCost,match(D83,WeaponAll,0)),0)+J83+K83","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D83,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(AND(D83=D85,D84=D86,H86<>\"\"),\"\",if(H83<>\"\",\"\",if(H84<>\"\",iferror(index(LinkNum,match(D83,WeaponAll,0)))*2&iferror(index(LinkDice,match(D83,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D83,WeaponAll,0)),\"\"))))","v":""},{"$f":"transpose(upgradeMountCost)","v":""},null,null,null,{"$f":"if(OR(H83<>\"\",and(D83=D85,D84=D86,D86<>\"\",D84<>D85)),\"\",if(H84<>\"\",\"linked \"&D83&\"s\",D83))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D84,WeaponAll,0)),0)+J84+K84","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D84,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H84<>\"\",\"\",if(H85<>\"\",iferror(index(LinkNum,match(D84,WeaponAll,0)))*2&iferror(index(LinkDice,match(D84,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D84,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H84:H85<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D84,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D84<>\"\",D83=D84,H85=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(H84<>\"\",\"\",if(H85<>\"\",\"linked \"&D84&\"s\",D84))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D85,WeaponAll,0)),0)+J85+K85","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D85,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H85<>\"\",\"\",if(H86<>\"\",iferror(index(LinkNum,match(D85,WeaponAll,0)))*2&iferror(index(LinkDice,match(D85,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D85,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H85:H86<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D85,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D85<>\"\",D84=D85,H84=\"\",H86=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(AND(M86,D86<>\"\"),\"linked \"&left(D85,len(D85)-11),if(H85<>\"\",\"\",if(H86<>\"\",\"linked \"&D85&\"s\",D85)))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D86,WeaponAll,0)),0)+J86+K86","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D86,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H86<>\"\",\"\",iferror(index(WeaponDamage,match(D86,WeaponAll,0)),\"\"))","v":""},"",{"$f":"IF(H86:H87<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D86,WeaponAll,0)))/2),0)","v":0},{"$f":"if(or(AND(D86<>\"\",D85=D86,H85=\"\"),M86),\"link weapons\",\"\")","v":""},{"$f":"AND(NOT(D85=D84),D83<>\"\",D84<>\"\",D85<>\"\",D86<>\"\",D83=D85,D84=D86,left(right(D86,9),4=\"slot\"))","v":false},{"$f":"if(H86<>\"\",\"\",D86)","v":""}]
[{"$nulls":5},"Weapons (port)","UPGRADE OR ADD MOUNT","LINK","DAMAGE",""]
[{"$f":"ifERROR(index(WeaponBPCost,match(D88,WeaponAll,0)),0)+J88+K88","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D88,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(AND(M91,H91<>\"\"),\"\",if(H88<>\"\",\"\",if(H89<>\"\",iferror(index(LinkNum,match(D88,WeaponAll,0)))*2&iferror(index(LinkDice,match(D88,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D88,WeaponAll,0)),\"\"))))","v":""},"",null,null,null,{"$f":"if(OR(H88<>\"\",and(D88=D90,D89=D91,D91<>\"\",D89<>D90)),\"\",if(H89<>\"\",\"linked \"&D88&\"s\",D88))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D89,WeaponAll,0)),0)+J89+K89","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D89,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H89<>\"\",\"\",if(H90<>\"\",iferror(index(LinkNum,match(D89,WeaponAll,0)))*2&iferror(index(LinkDice,match(D89,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D89,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H89:H90<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D89,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D89<>\"\",D88=D89,H90=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(H89<>\"\",\"\",if(H90<>\"\",\"linked \"&D89&\"s\",D89))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D90,WeaponAll,0)),0)+J90+K90","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D90,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H90<>\"\",\"\",if(H91<>\"\",iferror(index(LinkNum,match(D90,WeaponAll,0)))*2&iferror(index(LinkDice,match(D90,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D90,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H90:H91<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D90,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D90<>\"\",D89=D90,H89=\"\",H91=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(AND(M91,D91<>\"\"),\"linked \"&left(D90,len(D90)-11),if(H90<>\"\",\"\",if(H91<>\"\",\"linked \"&D90&\"s\",D90)))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D91,WeaponAll,0)),0)+J91+K91","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D91,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H91<>\"\",\"\",iferror(index(WeaponDamage,match(D91,WeaponAll,0)),\"\"))","v":""},"",{"$f":"IF(H91:H92<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D91,WeaponAll,0)))/2),0)","v":0},{"$f":"if(or(AND(D91<>\"\",D90=D91,H90=\"\"),M91),\"link weapons\",\"\")","v":""},{"$f":"AND(NOT(D90=D89),D88<>\"\",D89<>\"\",D90<>\"\",D91<>\"\",D88=D90,D89=D91,left(right(D91,9),4=\"slot\"))","v":false},{"$f":"if(H91<>\"\",\"\",D91)","v":""}]
[{"$nulls":5},"Weapons (starboard)","UPGRADE OR ADD MOUNT","LINK","DAMAGE",""]
[{"$f":"ifERROR(index(WeaponBPCost,match(D93,WeaponAll,0)),0)+J93+K93","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D93,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(AND(M96,H96<>\"\"),\"\",if(H93<>\"\",\"\",if(H94<>\"\",iferror(index(LinkNum,match(D93,WeaponAll,0)))*2&iferror(index(LinkDice,match(D93,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D93,WeaponAll,0)),\"\"))))","v":""},"",null,null,null,{"$f":"if(OR(H93<>\"\",and(D93=D95,D94=D96,D96<>\"\",D94<>D95)),\"\",if(H94<>\"\",\"linked \"&D93&\"s\",D93))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D94,WeaponAll,0)),0)+J94+K94","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D94,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H94<>\"\",\"\",if(H95<>\"\",iferror(index(LinkNum,match(D94,WeaponAll,0)))*2&iferror(index(LinkDice,match(D94,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D94,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H94:H95<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D94,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D94<>\"\",D93=D94,H95=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(H94<>\"\",\"\",if(H95<>\"\",\"linked \"&D94&\"s\",D94))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D95,WeaponAll,0)),0)+J95+K95","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D95,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H95<>\"\",\"\",if(H96<>\"\",iferror(index(LinkNum,match(D95,WeaponAll,0)))*2&iferror(index(LinkDice,match(D95,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D95,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H95:H96<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D95,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D95<>\"\",D94=D95,H94=\"\",H96=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(AND(M96,D96<>\"\"),\"linked \"&left(D95,len(D95)-11),if(H95<>\"\",\"\",if(H96<>\"\",\"linked \"&D95&\"s\",D95)))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D96,WeaponAll,0)),0)+J96+K96","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D96,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H96<>\"\",\"\",iferror(index(WeaponDamage,match(D96,WeaponAll,0)),\"\"))","v":""},"",{"$f":"IF(H96:H97<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D96,WeaponAll,0)))/2),0)","v":0},{"$f":"if(or(AND(D96<>\"\",D95=D96,H95=\"\"),M96),\"link weapons\",\"\")","v":""},{"$f":"AND(NOT(D95=D94),D93<>\"\",D94<>\"\",D95<>\"\",D96<>\"\",D93=D95,D94=D96,left(right(D96,9),4=\"slot\"))","v":false},{"$f":"if(H96<>\"\",\"\",D96)","v":""}]
[{"$nulls":5},"Weapons (aft)","UPGRADE OR ADD MOUNT","LINK","DAMAGE",""]
[{"$f":"ifERROR(index(WeaponBPCost,match(D98,WeaponAll,0)),0)+J98+K98","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D98,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(AND(M101,H101<>\"\"),\"\",if(H98<>\"\",\"\",if(H99<>\"\",iferror(index(LinkNum,match(D98,WeaponAll,0)))*2&iferror(index(LinkDice,match(D98,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D98,WeaponAll,0)),\"\"))))","v":""},"",null,null,null,{"$f":"if(OR(H98<>\"\",and(D98=D100,D99=D101,D101<>\"\",D99<>D100)),\"\",if(H99<>\"\",\"linked \"&D98&\"s\",D98))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D99,WeaponAll,0)),0)+J99+K99","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D99,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H99<>\"\",\"\",if(H100<>\"\",iferror(index(LinkNum,match(D99,WeaponAll,0)))*2&iferror(index(LinkDice,match(D99,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D99,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H99:H100<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D99,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D99<>\"\",D98=D99,H100=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(H99<>\"\",\"\",if(H100<>\"\",\"linked \"&D99&\"s\",D99))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D100,WeaponAll,0)),0)+J100+K100","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D100,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H100<>\"\",\"\",if(H101<>\"\",iferror(index(LinkNum,match(D100,WeaponAll,0)))*2&iferror(index(LinkDice,match(D100,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D100,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H100:H101<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D100,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D100<>\"\",D99=D100,H99=\"\",H101=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(AND(M101,D101<>\"\"),\"linked \"&left(D100,len(D100)-11),if(H100<>\"\",\"\",if(H101<>\"\",\"linked \"&D100&\"s\",D100)))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D101,WeaponAll,0)),0)+J101+K101","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D101,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H101<>\"\",\"\",iferror(index(WeaponDamage,match(D101,WeaponAll,0)),\"\"))","v":""},"",{"$f":"IF(H101:H102<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D101,WeaponAll,0)))/2),0)","v":0},{"$f":"if(or(AND(D101<>\"\",D100=D101,H100=\"\"),M101),\"link weapons\",\"\")","v":""},{"$f":"AND(NOT(D100=D99),D98<>\"\",D99<>\"\",D100<>\"\",D101<>\"\",D98=D100,D99=D101,left(right(D101,9),4=\"slot\"))","v":false},{"$f":"if(H101<>\"\",\"\",D101)","v":""}]
[{"$nulls":5},"Weapons (turret)","UPGRADE OR ADD MOUNT","LINK","DAMAGE",""]
[{"$f":"ifERROR(index(WeaponBPCost,match(D103,WeaponAll,0)),0)+J103+K103","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D103,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(AND(M106,H106<>\"\"),\"\",if(H103<>\"\",\"\",if(H104<>\"\",iferror(index(LinkNum,match(D103,WeaponAll,0)))*2&iferror(index(LinkDice,match(D103,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D103,WeaponAll,0)),\"\"))))","v":""},"",null,null,null,{"$f":"if(OR(H103<>\"\",and(D103=D105,D104=D106,D106<>\"\",D104<>D105)),\"\",if(H104<>\"\",\"linked \"&D103&\"s\",D103))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D104,WeaponAll,0)),0)+J104+K104","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D104,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H104<>\"\",\"\",if(H105<>\"\",iferror(index(LinkNum,match(D104,WeaponAll,0)))*2&iferror(index(LinkDice,match(D104,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D104,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H104:H105<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D104,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D104<>\"\",D103=D104,H105=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(H104<>\"\",\"\",if(H105<>\"\",\"linked \"&D104&\"s\",D104))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D105,WeaponAll,0)),0)+J105+K105","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D105,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H105<>\"\",\"\",if(H106<>\"\",iferror(index(LinkNum,match(D105,WeaponAll,0)))*2&iferror(index(LinkDice,match(D105,WeaponAll,0)))&\" (linked)\",iferror(index(WeaponDamage,match(D105,WeaponAll,0)),\"\")))","v":""},"",{"$f":"IF(H105:H106<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D105,WeaponAll,0)))/2),0)","v":0},{"$f":"if(AND(D105<>\"\",D104=D105,H104=\"\",H106=\"\"),\"link weapons\",\"\")","v":""},null,{"$f":"if(AND(M106,D106<>\"\"),\"linked \"&left(D105,len(D105)-11),if(H105<>\"\",\"\",if(H106<>\"\",\"linked \"&D105&\"s\",D105)))","v":""}]
[{"$f":"ifERROR(index(WeaponBPCost,match(D106,WeaponAll,0)),0)+J106+K106","v":0},{"$f":"ifERROR(index(WeaponPCUCost,match(D106,WeaponAll,0)),0)","v":0},"-",null,"⏣",null,null,null,{"$f":"if(H106<>\"\",\"\",iferror(index(WeaponDamage,match(D106,WeaponAll,0)),\"\"))","v":""},"",{"$f":"IF(H106:H107<>\"\",rounddown(ifERROR(index(WeaponBPCost,match(D106,WeaponAll,0)))/2),0)","v":0},{"$f":"if(or(AND(D106<>\"\",D105=D106,H105=\"\"),M106),\"link weapons\",\"\")","v":""},{"$f":"AND(NOT(D105=D104),D103<>\"\",D104<>\"\",D105<>\"\",D106<>\"\",D103=D105,D104=D106,left(right(D106,9),4=\"slot\"))","v":false},{"$f":"if(H106<>\"\",\"\",D106)","v":""}]

{"sheet":"Statblock","index":2,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,4,7,16],[7,0,7,3],[12,0,12,2],[6,2,6,16],[8,0,8,2],[6,0,6,1],[8,3,8,16],[12,3,12,7],[13,2,13,16],[13,0,13,1],[15,0,15,2],[16,0,16,2],[15,3,15,16],[16,3,16,16],[10,3,10,16],[10,0,10,2],[9,4,9,16],[9,0,9,3],[11,4,11,16],[11,0,11,3],[14,0,14,3],[14,4,14,16],[3,13,3,16],[1,14,1,15],[2,0,2,16],[3,7,3,10],[3,11,3,12],[3,3,3,6],[3,0,3,1],[0,0,0,16],[5,5,5,16],[4,3,4,16],[12,11,12,16],[12,8,12,10]]}
[{"$f":"ShipName","v":""}]
[null,{"$f":"upper(MakeModel)","v":""},{"$nulls":12},{"$f":"upper(\"Tier \"&Tier)","v":"TIER "}]
[{"$f":"ShipSize&\" \"&Frame","v":"- "}]
[{"$f":"\"Speed\"","v":"Speed"},null,{"$f":"Speed","v":0},"Maneuverability",null,null,null,{"$f":"ManeuverabilityTurn","v":"Perfect (turn 0)"},null,null,null,"Drift",null,{"$f":"DriftRating","v":0}]
["AC",{"$f":"ACtotal","v":10},"TL",{"$f":"TLtotal","v":10}]
["HP",{"$f":"HPtotal","v":0},"DT",{"$f":"BaseDT","v":"-"},"CT",{"$f":"CTtotal","v":0}]
["Shields",null,{"$f":"IF(Shield<>\"\",Shield&\" \"&ShieldBalance,\"N/A\")","v":"N/A"}]
["Attack (Forward)",null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(atkFore), NOT(atkFore = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
["Attack (Port)",null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(atkPort), NOT(atkPort = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
["Attack (Starboard)",null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(atkStarboard), NOT(atkStarboard = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
["Attack (Aft)",null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(atkAft), NOT(atkAft = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
["Attack (Turret)",null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(atkTurret), NOT(atkTurret = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
[{"$f":"\"Power Core\"&if(Core2<>\"\",\"s\",\"\")","v":"Power Core"},null,null,{"$f":"Core1&if(Core2<>\"\",\"; \"&Core2,\"\")","v":""},{"$nulls":4},"Drift Engine",null,null,{"$f":"Drift","v":""}]
["Systems",null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(otherSystems), NOT(or(otherSystems = \"\"\"\",otherSystems=\"\"-\"\") )),\"\"N/A\"\"))\"),\"\")","v":""}]
["Expansion Bays",null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(baysSortedList), NOT(baysSortedList = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
["Modifiers",null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(Modifiers), NOT(Modifiers = \"\"\"\") )),\"\"N/A\"\")\"),\"0, 0 Piloting\")","v":"0, 0 Piloting"}]
["Complement",null,null,{"$f":"CrewMin&\"-\"&CrewMax","v":"0-0"}]

{"sheet":"Ship Sheet","index":3,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":false,"merged":[[42,15,42,19],[43,15,43,19],[41,15,41,19],[41,10,41,13],[42,10,42,13],[43,10,43,13],[43,1,43,7],[42,1,42,7],[42,22,43,33],[44,22,44,33],[40,22,41,33],[39,22,39,33],[40,15,40,19],[40,10,40,13],[0,14,1,16],[0,1,0,7],[1,1,1,9],[11,1,11,4],[10,1,10,4],[9,1,9,7],[0,17,1,33],[4,1,4,3],[5,1,5,3],[8,1,8,7],[7,24,7,25],[2,1,2,12],[3,1,3,12],[11,26,11,28],[10,26,10,28],[9,26,9,28],[7,26,7,28],[8,26,8,28],[7,1,7,7],[6,1,6,7],[4,5,4,10],[5,5,5,10],[11,30,11,32],[7,30,7,32],[8,30,8,32],[10,30,10,32],[9,30,9,32],[6,26,6,28],[6,30,6,32],[18,21,18,25],[17,21,17,25],[19,14,19,18],[18,14,18,18],[16,27,16,31],[15,27,15,31],[12,26,12,32],[13,26,14,32],[16,21,16,25],[18,27,18,31],[17,27,17,31],[29,4,29,8],[29,1,29,3],[25,12,29,32],[45,1,45,7],[46,2,46,7],[45,22,45,33],[25,1,25,3],[26,1,26,3],[32,1,32,5],[32,17,36,23],[32,9,36,15],[32,25,36,31],[33,1,33,5],[38,1,38,7],[37,1,37,7],[40,1,40,7],[41,2,41,7],[44,2,44,7],[39,2,39,7],[16,7,16,11],[17,7,17,11],[18,7,18,11],[17,1,17,5],[18,1,18,5],[16,1,16,5],[15,1,15,5],[30,1,30,5],[27,1,27,3],[28,1,28,3],[19,27,19,31],[19,21,19,25],[20,21,20,25],[20,7,20,11],[31,1,31,5],[24,12,24,18],[31,25,31,31],[27,4,27,8],[28,4,28,8],[24,1,24,7],[24,9,24,10],[20,14,20,18],[22,14,22,18],[21,14,21,18],[25,9,25,10],[29,9,29,10],[28,9,28,10],[27,9,27,10],[26,9,26,10],[31,17,31,23],[31,9,31,15],[19,7,19,11],[19,1,19,5],[25,4,25,8],[26,4,26,8]]}
[null,"STARSHIP NAME",{"$nulls":10},"TIER",null,"please only edit blue fields",null,null,"STARSHIP SHEET"]
[null,{"$f":"ShipName","v":""},{"$nulls":10},{"$f":"Tier","v":""}]
[null,"MAKE AND MODEL",{"$nulls":22},"TOTAL",null,"PILOT\nBONUS",null,"ARMOR\nBONUS",null,"SIZE\nMOD",null,"MISC\nMOD"]
[null,{"$f":"MakeModel","v":""},{"$nulls":21},"AC",{"$f":"ACtotal","v":10},"=10+",null,"+",{"$f":"ArmorBonus","v":0},"+",{"$f":"SizeBonus","v":""},"+"]
[null,"SIZE",null,null,null,"FRAME",{"$nulls":18},"TOTAL",null,"PILOT\nBONUS",null,"COUNTER\nMEASURES",null,"SIZE\nMOD",null,"MISC\nMOD"]
[null,{"$f":"ShipSize","v":"-"},null,null,null,{"$f":"Frame","v":""},{"$nulls":17},"TL",{"$f":"TLtotal","v":10},"=10+",{"$f":"PilotBonus","v":""},"+",{"$f":"Countermeasures","v":0},"+",{"$f":"SizeBonus","v":""},"+"]
[null,"SPEED",{"$nulls":24},"TOTAL",null,null,null,"CURRENT"]
[null,{"$f":"Speed","v":0},{"$nulls":22},"HULL POINTS",null,{"$f":"HPtotal","v":0}]
[null,"MANEUVERABILITY",{"$nulls":24},"DAMAGE THRESHOLD",null,null,null,"CRITICAL THRESHOLD"]
[null,{"$f":"ManeuverabilityTurn","v":"Perfect (turn 0)"},{"$nulls":24},{"$f":"BaseDT","v":"-"},null,null,null,{"$f":"CTtotal","v":0}]
[null,"DRIFT RATING",{"$nulls":24},"SHIELD TOTAL",null,null,null,"SHIELD REGEN."]
[null,{"$f":"DriftRating","v":0},{"$nulls":24},{"$f":"ShieldSPTotal","v":0},null,null,null,{"$f":"ShieldRegenTotal","v":0}]
[{"$nulls":26},"MODIFIERS"]
[{"$nulls":26},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(Modifiers), NOT(Modifiers = \"\"\"\") )),\"\"N/A\"\")\"),\"0, 0 Piloting\")","v":"0, 0 Piloting"}]
[]
[null,"WEAPONS \n(FORWARD)",{"$nulls":25},"WEAPONS \n(TURRET)"]
[null,{"$f":"TRANSPOSE(atkFore)","v":""},{"$nulls":5},"WEAPONS \n(PORT)",{"$nulls":13},"WEAPONS \n(STARBOARD)",{"$nulls":5},{"$f":"TRANSPOSE(atkTurret)","v":""}]
[null,"",{"$nulls":5},{"$f":"TRANSPOSE(atkPort)","v":""},{"$nulls":13},{"$f":"TRANSPOSE(atkStarboard)","v":""},{"$nulls":5},""]
[null,"",{"$nulls":5},"",{"$nulls":6},"WEAPONS \n(AFT)",{"$nulls":6},"",{"$nulls":5},""]
[null,"",{"$nulls":5},"",{"$nulls":6},{"$f":"TRANSPOSE(atkAft)","v":""},{"$nulls":6},"",{"$nulls":5},""]
[{"$nulls":7},"",{"$nulls":6},"",{"$nulls":6},""]
[{"$nulls":14},""]
[{"$nulls":14},""]
[]
[null,"CREW",{"$nulls":7},"BONUSES",null,null,"NOTES"]
[null,"CAPTAIN"]
[null,"ENGINEERS"]
[null,"GUNNERS"]
[null,"PILOT"]
[null,"SCIENCE OFF."]
[null,"DRIFT ENGINE"]
[null,{"$f":"Drift","v":""},{"$nulls":7},"SYSTEMS",{"$nulls":7},"EXPANSION BAYS",{"$nulls":7},"CARGO/PASSENGERS"]
[null,"POWER CORE",{"$nulls":7},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(otherSystems), NOT(or(otherSystems = \"\"\"\",otherSystems=\"\"-\"\") )),\"\"N/A\"\"))\"),\"\")","v":""},{"$nulls":7},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(join(\"\", \"\", FILTER(sort(baysSortedList), NOT(baysSortedList = \"\"\"\") )),\"\"N/A\"\")\"),\"N/A\")","v":"N/A"}]
[null,{"$f":"Core1&if(Core2<>\"\",\"; \"&Core2,\"\")","v":""}]
[]
[]
[]
[null,"CRITICAL DAMAGE"]
[null,"LIFE SUPPORT (1-10)",{"$nulls":6},"⏣"]
[{"$nulls":22},"Glitching: all checks* for affected system at -2"]
[null,"SENSORS (11-30)",{"$nulls":6},"⏣",null,"FORWARD (1)",null,null,null,"⏣",{"$nulls":7},"Malfunctioning: all checks* for affected system at–4; no push actions for affected system; power core damage affects all other systems at -2 (stacks)"]
[{"$nulls":10},"STARBOARD(2)",null,null,null,"⏣"]
[null,"WEAPONS ARRAY (31-60)",{"$nulls":8},"AFT (3)",null,null,null,"⏣",{"$nulls":7},"Wrecked: all checks* for affected systems automatically fail; can still take minor actions; power core damage affects all other systems at -4 (stacks)"]
[null,"ENGINES (61-80)",{"$nulls":6},"⏣",null,"PORT (4)",null,null,null,"⏣"]
[]
[null,"POWER CORE (81-00)",{"$nulls":6},"⏣",{"$nulls":13},"*except the hold it together and patch engineer actions"]

{"sheet":"Armor","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Name","Bonus to AC","Special","TL mod","Turn Distance mod","Cost Multiplier","Cost (in BP)"]
["-",0.0,"-",null,null,1.0,{"$f":"F2*ShipSizeNum","v":0}]
["Mk 1 armor",1.0,"-",null,null,1.0,{"$f":"F3*ShipSizeNum","v":0}]
["Mk 2 armor",2.0,"-",null,null,2.0,{"$f":"F4*ShipSizeNum","v":0}]
["Mk 3 armor",3.0,"-",null,null,3.0,{"$f":"F5*ShipSizeNum","v":0}]
["Mk 4 armor",4.0,"-",null,null,5.0,{"$f":"F6*ShipSizeNum","v":0}]
["Mk 5 armor",5.0,"-1 TL",-1.0,null,7.0,{"$f":"F7*ShipSizeNum","v":0}]
["Mk 6 armor",6.0,"-1 TL",-1.0,null,9.0,{"$f":"F8*ShipSizeNum","v":0}]
["Mk 7 armor",7.0,"-1 TL",-1.0,null,12.0,{"$f":"F9*ShipSizeNum","v":0}]
["Mk 8 armor",8.0,"-1 TL",-1.0,null,15.0,{"$f":"F10*ShipSizeNum","v":0}]
["Mk 9 armor",9.0,"-2 TL, +1 turn",-2.0,1.0,18.0,{"$f":"F11*ShipSizeNum","v":0}]
["Mk 10 armor",10.0,"-2 TL, +1 turn",-2.0,1.0,21.0,{"$f":"F12*ShipSizeNum","v":0}]
["Mk 11 armor",11.0,"-2 TL, +1 turn",-2.0,1.0,25.0,{"$f":"F13*ShipSizeNum","v":0}]
["Mk 12 armor",12.0,"-3 TL, +2 turn",-3.0,2.0,30.0,{"$f":"F14*ShipSizeNum","v":0}]
["Mk 13 armor",13.0,"-3 TL, +2 turn",-3.0,2.0,35.0,{"$f":"F15*ShipSizeNum","v":0}]
["Mk 14 armor",14.0,"-3 TL, +2 turn",-3.0,2.0,40.0,{"$f":"F16*ShipSizeNum","v":0}]
["Mk 15 armor",15.0,"-4 TL, +3 turn",-4.0,3.0,45.0,{"$f":"F17*ShipSizeNum","v":0}]
[null,null,"ArmorTL>>>",{"$f":"iferror(index(ArmorTLt,match(Armor,ArmorChoice,0),0))","v":""},{"$f":"iferror(index(ArmorTurnT,match(Armor,ArmorChoice,0)),\"\")","v":""}]

{"sheet":"Computer Countermeasures","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Shock Grid","BP Cost"]
["-",0.0]
["shock grid rank 1",{"$f":"ICMTier*1","v":1}]
["shock grid rank 2",{"$f":"ICMTier*2","v":2}]
["shock grid rank 3",{"$f":"ICMTier*3","v":3}]
["shock grid rank 4",{"$f":"ICMTier*4","v":4}]

{"sheet":"Crew Quarters","index":6,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Name","Cost (in BP)"]
["-",0.0]
[{"$f":"if(ShipSizeNum>1,\"Crew Quarters (Common)\",\"\")","v":""},0.0]
[{"$f":"if(ShipSizeNum>1,\"Crew Quarters (Good)\",\"\")","v":""},2.0]
[{"$f":"if(ShipSizeNum>1,\"Crew Quarters (Luxurious)\",\"\")","v":""},5.0]

{"sheet":"Defensive Countermeasures","index":7,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Name","Bonus to TL","PCU","Cost (in BP)"]
["-",null,0.0,0.0]
["Mk 1 defenses",1.0,1.0,2.0]
["Mk 2 defenses",2.0,1.0,3.0]
["Mk 3 defenses",3.0,2.0,4.0]
["Mk 4 defenses",4.0,3.0,6.0]
["Mk 5 defenses",5.0,4.0,8.0]
["Mk 6 defenses",6.0,5.0,11.0]
["Mk 7 defenses",7.0,7.0,14.0]
["Mk 8 defenses",8.0,9.0,18.0]
["Mk 9 defenses",9.0,11.0,22.0]
["Mk 10 defenses",10.0,13.0,27.0]
["Mk 11 defenses",11.0,16.0,33.0]
["Mk 12 defenses",12.0,20.0,40.0]
["Mk 13 defenses",13.0,25.0,50.0]
["Mk 14 defenses",14.0,32.0,65.0]
["Mk 15 defenses",15.0,45.0,90.0]

{"sheet":"Drift Engines","index":8,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Drift Engine","Engine Rating","Min. PCU","Max Size","maxSizeNum","Cost Multiplier","Cost (in BP)","Eligible Drift Engines"]
["Signal Basic (75 PCU min.)",1.0,75.0,"-",7.0,2.0,{"$f":"F2*ShipSizeNum","v":0},{"$f":"IF(AND(C2<=PCUtotal,E2>=ShipSizeNum),A2,\"\")","v":""}]
["Signal Booster (100 PCU min.)",2.0,100.0,"Huge",5.0,5.0,{"$f":"F3*ShipSizeNum","v":0},{"$f":"IF(AND(C3<=PCUtotal,E3>=ShipSizeNum),A3,\"\")","v":""}]
["Signal Major (150 PCU min.)",3.0,150.0,"Large",4.0,10.0,{"$f":"F4*ShipSizeNum","v":0},{"$f":"IF(AND(C4<=PCUtotal,E4>=ShipSizeNum),A4,\"\")","v":""}]
["Signal Superior (175 PCU min.)",4.0,175.0,"Large",4.0,15.0,{"$f":"F5*ShipSizeNum","v":0},{"$f":"IF(AND(C5<=PCUtotal,E5>=ShipSizeNum),A5,\"\")","v":""}]
["Signal Ultra (200 PCU min.)",5.0,200.0,"Medium",3.0,20.0,{"$f":"F6*ShipSizeNum","v":0},{"$f":"IF(AND(C6<=PCUtotal,E6>=ShipSizeNum),A6,\"\")","v":""}]
["N/A",0.0,0.0,"-",null,0.0,{"$f":"F7*ShipSizeNum","v":0},"N/A"]

{"sheet":"Expansion Bays","index":9,"n_rows":27,"n_cols":30,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Expansion Bay","number()","PCU","Cost (in BP)","Bays used","possible bays","list from build","empty? cargo hold","with number","sorted list"]
["arcane laboratory",{"$f":"if(countif(H:H,A2)>1,\"(\"&countif(H:H,A2)&\")\",\"\")","v":""},1.0,1.0,1.0,{"$f":"Build!F61:F80","v":""},{"$f":"Bays","v":""},{"$f":"IF(AND(F2<>\"\",G2=\"\"),\"cargo hold\",G2)","v":""},{"$f":"if(H2=\"hangar bay (slot 1/4)\",\"hangar bay\",if(H2=\"shuttle bay (slot 1/2)\",\"shuttle bay\",if(OR(H2=\"hangar bay (slot 2/4)\",H2=\"hangar bay (slot 3/4)\",H2=\"hangar bay (slot 4/4)\"),\"\",if(H2=\"shuttle bay (slot 2/2)\",\"\",H2))))&\" \"&iferror(index(B$2:B$27,match(H2,A$2:A$27,0)),\"\")","v":" "},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"sort(unique(I2:I25))\"),\" \")","v":" "},{"$f":"if(F2<>\"\",BayChoice,\"\")","v":""},{"$f":"if(F3<>\"\",if(bays1=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays1=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays1=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays1=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F3<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F4<>\"\",if(bays2=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays2=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays2=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays2=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F4<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F5<>\"\",if(bays3=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays3=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays3=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays3=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F5<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F6<>\"\",if(bays4=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays4=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays4=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays4=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F6<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F7<>\"\",if(bays5=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays5=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays5=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays5=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F7<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F8<>\"\",if(bays6=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays6=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays6=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays6=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F8<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F9<>\"\",if(bays7=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays7=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays7=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays7=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F9<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F10<>\"\",if(bays8=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays8=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays8=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays8=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F10<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F11<>\"\",if(bays9=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays9=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays9=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays9=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F11<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F12<>\"\",if(bays10=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays10=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays10=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays10=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F12<>\"\",BayChoice))))),\"\")","v":""},{"$f":"if(F13<>\"\",if(bays11=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays11=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays11=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays11=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F13<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F14<>\"\",if(bays12=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays12=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays12=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays12=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F14<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F15<>\"\",if(bays13=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays13=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays13=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays13=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F15<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F16<>\"\",if(bays14=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays14=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays14=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays14=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F16<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F17<>\"\",if(bays15=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays15=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays15=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays15=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F17<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F18<>\"\",if(bays16=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays16=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays16=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays16=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F18<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F19<>\"\",if(bays17=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays17=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays17=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays17=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F19<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F20<>\"\",if(bays18=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays18=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays18=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays18=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F20<>\"\",BayChoice,\"\"))))),\"\")","v":""},{"$f":"if(F21<>\"\",if(bays19=\"hangar bay (slot 1/4)\",\"hangar bay (slot 2/4)\",if(bays19=\"hangar bay (slot 2/4)\",\"hangar bay (slot 3/4)\",if(bays19=\"hangar bay (slot 3/4)\",\"hangar bay (slot 4/4)\",if(bays19=\"shuttle bay (slot 1/2)\",\"shuttle bay (slot 2/2)\",if(F21<>\"\",BayChoice,\"\"))))),\"\")","v":""}]
["cargo hold","",0.0,0.0,1.0,"",null,""," "]
["escape pods","",2.0,1.0,1.0,"",null,""," "]
["guest quarters","",1.0,1.0,1.0,"",null,""," "]
[{"$f":"if(ShipSizeNum>=6,\"hangar bay (slot 1/4)\",\"\")","v":""},"(26)",30.0,10.0,1.0,"",null,""," "]
["life boats","",5.0,3.0,1.0,"",null,""," "]
["medical bay","",4.0,8.0,1.0,"",null,""," "]
["passenger seating","",0.0,0.0,1.0,"",null,""," "]
[{"$f":"if(ShipSizeNum>=3,\"power core housing\",\"\")","v":""},"(26)",0.0,10.0,1.0,"",null,""," "]
["recreation suite (gym)","",0.0,1.0,1.0,"",null,""," "]
["recreation suite (trivid den)","",1.0,1.0,1.0,"",null,""," "]
["recreation suite (hac)","",3.0,1.0,1.0,"",null,""," "]
["science lab","",2.0,1.0,1.0,"",null,""," "]
["sealed environment chamber","",2.0,1.0,1.0,"",null,""," "]
[{"$f":"if(ShipSizeNum>=5,\"shuttle bay (slot 1/2)\",\"\")","v":""},"(26)",10.0,4.0,1.0,"",null,""," "]
["smuggler compartment (dc 20)","",4.0,2.0,1.0,"",null,""," "]
["smuggler compartment (dc 25)","",5.0,3.0,1.0,"",null,""," "]
["smuggler compartment (dc 30)","",6.0,4.0,1.0,"",null,""," "]
["smuggler compartment (dc 35)","",7.0,5.0,1.0,"",null,""," "]
["smuggler compartment (dc 40)","",8.0,6.0,1.0,"",null,""," "]
["smuggler compartment (dc 45)","",9.0,7.0,1.0]
["smuggler compartment (dc 50)","",10.0,8.0,1.0]
["synthesis bay","",2.0,1.0,1.0]
["tech workshop","",3.0,1.0,1.0]
["hangar bay",""]
["shuttle bay",""]

{"sheet":"ICM","index":10,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Name","Bonus","Bonus","Nodes","PCU","Cost (in BP)"]
["basic computer (+0)",null,null,0.0,0.0,0.0]
["mk 1 mononode","+1 to any 1 check per round",1.0,1.0,10.0,{"$f":"(C3:C32^2)*D3:D32","v":1}]
["mk 1 duonode","+1 to any 2 checks per round",1.0,2.0,10.0,2.0]
["mk 1 trinode","+1 to any 3 checks per round",1.0,3.0,10.0,3.0]
["mk 1 tetranode","+1 to any 4 checks per round",1.0,4.0,10.0,4.0]
["mk 2 mononode","+2 to any 1 check per round",2.0,1.0,15.0,4.0]
["mk 2 duonode","+2 to any 2 checks per round",2.0,2.0,15.0,8.0]
["mk 2 trinode","+2 to any 3 checks per round",2.0,3.0,15.0,12.0]
["mk 2 tretranode","+2 to any 4 checks per round",2.0,4.0,15.0,16.0]
["mk 3 mononode","+3 to any 1 check per round",3.0,1.0,20.0,9.0]
["mk 3 duonode","+3 to any 2 checks per round",3.0,2.0,20.0,18.0]
["mk 3 trinode","+3 to any 3 checks per round",3.0,3.0,20.0,27.0]
["mk 3 tretranode","+3 to any 4 checks per round",3.0,4.0,20.0,36.0]
["mk 4 mononode","+4 to any 1 check per round",4.0,1.0,25.0,16.0]
["mk 4 duonode","+4 to any 2 checks per round",4.0,2.0,25.0,32.0]
["mk 4 trinode","+4 to any 3 checks per round'",4.0,3.0,25.0,48.0]
["mk 5 mononode","+5 to any 1 check per round",5.0,1.0,30.0,25.0]
["mk 5 duonode","+5 to any 2 checks per round",5.0,2.0,30.0,50.0]
["mk 5 trinode","+5 to any 3 checks per round",5.0,3.0,30.0,75.0]
["mk 6 mononode","+6 to any 1 check per round",6.0,1.0,35.0,36.0]
["mk 6 duonode","+6 to any 2 checks per round",6.0,2.0,35.0,72.0]
["mk 7 mononode","+7 to any 1 check per round",7.0,1.0,40.0,49.0]
["mk 7 duonode","+7 to any 2 checks per round",7.0,2.0,40.0,98.0]
["mk 8 mononode","+8 to any 1 check per round",8.0,1.0,45.0,64.0]
["mk 8 duonode","+8 to any 2 checks per round",8.0,2.0,45.0,128.0]
["mk 9 mononode","+9 to any 1 check per round",9.0,1.0,50.0,81.0]
["mk 9 duonode","+9 to any 2 checks per round",9.0,2.0,50.0,162.0]
["mk 10 mononode","+10 to any 1 check per round",10.0,1.0,55.0,100.0]
["mk 10 duonode","+10 to any 2 checks per round",10.0,2.0,55.0,200.0]
[{"$nulls":5},0.0]
["computer tier",{"$f":"max(1,rounddown(Tier/2,0))","v":1},null,null,null,0.0]

{"sheet":"Power Cores","index":11,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Core","Size","PCU","Cost (in BP)","CoreEligible","Core2Eligible"]
["Micron Light (50 PCU)","T",50.0,4.0,{"$f":"if(ShipSize=\"Tiny\",A2,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E2,\"\")","v":""}]
["Micron Heavy (70 PCU)","T",70.0,6.0,{"$f":"if(ShipSize=\"Tiny\",A3,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E3,\"\")","v":""}]
["Micron Ultra (80 PCU)","T",80.0,8.0,{"$f":"if(ShipSize=\"Tiny\",A4,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E4,\"\")","v":""}]
["Arcus Light (75 PCU)","T, S",75.0,7.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\"),A5,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E5,\"\")","v":""}]
["Pulse Brown (90 PCU)","T, S",90.0,9.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\"),A6,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E6,\"\")","v":""}]
["Pulse Black (120 PCU)","T, S",120.0,12.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\"),A7,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E7,\"\")","v":""}]
["Pulse White (140 PCU)","T, S",140.0,14.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\"),A8,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E8,\"\")","v":""}]
["Pulse Gray (100 PCU)","T, S, M",100.0,10.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\",ShipSize=\"Medium\"),A9,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E9,\"\")","v":""}]
["Arcus Heavy (130 PCU)","T, S, M",130.0,13.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\",ShipSize=\"Medium\"),A10,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E10,\"\")","v":""}]
["Pulse Green (150 PCU)","T, S, M",150.0,15.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\",ShipSize=\"Medium\"),A11,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E11,\"\")","v":""}]
["Pulse Red (175 PCU)","T, S, M",175.0,17.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\",ShipSize=\"Medium\"),A12,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E12,\"\")","v":""}]
["Pulse Blue (200 PCU)","T, S, M",200.0,20.0,{"$f":"if(OR(ShipSize=\"Tiny\",ShipSize=\"Small\",ShipSize=\"Medium\"),A13,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E13,\"\")","v":""}]
["Arcus Ultra (150 PCU)","S, M, L",150.0,15.0,{"$f":"if(OR(ShipSize=\"Small\",ShipSize=\"Medium\",ShipSize=\"Large\"),A14,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E14,\"\")","v":""}]
["Arcus Maximum (200 PCU)","S, M, L",200.0,20.0,{"$f":"if(OR(ShipSize=\"Small\",ShipSize=\"Medium\",ShipSize=\"Large\"),A15,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E15,\"\")","v":""}]
["Pulse Orange (250 PCU)","S, M, L",250.0,25.0,{"$f":"if(OR(ShipSize=\"Small\",ShipSize=\"Medium\",ShipSize=\"Large\"),A16,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E16,\"\")","v":""}]
["Pulse Prismatic (300 PCU)","S, M, L",300.0,30.0,{"$f":"if(OR(ShipSize=\"Small\",ShipSize=\"Medium\",ShipSize=\"Large\"),A17,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E17,\"\")","v":""}]
["Nova Light (150 PCU)","M, L, H",150.0,15.0,{"$f":"if(OR(ShipSize=\"Medium\",ShipSize=\"Large\",ShipSize=\"Huge\"),A18,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E18,\"\")","v":""}]
["Nova Heavy (200 PCU)","M, L, H",200.0,20.0,{"$f":"if(OR(ShipSize=\"Medium\",ShipSize=\"Large\",ShipSize=\"Huge\"),A19,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E19,\"\")","v":""}]
["Nova Ultra (300 PCU)","M, L, H",300.0,30.0,{"$f":"if(OR(ShipSize=\"Medium\",ShipSize=\"Large\",ShipSize=\"Huge\"),A20,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E20,\"\")","v":""}]
["Gateway Light (300 PCU)","L, H, G",300.0,30.0,{"$f":"if(OR(ShipSize=\"Large\",ShipSize=\"Huge\",ShipSize=\"Gargantuan\"),A21,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E21,\"\")","v":""}]
["Gateway Heavy (400 PCU)","L, H, G",400.0,40.0,{"$f":"if(OR(ShipSize=\"Large\",ShipSize=\"Huge\",ShipSize=\"Gargantuan\"),A22,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E22,\"\")","v":""}]
["Gateway Ultra (500 PCU)","H, G, C",500.0,50.0,{"$f":"if(OR(ShipSize=\"Huge\",ShipSize=\"Gargantuan\",ShipSize=\"Colossal\"),A23,\"\")","v":""},{"$f":"if(COUNTIF(Bays,\"Power core housing\")>0,E23,\"\")","v":""}]

{"sheet":"Security","index":12,"n_rows":112,"n_cols":5,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
["Anti-Hacking Systems","Cost (in BP)","Antipersonnel weapon","Cost (in BP)","Eligible antipersonnel weapons"]
["-",0.0,"-",0.0,{"$f":"if(ShipSizeNum<>\"\",C2,\"\")","v":""}]
["anti-hacking x1",3.0,"l-zero rifle, frostibte-class",4.0,{"$f":"if(ShipSizeNum<=3,C3,\"\")","v":"l-zero rifle, frostibte-class"}]
["anti-hacking x2",6.0,"l-zero rifle, hailstorm-class",8.0,{"$f":"if(ShipSizeNum<=3,C4,\"\")","v":"l-zero rifle, hailstorm-class"}]
["anti-hacking x3",9.0,"l-zero rifle, blizzard-class",14.0,{"$f":"if(ShipSizeNum<=3,C5,\"\")","v":"l-zero rifle, blizzard-class"}]
["anti-hacking x4",12.0,"l-zero rifle, avalanche-class",18.0,{"$f":"if(ShipSizeNum<=3,C6,\"\")","v":"l-zero rifle, avalanche-class"}]
[null,null,"l-flame rifle",2.0,{"$f":"if(ShipSizeNum<=3,C7,\"\")","v":"l-flame rifle"}]
[null,null,"l-laser rifle, azimuth",1.0,{"$f":"if(ShipSizeNum<=3,C8,\"\")","v":"l-laser rifle, azimuth"}]
[null,null,"l-laser rifle, corona",6.0,{"$f":"if(ShipSizeNum<=3,C9,\"\")","v":"l-laser rifle, corona"}]
[null,null,"l-laser rifle, aphelion",9.0,{"$f":"if(ShipSizeNum<=3,C10,\"\")","v":"l-laser rifle, aphelion"}]
[null,null,"l-autobeam rifle, tacitcal",11.0,{"$f":"if(ShipSizeNum<=3,C11,\"\")","v":"l-autobeam rifle, tacitcal"}]
[null,null,"l-laser rifle, perihelion",13.0,{"$f":"if(ShipSizeNum<=3,C12,\"\")","v":"l-laser rifle, perihelion"}]
[null,null,"l-autobeam rifle, advanced",15.0,{"$f":"if(ShipSizeNum<=3,C13,\"\")","v":"l-autobeam rifle, advanced"}]
[null,null,"l-laser rifle, parallax",17.0,{"$f":"if(ShipSizeNum<=3,C14,\"\")","v":"l-laser rifle, parallax"}]
[null,null,"l-autobeam rifle, elite",19.0,{"$f":"if(ShipSizeNum<=3,C15,\"\")","v":"l-autobeam rifle, elite"}]
[null,null,"l-laser rifle, zenith",20.0,{"$f":"if(ShipSizeNum<=3,C16,\"\")","v":"l-laser rifle, zenith"}]
[null,null,"l-plasma rifle, red star",6.0,{"$f":"if(ShipSizeNum<=3,C17,\"\")","v":"l-plasma rifle, red star"}]
[null,null,"l-plasma rifle, yellow star",10.0,{"$f":"if(ShipSizeNum<=3,C18,\"\")","v":"l-plasma rifle, yellow star"}]
[null,null,"l-plasma caster, white star",13.0,{"$f":"if(ShipSizeNum<=3,C19,\"\")","v":"l-plasma caster, white star"}]
[null,null,"l-plasma rifle, white star",15.0,{"$f":"if(ShipSizeNum<=3,C20,\"\")","v":"l-plasma rifle, white star"}]
[null,null,"l-plasma caster, blue star",17.0,{"$f":"if(ShipSizeNum<=3,C21,\"\")","v":"l-plasma caster, blue star"}]
[null,null,"l-plasma rifle, blue star",20.0,{"$f":"if(ShipSizeNum<=3,C22,\"\")","v":"l-plasma rifle, blue star"}]
[null,null,"l-hunting rifle",1.0,{"$f":"if(ShipSizeNum<=3,C23,\"\")","v":"l-hunting rifle"}]
[null,null,"l-scattergun, utility",1.0,{"$f":"if(ShipSizeNum<=3,C24,\"\")","v":"l-scattergun, utility"}]
[null,null,"l-acid dart rifle, tactical",2.0,{"$f":"if(ShipSizeNum<=3,C25,\"\")","v":"l-acid dart rifle, tactical"}]
[null,null,"l-autotarget rifle",2.0,{"$f":"if(ShipSizeNum<=3,C26,\"\")","v":"l-autotarget rifle"}]
[null,null,"l-crossbolter, tactical",2.0,{"$f":"if(ShipSizeNum<=3,C27,\"\")","v":"l-crossbolter, tactical"}]
[null,null,"l-acid dart rifle, dual",7.0,{"$f":"if(ShipSizeNum<=3,C28,\"\")","v":"l-acid dart rifle, dual"}]
[null,null,"l-seeker rifle, tactical",7.0,{"$f":"if(ShipSizeNum<=3,C29,\"\")","v":"l-seeker rifle, tactical"}]
[null,null,"l-crossbolter, dual",8.0,{"$f":"if(ShipSizeNum<=3,C30,\"\")","v":"l-crossbolter, dual"}]
[null,null,"l-scattergun, snub",8.0,{"$f":"if(ShipSizeNum<=3,C31,\"\")","v":"l-scattergun, snub"}]
[null,null,"l-magnetar rifle,tactical",9.0,{"$f":"if(ShipSizeNum<=3,C32,\"\")","v":"l-magnetar rifle,tactical"}]
[null,null,"l-combat rifle",10.0,{"$f":"if(ShipSizeNum<=3,C33,\"\")","v":"l-combat rifle"}]
[null,null,"l-acid dart rifle, comlpex",12.0,{"$f":"if(ShipSizeNum<=3,C34,\"\")","v":"l-acid dart rifle, comlpex"}]
[null,null,"l-scattergun, impact",12.0,{"$f":"if(ShipSizeNum<=3,C35,\"\")","v":"l-scattergun, impact"}]
[null,null,"l-gyrojet rifle, tactical",13.0,{"$f":"if(ShipSizeNum<=3,C36,\"\")","v":"l-gyrojet rifle, tactical"}]
[null,null,"l-magnetar rifle, advanced",13.0,{"$f":"if(ShipSizeNum<=3,C37,\"\")","v":"l-magnetar rifle, advanced"}]
[null,null,"l-seeker rifle, advanced",14.0,{"$f":"if(ShipSizeNum<=3,C38,\"\")","v":"l-seeker rifle, advanced"}]
[null,null,"l-gyrojet rifle, advanced",15.0,{"$f":"if(ShipSizeNum<=3,C39,\"\")","v":"l-gyrojet rifle, advanced"}]
[null,null,"l-scattergun, vortex",15.0,{"$f":"if(ShipSizeNum<=3,C40,\"\")","v":"l-scattergun, vortex"}]
[null,null,"l-magnetar rifle, elite",16.0,{"$f":"if(ShipSizeNum<=3,C41,\"\")","v":"l-magnetar rifle, elite"}]
[null,null,"l-gyrojet rifle, elite",17.0,{"$f":"if(ShipSizeNum<=3,C42,\"\")","v":"l-gyrojet rifle, elite"}]
[null,null,"l-seeker rifle, elite",17.0,{"$f":"if(ShipSizeNum<=3,C43,\"\")","v":"l-seeker rifle, elite"}]
[null,null,"l-scattergun, grapeshot",18.0,{"$f":"if(ShipSizeNum<=3,C44,\"\")","v":"l-scattergun, grapeshot"}]
[null,null,"l-magnetar rifle, paragon",19.0,{"$f":"if(ShipSizeNum<=3,C45,\"\")","v":"l-magnetar rifle, paragon"}]
[null,null,"l-gyrojet rifle, paragon",20.0,{"$f":"if(ShipSizeNum<=3,C46,\"\")","v":"l-gyrojet rifle, paragon"}]
[null,null,"l-seeker rifle, paragon",20.0,{"$f":"if(ShipSizeNum<=3,C47,\"\")","v":"l-seeker rifle, paragon"}]
[null,null,"l-pulsecaster rifle",1.0,{"$f":"if(ShipSizeNum<=3,C48,\"\")","v":"l-pulsecaster rifle"}]
[null,null,"l-arc emitter,tactical",2.0,{"$f":"if(ShipSizeNum<=3,C49,\"\")","v":"l-arc emitter,tactical"}]
[null,null,"l-arc rifle, staitc",6.0,{"$f":"if(ShipSizeNum<=3,C50,\"\")","v":"l-arc rifle, staitc"}]
[null,null,"l-arc emitter, advanced",9.0,{"$f":"if(ShipSizeNum<=3,C51,\"\")","v":"l-arc emitter, advanced"}]
[null,null,"l-arc rifle, aurora",11.0,{"$f":"if(ShipSizeNum<=3,C52,\"\")","v":"l-arc rifle, aurora"}]
[null,null,"l-arc rifle, storm",16.0,{"$f":"if(ShipSizeNum<=3,C53,\"\")","v":"l-arc rifle, storm"}]
[null,null,"l-arc rifle, tempest",19.0,{"$f":"if(ShipSizeNum<=3,C54,\"\")","v":"l-arc rifle, tempest"}]
[null,null,"l-sonic rifle, thunderstrike",5.0,{"$f":"if(ShipSizeNum<=3,C55,\"\")","v":"l-sonic rifle, thunderstrike"}]
[null,null,"l-streetsweeper, thunderstrike",7.0,{"$f":"if(ShipSizeNum<=3,C56,\"\")","v":"l-streetsweeper, thunderstrike"}]
[null,null,"l-sonic rifle, lfd",10.0,{"$f":"if(ShipSizeNum<=3,C57,\"\")","v":"l-sonic rifle, lfd"}]
[null,null,"l-streetsweeper, lfd",12.0,{"$f":"if(ShipSizeNum<=3,C58,\"\")","v":"l-streetsweeper, lfd"}]
[null,null,"l-sonic rifle, hfd",14.0,{"$f":"if(ShipSizeNum<=3,C59,\"\")","v":"l-sonic rifle, hfd"}]
[null,null,"l-streetsweeper, hfd",16.0,{"$f":"if(ShipSizeNum<=3,C60,\"\")","v":"l-streetsweeper, hfd"}]
[null,null,"l-sonic rifle, banshee",18.0,{"$f":"if(ShipSizeNum<=3,C61,\"\")","v":"l-sonic rifle, banshee"}]
[null,null,"l-needler rifle",1.0,{"$f":"if(ShipSizeNum<=3,C62,\"\")","v":"l-needler rifle"}]
[null,null,"h-zero cannon, tactical",16.0,{"$f":"if(ShipSizeNum<=3,C63,\"\")","v":"h-zero cannon, tactical"}]
[null,null,"h-zero cannon, advanced",19.0,{"$f":"if(ShipSizeNum<=3,C64,\"\")","v":"h-zero cannon, advanced"}]
[null,null,"h-zero cannon, elite",23.0,{"$f":"if(ShipSizeNum<=3,C65,\"\")","v":"h-zero cannon, elite"}]
[null,null,"h-flamethrower, ifrit-class",7.0,{"$f":"if(ShipSizeNum<=3,C66,\"\")","v":"h-flamethrower, ifrit-class"}]
[null,null,"h-flamethrower, salamander-class",13.0,{"$f":"if(ShipSizeNum<=3,C67,\"\")","v":"h-flamethrower, salamander-class"}]
[null,null,"h-flamethrower, hellhound-class",17.0,{"$f":"if(ShipSizeNum<=3,C68,\"\")","v":"h-flamethrower, hellhound-class"}]
[null,null,"h-flamethrower, firedrake-class",20.0,{"$f":"if(ShipSizeNum<=3,C69,\"\")","v":"h-flamethrower, firedrake-class"}]
[null,null,"h-flamethrower, phoenix-class",23.0,{"$f":"if(ShipSizeNum<=3,C70,\"\")","v":"h-flamethrower, phoenix-class"}]
[null,null,"h-artillery laser, azimuth",6.0,{"$f":"if(ShipSizeNum<=3,C71,\"\")","v":"h-artillery laser, azimuth"}]
[null,null,"h-artillery laser, corona",11.0,{"$f":"if(ShipSizeNum<=3,C72,\"\")","v":"h-artillery laser, corona"}]
[null,null,"h-artillery laser, aphellion",14.0,{"$f":"if(ShipSizeNum<=3,C73,\"\")","v":"h-artillery laser, aphellion"}]
[null,null,"h-autobeam artillery, tactical",15.0,{"$f":"if(ShipSizeNum<=3,C74,\"\")","v":"h-autobeam artillery, tactical"}]
[null,null,"h-artillery laser, perihelion",18.0,{"$f":"if(ShipSizeNum<=3,C75,\"\")","v":"h-artillery laser, perihelion"}]
[null,null,"h-autobeam artillery, advanced",21.0,{"$f":"if(ShipSizeNum<=3,C76,\"\")","v":"h-autobeam artillery, advanced"}]
[null,null,"h-artillery laser, parallax",22.0,{"$f":"if(ShipSizeNum<=3,C77,\"\")","v":"h-artillery laser, parallax"}]
[null,null,"h-autobeam artillery, elite",24.0,{"$f":"if(ShipSizeNum<=3,C78,\"\")","v":"h-autobeam artillery, elite"}]
[null,null,"h-artillery laser, zenith",25.0,{"$f":"if(ShipSizeNum<=3,C79,\"\")","v":"h-artillery laser, zenith"}]
[null,null,"h-plasma cannon, yellow star",19.0,{"$f":"if(ShipSizeNum<=3,C80,\"\")","v":"h-plasma cannon, yellow star"}]
[null,null,"h-plasma cannon, white star",21.0,{"$f":"if(ShipSizeNum<=3,C81,\"\")","v":"h-plasma cannon, white star"}]
[null,null,"h-plasma cannon, red star",13.0,{"$f":"if(ShipSizeNum<=3,C82,\"\")","v":"h-plasma cannon, red star"}]
[null,null,"h-plasma cannon, blue star",25.0,{"$f":"if(ShipSizeNum<=3,C83,\"\")","v":"h-plasma cannon, blue star"}]
[null,null,"h-reaction cannon, light",6.0,{"$f":"if(ShipSizeNum<=3,C84,\"\")","v":"h-reaction cannon, light"}]
[null,null,"h-machine gun, squad",9.0,{"$f":"if(ShipSizeNum<=3,C85,\"\")","v":"h-machine gun, squad"}]
[null,null,"h-x-gen gun, tactical",11.0,{"$f":"if(ShipSizeNum<=3,C86,\"\")","v":"h-x-gen gun, tactical"}]
[null,null,"h-reaction cannon, tactical",12.0,{"$f":"if(ShipSizeNum<=3,C87,\"\")","v":"h-reaction cannon, tactical"}]
[null,null,"h-machine gun, light",13.0,{"$f":"if(ShipSizeNum<=3,C88,\"\")","v":"h-machine gun, light"}]
[null,null,"h-x-gen gun, advanced",14.0,{"$f":"if(ShipSizeNum<=3,C89,\"\")","v":"h-x-gen gun, advanced"}]
[null,null,"h-reaction cannon, heavy",15.0,{"$f":"if(ShipSizeNum<=3,C90,\"\")","v":"h-reaction cannon, heavy"}]
[null,null,"h-stellar cannon, light",15.0,{"$f":"if(ShipSizeNum<=3,C91,\"\")","v":"h-stellar cannon, light"}]
[null,null,"h-crosbolter, advanced",16.0,{"$f":"if(ShipSizeNum<=3,C92,\"\")","v":"h-crosbolter, advanced"}]
[null,null,"h-machine gun, medium",16.0,{"$f":"if(ShipSizeNum<=3,C93,\"\")","v":"h-machine gun, medium"}]
[null,null,"h-x-gen gun, elite",18.0,{"$f":"if(ShipSizeNum<=3,C94,\"\")","v":"h-x-gen gun, elite"}]
[null,null,"h-crossbolter, elite",19.0,{"$f":"if(ShipSizeNum<=3,C95,\"\")","v":"h-crossbolter, elite"}]
[null,null,"h-reaction cannon, advanced",19.0,{"$f":"if(ShipSizeNum<=3,C96,\"\")","v":"h-reaction cannon, advanced"}]
[null,null,"h-stellar cannon, heavy",20.0,{"$f":"if(ShipSizeNum<=3,C97,\"\")","v":"h-stellar cannon, heavy"}]
[null,null,"h-machine gun, heavy",22.0,{"$f":"if(ShipSizeNum<=3,C98,\"\")","v":"h-machine gun, heavy"}]
[null,null,"h-reaction cannon, elite",22.0,{"$f":"if(ShipSizeNum<=3,C99,\"\")","v":"h-reaction cannon, elite"}]
[null,null,"h-crossbolter, paragon",23.0,{"$f":"if(ShipSizeNum<=3,C100,\"\")","v":"h-crossbolter, paragon"}]
[null,null,"h-reaction cannon, paragon",25.0,{"$f":"if(ShipSizeNum<=3,C101,\"\")","v":"h-reaction cannon, paragon"}]
[null,null,"h-x-gen gun, paragon",25.0,{"$f":"if(ShipSizeNum<=3,C102,\"\")","v":"h-x-gen gun, paragon"}]
[null,null,"h-shock caster, static",11.0,{"$f":"if(ShipSizeNum<=3,C103,\"\")","v":"h-shock caster, static"}]
[null,null,"h-shock caster, aurora",15.0,{"$f":"if(ShipSizeNum<=3,C104,\"\")","v":"h-shock caster, aurora"}]
[null,null,"h-shock caster, storm",21.0,{"$f":"if(ShipSizeNum<=3,C105,\"\")","v":"h-shock caster, storm"}]
[null,null,"h-shock caster, tempest",25.0,{"$f":"if(ShipSizeNum<=3,C106,\"\")","v":"h-shock caster, tempest"}]
[null,null,"h-screamer, thunderstrike",10.0,{"$f":"if(ShipSizeNum<=3,C107,\"\")","v":"h-screamer, thunderstrike"}]
[null,null,"h-screamer, lfd",14.0,{"$f":"if(ShipSizeNum<=3,C108,\"\")","v":"h-screamer, lfd"}]
[null,null,"h-screamer, hfd",20.0,{"$f":"if(ShipSizeNum<=3,C109,\"\")","v":"h-screamer, hfd"}]
[null,null,"h-nil grenate launcher, merc",6.0,{"$f":"if(ShipSizeNum<=3,C110,\"\")","v":"h-nil grenate launcher, merc"}]
[null,null,"h-nil grenade launcher, squad",13.0,{"$f":"if(ShipSizeNum<=3,C111,\"\")","v":"h-nil grenade launcher, squad"}]
[null,null,"h-imds missile launcher",15.0,{"$f":"if(ShipSizeNum<=3,C112,\"\")","v":"h-imds missile launcher"}]

{"sheet":"Sensors","index":13,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Sensors","Range","Modifier","Cost (in BP)"]
["-",null,0.0,0.0]
["cut-rate sensors (-2)","Short",-2.0,1.0]
["budget short-range sensors (+0)","Short","+0",2.0]
["basic short-range sensors (+2)","Short","+2",3.0]
["advanced short-range sensors (+4)","Short","+4",4.0]
["budget medium-range sensors (+0)","Medium","+0",3.0]
["basic medium-range sensors (+2)","Medium","+2",5.0]
["advanced medium-range sensors (+4)","Medium","+4",8.0]
["budget long-range sensors (+0)","Long","+0",6.0]
["basic long-range sensors (+2)","Long","+2",10.0]
["advanced long-range sensors (+4)","Long","+4",14.0]

{"sheet":"Shields","index":14,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Shield Name","Total SP","Regen","PCU","Cost (BP)","Balance shields"]
["-",0.0,0.0,0.0,0.0]
["basic shields 10",10.0,"1/min.",5.0,2.0,"(forward 3, port 2, starboard 2, aft 3)"]
["basic shields 20",20.0,"1/min.",10.0,3.0,"(forward 5, port 5, starboard 5, aft 5)"]
["basic shields 30",30.0,"1/min.",15.0,4.0,"(forward 8, port 7, starboard 7, aft 8)"]
["basic shields 40",40.0,"1/min.",15.0,5.0,"(forward 10, port 10, starboard 10, aft 10)"]
["light shields 50",50.0,"2/min.",20.0,6.0,"(forward 13, port 12, starboard 12, aft 13)"]
["light shields 60",60.0,"2/min.",20.0,8.0,"(forward 15, port 15, starboard 15, aft 15)"]
["light shields 70",70.0,"2/min.",25.0,10.0,"(forward 18, port 17, starboard 17, aft 18)"]
["light shields 80",80.0,"2/min.",30.0,12.0,"(forward 20, port 20, starboard 20, aft 20)"]
["medium shields 90",90.0,"4/min.",30.0,13.0,"(forward 23, port 22, starboard 22, aft 23)"]
["medium shields 100",100.0,"4/min.",30.0,15.0,"(forward 25, port 25, starboard 25, aft 25)"]
["medium shields 120",120.0,"4/min.",35.0,17.0,"(forward 30, port 30, starboard 30, aft 30)"]
["medium shields 140",140.0,"8/min.",40.0,18.0,"(forward 35, port 35, starboard 35, aft 35)"]
["medium shields 160",160.0,"8/min.",45.0,20.0,"(forward 40, port 40, starboard 40, aft 40)"]
["medium shields 200",200.0,"8/min.",50.0,22.0,"(forward 50, port 50, starboard 50, aft 50)"]
["heavy shields 240",240.0,"16/min.",55.0,23.0,"(forward 60, port 60, starboard 60, aft 60)"]
["heavy shields 280",280.0,"16/min.",60.0,25.0,"(forward 70, port 70, starboard 70, aft 70)"]
["heavy shields 320",320.0,"16/min.",70.0,27.0,"(forward 80, port 80, starboard 80, aft 80)"]
["heavy shields 360",360.0,"32/min.",80.0,28.0,"(forward 90, port 90, starboard 90, aft 90)"]
["heavy shields 420",420.0,"32/min.",90.0,30.0,"(forward 105, port 105, starboard 105, aft 105)"]
["heavy shields 480",480.0,"32/min.",110.0,32.0,"(forward 120, port 120, starboard 120, aft 120)"]
["superior shields 540",540.0,"64/min.",130.0,35.0,"(forward 135, port 135, starboard 135, aft 135)"]
["superior shields 600",600.0,"64/min.",160.0,40.0,"(forward 150, port 150, starboard 150, aft 150)"]
["",{"$nulls":4},{"$f":"iferror(index(ShieldBalanceT,match(Shield,ShieldChoice,0)),0)","v":0}]

{"sheet":"Ship Frames","index":15,"n_rows":17,"n_cols":42,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Frame","affordable frames","Size","Manueverability TURN ONLY","Manueverability","FramePilot","FrameTurn","HP","increment","DT","CT","Mounts","fore","FA1","FA2","FA3","FA4","port","PA1","PA2","PA3","PA4","starboard","SA1","SA2","SA3","SA4","aft","AA1","AA2","AA3","AA4","turret","T1","T2","T3","T4","Expansion Bays","Minimum Crew","Maximum Crew","Cost","Notes"]
["Racer",{"$f":"if(BPtotal<$AO2,\"\",A2)","v":""},"Tiny",{"$f":"\"perfect (turn 0\"&if(ArmorTurn<>\"\",\"+\"&ArmorTurn)&\")\"","v":"perfect (turn 0FALSE)"},"perfect (+2 Piloting, turn 0)",2.0,0.0,20.0,5.0,"-",4.0,"forward arc (1 light), aft arc (1 light)","1 light","light",{"$nulls":13},"1 light","light",{"$nulls":8},0.0,1.0,1.0,4.0,"-"]
["Interceptor",{"$f":"if(BPtotal<$AO3,\"\",A3)","v":""},"Tiny","perfect (turn 0)","perfect (+2 Piloting, turn 0)",2.0,0.0,30.0,5.0,"-",6.0,"forward arc (2 light)","2 light","light","light",{"$nulls":22},0.0,1.0,1.0,6.0,"-"]
["Fighter",{"$f":"if(BPtotal<$AO4,\"\",A4)","v":""},"Tiny","good (turn 1)","good (+1 Piloting, turn 1)",1.0,1.0,35.0,5.0,"-",7.0,"forward arc (2 light [1 must be a tracking weapon], aft arc (1 light)","2 light","light","light (tracking)",{"$nulls":12},"1 light","light",{"$nulls":8},0.0,1.0,2.0,8.0,"-"]
["Shuttle",{"$f":"if(BPtotal<$AO5,\"\",A5)","v":""},"Small","perfect (turn 0)","perfect (+2 Piloting, turn 0)",2.0,0.0,35.0,5.0,"-",7.0,"forward arc (1 light)","1 light","light",{"$nulls":23},3.0,1.0,4.0,6.0,"(usually cargo holds or passenger seating)"]
["Light Freighter",{"$f":"if(BPtotal<$AO6,\"\",A6)","v":""},"Small","good (turn 1)","good (+1 Piloting, turn 1)",1.0,1.0,40.0,10.0,"-",8.0,"forward arc (2 light), port arc (1 light), starboard arc (1 light)","2 light","light","light",null,null,"1 light","light",null,null,null,"1 light","light",{"$nulls":13},3.0,1.0,6.0,10.0,"-"]
["Explorer",{"$f":"if(BPtotal<$AO7,\"\",A7)","v":""},"Medium","good (turn 1)","good (+1 Piloting, turn 1)",1.0,1.0,55.0,10.0,"-",11.0,"forward arc (1 light), port arc (1 light), starboard arc (1 light), turret (1 light)","1 light","light",null,null,null,"1 light","light",null,null,null,"1 light","light",{"$nulls":8},"1 light","light",null,null,null,4.0,1.0,6.0,12.0,"-"]
["Transport",{"$f":"if(BPtotal<$AO8,\"\",A8)","v":""},"Medium","average (turn 2)","average (+0 Piloting, turn 2)",0.0,2.0,70.0,15.0,"-",14.0,"forward arc (1 heavy, 1 light), aft arc (1 light), turret (2 light)","1 heavy, 1 light","heavy","light",{"$nulls":12},"1 light","light",null,null,null,"2 light","light","light",null,null,5.0,1.0,6.0,15.0,"-"]
["Destroyer",{"$f":"if(BPtotal<$AO9,\"\",A9)","v":""},"Large","average (turn 2)","average (+0 Piloting, turn 2)",0.0,2.0,150.0,20.0,"-",30.0,"forward arc (2 heavy), port arc (1 light), starboard arc (1 light), aft arc (1 light), turret (1 light)","2 heavy","heavy","heavy",null,null,"1 light","light",null,null,null,"1 light","light",null,null,null,"1 light","light",null,null,null,"1 light","light",null,null,null,4.0,6.0,20.0,30.0,"-"]
["Heavy Frieghter",{"$f":"if(BPtotal<$AO10,\"\",A10)","v":""},"Large","average (turn 2)","average (+0 Piloting, turn 2)",0.0,2.0,120.0,20.0,"-",24.0,"forward arc (1 heavy, 2 light), port arc (1 heavy), starboard arc (1 heavy)","1 heavy, 2 light","heavy","light","light",null,"1 heavy","heavy",null,null,null,"1 heavy","heavy",{"$nulls":13},8.0,6.0,20.0,40.0,"-"]
["Bulk Freighter",{"$f":"if(BPtotal<$AO11,\"\",A11)","v":""},"Huge","poor (turn 3)","poor (-1 Piloting, turn 3)",-1.0,3.0,160.0,20.0,5.0,32.0,"forward arc (1 heavy), aft arc (1 heavy), turret (2 light) ","1 heavy","heavy",{"$nulls":13},"1 heavy","heavy",null,null,null,"2 light","light","light",null,null,10.0,20.0,50.0,55.0,"-"]
["Cruiser",{"$f":"if(BPtotal<$AO12,\"\",A12)","v":""},"Huge","average (turn 2)","average (+0 Piloting, turn 2)",0.0,2.0,180.0,25.0,5.0,36.0,"forward arc (1 capital), port arc (1 light), starboard arc (1 light), turret (1 heavy)","1 capital","capital",null,null,null,"1 light","light",null,null,null,"1 light","light",{"$nulls":8},"1 heavy","heavy",null,null,null,6.0,20.0,100.0,60.0,"-"]
["Carrier",{"$f":"if(BPtotal<$AO13,\"\",A13)","v":""},"Gargantuan","poor (turn 3)","poor (-1 Piloting, turn 3)",-1.0,3.0,240.0,30.0,10.0,48.0,"forward arc (1 capital), port arc (3 heavy), starboard arc (3 heavy), turret (2 light)","1 capital","capital",null,null,null,"3 heavy","heavy","heavy","heavy",null,"3 heavy","heavy","heavy","heavy",{"$nulls":6},"2 light","light","light",null,null,10.0,75.0,200.0,120.0,"(must have at least 1 hangar bay)"]
["Battleship",{"$f":"if(BPtotal<$AO14,\"\",A14)","v":""},"Gargantuan","average (turn 2)","average (+0 Piloting, turn 2)",0.0,2.0,280.0,40.0,10.0,56.0,"forward arc (1 capital, 2 heavy), port arc (2 heavy, 1 light), starboard arc (2 heavy, 1 light), aft arc (1 light), turret (2 heavy)","1 capital, 2 heavy","capital","heavy","heavy",null,"2 heavy, 1 light","heavy","heavy","light",null,"2 heavy, 1 light","heavy","heavy","light",null,"1 light","light",null,null,null,"2 heavy","heavy","heavy",null,null,8.0,100.0,300.0,150.0,"-"]
["Dreadnought",{"$f":"if(BPtotal<$AO15,\"\",A15)","v":""},"Colossal","clumsy (turn 4)","clumsy (-2 Piloting, turn 4)",-2.0,4.0,400.0,50.0,15.0,80.0,"forward arc (2 capital, 2 heavy), port arc (1 capital, 3 heavy), starboard arc (1 capital, 3 heavy), turret (4 light)","2 capital, 2 heavy","capital","capital","heavy","heavy","1 capital, 3 heavy","capital","heavy","heavy","heavy","1 capital, 3 heavy","capital","heavy","heavy","heavy",{"$nulls":5},"4 light","light","light","light","light",20.0,125.0,500.0,200.0,"-"]
[]
[null,null,null,{"$f":"iferror(index(D2:D17,(match(Frame,FrameChoice,0)),0))","v":""},null,{"$f":"iferror(index(FramePilot,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(FrameTurnT,match(Frame,FrameChoice,0)))","v":""},"HP",{"$f":"BaseHP+rounddown(L17/4)*baseHPinc","v":0},null,{"$f":"I17/5","v":0},{"$f":"if(Tier=\"¼\",1/4,if(Tier=\"⅓\",1/3,if(Tier=\"½\",1/2,Tier)))","v":""},"Weapons (forward)",{"$f":"iferror(index(N2:N15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(O2:O15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(P2:P15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(Q2:Q15,match(Frame,FrameChoice,0)))","v":""},"Weapons (port)",{"$f":"iferror(index(S2:S15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(T2:T15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(U2:U15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(V2:V15,match(Frame,FrameChoice,0)))","v":""},"Weapons (starboard)",{"$f":"iferror(index(X2:X15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(Y2:Y15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(Z2:Z15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AA2:AA15,match(Frame,FrameChoice,0)))","v":""},"Weapons (aft)",{"$f":"iferror(index(AC2:AC15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AD2:AD15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AE2:AE15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AF2:AF15,match(Frame,FrameChoice,0)))","v":""},"Weapons (turret)",{"$f":"iferror(index(AH2:AH15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AI2:AI15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AJ2:AJ15,match(Frame,FrameChoice,0)))","v":""},{"$f":"iferror(index(AK2:AK15,match(Frame,FrameChoice,0)))","v":""}]

{"sheet":"Starship Base Stats","index":16,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Tier","Starship Build Points","Special"]
["¼",25.0]
["⅓",30.0]
["½",40.0]
[1.0,55.0]
[2.0,75.0]
[3.0,95.0]
[4.0,115.0,"HP increase"]
[5.0,135.0]
[6.0,155.0]
[7.0,180.0]
[8.0,205.0,"HP increase"]
[9.0,230.0]
[10.0,270.0]
[11.0,310.0]
[12.0,350.0,"HP increase"]
[13.0,400.0]
[14.0,450.0]
[15.0,500.0]
[16.0,600.0,"HP increase"]
[17.0,700.0]
[18.0,800.0]
[19.0,900.0]
[20.0,1000.0,"HP increase"]

{"sheet":"Starship Scale","index":17,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Size","Size Number","Length","Weight","AC and TL modifier"]
["Tiny",1.0,"20-60 ft.","3-20 tons",2.0]
["Small",2.0,"60-120 ft.","20-40 tons",1.0]
["Medium",3.0,"120-300 ft.","40-150 tons",0.0]
["Large",4.0,"300-800 ft.","150-240 tons",-1.0]
["Huge",5.0,"800-2000 ft.","420-1200 tons",-2.0]
["Gargantuan",6.0,"2000-15000 ft.","1200-8000 tons",-4.0]
["Colossal",7.0,"over 15000 ft.","over 8000 tons",-8.0]
["-"]
[null,{"$f":"iferror(index(SizeNum,match(ShipSize,SizeChoice,0)),0)","v":""},null,null,{"$f":"iferror(index(SizeMod,match(ShipSize,SizeChoice,0)),0)","v":""}]

{"sheet":"Thrusters","index":18,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Thruster","Size","Speed (in hexes)","piloting modifier","PCU","Cost (in BP)","Eligible Thrusters"]
["T6 thrusters","Tiny",6.0,1.0,20.0,3.0,{"$f":"if(ShipSize=B2,A2,\"\")","v":""}]
["T8 thrusters","Tiny",8.0,0.0,25.0,4.0,{"$f":"if(ShipSize=B3,A3,\"\")","v":""}]
["T10 thrusters","Tiny",10.0,0.0,30.0,5.0,{"$f":"if(ShipSize=B4,A4,\"\")","v":""}]
["T12 thrusters","Tiny",12.0,-1.0,35.0,6.0,{"$f":"if(ShipSize=B5,A5,\"\")","v":""}]
["T14 thrusters","Tiny",14.0,-2.0,40.0,7.0,{"$f":"if(ShipSize=B6,A6,\"\")","v":""}]
["S6 thrusters","Small",6.0,1.0,30.0,3.0,{"$f":"if(ShipSize=B7,A7,\"\")","v":""}]
["S8 thrusters","Small",8.0,0.0,40.0,4.0,{"$f":"if(ShipSize=B8,A8,\"\")","v":""}]
["S10 thrusters","Small",10.0,0.0,50.0,5.0,{"$f":"if(ShipSize=B9,A9,\"\")","v":""}]
["S12 thrusters","Small",12.0,-1.0,60.0,6.0,{"$f":"if(ShipSize=B10,A10,\"\")","v":""}]
["M4 thrusters","Medium",4.0,2.0,40.0,2.0,{"$f":"if(ShipSize=B11,A11,\"\")","v":""}]
["M6 thrusters","Medium",6.0,1.0,50.0,3.0,{"$f":"if(ShipSize=B12,A12,\"\")","v":""}]
["M8 thrusters","Medium",8.0,0.0,60.0,4.0,{"$f":"if(ShipSize=B13,A13,\"\")","v":""}]
["M10 thrusters","Medium",10.0,0.0,70.0,5.0,{"$f":"if(ShipSize=B14,A14,\"\")","v":""}]
["M12 thrusters","Medium",12.0,-1.0,80.0,6.0,{"$f":"if(ShipSize=B15,A15,\"\")","v":""}]
["L4 thrusters","Large",4.0,2.0,60.0,4.0,{"$f":"if(ShipSize=B16,A16,\"\")","v":""}]
["L6 thrusters","Large",6.0,1.0,80.0,6.0,{"$f":"if(ShipSize=B17,A17,\"\")","v":""}]
["L8 thrusters","Large",8.0,0.0,100.0,8.0,{"$f":"if(ShipSize=B18,A18,\"\")","v":""}]
["L10 thrusters","Large",10.0,0.0,120.0,10.0,{"$f":"if(ShipSize=B19,A19,\"\")","v":""}]
["H4 thrusters","Huge",4.0,2.0,80.0,4.0,{"$f":"if(ShipSize=B20,A20,\"\")","v":""}]
["H6 thrusters","Huge",6.0,1.0,120.0,6.0,{"$f":"if(ShipSize=B21,A21,\"\")","v":""}]
["H8 thrusters","Huge",8.0,0.0,140.0,8.0,{"$f":"if(ShipSize=B22,A22,\"\")","v":""}]
["H10 thrusters","Huge",10.0,0.0,160.0,10.0,{"$f":"if(ShipSize=B23,A23,\"\")","v":""}]
["G4 thrusters","Gargantuan",4.0,2.0,120.0,8.0,{"$f":"if(ShipSize=B24,A24,\"\")","v":""}]
["G6 thrusters","Gargantuan",6.0,1.0,180.0,12.0,{"$f":"if(ShipSize=B25,A25,\"\")","v":""}]
["G8 thrusters","Gargantuan",8.0,0.0,240.0,16.0,{"$f":"if(ShipSize=B26,A26,\"\")","v":""}]
["C4 thrusters","Colossal",4.0,2.0,200.0,8.0,{"$f":"if(ShipSize=B27,A27,\"\")","v":""}]
["C6 thrusters","Colossal",6.0,1.0,300.0,12.0,{"$f":"if(ShipSize=B28,A28,\"\")","v":""}]
["C8 thrusters","Colossal",8.0,0.0,400.0,16.0,{"$f":"if(ShipSize=B29,A29,\"\")","v":""}]

{"sheet":"Upgrades","index":19,"n_rows":49,"n_cols":27,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Upgrade Slot>>>",null,"fore","F1","F2","F3","F4","port","P1","P2","P3","P4","starboard","S1","S2","S3","S4","aft","A1","A2","A3","A4","turret","T1","T2","T3","T4"]
["Weapons Chosen>>>",null,null,{"$f":"transpose(WeaponsFore)","v":""},{"$nulls":4},{"$f":"transpose(WeaponsPort)","v":""},{"$nulls":4},{"$f":"transpose(WeaponsStarboard)","v":""},{"$nulls":4},{"$f":"transpose(WeaponsAft)","v":""},{"$nulls":4},{"$f":"transpose(WeaponsTurret)","v":""}]
["Weapon Lists for each slot>",null,{"$f":"'Ship Frames'!M17:AK17","v":"Weapons (forward)"},{"$nulls":4},"Weapons (port)",{"$nulls":4},"Weapons (starboard)",{"$nulls":4},"Weapons (aft)",{"$nulls":4},"Weapons (turret)"]
[null,null,null,{"$f":"if(and(C2=\"micromissile battery (slot 1/2)\",D32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(C2=\"heavy laser array (slot 1/2)\",D32<>\"\"),\"heavy laser array (slot 2/2)\",if(D32=\"light\",sort(WeaponLight),if(D32=\"light (tracking)\",sort(WeaponLightTracking),if(D32=\"heavy\",sort(WeaponHeavy),if(D32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(D2=\"micromissile battery (slot 1/2)\",E32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(D2=\"heavy laser array (slot 1/2)\",E32<>\"\"),\"heavy laser array (slot 2/2)\",if(E32=\"light\",sort(WeaponLight),if(E32=\"light (tracking)\",sort(WeaponLightTracking),if(E32=\"heavy\",sort(WeaponHeavy),if(E32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(E2=\"micromissile battery (slot 1/2)\",F32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(E2=\"heavy laser array (slot 1/2)\",F32<>\"\"),\"heavy laser array (slot 2/2)\",if(F32=\"light\",sort(WeaponLight),if(F32=\"light (tracking)\",sort(WeaponLightTracking),if(F32=\"heavy\",sort(WeaponHeavy),if(F32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(F2=\"micromissile battery (slot 1/2)\",G32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(F2=\"heavy laser array (slot 1/2)\",G32<>\"\"),\"heavy laser array (slot 2/2)\",if(G32=\"light\",sort(WeaponLight),if(G32=\"light (tracking)\",sort(WeaponLightTracking),if(G32=\"heavy\",sort(WeaponHeavy),if(G32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(G2=\"micromissile battery (slot 1/2)\",H32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(G2=\"heavy laser array (slot 1/2)\",H32<>\"\"),\"heavy laser array (slot 2/2)\",if(H32=\"light\",sort(WeaponLight),if(H32=\"light (tracking)\",sort(WeaponLightTracking),if(H32=\"heavy\",sort(WeaponHeavy),if(H32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(H2=\"micromissile battery (slot 1/2)\",I32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(H2=\"heavy laser array (slot 1/2)\",I32<>\"\"),\"heavy laser array (slot 2/2)\",if(I32=\"light\",sort(WeaponLight),if(I32=\"light (tracking)\",sort(WeaponLightTracking),if(I32=\"heavy\",sort(WeaponHeavy),if(I32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(I2=\"micromissile battery (slot 1/2)\",J32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(I2=\"heavy laser array (slot 1/2)\",J32<>\"\"),\"heavy laser array (slot 2/2)\",if(J32=\"light\",sort(WeaponLight),if(J32=\"light (tracking)\",sort(WeaponLightTracking),if(J32=\"heavy\",sort(WeaponHeavy),if(J32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(J2=\"micromissile battery (slot 1/2)\",K32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(J2=\"heavy laser array (slot 1/2)\",K32<>\"\"),\"heavy laser array (slot 2/2)\",if(K32=\"light\",sort(WeaponLight),if(K32=\"light (tracking)\",sort(WeaponLightTracking),if(K32=\"heavy\",sort(WeaponHeavy),if(K32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(K2=\"micromissile battery (slot 1/2)\",L32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(K2=\"heavy laser array (slot 1/2)\",L32<>\"\"),\"heavy laser array (slot 2/2)\",if(L32=\"light\",sort(WeaponLight),if(L32=\"light (tracking)\",sort(WeaponLightTracking),if(L32=\"heavy\",sort(WeaponHeavy),if(L32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(L2=\"micromissile battery (slot 1/2)\",M32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(L2=\"heavy laser array (slot 1/2)\",M32<>\"\"),\"heavy laser array (slot 2/2)\",if(M32=\"light\",sort(WeaponLight),if(M32=\"light (tracking)\",sort(WeaponLightTracking),if(M32=\"heavy\",sort(WeaponHeavy),if(M32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(M2=\"micromissile battery (slot 1/2)\",N32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(M2=\"heavy laser array (slot 1/2)\",N32<>\"\"),\"heavy laser array (slot 2/2)\",if(N32=\"light\",sort(WeaponLight),if(N32=\"light (tracking)\",sort(WeaponLightTracking),if(N32=\"heavy\",sort(WeaponHeavy),if(N32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(N2=\"micromissile battery (slot 1/2)\",O32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(N2=\"heavy laser array (slot 1/2)\",O32<>\"\"),\"heavy laser array (slot 2/2)\",if(O32=\"light\",sort(WeaponLight),if(O32=\"light (tracking)\",sort(WeaponLightTracking),if(O32=\"heavy\",sort(WeaponHeavy),if(O32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(O2=\"micromissile battery (slot 1/2)\",P32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(O2=\"heavy laser array (slot 1/2)\",P32<>\"\"),\"heavy laser array (slot 2/2)\",if(P32=\"light\",sort(WeaponLight),if(P32=\"light (tracking)\",sort(WeaponLightTracking),if(P32=\"heavy\",sort(WeaponHeavy),if(P32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(P2=\"micromissile battery (slot 1/2)\",Q32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(P2=\"heavy laser array (slot 1/2)\",Q32<>\"\"),\"heavy laser array (slot 2/2)\",if(Q32=\"light\",sort(WeaponLight),if(Q32=\"light (tracking)\",sort(WeaponLightTracking),if(Q32=\"heavy\",sort(WeaponHeavy),if(Q32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(Q2=\"micromissile battery (slot 1/2)\",R32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(Q2=\"heavy laser array (slot 1/2)\",R32<>\"\"),\"heavy laser array (slot 2/2)\",if(R32=\"light\",sort(WeaponLight),if(R32=\"light (tracking)\",sort(WeaponLightTracking),if(R32=\"heavy\",sort(WeaponHeavy),if(R32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(R2=\"micromissile battery (slot 1/2)\",S32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(R2=\"heavy laser array (slot 1/2)\",S32<>\"\"),\"heavy laser array (slot 2/2)\",if(S32=\"light\",sort(WeaponLight),if(S32=\"light (tracking)\",sort(WeaponLightTracking),if(S32=\"heavy\",sort(WeaponHeavy),if(S32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(S2=\"micromissile battery (slot 1/2)\",T32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(S2=\"heavy laser array (slot 1/2)\",T32<>\"\"),\"heavy laser array (slot 2/2)\",if(T32=\"light\",sort(WeaponLight),if(T32=\"light (tracking)\",sort(WeaponLightTracking),if(T32=\"heavy\",sort(WeaponHeavy),if(T32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(T2=\"micromissile battery (slot 1/2)\",U32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(T2=\"heavy laser array (slot 1/2)\",U32<>\"\"),\"heavy laser array (slot 2/2)\",if(U32=\"light\",sort(WeaponLight),if(U32=\"light (tracking)\",sort(WeaponLightTracking),if(U32=\"heavy\",sort(WeaponHeavy),if(U32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(U2=\"micromissile battery (slot 1/2)\",V32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(U2=\"heavy laser array (slot 1/2)\",V32<>\"\"),\"heavy laser array (slot 2/2)\",if(V32=\"light\",sort(WeaponLight),if(V32=\"light (tracking)\",sort(WeaponLightTracking),if(V32=\"heavy\",sort(WeaponHeavy),if(V32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(V2=\"micromissile battery (slot 1/2)\",W32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(V2=\"heavy laser array (slot 1/2)\",W32<>\"\"),\"heavy laser array (slot 2/2)\",if(W32=\"light\",sort(WeaponLight),if(W32=\"light (tracking)\",sort(WeaponLightTracking),if(W32=\"heavy\",sort(WeaponHeavy),if(W32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(W2=\"micromissile battery (slot 1/2)\",X32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(W2=\"heavy laser array (slot 1/2)\",X32<>\"\"),\"heavy laser array (slot 2/2)\",if(X32=\"light\",sort(WeaponLight),if(X32=\"light (tracking)\",sort(WeaponLightTracking),if(X32=\"heavy\",sort(WeaponHeavy),if(X32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(X2=\"micromissile battery (slot 1/2)\",Y32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(X2=\"heavy laser array (slot 1/2)\",Y32<>\"\"),\"heavy laser array (slot 2/2)\",if(Y32=\"light\",sort(WeaponLight),if(Y32=\"light (tracking)\",sort(WeaponLightTracking),if(Y32=\"heavy\",sort(WeaponHeavy),if(Y32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(Y2=\"micromissile battery (slot 1/2)\",Z32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(Y2=\"heavy laser array (slot 1/2)\",Z32<>\"\"),\"heavy laser array (slot 2/2)\",if(Z32=\"light\",sort(WeaponLight),if(Z32=\"light (tracking)\",sort(WeaponLightTracking),if(Z32=\"heavy\",sort(WeaponHeavy),if(Z32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""},{"$f":"if(and(Z2=\"micromissile battery (slot 1/2)\",AA32<>\"\"),\"micromissile battery (slot 2/2)\",if(and(Z2=\"heavy laser array (slot 1/2)\",AA32<>\"\"),\"heavy laser array (slot 2/2)\",if(AA32=\"light\",sort(WeaponLight),if(AA32=\"light (tracking)\",sort(WeaponLightTracking),if(AA32=\"heavy\",sort(WeaponHeavy),if(AA32=\"capital\",sort(WeaponCapital),\"\"))))))","v":""}]
{"$rows_empty":8}
["DAMAGE LIST"]
["FUNCTIONAL"]
["GLITCHING"]
["MALFUNCTIONING"]
["WRECKED"]
[]
[]
[]
[]
[]
[]
["upgrade costs"]
[{"$f":"if(ShipSizeNum>=5,\"Upgrade Mount Hy>Cp\",\"\")","v":""},5.0]
[{"$f":"if(ShipSizeNum>=3,\"Upgrade Mount Lt>Hy\",\"\")","v":""},4.0]
["Add Light Mount",3.0]
[]
[{"$f":"if(ShipSizeNum>=3,\"Upgrade Turret Lt>Hy\",\"\")","v":""},6.0]
["Add Light Turret",5.0]
[]
["upgradeSlots",null,{"$f":"C3","v":"Weapons (forward)"},{"$f":"if(D33=\"\",D3,IF(OR(D33=UpHeavy,D33=upHeavyTurret),\"heavy\",if(D33=upCapital,\"capital\",if(OR(D33=upLight,D33=upLightTurret),\"light\"))))","v":""},{"$f":"if(E33=\"\",E3,IF(OR(E33=UpHeavy,E33=upHeavyTurret),\"heavy\",if(E33=upCapital,\"capital\",if(OR(E33=upLight,E33=upLightTurret),\"light\",\"\"))))","v":""},{"$f":"if(F33=\"\",F3,IF(OR(F33=UpHeavy,F33=upHeavyTurret),\"heavy\",if(F33=upCapital,\"capital\",if(OR(F33=upLight,F33=upLightTurret),\"light\"))))","v":""},{"$f":"if(G33=\"\",G3,IF(OR(G33=UpHeavy,G33=upHeavyTurret),\"heavy\",if(G33=upCapital,\"capital\",if(OR(G33=upLight,G33=upLightTurret),\"light\"))))","v":""},{"$f":"H3","v":"Weapons (port)"},{"$f":"if(I33=\"\",I3,IF(OR(I33=UpHeavy,I33=upHeavyTurret),\"heavy\",if(I33=upCapital,\"capital\",if(OR(I33=upLight,I33=upLightTurret),\"light\"))))","v":""},{"$f":"if(J33=\"\",J3,IF(OR(J33=UpHeavy,J33=upHeavyTurret),\"heavy\",if(J33=upCapital,\"capital\",if(OR(J33=upLight,J33=upLightTurret),\"light\"))))","v":""},{"$f":"if(K33=\"\",K3,IF(OR(K33=UpHeavy,K33=upHeavyTurret),\"heavy\",if(K33=upCapital,\"capital\",if(OR(K33=upLight,K33=upLightTurret),\"light\"))))","v":""},{"$f":"if(L33=\"\",L3,IF(OR(L33=UpHeavy,L33=upHeavyTurret),\"heavy\",if(L33=upCapital,\"capital\",if(OR(L33=upLight,L33=upLightTurret),\"light\"))))","v":""},{"$f":"M3","v":"Weapons (starboard)"},{"$f":"if(N33=\"\",N3,IF(OR(N33=UpHeavy,N33=upHeavyTurret),\"heavy\",if(N33=upCapital,\"capital\",if(OR(N33=upLight,N33=upLightTurret),\"light\"))))","v":""},{"$f":"if(O33=\"\",O3,IF(OR(O33=UpHeavy,O33=upHeavyTurret),\"heavy\",if(O33=upCapital,\"capital\",if(OR(O33=upLight,O33=upLightTurret),\"light\"))))","v":""},{"$f":"if(P33=\"\",P3,IF(OR(P33=UpHeavy,P33=upHeavyTurret),\"heavy\",if(P33=upCapital,\"capital\",if(OR(P33=upLight,P33=upLightTurret),\"light\"))))","v":""},{"$f":"if(Q33=\"\",Q3,IF(OR(Q33=UpHeavy,Q33=upHeavyTurret),\"heavy\",if(Q33=upCapital,\"capital\",if(OR(Q33=upLight,Q33=upLightTurret),\"light\"))))","v":""},{"$f":"R3","v":"Weapons (aft)"},{"$f":"if(S33=\"\",S3,IF(OR(S33=UpHeavy,S33=upHeavyTurret),\"heavy\",if(S33=upCapital,\"capital\",if(OR(S33=upLight,S33=upLightTurret),\"light\"))))","v":""},{"$f":"if(T33=\"\",T3,IF(OR(T33=UpHeavy,T33=upHeavyTurret),\"heavy\",if(T33=upCapital,\"capital\",if(OR(T33=upLight,T33=upLightTurret),\"light\"))))","v":""},{"$f":"if(U33=\"\",U3,IF(OR(U33=UpHeavy,U33=upHeavyTurret),\"heavy\",if(U33=upCapital,\"capital\",if(OR(U33=upLight,U33=upLightTurret),\"light\"))))","v":""},{"$f":"if(V33=\"\",V3,IF(OR(V33=UpHeavy,V33=upHeavyTurret),\"heavy\",if(V33=upCapital,\"capital\",if(OR(V33=upLight,V33=upLightTurret),\"light\"))))","v":""},{"$f":"W3","v":"Weapons (turret)"},{"$f":"if(X33=\"\",X3,IF(OR(X33=UpHeavy,X33=upHeavyTurret),\"heavy\",if(X33=upCapital,\"capital\",if(OR(X33=upLight,X33=upLightTurret),\"light\"))))","v":""},{"$f":"if(Y33=\"\",Y3,IF(OR(Y33=UpHeavy,Y33=upHeavyTurret),\"heavy\",if(Y33=upCapital,\"capital\",if(OR(Y33=upLight,Y33=upLightTurret),\"light\"))))","v":""},{"$f":"if(Z33=\"\",Z3,IF(OR(Z33=UpHeavy,Z33=upHeavyTurret),\"heavy\",if(Z33=upCapital,\"capital\",if(OR(Z33=upLight,Z33=upLightTurret),\"light\"))))","v":""},{"$f":"if(AA33=\"\",AA3,IF(OR(AA33=UpHeavy,AA33=upHeavyTurret),\"heavy\",if(AA33=upCapital,\"capital\",if(OR(AA33=upLight,AA33=upLightTurret),\"light\"))))","v":""}]
["transposed upgrade choice>>>",null,{"$f":"transpose(Build!G82:G106)","v":"UPGRADE OR ADD MOUNT"},{"$nulls":4},"UPGRADE OR ADD MOUNT",{"$nulls":4},"UPGRADE OR ADD MOUNT",{"$nulls":4},"UPGRADE OR ADD MOUNT",{"$nulls":4},"UPGRADE OR ADD MOUNT"]
["upgrade slot to capital>>>",null,null,{"$f":"if(D$3=\"\",$A$25:$A$27,if(D$3=\"light\",$A$25:$A$26,if(D$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(E$3=\"\",$A$25:$A$27,if(E$3=\"light\",$A$25:$A$26,if(E$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\"),\"\",if(F$3=\"\",$A$25:$A$27,if(F$3=\"light\",$A$25:$A$26,if(F$3=\"heavy\",upCapital,\"\"))))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\", ShipSize=\"medium\",ShipSize=\"large\"),\"\",if(G$3=\"\",$A$25:$A$27,if(G$3=\"light\",$A$25:$A$26,if(G$3=\"heavy\",upCapital,\"\"))))","v":""},null,{"$f":"if(I$3=\"\",$A$25:$A$27,if(I$3=\"light\",$A$25:$A$26,if(I$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(J$3=\"\",$A$25:$A$27,if(J$3=\"light\",$A$25:$A$26,if(J$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\"),\"\",if(K$3=\"\",$A$25:$A$27,if(K$3=\"light\",$A$25:$A$26,if(K$3=\"heavy\",upCapital,\"\"))))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\", ShipSize=\"medium\",ShipSize=\"large\"),\"\",if(L$3=\"\",$A$25:$A$27,if(L$3=\"light\",$A$25:$A$26,if(L$3=\"heavy\",upCapital,\"\"))))","v":""},null,{"$f":"if(N$3=\"\",$A$25:$A$27,if(N$3=\"light\",$A$25:$A$26,if(N$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(O$3=\"\",$A$25:$A$27,if(O$3=\"light\",$A$25:$A$26,if(O$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\"),\"\",if(P$3=\"\",$A$25:$A$27,if(P$3=\"light\",$A$25:$A$26,if(P$3=\"heavy\",upCapital,\"\"))))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\", ShipSize=\"medium\",ShipSize=\"large\"),\"\",if(Q$3=\"\",$A$25:$A$27,if(Q$3=\"light\",$A$25:$A$26,if(Q$3=\"heavy\",upCapital,\"\"))))","v":""},null,{"$f":"if(S$3=\"\",$A$25:$A$27,if(S$3=\"light\",$A$25:$A$26,if(S$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(T$3=\"\",$A$25:$A$27,if(T$3=\"light\",$A$25:$A$26,if(T$3=\"heavy\",upCapital,\"\")))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\"),\"\",if(U$3=\"\",$A$25:$A$27,if(U$3=\"light\",$A$25:$A$26,if(U$3=\"heavy\",upCapital,\"\"))))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\", ShipSize=\"medium\",ShipSize=\"large\"),\"\",if(V$3=\"\",$A$25:$A$27,if(V$3=\"light\",$A$25:$A$26,if(V$3=\"heavy\",upCapital,\"\"))))","v":""}]
["upgrade slot to heavy>>>",null,null,"","","","",null,"","","","",null,"","","","",null,"","","","",null,{"$f":"if(X$3=\"\",$A$29:$A$30,if(X$3=\"light\",upHeavyTurret,\"\"))","v":""},{"$f":"if(Y$3=\"\",$A$29:$A$30,if(Y$3=\"light\",upHeavyTurret,\"\"))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\"),\"\",if(Z$3=\"\",$A$29:$A$30,if(Z$3=\"light\",upHeavyTurret,\"\")))","v":""},{"$f":"if(OR(ShipSize=\"tiny\",ShipSize=\"small\", ShipSize=\"medium\",ShipSize=\"large\"),\"\",if(AA$3=\"\",$A$29:$A$30,if(AA$3=\"light\",upHeavyTurret,\"\")))","v":""}]
["add light mount>>>",null,null,"Add Light Mount","Add Light Mount","Add Light Mount","Add Light Mount",null,"Add Light Mount","Add Light Mount","Add Light Mount","Add Light Mount",null,"Add Light Mount","Add Light Mount","Add Light Mount","Add Light Mount",null,"Add Light Mount","Add Light Mount","Add Light Mount","Add Light Mount",null,"Add Light Turret","Add Light Turret","Add Light Turret","Add Light Turret"]
["cost for capital upgrade>>>",null,null,{"$f":"if(D34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(E34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(F34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(G34<>\"\",upCapitalCost,\"\")","v":""},null,{"$f":"if(I34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(J34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(K34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(L34<>\"\",upCapitalCost,\"\")","v":""},null,{"$f":"if(N34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(O34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(P34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(Q34<>\"\",upCapitalCost,\"\")","v":""},null,{"$f":"if(S34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(T34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(U34<>\"\",upCapitalCost,\"\")","v":""},{"$f":"if(V34<>\"\",upCapitalCost,\"\")","v":""}]
["cost for heavy upgrade>>>",null,null,{"$f":"if(D35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(E35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(F35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(G35<>\"\",UpHeavyCost,\"\")","v":""},null,{"$f":"if(I35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(J35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(K35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(L35<>\"\",UpHeavyCost,\"\")","v":""},null,{"$f":"if(N35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(O35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(P35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(Q35<>\"\",UpHeavyCost,\"\")","v":""},null,{"$f":"if(S35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(T35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(U35<>\"\",UpHeavyCost,\"\")","v":""},{"$f":"if(V35<>\"\",UpHeavyCost,\"\")","v":""},null,{"$f":"if(X35<>\"\",upHeavyTurretCost,\"\")","v":""},{"$f":"if(Y35<>\"\",upHeavyTurretCost,\"\")","v":""},{"$f":"if(Z35<>\"\",upHeavyTurretCost,\"\")","v":""},{"$f":"if(AA35<>\"\",upHeavyTurretCost,\"\")","v":""}]
["cost to add light mount>>>",null,null,{"$f":"if(D36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(E36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(F36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(G36<>\"\",upLightCost,\"\")","v":3},null,{"$f":"if(I36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(J36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(K36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(L36<>\"\",upLightCost,\"\")","v":3},null,{"$f":"if(N36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(O36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(P36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(Q36<>\"\",upLightCost,\"\")","v":3},null,{"$f":"if(S36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(T36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(U36<>\"\",upLightCost,\"\")","v":3},{"$f":"if(V36<>\"\",upLightCost,\"\")","v":3},null,{"$f":"if(X36<>\"\",upLightTurretCost,\"\")","v":5},{"$f":"if(Y36<>\"\",upLightTurretCost,\"\")","v":5},{"$f":"if(Z36<>\"\",upLightTurretCost,\"\")","v":5},{"$f":"if(AA36<>\"\",upLightTurretCost,\"\")","v":5}]
["upgradeMountCost",null,null,{"$f":"if(D33=\"\",\"\",if(D33=D36,D39,if(D33=D35,sum(D39,D38),if(D33=D34,sum(D37:D39),\"\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","","",""]
["Damage import>>>",null,{"$f":"transpose(Build!I82:I106)","v":"DAMAGE"},"","","","","DAMAGE","","","","","DAMAGE","","","","","DAMAGE","","","","","DAMAGE","","","",""]
[null,null,null,{"$f":"transpose(weaponsWlink)","v":""}]
["looking for arrays and consolidating",null,null,{"$f":"IF(D42=\"micromissile battery (slot 1/2)\",\"micromissile battery\",if(D42=\"micromissile battery (slot 2/2)\",\"\",if(D42=\"heavy laser array (slot 1/2)\",\"heavy laser array\",if(D42=\"heavy laser array (slot 2/2)\",\"\",D42))))","v":""},"","","","","","","","","","","","","","","","","","","","","","",""]
["Weapons with Damage for STATBLOCK>>>",null,null,{"$f":"if(D43<>\"\",D43&\" (\"&D41&\")\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"sensors","quarters","armor","defensive","icm","security","compy counters",{"$nulls":9},"Modifiers","ICM","SensorMod","pilot bonus",{"$nulls":4},"Countermeasures"]
["List of other Systems>>>",null,{"$f":"Sensor","v":""},{"$f":"Crew","v":""},{"$f":"Armor","v":""},{"$f":"DefCounter","v":""},{"$f":"ICM&IF(Tier<>\"\",\" (tier \"&Tier&\")\",\"\")","v":""},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(\"\"security (\"\"&join(\"\", \"\", FILTER(sort(Security), NOT(Security = \"\"\"\")))&\"\")\"\",\"\"\"\")\"),\"\")","v":""},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"iferror(\"\"countermeasures (\"\"&join(\"\", \"\", FILTER(sort(ComCounterAll), NOT(ComCounterAll = \"\"\"\")))&\"\")\"\",\"\"\"\")\"),\"\")","v":""},{"$nulls":9},">>>",{"$f":"ICMbonus","v":0},{"$f":"if(SensorModCompy<>0,SensorModCompy&\" Computers\",\"\")","v":""},{"$f":"IF((FramePilotBonus+ThrusterPilotBonus)>0,\"+\",\"\")&FramePilotBonus+ThrusterPilotBonus&\" Piloting\"","v":"0 Piloting"},{"$nulls":4},{"$f":"TLbonus+ArmorTL","v":0}]
[null,"total",null,"pilot bonus","armor bonus/countermeasures","size mod","misc mod"]
["ACtotal>>>",{"$f":"sum(C48:G48)","v":10},10.0,{"$f":"PilotBonus","v":""},{"$f":"ArmorBonus","v":0},{"$f":"SizeBonus","v":""},{"$f":"ACmiscMod","v":""}]
["TLtotal>>>",10,10.0,{"$f":"PilotBonus","v":""},{"$f":"Countermeasures","v":0},{"$f":"SizeBonus","v":""},{"$f":"TLmiscMod","v":""}]

{"sheet":"Maneuverability","index":20,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Maneuverability","turn"]
["Clumsy",4.0]
["Poor",3.0]
["Average",2.0]
["Good",1.0]
["Perfect",0.0]
[]
[{"$f":"iferror(if((FrameTurn+ArmorTurn)<=4,index(A2:A6,match(FrameTurn+ArmorTurn,B2:B6,0)),\"clumsy\")&\" (turn \"&(FrameTurn+ArmorTurn)&\")\",\"\")","v":"Perfect (turn 0)"}]

{"sheet":"Weapons","index":21,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Class","Type","Weapon","Range","Speed (in Hexes)","# of dice","LinkDice","Damage","PCU","Cost (in BP)","Special Properties","Mounts used"]
["Light","Direct","chain cannon","Short","-",6.0,"d4","6d4",15.0,15.0,"Ripper",1.0]
["Light","Direct","coilgun","Long","-",4.0,"d4","4d4",10.0,6.0,"-",1.0]
["Light","Direct","flak thrower","Short","-",3.0,"d4","3d4",10.0,5.0,"Point (+8)",1.0]
["Light","Direct","gyrolaser","Short","-",1.0,"d8","1d8",10.0,3.0,"Broad arc",1.0]
["Light","Direct","laser net","Short","-",2.0,"d6","2d6",10.0,9.0,"Point (+10)",1.0]
["Light","Direct","light emp cannon","Short","-",null,"special","Special",10.0,8.0,"EMP",1.0]
["Light","Direct","light laser cannon","Short","-",2.0,"d4","2d4",5.0,2.0,"-",1.0]
["Light","Direct","light particle beam","Medium","-",3.0,"d6","3d6",10.0,10.0,"-",1.0]
["Light","Direct","light plasma cannon","Short","-",2.0,"d12","2d12",10.0,12.0,"-",1.0]
["Light","Tracking","high explosive missile launcher","Long",12.0,4.0,"d8","4d8",10.0,4.0,"Limited fire 5",1.0]
["Light","Tracking","light plasma torpedo launcher","Long",14.0,3.0,"d8","3d8",5.0,5.0,"Limited fire 5",1.0]
["Light","Tracking","light torpedo launcher","Long",16.0,2.0,"d8","2d8",5.0,4.0,"-",1.0]
["Light","Tracking","micromissile battery (slot 1/2)","Long",10.0,2.0,"d6","2d6",10.0,3.0,"Array, limited fire 5",2.0]
["Light","Tracking","tactical nuclear missile launcher","Long",10.0,5.0,"d8","5d8",10.0,5.0,"Irradiate (low), limited fire 5",1.0]
["Heavy","Direct","graser","Short","-",7.0,"d10","7d10",40.0,35.0,"Irradiate (medium)",1.0]
["Heavy","Direct","gravity gun","Medium","-",6.0,"d6","6d6",40.0,30.0,"Tractor beam",1.0]
["Heavy","Direct","heavy emp cannon","Medium","-",null,"special","Special",30.0,24.0,"EMP",1.0]
["Heavy","Direct","heavy laser array (slot 1/2)","Short","-",6.0,"d4","6d4",15.0,10.0,"Array",2.0]
["Heavy","Direct","heavy laser cannon","Medium","-",4.0,"d8","4d8",10.0,8.0,"-",1.0]
["Heavy","Direct","heavy laser net","Short","-",5.0,"d6","5d6",15.0,12.0,"Point (+12)",1.0]
["Heavy","Direct","maser","Long","-",6.0,"d10","6d10",35.0,22.0,"-",1.0]
["Heavy","Direct","particle beam","Long","-",8.0,"d6","8d6",25.0,15.0,"-",1.0]
["Heavy","Direct","persistent particle beam","Long","-",10.0,"d6","10d6",40.0,25.0,"-",1.0]
["Heavy","Direct","plasma cannon","Medium","-",5.0,"d12","5d12",30.0,20.0,"-",1.0]
["Heavy","Direct","railgun","Long","-",8.0,"d4","8d4",20.0,15.0,"-",1.0]
["Heavy","Direct","twin laser","Long","-",5.0,"d8","5d8",15.0,12.0,"-",1.0]
["Heavy","Direct","x-laser cannon","Long","-",8.0,"d6","8d6",40.0,35.0,"Line",1.0]
["Heavy","Tracking","heavy antimatter missile launcher","Long",8.0,10.0,"d10","10d10",15.0,12.0,"Limited fire 5",1.0]
["Heavy","Tracking","heavy nuclear missile launcher","Long",10.0,10.0,"d8","10d8",15.0,10.0,"Irradiate (medium), limited fire 5",1.0]
["Heavy","Tracking","heavy plasma torpedo launcher","Long",12.0,5.0,"d10","5d10",10.0,10.0,"Limited fire 5",1.0]
["Heavy","Tracking","heavy torpedo launcher","Long",14.0,5.0,"d8","5d8",10.0,8.0,"Limited fire 5",1.0]
["Capital","Direct","gravity cannon","Long","-",2.0,"d6 x 10","2d6 x 10",40.0,50.0,"Tractor beam",1.0]
["Capital","Direct","mass driver","Long","-",2.0,"d6 x 10","2d6 x 10",25.0,25.0,"-",1.0]
["Capital","Direct","particle beam cannon","Long","-",3.0,"d4 x 10","3d4 x 10",30.0,30.0,"-",1.0]
["Capital","Direct","persistent particle beam cannon","Long","-",2.0,"d10 x 10","2d10 x 10",50.0,40.0,"-",1.0]
["Capital","Direct","super emp cannon","Long","-",null,"Special","Special",45.0,45.0,"EMP",1.0]
["Capital","Direct","super plasma cannon","Medium","-",3.0,"d6 x 10","3d6 x 10",45.0,35.0,"-",1.0]
["Capital","Direct","super x-laser cannon","Long","-",3.0,"d4 x 10","3d4 x 10",50.0,60.0,"Line",1.0]
["Capital","Direct","supergraser","Medium","-",2.0,"d8 x 10","2d8 x 10",50.0,60.0,"Irradiate (high)",1.0]
["Capital","Direct","superlaser","Long","-",2.0,"d4 x 10","2d4 x 10",20.0,20.0,"-",1.0]
["Capital","Direct","supermaser","Long","-",2.0,"d8 x 10","2d8 x 10",40.0,35.0,"-",1.0]
["Capital","Direct","vortex cannon","Medium","-",2.0,"d12 x 10","2d12 x 10",55.0,75.0,"Vortex",1.0]
["Capital","Tracking","antimatter mega-missile launcher","Long",6.0,4.0,"d10 x 10","4d10 x 10",15.0,25.0,"Limited fire 5",1.0]
["Capital","Tracking","hellfire torpedo launcher","Long",8.0,2.0,"d10 x 10","2d10 x 10",10.0,25.0,"Limited fire 5",1.0]
["Capital","Tracking","nuclear mega-missile launcher","Long",8.0,4.0,"d8 x 10","4d8 x 10",15.0,20.0,"Limited fire 5",1.0]
["Capital","Tracking","quantum missile launcher","Long",12.0,2.0,"d8 x 10","2d8 x 10",15.0,20.0,"Limited fire 5, quantum",1.0]
["Capital","Tracking","solar torpedo launcher","Long",10.0,2.0,"d6 x 10","2d6 x 10",10.0,20.0,"Limited fire 5",1.0]
[null,null,"heavy laser array"]
[null,null,"micromissile battery"]

{"sheet":"Example MakesModels","index":22,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["MAKE","MODEL","FRAME","RACE"]
["Atech","Immortal","cruiser","Pact Worlds"]
["Blackwind","Sepulcher","transport","Eoxian"]
["BMC","Mauler","fighter","Veskarium"]
["Death's Head","Necroglider","interceptor","Eoxian"]
["Hivonyx","Titan Hauler","bulk freighter","shirren"]
["Idaran","Voidrunner","racer","Kasathan"]
["Idaran","Vasarai","heavy freighter","Kasathan"]
["Idaran","Millennia","carrier","Kasathan"]
["Kelvolari","Venture","Explorer","Pact Worlds"]
["Norikama","Dropship","transport","Veskarium"]
["Ringworks","Wanderer","shuttle","Pact Worlds"]
["Ringworks","Starwasp","shuttle","Pact Worlds"]
["Sanjaval","Vagabond","explorer","Pact Worlds"]
["Starhive","Drone Mk I","light freighter","shirren"]
["Starhive","Drone Mk II","light freighter","shirren"]
["Starhive","Drone Mk III","light freighter","shirren"]
["Thaumtech","Omenbringer","battleship","Eoxian"]
["UIE","Hiveguard","destroyer","shirren"]
["Vindicas","Tyrant","dreadnought","Veskarium"]

{"sheet":"Version History","index":23,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["VERSION","DATE","NOTES"]
["v1.42","2017-08-26","Added an instructions/credits page.\nAdded a link to make a copy of the sheet.\nAdded a link to fund my caffeine habit."]
["v1.41","2017-08-25","CHANGED MOUNT CALCULATION to count the cost BEFORE you buy the weapons.\nUpdated the reset script to include the PILOT RANKS box on the Ship Sheet.\nEdited the turn calculation since it did not account for maneuverability lower than clumsy. Anything with turn>4 is still called clumsy now. I guess?\nFixed the ICM dropdown (for real this time) to include mk9 and mk10 computrons.\nDisallowed choosing crew quarters for tiny size ships. No more tiny quarters for your gnomes, pixies, and fairies.\nAdded a notation to more clearly show which weapons are linked.\nFixed some issues with having 4 of the same weapon on a single arc. I believe these were introduced when I added the ability to link arrays. That whole thing about fixing one problem causing another thing to break..."]
["v1.4","2017-08-23","BIG UPDATE! Lot's of bugs.\n\"The sheet won't let you link array weapons\" - This one was a doozy. Every time I fixed one thing, it broke another. Woof.\n\"The bonus to piloting checks from \"maneuverability\" and \"thruster speed\" are being added to the ships AC and TL in the \"pilot bonus\" spot.\" - rules error on my part. I know I read the thing that says the pilot only adds ranks in piloting to AC, but I forgot I guess. THERE'S A LOT OF RULES GUYS! I get confused. Fixed it and added a blue spot to enter in ranks of piloting.\n\"The \"Misc Mods\" box isn't being added into the AC/TL calculation.\" - forgot to add it. Fixed.\n\"Any modifiers to \"turn\", like from the heavier armor, isn't being adjusted.\" - changed the tables and separated out turn mod from armor and frame. Added a check to see total turn mod and give a name to maneuverability based on the final number.\n\"The \"\"critical threshold\"\" isn't being modified when the ship's HP changes do to higher tiers\" - Build sheet still reflects base hp and ct, but the ship sheet and stablock reflect higher tiers.\n\"If you link two weapons that have a \"x10\" damage it won't show up once they're linked\" - when I added linked weapons, I separated out the numbers of dice from the type so I could easily double the number and then link the two fields. I forgot to copy over the x10 for capital weapons.\nI labeled all named ranges so I don't get confused about numbers appearing on the bottom of tables. \"What's this for? Dunno, let's see what deleting it does. Oops. Broke the sheet.\""]
["v1.33","2017-08-22","added non-choices for those of us who are wishy-washy and can't stick with our decisions (-); fixed error where mounting an array in the last available slot allowed you to use the next mount as well (even if you don't have it or your ship can't support it)"]
["v1.32","2017-08-22","changed some formating on version history page; separated out to do to a separate tab; v in version is now lower case; removed the space between the v and the version number (spaces are hard); (real changes follow) added in tier 9 and 10 computer (CURSE YOU page breaks in the middle of tables!)"]
["V 1.31","2017-08-21","added a note to secondary core EXPLICITLY stating that a power core housing must be bought first; fixed an error where chain cannon was not showing up properly for light mount dropdowns"]
["V 1.3","8/20/2017 AM","arrays now take up two slots - must select (slot 2/2 on the second slot); added \"damaged systems\" to ship sheet; linking weapons now updates damage and consolidates weapons on the statblock and ship sheet; empty expansion bays are automatically converted to cargo bays on the statblock and ship sheet"]
["V 1.2","8/20/2017 PM","finished stat block sheet; reworked ship sheet that looks like the one in the book"]
["V 1.1","8/19/2017 PM","fixed expansion bays that took up multiple slots; started statblock sheet"]
["V 1.0","8/19/2017 AM","graduated to 1.0; prettified build sheet; added mount specific upgrades; adding linking weapons; added data valadation and individual dropdown lookups to limit selections to valid choice; published to net for sharing"]
["V 0.9","2017-08-18","reformated table sheet into separate themed sheets for ease of reading and updating; cleaned up and beautified lookup tables"]
["V 0.7","2017-08-17","removed scratch sheet; doing calculations on each table or on build/character sheet; output sheet complete"]
["V 0.3","2017-08-14","initial table input created; basic build sheet created"]
["V 0.1","2017-08-13","created sheet; initial outline and steps"]

{"sheet":"TO DO","index":24,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["TO DO"]
["Add functionality to turn certain systems on and off on the Ship Sheet to save on PCU. Some of us like to live dangerously."]
["Look into viewability on tablets and phones."]