Author Archives: Housingnet Help Desk

Business Intelligence On Demand

We were concerned that some clients were still checking tender emails each day from sources other than Housingnet. You don’t need to do this as we have a team of six doing that for you and we spend a lot more time organising them. The system we have built will replace the daily Bulletin as email is not the best delivery method for this type of content. We hope you like what we’ve built and, as always, we welcome your feedback.

Get started with the new BIOD system

settingx30 Settings – There are four ‘Settings’ panels –

  • Current Tenders – select Regions and Trades
  • Contract Award Notices – select Regions and Trades
  • Minutes – select Regions and Topics
  • News – select Regions and News Categories

Click on the settings icon in each section to save your choices. The selections that you make here will be reflected on all ‘contract’ searches throughout the site.

settings-biod
table-icon-biod Select the table icon to link to the main Current Tenders and Contract Award Tables
ct-rnm-biod-grid2 Tenders and Contracts in a darker font are the latest to be posted.
view-more-biod ‘View More’ will take you to the respective table to view older Tenders, Contracts and Minutes
minutes-settings-biod Local Authority, and sometimes Housing Association, Minutes can make for very useful insights. We search all Minutes looking for information we think might be relevant to you.
mobile-biod BIOD works on your mobile as well. Revisit this old blog post to see how to add a Housingnet icon to your mobile home screen and here to learn more about the mobile version.

Welcome to BIOD from Housingnet

Please send any questions and queries to helpdesk@housingnet.co.uk

Gender Pay Gap in the Social Housing Sector

The Gender Pay Gap reporting deadline was last night so we’ve compiled tables for Housing Associations and Local Authorities. If you have a Housingnet Licence and are signed in you can link to the full tables here:
Housing Associations
Local Authorities

Housing & Care 21 have the unenviable position of coming top so far in the HA table with a mean and median difference between the pay of women and men of 36% and 28% respectively. This means that women’s mean hourly rate is 36% less than men and a median rate of 28% less but this would most probably be due to the various types of job role within the organisation.
Glasgow Housing Association have the lowest minus (-) figures meaning that women are paid a mean hourly rate of 25% higher than men. The most even handed Housing Association is Choices who report no difference in their mean or median pay.

Overall companies in the UK have reported a 9.8% median pay gap in favour of men with construction having the largest average difference by sector.

Housingnet registration is free to all Housing Association and Local Authority people.

* Hourly rate mean and median figures are positive when female hourly rates are lower than men.

The mean hourly rate is the average hourly wage across the entire organisation so the mean gender pay gap is a measure of the difference between women’s mean hourly wage and men’s mean hourly wage.
The median hourly rate is calculated by ranking all employees from the highest paid to the lowest paid, and taking the hourly wage of the person in the middle; so the median gender pay gap is the difference between women’s median hourly wage (the middle paid woman) and men’s median hourly wage (the middle paid man).

Housing Organisation Stock Number of Employees Employees earning over £100,000
Female hourly rate comparison (%)*
Mean Median
Who Got a Bonus? (%)
Male Female
% of women in each pay quartile
Lower Lower Middle Upper Middle Top
Places For People Group Limited 182,725 11,365 57 6.3 -5.5 5.8 4.3 52.3 57.7 59.5 58.6
Clarion Housing Group Limited 101,393 3544 50 5 -1.8 72.4 75.3 43.3 60.9 61.6 46.2
Sanctuary Housing Association 66,878 8423 20 17.8 11.3 2.9 1.8 64 71 62 49
The Guinness Partnership Limited 55,107 2718 17 6.4 -4.8 50 58.3 51.3 53.7 59.4 48.3
The Riverside Group Limited 45,865 2710 12 8.1 6 76 74.8 61.4 70.6 70 55.3
Home Group Limited 44,197 2664 18 11.9 5.3 9.2 10.5 65.1 66 69.1 54.4
Sovereign Housing Association Limited 45,580 1862 24 5.2 7.2 61 58 61 40 42 43
Peabody Trust 43,590 1143 28 -2.4 -7.1 75.6 79.8 26.5 58.3 50.2 48.9
Together Housing Group 35,603 1300 8 6.4 10.5 0 0 65 47 35 36
WM Housing Group Limited 33,269 922 5 15.9 5.8 0 0 65.6 58.1 57.4 53.2

Housing Associations
Local Authorities

Housingnet Update February 2018

1. The League Tables are out for January and we have completed our first full year so we can start to compare month & year to date. A new ‘Construction’ table has been added.
https://housingnet.co.uk/contractor_league_analysis/rr/jan/2018

2. Expiring Contracts – we’ve added Stock, Repairs Satisfaction, Gas Servicing %, R&M Cost per Home, Planned Works Expenditure (previous year), links to Analysis metrics and related news.

exp-contracts-hn-update-2018
https://data.housingnet.co.uk/master/tender/expiring_contracts

3. All new Planning Applications relating to New Build are being added to the system in readiness for the launch of our ‘Development Opportunities’ section in March.
https://data.housingnet.co.uk/master/portal/planning/

All Brownfield registers are currently being uploaded and will be available by the end of February.

4. Market share analysis will be updated in March and then quarterly after that.

5. You all currently receive an advertising package from us worth £5000 and we are just about to ramp that up. Please hand us over to your marketing departments so we can show them the advertising opportunities we offer as part of your licence fee.

6. And lastly please remember that we have six people monitoring all daily tenders and tend to get them out quicker than the competition. We’ve not missed a tender yet so you can feel confident in using this service. Saved Tender searches can be viewed on the Current Tenders table and in the ‘Business Intelligence On Demand ’ service. You can access both from the main site Menu or on your phones at www.housingnet.co.uk – (https://www.housingnet.co.uk/blog/how-to-add-a-housingnet-quick-launch-icon-to-your-mobile-or-tablet/).

Set up your Tender preferences here: https://housingnet.co.uk/login/accountdetails

We have a lot going on at the moment but still welcome suggestions. We’re thinking about building a housing stock heatmap so you could select the stock you’re working on or are interested in and it would appear on the map as a heatmap. You could then overlay that with the stock markers for another HA/LA so you could see how easily, or not, it would be to cover the contract.

This visualisation is showing multiple organisations stock as a heat map, overlaid with Guinness Partnership stock and Jewson stores. You can show/hide the Jewson markers from the icon on the right hand side.
https://www.housingnet.co.uk/map/mapping/guinness/heatmap/

And this is a visualisation we built for Housing Associations which is looking at outlying stock and potential partners to swap stock with.
https://www.housingnet.co.uk/custom_map/stock_rationalisation_part2
Click on the purple marker then select Knightstone from the box that opens.

We’re here if you need us.

Building a wall !

Hello, thank you for dropping by.

Sadly after displaying free Housing Association details on the web for the past 20 years the time has come for us to build our own wall.

We now very specifically target Contractors, Suppliers and various other companies working in the Housing sector and no longer provide, what we have always called, ‘marketing data’. Previously we would allow visitors a snap shot of the information we hold to entice them to buy from us but for the past 20 years we have spent a lot of time dealing with enquiries from the general public either thinking we were a housing association or requesting advice and information about housing.

Click here to find out more about what we do, the licences we sell and how to register.

If you are already registered, .

Unfortunately the time has come for us to close off access to the address data and our news so we can concentrate on our core product. If you followed a link from a Google search to get here this will take time to be removed but we have done all we can to speed up this process to minimise the inconvenience.

For all housing enquiries it is always best to contact your Local Authority which you can locate here.

How to: Company / Competitor Analysis

How to find information on Housingnet relating to companies, the contracts they are, or have been, involved in, contract location, Contract Registers and Expenditure Sheets.

  1. Using the Search Bar
  2. Contracts Map
  3. Contracts & Tenders Portal
  4. Company / Competitor Search


 
Using the Search Bar

Name Search for company contact, people and financial data from the ‘Search’ link in the header (top) bar.

header_search

The other search icons in the header relate to People, an A-Z director of organisations, the Land Registry Title Search, News and on the far right side, Reports in the Housingnet Library.

search_icons

Every organisation we collect data on will have dedicated pages of information which you can access from the tabs at the top of the page.

keepmoat_ov


 
Contracts Map
Click on the ‘Map’ tab in the image above and then select the yellow ‘View the Contracts Map’ at the top of the page.
Menu > Maps > Contract Map - Select the company from the tab on the right hand side of the map.

contractor_select

The contracts are colour coded according to the expiry timeframe:

Red – Less than 12 months remaining
Amber – Less than 2 years remaining
Green – More than 2 years remaining
Blue – Direct Labour Organisations (DLOs)

contracts-map-keepmoat

 
Contracts & Tenders Portal
Menu > Search > Tenders & Contracts

Every PIN, Contract Notice and Contract Award Notice on Housingnet can be found in the ‘Contracts & Tenders Portal’. Type in the name of the company and select ‘Winner’ from the search drop down.

contract_portal

 
Company / Competitor Search
Menu > Search > Company/Competitor
Menu > Dashboard > Dashboard

menu

Search by Company (or Keyword such as ‘modular’ or ‘boiler’) from the search box on the Dashboard or in the Business Intelligence section of the Data Bank.

company-search-dashboard

 

High & Low Value Contracts

There are 3 sections in the Company / Competitor section:

  1. High & Low Value Contracts
  2. Contract Register
  3. Expenditure

The first page of results will display a list of all ‘High & Low Value Contract Winners’ containing the search term you used. Either select the companies of interest to you from the list individually or ‘Check All’ to select everything. Click on the ‘Fetch Data’ button.

keepmoat_contracts

All current and expired contracts are displayed in the results. Uncheck the ‘Display archived results’ tick box to remove the expired contracts. Total Contract Value from the CAN is displayed alongside the number of Framework contracts that are listed.

As with all these tables the results can be exported to a spreadsheet.

keepmoat-results

 

Contract Register

Every local authority maintains a corporate register of contracts intended to provide schedules of contracts for keeping track of an agency’s contracts and financial commitments with its suppliers; and contract statuses which can be used by public organisations to provide transparency.

CR-results

 

Expenditure

The Expenditure sheets are useful for suppliers to see which Local Authority is buying from your competitors and the value of the purchases.

Expenditure over £250 provides information of payments made by the Council to its suppliers in excess of £250 to increase openness and transparency.

expenditure-results

 

As always we are on hand to help and to export any data requests. If you have any questions, comments or queries please write to us – helpdesk@housingnet.co.uk

How to add a Housingnet quick launch icon to your mobile or tablet

Add this icon to your mobile or tablet home screen to link directly to the Housingnet site.

hn_launcher_192

We could write all the instructions out again but we found this page to be informative and easy to use:

https://www.howtogeek.com/196087/how-to-add-websites-to-the-home-screen-on-any-smartphone-or-tablet/

Please note that only Safari browsers on the Apple products have the option to add a quick launch icon.

hn_icon
As always, if you get stuck, please get in touch.

Mobile Housingnet v.2

The Premium mobile version of Housingnet has had an upgrade. You told us what you wanted and we hopefully built something useful for you. Below we’ve added some screen shots of the biggest changes to help you navigate the site.

Open www.housingnet.co.uk on your mobile phone. Select the ‘Menu’ icon in the top right and open the ‘Premium Login’ page to sign in. The Menu icon will change from green to white when you’re logged in.

Please note: if you found yourself stuck looking at the main Housingnet site on your mobile, (you would know it as it looks awful) and can’t get back to the mobile version all we can say is sorry, that was our fault. To rectify this you need to clear the browser cache. If you need help with this please call us.

Search for any Housing Association or Local Authority to view contact details, stock, contracts & news. We will connect the minutes and add all contracts for each contractor in the next version.

In the previous version we added Tenders, CANs and Expiring Contracts. Once you login any searches you have saved on the main site will be visible. To change the search criteria for any table open ‘Settings’ in Menu > Contracts > Settings

Don’t forget that further contract details and the ‘Pin’ icon (used to add a contract to your ‘Favourites’) can be viewed by clicking on the contract title – shown with the red border.

And lastly the League Tables have had a make over so they look a lot better than they did previously – we hope you agree.

As always, any questions, suggestions or frustrations should be sent to helpdesk@housingnet.co.uk so we can keep on learning.

Menu

home_screen_new
menu_1
menu_2

Details pages

ha_details
HA News
ha_news

Tenders

contracts

League Tables

league

Top 30 HA Financial Data Analysis

HousingNet registered users will find all the raw data for this on their Dashboard. If you’re not a client of ours this is what we do.

We also built this free Postcode search using some of the data we collect to take a look at what’s happening in your area.

Turnover (£) -2016 Turnover (£) -2015 Difference % Change
9,465,114,000 8,881,784,000 583,330,000 6.6%
Group Stock – 2016 Group Stock – 2015 Difference % Change
1,340,337 1,200,984 139,353 11.6%
Operating Surplus (£) – 2016 Operating Surplus (£) – 2015 Difference % Change
2,592,111,000 2,411,376,000 180,735,000 7.5%
Repairs Satisfaction (%) 2016 Repairs Satisfaction (%) 2015 Difference % Change
85 84 1.6 1.9%
Cost Per Home (£) – 2016 (avg.) Cost Per Home (£) – 2015 (avg.) Difference % Change
950 902 48 5.3%
Days to Relet – 2016 (Avg. for 17 HA’s out of 30) Days to Relet – 2015 (Avg. for 17 HA’s out of 30) Difference % Change
29 32 -3 -9.4%
Repairs & Maintenance Cost Per Home (£) – 2016 (Avg. for 13 HA’s out of 30) Repairs & Maintenance Cost Per Home (£) – 2015 (Avg. for 13 HA’s out of 30) Difference % Change
1,036 1,093 -57 -5.2%
Routine R & M Expenditure (£) 2016 Routine R & M Expenditure (£) 2015 Difference % Change
831,837,000 823,030,000 8,807,000 1.1%
Planned Maintenance Expenditure (£) – 2016 Planned Maintenance Expenditure (£) – 2015 Difference % Change
386,942,000 385,225,000 1,717,000 0.4%
Improvement Works (£) – 2016 Improvement Works (£) – 2015 Difference % Change
1,118,092,275 1,077,879,698 40,212,577 3.7%
Void Losses (£) – 2016 Void Losses (£) – 2015 Difference % Change
81,015,000 107,315,000 -26,300,000 -24.5%
Employees – 2016 Employees – 2015 Difference % Change
41,721 39,446 2,275 5.8%
Wages (£) – 2016 Wages (£) – 2015 Difference % Change
1,170,041,000 1,104,446,000 65,595,000 5.9%
Chief executive pay for top 30 HAs- 2016 (£) (avg.) Chief executive pay for top 30 HAs- 2015 (£) (avg.) Difference % Change
237,180 225,081 12,098 5.4%
Chief Executive pay per home 2016 (£) (avg.) Chief Executive pay per home 2015 (£) (avg.) Difference % Change
6 5 1 9.4%

FR_Analysis_grp

Social Homes valued at over £500,000

Happy New Year all.

Now that we’ve valued nearly all social homes in England we can start interrogating the data and we’re open to suggestions on this. We welcome your input so please let us know your ideas and we’ll trawl the data to find the answers.

We have a breakdown of properties valued at £300K – £499K and over £500K that we’ve added to the site for our registered users. The data is broken down between Housing Associations and Local Authority stock and then Freehold / Leasehold and Houses / Flats. This snapshot of the data is showing the total homes from HAs and LAs valued at >£500,000 and their total value.

District Total Homes Total Value
CITY OF WESTMINSTER 10507 10,631,697,106
KENSINGTON AND CHELSEA 9814 9,973,303,639
LAMBETH 12284 9,260,658,437
CAMDEN 7266 6,399,516,467
ISLINGTON 8451 6,381,363,664
HAMMERSMITH AND FULHAM 6651 5,986,773,492
HACKNEY 6269 4,447,997,781
WANDSWORTH 5597 4,137,797,080
TOWER HAMLETS 5227 3,422,338,031
SOUTHWARK 4344 2,857,326,031
RICHMOND UPON THAMES 2906 2,538,986,321
BRENT 1994 1,335,670,245
BARNET 1286 1,113,373,236
LEWISHAM 1719 1,075,060,804
EALING 1352 1,065,367,650
HARINGEY 1510 1,000,692,089
MERTON 1023 689,202,489
ELMBRIDGE 594 441,597,491
GREENWICH 649 433,177,005
BROMLEY 559 388,945,931
SEVENOAKS 564 361,506,474
HILLINGDON 349 353,061,921
HOUNSLOW 437 314,167,078
CAMBRIDGE 408 283,629,516
WAVERLEY 414 258,471,262
WINDSOR AND MAIDENHEAD 363 250,549,988
BATH AND NORTH EAST SOMERSET 323 217,601,920
CROYDON 323 202,483,812
SOUTH BUCKS 242 197,012,613
HARROW 297 196,595,687
TUNBRIDGE WELLS 307 187,973,986
WOKING 276 183,555,334
EAST HERTFORDSHIRE 284 178,851,312
CORNWALL 306 178,224,981

To calculate stock and value we use a combination of the Land Registry Corporate database, NROSH, House Price data and an awful lot of data scraping and cleansing.

If you have an idea for data analysis please send it over. We will share all the output with you whether or not you are registered on Housingnet.

Every Housing Association, on purchasing an unlimited licence from us, can access all their own Land Registry titles including geo-co-ordinates along side our normal data service.

House Price Valuation

We’ve been working with the Land Registry Corporate data set for a couple of years and the bulk of that time has been spent cleansing the data and adding geo-positioning co-ordinates for each social home. In May this year we started to look at portfolio valuation but the lack of bedroom data meant that there was a lot of guess work involved and the results didn’t stand up to scrutiny.

We set about collecting bedroom data and along the way we amassed a large amount of information on individual properties which 6 members of the team add to every day. Through this ‘big data’ exercise we started to get interest from Estate Agents and property websites resulting in an exclusivity licence with www.loyaltystreet.com and other opportunities for data cleansing and analysis.

Property Ownership Midmoor Road SW12

Property Ownership Midmoor Road SW12

Housing Associations own a vast amount of property and not all of it is social housing so we removed everything that wasn’t a flat or a house. We spent months cleansing incorrect road names, Postcodes, door numbers and house/flat designations and wrote countless algorithms to tweak the process each time.

1. Firstly we removed Land Registry Titles that was not a home – examples of this are – student/nursing accommodation, electricity sub-stations, shops, business units and even a bowling alley.
2. The initial property valuation exercise looked at any properties sold since 1995 ie. exact matches from ‘House Price Data’.
3. We then used various criteria to segregate the homes as either Flats or Houses and attached bedroom data to each record.
4. CAGR (Compound Annual Growth Rate) was used to calculate the current price of the property.
5. Based on the initial match with Price Paid data and the number of bedrooms we took out the average price for flat and house based on the Lower Layer Super Output Area or Postcode level, whichever was more accurate.
6. Using the average price we attached a value to the remaining properties and then used the House Price Index to cross check our results.

Finally, last Wednesday, we got something we were happy with for L&Q

Total Social Housing homes: £18.12 billion
Freehold : £15.67 billion
Leasehold : £2.45 billion

It’s not exact but it is, we believe, a very good indication of the current market value.

Currently we’re collecting every Social Housing new build including room sizes, client, contractor, construction type etc. Calculating valuation on 4.6 million social homes and enhancing the data of 3000 homes a week.

Every Housing Association, on purchasing a multi-user licence from us, can access all their own Land Registry titles including geo-co-ordinates along side our normal data service.