
Electronics Resources Get help with all types of electronics resources, including books, websites, datasheets, technical literature, and software. 

Thread Tools  Display Modes 
#1




Electronics Formula Excel Cheat Sheet Project
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) Last edited by FredM; 12052007 at 10:07 PM. 
#2




If you have an RC circuit, you can solve the following differential equation:
EMF = Vr + Vc (Kirchoff's Voltage Rule) Vr = IR = (dq/dt)*R Vc = Q/C EMF = (dq/dt)*R + (Q/C) After solving the 1st order differential equation, you get q = C(EMF)(1e^(t/(RC))) i = dq/dt = (EMF/R)e^(t/(RC)) This is for a DC circuit where the capacitor and resistor are in series. 
#3




Quote:
It might be an idea to run a small project that implements and graphs all of the major electronics formula and functions for people new to the subject. Perhaps this could be the spring board from which to build from. I'd be interested in helping out. Dave 
#4




Quote:
Nonlinear stuff is where I have problems, which is why I resorted to Excel.. However, there is no reason why a single spreadsheet could not be produced which contains the major formulas  from ohms law up.. If a worksheet was done for each 'group', this could be quite an interactive project  and need not be limited to formulas.. Simple circuits (standard opamp configurations, 555 timers etc) could be 'simulated' quite simply. I attach an example, based on the computations of the last.. This is a spreadsheet to calculate frequency and M/S ratio of 555 timer acting as oscillator.. I cannot spend any more time on the above 'project' at the moment, but would be happy to participate in the new year.. I dont think much coordination is required though.. If peeps leave worksheets unprotected, and are free to use / modify what has been created, or create new sheets.. they could be pasted here and collated later. 
#5




Hello Dave,
This is a really good idea. Many engineers that I work with use Excel for everything. I have several Excel files myself showing how to calculate the input common mode range of single supply inamp. Maxim also has an application note called "Exact Circuit Analysis" which uses Excel to calculate the impedance of an RC circuit. It then uses it to calculate the phase shift in the open loop curve of an opamp. I think this would be a great project for things like Ohm's law, Power, Reactance, transistor curves, etc. 
#6




Hi FredM and knightofsolamnus,
I'm glad we think this may be a good idea; to honest I'm surprised we haven't embarked on something like this before. I am willing to act as a coordinator, unless someone has the desire to take charge. FredM's spreadsheet is a good starting point. knightofsolamnus, if you want to upload your spreadsheets, I can merge them with FredM's and a couple of working spreadsheets I have and we can get the ball rolling. I can then post up a first version covering the basics. If FredM is happy for me to do so, I will change the thread name to something that better reflects the objectives of the project and I will stick it to the top of the Electronics Resources forum. If anyone else wishes to get involved please post and get involved. Dave 
#7




I am more than happy with this..

#8




Done. I'll get grafting on some basics. If anyone has any formula that would be good for putting into this, please let me know.
I hope we can have a good working version in the new year. Dave 
#9




Here is an Ohm's Law calculator. I was going to use VB scripts in Excel (bought a book to learn how to do it) but just relied on simple Excel formulas for now.

#10




Quote:
Good starting point and it looks quite snazzy with the colours and chart in the middle. I did consider the options of using VB macros, and even the idea of doing it in C++, however this is intended to be a simple calculator type application for general use. Why spend time implementing features that are readily available in Excel (I'm sure we will hit a stumbling block at some point when a bit of VB code will be needed). I encourage anyone else who has Excel worksheets for calculating values in just about any electronics applications to submit it  it would be great to have a collective effort covering a wide range of formulas. Dave 
Tags 
cheat, electronics, excel, formula, project, sheet 
Related Site Pages  
Section  Title  
Worksheet  Algebraic substitution for electric circuits  
Worksheet  Capacitive reactance  
Worksheet  Time constant calculations  
Worksheet  Capacitance  
Worksheet  Temperature coefficient of resistance 
Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Digital Electronics Cheat Sheet  m4yh3m  Homework Help  2  09202011 06:09 PM 
Long lost cheat sheet  Metalfan1185  General Electronics Chat  2  02172011 06:35 PM 
Help: deriving formula for a uniform resistive sheet current  gotumal  General Electronics Chat  2  06252009 02:45 PM 
Need some super duper formula sheet!  OptoElectronics_Kayla  General Electronics Chat  5  04072009 01:03 PM 
Digital Electronics Cheat Sheet  m4yh3m  General Electronics Chat  4  05242004 08:59 PM 
Thread Tools  
Display Modes  

