Find Jobs
Hire Freelancers

Excel workbook with Erlang-C algorithms

$2-8 USD / hour

Imeghairiwa
Imechapishwa over 3 years ago

$2-8 USD / hour

II need to have an Excel workbook updated to the present capabilities of Excel. Te workbook has not been updated since 2011. I do call center consulting and I use the excel workbook to estimate the number of agents required to handle a specific number of calls at a specified rate of service. The workbook contains Erlang-c algorithm, macros, and user defined functions that can be inserted into cells in a worksheet in the same workbook. I also need the ability to embed these functions into a website. The main Function I need to work is EC_Agents(number of calls, Average Call Length in Seconds,After Call Wrap Time, Percent calls answered target, service target) This is an erlang C calculation. The function does the math when I select the cells for inputs. When you insert the function it works like any other function EC_Agents(cell for call volume, cell for call length, cell for wrap-up time, cell for percent calls answered, cell for service target) In a call center the service rate objective is defined the percent of the incoming calls that must be answered with X seconds The phone system in a call center has lines for all of the agents and queue positions that calls wait in when all of the agents ae on calls. the phone system tracks how long the calls wait in the queue. The objective is to have the agents answer the calls in queue calls quickly .So if the target is to answer 90% of the total calls within 20 seconds or less the algorithm calculates the number of agents you need to answer the calls quickly. I need the ability to enter target wait times up to 24 hours (expressed in seconds) let me know if you have any other questions. The attached file is zipped: This is a link to the file in my Dropbox. [login to view URL]
Kitambulisho cha mradi: 28478865

Kuhusu mradi

4 mapendekezo
Mradi wa mbali
Inatumika 3 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
4 wafanyakazi huru wana zabuni kwa wastani $7 USD/saa kwa kazi hii
Picha ya Mtumiaji
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.
$5 USD ndani ya siku 40
4.9 (156 hakiki)
6.4
6.4
Picha ya Mtumiaji
Hi, I had completed one project of Erlang-C algorithms in past, Please send me a message to discuss further, Thanks
$10 USD ndani ya siku 40
4.9 (82 hakiki)
6.0
6.0
Picha ya Mtumiaji
Dear, I am very interested in your project and I can help you with it . I am an engineer with +17 years working on data (entry, processing and analysis) with excel and power bi now. Feel free to reach out to me via chat. Thank you for the opportunity. At the end you will be 100% satisfied by my job.
$6 USD ndani ya siku 40
5.0 (2 hakiki)
1.0
1.0
Picha ya Mtumiaji
$5 USD ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Rapids, United States
0.0
0
Mwanachama tangu Des 8, 2020

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.