Archaeology Wage Calculator.
Currently the Calculator is in an excel spreadsheet. You can download it here and directions are below. Unfortunately, it is only in Microsoft Excel XLSX. If you do not have the program to handle such a format, interactive charts are being added at the bottom of this webpage so that you can make calculations on this page.
Currently the Calculator is in an excel spreadsheet. You can download it here and directions are below. Unfortunately, it is only in Microsoft Excel XLSX. If you do not have the program to handle such a format, interactive charts are being added at the bottom of this webpage so that you can make calculations on this page.
archaeology_wage_calculator_beta_0.0.xlsx | |
File Size: | 1485 kb |
File Type: | xlsx |
Legal: This calculator is provided as is for personal research. The back end tab contains the raw data used. All formulas are left open to see so that anyone can check the calculations for errors. This resource might contain errors that could significantly change the outcomes. If you find any errors please contact [email protected] to report them. Because this calculator might contain errors it is recommend that this is used only for personal research and by using this calculator you waive all rights to bring litigation against the creator for any issues that may occur for the use of this calculator etc. etc. etc.
Inflation: There are two measures of inflation in the United Kingdom, the Retail Price Index (RPI) and the Consumer Price Index (CPI). The CPI calculates inflation based on the average price increase for a basket of 600 different goods and services. At the middle of each month information on prices of these commodities are collected from 120,000 different retailing outlets. While the RPI is based on the Living Costs and Food Survey which samples approximately 6,000 responding households per year. The households are visited by an interviewer, and information is collected about income and regular expenditure, such as household bills and mortgage payments. A set of weights are then calculated, based on the relative importance of the items in the average family budget, and applied to each item to get an overall rate. The difference between how the CPI and RPI calculates the price of a good tends to result in slightly different calculations of inflation.
How To Use Calculator:
1. Determine Average Archaeologists Pay
Using the drop down menu in Cell B6 you can select which position you would like to see numbers for. Definitions of each position is defined in the Jobs in British Archaeology Series with can be found on this website . You can see average wages for those positions and how those positions have fared against inflation, both RPI and CPI.
Using the drop down menu in Cell B5 you can select which year you would like to see information from, heading forward.
2. See Your Wage Against Inflation
Enter in your starting salary (yearly) and your current salary (yearly) in Cells B3 and B4. Also, enter in starting year (for starting salary)200 to see how your wages compare against inflation.
3. Set Custom Inflation
You may set your own inflation rates based on your personal circumstances. Click yes to the set custom inflation button (Cells B8 and B9).
In the field below use the drop down menus to select the items that you yearly budget consists of, up to 20 items. Enter in either the percentages that the item makes up of your yearly budget (e.g. 5% 18%, etc.) OR enter in amounts (e.g. £435, £9,785, etc.) DO NOT ENTER BOTH % and Amounts.
Inflation: There are two measures of inflation in the United Kingdom, the Retail Price Index (RPI) and the Consumer Price Index (CPI). The CPI calculates inflation based on the average price increase for a basket of 600 different goods and services. At the middle of each month information on prices of these commodities are collected from 120,000 different retailing outlets. While the RPI is based on the Living Costs and Food Survey which samples approximately 6,000 responding households per year. The households are visited by an interviewer, and information is collected about income and regular expenditure, such as household bills and mortgage payments. A set of weights are then calculated, based on the relative importance of the items in the average family budget, and applied to each item to get an overall rate. The difference between how the CPI and RPI calculates the price of a good tends to result in slightly different calculations of inflation.
How To Use Calculator:
1. Determine Average Archaeologists Pay
Using the drop down menu in Cell B6 you can select which position you would like to see numbers for. Definitions of each position is defined in the Jobs in British Archaeology Series with can be found on this website . You can see average wages for those positions and how those positions have fared against inflation, both RPI and CPI.
Using the drop down menu in Cell B5 you can select which year you would like to see information from, heading forward.
2. See Your Wage Against Inflation
Enter in your starting salary (yearly) and your current salary (yearly) in Cells B3 and B4. Also, enter in starting year (for starting salary)200 to see how your wages compare against inflation.
3. Set Custom Inflation
You may set your own inflation rates based on your personal circumstances. Click yes to the set custom inflation button (Cells B8 and B9).
In the field below use the drop down menus to select the items that you yearly budget consists of, up to 20 items. Enter in either the percentages that the item makes up of your yearly budget (e.g. 5% 18%, etc.) OR enter in amounts (e.g. £435, £9,785, etc.) DO NOT ENTER BOTH % and Amounts.
Interactive Charts
Below are some interactive charts you can change the figures on. Currently it is only the start years (highlighted in blue) to see how wages have kept up with inflation for certain positions (currently diggers) since 1994. Change the year between 2011 and 1994 to see the differences. More will be added soon.
Below are some interactive charts you can change the figures on. Currently it is only the start years (highlighted in blue) to see how wages have kept up with inflation for certain positions (currently diggers) since 1994. Change the year between 2011 and 1994 to see the differences. More will be added soon.