Set_Up

Document Sample
Set_Up Powered By Docstoc
					This worksheet allows you, the user, to define how the worksheet functions and is u
To Use:      For this entire excel workbook, Yellow fields are for your data input. On this sheet, you can def

Name of Clinic:                                           Clinic Name

Name of PCN:                                                 NONE

Name of Zone:                                                     0

List below Providers who will be tracked:
                                                          Who            Type
                         Provider 1's name:         Provider 1         Physician
                         Provider 2's name:         Provider 2            NA
                                                                                                                     Linking t
                         Provider 3's name:         Provider 3            NA                To Link Your AIMTracking to your A
                         Provider 4's name:         Provider 4            NA
                         Provider 5's name:         Provider 5            NA                1) Press Alt + F8 and select "Chan
                         Provider 6's name:         Provider 6            NA                2) In the Edit Links Window that ap
                         Provider 7's name:         Provider 7            NA                3) In the Change Source Window,
                         Provider 8's name:         Provider 8            NA                4) Select your tracking file and clic
                         Provider 9's name:         Provider 9            NA                5) WAIT – this may take several m
                         Provider 10's name:        Provider 10           NA                   Thousands of links are being es
                         Provider 11's name:        Provider 11           NA                6) When the links are established
                         Provider 12's name:        Provider 12           NA                7) Press F9 to calculate new value
                         Provider 13's name:        Provider 13           NA                8) Save the file to establish the link
                         Provider 14's name:        Provider 14           NA
                         Provider 15's name:        Provider 15           NA                NOTE: If the above steps do not w
                                                                                                 file to Your AIMAnalysis.xls(
                                                                                                 Applications which outlines t
What MONDAY will your tracking begin?           01-Mar-2010
         The value above should not be changed once tracking starts.

Is your clinic Primary Care or a Specialty?             Primary
  Note: changing the above requires you "Hide Intro/Tracker" then "Reveal Intro/Tracker" off of the AIM toolbar.
Has system locked the clinic type?                        No

What are your operating hours?                                                              This area for office use only.
What is the earliest time for an appointment?              6:00
What is the latest time for an appointment?               20:00                             Collabrative Name:
How early should patients arrive (minutes)?                 15          0.01042
What days of the week are you open?                       Open?                             Learning Session Completed:
                        1           Sunday                  No
                        2           Monday                 Yes
                        3          Tuesday                 Yes
                        4        Wednesday                 Yes
                        5          Thursday                Yes                              Security Issues
                        6           Friday                 Yes                              If you are having macro security or
                        7          Saturday                 No                              see "The Initial Setup - Changing Y
                                                                                            in the User Guide for AIM Applicati
                                                                                              You may download a copy of the U
                                                                                              (and other measurement tools & re



Generic 1         (Note: the "Generic" tab is for those doctors who want to collect additional stats.)
Title:                                  This is the Title to the Generic 1 page.

Generic 2
Title:                                  This is the Title to the Generic 2 page.

Generic 3
Title:                                  This is the Title to the Generic 3 page.
What is the start date of the Generic 3 page?            01-Jun-2009
First type of tracked item is called?                        Item 1
Second type of tracked item is called?                       Item 2
sheet functions and is used to set variable values.
ut. On this sheet, you can define how the sheet functions.



                                            Version 3.01




                         Linking to Your AIM Tracking
To Link Your AIMTracking to your AIMAnalysis take the following steps:

1) Press Alt + F8 and select "ChangeLink" from the dialog box. Click "Run".
2) In the Edit Links Window that appears select the Change Source button
3) In the Change Source Window, browse to find your AIMTracking.xls file
4) Select your tracking file and click OK.
5) WAIT – this may take several minutes.
   Thousands of links are being established between the two files.
6) When the links are established the hourglass disappears – click Close
7) Press F9 to calculate new values (see bottom of screen for progress)
8) Save the file to establish the link permanently between your files

NOTE: If the above steps do not work, consult the “Linking Your AIMTracking.xls
     file to Your AIMAnalysis.xls(m) file” section in your User Guide for AIM
     Applications which outlines this process in greater detail




f of the AIM toolbar.


This area for office use only.

Collabrative Name:         Supplied by AIM Staff

Learning Session Completed:                    1.00




Security Issues
If you are having macro security or other security issues, please
see "The Initial Setup - Changing Your Security Settings" section
in the User Guide for AIM Applications.
You may download a copy of the User Guide for AIM Applications
(and other measurement tools & resources) at www.albertaaim.ca.
Primary
Specialty



Key
RN
LPN
MOA
Allied Prof
NA



Yes
No
                                                                                Short Delay Chart
    Start Date               End Date                            Line 1                    Line 2                       Line 3                           Line 4
    1-Mar-10                 19-Mar-10                           Clinic Average            None                         None                             None


                                                                               Short Delay Chart


           1
           1
           1
    Days




                                                                                                                                                                                       Clinic Average
           1
                                                                                                                                                                                       None
           0
                                                                                                                                                                                       None
           0                                                                                                                                                                           None
           0




                                                                                                                                 10-Mar-10




                                                                                                                                                              12-Mar-10


                                                                                                                                                                          13-Mar-10


                                                                                                                                                                                      14-Mar-10


                                                                                                                                                                                                  15-Mar-10
                                                                    5-Mar-10
                  1-Mar-10


                                2-Mar-10


                                           3-Mar-10


                                                      4-Mar-10




                                                                                6-Mar-10


                                                                                            7-Mar-10


                                                                                                          8-Mar-10


                                                                                                                     9-Mar-10




                                                                                                                                             11-Mar-10
                                                                                                       Timeline




Printed on 9/8/2010                                                                         Alberta AIM                                                                                                       DelayChart
                                                                                   Long Delay Chart
     Start Date              End Date                           Line 1                     Line 2                            Line 3                     Line 4
     1-Mar-10                19-Mar-10                          Clinic Average             None                              None                       None


                                                                            Long Delay Chart


           1
           1
           1
                                                                                                                                                                                            Clinic Average
  Days




           1
                                                                                                                                                                                            None
           0                                                                                                                                                                                None
           0                                                                                                                                                                                None

           0




                                                                                                                                            11-Mar-10




                                                                                                                                                                                14-Mar-10
                                                                                                                                10-Mar-10




                                                                                                                                                        12-Mar-10


                                                                                                                                                                    13-Mar-10




                                                                                                                                                                                               15-Mar-10
                  1-Mar-10


                               2-Mar-10


                                          3-Mar-10


                                                     4-Mar-10


                                                                 5-Mar-10


                                                                            6-Mar-10


                                                                                       7-Mar-10


                                                                                                       8-Mar-10

                                                                                                   Timeline       9-Mar-10




Printed on 9/8/2010                                                                               Alberta AIM                                                                                              DelayChart
             Provider 1
             Provider 2
                           Clinic Weekly Demand, Supply and Activity
             Provider 3
             Provider 4
                  1
             Provider 5
             Provider 6
             Provider 7
                  1
             Provider 8
             Provider 9
                  1
             Provider 10
             Provider 11
     Units




             Provider 12
                  1
             Provider 13
                                                                       Demand
             Provider 14
                  0
             Provider 15                                               Supply
             Clinic
                                                                       Activity
                 0

                 0



                                                    Date




Printed on 9/8/2010                         Alberta AIM                   DSA_Charts
                      Clinic Monday - D/S/A                             Clinic Monday - Demand Types and Totals
          1.2
                                                                  1.2
            1                                                       1
          0.8                                                     0.8
  Units




                                                          Units
          0.6                                                     0.6
          0.4                                                     0.4
          0.2                                                     0.2
            0                                                       0




                      Demand   Supply    Activity                                  Demand    Internal   External




Printed on 9/8/2010                                 Alberta AIM                                                    DSA_Charts
                      Clinic Tuesday - D/S/A                               Clinic Tuesday - Demand Types and Totals
          1.2                                                            1.2
            1                                                              1
          0.8                                                            0.8




                                                                 Units
  Units




          0.6                                                            0.6
          0.4                                                            0.4
          0.2                                                            0.2
            0                                                              0




                       Demand     Supply       Activity
                                                                                         Demand    Internal   External




Printed on 9/8/2010                                       Alberta AIM                                                    DSA_Charts
                      Clinic Wednesday - D/S/A                              Clinic Wednesday - Demand Types and Totals
           1.2
                                                                      1.2
             1
                                                                        1
           0.8                                                        0.8
   Units




                                                              Units
           0.6                                                        0.6
           0.4                                                        0.4
           0.2                                                        0.2
             0                                                          0




                        Demand     Supply   Activity
                                                                                       Demand     Internal   External




Printed on 9/8/2010                                    Alberta AIM                                                      DSA_Charts
                      Clinic Thursday - D/S/A                               Clinic Thursday - Demand Types and Totals

          1.2
                                                                      1.2
            1                                                           1
          0.8                                                         0.8
  Units




                                                              Units
          0.6                                                         0.6
          0.4                                                         0.4
          0.2                                                         0.2
            0                                                           0




                       Demand     Supply    Activity
                                                                                       Demand    Internal   External




Printed on 9/8/2010                                    Alberta AIM                                                      DSA_Charts
                      Clinic Friday - D/S/A                                    Clinic Friday - Demand Types and Totals

           1.2                                                           1.2
             1                                                             1
           0.8                                                           0.8




                                                                 Units
   Units




           0.6                                                           0.6
           0.4                                                           0.4
                                                                                                                         Demand
           0.2                                                           0.2
                                                                                                                         Internal
             0                                                             0
                                                                                                                         External




                      Demand     Supply       Activity




Printed on 9/8/2010                                      Alberta AIM                                                      DSA_Charts
                                              No Show Percentage




                                             0%
                                                  20%
                                                        40%
                                                              60%
                                                                    80%
                                                                          100%
                                                                                 120%




Printed on 9/8/2010
                                  1-Mar-10


                                  2-Mar-10


                                  3-Mar-10


                                  4-Mar-10


                                  5-Mar-10
                                                                                        Clinic Average




                                  6-Mar-10


                                  7-Mar-10
                                                                                        None




Alberta AIM
                                  8-Mar-10
                      Timeline
                                                                                                         No Show Chart




                                  9-Mar-10
                                                                                        None




                                 10-Mar-10


                                 11-Mar-10
                                                                                        None




                                 12-Mar-10


                                 13-Mar-10


                                 14-Mar-10


                                 15-Mar-10
NoShowChart
                                         Panel Chart

                                Clinic Total         None     None   None

                       1

                       1
   Number of Clients




                       1

                       1

                       0

                       0

                       0
                       Mar-10                                               Mar-10

                                                   Timeline




Printed on 9/8/2010                            Alberta AIM                    PanelChart
                                    Continuity Chart

                             Average Clinic          None    None   None

                120.0%

                100.0%
   Percentage




                80.0%

                60.0%

                40.0%

                20.0%

                 0.0%
                    Mar-10                                                 Mar-10
                                                  Timeline




Printed on 9/8/2010                           Alberta AIM                  ContinuityChart
                      Cycle Time for Short Appt
                             Cycle Time      None   None   None

              4:48

              0:00

            19:12
     Time




            14:24

              9:36

              4:48

              0:00




                                            Date




Printed on 9/8/2010                   Alberta AIM                 Cycle_Time_Summary
                       Clinic Average
                        (Short Appt)

                4:48

                0:00

              19:12
     Time




              14:24
                                           Cycle Time
                9:36                       Wait Time
                                           Red ZoneTime
                4:48
                                           Minutes Behind
                0:00




                                    Date




Printed on 9/8/2010          Alberta AIM        Cycle_Time_Summary
The copyright of this software is retained by the Alberta Medical Association (CMA Alberta Division) on beha
the Toward Optimized Practice (TOP) program and the Access Improve Measure (AIM) initiative.

You are free:
 to Share — to copy, distribute and transmit the work
 to Remix — to adapt the work

Under the following conditions:
· Attribution. You must attribute the work in the manner specified by the author or licensor (but not in any
that suggests that they endorse you or your use of the work).
· Noncommercial. You may not use this work for commercial purposes.
· Share Alike. If you alter, transform, or build upon this work, you may distribute the resulting work only un
the same or similar license to this one.

This software is derived from software provided by Mark Murray and Associates and later versions provided b
Chinook Health Region. We are grateful for their contribution. However, this in no way implies their endorse
or liability.

This license agreement is based on the Creative Commons licensing agreement found at http://creativecommons.org/lice
The AMA, TOP and AIM do not endorse in any way derivative or excerpted materials based on this software, a
cannot be held liable for the content or use of any such adapted products. The use of the AMA, TOP and AIM
or logo for the purposes of advertising or implied endorsement of any derived product or service is strictly
forbidden.
Although reasonable effort has been made to ensure the accuracy and completeness of this software, the AMA
accept no responsibility for errors or omissions and assumes no responsibility or liability for loss or damage
resulting from the use of information contained within.


              Created for the AIM project in Alberta, Canada.




       Original spreadsheet concept by Mark Murray & Associates.




                                    This analysis application is
                                     brought to you by Toward
                                   Optimized Practice of Alberta,
                                   Canada.     Inquires? Email:
                                  measurement@albertaaim.ca or
                                 randy.campbell@topalbertadoctor
                                               s.org
                                     This analysis application is
                                      brought to you by Toward
                                    Optimized Practice of Alberta,
                                    Canada.     Inquires? Email:
                                   measurement@albertaaim.ca or
                                  randy.campbell@topalbertadoctor
                                                s.org




Security Issues
If you are having macro security or other security issues, please
see "The Initial Setup - Changing Your Security Settings" section
in the User Guide for AIM Applications.
You may download a copy of the User Guide for AIM Applications
(and other measurement tools & resources) at www.albertaaim.ca.
A Alberta Division) on behalf of
AIM) initiative.




 or licensor (but not in any way


e the resulting work only under


 d later versions provided by the
o way implies their endorsement


ttp://creativecommons.org/licenses/by-nc-sa/2.5/ca/ .
als based on this software, and
f the AMA, TOP and AIM name
uct or service is strictly

of this software, the AMA can
bility for loss or damage

				
DOCUMENT INFO