civil engineering formulas in excel download

#Civil engineering formulas in excel download how to
#Civil engineering formulas in excel download manual
#Civil engineering formulas in excel download code
#Civil engineering formulas in excel download professional

Warnings are provided for rates that may cause drying shrinkage cracking. Automates Job Sheet 813 calculations.Ĭalculates concrete bleed water evaporation rates based on WCS-4 (6/16) criteria. Automates Job Sheet 821 calculations.Ĭoncrete Mixture and Materials, Job Sheet 813Ĭalculates concrete design mixture and materials based on WCS-4 (3/19) criteria. Can be printed or filled in electronically.Ĭalculates concrete delivery tickets based on WCS-4 (3/19) criteria. Resembles ENG 523A Computation Sheet and used for documenting engineering calculations. 'BTU's saved' is calculated by subtracting 'Total BTU's used with conservation system' from 'Total BTU's used with baseline system.' Energy savings percentage is calculated by dividing 'BTU's Saved' by 'Total BTU's used with baseline system.' Total BTU's will be the total of the BTU's calculated for each energy source.

The quantity of BTUs is calculated from the data entered for different energy sources. Rating tool for concentrated livestock areas to determine if the area is a resource concern by calculating a rating at the edge of a concentrated livestock area and the end of a buffer. Includes a Help tab.Įvaluation of concentrated livestock areas using BARNY buffers.

#Civil engineering formulas in excel download code

These calculations are needed to determine if a Wisconsin Pollutant Discharge Elimination System (WPDES) permit is needed (Wisconsin Administrative Code NR 243).

#Civil engineering formulas in excel download manual

* Instructions for MS Excel 2007 Users (PDF 502 KB)Ĭalculates cross-section area or plane surface based on manual input of X and Y coordinate pairs.Ĭalculates the total number of animal units based on animal type, number of animals, and average weight, using a 1,000-pound equivalent. CAD drawings are available in the Wisconsin engineering CAD drawings section. Many engineering spreadsheets are available for use. Most if not all spreadsheets contain macros. The designer must understand the assumptions and calculations contained in the spreadsheets and is responsible for their use. The designer should verify that the design complies with NRCS standards and that the standard applies to the site. Useful Salary Slip Formulas 1īasic wage + HRA + Conveyance + Medical + Special allowancesĠ.75% of employee gross wage.NOTICE – The following engineering spreadsheets have been developed to assist in the design of typical engineering practices. Step 7: Now take out the printout of the salary slip and sign it and distribute to employees. Step 6: Now subtract all the deductions from the earned gross salary of the employee in that particular month, the balance amount will be the net salary of the employee. Other(Special) Allowances (Balance allowances) HRA (40% of the basic wage for nonmetro cities)Ĭonveyance Allowances ( 1600 Rs in urban areas)

#Civil engineering formulas in excel download professional

Step 5: In another column add deductions such as EPF, professional tax, ESI/health insurance, TDS, and salary advances, etc… Salary calculation formula for the total paid days = (Original gross salary/Total days in the month) X Paid days in that month.

The sum of all the earnings will be called the actual gross salary of the employee. Step 4: Now in one column add all the earnings of the employees such as basic wage, house rent allowances, conveyance allowances, medical allowances & special allowances. To calculate total paid days subtract LOPs from total days in the month. Step 3: Now enter the number of days in the month, and LOPs (Loss of Paydays) of the employee. Step 2: Now enter employee general details like name, designation, department, date of joining, gross salary, bank details, and any other required information as per your choice. Step 1: To create a salary slip/pay slip open a new Excel sheet and write your company name, address, and payslip month & year in the first three rows of the Excel file.

#Civil engineering formulas in excel download how to

Download Excel How to Create a Salary Slip in Excel