{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":7,"n_cols":26,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Title","Last Four","Prin","Int","Fees","Total","Last Payment Line","Payment","Ending","CU First","CU Last","ST","Notary Date",null,"Account Number","Customer First Name","Customer Last Name","State","Principal","Interest","Late Fees","Total Due","Last Payment","Agent Name","Notary","Notary Expiration Date"]
["Placement Account Manager","3132","$554,352.00","$46,565.00","$0.00","$600,917.00","The last payment made on this account was on ","June 15, 2012",".","HARRY","POTTER","NY","December 20, 2015",null,"5413132","Harry","Potter","ny",554352,46565,0,600917,"2012-06-15","Neville Longbottom","Professor Lupin",{"$f":"VLOOKUP(Y2,Sheet2!$A$2:$B$6,2,FALSE)","v":"2015-12-20"}]
["Placement Account Manager","2165","$45,155.00","$4.00","$542.00","$45,701.00","The last payment made on this account was on ","September 18, 2010",".","RONALD","WEASLEY","MA","December 20, 2015",null,"212165","Ronald","Weasley","ma",45155,4,542,45701,"2010-09-18","Neville Longbottom","Professor Lupin","2015-12-20"]
["Placement Account Manager","3215","$51,345.00","$1,454.00","$13.00","$52,812.00","The last payment made on this account was on ","May 29, 2012",".","HERMIONE","GRANGER","ME","December 20, 2015",null,"113215","Hermione","Granger","me",51345,1454,13,52812,"2012-05-29","Neville Longbottom","Professor Lupin","2015-12-20"]
["Placement Account Manager","1545","$54,354.00","$551.00","$512.00","$55,417.00","The last payment made on this account was on ","May 6, 2009",".","GINNY","POTTER","MI","December 20, 2015",null,"3211545","Ginny","Potter","mi",54354,551,512,55417,"2009-05-06","Neville Longbottom","Professor Lupin","2015-12-20"]
["Placement Account Manager","1554","$531,355.00","$44,424.00","$1,511.00","$577,290.00","There has never been a payment made on this account.","","","DRACO","MALFOY","VT","December 20, 2015",null,"54521554","Draco","Malfoy","vt",531355,44424,1511,577290,"none","Gregory Goyle","Professor Lupin","2015-12-20"]
["Placement Account Manager","4135","$435,154.00","$455.00","$121.00","$435,730.00","The last payment made on this account was on ","February 16, 2013",".","LUNA","LOVEGOOD","TN","December 20, 2015",null,"45314135","Luna","Lovegood","tn",435154,455,121,435730,"2013-02-16","Neville Longbottom","Professor Lupin","2015-12-20"]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Notary","Expiration Date"]
["Professor Quirrell","2015-01-19"]
["Professor Lockhart","2015-09-15"]
["Professor Lupin","2015-12-20"]
["Professor Moody","2013-03-04"]
["Professor Umbridge","2015-08-12"]