Foundation design spreadsheet xls

Foundation design spreadsheet xls


  • Foundation Design Spreadsheet
  • Pad Foundation Design spreadsheet
  • Combined Footing Design With Excel | Download Spreadsheet
  • Isolated Footing Design Example and Excel Sheet
  • Pump Sizing and Selection Made Easy
  • Foundation Design Spreadsheets
  • Foundation Design Spreadsheet

    Liu, Virginia Tech University January 1, Viscosity, power consumption, commercial availability and lifecycle cost analysis are all important considerations in pump sizing. An automated spreadsheet method helps engineers take those factors into account in centrifugal pump selection Many aspiring chemical engineers enter industry after university study without sufficient practical knowledge about how to properly size pumps. A number of recent articles provide useful guidelines for sizing and selecting pumps, but these articles focus on certain specific aspects of proper pump sizing, while leaving out others [1—4].

    Chemical engineering literature does not fully cover other essential aspects of pump sizing and selection — including the viscosity correction, power consumption, commercial availability and lifecycle cost analysis. The initial purchase price of a pump is only a small fraction of the total lifecycle cost. There are situations in which purchasing a less expensive pump actually leads to greater energy-usage costs. This results in a higher lifecycle cost see Example 1, below.

    Without a proper understanding of the pump selection process, engineers cannot effectively make both economic and practical decisions. This article aims to fill in some of the gaps in understanding and provide a straightforward method for pump sizing and selection.

    Along with this article, we have created a useful Microsoft Excel spreadsheet to assist with centrifugal pump sizing. The automated Excel spreadsheet assists in calculating the key parameters for pump sizing and selection. Since the majority of the pumps used in the chemical process industries CPI are centrifugal pumps, this article focuses on that equipment category, rather than the other general classes of pumps, such as rotary and positive displacement pumps.

    Example 1. Pump Sizing and Selection The following is a pump sizing problem to illustrate the calculations in this article. You are told to purchase a pump for your manufacturing facility that will carry water to the top of a tower at your facility. Assume BHP is 32 and 16 horsepower for the 3,rpm and 2,rpm pumps, respectively, for all pump choices in the composite curve. Assume all of the pumps are viable for your required flowrate.

    The suction-side pipe and discharge-side pipe diameters are 4 and 3 in. The suction tank elevation S is 12 ft, and the discharge tank elevation D is ft. Assume that both hd,f and hs,f are roughly 10 ft. The pump curves in Figure 3 illustrate the following pump options to choose.

    Notice that most of the TDH comes from the significant elevation difference between the suction and discharge side. Now that two pumps are feasible from the perspective of TDH requirements, you can compare the economics. At first glance, it is tempting to choose Option 1, since the initial investment is significantly lower. Although Option 2 has a higher initial cost, the lifetime cost over five years is dramatically lower.

    The problem shows that, in selecting a pump, the costs associated with power consumption and maintenance are critical pieces of information for making an informed decision. Pump sizing overview The concept of a pumping system is rather simple. The suction side refers to everything before the pump, while the discharge side refers to everything after the pump. Figure 1 illustrates a simplified pumping system. A key parameter in characterizing a pump is the total dynamic head TDH , which is the difference between the dynamic pressure of the discharge side and the suction side.

    The dynamic pressure represents the energy required to do the following: 1 to raise the liquid level from the suction tank to the discharge tank; 2 to provide liquid velocity inside both suction and discharge piping; 3 to overcome frictional losses in both suction and discharge piping; and 4 to pump the liquid against the pressure difference between the suction and discharge tanks.

    Figure 1. The following components are needed to calculate total dynamic head: suction and discharge elevation; fluid velocity; friction loss and dynamic head; and tank pressure Six steps to pump sizing. In order to size a pump, engineers need to estimate the temperature, density, viscosity and vapor pressure of the fluid being pumped.

    Pump sizing can be accomplished in six steps, as follows: Find the total dynamic head, which is a function of the four key components of a pumping system, such as the one shown in Figure 1 Correct for the viscosity of the fluid being pumped, since pump charts and data are given for water with a viscosity of 1 cP. The viscosity of other process fluids can differ dramatically Calculate the net positive suction head NPSH to select a pump that will not undergo cavitation Check the value of suction-specific speed to see if a commercial pump is readily available see section on suction-specific speed later in this article Check for potentially suitable pumps using a composite performance curve and an individual pump performance curve Compare the energy consumption and lifecycle cost of operating the selected pumps Pump Selection, Example 2 An additional pump selection problem is shown Example 2.

    For this example, consider a discharge line that is 50 ft schedule 40, 4-in. The velocity is The elevation difference on the discharge side is 17 ft, the total dynamic suction head is 50 ft, and the pressure on the discharge side is Solution: For choosing the appropriate pump, see Figures 3 and 4. Both pumps should be analyzed by performing a lifecycle cost analysis using the pump efficiencies from the individual pump performance curves.

    Calculating friction losses Pumps must overcome the frictional losses of the fluid in order for the fluid to flow in the suction and discharge lines.

    These frictional losses depend on pipe roughness, valves, fittings, pipe contractions, enlargements, pipe length, flowrate and liquid viscosity. To calculate the frictional head losses, in feet of liquid being pumped, on the suction hs,f and discharge hd,f side of the pump, Equation 1 can be used. The same equation can be applied to calculate the frictional losses of the discharge side, but with the appropriate values correlating to the discharge side of the pump.

    The first term in Equation 1 represents the frictional losses from the fluid flowing through a straight piece of pipe. The second term represents the frictional losses due to valves, fittings, pipe contractions and enlargements. We have provided the values for the typical resistance coefficients and pipe surface roughness from the chemical engineering literature in the Excel spreadsheet discussed in this article.

    An illustration of this solution can be observed in Example 2 on page We also implement the same heuristic within the Excel spreadsheet. The Darcy friction factor fD can be calculated using the Churchill equation, Equation 2 , which is applicable for all values of Reynolds number Re.

    Pad Foundation Design spreadsheet

    Empowering and engaging your employees. Tracking attendance and optimizing your business expenditure. Kredily helps you manage leave and attendance, Payroll, Payout, end to end.

    As a growing not-for-profit, we needed an HR solution that could help us manage our core HR processes at minimal cost. That's where Kredily helped us out!!

    Kredily brought to us a Core HR suite at no cost. It's basic and simple interface is very intuitive and doesn't require any training to implement. It's interesting to see how in India, an HRIS company is offering these value services at no cost to clients. During our relationship, Kredily has developed a good understanding of our own vision and work flows and found a way to successfully complement our operations without causing any discontinuities or issues on our side. As a startup founder, I was spending a considerable amount of time in keeping up the attendance, leave and payroll logs.

    The setup was easy and well directed. I personally liked the detailing in the application about the HR process. Sandeep G. The tool is so user friendly and simple to configure and use by not only the administrator but also the end user. More than the product itself, the support given to me has been a simply awesome experience. For a small NGO like ours, it has been great to get all solution on a single platform in managing the employee database and authorization matrix.

    This has really helped us a lot in building our organization as an effective institution. We were pleasantly surprised to find that Kredily offered not only an easy to use HRMS solution, but also one at zero cost. Kredily packs in a lot of the features of standard HRMS solutions and is incredibly simple and easy to use. Implementation time is next to nothing and the support that Kredily offers is awesome.

    I love the interface and your quick support every time needed. I found your step by step guidance on whether via demo videos or personally is wonderful and of a great support as an individual. We choose Kredily due to the simplicity they offer, especially within our industry. They have understood what challenges majority of the companies face, and offer a solution that could fit with most of the organization.

    Kredily has made it easy for us to choose what modules we felt we need. We are really excited to watch how we progress even more, and see what the future holds.

    Combined Footing Design With Excel | Download Spreadsheet

    That's where Kredily helped us out!! Kredily brought to us a Core HR suite at no cost. It's basic and simple interface is very intuitive and doesn't require any training to implement.

    Isolated Footing Design Example and Excel Sheet

    It's interesting to see how in India, an HRIS company is offering these value services at no cost to clients. During our relationship, Kredily has developed a good understanding of our own vision and work flows and found a way to successfully complement our operations without causing any discontinuities or issues on our side.

    As a startup founder, I was spending a considerable amount of time in keeping up the attendance, leave and payroll logs. The setup was easy and well directed. I personally liked the detailing in the application about the HR process. Sandeep G. The tool is so user friendly and simple to configure and use by not only the administrator but also the end user.

    Pump Sizing and Selection Made Easy

    More than the product itself, the support given to me has been a simply awesome experience. For a small NGO like ours, it has been great to get all solution on a single platform in managing the employee database and authorization matrix. This has really helped us a lot in building our organization as an effective institution.

    The mat foundation can be analysed as either rigid or flexible depending on the size and thickness of the mat and the strength of the subgrade.

    Foundation Design Spreadsheets

    Design of Raft Foundation Spreadsheet This spreadsheet can be used to design raft foundation subjected to a universally distributed loading.

    This is suitable for houses and small buildings with a raft foundation. The raft can be designed with a universally distributed loading and linear loads at the edges and corners of the raft.

    Strip Footing Design Excel Spreadsheet This spreadsheet completes the design of strip foundations including up to 16 columns placed anywhere along the strip footing. The columns can include axial, horizontal and moment forces making this spreadsheet suitable for warehouses and other buildings with column loads on long foundations.

    Wall Footing Design Spreadsheet This spreadsheet completes the design of long footings subjected to linear loads from walls. The spreadsheet allows the design to analyse a foundation of any length and width.


    thoughts on “Foundation design spreadsheet xls

    1. I apologise, but, in my opinion, you are not right. I am assured. Write to me in PM, we will communicate.

    2. I apologise, but, in my opinion, you are not right. I am assured. I can prove it. Write to me in PM.

    Leave a Reply

    Your email address will not be published. Required fields are marked *