Re: Rotating text in Preview & excel analysis pak

2011-07-11 Thread Philippe Chaperon 
Hi Chris and All,

Many thanks for the information and feedback. This will come in handy for
those of us using Excel.

Kind regards,

Philippe

2011/7/11 Chris Burton 

>
> Hi Ronni, Philippe and others
>
> Just thought I would let you know how I went with the Analysis ToolPak with
> excel.
>
> Microsoft has indeed dis-continued the use of the above add-in but does has
> Solver, for 2011 Excel.
>
> I have downloaded and installed the alternative for the ToolPak,
> StatPlus:mac 2009 and it seems to be pretty good. Easy to use, with
> tutorials on different stats to use, and how to use them with your data in
> Excel.
>
> This is an LE (light) version and they ask you to upgrade to the Pro
> version, which does has a lot more options and stats procedures.
>
> I will give a reasonable go over the coming months.
>
> Best regards
>
> Chris
>
> Christopher L.K. Burton
> Director
> Western Whale Research
> PO Box 1076
> Dunsborough WA 6281
> Mobile: 0419 199 120
> Email: c...@it.net.au
>
> On 03/07/2011, at 3:44 PM, Chris Burton wrote:
>
> >
> > Hi Ronni and Philippe
> >
> > Thanks very much for your very helpful advice and links. I will get to
> and check them out, and let you know how it goes.
> >
> > Philippe yes I found similar sites that say Microsoft expects us to use
> an LE version of StatPlus: Mac. Im not sure about it but will use at the
> last resort after I look at Ronni's suggestions.
> >
> > Kind regards
> >
> > Chris
> >
> >
> > On 03/07/2011, at 12:30 PM, Ronda Brown wrote:
> >
> >>
> >> Hi Chris,
> >>
> >> <
> http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/what-happened-to-the-data-analysis-toolpak-or/740ff33a-6ed9-4553-bc09-5cef06ce5f23
> >
> >>
> >> Solver was added to Office for Mac 2011 in the Service Pack 1 update.
> You can download and install Office for Mac 2011’s Service Pack 1 by
> clicking on the link below:
> >> <
> http://www.microsoft.com/downloads/en/details.aspx?FamilyID=EF1E612F-D8E3-4628-9FE4-AD136F0DEBD3&displaylang=en
> >
> >>
> >> After you install Service Pack 1, follow these steps to start Solver:
> >>  • Start Excel.
> >>  • Click Tools, and then select Add-Ins.
> >>  • Click to select the check box for Solver.Xlam.
> >>  • Click OK.
> >>
> >> <
> http://blog.officeformac.com/solver-for-excel-for-mac-2011-free-download-gives-you-what-if-analysis-on-steroids/
> >
> >>
> >> Solver for Excel for Mac 2011
> >> http://www.solver.com/mac/
> >>
> >> Cheers,
> >> Ronni
> >>
> >> On 03/07/2011, at 10:00 AM, Chris Burton wrote:
> >>
> >>>
> >>> Hi Ronni
> >>>
> >>> Thanks very much for your reply and link. I had another good look at
> the installation disk and found the customise section and included the VBA
> install.
> >>>
> >>> However there is no sign of the Analysis ToolPak.
> >>> When I reopened Excel I have a small window appear, saying 'Cannot find
> the Analysis ToolPak'. Please run the ValuePack Setup to install the
> Analysis ToolPak.
> >>>
> >>> There is no ValuePak Setup on my mac or on the install DVD? Do I need
> to download this?
> >>>
> >>> Kindest regards and many thanks Ronni
> >>>
> >>> Chris
> >>>
> >>>
> >>> On 02/07/2011, at 2:02 PM, Ronda Brown wrote:
> >>>
> 
>  On 02/07/2011, at 1:30 PM, Chris Burton  wrote:
> 
> > Also had another shock today while trying to do some basic stats in
> the new Excel 2011 but couldnt do anything as this version does not support
> the Analysis ToolPak, and add in normally supplied with previous versions.
> >
> > Apparently Microsoft are not doing this any longer so I have to
>  revert to 3rd party software!!
> 
>  Hi Chris,
> 
>  Did you perform a standard installation or custom installation of Mac
> Office?
> 
>  Microsoft returned the Analysis Toolpak add-in that it removed from
> Excel 2008.
>  Microsoft says that the new version of Excel supports the add-in the
> same way Excel 2008 did, and that the add-in’s basic functions work in Excel
> 2011
> 
>  Have a read here:
>  2011 without UDFs?
>  <
> http://blog.mclaughlinsoftware.com/2010/11/04/excel-2011-without-udfs/>
> 
>  Sent from Ronni's iPad
> >>
>
>



-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe -

Re: Rotating text in Preview & excel analysis pak

2011-07-10 Thread Chris Burton 

Hi Ronni, Philippe and others

Just thought I would let you know how I went with the Analysis ToolPak with 
excel.

Microsoft has indeed dis-continued the use of the above add-in but does has 
Solver, for 2011 Excel.

I have downloaded and installed the alternative for the ToolPak, StatPlus:mac 
2009 and it seems to be pretty good. Easy to use, with tutorials on different 
stats to use, and how to use them with your data in Excel. 

This is an LE (light) version and they ask you to upgrade to the Pro version, 
which does has a lot more options and stats procedures.

I will give a reasonable go over the coming months.

Best regards

Chris

Christopher L.K. Burton
Director
Western Whale Research
PO Box 1076
Dunsborough WA 6281
Mobile: 0419 199 120
Email: c...@it.net.au 

On 03/07/2011, at 3:44 PM, Chris Burton wrote:

> 
> Hi Ronni and Philippe
> 
> Thanks very much for your very helpful advice and links. I will get to and 
> check them out, and let you know how it goes.
> 
> Philippe yes I found similar sites that say Microsoft expects us to use an LE 
> version of StatPlus: Mac. Im not sure about it but will use at the last 
> resort after I look at Ronni's suggestions.
> 
> Kind regards
> 
> Chris
> 
> 
> On 03/07/2011, at 12:30 PM, Ronda Brown wrote:
> 
>> 
>> Hi Chris,
>> 
>> 
>> 
>> Solver was added to Office for Mac 2011 in the Service Pack 1 update. You 
>> can download and install Office for Mac 2011’s Service Pack 1 by clicking on 
>> the link below:
>> 
>> 
>> After you install Service Pack 1, follow these steps to start Solver:
>>  • Start Excel.
>>  • Click Tools, and then select Add-Ins.
>>  • Click to select the check box for Solver.Xlam.
>>  • Click OK.
>> 
>> 
>> 
>> Solver for Excel for Mac 2011
>> http://www.solver.com/mac/
>> 
>> Cheers,
>> Ronni
>> 
>> On 03/07/2011, at 10:00 AM, Chris Burton wrote:
>> 
>>> 
>>> Hi Ronni
>>> 
>>> Thanks very much for your reply and link. I had another good look at the 
>>> installation disk and found the customise section and included the VBA 
>>> install.
>>> 
>>> However there is no sign of the Analysis ToolPak. 
>>> When I reopened Excel I have a small window appear, saying 'Cannot find the 
>>> Analysis ToolPak'. Please run the ValuePack Setup to install the Analysis 
>>> ToolPak.
>>> 
>>> There is no ValuePak Setup on my mac or on the install DVD? Do I need to 
>>> download this?
>>> 
>>> Kindest regards and many thanks Ronni
>>> 
>>> Chris
>>> 
>>> 
>>> On 02/07/2011, at 2:02 PM, Ronda Brown wrote:
>>> 
 
 On 02/07/2011, at 1:30 PM, Chris Burton  wrote:
 
> Also had another shock today while trying to do some basic stats in the 
> new Excel 2011 but couldnt do anything as this version does not support 
> the Analysis ToolPak, and add in normally supplied with previous 
> versions. 
> 
> Apparently Microsoft are not doing this any longer so I have to  revert 
> to 3rd party software!!
 
 Hi Chris,
 
 Did you perform a standard installation or custom installation of Mac 
 Office?
 
 Microsoft returned the Analysis Toolpak add-in that it removed from Excel 
 2008.
 Microsoft says that the new version of Excel supports the add-in the same 
 way Excel 2008 did, and that the add-in’s basic functions work in Excel 
 2011
 
 Have a read here:
 2011 without UDFs?
 
 
 Sent from Ronni's iPad
>> 
>> 
>> 
>> 
>> -- The WA Macintosh User Group Mailing List --
>> Archives - 
>> Guidelines - 
>> Unsubscribe - 
>> 
> 
> 
> 
> 
> -- The WA Macintosh User Group Mailing List --
> Archives - 
> Guidelines - 
> Unsubscribe - 
> 




-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe -

Re: Rotating text in Preview & excel analysis pak

2011-07-03 Thread Chris Burton 

Hi Ronni and Philippe

Thanks very much for your very helpful advice and links. I will get to and 
check them out, and let you know how it goes.

Philippe yes I found similar sites that say Microsoft expects us to use an LE 
version of StatPlus: Mac. Im not sure about it but will use at the last resort 
after I look at Ronni's suggestions.

Kind regards

Chris


On 03/07/2011, at 12:30 PM, Ronda Brown wrote:

> 
> Hi Chris,
> 
> 
> 
> Solver was added to Office for Mac 2011 in the Service Pack 1 update. You can 
> download and install Office for Mac 2011’s Service Pack 1 by clicking on the 
> link below:
> 
> 
> After you install Service Pack 1, follow these steps to start Solver:
>   • Start Excel.
>   • Click Tools, and then select Add-Ins.
>   • Click to select the check box for Solver.Xlam.
>   • Click OK.
> 
> 
> 
> Solver for Excel for Mac 2011
> http://www.solver.com/mac/
> 
> Cheers,
> Ronni
> 
> On 03/07/2011, at 10:00 AM, Chris Burton wrote:
> 
>> 
>> Hi Ronni
>> 
>> Thanks very much for your reply and link. I had another good look at the 
>> installation disk and found the customise section and included the VBA 
>> install.
>> 
>> However there is no sign of the Analysis ToolPak. 
>> When I reopened Excel I have a small window appear, saying 'Cannot find the 
>> Analysis ToolPak'. Please run the ValuePack Setup to install the Analysis 
>> ToolPak.
>> 
>> There is no ValuePak Setup on my mac or on the install DVD? Do I need to 
>> download this?
>> 
>> Kindest regards and many thanks Ronni
>> 
>> Chris
>> 
>> 
>> On 02/07/2011, at 2:02 PM, Ronda Brown wrote:
>> 
>>> 
>>> On 02/07/2011, at 1:30 PM, Chris Burton  wrote:
>>> 
 Also had another shock today while trying to do some basic stats in the 
 new Excel 2011 but couldnt do anything as this version does not support 
 the Analysis ToolPak, and add in normally supplied with previous versions. 
 
 Apparently Microsoft are not doing this any longer so I have to  revert to 
 3rd party software!!
>>> 
>>> Hi Chris,
>>> 
>>> Did you perform a standard installation or custom installation of Mac 
>>> Office?
>>> 
>>> Microsoft returned the Analysis Toolpak add-in that it removed from Excel 
>>> 2008.
>>> Microsoft says that the new version of Excel supports the add-in the same 
>>> way Excel 2008 did, and that the add-in’s basic functions work in Excel 2011
>>> 
>>> Have a read here:
>>> 2011 without UDFs?
>>> 
>>> 
>>> Sent from Ronni's iPad
> 
> 
> 
> 
> -- The WA Macintosh User Group Mailing List --
> Archives - 
> Guidelines - 
> Unsubscribe - 
> 




-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Unsubscribe -