¿ªÔÆÌåÓý

Re: Making a Q-meter / References etc


Rodger Bean
 

¿ªÔÆÌåÓý

Hi Dave,

Thank you for the feedback, an amended version is attached.

?

  1. The input power of watt is rounded to the nearest integer - it would be useful if it allowed a few decimal places, as entering powers in nW or similar is not unusual. But if I enter 1.4 W, it gets rounded to 1 in the input display, but the outputs are more sensible.

Done. (Working in the TV broadcast industry, most of the transmitters that I worked on were 100W up to 30KW). ?

  1. You might consider whether it's worthwhile adding dbW. I know it's not used a lot, but our amateur licenses in the UK are specified in dBW now, not watt.

Done.

  1. You say dBm is referenced to 1 mW, and dBuV is referenced to 1 uV, but for dBmV, you spell out the millivolt, rather than just put 1 mV.

Done.

  1. You mention dBu, but don't allow anyone to perform any calculations with it.

For dBu, use 600¦¸ and ignore Watts, dBm, dBmV & dbuV.

  1. There's a spelling error ¨C impemdence.
  2. Done.
  3. According to the BIPM, the body that defines the SI standards, virtually all SI units and derived units should be spelled in lower case, and without the s - so watt, ampere, volt, not Watts, Volts, Amps etc. I think the only exception to this is degrees Celsius. (I have attached a copy of the SI document).

Just a personal preference. Re SI, having lived through: fps, cgs, MKS and SI. It¡¯s all just numbers, although at least in emu & esu (electrostatic units & electromagnetic units) there was no ¦Ð in a constant. And anyway, SI is just a collection of precisely defined, arbitrary units, relating to the an ordinary planet, orbiting around an ordinary star, in remote part of a galaxy that we call The Milky Way. They have as much in common with the rest of the universe as the distance from the thumb to the nose of whoever is the current reigning monarch. (lol).

7) If on the voltage gain section, I put an input of 1 V, and an output of -2 V, the calculator shows an error.

Not so easy to fix, I could square V1 & V2 then square root them to remove the negative sign, but I don¡¯t believe that it is necessary.? And any changes that gave a negative dB would imply a loss where none exists. There may be a function that only takes the modulus of a number entry. But I think it would be easier to remember that you are using an inverting amplifier.

* It's easy to configure an op-amp to have a negative gain (inverting amplifier).

* A VNA will often measure a reflected voltage that is 180 degrees out of phase with respect to the input.

?

Rodger Bean

?

?

From: [email protected] <[email protected]> On Behalf Of Dr. David Kirkby, Kirkby Microwave Ltd
Sent: Tuesday, 30 August 2022 07:35
To: [email protected]
Subject: Re: [Test Equipment Design & Construction] Making a Q-meter / References etc

?

That's useful. Can I suggest a few improvements?

?

1) The input power of watt is rounded to the nearest integer - it would be useful if it allowed a few decimal places, as entering powers in nW or similar is not unusual. But if I enter 1.4 W, it gets rounded to 1 in the input display, but the outputs are more sensible.

2) You might consider whether it's worthwhile adding dbW. I know it's not used a lot, but our amateur licenses in the UK are specified in dBW now, not watt.

3) You say dBm is referenced to 1 mW, and dBuV is referenced to 1 uV, but for dBmV, you spell out the millivolt, rather than just put 1 mV.

4) You mention dBu, but don't allow anyone to perform any calculations with it.

5) There's a spelling error - impemdence

6) According to the BIPM, the body that defines the SI standards, virtually all SI units and derived units should be spelled in lower case, and without the s - so watt, ampere, volt, not Watts, Volts, Amps etc. I think the only exception to this is degrees Celsius. (I have attached a copy of the SI document).

7) If on the voltage gain section, I put an input of 1 V, and an output of -2 V, the calculator shows an error.

* It's easy to configure an op-amp to have a negative gain (inverting amplifier).

* A VNA will often measure a reflected voltage that is 180 degrees out of phase with respect to the input.

?

I personally would take the absolute magnitudes of the voltages and use that to calculate the gain, so as to not show an error when the input and output are of a different sign.

8) According to the BIPM, there should be a space between a number and a unit - ie 2 uV not 2uV.

9) You are inconsistent in your use of P1 and P 1, and likewise V2 and V 2. Personally I would remove the spaces, as spaces imply multiplication. Or perhaps consider the use of subscripts.

10) I think the last part is potentially wrong, if the DUT does not accept all the input power. If the device reflects a lot of power on the left hand side, then the input power can be high, the output power low, but the dissipation is also low. When calculating antenna gains, the values are in terms of power accepted by the antenna, not the input power to the antenna.

?

I can think of two things you could usefully add.

1) The ability to calculate output voltages given an input voltage and a gain.

2) Noise temperature to noise figure and noise factor conversions.

?

It looks like a useful calculator, but there are some random suggestions of mine.

?

Dave

?

Dr David Kirkby Ph.D
Email: drkirkby@... Web:
Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.


?

?

On Mon, 29 Aug 2022 at 20:45, Rodger Bean <rodgerbean@...> wrote:

I created this Excel spreadsheet to convert between Watts, Volts, dBm, dBmV and dBuV. It has simple protection applied to guard against accidental overwriting of a formula. There is no password required to turn it off.

To turn the protection off, got to ¡°file¡± then ¡°info¡±.

?

Rodger Bean

?

From: [email protected] <[email protected]> On Behalf Of Mikek
Sent: Tuesday, 30 August 2022 00:36
To: [email protected]
Subject: Re: [Test Equipment Design & Construction] Making a Q-meter / References etc

?

Well the box turned out a little silly, basically a short from BNC to BNC.
?I setup a series LC 230uh, 110pf (variable) I could not get a dip, (still unsure why, not my first rodeo)
So, I installed a better than 1%, 1¦¸ resistor as the DUT and used 50kHz to avoid any strays.
Using db on my HP 400E (unknown calibration) Using 1 volt input and 1¦¸ load, I get -26.45db with the db scale and using a voltage ratio 1/ 0.0371 = 26.95 = 28.6db
?I don't know why the printed scale would not be in agreement.
?The correct answer (according to the paper) is 28.3db, so pretty good agreement using the voltage ratio! The meter error difference is 1.3mv.
?My favorite db to voltage, voltage to db calculator.

? I received parts for another project, so this is now on the back burner, but will keep reading in case someone has ideas where I went wrong.
??????????????????????????????????????????? Thanks, Mikek

* After talking with a calibration facility, I sent my HP 400E in for calibration ($25 shipping) Then they told me, "we can't calibrate that"
?After I get my HP 3400 working properly, I'll check, I think that someone will be able to calibrate that.

>I decided to tighten it up and put the termination at the meter.
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?? Mikek ???????
??????????????????????????

?

Join [email protected] to automatically receive all group messages.