{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Merchandising Configurator","Drop Down"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Merchandising Configurator","index":0,"n_rows":79,"n_cols":5,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,1,78,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[77,1,77,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[71,1,71,2],[72,1,72,2],[73,1,73,2],[58,1,58,2],[69,1,69,2],[70,1,70,2],[64,1,64,2],[65,1,65,2],[57,1,57,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[34,1,34,2],[39,1,39,2],[28,1,28,2],[40,1,40,2],[33,1,33,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[52,1,52,2],[17,1,17,2],[46,1,46,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[19,1,19,2],[20,1,20,2],[38,1,38,2],[41,1,41,2],[53,1,53,2],[42,1,42,2],[18,1,18,2],[21,1,21,2],[50,1,50,2],[51,1,51,2]]}
["Total Number 1.2m spaces"]
["Configuration"]
["Number of panels with \nA4 advertising"]
["Number of items (SKU) \nto display"]
["Approval Number"]
[]
[]
[]
[]
[]
["R6","2021-11-10"]
[]
[]
[]
[]
[]
["DISPLAY SYSTEM"]
["Part Number","Description",null,"Quantity"]
["PM0107-REV0","Plasson Merchandising System Hardware Box 1 (1xPost)",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",B1+1)","v":""}]
["PM0105-REV0","Plasson Merchandising System Hardware Box 2 (Header)",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",IF(B2=\"SIDE BY SIDE\",B1,2*B1))","v":""}]
["PM0106-REV0","Plasson Merchandising System Hardware Box 3 (Rails)",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",B1)","v":""}]
["PM0035-REV0","Plasson Merchandising System Foot",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",IF(B2=\"SIDE BY SIDE\",0,2))","v":""}]
["PM0015-REV0","Plasson Merchandising System Back Panels",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",IF(B2=\"SIDE BY SIDE\",B1,2*B1))","v":""}]
["PM0016-REV1","Plasson Merchandising System Large Baskets",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",IF(B2=\"SIDE BY SIDE\",((B1-B3)*10)+(B3*6),((2*B1-B3)*10)+(B3*6)))","v":""}]
["PM0017-REV1","Plasson Merchandising System Small Baskets",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",(B3*4))","v":""}]
["PM0018-REV1","Plasson Merchandising System Basket Dividers",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",IF(B4<(D24+D25),0,B4-D24-D25))","v":""},"*"]
["PM0019-REV2","Plasson Merchandising System Label Clips",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",B4)","v":""},"*"]
["PM0020-REV0","Plasson Merchandising System A4 Acrylic Advertising Holder",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",B3*4)","v":""}]
["PM0068-REV0","Merchandising Installation Instructions",null,{"$f":"IF(OR(B1=\"\",B2=\"\",B3=\"\",B4=\"\"),\"\",1)","v":""}]
[null,"*","Extra may be required for contingency"]
[]
[]
["A4 ADVERTISING",null,"Maximum Total Number",{"$f":"IF(B3=\"\",\"\",B3*4)","v":""}]
["Part Number","Description",null,"Quantity"]
["PM0050-REV1","Best Under Pressure"]
["PM0052-REV1","Metric Installation 16-63mm"]
["PM0053-REV1","Metric Installation 75-125mm"]
["PM0054-REV1","Rural Installation"]
["PM0055-REV1","Universal Fittings"]
["PM0056-REV1","Reducing Sets"]
["PM0057-REV1","PE-Cooper"]
["PM0059-REV0","Smartphone Bluetooth"]
["PM0141-REV0","Conversion Kits"]
[]
[]
["LABELS"]
["Part Number","Description",null,"Quantity"]
["PM0098-REV1","METRIC Merchandising Cards"]
["PM0099-REV1","BSP Merchandising Cards"]
["PM0100-REV1","RURAL Merchandising Cards"]
["PM0101-REV1","BALL VALVE Merchandising Cards"]
["PM0102-REV1","TAPPING SADDLE Merchandising Cards"]
["PM0142-REV0","EF Merchandising Cards"]
["PM0143-REV0","Generic (Blank) Merchandising Cards"]
[]
[]
["POSTERS"]
["Part Number","Description",null,"Quantity"]
["PM0074-REV2","Rural Hand"]
["PM0128-REV2","Electrofusion Group"]
["PM0129-REV2","Rural Group"]
["PM0130-REV2","SIMONA Group"]
["PM0131-REV2","Threaded Group"]
["PM0132-REV2","Metric Group"]
["PM0133-REV2","Rural Quote"]
["PM0085-REV0","Rural Hand Angel"]
[]
[]
["A4 PRINTS"]
["Part Number","Description",null,"Quantity"]
["PM0050-REV1","Best Under Pressure"]
["PM0052-REV1","Metric Installation 16-63mm"]
["PM0053-REV1","Metric Installation 75-125mm"]
["PM0054-REV1","Rural Installation"]
["PM0055-REV1","Universal Fittings"]
["PM0056-REV1","Reducing Sets"]
["PM0057-REV1","PE-Cooper"]
["PM0059-REV1","Smartphone Bluetooth"]
["PM0141-REV0","Conversion Kits"]

{"sheet":"Drop Down","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["SIDE BY SIDE"]
["BACK TO BACK"]