{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["README","Registration","Simulator"],"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/IntraDayMultiSkillSimulator.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, September 7th, 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":"Simulator","index":2,"n_rows":118,"n_cols":14,"rows_kept":118,"cut":false,"hidden":false,"merged":[[2,8,2,13],[10,8,10,13],[69,8,69,13],[2,1,2,5],[10,1,10,5],[69,1,69,5]]}
["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]
["Average handling time",8.65,9.1666666666666661,12.716666666666667,10.65,13.216666666666667,null,1,1,null,null,null,null,1]
["Average patience",10,10,10,10,10,null,2,null,1,null,null,null,1]
["Redial probability",0.1,0.1,0.1,0.1,0.1,null,3,null,null,1,null,null,1]
["Average redial time",60,60,60,60,60,null,4,null,null,null,1,null,1]
["Acceptable waiting time",{"$f":"20/60","v":0.33333333333333331},{"$f":"20/60","v":0.33333333333333331},0.33333333333333331,0.33333333333333331,0.33333333333333331,null,5,null,null,null,null,1,1]
[]
[null,"Forecast",null,null,null,null,null,null,"Staffing"]
["00:00 - 00:30",null,null,null,null,null,null,"00:00 - 00:30"]
["00:30 - 01:00",null,null,null,null,null,null,"00:30 - 01:00"]
["01:00 - 01:30",null,null,null,null,null,null,"01:00 - 01:30"]
["01:30 - 02:00",null,null,null,null,null,null,"01:30 - 02:00"]
["02:00 - 02:30",null,null,null,null,null,null,"02:00 - 02:30"]
["02:30 - 03:00",null,null,null,null,null,null,"02:30 - 03:00"]
["03:00 - 03:30",null,null,null,null,null,null,"03:00 - 03:30"]
["03:30 - 04:00",null,null,null,null,null,null,"03:30 - 04:00"]
["04:00 - 04:30",null,null,null,null,null,null,"04:00 - 04:30"]
["04:30 - 05:00",null,null,null,null,null,null,"04:30 - 05:00"]
["05:00 - 05:30",null,null,null,null,null,null,"05:00 - 05:30"]
["05:30 - 06:00",null,null,null,null,null,null,"05:30 - 06:00"]
["06:00 - 06:30",null,null,null,8,null,null,"06:00 - 06:30",null,null,null,2]
["06:30 - 07:00",null,null,null,5,null,null,"06:30 - 07:00",null,null,null,1]
["07:00 - 07:30",null,null,6,10,null,null,"07:00 - 07:30",null,null,2,3]
["07:30 - 08:00",null,null,14,42,null,null,"07:30 - 08:00",null,null,5,14]
["08:00 - 08:30",66,82,82,172,26,null,"08:00 - 08:30",19,25,34,61,11,20]
["08:30 - 09:00",150,154,138,264,48,null,"08:30 - 09:00",43,47,58,93,21,20]
["09:00 - 09:30",200,224,234,430,90,null,"09:00 - 09:30",57,68,99,152,39,20]
["09:30 - 10:00",260,240,294,580,104,null,"09:30 - 10:00",74,73,124,205,45,20]
["10:00 - 10:30",260,266,346,588,94,null,"10:00 - 10:30",74,81,146,208,41,20]
["10:30 - 11:00",186,184,340,498,76,null,"10:30 - 11:00",53,56,144,176,33,20]
["11:00 - 11:30",222,224,410,562,74,null,"11:00 - 11:30",64,68,173,199,32,20]
["11:30 - 12:00",248,256,448,622,80,null,"11:30 - 12:00",71,78,189,220,35,20]
["12:00 - 12:30",202,246,488,582,92,null,"12:00 - 12:30",58,75,206,206,40,20]
["12:30 - 13:00",198,186,452,472,82,null,"12:30 - 13:00",57,56,191,167,36,20]
["13:00 - 13:30",204,220,530,566,78,null,"13:00 - 13:30",58,67,224,200,34,20]
["13:30 - 14:00",206,210,496,548,74,null,"13:30 - 14:00",59,64,210,194,32,20]
["14:00 - 14:30",180,210,480,498,80,null,"14:00 - 14:30",51,64,203,176,35,20]
["14:30 - 15:00",222,204,522,608,102,null,"14:30 - 15:00",64,62,221,215,44,20]
["15:00 - 15:30",218,240,514,606,80,null,"15:00 - 15:30",62,73,217,215,35,20]
["15:30 - 16:00",184,196,530,652,72,null,"15:30 - 16:00",53,59,224,231,31,20]
["16:00 - 16:30",172,184,476,630,72,null,"16:00 - 16:30",49,56,201,223,31,20]
["16:30 - 17:00",212,178,512,690,82,null,"16:30 - 17:00",61,54,217,244,36,20]
["17:00 - 17:30",162,190,506,630,76,null,"17:00 - 17:30",46,58,214,223,33,20]
["17:30 - 18:00",150,150,486,480,68,null,"17:30 - 18:00",43,45,206,170,29,20]
["18:00 - 18:30",106,182,528,546,56,null,"18:00 - 18:30",30,55,223,193,24,20]
["18:30 - 19:00",86,126,460,416,58,null,"18:30 - 19:00",24,38,194,147,25,20]
["19:00 - 19:30",84,136,518,442,62,null,"19:00 - 19:30",24,41,219,156,27,20]
["19:30 - 20:00",60,94,494,438,56,null,"19:30 - 20:00",17,28,209,155,24,20]
["20:00 - 20:30",24,36,506,498,46,null,"20:00 - 20:30",6,11,214,176,20,20]
["20:30 - 21:00",null,null,498,476,46,null,"20:30 - 21:00",null,null,211,168,20]
["21:00 - 21:30",null,null,424,382,44,null,"21:00 - 21:30",null,null,179,135,19]
["21:30 - 22:00",null,null,288,274,24,null,"21:30 - 22:00",null,null,122,97,10]
["22:00 - 22:30",null,null,194,174,10,null,"22:00 - 22:30",null,null,82,61,4]
["22:30 - 23:00",null,null,98,96,null,null,"22:30 - 23:00",null,null,41,34]
["23:00 - 23:30",null,null,56,40,null,null,"23:00 - 23:30",null,null,23,14]
["23:30 - 24:00",null,null,36,16,null,null,"23:30 - 24:00",null,null,15,5]
[]
[]
[]
[]
[]
[]
["Service level",0.78345299999999995,0.71286499999999997,0.76605800000000002,0.72687299999999999,0.76081299999999996,null,"Occupancy",0.91474699999999998,0.92544599999999999,0.94245699999999999,0.953704,0.88361699999999999,0.96778399999999998]
["Average speed of answer",0.227404,0.30291099999999999,0.289885,0.30252200000000001,0.32153799999999999]
["Abandonments",2.2503499999999999E-2,3.3333300000000003E-2,3.23395E-2,3.40062E-2,3.2762100000000002E-2]
[]
[null,"Service level",null,null,null,null,null,null,"Occupancy"]
["00:00 - 00:30",0,0,0,0,0,null,"00:00 - 00:30",0,0,0,0,0,0]
["00:30 - 01:00",0,0,0,0,0,null,"00:30 - 01:00",0,0,0,0,0,0]
["01:00 - 01:30",0,0,0,0,0,null,"01:00 - 01:30",0,0,0,0,0,0]
["01:30 - 02:00",0,0,0,0,0,null,"01:30 - 02:00",0,0,0,0,0,0]
["02:00 - 02:30",0,0,0,0,0,null,"02:00 - 02:30",0,0,0,0,0,0]
["02:30 - 03:00",0,0,0,0,0,null,"02:30 - 03:00",0,0,0,0,0,0]
["03:00 - 03:30",0,0,0,0,0,null,"03:00 - 03:30",0,0,0,0,0,0]
["03:30 - 04:00",0,0,0,0,0,null,"03:30 - 04:00",0,0,0,0,0,0]
["04:00 - 04:30",0,0,0,0,0,null,"04:00 - 04:30",0,0,0,0,0,0]
["04:30 - 05:00",0,0,0,0,0,null,"04:30 - 05:00",0,0,0,0,0,0]
["05:00 - 05:30",0,0,0,0,0,null,"05:00 - 05:30",0,0,0,0,0,0]
["05:30 - 06:00",0,0,0,0,0,null,"05:30 - 06:00",0,0,0,0,0,0]
["06:00 - 06:30",0,0,0,0.4,0,null,"06:00 - 06:30",0,0,0,0.48507699999999998,0,0]
["06:30 - 07:00",0,0,0,0,0,null,"06:30 - 07:00",0,0,0,1,0,0]
["07:00 - 07:30",0,0,1,0.5,0,null,"07:00 - 07:30",0,0,0.32900800000000002,0.71505099999999999,0,0]
["07:30 - 08:00",0,0,0.538462,1,0,null,"07:30 - 08:00",0,0,0.708399,0.58538100000000004,0,0]
["08:00 - 08:30",1,1,1,1,1,null,"08:00 - 08:30",0.63881200000000005,0.64436499999999997,0.60839699999999997,0.68518299999999999,0.37489499999999998,0.61371900000000001]
["08:30 - 09:00",0.94701999999999997,1,1,1,1,null,"08:30 - 09:00",0.72518000000000005,0.73340399999999994,0.80433600000000005,0.83923099999999995,0.71282800000000002,0.874413]
["09:00 - 09:30",0.80101999999999995,0.99504999999999999,1,0.97161600000000004,1,null,"09:00 - 09:30",0.85576799999999997,0.81373600000000001,0.82208800000000004,0.85671600000000003,0.70711199999999996,0.91920199999999996]
["09:30 - 10:00",0.65853700000000004,0.84848500000000004,1,0.85639200000000004,0.69158900000000001,null,"09:30 - 10:00",0.95513400000000004,0.89328600000000002,0.77507499999999996,0.91712499999999997,0.934446,0.96383200000000002]
["10:00 - 10:30",0.897872,0.83524900000000002,0.882521,0.97539500000000001,0.92156899999999997,null,"10:00 - 10:30",0.96623300000000001,0.93366099999999996,0.92655900000000002,0.962256,0.906416,0.99447799999999997]
["10:30 - 11:00",0.36686400000000002,0.379888,0.58507500000000001,0.57226600000000005,0.45070399999999999,null,"10:30 - 11:00",0.99819500000000005,0.99206799999999995,0.96884999999999999,0.99369200000000002,0.97469700000000004,0.99972799999999995]
["11:00 - 11:30",1,0.88687800000000006,1,0.80449800000000005,0.68539300000000003,null,"11:00 - 11:30",0.87765899999999997,0.86809199999999997,0.88063999999999998,0.98001199999999999,0.96013999999999999,0.98886099999999999]
["11:30 - 12:00",0.89271999999999996,0.83458600000000005,0.87844,0.99656900000000004,0.58333299999999999,null,"11:30 - 12:00",0.94054499999999996,0.94773700000000005,0.94952400000000003,0.92929600000000001,0.95279000000000003,0.98050199999999998]
["12:00 - 12:30",0.88461500000000004,0.52118600000000004,1,0.81003599999999998,0.62244900000000003,null,"12:00 - 12:30",0.95369899999999996,0.97393700000000005,0.88691900000000001,0.99237500000000001,0.97332200000000002,0.99933700000000003]
["12:30 - 13:00",0.77604200000000001,0.57228900000000005,0.98139500000000002,0.58956900000000001,1,null,"12:30 - 13:00",0.964449,0.96624600000000005,0.94836399999999998,0.97525600000000001,0.85335499999999997,0.99215100000000001]
["13:00 - 13:30",0.76554999999999995,0.88990800000000003,1,0.74176799999999998,1,null,"13:00 - 13:30",0.97108899999999998,0.88285800000000003,0.853715,0.97862300000000002,0.87417599999999995,0.99551900000000004]
["13:30 - 14:00",0.80512799999999995,0.48648599999999997,0.45454499999999998,0.91337100000000004,0.98305100000000001,null,"13:30 - 14:00",0.91792899999999999,0.98292599999999997,0.99698600000000004,0.96764300000000003,0.84010499999999999,0.99771100000000001]
["14:00 - 14:30",0.64814799999999995,0.56185600000000002,0.78290999999999999,0.89400000000000002,0.74712599999999996,null,"14:00 - 14:30",0.89926499999999998,0.96980599999999995,0.97897000000000001,0.95099199999999995,0.97306099999999995,0.99763500000000005]
["14:30 - 15:00",1,0.921296,1,0.98835300000000004,0.93203899999999995,null,"14:30 - 15:00",0.86212900000000003,0.93591500000000005,0.93188000000000004,0.93059800000000004,0.90468899999999997,0.95960500000000004]
["15:00 - 15:30",0.91203699999999999,0.80751200000000001,0.48744799999999999,0.99826099999999995,0.80821900000000002,null,"15:00 - 15:30",0.92098800000000003,0.92533299999999996,0.989541,0.94871000000000005,0.794462,0.99235399999999996]
["15:30 - 16:00",0.96551699999999996,0.92592600000000003,0.76383800000000002,0.61549900000000002,0.75903600000000004,null,"15:30 - 16:00",0.89263300000000001,0.92126799999999998,0.94903800000000005,0.98531899999999994,0.92126300000000005,0.99565199999999998]
["16:00 - 16:30",0.38372099999999998,0.175258,0.72045499999999996,0.344051,0.78082200000000002,null,"16:00 - 16:30",0.96477599999999997,0.99752399999999997,0.98048599999999997,0.99273500000000003,0.88713299999999995,0.99968100000000004]
["16:30 - 17:00",0.99512199999999995,0.67796599999999996,0.99595999999999996,0.98816599999999999,0.94736799999999999,null,"16:30 - 17:00",0.87688500000000003,0.97407600000000005,0.95219799999999999,0.94355699999999998,0.80074400000000001,0.98267899999999997]
["17:00 - 17:30",0.45033099999999998,0.87700500000000003,0.89939599999999997,0.14858099999999999,0.30666700000000002,null,"17:00 - 17:30",0.98977800000000005,0.96721500000000005,0.94889599999999996,0.99954699999999996,0.99090699999999998,1]
["17:30 - 18:00",0.59722200000000003,0.238095,0.53896100000000002,0.29368899999999998,0.84375,null,"17:30 - 18:00",0.95125999999999999,0.99641999999999997,0.96337499999999998,0.993807,0.90291100000000002,1]
["18:00 - 18:30",0.485981,0.81967199999999996,0.85610200000000003,0.856881,0.68965500000000002,null,"18:00 - 18:30",0.96926599999999996,0.913941,0.98012500000000002,0.91383700000000001,0.89693199999999995,0.99812000000000001]
["18:30 - 19:00",0.494253,0.10169499999999999,2.1326999999999999E-2,5.7356600000000001E-2,0.92592600000000003,null,"18:30 - 19:00",0.95413999999999999,0.99993600000000005,1,0.99999800000000005,0.71172199999999997,0.99996399999999996]
["19:00 - 19:30",1,0.86986300000000005,1,1,1,null,"19:00 - 19:30",0.77895300000000001,0.910304,0.90056400000000003,0.90171100000000004,0.80410300000000001,0.94135899999999995]
["19:30 - 20:00",0.75,0.55294100000000002,0.81128400000000001,0.50885000000000002,0.34482800000000002,null,"19:30 - 20:00",0.76215699999999997,0.93077900000000002,0.95652499999999996,0.988622,0.97873900000000003,0.99916799999999995]
["20:00 - 20:30",0.86363599999999996,0.66666700000000001,0.82300899999999999,1,0.97619,null,"20:00 - 20:30",0.84465599999999996,0.90514700000000003,0.96337200000000001,0.88645200000000002,0.869726,0.958928]
["20:30 - 21:00",0,0,0.59012900000000001,0.76888900000000004,0.56000000000000005,null,"20:30 - 21:00",0,0,0.992587,0.98249699999999995,0.971271,0]
["21:00 - 21:30",0,0,0.90314799999999995,0.219219,0.15151500000000001,null,"21:00 - 21:30",0,0,0.96754899999999999,0.999421,0.99769699999999994,0]
["21:30 - 22:00",0,0,0.102273,0.43032799999999999,0.15789500000000001,null,"21:30 - 22:00",0,0,0.99962200000000001,0.98929100000000003,0.99352600000000002,0]
["22:00 - 22:30",0,0,4.1095899999999998E-2,3.125E-2,0.8,null,"22:00 - 22:30",0,0,0.99995400000000001,0.99998699999999996,0.87185699999999999,0]
["22:30 - 23:00",0,0,0,0.382716,0,null,"22:30 - 23:00",0,0,1,0.99359900000000001,0,0]
["23:00 - 23:30",0,0,0.33333299999999999,0,0,null,"23:00 - 23:30",0,0,0.98910799999999999,1,0,0]
["23:30 - 24:00",0,0,0,0.222222,0,null,"23:30 - 24:00",0,0,0.99938800000000005,0.98907800000000001,0,0]