Need LV MASS formula
 

New dude in town and don't know how to create the following complex (at least
to me) formula to calculate LV MASS in excel . . .

lv mass = 1.05 x {(b+t)^[2/3 (a+1) + d ~ d3 / 3(a+t)^] - b^[2/3 a+d ~ d3 /
3a^]}

note that d3 is d cubed

any assistance is most helpful ... under pressure to solve this ASAP

Someone pls show me the way . . .

SF

Need LV MASS formula
 

To put this into Excel, you need to tell us:
-- What do the tildes (~) mean?
-- Does ^ mean "to the power of" (and if so, why not use it for d^3)?
-- What does ^ mean when it's at then end of a calculation (as in the two
^]s)
-- Where are the variables b, t, a, d and b? Cells a1 to a5 or somewhere
else?

Regards,
Fred.

"SilverFox" <u49417@uwe wrote in message news:916295aa72615@uwe...
New dude in town and don't know how to create the following complex (at
least
to me) formula to calculate LV MASS in excel . . .

lv mass = 1.05 x {(b+t)^[2/3 (a+1) + d ~ d3 / 3(a+t)^] - b^[2/3 a+d ~ d3 /
3a^]}

note that d3 is d cubed

any assistance is most helpful ... under pressure to solve this ASAP

Someone pls show me the way . . .

SF

Need LV MASS formula
 

Thanks for taking an interest in my dilema Fred ...
This is a two part problem where my associate is working on the first formula
... thos results then feed into mine . . .
can you contact me via my email then I can show
you the actual formula as I cannot (or do not know how to) send attachment
image on this board
thnks much lad



Fred Smith wrote:
To put this into Excel, you need to tell us:
-- What do the tildes (~) mean?
-- Does ^ mean "to the power of" (and if so, why not use it for d^3)?
-- What does ^ mean when it's at then end of a calculation (as in the two
^]s)
-- Where are the variables b, t, a, d and b? Cells a1 to a5 or somewhere
else?

Regards,
Fred.

New dude in town and don't know how to create the following complex (at
least
[quoted text clipped - 10 lines]

SF

Need LV MASS formula
 

OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it

SF

Need LV MASS formula
 

SilverFox wrote:
OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it
CHECK OUT MY PHOTO GALLERY <<<<<<

SF

Need LV MASS formula
 

On Sun, 08 Feb 2009 07:38:18 GMT, "SilverFox" <u49417@uwe wrote:

SilverFox wrote:
OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it
CHECK OUT MY PHOTO GALLERY <<<<<<

SF

For anyone to do that, you'd have to post a link
--ron

Need LV MASS formula
 

Ron: not sure what you mean or how I post a link ... I created a file
"LVMASS" in photo gallery ... can't anyone see it? I see plenty of other
images there

SF

Ron Rosenfeld wrote:
OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it
CHECK OUT MY PHOTO GALLERY <<<<<<

SF

For anyone to do that, you'd have to post a link
--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1

Need LV MASS formula
 

No, we can't see it. Do you really want other people to have access to your
computer? Didn't think so. That's why Windows won't allow it.

You post a link by copying the address from Internet Explorer. You first
store the image in publicly available sites like Facebook, Flickr, Google,
etc.

If you are really desperate, and don't want to broaden your horizons, e-mail
the file to:
fred dot smith at shaw dot ca.

I'll take a look at it.

Regards,
Fred.

"SilverFox via OfficeKB.com" <u49417@uwe wrote in message
news:916c733127fc2@uwe...
Ron: not sure what you mean or how I post a link ... I created a file
"LVMASS" in photo gallery ... can't anyone see it? I see plenty of other
images there

SF

Ron Rosenfeld wrote:
OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it

CHECK OUT MY PHOTO GALLERY <<<<<<

SF

For anyone to do that, you'd have to post a link
--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1

Need LV MASS formula
 

On Mon, 09 Feb 2009 00:26:08 GMT, "SilverFox via OfficeKB.com" <u49417@uwe
wrote:

Ron: not sure what you mean or how I post a link ... I created a file
"LVMASS" in photo gallery ... can't anyone see it? I see plenty of other
images there

Where is photo gallery?

There are probably millions of photo galleries on the Internet. If you don't
tell me the address of yours, there's no way for me to find it.

--ron

Need LV MASS formula
 

Hi Moe,

Hopefully, this formula is what you want:
=1.05*((B1+T1)^2*(2/3*(A1+1)+D1-(D1^3/(3*(A1+T1)^2)))-B1^2*(2/3*A1+D1-(D1^3/(3*A1^2))))

To keep the formula consistent, I assumed the value of a is in A1, b in B1,
c in C1, d in D1 and t in T1. You can adjust these to suit your setup.

Here's some useful information to allow you to translate other formulas into
computerese:
1. Division is always done with the / key (as in 2/3)
2. Subtraction is the - key, not ~.
3. ^ is exponentiation ("to the power of")
4. There is no implied multiplication. You must always use the
multiplication symbol *, as in 2*a, not 2a.

Hope this helps,
Fred.

"Fred Smith" wrote in message
...
No, we can't see it. Do you really want other people to have access to
your computer? Didn't think so. That's why Windows won't allow it.

You post a link by copying the address from Internet Explorer. You first
store the image in publicly available sites like Facebook, Flickr, Google,
etc.

If you are really desperate, and don't want to broaden your horizons,
e-mail the file to:
fred dot smith at shaw dot ca.

I'll take a look at it.

Regards,
Fred.

"SilverFox via OfficeKB.com" <u49417@uwe wrote in message
news:916c733127fc2@uwe...
Ron: not sure what you mean or how I post a link ... I created a file
"LVMASS" in photo gallery ... can't anyone see it? I see plenty of other
images there

SF

Ron Rosenfeld wrote:
OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it

CHECK OUT MY PHOTO GALLERY <<<<<<

SF

For anyone to do that, you'd have to post a link
--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1

Need LV MASS formula
 

Hello Fred! Thank you so very much for your quick assistance. Totally
speechless with your willingness to help us out ...
just after I printed the formula my hard drive froze and it took over eight
hours to unlock it ... was more worried in getting my thanks across to you ...


Spent the day loading spreadsheets with data and calculations will be
generated shortly . . .
once again, KUDOS to you for sharing your knowledge and not berating us on
our lack of same.

Moe & Francisco

Fred Smith wrote:
Hi Moe,

Hopefully, this formula is what you want:
=1.05*((B1+T1)^2*(2/3*(A1+1)+D1-(D1^3/(3*(A1+T1)^2)))-B1^2*(2/3*A1+D1-(D1^3/(3*A1^2))))

To keep the formula consistent, I assumed the value of a is in A1, b in B1,
c in C1, d in D1 and t in T1. You can adjust these to suit your setup.

Here's some useful information to allow you to translate other formulas into
computerese:
1. Division is always done with the / key (as in 2/3)
2. Subtraction is the - key, not ~.
3. ^ is exponentiation ("to the power of")
4. There is no implied multiplication. You must always use the
multiplication symbol *, as in 2*a, not 2a.

Hope this helps,
Fred.

No, we can't see it. Do you really want other people to have access to
your computer? Didn't think so. That's why Windows won't allow it.
[quoted text clipped - 27 lines]
For anyone to do that, you'd have to post a link
--ron

--
Message posted via http://www.officekb.com

Need LV MASS formula
 

No problem. Glad I could help out. Thanks for the feedback. BTW, my
condolences on your hard drive. I hope it recovered OK.

Fred,

"SilverFox via OfficeKB.com" <u49417@uwe wrote in message
news:917a0341c51b2@uwe...
Hello Fred! Thank you so very much for your quick assistance. Totally
speechless with your willingness to help us out ...
just after I printed the formula my hard drive froze and it took over
eight
hours to unlock it ... was more worried in getting my thanks across to you
...


Spent the day loading spreadsheets with data and calculations will be
generated shortly . . .
once again, KUDOS to you for sharing your knowledge and not berating us on
our lack of same.

Moe & Francisco

Fred Smith wrote:
Hi Moe,

Hopefully, this formula is what you want:
=1.05*((B1+T1)^2*(2/3*(A1+1)+D1-(D1^3/(3*(A1+T1)^2)))-B1^2*(2/3*A1+D1-(D1^3/(3*A1^2))))

To keep the formula consistent, I assumed the value of a is in A1, b in
B1,
c in C1, d in D1 and t in T1. You can adjust these to suit your setup.

Here's some useful information to allow you to translate other formulas
into
computerese:
1. Division is always done with the / key (as in 2/3)
2. Subtraction is the - key, not ~.
3. ^ is exponentiation ("to the power of")
4. There is no implied multiplication. You must always use the
multiplication symbol *, as in 2*a, not 2a.

Hope this helps,
Fred.

No, we can't see it. Do you really want other people to have access to
your computer? Didn't think so. That's why Windows won't allow it.
[quoted text clipped - 27 lines]
For anyone to do that, you'd have to post a link
--ron

--
Message posted via http://www.officekb.com

Need LV MASS formula
 

Fred ... I want to thank you again for extending your time and knowledge ...
**«:::A:::» «:::W:::» «:::E:::» «:::S:::» «:::O:::» «:::M:::» «:::E:::»**
results; unfortunately my PC got fried and finally had to trash it ... using
a loaner for now but I just can't thank you enough.
with respect and admiration
Moe

Fred Smith wrote:
No problem. Glad I could help out. Thanks for the feedback. BTW, my
condolences on your hard drive. I hope it recovered OK.

Fred,

Hello Fred! Thank you so very much for your quick assistance. Totally
speechless with your willingness to help us out ...
[quoted text clipped - 36 lines]
For anyone to do that, you'd have to post a link
--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1