AOPA Pilot's Steven W. Ells in his February 2001 " Airframe and Powerplant: Checking Your List" encourages aircraft owners to update the equipment lists for their aircraft. To make that easier, we've created a basic Microsoft Excel spreadsheet that you can modify to serve this function. You must have Microsoft Excel software on your computer to open and use these files. On the left below is a sample spreadsheet, using data for a Piper PA-28 as an example. Not all components are listed. To the right is EQLtemplate.xls, an Excel document with the same functionality but with the sample data removed, for you to customize as needed for your aircraft (to make it a true template, open the file in Excel and save it as an Excel template). Weights are in pounds, arm is in inches, and moment is inch-pounds. The spreadsheet includes a weight-and-balance function that will automatically multiply the weight and arm you enter for each component to calculate its moment; at the bottom, the spreadsheet will add the total weight and total moment for you. Also on the spreadsheet are columns where you may record the part number or serial number of a component, as well as the date and tach or Hobbs time at its installation.
It is not our intent for this document to replace your aircraft's existing weight and balance form. If you do choose to use it for that purpose, remember that it first must be approved and signed off by your A&P.