Spreadsheet problem with entering complex equations
Any advice on how to enter longish equation into spreadsheet. It seems to freeze the spreadsheet or get syntax errors that don't seem to be there ?
For instance, I wish to calculate speed to throw a basketball ..given the angle...distance to basket and height to basket. The equation for this speed from SUVAT equations comes down to:-
speed = sqrt((4.9d^2)/((d * tan(theta] - h) cos^2(theta)))
theta is angle ... can vary from say 30 to 80 degrees. I realise you need a little o above angle when using trig functions.
d is horizontal distance to basket = 3
h is height to basket = 1
I just cannot enter this equation into geogebra spreadsheet without above errors occurring...sometimes when trying to re-edit equation you get a pop-up and sometimes not. Sometimes it comes back with an = ... in the box, like it is now not being treated as an equation.
I can do this fairly easily in google docs ... any advice welcome. ?