Prev: Re: Vector Movement (PBeM Excel sheet formulas) Next: Re: Comet Miniatures

Re: Vector Movement (PBeM Excel sheet formulas)

From: Brian Bell <brian.bell@a...>
Date: Wed, 25 Mar 1998 23:47:08 +0000
Subject: Re: Vector Movement (PBeM Excel sheet formulas)

Here is a representation of an Excell spreadsheet I made for vector
movement, I do not know if it works or not (yet). If someone spots an
error, please let me know.

A    Start X
B    Start Y
C    Start Angle
D    Start Velocity
E    Push -P/+S     If push P/S before turn
F    Push -A	    If push aft
G    Turn -P/+S     If turn before thrust
H    Push -P/+S     If push P/S after turn & before thrust
I    Push -A	    If push aft after turn & before thrust
J    Thrust
K    Push -P/+S     If push P/S after thrust
L    Push -A	    If push aft after thrust
M    Turn -P/+S     If turn after thrust
N   Push -P/+S	    If push P/S after thrust and turn
O    Push -A	    If push aft after thrust and turn
P    End X    =(A:A + (E:E * SIN(90)) + (F:F * SIN(360)) + (H:H *
SIN(90+(G:G*30))) + (I:I * SIN(360+(G:G*30))) + (D:D * SIN(C:C*30) +J:J
* SIN(G:G*30)) + (K:K * SIN(90+(M:M*30))) + (L:L * SIN(360+(M:M*30))) +
(N:N * SIN(90+(M:M*30))) + (O:O * SIN(360+(M:M*30))))
Q    End Y     =(B:B + (E:E * COS(90)) + (F:F * COS(360)) + (H:H *
COS(90+(G:G*30))) + (I:I * COS(360+(G:G*30))) + (D:D * COS(C:C*30) +J:J
* COS(G:G*30)) + (K:K * COS(90+(M:M*30))) + (L:L * COS(360+(M:M*30))) +
(N:N * COS(90+(M:M*30))) + (O:O * COS(360+(M:M*30))))
R    End Angle	   =(SQRT( (P:P -A:A )^2 + (Q:Q -B:B )^2 ))/30
S    End Velocity    =ATAN( (P:P -A:A ) / (Q:Q -B:B ) )

I have placed the file on my web site (no direct link from any page) at:

http://www.axom.com/bkb/ftvt.xls

--
Brian Bell
brian.bell@axom.com

The Full Thrust Ship Registry
http://www.axom.com/bkb/fthome.html
Dirtside II Site
http://www.axom.com/bkb/ds2main.html
Stargrunt II Site
http://www.axom.com/bkb/sg2.html
Cygnus Eclipsers' Science Fiction Games Page
http://www.axom.com/bkb/scifi_game.html

Prev: Re: Vector Movement (PBeM Excel sheet formulas) Next: Re: Comet Miniatures