Shell FCs are a bigger problem than we think...

[Almagnus1]

Anyhow, let's go back to this "problem"... have some proper stats as of March:

Characters with access to FC housing: 1,848,832
Characters with access to personal housing (with all 3 tenants): 271,885 (1,087,540)

And all of this is completely irrelevant to shell FCs. If you're going to cite population, at least use https://ffxivcensus.com/

Then again, this is coming from the same person that wrote a guide on how to get a shell FC to the point that it can buy a house ( https://www.xivhousing.com/free-company-leveling ) which is making this entire situation worse. So it's no surprise you're going to overzealously defend shell FCs.

Average characters per FC with a house:

NA: 23.4
EU: 17.01
JP: 10.4

Again, irrelevant to the discussion of shell FCs as I already pointed out 80% of the FC housing have at least 4+ members.

FCs with a house and less than 4 members:

NA: 6,053
EU: 3,519
JP: 14,154

Yes, I'm aware of this as I had previously said:

Your data shows that NA has 38,772 FC houses, 6053 of which have less than 4 members to them (which is 15.61%), while EU has 18,342 FC houses and roughly 3,519 have less than 4 members, which is 19.19%. So the 20% worldwide is actually higher because the problem is worse in JP than it is in the other regions.

So you're saying that of the 62,681 FC houses in Japan, 48,527 of them which are for FCs that are 4+ members (which is what I consider to be a legitimate FC in the scope of this post) don't care about small FCs?

I'm not talking about them, only the 14,154 FC houses for FCs that have 1-3 members, which comprise 22.58% of the FC houses in JP.

FCs with a house and less than 4 members created since the temporary restrictions have been added:

NA: 3,217
EU: 2,257
JP: 6,522

Problem isn't on when they were added, it's that they exist to begin with.

Let's compare the amount of FC houses with less than 4 members that have been purchased after those restrictions against all the FC houses:

NA: 3,217 out of 38,772 or 8.3%
EU: 2,257 out of 18,342 or 12.3%
JP: 6,522 out of 62,681 or 10.4%

When the purchase happenned is irrelevant when the problem is they exist to begin with.

Now let's compare your so-called "shell FCs" against all the available plots:

NA: 3,528 out of 138,240 or 2.5%
EU: 2,378 out of 69,120 or 3.4%
JP: 7,185 out of 184,320 or 3.9%

And look! You're even going so far as to leverage the fact that FCs take up about a third of all the FFXIV housing to make the problem appear as if it's nonexistant!

Such an intellectually honest response /s

While you are here, what are your thoughts on removing personal housing from players who are not consistently capped when it comes to tenants? If you want to take away FC houses that are below the initial members requirement, why not advocate for the same thing for personal housing? After all, as shown above, personal housing cannot accommodate nearly as many players as FC housing.

As stated previously, personal housing is completely irrelevant to the shell FC issue. Shell FC housing is done explicitly to bypass the personal housing requirements and let one person acquire more houses than what SE intendes.

Bonus question... should every single Free Company that falls below 4 members be terminated? Again, the initial requirement to submit a petition is 4 members.

Going by https://na.finalfantasyxiv.com/lodes.../housing_land/ the requirement to buy an FC house is four characters. It seems reasonable that the FC should stay at alest four members (which roughly 80% of the FCs do worldwide) to retain their house. There definitely needs to be a discussion around removing the FCs that fall below four (and where that threshold should be) because the data from SE with respect to the FCs isn't the cleanest (especially since there's 0 member FCs in that data).

*For the record, the % of "shell FCs" is even lower if you start adding filters like FC rank/GC status, but I had to give them a chance*

Rank 6-8 FCs with a house and 3 members or less:

NA: 3,080 out of 138,240 or 2.2%
EU: 1,807 out of 69,120 or 2.6%
JP: 5,155 out of 184,320 or 2.8%

And here we go with using all the houses instead of specifically talking about the FC housing just to water down the stats.

Here's what those stats are if you only look at the FC housing:

NA: 7.94%
EU: 4.66%
JP 13.30%

EU's low percentage is due to EU having generally less FC housing overall than the other two regions.

Rank 6-8 FCs with a house and 3 members or less created since patch 4.2.

NA: 2,411 out of 138,240 or 1.7%
EU: 1,699out of 69,120 or 2.5%
JP: 1,209 out of 184,320 or 0.6%

As stated previously when the purchase occurred doesn't matter, the problem is that they exist because the shell FCs are making this entire housing situation worse.

I love how you dismiss or straight up don't answer anything that destroys your posts. Part of me wishes you had the capability to properly defend the insanity you type on this board, but I guess you can't have it all!!!

Yes, because writing a more indepth response is more important than getting to the gym so I stay sexy! =D

Btw, all the data is on the website. Stop crying.

From having worked with PowerBI, I know that whatever you set the query the database uses to pull the data will define the dataset displayed, and as you have shown a pattern of using the data to represent the issue as not as significant as it is, I fully expect all views coming from you to be tailored to best fit your narrative regardless of what the data actually says. As your site hosts a guide on how to cheese the FC system to quickly spin up a shell FC (and yes, that's what your guide facilitates whethere you want to acknowledge it or not), I fully expect you to defend this flaw in the housing system and provide manicured data slices instead of the actual DB of data.