× AASHTO Type IV Girder Section Properties Design Loads - Dead Load - CSA S6-14 Stresses Aashto Type IV Girder RISK Board Game Analysis Sieve of Eratosthenes Excel Compund Interest Calculator Excel Shear Design CSA S6-14 Shear Design AASHTO 2014-17 Shear Design CSA S6-66 Go Back Go Back to Home Page
☰

EXCEL


Excel file used to calculate the metric section properties of AASHTO Type IV girder. Calculated properties are the following:

  • Height
  • Gross cross-sectional area
  • Distance from the top of cross-section to the centroid (c top)
  • Distance from the bottom of cross-section to the centroid (c bottom)
  • Area moment of inertia
  • Bottom section modulus
  • Top section modulus


    • Download

    Excel file used to calculate the unfactored moment and shear forces due to the self-weight of an AASHTO Type IV girder, deck and biteminous wearing surfaces. The thickness of biteminous wearing surfaces is taken as 65 mm, deck is taken as 200 mm. Weight of the barrier walls is ignored. The calculations are based on the values given in CSA S6-14 rev. 17.



    Download

    This Excel file was used to calculate the initial and service stresses experienced by an AASHTO Type IV girder. The girder is divided into small elements and for each element a stress value is calculated. This excel file can be modified for different girders with different strand profiles. Allowable stress limits can also be changed based on code. It can also be modified to show the parts in tension in blue, compression in red.



    Download

    This Excel file calculates all the win/lose probabilities based on the rolls of both sides. It gives a summary on what to do based on the dice. This information can be used to code an AI that masters the game fast or just by a competitive player.



    Download

    This Excel file can be used to calculate prime numbers up to a desired point. The method used is based on an algorithm called the sieve of Eratosthenes.



    Download

    This Excel file can be used to calculate the following on a loan:

  • Payment for each compounding period
  • Total interest
  • Total payment with interests
  • Beginning balance for each compounding period
  • Interest for each compounding period
  • Principal for each compounding period
  • Remaining balance for each compounding period

    • Given that the following is known:

  • Interest rate
  • Initial investment
  • Compounds per year
  • Payments per year
  • Time of finish of payments


    • Download

    This Excel file was used to calculate the required shear reinforcement and spacing in a 26 m AASHTO Type IV girder according to the design criteria given in CSA S6-14. It can be modified to be used for any type of length and girder.



    Download

    This Excel file was used to calculate the required shear reinforcement and spacing in a 26 m AASHTO Type IV girder according to the design criteria given in AASHTO LRFD 2014-17. It can be modified to be used for any type of length and girder.



    Download

    This Excel file was used to calculate the required shear reinforcement and spacing in a 26 m AASHTO Type IV girder according to the design criteria given in CSA S6-66. It can be modified to be used for any type of length and girder.



    Download
    Go Back