JacMar Freeware

    Account Record by Jack Karnes

Account Record is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 9/14/06
Account Record tracks and updates the activity of an account (money market, checking, IRA, etc.) including deposits, withdrawals and types of accumulating interest (compounded, simple, etc.). Will track any number of accounts. Also includes a running balance.

Index Page

    Auto Records by Jack Karnes

Auto Records is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 1/29/03
A good tool for those that are particular about their cars. A necessity for those who are not. Makes it easy to check mileages and dates of last lubes, tire, and battery purchases, and brake service. Keeps a record of all expenses for one or two cars. Records serial number and original purchase price and other important data.

Index Page

    Bookmarks and Favorites Lister by Jack Karnes

Bookmarks and Favorites Lister is an Excel spreadsheet, and requires Excel version 98 or later. Last Update: 4/24/05
This macro lists your Bookmarks or Favorites on an Excel spreadsheet so that you can print a record or be able to easily read the address (URL).

Index Page

    Calculator by Jack Karnes

Calculator is an Excel spreadsheet, and requires Excel version 5 or 98. A short version is available that includes only the first six items listed below. Aslo, a short version is available for non US users. This version uses no currency symbols. It also allows the user to select any country for currency conversions. A fourth version (Financial Calculator SP) is available that contains 12 financial calculations and an amortization creator. This version has the advantage of allowing the user to re-calculate while retaining entered data. Last Updates: 4/14/03, SV 4/14/03, SVNS 4/14/03, SP 5/13/03.
Contains the following:

Index Page

    Compiler and Duplicate Deleter by Jack Karnes

Compiler and Duplicate Deleter is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 3/27/02
Compiler and Duplicate Deleter is a file that makes it very easy to consolidate lists. It also provides a tutorial for using the Consolidate function in Excel. Additionally the Duplicate Deleter will delete duplicates when you wish to combine two lists.

Index Page

    Complete Suite by Jack Karnes
Complete Suite is an Excel spreadsheet requiring Excel version 5 to 2004. Last Update: 2/27/09
This file is similar to Calculator, above, but in a completely different format.
Contains the following sheets:
    1. Financial Calculator (Includes 13 functions).
    2. Retirement.
    3. Miscellaneous:
      A. Optimum weight finder.
      B. Metric Converter.
      C. Byte Converter.
      D. Amortization schedule creator.
      E. Financial Calculator (Includes 14 functions).
      F. How Much House?
      G. How Much Accumulation?
      H. Find Comparable Tax Rate.
    4. Currency Converter.
    5. Elapsed Time Calculator.
    6. Mileage Finder.
    7. Easy Sabre Codes.
    8. Text Manipulator.
    9. Folder Lister.
    10. Travel Phone Numbers.
    11. Presidents information and game.
    12. States information and game.
    13. Easter Date Finder.

    o Download Excel Version 5 to 2004 Now (217K)

Index Page

    Construction Costs by Jack Karnes

Construction Costs is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 8/11/00
Construction Costs allows the user to record each payment of a construction project (new house, new bedroom, etc.), and then categorize the payments into a summary. Invaluable record for future tax purposes. Allows for changing categories and replacing original list.

Index Page

    Currency Converter by Jack Karnes

Currency Converter is an Excel spreadsheet requiring Excel version 5. Last Update: 2/7/02. Last Import Update:6/23/05. Last Foreign Import Update: 6/23/05.
The Currency Converter converts foreign currencies to U. S. dollars or visa versa. Currency Converter - Import is available that allows the user to copy the factors from a web site and easily update your file. This version requires Excel 98.
The Currency Converter Foreign is for non US users. This allows the user to select their own country's currency and to convert currencies to that selection. Requires version 98 or 2001.
The Euro Converter is a conveient file to include in your lap top while traveling in the twelve Euro countries. Requires version 5+. Last Update 6/27/05.

Index Page

    Custom Backup by Jack Karnes

Custom Backup is an Excel spreadsheet requiring Excel version 98 and AppleScript (System 7.5 or later contains all AppleScript requirements). Last Update:4/18/01
The purpose of Custom Backup is to allow the user to copy folders to a backup disk with the freedom of being able to copy just one folder or any number of folders, up to 20, or to copy all 20 folders to a backup disk. Custom Backup not only copies the folders, but always puts them back in the same position. It is especially effective with Zip disks as the backup disk, however, any disk may be used.

Index Page

    Distance Finder by Jack Karnes

Distance Finder is an Excel spreadsheet that requires Excel version 5 or 98. Last Update: 7/26/04
The Distance Finder and Mileage Finder will find the distance between the 1,800 locations. Locations may be added if the coordinates are included. It will also create a list of the distances to all cities in the list from one particular location. In addition, it will create an itinerary schedule that will give the distance between each location of the itinerary, and the total distance covered. Calculates distances by great circle method and triangular method in both statute miles and Kilometers.

A new Distance Finder is now available that will find the distance between the original 1,800 locations plus 2,190 more for a total of 3,990 locations. Contains the same features as the above Distance Finder plus some added features.
o Download Excel Version 5 Now (114K)
o Download New Excel Version 5 With extra data now (227K)

Index Page

    Fee Calculator by Jack Karnes

Fee Calculator is a Excel spreadsheet requiring Excel version 5+. Last Update:6/12/01
Fee Calculator allows the user to calculate client fees based on time expended. Calculates total fees for each client. Also, provides a list of all charges, and a consolidation total for each client, and a total of all fees.

Index Page

    Financial Suite by Jack Karnes
Financial Suite is an Excel spreadsheet requiring Excel version 5 to 2004. Last Update: 9/14/06
There is also a version of this file created for Excel 2004. Excel 2004 requires OS X. Updated 9/14/06.
Contains the following sheets:
    1. Financial Calculator (Includes 15 functions and amortization schedule creator). Two added functions: How Much House? - How Much Accumulation?
    2. Currency Converter.
    3. Elapsed Time Calculator.
    4. Miscellaneous:
      A. Fund Analyzer.
      B. Fund Creator.
      C. Required Distribution for IRA holders over 70.
      D. What If?
      E. Net Worth (Calculates net worth and creates a printable sheet).
      F. How Much for How Long?
      G. Find Marginal Tax Rate. H. Find Comparable Tax Rate.
    5. Monthly Bills Calculator.
    6. Account Record tracks checking or money market accounts with deposits and withdrawals. Includes a running balance.
    7. Payment Schedule calculates amounts and payment dates of bonds.
    8. Expense Record.
    9. Trip Expense Record (More Detailed).

    Items 5 through 9 may be created into separate workbooks.

    o Download Excel Version 5 to 2004 Now (140K)

Mini Financial Calculator (4 1/2" X 2 1/2"). Contains all functions of item 1 of Financial Suite. An Excel spreadsheet requiring Excel version 5 or 98. Last Update: 11/13/02

o Download Excel Version 5 Now (19K)

Index Page

    Folder Lister by Jack Karnes

Folder Lister is an Excel spreadsheet, and requires Excel version 5 or later. Last Update: 8/26/03
Folder Lister will create a list of all files within a selected folder.

Index Page

    Folder Record by Jack Karnes

Folder Record is an Excel spreadsheet, and requires Excel version 98 and OS 7.5 or later. Last Update: 12/7/01
Folder Record will create a record with the following information for each file in a folder: File name, last modification date, icon position, and size. Number of folder records is restricted only by memory. Data may be easily updated.

Index Page

    Get Info by Jack Karnes

Get Info is an Excel spreadsheet, and requires Excel version 98 and OS 7.5 or later. Last Update: 5/21/01
Get Info will return the following information: File name, creation date, last modification date, size, icon position, version, creator, space available, type, window, alias. It will also create a list of all folders contained in a disk or folder, and get and set memory for applications. In addition, it will create a list of all folders on a disk or folder, their positions, modification dates, and sizes.

Index Page

    Golf Handicap/Index and Leaderboard by Jack Karnes

Golf Handicap/Index and Leaderboard is an Excel spreadsheet, and requires Excel version 97 or 2000. Last Update: 3/13/01
Golf Handicap/Index calculates your golf handicap and index and tracks other vital items, such as wagers. Leaderboard creates handicaps for any number of players or number of rounds in any particular tournament for players without established handicaps.

Index Page

    Index Creator by Jack Karnes

Index Creator is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 11/5/01
Index Creator creates an index page for your workbook. It will create up to 29 or 59 additional buttons to select up to 30 or 60 worksheets in your workbook(depending on which version you select). If you will not require more than 29 worksheets, we recommend using the 29 button version because it does not require scrolling for a 15" monitor.

A newer version is available that allows any number of worksheets (limited only by available memory) to be selected. Instead of buttons, a list box is used.

Index Page

    Monthly Bills by Jack Karnes

Monthly Bills is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 3/16/00
Monthly Bills allows the user to determine the amount of money required to transfer (from money market account, etc.) to checking account to cover monthly bills.

Index Page

    Object Controller by Jack Karnes

Object Controller is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 11/25/01
Object Controller controls the placement and assignments of objects in Excel spreadsheets. Anyone who has tried to align button placements in Excel realizes how difficult it can sometimes be with the mouse. This macro makes precise alignments possible. You can also use it to change macro assignments. It also allows the macro writer or customizer to determine immediately what color he or she is creating with the function [= PATTERNS(n,n,n)].

Index Page

    Payment Schedule by Jack Karnes

Payment Schedule is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 10/19/99
Payment Schedule creates a schedule of the payment amount, and month to be paid of your portfolio of bonds. Requires only entering the security name, coupon, maturity date, and quantity.

Index Page

    Presidents and States by Jack Karnes

Presidents and States is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 5/9/99
Presidents and States contains the life dates, party, place of birth, term dates, and Vice President of all our Presidents. It also lists the capitols, official abbreviations, and the date each of our states entered the Union. It also contains a game for both Presidents and States that makes it easy to learn the above facts.

Index Page

    Retirement Kit by Jack Karnes

Retirement Kit is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 4/22/01
Retirement Kit calculates the longevity of a retirement fund from a set monthly withdrawal. It also calculates the number of years required to meet a retirement fund goal at a set monthly investment or conversely, it calculates the amount funded over a specific length of time at a set monthly contribution. Lastly, it calculates the required disbursement from IRA funds for those over 70 1/2 years.

Index Page

    Sabre Codes by Jack Karnes

Sabre Codes is an Excel spreadsheet that requires Excel version 5 or 98. Last Update: 6/26/99
Sabre Codes is a helpful aid when working with Eaasy Sabre. It lists the codes for 49 air lines, 119 cities, and 176 hotels or chains. Any of the lists can be added to or updated.

Index Page

    Sports Stats by Jack Karnes

Sports Stats is an Excel spreadsheet that requires Excel version 5 or 98. Last Update: 11/9/03
Keep track of your favorite team in the NFL, NBA, or NHL. Sports Stats calculates the standings, and makes it easy to determine the wildcard teams.

Index Page

    Time and Date Formatter by Jack Karnes

Time and Date Formatter is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 11/17/99
Time and Date Formatter allows users downloading long columns of times or dates from the internet to reformat those imports. Formats 24 hour time designations into AM/PM format, and formats dd/mm/yy to m/d/yy or mm/dd/yy, and yyyymmdd format into mm/dd/yy format. Example: Converts 1630 to 4:30PM; converts 25/12/99 to 12/25/99; converts 19991114 to 11/14/99.

Index Page

    Travel Phone Numbers by Jack Karnes

Travel Phone Numbers is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 2/11/03
Travel Phone Numbers contains 800 numbers for air lines, hotels, car rentals, cruise and rail lines.

Index Page

    Trip Kit by Jack Karnes

Trip Kit is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 7/13/05
Creates a custom calendar for recording an itinerary, and an expense record of extreme detail (tracks air miles, etc.). Contains travel phone numbers, airline codes, and city codes.

Index Page

    URLs and Addresses by Jack Karnes

URLs and Addresses is an Excel spreadsheet, and requires Excel 98 and AppleScript (System 7.5 or later contains all AppleScript requirements). Last Update:4/18/01
Creates a list of your Eudora addresses, Navigator Bookmarks, or Explorer Favorites.

Index Page

    XL Invoicer and Inventory Control by Jack Karnes

XL Invoicer and Inventory Control is an Excel file, and requires Excel 98. Last Update: 2/22/02
With the use of a customer list and inventory list (contained in the file), the user can create an invoice that accurately addresses, prices, weighs, and adjusts the inventory. Also includes a summary of all invoices created. Update adds a purchase order form among other changes.

Index Page

    XL Menu Enhancer by Jack Karnes

XL Menu Enhancer is an Excel add-in file, and requires Excel 98. Last Update: 4/14/03

A version of this file for non US users is available that does not require a change to the Numbers control panel. Last Update: 4/14/03

Adds the following menu items to the following Excel menus:
View Insert Format Data
Info Find Remove Gridlines Expand Window
Display Open Files Select Return Gridlines Return Toolbars
Financial Calculator Delete File Remove Headings Compare Files
Metric Converter Alphabet/Numbers Return Headings
Byte Converter Set Proper Case Change Column Width
Amortization Schedule Object Controller Return Column Width
Currency Converter Button Mover Clear All
Days Calculator See Key Codes Short Date - Today
Long Date - Today
Freeze Value in Cell
Freeze Page
Color Sheet
Remove Color

(A complete description of the functions of each of the above menu items is contained in the Read Me file in the XL Menu Enhancer folder)

Index Page

    XL Opener Control by Jack Karnes

XL Opener Control is an Excel spreadsheet, and requires Excel version 5 or 98. Last Update: 9/7/03
XL Opener Control creates a control sheet for opening your Excel files. It will create up to 30 or 60 buttons to open your Excel files (depending on which version you select). If you will not require more than 30 buttons, we recommend using the 30 button version because it does not require scrolling for a 15" monitor.
A newer version that uses a list box instead of buttons is now available. This file allows the user to open any number of Excel files in up to 5 folders. Updated 1/25/05

Index Page

top of page