OT: Single variable formula solver, free download, Uses Excel to solve for an unknown variable |
|
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. |
|
OT: Single variable formula solver, free download, Uses Excel to solve for an unknown variable |
Air_Cooled_Nut |
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! |
Lo-Fi Version | Time is now: 28th May 2024 - 11:00 PM |
All rights reserved 914World.com © since 2002 |
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |