A couple of handy L/C calculators using MS 'Excel'. Although such computer-based calculators are two-a-penny on the 'Net, I like to design my own using 'Excel'. I have used of these both extensively for more that a year now, so there should not be any errors in the embedded sums. But please let me know if you find any: thanks.
The first one is a straight-forward 'put in the two known variables, the spreadsheet finds the unknown one' type.
[attachment=10646]
The second one is not quite so straight-forward, but is tackles quite a common problem - which if done in the 'traditional style', involves a pair of simultaneous equations in two variables.
With the awkward numbers that you get in 'L/C arithmetic', there is ample opportunity for errors to arise with a pencil and paper. The object of this 'sheet is to eliminate that and get the computer to do the hard work.
[attachment=10647]
Any feedback, +ve or -ve, will be appreciated; thanks.
Al.
The first one is a straight-forward 'put in the two known variables, the spreadsheet finds the unknown one' type.
[attachment=10646]
The second one is not quite so straight-forward, but is tackles quite a common problem - which if done in the 'traditional style', involves a pair of simultaneous equations in two variables.
With the awkward numbers that you get in 'L/C arithmetic', there is ample opportunity for errors to arise with a pencil and paper. The object of this 'sheet is to eliminate that and get the computer to do the hard work.[attachment=10647]
Any feedback, +ve or -ve, will be appreciated; thanks.
Al.
