Hi tricky one (for me).
I have a few systems needing to have 20% free hard disk space.
The systems are already in use and I cannot delete files.
So the Final total size of each disk must have 20% free.
Not as simple as getting a 39GB Drive and clearing 20% on it, since there is (for example) already 6GB in use..
I tried to write an excel formula, but I'm not sure this is straightforward. Can some one help.
I have been given figures for: 1. total disk space 2. Free space (GB) 3. Free Space (%) and I need to increment the hard disk size (new total) to have 20% free.
Total Space - Free Space(GB) = Used Space
Used Space + 25% = New Total
New Total - Total Space = Needed size increment.
When you add 25% to the Used space, you will get the figure for how big the drive space is needed to have Total size - 20% = Used Space.
B1 = Total Space
B2 = Free Space (GB)
then the formula for Needed increment would be: =(B1-B2)*1,25-B1
and for New Total, just remove the -B1 at the end.
EDIT: Added excel info.