CE En 270 - Homework #6

Vector Spreadsheet

Write a spreadsheet that does vector computations.  The user should be able to enter the i, j, k components of two vectors, v1 and v2.  Compute the vector difference, vector sum, dot product, and cross product of the two vectors.  Also compute the angle (in degrees) between the two vectors.  In case you have forgotten, suppose

 v₁ = a₁i + b₁j + c₁k
 v₂ = a₂i + b₂j + c₂k

then

 v₁ - v₂ = (a₁ - a₂)i + (b₁ - b₂)j + (c₁ - c₂)k
 v₁ + v₂ = (a₁ + a₂)i + (b₁ + b₂)j + (c₁ + c₂)k
 v₁ • v₂ = a₁a₂ + b₁b₂ + c₁c₂
 v₁ X v₂ = (b₁c₂ - b₂c₁)i + (a₂c₁ - a₁c₂)j + (a₁b₂ - a₂b₁)k
 angle between = cos^-1((v₁•v₂)/(|v₁| |v₂|))
 |v₁| = (a₁² + b₁² + c₁²)^1/2

You may want to use simple orthogonal unit vectors to test your spreadsheet.

Turn in a copy of your spreadsheet showing the results with the following vectors as input:

 v₁ = (1, -2, -2)
 v₂ = (-1, 3, -2)

Submittal Instructions:

Click here to upload your homework assignment.