Anyone excels in Excel?

[russiangitar02]

Alright, time to complain. Everything at work has been going just fine. But then, BOOM, MS Excel 2003 screws me over. (EDIT: or, apparently lack of use of probability theory in our company...)

Comments

[meep]

Dude, make a user-defined function in VBA. I do that all the time.

[meep]

Here's ref for it in C, which is easily adaptable for VBA:
http://www.nrbook.com/a/bookcpdf/c7-3.pdf

And you do know about the Actuarial Outpost, right (google it - you want the discussion forum. I go by campbell there)? You can ask in there, because someone may already have the code.

[russiangitar02]

I'm a lazy actuarial student... I don't want to to VBA unless I have to :P.

But wow, thank you for the reference though. This is exactly what I need. I guess I'm doing VBA afterall. :)

And thanks for the info on the Actuarial Outpost. I did not know about this. Now I know :) and it looks like my job might become easier :D. Yay!

Anyways, thanks again.

[meep]

VBA is pretty easy as a programming language. It will really help you if you've got to use Excel a lot. Just recording macros generally sucks.

I'm on the Outpost all the time. It is highly helpful when I've got programming problems, and was a huge amount of help when I was studying for exams. See you there!

[theonethatfalls]

This may come a little late - but don't reinvent the wheel. PEople have invented extensions for excel, programmed in VBA, allowing to do statistical things. I bet a tool exists to do exactly what you need - don't have time to look for it though.
Either way - see ya at Solnyshko.

[russiangitar02]

Yea yea yeah... I'm a lazy actuarial intern... I don't feel like programming in VBA.
But it looks like I might have to. Unless you want to do it :)?