Home  |  Forums  |  914 Info  |  Blogs
 
914World.com - The fastest growing online 914 community!
 
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG. This site is not affiliated with Porsche in any way.
Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners.
 

Welcome Guest ( Log In | Register )

> OT: Single variable formula solver, free download, Uses Excel to solve for an unknown variable
Air_Cooled_Nut
post Sep 5 2006, 12:55 PM
Post #1


914 Ronin - 914 owner who lost his 914club.com
***

Group: Members
Posts: 1,748
Joined: 19-April 03
From: Beaverton, Oregon
Member No.: 584
Region Association: None



Upon occasion I have the need...THE NEED FOR SPEED!...oops, sorry got carried away (IMG:style_emoticons/default/drunk.gif) Seriously, I'll come across a formula (like right now I'm researching turbos) and need to solve for one of the variables, typically the one that's on the wrong side of the equal sign. Excel does have a function, Goal Seek, that allows one to solve for an unknown but it's not necessarily easy to use. What I did was put a 'wrapper' around it to make it much more user friendly. I based it on a similar application I use on my PDA but my application doesn't require registration -- it's 100% FREE.

Disclaimer: This isn't something a 3 year-old could use right away. It's meant for people who have some education about problem solving and unknown variables. If you've graduated high school (or are about to) then you've got enough education (IMG:style_emoticons/default/wink.gif) The instructions should provide adequate direction along with the workbook.

Instructions:
http://www.icbm.org/erkson/personal/Better_Goal_Seeker.doc

Sample workbook:
http://www.icbm.org/erkson/personal/Better_Goal_Seeker.xls
BTW, the examples in the workbook can be deleted without affecting anything. Formulas can be added and deleted at will. It's just your standard, ordinary Excel workbook. The only thing different about it is that there's a macro in it to help one solve for an unknown variable within an equation. As you can see, you can have multiple formulas on a sheet, even on other sheets. Enjoy!
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Posts in this topic
Air_Cooled_Nut   OT: Single variable formula solver, free download   Sep 5 2006, 12:55 PM
JOHNMAN   You are of course joking, RIGHT???? One variable?...   Sep 5 2006, 02:21 PM
Air_Cooled_Nut  

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

- Lo-Fi Version Time is now: 28th May 2024 - 11:00 PM