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 text

There 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.

Science Education and Art Education: The Perfect Pair

After years of touting the STEM (science, technology, engineering, and mathematics ) educational programs, many teachers are discovering that by adding an “A” –for ART– student learning will pick up STEAM! This latest understanding of how students learn is changing science education by adding Art education back into the mix. This integrated education approach is developing a proven track record and being incorporated into public, private and homeschool education.At its inception, the STEM bill authorized over 150 million to help students earn a bachelor’s degrees and teaching credentials. It also provided millions in additional money to help align kindergarten through grade 12 math and science curricula to better prepare students for college.Now years later, people are asking questions like: Why are math and science viewed as standalone modalities? Why have so many schools dropped Arts education from their curriculum?For too long, we have wrongly believed that Science and Art education were separate disciplines that demanded different teaching methods. However, now we know that Science and Art, as well as Math and Music are intrinsically related!Educational researchers are recognizing that it is important to integrate all modalities into STEM lessons. By broadly using an integrated education curriculum, students are able to see how science education is important to aspects of everyday life. Integrated education also affords the opportunity for real-world application of the math and science education knowledge.The use of Art as the glue that bonds these modalities shows students how form and function are guiding principles. Art is not merely illustrative or decorative, but represents an essential part of the process of inquiry, such as problem finding, problem solving, and communication.The fervor that propels people to excel at mathematics and science education or engineering and art education are driven by the same desire: the desire to discover the intricacies and beauty in one’s world and chosen work. Furthermore, Art is also integrated into technologies such as engineering in the “form and function” debate. Does form follow function or does function follow form? Either way the two are fundamentally linked. Cars are a perfect example: From the Model-T Ford to the latest concept car, we have seen that the evolution of technology is as much about aesthetics (form) of the product as it is about functionality.Many of the fundamental concepts of form and function are the same. Line, shape, color, structure/function relationships as well as perspective, patterning, and sequencing are the language of art and science education. Students create “an artistic representation of their ideas and solutions is a valuable way to make learning personal. This allows for a clear understanding of the underpinnings of science principles and how these principles can be extrapolated to solve existing problems. It has been proven that students who previously had difficulty in STEM classes are picking up STEAM quickly!

Tips for an Exterior or Interior Painting Home Improvement Project

Giving your Tallahassee home a fresh look can be as easy as giving it a new coat of paint. One of the most commonly overlooked home improvement projects is merely adding a different coat of paint to your home’s exterior. In fact, it is one of the top five value-adding home improvement projects that can be done to your home.According to multiple experts, exterior and interior paint jobs consistently rank in the top five for home improvement projects that can add value to your home. When it comes time to sell the home, you want to make sure that the projects you have undertaken previously will reap a benefit financially. Not every project is considered to be a wise investment. While theoretically every home improvement or renovation project adds value to your home, since you are putting money into your home through added materials and labor, not every project realizes a return on your investment. Others only add marginal value to your home’s worth. That makes it important for you to think about the projects you are considering and find out if they are deemed good financial investments. As mentioned above, paint jobs are considered wise investments. Here are a few tips to keep in mind when undertaking this project, whether inside or outside the home.1. Consider a professional painter for your home’s exterior. While a professional painter may even be recommended for your home’s interior, it is nonetheless a project you can take on by yourself. Of course, hiring a professional painter will cost you more, but the result will be a cleaner and more vibrant look.2. Don’t forget to start with a primer. A base coat of tinted primer will make the paint look a whole lot better. Primer creates a sealed surface for paint, which makes the paint look more vibrant, hiding previous colors and blemishes. They also add to the life of the coat of paint, preventing cracks and peeling. It makes the paint last longer and stay more durable, something extremely important for exterior paint jobs. Don’t forget that primer will actually save you money since it will keep you from having to use up a lot of expensive high-quality paint to cover over previous colors or marks. The tinted primer is less expensive and can act as a first coat.3. When picking the color, you want to steer clear of outrageous colors that make a home harder to sell. It is a fine balance between your personal tastes and remembering that this is also a home improvement project that can add value to your home in the eyes of potential future buyers.4. Pay attention to details. Even if you are overwhelmed with the size of the project, resist the urge to hurry through the preparation or the actual painting. Protect nearby furniture, electrical outlets, woodwork, cabinets, countertops, and exterior surfaces. If you are tempted to rush through this home improvement project, it may be better to let a professional do it.5. Finally, don’t avoid the more expensive paint just so you can save some money today. Remember that more expensive paint is priced higher for a reason. If you are doing this for your own present enjoyment as well as for purposes of future home value, be willing to spend a little extra on stronger, more vibrant paint.Those are just five tips to keep in mind when giving your home’s exterior or interior a new coat of paint. It’s a project that can add value to your Tallahassee home years down the road when you decide to sell it. Therefore, keep that in mind every step of the way when undertaking this project.