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.展开更多
Real-time multimedia sharing in Consumer-centric Multimedia Network(CMN) requires usability anywhere, anytime and from any device. However, CMNs are usually located or implemented on application layer, which makes CMN...Real-time multimedia sharing in Consumer-centric Multimedia Network(CMN) requires usability anywhere, anytime and from any device. However, CMNs are usually located or implemented on application layer, which makes CMNs subjected to their fixed substrate security framework. A fundamental diversifying attribute for the customized security experiences of CMNs is pressing. This paper proposes a programmable network structure which is named Service Processing Chain(SPC) based on network function combination. The SPC is established by the ordinal combination of network functions in substrate switches dynamically, and therefore constructs a special channel for each CMN with required security. The construction and reconfiguration algorithms of SPC are also discussed in this paper. Evaluations and implementation show that above approaches are effective in providing multilevel security with flexibility and expansibility. It is believed that the SPC could provide customized security service and drive participative real-time multimedia sharing for CMNs.展开更多
针对部分机电产品在概念设计阶段未综合考虑客户和环境的需求,进而影响产品详细设计的问题,提出了一种基于功能—结构—客户和环境需求(function‒structure‒requirements of customer and environment,FSRce)模型的机电产品绿色概念设...针对部分机电产品在概念设计阶段未综合考虑客户和环境的需求,进而影响产品详细设计的问题,提出了一种基于功能—结构—客户和环境需求(function‒structure‒requirements of customer and environment,FSRce)模型的机电产品绿色概念设计方案生成方法。首先,从案例库中选择合适的功能和结构对现有产品设计树中的节点进行扩展和关联;同时通过数据挖掘、专家打分等方法获得产品的客户和环境需求重要度,以构建基于FSRce模型的产品概念设计空间。然后,先利用加权区间粗糙数法对客户和环境需求重要度进行分析,得到需求相对重要度,再运用模糊质量功能展开(fuzzy quality function deployment,FQFD)将需求相对重要度转化为产品的工程特性权重。最后,利用物元理论构建基于工程特性的产品物元域和各结构物元集,并结合工程特性权重得到各结构的满意度分值,通过比较满意度优选得到满足客户和环境需求的产品概念设计方案。以某小型工业吹风机为例,基于上述方法对其概念设计方案进行优化。相比于原始方案,优化后的吹风机在能源消耗上降低了15.38%,在碳排放上降低了15.32%,且客户满意度提高了44.66%,由此验证了所提出方法的可行性与有效性。所提出的方法为机电产品概念设计方案的生成提供了一种新思路,能更好地辅助设计人员实现对机电产品的绿色设计。展开更多
Quality function deployment (QFD) is a well-known customer-oriented product design methodology. Rating the final importance of customer requirements (CRs) is really a very es- sential starting point in the impleme...Quality function deployment (QFD) is a well-known customer-oriented product design methodology. Rating the final importance of customer requirements (CRs) is really a very es- sential starting point in the implementation of QFD, since it largely affects the target setting value of design requirements. This pa- per aims to propose a novel method to deal with the relative importance ratings (RIRs) of CRs problem considering customers' diversified requirements and unknown information on customers' weights, which is an indispensable process for determining the final importance ratings of CRs. First, a new concept of customer's assessment structure is proposed according to the basic idea of grey relational analysis (GRA), and then a constrained nonlinear optimization model is constructed to describe the assessment information aggregation factors of CRs considering customers' personalized and diversified requirements. Furthermore, an im- mune particle swarm optimization (IPSO) algorithm is designed to solve the model, and the weight vector of customers is obtained. Finally, a car door design example is introduced to illustrate the novel hybrid GRA-IPSO method's potential application in deter- mining the RIRs of CRs.展开更多
Corresponding customized software tool is usually unavailable, which increases the time and workload for evaluating the results of a clinical trial. In the present paper, we demonstrate the development process of a cu...Corresponding customized software tool is usually unavailable, which increases the time and workload for evaluating the results of a clinical trial. In the present paper, we demonstrate the development process of a customized software for one clinical trial on patients with obstructive lung disease. Over hundred patients and volunteers as controlled were included in the clinical trial. They were examined by spirometry and EIT in a seated position during spontaneous tidal breathing. Subsequently, standard vital capacity maneuver and forced full expiration maneuver were performed. In order to evaluate the offline data, a customized software was developed. The requirements of the software were defined by investigators. The software was then tested on patients’ data and refined based on feedbacks of the investigators. We finalized the customized software with analysis of various disease-specific parameters and indices. Compared to the data process with device specific programs and other commercial software, the customized software is more flexible, user-friendly and extendable. As conclusion, customized software simplifies the evaluation process distinctly and helps physicians to focus on study design and result interpretation.展开更多
In the implementation of quality function deployment (QFD), the determination of the target values of engineering characteristics is a complex decision process with multiple variables and multiple objectives that sh...In the implementation of quality function deployment (QFD), the determination of the target values of engineering characteristics is a complex decision process with multiple variables and multiple objectives that should trade off, and optimize all kinds of conflicts and constraints. A fuzzy linear programming model (FLP) is proposed. On the basis of the inherent fuzziness of QFD system, triangular fuzzy numbers are used to represent all the relationships and correlations, and then, the functional relationships between the customer needs and engineering characteristics and the functional correlations among the engineering characteristics are determined with the information in the house of quality (HoQ) fully used. The fuzzy linear programming (FLP) model aims to find the optimal target values of the engineering characteristics to maximize the customer satisfaction. Finally, the proposed method is illustrated by a numerical example.展开更多
文摘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.
基金supported by The National Basic Research Program of China (973) (Grant No. 2012CB315901, 2013CB329104)The National Natural Science Foundation of China (Grant No. 61521003, 61372121, 61309019, 61572519, 61502530)The National High Technology Research and Development Program of China (863) (Grant No. 2015AA016102)
文摘Real-time multimedia sharing in Consumer-centric Multimedia Network(CMN) requires usability anywhere, anytime and from any device. However, CMNs are usually located or implemented on application layer, which makes CMNs subjected to their fixed substrate security framework. A fundamental diversifying attribute for the customized security experiences of CMNs is pressing. This paper proposes a programmable network structure which is named Service Processing Chain(SPC) based on network function combination. The SPC is established by the ordinal combination of network functions in substrate switches dynamically, and therefore constructs a special channel for each CMN with required security. The construction and reconfiguration algorithms of SPC are also discussed in this paper. Evaluations and implementation show that above approaches are effective in providing multilevel security with flexibility and expansibility. It is believed that the SPC could provide customized security service and drive participative real-time multimedia sharing for CMNs.
文摘针对部分机电产品在概念设计阶段未综合考虑客户和环境的需求,进而影响产品详细设计的问题,提出了一种基于功能—结构—客户和环境需求(function‒structure‒requirements of customer and environment,FSRce)模型的机电产品绿色概念设计方案生成方法。首先,从案例库中选择合适的功能和结构对现有产品设计树中的节点进行扩展和关联;同时通过数据挖掘、专家打分等方法获得产品的客户和环境需求重要度,以构建基于FSRce模型的产品概念设计空间。然后,先利用加权区间粗糙数法对客户和环境需求重要度进行分析,得到需求相对重要度,再运用模糊质量功能展开(fuzzy quality function deployment,FQFD)将需求相对重要度转化为产品的工程特性权重。最后,利用物元理论构建基于工程特性的产品物元域和各结构物元集,并结合工程特性权重得到各结构的满意度分值,通过比较满意度优选得到满足客户和环境需求的产品概念设计方案。以某小型工业吹风机为例,基于上述方法对其概念设计方案进行优化。相比于原始方案,优化后的吹风机在能源消耗上降低了15.38%,在碳排放上降低了15.32%,且客户满意度提高了44.66%,由此验证了所提出方法的可行性与有效性。所提出的方法为机电产品概念设计方案的生成提供了一种新思路,能更好地辅助设计人员实现对机电产品的绿色设计。
基金supported by the Fundamental Research Funds for the Central Universities(K5051399035BDY251412+1 种基金JB150601)the Soft Science Project of Shaanxi Province(2013KRZ25)
文摘Quality function deployment (QFD) is a well-known customer-oriented product design methodology. Rating the final importance of customer requirements (CRs) is really a very es- sential starting point in the implementation of QFD, since it largely affects the target setting value of design requirements. This pa- per aims to propose a novel method to deal with the relative importance ratings (RIRs) of CRs problem considering customers' diversified requirements and unknown information on customers' weights, which is an indispensable process for determining the final importance ratings of CRs. First, a new concept of customer's assessment structure is proposed according to the basic idea of grey relational analysis (GRA), and then a constrained nonlinear optimization model is constructed to describe the assessment information aggregation factors of CRs considering customers' personalized and diversified requirements. Furthermore, an im- mune particle swarm optimization (IPSO) algorithm is designed to solve the model, and the weight vector of customers is obtained. Finally, a car door design example is introduced to illustrate the novel hybrid GRA-IPSO method's potential application in deter- mining the RIRs of CRs.
文摘Corresponding customized software tool is usually unavailable, which increases the time and workload for evaluating the results of a clinical trial. In the present paper, we demonstrate the development process of a customized software for one clinical trial on patients with obstructive lung disease. Over hundred patients and volunteers as controlled were included in the clinical trial. They were examined by spirometry and EIT in a seated position during spontaneous tidal breathing. Subsequently, standard vital capacity maneuver and forced full expiration maneuver were performed. In order to evaluate the offline data, a customized software was developed. The requirements of the software were defined by investigators. The software was then tested on patients’ data and refined based on feedbacks of the investigators. We finalized the customized software with analysis of various disease-specific parameters and indices. Compared to the data process with device specific programs and other commercial software, the customized software is more flexible, user-friendly and extendable. As conclusion, customized software simplifies the evaluation process distinctly and helps physicians to focus on study design and result interpretation.
基金supported by the National Natural Science Foundation of China (70571041).
文摘In the implementation of quality function deployment (QFD), the determination of the target values of engineering characteristics is a complex decision process with multiple variables and multiple objectives that should trade off, and optimize all kinds of conflicts and constraints. A fuzzy linear programming model (FLP) is proposed. On the basis of the inherent fuzziness of QFD system, triangular fuzzy numbers are used to represent all the relationships and correlations, and then, the functional relationships between the customer needs and engineering characteristics and the functional correlations among the engineering characteristics are determined with the information in the house of quality (HoQ) fully used. The fuzzy linear programming (FLP) model aims to find the optimal target values of the engineering characteristics to maximize the customer satisfaction. Finally, the proposed method is illustrated by a numerical example.