Morning all,
I thought I would share the results of a stopwatch trial I performed
on various versions of excel for PC and mac - the results are not
pretty.
Test machines
A - 1 Clone 2.4 GHz P4 (no HT), 512MB RAM, 40GB HD, WinXP - Office 2000
B - 1 eMac 1 GHz, 512MB RAM, 40GB HD, 10.3.4 - Office X
C - 1 Powerbook G4 15" 1.25GHz, 512MB RAM, 80GB HD, 10.3.4 - Office X
D - 1 Powermac G5 1.6GHz, 1.25 GB RAM, 80GB HD, 10.3.4 - Office X,
Office 2004, OpenOffice 1.1.2 (X windows)
Test
- 2 spreadsheets with 22,000 lines and 10 columns of data.
- vlookup product code in spreadsheet one to determine tax rate from
spreadsheet 2.
Results (in minutes:seconds)
A - 1:50
B - 14:25
C - 8:01
D - 6:25, 11:20, 2:10 (results in order - Office X, Office 2004, OO 1.1.2)
As you can see, it's not good. Anyone suggest how I can make my G5
look good again? Our company relies on Vlookups due to varying
sources of data every day.
Kind regards
Ron Holmes
This won't help, but if you've got so much data, then switch to a
database app, which is designed to handle large amounts of data.
Also, isn't there some preference to switch off automatic
recalculations. If you're just doing lookups, you could take this
option. Yes. See Preferences/ Calculations.
Rob
--
-------------------------------
Dr Rob Phillips, Senior Lecturer, [EMAIL PROTECTED]
Room 4.38 Teaching and Learning Centre, Library North Wing
Murdoch University, South St, Murdoch, 6150, Perth, Australia
Phone: +61 8 9360 6054 Mobile: 0416 065 054
Executive Member, Australasian Council on Open, Distance and E-learning (ACODE)
Chair, 2004 ASCILITE Conference,
http://www.ascilite.org.au/conferences/perth04/
-------------------------------