{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["README","Registration","2-Skill","Multi-Skill"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["README"]
[]
["This Excel file illustrates the use of the CCmath Long Term Multi-Skill Simulator"]
["It shows how the most commonly used functions are used"]
["The latest version of this file can be downloaded at:"]
["http://software.ccmath.com/simulator/LongTermMultiSkillSimulator-MAC.xlsm"]
["The user manual for this Excel sheet can be found at:"]
["http://http://software.ccmath.com/simulator/manual/"]
[]
["This workbook requires macros to be enabled"]
["Registration is needed to use the functions, see the Registration tab"]
["The module will be fully functional for 1 month after registration"]
[]
["For pricing information of a license: contact CCmath at info@ccmath.com"]
[]
["A short description of what can be found in the different tabs is as follows:"]
[null,"2-Skill: A long-term simulation for two skills. This simulator has more options for the simulation and is more precise for two skills"]
[null,"Multi-Skill: A long-term simulation for up to five skills and many skill groups."]
["These sheets produce answers based on simulations, so answers may differ slightly when calculations are repeated. "]
[]
[]
["Color coding"]
[null,"Input"]
[null,"Output"]
[]
["Version 1.3.2, October 3rd, 2016, © CCmath"]

{"sheet":"Registration","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Registration"]
[]
["Please click the button below to register",null,null,null,null,"To see the status on your license, click the button below"]
[]
[]
[]
[]
["Registration is required only once"]
["If the message reads \"Registration successful!\" or \"Product is already registered!\" then the simulator can be used"]
["Please contact CCmath if you get a different message"]

{"sheet":"2-Skill","index":2,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,1,12,2],[13,1,13,2],[2,1,2,2],[0,0,0,3]]}
["Multi-Skill Simulator"]
[]
[null,"Skills"]
["Type",1,2]
["FC",3,4,"per minute"]
["AHT",5,5,"minutes"]
["Patience",10,10,"minutes"]
["AWT",{"$f":"20/60","v":0.33333333333333331},{"$f":"20/60","v":0.33333333333333331},"minutes"]
[]
[null,null,null,"multi-skilled"]
["Agents",14,null,6]
[]
["Call assignment rule","Longest idle agent"]
["Call selection rule","Longest waiting call"]
[]
["Agent reservation threshold",0,0]
["Waiting time threshold",0,0,"minutes"]
[]
[]
[]
[]
["ASA","0,27144","0,249555","minutes"]
["SL","0,739712","0,751872"]
["Abandonments","0,0282531","0,025574"]
["Occupancy","0,856967","0,869742","0,91529"]

{"sheet":"Multi-Skill","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,8,2,13]]}
["Multi-Skill Simulator",null,null,null,null,null,null,"Number of groups"]
[null,null,null,null,null,null,null,6]
[null,"Skills",null,null,null,null,null,null,"Groups"]
[null,1,2,3,4,5,null,"Skill set",1,2,3,4,5,6]
["Forecast",4,4,4,4,4,"per minute",1,1,null,null,null,null,1]
["Average handling time",8.65,9.1666666666666661,12.716666666666667,10.65,13.216666666666667,"minutes",2,null,1,null,null,null,1]
["Average patience",10,10,10,10,10,"minutes",3,null,null,1,null,null,1]
["Redial probability",0.1,0.1,0.1,0.1,0.1,"minutes",4,null,null,null,1,null,1]
["Average redial time",60,60,60,60,60,"minutes",5,null,null,null,null,1,1]
["Acceptable waiting time",{"$f":"20/60","v":0.33333333333333331},{"$f":"20/60","v":0.33333333333333331},0.33333333333333331,0.33333333333333331,0.33333333333333331,"minutes"]
[null,null,null,null,null,null,null,"Available Agents",35,40,55,45,60,50]
[]
[]
[]
[]
["Average speed of answer",6.2595500000000001E-5,2.77887E-5,1.31742E-5,3.9363499999999997E-5,1.62168E-4,"minutes","Occupancy",0.73031500000000005,0.72958100000000004,0.77364999999999995,0.75824800000000003,0.76980099999999996,0.79442599999999997]
["Service level",0.99990100000000004,0.99997499999999995,1,1,0.99962499999999999]
["Abandonments",0,0,0,0,0]