Excel 2013 homework

profilehosm-a
copy_of_clinic.xlsx
Home>Computer Science homework help>Excel 2013 homework

Documentation

C & M Veterinary Clinic
Author
Date
Purpose To collect clinic patient traffic data for analysis.

Service Analysis by Month

C & M Veterinary Clinic
Sevice Analysis by Month
Month Checkup Surgery Technician
January
February
March
April
May
June
July
August
September
October
November
December

Service Analysis by Animal

C & M Veterinary Clinic
Service Analysis by Animal
Animal Type Checkup Surgery Technician
Small Dog
Large Dog
Cat
Small Bird
Large Bird
Other

January

C & M Veterinary Clinic
January
Animal Type Checkup Surgery Technician
Small Dog 32 10 5
Large Dog 45 12 5
Cat 18 15 3
Small Bird 18 0 2
Large Bird 10 0 1
Other 0 0 0

February

C & M Veterinary Clinic
February
Animal Type Checkup Surgery Technician
Small Dog 35 8 5
Large Dog 20 15 6
Cat 23 10 3
Small Bird 2 0 0
Large Bird 1 0 0
Other 1 0 0

March

C & M Veterinary Clinic
March
Animal Type Checkup Surgery Technician
Small Dog 55 15 18
Large Dog 21 8 24
Cat 40 18 20
Small Bird 4 0 0
Large Bird 5 0 0
Other 0 0 0

April

C & M Veterinary Clinic
April
Animal Type Checkup Surgery Technician
Small Dog 35 16 10
Large Dog 40 4 12
Cat 20 23 5
Small Bird 3 0 0
Large Bird 5 0 0
Other 0 0 0

May

C & M Veterinary Clinic
May
Animal Type Checkup Surgery Technician
Small Dog 31 20 10
Large Dog 46 22 10
Cat 16 30 6
Small Bird 6 0 4
Large Bird 8 0 2
Other 0 0 0

June

C & M Veterinary Clinic
June
Animal Type Checkup Surgery Technician
Small Dog 40 10 10
Large Dog 25 17 12
Cat 28 12 6
Small Bird 7 0 0
Large Bird 6 0 0
Other 2 0 0

July

C & M Veterinary Clinic
July
Animal Type Checkup Surgery Technician
Small Dog 60 16 15
Large Dog 22 7 20
Cat 38 20 18
Small Bird 2 0 0
Large Bird 3 0 0
Other 0 0 0

August

C & M Veterinary Clinic
August
Animal Type Checkup Surgery Technician
Small Dog 29 18 12
Large Dog 30 20 12
Cat 20 19 8
Small Bird 3 0 0
Large Bird 2 0 0
Other 0 0 0

September

C & M Veterinary Clinic
September
Animal Type Checkup Surgery Technician
Small Dog 35 15 13
Large Dog 30 12 10
Cat 25 20 18
Small Bird 8 0 0
Large Bird 6 0 0
Other 3 0 0

October

C & M Veterinary Clinic
October
Animal Type Checkup Surgery Technician
Small Dog 33 15 15
Large Dog 28 16 18
Cat 32 20 6
Small Bird 0 0 0
Large Bird 0 0 0
Other 0 0 0

November

C & M Veterinary Clinic
November
Animal Type Checkup Surgery Technician
Small Dog 58 8 18
Large Dog 20 15 22
Cat 30 23 25
Small Bird 0 0 0
Large Bird 1 0 0
Other 0 0 0

December

C & M Veterinary Clinic
December
Animal Type Checkup Surgery Technician
Small Dog 40 15 20
Large Dog 32 22 13
Cat 35 13 10
Small Bird 2 0 0
Large Bird 6 0 0
Other 0 0 0