{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","YTD Data","MTD Data"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"part_too_large","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":86,"n_cols":6,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Narcotic Treatment Programs"]
["Instructions for Generating Total Units of Service Report (TUOS)"]
[]
["Orange shaded cells with formula are locked."]
["Yellow shaded cells are for data entry."]
[]
[null,1,"Run the Contract Provider Charges Export Report in SmartCare.   Download in csv format. "]
[]
[null,2,"Generate year-to-date (YTD) and month-to-date (MTD) TUOS reports"]
[]
[null,null,2.2000000000000002,"Select YTD Data tab"]
[null,null,null,"2.2.1","Input date range starting from 9/1/2024 or 1st day of new fiscal year to end of month being invoiced in cells F1 and H1"]
[null,null,null,"2.2.2","Input contract number and name in cells F2 and F3."]
[]
[]
[]
[]
[null,null,2.2999999999999998,"Select MTD Data tab"]
[null,null,null,"2.3.1","Input date range of the month being invoiced in cells F1 and H1 to pull the monthly information from YTD Data tab"]
[null,null,null,"2.3.2","Input contract number and description in cells F2 and F3."]
[]
[]
[]
[]
[null,null,2.4,"Go back and select YTD Data tab"]
[null,null,null,"2.4.1","Copy Contract Provider Charges Export downloaded data by selecting cell A1  till the last data populating  column AG."]
[null,null,null,null,"Tip:  Place curson in cell A1 then press Shift +End Home in your keyboard to highlight data to be copied in YTD data tab."]
[null,null,null,"2.4.2","Paste (ctrl + v) in cell A3 the Contract Provider Charges Export"]
[null,null,null,"2.2.3","Click the button on YTD TUOS Report found in the dashboard to generate YTD TUOS summary"]
[]
[]
[]
[null,null,null,"2.2.4","Enter 0101 as password to continue in generating the YTD TUOS summary"]
[null,null,null,"2.2.5","Check and see YTD TUOS tab that will appear after MTD Data tab"]
[]
[]
[]
[null,null,null,null,"2.2.5.1","A generated YTD TUOS report now comes into view."]
[]
[null,null,null,null,"2.2.5.2","Utilization of  ProgramName, Perinatal, and Service Type slicers are to determine the amount to enter in the invoice, if necessary"]
[]
[null,null,2.5,"Go to  MTD Data tab"]
[null,null,null,"2.5.1","Click the button on MTD TUOS Report found in the dashboard to generate the MTD TUOS summary"]
[]
[]
[]
[null,null,null,"2.5.2","Check and see MTD TUOS tab that will appear after YTD TUOS tab"]
[]
[]
[]
[null,null,null,null,"2.2.5.1","A generated MTD TUOS report now comes into view."]
[]
[null,null,null,null,"2.2.5.2","Utilization of  ProgramName, Perinatal, and Service Type slicers are to determine the amount to enter in the invoice"]
[]
[null,3,"Print the YTD and MTD TUOS reports"]
[]
[null,null,3.1,"Select YTD TUOS tab"]
[null,null,null,"3.1.1","Follow instruction highlighted in yellow, which is to activate settings in Page Layout press Ctrl + (shift) Y in cell H2"]
[]
[]
[null,null,null,"3.1.2","Select in the ribbon bar the Page layout then Print Titles  "]
[null,null,null,"3.1.3","Edit the last 2 digits in Print area of Sheet tab to include Grand Total, if necessary."]
[null,null,null,"3.1.4","Press Print Preview, OK"]
[null,null,null,"3.1.5","Save in pdf or print in paper"]
[]
[null,null,3.2,"Select MTD TUOS tab"]
[null,null,null,"3.2.1","Follow instruction highlighted in yellow, which is to activate settings in Page Layout press Ctrl +(shift) M in cell H2"]
[]
[]
[null,null,null,"3.2.2","Select in the ribbon bar the Page layout then Print Titles  "]
[null,null,null,"3.2.3","Edit the last 2 digits in Print area of Sheet tab to include the Grand Total, if necessary."]
[null,null,null,"3.2.4","Press Print Preview, ok"]
[null,null,null,"3.2.5","Save in pdf or print in paper"]
[]
[null,4,"Save the file with a new filename; do not overwrite the template"]
[]
[null,5,"Use ProgramName, Perinatal, and Service Type slicers to determine the amount to enter in the invoice, if necessary, found in YTD TUOS and MTD TUOS tabs"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6,"End of process"]

{"sheet":"YTD Data","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"read":"part_too_large"}

{"sheet":"MTD Data","index":2,"n_rows":4,"n_cols":40,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Contract Provider Charges Export Report","from",null,"to",null,null,null,null,null,null,null,null,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(H1),0,(H1+1))","v":"00:00:00"}]
[null,null,null,"Contract",null,{"$f":"'YTD Data'!F2","v":0},{"$f":"'YTD Data'!G2","v":0}]
["BatchId","ProgramId","ProgramName","ProgramNpi","StaffId","Degree","DegreeName","StaffNpi","Perinatal","DateOfService","GroupServiceId","ServiceId","ProcedureCodeId","ServiceUnitType","ServiceUnits","ProcedureCodeName","ChargeId","BillingCode","RevenueCode","Modifier1","Modifier2","Modifier3","Modifier4","ChargeUnits","StaffFirstName","StaffMiddleName","StaffLastName","ChargesCreatedDate","LocationId","LocationName","Plan","AllActivePlans","ClientId","Service Month","Service Date","Service Type","Benefit Plan"]
[{"$f":"_xlfn._xlws.FILTER('YTD Data'!A:AK,('YTD Data'!AI:AI>='MTD Data'!F1)*('YTD Data'!AI:AI<AN1))","v":{"$error":"#VALUE!"}}]