Life/Tech/Ideas
On a previous article, dated 2 years ago, I explained how to automatically print to pdf a sheet, with a press of a button.
This one is the part 2. It is a tutorial of “how to print multiple pdf files from populated tables” in excel, with the help of VBA.
I wrote the code in 2018 and since then it has saved me (or the company I work for) a massive number of working hours (or weeks to be more precise).
(more…)You are working in your highly automated super excel spread sheet that you have created. After all these months of additions and formulas, cell updates and tests you are there! You finally mad your spread sheet fully automated that produces alone cells, numbers, prices and data that would take days to calculate them manually.But…
Something is missing… (more…)
As Estimator/QS I often have the need for quick and accurate measurements. The main tools I use are AutoCAD and MS Excel.
As it is well known Autodesk stopped selling AutoCAD as a program and it charges it as a service. That means that every year you have to pay an amount to Autodesk to use its service. It is a trend the latest years and the result is that the user doesn’t own the program if he/she decides to stop paying for the service.
That led me to search for an AutoCAD aternative that could be user friendly to an AutoCAD user, would have the same commands and the almost the same interface. Also, I was searching for a program that supported native DWG files to be sure that I would not have any conflict with files produced from AutoCAD.
There were many programs that I tried (ie BricsCAD, NanoCAD etc) but decided to stick with ProgeCAD for many reasons. (more…)