Below are some alliance resources that we have compiled. The spreadsheet in the top link has
background code written to do a number of things. Here is how you work with the spreadsheet:
First - BE SURE THAT MACROS ARE ENABLED! Click here to find out how to do so - this guy has
compiled an excellent set of instructions for all versions of Excel.
PLEASE READ THIS COMPLETELY BEFORE OPENING THE SPREADSHEET!
The INFO tab contains coordinates, grid type (sub, main, FP, etc), user, and user alliance, level,
and speed information that a few of us have started compiling. Add any information pertinent to
your area on that sheet and DO NOT change the layout of the sheet.
The COMPLETE tab contains a complete 600x600 grid of the Server 7 Haypi Kingdom. In cell A1,
there is a small button. Clicking that button resets the entire grid completely and refills the
applicable cells for those that have coordinates listed on the INFO tab.
*******************************************************************************************************************************
Find Player: These buttons along the top will help you find the coordinates for any recorded player
that we have on the spreadsheet. Clicking any of the buttons will bring up a form providing the
option to choose an Alliance or a Member from dropdown menus. Changing the Alliance dropdown
on the left will change the players available on the Members dropdown. To see all Members in the
dropdown on the right, choose the top (blank) option in the Alliance dropdown.
If you have chosen to list all players on the right, choosing a single player will then refresh both
dropdowns so that their alliance is chosen on the left. You will then see all of their recorded alliance
members in the dropdown on the right.
When you have chosen a player and see all of the recorded details below, clicking any of the
coordinates will take you to that spot on the map. If you wish to fill in information about all of the
high level users around you and your favorite FPs, please add them to the INFO sheet in the
existing fashion. DO NOT ADD THEM DIRECTLY TO THE MAP SHEET. The map is periodically
refreshed while using it and always when it is first opened.
The best course of action is to send me a list of coordinates that you want added to the spreadsheet
- or send back the modified spreadsheet itself (ask me for my email address) - and I will get it
updated. This sheet will be regularly improved upon so send me the details if you want them added.
*******************************************************************************************************************************
One other good use of this: Download the spreadsheet to your computer and get to the area of the
grid that your cities are in. Map out all FPs that are not already mapped. Now you'll be able to find
and keep track of all the FPs in your area and it may help with determining which ones you have and
haven't farmed recently if you use a method that works, such as always sweeping left to right, top to
bottom.
|
|
