Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by theblot
-
Calculating Exponential Function slope, using only partial data
Yea, here's what I did. I constructed the "slope" based on prior data. Then, I added the difference between the last data point in the list and the data point not in the list. Therefore, it'll include the increase in data, without affecting the slope.- theblot
- Post #9
- Forum: -Engineering spreadsheets
-
Calculating Exponential Function slope, using only partial data
This specific application is quite simple. We're calculating data storage on our network, to project how much storage we need to purchase for our company. Our data samples are from the backup routine that runs once a week. Well, for the past two weeks, we consolidated a massive amount of data...- theblot
- Post #7
- Forum: -Engineering spreadsheets
-
Calculating Exponential Function slope, using only partial data
Yes, but again, I need to exclude data from the slope, but include it into the final results. Here's an example: Let's say every week, I'm increasing exponentially by 1. So it goes as such: 1,2,4,8,16,32,etc... But two weeks, it's off by a lot: 1,2,4,8,16,58,65, etc... How can I figure out...- theblot
- Post #3
- Forum: -Engineering spreadsheets
-
Calculating Exponential Function slope, using only partial data
Here's the situation: We're trying to project growth over a few years using our past data for reference. Simple exponential trendline, right? The problem is that in the last two weeks, we saw a massive jump which was out of average and will likely not happen again. If I was using a linear...- theblot
- Thread
- Replies: 13
- Forum: -Engineering spreadsheets
