Text Box:           Text Box: Microsoft EXCEL solutions for Industry and Education. Text Box: Instrumentation Software.    Picaxe to Excel. Text Box:    Home of            XLNEC Text Box: AX2 VCI is Peter Ward’s Australian  Communication Authority License, a non-amateur allocation for research purposes.   The AX2VCI lab. Is located close to Bairnsdale,  in Victoria,  Australia. These majestic King Parrots are regular visitors.       Text Box: This site is your download source for Microsoft EXCEL 2003 format files covering all aspects of antenna design. construction, matching, and measurement. These workbooks authored by Peter Ward (RF1, RF2, RF3, and XLNEC) are free, with the source code  unlocked. Users can access the  code for Smith Chart and stub related  problems, as well as code for a host of RF calculations related to antenna measurement, matching, SWR and NEC. NEW NEW NEW  For educators, a Zipped ‘Kit’ showing how to interface a Revolution Education 'Picaxe' directly to Excel via the serial port is now here available for free download. See below. Free EXCEL workbooks for RF Calculations and Picaxe interfacing **Text Box: Can you use these custom charts for Excel?  Download     CUSTOMCHARTS.ZIP   Text Box: The “RF” files are those that have been  freely available since 1998 from   “The Unofficial NEC              Archives”   Now made available here,  directly from the author.   Because of the worries attached to the activation of EXCEL spreadsheets containing Macros, all my workbooks are unlocked, allowing you full access to the source code. Verify the code for yourself for peace of mind!     The Revolution Education 'Picaxe' related material is new for May 2006, and should help teachers and students add a new dimension to their Picaxe use. Many have walked around the perceived difficulty in having the Picaxe talk to Excel via the serial port, but the material available here will make it easy. Text Box: Contains instructions for these three.  Source Code is included for the Speedometer Chart. “Jon’s Charts” is your source page for all the tricks needed to build these handy Excel Charts, and more. Take a look at it. Thanks, Jon. Text Box: RF1.ZIP      Basic measurements related to RX / TX installations. Includes cable loss calculator for any coax., ERP and EIRP analysis. Rounded Rectangular Callout: EXCELent Text Box: RF2.ZIP      Calculations for stub calculation and placement, matching, and Impedance Chart related problems. VBA source code is unlocked. Text Box: RF3.ZIP      A wealth of sheets related to antenna design, bandwidth, and construction.. Text Box: RF4.ZIP      Practical projects and calculations related to antenna construction, and many other workshop related calculations. Text Box: XLNEC.ZIP  Not available presently, currently being updated. Automates NEC modelling and antenna design. Step through a design, varying up to three factors at each step. Thumbnails are printed for each run, allowing fast identification of patterns of interest. Download the old version from the “Unofficial NEC Archives” if you are desperate!   Having difficulty with any of the above files? Let me know, as several unexplained error messages have occurred with the conversion from EXCEL 95 to EXCEL 2003 format. Text Box: PICAXETOEXCELKIT.ZIP All necessary instructions and controls to enable serial communication from Picaxe to Excel in real time. Sample workbook and Picaxe programs show you how to get started immediately. Direct  serial communication between Picaxe and Excel allows a whole new world of convenience. Let Excel do the floating point processing.  Build a chart to display data as it arrives. The example provided  charts  ‘n’ data readings, against a Time/date stamp, and after ‘n’ readings are acquired continues charting always discarding the earliest reading.