tag:blogger.com,1999:blog-83520983559765956192011-11-27T16:04:48.656-08:00I rant, you read.nextranternoreply@blogger.comBlogger41100tag:blogger.com,1999:blog-8352098355976595619.post-56453436284768167152010-04-17T23:50:00.000-07:002010-04-18T00:02:05.813-07:00<div>If you were curious, here is a method to creating the worst Pandora station ever.</div><br /><div></div><br /><div>1. Go to <a href="http://www.pandora.com/">http://www.pandora.com/</a></div><br /><div>2. Click create new station</div><br /><div>3. When prompted, enter the following text as shown in the image below:</div><div> </div><p align="left"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 383px; DISPLAY: block; HEIGHT: 115px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5461368877678532114" border="0" alt="" src="http://3.bp.blogspot.com/_9LqrLT79nY8/S8quDwVnFhI/AAAAAAAAACA/6u0cg2lWV4w/s320/worst_ever.jpg" /></p><div></div><br /><div>4. Click create.</div><br /><div></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8352098355976595619-5645343628476816715?l=nextrant.blogspot.com' alt='' /></div>nextranternoreply@blogger.com0tag:blogger.com,1999:blog-8352098355976595619.post-48600312619915005812009-11-06T12:33:00.000-08:002009-11-06T12:44:33.895-08:00This was a solution to a problem excel should have never been used for. I was told not to use our robust and expensive reporting tool because a manager wanted to “keep it in excel”. The spreadsheet is ridiculous and this is just one obscenity.<br /><br />I would like to introduce you to what could be the longest excel formula in the world. It likes long walks on the beach, summing, counting, offsetting, matching, indirect functions, if statements, row functions and probably more if I reread it, which I will never do again. Do not get to close or it will consume you as it did me.<br /><br /><blockquote>=SUMIFS(OFFSET(INDIRECT("H"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)+ROW(B8),TRUE),IF(ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)))<10,-ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0))),-10),0,IF(ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)))<10,ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0))),10),1),OFFSET(INDIRECT("B"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)+ROW(B8),TRUE),-IF(ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)))<10,ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0))),10),0,IF(ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)))<10,ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0))),10),1),"<="&amp;'Line<br />Targets'!$B$1)/COUNTIFS(OFFSET(INDIRECT("B"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)+ROW(B8),TRUE),-IF(ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)))<10,ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0))),10),0,IF(ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0)))<10,ROW( INDIRECT("b"&amp; MATCH('Line<br />Targets'!B1,B8:B91,0))),10),1),"<="&amp;'Line Targets'!$B$1)</blockquote><br /><br />signed,<br />a broken man<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8352098355976595619-4860031261991500581?l=nextrant.blogspot.com' alt='' /></div>nextranternoreply@blogger.com0tag:blogger.com,1999:blog-8352098355976595619.post-42017601772886410302009-09-26T13:44:00.000-07:002009-09-26T13:50:02.951-07:00I got this email yesterday. This is by far the worst phishing attempt ever<br /><br><br /><br /><a href="http://s32.photobucket.com/albums/d9/downat420/?action=view&current=phishingattempt.jpg" target="_blank"><img src="http://i32.photobucket.com/albums/d9/downat420/phishingattempt.jpg" border="0" alt="worst phishing attempt"></a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8352098355976595619-4201760177288641030?l=nextrant.blogspot.com' alt='' /></div>nextranternoreply@blogger.com0tag:blogger.com,1999:blog-8352098355976595619.post-69397855856747297582009-05-11T05:05:00.000-07:002009-05-11T05:55:15.030-07:00After my aunt was told she cannot attend my wedding, for obvious reasons, she left this hilarious message on my answering machine.<br><br><br /><br /><br /><object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/NZnmfASXYXc&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/NZnmfASXYXc&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8352098355976595619-6939785585674729758?l=nextrant.blogspot.com' alt='' /></div>nextranternoreply@blogger.com0