{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["BBD Report","2000","4000","Problem Table","Problem Table 2","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"BBD Report","index":0,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Billing Doc","Delivery","Shipment","Carrier","Created On","Tran Plg Pt","Bill. Date","Created on","Bill.Doc.","Name of the payer","Name of sold-to party","Reason","Action"]
[93650913,81766385,756154,9004,"2012-02-27",9458,"2012-02-27","2012-02-27",93650913,"COSENTINO'S - PRAIRIE VILLAGE","COSENTINOS PC SHAWNEE - DAIRY"]
[93651693,81761633,2440000,600020,"2012-02-27",9459,"2012-02-27","2012-02-28",93651693,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
[93651695,81761635,2449999,600020,"2012-02-27",9459,"2012-02-27","2012-02-28",93651695,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
[93651696,81761636,2440001,600020,"2012-02-27",9459,"2012-02-27","2012-02-28",93651696,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
[93651697,81761637,2440002,600020,"2012-02-27",9459,"2012-02-27","2012-02-28",93651697,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
[93651707,81761412,2440003,621812,"2012-02-27",9459,"2012-02-27","2012-02-28",93651707,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93651708,81761415,2440004,621812,"2012-02-27",9459,"2012-02-27","2012-02-28",93651708,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93651729,81763927,2440005,621437,"2012-02-27",9962,"2012-02-27","2012-02-28",93651729,"GFS ACCOUNTS PAYABLE - GRAND RAPIDS","GFS PRAIRIES - EDMONTON"]
[93651743,81763873,2440006,620778,"2012-02-27",9953,"2012-02-27","2012-02-28",93651743,"SYSCO FOODSERVICE OF PETERBOROUGH","SYSCO FOODSERVICE OF PETERBOROUGH"]
[93651744,81763874,1224427,620778,"2012-02-27",9953,"2012-02-27","2012-02-28",93651744,"SYSCO FOODSERVICE OF PETERBOROUGH","SYSCO FOODSERVICE OF PETERBOROUGH"]
[93651812,81766667,756155,9004,"2012-02-28",9458,"2012-02-28","2012-02-28",93651812,"COSENTINO'S - PRAIRIE VILLAGE","COSENTINOS PRICE CHOPPER - BELTON -"]
[93652167,81764502,1224604,621437,"2012-02-28",9962,"2012-02-28","2012-02-28",93652167,"APPLE TEDDY CIDER & JUICES - RED DE","APPLE TEDDY CIDER & JUICES - RED DE"]
[93652170,81764543,1224605,621437,"2012-02-28",9962,"2012-02-28","2012-02-28",93652170,"APPLE TEDDY CIDER & JUICES - RED DE","APPLE TEDDY CIDER & JUICES - RED DE"]
[93652571,81763339,1224359,600003,"2012-02-28",407,"2012-02-28","2012-02-29",93652571,"SUPER VALU - HOPKINS","SUPER VALU - HOPKINS"]
[93652572,81763340,null,null,"2012-02-28",null,"2012-02-28","2012-02-29",93652572,"SUPER VALU - HOPKINS","SUPER VALU - HOPKINS"]
[93652573,81763341,1224359,600003,"2012-02-28",407,"2012-02-28","2012-02-29",93652573,"SUPER VALU - HOPKINS","SUPER VALU - HOPKINS"]
[93652627,81763337,1224359,600003,"2012-02-28",407,"2012-02-28","2012-02-29",93652627,"MCLANE - TEMPLE","MCLANE - NORTHFIELD"]
[93652628,81763338,1224359,600003,"2012-02-28",407,"2012-02-28","2012-02-29",93652628,"MCLANE - TEMPLE","MCLANE - NORTHFIELD"]
[93652986,81765628,1225069,9002,"2012-02-29",113,"2012-02-29","2012-02-29",93652986,"BENDER GOODMAN INC","VENTURA FOODS-WAUKESHA"]
[93653469,81765813,1224030,9004,"2012-02-29",101,"2012-02-29","2012-03-01",93653469,"NASH FINCH - MINNEAPOLIS","NASH FINCH - ST CLOUD"]
[93654648,81766045,1224855,611644,"2012-03-01",9953,"2012-03-01","2012-03-01",93654648,"GFS ACCOUNTS PAYABLE - GRAND RAPIDS","GFS ONTARIO"]
[93656243,81768456,1225115,617590,"2012-03-02",407,"2012-03-02","2012-03-03",93656243,"SUPERVALU - HOPKINS","SUPERVALU - URBANA"]
[93656244,81768461,1225115,617590,"2012-03-02",407,"2012-03-02","2012-03-03",93656244,"SUPERVALU - HOPKINS","SUPERVALU - URBANA"]
[93656245,81766038,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656245,"SUPER VALU INC - TWO HARBORS","SUPERVALU - PITTSBURGH"]
[93656307,81765810,1224817,621811,"2012-03-02",407,"2012-03-02","2012-03-03",93656307,"WALMART STORES - BENTONVILLE","WALMART DC 6042 - PAUL VALLEY"]
[93656347,81769606,1224355,617552,"2012-03-02",407,"2012-03-02","2012-03-03",93656347,"SUPER VALU - HOPKINS","SUPERVALU - BISMARCK"]
[93656348,81769607,1224355,617552,"2012-03-02",407,"2012-03-02","2012-03-03",93656348,"SUPER VALU - HOPKINS","SUPERVALU - BISMARCK"]
[93656364,81766107,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656364,"WALMART STORES - BENTONVILLE","WALMART DC 7012 - WASHINGTON COURT"]
[93656376,81766044,1225115,617590,"2012-03-02",407,"2012-03-02","2012-03-03",93656376,"WALMART STORES - BENTONVILLE","WALMART DC 7017 - WINTERSVILLE"]
[93656393,81765808,1224817,621811,"2012-03-02",407,"2012-03-02","2012-03-03",93656393,"WALMART STORES - BENTONVILLE","WALMART DC 7015 - OCHELATA"]
[93656394,81765809,1224817,621811,"2012-03-02",407,"2012-03-02","2012-03-03",93656394,"WALMART STORES - BENTONVILLE","WALMART DC 7015 - OCHELATA"]
[93656497,81766379,1224969,621819,"2012-03-02",9459,"2012-03-02","2012-03-03",93656497,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
[93656498,81766380,1224969,621819,"2012-03-02",9459,"2012-03-02","2012-03-03",93656498,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
[93656499,81766381,1224969,621819,"2012-03-02",9459,"2012-03-02","2012-03-03",93656499,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
[93656500,81766383,1224969,621819,"2012-03-02",9459,"2012-03-02","2012-03-03",93656500,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
[93656503,81767200,1225086,621812,"2012-03-02",9459,"2012-03-02","2012-03-03",93656503,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93656504,81767201,1225086,621812,"2012-03-02",9459,"2012-03-02","2012-03-03",93656504,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93656505,81767202,1225086,621812,"2012-03-02",9459,"2012-03-02","2012-03-03",93656505,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93656506,81767204,1225086,621812,"2012-03-02",9459,"2012-03-02","2012-03-03",93656506,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93656507,81767206,1225086,621812,"2012-03-02",9459,"2012-03-02","2012-03-03",93656507,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
[93656509,81765744,1224817,621811,"2012-03-02",407,"2012-03-02","2012-03-03",93656509,"MCLANE - TEMPLE","MCLANE  - DANVILLE"]
[93656510,81765750,1224817,621811,"2012-03-02",407,"2012-03-02","2012-03-03",93656510,"MCLANE - TEMPLE","MCLANE  - DANVILLE"]
[93656532,81766028,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656532,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
[93656533,81766029,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656533,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
[93656534,81766030,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656534,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
[93656535,81766031,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656535,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
[93656536,81766035,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656536,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
[93656537,81766036,1224856,621818,"2012-03-02",9459,"2012-03-02","2012-03-03",93656537,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
[93656556,81765672,1225562,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656556,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656557,81765684,1225564,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656557,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656558,81765686,1225565,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656558,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656559,81765687,1225567,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656559,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656560,81765688,1225569,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656560,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656561,81765689,1225570,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656561,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656562,81765691,1225571,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656562,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656563,81765692,1225572,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656563,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656564,81765693,1225574,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656564,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656565,81765696,1225575,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656565,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656566,81765727,1225576,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656566,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
[93656568,81765619,1224978,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656568,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
[93656569,81765620,1224979,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656569,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
[93656570,81765653,1225539,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656570,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
[93656571,81765681,1225563,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656571,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
[93656572,81765625,1224992,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656572,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF EDMONTON"]
[93656573,81765660,1225548,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656573,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF EDMONTON"]
[93656574,81765655,1225546,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656574,"SYSCO FOOD SERVICES OF KINGSTON","SYSCO FOOD SERVICES OF KINGSTON"]
[93656576,81765623,1224991,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656576,"SYSCO FOOD SERVICES OF VANCOUVER","SYSCO FOOD SERVICES OF VANCOUVER"]
[93656577,81765652,1225107,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656577,"SYSCO FOOD SERVICES OF VANCOUVER","SYSCO FOOD SERVICES OF VANCOUVER"]
[93656578,81765656,1225547,616336,"2012-03-02",9951,"2012-03-02","2012-03-03",93656578,"SYSCO FOOD SERVICES OF VANCOUVER","SYSCO FOOD SERVICES OF VANCOUVER"]
[93656579,81765621,1224980,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656579,"SYSCO FOOD SERVICES OF KINGSTON","SYSCO FOOD SERVICES OF MILTON"]
[93656580,81765654,1225540,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656580,"SYSCO FOOD SERVICES OF KINGSTON","SYSCO FOOD SERVICES OF MILTON"]
[93656586,81765646,1224995,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656586,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
[93656587,81765649,1225105,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656587,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
[93656588,81765663,1225550,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656588,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
[93656589,81765667,1225561,611644,"2012-03-02",9951,"2012-03-02","2012-03-03",93656589,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
[93656591,81765626,1224993,620843,"2012-03-02",9951,"2012-03-02","2012-03-03",93656591,"SYSCO FOOD SERVICES OF VICTORIA","SYSCO FOOD SERVICES OF VICTORIA"]
[93656592,81765634,1224994,620843,"2012-03-02",9951,"2012-03-02","2012-03-03",93656592,"SYSCO FOOD SERVICES OF VICTORIA","SYSCO FOOD SERVICES OF VICTORIA"]
[93656593,81765661,1225549,620843,"2012-03-02",9951,"2012-03-02","2012-03-03",93656593,"SYSCO FOOD SERVICES OF VICTORIA","SYSCO FOOD SERVICES OF VICTORIA"]
[93657229,81767687,1225168,600000,"2012-03-05",9949,"2012-03-05","2012-03-05",93657229,"MATOSANTOS COMMERCIAL CORP","MATOSANTOS COMMERCIAL CORP"]
[93657267,81766729,1224755,600000,"2012-03-05",9907,"2012-03-05","2012-03-05",93657267,"OTTEX CORPORATION","OTTEX CORPORATION"]
[93657296,81770980,1225858,600195,"2012-03-05",108,"2012-03-05","2012-03-05",93657296,"EGG CLEARING HOUSE-DOVER","EGG CLEARING HOUSE-DOVER"]
[93657304,81771021,1225859,600000,"2012-03-05",104,"2012-03-05","2012-03-05",93657304,"ROSE ACRES-GUTHRIE CENTER","ROSE ACRES-GUTHRIE CENTER"]
[93657310,81771026,1225902,600000,"2012-03-05",109,"2012-03-05","2012-03-05",93657310,"ROSE ACRES-GUTHRIE CENTER","ROSE ACRES-GUTHRIE CENTER"]
[93657311,81771027,1225903,600195,"2012-03-05",109,"2012-03-05","2012-03-05",93657311,"ROSE ACRES-GUTHRIE CENTER","ROSE ACRES-GUTHRIE CENTER"]
[93657594,81770200,1225598,600097,"2012-03-05",102,"2012-03-05","2012-03-05",93657594,"GOLD COAST INGREDIENTS INC-CITY OF","GOLD COAST INGREDIENTS INC-CITY OF"]
[93657628,81768747,1225388,600097,"2012-03-02",102,"2012-03-02","2012-03-05",93657628,"BELLISIO FOODS - DULUTH","BELLISIO FOODS - JACKSON"]
[93657642,81770147,1225682,600941,"2012-03-02",102,"2012-03-02","2012-03-05",93657642,"COMFORT FOODS INC-ALBUQUERQUE","COMFORT FOODS INC-ALBUQUERQUE"]
[93657643,81768748,1225388,600097,"2012-03-02",102,"2012-03-02","2012-03-05",93657643,"KRAFT FOODS-FAIR LAWN","KRAFT FOODS-FAIR LAWN"]
[93657646,81769648,1225598,600097,"2012-03-05",102,"2012-03-05","2012-03-05",93657646,"LANCE INC C/O ARCHWAY COOKIES LLC","LANCE INC C/O ARCHWAY COOKIES LLC"]
[93658297,81771056,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658297,"WILLIAMSBURG FOODS","WILLIAMSBURG FOODS"]
[93658298,81771050,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658298,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE HAMILTON MEAT"]
[93658299,81771051,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658299,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE HAMILTON MEAT"]
[93658300,81771049,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658300,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE AUSTIN 1027 MEAT"]
[93658301,81771047,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658301,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE ALBERT LEA 1019 MEAT"]
[93658302,81771048,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658302,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE ALBERT LEA 1019 MEAT"]
[93658304,81771054,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658304,"AFFILIATED FOODS - NORFOLK","NELSONS MARKETPLACE ALBERT LEA"]
[93658305,81771053,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658305,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE SIOUX FALLS #3 MEAT"]
[93658306,81771320,756401,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658306,"HY VEE SIOUX FALLS","HY VEE SIOUX FALLS"]
[93658307,81771320,480001,9004,"2012-03-05",403,"2012-03-05","2012-03-05",93658306,"HY VEE SIOUX FALLS","HY VEE SIOUX FALLS"]

{"sheet":"2000","index":1,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Bill. Date","Created on","Bill.Doc.","Name of the payer","Name of sold-to party"]
["2012-02-27","2012-02-27",93650913,"COSENTINO'S - PRAIRIE VILLAGE","COSENTINOS PC SHAWNEE - DAIRY"]
["2012-02-27","2012-02-28",93651693,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
["2012-02-27","2012-02-28",93651695,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
["2012-02-27","2012-02-28",93651696,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
["2012-02-27","2012-02-28",93651697,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - FORT WORTH"]
["2012-02-27","2012-02-28",93651707,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-02-27","2012-02-28",93651708,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-02-28","2012-02-28",93651812,"COSENTINO'S - PRAIRIE VILLAGE","COSENTINOS PRICE CHOPPER - BELTON -"]
["2012-02-28","2012-02-29",93652571,"SUPER VALU - HOPKINS","SUPER VALU - HOPKINS"]
["2012-02-28","2012-02-29",93652572,"SUPER VALU - HOPKINS","SUPER VALU - HOPKINS"]
["2012-02-28","2012-02-29",93652573,"SUPER VALU - HOPKINS","SUPER VALU - HOPKINS"]
["2012-02-28","2012-02-29",93652627,"MCLANE - TEMPLE","MCLANE - NORTHFIELD"]
["2012-02-28","2012-02-29",93652628,"MCLANE - TEMPLE","MCLANE - NORTHFIELD"]
["2012-02-29","2012-02-29",93652986,"BENDER GOODMAN INC","VENTURA FOODS-WAUKESHA"]
["2012-02-29","2012-03-01",93653469,"NASH FINCH - MINNEAPOLIS","NASH FINCH - ST CLOUD"]
["2012-03-02","2012-03-03",93656243,"SUPERVALU - HOPKINS","SUPERVALU - URBANA"]
["2012-03-02","2012-03-03",93656244,"SUPERVALU - HOPKINS","SUPERVALU - URBANA"]
["2012-03-02","2012-03-03",93656245,"SUPER VALU INC - TWO HARBORS","SUPERVALU - PITTSBURGH"]
["2012-03-02","2012-03-03",93656307,"WALMART STORES - BENTONVILLE","WALMART DC 6042 - PAUL VALLEY"]
["2012-03-02","2012-03-03",93656347,"SUPER VALU - HOPKINS","SUPERVALU - BISMARCK"]
["2012-03-02","2012-03-03",93656348,"SUPER VALU - HOPKINS","SUPERVALU - BISMARCK"]
["2012-03-02","2012-03-03",93656364,"WALMART STORES - BENTONVILLE","WALMART DC 7012 - WASHINGTON COURT"]
["2012-03-02","2012-03-03",93656376,"WALMART STORES - BENTONVILLE","WALMART DC 7017 - WINTERSVILLE"]
["2012-03-02","2012-03-03",93656393,"WALMART STORES - BENTONVILLE","WALMART DC 7015 - OCHELATA"]
["2012-03-02","2012-03-03",93656394,"WALMART STORES - BENTONVILLE","WALMART DC 7015 - OCHELATA"]
["2012-03-02","2012-03-03",93656497,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
["2012-03-02","2012-03-03",93656498,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
["2012-03-02","2012-03-03",93656499,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
["2012-03-02","2012-03-03",93656500,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET PHOENIX DC"]
["2012-03-02","2012-03-03",93656503,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-03-02","2012-03-03",93656504,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-03-02","2012-03-03",93656505,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-03-02","2012-03-03",93656506,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-03-02","2012-03-03",93656507,"TARGET DEDICATED FOOD DISTRIBUTION","TARGET - LAKE CITY"]
["2012-03-02","2012-03-03",93656509,"MCLANE - TEMPLE","MCLANE  - DANVILLE"]
["2012-03-02","2012-03-03",93656510,"MCLANE - TEMPLE","MCLANE  - DANVILLE"]
["2012-03-02","2012-03-03",93656532,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
["2012-03-02","2012-03-03",93656533,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
["2012-03-02","2012-03-03",93656534,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
["2012-03-02","2012-03-03",93656535,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
["2012-03-02","2012-03-03",93656536,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
["2012-03-02","2012-03-03",93656537,"C&S WHOLESALE GROCERS - BRATTLEBORO","C&S WHOLESALE - DUBOIS"]
["2012-03-05","2012-03-05",93657229,"MATOSANTOS COMMERCIAL CORP","MATOSANTOS COMMERCIAL CORP"]
["2012-03-05","2012-03-05",93657267,"OTTEX CORPORATION","OTTEX CORPORATION"]
["2012-03-05","2012-03-05",93657296,"EGG CLEARING HOUSE-DOVER","EGG CLEARING HOUSE-DOVER"]
["2012-03-05","2012-03-05",93657304,"ROSE ACRES-GUTHRIE CENTER","ROSE ACRES-GUTHRIE CENTER"]
["2012-03-05","2012-03-05",93657310,"ROSE ACRES-GUTHRIE CENTER","ROSE ACRES-GUTHRIE CENTER"]
["2012-03-05","2012-03-05",93657311,"ROSE ACRES-GUTHRIE CENTER","ROSE ACRES-GUTHRIE CENTER"]
["2012-03-05","2012-03-05",93657594,"GOLD COAST INGREDIENTS INC-CITY OF","GOLD COAST INGREDIENTS INC-CITY OF"]
["2012-03-02","2012-03-05",93657628,"BELLISIO FOODS - DULUTH","BELLISIO FOODS - JACKSON"]
["2012-03-02","2012-03-05",93657642,"COMFORT FOODS INC-ALBUQUERQUE","COMFORT FOODS INC-ALBUQUERQUE"]
["2012-03-02","2012-03-05",93657643,"KRAFT FOODS-FAIR LAWN","KRAFT FOODS-FAIR LAWN"]
["2012-03-05","2012-03-05",93657646,"LANCE INC C/O ARCHWAY COOKIES LLC","LANCE INC C/O ARCHWAY COOKIES LLC"]
["2012-03-05","2012-03-05",93658297,"WILLIAMSBURG FOODS","WILLIAMSBURG FOODS"]
["2012-03-05","2012-03-05",93658298,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE HAMILTON MEAT"]
["2012-03-05","2012-03-05",93658299,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE HAMILTON MEAT"]
["2012-03-05","2012-03-05",93658300,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE AUSTIN 1027 MEAT"]
["2012-03-05","2012-03-05",93658301,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE ALBERT LEA 1019 MEAT"]
["2012-03-05","2012-03-05",93658302,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE ALBERT LEA 1019 MEAT"]
["2012-03-05","2012-03-05",93658304,"AFFILIATED FOODS - NORFOLK","NELSONS MARKETPLACE ALBERT LEA"]
["2012-03-05","2012-03-05",93658305,"HYVEE FOOD STORES INC-W DES MOINES","HY VEE SIOUX FALLS #3 MEAT"]
["2012-03-05","2012-03-05",93658306,"HY VEE SIOUX FALLS","HY VEE SIOUX FALLS"]

{"sheet":"4000","index":2,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Bill. Date","Created on","Bill.Doc.","Name of the payer","Name of sold-to party"]
["2012-02-27","2012-02-28",93651729,"GFS ACCOUNTS PAYABLE - GRAND RAPIDS","GFS PRAIRIES - EDMONTON"]
["2012-02-27","2012-02-28",93651743,"SYSCO FOODSERVICE OF PETERBOROUGH","SYSCO FOODSERVICE OF PETERBOROUGH"]
["2012-02-27","2012-02-28",93651744,"SYSCO FOODSERVICE OF PETERBOROUGH","SYSCO FOODSERVICE OF PETERBOROUGH"]
["2012-02-28","2012-02-28",93652167,"APPLE TEDDY CIDER & JUICES - RED DE","APPLE TEDDY CIDER & JUICES - RED DE"]
["2012-02-28","2012-02-28",93652170,"APPLE TEDDY CIDER & JUICES - RED DE","APPLE TEDDY CIDER & JUICES - RED DE"]
["2012-03-01","2012-03-01",93654648,"GFS ACCOUNTS PAYABLE - GRAND RAPIDS","GFS ONTARIO"]
["2012-03-02","2012-03-03",93656556,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656557,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656558,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656559,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656560,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656561,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656562,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656563,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656564,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656565,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656566,"VANDERPOL'S EGGS LTD - ABBOTSFORD","VANDERPOL'S EGGS LTD - ABBOTSFORD"]
["2012-03-02","2012-03-03",93656568,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
["2012-03-02","2012-03-03",93656569,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
["2012-03-02","2012-03-03",93656570,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
["2012-03-02","2012-03-03",93656571,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF REGINA"]
["2012-03-02","2012-03-03",93656572,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF EDMONTON"]
["2012-03-02","2012-03-03",93656573,"SYSCO FOOD SERVICES OF EDMONTON","SYSCO FOOD SERVICES OF EDMONTON"]
["2012-03-02","2012-03-03",93656574,"SYSCO FOOD SERVICES OF KINGSTON","SYSCO FOOD SERVICES OF KINGSTON"]
["2012-03-02","2012-03-03",93656576,"SYSCO FOOD SERVICES OF VANCOUVER","SYSCO FOOD SERVICES OF VANCOUVER"]
["2012-03-02","2012-03-03",93656577,"SYSCO FOOD SERVICES OF VANCOUVER","SYSCO FOOD SERVICES OF VANCOUVER"]
["2012-03-02","2012-03-03",93656578,"SYSCO FOOD SERVICES OF VANCOUVER","SYSCO FOOD SERVICES OF VANCOUVER"]
["2012-03-02","2012-03-03",93656579,"SYSCO FOOD SERVICES OF KINGSTON","SYSCO FOOD SERVICES OF MILTON"]
["2012-03-02","2012-03-03",93656580,"SYSCO FOOD SERVICES OF KINGSTON","SYSCO FOOD SERVICES OF MILTON"]
["2012-03-02","2012-03-03",93656586,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
["2012-03-02","2012-03-03",93656587,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
["2012-03-02","2012-03-03",93656588,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
["2012-03-02","2012-03-03",93656589,"SYSCO FOOD SERVICES OF KELOWNA","SYSCO FOOD SERVICES OF KELOWNA"]
["2012-03-02","2012-03-03",93656591,"SYSCO FOOD SERVICES OF VICTORIA","SYSCO FOOD SERVICES OF VICTORIA"]
["2012-03-02","2012-03-03",93656592,"SYSCO FOOD SERVICES OF VICTORIA","SYSCO FOOD SERVICES OF VICTORIA"]
["2012-03-02","2012-03-03",93656593,"SYSCO FOOD SERVICES OF VICTORIA","SYSCO FOOD SERVICES OF VICTORIA"]

{"sheet":"Problem Table","index":3,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Column","Find 1","Up to","Reason","Action"]
["Shipment",2440000,2449999,"Suspended/Not Closed Out","To perform a Confirmation Reversal you need to do the following.  Inform the shipping warehouse that you will be performing a Confirmation Reversal and that the bills might re-print and that any notes might be whiped out.  ******************** OR *****************************  Contact the warehouse and ask them why the shipment is not closed out.  On Mondays you may have a number of Hall's not closed out (Sioux City may be an issue as well) because they are not on the system."]
["Shipment",480000,489999,"CARTage shipment","Log into SAP, VT02n, enter the shipment number, look at the Spec. Process. And see if it states \"CART\".  If it doesn't state CART you will need to "]
["Carrier",600000,{"$f":"B4","v":600000},"Customer Pick Up","Manual processing as CPU, BBD email"]
["Carrier",600097,{"$f":"B5","v":600097},"UPS","Log into SAP, VL03N, type in the delivery number, click GOTO up top, select Header, select Texts, click on Pick/Pack/Load Instructs (MGW), find the $ amount.  Manual processing with the cost, BBD email."]

{"sheet":"Problem Table 2","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Field1","Field2","Field3","Value","Reason","Action"]
["Shipment","Tran Plg Pt","Carrier",null,"Shell Egg","Log into SAP, VL03N, type in the delivery number and hit enter, look at the items, if they are all shell eggs then this goes to manual processing as SHELL EGG.  Manual processing as Shell Eggs, BBD email."]

{"sheet":"Sheet2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}