Skip to content
Aussieveedubbers

long shot- excel guru\'s

0 likes
Share Share on Facebook Share on X Share on Reddit
Log in to reply

BiX Veteran Volks Folk

2,499 posts · joined Sep 2002 ·

#139843
Ok iam trying to get a spreadsheet developed for work ( use it for extra credit for post grad work at uni😀).

I have to get out r ^(2/3) (ie r to the 2/3rds power) out of an equation (eg reverse it out). Now i have the function of xroot of a number on my calculator but can't find the same function in excel. any ideas?

wes u developed some good spreadsheets, any ideas?

Brad Wolfsburg Elder

3,764 posts · joined Aug 2002 ·

#139844
YOu need to talk to WES ... he is an Excell Guru ....
Brad
Why copy when you can own an original ?
Meyers Manx Australia

BiX Veteran Volks Folk

2,499 posts · joined Sep 2002 ·

#139848
andrew thats what iam trying to reverse

the equation is (mannings equation)

Qy= (1/n) * (r^(2/3)) * (Se^(1/2))

I have Qy, n, Se but need to find r,

so r^2/3=Qy/(1/n)/Se^(1/2)

nor need to get rid of the 2/3 power to find r by itself


Iam sick of doing 3 pages of calcs to find the required channel size for a discharge point of a catchment then having to do it over again when when one of the planners wants to change the layout of the site!!!!
so developing a spread sheet to make it easier and mabye the scientist can use it to.

modulus Veteran Volks Folk

2,009 posts · joined Jul 2003 ·

#139852
r^(2/3) = x
therefore
x = r^(3/2)

hth
Peter Hill
1975 Type 2 Double Cab
modulus.com.au

vanderaj Administrator a suffusion of yellow

3,130 posts · joined Aug 2002 ·

#139863
Don't you mean

x = r^(2/3)
r = x^(3/2)

?

Andrew

modulus Veteran Volks Folk

2,009 posts · joined Jul 2003 ·

#139864
^^^ What he said...
Yes, that's what i meant.
Peter Hill
1975 Type 2 Double Cab
modulus.com.au

BiX Veteran Volks Folk

2,499 posts · joined Sep 2002 ·

#139880
😀😀😀😀😀😀😀:thumb:thumb:thumb:thumb:thumb:thumb:thumb


thanks guys should have thought about the math way not the write formula for excel.

vw54 Administrator Always Waiting 4 Friday

16,723 posts · joined Aug 2002 ·

#139926
Hey LETS try n keep Excel simple...

I know how to do most things but lets keep it simple please

Now access is a different matter
I read it on FACEBOOK so it must be true


http://forums.aussieveedubbers.com/viewtopic.php?tid=91278&page=1#pid848630


http://forums.aussieveedubbers.com/viewtopic.php?tid=63561&page=1#pid624099


http://forums.aussieveedubbers.com/viewtopic.php?tid=4832&page=1#pid452603


http://forums.aussieveedubbers.com/viewtopic.php?tid=60650&page=1#pid574409

Baja Wes V6 Baja Pioneer

3,119 posts · joined Aug 2002 ·

#140249
I didn't reply to this yesterday as I was out riding my motorbike on a ride day for 10.5 hours. I'm a bit sore now.

Yes I could've helped, and yes I'm pretty familiar with Excel.
Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... 🙂
www.taylorcycles.com.au - My DH MTB racing brothers shop.