' from http://support.microsoft.com/kb/188007
' for running on Excel on Mac, where the VBA engine doesn't
' have VB6 String functions
Public Function Replace(sIn As String, sFind As String, _
            sReplaceWith As String, Optional nStart As Long = 1, _
            Optional lngMaxReplacementsToMake As Long = -1) As String

    Dim lngNumReplacementsDeja As Long
    Dim nPos As Integer
    Dim sOut As String
    Dim bContinue As Boolean
    
    bContinue = True
    
    sOut = sIn
    nPos = InStr(nStart, sOut, sFind, vbBinaryCompare)
    While (nPos > 0) And bContinue
            lngNumReplacementsDeja = lngNumReplacementsDeja + 1
            sOut = Left(sOut, nPos - 1) &_
                  sReplaceWith & Mid(sOut, nPos + Len(sFind))
            nPos = nPos + Len(sReplaceWith)
            
            If (lngMaxReplacementsToMake <> -1) And _
                (lngNumReplacementsDeja >= lngMaxReplacementsToMake) Then
            
                bContinue = False
            End If
            
            nPos = InStr(nPos, sOut, sFind, vbBinaryCompare)
            
            If nPos > 10000 Then
                ' I put a breakpoint here when testing
                Debug.Print nPos & " :: " & sOut & " :: " & sFind
            End If
        Wend
    
EndFn:
          Replace = sOut
End Function

Labels: excel, noteToSelf, vba

Labels: pseudo-academic

In addition, the program provides good news for the environment. That's because 84 percent of consumers traded in trucks and 59 percent purchased passenger cars. The average fuel economy of the vehicles traded in was 15.8 miles per gallon and the average fuel economy of vehicles purchased is 24.9 mpg. -- a 58 percent improvement.
...
New vehicles Mileage: 24.9 MPG
Trade-in Mileage: 15.8 MPG
Overall increase: 9.2 MPG, or a 58% improvement

Labels: noteToSelf

Overcoverage of the favored few teams and players not only kills joy through its sheer tedium, it is also the root of fan grievances about bias, about cross-promotion, and about corporate conflict of interest. I suspect the perceived arrogance of particular ESPN personalities would become a small-potatoes complaint if it were not magnified in fans' minds by the consequences of other forms of excess.

So what's the one last message I want to leave ESPN? I guess it would have to be: Don't be so predictable. Subtext: Stop trying to make the publicity-rich ever richer. Spread the wealth around before fans turn on ESPN the way investors have turned on bankers.

Remember that serving your audience also means not burying your lead. I've never seen an ombudsperson have so much filter and delay between introducing the[ir] topic and the criticism. And then, in this first post, "Serve the audience," when we do get past the reader responses and to your opinion, it's exceptionally weak. No comment explaining whether ESPN the story on Roethlisberger should have been run or not; you just mention that there could have been a better explanation when it wasn't, skirting the issue.

The Duke lacrosse team case is well chosen. I can understand toning down that witch hunt, but going from burning witches to becoming mute isn't any better reasoned a move.

Please remember that the ombudsperson's job is to critique where ESPN does lose its journalistic integrity, and it's [a] position whose importance shouldn't be trivialized. If making sure that at least SportsNation would have received the ["]explanation it deserved" (and good job committing ombudsperson trust suicide with the crosspromotion) is the most egregious violation you've found since starting, you're not listening.

Thank you for you time.

Labels: espn

Option Explicit

Public Sub createSql()
    Dim i As Integer
    Dim strTemp As String
    Dim strCname As String
    Dim strUserName As String
    
    
    For i = 2 To 65
    
        strCname = Cells(i, 1).Value
        strUserName = Cells(i, 2).Value
        'insanely important IP removed.
        strTemp = strTemp & f(strCname, strUserName)

    Next i
    frmTemp.txtCode.Text = strTemp
    frmTemp.Show
End Sub

Labels: code, excel, noteToSelf, vba

After my post, I got an email from the developer of an iPhone Twitter client. He was contacted by Microsoft a few months ago, with an offer to port his app to the Zune in exchange for “a bucket of money”. He turned them down, but assumes, as I do, that Microsoft reached out to the developers of multiple popular iPhone apps.

how many billions of dollars has Microsoft lost, in R&D, legal fees, and damage to reputation, because they decided that not only do they have to make a web browser, but they have to give it away free?

The meltdown that left 45 million Twitter users unable to access the service on Thursday came in two waves and was directed at a single blogger who has voiced his support for the Republic of Georgia in that country’s continuing conflict with Russia.
...
Early Thursday, the attackers sent out a wave of spam in the name of Cyxymu.
...
“They’re literally designed to smear someone’s online reputation,” said Ms. Jones. “These hackers wanted to make him look responsible for millions of spam e-mails that went out yesterday morning.”
...
The attacks coincided with the one-year anniversary of the Russia-Georgian conflict. “When the conflict started a year ago, there were various denial-of-service attacks coming from both sides, attacking Web sites.”

[The attacks against "non-critical US gov't sites", Twitter, and Facebook] don’t make any sense. And that means trouble, according to Cisco’s Patrick Peterson.

“I’m afraid two outliers make a line and there is something going on,” Peterson said.

I haven't been using Twitter all that long, but apparently it's become pretty snugly integrated into my life. Because when it suddenly stopped working about twenty minutes into practice, I was completely freaked out.

It all points to one thing, Peterson thinks. Botnets are too easy to assemble. There are too many unpatched Microsoft Windows machines on the internet that get repeatedly infected and taken over.

“The barrier to entry is too low,” Peterson said.

“It may that 998 of a 1000 criminals out there are out to maximize profits and minimize risk, but it doesn’t take many of them to get their hands on a small botnet to create harm. Then you have a minority actor doing a disproportionate amount of harm.”

Then I decided to change the license from GPL to something more free -- not free as in RMS, but free as in freedom. There were several options: GPL plus commercial license, BSD, LGPL, etc. Finally I was flamed off, so I left the G2 project, and development stopped there.
...
As G1 is getting worse day by day, I decided to try again at G2, and even though some people disagreed, I changed the license to LGPL.

Labels: gng