Hi there! I was making an excel template for calculations of allowable stress for aluminum frames.when I took a look at the rendered XLC formula.. there was a slight error in it. kindly look at the attached file.

"d10" is supposed to be "S".

i know that this is just a slight issue, but nonetheless i am giving my comment to further improve d XLC program.

thanks and more power to you and to XLC!

-moises villar-
civil engineer


-sori i cant seem to attach the xls file. ill repeat my post tomorrow.. my apologies

I am just checking the file attachments work in the forum.

File attachments seems to be working OK moises. I am looking forward to receiving your attachment.

Got it sir!

here is the file! at last i was able to attach it!






JohnDoyle wrote:

QUOTE:
File attachments seems to be working OK moises. I am looking forward to receiving your attachment.

moises I think that their is a " " character in the formula which is causing the problem. Your cell formula reads:
=IF(D10<D12,9.5*6.895, IF(AND(D12<D10, D10<D14), (10.5-0.07*SQRT(D10))*6.895, IF(D10>D14, (23600/D10)*6.895, ERROR)))
If you change this to:
=IF(D10<D12,9.5*6.895, IF(AND(D12<D10,D10<D14), (10.5-0.07*SQRT(D10))*6.895, IF(D10>D14, (23600/D10)*6.895, ERROR)))
Notice the " " character remove in front of "D10<D14"
Now your equation will be rendered correctly.

I'll be able to fix this bug in a future release but if you could use this work around for now.

Thanks for reporting this in. I really rely on user feedback to notice these bugs so that I can improve the product in the future.

Oh i see! Ok i'll try that in my formula again. Thanks big help!