Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Resistors Ratio (O97)

    I am an analog design electronic engineer. In 1988 I run a program to select two resistors satisfying a given numerical ratio.
    It is written in
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resistors Ratio (O97)

    I had a quick look at your program.
    You could convert it - but it is probably easier to simply use spreadsheet functionality for most of it

    That is
    Your data statements could become a "data" sheet in excel
    Your input and output values could just be cells connected with appropriate formulae.

    It looks intriguing - I'll have a quick play and see if I can post something useful.

  3. #3
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resistors Ratio (O97)

    That was fun <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

    I have attached a spreadsheet with no VBA at all that (I think) does what you require. It is possible I got my ratios and things inverted - but the idea is there

    On the first page enter values in cells B2 - B5
    The rest should be automatic <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    [Editted to attach an updated version of the spreadsheet to correctly pick best ratio resistors if value higher than target]

    If there are issues, or that didn't do what you want - post back.
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Re: Resistors Ratio (O97)

    Hi Andrew;
    I commend your fantastic work.
    You've done a beautiful job, more than what I was even expecting.
    I tested your program for the two possible instances (with the value of one resistor known, or both unknown), and it work charms.
    Thanks A LOT , again.
    I am attaching your program here, so everybody can enjoy it.
    Cheers,

    Daniel Rozenberg.
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Re: Resistors Ratio (O97)

    Hi Andrew;

    Yes. this latest works OK.
    I swapped legends between cells A9 and A10.
    Yes, I use Excel a lot and this fits OK with my applications.
    I am already spreading this program here at the office, where more than one engineer might need it.
    Thanks again,

    Best regards.

    Daniel Rozenberg
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •