Forum Discussion
Expansion and interpolation of dated dated
Nope -- I managed to take all your blank dates and develop numbers using TREND...but the results are pretty clearly not what you want. I do think they're an accurate TREND line, but because your overall trend in the productivity numbers is upward over the two years in questions, that general upward trend is what the TREND produced numbers show....increasing by approximately 1/1000th with each new entry. That is NOT an interpolation, however, between the last worked day and the next worked day.
It might be possible to use TREND on a monthly basis, say , for work days missed during any given month....but with over two years of data, that general trend is too general to be meaningful in the granularity of specific weekends.
was an interesting exercise, but didn't produce the outcome you wanted.
Let me add one new function to that series I gave you earlier as functions you might want to study and try: OFFSET.
And you asked about coming back and posting. First, it's entirely possible that somebody far more expert than I might pick up this thread. But if not, after you've continued a few other things on your own, you might come back and start a new thread. It wouldn't be bad to mention a link to this thread, just to keep people from going down blind alleys.
There was an attached word document, but not an Excel sheet. When you do upload the sheet itself, I hope it will be clear what you're asking. Your opening description makes it clear that you understand what you're to do, but it's still pretty abstract (i,e., vague) to those of us who are less closely involved.
Are you asking for
- help in evaluating the productivity data
- or help in expanding the dated columns to include. (etc)...
- or help in interpolation of productivity data for off working days
- or all of the above?
In any case, I hope those questions make clear what needs to be clarified.
Thanks for the information. I will need to study the information to try to understand. It seems that most of the explanations/examples are a bit cryptic for my immediate understanding. I have no doubt the solution to my problem is there and I appreciate your sorting through history to help me.