Editing Inventories

This section describes the inventory editing capabilities of GBonds.

Adding Bonds to an Inventory

The Add Bond dialog (shown in Figure 8) is activated from either the Edit->Add or the Add toolbar button. This dialog is used to create a new bond entry in the current inventory.

Figure 8. Add Bond Dialog

All necessary information for a single bond is derived from just two text fields. These fields are:

Serial Number:

This is the serial number printed on the bond. A couple of key pieces of information are extracted from the serial number by GBonds, so the serial number must be entered in its entirety.

Issue Date:

This is the issue or purchase date of the bond. The format must be MM/YYYY, where MM (month) is an integer from 1 to 12, and YYYY (year) is a four digit integer greater than or equal to 1940.

Once both fields are entered, pressing the OK button will add the bond to the inventory. Pressing the Cancel button will dismiss the dialog without adding the bond.

NoteAnatomy of a Serial Number
 

The first digit/character indicates denomination:

  • Q = $25
  • L = $50
  • K = $75
  • C = $100
  • R = $200
  • D = $500
  • M = $1,000
  • V = $5,000
  • X = $10,000

The last 1 or 2 digits/characters indicate series. If the last digit is a numeral (0-9), then the bond is a series S (Savings Note). Otherwise, the last alphabetic digits indicate the series: EE, E, or I. GBonds does not currently handle any other series of bond.

All other digits provide a unique identification of a bond.

Selecting Bonds in an Inventory

A prerequisite for the delete and cut/copy operations is the selection of a bond or set of bonds.

Selecting a single bond

A single bond can be selected simply by clicking on the desired bond (row) in the bond inventory area of a worksheet. Once selected the bond will be highlighted.

Aggregate bond selections

Multiple adjacent bonds can be selected by first selecting the first bond as above and then by holding the Shift key while selecting the last bond in the sequence. Individual bonds can be added to an existing selection by holding the Ctrl key while selecting the desired bonds. All bonds in an inventory can also be selected by using the Edit->Select All menu item. All bonds in an aggregate bond selection will be highlighted.

Unselecting bonds

Individual bonds can be removed from an existing selection by holding the Ctrl key while clicking on a previously selected bond. An entire selection can be dismissed by using the Edit->Unselect All menu item. Once a bond is unselected the highlight is removed from its entry.

Deleting Bonds from an Inventory

Before a bond can be deleted, it must be selected (see above). Both individual bonds and groups of bonds can be deleted at one time. Once a bond (or group of bonds) is selected, the delete command is activated from either the Edit->Delete menu item or the Delete toolbar button. This will activate a confirmation dialog (shown in Figure 9) for each selected bond.

Figure 9. Delete Bond Confirmation Dialog

This is a simple Yes or No dialog to confirm the intent to delete the selected bond. When multiple bonds are selected, there are 2 additional options: Yes to All (to confirm the deletion of this bond and all remaining bonds in the selection) and Cancel (to cancel the deletion of this bond and all remaining bonds in the selection).

CautionImportant
 

Bonds deleted with this command are not placed on the clipboard.

Using the Clipboard

Bonds can also be manipulated using the standard clipboard operations Cut, Copy and Paste.

Cut (Ctrl-X)

Moves selected bonds to the clipboard. The bonds are then available for pasting into another inventory, or as text into an external application such as a spreadsheet or word processor.

Copy (Ctrl-C)

Copies selected bonds to the clipboard without deleting them. The bonds are then available for pasting into another inventory, or as text into an external application such as a spreadsheet or word processor.

Paste (Ctrl-V)

Pastes bonds from the clipboard into the inventory. GBonds can only paste bonds from another GBonds worksheet.

Editing an Inventory's Title

The Edit Inventory Title dialog (shown in Figure 10) is activated from the Edit->Title menu item. This dialog is used to create or edit the title of an inventory.

Figure 10. Edit Inventory Title Dialog

Once a title is entered or modified, pressing the OK button will activate the new title. Pressing the Cancel button will dismiss the dialog without changing the current title.