Skip to main content

Posts

Multi purpose Calculator in Excel

Do you know excel can have calculator button which includes:   Standard calculator   Scientific calculator   Programmer calculator   Statistics calculator   Date calculator   Loan calculator   Fuel economy calculator   Vehicle lease calculator    Converter But, it is not being included in the ribbon. To include the calculator in the quick access toolbar follow the steps as shown. 1. Go to file menu. 2. Click on options à quick access toolbar. 3. In choose Commands from list, select commands not in the ribbon. 4. Select calculator and add. 5. Click  OK  and you will find the calculator symbol on the top ribbon.  Happy excelling. 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.

App review: Snap2door

About: In this smart generation, we used to take snaps on the go more and more, some of which are precious. We often think to have  hard copies of them. But, we lack time to do so. This app helps you do so. very simple and straight forward approach to photo printing. no more or less functions. It gives you only 3 functions, select the photos, select sizes, pay and your order placed. 2 minute work only. After 4-5 working days, you get a gift of your precious moments. Enjoy the best of smarter world. Functions : Very nice and simple. They should have given share this app button. I wanted that one. Pros: many pay options. discounts being given as flat. Cash on delivery too. You can select photos from social sites as well. you can print photos in any size you want. photo collage is also being done. Cons: Not found yet, i found the app very nice one. no junk, no adds, nothing that you don't want and placed. Ratings: 4.5/5 (0.5 for less for not giving share button) Enjoy th

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 Plate Create DXF file for importing in STAAD  Backup Model Tooltip Options Axis Color Extend Beam Renumber Nodes Renumber Beams Renumber Columns Shortcuts of STAAD Pro Change default design Codes 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 change default design codes in STAAD.Pro?

Many a times we start modeling in STAAD and then see input file, oops the member property are shown as American or of some other country. Why didn’t it is Indian as I am in India and designing as per Indian codes? For that, you have to make default design codes preferences to Indian. Follow the following method to do so.  1. Click on configuration in main STAAD window. 2. Open STAAD default design codes tab. 3. As you can see the default codes are American. 4. change them to Indian.  5. Enjoy. 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 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

How to extend beam in STAAD.Pro?

In previous article we saw how to extend beam in ETABS, now let us see how to extend beam in STAAD. Following are the steps to do the same. 1. Select the beam line which you want to extend. 2. Go to geometry → Stretch selected member command. Or select the button shown in the red box which is the shortcut for stretch member command.  3. Tick on “To an existing member” and select the cursor shown against it. 4. Select the member up to which you want to extend the line. 5. Your beam line is extended to the existing member. 6. If you want to extend up to an existing node, tick on “To an existing node” and select the node to which you want the beam to be extended. 7. Enjoy STAAD. Some other STAAD Pro topics you may like to explore : About Nodes, Beams and Plate Create DXF file for importing in STAAD  Backup Model Tooltip Options Axis Color Change Default units Renumber Nodes Renumber Beams Renumber Columns Shortcuts of STAAD Pr

How to Extend a line in ETABS?

Many a times we need to extend beams to the perpendicular beams some distance away. In ETABS, we have to follow a procedure to do the same. Following are the steps you need to do in order to extend a line. Select the line and the end point of the side you want to extend along with the line up to which you want to extend.      Go to Edit → Align points/lines/edges →extend line object → OK.   Line is extended.    you may also like to read How to extend beam in STAAD Pro.? 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.