{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["IHS-PRC Contracted Travel","Pharmacy"],"not_rendered":{"images":4,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"IHS-PRC Contracted Travel","index":0,"n_rows":88,"n_cols":8,"rows_kept":88,"merged":[[0,0,0,1],[0,2,0,4],[1,0,5,0],[1,2,1,7],[2,2,2,7],[3,2,3,3],[4,2,4,7],[5,2,5,7],[6,0,10,0],[6,2,6,7],[7,2,7,7],[8,2,8,3],[9,2,9,7],[10,2,10,7],[11,5,11,6],[12,0,12,3],[12,5,12,6],[24,5,24,6],[25,0,25,1],[25,2,25,4],[25,5,25,7],[26,0,26,3],[26,5,26,6],[57,5,57,6],[87,5,87,6]]}
["IHS-PRC/Contracted Travel",null,"INVOICE"]
["REIMBURSEMENT INFORMATION","IHS Area NAME:"]
[null,"IHS Area ADDRESS:"]
[null,"IHS Area CITY:",null,null,"STATE: ",null,"ZIPCODE: "]
[null,"NPI:"]
[null,"Tax ID:"]
["TRACKING INFORMATION","IHS Facility NAME:"]
[null,"IHS Facility ADDRESS:"]
[null,"IHS Facility CITY:",null,null,"STATE: ",null,"ZIPCODE: "]
[null,"NPI:"]
[null,"Tax ID:"]
[{"$nulls":4},"TOTAL INVOICE AMOUNT (must exactly match E-services submission)","$"]
["VETERAN INFORMATION",{"$nulls":4},"DATE OF SERVICE",null,"SUBTOTAL"]
["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)","IHS Payment Amount"]
{"$rows_empty":10}
[{"$nulls":5},"SUBTOTAL for this Page",null,{"$f":"SUM(H15:H24)","v":{"v":0,"d":"$0.00"}}]
["IHS-PRC/Contracted Travel",null,"INVOICE"]
["VETERAN INFORMATION",{"$nulls":4},"DATE OF SERVICE",null,"SUBTOTAL"]
["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)","IHS Payment Amount"]
{"$rows_empty":29}
[{"$nulls":5},"SUBTOTAL for this Page",null,{"$f":"SUM(H29:H57)","v":{"v":0,"d":"$0.00"}}]
{"$rows_empty":29}
[{"$nulls":5},"SUBTOTAL for this Page",null,{"$f":"SUM(H59:H87)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Pharmacy","index":1,"n_rows":29,"n_cols":10,"rows_kept":29,"merged":[[0,0,0,1],[0,2,0,6],[0,8,0,9],[1,0,5,0],[1,2,1,7],[2,2,2,7],[3,2,3,3],[4,2,4,7],[5,2,5,7],[6,0,10,0],[6,2,6,7],[7,2,7,7],[8,2,8,3],[9,2,9,7],[10,2,10,7],[11,5,11,7],[12,0,12,2],[12,3,12,7],[12,8,12,9],[26,0,26,1],[26,2,26,6],[26,8,26,9],[27,0,27,2],[27,3,27,7],[27,8,27,9],[56,7,56,8]]}
["IHS-PRC Pharmacy",null,"INVOICE"]
["REIMBURSEMENT INFORMATION","IHS Area NAME:"]
[null,"IHS Area ADDRESS:"]
[null,"IHS Area CITY:",null,null,"STATE: ",null,"ZIPCODE: "]
[null,"NPI:"]
[null,"Tax ID:"]
["TRACKING INFORMATION","IHS Facility NAME:"]
[null,"IHS Facility ADDRESS:"]
[null,"IHS Facility CITY:",null,null,"STATE: ",null,"ZIPCODE: "]
[null,"NPI:"]
[null,"Tax ID:"]
[{"$nulls":4},"TOTAL INVOICE AMOUNT (must exactly match E-services submission)","$"]
["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)"]
{"$rows_empty":12}
["IHS-PRC Pharmacy",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)"]