Mac Excel runs one third speed of PC Excel
- From: Bob Jordan <bjordan@xxxxxxxxxx>
- Date: Thu, 01 Mar 2007 08:57:34 +1300
I have suspected this for a while and only recently had the right PC
access to test it.
I have a reasonable sized spreadsheet (4000 rows by 30 columns) with
quite a lot of maths in it. I am using Solver to explore a set of 12
parameters. It includes some integer constraints which multiply up the
search time. On a 2 GHz iMac G5 it takes 7 minutes 48 to complete a
particular search from a defined start point using 149 iterations in
total. Running on a Dell D610 latitude Laptop with a 1.6GHz clock it
takes 2 minutes 41 seconds. Both get the dame answers and both use
identical patterns of iterations through the different branches.
Hey that is three times faster?
Both machines have 1GByte of RAM. I use OSX 10.4.8 and Office 2004 on
the Mac and I am pretty sure it has all the updates installed. There is
a version of XP on the PC although I am not too sure of the update
status on this machine.
I suspect this may be a general thing although most of my tasks are over
in a short time and the problem is not noticeable. Waiting for 8 minutes
for a computation takes me back to the real old days.
My suspicion is that the Mac version uses different procedures to manage
the links in memory between cells etc. Maybe my techniques with Excel
aggravate this a little but I have been using Excel very extensively for
a long time now.
Has anybody seen any reference to such phenomenon, or can anybody
provide an answer.
Bob J.
.
- Prev by Date: Re: Is it possible to comment out sections of formula in order to troubleshoot?
- Next by Date: Re: Excel keeps taking me back to A1 !!!!!!!!!!!
- Previous by thread: Strange problem with hyperlinks!
- Next by thread: Browse for Folder/Directory
- Index(es):
Relevant Pages
|
