Skip to content
Aussieveedubbers

EXCEL gurus

0 likes
Share Share on Facebook Share on X Share on Reddit

56astro Custom Title Time!

1,772 posts · joined Aug 2002 ·

#579716
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.

VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa

56astro Custom Title Time!

1,772 posts · joined Aug 2002 ·

#579720



VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa

crewcabconnection Being Sid James

1,922 posts · joined Apr 2003 ·

#579759
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.
Loves a lolcat

56astro Custom Title Time!

1,772 posts · joined Aug 2002 ·

#579761
CCC,

do you mean visual basic for the iterative process?

VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa

megalania Insano Dub Head

722 posts · joined May 2006 ·

#579766
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

56astro Custom Title Time!

1,772 posts · joined Aug 2002 ·

#579768
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?

VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa

megalania Insano Dub Head

722 posts · joined May 2006 ·

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

MickH Hairy Gutted Sloth

3,389 posts · joined Sep 2003 ·

#579778
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🤪🤖
tssnq.com.au

62ragtop Officially Full-On Dubber

269 posts · joined Jan 2005 ·

#579781
mathlab definitely........ uni students will definitely help

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

crewcabconnection Being Sid James

1,922 posts · joined Apr 2003 ·

#580002
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.
Loves a lolcat

BenettonVW Administrator AVD Forum Founder

3,125 posts · joined Aug 2002 ·

#580004
You guys need to get out more... 😀

THE LOWEST WITH THE MOSTEST BLING BLING WINS!!

squizy Thinking about another dub...maybe

4,082 posts · joined Dec 2002 ·

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

56astro Custom Title Time!

1,772 posts · joined Aug 2002 ·

#580014
Thanks Squiz

VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa

56astro Custom Title Time!

1,772 posts · joined Aug 2002 ·

#586218
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.

VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa