Re: Contest rules
I got the freeze panes part down. Did you manually put coordinates in, or is there a formula to automatically increase it every cell? What did you put in every box?
[ QUOTE ]
Here's a pic of what I do.
I did a screen split in the first row and column for the coordinates.
I color code mountains, deserted bases and member bases.
The member base colors are based on their fort level. I also put the most recent attack amount in front of the base name. I bold the name if they're known to be active, so I can easily spot where I need to visit.
I also hyperlink the member bases to another worksheet where I list out more detailed information about the base.
Excel doesnt allow a worksheet to be large enough to fit an entire map, so I broke the map into 4 parts width wise.
375W-240W, 239W-0W, 0E-239E, and 240E-375E
(Note there is a separate 0W and 0E, but getting to them isnt exactly intuitive)
I'm currently trying to work on a way for excel to put the data into ancient's template format, but being the excel neophyte I am, it's taking a little doing.
[/ QUOTE ]
|