{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Read First","Clinic Type and Providers","PC Totals","Primary Care TNA","Primary Care DSA","Specialty Care TNA","Specialty Care DSA","No Show","SC Totals","Primary Care Summary","Specialty Care Summary","Copyright","DropDown"],"not_rendered":{"charts":25,"images":7,"macros":1,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":12},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read First","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,3,2,4]]}
[]
[null,null,"If you see a yellow bar at the top of your screen such as this, click on \"Enable Content\"."]
["Data Tracking",null,null,"This Excel Workbook"]
["What data should I be tracking?","AIM considers a few measures the vital signs of a clinic.  They include:\n- Demand, Supply, Activity (DSA)\n- Third Next Available Appointment (TNA)\n- No-Show Rate\n\nAIM recommends that these measures be tracked routinely by all clinics.\n\nThere are other tools available on AIM Alberta's website for other measures such as Care Team Workload Analysis, Cycle Times, and Octane.",null,"What is the purpose of this tool?","This Excel workbook provides a place to enter the data and visualize your data using graphs.  "]
[]
["Why track these measures?","These measures, looked at together, can provide detail on access for a clinic.\n\nDemand, Supply, Activity\n\nSupply must equal, or be greater than, demand for a clinic to be able to run without increasing delay.  A gap between Supply and Activity can mean that there is appointment time that is going unutilized.\n\nThird Next Available Appointment (TNA)\n\nTNA is a measure of a provider's capacity to book an appointment.\n\nNo Show Rate\n\nNo-shows generate waste within a system.  Understanding the no-show rate can help target approaches to minimize no-shows.",null,"What steps do I take to use this tool?","1. Use the \"Clinic Type and Providers\" tab to select the if your clinic is Primary Care or Specialty Care.\n2. Enter the names of the clinicians who offer appointments (eg. physicians) on the \"Clinic Type and Providers\" tab.\n3. Enter the applicable data on the green coloured tabs.\n4. Use the \"Summary\" tab to visualize your data, find answers to your questions, and generate conversations with your team.  To update the graphs, click the \"Update all Graphs\" button on the \"Summary Tab\". \n"]
[]
["How do I track this data?","Information on tracking each measure for primary and specialty care, as well as templates for collecting them, can be found on the AIM website at the following web address:\n\nhttps://aimalberta.ca/too/resources/resource-library/access-improvement-work/measurement/ \n",null,"Each graph will have grey boxes where you can filter your data.\n   Click on these boxes to choose what data you want to see"]
[]
["What are some tips or keys to success?","Demand, Supply, and Activity, as well as no-show rates should be collected daily.\n\nTNA is measured weekly and should be measured at the same time, on the same day of each week and is measured in calendar days (including days the clinic is not open). "]

{"sheet":"Clinic Type and Providers","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,8,2,12],[3,8,7,12]]}
["This clinic is:",null,null,null,"Please list your clinicians to be included below:"]
[null,null,null,null,null,null,null,null,"Tips and Tricks"]
[]
[null,null,null,null,null,null,null,null,"1. Select your clinic type using the dropdown menu in cell B1.\n\n2. Enter the names of the clinicians who run appointments into the cells starting in E2."]

{"sheet":"PC Totals","index":2,"n_rows":6,"n_cols":110,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Provider","(All)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Provider","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,"Provider","(blank)",null,null,null,null,null,null,null,null,"TNA for Short","Column Labels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TNA: Long","Column Labels"]
["Day","(All)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,"Day",null,null,null,null,null,null,null,null,null,"Row Labels","(blank)","Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row Labels","(blank)","Grand Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank)"]
["Row Labels","Demand","Supply.","Activity",null,null,null,null,null,null,null,null,null,null,null,"Row Labels","Average Demand","Average Supply","Average Activity",null,null,null,null,null,null,null,null,null,null,"Row Labels","Percent of Demand which is Internal",null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total"]
["(blank)",0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",0,null,0,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$error":"#DIV/0!"}]

{"sheet":"Primary Care TNA","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,7,1,11],[2,7,6,11],[8,7,9,11]]}
["Date","Provider","Third Next Available (TNA):\nShort","Third Next Available (TNA):\nLong",null,null,null,"Tips and Tricks"]
[]
[null,null,null,null,null,null,null,"Check out the information on tracking TNA at the following link: \nhttps://aimalberta.ca/too/wp-content/uploads/Primary-Care-Delay-TNA-What-Why-How.pdf"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Want a collection template?"]
[null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/PC-Delay_Coll-TAM_FINAL.pdf"]
[]
[]
[null,null,null,null,null,null,null,"To continue entering data you can do one of two things:"]

{"sheet":"Primary Care DSA","index":4,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[[19,14,19,18],[20,14,22,18],[23,14,23,18],[24,14,25,18],[10,14,10,18],[11,14,11,18],[12,14,14,18],[15,14,15,18],[16,14,17,18],[18,14,18,18],[8,14,9,18],[0,14,1,18],[2,14,2,18],[3,14,3,18],[4,14,6,18],[7,14,7,18]]}
["Date","Provider","Demand:\nInternal","Demand: External","Supply","Activity:\nInternal","Activity:\nExternal","Day","Demand: Total","Activity:\nTotal",null,null,null,null,"Tips and Tricks"]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Date]]),\"\",TEXT(Table1[[#This Row],[Date]],\"ddd\"))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Date]]),\"\",SUM(Table1[[#This Row],[Demand:\nInternal]:[Demand: External]]))","v":""},{"$f":"IF(ISBLANK(Table1[Date]),\"\",SUM(Table1[[#This Row],[Activity:\nInternal]:[Activity:\nExternal]]))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Demand: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on the measure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/AIM-Demand-Measurement_PC.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Template:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/PC-Demand_Coll-TAM_FINAL.pdf"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Supply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on the measure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/AIM-Supply-Measurement_PC.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Template:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/PC-Supply_Coll-FINAL.pdf"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Activity:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on the measure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/AIM-Activity-Measurement_PC.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Template:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/PC-Activity_Weekly-calculation-sheet.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To continue entering data you can do one of two things:"]

{"sheet":"Specialty Care TNA","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,7,1,11],[2,7,6,11],[8,7,9,11],[7,7,7,11]]}
["Date","Provider","Third Next Available (TNA):\nNew","Third Next Available (TNA):\nReturn",null,null,null,"Tips and Tricks"]
[]
[null,null,null,null,null,null,null,"Check out the information on tracking TNA at the following link: \nhttps://aimalberta.ca/too/wp-content/uploads/Specialty-Care-Delay-TNA-What-Why-How-v2-hm.pdf"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Want collection templates?"]
[null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/SC-Delay_Coll.docx"]
[]
[]
[null,null,null,null,null,null,null,"To continue entering data you can do one of two things:"]

{"sheet":"Specialty Care DSA","index":6,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[[18,14,18,18],[19,14,19,18],[20,14,22,18],[23,14,23,18],[24,14,25,18],[11,14,11,18],[12,14,14,18],[7,14,7,18],[15,14,15,18],[16,14,17,18],[10,14,10,18],[0,14,1,18],[2,14,2,18],[3,14,3,18],[4,14,6,18],[8,14,9,18]]}
["Date","Provider","Demand:\nNew","Demand: Return","Supply:\nNew","Supply:\nReturn","Activity:\nNew","Activity:\nReturn","Day","Demand: Total","Supply:\nTotal","Activity:\nTotal",null,null,"Tips and Tricks"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table13[[#This Row],[Date]]),\"\",TEXT(Table13[[#This Row],[Date]],\"ddd\"))","v":""},{"$f":"IF(ISBLANK(Table13[[#This Row],[Date]]),\"\",SUM(Table13[[#This Row],[Demand:\nNew]:[Demand: Return]]))","v":""},{"$f":"IF(ISBLANK(Table13[[#This Row],[Date]]),\"\",SUM(Table13[[#This Row],[Supply:\nNew]:[Supply:\nReturn]]))","v":""},{"$f":"IF(ISBLANK(Table13[[#This Row],[Date]]),\"\",SUM(Table13[[#This Row],[Activity:\nNew]:[Activity:\nReturn]]))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Demand: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on the measure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/AIM-Demand-Measurement_SC.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Template:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/SC-Demand_Coll.docx"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Supply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on the measure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/AIM-Supply-Measurement_PC.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Template:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/SC-Supply_Coll.docx"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Activity:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information on the measure:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/Measurement-Cheat-Sheet-83KB.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Template:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aimalberta.ca/too/wp-content/uploads/SC-Activity_Coll.docx"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To continue entering data you can do one of two things:"]

{"sheet":"No Show","index":7,"n_rows":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,8,1,12],[2,8,6,12]]}
["Date","Provider","No Shows","Total Appointments","Day",null,null,null,"Tips and Tricks"]
[null,null,null,null,{"$f":"IF(ISBLANK(Table36[[#This Row],[Date]]),\"\",TEXT(Table36[[#This Row],[Date]],\"ddd\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Day"]
[null,null,null,null,null,null,null,null,"Check out the information on tracking TNA at the following link: \nhttps://aimalberta.ca/too/wp-content/uploads/AIM-No-Show-Measurement.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate","Column Labels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row Labels","(blank)","Grand Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,"To continue entering data you can do one of two things:"]

{"sheet":"SC Totals","index":8,"n_rows":6,"n_cols":104,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Provider","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Provider","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,"Provider","(blank)",null,null,null,null,null,null,null,null,null,null,null,"Provider","(blank)",null,null,null,null,null,null,null,null,null,null,"TNA: New","Column Labels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TNA: Return","Column Labels"]
["Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,"Day",null,null,null,null,null,null,null,null,null,null,null,null,"Day",null,null,null,null,null,null,null,null,null,null,null,"Row Labels","(blank)","Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row Labels","(blank)","Grand Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank)"]
["Row Labels","Demand","Supply","Activity",null,null,null,null,null,null,null,null,null,null,null,"Row Labels","Average Demand","Average Supply","Average Activity",null,null,null,null,null,null,null,null,null,null,"Row Labels","Demand for New","Suppy for New","Activity for New",null,null,null,null,null,null,null,null,null,"Row Labels","Demand for Return","Supply for Return","Activity for Return",null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total"]
["(blank)",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,null,null,null,null,null,null,null,null,null,null,null,"(blank)"]
["Grand Total",0,0,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",0,0,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total"]

{"sheet":"Primary Care Summary","index":9,"n_rows":69,"n_cols":1,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Third Next Available Appointment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Demand, Supply, Activity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["No Show Rate"]

{"sheet":"Specialty Care Summary","index":10,"n_rows":67,"n_cols":1,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Third Next Available Appointment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Demand, Supply, Activity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["No Show Rate"]

{"sheet":"Copyright","index":11,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["This work has been created by AIM Alberta (A department within Alberta Health Services) based on a concept by Mark Murray & Associates."]
[]
[]
[]
[]
[]
[]
["This work is licensed under the Creative Commons Attribution-NonCommercial 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc/4.0/ or send a letter to Creative Commons, PO Box 1866, Mountain View, CA 94042, USA."]
[]
[]
[]
[]
["You are free to use and edit this product.  You may share this work as long as you distribute the work on the same terms, and do not sell the product. You must attribute the original work to Alberta Health Services in a way that does not suggest that Alberta Health Services endorses you, or your use of the product.  If you alter the product to improve it, we ask that you share it with AIM Alberta at Measurement.AIM@AHS.ca so that the product can continue to improve.  When sharing the improved version back with AIM Alberta please describe the changes made."]
[]
["Copyright © (2020) Alberta Health Services. This material is protected by Canadian and other international copyright laws. All rights reserved.  This material is intended for general information only and is provided on an \"as is\", \"where is\" basis. Although reasonable efforts were made to confirm the accuracy of the information, Alberta Health Services does not make any representation or warranty, express, implied or statutory, as to the accuracy, reliability, completeness, applicability or fitness for a particular purpose of such information. This material is not a substitute for the advice of a qualified health professional. Alberta Health Services expressly disclaims all liability for the use of these materials, and for any claims, actions, demands or suits arising from such use."]
[]
["Alberta Health Services does not endorse, in any way, derivative or excerpted materials based on this product and cannot be held accountable for any such adapted product."]

{"sheet":"DropDown","index":12,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Appointment Types",null,null,"Clinic Type"]
["Primary","Specialty",null,"Primary Care"]
["Internal","New",null,"Specialty Care"]
["External","Return"]