Personnel Workload Calculations

[TST3]

Very new and in need of help. I have a db that captures/tracks/models work cycle time within an organization. I have a field that uses a value list for Year, semi-annual, month, week, day. I also have a field that captures the reported cycle time of the work per work item, and a field for the number of times the work item is accomplished if it is other than indicated in the frequency field. Somewhere I need to have time normalized to weekly from year, semi-annual, month, and day and by count. If I haven't totally confused anyone, I'd appreciate help. I had created a very primitive version in MSExcel, however, that method is time consuming as the db is growing large and more complicated.

[Ender]

I don't get all of what you are doing, but I'd suggest normalizing to days, since that is the smallest unit available. It can then be easily converted to weeks, if necessary.

 

The tricky part could be deciding how many days are in the selected unit. If it's a fixed number, like 30 for the number of days in a month, or 365 for the number of days in a year, then it's not totally accurate, but more of an estimate. If this isn't precise enough, you'll need to factor in the dates that the period covers, and calculate based on that.