Embedded Systems Conference
Home    Bloggers    Blogs    Article Archives    Messages    About Us   
Tw  |  Fb  |  In  |  Rss
Aubrey Kagan

Excel-Optimizing Resistor Ratios, Part 2

Aubrey Kagan
Page 1 / 2   >   >>
antedeluvian
antedeluvian
4/23/2015 8:43:11 AM
User Rank
Blogger
Re: Another Web Application
MalcomY

You may visit the following to see if it helps:

fairbird.ucoz.com

This looks very useful- thanks for the pointer

 

50%
50%
MalcolmY
MalcolmY
4/23/2015 4:23:06 AM
User Rank
Newbie
Another Web Application
You may visit the following to see if it helps:

fairbird.ucoz.com

50%
50%
amrutah
amrutah
6/30/2014 8:55:45 PM
User Rank
Master
Re: Future blog subject
@SachinEE: "But if the mathematical formula is too complex then its better to implement it using macros..."

  I agree with you that the regularly needed equations can be automated by writing macros, if its one time use then no purpose is served.  But writing macros itself  needs a lot of testing.  There are a set of regularly used macros bundled and available in web, check for "ASAP Utilities" on Google.

50%
50%
SachinEE
SachinEE
6/30/2014 7:31:47 PM
User Rank
Master
Re: Future blog subject
I am sure it can be used. Anything that can be expressed as a mathematical formual can be calculated- building a logical model- that is something else.


@antedeluvian, I totally agree with you. But if the mathematical formula is too complex then its better to implement it using macros because writing bigger formula is not easy.

 

50%
50%
SachinEE
SachinEE
6/30/2014 7:16:29 PM
User Rank
Master
Re: Future blog subject
I think your next series of blogs can be based on MATLAB.

@tzubair, I totally agree with you. Tutorial on MATLAB will help both students and professionals. I really hope to see Matlab tutorials in future blogs.


50%
50%
SachinEE
SachinEE
6/30/2014 7:12:51 PM
User Rank
Master
Re: Future blog subject
I do not wish to undermine the importance of Excel. It's as powerful a tool as any other.

@tzubair, I totally agree with you. Excel is very powerful tool and people have used excel to build very complex models. But only drawback of excel is if the data-points becomes very huge then its becomes pretty slow.


50%
50%
SachinEE
SachinEE
6/30/2014 7:09:53 PM
User Rank
Master
Re : Excel-Optimizing Resistor Ratios, Part 2
I have now completed the series on Excel that I set out to write nearly two years ago.

@Aubrey, thanks a lot for the series on excel. We learnt a lot about excel and its application in calculation circuit variables. If possible can you post some blogs on how best we can use to calculate statistical parameters in excel.


50%
50%
RedDerek
RedDerek
6/26/2014 8:14:38 PM
User Rank
Master
Part 1 reference
@Aubrey - check my comment in the part 1 of this set for I provided a link to my resistor calculator page that I have been using for some time. It might provide some other alternatives to your method.

I actually use formulas to calculate variations and work with the closest 1% set of resistors possible.

50%
50%
tzubair
tzubair
6/25/2014 8:31:30 AM
User Rank
Master
Re: Future blog subject
@Aubrey: I think your next series of blogs can be based on MATLAB. In my academic and professional experience, I have mostly used MATLAB and that seems to be the norm for most engineers. I think that may be of great help to the current students and professionals as well as those aspiring to be one. However, I do not wish to undermine the importance of Excel. It's as powerful a tool as any other.

50%
50%
tzubair
tzubair
6/25/2014 8:12:40 AM
User Rank
Master
Useful feature
Interesting post as always, Aubrey. Reading your blog has helped me refresh my Excel skills. I remember using the combination of data tables to generate a series of values and then using conditional formatting for a regression model that I was working on for an academic project. I guess Excel has a lot to offer to engineers but it's mostly the business professionals who tend to have more expertise in Excel than engineers.

50%
50%
Page 1 / 2   >   >>
More Blogs from Aubrey Kagan
In South Africa the fire protection sprinkler system has a different model to the one used in North America.
In parts 1 through 3 I described the construction of the transformer we needed to generate the 10Amps AC. We still had to drive the transformer.
Part 3 of AC Current Generator blog
When testing, a 10 amp AC current is fed into the module being tested (DUT) and the current is measured across a 25 mΩ shunt internal to the DUT.
I wrote an article on this topic in 2000 that was published on Circuit Cellar Online. I believe that the basic information that I wrote about is still relevant and so I am rewriting the article as a blog.
flash poll
educational resources
 
follow Planet Analog on Twitter
Planet Analog Twitter Feed
like us on facebook
our partners
Planet Analog
About Us     Contact Us     Help     Register     Twitter     Facebook     RSS