{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","Instructions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Input","index":0,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,16,4,20]]}
["Raw Data","Name","SSN","Fed WH","SS Wage","SS Tip","SS WH","Med Wage","Med WH","Gross Wages","Column1","Column2","Column3"]
[null,{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-1]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-1]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-1]\",0),3)=\"TIN\")),MID(INDIRECT(\"A\"&Table1[Column2]),8,34),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-2]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-2]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-2]\",0),3)=\"TIN\")),MID(INDIRECT(\"A\"&Table1[Column1]),6,11),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-3]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-3]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-3]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),1,10)),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-4]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-4]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[41]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),11,12)),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-5]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-5]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-5]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),23,12)),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-6]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-6]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-6]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),35,12)),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-7]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-7]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-7]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),47,12)),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-8]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-8]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-8]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),59,11)),\"\")","v":""},{"$f":"IF(AND(LEFT(INDIRECT(\"RC[-9]\",0),4)=\"----\",OR(LEFT(INDIRECT(\"R[1]C[-9]\",0),3)=\"SSN\",LEFT(INDIRECT(\"R[1]C[-9]\",0),3)=\"TIN\")),VALUE(MID(INDIRECT(\"A\"&Table1[Column3]),70,11)),\"\")","v":""},{"$f":"ROW()+1","v":3},{"$f":"ROW()+2","v":4},{"$f":"ROW()+4","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not ready for production"]

{"sheet":"Instructions","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You will need to set up IAT as follows:"]
[1,"Under \"Print\" set to \"Capture\""]
[2,"Under Tools, set \"Mode\" to \"CC Print\""]
[3,"Make sure the button beside \"Grab:\" is set to \"All Pages\""]
[4,"Make sure the checkmark next to \"Capture\" is checked."]
[]
[null,"Using IAT, run IRPTRI for the period you need."]
[5,"When it is finished, click the small downward pointing arrows to open the screen."]
[null,"Click anywhere in that field.  "]
[6,"Press \"Ctrl\" & \"A\" to select all the info."]
[7,"Press \"Ctrl\" & \"C\""]
[8,"Now go to this spreadsheet & press \"Start\"."]
[]
[null,"If you get an error on IAT of \"Unsupported Level of Complication\", just re-do it.  It should work then."]