To remove the first three digits from a number in an Excel sheet, you can use the RIGHT function. Here’s how you can do it: Steps: Explanation: This formula works well for numbers in text format or numbers stored as text. If the value is numeric, you might want to convert it to text first, […]
REMOVE 3 DIGIT FROM LEFT OR RIGHT IN EXCEL SHEET Read More »
To delete blank rows in an Excel sheet, you can follow these steps: Method 1: Using Excel’s Built-In Tools On the Home tab, in the Editing group, click Find & Select. 2- Click Go To Special. 3-Select Blanks and click OK. Excel selects the blank cells automatically blanks rows selected. 4-On the Home tab, in the
Delete Blank Rows Excel sheet Read More »
If you are looking to create a Traffic Diversion / Detour Sign Board for a road project or construction, the goal is to ensure clear and easily understandable instructions for drivers to follow. Here’s a breakdown of what such a sign board should include and how to design it: Key Elements for a Traffic Diversion
Traffic diversion – detour sign board Read More »
You can use Batch Plot to publish multiple sheets or drawings to Printer, PDF or DWF files.1- Open any drawing go to layout do plot command from the File menu or hit Ctrl+P key and do as excellently in the below photo by order also note that the title block its same size of your
Print multiple drawings to PDF without open cad Read More »
We need to know the unit weight of steel bars for estimate the steel bars actually get the length of those bars. But steel bar suppliers measure the steel bars as weight. So we have to order them in weight for purchasing. The weight of steel bars can be expressed in kilogram or ton. [ 1
Calculation The Weight of Steel Bars Read More »
1.1 General Information GRP manholes and chambers are made of FLOWTITE GRP pipes as integral part of pipe installations. Their design is based on FLOWTITE GRP pipes and GRP plates, joined together with the use of polyester – glass fibre laminates. The technology used in the productionprocess of GRP manholes and chambers guarantees that they are completely sealed, fully corrosion proof, have excellent durability and can be safely serviced and maintained. Manholes and chambers are monolithic products with defined composition and properties. 1.2 Purpose Manholes and chambers form a part of underground gravitational and pressure systems, allowing for the inspection and operation of pipelines and fittings, as well as for changing the flow conditions of a medium, within the range of their intended use. · GRP manholes and chambers are primarily designed to be used for: · inspection and maintenance of drains or sewers · ventilation of drains or sewers · flow conditions change of a medium(change of direction, change of pressure, change of water flow rate) · cleaning and flushing of drains or sewers · maintenance of water meters and fittings · housing of pumping stations · inlet drain pits 1.3 Features & Benefits FLOWTITE GRP manholes consist of a composition of high tech materials and offer many features and benefits: Non-corrosive Durable Safe Maintenance-free Internal and external corrosion resistance One-piece wall structure Restricts infiltration Avoids exfiltration Lightweight Easy handling Unloading with light equipment No heavy equipment necessary for installation Easy installation Savings in installation time Smaller excavation No heavy footings No waiting time for curing of the base plate before installation Easy fabrication: additional pipe entries can be cut with standard power tools No assembling on site Minor grouting necessary Easy inspection Reliable product Dependable Dimensionally stable Uniform design download GRP
GRP Structural Manhole Read More »
To efficiently bind multiple external references (Xrefs) into multiple AutoCAD drawings, you can utilize AutoCAD’s scripting capabilities to automate the process. Here’s a step-by-step guide: 1. Prepare Your Environment: 2. Create the Script File: Replace path_to_drawing.dwg with the path to your drawing and path_to_xref.dwg with the path to your Xref. 3. Execute the Script: AutoCAD
Bind multiple xrefs in multiple drawings Read More »
A sewerage profile is a vertical representation of a sewer system, illustrating the elevation changes along its length. This profile is essential for understanding the sewer’s slope, depth, and potential conflicts with other utilities. Key Components of a Sewerage Profile: Creating a Sewerage Profile: Resources and Examples: For practical examples and templates, platforms like DWGShare
SEWERAGE PROFILE AUTOCAD Free LISP Read More »
Definitions The Universal Transverse Mercator (UTM) is a system for assigning coordinates to locations on the surface of the Earth. Like the traditional method of latitude and longitude, it is a horizontal position representation, which means it ignores altitude and treats the earth as a perfect ellipsoid. However, it differs from global latitude/longitude in that it divides
Convert UTM from zone to another zone Read More »
This new excel sheet program allows the user to export and import the data between Autocad drawings and excel sheet with own layer name, color and text size by this excel sheet you can save time and effort to see below video know how to use.
Autocad to excel and vice versa Read More »
