1TEAM Smart Sheets

What: 1TEAM Smart Sheets a  software company that develops helpful  templates for the science, technology, engineering and mathematics (STEM) community which includes professionals, researchers, consultants, professors, students, instructors, teachers, engineers, and technologists.

Why: to ease, increase accuracy, reduce time, to study and understand the use an application of the formulas, to understand the relationships of variables, easily performed trial and error calculations,

Where: these templates can be used in schools, colleges, universities, consulting engineering offices, laboratories, construction sites, design houses, etc.

When: 1TEAM Smart Sheets was developed after 30 years of practical engineering experience. Use the template when performing the necessary application – easy to use, reasonable accuracy.

Who: 1TEAM Smart Sheets templates were developed by professionals practicing in their respective fields

How: 1TEAM Smart Sheets can be easily downloaded and used in laptops, desktops, touchpads, and even mobile devices such as smart phones.  . The spreadsheets are relatively easy to use that even elementary or high school students can use the templates. Combined with science, technology, engineering and mathematics tables and charts pre-loaded into spreadsheets, looking and searching for the appropriate values is much easier and requires less time

These are provided as a time saving tool. Please verify your data prior to use.

  1. Science, Technology, Engineering, and Mathematics (STEM) refers to the academic disciplines of science, technology, engineering, and mathematics. The term is typically used when addressing education policy and curriculum choices in schools to improve competitiveness in science and technology development. It has implications for workforce development, national security concerns and immigration policy.
  2. Science is a systematic enterprise that creates, builds and organizes knowledge in the form of testable explanations and predictions about the universe. Contemporary science is typically subdivided into the natural sciences which study the material world, the social sciences which study people and societies, and the formal sciences like mathematics. The formal sciences are often excluded as they do not depend on empirical observations. Disciplines which use science like engineering and medicine may also be considered to be applied sciences.
  3. Technology is the collection of techniques, skills, methods and processes used in the production of goods or services or in the accomplishment of objectives, such as scientific investigation. Technology can be the knowledge of techniques, processes, etc. or it can be embedded in machines, computers, devices and factories, which can be operated by individuals without detailed knowledge of the workings of such things.
  4. Engineering is the application of mathematics, empirical evidence and scientific, economic, social, and practical knowledge in order to invent, innovate, design, build, maintain, research, and improve structures, machines, tools, systems, components, materials, and processes. The discipline of engineering is extremely broad, and encompasses a range of more specialized fields of engineering, each with a more specific emphasis on particular areas of applied science, technology and types of application.
  5. Engineering Calculations
    1. Electrical Engineering: Electrical engineering is a field of engineering that generally deals with the study and application of electricity, electronics, and electromagnetism. This field first became an identifiable occupation in the latter half of the 19th century after commercialization of the electric telegraph, the telephone, electric power distribution/use, broadcasting, recording media. Electrical engineering has now subdivided into a wide range of subfields including electronics, digital computers, power engineering, telecommunications, control systems, radio-frequency engineering, signal processing, instrumentation, and microelectronics.
    2. Electrical Engineering Calculations
      1. DC Electricity: Direct current (DC) is the unidirectional flow of electric charge. Direct current is produced by sources such as batteries, power supplies, thermocouples, solar cells, or dynamos. Direct current may flow in a conductor such as a wire, but can also flow through semiconductors, insulators, or even through a vacuum as in electron or ion beams. Direct current may be obtained from an alternating current supply by use of a rectifier, which contains electronic elements (usually) or electromechanical elements (historically) that allow current to flow only in one direction. Direct current may be converted into alternating current with an inverter or a motor-generator set. Direct current is used to charge batteries and as power supply for electronic systems. Very large quantities of direct-current power are used in production of aluminum and other electrochemical It is also used for some railways, especially in urban areas. High-voltage direct current is used to transmit large amounts of power from remote generation sites or to interconnect alternating current power grids.
      2. DC Electricity Calculations
        1. Flux Density
        2. Electric Field
        3. Coulomb’s Law
        4. Work
        5. System Potential Energy
        6. Uniform Electric Field
        7. Flux Density
        8. Magnetic Field
        9. Magnetic Field (Wire Carrying Current)
        10. Faraday Law
        11. Ohm’s Law
        12. Resistors In Series And Parallel
        13. Resistance (Resistivity)
        14. Resistance (Change In Temperature)
        15. Power In A Resistive Circuit
        16. Decibels
        17. Kirchoff’s Law (Current)
        18. Kirchoff’s Law (Voltage)
        19. Belt That The White Conversion
        20. Wheatstone Conversion
        21. RC Transient Response (RC/Energizing)
        22. RC Transient Response (Discharging)
        23. LC Transient Response (Energizing)
        24. LC Transient Response (Discharge)
        25. LC Transient Response (Energizing)
    3. AC Electricity: Alternating current (AC), is an electric current in which the flow of electric charge periodically reverses direction. AC is the form in which electric power is delivered to businesses and residences. The usual waveform of alternating current in most electric power circuits is a sine wave.
    4. AC Electricity Calculations
      1. Time, Period And Frequency
      2. Average Efficiency Values
      3. Sine Cosine Conversion
      4. Voltage
      5. Power
      6. Average Power
      7. Capacitance
      8. Reactance
      9. Power
      10. Capacitor (Series)
      11. Capacitor (Parallel)
      12. Inductors (Reactance)
      13. Inductors (Power)
      14. Inductors (Series)
      15. Inductors (Parallel)
      16. Resonance
      17. Resonance (Series)
      18. Resonance (Parallel)
      19. Simple Transformers (Ratio)
      20. Real
      21. Reactance
      22. Apparent And Power Factor
      23. Power Factor Correction
      24. Synchronous Machines (Speed)
      25. Synchronous Machines (Induction/Slip)
      26. Delta
      27. Wye
      28. Equivalent Loads
    5. Nuclear Engineering: Nuclear engineering is the branch of engineering concerned with the application of the breakdown (fission) as well as the fusion of atomic nuclei and/or the application of other sub-atomic physics, based on the principles of nuclear physics. In the sub-field of nuclear fission, it particularly includes the interaction and maintenance of systems and components like nuclear reactors, nuclear power plants, and/or nuclear weapons. The field also includes the study of medical and other applications of (generally ionizing) radiation, nuclear safety, heat/thermodynamics transport, nuclear fuel and/or other related technology (e.g., radioactive waste disposal), and the problems of nuclear proliferation.
    6. Nuclear Engineering Calculations
      1. Binding Energy
      2. Rate Of Decay
      3. Number Of Atoms
      4. Cross-Section And Probabilities
      5. Interaction Rates
    7. Mechanical Engineering: Mechanical engineering is the discipline that applies the principles of engineering, physics, and materials science for the design, analysis, manufacturing, and maintenance of mechanical systems. It is the branch of engineering that involves the design, production, and operation of machinery. It is one of the oldest and broadest of the engineering disciplines. Mechanical engineering emerged as a field during the industrial revolution in Europe in the 18th century; however, its development can be traced back several thousand years around the world. The field has continually evolved to incorporate advancements in technology, and mechanical engineers today are pursuing developments in such fields as composites, mechatronics, and nanotechnology.
    8. Mechanical Engineering Calculations
      1. Fluid Statics And Dynamics
        1. Hydrostatic Pressure
        2. Pressure On Submerged Plane Surfaces
        3. Manometer
        4. Speed Of Sound In The Fluid
        5. Continuity Equation
        6. Open Channel Flow
        7. Bernoulli Equation
        8. Conversion Of Energy
        9. Reynold’s Number
        10. Darcy’s Friction Loss In Minor Loss
        11. Pump Terms
        12. Hydraulic Grade Line
        13. Torricelli’s Equation – Discharge
        14. Venturi Meter
        15. Orifice Plate
        16. Impulse – Momentum
        17. Lift And Drag
        18. Similarity
        19. Static Pitot Tube
      2. Hydraulic Machines
        1. Net Positive Suction Head
        2. Bumping Power (Head Added)
        3. Hydraulic Horsepower
        4. Specific Speed
        5. Pump Affinity Law
        6. Pump Similarity Laws
      3. Fans And Ductwork
        1. Air Horsepower
        2. System Loss Curve
        3. Fan Laws
        4. Equivalent Diameter Of Rectangular Duct
        5. Minor Duct Losses
        6. Windstream Power Content
      4.  Thermodynamics
        1. Mathematical Formula Of The First Law (Closed System)
        2. For Steady Open Flow Systems
        3. Ideal Gas Equation Of State
        4. Compressed Gas Equation Of State
        5. Ideal Gas Process Law
        6. Thermodynamic Relationships Of Any Process (Ideal Gases)
        7. Sensible Heat
        8. Quality Of A Liquid Vapor Mixture
        9. Properties Of A Liquid Vapor Mixture
        10. Constant Pressure (Closed System)
        11. Constant Volume (Closed System)
        12. Constant Temperature (Closed System)
        13. Polytropic Process (Closed System)
      5. Vapor, Combustion And Refrigeration Cycles
        1. Thermal Efficiency Of An Entire Cycle
        2. Carnot Cycle Efficiency
        3. Isotropic Efficiency Of A Pump
        4. Isotropic Efficiency Of A Turbine
        5. Rankin Cycle With Super Heating
        6. The Plan Formula
        7. Flow-Through Nozzles
        8. Coefficient Of Performance
        9. Carnot Cycle Coefficient Of Performance
      6. Compressible Fluid Dynamics
        1. General Flow Equation
        2. Speed Of Sound
        3. Mach Number
        4. Isotropic Flow Parameters
        5. Critical Pressure Ratio
        6. Rocket Performance
        7. Steam Flow (Nozzle Flow)
      7.  Combustion
        1. Heat Of Combustion
        2. Flue Gas Analysis
      8. Heat Transfer
        1. Thermal Conductivity
        2. Conduction Through Slabs
        3. Conduction Through Sandwiches
        4. Coefficient Of Heat Transfer Conductivity
        5. Logarithmic Mean Area
        6. Hollow Cylinder
        7. Insulated Pipe
        8. Critical Thickness Of Insulation
        9. Newtons Law Of Cooling
        10. Biot Number
        11. Thermal Diffusivity
        12. Fourier Number
        13. Transient Heat Flow
        14. Reynold’s Number
        15. Prandtl Number
        16. Grashoff Number
        17. Nusselt Equation For Forced Convection In Pipes
        18. Natural Convection
        19. Logarithmic Mean Temperature
        20. Heat Exchangers
        21. Stefan Boltzmann Constant
        22. Radiation From A Gray Body
        23. Net Radiation Transfer Between Two Gray Bodies
      9. Heating Ventilation And Air-Conditioning
        1. Heat Losses Through Walls
        2. Infiltration Heat Losses
        3. Heat To Warm Moisture
        4. Heat To Warm Incoming Air
        5. They Compete To Add Moisture
        6. Heat Contributed By Light And Machines
        7. Degree Days
        8. Annual Fuel Consumption
        9. Air-Conditioning Process
        10. Sensible Heating
        11. Cooling And Coil Dehumidification
        12. Cooling By A Diabetic Saturation (Evaporation)
        13. Instantaneous Heat Gain Through Walls
        14. Heat Gain Through Windows
        15. Heat Gain From Lights And Equipment
        16. Energy Efficiency Ratio (Eer)
        17. moisture load calculations
        18. heating load calculations
        19. cooling load calculations
      10.  Statics
        1. Resultants
        2. Couples
        3. Forces In Vector Form
        4. Components Of Inclined Members
        5. Moments
        6. Determinate Truss
        7. Catenary Cables
        8. Friction
        9.  Centroids
          1. Centroid Of A Rectangle
          2. Centroid Of A Triangle
          3. Centroid Of A Quarter Circle
          4. Centroid Of A Half Circle
          5. Centroid Of A Composite Shape
        10. Moments Of Inertia
          1. Moment Of Inertia Of A Rectangle
          2. Moment Of Inertia Of A Circle
          3. Radius Of Gyration
        11. Polar Moments Of Inertia
          1. Polar Moment Of Inertia Of A Circle
          2. Polar Moment Of Inertia Of A Rectangle
          3. Polar Moment Of Inertia Of A Hollow
          4. Polar Axis Theorem
        12. Mechanics Of Materials
          1. Stress
          2. Strain
          3. Hooke’s Law
          4. Elongation Under Normal Stress
          5. Values Of E And G(Steel)
          6. Values Of E And G(Aluminum)
          7. Poisson’s Ratio
          8. Thermal Stress And Strain
          9. Normal Stress In The Beam
          10. Shear Stress In The Beam
          11. Torsional Stress And Strain In The Shaft
          12. Eccentric Normal Stress
          13. Combined Stress
          14. Allowable Stress
          15. Single Beam Deflection
          16. Slender Columns In Compression
          17. Springs
          18. Thin-Walled Cylinders
          19. Shaft
          20. Thin-Walled Cylinders
        13.  Dynamics
          1. The Second Law
          2. Law Of Universal Gravitation
          3. Uniform Acceleration Formula’s
          4. Projectile Motion
          5. Work And Energy
          6. Work And Energy Principle
          7. Horsepower Required To Maintain Velocity
          8. Rotational Moment Of Inertia
          9. Relation Between The Rotational And Linear Motion
          10. Centrifugal Force
          11. Highway Banking
          12. Parallel Axis Theorem
          13. Radius Of Gyration
          14. Impulse Momentum Principle
          15. Impact
          16. Conservation Of Momentum In A Collision
          17. Undamped, Free Vibrations (Simple Harmonic Motion)
          18. Shaft Vibration (Critical Speeds)
          19. Shaft Vibration (Critical Speeds) Dunkerly’s Approximation
          20. Damped, Free Vibrations
          21. Damped, Forced Vibrations
          22. Vibration Isolation And Control
        14. Noise Control
          1. Sound Pressure Level
          2. Sound Power Level
          3. Noise Reduction
          4. Insertion Loss
          5. Addition And Subtraction Of Decibels
          6. Room Constant
          7. Noise Dose
        15.  Combustion
          1. Percent Excess Air While Burning Coal
          2. Combustion of Coal Fuel in a Furnace
          3. Combustion of Fuel Oil in a Furnace
          4. Combustion of Natural Fuel in a Furnace
          5. Combustion of Wood Fuel in a Furnace
          6. Final Combustion Products Temperature Estimate
        16.  Hydraulics
          1. Similarity or Affinity Laws for Centrifugal Pumps
          2. Similarity or Affinity Laws in Centrifugal Pumps Selection
          3. Minimum Safe Flow for a Centrifugal Pump
          4. Pipe-Wall Thickness And Schedule Number
          5. Pipe Wall Thickness Determination by Piping Code Formula
          6. Equivalent Length of a Complex Series Pipeline
          7. Equivalent Length of a Parallel Piping System
          8. Maximum Allowable Height for a Liquid Siphon
          9. Water Hammer Effect in Liquid Pipelines
        17.  Mathematics
          1. Triangle Properties
          2. Square / Rectangle Properties
          3. Parallelogram, Rhomboid & Rhombus Properties
          4. Trapezoid, Trapezium Properties
          5. Regular Polygon Properties
          6. Circle, Hollow Circle, Annulus Properties
          7. Sectors & Segments Of A Circle
          8. Ellipse Properties
          9. Parabola Properties
          10. Pyramid Or Cone Properties
          11. Frustum Of Pyramid Or Cone
          12. Cylinder Properties
          13. Frustum Of Cylinder
          14. Sphere Properties
          15. Sectors & Segments Of A Sphere
          16. Torus Properties
        18. plumbing system sizing
          1. Minimum Number of Fixtures Required
          2. PIPE & FITTING STANDARDS
          3. Minimum Fixture Connection Sizes & Load Values
          4. PIPE HANGER SPACING
          5. Storm Tables
          6. Storm Calculations
          7. Storm Sizing Input
          8. Storm Sizing Calculator
          9. Storm Sizing Output
          10. Water Supply Fixture Unit Calculation
          11. Water Supply Fixture Unit Calculation
          12. Water Supply Sizing Criteria
          13. Cold Water Pipe Sizing
          14. Revised Cold Water Pipe Sizing
          15. Hot Water Pipe Sizing
          16. Total Water Pipe Sizing
          17. CW Pressure Drop
          18. Revised CW Pressure Drop
          19. Water Heater Sizing
          20. Water Heater Sizing (MDA Method)
          21. Expansion Tank Sizing
          22. Recirculation Calculations
          23. Water Service Pressure Drop calculation
          24. Water Service Calculations
          25. High Rise Pressure Calculation
          26. CW Bill Of Materials
          27. Water Meter Dimensions
          28. PRV Calculations
          29. Chilled Drinking Water Storage Temperature
          30. Cross Connection Control Application
          31. Cross Connection Control Application Specifications
          32. Water Supply Fixture Units
          33. Drainage Fixture Units
          34. Pipe drainage Capacity
          35. Sanitary Drainage Sizing
          36. Vent Pipe Sizing
          37. Storm Sizing Criteria
          38. Storm Sizing Tables
          39. Storm Pipe Sizing
          40. AC Drains Pipe Sizing
          41. Drainage Temperature Tempering
        19.  Piping
          1. Reacting Forces And Bending Stress In Single-Plane
          2. Reacting Forces And Bending Stress In A Two-Plane Pipe Bend
          3. Reacting Forces And Bending Stress In A Three-Plane Pipe Bend
          4. Anchor Forces, Stress, And Deflection Of Bends
          5. Pipe-Wall Thickness And Schedule Number
          6. Pipe Wall Thickness Determination By Piping Code Formula
        20.  Pipe
          1. Pipe & Tube Data
          2. Piping Systems Material Specifications
          3. Pipe, Tube, Accessories Fluid Volume, Weight & Hangers
          4. Pipe, Fittings & Accessories Equivalent Length
          5. Expansion Tank Size Calculation
          6. Horizontal & Vertical Pipe Supports From Hvac Eq Rules Of Thumb
          7. Pipe Spacing On Racks From Hvac Eq. Rules Of Thumb Page 209
          8. Pipe Expansion / Contraction Loops, Anchors & Forces
          9. Valve Selection Guide From Piping Guide
          10. Pipe Flow Friction Calculations (Hazen Williams)
          11. Pipe Flow Friction Calculations ()
          12. Channel Flow (Manning Formula)
          13. Pipe Heat Loss / Gain Calculation
          14. Pipe Material Compatibility
          15. Metric Size
          16. Pump Selection Guide From Piping Guide
          17. Pipe Tube Data
          18. Friction Factors
          19. Imperial To Metric Size Equivalent
          20. Drainage Pipe Sizing
          21. Pipe Material Compatibility
          22. Piping Systems Material Specifications
          23. Corrugated Steel Pipe
          24. Clay Pipe
          25. Reinforced Concrete Pipe
          26. Plastic Pipe Derating
          27. Pipe Material Weights & Volume
          28. Pipe Expansion Loops
          29. Valve & Fitting Loss Working Copy
          30. Valve & Fitting Loss Final
          31. Sizing Criteria Working Copy
          32. Pipe Heat Loss
          33. Pipe Size
          34. Brass Pipe
          35. Pipe Hanger Recommendations
        21.  Structural
          1. Design Of A Continuous Beam
          2. Design Of A Single Beam With Point & Distributed Loads
          3. Capacity Of A Built-Up Column
          4. Capacity Of A Double-Angle Star Strut
        22.  Financial
          1. project budget and fees
          2. employee and costs
          3. timesheet summary (hours)
          4. timesheet summary (costs)
          5. timesheet summary (revenue)
      11. Calculation Data
        1. Chemical Element Properties
        2. Solid Elements Thermal Properties
        3. Solid Inorganic Compounds Thermal Properties
        4. Solid Organic Compounds Thermal Properties
        5. Solids Thermal Expansion Coefficients (0°C In T°C)
        6. Alloys Melting Points
        7. Miscellaneous Solids Melting Points
        8. Salts For Salt Baths Melting Points
        9. solid elements specific heat
        10. organic compounds specific heats
        11. alloys specific heats
        12. solid inorganic compounds specific heats
        13. miscellaneous solid substances specific heats
        14. food specific heats
        15. metals thermal conductivities
        16. alloys thermal conductivities
        17. building materials thermal conductivities
        18. miscellaneous solids thermal conductivities
        19. insulated materials thermal conductivities
        20. fire and ceramic bricks thermal conductivities
        21. Burnt Kleselguhr (Distomtomous Earth) thermal conductivities
        22. lamp black thermal conductivities
        23. metal surfaces emissivities
        24. non metal surfaces emissivities
        25. paints and coatings emissivities
        26. solid fuels heating values
        27. liquids thermal properties
        28. gases critical constants
        29. liquids coefficients of cubical thermal expansion
        30. liquids specific heats
        31. water specific heats