Spreadsheet: 103017d1300876087-making-simple-calculations-from-a-long-list-with-repeating-values-book1
Sheet: Sheet1

Reason | DAYS LOST
20 | 18
Abscess/Boils | 31
Abscess/Boils | 24
Abscess/Boils | 58
Abscess/Boils | 20
Alcoholism | 81
Allergic Reaction | 11
Allergic Reaction | 13
Allergic Reaction | 48
Allergic Reaction | 29
Anaemia | 100
Anaemia | 27.8571428571429
Anaemia | 62
Anaemia | 16
[NAME] | 2
Angina | 153
Angina | 1
Angina | 52.8571428571429
Anxiety | 473
Anxiety | 550
Anxiety | 837
Anxiety | 802
Appendicitis | 137
Appendicitis | 80
Appendicitis | 119
Appendicitis | 85
Arthritis | 83
Arthritis | 66
Arthritis | 132
Arthritis | 328
Asthma | 26
Asthma | 8
Asthma | 44
Asthma | 55
[NAME] | 147.857142857143
Back Pain/Strain | 961
Back Pain/Strain | 853
Back Pain/Strain | 1305
Back Pain/Strain | 826
Bells Palsy | 2.85714285714286
Bells Palsy | 24
Bereavement | 248
Bereavement | 89
Bereavement | 6.42857142857143
Bereavement | 148
Bereavement | 442
Bites | 16
Bites | 3
Bites | 5
Bites | 8
[NAME] (Unspecified) | 20
[NAME] (Unspecified) | 46
[NAME] (Unspecified) | 47
[NAME] | 127
[NAME] | 108
[NAME] | 83
Bronchitis | 13
Bronchitis | 34
Bronchitis | 38
Bronchitis | 46
Bruising - General | 21
Bruising - General | 67
Bruising - General | 16
Bruising - General | 22
Burns | 12
Burns | 8
Cancer | 215
Cancer | 225
Cancer | 1557
Cancer | 1938
Cardiac Failure | 32.8571428571429
Cardiac Failure | 379
Cardiac Failure | 60
Carpal Tunnel Syndrome | 16
Carpal Tunnel Syndrome | 159
Cartillage Damage | 34
Chest Infection | 232
Chest Infection | 292
Chest Infection | 713
Chest Infection | 596
Chest Pains | 50
Chest Pains | 37
Chest Pains | 286
Chest Pains | 117
[NAME] | 8
[NAME] | 20
[NAME] | 6
[NAME] | 15
Cold | 295
Cold | 220
Cold | 786
Cold | 579
Colitis/Ulcer Colitis | 11
Colitis/Ulcer Colitis | 10
Colitis/Ulcer Colitis | 9
Collapsed [NAME] | 6
Concussion | 1
Concussion | 13
Concussion | 5
Conjunctivitis | 4
Conjunctivitis | 9
Conjunctivitis | 39
Conjunctivitis | 6
Coronary Disease | 8
Cough | 11
Cough | 61
Crohn's Disease | 6
Crohn's Disease | 11
Crohn's Disease | 14
Crohn's Disease | 34
Cyst | 94
Cyst | 1
Cyst | 11
Cyst | 8
Cystitis | 1
Cystitis | 6
Cystitis | 4
Debility | 12
Debility | 57
Debility | 104
Debility | 78
Depression | 826
Depression | 829
Depression | 1598
Depression | 1228
Detached Retina | 3
Diabetes | 11
Diabetes | 46
Diabetes | 19
Diabetes | 8
Diarrhoea | 154
Diarrhoea | 122
Diarrhoea | 237
Diarrhoea | 196
Disc Prolapse/Lumbar Disc Lesion | 30
Disc Prolapse/Lumbar Disc Lesion | 196
Dislocation (unspecified) | 40
Dislocation (unspecified) | 66
Dislocation (unspecified) | 9
Diverticulitis | 8
Diverticulitis | 28
Dizziness | 10
Dizziness | 9
Dizziness | 144
Dizziness | 54
Ear Infection | 79
Ear Infection | 116
Ear Infection | 87
Ear Infection | 78
Earache | 3
Earache | 2
Earache | 286
Earache | 257
Eczema | 15
Eczema | 4
Endometriosis | 2
Endometriosis | 7
Endometriosis | 35
Endometriosis | 42
Epilepsy | 7
Epilepsy | 164
Exhaustion/Fatigue | 234
Exhaustion/Fatigue | 334
Exhaustion/Fatigue | 137
Exhaustion/Fatigue | 120
Exposure to Gases/Fumes etc | 2
Eye Defect/Blindness | 75
Eye Defect/Blindness | 2
Eye Defect/Blindness | 31
Eye Defect/Blindness | 2
Eye Defect/Blindness | 132
Eyes Infection | 19
Eyes Infection | 43
Eyes Infection | 42
Eyes Infection | 41
[NAME] | 2
[NAME] | 1
[NAME] | 5
[NAME] | 19
Female Complaints | 1
Fever - Unspecified | 4
Fever - Unspecified | 15
Fever - Unspecified | 47
Fever - Unspecified | 7
Fibroid - Uterus | 2
Fibroid - Uterus | 5
Food Poisoning | 53
Food Poisoning | 45
Food Poisoning | 28
Food Poisoning | 16
Fractured Bone | 750
Fractured Bone | 713
Fractured Bone | 250
Fractured Bone | 185
[NAME] | 3
[NAME] | 8
Gall Bladder - Infection | 12
Gall Bladder - Infection | 5
Gall Bladder - Infection | 3
Gall Bladder - Infection | 1
[NAME] | 14
[NAME] | 67
[NAME] | 201
Ganglion | 38
Ganglion | 13.5714285714286
[NAME] | 32
[NAME] | 114
[NAME] | 83
[NAME] | 104
Glandular Fever | 4
Glandular Fever | 1
Glandular Fever | 35
Gout | 42
Gout | 23
Gout | 53
Gout | 17
Groin Infection | 44.2857142857143
Groin Infection | 1
Gynaecological Complaint | 383
Gynaecological Complaint | 64
Gynaecological Complaint | 135
Gynaecological Complaint | 88
Haemorrhage | 24
Haemorrhage | 22.8571428571429
Haemorrhoids | 2
Haemorrhoids | 9
Haemorrhoids | 34
Haemorrhoids | 32
Hayfever/Sinusitis | 29
Hayfever/Sinusitis | 42
Hayfever/Sinusitis | 1
Headaches | 54
Headaches | 54
Headaches | 113
Headaches | 92
Heart Disease | 6
Heart Disease | 288
Heart Disease | 315
Heat Exhaustion/Sunstroke | 2
Heat Exhaustion/Sunstroke | 6
Hernia | 70
Hernia | 103
Hernia | 90
Hernia | 70
Hospital Treatment/Tests | 21
Hospital Treatment/Tests | 48
Hospital Treatment/Tests | 123
Hospital Treatment/Tests | 706
Huntington's Chorea | 64.28571428571429
Hypertension | 56.4285714285714
Hypertension | 187.142857142857
Hypertension | 32
Hypertension | 109
Hypoglycemia | 7
Hysterectomy | 225
Hysterectomy | 137
Hysterectomy | 140
Hysterectomy | 494
Impetigo | 2
Impetigo | 2
Infection (Unspecified) | 120
Infection (Unspecified) | 57
Infection (Unspecified) | 206
Infection (Unspecified) | 283
Influenza | 1539
Influenza | 878
Influenza | 1532
Influenza | 1041
[NAME] | 3
[NAME] | 2
Injection Reaction | 1
Injury to Ankle | 209
Injury to Ankle | 204
Injury to Ankle | 231
Injury to Ankle | 350
Injury to Arm | 224
Injury to Arm | 50
Injury to Arm | 7
Injury to Arm | 9
Injury to Back | 314
Injury to Back | 285
Injury to Back | 317
Injury to Back | 245
Injury to Chest | 98
Injury to Chest | 79
Injury to Chest | 20
Injury to Chest | 8
Injury to Elbow | 35
Injury to Elbow | 83
Injury to Elbow | 27
Injury to Eye | 1
Injury to Eye | 3
Injury to Eye | 22
Injury to Eye | 4
Injury to Face | 36
Injury to Face | 16
Injury to Foot | 105
Injury to Foot | 79
Injury to Foot | 223
Injury to Foot | 38
Injury to Hand | 145
Injury to Hand | 163
Injury to Hand | 64
Injury to Hand | 138
Injury to Head | 37
Injury to Head | 129
Injury to Head | 88
Injury to Head | 25
Injury to Hip | 53
Injury to Hip | 21
Injury to Hip | 3
Injury to Hip | 7
Injury to Knee | 472
Injury to Knee | 394
Injury to Knee | 335
Injury to Knee | 265
Injury to Leg | 329
Injury to Leg | 181
Injury to Leg | 102
Injury to Leg | 150
Injury to Neck - Whiplash/Torticollis | 298
Injury to Neck - Whiplash/Torticollis | 161
Injury to Neck - Whiplash/Torticollis | 102
Injury to Neck - Whiplash/Torticollis | 153
Injury to Shoulder | 256
Injury to Shoulder | 147
Injury to Shoulder | 138
Injury to Shoulder | 167
Injury to Wrist | 54
Injury to Wrist | 113
Injury to Wrist | 18
Injury to Wrist | 32
Insomnia | 56
Insomnia | 62
Insomnia | 4
Irritable Bowel Syndrome | 3
Irritable Bowel Syndrome | 10
Irritable Bowel Syndrome | 112
Irritable Bowel Syndrome | 15
Joints - Inflamed | 50
Joints - Inflamed | 117
Joints - Inflamed | 53
Joints - Inflamed | 7
[NAME] | 127
[NAME] | 19
[NAME] | 84
[NAME] | 88
Kidney Stones/Renal Calculus | 6
Kidney Stones/Renal Calculus | 70
Kidney Stones/Renal Calculus | 37
Labyrinthitis | 4
Labyrinthitis | 9
Labyrinthitis | 21
Labyrinthitis | 66
Laminectomy | 45
Laryngitis | 10
Laryngitis | 9
Laryngitis | 55
Laryngitis | 35
Ligaments Torn/Strained | 46
Ligaments Torn/Strained | 84
Ligaments Torn/Strained | 12
Ligaments Torn/Strained | 21
[NAME] | 107.142857142857
[NAME] | 87.1428571428571
[NAME]/Swollen | 6
Lymphoma | 83
Lymphoma | 48.5714285714286
Meningitis | 51
Meningitis | 8
Menstruation Problems | 2
Menstruation Problems | 10
Menstruation Problems | 18
Migraine | 59
Migraine | 102
Migraine | 166
Migraine | 156
Migraine | 1
Miscarriage | 98
Miscarriage | 181
Miscarriage | 163
Miscarriage | 80
[NAME] | 7
[NAME] | 3
[NAME] | 6
Multiple Injuries | 102
Multiple Injuries | 25
Multiple Injuries | 1
Multiple Sclerosis | 152
Multiple Sclerosis | 173
Multiple Sclerosis | 272
Multiple Sclerosis | 252.857142857143
Mumps | 10
Mumps | 4
Mumps | 8
Mumps | 11
[NAME] | 121
[NAME] | 36
[NAME] | 78
[NAME] | 13
[NAME] | 2
[NAME] | 5
[NAME] | 202
[NAME] | 9
Nerve - Damage | 33
Nerve - Damage | 24
Nerve - Damage | 20
Nerve - Damage | 7
Neuritis/Neuralgia | 17
Neuritis/Neuralgia | 31
Nose Bleed | 2
Nose Bleed | 4
Operation | 2796
Operation | 2479
Operation | 3555
Operation | 3226
Osteo-Arthritis | 6
Osteo-Arthritis | 230.714285714286
Osteo-Arthritis | 335
Palpitations | 2
Palpitations | 1
Palpitations | 23
Pancreatitis | 46
Pancreatitis | 238
Pancreatitis | 10
Parkinson's Disease | 1
[NAME] Disease | 3
Pericarditis | 16
Pericarditis | 52
Pharyngitis | 1
Pharyngitis | 16
Pleural Effusion/Pleurisy | 48
Pleural Effusion/Pleurisy | 72
Pleural Effusion/Pleurisy | 42
Pleural Effusion/Pleurisy | 43
Pneumonia | 3
Pneumonia | 205
Pneumonia | 93
Pneumonia | 95
Post Natal Depression | 70
Post Natal Depression | 29
Post Operative Care | 295
Post Operative Care | 265
Post Operative Care | 402
Post Operative Care | 181
Post Traumatic Stress | 18
Pregnancy - Condition of | 383
Pregnancy - Condition of | 392
Pregnancy - Condition of | 454
Pregnancy - Condition of | 650
Prostate [NAME] | 177
Prostate [NAME] | 19
Prostate [NAME] | 5
Pulmonary Embolism | 10
[NAME] | 8
Retinopathy | 5
Scald | 3
[NAME] | 64
[NAME] | 104
[NAME] | 317
[NAME] | 325
Shingles | 28
Shingles | 17
Shingles | 38
Shingles | 63
Shock | 9
Sinusitis | 59
Sinusitis | 1
Sinusitis | 85
Skin Infection | 68
Skin Infection | 6
Skin Infection | 24
Skin Infection | 48
[NAME] | 27
[NAME] | 14
[NAME] | 166
[NAME] | 124
Spondylosis | 17
Spondylosis | 29
Stomach Ulcers | 3
Stomach Ulcers | 1
Stomach Ulcers | 13
Stomach Upset/Pain | 389
Stomach Upset/Pain | 504
Stomach Upset/Pain | 655
Stomach Upset/Pain | 573
Strains/Sprains | 69
Strains/Sprains | 84
Strains/Sprains | 193
Strains/Sprains | 157
Stress | 1580
Stress | 2111
Stress | 1752
Stress | 2397
Stroke | 255
Stroke | 60
Stroke | 334
Swelling (general) | 10
Swelling (general) | 12
Swelling (general) | 31
Swelling (general) | 32
Tendinitis | 2
Tendinitis | 24
Tendinitis | 2
Tendinitis | 25
Tenosynovitis | 4
Throat Infection/Catarrah | 49
Throat Infection/Catarrah | 40
Throat Infection/Catarrah | 106
Throat Infection/Catarrah | 97
Thrombosis - Leg | 77.8571428571429
Thrombosis - Leg | 36
Thrombosis - Leg | 2
Thrombosis - Leg | 10
Thyroid Condition | 25
Thyroid Condition | 11
Thyroid Condition | 15
Thyroid Condition | 40
Tonsillitis | 39
Tonsillitis | 76
Tonsillitis | 128
Tonsillitis | 66
Toothache/Extraction | 77
Toothache/Extraction | 57
Toothache/Extraction | 45
Toothache/Extraction | 63
Tumour - Unspecified | 76
Ulcerative Colitis | 3
Ulcerative Colitis | 10
Ulcerative Colitis | 4
Upper Respiratory Tract Infection | 13
Upper Respiratory Tract Infection | 27
Upper Respiratory Tract Infection | 163
Upper Respiratory Tract Infection | 40
Urinary Infection | 9
Urinary Infection | 14
Urinary Infection | 31
Urinary Infection | 19
[NAME] | 3
[NAME] | 4
Vasectomy | 27
Vasectomy | 23
Vasectomy | 2
Vasectomy | 4
Vertigo | 15
Vertigo | 69
Vertigo | 221
Vertigo | 84
Viral Infection | 311
Viral Infection | 272
Viral Infection | 428
Viral Infection | 358
Vomiting | 393
Vomiting | 427
Vomiting | 597
Vomiting | 630
Wound - Laceration - Skin | 1
Wound - Laceration - Skin | 1