![]() |
X Factor into Percent...
So I have an entry field where I am putting a number, usually between 1 and
4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is. How much storage savings. Any suggestions? Joe |
X Factor into Percent...
Isn't it just:
=1 / X_factor expressed/formatted as a percentage? Hope this helps. Pete On Feb 24, 1:10*am, Joseph Hand wrote: So I have an entry field where I am putting a number, usually between 1 and 4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is.. How much storage savings. Any suggestions? Joe |
X Factor into Percent...
You know when you stare at something for so long, you can't see it clear head
on? Thank you Pete! joe "Pete_UK" wrote: Isn't it just: =1 / X_factor expressed/formatted as a percentage? Hope this helps. Pete On Feb 24, 1:10 am, Joseph Hand wrote: So I have an entry field where I am putting a number, usually between 1 and 4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is.. How much storage savings. Any suggestions? Joe . |
X Factor into Percent...
You're welcome, Joe - thanks for feeding back.
Pete On Feb 24, 3:37*am, Joseph Hand wrote: You know when you stare at something for so long, you can't see it clear head on? Thank you Pete! joe "Pete_UK" wrote: Isn't it just: =1 / X_factor expressed/formatted as a percentage? Hope this helps. Pete On Feb 24, 1:10 am, Joseph Hand wrote: So I have an entry field where I am putting a number, usually between 1 and 4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is.. How much storage savings. Any suggestions? Joe .- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com