Site-searching question

[Jazzepi]

Can someone help me out comprehending this database? I'm looking a the excel version.

There's columns "LVL", "TYPE", and then F/A/W/E/D/N/B. I assume that the level means the level you need of the specific type listed next to it, and all the letters are the gem output. Is that correct?

Is there an easy way to organize it so that I can see which sites appear in the water?

I checked on the actual number of level 1-2 sites and I counted it to be 299. Compared to the # of level 3-4 sites being 74. Breaking it down even further, there are 57 level 3 sites, and 17 level 4 sites.

What I'm curious about, more than anything else, is that I'm going to make a pretender to do some specific spell casting, but I also want to use him for site searching, so I'm trying to figure out the highest level he should be in paths when I'm only pumping them to site searching. It seems like level 3 is the answer. If you have level 3 in a path, according to this database and my bad math, you should have a 95.44% chance of finding a site of that type in the province. This doesn't take frequency modifications into account, which probably shift the number higher as level 4 sites are less frequent (the ones you can't find) and level 1-2 sites are going to be more frequent.

So I'd like to hear other people's ideas on this.

Jazzepi