---
title: "Reporting > Job List 9 - Scheduled Hours"
canonical: "https://technology.bytangram.com/space/TGKB/1656947073/Reporting%20%3E%20Job%20List%209%20-%20Scheduled%20Hours"
format: markdown
---
You can create many reports from the **jobs** module > **jobs list** simply by changing the **jobs list view** field. **Job list #9** allows you to compare scheduled hours to quoted and used hours. 

| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |

---

## HOW TO RUN JOB LIST 9

- Go to the **jobs** module > **jobs list** > **filter** your jobs list according to what you want to see in your report e.g. client/client group and project
- Click **apply**

![image](media://e28b6dd9-6554-49ed-9817-f7635b0af88f)

Once the job list has been filtered change the job list to **scheduled hours (9)**

![image](media://77da58d8-aaa3-4ce4-a493-727992a94ade)

- Your job list will reformat to **WorkBook’s scheduled hours (9)**

![image](media://eb47d187-a0e9-4a27-9f78-f35bc3655f77)

---

## EXPLANATION OF JOB LIST 9 DETAILS

There are a number of columns that can make up job list 9 - here is a breakdown of the column headers and their definitions.  

|  |  |
| --- | --- |
| **COLUMN NAME/S** | **DEFINITION** |
| **Client** | The client the job belongs to |
| **Project** | The grouping, campaign or project this job belongs to. It comes from the Project field in the job properties sidebar |
| **Job No.** | WorkBook job number |
| **Job Name** | Indicates the name of the job |
| **Reference Key** | The reference key field is sometimes used as part of the implementation process when jobs are imported into WorkBook. It comes from the reference key field in the job properties side bar > job finance settings |
| **Company** | The WorkBook company the job belongs to |
| **Billable** | There will be a tick in the field to indicate the job is billable |
| **Created** | Date the job was created |
| **End Date** | Indicates the job’s end date. It comes from the End Date field in the job properties sidebar |
| **Project Manager** | Indicates the project manager assigned on this job. It comes from the Project Manager field in the job properties sidebar |
| **Price: Billable Hours** | Total number of hours on approved Price Quotes on the job |
| **Allocated Hours** | Total number of hours scheduled on an active timeline/s on the job |
| **Remaining Hours Allocated** | Allocated hours less time registered against the allocated hours |
| **Used Hours** | Hours registered to date via timesheets on the job |
| **Allocated + Used Hours** | Remaining allocated hours + used hours |
| **Difference vs. Allocated Hours** | Allocated Hours - Allocated + Used Hours |
| **Difference vs. Billable Hours** | Price: Billable Hours - Allocated + Used Hours |
| **Unallocated Hours** | Hours against a task that has no one assigned to it |
| **Used Hours This Month** | Total hours timesheeted this month |
| **Expected EAC Hours This Month** | Expected hours to be logged this month based on hours allocated this month |

---

## CONFIGURING JOB LIST 9

Job list 9 contains many details for your reporting purposes. Use the **modify grid** functionality to configure job list 9 to suit your agency’s retainer reporting process.

> ℹ️ For more information on how to use the modify grid functionality refer to the [grid view reporting](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/959021106) article.


---

## EXPORTING JOB LIST 9

You can export job list 9 to create your own reports using WorkBook’s **export grid data** functionality.

> ℹ️ For more information on how to use the export grid data functionality refer to the [grid view reporting](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/959021106) article.


---

Related Articles

> Macro (contentbylabel)