Where are the add-ins in Office 2008?
Alexander Malov
in Excel (Tools > Add-ins). I rely on the statistical add-in quite a
bit for school work. I wasn't prompted for anything during the
installation. Thanks.
John
"Alexander Malov" <alx...@gmail.com> wrote in message
news:bbe16334-e3df-44d3...@k39g2000hsf.googlegroups.com...
Addins are AWOL. Once again Microsoft has succeded in actually charging
people money for a downgrade!
John McGhie
Office 2008 does not have an Analysis Toolpack. You have to use the
built-in functions.
The Analysis toolpack relied on VBA, so it can't operate in Office 2008.
The functions have been moved into Excel as native functions in this
release.
Cheers
On 17/01/08 8:05 AM, in article
bbe16334-e3df-44d3...@k39g2000hsf.googlegroups.com,
"Alexander Malov" <alx...@gmail.com> wrote:
--
Don't wait for your answer, click here: http://www.word.mvps.org/
Please reply in the group. Please do NOT email me unless I ask you to.
John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:jo...@mcghie.name
JE McGimpsey
> Just wondering if it's just Excel? Do Powerpoint or Word add-ins work?
No add-ins which are written in VBA, or rely on the VBA functionality
that's been taken out of Office 2008 will work.
I don't know of any Word or PPT add-ins that will work with Office 08.
JE McGimpsey
"John" <nos...@nospam.com> wrote:
> "John McGhie" <jo...@mcghie.name> wrote in message
> news:C3B57F99.DF1A%jo...@mcghie.name...
> > Hi Alexander:
> >
> > Office 2008 does not have an Analysis Toolpack. You have to use the
> > built-in functions.
> >
> > The Analysis toolpack relied on VBA, so it can't operate in Office 2008.
> > The functions have been moved into Excel as native functions in this
> > release.
>
>
> Not all of them have. The vast majority are AWOL.
Which functions are missing?
Unknown
"Our resident Excel Expert, JE McGimpsey has challenged people to identify an analysis you can't do with the built-in functions in E2008 "
then how does one implement a multivariate regression in Excel? For example, projected home value based on neighborhood, square footage, property taxes, bedrooms, bathrooms, pool, etc.
JE McGimpsey
wrote:
> Given -- <br>
> "Our resident Excel Expert, JE McGimpsey has challenged people to identify an
> analysis you can't do with the built-in functions in E2008 " <br><br>then how
> does one implement a multivariate regression in Excel? For example, projected
> home value based on neighborhood, square footage, property taxes, bedrooms,
> bathrooms, pool, etc.
Stumped -
It's been a long while since I did a multivariate regression, but IIRC,
the ATP just does a linear regression using the standard matrix method
found in any statistics textbook, which would find the coefficients
something like:
= MMULT(MINVERSE(MMULT(TRANSPOSE(X),X)),MMULT(TRANSPOSE(X),Y))
array entered into a column with the same number of rows that X has
columns, where
X = columns of independent variables
Y = column of knowns
JE McGimpsey
JE McGimpsey <jemcg...@mvps.org> wrote:
> Stumped -
>
> It's been a long while since I did a multivariate regression, but IIRC,
> the ATP just does a linear regression using the standard matrix method
> found in any statistics textbook, which would find the coefficients
> something like:
>
> = MMULT(MINVERSE(MMULT(TRANSPOSE(X),X)),MMULT(TRANSPOSE(X),Y))
>
> array entered into a column with the same number of rows that X has
> columns, where
>
> X = columns of independent variables
> Y = column of knowns
One note: to get the intercept, one column in X needs to be all 1's
Unknown
CyberTaz
*improvement* - just that that's how it is:-) Nobody here has any control
over MS decision making & the loss of VBA has been a devastating blow to
many of those who regularly participate in this group - people who rely on
Excel to make their living.
If you're genuinely concerned you might try using the Help> Send Feedback to
submit a convincing argument to MS on the issue. All we can do here is offer
support on what the software *does* have to offer.
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 1/29/08 10:34 PM, in article ee88e...@webcrossing.caR9absDaxw, "nick
John McGhie
1) Never
2) No
If you do not like those answers, you should use "Send Feedback" from the
Help menu to tell Microsoft what you want it for, and why AppleScript won't
do what you want.
Microsoft announced that VBA was being removed from Office 2007 for the PC
also. After a large amount of customer pressure, they changed their minds.
This would be possible in Mac Office too. Any decision can be changed.
But the price tag of changing this particular decision is a few million
dollars. Can you help us demonstrate to Microsoft that it will make a few
million dollars extra profit if it changes its mind on this?
Because that's the key to it. Remember, the designers and coders working at
Microsoft Macintosh Business Unit do what they are told. Microsoft has this
magic "Do what you're told or get fired" incentive policy common in a lot of
large companies around the globe :-)
And that applies to everyone, up to and including Steve Ballmer/Bill Gates.
The people doing the "telling" are the Board of Directors. Basically: your
pension fund and mine.
How are you going to convince your pension fund to ask Microsoft to change
its decision on VBA? It can be done. It has been done: in Office 2007.
How are we going to do this on the Mac?
Hope this helps
On 6/3/08 1:55 PM, in article ee88e...@webcrossing.caR9absDaxw, "Concern"
<Concern> wrote:
> When will the VBA in office 2008 become and update or plug in? Is this
> something that they will correct.
--
Don't wait for your answer, click here: http://www.word.mvps.org/
Please reply in the group. Please do NOT email me unless I ask you to.
John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50