i have looked into this Thomas and at first I was quite bamboozled so. I thought perhaps the formula image in cells I12:K16 was incorrect. I am not sure where I got this particular version of the formula from. I conducted the following checks:-
1. I changed the variables in my SMath sheet (attached) to match the spreadsheet at Mpa
235 - it came up with the same numbers - Johnson Pcr 197.34
2. I changed the variables in my SMath sheet (attached) to match the spreadsheet at Mpa
355 - it came up with the same numbers - Johnson Pcr 167.09
3. I then applied the same variables to the online calculator
https://www.omnicalculator.com/physics/buckling
4. At 235 Mpa it produced 197.3 kN using the
Johnson formula
5. At 355 Mpa it produced 198.5 kN using the
Euler formula
So I concluded that there is a "variable based" switch made between the Johnson & Euler formulas but on the surface my spreadsheet Johnson formula is correct.
I went back into my spreadsheet to see if I could find this "switch" variable and found that when I change Sy variable the Critical slenderness ratio at Cell B22 also changes.
At 355 Mpa it is 108.06 i.e.
smaller than the Actual slenderness ratio (S (or Sr)
At 235 Mpa it is 132.81 i.e.
greater than the Actual slenderness ratio(S (or Sr)
IF the critical slenderness ratio formula image I am using in cells D20:E23 is correct this seems to be the reason for the apparent anomaly because the yield stress value is the divisor or in other words the lower the yield stress the higher the Critical slenderness ratio.
I have modified the cells H8 and H15 to suggest which result to adopt.
I realise as a non mathematician and non engineer my logic may be skewed so I welcome correction, but the more I look into this subject especially the different curves for the different buckling formulas the more intriguing I find it.