{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main","Mappings","Import","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":48,"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":"Main","index":0,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Client ID:",17047531]
[null,null,null,null,null,null,null,"File to be converted:","C:\\Paychex\\31JW_ta.txt"]
[null,null,null,null,null,null,null,"Output file location:","C:\\Paychex\\"]

{"sheet":"Mappings","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Preview D/E","Preview Code","Payroll Online Pay Component",null,"Preview Division","Preview Branch","Preview Department","Labor Assignment","Payroll Online OU 1","Payroll Online OU 2","Payroll Online OU 3",null,"Preview Job Number","Payroll Online Job Number"]
["E",1,"Hourly",null,"NORTH",1,100,null,100,100,100,null,"CX1000","CX1000"]
["E",2,"Overtime",null,"SOUTH",2,200,null,200,200,200,null,"GT1000","GT1000"]
["E","B","Bonus",null,"EAST",3,300,null,300,300,300,null,"GT2000","GT2000"]
["E","C","Commissions",null,"WEST",4,400,null,400,400,400,null,"GT3000","GT3000"]
["E","S","Sick",null,"NREAST",5,500,null,500,500,500]
["E","H","Holiday",null,"SOEAST",6,600,null,600,600,600]
["E","V","Vacation"]
["E","P","Personal"]
["E","R","Retro"]
["E",5,"Salary"]
["E",10,"1099 Misc Comp"]

{"sheet":"Import","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[1,null,null,"CX1000",null,"E",1,null,40]
[2,null,null,"CX1000",null,"E",1,null,40]
[3,null,null,"CX1000",null,"E",5,null,null,null,null,null,null,null,2500]
[4,null,null,"CX1000",null,"E",1,null,40]
[5,null,null,"CX1000",null,"E",1,null,40]
[6,null,null,"CX1000",null,"E",10,null,null,null,null,null,null,null,500]
[7,null,null,"CX1000",null,"E",5,null,null,null,null,null,null,null,500]
[8,null,null,"CX1000",null,"E",1,null,40]
[9,null,null,"CX1000",null,"E",1,null,40]
[10,null,null,"CX1000",null,"E",10,null,null,null,null,null,null,null,500]
[11,null,null,"CX1000",null,"E",5,null,null,null,null,null,null,null,2500]
[12,null,null,"CX1000",null,"E",5,null,null,null,null,null,null,null,5000]

{"sheet":"Data","index":3,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Client ID","Worker ID","Org","Job Number","Pay Component","Rate","Rate Number","Hours","Units","Line Date","Amount","Check Seq Number","Override State","Override Local","Override Local Jurisdiction","Labor Assignment"]
[17047531,1,null,"CX1000","Hourly",null,1,40,null,null,null,null,null,null,null," "]
[17047531,2,null,"CX1000","Hourly",null,1,40,null,null,null,null,null,null,null," "]
[17047531,3,null,"CX1000","Salary",null,null,null,null,null,2500,null,null,null,null," "]
[17047531,4,null,"CX1000","Hourly",null,1,40,null,null,null,null,null,null,null," "]
[17047531,5,null,"CX1000","Hourly",null,1,40,null,null,null,null,null,null,null," "]
[17047531,6,null,"CX1000","1099 Misc Comp",null,null,null,null,null,500,null,null,null,null," "]
[17047531,7,null,"CX1000","Salary",null,null,null,null,null,500,null,null,null,null," "]
[17047531,8,null,"CX1000","Hourly",null,1,40,null,null,null,null,null,null,null," "]
[17047531,9,null,"CX1000","Hourly",null,1,40,null,null,null,null,null,null,null," "]
[17047531,10,null,"CX1000","1099 Misc Comp",null,null,null,null,null,500,null,null,null,null," "]
[17047531,11,null,"CX1000","Salary",null,null,null,null,null,2500,null,null,null,null," "]
[17047531,12,null,"CX1000","Salary",null,null,null,null,null,5000,null,null,null,null," "]