PhStat Directions

Introduction

Version 4 is compatible with Microsoft Windows Excel 2007, Excel 2010, and Excel 2013, (Mac) OS X Excel 2011, and Office 365 Excel. with the latest Microsoft-supplied patches and service packs applied.  Complete configuration and download instructions are contained in the Readme files below while the PhStat Software files contain the program source code.

Version 4

Readme.v4

PhStat.v4 Software can be found in your Blackboard course

Quick Instruction for Installing PHSTAT V4 from the Web

For complete instructions on how to download, install and troubleshoot the PHSTAT program, click on the Readme link.

Step 1:  Check to see whether you have the latest Microsoft-supplied patches and service packs for Excel applied (visit http://office.microsoft.com/en-us/downloads/redir/XT101808448.aspx  and click on Custom for the latest Excel updates).  PHStat will not work properly with unpatched versions of Excel.  You can only update Excel and install PHStat if you log on to Windows using a user account that includes administrator privileges.

Step 2:  Configure Excel to accept the add-in by changing the Trust Center security settings (see Readme link for specific steps for Excel 2007, Excel 2010 or Apple Excel 2011).

Step 3:  Download the PhStat.v4 Software files which are packaged as a zip archive and save it to a folder. Double-click the zip archive and extract the files.  Then click on the icon in the folder for the file named PHStat.xlam.  As PHStat begins to load, you will see a security warning message that discusses macros. Should this dialog box appear, click Enable Macros to allow PHStat to be opened. (If you are using Microsoft Windows and “nothing” happens, review Section 2 to make sure your system contains the correct security settings.).  If PHStat loads properly, a PHStat menu will appear in the Add-Ins tab (Excel 2007, Excel 2010, or Excel 2013)  or in the Apple menu (Excel 2011).

Using PHSTAT

You use PHStat by double-clicking the icon or folder listing (or shortcut) for PHStat.xlam. If you prefer, you can use the Excel (File) Open dialog box to open the PHStat.xlam file directly. As PHStat begins to load, you will see a security warning message that discusses macros. Should this dialog box appear, click Enable Macros to allow PHStat to be opened. (If you are using Microsoft Windows and “nothing” happens, review Section 2 to make sure your system contains the correct security settings.

Issues Using PHSTAT

Excel 2010, Excel 2013, and Excel 2016 Security Settings In these Excel versions, select File è Options and in the Excel Options dialog box: 1. Click Trust Center in the left pane and then click Trust Center Settings in the right pane. In the Trust Center dialog box: 2. Click Add-ins in the next left pane, and in the Add-ins right pane clear all of the check boxes. 3. Click Macro Settings in the left pane and in the Macro Settings right pane click Disable all macros with notification. 4. Click OK to close the Trust Center dialog box. Back in the Excel Options dialog box: 5. Click OK to finish. For systems with very stringent security settings, you may need to modify step 5. For such systems, in step 5, click Trusted Locations in the left pane and then, in the Trusted Locations right pane, click Add new location, click Browse and navigate to the folder into which you place the PHStat files. Then click OK in the open dialog boxes until all are closed. 2b Excel 2007 Security Settings In this version, click the Office Button and then click Excel Options, located at bottom of the Office Button menu window. Then continue with the five steps of the Excel 2010, Excel 2013, and Excel 2016 instructions.