Link to home
Start Free TrialLog in
Avatar of Damarado
Damarado

asked on

File Server Growth.

Hi All,

I have being giving the task to forecast the rate of growth within our File-Server
currently i am using a trial version of Tree Size Professional to get the total file size of uploads per month from Jan 14 - Jan 16.

from my inputs into Excel  i would like to know how can i get a forecast and also to display a trend graph.

i have uploaded the Excel sheet to give you a better understanding on my layout.

any help would be appreciate
Book21.xls
Avatar of Dirk Mare
Dirk Mare
Flag of South Africa image

December 2016 has actual growth (6.4) can I remove it?

DirkMare
Also if I can get the starting GB for Jan 2014. (Total Size)

DirkMare
Avatar of Damarado
Damarado

ASKER

@Dirk

Jan 2016 had a total of 4.4 GB uploaded

Dec 2015 had a total of 6.4GB

Jan  2014 had a total of 3.1GB uploaded.

Thanks.
The way your data is grouped tends to imply that you have a similar upload pattern for each MONTH, not across the year.

The problem with this is that many of your months only have 2 data points, so any prediction is unreliable.  Even the ones that have 3 show a trend reversal on the middle month, implying that your uploads don't follow trends.

Please see the attached sheet where I've made sparkline charts for each month, and an overall chart for all the months in chronological order.

The short answer is your data growth is fairly flat, but is unpredictable.
M--Personal-Server-growth.xlsx
On the excel spreadsheet; December 2016 has 6.4GB of data? I will remove this entry.
User generated image
Jan  2014 had a total of 3.1GB uploaded.
meaning December 2013 had 0GB (Zero GB) or please provide the correct amount.

Just trying to establish a starting point for growth

DirkMare
The only conclusion you could draw is that perhaps your summer months May Jun Jul are downward, and the rest are upward, but it's not very reliable...
Hi thanks for the help

here is what i have on Sheet 2 of the Excel Sheet.

i have used the average sum as the function
Book21.xls
ASKER CERTIFIED SOLUTION
Avatar of Danny Child
Danny Child
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great help