{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Read First","Provider Names","PC Totals","Ideal Panel Size","TNA","Daily Measures","No Shows","Backlog Reduction","Summary Graphs","Copyright","DropDown"],"not_rendered":{"charts":10,"images":7,"macros":1,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":6},"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":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,1,3],[6,5,6,6],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,7,3],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[8,1,8,3],[7,5,16,6],[9,1,16,3],[18,1,18,6],[21,1,21,6],[20,1,20,6]]}
[null,"Access Measures Tracker"]
[]
[null,"Introduction",null,null,null,"Technical Instructions"]
[null,"Use this workbook to record, calculate, and visualize key measures for access improvement for one or more providers. This tool is also for those who just want to calculate ideal panel size.\n\nKey measures: Ideal panel size, and third next available appointment (TNA). \n\nThis workbook can track and calculate additional measures that may be helpful. These are:  No-shows;  daily demand, supply and activity; and backlog reduction.",null,null,null,"IMPORTANT: \n1. Open this file in the Desktop Version of Excel to enable all features. \n2. Click 'Enable Content'.\n3. Enable Macros in order to display the Summary Graphs\n\n\n\n\n\n\n"]
[null,"What is in each tab?",null,null,null,"Tips for entering data:\n"]
[null,"Provider names: This is where you enter the names of the provider(s) you are tracking. \n\nIdeal panel size: Calculate and compare ideal panel sizes.\n\nTNA: Record third next available appointment for each provider. If multiple values are collected over time, these will be visualized in the Summary Graphs tab.\n\nDaily Measures: Track daily demand, supply, and activity. These are not always needed. If multiple values are collected over time, these will be visualized in the Summary Graphs tab.\n\nNo-Shows: Calculate no-show rates. If multiple values are collected over time, these will be visualized in the Summary Graphs tab.\n\nBacklog Reduction: Calculate the impact of temporarily adding supply in order to reduce backlog.\n\nSummary Graphs: Generate run charts to visualize trends in TNA, daily measures and no-shows."]
[null,null,null,null,null,"Filtering Run Charts:"]
[]
[null,"Copyright"]
[null,"This work has been created by the Alberta Medical Association's Accelerating Change Transformation Team (ACTT) based on work from Alberta Health Services and a concept by Mark Murray & Associates.\t\n\nThis 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/ \t\n\t\t\t\t\nAlberta Medical Association expressly disclaims all liability for the use of these materials, and for any claims, actions, demands or suits arising from such use. The Alberta Medical Association 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":"Provider Names","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,3,5,7]]}
[null,"Please list your clinicians to be included below:"]
[]
[null,null,null,"What does this tab do?"]
[null,null,null,"The provider names you list in the green cells will appear as a dropdown list you can choose from for the tabs where measures are collected."]

{"sheet":"PC Totals","index":2,"n_rows":6,"n_cols":110,"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,"Average of Third Next Available (TNA)","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,null,"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","Supply.","Activity","Demand",null,null,null,null,null,null,null,null,null,null,null,"Row Labels","Average Supply","Average Activity",null,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)",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"(blank)",{"$error":"#NAME?"}]
["Grand Total",null,0,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$error":"#NAME?"}]

{"sheet":"Ideal Panel Size","index":3,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,11,7,19],[2,1,3,1],[2,11,2,13],[2,16,4,20],[8,11,40,19],[0,1,0,9],[1,1,1,9],[2,2,2,4],[2,8,2,9],[2,5,2,7]]}
[null,"Ideal Panel Size Calculator"]
[]
[null,"Provider","Annual Demand",null,null,"Annual Supply",null,null,"Panel Information",null,null,"Clinic Level"]
[null,null,"Current Panel Size","RVR \n(Average Visits to any family physician)","Patient Visits per Year","Average Appt Slots per Week","Weeks Worked per Year","Potential Appt Supply","Ideal Target Panel","Over (Under) Ideal Target",null,"Clinic Panel Size","Clinic Return Visit Rate","Clinic Ideal Panel Size"]
[null,{"$f":"_xlfn._xlws.FILTER('Provider Names'!B2:B200,'Provider Names'!B2:B200>1)","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(C5>0,C5*D5,\"\")","v":""},null,null,{"$f":"IF(B5>1,F5*G5,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C5>0,H5/D5,\"\")","v":""},{"$f":"IF(C5>0,C5-I5,\"\")","v":""},null,{"$f":"IF(SUM(C5:C51)>1,SUM(C5:C51),\"\")","v":""},{"$f":"IF(SUM(E5:E51)>0,(SUM(E5:E51))/(SUM(C5:C51)),\"\")","v":""},{"$f":"IF(SUM(H5:H51)>0,SUM(H5:H51)/M5,\"\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,{"$f":"IF(C6>0,C6*D6,\"\")","v":""},null,null,{"$f":"IF(B6>1,F6*G6,\"\")","v":""},{"$f":"IF(C6>0,H6/D6,\"\")","v":""},{"$f":"IF(C6>0,C6-I6,\"\")","v":""}]
[null,null,null,null,"",null,null,"","","",null,"Instructions:\n"]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","","",null,"For each row: \n1. Provider. Column B: The providers will be automatically brought in from the \"Provider Names\" tab.\n\n2. Current Panel Size. Column C: Enter the number of patients currently on the provider's panel. The Health Quality Council of Alberta (HQCA) Primary Healthcare Panel Report is a good source.This can also be obtained from the Electronic Medical Record (EMR).\n\n3. Return Visit Rate (RVR). Column D: Enter the average number of visits a patient has had with any family medicine physician in the past year. Use the \"Average visits to any family physician\" value from the HQCA Primary Healthcare Panel Report. \n\n4. Patient Visits per Year. Column E: Calculated for you. Annual demand. Shows the number of visits paneled patients require per year. Calculated as: Current Panel Size x RVR.\n\n5. Average Appointment Slots per Week. Column F: Using the clinic's EMR, enter the number of appointment slots offered by this provider in a typical week. \n\n6. Weeks Worked per Year. Column G: Using the clinic's EMR or calendar, enter the number of weeks in a year the provider is usually in the clinic. An estimate can be determined by starting with 52 weeks and subtracting vacations, statutory holidays, sick days, and other expected time away from the clinic.\n\n7. Potential Appointment Supply. Column H: Calculated for you. Annual demand. Estimates the supply of appointments in a year. Calculated as: Provider visits per week x weeks worked per year.\n\n8. Ideal Target Panel. Column I: Calculated for you. Identifies the provider's ideal panel size given the data provided. Calculated as: Potential Supply of Appointments / RVR.\n\n9. Over (Under) Ideal Target. Column J: Calculated for you. Shows if a provider is over or under panelled, based on their balance of demand & supply. Calculated as: Current Panel Size - Ideal Target Panel. \n\nNote: Consider revisiting this annually, unless something changes."]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]
[null,null,null,null,"",null,null,"","",""]

{"sheet":"TNA","index":4,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,4,4,5],[3,4,3,5],[0,0,0,2],[1,7,2,13],[3,7,14,13]]}
["TNA Tracker",null,null,null,"Use this to calculate number of days if needed"]
["Date","Provider","Third Next Available (TNA)",null,"Date of measurement:","Date of TNA:",null,"Instructions"]
[null,null,null,null,"2024-11-05","2024-11-06"]
[null,null,null,null,"Number of days",null,null,"For each row: \n1. Date. Column A: Enter the date. Format: dd-MON-yy. Eg. 18 Jan 25\n2. Provider. Column B: Select provider from the dropdown list\n3. Third Next Available. Column C: Using the clinic's EMR, count the days until the third open appointment slot, with today being zero, and include days the clinic is closed. The time slot counted should be for the typical or shortest appointment slot, excluding carve-outs.  \n\nTo track trends over time, enter future values in the rows below, measuring the same day and time each week, and your results can be viewed as a run chart by clicking on the Summary Graphs tab."]
[null,null,null,null,{"$f":"F3-E3","v":1}]

{"sheet":"Daily Measures","index":5,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,9,2,16],[0,0,0,6],[3,9,19,16]]}
["Daily Measurement Tracker"]
["Date","Provider","Demand","Supply","Activity","Day","Activity:\nTotal",null,null,"Instructions"]
[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]]),\"\",Table1[[#This Row],[Activity]])","v":""}]
[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]]),\"\",Table1[[#This Row],[Activity]])","v":""},null,null,"Note: Tracking daily demand, supply, and activity is optional.  It may be useful in diagnosing your clinic and showing the impact of change. Measure at the end of the day.\n\nFor each row: \n1. Date. Column A: Enter the date. Format: dd-MON-yy. Eg. 18 Jan 25\n2. Provider. Column B: Select provider from the dropdown list\n3. Demand. Column C: Measured by counting the number of time slots of appointments booked today, regardless of when the appointment is booked for, or who booked it. This could be captured by a team member manually making a mark for each appointment request throughout the day, either on a spreadsheet or paper. \n4. Supply. Column D: Using the clinic's EMR, add up the number of time slots offered today. The time slot counted should be for the typical or shortest appointment slot, excluding carve-outs. \n5. Activity. Column E: Using the clinic's EMR, add up the number of time slots used today. The time slot counted should be for the typical or shortest appointment slot.\n\nTo track trends over time, enter future values in the rows below, and your results can be viewed as a run chart by clicking on the Summary Graphs tab."]
[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]]),\"\",Table1[[#This Row],[Activity]])","v":""}]
[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]]),\"\",Table1[[#This Row],[Activity]])","v":""}]
[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]]),\"\",Table1[[#This Row],[Activity]])","v":""}]

{"sheet":"No Shows","index":6,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,10,2,15],[3,10,16,15]]}
["No-Show Tracker"]
["Date","Provider","Count of No Shows","Count of Total Appointments","No Show Rate","No-Show Rate","Day",null,null,null,"Instructions"]
[null,null,null,null,{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$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,{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(ISBLANK(Table36[[#This Row],[Date]]),\"\",TEXT(Table36[[#This Row],[Date]],\"ddd\"))","v":""},null,null,null,"For each row:\n1. Date. Column A: Enter the date. Format: dd-MON-yy. Eg. 18 Jan 25\n2. Provider. Column B: Select provider from the dropdown list\n3.Count of No Shows. Column C: Using the clinic's EMR, enter the number of no-shows for your selected time period. eg. a day,  a week or a month.\n4. Count of Total Appointments. Column D: Using the clinic's EMR, enter the number of booked appointments for the same time period. \n5. No Show Rate. Column E: This is calculated for you as a percentage. \n\nIf you want to track progress or trends over time, enter future values in the rows below, and your results can be viewed as a run chart by clicking on the Summary Graphs tab."]
[null,null,null,null,{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(ISBLANK(Table36[[#This Row],[Date]]),\"\",TEXT(Table36[[#This Row],[Date]],\"ddd\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Average of No-Show Rate","Column Labels"]
[null,null,null,null,{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(ISBLANK(Table36[[#This Row],[Date]]),\"\",TEXT(Table36[[#This Row],[Date]],\"ddd\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Row Labels","(blank)","Grand Total"]
[null,null,null,null,{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(ISBLANK(Table36[[#This Row],[Date]]),\"\",TEXT(Table36[[#This Row],[Date]],\"ddd\"))","v":""},null,null,null,null,null,null,null,null,null,null,"(blank)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(Table36[[#This Row],[Date]]>0,Table36[[#This Row],[Count of No Shows]]/Table36[[#This Row],[Count of Total Appointments]],\"\")","v":""},{"$f":"IF(ISBLANK(Table36[[#This Row],[Date]]),\"\",TEXT(Table36[[#This Row],[Date]],\"ddd\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Grand Total",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Backlog Reduction","index":7,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,5,2,9],[3,10,4,17],[5,10,24,17]]}
["Backlog Reduction Calculator"]
[]
[null,null,"GOAL TNA:",3]
[null,null,null,null,null,null,null,null,null,null,"Instructions"]
[]
["Provider","Date of Most Recent TNA","Most Recent TNA","TNA \n(Only if TNA tab not filled out)","Average scheduled appointments per day","Extra Appointments needed to meet goal TNA","How many extra appts will you add per day?","Clinic days it will take to reach goal",null,null,"IMPORTANT: Providers should first ensure they have balanced their supply and demand for appointments prior to implementing backlog reduction strategies.  This will prevent backlog from reappearing and can help with the number of extra appointments you need to add to reach your goal.\n\n1. Goal TNA. Cell D3: Enter your goal TNA (in days) in Cell D3.\nFor each row:\n2. Provider. Column A: The providers will be automatically brought in from the \"Provider Names\" tab.\n3. Date of Most Recent TNA. Column B: Filled in for you if you have  been using the TNA tab. \n4. Most Recent TNA. Column C: Filled in for you if you have  been using the TNA tab. \n5. TNA. Column D: Only use if you have not been using the TNA tab.\n6. Average Scheduled Appointments Per Day. Column E: Using the clinic's EMR, select a typical day and add up the number of time slots offered. The time slot counted should be for the typical or shortest appointment slot, excluding carve-outs\n7. Extra Appointments Needed to Meet Goal TNA. Column F: Calculated for you.\n8. How many extra Appointments will you add per day. Column G: Enter the number of extra appointment slots the provider is willing to add per day. Can play around with this number.\n9. Clinic days it will take to reach goal Column H: Calculated for you.\n\n"]
[{"$f":"_xlfn._xlws.FILTER('Provider Names'!B2:B200,'Provider Names'!B2:B200>1)","v":{"$error":"#VALUE!"}},{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A7)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A7))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A7)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B7)*(Table3[Provider]:Table3[Provider]=A7),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,{"$f":"IF(A7>0,IF(ISBLANK(D7),(C7-$D$3)*E7,(D7-$D$3)*E7),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(A7>0,IF(G7>0,F7/G7,\"\"),\"\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!#REF!)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!#REF!))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!#REF!)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B8)*(Table3[Provider]:Table3[Provider]=#REF!),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,{"$f":"IF(A8>0,IF(ISBLANK(D8),(C8-$D$3)*E8,(D8-$D$3)*E8),\"\")","v":""},null,{"$f":"IF(A8>0,IF(G8>0,F8/G8,\"\"),\"\")","v":""}]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A9)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A9))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A9)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B9)*(Table3[Provider]:Table3[Provider]=A9),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,{"$f":"IF(A9>0,IF(ISBLANK(D9),(C9-$D$3)*E9,(D9-$D$3)*E9),\"\")","v":""},null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A10)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A10))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A10)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B10)*(Table3[Provider]:Table3[Provider]=A10),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A11)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A11))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A11)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B11)*(Table3[Provider]:Table3[Provider]=A11),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A12)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A12))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A12)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B12)*(Table3[Provider]:Table3[Provider]=A12),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A13)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A13))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A13)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B13)*(Table3[Provider]:Table3[Provider]=A13),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A14)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A14))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A14)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B14)*(Table3[Provider]:Table3[Provider]=A14),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A15)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A15))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A15)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B15)*(Table3[Provider]:Table3[Provider]=A15),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A16)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A16))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A16)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B16)*(Table3[Provider]:Table3[Provider]=A16),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A17)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A17))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A17)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B17)*(Table3[Provider]:Table3[Provider]=A17),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A18)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A18))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A18)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B18)*(Table3[Provider]:Table3[Provider]=A18),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A19)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A19))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A19)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B19)*(Table3[Provider]:Table3[Provider]=A19),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A20)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A20))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A20)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B20)*(Table3[Provider]:Table3[Provider]=A20),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A21)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A21))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A21)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B21)*(Table3[Provider]:Table3[Provider]=A21),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A22)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A22))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A22)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B22)*(Table3[Provider]:Table3[Provider]=A22),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A23)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A23))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A23)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B23)*(Table3[Provider]:Table3[Provider]=A23),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A24)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A24))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A24)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B24)*(Table3[Provider]:Table3[Provider]=A24),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A25)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A25))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A25)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B25)*(Table3[Provider]:Table3[Provider]=A25),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A26)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A26))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A26)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B26)*(Table3[Provider]:Table3[Provider]=A26),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A27)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A27))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A27)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B27)*(Table3[Provider]:Table3[Provider]=A27),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A28)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A28))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A28)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B28)*(Table3[Provider]:Table3[Provider]=A28),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A29)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A29))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A29)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B29)*(Table3[Provider]:Table3[Provider]=A29),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A30)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A30))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A30)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B30)*(Table3[Provider]:Table3[Provider]=A30),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A31)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A31))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A31)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B31)*(Table3[Provider]:Table3[Provider]=A31),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A32)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A32))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A32)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B32)*(Table3[Provider]:Table3[Provider]=A32),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A33)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A33))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A33)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B33)*(Table3[Provider]:Table3[Provider]=A33),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A34)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A34))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A34)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B34)*(Table3[Provider]:Table3[Provider]=A34),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A35)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A35))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A35)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B35)*(Table3[Provider]:Table3[Provider]=A35),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A36)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A36))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A36)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B36)*(Table3[Provider]:Table3[Provider]=A36),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A37)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A37))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A37)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B37)*(Table3[Provider]:Table3[Provider]=A37),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A38)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A38))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A38)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B38)*(Table3[Provider]:Table3[Provider]=A38),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A39)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A39))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A39)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B39)*(Table3[Provider]:Table3[Provider]=A39),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A40)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A40))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A40)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B40)*(Table3[Provider]:Table3[Provider]=A40),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A41)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A41))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A41)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B41)*(Table3[Provider]:Table3[Provider]=A41),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A42)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A42))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A42)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B42)*(Table3[Provider]:Table3[Provider]=A42),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A43)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A43))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A43)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B43)*(Table3[Provider]:Table3[Provider]=A43),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A44)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A44))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A44)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B44)*(Table3[Provider]:Table3[Provider]=A44),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A45)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A45))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A45)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B45)*(Table3[Provider]:Table3[Provider]=A45),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A46)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A46))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A46)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B46)*(Table3[Provider]:Table3[Provider]=A46),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A47)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A47))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A47)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B47)*(Table3[Provider]:Table3[Provider]=A47),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A48)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A48))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A48)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B48)*(Table3[Provider]:Table3[Provider]=A48),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A49)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A49))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A49)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B49)*(Table3[Provider]:Table3[Provider]=A49),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A50)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A50))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A50)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B50)*(Table3[Provider]:Table3[Provider]=A50),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A51)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A51))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A51)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B51)*(Table3[Provider]:Table3[Provider]=A51),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A52)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A52))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A52)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B52)*(Table3[Provider]:Table3[Provider]=A52),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A53)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A53))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A53)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B53)*(Table3[Provider]:Table3[Provider]=A53),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A54)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A54))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A54)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B54)*(Table3[Provider]:Table3[Provider]=A54),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A55)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A55))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A55)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B55)*(Table3[Provider]:Table3[Provider]=A55),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A56)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A56))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A56)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B56)*(Table3[Provider]:Table3[Provider]=A56),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A57)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A57))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A57)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B57)*(Table3[Provider]:Table3[Provider]=A57),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A58)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A58))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A58)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B58)*(Table3[Provider]:Table3[Provider]=A58),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A59)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A59))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A59)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B59)*(Table3[Provider]:Table3[Provider]=A59),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A60)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A60))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A60)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B60)*(Table3[Provider]:Table3[Provider]=A60),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A61)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A61))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A61)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B61)*(Table3[Provider]:Table3[Provider]=A61),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A62)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A62))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A62)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B62)*(Table3[Provider]:Table3[Provider]=A62),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A63)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A63))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A63)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B63)*(Table3[Provider]:Table3[Provider]=A63),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A64)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A64))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A64)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B64)*(Table3[Provider]:Table3[Provider]=A64),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A65)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A65))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A65)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B65)*(Table3[Provider]:Table3[Provider]=A65),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A66)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A66))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A66)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B66)*(Table3[Provider]:Table3[Provider]=A66),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A67)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A67))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A67)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B67)*(Table3[Provider]:Table3[Provider]=A67),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A68)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A68))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A68)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B68)*(Table3[Provider]:Table3[Provider]=A68),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A69)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A69))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A69)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B69)*(Table3[Provider]:Table3[Provider]=A69),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A70)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A70))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A70)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B70)*(Table3[Provider]:Table3[Provider]=A70),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A71)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A71))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A71)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B71)*(Table3[Provider]:Table3[Provider]=A71),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A72)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A72))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A72)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B72)*(Table3[Provider]:Table3[Provider]=A72),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,{"$f":"IF(A72>0,IF(ISBLANK(D72),(C72-$D$3)*E72,(D72-$D$3)*E72),\"\")","v":""},null,{"$f":"IF(A72>0,IF(G72>0,F72/G72,\"\"),\"\")","v":""}]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A73)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A73))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A73)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B73)*(Table3[Provider]:Table3[Provider]=A73),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A74)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A74))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A74)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B74)*(Table3[Provider]:Table3[Provider]=A74),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A75)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A75))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A75)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B75)*(Table3[Provider]:Table3[Provider]=A75),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A76)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A76))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A76)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B76)*(Table3[Provider]:Table3[Provider]=A76),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A77)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A77))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A77)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B77)*(Table3[Provider]:Table3[Provider]=A77),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A78)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A78))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A78)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B78)*(Table3[Provider]:Table3[Provider]=A78),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A79)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A79))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A79)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B79)*(Table3[Provider]:Table3[Provider]=A79),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A80)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A80))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A80)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B80)*(Table3[Provider]:Table3[Provider]=A80),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A81)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A81))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A81)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B81)*(Table3[Provider]:Table3[Provider]=A81),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A82)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A82))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A82)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B82)*(Table3[Provider]:Table3[Provider]=A82),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A83)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A83))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A83)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B83)*(Table3[Provider]:Table3[Provider]=A83),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A84)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A84))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A84)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B84)*(Table3[Provider]:Table3[Provider]=A84),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A85)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A85))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A85)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B85)*(Table3[Provider]:Table3[Provider]=A85),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A86)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A86))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A86)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B86)*(Table3[Provider]:Table3[Provider]=A86),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A87)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A87))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A87)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B87)*(Table3[Provider]:Table3[Provider]=A87),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A88)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A88))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A88)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B88)*(Table3[Provider]:Table3[Provider]=A88),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A89)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A89))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A89)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B89)*(Table3[Provider]:Table3[Provider]=A89),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A90)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A90))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A90)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B90)*(Table3[Provider]:Table3[Provider]=A90),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A91)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A91))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A91)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B91)*(Table3[Provider]:Table3[Provider]=A91),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A92)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A92))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A92)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B92)*(Table3[Provider]:Table3[Provider]=A92),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A93)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A93))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A93)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B93)*(Table3[Provider]:Table3[Provider]=A93),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A94)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A94))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A94)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B94)*(Table3[Provider]:Table3[Provider]=A94),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A95)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A95))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A95)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B95)*(Table3[Provider]:Table3[Provider]=A95),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A96)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A96))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A96)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B96)*(Table3[Provider]:Table3[Provider]=A96),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A97)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A97))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A97)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B97)*(Table3[Provider]:Table3[Provider]=A97),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A98)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A98))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A98)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B98)*(Table3[Provider]:Table3[Provider]=A98),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A99)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A99))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A99)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B99)*(Table3[Provider]:Table3[Provider]=A99),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A100)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A100))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A100)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B100)*(Table3[Provider]:Table3[Provider]=A100),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A101)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A101))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A101)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B101)*(Table3[Provider]:Table3[Provider]=A101),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A102)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A102))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A102)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B102)*(Table3[Provider]:Table3[Provider]=A102),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A103)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A103))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A103)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B103)*(Table3[Provider]:Table3[Provider]=A103),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A104)=0,\"\",_xlfn.MAXIFS(Table3[Date]:Table3[Date],Table3[Provider]:Table3[Provider],'Backlog Reduction'!A104))","v":""},{"$f":"IF(COUNTIF(Table3[Provider]:Table3[Provider],'Backlog Reduction'!A104)>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B104)*(Table3[Provider]:Table3[Provider]=A104),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""},null,null,"",null,""]
[null,{"$f":"IF(A105>0,_xlfn.MAXIFS(Table3[[#This Row],[Date]]:Table3[Date],Table3[[#This Row],[Provider]]:Table3[Provider],'Backlog Reduction'!A105),\"\")","v":""},{"$f":"IF(A105>0,(_xlfn.XLOOKUP(1,(Table3[Date]:Table3[Date]=B105)*(Table3[Provider]:Table3[Provider]=A105),Table3[Third Next Available (TNA)]:Table3[Third Next Available (TNA)])),\"\")","v":""}]

{"sheet":"Summary Graphs","index":8,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["TNA & No-Show Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,"<---- Click grey button each time you update any data "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Demand, Supply, Activity"]

{"sheet":"Copyright","index":9,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"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":10,"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"]