How to Calculate Nutrition Data Using Excel or Open Office Calc

EU directive 1169/2011 comes into full effect on the 13th of December 2016. The first phase of this directive came into effect in 2014 on December 13th but the second requires nutrition data which begs the question of how to calculate nutrition data.The first phase of this regulation required that all ingredients on labels needed to include allergen information within the ingredient list. Prior to this regulation, it was legally acceptable to include allergen information in a separate area of your label.The new regulations simply require allergens to be highlighted within the single ingredient list for the product but ingredients also need to be stated in quantitative order.Quantitative order simply means the largest constituent ingredient must be indicated first, then the second largest and so on. The percentages of these ingredients should also be included.There are several ways highlighting ingredients can be achieved; Users can use bold text underline text colour text or italic textThere are 14 allergens that must be indicated on labelling if they are present within the ingredients of the product. These include wheat or oats or any other cereal containing gluten and also include milk, eggs, fish, crustaceans, molluscs to name a few.Another aspect of the legislation was to harmonise the legibility of text on food labels.Historically, the text could be incredibly difficult to read as manufacturers crammed as much information into as small a section of the label as possible so as to maximise the marketing potential of the rest of the label.The new regulations require that all text must be legible with a specific height of the letter “x” in the font no smaller than 1.2 millimetres. In layman’s terms, that means that the standard Arial or Times New Roman font needs to be 6.5 points and size.The second phase of the regulations coming into force this December requires that nutrition data is supplied with all pre-packaged food so that consumers can make choices regarding the nutrition within the food they buy.The law stipulates that this information must be conveyed to the customer per 100 grams.It is also possible to convey the information additionally per serving so, for example, a sandwich would constitute a serving so a food producer could provide the information based on the entire sandwich. The food producer can also indicate nutrition values in a portion, for example, a biscuit or a small piece of chocolate. But the food producer must also provide the information in a per 100g format in all instances.How to Calculate Nutrition Data
In order to calculate the nutrition values of prepackaged food for sale to the public food production businesses need to know the nutrition values for the constituent ingredients within their product. Perhaps the best way to demonstrate how to calculate nutrition data is to give an example; a ham and mustard sandwich.A ham and mustard sandwich might consist of four ingredients; we will have the bread, ham, mustard, and margarine or butter to make a sandwich. Each of these ingredients will be incorporated along the lines of a recipe; that is to say, there will be a specific weight of each product to make up a standard product.Food manufacturers need to start with the basic data for the nutrition for each of the ingredients – as mentioned, the legislation requires that nutrition data is provided per 100 grams. As all manufacturers are required to do this most food producing companies should be able to obtain that information directly from the packaging of the products that they buy in or by speaking with their supplier.In our example, the food producer could tabulate the data from the constituent ingredients into a table. The information that must be conveyed includes energy in both kilojoules and kilocalories; they must also convey total fat, saturated fat, carbohydrates, sugar, protein, and salt – all in grams.Food producers can also indicate monounsaturated fat, polyunsaturated fats, polyols and starch (which are carbohydrates) and fibre if they wish to do so.The order of the nutrients is specific and must be adhered to comply with the regulations.Once the table of data is prepared per 100 grams for all of the ingredients, the food producer needs to understand the weight of each product used in the recipe to make the sandwich. In this example, the food producer would need to know the weight of two slices of bread (let’s say 60 grams), the ham they use (e.g. 30 grams), 10 grams of mustard 5 grams of margarine.Once this has been done a simple calculation is applied to each of the constituent ingredients to determine how many calories, how much fat, saturated fat etc. is present in the recipe. The calculation will be to divide the per 100g nutrition data by 100 then multiply that by the weight of that constituent in the ingredient.E.g. If 100g of ham is 350 calories, divided by 100 is 3.5 calories per gram. 3.5 calories per gram x 30 grams used in the recipe is 105 calories.Once this is complete, the food manufacturer will have an accurate indication of the total nutrition data for the ham and mustard sandwich by simply adding the values for each constituent ingredient together as a total for the recipe.And that is how to calculate nutrition data using Microsoft Excel or Open Office Calc.Right now, food manufacturers across the UK are facing a huge challenge in achieving the objectives set out in the regulations and they need to address them very quickly if they have not already.

Your Ultimate Guide to the Best Skin Care For Men – 4 Secret Ingredients Revealed

Skin care for men is as important as skin care for women. This is a fact that is widely being accepted these days. This article shall give you the clear ideas on what to look out for in men skin care products that is specifically needed for men and their skin care needs.Traditionally, skin care products have always been designed keeping the women and their needs in mind. The creams and lotions had been formulated keeping the women in mind, packaged for women and even had fragrance that was more feminine oriented.Men skin care had been an ignored lot. But, men also need special skin care. Fortunately, some skin care manufacturers have designed products specifically for men. But a majority of them have products that do not differentiate between the special needs of men skin care and women skin care products.Men are more sensitive towards inflammation of skin. Prostaglandin E2 (lipids or fatty cells) is found in greater levels in men then in woman. So, men skin care products should have special ingredients that counter this problem specifically. Inflammation if left unchecked, over time leads to a further breakdown of important structural proteins in the skin and causes premature skin aging.Cynergy TK is a natural ingredient that you must look for in men skin care products. It plays amazing role in soothing skin inflammation by blocking PGE2 production, which is the major biochemical pathway leading to inflammation and redness in the skin.Eyeliss TM and Haloxyl TM are two natural ingredients that work amazingly for dark circles and puffy skin that makes men look much older than they are. They are the best for curing wrinkles beneath the eyes very quickly and effectively. In fact, they are used in the elite creams that are used by the Hollywood stars and supermodels to maintain their young and attractive looks.Although, there are many differences in the skin type of men and women, there are also a couple of similarities. This is because the causes of skin aging are almost the same – whether it is men or women.Both men and women lose collagen in their skin as they age. This makes their skin lose its elasticity and suppleness over time. This also causes wrinkles and fine lines. So, some ingredients are commonly used both for skin care for men products as well as women skin care.Functional keratin is a wonderful solution to this problem of skin aging. It is available in Cynergy TK which is natural ingredient pioneered and developed in New Zealand. It plays a key structural role in skin health and makes it soft, supple, firm and young looking.It is a scientific fact that skin cells require nutrients in the form of vitamins, calcium, minerals and also antioxidants in order to stay healthy and maintain their moisture balance.Phytessence Wakame is an extract of a special Japanese sea kelp that is used in the best skin care for men as well as women products. It is one of the best kept Japanese anti aging and Skin rejuvenation secrets.It is rich in minerals, vitamins, calcium (its calcium content is 15 times greater than milk) and antioxidants. It works like magic in improving skin moisture retention and elasticity. It gives a smooth, velvety, young and radiant skin.Skin care for men has come far from the old days. Now, men do not have to live with wrinkled and saggy skin. They do not have to weather the signs of old age anymore. They can also have a healthy and vibrant skin that only good looking women enjoyed for many years.

SPDN: An Inexpensive Way To Profit When The S&P 500 Falls

Summary
SPDN is not the largest or oldest way to short the S&P 500, but it’s a solid choice.
This ETF uses a variety of financial instruments to target a return opposite that of the S&P 500 Index.
SPDN’s 0.49% Expense Ratio is nearly half that of the larger, longer-tenured -1x Inverse S&P 500 ETF.
Details aside, the potential continuation of the equity bear market makes single-inverse ETFs an investment segment investor should be familiar with.
We rate SPDN a Strong Buy because we believe the risks of a continued bear market greatly outweigh the possibility of a quick return to a bull market.
Put a gear stick into R position, (Reverse).
Birdlkportfolio

By Rob Isbitts

Summary
The S&P 500 is in a bear market, and we don’t see a quick-fix. Many investors assume the only way to navigate a potentially long-term bear market is to hide in cash, day-trade or “just hang in there” while the bear takes their retirement nest egg.

The Direxion Daily S&P 500® Bear 1X ETF (NYSEARCA:SPDN) is one of a class of single-inverse ETFs that allow investors to profit from down moves in the stock market.

SPDN is an unleveraged, liquid, low-cost way to either try to hedge an equity portfolio, profit from a decline in the S&P 500, or both. We rate it a Strong Buy, given our concern about the intermediate-term outlook for the global equity market.

Strategy
SPDN keeps it simple. If the S&P 500 goes up by X%, it should go down by X%. The opposite is also expected.

Proprietary ETF Grades
Offense/Defense: Defense

Segment: Inverse Equity

Sub-Segment: Inverse S&P 500

Correlation (vs. S&P 500): Very High (inverse)

Expected Volatility (vs. S&P 500): Similar (but opposite)

Holding Analysis
SPDN does not rely on shorting individual stocks in the S&P 500. Instead, the managers typically use a combination of futures, swaps and other derivative instruments to create a portfolio that consistently aims to deliver the opposite of what the S&P 500 does.

Strengths
SPDN is a fairly “no-frills” way to do what many investors probably wished they could do during the first 9 months of 2022 and in past bear markets: find something that goes up when the “market” goes down. After all, bonds are not the answer they used to be, commodities like gold have, shall we say, lost their luster. And moving to cash creates the issue of making two correct timing decisions, when to get in and when to get out. SPDN and its single-inverse ETF brethren offer a liquid tool to use in a variety of ways, depending on what a particular investor wants to achieve.

Weaknesses
The weakness of any inverse ETF is that it does the opposite of what the market does, when the market goes up. So, even in bear markets when the broader market trend is down, sharp bear market rallies (or any rallies for that matter) in the S&P 500 will cause SPDN to drop as much as the market goes up.

Opportunities
While inverse ETFs have a reputation in some circles as nothing more than day-trading vehicles, our own experience with them is, pardon the pun, exactly the opposite! We encourage investors to try to better-understand single inverse ETFs like SPDN. While traders tend to gravitate to leveraged inverse ETFs (which actually are day-trading tools), we believe that in an extended bear market, SPDN and its ilk could be a game-saver for many portfolios.

Threats
SPDN and most other single inverse ETFs are vulnerable to a sustained rise in the price of the index it aims to deliver the inverse of. But that threat of loss in a rising market means that when an investor considers SPDN, they should also have a game plan for how and when they will deploy this unique portfolio weapon.

Proprietary Technical Ratings
Short-Term Rating (next 3 months): Strong Buy

Long-Term Rating (next 12 months): Buy

Conclusions
ETF Quality Opinion
SPDN does what it aims to do, and has done so for over 6 years now. For a while, it was largely-ignored, given the existence of a similar ETF that has been around much longer. But the more tenured SPDN has become, the more attractive it looks as an alternative.

ETF Investment Opinion

SPDN is rated Strong Buy because the S&P 500 continues to look as vulnerable to further decline. And, while the market bottomed in mid-June, rallied, then waffled since that time, our proprietary macro market indicators all point to much greater risk of a major decline from this level than a fast return to bull market glory. Thus, SPDN is at best a way to exploit and attack the bear, and at worst a hedge on an otherwise equity-laden portfolio.