Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Referral Date Patient ID Number Referral Priority Weekday Type of Contact 03-Feb-11 156412 Routine Thursday Face 2 Face 28-Jan-11 156414 Emergency Friday Face 2 Face

Referral Date Patient ID Number Referral Priority Weekday Type of Contact
03-Feb-11 156412 Routine Thursday Face 2 Face
28-Jan-11 156414 Emergency Friday Face 2 Face
01-Feb-11 Do a pivot table from the data on tab 'Q1', showing the total number of contacts broken down by Referral Date and Contact Type Emergency Tuesday Face 2 Face
04-Feb-11 156418 Routine Friday Face 2 Face
28-Jan-11 156420 Routine Friday Face 2 Face
09-Feb-11 156422 Routine Wednesday Telephone
28-Jan-11 156424 Routine Friday Telephone
01-Feb-11 156426 Routine Tuesday Telephone
13-Jan-11 156428 Emergency Thursday Face 2 Face
10-Feb-11 156430 Emergency Thursday Telephone
01-Feb-11 156432 Emergency Tuesday Telephone
02-Feb-11 156434 Routine Wednesday Telephone
01-Feb-11 156436 Routine Tuesday Face 2 Face
24-Jan-11 156438 Routine Monday Face 2 Face
28-Jan-11 156440 Emergency Friday Face 2 Face
02-Feb-11 156442 Routine Wednesday Face 2 Face
24-Feb-11 156444 Routine Thursday Face 2 Face
21-Mar-11 156446 Emergency Monday Face 2 Face
18-Jan-11 156448 Routine Tuesday Telephone
28-Jan-11 156450 Routine Friday Face 2 Face
26-Jan-11 156452 Emergency Wednesday Telephone
01-Feb-11 156454 Emergency Tuesday Telephone
28-Jan-11 156456 Routine Friday Face 2 Face
31-Jan-11 156458 Routine Monday Face 2 Face
10-Jan-11 156460 Routine Monday Face 2 Face
07-Feb-11 156462 Routine Monday Face 2 Face
02-Feb-11 156464 Routine Wednesday Face 2 Face
08-Feb-11 156466 Emergency Tuesday Telephone
01-Feb-11 156468 Emergency Tuesday Telephone
04-Feb-11 156470 Emergency Friday Telephone
28-Jan-11 156472 Routine Friday Face 2 Face
07-Mar-11 156474 Routine Monday Telephone
01-Feb-11 156476 Routine Tuesday Telephone
07-Feb-11 156478 Emergency Monday Telephone
10-Feb-11 156480 Routine Thursday Face 2 Face
08-Feb-11 156482 Routine Tuesday Face 2 Face
02-Feb-11 156484 Emergency Wednesday Face 2 Face
09-Feb-11 156486 Routine Wednesday Face 2 Face
04-Feb-11 156488 Routine Friday Face 2 Face
27-Jan-11 156490 Emergency Thursday Face 2 Face
24-Feb-11 156492 Emergency Thursday Telephone
28-Jan-11 156494 Routine Friday Face 2 Face
28-Jan-11 156496 Routine Friday Telephone
28-Jan-11 156498 Routine Friday Telephone
01-Feb-11 156500 Routine Tuesday Face 2 Face
24-Jan-11 156502 Routine Monday Face 2 Face
31-Jan-11 156504 Emergency Monday Face 2 Face
14-Feb-11 156506 Emergency Monday Face 2 Face
01-Feb-11 156508 Emergency Tuesday Face 2 Face
04-Feb-11 156510 Routine Friday Telephone
03-Feb-11 156512 Routine Thursday Telephone
08-Feb-11 156514 Routine Tuesday Telephone
01-Feb-11 156516 Emergency Tuesday Face 2 Face
27-Jan-11 156518 Routine Thursday Telephone
07-Mar-11 156520 Routine Monday Telephone
02-Feb-11 156522 Emergency Wednesday Telephone
11-Mar-11 156524 Routine Friday Face 2 Face
03-Feb-11 156526 Routine Thursday Face 2 Face
01-Feb-11 156528 Emergency Tuesday Face 2 Face
04-Feb-11 156530 Emergency Friday Face 2 Face
03-Feb-11 156532 Routine Thursday Face 2 Face
09-Mar-11 156534 Routine Wednesday Face 2 Face
31-Jan-11 156536 Routine Monday Telephone
27-Jan-11 156538 Routine Thursday Face 2 Face
08-Feb-11 156540 Routine Tuesday Telephone
02-Feb-11 156542 Emergency Wednesday Telephone
18-Feb-11 156544 Emergency Friday Face 2 Face
27-Jan-11 156546 Emergency Thursday Face 2 Face
03-Feb-11 156548 Routine Thursday Face 2 Face
03-Feb-11 156550 Routine Thursday Face 2 Face
18-Feb-11 156552 Routine Friday Face 2 Face
27-Jan-11 156554 Emergency Thursday Telephone
02-Feb-11 156556 Routine Wednesday Telephone
27-Jan-11 156558 Routine Thursday Telephone
03-Feb-11 156560 Emergency Thursday Face 2 Face
16-Feb-11 156562 Routine Wednesday Telephone
15-Feb-11 156564 Routine Tuesday Telephone
01-Feb-11 156566 Emergency Tuesday Telephone
27-Jan-11 156568 Emergency Thursday Face 2 Face
05-Apr-11 156570 Routine Tuesday Face 2 Face
02-Feb-11 156572 Routine Wednesday Face 2 Face
04-Feb-11 156574 Routine Friday Face 2 Face
26-Jan-11 156576 Routine Wednesday Face 2 Face
27-Jan-11 156578 Routine Thursday Face 2 Face
26-Jan-11 156580 Emergency Wednesday Telephone
24-Jan-11 156582 Emergency Monday Face 2 Face
23-Feb-11 156584 Emergency Wednesday Telephone
22-Feb-11 156586 Routine Tuesday Telephone
28-Jan-11 156588 Routine Friday Face 2 Face
07-Mar-11 156590 Routine Monday Face 2 Face
27-Jan-11 156592 Emergency Thursday Face 2 Face
04-Feb-11 156594 Routine Friday Face 2 Face
02-Feb-11 156596 Routine Wednesday Face 2 Face
07-Feb-11 156598 Emergency Monday Telephone
27-Jan-11 156600 Routine Thursday Telephone
09-Feb-11 156602 Routine Wednesday Telephone
31-Jan-11 156604 Emergency Monday Face 2 Face
08-Feb-11 156606 Emergency Tuesday Telephone
02-Mar-11 156608 Routine Wednesday Telephone
12-Jan-11 156610 Routine Wednesday Telephone
01-Feb-11 156612 Routine Tuesday Face 2 Face
10-Feb-11 156614 Routine Thursday Face 2 Face
02-Feb-11 156616 Routine Wednesday Face 2 Face
14-Apr-11 156618 Emergency Thursday Face 2 Face
07-Feb-11 156620 Emergency Monday Face 2 Face
01-Feb-11 156622 Emergency Tuesday Face 2 Face
16-Feb-11 156624 Routine Wednesday Telephone
02-Feb-11 156626 Routine Wednesday Face 2 Face
03-Feb-11 156628 Routine Thursday Telephone
04-Feb-11 156630 Emergency Friday Telephone
10-Feb-11 156632 Routine Thursday Face 2 Face
30-Mar-11 156634 Routine Wednesday Face 2 Face
02-Feb-11 156636 Emergency Wednesday Face 2 Face
27-Jan-11 156638 Routine Thursday Face 2 Face
01-Feb-11 156640 Routine Tuesday Face 2 Face
26-Jan-11 156642 Emergency Wednesday Telephone
15-Feb-11 156644 Emergency Tuesday Telephone
25-Jan-11 156646 Routine Tuesday Telephone
06-Apr-11 156648 Routine Wednesday Face 2 Face
01-Feb-11 156650 Routine Tuesday Telephone
14-Feb-11 156652 Routine Monday Telephone
01-Feb-11 156654 Routine Tuesday Telephone
01-Feb-11 156656 Emergency Tuesday Face 2 Face
01-Feb-11 156658 Emergency Tuesday Face 2 Face
26-Jan-11 156660 Emergency Wednesday Face 2 Face
07-Feb-11 156662 Routine Monday Face 2 Face
31-Jan-11 156664 Routine Monday Face 2 Face
17-Feb-11 156666 Routine Thursday Face 2 Face
04-Feb-11 156668 Emergency Friday Telephone
27-Jan-11 156670 Routine Thursday Face 2 Face
21-Feb-11 156672 Routine Monday Telephone
08-Feb-11 156674 Emergency Tuesday Telephone
07-Feb-11 156676 Routine Monday Face 2 Face
02-Feb-11 156678 Routine Wednesday Face 2 Face
24-Feb-11 156680 Emergency Thursday Face 2 Face
31-Jan-11 156682 Emergency Monday Face 2 Face
03-Feb-11 156684 Routine Thursday Face 2 Face
28-Jan-11 156686 Routine Friday Telephone
08-Feb-11 156688 Routine Tuesday Telephone
01-Feb-11 156690 Routine Tuesday Telephone
28-Jan-11 156692 Routine Friday Face 2 Face
31-Jan-11 156694 Emergency Monday Telephone
28-Jan-11 156696 Emergency Friday Telephone
08-Mar-11 156698 Emergency Tuesday Telephone
13-Jan-11 156700 Routine Thursday Face 2 Face
04-Feb-11 156702 Routine Friday Face 2 Face
28-Jan-11 156704 Routine Friday Face 2 Face
02-Feb-11 156706 Emergency Wednesday Face 2 Face
25-Jan-11 156708 Routine Tuesday Face 2 Face
26-Jan-11 156710 Routine Wednesday Face 2 Face
11-Feb-11 156712 Emergency Friday Telephone
14-Mar-11 156714 Routine Monday Face 2 Face

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial and Managerial Accounting

Authors: John J Wild, Ken W. Shaw

8th edition

1260247856, 978-1260247855

More Books

Students also viewed these Accounting questions

Question

Compare and contrast the three wire line communications channels.

Answered: 1 week ago

Question

1. In what way is this government agency different from a business?

Answered: 1 week ago

Question

1. Too understand personal motivation.

Answered: 1 week ago