The AND Function - Make judgments based on multiple conditions (Used with the IF function)

• The AND formula displays "true" =TRUE when a number of logical formulas are all true.

  E.g. =IF( =AND([LIST1] >= 80, [LIST2] >= 80), Pass , Fail )

  In the above example, when both [LIST1] and [LIST2] are 80 or greater, the formula is true and a passing result displayed, and in all other cases, a failing result is displayed.
• The AND function and the OR function may be used as part of the logical formula for the IF function.
• It is possible to use the AND function and the OR function together to set as many conditions as you like for a formula.

AVERAGELIST Function - Display the average of the numbers displayed using a list

• This function displays the average value of the values used in LIST1, including branch numbers and LIST1[LIST1_1]… .

• E.g. =AVERAGELIST( 1 )

  If you put 1 in parentheses, it will display the average of all values (including branch numbers) displayed as LIST1.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

• E.g. = AVERAGELIST( 1-2 )

  If the values in the list are separated by commas and displayed separately, you can add hyphen + numeric value to the list number like this to specify a value at the specified position from within the comma-separated values. In this example, 1-2 will display the average of the values from the second comma-separated number in the list 1 values displayed in the diagnosis results.

Rounding to the nearest whole number or decimal point

• If you enter " , number of digits ", you can set the number of digits when rounding to decimal places or to the nearest whole number.
• If you do not set the number of digits
  , the default value will be 0, and the decimal point will be rounded off and displayed as a whole number.

CALC Function - Performing Mathematical Calculations

• When the character string "=CALC()" is inserted in brackets, a mathematical calculation is performed, and the displayed diagnosis results are based on this calculation.
• For example, say you enter =CALC( [LIST1] + [LIST2] ) into the diagnosic results basic text section, and include the numbers 1-10 in List 1 and List 2.
• When a diagnosis is generated, first, the variable [LIST] will be converted.
  For example, when [LIST1]→1, [LIST2]→2, the result will be
  =CALC(1 + 2).
  Next, the caculation is performed, and the end result, in this case 3, is displayed.
• Calculation is limited to the four basic arithmetic operations: addition, subtraction, multiplication, and division.
• The characters that may be used in =CALC() formulas are limited to numerals, the decimal point, and the following characters: + - * / ( ) , . 0-9 ,.

Rounding to Decimal Places or Integers

• By entering " , Number of Digits" after an equation, you may set the number of digits for values to be rounded to. Values may be rounded to a given number of decimal places, or to the nearest integer.
• When the number of digits is not set
  When the number of digits for rounding is not set, the default number 0 will be used, and values rounded to the nearest integer.

  E.g. =CALC( 1 / 3 )

  → Here, the calculation result "0.3333..." becomes 0.
• When the number of digits is set to a positive value

  E.g. =CALC( 1 / 3 , 2 )

  →Here, "0.3333..." becomes0.33.
  *The largest value that may be set here is 14. If a value larger than 14 is entered, it will be read as 14.
• When the number of digits is set to a negative value

  E.g. =CALC( 555 * 555 , -3 )

  → Here, the calculation result "308025" is displayed as 308000.

The Chart Function - Displays a chart (graph)

• This function may be used to display a chart (graph) as an image.When this function is used, the function is converted into a chart image within the diagnosis results.
• Parameters
  • TYPE(Required Field) - Choose a chart type. Currently, 6 different types are available.
    • RADAR - Radar Chart
    • LINE - Line Chart
    • BAR - Bar Chart
    • PIE - Pie Chart
    • SCATTER - Scatter Chart
    • TABLE - Table
  • DATA(Required Field) - Adds chart labels and values.
    • Labels: If too many values are entered, an error will occur and the chart will not be displayed correctly.
    • Please specify different content for each label. When there is more than one of a given label, the chart may not work properly.
    • Scatter charts explained
    • Labels and values are rendered as follows. Make sure that the left, right, top, and bottom labels are separated with hyphens.

      (E.g.)
      DATA : [
      (X axis) left label - (X axis) right label : X axis value ,
      (Y axis) bottom label - (Y axis) top label : Y axis value ,
      ],

    • When using a scatter chart, the X and Y axes have a range between -100 to 100, with the median at 0. Using a value outside of that range will cause it to revert to the maximum possible value.
    • TABLE chart
    • TABLE chart is a function that allows you to generate tables as images. As shown in the example, comma-separated values can be used in the data to separate the values into different cells, and line breaks can be used to add more rows.
    • TABLE chart can be used to configure tables that contain up to 10 rows and 10 columns. Any rows or columns added beyond that will be automatically deleted. You can configure up to a maximum of 20 characters of text in each cell.
    • TABLE chart labels can be enclosed in {{}} to change the formatting of cells. Available formatting options are "color" (text color) and "bgcolor" (background color).

      (E.g.)
      DATA: [
      {{ text:: label ;; color:: 000000 ;; bgcolor:: ff0000 ;; }} , label ,label ,label ,label
      label , label ,label ,label ,label
      label , label ,label ,label ,label
      ],

  • COLOR(Optional Field)
    Choose a color for your chart.
    *Only one color may be chosen for Radar charts, Line charts and Scatter chart. Even if you choose more than one color, only the first color will be applied.TABLE chart borders can be set to different colors.

    (E.g.）COLOR[ 000000 ]

    *Multiple colors may be chosen for bar charts and pie charts. The number of colors that may be selected is equal to the number of labels in the chart. When the number of selected colors is less than the number of labels, the setting will return to the first color in a repeating loop.

    E.g. COLOR[ ff0000, 0000ff, 008000, ]

  • MAX(Optional Field) - Radar charts only
    Set the maximum scale value for your radar chart.
  • TOTAL - Pie charts only
    Set the total sum of all values, as displayed when the user mouses over the chart.
    Useful for when you would like to have the values in a pie chart add up to 100%.
    For example, when the setting TOTAL:100 is in place, even if the pie graph contains the four values "1,1,1,1", the values will be adjusted to "25,25,25,25" in order to amount to a total of 100.
  • COLUMNWIDTH（Optional Field） - Applicable only for TABLE chart
    Setting this parameter to 1 in TABLE chart settings will make the table columns of variable width, which changes based on the length of the character string in the value. Not setting this parameter or setting it to 0 will make all columns equal in width.

COUNTIFLIST Function - Use a list to count and display the values that match the conditions among the values

• This function displays counted values from the LIST1 values (numbers) used in that match specified conditions, including branch numbers and [LIST1][LIST1_1]…

• E.g. =COUNTIFLIST( 1 , >=50 )

  If you put 1 in the list number, and >=50 as a condition, it will display all values (including branch numbers) over 50 will be displayed as LIST1.
• Conditions can be an equals sign, an inequality sign (=><), a number, or a string. The = can be omitted.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

• E.g. =COUNTIFLIST( 1-2 , >=50 )

  If the values in the list are separated by commas and displayed separately, you can add hyphen + numeric value to the list number like this to specify a value at the specified position from within the comma-separated values. In this example, 1-2 will display the average of the values from the second comma-separated number in the list 1 values displayed in the diagnosis results.

COUNTLIST Function - Display the counted values from the numbers shown using a list

• This function displays the counted LIST1 values (numbers) used in, including branch numbers and [LIST1] [LIST1_1]…

• E.g. =COUNTLIST( 1 )

  If you put 1 in parentheses, it will display the counted values (including branch numbers) displayed in LIST1.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

Shuffling effect function - Applies an effect that shuffles the strings when displayed

• This is a function that allows the string inserted between the brackets of =EF_SHUFFLE() to be shuffled and displayed.

Example of use

▼Five successive lottery draws
=EF_SHUFFLE(
[LIST1]
[LIST1_1]
[LIST1_2]
[LIST1_3]
[LIST1_4]
, 20 ,1000)

• Each parameter
  • String (required field) - Enter strings that you want to be shuffled and displayed here. If you want to add a comma into the string, please enclose them in single (double) quotation marks such as "ab , cd" and 'ef , gh'.
    When you create a new line, each string will be separated for each new line and will be shuffled and displayed in order.
  • Number of shuffles (optional field) - Sets the number of times that the string is shuffled. The bigger the value, the longer the shuffling time will be.
    *The default value is 30
    *The minimum value is 10 and the maximum value is 100. If you set it below the minimum value or above the maximum value, it will automatically be adjusted to the maximum or minimum value.
  • Starting time (milliseconds) (optional field) - You can delay the time that the shuffle starts.
    For example, you can use it when you have two shuffles lined up and you want to delay the starting time of the second shuffle.
    *The unit is milliseconds. If you want a delay of three seconds, please enter 3000.
    *The maximum value is 5000 (five seconds). If you set it above the maximum value, it will automatically be adjusted to the maximum value.

Caution

• This effect is only used when the diagnosis results are displayed on this site and will not change text that is posted on Twitter and so on.
• This effect will only be applied in browsers in which JavaScript is effective and if it is not effective, only the usual text will be displayed.
• This function might not operate normally on some devices, browsers, and so on.

Typing effect function - Allows one character to be displayed at a time as if the character string is being typed out

• =EF_TYPINGThis is a function that allows one character to be displayed at a time, as if being typed, from a character string in the brackets ().

Example of use

=EF_TYPING( [LIST1] , 100 , 500 )

• Each parameter
  • Character string (required) – Register the character string that you want to display here. If you want to add a comma into the character string, please surround it with single (double) quotation marks, e.g., "ab , cd" and 'ef , gh'.
    If you insert a line break, each character string will be split by the line breaks and displayed in order.
  • Display interval (milliseconds) (optional) – You can set the interval at which each character is displayed in milliseconds. The smaller the number is, the faster the text will be displayed.
    *The default value is 100
    *The lowest value is 10 and the highest value is 2000. If you set the value lower or higher than the lowest or highest values, it will automatically be corrected to the lowest or highest value.
  • Starting time (milliseconds) (optional) – You can delay the time at which the string starts to be displayed.
    For example, you can use this to delay the starting time of the second function when you have two effect functions in a row.
    *The unit is milliseconds. If you want to delay it by 3 seconds, please set it as 3000.
    *The highest value is 5000 (5 seconds). If you set it higher than the highest value, it will automatically be corrected to the highest value

Caution

• This effect is only used when the diagnosis results are displayed on this site and will not change text that is posted on Twitter and so on.
• This effect will only be applied in browsers in which JavaScript is effective and if it is not effective, only the usual text will be displayed.
• This function might not operate normally on some devices, browsers, and so on.

IF Function - Changes displayed information based on a set of conditions

• This function may be used to display (a logical formula and) a positive value when a set of conditions are met, and a negative value when those conditions are not met. Thus, the information displayed may be altered depending on whether or not certain conditions are met.
• Logical formulas are generated by linking two values together with an equals sign, or a greater-than or less-than sign(=><).

  E.g. =IF( [LIST1] >= 80, Pass, Fail )

  In the example above, when [LIST1] is 80 or greater, the formula is true and a passing result is displayed, while in all other cases, the value is false and a failing result is displayed.
• Within an IF formula, it is not possible to use symbols such as ( ) , , etc, as true or false values. If these symbols are used, the formula will not be converted and an error will occur.
• To use multiple conditions within an IF formula, the AND function or the OR function may be used within the logical formula.

MAXLIST Function - Display the highest value among those shown on a list

• This function displays the highest value from the LIST1 values (numbers) used, including branch numbers and [LIST1][LIST1_1]…

• E.g. =MAXLIST( 1 )

  If you put 1 in parentheses, it will display the largest value among all of the values (including branch numbers) displayed as LIST1.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

• E.g. =MAXLIST( 1-2 )

  If the values in the list are separated by commas and displayed separately, you can add hyphen + numeric value to the list number like this to specify a value at the specified position from within the comma-separated values. In this example, 1-2 will display the largest value from the second comma-separated number in the list 1 values displayed in the diagnosis results.

MINLIST Function - Display the smallest value among the numbers displayed using a list

• This function displays the lowest value from the LIST1 values (numbers) used, including branch numbers and [LIST1] [LIST1_1]…

• E.g. =MINLIST( 1 )

  If you put 1 in parentheses, it will display the largest value among all of the values (including branch numbers) displayed as LIST1.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

• E.g. =MINLIST( 1-2 )

  If the values in the list are separated by commas and displayed separately, you can add hyphen + numeric value to the list number like this to specify a value at the specified position from within the comma-separated values. In this example, 1-2 will display the largest value from the second comma-separated number in the list 1 values displayed in the diagnosis results.

The OR Function - Make judgments based on multiple conditions (Used with the IF function)

• The OR function displays "true" =TRUE when one of a number of logical formulas is true.

  E.g. =IF( =OR([LIST1] >= 80, [LIST2] >= 80), Pass , Fail )

  In the above example, when either [LIST1] or [LIST2] is 80 or greater, the formula is true and a passing result displayed, and in all other cases, a failing result is displayed.
• The AND function and the OR function may be used as part of the logical formula for the IF function.
• It is possible to use the AND function and the OR function together to set as many conditions as you like for a formula.

RAND_N function - Display a random value

• A function that can display random numerical values.
• Each parameter
• Number (numerical value) (optional field)（initial value: 0) - With this RAND_N function's number, the numerical value output can be reused.
• minimum value (numerical value) (optional field)（initial value: 0) - sets the minimum value of the numerical value you want to display randomly.
• maximum value (numerical value) （(optional field)（initial value: 100) - sets the maximum value of the numerical value you want to display randomly.
• Duplicate flag (numerical value) （(optional field)（initial value: 0) -if it is 1, it will process so that the numerical value that was displayed before won't be displayed again. If the numerical value that was displayed before can be displayed again, this will be 0.

• E.g. =RAND_N( 0 , -100 , 100 )

  In this example, the first number is set as 0, the minimum value is set as -100, and the maximum value is set as 100, and the diagnosis result will display a random numerical value between -100 to 100. After this function is entered, then you enter =RAND_N(0) , you can display the same value as the value displayed as number 0.
• The difference between the minimum and maximum values can be set up to 2 raised to the power of 60 (1,152,921,504,606,846,976).
• Omission of values

  E.g. =RAND_N( )

  Each parameter can be omitted. In this case, each parameter becomes the initial value, and the number becomes, 0, the minimum value becomes 0, and the maximum value becomes 100.

  E.g. =RAND_N( 1 )

  As above, it is possible to set the number only. Each parameter becomes the initial value, the minimum value becomes 0, and the maximum value becomes 100.
• When multiple functions of the same number are entered

  E.g. =RAND_N( 0 , -100 , 100 )
  　　=RAND_N( 0 , -999 , 999 )

  When you use the same number and set RAND_N function with different minimum value/maximum values, what you first entered is prioritized and the minimum/maximum value you entered later becomes void.
• Duplicate flag

  E.g. =RAND_N( 0 , 0 , 5 , 0 )
  　　=RAND_N( 1 , 0 , 5 , 1 )

• When the difference between the maximum value and the minimum value is more than 1,152,921,504,606,846,976, the maximum value is automatically adjusted.
• When entries have mistakes or character strings, it will be an error and 0 will be displayed.
• RAND_N function set content are added to the number of diagnosis result patterns. However, if there is a list variable set in the function or there is a RAND_N function set in the list, calculation cannot be made properly, so "0" will be displayed.
• create.説明-関数-RAND_N-RAND_N関数で表示された値を

SUMIFLIST Function - Use a list to display the sum of values displayed that match conditions

• This function displays statistics on values that match specified conditions LIST1 values (numbers) used in, including branch numbers and [LIST1] [LIST1_1]… .

• E.g. =SUMIFLIST( 1 , >=50 )

  1286--If you put 1 in the list number, and >=50 as a condition, it will display all values (including branch numbers) over 50 will be displayed as LIST1.
• Conditions can be an equals sign, an inequality sign (=><), a number, or a string. The = can be omitted.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

• (Example)= SUMIFLIST( 1-2 , vegetables , 3)

  If the values in the list are separated by commas and displayed separately, you can add hyphens + numeric values to the list number like, this , to specify a value at the specified position from within the comma-separated values.
  It is also possible to specify the values to be summed by separator position.
  For example, the values in list1 displayed in the diagnosis results can be separated into three parts: "Carrots , vegetables , 50".
  In this example, the search target is 1-2, and the separator number for the sum is 3, so if the second separator value in list 1 matches "vegetables", the third separator value "50" will be used for the sum.

SUMLIST Function - Uses a list to display the total of all displayed values

• This function adds up all values (numerical values) used in LIST1, including branch numbers (e.g. [LIST1][LIST1_1]).

• E.g. =SUMLIST( 1 )

  When "1" is inserted in brackets, the total of all numerical values comprising LIST1, including branch numbers, is displayed.
• If you want to target the values output by the RAND_N function instead of a list, put RAND_N in the place of the list number.

• E.g. =SUMLIST( 1 , 2 )

  By dividing values with commas, it is possible to select multiple lists. In this example, List 1 and List 2, which are displayed in the diagnosis results, as well as their branch numbers, are added together.

• E.g. =SUMLIST( 1-2 )

  If the values in the list are displayed separated by commas, then by adding hyphen + numerical value to the list numbers in this way, regarding the values delineated by commas, it becomes possible to total the values in the specified positions. As in this example, in the case of 1-2, all comma-delineated second numerical values for list 1 values displayed in the diagnosis results will be part of the total amount.