{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary View","Detailed Analysis View","Single-Site Calc","Multi-Site Calc"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":3,"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":"Summary View","index":0,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":true,"merged":[[46,0,46,1],[2,0,2,1]]}
["ISE 1.1.1 + Patch 2 Network Latency and Bandwidth Calculator for DB Replication - Summary"]
[]
["Customer Inputs"]
[]
[]
["Total # Endpoints",10000,"Total concurrent endpoints across entire deployment"]
["% Mobile Clients",50,"Over a 60 minute period of time, what percentage of the above are logging in during the peak interval?"]
["Total Mobile Clients",{"$f":"B6*B7*0.01","v":5000}]
["Peak Connection Interval (min)",{"$f":"'Detailed Analysis View'!B9","v":60},"Time interval for Total New Network Connections (or reconnections) at Peak"]
["Peak Connection Interval (sec)",{"$f":"B9*60","v":3600}]
["Average New Endpoint Connections / Sec",{"$f":"B8/B10","v":1.3888888888888888}]
[]
["% New endpoints (non-Guests)",{"$f":"'Detailed Analysis View'!B13","v":1},"New Endpoints as % of Total New Network Connections at Peak"]
["Number of New Endpoints",{"$f":"B13*B8*0.01","v":50},"Add 1 message for all new endpoints"]
["% Guest Logins",{"$f":"'Detailed Analysis View'!B15","v":5},"Guest user connections as % of Total New Network Connections at Peak"]
["Guest Logins During Peak Interval",{"$f":"B8*B15*0.01","v":250},"Add 1 message for all guest logins"]
["% New Guests",{"$f":"'Detailed Analysis View'!B17","v":50},"New guest users as a % of Guest Logins at Peak"]
["Number of New Guests at Peak",{"$f":"B16*B17*0.01","v":125},"Add 1 message for all new guests"]
["Total Number of New Endpoints or Guests",{"$f":"B14+B18","v":175}]
[]
["Is Profiling Enabled (0=no, 1=yes)",1]
["Probes Enabled:","(0=no, 1=yes)"]
["RADIUS",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B23, 0)","v":1},"Adds 1 message for all connections"]
["SNMP Trap",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B24, 0)","v":0},"Adds 1 message for all connections - Should not be enabled with RADIUS Accounting enabled."]
["SNMP Query",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B25, 0)","v":1},"Adds 1 message for all connections"]
["DHCP probe  (helper)",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B26, 0)","v":1},"Adds 2 message for all connections"]
["DHCP probe (SPAN)",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B27, 0)","v":0},"Adds 2 message for all connections - Should not be enabled with DHCP probe (Helper)"]
["HTTP probe  (redirect)",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B28, 0)","v":1},"Adds 1 message for all posture, provisioning, or web auth connections"]
["HTTP (SPAN)","X","Not supported for Distributed Deployments - # Endpoint updates depend on actual traffic and SPAN config"]
["NMAP",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B30, 0)","v":1},"Adds 1 message for new endpoints only"]
["DNS",{"$f":"IF(B21<>0, 'Detailed Analysis View'!B31, 0)","v":0},"Adds 1 message for all connections"]
["NetFlow","X","Not supported for Distributed Deployments - # Endpoint updates depend on actual traffic and NeFlow config"]
[]
["dVLAN Assignment? (0=no, 1=yes)",{"$f":"'Detailed Analysis View'!B34","v":1},"Requires RADIUS, DHCP, and DNS updates."]
["Posture Enabled? (0=no, 1=yes)",{"$f":"'Detailed Analysis View'!B35","v":1},"Requires RADIUS (CoA) and HTTP updates"]
["% Posture",{"$f":"'Detailed Analysis View'!B36","v":20},"Postured endpoints as % of Total New Network Connections at Peak"]
["Total Endpoints Postured",{"$f":"B35*B8*B36*0.01","v":1000},"Add 1 message if Profiling enabled for HTTP Probe"]
["RADIUS Re-Auth Period (sec)",{"$f":"'Detailed Analysis View'!B38","v":3600}]
["Number of Re-Auths During Peak Interval",{"$f":"IF(INT(B9/(B38/60)) > 1, (B9/(B38/60))*(B6-B8)+(B9/(B38/60)-1)*B8, (B9/(B38/60))*(B6-B8))","v":5000},"Add 2 messages per re-auth during peak period if Profiling enabled for RADIUS Probe"]
["DHCP Lease Period (hours)",{"$f":"'Detailed Analysis View'!B40","v":4}]
["Number of Renewals During Peak Interval",{"$f":"IF(INT(B9/(B40*60/2))>1,((B6-B8)*(B9/(B40*60/2)))+(B8*(B9/(B40*60/2)-1)),((B6-B8)*(B9/(B40*60/2))))","v":2500},"Add 2 messages per renewal during peak period if Profiling enabled for DHCP SPAN Probe"]
[]
["# Messages / sec",{"$f":"(((B8-B19)*B21*1)+(B19*B21*B34*((1*B23)+(B63*B26)+(B64*B27)+(B67*B31)))+(B19*B21*(1+(B60*B23)+(B61*B24)+((B23+B24)*B62*B25)+(B63*B26)+(B64*B27)+(B67*B31)+(B66*B30)))+(B19*(B36*0.01)*B21*((1*B23)+(B65*B28)))+((B16*1)+ (B18*B21*((1*B23)+(B65*B28))))+(IF((B21*B39*B23)>(B21*B41*B27), B21*B39*B23,B21*B41*B27)))/B10","v":3.3736111111111109}]
["# Nodes at Remote Datacenter/Campus",4]
[]
[]
["WAN Requirements to Remote Campus"]
["Max RT Latency Required (ms)",{"$f":"IF(B43=0, \"                    RADIUS Timeout Value\", 1000/B43)","v":296.41827912721288}]
["Min Bandwidth Required (Mbps)",{"$f":"B44*64*B43/1000","v":0.86364444444444444}]
[]
[]
[]
[{"$f":"'Detailed Analysis View'!A53","v":"Messages per Event Type"},null,{"$f":"'Detailed Analysis View'!C53","v":0}]
[{"$f":"'Detailed Analysis View'!A54","v":"RADIUS only auth"},{"$f":"'Detailed Analysis View'!B54","v":0},{"$f":"'Detailed Analysis View'!C54","v":"No db update for RADIUS only auth"}]
[{"$f":"'Detailed Analysis View'!A55","v":"Posture only"},{"$f":"'Detailed Analysis View'!B55","v":0},{"$f":"'Detailed Analysis View'!C55","v":"Posture status is session local so no db update"}]
[{"$f":"'Detailed Analysis View'!A56","v":"Create new guest"},{"$f":"'Detailed Analysis View'!B56","v":1},{"$f":"'Detailed Analysis View'!C56","v":"New db entry"}]
[{"$f":"'Detailed Analysis View'!A57","v":"Guest Login"},{"$f":"'Detailed Analysis View'!B57","v":1},{"$f":"'Detailed Analysis View'!C57","v":"Update last login time to Guest db"}]
[{"$f":"'Detailed Analysis View'!A58","v":"New endpoint detected"},{"$f":"'Detailed Analysis View'!B58","v":1},{"$f":"'Detailed Analysis View'!C58","v":"New db entry"}]
[{"$f":"'Detailed Analysis View'!A59","v":"Provisioning/MDP entry"},{"$f":"'Detailed Analysis View'!B59","v":1},{"$f":"'Detailed Analysis View'!C59","v":"New b entry"}]
[{"$f":"'Detailed Analysis View'!A60","v":"RADIUS probe attr"},{"$f":"'Detailed Analysis View'!B60","v":2},{"$f":"'Detailed Analysis View'!C60","v":"Typically two RADIUS updates per connection + 1 for VLAN change + 1 posture/webauth (CoA)"}]
[{"$f":"'Detailed Analysis View'!A61","v":"SNMP Trap probe attr"},{"$f":"'Detailed Analysis View'!B61","v":1},{"$f":"'Detailed Analysis View'!C61","v":"One update if Discovery mode (0 if RADIUS used)"}]
[{"$f":"'Detailed Analysis View'!A62","v":"SNMP Query probe attr"},{"$f":"'Detailed Analysis View'!B62","v":1},{"$f":"'Detailed Analysis View'!C62","v":"One per SNMP Trap or RADIUS Accounting Start"}]
[{"$f":"'Detailed Analysis View'!A63","v":"DHCP probe attr  (Helper)"},{"$f":"'Detailed Analysis View'!B63","v":2},{"$f":"'Detailed Analysis View'!C63","v":"Expect two updates for Discover/Request (two more if VLAN change) "}]
[{"$f":"'Detailed Analysis View'!A64","v":"DHCP probe attr (SPAN)"},{"$f":"'Detailed Analysis View'!B64","v":4},{"$f":"'Detailed Analysis View'!C64","v":"Expect four updates for Discover/Request (four more if VLAN change)"}]
[{"$f":"'Detailed Analysis View'!A65","v":"HTTP probe (Redirect)"},{"$f":"'Detailed Analysis View'!B65","v":1},{"$f":"'Detailed Analysis View'!C65","v":"Once per posture (or webauth or other redirect)"}]
[{"$f":"'Detailed Analysis View'!A66","v":"NMAP Probe"},{"$f":"'Detailed Analysis View'!B66","v":1},{"$f":"'Detailed Analysis View'!C66","v":"Typically would occur only once if triggered by rule (typically for new endpoint)"}]
[{"$f":"'Detailed Analysis View'!A67","v":"DNS Probe"},{"$f":"'Detailed Analysis View'!B67","v":1},{"$f":"'Detailed Analysis View'!C67","v":"Once per IP update (two for VLAN change)"}]
[{"$f":"'Detailed Analysis View'!A68","v":"HTTP probe (SPAN)"},{"$f":"'Detailed Analysis View'!B68","v":"variable"},{"$f":"'Detailed Analysis View'!C68","v":"Traffic specific (not recommended and not covered by this spreadsheet)"}]
[{"$f":"'Detailed Analysis View'!A69","v":"NetFlow"},{"$f":"'Detailed Analysis View'!B69","v":"variable"},{"$f":"'Detailed Analysis View'!C69","v":"Traffic specific (not recommended and not covered by this spreadsheet)"}]
[]
["For additional information, click here…"]
[]
[]
[]
[null,null,null,"Endpts",1,10000]
[null,null,null,"upd/sec",{"$f":"1/3600","v":2.7777777777777778E-4},{"$f":"10000/3600","v":2.7777777777777777}]
[null,null,null,"*8KB/upd",{"$f":"8*8*1024*E76","v":18.204444444444444},{"$f":"8*8*1024*F76","v":182044.44444444444},"bps"]
[]
[null,null,"per endpoint","Log/MnT (kbps)","Rep-PAN (kbps)","Rep-Exc (kbps)"]
[null,null,"mobile endpoints = 10 auths / hr and 1 ip change / hr",{"$f":"0.18","v":0.18},{"$f":"180/10000","v":1.7999999999999999E-2},{"$f":"360/10000","v":3.5999999999999997E-2}]
[null,null,"non-mobile endpoints = 1 auth per reauth period (> 1 hr per 10 hrs) and 1 ip change / day",{"$f":"(D80/10)/H81","v":8.9999999999999993E-3},{"$f":"E80/I82","v":8.9999999999999993E-3},{"$f":"E81*2","v":1.7999999999999999E-2},7200,{"$f":"IF(G81 <= 3600, 1, G81/3600)","v":2},null,"Reauth - dividing factor"]
[null,null,null,null,null,null,{"$f":"4*3600","v":14400},{"$f":"G82/2","v":7200},{"$f":"IF(H82<=3600, 1, H82/3600)","v":2},"DHCP - dividing factor"]
[]
[]
[]
[null,null,"Total Endpoints",50000]
[null,null,"% Mobile Endpoints",100]
[null,null,"Total Mobile Endpoints",{"$f":"D86*0.01*D87","v":50000}]
[null,null,"Total Non-Mobile Endpoints",{"$f":"D86-D88","v":0}]
[]
[null,null,"Total Endpoints at Remote Site",25000]
[null,null,"% Mobile at Remote Site",100]
[null,null,"Total Mobile Endpoints Remote Site",{"$f":"D91*0.01*D92","v":25000}]
[null,null,"Total Non-Mobile Endpoints Remote Site",{"$f":"D91-D93","v":0}]
[null,null,"# PSN nodes at Remote Site",3]
[null,null,"Secondary PAN node at Remote Site? (1=yes, 0=no)",1]
[null,null,"Secondary MnT node at Remote Site? (1=yes, 0=no)",1]
[null,null,"MnT Logging Factor",{"$f":"ABS(D97-2)","v":1}]
[null,null,"Audit Logging (Mbps)",{"$f":"D98*((D93*D80) + (D94*D81))","v":4500}]
[null,null,"DB Replication",{"$f":"(D95+D97+D96)*((D88*E80)+(D89*E81))","v":4499.9999999999991}]
[null,null,"Sending profile data for same endpoints to multiple node groups? (1=yes, 0=no)",1]
[null,null,"DB Replication for Ownership Change",{"$f":"D101*D95*((D88*F80)+(D89*F81))","v":5399.9999999999991}]
[null,null,"Total BW Required for WAN Link from Remote Site to Primary PAN/MnT (kbps)",{"$f":"D99+D100+D102","v":14400}]
[null,null,"Total BW Required for WAN Link from Remote Site to Primary PAN/MnT(Mbps)",{"$f":"D103*0.001","v":14.4}]
[]
[null,null,"Assumptions = suppression enabled, 1 node group per location, "]

{"sheet":"Detailed Analysis View","index":1,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":true,"merged":[[46,0,46,1],[2,0,2,1]]}
["ISE 1.1.1 + Patch 2 Latency and Bandwidth Calculator for DB Replication - Enter values into yellow highlighted boxes"]
[]
["Customer Inputs"]
["Assume peak rate - for example, start of week and start of day - when majority of endpoints connect to network"]
[]
["Total # Endpoints",10000,"Total concurrent endpoints across entire deployment"]
["% Establishing Network Connections at Peak",50,"Endpoints as % of Total Endpoints connecting or reconnecting to network during peak access period"]
["Total New Network Connections at Peak",{"$f":"B6*B7*0.01","v":5000}]
["Peak Connection Interval (min)",60,"Time interval for Total New Network Connections (or reconnections) at Peak"]
["Peak Connection Interval (sec)",{"$f":"B9*60","v":3600}]
["Average New Endpoint Connections / Sec",{"$f":"B8/B10","v":1.3888888888888888}]
[]
["% New endpoints (non-Guests)",1,"New Endpoints as % of Total New Network Connections at Peak"]
["Number of New Endpoints",{"$f":"B13*B8*0.01","v":50}]
["% Guest Logins",5,"Guest user connections as % of Total New Network Connections at Peak"]
["Guest Logins During Peak Interval",{"$f":"B8*B15*0.01","v":250}]
["% New Guests",50,"New guest users as a % of Guest Logins at Peak"]
["Number of New Guests at Peak",{"$f":"B16*B17*0.01","v":125}]
["Total Number of New Endpoints or Guests",{"$f":"B14+B18","v":175}]
[]
["Is Profiling Enabled (0=no, 1=yes)",1]
["Probes Enabled:","(0=no, 1=yes)"]
["RADIUS",1]
["SNMP Trap",0]
["SNMP Query",1]
["DHCP probe  (helper)",1]
["DHCP probe (SPAN)",0]
["HTTP probe  (redirect)",1]
["HTTP (SPAN)","X","Not supported for Distributed Deployments - # Endpoint updates depend on actual traffic and SPAN config"]
["NMAP",1]
["DNS",0]
["NetFlow","X","Not supported for Distributed Deployments - # Endpoint updates depend on actual traffic and NeFlow config"]
[]
["dVLAN Assignment? (0=no, 1=yes)",1,"Is VLAN assignment used to enforce access policies for authorized endpoints?"]
["Posture Enabled? (0=no, 1=yes)",1,"Is Posture Assessment using NAC or Web Agent enabled to determine endpoint compliance?"]
["% Posture",20,"Postured endpoints as % of Total New Network Connections at Peak"]
["Total Endpoints Postured",{"$f":"B35*B8*B36*0.01","v":1000}]
["RADIUS Re-Auth Period (sec)",3600,"Average RADIUS reauthentication interval for authenticated endpoints"]
["Number of Re-Auths During Peak Interval",{"$f":"IF(INT(B9/(B38/60)) > 1, (B9/(B38/60))*(B6-B8)+(B9/(B38/60)-1)*B8, (B9/(B38/60))*(B6-B8))","v":5000}]
["DHCP Lease Period (hours)",4,"Average DHCP lease period configured for DHCP clients"]
["Number of Renewals During Peak Interval",{"$f":"IF(INT(B9/(B40*60/2))>1,((B6-B8)*(B9/(B40*60/2)))+(B8*(B9/(B40*60/2)-1)),((B6-B8)*(B9/(B40*60/2))))","v":2500}]
[]
["# Messages / sec",{"$f":"(((B8-B19)*B21*1)+(B19*B21*B34*((1*B23)+(B63*B26)+(B64*B27)+(B67*B31)))+(B19*B21*(1+(B60*B23)+(B61*B24)+((B23+B24)*B62*B25)+(B63*B26)+(B64*B27)+(B67*B31)+(B66*B30)))+(B19*(B36*0.01)*B21*((1*B23)+(B65*B28)))+((B16*1)+ (B18*B21*((1*B23)+(B65*B28))))+(IF((B21*B39*B23)>(B21*B41*B27), B21*B39*B23,B21*B41*B27)))/B10","v":3.3736111111111109}]
["# ISE Nodes at Primary Datacenter/Campus",4,"Includes total number of ISE nodes (any persona) at the primary location"]
["# ISE Nodes at Backup DC/Remote Campus",4,"Includes total number of ISE nodes (any persona) at the remote location"]
[]
["WAN Requirements to Remote Campus"]
["Max RT Latency Required (ms)",{"$f":"IF(B43=0, \"                    RADIUS Timeout Value\", 1000/B43)","v":296.41827912721288}]
["Min BW Required within Main Campus (Mbps)",{"$f":"B44*64*B43/1000","v":0.86364444444444444}]
["Min BW Required to Remote Campus (Mbps)",{"$f":"B45*64*B43/1000","v":0.86364444444444444}]
[]
[]
["Messages per Event Type"]
["RADIUS only auth",0,"No db update for RADIUS only auth"]
["Posture only",0,"Posture status is session local so no db update"]
["Create new guest",1,"New db entry"]
["Guest Login",1,"Update last login time to Guest db"]
["New endpoint detected",1,"New db entry"]
["Provisioning/MDP entry",1,"New b entry"]
["RADIUS probe attr",2,"Typically two RADIUS updates per connection + 1 for VLAN change + 1 posture/webauth (CoA)"]
["SNMP Trap probe attr",1,"One update if Discovery mode (0 if RADIUS used)"]
["SNMP Query probe attr",1,"One per SNMP Trap or RADIUS Accounting Start"]
["DHCP probe attr  (Helper)",2,"Expect two updates for Discover/Request (two more if VLAN change) "]
["DHCP probe attr (SPAN)",4,"Expect four updates for Discover/Request (four more if VLAN change)"]
["HTTP probe (Redirect)",1,"Once per posture (or webauth or other redirect)"]
["NMAP Probe",1,"Typically would occur only once if triggered by rule (typically for new endpoint)"]
["DNS Probe",1,"Once per IP update (two for VLAN change)"]
["HTTP probe (SPAN)","variable","Traffic specific (not recommended and not covered by this spreadsheet)"]
["NetFlow","variable","Traffic specific (not recommended and not covered by this spreadsheet)"]

{"sheet":"Single-Site Calc","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,8]]}
["ISE 1.x Network Bandwidth Calculation for Single Remote Location"]
[]
[null,"Endpts",1,10000]
[null,"upd/sec",{"$f":"1/3600","v":2.7777777777777778E-4},{"$f":"10000/3600","v":2.7777777777777777}]
[null,"*8KB/upd",{"$f":"8*8*1024*C4","v":18.204444444444444},{"$f":"8*8*1024*D4","v":182044.44444444444},"bps"]
[]
["per endpoint","Log/MnT (kbps)","Rep-PAN (kbps)","Rep=PSN (kbps)","Own-Not (kbps)"]
["mobile endpoints = 10 auths / hr and 1 ip change / hr",{"$f":"1800/10000","v":0.18},{"$f":"180/10000","v":1.7999999999999999E-2},{"$f":"C8*2","v":3.5999999999999997E-2},{"$f":"D8/8","v":4.4999999999999997E-3}]
["non-mobile endpoints = 1 auth per reauth period (> 1/hr per 10 hrs) and 1 ip change / day",{"$f":"(B8/10)/E17","v":8.9999999999999993E-3},{"$f":"C8/E18","v":8.9999999999999993E-3},{"$f":"C9*2","v":1.7999999999999999E-2},{"$f":"D9/8","v":2.2499999999999998E-3}]
[]
[]
["Total Active Endpoints",100]
["% Mobile Endpoints",20]
["Total Mobile Endpoints",{"$f":"B12*0.01*B13","v":20}]
["Total Non-Mobile Endpoints",{"$f":"B12-B14","v":80}]
[]
[{"$f":"IF(B14<100, \"Reauth Interval (Default 2 hrs)\", \"\")","v":"Reauth Interval (Default 2 hrs)"},2,{"$f":"B17*3600","v":7200},null,{"$f":"IF(C17 <= 3600, 1, C17/3600)","v":2},"Reauth - dividing factor"]
[{"$f":"IF(B14<100, \"DHCP Lease Period (Default 4 hrs)\", \"\")","v":"DHCP Lease Period (Default 4 hrs)"},4,{"$f":"B18*3600","v":14400},{"$f":"C18/2","v":7200},{"$f":"IF(D18<=3600, 1, D18/3600)","v":2},"DHCP - dividing factor"]
[]
["Total Active Endpoints at Remote Site",50]
["% Mobile Endpoints at Remote Site",20]
["Total Mobile Endpoints Remote Site",{"$f":"B20*0.01*B21","v":10}]
["Total Non-Mobile Endpoints Remote Site",{"$f":"B20-B22","v":40}]
["# PSN nodes at Remote Site",1]
["Secondary PAN node at Remote Site? (1=yes, 0=no)",1]
["Secondary MnT node at Remote Site? (1=yes, 0=no)",1]
["MnT Logging Factor",{"$f":"ABS(B26-2)","v":1}]
["Audit Logging (Mbps)",{"$f":"B27*((B22*B8) + (B23*B9))","v":2.1599999999999997}]
["DB Replication",{"$f":"(B24+B26+B25)*((B14*C8)+(B15*C9))","v":3.24}]
["Sending profile data for same endpoints to multiple locations? (1=yes, 0=no)",0]
["DB Replication for Ownership Change",{"$f":"B30*((B24+B25+B26)*((B14*E8)+(B15*E9))+(B22*D8)+(B23*D9))","v":0}]
["Total BW Required for WAN Link from Remote Site to Primary PAN/MnT (kbps)",{"$f":"B28+B29+B31","v":5.4}]
["Total BW Required for WAN Link from Remote Site to Primary PAN/MnT (Mbps)",{"$f":"B32*0.001","v":5.4000000000000003E-3}]
[]
["Calculator Assumptions: \n• ISE Auth Suppression enabled\n• Profiling Whitelist Filter enabled\n• One node group per location\n• For Single-Site calculation, primary PAN and MnT nodes are deployed in primary Data Center to which bandwidth is calculated; For Multi-Site calculation, primary PAN is deployed in primary DC.\n• Mobile endpoints authenticate/reauthenticate as frequently as 10/hr and refresh IP 1/hr\n• Non-Mobile endpoints authenticate/reauthenticate no more than once per Reauth Interval and refresh IP address no more than once per DHCP renewal (1/2 Lease Period)\n• Bandwidth required for NAD or Guest Activity logging is not included.  These logging activities are highly variable and should be treated separately based on deployment requirements.\n• Bandwidth required for general RADIUS auth and accounting traffic is not included.  RADIUS traffic is generally less significant but actual requirement is highly contingent on multiple factors including total active endpoints, reauth intervals, and the authentication protocols used.\n• Deployments where all ISE nodes are deployed in one location are not considered by this calculator. All nodes deployed in the same location are assumed to be connected by high-speed LAN links (Gigabit Ethernet or higher)\n• Max round-trip latency between any two ISE v1.x nodes is currently set at 200ms."]

{"sheet":"Multi-Site Calc","index":3,"n_rows":54,"n_cols":31,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["ISE 1.x Network Bandwidth Calculation for Multiple Remote Locations"]
[]
["Total Active Endpoints",100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<--","Mobile","Non-Mobile",null,"Log/MnT (kbps)","Rep-PAN (kbps)","Rep-PSN (kbps)","Own-Notif (kbps)"]
["% Mobile Endpoints",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<--",{"$f":"B3*B4/100","v":20},{"$f":"B3-T4","v":80},"mobile",{"$f":"1800/10000","v":0.18},{"$f":"180/10000","v":1.7999999999999999E-2},{"$f":"X4*2","v":3.5999999999999997E-2},{"$f":"Y4/8","v":4.4999999999999997E-3}]
["# Remote Locations with PSNs \n(Not including data centers)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"non-mobile",{"$f":"(W4/10)/V7","v":8.9999999999999993E-3},{"$f":"X4/V8","v":8.9999999999999993E-3},{"$f":"X5*2","v":1.7999999999999999E-2},{"$f":"Y5/8","v":2.2499999999999998E-3}]
["Sending profile data for same endpoints to multiple locations? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<--",false,null,"Total Rep",null,{"$f":"($T$4*X4)+($U$4*X5)","v":1.08},null,{"$f":"($T$4*Z4)+($U$4*Z5)","v":0.27}]
[{"$f":"IF(B4<100, \"Reauth Interval (Default 2 hrs)\", \"\")","v":"Reauth Interval (Default 2 hrs)"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<--",{"$f":"B7*3600","v":7200},null,{"$f":"IF(T7 <= 3600, 1, T7/3600)","v":2},"Reauth Multiplier (reauth x 1 per hr)"]
[{"$f":"IF(B4<100, \"DHCP Lease Period (Default 4 hrs)\", \"\")","v":"DHCP Lease Period (Default 4 hrs)"},4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<--",{"$f":"B8*3600","v":14400},{"$f":"T8/2","v":7200},{"$f":"IF(U8<=3600, 1, U8/3600)","v":2},"IP Refresh Multiplier (ip change x 1 per hr)"]
[null,null,null,null,"   (P)=Primary",null,"  (S)=Secondary",null,{"$f":"IF(SUM($I$11:$I$52)>40, \"Max PSN count of 40 exceeded!\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aggregate DC Head-End WAN Bandwidth (Mbps)"]
["Location","Bandwidth Reqd to DC1 (Mbps)","Bandwidth Reqd to DC2 (Mbps)","Total DC Band-width (Mbps)","PAN(P)","PAN(S)","MNT(P)","MNT(S)","# PSNs","# Active Endpoints",null,"# Mobile","# Non-Mobile",1,2,1,2,null,"MaxPSN","Max Endpt",null,"MNT Log (DC2)","MNT Log (DC1)","PAN (P) Replication","Owner Change Replication","Owner Change Notification","Owner Change Total","MnT Log BW","Replication BW","Ownership Change BW","Total"]
["DC1/Main Campus","N/A",{"$f":"SUM(V11)","v":2.1599999999999996E-3},{"$f":"IF(SUM(B11:C11)>0,SUM(B11:C11),\"\")","v":2.1599999999999996E-3},null,null,null,null,1,50,null,{"$f":"IF(J11<>\"\",J11*$B$4/100,0)","v":10},{"$f":"IF(J11<>\"\",J11-L11,0)","v":40},{"$f":"IF(N10=1,1,0)","v":1},{"$f":"IF(O10=1,1,0)","v":0},{"$f":"IF(P10=1,1,0)","v":1},{"$f":"IF(Q10=1,1,0)","v":0},null,{"$f":"SUM($I$11:$I$52)-I11","v":1},{"$f":"SUM($J$11:$J$52)-J11","v":50},null,{"$f":"($P$12+$Q$12)*(($L$11*$W$4)+($M$11*$W$5))/1000","v":2.1599999999999996E-3},0,0,0,0,{"$f":"Y11+Z11","v":0},{"$f":"W53","v":2.1599999999999996E-3},{"$f":"X53","v":3.2400000000000003E-3},{"$f":"AA53","v":0},{"$f":"SUM(AB11:AD11)","v":5.4000000000000003E-3}]
["DC2/Secondary Campus",{"$f":"SUM(W12:Z12)","v":5.4000000000000003E-3},"N/A",5.4000000000000003E-3,null,null,null,null,1,50,null,{"$f":"IF(J12<>\"\",J12*$B$4/100,0)","v":10},{"$f":"IF(J12<>\"\",J12-L12,0)","v":40},{"$f":"IF(N10=1,0,1)","v":0},{"$f":"IF(O10=1,0,1)","v":1},{"$f":"IF(P10=1,0,1)","v":0},{"$f":"IF(Q10=1,0,1)","v":1},null,1,50,null,0,{"$f":"IF($I$12>0,($P$11+$Q$11)*(($L$12*$W$4)+($M$12*$W$5))/1000, 0)","v":2.1599999999999996E-3},{"$f":"SUM(I12+O12+P12+Q12)*$X$6/1000","v":3.2400000000000003E-3},{"$f":"IF($T$6=TRUE,(L12*$Y$4+M12*$Y$5)/1000, 0)","v":0},{"$f":"IF($T$6=TRUE,SUM(I12+O12+P12+Q12)*$Z$6/1000, 0)","v":0},{"$f":"Y12+Z12","v":0},{"$f":"V53","v":2.1599999999999996E-3},{"$f":"X12","v":3.2400000000000003E-3},{"$f":"Y12+Z12","v":0},{"$f":"SUM(AB12:AD12)","v":5.4000000000000003E-3}]
[{"$f":"IF(B$5>O13, \"Remote Site \" &(O13+1), \"\")","v":""},{"$f":"IF(I13>0,SUM(W13:Z13),\"\")","v":""},{"$f":"IF(I13>0,SUM(V13),\"\")","v":""},"",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":13},{"$f":"ROW() -N$13","v":0},null,null,null,2,100,null,{"$f":"IF(I13>0,($P$12+$Q$12)*((L13*$W$4)+(M13*$W$5))/1000,0)","v":0},{"$f":"IF(I13>0,($P$11+$Q$11)*((L13*$W$4)+(M13*$W$5))/1000,0)","v":0},{"$f":"I13*$X$6/1000","v":0},{"$f":"IF($T$6=TRUE,(L13*$Y$4+M13*$Y$5)/1000, 0)","v":0},{"$f":"IF($T$6=TRUE, I13*$Z$6/1000, 0)","v":0},0]
["",{"$f":"IF(I14>0,SUM(W14:Z14),\"\")","v":""},{"$f":"IF(I14>0,SUM(V14),\"\")","v":""},"",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":14},{"$f":"ROW() -N$13","v":1},null,null,null,2,100,null,{"$f":"IF(I14>0,($P$12+$Q$12)*((L14*$W$4)+(M14*$W$5))/1000,0)","v":0},{"$f":"IF(I14>0,($P$11+$Q$11)*((L14*$W$4)+(M14*$W$5))/1000,0)","v":0},{"$f":"I14*$X$6/1000","v":0},{"$f":"IF($T$6=TRUE,(L14*$Y$4+M14*$Y$5)/1000, 0)","v":0},{"$f":"IF($T$6=TRUE, I14*$Z$6/1000, 0)","v":0},0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":15},2,null,null,null,2,100,null,0,0,0,{"$f":"IF($T$6=TRUE,(L15*$Y$4+M15*$Y$5)/1000, 0)","v":0},0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":16},3,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":17},4,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":18},5,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":19},6,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":20},7,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":21},8,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":22},9,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":23},10,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":24},11,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":25},12,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":26},13,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":27},14,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":28},15,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":29},16,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":30},17,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":31},18,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":32},19,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":33},20,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":34},21,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":35},22,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":36},23,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":37},24,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":38},25,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":39},26,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":40},27,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":41},28,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":42},29,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":43},30,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":44},31,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":45},32,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":46},33,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":47},34,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":48},35,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":49},36,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":50},37,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":51},38,null,null,null,2,100,null,0,0,0,0,0,0]
["","","","",null,null,null,null,null,null,null,0,0,{"$f":"ROW()","v":52},39,null,null,null,2,100,null,0,0,0,0,0,0]
["Total PSNs and Endpoints",null,null,null,null,null,null,null,{"$f":"SUM(I11:I52)","v":2},{"$f":"SUM(J11:J52)","v":100},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V11:V52)","v":2.1599999999999996E-3},{"$f":"SUM(W12:W52)","v":2.1599999999999996E-3},{"$f":"SUM(X12:X52)","v":3.2400000000000003E-3},{"$f":"SUM(Y12:Y52)","v":0},{"$f":"SUM(Z12:Z52)","v":0},{"$f":"SUM(AA12:AA52)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"40-I53","v":38},{"$f":"B3-J53","v":0}]