This blog is for Construction Professionals wherein I learn and share Project Management and Green Building Concepts. If you are passionate about learning and updating your Construction and real Estate related knowledge along with MS Excel and MS Project Skills just hang on..
a default, you can fill in just any text or Number etc. in any cell of your
and solutions however demand reliability.
The Data validation feature just does that. For example you might want
to dictate the following rules to your electronic measurement book.
Using Excel Solver Feature to analyze and optimize the Steel Truss Design. If you are a Structural Designer and an advanced excel user, you might have or would like to use Solver Add in in Excel to optimize various designs.This feature is a paradigm shift from one way traditional design methods. Here, you make Excel try numerous design options/ possibilities till it meets all codal provisions for safety etc. and is also most economical. But I would like to warn the new professional that there is no substitute to getting deep into the design process and asking right questions from the professional peers and industry stakeholders. For why you should design with excel please refer to my previous blog at http://www.ashutoshp.in/2014/01/why-design-using-excel.html
This blog published automating construction billing during 2013. It is tried and tested and customises, nested ifs, data validation, Vlookup and workbook protection skills to meet the accounting department's requirements. Excel since then has transformed into analyzing and visualizing the big data. Construction projects have also transformed. 2013 was the time when the dashboard became fashionable, it served the purpose. Now is the time for low code, no-code development — dashboard remains in the front but the real value and not just automating a semi-manual billing that was inherited; what present-day site monitoring and management requirements are much beyond. Construction quality and safety as demanded today can be met by freeing the site engineers from all possible non-related activities. And meeting the requirements of construction data mining.
For Construction billing of buildings Many ERP Solutions Require. 1. Tower wise data (Required). 2. Unit wise data (Required but may be relaxed ) Additionally the best billing practices (Procedure) require the process to be: 1. Simple & easy to work with and understand. 2. Transparent and Electronically Audit-able. 3. The important data such as BOQ item rates and material coefficients etc. should be tamper-proof . HOW EXCEL CAN HELP? A few of Excel tricks can make you achieve all the above and more. This tutorial shall help you to achieve the best construction billing practices which are essential for effective SAP implementation and utilization of the data for project related time and cost analysis for Project Monitoring & Control. The good news is that you need not change your computer hardware or billing engineer though faster computer would help. It is assumed here that your billing engineer is already preparing the bills using