We help IT Professionals succeed at work.

File Server Growth.

130 Views
Last Modified: 2016-02-05
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
Comment
Watch Question

Dirk MareSystems Engineer (Acting IT Manager)
CERTIFIED EXPERT

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

DirkMare
Dirk MareSystems Engineer (Acting IT Manager)
CERTIFIED EXPERT

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

DirkMare

Author

Commented:
@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.
Danny ChildIT Manager

Commented:
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
Dirk MareSystems Engineer (Acting IT Manager)
CERTIFIED EXPERT

Commented:
On the excel spreadsheet; December 2016 has 6.4GB of data? I will remove this entry.
december 2016
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
Danny ChildIT Manager

Commented:
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...

Author

Commented:
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
IT Manager
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Great help
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.