Excel Templates | Excel Spreadsheets

BMR Calculator

Posted on October 26, 2009
Filed Under Health | 9 Comments

Basal metabolic rate or BMR, is the amount of energy expended while at rest in a neutrally temperate environment, in the post-absorptive state (meaning that the digestive system is inactive, which requires about twelve hours of fasting in humans). This is a definition that you can easily find in internet or from wikipedia. The release of energy in this condition is sufficient only for the functioning of the people vital organs, such as the heart, lungs, brain, liver, kidneys, sex organs, muscles and skin. People BMR is usually influenced by a number of factors, including age, weight, height, gender, environmental temperature, dieting, and exercise habits.

BMR Calculator

Because of the increased activity of cells undergoing division, the younger the person, the higher (faster) the metabolism. And the taller and heavier a person is, the faster their metabolism. Because of the greater percentage of lean muscle tissue in the male body, men generally have a 10-15% faster BMR than women. And when you go on restrictive, traditional diets, your BMR can drop by as much as 20%. People living in tropical or very cold environments generally have BMR’s 5-20% higher than those living in more temperate climates. In general, depending on the intensity and duration, consistent exercise can also increase your BMR.

Read more

Binary Hexadecimal Converter

Posted on October 25, 2009
Filed Under Education | Leave a Comment

This is another conversion tool using built-in excel function. But different than earlier post where the template using the built-in convert function, this converter using the other built in function. There are six built-in functions used here, those are dec2bin (decimal to binary), dec2hex (decimal to hexadecimal), hex2bin (hexadecimal to binary converter), hex2dec (hexadecimal to decimal), bin2dec (binary to decimal) and bin2hex (binary to hexadecimal).

For people or student who do software or hardware programming, these conversion utility are important. I have an engineer who works with these hexadecimal conversion daily, because he has to develop application on top of mobile phone operating system which consists of hexadecimal number. I don’t want to explain too detail about it, but if you are engineers, understanding conversion between these integer numbers is a must.

Binary Converter

As founded in internet, binary describes a numbering scheme in which there are only two possible values for each digit: 0 and 1. The term also refers to any digital encoding/decoding system in which there are exactly two possible states.In digital data memory, storage, processing, and communications, the 0 and 1 values are sometimes called “low” and “high,” respectively. And hexadecimal describes a base-16 number system. That is, it describes a numbering system containing 16 sequential numbers as base units (including 0) before adding a new position for the next number. (Note that we’re using “16” here as a decimal number to explain a number that would be “10” in hexadecimal.) The hexadecimal numbers are 0-9 and then use the letters A-F.

Read more

Temperature Converter

Posted on October 25, 2009
Filed Under Education | 1 Comment

After a month of taking care my offline business and also took some weeks off and did my other hobbies that has no relation with excel, I am a little bit rusty to create new excel templates. So, I created some easy templates, and also I still have some templates that I have created before and have not been published due to my offline activities.

This is the template where the first time I created several years ago, I have to interpret the temperature conversion formula into the correct excel function combination. But, when I saw the list of excel function again, I find that excel already have that conversion function named “Convert”. You can use this function not only for temperature conversion but also for other conversion, for example weight, distance, time and many other conversion that you can see in the excel help menu of this function.

Temperatur Converter

For temperature itself, excel provide conversion between Celcius, Fahrenheit and Kelvin, and you can see the implementation in my excel spreadsheet here.

Read more

Page 30 of 57« First...1020...2829303132...4050...Last »