If you are using a later version (Excel 2007 or later), this tip may not work for you.For a version of this tip written specifically for later versions of Excel, click here: Deriving Antilogs.If you are big into trig, you may wonder why there are no functions that derive antilogs.
![]() For instance, the base-10 log of 4 is 0.60206, and the base-10 antilog of 4 is 10,000 (10 raised to the fourth power). This also means that the base-10 antilog of the base-10 log of 4 is, again, 4. Raising 10 to the 0.60206 power is 4.). You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Deriving Antilogs. He is president of Sharon Parq Associates, a computer and publishing services company. The analysis for this circuitry is like as for the diode log amplifier configuration except that VBE is replaced to the VF, IC is replaced with the IF, and IEBO is replaced to the IR. In this post, we will have a detailed look at log and antilog amplifiers. These types of amplifiers are used in such applications where compression of analog input data occurs and in such applications were used for linearization of such transducer (it is a device that converts any type of signal into electric) which has exponential outputs, with that has analog multiplication and division. These amplifiers also preferred for such communication systems where large value frequency is used like an optical fiber communication system which helps in the processing of various range signals. In this post, we will have a detailed look at their circuit working, operation, and some other parameters. What is Logarithm The logarithm of any number is the power that has such a number at the base that results in this number. The results generated by the logarithmic or log amplifier is directly proportional to the log taken of the input provided while the output pf the antilog amplifier is inverse of the input. Logarithmic Amplifier The factor in a log amplifier is a component that shows logarithmic features which when exits in the feedback loop of the operational amplifier causes a logarithmic response. It indicates that out signal is a function of the logarithm taken of the input signal and can be defined by this below-given equation. Vout -K ln(Vin) in this equation the K is constant and ln denotes the natural logarithm with base e. As we are using a natural log in the formulas every relation can be transformed in the log to the base 10 (log10) with the use of this relation lnx 2.3log10x. The semiconductor PN junction in the shape of a diode or base-emitter junction of bipolar junction transistor offers logs characteristics. ![]() In the below figure you can see the resultant curve in this curve VF is forward diode voltage and IF is forward diode current. You can observe that the diode cur is not linear in this graphical representation. The curve is not only non-linear it is logarithmic and certainly denoted by this given equation. IFIF IRe qVFkt The ln of multiple of 2 numbers equal the summation of ln of every number. As the inverting input is connected at the ground or zero volts the output is at -VF in case the input is positive. The output value is restricted to the extreme value since the diode logarithmic features are restricted to voltage value less than 0.7 volts. With that input should have a positive value in case od diode is linked according to the configuration shown above. For handling of the negative value of inputs, you should change the configuration od diode. The analysis of the circuitry is shown in the above figures is discussed as starting with the factor that Vout -VF and IFIin there is no current exist at inverting input. Vout -VF IF Iin VinR1 Now we have Vout - (kTq) ln(VinIRRI) The terminology kTq is a constant value that is equal to the twenty-five milliVolts. So the value of output voltage will b. Vout -(0.025 V)ln(VinIRR1) By the above equation, you can observe that the output voltage is at the negative of logarithmic of the input single. The value of output is regulated through the value of the input signal and by varying the resistance. Log Amplifier connected with BJT The base-emitter junction configuration of BJT indicates a similar category of log feature as we discuss in the case of diode since it also has a PN junction configuration. The log amplifier having BJT has linked tot he common base configuration in the feedback loop as you can see in the below figure. You can see that the Vour according to ro the ground is equal to the -VBE.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |