{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Main","Server profiles","Load Calculation","Data"],"not_rendered":{"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"merged":[[0,0,2,7],[4,0,4,3],[4,5,4,6],[5,5,5,6],[6,5,6,6],[8,0,10,7],[12,0,12,3],[13,0,13,3],[15,0,17,7],[18,5,18,6],[19,0,19,3],[19,4,19,6],[20,0,20,3],[21,0,21,3],[25,0,27,7]]}
["Genesys Co-browse sizing calculator"]
[]
[]
[]
["Maximum number of concurrent Co-browse sessions",{"$nulls":4},1500]
["Website complexity",{"$nulls":4},"Average website complexity (genesys.com)"]
["Enable WebSocket connections",{"$nulls":4},true]
[]
["Estimated load"]
[]
[]
[]
["Estimated average requests per second",{"$nulls":5},{"$f":"AvgTotalRps","v":3000}]
["Estimated peak requests per second",{"$nulls":5},{"$f":"MaxTotalRps","v":{"v":3219.0890230020664,"d":"3219"}}]
[]
["Recommended deployment options"]
[]
[]
["CPU cores per node",{"$nulls":4},"8 CPU"]
[]
["Minimum Co-browse nodes count",{"$nulls":5},{"$f":"TotalMinimalNodes","v":2}]
["Recommended Co-browse nodes count",{"$nulls":5},{"$f":"TotalNodesCount","v":2}]
[]
["Note:","1. Estimations are valid for both external and embedded Cassandra."]
[null,"2. Minimum number of nodes if using embedded Cassandra is 3."]
["Data transfer estimation"]
[]
[]
[]
["Type","1 minute","1 hour","Daily","Weekly","Monthly","Year"]
["Clients"]
["to server, Gb",{"$f":"PerMinuteClientIn","v":0.47},{"$f":"B32*60","v":{"v":28.2,"d":"28.20"}},{"$f":"C32*24","v":{"v":676.8,"d":"676.80"}},{"$f":"D32*7","v":{"v":4737.599999999999,"d":"4,737.60"}},{"$f":"G32/12","v":{"v":20585.999999999996,"d":"20,586.00"}},{"$f":"D32*365","v":{"v":247031.99999999997,"d":"247,032.00"}}]
["from server, Gb",{"$f":"PerMinuteClientOut","v":0.19},{"$f":"B33*60","v":{"v":11.4,"d":"11.40"}},{"$f":"C33*24","v":{"v":273.6,"d":"273.60"}},{"$f":"D33*7","v":{"v":1915.2000000000003,"d":"1,915.20"}},{"$f":"G33/12","v":{"v":8322.000000000002,"d":"8,322.00"}},{"$f":"D33*365","v":{"v":99864.00000000001,"d":"99,864.00"}}]
[]
["Agents"]
["to server, Gb",{"$f":"PerMinuteAgentsIn","v":0.17},{"$f":"B36*60","v":{"v":10.200000000000001,"d":"10.20"}},{"$f":"C36*24","v":{"v":244.8,"d":"244.80"}},{"$f":"D36*7","v":{"v":1713.6000000000001,"d":"1,713.60"}},{"$f":"G36/12","v":{"v":7446,"d":"7,446.00"}},{"$f":"D36*365","v":{"v":89352,"d":"89,352.00"}}]
["from server, Gb",{"$f":"PerMinuteAgentsOut","v":0.51},{"$f":"B37*60","v":{"v":30.6,"d":"30.60"}},{"$f":"C37*24","v":{"v":734.4000000000001,"d":"734.40"}},{"$f":"D37*7","v":{"v":5140.800000000001,"d":"5,140.80"}},{"$f":"G37/12","v":{"v":22338.000000000004,"d":"22,338.00"}},{"$f":"D37*365","v":{"v":268056.00000000006,"d":"268,056.00"}}]

{"sheet":"Server profiles","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[0,0,0,3],[2,0,2,1],[2,2,2,3],[3,0,3,1],[3,2,3,3],[5,0,5,3],[7,0,7,1],[9,0,9,3],[10,0,10,1],[10,2,10,3],[11,0,11,1],[11,2,11,3]]}
["Recommended Hardware Configuration"]
[]
["CPU",null,"multicore (8+) CPU"]
["RAM",null,"8Gb"]
[]
["Recommended Software Configuration"]
["OS version",null,"Linux 5 x64, Windows Server 2008R2 x64"]
["Java version",null,"Java version 1.7, 64-Bit Server VM"]
[]
["Java options"]
["Initial heap size (Xms)",null,"4Gb"]
["Maximum heap size (Xmx)",null,"4Gb"]

{"sheet":"Load Calculation","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"hidden":true}
["Long polling ",{"$nulls":3},"Web socket"]
["Selected avg RPS",{"$f":"VLOOKUP(SiteType,Data!$A$2:$B$3,2,FALSE)","v":10},null,null,"Selected avg RPS",{"$f":"VLOOKUP(SiteType,Data!A2:C3,3,FALSE)","v":7}]
[]
["Selected sessions",{"$f":"IF(WebsocketEnabled,LPSessionsRatio*AvgSessions,AvgSessions)","v":300},null,null,"Selected sessions",{"$f":"AvgSessions-LPAvgSessions","v":1200}]
[]
["Avg total RPS",{"$f":"AvgRps*LPAvgSessions","v":3000},null,null,"Avg total RPS",{"$f":"WSAvgRps*WSAvgSessions","v":8400}]
["Avg total variation",{"$f":"AvgTotalRps","v":3000},null,null,"Avg total variation",{"$f":"WSAvgTotalRps","v":8400}]
["Max total RPS",{"$f":"AvgTotalRps+4*SQRT(AvgTotalRps)","v":3219.0890230020664},null,null,"Max total RPS",{"$f":"WSAvgTotalRps+4*SQRT(WSAvgTotalRps)","v":8766.606055596467}]
[]
["Selected config"]
["Avg single rps",{"$f":"VLOOKUP(CpuCores,Data!A6:B7,2,FALSE)","v":8000},null,null,"Avg single rps",{"$f":"VLOOKUP(CpuCores,Data!A6:E7,4,FALSE)","v":10000}]
["Max single rps",{"$f":"VLOOKUP(CpuCores,Data!A6:C7,3,FALSE)","v":12000},null,null,"Max single rps",{"$f":"VLOOKUP(CpuCores,Data!A6:E7,5,FALSE)","v":12000}]
[]
[]
["Estimated minimal nodes",{"$f":"INT(AvgTotalRps/MaxSingleRps)+IF(MOD(AvgTotalRps,MaxSingleRps)/MaxSingleRps>ElasticFactor,1,0)","v":0},null,null,"Estimated minimal nodes",{"$f":"INT(WSAvgTotalRps/WSMaxSingleRps)+IF(MOD(WSAvgTotalRps,WSMaxSingleRps)/WSMaxSingleRps>ElasticFactor,1,0)","v":1}]
["Estimated peak nodes",{"$f":"INT(MaxTotalRps/MaxSingleRps)+IF(MOD(MaxTotalRps,MaxSingleRps)/MaxSingleRps>ElasticFactor,1,0)","v":1},null,null,"Estimated peak nodes",{"$f":"INT(WSMaxTotalRps/WSMaxSingleRps)+IF(MOD(WSMaxTotalRps,WSMaxSingleRps)/WSMaxSingleRps>ElasticFactor,1,0)","v":1}]
["Estimated avg nodes",{"$f":"INT(AvgTotalRps/AvgSingleRps)+IF(MOD(AvgTotalRps,AvgSingleRps)/AvgSingleRps>ElasticFactor,1,0)","v":1},null,null,"Estimated avg nodes",{"$f":"INT(WSAvgTotalRps/WSAvgSingleRps)+IF(MOD(WSAvgTotalRps,WSAvgSingleRps)/WSAvgSingleRps>ElasticFactor,1,0)","v":1}]
["Estimated recommended nodes",{"$f":"MAX(EstimatedAvgNodes,EstimatedPeakNodes)","v":1},null,null,"Estimated recommended nodes",{"$f":"MAX(WSEstimatedAvgNodes,WSEstimatedPeakNodes)","v":1}]
[]
[]
[]
["Total"]
[]
["Estimated minimal nodes",{"$f":"MAX(EstimatedMinimalNodes+WSEstimatedMinimalNodes,MinimalNodes)","v":2}]
["Estimated peak nodes",{"$f":"MAX(EstimatedPeakNodes+WSEstimatedPeakNodes,AvgMinimalNodes)","v":2}]
["Estimated avg nodes",{"$f":"MAX(EstimatedAvgNodes+WSEstimatedAvgNodes,AvgMinimalNodes)","v":2}]
["Estimated recommended nodes",{"$f":"MAX(TotalAvgNodes,TotalPeakNodes)","v":2}]
[]
[]
["Data transfer"]
[]
["Traffic per minute, Mb","Clients in","Clients out","Agents in","Agents out"]
["LP",{"$f":"VLOOKUP(SiteType,Data!A22:B23,2,FALSE)","v":0.45},{"$f":"VLOOKUP(SiteType,Data!A22:E23,3,FALSE)","v":0.24},{"$f":"VLOOKUP(SiteType,Data!A22:E23,4,FALSE)","v":0.363},{"$f":"VLOOKUP(SiteType,Data!A22:E23,5,FALSE)","v":0.63}]
["WS",{"$f":"VLOOKUP(SiteType,Data!A22:J23,7,FALSE)","v":0.292},{"$f":"VLOOKUP(SiteType,Data!A22:J23,8,FALSE)","v":0.104},{"$f":"VLOOKUP(SiteType,Data!A22:J23,9,FALSE)","v":0.056},{"$f":"VLOOKUP(SiteType,Data!A22:J23,10,FALSE)","v":0.277}]
[]
["Total transfer, Gb",{"$f":"ROUND((B33*LPAvgSessions + B34*WSAvgSessions)/1024, 2)","v":0.47},{"$f":"ROUND((C33*LPAvgSessions + C34*WSAvgSessions)/1024, 2)","v":0.19},{"$f":"ROUND((D33*LPAvgSessions + D34*WSAvgSessions)/1024, 2)","v":0.17},{"$f":"ROUND((E33*LPAvgSessions + E34*WSAvgSessions)/1024, 2)","v":0.51}]

{"sheet":"Data","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"hidden":true,"merged":[[18,1,18,4],[18,6,18,9],[19,1,19,2],[19,3,19,4],[19,6,19,7],[19,8,19,9]]}
["Page weight","Avg RPS, LP","Avg RPS, WS"]
["Average website complexity (genesys.com)",10,7]
["High website complexity (amazon.com)",25,15]
[]
["Load limits/CPU","Avg RPS per server, LP","Max RPS per server, LP","Avg RPS per server, WS","Max RPS per server, WS"]
["4 CPU",4000,6000,8000,10000]
["8 CPU",8000,12000,10000,12000]
["cpu load",{"v":0.75,"d":"75%"},{"v":1,"d":"100%"},{"v":0.75,"d":"75%"},{"v":1,"d":"100%"}]
[]
["Scalability factor",1]
["Elastic load ",0.25]
["WebSocket part",0.8]
["LP part",{"$f":"0.2","v":0.2}," should be (1 - ws part), do not use equations here due to CB-3720"]
[]
[]
["Minimum nodes count",2]
["Minimum recommended nodes count",2]
[]
["Data transfer","Long Polling ",{"$nulls":4},"WebSocket"]
[null,"Clients",null,"Agents",null,null,"Clients",null,"Agents"]
[null,"to server","from server","to server","from server",null,"to server","from server","to server","from server"]
["Average website complexity (genesys.com)",0.45,0.24,0.363,0.63,null,0.292,0.104,0.056,0.277]
["High website complexity (amazon.com)",3.7,2.18,1.412,4.54,null,2.004,0.282,0.084,1.875]