Posts Tagged ‘basic’

MS Excel (2003 is my version) basic formula question?


 Powered by Max Banner Ads 

Here is what i’m trying to do:

I have a row of data for the members of a fitness club including name, number, city, etc. The final column then asks if they are currently a member or not using a “Yes”, “No”, or “Pending” drop down list.

I want to create a formula that checks the drop down box and if “Yes” is checked it sets the entire row to a certain background color (ie: light green), if “No” is checked then it sets the background of the entire row to red, and if “pending” is checked it sets it to light blue.

So, to summarize:
I want to set the color of an entire row depending on the value of a specific drop down menu (3 possibilities).

I got it to color the drop down menu cell a specific color depending on the result using condition formatter, but i cant figure out how to get the whole row a color. I’m thinking ill just have to create a formula on another page of my workbook and have it reference that cell using a lookup function and then execute an action depending.

Thank you for any help

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • Google Bookmarks
  • Yahoo! Buzz
  • Twitter
  • Technorati
  • Live
  • LinkedIn
  • MySpace

Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Natural Cures – 9 Basic Health Problems That Can be Treated Using Pyramid Energy

The interest in natural cures is on the rise. More today than ever before. Just as “going green” is the big buzzword for clean energy, and organic is the buzzword for fresh food, natural cures or natural home remedies are just as big now.

Below I have listed 9 basic health problems that can be treated using natural, clean energy that can be obtained from pyramids. Before you think that I am a new age freak or some sort of a kook (I might be a kook, kooky-freak, freaky-kook, etc…) for believing in pyramids, please hear me out.

First, everyone knows that natural sunlight is good for us. We also know that certain types of light, like ultra-violet light actually kills bacteria and that electromagnetism promises health benefits as well.

Pyramid energy over the years has shown to be beneficial to mankind in many ways. It has to do with the solar activity, electro magnetism, the benefits of prismatic or UV light due to the slope angle of the walls or architectural design of pyramids.

Pyramids can preserve meat, turn milk into yogurt, sharpen knives and offer many other benefits as well that fall under the category of natural cures or natural home remedies. When Kirlian photography is used, corona discharges are even present just like all living things that are photographed using this technique.

I have heard that even NASA has tested and experimented with them. Pyramid space is VERY SPECIAL SPACE! Even our stealth bomber’s design has all kinds of pyramid-type angles that allow it to be invisible to enemy radar. Here below are some health benefits of pyramid energy:

1.) Poor Eyesight – there are courses available that work on strengthening the muscles that shape the eye. The correct shape of the eye is what brings it into focus. Pyramid energy has reportedly helped people to correct their vision.

2.) Hearing – some basic hearing problems could be improved and sharpened through this free amazing energy.

3.) Acid Reflux Disease – digesting your food can get harder as you get older. And young people as well as older people have had trouble with acid reflux. I know from first had experience that pyramids make the stomach’s digestion process become active.

4.) Insomnia – millions of Americans suffer from lack of sleep. The soothing of the brain and the relaxation of the legs can help solve this symptom. I slept very well having my large pyramid next to our bed when we had a larger bedroom at one time.

5.) Chronic Pain, Arthritis – I saw slides in church from a missionary man stationed in South America that had chronic back pain. He got relief from sleeping in a pyramid that a native man of that region had built.

6.) High Blood Pressure – also called hypertension, the number one killer supposedly can be lowered just as meditation is used to lower blood pressure. The secret is stress release.

7.) Cavities and Gum Disease – cavities are caused from bacteria. Certain light kills bacteria just like the ultraviolet light used in barber shops to clean combs and scissors. Licorice root has also just been discovered to cure the bacteria that causes cavities. I have also experienced success curing cavities using pyramid energy. Hopefully, even gum disease can be treated.

8.) Stop Acne, Zits – zits die in their tracks. This works great. I energized Vaseline which I keep in a smaller pyramid. If you rub a little on a zit that won’t pop, the whitehead turns black and goes away. Again, it has to do with light or pyramid energy that kills bacteria.

9.) Heal Sores and Broken Bones Faster – I used to drive a milk truck and had to work 14 – 15 hour days. The winter weather and the wet road dirt from handling milk crates all day gave me severe open cuts around my finger nails that were extremely sore if I even lightly pressed on them. I was able to heal the extreme soreness overnight with pyramid energized Vaseline.

My cats almost went vegetarian. They used to be chronic about getting into the garbage for chicken bones. After I built my indoor pyramid they only ate their dry cat food. I heard of a a similar story about a dog becoming a vegetarian after his owner built a pyramid doghouse for it to sleep in.

Every home today needs a natural cure healing center. Just as every home today is not complete without a computer and the internet, no home should be without a free green energy source like pyramids can offer.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • Google Bookmarks
  • Yahoo! Buzz
  • Twitter
  • Technorati
  • Live
  • LinkedIn
  • MySpace

Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Basic Guide To The Sports Nutrition Industry

The role of food in total health care is not something new to mankind. The use of food to maintain man’s health is as natural as day and night. More than 2,000 years ago, Hippocrates, considered as the father of medicine, said, “Let food be your medicine and medicine be your food.” It is this principle that eventually led to the explosion of the nutraceutical industry.


The nutraceutical industry is concerned with nutraceuticals, that is, “food or part of a food that offers medical and/or health benefits including prevention or treatment of disease.”


All therapeutic areas such as anti arthritic, cold and cough, pain killers, digestion, sleeping disorders, blood pressure, cholesterol, prevention of certain cancers, osteoporosis, depression and diabetes are covered by nutraceuticals.


Products range from herbal dietary supplements, actual food components in dosage form such as capsules or tablets to beverages fortified with vitamins and genetically engineered designer foods, functional foods, processed foods such as cereal, soup and beverages.


Functional foods, the most popular term among consumers are modifieds food or food ingredients that may provide a health benefit beyond the traditional nutrients it contains.


Nutraceuticals is widely popular in the US, Canada, Japan, and Europe and has garnered $80 billion dollars in revenues. The demand for nutraceuticals has been growing worldwide due to consumer awareness of the links of diet and disease, aging population, rising health care cost and innovations in food technology and nutrition.


Sports and Food

In the last decade, sports and fitness nutrition has emerged as one large distinct category in the nutraceutical industry. Three main products contributed to the market’s dramatic 2004 growth:


- low carbohydrate products – which grew by as much as 154%

- sports energy beverages – which grew by 18%;

- sports supplements – which grew by 6%.


Now, the $2 billion-worth sports nutrition industry has moved away from the plain-tasting protein powders into a bigger pool of choices for customers. Available in almost any drug stores or supermarkets are energy bars, meal replacement products, protein powders, individual items (e.g., creatine, L-carnitine), amino acids, herbs, prohormones (hormone precursors); vitamins; minerals; and combination products. Because of this the sports nutrition nutraceutical industry is considered a ‘niche’ market and an offshoot of the mainstream food industry.


Competition factors for the Sports Nutrition Market

Product/brand differentiation

Because of greater saturation and competition in the marketplace sports nutrition products look alike and sound the same. Maintaining a brand that stands apart from the rest is difficult but a thing to strive for.


Research-substantiated claims.

Consumers’ ability to make intelligent choices should never be underestimated. People place more faith endorsements by university professors and doctors and claims backed by independent research than by endorsements by celebrities.

Core products and strategies

A good strategy now is to focus development of core products or integrating with large food and pharmaceutical concerns (e.g., Powerbar, BalanceBar).


E-commerce

For small companies that cannot or will not rely on strong distribution relationships, e-commerce is an increasingly attractive option.


Basis for marketing strategy

The factors for competition stated above have been gleaned from researches of what consumers are willing to pay for. Overall, customers want:


Something New

Retailers and consumers clamor for “new,” whether it means new forms of delivery (gels, effervescent tablets, functional beverages), new applications of or combinations with existing products, or all-natural sports nutrition products that are free of artificial ingredients and solvents.


Excellent Tasting All-natural products

Consumers are also looking for products that taste good and are easy to take. Taste is a major feature that can either make or break a product. The hunt is on for manufacturers to come up with better and new flavors.


High quality and safe products

Regulatory agencies exist to protect the consumers. It is the responsibility of product manufacturers to undertake sound research and prove the efficacy and safety of their nutraceutical products. Products that are based on false or misleading marketing should be and are banned and condemned.


Through product sales and advances in research and development, the Sports Nutrition Nutraceutical Industry is now validating what was proven, early on, by the fitness and nutrition pioneers – sports nutrition products provide easier access to a healthier way of performing and living.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • Google Bookmarks
  • Yahoo! Buzz
  • Twitter
  • Technorati
  • Live
  • LinkedIn
  • MySpace

Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Some Basic Cooking Terms and the Language Used in Recipes

It can be very frustrating when you are trying to follow a recipe, but you don’t understand the cooking terms used. Sometimes even instructions on a packet of pasta can confuse you – what does cook until “al dente” mean? So, let’s have a look at some basic cooking terms and the language used in recipes:-

Al dente – This term is often used with pasta and literally means “to the tooth/bite”. Boil the pasta until is is tender but still has some “bite”, not soggy and falling apart. Packet pasta usually takes 5-10 minutes in boiling water.

Baste – This term is often used when roasting chicken or cooking meat in a marinade. You will need to regularly “baste” the meat with the juices or sauce to keep it moist. For more details www.tailgating-recipe.com .You can use a spoon to spoon the juices or sauce over the meat or you can use a “baster” which is a bit like a syringe or bulb.

Beat – A term often used in cooking or baking. You may be instructed to beat and egg – simply crack an egg into a bowl and beat (stir rapidly) with a fork or whisk to combine the yolk and white. In cake recipes, you may be instructed to beat the margarine and sugar together – use an electric whisk or beater for ease.

Blanch – A recipe may call for blanching vegetable. This simply means to plunge them into boiling water for about a minute.

Chop – self explanatory but use a good sharp knife and try to chop vegetables etc. so that bits are uniform in size and thickness. Onions often have to be chopped finely so chop them as small as you can.

Cream – Cake recipes often instruct you to cream the butter or margarine with the sugar. Beat them together either with a wooden spoon or electric mixer until they are well combined and the mixture has turned a paler colour.

Dice – If you are instructed to dice meat or vegetables, it means that you should chop into uniform squares.

Fillet – This word can either be used as a noun or a verb. A meat fillet is a good quality piece of meat which has been “filleted”, had the bones removed. If a recipe asks you to fillet a piece of meat or fish, it means you need to remove the bones. This is tricky so buy fillet meat or ask your butcher or fishmonger to do it for you.

Fold – Cake recipes often tell you to fold in the flour after creaming the margarine and sugar and adding eggs. For more details www.apples-recipes.com .Add the flour a bit at a time using a metal spoon and a figure of eight movement to “fold” the flour into the mixture while retaining the air added by creaming or beating.

Julienne – This term is used with vegetables. Julienne carrots are carrots which have been chopped into matchsticks or strips.

Marinate – To coat a piece of meat or fish in a sauce usually overnight or for a few hours in the fridge. The meat will take on the flavours from the sauce.

Pare – Remove the skin from fruit or vegetables.

Peel – Remove the skin from fruit, vegetables or prawns.

Poach – To cook in liquid. Poached eggs are cooked in boiling water and poached fish is often cooked in hot milk.

Puree – To puree a vegetable or fruit is to blend it until it is as smooth as baby food. Use an electric blender.

Saute – You can saute vegetables and this means to fry in hot oil over a high heat for a short amount of time.

Season – To flavour with salt and pepper.

Simmer – This term is often used with sauces or recipes like curry or chilli. It means to bring a sauce to boiling and then turn down to a level where the sauce is bubbling but not boiling.

Stiff peaks – If you are instructed to beat cream or egg whites until stiff peaks are formed, then you need to whisk or beat until the mixture forms peaks which do not collapse and you could even turn the bowl upside down without the mixture immediately falling out.

Stir-fry – To stir-fry is to cook meat and/or vegetables in a wok at a high temperature. Stir-fry packs can be found in supermarkets and all you have to do is fry them briefly in hot oil in a wok, add sauce or spices and serve with noodles or rice.

Whisk – Use an electric whisk or a hand whisk to beat something like cream.

Hopefully these explanations will help you to feel more confident when using recipes.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • Google Bookmarks
  • Yahoo! Buzz
  • Twitter
  • Technorati
  • Live
  • LinkedIn
  • MySpace

Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

The Basic of a Good Health and Fitness Program

The best health and fitness plans promote to not only alter your physical appearance, but also help you to defeat the emotional issues physiological obstructions that induce us to be insalubrious in the first place. Ask any person who has committed to a serious health and fitness practice and has experienced this life-changing procedure. They will certainly be the best source of inspiration and information when you are considering taking the journey to improve your own health.

Physical fitness is essential in maintaining a healthy body. This is a physical process that serves a person to look, feel and work better. It helps in carrying out the bodily activities expeditiously. Physical fitness means you have to work out your heart, lungs and muscles of the body regularly. But fitness activities change from person to person.

You have to make sure that your exercise never becomes a routine. So keep on changing things up on a regular basis. This means that you will have to change the timing of your exercise and also you will have to do different exercises. Here’s why. When you stay stuck in the same patterns all the time, your body becomes accustomed to it and will develop defense mechanisms that will prevent you from being fit. When you change things up regularly, it doesn’t have time to adapt, and your physical fitness appears to be at its best.

Activities to be integrated in the fitness plans have to be determined after examining several constituents of fitness. Checking weight is a crucial part of physical fitness. Muscle tone growth is another view that is called for by fitness programs. Suggestions of timings are given by a good fitness program. Actually exercises are adjusted on the schedules of work which and individual is taking up.

Fitness programs also advise diets for individuals. Your eating habit will also affect your health and fitness programs. The main idea behind choosing health and fitness programs is that they give you long term suggestions. These fitness programs improve your health in terms of better performance of important body organs. This fitness programs gives you better stamina and more energy because of which you feel that you are healthy and fit.

Health experts recommend green tea as a diet for your physical fitness program. You should make it a regular habit of having green tea with your daily diet. You should have it at least thrice daily. Green tea energizes your metabolism. Your metabolic rate is kept at a high rate due to the presence of caffeine and other chemicals in green tea.

You have to keep a watch and analyze your exercise session. You don’t have to work out for hours together. That will lead to injury, exhaustion and you will be tired and less likely to carry on with your routine the next day. Just find ways and means through which you can increase intensity and make your exercises more challenging a little at a time. You can add more pushups to your list of exercises and also make them harder. This will help you to burn more calories and keep you physically fit.

Chris M. is a Miracle Mile Personal Trainer. Chris owns fitness business Positively Fit Inc. which services personal training to all of Orange County, CA. Read more by Chris M. by visiting his website at http://www.socalworkout.com/.
Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • NewsVine
  • Reddit
  • StumbleUpon
  • Google Bookmarks
  • Yahoo! Buzz
  • Twitter
  • Technorati
  • Live
  • LinkedIn
  • MySpace

Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon


 Powered by Max Banner Ads