Tag Archives: Storage

Quick tip – Human readable folder sizes in Excel

From the school of There’s Probably a Better Way, But…

I was taking the output of SysInternals’ du.exe utility and wanted to email it to a colleague, but the folder sizes were in KB. Since most of them were many Gigabytes in size, I wanted a quick way to convert them to the appropriate size in GB, MB, or KB.

I copied the du.exe size column and pasted it into Excel. Then I created the following formula:

=IF(E6>(2^20),TEXT(E6/(2^20),"0.0") & " GB","smaller")

…where E6 is the cell reference. Also note that du.exe’s output was in KB, so my test is one order of magnitude smaller than it would need to be if I was formatting a size in bytes. (i.e., 2^20 is 1 MB).

I then nested another similar if() function with a final formatting option to get my final formula:

=IF(E6>(2^20),TEXT(E6/(2^20),"0.0") & " GB",IF(E6>(2^10),TEXT(E6/(2^10),"0.0") & " MB",TEXT(E6,"0.0") & " KB"))

Wednesday – March 11

Out, yesterday, “Patch Tuesday.” Lots of email to clean up.

Task focus for today: Storage re-arrangements.

Again, heat’s on and so is the AC. Makes for cold fingers.

Reviewing Greg’s powershell script.

Draft memo; asked for saa-ad@uvm.edu email alias. Shared responsibility.

Confirmed names, affiliations, sent memo.

Some progress on storate re-org, but not as much as I’d hoped. And no progress on scripts. /sigh

Mastering the Maze tomorrow; or maybe more storage work.

Monday – March 9

Because of my body’s resistance to the artificial manipulation of time zones, I’m running at about ¾-impulse.

Happy Birthday to my little sister.

A friend pointed out to me that Tax Day is also Same Sex Kiss Day, to be held at your friendly neighborhood Starbucks, or wherever you want, really.

On the list for today: storage management, server disk repartitioning, and group management training.

Updating Tools list.

Configuring new SharePoint servers’ backup.

Working with server disk management; accessing system via remote console, mounting ISO as virtual CD across the wire.

Greg showed me WinDirStat. I’ve seen it in several magazines, but never quite grokked the utility of the rectilinear representations of files. Now I understand, and it makes a lot of sense. It would be nice to be able to select alternate color schemes.

Using GPartEd Live to fiddle with partitions. An hour or so later, and the drives have been resized and Windows is up and running, with no problems. Phew!

Sent Marty documentation about backing up MS SQL Server Express Edition using SQLCMD.EXE and Scheduled Tasks.

Investigate account issue for Beth.

Touch base  with Daryl on group management issue for CS.

UWinnipeg has ActivePerl 5.10 packages for IO-Socket-SSL. Is it enough?

Friday – March 6

Storage issues overnight; thanks, Greg, for putting out the fire.

Server storage resize project: IBM RSA access established, trouble getting GNU PartEd.

NERCOMP Campus Agreement LiveMeeting

Planning and design of home directory storage. Did some interesting analysis. Don’t want to break anything before the weekend, though. And I’m back on call.

And I solved a PHP problem for a client of IM; nice way to close the day. Thanks, Laurie.