Bullseye Glass Inventory Worksheet: Build One in Excel

How-to basics · Updated November 22, 2026

A Bullseye glass inventory worksheet is a catalog of the Bullseye sheet glass, frit, rods, stringers, and other materials you have on hand. You can build one in Excel by listing each material with its color or product code, compatibility, quantity, storage location, and reorder level; the worksheet below also shows how to calculate stock value and flag items to replenish.

What a Bullseye glass inventory worksheet is for

Bullseye Glass is associated with glass used in kilnforming, including fusing and slumping. An inventory worksheet helps a studio answer practical questions: Do I have enough of this color for a project? Where is the remaining piece? Which materials need replacing before the next firing? It can be a simple table, a printed checklist, or a more detailed workbook with separate tabs for different material types.

There is no single universal inventory layout that suits every studio. A hobbyist with a few sheets may need only color, quantity, and location. A teaching studio, production workspace, or artist managing many partial sheets may want product identifiers, lot information, purchase details, and a record of material used. Treat the worksheet as a record of what is physically in your workspace, not as a substitute for checking the glass itself.

What to record for each item

Give each row a clear meaning. One row might represent one product and its total available stock; alternatively, separate rows can represent distinct pieces or batches when their size, lot, or location matters. Avoid combining unlike materials into one quantity. A sheet, a jar of frit, and a bundle of stringers are not interchangeable units.

  • Item ID: A short identifier you assign, such as SHEET-014 or FRIT-006. Keep it unique if you attach labels to shelves or bins.
  • Product form: Sheet, frit, powder, rod, stringer, billet, or another form. Use the product’s actual description when known.
  • Color and product code: Record the color name and any code shown on the packaging or purchase record. Do not rely on a color name alone if several products look similar.
  • Compatibility: Record the stated compatibility information, including COE where relevant, and keep different compatibility families clearly identified.
  • Quantity and unit: For example, 3 full sheets, 2.5 square feet, or 400 grams. Use one consistent unit per item type and label it explicitly.
  • Dimensions or usable size: Especially helpful for partial sheets and offcuts. Note whether a measurement is approximate and whether the piece has chips or other damage.
  • Location: Use a repeatable description such as Rack A, shelf 2, or Bin Blue-3.
  • Reorder level, unit cost, and date acquired: Optional fields that help with purchasing and planning. Record the source and lot details when those are important to your studio.

For example, a row could describe one Bullseye sheet by its packaging code and color, list the quantity as one sheet, note its approximate dimensions, identify the storage rack, and record that it belongs to the compatibility group specified for that product. A separate row for a partial piece can preserve its actual dimensions rather than incorrectly counting it as a full sheet.

How to set up the worksheet in Excel

In Excel for Microsoft 365 on Windows, enter one header per column in row 1, then enter one item per row beneath it. A practical starting layout is: A Item ID, B Product form, C Color or product code, D Compatibility, E Quantity unit, F Quantity on hand, G Reorder level, H Unit cost, I Stock value, J Location, and K Notes. Add columns for dimensions, lot, supplier, or purchase date if you will use them.

Select the header row and the rows of data, then choose Insert > Table and confirm that the table has headers. A table makes it easier to sort and filter without separating a value from its item. Keep one kind of information in each column: do not put quantity, unit, and location together in a single cell. You can filter the Product form column to see only sheet glass, or filter Location to find items stored in a particular rack.

Use Excel’s number formats to make quantities and costs readable. Format the unit-cost and stock-value columns as currency if you are tracking purchase cost, and use a suitable decimal format for quantities that can be fractional. A quantity of 0.5 sheets is less ambiguous when the unit column says sheets and a note records the remaining dimensions. Do not use a currency total as a measure of artistic or replacement value: it is only the value calculated from the cost figure you entered.

Useful formulas for value and reorder checks

A basic worksheet can work without formulas, but two small calculations reduce arithmetic and make low stock easier to spot. First, choose how you will handle partial pieces and costs. If unit cost means cost per recorded unit, multiply it by quantity. If one row combines several pieces bought at different prices, the result is only an estimate unless you record the cost basis carefully.

With quantity on hand in F2 and unit cost in H2, enter this in I2 for stock value: =F2*H2. For example, if F2 is 4 sheets and H2 is $18.50 per sheet, the result is $74.00. Copy the formula down the column for other rows. Make sure the cost and quantity refer to the same unit; multiplying a quantity in square feet by a per-sheet cost would not give a meaningful value.

With quantity on hand in F2 and reorder level in G2, enter this in a status column such as L2: =IF(F2<=G2,"REORDER","OK"). If F2 is 2 and G2 is 2, the result is REORDER; if F2 is 5 and G2 is 2, the result is OK. Copy the formula down the status column. If you add status in L, put a Status header in L1 and adjust the table range as needed.

The reorder level is a reminder chosen by the studio, not a universal rule. Set it according to how often you use an item, how long replacement takes, whether a project depends on that exact color, and whether an acceptable substitute exists. For materials you do not intend to replace, a blank reorder level may be more honest than entering zero and creating a misleading alert.

Counting glass and keeping records current

An inventory is useful only if its quantities remain believable. Choose a routine: update the sheet when material is received, when a substantial piece is used, and when you discover breakage or move stock. For frequent small offcuts, recording every scrap may take longer than it saves. Decide on a practical minimum size or use a separate offcut bin recorded by approximate weight or dimensions.

When receiving materials, compare the delivery and product labels with the order before adding rows or increasing quantities. Record the actual form, color, and identifying information from the packaging. If the same item arrives in a different lot or is stored separately, consider creating another row rather than merging it blindly. A note or purchase date can help explain why two apparently similar items are tracked separately.

For a studio that needs more traceability, record usage as transactions on a second worksheet rather than repeatedly overwriting the only record. A simple log can include date, item ID, quantity added or removed, unit, and project or reason. The main inventory can then be checked against a physical count. This is most useful when several people share materials or when a project needs a reliable record of what was used; a small personal studio may find a single table faster.

Compatibility, labels, and common mistakes

Compatibility is not the same thing as color. Glass selected for a kilnformed project needs to be compatible according to the manufacturer’s information for the products being combined. Bullseye is commonly associated with COE 90 glass, but a worksheet should record the compatibility information for the particular material rather than assume that every glass in a studio is interchangeable. Do not mix glass families because their colors look alike, and do not treat a spreadsheet entry as proof that two pieces can safely be fused together.

Other frequent recordkeeping problems are easier to prevent:

  • Inconsistent names: Decide whether you will use the printed color name, product code, or both, then enter them consistently.
  • Unlabeled units: A quantity of 6 is not useful unless the worksheet says whether it means sheets, pieces, jars, or another unit.
  • Counting partials as full sheets: Record dimensions or a clearly defined fraction instead of overstating usable stock.
  • Overwriting identifying details: Keep notes about product codes, lots, or labels when those details matter for future identification.
  • Assuming the file matches reality: Periodically compare the worksheet with the shelves and correct discrepancies.

If a product label is missing or a material’s identity is uncertain, mark it as unverified and store it separately until identified. Do not guess a compatibility value based only on appearance. The worksheet’s purpose is to make reliable information easier to find, not to turn uncertain information into a confident-looking entry.

Using filters, sorting, and visual alerts

Filters can answer everyday questions quickly. In an Excel table, use the header dropdowns to show a specific product form, color, or location. Sort by reorder status or quantity to review supplies that may need attention. Before sorting, ensure the data is in a table or select the full dataset; sorting a single column alone can detach values from their associated items.

You can also highlight low quantities with Excel’s conditional formatting. Select the quantity cells, then choose Home > Conditional Formatting > Highlight Cells Rules and choose an appropriate rule, or apply a formula-based rule if you want the threshold to vary by row. A visible fill color is a prompt to inspect the stock, not proof that an order is necessary. Check project requirements, the physical quantity, and your chosen reorder level before buying.

Save the workbook somewhere that is backed up, and keep a dated copy before making major structural changes. If the worksheet will be printed, set a readable page orientation and repeat the header row on additional pages through Excel’s page setup options. A printed list can help during a shelf count, but mark the date of the count so readers know whether it reflects current stock.

When a simple worksheet is enough—and alternatives

A single Excel table is usually enough when one person manages a modest collection and wants to find colors, locations, and quantities. A separate transaction log or one tab per product category can help as the collection grows, but avoid splitting information so widely that the same item has conflicting records. A printed checklist can be useful at the storage area, while a digital master file is easier to sort and update.

For shared studios, a cloud-stored workbook can make updates accessible to more than one person, subject to the studio’s chosen Microsoft 365 setup and permissions. Excel for the web has a different interface from Excel for Windows, and some features or controls may differ; verify that collaborators can edit the file as intended. If several users need simultaneous updates, stock reservation, purchasing approvals, or barcode workflows, dedicated inventory software may be more suitable than adding complexity to a spreadsheet.

Cost tracking and practical limits

Cost fields are optional. If you include them, state whether the number is what you paid per sheet, per gram, or per another unit, and record whether shipping or other charges are included. A simple inventory value can support studio planning, but it may not represent current replacement cost, resale value, or an accounting figure. Keep the worksheet’s purpose clear and follow the recordkeeping requirements that apply to your situation rather than treating a homemade sheet as formal accounting guidance.

Price records also become stale. If comparing purchase costs over time matters, preserve the original purchase date and cost in a transaction or purchase log instead of replacing it with a newer price. If your only goal is to know whether material is available for an upcoming project, recording detailed financial history may add work without helping the decision.

Frequently Asked Questions

Is there an official Bullseye glass inventory worksheet?
A studio can create its own inventory worksheet using the fields that suit its materials. Do not assume that a generic worksheet is an official Bullseye document; check Bullseye’s own resources for manufacturer information and use your inventory file for your studio’s stock records.

What should I include in a Bullseye glass inventory?
At minimum, record the product form, color or product code, compatibility information, quantity with a unit, and storage location. Add dimensions for partial sheets and reorder levels or costs if those details help you make decisions.

How do I track glass offcuts?
Use a separate row for offcuts when their dimensions or color make them useful for planning. If there are many small scraps, set a practical minimum size or track a group by weight or approximate quantity; label that method so the number is not mistaken for full sheets.

Can I mix different COE glass in one inventory list?
You can list different materials in the same workbook, but identify compatibility clearly and keep stock records distinct. A shared spreadsheet does not mean the materials are suitable for combining in a kilnformed project.

How often should I update the worksheet?
Update it when significant stock arrives, is used, moved, or discarded, then do periodic physical counts. The right interval depends on how quickly the studio uses glass and how much accuracy its projects require.

Can Excel tell me exactly what to reorder?
Excel can flag rows whose recorded quantity is at or below a reorder level, but it cannot know your upcoming project needs or verify the shelves. Treat the flag as a review prompt and confirm the material and quantity before placing an order.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.