Data Input

• Introduction
• Features
• How to ...

• ---

• Button reference list
• Customize and options
• FAQs
• Known issues

• ---

• Input Data
  • Select data at startup
  • Copy from a cell
  • Resample cells
  • Get sum of cells
  • Keypad or direct entry
  • Transfers
  • Input from Special Functions

• ---

• Standard Functions
  • Main Operators
  • Standard Inputs and Memory
  • Result, Move result & Paste
  • Minor operators and Miscellaneous

• ---

• Special extract functions
  • Text to numbers
  • Extract multiple numbers
  • Date functions
    • Date information
    • Date Links

• ---

• Download and Install
  • Uninstall
• Run In–Cell

• ---

• Privacy
• About Humar
  • Contact
  • Disclaimer
  • Licensing & Acceptable Use
• Acknowledgements

• ---

• Free Excel Functions

Data Input Summary

There are several ways to get data into the two Input boxes

• Select a cell or cells with numeric data, before opening In-cell, (i.e., pre-selecting).
  Select one cell, two adjacent cells, or a range with a number in the first and last cells, or a range with a number in the first cell, an empty last cell and a number in either the cell to the left of the empty cell or the cell above the empty cell. When the last cell in the range is empty, this will be selected as the active cell, ready for a result to be pasted from the calculator, but Input 2 will contain the value of the cell to the left or the cell above this empty cell.
  Click here for an example.
  
  
• Re-sample - highlight one or more cells and click the ReSample button. The resample function operates the same as the above pre-select function.
  Both pre-select and ReSample accept numbers written as text in the selected cells and if one of the cells selected contains numbers and text, e.g., 2 @ $18.99 then the first number will be placed in the relevant input.
  If only one cell is selected this is a special case, and if the cell contains two numbers for example 18 @ $19.95, the first number is placed in input 1 and the second number is placed in input 2. (If more than two numbers in a cell, use the special function keys to extract the numbers).
  Click here for an example.
  
  
• Use the Copy button to get the value of the active cell.
  A numeric value or a number written as text will be recognized and copied to Input 1 or Input 2 as appropriate.
  Click here for an example.
  
  
• Exchange the values in the two input boxes.
  Click here for an example.
  
  
• Get number from memory, using the M1Re or M2Re buttons

  Each input has its own memory - Memory 1 for Input 1, Memory 2 for Input 2
  M1Re and M2Re recall the memory values and place them in inputs 1 and 2 respectively

  
  
• Enter data directly into the input boxes using the keypads or your keyboard
  Click here for an example.
  
  
• The value in the Result box can be moved to Input 1 or Input 2 using buttons in the ‘From Result box to:’ group
  Click here for an example.
  
  
• A value on the clipboard can be transferred to the Result box, and can then be transferred to Input 1 or Input 2.
  Click here for an example.
  
  
• Get the Sum of numbers in a range of cells using the Sum button
  Click here for an example.
  
  
• Transfer data from one of the three special conversion functions –
  Text to Number, Multiple numbers in one cell and Date/Time values
  Click here for an example.

Select Data at Startup (Pre–select)

• The first button shows the data preselected and the right mouse–button menu, ready to launch In–Cell,
  
• The second button shows the first and last numbers in the selection entered into inputs #1 and #2 as soon as In–Cell has been launched,
  Note that as the initial selection included one empty cell after the last number, this cell has been selected, ready for a result to be pasted into it.
  
• The third button shows the situation after clicking 'Paste'. The result value is now in the previously selected cell and the Active Cell has moved one cell in the default direction. (Default direction is selectable through 'Options' – right, down or 'no move').

Hover mouse over the buttons across the top of the spreadsheet to see the sequence

Section displayed:

Back to Top of Page

Copy single Cell Data to Input

Resample Spreadsheet Cells

• The first button shows the result of using the copy button for input #2. The Active Cell was highlighted and is used as the source of the Copy function.
  Note that the Active Cell is highlighted by a double red outline. The Active Cell outline is user selectable – see options.
• The second button shows the Resample function. In this case two numbers have been selected and with no blank cell after the second number
  
• The third button shows that after clicking Resample, inputs #1 and #2 contain the two selected numbers. The Active Cell has moved. If an empty cell had been selected at the end of the range, this would have been selected as the Active Cell.
  Note that the input values can be swapped with the Input 1 <> Input 2 button in the exchange group.
  The Exchange group is hidden in this example – click on the horizontal bar (highlighted in green) to display the buttons in the exchange group.

Hover mouse over the buttons across the top of the spreadsheet to see the functions

Section displayed:

Back to Top of Page

Get Sum of a Range of Cells

• The first button shows a range of cells highlighted. All numeric values in the range will be summed.
  Note that the sum function does not use the Active Cell. (The Active Cell outline is user selectable – see options).
• The second button shows the result of the sum function with the total in input # 1.

Hover mouse over the buttons across the top of the spreadsheet to see the functions

Section displayed:

Back to Top of Page

Keypad or Direct Entry from Keyboard

Backspace Button

• The first button shows that a keypad click adds a digit to the end of the existing number (in this case in input #2).
• The second button shows the result of using the Backspace button.
• The third button shows the effect of the CL keypad button. The cursor is placed in the input box (Input # 2 in this case).

Hover mouse over the buttons across the top of the spreadsheet to see the functions

Section displayed:

Back to Top of Page

Transfer Data from Clipboard

• The first button shows the clipboard data copied to the Result box, using the CB button (shown highlighted by red outline).
  The data came from a copy function – the insert shows data being copied from a Word document. Only data that the Windows clipboard function can convert to numeric format will be pasted.
• The second button shows the data transferred to Input #2 using the Inp2 button, (shown highlighted by red outline).

Hover mouse over the buttons across the top of the spreadsheet to see the functions

Section displayed:

Back to Top of Page

Transfers and Exchanges

• The first button shows data in the calculator prior to an exchange.
  The data came from cells C15 and D15 using the Resample button. The value excluding tax has been calculated and the value is in the Result box.
• The second button shows the effect of exchanging input #1 and input #2.
  This exchange allows the percentage calculation to be used as shown in by the third button.
• The third button shows a transfer from the Result box to input #2.
  The result of the last calculation (amount excuding tax) is now in input #2, and a percentage calculation has been performed using the As% button, (the tax rate is 14% !). The calculation type shows as A%, i.e., input #1 as as percentage of input #2.

Hover mouse over the buttons across the top of the spreadsheet to see the functions

Section displayed:

Back to Top of Page

Input from Special Functions

• The first button shows a number written as text, prior to conversion.
  Note that the conversion boxes at the bottom of the calculator can be hidden or displayed by clicking on the horizontal bar above the section.
  The colour of the input boxes, and the associated text is user configurable – you don't have to accept this colour !!!.
• The second button shows the number in the 'Text as #' Display box.
  If there are multiple numbers, as in Cell B15, the display button cycles through all the values found. Whichever value is in the display box can be pasted or transferred using one of the three buttons to the right, (Inp 1, Inp 2, or Paste).
• The third button shows the result after clicking both the Inp 1 button and the Paste button.
  The value (316000) is now in both cell C14 and Input #1.
  If multiple numbers are extracted, double clicking the Paste button will transfer the values sequentially to cells either to the right, or down, depending on the option selected by the user.
  The date option display rotates through the date elements, (year, month, day), the time, a text string for the whole date, and a number representing the date.
  If there are several dates in the text, all the elements of each date are displayed in turn. (The date extract does not currently support a double click to transfer all these elements – the required elements are selected using the display button, and then paste or transfer as required.

Hover mouse over the buttons across the top of the spreadsheet to see the functions

Section displayed:

Back to Top of Page

Copyright © 2007 Humar Consulting Inc.