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

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

Sodium cyclamate (calculated as sodium cyclamate) is a non-nutritive sweetener primarily used to enhance the taste of food. Its sweetness is 30 to 40 times that of sucrose, and excessive use may pose health risks. Detection of sodium cyclamate content in meat products provides a basis for government supervision, prevents food safety issues caused by excessive sodium cyclamate in meat products, and further safeguards consumers' food safety.
1. Data Collection: Collect information including sample number, inspection quantity, sample name, test item, detection method, maximum allowable limit, reported value, and unit.
2. Data Processing:
(1) Judgment of exceeding standard limits: If the reported value is "not detected" or less than or equal to the maximum allowable limit, it is classified as non-excessive; otherwise, it is classified as excessive. The IF and OR functions are used for this judgment.
(2) Total number of sodium cyclamate tests in meat products: the total number of inspections within the scope of data statistics.
(3) Number of problematic detection instances for sodium cyclamate in meat products: sum the number of inspections that exceed the standard limit using the SUMIF function.
(4) Detection rate of sodium cyclamate in meat products = (Number of problematic detection instances / Total number of sodium cyclamate tests in meat products) × 100%.

搜集汇总

数据集介绍

特点

该数据集记录了肉制品中甜蜜素含量的检测数据，主要用于食品安全监管，确保甜蜜素含量不超标。数据规模为47条，更新频次为按需更新，包含样品编号、检验数量、样品名称等详细信息，并通过算法规则进行数据处理。