My Computer Dummies

Calculate body mass index (bmi formula) in excel 2007

2012-02-28T18:20:00.001-08:00

How to calculate ideal body weight in Excel 2007. With using microsoft excel we can calculate an ideal body weight which refers to the formula for calculating ideal body weight according to Body Mass Index. Body Mass Index (BMI) is an ideal weight calculation is based on the formula: BMI (BMI) = Weight (kg) / (height (m) x Height (m) If the index has been obtained from the above calculation, the

How to make a sine graph in excel 2007 (plot sine wave)

2012-01-22T18:53:00.001-08:00

Make a sine graph in excel 2007 (plotting sine wave on Excel).By using Microsoft Excel, we can easily create a graph sine, cosine graphs, charts and graphs tangent of the other trigonometric functions. Specifically discussed in this post about how to create charts in Excel sinuses that might be useful for beginner friends. To create a graph of sin in Excel 2007, following procedure below: 1.

Create cosine graph/plot cosine wave in excel

2012-01-22T18:09:00.001-08:00

With Using Microsoft Excel, we can make a variety of curves from mathemathic functions such as trigonometric functions : sine curve, cosine, tangent, hyperbolic sine (sinh), cosec (cosecant), sec, etc.. In addition trigonometry function can also be made logarithmic curve, the exponential curve, linear curve, the curve da various other mathematical equations. Basically to make a curve of

How to find the matrix A if we known of Leontief matrix

2011-11-21T01:40:00.000-08:00

How to find the matrix A if we known of Leontif matrix. This post is a continuation of my previous post about the Leontief inverse matrix, as well as to answer questions friend about the inverse matrix, which asks you about how to calculate the matrix technology if we known the Leontief inverse matrix. If we let the technology matrix is a matrix A, and L is the Leontief inverse matrix. L = (I -

How to calculate Leontief matrix in excel

2011-11-21T01:05:00.000-08:00

Calculate the Leontief matrix in excel. Leontief matrix is a matrix that is the inverse of identity matrix minus matrix A. Leontief matrix is widely used in making the simulation or quantitative input-output analysis. In mathematical equations used to define the matrix Leontif are: L = (I - A) -1 where: L = matrix inverse Leontief I = Identity Matrix A = matrix A By using Microsoft Excel, if

How to calculate logarithm addition and logarithm multiplication in excel

2011-11-21T00:33:00.000-08:00

How to calculate logarithm addition and logarithm multiplication in excel. By using Microsoft Excel, in addition to calculate logarithm reduction and log division. Can also be done multiplication and addition of logarithms. In this post the process of logarithm addition and logarithm multiplication refers to the properties of logarithms as below: ª log a = 1 ª log 1 = 0 ª ⁿ = n log a ª ⁿ log b

How to calculate logarithm reduction and log division in excel

2011-11-21T00:09:00.000-08:00

How to calculate logarithm reduction and log division in excel. By using Microsoft Excel, we can perform the calculation of logarithms. In this post specifically discussed about how to use a logarithmic reduction formula and the division of the logarithm. In general, how to write formulas / functions in excel logarithms is using syntax: LOG (number, base) with: Number is the positive real

Calculate circumference of a circle in excel

2011-10-18T23:18:00.000-07:00

With using excel we can find circumference of a circle. If we know the radius value, diameter value or area value then we can calculate and find circumference of a circle. There are some formula to calculate circumference of a circle in excel, is defined on below table : With : A = area of cirle r = radius of circles d = diameter of circle C = circumference of cirles For more detail, you can

How to Calculate the Area of a Circle

2011-10-18T22:49:00.000-07:00

A circle is one of the geometric shapes, sometimes we need to calculate the radius, diameter, area or circumferences of circle. With using excel we can find the radius, diameter, area or circumferences of circle using formula below : For example :1. Create table belowThere are 3 cell contain data . a. Cell B5 is a radius dataIf we know radius value, then we can calculate the area of circleb.

Free audio converter amr to mp3/wav, wav/mp3 to amr

2011-10-07T06:22:00.000-07:00

Amr audio file format was first made for mobile, if the amr file to be run on a computer requires a software amr player, or can also be a way to convert audio files into mp3 format to audio files can be read on the mp3 player like winamp or windows media player. This amr converter software now widely available on the internet with a variety of character types licence from free (freeware) or paid

Feature Specification and Limits of Microsoft Excel 2007

2011-10-07T05:01:00.001-07:00

There are some new feature of Microsoft Excel 2007, but every feature has specification and limits, such as : a. Worksheet and workbook specifications and limits b. Calculation specifications and limits c. Charting specifications and limits d. PivotTable and PivotChart report specifications and limits e. Shared workbook specifications and limit For details every Specification and Limits , we

Microsoft Excel Tutorials

2011-10-07T05:01:00.000-07:00

Microsoft Excel is a powerfull spreadsheet application that can be use for calculation of dataset, create graph, make pivot tables, and customize procedure calculation using a macro programming language called Visual Basic for Applications. Below there are some tutorials microsoft excel 2003 and 2007 for beginner. Introduction 1. Error 16 digit number in excel 2. List of error or bug in

What's new in Microsoft Office Excel 2007

2011-10-07T04:59:00.000-07:00

Microsoft Office Excel 2007 provides powerful tools and features that you can use to analyze, share, and manage your data with ease There are some new feature in Microsoft Office Excel 2007, such as : 1. Results-oriented user interface with ribbon menu The new results-oriented user interface makes it easy for you to work in Microsoft Office Excel. Commands and features that were often buried

How to create horizontal navigation bar using css script (drop down menu version)

2011-09-16T06:32:00.000-07:00

oOne of the horizontal navigation menus are created using css and html scripts that can be put on the blog is a horizontal navigation menu / dropdown menu. As the picture below: In this tutorial we will build the navigation bar from a standard HTML and css script list. A navigation bar is basically a list of links, so using the <ul> and <li>elements tag : There are two steps to making the

Calculate angles using the arcsin, Arccos, arctan in excel 2007

2011-07-28T19:49:00.000-07:00

Arcsin function is a trigonometric function that is used to calculate the inverse sinevalue, while the arccos are inverse cosine function, and atan is the inverse tangent function. This function is an inverse function of sin, cos, tan. In general, writing formulas in Excel can be seen below syntax: arc sine ---> ASIN (number) arc cosine ---> ACOS (number) arc tan -----> ATAN (number) Note: a

Free primes number calculator (freeware)

2011-05-16T17:03:00.000-07:00

Software primes number calculator is a freeware software can be used to calculate the prime numbers or search and generated primes numbers in any intervals. Software prime numbers is very simple and could be an alternative for users who have difficulty calculating prime numbers. To use this software is to enter the interval value of numbers in the Input Range, and click the "calculate prime

How to chat multi ID YM (Multi login Yahoo Messenger )

2011-03-25T03:21:00.000-07:00

How to chat multi ID Yahoo Messenger (Yahoo Messenger Multi login). Today we will try to use a free software (freeware yahoo messenger tweaking). This software can perform some configuration on IM applications so that we can open more than one Yahoo Messenger application simultaneously in a same computer, so can chat on ym with multi login using the Yahoo ID from a different email. There are

Blender free software 3D content creation

2011-01-13T20:12:00.000-08:00

Blender is the free open source 3D content creation suite. Blender is a powerfull 3D Software for modeling - shade - animate - render - composite - interactive 3d Blender's animations systems supports a variety of techniques and tasks, allowing the creation of complex animations. OS Supported Platforms : Windows 2000, XP, Vista, Mac OS X (PPC and Intel), Linux (i386, SGI Irix 6.5, Sun

How to Fix dead pixel on LCD monitor (dead pixel repair)

2010-12-21T22:01:00.000-08:00

How to Fix dead pixel on LCD monitor (dead pixel repair). For users of LCD monitors, sometimes comes a point at which the screen can not display color properly. Dots on the screen is sometimes the color is just the same as changing the monitor display. So often reduces the quality of the display. The point at which the broken screen usually called Dead pixel or Stuck Pixel . We can fix dead

Add url Baidu (submit blog to Baidu and increase visitors from china)

2010-11-18T05:52:00.000-08:00

Add url Baidu (submit blog to Baidu and increase visitors from china). Baidu is China's largest search engine. In China, Baidu is more popular when compared to google. Based on data from Alexa rank, looks Baidu ranked first in China, and ranked 6th in the world .. In China google.com.hk only ranked 5th. Baidu website description details can be seen below: About Baidu.com (baidu.com): The

Add url to Yandex (submit blog to Yandex) to increase visitors from Russia

2010-11-14T09:35:00.000-08:00

Add url to Yandex (submit blog to Yandex) to increase visitors from Russia. Yandex is the largest search engine in Russia, based on data from Alexa, especially from Russian Internet users look Yandex more popular than Google, Yahoo, Bing. Yandex is in position 1 while google.ru is at position 4. can be found here Top Sites in Russia According the data from Alexa 85% Yandex users come from Russia

Convert Decimal to Octal

2010-11-14T08:42:00.000-08:00

How to Convert from Decimal to Octal. By using Excel 2003, the decimal number can be converted into Octal (decimal to Octal). However, the function to convert decimal numbers to Octal has the some limitations of which can be seen in the syntax and description below: Syntax DEC2OCT(number, places) Number is the decimal integer you want to convert. If number is negative, places is ignored and

Convert Decimal to Binary

2010-11-14T08:35:00.000-08:00

How to Convert from Decimal to Binary. By using Excel 2003, the decimal number can be converted into binary (decimal to binary). However, the function to convert decimal numbers to binary has the some limitations of which can be seen in the syntax and description below: Syntax : DEC2BIN(number,places) Number is the decimal integer you want to convert. If number is negative, places is ignored and

How to download ebooks on google books using google book downloader user script

2010-11-08T02:51:00.000-08:00

How to download ebooks on google books using google book downloader user script. Using google book downloader user script and greasemonkey is one alternative for Firefox users to download books from google book. This method is a complement of the previous ways on how to download book on google books and download the ebook in google book using firefox cache In this post we use an add-on firefox

How to install Google's book userscript downloader in firefox to download ebook from google book

2010-11-08T02:33:00.000-08:00

How to install Google's book userscript downloader in firefox to download ebook from google book .After the add-on greasemonkey installed on your computer, then the next step is to install Google's book userscript downloader in firefox. To install Google book downloader userscript following procedure: 1. Open firefox 2. Open the following pages Google book downloader userscript Click the "