The impact of slow Excel spreadsheets

Slow Excel Spreadsheets Increase Errors and Impact Productivity.

Research studies show that a user’s productivity and ability to focus on the task deteriorate as response time lengthens.

Response time greater than 10 seconds:

Users generally refuse to wait longer than 10 seconds.

Users tend to switch to other tasks.

Response time greater than 1 second but less than 10 seconds:

User errors, and annoyance level, start to increase, particularly for repetitive tasks.

The user has difficulty in retaining a train of thought, but will probably not have switched to doing a different task whilst they are waiting.

Sub-Second Response:

You will probably need to switch to Manual Calculation Mode when entering data.

Improving Calculation speed increases productivity.

For response times greater than a tenth of a send but still less than about 1 second, users can successfully keep a train of thought going, although they will notice the response time delay.

IBM studies from the 1970s and 1980s showed significant productivity gains for users when response times were less than a second.

Instant Response:

Use Automatic Calculation Mode even when entering data.

For response times of less than about a tenth of a second, users feel that the system is responding instantaneously.

© 2001-2020 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster