Geldbeschreibung der Position der Eisprüfer (Lokalitätslohn / Median County Housing Price * Fudge -Faktor) [OC]

Where or how you got the data (Source)

* [Federal civilian employee locality pay](https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2025/general-schedule/)

* [NAR median single-family home price for year-end 2024, by county](https://www.nar.realtor/sites/default/files/2025-04/2024-q4-county-median-prices-and-monthly-mortgage-payment-by-state-04-29-2025.pdf)

The tool used to generate the visual (Tool)

* Excel to create the chart

* Paint to get an image

I was wondering which cities might be best able to help a federal civilian employee buy a house. I started making a spreadsheet to parse locations, so I could just drop in city/state for any job announcement and it would go through and tell me what I’m looking for, but locality is still more manual than I’d like. Any suggestions as to how to better automate that are welcome.

There aren’t many available jobs being posted to USAJobs.gov right now though and this one was useful to get a range of cities. If this is considered too contentious a political post then please delete it and I’ll repost on Thursday. I was hoping to get critique, see if maybe I missed something. For instance, some counties are bigger than others and the „standard commuting factor“ might be different and might allow a house in a different county. I don’t know how I’d go about doing that without a more manual process than I’d like, so suggestions are welcome.

The next step is to start getting education data to parse school districts, but that’s going to be another beast.

Also, why do some cities have a state listed and some don’t? Originally every location had a state listed but when I told Excel those were geo cells, that’s how it decided to display them. I presume it only lists state if it might get confusing. It seemed good enough to me so I didn’t bother changing it.