ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   erlang C question (https://www.excelbanter.com/excel-discussion-misc-queries/83470-erlang-c-question.html)

Denniso6

erlang C question
 
I'm attempting to build a spreadsheet that calculates call-center staffing
requirements by half hour. Any recommendations as to how I get started would
be appricated.

Gary''s Student

erlang C question
 
Create a table with 48 rows of data ( one row for each half-hour in 24 hours )

In column A enter the estimated number of call received in that half-hour slot
In column B enter the estimated time to process a call (should include any
record-keeping overhead)

In column C enter:
=A1*B1/30

This is the minimum staffing. Include margin for people go on break, lunch,
etc.
--
Gary's Student


"Denniso6" wrote:

I'm attempting to build a spreadsheet that calculates call-center staffing
requirements by half hour. Any recommendations as to how I get started would
be appricated.


Denniso6

erlang C question
 
I'll try this!

Much appreciated. - D

"Gary''s Student" wrote:

Create a table with 48 rows of data ( one row for each half-hour in 24 hours )

In column A enter the estimated number of call received in that half-hour slot
In column B enter the estimated time to process a call (should include any
record-keeping overhead)

In column C enter:
=A1*B1/30

This is the minimum staffing. Include margin for people go on break, lunch,
etc.
--
Gary's Student


"Denniso6" wrote:

I'm attempting to build a spreadsheet that calculates call-center staffing
requirements by half hour. Any recommendations as to how I get started would
be appricated.


nur1

Quote:

Originally Posted by Denniso6 (Post 281014)
I'm attempting to build a spreadsheet that calculates call-center staffing
requirements by half hour. Any recommendations as to how I get started would
be appricated.

I am thinking about doing the same thing, have you managed to do this? If so, is there any advice you can give me as a person who was looking for the same thing. Cheers!


All times are GMT +1. The time now is 04:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com