Site-searching question

Jazzepi · #1 June 30th, 2007, 05:02 PM

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

lch · #2 June 30th, 2007, 05:21 PM

LVL = level required to find it. 0 is prolly visible from the start, for the others you need to look with a mage from that TYPE who has at least the level listed to find it.

FAWEDNB is the number of gems by type, yes.

If you scroll a bit more to the right, you can see the province terrain where the sites can be encountered. I guess you can sort the data by the Sea column.

Endoperez · #3 June 30th, 2007, 05:46 PM

There's also a terrain column for Deep Sea. Otherwise, read what lch wrote.

Jazzepi · #4 June 30th, 2007, 05:52 PM

Maybe I'm missing something, but the plains/forest/mount/waste/farm/sea/ciast/swamp/deepsea/coast/unique are all empty in this database I'm looking at. I suppose they're suppose to have a X mark or something to indicate that's where the site is allowed to spawn?

Jazzepi

vfb · #5 July 1st, 2007, 12:20 AM

They have 'Yes' in the .ods file to indicate that's where the site is allowed to spawn. Maybe it's a problem with exporting a boolean type field to .xls?

Edi · #6 July 1st, 2007, 01:42 AM

It's probably a conversion problem from the OpenOffice format to Excel, but I'm not going to fix it. I lifted the coding for site display from DrPraetorius and didn't check if it worked in Excel. If somebody wants to fix it, go right ahead.

Also, reading the Magic Sites section of the Glossary sheet should give you a good idea of what the different columns mean. The Glossary has explanations for all of the columns in all of the otehr sheets.

DireAussie · #7 September 28th, 2007, 02:25 AM

It requires a slight change to the formula, basically it needs an extra IF condition for the >= test

fixed formula for row BF2:
Code:

=IF(IF(MOD($E2+32768,SiteMasks!$A$3)>=SiteMasks!$A  $2,1,0)=1,"Yes","")

The formula is the same through to row BP2 but you have to replace the numbers from $A$3 and $A$2 with the numbers from the old formula. Then you can just fill down the columns.