{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["List","Guidance","Cancellations Log","Virtual- F2F","Top 10 Items","OLDEST & OUTSTANDING CASES","MI Summary","MI Graphs"],"not_rendered":{"charts":9,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":2,"pivot_tables":0},"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":"List","index":0,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,7,0,10],[0,0,0,3]]}
["Cancellations log",null,null,null,null,"O & O Cases ",null,"Virtual F2F"]
["Contact Method","Reason for Assessment Cancellation","Cancelled By","Rereferral Required ",null,"Reasons for Delay",null,"Change of Method of Contact","Reason for change","Stage in process assessment type changed?","Changed By"]
["Email","Could Not Confirm Assessment ","Customer","Yes",null,"Booked outside KPI due to volume of referrals ",null,"Virtual to F2F","Incorrect assessment type submitted","Incorrect assessment type submitted","Customer"]
["Phone","Forgotten","Employer","No",null,"svsdvs",null,"F2F to Virtual","Customer requested change before booking call","Before Assesment","Assessor"]
["Text","Holiday","Adviser",null,null,null,null,null,"Customer availability","During - Booking","CM"]
["Post","In correct Address","Assessor",null,null,null,null,null,"Customer requested change during booking call","At Assesment"]
["In Person","Medical Appt","No Contact",null,null,null,null,null,"Customer requested change during booking call due to being off work currently"]
[null,"Meeting",null,null,null,null,null,null,"Customer requested change during booking call due to assessor needed on site"]
[null,"No Assessor availability",null,null,null,null,null,null,"Assessor suggested change following discussion"]
[null,"NO SHOW",null,null,null,null,null,null,"Assessor availability"]
[null,"Sickness"]
[null,"Customer FTA"]
[null,"No NAR received by end of day 2"]
[null,"Referred in error"]

{"sheet":"Guidance","index":1,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,1,36,4],[43,1,43,4],[15,2,15,4],[16,1,16,4],[23,1,23,4],[30,1,30,4],[13,1,13,4],[3,2,3,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[]
[null,null,"Guidance ",null,"Version.1 June 2023"]
[]
[null,null,"Key Points"]
[null,"Key to scheduling the assessment with the customer is to ensure that it takes place as quickly as possible but takes into account the availability of all parties to be involved. We expect you to:"]
[null," Contact the Access to Work customer within two (2) working days of receipt of a Referral Form from DWP (not including weekends or public holidays) to arrange a date and time for the Holistic Assessment"]
[null," Offer the customer at least 5 appointment slots within the timeframe specified in your contract"]
[null," Keep a record of all appointments offered to the customer"]
[null," The Supplier makes at least 2 attempts within the first working day after Referral to contact the Customer to schedule the Assessment. If unsuccessful, a further attempt should be made on the second working day following referral."]
[null," In making these attempts the Supplier will ensure that the attempts to contact the customer are made at different times of the day, to avoid conflicting with regular scheduled commitments the Customer may have (e.g.: school run)"]
[null," Use a variety of communication methods (e.g.: - mobile phone, landline, email, whichever is the customer’s preferred method) "]
[null," If you are unable to contact the customer within the first two (2) working days, you should inform the Access to Work Case Manager by phone or email detailing the dates and means used when trying to contact the customer. The Access to Work Case Manager will contact the customer and advise them to contact you to schedule an appointment. You will send the referral back to the Access to Work Case Manager if the customer doesn't contact you."]
[null,"Please find below link to Action to Work Provider guidance"]
[null," https://www.gov.uk/government/publications/access-to-work-holistic-assessments-provider-guidance "]
[]
[null,null,"Annexe D Completion Notes"]
[null,"Cancellation Log"]
[null,"Input URN number, referral date and for each contact made the time and date of contact."]
[null,"For the Contact Method use the dropdown menu available. "]
[null,"Fill in the date for each assessment appointment made."]
[null,"If cancelled use the drop down to give the reason why, input the PRaP cancellation code, who cancelled from the dropdown and the cancellation date."]
[null,"RE-Referral required or not choose yes or no from the dropdown menu. If no complete the free text reason field."]
[]
[null,"Virtual - F2F"]
[null,"To be completed when changing the customers preference for being assessed."]
[null,"Complete URN Number and referral date. Use drop down to specify customers original choice and new method."]
[null,"Input the date of change and use drop down to give the reason for the change."]
[null,"Complete when in the process the change occurred using the drop down menu and then the menu for who made the change. "]
[]
[]
[null,"Top 10 Items "]
[null,"For each month list the top ten solutions used, in order, using the drop down menu provided."]
[]
[]
[]
[]
[null,"Oldest & Outstanding Cases"]
[null,"Input the Completion date and the total number of cases currently outstanding"]
[null,"Under Case Details list the cases that are now outside the KPI."]
[null,"URN Number, referral date, number of days elapsed since referral."]
[null,"Use the drop down menu to give the reason for the delay."]
[]
[]
[null,"MI Summary and Graphs"]
[null,"The Management Information listed here is gathered from the previous tabs but those not on the tabs need manual entries."]
[null,"Complaints and Rework cases: Input the figures in the relevant rows. "]
[null,"Graphs are produced automatically from the information from the MI Summary tab."]

{"sheet":"Cancellations Log","index":2,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6],[3,18,3,19],[3,9,3,13],[3,3,3,8],[3,14,3,17],[3,1,3,2]]}
[]
[null,"Cancellations Log ",null,null,"Month:","2023-01-01"]
[]
[null,"Referral Details",null,"Contact Attempt Details",null,null,null,null,null,"Assessment Dates Offered",null,null,null,null,"Cancellation Details ",null,null,null,"Re-Referral Details "]
[null,"URN","Referral Date","1st Contact Attempt\n(hh:mm DD/MM/YY)","1st Contact Method","2nd Contact Attempt\n(hh:mm DD/MM/YY)","2nd Contact Method","3rd Contact Attempt\n(hh:mm DD/MM/YY)","3rd Contact Method","1st Assessment Date Offered","2nd Assessment Date Offered","3rd Assessment Date Offered","4th Assessment Date Offered","5th Assessment Date Offered","Reason for Assessment Cancellation","PRaP Cancellation Code","Cancelled By","Cancellation Date","Re-Referral Required ","If no Re-Referral required, Why?"]

{"sheet":"Virtual- F2F","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,2],[3,3,3,7]]}
[]
[null,"Virtual - F2F",null,null,"Month:",{"$f":"IF('Cancellations Log'!F2=0,\"\",'Cancellations Log'!F2)","v":"2023-01-01"}]
[]
[null,"Referral Details",null,"Change details "]
[null,"URN","Referral Date","Change of Method of Contact","Date of change ","Reason for change","Stage in process assessment type changed?","Change made by",null,"Change reason","Number of times reason used "]
[null,null,null,null,null,null,null,null,null,"Incorrect assessment type submitted",{"$f":"COUNTIF($F$6:$F$106,J6)","v":0}]
[null,null,null,null,null,null,null,null,null,"Customer requested change before booking call",{"$f":"COUNTIF($F$6:$F$106,J7)","v":0}]
[null,null,null,null,null,null,null,null,null,"Customer availability",0]
[null,null,null,null,null,null,null,null,null,"Customer requested change during booking call",0]
[null,null,null,null,null,null,null,null,null,"Customer requested change during booking call due to being off work currently",0]
[null,null,null,null,null,null,null,null,null,"Customer requested change during booking call due to assessor needed on site",0]
[null,null,null,null,null,null,null,null,null,"Assessor suggested change following discussion",0]
[null,null,null,null,null,null,null,null,null,"Assessor availability",0]

{"sheet":"Top 10 Items","index":4,"n_rows":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,3,1,4],[3,1,3,11],[3,15,3,24]]}
[]
[null,"Top Ten Items",null,"Aug 21 to ",null,{"$f":"IF('Cancellations Log'!F2=0,\"\",'Cancellations Log'!F2)","v":"2023-01-01"}]
[]
[null,"Details of Top Ten recommended solutions in month and year to date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount product have been in this position"]
[null,"Month-Year","Item 1","Item 2","Item 3","Item 4","Item 5","Item 6","Item 7","Item 8","Item 9","Item 10",null,"List ",null,"Item 1","Item 2","Item 3","Item 4","Item 5","Item 6","Item 7","Item 8","Item 9","Item 10"]
[null,"2023-04-01",null,null,null,null,null,null,null,null,null,null,null,"Brain in Hand",null,{"$f":"COUNTIF(C$6:C$29,$N6)","v":0},{"$f":"COUNTIF(D$6:D$29,$N6)","v":0},0,0,0,0,0,0,0,0]
[null,"2023-05-01",null,null,null,null,null,null,null,null,null,null,null,"Chair",null,{"$f":"COUNTIF(C$6:C$29,$N7)","v":0},0,0,0,0,0,0,0,0,0]
[null,"2023-06-01",null,null,null,null,null,null,null,null,null,null,null,"Coping Strategies",null,0,0,0,0,0,0,0,0,0,0]
[null,"2023-07-01",null,null,null,null,null,null,null,null,null,null,null,"Copy AI ",null,0,0,0,0,0,0,0,0,0,0]
[null,"2023-08-01",null,null,null,null,null,null,null,null,null,null,null,"Desk",null,0,0,0,0,0,0,0,0,0,0]
[null,"2023-09-01",null,null,null,null,null,null,null,null,null,null,null,"Dictaphone",null,0,0,0,0,0,0,0,0,0,0]
[null,"2023-10-01",null,null,null,null,null,null,null,null,null,null,null,"Disability Awareness",null,0,0,0,0,0,0,0,0,0,0]
[null,"2023-11-01",null,null,null,null,null,null,null,null,null,null,null,"Disability Awareness Training",null,0,0,0,0,0,0,0,0,0,0]
[null,"2023-12-01",null,null,null,null,null,null,null,null,null,null,null,"Disability Impact Training",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-01-01",null,null,null,null,null,null,null,null,null,null,null,"Dragon Software",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-02-01",null,null,null,null,null,null,null,null,null,null,null,"Ergonomic Chair",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-03-01",null,null,null,null,null,null,null,null,null,null,null,"Ergonomic Keyboard",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-04-01",null,null,null,null,null,null,null,null,null,null,null,"Ergonomic Mouse",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-05-01",null,null,null,null,null,null,null,null,null,null,null,"Footrest",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-06-01",null,null,null,null,null,null,null,null,null,null,null,"Headset",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-07-01",null,null,null,null,null,null,null,null,null,null,null,"Hemingway ",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-08-01",null,null,null,null,null,null,null,null,null,null,null,"Inspiration",null,0,{"$f":"COUNTIF(D$6:D$29,$N22)","v":0},{"$f":"COUNTIF(E$6:E$29,$N22)","v":0},{"$f":"COUNTIF(F$6:F$29,$N22)","v":0},{"$f":"COUNTIF(G$6:G$29,$N22)","v":0},{"$f":"COUNTIF(H$6:H$29,$N22)","v":0},{"$f":"COUNTIF(I$6:I$29,$N22)","v":0},{"$f":"COUNTIF(J$6:J$29,$N22)","v":0},{"$f":"COUNTIF(K$6:K$29,$N22)","v":0},{"$f":"COUNTIF(L$6:L$29,$N22)","v":0}]
[null,"2024-09-01",null,null,null,null,null,null,null,null,null,null,null,"Keyboard",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-10-01",null,null,null,null,null,null,null,null,null,null,null,"Mark Mate",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-11-01",null,null,null,null,null,null,null,null,null,null,null,"Mind Mapping Software ",null,0,0,0,0,0,0,0,0,0,0]
[null,"2024-12-01",null,null,null,null,null,null,null,null,null,null,null,"Monitor",null,0,0,0,0,0,0,0,0,0,0]
[null,"2025-01-01",null,null,null,null,null,null,null,null,null,null,null,"Monitor Arm ",null,0,0,0,0,0,0,0,0,0,0]
[null,"2025-02-01",null,null,null,null,null,null,null,null,null,null,null,"Motion",null,0,0,0,0,0,0,0,0,0,0]
[null,"2025-03-01",null,null,null,null,null,null,null,null,null,null,null,"Mouse",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OrCam",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Assistive Software",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Ergonomic Equipment",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Hearing Equipment",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Neurodiversity Software",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Software",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Phonak Roger",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Writing Aid",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Remarkable",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Roger Pen System",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Screen Overlays ",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart Pen",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Technical Training",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Text HELP Software",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Text to Speech",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Text help",null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ZoomText",null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LARGE('Top 10 Items'!S$6:S$46,ROWS('Top 10 Items'!Q$6:Q6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!S$6:S$46,ROWS('Top 10 Items'!Q$6:Q6)),$P$6:$P$46,$N$6:$N$46))","v":""},{"$f":"IF(LARGE('Top 10 Items'!T$6:T$46,ROWS('Top 10 Items'!R$6:R6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!T$6:T$46,ROWS('Top 10 Items'!R$6:R6)),$P$6:$P$46,$N$6:$N$46))","v":""},{"$f":"IF(LARGE('Top 10 Items'!U$6:U$46,ROWS('Top 10 Items'!S$6:S6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!U$6:U$46,ROWS('Top 10 Items'!S$6:S6)),$P$6:$P$46,$N$6:$N$46))","v":""},{"$f":"IF(LARGE('Top 10 Items'!V$6:V$46,ROWS('Top 10 Items'!T$6:T6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!V$6:V$46,ROWS('Top 10 Items'!T$6:T6)),$P$6:$P$46,$N$6:$N$46))","v":""},{"$f":"IF(LARGE('Top 10 Items'!W$6:W$46,ROWS('Top 10 Items'!U$6:U6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!W$6:W$46,ROWS('Top 10 Items'!U$6:U6)),$P$6:$P$46,$N$6:$N$46))","v":""},{"$f":"IF(LARGE('Top 10 Items'!X$6:X$46,ROWS('Top 10 Items'!V$6:V6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!X$6:X$46,ROWS('Top 10 Items'!V$6:V6)),$P$6:$P$46,$N$6:$N$46))","v":""},{"$f":"IF(LARGE('Top 10 Items'!Y$6:Y$46,ROWS('Top 10 Items'!W$6:W6))=0,\"\",_xlfn.XLOOKUP(LARGE('Top 10 Items'!Y$6:Y$46,ROWS('Top 10 Items'!W$6:W6)),$P$6:$P$46,$N$6:$N$46))","v":""}]

{"sheet":"OLDEST & OUTSTANDING CASES","index":5,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[101,4,101,5],[102,4,102,5],[103,4,103,5],[104,4,104,5],[96,4,96,5],[97,4,97,5],[98,4,98,5],[99,4,99,5],[100,4,100,5],[91,4,91,5],[92,4,92,5],[93,4,93,5],[94,4,94,5],[95,4,95,5],[86,4,86,5],[87,4,87,5],[88,4,88,5],[89,4,89,5],[90,4,90,5],[81,4,81,5],[82,4,82,5],[83,4,83,5],[84,4,84,5],[85,4,85,5],[76,4,76,5],[77,4,77,5],[78,4,78,5],[79,4,79,5],[80,4,80,5],[71,4,71,5],[72,4,72,5],[73,4,73,5],[74,4,74,5],[75,4,75,5],[66,4,66,5],[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[3,1,3,3],[4,4,4,5],[5,4,5,5],[1,1,1,3],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5]]}
["2023-01-01"," "]
[null,"Oldest & Outstanding Cases ",null,null,"Completion Date :","2023-10-01"]
[]
[null,"Case Details",null,null,"Total Outstanding Cases:",{"$f":"COUNT(B6:B106)","v":0}]
[null,"URN","Referral Date","Days since Referral date ","Reasons for Delay"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Booked outside KPI due to volume of referrals "]

{"sheet":"MI Summary","index":6,"n_rows":44,"n_cols":45,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,7,1,10],[24,1,26,1]]}
[{"$f":"'Cancellations Log'!F2","v":"2023-01-01"}]
[null,"MI Summary Table","Apr - 23 to"]
[]
[null,"MONTHLY MI Headings","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01"]
[null,"Cancellation Log"]
[null,"Total cancellations made in month.",{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0))=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0)))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0))=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0)))","v":""}]
[]
[null,"Volume of cancellations made by the Provider in month.",{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&E4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(E4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&E4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(E4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&F4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(F4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&F4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(F4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&G4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(G4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&G4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(G4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&H4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(H4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&H4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(H4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&I4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(I4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&I4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(I4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&J4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(J4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&J4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(J4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&K4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(K4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&K4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(K4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&L4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(L4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&L4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(L4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&M4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(M4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&M4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(M4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&N4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(N4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&N4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(N4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&O4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(O4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&O4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(O4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&P4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(P4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&P4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(P4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Q4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Q4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Q4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Q4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&R4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(R4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&R4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(R4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&S4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(S4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&S4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(S4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&T4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(T4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&T4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(T4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&U4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(U4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&U4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(U4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&V4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(V4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&V4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(V4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&W4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(W4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&W4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(W4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&X4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(X4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&X4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(X4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Y4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Y4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Y4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Y4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Z4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Z4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Z4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Z4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$5))","v":""}]
[null,"Volume of cancellations made by the Provider YTD",{"$f":"IF(C8=\"\",\"\",SUM($C$8:C8))","v":""},{"$f":"IF(D8=\"\",\"\",SUM($C$8:D8))","v":""},{"$f":"IF(E8=\"\",\"\",SUM($C$8:E8))","v":""},{"$f":"IF(F8=\"\",\"\",SUM($C$8:F8))","v":""},{"$f":"IF(G8=\"\",\"\",SUM($C$8:G8))","v":""},{"$f":"IF(H8=\"\",\"\",SUM($C$8:H8))","v":""},{"$f":"IF(I8=\"\",\"\",SUM($C$8:I8))","v":""},{"$f":"IF(J8=\"\",\"\",SUM($C$8:J8))","v":""},{"$f":"IF(K8=\"\",\"\",SUM($C$8:K8))","v":""},{"$f":"IF(L8=\"\",\"\",SUM($C$8:L8))","v":""},{"$f":"IF(M8=\"\",\"\",SUM($C$8:M8))","v":""},{"$f":"IF(N8=\"\",\"\",SUM($C$8:N8))","v":""},{"$f":"IF(O8=\"\",\"\",SUM($C$8:O8))","v":""},{"$f":"IF(P8=\"\",\"\",SUM($C$8:P8))","v":""},{"$f":"IF(Q8=\"\",\"\",SUM($C$8:Q8))","v":""},{"$f":"IF(R8=\"\",\"\",SUM($C$8:R8))","v":""},{"$f":"IF(S8=\"\",\"\",SUM($C$8:S8))","v":""},{"$f":"IF(T8=\"\",\"\",SUM($C$8:T8))","v":""},{"$f":"IF(U8=\"\",\"\",SUM($C$8:U8))","v":""},{"$f":"IF(V8=\"\",\"\",SUM($C$8:V8))","v":""},{"$f":"IF(W8=\"\",\"\",SUM($C$8:W8))","v":""},{"$f":"IF(X8=\"\",\"\",SUM($C$8:X8))","v":""},{"$f":"IF(Y8=\"\",\"\",SUM($C$8:Y8))","v":""},{"$f":"IF(Z8=\"\",\"\",SUM($C$8:Z8))","v":""}]
[]
[null,"Volume of cancellations made by the Customer in month.",{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&E4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(E4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&E4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(E4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&F4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(F4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&F4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(F4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&G4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(G4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&G4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(G4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&H4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(H4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&H4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(H4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&I4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(I4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&I4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(I4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&J4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(J4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&J4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(J4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&K4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(K4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&K4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(K4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&L4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(L4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&L4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(L4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&M4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(M4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&M4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(M4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&N4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(N4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&N4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(N4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&O4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(O4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&O4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(O4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&P4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(P4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&P4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(P4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Q4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Q4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Q4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Q4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&R4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(R4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&R4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(R4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&S4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(S4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&S4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(S4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&T4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(T4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&T4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(T4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&U4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(U4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&U4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(U4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&V4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(V4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&V4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(V4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&W4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(W4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&W4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(W4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&X4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(X4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&X4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(X4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Y4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Y4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Y4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Y4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Z4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Z4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Z4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Z4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$3))","v":""}]
[null,"Volume of cancellations made by the Customer YTD",{"$f":"IF(C11=\"\",\"\",SUM($C$11:C11))","v":""},{"$f":"IF(D11=\"\",\"\",SUM($C$11:D11))","v":""},{"$f":"IF(E11=\"\",\"\",SUM($C$11:E11))","v":""},{"$f":"IF(F11=\"\",\"\",SUM($C$11:F11))","v":""},{"$f":"IF(G11=\"\",\"\",SUM($C$11:G11))","v":""},{"$f":"IF(H11=\"\",\"\",SUM($C$11:H11))","v":""},{"$f":"IF(I11=\"\",\"\",SUM($C$11:I11))","v":""},{"$f":"IF(J11=\"\",\"\",SUM($C$11:J11))","v":""},{"$f":"IF(K11=\"\",\"\",SUM($C$11:K11))","v":""},{"$f":"IF(L11=\"\",\"\",SUM($C$11:L11))","v":""},{"$f":"IF(M11=\"\",\"\",SUM($C$11:M11))","v":""},{"$f":"IF(N11=\"\",\"\",SUM($C$11:N11))","v":""},{"$f":"IF(O11=\"\",\"\",SUM($C$11:O11))","v":""},{"$f":"IF(P11=\"\",\"\",SUM($C$11:P11))","v":""},{"$f":"IF(Q11=\"\",\"\",SUM($C$11:Q11))","v":""},{"$f":"IF(R11=\"\",\"\",SUM($C$11:R11))","v":""},{"$f":"IF(S11=\"\",\"\",SUM($C$11:S11))","v":""},{"$f":"IF(T11=\"\",\"\",SUM($C$11:T11))","v":""},{"$f":"IF(U11=\"\",\"\",SUM($C$11:U11))","v":""},{"$f":"IF(V11=\"\",\"\",SUM($C$11:V11))","v":""},{"$f":"IF(W11=\"\",\"\",SUM($C$11:W11))","v":""},{"$f":"IF(X11=\"\",\"\",SUM($C$11:X11))","v":""},{"$f":"IF(Y11=\"\",\"\",SUM($C$11:Y11))","v":""},{"$f":"IF(Z11=\"\",\"\",SUM($C$11:Z11))","v":""}]
[]
[null,"Volume of cancellations due to DNA in month.",{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&C4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(C4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&D4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(D4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&E4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(E4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&E4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(E4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&F4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(F4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&F4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(F4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&G4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(G4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&G4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(G4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&H4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(H4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&H4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(H4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&I4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(I4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&I4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(I4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&J4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(J4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&J4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(J4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&K4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(K4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&K4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(K4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&L4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(L4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&L4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(L4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&M4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(M4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&M4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(M4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&N4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(N4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&N4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(N4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&O4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(O4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&O4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(O4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&P4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(P4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&P4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(P4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Q4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Q4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Q4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Q4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&R4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(R4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&R4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(R4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&S4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(S4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&S4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(S4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&T4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(T4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&T4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(T4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&U4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(U4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&U4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(U4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&V4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(V4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&V4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(V4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&W4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(W4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&W4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(W4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&X4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(X4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&X4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(X4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Y4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Y4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Y4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Y4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""},{"$f":"IF(COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Z4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Z4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7)=0,\"\",COUNTIFS('Cancellations Log'!$R$6:$R$500,\">=\"&Z4,'Cancellations Log'!$R$6:$R$500,\"<=\"&EOMONTH(Z4,0),'Cancellations Log'!$Q$6:$Q$500,List!$C$7))","v":""}]
[null,"Volume of cancellations due to DNA YTD",{"$f":"IF(C14=\"\",\"\",SUM($C$14:C14))","v":""},{"$f":"IF(D14=\"\",\"\",SUM($C$14:D14))","v":""},{"$f":"IF(E14=\"\",\"\",SUM($C$14:E14))","v":""},{"$f":"IF(F14=\"\",\"\",SUM($C$14:F14))","v":""},{"$f":"IF(G14=\"\",\"\",SUM($C$14:G14))","v":""},{"$f":"IF(H14=\"\",\"\",SUM($C$14:H14))","v":""},{"$f":"IF(I14=\"\",\"\",SUM($C$14:I14))","v":""},{"$f":"IF(J14=\"\",\"\",SUM($C$14:J14))","v":""},{"$f":"IF(K14=\"\",\"\",SUM($C$14:K14))","v":""},{"$f":"IF(L14=\"\",\"\",SUM($C$14:L14))","v":""},{"$f":"IF(M14=\"\",\"\",SUM($C$14:M14))","v":""},{"$f":"IF(N14=\"\",\"\",SUM($C$14:N14))","v":""},{"$f":"IF(O14=\"\",\"\",SUM($C$14:O14))","v":""},{"$f":"IF(P14=\"\",\"\",SUM($C$14:P14))","v":""},{"$f":"IF(Q14=\"\",\"\",SUM($C$14:Q14))","v":""},{"$f":"IF(R14=\"\",\"\",SUM($C$14:R14))","v":""},{"$f":"IF(S14=\"\",\"\",SUM($C$14:S14))","v":""},{"$f":"IF(T14=\"\",\"\",SUM($C$14:T14))","v":""},{"$f":"IF(U14=\"\",\"\",SUM($C$14:U14))","v":""},{"$f":"IF(V14=\"\",\"\",SUM($C$14:V14))","v":""},{"$f":"IF(W14=\"\",\"\",SUM($C$14:W14))","v":""},{"$f":"IF(X14=\"\",\"\",SUM($C$14:X14))","v":""},{"$f":"IF(Y14=\"\",\"\",SUM($C$14:Y14))","v":""},{"$f":"IF(Z14=\"\",\"\",SUM($C$14:Z14))","v":""}]
[null,"Virtual - F2F"]
[null,"Total volume of changes in Month",{"$f":"IFERROR(SUM(C19+C22),0)","v":0},0,{"$f":"IFERROR(SUM(E19+E22),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Changes from F2F to Virtual in Month",{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&C4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(C4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&C4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(C4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&X4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(X4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&X4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(X4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Y4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Y4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Y4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Y4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Z4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Z4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Z4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Z4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$4))","v":0}]
[null,"Changes from F2F to Virtual YTD",{"$f":"IF(C19=\"\",\"\",SUM($C$19:C19))","v":""},{"$f":"IF(D19=0,0,SUM($C$19:D19))","v":0},{"$f":"IF(E19=0,0,SUM($C$19:E19))","v":0},{"$f":"IF(F19=0,0,SUM($C$19:F19))","v":0},{"$f":"IF(G19=0,0,SUM($C$19:G19))","v":0},{"$f":"IF(H19=0,0,SUM($C$19:H19))","v":0},{"$f":"IF(I19=0,0,SUM($C$19:I19))","v":0},{"$f":"IF(J19=0,0,SUM($C$19:J19))","v":0},{"$f":"IF(K19=0,0,SUM($C$19:K19))","v":0},{"$f":"IF(L19=0,0,SUM($C$19:L19))","v":0},{"$f":"IF(M19=0,0,SUM($C$19:M19))","v":0},{"$f":"IF(N19=0,0,SUM($C$19:N19))","v":0},{"$f":"IF(O19=0,0,SUM($C$19:O19))","v":0},{"$f":"IF(P19=0,0,SUM($C$19:P19))","v":0},{"$f":"IF(Q19=0,0,SUM($C$19:Q19))","v":0},{"$f":"IF(R19=0,0,SUM($C$19:R19))","v":0},{"$f":"IF(S19=0,0,SUM($C$19:S19))","v":0},{"$f":"IF(T19=0,0,SUM($C$19:T19))","v":0},{"$f":"IF(U19=0,0,SUM($C$19:U19))","v":0},{"$f":"IF(V19=0,0,SUM($C$19:V19))","v":0},{"$f":"IF(W19=0,0,SUM($C$19:W19))","v":0},{"$f":"IF(X19=0,0,SUM($C$19:X19))","v":0},{"$f":"IF(Y19=0,0,SUM($C$19:Y19))","v":0},{"$f":"IF(Z19=0,0,SUM($C$19:Z19))","v":0}]
[]
[null,"Changes from Virtual to F2F in Month",{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&C4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(C4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&C4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(C4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&X4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(X4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&X4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(X4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Y4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Y4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Y4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Y4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Z4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Z4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3)=0,0,COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Z4,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Z4,0),'Virtual- F2F'!$D$6:$D$105,List!$H$3))","v":0}]
[null,"Changes from Virtual to F2F YTD",{"$f":"IF(C22=\"\",\"\",SUM($C$22:C22))","v":""},{"$f":"IF(D22=0,0,SUM($C$22:D22))","v":0},{"$f":"IF(E22=0,0,SUM($C$22:E22))","v":0},{"$f":"IF(F22=0,0,SUM($C$22:F22))","v":0},{"$f":"IF(G22=0,0,SUM($C$22:G22))","v":0},{"$f":"IF(H22=0,0,SUM($C$22:H22))","v":0},{"$f":"IF(I22=0,0,SUM($C$22:I22))","v":0},{"$f":"IF(J22=0,0,SUM($C$22:J22))","v":0},{"$f":"IF(K22=0,0,SUM($C$22:K22))","v":0},{"$f":"IF(L22=0,0,SUM($C$22:L22))","v":0},{"$f":"IF(M22=0,0,SUM($C$22:M22))","v":0},{"$f":"IF(N22=0,0,SUM($C$22:N22))","v":0},{"$f":"IF(O22=0,0,SUM($C$22:O22))","v":0},{"$f":"IF(P22=0,0,SUM($C$22:P22))","v":0},{"$f":"IF(Q22=0,0,SUM($C$22:Q22))","v":0},{"$f":"IF(R22=0,0,SUM($C$22:R22))","v":0},{"$f":"IF(S22=0,0,SUM($C$22:S22))","v":0},{"$f":"IF(T22=0,0,SUM($C$22:T22))","v":0},{"$f":"IF(U22=0,0,SUM($C$22:U22))","v":0},{"$f":"IF(V22=0,0,SUM($C$22:V22))","v":0},{"$f":"IF(W22=0,0,SUM($C$22:W22))","v":0},{"$f":"IF(X22=0,0,SUM($C$22:X22))","v":0},{"$f":"IF(Y22=0,0,SUM($C$22:Y22))","v":0},{"$f":"IF(Z22=0,0,SUM($C$22:Z22))","v":0}]
[null,"Top 10 Items"]
[null,"Top Three recommended solutions in month and year to date",{"$f":"IF('Top 10 Items'!$C6=0,\"\",'Top 10 Items'!$C6)","v":""},{"$f":"IF('Top 10 Items'!$C7=0,\"\",'Top 10 Items'!$C7)","v":""},{"$f":"IF('Top 10 Items'!$C8=0,\"\",'Top 10 Items'!$C8)","v":""},{"$f":"IF('Top 10 Items'!$C9=0,\"\",'Top 10 Items'!$C9)","v":""},{"$f":"IF('Top 10 Items'!$C10=0,\"\",'Top 10 Items'!$C10)","v":""},{"$f":"IF('Top 10 Items'!$C11=0,\"\",'Top 10 Items'!$C11)","v":""},{"$f":"IF('Top 10 Items'!$C12=0,\"\",'Top 10 Items'!$C12)","v":""},{"$f":"IF('Top 10 Items'!$C13=0,\"\",'Top 10 Items'!$C13)","v":""},{"$f":"IF('Top 10 Items'!$C14=0,\"\",'Top 10 Items'!$C14)","v":""},{"$f":"IF('Top 10 Items'!$C15=0,\"\",'Top 10 Items'!$C15)","v":""},{"$f":"IF('Top 10 Items'!$C16=0,\"\",'Top 10 Items'!$C16)","v":""},{"$f":"IF('Top 10 Items'!$C17=0,\"\",'Top 10 Items'!$C17)","v":""},{"$f":"IF('Top 10 Items'!$C18=0,\"\",'Top 10 Items'!$C18)","v":""},{"$f":"IF('Top 10 Items'!$C19=0,\"\",'Top 10 Items'!$C19)","v":""},{"$f":"IF('Top 10 Items'!$C20=0,\"\",'Top 10 Items'!$C20)","v":""},{"$f":"IF('Top 10 Items'!$C21=0,\"\",'Top 10 Items'!$C21)","v":""},{"$f":"IF('Top 10 Items'!$C22=0,\"\",'Top 10 Items'!$C22)","v":""},{"$f":"IF('Top 10 Items'!$C23=0,\"\",'Top 10 Items'!$C23)","v":""},{"$f":"IF('Top 10 Items'!$C24=0,\"\",'Top 10 Items'!$C24)","v":""},{"$f":"IF('Top 10 Items'!$C25=0,\"\",'Top 10 Items'!$C25)","v":""},{"$f":"IF('Top 10 Items'!$C26=0,\"\",'Top 10 Items'!$C26)","v":""},{"$f":"IF('Top 10 Items'!$C27=0,\"\",'Top 10 Items'!$C27)","v":""},{"$f":"IF('Top 10 Items'!$C28=0,\"\",'Top 10 Items'!$C28)","v":""},{"$f":"IF('Top 10 Items'!J22=0,\"\",'Top 10 Items'!J22)","v":""},null,null,null,null,null,{"$f":"IF('Top 10 Items'!P22=0,\"\",'Top 10 Items'!P22)","v":""},{"$f":"IF('Top 10 Items'!Q22=0,\"\",'Top 10 Items'!Q22)","v":""},{"$f":"IF('Top 10 Items'!R22=0,\"\",'Top 10 Items'!R22)","v":""},{"$f":"IF('Top 10 Items'!S22=0,\"\",'Top 10 Items'!S22)","v":""},{"$f":"IF('Top 10 Items'!T22=0,\"\",'Top 10 Items'!T22)","v":""},{"$f":"IF('Top 10 Items'!U22=0,\"\",'Top 10 Items'!U22)","v":""},{"$f":"IF('Top 10 Items'!V22=0,\"\",'Top 10 Items'!V22)","v":""},{"$f":"IF('Top 10 Items'!W22=0,\"\",'Top 10 Items'!W22)","v":""},{"$f":"IF('Top 10 Items'!X22=0,\"\",'Top 10 Items'!X22)","v":""},{"$f":"IF('Top 10 Items'!Y22=0,\"\",'Top 10 Items'!Y22)","v":""},{"$f":"IF('Top 10 Items'!Z22=0,\"\",'Top 10 Items'!Z22)","v":""},{"$f":"IF('Top 10 Items'!AA22=0,\"\",'Top 10 Items'!AA22)","v":""},{"$f":"IF('Top 10 Items'!AB22=0,\"\",'Top 10 Items'!AB22)","v":""},{"$f":"IF('Top 10 Items'!AC22=0,\"\",'Top 10 Items'!AC22)","v":""}]
[null,null,{"$f":"IF('Top 10 Items'!$D6=0,\"\",'Top 10 Items'!$D6)","v":""},{"$f":"IF('Top 10 Items'!$D7=0,\"\",'Top 10 Items'!$D7)","v":""},{"$f":"IF('Top 10 Items'!$D8=0,\"\",'Top 10 Items'!$D8)","v":""},{"$f":"IF('Top 10 Items'!$D9=0,\"\",'Top 10 Items'!$D9)","v":""},{"$f":"IF('Top 10 Items'!$D10=0,\"\",'Top 10 Items'!$D10)","v":""},{"$f":"IF('Top 10 Items'!$D11=0,\"\",'Top 10 Items'!$D11)","v":""},{"$f":"IF('Top 10 Items'!$D12=0,\"\",'Top 10 Items'!$D12)","v":""},{"$f":"IF('Top 10 Items'!$D13=0,\"\",'Top 10 Items'!$D13)","v":""},{"$f":"IF('Top 10 Items'!$D14=0,\"\",'Top 10 Items'!$D14)","v":""},{"$f":"IF('Top 10 Items'!$D15=0,\"\",'Top 10 Items'!$D15)","v":""},{"$f":"IF('Top 10 Items'!$D16=0,\"\",'Top 10 Items'!$D16)","v":""},{"$f":"IF('Top 10 Items'!$D17=0,\"\",'Top 10 Items'!$D17)","v":""},{"$f":"IF('Top 10 Items'!$D18=0,\"\",'Top 10 Items'!$D18)","v":""},{"$f":"IF('Top 10 Items'!$D19=0,\"\",'Top 10 Items'!$D19)","v":""},{"$f":"IF('Top 10 Items'!$D20=0,\"\",'Top 10 Items'!$D20)","v":""},{"$f":"IF('Top 10 Items'!$D21=0,\"\",'Top 10 Items'!$D21)","v":""},{"$f":"IF('Top 10 Items'!$D22=0,\"\",'Top 10 Items'!$D22)","v":""},{"$f":"IF('Top 10 Items'!$D23=0,\"\",'Top 10 Items'!$D23)","v":""},{"$f":"IF('Top 10 Items'!$D24=0,\"\",'Top 10 Items'!$D24)","v":""},{"$f":"IF('Top 10 Items'!$D25=0,\"\",'Top 10 Items'!$D25)","v":""},{"$f":"IF('Top 10 Items'!$D26=0,\"\",'Top 10 Items'!$D26)","v":""},{"$f":"IF('Top 10 Items'!$D27=0,\"\",'Top 10 Items'!$D27)","v":""},{"$f":"IF('Top 10 Items'!$D28=0,\"\",'Top 10 Items'!$D28)","v":""},{"$f":"IF('Top 10 Items'!$D29=0,\"\",'Top 10 Items'!$D29)","v":""},null,null,null,null,null,{"$f":"IF('Top 10 Items'!P23=0,\"\",'Top 10 Items'!P23)","v":""},{"$f":"IF('Top 10 Items'!Q23=0,\"\",'Top 10 Items'!Q23)","v":""},{"$f":"IF('Top 10 Items'!R23=0,\"\",'Top 10 Items'!R23)","v":""},{"$f":"IF('Top 10 Items'!S23=0,\"\",'Top 10 Items'!S23)","v":""},{"$f":"IF('Top 10 Items'!T23=0,\"\",'Top 10 Items'!T23)","v":""},{"$f":"IF('Top 10 Items'!U23=0,\"\",'Top 10 Items'!U23)","v":""},{"$f":"IF('Top 10 Items'!V23=0,\"\",'Top 10 Items'!V23)","v":""},{"$f":"IF('Top 10 Items'!W23=0,\"\",'Top 10 Items'!W23)","v":""},{"$f":"IF('Top 10 Items'!X23=0,\"\",'Top 10 Items'!X23)","v":""},{"$f":"IF('Top 10 Items'!Y23=0,\"\",'Top 10 Items'!Y23)","v":""},{"$f":"IF('Top 10 Items'!Z23=0,\"\",'Top 10 Items'!Z23)","v":""},{"$f":"IF('Top 10 Items'!AA23=0,\"\",'Top 10 Items'!AA23)","v":""},{"$f":"IF('Top 10 Items'!AB23=0,\"\",'Top 10 Items'!AB23)","v":""},{"$f":"IF('Top 10 Items'!AC23=0,\"\",'Top 10 Items'!AC23)","v":""}]
[null,null,{"$f":"IF('Top 10 Items'!$E6=0,\"\",'Top 10 Items'!$E6)","v":""},{"$f":"IF('Top 10 Items'!$E7=0,\"\",'Top 10 Items'!$E7)","v":""},{"$f":"IF('Top 10 Items'!$E8=0,\"\",'Top 10 Items'!$E8)","v":""},{"$f":"IF('Top 10 Items'!$E9=0,\"\",'Top 10 Items'!$E9)","v":""},{"$f":"IF('Top 10 Items'!$E10=0,\"\",'Top 10 Items'!$E10)","v":""},{"$f":"IF('Top 10 Items'!$E11=0,\"\",'Top 10 Items'!$E11)","v":""},{"$f":"IF('Top 10 Items'!$E12=0,\"\",'Top 10 Items'!$E12)","v":""},{"$f":"IF('Top 10 Items'!$E13=0,\"\",'Top 10 Items'!$E13)","v":""},{"$f":"IF('Top 10 Items'!$E14=0,\"\",'Top 10 Items'!$E14)","v":""},{"$f":"IF('Top 10 Items'!$E15=0,\"\",'Top 10 Items'!$E15)","v":""},{"$f":"IF('Top 10 Items'!$E16=0,\"\",'Top 10 Items'!$E16)","v":""},{"$f":"IF('Top 10 Items'!$E17=0,\"\",'Top 10 Items'!$E17)","v":""},{"$f":"IF('Top 10 Items'!$E18=0,\"\",'Top 10 Items'!$E18)","v":""},{"$f":"IF('Top 10 Items'!$E19=0,\"\",'Top 10 Items'!$E19)","v":""},{"$f":"IF('Top 10 Items'!$E20=0,\"\",'Top 10 Items'!$E20)","v":""},{"$f":"IF('Top 10 Items'!$E21=0,\"\",'Top 10 Items'!$E21)","v":""},{"$f":"IF('Top 10 Items'!$E22=0,\"\",'Top 10 Items'!$E22)","v":""},{"$f":"IF('Top 10 Items'!$E23=0,\"\",'Top 10 Items'!$E23)","v":""},{"$f":"IF('Top 10 Items'!$E24=0,\"\",'Top 10 Items'!$E24)","v":""},{"$f":"IF('Top 10 Items'!$E25=0,\"\",'Top 10 Items'!$E25)","v":""},{"$f":"IF('Top 10 Items'!$E26=0,\"\",'Top 10 Items'!$E26)","v":""},{"$f":"IF('Top 10 Items'!$E27=0,\"\",'Top 10 Items'!$E27)","v":""},{"$f":"IF('Top 10 Items'!$E28=0,\"\",'Top 10 Items'!$E28)","v":""},{"$f":"IF('Top 10 Items'!$E29=0,\"\",'Top 10 Items'!$E29)","v":""}]
[null,"Oldest & Outstanding Cases"]
[null,"Oldest case – Number of days outstanding from referral ",{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!D6:D106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&C4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(C4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!E6:E106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&D4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(D4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!F6:F106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&E4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(E4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!G6:G106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&F4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(F4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!H6:H106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&G4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(G4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!I6:I106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&H4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(H4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!J6:J106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&I4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(I4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!K6:K106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&J4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(J4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!L6:L106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&K4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(K4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!M6:M106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&L4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(L4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!N6:N106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&M4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(M4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!O6:O106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&N4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(N4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!P6:P106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&O4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(O4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!Q6:Q106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&P4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(P4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!R6:R106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Q4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Q4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!S6:S106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&R4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(R4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!T6:T106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&S4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(S4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!U6:U106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&T4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(T4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!V6:V106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&U4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(U4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!W6:W106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&V4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(V4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!X6:X106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&W4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(W4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!Y6:Y106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&X4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(X4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!Z6:Z106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Y4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Y4,0))","v":0},{"$f":"_xlfn.MAXIFS('OLDEST & OUTSTANDING CASES'!AA6:AA106,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Z4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Z4,0))","v":0}]
[null,"Oldest Case – Reason for delay ",{"$f":"IFERROR(_xlfn.XLOOKUP(C29,'OLDEST & OUTSTANDING CASES'!D6:D106,'OLDEST & OUTSTANDING CASES'!E6:E106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(D29,'OLDEST & OUTSTANDING CASES'!E6:E106,'OLDEST & OUTSTANDING CASES'!F6:F106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(E29,'OLDEST & OUTSTANDING CASES'!F6:F106,'OLDEST & OUTSTANDING CASES'!G6:G106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(F29,'OLDEST & OUTSTANDING CASES'!G6:G106,'OLDEST & OUTSTANDING CASES'!H6:H106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(G29,'OLDEST & OUTSTANDING CASES'!H6:H106,'OLDEST & OUTSTANDING CASES'!I6:I106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(H29,'OLDEST & OUTSTANDING CASES'!I6:I106,'OLDEST & OUTSTANDING CASES'!J6:J106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(I29,'OLDEST & OUTSTANDING CASES'!J6:J106,'OLDEST & OUTSTANDING CASES'!K6:K106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(J29,'OLDEST & OUTSTANDING CASES'!K6:K106,'OLDEST & OUTSTANDING CASES'!L6:L106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(K29,'OLDEST & OUTSTANDING CASES'!L6:L106,'OLDEST & OUTSTANDING CASES'!M6:M106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(L29,'OLDEST & OUTSTANDING CASES'!M6:M106,'OLDEST & OUTSTANDING CASES'!N6:N106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(M29,'OLDEST & OUTSTANDING CASES'!N6:N106,'OLDEST & OUTSTANDING CASES'!O6:O106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(N29,'OLDEST & OUTSTANDING CASES'!O6:O106,'OLDEST & OUTSTANDING CASES'!P6:P106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(O29,'OLDEST & OUTSTANDING CASES'!P6:P106,'OLDEST & OUTSTANDING CASES'!Q6:Q106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(P29,'OLDEST & OUTSTANDING CASES'!Q6:Q106,'OLDEST & OUTSTANDING CASES'!R6:R106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(Q29,'OLDEST & OUTSTANDING CASES'!R6:R106,'OLDEST & OUTSTANDING CASES'!S6:S106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(R29,'OLDEST & OUTSTANDING CASES'!S6:S106,'OLDEST & OUTSTANDING CASES'!T6:T106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(S29,'OLDEST & OUTSTANDING CASES'!T6:T106,'OLDEST & OUTSTANDING CASES'!U6:U106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(T29,'OLDEST & OUTSTANDING CASES'!U6:U106,'OLDEST & OUTSTANDING CASES'!V6:V106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(U29,'OLDEST & OUTSTANDING CASES'!V6:V106,'OLDEST & OUTSTANDING CASES'!W6:W106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(V29,'OLDEST & OUTSTANDING CASES'!W6:W106,'OLDEST & OUTSTANDING CASES'!X6:X106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(W29,'OLDEST & OUTSTANDING CASES'!X6:X106,'OLDEST & OUTSTANDING CASES'!Y6:Y106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(X29,'OLDEST & OUTSTANDING CASES'!Y6:Y106,'OLDEST & OUTSTANDING CASES'!Z6:Z106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(Y29,'OLDEST & OUTSTANDING CASES'!Z6:Z106,'OLDEST & OUTSTANDING CASES'!AA6:AA106),0)","v":0},{"$f":"IFERROR(_xlfn.XLOOKUP(Z29,'OLDEST & OUTSTANDING CASES'!AA6:AA106,'OLDEST & OUTSTANDING CASES'!AB6:AB106),0)","v":0}]
[]
[null,"Volumes outstanding at the end of the month",{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&C4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(C4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&C4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(C4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&D4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(D4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&D4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(D4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&E4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(E4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&E4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(E4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&F4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(F4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&F4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(F4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&G4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(G4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&G4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(G4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&H4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(H4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&H4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(H4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&I4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(I4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&I4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(I4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&J4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(J4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&J4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(J4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&K4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(K4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&K4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(K4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&L4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(L4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&L4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(L4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&M4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(M4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&M4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(M4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&N4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(N4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&N4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(N4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&O4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(O4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&O4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(O4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&P4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(P4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&P4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(P4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Q4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Q4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Q4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Q4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&R4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(R4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&R4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(R4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&S4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(S4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&S4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(S4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&T4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(T4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&T4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(T4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&U4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(U4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&U4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(U4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&V4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(V4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&V4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(V4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&W4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(W4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&W4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(W4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&X4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(X4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&X4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(X4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Y4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Y4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Y4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Y4,0)))","v":0},{"$f":"IF(COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Z4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Z4,0))=0,0,COUNTIFS('OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\">=\"&Z4,'OLDEST & OUTSTANDING CASES'!$C$6:$C$106,\"<=\"&EOMONTH(Z4,0)))","v":0}]
[null,"Complaints"]
[null,"Number of complaints handled by the Provider in Month"]
[null,"Number of complaints handled by the Provider YTD"]
[]
[null,"Number of complaints referred to the Authority in month"]
[null,"Number of complaints referred to the Authority YTD "]
[]
[null,"Time taken to resolve to customer’s satisfaction (in Working Days) in month "]
[null,"Time taken to resolve to customer’s satisfaction (in Working Days) YTD"]
[null,"Re worked cases "]
[null,"Volume of re worked cases in month"]
[null,"Volume of re worked cases to date "]

{"sheet":"MI Graphs","index":7,"n_rows":92,"n_cols":28,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,4,1,6],[1,1,1,2],[1,7,1,9],[91,1,91,20],[73,1,73,20],[3,1,3,20],[21,1,21,20],[55,1,55,20]]}
[]
[null,"MI Summary Graphs",null,null,"Jun - 23 to",null,null,{"$f":"IF('Cancellations Log'!F2=0,\"\",'Cancellations Log'!F2)","v":"2023-01-01"}]
[]
[null,"Cancellation Log"]
[]
[]
[null,null,"months",{"$f":"IF('MI Summary'!C4>=TODAY(),NA(),'MI Summary'!C4)","v":"2023-04-01"},{"$f":"IF('MI Summary'!D4>=TODAY(),NA(),'MI Summary'!D4)","v":"2023-05-01"},{"$f":"IF('MI Summary'!E4>=TODAY(),NA(),'MI Summary'!E4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!F4>=TODAY(),NA(),'MI Summary'!F4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!G4>=TODAY(),NA(),'MI Summary'!G4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!H4>=TODAY(),NA(),'MI Summary'!H4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!I4>=TODAY(),NA(),'MI Summary'!I4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!J4>=TODAY(),NA(),'MI Summary'!J4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!K4>=TODAY(),NA(),'MI Summary'!K4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!L4>=TODAY(),NA(),'MI Summary'!L4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!M4>=TODAY(),NA(),'MI Summary'!M4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!N4>=TODAY(),NA(),'MI Summary'!N4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!O4>=TODAY(),NA(),'MI Summary'!O4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!P4>=TODAY(),NA(),'MI Summary'!P4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!Q4>=TODAY(),NA(),'MI Summary'!Q4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!R4>=TODAY(),NA(),'MI Summary'!R4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!S4>=TODAY(),NA(),'MI Summary'!S4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!T4>=TODAY(),NA(),'MI Summary'!T4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!U4>=TODAY(),NA(),'MI Summary'!U4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!V4>=TODAY(),NA(),'MI Summary'!V4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!W4>=TODAY(),NA(),'MI Summary'!W4)","v":{"$error":"#N/A"}},null,{"$f":"IF('MI Summary'!X4>=TODAY(),NA(),'MI Summary'!X4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!Y4>=TODAY(),NA(),'MI Summary'!Y4)","v":{"$error":"#N/A"}},{"$f":"IF('MI Summary'!Z4>=TODAY(),NA(),'MI Summary'!Z4)","v":{"$error":"#N/A"}}]
[null,null,"By the Provider in month.",{"$f":"'MI Summary'!C8","v":""},{"$f":"'MI Summary'!D8","v":""},{"$f":"'MI Summary'!E8","v":""},{"$f":"'MI Summary'!F8","v":""},{"$f":"'MI Summary'!G8","v":""},{"$f":"'MI Summary'!H8","v":""},{"$f":"'MI Summary'!I8","v":""},{"$f":"'MI Summary'!J8","v":""},{"$f":"'MI Summary'!K8","v":""},{"$f":"'MI Summary'!L8","v":""},{"$f":"'MI Summary'!M8","v":""},{"$f":"'MI Summary'!N8","v":""},{"$f":"'MI Summary'!O8","v":""},{"$f":"'MI Summary'!P8","v":""},{"$f":"'MI Summary'!Q8","v":""},{"$f":"'MI Summary'!R8","v":""},{"$f":"'MI Summary'!S8","v":""},{"$f":"'MI Summary'!T8","v":""},{"$f":"'MI Summary'!U8","v":""},{"$f":"'MI Summary'!V8","v":""},{"$f":"'MI Summary'!W8","v":""},null,{"$f":"'MI Summary'!X8","v":""},{"$f":"'MI Summary'!Y8","v":""},{"$f":"'MI Summary'!Z8","v":""}]
[null,null,"By the Customer in month.",{"$f":"'MI Summary'!C11","v":""},1,{"$f":"'MI Summary'!E11","v":""},{"$f":"'MI Summary'!F11","v":""},{"$f":"'MI Summary'!G11","v":""},{"$f":"'MI Summary'!H11","v":""},{"$f":"'MI Summary'!I11","v":""},{"$f":"'MI Summary'!J11","v":""},{"$f":"'MI Summary'!K11","v":""},{"$f":"'MI Summary'!L11","v":""},{"$f":"'MI Summary'!M11","v":""},{"$f":"'MI Summary'!N11","v":""},{"$f":"'MI Summary'!O11","v":""},{"$f":"'MI Summary'!P11","v":""},{"$f":"'MI Summary'!Q11","v":""},{"$f":"'MI Summary'!R11","v":""},{"$f":"'MI Summary'!S11","v":""},{"$f":"'MI Summary'!T11","v":""},{"$f":"'MI Summary'!U11","v":""},{"$f":"'MI Summary'!V11","v":""},{"$f":"'MI Summary'!W11","v":""},null,{"$f":"'MI Summary'!X11","v":""},{"$f":"'MI Summary'!Y11","v":""},{"$f":"'MI Summary'!Z11","v":""}]
[null,null,"No contact in month.",{"$f":"'MI Summary'!C14","v":""},{"$f":"'MI Summary'!D14","v":""},{"$f":"'MI Summary'!E14","v":""},{"$f":"'MI Summary'!F14","v":""},{"$f":"'MI Summary'!G14","v":""},{"$f":"'MI Summary'!H14","v":""},{"$f":"'MI Summary'!I14","v":""},{"$f":"'MI Summary'!J14","v":""},{"$f":"'MI Summary'!K14","v":""},{"$f":"'MI Summary'!L14","v":""},{"$f":"'MI Summary'!M14","v":""},{"$f":"'MI Summary'!N14","v":""},{"$f":"'MI Summary'!O14","v":""},{"$f":"'MI Summary'!P14","v":""},{"$f":"'MI Summary'!Q14","v":""},{"$f":"'MI Summary'!R14","v":""},{"$f":"'MI Summary'!S14","v":""},{"$f":"'MI Summary'!T14","v":""},{"$f":"'MI Summary'!U14","v":""},{"$f":"'MI Summary'!V14","v":""},{"$f":"'MI Summary'!W14","v":""},null,{"$f":"'MI Summary'!X14","v":""},{"$f":"'MI Summary'!Y14","v":""},{"$f":"'MI Summary'!Z14","v":""}]
[null,null,"Other ",{"$f":"'MI Summary'!C6-SUM(D8:D10)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Virtual - F2F Log"]
[]
[null,null,"month",{"$f":"D7","v":"2023-04-01"},"2023-05-01",{"$f":"F7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"TOTAL CHANGES MADE YTD"]
[null,null,"F2F to Virtual",{"$f":"'MI Summary'!C19","v":""},{"$f":"'MI Summary'!D19","v":0},{"$f":"'MI Summary'!E19","v":0},{"$f":"'MI Summary'!F19","v":0},{"$f":"'MI Summary'!G19","v":0},{"$f":"'MI Summary'!H19","v":0},{"$f":"'MI Summary'!I19","v":0},{"$f":"'MI Summary'!J19","v":0},{"$f":"'MI Summary'!K19","v":0},{"$f":"'MI Summary'!L19","v":0},{"$f":"'MI Summary'!M19","v":0},{"$f":"'MI Summary'!N19","v":0},{"$f":"'MI Summary'!O19","v":0},{"$f":"'MI Summary'!P19","v":0},{"$f":"'MI Summary'!Q19","v":0},{"$f":"'MI Summary'!R19","v":0},{"$f":"'MI Summary'!S19","v":0},{"$f":"'MI Summary'!T19","v":0},{"$f":"'MI Summary'!U19","v":0},{"$f":"'MI Summary'!V19","v":0},{"$f":"'MI Summary'!W19","v":0},"F2F to Virtual",{"$f":"SUM(D25:X25)","v":0}]
[null,null,"Virtual to F2F",{"$f":"'MI Summary'!C22","v":""},{"$f":"'MI Summary'!D22","v":0},{"$f":"'MI Summary'!E22","v":0},{"$f":"'MI Summary'!F22","v":0},{"$f":"'MI Summary'!G22","v":0},{"$f":"'MI Summary'!H22","v":0},{"$f":"'MI Summary'!I22","v":0},{"$f":"'MI Summary'!J22","v":0},{"$f":"'MI Summary'!K22","v":0},{"$f":"'MI Summary'!L22","v":0},{"$f":"'MI Summary'!M22","v":0},{"$f":"'MI Summary'!N22","v":0},{"$f":"'MI Summary'!O22","v":0},{"$f":"'MI Summary'!P22","v":0},{"$f":"'MI Summary'!Q22","v":0},{"$f":"'MI Summary'!R22","v":0},{"$f":"'MI Summary'!S22","v":0},{"$f":"'MI Summary'!T22","v":0},{"$f":"'MI Summary'!U22","v":0},{"$f":"'MI Summary'!V22","v":0},{"$f":"'MI Summary'!W20","v":0},"Virtual to F2F",{"$f":"SUM(D26:X26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"stage of process change made ",{"$f":"D7","v":"2023-04-01"},{"$f":"E7","v":"2023-05-01"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Incorrect assessment type submitted",{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH($D$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$3))","v":""}]
[null,null,"Before assessment",{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH($D$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$4))","v":""}]
[null,null,"During assessment",{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(D$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&D$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH($D$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&E$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(E$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&F$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(F$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&G$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(G$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&H$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(H$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&I$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(I$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&J$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(J$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&K$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(K$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&L$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(L$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&M$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(M$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&N$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(N$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&O$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(O$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&P$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(P$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&Q$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(Q$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&R$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(R$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&S$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(S$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&T$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(T$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&U$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(U$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&V$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(V$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""},{"$f":"IF(COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5)=0,\"\",COUNTIFS('Virtual- F2F'!$E$6:$E$105,\">=\"&W$40,'Virtual- F2F'!$E$6:$E$105,\"<=\"&EOMONTH(W$40,0),'Virtual- F2F'!$G$6:$G$105,List!$J$5))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Oldest & Outstanding Cases "]
[]
[null,null,null,{"$f":"D7","v":"2023-04-01"},"2023-05-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"J7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"'MI Summary'!B29","v":"Oldest case – Number of days outstanding from referral "},0,{"$f":"'MI Summary'!D29","v":0},{"$f":"'MI Summary'!E29","v":0},{"$f":"'MI Summary'!F29","v":0},{"$f":"'MI Summary'!G29","v":0},{"$f":"'MI Summary'!H29","v":0},{"$f":"'MI Summary'!I29","v":0},{"$f":"'MI Summary'!J29","v":0},{"$f":"'MI Summary'!K29","v":0},{"$f":"'MI Summary'!L29","v":0},{"$f":"'MI Summary'!M29","v":0},{"$f":"'MI Summary'!N29","v":0},{"$f":"'MI Summary'!O29","v":0},{"$f":"'MI Summary'!P29","v":0},{"$f":"'MI Summary'!Q29","v":0},{"$f":"'MI Summary'!R29","v":0},{"$f":"'MI Summary'!S29","v":0},{"$f":"'MI Summary'!T29","v":0},{"$f":"'MI Summary'!U29","v":0},{"$f":"'MI Summary'!V29","v":0}]
[null,null,{"$f":"'MI Summary'!B32","v":"Volumes outstanding at the end of the month"},0,{"$f":"'MI Summary'!D32","v":0},{"$f":"'MI Summary'!E32","v":0},{"$f":"'MI Summary'!F32","v":0},{"$f":"'MI Summary'!G32","v":0},{"$f":"'MI Summary'!H32","v":0},{"$f":"'MI Summary'!I32","v":0},{"$f":"'MI Summary'!J32","v":0},{"$f":"'MI Summary'!K32","v":0},{"$f":"'MI Summary'!L32","v":0},{"$f":"'MI Summary'!M32","v":0},{"$f":"'MI Summary'!N32","v":0},{"$f":"'MI Summary'!O32","v":0},{"$f":"'MI Summary'!P32","v":0},{"$f":"'MI Summary'!Q32","v":0},{"$f":"'MI Summary'!R32","v":0},{"$f":"'MI Summary'!S32","v":0},{"$f":"'MI Summary'!T32","v":0},{"$f":"'MI Summary'!U32","v":0},{"$f":"'MI Summary'!V32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Complaints"]
[]
[null,null,null,{"$f":"D7","v":"2023-04-01"},{"$f":"E7","v":"2023-05-01"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Re worked cases in month",{"$f":"'MI Summary'!C43","v":0},{"$f":"'MI Summary'!D43","v":0},{"$f":"'MI Summary'!E43","v":0},{"$f":"'MI Summary'!F43","v":0},{"$f":"'MI Summary'!G43","v":0},{"$f":"'MI Summary'!H43","v":0},{"$f":"'MI Summary'!I43","v":0},{"$f":"'MI Summary'!J43","v":0},{"$f":"'MI Summary'!K43","v":0},{"$f":"'MI Summary'!L43","v":0},{"$f":"'MI Summary'!M43","v":0},{"$f":"'MI Summary'!N43","v":0},{"$f":"'MI Summary'!O43","v":0},{"$f":"'MI Summary'!P43","v":0},{"$f":"'MI Summary'!Q43","v":0},{"$f":"'MI Summary'!R43","v":0},{"$f":"'MI Summary'!S43","v":0},{"$f":"'MI Summary'!T43","v":0},{"$f":"'MI Summary'!U43","v":0},{"$f":"'MI Summary'!V43","v":0},{"$f":"'MI Summary'!W43","v":0}]
[null,null,"Re worked cases to date ",{"$f":"'MI Summary'!C44","v":0},{"$f":"'MI Summary'!D44","v":0},{"$f":"'MI Summary'!E44","v":0},{"$f":"'MI Summary'!F44","v":0},{"$f":"'MI Summary'!G44","v":0},{"$f":"'MI Summary'!H44","v":0},{"$f":"'MI Summary'!I44","v":0},{"$f":"'MI Summary'!J44","v":0},{"$f":"'MI Summary'!K44","v":0},{"$f":"'MI Summary'!L44","v":0},{"$f":"'MI Summary'!M44","v":0},{"$f":"'MI Summary'!N44","v":0},{"$f":"'MI Summary'!O44","v":0},{"$f":"'MI Summary'!P44","v":0},{"$f":"'MI Summary'!Q44","v":0},{"$f":"'MI Summary'!R44","v":0},{"$f":"'MI Summary'!S44","v":0},{"$f":"'MI Summary'!T44","v":0},{"$f":"'MI Summary'!U44","v":0},{"$f":"'MI Summary'!V44","v":0},{"$f":"'MI Summary'!W44","v":0}]
[null,null,{"$f":"'MI Summary'!B34","v":"Number of complaints handled by the Provider in Month"},{"$f":"'MI Summary'!C34","v":0},{"$f":"'MI Summary'!D34","v":0},{"$f":"'MI Summary'!E34","v":0},{"$f":"'MI Summary'!F34","v":0},{"$f":"'MI Summary'!G34","v":0},{"$f":"'MI Summary'!H34","v":0},{"$f":"'MI Summary'!I34","v":0},{"$f":"'MI Summary'!J34","v":0},{"$f":"'MI Summary'!K34","v":0},{"$f":"'MI Summary'!L34","v":0},{"$f":"'MI Summary'!M34","v":0},{"$f":"'MI Summary'!N34","v":0},{"$f":"'MI Summary'!O34","v":0},{"$f":"'MI Summary'!P34","v":0},{"$f":"'MI Summary'!Q34","v":0},{"$f":"'MI Summary'!R34","v":0},{"$f":"'MI Summary'!S34","v":0},{"$f":"'MI Summary'!T34","v":0},{"$f":"'MI Summary'!U34","v":0},{"$f":"'MI Summary'!V34","v":0},{"$f":"'MI Summary'!W34","v":0}]
[null,null,{"$f":"'MI Summary'!B35","v":"Number of complaints handled by the Provider YTD"},{"$f":"'MI Summary'!C35","v":0},{"$f":"'MI Summary'!D35","v":0},{"$f":"'MI Summary'!E35","v":0},{"$f":"'MI Summary'!F35","v":0},{"$f":"'MI Summary'!G35","v":0},{"$f":"'MI Summary'!H35","v":0},{"$f":"'MI Summary'!I35","v":0},{"$f":"'MI Summary'!J35","v":0},{"$f":"'MI Summary'!K35","v":0},{"$f":"'MI Summary'!L35","v":0},{"$f":"'MI Summary'!M35","v":0},{"$f":"'MI Summary'!N35","v":0},{"$f":"'MI Summary'!O35","v":0},{"$f":"'MI Summary'!P35","v":0},{"$f":"'MI Summary'!Q35","v":0},{"$f":"'MI Summary'!R35","v":0},{"$f":"'MI Summary'!S35","v":0},{"$f":"'MI Summary'!T35","v":0},{"$f":"'MI Summary'!U35","v":0},{"$f":"'MI Summary'!V35","v":0},{"$f":"'MI Summary'!W35","v":0}]
[null,null,{"$f":"'MI Summary'!B37","v":"Number of complaints referred to the Authority in month"},{"$f":"'MI Summary'!C37","v":0},{"$f":"'MI Summary'!D37","v":0},{"$f":"'MI Summary'!E37","v":0},{"$f":"'MI Summary'!F37","v":0},{"$f":"'MI Summary'!G37","v":0},{"$f":"'MI Summary'!H37","v":0},{"$f":"'MI Summary'!I37","v":0},{"$f":"'MI Summary'!J37","v":0},{"$f":"'MI Summary'!K37","v":0},{"$f":"'MI Summary'!L37","v":0},{"$f":"'MI Summary'!M37","v":0},{"$f":"'MI Summary'!N37","v":0},{"$f":"'MI Summary'!O37","v":0},{"$f":"'MI Summary'!P37","v":0},{"$f":"'MI Summary'!Q37","v":0},{"$f":"'MI Summary'!R37","v":0},{"$f":"'MI Summary'!S37","v":0},{"$f":"'MI Summary'!T37","v":0},{"$f":"'MI Summary'!U37","v":0},{"$f":"'MI Summary'!V37","v":0},{"$f":"'MI Summary'!W37","v":0}]
[null,null,{"$f":"'MI Summary'!B38","v":"Number of complaints referred to the Authority YTD "},{"$f":"'MI Summary'!C38","v":0},{"$f":"'MI Summary'!D38","v":0},{"$f":"'MI Summary'!E38","v":0},{"$f":"'MI Summary'!F38","v":0},{"$f":"'MI Summary'!G38","v":0},{"$f":"'MI Summary'!H38","v":0},{"$f":"'MI Summary'!I38","v":0},{"$f":"'MI Summary'!J38","v":0},{"$f":"'MI Summary'!K38","v":0},{"$f":"'MI Summary'!L38","v":0},{"$f":"'MI Summary'!M38","v":0},{"$f":"'MI Summary'!N38","v":0},{"$f":"'MI Summary'!O38","v":0},{"$f":"'MI Summary'!P38","v":0},{"$f":"'MI Summary'!Q38","v":0},{"$f":"'MI Summary'!R38","v":0},{"$f":"'MI Summary'!S38","v":0},{"$f":"'MI Summary'!T38","v":0},{"$f":"'MI Summary'!U38","v":0},{"$f":"'MI Summary'!V38","v":0},{"$f":"'MI Summary'!W38","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reworks "]