JacMar Freeware

    Account Record by Jack Karnes

Account Record is an Excel spreadsheet, and requires Excel version 97 or 2000. 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 97 or 2000. 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

    Calculator by Jack Karnes

Calculator is an Excel spreadsheet, and requires Excel version 97 or 2000. 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. All versions have been updated so that a conflict with the X-Bar add-in (if installed) can be avoided. Last Updates: 5/21/03, SV 5/21/03, SVNS 5/21/03, SP 5/21/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 97 or 2000. 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 97 to 2003. Last Update: 2/28/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 97 to 2003 for PC Now (217K)

Index Page

    Construction Costs by Jack Karnes

Construction Costs is an Excel spreadsheet, and requires Excel version 97 or 2000. 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 97 or 2000. 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 97+.
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 97 or 2000.
The Euro Converter is a conveient file to include in your lap top while traveling in the twelve Euro countries. Requires version 97+. Last Update 6/27/05.

Index Page

    Distance Finder by Jack Karnes

Distance Finder is an Excel spreadsheet that requires Excel version 97 or 2000. 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.

Index Page

    Fee Calculator by Jack Karnes

Fee Calculator is a Excel spreadsheet requiring Excel version 97+. 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 97 to 2003. Has been updated so that a conflict with the X-Bar add-in (if installed) can be avoided. Last Update: 2/28/09
Contains the following sheets:
    1. Financial Calculator (Includes 15 functions and amortization schedule creator). Two added functions: How Much House? - How Much Accumulation?
    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 97 to 2003 Now (141K)

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 97+. Last Update: 11/13/02

o Download Excel Version 97 Now (19K)

Index Page

    Folder Lister by Jack Karnes

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

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 97 or 2000. 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 will not require scrolling with 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 97+. 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 97 or 2000. 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 97 or 2000. 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 97 or 2000. 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 97 or 2000. 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 97 or 2000. 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 97 or 2000. 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 97 or 2000. 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 97+. 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 97 or 2000. 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

    XL Invoicer and Inventory Control by Jack Karnes

XL Invoicer and Inventory Control is an Excel file, and requires Excel 97+. 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 97 SR-1+ or 2000. Last Update: 4/14/03

A version of this file is available for non US users that does not require a change to the Regional Settings.. 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 readme 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 97 or 2000. 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 will not require scrolling with 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