{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Hawaii","Instructions","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","Idx","DC_LIST"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Hawaii","index":0,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,7,0,10]]}
[null,null,null,null,null,"HI List \n(HI is the only DC option)",null,"New Retail Zone "]
["Item#","Item Description","New Total Unit Cost","Effective Date","Retail Recommendation","DC List","Comments",48,49,50,51]
[null,null,null,null,null,"HI"]

{"sheet":"Instructions","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,3],[14,2,15,2],[4,2,4,3]]}
["Version 4",null,"Cost of Goods/Retail Change - Hawaii Form"]
[]
[]
[null,null,"Instructions"]
[null,null,"1 - Supplier fills out fields Item#, Description, New Total Unit Cost and Effective Date (at least 90 days in the future) and sends form to a Category Manager (CM)"]
[null,null,"2 - CM populates the remaining fields.  "]
[]
[]
[null,null,"IMPORTANT!!!  \nClick ENABLE CONTENT button before starting"]
[]
[null,null,"Field on Form","Description of Field "]
[null,null,"Item#","Enter valid CVS item#"]
[null,null,"Item Description","Enter the product description"]
[null,null,"New Total Unit Cost","Enter the New Total Unit Cost.  Cost can NOT be more than three decimals"]
[null,null,"Effective Date","1 - Effective date entered must be in the future >90 days (Supplier)"]
[null,null,null,"2 - 'Invalid Date' will show if entered is a Sunday, Monday, or the day after a CVS Corporate holiday as these are systematically invalid options.  A date highlighted in yellow is < 30 days"]
[null,null,"Retail Recommendation","Select from drop down"]
[null,null,"Zone Pricing","OPTIONAL -- Enter new Retail Price. Retail can NOT be more than two decimals"]
[null,null,"DC List","HI is the only DC option"]
[null,null,"Comments","OPTIONAL -- Add additional comments"]
[]
[]
[null,null,"Data Entry Field"]

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

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet4","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

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

{"sheet":"Sheet6","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Idx","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DC_LIST","index":8,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["DC_ID","DC_NAME"]
["AW-All DC","All DC"]
["DT","Novi"]
["IN","Indianapolis"]
["MA","Fredericksburg"]
["NJ","Lumberton"]
["PA","Somerset"]
["SC","N. Augusta"]
["TN","Knoxville"]
["WN","Woonsocket"]
["AL","Bessemer"]
["EN","Ennis"]
["CR","Conroe"]
["OR","Orlando"]
["LA","LaHabra"]
["UC","Patterson"]
["HI","Hawaii"]
["BV","Arizona"]
["FL","Vero Beach"]
["RC","PUERTO RICO         "]
["YK","Chemung"]