Bank Finding (spreadsheets)

Overview
In this page we will take a look at the most advanced technique to finding good banks. This is a time consuming technique which requires quite a bit of excel skill, but hopefully this page will help you understand how to do it. There are four main steps, each in their own section below.

Gathering the Data
The first thing you want to consider is which data do you want to gather. There are three main data points you need and those are Kingdom Name, Land and Networth. There's two places where you can gather these - from top scores or per sector. The top scores option is less time consuming, however gathering the data per sector is preferable, as it allows you to gather more data, such as the @ sign that shows whether the user is online or not.

Organizing & Manipulating the Data
This step is either easier or harder depending on your data collection method. If you collected the data from scores you will have two different tables where you will need to use excel's VLookUp function to match name and numbers from both tables. If you gathered the data directly from the sectors, you might need to make small adjustments in case kingdoms died or new kingdoms signed up. It is essential that all your data lines up.

Typically you will end up with kingdom names on the rows, and land / nw on the columns. Since you want to analyse these over time, you actually need to transpose the axis of the table, meaning that kingdom names are on the x axis and networth and land are on the y axis.

Certainly you've realized it would be very difficult to have both land and nw on the y axis, so two different tables are best.

Analyzing & Interpreting the Data
Now that you have a time series, you want to analyze your data to find which kingdoms have been inactive.

If you would like to know more on how to analyse & interpret the data, write a few wiki articles and contact RMagician. He likes people who write wiki articles.