基于大数据分析的医院医保监管研究

医保监管是新形势下医院医保管理工作的重要任务,在数据大爆炸的时代,大数据是推动医保治理体系和治理能力现代化的重要力量,是医院医保智能化管理不可或缺的技术手段。笔者基于大数据背景,以广西某三级医疗机构住院病人数据为研究样本,分析药品、诊疗项目数据的变化趋势,精准发现医保违规收费疑点,探索建立Excel软件与数据分析融合下的医院医保监管新模式。

“两尘四气”空气污染数据的校准模型

通过Excel软件对监测点收集的空气质量数据进行拆分及构造函数的方法,拟合了“两尘四气”的六个方程,这些方程可用于对自建点数据进行校准。在对所收集的数据标准化后,利用SPSS软件对“两尘四气”数据误差产生的原因进行回归分析,建立了多元线性回归方程。方程显示:压强、温度和风速更容易导致自建点数据误差,可使用对上述三种因素不敏感的材质制造检测仪的传感器。以上使用Excel和SPSS软件对大数据进行比对处理及建模的方法可用于环境监测、农业生产等领域促进高质量生态文明建设。

Excel支持的匀变速运动位移公式的探究教学

匀变速直线运动的位移公式是教学中的难点。在分析人教版新教材编写设计和高一学生学情后,提出以Excel软件作为技术支持的科学探究教学改进方案。通过v-t图像围成的面积和真实位移的数据对比,得到匀变速直线运动v-t图像围成的面积表示位移的结论。

基于Excel测试模板的变频器自动测试程序设计

变频器作为微波信号发射端和接收端的重要器件,对收发系统性能具有较大影响,因此,需对相关参数进行测试。本文针对其种类、测试参数和测试仪器设备多,以及测试人员要求高、人工测试效率低,开发设计变频器自动测试程序,并基于Excel测试模板,实现定制化测试。

VBA结合Excel在施工进度横道图制图软件开发中的应用研究

施工进度计划是建设项目施工组织设计中的重要内容,横道图是水利水电项目设计阶段施工总进度计划的主要表示方法。本文依托Microsoft Office Excel内嵌的VBA语言简单、方便、高效的特点和优势,探索研发了一款符合水利水电行业设计习惯的施工进度横道图制图软件,可以减少人力投入,提高设计效率,满足行业设计需求。软件具有自动进行工程量汇总、强度累计、制作强度曲线图、绘制施工总进度横道图并标注线条强度、分期分幅出图、进度线条批量平移(含部分项目跨停工时段平移)等功能,在诸多水利水电项目设计中得到良好应用。

Python实现Excel文档转换到Word文档的自动化方法

通过研究开发了一种基于Python语言,实现Excel数据自动转换成Word文档并实现排版功能的方法,为科研工作者、数据分析师或报告撰写人员提供一个方便快捷的工具,帮助他们更高效地完成Excel数据转换成Word并实现排版的任务。

Excel软件在医学统计学课程中的教学应用探讨

在医学数据统计处理中,常用的统计软件包括SAS、SPSS和R。此外,掌握Excel软件中的统计功能对于提高数据处理能力也是一个极佳的选择。文章以《卫生统计学》教材为例,展示了数据处理的过程,并探讨了计量资料的均数、标准差、配对设计资料的t检验、两个独立样本的t检验以及单因素方差分析在统计分析中的应用方法。Excel软件可以作为医学统计学课程的辅助教学软件。

应用型本科高校“Excel人力资源管理工具应用”课程建设研究

数据分析技术在人力资源管理行业中的应用越来越广泛,但目前人力资源管理专业学生的数据分析能力相对薄弱。通过对应用型本科高校“Excel人力资源管理工具应用”课程建设进行研究,找出原有课程教学中存在的主要问题,对课程内容进行重构和设计,注重Excel工具应用的教授及数据分析素养的提升,培养高素质的应用型人力资源数据分析人才。

基于“互联网+”职业教育学生学习行为的探讨

本文以柳州城市职业学院汽车检测与维修专业学生为研究对象,通过“互联网+”环境下的在线学习数据,采用Excel和Origin软件进行数理统计分析,以探讨学生的学习行为如何影响学习效果。研究结果表明:学生在学期开始阶段的学习投入程度较高,学习效果相对较高好;但在后续阶段则更多关注完成课后作业,而对学习的深层意义和持续投入有所忽视,并没有达到预期学习效果。根据数理统计分析得到的研究结果,并剖析问题结论,本文提出了改进在线课程设计、优化考核方式、加强在线学习监督与引导以及提供丰富的学习资源等教学改进建议。

典型纺织设备离散制造企业外购件BOM转化

A企业属于典型纺织设备离散制造企业,在采购业务实际运转中,由于部门职能分工不合理、业务流程不完善等问题,导致EBOM向PBOM转化困难。在企业现有条件下,通过部门职能调整、业务流程整改、数据整理、编码以及系统优化多方面探索,实现了企业外购件的BOM转换,为企业后续数字化转型奠定基础。

畅游数学海洋,探索圆的奥秘——《圆的周长》教学设计

创新整合点①Excel表格在线编辑功能可帮助教师及时收集学生课堂测量的数据。利用表格公式,拖拽下拉,快速生成大量数据,便于学生通过分析数据直观发现周长都是直径的3倍多。在此过程中引导学生初步发现倍数关系。

面向流动追踪的多层鲁棒Excel文档水印

Excel文档被广泛应用于金融财务、科学研究、数据分析、统计报告等领域,在教育培训、在线办公等诸多场景中扮演着重要角色,却也潜藏着违规使用、侵权行为和信息泄露等安全隐患。为保护Excel文档内容的安全,迫切需要研究更安全可靠的文档保护技术。文中基于Excel文档格式,提出了一种面向流动追踪的多层鲁棒Excel文档水印算法,该算法通过将多层水印信息嵌入Excel文档的单元格样式和边框的RGB颜色值中,从而能在实际应用场景中明确敏感文档传播链条,对文档泄露源头进行追踪溯源,定位泄密责任人,以减少信息泄露事件的发生。经实验对比发现,所提水印算法不可感知性好,对增加、删除、重新键入、格式刷、复制粘贴和另存为等多种常见文档操作和攻击具有很强的鲁棒性,同时支持多层水印嵌入。与其他基于文档格式的水印算法相比,所提算法具有更好的水印不可见性、更强的鲁棒性和更宽广的应用范围。

Facile synthesis of composite polyferric magnesium-silicate-sulfate coagulant with enhanced performance in water and wastewater

The coagulation process is a widely applied technology in water and wastewater treatment.Novel composite polyferric mag-nesium-silicate-sulfate(PFMS)coagulants were synthesized using Na_(2)SiO_(3)·9H_(2)O,Fe_(2)(SO_(4))_(3),and MgSO_(4) as raw materials in this paper.The effects of aging time,Fe:Si:Mg,and OH:M molar ratios(M represents the metal ions)on the coagulation performance of the as-pre-pared PFMS were systematically investigated to obtain optimum coagulants.The results showed that PFMS coagulant exhibited good co-agulation properties in the treatment of simulated humic acid-kaolin surface water and reactive dye wastewater.When the molar ratio was controlled at Fe:Si:Mg=2:2:1 and OH:M=0.32,the obtained PFMS presented excellent stability and a high coagulation efficiency.The removal efficiency of ultraviolet UV254 was 99.81%,and the residual turbidity of the surface water reached 0.56 NTU at a dosage of 30 mg·L^(-1).After standing the coagulant for 120 d in the laboratory,the removal efficiency of UV254 and residual turbidity of the surface wa-ter were 88.12%and 0.68 NTU,respectively,which accord with the surface water treatment requirements.In addition,the coagulation performance in the treatment of reactive dye wastewater was greatly improved by combining the advantages of magnesium and iron salts.Compared with polyferric silicate-sulfate(PFS)and polymagnesium silicate-sulfate(PMS),the PFMS coagulant played a better decolor-ization role within the pH range of 7-13.

Reactive molecular dynamics insight into the thermal decomposition mechanism of 2,6-Bis(picrylamino)-3,5-dinitropyridine

2,6-bis(picrylamino)-3,5-dinitropyridine(PYX)has excellent thermostability,which makes its thermal decomposition mechanism receive much attention.In this paper,the mechanism of PYX thermal decomposition was investigated thoroughly by the ReaxFF-lg force field combined with DFT-B3LYP(6-311++G)method.The detailed decomposition mechanism,small-molecule product evolution,and cluster evolution of PYX were mainly analyzed.In the initial stage of decomposition,the intramolecular hydrogen transfer reaction and the formation of dimerized clusters are earlier than the denitration reaction.With the progress of the reaction,one side of the bitter amino group is removed from the pyridine ring,and then the pyridine ring is cleaved.The final products produced in the thermal decomposition process are CO_(2),H_(2)O,N_(2),and H_(2).Among them,H_(2)O has the earliest generation time,and the reaction rate constant(k_(3))is the largest.Many clusters are formed during the decomposition of PYX,and the formation,aggregation,and decomposition of these clusters are strongly affected by temperature.At low temperatures(2500 K-2750 K),many clusters are formed.At high temperatures(2750 K-3250 K),the clusters aggregate to form larger clusters.At 3500 K,the large clusters decompose and become small.In the late stage of the reaction,H and N in the clusters escaped almost entirely,but more O was trapped in the clusters,which affected the auto-oxidation process of PYX.PYX's initial decomposition activation energy(E_(a))was calculated to be 126.58 kJ/mol.This work contributes to a theoretical understanding of PYX's entire thermal decomposition process.

Can ChatGPT evaluate research quality?

Purpose:Assess whether ChatGPT 4.0 is accurate enough to perform research evaluations on journal articles to automate this time-consuming task.Design/methodology/approach:Test the extent to which ChatGPT-4 can assess the quality of journal articles using a case study of the published scoring guidelines of the UK Research Excellence Framework(REF)2021 to create a research evaluation ChatGPT.This was applied to 51 of my own articles and compared against my own quality judgements.Findings:ChatGPT-4 can produce plausible document summaries and quality evaluation rationales that match the REF criteria.Its overall scores have weak correlations with my self-evaluation scores of the same documents(averaging r=0.281 over 15 iterations,with 8 being statistically significantly different from 0).In contrast,the average scores from the 15 iterations produced a statistically significant positive correlation of 0.509.Thus,averaging scores from multiple ChatGPT-4 rounds seems more effective than individual scores.The positive correlation may be due to ChatGPT being able to extract the author’s significance,rigour,and originality claims from inside each paper.If my weakest articles are removed,then the correlation with average scores(r=0.200)falls below statistical significance,suggesting that ChatGPT struggles to make fine-grained evaluations.Research limitations:The data is self-evaluations of a convenience sample of articles from one academic in one field.Practical implications:Overall,ChatGPT does not yet seem to be accurate enough to be trusted for any formal or informal research quality evaluation tasks.Research evaluators,including journal editors,should therefore take steps to control its use.Originality/value:This is the first published attempt at post-publication expert review accuracy testing for ChatGPT.

Design,preparation,application of advanced array structured materials and their action mechanism analyses for high performance lithium-sulfur batteries

Lithium-sulfur battery(LSB)has brought much attention and concern because of high theoretical specific capacity and energy density as one of main competitors for next-generation energy storage systems.The widely commercial application and development of LSB is mainly hindered by serious“shuttle effect”of lithium polysulfides(Li PSs),slow reaction kinetics,notorious lithium dendrites,etc.In various structures of LSB materials,array structured materials,possessing the composition of ordered micro units with the same or similar characteristics of each unit,present excellent application potential for various secondary cells due to some merits such as immobilization of active substances,high specific surface area,appropriate pore sizes,easy modification of functional material surface,accommodated huge volume change,enough facilitated transportation for electrons/lithium ions,and special functional groups strongly adsorbing Li PSs.Thus many novel array structured materials are applied to battery for tackling thorny problems mentioned above.In this review,recent progresses and developments on array structured materials applied in LSBs including preparation ways,collaborative structural designs based on array structures,and action mechanism analyses in improving electrochemical performance and safety are summarized.Meanwhile,we also have detailed discussion for array structured materials in LSBs and constructed the structure-function relationships between array structured materials and battery performances.Lastly,some directions and prospects about preparation ways,functional modifications,and practical applications of array structured materials in LSBs are generalized.We hope the review can attract more researchers'attention and bring more studying on array structured materials for other secondary batteries including LSB.

光学法CEMS颗粒物监测仪表的相关校准

烟气连续监测系统(CEMS)在检测烟气中颗粒物的质量浓度时,几乎没有可用的标准物质对颗粒物监测单元进行校准。因此,需要对光学原理颗粒物单元测得的原始参数进行回归计算,转换为环保要求的质量浓度数据。分析比较了国内外相关标准中颗粒物测量仪表的校准计算方法,重点参照HJ 75/76标准要求,以Excel作为回归计算工具,实现了快速的相关校准计算,并自动绘制相关曲线。同时,对目前颗粒物校准中遇到的普遍问题也探索了解决方法。

Enable Excel-Based Basic Cybersecurity Features for End Users by Using Python-Excel Integration

In the digital age, the global character of the Internet has significantly improved our daily lives by providing access to large amounts of knowledge and allowing for seamless connections. However, this enormously interconnected world is not without its risks. Malicious URLs are a powerful menace, masquerading as legitimate links while holding the intent to hack computer systems or steal sensitive personal information. As the sophistication and frequency of cyberattacks increase, identifying bad URLs has emerged as a critical aspect of cybersecurity. This study presents a new approach that enables the average end-user to check URL safety using Microsoft Excel. Using the powerful VirusTotal API for URL inspections, this study creates an Excel add-in that integrates Python and Excel to deliver a seamless, user-friendly interface. Furthermore, the study improves Excel’s capabilities by allowing users to encrypt and decrypt text communications directly in the spreadsheet. Users may easily encrypt their conversations by simply typing a key and the required text into predefined cells, enhancing their personal cybersecurity with a layer of cryptographic secrecy. This strategy democratizes access to advanced cybersecurity solutions, making attentive digital integrity a feature rather than a daunting burden.

依托三阶段啤酒游戏的“供应链管理”一体化课程设计

啤酒游戏是“供应链管理”课程教学过程中一项普遍应用的实验教学内容。在传统手动啤酒游戏的基础上,增加深圳中诺思与大连海事大学联合开发的数智啤酒游戏在线实验,引导学生自主设计基于Excel的多个供应链决策仿真实验,体现基于系统思考的供应链管理相关教学内容,构建以行动学习和以学生为中心的依托三阶段啤酒游戏的一体化教学框架,增强学生的自主研究能力、创新能力和批判性思维。

Enhancing Data Analysis and Automation: Integrating Python with Microsoft Excel for Non-Programmers

Microsoft Excel is essential for the End-User Approach (EUA), offering versatility in data organization, analysis, and visualization, as well as widespread accessibility. It fosters collaboration and informed decision-making across diverse domains. Conversely, Python is indispensable for professional programming due to its versatility, readability, extensive libraries, and robust community support. It enables efficient development, advanced data analysis, data mining, and automation, catering to diverse industries and applications. However, one primary issue when using Microsoft Excel with Python libraries is compatibility and interoperability. While Excel is a widely used tool for data storage and analysis, it may not seamlessly integrate with Python libraries, leading to challenges in reading and writing data, especially in complex or large datasets. Additionally, manipulating Excel files with Python may not always preserve formatting or formulas accurately, potentially affecting data integrity. Moreover, dependency on Excel’s graphical user interface (GUI) for automation can limit scalability and reproducibility compared to Python’s scripting capabilities. This paper covers the integration solution of empowering non-programmers to leverage Python’s capabilities within the familiar Excel environment. This enables users to perform advanced data analysis and automation tasks without requiring extensive programming knowledge. Based on Soliciting feedback from non-programmers who have tested the integration solution, the case study shows how the solution evaluates the ease of implementation, performance, and compatibility of Python with Excel versions.