如何计算客户类型在一年中最可能需要的努力
我知道每个客户大小的每个销售代表每年都有多少个客户。是否可以根据此数据集来计算每个客户大小所需的时间/精力？或说不同的是，我试图找出比小客户是否需要更多或更少的努力。
Excel中是否有函数或公式可以根据以下数据集回答上述内容？
为了添加一些上下文，以防有帮助。一年有2080个工作小时。我假设他们全力以赴与客户一起责任。我还希望最大的客户比小客户需要更多的时间，但我不知道更多。这就是我要弄清楚的。有些员工的客户确实比其他员工要多得多，因此最好最好看一下每个员工客户规模之间的相对差异...
客户大小的额定值从0（非常小）到7（最大）。
以下是大数据表的小数据提取物
I know how many customers of each customer-size group each sales representative handles on an annual basis. Is it possible to calculate the likely time/effort required by each customer size based on this data set? Or said differently, I'm trying to find out if larger customers require more or less effort than smaller customers.
Is there a function or formula in Excel that will allow be to answer the above based on the data set below?
To add some context, in case it is helpful. There are 2080 work hours a year. I'm assuming they spend all their time with the customers under their responsibility. I also expect that the largest customers require more time than a small customers, but I dont know how much more. That is what I'm trying to figure out. Some employees do handle a lot more customers than others, so its probably best to look a the relative difference between the customer sizes for each employee...
Customer size is rated from 0 (very small) to 7 (the largest).
Below is a small data extract of a large Data table
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论