--- title: "Using the Document Analysis Report to Determine Waiver Status (Texas)" slug: "using-the-document-analysis-report-to-determine-waiver-status-texas" updated: 2025-09-02T14:34:11Z published: 2025-09-02T14:34:11Z canonical: "support.eduphoria.net/using-the-document-analysis-report-to-determine-waiver-status-texas" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.eduphoria.net/llms.txt > Use this file to discover all available pages before exploring further. # Using the Document Analysis Report to Determine Waiver Status (Texas) Users in Texas school districts can generate a [**Document Analysis Report**](/v1/docs/running-the-document-analysis-report) to determine how each employee scored in each possible matrix heading for a specific document. Texas districts can use this report to identify which teachers have received one or more **Improvement Needed** scores on an evaluation document and which teachers qualify for the **T-TESS Waiver** for the specified school year. > [!NOTE] > **Note**: If a district does not apply any filters before generating the report, the exported spreadsheet includes all evaluations that were created with the selected document. ## **Generating the Document Analysis Report** **Step 1:** Select **Reports** from the **Analysis** section of the main menu. **Step 2:** Select **Document Analysis**. ![](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/image(510).png) **Step 3:** On the **Document Analysis** configuration screen, select the document you want to analyze from the **Reflection Documents** list. ![](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/image(513).png) **Step 4:** (Optional) Select the **Filter Items** in the left panel to apply different types of filters to the report. For example, choosing **Appraisal Dates** allows you to filter the data shown in the report by date range. ![](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/image(512).png) **Step 5:** Once you have selected a document and applied all desired filters, select the **Print** button in the top right to expand the print and export options. Select **Export to Spreadsheet** to open the document in a spreadsheet viewer, such as Excel or Google Sheets. ![](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/image(514).png) ## **Determining T-TESS Waiver Status** Once you have downloaded the report as a spreadsheet, open the file in a spreadsheet viewer, such as Excel or Google Sheets. This allows you to apply filters to more easily parse and analyze the data in the generated spreadsheet **Step 1:** Select the specific T-TESS document to analyze. **Step 2:** Apply the date filter for ​a specific timeframe. **Step 3:** Generate the ​T-TESS **Document Analysis Report** for the specific timeframe by clicking **Print** and choosing the **Export Score Counts to Spreadsheet**. **Step 4:** Paste the following formula into the **P2 cell** of the spreadsheet and hit **Enter/Return** on the keyboard to generate results: **=IF(O2>0,"Improvement Needed",SUM(K2:M2))** > [!WARNING] > **Caution:** The formula applies if you have **matrix questions containing five column headers/fields** and the **O Column Header** is **Improvement Needed**. ![paste excel formula.png](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/25176926092183.png) **Step 5:** Highlight the **P2 cell**, grab the corner of the cell, drag it down the **P column**, and generate the values for all other rows in the spreadsheet. ![drag p2 cell.png](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/25176926096151.png) ## **Data Results in the P Column** Use the data in the P column to determine if a teacher is **Proficient** overall or if the teacher can qualify for wavier status in T-TESS. All **Distinguished, Accomplished**, and **Proficient** selections are totaled and displayed as numerical values in the P cell at the end of each row. If a teacher receives one or more **Needs Improvement** selections, the P cell displays **Improvement** **Needed** for that teacher. ![p column totals.png](https://cdn.us.document360.io/d6ce927e-20b2-40ab-af8d-ea0afbbc28f7/Images/Documentation/25176926099863.png)