{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["READ ME FIRST","BUILD","TURRETS","QUICKINFO","SOFTWARE","INFORMATION","BUILD TOTALS","BUILDDATA"],"not_rendered":{"macros":1,"defined_names":83},"read":"whole","date_system":"1900"}

{"sheet":"READ ME FIRST","index":0,"n_rows":33,"n_cols":3,"rows_kept":33,"merged":[[14,1,15,2]]}
[]
[null,"In order","CT.SD.W Version 1.0.2 8-22-20"]
[null,"READ ME FIRST","Quick map to get started."]
[]
[null,"(1) BUILD","The core worksheet. This is where you actually design your Adventure-class ship, from 100 to 5,000 tons."]
[]
[null,"(2) TURRETS","This is where you fill out the turrets and  weapons you bought on the BUILD worksheet."]
[]
[null,"(3a) QUICKINFO","This summarizes your ship design, allowing you a quick view to either select the cells you want to print and then fit them on paper or in a PDF if you print to PDF."]
[]
[null,"(3b) SOFTWARE","This is a quick reference for the software you bought on the BUILD worksheet."]
[]
[null,"NOTE","This workbook with its various worksheets was laid out at 1920 x 1080 resolution.  You'll have to fiddle with the worksheet magnification if you use a different size monitor."]
[]
[null,"There is a 5-page help guide that goes through each step of the design worksheet."]
[]
[null,"For feedback"]
[null,"Ronald Stepp"]
[null,"morituri.max@gmail.com"]
[]
[null,"Change Log"]
[null,"1.0.1 8-22-20","Fixed an error where Long Term Fuel Reserves from Step 8 were not being deducted from available tonnage."]
[null,null,"Also fixed some residual extra missiles and sand cannisters left on sheet."]
[null,null,"Fixed some cat feet debris in a couple \"empty\" fields."]
[null,"1.0.2 8-22-20","Fixed an error where only the first 25 of 50 turrets were seen."]
[null,"1.0.2jd 9-17-20","Eagle eyed facebook member Timothy Salisbury spotted that I was showing the Jump number as maneuver number in the PDF."]
[]
[]
[]
[]
[null,"Issues"]
[null,null,"Might need to fiddle with build time to take into account precedence of Standard vs Custom vs Jump/Maneuver/Plant build"]
[null,null,"times. Right now (1.0.1) build times seem to be slightly inconsistent."]

{"sheet":"BUILD","index":1,"n_rows":168,"n_cols":66,"rows_kept":168,"merged":[[1,2,2,5],[1,6,2,29],[1,31,2,31],[1,32,2,33],[3,2,3,29],[3,34,4,34],[3,35,4,35],[4,4,5,4],[5,5,11,5],[5,6,5,8],[5,9,5,11],[5,12,5,14],[5,15,5,17],[5,18,5,20],[5,21,5,23],[5,25,6,29],[6,2,7,2],[6,6,6,8],[6,9,6,11],[6,12,6,14],[6,15,6,17],[6,18,6,20],[6,21,6,23],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20],[7,21,7,23],[7,25,7,29],[7,32,9,32],[7,33,9,33],[8,6,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[8,18,8,20],[8,21,8,23],[8,25,8,29],[9,2,10,2],[9,6,9,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[9,21,9,23],[9,25,10,29],[10,6,10,8],[10,9,10,11],[10,12,10,14],[11,12,11,14],[11,21,11,23],[11,25,11,29],[11,31,11,32],[12,6,12,23],[12,25,12,29],[12,31,12,32],[13,2,13,29],[13,31,13,32],[13,34,14,34],[13,35,14,35],[18,5,18,29],[22,2,22,29],[22,34,23,34],[22,35,23,35],[24,2,24,4],[24,28,24,29],[26,28,26,29],[31,34,32,34],[31,35,32,35],[37,6,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[37,17,37,18],[37,19,37,20],[37,21,37,22],[37,23,37,24],[37,25,37,26],[38,6,38,26],[38,46,38,51],[38,53,38,58],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[39,17,39,18],[39,19,39,20],[39,21,39,23],[39,24,39,26],[40,6,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[40,15,40,16],[40,17,40,18],[40,19,40,20],[40,21,40,23],[40,24,40,26],[41,6,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[41,15,41,16],[41,17,41,18],[41,19,41,20],[41,21,41,23],[41,24,41,26],[42,6,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[42,15,42,16],[42,17,42,18],[42,19,42,20],[42,21,42,23],[42,24,42,26],[43,6,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[43,15,43,16],[43,17,43,18],[43,19,43,20],[43,21,43,23],[43,24,43,26],[44,6,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[44,15,44,16],[44,19,44,20],[44,21,44,23],[44,24,44,26],[45,6,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[45,15,45,16],[45,17,45,18],[45,19,45,20],[45,21,45,23],[45,24,45,26],[46,6,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[46,17,46,18],[46,19,46,20],[46,21,46,23],[46,24,46,26],[47,6,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[47,15,47,16],[47,17,47,18],[47,19,47,20],[47,21,47,23],[47,24,47,26],[48,6,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[48,15,48,16],[48,17,48,18],[48,21,48,23],[48,24,48,26],[49,6,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[49,17,49,18],[49,19,49,20],[49,21,49,23],[49,24,49,26],[50,6,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[50,17,50,18],[50,19,50,20],[50,21,50,23],[50,24,50,26],[51,6,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[51,17,51,18],[51,19,51,20],[51,21,51,23],[51,24,51,26],[52,6,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[52,17,52,18],[52,19,52,20],[52,21,52,23],[52,24,52,26],[53,6,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[53,15,53,16],[53,17,53,18],[53,19,53,20],[53,21,53,23],[53,24,53,26],[54,6,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[54,17,54,18],[54,21,54,23],[54,24,54,26],[55,6,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[55,17,55,18],[55,19,55,20],[55,21,55,23],[55,24,55,26],[56,6,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[56,17,56,18],[56,19,56,20],[56,21,56,23],[56,24,56,26],[56,31,56,32],[57,6,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[57,15,57,16],[57,17,57,18],[57,19,57,20],[57,21,57,23],[57,24,57,26],[58,6,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[58,15,58,16],[58,17,58,18],[58,19,58,20],[58,21,58,23],[58,24,58,26],[59,6,59,20],[62,34,63,34],[62,35,63,35],[65,15,65,17],[65,28,65,29],[66,15,66,17],[66,28,66,29],[67,28,67,29],[68,28,68,29],[69,28,69,29],[70,28,70,29],[71,28,71,29],[72,28,72,29],[73,28,73,29],[74,28,74,29],[75,28,75,29],[77,2,77,29],[77,34,78,34],[77,35,78,35],[80,28,80,29],[81,28,81,29],[82,28,82,29],[83,28,83,29],[84,14,84,16],[84,28,84,29],[85,28,85,29],[86,28,86,29],[87,28,87,29],[88,28,88,29],[89,28,89,29],[91,27,91,29],[92,27,92,29],[95,2,95,29],[95,34,96,34],[95,35,96,35],[96,18,96,21],[97,18,97,19],[97,20,97,21],[98,18,98,19],[98,20,98,21],[98,28,98,29],[99,18,99,19],[99,20,99,21],[99,28,99,29],[100,9,101,13],[100,18,100,19],[100,20,100,21],[100,28,100,29],[101,18,101,19],[101,20,101,21],[101,28,101,29],[102,10,102,12],[102,18,102,19],[102,20,102,21],[102,28,102,29],[103,10,103,12],[103,18,103,19],[103,20,103,21],[103,28,103,29],[104,10,104,12],[104,18,104,19],[104,20,104,21],[104,28,104,29],[105,10,105,12],[105,18,105,19],[105,20,105,21],[105,28,105,29],[106,10,106,12],[106,28,106,29],[107,28,107,29],[108,28,108,29],[109,28,109,29],[110,10,110,12],[110,18,110,19],[110,20,110,21],[110,28,110,29],[111,10,111,12],[111,18,111,19],[111,20,111,21],[111,28,111,29],[112,10,112,12],[112,18,112,19],[112,20,112,21],[112,28,112,29],[113,10,113,12],[113,18,113,19],[113,20,113,21],[113,28,113,29],[114,18,114,21],[114,28,114,29],[115,10,115,12],[115,14,115,16],[115,18,115,19],[115,28,115,29],[116,13,117,17],[116,28,116,29],[117,28,117,29],[118,28,118,29],[120,2,120,29],[120,34,121,34],[120,35,121,35],[123,26,123,29],[124,26,124,29],[125,26,125,29],[126,26,126,29],[127,26,127,29],[129,2,129,29],[129,34,130,34],[129,35,130,35],[131,26,131,30],[132,27,132,29],[133,26,133,30],[135,26,135,30],[136,27,136,29],[137,26,137,30],[138,2,138,8],[138,10,138,17],[138,19,138,29],[139,2,139,8],[139,10,139,11],[139,12,139,13],[139,14,139,15],[139,16,139,17],[139,19,139,23],[139,25,139,29],[140,6,140,8],[140,10,140,11],[140,12,140,13],[140,14,140,15],[140,16,140,17],[140,19,140,20],[140,21,140,24],[140,25,140,26],[140,27,140,30],[140,39,140,42],[140,46,140,49],[141,6,141,8],[141,10,141,11],[141,12,141,13],[141,14,141,15],[141,16,141,17],[141,19,141,20],[141,22,141,23],[141,25,141,26],[141,28,141,29],[141,31,144,34],[142,6,142,8],[142,10,142,11],[142,12,142,13],[142,14,142,15],[142,16,142,17],[142,19,142,20],[142,22,142,23],[142,25,142,26],[142,28,142,29],[143,6,143,8],[143,10,143,11],[143,12,143,13],[143,14,143,15],[143,16,143,17],[143,19,143,20],[143,22,143,23],[143,25,143,26],[143,28,143,29],[144,6,144,8],[144,10,144,11],[144,12,144,13],[144,14,144,15],[144,16,144,17],[144,19,144,20],[144,22,144,23],[144,25,144,26],[144,28,144,29],[145,6,145,8],[145,10,145,11],[145,12,145,13],[145,14,145,15],[145,16,145,17],[145,19,145,20],[145,22,145,23],[145,25,145,26],[145,28,145,29],[146,6,146,8],[146,10,146,11],[146,12,146,13],[146,14,146,15],[146,16,146,17],[146,19,146,20],[146,22,146,23],[146,25,146,26],[146,28,146,29],[147,6,147,8],[147,10,147,11],[147,12,147,13],[147,14,147,15],[147,16,147,17],[147,19,147,20],[147,22,147,23],[147,25,147,26],[147,28,147,29],[148,6,148,8],[148,10,148,11],[148,12,148,13],[148,14,148,15],[148,16,148,17],[148,19,148,20],[148,22,148,23],[148,25,148,26],[148,28,148,29],[149,6,149,8],[149,10,149,11],[149,12,149,13],[149,14,149,15],[149,16,149,17],[149,19,149,20],[149,22,149,23],[149,25,149,26],[149,28,149,29],[150,6,150,8],[150,10,150,11],[150,12,150,13],[150,14,150,15],[150,16,150,17],[150,19,150,20],[150,22,150,23],[150,25,150,26],[150,28,150,29],[151,6,151,8],[151,10,151,11],[151,12,151,13],[151,14,151,15],[151,16,151,17],[151,19,151,20],[151,22,151,23],[151,25,151,26],[151,28,151,29],[152,6,152,8],[152,10,152,11],[152,12,152,13],[152,14,152,15],[152,16,152,17],[152,19,152,20],[152,22,152,23],[152,25,152,26],[152,28,152,29],[153,6,153,8],[153,10,153,11],[153,12,153,13],[153,14,153,15],[153,16,153,17],[153,19,153,20],[153,22,153,23],[153,25,153,26],[153,28,153,29],[154,6,154,8],[154,10,154,11],[154,12,154,13],[154,14,154,15],[154,16,154,17],[154,19,154,20],[154,22,154,23],[154,25,154,26],[154,28,154,29],[155,6,155,8],[155,10,155,11],[155,12,155,13],[155,14,155,15],[155,16,155,17],[155,19,155,20],[155,22,155,23],[155,25,155,26],[155,28,155,29],[156,6,156,8],[156,10,156,11],[156,12,156,13],[156,14,156,15],[156,16,156,17],[156,19,156,20],[156,22,156,23],[156,25,156,26],[156,28,156,29],[157,6,157,8],[157,10,157,11],[157,12,157,13],[157,14,157,15],[157,16,157,17],[157,19,157,20],[157,22,157,23],[157,25,157,26],[157,28,157,29],[158,6,158,8],[158,10,158,11],[158,12,158,13],[158,14,158,15],[158,16,158,17],[158,19,158,20],[158,22,158,23],[158,25,158,26],[158,28,158,29],[159,6,159,8],[159,10,159,11],[159,12,159,13],[159,14,159,15],[159,16,159,17],[159,21,159,23],[159,27,159,29],[160,6,160,8],[160,21,160,24],[160,27,160,30],[165,34,166,34],[165,35,166,35],[167,2,167,29]]}
[]
[null,null,"Ship Descriptive Name",{"$nulls":3},"ENTER SHIP DESCRIPTIVE NAME",{"$nulls":24},"Type","TYPE CODE",null,null,"CT.SD.W",null,"8wk"]
[{"$nulls":35},"V1.0.2jd 9-17-20",null,"YES"]
[null,null,"STEP 1. Select Hull Size",{"$nulls":31},"Tons Remaining","Total Cost",null,"4wk"]
[{"$nulls":4},"Standard Hull Sizes",{"$nulls":26},"Tons","MCr","Build Time",{"$nulls":3},"NO"]
[null,null,"Tonnage",null,null,"RESET\nTO\nZERO",{"$f":"BUILDDATA!AK5","v":5},null,null,{"$f":"BUILDDATA!AK11","v":35},null,null,{"$f":"BUILDDATA!AK17","v":65},null,null,{"$f":"BUILDDATA!AK24","v":"( 100 )"},null,null,{"$f":"BUILDDATA!AK29","v":600},null,null,{"$f":"BUILDDATA!AK33","v":"( 1000 )"},{"$nulls":3},"Standard Design",{"$nulls":5},{"$f":"BUILDDATA!E38","v":{"v":1100,"d":"1,100.000"}},{"$f":"IF(AL12=\"YES\",VLOOKUP(shipTonnage,HULLTABLE,2,1),0.1*shipTonnage)","v":{"v":110,"d":"110.000"}},{"$f":"IF(AL12=\"YES\",VLOOKUP(shipTonnage,HULLTABLE,3,1),E16)","v":32},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}}]
[null,null,{"$f":"BUILDDATA!E38","v":{"v":1100,"d":"1,100.000"}},null,{"v":100,"d":"100 "},null,{"$f":"BUILDDATA!AK6","v":10},null,null,{"$f":"BUILDDATA!AK12","v":40},null,null,{"$f":"BUILDDATA!AK18","v":70},null,null,{"$f":"BUILDDATA!AK25","v":200},null,null,{"$f":"BUILDDATA!AK30","v":700},null,null,{"$f":"BUILDDATA!AK34","v":2000}]
[{"$nulls":4},{"v":200,"d":"200 "},null,{"$f":"BUILDDATA!AK7","v":15},null,null,{"$f":"BUILDDATA!AK13","v":45},null,null,{"$f":"BUILDDATA!AK19","v":75},null,null,{"$f":"BUILDDATA!AK26","v":300},null,null,{"$f":"BUILDDATA!AK31","v":800},null,null,{"$f":"BUILDDATA!AK35","v":3000},{"$nulls":3},{"$f":"AL8","v":"NO"},{"$nulls":5},"8 weeks","Click to switch plans",{"$nulls":4},"NO"]
[null,null,"Cost (MCr)",null,{"v":400,"d":"400 "},null,{"$f":"BUILDDATA!AK8","v":20},null,null,{"$f":"BUILDDATA!AK14","v":50},null,null,{"$f":"BUILDDATA!AK20","v":80},null,null,{"$f":"BUILDDATA!AK27","v":400},null,null,{"$f":"BUILDDATA!AK32","v":900},null,null,{"$f":"BUILDDATA!AK36","v":4000},{"$nulls":3},"click to toggle",{"$nulls":5},"Plans"]
[null,null,{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}},null,{"v":600,"d":"600 "},null,{"$f":"BUILDDATA!AK9","v":25},null,null,{"$f":"BUILDDATA!AK15","v":55},null,null,{"$f":"BUILDDATA!AK21","v":85},null,null,{"$f":"BUILDDATA!AK28","v":500},{"$nulls":5},{"$f":"BUILDDATA!AK37","v":5000},{"$nulls":3},"STANDARD HULL SIZE",{"$nulls":5},"4 weeks"]
[{"$nulls":4},{"v":800,"d":"800 "},null,{"$f":"BUILDDATA!AK10","v":30},null,null,{"$f":"BUILDDATA!AK16","v":60},null,null,{"$f":"BUILDDATA!AK22","v":90}]
[{"$nulls":4},{"v":1000,"d":"1,000 "},{"$nulls":7},{"$f":"BUILDDATA!AK23","v":95},{"$nulls":12},{"$f":"AL12","v":"NO"},{"$nulls":5},{"v":0.1,"d":"10%"},{"$nulls":5},{"$f":"IF(OR(shipTonnage=100,shipTonnage=200,shipTonnage=400,shipTonnage=600,shipTonnage=800,shipTonnage=1000),\"YES\",\"NO\")","v":"NO"}]
[{"$nulls":6},"click to select hull tonnages, values are cumulative",{"$nulls":24},"Discount 10% to 40%"]
[null,null,"STEP 2. Select Drives.",{"$nulls":28},"for Standard Hull Sizes",null,null,"Tons Remaining","Total Cost",null,"Selected"]
[{"$nulls":4},"Build Time",null,"A","B","C","D","E","F","G","H","J","K","L","M","N","P","Q","R","S","T","U","V","W","X","Y","Z",null,"Tons","MCr",{"$nulls":4},"index (0-25)","Letter"]
[null,null,"Jump",1,{"$f":"BUILDDATA!AD38","v":32},"NONE",{"$f":"_xlfn.IFNA(BUILDDATA!F38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!G38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!H38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!I38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!J38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!K38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!L38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!M38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!N38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!O38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!P38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!Q38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!R38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!S38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!T38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!U38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!V38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!W38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!X38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!Y38,0)","v":2},{"$f":"_xlfn.IFNA(BUILDDATA!Z38,0)","v":2},{"$f":"_xlfn.IFNA(BUILDDATA!AA38,0)","v":3},{"$f":"_xlfn.IFNA(BUILDDATA!AB38,0)","v":4},{"$f":"_xlfn.IFNA(BUILDDATA!AC38,0)","v":6},null,{"$f":"_xlfn.IFNA(VLOOKUP(AM16,JMPTABLE,2,1),0)","v":{"v":50,"d":"50.000"}},{"$f":"_xlfn.IFNA(VLOOKUP(AM16,JMPTABLE,3,1),0)","v":{"v":90,"d":"90.000"}},null,{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}},null,9,"J"]
[null,null,"Maneuver",1,{"$f":"BUILDDATA!AD38","v":32},"NONE",{"$f":"_xlfn.IFNA(BUILDDATA!F38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!G38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!H38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!I38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!J38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!K38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!L38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!M38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!N38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!O38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!P38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!Q38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!R38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!S38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!T38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!U38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!V38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!W38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!X38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!Y38,0)","v":2},{"$f":"_xlfn.IFNA(BUILDDATA!Z38,0)","v":2},{"$f":"_xlfn.IFNA(BUILDDATA!AA38,0)","v":3},{"$f":"_xlfn.IFNA(BUILDDATA!AB38,0)","v":4},{"$f":"_xlfn.IFNA(BUILDDATA!AC38,0)","v":6},null,{"$f":"_xlfn.IFNA(VLOOKUP(AM17,JMPTABLE,4,1),0)","v":{"v":17,"d":"17.000"}},{"$f":"_xlfn.IFNA(VLOOKUP(AM17,JMPTABLE,5,1),0)","v":{"v":36,"d":"36.000"}},{"$nulls":4},9,"J"]
[null,null,"Power",1,{"$f":"BUILDDATA!AD38","v":32},"NONE",{"$f":"_xlfn.IFNA(BUILDDATA!F38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!G38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!H38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!I38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!J38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!K38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!L38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!M38,0)","v":0},{"$f":"_xlfn.IFNA(BUILDDATA!N38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!O38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!P38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!Q38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!R38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!S38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!T38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!U38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!V38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!W38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!X38,0)","v":1},{"$f":"_xlfn.IFNA(BUILDDATA!Y38,0)","v":2},{"$f":"_xlfn.IFNA(BUILDDATA!Z38,0)","v":2},{"$f":"_xlfn.IFNA(BUILDDATA!AA38,0)","v":3},{"$f":"_xlfn.IFNA(BUILDDATA!AB38,0)","v":4},{"$f":"_xlfn.IFNA(BUILDDATA!AC38,0)","v":6},null,{"$f":"_xlfn.IFNA(VLOOKUP(AM18,JMPTABLE,6,1),0)","v":{"v":28,"d":"28.000"}},{"$f":"_xlfn.IFNA(VLOOKUP(AM18,JMPTABLE,7,1),0)","v":{"v":72,"d":"72.000"}},{"$nulls":4},9,"J"]
[{"$nulls":5},"click to toggle select drives"]
[]
[]
[]
[null,null,"STEP 3. Fuel Tankage.",{"$nulls":31},"Tons Remaining","Total Cost"]
[{"$nulls":31},"Tons",null,"Total Weeks"]
[null,null,"Any yellowish field allows data entry",{"$nulls":23},"Power Plant and Maneuver (Number of Weeks x 4)",null,0,null,null,{"$f":"10*D18*AC25","v":{"v":0,"d":"0.000"}},null,{"$f":"AC25*4","v":0},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}}]
[{"$nulls":33},"Total Jumps"]
[{"$nulls":26},{"$f":"\"Number of Jump-\"& D16 &\" jumps\"","v":"Number of Jump-1 jumps"},null,0,null,null,{"$f":"0.1*AF6*D16*AC27","v":{"v":0,"d":"0.000"}},null,{"$f":"AC27","v":0}]
[]
[]
[]
[]
[null,null,"STEP 4. Bridge.",{"$nulls":31},"Tons Remaining","Total Cost"]
[{"$nulls":31},"Tons","MCr"]
[{"$nulls":34},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}}]
[{"$nulls":26},"Standard Bridge",{"$nulls":4},{"$f":"IF(shipTonnage>0,IF(0.02*AF6<20,20,0.02*AF6),0)","v":{"v":22,"d":"22.000"}},{"$f":"0.5*(AF6/100)","v":{"v":5.5,"d":"5.500"}}]
[]
[null,null,"STEP 5. Computer",{"$nulls":23},"Computer Model",{"$nulls":10},"Selected",0,1,2,3,4,5,6,7,8,9]
[{"$nulls":6},"NONE",null,null,1,null,"1bis",null,2,null,"2bis",null,3,null,4,null,5,null,6,null,7,{"$nulls":5},{"$f":"_xlfn.IFNA(VLOOKUP(AL38,COMPTABLE,2,0),0)","v":{"v":1,"d":"1.000"}},{"$f":"_xlfn.IFNA(VLOOKUP(AL38,COMPTABLE,3,0),0)","v":{"v":2,"d":"2.000"}},{"$nulls":4},1,"NONE",1,"1bis",2,"2bis",3,4,5,6,7]
[{"$nulls":6},"click to select desired computer model",{"$nulls":39},"Space",{"$nulls":6},"Cost"]
[{"$nulls":21},"Space",null,null,"MCr",{"$nulls":7},"Capacity",{"$f":"_xlfn.IFNA(VLOOKUP(AL38,COMPTABLE,4,0)&\" / \"&VLOOKUP(AL38,COMPTABLE,5,0),\"\")","v":"2 / 4"},{"$nulls":3},"NONE",1,2,3,4,5,6,null,"SUM",1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6]
[{"$nulls":4},"Predict","1 to 5","NONE",null,null,1,null,2,null,3,null,4,null,5,{"$nulls":3},{"$f":"SUM(AU41:AZ41)","v":0},null,null,{"$f":"SUM(BB41:BG41)","v":{"v":0,"d":"0.000"}},{"$nulls":7},"Tech Level",{"$f":"_xlfn.IFNA(VLOOKUP(AL38,COMPTABLE,6,0),\"\")","v":5},{"$nulls":3},"NONE",0,0,0,0,0,0,null,{"$f":"SUM(AM41:AQ41)","v":0},{"$f":"IF(AM41>0,1,0)","v":0},{"$f":"IF(AN41>0,2,0)","v":0},{"$f":"IF(AO41>0,1,0)","v":0},{"$f":"IF(AP41>0,3,0)","v":0},{"$f":"IF(AQ41>0,2,0)","v":0},null,null,{"$f":"IF(AM41>0,2,0)","v":0},{"$f":"IF(AN41>0,4,0)","v":0},{"$f":"IF(AO41>0,6,0)","v":0},{"$f":"IF(AP41>0,8,0)","v":0},{"$f":"IF(AQ41>0,10,0)","v":0},null,"Predict 1-5",{"$f":"IF(AM41>0,\"X\",\"\")","v":""},{"$f":"IF(AN41>0,\"X\",\"\")","v":""},"","",""]
[{"$nulls":4},"Gunner Interact",null,"NONE",null,null,1,{"$nulls":11},{"$f":"SUM(AU42:AZ42)","v":0},null,null,{"$f":"SUM(BB42:BG42)","v":{"v":0,"d":"0.000"}},{"$nulls":7},"Software Credit (MCr)",{"$f":"_xlfn.IFNA(VLOOKUP(AL38,COMPTABLE,7,0),0)","v":{"v":1,"d":"1.000"}},{"$nulls":3},"NONE",0,0,0,0,0,0,null,{"$f":"SUM(AM42:AQ42)","v":0},{"$f":"IF(AM42>0,1,0)","v":0},{"$nulls":6},{"$f":"IF(AM42>0,1,0)","v":0},{"$nulls":5},"Gunner Interact 1",{"$f":"IF(AM42>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Target",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM43>0,1,0)","v":0},{"$nulls":6},{"$f":"IF(AM43>0,1,0)","v":0},{"$nulls":5},"Target 1",{"$f":"IF(AM43>0,\"X\",\"\")","v":""}]
[null,null,"Offensive",null,"Selective","1 to 3","NONE",null,null,1,null,2,null,3,{"$nulls":7},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM44>0,1,0)","v":0},{"$f":"IF(AN44>0,2,0)","v":0},{"$f":"IF(AO44>0,1,0)","v":0},{"$nulls":4},{"$f":"IF(AM44>0,0.5,0)","v":0},{"$f":"IF(AN44>0,0.8,0)","v":0},{"$f":"IF(AO44>0,1,0)","v":0},{"$nulls":3},"Selective 3",{"$f":"IF(AM44>0,\"X\",\"\")","v":""},{"$f":"IF(AN44>0,\"X\",\"\")","v":""},{"$f":"IF(AO44>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Multi-target","2 to 4","NONE",{"$nulls":4},2,null,3,null,4,{"$nulls":5},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,null,{"$f":"IF(AN45>0,1,0)","v":0},{"$f":"IF(AO45>0,2,0)","v":0},{"$f":"IF(AP45>0,4,0)","v":0},{"$nulls":4},{"$f":"IF(AN45>0,1,0)","v":0},{"$f":"IF(AO45>0,2,0)","v":0},{"$f":"IF(AP45>0,3,0)","v":0},null,null,"Multi-target 2-4",null,"","",{"$f":"IF(AP45>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Launch",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM46>0,1,0)","v":0},{"$nulls":6},{"$f":"IF(AM46>0,2,0)","v":0},{"$nulls":5},"Launch 1",{"$f":"IF(AM46>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Double Fire",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM47>0,4,0)","v":0},{"$nulls":6},{"$f":"IF(AM47>0,4,0)","v":0},{"$nulls":5},"Double Fire 1",{"$f":"IF(AM47>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Maneuver/Evade","1 to 6","NONE",null,null,1,null,2,null,3,null,4,null,5,null,6,null,0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM48>0,1,0)","v":0},{"$f":"IF(AN48>0,2,0)","v":0},{"$f":"IF(AO48>0,3,0)","v":0},{"$f":"IF(AP48>0,4,0)","v":0},{"$f":"IF(AQ48>0,2,0)","v":0},{"$f":"IF(AR48>0,3,0)","v":0},null,{"$f":"IF(AM48>0,1,0)","v":0},{"$f":"IF(AN48>0,2,0)","v":0},{"$f":"IF(AO48>0,3,0)","v":0},{"$f":"IF(AP48>0,4,0)","v":0},{"$f":"IF(AQ48>0,5,0)","v":0},{"$f":"IF(AR48>0,6,0)","v":0},"Maneuver/Evade 1-6",{"$f":"IF(AM48>0,\"X\",\"\")","v":""},"","","","",""]
[{"$nulls":4},"Auto/Evade",null,"NONE",null,null,1,{"$nulls":11},{"$f":"SUM(AU49:AZ49)","v":0},null,null,{"$f":"SUM(BB49:BG49)","v":{"v":0,"d":"0.000"}},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM49>0,1,0)","v":0},{"$nulls":6},{"$f":"IF(AM49>0,0.5,0)","v":0},{"$nulls":5},"Auto/Evade 1",{"$f":"IF(AM49>0,\"X\",\"\")","v":""}]
[null,null,"Defensive",null,"Return Fire",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM50>0,1,0)","v":0},{"$nulls":6},{"$f":"IF(AM50>0,0.5,0)","v":0},{"$nulls":5},"Return Fire 1",{"$f":"IF(AM50>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Anti-Missile",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM51>0,2,0)","v":0},{"$nulls":6},{"$f":"IF(AM51>0,1,0)","v":0},{"$nulls":5},"Anti-Missile 1",{"$f":"IF(AM51>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"ECM",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM52>0,3,0)","v":0},{"$nulls":6},{"$f":"IF(AM52>0,4,0)","v":0},{"$nulls":5},"ECM 1",{"$f":"IF(AM52>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Maneuver",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,{"$f":"IF(AM53>0,1,0)","v":0},{"$nulls":6},{"$f":"IF(AM53>0,0.1,0)","v":0},{"$nulls":5},"Maneuver 1",{"$f":"IF(AM53>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Jump","1 to 6","NONE",null,null,1,null,2,null,3,null,4,null,5,null,6,null,0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,0,{"$f":"IF(AN54>0,2,0)","v":0},{"$f":"IF(AO54>0,3,0)","v":0},{"$f":"IF(AP54>0,4,0)","v":0},{"$f":"IF(AQ54>0,5,0)","v":0},{"$f":"IF(AR54>0,6,0)","v":0},null,{"$f":"IF(AM54>0,0.1,0)","v":0},{"$f":"IF(AN54>0,0.33,0)","v":0},{"$f":"IF(AO54>0,0.4,0)","v":0},{"$f":"IF(AP54>0,0.5,0)","v":0},{"$f":"IF(AQ54>0,0.6,0)","v":0},{"$f":"IF(AR54>0,0.7,0)","v":0},"Jump 1-6",{"$f":"IF(AM54>0,\"X\",\"\")","v":""},{"$f":"IF(AN54>0,\"X\",\"\")","v":""},{"$f":"IF(AO54>0,\"X\",\"\")","v":""},{"$f":"IF(AP54>0,\"X\",\"\")","v":""},{"$f":"IF(AQ54>0,\"X\",\"\")","v":""},{"$f":"IF(AR54>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Navigation",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,0,{"$nulls":6},{"$f":"IF(AM55>0,0.4,0)","v":0},{"$nulls":5},"Navigation 1",{"$f":"IF(AM55>0,\"X\",\"\")","v":""}]
[null,null,"Routine",null,"Differentiate","1 to 3","NONE",null,null,1,null,2,null,3,{"$nulls":7},0,null,null,{"v":0,"d":"0.000"},{"$nulls":12},"NONE",0,0,0,0,0,0,null,0,0,{"$f":"IF(AN56>0,2,0)","v":0},{"$f":"IF(AO56>0,3,0)","v":0},{"$nulls":4},{"$f":"IF(AM56>0,0.5,0)","v":0},{"$f":"IF(AN56>0,0.6,0)","v":0},{"$f":"IF(AO56>0,0.7,0)","v":0},{"$nulls":3},"Differentiate 1-3",{"$f":"IF(AM56>0,\"X\",\"\")","v":""},{"$f":"IF(AN56>0,\"X\",\"\")","v":""},{"$f":"IF(AO56>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Generate",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":6},"Required CPU Space",{"$nulls":5},"NONE",0,0,0,0,0,0,null,0,0,{"$nulls":6},{"$f":"IF(AM57>0,0.8,0)","v":0},{"$nulls":5},"Generate 1",{"$f":"IF(AM57>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Anti-Hijack",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":6},"Space","MCr",{"$nulls":4},"NONE",0,0,0,0,0,0,null,0,0,{"$nulls":6},{"$f":"IF(AM58>0,0.1,0)","v":0},{"$nulls":5},"Anti-Hijack 1",{"$f":"IF(AM58>0,\"X\",\"\")","v":""}]
[{"$nulls":4},"Library",null,"NONE",null,null,1,{"$nulls":11},0,null,null,{"v":0,"d":"0.000"},{"$nulls":6},{"$f":"SUM(V41:X59)","v":0},{"$f":"IF(AL62<0,0,AL62)","v":{"v":0,"d":"0.000"}},{"$nulls":4},"NONE",0,0,0,0,0,0,null,0,0,{"$nulls":6},{"$f":"IF(AM59>0,0.3,0)","v":0},{"$nulls":5},"Library 1",{"$f":"IF(AM59>0,\"X\",\"\")","v":""}]
[{"$nulls":6},"click to select desired software packages"]
[{"$nulls":37},"Total after bonus"]
[{"$nulls":37},{"$f":"SUM(Y41:AA59)-AH42","v":{"v":-1,"d":"-1.000"}}]
[null,null,"STEP 6. Accommodations.",{"$nulls":31},"Tons Remaining","Total Cost"]
[{"$nulls":31},"Tons","MCr"]
[{"$nulls":17},"STEP 11 allows accurate tracking of numbers of staterooms, low berths",{"$nulls":16},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}}]
[{"$nulls":13},"Recommended Staterooms",null,{"$f":"AL161","v":0},{"$nulls":10},"Stateroom",null,0,null,null,{"$f":"AC66*4","v":{"v":0,"d":"0.000"}},{"$f":"0.5*AC66","v":{"v":0,"d":"0.000"}}]
[{"$nulls":13},"Recommended Low Berths",null,{"$f":"AL163","v":0},{"$nulls":10},"Low Berth",null,0,null,null,{"$f":"AC67*0.5","v":{"v":0,"d":"0.000"}},{"$f":"0.05*AC67","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},"An Emergency Low Berth can accommodate four sophonts with no frills.",{"$nulls":8},"Emergency Low Berth",null,0,null,null,{"$f":"AC68*1","v":{"v":0,"d":"0.000"}},{"$f":"0.1*AC68","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Small Craft Stateroom",null,0,null,null,{"$f":"AC69*2","v":{"v":0,"d":"0.000"}},{"$f":"0.05*AC69","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Small Craft Couch",null,0,null,null,{"$f":"AC70*0.5","v":{"v":0,"d":"0.000"}},{"$f":"0.025*AC70","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Morse Hyper/13",null,0,null,null,{"$f":"4*AC71","v":{"v":0,"d":"0.000"}},{"$f":"16*AC71","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Morse Hyper/14",null,0,null,null,{"$f":"4*AC72","v":{"v":0,"d":"0.000"}},{"$f":"1.5*16*AC72","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Morse Hyper/15",null,0,null,null,{"$f":"4*AC73","v":{"v":0,"d":"0.000"}},{"$f":"2*16*AC73","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Morse Hyper/13 (core)",null,0,null,null,{"$f":"1*AC74","v":{"v":0,"d":"0.000"}},{"$f":"1.5*AC74","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Morse Hyper/14 (core)",null,0,null,null,{"$f":"1*AC75","v":{"v":0,"d":"0.000"}},{"$f":"1.5*1.5*AC75","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Morse Hyper/15 (core)",null,0,null,null,{"$f":"1*AC76","v":{"v":0,"d":"0.000"}},{"$f":"2*1.5*AC76","v":{"v":0,"d":"0.000"}}]
[]
[null,null,"STEP 7. Armament.",{"$nulls":31},"Tons Remaining","Total Cost"]
[{"$nulls":31},"Tons","MCr"]
[{"$nulls":4},"See TURRETS worksheet for weapon layout.",{"$nulls":29},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}}]
[{"$nulls":26},"Maximum Hardpoints",null,{"$f":"AF6/100","v":11}]
[{"$nulls":26},"Installed Hardpoints",null,0,{"$nulls":3},{"$f":"0.1*AC82","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Fire Control",null,0,null,null,{"$f":"1*AC83","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"}]
[{"$nulls":16},"Total Weapons to fill Turrets",{"$nulls":9},"Single Turret",null,0,{"$nulls":3},{"$f":"0.2*AC84","v":{"v":0,"d":"0.000"}}]
[{"$nulls":14},{"$f":"sinTurret+(duoTurret*2)+(triTurret*3)","v":0},{"$nulls":11},"Double Turret",null,0,{"$nulls":3},{"$f":"0.5*AC85","v":{"v":0,"d":"0.000"}}]
[{"$nulls":26},"Triple Turret",null,0,{"$nulls":3},{"$f":"1*AC86","v":{"v":0,"d":"0.000"}}]
[{"$nulls":16},"0.50 MCr each",{"$nulls":9},"Pulse Laser",null,0,{"$nulls":3},{"$f":"0.5*AC87","v":{"v":0,"d":"0.000"}}]
[{"$nulls":16},"1.00 MCr each",{"$nulls":9},"Beam Laser",null,0,{"$nulls":3},{"$f":"1*AC88","v":{"v":0,"d":"0.000"}}]
[{"$nulls":16},"0.75 MCr each",{"$nulls":9},"Missile Rack",null,0,{"$nulls":3},{"$f":"0.75*AC89","v":{"v":0,"d":"0.000"}}]
[{"$nulls":16},"0.25 MCr each",{"$nulls":9},"Sandcaster",null,0,{"$nulls":3},{"$f":"0.25*AC90","v":{"v":0,"d":"0.000"}}]
[]
[{"$nulls":16},"0.005 MCr each",{"$nulls":8},"Extra Missiles",null,0,{"$nulls":3},{"$f":"0.05*AB92","v":{"v":0,"d":"0.000"}},{"$f":"0.005*AB92","v":{"v":0,"d":"0.000"}}]
[{"$nulls":16},"0.0004 MCr each",{"$nulls":8},"Extra Sand Cannisters",null,0,{"$nulls":3},{"$f":"0.05*AB93","v":{"v":0,"d":"0.000"}},{"$f":"0.0004*AB93","v":{"v":0,"d":"0.000"}}]
[]
[]
[null,null,"STEP 8. Vehicles.",{"$nulls":31},"Tons Remaining","Total Cost"]
[{"$nulls":5},"Tonnage of Cutter is 20 tons without modules",{"$nulls":12},"Dedicated",{"$nulls":12},"Tons","MCr","Fuel (tons)",{"$nulls":4},"Max"]
[{"$nulls":5},"Fuel module masses 30 tons",{"$nulls":12},"Crew",null,"Min",{"$nulls":13},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}},null,null,{"$f":"COUNTIF(AM99:AM114,\"V\")","v":0}]
[{"$nulls":5},"ATV module masses 30 tons",{"$nulls":10},"V",null,0,null,{"$f":"AC99","v":0},{"$nulls":5},"ATV",null,0,null,null,{"$f":"10*AC99","v":{"v":0,"d":"0.000"}},{"$f":"0.03*AC99","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"IF(AC99>0,\"V\",\"\")","v":""},{"$f":"IF(AND(AM99=\"V\",AM99<>\"\"),COUNTIF(AM99,\"V\"),\"\")","v":""},{"$f":"IF(AND(maxvslots>1,AN99=$AM$98),\" and \",\"\")","v":""},{"$f":"IF(AC99=1,\" an \"& AA99,IF(AC99>1,VLOOKUP(AC99,oneHundred,2,1)&\" \"& AA99 & \"s\",\"\"))","v":""},{"$f":"IF(AN99<$AM$98,\", \",IF(AN99=$AM$98,\".\",\"\"))","v":""}]
[{"$nulls":5},"Open module masses 30 tons",{"$nulls":10},"V",null,0,null,{"$f":"AC100","v":0},{"$nulls":5},"Air/Raft",null,0,null,null,{"$f":"4*AC100","v":{"v":0,"d":"0.000"}},{"$f":"0.6*AC100","v":{"v":0,"d":"0.000"}},null,null,"grand total reserve tons",null,{"$f":"IF(SUM(AC101:AD106)+SUM(AC111:AD119)=0,\"and a\",\"\")","v":"and a"},{"$f":"IF(AC100>0,\"V\",\"\")","v":""},{"$f":"IF(AND(AM100=\"V\",AM100<>\"\"),COUNTIF($AM$99:AM100,\"V\"),\"\")","v":""},"",{"$f":"IF(AC100=1,\" an \"& AA100,IF(AC100>1,VLOOKUP(AC100,oneHundred,2,1)&\" \"& AA100 & \"s\",\"\"))","v":""},{"$f":"IF(AN100<$AM$98,\", \",IF(AN100=$AM$98,\".\",\"\"))","v":""}]
[{"$nulls":4},"Standard Cutters include 0 modules",{"$nulls":4},"Extra weeks\nof fuel",{"$nulls":6},"V",null,0,null,{"$f":"AC101","v":0},{"$nulls":5},"Speeder",null,0,null,null,{"$f":"6*AC101","v":{"v":0,"d":"0.000"}},{"$f":"1*AC101","v":{"v":0,"d":"0.000"}},null,null,{"$f":"SUM(AJ103:AJ114)+(O116*K116)","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM101=\"V\",AM101<>\"\"),COUNTIF($AM$99:AM101,\"V\"),\"\")","v":""},"",{"$f":"IF(AC101=1,\" a \"& AA101,IF(AC101>1,VLOOKUP(AC101,oneHundred,2,1)&\" \"& AA101 & \"s\",\"\"))","v":""},""]
[{"$nulls":4},"ATV Module includes an ATV",{"$nulls":11},"V",null,0,null,{"$f":"AC102","v":0},{"$nulls":5},"GCarrier",null,0,null,null,{"$f":"8*AC102","v":{"v":0,"d":"0.000"}},{"$f":"1*AC102","v":{"v":0,"d":"0.000"}},"per 4 weeks",null,"individual fuel reserve tons",null,null,"",{"$f":"IF(AND(AM102=\"V\",AM102<>\"\"),COUNTIF($AM$99:AM102,\"V\"),\"\")","v":""},"",{"$f":"IF(AC102=1,\" a \"& AA102,IF(AC102>1,VLOOKUP(AC102,oneHundred,2,1)&\" \"& AA102 & \"s\",\"\"))","v":""},""]
[{"$nulls":8},"Launch",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC103","v":0},{"$nulls":5},"Launch",null,0,null,null,{"$f":"(20*AC103)+((K103/4)*AH103)","v":{"v":0,"d":"0.000"}},{"$f":"14*AC103","v":{"v":0,"d":"0.000"}},{"v":1,"d":"1.00"},null,{"$f":"(K103/4)*AH103","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM103=\"V\",AM103<>\"\"),COUNTIF($AM$99:AM103,\"V\"),\"\")","v":""},"",{"$f":"IF(AC103=1,\" a 20-ton \"& AA103,IF(AC103>1,VLOOKUP(AC103,oneHundred,2,1)&\" 20-ton \"& AA103 & \"es\",\"\"))","v":""},""]
[{"$nulls":4},"V=Vehicle",{"$nulls":3},"Ship's Boat",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC104","v":0},{"$nulls":5},"Ship's Boat",null,0,null,null,{"$f":"(30*AC104)+((K104/4)*AH104)","v":{"v":0,"d":"0.000"}},{"$f":"16*AC104","v":{"v":0,"d":"0.000"}},{"v":1.8,"d":"1.80"},null,{"$f":"(K104/4)*AH104","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM104=\"V\",AM104<>\"\"),COUNTIF($AM$99:AM104,\"V\"),\"\")","v":""},"",{"$f":"IF(AC104=1,\" a 30-ton \"& AA104,IF(AC104>1,VLOOKUP(AC104,oneHundred,2,1)&\" 30-ton \"& AA104 & \"s\",\"\"))","v":""},""]
[{"$nulls":4},"SC=Small Craft",{"$nulls":3},"Pinnace",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC105","v":0},{"$nulls":5},"Pinnace",null,0,null,null,{"$f":"(40*AC105)+((K105/4)*AH105)","v":{"v":0,"d":"0.000"}},{"$f":"20*AC105","v":{"v":0,"d":"0.000"}},{"v":2,"d":"2.00"},null,{"$f":"(K105/4)*AH105","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM105=\"V\",AM105<>\"\"),COUNTIF($AM$99:AM105,\"V\"),\"\")","v":""},"",{"$f":"IF(AC105=1,\" a 40-ton \"& AA105,IF(AC105>1,VLOOKUP(AC105,oneHundred,2,1)&\" 40-ton \"& AA105 & \"s\",\"\"))","v":""},""]
[{"$nulls":8},"Cutter",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC106","v":0},{"$nulls":5},"Cutter",null,0,null,null,{"$f":"(20*AC106)+((K106/4)*AH106)","v":{"v":0,"d":"0.000"}},{"$f":"28*AC106","v":{"v":0,"d":"0.000"}},{"v":2,"d":"2.00"},null,{"$f":"(K106/4)*AH106","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM106=\"V\",AM106<>\"\"),COUNTIF($AM$99:AM106,\"V\"),\"\")","v":""},"",{"$f":"IF(AC106=1,\" a 50-ton \"& AA106,IF(AC106>1,VLOOKUP(AC106,oneHundred,2,1)&\" 50-ton \"& AA106 & \"s\",\"\"))","v":""},""]
[{"$nulls":8},"Fuel Module",null,0,{"$nulls":15},"Fuel Module",null,0,null,null,{"$f":"(30*AC107)+((K107/4)*AH107)","v":{"v":0,"d":"0.000"}},{"$f":"1*AC107","v":{"v":0,"d":"0.000"}},{"v":30,"d":"30.00"},null,{"$f":"(K107/4)*AH107","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(AC107>0,\"V\",\"\")","v":""},{"$f":"IF(AND(AM107=\"V\",AM107<>\"\"),COUNTIF($AM$99:AM107,\"V\"),\"\")","v":""},"",{"$f":"IF(AC107=1,\" a \"& AA107,IF(AC107>1,VLOOKUP(AC107,oneHundred,2,1)&\" \"& AA107 & \"s\",\"\"))","v":""},{"$f":"IF(AN107<$AM$98,\", \",IF(AN107=$AM$98,\".\",\"\"))","v":""}]
[{"$nulls":26},"ATV Module",null,0,null,null,{"$f":"30*AC108","v":{"v":0,"d":"0.000"}},{"$f":"1.8*AC108","v":{"v":0,"d":"0.000"}},{"$nulls":5},"",{"$f":"IF(AND(AM108=\"V\",AM108<>\"\"),COUNTIF($AM$99:AM108,\"V\"),\"\")","v":""},"",{"$f":"IF(AC108=1,\" an \"& AA108,IF(AC108>1,VLOOKUP(AC108,oneHundred,2,1)&\" \"& AA108 & \"s\",\"\"))","v":""},""]
[{"$nulls":26},"Open Module",null,0,null,null,{"$f":"30*AC109","v":{"v":0,"d":"0.000"}},{"$f":"2*AC109","v":{"v":0,"d":"0.000"}},{"$nulls":5},"",{"$f":"IF(AND(AM109=\"V\",AM109<>\"\"),COUNTIF($AM$99:AM109,\"V\"),\"\")","v":""},"",{"$f":"IF(AC109=1,\" an \"& AA109,IF(AC109>1,VLOOKUP(AC109,oneHundred,2,1)&\" \"& AA109 & \"s\",\"\"))","v":""},""]
[{"$nulls":16},"0 cost, placeholder item",{"$nulls":9},"Provision for future modules",null,0,null,null,{"$f":"30*AC110","v":{"v":0,"d":"0.000"}},{"$f":"0","v":{"v":0,"d":"0.000"}},"per 4 weeks",null,"individual fuel reserve tons"]
[{"$nulls":8},"Slow Boat",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC111","v":0},{"$nulls":5},"Slow Boat",null,0,null,null,{"$f":"(30*AC111)+((K111/4)*AH111)","v":{"v":0,"d":"0.000"}},{"$f":"15*AC111","v":{"v":0,"d":"0.000"}},{"v":1,"d":"1.00"},null,{"$f":"(K111/4)*AH111","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(AC111>0,\"V\",\"\")","v":""},{"$f":"IF(AND(AM111=\"V\",AM111<>\"\"),COUNTIF($AM$99:AM111,\"V\"),\"\")","v":""},"",{"$f":"IF(AC111=1,\" a 30-ton \"& AA111,IF(AC111>1,VLOOKUP(AC111,oneHundred,2,1)&\" 30-ton \"& AA111 & \"s\",\"\"))","v":""},{"$f":"IF(AN111<$AM$98,\", \",IF(AN111=$AM$98,\".\",\"\"))","v":""}]
[{"$nulls":8},"Slow Pinnace",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC112","v":0},{"$nulls":5},"Slow Pinnace",null,0,null,null,{"$f":"(40*AC112)+((K112/4)*AH112)","v":{"v":0,"d":"0.000"}},{"$f":"18*AC112","v":{"v":0,"d":"0.000"}},{"v":1,"d":"1.00"},null,{"$f":"(K112/4)*AH112","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM112=\"V\",AM112<>\"\"),COUNTIF($AM$99:AM112,\"V\"),\"\")","v":""},"",{"$f":"IF(AC112=1,\" a 40-ton \"& AA112,IF(AC112>1,VLOOKUP(AC112,oneHundred,2,1)&\" 40-ton \"& AA112 & \"s\",\"\"))","v":""},""]
[{"$nulls":8},"Shuttle",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"2*AC113","v":0},{"$nulls":5},"Shuttle",null,0,null,null,{"$f":"(95*AC113)+((K113/4)*AH113)","v":{"v":0,"d":"0.000"}},{"$f":"33*AC113","v":{"v":0,"d":"0.000"}},2.85,null,{"$f":"(K113/4)*AH113","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM113=\"V\",AM113<>\"\"),COUNTIF($AM$99:AM113,\"V\"),\"\")","v":""},"",{"$f":"IF(AC113=1,\" a 95-ton \"& AA113,IF(AC113>1,VLOOKUP(AC113,oneHundred,2,1)&\" 95-ton \"& AA113 & \"s\",\"\"))","v":""},""]
[{"$nulls":8},"Fighter",null,0,{"$nulls":5},"SC",null,0,null,{"$f":"1*AC114","v":0},{"$nulls":5},"Fighter",null,0,null,null,{"$f":"(10*AC114)+((K114/4)*AH114)","v":{"v":0,"d":"0.000"}},{"$f":"18*AC114","v":{"v":0,"d":"0.000"}},{"v":1,"d":"1.00"},null,{"$f":"(K114/4)*AH114","v":{"v":0,"d":"0.00"}},null,null,"",{"$f":"IF(AND(AM114=\"V\",AM114<>\"\"),COUNTIF($AM$99:AM114,\"V\"),\"\")","v":""},"",{"$f":"IF(AC114=1,\" a 10-ton \"& AA114,IF(AC114>1,VLOOKUP(AC114,oneHundred,2,1)&\" 10-ton \"& AA114 & \"s\",\"\"))","v":""},""]
[{"$nulls":18},"Dedicated",{"$nulls":14},"can change the",null,"long term fuel reserve"]
[{"$nulls":8},"Long Term Fuel Reserves",null,0,{"$nulls":3},0,{"$nulls":3},"Crew",{"$nulls":14},"values above",null,{"$f":"K116*O116","v":{"v":0,"d":"0.00"}}]
[{"$nulls":13},"Weekly use (tons)",{"$nulls":19},"if desired"]
[]
[]
[{"$nulls":41},{"$f":"_xlfn.CONCAT(AO99,AP99,AQ99,AO100,AP100,AQ100,AO101,AP101,AQ101,AO102,AP102,AQ102,AO103,AP103,AQ103,AO104,AP104,AQ104,AO105,AP105,AQ105,AO106,AP106,AQ106,AO107,AP107,AQ107,AO108,AP108,AQ108,AO109,AP109,AQ109,AO111,AP111,AQ111,AO112,AP112,AQ112,AO113,AP113,AQ113,AO114,AP114,AQ114)","v":""}]
[null,null,"STEP 9. Cargo Capacity.",{"$nulls":31},"Tons Remaining","Total Cost"]
[{"$nulls":31},"Tons",{"$nulls":6},"Cargo Bays"]
[{"$nulls":34},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}},null,null,{"$f":"COUNTIF(AA124:AD128,\">0\")","v":0}]
[{"$nulls":24},"Cargo Bay 1",null,{"v":0,"d":"0.000"},{"$nulls":4},{"$f":"AA124","v":{"v":0,"d":"0.000"}},{"$nulls":6},{"$f":"IF(AA124>0,\"BAY\",\"\")","v":""},{"$f":"IF(AND(AM124=\"BAY\",AM124<>\"\"),COUNTIF(AM124,\"BAY\"),\"\")","v":""},{"$f":"IF(AND(cargobays>1,AN124=$AM$123),\" and \",\"\")","v":""},{"$f":"IF(AA124>0,\" a \" & IF(cargobays=1,\" single \",\"\") & AA124 & \"-ton bay\",\"\")","v":""},{"$f":"IF(AN124<$AM$123,\", \",IF(AN124=$AM$123,\".\",\"\"))","v":""}]
[{"$nulls":24},"Cargo Bay 2",null,{"v":0,"d":"0.000"},{"$nulls":4},{"$f":"AA125","v":{"v":0,"d":"0.000"}},{"$nulls":6},{"$f":"IF(AA125>0,\"BAY\",\"\")","v":""},{"$f":"IF(AND(AM125=\"BAY\",AM125<>\"\"),COUNTIF($AM$124:AM125,\"BAY\"),\"\")","v":""},{"$f":"IF(AND(cargobays>1,AN125=$AM$123),\" and \",\"\")","v":""},{"$f":"IF(AA125>0,\" a \" & IF(cargobays=1,\" single \",\"\") & AA125 & \"-ton bay\",\"\")","v":""},{"$f":"IF(AN125<$AM$123,\", \",IF(AN125=$AM$123,\".\",\"\"))","v":""}]
[{"$nulls":24},"Cargo Bay 3",null,{"v":0,"d":"0.000"},{"$nulls":4},{"$f":"AA126","v":{"v":0,"d":"0.000"}},{"$nulls":6},"",{"$f":"IF(AND(AM126=\"BAY\",AM126<>\"\"),COUNTIF($AM$124:AM126,\"BAY\"),\"\")","v":""},{"$f":"IF(AND(cargobays>1,AN126=$AM$123),\" and \",\"\")","v":""},{"$f":"IF(AA126>0,\" a \" & IF(cargobays=1,\" single \",\"\") & AA126 & \"-ton bay\",\"\")","v":""},""]
[{"$nulls":24},"Cargo Bay 4",null,{"v":0,"d":"0.000"},{"$nulls":4},{"$f":"AA127","v":{"v":0,"d":"0.000"}},{"$nulls":6},"",{"$f":"IF(AND(AM127=\"BAY\",AM127<>\"\"),COUNTIF($AM$124:AM127,\"BAY\"),\"\")","v":""},{"$f":"IF(AND(cargobays>1,AN127=$AM$123),\" and \",\"\")","v":""},{"$f":"IF(AA127>0,\" a \" & IF(cargobays=1,\" single \",\"\") & AA127 & \"-ton bay\",\"\")","v":""},""]
[{"$nulls":24},"Cargo Bay 5",null,{"v":0,"d":"0.000"},{"$nulls":4},{"$f":"AA128","v":{"v":0,"d":"0.000"}},{"$nulls":6},"",{"$f":"IF(AND(AM128=\"BAY\",AM128<>\"\"),COUNTIF($AM$124:AM128,\"BAY\"),\"\")","v":""},{"$f":"IF(AND(cargobays>1,AN128=$AM$123),\" and \",\"\")","v":""},{"$f":"IF(AA128>0,\" a \" & IF(cargobays=1,\" single \",\"\") & AA128 & \"-ton bay\",\"\")","v":""},""]
[]
[null,null,"STEP 10. Streamlining",{"$nulls":31},"Tons Remaining","Total Cost",{"$nulls":5},{"$f":"_xlfn.CONCAT(AO124,AP124,AQ124,AO125,AP125,AQ125,AO126,AP126,AQ126,AO127,AP127,AQ127,AO128,AP128,AQ128)","v":""}]
[{"$nulls":32},"MCr",{"$nulls":4},"streamlined"]
[{"$nulls":26},"streamlining",{"$nulls":7},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}},null,"NO"]
[{"$nulls":27},{"$f":"streaming","v":"NO"},{"$nulls":4},{"$f":"IF(AL132=\"YES\",INT(0.5+(AF6/100)),0)","v":{"v":0,"d":"0.000"}},{"$nulls":4},"exclude luxury"]
[{"$nulls":26},"click to toggle",{"$nulls":10},"NO"]
[{"$nulls":37},"total turrets"]
[{"$nulls":26},"Exclude Luxury",{"$nulls":10},{"$f":"SUM(AC84:AD86)","v":0}]
[{"$nulls":25},"Exclude Luxury Staterooms from Double Occupancy",null,{"$f":"luxury","v":"NO"},{"$nulls":9},"total drives"]
[{"$nulls":26},"click to toggle",{"$nulls":10},{"$f":"SUM(AF16:AF18)","v":{"v":95,"d":"95.000"}}]
[null,null,{"$f":"\"ship's tonnage is \" & TEXT(shipTonnage,\"#,####\") & \" tons.\"","v":"ship's tonnage is 1,100 tons."},{"$nulls":7},"Occupancy",{"$nulls":8},"Worksheet for Step 6",{"$nulls":17},"total crew","Crew",{"$nulls":6},"Crew"]
[null,null,"STEP 11. Crew.",{"$nulls":7},"x1",null,"x0.5",null,"x2",null,"x1",null,null,"Staterooms",{"$nulls":5},"Low Berths",{"$nulls":5},{"$f":"\"Crew = \" & SUM(E142:E154)","v":"Crew = 0"},{"$nulls":5},{"$f":"SUM(E142:E153)","v":0},"Sections",{"$nulls":5},"Difference","Can be added"]
[{"$nulls":4},"Filled","Min","Add",{"$nulls":3},"S",null,"D",null,"LUX",null,"LOW",null,null,"Need",null,"Installed",{"$nulls":3},"Need",null,"Installed",{"$nulls":9},"additional crew",{"$f":"COUNTIF(E142:E154,\">0\")","v":0},"Actual required present crew",{"$nulls":5},{"$f":"COUNTIF(AS142:AS154,\">0\")","v":9},"Crew that can be added later to max out positions"]
[null,null,"Captain","L",0,{"$f":"IF(shipTonnage>=1000,1,0)","v":{"v":1,"d":"1.0"}},{"$nulls":13},{"$f":"IF(K142>0,K142,0)+IF(M142>0,M142/2,0)+IF(O142>0,2*O142,0)","v":{"v":0,"d":"0.0"}},null,null,0,null,null,{"$f":"IF(Q142>0,Q142,0)","v":0},null,null,0,null,null,"Unallocated Staterooms was added to correctly calculate double occupancy of passengers if any are taken on at some point.",{"$nulls":5},{"$f":"SUM(AS142:AS153)","v":22},{"$f":"IF(E142>0,\"CREW\",\"\")","v":""},{"$f":"IF(AND(AM142=\"CREW\",AM142<>\"\"),COUNTIF(AM142,\"CREW\"),\"\")","v":""},{"$f":"IF(AND(totalFSections>1,AN142=$AM$141),\" and \",\"\")","v":""},{"$f":"IF(E142>0,IF(E142=1,C142,IF(E142>1,VLOOKUP(E142,oneHundred,2,1) & \" \"  & C142 & \"s\",\"\")),\"\")","v":""},{"$f":"IF(AN142<totalFSections,\", \",IF(AN142=totalFSections,\".\",\"\"))","v":""},null,{"$f":"INT(F142)-E142","v":1},{"$f":"IF(AS142>0,\"CREW\",\"\")","v":"CREW"},{"$f":"IF(AND(AT142=\"CREW\",AT142<>\"\"),COUNTIF(AT142,\"CREW\"),\"\")","v":1},{"$f":"IF(AND(AT141>1,AU142=$AT$141),\" and \",\"\")","v":""},{"$f":"IF(AS142>0,IF(AS142=1,C142,IF(AS142>1,VLOOKUP(AS142,oneHundred,2,1) & \" \"  & C142 & \"s\",\"\")),\"\")","v":"Captain"},{"$f":"IF(AU142<$AT$141,\", \",IF(AU142=$AT$141,\".\",\"\"))","v":", "},{"$nulls":3},{"$f":"IF(K142>0,\"Single=\"&K142,\"\")","v":""},{"$f":"IF(M142>0,\"Double=\"&M142,\"\")","v":""},{"$f":"IF(O142>0,\"Luxury=\"&O142,\"\")","v":""},{"$f":"IF(Q142>0,\"Low=\"&Q142,\"\")","v":""},{"$f":"SUBSTITUTE(TRIM(BB142&\" \"&BC142&\" \"&BD142&\" \"&BE142),\" \",\", \")","v":""},{"$f":"IFERROR(SUBSTITUTE(BF142,\",\",\" and\",LEN(BF142)-LEN(SUBSTITUTE(BF142,\",\",\"\"))),BF142)","v":""}]
[null,"or","Commanding Officer","L",0,{"$f":"IF(shipTonnage>=1000,1,0)","v":{"v":1,"d":"1.0"}},{"$nulls":13},{"$f":"IF(K143>0,K143,0)+IF(M143>0,M143/2,0)+IF(O143>0,2*O143,0)","v":{"v":0,"d":"0.0"}},null,null,0,null,null,{"$f":"IF(Q143>0,Q143,0)","v":0},null,null,0,{"$nulls":8},"total small craft",{"$f":"IF(E143>0,\"CREW\",\"\")","v":""},{"$f":"IF(AND(AM143=\"CREW\",AM143<>\"\"),COUNTIF($AM$142:AM143,\"CREW\"),\"\")","v":""},"","","",null,{"$f":"INT(F143)-E143","v":1},{"$f":"IF(AS143>0,\"CREW\",\"\")","v":"CREW"},{"$f":"IF(AND(AT143=\"CREW\",AT143<>\"\"),COUNTIF($AT$142:AT143,\"CREW\"),\"\")","v":2},{"$f":"IF(AND(AT142>1,AU143=$AT$141),\" and \",\"\")","v":""},"Commanding Officer",{"$f":"IF(AU143<$AT$141,\", \",IF(AU143=$AT$141,\".\",\"\"))","v":", "},{"$nulls":3},{"$f":"IF(K143>0,\"Single=\"&K143,\"\")","v":""},{"$f":"IF(M143>0,\"Double=\"&M143,\"\")","v":""},{"$f":"IF(O143>0,\"Luxury=\"&O143,\"\")","v":""},{"$f":"IF(Q143>0,\"Low=\"&Q143,\"\")","v":""},{"$f":"SUBSTITUTE(TRIM(BB143&\" \"&BC143&\" \"&BD143&\" \"&BE143),\" \",\", \")","v":""},{"$f":"IFERROR(SUBSTITUTE(BF143,\",\",\" and\",LEN(BF143)-LEN(SUBSTITUTE(BF143,\",\",\"\"))),BF143)","v":""}]
[null,null,"Executive Officer","L",0,{"$f":"IF(shipTonnage>=1000,1,0)","v":{"v":1,"d":"1.0"}},{"$nulls":13},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,{"$nulls":8},{"$f":"SUM(AC99:AD106)+SUM(AC111:AD114)","v":0},"",{"$f":"IF(AND(AM144=\"CREW\",AM144<>\"\"),COUNTIF($AM$142:AM144,\"CREW\"),\"\")","v":""},"","","",null,1,"CREW",{"$f":"IF(AND(AT144=\"CREW\",AT144<>\"\"),COUNTIF($AT$142:AT144,\"CREW\"),\"\")","v":3},"","Executive Officer",", ",{"$nulls":3},"","","","","",""]
[null,null,"Admin Rating","L",0,{"$f":"IF(shipTonnage>=1000,3,0)","v":{"v":3,"d":"3.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,{"$nulls":8},"total high passengers","",{"$f":"IF(AND(AM145=\"CREW\",AM145<>\"\"),COUNTIF($AM$142:AM145,\"CREW\"),\"\")","v":""},"","","",null,3,"CREW",{"$f":"IF(AND(AT145=\"CREW\",AT145<>\"\"),COUNTIF($AT$142:AT145,\"CREW\"),\"\")","v":4},"","three Admin Ratings",", ",{"$nulls":3},"","","","","",""]
[null,null,"Crew Rating","L",0,{"$f":"IF(shipTonnage>=1000,(shipTonnage/1000)*10,0)","v":{"v":11,"d":"11.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"Filled = active crew positions on the ship.",{"$nulls":5},{"$f":"SUM(E156:E158)","v":0},"",{"$f":"IF(AND(AM146=\"CREW\",AM146<>\"\"),COUNTIF($AM$142:AM146,\"CREW\"),\"\")","v":""},"","","",null,11,"CREW",{"$f":"IF(AND(AT146=\"CREW\",AT146<>\"\"),COUNTIF($AT$142:AT146,\"CREW\"),\"\")","v":5},"","eleven Crew Ratings",", ",{"$nulls":3},"","","","","",""]
[null,null,"Pilot","S",0,{"v":1,"d":"1.0"},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"Min = recommended crew positions by ship size or",{"$nulls":5},"total low passengers","",{"$f":"IF(AND(AM147=\"CREW\",AM147<>\"\"),COUNTIF($AM$142:AM147,\"CREW\"),\"\")","v":""},"","","",null,1,"CREW",{"$f":"IF(AND(AT147=\"CREW\",AT147<>\"\"),COUNTIF($AT$142:AT147,\"CREW\"),\"\")","v":6},"","Pilot",", ",{"$nulls":3},"","","","","",""]
[null,null,"Navigator","S",0,{"$f":"IF(shipTonnage>=200, 1,\"na\")","v":{"v":1,"d":"1.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"system.",{"$nulls":5},{"$f":"E159","v":0},"",{"$f":"IF(AND(AM148=\"CREW\",AM148<>\"\"),COUNTIF($AM$142:AM148,\"CREW\"),\"\")","v":""},"","","",null,1,"CREW",{"$f":"IF(AND(AT148=\"CREW\",AT148<>\"\"),COUNTIF($AT$142:AT148,\"CREW\"),\"\")","v":7},"","Navigator",", ",{"$nulls":3},"","","","","",""]
[null,null,"Engineer","S",0,{"$f":"IF(shipTonnage>=200,(AL138/35),\"na\")","v":{"v":2.7142857142857144,"d":"2.7"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"Add = note to designer for possible additional crew.",{"$nulls":5},"all passengers","",{"$f":"IF(AND(AM149=\"CREW\",AM149<>\"\"),COUNTIF($AM$142:AM149,\"CREW\"),\"\")","v":""},"","","",null,2,"CREW",{"$f":"IF(AND(AT149=\"CREW\",AT149<>\"\"),COUNTIF($AT$142:AT149,\"CREW\"),\"\")","v":8},"","two Engineers",", ",{"$nulls":3},"","","","","",""]
[null,null,"Steward","S",0,{"$f":"IF((AL146/8)>0,(AL146/8),0)","v":{"v":0,"d":"0.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"S,D,LUX,LOW = number and size of staterooms needed",{"$nulls":5},{"$f":"SUM(E156:E159)","v":0},"",{"$f":"IF(AND(AM150=\"CREW\",AM150<>\"\"),COUNTIF($AM$142:AM150,\"CREW\"),\"\")","v":""},"","","",null,0,"",{"$f":"IF(AND(AT150=\"CREW\",AT150<>\"\"),COUNTIF($AT$142:AT150,\"CREW\"),\"\")","v":""},"","","",{"$nulls":3},"","","","","",""]
[null,null,"Medic","S",0,{"$f":"IF(shipTonnage>=200,1,0)+(AL150/120)","v":{"v":1,"d":"1.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"for that crew position.",{"$nulls":5},"total vehicles","",{"$f":"IF(AND(AM151=\"CREW\",AM151<>\"\"),COUNTIF($AM$142:AM151,\"CREW\"),\"\")","v":""},"","","",null,1,"CREW",{"$f":"IF(AND(AT151=\"CREW\",AT151<>\"\"),COUNTIF($AT$142:AT151,\"CREW\"),\"\")","v":9}," and ","Medic",".",{"$nulls":3},"","","","","",""]
[null,null,"Gunner","S",0,{"$f":"IF(AL136>0,AL136,0)","v":{"v":0,"d":"0.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"Installed = Actual Staterooms or Low Berths needed.",{"$nulls":5},{"$f":"SUM(AC99:AD106)+SUM(AC111:AD119)","v":0},"",{"$f":"IF(AND(AM152=\"CREW\",AM152<>\"\"),COUNTIF($AM$142:AM152,\"CREW\"),\"\")","v":""},"","","",null,0,"",{"$f":"IF(AND(AT152=\"CREW\",AT152<>\"\"),COUNTIF($AT$142:AT152,\"CREW\"),\"\")","v":""},"","","",{"$nulls":3},"","","","","",""]
[null,null,"Troop","L",0,{"v":0,"d":"0.0"},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"Step 6 is where they are actually purchased for the ship.",{"$nulls":5},"total cargo","",{"$f":"IF(AND(AM153=\"CREW\",AM153<>\"\"),COUNTIF($AM$142:AM153,\"CREW\"),\"\")","v":""},"","","",null,0,"",{"$f":"IF(AND(AT153=\"CREW\",AT153<>\"\"),COUNTIF($AT$142:AT153,\"CREW\"),\"\")","v":""},"","","",{"$nulls":3},"","","","","",""]
[null,null,"Dedicated V/SC Pilot","S",{"$f":"SUM(S99:T106,S111:T114)","v":0},{"$f":"SUM(U99:V114)","v":{"v":0,"d":"0.0"}},0,{"$nulls":12},{"v":0,"d":"0.0"},null,null,0,null,null,0,null,null,0,null,null,"This line's blue FILLED/MIN values are taken from STEP 8.",{"$nulls":5},{"$f":"SUM(AA124:AD128)","v":{"v":0,"d":"0.000"}},{"$f":"IF(E154>0,\"CREW\",\"\")","v":""},{"$f":"IF(AND(AM154=\"CREW\",AM154<>\"\"),COUNTIF($AM$142:AM154,\"CREW\"),\"\")","v":""},"","","",null,{"$f":"INT(F154)-E154","v":0},"",{"$f":"IF(AND(AT154=\"CREW\",AT154<>\"\"),COUNTIF($AT$142:AT154,\"CREW\"),\"\")","v":""},{"$f":"IF(AND(AT153>1,AU154=$AT$141),\" and \",\"\")","v":""},"",{"$f":"IF(AU154<$AT$141,\", \",IF(AU154=$AT$141,\".\",\"\"))","v":""},{"$nulls":3},"","","","","",""]
[null,null,"Unallocated Staterooms","P",0,null,0,{"$nulls":12},{"$f":"IF(K155>0,K155,0)+IF(M155>0,M155/2,0)+IF(O155>0,2*O155,0)","v":{"v":0,"d":"0.0"}},null,null,0,null,null,0,null,null,0,{"$nulls":24},{"$f":"IF(K155>0,\"Single=\"&K155,\"\")","v":""},{"$f":"IF(M155>0,\"Double=\"&M155,\"\")","v":""},{"$f":"IF(O155>0,\"Luxury=\"&O155,\"\")","v":""},{"$f":"IF(Q155>0,\"Low=\"&Q155,\"\")","v":""},{"$f":"SUBSTITUTE(TRIM(BB155&\" \"&BC155&\" \"&BD155&\" \"&BE155),\" \",\", \")","v":""},{"$f":"IFERROR(SUBSTITUTE(BF155,\",\",\" and\",LEN(BF155)-LEN(SUBSTITUTE(BF155,\",\",\"\"))),BF155)","v":""}]
[null,null,"Luxury High or Middle","P",0,{"$nulls":14},{"$f":"IF(K156>0,K156,0)+IF(M156>0,M156/2,0)+IF(O156>0,2*O156,0)","v":{"v":0,"d":"0.0"}},null,null,0,null,null,{"$f":"IF(Q156=\"Y\",E156,\"\")","v":""},{"$nulls":5},"NOTE: Filling in all the fields will allow the worksheet",{"$nulls":5},"large ship crew",{"$nulls":15},{"$f":"IF(K156>0,\"Single=\"&K156,\"\")","v":""},{"$f":"IF(M156>0,\"Double=\"&M156,\"\")","v":""},{"$f":"IF(O156>0,\"Luxury=\"&O156,\"\")","v":""},{"$f":"IF(Q156>0,\"Low=\"&Q156,\"\")","v":""},{"$f":"SUBSTITUTE(TRIM(BB156&\" \"&BC156&\" \"&BD156&\" \"&BE156),\" \",\", \")","v":""},{"$f":"IFERROR(SUBSTITUTE(BF156,\",\",\" and\",LEN(BF156)-LEN(SUBSTITUTE(BF156,\",\",\"\"))),BF156)","v":""}]
[null,null,"Standard High or Middle","P",0,{"$nulls":14},{"v":0,"d":"0.0"},null,null,0,null,null,"",{"$nulls":5},"to accurately figure out passenger double occupancy.",{"$nulls":5},{"$f":"SUM(E142:E146)+E153","v":0},{"$nulls":15},"","","","","",""]
[null,null,"Economy High or Middle","P",0,{"$nulls":14},{"v":0,"d":"0.0"},null,null,0,null,null,"",{"$nulls":11},"small crew",{"$nulls":15},"","","","","",""]
[null,null,"Low Passengers","P",0,{"$nulls":20},{"$f":"IF(Q159>0,Q159,0)","v":0},null,null,0,{"$nulls":8},{"$f":"SUM(E147:E152)","v":0},{"$nulls":15},"","","","","",""]
[null,null,"Total High/Medium Passengers at Normal Occupancy",{"$nulls":3},{"$f":"SUM(E156:E158)","v":0},{"$nulls":14},{"$f":"SUM(W142:X158)","v":0},{"$nulls":5},{"$f":"SUM(AC142:AD159)","v":0},{"$nulls":9},"reccom. staterooms"]
[null,null,"Total High/Medium Passengers at Double Occupancy",{"$nulls":3},{"$f":"((V160-IF(luxury=\"YES\",W156,0))*2)-SUM(K142:N154)","v":0},{"$nulls":14},"Total",{"$nulls":5},"Total",{"$nulls":9},{"$f":"V160","v":0}]
[{"$nulls":30},"L=Large Ship Crew, S=Small Ship Crew, P=Passengers",{"$nulls":6},"reccom. low berths"]
[null,null,"Occupancy: S=Single, D=Double, LUX=Luxury (Two Staterooms), Low=Low Berth",{"$nulls":34},{"$f":"AB160","v":0}]
[]
[null,null,"For engineers, stewards, medics, and gunners, the highest skilled is chief of section and paid 10% more."]
[null,null,"One person may fill two positions, but each is performed at their skill level - 1. Salary equals 75% of both positions combined.",{"$nulls":31},"Tons Remaining","Total Cost"]
[]
[null,null,"E N D   O F   D E S I G N   A R E A",{"$nulls":31},{"$f":"remainingTons","v":{"v":982,"d":"982.000"}},{"$f":"IF(standard=\"YES\",standardCost,totalCost)","v":{"v":318.655,"d":"318.6550"}}]

{"sheet":"TURRETS","index":2,"n_rows":56,"n_cols":62,"rows_kept":56,"merged":[[2,1,2,20],[3,23,4,29],[4,3,4,5],[24,1,25,4],[27,1,28,4]]}
[{"$nulls":33},"S",1,{"$f":"D7","v":0},{"$nulls":4},"Total Turrets"]
[{"$nulls":33},"D",2,{"$f":"E7","v":0},{"$nulls":4},{"$f":"SUM(AO7:AO56)","v":0},null,"S","single"]
[null,"TURRET LAYOUT SHEET",{"$nulls":31},"T",3,{"$f":"F7","v":0},{"$nulls":4},"Unique Groups",null,"D","double",null,null,"Total Cost"]
[null,"Ship Tons",{"$f":"shipTonnage","v":{"v":1100,"d":"1,100"}},{"$nulls":4},"M=Mod A, B, or C for Missiles or Sandcasters",{"$nulls":15},"Used for the checks",{"$nulls":6},"num","num","turret","turret",{"$nulls":6},{"$f":"COUNTIF(AO7:AO56,\">0\")","v":0},null,"T","triple",null,null,{"$f":"SUM(AU7:AU56)","v":{"v":0,"d":"0.00"}}]
[null,"Hardpoints",{"$f":"hardpointsOn","v":0},"Turrets (T)",{"$nulls":3},"Mod B or C only available for Missiles or Sandcasters",{"$nulls":22},"ck","ck","ck","ck"]
[{"$nulls":3},"Single","Double","Triple",null,"HP","T","PL","BL","MR","SC","M","HP","T","PL","BL","MR","SC","M",null,null,"HP","T","PL","BL","MR","SC","sum","over","under","over","under",{"$nulls":3},"HP","Comp","Unique","Amt","Type","P","B","M","S","Cost (MCr)",{"$nulls":4},"PL","BL","MR","SC"]
[{"$nulls":3},{"$f":"sinTurret","v":0},{"$f":"duoTurret","v":0},{"$f":"triTurret","v":0},null,1,{"$nulls":6},26,{"$nulls":8},1,{"$f":"I7","v":0},{"$f":"J7","v":0},{"$f":"K7","v":0},{"$f":"L7","v":0},{"$f":"M7","v":0},{"$f":"SUM(Z7:AC7)","v":0},{"$f":"IFERROR(IF(AD7>VLOOKUP(Y7,checktsum,2,0),\"F\"&Y7,\"G\"),\"G\")","v":"G"},{"$f":"IFERROR(IF(AD7<VLOOKUP(Y7,checktsum,2,0),\"F\"&Y7,\"G\"),\"G\")","v":"G"},{"$nulls":3},{"$f":"\"I7\"","v":"I7"},null,1,{"$f":"IF(I7=\"\",\"x\",I7) & IF(J7=\"\",\"xx\",\"P\"&J7) & IF(K7=\"\",\"xx\",\"B\"&K7) & IF(L7=\"\",\"xx\",\"M\"&L7) & IF(M7=\"\",\"xx\",\"S\"&M7)","v":"xxxxxxxxx"},{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN6, turretList), 0)),\"\")","v":"xxxxxxxxx"},{"$f":"IF(LEFT(AN7,1)<>\"x\",COUNTIF(turretList,AN7),0)","v":0},{"$f":"IF(AO7>0,LEFT(AN7,1),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN7,3,1)),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN7,5,1)),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN7,7,1)),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN7,9,1)),\"\")","v":""},{"$f":"IF(AO7>0,IFERROR((AQ7*0.5*AO7),0)+IFERROR((AR7*1*AO7),0)+IFERROR((AS7*0.75*AO7),0)+IFERROR((AT7*0.25*AO7),0),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(AO7>0,VLOOKUP(AO7,oneHundred,2,1)&\" \",\"\")","v":""},{"$f":"IF(AO7>0,VLOOKUP(AP7,SDTurret,2,0)&\" \",\"\")","v":""},{"$f":"IF(AO7>0,\"turret\" & IF(AO7>1,\"s \",\" \"),\"\")","v":""},{"$f":"IF(AO7>0,\"with a \",\"\")","v":""},{"$f":"IF(AND(AQ7<>\"\",AQ7>0),\"PLx\"&AQ7,\"\")","v":""},{"$f":"IF(AND(AR7<>\"\",AR7>0),\"BLx\"&AR7,\"\")","v":""},{"$f":"IF(AND(AS7<>\"\",AS7>0),\"MRx\"&AS7,\"\")","v":""},{"$f":"IF(AND(AT7<>\"\",AT7>0),\"SCx\"&AT7,\"\")","v":""},{"$f":"SUBSTITUTE(TRIM(AZ7&\" \"&BA7&\" \"&BB7&\" \"&BC7),\" \",\", \")","v":""},{"$f":"IF(AO7>0,\".\",\"\")","v":""},{"$nulls":3},{"$f":"_xlfn.CONCAT(AV7,AW7,AX7,AY7,BD7,BE7)","v":""},{"$f":"IFERROR(SUBSTITUTE(BI7,\",\",\" and a\",LEN(BI7)-LEN(SUBSTITUTE(BI7,\",\",\"\"))),BI7)","v":""}]
[null,null,"Purchased",{"$nulls":4},2,{"$nulls":6},27,{"$nulls":8},2,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I8\"","v":"I8"},null,{"$f":"AL7+1","v":2},{"$f":"IF(I8=\"\",\"x\",I8) & IF(J8=\"\",\"xx\",\"P\"&J8) & IF(K8=\"\",\"xx\",\"B\"&K8) & IF(L8=\"\",\"xx\",\"M\"&L8) & IF(M8=\"\",\"xx\",\"S\"&M8)","v":"xxxxxxxxx"},{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN7, turretList), 0)),\"\")","v":""},0,{"$f":"IF(AO8>0,LEFT(AN8,1),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN8,3,1)),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN8,5,1)),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN8,7,1)),\"\")","v":""},{"$f":"IFERROR(VALUE(MID(AN8,9,1)),\"\")","v":""},{"$f":"IF(AO8>0,IFERROR((AQ8*0.5*AO8),0)+IFERROR((AR8*1*AO8),0)+IFERROR((AS8*0.75*AO8),0)+IFERROR((AT8*0.25*AO8),0),0)","v":{"v":0,"d":"0.00"}},"","",{"$f":"IF(AO8>0,\"turret\" & IF(AO8>1,\"s \",\" \"),\"\")","v":""},{"$f":"IF(AO8>0,\"with a \",\"\")","v":""},{"$f":"IF(AND(AQ8<>\"\",AQ8>0),\"PLx\"&AQ8,\"\")","v":""},{"$f":"IF(AND(AR8<>\"\",AR8>0),\"BLx\"&AR8,\"\")","v":""},{"$f":"IF(AND(AS8<>\"\",AS8>0),\"MRx\"&AS8,\"\")","v":""},{"$f":"IF(AND(AT8<>\"\",AT8>0),\"SCx\"&AT8,\"\")","v":""},{"$f":"SUBSTITUTE(TRIM(AZ8&\" \"&BA8&\" \"&BB8&\" \"&BC8),\" \",\", \")","v":""},{"$f":"IF(AO8>0,\".\",\"\")","v":""},{"$nulls":3},{"$f":"_xlfn.CONCAT(AV8,AW8,AX8,AY8,BD8,BE8)","v":""},{"$f":"IFERROR(SUBSTITUTE(BI8,\",\",\" and a\",LEN(BI8)-LEN(SUBSTITUTE(BI8,\",\",\"\"))),BI8)","v":""}]
[null,null,"Pulse Laser (PL)",{"$f":"BUILD!AC87","v":0},{"$nulls":3},3,{"$nulls":6},28,{"$nulls":8},3,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I9\"","v":"I9"},null,3,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN8, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Beam Laser (BL)",{"$f":"BUILD!AC88","v":0},{"$nulls":3},4,{"$nulls":6},29,{"$nulls":8},4,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I10\"","v":"I10"},null,4,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN9, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Missile Rack (Ms)",{"$f":"BUILD!AC89","v":0},{"$nulls":3},5,{"$nulls":6},30,{"$nulls":8},5,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I11\"","v":"I11"},null,5,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN10, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Sandcaster (Sc)",{"$f":"BUILD!AC90","v":0},{"$nulls":3},6,{"$nulls":6},31,{"$nulls":8},6,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I12\"","v":"I12"},null,6,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN11, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},7,{"$nulls":6},32,{"$nulls":8},7,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I13\"","v":"I13"},null,7,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN12, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Checks","Short","Over",null,null,8,{"$nulls":6},33,{"$nulls":8},8,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I14\"","v":"I14"},null,8,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN13, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Single Turret",{"$f":"IF(COUNTIF(Y7:Y56,\"S\")<D7,D7-COUNTIF(Y7:Y56,\"S\"),\"good\")","v":"good"},{"$f":"IF(COUNTIF(Y7:Y56,\"S\")>D7,COUNTIF(Y7:Y56,\"S\")-D7,\"good\")","v":"good"},null,null,9,{"$nulls":6},34,{"$nulls":8},9,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I15\"","v":"I15"},null,9,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN14, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Double Turet",{"$f":"IF(COUNTIF(Y7:Y56,\"D\")<E7,E7-COUNTIF(Y7:Y56,\"D\"),\"good\")","v":"good"},{"$f":"IF(COUNTIF(Y7:Y56,\"D\")>E7,COUNTIF(Y7:Y56,\"D\")-E7,\"good\")","v":"good"},null,null,10,{"$nulls":6},35,{"$nulls":8},10,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I16\"","v":"I16"},null,10,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN15, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Triple Turret",{"$f":"IF(COUNTIF(Y7:Y56,\"T\")<F7,F7-COUNTIF(Y7:Y56,\"T\"),\"good\")","v":"good"},{"$f":"IF(COUNTIF(I7:I31,\"T\")>F7,COUNTIF(I7:I31,\"T\")-F7,\"good\")","v":"good"},null,null,11,{"$nulls":6},36,{"$nulls":8},11,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I17\"","v":"I17"},null,11,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN16, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},12,{"$nulls":6},37,{"$nulls":8},12,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I18\"","v":"I18"},null,12,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN17, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Checks","Short","Over",null,null,13,{"$nulls":6},38,{"$nulls":8},13,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I19\"","v":"I19"},null,13,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN18, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Pulse Laser",{"$f":"IF(SUM(Z7:Z56)<D9,D9-SUM(Z7:Z56),\"good\")","v":"good"},{"$f":"IF(SUM(Z7:Z56)>D9,SUM(Z7:Z56)-D9,\"good\")","v":"good"},null,null,14,{"$nulls":6},39,{"$nulls":8},14,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I20\"","v":"I20"},null,14,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN19, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Beam Laser",{"$f":"IF(SUM(AA7:AA56)<D10,D10-SUM(AA7:AA56),\"good\")","v":"good"},{"$f":"IF(SUM(AA7:AA56)>D10,SUM(AA7:AA56)-D10,\"good\")","v":"good"},null,null,15,{"$nulls":6},40,{"$nulls":8},15,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I21\"","v":"I21"},null,15,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN20, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Missile Rack",{"$f":"IF(SUM(AB7:AB56)<D11,D11-SUM(AB7:AB56),\"good\")","v":"good"},{"$f":"IF(SUM(AB7:AB56)>D11,SUM(AB7:AB56)-D11,\"good\")","v":"good"},null,null,16,{"$nulls":6},41,{"$nulls":8},16,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I22\"","v":"I22"},null,16,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN21, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,null,"Sandcaster",{"$f":"IF(SUM(AC7:AC56)<D12,D12-SUM(AC7:AC56),\"good\")","v":"good"},{"$f":"IF(SUM(AC7:AC56)>D12,SUM(AC7:AC56)-D12,\"good\")","v":"good"},null,null,17,{"$nulls":6},42,{"$nulls":8},17,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I23\"","v":"I23"},null,17,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN22, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},18,{"$nulls":6},43,{"$nulls":8},18,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I24\"","v":"I24"},null,18,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN23, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,"Click here to clear unavailable turrets",{"$nulls":5},19,{"$nulls":6},44,{"$nulls":8},19,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I25\"","v":"I25"},null,19,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN24, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},20,{"$nulls":6},45,{"$nulls":8},20,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I26\"","v":"I26"},null,20,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN25, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},21,{"$nulls":6},46,{"$nulls":8},21,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I27\"","v":"I27"},null,21,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN26, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[null,"Click here to clear ALL turrets",{"$nulls":5},22,{"$nulls":6},47,{"$nulls":8},22,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I28\"","v":"I28"},null,22,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN27, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},23,{"$nulls":6},48,{"$nulls":8},23,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I29\"","v":"I29"},null,23,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN28, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},24,{"$nulls":6},49,{"$nulls":8},24,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I30\"","v":"I30"},null,24,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN29, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":7},25,{"$nulls":6},50,{"$nulls":8},25,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"I31\"","v":"I31"},null,25,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN30, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},26,{"$f":"P7","v":0},{"$f":"Q7","v":0},{"$f":"R7","v":0},{"$f":"S7","v":0},{"$f":"T7","v":0},0,"G","G",{"$nulls":3},{"$f":"\"P7\"","v":"P7"},null,26,{"$f":"IF(P7=\"\",\"x\",P7) & IF(Q7=\"\",\"xx\",\"P\"&Q7) & IF(R7=\"\",\"xx\",\"B\"&R7) & IF(S7=\"\",\"xx\",\"M\"&S7) & IF(T7=\"\",\"xx\",\"S\"&T7)","v":"xxxxxxxxx"},{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN31, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},27,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P8\"","v":"P8"},null,27,{"$f":"IF(P8=\"\",\"x\",P8) & IF(Q8=\"\",\"xx\",\"P\"&Q8) & IF(R8=\"\",\"xx\",\"B\"&R8) & IF(S8=\"\",\"xx\",\"M\"&S8) & IF(T8=\"\",\"xx\",\"S\"&T8)","v":"xxxxxxxxx"},{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN32, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},28,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P9\"","v":"P9"},null,28,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN33, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},29,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P10\"","v":"P10"},null,29,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN34, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},30,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P11\"","v":"P11"},null,30,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN35, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},31,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P12\"","v":"P12"},null,31,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN36, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},32,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P13\"","v":"P13"},null,32,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN37, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},33,0,0,0,0,0,{"$f":"SUM(Z39:AC39)","v":0},{"$f":"IFERROR(IF(AD39>VLOOKUP(Y39,checktsum,2,0),\"F\"&Y39,\"G\"),\"G\")","v":"G"},{"$f":"IFERROR(IF(AD39<VLOOKUP(Y39,checktsum,2,0),\"F\"&Y39,\"G\"),\"G\")","v":"G"},{"$nulls":3},{"$f":"\"P14\"","v":"P14"},null,33,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN38, turretList), 0)),\"\")","v":""},{"$f":"IF(LEFT(AN39,1)<>\"x\",COUNTIF(turretList,AN39),0)","v":0},"","","","","",{"v":0,"d":"0.00"},{"$f":"IF(AO39>0,VLOOKUP(AO39,oneHundred,2,1)&\" \",\"\")","v":""},{"$f":"IF(AO39>0,VLOOKUP(AP39,SDTurret,2,0)&\" \",\"\")","v":""},"","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},34,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P15\"","v":"P15"},null,{"$f":"AL39+1","v":34},"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN39, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},35,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P16\"","v":"P16"},null,35,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN40, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},36,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P17\"","v":"P17"},null,36,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN41, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},37,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P18\"","v":"P18"},null,37,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN42, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},38,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P19\"","v":"P19"},null,38,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN43, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},39,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P20\"","v":"P20"},null,39,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN44, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},40,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P21\"","v":"P21"},null,40,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN45, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},41,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P22\"","v":"P22"},null,41,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN46, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},42,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P23\"","v":"P23"},null,42,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN47, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},43,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P24\"","v":"P24"},null,43,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN48, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},44,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P25\"","v":"P25"},null,44,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN49, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},45,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P26\"","v":"P26"},null,45,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN50, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},46,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P27\"","v":"P27"},null,46,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN51, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},47,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P28\"","v":"P28"},null,47,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN52, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},48,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P29\"","v":"P29"},null,48,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN53, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},49,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P30\"","v":"P30"},null,49,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN54, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]
[{"$nulls":23},50,0,0,0,0,0,0,"G","G",{"$nulls":3},{"$f":"\"P31\"","v":"P31"},null,50,"xxxxxxxxx",{"$f":"IFERROR(INDEX(turretList, MATCH(0,COUNTIF($AN$6:AN55, turretList), 0)),\"\")","v":""},0,"","","","","",{"v":0,"d":"0.00"},"","","","","","","","","","",{"$nulls":3},"",""]

{"sheet":"QUICKINFO","index":3,"n_rows":138,"n_cols":19,"rows_kept":138,"merged":[[0,1,1,9],[9,4,9,5],[28,6,28,7],[35,5,35,7],[134,7,134,8]]}
[null,"Various unused rows in the ship description below will automatically hide themselves when you activate this sheet."]
[{"$nulls":18},"HIDEROWS"]
[null,"Ship Descriptive Name",{"$f":"BUILD!G2","v":"ENTER SHIP DESCRIPTIVE NAME"},{"$nulls":4},"Build",{"$nulls":9},"Yes",{"$f":"IF(R3=\"Yes\",TRUE,FALSE)","v":true}]
[null,"Type",{"$f":"BUILD!AG2","v":"TYPE CODE"},{"$nulls":4},"Time","Tons","MCr",{"$nulls":7},"Yes",true]
[null,"Hull Tonnage",{"$f":"shipTonnage","v":{"v":1100,"d":"1,100"}},{"$nulls":4},{"$f":"BUILD!AH6","v":32},null,{"$f":"BUILD!AG6","v":{"v":110,"d":"110.00"}},{"$nulls":7},{"$f":"IF(J5>0,\"Yes\",\"No\")","v":"Yes"},true]
[null,"Jump Drive",{"$f":"letterJump","v":"J"},{"$nulls":3},{"$f":"  \"Performance: Jump-\" & numJDrive","v":"Performance: Jump-1"},null,{"$f":"BUILD!AF16","v":{"v":50,"d":"50.00"}},{"$f":"BUILD!AG16","v":{"v":90,"d":"90.00"}},{"$nulls":7},{"$f":"IF(J6>0,\"Yes\",\"No\")","v":"Yes"},true]
[null,"Maneuver Drive",{"$f":"letterManeuver","v":"J"},{"$nulls":3},{"$f":"  \"Performance: \" & numMDrive &\"-G acceleration\"","v":"Performance: 1-G acceleration"},null,{"$f":"BUILD!AF17","v":{"v":17,"d":"17.00"}},{"$f":"BUILD!AG17","v":{"v":36,"d":"36.00"}},{"$nulls":7},"Yes",true]
[null,"Power Plant",{"$f":"letterPower","v":"J"},{"$nulls":5},{"$f":"BUILD!AF18","v":{"v":28,"d":"28.00"}},{"$f":"BUILD!AG18","v":{"v":72,"d":"72.00"}},{"$nulls":7},"Yes",true]
[null,"Streamlined",{"$f":"streaming","v":"NO"},{"$nulls":6},{"$f":"BUILD!AG133","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(J9>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Fuel Tankage",null,null,{"$f":"\"------Notes------\"","v":"------Notes------"},{"$nulls":3},"Tons","MCr",{"$nulls":7},"Yes",true]
[null,"Power Plant and Maneuver",null,null,{"$f":"BUILD!AC25*4","v":0},"Weeks",null,null,{"$f":"BUILD!AF25","v":{"v":0,"d":"0.00"}},"na",{"$nulls":7},{"$f":"IF(I11>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Jump",null,null,{"$f":"BUILD!AC27","v":0},{"$f":"IF(E12<2,\"Jump-\"&numJDrive,\"Jump-\"&numJDrive&\"'s\")","v":"Jump-1"},null,null,{"$f":"BUILD!AF27","v":{"v":0,"d":"0.00"}},"na",{"$nulls":7},{"$f":"IF(I12>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Vehicle, Small Craft and Fuel Reserve","also noted below",{"$nulls":5},{"$f":"totalReserve","v":{"v":0,"d":"0.00"}},"na",{"$nulls":7},{"$f":"IF(I13>0,\"Yes\",\"No\")","v":"No"},false]
[{"$nulls":8},"Tons","MCr",{"$nulls":7},"Yes",true]
[null,"Standard Bridge",null,null,"Capacity","TL","MCredit",null,{"$f":"BUILD!AF35","v":{"v":22,"d":"22.00"}},{"$f":"BUILD!AG35","v":{"v":5.5,"d":"5.50"}},{"$nulls":7},"Yes",true]
[null,"Computer",{"$f":"\"Model/\"&selectedModel","v":"Model/1"},null,{"$f":"BUILD!AH40","v":"2 / 4"},{"$f":"BUILD!AH41","v":5},{"$f":"BUILD!AH42","v":{"v":1,"d":"1.00"}},null,{"$f":"BUILD!AF38","v":{"v":1,"d":"1.00"}},{"$f":"BUILD!AG38","v":{"v":2,"d":"2.00"}},{"$nulls":7},"Yes",true]
[null,"Accomodations and Accessories",{"$nulls":6},"Tons","MCr",{"$nulls":7},{"$f":"IF(COUNTIF(R18:R28,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},false]
[null,{"$f":"\"Stateroom\" & IF(C18>1,\"s\",\"\")","v":"Stateroom"},{"$f":"stateRooms","v":0},{"$nulls":5},{"$f":"BUILD!AF66","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG66","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(I18>0,\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"Low Berth\" & IF(C19>1,\"s\",\"\")","v":"Low Berth"},{"$f":"lowBerths","v":0},{"$nulls":5},{"$f":"BUILD!AF67","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG67","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(I19>0,\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"Emergency Low Berth\" & IF(C20>1,\"s\",\"\")","v":"Emergency Low Berth"},{"$f":"emlowBerths","v":0},{"$nulls":5},{"$f":"BUILD!AF68","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG68","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Small Craft Stateroom\" & IF(C21>1,\"s\",\"\")","v":"Small Craft Stateroom"},{"$f":"smallStaterooms","v":0},{"$nulls":5},{"$f":"BUILD!AF69","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG69","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Small Craft Couch\" & IF(C22>1,\"es\",\"\")","v":"Small Craft Couch"},{"$f":"smallCouches","v":0},{"$nulls":5},{"$f":"BUILD!AF70","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG70","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Morse Hyper/13\" & IF(C23>1,\"'s\",\"\")","v":"Morse Hyper/13"},{"$f":"morse13","v":0},{"$nulls":5},{"$f":"BUILD!AF71","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG71","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Morse Hyper/14\" & IF(C24>1,\"'s\",\"\")","v":"Morse Hyper/14"},{"$f":"morse14","v":0},{"$nulls":5},{"$f":"BUILD!AF72","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG72","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Morse Hyper/15\" & IF(C25>1,\"'s\",\"\")","v":"Morse Hyper/15"},{"$f":"morse15","v":0},{"$nulls":5},{"$f":"BUILD!AF73","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG73","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Morse Hyper/13 (core)\" & IF(C26>1,\"'s\",\"\")","v":"Morse Hyper/13 (core)"},{"$f":"mCore13","v":0},{"$nulls":5},{"$f":"BUILD!AF74","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG74","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Morse Hyper/14 (core)\" & IF(C27>1,\"'s\",\"\")","v":"Morse Hyper/14 (core)"},{"$f":"mCore14","v":0},{"$nulls":5},{"$f":"BUILD!AF75","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG75","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Morse Hyper/15 (core)\" & IF(C28>1,\"'s\",\"\")","v":"Morse Hyper/15 (core)"},{"$f":"mCore15","v":0},{"$nulls":5},{"$f":"BUILD!AF76","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG76","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,"Armaments",{"$nulls":6},"Tons","MCr",{"$nulls":7},{"$f":"IF(COUNTIF(R30:R35,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},false]
[null,"Hardpoints:",{"$f":"hardpointsOn &\" of \" & maxHardpoints","v":"0 of 11"},{"$nulls":6},{"$f":"BUILD!AG82","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(J30>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Fire Control",{"$f":"firecontrolOn","v":0},{"$nulls":5},{"$f":"BUILD!AF83","v":{"v":0,"d":"0.00"}},"na",{"$nulls":7},{"$f":"IF(I31>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Single, Double, Triple Turrets",{"$f":"sinTurret &\"s / \"&duoTurret&\"d / \"&triTurret & \"t\"","v":"0s / 0d / 0t"},{"$nulls":6},{"$f":"SUM(BUILD!AG84:AG86)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(J32>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Weapons",null,{"$f":"\"PL = \"&BUILD!AC87","v":"PL = 0"},{"$f":"\"BL = \"&BUILD!AC88","v":"BL = 0"},{"$f":"\"MR = \"&BUILD!AC89","v":"MR = 0"},{"$f":"\"SC = \"&BUILD!AC90","v":"SC = 0"},null,null,{"$f":"SUM(BUILD!AG87:AG90)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(J33>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Extra missiles",{"$f":"BUILD!AB92","v":0},{"$nulls":5},{"$f":"BUILD!AF92","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG92","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(J34>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Extra sand cannisters",{"$f":"BUILD!AB93","v":0},{"$nulls":5},{"$f":"BUILD!AF93","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG93","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(J35>0,\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"Unique Turret Group ID\"","v":"Unique Turret Group ID"},{"$nulls":3},{"$f":"\"Turrets Installed: \" & Tinstalled","v":"Turrets Installed: 0"},{"$nulls":3},"MCr",{"$nulls":7},{"$f":"IF(COUNTIF(R37:R86,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(R36=\"Yes\",TRUE,FALSE)","v":false}]
[null,{"$f":"P37","v":""},{"$f":"TURRETS!BJ7","v":""},{"$nulls":6},{"$f":"TURRETS!AU7","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R37=\"Yes\",SUM(Q37),\"\")","v":""},{"$f":"IF(R37=\"Yes\",1,\"\")","v":""},{"$f":"IF(J37>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(R37=\"Yes\",TRUE,FALSE)","v":false}]
[null,{"$f":"P38","v":""},{"$f":"TURRETS!BJ8","v":""},{"$nulls":6},{"$f":"TURRETS!AU8","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R38=\"Yes\",SUM($Q$37:Q38),\"\")","v":""},{"$f":"IF(R38=\"Yes\",1,\"\")","v":""},{"$f":"IF(J38>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(R38=\"Yes\",TRUE,FALSE)","v":false}]
[null,"",{"$f":"TURRETS!BJ9","v":""},{"$nulls":6},{"$f":"TURRETS!AU9","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R39=\"Yes\",SUM($Q$37:Q39),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ10","v":""},{"$nulls":6},{"$f":"TURRETS!AU10","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R40=\"Yes\",SUM($Q$37:Q40),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ11","v":""},{"$nulls":6},{"$f":"TURRETS!AU11","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R41=\"Yes\",SUM($Q$37:Q41),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ12","v":""},{"$nulls":6},{"$f":"TURRETS!AU12","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R42=\"Yes\",SUM($Q$37:Q42),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ13","v":""},{"$nulls":6},{"$f":"TURRETS!AU13","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R43=\"Yes\",SUM($Q$37:Q43),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ14","v":""},{"$nulls":6},{"$f":"TURRETS!AU14","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R44=\"Yes\",SUM($Q$37:Q44),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ15","v":""},{"$nulls":6},{"$f":"TURRETS!AU15","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R45=\"Yes\",SUM($Q$37:Q45),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ16","v":""},{"$nulls":6},{"$f":"TURRETS!AU16","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R46=\"Yes\",SUM($Q$37:Q46),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ17","v":""},{"$nulls":6},{"$f":"TURRETS!AU17","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R47=\"Yes\",SUM($Q$37:Q47),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ18","v":""},{"$nulls":6},{"$f":"TURRETS!AU18","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R48=\"Yes\",SUM($Q$37:Q48),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ19","v":""},{"$nulls":6},{"$f":"TURRETS!AU19","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R49=\"Yes\",SUM($Q$37:Q49),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ20","v":""},{"$nulls":6},{"$f":"TURRETS!AU20","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R50=\"Yes\",SUM($Q$37:Q50),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ21","v":""},{"$nulls":6},{"$f":"TURRETS!AU21","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R51=\"Yes\",SUM($Q$37:Q51),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ22","v":""},{"$nulls":6},{"$f":"TURRETS!AU22","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R52=\"Yes\",SUM($Q$37:Q52),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ23","v":""},{"$nulls":6},{"$f":"TURRETS!AU23","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R53=\"Yes\",SUM($Q$37:Q53),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ24","v":""},{"$nulls":6},{"$f":"TURRETS!AU24","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R54=\"Yes\",SUM($Q$37:Q54),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ25","v":""},{"$nulls":6},{"$f":"TURRETS!AU25","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R55=\"Yes\",SUM($Q$37:Q55),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ26","v":""},{"$nulls":6},{"$f":"TURRETS!AU26","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R56=\"Yes\",SUM($Q$37:Q56),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ27","v":""},{"$nulls":6},{"$f":"TURRETS!AU27","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R57=\"Yes\",SUM($Q$37:Q57),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ28","v":""},{"$nulls":6},{"$f":"TURRETS!AU28","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R58=\"Yes\",SUM($Q$37:Q58),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ29","v":""},{"$nulls":6},{"$f":"TURRETS!AU29","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R59=\"Yes\",SUM($Q$37:Q59),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ30","v":""},{"$nulls":6},{"$f":"TURRETS!AU30","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R60=\"Yes\",SUM($Q$37:Q60),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ31","v":""},{"$nulls":6},{"$f":"TURRETS!AU31","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R61=\"Yes\",SUM($Q$37:Q61),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ32","v":""},{"$nulls":6},{"$f":"TURRETS!AU32","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R62=\"Yes\",SUM($Q$37:Q62),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ33","v":""},{"$nulls":6},{"$f":"TURRETS!AU33","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R63=\"Yes\",SUM($Q$37:Q63),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ34","v":""},{"$nulls":6},{"$f":"TURRETS!AU34","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R64=\"Yes\",SUM($Q$37:Q64),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ35","v":""},{"$nulls":6},{"$f":"TURRETS!AU35","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R65=\"Yes\",SUM($Q$37:Q65),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ36","v":""},{"$nulls":6},{"$f":"TURRETS!AU36","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R66=\"Yes\",SUM($Q$37:Q66),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ37","v":""},{"$nulls":6},{"$f":"TURRETS!AU37","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R67=\"Yes\",SUM($Q$37:Q67),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ38","v":""},{"$nulls":6},{"$f":"TURRETS!AU38","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R68=\"Yes\",SUM($Q$37:Q68),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ39","v":""},{"$nulls":6},{"$f":"TURRETS!AU39","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R69=\"Yes\",SUM($Q$37:Q69),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ40","v":""},{"$nulls":6},{"$f":"TURRETS!AU40","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R70=\"Yes\",SUM($Q$37:Q70),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ41","v":""},{"$nulls":6},{"$f":"TURRETS!AU41","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R71=\"Yes\",SUM($Q$37:Q71),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ42","v":""},{"$nulls":6},{"$f":"TURRETS!AU42","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R72=\"Yes\",SUM($Q$37:Q72),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ43","v":""},{"$nulls":6},{"$f":"TURRETS!AU43","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R73=\"Yes\",SUM($Q$37:Q73),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ44","v":""},{"$nulls":6},{"$f":"TURRETS!AU44","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R74=\"Yes\",SUM($Q$37:Q74),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ45","v":""},{"$nulls":6},{"$f":"TURRETS!AU45","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R75=\"Yes\",SUM($Q$37:Q75),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ46","v":""},{"$nulls":6},{"$f":"TURRETS!AU46","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R76=\"Yes\",SUM($Q$37:Q76),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ47","v":""},{"$nulls":6},{"$f":"TURRETS!AU47","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R77=\"Yes\",SUM($Q$37:Q77),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ48","v":""},{"$nulls":6},{"$f":"TURRETS!AU48","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R78=\"Yes\",SUM($Q$37:Q78),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ49","v":""},{"$nulls":6},{"$f":"TURRETS!AU49","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R79=\"Yes\",SUM($Q$37:Q79),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ50","v":""},{"$nulls":6},{"$f":"TURRETS!AU50","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R80=\"Yes\",SUM($Q$37:Q80),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ51","v":""},{"$nulls":6},{"$f":"TURRETS!AU51","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R81=\"Yes\",SUM($Q$37:Q81),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ52","v":""},{"$nulls":6},{"$f":"TURRETS!AU52","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R82=\"Yes\",SUM($Q$37:Q82),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ53","v":""},{"$nulls":6},{"$f":"TURRETS!AU53","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R83=\"Yes\",SUM($Q$37:Q83),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ54","v":""},{"$nulls":6},{"$f":"TURRETS!AU54","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R84=\"Yes\",SUM($Q$37:Q84),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ55","v":""},{"$nulls":6},{"$f":"TURRETS!AU55","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R85=\"Yes\",SUM($Q$37:Q85),\"\")","v":""},"","No",false]
[null,"",{"$f":"TURRETS!BJ56","v":""},{"$nulls":6},{"$f":"TURRETS!AU56","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(R86=\"Yes\",SUM($Q$37:Q86),\"\")","v":""},"","No",false]
[null,"Small Craft and Vehicles",{"$nulls":5},"Fuel Reserve Tons","Tons","MCr",{"$nulls":7},{"$f":"IF(COUNTIF(R88:R104,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},false]
[null,{"$f":"\"ATV ( x \" & BUILD!AC99 & \" )\"","v":"ATV ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF99","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG99","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(I88>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(R88=\"Yes\",TRUE,FALSE)","v":false}]
[null,{"$f":"\"Air/Raft ( x \" & BUILD!AC100 & \" )\"","v":"Air/Raft ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF100","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG100","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(I89>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(R89=\"Yes\",TRUE,FALSE)","v":false}]
[null,{"$f":"\"Speeder ( x \" & BUILD!AC101 & \" )\"","v":"Speeder ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF101","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG101","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"GCarrier ( x \" & BUILD!AC102 & \" )\"","v":"GCarrier ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF102","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG102","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Launch ( x \" & BUILD!AC103 & \" )\"","v":"Launch ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ103","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF103-BUILD!AJ103","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG103","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(OR(H92>0,I92>0),\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"Ship's Boat ( x \" & BUILD!AC104 & \" )\"","v":"Ship's Boat ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ104","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF104-BUILD!AJ104","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG104","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(OR(H93>0,I93>0),\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"Pinnace ( x \" & BUILD!AC105 & \" )\"","v":"Pinnace ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ105","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF105-BUILD!AJ105","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG105","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Cutter ( x \" & BUILD!AC106 & \" )\"","v":"Cutter ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ107","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF106-BUILD!AJ106","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG106","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Fuel Module ( x \" & BUILD!AC107 & \" )\"","v":"Fuel Module ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF107-BUILD!AJ107","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG107","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(I96>0,\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"ATV Module ( x \" & BUILD!AC108 & \" )\"","v":"ATV Module ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF108","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG108","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Open Module ( x \" & BUILD!AC109 & \" )\"","v":"Open Module ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF109","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG109","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Provision for future modules ( x \" & BUILD!AC110 & \" )\"","v":"Provision for future modules ( x 0 )"},{"$nulls":6},{"$f":"BUILD!AF110","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG110","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Slow Boat ( x \" & BUILD!AC111 & \" )\"","v":"Slow Boat ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ111","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF111-BUILD!AJ111","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG111","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(OR(H100>0,I100>0),\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"\"Slow Pinnace ( x \" & BUILD!AC112 & \" )\"","v":"Slow Pinnace ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ112","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF112-BUILD!AJ112","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG112","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Shuttle ( x \" & BUILD!AC113 & \" )\"","v":"Shuttle ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ113","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF113-BUILD!AJ113","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG113","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,{"$f":"\"Fighter ( x \" & BUILD!AC114 & \" )\"","v":"Fighter ( x 0 )"},{"$nulls":5},{"$f":"BUILD!AJ114","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AF114-BUILD!AJ114","v":{"v":0,"d":"0.00"}},{"$f":"BUILD!AG114","v":{"v":0,"d":"0.00"}},{"$nulls":7},"No",false]
[null,"Long Term Fuel Reserves",{"$nulls":5},{"$f":"BUILD!AJ116","v":{"v":0,"d":"0.00"}},{"$nulls":9},{"$f":"IF(H104>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Cargo Bay","Tonnage",{"$nulls":5},"Tons",{"$nulls":8},{"$f":"IF(COUNTIF(R106:R110,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},false]
[null,{"$f":"IF(C106>0,\"Bay #\" & P106,\"\")","v":""},{"$f":"BUILD!AA124","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"C106","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF(R106=\"Yes\",SUM(Q106),\"\")","v":""},{"$f":"IF(R106>0,1,0)","v":1},{"$f":"IF(C106>0,\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"IF(C107>0,\"Bay #\" & P107,\"\")","v":""},{"$f":"BUILD!AA125","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"C107","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF(R107=\"Yes\",SUM($Q$106:Q107),\"\")","v":""},{"$f":"IF(R107=\"Yes\",1,\"\")","v":""},{"$f":"IF(C107>0,\"Yes\",\"No\")","v":"No"},false]
[null,"",{"$f":"BUILD!AA126","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"C108","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF(R108=\"Yes\",SUM($Q$106:Q108),\"\")","v":""},"","No",false]
[null,"",{"$f":"BUILD!AA127","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"C109","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF(R109=\"Yes\",SUM($Q$106:Q109),\"\")","v":""},"","No",false]
[null,"",{"$f":"BUILD!AA128","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"C110","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF(R110=\"Yes\",SUM($Q$106:Q110),\"\")","v":""},"","No",false]
[null,"Crew Position","Staterooms","Low Berths",null,"Occupancy",null,{"$f":"\"Installed SR / LB = \" & C18 & \" / \" & C19","v":"Installed SR / LB = 0 / 0"},{"$nulls":9},{"$f":"IF(COUNTIF(R112:R125,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},false]
[null,{"$f":"BUILD!C142 & \" ( x \"&BUILD!E142 &\" )\"","v":"Captain ( x 0 )"},{"$f":"BUILD!W142","v":0},{"$f":"BUILD!AC142","v":0},null,{"$f":"BUILD!BG142","v":""},{"$nulls":11},{"$f":"IF(OR(C112>0,D112>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R112=\"Yes\",TRUE,FALSE)","v":false}]
[null,{"$f":"BUILD!C143 & \" ( x \"&BUILD!E143 &\" )\"","v":"Commanding Officer ( x 0 )"},{"$f":"BUILD!W143","v":0},{"$f":"BUILD!AC143","v":0},null,{"$f":"BUILD!BG143","v":""},{"$nulls":11},{"$f":"IF(OR(C113>0,D113>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R113=\"Yes\",TRUE,FALSE)","v":false}]
[null,{"$f":"BUILD!C144 & \" ( x \"&BUILD!E144 &\" )\"","v":"Executive Officer ( x 0 )"},{"$f":"BUILD!W144","v":0},{"$f":"BUILD!AC144","v":0},null,{"$f":"BUILD!BG144","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C145 & \" ( x \"&BUILD!E145 &\" )\"","v":"Admin Rating ( x 0 )"},{"$f":"BUILD!W145","v":0},{"$f":"BUILD!AC145","v":0},null,{"$f":"BUILD!BG145","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C146 & \" ( x \"&BUILD!E146 &\" )\"","v":"Crew Rating ( x 0 )"},{"$f":"BUILD!W146","v":0},{"$f":"BUILD!AC146","v":0},null,{"$f":"BUILD!BG146","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C147 & \" ( x \"&BUILD!E147 &\" )\"","v":"Pilot ( x 0 )"},{"$f":"BUILD!W147","v":0},{"$f":"BUILD!AC147","v":0},null,{"$f":"BUILD!BG147","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C148 & \" ( x \"&BUILD!E148 &\" )\"","v":"Navigator ( x 0 )"},{"$f":"BUILD!W148","v":0},{"$f":"BUILD!AC148","v":0},null,{"$f":"BUILD!BG148","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C149 & \" ( x \"&BUILD!E149 &\" )\"","v":"Engineer ( x 0 )"},{"$f":"BUILD!W149","v":0},{"$f":"BUILD!AC149","v":0},null,{"$f":"BUILD!BG149","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C150 & \" ( x \"&BUILD!E150 &\" )\"","v":"Steward ( x 0 )"},{"$f":"BUILD!W150","v":0},{"$f":"BUILD!AC150","v":0},null,{"$f":"BUILD!BG150","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C151 & \" ( x \"&BUILD!E151 &\" )\"","v":"Medic ( x 0 )"},{"$f":"BUILD!W151","v":0},{"$f":"BUILD!AC151","v":0},null,{"$f":"BUILD!BG151","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C152 & \" ( x \"&BUILD!E152 &\" )\"","v":"Gunner ( x 0 )"},{"$f":"BUILD!W152","v":0},{"$f":"BUILD!AC152","v":0},null,{"$f":"BUILD!BG152","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C153 & \" ( x \"&BUILD!E153 &\" )\"","v":"Troop ( x 0 )"},{"$f":"BUILD!W153","v":0},{"$f":"BUILD!AC153","v":0},null,{"$f":"BUILD!BG153","v":""},{"$nulls":11},"No",false]
[null,{"$f":"BUILD!C154 & \" ( x \"&BUILD!E154 &\" )\"","v":"Dedicated V/SC Pilot ( x 0 )"},{"$f":"BUILD!W154","v":0},{"$f":"BUILD!AC154","v":0},null,{"$f":"BUILD!BG154","v":""},{"$nulls":11},{"$f":"IF(OR(C124>0,D124>0),\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"BUILD!C155","v":"Unallocated Staterooms"},{"$f":"BUILD!W155","v":0},{"$f":"BUILD!AC155","v":0},null,{"$f":"BUILD!BG155","v":""},{"$nulls":11},"No",false]
[null,"Passengers","Staterooms","Low Berths",null,"Occupancy",null,{"$f":"\"Recommended SR / LB = \" & SUM(C112:C125)+SUM(C127:C130) &\" / \" & SUM(D112:D125)+SUM(D127:D130)","v":"Recommended SR / LB = 0 / 0"},{"$nulls":9},{"$f":"IF(COUNTIF(R127:R130,\"Yes\")=0,\"No\",\"Yes\")","v":"No"},false]
[null,"Luxury High or Middle",{"$f":"BUILD!W156","v":0},null,null,{"$f":"BUILD!BG156","v":""},{"$nulls":11},"No",false]
[null,"Standard High or Middle",{"$f":"BUILD!W157","v":0},null,null,{"$f":"BUILD!BG157","v":""},{"$nulls":11},"No",false]
[null,"Economy High or Middle",{"$f":"BUILD!W158","v":0},null,null,{"$f":"BUILD!BG158","v":""},{"$nulls":11},"No",false]
[null,"Low Passengers",null,{"$f":"BUILD!AC159","v":0},null,{"$f":"BUILD!BG159","v":""},{"$nulls":11},"No",false]
[null,{"$f":"IF(SUM(C112:C130)<C18,\"Overage of staterooms purchased\",IF(SUM(C112:C130)>C18,\"Shortage of staterooms purchased\",\"Adequate staterooms purchased\"))","v":"Adequate staterooms purchased"},{"$nulls":3},{"$f":"IF(BUILD!G161>0,\"High/Medium Passengers with Double Occupancy = \" & BUILD!G161 )","v":false},{"$nulls":11},{"$f":"IF(SUM(C112:C130)>0,\"Yes\",\"No\")","v":"No"},false]
[null,{"$f":"IF(SUM(D112:D130)<C19,\"Overage of low berths purchased\",IF(SUM(D112:D130)>C19,\"Shortage of low berths purchased\",\"Adequate low berths purchased\"))","v":"Adequate low berths purchased"},{"$nulls":3},{"$f":"IF(SUM(BUILD!E156:E159)=0,\"No passengers are normally carried\",\"\")","v":"No passengers are normally carried"},{"$nulls":11},{"$f":"IF(SUM(D112:D130)>0,\"Yes\",\"No\")","v":"No"},false]
[{"$nulls":17},{"$f":"IF(SUM(C112:D130)>0,\"Yes\",\"No\")","v":"No"},false]
[null,"Summary of Ship Design",{"$nulls":7},"MCr",{"$nulls":7},{"$f":"\"Yes\"","v":"Yes"},true]
[null,{"$f":"\"Hull Tonnage = ( \"&TEXT(shipTonnage,\"#,000\")&\" tons )\"","v":"Hull Tonnage = ( 1,100 tons )"},null,{"$f":"\"Standard Hull Size = \" & BUILD!AL12","v":"Standard Hull Size = NO"},{"$nulls":3},{"$f":"\"Base Cost\"","v":"Base Cost"},null,{"$f":"IF(DesignType=\"Custom Design\",'BUILD TOTALS'!E21,'BUILD TOTALS'!E25)","v":{"v":315.5,"d":"315.5000"}},{"$nulls":7},{"$f":"\"Yes\"","v":"Yes"},true]
[null,{"$f":"\"Remaining Tonnage = ( \" &TEXT(remainingTons,\"#,##0\")&\" tons )\"","v":"Remaining Tonnage = ( 982 tons )"},null,{"$f":"IF(standard=\"Yes\",\"Design = Standard\",\"Design = Custom\")","v":"Design = Custom"},{"$nulls":4},{"$f":"IF(DesignType=\"Custom Design\",\"Architect Fee\",\"10% Discount\")","v":"Architect Fee"},{"$f":"IF(DesignType=\"Custom Design\",'BUILD TOTALS'!E22,'BUILD TOTALS'!E26)","v":{"v":3.1550000000000002,"d":"3.1550"}},{"$nulls":7},"Yes",true]
[null,{"$f":"\"Build Time = ( \" & BUILD!AH6 &\" months )\"","v":"Build Time = ( 32 months )"},{"$nulls":6},{"$f":"IF(DesignType= \"Custom Design\",'BUILD TOTALS'!D23,'BUILD TOTALS'!D27)","v":"Total"},{"$f":"IF(DesignType=\"Custom Design\",'BUILD TOTALS'!E23,'BUILD TOTALS'!E27)","v":{"v":318.655,"d":"318.6550"}},{"$nulls":7},"Yes",true]
[null,{"$f":"\"Streamlined = \" & streaming","v":"Streamlined = NO"},{"$nulls":6},{"$f":"IF(DesignType=\"Custom Design\",\"\",\"Total\")","v":""},{"$f":"IF(DesignType=\"Custom Design\",\"\",'BUILD TOTALS'!E28)","v":""},{"$nulls":7},"Yes",true]

{"sheet":"SOFTWARE","index":4,"n_rows":39,"n_cols":22,"rows_kept":39}
[]
[]
[{"$nulls":3},{"$f":"BUILD!G2 & \" ( type \" & BUILD!AG2 & \" )\"","v":"ENTER SHIP DESCRIPTIVE NAME ( type TYPE CODE )"},{"$nulls":17},{"$f":"\"Computer Model/\" & selectedModel","v":"Computer Model/1"}]
[]
[]
[{"$nulls":3},"Routine",null,null,"Space","MCr",null,null,"Defensive",null,null,"Space","MCr",null,null,"Offensive",null,null,"Space","MCr"]
[]
[{"$nulls":3},{"$f":"BUILD!BI53","v":""},null,"Maneuver",1,0.1,null,null,{"$f":"BUILD!BI48","v":""},null,"Maneuver/evade 1",1,{"v":1,"d":"1.0"},null,null,{"$f":"BUILD!BI41","v":""},null,"Predict 1",1,{"v":2,"d":"2.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BI54","v":""},null,"Jump 1",1,0.1,null,null,{"$f":"BUILD!BJ48","v":""},null,"Maneuver/evade 2",2,{"v":2,"d":"2.0"},null,null,{"$f":"BUILD!BJ41","v":""},null,"Predict 2",2,{"v":4,"d":"4.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BJ54","v":""},null,"Jump 2",2,0.3,null,null,{"$f":"BUILD!BK48","v":""},null,"Maneuver/evade 3",3,{"v":3,"d":"3.0"},null,null,{"$f":"BUILD!BK41","v":""},null,"Predict 3",1,{"v":6,"d":"6.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BK54","v":""},null,"Jump 3",2,0.4,null,null,{"$f":"BUILD!BL48","v":""},null,"Maneuver/evade 4",4,{"v":4,"d":"4.0"},null,null,{"$f":"BUILD!BL41","v":""},null,"Predict 4",3,{"v":8,"d":"8.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BL54","v":""},null,"Jump 4",2,0.5,null,null,{"$f":"BUILD!BM48","v":""},null,"Maneuver/evade 5",2,{"v":5,"d":"5.0"},null,null,{"$f":"BUILD!BM41","v":""},null,"Predict 5",2,{"v":10,"d":"10.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BM54","v":""},null,"Jump 5",2,0.6,null,null,{"$f":"BUILD!BN48","v":""},null,"Maneuver/evade 6",3,{"v":6,"d":"6.0"},null,null,{"$f":"BUILD!BI42","v":""},null,"Gunner Interact",1,{"v":1,"d":"1.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BN54","v":""},null,"Jump 6",2,0.7,null,null,{"$f":"BUILD!BI49","v":""},null,"Auto/evade",1,0.5,null,null,{"$f":"BUILD!BI43","v":""},null,"Target",1,{"v":1,"d":"1.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BI55","v":""},null,"Navigation",1,0.4,null,null,{"$f":"BUILD!BI50","v":""},null,"Return Fire",1,0.5,null,null,{"$f":"BUILD!BI44","v":""},null,"Selective 1",1,0.5]
[]
[{"$nulls":3},{"$f":"BUILD!BI56","v":""},null,"Differentiate 1",1,0.5,null,null,{"$f":"BUILD!BI51","v":""},null,"Anti-Missile",2,{"v":1,"d":"1.0"},null,null,{"$f":"BUILD!BJ44","v":""},null,"Selective 2",2,0.8]
[]
[{"$nulls":3},{"$f":"BUILD!BJ56","v":""},null,"Differentiate 2",2,0.6,null,null,{"$f":"BUILD!BI52","v":""},null,"ECM",3,{"v":4,"d":"4.0"},null,null,{"$f":"BUILD!BK44","v":""},null,"Selective 3",1,{"v":1,"d":"1.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BK56","v":""},null,"Differentiate 3",3,0.7,{"$nulls":4},{"$f":"\"TL = \" & BUILD!AH41","v":"TL = 5"},"Space","MCr",null,null,{"$f":"BUILD!BJ45","v":""},null,"Multi-target 2",1,{"v":1,"d":"1.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BI57","v":""},null,"Generate",2,0.8,{"$nulls":4},{"$f":"\"Capacity = \" & BUILD!AH40","v":"Capacity = 2 / 4"},{"$nulls":4},{"$f":"BUILD!BK45","v":""},null,"Multi-target 3",2,{"v":2,"d":"2.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BI58","v":""},null,"Anti-Hijack",1,0.1,{"$nulls":4},"Total Space and Cost",{"$f":"SUM(BUILD!V41:X59)","v":0},{"$f":"SUM(BUILD!Y41:AA59)","v":{"v":0,"d":"0.0"}},null,null,{"$f":"BUILD!BL45","v":""},null,"Multi-target 4",4,{"v":3,"d":"3.0"}]
[]
[{"$nulls":3},{"$f":"BUILD!BI59","v":""},null,"Library",1,0.3,{"$nulls":4},"Software Credit",null,{"$f":"BUILD!AH42","v":{"v":1,"d":"1.0"}},null,null,{"$f":"BUILD!BI46","v":""},null,"Launch",1,{"v":2,"d":"2.0"}]
[]
[{"$nulls":12},"Final Cost",null,{"$f":"IF(O32-O34<0,0,O32-O34)","v":{"v":0,"d":"0.0"}},null,null,{"$f":"BUILD!BI47","v":""},null,"Double Fire",4,{"v":4,"d":"4.0"}]
[]
[]
[{"$nulls":3},"Computer Programs (note those programs available)"]

{"sheet":"INFORMATION","index":5,"n_rows":22,"n_cols":10,"rows_kept":22,"hidden":true,"merged":[[2,1,29,1],[4,3,7,3],[4,5,7,5]]}
[{"$nulls":7},{"$f":"TRIM(J3 & J4 & J5 & J6 & J7 & J8 & J9 & J10 & J11 & J12 & J13 &J14 & J15 & J16 & J17 & J19 & J20 & J21 )","v":{"$error":"#N/A"}}]
[]
[null,"Free Trader (type A ): Using a 3200-ton hull, the Free Trader is an elementary interstellar merchant ship plying the space lanes and carrying cargo and passengers. It mounts jump drive-V, maneuver drive-V, and power plant-V, giving a performance of jump-1 and 1-G acceleration. Fuel tankage for 330 tons supports the power plant for 4 weeks and allows one jump-1. Adjacent to the bridge is a computer Model/1. There are ten staterooms and twenty low berths. There are thirty-two hardpoints and thirty-two tons allocated for fire control. Eleven single turrets are installed: one with a missile rack. Eleven double turrets are installed: one with beam lasers. Ten triple turrets are installed: one with pulse lasers, one with missile racks. Cargo capacity is 82 tons, divided into a single 82-ton bay. The hull is Streamlined.",null,"Descriptive Name",null,"Free Trader",null,1,null,{"$f":"\" \" & dName & \" (type \" & dType & \" ): \"","v":" Free Trader (type A ): "}]
[{"$nulls":3},"Type",null,"A",null,2,null,{"$f":"\" Using a \" & shipTonnage & \"-ton hull, the \" & dName & \" is \" & dDuty & \" \"","v":" Using a 1100-ton hull, the Free Trader is an elementary interstellar merchant ship plying the space lanes and carrying cargo and passengers. "}]
[{"$nulls":3},"Duties and Purpose",null,"an elementary interstellar merchant ship plying the space lanes and carrying cargo and passengers.",null,3,"DRIVES",{"$f":"\" It mounts jump drive-\" & letterJump & \", maneuver drive-\" & letterManeuver & \", and power plant-\" & letterPower & \", giving a performance of jump-\" & numJDrive & \" and \" & numMDrive & \"-G acceleration. \"","v":" It mounts jump drive-J, maneuver drive-J, and power plant-J, giving a performance of jump-1 and 1-G acceleration. "}]
[{"$nulls":7},4,"FUEL",{"$f":"\" Fuel tankage for \"&normFuelTankage&\" tons supports the power plant for \"&powerWeeks&\" weeks and allows \"&howmanyJumps&\" jump-\"&numJDrive&\". \" & IF(totalReserve>0,\", and holds \"&totalReserve&\" tons in reserve for its small craft and long term operations.\",\"\")","v":{"$error":"#N/A"}}]
[{"$nulls":7},5,"COMP",{"$f":"\" Adjacent to the bridge is a computer Model/\" & selectedModel & \". \"","v":" Adjacent to the bridge is a computer Model/1. "}]
[{"$nulls":7},6,"ACC",{"$f":"\" There are \"&VLOOKUP(stateRooms,oneHundred,2,1)&\" staterooms and \" &VLOOKUP(lowBerths,oneHundred,2,1) & \" low berths. \"","v":" There are no staterooms and no low berths. "}]
[{"$nulls":7},7,"ACC",{"$f":"IF(emlowBerths=1,\" There is one emergency low berth. \",IF(emlowBerths>1,\" There are \"& VLOOKUP(emlowBerths,oneHundred,2,1) &\" emergency low berths. \",\"\"))","v":""}]
[{"$nulls":7},8,"ACC",{"$f":"IF(smallStaterooms=1,\" There is one small craft stateroom. \",IF(smallStaterooms>1,\" There are \"& VLOOKUP(smallStaterooms,oneHundred,2,1) &\" small craft staterooms. \",\"\"))","v":""}]
[{"$nulls":7},9,"ACC",{"$f":"IF(smallCouches=1,\" There is one small craft couch. \",IF(smallCouches>1,\" There are \"& VLOOKUP(smallCouches,oneHundred,2,1) &\" small craft couches. \",\"\"))","v":""}]
[{"$nulls":7},10,"HP",{"$f":"\" There are \"&VLOOKUP(hardpointsOn,oneHundred,2,1)&\" hardpoints and \"&VLOOKUP(firecontrolOn,oneHundred,2,1)&\" tons allocated for fire control. \"&IF(totalturrets=0,\"No weapons are mounted.\",\"\")","v":" There are no hardpoints and no tons allocated for fire control. No weapons are mounted."}]
[{"$nulls":7},11,"S-Trt",{"$f":"IF(sinTurret>0,\" \" & singleTText,\"\")","v":""}]
[{"$nulls":7},12,"D-Trt",{"$f":"IF(duoTurret>0,\" \" & doubleTText,\"\")","v":""}]
[{"$nulls":7},13,"T-Trt",{"$f":"IF(triTurret>0,\" \" & tripleTText,\"\")","v":""}]
[{"$nulls":7},14,"Vehicles"]
[{"$nulls":7},15,"Vehicles",{"$f":"IF(totalVehicles>0,vehicleLIST,\"\")","v":""}]
[{"$nulls":7},16]
[{"$nulls":7},17,"Cargo",{"$f":"IF(allCargo>0,\" Cargo capacity is \" & allCargo & \" tons, divided into \" & IF(cargobays=1,\" \",IF(cargobays>1,\" several bays: \",\"\")) & cargoList,\"\")","v":""}]
[{"$nulls":7},18,"Stream",{"$f":"\" The hull is \" & IF(streaming=\"NO\",\"Unstreamlined\",\"Streamlined.\")","v":" The hull is Unstreamlined"}]
[{"$nulls":7},19,"Crew"]
[{"$nulls":7},20]

{"sheet":"BUILD TOTALS","index":6,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[19,3,19,4]]}
[]
[]
[{"$nulls":3},"Tons","Cost"]
[null,"STEP 1",null,{"$f":"shipTonnage","v":{"v":1100,"d":"1100.000"}},{"$f":"BUILD!AG6","v":{"v":110,"d":"110.000"}}]
[null,"STEP 2",null,{"$f":"SUM(BUILD!AF16:AF18)","v":{"v":95,"d":"95.000"}},{"$f":"SUM(BUILD!AG16:AG18)","v":{"v":198,"d":"198.000"}}]
[null,"STEP 3",null,{"$f":"SUM(BUILD!AF25:AF27)","v":{"v":0,"d":"0.000"}}]
[null,"STEP 4",null,{"$f":"SUM(BUILD!AF35:AF36)","v":{"v":22,"d":"22.000"}},{"$f":"BUILD!AG35","v":{"v":5.5,"d":"5.500"}}]
[null,"STEP 5",null,{"$f":"SUM(BUILD!AF38:AF40)","v":{"v":1,"d":"1.000"}},{"$f":"BUILD!AG38+BUILD!AG59","v":{"v":2,"d":"2.000"}}]
[null,"STEP 6",null,{"$f":"SUM(BUILD!AF66:AF76)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(BUILD!AG66:AG76)","v":{"v":0,"d":"0.000"}}]
[null,"STEP 7",null,{"$f":"SUM(BUILD!AF82:AF93)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(BUILD!AG82:AG93)","v":{"v":0,"d":"0.000"}}]
[null,"STEP 8",null,{"$f":"SUM(BUILD!AF99:AF119)+BUILD!AJ116","v":{"v":0,"d":"0.000"}},{"$f":"SUM(BUILD!AG99:AG119)","v":{"v":0,"d":"0.000"}}]
[null,"STEP 9",null,{"$f":"SUM(BUILD!AF124:AF128)","v":{"v":0,"d":"0.000"}}]
[null,"STEP 10",null,{"$f":"SUM(BUILD!AF133)","v":{"v":0,"d":"0.000"}},{"$f":"BUILD!AG133","v":{"v":0,"d":"0.000"}}]
[{"$nulls":3},"Remaining","Total MCr"]
[{"$nulls":3},{"$f":"D4-SUM(D5:D13)","v":{"v":982,"d":"982.000"}},{"$f":"E23","v":{"v":318.655,"d":"318.6550"}},null,"Custom Design, includes 1% Architect Fee"]
[{"$nulls":4},{"$f":"E28","v":{"v":283.95009999999996,"d":"283.9501"}},null,"Standard Design reflects 10% discount, plus 100Cr Plan Fee"]
[null,"Standard Design",null,{"$f":"BUILD!AL8","v":"NO"}]
[null,"Streamlining",null,{"$f":"BUILD!AL132","v":"NO"}]
[]
[{"$nulls":3},{"$f":"IF(BUILD!AL8=\"YES\",\"Standard Design\",\"Custom Design\")","v":"Custom Design"}]
[{"$nulls":3},"Custom Design",{"$f":"SUM(E4:E13)","v":{"v":315.5,"d":"315.500"}},null,"MCr","Architect Perc."]
[{"$nulls":3},"Architect Fee",{"$f":"(H22/100)*E21","v":3.1550000000000002},null,"MCr",{"$f":"IF(BUILD!AL3=\"YES\",1,IF(BUILD!AL5=\"YES\",1.5,0))","v":{"v":1,"d":"1.0"}}]
[{"$nulls":3},"Total",{"$f":"E21+E22","v":318.655}]
[]
[{"$nulls":3},"Standard Design",{"$f":"SUM(E4:E13)","v":{"v":315.5,"d":"315.500"}},null,"MCr"]
[{"$nulls":3},{"$f":"BUILD!AF12 * 100 &\"% Discount\"","v":"10% Discount"},{"$f":"-1 * (BUILD!AF12*E25)","v":-31.55},null,"MCr"]
[{"$nulls":3},"Plan Fee",{"$f":"0.0001","v":1E-4},null,"MCr"]
[{"$nulls":3},"Total",{"$f":"E25+E26+E27","v":{"v":283.95009999999996,"d":"283.950"}}]

{"sheet":"BUILDDATA","index":7,"n_rows":145,"n_cols":56,"rows_kept":145,"hidden":true,"merged":[[1,2,1,35],[1,38,1,44],[1,46,1,52],[3,49,3,50],[16,46,16,52],[30,38,30,44],[43,39,43,40],[43,43,43,44]]}
[]
[null,null,"BDTABLE",{"$nulls":35},"JMPTABLE",{"$nulls":7},"COMPTABLE"]
[{"$nulls":3},"Selected","Value","A","B","C","D","E","F","G","H","J","K","L","M","N","P","Q","R","S","T","U","V","W","X","Y","Z","Time",{"$nulls":6},"Formatted",{"$nulls":17},"a pulse laser","pulse lasers"]
[null,null,0,"No",{"$f":"0","v":0},{"$nulls":34},"JDrive",null,"MDrive",null,"PPlant",{"$nulls":5},"Capacity",{"$nulls":4},"a beam laser","beam lasers"]
[null,null,5,"No",{"$f":"IF(D5=\"Yes\",C5,\"\")","v":""},{"$nulls":31},{"$f":"IF(D5=\"Yes\",\"( \"&C5&\" )\",C5)","v":5},null,null,"Mass","MCr","Mass","MCr","Mass","MCr",null,null,"Tons","MCr","A","B","Tech","Bonus",null,"a missile rack","missile racks"]
[null,null,10,"No",{"$f":"IF(D6=\"Yes\",C6,\"\")","v":""},{"$nulls":31},{"$f":"IF(D6=\"Yes\",\"( \"&C6&\" )\",C6)","v":10},null,"A",10,10,1,4,4,8,null,1,1,2,2,4,5,1,null,"a sandcaster","sandcasters"]
[null,null,15,"No","",{"$nulls":31},15,null,"B",15,20,3,8,7,16,null,"1bis",1,4,4,0,6,1]
[null,null,20,"No","",{"$nulls":31},20,null,"C",20,30,5,12,10,24,null,2,2,9,3,6,7,2]
[null,null,25,"No","",{"$nulls":31},25,null,"D",25,40,7,16,13,32,null,"2bis",2,18,6,0,8,2]
[null,null,30,"No","",{"$nulls":31},30,null,"E",30,50,9,20,16,40,null,3,3,18,5,9,9,3]
[null,null,35,"No","",{"$nulls":31},35,null,"F",35,60,11,24,19,48,null,4,4,30,8,15,10,4]
[null,null,40,"No","",{"$nulls":31},40,null,"G",40,70,13,28,22,56,null,5,5,45,12,25,11,5]
[null,null,45,"No","",{"$nulls":31},45,null,"H",45,80,15,32,25,64,null,6,7,55,15,35,12,6]
[null,null,50,"No","",{"$nulls":31},50,null,"J",50,90,17,36,28,72,null,7,9,80,20,50,13,7]
[null,null,55,"No","",{"$nulls":31},55,null,"K",55,100,19,40,31,80]
[null,null,60,"No","",{"$nulls":31},60,null,"L",60,110,21,44,34,88]
[null,null,65,"No","",{"$nulls":31},65,null,"M",65,120,23,48,37,96,null,"HULLTABLE"]
[null,null,70,"No","",{"$nulls":31},70,null,"N",70,130,25,52,40,104,null,null,"MCr","Time"]
[null,null,75,"No","",{"$nulls":31},75,null,"P",75,140,27,56,43,112,null,100,2,9]
[null,null,80,"No","",{"$nulls":31},80,null,"Q",80,150,29,60,46,120,null,200,8,11]
[null,null,85,"No","",{"$nulls":31},85,null,"R",85,160,31,64,49,128,null,400,16,14]
[null,null,90,"No","",{"$nulls":31},90,null,"S",90,170,33,68,52,136,null,600,48,22]
[null,null,95,"No","",{"$nulls":31},95,null,"T",95,180,35,72,55,144,null,800,80,25]
[null,null,100,"Yes",100,2,4,6,{"$nulls":21},10,{"$nulls":6},"( 100 )",null,"U",100,190,37,76,58,152,null,1000,100,27]
[null,null,200,"No","",1,2,3,4,5,6,{"$nulls":18},12,{"$nulls":6},200,null,"V",105,200,39,80,61,160]
[null,null,300,"No","",null,1,1,2,2,3,3,4,4,5,5,6,6,{"$nulls":11},16,{"$nulls":6},300,null,"W",110,210,41,84,64,168]
[null,null,400,"No","",null,1,1,2,2,3,3,4,4,5,5,6,6,{"$nulls":11},16,{"$nulls":6},400,null,"X",115,220,43,88,67,176]
[null,null,500,"No","",null,null,1,1,1,2,2,2,3,3,3,4,4,4,5,5,5,6,6,6,{"$nulls":4},24,{"$nulls":6},500,null,"Y",120,230,45,92,70,184]
[null,null,600,"No","",null,null,1,1,1,2,2,2,3,3,3,4,4,4,5,5,5,6,6,6,{"$nulls":4},24,{"$nulls":6},600,null,"Z",125,240,47,96,73,192]
[null,null,700,"No","",{"$nulls":3},1,1,1,1,2,2,2,2,3,3,3,3,4,4,4,4,5,5,6,6,6,28,{"$nulls":6},700]
[null,null,800,"No","",{"$nulls":3},1,1,1,1,2,2,2,2,3,3,3,3,4,4,4,4,5,5,6,6,6,28,{"$nulls":6},800,null,"JUMPTABLE",{"$nulls":9},"how many jumps",{"$f":"VLOOKUP(totalJumps,JUMPTABLE,2,1) & \" \" & VLOOKUP(totalJumps,JUMPTABLE,3,1)","v":{"$error":"#N/A"}}]
[null,null,900,"No","",{"$nulls":4},1,1,1,1,1,2,2,2,2,2,3,3,3,3,3,4,5,6,6,6,30,{"$nulls":6},900,null,1,"one",{"$f":"\"\"","v":""}]
[null,null,1000,"Yes",1000,{"$nulls":4},1,1,1,1,1,2,2,2,2,2,3,3,3,3,3,4,5,6,6,6,30,{"$nulls":6},"( 1000 )",null,2,"two","succesive"]
[null,null,2000,"No","",{"$nulls":8},1,1,1,1,1,1,1,1,1,1,1,2,2,3,4,6,32,{"$nulls":6},2000,null,3,"three","succesive"]
[null,null,3000,"No","",{"$nulls":14},1,1,1,1,1,1,1,2,2,4,34,{"$nulls":6},3000,null,4,"four","succesive"]
[null,null,4000,"No","",{"$nulls":19},1,1,1,2,3,35,{"$nulls":6},4000,null,5,"five","succesive"]
[null,null,5000,"No","",{"$nulls":20},1,1,1,2,36,{"$nulls":6},5000,null,6,"six","succesive"]
[null,null,"Total",null,{"$f":"SUM(E4:E37)","v":1100},{"$f":"INDEX(F4:F37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(G4:G37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(H4:H37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(I4:I37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(J4:J37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(K4:K37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(L4:L37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(M4:M37,MATCH(TRUE,C4:C37>=E38,0))","v":0},{"$f":"INDEX(N4:N37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(O4:O37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(P4:P37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(Q4:Q37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(R4:R37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(S4:S37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(T4:T37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(U4:U37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(V4:V37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(W4:W37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(X4:X37,MATCH(TRUE,C4:C37>=E38,0))","v":1},{"$f":"INDEX(Y4:Y37,MATCH(TRUE,C4:C37>=E38,0))","v":2},{"$f":"INDEX(Z4:Z37,MATCH(TRUE,C4:C37>=E38,0))","v":2},{"$f":"INDEX(AA4:AA37,MATCH(TRUE,C4:C37>=E38,0))","v":3},{"$f":"INDEX(AB4:AB37,MATCH(TRUE,C4:C37>=E38,0))","v":4},{"$f":"INDEX(AC4:AC37,MATCH(TRUE,C4:C37>=E38,0))","v":6},{"$f":"INDEX(AD4:AD37,MATCH(TRUE,C4:C37>=E38,0))","v":32},{"$nulls":8},7,"seven","succesive"]
[{"$nulls":38},8,"eight","succesive"]
[{"$nulls":38},9,"nine","succesive"]
[{"$nulls":38},10,"ten","succesive"]
[]
[]
[{"$nulls":39},"oneHundred",{"$nulls":3},"countSDT"]
[{"$nulls":39},0,"no",null,null,1,"single"]
[{"$nulls":39},{"$f":"AN45+1","v":1},"one",null,null,2,"dual"]
[{"$nulls":39},{"$f":"AN46+1","v":2},"two",null,null,3,"triple"]
[{"$nulls":39},3,"three"]
[{"$nulls":39},4,"four"]
[{"$nulls":39},5,"five"]
[{"$nulls":39},6,"six"]
[{"$nulls":39},7,"seven"]
[{"$nulls":39},8,"eight"]
[{"$nulls":39},9,"nine"]
[{"$nulls":39},10,"ten"]
[{"$nulls":39},11,"eleven"]
[{"$nulls":39},12,"twelve"]
[{"$nulls":39},13,"thirteen"]
[{"$nulls":39},14,"fourteen"]
[{"$nulls":39},15,"fifteen"]
[{"$nulls":39},16,"sixteen"]
[{"$nulls":39},17,"seventeen"]
[{"$nulls":39},18,"eighteen"]
[{"$nulls":39},19,"nineteen"]
[{"$nulls":39},20,"twenty"]
[{"$nulls":39},21,"twenty-one"]
[{"$nulls":39},22,"twenty-two"]
[{"$nulls":39},23,"twenty-three"]
[{"$nulls":39},24,"twenty-four"]
[{"$nulls":39},25,"twenty-five"]
[{"$nulls":39},26,"twenty-six"]
[{"$nulls":39},27,"twenty-seven"]
[{"$nulls":39},28,"twenty-eight"]
[{"$nulls":39},29,"twenty-nine"]
[{"$nulls":39},30,"thirty"]
[{"$nulls":39},31,"thirty-one"]
[{"$nulls":39},32,"thirty-two"]
[{"$nulls":39},33,"thirty-three"]
[{"$nulls":39},34,"thirty-four"]
[{"$nulls":39},35,"thirty-five"]
[{"$nulls":39},36,"thirty-six"]
[{"$nulls":39},37,"thirty-seven"]
[{"$nulls":39},38,"thirty-eight"]
[{"$nulls":39},39,"thirty-nine"]
[{"$nulls":39},40,"forty"]
[{"$nulls":39},41,"forty-one"]
[{"$nulls":39},42,"forty-two"]
[{"$nulls":39},43,"forty-three"]
[{"$nulls":39},44,"forty-four"]
[{"$nulls":39},45,"forty-five"]
[{"$nulls":39},46,"forty-six"]
[{"$nulls":39},47,"forty-seven"]
[{"$nulls":39},48,"forty-eight"]
[{"$nulls":39},49,"forty-nine"]
[{"$nulls":39},50,"fifty"]
[{"$nulls":39},51,"fifty-one"]
[{"$nulls":39},52,"fifty-two"]
[{"$nulls":39},53,"fifty-three"]
[{"$nulls":39},54,"fifty-four"]
[{"$nulls":39},55,"fifty-five"]
[{"$nulls":39},56,"fifty-six"]
[{"$nulls":39},57,"fifty-seven"]
[{"$nulls":39},58,"fifty-eight"]
[{"$nulls":39},59,"fifty-nine"]
[{"$nulls":39},60,"sixty"]
[{"$nulls":39},61,"sixty-one"]
[{"$nulls":39},62,"sixty-two"]
[{"$nulls":39},63,"sixty-three"]
[{"$nulls":39},64,"sixty-four"]
[{"$nulls":39},65,"sixty-five"]
[{"$nulls":39},{"$f":"AN110+1","v":66},"sixty-six"]
[{"$nulls":39},67,"sixty-seven"]
[{"$nulls":39},68,"sixty-eight"]
[{"$nulls":39},69,"sixty-nine"]
[{"$nulls":39},70,"seventy"]
[{"$nulls":39},71,"seventy-one"]
[{"$nulls":39},72,"seventy-two"]
[{"$nulls":39},73,"seventy-three"]
[{"$nulls":39},74,"seventy-four"]
[{"$nulls":39},75,"seventy-five"]
[{"$nulls":39},76,"seventy-six"]
[{"$nulls":39},77,"seventy-seven"]
[{"$nulls":39},78,"seventy-eight"]
[{"$nulls":39},79,"seventy-nine"]
[{"$nulls":39},80,"eighty"]
[{"$nulls":39},81,"eighty-one"]
[{"$nulls":39},82,"eighty-two"]
[{"$nulls":39},83,"eighty-three"]
[{"$nulls":39},84,"eighty-four"]
[{"$nulls":39},85,"eighty-five"]
[{"$nulls":39},86,"eighty-six"]
[{"$nulls":39},87,"eighty-seven"]
[{"$nulls":39},88,"eighty-eight"]
[{"$nulls":39},89,"eighty-nine"]
[{"$nulls":39},90,"ninety"]
[{"$nulls":39},91,"ninety-one"]
[{"$nulls":39},92,"ninety-two"]
[{"$nulls":39},93,"ninety-three"]
[{"$nulls":39},94,"ninety-four"]
[{"$nulls":39},95,"ninety-five"]
[{"$nulls":39},96,"ninety-six"]
[{"$nulls":39},97,"ninety-seven"]
[{"$nulls":39},98,"ninety-eight"]
[{"$nulls":39},99,"ninety-nine"]
[{"$nulls":39},100,"one-hundred"]