834 Analyzer

Version 1.0 (ACS Version) and Version 2.0 (EDS Version)

The 834 Analyzer is a program that allows the display of parsed 834 data in a printable spreadsheet format. The 834 Analyzer program is not intended for use in a production environment, but rather to aid managed care plans to view their trading partner's outbound transactions. The 834 Analyzer is designed to display 834 transactions downloaded from Florida Medicaid's fiscal agent (ACS prior to 7/1/2008, EDS after 7/1/2008). The analyzer may not function properly with files produced by other entities, however, the macros are not protected and may be altered by the end user.

Excel must be set to accept macros in order for the 834 Analyzer to function. After opening Excel, click "Tools", "Macro", and then "Security." Click the radio button for "Medium" and close Excel. When reopening Excel and enabling macros, "Analyze X12" will appear on the menu bar. "Click "Analyze X12" to run the program. Clicking "Save Workbook" will save the analyzed file for future analysis. "Reset workbook" will remove the analysis worksheets. The download file includes the 834 analyzer program, user documentation, and a sample 834 file. THE STATE OF FLORIDA WILL NOT PROVIDE SUPPORT FOR THIS TOOL!

Download Intructions: Click the "Version 1.0 Download" link below. Click the "Open" button. Click the "Unzip" button. Click "OK" when the "WinZip Self-Extractor" window appears.

834 Analyzer v1.0 Download

Download Intructions: Click the "Version 2.0 Download" link below. Click the "Open" button. Click the "Unzip" button. Click "OK" when the "WinZip Self-Extractor" window appears.

834 Analyzer v2.0 Download

PLEASE READ THE FOLLOWING DISCLAIMER.

NOTE: The analyzer program requires Excel 2000 or Excel 2003 to operate.

DISCLAIMER: The State of Florida (including its employees and agents) assumes no responsibility for consequences resulting from the use of the information herein, or in any respect for the content of such information including (but not limited to) error or omissions or the accuracy or reasonableness of assumptions made in the design of the 834 Analyzer. The State of Florida is not responsible for, and expressly disclaims all liability for, damages of any kind arising out of use, reference to, or reliance on such information obtained from the 834 Analyzer and makes no guarantees or warranties, including (but not limited to) any expressed or implied warranties of fitness for a particular use or purpose with respect to the use of the tool.