{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["Cover","Contact","ConfigServer","DataMart","GIM","GKC","GVP ","ICON","iWD Sizing Calculator","LRM","Multimedia","OCS","WFM Oracle","WFM MSSQL","WFM DB2","ICON_IDBSize","IconRowSizes","UCS"],"not_rendered":{"images":1,"defined_names":56,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"merged":[[0,0,0,11],[12,0,12,11]]}
["Genesys Database Sizing Estimator 8.x Worksheets"]
[]
["Note: This Database Size Estimator provides a range of expected database sizes for various Genesys products. 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 © 2000–2016 Genesys Telecommunications Laboratories, Inc. All rights reserved."]
[]
["About Genesys:  Genesys is the world's leading provider of customer service and contact center software—with more than 4,000 customers in 80 countries. Drawing on its more than 20 years of customer service innovation and experience, Genesys is uniquely positioned to help companies bring their people, insights and customer channels together to effectively drive today’s customer conversation. Genesys software directs more than 100 million interactions every day, maximizing the value of customer engagement and differentiating the experience by driving personalization and multi-channel customer service—and extending customer service across the enterprise to optimize processes and the performance of customer-facing employees. Go to www.genesyslab.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.\nYour Responsibility for Your System’s Security: You are responsible for the security of your system. Product administration to prevent unauthorized use is your responsibility. Your system administrator should read all documents provided with this product to fully understand the features available that reduce your risk of incurring charges for unlicensed use of Genesys products."]
["Trademarks: Genesys and the Genesys logo are registered trademarks of Genesys Telecommunications Laboratories, Inc. All other company names and logos may be trademarks or registered trademarks of their respective holders. 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."]
["Ordering and Licensing Information: Complete information on ordering and licensing Genesys products can be found in the Genesys Licensing Guide."]
[]
["Document Version: 8g_DBSizing_03-2016_v8.0.001.12"]

{"sheet":"Contact","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"merged":[[2,1,2,3],[3,1,3,3]]}
[null,"Customer Care Contact Information"]
[]
[null,"Technical Support from VARs\nIf you have purchased support from a value-added reseller (VAR), please contact the VAR for technical support."]
[null,"Customer Care from Genesys\nIf you have purchased support directly from Genesys, please contact Genesys Customer Care (http://www.genesys.com/customer-care/contact-us). Before contacting\nCustomer Care, please refer to the Genesys Care Support Guide for On-Premises (http://www.genesys.com/customer-care/support-processes) for complete contact information and procedures."]

{"sheet":"ConfigServer","index":2,"n_rows":52,"n_cols":2,"rows_kept":52}
["Configuration Database 8.0"]
["Use this spreadsheet to estimate the size of the  Configuration Database for your environment. Some examples are provided.                           1.  Change the values for your environment.                                                                                                                                   2. Your estimated database size appears in the last row: Config DB Size (MB)"]
[]
["           Configuration Data Objects"]
[]
["Environment","Number"]
["Hosts",2]
["Alarm conditions",10]
["Application Templates",35]
["Applications",{"v":1000,"d":"1,000"}]
["Services",2]
["Tenants",1]
["Time Zone",1]
["Scripts",4]
["Access Groups",5]
["Folders",12]
["Enumerators",21]
["Enumerators values (Total for all Enumerators)",64]
["CTI","Number"]
["Switching Offices",2]
["Physical Switches",2]
["Persons",{"v":3000,"d":"3,000"}]
["Agent Groups",100]
["Agent Logins",{"v":3000,"d":"3,000"}]
["Places",{"v":2000,"d":"2,000"}]
["Place Groups",100]
["DNs",{"v":2100,"d":"2,100"}]
["DN Groups",100]
["Voice Prompts",20]
["IVR Ports",20]
["IVRs",20]
["Outbound","Number"]
["Calling Lists",5]
["Campaigns",5]
["Campaign Groups",1]
["Treatments",2]
["Table Access",1]
["Filters",20]
["Routing","Number"]
["Skills",{"v":1000,"d":"1,000"}]
["Transactions",100]
["Objective Tables",1]
["Statistical Days",5]
["Statistical Tables",5]
["Action Codes",50]
["GVP","Number"]
["GVP Resellers"]
["GVP Customers"]
["GVP IVR Profiles"]
["Scheduled Tasks"]
[]
["Config DB Size (MB)",{"$f":"SUM(B7:B18,B20:B31,B33:B38,B40:B45,B47:B50)*10*1024/(1024*1024)","v":{"v":125.15625,"d":"125.16"}}]

{"sheet":"DataMart","index":3,"n_rows":68,"n_cols":9,"rows_kept":68}
["                                        "," Select DB from drop-down","Record Length"]
["ODS and DataMart 8.0","Sybase",{"$f":"VLOOKUP(B2,H3:I6,2,FALSE)","v":83},{"$nulls":4},"Database","Record Length"]
["Use this spreadsheet to estimate the size of the ODS and DataMart Database for your environment. \nSome examples are provided.                                                                                                                                                                               1. Select the database from the drop-down menu in the second column.                                                                                          2. Change the values for your environment.                                                                                                                3. Your estimated database sizes appear in the last rows.   ",{"$nulls":6},"Oracle",42]
[{"$nulls":7},"MS SQLServer",66]
["           Layouts",{"$nulls":6},"IBM DB2",58]
[{"$nulls":7},"Sybase",83]
["Outbound Contact Layout Templates","Number","Statistics"]
["CALL_LS",1,24]
["CMP",1,25]
["CMP_CALL_L",1,24]
["CMP_GR",25,7]
["GROFPLS",25,28]
["GROFQUEUES",5,11]
["O_AGENT",500,32]
["O_AGENT_GR",50,32]
["PLACE",250,28]
["QUEUE",5,11]
["ROUTEPOINT",25,11]
["VCB Layout Templates","Number","Statistics"]
["VCB_GQ_EV",5,9]
["VCB_GQUEUE",5,12]
["VCB_Q_EV",10,9]
["VCB_QUEUE",10,12]
["VCB_RP",50,12]
["VCB_TENANT",2,21]
["Enterprise Routing Layout Templates","Number","Statistics"]
["AGENT",{"v":1000,"d":"1,000"},28]
["GROFAGS",100,28]
["GROFPLS",25,28]
["GROQUEUES",5,11]
["PLACE",500,28]
["QUEUE",10,11]
["ROUTEPOINT",50,11]
["Multimedia Layout Templates","Number","Statistics"]
["ERMS"]
["EMAIL_AGENT",{"v":1000,"d":"1,000"},11]
["EMAIL_GAGENT",100,11]
["EMAIL_GPLACE",25,11]
["EMAIL_IQUEUE",50,5]
["EMAIL_PLACE",500,11]
["EMAIL_TENANT",2,11]
["Web Media"]
["CHAT_A",{"v":1000,"d":"1,000"},13]
["CHAT_GA",100,13]
["CHAT_GH",3,7]
["CHAT_GP",25,13]
["CHAT_P",500,13]
["Voice"]
["VOICE_A",{"v":1000,"d":"1,000"},22]
["VOICE_AG",100,27]
["VOICE_GQ",5,13]
["VOICE_P",500,22]
["VOICE_PG",25,27]
["VOICE_Q",10,13]
["VOICE_RP",50,13]
["VOICE_T",2,16]
[]
["Total Requests Number",{"$f":"SUM(B8:B18*C8:C18,B20:B25*C20:C25,B27:B33*C27:C33,B36:B41*C36:C41,B43:B47*C43:C47,B49:B56*C49:C56)","v":{"v":149650,"d":"149,650"}}]
[]
["Collection Time Profiles per Day",96]
[]
["ODS Lifetime (Days)",5]
[]
["ODS Size (GB)",{"$f":"B58*C2*B60*(B62+2)/1073741824","v":{"v":7.773636281490326,"d":"7.77"}}]
[]
["Datamart Lifetime (Days)",365]
[]
["DataMart Size (GB)",{"$f":"(B58*B60*B66*8+20000)/1073741824","v":{"v":39.06889632344246,"d":"39.07"}}]

{"sheet":"GIM","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[3,1,3,4],[6,1,6,5]]}
["Genesys Info Mart Database Size Estimator"]
[]
["This Database Size Estimator requires a separate spreadsheet. Download the spreadsheet using the link provided below."]
[null,"GIM 8.1 Database Size Estimator"]
[]
["Note: The estimator can also be accessed from the Genesys Info Mart documentation landing page using the link provided below."]
[null,"https://docs.genesys.com/Documentation/GIM"]

{"sheet":"GKC","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[3,1,3,4],[6,1,6,5]]}
["Genesys Knowledge Center Sizing Estimator"]
[]
["This Database Size Estimator requires a separate spreadsheet. Download the spreadsheet using the link provided below."]
[null,"Genesys Knowledge Center Sizing Workbook"]
[]
["Note: The estimator can also be accessed from the Genesys Knowleddge Center documentation landing page using the link provided below."]
[null,"https://docs.genesys.com/Documentation/KC"]

{"sheet":"GVP ","index":6,"n_rows":53,"n_cols":14,"rows_kept":53,"merged":[[1,0,1,1],[1,2,1,3],[2,2,2,3],[2,6,8,6],[2,12,8,12],[2,13,46,13],[3,2,3,3],[3,7,8,7],[3,11,8,11],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[9,6,32,6],[9,12,32,12],[10,2,10,3],[10,7,15,7],[10,11,15,11],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[17,7,23,7],[18,2,18,3],[18,11,23,11],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[24,7,27,7],[24,11,27,11],[28,7,32,7],[28,11,32,11],[30,0,35,0],[33,6,40,6],[33,12,40,12],[34,7,39,7],[34,11,39,11],[36,0,41,0],[41,6,46,6],[41,7,46,7],[41,11,46,11],[41,12,46,12],[43,0,46,0],[47,0,51,0]]}
["GVP"]
["Required Estimates",null,"Description",{"$nulls":3},"Component",null,"Data Type","Percent of Total","Required Disk Usage (MB)","Sum per Datatype per Component (GB)","Sum per Component (GB)","Sum (GB) + Overhead"]
["# of DN",30,{"$nulls":4},"Resource Manager","CDR","CDR",{"$f":"(K3/1024)/$N$3","v":{"v":0.3377601148078255,"d":"33.776%"}},{"$f":"((1300 + 1430*B13)*B12 *(C30+1)) / 1048576","v":{"v":1882790.2221679687,"d":"1,882,790.222168"}},{"$f":" K3 / 1024","v":{"v":1838.662326335907,"d":"1,838.662326"}},{"$f":" L3 + L4","v":{"v":1839.1742876172066,"d":"1,839.174288"}},{"$f":"M3+M10+M34+M42 + 0.5","v":{"v":5443.692862853407,"d":"5,443.692863"}}]
["# of IVR Profiles",30,{"$nulls":5},"Operational Reporting","OR (5 minutes)",{"$f":"(K4/1024)/$N$3","v":{"v":7.44990603380922e-05,"d":"0.007%"}},{"$f":" 300 *(B3  + B4 + B5 + B9 + B10 + 1) * B6 * 2 * 1440 * (C31+1) / 1048576","v":{"v":415.283203125,"d":"415.283203"}},{"$f":" (K4 + K5 + K6 + K7 + K8+ K9) / 1024","v":{"v":0.5119612812995911,"d":"0.511961"}}]
["# of Tenants",2,"Include number of Sub-Tenants",{"$nulls":5},"OR (30 minutes)",{"v":9.93320804507896e-06,"d":"0.001%"},{"$f":" 300 * (B3 + B4 + B5 + B9 + B10 + 1) * B6 * 2* 48 *(C32+1) / 1048576","v":{"v":55.37109375,"d":"55.371094"}}]
["# of RM",4,"Number of ALL ResourceManager applications. HA-pairs count as 2",{"$nulls":5},"OR (hourly)",{"v":4.96660402253948e-06,"d":"0.000%"},{"$f":" 300 * (B3 + B4 + B5 + B9 + B10 + 1)* B6 * 2 * 24 * (C33+1) / 1048576","v":{"v":27.685546875,"d":"27.685547"}}]
["# of MCPs",8,"Number of Media Control Platform Applications",{"$nulls":5},"OR (daily)",{"v":2.353963364849441E-6,"d":"0.000%"},{"$f":" 300 * (B3 + B4 + B5 + B9 + B10 +1) *B6 *2 * (C34+1) / 1048576","v":{"v":13.121795654296875,"d":"13.121796"}}]
["# of CCPs",0,"Number of Call Control Platform Applications",{"$nulls":5},"OR (weekly)",{"v":1.3488173126688318E-6,"d":"0.000%"},{"$f":" 300 * (B3 + B4 + B5 + B9 + B10 + 1) *B6 * 2 *(C35+1) / (7 * 1048576)","v":{"v":7.518768310546875,"d":"7.518768"}}]
["# of CTIC",0,"Number of CTI Connectors",{"$nulls":5},"OR (monthly)",{"v":9.450343765109843E-7,"d":"0.000%"},{"$f":" 300 * (B3 + B4 + B5 + B9 + B10 +1) *B6 * 2 *(C36+1) / (30 * 1048576)","v":{"v":5.2679443359375,"d":"5.267944"}}]
["# of PSTNC",0,"Number of PSTN Connectors",{"$nulls":3},"Media Control Platform","CDR","CDR",{"v":0.4837516662632226,"d":"48.375%"},{"$f":" ( (3250+(660*B15)) * B14 * (1+C30))/ 1048576","v":{"v":2696596.9848632813,"d":"2,696,596.984863"}},{"$f":" K10 / 1024","v":{"v":2633.395493030548,"d":"2,633.395493"}},{"$f":"L10+L11+L17+L18+L19+L25+L29","v":{"v":3603.9454379103013,"d":"3,603.945438"}}]
["# of ASR and TTS components",4,"Number of ASR components plus the number of TTS components configured in the deployment",{"$nulls":4},"Operational Reporting","OR (5 minutes)",{"v":3.7840792552681751E-5,"d":"0.004%"},{"$f":" (300 * (B4 +1) * B7 * 1440 * (1+C31) + 300 * B7 *1440 * (C31+1)) / 1048576","v":{"v":210.9375,"d":"210.937500"}},{"$f":" (K11 + K12 + K13 + K14 +K15 + K16) / 1024","v":{"v":0.257693241749491,"d":"0.257693"}}]
["# of Calls per Day (RM)",{"v":23328000,"d":"23,328,000"},{"$nulls":6},"OR (30 minutes)",{"v":5.0454390070242333E-6,"d":"0.001%"},{"$f":" (300 * (B4 + 1) * B7 *48 * (1+C32) + 300 * B7 * 48 *(C32+1)) / 1048576","v":{"v":28.125,"d":"28.125000"}}]
["Average tenant hierarchy length (RM)",1,"The average number of tenants in the tenant hierarchy for RM sessions",{"$nulls":5},"OR (hourly)",{"v":2.5227195035121167E-6,"d":"0.000%"},{"$f":" (300 * (B4 + 1) * B7 * 24 * (1+C33) + 300 * B7 * 24 * (C33+1)) / 1048576","v":{"v":14.0625,"d":"14.062500"}}]
["# of Calls per Day (MCP)",{"v":23328000,"d":"23,328,000"},{"$nulls":6},"OR (daily)",{"v":1.170754266115595E-6,"d":"0.000%"},{"$f":" (300 * (B4 + 1) * B7 * (C34+1) + 100 * B7 *(C34+1)) / 1048576","v":{"v":6.52618408203125,"d":"6.526184"}}]
["Average tenant hierarchy length (MCP)",1,"The average number of tenants in the tenant hierarchy for MCP sessions",{"$nulls":5},"OR (weekly)",{"v":6.8511355564131146E-7,"d":"0.000%"},{"$f":" (((300 * ( B4 + 1) * B7 * (C35+1)) / 7) + ((300 * B7  * (1+C35)) / 7)) / 1048576","v":{"v":3.819056919642857,"d":"3.819057"}}]
["# of Events per call (MCP)",5,"Depends on VXML application call flow and needs to be reviewed after application is implemented",{"$nulls":5},"OR (monthly)",{"v":7.3127660087159507E-8,"d":"0.000%"},{"$f":" (((300 * (B4 + 1) *  (C36+1)) / 30) + (300 * B7 * (C36+1) / 30)) / 1048576","v":{"v":0.4076385498046875,"d":"0.407639"}}]
["# of Custom VARs per call",0,"Depends on the application implementation. This refers to the number of variables logged in a single call flow by \n<log label=\"com.genesyslab.var.CustomVar\">name|value</log>",{"$nulls":4},"Events","Events",{"v":0.07982042179081307,"d":"7.982%"},{"$f":" (500 * B14 * B16 *(C43+1)) / 1048576","v":{"v":444946.2890625,"d":"444,946.289063"}},{"$f":" K17 / 1024","v":{"v":434.51786041259766,"d":"434.517860"}}]
["# of IVR Actions",0,"refers to the number of unique “actionID” logged in your application, by the log tag \n<log label=\"com.genesyslab.var.ActionStart\">actionID[|parentID=<PID>]</log>",{"$nulls":4},"VAR","CDR",{"v":0.061860826887880124,"d":"6.186%"},{"$f":" ((500 + (500 * B17)) * B14 * (C30+1)) / 1048576","v":{"v":344833.3740234375,"d":"344,833.374023"}},{"$f":" K18 / 1024","v":{"v":336.7513418197632,"d":"336.751342"}}]
["# of Unique Call End Reasons",0,"refers to the number of unique “Call End Reasons” logged in your application, by the log tag \n<log label=\"com.genesyslab.var.CallResult\">result[|reason]</log>. ",{"$nulls":5},"VAR (5 minutes)",{"v":1.8920396276340875E-5,"d":"0.002%"},{"$f":" (300 * ( B4 + B5) * (B18 +1) * (B19+1) * 1440 * (C37+1)) *4/ 1048576","v":{"v":105.46875,"d":"105.468750"}},{"$f":" (K19 + K20 + K21 + K22 + K23 + K24) / 1024","v":{"v":0.13002191271100724,"d":"0.130022"}}]
["Failure %",5,"This is an estimate of the number of calls that will fail the service quality measurement. ",{"$nulls":5},"VAR (30 minutes)",{"v":2.5227195035121167E-6,"d":"0.000%"},{"$f":" (300 * (B4 + B5) * (B18 + 1) * (B19+1) * 48 * (C38+1)) *4/ 1048576","v":{"v":14.0625,"d":"14.062500"}}]
["SQA stat update period",900,"The SQA stat update period (see the [sqa]stat.update.interval option in the RS configuration) in seconds.",{"$nulls":5},"VAR (hourly)",{"v":1.2613597517560583E-6,"d":"0.000%"},{"$f":" (300 * (B4 + B5) * (B18 + 1) * (B19+1) * 24 * (C39+1)) *4/ 1048576","v":{"v":7.03125,"d":"7.031250"}}]
["SQA service quality period",900,"The Service Quality Period (see the [sqa]service.quality.period option in the RS configuration) in seconds.",{"$nulls":5},"VAR (daily)",{"v":5.9783196567604848E-7,"d":"0.000%"},{"$f":" (300 * ( B4 + B5 ) * (B18 + 1) * (B19+1) * (C40+1)) *4 / 1048576","v":{"v":3.33251953125,"d":"3.332520"}}]
["# of Calls per Day (CCP)",0,{"$nulls":6},"VAR (weekly)",{"v":3.4255677782065573E-7,"d":"0.000%"},{"$f":" (300 * ( B4 + B5 ) *(B18 + 1) * (B19+1) * (C41+1)) * 4/ (7 * 1048576)","v":{"v":1.9095284598214286,"d":"1.909528"}}]
["Average tenant hierarchy length (CCP)",1,"The average number of tenants in the tenant hierarchy for CCP sessions",{"$nulls":5},"VAR (monthly)",{"v":2.4000873054247223E-7,"d":"0.000%"},{"$f":" (300 * ( B4 + B5 ) * (B18 + 1) * (B19+1) * (C42+1)) * 4 / ( 30 * 1048576)","v":{"v":1.337890625,"d":"1.337891"}}]
["# of Events per call (CCP)",5,"Depends on CCXML application call flow and needs to be reviewed after application is implemented",{"$nulls":4},"SQA Latency","hourly",{"v":9.08179021264362e-06,"d":"0.001%"},{"$f":" (270 *B7 * (C44+1) * 24 * (3600/B21) *32) / 1048576","v":{"v":50.625,"d":"50.625000"}},{"$f":" (K25 + K26 + K27 + K28) / 1024","v":{"v":0.061004774911063056,"d":"0.061005"}}]
[{"$nulls":8},"daily",{"v":1.0760975382168874E-6,"d":"0.000%"},{"$f":" (270 *B7 * (C45+1) *32) /1048576","v":{"v":5.99853515625,"d":"5.998535"}}]
[{"$nulls":8},"weekly",{"v":6.1660220007718036E-7,"d":"0.000%"},{"$f":" (270 *B7 * (1+C46)*32) / (7 * 1048576)","v":{"v":3.4371512276785716,"d":"3.437151"}}]
[{"$nulls":8},"monthly",{"v":4.3201571497645e-07,"d":"0.000%"},{"$f":" (270 * B7 * (1+C47)*32) / (30 * 1048576)","v":{"v":2.408203125,"d":"2.408203"}}]
[null,"Data Type","Related Retention Period","Option in CME",{"$nulls":3},"SQA Failure","Details",{"v":0.03651784296929698,"d":"3.652%"},{"$f":" (500 * B14 * (B20/100) * (1+C48)) / 1048576","v":{"v":203562.92724609375,"d":"203,562.927246"}},{"$f":" (K29 + K30 + K31 + K32 + K33) / 1024","v":{"v":198.83202271802085,"d":"198.832023"}}]
["CDR","CDR",30,"rs.db.retention.cdr.default",{"$nulls":4},"hourly",{"v":6.3067987587802921E-6,"d":"0.001%"},{"$f":" (200 * B7 * B4 * (C49+1) * 24*(3600/B22)) / 1048576","v":{"v":35.15625,"d":"35.156250"}}]
["Operational Reporting","OR (5 minutes)",1,"rs.db.retention.operations.5min.default",{"$nulls":4},"daily",{"v":7.4728995709506062E-7,"d":"0.000%"},{"$f":" (200 * B7 * B4 * (1+C50)) / 1048576","v":{"v":4.1656494140625,"d":"4.165649"}}]
[null,"OR (30 minutes)",7,"rs.db.retention.latencies.weekly.default",{"$nulls":4},"weekly",{"v":2.1233827666280371E-7,"d":"0.000%"},{"$f":" (200 * B7 * B4 * (1+C51)) / (7 * 1048576)","v":{"v":1.1836460658482142,"d":"1.183646"}}]
[null,"OR (hourly)",7,"rs.db.retention.operations.hourly.default",{"$nulls":4},"monthly",{"v":1.0018612611604109E-7,"d":"0.000%"},{"$f":" (200 * B7 * B4 * (1+C52)) / (30 * 1048576)","v":{"v":0.5584716796875,"d":"0.558472"}}]
[null,"OR (daily)",90,"rs.db.retention.operations.daily.default",null,null,"CCP","CDR","CDR",{"v":0,"d":"0.000%"},{"$f":" (1850+(660*B24)) * B23 * (1+C30) / 1048576","v":{"v":0,"d":"0.000000"}},{"$f":" K34 / 1024","v":{"v":0,"d":"0.000000"}},{"$f":" L34 + L35 + L41","v":{"v":0,"d":"0.000000"}}]
[null,"OR (weekly)",364,"rs.db.retention.operations.weekly.default",{"$nulls":3},"Operational Reporting","OR (5 minutes)",{"v":0,"d":"0.000%"},{"$f":" (300 * (B4 +1) * B8 * 1440 * (1+C31) + 300 * B8 *1440 * (C31+1)) / 1048576","v":{"v":0,"d":"0.000000"}},{"$f":" (K35 + K36 + K37 + K38 + K39 + K40) / 1024","v":{"v":0,"d":"0.000000"}}]
[null,"OR (monthly)",1095,"rs.db.retention.operations.monthly.default",{"$nulls":4},"OR (30 minutes)",{"v":0,"d":"0.000%"},{"$f":" ((300 * (B4 + 1) * B8 * 48 * (1+C32)) + ( 300 * B8 * 48 * (1+C32))) / 1048576","v":{"v":0,"d":"0.000000"}}]
["VAR","OR (5 minutes)",1,"rs.db.retention.var.5min.default",{"$nulls":4},"OR (hourly)",{"v":0,"d":"0.000%"},{"$f":" ((300 * (B4 + 1) * B8 * 24 * (1+C33)) + ( 300 * B8 * 24 * (1+C33))) / 1048576","v":{"v":0,"d":"0.000000"}}]
[null,"OR (30 minutes)",7,"rs.db.retention.var.30min.default",{"$nulls":4},"OR (daily)",{"v":0,"d":"0.000%"},{"$f":" ((300 * (B4 + 1) * B8 * (1+C34)) + ( 300 * B8 *  (1+C34))) / 1048576","v":{"v":0,"d":"0.000000"}}]
[null,"OR (hourly)",7,"rs.db.retention.var.hourly.default",{"$nulls":4},"OR (weekly)",{"v":0,"d":"0.000%"},{"$f":" (((300 * (B4 + 1) * B8  * (1+C35)) / 7)+ (( 300 * B8  * (1+C35)) / 7)) / 1048576","v":{"v":0,"d":"0.000000"}}]
[null,"OR (daily)",90,"rs.db.retention.var.daily.default",{"$nulls":4},"OR (monthly)",{"v":0,"d":"0.000%"},{"$f":" (((300 * (B4 + 1) * B8 * (1+C36)) / 30)+ (( 300 * B8 * (1+C36)) / 30)) / 1048576","v":{"v":0,"d":"0.000000"}}]
[null,"OR (weekly)",364,"rs.db.retention.var.monthly.default",{"$nulls":3},"Events","Events",{"v":0,"d":"0.000%"},{"$f":" (500 * B25 * B23 * (1+C43)) / 1048576","v":{"v":0,"d":"0.000000"}},{"$f":" K41 / 1024","v":{"v":0,"d":"0.000000"}}]
[null,"OR (monthly)",1095,"rs.db.retention.var.monthly.default",null,null,"TTS/ASR","Operational Reporting","OR (5 minutes)",{"v":1.0642722905441743E-5,"d":"0.001%"},{"$f":" 300 *($B$4 + $B$5 + $B$11)  * 2 * 1440 * ($C31+1) / 1048576","v":{"v":59.326171875,"d":"59.326172"}},{"$f":" (K42 + K43 + K44 + K45 + K46 + K47) / 1024","v":{"v":0.07313732589994158,"d":"0.073137"}},{"$f":"L42","v":{"v":0.07313732589994158,"d":"0.073137"}}]
["Events","Events",7,"rs.db.retention.events.default",{"$nulls":4},"OR (30 minutes)",{"v":1.4190297207255656E-6,"d":"0.000%"},{"$f":" 300 *($B$4 + $B$5 + $B$11)  * 2 * 48 * ($C32+1) / 1048576","v":{"v":7.91015625,"d":"7.910156"}}]
["SQA Latency","hourly",7,"rs.db.retention.latencies.hourly.default",{"$nulls":4},"OR (hourly)",{"v":7.0951486036278279E-7,"d":"0.000%"},{"$f":" 300 *($B$4 + $B$5 + $B$11)  * 2 * 24 * ($C33+1) / 1048576","v":{"v":3.955078125,"d":"3.955078"}}]
[null,"daily",90,"rs.db.retention.latencies.daily.default",{"$nulls":4},"OR (daily)",{"v":3.3628048069277727E-7,"d":"0.000%"},{"$f":" 300 *($B$4 + $B$5 + $B$11)  * 2 * ($C34+1) / 1048576","v":{"v":1.874542236328125,"d":"1.874542"}}]
[null,"weekly",364,"rs.db.retention.latencies.weekly.default",{"$nulls":4},"OR (weekly)",{"v":1.9268818752411884E-7,"d":"0.000%"},{"$f":" 300 *($B$4 + $B$5 + $B$11)  * 2 * ($C35+1) / (7*1048576)","v":{"v":1.0741097586495536,"d":"1.074110"}}]
[null,"monthly",1095,"rs.db.retention.latencies.monthly.default",{"$nulls":4},"OR (monthly)",{"v":1.3500491093014062E-7,"d":"0.000%"},{"$f":" 300 *($B$4 + $B$5 + $B$11)  * 2 * ($C36+1) / (30*1048576)","v":{"v":0.7525634765625,"d":"0.752563"}}]
["SQA Failure","Details",365,"rs.db.retention.sq.failures.default",{"$nulls":9},"For Oracle 11g - Partitioning Mode - RS 814 - Only RS' Tablespace Size Estimation - Oracle System / log files not included."]
[null,"hourly",7,"rs.db.retention.sq.hourly.default"]
[null,"daily",90,"rs.db.retention.sq.daily.default"]
[null,"weekly",180,"rs.db.retention.sq.weekly.default"]
[null,"monthly",365,"rs.db.retention.sq.monthly.default"]
["For Oracle 11g - Partitioning Mode - RS 814 - Only RS' Tablespace Size Estimation - Oracle System / log files not included."]

{"sheet":"ICON","index":7,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[3,1,3,4],[6,1,6,5]]}
["Interaction Concentrator Database Size Estimator"]
[]
["This Database Size Estimator requires a separate spreadsheet. Download the spreadsheet using the link provided below."]
[null,"ICON 8.1 Database Size Estimator"]
[]
["Note: The estimator can also be accessed from the Interaction Concentrator documentation landing page using the link provided below."]
[null,"https://docs.genesys.com/Documentation/ICON"]

{"sheet":"iWD Sizing Calculator","index":8,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[12,1,12,2],[15,4,15,5],[21,3,21,4]]}
["iWD 8.0 with MS SQL Server"]
[]
["System Profile","Number",null,"H/W Configuration","Number"]
["Task expiration period (days)",30,{"$f":"IF(B4 < 1,\"< 1 ERROR\", \"\")","v":""},"CPU clock (GHz)",{"v":2.8,"d":"3"}]
["iWD Data Mart DB retention period (days)",365,{"$f":"IF(B5 < 1,\"< 1 ERROR\", \"\")","v":""},"CPU core number",4]
["Incoming task rate (per day)",{"v":200000,"d":"200,000"},{"$f":"IF(B6 < B8,TEXT(B8,\"<  0.00\"), \"\")","v":""},"Memory (MB)",{"v":4000,"d":"4,000"}]
["Average re-prioritization period (hours)",{"v":0.7,"d":"1"},{"$f":"IF(B7 < 0.1,\"<  0.1 ERROR\", \"\")","v":""}]
["Maximum incoming task rate (per second)",30,{"$f":"IF(B8 < B6/24/3600,TEXT(B6/24/3600,\"<  0.00\"), \"\")","v":""}]
["Average number of tasks in backlog",{"v":40000,"d":"40,000"},{"$f":"IF(B9 < 1,\"< 1 ERROR\", \"\")","v":""}]
["Number of agents",{"v":2000,"d":"2,000"},{"$f":"IF(B10 < 1,\"< 1 ERROR\", \"\")","v":""}]
["Attached data size (KB) ( > 1 )",4,{"$f":"IF(B11 < 1,\"< 1 ERROR\", \"\")","v":""}]
[]
["Estimated Effective Task Rate (tasks/sec)","Databse Configuration"]
[{"$f":" (B8 + (B9/B7/3600 ))*(1+0.061*(B11-1))","v":{"v":54.26777777777778,"d":"54.27"}},{"$f":"IF(A14 < 20,\"All in One\",\"Separate Host per DB\")","v":"Separate Host per DB"},{"$f":"IF(A14 >45,\" IxN DB on RAID\",\"\")","v":" IxN DB on RAID"}]
[]
[null,"Database File Size (GB)"]
["Database Name","MS SQL "]
["Interaction Server database",{"$f":"((C34 +(B11-B41))*(B9 + B4*B6)/1024)/1024","v":{"v":236.18730036417642,"d":"236.19"}}]
["Interaction Server Event Log database",{"$f":"((C35+(B11-B41))*(B9+B4*B6)/1024)/1024","v":{"v":255.77616874694823,"d":"255.78"}}]
["iWD Data Mart database",{"$f":"(C36*(B5*B6)/1024)/1024","v":{"v":29.674072265625,"d":"29.67"}}]
[]
[{"$nulls":3},"H/W checks: all must be PASS"]
["Application","CPU Usage %","Maximum CPU Usage %","CPU Check","Memory Check"]
["Interaction Server",{"$f":"(B46 + (C46 *(A14+(B9/B7/3600 )))+(D46 *B9)+(F46 *B10))*(B42/E4)","v":{"v":97.17221587301587,"d":"97.17"}},{"$f":"E5*80 - ( B28 + B29)","v":{"v":301.1717293650794,"d":"301"}},{"$f":"IF(B24 < C24,\"PASS\", \"FAILED\")","v":"PASS"},{"$f":"IF((580+ 200 + 180 + 1200)<( E6 * 0.8),\"PASS\", \"FAILED\")","v":"PASS"}]
["iWD Runtime Node",{"$f":"(B47 + (C47 *(A14+(B9/B7/3600 )))+(D47 *B9)+(F47 *B10))*(B42/E4)","v":{"v":50.17773968253969,"d":"50.18"}},{"$f":"E5*80","v":320},"PASS",{"$f":"IF(3000 < E6*0.8,\"PASS\", \"FAILED\")","v":"PASS"}]
["iWD DataMart Node MAX",{"$f":"(B48 + (C48 *(A14+(B9/B7/3600 )))+(D48 *B9)+(F48 *B10))*(B42/E4)","v":{"v":299.003146031746,"d":"299.00"}},{"$f":"E5*80","v":320},"PASS",{"$f":"IF(3100 < (E6*0.8),\"PASS\", \"FAILED\")","v":"PASS"}]
["MS SQL Server",{"$f":"(B49 + (C49 *(A14+(B9/B7/3600 )))+(D49 *B9)+(F49 *B10))*(B42/E4)","v":{"v":90.04680793650795,"d":"90.05"}},{"$f":"E5*80","v":320},"PASS",{"$f":"IF(3199 < (E6*0.8),\"PASS\", \"FAILED\")","v":"PASS"}]
["Universal Routing Server ",{"$f":"(B50 + (C50 *(A14+(B9/B7/3600 )))+(D50 *B9)+(F50 *B10))*(B42/E4)","v":{"v":14.354920476190475,"d":"14.35"}},80,"PASS",{"$f":"IF((580+ 200 + 180 + 1200)<( E6 * 0.8),\"PASS\", \"FAILED\")","v":"PASS"}]
["Stat Server",{"$f":"(B51 + (C51 *(A14+(B9/B7/3600 )))+(D51 *B9)+(F51 *B10))*(B42/E4)","v":{"v":4.473350158730159,"d":"4.47"}},80,"PASS",{"$f":"IF((580+ 200 + 180 + 1200)<( E6 * 0.8),\"PASS\", \"FAILED\")","v":"PASS"}]
[]
[]
[]
["database_name","databse_file_size KB","KB per task"]
["ixn_db",1140101,{"$f":"B34/B40","v":38.003366666666665}]
["ixn_eventlog_db",41404098,{"$f":"B35/B39","v":41.404098}]
["iwddatamart_2",426240,{"$f":"B36/B39","v":0.42624}]
[]
["System test metrics"]
["Total tasks processed",1000000]
["Tasks Number in queues",30000]
["Attached Data Size (KB)",1]
["Host CPU GHz",2.8]
[]
[]
["Application","CPU0","K1","K2",null,"K3"]
["Interaction server",1.1,1.28,{"v":2.23E-5,"d":"2.23E-05"},null,{"v":0.0027,"d":"2.70E-03"}]
["iWD running node",0.87,0.68,{"v":4.03e-05,"d":"4.03E-05"},null,0]
["iWD DataMart node MAX",53,3.46,{"v":1.19E-5,"d":"1.19E-05"},null,{"v":1.42E-3,"d":"1.42E-03"}]
["SQL server",0.5,1.27,{"v":1.17E-5,"d":"1.17E-05"},null,{"v":0,"d":"0.00E+00"}]
["URS ",0,0.177,{"v":4.85E-5,"d":"4.85E-05"},null,{"v":0,"d":"0.00E+00"}]
["Stat Server",0.1,0.038,{"v":4.27e-05,"d":"4.27E-05"},null,{"v":0,"d":"0.00E+00"}]

{"sheet":"LRM","index":9,"n_rows":20,"n_cols":3,"rows_kept":20,"merged":[[18,0,18,2],[19,0,19,2]]}
[]
["License Reporting Manager:   LRM Sizing Recommendations "]
[]
["LRM does not require complex sizing calculations.  The table below from the Hardware Sizing Guide is included here for spreadsheet user convenience.  "]
[]
[null,"Medium Contact Centre","Large Contact Centre"]
["Total agents",1000,{"v":21000,"d":"21,000"}]
["Total shifts",2,3]
["Agents/shift ",500,700]
["Logins/day",1000,{"v":21000,"d":"21,000"}]
["Products","CIM","CIM"]
["Minimum recommended free disk space for LRM DB","10GB","20GB"]
["Disk space recommended for LRM DB to keep >13 months of reporting data","Approximately 20 GB, depending upon number of tenants, agents, places, tenants, sellable items, bundles","Approximately 40 GB, depending upon number of tenants, agents, places, tenants, sellable items, bundles"]
["Minimum recommended CPU 1 Intel CPU 2.6 GHz"," 1 Intel CPU 2.6 GHz core 2 duo"," 2 Intel CPU 2.6 GHz core 2 duo"]
["Minimum recommended Memory ","4GB","8GB *"]
["Dedicated server requirement ","No","Yes"]
["VM info/recommendations ","VMs are acceptable if they have similar CPU, memory, and disk resources","VMs are acceptable if they have similar CPU, memory, and disk resources"]
[]
["For a large contact center, if the system has more than 50,000 agents, LRM requires additional Java Heap space to load the agent information from the Configuration Server.   See the License Reporting Manager 8.1 Deployment Guide for details.\n"]
["*  If the number of agents exceeds 100,000 agents, Genesys recommends that LRM is deployed on\na host or Virtual Machine with a minimum of 8 GB RAM."]

{"sheet":"Multimedia","index":10,"n_rows":14,"n_cols":3,"rows_kept":14}
["Multimedia 8.0"," "]
["Use this spreadsheet to estimate the size of the  Multimedia Database for your environment. Some examples are provided.                                    1.  Change the values in the number column for your environment.                                                                                                   2. Your estimated database sizes appear in the last rows."]
[]
[]
["Entry","Number"]
["Email Interactions Per Day",100]
["Chat Interactions Per Day",{"v":1000,"d":"1,000"}]
["Attached Data, in Kbytes",16," Recommended limit - 16 Kb"]
["Contacts",{"v":100000,"d":"100,000"}]
["Active Interactions maximum number",{"v":10000,"d":"10,000"}]
["UCS Database Lifetime (Days)",90]
["Estimations"]
["UCS DB Size (MB)",{"$f":"((B6*1024*25 + B7*1024*5)*B11 + B9*1024)/(1024*1024)","v":{"v":756.8359375,"d":"756.84"}}]
["Interaction Server DB Size (MB)",{"$f":"(3.5+B8)*1024*B10/(1024*1024)","v":{"v":190.4296875,"d":"190.43"}}]

{"sheet":"OCS","index":11,"n_rows":36,"n_cols":4,"rows_kept":36,"merged":[[5,0,5,1]]}
["Outbound Contact 8.0"]
["Use this spreadsheet to estimate the size of the Outbound Contact Database for your environment. Some examples are provided.                                                                1.  Change the values for your environment.                                                                                                                                   2. Your estimated database sizes appear in the last rows.\nNote:  This spread sheet supports up to 8 calling lists.  For more than 8 calling lists, use the following formula for estimated database sizing.",null,null," "]
[]
["Formula: "]
[]
["M  - number of calling lists,\nNi – number of records in the calling list i,\nLi – length of record for calling list i.\nsi – coefficient for index space.\nExample:  OCS uses two calling lists: List 1 contains 100000 records with record size 600 bytes and List 2 contains 50000 records with record size 450 bytes. Indexes occupy one-third of table space. Estimated database size will be: \n1.33 * (100000*600 + 50000*450) / (1024*1024) = 104.6 MB\n"]
[]
["Entry","Number"]
["Coefficient for index space (si)",1.33]
["Number of calling lists (M)",6,{"$f":"IF(B10>8,\"Error:  This spread sheet supports only upto eight calling lists.\",\"\")","v":""}]
[]
["Number of records in the calling list-1",{"v":100000,"d":"100,000"}]
["Length of record for calling list-1 (Bytes)",600]
[]
["Number of records in the calling list-2",{"v":50000,"d":"50,000"}]
["Length of record for calling list-2 (Bytes)",450]
[]
["Number of records in the calling list-3"]
["Length of record for calling list-3 (Bytes)"]
[]
["Number of records in the calling list-4"]
["Length of record for calling list-4 (Bytes)"]
[]
["Number of records in the calling list-5"]
["Length of record for calling list-5 (Bytes)"]
[]
["Number of records in the calling list-6"]
["Length of record for calling list-6 (Bytes)"]
[]
["Number of records in the calling list-7"]
["Length of record for calling list-7 (Bytes)"]
[]
["Number of records in the calling list-8"]
["Length of record for calling list-8 (Bytes)"]
[]
["OCS DB Size (MB)",{"$f":"B9*((B12*B13)+(B15*B16)+(B18*B19)+(B21*B22)+(B24*B25)+(B27*B28)+(B30*B31)+(B33*B34))/(1024*1024)","v":{"v":104.64191436767578,"d":"104.64"}}]

{"sheet":"WFM Oracle","index":12,"n_rows":58,"n_cols":5,"rows_kept":58}
["Workforce Management 8.0 with Oracle"]
[]
["Contact Center Configuration","Number"]
["Type of the Database Server:","Oracle"]
["Number of Sites:",3,"<--","Please enter the estimated number of Sites","nSites"]
["Number of Activities and Multi-Site Activities:",100,"<--","Please enter the estimated number of Activities","nActivities"]
["Number of Agents:",{"v":3000,"d":"3,000"},"<--","Please enter the estimated number of Agents","nAgents"]
["Number of Teams:",300,"<--","Please enter the estimated number of Teams","nTeams"]
["Number of Schedule Trades per Agent per Year:",15,"<--","Please enter the estimated number of Trading Transactions per Agent per Year","nTrading"]
["Number of Scenarios per Year for Same Activities:",5,"<--","Please enter the estimated number of Scenarios for Same Activities per Year","nScenarios"]
["Number of Days per Scenario:",30,"<--","Please enter the estimated number of Days in each Scenario","nDays"]
["Number of Factors:",15,"<--","Please enter the estimated number of Factors","nFactors"]
["Number of Events per Factor:",2,"<--","Please enter the estimated number of Events per Factor","nFactorEvents"]
["Number of Forecast Override Templates:",25,"<--","Please enter the estimated number of Forecast Override Templates","nTemp"]
["Number of Days per Override Template:",30,"<--","Please enter the estimated number of Days per Override Template","nTempDays"]
["Number of Forecast non-Override (weekly) Templates:",25,"<--","Please enter the estimated number of non-Override Templates","nTempWeekly"]
["Number of Calendar Items changes per Day:",10,"<--","Please enter the estimated number of Calendar changes per Day","nCalChanges"]
["Number of changed Calendar Items per transaction:",10,"<--","Please enter the estimated number of changed Calendar Items per each change","nCalItems"]
["Number of Calendar Items per Agent per Year:",10,"<--","Please enter the estimated number of Calendar Items per Agent per Year","nCalendar"]
[{"$nulls":3},"(count Vacations, Sick Days, Exceptions, Day Offs, etc.) "]
["Number of manual schedule changes per Agent per Year:",33,"<--","Please enter the estimated number of schedule changes for one Agent per Year","nSchChanges"]
["Polling Timer:",{"$f":"365*24*60","v":525600},"<--","Please enter the number of times WFM Daemon will ask WFM Server for updates per Year.","nPollingTimer"]
[{"$nulls":3},"Default setting is 1 minute = 365 * 24 * 60. Enter 0 if you will not use WFM Daemon."]
["Audit type:","Low","<--","Please select between Low and High Audit Level. Possible values are: Low or High.","nAuditLevel"]
[]
["Formulas used in calculations","Bytes","GB","Brief Explanations"]
["Configuration:",{"$f":"(B6*89026.65+B7*4572.2)*17.7","v":{"v":400360990.5,"d":"400,360,991"}},{"$f":"B27/1024/1024/1024","v":{"v":0.37286522844806314,"d":"0.37"}},"(nActivities * RecordSize + nAgents * RecordSize) * CONSTANT(17.70)"]
[{"$nulls":3},"By multiplying the sizes of Activities and Agents tables by this Constant you get the exact size of all the Configuration subsystem. \nThe constant is the average value calculated from many Customer databases on Oracle Server."]
["Agent Real Time:",{"$f":"365*B7*705.73","v":{"v":772774350,"d":"772,774,350"}},{"$f":"B29/1024/1024/1024","v":{"v":0.7197021972388029,"d":"0.72"}},"365 days * nAgents * RecordSize"]
["Trading:",{"$f":"B7*(B9*398.8+B9*2*418.1+B9*2*391.33)","v":{"v":90794700,"d":"90,794,700"}},{"v":0.08455915376543999,"d":"0.08"},"nAgents * (nTrading * RecordSize1 + nTrading * 2 * RecordSize2 + nTrading * 2 * RecordSize3)"]
["Calendar:",{"$f":"B7*B19*158.61","v":{"v":4758300,"d":"4,758,300"}},{"v":0.004431512206792831,"d":"0.00"},"nAgents * nCalendar * RecordSize"]
["Performance Act:",{"$f":"365*96*B6*151.48","v":{"v":530785919.99999994,"d":"530,785,920"}},{"v":0.49433290958404535,"d":"0.49"},"365 days * 96 timesteps * nActivities * RecordSize"]
["Performance Team:",{"$f":"365*96*B8*124.86","v":{"v":1312528320,"d":"1,312,528,320"}},{"v":1.2223872542381287,"d":"1.22"},"365 days * 96 timesteps * nTeams * RecordSize"]
["Performance Act/Team:",{"$f":"365*96*B8*121.65","v":{"v":1278784800,"d":"1,278,784,800"}},{"v":1.1909611523151398,"d":"1.19"},"365 days * 96 timesteps * nTeams * RecordSize"]
["Performance Alerts:",{"$f":"10*329502.24","v":{"v":3295022.4,"d":"3,295,022"}},{"v":3.068728744983673E-3,"d":"0.00"},"CONSTANT (Average number of Alerts per Year = 10) * RecordSize"]
["Schedule Master:",{"$f":"B7*365*381.15","v":{"v":417359250,"d":"417,359,250"}},{"v":0.38869609124958515,"d":"0.39"},"nAgents * 365 * RecordSize"]
["Schedule Scenario:",{"$f":"B7*365*381.15","v":{"v":417359250,"d":"417,359,250"}},{"v":0.38869609124958515,"d":"0.39"},"nAgents * 365 * RecordSize"]
["Baseline Schedule:",{"$f":"B7*365*381.15*0.1","v":{"v":41735925,"d":"41,735,925"}},{"v":0.038869609124958515,"d":"0.04"},"nAgents * 365 * 10% * RecordSize"]
["Calendar Audit:",{"$f":"365 * B17*B18*943","v":{"v":34419500,"d":"34,419,500"}},{"v":0.03205565735697746,"d":"0.03"},"365 days * nCalChanges * nCalItems * RecordSize"]
["Trade Audit:",{"$f":"B7*237.9*(B9+B9*2+B9*2)*2","v":{"v":107055000,"d":"107,055,000"}},{"v":0.09970273822546005,"d":"0.10"},"nAgents * RecordSize * (nTrading + nTrading * 2 + nTrading * 2 ) * 2"]
["Schedule audit:",{"$f":"B7*B21*(403.36+IF(B24=\"Low\", 0, 381.15)+276.04)+B7*365*(276.04+IF(B24=\"Low\", 0, 381.15)+111.71)","v":{"v":491846850,"d":"491,846,850"}},{"v":0.45806807465851307,"d":"0.46"},"nAgents*nSchChanges*RecordSize1 + nAgents*365*RecordSize2"]
["Trading acknowledgements:",{"$f":"B22*B5*335.66","v":{"v":529268688.00000006,"d":"529,268,688"}},{"v":0.4929198771715165,"d":"0.49"},"nPollingTimer * nSites * RecordSize"]
["Schedule acknowledgements:",{"$f":"B22*B5*283.84","v":{"v":447558911.99999994,"d":"447,558,912"}},{"v":0.4168217182159423,"d":"0.42"},"nPollingTimer * nSites * RecordSize"]
["Calendar acknowledgements:",{"$f":"B22*B5*98.04","v":{"v":154589472,"d":"154,589,472"}},{"v":0.14397266507148743,"d":"0.14"},"nPollingTimer * nSites * RecordSize"]
["Forecast:",{"$f":"B10*2*B11*4055.04","v":{"v":1216512,"d":"1,216,512"}},{"v":1.132965087890625E-3,"d":"0.00"},"nScenarios * 2 * nDays * nActivities * RecordSize"]
["Forecast Events:",{"$f":"B12*B13*2*2115.23","v":{"v":126913.8,"d":"126,914"}},{"v":1.1819768697023392E-4,"d":"0.00"},"nFactors * nFactorEvents * 2 * RecordSize"]
["Forecast Override Templates:",{"$f":"B14*96*B15*303.4","v":{"v":21844800,"d":"21,844,800"}},{"v":0.020344555377960205,"d":"0.02"},"nTemp * 96 * nTempDays * RecordSize"]
["Forecast Weekly Templates:",{"$f":"B15*96*7*303.4","v":{"v":6116544,"d":"6,116,544"}},{"v":0.005696475505828857,"d":"0.01"},"nTempWeekly * 96 * 7 * RecordSize"]
["Forecast Params:",{"$f":"B6*B10*3221.13","v":{"v":1610565,"d":"1,610,565"}},{"v":1.4999555423855782E-3,"d":"0.00"},"nActivities * nScenarios * RecordSize"]
[]
["Annual WFM Database size","Bytes","GB"]
["DB Size Year 1:",{"$f":"SUM(B27:B49)","v":{"v":7066190584.7,"d":"7,066,190,585"}},{"$f":"B52/1024/1024/1024","v":{"v":6.580902808066457,"d":"6.58"}}]
["DB Size Year 2:",{"$f":"B52*2","v":{"v":14132381169.4,"d":"14,132,381,169"}},{"$f":"B53/1024/1024/1024","v":{"v":13.161805616132915,"d":"13.16"}}]
["DB Size Year 3:",{"$f":"B52*3","v":{"v":21198571754.1,"d":"21,198,571,754"}},{"$f":"B54/1024/1024/1024","v":{"v":19.74270842419937,"d":"19.74"}}]
["DB Size Year 4:",{"$f":"B52*4","v":{"v":28264762338.8,"d":"28,264,762,339"}},{"$f":"B55/1024/1024/1024","v":{"v":26.32361123226583,"d":"26.32"}}]
[]
[]
[null,null,"Notes:","RecordSize for each subsystem is calculated using customer databases with real data on Oracle 10g."]

{"sheet":"WFM MSSQL","index":13,"n_rows":58,"n_cols":5,"rows_kept":58}
["Workforce Management 8.0 with Microsoft SQL Server"]
[]
["Contact Center Configuration","Number"]
["Type of the Database Server:","MSSQL"]
["Number of Sites:",3,"<--","Please enter the estimated number of Sites","nSites"]
["Number of Activities and Multi-Site Activities:",100,"<--","Please enter the estimated number of Activities","nActivities"]
["Number of Agents:",{"v":3000,"d":"3,000"},"<--","Please enter the estimated number of Agents","nAgents"]
["Number of Teams:",300,"<--","Please enter the estimated number of Teams","nTeams"]
["Number of Schedule Trades per Agent per Year:",15,"<--","Please enter the estimated number of Trading Transactions per Agent per Year","nTrading"]
["Number of Scenarios per Year for Same Activities:",5,"<--","Please enter the estimated number of Scenarios for Same Activities per Year","nScenarios"]
["Number of Days per Scenario:",30,"<--","Please enter the estimated number of Days in each Scenario","nDays"]
["Number of Factors:",15,"<--","Please enter the estimated number of Factors","nFactors"]
["Number of Events per Factor:",2,"<--","Please enter the estimated number of Events per Factor","nFactorEvents"]
["Number of Forecast Override Templates:",25,"<--","Please enter the estimated number of Forecast Override Templates","nTemp"]
["Number of Days per Override Template:",30,"<--","Please enter the estimated number of Days per Override Template","nTempDays"]
["Number of Forecast non-Override (weekly) Templates:",25,"<--","Please enter the estimated number of non-Override Templates","nTempWeekly"]
["Number of Calendar Items changes per Day:",10,"<--","Please enter the estimated number of Calendar changes per Day","nCalChanges"]
["Number of changed Calendar Items per transaction:",10,"<--","Please enter the estimated number of changed Calendar Items per each change","nCalItems"]
["Number of Calendar Items per Agent per Year:",10,"<--","Please enter the estimated number of Calendar Items per Agent per Year","nCalendar"]
[{"$nulls":3},"(count Vacations, Sick Days, Exceptions, Day Offs, etc.) "]
["Number of manual schedule changes per Agent per Year:",33,"<--","Please enter the estimated number of schedule changes for one Agent per Year","nSchChanges"]
["Polling Timer:",{"$f":"365*24*60","v":525600},"<--","Please enter the number of times WFM Daemon will ask WFM Server for updates per Year.","nPollingTimer"]
[{"$nulls":3},"Default setting is 1 minute = 365 * 24 * 60. Enter 0 if you will not use WFM Daemon."]
["Audit type:","Low","<--","Please select between Low and High Audit Level. Possible values are: Low or High.","nAuditLevel"]
[]
["Formulas used in calculations","Bytes","GB","Brief Explanations"]
["Configuration:",{"$f":"(B6*4082.25+B7*445.65)*9.37","v":{"v":16352289.749999998,"d":"16,352,290"}},{"$f":"B27/1024/1024/1024","v":{"v":0.015229256590828298,"d":"0.02"}},"(nActivities * RecordSize + nAgents * RecordSize) * CONSTANT(9.37)"]
[{"$nulls":3},"By multiplying the sizes of Activities and Agents tables by this Constant you get the exact size of all the Configuration subsystem. \nThe constant is the average value calculated from many Customer databases on MSSQL Server."]
["Agent Real Time:",{"$f":"365*B7*824.12","v":{"v":902411400,"d":"902,411,400"}},{"$f":"B29/1024/1024/1024","v":{"v":0.8404361084103584,"d":"0.84"}},"365 days * nAgents * RecordSize"]
["Trading:",{"$f":"B7*(B9*1012.49+B9*2*577.64+B9*2*615.94)","v":{"v":152984250,"d":"152,984,250"}},{"v":0.14247768558561802,"d":"0.14"},"nAgents * (nTrading * RecordSize1 + nTrading * 2 * RecordSize2 + nTrading * 2 * RecordSize3)"]
["Calendar:",{"$f":"B7*B19*192.05","v":{"v":5761500,"d":"5,761,500"}},{"v":5.3658150136470795E-3,"d":"0.01"},"nAgents * nCalendar * RecordSize"]
["Performance Act:",{"$f":"365*96*B6*180.25","v":{"v":631596000,"d":"631,596,000"}},{"v":0.5882196128368378,"d":"0.59"},"365 days * 96 timesteps * nActivities * RecordSize"]
["Performance Team:",{"$f":"365*96*B8*161.7","v":{"v":1699790399.9999998,"d":"1,699,790,400"}},{"v":1.5830531716346739,"d":"1.58"},"365 days * 96 timesteps * nTeams * RecordSize"]
["Performance Act/Team:",{"$f":"365*96*B8*153.45","v":{"v":1613066399.9999998,"d":"1,613,066,400"}},{"v":1.502285152673721,"d":"1.50"},"365 days * 96 timesteps * nTeams * RecordSize"]
["Performance Alerts:",{"$f":"10*22391.47","v":{"v":223914.7,"d":"223,915"}},{"v":2.085368148982525E-4,"d":"0.00"},"CONSTANT (Average number of Alerts per Year = 10) * RecordSize"]
["Schedule Master:",{"$f":"B7*365*520","v":{"v":569400000,"d":"569,400,000"}},{"v":0.5302950739860535,"d":"0.53"},"nAgents * 365 * RecordSize"]
["Schedule Scenario:",{"$f":"B7*365*520","v":{"v":569400000,"d":"569,400,000"}},{"v":0.5302950739860535,"d":"0.53"},"nAgents * 365 * RecordSize"]
["Baseline Schedule:",{"$f":"B7*365*520*0.1","v":{"v":56940000,"d":"56,940,000"}},{"v":0.05302950739860535,"d":"0.05"},"nAgents * 365 * 10% * RecordSize"]
["Calendar Audit:",{"$f":"365 * B17*B18*495.23","v":{"v":18075895,"d":"18,075,895"}},{"v":0.016834489069879055,"d":"0.02"},"365 days * nCalChanges * nCalItems * RecordSize"]
["Trade Audit:",{"$f":"B7*99.45*(B9+B9*2+B9*2)*2","v":{"v":44752500,"d":"44,752,500"}},{"v":0.0416790135204792,"d":"0.04"},"nAgents * RecordSize * (nTrading + nTrading * 2 + nTrading * 2 ) * 2"]
["Schedule audit:",{"$f":"B7*B21*(145.29+IF(B24=\"Low\", 0, 520)+118.67)+B7*365*(118.67+IF(B24=\"Low\", 0, 520)+84.78)","v":{"v":248909790,"d":"248,909,790"}},{"v":0.2318153064697981,"d":"0.23"},"nAgents*nSchChanges*RecordSize1 + nAgents*365*RecordSize2"]
["Trading acknowledgements:",{"$f":"B22*B5*82.9","v":{"v":130716720.00000001,"d":"130,716,720"}},{"v":0.12173943221569063,"d":"0.12"},"nPollingTimer * nSites * RecordSize"]
["Schedule acknowledgements:",{"$f":"B22*B5*101.04","v":{"v":159319872,"d":"159,319,872"}},{"v":0.1483781933784485,"d":"0.15"},"nPollingTimer * nSites * RecordSize"]
["Calendar acknowledgements:",{"$f":"B22*B5*98.04","v":{"v":154589472,"d":"154,589,472"}},{"v":0.14397266507148743,"d":"0.14"},"nPollingTimer * nSites * RecordSize"]
["Forecast:",{"$f":"B10*2*B11*925.89","v":{"v":277767,"d":"277,767"}},{"v":2.5869067758321762E-4,"d":"0.00"},"nScenarios * 2 * nDays * nActivities * RecordSize"]
["Forecast Events:",{"$f":"B12*B13*2*2115.23","v":{"v":126913.8,"d":"126,914"}},{"v":1.1819768697023392E-4,"d":"0.00"},"nFactors * nFactorEvents * 2 * RecordSize"]
["Forecast Override Templates:",{"$f":"B14*96*B15*78.35","v":{"v":5641200,"d":"5,641,200"}},{"v":0.005253776907920837,"d":"0.01"},"nTemp * 96 * nTempDays * RecordSize"]
["Forecast Weekly Templates:",{"$f":"B15*96*7*78.35","v":{"v":1579536,"d":"1,579,536"}},{"v":1.4710575342178345E-3,"d":"0.00"},"nTempWeekly * 96 * 7 * RecordSize"]
["Forecast Params:",{"$f":"B6*B10*96.57","v":{"v":48285,"d":"48,285"}},{"v":4.496891051530838E-5,"d":"0.00"},"nActivities * nScenarios * RecordSize"]
[]
["Annual WFM Database size","Bytes","GB"]
["DB Size Year 1:",{"$f":"SUM(B27:B49)","v":{"v":6981964105.25,"d":"6,981,964,105"}},{"$f":"B52/1024/1024/1024","v":{"v":6.502460786374286,"d":"6.50"}}]
["DB Size Year 2:",{"$f":"B52*2","v":{"v":13963928210.5,"d":"13,963,928,211"}},{"$f":"B53/1024/1024/1024","v":{"v":13.004921572748572,"d":"13.00"}}]
["DB Size Year 3:",{"$f":"B52*3","v":{"v":20945892315.75,"d":"20,945,892,316"}},{"$f":"B54/1024/1024/1024","v":{"v":19.507382359122857,"d":"19.51"}}]
["DB Size Year 4:",{"$f":"B52*4","v":{"v":27927856421,"d":"27,927,856,421"}},{"$f":"B55/1024/1024/1024","v":{"v":26.009843145497143,"d":"26.01"}}]
[]
[]
[null,null,"Notes:","RecordSize for each subsystem is calculated using customer databases with real data on MSSQL Server 2000."]

{"sheet":"WFM DB2","index":14,"n_rows":58,"n_cols":5,"rows_kept":58}
["Workforce Management 8.0 with DB2"]
[]
["Contact Center Configuration","Number"]
["Type of the Database Server:","DB2"]
["Number of Sites:",3,"<--","Please enter the estimated number of Sites","nSites"]
["Number of Activities and Multi-Site Activities:",100,"<--","Please enter the estimated number of Activities","nActivities"]
["Number of Agents:",{"v":3000,"d":"3,000"},"<--","Please enter the estimated number of Agents","nAgents"]
["Number of Teams:",300,"<--","Please enter the estimated number of Teams","nTeams"]
["Number of Schedule Trades per Agent per Year:",15,"<--","Please enter the estimated number of Trading Transactions per Agent per Year","nTrading"]
["Number of Scenarios per Year for Same Activities:",5,"<--","Please enter the estimated number of Scenarios for Same Activities per Year","nScenarios"]
["Number of Days per Scenario:",30,"<--","Please enter the estimated number of Days in each Scenario","nDays"]
["Number of Factors:",15,"<--","Please enter the estimated number of Factors","nFactors"]
["Number of Events per Factor:",2,"<--","Please enter the estimated number of Events per Factor","nFactorEvents"]
["Number of Forecast Override Templates:",25,"<--","Please enter the estimated number of Forecast Override Templates","nTemp"]
["Number of Days per Override Template:",30,"<--","Please enter the estimated number of Days per Override Template","nTempDays"]
["Number of Forecast non-Override (weekly) Templates:",25,"<--","Please enter the estimated number of non-Override Templates","nTempWeekly"]
["Number of Calendar Items changes per Day:",10,"<--","Please enter the estimated number of Calendar changes per Day","nCalChanges"]
["Number of changed Calendar Items per transaction:",10,"<--","Please enter the estimated number of changed Calendar Items per each change","nCalItems"]
["Number of Calendar Items per Agent per Year:",10,"<--","Please enter the estimated number of Calendar Items per Agent per Year","nCalendar"]
[{"$nulls":3},"(count Vacations, Sick Days, Exceptions, Day Offs, etc.) "]
["Number of manual schedule changes per Agent per Year:",33,"<--","Please enter the estimated number of schedule changes for one Agent per Year","nSchChanges"]
["Polling Timer:",{"$f":"365*24*60","v":525600},"<--","Please enter the number of times WFM Daemon will ask WFM Server for updates per Year.","nPollingTimer"]
[{"$nulls":3},"Default setting is 1 minute = 365 * 24 * 60. Enter 0 if you will not use WFM Daemon."]
["Audit type:","Low","<--","Please select between Low and High Audit Level. Possible values are: Low or High.","nAuditLevel"]
[]
["Formulas used in calculations","Bytes","GB","Brief Explanations"]
["Configuration:",{"$f":"(B6*4082.25+B7*445.65)*9.37","v":{"v":16352289.749999998,"d":"16,352,290"}},{"$f":"B27/1024/1024/1024","v":{"v":0.015229256590828298,"d":"0.02"}},"(nActivities * RecordSize + nAgents * RecordSize) * CONSTANT(9.37)"]
[{"$nulls":3},"By multiplying the sizes of Activities and Agents tables by this Constant you get the exact size of all the Configuration subsystem. \nThe constant is the average value calculated from many Customer databases on DB2 Server."]
["Agent Real Time:",{"$f":"365*B7*798","v":{"v":873810000,"d":"873,810,000"}},{"$f":"B29/1024/1024/1024","v":{"v":0.8137989789247513,"d":"0.81"}},"365 days * nAgents * RecordSize"]
["Trading:",{"$f":"B7*(B9*1012.49+B9*2*577.64+B9*2*615.94)","v":{"v":152984250,"d":"152,984,250"}},{"v":0.14247768558561802,"d":"0.14"},"nAgents * (nTrading * RecordSize1 + nTrading * 2 * RecordSize2 + nTrading * 2 * RecordSize3)"]
["Calendar:",{"$f":"B7*B19*192.05","v":{"v":5761500,"d":"5,761,500"}},{"v":5.3658150136470795E-3,"d":"0.01"},"nAgents * nCalendar * RecordSize"]
["Performance Act:",{"$f":"365*96*B6*180.25","v":{"v":631596000,"d":"631,596,000"}},{"v":0.5882196128368378,"d":"0.59"},"365 days * 96 timesteps * nActivities * RecordSize"]
["Performance Team:",{"$f":"365*96*B8*161.7","v":{"v":1699790399.9999998,"d":"1,699,790,400"}},{"v":1.5830531716346739,"d":"1.58"},"365 days * 96 timesteps * nTeams * RecordSize"]
["Performance Act/Team:",{"$f":"365*96*B8*153.45","v":{"v":1613066399.9999998,"d":"1,613,066,400"}},{"v":1.502285152673721,"d":"1.50"},"365 days * 96 timesteps * nTeams * RecordSize"]
["Performance Alerts:",{"$f":"10*22391.47","v":{"v":223914.7,"d":"223,915"}},{"v":2.085368148982525E-4,"d":"0.00"},"CONSTANT (Average number of Alerts per Year = 10) * RecordSize"]
["Schedule Master:",{"$f":"B7*365*520","v":{"v":569400000,"d":"569,400,000"}},{"v":0.5302950739860535,"d":"0.53"},"nAgents * 365 * RecordSize"]
["Schedule Scenario:",{"$f":"B7*365*520","v":{"v":569400000,"d":"569,400,000"}},{"v":0.5302950739860535,"d":"0.53"},"nAgents * 365 * RecordSize"]
["Baseline Schedule:",{"$f":"B7*365*520*0.1","v":{"v":56940000,"d":"56,940,000"}},{"v":0.05302950739860535,"d":"0.05"},"nAgents * 365 * 10% * RecordSize"]
["Calendar Audit:",{"$f":"365 * B17*B18*495.23","v":{"v":18075895,"d":"18,075,895"}},{"v":0.016834489069879055,"d":"0.02"},"365 days * nCalChanges * nCalItems * RecordSize"]
["Trade Audit:",{"$f":"B7*99.45*(B9+B9*2+B9*2)*2","v":{"v":44752500,"d":"44,752,500"}},{"v":0.0416790135204792,"d":"0.04"},"nAgents * RecordSize * (nTrading + nTrading * 2 + nTrading * 2 ) * 2"]
["Schedule audit:",{"$f":"B7*B21*(145.29+IF(B24=\"Low\", 0, 520)+118.67)+B7*365*(118.67+IF(B24=\"Low\", 0, 520)+84.78)","v":{"v":248909790,"d":"248,909,790"}},{"v":0.2318153064697981,"d":"0.23"},"nAgents*nSchChanges*RecordSize1 + nAgents*365*RecordSize2"]
["Trading acknowledgements:",{"$f":"B22*B5*82.9","v":{"v":130716720.00000001,"d":"130,716,720"}},{"v":0.12173943221569063,"d":"0.12"},"nPollingTimer * nSites * RecordSize"]
["Schedule acknowledgements:",{"$f":"B22*B5*101.04","v":{"v":159319872,"d":"159,319,872"}},{"v":0.1483781933784485,"d":"0.15"},"nPollingTimer * nSites * RecordSize"]
["Calendar acknowledgements:",{"$f":"B22*B5*98.04","v":{"v":154589472,"d":"154,589,472"}},{"v":0.14397266507148743,"d":"0.14"},"nPollingTimer * nSites * RecordSize"]
["Forecast:",{"$f":"B10*2*B11*925.89","v":{"v":277767,"d":"277,767"}},{"v":2.5869067758321762E-4,"d":"0.00"},"nScenarios * 2 * nDays * nActivities * RecordSize"]
["Forecast Events:",{"$f":"B12*B13*2*2115.23","v":{"v":126913.8,"d":"126,914"}},{"v":1.1819768697023392E-4,"d":"0.00"},"nFactors * nFactorEvents * 2 * RecordSize"]
["Forecast Override Templates:",{"$f":"B14*96*B15*78.35","v":{"v":5641200,"d":"5,641,200"}},{"v":0.005253776907920837,"d":"0.01"},"nTemp * 96 * nTempDays * RecordSize"]
["Forecast Weekly Templates:",{"$f":"B15*96*7*78.35","v":{"v":1579536,"d":"1,579,536"}},{"v":1.4710575342178345E-3,"d":"0.00"},"nTempWeekly * 96 * 7 * RecordSize"]
["Forecast Params:",{"$f":"B6*B10*96.57","v":{"v":48285,"d":"48,285"}},{"v":4.496891051530838E-5,"d":"0.00"},"nActivities * nScenarios * RecordSize"]
[]
["Annual WFM Database size","Bytes","GB"]
["DB Size Year 1:",{"$f":"SUM(B27:B49)","v":{"v":6953362705.25,"d":"6,953,362,705"}},{"$f":"B52/1024/1024/1024","v":{"v":6.475823656888679,"d":"6.48"}}]
["DB Size Year 2:",{"$f":"B52*2","v":{"v":13906725410.5,"d":"13,906,725,411"}},{"$f":"B53/1024/1024/1024","v":{"v":12.951647313777357,"d":"12.95"}}]
["DB Size Year 3:",{"$f":"B52*3","v":{"v":20860088115.75,"d":"20,860,088,116"}},{"$f":"B54/1024/1024/1024","v":{"v":19.427470970666036,"d":"19.43"}}]
["DB Size Year 4:",{"$f":"B52*4","v":{"v":27813450821,"d":"27,813,450,821"}},{"$f":"B55/1024/1024/1024","v":{"v":25.903294627554715,"d":"25.90"}}]
[]
[]
[null,null,"Notes:","RecordSize for each subsystem is calculated using customer databases with real data on DB2 Server 8.2."]

{"sheet":"ICON_IDBSize","index":15,"n_rows":51,"n_cols":9,"rows_kept":51,"hidden":true}
["Table","Row Size","Rows Per Day","Table Size Per Year","Index Size Per Year","Total Size Per Year","Rows Per Year","Comments"]
["GS_AGENT_STAT",{"$f":"IconRowSizes!M48","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE), C19*#REF!, 0)","v":{"$error":"#REF!"}},{"$f":"$B$50*CEILING($G2/FLOOR($B$48/$B2,1),1)","v":{"$error":"#REF!"}},{"$f":"$B$50*IF(IconRowSizes!$N48, CEILING($G2/FLOOR($B$49/IconRowSizes!$N48,1),1),0) + IF(IconRowSizes!$O48, $B$50*CEILING($G2/FLOOR($B$49/IconRowSizes!$O48,1),1),0) + IF(IconRowSizes!$P48, $B$50*CEILING($G2/FLOOR($B$49/IconRowSizes!$P48,1),1),0) + IF(IconRowSizes!$Q48, $B$50*CEILING($G2/FLOOR($B$49/IconRowSizes!$Q48,1),1),0) + IF(IconRowSizes!$R48, $B$50*CEILING($G2/FLOOR($B$49/IconRowSizes!$R48,1),1),0) + IF(IconRowSizes!$S48, $B$50*CEILING($G2/FLOOR($B$49/IconRowSizes!$S48,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D2:E2)","v":{"$error":"#REF!"}},{"$f":"$C2*#REF!","v":{"$error":"#REF!"}},null," "]
["GS_AGENT_STAT_WM",{"$f":"IconRowSizes!M49","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE), 5*C4, 0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N49, CEILING($G3/FLOOR($B$49/IconRowSizes!$N49,1),1),0) + IF(IconRowSizes!$O49, $B$50*CEILING($G3/FLOOR($B$49/IconRowSizes!$O49,1),1),0) + IF(IconRowSizes!$P49, $B$50*CEILING($G3/FLOOR($B$49/IconRowSizes!$P49,1),1),0) + IF(IconRowSizes!$Q49, $B$50*CEILING($G3/FLOOR($B$49/IconRowSizes!$Q49,1),1),0) + IF(IconRowSizes!$R49, $B$50*CEILING($G3/FLOOR($B$49/IconRowSizes!$R49,1),1),0) + IF(IconRowSizes!$S49, $B$50*CEILING($G3/FLOOR($B$49/IconRowSizes!$S49,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D3:E3)","v":{"$error":"#REF!"}},{"$f":"$C3*#REF!","v":{"$error":"#REF!"}}]
["GX_SESSION_ENDPOINT",{"$f":"IconRowSizes!M50","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C19*#REF!+#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N50, CEILING($G4/FLOOR($B$49/IconRowSizes!$N50,1),1),0) + IF(IconRowSizes!$O50, $B$50*CEILING($G4/FLOOR($B$49/IconRowSizes!$O50,1),1),0) + IF(IconRowSizes!$P50, $B$50*CEILING($G4/FLOOR($B$49/IconRowSizes!$P50,1),1),0) + IF(IconRowSizes!$Q50, $B$50*CEILING($G4/FLOOR($B$49/IconRowSizes!$Q50,1),1),0) + IF(IconRowSizes!$R50, $B$50*CEILING($G4/FLOOR($B$49/IconRowSizes!$R50,1),1),0) + IF(IconRowSizes!$S50, $B$50*CEILING($G4/FLOOR($B$49/IconRowSizes!$S50,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C4*#REF!","v":{"$error":"#REF!"}}]
["G_AGENT_STATE_HISTORY",{"$f":"IconRowSizes!M51","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C4*(2*#REF! + 2 +#REF! *#REF!) + C19*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N51, CEILING($G5/FLOOR($B$49/IconRowSizes!$N51,1),1),0) + IF(IconRowSizes!$O51, $B$50*CEILING($G5/FLOOR($B$49/IconRowSizes!$O51,1),1),0) + IF(IconRowSizes!$P51, $B$50*CEILING($G5/FLOOR($B$49/IconRowSizes!$P51,1),1),0) + IF(IconRowSizes!$Q51, $B$50*CEILING($G5/FLOOR($B$49/IconRowSizes!$Q51,1),1),0) + IF(IconRowSizes!$R51, $B$50*CEILING($G5/FLOOR($B$49/IconRowSizes!$R51,1),1),0) + IF(IconRowSizes!$S51, $B$50*CEILING($G5/FLOOR($B$49/IconRowSizes!$S51,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C5*#REF!","v":{"$error":"#REF!"}}]
["G_AGENT_STATE_RC",{"$f":"IconRowSizes!M52","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),ROUND(C5/C4,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N52, CEILING($G6/FLOOR($B$49/IconRowSizes!$N52,1),1),0) + IF(IconRowSizes!$O52, $B$50*CEILING($G6/FLOOR($B$49/IconRowSizes!$O52,1),1),0) + IF(IconRowSizes!$P52, $B$50*CEILING($G6/FLOOR($B$49/IconRowSizes!$P52,1),1),0) + IF(IconRowSizes!$Q52, $B$50*CEILING($G6/FLOOR($B$49/IconRowSizes!$Q52,1),1),0) + IF(IconRowSizes!$R52, $B$50*CEILING($G6/FLOOR($B$49/IconRowSizes!$R52,1),1),0) + IF(IconRowSizes!$S52, $B$50*CEILING($G6/FLOOR($B$49/IconRowSizes!$S52,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C6*#REF!","v":{"$error":"#REF!"}}]
["G_CALL",{"$f":"IconRowSizes!M53","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C15,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N53, CEILING($G7/FLOOR($B$49/IconRowSizes!$N53,1),1),0) + IF(IconRowSizes!$O53, $B$50*CEILING($G7/FLOOR($B$49/IconRowSizes!$O53,1),1),0) + IF(IconRowSizes!$P53, $B$50*CEILING($G7/FLOOR($B$49/IconRowSizes!$P53,1),1),0) + IF(IconRowSizes!$Q53, $B$50*CEILING($G7/FLOOR($B$49/IconRowSizes!$Q53,1),1),0) + IF(IconRowSizes!$R53, $B$50*CEILING($G7/FLOOR($B$49/IconRowSizes!$R53,1),1),0) + IF(IconRowSizes!$S53, $B$50*CEILING($G7/FLOOR($B$49/IconRowSizes!$S53,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C7*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_HISTORY",{"$f":"IconRowSizes!M54","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),2*C7,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N54, CEILING($G8/FLOOR($B$49/IconRowSizes!$N54,1),1),0) + IF(IconRowSizes!$O54, $B$50*CEILING($G8/FLOOR($B$49/IconRowSizes!$O54,1),1),0) + IF(IconRowSizes!$P54, $B$50*CEILING($G8/FLOOR($B$49/IconRowSizes!$P54,1),1),0) + IF(IconRowSizes!$Q54, $B$50*CEILING($G8/FLOOR($B$49/IconRowSizes!$Q54,1),1),0) + IF(IconRowSizes!$R54, $B$50*CEILING($G8/FLOOR($B$49/IconRowSizes!$R54,1),1),0) + IF(IconRowSizes!$S54, $B$50*CEILING($G8/FLOOR($B$49/IconRowSizes!$S54,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C8*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_STAT",{"$f":"IconRowSizes!M55","v":{"$error":"#REF!"}},{"$f":"C7","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N55, CEILING($G9/FLOOR($B$49/IconRowSizes!$N55,1),1),0) + IF(IconRowSizes!$O55, $B$50*CEILING($G9/FLOOR($B$49/IconRowSizes!$O55,1),1),0) + IF(IconRowSizes!$P55, $B$50*CEILING($G9/FLOOR($B$49/IconRowSizes!$P55,1),1),0) + IF(IconRowSizes!$Q55, $B$50*CEILING($G9/FLOOR($B$49/IconRowSizes!$Q55,1),1),0) + IF(IconRowSizes!$R55, $B$50*CEILING($G9/FLOOR($B$49/IconRowSizes!$R55,1),1),0) + IF(IconRowSizes!$S55, $B$50*CEILING($G9/FLOOR($B$49/IconRowSizes!$S55,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C9*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_USERDATA",{"$f":"IconRowSizes!M56","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N56, CEILING($G10/FLOOR($B$49/IconRowSizes!$N56,1),1),0) + IF(IconRowSizes!$O56, $B$50*CEILING($G10/FLOOR($B$49/IconRowSizes!$O56,1),1),0) + IF(IconRowSizes!$P56, $B$50*CEILING($G10/FLOOR($B$49/IconRowSizes!$P56,1),1),0) + IF(IconRowSizes!$Q56, $B$50*CEILING($G10/FLOOR($B$49/IconRowSizes!$Q56,1),1),0) + IF(IconRowSizes!$R56, $B$50*CEILING($G10/FLOOR($B$49/IconRowSizes!$R56,1),1),0) + IF(IconRowSizes!$S56, $B$50*CEILING($G10/FLOOR($B$49/IconRowSizes!$S56,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D10:E10)","v":{"$error":"#REF!"}},{"$f":"$C10*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_USERDATA_CUST",{"$f":"IconRowSizes!M57","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N57, CEILING($G11/FLOOR($B$49/IconRowSizes!$N57,1),1),0) + IF(IconRowSizes!$O57, $B$50*CEILING($G11/FLOOR($B$49/IconRowSizes!$O57,1),1),0) + IF(IconRowSizes!$P57, $B$50*CEILING($G11/FLOOR($B$49/IconRowSizes!$P57,1),1),0) + IF(IconRowSizes!$Q57, $B$50*CEILING($G11/FLOOR($B$49/IconRowSizes!$Q57,1),1),0) + IF(IconRowSizes!$R57, $B$50*CEILING($G11/FLOOR($B$49/IconRowSizes!$R57,1),1),0) + IF(IconRowSizes!$S57, $B$50*CEILING($G11/FLOOR($B$49/IconRowSizes!$S57,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C11*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_USERDATA_CUST1",{"$f":"IconRowSizes!M58","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N58, CEILING($G12/FLOOR($B$49/IconRowSizes!$N58,1),1),0) + IF(IconRowSizes!$O58, $B$50*CEILING($G12/FLOOR($B$49/IconRowSizes!$O58,1),1),0) + IF(IconRowSizes!$P58, $B$50*CEILING($G12/FLOOR($B$49/IconRowSizes!$P58,1),1),0) + IF(IconRowSizes!$Q58, $B$50*CEILING($G12/FLOOR($B$49/IconRowSizes!$Q58,1),1),0) + IF(IconRowSizes!$R58, $B$50*CEILING($G12/FLOOR($B$49/IconRowSizes!$R58,1),1),0) + IF(IconRowSizes!$S58, $B$50*CEILING($G12/FLOOR($B$49/IconRowSizes!$S58,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C12*#REF!","v":{"$error":"#REF!"}}]
["R_CALL_USERDATA_CUST3",{"$f":"IconRowSizes!M59","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N59, CEILING($G13/FLOOR($B$49/IconRowSizes!$N59,1),1),0) + IF(IconRowSizes!$O59, $B$50*CEILING($G13/FLOOR($B$49/IconRowSizes!$O59,1),1),0) + IF(IconRowSizes!$P59, $B$50*CEILING($G13/FLOOR($B$49/IconRowSizes!$P59,1),1),0) + IF(IconRowSizes!$Q59, $B$50*CEILING($G13/FLOOR($B$49/IconRowSizes!$Q59,1),1),0) + IF(IconRowSizes!$R59, $B$50*CEILING($G13/FLOOR($B$49/IconRowSizes!$R59,1),1),0) + IF(IconRowSizes!$S59, $B$50*CEILING($G13/FLOOR($B$49/IconRowSizes!$S59,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["G_DND_HISTORY",{"$f":"IconRowSizes!M60","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N60, CEILING($G14/FLOOR($B$49/IconRowSizes!$N60,1),1),0) + IF(IconRowSizes!$O60, $B$50*CEILING($G14/FLOOR($B$49/IconRowSizes!$O60,1),1),0) + IF(IconRowSizes!$P60, $B$50*CEILING($G14/FLOOR($B$49/IconRowSizes!$P60,1),1),0) + IF(IconRowSizes!$Q60, $B$50*CEILING($G14/FLOOR($B$49/IconRowSizes!$Q60,1),1),0) + IF(IconRowSizes!$R60, $B$50*CEILING($G14/FLOOR($B$49/IconRowSizes!$R60,1),1),0) + IF(IconRowSizes!$S60, $B$50*CEILING($G14/FLOOR($B$49/IconRowSizes!$S60,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C14*#REF!","v":{"$error":"#REF!"}},"Assuming that every agent press DND button once per day"]
["G_IR",{"$f":"IconRowSizes!M61","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),#REF!*(#REF! +#REF!),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N61, CEILING($G15/FLOOR($B$49/IconRowSizes!$N61,1),1),0) + IF(IconRowSizes!$O61, $B$50*CEILING($G15/FLOOR($B$49/IconRowSizes!$O61,1),1),0) + IF(IconRowSizes!$P61, $B$50*CEILING($G15/FLOOR($B$49/IconRowSizes!$P61,1),1),0) + IF(IconRowSizes!$Q61, $B$50*CEILING($G15/FLOOR($B$49/IconRowSizes!$Q61,1),1),0) + IF(IconRowSizes!$R61, $B$50*CEILING($G15/FLOOR($B$49/IconRowSizes!$R61,1),1),0) + IF(IconRowSizes!$S61, $B$50*CEILING($G15/FLOOR($B$49/IconRowSizes!$S61,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C15*#REF!","v":{"$error":"#REF!"}}]
["G_IR_HISTORY",{"$f":"IconRowSizes!M62","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),2*C15 +#REF! *#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N62, CEILING($G16/FLOOR($B$49/IconRowSizes!$N62,1),1),0) + IF(IconRowSizes!$O62, $B$50*CEILING($G16/FLOOR($B$49/IconRowSizes!$O62,1),1),0) + IF(IconRowSizes!$P62, $B$50*CEILING($G16/FLOOR($B$49/IconRowSizes!$P62,1),1),0) + IF(IconRowSizes!$Q62, $B$50*CEILING($G16/FLOOR($B$49/IconRowSizes!$Q62,1),1),0) + IF(IconRowSizes!$R62, $B$50*CEILING($G16/FLOOR($B$49/IconRowSizes!$R62,1),1),0) + IF(IconRowSizes!$S62, $B$50*CEILING($G16/FLOOR($B$49/IconRowSizes!$S62,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C16*#REF!","v":{"$error":"#REF!"}}]
["G_IS_LINK",{"$f":"IconRowSizes!M63","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),MAX(2*#REF!*(#REF!-1),0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N63, CEILING($G17/FLOOR($B$49/IconRowSizes!$N63,1),1),0) + IF(IconRowSizes!$O63, $B$50*CEILING($G17/FLOOR($B$49/IconRowSizes!$O63,1),1),0) + IF(IconRowSizes!$P63, $B$50*CEILING($G17/FLOOR($B$49/IconRowSizes!$P63,1),1),0) + IF(IconRowSizes!$Q63, $B$50*CEILING($G17/FLOOR($B$49/IconRowSizes!$Q63,1),1),0) + IF(IconRowSizes!$R63, $B$50*CEILING($G17/FLOOR($B$49/IconRowSizes!$R63,1),1),0) + IF(IconRowSizes!$S63, $B$50*CEILING($G17/FLOOR($B$49/IconRowSizes!$S63,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C17*#REF!","v":{"$error":"#REF!"}}]
["G_IS_LINK_HISTORY",{"$f":"IconRowSizes!M64","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C17,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N64, CEILING($G18/FLOOR($B$49/IconRowSizes!$N64,1),1),0) + IF(IconRowSizes!$O64, $B$50*CEILING($G18/FLOOR($B$49/IconRowSizes!$O64,1),1),0) + IF(IconRowSizes!$P64, $B$50*CEILING($G18/FLOOR($B$49/IconRowSizes!$P64,1),1),0) + IF(IconRowSizes!$Q64, $B$50*CEILING($G18/FLOOR($B$49/IconRowSizes!$Q64,1),1),0) + IF(IconRowSizes!$R64, $B$50*CEILING($G18/FLOOR($B$49/IconRowSizes!$R64,1),1),0) + IF(IconRowSizes!$S64, $B$50*CEILING($G18/FLOOR($B$49/IconRowSizes!$S64,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C18*#REF!","v":{"$error":"#REF!"}}]
["G_LOGIN_SESSION",{"$f":"IconRowSizes!M65","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N65, CEILING($G19/FLOOR($B$49/IconRowSizes!$N65,1),1),0) + IF(IconRowSizes!$O65, $B$50*CEILING($G19/FLOOR($B$49/IconRowSizes!$O65,1),1),0) + IF(IconRowSizes!$P65, $B$50*CEILING($G19/FLOOR($B$49/IconRowSizes!$P65,1),1),0) + IF(IconRowSizes!$Q65, $B$50*CEILING($G19/FLOOR($B$49/IconRowSizes!$Q65,1),1),0) + IF(IconRowSizes!$R65, $B$50*CEILING($G19/FLOOR($B$49/IconRowSizes!$R65,1),1),0) + IF(IconRowSizes!$S65, $B$50*CEILING($G19/FLOOR($B$49/IconRowSizes!$S65,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C19*#REF!","v":{"$error":"#REF!"}}]
["G_PARTY",{"$f":"IconRowSizes!M66","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),2*C7 +#REF!*(#REF! +#REF!),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N66, CEILING($G20/FLOOR($B$49/IconRowSizes!$N66,1),1),0) + IF(IconRowSizes!$O66, $B$50*CEILING($G20/FLOOR($B$49/IconRowSizes!$O66,1),1),0) + IF(IconRowSizes!$P66, $B$50*CEILING($G20/FLOOR($B$49/IconRowSizes!$P66,1),1),0) + IF(IconRowSizes!$Q66, $B$50*CEILING($G20/FLOOR($B$49/IconRowSizes!$Q66,1),1),0) + IF(IconRowSizes!$R66, $B$50*CEILING($G20/FLOOR($B$49/IconRowSizes!$R66,1),1),0) + IF(IconRowSizes!$S66, $B$50*CEILING($G20/FLOOR($B$49/IconRowSizes!$S66,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C20*#REF!","v":{"$error":"#REF!"}}]
["G_PARTY_HISTORY",{"$f":"IconRowSizes!M67","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),3*C20,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N67, CEILING($G21/FLOOR($B$49/IconRowSizes!$N67,1),1),0) + IF(IconRowSizes!$O67, $B$50*CEILING($G21/FLOOR($B$49/IconRowSizes!$O67,1),1),0) + IF(IconRowSizes!$P67, $B$50*CEILING($G21/FLOOR($B$49/IconRowSizes!$P67,1),1),0) + IF(IconRowSizes!$Q67, $B$50*CEILING($G21/FLOOR($B$49/IconRowSizes!$Q67,1),1),0) + IF(IconRowSizes!$R67, $B$50*CEILING($G21/FLOOR($B$49/IconRowSizes!$R67,1),1),0) + IF(IconRowSizes!$S67, $B$50*CEILING($G21/FLOOR($B$49/IconRowSizes!$S67,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C21*#REF!","v":{"$error":"#REF!"}}]
["G_PARTY_STAT",{"$f":"IconRowSizes!M68","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C20,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N68, CEILING($G22/FLOOR($B$49/IconRowSizes!$N68,1),1),0) + IF(IconRowSizes!$O68, $B$50*CEILING($G22/FLOOR($B$49/IconRowSizes!$O68,1),1),0) + IF(IconRowSizes!$P68, $B$50*CEILING($G22/FLOOR($B$49/IconRowSizes!$P68,1),1),0) + IF(IconRowSizes!$Q68, $B$50*CEILING($G22/FLOOR($B$49/IconRowSizes!$Q68,1),1),0) + IF(IconRowSizes!$R68, $B$50*CEILING($G22/FLOOR($B$49/IconRowSizes!$R68,1),1),0) + IF(IconRowSizes!$S68, $B$50*CEILING($G22/FLOOR($B$49/IconRowSizes!$S68,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C22*#REF!","v":{"$error":"#REF!"}}]
["G_ROUTE_RESULT",{"$f":"IconRowSizes!M69","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N69, CEILING($G23/FLOOR($B$49/IconRowSizes!$N69,1),1),0) + IF(IconRowSizes!$O69, $B$50*CEILING($G23/FLOOR($B$49/IconRowSizes!$O69,1),1),0) + IF(IconRowSizes!$P69, $B$50*CEILING($G23/FLOOR($B$49/IconRowSizes!$P69,1),1),0) + IF(IconRowSizes!$Q69, $B$50*CEILING($G23/FLOOR($B$49/IconRowSizes!$Q69,1),1),0) + IF(IconRowSizes!$R69, $B$50*CEILING($G23/FLOOR($B$49/IconRowSizes!$R69,1),1),0) + IF(IconRowSizes!$S69, $B$50*CEILING($G23/FLOOR($B$49/IconRowSizes!$S69,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C23*#REF!","v":{"$error":"#REF!"}}]
["G_SECURE_USERDATA_HISTORY",{"$f":"IconRowSizes!M70","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N70, CEILING($G24/FLOOR($B$49/IconRowSizes!$N70,1),1),0) + IF(IconRowSizes!$O70, $B$50*CEILING($G24/FLOOR($B$49/IconRowSizes!$O70,1),1),0) + IF(IconRowSizes!$P70, $B$50*CEILING($G24/FLOOR($B$49/IconRowSizes!$P70,1),1),0) + IF(IconRowSizes!$Q70, $B$50*CEILING($G24/FLOOR($B$49/IconRowSizes!$Q70,1),1),0) + IF(IconRowSizes!$R70, $B$50*CEILING($G24/FLOOR($B$49/IconRowSizes!$R70,1),1),0) + IF(IconRowSizes!$S70, $B$50*CEILING($G24/FLOOR($B$49/IconRowSizes!$S70,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C24*#REF!","v":{"$error":"#REF!"}},"The table covered by the G_USEDATA_HISTORY table"]
["G_USERDATA_HISTORY",{"$f":"IconRowSizes!M71","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C7*#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N71, CEILING($G25/FLOOR($B$49/IconRowSizes!$N71,1),1),0) + IF(IconRowSizes!$O71, $B$50*CEILING($G25/FLOOR($B$49/IconRowSizes!$O71,1),1),0) + IF(IconRowSizes!$P71, $B$50*CEILING($G25/FLOOR($B$49/IconRowSizes!$P71,1),1),0) + IF(IconRowSizes!$Q71, $B$50*CEILING($G25/FLOOR($B$49/IconRowSizes!$Q71,1),1),0) + IF(IconRowSizes!$R71, $B$50*CEILING($G25/FLOOR($B$49/IconRowSizes!$R71,1),1),0) + IF(IconRowSizes!$S71, $B$50*CEILING($G25/FLOOR($B$49/IconRowSizes!$S71,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C25*#REF!","v":{"$error":"#REF!"}}]
["G_VIRTUAL_QUEUE",{"$f":"IconRowSizes!M72","v":{"$error":"#REF!"}},{"$f":"#REF!*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N72, CEILING($G26/FLOOR($B$49/IconRowSizes!$N72,1),1),0) + IF(IconRowSizes!$O72, $B$50*CEILING($G26/FLOOR($B$49/IconRowSizes!$O72,1),1),0) + IF(IconRowSizes!$P72, $B$50*CEILING($G26/FLOOR($B$49/IconRowSizes!$P72,1),1),0) + IF(IconRowSizes!$Q72, $B$50*CEILING($G26/FLOOR($B$49/IconRowSizes!$Q72,1),1),0) + IF(IconRowSizes!$R72, $B$50*CEILING($G26/FLOOR($B$49/IconRowSizes!$R72,1),1),0) + IF(IconRowSizes!$S72, $B$50*CEILING($G26/FLOOR($B$49/IconRowSizes!$S72,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C26*#REF!","v":{"$error":"#REF!"}}]
["GOX_CHAIN_CALL",{"$f":"IconRowSizes!M73","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N73, CEILING($G27/FLOOR($B$49/IconRowSizes!$N73,1),1),0) + IF(IconRowSizes!$O73, $B$50*CEILING($G27/FLOOR($B$49/IconRowSizes!$O73,1),1),0) + IF(IconRowSizes!$P73, $B$50*CEILING($G27/FLOOR($B$49/IconRowSizes!$P73,1),1),0) + IF(IconRowSizes!$Q73, $B$50*CEILING($G27/FLOOR($B$49/IconRowSizes!$Q73,1),1),0) + IF(IconRowSizes!$R73, $B$50*CEILING($G27/FLOOR($B$49/IconRowSizes!$R73,1),1),0) + IF(IconRowSizes!$S73, $B$50*CEILING($G27/FLOOR($B$49/IconRowSizes!$S73,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C27*#REF!","v":{"$error":"#REF!"}}]
["GO_CAMPAIGN",{"$f":"IconRowSizes!M74","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N74, CEILING($G28/FLOOR($B$49/IconRowSizes!$N74,1),1),0) + IF(IconRowSizes!$O74, $B$50*CEILING($G28/FLOOR($B$49/IconRowSizes!$O74,1),1),0) + IF(IconRowSizes!$P74, $B$50*CEILING($G28/FLOOR($B$49/IconRowSizes!$P74,1),1),0) + IF(IconRowSizes!$Q74, $B$50*CEILING($G28/FLOOR($B$49/IconRowSizes!$Q74,1),1),0) + IF(IconRowSizes!$R74, $B$50*CEILING($G28/FLOOR($B$49/IconRowSizes!$R74,1),1),0) + IF(IconRowSizes!$S74, $B$50*CEILING($G28/FLOOR($B$49/IconRowSizes!$S74,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C28*#REF!","v":{"$error":"#REF!"}}]
["GO_CAMPAIGNHISTORY",{"$f":"IconRowSizes!M75","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),3*C28,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N75, CEILING($G29/FLOOR($B$49/IconRowSizes!$N75,1),1),0) + IF(IconRowSizes!$O75, $B$50*CEILING($G29/FLOOR($B$49/IconRowSizes!$O75,1),1),0) + IF(IconRowSizes!$P75, $B$50*CEILING($G29/FLOOR($B$49/IconRowSizes!$P75,1),1),0) + IF(IconRowSizes!$Q75, $B$50*CEILING($G29/FLOOR($B$49/IconRowSizes!$Q75,1),1),0) + IF(IconRowSizes!$R75, $B$50*CEILING($G29/FLOOR($B$49/IconRowSizes!$R75,1),1),0) + IF(IconRowSizes!$S75, $B$50*CEILING($G29/FLOOR($B$49/IconRowSizes!$S75,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C29*#REF!","v":{"$error":"#REF!"}}]
["GO_CAMPPROP_HIST",{"$f":"IconRowSizes!M76","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),2*C28,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N76, CEILING($G30/FLOOR($B$49/IconRowSizes!$N76,1),1),0) + IF(IconRowSizes!$O76, $B$50*CEILING($G30/FLOOR($B$49/IconRowSizes!$O76,1),1),0) + IF(IconRowSizes!$P76, $B$50*CEILING($G30/FLOOR($B$49/IconRowSizes!$P76,1),1),0) + IF(IconRowSizes!$Q76, $B$50*CEILING($G30/FLOOR($B$49/IconRowSizes!$Q76,1),1),0) + IF(IconRowSizes!$R76, $B$50*CEILING($G30/FLOOR($B$49/IconRowSizes!$R76,1),1),0) + IF(IconRowSizes!$S76, $B$50*CEILING($G30/FLOOR($B$49/IconRowSizes!$S76,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C30*#REF!","v":{"$error":"#REF!"}}]
["GO_CHAIN",{"$f":"IconRowSizes!M77","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),CEILING(2*#REF!/#REF!,1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N77, CEILING($G31/FLOOR($B$49/IconRowSizes!$N77,1),1),0) + IF(IconRowSizes!$O77, $B$50*CEILING($G31/FLOOR($B$49/IconRowSizes!$O77,1),1),0) + IF(IconRowSizes!$P77, $B$50*CEILING($G31/FLOOR($B$49/IconRowSizes!$P77,1),1),0) + IF(IconRowSizes!$Q77, $B$50*CEILING($G31/FLOOR($B$49/IconRowSizes!$Q77,1),1),0) + IF(IconRowSizes!$R77, $B$50*CEILING($G31/FLOOR($B$49/IconRowSizes!$R77,1),1),0) + IF(IconRowSizes!$S77, $B$50*CEILING($G31/FLOOR($B$49/IconRowSizes!$S77,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C31*#REF!","v":{"$error":"#REF!"}},"Assuming that as average only half of a chain's records are processed to reach the target (whatever it means)"]
["GO_CHAINREC_HIST",{"$f":"IconRowSizes!M78","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),4*C31*CEILING(#REF!/2,1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N78, CEILING($G32/FLOOR($B$49/IconRowSizes!$N78,1),1),0) + IF(IconRowSizes!$O78, $B$50*CEILING($G32/FLOOR($B$49/IconRowSizes!$O78,1),1),0) + IF(IconRowSizes!$P78, $B$50*CEILING($G32/FLOOR($B$49/IconRowSizes!$P78,1),1),0) + IF(IconRowSizes!$Q78, $B$50*CEILING($G32/FLOOR($B$49/IconRowSizes!$Q78,1),1),0) + IF(IconRowSizes!$R78, $B$50*CEILING($G32/FLOOR($B$49/IconRowSizes!$R78,1),1),0) + IF(IconRowSizes!$S78, $B$50*CEILING($G32/FLOOR($B$49/IconRowSizes!$S78,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C32*#REF!","v":{"$error":"#REF!"}},"Assuming four changes per chain"]
["GO_CUSTOM_FIELDS",{"$f":"IconRowSizes!M79","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C36*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N79, CEILING($G33/FLOOR($B$49/IconRowSizes!$N79,1),1),0) + IF(IconRowSizes!$O79, $B$50*CEILING($G33/FLOOR($B$49/IconRowSizes!$O79,1),1),0) + IF(IconRowSizes!$P79, $B$50*CEILING($G33/FLOOR($B$49/IconRowSizes!$P79,1),1),0) + IF(IconRowSizes!$Q79, $B$50*CEILING($G33/FLOOR($B$49/IconRowSizes!$Q79,1),1),0) + IF(IconRowSizes!$R79, $B$50*CEILING($G33/FLOOR($B$49/IconRowSizes!$R79,1),1),0) + IF(IconRowSizes!$S79, $B$50*CEILING($G33/FLOOR($B$49/IconRowSizes!$S79,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C33*#REF!","v":{"$error":"#REF!"}}]
["GO_FIELDHIST",{"$f":"IconRowSizes!M80","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C36*(#REF! +#REF!),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N80, CEILING($G34/FLOOR($B$49/IconRowSizes!$N80,1),1),0) + IF(IconRowSizes!$O80, $B$50*CEILING($G34/FLOOR($B$49/IconRowSizes!$O80,1),1),0) + IF(IconRowSizes!$P80, $B$50*CEILING($G34/FLOOR($B$49/IconRowSizes!$P80,1),1),0) + IF(IconRowSizes!$Q80, $B$50*CEILING($G34/FLOOR($B$49/IconRowSizes!$Q80,1),1),0) + IF(IconRowSizes!$R80, $B$50*CEILING($G34/FLOOR($B$49/IconRowSizes!$R80,1),1),0) + IF(IconRowSizes!$S80, $B$50*CEILING($G34/FLOOR($B$49/IconRowSizes!$S80,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C34*#REF!","v":{"$error":"#REF!"}}]
["GO_METRICS",{"$f":"IconRowSizes!M81","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),CEILING(2*$B$51*#REF!*(2*#REF!+3)+#REF!*(#REF!+3),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N81, CEILING($G35/FLOOR($B$49/IconRowSizes!$N81,1),1),0) + IF(IconRowSizes!$O81, $B$50*CEILING($G35/FLOOR($B$49/IconRowSizes!$O81,1),1),0) + IF(IconRowSizes!$P81, $B$50*CEILING($G35/FLOOR($B$49/IconRowSizes!$P81,1),1),0) + IF(IconRowSizes!$Q81, $B$50*CEILING($G35/FLOOR($B$49/IconRowSizes!$Q81,1),1),0) + IF(IconRowSizes!$R81, $B$50*CEILING($G35/FLOOR($B$49/IconRowSizes!$R81,1),1),0) + IF(IconRowSizes!$S81, $B$50*CEILING($G35/FLOOR($B$49/IconRowSizes!$S81,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C35*#REF!","v":{"$error":"#REF!"}}]
["GO_RECORD",{"$f":"IconRowSizes!M82","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),C31*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$B$50*IF(IconRowSizes!$N82, CEILING($G36/FLOOR($B$49/IconRowSizes!$N82,1),1),0) + IF(IconRowSizes!$O82, $B$50*CEILING($G36/FLOOR($B$49/IconRowSizes!$O82,1),1),0) + IF(IconRowSizes!$P82, $B$50*CEILING($G36/FLOOR($B$49/IconRowSizes!$P82,1),1),0) + IF(IconRowSizes!$Q82, $B$50*CEILING($G36/FLOOR($B$49/IconRowSizes!$Q82,1),1),0) + IF(IconRowSizes!$R82, $B$50*CEILING($G36/FLOOR($B$49/IconRowSizes!$R82,1),1),0) + IF(IconRowSizes!$S82, $B$50*CEILING($G36/FLOOR($B$49/IconRowSizes!$S82,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$C36*#REF!","v":{"$error":"#REF!"}},"Assuming that there is 1-1 correspondence between GO_RECORD rows and outbound calls (e.g., if an outpound record has been processed twice during the day, there will be two rows in the GO_RECORD table)"]
["GO_SECURE_FIELDS",{"$f":"IconRowSizes!M83","v":{"$error":"#REF!"}},0," ",{"$f":"$B$50*IF(IconRowSizes!$N83, CEILING($G37/FLOOR($B$49/IconRowSizes!$N83,1),1),0) + IF(IconRowSizes!$O83, $B$50*CEILING($G37/FLOOR($B$49/IconRowSizes!$O83,1),1),0) + IF(IconRowSizes!$P83, $B$50*CEILING($G37/FLOOR($B$49/IconRowSizes!$P83,1),1),0) + IF(IconRowSizes!$Q83, $B$50*CEILING($G37/FLOOR($B$49/IconRowSizes!$Q83,1),1),0) + IF(IconRowSizes!$R83, $B$50*CEILING($G37/FLOOR($B$49/IconRowSizes!$R83,1),1),0) + IF(IconRowSizes!$S83, $B$50*CEILING($G37/FLOOR($B$49/IconRowSizes!$S83,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"Those two tables covered by the G_CUSTOM_FIELDS"]
["GO_SEC_FIELDHIST",{"$f":"IconRowSizes!M84","v":{"$error":"#REF!"}},0," ",{"$f":"$B$50*IF(IconRowSizes!$N84, CEILING($G38/FLOOR($B$49/IconRowSizes!$N84,1),1),0) + IF(IconRowSizes!$O84, $B$50*CEILING($G38/FLOOR($B$49/IconRowSizes!$O84,1),1),0) + IF(IconRowSizes!$P84, $B$50*CEILING($G38/FLOOR($B$49/IconRowSizes!$P84,1),1),0) + IF(IconRowSizes!$Q84, $B$50*CEILING($G38/FLOOR($B$49/IconRowSizes!$Q84,1),1),0) + IF(IconRowSizes!$R84, $B$50*CEILING($G38/FLOOR($B$49/IconRowSizes!$R84,1),1),0) + IF(IconRowSizes!$S84, $B$50*CEILING($G38/FLOOR($B$49/IconRowSizes!$S84,1),1),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"and GO_FIELDHIST tables respectively"]
["Total",null,{"$f":"SUM(C2:C38) + SUM(C42:C45)","v":{"$error":"#REF!"}},{"$f":"SUM(D2:D38) + SUM(D42:D45)","v":{"$error":"#REF!"}},{"$f":"SUM(E2:E38)+SUM(E42:E45)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
["Userdata Table","Row Size","Rows Per Day","Table Size Per Year","Index Size Per Year",null,"Rows Per Year","Comment"]
["G_CALL_USERDATA",{"$f":"IconRowSizes!M56 - 258*(10-#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),IF(#REF! > 0, C7,0),0)","v":{"$error":"#REF!"}},{"$f":"$B$50*CEILING($G42/FLOOR($B$48/$B42,1),1)","v":{"$error":"#REF!"}},{"$f":"$B$50*IF(IconRowSizes!$N56, CEILING($G42/FLOOR($B$49/IconRowSizes!$N56,1),1),0) + IF(IconRowSizes!$O56, $B$50*CEILING($G42/FLOOR($B$49/IconRowSizes!$O56,1),1),0) + IF(IconRowSizes!$P56, $B$50*CEILING($G42/FLOOR($B$49/IconRowSizes!$P56,1),1),0) + IF(IconRowSizes!$Q56, $B$50*CEILING($G42/FLOOR($B$49/IconRowSizes!$Q56,1),1),0) + IF(IconRowSizes!$R56, $B$50*CEILING($G42/FLOOR($B$49/IconRowSizes!$R56,1),1),0) + IF(IconRowSizes!$S56, $B$50*CEILING($G42/FLOOR($B$49/IconRowSizes!$S56,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D42:E42)","v":{"$error":"#REF!"}},{"$f":"$C42*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_USERDATA_CUST1",{"$f":"IconRowSizes!M57","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),IF(#REF! > 0, C7, 0),0)","v":{"$error":"#REF!"}},{"$f":"$B$50*CEILING($G43/FLOOR($B$48/$B43,1),1)","v":{"$error":"#REF!"}},{"$f":"$B$50*IF(IconRowSizes!$N57, CEILING($G43/FLOOR($B$49/IconRowSizes!$N57,1),1),0) + IF(IconRowSizes!$O57, $B$50*CEILING($G43/FLOOR($B$49/IconRowSizes!$O57,1),1),0) + IF(IconRowSizes!$P57, $B$50*CEILING($G43/FLOOR($B$49/IconRowSizes!$P57,1),1),0) + IF(IconRowSizes!$Q57, $B$50*CEILING($G43/FLOOR($B$49/IconRowSizes!$Q57,1),1),0) + IF(IconRowSizes!$R57, $B$50*CEILING($G43/FLOOR($B$49/IconRowSizes!$R57,1),1),0) + IF(IconRowSizes!$S57, $B$50*CEILING($G43/FLOOR($B$49/IconRowSizes!$S57,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D43:E43)","v":{"$error":"#REF!"}},{"$f":"$C43*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_USERDATA_CUST2",{"$f":"IconRowSizes!M58","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),IF(#REF! > 19, C7, 0),0)","v":{"$error":"#REF!"}},{"$f":"$B$50*CEILING($G44/FLOOR($B$48/$B44,1),1)","v":{"$error":"#REF!"}},{"$f":"$B$50*IF(IconRowSizes!$N58, CEILING($G44/FLOOR($B$49/IconRowSizes!$N58,1),1),0) + IF(IconRowSizes!$O58, $B$50*CEILING($G44/FLOOR($B$49/IconRowSizes!$O58,1),1),0) + IF(IconRowSizes!$P58, $B$50*CEILING($G44/FLOOR($B$49/IconRowSizes!$P58,1),1),0) + IF(IconRowSizes!$Q58, $B$50*CEILING($G44/FLOOR($B$49/IconRowSizes!$Q58,1),1),0) + IF(IconRowSizes!$R58, $B$50*CEILING($G44/FLOOR($B$49/IconRowSizes!$R58,1),1),0) + IF(IconRowSizes!$S58, $B$50*CEILING($G44/FLOOR($B$49/IconRowSizes!$S58,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D44:E44)","v":{"$error":"#REF!"}},{"$f":"$C44*#REF!","v":{"$error":"#REF!"}}]
["G_CALL_USERDATA_CUST3",{"$f":"IconRowSizes!M59","v":{"$error":"#REF!"}},{"$f":"IF(VLOOKUP(#REF!,#REF!,2,FALSE),IF(#REF! > 38, C8, 0),0)","v":{"$error":"#REF!"}},{"$f":"$B$50*CEILING($G45/FLOOR($B$48/$B45,1),1)","v":{"$error":"#REF!"}},{"$f":"$B$50*IF(IconRowSizes!$N59, CEILING($G45/FLOOR($B$49/IconRowSizes!$N59,1),1),0) + IF(IconRowSizes!$O59, $B$50*CEILING($G45/FLOOR($B$49/IconRowSizes!$O59,1),1),0) + IF(IconRowSizes!$P59, $B$50*CEILING($G45/FLOOR($B$49/IconRowSizes!$P59,1),1),0) + IF(IconRowSizes!$Q59, $B$50*CEILING($G45/FLOOR($B$49/IconRowSizes!$Q59,1),1),0) + IF(IconRowSizes!$R59, $B$50*CEILING($G45/FLOOR($B$49/IconRowSizes!$R59,1),1),0) + IF(IconRowSizes!$S59, $B$50*CEILING($G45/FLOOR($B$49/IconRowSizes!$S59,1),1),0)","v":{"$error":"#REF!"}},{"$f":"SUM(D45:E45)","v":{"$error":"#REF!"}},{"$f":"$C45*#REF!","v":{"$error":"#REF!"}}]
[]
["Helpers","Value"]
["Block Free Size",{"$f":"IconRowSizes!$Q$2","v":{"$error":"#REF!"}}]
["Index Block Free Size",{"$f":"IconRowSizes!$R$2","v":{"$error":"#REF!"}}]
["Block Size",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Metrics Snapshots Per Day",{"$f":"3600*#REF!/#REF!","v":{"$error":"#REF!"}}]

{"sheet":"IconRowSizes","index":16,"n_rows":84,"n_cols":21,"rows_kept":84,"hidden":true}
["Data Type","bigint","int","smallint","number (16)","number (19)","number (20)","datetime","varchar(50)","varchar(64)","varchar(128)","varchar(255)","Block Header","Row Header","Index Block Header","Index Row Header","Block Free Size","Index Block Free Size"]
["Bytes (Current)",{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),B3,B4,B5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),C3,C4,C5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),D3,D4,D5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),E3,E4,E5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),F3,F4,F5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),G3,G4,G5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),H3,H4,H5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),I3,I4,I5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),J3,J4,J5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),K3,K4,K5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),L3,L4,L5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),M3,M4,M5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),N3,N4,N5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),O3,O4,O5)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(VLOOKUP(#REF!,#REF!,2,FALSE),P3,P4,P5)","v":{"$error":"#REF!"}},{"$f":"FLOOR((#REF! - M2)*(1-#REF!),1)","v":{"$error":"#REF!"}},{"$f":"FLOOR((#REF! - O2)*(1-#REF!),1)","v":{"$error":"#REF!"}}]
["Bytes (Oracle)",11,6,4,9,11,11,11,53,65,129,258,84,3,161,8,{"$nulls":4},"Header estimates for Oracle could be outdated (taken from several sources, including Oracle 7 documentation). Hopefully, progress should save memory, don't waste it."]
["Bytes (MSSQL)",8,4,2,9,9,13,8,52,66,130,257,0,15,0,16]
["Bytes (DB2)",8,4,2,9,10,11,10,52,66,130,258,84,3,161,8,{"$nulls":4},"For DB2 header estimates were just forcibly set to those of Oracle"]
[]
["Table","smallint","integer","bigint","number(16)","number(19)","number(20)","datetime","varchar(50)","varchar(64)","varchar(128)","varchar(255)","Row Size","IES 1","IES 2","IES 3","IES 4","IES 5","IES 6","IES 7"]
["GCX_AGENT_PLACE",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B8 + C2*C8 + D2*D8 + E2*E8 + F2*F8 + G2*G8 + H2*H8 + I2*I8 + J2*J8 + K2*K8 + L2*L8","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_CAMPGROUP_INFO",0,23,2,1,0,0,3,0,0,0,1,{"$f":"13+B2*B9 + C2*C9 + D2*D9 + E2*E9 + F2*F9 + G2*G9 + H2*H9 + I2*I9 + J2*J9 + K2*K9 + L2*L9","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_CAMPLIST_INFO",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B10 + C2*C10 + D2*D10 + E2*E10 + F2*F10 + G2*G10 + H2*H10 + I2*I10 + J2*J10 + K2*K10 + L2*L10","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_ENDPOINT_PLACE",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B11 + C2*C11 + D2*D11 + E2*E11 + F2*F11 + G2*G11 + H2*H11 + I2*I11 + J2*J11 + K2*K11 + L2*L11","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_FORMAT_FIELD",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B12 + C2*C12 + D2*D12 + E2*E12 + F2*F12 + G2*G12 + H2*H12 + I2*I12 + J2*J12 + K2*K12 + L2*L12","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_GROUP_AGENT",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B13 + C2*C13 + D2*D13 + E2*E13 + F2*F13 + G2*G13 + H2*H13 + I2*I13 + J2*J13 + K2*K13 + L2*L13","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_GROUP_ENDPOINT",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B14 + C2*C14 + D2*D14 + E2*E14 + F2*F14 + G2*G14 + H2*H14 + I2*I14 + J2*J14 + K2*K14 + L2*L14","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_GROUP_PLACE",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B15 + C2*C15 + D2*D15 + E2*E15 + F2*F15 + G2*G15 + H2*H15 + I2*I15 + J2*J15 + K2*K15 + L2*L15","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_GROUP_ROUTEDN",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B16 + C2*C16 + D2*D16 + E2*E16 + F2*F16 + G2*G16 + H2*H16 + I2*I16 + J2*J16 + K2*K16 + L2*L16","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_LIST_TREATMENT",0,13,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B17 + C2*C17 + D2*D17 + E2*E17 + F2*F17 + G2*G17 + H2*H17 + I2*I17 + J2*J17 + K2*K17 + L2*L17","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_LOGIN_INFO",0,14,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B18 + C2*C18 + D2*D18 + E2*E18 + F2*F18 + G2*G18 + H2*H18 + I2*I18 + J2*J18 + K2*K18 + L2*L18","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_OBJTABLE_RECORD",0,17,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B19 + C2*C19 + D2*D19 + E2*E19 + F2*F19 + G2*G19 + H2*H19 + I2*I19 + J2*J19 + K2*K19 + L2*L19","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_SKILL_LEVEL",0,14,2,1,0,0,3,0,0,0,0,{"$f":"13+B2*B20 + C2*C20 + D2*D20 + E2*E20 + F2*F20 + G2*G20 + H2*H20 + I2*I20 + J2*J20 + K2*K20 + L2*L20","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GCX_SUBCODE",0,12,2,1,0,0,3,0,0,0,2,{"$f":"13+B2*B21 + C2*C21 + D2*D21 + E2*E21 + F2*F21 + G2*G21 + H2*H21 + I2*I21 + J2*J21 + K2*K21 + L2*L21","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GC_ACTION_CODE",0,18,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B22 + C2*C22 + D2*D22 + E2*E22 + F2*F22 + G2*G22 + H2*H22 + I2*I22 + J2*J22 + K2*K22 + L2*L22","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_AGENT",0,19,2,0,0,0,4,0,3,0,2,{"$f":"13+B2*B23 + C2*C23 + D2*D23 + E2*E23 + F2*F23 + G2*G23 + H2*H23 + I2*I23 + J2*J23 + K2*K23 + L2*L23","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_APPLICATION",0,17,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B24 + C2*C24 + D2*D24 + E2*E24 + F2*F24 + G2*G24 + H2*H24 + I2*I24 + J2*J24 + K2*K24 + L2*L24","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_ATTR_VALUE",0,18,2,0,0,0,4,0,0,0,3,{"$f":"13+B2*B25 + C2*C25 + D2*D25 + E2*E25 + F2*F25 + G2*G25 + H2*H25 + I2*I25 + J2*J25 + K2*K25 + L2*L25","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_BUS_ATTRIBUTE",0,18,2,0,0,0,4,0,0,0,3,{"$f":"13+B2*B26 + C2*C26 + D2*D26 + E2*E26 + F2*F26 + G2*G26 + H2*H26 + I2*I26 + J2*J26 + K2*K26 + L2*L26","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_CALLING_LIST",0,23,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B27 + C2*C27 + D2*D27 + E2*E27 + F2*F27 + G2*G27 + H2*H27 + I2*I27 + J2*J27 + K2*K27 + L2*L27","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_CAMPAIGN",0,17,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B28 + C2*C28 + D2*D28 + E2*E28 + F2*F28 + G2*G28 + H2*H28 + I2*I28 + J2*J28 + K2*K28 + L2*L28","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_ENDPOINT",0,20,2,0,0,0,4,0,0,0,3,{"$f":"13+B2*B29 + C2*C29 + D2*D29 + E2*E29 + F2*F29 + G2*G29 + H2*H29 + I2*I29 + J2*J29 + K2*K29 + L2*L29","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_FIELD",0,23,2,0,0,0,4,0,0,0,3,{"$f":"13+B2*B30 + C2*C30 + D2*D30 + E2*E30 + F2*F30 + G2*G30 + H2*H30 + I2*I30 + J2*J30 + K2*K30 + L2*L30","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_FILTER",0,18,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B31 + C2*C31 + D2*D31 + E2*E31 + F2*F31 + G2*G31 + H2*H31 + I2*I31 + J2*J31 + K2*K31 + L2*L31","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_FOLDER",0,20,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B32 + C2*C32 + D2*D32 + E2*E32 + F2*F32 + G2*G32 + H2*H32 + I2*I32 + J2*J32 + K2*K32 + L2*L32","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_FORMAT",0,17,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B33 + C2*C33 + D2*D33 + E2*E33 + F2*F33 + G2*G33 + H2*H33 + I2*I33 + J2*J33 + K2*K33 + L2*L33","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_GROUP",0,19,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B34 + C2*C34 + D2*D34 + E2*E34 + F2*F34 + G2*G34 + H2*H34 + I2*I34 + J2*J34 + K2*K34 + L2*L34","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_IVR",0,18,2,0,0,0,4,0,0,0,3,{"$f":"13+B2*B35 + C2*C35 + D2*D35 + E2*E35 + F2*F35 + G2*G35 + H2*H35 + I2*I35 + J2*J35 + K2*K35 + L2*L35","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_IVRPORT",0,19,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B36 + C2*C36 + D2*D36 + E2*E36 + F2*F36 + G2*G36 + H2*H36 + I2*I36 + J2*J36 + K2*K36 + L2*L36","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_LOGIN",0,18,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B37 + C2*C37 + D2*D37 + E2*E37 + F2*F37 + G2*G37 + H2*H37 + I2*I37 + J2*J37 + K2*K37 + L2*L37","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_OBJ_TABLE",0,17,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B38 + C2*C38 + D2*D38 + E2*E38 + F2*F38 + G2*G38 + H2*H38 + I2*I38 + J2*J38 + K2*K38 + L2*L38","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_PLACE",0,17,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B39 + C2*C39 + D2*D39 + E2*E39 + F2*F39 + G2*G39 + H2*H39 + I2*I39 + J2*J39 + K2*K39 + L2*L39","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_SCRIPT",0,18,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B40 + C2*C40 + D2*D40 + E2*E40 + F2*F40 + G2*G40 + H2*H40 + I2*I40 + J2*J40 + K2*K40 + L2*L40","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_SKILL",0,17,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B41 + C2*C41 + D2*D41 + E2*E41 + F2*F41 + G2*G41 + H2*H41 + I2*I41 + J2*J41 + K2*K41 + L2*L41","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_SWITCH",0,19,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B42 + C2*C42 + D2*D42 + E2*E42 + F2*F42 + G2*G42 + H2*H42 + I2*I42 + J2*J42 + K2*K42 + L2*L42","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_TABLE_ACCESS",0,21,2,0,0,0,4,0,0,0,3,{"$f":"13+B2*B43 + C2*C43 + D2*D43 + E2*E43 + F2*F43 + G2*G43 + H2*H43 + I2*I43 + J2*J43 + K2*K43 + L2*L43","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_TENANT",0,16,2,0,0,0,4,0,0,0,1,{"$f":"13+B2*B44 + C2*C44 + D2*D44 + E2*E44 + F2*F44 + G2*G44 + H2*H44 + I2*I44 + J2*J44 + K2*K44 + L2*L44","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_TIME_ZONE",0,21,2,0,0,0,4,0,0,0,4,{"$f":"13+B2*B45 + C2*C45 + D2*D45 + E2*E45 + F2*F45 + G2*G45 + H2*H45 + I2*I45 + J2*J45 + K2*K45 + L2*L45","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_TREATMENT",0,27,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B46 + C2*C46 + D2*D46 + E2*E46 + F2*F46 + G2*G46 + H2*H46 + I2*I46 + J2*J46 + K2*K46 + L2*L46","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GC_VOICE_PROMPT",0,19,2,0,0,0,4,0,0,0,2,{"$f":"13+B2*B47 + C2*C47 + D2*D47 + E2*E47 + F2*F47 + G2*G47 + H2*H47 + I2*I47 + J2*J47 + K2*K47 + L2*L47","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GS_AGENT_STAT",0,17,2,1,0,0,3,1,0,0,0,{"$f":"13+B2*B48 + C2*C48 + D2*D48 + E2*E48 + F2*F48 + G2*G48 + H2*H48 + I2*I48 + J2*J48 + K2*K48 + L2*L48","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0," "]
["GS_AGENT_STAT_WM",0,19,2,1,0,0,3,1,0,0,0,{"$f":"13+B2*B49 + C2*C49 + D2*D49 + E2*E49 + F2*F49 + G2*G49 + H2*H49 + I2*I49 + J2*J49 + K2*K49 + L2*L49","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2+C2+C2+C2","v":{"$error":"#REF!"}},0,0,0,0]
["GX_SESSION_ENDPOINT",0,18,2,1,0,0,3,1,0,0,0,{"$f":"13+B2*B50 + C2*C50 + D2*D50 + E2*E50 + F2*F50 + G2*G50 + H2*H50 + I2*I50 + J2*J50 + K2*K50 + L2*L50","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},{"$f":"P2+I2+C2","v":{"$error":"#REF!"}},0,0,0]
["G_AGENT_STATE_HISTORY",0,26,2,1,0,0,3,2,0,0,1,{"$f":"13+B2*B51 + C2*C51 + D2*D51 + E2*E51 + F2*F51 + G2*G51 + H2*H51 + I2*I51 + J2*J51 + K2*K51 + L2*L51","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_AGENT_STATE_RC",1,17,2,1,0,0,3,1,0,0,2,{"$f":"13+B2*B52 + C2*C52 + D2*D52 + E2*E52 + F2*F52 + G2*G52 + H2*H52 + I2*I52 + J2*J52 + K2*K52 + L2*L52","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_CALL",0,17,2,1,1,0,3,8,0,0,0,{"$f":"13+B2*B53 + C2*C53 + D2*D53 + E2*E53 + F2*F53 + G2*G53 + H2*H53 + I2*I53 + J2*J53 + K2*K53 + L2*L53","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+C2+B2","v":{"$error":"#REF!"}},{"$f":"P2+C2+B2","v":{"$error":"#REF!"}}]
["G_CALL_HISTORY",0,10,2,1,0,0,2,2,0,0,0,{"$f":"13+B2*B54 + C2*C54 + D2*D54 + E2*E54 + F2*F54 + G2*G54 + H2*H54 + I2*I54 + J2*J54 + K2*K54 + L2*L54","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_CALL_STAT",8,24,2,1,0,0,1,1,0,0,0,{"$f":"13+B2*B55 + C2*C55 + D2*D55 + E2*E55 + F2*F55 + G2*G55 + H2*H55 + I2*I55 + J2*J55 + K2*K55 + L2*L55","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_CALL_USERDATA",0,6,2,1,0,0,1,1,0,0,10,{"$f":"13+B2*B56 + C2*C56 + D2*D56 + E2*E56 + F2*F56 + G2*G56 + H2*H56 + I2*I56 + J2*J56 + K2*K56 + L2*L56","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_CALL_USERDATA_CUST",0,6,2,1,0,0,1,1,13,0,6,{"$f":"13+B2*B57 + C2*C57 + D2*D57 + E2*E57 + F2*F57 + G2*G57 + H2*H57 + I2*I57 + J2*J57 + K2*K57 + L2*L57","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_CALL_USERDATA_CUST1",0,6,2,1,0,0,1,1,13,0,6,{"$f":"13+B2*B58 + C2*C58 + D2*D58 + E2*E58 + F2*F58 + G2*G58 + H2*H58 + I2*I58 + J2*J58 + K2*K58 + L2*L58","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_CALL_USERDATA_CUST2",0,6,2,1,0,0,1,1,13,0,6,{"$f":"13+B2*B59 + C2*C59 + D2*D59 + E2*E59 + F2*F59 + G2*G59 + H2*H59 + I2*I59 + J2*J59 + K2*K59 + L2*L59","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_DND_HISTORY",0,14,2,1,0,0,3,1,0,0,0,{"$f":"13+B2*B60 + C2*C60 + D2*D60 + E2*E60 + F2*F60 + G2*G60 + H2*H60 + I2*I60 + J2*J60 + K2*K60 + L2*L60","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_IR",0,13,3,1,0,0,4,4,0,0,0,{"$f":"13+B2*B61 + C2*C61 + D2*D61 + E2*E61 + F2*F61 + G2*G61 + H2*H61 + I2*I61 + J2*J61 + K2*K61 + L2*L61","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+C2+B2","v":{"$error":"#REF!"}},{"$f":"P2+C2+B2","v":{"$error":"#REF!"}}]
["G_IR_HISTORY",0,9,2,1,1,0,2,2,0,0,0,{"$f":"13+B2*B62 + C2*C62 + D2*D62 + E2*E62 + F2*F62 + G2*G62 + H2*H62 + I2*I62 + J2*J62 + K2*K62 + L2*L62","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+I2+F2","v":{"$error":"#REF!"}},0,0,0]
["G_IS_LINK",0,15,2,1,0,0,4,2,0,0,1,{"$f":"13+B2*B63 + C2*C63 + D2*D63 + E2*E63 + F2*F63 + G2*G63 + H2*H63 + I2*I63 + J2*J63 + K2*K63 + L2*L63","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2+B2","v":{"$error":"#REF!"}},0,0,0,0]
["G_IS_LINK_HISTORY",0,11,2,1,0,0,2,3,0,0,0,{"$f":"13+B2*B64 + C2*C64 + D2*D64 + E2*E64 + F2*F64 + G2*G64 + H2*H64 + I2*I64 + J2*J64 + K2*K64 + L2*L64","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_LOGIN_SESSION",0,17,2,1,0,0,3,2,0,0,0,{"$f":"13+B2*B65 + C2*C65 + D2*D65 + E2*E65 + F2*F65 + G2*G65 + H2*H65 + I2*I65 + J2*J65 + K2*K65 + L2*L65","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+C2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0]
["G_PARTY",0,22,2,1,0,0,4,4,0,0,1,{"$f":"13+B2*B66 + C2*C66 + D2*D66 + E2*E66 + F2*F66 + G2*G66 + H2*H66 + I2*I66 + J2*J66 + K2*K66 + L2*L66","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0]
["G_PARTY_HISTORY",0,20,2,1,0,0,3,2,0,0,0,{"$f":"13+B2*B67 + C2*C67 + D2*D67 + E2*E67 + F2*F67 + G2*G67 + H2*H67 + I2*I67 + J2*J67 + K2*K67 + L2*L67","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_PARTY_STAT",5,26,2,1,0,0,1,1,0,0,0,{"$f":"13+B2*B68 + C2*C68 + D2*D68 + E2*E68 + F2*F68 + G2*G68 + H2*H68 + I2*I68 + J2*J68 + K2*K68 + L2*L68","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0,0]
["G_ROUTE_RESULT",0,16,2,1,0,0,3,9,0,0,3,{"$f":"13+B2*B69 + C2*C69 + D2*D69 + E2*E69 + F2*F69 + G2*G69 + H2*H69 + I2*I69 + J2*J69 + K2*K69 + L2*L69","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_SECURE_USERDATA_HISTORY",0,16,2,0,1,0,2,2,1,0,2,{"$f":"13+B2*B70 + C2*C70 + D2*D70 + E2*E70 + F2*F70 + G2*G70 + H2*H70 + I2*I70 + J2*J70 + K2*K70 + L2*L70","v":{"$error":"#REF!"}},{"$f":"P2+F2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_USERDATA_HISTORY",0,16,2,0,1,0,2,2,1,0,2,{"$f":"13+B2*B71 + C2*C71 + D2*D71 + E2*E71 + F2*F71 + G2*G71 + H2*H71 + I2*I71 + J2*J71 + K2*K71 + L2*L71","v":{"$error":"#REF!"}},{"$f":"P2+F2","v":{"$error":"#REF!"}},0,0,0,0,0]
["G_VIRTUAL_QUEUE",0,26,2,1,0,0,3,6,0,0,4,{"$f":"13+B2*B72 + C2*C72 + D2*D72 + E2*E72 + F2*F72 + G2*G72 + H2*H72 + I2*I72 + J2*J72 + K2*K72 + L2*L72","v":{"$error":"#REF!"}},{"$f":"P2+F2","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},0,0,0]
["GOX_CHAIN_CALL",0,8,2,1,0,0,2,1,2,0,0,{"$f":"13+B2*B73 + C2*C73 + D2*D73 + E2*E73 + F2*F73 + G2*G73 + H2*H73 + I2*I73 + J2*J73 + K2*K73 + L2*L73","v":{"$error":"#REF!"}},{"$f":"P2+F2","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+I2","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0]
["GO_CAMPAIGN",0,26,2,1,0,0,4,0,1,0,0,{"$f":"13+B2*B74 + C2*C74 + D2*D74 + E2*E74 + F2*F74 + G2*G74 + H2*H74 + I2*I74 + J2*J74 + K2*K74 + L2*L74","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+J2","v":{"$error":"#REF!"}},0,0,0,0]
["GO_CAMPAIGNHISTORY",0,16,2,1,0,0,3,0,1,0,0,{"$f":"13+B2*B75 + C2*C75 + D2*D75 + E2*E75 + F2*F75 + G2*G75 + H2*H75 + I2*I75 + J2*J75 + K2*K75 + L2*L75","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GO_CAMPPROP_HIST",0,33,2,1,0,0,5,0,1,0,0,{"$f":"13+B2*B76 + C2*C76 + D2*D76 + E2*E76 + F2*F76 + G2*G76 + H2*H76 + I2*I76 + J2*J76 + K2*K76 + L2*L76","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GO_CHAIN",0,23,2,1,0,0,4,0,4,0,0,{"$f":"13+B2*B77 + C2*C77 + D2*D77 + E2*E77 + F2*F77 + G2*G77 + H2*H77 + I2*I77 + J2*J77 + K2*K77 + L2*L77","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+J2","v":{"$error":"#REF!"}},0,0,0,0]
["GO_CHAINREC_HIST",0,26,2,1,0,0,3,0,2,0,0,{"$f":"13+B2*B78 + C2*C78 + D2*D78 + E2*E78 + F2*F78 + G2*G78 + H2*H78 + I2*I78 + J2*J78 + K2*K78 + L2*L78","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GO_CUSTOM_FIELDS",0,15,2,1,0,0,4,0,1,0,1,{"$f":"13+B2*B79 + C2*C79 + D2*D79 + E2*E79 + F2*F79 + G2*G79 + H2*H79 + I2*I79 + J2*J79 + K2*K79 + L2*L79","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+J2","v":{"$error":"#REF!"}},{"$f":"P2+J2+C2+C2","v":{"$error":"#REF!"}},0,0,0]
["GO_FIELDHIST",0,14,2,1,0,0,3,1,1,0,2,{"$f":"13+B2*B80 + C2*C80 + D2*D80 + E2*E80 + F2*F80 + G2*G80 + H2*H80 + I2*I80 + J2*J80 + K2*K80 + L2*L80","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GO_METRICS",0,15,2,1,0,0,2,0,5,0,0,{"$f":"13+B2*B81 + C2*C81 + D2*D81 + E2*E81 + F2*F81 + G2*G81 + H2*H81 + I2*I81 + J2*J81 + K2*K81 + L2*L81","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]
["GO_RECORD",0,33,2,1,0,0,4,0,3,0,2,{"$f":"13+B2*B82 + C2*C82 + D2*D82 + E2*E82 + F2*F82 + G2*G82 + H2*H82 + I2*I82 + J2*J82 + K2*K82 + L2*L82","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+J2","v":{"$error":"#REF!"}},{"$f":"P2+J2+C2","v":{"$error":"#REF!"}},0,0,0]
["GO_SECURE_FIELDS",0,15,2,1,0,0,4,0,1,0,1,{"$f":"13+B2*B83 + C2*C83 + D2*D83 + E2*E83 + F2*F83 + G2*G83 + H2*H83 + I2*I83 + J2*J83 + K2*K83 + L2*L83","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},{"$f":"P2+J2","v":{"$error":"#REF!"}},{"$f":"P2+J2+C2+C2","v":{"$error":"#REF!"}},0,0,0]
["GO_SEC_FIELDHIST",0,14,2,1,0,0,3,1,1,0,2,{"$f":"13+B2*B84 + C2*C84 + D2*D84 + E2*E84 + F2*F84 + G2*G84 + H2*H84 + I2*I84 + J2*J84 + K2*K84 + L2*L84","v":{"$error":"#REF!"}},{"$f":"P2+E2","v":{"$error":"#REF!"}},0,0,0,0,0]

{"sheet":"UCS","index":17,"n_rows":57,"n_cols":2,"rows_kept":57}
["Universal Contact Server / Context Services 8.1"," "]
["Use this spreadsheet to estimate the size of the  Universal Contact Server database for your environment. Some examples are provided. Scroll over red marks for information.                                            1.  Change the values in the Number column to match your environment.                                                                                                   2. Estimated database sizes appear in the last rows."]
["Profile entries","Number"]
["Number of Profiles",{"v":500000,"d":"500,000"}]
["Number of defined Core Attributes",4]
["Number of defined Extensions",5]
["Number of fixed attributes in Extensions",5]
["Number of string attributes in Extensions",15]
["Average length of each string in Extensions",10]
["Number of defined identification keys",4]
["Number of fixed attributes in identification keys",0]
["Number of string attributes in identification keys",4]
["Average length of each string in identification keys",16]
["Estimations"]
["Profiles Core Size (MB)",{"$f":"NbProfile*((160+NbCoreAttribute*400))/ (1024*1024)","v":{"v":839.2333984375,"d":"839"}}]
["Profiles Extensions Size (MB)",{"$f":"NbProfile*((2*2*NbProfileExtensions*32)+(NbFixedAttrExtension*8)+(AvgStrLengthProfExt*2*2*NbStrAttrExtension)) / (1024*1024)","v":{"v":610.3515625,"d":"610"}}]
["Profile Identification Keys Size (MB)",{"$f":"NbProfile*NbIdKeys*((32+(NbFixedAttrsIdKeys*8+AvgLengthStringAttrsIdKeys*NbStringAttrsIdKeys)*2*2))/ (1024*1024)","v":{"v":549.31640625,"d":"549"}}]
["Total Profiles Size (MB)",{"$f":"SUM(B15:B17)","v":{"v":1998.9013671875,"d":"1,999"}}]
[]
["Service model entries (Context Services)","Number"]
["Number of Services per Day",{"v":100000,"d":"100,000"}]
["Services lifetime (days)",180]
["Number of States per Service",3]
["Number of Tasks per Service",6]
["Number of defined Service extensions",2]
["Number of fixed attributes in Service Extensions",10]
["Number of string attributes in Service Extensions",3]
["Average length of each string in Service Extensions",20]
["Number of defined State extensions",2]
["Number of fixed attributes in State extensions",10]
["Number of string attributes in State extensions",3]
["Average length of each string in State extensions",20]
["Number of defined Task extensions",2]
["Number of fixed attributes in Task Extensions",10]
["Number of string attributes in Task Extensions",3]
["Average length of each string in Task Extensions",20]
["Estimations"]
["Service only size (MB)",{"$f":"nbServicePerDay*serviceRetention*((500)+((NbServiceExtension*8)+(NbFixedAttrServiceExtension*8)+(NbStrAttrServiceExtension*2*2*AvgStrLengthServiceExtension))) / (1024*1024)","v":{"v":14350.89111328125,"d":"14,351"}}]
["State only size (MB)",{"$f":"nbServicePerDay*serviceRetention*NbStatePerService*((350)+((NbStateExtension*8*2)+(NbFixedAttrStateExtension*8)+(NbStrAttrStateExtension*2*2*AvgStrLengthStateExtension))) / (1024*1024)","v":{"v":36151.885986328125,"d":"36,152"}}]
["Task only size (MB)",{"$f":"nbServicePerDay*serviceRetention*NbTaskPerService*((350)+((NbTaskExtension*8*3)+(NbFixedAttrTaskExtension*8)+(NbStrAttrTaskExtension*2*2*AvgStrLengthTaskExtension))) / (1024*1024)","v":{"v":73951.72119140625,"d":"73,952"}}]
["Total CS Size (MB)",{"$f":"SUM(B38:B40)","v":{"v":124454.49829101563,"d":"124,454"}}]
[]
["Interaction model entries","Number"]
["Average e-mail size (KB)",25]
["Average attachment size (KB)",6]
["Percentage of e-mails with attachments",15]
["Average Auto-reply size (KB)",10]
["Number of Contacts",0]
["E-mail interactions per day",{"v":100000,"d":"100,000"}]
["Chat interactions per day",{"v":5000,"d":"5,000"}]
["UCS database lifetime (days)",365]
["Estimations"]
["Total UCS DB Size (MB)",{"$f":"(((nbEmailPerDay*1024*AvgEmailSize) +(6700+2*AutoReplySize*nbEmailPerDay)+((PercentageOfEmailsWithAttachement*nbEmailPerDay)/100) * (1300+(AttachementSize*1024))+ nbChatPerDay*1024*5)*interactionRetention + nbContact*1024)/(1024*1024)","v":{"v":939590.7835960388,"d":"939,591"}}]
[]
["Total UCS/CS DB Size (MB)",{"$f":"SUM(B53,B41)","v":{"v":1064045.2818870544,"d":"1,064,045"}}]
[]
["Run-time DB Size required (MB)",{"$f":"totalUCSCS*1.3","v":{"v":1383258.8664531708,"d":"1,383,259"}}]