Site-searching question

[Jazzepi]

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]

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]

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]

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]

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..)