{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet6"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,3,5,6],[11,5,11,6],[12,5,12,6]]}
[]
[]
[]
[]
[]
["1200 S. Rogers Circle, Suite 10",null,null,"Employee Expense Report"]
["Boca Raton, FL 33487"]
["(561) 394-5818"]
[]
["Expense Period:  "]
[]
["Name",null,"Expense Associated With:",null,null,"Department"]
[null,null,"WTUI",null,null,"Sales"]
[]
["Manager",null,"Purpose",null,null,"Todays Date: "]
["David Simon",null,"Site Visits",null,null,{"$f":"TODAY()","v":"2017-05-17"}]
[]
["Date","Category","Description","Reimb?","Currency","Foreign Amt","USD Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTALS:",null,null,null,null,null,{"$f":"SUM(G19:G38)","v":0}]
["TOTAL REIMBURSEABLE AMOUNT (IN US DOLLARS)",null,null,null,null,null,{"$f":"SUMIF(D19:D38,\"YES\",G19:G38)","v":0}]
["**Attach XE Currency Converter with any foreign charges."]
[]
[]
[]
["Employee Signature",null,null,"Manager Signature"]
[]
[]
["Date",null,null,"Date"]

{"sheet":"Sheet2","index":1,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Adam Gibson"]
["David Lewis"]
["Faren Turner"]
["Jessica Hembree"]
["Monica Pissanos"]
["Shawn Burdge"]
["David Simon"]
["Jill Simon"]
["Marcio Riberio"]
["Melissa Fleming"]
[]
["Yes"]
["No"]
[]
["Auto"]
["Travel"]
["Meals & Entertainment"]
["Office Supplies"]
["Other"]
[]
["Sales"]
["Admin"]
["Warehouse"]
[]
["Australian Dollar"]
["Canadian Dollar"]
["Dollars"]
["Euros"]
["Hong Kong Dollar"]
["Krona"]
["Krone"]
["New Zealand Dollar"]
["Peso"]
["Pounds"]
["Real"]
["Ruble"]
["Rupee"]
["Swiss Franc"]
["Yen"]
["Yuan"]

{"sheet":"Sheet6","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Foreign Currency",null,"Converting From a Foreign Currency to U.S. $"]
[null,"1 USD $",null,"Currency","Value"]
[null,"1 JPY ¥",null,"1 USD $",5]
[null,"1 EUR €",null,null,{"$f":"SUM(VLOOKUP(D5,#REF!,2,FALSE)*E5)","v":{"$error":"#REF!"}}]
[null,"1 CAD $"]
[null,"1 GBP £"]
[null,"1 AUD $",null,"Converting From U.S. $ to a Foreign Currency"]
[null,"1 CHF",null,"Currency","Value"]
[null,null,null,"U.S.$",1]