Behavioral Health-Focused Systems of Care Grant

The Washington State Department of Commerce is making up to $459,800 available to implement the Behavioral Health Systems of Care Grant, focusing on youth and young adults exiting behavioral health settings. The Behavioral Health Systems of Care Grant program supports interventions that prevent young adults from exiting inpatient behavioral health systems into homelessness. Behavioral Health Systems of Care grant program seeks to identify young adults (18-24) at risk of homelessness…

Excel Advanced Tip: Fun with Formatting Text, Numbers and Styles

Instead of tweaking individual cells in your data set, make adjustments to a whole table, row or column. Which spreadsheet would you prefer to work with? à           Table 1: Before Formatting Fun                                                                   …

Reports Corner: Data Quality Report

No dataset is perfect, but good data helps improve the good work already being done to help people experiencing homelessness across Washington. Data is important, and there is a report for that. It is the Data Quality Report (DQR). What is the DQR? The DQR reviews data quality for many HMIS data elements and helps us understand how our programs and projects are doing with data quality. For an overview…

Excel Beginner Tip: The Power of Data Filters

The power of data filters is that they can help you find information quickly and increase efficiency. Hours of slowly scrolling a large dataset for a certain piece of information can be replaced by a few clicks. What is a Filter? A filter finds and displays all cell values that match a certain criterion. The data in your spreadsheet can be filtered by text, number or color. How to turn…

How to: Current Living Situation report

If you are entering data for a Street Outreach project or other service projects, you would also have recorded each contact you make with clients in a little section called the Current Living Situation. Once all this data is collected, how and where would you access them? Currently, there aren’t any reports within HMIS built specifically for Current Living Situation, but there is a quick workaround using the Program Details…

Excel Beginner Tip: View summary data on the Excel Status Bar for a quick summary of your data without using an equation.

Have you ever needed a quick count of clients or wondered what their average age is? The average age and more information can be found easily on the Excel Status Bar if properly set up. Set your Status Bar You can find the Status Bar at the bottom of the Excel Spreadsheet; see the orange rectangle below. Right-click on the Status Bar to bring up the ‘Customize Status Bar’ window.…

Excel Advanced Tip: Tell your formulas how to behave with absolute references in formulas using ‘$’

In Excel, if you write a formula in a cell, it is common for it to contain a cell reference, which means the formula points to a value in one or more other cells. In the example below, the formula in cell E2 references cells B2, C2 and D2. It determines the total number of phone cards requested during the quarter by adding together the requests in April (B2), May…

Help with internet costs and laptops

The Emergency Broadband Benefit will provide a discount of up to $50 per month towards broadband service for eligible households and up to $75 per month for households on Tribal lands. Eligible households can also receive a one-time discount of up to $100 to purchase a laptop, desktop computer, or tablet from participating providers if they contribute $10-$50 toward the purchase price. The Emergency Broadband Benefit is limited to one…

The Annual Homeless Assessment Report (AHAR)​

The report found that between 2019 and 2020, homelessness increased significantly among unsheltered populations and people experiencing chronic homelessness. “The findings of the 2020 AHAR Part 1 Report are very troubling, even before you consider what COVID-19 has done to make the homelessness crisis worse,” said Secretary of Housing and Urban Development Marcia L. Fudge. “Thanks to President Biden’s leadership, we are once again putting Housing First to end this…