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
Microsoft ExcelMath / Science

Avatar of undefined
Last Comment
Damarado

8/22/2022 - Mon
Dirk Mare

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

DirkMare
Dirk Mare

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

DirkMare
ASKER
Damarado

@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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Danny Child

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 Mare

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 Child

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...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Damarado

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
Danny Child

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Damarado

Great help