You can also use the checkbox in the main Solver window to make sure that all of the values that you didn't specify constraints for are non-negative. You don't have to add a constraint for each cell. Klicken Sie auf Add-Ins, und wählen Sie dann im Feld Verwalten die Option Excel-Add-Ins aus. Hinweis: Klicken Excel 2007 auf Microsoft Office Schaltfläche, und klicken Sie dann Excel Optionen.
In Excel 2010 und höher wechseln Sie zu Datei > Optionen. If you want six variables to have values over 10, for example, you can select them all and tell Solver that they must be greater than or equal to 11. Wenn Sie das Solver-Add-In verwenden möchten, müssen Sie es jedoch zuerst in Excel laden. It's important to remember that you can select multiple cells for Cell Reference.
#EXCEL ADD INS SOLVER INSTALL#
So if you have three cells, you'll end up with the numbers 1, 2, and 3 (but not necessarily in that order)įinally, add the value for the constraint. To install Solver in Excel:Windows: File, Options, Addins and select Solver Add-insOn a Mac (0:35) Tools, Add-ins, and check the Solver Add-inSup. But it also specifies that they must be between 1 and the number of cells. It specifies that every cell in the range that you select for Cell Reference must be a different number. Last edited by ZhangYong 04-16-2010 at 10:57 AM.AllDifferent is a little confusing. To locate this article, you can google it by using "DDSolver" as a keyword. (2) Key Laboratory of Drug Quality Control and Pharmacovigilance, Ministry of Education, Center for Instrumental Analysis, China Pharmaceutical University, No.24, Tongjiaxiang, 210009 Nanjing, China (1) Department of Pharmaceutics, China Pharmaceutical University, No. Yong Zhang, Meirong Huo, Jianping Zhou, Aifeng Zou, Weize Li, Chengli Yao and Shaofei Xie Our published article introducing the DDSolver is:ĭDSolver: An Add-In Program for Modeling and Comparison of Drug Dissolution Profiles It is a little bug of Springer's website, we are contacting Springer for fixing this bug. xla, then everything will go smoothly as directed in Installation Structions Document. xls downloaded from the Springer's website into 12248_2010_9185_MOESM2_ESM.
To install DDSolver on your computer, you should first change the 12248_2010_9185_MOESM2_ESM. In addition, a detailed disscusion of the approaches for estimating similarity between dissolution profiles was supplied as Supplementary File.
#EXCEL ADD INS SOLVER SOFTWARE#
The DDSolver software is available at the Electronic Supplementary Materials page of the paper's website. When the dialogue box appears, make sure the box is ticked, as shown below. If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in. In the Add-Ins available box, select the Solver Add-in check box, and then click OK. Click Add-Ins, and then in the Manage box, select Excel Add-ins and click Go. To do this, go to File -> Options -> Add-Ins -> Manage Excel Add-Ins. Click the Microsoft Office Button, and then click Excel Options. The first step is to make sure you have Solver installed in your Excel file.
#EXCEL ADD INS SOLVER SERIES#
You can download it from the Spriger's website providing you have the right to access the fulltext of the Springer Database.ĭDSolver is a freely available program which is capable of performing most existing techniques for comparing drug release data, including exploratory data analysis, univariate ANOVA, ratio test procedures, the difference factor f 1, the similarity factor f 2, the Rescigno indices, the 90% confidence interval (CI) of difference method, the multivariate statistical distance method, the model-dependent method, the bootstrap f 2 method, and Chow and Ki’s time series method. Step 1: Ensure the Solver Add-In is Installed. Most recently, we have developed a powerful software, named DDSolver, for estimating drug dissolution/release similarity.