help this dude fix his spreadsheet

[dan_l]

http://deadspin.com/5902760/finance-guy-keeps-incredibly-detailed-incredibly-creepy-spreadsheet-of-his-matchcom-prospects


http://dealbreaker.com/2012/04/financial-services-employees-excel-spreadsheet-of-dating-prospects-allows-for-18-year-olds-has-no-room-for-jappy-girls/


I, for one, think he should make a dashboard with some way better visualizations. That color theme is pretty piss poor, and I'm not really one for using text bold as an indicator.


Although, I sort of like those cell borders at the column heads.


Say, anybody else wonder what's written in the comments?

 

[Hui]

Thanx for that Dan_I

Its Truly amazing what Excel can be used for?

But is should have been posted in: http://chandoo.org/wp/2010/08/13/unusual-excel-uses/

 

[SirJB7]

Hi, dan_l!

Poor man, completely deprived of social life, except for some sporadic date very occasionally ... otherwise why wouldn't have he needed an Access DB at least...?

Looking back on it, I was nearly missing I have to migrate those two .mdb and .accdb to SQL Server 2012...

Regards!

 

[dan_l]

lol


sirjb's little black book is actually a little black database.

 

[SirJB7]

Hi, dan_l!


I remember old days when my phone & address & other stuff black book was in ... guess what?... Yes, in Excel...

But encrypted, with double or triple nested combinations of substitution & transposition, a passphrase of about 35 char... plus an open password, of course.

When opened, userform for password, no validations... it decrypted every field (numbers, text and phones, the three types) and displayed what resulted... if a witness field differed from what decrypted the file couldn't be saved... worksheet change events encrypted info as entered, button for decrypting and displaying but not saving allowed (I later changed it to automatically re-encrypt before saving).

After reading Simon Singh's The Code Book, I improved substitution features so as to avoid frequency analysis attacks... as if someone were to take the trouble to crack the password (well, Elcomsoft was starting yet) -as a matter of fact there's been a lady who did that, just to be faced with the user form with a single text box...-, and then copy all data to perform freq tests... Oh! those old days...


Regards!


PS: I didn't mention that I added a lot of records/rows so as to make it appear much more nourished that it actually was...


PS2: I used it only for hobby... I always remembered every phone number an address... until cell phones, of course, I tried to store my phone book encrypted in my first Fujitsu Stylus flip but memory was only numeric... so I developed a light version for the cell... 100 memories or so... and it worked fine... but I could never use the speed dial, always digit by digit...