{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Cover","User Guide","Input&Calculation","Input&Calculation (Redirect)","Windows_all","Windows_trace","Linux_all","Linux_trace","Network"],"not_rendered":{"images":1,"defined_names":366},"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":14,"n_cols":1,"rows_kept":14,"merged":[[0,0,0,11],[13,0,13,11]]}
["Genesys SIP Server Sizing Tool 8.1.1"]
[]
["Note: This Sizing Tool provides a framework to evaluate the Genesys SIP Server load and to make the proper hardware choice for it. Click the tabs at the bottom to access a product. "]
[]
["The information contained herein is proprietary and confidential and cannot be disclosed or duplicated without the prior written consent of Genesys Telecommunications Laboratories, Inc. Copyright © 2014-2017 Genesys Telecommunications Laboratories, Inc. All rights reserved."]
[]
["About Genesys:  Genesys solutions feature leading software that manages customer interactions over phone, Web, and mobile devices. The Genesys software suite handles customer conversations across multiple channels and resources—self-service, assisted-service, and proactive outreach—fulfilling customer requests and optimizing customer care goals while efficiently using resources. Genesys software directs more than 100 million customer interactions every day for 4000 companies and government agencies in 80 countries. These companies and agencies leverage their entire organization, from the contact center to the back office, while dynamically engaging their customers. Go to www.genesys.com for more information.Each product has its own documentation for online viewing at the Genesys Customer Care website or on the Documentation Library DVD, which is available from Genesys upon request. For more information, contact your sales representative."]
["Notice: Although reasonable effort is made to ensure that the information in this document is complete and accurate at the time of release, Genesys Telecommunications Laboratories, Inc., cannot assume responsibility for any existing errors. Changes and/or corrections to the information contained in this document may be incorporated in future versions."]
["Trademarks: Genesys, the Genesys logo, and T-Server are registered trademarks of Genesys Telecommunications Laboratories, Inc. All other trademarks and trade names referred to in this document are the property of other companies. The Crystal monospace font is used by permission of Software Renovation Corporation, www.SoftwareRenovation.com."]
["Technical Support from VARs: If you have purchased support from a value-added reseller (VAR), please contact the VAR for technical support."]
["Customer Care from Genesys: If you have purchased support directly from Genesys, please contact Genesys Customer Care at the regional numbers provided on the Genesys Customer Care website."]
["Ordering and Licensing Information: Complete information on ordering and licensing Genesys products can be found in the Genesys Licensing Guide. Released by Genesys Telecommunications Laboratories, Inc. www.genesys.com."]
[]
["Document Version: 8.1.100.12"]

{"sheet":"User Guide","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"merged":[[0,0,3,8],[15,0,15,1],[15,2,15,8],[16,0,16,1],[16,2,16,8],[19,2,19,13],[22,2,22,8],[23,2,23,8],[24,0,24,1],[24,2,24,8],[25,0,25,1],[25,2,25,8],[26,0,26,1],[26,2,26,8]]}
["SIP Server and SIP Proxy Sizing Tool is an Excel Workbook File. It was developed and tested with Microsoft Excel 2007. To open the User's Guide, Microsoft Word 2007 or later must be installed."]
[]
[]
[]
[]
["Note. Sizing is valid for SIP Server running on dedicated hardware or inside of the Virtual machine on top of VMWare  ESX or Windows Hyper-V"]
["For case of  Virtual machine next conditions should be satisfied:"]
["1. Over-provisioning (CPU and memory) does not happen on hosts where VM with SIP Servers are running"]
["2. Hosts are configured with performance power profile (processors works at the maximum frequency). "]
[]
[]
[]
[]
[]
[]
["Version",null,"Change History"]
[]
["8.1.100.12",null,"Hit Ratio for predictive calls added."]
["8.1.100.11",null,"Virtual Queue Event Distribution Adjustment is now calculated after AttachedData Adjustment but before Monitoring Client Connections Adjustment."]
["8.1.100.10",null,"Validated sizing for Virtual Machines on top of Windows 2012 Hyper-V. Updated a basic set of coefficients."]
["8.1.100.09",null,"Fixed bug in sizing of Redirect Mode for Windows platform(invalid correction of for user date update)."]
["8.1.100.08",null,"Fixed bug in calculation of SIP Server numbers. Removed “Logical Processors” rows, because these values were not used for calculation."]
["8.1.100.07",null,"Added sizing of SIP Server in Redirect mode."]
["8.1.100.06",null,"Updated the formula to calculate a hardware adjustment coefficient."]
["8.1.100.05",null,"Added Virtual Queue event distribution."]
["8.1.100.04",null,"First published version."]

{"sheet":"Input&Calculation","index":2,"n_rows":92,"n_cols":10,"rows_kept":92,"merged":[[1,1,1,6],[1,8,1,9],[3,3,3,6],[4,3,4,6],[6,5,6,6],[6,8,6,9],[7,5,7,6],[7,8,7,9],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[11,8,11,9],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[27,3,27,6],[28,3,28,6],[29,3,29,6],[30,3,30,6],[31,3,31,6],[32,3,32,6],[33,3,33,6],[36,3,36,6],[37,3,37,6],[41,1,41,7],[43,1,43,7],[44,3,44,7],[45,3,45,7],[46,3,46,7],[47,3,47,7],[49,3,49,6],[51,1,51,7],[73,1,73,7],[76,1,76,7],[81,1,81,7],[84,1,84,7],[87,1,87,7],[90,3,90,7],[91,3,91,7]]}
[]
[null,"Genesys SIP Sizing Input Parameters",{"$nulls":6},"Genesys SIP Sizing Output Summary"]
[]
[null,"Parameter","Value","Comments",{"$nulls":4},"Minimum # SIP Server HA Pairs (if running multi-threaded)",{"$f":"MAX(C46,C48,C91)","v":1}]
[null,"Operating System & Log Level","Windows_all",{"$nulls":5},"Minimum # SIP Server HA Pairs (if running single-threaded)",{"$f":"MAX(C46,C48,C92)","v":2}]
[]
[null,"Call Type","Peak Call Traffic\n(calls per sec)","Average Call Duration (sec)","Predictive Hit Ratio (%)","Comments",null,null,{"$f":"CONCATENATE(\"Using current plans with \", TEXT(C29,\"#\"),\" SIP Server HA Pair(s), each with \", TEXT(C30,\"#\"),\" SIP Proxies\")","v":"Using current plans with 1 SIP Server HA Pair(s), each with 2 SIP Proxies"}]
[null,"Inbound Calls - Routed",10,300,{"$nulls":4},"In multi-threaded mode, estimated CPU usage would be"]
[null,"Outbound Calls - Routed Predictive",0,300,{"v":0.3,"d":"30%"},{"$nulls":3},"SIP Server Main Thread CPU (estimated peak %)",{"$f":"D89/100","v":{"v":0.3177596825326676,"d":"31.8%"}}]
[null,"Outbound Calls - Routed Predictive ASM",0,300,{"v":0.3,"d":"30%"},{"$nulls":3},"SIP Server Call Manager Thread CPU (estimated peak %)",{"$f":"E89/100","v":{"v":0.2796186696047096,"d":"28.0%"}}]
[null,"Outbound Calls - Routed Non-Predictive",0,300]
[null,"Internal Calls - Direct (not routed)",2,150,{"$nulls":4},"In single-threaded mode, estimated CPU usage would be"]
[{"$nulls":8},"SIP Server Single Thread CPU (estimated peak %)",{"$f":"F89/100","v":{"v":0.7924910092634546,"d":"79.2%"}}]
[null,"Detailed Call Modeling","Percentage or Rate","Average Call Duration (sec)","Comments"]
[null,"Single-Step Transfer  (% All Routed Calls)",20,"n/a",{"$nulls":4}," SIP Proxy CPU (estimated peak %)",{"$f":"H89/100","v":{"v":0.060485,"d":"6.0%"}}]
[null,"Two-Step Transfer  (% All Routed Calls)",20,100,"Duration of consult call before transfer"]
[null,"Recording  (% of All Routed Calls)",100,"n/a",{"$nulls":4},"SIP Network Bandwidth (total estimated peak KBps)",{"$f":"(C54*Network!NSIP_inbound+C59*Network!NSIP_1xfer+C60*Network!NSIP_2xfer+C61*Network!NSIP_record +C62*Network!NSIP_1confr+C63*Network!NSIP_2confr + C64*Network!NSIP_consult +C58* Network!NSIP_intern +C65*Network!NSIP_treatment + C66*Network!NSIP_treatment_next + C67*Network!NSIP_monitor +C55*Network!NSIP_predictive_route + C56*Network!NSIP_predictive_merge)/1000","v":687}]
[null,"Single-Step Conference   (% All Routed Calls)",20,"n/a",{"$nulls":4},"T-Lib Network Bandwidth (total estimated peak KBps)",{"$f":"ROUND(((C54*Network!NTlib_inbound+C59*Network!NTlib_1xfer+C60*Network!NTlib_2xfer+C61*Network!NTlib_record +C62*Network!NTlib_1confr+C63*Network!NTlib_2confr + C64*Network!NTlib_consult +C58* Network!NTlib_intern +C65*Network!NTlib_treatment + C66*Network!NTlib_treatment_next + C67*Network!NTlib_monitor +C55*Network!NTlib_predictive_route + C56*Network!NTlib_predictive_merge + (C68+C69+C70)*Network!NTLib_ISCC + C33*C54*(C34+Network!NTlib_data))*C32 +(Network!R_size+C36)*C35*(1+C32))/1000,0)","v":2565}]
[null,"Two-Step Conference   (% All Routed Calls)",10,100,"Duration of consult call before merge into conf"]
[null,"Consultation  (% All Routed Calls)",20,100,"Duration of consult call  (no xfer or conf)",{"$nulls":3},"Concurrent Calls Per SIP Server HA Pair (estimated peak)",{"$f":"C45/C29","v":3900}]
[null,"Treatment (% Inbound calls) ",100,"n/a",{"$nulls":4},"Agent Connections Per SIP Server HA Pair (estimated peak)",{"$f":"C31/C29","v":1000}]
[null,"# Treatments per Inbound Call",5,"n/a"]
[null,"Voice Monitoring (% All Routed calls)",20,"n/a"]
[null,"ISCC Origination (% of Inbound calls)",50,"n/a"]
[null,"ISCC Direct-UUI (% of Inbound calls)",0,"n/a"]
[null,"ISCC Route (% of Inbound calls)",0,"n/a"]
[]
[null,"Parameter","Value","Comments"]
[null,"Planned # SIP Server HA Pair(s)",1]
[null,"Planned # SIP Proxies per SIP Server HA Pair",2,"Proxy is optional; but when deployed use at least 2"]
[null,"Agent Desktops Connections (total)",1000,"Connections from Workspace or custom desktop"]
[null,"Monitoring Client Connections (to each SIP Server)",6,"Connections from Stat Server, ICON, etc"]
[null,"Attached Data - Average # Updates per Call",10]
[null,"Attached Data - Average Size per Update (bytes)",1024]
[null,"Virtual Queue: Overall Event Rate",100]
[null,"Vrtual Queue: Average User Data Size",1024]
[null,"Customer Platform -  CPU Benchmark",30.5]
[null,"Genesys Reference  Platform -  CPU Benchmark",30.5,"Dell Power Edge R710 2.8 GHz, 8 Cores/16 hyper threads"]
[]
[]
[]
[null,"Calculations"]
[]
[null,"Capacity Calculations"]
[null,"Peak Concurrent calls",{"$f":"C8*D8+C9*D9+C10*D10+C12*D12+SUM(C8:C12)*C16/100*D16+SUM(C8:C12)*C19/100*D19+SUM(C8:C12)*C20/100*D20","v":3900}]
[null,"Min # SIP Server HA pairs to handle concurrent calls",{"$f":"ROUNDUP(C45/INDIRECT(platform&\"!MAX_concur\"),0)","v":1}]
[null,"Agent Desktop Connections (per Server)",{"$f":"C31/C29","v":1000}]
[null,"Min # SIP Server HA pairs to handle agent desktop connections",{"$f":"ROUNDUP(C31/INDIRECT(platform&\"!MAX_concur\"),0)","v":1}]
[]
[null,"Hardware adjustment coeficient",{"$f":"C38/C37","v":1}]
[null,""]
[null,"CPU Usage per scenario per server "]
[null,"Type of Activity","Call Rate per SIP Server","Main Thread CPU (%)","Call Manager Thread CPU (%)","Single Thread CPU (%)","Call Rate per SIP Proxy ","SIP Proxy CPU (%)"]
[null,"Inbound Calls - Routed",{"$f":"C8/C29","v":{"v":10,"d":"10.00"}},{"$f":"C54*INDIRECT(platform&\"!MT_inbound\")","v":{"v":3.678756476683938,"d":"3.68"}},{"$f":"C54*INDIRECT(platform&\"!CM_inbound\")","v":{"v":4.419689119170985,"d":"4.42"}},{"$f":"C54*INDIRECT(platform&\"!ST_inbound\")","v":{"v":8.098445595854923,"d":"8.10"}},{"$f":"C8/C30/C29","v":{"v":5,"d":"5.00"}},{"$f":"G54*INDIRECT(platform&\"!PR_inbound\")","v":{"v":0.5850000000000001,"d":"0.59"}}]
[null,"Outbound Calls - Routed, Predictive",{"$f":"C9/C29","v":{"v":0,"d":"0.00"}},{"$f":"C55*E9*INDIRECT(platform&\"!MT_predictive_route\")+ C55*(100% - E9)*INDIRECT(platform&\"!MT_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C55*E9*INDIRECT(platform&\"!CM_predictive_route\")+ C55*(100% - E9)*INDIRECT(platform&\"!CM_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C55*INDIRECT(platform&\"!ST_predictive_route\")","v":{"v":0,"d":"0.00"}},{"$f":"C9/C30/C29","v":{"v":0,"d":"0.00"}},{"$f":"G55*INDIRECT(platform&\"!PR_predictive_route\")","v":{"v":0,"d":"0.00"}}]
[null,"Outbound Calls - Routed, Predictive ASM",{"$f":"C10/C29","v":{"v":0,"d":"0.00"}},{"$f":"C56*E10*INDIRECT(platform&\"!MT_predictive_merge\")+ C56*(100% - E10)*INDIRECT(platform&\"!MT_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C56*E10*INDIRECT(platform&\"!CM_predictive_merge\")+ C56*(100% - E10)*INDIRECT(platform&\"!CM_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C56*INDIRECT(platform&\"!ST_predictive_merge\")","v":{"v":0,"d":"0.00"}},{"$f":"C10/C30/C29","v":{"v":0,"d":"0.00"}},{"$f":"G56*INDIRECT(platform&\"!PR_predictive_merge\")","v":{"v":0,"d":"0.00"}}]
[null,"Outbound Calls - Routed, Non-Predictive",{"$f":"C11/C29","v":{"v":0,"d":"0.00"}},{"$f":"C57*INDIRECT(platform&\"!MT_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C57*INDIRECT(platform&\"!CM_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C57*INDIRECT(platform&\"!ST_inbound\")","v":{"v":0,"d":"0.00"}},{"$f":"C11/C37/C30","v":{"v":0,"d":"0.00"}},{"$f":"G57*INDIRECT(platform&\"!PR_inbound\")","v":{"v":0,"d":"0.00"}}]
[null,"Internal Calls - Direct (non routed)",{"$f":"C12/C29","v":{"v":2,"d":"2.00"}},{"$f":"C58*INDIRECT(platform&\"!MT_intern\")","v":{"v":0.6159235668789809,"d":"0.62"}},{"$f":"C58*INDIRECT(platform&\"!CM_intern\")","v":{"v":0.9585987261146497,"d":"0.96"}},{"$f":"C58*INDIRECT(platform&\"!ST_intern\")","v":{"v":1.5745222929936307,"d":"1.57"}},{"$f":"C12/C30/C29","v":{"v":1,"d":"1.00"}},{"$f":"G58*INDIRECT(platform&\"!PR_intern\")","v":{"v":0.211,"d":"0.21"}}]
[null,"Single-Step Transfer",{"$f":"SUM(C54:C57)*(C15/100)","v":{"v":2,"d":"2.00"}},{"$f":"C59*INDIRECT(platform&\"!MT_1xfer\")","v":{"v":0.40271024312475107,"d":"0.40"}},{"$f":"C59*INDIRECT(platform&\"!CM_1xfer\")","v":{"v":0.6314467915504184,"d":"0.63"}},{"$f":"C59*INDIRECT(platform&\"!ST_1xfer\")","v":{"v":1.0341570346751694,"d":"1.03"}},{"$f":"SUM(G54:G57)*(C15/100)","v":{"v":1,"d":"1.00"}},{"$f":"G59*INDIRECT(platform&\"!PR_1xfer\")","v":{"v":0.128,"d":"0.13"}}]
[null,"Two-Step Transfer",{"$f":"SUM(C54:C57)*(C16/100)","v":{"v":2,"d":"2.00"}},{"$f":"C60*INDIRECT(platform&\"!MT_2xfer\")","v":{"v":0.9583663517220361,"d":"0.96"}},{"$f":"C60*INDIRECT(platform&\"!CM_2xfer\")","v":{"v":2.1337092349893325,"d":"2.13"}},{"$f":"C60*INDIRECT(platform&\"!ST_2xfer\")","v":{"v":3.0920755867113687,"d":"3.09"}},{"$f":"SUM(G54:G57)*(C16/100)","v":{"v":1,"d":"1.00"}},{"$f":"G60*INDIRECT(platform&\"!PR_2xfer\")","v":{"v":0.511,"d":"0.51"}}]
[null,"Recording",{"$f":"SUM(C54:C57)*(C17/100)","v":{"v":10,"d":"10.00"}},{"$f":"C61*INDIRECT(platform&\"!MT_record\")","v":{"v":1.1981666002391385,"d":"1.20"}},{"$f":"C61*INDIRECT(platform&\"!CM_record\")","v":{"v":5.703387803905937,"d":"5.70"}},{"$f":"C61*INDIRECT(platform&\"!ST_record\")","v":{"v":6.901554404145076,"d":"6.90"}},{"$f":"SUM(G54:G57)*(C17/100)","v":{"v":5,"d":"5.00"}},{"$f":"G61*INDIRECT(platform&\"!PR_record\")","v":{"v":1.3250000000000002,"d":"1.33"}}]
[null,"Single-Step Conference",{"$f":"SUM(C54:C57)*(C18/100)","v":{"v":2,"d":"2.00"}},{"$f":"C62*INDIRECT(platform&\"!MT_1confr\")","v":{"v":0.7407192928985066,"d":"0.74"}},{"$f":"C62*INDIRECT(platform&\"!CM_1confr\")","v":{"v":2.033709234989332,"d":"2.03"}},{"$f":"C62*INDIRECT(platform&\"!ST_1confr\")","v":{"v":2.7744285278878387,"d":"2.77"}},{"$f":"SUM(G54:G57)*(C18/100)","v":{"v":1,"d":"1.00"}},{"$f":"G62*INDIRECT(platform&\"!PR_1confr\")","v":{"v":0.437,"d":"0.44"}}]
[null,"Two-Step Conference",{"$f":"SUM(C54:C57)*(C19/100)","v":{"v":1,"d":"1.00"}},{"$f":"C63*INDIRECT(platform&\"!MT_2confr\")","v":{"v":0.6090474292546832,"d":"0.61"}},{"$f":"C63*INDIRECT(platform&\"!CM_2confr\")","v":{"v":1.79649262654444,"d":"1.80"}},{"$f":"C63*INDIRECT(platform&\"!ST_2confr\")","v":{"v":2.4055400557991233,"d":"2.41"}},{"$f":"SUM(G54:G57)*(C19/100)","v":{"v":0.5,"d":"0.50"}},{"$f":"G63*INDIRECT(platform&\"!PR_2confr\")","v":{"v":0.4535,"d":"0.45"}}]
[null,"Consultation",{"$f":"SUM(C54:C57)*(C20/100)","v":{"v":2,"d":"2.00"}},{"$f":"C64*INDIRECT(platform&\"!MT_consult\")","v":{"v":0.9024839987808594,"d":"0.90"}},{"$f":"C64*INDIRECT(platform&\"!CM_consult\")","v":{"v":2.145473940871686,"d":"2.15"}},{"$f":"C64*INDIRECT(platform&\"!ST_consult\")","v":{"v":3.0479579396525454,"d":"3.05"}},{"$f":"SUM(G54:G57)*(C20/100)","v":{"v":1,"d":"1.00"}},{"$f":"G64*INDIRECT(platform&\"!PR_consult\")","v":{"v":0.496,"d":"0.50"}}]
[null,"Treatments (first)",{"$f":"C54*(C21/100)","v":{"v":10,"d":"10.00"}},{"$f":"C65*INDIRECT(platform&\"!MT_treatment\")","v":{"v":1.3212435233160613,"d":"1.32"}},{"$f":"C65*INDIRECT(platform&\"!CM_treatment\")","v":{"v":2.7956954962136304,"d":"2.80"}},{"$f":"C65*INDIRECT(platform&\"!ST_treatment\")","v":{"v":4.116939019529692,"d":"4.12"}},{"$f":"G54*(C21/100)","v":{"v":5,"d":"5.00"}},{"$f":"G65*INDIRECT(platform&\"!PR_treatment\")","v":{"v":0.735,"d":"0.74"}}]
[null,"Treatments (next)",{"$f":"C54*(C22-1)*(C21/100)","v":{"v":40,"d":"40.00"}},{"$f":"C66*INDIRECT(platform&\"!MT_treatment_next\")","v":{"v":5.16923076923077,"d":"5.17"}},{"$f":"C66*INDIRECT(platform&\"!CM_treatment_next\")","v":{"v":3.69230769230769,"d":"3.69"}},{"$f":"C66*INDIRECT(platform&\"!ST_treatment_next\")","v":{"v":8.86153846153846,"d":"8.86"}},{"$f":"G54*(C22-1)*(C21/100)","v":{"v":20,"d":"20.00"}},{"$f":"G66*INDIRECT(platform&\"!PR_treatment_next\")","v":{"v":0.8400000000000001,"d":"0.84"}}]
[null,"Monitoring",{"$f":"SUM(C54:C57)*(C23/100)","v":{"v":2,"d":"2.00"}},{"$f":"C67*INDIRECT(platform&\"!MT_monitor\")","v":{"v":0.599542822310271,"d":"0.60"}},{"$f":"C67*INDIRECT(platform&\"!CM_monitor\")","v":{"v":1.6513562938128616,"d":"1.65"}},{"$f":"C67*INDIRECT(platform&\"!ST_monitor\")","v":{"v":2.250899116123133,"d":"2.25"}},{"$f":"SUM(G54:G57)*(C23/100)","v":{"v":1,"d":"1.00"}},{"$f":"G67*INDIRECT(platform&\"!PR_monitor\")","v":{"v":0.327,"d":"0.33"}}]
[null,"ISCC Origination",{"$f":"C54*(C24/100)","v":{"v":5,"d":"5.00"}},{"$f":"C68*INDIRECT(platform&\"!MT_iscc_source\")","v":{"v":0.17500000000000002,"d":"0.18"}},{"$f":"C68*INDIRECT(platform&\"!CM_iscc_source\")","v":{"v":0,"d":"0.00"}},{"$f":"C68*INDIRECT(platform&\"!ST_iscc_source\")","v":{"v":0.17500000000000002,"d":"0.18"}},{"v":0,"d":"0.00"}]
[null,"ISCC Direct-UUI",{"$f":"C54*(C25/100)","v":{"v":0,"d":"0.00"}},{"$f":"C69*INDIRECT(platform&\"!MT_iscc_directUUI\")","v":{"v":0,"d":"0.00"}},{"$f":"C69*INDIRECT(platform&\"!CM_iscc_directUUI\")","v":{"v":0,"d":"0.00"}},{"$f":"C69*INDIRECT(platform&\"!ST_iscc_directUUI\")","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[null,"ISCC Route",{"$f":"C54*(C26/100)","v":{"v":0,"d":"0.00"}},{"$f":"C70*INDIRECT(platform&\"!MT_iscc_route\")","v":{"v":0,"d":"0.00"}},{"$f":"C70*INDIRECT(platform&\"!CM_iscc_route\")","v":{"v":0,"d":"0.00"}},{"$f":"C70*INDIRECT(platform&\"!ST_iscc_route\")","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[]
[null,"Totals",null,{"$f":"SUM(D54:D71)","v":{"v":16.371191074439995,"d":"16.37"}},{"$f":"SUM(E54:E71)","v":{"v":27.96186696047096,"d":"27.96"}},{"$f":"SUM(F54:F71)","v":{"v":44.33305803491096,"d":"44.33"}},null,{"$f":"SUM(H54:H71)","v":{"v":6.0485,"d":"6.05"}}]
[]
[null,"Agent Desktop Connections Adjustment"]
[{"$nulls":3},{"$f":"D72*(1+(C31/C29)*INDIRECT(platform&\"!MT_aclients\"))","v":{"v":16.649501322705472,"d":"16.65"}},{"$f":"E72*(1+(C31/C29)*INDIRECT(platform&\"!CM_aclients\"))","v":{"v":27.96186696047096,"d":"27.96"}},{"$f":"F72*(1+(C31/C29)*INDIRECT(platform&\"!ST_aclients\"))","v":{"v":45.08672002150445,"d":"45.09"}},null,{"$f":"H72","v":{"v":6.0485,"d":"6.05"}}]
[]
[null,"Attached Data Adjustment"]
[{"$nulls":3},{"$f":"D75*(1 +C33*INDIRECT(platform&\"!MT_update\"))*(1+C33*C34*INDIRECT(platform&\"!MT_attach\"))","v":{"v":26.12936822613104,"d":"26.13"}},{"$f":"E75","v":{"v":27.96186696047096,"d":"27.96"}},{"$f":"F75*(1 +C33*INDIRECT(platform&\"!ST_update\"))*(1+C33*C34*INDIRECT(platform&\"!ST_attach\"))","v":{"v":70.75812582709416,"d":"70.76"}},null,{"$f":"H75","v":{"v":6.0485,"d":"6.05"}}]
[]
[null,"Virtual Queue Distribution",{"$f":"C35/C29","v":{"v":100,"d":"100.00"}},{"$f":"C80*INDIRECT(platform&\"!MT_vqrate\") + C80*C32*(C36/1000)*INDIRECT(platform&\"!MT_vqdata\")","v":{"v":2.242032,"d":"2.24"}},{"$f":"C80*INDIRECT(platform&\"!CM_vqrate\") + C80*C32*(C36/1000)*INDIRECT(platform&\"!CM_vqdata\")","v":{"v":0,"d":"0.00"}},{"$f":"C80*INDIRECT(platform&\"!ST_vqrate\") + C80*C32*(C36/1000)*INDIRECT(platform&\"!ST_vqdata\")","v":{"v":2.242032,"d":"2.24"}}]
[]
[null,"Virtual Queue Dsitribution Adjustment"]
[{"$nulls":3},{"$f":"D78+D80","v":{"v":28.371400226131037,"d":"28.37"}},{"$f":"E78+E80","v":{"v":27.96186696047096,"d":"27.96"}},{"$f":"F78+F80","v":{"v":73.00015782709416,"d":"73.00"}}]
[]
[null,"Monitoring Client Connections Adjustment"]
[{"$nulls":3},{"$f":"D83*(1+C32*INDIRECT(platform&\"!MT_mclients\"))","v":{"v":31.775968253266765,"d":"31.78"}},{"$f":"E83*(1+C32*INDIRECT(platform&\"!CM_mclients\"))","v":{"v":27.96186696047096,"d":"27.96"}},{"$f":"F78*(1+C32*INDIRECT(platform&\"!ST_mclients\"))","v":{"v":79.24910092634546,"d":"79.25"}},null,{"$f":"H78","v":{"v":6.0485,"d":"6.05"}}]
[]
[null,"Hardware Adjustment"]
[{"$nulls":3},{"$f":"D86*C50","v":{"v":31.775968253266765,"d":"31.78"}},{"$f":"E86*C50","v":{"v":27.96186696047096,"d":"27.96"}},{"$f":"F86*C50","v":{"v":79.24910092634546,"d":"79.25"}},null,{"$f":"H86*C50","v":{"v":6.0485,"d":"6.05"}}]
[]
[null,"Minimum # Multi-threaded SIP Server HA Pair(s) to handle Call Traffic",{"$f":"ROUNDUP(MAX(D89:E89)*C29/75,0)","v":1},"Max Threshold is to keep CPU usage of each thread below 75%"]
[null,"Minimum # Single-threaded SIP Server HA Pair(s) to handle Call Traffic",{"$f":"ROUNDUP(F89/75*C29,0)","v":2},"Max Threshold is to keep CPU usage of each thread below 75%"]

{"sheet":"Input&Calculation (Redirect)","index":3,"n_rows":60,"n_cols":10,"rows_kept":60,"merged":[[1,1,1,6],[1,8,1,9],[3,3,3,6],[4,3,4,6],[5,1,5,6],[6,3,6,6],[6,8,6,9],[7,3,7,6],[7,8,7,9],[8,3,8,6],[9,3,9,6],[10,3,10,6],[11,3,11,6],[11,8,11,9],[12,1,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[16,3,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,3,20,6],[21,3,21,6],[22,3,22,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[26,3,26,6],[27,3,27,6],[28,3,28,6],[29,3,29,6],[33,1,33,7],[35,1,35,7],[36,3,36,7],[37,1,37,7],[38,1,38,7],[49,1,49,7],[52,1,52,7],[55,1,55,7],[58,3,58,7],[59,3,59,7]]}
[]
[null,"Genesys SIP Sizing Input Parameters",{"$nulls":6},"Genesys SIP Sizing Output Summary"]
[]
[null,"Parameter","Value","Comments",{"$nulls":4},"Minimum # SIP Server HA Pairs (if running multi-threaded)",{"$f":"C59","v":1}]
[null,"Operating System & Log Level","Windows_all",{"$nulls":5},"Minimum # SIP Server HA Pairs (if running single-threaded)",{"$f":"C60","v":1}]
[]
[null,"Call Type","Peak Call Traffic\n(calls per sec)","Comments",{"$nulls":4},{"$f":"CONCATENATE(\"Using current plans with \", TEXT(C22,\"#\"),\" SIP Server HA Pair(s), each with \", TEXT(C26,\"#\"),\" SIP Proxies\")","v":"Using current plans with 1 SIP Server HA Pair(s), each with  SIP Proxies"}]
[null,"Inbound Calls - Routed",75,{"$nulls":5},"In multi-threaded mode, estimated CPU usage would be"]
[{"$nulls":8},"SIP Server Main Thread CPU (estimated peak %)",{"$f":"D57/100","v":{"v":0.4119790282309094,"d":"41.2%"}}]
[{"$nulls":8},"SIP Server Call Manager Thread CPU (estimated peak %)",{"$f":"E57/100","v":{"v":0.18975,"d":"19.0%"}}]
[]
[{"$nulls":8},"In single-threaded mode, estimated CPU usage would be"]
[{"$nulls":8},"SIP Server Single Thread CPU (estimated peak %)",{"$f":"F57/100","v":{"v":0.5902110900896718,"d":"59.0%"}}]
[null,"Detailed Call Modeling","Percentage or Rate","Comments"]
[null,"ISCC Origination (% of Inbound calls)",100,{"$nulls":5}," SIP Proxy CPU (estimated peak %)",{"$f":"H57/100","v":{"v":0,"d":"0.0%"}}]
[null,"ISCC Direct-UUI (% of Inbound calls)",0]
[null,"ISCC Route (% of Inbound calls)",100,{"$nulls":5},"SIP Network Bandwidth (total estimated peak KBps)",{"$f":"ROUND((C41*Network!NSIP_Redirect)/1000,0)","v":188}]
[{"$nulls":8},"T-Lib Network Bandwidth (total estimated peak KBps)",{"$f":"ROUND(((C41*Network!NTlib_Redirect + (C43+C44+C45)*Network!NTLib_ISCC + C24*C41*(C25+Network!NTlib_data))*C23)/1000,0)","v":3295}]
[]
[]
[null,"Parameter","Value","Comments"]
[null,"Planned # SIP Server HA Pair(s) (Warm Standby)",1]
[null,"Monitoring Client Connections (to each SIP Server)",6,"Connections from Stat Server, ICON, etc"]
[null,"Attached Data - Average # Updates per Call",3]
[null,"Attached Data - Average Size per Update (bytes)",1024]
[]
[null,"Customer Platform -  CPU Benchmark",30.5]
[null,"Customer Platform -  # Logical Processors",16]
[null,"Genesys Reference  Platform -  CPU Benchmark",30.5,"Dell Power Edge R710 2.8 GHz, 8 Cores/16 hyper threads"]
[null,"Genesys Reference  Platform  -  # Logical Processors",16]
[]
[]
[]
[null,"Calculations"]
[]
[null,"Capacity Calculations"]
[null,"Hardware adjustment coeficient",{"$f":"C29/C27","v":1}]
[null,""]
[null,"CPU Usage per scenario per server "]
[null,"Type of Activity","Call Rate per SIP Server","Main Thread CPU (%)","Call Manager Thread CPU (%)","Single Thread CPU (%)"]
[null,"Inbound Calls - Routed",{"$f":"C8/C22","v":{"v":75,"d":"75.00"}},{"$f":"C41*INDIRECT(platform&\"!MT_redirect\")","v":{"v":16.425,"d":"16.43"}},{"$f":"C41*INDIRECT(platform&\"!CM_redirect\")","v":{"v":13.725,"d":"13.73"}},{"$f":"C41*INDIRECT(platform&\"!ST_redirect\")","v":{"v":24.900000000000002,"d":"24.90"}}]
[]
[null,"ISCC Origination",{"$f":"C41*(C15/100)","v":{"v":75,"d":"75.00"}},{"$f":"C43*INDIRECT(platform&\"!MT_iscc_source\")","v":{"v":2.6250000000000004,"d":"2.63"}},{"$f":"C43*INDIRECT(platform&\"!CM_iscc_source\")","v":{"v":0,"d":"0.00"}},{"$f":"C43*INDIRECT(platform&\"!ST_iscc_source\")","v":{"v":2.6250000000000004,"d":"2.63"}}]
[null,"ISCC Direct-UUI",{"$f":"C41*(C16/100)","v":{"v":0,"d":"0.00"}},{"$f":"C44*INDIRECT(platform&\"!MT_iscc_directUUI\")","v":{"v":0,"d":"0.00"}},{"$f":"C44*INDIRECT(platform&\"!CM_iscc_directUUI\")","v":{"v":0,"d":"0.00"}},{"$f":"C44*INDIRECT(platform&\"!ST_iscc_directUUI\")","v":{"v":0,"d":"0.00"}}]
[null,"ISCC Route",{"$f":"C41*(C17/100)","v":{"v":75,"d":"75.00"}},{"$f":"C45*INDIRECT(platform&\"!MT_iscc_route\")","v":{"v":12.675,"d":"12.68"}},{"$f":"C45*INDIRECT(platform&\"!CM_iscc_route\")","v":{"v":5.250000000000001,"d":"5.25"}},{"$f":"C45*INDIRECT(platform&\"!ST_iscc_route\")","v":{"v":17.925,"d":"17.93"}}]
[]
[null,"Totals",null,{"$f":"SUM(D41:D46)","v":{"v":31.725,"d":"31.73"}},{"$f":"SUM(E41:E46)","v":{"v":18.975,"d":"18.98"}},{"$f":"SUM(F41:F46)","v":45.45}]
[]
[]
[null,"Attached Data Adjustment"]
[{"$nulls":3},{"$f":"D47*(1 +C24*INDIRECT(platform&\"!MT_update\"))*(1+C24*C25*INDIRECT(platform&\"!MT_attach\"))","v":{"v":36.783841806331196,"d":"36.78"}},{"$f":"E47*(1 +C24*INDIRECT(platform&\"!CM_update\"))*(1+C24*C25*INDIRECT(platform&\"!CM_attach\"))","v":{"v":18.975,"d":"18.98"}},{"$f":"F47*(1 +C24*INDIRECT(platform&\"!ST_update\"))*(1+C24*C25*INDIRECT(platform&\"!ST_attach\"))","v":{"v":52.6974187580064,"d":"52.70"}}]
[]
[null,"Monitoring Client Connections Adjustment"]
[{"$nulls":3},{"$f":"D51*(1+C23*INDIRECT(platform&\"!MT_mclients\"))","v":{"v":41.19790282309094,"d":"41.20"}},{"$f":"E51*(1+C23*INDIRECT(platform&\"!CM_mclients\"))","v":{"v":18.975,"d":"18.98"}},{"$f":"F51*(1+C23*INDIRECT(platform&\"!ST_mclients\"))","v":{"v":59.02110900896717,"d":"59.02"}},null,{"$f":"H51","v":{"v":0,"d":"0.00"}}]
[]
[null,"Hardware Adjustment"]
[{"$nulls":3},{"$f":"D54*C37","v":{"v":41.19790282309094,"d":"41.20"}},{"$f":"E54*C37","v":{"v":18.975,"d":"18.98"}},{"$f":"F54*C37","v":{"v":59.02110900896717,"d":"59.02"}},null,{"$f":"H54*C37","v":{"v":0,"d":"0.00"}}]
[]
[null,"Minimum # Multi-threaded SIP Server HA Pair(s) to handle Call Traffic",{"$f":"ROUNDUP(MAX(D54:E54)*C22/75,0)","v":1},"Max Threshold is to keep CPU usage of each thread below 75%"]
[null,"Minimum # Single-threaded SIP Server HA Pair(s) to handle Call Traffic",{"$f":"ROUNDUP(F54/75*C22,0)","v":1},"Max Threshold is to keep CPU usage of each thread below 75%"]

{"sheet":"Windows_all","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[0,0,1,0],[0,1,0,4],[0,5,1,5],[21,1,21,3]]}
["Call and Clients Activities","Windows Platform",{"$nulls":3},"Comments"]
[null,"Main Thread","Call Manager Thread","Single Thread","SIP Proxy"]
["Inbound Call",0.3678756476683938,0.4419689119170985,{"$f":"B3+C3","v":0.8098445595854923},0.117]
["Single-Step Transfer",0.20135512156237553,0.3157233957752092,{"$f":"B4+C4","v":0.5170785173375847},0.128]
["Two-Step Transfer",0.47918317586101805,1.0668546174946663,1.5460377933556844,0.511]
["Recording",0.11981666002391385,0.5703387803905937,0.6901554404145076,0.265]
["Single-Step Conference",0.3703596464492533,1.016854617494666,{"$f":"B7+C7","v":1.3872142639439193},0.437]
["Two-Step Conference",0.6090474292546832,1.79649262654444,2.4055400557991233,0.907]
["Consultation Call",0.4512419993904297,1.072736970435843,1.5239789698262727,0.496]
["Internal Call (3pcc)",0.30796178343949043,0.47929936305732485,0.7872611464968153,0.211]
["Treatment (first)",0.13212435233160613,0.27956954962136304,0.4116939019529692,0.147]
["Treatment (next)",0.12923076923076926,0.09230769230769224,0.22153846153846152,0.042]
["Monitoring",0.2997714111551355,0.8256781469064308,1.1254495580615664,0.327]
["Predictive ",0.5788461538461539,0.975,1.5538461538461539,0.419]
["Predictive ASM",0.9653846153846153,0.8923076923076924,1.8576923076923078,0.34]
["Redirect",0.219,0.183,0.332,0]
["ISCC Origination",0.035,0,0.035,0]
["ISCC Direct-UUI",0.029,0,0.029,0]
["ISCC Route",0.169,0.07,0.23900000000000002,0]
[]
[]
["Max number of concurent calls",15000]
[]
["Updates data adjustment",0.014667,0,{"$f":"B24","v":0.014667}]
["Size data adjustment",3.6e-05,0,{"$f":"B25","v":3.6e-05}]
[]
["T-Library client connections adjustment (per client)",1.7E-5,0,{"$f":"B27+C27","v":1.7E-5}]
[]
["T-Library monitoring client  connections adjustment (per client) ",0.02,0,0.02]
[]
["Virtual Queue Event Distribution (rate)",0.0207,0,0.0207]
["Virtual Queue Event Distribution (data size)",0.00028,0,0.00028]

{"sheet":"Windows_trace","index":5,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[0,0,1,0],[0,1,0,4],[0,5,1,5],[21,1,21,3]]}
["Call and Clients Activities","Windows Platform",{"$nulls":3},"Comments"]
[null,"Main Thread","Call Manager Thread","Single Thread","SIP Proxy"]
["Inbound Call",0.23834196891191714,0.35906735751295327,{"$f":"B3+C3","v":0.5974093264248704},0.085]
["Single-Step Transfer",0.1155041849342367,0.20247110402550828,{"$f":"B4+C4","v":0.317975288959745},0.066]
["Two-Step Transfer",0.2998933252057298,0.8850502895458697,1.1849436147515995,0.391]
["Recording",0.05550418493423669,0.47631725787166185,0.5318214428058985,0.176]
["Single-Step Conference",0.24695214873514165,0.8115208777811643,1.058473026516306,0.308]
["Two-Step Conference",0.40011956954962136,1.4717018732562777,1.871821442805899,0.672]
["Consultation Call",0.32342273697043583,0.9379914660164584,1.2614142029868942,0.391]
["Internal Call (3pcc)",0.19585987261146495,0.37388535031847137,0.5697452229299363,0.152]
["Treatment (first)",0.10011956954962137,0.20554802710243142,0.3056675966520528,0.102]
["Treatment (next)",0.0938461538461538,0.07230769230769224,0.16615384615384604,0.024]
["Monitoring",0.22342273697043571,0.7409326424870464,0.9643553794574821,0.342]
["Predictive ",0.40961538461538466,0.8596153846153847,1.2692307692307694,0.268]
["Predictive ASM",0.6846153846153846,0.676923076923077,1.3615384615384616,0.223]
["Redirect",0.149,0.155,0.246,0]
["ISCC Origination",0.018,0.018,0.036,0]
["ISCC Direct-UUI",1E-3,0,1E-3,0]
["ISCC Route",0.077,0.004,0.081,0]
[]
[]
["Max number of concurent calls",15000]
[]
["Updates data adjustment",0.012903,0,{"$f":"B24","v":0.012903}]
["Size data adjustment",1e-05,0,{"$f":"B25","v":1e-05}]
[]
["T-Library client connections adjustment (per client)",4e-05,2e-06,2.4e-05]
[]
["T-Library monitoring client  connections adjustment (per client) ",0.02,0,0.02]
[]
["Virtual Queue Event Distribution (rate)",0.0042,0,0.0042]
["Virtual Queue Event Distribution (data size)",0.00015,0,0.00015]

{"sheet":"Linux_all","index":6,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[0,0,1,0],[0,1,0,4],[0,5,1,5],[21,1,21,3]]}
["Call and Clients Activities","Linux Platform",{"$nulls":3},"Comments"]
[null,"Main Thread","Call Manager Thread","Single Thread","SIP Proxy"]
["Inbound Call",0.364,0.503,{"$f":"B3+C3","v":0.867},0.097]
["Single-Step Transfer",0.167,0.317,{"$f":"B4+C4","v":0.484},0.09]
["Two-Step Transfer",0.436,1.163,1.599,0.451]
["Recording",0.056,0.555,0.6110000000000001,0.24]
["Single-Step Conference",0.324,1.087,1.411,0.376]
["Two-Step Conference",0.559,1.984,2.543,0.755]
["Consultation Call",0.48,1.208,1.688,0.435]
["Internal Call (3pcc)",0.307,0.536,0.843,0.172]
["Treatment (first)",0.276,0.357,0.633,0.118]
["Treatment (next)",0.208,0.084,0.292,0.039]
["Monitoring",0.251,0.866,1.117,0.295]
["Predictive ",0.73,1.243,1.973,0.362]
["Predictive ASM",1.32,1.1,2.42,0.253]
["Redirect",0.164,0.181,0.317,0]
["ISCC Origination",0.049,0.012,0.061,0]
["ISCC Direct-UUI",0.029,0.012,0.041,0]
["ISCC Route",0.178,0.082,0.26,0]
[]
[]
["Max number of concurent calls",15000]
[]
["Updates data adjustment",0.0141843,0,{"$f":"B24","v":0.0141843}]
["Size data adjustment",2.59e-05,0,{"$f":"B25","v":2.59e-05}]
[]
["T-Library client connections adjustment (per client)",7.9e-05,0,{"$f":"B27","v":7.9e-05}]
[]
["T-Library monitoring client  connections adjustment (per client) ",0.02,0,0.02]
[]
["Virtual Queue Event Distribution (rate)",0.0161,0,0.0161]
["Virtual Queue Event Distribution (data size)",0.000311,0,0.000311]

{"sheet":"Linux_trace","index":7,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[0,0,1,0],[0,1,0,4],[0,5,1,5],[21,1,21,3]]}
["Call and Clients Activities","Linux Platform",{"$nulls":3},"Comments"]
[null,"Main Thread","Call Manager Thread","Single Thread","SIP Proxy"]
["Inbound Call",0.212,0.411,{"$f":"B3+C3","v":0.623},0.072]
["Single-Step Transfer",0.134,0.262,{"$f":"B4+C4","v":0.396},0.064]
["Two-Step Transfer",0.321,0.967,1.288,0.3]
["Recording",0.045,0.447,0.492,0.179]
["Single-Step Conference",0.255,0.923,1.178,0.287]
["Two-Step Conference",0.413,1.689,2.102,0.548]
["Consultation Call",0.311,0.998,1.309,0.321]
["Internal Call (3pcc)",0.184,0.447,0.631,0.129]
["Treatment (first)",0.208,0.269,0.477,0.081]
["Treatment (next)",0.169,0.089,0.258,0.029]
["Monitoring",0.188,0.712,0.8999999999999999,0.216]
["Predictive ",0.461,0.961,1.422,0.277]
["Predictive ASM",1.02,0.92,1.94,0.181]
["Redirect",0.119,0.16,0.245,0]
["ISCC Origination",0.019,0,0.019,0]
["ISCC Direct-UUI",0.014,0,0.014,0]
["ISCC Route",0.106,0.046,0.152,0]
[]
[]
["Max number of concurent calls",15000]
[]
["Updates data adjustment",0.0125,0,{"$f":"B24","v":0.0125}]
["Size data adjustment",1.9e-05,0,{"$f":"B25","v":1.9e-05}]
[]
["T-Library client connections adjustment (per client)",1.26E-4,4e-06,{"$f":"B27","v":1.26E-4}]
[]
["T-Library monitoring client  connections adjustment (per client) ",0.02,0,0.02]
[]
["Virtual Queue Event Distribution (rate)",0.00406,0,0.00406]
["Virtual Queue Event Distribution (data size)",0.00026,0,0.00026]

{"sheet":"Network","index":8,"n_rows":19,"n_cols":7,"rows_kept":19}
[]
[]
["Activities","SIP Trafic per call (bytes)","Number of T-Library Requests/Events","T-Lib Network Traffic (bytes)",null,"Average Size of Request","Average Size of Event"]
["Inbound Call",7500,15,{"$f":"(C4-1)*E_size + R_size","v":3750},null,250,250]
["Single-Step Transfer",7500,6,1500]
["Two-Step Transfer",31500,13,3250]
["Recording",17000,9,2250]
["Single-Step Conference",23500,9,2250]
["Two-Step Conference",53000,17,4250]
["Consultation Call",32500,17,4250]
["Internal Call (3pcc)",16000,13,3250]
["Treatment (first)",6000,2,500]
["Treatment (next)",1500,2,500]
["Monitoring",23500,9,2250]
["Predictive",15000,6,1500]
["Predictive ASM",39000,13,{"$f":"(C16-1)*E_size + R_size","v":3250}]
["Redirect",2500,5,{"$f":"(C17-1)*E_size + R_size","v":1250}]
["ISCC",null,3,750]
["Data Update",null,2,500]