N2 Calculation Spreadsheets: Worksheet for calculating the diameter of compressed air pipes

Worksheet N2: Worksheet approximates diameter for compressed air pipes.
The worksheet considers the following input variables:

permissible load loss
Tube length value
Standard free air discharge value
Effective line working pressure value
Temperature of the compressed air that will flow in the tube
Approximate value of alpha coefficient
Air specific weight value

N2 Calculation Spreadsheets: Thermal load calculation – Refrigeration and Air Conditioning

Worksheet N2: Worksheet calculates ambient thermal load for refrigeration and air conditioning selection applications.
Spreadsheet considers the position of the windows, the characteristics of the construction, the ilumination, the equipment, the activity and ventilation.
Check out the details in the attached image..

N2 Calculation Spreadsheets: Life line – AA Steel Cable 6 x19

Worksheet N2: Calculates the parameters for the simple use of AA 6 steel cables×19 CIMAF of different gauges in lifelines.
Calculate cable strain, elastic deformation, Stretching, Length, Load, max number. of people and cable clipping.

N2 Calculation Spreadsheets: Calculation of Weight and Volume of Profiles and Beams

Worksheet N2: Spreadsheet calculates weight and volume for the following metal profiles:
-Plates
-U and I profile
-Round Profile, Corners, stiffened profiles
-Round and Rectangular Tubes

N2 Calculation Spreadsheets: Lifting eye calculation

Worksheet N2: Worksheet calculates complete eye sizing for elevation, considering applied load, the hole diameter and the load direction.
Among the variables calculated are the thickness of the eyelet plate, backing plate thickness, eye weld bead, eye height and length.

N2 Calculation Spreadsheets: Axis Tolerances Table / Open it

Worksheet N2: Worksheet provides the respective tolerances in microns for the entered shaft and hole diameters.
Input information: Shaft Diameter / Open it, removal (A,B,H,c,h,etc), Quality (7,10,11,etc)

N2 Calculation Spreadsheets: Calculation of ISO Tolerances

Worksheet N2: Worksheet provides guidelines for selecting and applying dimensional tolerances.
Displays by selecting the nomenclature (H7, h6, etc) the dimensional limits for the various diameters.

N2 Calculation Spreadsheets: Calculation of Coil Springs

Worksheet N2: Worksheet provides calculation for coil spring application.
Input data:
-Wire Diameter
-External diameter
-active turns
-Modulus of elasticity

The spreadsheet reports the maximum effort, Total length, wire length and other information for design and application.

N2 Calculation Spreadsheets: Sheet for calculating time and cutting advance in Band Saw

Worksheet N2: According to the geometry and material parameters, the spreadsheet calculates:
-Calculates the cutting time of the part.
-Calculate lead time.

scroll to top