{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Master","Turner","Smith","Jones","Johnson"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":1,"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":"Master","index":0,"n_rows":136,"n_cols":6,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table1"]
[null,"NName","Code","State","Zip","Bin"]
[null,"Smith","V5756","TX",925468994,"DOS"]
[null,"Jones","D2538","MN",485064290,"DOH"]
[null,"Turner","D2538","MN",605744692,"FOB"]
[null,"Jones","V5756","AR",814241959,"GUB"]
[null,"Turner","P5575","TX",326803194,"HAL"]
[null,"Smith","D7412","NV",792540769,"RAP"]
[null,"Turner","V5756","OR",484895496,"NIM"]
[null,"Johnson","L4795","GA",600413701,"DAH"]
[null,"Jones","H9545","NJ",743865436,"VAL"]
[null,"Jones","P4291","UT",455670408,"VUF"]
[null,"Johnson","V1486","GA",952041388,"RON"]
[null,"Turner","M8422","MS",419094319,"VEH"]
[null,"Smith","V5756","MN",166123959,"FUR"]
[null,"Turner","L4795","NJ",889184886,"FOD"]
[null,"Turner","D7412","ND",725864382,"HAJ"]
[null,"Smith","P5575","OR",316599927,"HUP"]
[null,"Jones","V5756","MI",609227977,"MIR"]
[null,"Turner","D7412","WA",549457246,"PES"]
[null,"Turner","V5756","MT",368829747,"LOG"]
[null,"Jones","H9545","IL",334390607,"PAN"]
[null,"Smith","H9545","KS",641097265,"WEG"]
[null,"Turner","V5756","CO",430892460,"SEK"]
[null,"Turner","V1486","TX",108978137,"FAF"]
[null,"Smith","H9545","MA",346307232,"SED"]
[null,"Jones","H9545","AK",675848352,"DOL"]
[null,"Smith","D2538","AR",869581683,"MUJ"]
[null,"Jones","D2538","ME",648548000,"PAP"]
[null,"Smith","P5575","LA",996284560,"WEN"]
[null,"Smith","M8422","LA",722838313,"GIG"]
[null,"Johnson","V1486","NJ",808575806,"VOK"]
[null,"Smith","V1486","AK",845114712,"WEJ"]
[null,"Johnson","H9545","FL",565487442,"VIG"]
[null,"Johnson","V1486","IN",802738693,"PAN"]
[null,"Turner","L4795","ID",283107599,"PAN"]
[null,"Smith","V5756","TN",932979103,"VUH"]
[null,"Johnson","D7412","OR",708633855,"HED"]
[null,"Turner","L4795","NC",468256147,"HIR"]
[null,"Turner","V5756","IN",594885268,"TOK"]
[null,"Smith","P4291","OH",569776831,"NAG"]
[null,"Smith","D7412","IA",772173343,"POL"]
[null,"Smith","V5756","AR",151726908,"JUF"]
[null,"Jones","D2538","GA",292893857,"SIB"]
[null,"Jones","D7412","IN",396747580,"KIL"]
[null,"Smith","P4291","AZ",619042181,"PUF"]
[null,"Jones","P4291","IN",473566630,"WOP"]
[null,"Smith","V1486","CT",243663771,"WAS"]
[null,"Turner","V1486","MI",845021161,"BAM"]
[null,"Johnson","D2538","OK",961188517,"VIL"]
[null,"Johnson","D2538","NM",887898974,"MAN"]
[null,"Smith","L4795","GA",672029635,"WEH"]
[null,"Johnson","L4795","TN",431609382,"LOD"]
[null,"Johnson","P4291","KS",943366244,"FUD"]
[null,"Johnson","L4795","MN",707946344,"TEL"]
[null,"Smith","P4291","HI",273513620,"NUG"]
[null,"Turner","D2538","GA",901456812,"VIG"]
[null,"Johnson","M8422","MA",909132742,"GOS"]
[null,"Johnson","V1486","RI",451331653,"NIB"]
[null,"Turner","D2538","KY",897924292,"NIB"]
[null,"Turner","M8422","AZ",132582921,"GOS"]
[null,"Jones","H9545","NJ",148688130,"RAP"]
[null,"Turner","P4291","IN",118094512,"WUR"]
[null,"Smith","P5575","FL",554760299,"JIK"]
[null,"Smith","P4291","ME",237257392,"BIL"]
[null,"Johnson","H9545","AR",227370746,"NAJ"]
[null,"Johnson","L4795","SC",395544962,"TAN"]
[null,"Jones","V1486","ME",343274647,"WER"]
[null,"Johnson","M8422","NC",394837556,"GIR"]
[null,"Turner","M8422","OK",400810389,"TEJ"]
[null,"Turner","V5756","MI",598555622,"BOL"]
[null,"Jones","D2538","DE",959899565,"GIH"]
[null,"Turner","M8422","PA",109233398,"LER"]
[null,"Jones","H9545","SC",206838753,"HAF"]
[null,"Turner","D7412","AR",278955978,"GEN"]
[null,"Turner","M8422","NE",218734592,"HUR"]
[null,"Turner","V1486","NC",844283515,"GEK"]
[null,"Jones","P4291","GA",250763881,"DEP"]
[null,"Turner","V1486","NM",323875336,"NIS"]
[null,"Smith","H9545","AK",733772141,"FEN"]
[null,"Jones","L4795","TN",205087373,"SID"]
[null,"Turner","P5575","OR",489762293,"NOG"]
[null,"Smith","V1486","ND",458368722,"BOB"]
[null,"Jones","P4291","GA",918345432,"BUR"]
[null,"Smith","P4291","IL",234068197,"NOL"]
[null,"Turner","D7412","PA",299078816,"JOS"]
[null,"Turner","P4291","MT",870512484,"DUP"]
[null,"Jones","P4291","ND",752704229,"WIP"]
[null,"Johnson","D2538","ND",576691289,"VIG"]
[null,"Smith","L4795","AL",139149296,"GES"]
[null,"Smith","L4795","TX",483407908,"GID"]
[null,"Turner","V1486","NV",197082216,"GAP"]
[null,"Johnson","V1486","OR",826067832,"VIG"]
[null,"Smith","M8422","GA",361190714,"RUS"]
[null,"Jones","M8422","OK",263159689,"WIK"]
[null,"Turner","D7412","WY",922270558,"GEH"]
[null,"Turner","P5575","WI",717155262,"MOK"]
[null,"Turner","V5756","KS",953254434,"TIK"]
[null,"Smith","L4795","GA",770271561,"VAD"]
[null,"Johnson","D2538","KY",730736386,"SID"]
[null,"Johnson","P4291","IL",948236132,"LAN"]
[null,"Turner","P5575","RI",788268140,"GIB"]
[null,"Turner","L4795","ME",181268369,"RAG"]
[null,"Turner","L4795","NC",981576128,"GIH"]
[null,"Johnson","P4291","UT",998900049,"DEH"]
[null,"Jones","V1486","LA",110382042,"DIF"]
[null,"Smith","V1486","WV",655590341,"TEB"]
[null,"Smith","P5575","IL",363012848,"FUB"]
[null,"Johnson","P5575","CA",147341628,"VIH"]
[null,"Johnson","L4795","AZ",122777193,"DUD"]
[null,"Jones","V5756","AK",593790151,"GIL"]
[null,"Turner","V1486","NJ",712747741,"TOK"]
[null,"Turner","V1486","CO",546220886,"NOM"]
[null,"Johnson","D7412","CT",915355766,"BOS"]
[null,"Johnson","P5575","ND",738400176,"VAG"]
[null,"Turner","H9545","FL",377548618,"FIB"]
[null,"Turner","H9545","VA",767857945,"KEJ"]
[null,"Jones","V5756","SD",796302495,"LEL"]
[null,"Johnson","V1486","IA",811479704,"PAR"]
[null,"Smith","P5575","MS",841550476,"RUB"]
[null,"Smith","M8422","IN",445098042,"VAJ"]
[null,"Johnson","P4291","RI",774004874,"BIL"]
[null,"Turner","D2538","TN",428966281,"HUJ"]
[null,"Jones","H9545","DE",810173526,"KON"]
[null,"Turner","P5575","WY",418906510,"SIG"]
[null,"Johnson","V5756","KY",504964186,"NUP"]
[null,"Jones","D7412","CT",299885337,"LUF"]
[null,"Jones","V5756","AR",258456686,"KAM"]
[null,"Johnson","H9545","NM",704109618,"HOF"]
[null,"Turner","L4795","MT",312848313,"FEG"]
[null,"Turner","M8422","SC",510856452,"GEN"]
[null,"Johnson","L4795","TN",649821880,"FEJ"]
[null,"Johnson","V1486","AR",109413593,"BIM"]
[null,"Johnson","M8422","KY",753002804,"HOL"]
[null,"Turner","V1486","DE",399159468,"TEG"]

{"sheet":"Turner","index":1,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NName"]
[null,{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"Turner"}]
[]
[null,"NName","Code","State","Zip"]
[null,"Turner","D2538","MN",605744692]
[null,"Turner","P5575","TX",326803194]
[null,"Turner","V5756","OR",484895496]
[null,"Turner","M8422","MS",419094319]
[null,"Turner","L4795","NJ",889184886]
[null,"Turner","D7412","ND",725864382]
[null,"Turner","D7412","WA",549457246]
[null,"Turner","V5756","MT",368829747]
[null,"Turner","V5756","CO",430892460]
[null,"Turner","V1486","TX",108978137]
[null,"Turner","L4795","ID",283107599]
[null,"Turner","L4795","NC",468256147]
[null,"Turner","V5756","IN",594885268]
[null,"Turner","V1486","MI",845021161]
[null,"Turner","D2538","GA",901456812]
[null,"Turner","D2538","KY",897924292]
[null,"Turner","M8422","AZ",132582921]
[null,"Turner","P4291","IN",118094512]
[null,"Turner","M8422","OK",400810389]
[null,"Turner","V5756","MI",598555622]
[null,"Turner","M8422","PA",109233398]
[null,"Turner","D7412","AR",278955978]
[null,"Turner","M8422","NE",218734592]
[null,"Turner","V1486","NC",844283515]
[null,"Turner","V1486","NM",323875336]
[null,"Turner","P5575","OR",489762293]
[null,"Turner","D7412","PA",299078816]
[null,"Turner","P4291","MT",870512484]
[null,"Turner","V1486","NV",197082216]
[null,"Turner","D7412","WY",922270558]
[null,"Turner","P5575","WI",717155262]
[null,"Turner","V5756","KS",953254434]
[null,"Turner","P5575","RI",788268140]
[null,"Turner","L4795","ME",181268369]
[null,"Turner","L4795","NC",981576128]
[null,"Turner","V1486","NJ",712747741]
[null,"Turner","V1486","CO",546220886]
[null,"Turner","H9545","FL",377548618]
[null,"Turner","H9545","VA",767857945]
[null,"Turner","D2538","TN",428966281]
[null,"Turner","P5575","WY",418906510]
[null,"Turner","L4795","MT",312848313]
[null,"Turner","M8422","SC",510856452]
[null,"Turner","V1486","DE",399159468]

{"sheet":"Smith","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NName"]
[null,{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"Smith"}]
[]
[null,"NName","Code","State","Zip","Bin"]
[null,"Smith","V5756","TX",925468994,"DOS"]
[null,"Smith","D7412","NV",792540769,"RAP"]
[null,"Smith","V5756","MN",166123959,"FUR"]
[null,"Smith","P5575","OR",316599927,"HUP"]
[null,"Smith","H9545","KS",641097265,"WEG"]
[null,"Smith","H9545","MA",346307232,"SED"]
[null,"Smith","D2538","AR",869581683,"MUJ"]
[null,"Smith","P5575","LA",996284560,"WEN"]
[null,"Smith","M8422","LA",722838313,"GIG"]
[null,"Smith","V1486","AK",845114712,"WEJ"]
[null,"Smith","V5756","TN",932979103,"VUH"]
[null,"Smith","P4291","OH",569776831,"NAG"]
[null,"Smith","D7412","IA",772173343,"POL"]
[null,"Smith","V5756","AR",151726908,"JUF"]
[null,"Smith","P4291","AZ",619042181,"PUF"]
[null,"Smith","V1486","CT",243663771,"WAS"]
[null,"Smith","L4795","GA",672029635,"WEH"]
[null,"Smith","P4291","HI",273513620,"NUG"]
[null,"Smith","P5575","FL",554760299,"JIK"]
[null,"Smith","P4291","ME",237257392,"BIL"]
[null,"Smith","H9545","AK",733772141,"FEN"]
[null,"Smith","V1486","ND",458368722,"BOB"]
[null,"Smith","P4291","IL",234068197,"NOL"]
[null,"Smith","L4795","AL",139149296,"GES"]
[null,"Smith","L4795","TX",483407908,"GID"]
[null,"Smith","M8422","GA",361190714,"RUS"]
[null,"Smith","L4795","GA",770271561,"VAD"]
[null,"Smith","V1486","WV",655590341,"TEB"]
[null,"Smith","P5575","IL",363012848,"FUB"]
[null,"Smith","P5575","MS",841550476,"RUB"]
[null,"Smith","M8422","IN",445098042,"VAJ"]

{"sheet":"Jones","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NName"]
[null,{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"Jones"}]
[]
[null,"NName","Code","State"]
[null,"Jones","D2538","MN"]
[null,"Jones","V5756","AR"]
[null,"Jones","H9545","NJ"]
[null,"Jones","P4291","UT"]
[null,"Jones","V5756","MI"]
[null,"Jones","H9545","IL"]
[null,"Jones","H9545","AK"]
[null,"Jones","D2538","ME"]
[null,"Jones","D2538","GA"]
[null,"Jones","D7412","IN"]
[null,"Jones","P4291","IN"]
[null,"Jones","H9545","NJ"]
[null,"Jones","V1486","ME"]
[null,"Jones","D2538","DE"]
[null,"Jones","H9545","SC"]
[null,"Jones","P4291","GA"]
[null,"Jones","L4795","TN"]
[null,"Jones","P4291","GA"]
[null,"Jones","P4291","ND"]
[null,"Jones","M8422","OK"]
[null,"Jones","V1486","LA"]
[null,"Jones","V5756","AK"]
[null,"Jones","V5756","SD"]
[null,"Jones","H9545","DE"]
[null,"Jones","D7412","CT"]
[null,"Jones","V5756","AR"]

{"sheet":"Johnson","index":4,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NName"]
[null,{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"Johnson"}]
[]
[null,"NName","Code","State","Zip"]
[null,"Johnson","L4795","GA",600413701]
[null,"Johnson","V1486","GA",952041388]
[null,"Johnson","V1486","NJ",808575806]
[null,"Johnson","H9545","FL",565487442]
[null,"Johnson","V1486","IN",802738693]
[null,"Johnson","D7412","OR",708633855]
[null,"Johnson","D2538","OK",961188517]
[null,"Johnson","D2538","NM",887898974]
[null,"Johnson","L4795","TN",431609382]
[null,"Johnson","P4291","KS",943366244]
[null,"Johnson","L4795","MN",707946344]
[null,"Johnson","M8422","MA",909132742]
[null,"Johnson","V1486","RI",451331653]
[null,"Johnson","H9545","AR",227370746]
[null,"Johnson","L4795","SC",395544962]
[null,"Johnson","M8422","NC",394837556]
[null,"Johnson","D2538","ND",576691289]
[null,"Johnson","V1486","OR",826067832]
[null,"Johnson","D2538","KY",730736386]
[null,"Johnson","P4291","IL",948236132]
[null,"Johnson","P4291","UT",998900049]
[null,"Johnson","P5575","CA",147341628]
[null,"Johnson","L4795","AZ",122777193]
[null,"Johnson","D7412","CT",915355766]
[null,"Johnson","P5575","ND",738400176]
[null,"Johnson","V1486","IA",811479704]
[null,"Johnson","P4291","RI",774004874]
[null,"Johnson","V5756","KY",504964186]
[null,"Johnson","H9545","NM",704109618]
[null,"Johnson","L4795","TN",649821880]
[null,"Johnson","V1486","AR",109413593]
[null,"Johnson","M8422","KY",753002804]