214
File Memory Section 5-1
• Input 4 characters in each cell if single-word fields are being used or 8
characters if double-word fields are being used. For example, if single-
word fields are being used input 000A, not just A.
• Be sure to input only hexadecimal characters (0 to 9, A to F, or a to f) in
the cells. Other characters and codes cannot be used.
When you want to store hexadecimal digits in I/O memory, it is helpful to con-
vert the spreadsheet’s decimal inputs to hexadecimal. Use the following pro-
cedure to convert to hexadecimal.
1,2,3... 1. Select Add-Ins... from the Tools Menu.
2. Select Analysis ToolPak in the Add-Ins Menu.
3. Select Function from the Insert Menu at the cell where the function will be
used.
4. Select DEC2HEX (number, digits) from Engineering in the Category
Field.
5. When converting to 4-digit hexadecimal, input the following at the number
variable: IF(0<=cell location,cell location,65535+cell location)
When converting to 8-digit hexadecimal, input the following at the number
variable: IF(0<=cell location,cell location,4294967296+cell location)
• Example 1: Inputting non-negative decimal values.
• Example 2: Inputting signed decimal values.
Data Files Transferred
Automatically at Startup
There are 6 kinds of files that are transferred automatically at startup when
the automatic transfer at startup function is being used.
Item Converting unsigned decimal to 4-digit
hexadecimal
Converting unsigned decimal to 8-digit
hexadecimal
Function
used
DEC2HEX(cell_location,4) DEC2HEX(cell_location,8)
Example
Input 10 in decimal and convert to 000A in 4-digit
hexadecimal.
Input 10 in decimal and convert to 0000000A in
8-digit hexadecimal.
Item Converting signed decimal to 4-digit hexadecimal Converting signed decimal to 8-digit hexadecimal
Function
used
DEC2HEX(IF(0<=cell_location,cell_location,65536+
cell_location),4)
DEC2HEX(IF(0<=cell_location,cell_location,
4294967296+cell_location),8)
Example
<
Input -10 in decimal and convert to FFF6 in 4-digit
hexadecimal.
<
Input -10 in decimal and convert to FFFFFFF6 in 8-
digit hexadecimal.
Data file Transferring with the
parameter file
Transferring without the
parameter file
Data file starting at
D20000 (See note.)
AUTOEXEC.IOM REPLACE.IOM
Data file starting at
D00000
ATEXECDM.IOM REPLCDM.IOM
Data file starting at
E@_20000
ATEXECDM.IOM REPLCDM.IOM
To Next Page
Loading...
