冷冻饮品中糖精钠含量安全评价检测数据

糖精纳是甜味剂，是我国批准限量使用的食品添加剂，消费者如果经常食用甜蜜素含量超标的饮料或其它食品，就会因摄入过量对人体的肝脏和神经系统造成危害，特别是对代谢排毒的能力较弱的老人、孕妇、小孩危害更明显。
本数据可以对冷冻饮品中糖精钠含量的情况进行安全性评价，为政府部门监管提供依据，避免因糖精钠超标使用而产生食品安全问题，进一步保障消费者的食品安全。1.数据采集：采集样品编号、检验数量、样品名称、项目、方法、最大限定值、报告值、单位等信息；
2.数据处理：(1)是否超出标准值，报告值为未检出、报告值小于等于最大限定值的为未超出，反之为超出，具体使用IF、OR的函数；(2)冷冻饮品中糖精钠含量监测总数,为数据统计范围内总检验数量；(3)冷冻饮品中糖精钠含量检出问题项次数，通过SUMIF函数将超出标准值的检验数量求和；(4)冷冻饮品中糖精钠含量问题发现率=冷冻饮品中糖精钠含量检出问题项次数/冷冻饮品中糖精钠含量监测总数*100%。

Saccharin sodium is a sweetener and a food additive approved for limited use in China. Frequent consumption of beverages or other foods with excessive sodium cyclamate content will cause harm to the human liver and nervous system due to excessive intake, especially for the elderly, pregnant women and children with weaker metabolic and detoxification abilities.

This dataset can be used to conduct safety assessments on the saccharin sodium content in frozen drinks, provide a basis for government regulatory departments, avoid food safety issues caused by excessive use of saccharin sodium, and further guarantee 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) Determine whether the standard value is exceeded: if the reported value is "not detected" or less than or equal to the maximum allowable limit, it is classified as not exceeding the standard; otherwise, it is classified as exceeding the standard. The IF and OR functions are specifically used for this calculation.
(2) The total number of monitored saccharin sodium content in frozen drinks refers to the total number of inspections within the data statistics scope.
(3) The number of problematic items detected for saccharin sodium content in frozen drinks is the sum of the number of inspections that exceed the standard value, calculated using the SUMIF function.
(4) The problem detection rate of saccharin sodium content in frozen drinks = (Number of problematic items detected / Total number of monitored samples) * 100%.

搜集汇总

数据集介绍

特点

该数据集提供了冷冻饮品中糖精钠含量的检测数据，旨在评估其安全性，为政府部门监管提供依据，保障消费者食品安全。数据规模为85条，更新频次为按需更新，数据内容包括样品信息、检测方法和结果等，并通过算法规则对数据进行了处理和分析。