ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   X Factor into Percent... (https://www.excelbanter.com/excel-worksheet-functions/257193-x-factor-into-percent.html)

Joseph Hand

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

Pete_UK

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



Joseph Hand

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


.


Pete_UK

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