Avoid Excel Horror Stories: How to excel at creating reliable, user-friendly spreadsheets by Knott Gary

Author:Knott, Gary [Knott, Gary]
Language: eng
Format: epub, azw3
Publisher: how2excel
Published: 2021-06-26T00:00:00+00:00

3.5 Copy and paste errors

Copy and paste is very useful, easy to perform and commonly used… Ctrl C and Ctrl V are probably the most well-known Excel shortcuts. But this seemingly simple action can lead to expensive (but avoidable) errors, as the following examples show. These include (i) errors which were created during the copying and (ii) errors that were already in the cells being copied and were therefore repeated.

DOCTOR JOB OFFERS AND REJECTIONS SENT TO INCORRECT CANDIDATES

Background: The National Health Service in Britain used spreadsheets for assessing junior doctors’ interview results.

Error: The spreadsheet with the results for each interview was copied into a new sheet with a different format and other errors were made, which resulted in incorrect rankings being assigned to interviewees.

Outcome: As a result, some job offers and rejections were sent to incorrect candidates. A statement by the British Medical Association said, ‘There is no hiding from the fact that many trainees will have made huge life decisions based on their original offers. ’

Source: http://www.nationalhealthexecutive.com/Health-Care-News/junior-doctor-jobs-offers-withdrawn-after-admin-blunder?dorewrite=false

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.