Some Cool Infoz for Keeping Up

John Lam is working on IronRuby at Microsoft.  This video over on InfoQ was rather interesting.  If you are curious which direction Ruby is going in the Microsoft world, this discussion gives some good insight and idea.

Look, a railroad system for Dutch Railways, being presented via a case study.  The case study being specific to how SCRUM accomplished a project that previously had failed.  The final audit of the software concluded:

  • The maintainability of the system is very good.- The quality of the source code is very high.

How can one NOT want that for the accomplishment of a project?  Come on, Lean, SCRUM, whatever you want to call it, Agile methods work, USE THEM!  The amount of failure that comes form not utilizing strong team based agile style processes is too massive to even contemplate further use in this day and age…  but enough of me ranting about non-agile methods.

Windows Live Tools have been released via a July CTP specific to VS.NET 2008.  These are something that I might actually use in the near future for some projects.  I ponder how I could utilize them in a transportation or transit related realm.

That’s all I got for right now, gotta jump back into my MVC and finish mocking up some examples.

Put Those Assemblies There :: Tip O' The Day

A little post build event can help a lot when one has multiple assemblies that need to be utilized by an application.  Such as the entlib or composite library.  Just put the following script in the post build event and make sure to create a directory were the assemblies will go.  Boom – you got everything in one place were you want it!

copy /y “$(TargetDir)$(TargetName).*”  “$(SolutionDir)..\build\references\”

Technorati Tags: Build,Post Build,Assembly

del.icio.us Tags: Build,Post Build,Assembly

Social Networks OMG

Oh…

My…

God…

WTF?

I’m sitting here on the floor of the new apartment, Joleen working on a large scale multi-page poster type thing that will adorn the wall and I’m digging through various social medium online.  The nature of this social medium is rather overwhelming these days and really makes me ponder what we can achieve through increased social interaction via the computer.

As is obvious, with myspace, Facebook, and the others (I remember when Friendster was the only real site out there) people are socializing online as never before.  If I remember correctly at first, it was the fast wit, smart, or maybe just crazy people all over IRC (that’s Internet Relay Chat for you noobs).  Tons of people chatting at any hour in any of thousands of chat rooms.  Then there were other chat rooms, forums, and chat with icons and emoticons moved in.  Before one realized there was just a whole mess of people blathering back and forth across the Internet.

Then came along the new trendy label of social networks.  Social networks are kind of like Web 2.0, very superficial in difference but slightly more user friendly and sophisticated.  Functionally, it isn’t any different than that bunch of elite folk bantering away in IRC.  The difference now is the sophisticated part of metadata, conversation and person tagging, and the ensuing relational correlations that can be drawn.  People can find stats of stats of more stats all over the Internet now in relation to their social standing.  Mind you, there are still about 5.8 Billion people not involved with this social network of the Internet on this level, but there are about 200 Million that are.  Between Japan, China, India, Europe (and England), and the United States the surge of interaction is massive.

There are so many things out there that intend, contend, and are pushing to be THE social network medium of the future.  But it isn’t the Internet as a whole they’re going for but instead the Enterprise, the small businesses, the local community neighborhood, or some other niche community.  One of the sites, that I watch once in a while is Jive Software.  Jive is right here in Portland and has become one of those it places to work and talk about.  The other social medium network site that I’ve followed closely, especially the more I’ve used it is linkedin.

But I can’t help but continue to wonder.  OMG, WTF!  Does this have return on investment?  Does it bring us truly more connected to each other?  Does it allow us to push ourselves even further away from those that are different and align ourselves more closely with those like us?  Does it allow for us to cut off the world we don’t want and not have to deal with reality?  Were does the line stand, is there a line, what is the line in relation to all this?

Is social networking doomed to keep giving us more and more of these TLAs?  Emoticons of absurdity?  Surprise [:O]

Many questions, which only time can clarify.

Until then I’m going back to my MVC playground.

Just Some Excel Helpers and Respective Unit Tests

Just some semi-elegant stuff I’ve conjured up recently to get column names in Excel and do some other functional things.  I wrote this code in a true TDD fashion.  It still, for some reason, seems odd to me to write tests in VB, since it was always a language that encouraged dirtiness.  But alas, this is fairly solid stuff.

Imports NUnit.Framework

<TestFixture()> _
Public Class HelperTests
    <Test()> <Category("Presenter Helper Tests")> _
    Public Sub TestHelperGetExcelColumnLetterSingleLetter()
        Dim theLetter As String = Helper.GetExcelColumnLetter(3)
        Assert.AreEqual(theLetter, "C")
    End Sub

    <Test()> <Category("Presenter Helper Tests")> _
    Public Sub TestHelperGetExcelColumnLetterDoubleLetter()
        Dim theLetter As String = Helper.GetExcelColumnLetter(29)
        Assert.AreEqual(theLetter, "AC")
    End Sub

    <Test()> <Category("Presenter Helper Tests")> _
    Public Sub TestHelperGetExcelColumnDoubleLetterThirdAlphabet()
        Dim theLetter As String = Helper.GetExcelColumnLetter(56)
        Assert.AreEqual(theLetter, "BD")
    End Sub

    <Test()> <Category("Presenter Helper Tests")> _
   Public Sub TestHelperGetExcelColumnTripleLetter()
        Dim theLetter As String = Helper.GetExcelColumnLetter(2356)
        Assert.AreEqual(theLetter, "CLP")
    End Sub

    <Test()> <Category("Presenter Helper Tests")> _
    Public Sub TestHelperGetExcelColumnTripleLetterSomething()
        Dim theLetter As String = Helper.GetExcelColumnLetter(14999)
        Assert.AreEqual(theLetter, "VDW")
    End Sub

    <Test()> <Category("Presenter Helper Tests")> _
        Public Sub TestHelperGetExcelColumnTripleLetterTheEndOfZzz()
        Dim theLetter As String = Helper.GetExcelColumnLetter(18278)
        Assert.AreEqual(theLetter, "ZZZ")
    End Sub

    <Test()> <Category("Presenter Helper Tests")> _
    Public Sub TestHelperGetExcelColumnF1C1()
        Dim theColumnF1C1 As String = Helper.GetExcelColumnF1C1(3, 6)
        Assert.AreEqual("C:F", theColumnF1C1)
    End Sub

End Class

I churned out each of these tests, the first few I did at one time, counting out where the column “letters” would be derived at various column numbers.  It almost got confusing a few times.  All tests of course went red and I began coding the innards of the method.

What I came up with, after a few gotchas here and there is this.

Public Class Helper
    ''' <summary>
    ''' This method gets the appropriate "A" thru "ZZZ" column header for Excel based
    ''' on a passed in long data type.
    ''' </summary>
    ''' <param name="colNum">Pass in a long type to derive the appropriate column header letter.</param>
    ''' <returns>A string of the appropriate "A" thru "ZZZ" header letter.</returns>
    Public Shared Function GetExcelColumnLetter(ByVal colNum As Long) As String
        Do
            GetExcelColumnLetter = Chr(65 + (colNum - 1) Mod 26) & GetExcelColumnLetter
            colNum = (colNum - 1) \ 26
        Loop While colNum > 0
    End Function

    ''' <summary>
    ''' This method returns the ("A:ZZZ") part of the Range("A:ZZZ") column interface.
    ''' </summary>
    ''' <param name="firstColumn">Enter the first column to start the range with.</param>
    ''' <param name="secondColumn">Enter the second column to end the range with.</param>
    ''' <returns>A string formatted as A:ZZZ is returned from this method.</returns>
    Public Shared Function GetExcelColumnF1C1(ByVal firstColumn As String, ByVal secondColumn As String) As String
        Return GetExcelColumnLetter(firstColumn) + ":" + GetExcelColumnLetter(secondColumn)
    End Function
End Class

If you work with Excel frequently you know all about F1C1, which I decided to stick on the end of the GetExcelColumnF1C1.  Not sure if it really makes sense, but since so much of Excel is kind of just mess, I figured it might conjure the right thought in a coder’s mind.

kick it on DotNetKicks.com

Technorati Tags: Office 2007,Office,Excel,VB,TDD,Unit Test

del.icio.us Tags: Office 2007,Office,Excel,VB,TDD,Unit Test