Friday, September 27, 2013
Planetary Motion
This template is prepared for
calculating the planetary motion variables using Kepler's Third Law.
SpreadsheetWEB version provides all features of the template online.
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.
Universal Gravitation and Escape Velocity
Universal Gravitation and Escape
Velocity
This template is prepared for calculating the force of gravity,
acceralation due to gravity and escape velocity for a spesific central
object using Newton's universal gravitation law. There are two charts
showing the behaviours of force of gravity and escape velocity with
respect to position. SpreadsheetWEB version provides all features of
the template online.
Projectile Motion
This template is prepared for
simulating and comparing projectile motion with and without air
resistance.
Euler Method in Falling Velocity
This template is prepared for
simulating the success of Euler approximation for the velocity in free
fall. Parameters like the mass of the object play a very important role
in the success of the method. Error of the method with different
parameters can be observed.
Structural Beam Calc (Between Support and Load)
This template is prepared for
understanding the deflection characteristics of a structural beam under a
specific loading conditions. This template aids in stress and
deflection calculations for structural cantilevered beam bending with
load at location between support and load. SpreadsheetWEB version of the
template allows to carry out the calculations online.
Gravitational Acceleration
This template is prepared for
calculating the gravitational acceleration, g, for given altitude and
latitudes. Also a latitude-gravitational acceleration chart is provided
to understand the behabiour of g with respect to increasing latitudes.
SpreadsheetWEB version provides all features of the template online.
Section Properties (Equilateral Triangle)
For the analysis of bending and
torsion, certain relations for the second-area moments, commonly
referred to as moments of inertia, are very important. This application
is created in order to determine
moments of inertia of equilateral triangle as well as other properties
of the structural section. SpreadsheetWEB version of the template
provides all features of the template online.
Structural Beam Calc (with End Overhanging Supports and a Single Load)
This template is prepared for
understanding the deflection characteristics of a structural beam under a
specific loading conditions. This template aids in stress and
deflection calculations for structural beam bending with end overhanging
supports and a single load. SpreadsheetWEB version of the template
allows to carry out the calculations online.
Section Properties (Hollow Ellipse)
For the analysis of bending and
torsion, certain relations for the second-area moments, commonly
referred to as moments of inertia, are very important. This application
is created in order to determine
moments of inertia of hollow ellipse as well as other properties of the
structural section. SpreadsheetWEB version of the template provides all
features of the template online.
Structural Beam Calc (Cantilevered Beam with Load at Location)
This template is prepared for
understanding the deflection characteristics of a structural beam under a
specific loading conditions. This template aids in stress and
deflection calculations for cantilevered beam with one load applied at
the end. SpreadsheetWEB version of the template allows to carry out the
calculations online.
Structural Beam Calc (Cantilevered Beam with Uniform Load)
This template is prepared for
understanding the deflection characteristics of a structural beam under a
specific loading conditions. This template aids in stress and
deflection calculations for cantilereved beam with uniform load.
SpreadsheetWEB version of the template allows to carry out the
calculations online.
Section Properties (Channel Section)
For the analysis of bending and
torsion, certain relations for the second-area moments, commonly
referred to as moments of inertia, are very important. This application
is created in order to determine
moments of inertia of channel section as well as other properties of the
structural section. SpreadsheetWEB version of the template provides all
features of the template online.
Section Properties (Equal-Legged Angle)
For the analysis of bending and
torsion, certain relations for the second-area moments, commonly
referred to as moments of inertia, are very important. This application
is created in order to determine
moments of inertia of equal-legged angle as well as other properties of
the structural section. SpreadsheetWEB version of the template provides
all features of the template online.
Section Properties (Hollow Circle)
For the analysis of bending and
torsion, certain relations for the second-area moments, commonly
referred to as moments of inertia, are very important. This application
is created in order to determine
moments of inertia of hollow circle as well as other properties of the
structural section. SpreadsheetWEB version of the template provides all
features of the template online.
Structural Beam Calc (Guided on One End with Uniform Load)
This template is prepared for
understanding the deflection characteristics of a structural beam under a
specific loading conditions. This template aids in stress and
deflection calculations for structural beam bending free and guided on
one end, rigid one with uniform load. SpreadsheetWEB version of the
template allows to carry out the calculations online.
Section Properties (Wide-Flange Beam with Equal Flangers)
For the analysis of bending and
torsion, certain relations for the second-area moments, commonly
referred to as moments of inertia, are very important. This application
is created in order to determine
moments of inertia of wide-flange beam with equal flangers as well as
other properties of the structural section. SpreadsheetWEB version of
the template provides all features of the template online.
Structural Beam Calc (Guided on One End with Single Load)
This template is prepared for
understanding the deflection characteristics of a structural beam under a
specific loading conditions. This template aids in stress and
deflection calculations for structural beam bending free and guided on
one end, rigid one end with single load. SpreadsheetWEB version of the
template allows to carry out the calculations online.
Gamma Distribution
This template is prepared for
calculating gamma probabilities easily. Probability density function and
cumulative distribution are plotted on charts with different shape and
scale paramters. SpreadsheetWEB version provides all features of the
template online.
Standard Normal Distribution
This template is prepared for
calculating standard normal probabilities quickly. 4 types of results
corresponding different areas are given simultaneously.
Distribution Generator
This template is prepared for
generating Rectengular, Right-Skewed, Left-Skewed and Normal
distributons.
Hypothesis Testing
This template is prepared for
testing the validity of mean and variance values (hypothesis) using a
sample. Strength of the test is not fixed and left to your choice.
SpreadsheetWEB version allows you to carry out the calculations online.
World GDP Dashboard
This template is another example of
building dashboards in Excel. It features various charts and sparklines.
It uses data from World Bank on global GDP data. It is interactive in a
way that user can select from a list of data indicators and countries
to update the charts.
K-Means Algorithm
K-Means algorithm is one of the
most-commonly used clustering algorithms. Clustering algorithms try to
group similar data points (may have various meainings) with respect to a
selected criteria. These algorithms are widely used in data mining,
pattern recognition, image analysis, supply chain management, etc. Like
all clustering algorithms, K-Means algorithm tries to assign data points
into a determined number of clusters, K. The algorithm assumes that
each cluster has a center (centroid) and aims to minimize the sum of
distances of data points from the centroids of clusters that the data
points are assigned to. This algorithm is a fast algorithm that
converges rapidly with good solutions. Random initialization prevents
the algorithm from being stuck to a bad solution. This template runs the
algorithm with VBA code, therefore macros need to be enabled. The
algorithm may be run either once at a time or each step may be observed
in order to observe the convergence process of the alg.
Beta Distribution
This template is prepared for
understanding and simulating beta distributions. An introduction sheet
briefly describes the distribution while on another sheet, Beta
distribution of entered parameters may be created. All properties of the
distribution such as moments and shape are displayed. SpreadsheetWEB
version provides all features of the template online.
Double Exponential Smoothing - Multiple Data
An upgraded version of Double
Exponential Smoothing application.
New Features:
- Ability to choose data by combobox. You do not need delete and
re-write data again and again.
- Get a report for all products forecasted values by clicking only one
button.
When a trend exists, the forecasting technique must consider the trend
as well as the series average ignoring the trend will cause the forecast
to always be below (with an increasing trend) or above (with a
decreasing trend) actual demand. Double exponential smoothing smooths
(averages) both the series average and the trend. This template is
prepared for carrying out DES forecast depending on up to 60 data
points. SpreadsheetWEB version of the template provides all features
online.
Binomial Distribution
This template is prepared for
calculating binomial probabilities. Characteristics of the distribution
with the entered parameters are displayed on a table. Moments may be
calculating using the moment-generating function. Also, probability mass
function and cumulative distribution function are displayed on charts.
SpreadsheetWEB version provides all features of the template online.
Earned Value Analysis
You can track and analyze your
project's condition by various indicators with Earned Value Analysis
application.
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.
Polar Coordinates
This template is prepared for
understanding the system of polar coordinates. The point determined by
the system parameters, angle and radius, are displayed on a x-y chart.
The chart aids in understanding the relationship of the system of polar
coordinates with the system of cartesian coordinates.
Goodness of Fit Tester
Goodness-of-Fit Tester helps you
decide if an observed sample is significantly different than expected
proportions. You can test by this spreadsheet ratios of defectivity,
productivity, probabilities and so on. SpreadsheetWEB version provides
all features of the template online.
Test of Independence
Test of Independence helps you check
the independence of variables on a certain observation. This template
is prepared for checking the relations of 2 subjects each having 2
types. Level is significance is determined by the user. SpreadsheetWEB
version provides all features of the template online.
Simple Linear Regression
Linear regression attempts to model
the relationship between two variables by fitting a linear equation to
observed data. One variable is considered to be an explanatory variable,
and the other is considered to be a dependent variable. This template
is prepared fopr carrying out regression over a data of 60 periods.
However, using this data, you may also forecast the data of a further
period. SpreadsheetWEB version of the template provides all features
online.
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.
Complex Roots
This template is prepared to provide
a comprehension of the roots of complex numbers using a graph
displaying the real and imaginary parts. Also, a quick conversion of
standard form to polar form is carried out. The template can be used for
evaluating up to 10 roots of complex numbers. SpreadsheetWEB version of
the template allows you to use all features of the template online.
Standard Normal Distribution
This template is prepared for
calculating standard normal probabilities quickly. 4 types of results
corresponding different areas are given simultaneously.
Moving Averages
This template is prepared for
evaluating the moving averages of a data up to 30 items. You may use the
moving averages of any number of items that you may define. Also
cumulative moving averages can be calculated. The original data and
moving averages may be compared with a chart. SpreadsheetWEB version of
the template allows you to carry out the calculations online.
Derivatives
This template is prepared for
understanding the behaviour of first and second order derivatives with
varying paramaters. The analysis is carried out for a third order
polynomial. SpreadsheetWEB version provides all features of the template
online.
Shortest Path Problem Solver
Shortest Path problems are one of the base operations of the network
problems. Problem is to reach a target location from a beginning
location. There are generally numerous available paths to achieve this
goal. The objective of the Shortest Path problem is to achieve this goal
with the minimum distance traveled. One way to solve the problem is
dynamic programming. This template uses dynamic programming techniques
to solve up to 16-node shortest path problem. SpreadsheetWEB version of
the template carries the dynamic program onto the web and solves the
problem online.
Basics of Logarithmic Functions
This template is prepared for understanding the behaviour of logarithmic
functions. Behaviour of logarithmic functions is compared with the
natural logarithm (ln) by the aid of a chart. SpreadsheetWEB version
provides all features of the template online.
Cartesian Coordinates
This template is prepared for understanding the basics of the system of
cartesian coordinates. Defined point and its projections on the x and y
axis are displayed on a chart.
Inverse Transpose Matrix Calculator
This template is prepared for calculating the determinant, inverse and transpose of square matrices with dimensions up to 10x10.
Base System Conversion
This template provides calculations for base system conversions. The
conversion may be carried out between any base system up to decimal
(10). Further conversions need some symbols in addition to 10 numbers,
and are provided in this template.
Basics of Exponential Functions
This template is prepared for understanding the behaviour of natural
exponential function with the aid of a graph. SpreadsheetWEB version of
the template provides all features of the template online.
http://spreadsheetzone.com/265/Basics-of-Exponential-Function.html
Trigonometric Functions
This template is prepared for providing the basic understanding of main
trigonometric functions; sin, cos, tan and cot. The values of the
functions are calculated with the aid of an acute angled triangle.
SpreadsheetWEB version provides all features of the template online.
Ideal Gas Law
This template is prepared for calculating the unknown values (pressure,
volume or temparature) using the 3 gas laws: Boyle's Law, Combined Gas
Law and Charles' Law. Charts of 3 laws are displayed. SpreadsheetWEB
version allows to use the template online.
Reaction Energy Calculator
A tool for calculating energy absorbed/released on chemical reactions.
You do not need know bond energy for all molecules, just select it with
combobox and it will be written automatically. You can if the reaction
is Exothermic or Endothermic by chart.
Heat of Vaporization
A great tool for learning, comparing and understanding boiling points
and vaporization energy of different liquid types at different heights.
Periodic Table
This is an informative Periodic Table. Atomic numbers, symbols and
atomic weights of the elements are displayed on the table as usual. In
addition, detailed information (specific propertioes, areas of use,
etc.) about the selected element is displayed over the table. Melting
points, boiling points and liquid ranges of all elements in the table
are displayed on a temperature-atomic number chart, in which again the
selected element is highlighted. For the ease of dynamically using the
table and updating the chart, the template uses VBA code. Hence, macros
need to be enabled to use the Periodic Table.
Subscribe to:
Comments (Atom)