LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Help needed (idiot onboard)

Hi All,

I hope someone can help me with this; I've bashed a good-sized dent
in my desktop and would like to stop before the desk breaks
altogether.

I have a spreadsheet that I track my server hard drive free space on.
It does some basic averaging on consumption and the like. What I
would really like to be able to do is forecast when I am going to run
out of space.

I know the basics of what I want to do and I am sure I have all of the
parts, I just don't know how to cobble them together in a cell and
have it spit out my answer.

Here is what I have:

- Column A = today's date
- Column B = free bytes on HD
- Column C = byte change from yesterday (Btoday-Byesterday)
- A standalone cell that averages Column C (average daily consumption)

So; it should be a relatively simple FORECAST or TREND to tell me that
in x-number of days, I will reach x-number of bytes available.

If some kind soul is willing to help me along on this path, the amount
of gratitude poured forth would be excessive.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a spreadsheet idiot-proof Howard Excel Worksheet Functions 6 September 9th 09 08:42 PM
I am an Idiot Woman Pepper New Users to Excel 18 January 1st 09 01:10 AM
Onboard Excel help...teach a man to fish... NoMagic@Certegy Excel Discussion (Misc queries) 3 November 1st 06 04:06 PM
I want 148:30 converted to 148.5 and I am an idiot element04 Excel Discussion (Misc queries) 1 July 13th 06 01:41 AM
Excel Idiot Needs Formula Help!! Donna123 Excel Worksheet Functions 1 September 5th 05 05:28 AM


All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"