Skip to main content

Posts

Showing posts with the label How to Guide

How to calculate water tank capacity in liters?

Let us suppose your tank dimensions are 
L = 8ft B = 6 ft D/H = 5 ft
Then your volume of tank will be 
8 x 6 x 5 = 240 ft³


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?

How to use data validation in MS Excel?

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…

How to use Vlookup in MS Excel?

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.

How to load add-ins and make a customised ribbon button for it?

Hi,

Add-ins are the custom functions/commands/formulae or macros stored in an external file which can be used in any excel file to increase productivity.

In order to use Add-Ins, you should be allowing the add ins. to do that follow this steps.


1. Go to file -- options -- Trust Center -- Open trust center settings.



2. Go to Add-Ins tab -- Un-check all the tick marks of disabling add ins. If you want Add-Ins to be signed by trusted Publisher, check first option ticked.


3. Press OK. 
Now, to add the Add-Ins Follow these steps. 
1. Go to File-- Options -- Add-Ins -- Manage -- click on "Excel Add-Ins" -- press Go. 

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…

How to make DXF in Autocad and import DXF layout in STAAD.Pro?

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…

How to fill out the cells with the value of cell above in excel?

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.



Hope you find it useful. Comment if you have doubts o…

How to Invert Select files in a folder in Windows 7?

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.

1. select the files you want to retain.




How to remove Line breaks (enters) from a paragraph?

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.

1. Paste the material to your word file. It looks like this.







How to remove field background in Autocad?

Many a times we use fields in the texts in Autocad drawings. By default the field background comes grayish white. It annoys us. We want to remove it as soon as possible. Here is how it looks like.



You can remove this background by setting fielddisplay value to 0.

Just type fielddisplay and it will be showing value 1, change it to 0 and press enter. you can see the difference. Here is how it looks like after setting fielddisplay value to 0.




Some more topics you may like to read

Shortcuts of Autocad.Basic Commands in Autocad?How to write text below Dimension line?How to see the dialogue box in Autocad?How to set units' format and precision?
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.

How to write text below dimension line in Autocad?

Here is a simple way to write text below dimension line. Just press \X (Backslash followed by capital x) and type your text. You have written text below dimension line. Here is how it looks like.



Some more topics you may like to read
Shortcuts of Autocad.Basic Commands in Autocad?How to see the dialogue box in Autocad?How to set units' format and precision?How to remove Field background? 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.

How to adjust snooze timing in alarm of mobile?

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.

How to program Tatasky remote to work for TV?

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.

How to see dialog window in Autocad?

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.

To display a dialog window when using the Open, Save As, etc. commands:
On the command line in AutoCAD, enter FILEDIA. Enter 1 for the value.Enjoy.
Some more topics you may like to read
Shortcuts of Autocad.Basic Commands in Autocad?How to write text below Dimension line?How to set units' format and precision?How to remove Field background? 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.

How to take backup of your model in STAAD.Pro.?

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…

How to change Structural tool tip options in STAAD.Pro?

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. 



5. Enjoy STAAD.
Some other STAAD Pro topics you may like to explore :


About Nodes, Beams and PlateCreate DXF file for importing in STAAD Backup…

How to change default units in STAAD.Pro?

We generally use metric units for analysis and design. You can change the default unit of STAAD as per your preference. Follow the method shown below to change the default units of STAAD. 

1. Click on configuration in main STAAD window.

2. Open base unit tab.



3. As you can see the default units are metric, change them to English/metric as you prefer. 
4. Enjoy.
Some other STAAD Pro topics you may like to explore :



About Nodes, Beams and PlateCreate DXF file for importing in STAAD Backup ModelTooltip OptionsAxis ColorExtend BeamRenumber NodesRenumber BeamsRenumber ColumnsShortcuts of STAAD ProChange default design CodesHope 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.

How to solve equations in Excel?

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…