问题描述
嗨。
我正在尝试做一些我认为相当简单的事情。原来不是。至少不适合我。
I am trying to do something I thought would be rather simple. Turned out not to be. At least not for me.
我想提取部门中所有人（资源）的年度使用百分比。那可能吗？优选以全年等效的格式。即每年有多少小时的资源/人被分配到任务除以每年
的工作小时数。这可能吗？
I want to extract annual usage percentages for all the people (resources) in a department. Is that possible? Preferebly in the format of full year equivalent. I.e how many hours per year has a resource/person been allocated to a task divided by the number of working hours per year. Is that possible?
祝你好运。
推荐答案
对于这类数据，您可能需要VBA来收集每个资源的年度小时数，计算FTE（年度）并将结果转储到额外的字段中。所以是的，当然可行且可行。
For that kind of data you will probably need VBA to gather the annual hours of each resource, calculate the FTE (annual) and dump the result into an extra field. So yes, certainly possible and doable.
John
这篇关于年度用量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！