Design Spreadsheets

Posted: June 25, 2011 in Design Spreadsheets

Mechanical Design Spreadsheets

These Mechanical Design Spreadsheets are good and simple excel calculation sheets for vessel components designing. The source links are not hidden so that you can explore further. Please don’t forget to read all the sheets in a single workbook.
Here is the list of contents : (Total size 0.643 MB)
296_Material Database ver E4.01.xls
297_Pipe and Shell Design Tool ver E4.01.xls
298_Cone Design Tool ver E4.01.xls
299_Elliptical Head Design Tool ver E4.01.xls
300_F&D Head Design Tool ver E4.01.xls
301_Hemispherical Head Design Tool ver E4.01.xls
302_Nozzle Design Tool ver E4.01.xls
303_Nozzle and Repad Design Tool ver E4.01.xls
326_Cone Layout Tool ver E4.02.xls
COLLAPSE PRESSURE SUPPORT SPACING.XLS
Nozzle Loads WRC 107 ver 1.1.xls
http://ifile.it/yoe491f

Piping Design Spreadsheets

Here is the list of contents : (Total size 5.669 MB)
Flange Rating_(NPS 0.5~24)_V3.0.xls
Flange Rating_Large Diameter_(NPS 26~60)_V1.0.xls
FRP Fittings Guide.xls
IMPERIAL PIPING WEIGHT LOAD CALCULATION WORKBOOK.XLS
METRIC PIPING WEIGHT CALCULATION WORKSHEET.XLS
Pipe P vs T Data.xls
Pipe Size Optimization.xls
Pressure Drop & Flowrate-Karman.xls
Thickness & Weld Branch Calculation-ASME B31.3.xls
TW ASME-Imp.xls
TW Thermo-Kinetics.xls
http://ifile.it/uzx3h51

Process Design Spreadsheets

Here is the list of contents : (Total size 2.813 MB)
Column Design.zip
Condensate Line Sizing.xls
Experienced Based Rules of Chemical Engineering.xls
Filtration.zip
Flare Stack Calculations.xls
KOD Sizing.xls
LINE SIZE & PRESSURE DROP CALCULATION.xls
PRESSURE OF REAL GASES.xls
Reactor Particle Sizing.xls
Scrubber Design.xls
Steam Leak Calculation.xls
Steam Tracing.xls
Thumb Rules for Chemical Engineer.xls
Two Phase Flow.xls
Vapor Pressure of a Liquid Solution.xls
Various Calcs.zip
Velocity of Sound.xls
Volumes & Weights.xls
http://ifile.it/abj6hqf

Drilling Calculations Spreadsheets

Here is the list of contents – a great collection of 40 worksheets among which many worksheets contain multiple sheets : (.rar file size 3.027 MB)
01_General Formulae.xls
02_Drilling Calculation.xls
03_Assortment of Mini Applications.xls
04_Pressure Drops & Others.XLS
05_SRB Hydraulic Programs.xls
06_Hydraulics Worksheet.xls
07_Nowsco Calculation Sheets.xls
08_BASIC MUD REPORTv1.5.xls
09_MudEng2.55.xls
10_Simple Mud Engineerv1.22.xls
11_MUD MIXING.XLS
12_Hydraulic Calculations & Mudpump.xls
13_Spot Heavy Mud.xls
14_Mud Motors, Jets & Surveys.xls
15_Floating Casing.xls
16_Lubricate and Bleed Procedure.xls
17_Maximum Casing Pressure and Pit Gain.xls
18_Critical Rotary Speed.xls
19_Drill String Design.xls
20_Filling the Hole.xls
21_Volumetric Method.xls
22_Well Control.xls
23_Well Control Worksheet-Surface BOP.xls
24_Randy Smith Kill.xls
25_Kill Sheet IWCF.XLW
26_Shell Kill.xls
27_Kill Sheet7.xls
28_Kill Sheet1.xls
29_WELL CONTROL DATA SHEET for DIRECTIONAL WELLS Wt. & Wt. METHOD.xls
30_WELL CONTROL DATA SHEET for DRILLER’S METHOD.xls
31_WELL CONTROL DATA SHEET for VERTICAL WELLS Wt. & Wt. METHOD.xls
32_IDEAL KICK REMOVAL.XLS
33_Well Control.xls
34_Cement Calculations.XLS
35_CASING CEMENTING.xls
36_CEMENT.XLS
37_PRIMARY CEMENTATION.XLS
38_PUMPING RATES FOR CEMENT SPACERS.XLS
39_Buckling & Wellhead Load After Cementing.XLS
40_Squeeze Cementing Job.xls

And here are the links :
http://ifile.it/6fh709q
http://www.4shared.com/file/aC1Dpjgp/Drilling_Calculations_Spreadsh.html

Instrumentation Design Spreadsheets

CVCALCS.xls
CVGAS.xls
CVOIL.xls
Instt Air Consumption.xls
mA to PLC Raw Count Conversion.xls
Mercer_Pilot Valve Sizing_v5.1.xls
Mercer_Spring Valve Sizing_v4.99.xls
Orifice Calculation.xls
Ross_Valve Sizing.xls
http://ifile.it/cgwx16h

Civil Design Spreadsheets

Bar Schedule 8666.xlt
Daniel-Conventional Slabs.xls
Daniel-Pile Caps.xls
Daniel-Tank Footing.xls
Daniel-Wind-ASCE7-05.xls
Daniel-Wind-IR16-7.xls
Steel Beam.xls
Tank Size Calculator.xls
Wind Design.xls
http://ifile.it/3b6lrsn

Electrical Design Spreadsheets

Here is the list of contents : (Total size 0.438 MB)
01_Basic Electrical Calculations.xls
02_Voltage Drop Calculator.xls
03_Capacitor kVAR Calculator.xls
04_T310-16 Conductor Size Calculation_Newton.xls
05_Short-Circuit Calculator_v7.1.xls
06_3-Phase Calculator.xls
07_Touch Potential 2-Wire Circuit.xls
08_Touch Potential 3-Wire Circuit.xls
09_Transmission Line Calculator.xls
10_NFPA 70E_ARC Calculator.xls
11_Residential Load Calculation.xls
12_Household Power Consumption.xls
13_Yacht Load Calculation.xls
14_PCB Thermal Copper Area 3.xls
15_Layer Stack Planning Calculator.xls
16_Trace Width Based on Power.xls
http://ifile.it/hc8mlob

About these ads
Comments
  1. asterix says:

    electrical design spreadsheet cannot be downloaded please upload again

  2. Suzi Saleh says:

    That good but How can i use it

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s