1. Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.
    Dismiss Notice

Why isn't my spreadsheet working?

Discussion in 'Mathematics and Physics' started by electrocub, Dec 12, 2008.

  1. electrocub

    electrocub New Member

    Joined:
    Nov 25, 2008
    Messages:
    20
    Likes:
    0
    I found a comparitor volt meter circuit for a 12 volt gelcell. Depending on the voltage that the battery is at, one or more led's light up. I wanted to change the value of the resistors in the resistor network so the led's would light at the voltage I wanted it to. Instead of doing a trial and error approach, I created an Excel spreadsheet that I thought I could change the values of the resistors and experiment this way. As I changed the values of the resistors, the circuit would change and the colors of the cells would turn on and off. It looked like my spreadsheet worked correctly, so I built the circuit with the values in the spreadsheet., Unfortunatly it didn't work anywhere close to what the values of the spreadsheet were. Would someone look at the spreadsheet and tell me where I went wrong? Thanks



    Here is the link to the meter.
    http://ourworld.compuserve.com/homepages/Bill_Bowden/page11htm#meter.gif
    It is called led 12 volt lead acid battery meter
     

    Attached Files:

Share This Page