mallorielane
New Member
- Joined
- Feb 9, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello! I am working on a project to combine three separate dialer (outboud call flows) markets into 1 dialer. More specifically, I am trying to determine the cadence that should be set for the dialer in order to make the appropriate amount of calls for each market.
Here is an example of what I am working with (the end goal being using a formula to determine cadence) Currently, I have the worksheet set to change based on different inputs. For instance, if I change outbound lines to 4, the calls/hours calculations will automatically change as well. This is what I am hoping to do with cadence, being that I will be working with different data every day. My goal is to evenly spread the calls out for all three markets over the course of the dialer run time (I don't want the dialer to call all of market 1, then move on to market 2. I would like it to call a specific number of market 1, then market 2, then market 3, then back to market 1 and so on) I may be wrong on this, but I thought it would be useful to calculate cadence based on 1 hour of run time. So if 360 calls are made an hour, 168 of them will be Market 1, 138 for market 2, and 53 for market 3. However, I cannot determine what the formula would look like for this. Any help would be greatly appreciated. Also, I realize that this might not make sense, so please let me know if there is any additional information needed in order to understand the ask.
Here is an example of what I am working with (the end goal being using a formula to determine cadence) Currently, I have the worksheet set to change based on different inputs. For instance, if I change outbound lines to 4, the calls/hours calculations will automatically change as well. This is what I am hoping to do with cadence, being that I will be working with different data every day. My goal is to evenly spread the calls out for all three markets over the course of the dialer run time (I don't want the dialer to call all of market 1, then move on to market 2. I would like it to call a specific number of market 1, then market 2, then market 3, then back to market 1 and so on) I may be wrong on this, but I thought it would be useful to calculate cadence based on 1 hour of run time. So if 360 calls are made an hour, 168 of them will be Market 1, 138 for market 2, and 53 for market 3. However, I cannot determine what the formula would look like for this. Any help would be greatly appreciated. Also, I realize that this might not make sense, so please let me know if there is any additional information needed in order to understand the ask.
