Site-searching question

lch · #1 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 · #2 June 30th, 2007, 05:46 PM

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

Jazzepi · #3 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 · #4 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 · #5 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 · #6 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.

Humakty · #7 September 28th, 2007, 09:30 AM

I'm not contesting your logic, but to make my mages crawl on the map seems to me quite long. If you organize your search wisely, you need one turn to move and one turn to search,whereas a mage casting search spells search every turn.
It is true it costs me a big quantity of gems.
I think that the more sites you put as a setting, the more it is viable to cast search.(the less gems it represents of your total income)
In facts, I guess it is just sheer lazyness.(cast monthly and forget..)