{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CUIC","LiveData","BW Data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":16,"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":"CUIC","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,0,7,3],[22,0,22,3],[27,0,27,3],[31,0,31,3],[10,3,12,3]]}
["CUIC Bandwidth Calculator"]
["Release 12.6(1)"]
[]
["Note: Only make changes to fields in yellow."]
[]
[]
["Customer Site Information","Value","Units","Comments"]
["Call Center Information"]
["Total Number of Agents",1800,"agent(s)","2000 maximum"]
["Number of Supervisors",200,"supervisor(s)","Typically 10% of capacity"]
["Number of Historical Reports in CUIC report viewer",2,"Number of reports","This count includes report execution for the user through permalinks and dashboards also."]
["Number of Real Time Reports in CUIC report viewer",2,"Number of reports"]
["Number of LiveData Reports in CUIC report viewer ",2,"Number of reports"]
["Number of LiveData Reports in Finesse Gadget ",2,"Number of reports"]
["Number of Historical Report rows",2000,"Number of rows"]
["Number of Real time Repot rows",100,"Number of rows"]
["Number of Historical Report Columns",20,"Number of columns"]
["Number of Realtime Report Columns",20,"Number of columns"]
[]
["Maximum Login Time for all Supervisors in CUIC interface",2,"Minute(s)"]
["Maximum Login Time for all Agents in Finesse desktop",5,"minute(s)","The total amount of time it should take for all agents to log into the Agent desktop.  If the deployment includes 2000 agents and this value is set to 5 minutes, all 2000 agents should be able to point their browser to Finesse and complete the login sequence within 5 minutes."]
[]
["CUIC Client Interface to CUIC server Bandwidth"]
["Total Bandwidth - No Caching",{"$f":"FIXED((('BW Data'!B12+'BW Data'!B13+'BW Data'!B14)*1.3+(LD_Reports+RT_Reports+HT_Reports)*'BW Data'!B20*1.3+(RT_Report_Columns*RT_Report_Rows)*'BW Data'!B22*RT_Reports*1.3+(HT_Report_Columns*HT_Report_Rows)*'BW Data'!B22*HT_Reports*1.3)*SuperVisors/(Supervisor_Login_Timee*60))","v":"26,885.90"},"KBPS"]
["Total Bandwidth - Caching",{"$f":"FIXED((('BW Data'!B16+'BW Data'!B17+'BW Data'!B18)*1.3+(LD_Reports+RT_Reports+HT_Reports)*'BW Data'!B20*1.3+(RT_Report_Columns*RT_Report_Rows)*'BW Data'!B22*RT_Reports*1.3+(HT_Report_Columns*HT_Report_Rows)*'BW Data'!B22*HT_Reports*1.3)*SuperVisors/(Supervisor_Login_Timee*60))","v":"20,164.69"},"KBPS"]
["Bandwidth to sustain  Reports  in CUIC  ",{"$f":"FIXED((((RT_Report_Columns*RT_Report_Rows)*'BW Data'!B22*1.3+ 'BW Data'!B19*1.3)*RT_Reports*1.3+((HT_Report_Columns*HT_Report_Rows)*'BW Data'!B22*1.3 + 'BW Data'!B19*1.3 )*HT_Reports)*SuperVisors)","v":"1,09,958.06"},"KBPS"]
[]
[" Agent desktop Client to  CUIC server Bandwidth"]
[" Agent desktop Client to  server Bandwidth - No caching",{"$f":"FIXED(('BW Data'!B5*1.3+(LD_Reports-1)*'BW Data'!B7*1.3)*Agents/(Agents_Login_Timee*60))","v":"23,165.85"},"KBPS"]
[" Agent desktop Client to  server Bandwidth - Caching",{"$f":"FIXED(('BW Data'!B6*1.3+(LD_Reports-1)*'BW Data'!B7*1.3)*Agents/(Agents_Login_Timee*60))","v":"5,695.23"},"KBPS"]
[]
[" CUIC Server to AWDB Bandwidth"]
["CUIC Server to AWDB Bandwidth",{"$f":"FIXED((RT_Report_Rows*HT_Report_Columns*4*'BW Data'!B23*1.3)+(HT_Report_Rows*HT_Report_Columns*4*'BW Data'!B23*1.3)*SuperVisors)","v":"2,72,255.55"},"KBPS"]

{"sheet":"LiveData","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,0,7,3],[15,0,15,3],[20,0,20,3],[23,0,23,3],[26,0,26,3]]}
["LiveData Bandwidth Calculator"]
[{"$f":"CUIC!A2","v":"Release 12.6(1)"}]
[]
["Note: Only make changes to fields in yellow."]
[]
[]
["Customer Site Information","Value","Units","Comments"]
["Call Center Information"]
["Total Number of Agents",2000,"agent(s)","2000 maximum"]
["Number of LiveData Reports in Finesse Gadget ",2,"Number of reports"]
["Number of LiveData Report rows",20,"Number of rows"]
[]
["Calls per Second",15,"Calls per second"]
["Maximum Login Time for all Agents in Finesse desktop",5,"minute(s)","The total amount of time it should take for all agents to log into the Finesse server including Finesse failover conditions.  If the deployment includes 2000 agents and this value is set to 5 minutes, all 2000 agents should be able to point their browser to Finesse and complete the login sequence within 5 minutes."]
[]
["Agent Desktop Client to LiveData server Bandwidth"]
[]
["Total Bandwidth required for Login",{"$f":"FIXED(('BW Data'!B28*1.3+(LD_LD_Reports-1)*'BW Data'!B29*1.3 + 'BW Data'!B30*LD_LD_Rows*1.3)*LD_Agent_Count/(LD_Login_Time*60))","v":"203.15"},"KBPS"]
["Bandwidth required to sustain gadgets",{"$f":"FIXED(('BW Data'!B31*1.3*LD_LD_Rows)*LD_LD_Reports*LD_Agent_Count)","v":"23,192.00"},"KBPS"]
[]
["LiveData Server to PG server Bandwidth"]
["Total Bandwidth required to sustain  ",{"$f":"FIXED(LD_Calls_Per_Second*('BW Data'!B32*1.3*8+'BW Data'!B33*1.3)+2*('BW Data'!B34*1.3+'BW Data'!B35*1.3))","v":"604.12"},"KBPS"]
[]
["LiveData Server Side A to Side B server Bandwidth"]
["Total Bandwidth required",{"$f":"FIXED(('BW Data'!B31*1.3*LD_LD_Rows)*LD_LD_Reports*LD_Agent_Count)","v":"23,192.00"},"KBPS"]
[]
["LiveData Server Bandwidth requirement on Service startup"]
["Total Bandwidth required",{"$f":"FIXED('BW Data'!B36*LD_Agent_Count*1.3)","v":"14,645.31"},"KBPS"]

{"sheet":"BW Data","index":2,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,2,0],[24,0,25,0]]}
[]
["CUIC Bandwidth Measurements"]
[null,"Size in KB"]
["Agent Desktop"]
["Download Size - No Browser Cache",{"$f":"2833055/1024","v":2766.6552734375}]
["Download Size - Browser Cache",{"$f":"539477/1024","v":526.8330078125}]
["Data Downloaded for Second Gadget",{"$f":"208205/1024","v":203.3251953125}]
[]
[]
[]
["CUIC"]
["Pre-login size No Cache",{"$f":"1462981/1024","v":1428.6923828125}]
["Post Login No Cache",{"$f":"10638355/1024","v":10389.0185546875}]
["Report Exec No Cache",{"$f":"43540/1024","v":42.51953125}]
[]
["Pre-login size - Cached",{"$f":"1337243/1024","v":1305.9013671875}]
["Post Login - Cached",{"$f":"7592758/1024","v":7414.802734375}]
["Report Exec - Cached",{"$f":"38328/1024","v":37.4296875}]
["Report Auto Refresh ",1.5]
["Data for second report No Cache",{"$f":"23636/1024","v":23.08203125}]
[]
["Approx. Cell Size",{"$f":"5/1024","v":4.8828125E-3}]
["Approx. Cell Size for queries from CUIC Server to AWDB",{"$f":"6.7/1024","v":6.5429687500000002E-3}]
[]
["LiveData Bandwidth Measurements"]
[null,"Size in KB"]
["Agent Desktop"]
["WebService download for 1 Gadget",7]
["Additional Data for next gadget",3.5]
["Snapshot message for one row",{"$f":"0.647","v":0.64700000000000002}]
["Update message for each row",{"$f":"0.223","v":0.223}]
["Agent State Event message size",3.79]
["TCD Message size",{"$f":"636/1024","v":0.62109375}]
["Heartbeat Request Size",{"$f":"103/1024","v":0.1005859375}]
["Timer Report Event ",{"$f":"198/1024","v":0.193359375}]
["Agent Snapshot Message from PG",{"$f":"5768/1024","v":5.6328125}]