| 1 |
401k Calculator
This template evaluates your 401(k) plan position and simulates future contributions by you and your employer. Also provides an analysis on your final balance which contains your contributions, employer's contributions and interest earned until retirement day.
|
| 105 |
Body Mass Index (BMI) Calculator
Body Mass Index is a measure of fat based on height and weight. This template is prepared for calculating BMI.
|
| 143 |
Cost Worth Diagram (Tanaka Method)
This template is prepared for comparing relative component costs to estimated worth using the method introduced by Tanaka (1989). Comparison of up to 10 components and up to 10 functions is ara available in this template. A comparison chart with lower and upper boundaries is provided. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 13 |
EOQ Model
This is a template for EOQ Model analysis for simple inventory systems. The template also allows to compare EOQ with any other quantity displaying the resulting costs.
|
| 75 |
Gym Activity Calculator
This template is prepared for evaluating the calories burned by different gym activity programs.
|
| 86 |
Inflation Calculator
This template is prepared for comparing the purchasing power of a selected amount of money in 2 different time periods. The template contains U.S. Consumer Price Index data from 1913 to March, 2009. Data can be updated up to 2020.
|
| 102 |
Global Electricity Consumption Dashboard
This template is another example of building dashboards in Excel. It includes a worksheet containing source data that can be updated. The dashboard will refresh immediately with new data.
Also included in this template, information to deploy it as a web application via SpreadsheetWEB
|
| 61 |
Inventory Calculator
This template is prepared for simulating orders and inventory positions according to Safety Stock policy.
|
| 65 |
Inventory sS Policy Analysis
This template is prepared for simulating inveontory costs (including checking, holding, backorder and replenishment costs) of a given demand data or forecast of 24 weeks. Daily inventory positions and incurred inventory costs are displayed on the 'Simulation' sheet.
|
| 76 |
Kanban Card Calculator
This calculator evaluates the number of Kanban Cards needed. Also, total number of Kanban Cards are distributed among color codes (green, yellow and red).
|
| 128 |
Median and Quartiles
This template is prepared for calculating median, lower quartile and upper quartile values of a data set. Up to 20 values/scores are available. The values are sorted automatically, the evaluated median and quartiles are displayed on a chart. SpreadsheetWEB version of the template provides all features of the file online.
|
| 120 |
Metric vs U.S. Units
This template is prepared for quick conversion of Metric Units to U.S. units, or vice versa. The conversion can be carried out for weight, length, area and volume units. SpreadsheetWEB version of the template allows you to carry out the conversion online.
|
| 26 |
Mortgage Calculator
This template calculates the repayment amounts for a specified mortgage. Also a chart displaying the payment distribution for principal loan, interest and tax is available.
|
| 27 |
Net Worth Calculator
This template is prepared for individual net worth calculations. The form is flexible in types of assets and liabilities.
|
| 85 |
NPV IRR Calculator
This template is prepared for calculating Net Present Value (NPV) and Internal Rate of Return (IRR) of a single projects, displaying if it is profitable to take. Also a simulation of cash flows over the project horizon is created.
|
| 49 |
Retirement Calculator
This template is prepared for projecting retirement plans. A comparison of gains by principal payments and gains by interest is provided with charts. Also a simulation of the coming 60 years is available.
|
| 166 |
Savings by Cutting Expenses
This template is prepared for observing the long term results of daily savings. Long term savings by a target age that you determine is displayed according to an estimated annual interest rate. SpreadsheetWEB version of the calculator provides all features of the template and it may be placed and used online.
|
| 167 |
Temperature Conversion
This template is prepared for carrying out Celcius-to-Fahrenheit and Fahrenheit-to-Celcius conversions. The conversion is displayed on a chart and a table. SpreadsheetWEB version of the calculator provides all features of the template and it may be placed and used online.
|