I used the same inputs in mathcad and excel considering the units , however I get different results in mathcad for Mi and f2 . Do you have any clue ?
Yeah you are totally right .
If you just tell me in general why I would get different results in excel and mathcad , I will figure it out myself
in mathcad sheet the calculation of Mi is on page 9
in excel the function is
all inputs are the same in both of sheets , still getting different results
As explained below I guess that the problem is the missing vectorization of expressions which use vectors.
You find it in on the Math ribbon in the "Operators" menu or you may use the appropriate keyboard shortcut (which depends on the language of your keyboard).
One thing which I noticed when I took a look into the Prime sheet.
Your calculation of Mi involves the multiplication of three vectors - alpha.t, q.blabla and z.
The mutliplication of the first two vectors is done as vector multiplication - that is scalar multiplication and the result is a scalar. Guess this is not what you intended. If you want the elements of the vectors to be multiplied one by one and a vector as result. you must apply vectorization!
Here is a simple example showing the difference:
Chances are that other calculations in your sheet may need vectorization as well.
