I have recently been lumped with quite a bit of Excel based tasks to do at work, and there is one function that I keep needing that does not appear to be in VBA. "AverageIf"

Knowing that you can perform the equivelant of an AverageIf with combination of SumIf() and CountIf(), I thought I'd wrap these up in a function.

'Purpose:
'   Like Excel's sum if function put performs an average, rather than a sum.
'
Public Function AVGIF(ByVal checkRange As Range, ByVal criteria As Variant, ByVal avgRange As Range) As Variant

    Dim sumIfResult As Double
    Dim countIfResult As Double

    sumIfResult = Application.WorksheetFunction.SumIf(checkRange, criteria, avgRange)
    countIfResult = Application.WorksheetFunction.CountIf(checkRange, criteria)

    If countIfResult = 0 Then
        AVGIF = 0
    Else
        AVGIF = sumIfResult / countIfResult
    End If

End Function

I hope some one finds this as useful as I have.

Mixing with one deck using Serato Scratch Lives Input reverse function

Below is a clip of a simple demonstration to show how you can use the Input Reverse function in Serato Scratch Live to mix with just one deck.

It may be useful if you can you break a needle during a set, or one deck is off for repair / servicing, or you have completely ruined one of the TCVs, There are any number of reasons that may lead you to have just one serviceable deck!

I hope it may help someone out of a sticky situation. sometime. Thank you for watching.

Tracks played:
Stir Fry - Breakin on the streets
The Soul of Man  -Scatterbox
Plump DJs - Weighed Down

You Tube Clip Link

Another discovery today, courtesy of Google finding Rik Robinson's Blog is String.TrimStart() and String.TrimEnd().

To trim a leading slash of a string or path use:

myString = myString.TrimStart(new char[]{'\\', '/'}); 

To trim a trailing slash of a string or path use:

myString = myString.TrimEnd(new char[]{'\\', '/'}); 

I had previously been using a much more long-winded approach. Cheers Rik for bringing that to my attention.

I have recently experienced a JavaScript errror incident when I started using Roles and Membership in a website for the first time.

IE6 reported a syntax error at Line 5 after adding a SiteMapDataSource and Asp.Net Menu controls to the page. The menu would not work I guess due to the JavaScript error.

A quick Google, led me to this page which led me to try adding the following code into my web config

  </system.web>
  
  <!-- Prevent JavaScript Errors, caused by web resource can't be accessed by current user. -->
  <location path="webresource.axd">
    <system.web>
      <authorization>
        <allow users="*"/>
      </authorization>
    </system.web>
  </location> 

</configuration>

This appeared to remove the error, I am assuming by allowing the web resource JavaScript to be accessed by all users.