{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["System","Inventory Detail","Customer DataBase","Purchase Order","Shipment","Back Order","Individual P.O.","Back Order Report","test"],"not_rendered":{"charts":0,"images":0,"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":"System","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,3,10],[5,4,6,8]]}
[]
[]
[null,null,"Dream Chocolate"]
[]
[]
[null,null,null,null,"Inventory Control System"]
[]
[]
[]
[]
[]
[]
[null,null,1,"Click to Create New P.O",null,1,"Click to Edit Customer Info",null,1,"Click to Find P.O."]
[null,null,null,null,null,2,"Click to Find Customer",null,2,"Click To Open P.O."]
[null,null,null,null,null,3,"Click to Add New Customer",null,3,"Click To Check status"]
[]
[]
[]
[null,null,null,1,"Click to Update Sells Price",null,null,1,"Click To Generate Report"]

{"sheet":"Inventory Detail","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["S.No","Product Segment","Product","Quantity","Quantity Available","Price","Back Order","Location"]
[1,"Organic Chocolate Bars","Coconut Almond Creme Milk",125,0,27,40,"A1"]
[2,"Organic Chocolate Bars","Caramel Creme Latte Milk",178,0,27,45,"A2"]
[3,"Organic Chocolate Bars","Coconut Curry Milk",189,179,27,0,"A3"]
[4,"Organic Chocolate Bars","Crystallized Ginger Dark",115,49,27,0,"A4"]
[5,"Organic Chocolate Bars","Dark Mint",147,0,27,53,"A5"]
[6,"Organic Chocolate Bars","Dark Espresso",192,185,27,0,"B1"]
[7,"Organic Chocolate Bars","Dark Chocolate",10,0,27,0,"B2"]
[8,"Organic Chocolate Bars","Dark Lavender",198,136,27,0,"B3"]
[9,"Organic Chocolate Bars","Dark Coco Nibs",196,139,27,0,"B4"]
[10,"Genuine Series Bars","Crème de Coco",112,101,25.8,0,"B5"]
[11,"Genuine Series Bars","Crème de Menthe",30,0,25.8,20,"C1"]
[12,"Genuine Series Bars","Extreme Dark",114,56,25.8,0,"C2"]
[13,"Genuine Series Bars","White Lavender ",105,88,25.8,0,"C3"]
[14,"Genuine Series Bars","Kona Mint",112,112,25.8,0,"C4"]
[15,"Genuine Series Bars","Lavender Milk",184,184,25.8,0,"C5"]
[16,"Genuine Series Bars","Milk Macedamia",101,23,25.8,0,"D1"]
[17,"Genuine Series Bars","Suger Free Chocolate",179,121,25.8,0,"D2"]
[18,"Genuine Series Bars","Orange Milk Chocolate",175,160,25.8,0,"D3"]
[19,"Genuine Series Bars","Rich Milk Chocolate",187,123,25.8,0,"D4"]
[20,"HuckleBerry Products","HuckleBerry White",156,124,36,0,"D5"]
[21,"HuckleBerry Products","HuckleBerry Dark",102,46,36,0,"E1"]
[22,"HuckleBerry Products","Rocky Mountain Gournment HuckleBerry",111,0,36,36,"E2"]
[23,"HuckleBerry Products","HuckleBerry White Chocolate Bark",199,156,36,0,"E3"]
[24,"Specialty Bars/Hawaiian Chocolate","Hava Kava Coconut Ginger",40,10,38.4,0,"E4"]
[25,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",149,0,38.4,80,"E5"]
[26,"Specialty Bars/Hawaiian Chocolate","Hava Kava Pineapple Lime",200,100,38.4,0,"F1"]
[27,"Specialty Bars/Life Style Chocolate Bars","Beach Lover Milk",155,150,38.4,0,"F2"]
[28,"Specialty Bars/Life Style Chocolate Bars","Biker Bar Dark",156,112,38.4,0,"F3"]
[29,"Specialty Bars/Life Style Chocolate Bars","Golf Lover Milk",163,78,38.4,0,"F4"]
[30,"Specialty Bars/Life Style Chocolate Bars","Biker Bar Milk",10,0,38.4,20,"F5"]
[31,"Specialty Bars/Life Style Chocolate Bars","Golf Lover Dark",127,120,38.4,0,"G1"]
[32,"Specialty Bars/Life Style Chocolate Bars","Beach Lover Dark",134,82,38.4,0,"G2"]
[33,"Specialty Bars/OmniPeace","Peace of Chocolate Dark",12,5,3.99,0,"G3"]
[34,"Specialty Bars/OmniPeace","Peace of Chocolate-Raspberry",194,103,3.99,0,"G4"]
[35,"Specialty Bars/OmniPeace","Peace of Chocolate Milk",128,73,3.99,0,"G5"]
[36,"Specialty Bars/OmniPeace","Peace of Caramel Creme Latte",196,79,3.99,0,"H1"]
[37,"State Shape Bar","Oregon",194,145,36,0,"H2"]
[38,"State Shape Bar","California",25,0,27,5,"H3"]
[39,"State Shape Bar","Monatan",0,0,36,0,"H4"]
[40,"State Shape Bar","Nevada Shapped",15,10,27,0,"H5"]

{"sheet":"Customer DataBase","index":2,"n_rows":202,"n_cols":9,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["ID","First Name","Last Name","Street Address","City","State","Zip Code","Phone Number","Email address"]
[1,"EVELYN","SABO","5617 Hoover St., Suite A","Houston","TX","77092-3346","(713) 263-1944","isworld@byu.edu "]
[2,"SUSAN","KISSLINGER","8800 Conant","Hamtramck","MI",48211,"(313) 921-7710","isys520@byu.net "]
[3,"TOM","MCCLELLAN","3313 North Jones Street","Fort Worth","TX",76106,"(817) 626-0983","tjed@byu.edu"]
[4,"BEVERLY","STOKLEY","629 Railroad Street","Carroll","IA",51401,"(712) 792-5909","mis.survey@byu.edu "]
[5,"BRITTNEY","BOOTH","W 5725 Birch Creek Road No 6","Menominee","MI",49858,"(906) 863-3498","sigsand@byu.edu"]
[6,"RONNIE","PRUETT","19690 Hwy 412 E.","Lexington","TN",38351,"(731) 967-1411","junk-mail@byu.edu "]
[7,"ORBIT","BAETEN","458 1/2 South Broadway","Yonkers","NY",10705,"(914) 968-2209","govena@byu.edu"]
[8,"ANGELO","CAMARANO","5428 Fm 69","Coke","TX",75431,"(903) 629-3856","agent@byu.edu "]
[9,"RUSSELL","WALTER","1728 Kalani Street","Honolulu","HI",96819,"(808) 845-5902","isworld@byu.edu "]
[10,"MICHAEL","THELEN","814 Second Avenue","Elizabeth","NJ",7202,"(908) 354-2674","isys520@byu.net "]
[11,"SOCRATES","SAGRIS","86-17 Northern Blvd","Jackson Heights","NY",11372,"(718) 779-4971","tjed@byu.edu"]
[12,"NORMA","BENDER","53-42 98th Street","Corona","NY",11368,"(718) 271-8228","mis.survey@byu.edu "]
[13,"KATHY","GRAVES","5165 Forsyth Commerce Rd","Orlando","FL",32807,"(407) 282-3200","sigsand@byu.edu"]
[14,"EDRICK","GRIER","2480 W 80 St. # 1","Hialeah","FL",33016,"(305) 556-2010","junk-mail@byu.edu "]
[15,"FRANCISCO","SANCHEZ","6000 South 35th Street","McAllen","TX",78503,"(956) 686-3846","govena@byu.edu"]
[16,"LEWIS","GELINAS","34165 Autry","Livonia","MI","48150-1333","(734) 422-2060","agent@byu.edu "]
[17,"CHUCK","AHEARN","4921 Clautier Ave.","Salida","CA",95368,"(209) 406-7888","isworld@byu.edu "]
[18,"LLOYD","HARE","2939 Sunol Dr.","Vernon","CA",90023,"(213) 763-8500","isys520@byu.net "]
[19,"SHAWN","HILL","12 Middle Street (rear)","Taneytown","MD","21787-2120","(410) 756-2420","tjed@byu.edu"]
[20,"BETTY","ROSE","108 Front St Suite 102","Labadie","MO",63055,"(636) 587-2000","mis.survey@byu.edu "]
[21,"LARRY","ROPPEL","278 Ideal Street","Paincourtville","LA",70391,"(985) 369-2677","sigsand@byu.edu"]
[22,"ALLISON","TROUP","2275 Jennings St.","San Francisco","CA",94124,"(415) 822-3366","junk-mail@byu.edu "]
[23,"JOSEPH","D'ELIA","123 Grand Street","Brooklyn","NY",11211,"(718) 384-7400","govena@byu.edu"]
[24,"ROBERT","ZASTEMPOWSKI","201 N Main Street","Bluffton","OH",45817,"(419) 358-2926","agent@byu.edu "]
[25,"MELANIE","BAUER","209 McLean Boulevard","Paterson","NJ",7504,"(973) 523-4101","isworld@byu.edu "]
[26,"RAYMOND","KNAPP","400 Lincoln Blvd.","Middlesex","NJ",8846,"(732) 563-4001","isys520@byu.net "]
[27,"ANDY","JACKSON","739 Ramsey Avenue","Hillside","NJ",7205,"(908) 206-8886","tjed@byu.edu"]
[28,"BRIAN","AMENTA","5604 Georgia Ave","West Palm Beach","FL",33405,"(561) 202-9967","mis.survey@byu.edu "]
[29,"ROMY","SAINT-HILAIRE","12 Church Street","Keansburg","NJ",7734,"(732) 787-7798","sigsand@byu.edu"]
[30,"ERNST","SARTORIUS","4310 14th Avenue","Brooklyn","NY",11219,"(718) 436-5511","junk-mail@byu.edu "]
[31,"EDGAR","CASTILLO","318 E. Airy Street","Norristown","PA",19401,"(610) 275-3437","govena@byu.edu"]
[32,"LESLIE","LLOYD","Agulla St. # 107","Mayaguez","PR",680,"(787) 832-4145","agent@byu.edu "]
[33,"JASON","NEPTUNE","3101 Kailiili Road","Haiku","HI",96708,"(808) 572-0101","isworld@byu.edu "]
[34,"JOHNNY","POWELL","100 Wendling Plaza","Buckhannon","WV",26201,"(304) 472-5500","isys520@byu.net "]
[35,"HEIKKI","KEINANEN","11404 68th Avenue","Allendale","MI",49401,"(616) 895-4333","tjed@byu.edu"]
[36,"KURT","WEISS","5 Wegmann Way","Oak Ridge","NJ",7438,"(516) 872-2070","mis.survey@byu.edu "]
[37,"TOM","BELAU","1700 North Soto St.","Los Angeles","CA",90033,"(323) 222-0827","sigsand@byu.edu"]
[38,"DEE","WATSON","100 North 15th Street","Ord","NE",68862,"(308) 728-3858","junk-mail@byu.edu "]
[39,"WILLIAM","WEBER","2975 Laguna Canyon Rd.","Laguna Beach","CA",92651,"(949) 497-1741","govena@byu.edu"]
[40,"NICK","SPARACINO","505 Jones Road","Winston-Salem","NC",27107,"(336) 788-9008","agent@byu.edu "]
[41,"JANET","HOFFMANN","26231 River Run Trail","Zuni","VA","23898-3215","(757) 562-2387","isworld@byu.edu "]
[42,"DIANE","FARRELL","2130 Queens Chapel Rd, NE","Washington","DC","20018-3608","(202) 832-2600","isys520@byu.net "]
[43,"ROBERT","ABUTIN","1311 8th Street","Berkeley","CA",94710,"(510) 526-7000","tjed@byu.edu"]
[44,"PATRICIA","LLAPITAN","178 West Service Road","Champlain","NY",12919,"(518) 298-7465","mis.survey@byu.edu "]
[45,"THOMAS","SHORTS","56 Railroad Ave","Stamford","NY",12167,"(607) 652-2151","sigsand@byu.edu"]
[46,"BARRY","WHISNANT","77 N. Hetrick Avenue","Palmyra","PA","17078-0388","(717) 838-6356","junk-mail@byu.edu "]
[47,"JASON","BARCOMB","5600 First Ave -PO Box 290","Brooklyn","NY",11220,"(718) 492-0760","govena@byu.edu"]
[48,"KIM","WELSH","830 Capitolio Way","San Luis Obispo","CA",93401,"(805) 544-7600","agent@byu.edu "]
[49,"MATT","RUDISILL","178 West Service Road","Champlain","NY",12919,"(518) 298-7465","isworld@byu.edu "]
[50,"MICHAEL","TRAINOR","438 Griffith Ave.","Sweetgrass","MT",59484,"(406) 335-2342","isys520@byu.net "]
[51,"VERA","FEDERICO","1st & Griffith","Sweetgrass","MT",59484,"(406) 335-2342","tjed@byu.edu"]
[52,"ERNEST","HIGGS","3698 1/2 NW 16th St., Bay G","Lauderhill","FL",33311,"(954) 616-6328","mis.survey@byu.edu "]
[53,"HENRY","JOHANSKY","3855 Co. Rd. 36","Killen","AL",35645,"(256) 757-8269","sigsand@byu.edu"]
[54,"NORMA","DAVIS","1457 Lidcombe Ave","El Monte","CA",91733,"(626) 579-2299","junk-mail@byu.edu "]
[55,"JOYCE","ANDERSON","3721 East Slauson Ave.","Maywood","CA",90270,"(323) 582-8618","govena@byu.edu"]
[56,"DENNIS","CALLAHAN","3823 South Halsted st","Chicago","IL",60609,"(773) 927-3233","agent@byu.edu "]
[57,"IAN","SHEARS","751 Waiakamilo Road","Honolulu","HI",96817,"(808) 832-6650","isworld@byu.edu "]
[58,"ROBERT","DAYTON","205 Buck Mountain Rd.","West Jefferson","NC",28694,"(336) 246-3319","isys520@byu.net "]
[59,"ROBERT","KIRKLAND","907 Produce Park Lane","Hidalgo","TX",78557,"(956) 843-9884","tjed@byu.edu"]
[60,"RICHARD","RINGLER","920 E Spruce St","Abbotsford","WI",54405,"(715) 223-3742","mis.survey@byu.edu "]
[61,"WILLIAM","LOUGHRAN","3623 Blackington Ave.","Flint","MI",48532,"(810) 232-7128","sigsand@byu.edu"]
[62,"FREDERICK","OSBORN","508 East Linden Street","Abbotsford","WI",54405,"(715) 223-6386","junk-mail@byu.edu "]
[63,"CHARLES","BRANDON","539 N. Meridian Street","Curtiss","WI",54422,"(715) 223-4676","govena@byu.edu"]
[64,"HERBERT","LINDSAY","1741 Allen Street","Allentown","PA",18104,"(610) 435-1735","agent@byu.edu "]
[65,"HERBERT","LINDSAY","8758 South US Highway 377","Dublin","TX",76446,"(254) 968-4919","isworld@byu.edu "]
[66,"JASON","BURNETTE","2418 Data Dr.","Louisville","KY",40299,"(812) 755-5031","isys520@byu.net "]
[67,"LARRY","O'NEILL","210 Hastings Avenue","Saint Paul Park","MN",55071,"(651) 459-6372","tjed@byu.edu"]
[68,"RICHARD","JAYNES","84 Market Street","Passaic","NJ",7055,"(973) 773-3888","mis.survey@byu.edu "]
[69,"DANA","REYNOLDS","Carr #1 KM 30 Bo. Bairoa","Caguas","PR",746,null,"sigsand@byu.edu"]
[70,"JIM","AIMONE","2881 Wyoming Street","Dearborn","MI","48120-1599","(313) 841-4900","junk-mail@byu.edu "]
[71,"DAVID","BANGS","329 South Main Street","Church Point","LA",70525,"(337) 684-6933","govena@byu.edu"]
[72,"REED","HALVORSEN","280 Jessup Road","Thorofare","NJ",8086,"(856) 848-8877","agent@byu.edu "]
[73,"MARY","SEVER","740 Industrial Drive","Elmhurst","IL",60126,"(630) 942-8461","isworld@byu.edu "]
[74,"JACKIE","FLANAGAN","670 Chesapeake Park Plaza","Baltimore","MD",21220,"(410) 238-3866","isys520@byu.net "]
[75,"MICHAEL","JERABEK","30301 Commerce Blvd","Chesterfield","MI",48051,"(586) 749-2882","tjed@byu.edu"]
[76,"BARBARA","BRAGE","5710 Lord St","Scottsmoor","FL",32775,"(888) 823-8999","mis.survey@byu.edu "]
[77,"RANDY","RICKERT","210 Alden Street","Fall River","MA",2723,"(508) 678-2098","sigsand@byu.edu"]
[78,"THOMAS","ALCOCK","17076 Hwy 32 N","Pinetown","NC",27865,"(252) 927-3700","junk-mail@byu.edu "]
[79,"ROGER","ONEY","1323 North Zarzamora Street","San Antonio","TX",78207,"(210) 834-7645","govena@byu.edu"]
[80,"JOHN","BEARDEN","6210 East Fulton Street","Ada","MI",49301,"(616) 676-0767","agent@byu.edu "]
[81,"NEIL","SWIDEY","854 Bearsden Road","Athol","MA",1331,"(978) 249-9441","isworld@byu.edu "]
[82,"GROSS","MARTIN","35 New Britain Avenue","Hartford","CT",6106,"(860) 522-1588","isys520@byu.net "]
[83,"JASON","ZEINERT","101 14th Street SE","Orange City","IA",51041,"(712) 737-4829","tjed@byu.edu"]
[84,"ANTHONY","LLOYD","4929 East Willow","Enid","OK",73701,"(580) 616-6656","mis.survey@byu.edu "]
[85,"RONALD","MADEWELL","5109 E. Willow","Enid","OK",73701,"(580) 237-6656","sigsand@byu.edu"]
[86,"DAVID","RASMUSSEN","5110 Enterprise Blvd.","Enid","OK",73701,"(580) 616-6656","junk-mail@byu.edu "]
[87,"DAVID","RASMUSSEN","206 East Pine","Enid","OK",73701,"(580) 616-6656","govena@byu.edu"]
[88,"DANIEL","RENSHAW","201 South Raleigh Rd.","Enid","OK",73701,"(580) 616-6656","agent@byu.edu "]
[89,"TIM","SPROUSE","100 Washburn Road","Cherokee","IA","51012-0832","(712) 225-3637","isworld@byu.edu "]
[90,"DEBBIE","DUNAWAY","28-32 Urban Ave.","Westbury","NY",11590,"(516) 333-6344","isys520@byu.net "]
[91,"ROY","ACHZIGER","11601 S. Central","Alsip","IL",60803,"(708) 293-1926","tjed@byu.edu"]
[92,"MATT","RENO","1301 Northpark Drive","Fort Worth","TX",76102,"(817) 332-5807","mis.survey@byu.edu "]
[93,"LARRY","HALLSTROM","400 Drew Court","King Of Prussia","PA",19406,"(610) 277-5010","sigsand@byu.edu"]
[94,"SHARON","SCHINDELL","3225 South Main Street","Fort Worth","TX",76110,"(817) 207-8600","junk-mail@byu.edu "]
[95,"SANDRA","CLARK","131 Roseway Drive","Thomasville","GA",31792,"(229) 584-0420","govena@byu.edu"]
[96,"HERBERT","RASMUSSEN","5151 Fairbank RD","Ashville","NY","14710-9801","(716) 782-2000","agent@byu.edu "]
[97,"ALVIN","WALKER","4170 Gravois","Saint Louis","MO",63116,"(314) 773-8868","isworld@byu.edu "]
[98,"JAY","THOMPSON","1 Ikea Drive, CN 6070","Elizabeth","NJ",7207,null,"isys520@byu.net "]
[99,"MARK","BAKER","201 NE 2nd Avenue, Suite 100","Portland","OR",97232,"(503) 730-8390","tjed@byu.edu"]
[100,"JEFF","THOMPSON","8640 Siempre Viva Rd.","San Diego","CA",92154,"(619) 710-1871","mis.survey@byu.edu "]
[101,"HAL","IRWIN","225 John Hancock Rd.","Taunton","MA","02780-7818","(617) 880-5243","sigsand@byu.edu"]
[102,"ERIC","MCGLASHING","4430 S. Tripp Avenue","Chicago","IL",60632,"(773) 247-5060","junk-mail@byu.edu "]
[103,"ELVIA","HERNANDEZ","220 West Street","Postville","IA",52162,"(563) 864-7811","govena@byu.edu"]
[104,"PAMELA","DELUCIA","AURI, 1501 State Street","Marshall","MN",56258,"(507) 537-7440","agent@byu.edu "]
[105,"JAMES","NEWTON","3rd Street & Murray","Helena","OK",73741,"(580) 852-3221","isworld@byu.edu "]
[106,"EVANGELINE","EDWARDS","Grider Road","McAlester","OK","74502-1999","(918) 423-9212","isys520@byu.net "]
[107,"CHARLIE","SIMMS","23 Grant Street","Linden","NJ",7036,"(908) 587-0081","tjed@byu.edu"]
[108,"ROBERT","MILLER","7224 N.W. 25th Street","Miami","FL",33122,"(305) 763-5448","mis.survey@byu.edu "]
[109,"TROY","DUCK","7124 North Marine Drive","Portland","OR",97203,"(503) 286-6548","sigsand@byu.edu"]
[110,"JOSEPH","AMBROSETTI","444 Marshall Street","Paterson","NJ",7503,"(973) 742-4990","junk-mail@byu.edu "]
[111,"JACK","CERVONI","570 Williams St.","San Leandro","CA",94577,"(510) 483-3273","govena@byu.edu"]
[112,"JOHNNIE","HOPKINS","37-14 56th Street","Woodside","NY",11377,"(646) 338-8002","agent@byu.edu "]
[113,"KAREN","REALE","45 Ferry Street","South River","NJ",8882,"(732) 238-0428","isworld@byu.edu "]
[114,"ELLEN","CLINTON","3713 Jensen Drive","Houston","TX",77026,"(713) 228-6445","isys520@byu.net "]
[115,"BERNIE","BOUTIN","355 E. 76th, Suite 106","Anchorage","AK",99518,"(907) 562-9595","tjed@byu.edu"]
[116,"ALANA","BUTLER","2164 Island Circle","Kodiak","AK",99615,"(907) 486-3905","mis.survey@byu.edu "]
[117,"WILLIAM","EXINER","Bering Pacific Ranches","Unalaska","AK",99685,"(907) 345-1160","sigsand@byu.edu"]
[118,"ARTHUR","GETZ","2914 Arctic Blvd.","Anchorage","AK",99509,"(907) 562-3636","junk-mail@byu.edu "]
[119,"BRIAN","WILDER","695 Henderson Road","Boaz","AL",35957,"(256) 505-4500","govena@byu.edu"]
[120,"BOBBY","EPLING","200 Tyson Drive","Albertville","AL",35950,"(256) 593-3152","agent@byu.edu "]
[121,"RORY","FARRIS","6 Downing Drive","Phenix City","AL",36869,"(334) 664-0448","isworld@byu.edu "]
[122,"AILEEN","MARCUS","2410 Y.H. Hanson Ave.","Albert Lea","MN",56007,"(507) 377-7265","isys520@byu.net "]
[123,"EMILIO","VICENTE","130 Quality Drive","Albertville","AL",35950,"(256) 840-9923","tjed@byu.edu"]
[124,"KATHY","VICENTE","1534 Orourke/Air Ind Road","Gaylord","MI",49735,"(989) 732-2800","mis.survey@byu.edu "]
[125,"BRUCE","NELSON","129 West Church Street","Albion","NE",68620,"(402) 395-2619","sigsand@byu.edu"]
[126,"HAROLD","LAMPERT","4300 Alexander Blvd., NE","Albuquerque","NM",87107,"(505) 344-4011","junk-mail@byu.edu "]
[127,"HUGH","WEBB","382 Main Street","Harleysville","PA",19438,"(215) 256-8818","govena@byu.edu"]
[128,"NAIM","NASRALLAH","625 East Broad Street","Quakertown","PA",18951,"(215) 256-8818","agent@byu.edu "]
[129,"JOHN","JOHANNSON","4461 Township Line Road","Schwenksville","PA",19473,"(484) 991-1000","isworld@byu.edu "]
[130,"CONNIE","STEWART","1026 Campus Rd.","Mundelein","IL",60060,"(847) 968-2533","isys520@byu.net "]
[131,"CONNIE","STEWART","120 Fulton St.","Fresno","CA",93721,"(559) 264-4900","tjed@byu.edu"]
[132,"WAYNE","PALON","911 North Simpson Dr.","Warrensburg","MO",64093,"(660) 747-8261","mis.survey@byu.edu "]
[133,"ARMAND","BERGERON","2 Rockwood Street","Rochester","NY",14610,"(585) 323-2020","sigsand@byu.edu"]
[134,"ARMAND","BERGERON","77 D Street","Johnstown","PA",15906,"(814) 535-7694","junk-mail@byu.edu "]
[135,"BRENNAN","BILLINGS","Hwy 152, West Landis","Landis","NC",28088,"(704) 857-9222","govena@byu.edu"]
[136,"BRENNAN","BILLINGS","3304 N. Central Ave.","Chicago","IL",60634,"(773) 282-3820","agent@byu.edu "]
[137,"DAWN","ROTH","4951-53 West Diversey Ave.","Chicago","IL",60639,"(773) 237-2919","isworld@byu.edu "]
[138,"SKIP","QUILLEN","126 12th Street","Brooklyn","NY",11215,"(718) 499-7821","isys520@byu.net "]
[139,"BILL","MCCULLOCH","5600 1st Avenue","Brooklyn","NY",11220,"(718) 499-7821","tjed@byu.edu"]
[140,"CHRISTINE","WALKER","7108 Gerald Ave.","Van Nuys","CA",91406,"(818) 994-8871","mis.survey@byu.edu "]
[141,"MIKE","THOMAS","122 Water Street","Quincy","MA",2169,"(617) 479-6360","sigsand@byu.edu"]
[142,"EDWARD","DEFRIAS","1138 4th Avenue South","Nashville","TN",37210,"(615) 356-7077","junk-mail@byu.edu "]
[143,"CHRIS","PETERSON","1616 S. Dean Road","Orlando","FL",32825,"(407) 277-9483","govena@byu.edu"]
[144,"JOSETTE","THOMAS","4501 S. 36th Street","Omaha","NE",68107,"(402) 734-6901","agent@byu.edu "]
[145,"JENNY","HAARALA","3737 S. Halsted Street","Chicago","IL",60609,"(773) 890-5100","isworld@byu.edu "]
[146,"CHESTER","CHILDERS","12041 Cordova Road","Cordova","MD","21625-2946","(410) 820-2100","isys520@byu.net "]
[147,"RENEE","ONSAGER","18752 Harbeson Road","Harbeson","DE",19951,"(302) 684-1640","tjed@byu.edu"]
[148,"CLARENCE","STEPHENS","125 Seneca Trail","Boyertown","PA",19512,null,"mis.survey@byu.edu "]
[149,"JACK","HILBURN","125 Seneca Trail","Boyertown","PA",19512,"(610) 367-2174","sigsand@byu.edu"]
[150,"THOMAS","KOZLIK","6201 Seaforth Street","Baltimore","MD",21224,"(410) 633-3200","junk-mail@byu.edu "]
[151,"BETH","HAMM","200 Turner Dr.","Rantoul","IL",61866,"(217) 892-2545","govena@byu.edu"]
[152,"MELISSA","MULWEE","1101 Northeast 23rd Street","Fort Worth","TX",76164,"(817) 546-0912","agent@byu.edu "]
[153,"RICHARD","MCBRAYER","2501 Broadway","Cheektowaga","NY",14227,"(716) 894-4000","isworld@byu.edu "]
[154,"NANCE","KNIGHT","25447 Industrial Blvd.","Hayward","CA",94545,"(510) 276-7700","isys520@byu.net "]
[155,"CLARICE","YOSKOWITZ","333 Clay St.","Oakland","CA",94607,"(510) 763-6200","tjed@byu.edu"]
[156,"DANNY","BARRICKMAN","1725 Pine Avenue","Vineland","NJ",8360,"(856) 507-1100","mis.survey@byu.edu "]
[157,"BLEN","FLOWE","216 NE 12th Street, Suite B","Moore","OK",73160,"(405) 794-2530","sigsand@byu.edu"]
[158,"ROBINSON","BAKER","110 East 1st Street","Alma","KS",66401,"(785) 765-3396","junk-mail@byu.edu "]
[159,"LORRAINE","WILLARD","1724 W. Monroe Road","St Louis","MI",48880,"(989) 681-3733","govena@byu.edu"]
[160,"FRANKLIN","ROSS","2433 1/2 Cesar Chavez Ave.","Los Angeles","CA",90033,"(323) 268-5030","agent@byu.edu "]
[161,"MARCUS","OBIE","113 S. County Road","Alma","MO",64001,"(660) 674-2231","isworld@byu.edu "]
[162,"CAROL","SCHULER","100 North County Road","Alma","MO",64001,"(660) 674-2231","isys520@byu.net "]
[163,"ROBERT","THORNBER","9910 Teal Avenue","San Antonio","TX",78224,"(210) 226-5029","tjed@byu.edu"]
[164,"JENNI","ELVIS","670 East Cherry Road","Quakertown","PA",18951,"(215) 536-6050","mis.survey@byu.edu "]
[165,"MELVIN","BASS","5419 Mascher Street","Philadelphia","PA",19120,"(215) 224-2212","sigsand@byu.edu"]
[166,"GERALD","DAVIS","301 Fairmont St.","Norcross","GA",30071,"(678) 421-0119","junk-mail@byu.edu "]
[167,"JUANITA","GONZALEZ","417 Atlas Avenue","Madison","WI",53714,"(608) 224-1481","govena@byu.edu"]
[168,"ROBERT","HANDY","2302 US 301 South","Dunn","NC",28334,"(910) 892-8751","agent@byu.edu "]
[169,"JACK","RUPERT","9900 Lower Sacramento Rd.","Stockton","CA",95210,"(209) 477-2691","isworld@byu.edu "]
[170,"JAN","MATTHEWS","1272 W. Alaska Place","Denver","CO",80223,"(303) 778-0886","isys520@byu.net "]
[171,"PATRICIA","COMBER","2800 Indian School Rd. N.E.","Albuquerque","NM",87106,"(505) 266-2853","tjed@byu.edu"]
[172,"RICK","THOMAS","1952 Wartrace Pike","Shelbyville","TN",37160,"(931) 684-4191","mis.survey@byu.edu "]
[173,"DAVE","HEGER","1915 N. Broadway","Los Angeles","CA",90031,"(323) 223-3855","sigsand@byu.edu"]
[174,"FAITH","MORIN","303 Lowe Street","Alta Vista","KS",66834,"(785) 499-6829","junk-mail@byu.edu "]
[175,"EVARISTO","ELIAS","301 Raynolds St.","El Paso","TX","79905-1611","(915) 534-2586","govena@byu.edu"]
[176,"DANA","COOK","703 E. War Memorial Dr.","Peoria Heights","IL",61624,"(309) 688-8711","agent@byu.edu "]
[177,"LARISA","GALPERINA","4513 F Street","Amana","IA",52203,"(319) 622-7580","isworld@byu.edu "]
[178,"LAURA","FOLTS","735 Fremont Ave","San Leandro","CA",94577,"(510) 351-0841","isys520@byu.net "]
[179,"JOYCE","KACZYNSKI","2180 NW 19th Ave","Miami","FL",33142,"(305) 324-7471","tjed@byu.edu"]
[180,"JEANNE","CRISTIANO","2105 Hammond Dr.","Schaumburg","IL",60173,"(847) 303-1144","mis.survey@byu.edu "]
[181,"PATRICIA","HAINES","6863 N.E. 3rd. Ave.","Miami","FL",33138,"(305) 754-0001","sigsand@byu.edu"]
[182,"LOIS","WATTS","2856 Guinotte","Kansas City","MO",64120,"(816) 483-6350","junk-mail@byu.edu "]
[183,"GABRIELLE","PHIFER","3131 S. Canal Street","Chicago","IL",60616,"(312) 842-3224","govena@byu.edu"]
[184,"SUE","CARLTON","410 SE 18th St.","Des Moines","IA","50317-7619","(515) 265-1618","agent@byu.edu "]
[185,"SHERI","AMAN","13677 Yorba Ave.","Chino","CA",91710,"(909) 628-4888","isworld@byu.edu "]
[186,"MAGIN","GARCIA","15501 SE Piazza Ave","Clackamas","OR",97015,"(503) 656-6400","isys520@byu.net "]
[187,"JOSEPH","HART","100 Lee St","Jackson","TN",38301,"(731) 422-7100","tjed@byu.edu"]
[188,"ROBERT","BIENAMANN","965 Mullins St.","Humboldt","TN",38343,"(731) 784-7130","mis.survey@byu.edu "]
[189,"CLAUDE","AUTREY","607 Industry Rd","Louisville","KY",40208,"(502) 634-4753","sigsand@byu.edu"]
[190,"JULIE","ROEDER-MARSH","420 S. 145 E. Ave","Tulsa","OK",74108,"(918) 949-3750","junk-mail@byu.edu "]
[191,"NATALEO","ALEMAN","888 American Way","Boonville","IN",47601,"(812) 897-4713","govena@byu.edu"]
[192,"BOB","ROERDINK","12805 NW 42 Avenue","Opa-Locka","FL",33054,"(305) 769-2112","agent@byu.edu "]
[193,"GEORGE","ROEMER","375 Pierce Industrial Blvd","Blackshear","GA",31516,"(912) 449-5700","isworld@byu.edu "]
[194,"GREG","DIAL","374 E. 167th St.","Harvey","IL",60426,"(708) 331-1982","isys520@byu.net "]
[195,"LORY","DANSKY","450 Metuchen Road","South Plainfield","NJ",7080,"(908) 754-1300","tjed@byu.edu"]
[196,"RICKY","SPEAGLE","5201 Industry Ave.","Pico Rivera","CA",90660,"(562) 801-4100","mis.survey@byu.edu "]
[197,"RONALD","RUCHALSKI","2991 Mead Ave.","Santa Clara","CA",95051,"(408) 986-0588","sigsand@byu.edu"]
[198,"ALBERT","MULWEE","6005 Golden Valley Road","Golden Valley","MN",55422,"(763) 746-8414","junk-mail@byu.edu "]
[199,"DAVID","MARKS","3120 Avenue E","Arlington","TX",76011,"(817) 652-1315","govena@byu.edu"]
[200,"DAMIAN","GARNEAU","30 B Street","Burlington","MA",1803,"(781) 273-3230","agent@byu.edu "]
[201,"Sujan","Panta","1269 N riverside Ave","provo","UT",84604,8014727681,"panta.sujan@gmail.com"]

{"sheet":"Purchase Order","index":3,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Date","P.O. No.","First Name","Last Name","Phone No.","Product Segment","Product ","Quantity","Back Order","Shipment Date","Status"]
["11/9/2011 10:52:20 AM",11250,"RONNIE","PRUETT","(731) 967-1411","Specialty Bars/Life Style Chocolate Bars","Biker Bar Milk",10,0,null,"Email Sent"]
["11/9/2011 10:53:53 AM",11251,"ANGELO","CAMARANO","(903) 629-3856","Specialty Bars/Life Style Chocolate Bars","Golf Lover Milk",12,0,null,"Email Sent"]
["11/9/2011 10:53:53 AM",11251,"ANGELO","CAMARANO","(903) 629-3856","State Shape Bar","California",25,0,null,"Email Sent"]
["11/9/2011 10:53:53 AM",11251,"ANGELO","CAMARANO","(903) 629-3856","Specialty Bars/Hawaiian Chocolate","Hava Kava Coconut Ginger",5,0,null,"Email Sent"]
["11/9/2011 11:22:12 AM",11252,"ROBERT","ZASTEMPOWSKI","(419) 358-2926","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",10,0,null,"Email Sent"]
["11/9/2011 11:22:12 AM",11252,"ROBERT","ZASTEMPOWSKI","(419) 358-2926","Organic Chocolate Bars","Coconut Almond Creme Milk",0,10,null,"Email Sent"]
["11/9/2011 11:22:12 AM",11252,"ROBERT","ZASTEMPOWSKI","(419) 358-2926","Specialty Bars/OmniPeace","Peace of Chocolate-Raspberry",10,0,null,"Email Sent"]
["11/9/2011 11:22:12 AM",11253,"NORMA","BENDER","(718) 271-8228","Specialty Bars/Hawaiian Chocolate","Hava Kava Coconut Ginger",10,0,"2011-11-10","Email Sent"]
["11/9/2011 11:23:47 AM",11253,"NORMA","BENDER","(718) 271-8228","Organic Chocolate Bars","Coconut Almond Creme Milk",0,10,"2011-11-10","Email Sent"]
["11/9/2011 11:23:47 AM",11253,"NORMA","BENDER","(718) 271-8228","Organic Chocolate Bars","Crystallized Ginger Dark",12,0,"2011-11-10","Email Sent"]
["11/9/2011 11:29:09 AM",11254,"NORMA","BENDER","(718) 271-8228","HuckleBerry Products","Rocky Mountain Gournment HuckleBerry",0,12,null,"Email Sent"]
["11/9/2011 11:29:09 AM",11254,"NORMA","BENDER","(718) 271-8228","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",10,0,null,"Email Sent"]
["11/9/2011 11:29:09 AM",11254,"NORMA","BENDER","(718) 271-8228","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",10,0,null,"Email Sent"]
["11/9/2011 11:37:51 AM",11255,"LLOYD","HARE","(213) 763-8500","Organic Chocolate Bars","Caramel Creme Latte Milk",0,10,null,"Email Sent"]
["11/9/2011 11:37:51 AM",11255,"LLOYD","HARE","(213) 763-8500","Organic Chocolate Bars","Crystallized Ginger Dark",10,0,null,"Email Sent"]
["11/9/2011 11:37:51 AM",11255,"LLOYD","HARE","(213) 763-8500","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",10,0,null,"Email Sent"]
["11/9/2011 11:40:05 AM",11256,"Sujan","Panta",8014727681,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",10,0,null,"Email Sent"]
["11/9/2011 11:40:05 AM",11256,"Sujan","Panta",8014727681,"Specialty Bars/Hawaiian Chocolate","Hava Kava Pineapple Lime",10,0,null,"Email Sent"]
["11/9/2011 11:40:05 AM",11256,"Sujan","Panta",8014727681,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",5,0,null,"Email Sent"]
["11/9/2011 11:40:05 AM",11256,"Sujan","Panta",8014727681,"Specialty Bars/Life Style Chocolate Bars","Biker Bar Milk",0,10,null,"Email Sent"]
["11/9/2011 11:49:45 AM",11257,"DAVID","MARKS","(817) 652-1315","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",74,26,null,"Email Sent"]
["11/9/2011 3:29:30 PM",11258,"SUSAN","KISSLINGER","(313) 921-7710","HuckleBerry Products","HuckleBerry Dark",56,0,null,"Email Sent"]
["11/9/2011 9:44:05 PM",11259,"LEWIS","GELINAS","(734) 422-2060","Organic Chocolate Bars","Crystallized Ginger Dark",30,0,null,"Email Sent"]
["11/9/2011 9:56:47 PM",11260,"SUSAN","KISSLINGER","(313) 921-7710","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",0,10,null,"Email Sent"]
["11/10/2011 1:30:57 AM",11261,"ROBERT","ZASTEMPOWSKI","(419) 358-2926","Specialty Bars/Hawaiian Chocolate","Hava Kava Pineapple Lime",80,0,null,"Email Sent"]
["11/10/2011 1:30:57 AM",11261,"ROBERT","ZASTEMPOWSKI","(419) 358-2926","Specialty Bars/Life Style Chocolate Bars","Beach Lover Dark",50,0,null,"Email Sent"]
["11/10/2011 1:12:35 PM",11262,"MELISSA","MULWEE","(817) 546-0912","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",0,12,null,"Email Sent"]
["11/10/2011 1:12:35 PM",11262,"MELISSA","MULWEE","(817) 546-0912","Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",0,12,null,"Email Sent"]
["11/10/2011 1:12:35 PM",11262,"MELISSA","MULWEE","(817) 546-0912","Organic Chocolate Bars","Dark Lavender",20,0,null,"Email Sent"]
["11/10/2011 1:12:35 PM",11262,"MELISSA","MULWEE","(817) 546-0912","Specialty Bars/Life Style Chocolate Bars","Golf Lover Milk",10,0,null,"Email Sent"]

{"sheet":"Shipment","index":4,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Shipment No.","P.O.No","Customer ID","First Name","Last name","Shipping Address","City","State","Zip Code","Tracking No.","Status"]
[11358,11250,6,"RONNIE","PRUETT","19690 Hwy 412 E.","Lexington","TN",38351,null,"Not Shipped"]
[11359,11251,8,"ANGELO","CAMARANO","5428 Fm 69","Coke","TX",75431,null,"Not Shipped"]
[11360,11253,12,"NORMA","BENDER","53-42 98th Street","Corona","NY",11368,1.23455555555555E+16,"Shipped"]
[11361,11254,12,"NORMA","BENDER","53-42 98th Street","Corona","NY",11368,null,"Not Shipped"]
[11362,11255,18,"LLOYD","HARE","2939 Sunol Dr.","Vernon","CA",90023,null,"Not Shipped"]
[11363,11256,201,"Sujan","Panta","1269 N riverside Ave","provo","UT",84604,null,"Not Shipped"]
[11364,11257,199,"DAVID","MARKS","3120 Avenue E","Arlington","TX",76011,null,"Not Shipped"]
[11365,11258,2,"SUSAN","KISSLINGER","8800 Conant","Hamtramck","MI",48211,null,"Not Shipped"]
[11366,11259,16,"LEWIS","GELINAS","34165 Autry","Livonia","MI","48150-1333",null,"Not Shipped"]
[11367,11260,2,"SUSAN","KISSLINGER","8800 Conant","Hamtramck","MI",48211,null,"Not Shipped"]
[11368,11261,24,"ROBERT","ZASTEMPOWSKI","201 N Main Street","Bluffton","OH",45817,null,"Not Shipped"]
[11369,11262,152,"MELISSA","MULWEE","1101 Northeast 23rd Street","Fort Worth","TX",76164,null,"Not Shipped"]

{"sheet":"Back Order","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Back Order No.","Date","P.O No","Product Segment","Product Detail","Quantity"]
[1099,"11/9/2011 11:23:47 AM",11253,"Organic Chocolate Bars","Coconut Almond Creme Milk",10]
[1100,"11/9/2011 11:29:09 AM",11254,"HuckleBerry Products","Rocky Mountain Gournment HuckleBerry",12]
[1101,"11/9/2011 11:37:51 AM",11255,"Organic Chocolate Bars","Caramel Creme Latte Milk",10]
[1102,"11/9/2011 11:40:05 AM",11256,"Specialty Bars/Life Style Chocolate Bars","Biker Bar Milk",10]
[1103,"11/9/2011 11:49:45 AM",11257,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",26]
[1104,"11/10/2011 1:07:28 PM",11262,"Organic Chocolate Bars","Dark Mint",10]
[1104,"11/10/2011 1:07:28 PM",11262,"Organic Chocolate Bars","Caramel Creme Latte Milk",10]
[1105,"11/10/2011 1:12:35 PM",11262,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",12]
[1105,"11/10/2011 1:12:35 PM",11262,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",12]

{"sheet":"Individual P.O.","index":6,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,5,24,7],[25,5,25,7],[26,5,26,7],[28,5,28,7],[27,2,27,4],[27,5,27,7],[28,2,28,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[21,2,21,4],[22,2,22,4],[23,2,23,4],[20,2,20,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[11,1,11,4],[12,1,12,2],[14,2,14,4],[14,5,14,7],[11,7,11,9],[10,1,10,4],[1,1,2,9],[4,3,4,7],[8,2,8,4],[8,8,8,9],[6,8,6,9],[10,7,10,9]]}
[]
[null,"Dream Chocolate"]
[]
[]
[null,3,null,"Purchase Order"]
[]
[null,"P.O. #",11251,null,null,null,null,"Date","11/9/2011 10:53:53 AM"]
[]
[null,"Customer","ANGELO CAMARANO",null,null,null,null,"Phone Number","(903) 629-3856"]
[]
[null,"Billing Address",null,null,null,null,null,"Shipping Address"]
[null,"5428 Fm 69",null,null,null,null,null,"5428 Fm 69"]
[null,"Coke",null,"TX",75431,null,null,"Coke","TX",75431]
[]
[null,"S.No","Product Segment",null,null,"Product Detail",null,null,"Quantity","Back Order"]
[null,1,"Specialty Bars/Life Style Chocolate Bars",null,null,"Golf Lover Milk",null,null,12,0]
[null,2,"State Shape Bar",null,null,"California",null,null,25,0]
[null,3,"Specialty Bars/Hawaiian Chocolate",null,null,"Hava Kava Coconut Ginger",null,null,5,0]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[]
[null,null,"agent@byu.edu "]

{"sheet":"Back Order Report","index":7,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["S.No","Product Segment","Product Description","Quantity"]
[1,"Organic Chocolate Bars","Coconut Almond Creme Milk",10]
[2,"Organic Chocolate Bars","Caramel Creme Latte Milk",20]
[3,"HuckleBerry Products","Rocky Mountain Gournment HuckleBerry",32]
[4,"Specialty Bars/Hawaiian Chocolate","Hava Kava Mango Mint",58]
[5,"Specialty Bars/Life Style Chocolate Bars","Biker Bar Milk",68]

{"sheet":"test","index":8,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Specialty Bars/Life Style Chocolate Bars","Golf Lover Milk",12]
["State Shape Bar","California",25,null,"Hava Kava Coconut Ginger",5,"E4"]
["Specialty Bars/Hawaiian Chocolate","Hava Kava Coconut Ginger",5,null,"Golf Lover Milk",12,"F4"]
[null,null,null,null,"California",25,"H3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rocky Mountain Gournment HuckleBerry",0,"E2"]
["Hava Kava Mango Mint",10,"E5"]
["Hava Kava Mango Mint",10,"E5"]