This doesn't help because I will be using the sheet I create at multiple
locations and I can't install anything onto any other computer that isn't
mine. Any other suggestions?

"Carim" wrote:


Hi Fonz,

Have you had a chance to take a look at the excel add-in called
Analysis ToolPack ...?
It seems to me it is packed with a great deal of functions ...

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531166

It's part of Excel, it's on the same CD so anyone with a legal copy of
Excel/Office would also have the ATP
Regarding the formulas go here

http://groups.google.es/advanced_gro...=lang_en&hl=en

and search, there are plenty of math professor regulars who have answered
these type of questions many times, names to include in your search

Mike Middleton, Jerry W. Lewis, Dave Braden, Harlan Grove

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Fonz" wrote in message
...
This doesn't help because I will be using the sheet I create at multiple
locations and I can't install anything onto any other computer that isn't
mine. Any other suggestions?

"Carim" wrote:


Hi Fonz,

Have you had a chance to take a look at the excel add-in called
Analysis ToolPack ...?
It seems to me it is packed with a great deal of functions ...

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile:
http://www.excelforum.com/member.php...o&userid=33259
View this thread:
http://www.excelforum.com/showthread...hreadid=531166

In article ,
"Peo Sjoblom" wrote:

It's part of Excel, it's on the same CD so anyone with a legal copy of
Excel/Office would also have the ATP

But an awful lot of corporate users won't have the CD, either because
the company has a single site copy or because the CDs are sequestered
with the IT Dept. Often their IT Dept won't install ATP since it's not
on the approved configuration list. As far as they're concerned, it's
*not* part of XL.

That's true, but one would expect that if this is something that is to the
benefit of the company on might expect that necessary strings could be
pulled to facilitate this. Some companies I have worked with have had it
installed already (although you have to check it under toolsadd-ins) and
other have made it possible although I am sure there are companies that
won't budge

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"JE McGimpsey" wrote in message
...
In article ,
"Peo Sjoblom" wrote:

It's part of Excel, it's on the same CD so anyone with a legal copy of
Excel/Office would also have the ATP

But an awful lot of corporate users won't have the CD, either because
the company has a single site copy or because the CDs are sequestered
with the IT Dept. Often their IT Dept won't install ATP since it's not
on the approved configuration list. As far as they're concerned, it's
*not* part of XL.

In article ,
"Peo Sjoblom" wrote:

although I am sure there are companies that won't budge

Well, that includes most of my larger clients...<g

"JE McGimpsey" wrote in message
...
In article ,
"Peo Sjoblom" wrote:

It's part of Excel, it's on the same CD so anyone with a legal copy of
Excel/Office would also have the ATP

But an awful lot of corporate users won't have the CD, either because
the company has a single site copy or because the CDs are sequestered
with the IT Dept. Often their IT Dept won't install ATP since it's not
on the approved configuration list. As far as they're concerned, it's
*not* part of XL.

In my experience it is usually possible to include the Analysis ToolPak
without needing to use the installation CD. Just tick the relevant box
under Tools/ Add-Ins. This worked successfully under two iterations of my
company's installation, and at home.
--
David Biddulph

In article ,
"David Biddulph" wrote:

In my experience it is usually possible to include the Analysis ToolPak
without needing to use the installation CD. Just tick the relevant box
under Tools/ Add-Ins. This worked successfully under two iterations of my
company's installation, and at home.

That's because your company installed the ATP when they installed XL. If
that's the case, it will work, of course.

However, not all companies install add-ins when they install XL.

Contact me and I will give you some samples of the formulas. for things
like grouped data, you would be better off building a matrix of formulas
that calculate the parts of the formulas. That is why posting here wouldn't
be very easy to do.



Include your original post in your email.

--
Regards,
Tom Ogilvy

"Fonz" wrote in message
...
This doesn't help because I will be using the sheet I create at multiple
locations and I can't install anything onto any other computer that isn't
mine. Any other suggestions?

"Carim" wrote:


Hi Fonz,

Have you had a chance to take a look at the excel add-in called
Analysis ToolPack ...?
It seems to me it is packed with a great deal of functions ...

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile:
http://www.excelforum.com/member.php...o&userid=33259
View this thread:
http://www.excelforum.com/showthread...hreadid=531166