{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Factories","Build Quote","Estimate","PO to Vendor","PO to Decorator","Customers","Blank Products","info","Lines","TREVFileNames","TREVJobToZoho","TREVPermanent","Line 1","Line 2","Line 3","Pacific Price List","Line 4","Line 5","Line 6","Line 7","Line 8","Line 9","Line 10","Line 11","Line 12","Line 13","Line 14","Line 15"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Factories","index":0,"n_rows":128,"n_cols":5,"rows_kept":128,"cut":false,"hidden":true,"merged":[]}
["Company","Address 1","Address 2","Email","Phone"]
["Not Yet Assigned","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["None","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Screen Printers, Inc","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Vendors Unite","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Acme, inc.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Widget Corp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["123 Warehousing","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Demo Company","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Smith and Co.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Foo Bars","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["ABC Telecom","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Fake Brothers","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["QWERTY Logistics","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Demo, inc.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sample Company","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sample, inc","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Acme Corp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Allied Biscuit","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Ankh-Sto Associates","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Extensive Enterprise","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Galaxy Corp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Globo-Chem","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Mr. Sparkle","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Globex Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["LexCorp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["LuthorCorp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["North Central Positronics","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Omni Consimer Products","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Praxis Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sombra Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sto Plains Holdings","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Tessier-Ashpool","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Wayne Enterprises","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Wentworth Industries","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["ZiffCorp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Bluth Company","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Strickland Propane","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Thatherton Fuels","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Three Waters","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Water and Power","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Western Gas & Electric","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Mammoth Pictures","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Mooby Corp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Gringotts","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Thrift Bank","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Flowers By Irene","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["The Legitimate Businessmens Club","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Osato Chemicals","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Transworld Consortium","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Universal Export","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["United Fried Chicken","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Virtucon","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Kumatsu Motors","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Keedsler Motors","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Powell Motors","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Industrial Automation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sirius Cybernetics Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["U.S. Robotics and Mechanical Men","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Colonial Movers","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Corellian Engineering Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Incom Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["General Products","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Leeding Engines Ltd.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Blammo","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Input, Inc.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Mainway Toys","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Videlectrix","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Zevo Toys","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Ajax","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Axis Chemical Co.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Barrytron","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Carrys Candles","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Cogswell Cogs","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Spacely Sprockets","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["General Forge and Foundry","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Duff Brewing Company","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Dunder Mifflin","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["General Services Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Monarch Playing Card Co.","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Krustyco","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Initech","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Roboto Industries","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Primatech","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sonky Rubber Goods","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["St. Anky Beer","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Stay Puft Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Vandelay Industries","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Wernham Hogg","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Gadgetron","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Burleigh and Stronginthearm","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["BLAND Corporation","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Nordyne Defense Dynamics","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Petrox Oil Company","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Roxxon","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["McMahon and Tate","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Sixty Second Avenue","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Charles Townsend Agency","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Spade and Archer","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Megadodo Publications","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Rouster and Sideways","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["C.H. Lavatory and Sons","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Globo Gym American Corp","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["The New Firm","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["SpringShield","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Compuglobalhypermeganet","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Data Systems","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Gizmonic Institute","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Initrode","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Taggart Transcontinental","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Atlantic Northern","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Niagular","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Plow King","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Big Kahuna Burger","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Big T Burgers and Fries","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Chez Quis","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Chotchkies","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["The Frying Dutchman","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Klimpys","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["The Krusty Krab","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Monks Diner","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Milliways","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Minuteman Cafe","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Taco Grande","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Tip Top Cafe","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Moes Tavern","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Central Perk","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]
["Chasers","123 not a real street","irvine, ca 92671","fakeemail@gmail.com",9495551234]

{"sheet":"Build Quote","index":1,"n_rows":137,"n_cols":41,"rows_kept":137,"cut":false,"hidden":false,"merged":[[113,11,113,14],[114,11,114,14],[111,20,111,21],[115,20,115,21],[115,7,115,10],[112,20,112,21],[113,20,113,21],[112,7,114,10],[114,20,114,21],[111,7,111,10],[111,11,111,14],[120,1,121,1],[120,24,121,24],[120,19,121,19],[120,20,121,20],[120,21,121,21],[120,22,121,22],[120,23,121,23],[112,40,113,41],[120,2,121,2],[120,3,121,3],[117,20,117,26],[120,5,120,13],[120,14,121,14],[120,15,121,15],[120,16,121,16],[120,4,121,4],[114,1,114,5],[115,1,115,5],[117,7,117,10],[116,7,116,10],[115,11,115,14],[120,25,121,25],[112,11,112,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"95 Markets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Road Bike 4 U"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aerofit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agua Dulce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Mountain Trail Riders"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"American Diabetes Association"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baghouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bicycle.net"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Rock"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bike Works Hawaii"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boostability"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brian Forbes - Customer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broken Spoke"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carter West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CB Marketing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Center For Discovery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Christensen & Hymas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Care to Stay Home"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dale Gordon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Damion Hickman Designs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E360"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El Toro HS MTB Team"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empire Bikes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Epic Endings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estate Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foothill Knight High School"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G2 Bikes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glistening Perfection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Helen's Cycles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hensel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hero Ride"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Human Options"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ignite"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insight Investments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irwin Cycles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jim Bishop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanne Russell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KOM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kristen Powell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labeltronics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laguna Hills HS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long Beach Cyclery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marathon Pain Relief"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maryanne - Baghouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matt's Munchies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mazzo Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mike Delange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MJC Engineering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mouse Trap Trucks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My FAC Team"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My Soxy Feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Myogenix"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mystic Motel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nittany Lions MTB Team"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Dot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oso Loco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Over the Hump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paragon Cycling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Park City Ortho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedal Industries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedal Retail Items"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PersonalizeDx"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predixion Software"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Image"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PSB Integrated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PureFit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radsport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Randy Rogers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rapid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rapid Cycling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rausch PT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Monkey Sports"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Mountain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Whale Coffee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Relampago"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ride Like A Ninja"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock N Road"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock Sports"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Juan Hill HS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAW Sports"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sea Cycle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shimano"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skinfit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Socal Endurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stan Chien DDS Inc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surf City Cyclery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team FC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team Rwanda Cycling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Path"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ThinkASG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trabuco Hills HS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trail Angels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two Hubs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velosport Club"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velosport Jrs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velosport U23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velovie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Emulsions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Win Team Racing"]
[null,null,null,null,null,null,null,"Custom Quote for:",null,null,null,null,null,null,null,"Job Number:",{"$f":"TREVFileNames!B2","v":25006},null,null,null,"Vendor Cost",null,{"$f":"SUM(O123:O137*U123:U137)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ready to Save?"]
[null,null,null,null,null,null,null,"Ship To Address:",null,null,null,{"$f":"IFERROR(IF(VLOOKUP($L$112,Customers!$A$2:D$200,2,FALSE)=\"\",\"\",VLOOKUP(L112,Customers!$A$2:$D$200,2,FALSE)),\"\")","v":""},null,null,null,"InHands Date:",null,null,null,null,"Decorator Cost",null,{"$f":"SUM(O123:O137*V123:V137)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L112=\"\",\"NO\",IF(L116=\"\",\"NO\",IF(L117=\"\",\"NO\",IF(Q113=\"\",\"NO\",IF(Q114=\"\",\"NO\",IF(O120=\"\",\"NO\",IF(L118=\"\",\"NO\",IF(#REF!=\"\",\"NO\",IF(AA113=\"\",\"NO\",\"Good\")))))))))","v":"NO"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($L$112,Customers!$A$2:D$200,3,FALSE)=\"\",\"\",VLOOKUP($L$112,Customers!$A$2:$D$200,3,FALSE)),\"\")","v":""},null,null,null,"Quoted by:",null,null,null,null,"Total Cost",null,{"$f":"W113+W112","v":0}]
[null,"26080 Towne Centre Drive | Foothill Ranch  CA  92610",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($L$112,Customers!$A$2:D$200,3,FALSE)=\"\",\"\",CONCATENATE(VLOOKUP($L$112,Customers!$A$2:$F$200,4,FALSE)&\", \"&VLOOKUP($L$112,Customers!$A$2:$F$200,5,FALSE)&\" \"&VLOOKUP($L$112,Customers!$A$2:$F$200,6,FALSE))),\"\")","v":""},null,null,null,"Terms:",null,null,null,null,"Total Revenue",null,{"$f":"SUM(Q123:Q137)","v":0}]
[null,"888-308-0005",null,null,null,null,null,"Contact:",null,null,null,null,null,null,null,"Resale:",null,null,null,null,"Estimated Profit",null,{"$f":"W115-W114","v":0}]
[null,null,null,null,null,null,null,"Est. Production Time",null,null,null,5,"days",null,null,"Bag & Fold:"]
[null,null,null,null,null,null,null,"Est Ship Time:",null,null,null,2,"days",null,null,"Project Name:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor","Decorator"]
[]
[null,"Item #","Blank Color","Style Name","Imprint Color","Sizing",null,null,null,null,null,null,null,null,"Qty","Price","Ext. Price",null,null,"Qty","Cost","Runcharge","TtlCst","Ext. Cost","Profit","Margin"]
[null,null,null,null,null,"xxs","xs","s","m","l","xl","xxl","xxxl","xxxxl"]
[1,{"$f":"IF(Lines!D10=0,\"\",Lines!D10)","v":""},{"$f":"IF(Lines!L10=0,\"\",Lines!L10)","v":""},{"$f":"IF(Lines!H10=0,\"\",Lines!H10)","v":""},{"$f":"IF(Lines!Z10=0,\"\",Lines!Z10)","v":""},{"$f":"IF(Lines!M10=0,\"\",Lines!M10)","v":""},{"$f":"IF(Lines!N10=0,\"\",Lines!N10)","v":""},{"$f":"IF(Lines!O10=0,\"\",Lines!O10)","v":""},{"$f":"IF(Lines!P10=0,\"\",Lines!P10)","v":""},{"$f":"IF(Lines!Q10=0,\"\",Lines!Q10)","v":""},{"$f":"IF(Lines!R10=0,\"\",Lines!R10)","v":""},{"$f":"IF(Lines!S10=0,\"\",Lines!S10)","v":""},{"$f":"IF(Lines!T10=0,\"\",Lines!T10)","v":""},{"$f":"IF(Lines!U10=0,\"\",Lines!U10)","v":""},{"$f":"SUM(F123:N123)","v":0},{"$f":"ROUND(W123/(1-Z123),2)","v":0},{"$f":"P123*O123","v":0},null,null,{"$f":"O123","v":0},{"$f":"Lines!E10","v":0},{"$f":"Lines!G10","v":0},{"$f":"U123+V123","v":0},{"$f":"W123*T123","v":0},{"$f":"Q123-X123","v":0},{"$f":"Lines!K10","v":0.4}]
[2,{"$f":"IF(Lines!D11=0,\"\",Lines!D11)","v":""},{"$f":"IF(Lines!L11=0,\"\",Lines!L11)","v":""},{"$f":"IF(Lines!H11=0,\"\",Lines!H11)","v":""},{"$f":"IF(Lines!Z11=0,\"\",Lines!Z11)","v":""},{"$f":"IF(Lines!M11=0,\"\",Lines!M11)","v":""},{"$f":"IF(Lines!N11=0,\"\",Lines!N11)","v":""},{"$f":"IF(Lines!O11=0,\"\",Lines!O11)","v":""},{"$f":"IF(Lines!P11=0,\"\",Lines!P11)","v":""},{"$f":"IF(Lines!Q11=0,\"\",Lines!Q11)","v":""},{"$f":"IF(Lines!R11=0,\"\",Lines!R11)","v":""},{"$f":"IF(Lines!S11=0,\"\",Lines!S11)","v":""},{"$f":"IF(Lines!T11=0,\"\",Lines!T11)","v":""},{"$f":"IF(Lines!U11=0,\"\",Lines!U11)","v":""},0,0,0,null,null,{"$f":"O124","v":0},{"$f":"Lines!E11","v":0},{"$f":"Lines!G11","v":0},0,0,0,{"$f":"Lines!K11","v":0.4}]
[3,{"$f":"IF(Lines!D12=0,\"\",Lines!D12)","v":""},{"$f":"IF(Lines!L12=0,\"\",Lines!L12)","v":""},{"$f":"IF(Lines!H12=0,\"\",Lines!H12)","v":""},{"$f":"IF(Lines!Z12=0,\"\",Lines!Z12)","v":""},{"$f":"IF(Lines!M12=0,\"\",Lines!M12)","v":""},{"$f":"IF(Lines!N12=0,\"\",Lines!N12)","v":""},{"$f":"IF(Lines!O12=0,\"\",Lines!O12)","v":""},{"$f":"IF(Lines!P12=0,\"\",Lines!P12)","v":""},{"$f":"IF(Lines!Q12=0,\"\",Lines!Q12)","v":""},{"$f":"IF(Lines!R12=0,\"\",Lines!R12)","v":""},{"$f":"IF(Lines!S12=0,\"\",Lines!S12)","v":""},{"$f":"IF(Lines!T12=0,\"\",Lines!T12)","v":""},{"$f":"IF(Lines!U12=0,\"\",Lines!U12)","v":""},0,0,0,null,null,{"$f":"O125","v":0},{"$f":"Lines!E12","v":0},{"$f":"Lines!G12","v":0},0,0,0,{"$f":"Lines!K12","v":0.4}]
[4,{"$f":"IF(Lines!D13=0,\"\",Lines!D13)","v":""},{"$f":"IF(Lines!L13=0,\"\",Lines!L13)","v":""},{"$f":"IF(Lines!H13=0,\"\",Lines!H13)","v":""},{"$f":"IF(Lines!Z13=0,\"\",Lines!Z13)","v":""},{"$f":"IF(Lines!M13=0,\"\",Lines!M13)","v":""},{"$f":"IF(Lines!N13=0,\"\",Lines!N13)","v":""},{"$f":"IF(Lines!O13=0,\"\",Lines!O13)","v":""},{"$f":"IF(Lines!P13=0,\"\",Lines!P13)","v":""},{"$f":"IF(Lines!Q13=0,\"\",Lines!Q13)","v":""},{"$f":"IF(Lines!R13=0,\"\",Lines!R13)","v":""},{"$f":"IF(Lines!S13=0,\"\",Lines!S13)","v":""},{"$f":"IF(Lines!T13=0,\"\",Lines!T13)","v":""},{"$f":"IF(Lines!U13=0,\"\",Lines!U13)","v":""},0,0,0,null,null,{"$f":"O126","v":0},{"$f":"Lines!E13","v":0},{"$f":"Lines!G13","v":0},0,0,0,{"$f":"Lines!K13","v":0.4}]
[5,{"$f":"IF(Lines!D14=0,\"\",Lines!D14)","v":""},{"$f":"IF(Lines!L14=0,\"\",Lines!L14)","v":""},{"$f":"IF(Lines!H14=0,\"\",Lines!H14)","v":""},{"$f":"IF(Lines!Z14=0,\"\",Lines!Z14)","v":""},{"$f":"IF(Lines!M14=0,\"\",Lines!M14)","v":""},{"$f":"IF(Lines!N14=0,\"\",Lines!N14)","v":""},{"$f":"IF(Lines!O14=0,\"\",Lines!O14)","v":""},{"$f":"IF(Lines!P14=0,\"\",Lines!P14)","v":""},{"$f":"IF(Lines!Q14=0,\"\",Lines!Q14)","v":""},{"$f":"IF(Lines!R14=0,\"\",Lines!R14)","v":""},{"$f":"IF(Lines!S14=0,\"\",Lines!S14)","v":""},{"$f":"IF(Lines!T14=0,\"\",Lines!T14)","v":""},{"$f":"IF(Lines!U14=0,\"\",Lines!U14)","v":""},0,0,0,null,null,{"$f":"O127","v":0},{"$f":"Lines!E14","v":0},{"$f":"Lines!G14","v":0},0,0,0,{"$f":"Lines!K14","v":0.4}]
[6,{"$f":"IF(Lines!D15=0,\"\",Lines!D15)","v":""},{"$f":"IF(Lines!L15=0,\"\",Lines!L15)","v":""},{"$f":"IF(Lines!H15=0,\"\",Lines!H15)","v":""},{"$f":"IF(Lines!Z15=0,\"\",Lines!Z15)","v":""},{"$f":"IF(Lines!M15=0,\"\",Lines!M15)","v":""},{"$f":"IF(Lines!N15=0,\"\",Lines!N15)","v":""},{"$f":"IF(Lines!O15=0,\"\",Lines!O15)","v":""},{"$f":"IF(Lines!P15=0,\"\",Lines!P15)","v":""},{"$f":"IF(Lines!Q15=0,\"\",Lines!Q15)","v":""},{"$f":"IF(Lines!R15=0,\"\",Lines!R15)","v":""},{"$f":"IF(Lines!S15=0,\"\",Lines!S15)","v":""},{"$f":"IF(Lines!T15=0,\"\",Lines!T15)","v":""},{"$f":"IF(Lines!U15=0,\"\",Lines!U15)","v":""},0,0,0,null,null,0,{"$f":"Lines!E15","v":0},{"$f":"Lines!G15","v":0},0,0,0,{"$f":"Lines!K15","v":0.4}]
[7,{"$f":"IF(Lines!D16=0,\"\",Lines!D16)","v":""},{"$f":"IF(Lines!L16=0,\"\",Lines!L16)","v":""},{"$f":"IF(Lines!H16=0,\"\",Lines!H16)","v":""},{"$f":"IF(Lines!Z16=0,\"\",Lines!Z16)","v":""},{"$f":"IF(Lines!M16=0,\"\",Lines!M16)","v":""},{"$f":"IF(Lines!N16=0,\"\",Lines!N16)","v":""},{"$f":"IF(Lines!O16=0,\"\",Lines!O16)","v":""},{"$f":"IF(Lines!P16=0,\"\",Lines!P16)","v":""},{"$f":"IF(Lines!Q16=0,\"\",Lines!Q16)","v":""},{"$f":"IF(Lines!R16=0,\"\",Lines!R16)","v":""},{"$f":"IF(Lines!S16=0,\"\",Lines!S16)","v":""},{"$f":"IF(Lines!T16=0,\"\",Lines!T16)","v":""},{"$f":"IF(Lines!U16=0,\"\",Lines!U16)","v":""},0,0,0,null,null,0,{"$f":"Lines!E16","v":0},{"$f":"Lines!G16","v":0},0,0,0,{"$f":"Lines!K16","v":0.4}]
[8,{"$f":"IF(Lines!D17=0,\"\",Lines!D17)","v":""},{"$f":"IF(Lines!L17=0,\"\",Lines!L17)","v":""},{"$f":"IF(Lines!H17=0,\"\",Lines!H17)","v":""},{"$f":"IF(Lines!Z17=0,\"\",Lines!Z17)","v":""},{"$f":"IF(Lines!M17=0,\"\",Lines!M17)","v":""},{"$f":"IF(Lines!N17=0,\"\",Lines!N17)","v":""},{"$f":"IF(Lines!O17=0,\"\",Lines!O17)","v":""},{"$f":"IF(Lines!P17=0,\"\",Lines!P17)","v":""},{"$f":"IF(Lines!Q17=0,\"\",Lines!Q17)","v":""},{"$f":"IF(Lines!R17=0,\"\",Lines!R17)","v":""},{"$f":"IF(Lines!S17=0,\"\",Lines!S17)","v":""},{"$f":"IF(Lines!T17=0,\"\",Lines!T17)","v":""},{"$f":"IF(Lines!U17=0,\"\",Lines!U17)","v":""},0,0,0,null,null,0,{"$f":"Lines!E17","v":0},{"$f":"Lines!G17","v":0},0,0,0,{"$f":"Lines!K17","v":0.4}]
[9,{"$f":"IF(Lines!D18=0,\"\",Lines!D18)","v":""},{"$f":"IF(Lines!L18=0,\"\",Lines!L18)","v":""},{"$f":"IF(Lines!H18=0,\"\",Lines!H18)","v":""},{"$f":"IF(Lines!Z18=0,\"\",Lines!Z18)","v":""},{"$f":"IF(Lines!M18=0,\"\",Lines!M18)","v":""},{"$f":"IF(Lines!N18=0,\"\",Lines!N18)","v":""},{"$f":"IF(Lines!O18=0,\"\",Lines!O18)","v":""},{"$f":"IF(Lines!P18=0,\"\",Lines!P18)","v":""},{"$f":"IF(Lines!Q18=0,\"\",Lines!Q18)","v":""},{"$f":"IF(Lines!R18=0,\"\",Lines!R18)","v":""},{"$f":"IF(Lines!S18=0,\"\",Lines!S18)","v":""},{"$f":"IF(Lines!T18=0,\"\",Lines!T18)","v":""},{"$f":"IF(Lines!U18=0,\"\",Lines!U18)","v":""},0,0,0,null,null,0,{"$f":"Lines!E18","v":0},{"$f":"Lines!G18","v":0},0,0,0,{"$f":"Lines!K18","v":0.4}]
[10,{"$f":"IF(Lines!D19=0,\"\",Lines!D19)","v":""},{"$f":"IF(Lines!L19=0,\"\",Lines!L19)","v":""},{"$f":"IF(Lines!H19=0,\"\",Lines!H19)","v":""},{"$f":"IF(Lines!Z19=0,\"\",Lines!Z19)","v":""},{"$f":"IF(Lines!M19=0,\"\",Lines!M19)","v":""},{"$f":"IF(Lines!N19=0,\"\",Lines!N19)","v":""},{"$f":"IF(Lines!O19=0,\"\",Lines!O19)","v":""},{"$f":"IF(Lines!P19=0,\"\",Lines!P19)","v":""},{"$f":"IF(Lines!Q19=0,\"\",Lines!Q19)","v":""},{"$f":"IF(Lines!R19=0,\"\",Lines!R19)","v":""},{"$f":"IF(Lines!S19=0,\"\",Lines!S19)","v":""},{"$f":"IF(Lines!T19=0,\"\",Lines!T19)","v":""},{"$f":"IF(Lines!U19=0,\"\",Lines!U19)","v":""},0,0,0,null,null,0,{"$f":"Lines!E19","v":0},{"$f":"Lines!G19","v":0},0,0,0,{"$f":"Lines!K19","v":0.4}]
[11,{"$f":"IF(Lines!D20=0,\"\",Lines!D20)","v":""},{"$f":"IF(Lines!L20=0,\"\",Lines!L20)","v":""},{"$f":"IF(Lines!H20=0,\"\",Lines!H20)","v":""},{"$f":"IF(Lines!Z20=0,\"\",Lines!Z20)","v":""},{"$f":"IF(Lines!M20=0,\"\",Lines!M20)","v":""},{"$f":"IF(Lines!N20=0,\"\",Lines!N20)","v":""},{"$f":"IF(Lines!O20=0,\"\",Lines!O20)","v":""},{"$f":"IF(Lines!P20=0,\"\",Lines!P20)","v":""},{"$f":"IF(Lines!Q20=0,\"\",Lines!Q20)","v":""},{"$f":"IF(Lines!R20=0,\"\",Lines!R20)","v":""},{"$f":"IF(Lines!S20=0,\"\",Lines!S20)","v":""},{"$f":"IF(Lines!T20=0,\"\",Lines!T20)","v":""},{"$f":"IF(Lines!U20=0,\"\",Lines!U20)","v":""},0,0,0,null,null,0,{"$f":"Lines!E20","v":0},{"$f":"Lines!G20","v":0},0,0,0,{"$f":"Lines!K20","v":0.4}]
[12,{"$f":"IF(Lines!D21=0,\"\",Lines!D21)","v":""},{"$f":"IF(Lines!L21=0,\"\",Lines!L21)","v":""},{"$f":"IF(Lines!H21=0,\"\",Lines!H21)","v":""},{"$f":"IF(Lines!Z21=0,\"\",Lines!Z21)","v":""},{"$f":"IF(Lines!M21=0,\"\",Lines!M21)","v":""},{"$f":"IF(Lines!N21=0,\"\",Lines!N21)","v":""},{"$f":"IF(Lines!O21=0,\"\",Lines!O21)","v":""},{"$f":"IF(Lines!P21=0,\"\",Lines!P21)","v":""},{"$f":"IF(Lines!Q21=0,\"\",Lines!Q21)","v":""},{"$f":"IF(Lines!R21=0,\"\",Lines!R21)","v":""},{"$f":"IF(Lines!S21=0,\"\",Lines!S21)","v":""},{"$f":"IF(Lines!T21=0,\"\",Lines!T21)","v":""},{"$f":"IF(Lines!U21=0,\"\",Lines!U21)","v":""},0,0,0,null,null,{"$f":"O134","v":0},{"$f":"Lines!E21","v":0},{"$f":"Lines!G21","v":0},0,0,0,{"$f":"Lines!K21","v":0.4},null,"`"]
[13,{"$f":"IF(Lines!D22=0,\"\",Lines!D22)","v":""},{"$f":"IF(Lines!L22=0,\"\",Lines!L22)","v":""},{"$f":"IF(Lines!H22=0,\"\",Lines!H22)","v":""},{"$f":"IF(Lines!Z22=0,\"\",Lines!Z22)","v":""},{"$f":"IF(Lines!M22=0,\"\",Lines!M22)","v":""},{"$f":"IF(Lines!N22=0,\"\",Lines!N22)","v":""},{"$f":"IF(Lines!O22=0,\"\",Lines!O22)","v":""},{"$f":"IF(Lines!P22=0,\"\",Lines!P22)","v":""},{"$f":"IF(Lines!Q22=0,\"\",Lines!Q22)","v":""},{"$f":"IF(Lines!R22=0,\"\",Lines!R22)","v":""},{"$f":"IF(Lines!S22=0,\"\",Lines!S22)","v":""},{"$f":"IF(Lines!T22=0,\"\",Lines!T22)","v":""},{"$f":"IF(Lines!U22=0,\"\",Lines!U22)","v":""},0,0,0,null,null,{"$f":"O135","v":0},{"$f":"Lines!E22","v":0},{"$f":"Lines!G22","v":0},0,0,0,{"$f":"Lines!K22","v":0.4}]
[14,{"$f":"IF(Lines!D23=0,\"\",Lines!D23)","v":""},{"$f":"IF(Lines!L23=0,\"\",Lines!L23)","v":""},{"$f":"IF(Lines!H23=0,\"\",Lines!H23)","v":""},{"$f":"IF(Lines!Z23=0,\"\",Lines!Z23)","v":""},{"$f":"IF(Lines!M23=0,\"\",Lines!M23)","v":""},{"$f":"IF(Lines!N23=0,\"\",Lines!N23)","v":""},{"$f":"IF(Lines!O23=0,\"\",Lines!O23)","v":""},{"$f":"IF(Lines!P23=0,\"\",Lines!P23)","v":""},{"$f":"IF(Lines!Q23=0,\"\",Lines!Q23)","v":""},{"$f":"IF(Lines!R23=0,\"\",Lines!R23)","v":""},{"$f":"IF(Lines!S23=0,\"\",Lines!S23)","v":""},{"$f":"IF(Lines!T23=0,\"\",Lines!T23)","v":""},{"$f":"IF(Lines!U23=0,\"\",Lines!U23)","v":""},{"$f":"SUM(F136:N136)","v":0},0,0,null,null,{"$f":"O136","v":0},{"$f":"Lines!E23","v":0},{"$f":"Lines!G23","v":0},0,0,0,{"$f":"Lines!K23","v":0.4}]
[15,{"$f":"IF(Lines!D24=0,\"\",Lines!D24)","v":""},{"$f":"IF(Lines!L24=0,\"\",Lines!L24)","v":""},{"$f":"IF(Lines!H24=0,\"\",Lines!H24)","v":""},{"$f":"IF(Lines!Z24=0,\"\",Lines!Z24)","v":""},{"$f":"IF(Lines!M24=0,\"\",Lines!M24)","v":""},{"$f":"IF(Lines!N24=0,\"\",Lines!N24)","v":""},{"$f":"IF(Lines!O24=0,\"\",Lines!O24)","v":""},{"$f":"IF(Lines!P24=0,\"\",Lines!P24)","v":""},{"$f":"IF(Lines!Q24=0,\"\",Lines!Q24)","v":""},{"$f":"IF(Lines!R24=0,\"\",Lines!R24)","v":""},{"$f":"IF(Lines!S24=0,\"\",Lines!S24)","v":""},{"$f":"IF(Lines!T24=0,\"\",Lines!T24)","v":""},{"$f":"IF(Lines!U24=0,\"\",Lines!U24)","v":""},{"$f":"SUM(F137:N137)","v":0},0,0,null,null,{"$f":"O137","v":0},{"$f":"Lines!E24","v":0},{"$f":"Lines!G24","v":0},0,0,0,{"$f":"Lines!K24","v":0.4}]

{"sheet":"Estimate","index":2,"n_rows":165,"n_cols":9,"rows_kept":165,"cut":false,"hidden":false,"merged":[[29,1,29,5],[31,1,31,5],[32,0,32,5],[32,6,32,7],[27,1,27,5],[28,1,28,5],[30,1,30,5],[16,1,16,5],[13,2,13,3],[14,2,14,3],[15,1,15,5],[23,1,23,5],[13,5,13,8],[14,5,14,8],[25,1,25,5],[26,1,26,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[24,1,24,5],[10,0,10,3],[10,5,10,8],[11,0,11,3],[11,5,11,8],[12,0,12,3],[12,5,12,8],[0,6,2,8],[4,0,4,3],[5,0,5,3],[8,6,8,8],[9,0,9,3],[9,5,9,8],[8,0,8,3],[42,0,42,3],[42,5,42,8],[43,0,43,3],[43,5,43,8],[44,0,44,3],[44,5,44,8],[33,6,35,8],[37,0,37,3],[38,0,38,3],[41,0,41,3],[41,6,41,8],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[45,0,45,3],[45,5,45,8],[46,2,46,3],[46,5,46,8],[47,2,47,3],[47,5,47,8],[64,1,64,5],[65,0,65,5],[65,6,65,7],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,5],[62,1,62,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[75,0,75,3],[75,5,75,8],[76,0,76,3],[76,5,76,8],[77,0,77,3],[77,5,77,8],[66,6,68,8],[70,0,70,3],[71,0,71,3],[74,0,74,3],[74,6,74,8],[81,1,81,5],[82,1,82,5],[83,1,83,5],[84,1,84,5],[85,1,85,5],[78,0,78,3],[78,5,78,8],[79,2,79,3],[79,5,79,8],[80,2,80,3],[80,5,80,8],[91,1,91,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[95,1,95,5],[86,1,86,5],[87,1,87,5],[88,1,88,5],[89,1,89,5],[90,1,90,5],[104,0,104,3],[107,0,107,3],[107,6,107,8],[108,0,108,3],[108,5,108,8],[97,1,97,5],[98,0,98,5],[98,6,98,7],[99,6,101,8],[103,0,103,3],[112,2,112,3],[112,5,112,8],[113,2,113,3],[113,5,113,8],[114,1,114,5],[109,0,109,3],[109,5,109,8],[110,0,110,3],[110,5,110,8],[111,0,111,3],[111,5,111,8],[120,1,120,5],[121,1,121,5],[122,1,122,5],[123,1,123,5],[124,1,124,5],[115,1,115,5],[116,1,116,5],[117,1,117,5],[118,1,118,5],[119,1,119,5],[131,0,131,5],[131,6,131,7],[132,6,134,8],[136,0,136,3],[137,0,137,3],[125,1,125,5],[126,1,126,5],[127,1,127,5],[128,1,128,5],[130,1,130,5],[143,0,143,3],[143,5,143,8],[144,0,144,3],[144,5,144,8],[145,2,145,3],[145,5,145,8],[140,0,140,3],[140,6,140,8],[141,0,141,3],[141,5,141,8],[142,0,142,3],[142,5,142,8],[150,1,150,5],[151,1,151,5],[152,1,152,5],[153,1,153,5],[154,1,154,5],[146,2,146,3],[146,5,146,8],[147,1,147,5],[148,1,148,5],[149,1,149,5],[160,1,160,5],[161,1,161,5],[163,1,163,5],[164,0,164,5],[164,6,164,7],[155,1,155,5],[156,1,156,5],[157,1,157,5],[158,1,158,5],[159,1,159,5]]}
[null,null,null,null,null,null,"Estimate"]
[]
[]
[null,null,null,null,null,null,null,"Page:",1]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688"]
[]
[]
["Name/Ship-To Address"]
[{"$f":"IF('Build Quote'!L112=0,\"\",'Build Quote'!L112)","v":""}]
[{"$f":"IF(A10=\"\",\"\",'Build Quote'!L113)","v":""}]
[{"$f":"IF(A11=\"\",\"\",'Build Quote'!L114)","v":""}]
[{"$f":"IF(A12=\"\",\"\",'Build Quote'!L115)","v":""}]
["Date","Estimate #","In Hands Date",null,"Terms","Project"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!Q112","v":25006},{"$f":"'Build Quote'!Q113","v":"00:00:00"},null,{"$f":"IF('Build Quote'!Q115=\"\",\"\",'Build Quote'!Q115)","v":""},{"$f":"IF('Build Quote'!E116=\"\",\"\",'Build Quote'!E116)","v":""}]
["Item","Description",null,null,null,null,"Qty","Price","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G17=\"\",\"\",H17*G17)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Tax and Shipping Additional | Allow for 5% +/- in totals                                                                    + 3% convience fee for Credit Cards",null,null,null,null,null,"Total:",null,{"$f":"IF(I17=\"\",\"\",SUM(I17:I32))","v":""}]
[null,null,null,null,null,null,"Estimate"]
[]
[]
[null,null,null,null,null,null,null,"Page:",2]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688"]
[]
[]
["Name/Ship-To Address"]
[{"$f":"IF('Build Quote'!P141=0,\"\",'Build Quote'!P141)","v":""}]
[{"$f":"IF(A43=\"\",\"\",'Build Quote'!P142)","v":""}]
[{"$f":"IF(A44=\"\",\"\",'Build Quote'!P143)","v":""}]
[{"$f":"IF(A45=\"\",\"\",'Build Quote'!P144)","v":""}]
["Date","Estimate #","In Hands Date",null,"Terms","Project"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!V142","v":0},{"$f":"'Build Quote'!R141","v":"00:00:00"},null,{"$f":"IF('Build Quote'!R151=\"\",\"\",'Build Quote'!R151)","v":""},{"$f":"IF('Build Quote'!E145=\"\",\"\",'Build Quote'!E145)","v":""}]
["Item","Description",null,null,null,null,"Qty","Price","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G50=\"\",\"\",H50*G50)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Tax and Shipping Additional | Allow for 5% +/- in totals                                                           + 3% convience fee for Credit Cards",null,null,null,null,null,"Total:",null,{"$f":"IF(I50=\"\",\"\",SUM(I50:I65)+I33)","v":""}]
[null,null,null,null,null,null,"Estimate"]
[]
[]
[null,null,null,null,null,null,null,"Page:",3]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688"]
[]
[]
["Name/Ship-To Address"]
[{"$f":"IF('Build Quote'!P174=0,\"\",'Build Quote'!P174)","v":""}]
[{"$f":"IF(A76=\"\",\"\",'Build Quote'!P175)","v":""}]
[{"$f":"IF(A77=\"\",\"\",'Build Quote'!P176)","v":""}]
[{"$f":"IF(A78=\"\",\"\",'Build Quote'!P177)","v":""}]
["Date","Estimate #","In Hands Date",null,"Terms","Project"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!V175","v":0},{"$f":"'Build Quote'!R174","v":"00:00:00"},null,{"$f":"IF('Build Quote'!R184=\"\",\"\",'Build Quote'!R184)","v":""},{"$f":"IF('Build Quote'!E178=\"\",\"\",'Build Quote'!E178)","v":""}]
["Item","Description",null,null,null,null,"Qty","Price","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G83=\"\",\"\",H83*G83)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(G98=\"\",\"\",H98*G98)","v":""}]
["Tax and Shipping Additional | Allow for 5% +/- in totals                                                           + 3% convience fee for Credit Cards",null,null,null,null,null,"Total:",null,{"$f":"IF(I83=\"\",\"\",SUM(I83:I98)+I66)","v":""}]
[null,null,null,null,null,null,"Estimate"]
[]
[]
[null,null,null,null,null,null,null,"Page:",4]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688"]
[]
[]
["Name/Ship-To Address"]
[{"$f":"IF('Build Quote'!P207=0,\"\",'Build Quote'!P207)","v":""}]
[{"$f":"IF(A109=\"\",\"\",'Build Quote'!P208)","v":""}]
[{"$f":"IF(A110=\"\",\"\",'Build Quote'!P209)","v":""}]
[{"$f":"IF(A111=\"\",\"\",'Build Quote'!P210)","v":""}]
["Date","Estimate #","In Hands Date",null,"Terms","Project"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!V208","v":0},{"$f":"'Build Quote'!R207","v":"00:00:00"},null,{"$f":"IF('Build Quote'!R217=\"\",\"\",'Build Quote'!R217)","v":""},{"$f":"IF('Build Quote'!E211=\"\",\"\",'Build Quote'!E211)","v":""}]
["Item","Description",null,null,null,null,"Qty","Price","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G116=\"\",\"\",H116*G116)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(G131=\"\",\"\",H131*G131)","v":""}]
["Tax and Shipping Additional | Allow for 5% +/- in totals                                                           + 3% convience fee for Credit Cards",null,null,null,null,null,"Total:",null,{"$f":"IF(I116=\"\",\"\",SUM(I116:I131)+I99)","v":""}]
[null,null,null,null,null,null,"Estimate"]
[]
[]
[null,null,null,null,null,null,null,"Page:",5]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688"]
[]
[]
["Name/Ship-To Address"]
[{"$f":"IF('Build Quote'!P240=0,\"\",'Build Quote'!P240)","v":""}]
[{"$f":"IF(A142=\"\",\"\",'Build Quote'!P241)","v":""}]
[{"$f":"IF(A143=\"\",\"\",'Build Quote'!P242)","v":""}]
[{"$f":"IF(A144=\"\",\"\",'Build Quote'!P243)","v":""}]
["Date","Estimate #","In Hands Date",null,"Terms","Project"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!V241","v":0},{"$f":"'Build Quote'!R240","v":"00:00:00"},null,{"$f":"IF('Build Quote'!R250=\"\",\"\",'Build Quote'!R250)","v":""},{"$f":"IF('Build Quote'!E244=\"\",\"\",'Build Quote'!E244)","v":""}]
["Item","Description",null,null,null,null,"Qty","Price","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G149=\"\",\"\",H149*G149)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(G164=\"\",\"\",H164*G164)","v":""}]
["Tax and Shipping Additional | Allow for 5% +/- in totals                                                           + 3% convience fee for Credit Cards",null,null,null,null,null,"Total:",null,{"$f":"IF(I149=\"\",\"\",SUM(I149:I164)+I132)","v":""}]

{"sheet":"PO to Vendor","index":3,"n_rows":243,"n_cols":9,"rows_kept":243,"cut":false,"hidden":false,"merged":[[242,8,243,8],[241,1,241,5],[95,0,96,5],[95,6,96,7],[144,0,145,5],[144,6,145,7],[193,0,194,5],[193,6,194,7],[242,0,243,5],[242,6,243,7],[236,1,236,5],[237,1,237,5],[238,1,238,5],[239,1,239,5],[240,1,240,5],[231,1,231,5],[232,1,232,5],[233,1,233,5],[234,1,234,5],[235,1,235,5],[226,1,226,5],[227,1,227,5],[228,1,228,5],[229,1,229,5],[230,1,230,5],[221,1,221,5],[222,1,222,5],[223,1,223,5],[224,1,224,5],[225,1,225,5],[216,1,216,5],[217,1,217,5],[218,1,218,5],[219,1,219,5],[220,1,220,5],[211,1,211,5],[212,1,212,5],[213,1,213,5],[214,1,214,5],[215,1,215,5],[208,2,208,3],[208,4,208,6],[209,2,209,3],[209,4,209,6],[210,1,210,5],[205,0,205,3],[205,5,205,8],[206,0,206,3],[206,5,206,8],[207,0,207,3],[207,5,207,8],[201,6,201,8],[203,1,203,3],[203,6,203,8],[204,0,204,3],[204,5,204,8],[201,0,201,3],[192,1,192,5],[195,6,197,8],[199,0,199,3],[199,6,200,8],[200,0,200,3],[193,8,194,8],[187,1,187,5],[188,1,188,5],[189,1,189,5],[190,1,190,5],[191,1,191,5],[182,1,182,5],[183,1,183,5],[184,1,184,5],[185,1,185,5],[186,1,186,5],[177,1,177,5],[178,1,178,5],[179,1,179,5],[180,1,180,5],[181,1,181,5],[172,1,172,5],[173,1,173,5],[174,1,174,5],[175,1,175,5],[176,1,176,5],[167,1,167,5],[168,1,168,5],[169,1,169,5],[170,1,170,5],[171,1,171,5],[162,1,162,5],[163,1,163,5],[164,1,164,5],[165,1,165,5],[166,1,166,5],[159,2,159,3],[159,4,159,6],[160,2,160,3],[160,4,160,6],[161,1,161,5],[156,0,156,3],[156,5,156,8],[157,0,157,3],[157,5,157,8],[158,0,158,3],[158,5,158,8],[152,6,152,8],[154,1,154,3],[154,6,154,8],[155,0,155,3],[155,5,155,8],[152,0,152,3],[143,1,143,5],[146,6,148,8],[150,0,150,3],[150,6,151,8],[151,0,151,3],[144,8,145,8],[138,1,138,5],[139,1,139,5],[140,1,140,5],[141,1,141,5],[142,1,142,5],[133,1,133,5],[134,1,134,5],[135,1,135,5],[136,1,136,5],[137,1,137,5],[128,1,128,5],[129,1,129,5],[130,1,130,5],[131,1,131,5],[132,1,132,5],[123,1,123,5],[124,1,124,5],[125,1,125,5],[126,1,126,5],[127,1,127,5],[118,1,118,5],[119,1,119,5],[120,1,120,5],[121,1,121,5],[122,1,122,5],[113,1,113,5],[114,1,114,5],[115,1,115,5],[116,1,116,5],[117,1,117,5],[110,2,110,3],[110,4,110,6],[111,2,111,3],[111,4,111,6],[112,1,112,5],[107,0,107,3],[107,5,107,8],[108,0,108,3],[108,5,108,8],[109,0,109,3],[109,5,109,8],[103,6,103,8],[105,1,105,3],[105,6,105,8],[106,0,106,3],[106,5,106,8],[103,0,103,3],[97,6,99,8],[101,0,101,3],[101,6,102,8],[102,0,102,3],[95,8,96,8],[91,1,91,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[86,1,86,5],[87,1,87,5],[88,1,88,5],[89,1,89,5],[90,1,90,5],[81,1,81,5],[82,1,82,5],[83,1,83,5],[84,1,84,5],[85,1,85,5],[76,1,76,5],[77,1,77,5],[78,1,78,5],[79,1,79,5],[80,1,80,5],[71,1,71,5],[72,1,72,5],[73,1,73,5],[74,1,74,5],[75,1,75,5],[66,1,66,5],[67,1,67,5],[68,1,68,5],[69,1,69,5],[70,1,70,5],[62,2,62,3],[62,4,62,6],[63,1,63,5],[64,1,64,5],[65,1,65,5],[59,0,59,3],[59,5,59,8],[60,0,60,3],[60,5,60,8],[61,2,61,3],[61,4,61,6],[56,1,56,3],[56,6,56,8],[57,0,57,3],[57,5,57,8],[58,0,58,3],[58,5,58,8],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[46,1,46,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[6,0,6,3],[4,0,4,3],[54,0,54,3],[23,1,23,5],[24,1,24,5],[25,1,25,5],[11,0,11,3],[12,0,12,3],[48,6,50,8],[52,0,52,3],[52,6,53,8],[53,0,53,3],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[54,6,54,8],[47,0,47,5],[29,1,29,5],[30,1,30,5],[47,6,47,7],[33,1,33,5],[34,1,34,5],[0,6,2,8],[5,0,5,3],[8,1,8,3],[8,6,8,8],[4,6,5,8],[6,6,6,8],[31,1,31,5],[32,1,32,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[22,1,22,5],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,1,15,5],[16,1,16,5],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[9,0,9,3],[10,0,10,3]]}
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",1]
[null,null,null,null,null,null,"In Hands Date"]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688",null,null,null,null,null,{"$f":"TODAY()+1","v":"2015-12-12"}]
[]
["Vendor:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!P$120=\"\",\"\",'Build Quote'!P$120)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!Q$120=\"\",\"\",'Build Quote'!Q$120)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,2,FALSE))","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,3,FALSE))","v":""}]
[]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!Q$112","v":25006},{"$f":"TODAY()","v":"2015-12-11"}]
["Item","Description",null,null,null,null,"Quantity","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H17=\"\",\"\",H17*G17)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H18=\"\",\"\",H18*G18)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I17=\"\",\"\",SUM(I17:I47))","v":""}]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",2]
[null,null,null,null,null,null,"In Hands Date"]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688",null,null,null,null,null,{"$f":"TODAY()+1","v":"2015-12-12"}]
[]
["Vendor:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!P$120=\"\",\"\",'Build Quote'!P$120)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!Q$120=\"\",\"\",'Build Quote'!Q$120)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,2,FALSE))","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,3,FALSE))","v":""}]
[]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!Q$112","v":25006},{"$f":"TODAY()","v":"2015-12-11"}]
["Item","Description",null,null,null,null,"Quantity","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H65=\"\",\"\",H65*G65)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H66=\"\",\"\",H66*G66)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I65=\"\",\"\",SUM(I65:I95)+I48)","v":""}]
[]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",3]
[null,null,null,null,null,null,"In Hands Date"]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688",null,null,null,null,null,{"$f":"TODAY()+1","v":"2015-12-12"}]
[]
["Vendor:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!P$120=\"\",\"\",'Build Quote'!P$120)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!Q$120=\"\",\"\",'Build Quote'!Q$120)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,2,FALSE))","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,3,FALSE))","v":""}]
[]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!Q$112","v":25006},{"$f":"TODAY()","v":"2015-12-11"}]
["Item","Description",null,null,null,null,"Quantity","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H114=\"\",\"\",H114*G114)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H115=\"\",\"\",H115*G115)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I114=\"\",\"\",SUM(I114:I144)+I97)","v":""}]
[]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",4]
[null,null,null,null,null,null,"In Hands Date"]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688",null,null,null,null,null,{"$f":"TODAY()+1","v":"2015-12-12"}]
[]
["Vendor:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!P$120=\"\",\"\",'Build Quote'!P$120)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!Q$120=\"\",\"\",'Build Quote'!Q$120)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,2,FALSE))","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,3,FALSE))","v":""}]
[]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!Q$112","v":25006},{"$f":"TODAY()","v":"2015-12-11"}]
["Item","Description",null,null,null,null,"Quantity","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H163=\"\",\"\",H163*G163)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H164=\"\",\"\",H164*G164)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I163=\"\",\"\",SUM(I163:I193)+I146)","v":""}]
[]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",5]
[null,null,null,null,null,null,"In Hands Date"]
["26080 Towne Ctr"]
["Foothill Ranch, CA 92688",null,null,null,null,null,{"$f":"TODAY()+1","v":"2015-12-12"}]
[]
["Vendor:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!P$120=\"\",\"\",'Build Quote'!P$120)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!Q$120=\"\",\"\",'Build Quote'!Q$120)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,2,FALSE))","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F$10=\"\",\"\",VLOOKUP(F$10,Factories!$A$2:$C$31,3,FALSE))","v":""}]
[]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'Build Quote'!Q$112","v":25006},{"$f":"TODAY()","v":"2015-12-11"}]
["Item","Description",null,null,null,null,"Quantity","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H212=\"\",\"\",H212*G212)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H213=\"\",\"\",H213*G213)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I212=\"\",\"\",SUM(I212:I242)+I195)","v":""}]

{"sheet":"PO to Decorator","index":4,"n_rows":165,"n_cols":9,"rows_kept":165,"cut":false,"hidden":false,"merged":[[160,1,160,5],[161,1,161,5],[163,1,163,5],[164,0,164,5],[164,6,164,7],[155,1,155,5],[156,1,156,5],[157,1,157,5],[158,1,158,5],[159,1,159,5],[150,1,150,5],[151,1,151,5],[152,1,152,5],[153,1,153,5],[154,1,154,5],[146,2,146,3],[146,4,146,6],[147,1,147,5],[148,1,148,5],[149,1,149,5],[143,0,143,3],[143,5,143,8],[144,0,144,3],[144,5,144,8],[145,2,145,3],[145,4,145,6],[140,1,140,3],[140,6,140,8],[141,0,141,3],[141,5,141,8],[142,0,142,3],[142,5,142,8],[132,6,134,8],[136,0,136,3],[136,6,137,8],[137,0,137,3],[138,6,138,8],[127,1,127,5],[128,1,128,5],[130,1,130,5],[131,0,131,5],[131,6,131,7],[122,1,122,5],[123,1,123,5],[124,1,124,5],[125,1,125,5],[126,1,126,5],[117,1,117,5],[118,1,118,5],[119,1,119,5],[120,1,120,5],[121,1,121,5],[113,2,113,3],[113,4,113,6],[114,1,114,5],[115,1,115,5],[116,1,116,5],[110,0,110,3],[110,5,110,8],[111,0,111,3],[111,5,111,8],[112,2,112,3],[112,4,112,6],[107,1,107,3],[107,6,107,8],[108,0,108,3],[108,5,108,8],[109,0,109,3],[109,5,109,8],[99,6,101,8],[103,0,103,3],[103,6,104,8],[104,0,104,3],[105,6,105,8],[94,1,94,5],[95,1,95,5],[97,1,97,5],[98,0,98,5],[98,6,98,7],[89,1,89,5],[90,1,90,5],[91,1,91,5],[92,1,92,5],[93,1,93,5],[84,1,84,5],[85,1,85,5],[86,1,86,5],[87,1,87,5],[88,1,88,5],[80,2,80,3],[80,4,80,6],[81,1,81,5],[82,1,82,5],[83,1,83,5],[77,0,77,3],[77,5,77,8],[78,0,78,3],[78,5,78,8],[79,2,79,3],[79,4,79,6],[74,1,74,3],[74,6,74,8],[75,0,75,3],[75,5,75,8],[76,0,76,3],[76,5,76,8],[66,6,68,8],[70,0,70,3],[70,6,71,8],[71,0,71,3],[72,6,72,8],[61,1,61,5],[62,1,62,5],[64,1,64,5],[65,0,65,5],[65,6,65,7],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[47,2,47,3],[47,4,47,6],[48,1,48,5],[49,1,49,5],[50,1,50,5],[44,0,44,3],[44,5,44,8],[45,0,45,3],[45,5,45,8],[46,2,46,3],[46,4,46,6],[41,1,41,3],[41,6,41,8],[42,0,42,3],[42,5,42,8],[43,0,43,3],[43,5,43,8],[33,6,35,8],[37,0,37,3],[37,6,38,8],[38,0,38,3],[39,6,39,8],[32,0,32,5],[29,1,29,5],[31,1,31,5],[32,6,32,7],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[9,0,9,3],[10,0,10,3],[23,1,23,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[22,1,22,5],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[11,0,11,3],[12,0,12,3],[0,6,2,8],[4,0,4,3],[5,0,5,3],[8,1,8,3],[8,6,8,8],[4,6,5,8],[6,6,6,8]]}
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",1]
["26080 Towne Ctr",null,null,null,null,null,"In Hands Date"]
["Foothill Ranch, CA 92688"]
[null,null,null,null,null,null,{"$f":"'Build Quote'!Q113","v":"00:00:00"}]
[]
["Decorator:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!Q120=\"\",\"\",'Build Quote'!Q120)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!L112=0,\"\",'Build Quote'!L112)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F10=\"\",\"\",'Build Quote'!L113)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F10=\"\",\"\",'Build Quote'!L114)","v":""}]
[null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",'Build Quote'!L115)","v":""}]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'PO to Vendor'!B15","v":25006},{"$f":"G7-'Build Quote'!L118","v":-2}]
["Item","Description",null,null,null,null,"Qty","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G17=\"\",\"\",H17*G17)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send a virtual proof to production@pedalindustries.com before production. Send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I17=\"\",\"\",SUM(I17:I32))","v":""}]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",2]
["26080 Towne Ctr",null,null,null,null,null,"In Hands Date"]
["Foothill Ranch, CA 92688"]
[null,null,null,null,null,null,{"$f":"'Build Quote'!Q142","v":"00:00:00"}]
[]
["Decorator:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!Q153=\"\",\"\",'Build Quote'!Q153)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!L141=0,\"\",'Build Quote'!L141)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F43=\"\",\"\",'Build Quote'!L142)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F43=\"\",\"\",'Build Quote'!L143)","v":""}]
[null,null,null,null,null,{"$f":"IF(F43=\"\",\"\",'Build Quote'!L144)","v":""}]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'PO to Vendor'!B48","v":0},{"$f":"G40-'Build Quote'!L151","v":"00:00:00"}]
["Item","Description",null,null,null,null,"Qty","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G50=\"\",\"\",H50*G50)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send a virtual proof to production@pedalindustries.com before production. Send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I50=\"\",\"\",SUM(I50:I65)+I33)","v":""}]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",3]
["26080 Towne Ctr",null,null,null,null,null,"In Hands Date"]
["Foothill Ranch, CA 92688"]
[null,null,null,null,null,null,{"$f":"'Build Quote'!Q175","v":"00:00:00"}]
[]
["Decorator:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!Q186=\"\",\"\",'Build Quote'!Q186)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!L174=0,\"\",'Build Quote'!L174)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F76=\"\",\"\",'Build Quote'!L175)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F76=\"\",\"\",'Build Quote'!L176)","v":""}]
[null,null,null,null,null,{"$f":"IF(F76=\"\",\"\",'Build Quote'!L177)","v":""}]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'PO to Vendor'!B81","v":0},{"$f":"G73-'Build Quote'!L184","v":"00:00:00"}]
["Item","Description",null,null,null,null,"Qty","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G83=\"\",\"\",H83*G83)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send a virtual proof to production@pedalindustries.com before production. Send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I83=\"\",\"\",SUM(I83:I98)+I66)","v":""}]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[null,null,null,null,null,null,null,"Page:",4]
["26080 Towne Ctr",null,null,null,null,null,"In Hands Date"]
["Foothill Ranch, CA 92688"]
[null,null,null,null,null,null,{"$f":"'Build Quote'!Q208","v":"00:00:00"}]
[]
["Decorator:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!Q219=\"\",\"\",'Build Quote'!Q219)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!L207=0,\"\",'Build Quote'!L207)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F109=\"\",\"\",'Build Quote'!L208)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F109=\"\",\"\",'Build Quote'!L209)","v":""}]
[null,null,null,null,null,{"$f":"IF(F109=\"\",\"\",'Build Quote'!L210)","v":""}]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'PO to Vendor'!B114","v":0},{"$f":"G106-'Build Quote'!L217","v":"00:00:00"}]
["Item","Description",null,null,null,null,"Qty","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G116=\"\",\"\",H116*G116)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send a virtual proof to production@pedalindustries.com before production. Send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I116=\"\",\"\",SUM(I116:I131)+I99)","v":""}]
[null,null,null,null,null,null,"Purchase Order"]
[]
[]
[]
["26080 Towne Ctr",null,null,null,null,null,"In Hands Date"]
["Foothill Ranch, CA 92688"]
[null,null,null,null,null,null,{"$f":"'Build Quote'!Q241","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Page:",5]
["Decorator:",null,null,null,null,"Ship To:"]
[{"$f":"IF('Build Quote'!Q252=\"\",\"\",'Build Quote'!Q252)","v":""},null,null,null,null,{"$f":"IF('Build Quote'!L240=0,\"\",'Build Quote'!L240)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(F142=\"\",\"\",'Build Quote'!L241)","v":""}]
[{"$f":"IF(A$10=\"\",\"\",VLOOKUP(A$10,Factories!$A$2:$C$31,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(F142=\"\",\"\",'Build Quote'!L242)","v":""}]
[null,null,null,null,null,{"$f":"IF(F142=\"\",\"\",'Build Quote'!L243)","v":""}]
["Date","P.O. Number","Estimated Ship Date"]
[{"$f":"TODAY()","v":"2015-12-11"},{"$f":"'PO to Vendor'!B147","v":0},{"$f":"G139-'Build Quote'!L250","v":"00:00:00"}]
["Item","Description",null,null,null,null,"Qty","Cost","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G149=\"\",\"\",H149*G149)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["Please send a virtual proof to production@pedalindustries.com before production. Send invoices to accounting@pedalindustries.com.",null,null,null,null,null,"Total:",null,{"$f":"IF(I149=\"\",\"\",SUM(I149:I164)+I132)","v":""}]

{"sheet":"Customers","index":5,"n_rows":127,"n_cols":8,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
["Company","Address","Address 2","City","State","Zip","Phone","Email"]
["Pedal Industries","1234 address",null,"foothill ranch","ca",92688,9495551234,"pedalindustries.email@gmail.com"]
["Super Customer","111 success lane",null,"irvine","ca",92653,9495554321,"thisisnotarealemail@gmail.com"]
["Customer Three","41 big spender ave",null,"santa barbara","ca",92850,7135556321,"anotherfakeemail@gmail.com"]
["Acme, inc.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Widget Corp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["123 Warehousing","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Demo Company","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Smith and Co.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Foo Bars","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["ABC Telecom","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Fake Brothers","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["QWERTY Logistics","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Demo, inc.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sample Company","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sample, inc","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Acme Corp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Allied Biscuit","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Ankh-Sto Associates","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Extensive Enterprise","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Galaxy Corp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Globo-Chem","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Mr. Sparkle","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Globex Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["LexCorp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["LuthorCorp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["North Central Positronics","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Omni Consimer Products","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Praxis Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sombra Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sto Plains Holdings","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Tessier-Ashpool","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Wayne Enterprises","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Wentworth Industries","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["ZiffCorp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Bluth Company","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Strickland Propane","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Thatherton Fuels","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Three Waters","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Water and Power","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Western Gas & Electric","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Mammoth Pictures","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Mooby Corp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Gringotts","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Thrift Bank","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Flowers By Irene","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["The Legitimate Businessmens Club","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Osato Chemicals","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Transworld Consortium","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Universal Export","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["United Fried Chicken","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Virtucon","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Kumatsu Motors","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Keedsler Motors","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Powell Motors","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Industrial Automation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sirius Cybernetics Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["U.S. Robotics and Mechanical Men","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Colonial Movers","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Corellian Engineering Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Incom Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["General Products","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Leeding Engines Ltd.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Blammo","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Input, Inc.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Mainway Toys","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Videlectrix","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Zevo Toys","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Ajax","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Axis Chemical Co.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Barrytron","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Carrys Candles","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Cogswell Cogs","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Spacely Sprockets","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["General Forge and Foundry","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Duff Brewing Company","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Dunder Mifflin","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["General Services Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Monarch Playing Card Co.","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Krustyco","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Initech","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Roboto Industries","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Primatech","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sonky Rubber Goods","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["St. Anky Beer","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Stay Puft Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Vandelay Industries","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Wernham Hogg","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Gadgetron","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Burleigh and Stronginthearm","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["BLAND Corporation","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Nordyne Defense Dynamics","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Petrox Oil Company","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Roxxon","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["McMahon and Tate","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Sixty Second Avenue","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Charles Townsend Agency","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Spade and Archer","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Megadodo Publications","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Rouster and Sideways","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["C.H. Lavatory and Sons","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Globo Gym American Corp","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["The New Firm","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["SpringShield","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Compuglobalhypermeganet","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Data Systems","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Gizmonic Institute","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Initrode","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Taggart Transcontinental","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Atlantic Northern","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Niagular","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Plow King","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Big Kahuna Burger","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Big T Burgers and Fries","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Chez Quis","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Chotchkies","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["The Frying Dutchman","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Klimpys","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["The Krusty Krab","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Monks Diner","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Milliways","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Minuteman Cafe","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Taco Grande","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Tip Top Cafe","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Moes Tavern","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Central Perk","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]
["Chasers","123 not a real street",null,"irvine","ca",92671,9495551234,"anotherfakeemail@gmail.com"]

{"sheet":"Blank Products","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Item Number","Cost","Blank Color Options","Customer Item","Customer Description"]
[3301,4,null,"Apparel","Premium Crew Neck"]
[3401,4.5,null,"Apparel","Ladies V Neck"]
[3501,4.3,null,"Apparel","Crew Neck"]
[3601,4,null,"Apparel","Premium Crew Neck"]
[4101,4.5,null,"Apparel","Ladies V Neck"]
[4102,4.3,null,"Apparel","Crew Neck"]
[4201,4,null,"Apparel","Premium Crew Neck"]
[4202,4.5,null,"Apparel","Ladies V Neck"]
[4301,4.3,null,"Apparel","Crew Neck"]
[4401,4,null,"Apparel","Premium Crew Neck"]
[5101,4.5,null,"Apparel","Ladies V Neck"]
[5201,4.3,null,"Apparel","Crew Neck"]
[5301,4.3,null,"Apparel","Premium Crew Neck"]

{"sheet":"info","index":7,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Item Types:"]
[null,"Apparel"]
[null,"Apparel:Apparel Set up"]
[null,"Other"]
[null,"Other:Set up"]
[null,"Hats!"]
[null,"Hats!:Set up Hats"]
[null,"DHD"]
[null,"DHD:Bag and Fold"]
[null,"DHD:Neck Hit"]
[null,"DHD:Remove Label"]
[null,"DHD:Setup"]
[null,"Cycle Kits"]
[null,"Cycle Kits:Setup"]
[null,"Socks!"]
[null,"Socks!:Set up Socks"]

{"sheet":"Lines","index":8,"n_rows":109,"n_cols":32,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Number of Locations","Current Location #","Blank Item #","Blank Cost","Bag+Fold","Run Charge","Style Name","Style QTY","Line Type","Margin","Blank Color","XXS","XS","S","M","L","XL","2XL","3XL","4XL","2XL +","3XL +","4XL +","Blank Description"]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[0,null,1,null,null,false,null,null,null,null,0.4]
[1,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[2,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[3,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[4,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[5,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[6,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[7,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[8,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[9,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[10,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[11,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[12,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[13,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[14,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[15,null,1,null,null,false,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,1,2,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Preset Location Names:"]
["Front"]
["Back"]
["Side"]
["test1"]
["test2"]
["Forfun"]
["Forfun1"]
["not a real name"]
["lkjh"]

{"sheet":"TREVFileNames","index":9,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Estimate FileName:",{"$f":"B2&\" Estimate\"","v":"25006 Estimate"}]
["Job Number:",25006]
["Customer:",{"$f":"'Build Quote'!L112","v":0}]
["Customer Email:",{"$f":"IFERROR(VLOOKUP(B3,Customers!A:H,8,FALSE),\"no email\")","v":"no email"}]
["Vendor:",{"$f":"IF('Build Quote'!P120=\"\",\"\",'Build Quote'!P120)","v":""}]
["Vendor Email:",{"$f":"IFERROR(VLOOKUP(B5,Factories!A:E,4,FALSE),\"no email\")","v":"no email"}]
["Decorator:",{"$f":"IF('Build Quote'!Q120=\"\",\"\",'Build Quote'!Q120)","v":""}]
["Decorator Email:",{"$f":"IFERROR(VLOOKUP(B7,Factories!A:E,4,FALSE),\"no email\")","v":"no email"}]

{"sheet":"TREVJobToZoho","index":10,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Job # : ",{"$f":"TREVFileNames!B2","v":25006}]
["Job Name : ",{"$f":"IF('Build Quote'!Q118=\"\",\"\",'Build Quote'!Q118)","v":""}]
["Customers : ",{"$f":"IF('Build Quote'!L112=\"\",\"\",'Build Quote'!L112)","v":""}]
["Status : ","New Order"]
["Steps : ","Check in-hands Date"]
["Date Initiated : ",{"$f":"TODAY()","v":"2015-12-11"}]
["Date In Hands : ",{"$f":"IF('Build Quote'!Q113=\"\",\"\",'Build Quote'!Q113)","v":""}]
["Ship Time : ",{"$f":"'Build Quote'!L118","v":2}]
["Purchase Orders : "]
["Excel Sheet : "]
["Attachments : "]
["Art : "]
["Overview : "]
["Old Quote Number : "]
["Date Ordered : "]
["Total Quote Amount : ",{"$f":"'Build Quote'!W115","v":0}]
["Estimated Profit : ",{"$f":"'Build Quote'!W116","v":0}]
["Tracking Numbers : "]
["Line Items : "]

{"sheet":"TREVPermanent","index":11,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Sent to Zoho?",false]
["Got PO Number",false]
["Print Estimate",false]
["Print PO to Vendor",false]
["Print PO to Decorator",false]
["Sent Estimate",false]
["Sent PO to Vendor",false]
["Sent PO to Decorator",false]
["Build Estimate",false]
["Build PO Vendor",false]
["Build PO Decorator",false]
["Estimate Length"]
["PO Vendor Length"]
["PO Decorator Length"]
["Required Fields Complete",{"$f":"IF('Build Quote'!L112=\"\",1,IF('Build Quote'!Q113=\"\",1,IF('Build Quote'!Q116=\"\",1,IF('Build Quote'!Q117=\"\",1,IF('Build Quote'!Q118=\"\",1,IF('Build Quote'!P120=\"\",1,IF('Build Quote'!Q120=\"\",1,0)))))))","v":1}]

{"sheet":"Line 1","index":12,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 2","index":13,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 3","index":14,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Pacific Price List","index":15,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,3,0,17],[2,0,12,0]]}
[null,null,null,"Number of Colors"]
[null,null,null,"Process",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"Flash"]
["Quantity Level",1,0,120,25,40,55,70,85,100,115,130,145,160,175,190,205,220,1]
[null,24,1,10,2,3,4,5,6,7,8,9,10,11,12,13,14,15,1]
[null,48,2,9,1.9,2,2.1,2.2000000000000002,2.2999999999999998,2.4,2.5,2.6,2.7,2.8,2.9,3,3.1,3.2,1]
[null,72,3,8,1.8,1.9,2,2.1,2.2000000000000002,2.2999999999999998,2.4,2.5,2.6,2.7,2.8,2.9,3,3.1,1]
[null,144,4,7,1.7,1.8,1.9,2,2.1,2.2000000000000002,2.2999999999999998,2.4,2.5,2.6,2.7,2.8,2.9,3,0.9]
[null,{"$f":"B7*2","v":288},5,6,1.6,1.55,1.5,1.45,1.4,1.35,1.3,1.25,1.2,1.1499999999999999,1.1000000000000001,1.05,0.999999999999999,0.94999999999999896,0.9]
[null,600,6,5,1.5,1.48,1.46,1.44,1.42,1.4,1.38,1.36,1.34,1.32,1.3,1.28,1.26,1.24,0.9]
[null,1200,7,4,1.4,1.39,1.38,1.37,1.36,1.35,1.34,1.33,1.32,1.31,1.3,1.29,1.28,1.27,0.9]
[null,{"$f":"250*12","v":3000},8,3,1.3,1.29,1.28,1.27,1.26,1.25,1.24,1.23,1.22,1.21,1.2,1.19,1.18,1.17,0.9]
[null,6000,9,2,1.2,1.19,1.18,1.17,1.1599999999999999,1.1499999999999999,1.1399999999999999,1.1299999999999999,1.1200000000000001,1.1100000000000001,1.1000000000000001,1.0900000000000001,1.08,1.07,0.9]
[null,12000,10,1,1.1000000000000001,1.0900000000000001,1.08,1.07,1.06,1.05,1.04,1.03,1.02,1.01,1,0.99,0.98,0.97,0.9]
[null,500000]

{"sheet":"Line 4","index":16,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 5","index":17,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 6","index":18,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 7","index":19,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 8","index":20,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 9","index":21,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 10","index":22,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 11","index":23,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 12","index":24,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 13","index":25,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 14","index":26,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]

{"sheet":"Line 15","index":27,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"location name","colors","flash"]
[null,0,1,2]
[0,null,null,false]
[1,null,null,false]
[2,null,null,false]
[3,null,null,false]
[4,null,null,false]
[5,null,null,false]
[6,null,null,false]
[7,null,null,false]
[8,null,null,false]
[9,null,null,false]
[10,null,null,false]