馒头中安赛蜜含量安全评价检测数据

安赛蜜是一种食品添加剂，化学名称为乙酰磺胺酸钾，又称AK糖，外观为白色结晶性粉末，它是一种有机合成盐，其口味与甘蔗相似，本数据可以对馒头中安赛蜜含量的情况进行安全性评价，为政府部门监管食品从业者合理使用食品添加剂提供依据，进一步保障消费者的食品安全。1.数据采集：采集样品编号、检验数量、样品名称、项目、方法、最大限定值、报告值、单位等信息；2.数据处理：(1)是否超出标准值，报告值为未检出、报告值小于等于最大限定值的为未超出，反之为超出，具体使用IF、OR的函数；(2)馒头中安赛蜜含量监测总数,为数据统计范围内总检验数量；(3)馒头中安赛蜜含量检出问题项次数，通过SUMIF函数将超出标准值的检验数量求和；(4)馒头中安赛蜜含量问题发现率=馒头中安赛蜜含量检出问题项次数/馒头中安赛蜜含量监测总数。

Acesulfame potassium, a food additive with the chemical name potassium acesulfame and also known as AK sugar, is an organic synthetic salt appearing as a white crystalline powder and possessing a taste similar to that of sugarcane. This dataset enables safety assessment of acesulfame potassium content in steamed buns, providing a scientific basis for government authorities to supervise food producers and operators in the rational utilization of food additives, thereby further safeguarding consumer 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 of measurement.

2. Data Processing:
(1) Compliance Judgment: Samples with a reported value of "not detected" or a reported value less than or equal to the maximum allowable limit are classified as non-excessive, while the rest are classified as excessive. This judgment is specifically executed using the IF and OR logical functions.
(2) Total Monitored Samples for Acesulfame Potassium Content in Steamed Buns: The total number of inspections conducted within the data statistics scope.
(3) Number of Non-Compliant Tests for Acesulfame Potassium Content in Steamed Buns: The count of inspections that exceed the standard limits, which is calculated by summing the quantities of such non-compliant tests using the SUMIF function.
(4) Non-Compliance Detection Rate of Acesulfame Potassium Content in Steamed Buns: Calculated as (Number of non-compliant tests) / (Total monitored samples for acesulfame potassium content in steamed buns).

搜集汇总

数据集介绍

特点

该数据集提供了馒头中安赛蜜含量的检测数据，用于食品安全评价，数据规模为50条，更新频次为按需更新。数据内容包括样品编号、检验数量、样品名称、项目、方法、标准值、最大限定值、报告值、单位等信息，并通过算法规则对数据进行了处理，如判断是否超出标准值、计算问题发现率等。