Business Solution

A Digital Solution provider, from designing websites, graphics and logos, building custom apps to GIS and Surveying Solutions.

Home
About
Services
Archive
Subscribe (RSS)
Ask for Solutions!
Random post

Catching Elephant is a theme by Andy Taylor

 

Generating engineering drawings from a given data set (like an Excel sheet) is the dream of every engineer engaged in drawing such drawings. As a trial I set out to code in VBA and tried to generated Siteplans, X/Section, L/Sections and some other drawings from a given data set in Excel.

The drawings are in a specified scale and the standards are upto CAD drawings with precisions upto 6 digit decimal place. And the most important consideration is the speed and precision. Generating cross sectional drawing at 30m interval for a 15000m long road took hardly 120 seconds at 1:100m scale and on a A3 size paper.

The drawings can be exported to DES, DXF or any other vector type for further processing in Corel Technical, AutoCad or any other CAD/CAM software. Though the applet/addon is far from complete, it is very usable and so far I’ve generated C/S for more than 220 roads ranging from 1.8 Km to 27 Km length for some clients.

[Siteplan Generated in CorelDraw using Excel & GPS Data]

[C/Section Drawing Generated in CorelDraw Using Excel Data & VBA]

I am interested in further developing this applet and port it to CorelCAD, AutoCAD and I am planning the following features:

  1. Embankment
  2. AutoCad AutoLISP & VBA support
  3. CorelCAD VBA Support
  4. Linking Back from Drawing back to Excel Data
  5. Adding support for Bridge/Culvert drawing generation

Interested developers, please contact me. [For co-development only please] As soon as it is stable and finished, We are going to open source the codes.

This is a Siteplan(Map) in 1:2500 scale, generated with CorelDraw using VBA and some GIS script I’ve written. This plan was generated using the GPS track. Developers interested in using CorelDraw to generate engineering drawings, please contact me at boychou.thokchom(at)gmail for the scripts that i’ve developed in Excel and Corel with VBA for the following Functions: Cross Sectional drawings for roads/formation cutting Longitudinal Sections (L/Section) Siteplans and in Excel Bearing (Back/Fore) Distance from Lat/Lon Extract elevation for points between two cordinates etc.

This is a Siteplan(Map) in 1:2500 scale, generated with CorelDraw using VBA and some GIS script I’ve written. This plan was generated using the GPS track. Developers interested in using CorelDraw to generate engineering drawings, please contact me at boychou.thokchom(at)gmail for the scripts that i’ve developed in Excel and Corel with VBA for the following Functions:

  1. Cross Sectional drawings for roads/formation cutting
  2. Longitudinal Sections (L/Section)
  3. Siteplans

and in Excel

  1. Bearing (Back/Fore)
  2. Distance from Lat/Lon
  3. Extract elevation for points between two cordinates etc.

Business Solution:: Imphal River Survey

Business Solution is happy to announce that Imphal River Survey project has been bagged by us. We are organizing for the field works and looking for bargain equipments. We need SONAR based underwater scanners, LIDAR/LLaser based measuring tools. And data and data on Imphal Valley and the places where Imphal/Manipur River passes through.

Look for updates.

(Source: facebook.com)