Using the create Excel tool

* The contents described here is Ver 1.00 point.

How to create Excel tool in Board explained.

Get the Board create Excel Tools

And download the file from the following link, please out a file from a ZIP file.

Creating a board layout parameters

To define a parameter or board layout need to save in the.xlsx file and edit in Excel. You can also edit the file in the sample distribution, and can be created from scratch based on.

Even Board container definition file name output file name can be anything, but eventually.

Board container parameter

Create a 'Container' sheet to create a Board container parameter. You must create this sheet.

Create a second column 1 'Key' column Value' header in the first line.

Enter the distinguished name that identifies the values in the key column, it fit each value in the Value column enter will continue. In one of the following parameter can be specified.

  • IdentityName
  • Author
  • Version
  • IsExcludeNextBoard
  • Order
  • KeyReleaseTimingWhenActiveWindowChange

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
IdentityName This parameter is required.
GeneratorIdentityName Automatically set.
GeneratorVersion Automatically set.

Board para meter

Create a 'Boards' seats to create a parameter of the Board. You must create this sheet.

Type the distinguished name of the parameters of the Board in the first line.

Minutes of Board the second and subsequent lines displayed per row, type the header parameter to match.

Parameters can be specified in the column will be less.

  • IdentityName
  • Position
  • StartPositionType
  • PositionOffset
  • NextBoardPositionType
  • CenterPosition
  • FontSizeScale
  • BoardScale
  • ImageName
  • ImageStretchMode

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
Position

Usually enter the here the size of the Board is automatically determined according to Keeley out if left blank. However, position is (0, 0) to become for the position must see PositionOffset' parameter 'StartPositionType' and you must.

Each parameter is X, Y, Width, Height entered separated by commas.

PositionOffset Each parameter is X, Y type separated by commas.
CenterPosition Each parameter is X, Y type separated by commas.

Key layout

Create {_Layout sheet to create the key layout. Specify the index of the Board starting with 1 "{x}" part. If you need to view multiple boards this sheet is required to only the number of the Board.

This sheet into shape, we will create a layout of keys. It is recommended that so may place any shape, but at the moment only rectangular keys can be created using rectangular shape.

Enter the distinguished name of the key in the shape once you place the shape. This distinguished name works in conjunction with keepelameta. Please note that is not the text that appears in the key.

Text that you type when you enter a distinguished name if no keepelameta is set to keepelameta "KeyType" and "DisplayText". Please note that the specified does not exist "KeyType" fail to load in the application.

The size of the cells when you position shapes on the back is output effect.

Key parameters

Create {_KeyDefine sheet to create a keepelameta. Specify the index of the Board starting with 1 "{x}" part. If you need to view multiple boards this sheet is required to only the number of the Board.

Type the distinguished name of the key parameter in the first line.

Only number keys to target board the second and subsequent lines of each row type according to the parameters of the header.

Parameters can be specified in the column will be less.

  • Name
  • KeyType
  • Position
  • DisplayText
  • FontSize
  • ImageName
  • ImageStretchMode
  • IsToggle
  • IsOneClickToggleRelease
  • Options
  • Processes

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
Name Keepelameta entered the name you enter here and name shapes in the layout sheet work together applies to key for the target position. Layout sheet even Board container definition file output is based on layout sheets, because the name here is no problem.
KeyType If left blank the value in the Name column is used.
Position So I will use will be preferentially used if you enter here the position and size, typically keylayout sheet set in position and size is basically missing, may be. If you enter 'X, Y, Width, Height"type separated by commas. The unit is a logical pixel.
DisplayText If left blank the value in the Name column is used. To wrap text in a cell that breaks the actual display text.
Options If you want to use according to enter.
Processes If you want to use according to enter.

Board decor

You can to set detailed decoration on the appearance of the Board.

Enter the parameter Board decorations the distinguished name in the first line. We will set the decoration of attempting to target the second and subsequent lines, each condition in the Board.

You can specify by typing "TargetBoardName" specified in the "Boards" sheet "IdentityName" apply to any Board.

Also you can specify conditions of IME is to apply to all States of "ImeStatuses" or "PressKeys" to apply key is still down.

Parameters can be specified in the column will be less.

  • IdentityName
  • TargetBoardName
  • ImeStatuses
  • PressKeys
  • BackgroundColor
  • ImageName
  • ImageStretchMode
  • BorderColor
  • BorderThickness

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
TargetBoardName Decide to apply to any Board. The name specified in the "Boards" sheet "IdentityName".
ImeStatuses Indicates the IME is currently applied decoration on any State. You can specify any value see definitions in BoardDecorateInfo. If you type in more than one type in a comma-separated values. (Example:KanaInputAlphaHalf, KanaInputKatakanaHalf)
PressKeys Specifies which keys are to apply the decoration is still down. For example to specify the [LeftShift] and when you press any applies the shift décor. If you want to be applied in more than one key at the same time push specify multiple comma-separated.
BackgroundColor Color is 0 to 255 separated. Enter values in the comma-separated values in "A, R, G, B".
BorderColor Color is 0 to 255 separated. Enter values in the comma-separated values in "A, R, G, B".

Key decoration

You can to set detailed decoration on the appearance of the key.

Enter the distinguished name of the parameter key decoration on the first line. We will set the key to target the second and subsequent lines, each condition in the decoration.

You can decide to apply to any key by entering the Name you specified in "{_KeyDefine" sheet "TargetBoardName".

Also IME is to apply to all States of "ImeStatuses" or "PressKeys" to apply key is still down, "IsPressed" own key is still down or the criterion may be specified.

Parameters can be specified in the column will be less.

  • IdentityName
  • TargetKeyName
  • ImeStatuses
  • PressKeys
  • IsPressed
  • DisplayText
  • FontName
  • FontSize
  • TextBold
  • TextColor
  • BackgroundColor
  • ImageName
  • ImageStretchMode
  • BorderColor
  • BorderThickness

See definition on the following link to each parameter for more information.

See the following setting Board created Excel Tools of their own and complementary.

Key Remarks
TargetKeyName Specify which keys to adapt. The name 'Name' specified with "{_KeyDefine" sheets.
ImeStatuses Indicates the IME is currently applied decoration on any State. You can specify any value see definitions in KeyDecorateInfo. If you type in more than one type in a comma-separated values. (Example:KanaInputAlphaHalf, KanaInputKatakanaHalf)
PressKeys Determine out of other key which key was to apply the decoration is still down. For example to specify the [LeftShift] and when you press any applies the shift décor. If you want to be applied in more than one key at the same time push specify multiple comma-separated. Possible criteria to include its own key.
IsPressed If TRUE. Key itself is still down when the apply to decoration. FALSE or if unspecified is normally when key decoration.
TextColor Color is 0 to 255 separated. Enter values in the comma-separated values in "A, R, G, B".
BackgroundColor Color is 0 to 255 separated. Enter values in the comma-separated values in "A, R, G, B".
BorderColor Color is 0 to 255 separated. Enter values in the comma-separated values in "A, R, G, B".

Create a Board container definition file

Create

Move the boards definition files (.xlsx) created the "Boadceato_x_xx.xlsm" file. (where x_xx is the version)

Once you have moved the file open the 'BoardCreator.xlsm'. .Xlsx files in the folder by clicking the Board container definition file generation button in the sheet Board container definition files are generated based on.

Board container definition file successfully processing the same folder with the ".setting' extension is created.

About security

If you opened an Excel file that contains the macro is 'BoardCreator.xlsm' and warning is displayed as shown in figure. (In some cases message differs from the figure)

Allow the macro can run if you receive alerts. You can't create a Board container definition file and does not allow.

Board container definition file deployment

Place the Boards \Default\ folder of the Board container definition file (.setting) created a "TiitanTouchBoard.exe" folder in the. After deployment, one Genta's are loaded when you start the senor.

If incorrect parameter specified when running, so review the setting of the Board when the rebuild.

About the included sample Board

Provided the Board summarizes the small board package boards Excel Tools, easy-to-create boards for the first time as source data and functionality for each sample. In the following samples are included.

File name Summary Image
010_Normal_1_00_Ja Included in the initial state is usually a keyboard layout.
020_Thumb_1_00_Ja It is included by default thumb keyboard for the lay out.
030_MousePad_1_00_Ja It is a mouse pad is included by default.
031_MousePadOneHandLeft_1_00_Ja It is a left-pad in the Board package.
032_MousePadOneHandRight_1_00_Ja It is a right-handed mouse pad in the Board package.
033_MousePadExtensionKey_1_00_Ja It is a mouse pad extensions included in board package.
040_TenKeyLeft_1_00_Ja It is a numeric keypad for left hand contained in board package.
041_TenKeyRight_1_00_Ja It is for the right hand numeric keypad contained in board package.
042_TenKeyLeftNumLock_1_00_Ja It is left for the NumLock keypad in the Board package.
043_TenKeyRightNumLock_1_00_Ja It is right for the NumLock keypad included in board package.
050_GameController_1_00_Ja This is the game controllers in the Board package.
060_IllustCspLeft_1_00_Ja Clip Studio Paint for the left hand short Board in the Board package is.
061_IllustCspRight_1_00_Ja Clip Studio Paint for the right hand short Board in the Board package is.
062_IllustPsLeft_1_00_Ja Is a Photshop for left hand short Board in the Board package.
063_IllustPsRight_1_00_Ja Is a Photshop right-handed short Board in the Board package.
501_MinimumBoardSample_1_00_Ja Is a sample Board consists of the minimum as far as possible.
502_FourBoardsSample_1_00_Ja Is the Board sample boards on four corners.
503_BoardPositionSample_1_00_Ja Is specified by the location and size of any Board Board sample.
504_BoardPositionOffsetSample_1_00_Ja Board sample Board to shift from the initial position, the place is.
505_BoardScaleSample_1_00_Ja Across the Board, and expanded the KeyText Board sample.
506_BoardImageSample_1_00_Ja It is using the image in the background of the Board the Board sample.
511_ImeOnOffDecorateSample_1_00_Ja This is a sample depending on the IME ON, OFF switch Board decoration.
512_ImeDetailDecorateSample_1_00_Ja IME Kana is a sample switch Board decorated by details such as typing or romaji input. By switching the colors to the IME for each current IME status easier to understand.
513_PressKeyBoardDecorateSample_1_00_Ja This is a sample switch Board decorated by the State of the key you press. Pressing the SHIFT key or Ctrl key turns the Board background.
514_TransparentColorBoardSample_1_00_Ja This is a sample make transparent the background of the Board. You can create this floating down the key board.
515_TransparentImageBoardSample_1_00_Ja It is a sample of the Board by using a transparent image in the background of the Board, in any form. You can create a free-form Board according to this key background to crop images by.
521_KeySimpleDecorateSample_1_00_Ja This is a sample applied decorations of standard keys. You can specify "KeyText", font size, background color, etc.
522_KeyToggleSample_1_00_Ja It is an example of various key toggle behavior.
523_CustomProcessKeySample_1_00_Ja This is a sample process press down key to customize the various keystrokes. Redo [undo] "select all", such as "open Windows Explorer" in bulk can enter multiple characters, such as emoticons, escaping a potential shortcut.
524_SpecialKeySample_1_00_Ja This is a sample placed a minor key is defined as a key, but rarely used. Simply because what is defined only a collection of keys to press nothing happens when I click may have been. Also different behavior depending on the OS and environment settings.
531_KeyExtendDecorateSample_1_00_Ja This is a sample applied decorative detail are key. It is possible to specify many different display text, font text color "background color" background image "border".
532_KeyImeDecorateSample_1_00_Ja This is a sample key decoration changes depending on the State of the IME. The characters that are typed by pressing the key depending on the State of the IME key characters to show is.
533_KeyPressDecorateSample_1_00_Ja This is a sample key decoration depends on the pressed state of a specified key. Pressing the SHIFT key or Ctrl key changes such as text on the.

For past versions