Program spreadsheets can be a great learning tool and, of course, are very handy when making tactical decisions concerning your detector settings. White's Spectra V3 The White's Spectra V3 has the most extensive array of settings of any detector yet made. Its menu system is, accordingly, vast. Thinking it the best way to remove any uncertainties regarding the technical operation of the V3 I set up this spreadsheet (thanks to Larry (IL) from the Find's V3 forum for the original template). A full view of a detector's internal settings can provide a clearer situational awareness, technically speaking, when out in the field.

This spreadsheet details the settings for discrimination, sensitivity, ground tracking, frequency, filter and speed, audio and configuration including all custom and color settings. Some notable features include (some only available in macro-enabled .xlsm version): Push button ON/OFF values. Otherwise, every value is selected from a dropbox containing all acceptable values. No more guessing, uncertainty, or the need for the manual or detector to verify values. Accepts typed values. Conditional formatting provides visual cues including highlighted text and Data Bars indicating relative value. Choose colors through RGB values or color picker. Each setting has a comment attached containing: Manual page. Name of setting and acceptable values. Coin default value. Manual text. Custom and color settings can be collapsed to simplify the view. Program descriptions in attached comments. In-sheet note area with optional comments. Fully customizable.

Download Version 2.1 of the V3 program spreadsheet Three versions of the file are available: Excel 2007+ Macro-Enabled .xlsm file -> most functionality - will have to enable macros. If you always make sure that you get any of my macro-enabled files from this site, you do not have to worry about anything malicious (read more) Every Setting (excluding Program menu) Pushbutton ON/OFF values Dropdown values Two methods of choosing colors including a color picker Conditional formatting Setting descriptions in comments Program descriptions in comments Global Settings Freeform Notes section Excel 2007+ .xlsx file -> standard Excel 2007 Workbook file Every Setting (excluding Program menu) Dropdown values Selection of RGB color values Conditional formatting Setting descriptions in comments Program descriptions in comments Global Settings Freeform Notes section Pre-Excel 2007 .xls file -> standard Pre-Excel 2007 Workbook file Every Setting (excluding Program menu) Dropdown values Selection of RGB color values Setting descriptions in comments Program descriptions in comments Global Settings Freeform Notes section Click a file - Open to view, Save to download the file... Spectra_V3_Programs_v_2_1.xlsm Spectra_V3_Programs_v_2_1.xlsx Spectra_V3_Programs_v_2_1.xls * Using "Open" on .xlsm file will cause problems...best to Save it to your drive before using it. Alternative formats Spectra_V3_Programs_v_2_1.pdf (Factory Programs PDF) Spectra_V3_Programs_v_2_1.ods (OpenDocument Spreadsheet) Blank formats Spectra_V3_Programs_v_2_1_blank.xls Spectra_V3_Programs_v_2_1_blank.pdf

Using the file There are four worksheets: Factory Programs - contains data for the eleven built-in programs My Programs - contains ten programs, all with the Coin Program settings My Program - contains one program with the Coin Program settings Values - used for dropbox values You will probably find yourself wanting to move programs from one worksheet to another. To do this select the three columns that comprise the desired program, right-click and select Copy. Go to the destination worksheet and select the three columns you want to replace, right-click and select Paste. You can also use Insert Copied Cells if you are building up a worksheet, or if it is just more appropriate (sometimes Insert is the only method if Paste fails). Be aware that when copying/pasting the forms controls (like the checkbox) can sporadically show up somewhere in the same row they were on...just right-click and Cut. Inserting and deleting rows is fine, just be aware that the Global Settings may be affected depending on whether the cell references get messed up or not. I may add more later, but if you know or learn Excel then that is all you need (and there are plenty of web resources devoted to that subject).

Notes Inaccuracy in Live Search -> Analysis -> Spectragraph comment...now fixed (slipstream into v2.1). Thanks to Neil in West Jersey for finding this error (actually, an error in the manual). v2.0 -> v2.1 was due to missing setting (Range Color) I saw that comments could collapse to zero (or other disadvantageous) height or move from their original locations so there are two macros you can run. modResetComments - Resets comments back to standard positions. modCommentSize - Sets comment height based on character count. The small comments have just enough room and the large ones have too much, but at least nothing is hidden. Need to fine-tune the equation. Your other option is to right-click and edit comment to fix it. I would not use them unless necessary. You may need to modify your live error checking options. In Excel 2007, go to Excel Options -> Formulas -> Error checking rules -> Uncheck "Numbers formatted as text or preceded by an apostrophe". "Unlocked cells containing formulas" may also be unchecked. This will prevent certain cells from being marked with errors. Not certain how to do this in Excel 2003. If you use the .xlsm macro-enabled version, bear in mind that if you create a new program worksheet, you should copy the "Private Sub Worksheet_Change" procedure from one of the existing worksheets to the new worksheet. This is used for color changes. The file can be modified in any way you wish, except for one thing. The "Values" worksheet cannot be renamed or removed and the values in this worksheet cannot be moved. You can change the worksheet tab order and you can edit the values "in-place" in the Values worksheet. You can add data to the Values worksheet if you don't overwrite existing data. Please report any errors to TBGO.