{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["READ ME FIRST","Selection","List","Background worksheet"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":12,"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":"READ ME FIRST","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,6,17,8],[17,1,17,3],[18,1,18,3],[12,1,12,3],[0,0,0,3],[12,0,18,0],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[16,6,16,8],[8,1,8,3],[9,1,9,3],[10,1,10,3],[7,1,7,3],[15,5,15,8]]}
["Weblinks to technical docs and resources:"]
["EkipUP+","Edge Gateway","E-kit","Ability™ Canada"]
["Product webpage","Webpage (with videos)","Product webpage"]
["Tech catalog","Brochure","Brochure"]
["User Manual","User Manual","User Manual"]
["Videomanuals","Ability™ enabled","Setup video"]
[]
["Product","Intended use"]
["EkipUP+","Monitoring, protection and control device to digitally upgrade existing electrical and/or electrically operated equipment, with visualization on Ability™ Energy Manager cloud-native SaaS"]
["Edge Industrial Gateway (EIG)","Secure gateway to integrate multiple smart devices (LV and MV) from ABB on Modbus TCP and/or Modbus RTU, for visualization in Ability™ Energy Manager cloud-native SaaS. EIG is required to integrate other ABB products like SWICOM, Relion, PSTX, TVOC2, CMS-700, SCU100, UPS, etc. Note: EkipUP+ or Emax2 or TmaxXT can each connect directly via Ekip Com Hub module. "]
["E-kit","Universal gateway to integrate 3rd party (non-ABB) devices on Modbus (RTU/TCP) only, for visualization on Ability™ Energy Manager cloud-native SaaS. Note: since E-kit does not have cybersecurity in-built, it is required to use EIG for Ability™ cloud connectivity "]
[]
["Note: firmwares enable specific functionalities in EkipUP+ and are described in the EkipUP+ Tech Catalog (weblink above)","Links to EkipUP+ firmware sold on ABB Marketplace"]
[null,"Monitor to Protect for EkipUP+ (device upgrade)"]
[null,"Power Controller for Ekip (kW-based load management)"]
[null,"Generator Protections for Ekip | ABB Ability Marketplace™",null,null,null,"Video guide to using this selector"]
[null,"Motor Protection for Ekip | ABB Ability Marketplace™",null,null,null,"Jump to:","Selection page"]
[null,"IPS - Interface Protection for Ekip | ABB Ability Marketplace™",null,null,null,"Email us:","ability@ca.abb.com"]
[null,"Adaptive Load Shedding for Ekip | ABB Ability Marketplace™"]

{"sheet":"Selection","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,3,1,5],[1,0,1,1],[17,0,17,1],[18,3,18,5],[24,3,26,5],[27,0,28,0],[29,0,30,0],[31,0,32,0],[34,3,34,5],[33,3,33,5]]}
["Application-related questions","Selection options",null,"Part number","Description","Quantity"]
["EkipUP+ (supplied as loose parts or enclosed \"plug & play\" solution)",null,null,"EkipUP+ (available as loose parts or enclosed \"plug & play\")"]
["What will the EkipUP+ device be used for mainly?","Not required",null,{"$f":"'Background worksheet'!D2","v":"Not selected"},{"$f":"'Background worksheet'!E2","v":"Not selected"},{"$f":"'Background worksheet'!F2","v":0}]
["How many EkipUP+ units are required?",0,null,{"$f":"'Background worksheet'!D4","v":"Loose parts"},{"$f":"'Background worksheet'!E4","v":"Loose parts only"},{"$f":"'Background worksheet'!F4","v":0}]
["Is an enclosed \"plug & play\" solution required or just loose parts?","Loose parts only",null,{"$f":"'Background worksheet'!D5","v":"Not selected"},{"$f":"'Background worksheet'!E5","v":"None"},{"$f":"'Background worksheet'!F5","v":0}]
["What is the ampere rating of the network/section to be monitored?","None",null,{"$f":"'Background worksheet'!D7","v":"1SDA104662R1"},{"$f":"'Background worksheet'!E7","v":"Insertion bridges, Type-D"},{"$f":"'Background worksheet'!F5","v":0}]
["What is the network voltage?","600V 3-ph 60Hz",null,{"$f":"'Background worksheet'!D6","v":"None"},{"$f":"'Background worksheet'!E6","v":"Ekip Supply auto-selected with EkipUP+"},{"$f":"'Background worksheet'!F6","v":0}]
["Is the network 3-phase, 3-wire or 3-phase, 4-wire?","Not required",null,{"$f":"'Background worksheet'!D8","v":"Not selected"},{"$f":"'Background worksheet'!E8","v":"Not selected"},{"$f":"'Background worksheet'!F8","v":0}]
["What diameter of sensors would best fit the busbars?","200mm",null,{"$f":"'Background worksheet'!D9","v":"Not selected"},{"$f":"'Background worksheet'!E9","v":"Not selected"},{"$f":"'Background worksheet'!F9","v":0}]
["Will the EkipUP+ unit communicate with Ability™ cloud?","No",null,{"$f":"'Background worksheet'!D10","v":"Not selected"},{"$f":"'Background worksheet'!E10","v":"Not selected"},{"$f":"'Background worksheet'!F10","v":0}]
["What additional communication protocol is needed?","None",null,{"$f":"'Background worksheet'!D11","v":"Not selected"},{"$f":"'Background worksheet'!E11","v":"Not selected"},{"$f":"'Background worksheet'!F11","v":0}]
["Is redundant communication required?","No",null,{"$f":"'Background worksheet'!D12","v":"n/a"},{"$f":"'Background worksheet'!E12","v":"n/a"},{"$f":"'Background worksheet'!F12","v":0}]
["Does ambient panel temperature need to be measured?","No",null,{"$f":"'Background worksheet'!D13","v":"n/a"},{"$f":"'Background worksheet'!E13","v":"n/a"},{"$f":"'Background worksheet'!F13","v":0}]
["If yes, how many PT1000 probes are required per EkipUP+ unit?",0,null,{"$f":"'Background worksheet'!D14","v":"n/a"},{"$f":"'Background worksheet'!E14","v":"n/a"},{"$f":"'Background worksheet'!F14","v":0}]
["How many additional digital I/O might be required per EkipUP+?",0,null,{"$f":"'Background worksheet'!D15","v":"n/a"},{"$f":"'Background worksheet'!E15","v":"n/a"},{"$f":"'Background worksheet'!F15","v":0}]
["How many years of extended warranty are needed?","None",null,{"$f":"'Background worksheet'!D16","v":"n/a"},{"$f":"'Background worksheet'!E16","v":"n/a"},{"$f":"'Background worksheet'!F16","v":0}]
["Is an Ekip programming cable already available on site?","No",null,{"$f":"'Background worksheet'!D17","v":"Not selected"},{"$f":"'Background worksheet'!E17","v":"None"},{"$f":"'Background worksheet'!F17","v":0}]
["Edge Industrial Gateway and E-kit (supplied as loose parts only)",null,null,{"$f":"'Background worksheet'!D18","v":"1SDA076154R1"},{"$f":"'Background worksheet'!E18","v":"1SDA076154R1"},{"$f":"'Background worksheet'!F18","v":1}]
["Do any other ABB devices need to be added to the same network?","No",null,"Edge Industrial Gateway and/or E-Kit (supplied as loose parts only)"]
["If yes, how many ABB devices to be connected via Modbus TCP?",0,null,{"$f":"'Background worksheet'!D20","v":"Not selected"},{"$f":"'Background worksheet'!E20","v":"No additional ABB devices"},{"$f":"'Background worksheet'!F20","v":0}]
["… and how many to be connected via Modbus RTU?",0,null,{"$f":"'Background worksheet'!D21","v":"n/a"},{"$f":"'Background worksheet'!E21","v":"n/a"},{"$f":"'Background worksheet'!F21","v":0}]
["Any on-board I/O required with Edge Industrial Gateway?","No",null,{"$f":"'Background worksheet'!D22","v":"n/a"},{"$f":"'Background worksheet'!E22","v":"n/a"},{"$f":"'Background worksheet'!F22","v":0}]
["Any non-ABB devices (3rd party) to be added to the same network?","No",null,{"$f":"'Background worksheet'!D23","v":"Not selected"},{"$f":"'Background worksheet'!E23","v":"Not selected"},{"$f":"'Background worksheet'!F23","v":0}]
["If yes, how many non-ABB devices to be added via Modbus TCP?",0,null,{"$f":"'Background worksheet'!D24","v":"Not selected"},{"$f":"'Background worksheet'!E24","v":"No additional non-ABB devices"},{"$f":"'Background worksheet'!F24","v":0}]
["… and how many to be added via Modbus RTU?",0,null,{"$f":"'Background worksheet'!B29","v":"Suggestion/Alert:"}]
[]
["How to use this tool (click here for step-by-step video):"]
["Select from the grey cells only, in response to above questions (going top-down) and related to your specific application.",null,null,"Provisioning software and Ability™ SaaS subscriptions"]
[null,null,null,"Ekip Connect 3 programming tool for EkipUP+ (free)",null,"Download"]
["Based on your selection, part numbers and quantities will automatically appear in the columns on the right side of this sheet.",null,null,"Provisioning tool for Edge Industrial Gateway (free)",null,"Download"]
[null,null,null,"Ability™ Energy Manager Watching/Performing Voucher",null,"Purchase"]
["Look out for suggestions boxes that appear when a cell is selected and alerts based on selections, then review/revise if necessary.",null,null,"Ability™ Energy Manager Watching/Performing subscription",null,"Purchase"]
[null,null,null,"Ability™ Energy Manager Watching for Multisite Voucher",null,"Purchase"]
["Copy-paste-email the selection to your distributor or ABB sales rep for pricing. If you select the Print option, it will go to your default printer (or will be saved as PDF, if that is your default printer setting)",null,null,"Note: Please copy-paste and email above part numbers to your local distributor or sales rep for pricing and ordering, or print the page using the button above, and send it."]
[null,null,null,"Technical specs, part numbers, pricing, etc., subject to change with evolving technologies and upgrades. Please verify prior to ordering."]
[null,null,null,"For clarifications:","ability@ca.abb.com"]
[null,null,null,"Local webpage:","https://new.abb.com/ca/ability"]

{"sheet":"List","index":2,"n_rows":88,"n_cols":4,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
["Description","Order code"]
["None","Not selected"]
["EkipUP+ Monitor","1SDA117056R1"]
["EkipUP+ Protect","1SDA117057R1"]
["Not required","Insertion bridges, Type-D","1SDA104662R1"]
["3-phase 3-wire 120mm","Open CS 3P type C 120mm 100-4000A","1SDA083372R1"]
["3-phase 4-wire 120mm","Open CS 4P type C 120mm 100-4000A","1SDA083373R1"]
["3-phase 3-wire 100mm","Open CS 3P type C 100mm 100-4000A","1SDA085566R1"]
["3-phase 4-wire 100mm","Open CS 4P type C 100mm 100-4000A","1SDA085564R1"]
["3-phase 3-wire 200mm","Open CS 3P type C 200mm 100-4000A","1SDA085565R1"]
["3-phase 4-wire 200mm","Open CS 4P type C 200mm 100-4000A","1SDA085563R1"]
["3-phase 3-wire 290mm","Open CS 3P type C 290mm 200-6300A","1SDA107696R1"]
["3-phase 4-wire 290mm","Open CS 4P type C 290mm 200-6300A","1SDA107695R1"]
["None","Not selected"]
["Ekip Com Hub E1.2..E6.2","1SDA082894R1"]
["None","Not selected","None","Not selected"]
["EKIP COM MODBUS RS-485 E1.2..E6.2","1SDA074150R1","EKIP COM R MODBUS RS-485 E1.2..E6.2-XT","1SDA074157R1"]
["EKIP COM MODBUS TCP E1.2..E6.2","1SDA074151R1","EKIP COM R MODBUS TCP R E1.2...E6.2","1SDA074158R1"]
["EKIP COM PROFIBUS E1.2..E6.2","1SDA074152R1","EKIP COM R PROFIBUS E1.2..E6.2-Tmax XT","1SDA074159R1"]
["EKIP COM PROFINET E1.2..E6.2","1SDA074153R1","EKIP COM R PROFINET E1.2...E6.2","1SDA074160R1"]
["EKIP COM DEVICENET E1.2..E6.2","1SDA074154R1","EKIP COM R DEVICENET E1.2..E6.2-Tmax XT","1SDA074161R1"]
["EKIP COM ETHERNET/IP E1.2..E6.2","1SDA074155R1","EKIP COM R ETHERNET/IP E1.2..E6.2","1SDA074162R1"]
["EKIP COM IEC61850 E1.2..E6.2","1SDA074156R1","Ekip Com R IEC61850 E1.2..E6.2","1SDA076170R1"]
["EKIP LINK E1.2..E6.2","1SDA074163R1","Ekip Link does not have redundant option","n/a"]
["EKIP SYNCHROCHECK E1.2..E6.2-Tmax XT","1SDA074183R1"]
["EKIP 2K-1 E1.2..E6.2-Tmax XT","1SDA074167R1"]
["EKIP 2K-2 E1.2..E6.2-Tmax XT","1SDA074168R1"]
["EKIP 10K E1.2..E6.2-Tmax XT","1SDA074171R1"]
["RELT-Ekip 2K-3 E1.2..E6.2-Tmax XT","1SDA074169R1"]
["Ekip Signalling 3T-1","1SDA085693R1"]
["Ekip Signalling 3T-2","1SDA085694R1"]
["None","Not selected"]
["RATING PLUG 100 E1.2..E2.2 INST","1SDA074258R1"]
["RATING PLUG 200 E1.2..E2.2 INST","1SDA074259R1"]
["RATING PLUG 250 E1.2..E2.2 INST","1SDA074260R1"]
["RATING PLUG 400 E1.2..E6.2 INST","1SDA074261R1"]
["Rating Plug 600 E1.2...E6.2 UL INST","1SDA079826R1"]
["RATING PLUG 630 E1.2..E6.2 INST","1SDA074262R1"]
["RATING PLUG 800 E1.2..E6.2 INST","1SDA074263R1"]
["RATING PLUG 1000 E1.2..E6.2 INST","1SDA074264R1"]
["Rating Plug 1200 E2.2...E6.2 UL INST","1SDA079828R1"]
["RATING PLUG 1250 E1.2..E6.2 INST","1SDA074265R1"]
["RATING PLUG 1600 E2.2..E6.2 INST","1SDA074266R1"]
["RATING PLUG 2000 E2.2..E6.2 INST","1SDA074267R1"]
["RATING PLUG 2500 E4.2..E6.2 INST","1SDA074268R1"]
["RATING PLUG 3200 E4.2..E6.2 INST","1SDA074269R1"]
["Rating Plug 3600 E6.2 UL (INST)","1SDA079829R1"]
["RATING PLUG 4000 E6.2 INST","1SDA074270R1"]
["RATING PLUG 5000 E6.2 INST","1SDA074271R1"]
["Installation kit DIN/DOOR Ekip UP","1SDA085567R1"]
["cable kit Ext 4p Ekip UP","1SDA085568R1"]
["Transparent Cover Ekip UP+ Monitor","1SDA085569R1"]
["Support CS Rogowski type C D12mm open","1SDA085570R1"]
["External Probe PT1000 3mt","1SDA085695R1"]
["Ekip Signalling Modbus TCP E1.2...E6.2","1SDA082485R1"]
["Ekip Programming Emax2 - Tmax XT","1SDA076154R1"]
["IPS - Interface protection system","1SDA082919R1"]
["Adaptive Load Shedding Emax 2","1SDA082921R1"]
["Loose parts only","Loose parts"]
["Nema1 enclosed package","EKIP1-BOXKIT-T1"]
["Nema 3R or Nema 4 enclosed package","EKIP1-BOXKIT-T3"]
["None","Not selected"]
["RATING PLUG 100 E1.2..E2.2","1SDA074218R1"]
["RATING PLUG 200 E1.2..E2.2","1SDA074219R1"]
["RATING PLUG 250 E1.2..E2.2","1SDA074220R1"]
["RATING PLUG 400 E1.2..E6.2","1SDA074221R1"]
["RATING PLUG 630 E1.2..E6.2","1SDA074222R1"]
["RATING PLUG 800 E1.2..E6.2","1SDA074223R1"]
["RATING PLUG 1000 E1.2..E6.2","1SDA074224R1"]
["RATING PLUG 1250 E1.2..E6.2","1SDA074225R1"]
["RATING PLUG 1600 E2.2..E6.2","1SDA074226R1"]
["RATING PLUG 2000 E2.2..E6.2","1SDA074227R1"]
["RATING PLUG 2500 E2.2..E6.2","1SDA074228R1"]
["RATING PLUG 3200 E4.2..E6.2","1SDA074229R1"]
["RATING PLUG 4000 E4.2..E6.2","1SDA074230R1"]
["RATING PLUG 5000 E6.2","1SDA074231R1"]
["Rating Plug 6000 E6.2 UL ed.2","1SDA112858R1"]
["None","Not selected"]
["warranty extension 2 years - Ekip UP","1SDA104660R1"]
["warranty extension 4 years - Ekip UP","1SDA085815R1"]
["warranty extension 5 years - Ekip UP","1SDA104661R1"]
["External Probe PT1000 3mt","1SDA085695R1"]
["Ekip Programming Emax2 - Tmax XT","1SDA076154R1"]
["ABB Ability Edge Industrial gw 3G US","1SDA116753R1"]
["Side-expansion module for EIG","1SDA114038R1"]
["Cellular antenna EIG","1SDA114040R1"]
["EIG Power Supply 115-230Vac/24Vdc","1SDA114043R1"]
["Wall Mounting brackets for EIG","1SDA114041R1"]

{"sheet":"Background worksheet","index":3,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["EkipUP+","Selection","Logic","Part number","Description","Quantity"]
["What will the EkipUP+ device be used for mainly?",{"$f":"Selection!B3","v":"Not required"},{"$f":"IF(B2=\"Not required\",0,IF(B2=\"Network monitoring only\",1,IF(OR(B2=\"To upgrade a circuit breaker\",B2=\"Load management and peak shaving\"),2)))","v":0},{"$f":"IF(C2=0,\"Not selected\",IF(C2=1,\"1SDA117056R1\",IF(C2=2,\"1SDA117057R1\")))","v":"Not selected"},{"$f":"IF(C2=0,\"Not selected\",IF(C2=1,\"EkipUP+ Monitor\",IF(C2=2,\"EkipUP+ Protect\")))","v":"Not selected"},{"$f":"B3","v":0}]
["How many EkipUP+ units are required?",{"$f":"Selection!B4","v":0}]
["Is an enclosed \"plug & play\" solution required or just loose parts?",{"$f":"Selection!B5","v":"Loose parts only"},null,{"$f":"VLOOKUP(B4,Enc,2,FALSE)","v":"Loose parts"},{"$f":"VLOOKUP(B4,Enc,1,FALSE)","v":"Loose parts only"},{"$f":"B3","v":0}]
["What is the ampere rating of the network/section to be monitored?",{"$f":"Selection!B6","v":"None"},null,{"$f":"VLOOKUP(B5,ratplug,2,FALSE)","v":"Not selected"},{"$f":"B5","v":"None"},{"$f":"B3","v":0}]
["Is the network 3-phase, 3-wire or 3-phase, 4-wire?",{"$f":"Selection!B8","v":"Not required"},null,{"$f":"IF(B3=1,\"1SDA074173R1\",\"None\")","v":"None"},{"$f":"IF(B3=1,\"EKIP SUPPLY 24-48VDC E1.2..E6.2-Tmax XT\",\"Ekip Supply auto-selected with EkipUP+\")","v":"Ekip Supply auto-selected with EkipUP+"},{"$f":"F2","v":0}]
["What diameter of sensors would best fit the busbars?",{"$f":"Selection!B9","v":"200mm"},{"$f":"CONCATENATE(B6,\" \",B7)","v":"Not required 200mm"},{"$f":"IF(B6=\"Not required\",List!C5,VLOOKUP(C7,OCS,3,FALSE))","v":"1SDA104662R1"},{"$f":"IF(B6=\"Not required\",List!B5,VLOOKUP(C7,OCS,2,FALSE))","v":"Insertion bridges, Type-D"},{"$f":"F5","v":0}]
["Will the EkipUP+ unit communicate with Ability™ cloud?",{"$f":"Selection!B10","v":"No"},{"$f":"IF(B8=\"Yes\",1,IF(B8=\"No\",2))","v":2},{"$f":"IF(C8=1,\"1SDA082894R1\",IF(C8=2,\"Not selected\"))","v":"Not selected"},{"$f":"IF(C8=1,\"Ekip Com Hub E1.2..E6.2\",IF(C8=2,\"Not selected\"))","v":"Not selected"},{"$f":"IF(C8=1,B3,IF(C8=2,0))","v":0}]
["What additional communication protocol(s) are needed?",{"$f":"Selection!B11","v":"None"},{"$f":"IF(B9=\"None\",1,2)","v":1},{"$f":"VLOOKUP(B9,module2,2,FALSE)","v":"Not selected"},{"$f":"IF(C9=1,\"Not selected\",B9)","v":"Not selected"},{"$f":"IF(C9=1,0,B3)","v":0}]
["Is redundant communication required?",{"$f":"Selection!B12","v":"No"},{"$f":"IF(B10=\"Yes\",1,IF(B10=\"No\",2))","v":2},{"$f":"IF(AND(C10=1,C9=2),VLOOKUP(E9,module3,4,FALSE),\"Not selected\")","v":"Not selected"},{"$f":"IF(AND(C10=1,C9=2),VLOOKUP(E9,module3,3,FALSE),\"Not selected\")","v":"Not selected"},{"$f":"IF(AND(C10=1,D10<>\"n/a\"),F9,0)","v":0}]
["Does ambient temperature in the panel need to be measured?",{"$f":"Selection!B13","v":"No"},{"$f":"IF(B11=\"Yes\",1,IF(B11=\"No\",2))","v":2},{"$f":"IF(C11=1,\"1SDA085693R1\",IF(C11=2,\"Not selected\"))","v":"Not selected"},{"$f":"IF(C11=1,\"Ekip Signalling 3T-1\",IF(C11=2,\"Not selected\"))","v":"Not selected"},{"$f":"IF(AND(C11=1,OR(B12=3,B12=6)),B3,0)","v":0}]
["If yes, how many PT1000 probes are required?",{"$f":"Selection!B14","v":0},{"$f":"IF(OR(B12=0,B12=3),1,IF(B12=6,2))","v":1},{"$f":"IF(C12=2,\"1SDA085694R1\",IF(C12=1,\"n/a\"))","v":"n/a"},{"$f":"IF(C12=2,\"Ekip Signalling 3T-2\",IF(C12=1,\"n/a\"))","v":"n/a"},{"$f":"IF(C12=2,B3,IF(C12=1,0))","v":0}]
[null,null,{"$f":"IF(AND(C11=1,B12>0),1,2)","v":2},{"$f":"IF(C13=1,\"1SDA085695R1\",\"n/a\")","v":"n/a"},{"$f":"IF(C13=1,\"External Probe PT1000 3mt\",\"n/a\")","v":"n/a"},{"$f":"IF(C13=1,B12*B3,0)","v":0}]
["How many additional digital I/O would be required?",{"$f":"Selection!B15","v":0},{"$f":"IF(OR(B14=2,B14=4),1,2)","v":2},{"$f":"IF(C14=1,\"1SDA074167R1\",\"n/a\")","v":"n/a"},{"$f":"IF(C14=1,\"EKIP 2K-1 E1.2..E6.2-Tmax XT\",\"n/a\")","v":"n/a"},{"$f":"IF(C14=1,B3,0)","v":0}]
[null,null,null,{"$f":"IF(B14=4,\"1SDA074168R1\",\"n/a\")","v":"n/a"},{"$f":"IF(B14=4,\"EKIP 2K-2 E1.2..E6.2-Tmax XT\",\"n/a\")","v":"n/a"},{"$f":"IF(B14=4,B3,0)","v":0}]
[null,null,{"$f":"IF(OR(B14=10,B14=20,B14=30),1,2)","v":2},{"$f":"IF(C16=1,\"1SDA074171R1\",\"n/a\")","v":"n/a"},{"$f":"IF(C16=1,\"EKIP 10K E1.2..E6.2-Tmax XT\",\"n/a\")","v":"n/a"},{"$f":"IF(C16=1,IF(B14=10,B3*1,IF(B14=20,B3*2,IF(B14=30,B3*3))),0)","v":0}]
["How many years of extended warranty are needed?",{"$f":"Selection!B16","v":"None"},null,{"$f":"VLOOKUP(B17,warranty,2,FALSE)","v":"Not selected"},{"$f":"B17","v":"None"},{"$f":"IF(B17=\"None\",0,B3)","v":0}]
["Is an Ekip programming cable already available?",{"$f":"Selection!B17","v":"No"},null,{"$f":"IF(B18=\"No\",\"1SDA076154R1\",IF(B18=\"Yes\",\"Not selected\"))","v":"1SDA076154R1"},{"$f":"IF(B18=\"No\",\"1SDA076154R1\",IF(B18=\"Yes\",\"Not selected\"))","v":"1SDA076154R1"},{"$f":"IF(B18=\"No\",1,IF(B18=\"Yes\",0))","v":1}]
["Edge Industrial Gateway and E-kit"]
["Do any other ABB devices need to be added to the same network?",{"$f":"Selection!B19","v":"No"},{"$f":"IF(B20=\"Yes\",1,IF(B20=\"No\",2))","v":2},{"$f":"IF(OR(C20=1,C24=1),\"1SDA116753R1\",IF(C20=2,\"Not selected\"))","v":"Not selected"},{"$f":"IF(OR(C20=1,C24=1),\"ABB Ability Edge Industrial gw 3G US\",IF(C20=2,\"No additional ABB devices\"))","v":"No additional ABB devices"},{"$f":"IF(OR(C20=1,C24=1),MAX(C21,C22)+F26,0)","v":0}]
["How many ABB devices need to be connected on Modbus TCP?",{"$f":"Selection!B20","v":0},{"$f":"IF(C20=1,ROUNDUP(B21/45,0),0)","v":0},{"$f":"IF(OR(C20=1,C24=1),\"1SDA114040R1\",\"n/a\")","v":"n/a"},{"$f":"IF(OR(C20=1,C24=1),\"Cellular antenna EIG\",\"n/a\")","v":"n/a"},{"$f":"IF(OR(C20=1,C24=1),F20,0)","v":0}]
["How many ABB devices need to be connected on Modbus RTU?",{"$f":"Selection!B21","v":0},{"$f":"IF(C20=1,ROUNDUP(B22/15,0),0)","v":0},{"$f":"IF(OR(C20=1,C24=1),\"1SDA114043R1\",\"n/a\")","v":"n/a"},{"$f":"IF(OR(C20=1,C24=1),\"EIG Power Supply 115-230Vac/24Vdc\",\"n/a\")","v":"n/a"},{"$f":"IF(OR(C20=1,C24=1),F20,0)","v":0}]
["Any on-board I/O required with Edge Industrial Gateway?",{"$f":"Selection!B22","v":"No"},{"$f":"IF(AND(C20=1,B23=\"Yes\"),1,2)","v":2},{"$f":"IF(AND(C20=1,C23=1),\"1SDA114038R1\",\"Not selected\")","v":"Not selected"},{"$f":"IF(AND(C20=1,C23=1),\"Side-expansion module for EIG\",\"Not selected\")","v":"Not selected"},{"$f":"IF(AND(C20=1,C23=1),F20,0)","v":0}]
["Any non-ABB devices (3rd party) to be added to Ability™ cloud?",{"$f":"Selection!B23","v":"No"},{"$f":"IF(B24=\"Yes\",1,IF(B24=\"No\",2))","v":2},{"$f":"IF(C24=1,\"1SDA116753R1\",IF(C24=2,\"Not selected\"))","v":"Not selected"},{"$f":"IF(C24=1,\"ABB E-kit\",IF(C24=2,\"No additional non-ABB devices\"))","v":"No additional non-ABB devices"},{"$f":"MAX(C25,C26)","v":0}]
["How many non-ABB devices need to be connected on Modbus TCP?",{"$f":"Selection!B24","v":0},{"$f":"IF(C24=1,ROUNDUP(B25/30,0),0)","v":0}]
["How many non-ABB devices need to be connected on Modbus RTU?",{"$f":"Selection!B25","v":0},{"$f":"IF(C24=1,ROUNDUP(B26/15,0),0)","v":0},null,null,{"$f":"IF(F24>0,1,0)","v":0}]
[]
["Error messages"]
["Final error message",{"$f":"CONCATENATE(\"Suggestion/Alert:\",B30,B31,B32,B33,B34,B35,B36,B37,B38)","v":"Suggestion/Alert:"}]
["EkipUP+",{"$f":"IF(AND(C2<>0,B3=0),\" please enter the quantity of EkipUP+ units required;\",\"\")","v":""}]
["Rating plug",{"$f":"IF(AND(B3>0,B5=\"None\"),\" please select ampere rating for the EkipUP+ unit;\",\"\")","v":""}]
["Voltage",{"$f":"IF(C32=\"Other voltage and/or frequency\",\" for voltages other than 600V or 480V, please email ability@ca.abb.com with application details;\",\"\")","v":""},{"$f":"Selection!B7","v":"600V 3-ph 60Hz"}]
["3T",{"$f":"IF(AND(C11=2,C12=2),\" please select YES for temperature measurement option;\",\"\")","v":""}]
["Control supply for 10K",{"$f":"IF(D16=\"1SDA074171R1\",\" Note: please note Ekip 10K needs 24Vdc or 110Vac control supply as it is not directly fed from EkipUP+;\",\"\")","v":""}]
["10K comms",{"$f":"IF(AND(C16=1,C35<>1),\"please select Ekip Com Modbus RS-485 or Ekip Link above for Ekip 10K to communucate with EkipUP+\",\"\")","v":""},{"$f":"IF(OR(D9=\"1SDA074150R1\",D9=\"1SDA074163R1\",D10=\"1SDA074157R1\"),1,0)","v":0}]
["Module limit",{"$f":"IFERROR(IF((F8+F9+F10+F11+F12+F14+F15)/B3>4,\" maximum 4 modules allowed per EkipUP+ unit, please review communication options;\",\"\"),\"\")","v":""}]
["Warranty",{"$f":"IF(D17=\"1SDA104660R1\",\" please note 2-year warranty is automatically included if EkipUP+ is connected to Ability™ with an EM subscription;\",\"\")","v":""}]
["Downstream device limit",{"$f":"IF(B21+B22+B25+B26>350,\" number of downstream devices exceeds the limit, please review selection;\",\"\")","v":""}]