Bug Tracker

  • Category: Task Planners
  • Platform: Microsoft Excel
  • Description: Track your bugs or issues in one easy to use spreadsheet. Designed to be intuitive and empower you to stay on top of your bug backlog. Prioritize your bugs and keep their statuses up to date. Assign bugs or issues to people in your team, set due dates and track your progress. Both light and dark mode themes included!



    • Download Now

Features

✔️Modern & Easy to use interface.
✔️Multi-purpose tracker - Can be used as a bug tracker for software development or Issue tracker for any kind of work environment.
✔️Easily enter a bug or issue & select a Status from the drop-down list (Not started, In progress, completed, on hold, canceled, blocked).
✔️Select a Priority from the drop-down list (P1, P2, P3, P4).
✔️Select a Created Date & Due Date. The Due date appears in red automatically if the date has passed.
✔️List everyone you work with and select who logged the bug and who it's assigned to.
✔️Set the progress amount for each bug, the percentage value is automatically color coded.
✔️Modern, colorful status bar displays the total task count per status.
✔️Active bugs tile automatically calculates how many bugs are active (excluding those in Completed or Canceled state).
✔️Active P1 tile automatically calculates how many bugs are active and are considered Priority 1.
✔️Team count tile automatically displays the number of people in your team.
✔️Progress tile automatically displays the total percentage, based on how many bugs are in the Completed state.
✔️Customizable - You can edit anything you'd like in this spreadsheet if needed.

Get started with your Tracker

Learn how to get the most from your new bug tracker

Configure the Settings sheet

Select the ‘Settings’ sheet and enter the following information:

  • People: List the names of all the people involved in your project.
  • Status: You may rename one or more of the default statuses.
  • Priority: You may rename one or more of the default priorities.

🟢 Tip: To remove an entry in the ‘People’ list, right click on the entry and select ‘Delete -> Table Rows’.



Start logging bugs

The ‘Tasks’ sheet allows you to manage all your bugs. Each bug contains the following 9 columns:

  • ID: Enter the ID of your choice for each bug. For example, you may start with 0001.
  • Bug: Enter a bug description. If the amount of information you need to enter does not fit into this cell, consider adding a 'note' by right-clicking in the cell and selecting 'New Note'. If you need to include images, text formatting and large amounts of imformation, we suggest logging the bug in a Word document and then hyperlinking the Bug cell to the Word document. These documents can be stored on Microsoft OneDrive or Google Drive.
  • Status: Select a status from the dropdown menu.
  • Priority: Select a priority from the dropdown menu. (P1 = Most urgent, P4 = Least urgent)
  • Created Date: Enter bug creation date.
  • Due Date: Enter the date which the bug should be fixed by.
  • Created By: Select the person who logged the bug. Choose your name if you're logging the bug.
  • Assigned To: Assign the bug to someone in the team. They will be responsible for fixing the bug.
  • Progress: Enter a number between 0 and 100. This will be formatted as a percentage and will be color coded automatically.

🟢 Tip: All dates must be entered in the following format: January 1, 2023

🟢 Tip: When the ‘Due Date’ has passed the current date, it will appear in red.



    Frequently Asked Questions


  • Yes, you can easily apply filters on the ‘Tasks’ sheet.
    Simply click the Filter button at the top of the desired column and check or un-check any of the available checkboxes.
    Here’s what the filter menu would look like if you only wanted to see “In progress” Tasks:

  • Yes, simply click the ‘Filter button’ at the top of the column and select “Sort A to Z”.

  • You may highlight any cell that you would like to clear and hit the Delete key on your keyboard.

  • Your tracker comes with about 200 blank rows; however, you can add more by right clicking the last row and selecting “Insert -> Table Row Below”

  • Contact us via the Bobcat Planners Etsy shop any time!