{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Sizing Procedure"," Sizing Tool","Sample Deployments","Calculations-Hidden"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"merged":[[0,0,0,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[5,0,5,11],[6,0,6,11],[7,0,7,11],[8,0,8,11],[9,0,9,11],[11,0,11,11]]}
["Genesys Web Services and Applications Node Sizing Tool 8.5.2"]
[]
["Note: This sizing calculator provides an estimate of the required number of Web Services nodes (VMs) and peak number of CPU utilization. These numbers are calculated based on input parameters that specify projected load and maximum time for recovery if one API node goes down. The number of VMs and CPU utilization can be used to estimate required number of ESX hosts for a given deployment."]
["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 © 2016-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.5.201.04"]

{"sheet":"Sizing Procedure","index":1,"n_rows":10,"n_cols":2,"rows_kept":10}
[]
[]
[]
[]
[]
[null,"Sizing Procedure"]
[null,"1. Enter Sizing Input Parameters, which reflect expected peak traffic"]
[null,"2. Enter SPECint2006 Rate CPU score,  based on https://www.spec.org/cgi-bin/osgresults?conf=rint2006             For example, SPECint2006 Rate for Intel Xeon E5-2697 = 1180/28 = 42.14"]
[null,"3. Sizing Output Results for the number of API, Elastic Search, Stat and Cassandra nodes are shown immediately, with estimated peak CPU utilization"]
[null,"4. Based on the node and CPU outputs, manually determine the required number of VMWare ESX hosts using these rules:\n- Minimum of 3 ESX hosts, to accommodate HA requirements (each ESX will host one Cassandra and ES node)\n- Total CPU Utilization on a host (sum of CPU utilization for all VMs) must not exceed 75% of total host capacity"]

{"sheet":" Sizing Tool","index":2,"n_rows":31,"n_cols":4,"rows_kept":31}
[]
[null,"Sizing Input"]
[null,"Input Parameter","Value","Comments"]
[null,"Max # Logged in Agents",1500,"Max # of agents logged in simultaneously"]
[null,"Peak Call Rate (calls/sec)",{"v":2,"d":"2.0"},"Peak total rate of all new calls handled by agents (Inbound & Outbound)"]
[null,"Average Call Duration (sec)",600]
[null,"Peak Chat Rate (chat/sec) ",{"v":0,"d":"0.0"}]
[null,"Chat Session duration (sec)",0]
[null,"# Messages per Session",0,"Number of messages going in both directions during one session"]
[null,"Peak Inbound Email Rate",{"v":0,"d":"0.0"},"Average rate of inbound emails"]
[null,"Peak Outbound Email Rate",{"v":0,"d":"0.0"},"Summary of average rate of replies and rate of outbound emails"]
[null,"Rate of Email Through Workbin",{"v":0,"d":"0.0"},"Average rate of emails that go through workbin"]
[null,"Attachment Size (MByte)",0,"Average attachment size in MByte"]
[null,"Max re-Login Time (sec)",10,"Max acceptable time for agent re-login to surviving node after failure"]
[null,"# Cores per VM",4]
[null,"CPU Score (SPECint2006)",42,"https://www.spec.org/cgi-bin/osgresults?conf=rint2006"]
[]
[null,"Sizing Output"]
[null,"Output Parameter","Value","Comments"]
[null,"API Nodes - # Required",{"$f":"INDEX('Calculations-Hidden'!$A$47:$A$62,MATCH(1,('Calculations-Hidden'!$C$47:$C$62<=$C$14)*('Calculations-Hidden'!$E$47:$E$62<'Calculations-Hidden'!$B$37)*('Calculations-Hidden'!$M$47:$M$62<'Calculations-Hidden'!$B$36),0))","v":4}]
[null,"API Nodes - Peak CPU",{"$f":"INDEX('Calculations-Hidden'!$M$47:$M$62,MATCH(1,('Calculations-Hidden'!$C$47:$C$62<=$C$14)*('Calculations-Hidden'!$E$47:$E$62<'Calculations-Hidden'!$B$37)*('Calculations-Hidden'!$M$47:$M$62<'Calculations-Hidden'!$B$36),0))","v":{"v":1.4830992400000003,"d":"148%"}}]
[null,"Elastic Search Nodes - # Required",3]
[null,"Elastic Search Nodes - Peak CPU",{"$f":"'Calculations-Hidden'!$X$48","v":{"v":0.13635000000000003,"d":"14%"}}]
[null,"Stat Nodes - Required",2,"< 10% Peak CPU    One Stat node will also serve Sync function"]
[null,"Cassandra Nodes - # Required",3]
[null,"Cassandra Nodes - Peak CPU",{"$f":"'Calculations-Hidden'!$X$55","v":{"v":0.31484,"d":"31%"}}]
[null,"Derived Parameters","Value","Comments"]
[null,"Max # Agents on a Call",{"$f":"$C$5*$C$6","v":1200}]
[null,"Voice Busy Factor",{"$f":"$C$28/$C$4","v":{"v":0.8,"d":"80%"}},"Note: adjust # Agents & Call Rate if Busy Factor > 100%"]
[null,"# Simultaneous Chat Sessions",{"$f":"C7*C8","v":0}]
[null,"# Chat message rate",{"$f":"C7*C9","v":{"v":0,"d":"0%"}}]

{"sheet":"Sample Deployments","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Calculations-Hidden","index":4,"n_rows":62,"n_cols":24,"rows_kept":62,"hidden":true,"merged":[[0,2,0,12],[0,16,0,26],[1,2,1,12],[1,16,1,26],[2,2,2,12],[2,16,2,26],[3,2,3,12],[3,16,3,26],[4,2,4,12],[4,16,4,26],[5,2,5,12],[5,16,5,26],[6,2,6,12],[6,16,6,26],[7,2,7,12],[7,16,7,26],[8,2,8,12],[8,16,8,26],[9,2,9,12],[9,16,9,26],[10,2,10,12],[10,16,10,26],[11,2,11,12],[12,2,12,12],[13,2,13,12],[14,2,14,12],[14,16,14,26],[15,2,15,12],[15,16,15,26],[16,2,16,12],[16,16,16,26],[17,2,17,12],[17,16,17,26],[18,2,18,12],[18,16,18,26],[19,2,19,12],[19,16,19,26],[20,2,20,12],[20,16,20,26],[21,16,21,26],[22,16,22,26],[23,2,23,12],[23,16,23,26],[24,2,24,12],[24,16,24,26],[25,2,25,12],[26,2,26,12],[27,2,27,12],[28,2,28,12],[29,2,29,12],[33,2,33,12],[34,2,34,12],[35,2,35,12],[36,2,36,12],[37,2,37,12],[38,2,38,12],[39,2,39,12],[40,2,40,12],[41,2,41,12],[42,2,42,12]]}
["Default settings","Values","Comments",{"$nulls":11},"Default settings","Values","Comments"]
["RegMax",30,"Logins Per Second. It depends on DOS filter settings and available bandwidth",{"$nulls":11},"ES Kidle",{"$f":"33/2000","v":0.0165},"K ->coefficient for ES idle (CPU= kx, where x= number of agents)"]
["API Kpro",2.5,"K ->coefficient for call processing (CPU= kx + b, where x= CallRate), status change is included",{"$nulls":11},"ES Kpro",0.48]
["API Bpro",4.54,"b ->coefficient for call processing (CPU= kx + b, where x= CallRate)",{"$nulls":11},"ES Kcontact",0.08]
["API Kreg",10.2,"K ->coefficient for relogin (CPU= kx + b, where x= Login Rate)",{"$nulls":11},"ES Ks_obj_query",0.1]
["API Breg",7.5,"b ->coefficient for relogin (CPU= kx + b, where x= Login Rate)",{"$nulls":11},"ES emailRateInb",1.35]
["API Kcontact",0.73,"Request contact info via UCS, There is no measurement so far, just tree time less than call processing",{"$nulls":11},"ES emailRateOut",0]
["API Bcontact",0,{"$nulls":12},"ES emailRateWBin",0]
["API Kobj_query",0.3,"Need to verify this.",{"$nulls":11},"ES emailIdle",112,"Is it scalable with nodes?"]
["API Bobj_query",0,{"$nulls":12},"ES ChatRate",1.77]
["API Kstatus_change",1,"K ->coefficient for relogin (CPU= kx + b, where x= Status Change Rate)",{"$nulls":11},"ES ChatMsgRate",0.17,"let's ignore this"]
["API Bstatus_change",0,"b ->coefficient for relogin (CPU= kx + b, where x= Status Change Rate)"]
["API Chat K_Rate",4.95]
["API Chat K_MsgRate",1.29]
["API Chat K_ActiveSession",0,{"$nulls":12},"Default settings","Values","Comments"]
["API Email K_RateInb",5.46,{"$nulls":12},"Cassandra Voice K_idle",6,"Is it scalable with nodes? does it depend on agent's number?"]
["API Email K_RateOut",{"$f":"7.12-5.46","v":1.6600000000000001},{"$nulls":12},"Cassandra Voice K_pro",0.38]
["API Email K_RateWorkBin",{"$f":"8.69-7.12","v":1.5699999999999994},{"$nulls":12},"Cassandra Voice K_status",0.15]
["API Email K_AttSize",0.2,"CPU= Krate*Rate(1* Katt*AttInMByte)",{"$nulls":11},"Cassandra Voice  K_reg",1.2]
["API Email K_BodySize",0.2,{"$nulls":12},"Cassandra Chat K_rate",1.1]
["RegMin",3,"Logins Per Second. It depends on DOS filter settings and available bandwidth",{"$nulls":11},"Cassandra Chat K_msgRate",0.5]
[{"$nulls":14},"Cassandra Email K_inb",1.9]
[{"$nulls":14},"Cassandra Email K_out",{"$f":"2.37-1.9","v":0.4700000000000002},"K_inb_reply - Kinb"]
["CPU Overload Trashold ",0.8,{"$nulls":12},"Cassandra Email K_wbin",{"$f":"3.48-2.37","v":1.1099999999999999},"K_inb_wbin_reply - Kinb_reply"]
["Lberr",0.1,{"$nulls":12},"Cassandra Email K_idle",17,"Is it scalable with nodes?"]
["Default CPU score",42.14," https://www.spec.org/cgi-bin/osgresults?conf=rint2006,  (see SPECint2006 Rate for Intel Xeon E5-2697= 1180/28"]
["MultipleObjQuery Refresh Tout",60]
["StatusChangesPerCall",1]
["Call Transfer&Conference ratio",0.2]
["UCSrequestsPerCall",4]
[]
[]
[]
[]
["Derived params"]
["MaxCPU",{"$f":"' Sizing Tool'!C15*100*B24/100","v":{"v":3.2,"d":"320.0%"}},"Maximum CPU per VM"]
["MaxCPUpro",{"$f":"200*B24/100","v":{"v":1.6,"d":"160.0%"}},"Maximum CPU for TServer handling thread"]
["CPUScoreCoeff",{"$f":"$B$26/' Sizing Tool'!$C$16","v":{"v":1.0033333333333334,"d":"1.0"}}]
["CPUScoreCoeffAdjusted",{"$f":"IF(B38>1,B38,IF(B38<0.75,0.75,1-(1-B38)*0.5))","v":{"v":1.0033333333333334,"d":"1.0"}}]
["Call processing rate (adjusted)",{"$f":"' Sizing Tool'!C5*(3*B29+1-B29)","v":{"v":2.8000000000000003,"d":"2.8"}},"Let's assume transfer&conference has 3 times more impact on WebAPI CPU utilization"]
["MultipleObjQuery Rate",{"$f":"' Sizing Tool'!C4/B27","v":{"v":25,"d":"25.0"}},"Need to verify this"]
["Status Change rate",{"$f":"B40*B28","v":{"v":2.8000000000000003,"d":"2.8"}}]
["UCS Request Rate",{"$f":"B40*B30","v":{"v":11.200000000000001,"d":"11.2"}},"Let's assume that WWE issue 4 requests to UCS for each call"]
[]
[]
["#WebAPI Nodes","Re-Login Rate","Re-Login time","CPUpro","CPUrelog","CPUstatus","CPUcontact","CPUobj_query","EmailInb","EmailOut","EmailBin","Chat","CPUtotal",{"$nulls":3},"Elastic Search Nodes","CPUidle","CPUpro","CPUcont","CPUs_obj_query","CPUemail","CPUchat","CPUtotal"]
[2,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A47*(A47-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A47*(A47-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A47*(A47-1)*' Sizing Tool'!$C$14))), 1)","v":30},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B47*A47*(A47-1))),0)","v":25},{"$f":"(($B$3*($B$40/(A47-1)) + $B$4)*(1+$B$25))*$B$39/100","v":{"v":0.12736313333333338,"d":"12.7%"}},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A47*(A47-1)*IF(C47>5,C47,5)))+$B$6)*$B$39/100","v":{"v":3.1454500000000003,"d":"314.5%"}},{"$f":"(($B$11*$B$42+$B$12)*(1+$B$25)*$B$39)/(A47-1)/100","v":{"v":0.030902666666666675,"d":"3.1%"}},{"$f":"(($B$7*$B$43+$B$8)*(1+$B$25)*$B$39)/(A47-1)/100","v":{"v":0.09023578666666668,"d":"9.0%"}},{"$f":"(($B$9*$B$43+$B$10)*(1+$B$25)*$B$39)/(A47-1)/100","v":{"v":0.03708320000000001,"d":"3.7%"}},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A47-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A47-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A47-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A47-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"SUM(D47:L47)","v":{"v":3.4310347866666673,"d":"343.1%"}},{"$nulls":3},2,{"$f":"$P$2*' Sizing Tool'!$C$4/(Q47-1)/100 + IF((' Sizing Tool'!$C$10+' Sizing Tool'!$C$11+' Sizing Tool'!$C$7) > 0,'Calculations-Hidden'!$P$9)/(Q47-1)/100","v":{"v":0.2475,"d":"24.8%"}},{"$f":"$P$3*$B$40/(Q47-1)/100","v":{"v":0.01344,"d":"1.3%"}},{"$f":"$P$4*$B$43/(Q47-1)/100","v":{"v":0.008960000000000001,"d":"0.9%"}},{"$f":"$P$5*$B$40/(Q47-1)/100","v":{"v":2.8000000000000004E-3,"d":"0.3%"}},{"$f":"$P$6*' Sizing Tool'!$C$10/(Q47-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"$P$10*' Sizing Tool'!$C$7/(Q47-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"SUM(R47:W47)","v":{"v":0.27270000000000005,"d":"27.3%"}}]
[3,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A48*(A48-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A48*(A48-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A48*(A48-1)*' Sizing Tool'!$C$14))), 1)","v":25},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B48*A48*(A48-1))),0)","v":10},{"v":0.08873480000000003,"d":"8.9%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A48*(A48-1)*IF(C48>5,C48,5)))+$B$6)*$B$39/100","v":{"v":2.63375,"d":"263.4%"}},{"v":0.015451333333333338,"d":"1.5%"},{"v":0.04511789333333334,"d":"4.5%"},{"v":0.018541600000000005,"d":"1.9%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A48-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A48-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A48-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A48-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"SUM(D48:L48)","v":{"v":2.801595626666667,"d":"280.2%"}},{"$nulls":3},3,{"$f":"$P$2*' Sizing Tool'!$C$4/(Q48-1)/100 + IF((' Sizing Tool'!$C$10+' Sizing Tool'!$C$11+' Sizing Tool'!$C$7) > 0,'Calculations-Hidden'!$P$9)/(Q48-1)/100","v":{"v":0.12375,"d":"12.4%"}},{"$f":"$P$3*$B$40/(Q48-1)/100","v":{"v":0.00672,"d":"0.7%"}},{"$f":"$P$4*$B$43/(Q48-1)/100","v":{"v":4.4800000000000005E-3,"d":"0.4%"}},{"$f":"$P$5*$B$40/(Q48-1)/100","v":{"v":1.4000000000000002E-3,"d":"0.1%"}},{"$f":"$P$6*' Sizing Tool'!$C$10/(Q48-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"$P$10*' Sizing Tool'!$C$7/(Q48-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"SUM(R48:W48)","v":{"v":0.13635000000000003,"d":"13.6%"}}]
[4,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A49*(A49-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A49*(A49-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A49*(A49-1)*' Sizing Tool'!$C$14))), 1)","v":12.5},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B49*A49*(A49-1))),0)","v":10},{"v":0.0758586888888889,"d":"7.6%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A49*(A49-1)*IF(C49>5,C49,5)))+$B$6)*$B$39/100","v":{"v":1.3545000000000003,"d":"135.5%"}},{"v":0.01030088888888889,"d":"1.0%"},{"v":0.030078595555555556,"d":"3.0%"},{"v":0.012361066666666668,"d":"1.2%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A49-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A49-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A49-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A49-1)/100","v":{"v":0,"d":"0.0%"}},{"v":1.4830992400000003,"d":"148.3%"},{"$nulls":3},4,{"$f":"$P$2*' Sizing Tool'!$C$4/(Q49-1)/100 + IF((' Sizing Tool'!$C$10+' Sizing Tool'!$C$11+' Sizing Tool'!$C$7) > 0,'Calculations-Hidden'!$P$9)/(Q49-1)/100","v":{"v":0.0825,"d":"8.3%"}},{"$f":"$P$3*$B$40/(Q49-1)/100","v":{"v":4.4800000000000005E-3,"d":"0.4%"}},{"$f":"$P$4*$B$43/(Q49-1)/100","v":{"v":2.986666666666667E-3,"d":"0.3%"}},{"v":9.3333333333333332E-4,"d":"0.1%"},{"$f":"$P$6*' Sizing Tool'!$C$10/(Q49-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"$P$10*' Sizing Tool'!$C$7/(Q49-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.0909,"d":"9.1%"}]
[5,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A50*(A50-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A50*(A50-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A50*(A50-1)*' Sizing Tool'!$C$14))), 1)","v":7.5},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B50*A50*(A50-1))),0)","v":10},{"v":0.06942063333333334,"d":"6.9%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A50*(A50-1)*IF(C50>5,C50,5)))+$B$6)*$B$39/100","v":{"v":0.8428,"d":"84.3%"}},{"v":0.007725666666666669,"d":"0.8%"},{"v":0.02255894666666667,"d":"2.3%"},{"v":0.009270800000000003,"d":"0.9%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A50-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A50-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A50-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A50-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.9517760466666667,"d":"95.2%"},{"$nulls":3},5,{"$f":"$P$2*' Sizing Tool'!$C$4/(Q50-1)/100 + IF((' Sizing Tool'!$C$10+' Sizing Tool'!$C$11+' Sizing Tool'!$C$7) > 0,'Calculations-Hidden'!$P$9)/(Q50-1)/100","v":{"v":0.061875,"d":"6.2%"}},{"$f":"$P$3*$B$40/(Q50-1)/100","v":{"v":0.00336,"d":"0.3%"}},{"$f":"$P$4*$B$43/(Q50-1)/100","v":{"v":2.2400000000000002E-3,"d":"0.2%"}},{"v":7.000000000000001E-4,"d":"0.1%"},{"$f":"$P$6*' Sizing Tool'!$C$10/(Q50-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"$P$10*' Sizing Tool'!$C$7/(Q50-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.06817500000000001,"d":"6.8%"}]
[6,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A51*(A51-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A51*(A51-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A51*(A51-1)*' Sizing Tool'!$C$14))), 1)","v":5},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B51*A51*(A51-1))),0)","v":10},{"v":0.06555780000000001,"d":"6.6%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A51*(A51-1)*IF(C51>5,C51,5)))+$B$6)*$B$39/100","v":{"v":0.5869500000000001,"d":"58.7%"}},{"v":0.006180533333333334,"d":"0.6%"},{"v":0.018047157333333334,"d":"1.8%"},{"v":0.007416640000000002,"d":"0.7%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A51-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A51-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A51-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A51-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.6841521306666667,"d":"68.4%"}]
[7,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A52*(A52-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A52*(A52-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A52*(A52-1)*' Sizing Tool'!$C$14))), 1)","v":3.6},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B52*A52*(A52-1))),0)","v":9},{"v":0.06298257777777778,"d":"6.3%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A52*(A52-1)*IF(C52>5,C52,5)))+$B$6)*$B$39/100","v":{"v":0.48136111111111113,"d":"48.1%"}},{"v":0.005150444444444445,"d":"0.5%"},{"v":0.015039297777777778,"d":"1.5%"},{"v":0.006180533333333334,"d":"0.6%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A52-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A52-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A52-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A52-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.5707139644444446,"d":"57.1%"}]
[8,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A53*(A53-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A53*(A53-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A53*(A53-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B53*A53*(A53-1))),0)","v":8},{"v":0.06114313333333334,"d":"6.1%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A53*(A53-1)*IF(C53>5,C53,5)))+$B$6)*$B$39/100","v":{"v":0.41790625,"d":"41.8%"}},{"v":0.004414666666666667,"d":"0.4%"},{"v":0.012890826666666667,"d":"1.3%"},{"v":0.005297600000000001,"d":"0.5%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A53-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A53-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A53-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A53-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.5016524766666667,"d":"50.2%"}]
[9,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A54*(A54-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A54*(A54-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A54*(A54-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B54*A54*(A54-1))),0)","v":6},{"v":0.059763550000000006,"d":"6.0%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A54*(A54-1)*IF(C54>5,C54,5)))+$B$6)*$B$39/100","v":{"v":0.4305972222222222,"d":"43.1%"}},{"v":3.8628333333333344E-3,"d":"0.4%"},{"v":0.011279473333333335,"d":"1.1%"},{"v":0.004635400000000001,"d":"0.5%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A54-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A54-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A54-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A54-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.5101384788888887,"d":"51.0%"},{"$nulls":3},"#Cassandra","CPUidle","CPUpro","CPUstatus","CPUreg","CPUemail","CPUchat","CPUTotal"]
[10,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A55*(A55-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A55*(A55-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A55*(A55-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B55*A55*(A55-1))),0)","v":5},{"v":0.05869054074074075,"d":"5.9%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A55*(A55-1)*IF(C55>5,C55,5)))+$B$6)*$B$39/100","v":{"v":0.4163833333333333,"d":"41.6%"}},{"v":3.4336296296296302E-3,"d":"0.3%"},{"v":0.010026198518518518,"d":"1.0%"},{"v":4.1203555555555564E-3,"d":"0.4%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A55-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A55-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A55-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A55-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.49265405777777777,"d":"49.3%"},{"$nulls":3},3,{"$f":"IF((' Sizing Tool'!$C$10+' Sizing Tool'!$C$11+' Sizing Tool'!$C$7) > 0,$P$25,$P$16)/100","v":{"v":0.06,"d":"6.0%"}},{"$f":"$P$17*$B$40/100","v":{"v":0.01064,"d":"1.1%"}},{"$f":"$P$18*$B$42/100","v":{"v":0.004200000000000001,"d":"0.4%"}},{"$f":"$P$19 * 20/100","v":{"v":0.24,"d":"24.0%"}},{"$f":"($P$22*' Sizing Tool'!$C$10+$P$23*' Sizing Tool'!$C$11+$P$24*' Sizing Tool'!$C$12)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($P$20*' Sizing Tool'!$C$7+$P$21*(' Sizing Tool'!$C$7*' Sizing Tool'!$C$9))/100","v":{"v":0,"d":"0.0%"}},{"$f":"SUM(R55:W55)","v":{"v":0.31484,"d":"31.5%"}}]
[11,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A56*(A56-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A56*(A56-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A56*(A56-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B56*A56*(A56-1))),0)","v":4},{"v":0.05783213333333335,"d":"5.8%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A56*(A56-1)*IF(C56>5,C56,5)))+$B$6)*$B$39/100","v":{"v":0.35435909090909085,"d":"35.4%"}},{"v":0.003090266666666667,"d":"0.3%"},{"v":0.009023578666666667,"d":"0.9%"},{"v":0.003708320000000001,"d":"0.4%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A56-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A56-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A56-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A56-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.4280133895757575,"d":"42.8%"}]
[12,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A57*(A57-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A57*(A57-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A57*(A57-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B57*A57*(A57-1))),0)","v":3},{"v":0.057129800000000015,"d":"5.7%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A57*(A57-1)*IF(C57>5,C57,5)))+$B$6)*$B$39/100","v":{"v":0.3078409090909091,"d":"30.8%"}},{"v":2.8093333333333343E-3,"d":"0.3%"},{"v":0.008203253333333334,"d":"0.8%"},{"v":0.003371200000000001,"d":"0.3%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A57-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A57-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A57-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A57-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.3793544957575758,"d":"37.9%"}]
[13,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A58*(A58-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A58*(A58-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A58*(A58-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B58*A58*(A58-1))),0)","v":3},{"v":0.05654452222222223,"d":"5.7%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A58*(A58-1)*IF(C58>5,C58,5)))+$B$6)*$B$39/100","v":{"v":0.27205769230769233,"d":"27.2%"}},{"v":2.5752222222222227E-3,"d":"0.3%"},{"v":7.519648888888889E-3,"d":"0.8%"},{"v":0.003090266666666667,"d":"0.3%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A58-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A58-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A58-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A58-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.34178735230769236,"d":"34.2%"}]
[14,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A59*(A59-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A59*(A59-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A59*(A59-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B59*A59*(A59-1))),0)","v":2},{"v":0.056049287179487185,"d":"5.6%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A59*(A59-1)*IF(C59>5,C59,5)))+$B$6)*$B$39/100","v":{"v":0.24394230769230765,"d":"24.4%"}},{"v":2.3771282051282057E-3,"d":"0.2%"},{"v":0.006941214358974359,"d":"0.7%"},{"v":0.002852553846153847,"d":"0.3%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A59-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A59-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A59-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A59-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.31216249128205126,"d":"31.2%"}]
[15,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A60*(A60-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A60*(A60-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A60*(A60-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B60*A60*(A60-1))),0)","v":2},{"v":0.05562480000000001,"d":"5.6%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A60*(A60-1)*IF(C60>5,C60,5)))+$B$6)*$B$39/100","v":{"v":0.22145,"d":"22.1%"}},{"v":2.2073333333333337E-3,"d":"0.2%"},{"v":0.006445413333333334,"d":"0.6%"},{"v":2.6488000000000006E-3,"d":"0.3%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A60-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A60-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A60-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A60-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.28837634666666667,"d":"28.8%"}]
[16,{"$f":"ROUNDUP(IF(' Sizing Tool'!$C$4/(A61*(A61-1)*' Sizing Tool'!$C$14) > $B$2, $B$2, IF(' Sizing Tool'!$C$4/(A61*(A61-1)*' Sizing Tool'!$C$14) < $B$21, $B$21, ' Sizing Tool'!$C$4/(A61*(A61-1)*' Sizing Tool'!$C$14))), 1)","v":3},{"$f":"ROUNDDOWN((' Sizing Tool'!$C$4/(B61*A61*(A61-1))),0)","v":2},{"v":0.055256911111111126,"d":"5.5%"},{"$f":"($B$5*(' Sizing Tool'!$C$4/(A61*(A61-1)*IF(C61>5,C61,5)))+$B$6)*$B$39/100","v":{"v":0.20317500000000002,"d":"20.3%"}},{"v":2.0601777777777782E-3,"d":"0.2%"},{"v":0.006015719111111112,"d":"0.6%"},{"v":2.472213333333334E-3,"d":"0.2%"},{"$f":"($B$16*' Sizing Tool'!$C$10 * (1+$B$19 * ' Sizing Tool'!$C$13))/(A61-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$17*' Sizing Tool'!$C$11)/(A61-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"($B$18*' Sizing Tool'!$C$12)/(A61-1)/100","v":{"v":0,"d":"0.0%"}},{"$f":"('Calculations-Hidden'!$B$13*' Sizing Tool'!$C$7+'Calculations-Hidden'!$B$14*' Sizing Tool'!$C$9*' Sizing Tool'!$C$7)/(A61-1)/100","v":{"v":0,"d":"0.0%"}},{"v":0.2689800213333333,"d":"26.9%"}]
[99,null,0,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"$f":"D62+E62+F62+G62+H62","v":{"v":0,"d":"0.0%"}}]