Dataset Information

Analytical Solution of the Time-Dependent Microfluidic Poiseuille Flow in Rectangular Channel Cross-Sections and its Numerical Implementation in Microsoft Excel.

ABSTRACT: We recently demonstrated that the Navier-Stokes equation for pressure-driven laminar (Poiseuille) flow can be solved in any channel cross-section using a finite difference scheme implemented in a spreadsheet analysis tool such as Microsoft Excel. We also showed that implementing different boundary conditions (slip, no-slip) is straight-forward. The results obtained in such calculations only deviated by a few percent from the (exact) analytical solution. In this paper we demonstrate that these approaches extend to cases where time-dependency is of importance, e.g., during initiation or after removal of the driving pressure. As will be shown, the developed spread-sheet can be used conveniently for almost any cross-section for which analytical solutions are close-to-impossible to obtain. We believe that providing researchers with convenient tools to derive solutions to complex flow problems in a fast and intuitive way will significantly enhance the understanding of the flow conditions as well as mass and heat transfer kinetics in microfluidic systems.

SUBMITTER: Risch P

PROVIDER: S-EPMC6628308 | biostudies-literature | 2019 May

REPOSITORIES: biostudies-literature

ACCESS DATA

Publications

Analytical Solution of the Time-Dependent Microfluidic Poiseuille Flow in Rectangular Channel Cross-Sections and its Numerical Implementation in Microsoft Excel.

Risch Patrick P Helmer Dorothea D Kotz Frederik F Rapp Bastian E BE

Biosensors 20190524 2

We recently demonstrated that the Navier-Stokes equation for pressure-driven laminar (Poiseuille) flow can be solved in any channel cross-section using a finite difference scheme implemented in a spreadsheet analysis tool such as Microsoft Excel. We also showed that implementing different boundary conditions (slip, no-slip) is straight-forward. The results obtained in such calculations only deviated by a few percent from the (exact) analytical solution. In this paper we demonstrate that these ap ...[more]

PMID: 31137723

Similar Datasets

Project description:BACKGROUND:Burnout (BO), a critical syndrome particularly for nurses in health care settings, substantially affects their physical and psychological status, the institute's well-being, and indirectly, patient outcomes. However, objectively classifying BO levels has not been defined and noticed in the literature. OBJECTIVE:The aim of this study is to build a model using the convolutional neural network (CNN) to develop an app for automatic detection and classification of nurse BO using the Maslach Burnout Inventory-Human Services Survey (MBI-HSS) to help assess nurse BO at an earlier stage. METHODS:We recruited 1002 nurses working in a medical center in Taiwan to complete the Chinese version of the 20-item MBI-HSS in August 2016. The k-mean and CNN were used as unsupervised and supervised learnings for dividing nurses into two classes (n=531 and n=471 of suspicious BO+ and BO-, respectively) and building a BO predictive model to estimate 38 parameters. Data were separated into training and testing sets in a proportion 70%:30%, and the former was used to predict the latter. We calculated the sensitivity, specificity, and receiver operating characteristic curve (area under the curve) across studies for comparison. An app predicting respondent BO was developed involving the model's 38 estimated parameters for a website assessment. RESULTS:We observed that (1) the 20-item model yields a higher accuracy rate (0.95) with an area under the curve of 0.97 (95% CI 0.94-0.95) based on the 1002 cases, (2) the scheme named matching personal response to adapt for the correct classification in model drives the prior model's predictive accuracy at 100%, (3) the 700-case training set with 0.96 accuracy predicts the 302-case testing set reaching an accuracy of 0.91, and (4) an available MBI-HSS app for nurses predicting BO was successfully developed and demonstrated in this study. CONCLUSIONS:The 20-item model with the 38 parameters estimated by using CNN for improving the accuracy of nurse BO has been particularly demonstrated in Excel (Microsoft Corp). An app developed for helping nurses to self-assess job BO at an early stage is required for application in the future.

Project description:BackgroundThe use of network meta-analysis has increased dramatically in recent years. WinBUGS, a freely available Bayesian software package, has been the most widely used software package to conduct network meta-analyses. However, the learning curve for WinBUGS can be daunting, especially for new users. Furthermore, critical appraisal of network meta-analyses conducted in WinBUGS can be challenging given its limited data manipulation capabilities and the fact that generation of graphical output from network meta-analyses often relies on different software packages than the analyses themselves.MethodsWe developed a freely available Microsoft-Excel-based tool called NetMetaXL, programmed in Visual Basic for Applications, which provides an interface for conducting a Bayesian network meta-analysis using WinBUGS from within Microsoft Excel. . This tool allows the user to easily prepare and enter data, set model assumptions, and run the network meta-analysis, with results being automatically displayed in an Excel spreadsheet. It also contains macros that use NetMetaXL's interface to generate evidence network diagrams, forest plots, league tables of pairwise comparisons, probability plots (rankograms), and inconsistency plots within Microsoft Excel. All figures generated are publication quality, thereby increasing the efficiency of knowledge transfer and manuscript preparation.ResultsWe demonstrate the application of NetMetaXL using data from a network meta-analysis published previously which compares combined resynchronization and implantable defibrillator therapy in left ventricular dysfunction. We replicate results from the previous publication while demonstrating result summaries generated by the software.ConclusionsUse of the freely available NetMetaXL successfully demonstrated its ability to make running network meta-analyses more accessible to novice WinBUGS users by allowing analyses to be conducted entirely within Microsoft Excel. NetMetaXL also allows for more efficient and transparent critical appraisal of network meta-analyses, enhanced standardization of reporting, and integration with health economic evaluations which are frequently Excel-based.

Project description:BackgroundMany quality-of-life studies have been conducted in healthcare settings, but few have used Microsoft Excel to incorporate Cronbach's α with dimension coefficient (DC) for describing a scale's characteristics. To present a computer module that can report a scale's validity, we manipulated datasets to verify a DC that can be used as a factor retention criterion for demonstrating its usefulness in a patient safety culture survey (PSC).MethodsMicrosoft Excel Visual Basic for Applications was used to design a computer module for simulating 2000 datasets fitting the Rasch rating scale model. The datasets consisted of (i) five dual correlation coefficients (correl. = 0.3, 0.5, 0.7, 0.9, and 1.0) on two latent traits (i.e., true scores) following a normal distribution and responses to their respective 1/3 and 2/3 items in length; (ii) 20 scenarios of item lengths from 5 to 100; and (iii) 20 sample sizes from 50 to 1000. Each item containing 5-point polytomous responses was uniformly distributed in difficulty across a ± 2 logit range. Three methods (i.e., dimension interrelation ≥0.7, Horn's parallel analysis (PA) 95% confidence interval, and individual random eigenvalues) were used for determining one factor to retain. DC refers to the binary classification (1 as one factor and 0 as many factors) used for examining accuracy with the indicators sensitivity, specificity, and area under receiver operating characteristic curve (AUC). The scale's reliability and DC were simultaneously calculated for each simulative dataset. PSC real data were demonstrated with DC to interpret reports of the unit-based construct validity using the author-made MS Excel module.ResultsThe DC method presented accurate sensitivity (=0.96), specificity (=0.92) with a DC criterion (≥0.70), and AUC (=0.98) that were higher than those of the two PA methods. PA combined with DC yielded good sensitivity (=0.96), specificity (=1.0) with a DC criterion (≥0.70), and AUC (=0.99).ConclusionsAdvances in computer technology may enable healthcare users familiar with MS Excel to apply DC as a factor retention criterion for determining a scale's unidimensionality and evaluating a scale's quality.

Dataset Information

Analytical Solution of the Time-Dependent Microfluidic Poiseuille Flow in Rectangular Channel Cross-Sections and its Numerical Implementation in Microsoft Excel.

Publications

Analytical Solution of the Time-Dependent Microfluidic Poiseuille Flow in Rectangular Channel Cross-Sections and its Numerical Implementation in Microsoft Excel.

Similar Datasets

OmicsDI is part of the ELIXIR infrastructure

Tweets