Now 1ft³ = 28.31 liter,hence, total volume of tank in liter shall be 240 x 28.31 = 6794.4 liter. That means almost 6800 liter of water can be stored in the tank. Here is a quick video to show you How to calculate water tank capacity in liters?

As the government has decided to link aadhar cards with pan cards, the process of linking has started. Use following link to link aadhar card with pan card. Link Aadhar card
Share with your friends and family.

Data validation is a tool that reduces errors, it helps in making cells constraint to some particular values only.

MS Excel says " Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering data that is not valid."

That means, using Data validation, you are controlling the cell values. You can allow people to enter data of their choice, but warn them once when they try to add it in the cell. You can also provide messages to show what kind of input you want for the cell, and instructions to help them correct if any errors comes in.

So, the question is, when is Data validation be helpful?

To give answer to this question, i can say, whenever you want your choice in a cell, data validation will be helpful. When you share your workbook, you want a predefined format to be followed by in order to get the accurate results from the entries. In such a case…

Hi friends,
Let us learn about Vlookup function of MS Excel. If, you have a big table and you dont want to drag your mouse each and every time you need some value from that table, you can use Lookup or Vlookup or Hlookup. These are some of the best techniques of data extraction from tables.
Vlookup is used to extract data from a table, follow these steps to use it.

2. You will be directed to Add-Ins already present, in order to add new ones, press "browse" button.

3. Excel add in folder opens. Paste your Add-Ins here. and select the one that you want to add followed by OK. you will be redirected back to present add-Ins. press OK again.
4. Add-Ins are added.
To create a Customised Ribbon button for the Add-In that yo…

Creating a centerline drawing from a beam column layout and exporting it as DXF will help it to be imported in STAAD.Pro. You can create the centerline the way you want, but here we have shown a method which is a quicker one we feel. The ultimate choice is with you about how to make it.

Here is a quick way.

1. Create 4 lines at two opposite corners.
2. Use fillet multiple to join them. you have made the bounding box.
3. Create lines in center where the beams will be coming.
4. extend them to the bounding box. Your DXF is ready.
5. select all the centerlines you just created and move them with upper left corner to 0,0,0.
6. Now, if your STAAD.Pro units are different than the CAD, scale your centerline drawing to the appropriate scale factor.
7. write down "DXFOUT" command in command line. A saving window pops up. Select the location where you want to save your DXF.
8. Go to tools -- ooptions -- DXF outions -- Check mark select object and chaneg 16 to 3 or the l…

Sometimes, a quick tip saves so much time that we feel amazed. This is such one tip to save your hours in the future work. Selecting blank cells and adding value to is a repetitive work, and, if we can make this repetitive work a one time work, the time of all the clicks for repetition can be saved. But the question is how to do that? here is a way.
Here, we will be filling blank cells with the value of non blank cell above. That means each blank cell will be filled by the non blank cell value of above cell encountered first.

1. Select the column in which you want to fill the blank cells.
2. go to home -- Find and select -- Go to special.

3. Select blanks and press OK.

4. press "=" followed by upper arrow to add the formulae that write the value of above cell.

5. Press "CTRL+Enter" instead of only Enter.

6. Bingo, you have done it.

Watch out the video and learn to fill blank cells faster than never before.

Many a times we need to invert select files to delete them. We select files and CTRL+Selectand then again CTRL+Select and delete. But, what if you can select the files you want to retain and invert the selection so that you can delete the rest. Here is a way to do it.

Many a times we copy materials from PDFs. Those comes with line breaks, we have to manually remove all enters and join lines. But, no more we do it the same way. Follow the following procedure and removing it becomes a lot simpler.

Many a times you feel that i wish my snooze time be some more or some less so that i can sleep more or wake up earlier. You can, yes you can change the snooze timing in your alarm. Just follow the simple steps and change the snooze timings.

1. Open the Alarm app.2. Go to setting, click on snooze length and adjust as you want.
3. Enjoy the sleep. Good night.

Here is a video showing snoozing in android 5.1.

Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.

Now you don't need to have two remotes to operate TV and Tata sky. To make Tata Sky remote work for your TV, just press univ button on your Tata Sky remote and use it as a TV remote.Functions that can be used with tatasky remote includes on/off, mute, volume and input mode.
To program Tata sky remote to work for TV, follow the following steps.
1. Press and hold select+2 button on Tatasky remote until LED blinks twice. Your Tatasky remote is now on learning mode.
2. Put Tatasky remote and TV remote 5cm apart and in front of each other such that LED of both the remote face each other.
3. Press Volume+ button in Tatasky remote, then on TV remote. Tatasky remote will blink twice.
4. Your volume+ key is programmed. Repeat step 3 for all the other keys viz. Volume-, power,mute,source buttons.
5. Press select button to come out of learning mode.
Enjoy.

Sometimes, when you run an AutoCAD command that usually displays a file selection dialog window, you instead receive a prompt at the command line. You find it cumbersome to save the file to a particular place or select a particular file in such case. This is because FILEDIA variable is by default became 0. Follow the following procedure and you will be seeing the file selection window.

Regardless of operator, if you'd want to stop all the promotional calls and sms, follow the following procedure and enjoy the undisturbed services.+ Type "START 0" and send to 1909. Its done.
+ call 1909 and follow the IVR. Keep reading tinytopic.

Backup files in STAAD are saved as .SBK file type. You can take as many time interval backup as you want. More over you can compare two backup models for changes being made. You can set predefined time intervals at which model can be backed up. By default backups are saved in the folder where model is saved. You can change that too. For opening backup manager, start STAAD and in project task open backup manager. Set no. of auto save backups and time intervals for the same. Set no of manual save backups, keep backups as less as you need. Because, that consumes disk space. If you are a new modeler, you should be saving more backups, but if you are an expert, you might need only 3 to 5 backups, that is too much for the experienced STAAD user. Set backup directory, by default the project directory is the backup directory. You can change the backup directory by un checking the project directory option and specifying the directory path for the backup. One should have a different backup folder…

Many a times you need element information for better interpretation or in use of something viz, putting coordinates of nodes in area load assignment, finding beam length etc. At that time you click on it and get the information about elements. But, what if you hover over an element and get its number and other related information? It’s a good idea indeed, right? Yes, it is possible. Just follow the following steps and you can get all the element information you need just by hovering over it. 1. Go to view menu and click on structural tool tip options.

2. Select the element in the tool, in options column, click right all the information that you want at the time of hovering.

3. Set tip delay as you want the tool tip to show after milliseconds. 4. Press ok and hover over an element and see the information you needed.

Many a times we encounter problems of solving equations within spreadsheet for engineering calculations. Suppose you want to solve n²-3n+1.5674 = 0, and want to find answer of the same in the middle of your engineering sum.

There are two options available in excel for the same.1.You can use goal seek. Follow following procedure for using goal seek.

As shown in picture above you want x value for f(x) being 0. a.Go to Data -> What if analysis -> Goal seek

b.In set cell provide cell reference of F(x) (you want F(x) to be 0, right?) c.In to value type 0. d.In by changing cell provide cell reference of cell of x (you want value of x for which f(x) becomes 0.) e.Press ok and see the result. f.As we know it should give us two options for which f(x) becomes 0. But, goal seek provides least value for which f(x) becomes 0.
2. You can use solver option for the solution. a.Go to data -> Solver (if you can’t find solver in data menu, go to options->add ins->Excel add ins -> solver add…