You can visualize your DWG files also on your mobile device now
Show me more...
Top Visited Posts in 2012
2012 Summary
Català - Castellano - Deutsch
#01. List of SketchUp Plugins: A post dated from 2009 but that has been (or used to be, when I had teh time) updated regularly with all the SU Plugins I have reviewed on this site. It needs some link updating which I will do soon, but it is still the favourite post for most visitors to CAD Addict.
#02. Using AutoCAD autosave files to recover lost work: This post explains what can you do after one of those moments when apparently you've lost part of your work in AutoCAD. It is the post with the most number of comments and all of them positive, so it is the one that made my work here feel more rewarded. Thanks to all who spend the time wirting down a comment, good or bad, it's great to know someone is reading.
#03. Plugin to Make faces from lines in SketchUp: I have toc onfess I am a bit puzzled by this post being so popular. The plugin was very useful back when the version of SU was v.6 or so and the program was not very smart creating lines from a closed set of lines. I think this was pretty much solved in later versions of SU, but oddly the post keeps getting a lot of visits. If anyone knows why the info will be very much appreciated.
#04. Volume Calculator Plugin for SketcHup: A post explaining how to use this old plugin to calculate volume of entities in SketchUp. A simple post about a simple plugin but that has had a lot of visitors and comments during these last months.
#05. How to install plugins in SketchUp: This is simple tutorial on how to get your plugins working in SketchUp. Sometimes the posts you think are too simple become the most wanted ones.
#06. List of BIM Software and Providers: Back when I was writing my Master Thesis, I started researching on all the scope of providers that have Building Information Modelling related software. This posts gathers most of that info and organizes it in different categories. One think this post taught me: People love lists.
#07. Converting 3D objects into 2D drwaings in AutoCAD: THis post explains the use of the FLATSHOT command in AutoCAD that allows you to flatten 3D Objects into a 2D drawing.
#08. Representing section cuts with solid fill in SketchUp: Another simple tutorial with images to get a nicer representation of the section cuts that SketchUp allows us to do very simple.
#09. Converting lines into tubes / cilinders in SketchUp: A post explaining the use of two different plugins that allow you to do this operation very fast.
#10. Mirroring objects in SketcUp: THree different methods to do the mirror operation in SketchUp. The oldest post (it dates back from 2008) to appear on this top ten list.
Show me more...
Català - Castellano - Deutsch
#01. List of SketchUp Plugins: A post dated from 2009 but that has been (or used to be, when I had teh time) updated regularly with all the SU Plugins I have reviewed on this site. It needs some link updating which I will do soon, but it is still the favourite post for most visitors to CAD Addict.
#02. Using AutoCAD autosave files to recover lost work: This post explains what can you do after one of those moments when apparently you've lost part of your work in AutoCAD. It is the post with the most number of comments and all of them positive, so it is the one that made my work here feel more rewarded. Thanks to all who spend the time wirting down a comment, good or bad, it's great to know someone is reading.
#03. Plugin to Make faces from lines in SketchUp: I have toc onfess I am a bit puzzled by this post being so popular. The plugin was very useful back when the version of SU was v.6 or so and the program was not very smart creating lines from a closed set of lines. I think this was pretty much solved in later versions of SU, but oddly the post keeps getting a lot of visits. If anyone knows why the info will be very much appreciated.
#04. Volume Calculator Plugin for SketcHup: A post explaining how to use this old plugin to calculate volume of entities in SketchUp. A simple post about a simple plugin but that has had a lot of visitors and comments during these last months.
#05. How to install plugins in SketchUp: This is simple tutorial on how to get your plugins working in SketchUp. Sometimes the posts you think are too simple become the most wanted ones.
#06. List of BIM Software and Providers: Back when I was writing my Master Thesis, I started researching on all the scope of providers that have Building Information Modelling related software. This posts gathers most of that info and organizes it in different categories. One think this post taught me: People love lists.
#07. Converting 3D objects into 2D drwaings in AutoCAD: THis post explains the use of the FLATSHOT command in AutoCAD that allows you to flatten 3D Objects into a 2D drawing.
#08. Representing section cuts with solid fill in SketchUp: Another simple tutorial with images to get a nicer representation of the section cuts that SketchUp allows us to do very simple.
#09. Converting lines into tubes / cilinders in SketchUp: A post explaining the use of two different plugins that allow you to do this operation very fast.
#10. Mirroring objects in SketcUp: THree different methods to do the mirror operation in SketchUp. The oldest post (it dates back from 2008) to appear on this top ten list.
Show me more...
Happy 2013 - End of year thoughts
The most innactive year comes to an end, hope next one is better.
Català - Castellano - Deutsch
2012 comes to an end. It's time to think about all those new year's resolutions and of course, after checking that I only posted 6 times on this blog in 2012, my new year resolution seems obvious, POST MORE. I already explained the main reason why I was not having time to blog at all here. Well, good news for the blog (not so much for me) the construction is over and I am temporarily back to office. It is a more relaxed sort of job I am doing right now, but of course not so interesting. So apparently it seems I will have more time after work (and more energy) to think on posts and to write them. That is my new years resolution. Of course, there are others, but can't publish them here ;-). On the mean time, I just want to say thanks to all readers who keep coming here on purpose or just by chance through a google search during 2012, you are my motivation to keep the blog active. Cheers and happy 2013 to all! I have though one good news coming soon, will post it already in 2013!
Show me more...
Català - Castellano - Deutsch
2012 comes to an end. It's time to think about all those new year's resolutions and of course, after checking that I only posted 6 times on this blog in 2012, my new year resolution seems obvious, POST MORE. I already explained the main reason why I was not having time to blog at all here. Well, good news for the blog (not so much for me) the construction is over and I am temporarily back to office. It is a more relaxed sort of job I am doing right now, but of course not so interesting. So apparently it seems I will have more time after work (and more energy) to think on posts and to write them. That is my new years resolution. Of course, there are others, but can't publish them here ;-). On the mean time, I just want to say thanks to all readers who keep coming here on purpose or just by chance through a google search during 2012, you are my motivation to keep the blog active. Cheers and happy 2013 to all! I have though one good news coming soon, will post it already in 2013!
Show me more...
Labels:
General
[Guest Post] MS Excel: How to find the corresponding value for a given entry
Using the VLOOKUP function in Excel
Català - Castellano - Deutsch
Another Guest post by my brother about Excel. Imagine you have this list, where each letter has a value Then you have a given list such as, and you want to have the value for each letter: You just have to write the following: =Vlookup(value you want to find; matrix where the value has to be found; number of column where the value is;”false” if you want to find the exact value) In our example, this would mean you write in Sheet 2, Cell B2 the following: =vlookup(A2;Sheet1!A:B;2;FALSE) And the result would be:
Show me more...
Català - Castellano - Deutsch
Another Guest post by my brother about Excel. Imagine you have this list, where each letter has a value Then you have a given list such as, and you want to have the value for each letter: You just have to write the following: =Vlookup(value you want to find; matrix where the value has to be found; number of column where the value is;”false” if you want to find the exact value) In our example, this would mean you write in Sheet 2, Cell B2 the following: =vlookup(A2;Sheet1!A:B;2;FALSE) And the result would be:
Show me more...
Labels:
Excel,
Guest Posts
[Guest Post] Some useful shortcuts for Excel
Some useful shortcuts for Excel. A guest post by my brother Jordi.Català - Castellano - Deutsch
This is a guest post by my brother Jordi. A list of useful shortcuts for MS Excel that will make your workflow much faster. Here they come:
Show me more...
This is a guest post by my brother Jordi. A list of useful shortcuts for MS Excel that will make your workflow much faster. Here they come:
- Ctrl+”+”: Add a new column or row. Click on the column/row where you want to add and press “Ctrl” and at the same time the “+”.
- Ctrl+”-“: Delete a new column or row. Select the column/row want to delete and press “Ctrl” and at the same time the “-”.
- F2: Modify a cell. When you are in a cell, press F2 and you will be able to modify directly the cell without the need to double-click it.
- F4: Repeat an action: When you want to repeat and action you just performed, press F4 and the last action you made will be repeated.
- F9: recalculate the values. Sometimes the excel sheet are put into manual calculation, if you want the sheet to calculate and show you the values, pres F9
- Ctrl + “up arrow”/“down arrow”: Move to the first/last line with values: Press Ctrl + “up arrow”/“down arrow”
Show me more...
Labels:
Excel,
Guest Posts
Subscribe to:
Posts (Atom)