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:

[TABLE="width: 142"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Platform[/TD]
[TD="align: right"]3-Oct[/TD]
[/TR]
[TR]
[TD]AIX[/TD]
[TD="align: right"]2317951[/TD]
[/TR]
[TR]
[TD]WIN[/TD]
[TD="align: right"]8503907[/TD]
[/TR]
[TR]
[TD]LINUX x86[/TD]
[TD="align: right"]6372989[/TD]
[/TR]
[TR]
[TD]LinuxPPC64[/TD]
[TD="align: right"]127594.9[/TD]
[/TR]
[TR]
[TD]DB2/6000 [/TD]
[TD="align: right"]56299.84[/TD]
[/TR]
[TR]
[TD]DB2/AIX64[/TD]
[TD="align: right"]544812.9[/TD]
[/TR]
[TR]
[TD]SQL[/TD]
[TD="align: right"]8059679[/TD]
[/TR]
[TR]
[TD]DOMINO[/TD]
[TD="align: right"]199481.8[/TD]
[/TR]
[TR]
[TD]ORACLE[/TD]
[TD="align: right"]5330958[/TD]
[/TR]
</tbody>[/TABLE]

 

[shawnb86]

this data is manual input. I would like for it to be [TABLE="class: cms_table, width: 142"]
<tbody>[TR]
[TD]Platform[/TD]
[TD="align: right"]3-Oct[/TD]
[/TR]
[TR]
[TD]AIX[/TD]
[TD="align: right"]2.3179 TB[/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

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

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Platform​

[/td][td="bgcolor:#F3F3F3"]

MB​

[/td][td="bgcolor:#F3F3F3"]

TB​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]AIX[/td][td]

2,317,951.00​

[/td][td]

2.21​

[/td][td]C2: =B2/2^20[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]WIN[/td][td]

8,503,907.00​

[/td][td]

8.11​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]LINUX x86[/td][td]

6,372,989.00​

[/td][td]

6.08​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]LinuxPPC64[/td][td]

127,594.90​

[/td][td]

0.12​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]DB2/6000[/td][td]

56,299.84​

[/td][td]

0.05​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]DB2/AIX64[/td][td]

544,812.90​

[/td][td]

0.52​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]SQL[/td][td]

8,059,679.00​

[/td][td]

7.69​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]DOMINO[/td][td]

199,481.80​

[/td][td]

0.19​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]ORACLE[/td][td]

5,330,958.00​

[/td][td]

5.08​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td="bgcolor:#F3F3F3"]

Platform​

[/td][td="bgcolor:#F3F3F3"]

MB​

[/td][td="bgcolor:#F3F3F3"]

TB​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]AIX[/td][td]

2,317,951.00​

[/td][td]

2.32​

[/td][td]C13: =B13/1000000[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]WIN[/td][td]

8,503,907.00​

[/td][td]

8.50​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]LINUX x86[/td][td]

6,372,989.00​

[/td][td]

6.37​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

16​

[/td][td]LinuxPPC64[/td][td]

127,594.90​

[/td][td]

0.13​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

17​

[/td][td]DB2/6000[/td][td]

56,299.84​

[/td][td]

0.06​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

18​

[/td][td]DB2/AIX64[/td][td]

544,812.90​

[/td][td]

0.54​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

19​

[/td][td]SQL[/td][td]

8,059,679.00​

[/td][td]

8.06​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

20​

[/td][td]DOMINO[/td][td]

199,481.80​

[/td][td]

0.20​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

21​

[/td][td]ORACLE[/td][td]

5,330,958.00​

[/td][td]

5.33​

[/td][td][/td][/tr]
[/table]

 

[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.

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #C0C0C0"][/TD]
[TD="bgcolor: #C0C0C0"]

A​

[/TD]
[TD="bgcolor: #C0C0C0"]

B​

[/TD]
[TD="bgcolor: #C0C0C0"]

C​

[/TD]
[TD="bgcolor: #C0C0C0"]

D​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

1​

[/TD]
[TD="bgcolor: #F3F3F3"]

Platform​

[/TD]
[TD="bgcolor: #F3F3F3"]

MB​

[/TD]
[TD="bgcolor: #F3F3F3"]

TB​

[/TD]
[TD="bgcolor: #F3F3F3"][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

2​

[/TD]
[TD]AIX[/TD]
[TD]

2,317,951.00​

[/TD]
[TD]

2.21​

[/TD]
[TD]C2: =B2/2^20[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

3​

[/TD]
[TD]WIN[/TD]
[TD]

8,503,907.00​

[/TD]
[TD]

8.11​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

4​

[/TD]
[TD]LINUX x86[/TD]
[TD]

6,372,989.00​

[/TD]
[TD]

6.08​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

5​

[/TD]
[TD]LinuxPPC64[/TD]
[TD]

127,594.90​

[/TD]
[TD]

0.12​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

6​

[/TD]
[TD]DB2/6000[/TD]
[TD]

56,299.84​

[/TD]
[TD]

0.05​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

7​

[/TD]
[TD]DB2/AIX64[/TD]
[TD]

544,812.90​

[/TD]
[TD]

0.52​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

8​

[/TD]
[TD]SQL[/TD]
[TD]

8,059,679.00​

[/TD]
[TD]

7.69​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

9​

[/TD]
[TD]DOMINO[/TD]
[TD]

199,481.80​

[/TD]
[TD]

0.19​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

10​

[/TD]
[TD]ORACLE[/TD]
[TD]

5,330,958.00​

[/TD]
[TD]

5.08​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

11​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

12​

[/TD]
[TD="bgcolor: #F3F3F3"]

Platform​

[/TD]
[TD="bgcolor: #F3F3F3"]

MB​

[/TD]
[TD="bgcolor: #F3F3F3"]

TB​

[/TD]
[TD="bgcolor: #F3F3F3"][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

13​

[/TD]
[TD]AIX[/TD]
[TD]

2,317,951.00​

[/TD]
[TD]

2.32​

[/TD]
[TD]C13: =B13/1000000[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

14​

[/TD]
[TD]WIN[/TD]
[TD]

8,503,907.00​

[/TD]
[TD]

8.50​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

15​

[/TD]
[TD]LINUX x86[/TD]
[TD]

6,372,989.00​

[/TD]
[TD]

6.37​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

16​

[/TD]
[TD]LinuxPPC64[/TD]
[TD]

127,594.90​

[/TD]
[TD]

0.13​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

17​

[/TD]
[TD]DB2/6000[/TD]
[TD]

56,299.84​

[/TD]
[TD]

0.06​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

18​

[/TD]
[TD]DB2/AIX64[/TD]
[TD]

544,812.90​

[/TD]
[TD]

0.54​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

19​

[/TD]
[TD]SQL[/TD]
[TD]

8,059,679.00​

[/TD]
[TD]

8.06​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

20​

[/TD]
[TD]DOMINO[/TD]
[TD]

199,481.80​

[/TD]
[TD]

0.20​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

21​

[/TD]
[TD]ORACLE[/TD]
[TD]

5,330,958.00​

[/TD]
[TD]

5.33​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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?

[TABLE="width: 296"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Date[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Platform[/TD]
[TD="align: right"]3-Oct[/TD]
[TD="align: right"]4-Oct[/TD]
[TD="align: right"]5-Oct[/TD]
[/TR]
[TR]
[TD]AIX (mb)[/TD]
[TD="align: right"]2317951[/TD]
[TD="align: right"]2328039[/TD]
[TD="align: right"]2479165[/TD]
[/TR]
[TR]
[TD]AIX (TB)[/TD]
[TD="align: right"]2.317951[/TD]
[TD="align: right"]2.328039[/TD]
[TD="align: right"]2.479165[/TD]
[/TR]
[TR]
[TD]WIN (mb)[/TD]
[TD="align: right"]8503907[/TD]
[TD="align: right"]11200978[/TD]
[TD="align: right"]7077588[/TD]
[/TR]
[TR]
[TD]WIN (TB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LINUX x86 (mb)[/TD]
[TD="align: right"]6372989[/TD]
[TD="align: right"]6367421[/TD]
[TD="align: right"]7312388[/TD]
[/TR]
[TR]
[TD]LINUX x86 (TB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LinuxPPC64 (mb)[/TD]
[TD="align: right"]127594.9[/TD]
[TD="align: right"]133857.4[/TD]
[TD="align: right"]124766.7[/TD]
[/TR]
[TR]
[TD]LinuxPPC64 (TB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DB2/6000 (mb)[/TD]
[TD="align: right"]56299.84[/TD]
[TD="align: right"]60682.48[/TD]
[TD="align: right"]65968.27[/TD]
[/TR]
[TR]
[TD]DB2/6000 (TB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DB2/AIX64 (mb)[/TD]
[TD="align: right"]544812.9[/TD]
[TD="align: right"]479300.3[/TD]
[TD="align: right"]494746.6[/TD]
[/TR]
[TR]
[TD]DB2/AIX64 (TB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SQL (mb)[/TD]
[TD="align: right"]8059679[/TD]
[TD="align: right"]8184756[/TD]
[TD="align: right"]8687237[/TD]
[/TR]
[TR]
[TD]SQL (TB)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DOMINO (mb)[/TD]
[TD="align: right"]199481.8[/TD]
[TD="align: right"]76690.6[/TD]
[TD="align: right"]2484354[/TD]
[/TR]
[TR]
[TD]DOMINO (TB)[/TD]
[TD="align: right"]0.199482[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ORACLE (mb)[/TD]
[TD="align: right"]5330958[/TD]
[TD="align: right"]3321268[/TD]
[TD="align: right"]5486001[/TD]
[/TR]
[TR]
[TD]ORACLE (TB)[/TD]
[TD="align: right"]5.330958[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]