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.
Thanks for responding. I'll study the INDEX, MATCH, ROW, INDIRECT functions and try to work it out. I'm not confident I will. I've struggled for a couple of days and have not progressed. After I study the functions and try to apply them, and fail, how can I re-post my need to the techcommunity? Is it possible they are monitoring my plight or do I need to take initiate another request for help? As you surely can tell, I'm totally ignorant of seeking help.
Thanks again.
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.