|
Related Topics:
| Analysis Toolpak - Excel 2008 - Hello, does anybody know how to replicate the XIRR formula from the Analysis Toolpak in Excel 2008 (given that the Toolpak itself seems to be Many thanks,
Problems with Excel Add-Ins (Data Analysis) - Hello, I'm trying to add the 'Data Analysis' add-in and I keep having I've Office X and applied patches. I click Add-ins' and select the Data analysis pack off the disk The 'Data Analysis' menu item never appears on..
Data Analysis add-in for excel office x - Does anyone know where to get the data analysis add-in for excel? It is there with the PC version but I can't find it with the mac version. I only have the add-in for Euro Currency Tool. I really need this and can't find it anywhere. thanks!!
can't add-in excel v.X data analysis toolpack - I have a student version of office v.X (as far as I know, it is the same as regular office but at student price). I need the ANOVA function but it isn't listed under Ins. The only add-in that shows up is a euro currency Does anyone..
Analysis Toolkit is shutting down Excel:mac 2004 - While in Excel the Data Analysis Tookit shuts down Excel:mac I have 2004 and it still does it. If you could possibly help me with my situation that would be great!!
|
|
|
Next: Excel: Solver in Excel 2008?
|
| Author |
Message |
External
Since: Feb 19, 2008
Posts: 1
|
(Msg. 16) Posted: Tue Feb 19, 2008 7:24 am
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
|
| I have avoided buying the upgrade for 2008, because the regression and solver were basic tools I have had to use. While I really would have liked the speed improvement, I need these functions. I thought this was a deficiency in iWork and thought Microsoft would not drop these. I am considering starting to use Gnumeric which even includes simulation analysis.
|
>> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 17) Posted: Tue Feb 19, 2008 10:46 am
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee88d6d.20.DeleteThis@webcrossing.caR9absDaxw>, "Shree Vattikuti" <>
wrote:
> I have avoided buying the upgrade for 2008, because the regression and solver
> were basic tools I have had to use. While I really would have liked the speed
> improvement, I need these functions. I thought this was a deficiency in iWork
> and thought Microsoft would not drop these. I am considering starting to use
> Gnumeric which even includes simulation analysis.
Gnumeric's an excellent package. No Pivot Tables or conditional
formatting, and charting isn't quite as good, but as long as you can
compile your own version, it's a good option.
If you like the improvements in Word, PPT and Entourage, you can always
run XL04 with the 08 versions of the others.
Regression in XL08 can be done at least as well (if not quite as
conveniently) with the tools here:
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
Solver's hopeless in 08 right now, but I'm hopeful that this can
eventually be solved by MacBU, though I don't have any specific reason
to think so. |
|
| Back to top |
|
| |
External
Since: Feb 25, 2008
Posts: 1
|
(Msg. 18) Posted: Mon Feb 25, 2008 11:29 am
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
PLease add my voice to the chorus of stunned mac users regarding the loss of Solver and data analysis tools. I am in an MBA program, where each are daily, vital tools.
If MS is trying to chase the Mac out of universities, this is a brilliant first step. >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 19) Posted: Mon Feb 25, 2008 2:44 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee88d6d.22.TakeThisOut@webcrossing.caR9absDaxw>, MW <> wrote:
> PLease add my voice to the chorus of stunned mac users regarding the loss of
> Solver and data analysis tools. I am in an MBA program, where each are daily,
> vital tools.
This isn't the place to add your voice. This is primarily a peer-to-peer
newsgroup.
Use Help/Send Feedback... instead
Note that the part of the Analysis Toolpak that didn't make it to XL08
was the wizards (e.g., the functions were incorporated into XL so no
add-in was needed). The wizards used XL functions (except the poorly
implemented Random Number Generator), so their results can be obtained
using those functions. See
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
for some pre-made workbooks. >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Feb 11, 2005
Posts: 566
|
(Msg. 20) Posted: Mon Feb 25, 2008 4:35 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 2/25/08 2:29 PM, in article ee88d6d.22 RemoveThis @webcrossing.caR9absDaxw, "MW" <MW>
wrote:
> PLease add my voice to the chorus of stunned mac users regarding the loss of
> Solver and data analysis tools. I am in an MBA program, where each are daily,
> vital tools.
>
> If MS is trying to chase the Mac out of universities, this is a brilliant
> first step.
They are not. Voice your concern via send feedback on the help menu.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Jan 15, 2008
Posts: 66
|
(Msg. 21) Posted: Mon Feb 25, 2008 4:54 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 22) Posted: Tue Feb 26, 2008 5:48 am
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee88d6d.25 DeleteThis @webcrossing.caR9absDaxw>, <> wrote:
> Did MS eliminate being able to calculate the forward and inverse Fourier
> transforms in 2008???
No, but they did eliminate VBA and therefore the ability to use the FFT
wizard in the Analysis Toolpak Add-in.
Since the wizards used XL functions (except for the poorly implemented
ATP random number generator), you can still calculate forward and
inverse Fourier transforms, but it means building tables and using the
now built-in matrix functions.
Probably too much of a PITA for most people, but it can be done, and
it's rather straight-forward, if tedious - there are examples you can
Google for... >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Nov 16, 2007
Posts: 283
|
(Msg. 23) Posted: Tue Feb 26, 2008 8:21 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Bob Greenblatt wrote:
> On 2/25/08 2:29 PM, in article ee88d6d.22.DeleteThis@webcrossing.caR9absDaxw, "MW" <MW>
> wrote:
>
>> PLease add my voice to the chorus of stunned mac users regarding the loss of
>> Solver and data analysis tools. I am in an MBA program, where each are daily,
>> vital tools.
>>
>> If MS is trying to chase the Mac out of universities, this is a brilliant
>> first step.
> They are not. Voice your concern via send feedback on the help menu.
>
Better yet have the university do it as well. If you could get all the
university's to do so and lend their voice, maybe it would force MS hand
and make them hire some more Mac programmers to fix the problem.
Manny Software vendors still consider Mac's Play toys or Machines just
video and Audio Processing and art design.
They are just as capable of doing *any* job any other platform could do,
Windows, UNIX, Linux if they had the software.
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |pjones@kimbanet.com, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto:pjones@kimbanet.com
<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>
<http://www.vpea.org> >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Feb 29, 2008
Posts: 1
|
(Msg. 24) Posted: Fri Feb 29, 2008 9:22 am
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 25) Posted: Sat Mar 01, 2008 5:34 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee88d6d.28.DeleteThis@webcrossing.caR9absDaxw>,
Richardc.DeleteThis@officeformac.com wrote:
> Are there statistical functions in Office 2008, such as ANOVA? I cannot find
> any reference to them in the help system.
All the statistical functions from the Analysis Toolpak Add-in were
incorporated into XL08.
However, ANOVA was implemented in the ATP as a wizard, not a function,
which means it used automation to drive the built-in and ATP functions.
This no longer works in XL08.
However, you can find a good substitute here:
http://www.coventry.ac.uk/ec/~nhunt/oatbran/ >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Mar 01, 2008
Posts: 1
|
(Msg. 26) Posted: Sat Mar 01, 2008 6:55 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Just throwing another voice in for Solver support. I shouldn't have to run VMWare, Windows and Office 2007 to be able to do undergraduate business school stuff.
Yes, I have submitted feedback through the normal channel, but here's another hit on the internet for Microsoft. Hopefully this site and others will help people know ahead of time not to buy Office 2008 if they need these functions.
Have a nice day. >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Mar 03, 2008
Posts: 4
|
(Msg. 27) Posted: Tue Mar 04, 2008 1:47 am
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Are there any genuine reasons to upgrade to 08?
I would glady pay for 08 had MS tweaked some of the brilliant and most useful tools in 04 e.g. VBA/Solver/customizable shortcuts etc. However, all I seem to find is more disappointment from everyone that all these great things have been removed or dummed down for short-term commercial gains by MS.
Someone, please tell me why I should pay the money to upgrade! What am I missing?
(PS new charts and ledger sheets are not genuine reasons) >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Mar 08, 2008
Posts: 1
|
(Msg. 28) Posted: Sat Mar 08, 2008 1:00 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> Sorry if this is a stupid question. Can anyone help me find the XIRR function? I can't find it in the Insert-Functions tab where I expected it to be. I can only find IRR. I tried to find it on the "coventry.uk" link, but I can't open those spreadsheets.
In reading the Excel Post's I gathered that the XIRR function is not available in Excel 2008 and therefor did not purchase the program. If you find out otherwise, Jamie, or anyone else, please post your finding. >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Mar 01, 2006
Posts: 37
|
(Msg. 29) Posted: Sat Mar 08, 2008 3:24 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Franz -
In Mac Excel 2008, if I type =xirr( into a cell, I see XIRR(value,
dates,[guess]), showing me how to complete the arguments.
As far as I know, functions that were previously available with the Analysis
ToolPak add-in are now standard worksheet functions in Mac Excel 2008 (as
they are in Windows Excel 2007).
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
<Franz> wrote in message news:ee88d6d.31@webcrossing.caR9absDaxw...
> Sorry if this is a stupid question. Can anyone help me find the XIRR
> function? I can't find it in the Insert-Functions tab where I expected it
> to be. I can only find IRR. I tried to find it on the "coventry.uk" link,
> but I can't open those spreadsheets. >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
External
Since: Mar 21, 2008
Posts: 1
|
(Msg. 30) Posted: Fri Mar 21, 2008 3:17 pm
Post subject: Re: Excel 2008: Analysis Add-in? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Mike,
It does look like there are functions that were previously in data analysis. However, the data analysis, specifically regression, looks at multiple data outputs that these functions do not provide. Additionally, the oatbran files do not allow for multiple regression, which data analysis provided
> Franz -
>
> In Mac Excel 2008, if I type =xirr( into a cell, I see XIRR(value,
> dates,[guess]), showing me how to complete the arguments.
>
> As far as I know, functions that were previously available with the Analysis
> ToolPak add-in are now standard worksheet functions in Mac Excel 2008 (as
> they are in Windows Excel 2007).
>
> - Mike Middleton
> <http://www.DecisionToolworks.com>
> Decision Analysis Add-ins for Excel
>
>
> wrote in message news:ee88d6d.31@webcrossing.caR9absDaxw...
> > Sorry if this is a stupid question. Can anyone help me find the XIRR
> > function? I can't find it in the Insert-Functions tab where I expected it
> > to be. I can only find IRR. I tried to find it on the "coventry.uk" link,
> > but I can't open those spreadsheets.
>
>
> >> Stay informed about: Excel 2008: Analysis Add-in? |
|
| Back to top |
|
| |
|
FAQ
Search
Profile
Private Messages
Log in/Register/Password
