{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","YTD Details","MTD Details"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Narcotic Treatment Programs"]
["Instructions to Summarize CoSD Charges/Claims Report"]
[]
[]
["Orange shaded cells with formula are locked."]
["Yellow shaded cells are for data entry."]
[]
[null,1,"Run the CoSD Charges/Claims Report in SmartCare"]
[null,null,1.1000000000000001,"Enter or select the report parameters"]
[null,null,null,"1.1.1","DOS From",null,":","9/1/2024 or 1st day of new fiscal year"]
[null,null,null,"1.1.2","DOS To",null,":","End of month being invoiced"]
[null,null,null,"1.1.3","Program(s)",null,":","NTP program according to contract number"]
[null,null,null,"1.1.4","Procedure Code(s)",null,":","All procedure codes"]
[null,null,null,"1.1.5","Coverage Plan(s)",null,":","All coverage plans"]
[null,null,null,"1.1.6","Service Area ID",null,":","DMC"]
[null,null,null,"1.1.7","Client Id",null,":","Null "]
[]
[null,null,1.2,"Download in csv format"]
[]
[null,2,"Generate year-to-date (YTD) and month-to-date (MTD) reports"]
[]
[null,null,2.1,"Select YTD Details tab"]
[null,null,null,"2.1.1","Input report run date in cell B1"]
[null,null,null,"2.1.2","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.1.3","Input contract number and name in cells F2 and G2"]
[]
[]
[]
[]
[null,null,2.2000000000000002,"Select MTD Details tab"]
[null,null,null,"2.2.1","Input date range of the month being invoiced in cells F1 and H1 to pull the monthly information from YTD Details tab"]
[null,null,null,"2.2.2","Input contract number and description in cells F2 and G2"]
[]
[]
[]
[]
[null,null,2.2999999999999998,"Go back and select YTD Details tab"]
[null,null,null,"2.3.1","Copy CoSD Charges/Claims Report downloaded data by selecting cell A5  till the last data in column U"]
[null,null,null,null,"Tip:  Place curson in cell A5 then press Shift +End Home in your keyboard to highlight data to be copied in YTD details tab"]
[null,null,null,"2.3.2","Paste (ctrl + v)  CoSD Charges/Claims Report in cell A4 of YTD Details tab"]
[null,null,null,"2.3.3","Click YTD Report button found in the dashboard to generate YTD summary report"]
[]
[]
[]
[null,null,null,"2.3.4","Enter 0101 as password to continue in generating the YTD summary report"]
[null,null,null,"2.3.5","Check and see YTD Summary tab that will appear after MTD Details tab"]
[]
[]
[]
[null,null,null,"2.3.6","YTD Summary report now comes into view"]
[]
[null,null,2.4,"Go to  MTD Details tab"]
[null,null,null,"2.4.1","Click MTD Report button found in the dashboard to generate MTD summary report"]
[]
[]
[]
[null,null,null,"2.4.2","Check and see MTD Summary tab that will appear after YTD Summary tab"]
[]
[]
[]
[null,null,null,"2.4.3","MTD Summary report now comes into view"]
[]
[null,3,"Remove client and clinician names appearing in YTD and MTD details tabs"]
[null,null,3.1,"Delete the names of the clients shown in column D"]
[null,null,3.2,"Delete the names of clinicians shown in column H"]
[]
[null,4,"Save the file with a new filename; do not overwrite the template"]
[]
[null,5,"Set in landscape orientation the YTD and MTD summary reports print-out"]
[]
[null,6,"End of process"]

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

{"sheet":"MTD Details","index":2,"n_rows":4,"n_cols":40,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["SmartCare Run Date:",{"$f":"IF(ISBLANK('YTD Details'!B1),\"\",'YTD Details'!B1)","v":""},null,"CoSD Charges and Claims 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":"IF(ISBLANK('YTD Details'!F2),\" \",'YTD Details'!F2)","v":" "},{"$f":"IF(ISBLANK('YTD Details'!G2),\" \",'YTD Details'!G2)","v":" "}]
["ChargeId","PlanName","ClientId","ClientName","serviceId","GroupServiceId","DateofService","Clinician","LicenseTypeDegree","ProcedureName","ServiceUnit","ServiceUnitType","CodeAndModifiers","Units","Charge","Balance","BilledDate","ModifiedDate","ChargeStatus","ProgramCode","LocationName","Service Month","Plan Name","Perinatal","HCPCS","Service Type","  Units","Units Reconciliation"]
[{"$f":"_xlfn._xlws.FILTER('YTD Details'!A:AB,('YTD Details'!G:G>='MTD Details'!F1)*('YTD Details'!G:G<AN1))","v":{"$error":"#VALUE!"}}]