| [ Total Views: 1127 | Total Replies: 7 | Thread Id: 19013 ] |
|
|
 BiX
Veteran Volks Folk
Posts: 2499
Threads: 154
Registered: September 2nd, 2002
Member Is Offline
Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
|
| posted on February 15th, 2004 at 02:16 PM |
|
|
long shot- excel guru's
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
Posts: 3764
Threads: 332
Registered: August 24th, 2002
Member Is Offline
Location: SE QLD, Mt Nebo
Theme: UltimaBB Pro Blue ( Default )
Mood: Manx Buggy Building
|
| posted on February 15th, 2004 at 02:21 PM |
|
|
mmm
YOu need to talk to WES ... he is an Excell Guru ....
|
|
|
 vanderaj
A.k.a.: Andrew van der Stock
Super Administrator
a suffusion of yellow
Posts: 3122
Threads: 437
Registered: August 26th, 2002
Member Is Offline
Location: Colorado Springs, CO, USA
Theme: UltimaBB Pro Yellow
Mood: In the family again
|
| posted on February 15th, 2004 at 02:24 PM |
|
|
y = r ^ ( 2/3 )
y = exp(2/3* ln(r))
That might help if you can reverse that. The mathematica pages for roots are very pretty:
Square root:
http://mathworld.wolfram.com/SquareRoot.html
Inverse functions:
http://mathworld.wolfram.com/InverseFunction.html
Andrew
|
|
|
BiX
Veteran Volks Folk
Posts: 2499
Threads: 154
Registered: September 2nd, 2002
Member Is Offline
Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
|
| posted on February 15th, 2004 at 02:32 PM |
|
|
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
A.k.a.: Peter Hill
Veteran Volks Folk
Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline
Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular
|
| posted on February 15th, 2004 at 02:37 PM |
|
|
r^(2/3) = x
therefore
x = r^(3/2)
hth
|
|
|
vanderaj
A.k.a.: Andrew van der Stock
Super Administrator
a suffusion of yellow
Posts: 3122
Threads: 437
Registered: August 26th, 2002
Member Is Offline
Location: Colorado Springs, CO, USA
Theme: UltimaBB Pro Yellow
Mood: In the family again
|
| posted on February 15th, 2004 at 03:12 PM |
|
|
Don't you mean
x = r^(2/3)
r = x^(3/2)
?
Andrew
|
|
|
modulus
A.k.a.: Peter Hill
Veteran Volks Folk
Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline
Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular
|
| posted on February 15th, 2004 at 03:16 PM |
|
|
^^^ What he said...
Yes, that's what i meant.
|
|
|
BiX
Veteran Volks Folk
Posts: 2499
Threads: 154
Registered: September 2nd, 2002
Member Is Offline
Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
|
| posted on February 15th, 2004 at 03:53 PM |
|
|
:thumb:thumb:thumb:thumb:thumb:thumb:thumb
thanks guys should have thought about the math way not the write formula for excel. |
|
|
vw54
Super Administrator
Always Waiting 4 Friday
Posts: 16723
Threads: 378
Registered: August 26th, 2002
Member Is Offline
Location: Sunny Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Oval resto ongoing
|
| posted on February 15th, 2004 at 05:46 PM |
|
|
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
|
|
|
Baja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline
Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content
|
| posted on February 16th, 2004 at 08:37 AM |
|
|
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.
|
|
|
