End-user computing empowers non-developers to manage data and applications, enhancing collaboration and efficiency. Spreadsheets, a prime example of end-user programming environments widely used in business for data a...End-user computing empowers non-developers to manage data and applications, enhancing collaboration and efficiency. Spreadsheets, a prime example of end-user programming environments widely used in business for data analysis. However, Excel functionalities have limits compared to dedicated programming languages. This paper addresses this gap by proposing a prototype for integrating Python’s capabilities into Excel through on-premises desktop to build custom spreadsheet functions with Python. This approach overcomes potential latency issues associated with cloud-based solutions. This prototype utilizes Excel-DNA and IronPython. Excel-DNA allows creating custom Python functions that seamlessly integrate with Excel’s calculation engine. IronPython enables the execution of these Python (CSFs) directly within Excel. C# and VSTO add-ins form the core components, facilitating communication between Python and Excel. This approach empowers users with a potentially open-ended set of Python (CSFs) for tasks like mathematical calculations, statistical analysis, and even predictive modeling, all within the familiar Excel interface. This prototype demonstrates smooth integration, allowing users to call Python (CSFs) just like standard Excel functions. This research contributes to enhancing spreadsheet capabilities for end-user programmers by leveraging Python’s power within Excel. Future research could explore expanding data analysis capabilities by expanding the (CSFs) functions for complex calculations, statistical analysis, data manipulation, and even external library integration. The possibility of integrating machine learning models through the (CSFs) functions within the familiar Excel environment.展开更多
The capacitor bank and synchronous condenser have been the only available sources of reactive power.Nowadays,most of the appliances use a power electronic interface for their connection.Applying a power electronic int...The capacitor bank and synchronous condenser have been the only available sources of reactive power.Nowadays,most of the appliances use a power electronic interface for their connection.Applying a power electronic interface addsmany features to these appliances.One of the promising features is their capability to interact with Volt-VAR programs.In this paper was investigated the reactive power interaction of the end-user appliances.For this purpose,the distribution network buses are ranked based on their effectiveness,followed by studying their interaction in the Volt-VAR program.To be able to consider the uncertainties,Probability Density Function(PDF)curve was discretized to represent different scenarios,and the reduction method was utilized to reduce the situations.展开更多
High-molecular-weight glutenin subunits(HMW-GSs) are the most critical grain storage proteins that determine the unique processing qualities of wheat. Although it is a part of the superior HMW-GS pair(Dx5+Dy10), the c...High-molecular-weight glutenin subunits(HMW-GSs) are the most critical grain storage proteins that determine the unique processing qualities of wheat. Although it is a part of the superior HMW-GS pair(Dx5+Dy10), the contribution of the Dy10 subunit to wheat processing quality remains unclear. In this study, we elucidated the effect of Dy10 on wheat processing quality by generating and analyzing a deletion mutant(with the Dy10-null allele), and by elucidating the changes to wheat flour following the incorporation of purified Dy10. The Dy10-null allele was transcribed normally,but the Dy10 subunit was lacking. These findings implied that the Dy10-null allele reduced the glutenin:gliadin ratio and negatively affected dough strength(i.e., Zeleny sedimentation value, gluten index, and dough development and stability times) and the bread-making quality;however, it positively affected the biscuit-making quality. The incorporation of various amounts of purified Dy10 into wheat flour had a detrimental effect on biscuit-making quality. The results of this study demonstrate that the Dy10 subunit is essential for maintaining wheat dough strength. Furthermore, the Dy10-null allele may be exploited by soft wheat breeding programs.展开更多
This study was performed to identify how the different levels of nitrogen application affected the variances of gluten properties and end-use qualities and the differences of variances among Korean wheat cultivars. Pr...This study was performed to identify how the different levels of nitrogen application affected the variances of gluten properties and end-use qualities and the differences of variances among Korean wheat cultivars. Protein and dry gluten content, SDS sedimentation volume and water absorption of Mixolab increased as nitrogen application increased. This ratio of the increase was higher in Korean wheat cultivars for bread than in Korean wheat cultivars for noodles and cookies. The proportion of（α＋β）-gliadin measured by reversed-phase high-performance liquid chromatography（RP-HPLC） increased, but the proportion of ω-and γ-gliadin decreased as the protein content increased. The Korean wheat cultivars for bread showed a high proportion of（α＋β）-gliadin increase, the Korean cultivars for noodles had a high proportion of γ-gliadin decrease and the Korean wheat cultivars for cookies had a high proportion of ω-gliadin decrease. However, there was no variation of the component in the proportion of glutenin component measured by RP-HPLC, even though the protein content was increased, but all of the protein fractions measured by size exclusion（SE）-HPLC were increased. The soluble monomeric protein showed a high proportion of Korean wheat cultivars for bread by the increase of protein content. Bread loaf volume increased by the increase of protein content but there were no variances in the ratio of increase among Korean wheat cultivars. The cookie diameter decreased with the increase of protein content, and this ratio of decrease was the highest in Korean wheat cultivars for cookies. The hardness of cooked noodles also increased by the increase of protein content but there were no variations in springiness and cohesiveness. The decrease proportion of ω-gliadin affected the increase of bread loaf volume, the hardness of cooked noodles, and the decrease of cookie diameter.展开更多
The relative content of Pb and its correlation were investigated in endosperm, aleurone layer and pericarp respectively among different wheat varieties for specific end-uses (WVFSE) using scanning electron microscope ...The relative content of Pb and its correlation were investigated in endosperm, aleurone layer and pericarp respectively among different wheat varieties for specific end-uses (WVFSE) using scanning electron microscope (SEM) equipped with the energy dispersive X-ray spectroscope (EDS). The results showed that Pb contents in grains at different positions followed the order of endosperm > pericarp > aleurone. The differences of Pb contents varied among the WVFSE, and wheat with strong gluten had a highest average content of Pb, while wheat with medium gluten had a lowest one. There were significant third order equation correlations between Pb content in endosperm and that in aleurone layer and that in pericarp, respectively. And good correlation coefficients were obtained. However, the correlation differed at different position among WVFSE, which indicated that Pb contents in endosperm, aleurone layer and pericarp were regulated by each other.展开更多
The effects of incorporating pineapple leaf fibre (PLF) as a filler on the end-end properties of natural rubber vulcanizates were studied at different filler contents and particle sizes. The pineapple leaf fibre was u...The effects of incorporating pineapple leaf fibre (PLF) as a filler on the end-end properties of natural rubber vulcanizates were studied at different filler contents and particle sizes. The pineapple leaf fibre was used within filler contents, 0 to 40 phr at the following filler particle sizes, 75, 150 and 300 μm. The PLF was characterized for filler properties while carbon black (N330) served as the reference filler. The natural rubber vulcanizates were compounded on a two-roll mill. Results showed that the abrasion resistance of filled natural rubber vulcanizates was generally higher than that of the unfilled natural rubber vulcanizate at filler content, 5 phr, and for PLF (150 and 300 μm) and carbon black filled natural rubber vulcanizates, the abrasion resistance decreased within filler content, 5 to 20 phr after which it increased with filler content. CB exhibited better abrasion resistance in the vulcanizates than PLF at filler contents greater than 20 phr. The hardness of filled natural rubber vulccanizates was generally greater than that of unfilled vulcanizate and increased with increases in filler particle size at filler contents, 10 and 20 phr. The specific gravity of the rubber vulcanizates increased gradually with the increase in filler content at filler content greater than 5 phr, and increased with increases in filler particle size at any filler content considered. The swelling index of filled natural rubber vulcanizates in toluene generally decreased with increasing filler particle size at filler contents, 5, 10 and 40 phr whereas the swelling index for PLF (150 μm) filled natural rubber decreased with increases in filler content. CB filled vulcanizates absorbed the highest amount of toluene (2.5%) in the vulcanizates at filler content, 40 phr. PLF (150 and 300 μm) generally gave optimum performances in the end-use properties of the rubber vulcanizates determined within filler contents, 30 and 40 phr. The incorporation of pineapple leaf fibre into natural rubber was found to improve the end-use properties of natural rubber vulcanizates and therefore, has potential in the formulation of natural rubber products.展开更多
End-use energy consumption can reflect the industrial development of a country and the living standards of its residents. The study of end-use energy consumption can provide a solid basis for industrial restructuring,...End-use energy consumption can reflect the industrial development of a country and the living standards of its residents. The study of end-use energy consumption can provide a solid basis for industrial restructuring, energy saving, and emission reduction. In this paper, we analyzed the end-use energy consumption of a region in Northwestern China, and applied the Markov prediction method to forecast the future demand of different types of end-use energy. This provides a reference for the energy structure optimization in the Northwestern China.展开更多
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 int...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.展开更多
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.展开更多
文摘End-user computing empowers non-developers to manage data and applications, enhancing collaboration and efficiency. Spreadsheets, a prime example of end-user programming environments widely used in business for data analysis. However, Excel functionalities have limits compared to dedicated programming languages. This paper addresses this gap by proposing a prototype for integrating Python’s capabilities into Excel through on-premises desktop to build custom spreadsheet functions with Python. This approach overcomes potential latency issues associated with cloud-based solutions. This prototype utilizes Excel-DNA and IronPython. Excel-DNA allows creating custom Python functions that seamlessly integrate with Excel’s calculation engine. IronPython enables the execution of these Python (CSFs) directly within Excel. C# and VSTO add-ins form the core components, facilitating communication between Python and Excel. This approach empowers users with a potentially open-ended set of Python (CSFs) for tasks like mathematical calculations, statistical analysis, and even predictive modeling, all within the familiar Excel interface. This prototype demonstrates smooth integration, allowing users to call Python (CSFs) just like standard Excel functions. This research contributes to enhancing spreadsheet capabilities for end-user programmers by leveraging Python’s power within Excel. Future research could explore expanding data analysis capabilities by expanding the (CSFs) functions for complex calculations, statistical analysis, data manipulation, and even external library integration. The possibility of integrating machine learning models through the (CSFs) functions within the familiar Excel environment.
文摘The capacitor bank and synchronous condenser have been the only available sources of reactive power.Nowadays,most of the appliances use a power electronic interface for their connection.Applying a power electronic interface addsmany features to these appliances.One of the promising features is their capability to interact with Volt-VAR programs.In this paper was investigated the reactive power interaction of the end-user appliances.For this purpose,the distribution network buses are ranked based on their effectiveness,followed by studying their interaction in the Volt-VAR program.To be able to consider the uncertainties,Probability Density Function(PDF)curve was discretized to represent different scenarios,and the reduction method was utilized to reduce the situations.
基金supported by the National Natural Science Foundation of China (31971939, 32072054, and 31901961)the Science and Technology Department of Sichuan Province, China (2019YFH0066 and 2020YFH0150)the Designing Future Wheat Strategic Program of the UK (BB/P016855/1)。
文摘High-molecular-weight glutenin subunits(HMW-GSs) are the most critical grain storage proteins that determine the unique processing qualities of wheat. Although it is a part of the superior HMW-GS pair(Dx5+Dy10), the contribution of the Dy10 subunit to wheat processing quality remains unclear. In this study, we elucidated the effect of Dy10 on wheat processing quality by generating and analyzing a deletion mutant(with the Dy10-null allele), and by elucidating the changes to wheat flour following the incorporation of purified Dy10. The Dy10-null allele was transcribed normally,but the Dy10 subunit was lacking. These findings implied that the Dy10-null allele reduced the glutenin:gliadin ratio and negatively affected dough strength(i.e., Zeleny sedimentation value, gluten index, and dough development and stability times) and the bread-making quality;however, it positively affected the biscuit-making quality. The incorporation of various amounts of purified Dy10 into wheat flour had a detrimental effect on biscuit-making quality. The results of this study demonstrate that the Dy10 subunit is essential for maintaining wheat dough strength. Furthermore, the Dy10-null allele may be exploited by soft wheat breeding programs.
基金the support of Cooperative Research Program for Agriculture Science & Technology Development, Rural Development Administration, Republic of Korea (PJ011009)
文摘This study was performed to identify how the different levels of nitrogen application affected the variances of gluten properties and end-use qualities and the differences of variances among Korean wheat cultivars. Protein and dry gluten content, SDS sedimentation volume and water absorption of Mixolab increased as nitrogen application increased. This ratio of the increase was higher in Korean wheat cultivars for bread than in Korean wheat cultivars for noodles and cookies. The proportion of（α＋β）-gliadin measured by reversed-phase high-performance liquid chromatography（RP-HPLC） increased, but the proportion of ω-and γ-gliadin decreased as the protein content increased. The Korean wheat cultivars for bread showed a high proportion of（α＋β）-gliadin increase, the Korean cultivars for noodles had a high proportion of γ-gliadin decrease and the Korean wheat cultivars for cookies had a high proportion of ω-gliadin decrease. However, there was no variation of the component in the proportion of glutenin component measured by RP-HPLC, even though the protein content was increased, but all of the protein fractions measured by size exclusion（SE）-HPLC were increased. The soluble monomeric protein showed a high proportion of Korean wheat cultivars for bread by the increase of protein content. Bread loaf volume increased by the increase of protein content but there were no variances in the ratio of increase among Korean wheat cultivars. The cookie diameter decreased with the increase of protein content, and this ratio of decrease was the highest in Korean wheat cultivars for cookies. The hardness of cooked noodles also increased by the increase of protein content but there were no variations in springiness and cohesiveness. The decrease proportion of ω-gliadin affected the increase of bread loaf volume, the hardness of cooked noodles, and the decrease of cookie diameter.
文摘The relative content of Pb and its correlation were investigated in endosperm, aleurone layer and pericarp respectively among different wheat varieties for specific end-uses (WVFSE) using scanning electron microscope (SEM) equipped with the energy dispersive X-ray spectroscope (EDS). The results showed that Pb contents in grains at different positions followed the order of endosperm > pericarp > aleurone. The differences of Pb contents varied among the WVFSE, and wheat with strong gluten had a highest average content of Pb, while wheat with medium gluten had a lowest one. There were significant third order equation correlations between Pb content in endosperm and that in aleurone layer and that in pericarp, respectively. And good correlation coefficients were obtained. However, the correlation differed at different position among WVFSE, which indicated that Pb contents in endosperm, aleurone layer and pericarp were regulated by each other.
文摘The effects of incorporating pineapple leaf fibre (PLF) as a filler on the end-end properties of natural rubber vulcanizates were studied at different filler contents and particle sizes. The pineapple leaf fibre was used within filler contents, 0 to 40 phr at the following filler particle sizes, 75, 150 and 300 μm. The PLF was characterized for filler properties while carbon black (N330) served as the reference filler. The natural rubber vulcanizates were compounded on a two-roll mill. Results showed that the abrasion resistance of filled natural rubber vulcanizates was generally higher than that of the unfilled natural rubber vulcanizate at filler content, 5 phr, and for PLF (150 and 300 μm) and carbon black filled natural rubber vulcanizates, the abrasion resistance decreased within filler content, 5 to 20 phr after which it increased with filler content. CB exhibited better abrasion resistance in the vulcanizates than PLF at filler contents greater than 20 phr. The hardness of filled natural rubber vulccanizates was generally greater than that of unfilled vulcanizate and increased with increases in filler particle size at filler contents, 10 and 20 phr. The specific gravity of the rubber vulcanizates increased gradually with the increase in filler content at filler content greater than 5 phr, and increased with increases in filler particle size at any filler content considered. The swelling index of filled natural rubber vulcanizates in toluene generally decreased with increasing filler particle size at filler contents, 5, 10 and 40 phr whereas the swelling index for PLF (150 μm) filled natural rubber decreased with increases in filler content. CB filled vulcanizates absorbed the highest amount of toluene (2.5%) in the vulcanizates at filler content, 40 phr. PLF (150 and 300 μm) generally gave optimum performances in the end-use properties of the rubber vulcanizates determined within filler contents, 30 and 40 phr. The incorporation of pineapple leaf fibre into natural rubber was found to improve the end-use properties of natural rubber vulcanizates and therefore, has potential in the formulation of natural rubber products.
基金Supported by the National Natural Science Foundation of China(71471059)
文摘End-use energy consumption can reflect the industrial development of a country and the living standards of its residents. The study of end-use energy consumption can provide a solid basis for industrial restructuring, energy saving, and emission reduction. In this paper, we analyzed the end-use energy consumption of a region in Northwestern China, and applied the Markov prediction method to forecast the future demand of different types of end-use energy. This provides a reference for the energy structure optimization in the Northwestern China.
文摘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.
文摘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.
