I needed to calculate the voltage on a capacitor after a given time, and also needed to calculate the time required to charge a capacitor to a given voltage.. maths being rusty (and losing my SC which had all the formulas programmed in ) I resorted to Excel.
The attached .xls (in .zip) may be of use to others.. it contains 2 simple routines..
1.) Given applied voltage, R, C, and time (t), it outputs the instantaneous voltage across the capacitor at t.
2.) Given applied voltage, R, C, and the voltage required across the capacitor, it outputs the time at which this voltage appears across the capacitor.
You will need the LN() function installed in Excel or (other spreadsheet)
The attached .xls (in .zip) may be of use to others.. it contains 2 simple routines..
1.) Given applied voltage, R, C, and time (t), it outputs the instantaneous voltage across the capacitor at t.
2.) Given applied voltage, R, C, and the voltage required across the capacitor, it outputs the time at which this voltage appears across the capacitor.
You will need the LN() function installed in Excel or (other spreadsheet)
Attachments

11.7 KB Views: 2,139