Checking your spreadsheet
To see if u,v and LOD are being calculated correctly, create the following right triangle:
If the LOD0 width, height is set equal to 32,16 then the LOD will be zero.
If the LOD0 width, height is set equal to 64, 32 then the LOD will be 1. Having different W’s at the vertexes should cause the LOD to vary across the triangle.