{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Read Me First","Device_Cabinet_Data","Cabinet Features","Cabinet Dimensions","AMS-Features","Configurator","Sheet1"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":1,"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":"Read Me First","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,1,26,2],[28,1,28,2],[30,1,30,2],[32,1,32,2],[36,1,36,2],[27,1,27,2],[23,5,23,8],[24,5,24,8],[25,5,25,8],[1,1,1,2],[2,1,2,2],[4,1,4,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[10,1,10,2],[21,1,21,2],[23,1,23,2],[25,1,25,2]]}
[]
[null,"Intelligent Cabinets configurator"]
[null,"Note: Latest version of this downloadable Configurator is stored on Solutions Pathway"]
[]
[null,"Preparation"]
[]
[null,"Examine the \"Cabinet Features\" Sheet to understand the Cabinets hardware features"]
[null,"The \"Cabinet Dimensions\" Sheet provides images of Cabinet size options and dimension details."]
[null,"Read the \"AMS-Features\" Sheet to get an understanding of what the Access Management System features and benefits are."]
[]
[null,"  Data Input and Preparing your quote"]
[]
[null,"Step 1:","Enter key customer details: Quantity of Devices, Region and choose Device type and Charger"]
[null,"Step 2:","Enter Zebra Access Management System (ZAMS) requirements"]
[null,"              ","Choose other options: Cradle Locks, Stadium Shelves, Cabinet Base unit"]
[null,"Step 3:","Use the Configurator Tool to generate a SKU list to create your quote"]
[null,"Step 4:","Ensure Shipping is quoted "]
[null,null,"For Zebra shipping quotes, request via PS Bid & Quote"]
[null,"Step 5:","Add services required for installation / Deployment."]
[null,null,"For Zebra PS quotes, request via PS Bid and Quote (with their install quick-quote tool)"]
[]
[null,"The configurator will automatically update associated options and recommendation information "]
[]
[null,"  Recommended Configuration"]
[]
[null,"The recommended configuration is \nshown in the dark grey box: "]
[null," Alternative considerations and \nconfiguration are shown in \nthe boxes below."]
[]
[null,"If you require support with alternative configurations, including multiple device types per cabinet, please contact your Zebra Account Manager or Solution Sales Specialist"]
[]
[null,"  Preparing your quote:  Bill Of Materials and SKU List"]
[]
[null,"A Bill Of Materials (BOM) is generated, including SKUs and quantities.  This information can be used to generate a quote using Partner Gateway / Solution Pathway."]
[]
[]
[]
[null,"IC Cabinet Configurator V1"]

{"sheet":"Device_Cabinet_Data","index":1,"n_rows":141,"n_cols":34,"rows_kept":141,"cut":false,"hidden":true,"merged":[[1,0,1,31],[55,0,55,20],[43,0,43,20],[66,5,66,9],[66,12,66,17],[66,19,66,21],[76,0,76,6],[76,8,76,14],[76,18,76,19],[67,23,67,24],[66,0,66,3],[103,0,103,5],[82,16,82,20],[98,0,98,2],[91,0,91,1],[91,3,91,6],[91,13,91,15],[91,8,91,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,9,55,60]
["Table 813"]
[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,31,32,33,34]
["Device","Cradle Lock Compatible","Unit Value","Toaster Option","Devices Per Cradle","Device \nDepth","Compact \nCL","Compact\n No CL","Small\nCL","Small\nNo CL","Midi\nCL","Midi\nNo CL","Large\nCL","Large\nNo CL","X-Large\nCL","X-Large\nNo CL","Extreme\nCL","Extreme\nNo CL","Row Value","Stadium Compatible","Extra Shelf","Cradle Lock","Cradle Lock - Toaster","Cradle w/Toaster","Devices with Toaster","Pistol Grip Angle","Pistol Grip Straight","Devices per layer","Aux Bracket Rqd","Aux  € Bracket Price","Aux £  Bracket Price","Aux  $ Bracket Price","AMS Compatible","Shared Cradle"]
["None",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,0,0]
["EC30",0,5,0,10,1,10,10,40,40,60,60,100,100,120,120,240,240,1,1,1,null,null,0,0,0,0,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T6+1)","v":20},null,null,null,null,1,1]
["EC50",0,5,0,5,1,5,5,20,20,30,30,50,50,60,60,120,120,2,1,1,null,null,0,0,1,0,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T7+1)","v":10},null,null,null,null,1,1]
["EC55",0,5,0,5,1,5,5,20,20,30,30,50,50,60,60,120,120,3,1,1,null,null,0,0,1,0,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T8+1)","v":10},null,null,null,null,1,1]
["TC20",1,5,0,5,1,5,5,20,20,25,30,45,50,50,60,100,120,4,1,1,"CS-CRD-LOC-TC2",null,0,0,0,1,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T9+1)","v":10},null,null,null,null,1,1]
["TC25",1,5,0,5,1,5,5,20,20,25,30,45,50,50,60,100,120,5,1,1,"CS-CRD-LOC-TC2",null,0,0,0,1,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T10+1)","v":10},null,null,null,null,1,1]
["TC21",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,6,1,0,"CS-CRD-LOC-TC2",null,1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T11+1)","v":10},null,null,null,null,1,1]
["TC26",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,7,1,0,"CS-CRD-LOC-TC2",null,1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T12+1)","v":10},null,null,null,null,1,1]
["TC50",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,8,1,0,"CS-CRD-LOC-TC5","CS-CRD-LOC-TC5-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T13+1)","v":10},null,null,null,null,1,1]
["TC51",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,9,1,0,"CS-CRD-LOC-TC5","CS-CRD-LOC-TC5-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T14+1)","v":10},null,null,null,null,1,1]
["TC52",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,9,1,0,"CS-CRD-LOC-TC5","CS-CRD-LOC-TC5-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T15+1)","v":10},null,null,null,null,1,1]
["TC56",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,10,1,0,"CS-CRD-LOC-TC5","CS-CRD-LOC-TC5-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T16+1)","v":10},null,null,null,null,1,1]
["TC57",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,11,1,0,"CS-CRD-LOC-TC5","CS-CRD-LOC-TC5-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T17+1)","v":10},null,null,null,null,1,1]
["TC70",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,12,1,0,"CS-CRD-LOC-TC7","CS-CRD-LOC-TC7-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T18+1)","v":10},null,null,null,null,1,1]
["TC72",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,13,1,0,"CS-CRD-LOC-TC7","CS-CRD-LOC-TC7-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T19+1)","v":10},null,null,null,null,1,1]
["TC75",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,14,1,0,"CS-CRD-LOC-TC7","CS-CRD-LOC-TC7-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T20+1)","v":10},null,null,null,null,1,1]
["TC77",1,5,1,5,1,5,5,20,20,25,30,35,40,40,50,80,100,15,1,0,"CS-CRD-LOC-TC7","CS-CRD-LOC-TC7-T",1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T21+1)","v":10},null,null,null,null,1,1]
["TC8000",0,5,1,5,2,0,0,15,15,20,20,25,25,30,30,60,60,16,0,1,null,null,1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T22+1)","v":5},"BRKT-SCRD-MSDK-01",89,78.900000000000006,112,1,1]
["TC8300",0,5,1,5,2,0,0,15,15,20,20,25,25,30,30,60,60,17,0,1,null,null,1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T23+1)","v":5},"BRKT-SCRD-MSDK-01",89,78.900000000000006,112,1,1]
["MC2200",0,5,1,5,1,5,5,15,15,15,15,20,20,25,25,50,50,18,0,0,null,null,1,4,1,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T24+1)","v":5},null,null,null,null,1,1]
["MC2700",0,5,1,5,1,5,5,15,15,15,15,20,20,25,25,50,50,18,0,0,null,null,1,4,1,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T25+1)","v":5},null,null,null,null,1,1]
["MC3300S",0,5,1,5,1,0,0,10,10,15,15,20,20,25,25,50,50,18,0,0,null,null,1,4,1,0,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T26+1)","v":5},null,null,null,null,1,1]
["MC3300T",0,5,1,5,1,0,0,10,10,15,15,20,20,25,25,50,50,19,0,0,null,null,1,4,1,0,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T27+1)","v":5},null,null,null,null,1,1]
["MC3300G",0,5,1,5,2,0,0,10,10,15,15,20,20,25,25,50,50,20,0,0,null,null,1,4,1,0,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T28+1)","v":5},null,null,null,null,1,1]
["MC9300",0,5,0,4,2,0,0,8,8,12,12,16,16,16,16,32,32,21,0,0,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T29+1)","v":4},null,null,null,null,1,1]
["WT6000",0,5,1,5,1,5,5,20,20,30,30,40,40,50,50,100,100,22,1,0,null,null,1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T30+1)","v":10},null,null,null,null,1,1]
["WT6300",0,5,1,5,1,5,5,20,20,30,30,40,40,50,50,100,100,23,1,0,null,null,1,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T31+1)","v":10},null,null,null,null,1,1]
["ZQ210",0,5,0,4,1,4,4,16,16,24,24,32,32,40,40,80,80,24,1,0,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T32+1)","v":8},null,null,null,null,0,1]
["ZQ310",0,5,0,4,1,4,4,16,16,24,24,32,32,40,40,80,80,25,1,0,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T33+1)","v":8},null,null,null,null,0,1]
["ZQ320",0,5,0,5,1,5,5,20,20,30,30,40,40,50,50,100,100,26,1,0,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T34+1)","v":10},null,null,null,null,0,1]
["ZQ620",0,5,0,4,1,0,0,16,16,24,24,32,32,40,40,80,80,27,1,0,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T35+1)","v":8},null,null,null,null,0,0]
["ZQ630",0,5,0,4,1,0,0,16,16,24,24,32,32,40,40,80,80,28,1,0,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T36+1)","v":8},null,null,null,null,0,0]
["QLN4x",0,5,0,3,1,3,3,12,12,18,18,24,24,30,30,60,60,29,1,0,null,null,0,0,null,null,6,null,null,null,null,0,1]
["ET5x-Windows",0,5,0,4,2,0,0,12,12,16,16,20,20,24,24,48,48,30,0,1,null,null,0,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T38+1)","v":4},null,null,null,null,0,1]
["ET5x-Android",0,5,0,4,2,0,0,12,12,16,16,20,20,24,24,48,48,30,0,1,null,null,0,4,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T39+1)","v":4},null,null,null,null,1,1]
["RS5100",0,5,0,20,1,20,20,80,80,120,120,200,200,240,240,480,480,31,1,1,null,null,0,0,null,null,{"$f":"Table813[[#This Row],[Devices Per Cradle]]*(T40+1)","v":40},null,null,null,null,0,1]
[]
[null,null,null,null,null,null," (Cradle lock Yes Column N/No Column N-1  )   If  Stadium =\"No\" /2) * Toaster"]
[]
["Table 10"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Cabinet Options","SKU","Cabinet Base","CC6-Bracket","CC600 Bracket\n€ Price","CC600 Bracket\n£ Price","CC600 Bracket $ Price","Stadium Compatible","Stadium SKU","Stadium\n€ Price","Stadium\n£ Price","Stadium\n$ Price","Std Shelves Shipped","Standard Shelf SKU","Std Shelf\n€ Price","Std Shelf\n£ Price","Std Shelf\n$ Price","Short IEC","Long IEC","Height Factor","Base Compatible","Cabinet Base \n€ Price","Cabinet Base\n£ Price","Cabinet Base \n$ Price","No of IEC Sockets"]
["Compact","CS-CAB-1",0,"CS-CAB-MNTG-C6",78.400000000000006,68.72,86.15,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0]
["Small","CS-CAB-2","CS-CAB-BSE","CS-CAB-MNTG-C6",78.400000000000006,68.72,86.15,1,"CS-CAB-SHV-SS",79.8,69.95,87.69,1,"CS-CAB-SHV",98,85.9,107.69,2,0,10,1,448,392.7,492.31,14]
["Midi","CS-CAB-3","CS-CAB-BSE","CS-CAB-MNTG-C6",78.400000000000006,68.72,86.15,1,"CS-CAB-SHV-SS",79.8,69.95,87.69,2,"CS-CAB-SHV",98,85.9,107.69,2,1,14,1,448,392.7,492.31,14]
["Large","CS-CAB-4","CS-CAB-BSE","CS-CAB-MNTG-C6-R1",221.54,194.19,246.15,1,"CS-CAB-SHV-SS",79.8,69.95,87.69,3,"CS-CAB-SHV",98,85.9,107.69,3,1,18,1,448,392.7,492.31,14]
["X-Large","CS-CAB-5XL","Not Compatible","CS-CAB-MNTG-C6-R2",221.54,194.19,246.15,1,"CS-CAB-SHV-SS",79.8,69.95,87.69,4,"CS-CAB-SHV",98,85.9,107.69,3,2,22,0,null,null,null,14]
["Extreme","CS-CAB-5-EXT","Not Compatible","CS-CAB-MNTG-C6-R2",221.54,194.19,246.15,1,"CS-CAB-SHV-EXT-SS",159.6,139.9,175.38,4,"CS-CAB-SHV-EXT",196.08,171.88,215.38,6,4,44,0,null,null,null,28]
[]
["Conversion Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"328 x 580 x 230","1012 x 700 x 437","1312 x 700 x 437","1612 x 700 x 437","1912 x 700 x 437","1912 x 700 x 437","1912 x 1200 x437"]
["Ft to Mtr",10.763999999999999]
["Table 13"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
["Cabinet","EMEA SKU","Cabinet\n€ Price","NA Bundled SKU","NA Bundle Price","NA -C6-Bundled SKU","NA-C6-Bundeled Price","APAC - SKU","APAC Cost","APAC-C6-Bundled","LATAM-No Bundle","LATAM-Bundled","LATAM-C6-Bundled","Floor Area\nSqr mtr","Wall Area","Weight","Wall area with Base","Cabinet\n£ Price","EMEA B-FLTPK SKU2","Cabinet-B-FLTPK € Price3","Cabinet-B-FLTPK-£ Price24"]
["Compact","CS-CAB-1-B",1075.7,"CS-CAB-1-B-N",1318.05,"CS-CAB-1-B-C6-N",2121.87,"n/a","n/a","n/a","n/a","n/a","n/a",0.13339999999999999,0.19023999999999999,11,0.19023999999999999,924.91,"CS-CAB-1-B-FLTPK",100,80]
["Small","CS-CAB-2-B",1506.5,"CS-CAB-2-B-N",1871.26,"CS-CAB-2-B-C6-N",2675.08,"n/a","n/a","n/a","n/a","n/a","n/a",0.30590000000000001,0.70840000000000003,22,0.91839999999999999,1320.53,"CS-CAB-2-B-FLTPK",2000,1800]
["Midi","CS-CAB-3-B",2216.6799999999998,"CS-CAB-3-B-N",2659.45,"CS-CAB-3-B-C6-N",3463.27,"n/a","n/a","n/a","n/a","n/a","n/a",0.30590000000000001,0.91839999999999999,44,1.1284000000000001,1943.04,"CS-CAB-3-B-FLTPK",30000,2800]
["Large","CS-CAB-4-B",2524.41,"CS-CAB-4-B-N",3000.72,"CS-CAB-4-B-C6-N",3804.75,"n/a","n/a","n/a","n/a","n/a","n/a",0.30590000000000001,1.1284000000000001,66,1.3384,2212.79,"CS-CAB-4-B-FLTPK",4000,3800]
["X-Large","CS-CAB-5XL-B",3481.88,"CS-CAB-5XL-B-N",4063.42,"CS-CAB-5XL-B-C6-N",4867.24,"n/a","n/a","n/a","n/a","n/a","n/a",0.30590000000000001,1.3384,88,1.3384,3052.06,"CS-CAB-5XL-B-FLTPK",5000,4800]
["Extreme","CS-CAB-5EXT-B",5743.08,"CS-CAB-5EXT-B-N",6468.07,"CS-CAB-5EXT-B-C6-N",7271.89,"n/a","n/a","n/a","n/a","n/a","n/a",0.52439999999999998,2.2944,120,2.2944,5034.13,"CS-CAB-5EXT-B-FLTPK",5500,4900]
[]
[]
["Table 1",null,null,null,null,"Table 4",null,null,null,null,null,null,"Table 2",null,null,null,null,null,null,"Table 11"]
["Device","Unit Value","Devices per cradle","Unit Depth",null,"SKU","€ Price","£ Price","$ Price",null,null,null,"Country","Cable SKU","Unit Price","Code","Currency","Area Unit",null,"Cabinet Factor","Cabinet Name","CC6-Bracket",null,"Table 3"]
["TC21",5,5,1,null,"CS-CAB-IEC",7.7,6.14,null,null,null,null,"United Kingdom","CS-CAB-UK-MLEAD",6.75,"UK","£","m²",null,10,"Compact","CS-CAB-MNTG-C6",null,"Optimal","Answer"]
["TC26",7.5,5,1,null,"CS-CAB-IEC-L",6.92,6.07,null,null,null,null,"Europe","CS-CAB-EU-MLEAD",7.7,"EU","€","m²",null,30,"Small","CS-CAB-MNTG-C6",null,"Optimal",1]
["TC52",7.5,5,1,null,"CS-CC6-IEC",7.7,6.75,null,null,null,null,"North America","CS-CAB-NA-MLEAD",10,"NA","$","Ft²",null,40,"Midi","CS-CAB-MNTG-C6",null,"All",0]
["TC77",7.5,5,1,null,"CS-CAB-NA-IEC",null,null,7.69,null,null,null,"Australia","CS-CAB-AU-MLEAD",99,"AU","$","m²",null,50,"Large","CS-CAB-MNTG-C6-R!"]
["MC3300",10,5,2,null,"CS-CAB-NA-IEC-L",null,null,7.69,null,null,null,null,null,null,null,null,null,null,60,"X-Large","CS-CAB-MNTG-C6-R2"]
["MC9300",12,4,2,null,"CS-CC6-NA-IEC",null,null,8.4600000000000009,null,null,null,null,null,null,null,null,null,null,120,"Extreme","CS-CAB-MNTG-C6-R2"]
["TC8300",10,5,2]
[]
["Table 8",null,null,null,null,null,null,null,"Table 9",null,null,null,null,null,null,null,null,null,"Table 7"]
["Column1","Compact","Small","Midi","Large","X-Large","Extreme",null,"Column1","Compact","Small","Midi","Large","X-Large","Extreme",null,null,null,"Top or Side","Answer"]
["TC20",5,30,40,50,60,120,null,"TC20",5,20,30,40,50,100,null,null,null,"Top","T"]
["TC21",5,30,30,40,50,100,null,"TC21",5,20,30,40,50,100,null,null,null,"Side","S"]
["TC26",5,20,30,40,50,100,null,"TC26",5,20,30,40,50,100]
["TC50",5,20,30,40,50,100,null,"TC50",5,20,30,40,50,100]
["TC56",5,20,30,40,50,100,null,"TC56",5,20,30,40,50,100,null,"Table 19"]
["TC57",5,20,30,40,50,100,null,"TC57",5,20,30,40,50,100,null,"Years","Software","Price £","Price €","Price $"]
["TC70",5,20,30,40,50,100,null,"TC70",5,20,30,40,50,100,null,0,"None",0,0,0]
["TC77",5,20,30,40,50,100,null,"TC77",5,20,30,40,50,100,null,1,"CS-ACS-MGTB-1",27.43,31.29,34.380000000000003]
["TC8300",0,15,15,20,25,50,null,"TC8300",0,0,0,0,0,0,null,3,"CS-ACS-MGTB-3",72.94,83.21,91.45]
["MC3300",0,10,15,20,25,50,null,"MC3300",0,0,0,0,0,0,null,5,"CS-ACS-MGTB-5",115.94,132.26,150.84]
["MC9300",0,8,12,16,20,40,null,"MC9300",0,0,0,0,0,0]
["WT6000",5,15,15,20,25,50,null,"WT6000",0,0,0,0,0,0]
[]
["Table 5",null,null,"Table 6 - to be deleted",null,null,null,null,"Table 15",null,null,null,null,"Table 16"]
["Yes/No","Answer",null,"CC6000 \nMount","SKU","CC6000\n€ Price","Code",null,"Cradle Lock SKU","Cradle Lock\n€ Price ","Cradle Lock\n$ Price","Cradle Lock\n£ Price",null,"Item","SKU","Price EU","Price UK"]
["YES",1,null,"Top","CS-CAB-MNTG-C6","YYY","YYY",null,"CS-CRD-LOC",500,506.31,null,null,"CC6000","CC6000-10-3200LCWW",1513.49,1326.66]
["No",2,null,"Side L-XL","CS-CAB-MNTG-C6-R1","YYY","YYY",null,"CS-CRD-LOC-TC2",481.98,491.43,null,null,"CC6000 PSU","PWR-BUA5V16W0WW",31.09,27.25]
[null,null,null,"Side Ext","CS-CAB-MNTG-C6-R2","YYY","YYY",null,"CS-CRD-LOC-TC5",459.03,468.03,null,null,"CC6000 DC Cable","CBL-DC-383A1-01",6.54,5.74]
[null,null,null,null,null,null,null,null,"CS-CRD-LOC-TC5-T",416.19,424.35]
[null,null,null,null,null,null,null,null,"CS-CRD-LOC-TC7",481.98,491.43]
["Table 14",null,null,null,null,null,null,null,"CS-CRD-LOC-TC7-T",416.19,424.35]
["Yes/No","Answer","Column1"]
["Yes",1,"Yes"]
["No",0,"No"]
[]
["SKU_Price"]
["SKU","Euro","UK","NA","ANZ","LATAM"]
["CS-CAB-1-B",1075.7,924.91]
["CS-CAB-2-B",1506.5,1320.53]
["CS-CAB-3-B",2216.6799999999998,1943.04]
["CS-CAB-4-B",2524.41,2212.79]
["CS-CAB-5XL-B",3481.88,3052.06]
["CS-CAB-5EXT-B",5743.08,5034.13]
["CS-CAB-1-B-FLTPK",1075.7,924.91]
["CS-CAB-2-B-FLTPK",1506.5,1320.53]
["CS-CAB-3-B-FLTPK",2216.6799999999998,1943.04]
["CS-CAB-4-B-FLTPK",2524.41,2212.79]
["CS-CAB-5XL-B-FLTPK",3481.88,3052.06]
["CS-CAB-5EXT-B-FLTPK",5743.08,5034.13]
["CS-CAB-1-B-N",null,null,1318.05]
["CS-CAB-2-B-N",null,null,1871.26]
["CS-CAB-3-B-N",null,null,2659.45]
["CS-CAB-4-B-N",null,null,3000.72]
["CS-CAB-5XL-B-N",null,null,4063.42]
["CS-CAB-5EXT-B-N",null,null,6468.07]
["CS-CAB-1-B-C6-N",null,null,2121.87]
["CS-CAB-2-B-C6-N",null,null,2675.08]
["CS-CAB-3-B-C6-N",null,null,3463.27]
["CS-CAB-4-B-C6-N",null,null,3804.75]
["CS-CAB-5XL-B-C6-N",null,null,4867.24]
["CS-CAB-5EXT-B-C6-N",null,null,7271.89]
["CS-CAB-1-B-N-FLTPK"]
["CS-CAB-2-B-N-FLTPK"]
["CS-CAB-3-B-N-FLTPK"]
["CS-CAB-4-B-N-FLTPK"]
["CS-CAB-5XL-B-N-FLTPK"]
["CS-CAB-5EXT-B-N-FLTPK"]
["CS-CAB-1-B-C6-N-FLTPK"]
["CS-CAB-2-B-C6-N-FLTPK"]
["CS-CAB-3-B-C6-N-FLTPK"]
["CS-CAB-4-B-C6-N-FLTPK"]
["CS-CAB-5XL-B-C6-N-FLTPK"]
["CS-CAB-5EXT-B-C6-N-FLTPK"]

{"sheet":"Cabinet Features","index":2,"n_rows":55,"n_cols":31,"rows_kept":55,"cut":false,"hidden":false,"merged":[[48,20,49,25],[1,20,17,25],[51,1,56,2],[51,3,53,4],[54,3,56,4],[52,20,54,32],[51,5,53,18],[54,5,56,18],[12,27,12,31],[28,27,28,31],[27,27,27,31],[30,27,30,31],[1,0,1,16],[3,0,3,16],[18,20,19,25]]}
[]
["Cabinet Detail"]
[]
["(Colours used for illustration purposes only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping Lid - Aids ventilation"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Right hand bi-fold door"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Unit - (drawer partially open)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acrylic leaf - contents visible when door is locked"]
[]
[null,null,null,"Left hand bi-fold door"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14 socket Power Distribution Unit (PDU)",null,null,null,null,null,"Small Cabinet with CC6000 mounted on top.\nCan also be mounted on top of Midi"]
[]
[]
[]
[null,null,null,"Door handle",null,null,null,null,null,null,null,null,null,null,"Cradle fixing screw"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Louvred panel - flexible shelf positions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compact Cabinet (door open)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stadium shelf - half depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List of Compatible Devices"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main shelf - full depth",null,null,null,null,null,null,null,null,null,null,null,null,"EC30","TC20","MC2200","WT6000"]
[null,null,null,"Door lock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC50","TC25","MC2700","WT6300"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC55","TC21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC26","ZQ210","RS5100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC50","ZQ310"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable entry point; Power, Ethernet etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,"TC51","ZQ320"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC52","QLN4x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC72"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC75"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC77"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large Cabinet with CC6000 mounted on Right hand side. CC600 side mounted on Large, X-Large and Extreme"]
[]
[]
[null,"Cradle Locks and Stadium Shelves",null,"Extreme &\n X-Large",null,"If Stadium Shelves are fitted then adding Cradle locks makes the lowest Stadium shelf difficult to access, therefore when Cradle Locks are added, the number of Stadium shelves and IEC-L cables will be reduced by 1 for each cabinet."]
[]
[]
[null,null,null,"Large, Midi \n& Small",null,"This also applies to the Large, Midi and Small cabinets.   If the Cabinet Base unit is used or, in the case of Midi & Small cabinets, they are wall mounted, then this Stadium Shelf can be used"]

{"sheet":"Cabinet Dimensions","index":3,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,2,25,2],[14,0,15,0],[14,8,25,8],[14,3,25,3],[14,5,25,5],[14,7,25,7],[14,4,25,4],[14,6,25,6]]}
[]
[null,"Small","Small with Base","Midi","Midi with Base","Large","Large with Base","X-Large","Extreme"]
["Height","1000mm, 39.4\"","1300mm,   51.2\"","1300mm,   51.2\"","1600mm,   63\"","1600mm,   63\"","1900mm,   74.8\"","1900mm,   74.8\"","1900mm,   74.8\""]
["Width","700mm,   27.5\"","700mm,   27.5\"","700mm,   27.5\"","700mm,   27.5\"","700mm,   27.5\"","700mm,   27.5\"","700mm,   27.5\"","1200mm,   47.2\""]
["Depth","440mm,   17.3\"","440mm,   17.3\"","440mm,   17.3\"","440mm,   17.3\"","440mm,   17.3\"","440mm,   17.3\"","440mm,   17.3\"","440mm,   17.3\""]
["Cabinet Weight","44kg,   97lbs","66kg,   145.5lbs","57kg,   125.6lbs","79kg,   174lbs","70kg,   154lbs","92kg,   202.8lbs","83kg, 182.9lbs","124kg,   273.4lbs"]
["Shelf Weight","2.7kg,   5.9lbs","2.7kg,   5.9lbs","2.7kg,   5.9lbs","2.7kg,   5.9lbs","2.7kg,   5.9lbs","2.7kg,   5.9lbs","2.7kg,   5.9lbs","5kg,   11lbs"]
["Stadium Shelf Weight","1.2kg,   2.6lbs","1.2kg,   2.6lbs","1.2kg,   2.6lbs","1.2kg,   2.6lbs","1.2kg,   2.6lbs","1.2kg,   2.6lbs","1.2kg,   2.6lbs","2.4kg, 5.2lbs"]
["Cables included with Cabinet",null,"2 x IEC","2 x IEC, 1 x IEC-L","2 x IEC, 1 x IEC-L","3 x IEC, 1 x IEC-L","3 x IEC, 1 x IEC-L","3 x IEC, 2 x IEC-L","6 x IEC, 4 x IEC-L"]
["Slots\n(No of potential shelf locations)",10,10,14,14,18,18,22,44]
["Slot spacing (mm)\nSpace between shelf supports","75mm,  2.95\"","75mm,  2.95\"","75mm,  2.95\"","75mm,  2.95\"","75mm,  2.95\"","75mm,  2.95\"","75mm,  2.95\"","75mm,  2.95\""]
["Default inter-shelf gap (mm)\nThe space between shelf positions","450mm,   17.7\"","450mm,   17.7\"","450mm,   17.7\"","375mm,   14.7\"","375mm,   14.7\"","375mm,   14.7\"","375mm,   14.7\"","375mm,   14.7\""]
["Gap from Top shelf to Cabinet top","427mm,   16.8\"","427mm,   16.8\"","427mm,   16.8\"","427mm,   16.8\"","352mm,   13.8\"","352mm,   13.8\"","277mm,   10.9\"","277mm,   10.9\""]
["Compatible with Base Unit","Yes","Yes","Yes","Yes","Yes","Yes","No","No"]
["The lady shown below is scaled to 1.61m or 5ft 3in, the average height for a UK female. She is shown in proportion to the cabinets"]
[]
[]
[null,"Orange Shelf:\n Stadium    "]
[null,"Red Shelf:\nStandard"]

{"sheet":"AMS-Features","index":4,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,26],[54,1,54,18],[54,19,54,27],[52,1,52,14],[52,15,52,27]]}
["AMS Features and Benefits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For further details and training information on Zebra Access Management System please use the following link:",null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.zebra.com/us/en/support-downloads/software/productivity-apps/intelligent-cabinets.html"]
[]
[null,"For an amazing insight on how Intelligent Cabinets can help your customers see the following video on Zebra Technologies YouTube Channel :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=3JJajoA0DtY  "]

{"sheet":"Configurator","index":5,"n_rows":38,"n_cols":46,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,8,11,9],[1,23,1,27],[2,23,2,27],[2,29,2,33],[1,29,1,33],[1,17,1,21],[2,17,2,21],[1,7,1,13],[11,10,11,11],[11,12,11,13],[4,7,11,7],[2,41,2,45],[1,41,1,45],[2,35,2,39],[1,35,1,39],[20,1,20,2],[13,7,16,7],[18,7,23,7],[17,1,17,2],[14,1,14,2],[21,1,21,2],[22,1,22,2],[19,1,19,2],[13,1,13,2],[16,1,16,2],[18,1,18,2],[2,7,2,13],[23,1,23,2],[16,12,16,13],[15,12,15,13],[14,12,14,13],[13,12,13,13],[15,8,15,10],[16,8,16,10],[13,8,13,10],[14,8,14,10],[11,1,11,2],[15,1,15,2],[0,1,0,4],[10,1,10,2],[8,1,8,2],[9,1,9,2],[7,1,7,2],[4,1,5,2],[4,3,5,3],[1,1,1,3],[2,1,2,3],[12,1,12,2],[23,43,23,44],[23,37,23,38],[5,44,5,45],[4,41,4,45],[5,20,5,21],[4,17,4,21],[5,26,5,27],[4,23,4,27],[5,38,5,39],[4,35,4,39],[5,32,5,33],[4,29,4,33],[23,31,23,32],[23,25,23,26],[23,19,23,20]]}
["210325"]
[null,"Data Input",null,null,null,null,null,"Recommended configuration",null,null,null,null,null,null,null,null,"Z3br4","Bill Of Materials and SKU List",null,null,null,null,null,"Bill Of Materials and SKU List",null,null,null,null,null,"Bill Of Materials and SKU List",null,null,null,null,null,"Bill Of Materials and SKU List",null,null,null,null,null,"Bill Of Materials and SKU List"]
[null,"Enter data and select options in the drop down menus highlighted in blue below.",null,null,null,null,null,"Optimal cabinet choice based upon cost and capacity, and assumes the same cabinet type is used.  Alternative considerations and cabinet combinations are listed further below.  \nPricing may change and is for comparisson purposes only. Please refer to Solution Pathway or Partner Gateway for latest pricing.",null,null,null,null,null,null,null,null,null,"Use the SKUs and Quantities (Qty) listed below to generate quotes using your quoting tool, such as Solutions Pathway.",null,null,null,null,null,"Use the SKUs and Quantities (Qty) listed below to generate quotes using your quoting tool, such as Solutions Pathway.",null,null,null,null,null,"Use the SKUs and Quantities (Qty) listed below to generate quotes using your quoting tool, such as Solution Pathway.",null,null,null,null,null,"Use the SKUs and Quantities (Qty) listed below to generate quotes using your quoting tool, such as Solution Pathway.",null,null,null,null,null,"Use the SKUs and Quantities (Qty) listed below to generate quotes using your quoting tool, such as Solution Pathway."]
[]
[null,"Number of Mobile Devices per Location",null,100,null,null,null,"Same Cabinet Type \nSolution",null,"Extreme","X-Large","Large","Midi","Small",null,null,null,{"$f":"Device_Cabinet_Data!A52","v":"Extreme"},null,null,null,null,null,{"$f":"Device_Cabinet_Data!A51","v":"X-Large"},null,null,null,null,null,{"$f":"Device_Cabinet_Data!A50","v":"Large"},null,null,null,null,null,{"$f":"Device_Cabinet_Data!A49","v":"Midi"},null,null,null,null,null,{"$f":"Device_Cabinet_Data!A48","v":"Small"}]
[null,null,null,null,null,null,null,null,"Devices per cabinet",{"$f":"$G$12/$F$12*(IF(AND($D$20=\"No\",$F$19=1),$J$13/2,IF($D$22=\"Yes\", VLOOKUP($D$9,Table813[],17,FALSE),$J13)))","v":100},{"$f":"$G$12/$F$12*(IF(AND($D$20=\"No\",$F$19=1),$K$13/2,IF($D$22=\"Yes\", VLOOKUP($D$9,Table813[],15,FALSE),$K13)))","v":50},{"$f":"$G$12/$F$12*(IF(AND($D$20=\"No\",$F$19=1),$L$13/2,IF(AND($D$22=\"Yes\",$D$23<>\"Base\"),VLOOKUP($D$9,Table813[],13,FALSE),$L13)))","v":40},{"$f":"$G$12/$F$12*(IF(AND($D$20=\"No\",$F$19=1),$M$13/2,IF(AND($D$22=\"Yes\",$D$23=\"None\"), VLOOKUP($D$9,Table813[],11,FALSE),$M13)))","v":30},{"$f":"$G$12/$F$12*(IF(AND($D$20=\"No\",$F$19=1),$N$13/2,IF(AND($D$22=\"Yes\",$D$23=\"None\"), VLOOKUP($D$9,Table813[],9,FALSE),$N13)))","v":20},null,null,null,"Floor Area",{"$f":"IF($G$10=\"NA\", _xlfn.CONCAT(R$25,Device_Cabinet_Data!$R$71), _xlfn.CONCAT(R$25,Device_Cabinet_Data!$R$69))","v":"0.52m²"},"Wall Area",{"$f":"IF($G$10=\"NA\",_xlfn.CONCAT(R$26,Device_Cabinet_Data!$R$71),_xlfn.CONCAT(R$26,Device_Cabinet_Data!$R$69))","v":"2.29m²"},null,null,"Floor Area",{"$f":"IF($G$10=\"NA\", _xlfn.CONCAT(X$25,Device_Cabinet_Data!$R$71), _xlfn.CONCAT(X$25,Device_Cabinet_Data!$R$69))","v":"1.05m²"},"Wall Area",{"$f":"IF($G$10=\"NA\",_xlfn.CONCAT(X$26,Device_Cabinet_Data!$R$71),_xlfn.CONCAT(X$26,Device_Cabinet_Data!$R$69))","v":"2.68m²"},null,null,"Floor Area",{"$f":"IF($G$10=\"NA\", _xlfn.CONCAT(AD$25,Device_Cabinet_Data!$R$71), _xlfn.CONCAT(AD$25,Device_Cabinet_Data!$R$69))","v":"1.57m²"},"Wall Area",{"$f":"IF($G$10=\"NA\",_xlfn.CONCAT(AD$26,Device_Cabinet_Data!$R$71),_xlfn.CONCAT(AD$26,Device_Cabinet_Data!$R$69))","v":"3.39m²"},null,null,"Floor Area",{"$f":"IF($G$10=\"NA\", _xlfn.CONCAT(AJ$25,Device_Cabinet_Data!$R$71), _xlfn.CONCAT(AJ$25,Device_Cabinet_Data!$R$69))","v":"2.1m²"},"Wall Area",{"$f":"IF($G$10=\"NA\",_xlfn.CONCAT(AJ$26,Device_Cabinet_Data!$R$71),_xlfn.CONCAT(AJ$26,Device_Cabinet_Data!$R$69))","v":"3.67m²"},null,null,"Floor Area",{"$f":"IF($G$10=\"NA\", _xlfn.CONCAT(AP$25,Device_Cabinet_Data!$R$71), _xlfn.CONCAT(AP$25,Device_Cabinet_Data!$R$69))","v":"2.62m²"},"Wall Area",{"$f":"IF($G$10=\"NA\",_xlfn.CONCAT(AP$26,Device_Cabinet_Data!$R$71),_xlfn.CONCAT(AP$26,Device_Cabinet_Data!$R$69))","v":"3.54m²"}]
[null,null,null,null,null,null,null,null,"No of Cabinets Required",{"$f":" IF(INT($D$5/J$6)=0,  \"1\",ROUNDUP($D$5/J$6,0))","v":1},{"$f":" IF(INT($D$5/K$6)=0,  \"1\",ROUNDUP($D$5/K$6,0))","v":2},{"$f":" IF(INT($D$5/L$6)=0,  \"1\",ROUNDUP($D$5/L$6,0))","v":3},{"$f":" IF(INT($D$5/M$6)=0,  \"1\",ROUNDUP($D$5/M$6,0))","v":4},{"$f":" IF(INT($D$5/N$6)=0,  \"1\",ROUNDUP($D$5/N$6,0))","v":5},null,null,null,"Product Build","SKU","Unit Price","Qty","Total",null,"Product Build","SKU","Unit Price","Qty","Total",null,"Product Build","SKU","Unit Price","Qty","Total",null,"Product Build","SKU","Unit Price","Qty","Total",null,"Product Build","SKU","Unit Price","Qty","Total"]
[null,"Flat Pack",null,"Yes",null,null,null,null,"Stadium Shelves Rqd",{"$f":"IF($F$20=1,J7*((VLOOKUP(J5,Table10[],13,FALSE))+1-$F$22),0)","v":5},{"$f":"IF($F$20=1,K7*((VLOOKUP(K5,Table10[],13,FALSE))+1-$F$22),0)","v":10},{"$f":"IF($F$20=1,L7*((VLOOKUP(L5,Table10[],13,FALSE))+1-($F$22*$F$23)),0)","v":12},{"$f":"IF($F$20=1,M7*((VLOOKUP(M5,Table10[],13,FALSE))+1-($F$22*$F$23)),0)","v":12},{"$f":"IF($F$20=1,N7*((VLOOKUP(N5,Table10[],13,FALSE))+1),0)","v":10},null,null,null,{"$f":"IF($G$10<>\"NA\",\"Cabinets\",IF($D$16=\"Yes\",\"Cabinets with CC6\",\"Cabinets w/o CC6\"))","v":"Cabinets"},{"$f":"IF($G$10<>\"NA\",IF($D$8=\"Yes\",Device_Cabinet_Data!$S$64,Device_Cabinet_Data!$B$64),IF($D$16=\"No\",Device_Cabinet_Data!$D64,Device_Cabinet_Data!$F64))","v":"CS-CAB-5EXT-B-FLTPK"},{"$f":"VLOOKUP(S8, SKU_Price[], IF($G$10=\"EU\",2,IF($G$10=\"UK\",3,IF($G$10=\"NA\",4,0))),FALSE)","v":5743.08},{"$f":"IF($G$10=\"NA\",IF($D$16=\"Yes\",ROUNDUP(Configurator!$J$7/$D$17,0),$J$7),$J$7)","v":1},{"$f":"IFERROR(IF(U8>0,T8*U8,\"\"),\"\")","v":5743.08},null,{"$f":"IF($G$10<>\"NA\",\"Cabinets\",IF($D$16=\"Yes\",\"Cabinets with CC6\",\"Cabinets w/o CC6\"))","v":"Cabinets"},{"$f":"IF($G$10<>\"NA\",IF($D$8=\"Yes\",Device_Cabinet_Data!$S$63,Device_Cabinet_Data!$B$63),IF($D$16=\"No\",Device_Cabinet_Data!$D63,Device_Cabinet_Data!$F63))","v":"CS-CAB-5XL-B-FLTPK"},{"$f":"VLOOKUP(Y8, SKU_Price[], IF($G$10=\"EU\",2,IF($G$10=\"UK\",3,IF($G$10=\"NA\",4,0))),FALSE)","v":3481.88},{"$f":"IF($G$10=\"NA\",IF($D$16=\"Yes\",ROUNDUP(Configurator!$K$7/$D$17,0),$K$7),$K$7)","v":2},{"$f":"IFERROR(IF(AA8>0,Z8*AA8,\"\"),\"\")","v":6963.76},null,{"$f":"IF($G$10<>\"NA\",\"Cabinets\",IF($D$16=\"Yes\",\"Cabinets with CC6\",\"Cabinets w/o CC6\"))","v":"Cabinets"},{"$f":"IF($G$10<>\"NA\",IF($D$8=\"Yes\",Device_Cabinet_Data!$S$62,Device_Cabinet_Data!$B$62),IF($D$16=\"No\",Device_Cabinet_Data!$D62,Device_Cabinet_Data!$F62))","v":"CS-CAB-4-B-FLTPK"},{"$f":"VLOOKUP(AE8, SKU_Price[], IF($G$10=\"EU\",2,IF($G$10=\"UK\",3,IF($G$10=\"NA\",4,0))),FALSE)","v":2524.41},{"$f":"IF($G$10=\"NA\",IF($D$16=\"Yes\",ROUNDUP(Configurator!$L$7/$D$17,0),$L$7),$L$7)","v":3},{"$f":"IFERROR(IF(AG8>0,AF8*AG8,\"\"),\"\")","v":7573.23},null,{"$f":"IF($G$10<>\"NA\",\"Cabinets\",IF($D$16=\"Yes\",\"Cabinets with CC6\",\"Cabinets w/o CC6\"))","v":"Cabinets"},{"$f":"IF($G$10<>\"NA\",IF($D$8=\"Yes\",Device_Cabinet_Data!$S$61,Device_Cabinet_Data!$B$61),IF($D$16=\"No\",Device_Cabinet_Data!$D61,Device_Cabinet_Data!$F61))","v":"CS-CAB-3-B-FLTPK"},{"$f":"VLOOKUP(AK8, SKU_Price[], IF($G$10=\"EU\",2,IF($G$10=\"UK\",3,IF($G$10=\"NA\",4,0))),FALSE)","v":2216.6799999999998},{"$f":"IF($G$10=\"NA\",IF($D$16=\"Yes\",ROUNDUP(Configurator!$M$7/$D$17,0),$M$7),$M$7)","v":4},{"$f":"IFERROR(IF(AM8>0,AL8*AM8,\"\"),\"\")","v":8866.7199999999993},null,{"$f":"IF($G$10<>\"NA\",\"Cabinets\",IF($D$16=\"Yes\",\"Cabinets with CC6\",\"Cabinets w/o CC6\"))","v":"Cabinets"},{"$f":"IF($G$10<>\"NA\",IF($D$8=\"Yes\",Device_Cabinet_Data!$S$60,Device_Cabinet_Data!$B$60),IF($D$16=\"No\",Device_Cabinet_Data!$D60,Device_Cabinet_Data!$F60))","v":"CS-CAB-2-B-FLTPK"},{"$f":"VLOOKUP(AQ8, SKU_Price[], IF($G$10=\"EU\",2,IF($G$10=\"UK\",3,IF($G$10=\"NA\",4,0))),FALSE)","v":1506.5},{"$f":"IF($G$10=\"NA\",IF($D$16=\"Yes\",ROUNDUP(Configurator!$N$7/$D$17,0),$N$7),$N$7)","v":5},{"$f":"IFERROR(IF(AS8>0,AR8*AS8,\"\"),\"\")","v":7532.5}]
[null,"Select Your Device",null,"TC57",{"$f":"VLOOKUP(D9,Table813[[Device]:[Unit Value]],3,)","v":5},null,null,null,"Expansion\nCapacity",{"$f":"(J7*J6)-$D$5","v":0},{"$f":"(K7*K6)-$D$5","v":0},{"$f":"(L7*L6)-$D$5","v":20},{"$f":"(M7*M6)-$D$5","v":20},{"$f":"(N7*N6)-$D$5","v":0},null,null,null,{"$f":"IF(AND($G$10=\"NA\",U$9<>\"\"),\"Cabinets, w/o CC6\",\"\")","v":""},{"$f":"IF(AND($G$10=\"NA\",U9<>\"\"),IF(AND($D$14<>1,$J$7>1),VLOOKUP(Configurator!$J$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF(AND(U9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$J$7>1),VLOOKUP(Configurator!$J$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G$10=\"NA\",IF($J$7-$U$8=0,\"\",$J$7-$U$8),\"\")","v":""},{"$f":"IFERROR(IF(U9>0,T9*U9,\"\"),\"\")","v":""},null,{"$f":"IF(AND($G$10=\"NA\",AA$9<>\"\"),\"Cabinets, w/o CC6\",\"\")","v":""},{"$f":"IF(AND(AA9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$K$7>1),VLOOKUP(Configurator!$K$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF(AND(AA9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$K$7>1),VLOOKUP(Configurator!$K$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G$10=\"NA\",IF($K$7-$AA$8=0,\"\",$K$7-$AA$8),\"\")","v":""},{"$f":"IFERROR(IF(AA9>0,Z9*AA9,\"\"),\"\")","v":""},null,{"$f":"IF(AND($G$10=\"NA\",AG$9<>\"\"),\"Cabinets, w/o CC6\",\"\")","v":""},{"$f":"IF(AND(AG9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$L$7>1),VLOOKUP(Configurator!$L$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF(AND(AG9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$L$7>1),VLOOKUP(Configurator!$L$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G$10=\"NA\",IF($L$7-AG$8=0,\"\",$L$7-AG$8),\"\")","v":""},"",null,{"$f":"IF(AND($G$10=\"NA\",AM$9<>\"\"),\"Cabinets, w/o CC6\",\"\")","v":""},{"$f":"IF(AND(AM9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$M$7>1),VLOOKUP(Configurator!$M$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF(AND(AM9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$M$7>1),VLOOKUP(Configurator!$M$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G$10=\"NA\",IF($M$7-AM$8=0,\"\",$M$7-AM$8),\"\")","v":""},"",null,{"$f":"IF(AND($G$10=\"NA\",AS$9<>\"\"),\"Cabinets, w/o CC6\",\"\")","v":""},{"$f":"IF(AND(AS9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$N$7>1),VLOOKUP(Configurator!$N$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF(AND(AS9<>\"\",$G$10=\"NA\"),IF(AND($D$14<>1,$N$7>1),VLOOKUP(Configurator!$N$5,Table13[[#All],[Cabinet]:[NA-C6-Bundeled Price]],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G$10=\"NA\",IF($N$7-AS$8=0,\"\",$N$7-AS$8),\"\")","v":""},""]
[null,"Select Your Country",null,"Europe",{"$f":"VLOOKUP(D10,Table2[],2,FALSE)","v":"CS-CAB-EU-MLEAD"},{"$f":"VLOOKUP(D10,Table2[],5,FALSE)","v":"€"},{"$f":"VLOOKUP(D10,Table2[],4,FALSE)","v":"EU"},null,"IEC Socket per Cabinet",{"$f":"VLOOKUP(J5,Table10[],25,FALSE)","v":28},{"$f":"VLOOKUP(K5,Table10[],25,FALSE)","v":14},{"$f":"VLOOKUP(L5,Table10[],25,FALSE)","v":14},{"$f":"VLOOKUP(M5,Table10[],25,FALSE)","v":14},{"$f":"VLOOKUP(N5,Table10[],25,FALSE)","v":14},null,null,null,"Power Cable",{"$f":"Configurator!$E$10","v":"CS-CAB-EU-MLEAD"},{"$f":"VLOOKUP(Configurator!$D$10,Table2[],3,FALSE)","v":7.7},{"$f":"Configurator!J7*2","v":2},{"$f":"IFERROR(IF(U10>0,T10*U10,\"\"),\"\")","v":15.4},null,"Power Cable",{"$f":"Configurator!$E$10","v":"CS-CAB-EU-MLEAD"},{"$f":"VLOOKUP(Configurator!$D$10,Table2[],3,FALSE)","v":7.7},{"$f":"Configurator!K7","v":2},{"$f":"IFERROR(IF(AA10>0,Z10*AA10,\"\"),\"\")","v":15.4},null,"Power Cable",{"$f":"Configurator!$E$10","v":"CS-CAB-EU-MLEAD"},{"$f":"VLOOKUP(Configurator!$D$10,Table2[],3,FALSE)","v":7.7},{"$f":"Configurator!L7","v":3},{"$f":"IFERROR(IF(AG10>0,AF10*AG10,\"\"),\"\")","v":23.1},null,"Power Cable",{"$f":"Configurator!$E$10","v":"CS-CAB-EU-MLEAD"},{"$f":"VLOOKUP(Configurator!$D$10,Table2[],3,FALSE)","v":7.7},{"$f":"Configurator!M7","v":4},{"$f":"IFERROR(IF(AM10>0,AL10*AM10,\"\"),\"\")","v":30.8},null,"Power Cable",{"$f":"Configurator!$E$10","v":"CS-CAB-EU-MLEAD"},{"$f":"VLOOKUP(Configurator!$D$10,Table2[],3,FALSE)","v":7.7},{"$f":"Configurator!N7","v":5},{"$f":"IFERROR(IF(AS10>0,AR10*AS10,\"\"),\"\")","v":38.5}]
[null,"Cradles with Battery Charger",null,"No",{"$f":"IF(F11=1,VLOOKUP(D11,Table14[],2,FALSE),0)","v":0},{"$f":"VLOOKUP(D9,Table813[],24,FALSE)","v":1},{"$f":"E11*F11","v":0},null,"Spare IEC Sockets",{"$f":"IF($D$11=\"Yes\",J$10-(J$6/VLOOKUP($D$9,Table813[],25,FALSE)),J$10-(J$6/VLOOKUP($D$9,Table813[],5)))","v":8},{"$f":"IF($D$11=\"Yes\",K$10-(K$6/VLOOKUP($D$9,Table813[],25,FALSE)),K$10-(K$6/VLOOKUP($D$9,Table813[],5)))","v":4},{"$f":"IF($D$11=\"Yes\",L$10-(L$6/VLOOKUP($D$9,Table813[],25,FALSE)),L$10-(L$6/VLOOKUP($D$9,Table813[],5)))","v":6},{"$f":"IF($D$11=\"Yes\",M$10-(M$6/VLOOKUP($D$9,Table813[],25,FALSE)),M$10-(M$6/VLOOKUP($D$9,Table813[],5)))","v":8},{"$f":"IF($D$11=\"Yes\",N$10-(N$6/VLOOKUP($D$9,Table813[],25,FALSE)),N$10-(N$6/VLOOKUP($D$9,Table813[],5)))","v":10},null,null,null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Std\",\"\")","v":"IEC Lead, Std"},{"$f":"IF(R11<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF($R$11<>\"\",IF($G$10=\"EU\",VLOOKUP(S11,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(S11,Table4[],3,FALSE),VLOOKUP(S11,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(R11<>\"\",$E$20*$J$7*VLOOKUP(R$5,Table10[],18,FALSE),\"\")","v":6},{"$f":"IFERROR(IF(U$11>0,T11*U11,\"\"),\"\")","v":46.2},null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Std\",\"\")","v":"IEC Lead, Std"},{"$f":"IF(X11<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(X11<>\"\",IF($G$10=\"EU\",VLOOKUP(Y11,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(Y11,Table4[],3,FALSE),VLOOKUP(Y11,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(X11<>\"\",$E$20*$K7*VLOOKUP(X$5,Table10[],18,FALSE),\"\")","v":6},{"$f":"IFERROR(IF(AA$11>0,Z11*AA11,\"\"),\"\")","v":46.2},null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Std\",\"\")","v":"IEC Lead, Std"},{"$f":"IF(AD11<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(X11<>\"\",IF($G$10=\"EU\",VLOOKUP(AE11,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AE11,Table4[],3,FALSE),VLOOKUP(AE11,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(AD11<>\"\",$E$20*$L7*VLOOKUP(AD$5,Table10[],18,FALSE),\"\")","v":9},69.3,null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Std\",\"\")","v":"IEC Lead, Std"},{"$f":"IF(AJ11<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(AJ11<>\"\",IF($G$10=\"EU\",VLOOKUP(AK11,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AK11,Table4[],3,FALSE),VLOOKUP(AK11,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(AJ11<>\"\",$E$20*$M7*VLOOKUP(AJ$5,Table10[],18,FALSE)+IF(AM$14<>\"\",AM$14,0),\"\")","v":8},61.6,null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Std\",\"\")","v":"IEC Lead, Std"},{"$f":"IF(AP11<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(AP11<>\"\",IF($G$10=\"EU\",VLOOKUP(AQ11,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AQ11,Table4[],3,FALSE),VLOOKUP(AQ11,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(AP11<>\"\",$E$20*$N7*VLOOKUP(AP$5,Table10[],18,FALSE)+IF(AS$14<>\"\",AS$14,0),\"\")","v":10},77]
[null,"Qty of Cradles to be housed",null,{"$f":"ROUNDUP(D5/G12,0)","v":20},null,{"$f":"VLOOKUP(D9,Table813[[Device]:[Devices Per Cradle]],5,FALSE)","v":5},{"$f":"(VLOOKUP(D9,Table813[[Device]:[Devices Per Cradle]],5,FALSE))-G11","v":5},null,"Optimal Cabinet Choice",null,{"$f":"OFFSET(INDIRECT(CELL(\"address\",INDEX(Configurator!$R$24:$AT$24,MATCH(MIN(Configurator!$V$24,Configurator!$AB$24,Configurator!$AH$24,Configurator!$AN$24,Configurator!$AT$24),Configurator!$R$24:$AT$24,0)))),-19,-4)","v":"Extreme"},null,{"$f":"MIN(Configurator!$V$24,Configurator!$AB$24,Configurator!$AH$24,Configurator!$AN$24,Configurator!$AT$24)","v":16734.840000000004},null,null,null,null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Long\",\"\")","v":"IEC Lead, Long"},{"$f":"IF(R12<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(R12<>\"\",IF($G$10=\"EU\",VLOOKUP(S12,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(S12,Table4[],3,FALSE),VLOOKUP(S12,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(R12<>\"\",($E$20*$J$7*VLOOKUP(R$5,Table10[],19,FALSE))-($J$7*$F$20*$F$22)+IF(U14<>\"\",2*U$14,0),\"\")","v":4},{"$f":"IFERROR(IF(U$12>0,T12*U12,\"\"),\"\")","v":30.8},null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Long\",\"\")","v":"IEC Lead, Long"},{"$f":"IF(X12<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(X12<>\"\",IF($G$10=\"EU\",VLOOKUP(Y12,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(Y12,Table4[],3,FALSE),VLOOKUP(Y12,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(X12<>\"\",($E$20*$K$7*VLOOKUP(X$5,Table10[],19,FALSE))-($K$7*$F$20*$F$22)+IF(AA$14<>\"\",AA$14,0),\"\")","v":4},{"$f":"IFERROR(IF(AA$12>0,Z12*AA12,\"\"),\"\")","v":30.8},null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Long\",\"\")","v":"IEC Lead, Long"},{"$f":"IF(AD12<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(AD12<>\"\",IF($G$10=\"EU\",VLOOKUP(AE12,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AE12,Table4[],3,FALSE),VLOOKUP(AE12,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(AD12<>\"\",($E$20*$L$7*VLOOKUP(AD$5,Table10[],19,FALSE))-($L$7*$F$20*$F$22*$F$23)+IF(AG$14<>\"\",AG$14,0),\"\")","v":3},23.1,null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Long\",\"\")","v":"IEC Lead, Long"},{"$f":"IF(AJ12<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(AJ12<>\"\",IF($G$10=\"EU\",VLOOKUP(AK12,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AK12,Table4[],3,FALSE),VLOOKUP(AK12,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(AJ12<>\"\",($E$20*$M$7*VLOOKUP(AJ$5,Table10[],19,FALSE))-($M$7*$F$20*$F$22*$F$23),\"\")","v":4},{"$f":"IFERROR(IF(AM$12>0,AL12*AM12,\"\"),\"\")","v":30.8},null,{"$f":"IF(OR($D$20=\"Yes\",$G$10=\"NA\"),\"IEC Lead, Long\",\"\")","v":"IEC Lead, Long"},{"$f":"IF(AP12<>\"\",IF($G$10<>\"NA\",Device_Cabinet_Data!$F$69,Device_Cabinet_Data!$F$72),\"\")","v":"CS-CAB-IEC"},{"$f":"IF(AP12<>\"\",IF($G$10=\"EU\",VLOOKUP(AQ12,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AQ12,Table4[],3,FALSE),VLOOKUP(AQ12,Table4[],4,FALSE))),\"\")","v":7.7},{"$f":"IF(AP12<>\"\",($E$20*$N$7*VLOOKUP(AP$5,Table10[],19,FALSE))-($F$22*$F$23),\"\")","v":0},{"$f":"IFERROR(IF(AS$11>0,AR12*AS12,\"\"),\"\")","v":0}]
[null,"AMS Compatible",null,{"$f":"IF(F13=1,\"Yes\",\"No\")","v":"Yes"},1,{"$f":"VLOOKUP(D9,Table813[],33,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP($D$9,Table813[],18,FALSE)","v":100},{"$f":"VLOOKUP($D$9,Table813[],16,FALSE)","v":50},{"$f":"VLOOKUP($D$9,Table813[],14,FALSE)","v":40},{"$f":"VLOOKUP($D$9,Table813[],12,FALSE)","v":30},{"$f":"VLOOKUP($D$9,Table813[],10,FALSE)","v":20},null,null,null,{"$f":"IF($F$20=1,\"Stadium Shelves\",\"\")","v":"Stadium Shelves"},{"$f":"IF($F$20=1,VLOOKUP(R$5,Table10[],9,FALSE),\"\")","v":"CS-CAB-SHV-EXT-SS"},{"$f":"IF($F$20=1,IF($G$10=\"EU\",VLOOKUP(R$5,Table10[],10,FALSE),IF($G$10=\"UK\",VLOOKUP(R$5,Table10[],11,FALSE),IF($G$10=\"NA\",VLOOKUP(R$5,Table10[],12,FALSE),\"\"))),\"\")","v":159.6},{"$f":"IF($F$20=1,$J$8,\"\")","v":5},{"$f":"IFERROR(IF(U13>0,T13*U13,\"\"),\"\")","v":798},null,{"$f":"IF($F$20=1,\"Stadium Shelves\",\"\")","v":"Stadium Shelves"},{"$f":"IF($F$20=1,VLOOKUP(X$5,Table10[],9,FALSE),\"\")","v":"CS-CAB-SHV-SS"},{"$f":"IF($F$20=1,IF($G$10=\"EU\",VLOOKUP(X$5,Table10[],10,FALSE),IF($G$10=\"UK\",VLOOKUP(X$5,Table10[],11,FALSE),IF($G$10=\"NA\",VLOOKUP(X$5,Table10[],12,FALSE),\"\"))),\"\")","v":79.8},{"$f":"IF($F$20=1,$K$8,\"\")","v":10},{"$f":"IFERROR(IF(AA13>0,Z13*AA13,\"\"),\"\")","v":798},null,{"$f":"IF($F$20=1,\"Stadium Shelves\",\"\")","v":"Stadium Shelves"},{"$f":"IF($F$20=1,VLOOKUP(AD$5,Table10[],9,FALSE),\"\")","v":"CS-CAB-SHV-SS"},{"$f":"IF($F$20=1,IF($G$10=\"EU\",VLOOKUP(AD$5,Table10[],10,FALSE),IF($G$10=\"UK\",VLOOKUP(AD$5,Table10[],11,FALSE),IF($G$10=\"NA\",VLOOKUP(AD$5,Table10[],12,FALSE),\"\"))),\"\")","v":79.8},{"$f":"IF($F$20=1,$L$8,\"\")","v":12},{"$f":"IFERROR(IF(AG13>0,AF13*AG13,\"\"),\"\")","v":957.59999999999991},null,{"$f":"IF($F$20=1,\"Stadium Shelves\",\"\")","v":"Stadium Shelves"},{"$f":"IF($F$20=1,VLOOKUP(AJ$5,Table10[],9,FALSE),\"\")","v":"CS-CAB-SHV-SS"},{"$f":"IF($F$20=1,IF($G$10=\"EU\",VLOOKUP(AJ$5,Table10[],10,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ$5,Table10[],11,FALSE),IF($G$10=\"NA\",VLOOKUP(AJ$5,Table10[],12,FALSE),\"\"))),\"\")","v":79.8},{"$f":"IF($F$20=1,$M$8,\"\")","v":12},{"$f":"IFERROR(IF(AM13>0,AL13*AM13,\"\"),\"\")","v":957.59999999999991},null,{"$f":"IF($F$20=1,\"Stadium Shelves\",\"\")","v":"Stadium Shelves"},{"$f":"IF($F$20=1,VLOOKUP(AP$5,Table10[],9,FALSE),\"\")","v":"CS-CAB-SHV-SS"},{"$f":"IF($F$20=1,IF($G$10=\"EU\",VLOOKUP(AP$5,Table10[],10,FALSE),IF($G$10=\"UK\",VLOOKUP(AP$5,Table10[],11,FALSE),IF($G$10=\"NA\",VLOOKUP(AP$5,Table10[],12,FALSE),\"\"))),\"\")","v":79.8},{"$f":"IF($F$20=1,$N$8,\"\")","v":10},{"$f":"IFERROR(IF(AS13>0,AR13*AS13,\"\"),\"\")","v":798}]
[null,"Access Management System",null,"Yes",null,null,null,"Cost, Space and Capacity considerations","Lowest Price",null,null,{"$f":"OFFSET(INDIRECT(CELL(\"address\",INDEX(Configurator!$R$24:$AT$24,MATCH(MIN(Configurator!$V$24,Configurator!$AB$24,Configurator!$AH$24,Configurator!$AN$24,Configurator!$AT$24),Configurator!$R$24:$AT$24,0)))),-19,-4)","v":"Extreme"},{"$f":"MIN(Configurator!$V$24,Configurator!$AB$24,Configurator!$AH$24,Configurator!$AN$24,Configurator!$AT$24)","v":16734.840000000004},null,null,null,null,{"$f":"IF(VLOOKUP($D$9,Table813[],21,FALSE)=1,\"Extra Std Shelf\",\"\")","v":""},{"$f":"IF(R14<>\"\",VLOOKUP(R5,Table10[],14,FALSE),\"\")","v":""},{"$f":"IF(R$14<>\"\",IF($G$10=\"EU\",VLOOKUP(R$5,Table10[],15,FALSE),IF($G$10=\"UK\",VLOOKUP(R$5,Table10[],16,FALSE),IF($G$10=\"NA\",VLOOKUP(R$5,Table10[],17,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(R14<>\"\",IF(U9<>\"\",SUM(U8:U9),U8),\"\")","v":""},"",null,{"$f":"IF(VLOOKUP($D$9,Table813[],21,FALSE)=1,\"Extra Std Shelf\",\"\")","v":""},{"$f":"IF(X14<>\"\",VLOOKUP(X5,Table10[],14,FALSE),\"\")","v":""},{"$f":"IF(X$14<>\"\",IF($G$10=\"EU\",VLOOKUP(X$5,Table10[],15,FALSE),IF($G$10=\"UK\",VLOOKUP(X$5,Table10[],16,FALSE),IF($G$10=\"NA\",VLOOKUP(X$5,Table10[],17,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(X14<>\"\",IF(AA9<>\"\",SUM(AA8:AA9),AA8),\"\")","v":""},"",null,{"$f":"IF(VLOOKUP($D$9,Table813[],21,FALSE)=1,\"Extra Std Shelf\",\"\")","v":""},{"$f":"IF(AD14<>\"\",VLOOKUP(AD5,Table10[],14,FALSE),\"\")","v":""},{"$f":"IF(AD$14<>\"\",IF($G$10=\"EU\",VLOOKUP(AD$5,Table10[],15,FALSE),IF($G$10=\"UK\",VLOOKUP(AD$5,Table10[],16,FALSE),IF($G$10=\"NA\",VLOOKUP(AD$5,Table10[],17,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AD14<>\"\",IF(AG9<>\"\",SUM(AG8:AG9),AG8),\"\")","v":""},{"$f":"IFERROR(IF(AG14>0,AF14*AG14,\"\"),\"\")","v":""},null,{"$f":"IF(VLOOKUP($D$9,Table813[],21,FALSE)=1,\"Extra Std Shelf\",\"\")","v":""},{"$f":"IF(AJ14<>\"\",VLOOKUP(AJ5,Table10[],14,FALSE),\"\")","v":""},{"$f":"IF(AJ$14<>\"\",IF($G$10=\"EU\",VLOOKUP(AJ$5,Table10[],15,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ$5,Table10[],16,FALSE),IF($G$10=\"NA\",VLOOKUP(AJ$5,Table10[],17,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AJ14<>\"\",IF(AM9<>\"\",SUM(AM8:AM9),AM8),\"\")","v":""},{"$f":"IFERROR(IF(AM14>0,AL14*AM14,\"\"),\"\")","v":""},null,{"$f":"IF(VLOOKUP($D$9,Table813[],21,FALSE)=1,\"Extra Std Shelf\",\"\")","v":""},{"$f":"IF(AP14<>\"\",VLOOKUP(AP5,Table10[],14,FALSE),\"\")","v":""},{"$f":"IF(AP$14<>\"\",IF($G$10=\"EU\",VLOOKUP(AP$5,Table10[],15,FALSE),IF($G$10=\"UK\",VLOOKUP(AP$5,Table10[],16,FALSE),IF($G$10=\"NA\",VLOOKUP(AP$5,Table10[],17,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AP14<>\"\",IF(AS9<>\"\",SUM(AS8:AS9),AS8),\"\")","v":""},""]
[null,"AMS License Duration",null,3,null,null,null,null,"Smallest Floor Space",null,null,{"$f":"OFFSET(INDIRECT(CELL(\"address\",INDEX(Configurator!$R$25:$AT$25,MATCH(MIN(Configurator!$R$25,Configurator!$X$25,Configurator!$AD$25,Configurator!$AJ$25,Configurator!$AP$25),Configurator!$R$25:$AT$25,0)))),-20,0)","v":"Extreme"},{"$f":"_xlfn.CONCAT(MIN(Configurator!R25,Configurator!X25,Configurator!AD25,Configurator!AJ25,Configurator!AP25),\" \",N18)","v":"0.52 m²"},null,null,null,null,{"$f":"IF($D$14=\"Yes\",\"AMS Software\",\"\")","v":"AMS Software"},{"$f":"IF($D$14=\"Yes\",VLOOKUP($D$15,Table19[[Years]:[Software]],2,FALSE),\"\")","v":"CS-ACS-MGTB-3"},{"$f":"IF($D$14=\"Yes\",IF($G$10=\"UK\",VLOOKUP($D$15,Table19[],3,FALSE),IF($G$10=\"EU\",VLOOKUP($D$15,Table19[],4,FALSE),IF($G$10=\"NA\",VLOOKUP($D$15,Table19[],5,FALSE),\"\"))),\"\")","v":83.21},{"$f":"IF($D$14=\"Yes\",$D$5,\"\")","v":100},8321,null,{"$f":"IF($D$14=\"Yes\",\"AMS Software\",\"\")","v":"AMS Software"},{"$f":"IF($D$14=\"Yes\",VLOOKUP($D$15,Table19[[Years]:[Software]],2,FALSE),\"\")","v":"CS-ACS-MGTB-3"},{"$f":"IF($D$14=\"Yes\",IF($G$10=\"UK\",VLOOKUP($D$15,Table19[],3,FALSE),IF($G$10=\"EU\",VLOOKUP($D$15,Table19[],4,FALSE),IF($G$10=\"NA\",VLOOKUP($D$15,Table19[],5,FALSE),\"\"))),\"\")","v":83.21},{"$f":"IF($D$14=\"Yes\",$D$5,\"\")","v":100},8321,null,{"$f":"IF($D$14=\"Yes\",\"AMS Software\",\"\")","v":"AMS Software"},{"$f":"IF($D$14=\"Yes\",VLOOKUP($D$15,Table19[[Years]:[Software]],2,FALSE),\"\")","v":"CS-ACS-MGTB-3"},{"$f":"IF($D$14=\"Yes\",IF($G$10=\"UK\",VLOOKUP($D$15,Table19[],3,FALSE),IF($G$10=\"EU\",VLOOKUP($D$15,Table19[],4,FALSE),IF($G$10=\"NA\",VLOOKUP($D$15,Table19[],5,FALSE),\"\"))),\"\")","v":83.21},{"$f":"IF($D$14=\"Yes\",$D$5,\"\")","v":100},{"$f":"IFERROR(IF(AG15>0,AF15*AG15,\"\"),\"\")","v":8321},null,{"$f":"IF($D$14=\"Yes\",\"AMS Software\",\"\")","v":"AMS Software"},{"$f":"IF($D$14=\"Yes\",VLOOKUP($D$15,Table19[[Years]:[Software]],2,FALSE),\"\")","v":"CS-ACS-MGTB-3"},{"$f":"IF($D$14=\"Yes\",IF($G$10=\"UK\",VLOOKUP($D$15,Table19[],3,FALSE),IF($G$10=\"EU\",VLOOKUP($D$15,Table19[],4,FALSE),IF($G$10=\"NA\",VLOOKUP($D$15,Table19[],5,FALSE),\"\"))),\"\")","v":83.21},{"$f":"IF($D$14=\"Yes\",$D$5,\"\")","v":100},{"$f":"IFERROR(IF(AM15>0,AL15*AM15,\"\"),\"\")","v":8321},null,{"$f":"IF($D$14=\"Yes\",\"AMS Software\",\"\")","v":"AMS Software"},{"$f":"IF($D$14=\"Yes\",VLOOKUP($D$15,Table19[[Years]:[Software]],2,FALSE),\"\")","v":"CS-ACS-MGTB-3"},{"$f":"IF($D$14=\"Yes\",IF($G$10=\"UK\",VLOOKUP($D$15,Table19[],3,FALSE),IF($G$10=\"EU\",VLOOKUP($D$15,Table19[],4,FALSE),IF($G$10=\"NA\",VLOOKUP($D$15,Table19[],5,FALSE),\"\"))),\"\")","v":83.21},{"$f":"IF($D$14=\"Yes\",$D$5,\"\")","v":100},8321]
[null,"Use CC6000",null,"Yes",0,{"$f":"IF(D16=\"Yes\",1,0)","v":1},null,null,"Smallest wall area",null,null,{"$f":"OFFSET(INDIRECT(CELL(\"address\",INDEX(Configurator!$R$26:$AS$26,MATCH(MIN(Configurator!R26,Configurator!X26,Configurator!AD26,Configurator!AJ26,Configurator!AP26),Configurator!$R$26:$AS$26,0)))),-21,0)","v":"Extreme"},{"$f":"_xlfn.CONCAT(MIN(Configurator!$R$26,Configurator!$X$26,Configurator!$AD$26,Configurator!$AJ$26,Configurator!$AP$26),\" \",N18)","v":"2.29 m²"},null,null,null,null,{"$f":"IF(AND($G$10<>\"NA\",$D16=\"Yes\"),\"CC6000\",\"\")","v":"CC6000"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(R$16,Table16[],2,FALSE),\"\")","v":"CC6000-10-3200LCWW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(R$16,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(R$16,Table16[],4,FALSE))),\"\")","v":1513.49},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($J$7/$D$17,0),\"\")","v":1},1513.49,null,{"$f":"IF(AND($G$10<>\"NA\",$D16=\"Yes\"),\"CC6000\",\"\")","v":"CC6000"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(X$16,Table16[],2,FALSE),\"\")","v":"CC6000-10-3200LCWW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(X16,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(X16,Table16[],4,FALSE))),\"\")","v":1513.49},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($K$7/$D$17,0),\"\")","v":1},1513.49,null,{"$f":"IF(AND($G$10<>\"NA\",$D16=\"Yes\"),\"CC6000\",\"\")","v":"CC6000"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AD$16,Table16[],2,FALSE),\"\")","v":"CC6000-10-3200LCWW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AD16,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AD16,Table16[],4,FALSE))),\"\")","v":1513.49},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($L$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AG16>0,AF16*AG16,\"\"),\"\")","v":3026.98},null,{"$f":"IF(AND($G$10<>\"NA\",$D16=\"Yes\"),\"CC6000\",\"\")","v":"CC6000"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AJ$16,Table16[],2,FALSE),\"\")","v":"CC6000-10-3200LCWW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AJ16,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ16,Table16[],4,FALSE))),\"\")","v":1513.49},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($M$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AM16>0,AL16*AM16,\"\"),\"\")","v":3026.98},null,{"$f":"IF(AND($G$10<>\"NA\",$D16=\"Yes\"),\"CC6000\",\"\")","v":"CC6000"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AP$16,Table16[],2,FALSE),\"\")","v":"CC6000-10-3200LCWW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AP16,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AP16,Table16[],4,FALSE))),\"\")","v":1513.49},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($N$7/$D$17,0),\"\")","v":3},4540.47]
[null,"Cabinets per CC6000",null,2,{"$f":"VLOOKUP(D18,Table5[],2,FALSE)","v":1},null,null,null,"Greatest expansion",null,null,{"$f":"OFFSET(INDIRECT(CELL(\"address\",INDEX($J$9:$N$9,MATCH(MAX($J$9:N9),$J$9:$N$9,0)))),-4,0)","v":"Large"},{"$f":"MAX(J9,K9,L9,M9,N9)","v":20},null,null,null,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 PSU\",\"\")","v":"CC6000 PSU"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(R17,Table16[],2,FALSE),\"\")","v":"PWR-BUA5V16W0WW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(R17,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(R17,Table16[],4,FALSE))),\"\")","v":31.09},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($J$7/$D$17,0),\"\")","v":1},31.09,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 PSU\",\"\")","v":"CC6000 PSU"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(X17,Table16[],2,FALSE),\"\")","v":"PWR-BUA5V16W0WW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(X17,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(X17,Table16[],4,FALSE))),\"\")","v":31.09},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($K$7/$D$17,0),\"\")","v":1},31.09,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 PSU\",\"\")","v":"CC6000 PSU"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AD17,Table16[],2,FALSE),\"\")","v":"PWR-BUA5V16W0WW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AD17,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AD17,Table16[],4,FALSE))),\"\")","v":31.09},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($L$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AG17>0,AF17*AG17,\"\"),\"\")","v":62.18},null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 PSU\",\"\")","v":"CC6000 PSU"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AJ17,Table16[],2,FALSE),\"\")","v":"PWR-BUA5V16W0WW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AJ17,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ17,Table16[],4,FALSE))),\"\")","v":31.09},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($M$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AM17>0,AL17*AM17,\"\"),\"\")","v":62.18},null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 PSU\",\"\")","v":"CC6000 PSU"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AP17,Table16[],2,FALSE),\"\")","v":"PWR-BUA5V16W0WW"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AP17,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AP17,Table16[],4,FALSE))),\"\")","v":31.09},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($N$7/$D$17,0),\"\")","v":3},93.27]
[null,"CC6000 Mount",null,"Yes",1,null,null,null,null,null,null,null,null,{"$f":"IF($G$10<>\"NA\",Device_Cabinet_Data!$R$69,Device_Cabinet_Data!$R$71)","v":"m²"},null,null,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 DC Cable\",\"\")","v":"CC6000 DC Cable"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(R18,Table16[],2,FALSE),\"\")","v":"CBL-DC-383A1-01"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(R18,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(R18,Table16[],4,FALSE))),\"\")","v":6.54},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($J$7/$D$17,0),\"\")","v":1},6.54,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 DC Cable\",\"\")","v":"CC6000 DC Cable"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(X18,Table16[],2,FALSE),\"\")","v":"CBL-DC-383A1-01"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(X18,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(X18,Table16[],4,FALSE))),\"\")","v":6.54},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($K$7/$D$17,0),\"\")","v":1},6.54,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 DC Cable\",\"\")","v":"CC6000 DC Cable"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AD18,Table16[],2,FALSE),\"\")","v":"CBL-DC-383A1-01"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AD18,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AD18,Table16[],4,FALSE))),\"\")","v":6.54},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($L$7/$D$17,0),\"\")","v":2},13.08,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 DC Cable\",\"\")","v":"CC6000 DC Cable"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AJ18,Table16[],2,FALSE),\"\")","v":"CBL-DC-383A1-01"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AJ18,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ18,Table16[],4,FALSE))),\"\")","v":6.54},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($M$7/$D$17,0),\"\")","v":2},13.08,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"CC6000 DC Cable\",\"\")","v":"CC6000 DC Cable"},{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),VLOOKUP(AP18,Table16[],2,FALSE),\"\")","v":"CBL-DC-383A1-01"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10=\"EU\",VLOOKUP(AP18,Table16[],3,FALSE),IF($G$10=\"UK\",VLOOKUP(AP18,Table16[],4,FALSE))),\"\")","v":6.54},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($N$7/$D$17,0),\"\")","v":3},19.62]
[null,"Stadium Compatible",null,{"$f":"IF(F19=1,\"Yes\",\"No\")","v":"Yes"},1,{"$f":"VLOOKUP(D9,Table813[],20,FALSE)","v":1},null,"Alternative Mixed \nCabinet Type\nSolution",null,"Extreme","X-Large","Large","Midi","Small",null,null,null,{"$f":"IF($D$18=\"Yes\",\"CC6000 Bracket\",\"\")","v":"CC6000 Bracket"},{"$f":"IF(AND($D$16=\"Yes\",$D$18=\"Yes\"),VLOOKUP(R$5,Table10[],4,FALSE),\"\")","v":"CS-CAB-MNTG-C6-R2"},{"$f":"IF($S19<>\"\",IF($G$10=\"EU\",VLOOKUP(R$5,Table10[],5,FALSE),IF($G$10=\"UK\",VLOOKUP(R$5,Table10[],6,FALSE),IF($G$10=\"NA\",VLOOKUP(R$5,Table10[],7,FALSE),\"\"))),\"\")","v":221.54},{"$f":"IF(S$19<>\"\",ROUNDUP($J$7/$D$17,0),\"\")","v":1},221.54,null,{"$f":"IF($D$18=\"Yes\",\"CC6000 Bracket\",\"\")","v":"CC6000 Bracket"},{"$f":"IF(AND($D$16=\"Yes\",$D$18=\"Yes\"),VLOOKUP(X$5,Table10[],4,FALSE),\"\")","v":"CS-CAB-MNTG-C6-R2"},{"$f":"IF($S19<>\"\",IF($G$10=\"EU\",VLOOKUP(X$5,Table10[],5,FALSE),IF($G$10=\"UK\",VLOOKUP(X$5,Table10[],6,FALSE),IF($G$10=\"NA\",VLOOKUP(X$5,Table10[],7,FALSE),\"\"))),\"\")","v":221.54},{"$f":"IF(Y$19<>\"\",ROUNDUP($K$7/$D$17,0),\"\")","v":1},221.54,null,{"$f":"IF($D$18=\"Yes\",\"CC6000 Bracket\",\"\")","v":"CC6000 Bracket"},{"$f":"IF(AND($D$16=\"Yes\",$D$18=\"Yes\"),VLOOKUP(AD$5,Table10[],4,FALSE),\"\")","v":"CS-CAB-MNTG-C6-R1"},{"$f":"IF($S19<>\"\",IF($G$10=\"EU\",VLOOKUP(AD$5,Table10[],5,FALSE),IF($G$10=\"UK\",VLOOKUP(AD$5,Table10[],6,FALSE),IF($G$10=\"NA\",VLOOKUP(AD$5,Table10[],7,FALSE),\"\"))),\"\")","v":221.54},{"$f":"IF(AE$19<>\"\",ROUNDUP($L$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AG19>0,AF19*AG19,\"\"),\"\")","v":443.08},null,{"$f":"IF($D$18=\"Yes\",\"CC6000 Bracket\",\"\")","v":"CC6000 Bracket"},{"$f":"IF(AND($D$16=\"Yes\",$D$18=\"Yes\"),VLOOKUP(AJ$5,Table10[],4,FALSE),\"\")","v":"CS-CAB-MNTG-C6"},{"$f":"IF($S19<>\"\",IF($G$10=\"EU\",VLOOKUP(AJ$5,Table10[],5,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ$5,Table10[],6,FALSE),IF($G$10=\"NA\",VLOOKUP(AJ$5,Table10[],7,FALSE),\"\"))),\"\")","v":78.400000000000006},{"$f":"IF(AK$19<>\"\",ROUNDUP($M$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AM19>0,AL19*AM19,\"\"),\"\")","v":156.80000000000001},null,{"$f":"IF($D$18=\"Yes\",\"CC6000 Bracket\",\"\")","v":"CC6000 Bracket"},{"$f":"IF(AND($D$16=\"Yes\",$D$18=\"Yes\"),VLOOKUP(AP$5,Table10[],4,FALSE),\"\")","v":"CS-CAB-MNTG-C6"},{"$f":"IF($S19<>\"\",IF($G$10=\"EU\",VLOOKUP(AP$5,Table10[],5,FALSE),IF($G$10=\"UK\",VLOOKUP(AP$5,Table10[],6,FALSE),IF($G$10=\"NA\",VLOOKUP(AP$5,Table10[],7,FALSE),\"\"))),\"\")","v":78.400000000000006},{"$f":"IF(AQ$19<>\"\",ROUNDUP($N$7/$D$17,0),\"\")","v":3},235.20000000000002]
[null,"Use Stadium Shelves",null,"Yes",{"$f":"IF(AND($D$20=\"Yes\",$G$10=\"NA\"),2,1)","v":1},{"$f":"IF(AND($D$20=\"Yes\",F19=1),1,0)","v":1},null,null,"Devices per cabinet",{"$f":"J6","v":100},{"$f":"K6","v":50},{"$f":"L6","v":40},{"$f":"M6","v":30},{"$f":"N6","v":20},null,null,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"IEC Lead CC6000\",\"\")","v":"IEC Lead CC6000"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10<>\"NA\",Device_Cabinet_Data!$F$71,Device_Cabinet_Data!$F$74),\"\")","v":"CS-CC6-IEC"},{"$f":"IF($S$20<>\"\",IF($D$16=\"Yes\", IF($G$10=\"EU\",VLOOKUP(S20,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(S20,Table4[],3,FALSE),VLOOKUP(S20,Table4[],4,FALSE))),\"\"),\"\")","v":7.7},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($J$7/$D$17,0),\"\")","v":1},7.7,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"IEC Lead CC6000\",\"\")","v":"IEC Lead CC6000"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10<>\"NA\",Device_Cabinet_Data!$F$71,Device_Cabinet_Data!$F$74),\"\")","v":"CS-CC6-IEC"},{"$f":"IF($Y$20<>\"\",IF($D$16=\"Yes\", IF($G$10=\"EU\",VLOOKUP(Y20,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(Y20,Table4[],3,FALSE),VLOOKUP(Y20,Table4[],4,FALSE))),\"\"),\"\")","v":7.7},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($K$7/$D$17,0),\"\")","v":1},7.7,null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"IEC Lead CC6000\",\"\")","v":"IEC Lead CC6000"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10<>\"NA\",Device_Cabinet_Data!$F$71,Device_Cabinet_Data!$F$74),\"\")","v":"CS-CC6-IEC"},{"$f":"IF($AE$20<>\"\",IF($D$16=\"Yes\", IF($G$10=\"EU\",VLOOKUP(AE20,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AE20,Table4[],3,FALSE),VLOOKUP(AE20,Table4[],4,FALSE))),\"\"),\"\")","v":7.7},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($L$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AG20>0,AF20*AG20,\"\"),\"\")","v":15.4},null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"IEC Lead CC6000\",\"\")","v":"IEC Lead CC6000"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10<>\"NA\",Device_Cabinet_Data!$F$71,Device_Cabinet_Data!$F$74),\"\")","v":"CS-CC6-IEC"},{"$f":"IF($AK$20<>\"\",IF($D$16=\"Yes\", IF($G$10=\"EU\",VLOOKUP(AK20,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AK20,Table4[],3,FALSE),VLOOKUP(AK20,Table4[],4,FALSE))),\"\"),\"\")","v":7.7},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($M$7/$D$17,0),\"\")","v":2},{"$f":"IFERROR(IF(AM20>0,AL20*AM20,\"\"),\"\")","v":15.4},null,{"$f":"IF(AND($G$10<>\"NA\",$D$16=\"Yes\"),\"IEC Lead CC6000\",\"\")","v":"IEC Lead CC6000"},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),IF($G$10<>\"NA\",Device_Cabinet_Data!$F$71,Device_Cabinet_Data!$F$74),\"\")","v":"CS-CC6-IEC"},{"$f":"IF($AQ$20<>\"\",IF($D$16=\"Yes\", IF($G$10=\"EU\",VLOOKUP(AQ20,Table4[],2,FALSE),IF($G$10=\"UK\",VLOOKUP(AQ20,Table4[],3,FALSE),VLOOKUP(AQ20,Table4[],4,FALSE))),\"\"),\"\")","v":7.7},{"$f":"IF(AND($D$16=\"Yes\",$G$10<>\"NA\"),ROUNDUP($N$7/$D$17,0),\"\")","v":3},23.1]
[null,"Cradle Lock Compatible",null,{"$f":"IF(F21=1,\"Yes\", \"No\")","v":"Yes"},null,{"$f":"VLOOKUP(D9,Table813[],2,FALSE)","v":1},null,null,"No of Main Cabinets",{"$f":"IFERROR(IF(INT($D$5/J$6)=0,\"1\",INT($D$5/J$6)),\"\")","v":1},{"$f":"IFERROR(IF(INT($D$5/K$6)=0,\"1\",INT($D$5/K$6)),\"\")","v":2},{"$f":"IFERROR(IF(INT($D$5/L$6)=0,\"1\",INT($D$5/L$6)),\"\")","v":2},{"$f":"IFERROR(IF(INT($D$5/M$6)=0,\"1\",INT($D$5/M$6)),\"\")","v":3},{"$f":"IFERROR(IF(INT($D$5/N$6)=0,\"1\",INT($D$5/N$6)),\"\")","v":5},null,null,null,{"$f":"IF($D$22=\"Yes\",\"Cradle Lock\",\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($D$11=\"No\",VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],22,FALSE),VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],23,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($G$10=\"NA\",VLOOKUP(S$21,Table15[],3,FALSE),VLOOKUP(S$21,Table15[],2,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",$D$12,\"\")","v":""},"",null,{"$f":"IF($D$22=\"Yes\",\"Cradle Lock\",\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($D$11=\"No\",VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],22,FALSE),VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],23,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($G$10=\"NA\",VLOOKUP(Y$21,Table15[],3,FALSE),VLOOKUP(Y$21,Table15[],2,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",$D$12,\"\")","v":""},"",null,{"$f":"IF($D$22=\"Yes\",\"Cradle Lock\",\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($D$11=\"No\",VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],22,FALSE),VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],23,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($G$10=\"NA\",VLOOKUP(AE$21,Table15[],3,FALSE),VLOOKUP(AE$21,Table15[],2,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",$D$12,\"\")","v":""},{"$f":"IFERROR(IF(AG21>0,AF21*AG21,\"\"),\"\")","v":""},null,{"$f":"IF($D$22=\"Yes\",\"Cradle Lock\",\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($D$11=\"No\",VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],22,FALSE),VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],23,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($G$10=\"NA\",VLOOKUP(AK$21,Table15[],3,FALSE),VLOOKUP(AK$21,Table15[],2,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",$D$12,\"\")","v":""},{"$f":"IFERROR(IF(AM21>0,AL21*AM21,\"\"),\"\")","v":""},null,{"$f":"IF($D$22=\"Yes\",\"Cradle Lock\",\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($D$11=\"No\",VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],22,FALSE),VLOOKUP($D$9,Table813[[Device]:[Cradle Lock - Toaster]],23,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",IF($G$10=\"NA\",VLOOKUP(AQ$21,Table15[],3,FALSE),VLOOKUP(AQ$21,Table15[],2,FALSE)),\"\")","v":""},{"$f":"IF($D$22=\"Yes\",$D$12,\"\")","v":""},""]
[null,"With Cradle Locks",null,"No",null,{"$f":"IF(D22=\"Yes\",1,0)","v":0},null,null,"Remainder",{"$f":"IF($D$5-(J21*J6)>0,$D$5-(J21*J6),0)","v":0},{"$f":"IF($D$5-(K21*K6)>0,$D$5-(K21*K6),0)","v":0},{"$f":"IF($D$5-(L21*L6)>0,$D$5-(L21*L6),0)","v":20},{"$f":"IF($D$5-(M21*M6)>0,$D$5-(M21*M6),0)","v":10},{"$f":"IF($D$5-(N21*N6)>0,$D$5-(N21*N6),0)","v":0},null,null,null,{"$f":"IF($D$23=\"Base\",\"Cabinet Base\",IF($D$23=\"Wall\",\"Wall Mounted\",\"\"))","v":""},{"$f":"IF($D$23=\"Base\",VLOOKUP(R5,Table10[],3,FALSE),IF($D$23=\"Wall\",\"Not Compatible\",\"\"))","v":""},{"$f":"IF($D$23=\"Yes\",IF($G$10=\"EU\",VLOOKUP(R$5,Table10[],22,FALSE),IF($G$10=\"UK\",VLOOKUP(R$5,Table10[],23,FALSE),VLOOKUP(R$5,Table10[],24,FALSE))),\"\")","v":""},{"$f":"IF(AND($D$23=\"Yes\",S22<>\"Not Compatible\"),J7,\"\")","v":""},"",null,{"$f":"IF($D$23=\"Base\",\"Cabinet Base\",IF($D$23=\"Wall\",\"Wall Mounted\",\"\"))","v":""},{"$f":"IF($D$23=\"Base\",VLOOKUP(X5,Table10[],3,FALSE),IF($D$23=\"Wall\",\"Not Compatible\",\"\"))","v":""},{"$f":"IF($D$23=\"Yes\",IF($G$10=\"EU\",VLOOKUP(X$5,Table10[],22,FALSE),IF($G$10=\"UK\",VLOOKUP(X$5,Table10[],23,FALSE),VLOOKUP(X$5,Table10[],24,FALSE))),\"\")","v":""},{"$f":"IF(AND($D$23=\"Yes\",Y22<>\"Not Compatible\"),K7,\"\")","v":""},"",null,{"$f":"IF($D$23=\"Base\",\"Cabinet Base\",IF($D$23=\"Wall\",\"Wall Mounted\",\"\"))","v":""},{"$f":"IF($D$23=\"Base\",VLOOKUP(AD5,Table10[],3,FALSE),IF($D$23=\"Wall\",\"Not Compatible\",\"\"))","v":""},{"$f":"IF($D$23=\"Yes\",IF($G$10=\"EU\",VLOOKUP(AD$5,Table10[],22,FALSE),IF($G$10=\"UK\",VLOOKUP(AD$5,Table10[],23,FALSE),VLOOKUP(AD$5,Table10[],24,FALSE))),\"\")","v":""},{"$f":"IF(AND($D$23=\"Base\",AE22<>\"Not Compatible\"),L7,\"\")","v":""},{"$f":"IFERROR(IF(AG22>0,AF22*AG22,\"\"),\"\")","v":""},null,{"$f":"IF($D$23=\"Base\",\"Cabinet Base\",IF($D$23=\"Wall\",\"Wall Mounted\",\"\"))","v":""},{"$f":"IF($D$23=\"Base\",VLOOKUP(AJ5,Table10[],3,FALSE),IF($D$23=\"Wall\",\"Included\",\"\"))","v":""},{"$f":"IF($D$23=\"Yes\",IF($G$10=\"EU\",VLOOKUP(AJ$5,Table10[],22,FALSE),IF($G$10=\"UK\",VLOOKUP(AJ$5,Table10[],23,FALSE),VLOOKUP(AJ$5,Table10[],24,FALSE))),\"\")","v":""},{"$f":"IF(AND($D$23=\"Base\",AK22<>\"Not Compatible\"),M7,\"\")","v":""},{"$f":"IFERROR(IF(AM22>0,AL22*AM22,\"\"),\"\")","v":""},null,{"$f":"IF($D$23=\"Base\",\"Cabinet Base\",IF($D$23=\"Wall\",\"Wall Mounted\",\"\"))","v":""},{"$f":"IF($D$23=\"Base\",VLOOKUP(AP5,Table10[],3,FALSE),IF($D$23=\"Wall\",\"Included\",\"\"))","v":""},{"$f":"IF($D$23=\"Yes\",IF($G$10=\"EU\",VLOOKUP(AP$5,Table10[],22,FALSE),IF($G$10=\"UK\",VLOOKUP(AP$5,Table10[],23,FALSE),VLOOKUP(AP$5,Table10[],24,FALSE))),\"\")","v":""},{"$f":"IF(AND($D$23=\"Base\",AQ22<>\"Not Compatible\"),N7,\"\")","v":""},""]
[null,"Base Unit / Wall Mount",null,"None",null,{"$f":"IF($D$23=\"None\",1,0)","v":1},{"$f":"IF($D$23=\"Wall\",2,IF($D$23=\"Base\",1,0))","v":0},null,"Supplemental Cabinet",{"$f":"IF(J$22>0,IF(J$22<=$N$6,$N$5,IF(J$22<=$M$6,$M$5,IF(J$22<=$L$6,$L$5,IF(J$22<=$K$6,$K$5,IF(J$22<=J$6,J$5,\"\"))))),\"None\")","v":"None"},{"$f":"IF(K$22>0,IF(K$22<=$N$6,$N$5,IF(K$22<=$M$6,$M$5,IF(K$22<=$L$6,$L$5,IF(K$22<=$K$6,$K$5,IF(K$22<=K$6,K$5,\"\"))))),\"None\")","v":"None"},{"$f":"IF(L$22>0,IF(L$22<=$N$6,$N$5,IF(L$22<=$M$6,$M$5,IF(L$22<=$L$6,$L$5,IF(L$22<=$K$6,$K$5,IF(L$22<=L$6,L$5,\"\"))))),\"None\")","v":"Small"},{"$f":"IF(M$22>0,IF(M$22<=$N$6,$N$5,IF(M$22<=$M$6,$M$5,IF(M$22<=$L$6,$L$5,IF(M$22<=$K$6,$K$5,IF(M$22<=M$6,M$5,\"\"))))),\"None\")","v":"Small"},{"$f":"IF(N$22>0,IF(N$22<=$N$6,$N$5,IF(N$22<=$M$6,$M$5,IF(N$22<=$L$6,$L$5,IF(N$22<=$K$6,$K$5,IF(N$22<=N$6,N$5,\"\"))))),\"None\")","v":"None"},null,null,null,{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),\"Device Bracket\",\"\")","v":""},{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),VLOOKUP($D$9,Table813[],29,FALSE),\"\")","v":""},{"$f":"IF($R$23<>\"\",IF($G$10=\"EU\",VLOOKUP($D$9,Table813[],30,FALSE),IF($G$10=\"UK\",VLOOKUP($D$9,Table813[],31,FALSE),IF($G$10=\"NA\",VLOOKUP($D$9,Table813[],32,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AND($D$24=\"Yes\",$F$24=1),$D$12,\"\")","v":""},"",null,{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),\"Device Bracket\",\"\")","v":""},{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),VLOOKUP($D$9,Table813[],29,FALSE),\"\")","v":""},{"$f":"IF($X$23<>\"\",IF($G$10=\"EU\",VLOOKUP($D$9,Table813[],30,FALSE),IF($G$10=\"UK\",VLOOKUP($D$9,Table813[],31,FALSE),IF($G$10=\"NA\",VLOOKUP($D$9,Table813[],32,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AND($D$24=\"Yes\",$F$24=1),$D$12,\"\")","v":""},"",null,{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),\"Device Bracket\",\"\")","v":""},{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),VLOOKUP($D$9,Table813[],29,FALSE),\"\")","v":""},{"$f":"IF($AD$23<>\"\",IF($G$10=\"EU\",VLOOKUP($D$9,Table813[],30,FALSE),IF($G$10=\"UK\",VLOOKUP($D$9,Table813[],31,FALSE),IF($G$10=\"NA\",VLOOKUP($D$9,Table813[],32,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AND($D$24=\"Yes\",$F$24=1),$D$12,\"\")","v":""},{"$f":"IFERROR(IF(AG23>0,AF23*AG23,\"\"),\"\")","v":""},null,{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),\"Device Bracket\",\"\")","v":""},{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),VLOOKUP($D$9,Table813[],29,FALSE),\"\")","v":""},{"$f":"IF($AJ$23<>\"\",IF($G$10=\"EU\",VLOOKUP($D$9,Table813[],30,FALSE),IF($G$10=\"UK\",VLOOKUP($D$9,Table813[],31,FALSE),IF($G$10=\"NA\",VLOOKUP($D$9,Table813[],32,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AND($D$24=\"Yes\",$F$24=1),$D$12,\"\")","v":""},{"$f":"IFERROR(IF(AM23>0,AL23*AM23,\"\"),\"\")","v":""},null,{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),\"Device Bracket\",\"\")","v":""},{"$f":"IF(AND($F$24=1,$D$24=\"Yes\"),VLOOKUP($D$9,Table813[],29,FALSE),\"\")","v":""},{"$f":"IF($AP$23<>\"\",IF($G$10=\"EU\",VLOOKUP($D$9,Table813[],30,FALSE),IF($G$10=\"UK\",VLOOKUP($D$9,Table813[],31,FALSE),IF($G$10=\"NA\",VLOOKUP($D$9,Table813[],32,FALSE),\"\"))),\"\")","v":""},{"$f":"IF(AND($D$24=\"Yes\",$F$24=1),$D$12,\"\")","v":""},""]
[null,{"$f":"IF($F$24<>0, \"Aux Bracket Required\",\"Aux Bracket Not Required\")","v":"Aux Bracket Not Required"},null,"Yes",null,{"$f":"IF(VLOOKUP(D9,Table813[],29,FALSE)<>\"\",1,0)","v":0},null,null,"Expansion\nCapacity",{"$f":"IF(J23=\"None\",(J$6*J$21)-$D$5,(HLOOKUP(J23,$J$5:$N$6,2,FALSE))-J22)","v":0},{"$f":"IF(K23=\"None\",(K$6*K$21)-$D$5,(HLOOKUP(K23,$J$5:$N$6,2,FALSE))-K22)","v":0},{"$f":"IF(L23=\"None\",(L$6*L$21)-$D$5,(HLOOKUP(L23,$J$5:$N$6,2,FALSE))-L22)","v":0},{"$f":"IF(M23=\"None\",(M$6*M$21)-$D$5,(HLOOKUP(M23,$J$5:$N$6,2,FALSE))-M22)","v":10},{"$f":"IF(N23=\"None\",(N$6*N$21)-$D$5,(HLOOKUP(N23,$J$5:$N$6,2,FALSE))-N22)","v":0},null,null,null,null,null,"Total",null,{"$f":"SUM(V8:V23)","v":16734.840000000004},null,null,null,"Total",null,{"$f":"SUM(AB8:AB23)","v":17955.520000000004},null,null,null,"Total",null,{"$f":"SUM(AH8:AH23)","v":20528.050000000007},null,null,null,"Total",null,{"$f":"SUM(AN8:AN23)","v":21542.959999999999},null,null,null,"Total",null,{"$f":"SUM(AT8:AT23)","v":21678.66}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$10<>\"NA\",ROUND($J$7*Device_Cabinet_Data!$N$64,2),ROUND($J$7*Device_Cabinet_Data!$N$64*Device_Cabinet_Data!$B$55,2))","v":0.52},null,null,null,null,null,{"$f":"IF($G$10<>\"NA\",ROUND($K$7*Device_Cabinet_Data!$N$64,2),ROUND($K$7*Device_Cabinet_Data!$N$64*Device_Cabinet_Data!$B$55,2))","v":1.05},null,null,null,null,null,{"$f":"IF($G$10<>\"NA\",ROUND($L$7*Device_Cabinet_Data!$N$64,2),ROUND($L$7*Device_Cabinet_Data!$N$64*Device_Cabinet_Data!$B$55,2))","v":1.57},null,null,null,null,null,{"$f":"IF($G$10<>\"NA\",ROUND($M$7*Device_Cabinet_Data!$N$64,2),ROUND($M$7*Device_Cabinet_Data!$N$64*Device_Cabinet_Data!$B$55,2))","v":2.1},null,null,null,null,null,{"$f":"IF($G$10<>\"NA\",ROUND($N$7*Device_Cabinet_Data!$N$64,2),ROUND($N$7*Device_Cabinet_Data!$N$64*Device_Cabinet_Data!$B$55,2))","v":2.62}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$10=\"NA\",ROUND(S$26*Device_Cabinet_Data!$B$55,2),ROUND(S$26,2))","v":2.29},{"$f":"IF($D$23=\"Yes\",$J$7*VLOOKUP(R$5,Table13[],19,FALSE),$J$7*VLOOKUP(R$5,Table13[],15,FALSE))","v":2.2944},null,null,null,null,{"$f":"IF($G$10=\"NA\",ROUND(Y$26*Device_Cabinet_Data!$B$55,2),ROUND(Y$26,2))","v":2.68},{"$f":"IF($D$23=\"Yes\",$K$7*VLOOKUP(X$5,Table13[],19,FALSE),$K$7*VLOOKUP(X$5,Table13[],15,FALSE))","v":2.6768000000000001},null,null,null,null,{"$f":"IF($G$10=\"NA\",ROUND(AE$26*Device_Cabinet_Data!$B$55,2),ROUND(AE$26,2))","v":3.39},{"$f":"IF($D$23=\"Yes\",$L$7*VLOOKUP(AD$5,Table13[],19,FALSE),$L$7*VLOOKUP(AD$5,Table13[],15,FALSE))","v":3.3852000000000002},null,null,null,null,{"$f":"IF($G$10=\"NA\",ROUND(AK$26*Device_Cabinet_Data!$B$55,2),ROUND(AK$26,2))","v":3.67},{"$f":"IF($D$23=\"Yes\",$M$7*VLOOKUP(AJ$5,Table13[],19,FALSE),$M$7*VLOOKUP(AJ$5,Table13[],15,FALSE))","v":3.6736},null,null,null,null,{"$f":"IF($G$10=\"NA\",ROUND(AQ$26*Device_Cabinet_Data!$B$55,2),ROUND(AQ$26,2))","v":3.54},{"$f":"IF($D$23=\"Yes\",$N$7*VLOOKUP(AP$5,Table13[],19,FALSE),$N$7*VLOOKUP(AP$5,Table13[],15,FALSE))","v":3.5420000000000003}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r4"]

{"sheet":"Sheet1","index":6,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[[18,6,18,7],[20,6,20,7],[22,6,22,7],[12,6,12,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[14,6,14,7],[15,6,15,7],[17,6,17,7],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[7,6,7,7],[8,6,8,7],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[7,1,7,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
[]
[]
[null,"Select Your Device",null,"D9","Same","D9","Select Your Device"]
[null,"Select Your Country",null,"D10","Same","D10","Select Your Country"]
[null,"Cradles with Battery Charger",null,"D11","Same","D11","Cradles with Battery Charger"]
[null,"Qty of Cradles to be housed",null,"D12","Same","D12","Qty of Cradles to be housed"]
[null,"Use CC6000",null,"D13"]
[null,"Cabinets per CC6000",null,"D14",null,"D13","AMS Compatible"]
[null,"CC6000 Mount",null,"D15",null,"D14","Access Management System"]
[null,"TC8xxx Vertical Bracket",null,"D16",null,"D15","AMS License Duration"]
[null,"Stadium Compatible",null,"D17",null,"D16","Use CC6000"]
[null,"Use Stadium Shelves",null,"D18",null,"D17","Cabinets per CC6000"]
[null,"Cradle Lock Compatible",null,"D19",null,"D18","CC6000 Mount"]
[null,"With Cradle Locks",null,"D20"]
[null,"Cabinet Base",null,"D21",null,"D19","Stadium Compatible"]
[null,"AMS Compatible",null,"D22",null,"D20","Use Stadium Shelves"]
[null,"Access Management System",null,"D23"]
[null,"AMS License Duration",null,"D24",null,"D21","Cradle Lock Compatible"]
[null,null,null,null,null,"D22","With Cradle Locks"]
[]
[null,null,null,null,null,"D23","Cabinet Base"]
[]
[null,null,null,null,null,"D24","TC8xxx Vertical Bracket"]