{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover Page","Accessory File","DropDown Lists","Financial Groups"],"not_rendered":{"charts":0,"images":2,"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":"Cover Page","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,4,5,18],[17,3,23,19]]}
[]
[]
[null,null,null,null,"Master Accessory Load File"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Instructions:\n1. *First Time Upload* - Please paste frame data into the 'Acessory File' tab starting on cell A12. Right click and use \"Paste Values\" in order to retain validation formatting.\n2. The Accessory File tab has formatting to help easily display when data is missing. If a cell within the pasted data is showing a light red color, required data is missing. If a light blue fill appears in your data, a \"zero\" measurement needs to be corrected. If a light yellow color appears, this is missing optional data, data missing in those columns is not required for upload.\n3. Row 8 contains a data check field that will compare the total number of entries in Column A against all other columns in the tab. If all columns show a green 'valid' text, the column is not missing data in a cell in that column. If 'missing data' appears in red, please check the column where the the missing data cell is shown and look for light red cells."]

{"sheet":"Accessory File","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,1,2],[5,2,6,2],[3,2,4,2],[3,3,4,3],[5,3,6,3],[0,3,1,3]]}
[null,null,"Data Check"]
[]
[null,null,"Empty Cells:",0]
[null,null,"Total Number of Accessories Submitted:",0]
[]
[null,null,"Number of cells that contain a \"0\" value:",7]
[]
[]
[]
[]
[]
["Data Check:",{"$f":"IF($A$13=B13, \"Valid\", \"Missing Data\")","v":"Valid"},{"$f":"IF($A$13=C13, \"Valid\", \"Missing Data\")","v":"Valid"},"Valid","Valid","Valid","Valid",{"$f":"IF($A$13=H13, \"Valid\", \"Optional Missing Data\")","v":"Valid"},{"$f":"IF($A$13=I13, \"Valid\", \"Optional Missing Data\")","v":"Valid"},"Valid","Valid","Valid","Valid"]
[{"$f":"COUNTIF(A16:A200000,\"*?\")","v":0},{"$f":"COUNTIF(B16:B200000,\">0\")","v":0},{"$f":"COUNTIF(C16:C200000,\">0\")","v":0},{"$f":"COUNTIF(D16:D200000,\"*?\")","v":0},0,0,{"$f":"COUNTIF(G16:G200000,\">0\")","v":0},{"$f":"COUNTIF(H16:H200000,\">0\")","v":0},0,0,0,{"$f":"COUNTIF(L16:L200000,\">0\")","v":0},{"$f":"COUNTIF(M16:M200000,\"*?\")","v":0}]
["Item Name","Default Cost","Item Number","UPC #","Item Status","Vendor","Default Retail Price","Retail Price 2","Retail Price 3","Retail Price 4","Retail Price 5","Company ID","Financial Group Name"]
["Name that will be seen in POS.  Users select from a drop down window, and items will be populated alphabetically.  Depending on number of items to scroll thru, it is often helpful to use a naming convention to group them together.\n\nData Type: CHAR","This is your cost for reporting if using COGS.   (Vendor Cost)\n\nData Type: DEC (5,2)","Alphanumeric Unique Identifier for this Accessory.  Does not need to be the same as UPC but can be.\n\nData Type: CHAR","UPC Code\n\nData Type: INT","We support:\nActive\nRecall\nDiscontinued\n\nSelect from Drop Down List or leave empty if you do not want a status on the item.\n\nData Type: CHAR\n\n","User must create vendor name.  Load process will associate vendor with this item.  If vendor has not already been created in the database, user will have to manually map vendor to item.\n\nData Type: CHAR","Data Type: DEC (5,2)","Data Type: DEC (5,2)","Data Type: DEC (5,2)","Data Type: DEC (5,2)","Data Type: DEC (5,2)","Eyefinity will provide the ID to you.\nData Type: CHAR","Optional: \nFinancial groups are used to create groupings of similar product for GL reporting.  Examples could include 'Consignment', 'Private Lable' but can be used as you wish.\n\nEnter your Master List of Frame Financial Groups on the Financial Groups tab of this document.\n\nData Type: CHAR"]

{"sheet":"DropDown Lists","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Item Status"]
["Active"]
["Recall"]
["Discontinue"]

{"sheet":"Financial Groups","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Financial Group Name"]