Need LV MASS formula

[SilverFox]

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

 

[Fred Smith]

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]

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 (e-mail address removed) 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

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

 

[SilverFox]

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

 

[SilverFox]

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 <<<<<<

 

[Ron Rosenfeld]

CHECK OUT MY PHOTO GALLERY <<<<<<

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

 

[SilverFox via OfficeKB.com]

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

 

[Fred Smith]

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.

 

[Ron Rosenfeld]

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

 

[Fred Smith]

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.

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]

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

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]

 

[Fred Smith]

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 ...
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

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

 

[SilverFox via OfficeKB.com]

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

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]