How to Export Tables From AutoCAD to Excel Format?

Part 1 of 13 in our How To Use AutoCAD series

When working with AutoCAD, you never work completely in isolation. AutoCAD workflows are always about collaboration, review and approval. As such, AutoCAD projects and designs will always be connected and work in conjunction with other formats.

More often than not, the detailed tables of information of a design will need to be either recorded, edited or entered into Excel spreadsheets. That being said, you’ll need to know how to get that table into Excel.

To export a table from AutoCAD and edit it in Microsoft Excel simply select the table, then right click and choose “Export”. The table will be exported in .CSV file format.

Next, right click on the exported .CSV file and from the options menu choose Open with Excel.

Opening CSV In Excel

Once the table has been opened in the Microsoft Excel, save it as an .xlsx file and you can instantly start editing the spreadsheet.

 

What 5 Oscar Nominated Directors Can Teach You About Being An Entrepreneur

It’s that time of year again and the 2016 Oscars are right around the corner. You can be nothing but inspired by the films and their actors, screenplays, and production teams. This is especially the case with this year’s nominees for best director. Each brought something unique to the table.

These directors had a vision they worked hard to realize and they did it while dealing with a lot of risk.  And in certain ways, these movie directors are similar in nature to entrepreneurs. Given their success, the 5 Academy Award-nominated directors of 2016 can certainly give you a few extra pointers about being an entrepreneur.

Work With Your Strengths And Past Experiences

Known for his big hit comedies, Adam McKay had to find the sweet spot between comedy and drama in bringing the The Big Short to the big screen.  Based on the financial crash of 2008, making the topic with all its financial talk accessible to everyone was essential to the film’s purpose.

You may think that a comedy-based director wouldn’t be able to pull it off, but he did. It was the lynch pin for him. He worked the explanations into a pop-culture frame, getting celebrities to break down financial concepts into analogies that resonated with the average Joe.

In an interview with Film Comment, McKay says, “that was the very first idea I had when I read the book: you’ve got to break the fourth wall in this movie…. I’d seen some movies do it really well, and certainly from my theater background I’d done it a bunch. So I knew it could work—it’s all about how much you do it, the way you do it. But yeah, the very first idea I had was going to those explanations.”

The key takeaway? Know where your experience and strengths fit into your start up. Be brave enough to apply them in different ways.

Whether you’re a knowledge-seeking, problem solver or the manager-type who thinks outside of the box, your perspective and experiences will only help your business thrive. Only you can develop your startup in ways that no one else can.

Feeling Lost Can Be A Positive Part Of The Process

Alejandro González Iñárritu directed The Revenant, which, as you can imagine, was a challenge to shoot. Extreme and unpredictable weather conditions out in the wilderness can’t be easy for any director and film crew to deal with. But, to Iñárritu, the challenge was a personal journey.

Explaining this to Deadline.com, he says of the filming process, “this is not some tourist trip with a GPS, where everything is planned and everything is on time. This is a journey, and my process sometimes in life is to get lost. I personally think that you have to get lost to find something really worthwhile, at least sometimes…. But sometimes the best journey, and the best things you discover, come when you get lost.”

As you build your startup, things won’t always go according to plan. But when you’re in a tailspin, you can find, as Iñárritu did, the inspiration to turn things around.

You need to remember that feeling lost can be a constructive emotion.  It’s a sign to switch gears, adapt, and discover a better path towards your goal.

Don’t Let Setbacks Stop You

George Miller introduced the world to Max Rockatansky back in 1979. That was more than 30 years ago. And it’s been more than 10 since Mad Max Beyond Thunderdome was released in 1985. A long time for diehard fans.

Why the huge gap? Talking to Vice.com, Miller spoke about the many setbacks leading up to the latest film. There were a wide range of obstacles: 9/11, a weak Australian dollar, locations falling through and losing Mel Gibson as Mad Max.

When asked if they made him think of abandoning the franchise, Miller says that it never got to that point. They were just a natural part of the film business.  He expands on the thought, saying, “you have a number of things going, and there’s one that sort of drives you. But if it falls away, if it’s good enough, it keeps coming back. So it was just a matter of getting it all sort of lined up and the right things happening.”

No doubt Mad Max: Fury Road kept coming back for Miller. Struggles will happen and things may get side tracked. But it doesn’t mean the end of your dreams.

In fact, it can be a blessing in disguise. A sign to wait for the right time. And what you need during that time is a sixth sense to know that you have an idea that’s worth developing. Pursue it despite the setbacks.

Learn from your Mistakes and your Achievements

Leading up to this point, Tom McCarthy has acted in a number of films (and TV shows) over the years, including The Lovely Bones and Meet The Parents. He has directed 5 movies with his last recent film being, The Cobbler, which wasn’t well-received by audiences and critics.  But, in stark contrast, the actor/director is now nominated this year for Spotlight, a journalist drama based on true events,.

RollingStone.com talked to him about the differences in success between The Cobbler and Spotlight. And he responded with a reflection on his view on the film-making process:

“You learn with every movie you make, you learn from your mistakes and you learn from your achievements, and I really do have that approach to filmmaking. It was certainly a learning experience, just like making a good movie is a learning experience.”

And likewise, this same perspective holds true for entrepreneurs. You need to treat each step as an experience to learn from. You’re always thrown into new situations, making errors and gaining successes along the way.

But if you can constructively learn from your new insights and experiences, both good and bad, things can only develop and move forward just as they did for McCarthy.

Be Passionate About What You Do

The success of Lenny Abrahamson’s Room has the director in new territory with his first Academy Award nomination. And of course, interviewers are wondering about how he’s reacting to the success and how it affects him.

In an interview with Collider.com, Abrhamson reflects that “you can get a little caught up in it. Also, what I’ve done, I’ve done because I feel passionate about it. I think that works for me. It’s how you make good work. Your heart has to be deeply in it. If you started to choose projects because you like the awards buzz too much and you were a bit addicted to that, and you choose the next project based on whether it’s going to be awards worthy or not, you’ll make really bad decisions.”

As entrepreneurs, you dream of success. And when it finally comes, it can be easy to let profit and success drive you. But the important part is to remember the “why” and “what” that started it all.

You didn’t work long hours and go through all that stress for an idea you weren’t emotionally invested in. Why start now? Always let your passion drive you. Your success will be all the sweeter for it.

 
So if you need some inspiration and advice on your road to entrepreneurial success, you don’t have to look far.  Just look to the silver screen.

How To Learn AutoCAD

AutoCAD Technical Design

In this day and age, anyone can pick up a new skill and turn it into a high-paying career asset. This is especially true for the tech savvy who already tinker around with and explore software on their own. They can translate that hobby into valuable skills needed for certain positions or tasks.

For instance, being able to create high quality AutoCAD images, 3D digital drawings and the like, is an extremely valuable skillset. Because of its extremely niched usage, AutoCAD isn’t a software skill likely to be common among average computer users.

And even if you’re not learning it for professional reasons, you may simply be curious about AutoCAD software, wanting to learn more about it.  

But where do you start? With such a complex piece of software, the learning process is sure to be confusing. Fear not.  Below are some basic answers, handy tips and a few pointers on how to learn your way around AutoCAD.

How To Learn AutoCAD On Your Own?

The best way to start learning AutoCAD on your own is to find an online course or tutorials that best suit your learning preferences and needs. For example, if you’re dominantly a visual learner you may want to start with YouTube video tutorials or enroll an online course with lots of video materials. If you prefer to learn by reading step by step instructions followed by images and screenshots, you may want to start with a basic course offering such materials. Fortunately, there are many AutoCAD learning resources to be found on the Internet. The first resource that comes to mind:  Autodesk official training guide, tools and learning tools.

Additionally, we’ve compiled a list of websites that provide free online AutoCAD courses, tutorials and complementary exercises.

Beside that, here are some additional helpful tips for self-learning with AutoCAD:

  • Find blogs and tutorials specific to your field of work. For example, if you want to learn how to use AutoCAD for mechanical workflows, try to find a blog or tutorial that specifically covers this topic.  
  • Search for exercises that will help you to memorize various commands by practice. He goes on to point out that this way of learning boosts your morale and self-esteem:  each time you complete an exercise, you feel more and more accomplished.
  • Start by learning how to use 2D drawing tools and applying what you learn to 2D drawings. If you don’t have any 2D drawings, just search the web; there are many 2D drawings available online. Once you get the hang of 2D drawing tools, then go for 3D which are mostly the same ones as 2D except for some specialized tools.
  • Practice, practice and then practice some more. This is the rule that applies to learning new skills or mastering a software application such as AutoCAD.

How Can Kids Learn AutoCAD?

Although AutoCAD isn’t a general purpose software application that all children will necessarily use in their higher education or future line of work, they can certainly learn how to draft 2D and 3D models in AutoCAD. Most importantly, a Quora thread shows that there’s an interest in teaching kids how to use AutoCAD.

A good place to start would be to teach a class or a child how to use one of the widely available free and easy-to-learn online apps for creating and printing 3D models. It’s fun and  good preparation for working with a more advanced desktop software program for 2D and 3D drafting such as AutoCAD.

The next step would be to do a few demos on how to use the key commands and solve common problems. Provide them with video lessons that you can create yourself or choose and use free online AutoCAD tutorials.  

There are also ready-made exercises and quizzes to test students’ progress. Follow their progress with the program and assign different challenges based on their individual performance, interest and engagement.

If you’re teaching, let’s say a bunch of 8th graders, chances are that majority of them won’t be engaged enough to become proficient in AutoCAD, especially if they don’t aspire to become architects or engineers. Therefore, adapt the course to accommodate for this and yet keep encouraging and challenging the students who do have higher engagement and interest levels.

How To Become An AutoCAD Professional?

Once you’ve mastered the basics and learned how to create basic drawings and blueprints in AutoCAD using any or all of the above mentioned techniques,  you’re ready to take your AutoCAD skills and expertise to the next level. Experienced AutoCAD users like Raymond Owusu suggest finding professional, complex drawings and trying to replicate them. Another good tip is to join AutoCAD forums and communities and ask how to do some difficult things. Consistent practice and especially real life projects will help you become a power user or even an AutoCAD professional.

The easiest way to test and prove your expertise in AutoCAD is to take a test provided by Autodesk and earn official certification status that will validate your drafting and design skills. Autodesk certifications are widely recognized credentials in the CAD industry and can establish you as an AutoCAD professional and further your design career.  

How To Get Autodesk Certification For AutoCAD?

In order to become Autodesk AutoCAD certified user or professional, it is necessary to take and pass a suitable exam offered by Autodesk.

You can find the detailed exam preparation information on the Autodesk website. This includes exam topics and objectives, recommended preparation methods for different certification levels, requirements, training options, and other related info.  

 

Top 10 Big Data And Data Science Conferences In 2016

Conference Event AuditoriumYou can’t go a day online without reading about big data. In our fast-paced, tech-oriented world where data is key, it isn’t any wonder. Managing, analysing, and storing all that generated data are issues many businesses are looking to improve upon or resolve.

Reading and discovering all about data science while you’re online isn’t hard. It’s staying well ahead of the game that is. There are big data science trends going on and it’s crucial to stay on top of them.

What new developments are happening? Will business intelligence predictions affect your company? Where can you get expert advice?

The best place to start? Data science conferences. They’re a great way for data practitioners and business pros to network, gain some perspective or learn new skills.

Here are the 2016 conferences that made our shortlist.  Did we miss any? Add your suggestions and recommendations in the comments!

  1. Strata + Hadoop World

Presented by Cloudera and O’Reilly, this conference is one of the most renowned data conferences you can attend. Its focus is on putting new methods and technologies into the spotlight, helping you develop new skills, best practices and strategies for dealing with and leveraging your data.  Attend and you can take advantage of training, career opportunities, workshops, keynote speakers, and discussions. You’ll get the opportunity to network with industry leading data scientists, business professionals and thought leaders.

Date & location: 

  • San Jose, California
  • March 28-29 (training)
  • March 29-31 (conference)
  1. Emetrics Summit

The eMetrics Summit is an event dedicated towards the data-driven marketer. Its speakers and tracks are geared at exploring how big data and technology will impact the future of your online and social media marketing efforts.  Discover answers to your questions and learn the latest from experts about digital analytics and marketing optimization.

Date & Location:

  • San Francisco, April 3-6
  • Chicago, June 20-23
  • New York, October 24-27
  1. Predictive Analytics World for Business

The Predictive Analytics World for Business conference, is co-located with the eMetrics summit mentioned above. Attendees at this event can get insights and hands on discovery with predictive analysis to improve the decisions being made from collected data.  This conference brings together the predictive analytics community to cover popular topics like marketing and CRM (offline and online), insurance pricing, credit scoring and other areas where predictive analytics is applied.  Get product recommendations, ideas on strategies, and more.

Date & Location: 

  • San Francisco, California
  • April 3-7
  1. Open Data Science Conference

When dealing with big data, it isn’t uncommon for data professionals to work with open source tools. This conference is an event that fosters the melding of open source and big data where you can get deeper insight on how one is integrated with the other. Its focus? Open source languages used in data sciences, data visualization, predictive analytics, big data tools, Hadoop-based languages, and machine learning, among other topics.

Date & Location:

  1. Data Science Innovation Summit

While you may have missed the Big Data Innovation Summit going on right now, you can still catch the Data Science Innovation Summit next month. The event showcases a number of keynote presentations, interactive workshops, and case studies from Fortune 500 companies. Check it out if you’re interested in discussing how to extract the value from your data, which is the event’s main focus for 2016. Learn from other business, data, and IT pros in the field.

Date & Location:

  • San Diego, California
  • February 18-19

 

Making Business Connections

  1. useR!

This conference is offered and organized by the R language user and developer community, one of the main programming languages specifically designed for analyzing big data. Attendees get to hear from colleagues with invited and user-contributed presentations exploring R-related and general topics. The useR! program will cover visualization and graphics, bioinformatics, high performance computing, industrial applications, statistical learning with big data, teaching and more.

Date & Location:  

  • Stanford, California
  • June 27 -30
  1. Insight 2016

While details for this conference are still in the works, you’ll want to keep this one on your radar. In the past, this IBM conference has  had an excellent program that includes speakers, informative sessions, and tons of opportunities aimed at helping you learn about capturing your data more efficiently and leveraging it for your business.  In addition to data and analytics, this conference covers a broad range of interests including cloud, mobile, IoT, security and much more!

Date & Location:

  • Las Vegas, Nevada
  • October 23-27
  1. JSM

The Joint Statistics Meeting boasts being the “largest gathering of statisticians held in North America”. And rightly so. This conference is held jointly with a number of prestigious associations in the field of statistics. Attending this conference, you can get a broader picture about statistics, data, and their real world applications.

Date & Location:

  • Chicago, Illinois
  • July 30-August 4
  1. Data Summit

This summit has some of the biggest corporations in attendance. It covers a wide range of hot topics being discussed in data science: big data integration, data engineering, data discovery, modern data architectures, big data in the cloud and more. Visit the site for more details.

Date & Location:

  • New York, New York
  • May 9-11
  1. KDD2016

Behind this event is the SIGKDD, ACM’s Special Interest Group on Knowledge Discovery and Data Science. As an interdisciplinary conference, KDD 2016 will be the place to be if you’re looking for a community of data scientists and experts who are enthusiastic about discussing and spreading the word about developments in the KDD field, as well as encouraging education among researchers, users and practitioners.

Date & Location:  

  • San Francisco, California
  • August 13-17

 

Now that there are tools like Excel 2016 that are making it easy for dealing with big data, everyone has the potential to be a data scientist.  If you’re one of them, attend at least one of these in the upcoming year or, if not, check in with them online as there will have post-event content available.

 

AutoCAD Q&A Guide: Top Answers to 11 FAQs About AutoCAD

CAD Model

Although AutoCAD is a complex program that brings to mind computer experts and technical precision, it’s an application that, despite its intimidating nature, can be very rewarding once you learn about it.

If you’re interested in AutoCAD, you’re probably full of questions. Well, we’ve scoured the web for the most common FAQs about AutoCAD usage and best industry practices and found the answers to them. Whether you’re a newbie, a hobbyist or an existing AutoCAD user,  you’ll get one super AutoCAD knowledge source right at your fingertips.

Check it out.  After all, if someone had a question about the program, chances are you have the same one too! 

What Projects Can Be Done In AutoCAD?

Autodesk AutoCAD is a general purpose CAD software application. As such, it can be used for drafting and design projects that involve creation, editing, viewing or printing various types of geometric 2D and 3D entities. Basically, this includes various projects in areas of architectural, civil, mechanical or electrical engineering drawing and design.

Do Civil Engineers Need To Learn AutoCAD?

The general consensus among experts online is that civil engineers do need to know their way around CAD software.  According to many structural engineers, like Norbert Pozsonyi at Quora, AutoDesk’s AutoCAD is an essential CAD software tool to learn and know. Learning AutoCAD will at least help you to read drawings, which is of vital importance for civil engineers.

Whether and how much you will really need it in practice, depends on where you are (in which part of the world) and what software is used at the company you work for. For example, civil / transportation design engineer Robert Lane explains in a Quora thread that most DOT’s (Departments of Transportation) in the US mostly use Microstation and its design software.

What CAD Software Does A Civil Engineer Need To Know To Land A Job?

Autodesk’s AutoCAD is an industry standard used by the vast majority of civil engineers and construction firms, but there are still many others that use different CAD software. So, if you have to pick one CAD software to learn, choose AutoCAD. But, to improve your prospects of landing a job as a civil engineer, you may want to learn a few other CAD software applications. Some of the most commonly used ones that will add extra strings to any civil engineer’s bow include MicroStation, Revit and Tekla.  A comprehensive list of CAD editors and a comparison of computer-aided design solutions is available at Wikipedia

What Is The Difference Between AutoCAD And AutoCAD 360?

AutoCAD is a commercial computer-aided design (CAD) desktop software application for 2D and 3D design and drafting. It’s used for creating blueprints and other engineering plans. AutoCAD is mostly used by drafters in architectural drafting, civil drafting, mechanical drafting, electrical drafting, electronics, aeronautical drafting, and beyond.  

AutoCAD is available for Microsoft Windows and Mac OS X.

AutoCAD 360, on the other hand, is a web and mobile drawing and drafting application that allows registered users to view, edit and share AutoCAD drawings via web and mobile devices. It’s available with a free plan and two paid plans (as a Pro and Pro Plus).  AutoCAD 360 is used by general contractors, project managers and tradesman with little to no experience with CAD and is commonly used across a wide range of industries: architecture, engineering and construction, mechanical, electrical, plumbing, and more.

AutoCAD 360 is available for download as a mobile app for Android and iOS devices.

What Is The Difference Between AutoCAD And Solidworks?

A CAD analyst Sandeep Kumar summed it up on Quora: Autodesk’s AutoCAD was initially designed for 2D drafting and subsequently extended with some 3D features. SolidWorks, on the other hand, is a full featured 3D modelling CAD software.

Solidworks Resource Homepage

When it comes to 3D modelling, SolidWorks is for the advanced users and tasks, while AutoCAD is mainly for intermediate 3D modelling.

However, while AutoCAD is available for both Microsoft Windows and Mac OS, Solidworks runs exclusively on Microsoft Windows OS.  

Autodesk’s Inventor is actually Solidworks’ counterpart, rather than the often compared AutoCAD

What Are The Differences Between AutoCAD, AutoCAD Architecture, 3DS Max And Revit?

AutoCAD is, as already mentioned above, primarily a 2D drafting software with moderate 3D modelling capabilities. It uses lines to graphically represent objects.

AutoCAD Architecture is a specialized version of AutoCAD with additional tools designed specifically for architects to enhance their workflow, aiding in tasks such as architectural planning and construction documentation.

Revit is a 4D BIM modeling software with tools for planning and tracking various stages in a building’s lifecycle, from concept to construction and eventual demolition. Simply said,  Revit is used for building computer models of physical structures. It allows users to create actual objects with attached parameters and data like material, as opposed to just creating lines that graphically represent objects. It should be noted that Revit is a building modelling tool, and isn’t used for generic modelling purposes.

Autodesk 3ds Max is a 3D modelling, animation and rendering software. It’s mostly used for making 3D animations, games, images, movie effects and movie-pre-visualization. Its most common users are video game developers, TV studios and architectural visualization studios. While AutoCAD is primarily used for drafting, 3ds Max is mostly used for presentation. These two are both are geometric modellers, while AutoCAD Architecture and Revit are classified as BIM modellers.

Despite the differences between them, these programs primarily handle design and its implementation into usable construction and presentation documents.

What Are The Limitations Of AutoCAD Supported .DXF File Format?

To identify limitations or advantages of the .DXF file format, it is necessary to compare it to AutoCAD’s native .DWG format.  What can these formats do and which should you use?

Although both file formats are developed by Autodesk and supported by AutoCAD, there are some differences between the two vector image file types. The main one is that DWG (which stands for DraWinG) files only work with Autodesk’s AutoCAD, while .DXF (meaning drawing exchange/interchange format) was developed to allow other CAD programs to open and use information from the drawing file.

Furthermore, some CAD programs can’t import .DWG files, but they can import .DXF. That being said, if you’re a CAD user who doesn’t use AutoCAD, the ability to open and use the .DXF file in other CAD programs is its obvious advantage over the DWG.     

Possible limitations of .DXF in comparison to DWG are:

  • DWG files retain all drawing layers, colors, lines weights and x-references, while DXF files retain lines, dimension and text only.
  • While DXF is ACSII text, DWG is a binary file. This means that .DXF is more bloated in size than DWG.  

Despite these potential drawbacks, the ability to work with all vector-based programs has made the .DXF the most pervasive vector file type in the CAD industry.

Is It Possible To Convert TIFF To AutoCAD File?

It isn’t possible to directly convert TIFF image to DWG/DXF, but there’s a workaround you can try if you need to reuse a TIFF image in AutoCAD. Use the IMAGEATTACH command to insert TIFF as a raster image, then use the image as reference. It’s possible to trace the image.

Is It Possible To Convert PDF To CAD File?

Yes, it’s possible to convert PDF to CAD file. All you need is a PDF to CAD conversion solution. There are a number of available PDF to CAD converters, including Investintech’s Able2Extract, which converts PDF to DWG and DXF formats. Able2Extract PDF Converter is a desktop software, which is free to try for 7 days. There are also some free online PDF to AutoCAD converters, like this one.

Able2Extract Autocad Conversion

If the PDF file was generated from a CAD application, such as AutoCAD, the vector data should be embedded in it, which allows for an easy and accurate conversion.

Do Software Packages That Convert PDF To CAD Files Really Work?

In short: yes, they work. According to a BIM expert and educator, Stefan Boeykens, there are a number of things to keep in mind when converting and evaluating results of a PDF to CAD conversion. Firstly, note that a PDF file is a visual representation of a CAD drawing.  It contains lines, color and text. Thus, when it comes to the conversion output of such files, know that:

  • Lines are, by rule, converted accurately, with an exception to line weights which convert with less accuracy.  
  • Hatches are turned into blocks or groups of lines.
  • With text and dimensions,  the conversion output largely depends on the source. Thus, text can be turned into curves resembling the text, and dimensions become grouped text and lines. There can’t be dimension entity in the conversion output simply because there is no such thing in the PDF.

Note that when converting PDF to CAD drawings, your resulting content will end up as a graphical output containing line-properties, colors, curves, etc.

What Is The Best Format To Transfer CAD Files To Non-CAD Recipients?

The default and usually the best format for non-CAD recipients is the PDF (Portable Document format) as anyone can open and view PDFs on any device. PDFs are non-editable and an obvious choice when the owner or sender doesn’t want the recipient to edit the document.

An alternative to PDF would be DWF as another non-editable file format. However, to open it, the recipient needs to have DWF viewer installed. Compared to the widely used PDF format and the number of freely available PDF readers, chances are that most non-CAD users won’t have the necessary DWF viewers installed on their devices. They may even be unaware of such software, or even if they are, finding and installing would take up extra time.

If you want to transfer the editable CAD file to a client, project manager, tradesman, contractor or any other project stakeholder, the best formats are .DWG or .DXF. If they don’t generally use desktop AutoCAD, they can open the DWG or the DXF files in AutoCAD 360 even with a free plan and make edits to it.