tag:blogger.com,1999:blog-93079352012-01-22T21:21:28.350-07:00New and Interesting Excel Templates and SpreadsheetsJon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger1381100tag:blogger.com,1999:blog-9307935.post-70108937467244476862012-01-19T13:02:00.003-07:002012-01-19T13:04:25.376-07:00

This new Cleaning Schedule / Checklist template will help you get organized. Add your chores to the 4-week schedule and download checklists for cleaning house and spring-cleaning.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-40319169417057570852012-01-11T15:21:00.002-07:002012-01-11T15:24:27.615-07:00

Download a few different types of Reward Charts for your kids, including a simple reward chart as shown in the image, a practice chart, school behavior chart, and a weekly reward chart for multiple kids.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-83175039799315437782011-11-16T16:35:00.003-07:002011-11-16T16:37:52.092-07:00

This new Job Application Form Template can help you gather information from job applicants without having to design your own form. You customize it as needed, or use it as-is.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-69188716414530480012011-10-18T15:09:00.003-07:002011-10-18T15:11:08.420-07:00

This new College Budget template can help you create a yearly college budget, with expenses grouped by semester.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-41849153851497411252011-10-12T15:58:00.001-07:002011-10-12T15:58:41.772-07:00

This new Inventory Control Tpreadsheet includes a worksheet for tracking current, on order, back ordered stock. It also includes an inventory label template, supplier contact info list, and physical count sheet.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-13583252939651611302011-09-28T12:28:00.002-07:002011-09-28T12:30:24.684-07:00

This new Packing List template contains lists to help prepare for business travel, vacation, and college.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-18639640260383595402011-09-20T12:19:00.003-07:002011-09-20T12:22:20.582-07:00

The new Software Inventory template was derived from the asset tracking template, but designed specifically for tracking software licenses, computer hardware, license expiration, etc.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-11061918444524726352011-07-28T16:33:00.003-07:002011-07-28T16:35:57.382-07:00

Use this Wedding Guest List Template to help you keep track of your wedding invitations and the number of people attending your rehearsal dinner and/or reception. You can also make notes about dietary restrictions and gifts received.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-10283429959746615012011-04-25T14:31:00.004-07:002011-04-25T14:35:15.779-07:00

Need a periodic table packed with element property data? Check out this Periodic Table. Thanks to print scaling in Excel, it is possible to create a good-looking, data-rich, periodic table and have it print nicely on a single sheet of paper.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-61723808861482421652011-03-08T09:33:00.002-07:002011-03-08T09:36:21.169-07:00

Download this Contact List template to customize your phone list, address list, email list or other contacts.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-31161064425465610282011-02-28T22:12:00.005-07:002011-02-28T22:17:32.626-07:00

This new family tree template contains multiple designs and layouts for creating horizontal family tree pedigree charts. The thumbnail to the left shows a portrait layout of the more colorful chart. There are also blank printable PDF versions that you can complete by hand, or share as class handouts.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-80726281216662315062011-02-01T11:26:00.005-07:002011-02-01T11:28:58.062-07:00

This new free business Start Up Costs template can help you estimate and track your expenses as you are starting a new small business. Estimating your startup costs should be a part of all good business plans.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-24289553987939753252011-01-31T13:27:00.003-07:002011-01-31T13:31:35.760-07:00

This Pro Forma Invoice can be used in place of a quote template, and the purpose is basically the same ... to agree upon the products, shipping details, and the prices before committing to a sale. A proforma invoice is commonly used for international trade.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-43004230016952865422010-12-23T13:30:00.003-07:002010-12-23T13:33:01.846-07:00

Create a Work Order Form for your business using this free template. This spreadsheet was designed mainly for service and repair companies, but can also be used for businesses that provide both services and products and materials.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-73987100856164370002010-12-16T10:39:00.004-07:002010-12-16T10:45:08.429-07:00

This new free Price Quote Template was created from the corresponding invoice template. Check out the download page on Vertex42.com for more information about the difference between an invoice and a price quote. If you have questions, you are welcome to post your comments here.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-85632592568462120322010-12-11T14:25:00.002-07:002010-12-11T14:33:52.633-07:00

This new Free Invoice Template is a great invoice for service companies. It's based on the basic invoice included in the Service Invoice template, but has a few additional features, such as (1) a column for indicating whether or not to tax a specific item, (2) three separate designs to choose from and (3) it's completely free.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-69296552960490098032010-10-23T13:04:00.002-07:002010-10-23T13:15:10.656-07:00

As the holidays get nearer, you may want to revisit your budget to make sure that you can stay on track. It's very easy to overspend during the holidays, so to avoid going into debt, create a personal budget if you don't already have one. While you at it, figure out where you're at on your various loans using this free amortization schedule.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-75666946106409643302010-10-20T13:22:00.003-07:002010-10-20T13:25:53.128-07:00

This printable Money Management Worksheet helps parents teach their children the principles of savings and banking via the "Family Bank" approach.For information about how to use this template, read the article Money Management for Kids - The Family Bank Approach.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-8296007630623415262010-10-04T09:22:00.003-07:002010-10-04T09:25:44.157-07:00

Even though it might not be time to go Christmas shopping, it is never a bad time to budget for the Holidays. This Christmas Gift Budget can help you keep track of not only Christmas gifts, but also other holiday spending as well (like food, Christmas cards, etc.).

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-60882528225001760822010-09-16T12:24:00.002-07:002010-09-16T12:27:07.165-07:00

This Reimbursement Form is for employees to request reimbursement for general business expenses like software, office supplies, etc. For travel expenses, use the Travel Expense Form

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-5499860259748916692010-08-26T14:21:00.003-07:002010-08-26T14:24:02.305-07:00

The Gift Certificate Templates were created for Word, but there is also a Tracking Log for Excel that you can use to keep track of certificates that you issue and when they are redeemed.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-86803280497657504562010-08-24T10:55:00.002-07:002010-08-24T10:58:42.517-07:00

You can download an Excel version of Inflation Calculator that lets you see how to use the FV and PV functions to perform some basic inflation calculations.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-84212113214660427132010-08-12T11:26:00.002-07:002010-08-12T11:29:30.828-07:00

Have you had a new child recently? You can find a recommended Immunization Schedule on the CDC website. If you want to keep an electronic record of vaccinations for you and your children, download this new Immunization Record for Excel.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-60530871445576210242010-07-26T14:42:00.005-07:002010-07-26T14:48:02.998-07:00

I've announced the release of the Vertex42® Money Manager on my new blog. See the post Introducing the New Vertex42 Money Management Template. The new Vertex42 Blog will eventually make this one obsolete, but I'll continue to post new templates here for those that may be following this blog.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-75222334195820704222010-07-22T12:53:00.003-07:002010-07-22T12:56:25.107-07:00

This new Yearly Budget Calculator is probably the most powerful budget spreadsheet I've created so far. It combines the family budget planner and the monthly budget into a single workbook, with everything on one worksheet to make it easy to customize the categories.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-53741316210546419082010-07-15T07:29:00.003-07:002010-07-15T07:32:19.594-07:00

If you budget, you may like this new Savings Goal Tracker. It functions as a simple Savings Account Register, but it is designed specifically as a Goal tracker. If you tend to lump multiple savings goals into a single savings account, you mind this very useful.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-37185407194471279282010-07-12T11:25:00.003-07:002010-07-12T11:27:42.654-07:00

This new printable Baby Feeding Schedule was created due to a recent need. It lets you track sleep times, feeding times, number of diapers, etc.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-77101744435142311902010-07-05T15:17:00.002-07:002010-07-05T15:21:01.872-07:00

This Employee Payroll Register template was designed for small businesses that need a way to record employee information and track payroll payments and hours worked. This template is particularly useful if you are using an accountant or online payroll system to calculate your payroll, but also want to make sure you keep a record for yourself.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-30674258612521444802010-06-17T13:09:00.004-07:002010-06-17T13:15:24.404-07:00

This Golf Score Log spreadsheet lets you track your golf scores, but the really cool thing is how it lets you filter by Course, # of Holes, etc. It displays your Handicap Index, and if you filter by Course, it will display your Course Handicap. I hope this is useful, but if not, it was at least fun to create. :-)

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-28506385973097460752010-06-09T14:54:00.002-07:002010-06-09T14:56:51.660-07:00

This Bill of Sale Template is actually for Microsoft Word. I would have created it with Excel except that one of the main things that you'll probably need to change is the text in the Conditions section, which would be annoying to have to modify in Excel.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-43897768136804302692010-05-07T11:34:00.002-07:002010-05-07T11:38:34.809-07:00

So these Recipe Card Templates are for Word rather than Excel, but I don't have a Word Templates blog yet so I'm announcing the new template here. You can use one of these templates to print recipe cards on 4x6 or 3x5 index cards, regular paper, or card stock.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-68146773900201716242010-05-03T14:46:00.003-07:002010-05-03T14:50:31.102-07:00

This Blood Pressure Chart spreadsheet helps you track your SBP and DBP blood pressure readings over time. You can use the printable blood pressure log to track by hand and/or use the spreadsheet to create a visual chart that may help you identify trends.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-28680179617170713922010-04-28T15:17:00.003-07:002010-04-28T15:19:33.813-07:00

The new Credit Card Payment Calculator lets you see how much it really costs to make minimum payments. Calculate the total interest and time to pay off. Compare to making a fixed monthly payment.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-41619553702140782002010-04-17T10:34:00.002-07:002010-04-17T10:38:38.398-07:00

Use this Paycheck Calculator to estimate the effect of tax withholdings, allowances, 401(k) withholdings, pre-tax deductions, and post-tax deductions on your net take-home pay. It estimates federal tax withholdings using the tables from IRS Publication 15.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-80950609424659775222010-04-17T09:44:00.002-07:002010-04-17T09:50:18.905-07:00

The Modelo de Factura is a basic Spanish invoice template for Excel. This "Factura" is designed mainly for service businesses, rather than sales, but it can be used for almost any type of invoice, depending on what you include in the description.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-12316106022884307462010-03-22T08:20:00.004-07:002010-03-22T08:25:29.503-07:00

This Resume Template is actually for Microsoft Word, but hopefully you'll forgive me for mentioning this template on this blog. I did create a couple resume templates for Excel for novelty's sake, but I haven't put them on my website yet.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-89417933125981586372010-02-17T13:24:00.004-07:002010-02-17T13:28:34.453-07:00

This new Line of Credit Calculator can be used to estimate payments for a Home Equity Line of Credit (HELOC) or other general revolving line of credit account. It is a fairly advanced (dare I say complicated?) spreadsheet with multiple payment options to choose from and a fancy variable rate simulation. Use at your own risk.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-90320240505619576912010-02-11T14:23:00.002-07:002010-02-11T14:26:03.754-07:00

This new Blood Sugar Chart and printable blood sugar log can help you track your blood sugar levels over time. The worksheet also includes a chart for tracking your Hemoglobin A1c levels.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-73214412667457914572010-02-09T14:52:00.003-07:002010-02-09T14:55:25.757-07:00

I created a Graph Paper template for both Excel and Word. So far, I've created 1/4 and 1/5 inch, centimeter, and isometric graph paper.It turns out that Excel is not very good for printing accurately scaled graph paper, otherwise I wouldn't have bothered creating the Word versions.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-82740983024519945892010-01-30T13:15:00.003-07:002010-01-30T13:18:28.091-07:00

Just finished a new Credit Repair edition of the Debt Reduction Calculator that helps you improve your FICO credit score by reducing debt down to specific balance-to-credit-limit ratios.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-54921129343450804262010-01-26T12:38:00.002-07:002010-01-26T12:42:01.115-07:00

This Packing Slip template was designed for businesses using the sales invoice template that have requested a corresponding packing slip.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-46384983188063051022010-01-23T15:36:00.002-07:002010-01-23T15:40:41.985-07:00

This Moving Checklist is a fairly comprehensive list of activities, reminders, and tips that will help you when moving. If you have suggestions for things that ought to be included in the list, please add your comments.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-19441351349337662782010-01-21T10:04:00.002-07:002010-01-21T10:10:43.637-07:00

This weekly Lesson Plan Template is a printable lesson planner for teachers. It includes a notes area and space for 8 class periods. It was designed to try to maximize the amount of writing space and not require too much ink when printing.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-13913709351895205342010-01-19T16:02:00.003-07:002010-01-19T16:05:59.211-07:00

This Critical Path Method spreadsheet implements the PERT algorithm for analyzing the durations and dependencies of project tasks. This is a handy tool for project management.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-7007375222890062072010-01-13T20:16:00.002-07:002010-01-13T20:17:31.396-07:00

This perpetual calendar template is a French version of the Vertex42 Perpetual Calendar with some of the common holidays in France.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-67135155138382142992010-01-07T20:46:00.002-07:002010-01-07T20:48:32.211-07:00

This new GPA Calculator helps you track your grades from semester to semester and calculates your cumulative GPA. You can also use it for doing what-if scenarios.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-84915296580816072672009-12-16T14:37:00.002-07:002009-12-16T14:41:39.863-07:00

This new Receipt Template lets you print 3 cash payment receipts or 3 rent receipts on a single page. It is available as a printable PDF with editable fields or as a spreadsheet template.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-30171075306920845112009-12-11T17:21:00.004-07:002009-12-15T12:55:18.026-07:00

I created my first official non-English Excel template. The new Plantilla Calendario is a new perpetual calendar template that creates both yearly and monthly calendars for any year in the future. You can also change the start month in order to create a school calendar. The page also contains printable calendars in PDF format.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-66876255204381345042009-12-09T20:30:00.002-07:002009-12-09T21:10:43.461-07:00

This free Camping Checklist is a great help for preparing for a campout. It lists both personal items and group items and also includes a backpacking checklist.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-53303606141567852782009-12-04T13:50:00.002-07:002009-12-04T13:53:14.927-07:00

If you have a new arrival coming soon, you can use this New Baby Checklist to see if there is anything you might need to be getting ready. It can be downloaded as a printable PDF, or you can download the Baby Checklist template and customize it using Excel.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-2790049340077254122009-11-19T12:00:00.002-07:002009-11-19T12:05:12.789-07:00

This free Gradebook Template is a simple yet flexible tool for teachers wanting to track grades using Excel. I spent a long time on the creation of this template. It started out very simple, but then I kept wanting to add more features and capabilities. I'm still probably not done tweaking, but at least its available for download now.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-24664697332147270222009-11-17T10:00:00.002-07:002009-11-17T10:03:01.610-07:00

This Free Fax Cover Sheet template can be customized and used to print blank copies to include by your fax machine. It was designed to provide plenty of room for writing the fax numbers and messages by hand.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-79792312509440358602009-10-29T15:50:00.003-07:002009-10-29T15:54:07.940-07:00

This Fishbone Diagram, also known as a Cause and Effect Diagram or Ishikawa Diagram, was designed for ease of use. So, even though it isn't angled like most fishbone diagrams, it is much easier to edit than one that uses textboxes and arrows.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-52928741320629268562009-10-21T11:55:00.002-07:002009-10-21T11:59:36.807-07:00

This new Annuity Calculator can help you figure out how much you need to have saved for retirement. The Savings Calculator can help you figure out how much you will have saved by making regular contributions for a number of years. Then, the Annuity Calculator can help you figure out how long that savings will last you.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-42029066981334798452009-10-19T14:45:00.002-07:002009-10-19T14:48:59.124-07:00

This new Depreciation Calculator can be used for basic depreciation calculations including straight-line (SL), sum-of-years' digits (SYOD), and declining balance (DB) methods. It also includes a worksheet for calculating the MACRS depreciation using the approach outlined by the IRS.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-58143913770949145962009-10-16T14:06:00.002-07:002009-10-19T14:48:50.728-07:00

This new Depreciation Schedule template lets you list multiple assets and calculate total yearly depreciation. You can choose from straight-line or declining balance depreciation methods.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-35704430594267911812009-10-15T10:41:00.002-07:002009-10-15T10:44:57.431-07:00

This new College Savings Calculator helps you create an educational savings plan for your child. You can specify yearly costs for grades K-12 in additional to college costs. The monthly deposit amount is calculated based upon the costs, yearly deposits, and other deposits that you specify.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-60323444562543346672009-10-08T10:54:00.002-07:002009-10-08T10:56:45.286-07:00

This NPV Calculator will show you how to use the NPV, IRR, XNPV, and XIRR functions in Excel.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-12002164847699917832009-10-01T10:00:00.003-07:002009-10-01T10:04:40.728-07:00

This page explains how to use a PICK Chart in a Lean Six Sigma event to help categorize process improvement ideas. You can also download a free template for recording the ideas.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-1329716751845772002009-09-23T11:42:00.003-07:002009-10-01T10:04:06.441-07:00

Use this Box Plot template to quickly and easily create box and whisker plots for comparing multiple samples. Just copy and paste your data into the Data sheet and the Plot will update automatically.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-44784981611155807032009-09-15T15:02:00.004-07:002009-10-01T10:04:06.442-07:00

This new Control Chart template creates X-bar, R, and S charts. Just add your data to the data table. It also calculates process capability indices (like Cp, Cpk) and percent yield, based on given specification limits.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-23046404718793773432009-09-09T10:08:00.002-07:002009-09-09T10:11:08.856-07:00

The new Running Log template actually contains 3 different logs: a running log, walking log, and a race log. You can also download printable versions in PDF format. Record your distance, time, pace, heart rate, the temperature and other route information and comments.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-9592432670238345832009-09-02T10:10:00.002-07:002009-10-01T10:04:34.840-07:00

See examples of different types of Organizational Charts for companies, corporations, nonprofit organizations, and schools. Download an Organizational Chart Template for Excel 2007.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-35328177407811008012009-08-17T14:21:00.002-07:002009-08-17T14:24:28.842-07:00

This spreadsheet is a 3-year Profit and Loss projection. It is used to estimate your future income and business expenses to aid in business planning and budgeting.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-24514416051482392372009-08-14T14:25:00.005-07:002009-08-14T14:29:09.680-07:00

The new Business Budget template provides two sample business budget spreadsheets for (1) service providers and (2) companies producing and selling goods.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-63175790710692471142009-08-12T12:23:00.004-07:002009-08-12T12:32:21.416-07:00

The new Photo Calendar template lets you create and print a calendar using photos and pictures that you insert.You can fully customize the calendars, adding events, clipart, etc.This template was designed for printing the photo calendar on 8 1/2" x 11" paper in portrait orientation. Instructions are given on the download page for how to print a mini folding wall calendar.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-80237335871154439962009-07-28T11:07:00.002-07:002009-07-28T11:11:41.736-07:00

I originally created this Attendance Record to track attendance for Scouting activities, but it is general enough to be used for meetings, clubs, church attendance, Sunday school attendance, and even school attendance, although I have other templates specifically for daily school attendance tracking.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com4tag:blogger.com,1999:blog-9307935.post-24685969447790406522009-07-21T16:42:00.003-07:002009-07-21T16:46:49.257-07:00

These printable Sign Up Sheet templates can be used for collecting information for volunteer sign ups, club sign ups, potlucks, and other events or activities.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-77062441307681398072009-07-13T12:37:00.001-07:002009-07-13T12:38:47.145-07:00

This Workout Log template helps you track your strength training progress. It lets you track 5 days on a single page. Record the number of sets and reps and the weight for your lifting exercises. Track your weight, hours of sleep, and daily calories ... more info

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-61391611817771282752009-07-13T12:33:00.002-07:002009-07-13T12:38:58.842-07:00

This Exercise Log helps you track your fitness and strength training progress. It includes a worksheet for listing 2 days per page and one for listing 3 days per page. List the exercises and then record the number of sets/reps for the weight lifted, or the time/distance and heart rate for cardiovascular activities ... more info

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-11455300648993354212009-06-23T13:59:00.002-07:002009-07-13T12:37:27.851-07:00

This Workout Chart template can help you structure your personal weight lifting program. List exercises for warm up, core body strength training, upper body strength training, lower body strength training, and cool down. The workbook also includes a worksheet for calculating your 1RM (One Rep Max) based on multiple reps to failure (rather than 'maxing out').

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-11106769574150732712009-06-19T14:42:00.003-07:002009-06-19T14:46:09.366-07:00

Create a weekly personal fitness plan with this Exercise Chart template. Schedule both strength training and cadio exercises. Record sets/reps and weight, time/distance and target heart rate, intensity levels, and notes.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-62694010156451779102009-06-03T09:44:00.003-07:002009-06-03T09:47:04.213-07:00

This simple Loan Calculator is meant as an educational tool to see examples of how to use various financial functions in Excel, including the PMT, PV, RATE, and NPER functions.... more financial calculators

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-8626369768233278732009-06-03T09:39:00.003-07:002009-06-03T09:42:48.780-07:00

This Sales Invoice template is designed for small businesses that sell and ship multiple products. The invoice has columns for the item #, quantity, and unit price.Other Invoices and related templates.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-8190616602710727672009-06-03T09:34:00.002-07:002009-06-03T09:43:05.746-07:00

This Service Invoice template is designed for small service-oriented businesses like lawyers, accountants, graphic designers, web developers, etc. who work either hourly rates or on a project basis.Other Invoices and related templates.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-52654387506644026632009-06-03T08:34:00.003-07:002009-06-03T09:43:05.746-07:00

These 5 different Sign In Sheets and Templates include a (1) Meeting Sign In Sheet for collecting info from attendees, (2) Visitor Sign In / Sign Out for schools, museums, open houses, (3) Patient sign in sheet with appointment and arrival times, (4) Course sign in sheet for recording attendance at a seminar, workshop, or class, (5) Generic sign in form for all other occasions.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-37982626356458630712009-05-19T13:52:00.003-07:002009-05-19T13:59:48.228-07:00

This new Pareto Chart Template helps you perform a quick pareto analysis without having to manually create the chart. Creating your own can be time consuming and tricky if you don't know how to work with a secondary axis. This pareto chart template highlights the most significant items and the placement of the labels makes it possible to have descriptive labels without messing up the size of the

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-26833891535480801012009-05-15T13:27:00.002-07:002009-06-03T09:43:05.747-07:00

This Purchase Order template is perfect for businesses that need to order parts, equipment, and inventory from vendors that request a purchase order.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-58981841061644511292009-05-15T13:21:00.003-07:002009-05-15T13:26:26.110-07:00

This Employee Vacation Accrual template lets you track your vacation, sick leave, and personal leave usage. Find out how much vacation you will have accrued after a number of pay periods, what your current balance is, etc.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-31788750367378899442009-04-30T15:10:00.002-07:002009-04-30T15:15:35.805-07:00

This Class Schedule template is designed to help students plan their week. It is especially useful during course registration, to help avoid overlapping classes and fitting in a work schedule.The spreadsheet has two worksheets ... one with time intervals of 15 minutes and the other with time intervals of 30 minutes.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-4924886447224251282009-04-27T08:52:00.004-07:002009-04-30T15:09:24.727-07:00

This free Mortgage Payment Calculator is for comparing various fixed-rate mortgages side-by-side. It can be used for both US (monthly compounding) and Canadian (semi-annual compounding) mortgages and also allows you to enter extra monthly payments.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-70373345526198898662009-04-23T10:44:00.004-07:002009-04-23T11:17:23.626-07:00

This new Break Even Analysis spreadsheet is helpful for analyzing the financial viability of a new venture or product. It calculates the break-even sales (number of sales required to break even), the break-even price, or the payback period. Each scenario is a separate worksheet within the workbook. The download page also includes detailed information about the formulas used to calculate the

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-82027441925134326002009-04-22T09:35:00.002-07:002009-04-30T15:22:58.793-07:00

This Monthly Planner Template is great for printing letter-size planner pages for a 3-ring binder. It is more than just a calendar. It includes a To-Do list and sections for monthly Goals and Notes. Unlike many of my other calendar templates, this one allows you to copy the worksheet so that you can have multiple months within the same workbook, which is nice if you are using this for planning

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-61335457809810908982009-04-16T13:28:00.008-07:002009-04-30T15:22:17.862-07:00

This Weekly Meal Planner template lets you create your own list of main dishes, side dishes, breakfast and lunch meals. These lists appear as drop-down lists within the meal planner, making it easy to quickly select meals for the week. The Monthly Menu Planner template also lets you customize lists, and can be useful for longer-term planning. It only includes space for one meal per day - mostly

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com96tag:blogger.com,1999:blog-9307935.post-18840225639133751322009-04-13T15:51:00.004-07:002009-04-30T15:21:15.524-07:00

This weekly planner spreadsheet lets you print a letter-size planner page that will fit common 3-ring binders. You can enter yearly events like birthdays and holidays and it will automatically add them to the planner (up to 3 events/holidays per day).I've also created a couple printable weekly planners that you can download from this page in PDF format. One is based on the Excel version of the

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-72616034449970643142009-04-11T20:52:00.003-07:002009-04-30T15:16:56.808-07:00

This Personal Budget Template let's you plan your budget for an entire year. My article How to Make a Budget explains how to use this budget template to keep track of expenses from month-to-month so that you can figure out an average for each expense category.I use this type of budget spreadsheet because it lets me include annual or semi-annual payments during the specific months that they occur,

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-25717348481658716052009-04-11T20:44:00.002-07:002009-04-11T20:48:47.440-07:00

This BMI Chart was created in Excel using similar techniques as the Ideal Weight Chart. The spreadsheet also includes a BMI Calculator.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-53564909791767467722009-04-08T19:41:00.005-07:002009-04-11T20:42:13.966-07:00

This Net Worth Calculator is a spreadsheet template that I created while I was working on creating some other financial statements. It helps you calculate your personal net worth by providing a ready-to-use list of asset and liability categories.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-76733862436041114652009-03-31T08:43:00.005-07:002009-04-11T14:18:10.973-07:00

I created this a billing statement template specifically for tracking invoices. It's designed using the same theme as my other invoice and purchase order templates. If you have less than 20 or so customers or tenants, you can keep track of the billing statements by having a separate billing statement worksheet for each customer in a single workbook. It can also double as an accounts receivable

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-27696437112975396162009-03-20T16:06:00.004-07:002009-04-11T14:08:06.682-07:00

Based on a request from a user, I created this expense tracker, which lets you record transactions and allocate the charges into specific expense categories which you define. Each category is a different column, and you can copy/insert new columns as needed without too much trouble. The template includes a budget tracking chart to compare your budget to how much has been spent so far in each

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-7173448815217423562009-03-12T08:44:00.007-07:002009-04-11T20:42:56.380-07:00

To go along with my recent Exercise and Fitness theme, I've created a new weight loss chart template for Excel, as well as a few printable weight loss logs and charts in PDF format that you can download, print, and keep handy right next to your scale (at least that's what I'm doing). I've got more Exercise Charts coming ... stay tuned.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-22828596254056653932009-03-03T17:07:00.006-07:002009-03-19T19:18:18.430-07:00

Today, Vertex42 was announced as the newest partner of Office Online Templates. I submitted 8 different financial calculators for inclusion in their template gallery, which you can get to by clicking on the image below. The original templates can still be downloaded from the following pages:Home Mortgage CalculatorAuto Loan Calculator401k CalculatorSavings CalculatorCredit Card Payoff

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-32846432743112795532009-02-24T15:01:00.007-07:002009-04-30T15:21:40.352-07:00

Although most people could create their own Grocery List template in a matter of minutes, I spent a few hours trying to come up with a template that was highly functional and useful. I ended up creating two different types of lists, (1) a blank Shopping List that could be used for any type of store (including groceries), and (2) a Grocery List that includes categories with some commonly purchased

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-39197793604287132072009-02-12T10:05:00.005-07:002009-04-11T20:36:57.656-07:00

By request, I created a new loan calculator specifically for fixed-rate interest-only mortgage loans. It is based on my amortization schedule template, but allows you to enter the IO period in years and make extra payments during that time. At the end of the IO period, the loan is amortized using the current balance and number of years remaining.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-83411527973875000602009-02-11T09:29:00.008-07:002009-04-11T20:50:39.408-07:00

I've added a new spreadsheet that includes a table, chart, and calculator for estimating your ideal weight. The Ideal Weight Chart uses the BMI, Devine, Robinson, and Miller formulas - all on the same graph - so it is fairly easy to compare them.The chart uses a special trick for creating the shading that highlights the overweight, normal, and underweight regions based on the BMI (body mass index

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-78868637098113008012009-01-19T08:27:00.004-07:002009-04-11T15:39:56.342-07:00

I created a new Printable Daily Planner that lets you print a letter-size planner page that will fit common 3-ring binders. There are no macros and it doesn't tie in to a database, so if you're looking for an electronic planner - something similar to the way Outlook works - this daily planner is probably not for you. However, you CAN enter yearly events like birthdays and holidays and it will

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-4407282075491697692008-10-08T11:56:00.001-07:002009-04-11T13:53:34.740-07:00

I just finished creating 3 new financial statement templates - designed mainly for small business owners.Balance SheetIncome StatementCash Flow StatementThese should also work in OpenOffice and Google Spreadsheets.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-25088796079983043352008-08-12T20:27:00.002-07:002009-04-13T16:01:46.115-07:00

This new template is for recording what you eat and how much water you drink each day. Today was my first official day to use the food log, and I was surprised to find out that my typical bowl of Honey Nut Cheerios is actually 550 calories. I looked at the other cereal boxes that we have, and it appears as if the manufacturers just change the serving size so that every serving comes to about 110-

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9307935.post-16134614262387335342008-07-25T20:27:00.001-07:002009-04-11T13:55:05.665-07:00

Today I created a new home inventory spreadsheet template that works with both Excel and Google Spreadsheets. The template is not in the Google Docs gallery, but it can be downloaded from my website and then uploaded to Google Docs. It is a pretty basic spreadsheet, but hopefully if you're reading this, it will be a reminder for you to complete your inventory, or update it.I'm not sure whether

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9307935.post-75658666838076671052008-07-16T18:39:00.000-07:002008-07-16T18:49:46.628-07:00

Google™ launched their new Google Docs Template Gallery today. The gallery contains over 100 spreadsheet templates, some of which were contributed by Vertex42 and TemplateZone.Check out the official announcement, "Templates bring Docs to life" on the Google Docs Blog.These templates are a great resource for Google Docs users. If you are familiar with Excel and Google Spreadsheets, you may realize

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0