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…

Washington Community Economic Revitalization Board invests over $10 million in nine rural county projects

Washington Community Economic Revitalization Board invests over $10 million in nine rural county projects

OLYMPIA, WA – The Washington State Community Economic Revitalization Board (CERB) yesterday approved $8,272,040 million in grants and $1,975,000 in low-interest loans for planning, economic development and rural broadband infrastructure construction projects. Five rural broadband projects were approved for nearly $8 million in funding from the CERB coronavirus capital projects fund, enabling an estimated 3,362 high-speed internet connections once completed. Projects are located in Grays Harbor, Kitsap, Mason, Skagit and…

Commerce awards $11.4 million for vital infrastructure projects in 20 rural communities

Commerce awards $11.4 million for vital infrastructure projects in 20 rural communities

Community Development Block Grants fund wide range of high-priority local projects, including public water, sewer, emergency and fire protection systems, streets, housing, food pantries and more. OLYMPIA, Wash. – The Washington State Department of Commerce today announced 20 rural cities, towns and counties will receive a total of more than $11.4 million in Community Development Block Grants (CDBG) for 2021. The 22 projects funded will: improve rural water, sewer, streets,…

Vaccination and masking requirements at Commerce

Who is included in Washington state’s vaccination and masking requirement? Here is a brief overview: All Commerce employees — including those working remotely — must be vaccinated by Oct. 18 unless approved for a medical or religious exemption. When working in person or onsite at a Commerce location, ALL independent contractors, grantees, service providers and volunteers must comply with the requirement to verify vaccination status AND wear a mask. If your contract or work…

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…

COVID-19 utility moratorium ends Sept. 30; state leaders urge customers who are behind on energy and water bills to contact utilities and make a plan to keep services on

COVID-19 utility moratorium ends Sept. 30; state leaders urge customers who are behind on energy and water bills to contact utilities and make a plan to keep services on

More than half a million Washingtonians are at risk of having electricity, natural gas or water services shut off OLYMPIA, WA — The emergency proclamation preventing shut-off of water, electricity or natural gas services is slated to end Sept. 30. It is among the many emergency measures enacted by Gov. Jay Inslee in the wake of COVID-19. State leaders and utility operators estimate more than 500,000 Washingtonians have overdue bills…

Commerce Clean Energy Fund awards grants to 18 innovative electricity grid modernization projects benefitting Washington communities

Commerce Clean Energy Fund awards grants to 18 innovative electricity grid modernization projects benefitting Washington communities

Grants fund electricity grid projects that will expand renewable energy use and support community resilience.  OLYMPIA, WA – The Washington State Department of Commerce today announced approximately $3.9 million in grants from the state’s Clean Energy Fund for 18 electricity grid modernization projects across the state. As Washington’s utilities advance towards the state’s goal of 100% clean electricity by 2045, the projects will advance a variety of renewable energy technologies…

New report: Staggering staff turnover rate emphasizes urgent need to support child care workforce in order to increase access and affordability of quality care

New report: Staggering staff turnover rate emphasizes urgent need to support child care workforce in order to increase access and affordability of quality care

Washington’s Child Care Collaborative Task Force releases strategy that builds on historic Fair Start for Kids Act investments, calls for focus on growing the child care workforce. OLYMPIA, WA – Washington state’s Child Care Collaborative Task Force released a comprehensive new strategy that emphasizes the urgency of bolstering the child care workforce amidst a staggering turnover rate of 43 percent. The new Washington State Child Care Access Strategy makes clear…