蔬菜制品中的甜蜜素含量安全评价检测数据

甜蜜素（以环已基氨基磺酸钠计）是属无营养的甜味剂，主要用于增加食品的口感，其甜度是蔗糖的30~40倍，过量使用可能会对身体健康造成危害。蔬菜制品中的甜蜜素含量的检测，为政府部门监管提供依据，避免因蔬菜制品中的甜蜜素含量超标使用而产生食品安全问题，进一步保障消费者的食品安全。1.数据采集：采集样品编号、检验数量、样品名称、项目、方法、最大限定值、报告值、单位等信息；2.数据处理：(1)是否超出标准值，报告值为未检出、报告值小于等于最大限定值的为未超出，反之为超出，具体使用IF、OR的函数；(2)蔬菜制品中的甜蜜素含量检测总数：为数据统计范围内总检验数量；(3)蔬菜制品中的甜蜜素含量检出问题项次数：通过SUMIF函数将超出标准值的检验数量求和；(4)蔬菜肉制品中的甜蜜素含量发现率=蔬菜制品中的甜蜜素含量检出问题项次数/蔬菜制品中的甜蜜素含量监测总数*100%。

Sodium cyclamate, expressed as sodium cyclohexylsulfamate, is a non-nutritive sweetener primarily used to enhance the sensory properties of food. It has a sweetness 30 to 40 times that of sucrose, and excessive consumption may pose risks to human health. Testing for cyclamate content in vegetable products provides a scientific basis for government regulatory oversight, prevents food safety incidents caused by excessive use of cyclamate in vegetable products, and further safeguards consumer food safety.
1. Data Collection: Collect information including sample number, test quantity, sample name, detection item, test method, maximum allowable limit, reported value, unit and other relevant parameters.
2. Data Processing:
(1) Standard Excess Judgment: Use IF and OR functions to determine whether the reported value exceeds the maximum allowable limit. Cases where the reported value is "not detected" or less than or equal to the maximum allowable limit are classified as non-excessive, while others are classified as excessive.
(2) Total Number of Cyclamate Tests for Vegetable Products: Refers to the total number of tests within the statistical scope.
(3) Number of Excessive Test Results for Cyclamate in Vegetable Products: Sum the quantity of tests with excessive cyclamate content using the SUMIF function.
(4) Detection Rate of Cyclamate in Vegetable Products = (Number of Excessive Test Results for Cyclamate in Vegetable Products / Total Number of Cyclamate Tests for Vegetable Products) × 100%.

搜集汇总

数据集介绍

特点

该数据集记录了蔬菜制品中甜蜜素含量的检测数据，包含111条记录，主要用于食品安全监管，确保甜蜜素含量不超标。