DESIGNMEP

 SEARCHABLE DROPDOWN LIST =FILTER(A2:A32,ISNUMBER(SEARCH(D1,A2:A32)) VLOOKUP: TO MATCH THE DATA WITH THE TEXT IN THE TABLE AUTOMATICALLY   Application of VLOOKUP: To compare two sheets for values and Extract data from them. =IFERROR(IF(C13<>0,VLOOKUP(C13,'RB-1'!$C$5:$M$44,11,0),""),"") if error→ eliminates #NA display If condition→ checks for blank cell and display the data extracted by VLOOKUP  which matches C13 table in given sheet at 11th column. If incorrect display nothing. 0 means exactly at the same row.   INDEX function: Extracts data from the table address denoted by Match Function MATCH Function: Shows the address of the cell, not data, containing the data.  Compare Two sheets For differences:  For example, if you sent the quotation and the clients send the last edited sheet for agreement, compare the one you sent and they said they agreed. Sometimes, they twist the words within.  One option we have is to view side by side.  ...

  Management of projects/ company/ life or anything that is manageable: Business should not run around you but your customer, your product and your highest vision. don't die for it because one day there will be no person to   love it and look after it for the business you die for today. To open a company, in my thinking, either there is opportunity you see which is yours for sure if you want or there is a tool you already have which you can push a little harder to function and make the plans ready for it to succeed. BE CLEAR, KNOW WHY ARE YOU DOING WHAT YOU ARE DOING, DON’T USE OVERQUALIFIED FOR UNDERVALUED WORKS,   LEARN FROM WHO THINKS THEY ARE EXPERT, ASK SUGGESTIONS FROM THEM, ALWAYS TRY TO IMPROVE IN EVERY PROCESS, GIVE VALUE MINIMIZING THE EXPENSE. Don’t hire just because you wish it will scale to large company. Do when it really does. 30% increase of quality even in the start is better than 100% later because later means later and we cannot guarantee it. Ma...

It is common to many of us, who are working as a site engineer, to not know how to run the sites and execute the plan anymore. We come across Variety of Problems like economic problems, Materials shortage, lack of proper knowledge and not knowing what to do anymore.  So, been through such problems, I have come up with some of the common solution we must be aware before running any activities in sites. WORRY ABOUT THE WORK, NOT THE PEOPLE: Don’t Ask the Employee or workers, where are they? Ask them, “is the work done?” Because, they are hired for the work. Not the location. While design o    Not more than required o    Not less than necessary o    Always focus on goal in each step and ask: does this provide the required output? o    Does this reduce the material consumption providing the quality without compromise? o    Does it affect the other that depends on it? Eg. Light depends on hvac installation. o    Will the design...

Among Many Methods, there are several which has been proved effective. 1. Feynman Rule's of Learning 2. Elon Musk's Rule of Learning 3. Create Feedback Loop: Think of Any topic. Start understanding. If its non destructive and low costly, you can even start doing what you are learning. So, you will understand if it is working or not. It will give you feedback loop and help you understand it deeper.  4. Know beforehand what you want to Understand at the end: Always focus in the end point of your seeking. So, you will not diverge from what is essential at the end of the project. Know what you want. So, you don't have to be overwhelmed by the information. 5. Learn from Experts: Lastly but not least, pulling force is always less than the pushing force. So, let someone with expertise explain you what you want to know. It is the best way to learn.

Are you tired of trying to hard trying to save project or goals from falling apart? I was. So, I have come up with some ideas that will help in managing the stress retaining the efficiency your work demands. Below I have listed some of them. If you have some, let me know in the comment section. 1. To make any work efficient,  Break down the work into many smaller steps.   2. Which steps are repeated often? Try to automate or use easier tools for the work. 3. Which Steps requires more time and attention? Use efficient tools and manpower. 4. There are some items or actions that may seem insignificant but the work cannot be moved forward without them.  5. Make the decisions regarding the things that take a long time. For example, if the project needs airplane after some months and You need to order from others. Otherwise, the decisions will linger and it will be out of our control.  6. Create work schedule for the works and break down the work for example, if the p...

 If you fear, you will get angry, it will create the hate and it is violent.  People fear what they don't understand and hate what they can't conquer. It is a famous saying which is applicable in any field. Not just MEP but every field. So, if you are entering into the business field and don't know what you are getting into, it might get messy.  you will get paranoids over time.  So, understand the following aspects that you should know before starting.  1. Understand the government duties and taxes. Vats and customs tarriffs.  2. Understand the technical aspect in very minute details or know someone who can be trusted to handle any situation. 3. Understand that clients will not pay the money timely. Know that they will not pay when you demand. you will have to bear the interest rate for the money that was used for Clients. It may even surpass the profit from the clients. 4. You are in search of the money. So, you will meet rich people. Rich people are gree...

 I have been on the construction field since the beginning of my carrier. And since the day, I have been provided with the various responsibilities and experiences. 10 things I would like to suggest are as follows: 1. Don't Panic. If you have money, everything will be solved. It is money, that pushes everything and work will be 10 times easier if you just add 20% more money in the project. Sometime this thought can make you relaxed. 2. When the employee points the problems, don't ignore it. When they are used to being ignored, they unconsciously develop the tendency to not care about the problems. So, respond whenever employees points to the problems.  3. Know what you are doing and break down into many small steps, plans.  4. Break down the expenses into visible ones so it becomes clear where it goes, why and how. LEARN the alternative ways so the expenses can be reduced. Make it legal, make it authentic. 5. Give the workers the clear direction on the role. Don't make en...