{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["THP Billing Invoice","Pharmacy"],"not_rendered":{"images":3,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"THP Billing Invoice","index":0,"n_rows":91,"n_cols":10,"rows_kept":91,"merged":[[0,0,0,2],[0,3,0,6],[0,7,0,9],[1,0,1,2],[1,3,1,8],[2,0,2,2],[2,3,2,8],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,7],[5,0,5,2],[5,3,5,7],[5,8,5,9],[6,6,6,7],[6,8,6,9],[7,2,7,5],[7,7,7,8],[25,7,25,8],[26,0,26,2],[26,3,26,6],[26,7,26,9],[27,2,27,5],[27,7,27,8],[59,7,59,8],[90,7,90,8]]}
["THP-PRC Billing",null,null,"INVOICE"]
["THP Facility NAME: "]
["THP Facility ADDRESS: "]
["THP Facility CITY: ",{"$nulls":4},"STATE: ",null,"ZIPCODE: "]
["NPI:"]
["Tax ID: "]
[{"$nulls":5},"TOTAL INVOICE AMOUNT (must exactly match E-services submission)","$"]
[null,null,"VETERAN INFORMATION",{"$nulls":4},"DATE OF SERVICE",null,"SUBTOTAL"]
["E-Services order #","THP Tracking #  (optional)","LAST NAME","FIRST NAME","UNIQUE ID (SSN or ICN)","DOB (MM/DD/YYYY)","Name of community provider/group","From Date (MM/DD/YYYY)","To Date (MM/DD/YYYY)","THP Payment Amount"]
{"$rows_empty":16}
[{"$nulls":7},"SUBTOTAL for this Page",null,{"$f":"SUM(J10:J25)","v":{"v":0,"d":"$0.00"}}]
["THP-PRC Billing",null,null,"INVOICE"]
[null,null,"VETERAN INFORMATION",{"$nulls":4},"DATE OF SERVICE",null,"SUBTOTAL"]
["E-Services order #","THP Tracking #  (optional)","LAST NAME","FIRST NAME","UNIQUE ID (SSN or ICN)","DOB (MM/DD/YYYY)","Name of community provider/group","From Date (MM/DD/YYYY)","To Date (MM/DD/YYYY)","THP Payment Amount"]
{"$rows_empty":30}
[{"$nulls":7},"SUBTOTAL for this Page",null,{"$f":"SUM(J30:J59)","v":{"v":0,"d":"$0.00"}}]
{"$rows_empty":30}
[{"$nulls":7},"SUBTOTAL for this Page",null,{"$f":"SUM(J61:J90)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Pharmacy","index":1,"n_rows":3,"n_cols":10,"rows_kept":3,"merged":[[0,0,0,2],[0,3,0,7],[0,8,0,9],[1,0,1,2],[1,3,1,7],[1,8,1,9]]}
["THP-PRC Pharmacy",null,null,"INVOICE"]
["VETERAN INFORMATION",null,null,"DRUG INFORMATION",{"$nulls":4},"DATE OF SERVICE"]
["LAST NAME","FIRST NAME","UNIQUE ID (SSN or ICN)","NDC","NDC Description","Strength","Unit of Measure","Quantity","From Date (MM/DD/YYYY)","To Date (MM/DD/YYYY)"]