When you select Instructions, the BMC Software Spreadsheet Converter instruction screen is displayed.

After the Spreadsheet Converter is loaded, begin execution by selecting the BMC Software toolbar from the View menu item (Excel 2003 and earlier) or the Add-ins menu (Excel 2007 and later).

Next, continue with the following procedures. To start the Spreadsheet Converter on Excel 2007 and laterĬlick the Office button in the top left corner of the Excel window, select Open, and locate the Spreadsheet Converter. Use Tools > Add-ins to add the Spreadsheet Converter.ĭouble-click the CX98SSCX.XLA file in Explorer or File Manager. Use File > Open to load the Spreadsheet Converter. To start the Spreadsheet Converter on Excel 2003 and earlier Since the report and spreadsheet files reside on your PC it should be possible to send them in either by e-mail, or by putting them on a diskette and mailing it in.The Spreadsheet Converter (file CX98SSCX.XLA) runs as an Excel Add-in. It will also help if you send a copy of the resulting spreadsheet. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, Fahrenheit to Celsius, gallons into liters, and for many other unit conversions. In order to work on an incident for the Spreadsheet Converter, BMC Software Customer Support personnel need a copy of the reports that were being converted. The Excel CONVERT function converts a number in one measurement system to another. Use the same procedures for downloading as described in Installing the Spreadsheet Converter on your PC.

Whenever a Spreadsheet Converter PTF is sent, the HOLDDATA file will alert you to the availability of an updated version that needs to be downloaded again.

Updates to the Spreadsheet Converter will be distributed by way of the usual BMC Software Candidate and PUT mechanisms.Įmergency fixes can be sent by standard BMC Software maintenance procedures. You can use a formula, which usually begins with an equal mark (), to perform some simple calculations such as addition, subtraction, multiplication and division. Formulas are equations that are used to analyze and calculate the numeric values. The Workbook is the Excel lingo for ‘spreadsheet’. How to Use Formulas in Spreadsheets 2016. It is available in MS office as well as Office 365, from where a user can create a spreadsheet. Since the Spreadsheet Converter is distributed as a mainframe file, it is maintained using standard SMP tools. A spreadsheet is a grid-based files designed to manage or perform any type of calculation on personal or business data. Any questions about using Excel should be directed to Microsoft Corporation. BMC Software does not sell or support Microsoft Excel. The Spreadsheet Converter is a conversion tool only, designed to make viewing or manipulating the data in the CMF Analyzer or CMFMON reports easier. The Spreadsheet Converter is compatible only with Microsoft Excel 2000 and later, and does not need any additional hardware that is not part of the minimum requirements for running Excel.

Spreadsheet converter 6