Skip to main content
  Bab 1:  Jejak di Nebula Komet   Tahun 2242.  Kapten Elara Vance, seorang wanita tangguh dengan mata biru tajam dan rambut pirang yang selalu terikat rapi, memimpin pesawat eksplorasi Stardust.  Misi mereka:  menjelajahi nebula Komet, sebuah kawasan misterius di pinggiran galaksi Andromeda yang dikabarkan menyimpan rahasia kehidupan di luar bumi.  Namun, perjalanan mereka jauh dari kata mudah.  Keheningan angkasa, yang biasanya hanya diselingi dengungan mesin pesawat, kini dipenuhi ketegangan yang mencekam.   Pesawat Stardust telah berkeliaran selama berbulan-bulan di nebula tersebut.  Sensor mereka mendeteksi anomali energi yang tak terjelaskan, sinyal-sinyal aneh yang seakan berbisik dari kegelapan antarbintang.  Para kru, yang terdiri dari para ilmuwan dan teknisi terbaik di Bumi, mulai merasakan tekanan psikologis yang luar biasa.  Kesunyian angkasa yang luas dan tak berujung seakan menekan dada mereka, memicu rasa takut d...

How to Recipe 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.

In order to help food businesses across the UK, Positive ID Labelling have developed Nutridata Nutrition Calculation Software that allows food users to input their constituent ingredients, create recipes and then create and product data to mee the EU Regulations.

Nutridata software automatically calculates nutrition data for food producers and exports is in an Excel spreadsheet that can be used with labelling software or can be used by graphic designers to alter information on labels printed it label manufacturers.


By  

Popular posts from this blog

Kecemburuan semacam ini

Jacey melemparkan cangkir kopi kaca, (Mug Kaca Berinsulasi Dinding Ganda Zwilling), melintasi dapur. Itu menghantam dinding yang baru dicat (Behr, Sweet Coconut Milk, M230), dan hancur menjadi triliunan kepingan. "Inilah yang telah kamu lakukan pada kami!" teriaknya, suaranya berderak karena cemburu, kuku jarinya yang terawat (Orly Cold As Ice - perawatan bernapas + warna) menusuk udara ke arah tumpukan puing-puing kaca. Blayne menundukkan kepalanya, dagu keduanya mengenai dadanya terlebih dahulu. "Maaf, sayang," gumamnya. "Maaf?! Maaf!" Dia mengambil sekotak Wheat Thins dan mengangkatnya di atas kepalanya. "Tolong jangan melempar yang lain!" Blayne memohon, berdiri dari posisi setengah duduk di bangku logam di dapur. Ini adalah bangku yang sangat tidak nyaman (Bangku Meja Grejsi dengan Bingkai Logam), tetapi Jacey menyukai cara logam itu memantulkan sinar matahari di sore hari, jadi itulah yang dia beli. Dia mencondongkan tubuh ke arahnya,...

Thirteenth step

My grandmother attends the church basement on Tuesday evenings. I saw him there among the metal folding chairs and antique coffee pots, his figure trembling under the fluorescent lights that buzzed like dying insects. She wears the same powder blue pullover she was buried in, the one with pearl buttons that catch the light like little moons. Others can't see it, of course. They just feel a sudden chill as they pass by where she is, or smell the ghostly smell of her Shalimar perfume mixing with the smell of burnt coffee that never leaves these rooms. But I see clearly. He's been following me to AA meetings for three months since I got my first white chip after five years of being back in the bottle. "Your grandmother was my godmother in 1985," old Pete told me after tonight's meeting, hands shaking as he poured a seven-pack of Sweet'n Low into his coffee. "Toughest godmother I ever had. She saved my life." "Mine, too," I said, not specif...

A-Z of Corporate Governance Law

Corporate governance law can be seen as the law that states the way a company is regulated and managed. Any student of law must have a clear idea about the corporate governance law. This article provides an insight into the law, along with its importance. Corporate governance law  describes how a company will be managed and governed. This topic is an important one for any student pursuing a degree in law. They may also receive academic papers to write on it. Hence, individuals should be clear about this law. The article aims at clarifying the idea behind the law and why it is important. What exactly is corporate governance law? A business is directed and controlled by the system of corporate governance. It is a process for governing a company, establishing the policies, customs, and laws for all employees, starting from the highest to the lowest levels. It states the distribution of responsibilities and rights among the various participants in a company like the di...