If you're reading this you must be some sort of MS Excel guru.

I am trying to find someone who can transfer a very complicated mathamatical equation into a spreadsheet.

Let me know if you think you have the ability.

you need to write that in Visual Basic, in fact that is what Excel will prompt you to do. Not sure you'll crack it with an IF statement as its not designed for recursive structures in Exel. The answe you seek is 42.

CCC,

do you mean visual basic for the iterative process?

I would guess Visual basic as well. Theres no way a macro could perform that. Do you know C+ or any other programming language,
if so then you shouldn't find basic too hard. Its all the same sort of thing. Good luck

I know nothing about visual basic, except when I was time wasting at a previous job I wrote a program to calculate fuel consumption (it was ultra simple, like 5 lines long).

If I was to try and find someone to do it where would I start looking?

high schools?

unis?

companies?

Try your engineering dept at the local uni or TAFE. Its amazing what uni students will do for beer.

Hmmm.....my wife informs me it would take about 5 minutes....but we don't have the "stats pack" on our PC to do it??? She does this crap at work daily and suggests to try the uni. I've done nothing like this since uni and have to much brain damage to try it or understand most of it now

mathlab definitely........ uni students will definitely help

[ Edited on 19-3-2007 by 62ragtop ]

ah yes, you are right, Newtons Iterative method is the go, due to the high number of unknown variables. Thanks for the correction. At least you have the algorithm to work off.

You guys need to get out more...

I'll ask some of the eggs at work tomorrow - there's bound to be a maths guru in there somewhere.

Thanks Squiz

STOP WORKING

I found a uni student that has developed the program in html code.

Looks good and produces a 'report' of inputs, constants/program settings, outputs.

Thanks to those that have looked at cracking it.

rabbits