Convert MB to TB in Excel 2016

[shawnb86]

Hi I have data that I input in to a chart but the output is MBs and id prefer TB due to the large sizes of data. Could anyone help with a formula?

Thanks!

 

[Michael M]

??????

the output is MBs and id prefer TB

Would you like to provide a little more info ?

 

[shawnb86]

sorry, here is an example from the spreadsheet:

Platform	3-Oct
AIX	2317951
WIN	8503907
LINUX x86	6372989
LinuxPPC64	127594.9
DB2/6000	56299.84
DB2/AIX64	544812.9
SQL	8059679
DOMINO	199481.8
ORACLE	5330958

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[shawnb86]

this data is manual input. I would like for it to be

Platform	3-Oct
AIX	2.3179 TB

<tbody>
</tbody>

 

[shg]

Technically, a TB is 10^12 bits, but common usage is 2^40 (which is a TebiByte). Pick your poison.

	A​	B​	C​	D​
1​	Platform​	MB​	TB​	​
2​	AIX	2,317,951.00​	2.21​	C2: =B2/2^20
3​	WIN	8,503,907.00​	8.11​
4​	LINUX x86	6,372,989.00​	6.08​
5​	LinuxPPC64	127,594.90​	0.12​
6​	DB2/6000	56,299.84​	0.05​
7​	DB2/AIX64	544,812.90​	0.52​
8​	SQL	8,059,679.00​	7.69​
9​	DOMINO	199,481.80​	0.19​
10​	ORACLE	5,330,958.00​	5.08​
11​
12​	Platform​	MB​	TB​	​
13​	AIX	2,317,951.00​	2.32​	C13: =B13/1000000
14​	WIN	8,503,907.00​	8.50​
15​	LINUX x86	6,372,989.00​	6.37​
16​	LinuxPPC64	127,594.90​	0.13​
17​	DB2/6000	56,299.84​	0.06​
18​	DB2/AIX64	544,812.90​	0.54​
19​	SQL	8,059,679.00​	8.06​
20​	DOMINO	199,481.80​	0.20​
21​	ORACLE	5,330,958.00​	5.33​

 

[shawnb86]

thank you! my only issue with this is that with many days of data in my chart it will be tough to read for management. do i have any other options or is this my best bet?

Technically, a TB is 10^12 bits, but common usage is 2^40 (which is a TebiByte). Pick your poison.

	A​	B​	C​	D​
1​	Platform​	MB​	TB​
2​	AIX	2,317,951.00​	2.21​	C2: =B2/2^20
3​	WIN	8,503,907.00​	8.11​
4​	LINUX x86	6,372,989.00​	6.08​
5​	LinuxPPC64	127,594.90​	0.12​
6​	DB2/6000	56,299.84​	0.05​
7​	DB2/AIX64	544,812.90​	0.52​
8​	SQL	8,059,679.00​	7.69​
9​	DOMINO	199,481.80​	0.19​
10​	ORACLE	5,330,958.00​	5.08​
11​
12​	Platform​	MB​	TB​
13​	AIX	2,317,951.00​	2.32​	C13: =B13/1000000
14​	WIN	8,503,907.00​	8.50​
15​	LINUX x86	6,372,989.00​	6.37​
16​	LinuxPPC64	127,594.90​	0.13​
17​	DB2/6000	56,299.84​	0.06​
18​	DB2/AIX64	544,812.90​	0.54​
19​	SQL	8,059,679.00​	8.06​
20​	DOMINO	199,481.80​	0.20​
21​	ORACLE	5,330,958.00​	5.33​

<tbody>
</tbody>

 

[shg]

What could be easier to read?

Oops on the definition:

10^12 bytes = 1 Terabyte (TB)

2^40 bytes = 1 Tebibyte (TiB)

 

[shawnb86]

Reason being is the chart has many days. Oct 3, 4, 5, etc etc for 30+days

What could be easier to read?

Oops on the definition:

10^12 bytes = 1 Terabyte (TB)

2^40 bytes = 1 Tebibyte (TiB)

 

[macfuller]

The formula doesn't affect the data display... If you want that granularity of data it's hard to know how to re-format it to make it easier to digest.

The numbers in your example seem fairly stable for each platform, so you could provide a running 7-day average of each platform. Or you could put the platform data into a 30-day line chart with each series as a platform. Or provide a baseline average and only highlight days or amounts where the usage was above or below that baseline - the good ol' traffic light metaphor for each platform.

 

[shawnb86]

here is how my data is displayed going all the way to todays date and growing daily:

all this data has to go in to a line graph for mgmt. any advice on how to format better?

	Date
Platform	3-Oct	4-Oct	5-Oct
AIX (mb)	2317951	2328039	2479165
AIX (TB)	2.317951	2.328039	2.479165
WIN (mb)	8503907	11200978	7077588
WIN (TB)
LINUX x86 (mb)	6372989	6367421	7312388
LINUX x86 (TB)
LinuxPPC64 (mb)	127594.9	133857.4	124766.7
LinuxPPC64 (TB)
DB2/6000 (mb)	56299.84	60682.48	65968.27
DB2/6000 (TB)
DB2/AIX64 (mb)	544812.9	479300.3	494746.6
DB2/AIX64 (TB)
SQL (mb)	8059679	8184756	8687237
SQL (TB)
DOMINO (mb)	199481.8	76690.6	2484354
DOMINO (TB)	0.199482
ORACLE (mb)	5330958	3321268	5486001
ORACLE (TB)	5.330958

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>