Date   
Re: 10 MHz crystal matching

Hans Summers <Hans.Summers@...>
 

I just measured the resonance frequency of ten 10 MHz
crystals. I found a set of four within 30 Hz and
another set of four within 45 Hz.

How does this compare to other peoples results?
Here are my measurements in ascending order:

9,994,677
9,994,704
9,994,733
9,994,747
9,994,799 0
9,994,811 +12
9,994,821 +22
9,994,829 +30
9,994,874
9,994,887

You can see the chosen 4, which are within 30 Hz. I wouldn't have been able
to match a second set within 45Hz.

Note: these frequency counter readings are on my homebrew frequency counter
(http://www.hanssummers.com/electronics/equipment/radiofreqcounter/intro.htm
) which is installed in my 80/40m receiver
(http://www.hanssummers.com/radio/polyphase/index.htm). Previously in 30m
QRSS beacon experiments (http://www.hanssummers.com/radio/qrss/index.htm) I
built a simple 30m direct conversion receiver
(http://www.hanssummers.com/radio/30m/index.htm) and calibrated the
frequency counter against the Moscow RWM timesignal on 9,996,000. My counter
was reading just over 1KHz too low at this frequency. So the measurements
above would need to be revised upwards by about 1KHz. But it's the relative
frequency which is important here anyway, and I haven't repeated the
calibration.


Did somebody already plot the passband shape of a
resulting 4 crystal filter?
How do you do that? Figure out the shape that is?
Farhan has spoken about theoretically determining the shape. I'd also like
to see experimental measurements. One way is to use a spectrum analyser with
tracking generator and very narrow bandwidths available. The filter shape
would appear directly on the screen. I built a spectrum analyser
(http://www.hanssummers.com/electronics/equipment/spectrumanalyser/index.htm
) and someday I will make a tracking generator, but not yet (too many other
projects).

When I have time, I indend to build another logarithmic amplifier using the
excellent (but expensive) AD8307 chip. Using this with a voltmeter to
measure the logarithmic output, a frequency counter and a 30m VFO it would
be possible to take a series of measurements of the filter attenuation at
different frequencies and plot the curve. The log amp on my spectrum
analyser can be seen here:
http://www.hanssummers.com/electronics/equipment/spectrumanalysertemp/logamp
/index.htm. You'll note that it's a very simple circuit. I think this will
provide a cheap way to obtain the passband curve.

72/3 de Hans G0UPL
http://www.HansSummers.com

Re: level and wave shape after balans mixer?

Charles Darley
 

Hi All
 
I rather agree with Mark - I have done a lot of construction in the past and the absence of such info takes a long time of searching for a fault.  AND It will make great testing and fault finding practice for my club members whilst I am building the project.
 
the question is how best to show it ...
 
I suggest a second schematic so that the first is used during construction and then the second during testing.  At the point where  a value wants to be put annotate with an arrow and letter and then list the information separately ..
 
Mark if you give me the info then I would happily try to do a suitable sheet and post it to the group fro discussion
 
Regards Charles
 
 

-----Original Message-----
From: Mark [mailto:Mark@...]
Sent: 01 July 2004 12:19
To: BITX20@...
Subject: [BITX20] Re: level and wave shape after balans mixer?

- farhan wrote:

i am convinced that we need to add detailed test measurements for the
transceiver on the site. i have most of them in my log book. i will
post them soon.

I would welcome test measurements - two days of head scratching so
far! The RX is alive in my rig but not yet kicking! I have a lot of
BFO audible in the output also I have had to bypass the xtal filter
and the band pass filter to get any signal strength.

I'll tell you all this story just for fun. I had no joy with the
band pass filter and nearly threw the rig out of the window. Then I
realised that when I had "made" 2.2 pm out of 5 x 10pf caps I had
them in parralel and not series! Oh boy, the basic mistakes!

I try some more tomorrow.

Mark G0MGX



--- In BITX20@..., "vdberghak" wrote:
> Thanks for the additional information.
>
> > the correct schmatics are now at www.phonestack.com/farhan.
> I checked again http://www.phonestack.com/farhan/bitx.html and
found
> out that point 5 and 6 are stil wrong (not in accordance with the
> data sheet, as noticed and posted by someone else).
> I connected it correctly but an other person that follows the
> schematic can have serious problems.
> (if you make adjustments to your site, may be you can also add a
> link to this yahoo group?).
>
> The point is that I expected more output after the mixer. I am
> always suspicious with that kind of coils (did I take the right
one,
> did I make the correct connections, is it really working the way
it
> should be) so I like to check something.
>
> > if you have already made the crystal filter, it is best that you
> measure
> > and check the signal at the output Q12 (without the RF mixer
> connected).
> I will work on it today and add directly the next stages to
> terminate the filter as good as possible. I hope the output will
> then be incresed some more otherwise I do not end up with enough
> power at the end (or am I pessimistic ;-)  ).
>
> > have you tested the receiver  yet? it is usually the recevier
that
> comes
> > alive first.
> The receiver works, while connecting a wire to Q3 I hear a lot
more
> then with the wire connected to the mixer.
>
> > i am convinced that we need to add detailed test measurements
for
> the
> > transceiver on the site. i have most of them in my log book. i
> will post
> > them soon.
>
> In general, voltages can be checked easily to find out roughly
that
> the connections are correct and the correct values resistors are
> mounted. Some general clues about what can be expected while
> connecting a wire to a point or what voltage can be measured with
> simple test gear would make it more complete indeed. May be
current
> with and without oscilator on (for every stage) will avoid the
need
> for more test equipment?
> Adding too many measurement possibilities may be prevents a lot of
> people building the design because they think it is all needed.
> Doing the way you do now makes it important for everyone to
> understand the circuit resulting in a higher level of radio
> amateurs ;-)
>
> Other builders comments?
> Best regards,
> Chris, PA3CRX


Bitx 20, Help me!

felipetanaweb <felipetanaweb@...>
 

Please I do not have the 10MHz crystals to make the filter, but I
have 5 pieces of 8MHz crystals with this 8MHz crystals is possible to
make the filter with new values of resistor and capacitor?And to
modify the Bitx20 to Bitx40 is only to modify the Band Pass filter
and de oscillator?Somebody has this modification?

Thanks!

Re: Bitx 20, Help me!

Hans Summers <Hans.Summers@...>
 

Note that I have 20 spare 10MHz crystals, from my components order. Price is
£2.23 for 10 crystals, plus postage at cost.

73 Hans G0UPL
http://www.HansSummers.com

-----Original Message-----
From: felipetanaweb [mailto:felipetanaweb@...]
Sent: 01 July 2004 14:33
To: BITX20@...
Subject: [BITX20] Bitx 20, Help me!


Please I do not have the 10MHz crystals to make the filter, but I
have 5 pieces of 8MHz crystals with this 8MHz crystals is possible to
make the filter with new values of resistor and capacitor?And to
modify the Bitx20 to Bitx40 is only to modify the Band Pass filter
and de oscillator?Somebody has this modification?

Thanks!

Components

Hans Summers <Hans.Summers@...>
 

The order for the 2nd round of components is now in. With any luck, they
arrive tomorrow and I despatch them to you tomorrow. Due to a shortage of
2N2219 at Viewcom I ordered the real 2N2218 from Mode Components. Slightly
cheaper too :-)

Just like last time, I have ordered two extra sets of components, comprising
all semiconductors, ten 10MHz crystals, trimmer capacitors and a 200pF
tuning capacitor. If anyone wants one of these two spare sets, the price is
exactly £8, plus £0.28 UK postage (or whatever the postage for 50g to your
country is, if you are outside the UK).

72/3 Hans G0UPL
http://www.HansSummers.com

Re: Bitx 20, Help me!

Chris van den Berg
 

Hi,

Please I do not have the 10MHz crystals to make the filter, but I
have 5 pieces of 8MHz crystals with this 8MHz crystals is possible
to
make the filter with new values of resistor and capacitor?
this kind of filter can be made with several x-tals.
For SSB usualy x-tals above 10 MHz are used, however, lower is also
possible.
The lower the x-tal frequency, the smaller the capacitors between
the x-tals must be.

modify the Bitx20 to Bitx40 is only to modify the Band Pass filter
and de oscillator?Somebody has this modification?
Because almost everything is broadband, it is possible to make it
for the band you want. Exact details: with a dipper and some
experiments you will find it out!
Best regards,
Chris, PA3CRX

PTO/VFO for BITX40

Arvid Evans <arvevans@...>
 

BITXers

There are several alternative ways to build various parts of the BITX
design. For my BITX40 I chose a PTO type oscillator for the VFO.
This uses a layout similar to that done by Jom - WA6OTP
<www.wa6otp.com&#92;pto.htm> for the mechanical construction, but is a BJT
based Clapp oscillator circuit with emitter-follower VFO buffer. A 32
tpi (turns per inch) brass screw is threaded into a coil of #28 wound
on a soda straw and covered in hot-melt glue. The present tuning
range is about +350 KHz for my version. This covers all of 40 Meters
(7.0 - 7.3 MHz) in 28 turns of the knob. I am still tweeking this to
try for 10 KHz per turn, but that is not quite working yet.

A picture has been posted (see PHOTOS in the BITX20 forum pages under
K7HKL) to show the mechanical design. A schematic has not yet been
finalized because the oscillator is prototype and still being modified
for tuning range and temperature stability.

K7HKL

Re: - Correct schematics

g4dfv2004 <duncan.walters@...>
 

Ashtar, I have followed the link to your site:-
www.phonestack.com/farhan
and the schematic around the LM386 still looks the same as before.

Duncan G4DFV

Re: Bitx 20, Help me!

Arvid Evans <arvevans@...>
 

--- In BITX20@..., "felipetanaweb" <felipetanaweb@b...> wrote:
Please I do not have the 10MHz crystals to make the filter, but I
have 5 pieces of 8MHz crystals with this 8MHz crystals is possible to
make the filter with new values of resistor and capacitor?And to
modify the Bitx20 to Bitx40 is only to modify the Band Pass filter
and de oscillator?Somebody has this modification?

Thanks!
Felipe

I first buiilt the BITX20 and am now working on a BITX40 version.
That way I can compare DC voltages and RF & AF signals with a working
unit as I complete the 40 Meter version.

Here are some changes that are being incorporated into my BITX40 as I
modify Farhan's design for 40 Meters, and to fit the contents of my
junk box:

1) I used 10.7 MHz IF transformers from an old AM/FM radio to
build the front-end bandpass circuit. There is a photograph and
schematic of this in the "photos" section of this web forum under my
callsign, K7HKL.
2) Since I am using the original 10 MHz crystal filter design, my
VFO needs to tune 7.0 to 7.3 MHz below the IF frequency. That means
that the VFO range will be from 3.0 to 2.7 MHz. Since that is a bit
lower in frequency than in Farhan's BITX20, the oscillator coil will
need more turns. In my BITX40 version I did not use the BITX20 VFO
design. Instead I am using a PTO (Pearmability Tuned Oscillator)
design that is close to what WA6OTP is selling in kit form ( see
<www.wa6otp.com&#92;pto.htm> for a picture of Jim's design ), but my PTO
is for 3.0 to 2.7 MHz. Using this PTO design for the VFO avoided the
need for the higher voltage (36 V) zener diode and also eliminated the
need for using two separate tuning capacitors (a larger band-set and
the smaller zener fine-tuning capacitor). My VFO capacitors are all
fixed-value with just a small trimmer cap to calibrate the upper band
edge. All tuning adjustments are accomplished with about 30 turns of
the brass screw in the PTO design. If you use a brass screw PTO
please note that the frequency will "increase" as the screw is
inserted into the coil. One negative part of the PTO design is that
the tuning knob will move forward and backward about an inch (2.5
cm)from your front pannel as the frequency is changed. A photo of
this unit in its current state of construction is shown in the photo
section.
3) To test my crystal filter I built the BFO circuit from the
BITX20 design on a separate of circuit board and added the inductor
and variable capacitor in series with the crystal. This gave me a
very stable oscillator that could be tuned across the filter passband
to determine the shape factor. This signal was injected into the
input of the filter and a simple diode & capacitor type RF detector
was used with my voltmeter to measure the output. I do have a
frequency counter so I was able to determine the exact frequency that
was being output by my test oscillator. As the frequency was varied I
was able to plot the output voltage on a sheet of grid paper. I would
assume that you might do something similar in building your filter
using 8 MHz crystals. Remember that the center capacitor in the
filter is double the capacitance of each of the end capacitors. So
you will need 4 capacitors of the same value ( one on each end and two
in parallel in the middle ).
4) In my BITX20 and also in my BITX40 I changed the audio output
circuit from Farhan's original design. Since I usually use headphones
there was no need to have the audio level provided by the LM-386
integrated circuit. I used a simple LM-741 Op-Amp in place of the
LM-386. My op-amp runs a voltage gain of 100 that was achieved by
using a 100K feedback resistor and a 1K input resistor on the
inverting input. I will try to place a schematic of the op-amp
circuit on this web site later today.
Later I did add speaker capability to my BITX20 by building a
separate amplifier (it is in the external speaker case) using an NPN
transistor driving an NPN & PNP pair for about 1/2 watt of audio. I
will try to also add a schematic of that to this web site later today.
5) For the tap washers in Farhan's design I substituted 1/4 inch
wide slices of 1/2 inch (1.25 cm) PVC pipe. These measure about 5/8
inch ID and nearly 3/4 inch OD so they are slightly larger ID than the
tap washers but they worked fine. I already had the plastic pipe so I
did not need to make a trip to the hardware store for the tap washers.
A picture of these PVC coil forms is in the photos section under my
callsign. Note that I cut a slot in the side of my PVC coil forms to
make it easier to wind the inductors. This allows the wire to be
passed through the slot instead of threading each turn through the
center of a closed loop of plastic. Since the PVC does not affect the
magnetic properties of the coil, adding this slot has no affect on the
resulting inductance.

I hope this helps you and others that want to make alterations to
Farhan's excellent design. Like you I needed to make some changes to
accomodate the parts that I already had available for this project.

My BITX40 is not complete yet, but as I finish construction and
testing of each section I will try to post pictures and comments on
this web site. Like I said earlier, it really helps to have a working
BITX20 available for comparison testing with the sections of my BITX40
that are significently different from the original design.

Good luck on your effort,

Arv - K7HKL

Components round 2

Hans Summers <Hans.Summers@...>
 

All components arrived here today. I have counted them all out into the
component packs and despatched them.

Note that I have two spare packs, if any latecomers would like one: price is
£8 + £0.28 UK postage, or whatever 50g costs to your country. These
components are at supplied by me at cost, from Farnell, Rapid Electronics
and Mode Components. Many are discounted due to bulk buy crystals,
transistors etc in QTY 100+. The pack comprises all semiconductors, crystals
and variable capacitors: 10x 10MHz xtals, 25x BC547B, 2N2218, IRF510, 15x
1N4148, 36V Zener, 9V1 Zener, 5V6 Zener, LM386N-1, 5x 22pF trimmer,
miniature 200pF tuning capacitor.

72/3 de Hans G0UPL
http://www.HansSummers.com

Re: Bitx 20, Help me!

Jim Strohm <jstrohm@...>
 

On Jul 2, 2004, at 10:37 AM, Arvid Evans wrote:

I first buiilt the BITX20 and am now working on a BITX40 version.
That way I can compare DC voltages and RF & AF signals with a working
unit as I complete the 40 Meter version.

Here are some changes that are being incorporated into my BITX40 as I
modify Farhan's design for 40 Meters, and to fit the contents of my
junk box
Builders are reminded that while the IRF510 final may be a little hard to find and may be a little expensive, many other power FETs will amplify quite nicely on lower frequencies, .

In the late 1980s and early 1990s, some ARRL members performed experiments with power FETs salvaged from switching power supplies. Their results as published in QST indicated that almost everything worked well at 40 meters or below.

Builders are especially reminded that IBM vastly over-engineered and de-rated power supplies for its minicomputers such as the AS/400, and a lot of those are coming onto the surplus market -- or winding up in landfills. These are EXCELLENT sources for builder parts -- with the caveat that lmost every semiconductor is marked with an IBM part number, so you'll need to bin parts as you remove them. The DIP ICs are all useless, except for use as art supplies.

I don't have a lot of experience with Hewlett-Packard minis, but most of the old 3000s, 5000s, and some 9000s should be surfacing soon, for the last gasp before the dust-bin. I **do** have a partial cross-reference for HP-numbered semiconductors, so these ARE worth hanging onto.

I'll post the list to the files section here when I find it. Alas, it's a .gif and I don't feel like typing it into a text file, and the reproduction quality is bad enough that OCR won't read it reliably.

Jim N6OTQ

HP Parts Xref

Jim <jstrohm@...>
 

I found it (surprised myself). It's now in the file section in a folder named "hp_parts_xref".
Six .gifs, all about 250K.

I found these files on the internet a few years ago and as far as I know it's fair game for
sharing with others.

It would be nice if some day this got converted to text, but since I won't start today, I
won't ask anybody else to, either!! We have things to build. I'm salvaging some PC boards
today with my hot-air gun. I think I've made about USD$3 already -- in just half an hour.

Jim N6OTQ

Resonance Calculator Tool

Arvid Evans <arvevans@...>
 

In the "files" section of this forum I have uploaded a small
spreadsheet program called "RESONANCE CALCULATOR.xls". This is a
spreadsheet program that helps calculate inductance, capacitance, or
frequency for various combinations of L and C. I found this very
handy in re-calculating the inductance values for converting Farhan's
BITX20 design into a BITX40 transceiver.

This is a Microsoft (tm) Excel spreadsheet, but if you do not have
MS-Excel all is not lost. You can go to <www.OpenOffice.org> and
download their FREE Open Office program. The spredsheet tool in Open
Office can read and execute MS-Excel programs. FYI: Open Office is
available for both MS-Windows and Linux, so if you are a Linux user
like me you now can have an equivalent of all the MS-Office tools for
FREE!

If anyone has problems with this spreadsheet, please let me know
because I can easily generate and upload both MS and OpenOffice
specific versions of this tool. If you need to "unlock" the
spreadsheet to make your own changes to the layout or formula, also
please let me know and I can provide you with the program password.

Arv - K7HKL

Re: Resonance Calculator Tool

Charles Darley
 

Hi Arv
 
Thank very much for the spread sheet ... This is something that I will  demo at the club during the sessions on the building of the project ..
 
73  Charles  G4VSZ

-----Original Message-----
From: Arvid Evans [mailto:arvevans@...]
Sent: 02 July 2004 19:45
To: BITX20@...
Subject: [BITX20] Resonance Calculator Tool

In the "files" section of this forum I have uploaded a small
spreadsheet program called "RESONANCE CALCULATOR.xls".  This is a
spreadsheet program that helps calculate inductance, capacitance, or
frequency for various combinations of L and C.  I found this very
handy in re-calculating the inductance values for converting Farhan's
BITX20 design into a BITX40 transceiver.

This is a Microsoft (tm) Excel spreadsheet, but if you do not have
MS-Excel all is not lost.  You can go to and
download their FREE Open Office program.  The spredsheet tool in Open
Office can read and execute MS-Excel programs.  FYI: Open Office is
available for both MS-Windows and Linux, so if you are a Linux user
like me you now can have an equivalent of all the MS-Office tools for
FREE!

If anyone has problems with this spreadsheet, please let me know
because I can easily generate and upload both MS and OpenOffice
specific versions of this tool.  If you need to "unlock" the
spreadsheet to make your own changes to the layout or formula, also
please let me know and I can provide you with the program password.

Arv - K7HKL


L1 and L2 on PA diagram

Charles Darley
 

Hi all

Looking at the PA diagram it is indicated that from the antenna there
are two inductors L1 and L2 but the details below indicate L4 and L5.

Can anyone confirm that L1 = L4 and L2 = L5

73 G4VSZ Charles

Re: Bitx 20, Help me!

Chris van den Berg
 

Hi,
at this moment I spend hours getting the filter working for the IF
frequency of 4.9152 MHz.
It is importand that measurements are done with the circuits
connected, it seems that the load determines the passband a lot.
To have an idea about the functioning of the filter, I connected my
LF generator to the microphone connection. Measuring the output of
Q12 (with an osciloscoop or a mw meter), you see variation of the
output level while variating the LF frequency.
For the filter I made, it learned me that my filter had some peaks
that were not close together. Playing with different capacitor
values took a lot of time but with capacitor values of 68pF, 82pF,
68pF I have peaks at 1052Hz, 1538Hz, 2000Hz (after I also corrected
the coil in the BFO to get the peaks on the right places). With a
mircophone connected, I see output while talking in the microphone.
Between the peaks, the output is not completely down but I think the
filter shape is not flat enough. This weekend, I will play with some
additional serie coils, may be the impedance of the filter is much
higher then the circuit. (I hope the peaks do not shift again ;-( ).
Anyone else suggestions?

By the way, for the ones that want to see it with an analyser: may
be the BFO signal can be connected to both mixers resulting in audio
frequency mix up, filtered and down to LF again. Then a spectrum
analyser can be used with the PC sound card? (pink noise to the
microphone terminal, output of the mixer to the LF sound card input).
Just a thought, not tried.

Lets experiment further!
Chris, PA3CRX

Please I do not have the 10MHz crystals to make the filter, but
I
have 5 pieces of 8MHz crystals with this 8MHz crystals is
possible to
make the filter with new values of resistor and capacitor?>
3) To test my crystal filter I built the BFO circuit from the
BITX20 design on a separate of circuit board and added the inductor
and variable capacitor in series with the crystal. This gave me a
very stable oscillator that could be tuned across the filter
passband
to determine the shape factor. This signal was injected into the
input of the filter and a simple diode & capacitor type RF detector
was used with my voltmeter to measure the output. I do have a
frequency counter so I was able to determine the exact frequency
that
was being output by my test oscillator. As the frequency was
varied I
was able to plot the output voltage on a sheet of grid paper. I
would
assume that you might do something similar in building your filter
using 8 MHz crystals.

Re: BAND selection

Ashhar Farhan <farhan@...>
 

one of the inherent problems with 10 MHz if is that it precludes the 10
MHz band. the IF will fall within the RF passband.

it might work if you used 14.318 MHz crystals for IF and used the 4 MHz
vfo to mix down to 10MHz IF.

You have to keep the IF, RF and VFO frequencies away from each other as
well as see to it their various (and particularly odd) multiples don't
match up.

For instance, you used a 9Mhz IF for an 18 MHz design. The second harmonic
of the BFO will appear as a tunable signal in the receiver. The VFO will
also appear as a quickly tuned spur.

W7ZOI has a program called spurtune.exe that is ideal to work these spur
resposnes out.

i am not sure about the copyrights on these programs. if they are
distributable, then i can upload them to our folders for everybody to use
them. they are very useful, all of them.

- farhan

On Sat, 3 Jul 2004, MILAREPA wrote:

Dear Forum,

Suppose I plan to have some band selection in future, after 'original' 14 MHz has been set up.

I just need confirmation about my frequency 'plan' table below,
is this correct in the meaning of 'practical' especially for 10 MHz,
that the VFO need to tune 0 ~ 0.4 MHz ?



Thanks.

BAND selection

MILAREPA <MILAREPA@...>
 

Dear Forum,
 
Suppose I plan to have some band selection in future, after 'original' 14 MHz has been set up.
 
I just need confirmation about my frequency 'plan' table below,
is this correct in the meaning of 'practical' especially for 10 MHz,
that the VFO need to tune 0 ~ 0.4 MHz ?
 
 
Thanks.

The prince of FETs

Hans Summers <Hans.Summers@...>
 

I agree with all Jim's comments about the use of FET's salvaged from PSU's
etc in power amplifiers for bands 40m or below. I always like to use
"recycled" components wherever possible.

But when it comes to higher frequency amps, the IRF510 is in my opinion the
best choice available. A month or two I was considering a highly efficient
class E amp for 30m, for a /p rig. I wondered why the IRF510 was so popular
in QRP designs. Was it just fashion? Low cost (relatively)? So I read *many*
power FET datasheets to see if there was any better alternative, at ANY
price. Gate capacitance is an issue at higher frequencies, it must be as
small as possible. Similarly fast switching times are increasingly important
at higher frequencies. For best efficiency one wants low ON resistance. And
of course high power handling capability is essential.

Unfortunately, the choice of power FET necessarily involves some compromise
of these parameters. Larger device size means lower ON resistance and higher
power dissipation, but at the expense of higher gate capacitance and thereby
also slower speed. And so on. After all my searching, I was unable to find a
device that I considered offered a more optimum compromise of these
characteristics, for an efficient QRP HF amp, than the IRF510.

It therefore appears that this is THE best FET for QRP rigs, not just a
fashion or low cost, availability etc. All the more remarkable if there is
any truth in the story that I heard, about this FET originally being
designed for use switching car indicator lights. Or is this just urban
legend? Either way, long live the prince of FET's!

72/3 de Hans G0UPL
http://www.hanssummers.com

Re: Resonance Calculator Tool

arvevans@...
 

Charles

Just to make sure that all works as anticipated in your club demo of the spreadsheet program...I have attached two versions of the spreadsheet to this email. The one with the .sxc sufix is customized for Linux and OpenOffice Spreadsheet tools. The one with the .xls suffix is my original version written using Win-98 and MS-Excel. This way you can provide copies to your club members that will fit whatever computing platform they might be using.

Please feel free to distribute this program for any non-commercial use. I had fun developing the code, so maybe someone else will have fun using it.

For your own use...the sheet protection password is my callsign (all lower-case) so now you can customize the spreadsheet to include your club logo or name. Just remember to make your changes to a "copy" of the original so that if you make a mess of it you can always return to the pure original and start over (with a new copy of the original!). 8-)

73's
Arv - K7HKL
_._

-----Original Message-----
From: Charles Darley <charles@...>
Sent: Jul 2, 2004 4:57 PM
To: BITX20@...
Subject: RE: [BITX20] Resonance Calculator Tool

Hi Arv

Thank very much for the spread sheet ... This is something that I will demo
at the club during the sessions on the building of the project ..

73 Charles G4VSZ
-----Original Message-----
From: Arvid Evans [mailto:arvevans@...]
Sent: 02 July 2004 19:45
To: BITX20@...
Subject: [BITX20] Resonance Calculator Tool


In the "files" section of this forum I have uploaded a small
spreadsheet program called "RESONANCE CALCULATOR.xls". This is a
spreadsheet program that helps calculate inductance, capacitance, or
frequency for various combinations of L and C. I found this very
handy in re-calculating the inductance values for converting Farhan's
BITX20 design into a BITX40 transceiver.

This is a Microsoft (tm) Excel spreadsheet, but if you do not have
MS-Excel all is not lost. You can go to <www.OpenOffice.org> and
download their FREE Open Office program. The spredsheet tool in Open
Office can read and execute MS-Excel programs. FYI: Open Office is
available for both MS-Windows and Linux, so if you are a Linux user
like me you now can have an equivalent of all the MS-Office tools for
FREE!

If anyone has problems with this spreadsheet, please let me know
because I can easily generate and upload both MS and OpenOffice
specific versions of this tool. If you need to "unlock" the
spreadsheet to make your own changes to the layout or formula, also
please let me know and I can provide you with the program password.

Arv - K7HKL


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/BITX20/

b.. To unsubscribe from this group, send an email to:
BITX20-unsubscribe@...

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.