Dik:
Do you have a reference for Bauer's Method you are able to share?
In your spreadsheet it doesn't look like you have accounted for different yield strengths of the shapes. I'll update my site later today to include a shape template for channels not including the fillets based on the attach info, (I should be able to work out the interior fillet from the K dimension but for now the properties are close enough to the manual without it, AISC nor ASTM provides any info on the flange toe fillet anyone know if this info exists?)
Here is what I assumed for the top of the channel inferred from your yn dimension of block 3 in your spreadsheet:
Coordinate information for the Channel (I have a template built for wide flanges that approximates the fillets as several straight sections):
Resulting Properties (note that Z is based on 50 ksi Fy of the Wide Flange and accounts for the channel being 36 ksi):
Composite Section Results
Area 20.866 in2 Cross-Section Area
Transformed Area 20.866 in2 Transformed Cross-Section Area
Centroid (2.729,9.190) in Centroid in Global Coordinates
Properties about the Centroidal XX,YY Axis
Ixx 859.945 in4 Moment of Inertia (Second Moment of Area) about the XX-Axis, ∫ y2 dA
Iyy 30.537 in4 Moment of Inertia (Second Moment of Area) about the YY-Axis, ∫ x2 dA
Ixxyy -1.625 in4 Product of Inertia, ∫ x y dA
Izz or Jzz 890.482 in4 Polar Moment of Inertia, Ixx+Iyy
Sxx,top 96.510 in3 Elastic Section Modulus to the Top Most Vertex, Ixx / ymax
Sxx,bottom 93.579 in3 Elastic Section Modulus to the Bottom Most Vertex, Ixx / ymin
Syy,left 10.425 in3 Elastic Section Modulus to the Left Most Vertex, Iyy / xmin
Syy,right 10.425 in3 Elastic Section Modulus to the Right Most Vertex, Iyy / xmax
rxx 6.420 in3 Radius of Gyration about the XX-axis, √ Ixx/Atransformed
ryy 1.210 in3 Radius of Gyration about the YY-axis, √ Iyy/Atransformed
rzz 6.533 in3 Radius of Gyration about the ZZ-axis, √ Izz/Atransformed
Plastic Section Moduli, Fy=50.000 ksi
Zxx 112.063 in3 Plastic Section Modulus for Moments about the XX-Axis ( Error: 7.206e-09, Iterations: 34 )
Zyy 15.830 in3 Plastic Section Modulus for Moments about the YY-Axis ( Error: -9.789e-09, Iterations: 38 )
Zuu 112.063 in3 Plastic Section Modulus for Moments about the UU-Axis ( Error: -3.038e-10, Iterations: 34 )
Zvv 15.828 in3 Plastic Section Modulus for Moments about the VV-Axis ( Error: -7.119e-09, Iterations: 39 )
Principal Axis
Iuu 859.948 in4 Moment of Inertia (Second Moment of Area) about the UU-Axis
Ivv 30.534 in4 Moment of Inertia (Second Moment of Area) about the VV-Axis
Iuuvv 0.000 in4 Product of Inertia
θuu 0.112o Rotation from XX-Axis to the UU-Axis
θvv 90.112o Rotation from XX-Axis to the VV-Axis