PDA

View Full Version : Solved: Analysis Toolpak



philfer
12-29-2009, 01:26 PM
Hello,

What are the implications of installing the analysis toolpak add in in pre-2007 versions?

Does it make the file much bigger?

I appreciate that if the file uses analysis functions and is distributed I need to write a piece of code to check for the add in but besides that what are the implications?

Thanks
Phil

Bob Phillips
12-29-2009, 05:29 PM
The implications are ... you can use the ATP functions!

What ilke are you thinking about? It is its own file, so it doesn't make anything bigger.

philfer
01-05-2010, 05:09 AM
Hi,

Thanks for your answer. If that is the case why wouldnt MS have it already pre-installed as standard in Excel 2003. If there are no other implications besides being able to use more functions why wouldnt it be standard?

Cheers
Phil

mbarron
01-05-2010, 07:31 AM
There may be some memory overhead involved

The reason it isn't "standard" is because not everyone needs/wants the tool pack to be active.

How many "normal" user use any of these functions?


ACCRINT DEC2BIN HEX2OCT ISEVEN SERIESSUM
ACCRINTM DEC2HEX IMABS ISODD SQRTPI
BESSELI DEC2OCT IMAGINARY LCM TBILLEQ
BESSELJ DELTA IMARGUMENT MDURATION TBILLPRICE
BESSELK DISC IMCONJUGATE MROUND TBILLYIELD
BESSELY DOLLARDE IMCOS MULTINOMIAL WEEKNUM
BIN2DEC DOLLARFR IMDIV NETWORKDAYS WORKDAY
BIN2HEX DURATION IMEXP NOMINAL XIRR
BIN2OCT EDATE IMLN OCT2BIN XNPV
COMPLEX EFFECT IMLOG10 OCT2DEC YEARFRAC
CONVERT EOMONTH IMLOG2 OCT2HEX YIELD
COUPDAYBS ERF IMPOWER ODDFPRICE YIELDDISC
COUPDAYS ERFC IMPRODUCT ODDFYIELD YIELDMAT
COUPDAYSNC FACTDOUBLE IMREAL ODDLPRICE
COUPNCD FVSCHEDULE IMSIN ODDLYIELD
COUPNUM GCD IMSQRT PRICE
COUPPCD GESTEP IMSUB PRICEDISC
CUMIPMT HEX2BIN IMSUM PRICEMAT
CUMPRINC HEX2DEC INTRATE RECEIVED

Bob Phillips
01-05-2010, 12:41 PM
Hi,

Thanks for your answer. If that is the case why wouldnt MS have it already pre-installed as standard in Excel 2003. If there are no other implications besides being able to use more functions why wouldnt it be standard?

Because they hadn't done the work by then to integrate it. They only did that in 2007, and that is only for the function, it still needs installing for the other bits.