testing gain, wire gauge, current draw
Printed From: the12volt.com
Forum Name: Car Audio
Forum Discription: Car Stereos, Amplifiers, Crossovers, Processors, Speakers, Subwoofers, etc.
URL: https://www.the12volt.com/installbay/forum_posts.asp?tid=90682
Printed Date: May 14, 2024 at 6:26 AM
Topic: testing gain, wire gauge, current draw
Posted By: sparky3489
Subject: testing gain, wire gauge, current draw
Date Posted: February 19, 2007 at 8:24 PM
Try this out and let me know what you think.
https://www.datafilehost.com/download.php?file=6d26c621
I know it has a few errors, but they lean towards excess rather than lack of...so it is based on being "safe than sorry".
You will need Microsoft Excel and a multi-meter.
Feedback is appreciated.
Replies:
Posted By: sparky3489
Date Posted: February 20, 2007 at 8:38 AM
The "errors" are very hard to overcome because the way the calculations on the "power wire size" operate. They give rediculous wire sizes for anything beyond 1000 watts RMS, that's why theres a limit. I'm not sure how to make a "curve" in excel. The "alternator" sheet starts of by calculating 40% of the current alternator as this is what generally is needed to run just the car (this figure is based on what auto manufacturers denote is needed to actually run the car, air conditioning, fog lights, etc.). When you put in a new value for amperage this changes the original 40% value. So I'm trying to figure a way to correct this. Any ideas? If Excel had a way of capturing a specific value and keeping it like the MS feature on a calculator. However, the sheet must also be resettable to calculate a different vehicle. This is my dilemma...or do you think I should leave well enough alone.
Posted By: sparky3489
Date Posted: February 21, 2007 at 4:04 PM
Out of the 54 (so far) views of this post there's not one reply but my own? I hope those 54 people like my work.....
Posted By: sparky3489
Date Posted: February 22, 2007 at 5:50 PM
You there. Post a reply!!!!
Posted By: haemphyst
Date Posted: February 22, 2007 at 5:52 PM
OK, OK! I downloaded it, but I have not been able to really apply it, or even look very deeply into it... When I do finally try it out, I'll let ya know!
Otherwise, it seems like a good idea.
-------------
It all reminds me of something that Molière once said to Guy de Maupassant at a café in Vienna: "That's nice. You should write it down."
Posted By: sparky3489
Date Posted: February 26, 2007 at 1:20 PM
bump....bumpity bump......BUMP BUMP BUMP!!! BUMPITY BUMP BAAAAA........BUMP-I-BUMP BUMPITY BUMP BAAAAA........BUMP-I-BUMP, BUMP-I-BUMP-AA...BUMP-I-BUMP-AA, BUMP-I BUMP!!! (Theme from Indians Jones and the Temple of Doom, ha ha ha) Hey, I can post whatever i want as long as no one is offended as I'm still waiting for ANY feedback from what is now 118 reads of my post........
Posted By: haemphyst
Date Posted: February 26, 2007 at 1:32 PM
Well, I used it, and it seems to be a decent job of spreadsheeting. I am not an Excel guy, I am a hardware guy, so I can't help with further programming, but, otherwise... Job well done.
-------------
It all reminds me of something that Molière once said to Guy de Maupassant at a café in Vienna: "That's nice. You should write it down."
Posted By: sparky3489
Date Posted: February 26, 2007 at 6:35 PM
Sweet. All I wanted to know.
|