Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make a spreadsheet idiot-proof | Excel Worksheet Functions | |||
I am an Idiot Woman | New Users to Excel | |||
Onboard Excel help...teach a man to fish... | Excel Discussion (Misc queries) | |||
I want 148:30 converted to 148.5 and I am an idiot | Excel Discussion (Misc queries) | |||
Excel Idiot Needs Formula Help!! | Excel Worksheet Functions |