Board Logo
Go To Bottom

Printable Version  
[ Total Views: 705 | Total Replies: 14 | Thread Id: 61252 ]
Author: Subject:  EXCEL gurus
Member56astro
Custom Title Time!
*****


Avatar


Posts: 1772
Threads: 74
Registered: August 25th, 2002
Member Is Offline

Location: The Nambucca
Theme: UltimaBB Pro Blue ( Default )
Mood: Pobjoy Powered with twin ignition & soon to be EFI'd

posted on March 19th, 2007 at 07:51 PM
EXCEL gurus


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.




http://home.swiftdsl.com.au/~astro/images/maltese%20cross.JPG
VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa
Member56astro
Custom Title Time!
*****


Avatar


Posts: 1772
Threads: 74
Registered: August 25th, 2002
Member Is Offline

Location: The Nambucca
Theme: UltimaBB Pro Blue ( Default )
Mood: Pobjoy Powered with twin ignition & soon to be EFI'd

posted on March 19th, 2007 at 08:04 PM



http://home.swiftdsl.com.au/~astro/images/viewfactor.JPG

http://home.swiftdsl.com.au/~astro/images/viewfactor1.JPG




http://home.swiftdsl.com.au/~astro/images/maltese%20cross.JPG
VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa
Membercrewcabconnection
Custom Title Time!
Being Sid James
*****


Avatar


Posts: 1922
Threads: 293
Registered: April 22nd, 2003
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )
Mood: Looking forward to week 10

posted on March 19th, 2007 at 09:06 PM



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
Member56astro
Custom Title Time!
*****


Avatar


Posts: 1772
Threads: 74
Registered: August 25th, 2002
Member Is Offline

Location: The Nambucca
Theme: UltimaBB Pro Blue ( Default )
Mood: Pobjoy Powered with twin ignition & soon to be EFI'd

posted on March 19th, 2007 at 09:13 PM



CCC,

do you mean visual basic for the iterative process?




http://home.swiftdsl.com.au/~astro/images/maltese%20cross.JPG
VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa
Membermegalania
Insano Dub Head
****


Avatar


Posts: 722
Threads: 65
Registered: May 4th, 2006
Member Is Offline

Location: Melbourne Vic
Theme: UltimaBB Pro Blue ( Default )
Mood: Chilled

posted on March 19th, 2007 at 09:44 PM



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
Member56astro
Custom Title Time!
*****


Avatar


Posts: 1772
Threads: 74
Registered: August 25th, 2002
Member Is Offline

Location: The Nambucca
Theme: UltimaBB Pro Blue ( Default )
Mood: Pobjoy Powered with twin ignition & soon to be EFI'd

posted on March 19th, 2007 at 09:48 PM



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?




http://home.swiftdsl.com.au/~astro/images/maltese%20cross.JPG
VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa
Membermegalania
Insano Dub Head
****


Avatar


Posts: 722
Threads: 65
Registered: May 4th, 2006
Member Is Offline

Location: Melbourne Vic
Theme: UltimaBB Pro Blue ( Default )
Mood: Chilled

posted on March 19th, 2007 at 10:04 PM



Try your engineering dept at the local uni or TAFE. Its amazing what uni students will do for beer.
MemberMickH
A.k.a.: Michael Hutchinson
Bishop of Volkswagenism
Hairy Gutted Sloth
******


Avatar


Posts: 3389
Threads: 29
Registered: September 6th, 2003
Member Is Offline

Location: TownsvilleTropical North QLD
Theme: UltimaBB Pro Blue ( Default )
Mood: Grow a brain...walls don't hit back...

posted on March 19th, 2007 at 10:14 PM



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:crazy::borg:



tssnq.com.au
Member62ragtop
A.k.a.: Bug Craze!!!
Officially Full-On Dubber
***


Avatar


Posts: 269
Threads: 33
Registered: January 11th, 2005
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro Blue ( Default )

posted on March 19th, 2007 at 10:40 PM



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

[ Edited on 19-3-2007 by 62ragtop ]
Membercrewcabconnection
Custom Title Time!
Being Sid James
*****


Avatar


Posts: 1922
Threads: 293
Registered: April 22nd, 2003
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )
Mood: Looking forward to week 10

posted on March 20th, 2007 at 09:31 PM



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
Super AdministratorBenettonVW
Super Administrator
AVD Forum Founder
*********

Rank Avatar

Avatar


Posts: 3125
Threads: 185
Registered: August 26th, 2002
Member Is Offline

Location: Country Vic, Australia
Theme: UltimaBB Pro Blue ( Default )
Mood: Slammed.. & BLINGED UP!!

posted on March 20th, 2007 at 09:36 PM



You guys need to get out more... :D



http://www.members.optusnet.com.au/~surie/newjimgow.gif

THE LOWEST WITH THE MOSTEST BLING BLING WINS!!

Membersquizy
A.k.a.: Paul
Compulsive Aussie Vee Dubber
Thinking about another dub...maybe
*******


Avatar


Posts: 4082
Threads: 243
Registered: December 17th, 2002
Member Is Offline

Location: Thornleigh
Theme: UltimaBB Pro Blue

posted on March 20th, 2007 at 09:41 PM



I'll ask some of the eggs at work tomorrow - there's bound to be a maths guru in there somewhere.
Member56astro
Custom Title Time!
*****


Avatar


Posts: 1772
Threads: 74
Registered: August 25th, 2002
Member Is Offline

Location: The Nambucca
Theme: UltimaBB Pro Blue ( Default )
Mood: Pobjoy Powered with twin ignition & soon to be EFI'd

posted on March 20th, 2007 at 10:05 PM



Thanks Squiz



http://home.swiftdsl.com.au/~astro/images/maltese%20cross.JPG
VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa
Member56astro
Custom Title Time!
*****


Avatar


Posts: 1772
Threads: 74
Registered: August 25th, 2002
Member Is Offline

Location: The Nambucca
Theme: UltimaBB Pro Blue ( Default )
Mood: Pobjoy Powered with twin ignition & soon to be EFI'd

posted on April 20th, 2007 at 04:13 PM



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.




http://home.swiftdsl.com.au/~astro/images/maltese%20cross.JPG
VW car, VW engine ...... keepin it "real"
35MPG on 101.3kPa
Super Moderator65busser
Super Moderator
*******

Rank Avatar

Avatar


Posts: 1795
Threads: 224
Registered: November 6th, 2002
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro Blue ( Default )
Mood: dakked

posted on April 20th, 2007 at 04:37 PM



rabbits





  Go To Top


Powered by GaiaBB, © 2011 The GaiaBB Group
(C) 2001-2024 Aussieveedubbers

[ Queries: 40 ] [ PHP: 1.6% - SQL: 98.4% ]