Archive

Archive for the ‘Main’ Category

Trolls: fantasy versus reality!

January 2nd, 2013 No comments

Categories: Main Tags:

Excel Macro: colour alternate ranges of the same value in the specified column

May 24th, 2011 No comments
'
'   Process a column of values, colouring alternate ranges of the same value.
'
'   Work down a column of cells, stopping when a blank is hit.
'
'   If a cell is a different value to the one preceding it, invert the
'   value of the toggle variable.
'
'   If the toggle variable is true colour the cell.
'
Public Sub main()

    Dim w As Worksheet
    Set w = Worksheets("Sheet1")
    
    Dim rowCtr As Integer
    rowCtr = 2
    
    Dim toggle As Boolean
    toggle = False
    
    While w.Cells(rowCtr, 1).Value <> ""
    
        If rowCtr > 2 Then
        
            If w.Cells(rowCtr, 2).Value <> w.Cells(rowCtr - 1, 2).Value Then
            
                toggle = Not toggle
            
            End If
        
        End If
        
        
        If toggle Then
        
            With w.Cells(rowCtr, 2).Interior
                .ColorIndex = 6
                .Pattern = xlSolid
            End With
        
        End If
        
    
        rowCtr = rowCtr + 1
    
    Wend

End Sub
Categories: Main Tags:

Your App’s Website Sucks

June 24th, 2010 No comments
Categories: Mac, Main Tags:

Party Cat

April 24th, 2010 No comments
Categories: Main Tags:

Too stupid to understand science?

February 8th, 2010 No comments

Categories: Main Tags:

Why has this movie not been made?

January 17th, 2010 No comments

…a fictional 2006 FIFA World Cup Finale between Germany and Netherlands. When the team from Germany loses, they send out as revenge a Zombie invasion

(Taken from Wikipedia)

Why? God dammnit why?

Categories: Main Tags:

You came to the wrong neighbourhood…..

January 13th, 2010 No comments

Categories: Main Tags:

The Dunning–Kruger effect, and it explains a lot……

December 28th, 2009 No comments

The definition of the Dunning-Kruger effect, aken from Wikipedia:

…is a cognitive bias in which “people reach erroneous conclusions and make unfortunate choices but their incompetence robs them of the metacognitive ability to realize it”…

Which can be summarised as:

The trouble with the world is that the stupid are cocksure and the intelligent are full of doubt.

This explains a lot, don’t you think?

Categories: Main Tags:

Homeopathy is an ancient, pre-scientific and absurd pseudoscience

December 20th, 2009 No comments

Homeopathy is an ancient, pre-scientific and absurd pseudoscience. Yet it persists today as an accepted complementary medicine, largely because people don’t know what it is.

The 10:23 Campaign aims to show the public what homeopathy is and explain how we know it doesn’t work.

Click here to find out more.

Categories: Main, Science Tags:

The Apollo Hoax Promoters

August 15th, 2009 No comments

The most interesting, not to mention entertaining, proponents of the Apollo Hoax theory are:

  1. Bill Kaysing – the “father” of the Apollo hoax theory.
  2. Ralph Rene – conspiracy theorist and ardent hoax supporter.
  3. David Percy and Mary Bennet
  4. Marcus Allen
  5. Bart Sibrel – conspiracy theorist, ardent hoax supporter and film maker. He was famously punched by Buzz Aldrin after accusing the astronaut as being “a coward, a liar and a thief” – see the youtube video here.
Categories: Main Tags: