Help with math problem on Openoffice Calc

[Brad]

Hello

I’m having problems making my own e-skate spreadsheet.

As you can see, I’m working on this middle equation about power required to go up an incline.

Now, I can get the correct answer via my iPad calculator as seen below which would round up to 502 watts. See my calculations in the history box at the bottom left…

For some reason I just cannot get the damn equation to work in Openoffice Calc (Excel) as you can see below. 1km/h is 0.277778 meters a second, so I multiply by speed.

Have not done any math for ages now and am just about to give up after trying to fix this for about an hour. Google was great to find SIN and Power functions, but still…

Any pointers?

[lock]

Fairly sure the sin function is expecting radians. Try replacing sin(n4) with sin(radians(n4)).

[Brad]

@lock

sin(radians(n4))

Well, shit. That did it. Was sure it was something so simple. It off by 0.5 but that is close enough for me.

Thanks, really enjoying learning how to do Excel.

[Brad]

Having trouble finding cube 3. I’m sure Openoffice Calc does not have that feature.

I read somewhere that cube 3 is the same as 1^1/3, but when I use that, I get an entirely different number.

EDIT: Never mind, managed to find the solution here. Solution was =POWER((K3/(0.51.2251*0.9));1/3)*3.6 to calculate km/h speed for equation at the top of quick analysis image

Forum bugged out “*” in some places…

[faithfulpuppy]

use 1^(1/3)

[oyta]

a^(1/3) = cuberoot( a )