tag:blogger.com,1999:blog-1496237119618989842017-02-20T02:55:25.508-08:00My Computer DummiesArticles and tutorials about blog, internet and computerComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.comBlogger197125tag:blogger.com,1999:blog-149623711961898984.post-68126383761477960382012-02-28T18:20:00.001-08:002012-03-15T23:22:09.374-07:00Calculate body mass index (bmi formula) in excel 2007How 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, theComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-8577483293067702982012-01-22T18:53:00.001-08:002012-03-15T23:22:31.241-07:00How to make a sine graph in excel 2007 (plot sine wave)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. Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com2tag:blogger.com,1999:blog-149623711961898984.post-63637581216091126572012-01-22T18:09:00.001-08:002012-03-15T23:22:52.210-07:00Create cosine graph/plot cosine wave in excelWith 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com1tag:blogger.com,1999:blog-149623711961898984.post-8880538765904705512011-11-21T01:40:00.000-08:002012-01-22T18:12:48.592-08:00How to find the matrix A if we known of Leontief matrixHow 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 -Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com3tag:blogger.com,1999:blog-149623711961898984.post-49365977122455994782011-11-21T01:05:00.000-08:002011-11-21T01:06:29.666-08:00How to calculate Leontief matrix in excelCalculate 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com3tag:blogger.com,1999:blog-149623711961898984.post-42215807250869020832011-11-21T00:33:00.000-08:002011-11-21T00:33:57.367-08:00How to calculate logarithm addition and logarithm multiplication in excelHow 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com3tag:blogger.com,1999:blog-149623711961898984.post-18471210407298772532011-11-21T00:09:00.000-08:002011-11-21T00:11:22.258-08:00How to calculate logarithm reduction and log division in excelHow 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-57888536214169964192011-10-18T23:18:00.000-07:002011-10-18T23:18:03.316-07:00Calculate circumference of a circle in excelWith 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 canComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com3tag:blogger.com,1999:blog-149623711961898984.post-45720408630425205242011-10-18T22:49:00.000-07:002011-10-18T22:49:51.842-07:00How to Calculate the Area of a CircleA 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.Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com1tag:blogger.com,1999:blog-149623711961898984.post-87039747812060621022011-10-07T06:22:00.000-07:002011-10-07T06:22:02.693-07:00Free audio converter amr to mp3/wav, wav/mp3 to amrAmr 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 paidComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-34472954088011765762011-10-07T05:01:00.001-07:002011-10-07T05:01:51.851-07:00Feature Specification and Limits of Microsoft Excel 2007There 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-56257894349433134452011-10-07T05:01:00.000-07:002011-10-19T01:47:12.766-07:00Microsoft Excel TutorialsMicrosoft 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com3tag:blogger.com,1999:blog-149623711961898984.post-90291123334161418682011-10-07T04:59:00.000-07:002011-10-07T04:59:55.513-07:00What's new in Microsoft Office Excel 2007Microsoft 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-35273482454489209012011-09-16T06:32:00.000-07:002011-09-16T06:49:02.134-07:00How to create horizontal navigation bar using css script (drop down menu version)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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com2tag:blogger.com,1999:blog-149623711961898984.post-8731904887647468242011-07-28T19:49:00.000-07:002011-10-07T00:10:19.686-07:00Calculate angles using the arcsin, Arccos, arctan in excel 2007Arcsin 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: aComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com2tag:blogger.com,1999:blog-149623711961898984.post-45322654177747215372011-05-16T17:03:00.000-07:002015-10-13T22:08:47.698-07:00Free primes number calculator (freeware)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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com5tag:blogger.com,1999:blog-149623711961898984.post-53082755225409123892011-03-25T03:21:00.000-07:002011-03-25T03:21:41.912-07:00How to chat multi ID YM (Multi login Yahoo Messenger )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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com4tag:blogger.com,1999:blog-149623711961898984.post-28929145537192871862011-01-13T20:12:00.000-08:002011-01-13T20:18:10.347-08:00Blender free software 3D content creationBlender 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com7tag:blogger.com,1999:blog-149623711961898984.post-65185850434245544302010-12-21T22:01:00.000-08:002011-10-03T05:59:26.093-07:00How to Fix dead pixel on LCD monitor (dead pixel repair)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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com1tag:blogger.com,1999:blog-149623711961898984.post-55389374423356083982010-11-18T05:52:00.000-08:002010-11-18T05:54:46.082-08:00Add url Baidu (submit blog to Baidu and increase visitors from china)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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com19tag:blogger.com,1999:blog-149623711961898984.post-8787335932243785072010-11-14T09:35:00.000-08:002010-11-14T09:35:22.279-08:00Add url to Yandex (submit blog to Yandex) to increase visitors from RussiaAdd 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 RussiaComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com14tag:blogger.com,1999:blog-149623711961898984.post-24126499273895284552010-11-14T08:42:00.000-08:002010-11-14T08:44:25.110-08:00Convert Decimal to OctalHow 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com1tag:blogger.com,1999:blog-149623711961898984.post-26496637839635556522010-11-14T08:35:00.000-08:002010-11-14T08:35:31.723-08:00Convert Decimal to BinaryHow 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 andComputer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-90143495732831701332010-11-08T02:51:00.000-08:002010-11-10T02:33:55.958-08:00How to download ebooks on google books using google book downloader user scriptHow 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 Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0tag:blogger.com,1999:blog-149623711961898984.post-56098717849711335032010-11-08T02:33:00.000-08:002010-11-08T02:33:10.098-08:00How to install Google's book userscript downloader in firefox to download ebook from google bookHow 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 "Computer for Dummieshttp://www.blogger.com/profile/11748211978125907666noreply@blogger.com0