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...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.展开更多
To simulate the process of cold roll-forming process, a new method isadopted. The theoretical foundation of this method is an elastic-plastic large deformation splinefinite strip method based on object-oriented progra...To simulate the process of cold roll-forming process, a new method isadopted. The theoretical foundation of this method is an elastic-plastic large deformation splinefinite strip method based on object-oriented programming. Combined with the computer graphicstechnology, the visual simulation of cold roll-forming is completed and the system is established.By analyzing common channel steel, the process is shown and explained including theory method, modeland result display. So the simulation system is already a kind of mature and effective tool toanalyze the process of cold roll forming.展开更多
Based on former studies on weather simulator modules in IPMist laboratory, study on visual programming of stochastic weather generator(VS-WGEN)was continued. In this study, Markov Chain, Monte Carlo, Fourier Series, a...Based on former studies on weather simulator modules in IPMist laboratory, study on visual programming of stochastic weather generator(VS-WGEN)was continued. In this study, Markov Chain, Monte Carlo, Fourier Series, and weak stationary process were used to generate the daily weather data in software Matlab 6. 0, with the data input from 40 years' weather data recorded by Beijing Weather Station. The generated data includes daily maximum temperature, minimum temperature, precipitation and solar radiation. It has been verified that the weather data generated by the VS-WGEN were more accurate than that by the old WGEN, when twenty new model parameters were included. VS-WGEN has wide software applications, such as pest risk analysis, pest forecast and management. It can be implemented in hardware development as well, such as weather control in weather chamber and greenhouse for researches on ecological adaptation of crop varieties to a given location over time and space. Overall, VS-WGEN is a very useful tool for studies on theoretical and applied ecology.展开更多
The purpose of this research is the design and implementation of a support system for learning programming. To archive this purpose, in this article, we propose a Puzzle Programming System that uses jigsaw puzzles as ...The purpose of this research is the design and implementation of a support system for learning programming. To archive this purpose, in this article, we propose a Puzzle Programming System that uses jigsaw puzzles as an example of the application of physical visualization, which visualizes logical constraints to physical ones. This Puzzle Programming System aims to teach basic programming concepts by presenting the invisible constraints of programming language syntax using the visual constraints of jigsaw puzzle pieces. This system runs on an Apple iPad and was developed using the Unity game engine. We used YAML as a data format for serializing structured data for data management. By inviting high school students to try out a prototype, we could confirm the usefulness of the Puzzle Programming System. The experimental evaluation results also shed light on aspects of the game that need to be redesigned and parts where the visual programming model needs to be modified and expanded.展开更多
Based on the ablation micro-morphological characteristics, thermo-chemical ablation mechanism, and mechanical stripping mechanism, a dual-region solid rocket motor C/C throat liner ablation model and physical model ar...Based on the ablation micro-morphological characteristics, thermo-chemical ablation mechanism, and mechanical stripping mechanism, a dual-region solid rocket motor C/C throat liner ablation model and physical model are established. The ablation program was written and the experimental data of 70 lb BATES engine platform was used for model validation. The relative errors between the simulation calculation results and the experimental results were −6.83% - 10.20%. The ablation program was applied to study the effects of combustion chamber temperature, pressure, oxidation component concentration, throat particle concentration and particle scouring angle on the nozzle throat liner, which provides a reference for the design of the nozzle throat liner and the estimation of solid rocket motor ablation.展开更多
文摘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.
基金This project is supported by Provincial Natural Science Foundation of Hebei (No.502214).
文摘To simulate the process of cold roll-forming process, a new method isadopted. The theoretical foundation of this method is an elastic-plastic large deformation splinefinite strip method based on object-oriented programming. Combined with the computer graphicstechnology, the visual simulation of cold roll-forming is completed and the system is established.By analyzing common channel steel, the process is shown and explained including theory method, modeland result display. So the simulation system is already a kind of mature and effective tool toanalyze the process of cold roll forming.
基金supported jointly by the grant of Project“973”:Fundamental Studies on Invasion and Control of Extra Pest(2002CB111400)the grant of Key Project of Ministry of Science and Technology of China:Development of New Technologies for Pest Forecasting(2001BA50PB01).
文摘Based on former studies on weather simulator modules in IPMist laboratory, study on visual programming of stochastic weather generator(VS-WGEN)was continued. In this study, Markov Chain, Monte Carlo, Fourier Series, and weak stationary process were used to generate the daily weather data in software Matlab 6. 0, with the data input from 40 years' weather data recorded by Beijing Weather Station. The generated data includes daily maximum temperature, minimum temperature, precipitation and solar radiation. It has been verified that the weather data generated by the VS-WGEN were more accurate than that by the old WGEN, when twenty new model parameters were included. VS-WGEN has wide software applications, such as pest risk analysis, pest forecast and management. It can be implemented in hardware development as well, such as weather control in weather chamber and greenhouse for researches on ecological adaptation of crop varieties to a given location over time and space. Overall, VS-WGEN is a very useful tool for studies on theoretical and applied ecology.
文摘The purpose of this research is the design and implementation of a support system for learning programming. To archive this purpose, in this article, we propose a Puzzle Programming System that uses jigsaw puzzles as an example of the application of physical visualization, which visualizes logical constraints to physical ones. This Puzzle Programming System aims to teach basic programming concepts by presenting the invisible constraints of programming language syntax using the visual constraints of jigsaw puzzle pieces. This system runs on an Apple iPad and was developed using the Unity game engine. We used YAML as a data format for serializing structured data for data management. By inviting high school students to try out a prototype, we could confirm the usefulness of the Puzzle Programming System. The experimental evaluation results also shed light on aspects of the game that need to be redesigned and parts where the visual programming model needs to be modified and expanded.
文摘Based on the ablation micro-morphological characteristics, thermo-chemical ablation mechanism, and mechanical stripping mechanism, a dual-region solid rocket motor C/C throat liner ablation model and physical model are established. The ablation program was written and the experimental data of 70 lb BATES engine platform was used for model validation. The relative errors between the simulation calculation results and the experimental results were −6.83% - 10.20%. The ablation program was applied to study the effects of combustion chamber temperature, pressure, oxidation component concentration, throat particle concentration and particle scouring angle on the nozzle throat liner, which provides a reference for the design of the nozzle throat liner and the estimation of solid rocket motor ablation.