mike wightman
SOC-14 10K
It really is much easier to use the High Guard formulae instead IMHO.
Starship Armor
- Thread starter lightsenshi
- Start date
shadowdragon
SOC-12
i just compressed it into one formula i think, if i read the HG formula listed above correctly.
another way that is calculator, or spreadsheet friendly would be:
((Hull size*.01)+((Hull size*.01)*desired AR))* TL modifier= dTons
((Hull size*.01)+((Hull size*.01)*desired AR))=AR units
so the only lookup would be the TL modifier, which is easy to memorize
another way that is calculator, or spreadsheet friendly would be:
((Hull size*.01)+((Hull size*.01)*desired AR))* TL modifier= dTons
((Hull size*.01)+((Hull size*.01)*desired AR))=AR units
so the only lookup would be the TL modifier, which is easy to memorize
princelian
SOC-12
Or you define a variable (TL) and a lookup string or table, depending on how savvy an Excel builder you are for the TL modifier.
For Excel:
Cell A1 = TL
Cell A2 = TL mod
Cell A3 = hull size
Cell A4 = desired AR
Cell A5 = dTons
Cell A6 = AR units
Put TL in A1.
Put the following string in A2:
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;"> =if($A$1<=9,4,if($A$1<=11,3,if($A$1<=12,2,1)))</pre>[/QUOTE]Put hull size in A3.
Put desired AR in A4.
Put the following string in A5:
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;"> =($A$4+1)*$A$3*$A$2"</pre>[/QUOTE]Put the following string in A6:
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;"> =($A$4+1)*$A$3"</pre>[/QUOTE]You can rearrange your cell arrangement, but be sure to change your equations to match.
For Excel:
Cell A1 = TL
Cell A2 = TL mod
Cell A3 = hull size
Cell A4 = desired AR
Cell A5 = dTons
Cell A6 = AR units
Put TL in A1.
Put the following string in A2:
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;"> =if($A$1<=9,4,if($A$1<=11,3,if($A$1<=12,2,1)))</pre>[/QUOTE]Put hull size in A3.
Put desired AR in A4.
Put the following string in A5:
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;"> =($A$4+1)*$A$3*$A$2"</pre>[/QUOTE]Put the following string in A6:
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;"> =($A$4+1)*$A$3"</pre>[/QUOTE]You can rearrange your cell arrangement, but be sure to change your equations to match.
