To draw the Plan of an existing building by plotting the Coordinates using Auto CAD software / Microsoft Excel.

Object: To draw the plan of existing building by plotting the coordinates using AutoCAD software / Microsoft Excel.

Apparatus : Auto cad /Microsoft Excel

THEORY:

Auto cad: AutoCAD is a computer-aided drafting software program used to create blueprints for buildings, bridges, and computer chips, among other things.

Auto cad is a computer aided design software for the 2D and 3D design of certain objects or places. It is widely used in civil engineering field because of its ability to plan sites a lot easier than hand drawing, it can help design a lot of engineering supplies.

Microsoft Excel: Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.it is also used to make graphs.

Procedure:

Method to Plot layout on Microsoft Excel

  1. Enter Northing and Southing in adjacent columns
  2. Select all Northings and southings.
  3. Go to Insert Tab then Charts and then Selects a graph layout from given scatters.

Method to Plot layout on AutoCAD

  1. Set the units from format tab or simply press un and enter.
  2. Set the Dimensions from dimension tab or just press D and enter.
  3. Select the Polyline
  4. Enter Northing , Easting.
  5. Continue to enter northing and easting values to define the line segments. Or press ESC to return to the Line command prompt where you can use additional options to define the line.

Coordinates of Building are;

1(528,-73)

37(1012,603)

2(684,34)

38(972,639)

3(545,215)

39(906,597)

4(647,294)

40(947,550)

4(762,161)

41(898,515)

6(1036,355)

42(775,647)

7(919,486)

43(388,356)

8(960,514)

44(349,402)

9(1023,525)

45(202,285)

10(1036,567)

11(1075,594)

12(1105,578)

13(1095,527)

14(1384,224)

15(1458,276)

16(1174,608)

17(1198,614)

18(1200,639)

19(1228,647)

20(1231,704)

21(1208,709)

22(1207,733)

23(1189,756)

24(1247,794)

25(1334,749)

26(1367,975)

27(1295,1064)

28(1179,1104)

29(1056,1094)

30(953,1022)

31(879,901)

32(901,779)

33(1021,828)

34(1102,764)

35(1048,737)

36(1050,625)

The plan of the existing building by plotting the coordinates using Microsoft Excel

Word Image 876 1

The plan of the existing building by plotting the coordinates using AutoCAD software

Word Image 876 2

Leave a Comment

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

Scroll to Top