{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VOD Sheet","Vendors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"VOD Sheet","index":0,"n_rows":6,"n_cols":29,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["LastFour","FIRSTNAME","LASTNAME","ADDRESS","CITY","STATE","ZIP","OpenDate","CODate","COBalance","CurrentBalance","VendorPhone","VendorAddress","VendorCity","VendorState","VendorZip",null,"Account Number","First Name","Last Name","Street","City","State","Zip","Open Date","CO Date","CO Balance","Current Balance","Vendor"]
["5364","SHAWN","SPENCER","54531 PSYCH STREET","SANTA BARBARA","CA","45138","January 2, 2000","August 13, 2012","$52,369,844.00","$54,128,963.00",{"$f":"VLOOKUP(AC2,Vendors!$A$2:$B$10,2,FALSE)","v":5555555557},{"$f":"VLOOKUP(AC2,Vendors!$A$2:$C$10,3,FALSE)","v":"125 Fake Street"},{"$f":"VLOOKUP(AC2,Vendors!$A$2:$D$10,4,FALSE)","v":"San Diego"},{"$f":"VLOOKUP(AC2,Vendors!$A$2:$E$10,5,FALSE)","v":"CA"},{"$f":"VLOOKUP(AC2,Vendors!$A$2:$F$10,6,FALSE)","v":"54127"},null,75364,"Shawn","Spencer","54531 Psych Street","Santa Barbara","CA","45138","2000-01-02","2012-08-13",52369844,54128963,"Genie in a bottle"]
["8456","GUSTER","BURTON","8965 DRUGS LANE","SANTA BARBARA","CA","45128","April 5, 1999","September 4, 2012","$32,569.00","$21,458.00",{"$f":"VLOOKUP(AC3,Vendors!$A$2:$B$10,2,FALSE)","v":5555555556},{"$f":"VLOOKUP(AC3,Vendors!$A$2:$C$10,3,FALSE)","v":"124 Fake Street"},{"$f":"VLOOKUP(AC3,Vendors!$A$2:$D$10,4,FALSE)","v":"Provo"},{"$f":"VLOOKUP(AC3,Vendors!$A$2:$E$10,5,FALSE)","v":"UT"},{"$f":"VLOOKUP(AC3,Vendors!$A$2:$F$10,6,FALSE)","v":"54126"},null,1728456,"Guster","Burton","8965 Drugs Lane","Santa Barbara","CA","45128","1999-04-05","2012-09-04",32569,21458,"Flying Carpet"]
["8264","JULIET","O'HARA","14598 ROMANCE STREET","SANTA BARBARA","CA","45894","August 9, 1997","April 6, 2010","$258,963.00","$245,896.00",{"$f":"VLOOKUP(AC4,Vendors!$A$2:$B$10,2,FALSE)","v":5555555563},{"$f":"VLOOKUP(AC4,Vendors!$A$2:$C$10,3,FALSE)","v":"131 Fake Street"},{"$f":"VLOOKUP(AC4,Vendors!$A$2:$D$10,4,FALSE)","v":"San Diego"},{"$f":"VLOOKUP(AC4,Vendors!$A$2:$E$10,5,FALSE)","v":"CA"},{"$f":"VLOOKUP(AC4,Vendors!$A$2:$F$10,6,FALSE)","v":"54133"},null,78264,"Juliet","O'Hara","14598 Romance Street","Santa Barbara","CA","45894","1997-08-09","2010-04-06",258963,245896,"Crookshanks"]
["8632","CARLTON","LASSETER","3658 GUN SHOOTING DRIVE","SAN DIEGO","CA","48965","March 26, 1995","May 7, 1998","$159,683.00","$52,893.00",{"$f":"VLOOKUP(AC5,Vendors!$A$2:$B$10,2,FALSE)","v":5555555559},{"$f":"VLOOKUP(AC5,Vendors!$A$2:$C$10,3,FALSE)","v":"127 Fake Street"},{"$f":"VLOOKUP(AC5,Vendors!$A$2:$D$10,4,FALSE)","v":"Provo"},{"$f":"VLOOKUP(AC5,Vendors!$A$2:$E$10,5,FALSE)","v":"UT"},{"$f":"VLOOKUP(AC5,Vendors!$A$2:$F$10,6,FALSE)","v":"54129"},null,988632,"Carlton","Lasseter","3658 Gun Shooting Drive","San Diego","CA","48965","1995-03-26","1998-05-07",159683,52893,"Bagheera"]
["2436","CHIEF","VICK","6587 BIG BOSS LANE","ORANGE","CA","48759","June 19, 1995","December 12, 2011","$12,589.00","$57,935.00",{"$f":"VLOOKUP(AC6,Vendors!$A$2:$B$10,2,FALSE)","v":5555555561},{"$f":"VLOOKUP(AC6,Vendors!$A$2:$C$10,3,FALSE)","v":"129 Fake Street"},{"$f":"VLOOKUP(AC6,Vendors!$A$2:$D$10,4,FALSE)","v":"Salt Lake City"},{"$f":"VLOOKUP(AC6,Vendors!$A$2:$E$10,5,FALSE)","v":"UT"},{"$f":"VLOOKUP(AC6,Vendors!$A$2:$F$10,6,FALSE)","v":"54131"},null,712436,"Chief","Vick","6587 Big Boss Lane","Orange","CA","48759","1995-06-19","2011-12-12",12589,57935,"hedwig"]

{"sheet":"Vendors","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Vendor","Phone","Address","City","State","ZIP"]
["Magic Wand",5555555555,"123 Fake Street","Salt Lake City","UT","54125"]
["Flying Carpet",5555555556,"124 Fake Street","Provo","UT","54126"]
["Genie in a bottle",5555555557,"125 Fake Street","San Diego","CA","54127"]
["Abu",5555555558,"126 Fake Street","Salt Lake City","UT","54128"]
["Bagheera",5555555559,"127 Fake Street","Provo","UT","54129"]
["Baloo",5555555560,"128 Fake Street","San Diego","CA","54130"]
["Hedwig",5555555561,"129 Fake Street","Salt Lake City","UT","54131"]
["Norbert",5555555562,"130 Fake Street","Provo","UT","54132"]
["Crookshanks",5555555563,"131 Fake Street","San Diego","CA","54133"]