{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["QuickBooks Data","Data Entry Page","Customer Confirmation","Factory Order Form","Front Office","Macro Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"QuickBooks Data","index":0,"n_rows":27,"n_cols":44,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Customer","RefNumber","Payment Method","Check Number","Class","Rep","BillTo Line1","BillTo Line2","BillTo Line3","BillTo Line4","BillTo City","BillTo State","BillTo PostalCode","ShipTo Line1","ShipTo Line2","ShipTo Line3","ShipTo Line4","ShipTo City","ShipTo State","ShipTo PostalCode","Phone","Email","First Name","Last Name","Customer Message","TO BE PRINTED","To Be E-Mailed","Company Name","CC Number","CC Expire Month","CC Expire Year","CC Name on Card","CC Address","CC Postal Code","REP","SHIP DATE","CLASS","VIA","ITEM","DESCRIPTION","QUANTITY","PRICE","AMOUNT","MEMO"]
[{"$f":"'Data Entry Page'!B13","v":"Arizona Baseball Club"},1,{"$f":"IF('Data Entry Page'!B33=\"card #\",\"CHECK\",\"CREDIT CARD\")","v":"CREDIT CARD"},{"$f":"IF(OR('Data Entry Page'!D32=\"check#\", 'Data Entry Page'!D32=\"\"), \"\", 'Data Entry Page'!D32)","v":""},{"$f":"'Data Entry Page'!A5","v":"TP4L"},{"$f":"'Data Entry Page'!B5","v":"DT"},{"$f":"'Data Entry Page'!B17","v":"David Pruitt"},{"$f":"IF(OR('Data Entry Page'!B18=\"Company\", 'Data Entry Page'!B18=\"\"), \"\", 'Data Entry Page'!B18)","v":"Arizona Baseball Club\t\t"},{"$f":"'Data Entry Page'!B19","v":"7573 W. Navigator Lane"},{"$f":"IF(OR('Data Entry Page'!B20=\"address\", 'Data Entry Page'!B20=\"\"), \"\", 'Data Entry Page'!B20)","v":""},{"$f":"'Data Entry Page'!B21","v":"Peoria"},{"$f":"'Data Entry Page'!B22","v":"AZ"},{"$f":"'Data Entry Page'!B23","v":85383},{"$f":"'Data Entry Page'!B24","v":"David Pruitt"},{"$f":"IF(OR('Data Entry Page'!B25=\"Company\", 'Data Entry Page'!B25=\"\"), \"\", 'Data Entry Page'!B25)","v":"Arizona Baseball Club\t\t"},{"$f":"IF('Data Entry Page'!B26=\"address\",\"\",'Data Entry Page'!B26)","v":"7573 W. Navigator Lane"},{"$f":"IF(OR('Data Entry Page'!B27=\"address\", 'Data Entry Page'!B27=\"\"), \"\", 'Data Entry Page'!B27)","v":""},{"$f":"'Data Entry Page'!B28","v":"Peoria"},{"$f":"'Data Entry Page'!B29","v":"AZ"},{"$f":"'Data Entry Page'!B30","v":85383},{"$f":"'Data Entry Page'!B16","v":"602 509 1996"},{"$f":"'Data Entry Page'!B15","v":"admin@arizonabbc.com"},{"$f":"'Data Entry Page'!B14","v":"David"},{"$f":"'Data Entry Page'!C14","v":"Pruitt"},"Thank you For Your Purchase!","N","Y",{"$f":"IF('Data Entry Page'!B13=\"team / company name\",\"\",'Data Entry Page'!B13)","v":"Arizona Baseball Club"},{"$f":"'Data Entry Page'!B33","v":"4246315257889988"},{"$f":"'Data Entry Page'!B34","v":"12"},{"$f":"'Data Entry Page'!C34","v":"2027"},{"$f":"'Data Entry Page'!B17","v":"David Pruitt"},{"$f":"'Data Entry Page'!B19","v":"7573 W. Navigator Lane"},{"$f":"'Data Entry Page'!B23","v":85383},{"$f":"'Data Entry Page'!B5","v":"DT"},{"$f":"IF(ISBLANK('Data Entry Page'!G5), TEXT(TODAY()+10, \"MM/DD/YYYY\"), TEXT('Data Entry Page'!G5, \"MM/DD/YYYY\"))","v":"04/03/2026"},{"$f":"'Data Entry Page'!A5","v":"TP4L"},null,{"$f":"'Data Entry Page'!C52","v":"Trading Pin"},{"$f":"CONCATENATE(\n    'Data Entry Page'!C51, \" - \",\n    IF('Data Entry Page'!C55<>\"\", TEXT('Data Entry Page'!C55, \"0%\") & \" \", \"\"),\n    'Data Entry Page'!C52, \", \",\n    _xlfn.TEXTJOIN(\", \", TRUE,\n        'Data Entry Page'!C53,\n        'Data Entry Page'!C54,\n        'Data Entry Page'!C56,\n        IF('Data Entry Page'!C57<>\"\", 'Data Entry Page'!C57 & \" Epoxy\", \"\"),\n        'Data Entry Page'!C58,\n        'Data Entry Page'!C59)\n)","v":"360 - 2 Rubber Clutch Trading Pin, Cloisonne Soft Enamel, 1.75\", Die Black Metal, No Epoxy, Glitter Color"},{"$f":"'Data Entry Page'!C51","v":360},{"$f":"'Data Entry Page'!C44","v":3.8},{"$f":"'Data Entry Page'!C38","v":1368},{"$f":"CONCATENATE(\n    'Data Entry Page'!A5, \" - \",\n    'Data Entry Page'!B5, \" - \",\n    IF('Data Entry Page'!B32<>\"\", 'Data Entry Page'!B32 & \" - \", \"\"),\n    TEXT(AJ2, \"M/DD\")\n)","v":"TP4L - DT - 4/03"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF('Data Entry Page'!C45 > 0, A2, \"\")","v":""},{"$f":"IF('Data Entry Page'!C45 > 0, B2, \"\")","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,{"$f":"IF('Data Entry Page'!C45 > 0, TEXT('Data Entry Page'!C45 * 100, \"0\") & \"% Discount\", \"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!C50 > 0, A2, \"\")","v":""},{"$f":"IF('Data Entry Page'!C50 > 0, B2, \"\")","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,{"$f":"IF('Data Entry Page'!C50 > 0, \"Mold Fee\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C50 > 0, \"Standard Mold Fee\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C50 > 0, \"1\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C50 > 0, 'Data Entry Page'!C50, \"\")","v":""}]
[{"$f":"IF('Data Entry Page'!C47 > 0, A2, \"\")","v":""},{"$f":"IF('Data Entry Page'!C47 > 0, B2, \"\")","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,{"$f":"IF('Data Entry Page'!C47 > 0, \"Offset Digital Fee\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C47 > 0, \"Offset Digital Fee\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C47 > 0, \"1\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C47 > 0, 'Data Entry Page'!C47, \"\")","v":""}]
[{"$f":"IF('Data Entry Page'!C48 > 0, A2, \"\")","v":""},{"$f":"IF('Data Entry Page'!C48 > 0, B2, \"\")","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,{"$f":"IF('Data Entry Page'!C48 > 0, \"SHIPPING\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C48 > 0, \"Shipping Fee\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C48 > 0, \"1\", \"\")","v":""},{"$f":"IF('Data Entry Page'!C48 > 0, 'Data Entry Page'!C48, \"\")","v":""}]

{"sheet":"Data Entry Page","index":1,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[38,3,38,6],[0,0,0,5],[10,1,10,3],[7,1,7,4],[37,3,37,6],[8,1,8,4],[12,1,12,2]]}
["PINS & COINS  Order Completion Checklist",null,null,null,null,null,"REV. 28JUNE2024"]
[]
[]
["Website","Sales","Approved By:","Previous Customer",null,"Quote Only: "]
["TP4L","DT","MK,NS,JM","ReOrder: "," 26-50030","Ship Date:","2026-04-03"]
[null,null,null,"Factory: ","MPE"]
[null,"Internal Office notes"]
[]
[null,"LSP"]
[]
["Name as turned in:","Arizona Baseball #7 - David Pruitt"]
[]
["Team / Company","Arizona Baseball Club"]
["contact name","David","Pruitt"]
["Email","admin@arizonabbc.com"]
["Phone ","602 509 1996"]
["Customer Bill To:","David Pruitt"]
[null,"Arizona Baseball Club\t\t"]
[null,"7573 W. Navigator Lane"]
[]
[null,"Peoria"]
[null,"AZ"]
[null,85383]
["Customer Ship To:","David Pruitt"]
[null,"Arizona Baseball Club\t\t"]
[null,"7573 W. Navigator Lane"]
[]
[null,"Peoria"]
[null,"AZ"]
[null,85383]
[]
["PO Number",null,"Check#","check#"]
["Credit Card #","4246315257889988"]
["Expiration date","12","2027"]
["Security Code","790"]
[]
["TOTAL QUANTITY",null,{"$f":"E51","v":360},"ADDITIONAL FACTORY INSTRUCTIONS"]
["TOTAL SALE",null,{"$f":"E49","v":1368},"Ship on or before April 3rd 2026."]
["variations",null,{"$f":"E41","v":1}]
[]
[null,null,{"$f":"IF(C51>0,1,\"\")","v":1},null,{"$f":"SUM(B41:D41)","v":1}]
["Quantity",null,360]
[]
["Unit Price",null,3.8]
["Discount %"]
["GA County Sales Tax    "]
["Offset Digital Fee"]
["Shipping Fees"]
["Total Delivered Price",null,{"$f":"(C44*C51)*(1-C45)+C47+C48+C50","v":1368},null,{"$f":"SUM(B49:D49)","v":1368}]
["Mold Fee"]
["Quantity",null,{"$f":"C42","v":360},null,{"$f":"SUM(B51:D51)","v":360}]
["Product","(pulldown menu)","Trading Pin"]
["Type","(pulldown menu)","Cloisonne Soft Enamel"]
["Size",null,"1.75\""]
["Backing","(pulldown menu)","2 Rubber Clutch"]
["Plating","(pulldown menu)","Die Black Metal"]
["Epoxy","(pulldown menu)","No"]
["Options","(pulldown menu)","Glitter Color"]
["Options","(pulldown menu)"]
["Options","(pulldown menu)","Spinner"]
["Coin Edging","(pulldown menu)"]
["Back Stamping","(pulldown menu)","Yes"]
["Colors","# OF COLORS","White, 187 glitter, black"]
["Proof Number",null,"3D (spinner)"]

{"sheet":"Customer Confirmation","index":2,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,0,3,7],[57,0,57,7],[59,0,59,7],[61,0,61,7],[55,0,55,7],[53,0,53,7],[51,0,51,7]]}
[]
["Hello ,"]
[]
["Per your request we have attached a Full Color Proof of your design.  Please review this proof(s) and your pertinent order information and reply back to us with your approval to proceed."]
[]
[{"$f":"IF(OR('Data Entry Page'!B25=\"name\",'Data Entry Page'!B18=\"name\",'Data Entry Page'!B33=\"card #\"),\"Please provide us with your information as requested below\",\"\")","v":""}]
[]
["Your Full Name: "]
[]
["Name for the order (business or organization):"]
[]
["Phone Number:"]
[]
[{"$f":"IF('Data Entry Page'!B26=\"address\",\"Shipping Address:\",\"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!B19=\"address\",\"Billing Address:\",\"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!B33=\"card #\",\"Credit Card Number\",\"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!B33=\"card #\",\"Expiration MM/YY:\",\"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!B33=\"card #\",\"Security Code:          (VISA, MC, DISC 3 digits on rear - AMEX 4 digits on face)\",\"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!B33=\"card #\",\"Name as it Appears on the Card\",\"\")","v":""}]
[]
[{"$f":"IF('Data Entry Page'!B33=\"card #\",\"Type of Credit Card: or if you prefer, simply call my toll free number below.\",\"\")","v":""}]
[]
[]
["Name:                   ",null,null,{"$f":"'Data Entry Page'!B11","v":"Arizona Baseball #7 - David Pruitt"}]
["Customer Phone #:        ",null,null,{"$f":"'Data Entry Page'!B16","v":"602 509 1996"}]
["Email ",null,null,{"$f":"'Data Entry Page'!B15","v":"admin@arizonabbc.com"}]
[]
["Offset Digital Fee",null,null,{"$f":"IF('Data Entry Page'!C47>0,'Data Entry Page'!C47,\"\")","v":""}]
["Mold Fee",null,null,{"$f":"IF('Data Entry Page'!C50>0,'Data Entry Page'!C50,\"\")","v":""}]
["Quantity",null,null,{"$f":"IF('Data Entry Page'!C51>0,'Data Entry Page'!C51,\"\")","v":360}]
["Product",null,null,{"$f":"IF('Data Entry Page'!C52>0,'Data Entry Page'!C52,\"\")","v":"Trading Pin"}]
["Type",null,null,{"$f":"IF('Data Entry Page'!C53>0,'Data Entry Page'!C53,\"\")","v":"Cloisonne Soft Enamel"}]
["Size",null,null,{"$f":"IF('Data Entry Page'!C54>0,'Data Entry Page'!C54,\"\")","v":"1.75\""}]
["Backing",null,null,{"$f":"IF('Data Entry Page'!C55>0,'Data Entry Page'!C55,\"\")","v":"2 Rubber Clutch"}]
["Plating",null,null,{"$f":"IF('Data Entry Page'!C56>0,'Data Entry Page'!C56,\"\")","v":"Die Black Metal"}]
["Epoxy",null,null,{"$f":"IF('Data Entry Page'!C57>0,'Data Entry Page'!C57,\"\")","v":"No"}]
["Options",null,null,{"$f":"IF('Data Entry Page'!C58>0,IF(OR('Data Entry Page'!C58=\"Clear Protective Coating\",'Data Entry Page'!C58=\"Glitter Color\",'Data Entry Page'!C58=\"Dangler\",'Data Entry Page'!C58=\"Bobble Head\",'Data Entry Page'!C58=\"3-D Mold\",'Data Entry Page'!C58=\"Cutouts\",'Data Entry Page'!C58=\"Presentation Case\"),'Data Entry Page'!C58,\"NONE\"),\"\")","v":"Glitter Color"}]
["Options",null,null,{"$f":"IF('Data Entry Page'!C59>0,IF(OR('Data Entry Page'!C59=\"Clear Protective Coating\",'Data Entry Page'!C59=\"Glitter Color\",'Data Entry Page'!C59=\"Dangler\",'Data Entry Page'!C59=\"Bobble Head\",'Data Entry Page'!C59=\"3-D Mold\",'Data Entry Page'!C59=\"Cutouts\",'Data Entry Page'!C59=\"Presentation Case\"),'Data Entry Page'!C59,\"NONE\"),\"\")","v":""}]
["Options",null,null,{"$f":"IF('Data Entry Page'!C60>0,IF(OR('Data Entry Page'!C60=\"Slidder\",'Data Entry Page'!C60=\"Blinker\",'Data Entry Page'!C60=\"Spinner\",'Data Entry Page'!C60=\"Springer\"),'Data Entry Page'!C60,\"NONE\"),\"\")","v":"Spinner"}]
["Coin Edging",null,null,{"$f":"IF('Data Entry Page'!C61>0,'Data Entry Page'!C61,\"\")","v":""}]
["Colors",null,"# of colors",{"$f":"IF('Data Entry Page'!C63>0,'Data Entry Page'!C63,\"\")","v":"White, 187 glitter, black"}]
["Proof Number",null,null,{"$f":"IF('Data Entry Page'!C64>0,'Data Entry Page'!C64,\"\")","v":"3D (spinner)"}]
[]
["Order Total:",null,null,{"$f":"'Data Entry Page'!E49","v":1368}]
[]
[]
[{"$f":"IF('Data Entry Page'!C48=0,\"You have selected our Standard Air Shipping method which is UPS Expedited Delivery.  Delivery is typically within 3-5 days depending on your location.\",\"You have selected our Express Air Shipping method which is UPS Express Delivery.  Delivery is typically within 1-3 days depending on your location.\")","v":"You have selected our Standard Air Shipping method which is UPS Expedited Delivery.  Delivery is typically within 3-5 days depending on your location."}]
[]
["DUE TO THE EXTREME VOLUME OF TRADING PINS ORDERED BETWEEN THE DATES OF (JUNE 1 and JULY 31) THERE WILL BE NO DELIVERY GUARANTEES IMPLIED OR OFFERED BETWEEN THIS TIME PERIOD"]
[]
["We will charge the order to the credit card number provided."]
[]
["All price quotes valid for 7 days unless otherwise stated in email above.  Estimated production times do not begin until final artwork approval and payment have BOTH been received. "]
[]
["Due to the custom nature of the product we manufacture, all sales are final and once an order has been placed it may not be canceled for any reason."]
[]
["Due to the custom nature of the product we manufacture, all sales are final and once an order has been placed it may not be canceled for any reason. By replying to this email and giving your approval to start production of this order, you are stating that you have thoroughly checked and reviewed the proof and acknowledge that it is free of errors and is ready for manufacturing, and that you have read and agree to the attached Guarantees, Terms and Conditions for your order. "]

{"sheet":"Factory Order Form","index":3,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,0,4,4],[5,0,5,4],[6,0,6,4]]}
["Hello,",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[{"$f":"IF('Data Entry Page'!E5=\"NO\",\"We have a new order for you;\",\"We have a REORDER for you, please use Reorder#\")","v":"We have a REORDER for you, please use Reorder#"},null,null,null,{"$f":"IF('Data Entry Page'!E5=\"NO\",\"\",'Data Entry Page'!E5)","v":" 26-50030"},null,null,""]
[null,null,null,null,null,null,null,""]
[{"$f":"IF('Data Entry Page'!G4=\"YES\",\"RUSH ORDER : This order must ship to the customer on or before\",\"\")","v":""},null,null,null,null,{"$f":"IF('Data Entry Page'!G4=\"YES\",'Data Entry Page'!G5,\"\")","v":""},null,""]
[{"$f":"IF('Data Entry Page'!D38=\"\",\"\",'Data Entry Page'!D38)","v":"Ship on or before April 3rd 2026."},null,null,null,null,null,null,""]
[{"$f":"IF('Data Entry Page'!D39=\"\",\"\",'Data Entry Page'!D39)","v":""}]
[]
["Name",null,null,{"$f":"'Data Entry Page'!B11","v":"Arizona Baseball #7 - David Pruitt"}]
["Customer Phone #:       ",null,null,{"$f":"'Data Entry Page'!B16","v":"602 509 1996"}]
[]
["Quantity",null,null,{"$f":"IF('Data Entry Page'!C51>0,'Data Entry Page'!C51,\"\")","v":360}]
["Product",null,null,{"$f":"IF('Data Entry Page'!C52>0,'Data Entry Page'!C52,\"\")","v":"Trading Pin"}]
["Type",null,null,{"$f":"IF('Data Entry Page'!C53>0,IF('Data Entry Page'!C53=\"Cloisonne\",\"Epola\",IF('Data Entry Page'!C53=\"Cloisonne Soft Enamel\",\"Iron Soft Enamel\",'Data Entry Page'!C53)),\"\")","v":"Iron Soft Enamel"}]
["Size",null,null,{"$f":"IF('Data Entry Page'!C54>0,'Data Entry Page'!C54,\"\")","v":"1.75\""}]
["Backing",null,null,{"$f":"IF('Data Entry Page'!C55>0,'Data Entry Page'!C55,\"\")","v":"2 Rubber Clutch"}]
["Plating",null,null,{"$f":"IF('Data Entry Page'!C56>0,IF('Data Entry Page'!C56=\"18k Gold\",\"Bronze\",IF('Data Entry Page'!C56=\"Polished Silver\",\"Nickle\",'Data Entry Page'!C56)),\"\")","v":"Die Black Metal"}]
["Epoxy",null,null,{"$f":"IF('Data Entry Page'!C57>0,'Data Entry Page'!C57,\"\")","v":"No"}]
["Options",null,null,{"$f":"IF('Data Entry Page'!C58>0,IF(OR('Data Entry Page'!C58=\"Clear Protective Coating\",'Data Entry Page'!C58=\"Glitter Color\",'Data Entry Page'!C58=\"Dangler\",'Data Entry Page'!C58=\"Bobble Head\",'Data Entry Page'!C58=\"3-D Mold\",'Data Entry Page'!C58=\"Cutouts\",'Data Entry Page'!C58=\"Presentation Case\"),'Data Entry Page'!C58,\"NONE\"),\"\")","v":"Glitter Color"}]
["Options",null,null,{"$f":"IF('Data Entry Page'!C59>0,IF(OR('Data Entry Page'!C59=\"Clear Protective Coating\",'Data Entry Page'!C59=\"Glitter Color\",'Data Entry Page'!C59=\"Dangler\",'Data Entry Page'!C59=\"Bobble Head\",'Data Entry Page'!C59=\"3-D Mold\",'Data Entry Page'!C59=\"Cutouts\",'Data Entry Page'!C59=\"Presentation Case\"),'Data Entry Page'!C59,\"NONE\"),\"\")","v":""}]
["Options",null,null,{"$f":"IF('Data Entry Page'!C60>0,IF(OR('Data Entry Page'!C60=\"Slidder\",'Data Entry Page'!C60=\"Blinker\",'Data Entry Page'!C60=\"Spinner\",'Data Entry Page'!C60=\"Springer\"),'Data Entry Page'!C60,\"NONE\"),\"\")","v":"Spinner"}]
["Coin Edging",null,null,{"$f":"IF('Data Entry Page'!C61>0,'Data Entry Page'!C61,\"\")","v":""}]
["Back Stamping",null,null,{"$f":"IF('Data Entry Page'!C62>0,'Data Entry Page'!C62,\"\")","v":"Yes"},{"$f":"IF('Data Entry Page'!C62=\"YES\",\"use the following backstamp\",\"\")","v":"use the following backstamp"},"WWW.TRADINGPINS4LESS.COM"]
["Colors",null,null,{"$f":"IF('Data Entry Page'!C63>0,'Data Entry Page'!C63,\"\")","v":"White, 187 glitter, black"},"colors",null,null,null,null,null,""]
["Proof Number",null,null,{"$f":"IF('Data Entry Page'!C64>0,'Data Entry Page'!C64,\"\")","v":"3D (spinner)"}]
[]
[]
["See attached Artwork"]
["Each item to be individually poly-bagged in zip-lock style bags."]
["Please ship using our FedEx account number 414008143"]
[{"$f":"IF('Data Entry Page'!C48=0,\"Please Ship using International Priority\",\"Please Ship using International Priority EXPRESS \")","v":"Please Ship using International Priority"}]
[{"$f":"IF('Data Entry Page'!G5=\"\",\"Please produce in (10) business days or less.\",\"\")","v":""}]
["Deliver to the customer at the following address;"]
[]
[{"$f":"'Data Entry Page'!B24","v":"David Pruitt"}]
[{"$f":"IF('Data Entry Page'!B25=\"c/o or company\",\"\",'Data Entry Page'!B25)","v":"Arizona Baseball Club\t\t"}]
[{"$f":"'Data Entry Page'!B26","v":"7573 W. Navigator Lane"}]
[{"$f":"IF('Data Entry Page'!B27=\"address\",\"\",'Data Entry Page'!B27)","v":0}]
[{"$f":"'Data Entry Page'!B28","v":"Peoria"}]
[{"$f":"'Data Entry Page'!B29","v":"AZ"}]
[{"$f":"'Data Entry Page'!B30","v":85383}]
[]
["Thank you."]
[]
["Tom Welch"]
["Lightsaber Promotions"]
["1 706 745 4888"]

{"sheet":"Front Office","index":4,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,5],[6,1,6,4],[7,1,7,4],[21,3,21,6],[22,3,22,6]]}
[{"$f":"'Data Entry Page'!A1:F1","v":"PINS & COINS  Order Completion Checklist"}]
[]
["Website","Sales","Approved By:","Previous Customer",{"$f":"'Data Entry Page'!E4","v":0},"Quote Only: ",{"$f":"'Data Entry Page'!G4","v":0}]
[{"$f":"'Data Entry Page'!A5","v":"TP4L"},{"$f":"'Data Entry Page'!B5","v":"DT"},{"$f":"'Data Entry Page'!C5","v":"MK,NS,JM"},"ReOrder: ",{"$f":"'Data Entry Page'!E5","v":" 26-50030"},"Ship Date:",{"$f":"'Data Entry Page'!G5","v":46115}]
[null,null,null,"Factory: ",{"$f":"'Data Entry Page'!E6","v":"MPE"}]
[null,"Internal Office Notes"]
[null,{"$f":"'Data Entry Page'!B8:E8","v":0}]
[null,{"$f":"'Data Entry Page'!B9:E9","v":"LSP"}]
[]
["filed as :",{"$f":"'Data Entry Page'!B11","v":"Arizona Baseball #7 - David Pruitt"}]
["Customer Name",{"$f":"'Data Entry Page'!B13","v":"Arizona Baseball Club"},null,"Email",{"$f":"'Data Entry Page'!B15","v":"admin@arizonabbc.com"}]
["contact name",{"$f":"'Data Entry Page'!B14","v":"David"},null,"Phone ",{"$f":"'Data Entry Page'!B16","v":"602 509 1996"}]
[]
["Customer Bill To:",{"$f":"'Data Entry Page'!B18","v":"Arizona Baseball Club\t\t"},null,"Customer Ship To:",{"$f":"'Data Entry Page'!B25","v":"Arizona Baseball Club\t\t"},null,"PO / Check # ",{"$f":"'Data Entry Page'!B32","v":0}]
[null,{"$f":"'Data Entry Page'!B19","v":"7573 W. Navigator Lane"},null,null,{"$f":"'Data Entry Page'!B26","v":"7573 W. Navigator Lane"},null,"Credit Card #",{"$f":"'Data Entry Page'!B33","v":"4246315257889988"}]
[null,{"$f":"'Data Entry Page'!B20","v":0},null,null,{"$f":"'Data Entry Page'!B27","v":0},null,"Expiration date",{"$f":"'Data Entry Page'!B34","v":"12"}]
[null,{"$f":"'Data Entry Page'!B21","v":"Peoria"},null,null,{"$f":"'Data Entry Page'!B28","v":"Peoria"},null,"Security Code",{"$f":"'Data Entry Page'!B35","v":"790"}]
[null,{"$f":"'Data Entry Page'!B22","v":"AZ"},null,null,{"$f":"'Data Entry Page'!B29","v":"AZ"}]
[null,{"$f":"'Data Entry Page'!B23","v":85383},null,null,{"$f":"'Data Entry Page'!B30","v":85383}]
[]
[null,null,null,"ADDITIONAL FACTORY INSTRUCTIONS"]
["TOTAL QUANTITY",{"$f":"'Data Entry Page'!C37","v":360},null,{"$f":"'Data Entry Page'!D38:G38","v":"Ship on or before April 3rd 2026."}]
["TOTAL SALE",{"$f":"'Data Entry Page'!C38","v":1368},null,{"$f":"'Data Entry Page'!D39:G39","v":0}]
["variations",{"$f":"'Data Entry Page'!C39","v":1}]
[]
[]
["Unit Price",null,{"$f":"'Data Entry Page'!C44","v":3.8}]
[]
["Discount %",null,{"$f":"'Data Entry Page'!C45","v":0}]
["GA County Sales Tax    ",null,{"$f":"'Data Entry Page'!C46","v":0}]
["Additional Fees",null,{"$f":"'Data Entry Page'!C48","v":0}]
[]
["Total Delivered Price",null,{"$f":"'Data Entry Page'!C49","v":1368}]
[]
["Quantity",null,{"$f":"'Data Entry Page'!C51","v":360}]
["Product","(pulldown menu)",{"$f":"'Data Entry Page'!C52","v":"Trading Pin"}]
["Type","(pulldown menu)",{"$f":"'Data Entry Page'!C53","v":"Cloisonne Soft Enamel"}]
["Size",null,{"$f":"'Data Entry Page'!C54","v":"1.75\""}]
["Backing","(pulldown menu)",{"$f":"'Data Entry Page'!C55","v":"2 Rubber Clutch"}]
["Plating","(pulldown menu)",{"$f":"'Data Entry Page'!C56","v":"Die Black Metal"}]
["Epoxy","(pulldown menu)",{"$f":"'Data Entry Page'!C57","v":"No"}]
["Options","(pulldown menu)",{"$f":"'Data Entry Page'!C58","v":"Glitter Color"}]
["Options","(pulldown menu)",{"$f":"'Data Entry Page'!C59","v":0}]
["Options","(pulldown menu)",{"$f":"'Data Entry Page'!C60","v":"Spinner"}]
["Coin Edging","(pulldown menu)",{"$f":"'Data Entry Page'!C61","v":0}]
["Back Stamping","(yes/no)",{"$f":"'Data Entry Page'!C62","v":"Yes"}]
["Colors","# OF COLORS",{"$f":"'Data Entry Page'!C63","v":"White, 187 glitter, black"}]
["Proof Number",null,{"$f":"'Data Entry Page'!C64","v":"3D (spinner)"}]

{"sheet":"Macro Data","index":5,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,"CUSTOMER CORRESPONDANCE SHEET"]
[]
[null,"Quantity","IF('Data Entry Page'!C50>0,'Data Entry Page'!C50,\"\")"]
[null,"Product","IF('Data Entry Page'!C50>0,'Data Entry Page'!C51,\"\")"]
[null,"Type","IF('Data Entry Page'!C50>0,'Data Entry Page'!C52,\"\")"]
[null,"Size","IF('Data Entry Page'!C50>0,'Data Entry Page'!C53,\"\")"]
[null,"Backing","IF('Data Entry Page'!C50>0,'Data Entry Page'!C54,\"\")"]
[null,"Plating","IF('Data Entry Page'!C50>0,'Data Entry Page'!C55,\"\")"]
[null,"Options (1)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C56=\"Clear Protective Coating\",'Data Entry Page'!C56=\"Glitter Color\",'Data Entry Page'!C56=\"Dangler\",'Data Entry Page'!C56=\"Bobble Head\",'Data Entry Page'!C56=\"3-D Mold\",'Data Entry Page'!C56=\"Cutouts\",'Data Entry Page'!C56=\"Presentation Case\"),'Data Entry Page'!C56,\"NONE\"),\"\")"]
[null,"Options (2)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C57=\"Clear Protective Coating\",'Data Entry Page'!C57=\"Glitter Color\",'Data Entry Page'!C57=\"Dangler\",'Data Entry Page'!C57=\"Bobble Head\",'Data Entry Page'!C57=\"3-D Mold\",'Data Entry Page'!C57=\"Cutouts\",'Data Entry Page'!C57=\"Presentation Case\"),'Data Entry Page'!C57,\"NONE\"),\"\")"]
[null,"Options (3)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C58=\"Clear Protective Coating\",'Data Entry Page'!C58=\"Glitter Color\",'Data Entry Page'!C58=\"Dangler\",'Data Entry Page'!C58=\"Bobble Head\",'Data Entry Page'!C58=\"3-D Mold\",'Data Entry Page'!C58=\"Cutouts\",'Data Entry Page'!C58=\"Presentation Case\"),'Data Entry Page'!C58,\"NONE\"),\"\")"]
[null,"Options (4)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C58=\"Slidder\",'Data Entry Page'!C58=\"Blinker\",'Data Entry Page'!C58=\"Spinner\",'Data Entry Page'!C58=\"Springer\"),'Data Entry Page'!C58,\"NONE\"),\"\")"]
[null,"Coin Edging","IF('Data Entry Page'!C50>0,'Data Entry Page'!C60,\"\")"]
[]
[null,"Colors","IF('Data Entry Page'!C50>0,'Data Entry Page'!C62,\"\")"]
[null,"Proof Number","IF('Data Entry Page'!C50>0,'Data Entry Page'!C63,\"\")"]
[]
[]
[null,"FOR FACTORY ORDER SHEET"]
[]
[null,"Quantity","IF('Data Entry Page'!C50>0,'Data Entry Page'!C50,\"\")"]
[null,"Product","IF('Data Entry Page'!C50>0,'Data Entry Page'!C51,\"\")"]
[null,"Type","IF('Data Entry Page'!C50>0,IF('Data Entry Page'!C52=\"Cloisonne\",\"Epola\",IF('Data Entry Page'!C52=\"Cloisonne Soft Enamel\",\"Iron Soft Enamel\",'Data Entry Page'!C52)),\"\")"]
[null,"Size","IF('Data Entry Page'!C50>0,'Data Entry Page'!C53,\"\")"]
[null,"Backing","IF('Data Entry Page'!C50>0,'Data Entry Page'!C54,\"\")"]
[null,"Plating","IF('Data Entry Page'!C50>0,IF('Data Entry Page'!C55=\"18k Gold\",\"Bronze\",IF('Data Entry Page'!C55=\"Polished Silver\",\"Nickle\",'Data Entry Page'!C55)),\"\")"]
[null,"Options (1)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C56=\"Clear Protective Coating\",'Data Entry Page'!C56=\"Glitter Color\",'Data Entry Page'!C56=\"Dangler\",'Data Entry Page'!C56=\"Bobble Head\",'Data Entry Page'!C56=\"3-DMold\",'Data Entry Page'!C56=\"Cutouts\",'Data Entry Page'!C56=\"Presentation Case\"),'Data Entry Page'!C56,\"NONE\"),\"\")"]
[null,"Options (2)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C57=\"Clear Protective Coating\",'Data Entry Page'!C57=\"Glitter Color\",'Data Entry Page'!C57=\"Dangler\",'Data Entry Page'!C57=\"Bobble Head\",'Data Entry Page'!C57=\"3-D Mold\",'Data Entry Page'!C57=\"Cutouts\",'Data Entry Page'!C57=\"Presentation Case\"),'Data Entry Page'!C57,\"NONE\"),\"\")"]
[null,"Options (3)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C58=\"Clear Protective Coating\",'Data Entry Page'!C58=\"Glitter Color\",'Data Entry Page'!C58=\"Dangler\",'Data Entry Page'!C58=\"Bobble Head\",'Data Entry Page'!C58=\"3-D Mold\",'Data Entry Page'!C58=\"Cutouts\",'Data Entry Page'!C58=\"Presentation Case\"),'Data Entry Page'!C58,\"NONE\"),\"\")"]
[null,"Options (4)","IF('Data Entry Page'!C50>0,IF(OR('Data Entry Page'!C58=\"Slidder\",'Data Entry Page'!C58=\"Blinker\",'Data Entry Page'!C58=\"Spinner\",'Data Entry Page'!C58=\"Springer\"),'Data Entry Page'!C58,\"NONE\"),\"\")"]
[null,"Coin Edging","IF('Data Entry Page'!C50>0,'Data Entry Page'!C60,\"\")"]
[null,"Back Stamping","IF('Data Entry Page'!C50>0,'Data Entry Page'!C61,\"\")"]
[null,"Colors","IF('Data Entry Page'!C50>0,'Data Entry Page'!C62,\"\")"]
[null,"Proof Number","IF('Data Entry Page'!C50>0,'Data Entry Page'!C63,\"\")"]