Show the last save date and time in a cell automatically with VB code
Show me more...
Top Visited Posts in 2012
2012 SummaryCatalà - 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...
[Guest Post] MS Excel: How to find the corresponding value for a given entry
Using the VLOOKUP function in ExcelCatalà - Castellano - Deutsch
Another Guest post by my brother about Excel. Imagine you have this list, where each letter has a value
Show me more...
[Guest Post] Some useful shortcuts for Excel
Some useful shortcuts for Excel. A guest post by my brother Jordi.Català - Castellano - DeutschThis 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...
[Updated Old Post]: AutoCAD Image Frame
Settings for image frames in AutoCADCatalà - Castellano - Deutsch
This is an updated verion of a previous "guest post". I've been asked to remove that post, but since the topic is relevant I will just summarize it here.
Images in AutoCAD have frames (even if you don't see them). Playing with the "IMAGEFRAME" system variable allows you to toggle from seeing or not seeing the frame. THe three settings for the IMAGEFRAME system variable are these:
If you set it to 0 it means the frame is completely off (not seen nor printed), setting it to 1 means the frame is on (seen and printed), and finally setting it to 2 means that the frame is on in the drawing, but it will be off in when you print.
Also, you can switch from Visible (number 1) to invisible (number 0) frames by using the TFRAME command. It doesn't allow to control the variable to set it to number 2 though, but this gives you the flexibility to switch on and off the frames quickly.
Show me more...
Ferrovial's Handbook Against Waste [1962]
A Handbook against "waste" dated back from 1962.Català - Castellano - Deutsch
Recently, I got news of the realease of the "handbook against waste" written as an internal document for Ferrovial (one of the biggest general contractors in Spain). I had heard of this docuemtn for a while but had not had the chance to read it. Now it is available for everyone from this link. [The handbook is in Spanish]. I am also keeping here a mirror copy just in case the link goes down and I am not available to update it. Click on the image below.
It is a very interesting read, and what is specially interesting is that it dates back to 1962. Sometimes we tend to think that all the fuzz about Lean, Last Planner or Location Based Scheduling is something new that just came out of nowhere just a few years back. This handbook is the proof that some companies and many professionals have worked with better standards and processes for a long time, they just didn't publish it openly. Competition is fierce in the construction sector, and maybe this fierce competition is what for a long time has made it impossible for companies to share their knowledge and improve so the Construction Industry as a whole. Luckily, I think the internet and the advent of Social Media, has changed this, and more and more companies are sharing part of their better processes. I am back! ;-)
Show me more...
The reason i am not blogging
Can't find the time to blog sorry, too busy.Català - Castellano - Deutsch
Been to busy recently to keep on blogging, the reason? Last december I prepared a presentation for a project we were bidding to be the general contractors, and it seems the presentation was good enough to win the bid. You can see part of the presentation below.
SO now I am the Project Manager on site, dealing with all subcontractors, writing contracts, controling costs, taking care that we keep on the tied schedule we have, all that! So no time to blog at all other than this few lines 2 months after the last posts. At some point I'll be back, can't tell you when yet. Hope you don't leave the blog forever.
Show me more...
Subscribe to:
Posts (Atom)