{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Invoice Template","Invoice Details","Background","Submitting Invoices","Contact Us","Sheet2","Sites","utilization report sample","bulk inv upload"," Shift Table ","AFter Hour Rates","Physician Reporting Periods"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"comments":0,"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":"Instructions","index":0,"n_rows":76,"n_cols":1,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["APSA Hours Reporting After Hours Premium Invoice\n\nInstructions"]
[]
["Due to time constraints to meet new PMA requirements, this excel-based reporting and invoice template will be used to report"]
["hours until such time that a more sophisticated tool and system can be developed."]
["We appreciate your collaboration and cooperation as we implement this change."]
[]
["PLEASE NOTE: For providers and groups already submitting invoices and hours reporting, this is not intended to"]
["change your current workflow; however, you must use this new form for submission."]
[]
["Please regulary check the Medical Staff Website to ensure you are using the most up to date version of the template."]
["https://medicalstaff.islandhealth.ca/pma "]
[]
["STEP 1: Save a Copy of this Template to Your Computer"]
["This file has programmed buttons that are \"Macro enabled\". The macros may be locked."]
["To unlock the features:"]
["Save a copy of the excel file on your computer "]
["Close the File"]
["Reopen the file"]
["Go to the top left of excel and click on \"File\""]
["If the Enable Contect sheild is there click on \"Enable Content\" as shown"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OR"]
["If you see this message at the top of your screen, click \"Enable Content\";"]
["this will unlock the features in the template including calculations and button functions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 2: Test"]
["Test to ensure the features are working by clicking on the CLEAR INVOICE button."]
["If you do not get the message, \"Are you sure you would like to clear the invoice?\","]
["close the file, reopen and repeat steps. Contact Physician Compensation if the issue persists at"]
["Physician_Comp@islandhealth.ca "]
[]
["STEP 3: Complete the Required Fields in the Invoice"]
["Go to Invoice Template (see tab names below)"]
["Complete lines 4 through 7"]
["Enter all shift information in line 13 and beyond, as needed"]
["For further information and instructions on how to complete required fields, see the Invoice Details tab"]
[]
["STEP 4: Calculate Invoice"]
["Once all of the shift details have been answered, click on the CALCULATE INVOICE button."]
["This will ensure the invoice is accurate and complete by looking for missing information, checking that"]
["hours entered balance for each day, and looking for any overlapping shift times on the same day (for the same person)"]
[]
["STEP 5: Verify Invoice"]
["Once the invoice is complete and there are no errors, verify by the invoice by"]
["selecting 'Yes' in the 'Physician/Group Validation\" drop down box."]
[]
["STEP 6: Save Invoice"]
["Save the invoice with a file name that includes your or your group's name and the reporting period."]
[]
["STEP 6: Submit Invoice"]
["Using an Island Health email address only, submit the completed invoice to:"]
["Physician_Comp@islandhealth.ca "]
["Files cannot be submitted using a non-Island Health email address as the Island Health external email address firewall will block the file from being received."]
["If you, or the individual submitting the invoice on your behalf, cannot access an Island Health email address or do not have one, please contact"]
["Physician Compensation to discuss alternate arrangements."]

{"sheet":"Invoice Template","index":1,"n_rows":100,"n_cols":48,"rows_kept":100,"cut":false,"hidden":false,"merged":[[7,7,7,9],[9,12,9,15],[8,12,8,14],[7,12,7,14],[5,12,5,15],[3,12,3,15],[6,12,6,15],[4,12,4,15],[7,10,7,11],[10,12,10,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"HOURS SUBMISSION AND AFTER HOURS INVOICE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"remove macro from logo"]
[null,null,null,null,null,null,"Contract/ Program Name",null,null,null,null,"Contract #:"]
[null,null,null,null,null,null,"Provider Name/GROUP:",null,null,null,null,"Site/ Facility (from drop down list)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need Assistance? Contact:"]
[null,null,null,null,null,null,"Provider MSP#",null,null,null,null,"Site/ Facility (if not in drop down list)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physician_Comp@islandhealth.ca"]
[null,null,null,null,null,null,null,null,null,null,null,"Report Period: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V1.0"]
[null,null,null,null,"Physician/ Group \nValidation (Drop Down)",null,null,"I certify that this invoice is for actual hours worked as documented (consistent with the terms of the contract)",null,null,"Certification Authority (CA) Approval (enter name):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Using Island Health email, forward invoice to Certification Authority (CA)"]
[null,null,null,null,null,null,"Date:",null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"I confirm to the best of my knowledge that the hours were worked \n(consistent with the terms of the contract)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Once Approved by CA forward to:"]
["Col A, B, D - If cells are blue these will prepopulate - \ndo not override","If Cells is Pink enter value for each line",null,null,null,null,null,null,null,null,null,null,"Direct/ Indirect & NonPatient/ Other must add up to Total Hours",null,null,"Explain Other ie Clinical Admin \n(must be allowable in contract terms)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physician_Comp@Islandhealth.ca"]
["Physician Name - \nLast Name, First Name","Practioner MSP#","Contract #","If Multi Facility, Name Here","Date of Service","Weekday or\n Weekend","Stat/Lieu Day\n (Auto-\npopulate)","Shift \nScheduled/ UnScheduled\n(Drop down)","ON/OFF \nSITE\n(Drop down)","Shift Start Time\n(hhmm) \nround to 15 min ","Shift End Time\n(hhmm) \nround to 15 min","Total\nHours","Direct","Indirect.","NonPatient/Other","Notes","Base Hours","Weekday \nStart Time","Weekday \nEnd time","Weekday\nHours","Weekday \nRate","Weekday \nDollars","After Hours Evening","Evening \nStart Time","Evening \nEnd time","Evening \n(18:00-23:00) Hours","Evening (18:00-23:00)\n Rate","Evening \nDollars","After Hours Weekend/Stat","Weekend/Stat \nStart Time","Weekend/Stat \nEnd time","Weekend/Stat \n(8:00-23:00) \nHours","Weekend/Stat \n(8:00-23:00)\n Rate","Weekend/Stat\n Dollars","After Hours Night","Night \nStart Time","Night \nEnd time","Night \n(23:00 to 8:00) \nHours","Night \n(23:00-8:00) \nRate","Night \nDollars","Base + After hours","After Hours.","After Hours \nPayment","Errors","Physician Approve","Signing Authority","Reporting PD","Site2"]
[{"$f":"+IF(OR($E13=\"\",UPPER($H$5)=\"GROUP\"),\"\",$H$5)","v":""},{"$f":"+IF(OR(E13=\"\",UPPER($H$5)=\"GROUP\"),\"\",$H$6)","v":""},{"$f":"IF(ISBLANK($E13),\"\",$M$4)","v":""},null,null,{"$f":"IF(E13=\"\", \"\", IF(OR(WEEKDAY(E13)=1, WEEKDAY(E13)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E13,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK($E13),\"\",$M$7)","v":""},{"$f":"IF(E13<>\"\",IF(UPPER($M$5)=\"MULTI\",$D13,IF(UPPER($M$5)=\"NOT ON LIST\",$M$6,$M$5)),\"\")","v":""}]
["","","",null,null,{"$f":"IF(E14=\"\", \"\", IF(OR(WEEKDAY(E14)=1, WEEKDAY(E14)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E14,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK($E14),\"\",$M$7)","v":""},{"$f":"IF(E14<>\"\",IF(UPPER($M$5)=\"MULTI\",$D14,IF(UPPER($M$5)=\"NOT ON LIST\",$M$6,$M$5)),\"\")","v":""}]
["","","",null,null,{"$f":"IF(E15=\"\", \"\", IF(OR(WEEKDAY(E15)=1, WEEKDAY(E15)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E15,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,{"$f":"IF(E16=\"\", \"\", IF(OR(WEEKDAY(E16)=1, WEEKDAY(E16)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E16,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,{"$f":"IF(E17=\"\", \"\", IF(OR(WEEKDAY(E17)=1, WEEKDAY(E17)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E17,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E18,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,{"$f":"IF(E19=\"\", \"\", IF(OR(WEEKDAY(E19)=1, WEEKDAY(E19)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E19,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,{"$f":"IF(E20=\"\", \"\", IF(OR(WEEKDAY(E20)=1, WEEKDAY(E20)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E20,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E21,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E22,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E23,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E24,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E25,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E26,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E27,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E28,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E29,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E30,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E31,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E32,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E33,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E34,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E35,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E36,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E37,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E38,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E39,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E40,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E41,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E42,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E43,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E44,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
[{"$f":"+IF(OR($E45=\"\",UPPER($H$5)=\"GROUP\"),\"\",$H$5)","v":""},{"$f":"+IF(OR(E45=\"\",UPPER($H$5)=\"GROUP\"),\"\",$H$6)","v":""},{"$f":"IF(ISBLANK($E45),\"\",$M$4)","v":""},null,null,"",{"$f":"IF(ISNA(VLOOKUP(E45,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",{"$f":"IF(E45<>\"\",IF(UPPER($M$5)=\"MULTI\",$D45,IF(UPPER($M$5)=\"NOT ON LIST\",$M$6,$M$5)),\"\")","v":""}]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E46,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E47,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E48,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E49,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E50,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E51,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E52,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E53,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E54,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E55,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E56,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E57,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E58,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E59,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E60,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E61,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E62,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E63,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E64,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E65,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E66,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E67,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E68,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E69,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E70,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E71,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E72,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E73,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E74,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E75,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E76,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
[{"$f":"+IF(OR($E77=\"\",UPPER($H$5)=\"GROUP\"),\"\",$H$5)","v":""},{"$f":"+IF(OR(E77=\"\",UPPER($H$5)=\"GROUP\"),\"\",$H$6)","v":""},{"$f":"IF(ISBLANK($E77),\"\",$M$4)","v":""},null,null,"",{"$f":"IF(ISNA(VLOOKUP(E77,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",{"$f":"IF(E77<>\"\",IF(UPPER($M$5)=\"MULTI\",$D77,IF(UPPER($M$5)=\"NOT ON LIST\",$M$6,$M$5)),\"\")","v":""}]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E78,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK($E78),\"\",$M$7)","v":""},""]
["","","",null,null,{"$f":"IF(E79=\"\", \"\", IF(OR(WEEKDAY(E79)=1, WEEKDAY(E79)=7), \"Weekend\", \"Weekday\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(E79,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E80,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E81,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E82,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E83,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E84,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E85,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E86,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E87,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E88,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E89,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E90,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E91,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E92,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E93,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E94,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E95,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E96,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E97,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E98,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
["","","",null,null,"",{"$f":"IF(ISNA(VLOOKUP(E99,'Physician Reporting Periods'!F:F,1,0)),\"\",\"STAT\")","v":""},null,null,null,null,{"$f":"ROUND(MOD(TblInvoice[[#This Row],[Shift End Time\n(hhmm) \nround to 15 min]]-TblInvoice[[#This Row],[Shift Start Time\n(hhmm) \nround to 15 min ]],1)*24,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($G$8=\"YES\",$H$5&\" \"&TEXT($H$9,\"dd/mm/yy\"),\"\"))","v":""},{"$f":"IF(ISBLANK(TblInvoice[[#This Row],[Date of Service]]),\"\",IF($M$8<>\"\",$M$8&\" \"& TEXT($M$9,\"dd/mm/yy\"),\"\"))","v":""},"",""]
[{"$f":"IF(ISBLANK(E100),\"\",$H$5)","v":"00:00:00"},{"$f":"IF(ISBLANK(E100),\"\",VLOOKUP(A100,BulkUpld[[Physician Name]:[MSP '#]],2,0))","v":{"$error":"#N/A"}},null,null,"Need more lines? Submit a separate invoice",null,null,null,null,null,null,{"$f":"SUBTOTAL(109,TblInvoice[Total\nHours])","v":0},{"$f":"SUBTOTAL(109,TblInvoice[Direct])","v":0},{"$f":"SUBTOTAL(109,TblInvoice[Indirect.])","v":0},{"$f":"SUBTOTAL(109,TblInvoice[NonPatient/Other])","v":0},null,null,null,null,{"$f":"SUBTOTAL(109,TblInvoice[Weekday\nHours])","v":0},null,{"$f":"SUBTOTAL(109,TblInvoice[Weekday \nDollars])","v":0},null,null,null,{"$f":"SUBTOTAL(109,TblInvoice[Evening \n(18:00-23:00) Hours])","v":0},null,{"$f":"SUBTOTAL(109,TblInvoice[Evening \nDollars])","v":0},null,null,null,{"$f":"SUBTOTAL(109,TblInvoice[Weekend/Stat \n(8:00-23:00) \nHours])","v":0},null,{"$f":"SUBTOTAL(109,TblInvoice[Weekend/Stat\n Dollars])","v":0},null,null,null,{"$f":"SUBTOTAL(109,TblInvoice[Night \n(23:00 to 8:00) \nHours])","v":0},null,{"$f":"SUBTOTAL(109,TblInvoice[Night \nDollars])","v":0},{"$f":"SUM(TblInvoice[Base + After hours])-SUMIFS(TblInvoice[Base + After hours],TblInvoice[Shift \nScheduled/ UnScheduled\n(Drop down)],\"worksafe portion\")","v":0},{"$f":"SUM(AP13:AP99)","v":0},{"$f":"SUM(AQ13:AQ99)","v":0}]

{"sheet":"Invoice Details","index":2,"n_rows":144,"n_cols":2,"rows_kept":144,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["Invoice Field Details"]
[]
["Contract/ Program"]
["Indicate the program for which you are submitting an invoice."]
["If you have more than 1 contract that requires invoice submission, you must submit a separate invoice for each."]
[]
["Provider Name/ Group:"]
["For Individual Providers: Enter Your Name as Last name, First name"]
["For Groups: Type \"Group\" (ensuring correct spelling)"]
["Please submit all physician hours for the group on the same invoice."]
[]
["MSP#"]
["If this is not a group invoice enter your MSP# here."]
[]
["Contract #"]
["If you know your contract number enter it here."]
[]
["Site/ Facility (from list)"]
["From the drop down list, indicate which facility you have worked at."]
["If you are working at multiple sites or your site is not on this list then choose the \"Not on List\" option"]
[]
["Site/ Facility (if not in list)"]
["Indicate the site(s) if you indicated \"Not on List\" for Site/ Facility (from list)"]
[]
["Report Period: "]
["Timeframe that covers the invoice"]
["Please submit separate invoices for each pay period"]
[]
["Entering shift details"]
[]
["Groups only: Physician Name - \nLast Name, First Name"]
["Enter phsycian name. Please do not use shortened/nicknames for last names"]
[]
["Groups Only: Practioner MSP#"]
["Do your best to fill in this field as it helps to ensure we are recording and paying the correct physician"]
[]
["Date"]
["Date of Service: Enter as dd/mm/yy or mm/dd/yy (you can see the format that your computer supports in the"]
["bottom right corner of your screen. If entered correctly, the format will correct itself to show the day of the week and the date)"]
[]
["Stat/Lieu Day\n (Auto-\npopulate)"]
["This field will pre-populate with \"Stat\" for all stats and stats in lieu"]
[]
["Shift \nScheduled/ Unscheduled\n(Drop down)"]
["SCHEDULED "]
["UNSCHEDULED"]
[]
["ON/OFF \nSITE\n(Drop down)"]
["ON"]
["OFF"]
["Only time worked on site will be eligible for After Hours premiums"]
[]
["Shift Start Time\n(hhmm) \n15 min incr"]
["use 24 hour clock"]
["there is no need to enter \":\" for this field"]
["must enter in 15 minute increments only"]
["enter 0000 for midnight"]
["enter a new line when breaks exceed 30 minutes"]
[]
["Shift End Time\n(hhmm) \n15 min incr"]
["use 24 hour clock"]
["there is no need to enter \":\" for this field"]
["must enter in 15 minute increments only"]
["enter 0000 for midnight"]
[]
["Total\nHours"]
["This is a Calculated field (end time minus start time)"]
[]
["Direct"]
["Enter Direct Patient care hours worked during the shift"]
["Refer to definitions in contract terms"]
[]
["Indirect"]
["Enter Indirect Patient care hours worked during the shift"]
["Refer to definitions in contract terms"]
[]
["Clinical Admin/ Other"]
["Enter Non-Patient care hours worked during the shift including Clinical Administration time or Travel"]
["Refer to applicable category and definitions in contract terms"]
[]
["Notes"]
["Terms of the contract may indicate that an explanation of what was done during the Clinical Admin/ Other"]
["category time is provided. Enter here if so."]
[]
["Base + After hours"]
["Calculated field will populate by using the Calculate button"]
["This includes all hours in the shift"]
[]
["After Hours"]
["This is a total of the hours in the shift that qualify for after hours premiums"]
[]
["After Hours \nPayment"]
["After hours payment is calculated based on the after hours shift times multiplied by the applicable rate"]
[]
["Errors"]
["potential errors generated by \"Calculate\" button:"]
[]
[null,"Unbalanced:"]
[null,"when Direct/Indirect Other hours column do not add up to the total hours then a message of \"Unbalanced\" will appear"]
[null,"Go back to those columns and correct. "]
[null,"Once corrected press the \"Calculate\" button again"]
[]
[null,"Overlap:"]
[null,"Identified overlapping shifts on the same day by the same provider"]
[null,"Go back to adjust the times to correct"]
[null,"Once corrected press the \"Calculate\" button"]
[]
["Buttons:"]
[]
[null,"Calculate Invoice"]
[null,"Checks that direct+indirect+Other Hours columns balance with Total Hours covered by the shift"]
[null,"Checks that there are no overlapping shifts for the same provider on the same day"]
[null,"Calculates after hour premiums for qualifying timeframes"]
[null,"Only calculates the after hour premiums payable. "]
[null,"Payment for other hours will be done manually by Physician Compensation according to contract terms and applicable rates."]
[]
[null,"Show/Hide Details"]
[null,"Expands and collapses columns that show the backup for total hours in shift and "]
[null,"after hours premium calculations"]
[]
[null,"Hide/Unhide Lines"]
[null,"This will hide or unhide the blank lines in the invoice"]
[]
[null,"Clear Invoice"]
[null,"Resets and deletes all previously populated fields in invoice"]
[]
["Features:"]
[null,"Provider Name/ Group"]
[null,"For individuals contract enter Last Name, First Name "]
[null,"For Groups indicate \"Group\" (spell full word)"]
[null,"The field or MSP# will be disabled"]
[null,"The columns to the left will become visible where Provider and MSP# will need to populated"]
[]
[null,"Physician/ Group Validation (Drop Down)"]
[null,"Once the invoice is complete and the calculation button has been clicked the error are cleared then "]
[null,"use the drop down to indicate \"Yes\""]
[null,"This means that the invoice is for actual hours worked as documented"]
[null,"The Date is populated in cell below"]
[null,"The Provider Name or \"Group\" and Date is recorded in the background"]
[]
[null,"Certification Authority (CA) Approval (enter name):"]
[null,"Certification authority to enter their name in this field (no electronic signature or copy signature)"]
[null,"The date will populate below"]
[null,"The CA name and date is recorded in the background"]

{"sheet":"Background","index":3,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Background"]
["Effective April 1, 2023, the recently negotiated and ratified 2022 Physician Master Agreement (PMA) between the Doctors of BC and the Ministry of Health created new hourly reporting obligations for physicians providing services under Alternative Payment Subsidiary Agreement (APSA) service contracts and established After Hours Premium (AHP) payments for physicians providing services under APSA service contracts. Reporting requirements and premium eligibility information are detailed below."]
[]
["APSA Service Contract Hours Reporting"]
["Under the 2022 PMA, physicians working under APSA service contracts must report hours spent providing services with the following information:"]
["·        Date of service;"]
["·        Location of service, identified as “on-site” or “off-site”;"]
["·        For scheduled services, start and stop times rounded to the nearest 15 minute increment. Where scheduled services are provided more than 30 minutes apart within the same day, separate daily entries are required; and,"]
["·        For unscheduled services, total hours rounded to the nearest 15 minute increment."]
["Please note that we will still require each daily hour reporting entry be separated into Direct, Indirect, and Non-Patient care hours. "]
[]
["After-Hours Premiums"]
["In addition to clinical service contract hourly rates, AHPs will be paid for clinical services provided within a Health Authority Facility as follows:"]
["·        Evening (1800 to 2300) $25 per hour;"]
["·        Nights (2300 to 0800) $35 per hour; and,"]
["·        Weekends/Holidays (0800 to 2300) $25 per hour."]
[]
["In order to receive AHP payments, invoicing for all scheduled and unscheduled services provided after hours must include:"]
["·        Date of service"]
["·        Health Authority Facility name; and,"]
["·        Start and stop time rounded to the nearest 15-minute increment."]
[]
["Support for New Reporting Obligations:"]
["The reporting obligations created by the 2022 PMA represent a significant process change for Island Health Medical Staff Contracts and Compensation. Due to time constraints, this excel-based invoice template will be used to report hours until such time that a more sophisticated tool and system can be developed."]
[]
["Invoices must be transmitted via an Island Health email address. Due to security reasons, non-Island Health email addresses cannot be used to submit invoices; the email will not be received. If you or the person submitting invoices on your behalf cannot access an Island Health email address, please contact Physician Compensation to discuss alternate arrangements."]
[]
["We sincerely appreciate your collaboration and cooperation as we implement this change."]
["If you have any questions please reach out to Physician Compensation at:"]
["Physician_comp@islandhealth.ca"]

{"sheet":"Submitting Invoices","index":4,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Forwarding Instructions"]
[]
["Sending the Invoice:"]
["Only send/transfer this invoice using an Island Health email account. Sending via a non-Island "]
["Health email address will result in the file not being received."]
[]
["If you, or the person submitting invoices on your behalf, do not have access to an Island Health "]
["email account, please contact:"]
["Physician_Comp@Islandhealth.ca"]
[]
[]
["PLEASE NOTE: For providers and groups already submitting invoices and hours reporting, this is not intended to"]
["change your current workflow; however, you must use this new form for submission."]

{"sheet":"Contact Us","index":5,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Contact Us"]
[]
["Any questions/ concerns? Contact:"]
[]
["Physician_Comp@islandhealth.ca"]

{"sheet":"Sheet2","index":6,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Date","Date = Cells.Find(What:=\"Date\", LookIn:=xlFormulas).column",{"$f":"\"Dim \"&A1&\" as Long\"","v":"Dim Date as Long"},"=","Columns(",{"$f":"+A1","v":"Date"},").Hidden = True",null,null,{"$f":"CONCATENATE(D1,E1,F1,G1)","v":"=Columns(Date).Hidden = True"},13]
["Contract","Contract = Cells.Find(What:=\"Contract*#\", LookIn:=xlFormulas).column",{"$f":"\"Dim \"&A2&\" as Long\"","v":"Dim Contract as Long"},"=","cells.find(what:=\"",{"$f":"+A2","v":"Contract"},"\", LookIn:=xlFormulas).Row",null,null,{"$f":"CONCATENATE(A2,D2,E2,F2,G2)","v":"Contract=cells.find(what:=\"Contract\", LookIn:=xlFormulas).Row"},14]
["dayorend","dayorend = Cells.Find(What:=\"Weekday*or*Weekend\", LookIn:=xlFormulas).column","Dim dayorend as Long","=","cells.find(what:=\"",{"$f":"+A3","v":"dayorend"},"\", LookIn:=xlFormulas).Row",null,null,"dayorend=cells.find(what:=\"dayorend\", LookIn:=xlFormulas).Row",15]
["Stat_Lieu","Stat_Lieu = Cells.Find(What:=\"Stat/Lieu*\", LookIn:=xlFormulas).column","Dim Stat_Lieu as Long","=","cells.find(what:=\"","Stat_Lieu","\", LookIn:=xlFormulas).Row",null,null,"Stat_Lieu=cells.find(what:=\"Stat_Lieu\", LookIn:=xlFormulas).Row",17]
["Shift","Shift = Cells.Find(What:=\"*Scheduled*Unscheduled*\", LookIn:=xlFormulas).column","Dim Shift as Long","=","cells.find(what:=\"","Shift","\", LookIn:=xlFormulas).Row",null,null,"Shift=cells.find(what:=\"Shift\", LookIn:=xlFormulas).Row",18]
["ON_OFF_Site","ON_OFF_Site = Cells.Find(What:=\"ON*OFF*SITE*\", LookIn:=xlFormulas).column","Dim ON_OFF_Site as Long","=","cells.find(what:=\"","ON_OFF_Site","\", LookIn:=xlFormulas).Row",null,null,"ON_OFF_Site=cells.find(what:=\"ON_OFF_Site\", LookIn:=xlFormulas).Row",19]
["Site","Site = Cells.Find(What:=\"Site\", LookIn:=xlFormulas).column","Dim Site as Long","=","cells.find(what:=\"","Site","\", LookIn:=xlFormulas).Row",null,null,"Site=cells.find(what:=\"Site\", LookIn:=xlFormulas).Row",20]
["Shift_Start_Time","Shift_Start_Time = Cells.Find(What:=\"Shift*Start*Time*\", LookIn:=xlFormulas).column","Dim Shift_Start_Time as Long","=","cells.find(what:=\"","Shift_Start_Time","\", LookIn:=xlFormulas).Row",null,null,"Shift_Start_Time=cells.find(what:=\"Shift_Start_Time\", LookIn:=xlFormulas).Row",21]
["Shift_End_Time","Shift_End_Time = Cells.Find(What:=\"Shift*End*Time*\", LookIn:=xlFormulas).column","Dim Shift_End_Time as Long","=","cells.find(what:=\"","Shift_End_Time","\", LookIn:=xlFormulas).Row",null,null,"Shift_End_Time=cells.find(what:=\"Shift_End_Time\", LookIn:=xlFormulas).Row",22]
["Total_Shift_Hours","Total_Shift_Hours = Cells.Find(What:=\"Total*Hours\", LookIn:=xlFormulas).column","Dim Total_Shift_Hours as Long","=","cells.find(what:=\"","Total_Shift_Hours","\", LookIn:=xlFormulas).Row",null,null,"Total_Shift_Hours=cells.find(what:=\"Total_Shift_Hours\", LookIn:=xlFormulas).Row",23]
["Direct","Direct = Cells.Find(What:=\"Direct\", LookIn:=xlFormulas).column","Dim Direct as Long","=","cells.find(what:=\"","Direct","\", LookIn:=xlFormulas).Row",null,null,"Direct=cells.find(what:=\"Direct\", LookIn:=xlFormulas).Row",24]
["Indirect","Indirect = Cells.Find(What:=\"Indirect\", LookIn:=xlFormulas).column","Dim Indirect as Long","=","cells.find(what:=\"","Indirect","\", LookIn:=xlFormulas).Row",null,null,"Indirect=cells.find(what:=\"Indirect\", LookIn:=xlFormulas).Row",25]
["Cadmin_Other","Cadmin_Other = Cells.Find(What:=\"Clinical*\", LookIn:=xlFormulas).column","Dim Cadmin_Other as Long","=","cells.find(what:=\"","Cadmin_Other","\", LookIn:=xlFormulas).Row",null,null,"Cadmin_Other=cells.find(what:=\"Cadmin_Other\", LookIn:=xlFormulas).Row",26]
["Base","Base = Cells.Find(What:=\"Base Hours\", LookIn:=xlFormulas).column","Dim Base as Long","=","Columns(","Base",").Hidden = True",null,null,{"$f":"CONCATENATE(D14,E14,F14,G14)","v":"=Columns(Base).Hidden = True"},28]
["WeekdayStart","WeekdayStart = Cells.Find(What:=\"Weekday*Start*Time\", LookIn:=xlFormulas).column","Dim WeekdayStart as Long","=","Columns(","WeekdayStart",").Hidden = True",null,null,"=Columns(WeekdayStart).Hidden = True",29]
["WeekdayEnd","WeekdayEnd = Cells.Find(What:=\"Weekday*End*time\", LookIn:=xlFormulas).column","Dim WeekdayEnd as Long","=","Columns(","WeekdayEnd",").Hidden = True",null,null,"=Columns(WeekdayEnd).Hidden = True",30]
["WeekdayHours","WeekdayHours = Cells.Find(What:=\"Weekday*(8:00-18:00)*Hours\", LookIn:=xlFormulas).column","Dim WeekdayHours as Long","=","cells.find(what:=\"","WeekdayHours","\", LookIn:=xlFormulas).Row",null,null,"WeekdayHours=cells.find(what:=\"WeekdayHours\", LookIn:=xlFormulas).Row",31]
["WeekdayRate","WeekdayRate = Cells.Find(What:=\"Weekday*(08:00-18:00)* Rate\", LookIn:=xlFormulas).column","Dim WeekdayRate as Long","=","Columns(",{"$f":"+A18","v":"WeekdayRate"},").Hidden = True",null,null,{"$f":"CONCATENATE(D18,E18,F18,G18)","v":"=Columns(WeekdayRate).Hidden = True"},32]
["WeekdayDollars","WeekdayDollars = Cells.Find(What:=\"Weekday*Dollars\", LookIn:=xlFormulas).column","Dim WeekdayDollars as Long","=","cells.find(what:=\"","WeekdayDollars","\", LookIn:=xlFormulas).Row",null,null,"WeekdayDollars=cells.find(what:=\"WeekdayDollars\", LookIn:=xlFormulas).Row",33]
["Evening","Evening = Cells.Find(What:=\"After*Hours*Evening\", LookIn:=xlFormulas).column","Dim Evening as Long","=","Columns(","Evening",").Hidden = True",null,null,{"$f":"CONCATENATE(D20,E20,F20,G20)","v":"=Columns(Evening).Hidden = True"},34]
["EveningStart","EveningStart = Cells.Find(What:=\"Evening*Start*Time\", LookIn:=xlFormulas).column","Dim EveningStart as Long","=","Columns(","EveningStart",").Hidden = True",null,null,"=Columns(EveningStart).Hidden = True",35]
["EveningEnd","EveningEnd = Cells.Find(What:=\"Evening*End*time\", LookIn:=xlFormulas).column","Dim EveningEnd as Long","=","Columns(","EveningEnd",").Hidden = True",null,null,"=Columns(EveningEnd).Hidden = True",36]
["EveningHours","EveningHours = Cells.Find(What:=\"Evening*(18:00-23:00)*Hours\", LookIn:=xlFormulas).column","Dim EveningHours as Long","=","cells.find(what:=\"","EveningHours","\", LookIn:=xlFormulas).Row",null,null,"EveningHours=cells.find(what:=\"EveningHours\", LookIn:=xlFormulas).Row",37]
["EveningRate","EveningRate = Cells.Find(What:=\"Evening*(18:00-23:00)*Rate\", LookIn:=xlFormulas).column","Dim EveningRate as Long","=","Columns(",{"$f":"+A24","v":"EveningRate"},").Hidden = True",null,null,{"$f":"CONCATENATE(D24,E24,F24,G24)","v":"=Columns(EveningRate).Hidden = True"},1]
["EveningDollars","EveningDollars = Cells.Find(What:=\"Evening*Dollars\", LookIn:=xlFormulas).column","Dim EveningDollars as Long","=","cells.find(what:=\"",{"$f":"+A25","v":"EveningDollars"},"\", LookIn:=xlFormulas).Row",null,null,"EveningDollars=cells.find(what:=\"EveningDollars\", LookIn:=xlFormulas).Row",2]
["WeekendStat","WeekendStat = Cells.Find(What:=\"After*Hours*Weekend/Stat\", LookIn:=xlFormulas).column","Dim WeekendStat as Long","=","Columns(","WeekendStat",").Hidden = True",null,null,{"$f":"CONCATENATE(D26,E26,F26,G26)","v":"=Columns(WeekendStat).Hidden = True"},3]
["WeekendStatStart","WeekendStatStart = Cells.Find(What:=\"Weekend/Stat*Start*Time\", LookIn:=xlFormulas).column","Dim WeekendStatStart as Long","=","Columns(","WeekendStatStart",").Hidden = True",null,null,"=Columns(WeekendStatStart).Hidden = True",4]
["WeekendStatEnd","WeekendStatEnd = Cells.Find(What:=\"Weekend/Stat*End*time\", LookIn:=xlFormulas).column","Dim WeekendStatEnd as Long","=","Columns(","WeekendStatEnd",").Hidden = True",null,null,"=Columns(WeekendStatEnd).Hidden = True",5]
["WeekendStatHours","WeekendStatHours = Cells.Find(What:=\"Weekend/Stat*(8:00-23:00)*Hours\", LookIn:=xlFormulas).column","Dim WeekendStatHours as Long","=","cells.find(what:=\"","WeekendStatHours","\", LookIn:=xlFormulas).Row",null,null,"WeekendStatHours=cells.find(what:=\"WeekendStatHours\", LookIn:=xlFormulas).Row",6]
["WeekendStatRate","WeekendStatRate = Cells.Find(What:=\"Weekend/Stat*(8:00-23:00)*Rate\", LookIn:=xlFormulas).column","Dim WeekendStatRate as Long","=","Columns(",{"$f":"+A30","v":"WeekendStatRate"},").Hidden = True",null,null,{"$f":"CONCATENATE(D30,E30,F30,G30)","v":"=Columns(WeekendStatRate).Hidden = True"},7]
["WeekendStatDollars","WeekendStatDollars = Cells.Find(What:=\"Weekend/Stat*Dollars\", LookIn:=xlFormulas).column","Dim WeekendStatDollars as Long","=","cells.find(what:=\"","WeekendStatDollars","\", LookIn:=xlFormulas).Row",null,null,null,8]
["Night","Night = Cells.Find(What:=\"After*Hours*Night\", LookIn:=xlFormulas).column","Dim Night as Long","=","Columns(","Night",").Hidden = True",null,null,{"$f":"CONCATENATE(D32,E32,F32,G32)","v":"=Columns(Night).Hidden = True"},9]
["NightStart","NightStart = Cells.Find(What:=\"Night*Start*Time\", LookIn:=xlFormulas).column","Dim NightStart as Long","=","Columns(","NightStart",").Hidden = True",null,null,"=Columns(NightStart).Hidden = True",10]
["NightEndd","NightEndd = Cells.Find(What:=\"Night*End*time\", LookIn:=xlFormulas).column","Dim NightEndd as Long","=","Columns(","NightEndd",").Hidden = True",null,null,"=Columns(NightEndd).Hidden = True",11]
["NightHours","NightHours = Cells.Find(What:=\"Night*(23:00 to 8:00)*Hours\", LookIn:=xlFormulas).column","Dim NightHours as Long","=","cells.find(what:=\"","NightHours","\", LookIn:=xlFormulas).Row",null,null,"Shift_End_Time = Cells.Find(what:=\"Shift End Time (hh:mm) 15 min incr\", LookIn:=xlFormulas).Row",12]
["NightRate","NightRate = Cells.Find(What:=\"Night*(23:00-8:00)*Rate\", LookIn:=xlFormulas).column","Dim NightRate as Long","=","Columns(",{"$f":"+A36","v":"NightRate"},").Hidden = True",null,null,{"$f":"CONCATENATE(D36,E36,F36,G36)","v":"=Columns(NightRate).Hidden = True"}]
["NightDollars","NightDollars = Cells.Find(What:=\"Night*Dollars\", LookIn:=xlFormulas).column","Dim NightDollars as Long","=","cells.find(what:=\"","NightDollars","\", LookIn:=xlFormulas).Row",null,null,"Direct = Cells.Find(what:=\"Direct\", LookIn:=xlFormulas).Row"]
["Total_Hours","Total_Hours = Cells.Find(What:=\"Base + After Hours\", LookIn:=xlFormulas).column","Dim Total_Hours as Long","=","cells.find(what:=\"","Total_Hours","\", LookIn:=xlFormulas).Row",null,null,"Indirect = Cells.Find(what:=\"Indirect\", LookIn:=xlFormulas).Row"]
["After_Hours","After_Hours = Cells.Find(What:=\"After*Hours\", LookIn:=xlFormulas).column","Dim After_Hours as Long","=","cells.find(what:=\"","After_Hours","\", LookIn:=xlFormulas).Row",null,null,"Cadmin_Other = Cells.Find(what:=\"Clinical Admin/Other\", LookIn:=xlFormulas).Row",16]
["AfterHours_Pay","AfterHours_Pay = Cells.Find(What:=\"After*Hours*Payment\", LookIn:=xlFormulas).column"]
["Notes","Notes = Cells.Find(What:=\"Notes*\", LookIn:=xlFormulas).column"]
["Errors","Errors = Cells.Find(What:=\"Errors\", LookIn:=xlFormulas).column",{"$f":"TRIM(B42)","v":"Errors = Cells.Find(What:=\"Errors\", LookIn:=xlFormulas).column"},"Dim ",{"$f":"+C42","v":"Errors = Cells.Find(What:=\"Errors\", LookIn:=xlFormulas).column"}," as Long",null,null,null,{"$f":"CONCATENATE(D42,E42,F42,G42)","v":"Dim Errors = Cells.Find(What:=\"Errors\", LookIn:=xlFormulas).column as Long"},38]

{"sheet":"Sites","index":7,"n_rows":211,"n_cols":2,"rows_kept":211,"cut":false,"hidden":true,"merged":[]}
["Name","Code"]
["Not on List"]
["Multi"]
["Allergy Victoria","Y0986"]
["Arbutus Family Medicine","Y1085"]
["Arrowsmith Lodge","Y0300"]
["Ayre Manor Assisted Living","Y0172"]
["Bamfield Health Centre","Z8550"]
["Beacon Hill Villa","Y0173"]
["Beaufort Clinic","Y0301"]
["Beckley Farm Lodge","Y0174"]
["Birch Family Medicine Clinic","Y0903"]
["Blue Sky Medical Clinic Duncan","Y1088"]
["Burnside Medical Clinic","Y0929"]
["Campbell River – Community Care","Y0786"]
["Campbell River Hospital","Z5080"]
["Campbell River Mental Health & Substance Use Services","Y0257"]
["Campbell River Mental Health Centre (Act)","Y0674"]
["Campbell River Youth Clinic","Y0302"]
["Centered Primary Care Group 1","Y0960"]
["Centered Primary Care Group 2","Y0961"]
["Central Island Child and Adolescent Psychiatry Program","Y0132"]
["Centre Island Surgical Centre (CISC)","Y1118"]
["Chah Chum Hii Yup Health & Administration Office","Y1071"]
["Chemainus  Health Care Centre","Z5050"]
["Clearview Detox","Y0803"]
["Coastal Health Unit","Y0684"]
["Comox Valley – Community Care","Y0787"]
["Comox Valley Foundry","Y1077"]
["Comox Valley Health Centre","Y0133"]
["Comox Valley Hospital "]
["Comox Valley Nursing Centre","Y0250"]
["Cool Aid Society","Y0140"]
["Cordova Bay Medical Clinic Victoria","Y1080"]
["Cormorant Island Health Centre","Z5070"]
["Cortes Island Health Centre","Y0304"]
["Cowichan – Community Care","Y0790"]
["Cowichan District Hospital","Z2030"]
["Cowichan Lodge","Y0305"]
["Cowichan PCN","Y0844"]
["Cyf, Bowen Centre","Y0675"]
["Denman Island Medical Clinic","Y1078"]
["Ditidaht Health Centre","Y0266"]
["Downtown Victoria Urgent & Primary Care Centre UPCC","Y0928"]
["Dr. Daniel Evans Family Practice","Y1084"]
["Duncan Home and Community Care Centre","Y0267"]
["Duncan Mental Health Centre","Y0182"]
["Duncan Youth Clinic","Y0679"]
["Eagle Creek Medical Clinic","Y0809"]
["Eric Martin Pavilion "]
["Esquimalt Health Unit","Y0247"]
["Esquimalt PCN","Y0843"]
["Fort Royal","Y0681"]
["Foul Bay Professional Centre","Y0178"]
["Foundry Campbell River","Y0775"]
["Foundry Victoria (Victoria Youth Clinic)","Y0246"]
["Full Circle Medical Clinic","Y1092"]
["Gabriola Medical Clinic","Y0896"]
["Galiano Island Health Centre","Y0306"]
["Gilford Island Community Health Centre and the Kingcome Inlet Health Care Centre","Y1076"]
["Glengarry Residential Care Facility","Y0673"]
["Glenwarren Lodge Long Term Care","Y0177"]
["Gold River Health Centre","Z8600"]
["Gorge Road Hospital","Z2110"]
["Gorge Urgent Primary Care Centre","Y1090"]
["Greater Victoria - Community Care"]
["Greater Victoria – Community Care","Y0791"]
["Grow Health","Y0931"]
["Halalt Health Unit","Y0310"]
["Health Point Care Centre","Y0904"]
["Hesquiaht Health Centre","Y1075"]
["Hornby Island Medical Clinic","Y0311"]
["huup¿atu (Health) Centre","Y1072"]
["Island Sexual Health - CHC","Y0845"]
["James Bay Care Centre","Y0157"]
["James Bay Community Project","Y0139"]
["James Bay UPCC","Y0835"]
["John Barsby Community School","Y0248"]
["Juan De Fuca Residential Care Hospital","Z220E"]
["Keeler Young & McLurg","Y0932"]
["Kiwanis Pavilion","Y0158"]
["Kyoquot Health Centre","Y0876"]
["Kyuquot Health Centre","Z8570"]
["Lady Minto / Gulf Islands Hospital","Z2060"]
["Ladysmith Community Health Centre","Z5060"]
["Lakeside Medical Clinic- Cowichan Valley","Y1083"]
["Lexitor Medical Clinic","Y0933"]
["Lodge at Broadmead","Y0159"]
["Luther Court Society","Y0160"]
["Macoah Community Centre","Y1074"]
["Malahat Health Unit","Y0312"]
["Mayne Island Health Centre","Y0307"]
["Metral Drive Office","Y0682"]
["Mhsu-Courtney/Riverside Facility","Y0676"]
["Mount Saint Mary Residential Care Hospital","Z212E"]
["Mount Tolmie Hospital","Y0161"]
["Mt. Waddington","Y0777"]
["Nanaimo – Community Care","Y0788"]
["Nanaimo Child/Youth Clinic","Y0947"]
["Nanaimo District Senior Secondary School","Y0251"]
["Nanaimo Eating Disorder Program","Y1115"]
["Nanaimo Family Practice Clinic","Y0930"]
["Nanaimo Home and Community Care","Y0249"]
["Nanaimo Medical Arts Centre UPCC","Y0802"]
["Nanaimo Memory Clinic","Y0969"]
["Nanaimo Mental Health and Addictions","Y0186"]
["Nanaimo Regional General Hospital","Z5010"]
["Nanaimo Substance Use Outreach Office","Y1070"]
["Nanaimo Urgent Primary Care Centre "]
["Nanoose First Nations Health","Y0152"]
["New Horizons","Y0313"]
["Nigel House Residential Care","Y0162"]
["NIH Comox Valley","Y0776"]
["North Island Hospital, Comox Valley","Z5030"]
["North Quadra UPCC","Y0864"]
["NTP Tuscany","Y1007"]
["NTP West Coast","Y0985"]
["Oak Bay Lodge","Y0163"]
["Oceanside Health Centre","Y0245"]
["Oceanside Hospice Society","Y0180"]
["Office of Dr C Dumitrescu and Dr C Keller","Y1081"]
["Office of Dr David Johnson","Y1086"]
["Office of Dr T Chaudhry and Dr A Waheed"]
["Pacheedaht First Nation Health Centre","Y0677"]
["Pacific Station Medical Clinic","Y0934"]
["Pauquachin Health Centre","Y0153"]
["PCN NTP GP Fifth Street Family Practice"]
["Pender Island Health Centre","Y0308"]
["Penelakut Elementary School","Y0727"]
["Penelakut Health Unit","Y0678"]
["PFP Doctors Medical Clinic","Y0999"]
["PFP Shelbourne Family Practice & Maternity","Y0998"]
["Phs Community Services Society","Y0268"]
["Physician Office - Dr. Montalbetti","Y0183"]
["Port Alberni – Community Care","Y0789"]
["Port Alberni Mental Health and Addiction Services","Y0184"]
["Port Alice Health Centre","Y0314"]
["Port Alice Hospital","Z8590"]
["Port Hardy Hospital","Z5100"]
["Port Hardy Primary Health Care Centre","Y0252"]
["Port Hardy Youth Clinic","Y0315"]
["Port McNeill and District Hospital","Z5110"]
["Port McNeill Health Clinic","Y0134"]
["Port McNeill Medical Clinic","Y0253"]
["Quadra Village Medical Centre","Y0935"]
["Quatsino Health Clinic","Y0261"]
["Queen Alexandra Centre For Children's Health","Z2040"]
["Rapid Access Addictions Medicine Clinic","Y0269"]
["Resthaven Lodge","Y0165"]
["Round Building Health Unit","Y0683"]
["Royal Jubilee Hospital","Z2010"]
["Saanich Peninsula – Community Care","Y0792"]
["Saanich Peninsula Hospital","Z2170"]
["Saltspring Island Community Services","Y0181"]
["Sandringham Care Centre","Y0316"]
["Saturna Island Medical Clinic","Y0309"]
["Sea Cove Medical Clinic Comox","Y1079"]
["Seafield Surgical Centre","Y0941"]
["Selkirk Place Residential Care","Y0166"]
["Seven Oaks Tertiary Mental Health Hospital","Z2300"]
["Shoreline Medical Clinic - Brentwood","Y0936"]
["Shoreline Medical Clinic - Sidney","Y0937"]
["Sidney Care Home","Y0167"]
["Sitka Health Centre","Y0972"]
["Snuneymuxw Health Centre","Y0260"]
["Snuneymuxw Health Centre","Y0897"]
["Sointula Health Centre","Y0801"]
["South Island ACT","Y0778"]
["South Island Surgical Centre (SISC)","Y1119"]
["St. Joseph's General Hospital","Z5020"]
["Sunshine Wellness Centre","Y0319"]
["Tahsis Health Centre","Z8610"]
["The Heights at Mt. View Residential Care","Y0170"]
["The John Howard Society of the North Island "]
["The Lodge on 4Th","Y0680"]
["The Salvation Army Sunset Lodge","Y0169"]
["Tiic-Mis-Aq'kin Health Centre","Y1073"]
["Tofino General Hospital","Z8540"]
["Trillium Lodge","Z512E"]
["Tsartlip Health Centre","Y0155"]
["Tsawout Health Centre","Y0154"]
["Tseycum First Nation Health","Y0156"]
["Tuscany Medical","Y0959"]
["University of Victoria - Student Health Services","Y0317"]
["University Plaza","Y0958"]
["Unknown","Y0000"]
["Vancouver Island Suspected Child Abuse and Neglect Program","Y0318"]
["Vancouver Island University","Y0303"]
["Victoria Chinatown Care Centre","Y0171"]
["Victoria General Hospital","Z2020"]
["Victoria Memory Clinic","Y0970"]
["Victoria Mental Health Centre Eric Martin Pavilion","Y0141"]
["Victoria Native Friendship Centre","Y0898"]
["Victoria Westshore Secondary Schools","Y0254"]
["Victoria Youth Clinic Society "]
["View Royal Maternity and Family Practice","Y1091"]
["View Royal Surgical Centre","Y0860"]
["Virtual Site","Y9998"]
["Wellington Medical Clinic","Y0971"]
["West Coast General Hospital","Z8510"]
["Westshore CHC","Y1008"]
["Westshore OAT","Y1000"]
["Westshore Urgent Primary Care Centre UPCC","Y0783"]
["Westward Medical Clinic","Y0962"]
["Westwind Medical Clinic","Y0938"]
["WIC Esquimalt Medical Clinic","Y0995"]
["WIC Shoreline Medical Brentwood","Y0992"]
["WIC Shoreline Medical Sidney","Y0993"]
["WIC West Coast Family Medical Clinic","Y0991"]
["WIC West Saanich Family Medical Clinic","Y0994"]
["Yates & Quadra Integrated Health Centre - PCN","Y0846"]

{"sheet":"utilization report sample","index":8,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["CPRP_ID","HA_RECORD_ID","PRAC_BILLING_NUMBER","PRAC_NAME","PAYEE_NUMBER","ACTUAL_PRACTICE_CATEGORY","ACTUAL_RANGE_PLACEMENT","ACTUAL_RATE_PAID","RRP_SCC","RRP_PAID","SERVICE_START_DATE","SERVICE_END_DATE","SERVICE_START_TIME","SERVICE_END_TIME","SERVICE_TYPE","HOURS","ACTUAL_FACILITY","APP_AMT"]
[22198,1,65392,"Atherstone, Michael",36597,"ANAESN",100,394.77,"CC",27.36,"2022-08-19","2022-08-19","07:00:00","08:00:00","OR",1,"Z5030",394.77]
[22198,2,65392,"Atherstone, Michael",36597,"ANAESD",100,225.18,"CC",7.8,"2022-08-19","2022-08-19","08:00:00","08:30:00","OOR",0.5,"Z5030",225.18]
[22198,3,44352,"Briggs, Joshua",36597,"ANAESN",100,394.77,"CC",20.52,"2022-08-19","2022-08-19","07:15:00","08:00:00","OR",0.75,"Z5030",394.77]
[22198,4,44352,"Briggs, Joshua",36597,"ANAESD",100,225.18,"CC",117.04,"2022-08-19","2022-08-19","08:00:00","15:30:00","OR",7.5,"Z5030",225.18]
[22198,5,44352,"Briggs, Joshua",36597,"ANAESD",100,225.18,"CC",15.6,"2022-08-19","2022-08-19","15:30:00","16:30:00","Overrun",1,"Z5030",225.18]
[22198,6,1592,"Collins, Ronald",36597,"ANAESN",100,394.77,"CC",20.52,"2022-08-19","2022-08-19","07:15:00","08:00:00","OR",0.75,"Z5030",394.77]
[22198,7,1592,"Collins, Ronald",36597,"ANAESD",100,225.18,"CC",117.04,"2022-08-19","2022-08-19","08:00:00","15:30:00","OR",7.5,"Z5030",225.18]
[22198,8,1592,"Collins, Ronald",36597,"ANAESD",100,225.18,"CC",11.7,"2022-08-19","2022-08-19","15:30:00","16:15:00","Overrun",0.75,"Z5030",225.18]
[22198,9,65392,"Atherstone, Michael",36597,"ANAESD",100,225.18,"CC",46.81,"2022-08-19","2022-08-19","15:00:00","18:00:00","OR",3,"Z5030",225.18]
[22198,10,65392,"Atherstone, Michael",36597,"ANAESE",100,350.8,"CC",48.62,"2022-08-19","2022-08-19","18:00:00","20:00:00","OR",2,"Z5030",350.8]
[22198,11,65392,"Atherstone, Michael",36597,"ANAESE",100,350.8,"CC",48.62,"2022-08-19","2022-08-19","20:00:00","22:00:00","On-call",2,"Z5030",350.8]
[22198,12,65392,"Atherstone, Michael",36597,"ANAESW",100,350.8,"CC",97.24,"2022-08-21","2022-08-21","08:00:00","12:00:00","OR",4,"Z5030",350.8]
[22198,13,65392,"Atherstone, Michael",36597,"ANAESW",100,350.8,"CC",66.849999999999994,"2022-08-21","2022-08-21","12:00:00","14:45:00","On-call",2.75,"Z5030",350.8]
[22198,14,65392,"Atherstone, Michael",36597,"ANAESW",100,350.8,"CC",60.78,"2022-08-21","2022-08-21","19:15:00","21:45:00","On-call",2.5,"Z5030",350.8]
[22198,15,65392,"Atherstone, Michael",36597,"ANAESW",100,350.8,"CC",12.16,"2022-08-21","2022-08-21","22:30:00","23:00:00","On-call",0.5,"Z5030",350.8]

{"sheet":"bulk inv upload","index":9,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Physician Name","MSP #","Vendor","Type","EffectiveDate(yyyy/mm/dd)","InvoiceDate\n(yyyy/mm/dd)","InvoiceNumber","Description","GlAccount","Amount","Tax","StatHours","Approver",{"$f":"SUM(J:J)","v":0}]
["Atherstone, Michael",65392,"R016047",{"$f":"\"FEE\"","v":"FEE"},{"$f":"TODAY()","v":"2023-03-30"},{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$f":"TEXT(F4,\"yymmdd\")&\"NIHAN\"","v":{"$error":"#REF!"}},{"$f":"'Invoice Template'!M4&\" \"&TEXT(F4,\"mmm d yy\")","v":{"$error":"#REF!"}},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A4),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Badh, Charanjit",67499,"R032217","FEE",{"$f":"+$E$4","v":"2023-03-30"},{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+H$4","v":{"$error":"#REF!"}},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A27),2)","v":0},{"$f":"+K$4","v":"NON"},{"$f":"0","v":0},{"$f":"+$M$4","v":"YG"}]
["Becotte, Annick",39452,"R031513","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G108,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A24),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Blais, Alexandre",67060,"R020389","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!#REF!),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Briggs, Joshua",44352,"R032204","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A28),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Chadwick, Mairi",36804,"R030918","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A8),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Collins, Ronald",1592,"R031912","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G120,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A25),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Cook, Andrew",27323,"R006017","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G13,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A5),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Donald, Sean",82788,"R030230","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G12,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A6),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Flexer, William",29988,"R030202","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G105,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A21),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Genuis, Katrina","J0445","R032432","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G125,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A30),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Gornall, Wayne",2812,"R006018","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G15,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A9),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Holmes, Stuart",28405,"R009362","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G90,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A10),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Honeywood, Kallie",29452,"R031913","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G121,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A26),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Ishwarlall, Sujay",82786,"R028295","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A11),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Kothari, Rohan",59972,"R032584","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G124,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A29),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Maguire, Douglas","J0349","R032828","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G115,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A31),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Mattheus, Catherina",26614,"R019872","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A12),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Neveling, Christoffel",68122,"R029703","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G107,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A23),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Rimmer, Tara",34546,"R029945","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A13),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Rozenberg, Anna",37125,"R031039","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A14),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Sacevich, Calen",82543,"R028014","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G106,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A22),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Smith, Philip",85254,"R020283","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G100,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A16),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Swanstrom, Laura",12345,null,"FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G117,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A32),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Sysak, Daniel",37647,"R031229","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G101,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A17),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Thakore, Shefali",27202,"R029687","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!#REF!,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A15),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Thibodeau, Lindi",67510,"R025807","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G102,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A18),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Watson, Jonathan",28582,"R008204","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G103,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A19),2)","v":0},"NON",{"$f":"0","v":0},"YG"]
["Wong, Chrison",37332,"R031081","FEE","2023-03-30",{"$f":"VLOOKUP('Invoice Template'!G104,'Physician Reporting Periods'!A:C,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$f":"ROUND(SUMIFS('Invoice Template'!$AP$13:$AP$99,'Invoice Template'!$A$13:$A$99,'bulk inv upload'!$A20),2)","v":0},"NON",{"$f":"0","v":0},"YG"]

{"sheet":" Shift Table ","index":10,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[null,"CVH_SHIFTS"]
[null,"SCHEDULED "]
[null,"UNSCHEDULED"]

{"sheet":"AFter Hour Rates","index":11,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["APPENDIX 2"]
[]
["PAYMENT"]
[]
["A.    Payment for Services"]
[]
["1.     Scheduled Shifts"]
[]
["Payment for Scheduled Shifts at RCH will be paid at the following hourly rates:"]
[]
[]
[]
["Effective 22/23: ","Hourly Rates","Practise Category"]
[]
["a.       08:00 to 18:00 on weekdays – $225.18 per hour",0,"BASE"]
["b.       18:00 to 23:00 on weekdays – $350.80 per hour ",25,"EVENING"]
["c.       08:00 to 23:00 on weekends – $ 350.80 per hour ",25,"WEEKEND"]
["d.       23:00 to 08:00 on all days - $394.77 per hour ",35,"NIGHT"]
["e.       08:00 to 23:00 on statutory holidays – $ 350.80 per hour ",25,"STAT"]

{"sheet":"Physician Reporting Periods","index":12,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Report Period","Start Date","End Date",null,"Statutory Holiday","Date"]
[{"$f":"TEXT(B2,\"MMM-D-yyyy\")&\" - \"&TEXT(C2,\"MMM-D-yyyy\")","v":"Mar-1-2023 - Mar-31-2023"},"2023-03-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-03-31"},null,"Good Friday","2023-04-07",null,"2023-04-07",{"$f":"+H2='Invoice Template'!E15","v":false}]
["Apr-1-2023 - Apr-30-2023",{"$f":"+C2+1","v":"2023-04-01"},{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-04-30"},null,"Easter Monday","2023-04-10"]
["May-1-2023 - May-31-2023",{"$f":"+C3+1","v":"2023-05-01"},{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-05-31"},null,"Victoria Day","2023-05-22"]
["Jun-1-2023 - Jun-30-2023",{"$f":"+C4+1","v":"2023-06-01"},{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-06-30"},null,"Canada Day","2023-07-01"]
["Jul-1-2023 - Jul-31-2023",{"$f":"+C5+1","v":"2023-07-01"},{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-07-31"},null,"Canada Day in lieu","2023-01-03"]
["Aug-1-2023 - Aug-31-2023",{"$f":"+C6+1","v":"2023-08-01"},{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-08-31"},null,"BC Day","2023-08-07"]
["Sep-1-2023 - Sep-30-2023","2023-09-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-09-30"},null,"Labour Day","2023-09-04"]
["Oct-1-2023 - Oct-31-2023","2023-10-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-10-31"},null,"National Day for Truth and Reconciliation","2023-09-30"]
["Nov-1-2023 - Nov-30-2023","2023-11-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-11-30"},null,"National Day for Truth and Reconciliation in Lieu","2023-10-03"]
["Dec-1-2023 - Dec-31-2023","2023-12-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2023-12-31"},null,"Thanksgiving Day","2023-10-09"]
["Jan-1-2024 - Jan-31-2024","2024-01-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2024-01-31"},null,"Rememberance Day","2023-11-11"]
["Feb-1-2024 - Feb-29-2024","2024-02-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2024-02-29"},null,"Rememberance Day in Lieu","2023-11-13"]
["Mar-1-2024 - Mar-31-2024","2024-03-01",{"$f":"EOMONTH(DatesTable[[#This Row],[Start Date]],0)","v":"2024-03-31"},null,"Christmas Day","2023-12-25"]
[null,null,null,null,"Boxing Day","2023-12-26"]
[null,null,null,null,"New Year","2024-01-01"]
[null,null,null,null,"Family Day","2024-02-19"]