Exp digital currency
Publish: 2021-04-10 15:59:34
1. I know that in addition to mines, there are high-frequency trading arbitrage of foreign exchange and virtual currency, virtual currency arbitrage training, virtual currency ATM.
2. &# 8205; bitcoin is still the dominant cryptocurrency, and no currency can surpass it. Most of the start-ups in the field of cryptocurrency are bitcoin related companies&# 8205;&# 8205;
3. When the amount of exp / imp data is large, this process takes a long time. We can use some methods to optimize the exp / imp operation<
exp: using direct path direct = y
Oracle will avoid SQL statement processing engine, read data directly from the database file, and then write it to the export file.
it can be observed in the export log that:
exp-00067: table XXX will be exported in conventional path
if no direct path is used, The value of buffer parameter must be large enough.
some parameters are not compatible with direct = y, so it is not possible to export removable tablespace with direct path, or export database subset with query parameter.
when the imported and exported databases are running on different OS, it is not possible to export removable tablespace with direct path, The value of recordlength parameter must be consistent.
imp: optimize through the following ways
1_ area_ Set the size to a larger value, such as 100m
2. Avoid waiting for log switch
increase the number of redo log groups and the size of log files.
3. Optimize the log buffer, such as_ The buffer capacity should be increased by 10 times (the maximum size should not be more than 5m)
4. Insert and submit with array
commit = y
note: the array mode can not handle tables with lob and long types. For such tables, if commit = y is used, each row is inserted, The redo log will be submitted once.
5. Use nologing to rece the redo log size
when importing, specify the parameter indexes = n, only import data and ignore index. After importing data, create index through script, specify nologing options
export / import and character set
when importing and exporting data, we should pay attention to the problem of character set. In the process of exp / imp, we need to pay attention to four character set parameters: the client character set of the export side, the database character set of the export side, the client character set of the import side, and the database character set of the import side
we need to look at these four character set parameters first
view the character set information of the database:
sql & gt; select * from nls_ database_ parameters;< br />
PARAMETER VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_ LANGUAGE AMERICAN
NLS_ TERRITORY AMERICA
NLS_ CURRENCY $
NLS_ ISO_ CURRENCY AMERICA
NLS_ NUMERIC_ CHARACTERS .,
NLS_ CHARACTERSET ZHS16GBK
NLS_ CALENDAR GREGORIAN
NLS_ DATE_ FORMAT DD-MON-RR
NLS_ DATE_ LANGUAGE AMERICAN
NLS_ SORT BINARY
NLS_ TIME_ FORMAT HH.MI.SSXFF AM
NLS_ TIMESTAMP_ FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_ TIME_ TZ_ FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_ TIMESTAMP_ TZ_ FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_ DUAL_ CURRENCY $
NLS_ COMP BINARY
NLS_ NCHAR_ CHARACTERSET ZHS16GBK
NLS_ RDBMS_ VERSION 8.1.7.4.1
NLS_ Character set: ZHS16GBK is the character set of the current database
let's look at the client's character set information again:
the NLS parameter of the client's character set_ LANG=_& lt; territory >.
Language: Specifies the language used for Oracle messages, and displays the day and month in the date
territory: Specifies the format of currency and number, region and the habit of calculating week and date
characterset: controls the character set used by client applications. Usually set or equal to the client's code page
or set utf8 for Unicode applications
query and modify NLS in Windows_ Lang can be performed in the registry:
HKEY_ LOCAL_ MACHINE\ SOFTWARE\ Oracle\ HOMExx\
XX refers to the existence of multiple Oracle databases_ The system number of home
in UNIX:
$env|grep NLS_ LANG
NLS_ LANG=simplified chinese_ China. ZHS16GBK
modification available:
$export NLS_ LANG=AMERICAN_ American. Utf8
it is usually best to set the client character set to be the same as the database when exporting. When importing data, there are mainly the following two cases:
(1) the source database and the target database have the same character set settings
in this case, you only need to set the NLS of the export and import clients_ Lang is equal to the database character set
(2) the source database and the target database have different character sets
first export the NLS of the client_ Lang is set to be consistent with the database character set of the export side, export the data, and then import it into the NLS of the client side_ Lang is set to be consistent with the export side, and the data is imported, so that the conversion only occurs in the database side, and only once
in this case, only when the character set of the import side database is a strict superset of the character set of the export side database, can the data be completely imported, otherwise, there may be data inconsistency or garbled
the problem of exp / imp between different versions
generally speaking, it is not a big problem to import data from low version to high version, but the trouble is to import data from high version to low version. Before Oracle9i, exp / imp between different versions of Oracle can be solved by the following methods:
1. Run the bottom version of catexp.sql on high version database
2. Use low version exp to export high version data
3. Import the database into the lower version database by using the lower version imp
4. Rerun the high version of catexp.sql script on the high version database
but in 9i, the above method can't solve the problem. If you directly use the lower version of exp / imp, the following errors will appear:
exp-00008: Oracle error% Lu accounted
ora-00904: invalid column name
this is a published bug, and you need to wait until oracle10.0 to solve it. The bug number is 2261722. You can check the details of this bug on metalink
bugs belong to bugs. We still have to do our work. We will solve them ourselves before Oracle supports us. Execute the following SQL in Oracle9i and rebuild the exu81rls view< br />CREATE OR REPLACE view exu81rls
(objown,objnam,policy,polown,polsch,polfun,stmts,chkopt,enabled,spolicy)
AS select u.name, o.name, r.pname, r.pfschma, r.ppname, r.pfname,
decode(bitand(r.stmt_ type,1), 0,'&# 39;, &# 39; SELECT,')< br />|| decode(bitand(r.stmt_ type,2), 0,'&# 39;, &# 39; INSERT,')< br />|| decode(bitand(r.stmt_ type,4), 0,'&# 39;, &# 39; UPDATE,')< br />|| decode(bitand(r.stmt_ type,8), 0,'&# 39;, &# 39; DELETE,'),< br />r.check_ opt, r.enable_ flag,
DECODE(BITAND(r.stmt_ type, 16), 0, 0, 1)
from user$ u, obj$ o, rls$ r
where u.user# = o.owner#
and r.obj# = o.obj#
and (uid = 0 or
uid = o.owner# or
exists ( select * from session_ roles where role=' SELECT_ CATALOG_ ROLE')< br />)
/
grant select on sys.exu81rls to public;
/
exp / imp can be used across versions, but the versions of exp and imp must be used correctly:
1. Always use the version of IMP to match the database version, for example, to import to 817, use the imp tool of 817.
2. Always use the version of exp to match the lowest version of two databases, for example, to import from 9201 to 817, use the exp tool of 817
exp: using direct path direct = y
Oracle will avoid SQL statement processing engine, read data directly from the database file, and then write it to the export file.
it can be observed in the export log that:
exp-00067: table XXX will be exported in conventional path
if no direct path is used, The value of buffer parameter must be large enough.
some parameters are not compatible with direct = y, so it is not possible to export removable tablespace with direct path, or export database subset with query parameter.
when the imported and exported databases are running on different OS, it is not possible to export removable tablespace with direct path, The value of recordlength parameter must be consistent.
imp: optimize through the following ways
1_ area_ Set the size to a larger value, such as 100m
2. Avoid waiting for log switch
increase the number of redo log groups and the size of log files.
3. Optimize the log buffer, such as_ The buffer capacity should be increased by 10 times (the maximum size should not be more than 5m)
4. Insert and submit with array
commit = y
note: the array mode can not handle tables with lob and long types. For such tables, if commit = y is used, each row is inserted, The redo log will be submitted once.
5. Use nologing to rece the redo log size
when importing, specify the parameter indexes = n, only import data and ignore index. After importing data, create index through script, specify nologing options
export / import and character set
when importing and exporting data, we should pay attention to the problem of character set. In the process of exp / imp, we need to pay attention to four character set parameters: the client character set of the export side, the database character set of the export side, the client character set of the import side, and the database character set of the import side
we need to look at these four character set parameters first
view the character set information of the database:
sql & gt; select * from nls_ database_ parameters;< br />
PARAMETER VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_ LANGUAGE AMERICAN
NLS_ TERRITORY AMERICA
NLS_ CURRENCY $
NLS_ ISO_ CURRENCY AMERICA
NLS_ NUMERIC_ CHARACTERS .,
NLS_ CHARACTERSET ZHS16GBK
NLS_ CALENDAR GREGORIAN
NLS_ DATE_ FORMAT DD-MON-RR
NLS_ DATE_ LANGUAGE AMERICAN
NLS_ SORT BINARY
NLS_ TIME_ FORMAT HH.MI.SSXFF AM
NLS_ TIMESTAMP_ FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_ TIME_ TZ_ FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_ TIMESTAMP_ TZ_ FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_ DUAL_ CURRENCY $
NLS_ COMP BINARY
NLS_ NCHAR_ CHARACTERSET ZHS16GBK
NLS_ RDBMS_ VERSION 8.1.7.4.1
NLS_ Character set: ZHS16GBK is the character set of the current database
let's look at the client's character set information again:
the NLS parameter of the client's character set_ LANG=_& lt; territory >.
Language: Specifies the language used for Oracle messages, and displays the day and month in the date
territory: Specifies the format of currency and number, region and the habit of calculating week and date
characterset: controls the character set used by client applications. Usually set or equal to the client's code page
or set utf8 for Unicode applications
query and modify NLS in Windows_ Lang can be performed in the registry:
HKEY_ LOCAL_ MACHINE\ SOFTWARE\ Oracle\ HOMExx\
XX refers to the existence of multiple Oracle databases_ The system number of home
in UNIX:
$env|grep NLS_ LANG
NLS_ LANG=simplified chinese_ China. ZHS16GBK
modification available:
$export NLS_ LANG=AMERICAN_ American. Utf8
it is usually best to set the client character set to be the same as the database when exporting. When importing data, there are mainly the following two cases:
(1) the source database and the target database have the same character set settings
in this case, you only need to set the NLS of the export and import clients_ Lang is equal to the database character set
(2) the source database and the target database have different character sets
first export the NLS of the client_ Lang is set to be consistent with the database character set of the export side, export the data, and then import it into the NLS of the client side_ Lang is set to be consistent with the export side, and the data is imported, so that the conversion only occurs in the database side, and only once
in this case, only when the character set of the import side database is a strict superset of the character set of the export side database, can the data be completely imported, otherwise, there may be data inconsistency or garbled
the problem of exp / imp between different versions
generally speaking, it is not a big problem to import data from low version to high version, but the trouble is to import data from high version to low version. Before Oracle9i, exp / imp between different versions of Oracle can be solved by the following methods:
1. Run the bottom version of catexp.sql on high version database
2. Use low version exp to export high version data
3. Import the database into the lower version database by using the lower version imp
4. Rerun the high version of catexp.sql script on the high version database
but in 9i, the above method can't solve the problem. If you directly use the lower version of exp / imp, the following errors will appear:
exp-00008: Oracle error% Lu accounted
ora-00904: invalid column name
this is a published bug, and you need to wait until oracle10.0 to solve it. The bug number is 2261722. You can check the details of this bug on metalink
bugs belong to bugs. We still have to do our work. We will solve them ourselves before Oracle supports us. Execute the following SQL in Oracle9i and rebuild the exu81rls view< br />CREATE OR REPLACE view exu81rls
(objown,objnam,policy,polown,polsch,polfun,stmts,chkopt,enabled,spolicy)
AS select u.name, o.name, r.pname, r.pfschma, r.ppname, r.pfname,
decode(bitand(r.stmt_ type,1), 0,'&# 39;, &# 39; SELECT,')< br />|| decode(bitand(r.stmt_ type,2), 0,'&# 39;, &# 39; INSERT,')< br />|| decode(bitand(r.stmt_ type,4), 0,'&# 39;, &# 39; UPDATE,')< br />|| decode(bitand(r.stmt_ type,8), 0,'&# 39;, &# 39; DELETE,'),< br />r.check_ opt, r.enable_ flag,
DECODE(BITAND(r.stmt_ type, 16), 0, 0, 1)
from user$ u, obj$ o, rls$ r
where u.user# = o.owner#
and r.obj# = o.obj#
and (uid = 0 or
uid = o.owner# or
exists ( select * from session_ roles where role=' SELECT_ CATALOG_ ROLE')< br />)
/
grant select on sys.exu81rls to public;
/
exp / imp can be used across versions, but the versions of exp and imp must be used correctly:
1. Always use the version of IMP to match the database version, for example, to import to 817, use the imp tool of 817.
2. Always use the version of exp to match the lowest version of two databases, for example, to import from 9201 to 817, use the exp tool of 817
4. Continue
exp (x): returns the value with E as the base and X as the index; That is a common function of VB
the following is the explanation of the common function:
ABS function returns the absolute value of the number
and operator performs the logical join of two expressions
the array function returns a variant containing an array
the ASC function returns the ANSI character code of the first letter of a string
the assignment operator (=) assigns values to variables or attributes
the arctangent value of the number returned by the ATN function
call statements transfer control to sub or function proceres
the CBool function returns an expression that has been converted to a variant of a Boolean subtype
the cbyte function returns an expression that has been converted to a variant of a stanza subtype
the ccur function returns an expression that has been converted to a variant of the currency subtype
the CDate function returns an expression that has been converted to a variant of a date subtype
the cdbl function returns an expression that has been converted to a variant of a double precision subtype
the Chr function returns the character of the specified ANSI character code
the cint function returns an expression that has been converted to a variant of an integer subtype
the class object provides access to the events of the created class
the class Statement Declares the class name
the clear method clears all the property settings of the err object
the CLng function returns an expression that has been converted to a variant of the long subtype
list of color constants
comparison constants list of constants used for comparison operations
the join operator (&) forces the string join of two expressions
the const Statement Declares the constant used for the letter value
the cos function returns the cosine of the angle
the CreateObject function creates and returns a reference to an automatic object
the CSng function returns an expression that has been converted to a variant of a single precision subtype
the CSTR function returns an expression that has been converted to a variant of a string subtype
date and time constants are used to define the day of the week and the constant list of other constants in date and time operations
date format constant is used for the constant list of date and time formats
the date function returns the current system date
the DateAdd function returns the date with the specified time interval added
the DateDiff function returns the interval between two dates
the datepart function returns the specified part of a given date
the dateserial function returns a variant of the specified date subtype
the DateValue function returns a variant of the date subtype
the day function returns the date from 1 to 31
the description property returns or sets a string describing an error
the dictionary object stores the objects of data keys and item pairs
dim Statement Declares variables and allocates storage space
the division operator (/) divides two numbers and returns the quotient in floating-point format
do... Loop statement repeats a chunk when the condition is true or when the condition becomes true
empty indicates the value of a variable that has not been initialized
the EQV operator makes two expressions equal
the erase statement reinitializes the elements of the fixed array and reallocates the storage space of the dynamic array
the err object contains information about runtime errors
the eval function evaluates and returns the value of the expression
the execute method searches for regular expressions based on the specified string
the execute statement executes a single or more specified statements
the exit statement exits a do... Loop, for... Next, function, or sub block
exp function returns the power of E (the base of natural logarithm)
the self multiplication operator (^) is an exponential function, and the power is an independent variable
false keyword, whose value is zero
the file system object provides access to the computer file system
the filter function returns an array containing a subset of string arrays with a lower bound of 0 according to the specified filtering criteria
the firstindex property returns the location of the string match
the fix function returns the integer part of the number
for... Next statement repeats a set of statements a specified number of times
for each... Next statement repeats a set of statements for each element in an array or collection
the expression returned by the formatcurrency function is the currency value format, and its currency symbol is defined in the system control panel
the formatdatetime function returns an expression formatted as a date or time
the formatnumber function returns an expression formatted as a number
the formatpercent function returns an expression formatted as a percentage (multiplied by 100), ending with the% sign
the function statement declares the name, parameters and code that form the body of the function procere
the GetObject function returns access to automatic objects from a file
the GetRef function returns a reference to a procere that can be bound to an event.
exp (x): returns the value with E as the base and X as the index; That is a common function of VB
the following is the explanation of the common function:
ABS function returns the absolute value of the number
and operator performs the logical join of two expressions
the array function returns a variant containing an array
the ASC function returns the ANSI character code of the first letter of a string
the assignment operator (=) assigns values to variables or attributes
the arctangent value of the number returned by the ATN function
call statements transfer control to sub or function proceres
the CBool function returns an expression that has been converted to a variant of a Boolean subtype
the cbyte function returns an expression that has been converted to a variant of a stanza subtype
the ccur function returns an expression that has been converted to a variant of the currency subtype
the CDate function returns an expression that has been converted to a variant of a date subtype
the cdbl function returns an expression that has been converted to a variant of a double precision subtype
the Chr function returns the character of the specified ANSI character code
the cint function returns an expression that has been converted to a variant of an integer subtype
the class object provides access to the events of the created class
the class Statement Declares the class name
the clear method clears all the property settings of the err object
the CLng function returns an expression that has been converted to a variant of the long subtype
list of color constants
comparison constants list of constants used for comparison operations
the join operator (&) forces the string join of two expressions
the const Statement Declares the constant used for the letter value
the cos function returns the cosine of the angle
the CreateObject function creates and returns a reference to an automatic object
the CSng function returns an expression that has been converted to a variant of a single precision subtype
the CSTR function returns an expression that has been converted to a variant of a string subtype
date and time constants are used to define the day of the week and the constant list of other constants in date and time operations
date format constant is used for the constant list of date and time formats
the date function returns the current system date
the DateAdd function returns the date with the specified time interval added
the DateDiff function returns the interval between two dates
the datepart function returns the specified part of a given date
the dateserial function returns a variant of the specified date subtype
the DateValue function returns a variant of the date subtype
the day function returns the date from 1 to 31
the description property returns or sets a string describing an error
the dictionary object stores the objects of data keys and item pairs
dim Statement Declares variables and allocates storage space
the division operator (/) divides two numbers and returns the quotient in floating-point format
do... Loop statement repeats a chunk when the condition is true or when the condition becomes true
empty indicates the value of a variable that has not been initialized
the EQV operator makes two expressions equal
the erase statement reinitializes the elements of the fixed array and reallocates the storage space of the dynamic array
the err object contains information about runtime errors
the eval function evaluates and returns the value of the expression
the execute method searches for regular expressions based on the specified string
the execute statement executes a single or more specified statements
the exit statement exits a do... Loop, for... Next, function, or sub block
exp function returns the power of E (the base of natural logarithm)
the self multiplication operator (^) is an exponential function, and the power is an independent variable
false keyword, whose value is zero
the file system object provides access to the computer file system
the filter function returns an array containing a subset of string arrays with a lower bound of 0 according to the specified filtering criteria
the firstindex property returns the location of the string match
the fix function returns the integer part of the number
for... Next statement repeats a set of statements a specified number of times
for each... Next statement repeats a set of statements for each element in an array or collection
the expression returned by the formatcurrency function is the currency value format, and its currency symbol is defined in the system control panel
the formatdatetime function returns an expression formatted as a date or time
the formatnumber function returns an expression formatted as a number
the formatpercent function returns an expression formatted as a percentage (multiplied by 100), ending with the% sign
the function statement declares the name, parameters and code that form the body of the function procere
the GetObject function returns access to automatic objects from a file
the GetRef function returns a reference to a procere that can be bound to an event.
5. The categories of items and equipment < br /
< br /
< br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < each of the first-35\\35\< br / < br / < br > < br > < br / < br > < br > < br / < br / < br / < br > < br > < br / < br / < br > < br > < each each each each each each each each each of the < br / < br / < br / <
14 # dol
15 # hel
16 # IO
17 # lum
18 # Ko
19 # fal
20 # LEM
21 # pul
22 ᦇ um
23 ᦇ mal
24 ᦇ ist
25 ᦇ Gul
26 ᦇ vex
27 ᦇ ohm
28 ᦇ Lo
29 ᦇ sur
30 ᦇ BER
31 ᦇ Jah
32 ᦇ Cham
33 ᦇ Zod
40 / 15: generally, there should be IAS or max after it, Represents 40 ed / 15ias or 40 ed / 15max damage
ar: attack hit rate
as: attack speed
ds: critical strike attribute
CB: decisive strike
Kb: repel
ow: wound
MF: chance to obtain magic items, It generally refers to a behavior
CBF: not frozen attribute
FHR: fast recovery strike
FCR: fast casting spell
MDR: rece magic damage
ITD: ignore target defense
IAS: increase fast attack speed
eth: disposable items that cannot be repaired
FRW: fast moving / running attribute
req: equipment requirements of items, It generally includes strength, agility, Class
icob: increase the probability of resistance
leech: Vampire / suck magic power / experience value
pe: perfect emerald
pr: perfect ruby
pd: perfect white diamond
wmpg: perfect gem
Cr: anti ice
fr: fire prevention
LR: anti electricity
PR: anti poison
CD: ice damage
FD: fire damage
LD: electric damage
PD: poison damage
MD: magic damage
res: resistance (four defenses)
def: Defense
dam: damage, DMG in the same way
Dr: rece physical damage, which is commonly known as Wumian
ed: increase damage, or enhance defense
BC: the most commonly refers to the small amulet that increases the probability of magic equipment occurrence by 6%, and another means idiot...
SC: small amulet, generally refers to the small Amulet of 7% MF, Common currency
LC: large amulet
GC: super large amulet
b & # 39; SC: the SC dropped by Baal, because of its high level, can wash out better attributes
n & # 39; SC: the SC dropped by niserak, because of its high level, can wash out better attributes
PDSC: a small talisman to increase poison damage, It generally refers to the small Amulet of 100 poison damage
LGC + 1 mage's super large Amulet of electricity skill
CB: giant God's blade
CS: giant God's sword
Pb: Magic blade
MS: secret instrument's sword
SS: Assassin's close cut
amu: necklace, amulet, and the same meaning is Amy, XL
wbow: bow of shelter
bow: bow of matriarch
Gris: Griswold & # 39; S Legacy Ranger essence set for short
cXXq: also cXXe, refers to the weapon with the cruel prefix and light / absorb the suffix. Generally speaking, these are the best
of the same kind of weapon. For example, ccbq, cwpq, CMSE, CSSE, cmbe and so on<
gmbow: generally refers to the bow in the Amazon suit
Lionheart: the language of the talisman lion heart
Fury: the language of the talisman fury
rhyme: the language of the talisman rhyme
White: the language of the talisman white, the wizard PK's good weapon
silence: the language of the talisman silence
smoke: the language of the talisman smoke
uni: dark gold items
GF: grandfather giant's blade, The best weapon of barbarian PVC
TT: dark gold Amazon javelin, also known as Titan
WF: wind power, dark gold nine headed snake bow; Water fish, mostly refers to players who don't understand the market
wt: boots of the battlefield
SOJ: stone of Jordan. The main currency in circulation of war net is
ear: string of ears, which is usually called Wumian belt, Another one is that PK people fall out of their ears
ire: usually refers to rother armor
Sun: rising sun
orb: eyeball or Witch skills
WMJ: Wu Mian armor
WMD: Wu Mian shield
WMK: Wu Mian helmet
game: usually refers to Wu Mian helmet
Room: Sword of dark gold champion
mesh: Wu Mian armor
Mara: Mara's Kaleidoscope Necklace
skin: each There are some differences between the two battle nets. Most of them refer to the skin armor of the dark gold fire devil, while others refer to the skin armor of the dark gold sea snake. Luna is one of the dark gold shields, which has the attribute of ice absorption, Ballista / DP
bow: bow of the dark gold Crusader
wmyd: Wumian belt
Raven: Crow
shako: dark gold cap, Junmao
Jordan: Jordan's stone ring
storm: Wumian shield, storm shield
bbface: array & 39; S face Slayer guard special dark gold helmet for barbarians
mallet: Schaefer & # 39; S hammer legendary mallet, the hand weapon of Ranger
Highlord: Highlord & 39; S wrath army's anger, also known as Dajun
Zakarum: dark gold Ranger special shield
Jew: jewel jewelry
JP: boutique, best
LJ: La Ji garbage
leg: leg. It's a must to open the cow level
IK: barbarian suit, short for Immortal King
tal: taraxia suit
naj: Witch suit, Nagi
NAT: short for assassin suit
sign: Xigang suit
laying: glove for disciple suit
mavina: short for Amazon mavina suit, Or write MVN
character skill class
this class generally has a feature that the abbreviation is mastered by the first letter of each word of the skill, for example, CN = = cold master witch's cold magic.
Amazon: Amazon, other words with the same meaning are zon, AMZ
CS: Amazon's double strike skill
GA: Amazon's Guide arrow skill
LF: Amazon's lightning rage skill
MS: Amazon's row arrow skill
SM: Amazon's slow attack skill
Valk: Amazon's female warrior skill
ASN: assassin, As
cm: Assassin's claw mastery skill
DF: Assassin's dragon flying skill
LS: Assassin's lightning trap skill
MB: Assassin's shockwave skill
ts: Assassin's tiger strike skill
SM: Assassin's shadow master skill
cos: Assassin's phantom Cape skill
bar: barbarian, and BB, Ymr
Bo: barbarian battle command skill
is: barbarian steel skin skill
La: barbarian jump skill
NR: barbarian natural resistance skill
SM: barbarian sword mastery skill
ssbar: double sword barbarian or sword shield barbarian
dru: Druid
CA: Druid's storm armor skill
OS: Druid's Oak skill Skill
Fury: Druid's rage skill
SOR: witch, There are also Sorc
es: Witch's energy shield skill
cm: Witch's ice mastery skill
FW: Witch's fire wall skill
LM: Witch's electricity mastery skill
TK: Witch's space taking skill
TP: Witch's blinking skill
ts: Witch's thundercloud skill
SF: Witch's electrostatic field skill
Hydra: Witch's Hydra skill
meteor: Witch's meteorite skill
pal: Ranger, as well as Pala, Parly, xxdin
HF: Ranger's holy knot skill
HS: Ranger's Holy Shield skill
con: Ranger's concentrated aura skill, Conc is the same as
FOH: Ranger's heaven fist skill
ven: Ranger's Revenge skill
conv: Ranger's trial aura skill
NEC: Wizard, Similarly, Necro
BW: bone wall skill of wizard
Ce: Corpse Explosion skill of wizard
GM: master skill of wizard's puppet
PN: poison Star Skill of wizard
Ig: Iron puppet skill of wizard
im: Iron virgin skill of wizard
LR: rece resistance skill of wizard
amp: strengthen damage skill of wizard
Dec: aging skill of wizard Skills
STR: strong
vit: vigor
Eng: energy
DEX: Agility
HP: life value
MP: Mana value
common words
communication in the game has formed a unique culture. Understanding common phrases is the beginning of integrating into this culture...
=: etc.
b: Baal, The last leader
1: in the process of leading, if the leader hits this number, it means that the door is very safe and can enter, if it is 2, it means danger
5T: five groups of enemies in front of Baal
88: bye, many of the same, such as BB, bye, 886, etc.
x #: X is the number in the middle of 1-33, which means the magic talisman No. x
BD: in the forum, This word generally means helping the top, there is also the meaning of fool
BT: abnormal
ah: dark
3Q: Thank you, there are many, such as thx, XX, thax, 3x and so on
4242: Yes, yes
555 ~ ~ ~: cry
ACC: account name
Max: maximum damage
Min: minimum damage
x H: X means 1-2, It means several weapons. For example, 1 h means one hand weapon
x s: X means a number of 1-6, which means several holes weapon, For example, 6S means 6-hole weapon
bug: Game loophole
ban: account blocked by administrator
BBS: Forum
btw: by the way
char: role
cow: cattle farm
Cr: game creation
BRB: idea of replacement, please wait
Cu: Goodbye
CW: colour wolf, ha ha ha
DD: things
ds: how much? Used in general transactions; Or "on the ground" means
al: double suction
El: el. It is equivalent to PK
en: Um
exp: experience value
fant: inverted, dizzy, can also be used ft
GG: brother
JJ: sister
GX: congratulations:)
Hell: Hell difficulty
I C: I see
C / C: room name = China, password = China, home of Chinese players
J / J: room name = Japan, password = Japan, game room name, Japanese players home
k / K: room name = Korea, password = Korea, game room name, Korean players home
JS: J business
KX: for example, KC / KP / km / KB, main activities of battle. Net, KC = kill cattle; KP = under the fifth scene, the Red Gate enters the gate
jinguai; Km = kill memphisto; KB = kill bar
CK: ox king, key protection object
lag: network delay, generally means slow network speed
lol: laugh, many other similar ^ o ^, - O --_- And so on
LV: level, level
me 2: me too
mm: sister, Meimei, female player
mod: equipment attribute or alternative mode
n: many kinds of meaning, next game; NO Game room name
newbie: new person
PT: ordinary difficulty; In the forum refers to cheat paste
nm: Nightmare difficulty
dy: Hell difficulty
nor: ordinary difficulty
NP: 1: no problem; 2: Abbreviations of game name and password, such as NP? It means to ask you the name and password of the game
< br /
< br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < each of the first-35\\35\< br / < br / < br > < br > < br / < br > < br > < br / < br / < br / < br > < br > < br / < br / < br > < br > < each each each each each each each each each of the < br / < br / < br / <
14 # dol
15 # hel
16 # IO
17 # lum
18 # Ko
19 # fal
20 # LEM
21 # pul
22 ᦇ um
23 ᦇ mal
24 ᦇ ist
25 ᦇ Gul
26 ᦇ vex
27 ᦇ ohm
28 ᦇ Lo
29 ᦇ sur
30 ᦇ BER
31 ᦇ Jah
32 ᦇ Cham
33 ᦇ Zod
40 / 15: generally, there should be IAS or max after it, Represents 40 ed / 15ias or 40 ed / 15max damage
ar: attack hit rate
as: attack speed
ds: critical strike attribute
CB: decisive strike
Kb: repel
ow: wound
MF: chance to obtain magic items, It generally refers to a behavior
CBF: not frozen attribute
FHR: fast recovery strike
FCR: fast casting spell
MDR: rece magic damage
ITD: ignore target defense
IAS: increase fast attack speed
eth: disposable items that cannot be repaired
FRW: fast moving / running attribute
req: equipment requirements of items, It generally includes strength, agility, Class
icob: increase the probability of resistance
leech: Vampire / suck magic power / experience value
pe: perfect emerald
pr: perfect ruby
pd: perfect white diamond
wmpg: perfect gem
Cr: anti ice
fr: fire prevention
LR: anti electricity
PR: anti poison
CD: ice damage
FD: fire damage
LD: electric damage
PD: poison damage
MD: magic damage
res: resistance (four defenses)
def: Defense
dam: damage, DMG in the same way
Dr: rece physical damage, which is commonly known as Wumian
ed: increase damage, or enhance defense
BC: the most commonly refers to the small amulet that increases the probability of magic equipment occurrence by 6%, and another means idiot...
SC: small amulet, generally refers to the small Amulet of 7% MF, Common currency
LC: large amulet
GC: super large amulet
b & # 39; SC: the SC dropped by Baal, because of its high level, can wash out better attributes
n & # 39; SC: the SC dropped by niserak, because of its high level, can wash out better attributes
PDSC: a small talisman to increase poison damage, It generally refers to the small Amulet of 100 poison damage
LGC + 1 mage's super large Amulet of electricity skill
CB: giant God's blade
CS: giant God's sword
Pb: Magic blade
MS: secret instrument's sword
SS: Assassin's close cut
amu: necklace, amulet, and the same meaning is Amy, XL
wbow: bow of shelter
bow: bow of matriarch
Gris: Griswold & # 39; S Legacy Ranger essence set for short
cXXq: also cXXe, refers to the weapon with the cruel prefix and light / absorb the suffix. Generally speaking, these are the best
of the same kind of weapon. For example, ccbq, cwpq, CMSE, CSSE, cmbe and so on<
gmbow: generally refers to the bow in the Amazon suit
Lionheart: the language of the talisman lion heart
Fury: the language of the talisman fury
rhyme: the language of the talisman rhyme
White: the language of the talisman white, the wizard PK's good weapon
silence: the language of the talisman silence
smoke: the language of the talisman smoke
uni: dark gold items
GF: grandfather giant's blade, The best weapon of barbarian PVC
TT: dark gold Amazon javelin, also known as Titan
WF: wind power, dark gold nine headed snake bow; Water fish, mostly refers to players who don't understand the market
wt: boots of the battlefield
SOJ: stone of Jordan. The main currency in circulation of war net is
ear: string of ears, which is usually called Wumian belt, Another one is that PK people fall out of their ears
ire: usually refers to rother armor
Sun: rising sun
orb: eyeball or Witch skills
WMJ: Wu Mian armor
WMD: Wu Mian shield
WMK: Wu Mian helmet
game: usually refers to Wu Mian helmet
Room: Sword of dark gold champion
mesh: Wu Mian armor
Mara: Mara's Kaleidoscope Necklace
skin: each There are some differences between the two battle nets. Most of them refer to the skin armor of the dark gold fire devil, while others refer to the skin armor of the dark gold sea snake. Luna is one of the dark gold shields, which has the attribute of ice absorption, Ballista / DP
bow: bow of the dark gold Crusader
wmyd: Wumian belt
Raven: Crow
shako: dark gold cap, Junmao
Jordan: Jordan's stone ring
storm: Wumian shield, storm shield
bbface: array & 39; S face Slayer guard special dark gold helmet for barbarians
mallet: Schaefer & # 39; S hammer legendary mallet, the hand weapon of Ranger
Highlord: Highlord & 39; S wrath army's anger, also known as Dajun
Zakarum: dark gold Ranger special shield
Jew: jewel jewelry
JP: boutique, best
LJ: La Ji garbage
leg: leg. It's a must to open the cow level
IK: barbarian suit, short for Immortal King
tal: taraxia suit
naj: Witch suit, Nagi
NAT: short for assassin suit
sign: Xigang suit
laying: glove for disciple suit
mavina: short for Amazon mavina suit, Or write MVN
character skill class
this class generally has a feature that the abbreviation is mastered by the first letter of each word of the skill, for example, CN = = cold master witch's cold magic.
Amazon: Amazon, other words with the same meaning are zon, AMZ
CS: Amazon's double strike skill
GA: Amazon's Guide arrow skill
LF: Amazon's lightning rage skill
MS: Amazon's row arrow skill
SM: Amazon's slow attack skill
Valk: Amazon's female warrior skill
ASN: assassin, As
cm: Assassin's claw mastery skill
DF: Assassin's dragon flying skill
LS: Assassin's lightning trap skill
MB: Assassin's shockwave skill
ts: Assassin's tiger strike skill
SM: Assassin's shadow master skill
cos: Assassin's phantom Cape skill
bar: barbarian, and BB, Ymr
Bo: barbarian battle command skill
is: barbarian steel skin skill
La: barbarian jump skill
NR: barbarian natural resistance skill
SM: barbarian sword mastery skill
ssbar: double sword barbarian or sword shield barbarian
dru: Druid
CA: Druid's storm armor skill
OS: Druid's Oak skill Skill
Fury: Druid's rage skill
SOR: witch, There are also Sorc
es: Witch's energy shield skill
cm: Witch's ice mastery skill
FW: Witch's fire wall skill
LM: Witch's electricity mastery skill
TK: Witch's space taking skill
TP: Witch's blinking skill
ts: Witch's thundercloud skill
SF: Witch's electrostatic field skill
Hydra: Witch's Hydra skill
meteor: Witch's meteorite skill
pal: Ranger, as well as Pala, Parly, xxdin
HF: Ranger's holy knot skill
HS: Ranger's Holy Shield skill
con: Ranger's concentrated aura skill, Conc is the same as
FOH: Ranger's heaven fist skill
ven: Ranger's Revenge skill
conv: Ranger's trial aura skill
NEC: Wizard, Similarly, Necro
BW: bone wall skill of wizard
Ce: Corpse Explosion skill of wizard
GM: master skill of wizard's puppet
PN: poison Star Skill of wizard
Ig: Iron puppet skill of wizard
im: Iron virgin skill of wizard
LR: rece resistance skill of wizard
amp: strengthen damage skill of wizard
Dec: aging skill of wizard Skills
STR: strong
vit: vigor
Eng: energy
DEX: Agility
HP: life value
MP: Mana value
common words
communication in the game has formed a unique culture. Understanding common phrases is the beginning of integrating into this culture...
=: etc.
b: Baal, The last leader
1: in the process of leading, if the leader hits this number, it means that the door is very safe and can enter, if it is 2, it means danger
5T: five groups of enemies in front of Baal
88: bye, many of the same, such as BB, bye, 886, etc.
x #: X is the number in the middle of 1-33, which means the magic talisman No. x
BD: in the forum, This word generally means helping the top, there is also the meaning of fool
BT: abnormal
ah: dark
3Q: Thank you, there are many, such as thx, XX, thax, 3x and so on
4242: Yes, yes
555 ~ ~ ~: cry
ACC: account name
Max: maximum damage
Min: minimum damage
x H: X means 1-2, It means several weapons. For example, 1 h means one hand weapon
x s: X means a number of 1-6, which means several holes weapon, For example, 6S means 6-hole weapon
bug: Game loophole
ban: account blocked by administrator
BBS: Forum
btw: by the way
char: role
cow: cattle farm
Cr: game creation
BRB: idea of replacement, please wait
Cu: Goodbye
CW: colour wolf, ha ha ha
DD: things
ds: how much? Used in general transactions; Or "on the ground" means
al: double suction
El: el. It is equivalent to PK
en: Um
exp: experience value
fant: inverted, dizzy, can also be used ft
GG: brother
JJ: sister
GX: congratulations:)
Hell: Hell difficulty
I C: I see
C / C: room name = China, password = China, home of Chinese players
J / J: room name = Japan, password = Japan, game room name, Japanese players home
k / K: room name = Korea, password = Korea, game room name, Korean players home
JS: J business
KX: for example, KC / KP / km / KB, main activities of battle. Net, KC = kill cattle; KP = under the fifth scene, the Red Gate enters the gate
jinguai; Km = kill memphisto; KB = kill bar
CK: ox king, key protection object
lag: network delay, generally means slow network speed
lol: laugh, many other similar ^ o ^, - O --_- And so on
LV: level, level
me 2: me too
mm: sister, Meimei, female player
mod: equipment attribute or alternative mode
n: many kinds of meaning, next game; NO Game room name
newbie: new person
PT: ordinary difficulty; In the forum refers to cheat paste
nm: Nightmare difficulty
dy: Hell difficulty
nor: ordinary difficulty
NP: 1: no problem; 2: Abbreviations of game name and password, such as NP? It means to ask you the name and password of the game
6. Explanation of common terms
I'm afraid the most troublesome thing for newcomers is not the level gap, but the confusion in the face of full screen terms. Here are some of the most common abbreviations, hoping to help you on the road of battle. Net< The category of items and equipment < br /
< br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < each of the first-35\\< br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br / < br > < br / < br# shael
14 # dol
15 # hel
16 # IO
17 # lum
18 # Ko
19 # fal
20 # LEM
21 # pul
22 # um
2 3 ᦇ mal
24 ᦇ ist
25 ᦇ Gul
26 ᦇ vex
27 ᦇ ohm
28 ᦇ Lo
29 ᦇ sur
30 ᦇ BER
31 ᦇ Jah
32 ᦇ Cham
33 ᦇ Zod
40 / 15: generally, IAS or max should be followed here, Represents 40 ed / 15ias or 40 ed / 15max damage
ar: attack hit rate
as: attack speed
ds: critical strike attribute
CB: decisive strike
Kb: repel
ow: wound
MF: chance to obtain magic items, It generally refers to a kind of behavior
CBF: not frozen attribute
FHR: fast recovery strike
FCR: fast casting spell
MDR: rece magic damage
ITD: ignore target defense
IAS: increase fast attack speed
eth: irreparable disposable items
FRW: fast moving / running attribute
req: equipment requirements of items, generally including strong, Agility, rank, etc.
icob: increase the probability of resistance
leech: blood sucking / sucking magic power / experience value
pe: perfect emerald
pr: perfect ruby
pd: perfect white diamond
wmpg: perfect gem
Cr: anti ice
fr: fire prevention
LR: anti electricity
PR: anti poison
CD: ice damage
FD: fire damage
LD: electric damage
PD: poison damage
MD: magic damage
res: resistance (four defenses)
def: Defense
dam: damage, DMG in the same way
Dr: rece physical damage, which is commonly known as Wumian
ed: increase damage, or enhance defense
BC: the most commonly refers to the small amulet that increases the probability of magic equipment occurrence by 6%, and another means idiot...
SC: small amulet, generally refers to the small Amulet of 7% MF, Common currency
LC: large amulet
GC: super large amulet
b & # 39; SC: the SC dropped by Baal, because of its high level, can wash out better attributes
n & # 39; SC: the SC dropped by niserak, because of its high level, can wash out better attributes
PDSC: a small talisman to increase poison damage, It generally refers to the small Amulet of 100 poison damage
LGC + 1 mage's super large Amulet of electricity skill
CB: giant God's blade
CS: giant God's sword
Pb: Magic blade
MS: secret instrument's sword
SS: Assassin's close cut
amu: necklace, amulet, and the same meaning is Amy, XL
wbow: bow of shelter
bow: bow of matriarch
Gris: Griswold & # 39; S Legacy Ranger essence set for short
cXXq: also cXXe, refers to the weapon with the cruel prefix and light / absorb the suffix. Generally speaking, these are the best
of the same kind of weapon. For example, ccbq, cwpq, CMSE, CSSE, cmbe and so on<
gmbow: generally refers to the bow in the Amazon suit
Lionheart: the language of the talisman lion heart
Fury: the language of the talisman fury
rhyme: the language of the talisman rhyme
White: the language of the talisman white, the wizard PK's good weapon
silence: the language of the talisman silence
smoke: the language of the talisman smoke
uni: dark gold items
GF: grandfather giant's blade, The best weapon of barbarian PVC
TT: dark gold Amazon javelin, also known as Titan
WF: wind power, dark gold nine headed snake bow; Water fish, mostly refers to players who don't understand the market
wt: boots of the battlefield
SOJ: stone of Jordan. The main currency in circulation of war net is
ear: string of ears, which is usually called Wumian belt, Another one is that PK people fall out of their ears
ire: usually refers to rother armor
Sun: rising sun
orb: eyeball or Witch skills
WMJ: Wu Mian armor
WMD: Wu Mian shield
WMK: Wu Mian helmet
game: usually refers to Wu Mian helmet
Room: Sword of dark gold champion
mesh: Wu Mian armor
Mara: Mara's Kaleidoscope Necklace
skin: each battle net has There are some differences, most of them refer to the dark gold flame skin plate armor, and some refer to the dark gold sea snake skin armor
Luna: one of the dark gold shields, which has the attribute of ice absorption
Star: dark gold devil meteor hammer
sash: Wumian belt
Dapao: people often say the cannon, Ballista / DP
bow: the bow of the dark gold Crusader
wmyd: Wumian belt
Raven: Crow
shako: dark gold cap, Junmao
Jordan: Jordan's stone ring
storm: Wumian shield, storm shield
bbface: array & 39; S face Slayer guard special dark gold helmet for barbarians
mallet: Schaefer & # 39; S hammer legendary mallet, the hand weapon of Ranger
Highlord: Highlord & 39; S wrath army's anger, also known as Dajun
Zakarum: dark gold Ranger special shield
Jew: jewel jewelry
JP: boutique, best
LJ: La Ji garbage
leg: leg. It's a must to open the cow level
IK: barbarian suit, short for Immortal King
tal: taraxia suit
naj: Witch suit
Nath: Assassin suit
sign: Xigang suit
laying: glove of disciple suit
mavina: short for Amazon mavina suit, or MVN
character skill class
this class generally has one characteristic, Abbreviations are all mastered by the first letter of each word of the skill, such as CN = = cold master witch's cold magic, AMZ
CS: Amazon's double strike skill
GA: Amazon's Guide arrow skill
LF: Amazon's lightning rage skill
MS: Amazon's row arrow skill
SM: Amazon's slow attack skill
Valk: Amazon's female warrior skill
ASN: assassin, As
cm: Assassin's claw mastery skill
DF: Assassin's dragon flying skill
LS: Assassin's lightning trap skill
MB: Assassin's shockwave skill
ts: Assassin's tiger strike skill
SM: Assassin's shadow master skill
cos: Assassin's phantom Cape skill
bar: barbarian, and BB, Ymr
Bo: barbarian fighting command skill
is: barbarian's steel skin skill
La: barbarian's jumping skill
NR: barbarian's natural resistance skill
SM: barbarian's sword mastery skill
ssbar: double sword barbarian or sword shield barbarian
dru: Druid
CA: Druid's storm armor skill
OS: Druid's Oak skill < br />Fury: Druid's rage skill
SOR: witch, There are also Sorc
es: Witch's energy shield skill
cm: Witch's ice mastery skill
FW: Witch's fire wall skill
LM: Witch's electricity mastery skill
TK: Witch's space taking skill
TP: Witch's blinking skill
ts: Witch's thundercloud skill
SF: Witch's electrostatic field skill
Hydra: Witch's Hydra skill
metal R: Witch's meteorite skill
pal: Ranger, as well as Pala, ally, xxdin
HF: Ranger's holy knot skill
HS: Ranger's Holy Shield skill
con: Ranger's concentrated aura skill, Conc is the same as
FOH: Ranger's heaven fist skill
ven: Ranger's Revenge skill
conv: Ranger's trial aura skill
NEC: Wizard, Similarly, Necro
BW: bone wall skill of wizard
Ce: Corpse Explosion skill of wizard
GM: puppet master skill of wizard
PN: poison Star Skill of wizard
Ig: Iron puppet skill of wizard
Im: iron virgin skill of wizard
LR: resistance rection skill of wizard
amp: damage enhancement skill of wizard
Dec: aging skill of wizard
br/ >
STR: strong
vit: vigor
Eng: energy
DEX: Agility
HP: life value
MP: Mana value
common words class
communication in the game has formed a unique culture. Understanding common phrases is the beginning of integrating into this culture...
=: etc.
b: Baal, the last leader
1: in the process of leading people, If the number is 2, it means danger
5T: five groups of enemies in front of Baal
88: goodbye, many of the same, such as BB, bye, 886, etc.
x #: X is the number in the middle of 1-33, which means the X talisman
BD: in the forum, this word generally means helping the top, BT: pervert
ah: Diablo
3Q: Thank you. There are many more, such as thx, XX, thax, 3x, etc.
4242: Yes, yes
555 ~ ~: cry
ACC: account name
Max: maximum damage
Min: minimum damage
x H: X is a number of 1-2, which means several weapons, For example, 1 h stands for one handed weapon
x s: x stands for the number of 1-6, which means several hole weapon, for example, 6 s stands for six hole weapon
bug: Game vulnerability
ban: account blocked by administrator
BBS: Forum
btw: by the way
char: role
cow: cattle farm
Cr: Game establishment
BRB: replacement, Please wait for me.
Cu: Goodbye
CW: colour wolf, ha ha
DD: things
ds: how much? Used in general transactions; Or "on the ground" means
al: double suction
El: el. It is equivalent to PK
en: Um
exp: experience value
fant: inverted, dizzy, or ft
GG: elder brother
JJ: elder sister
GX: congratulations:)
Hell: Hell difficulty
I C: I see
C / C: room name = China, password = China, Chinese players' home court
J / J: room name = Japan, password = Japan, game room name, Japanese players home
k / K: room name = Korea, password = Korea, game room name, Korean players home
JS: J business
KX: for example, KC / KP / km / KB, main activities of battle. Net, KC = kill cattle; KP = kill the first
jinguai after entering the Red Gate in the fifth scene; Km = kill memphisto; KB = kill bar
CK: ox king, key protection object
lag: network delay, generally means slow network speed
lol: laugh, many other similar ^ o ^, - O --_- And so on
LV: level, level
me 2: me too
mm: sister, Meimei, female player
mod: equipment attribute or alternative mode
n: many kinds of meaning, next game; NO Game room name
newbie: new person
PT: ordinary difficulty; In the forum refers to cheat paste
nm: Nightmare difficulty
dy: Hell difficulty
nor: ordinary difficulty
NP: 1: no problem; 2: Abbreviations of game name and password, such as NP? It means to ask you the name and password of the game
NR = NT: common terms of UW server transaction,
I'm afraid the most troublesome thing for newcomers is not the level gap, but the confusion in the face of full screen terms. Here are some of the most common abbreviations, hoping to help you on the road of battle. Net< The category of items and equipment < br /
< br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < br / < each of the first-35\\< br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br > < br / < br > < br / < br# shael
14 # dol
15 # hel
16 # IO
17 # lum
18 # Ko
19 # fal
20 # LEM
21 # pul
22 # um
2 3 ᦇ mal
24 ᦇ ist
25 ᦇ Gul
26 ᦇ vex
27 ᦇ ohm
28 ᦇ Lo
29 ᦇ sur
30 ᦇ BER
31 ᦇ Jah
32 ᦇ Cham
33 ᦇ Zod
40 / 15: generally, IAS or max should be followed here, Represents 40 ed / 15ias or 40 ed / 15max damage
ar: attack hit rate
as: attack speed
ds: critical strike attribute
CB: decisive strike
Kb: repel
ow: wound
MF: chance to obtain magic items, It generally refers to a kind of behavior
CBF: not frozen attribute
FHR: fast recovery strike
FCR: fast casting spell
MDR: rece magic damage
ITD: ignore target defense
IAS: increase fast attack speed
eth: irreparable disposable items
FRW: fast moving / running attribute
req: equipment requirements of items, generally including strong, Agility, rank, etc.
icob: increase the probability of resistance
leech: blood sucking / sucking magic power / experience value
pe: perfect emerald
pr: perfect ruby
pd: perfect white diamond
wmpg: perfect gem
Cr: anti ice
fr: fire prevention
LR: anti electricity
PR: anti poison
CD: ice damage
FD: fire damage
LD: electric damage
PD: poison damage
MD: magic damage
res: resistance (four defenses)
def: Defense
dam: damage, DMG in the same way
Dr: rece physical damage, which is commonly known as Wumian
ed: increase damage, or enhance defense
BC: the most commonly refers to the small amulet that increases the probability of magic equipment occurrence by 6%, and another means idiot...
SC: small amulet, generally refers to the small Amulet of 7% MF, Common currency
LC: large amulet
GC: super large amulet
b & # 39; SC: the SC dropped by Baal, because of its high level, can wash out better attributes
n & # 39; SC: the SC dropped by niserak, because of its high level, can wash out better attributes
PDSC: a small talisman to increase poison damage, It generally refers to the small Amulet of 100 poison damage
LGC + 1 mage's super large Amulet of electricity skill
CB: giant God's blade
CS: giant God's sword
Pb: Magic blade
MS: secret instrument's sword
SS: Assassin's close cut
amu: necklace, amulet, and the same meaning is Amy, XL
wbow: bow of shelter
bow: bow of matriarch
Gris: Griswold & # 39; S Legacy Ranger essence set for short
cXXq: also cXXe, refers to the weapon with the cruel prefix and light / absorb the suffix. Generally speaking, these are the best
of the same kind of weapon. For example, ccbq, cwpq, CMSE, CSSE, cmbe and so on<
gmbow: generally refers to the bow in the Amazon suit
Lionheart: the language of the talisman lion heart
Fury: the language of the talisman fury
rhyme: the language of the talisman rhyme
White: the language of the talisman white, the wizard PK's good weapon
silence: the language of the talisman silence
smoke: the language of the talisman smoke
uni: dark gold items
GF: grandfather giant's blade, The best weapon of barbarian PVC
TT: dark gold Amazon javelin, also known as Titan
WF: wind power, dark gold nine headed snake bow; Water fish, mostly refers to players who don't understand the market
wt: boots of the battlefield
SOJ: stone of Jordan. The main currency in circulation of war net is
ear: string of ears, which is usually called Wumian belt, Another one is that PK people fall out of their ears
ire: usually refers to rother armor
Sun: rising sun
orb: eyeball or Witch skills
WMJ: Wu Mian armor
WMD: Wu Mian shield
WMK: Wu Mian helmet
game: usually refers to Wu Mian helmet
Room: Sword of dark gold champion
mesh: Wu Mian armor
Mara: Mara's Kaleidoscope Necklace
skin: each battle net has There are some differences, most of them refer to the dark gold flame skin plate armor, and some refer to the dark gold sea snake skin armor
Luna: one of the dark gold shields, which has the attribute of ice absorption
Star: dark gold devil meteor hammer
sash: Wumian belt
Dapao: people often say the cannon, Ballista / DP
bow: the bow of the dark gold Crusader
wmyd: Wumian belt
Raven: Crow
shako: dark gold cap, Junmao
Jordan: Jordan's stone ring
storm: Wumian shield, storm shield
bbface: array & 39; S face Slayer guard special dark gold helmet for barbarians
mallet: Schaefer & # 39; S hammer legendary mallet, the hand weapon of Ranger
Highlord: Highlord & 39; S wrath army's anger, also known as Dajun
Zakarum: dark gold Ranger special shield
Jew: jewel jewelry
JP: boutique, best
LJ: La Ji garbage
leg: leg. It's a must to open the cow level
IK: barbarian suit, short for Immortal King
tal: taraxia suit
naj: Witch suit
Nath: Assassin suit
sign: Xigang suit
laying: glove of disciple suit
mavina: short for Amazon mavina suit, or MVN
character skill class
this class generally has one characteristic, Abbreviations are all mastered by the first letter of each word of the skill, such as CN = = cold master witch's cold magic, AMZ
CS: Amazon's double strike skill
GA: Amazon's Guide arrow skill
LF: Amazon's lightning rage skill
MS: Amazon's row arrow skill
SM: Amazon's slow attack skill
Valk: Amazon's female warrior skill
ASN: assassin, As
cm: Assassin's claw mastery skill
DF: Assassin's dragon flying skill
LS: Assassin's lightning trap skill
MB: Assassin's shockwave skill
ts: Assassin's tiger strike skill
SM: Assassin's shadow master skill
cos: Assassin's phantom Cape skill
bar: barbarian, and BB, Ymr
Bo: barbarian fighting command skill
is: barbarian's steel skin skill
La: barbarian's jumping skill
NR: barbarian's natural resistance skill
SM: barbarian's sword mastery skill
ssbar: double sword barbarian or sword shield barbarian
dru: Druid
CA: Druid's storm armor skill
OS: Druid's Oak skill < br />Fury: Druid's rage skill
SOR: witch, There are also Sorc
es: Witch's energy shield skill
cm: Witch's ice mastery skill
FW: Witch's fire wall skill
LM: Witch's electricity mastery skill
TK: Witch's space taking skill
TP: Witch's blinking skill
ts: Witch's thundercloud skill
SF: Witch's electrostatic field skill
Hydra: Witch's Hydra skill
metal R: Witch's meteorite skill
pal: Ranger, as well as Pala, ally, xxdin
HF: Ranger's holy knot skill
HS: Ranger's Holy Shield skill
con: Ranger's concentrated aura skill, Conc is the same as
FOH: Ranger's heaven fist skill
ven: Ranger's Revenge skill
conv: Ranger's trial aura skill
NEC: Wizard, Similarly, Necro
BW: bone wall skill of wizard
Ce: Corpse Explosion skill of wizard
GM: puppet master skill of wizard
PN: poison Star Skill of wizard
Ig: Iron puppet skill of wizard
Im: iron virgin skill of wizard
LR: resistance rection skill of wizard
amp: damage enhancement skill of wizard
Dec: aging skill of wizard
br/ >
STR: strong
vit: vigor
Eng: energy
DEX: Agility
HP: life value
MP: Mana value
common words class
communication in the game has formed a unique culture. Understanding common phrases is the beginning of integrating into this culture...
=: etc.
b: Baal, the last leader
1: in the process of leading people, If the number is 2, it means danger
5T: five groups of enemies in front of Baal
88: goodbye, many of the same, such as BB, bye, 886, etc.
x #: X is the number in the middle of 1-33, which means the X talisman
BD: in the forum, this word generally means helping the top, BT: pervert
ah: Diablo
3Q: Thank you. There are many more, such as thx, XX, thax, 3x, etc.
4242: Yes, yes
555 ~ ~: cry
ACC: account name
Max: maximum damage
Min: minimum damage
x H: X is a number of 1-2, which means several weapons, For example, 1 h stands for one handed weapon
x s: x stands for the number of 1-6, which means several hole weapon, for example, 6 s stands for six hole weapon
bug: Game vulnerability
ban: account blocked by administrator
BBS: Forum
btw: by the way
char: role
cow: cattle farm
Cr: Game establishment
BRB: replacement, Please wait for me.
Cu: Goodbye
CW: colour wolf, ha ha
DD: things
ds: how much? Used in general transactions; Or "on the ground" means
al: double suction
El: el. It is equivalent to PK
en: Um
exp: experience value
fant: inverted, dizzy, or ft
GG: elder brother
JJ: elder sister
GX: congratulations:)
Hell: Hell difficulty
I C: I see
C / C: room name = China, password = China, Chinese players' home court
J / J: room name = Japan, password = Japan, game room name, Japanese players home
k / K: room name = Korea, password = Korea, game room name, Korean players home
JS: J business
KX: for example, KC / KP / km / KB, main activities of battle. Net, KC = kill cattle; KP = kill the first
jinguai after entering the Red Gate in the fifth scene; Km = kill memphisto; KB = kill bar
CK: ox king, key protection object
lag: network delay, generally means slow network speed
lol: laugh, many other similar ^ o ^, - O --_- And so on
LV: level, level
me 2: me too
mm: sister, Meimei, female player
mod: equipment attribute or alternative mode
n: many kinds of meaning, next game; NO Game room name
newbie: new person
PT: ordinary difficulty; In the forum refers to cheat paste
nm: Nightmare difficulty
dy: Hell difficulty
nor: ordinary difficulty
NP: 1: no problem; 2: Abbreviations of game name and password, such as NP? It means to ask you the name and password of the game
NR = NT: common terms of UW server transaction,
7. Excel function
database and list management function
daverage returns the average value of selected database items
dcounta calculates the number of cells containing numbers in the database
dcounta calculates the number of non empty cells in the database
dget extracts a single record satisfying specified conditions from the database
Dmax returns the maximum value of selected database items
Dmin returns the minimum value of the selected database item
dpproct multiplied by the value in a specific field (the records in this field are the records that meet the specified conditions in the database)
dstdev estimates the standard deviation according to the example of the selected item in the database
dstdevp calculates the standard deviation according to the sample population of the selected item in the database
dsum calculates the standard deviation for the items that meet the specified conditions in the database The sum of the numbers in the field column of the records in the database
Dvar estimates the variance according to the example of the selected items in the database
dvarp calculates the variance according to the sample population of the selected items in the database
getviewdata returns the data stored in the PivotTable
date and time function
date returns the series number of a specific time
datedif calculates the variance between two dates Year, month Days
DateValue converts a date in text format to a series number
day converts a series number to a day in a month
Days360 calculates the number of days between two dates by 360 days per year
edate returns the series number of a date before or after the specified number of months
eomonth returns the series number of the last day of a month before or after the specified number of months Number of columns
hour converts the number of series to hours
minute converts the number of series to minutes
month converts the number of series to months
networkdays returns the complete number of working days between two dates
now returns the number of series of the current date and time
second converts the number of series to seconds
time returns the number of series of a specific time
time Time in this format is converted to series number
today returns the series number of the current day
weekday converts the series number to week
workday returns the series number of a certain date before or after the specified number of working days
year converts the series number to year
YearFrac returns the representative start_ Date and end_ The number of days in years between date
DDE and external functions
call the procere in DLL or code source
register.id returns the registration ID of the registered specified DLL or code source
sql.request connects to the external data source, runs the query from the worksheet, and then returns the result as an array, Without macro programming< Other information about call and register functions
engineering functions
besseli returns the modified Bessel function in (x)
besselj returns the modified Bessel function jn (x)
besselk returns the modified Bessel function kn (x)
bessely returns the Bessel function yn (x)
xlfctbin2dec BIN2DEC converts binary numbers to decimal numbers
bin2hex Convert binary numbers to hexadecimal numbers
bin2oct convert binary numbers to octal numbers
complex convert real and imaginary coefficients to complex numbers
Convert numbers in one measurement system to another
DEC2BIN convert decimal numbers to binary numbers
DEC2HEX convert decimal numbers to hexadecimal numbers
de C2oct converts decimal number to octal number
delta detects whether two values are equal
ERF returns error function
erfc returns co error function
gestep detects whether the number is greater than a certain threshold
HEX2BIN converts hexadecimal number to binary number
HEX2DEC converts hexadecimal number to decimal number
hex2oct converts hexadecimal number to decimal number Change to octal number
imabs returns the absolute value (molus) of complex number
imaginary returns the imaginary coefficient of complex number
imaginary returns the parameter theta, An angle in radians
imconjugate returns the conjugate complex of a complex number
imcos returns the cosine of the complex number
imdiv returns the quotient of two complex numbers
imexp returns the exponent of the complex number
imln returns the natural logarithm of the complex number
imlog10 returns the common logarithm of the complex number
imlog2 returns the logarithm of the base 2 of the complex number
impower returns the complex number Improct returns the proct of two complex numbers
imreal returns the real coefficient of complex numbers
imsin returns the sine of complex numbers
imsqrt returns the square root of complex numbers
imsub returns the difference of two complex numbers
imsum returns the sum of two complex numbers
OCT2BIN converts octal numbers to binary numbers
oct2dec converts octal numbers to decimal numbers Number
OCT2HEX converts octal number to hexadecimal number
financial function
accord returns the accrued interest of fixed-term interest paying securities
ACCRINTM returns the accrued interest of e one-time interest paying securities
AmorDEGRC returns the depreciation value of each accounting period
AmorLINC returns the depreciation value of each accounting period
CoupDayBS returns the current value The number of days in the interest payment period up to the transaction date
CoupDays returns the number of days in the interest payment period of the transaction date
CoupDaysNC returns the number of days from the transaction date to the next interest payment date
coupncd returns the date of the next interest payment date after the transaction date
coupnum returns the number of interest payable times between the transaction date and the maturity date
couppcd returns the previous interest payment date before the transaction date The date of the interest payment date
cumipmt returns the accumulated amount of interest repaid between two periods
cumprinc returns the accumulated amount of principal repaid between two periods
DB returns the depreciation value of an asset in a specified period by using the declining fixed balance method
DDB uses the double declining balance method or other specified methods, Returns the depreciation value of an asset in a specified period
disc returns the discount rate of the security
Dollard converts the price expressed by fraction to the price expressed by fraction
dollarfr converts the price expressed by fraction to the price expressed by fraction
ration returns the correction period of the fixed-term interest paying security
effect returns the actual annual interest rate FV returns the future value of the investment
fvschele returns the future value of the principal based on a series of compound interests
internal returns the interest rate of the one-time interest bearing securities
IPMT returns the interest repayment amount of the investment in a fixed period
IRR returns the internal rate of return of a group of cash flows
ispmt calculates the interest paid in a specific period of the investment
MDuration returns the hypothetical surface The Macauley correction period of a security with a value of $100
mirr returns the positive and negative cash flows, and uses the modified internal rate of return with different interest rates
nominal returns the nominal annual interest rate
NPER returns the number of investment periods
NPV is based on a series of cash flows and a fixed discount rate for each period, Returns the net present value of an investment
oddprice returns the price of a security with a face value of $100 that is not fixed on the down payment date
oddfield returns the yield of a security with a face value of $100 that is not fixed on the down payment date
oddprice returns the price of a security with a face value of $100 that is not fixed on the end payment date
oddfield returns the yield of a security with a face value of $100 that is not fixed on the end payment date Interest rate
PMT returns the amount of each payment of the investment or loan
PPMT returns the principal repayment of the investment in a given period
price returns the price of the $100 face value security with regular interest payment
pricesisc returns the price of the $100 face value security issued at discount
PriceMat returns the price of the $100 face value security with interest payment e < br/ >PV returns the present value of investment
rate returns the interest rate of annuity in each period
received returns the amount of securities with one-time interest payment e
SLN returns the straight-line depreciation cost of an asset in each period
Syd returns the depreciation value of an asset in a certain period calculated by the sum of years depreciation method
tbilleq returns the equivalent yield of treasury bonds
tbillpric E returns the price of treasury bills with a face value of $100
tbillyield returns the yield of treasury bills
VDB uses the declining balance method, Return the depreciation amount of assets in a specified period or a certain period of time
XIRR returns the internal rate of return of a group of irregular cash flows
xnpv returns the net present value of a group of irregular cash flows
yield returns the rate of return of regular interest bearing securities
YieldDisc returns the annual rate of return of discount issued securities, For example: Treasury bonds
YieldMat returns the annual yield of the securities with interest e
information function
cell returns the relevant cell format Location or content information
countblank calculates the number of empty cells in the range
error.type returns the number corresponding to the error type
info returns information about the current operating environment
isblank returns true if the value is empty
iserr returns true if the value is an error value other than # n / A
ISERROR returns true if the value is any error value
iseven returns true if the number is even
islogical returns true if the value is logical
ISNA returns true if the value is # n / a error
isn text returns true if the value is not text
isnumber returns true if the value is a number
Isodd returns true if the number is odd
isref returns true if the value is a reference
istext returns true if the value is text
n returns the value converted to a number
Na returns the error value # n / a
xlfcttype type returns the number representing the data type of the value
logical function
and if all parameters are true, Then return true
false returns the logical value false
If specifies the logical detection to be performed
not reverses the logical value of the parameter
or if any parameter is true, Then return true
true returns the logical value true
lookup and reference function
address returns the reference to a single cell in the worksheet in text form
areas returns the number of ranges in the reference
choose a value from the list of values
column returns the column number of the reference
columns returns the number of columns in the reference
lookup the top of the array Line and return the value of the indicator cell
hyperlink creates a shortcut or jump to open the Document on intranet or Internet
index uses index to select value from reference or array
direct returns reference represented by text value
lookup finds value in vector or array
match finds value in reference or array
offset returns reference offset from given reference
row returns line number of reference
rows returns reference The number of rows in
transpose returns the transpose of the array
vlookup finds the first column of the array and moves the row, Then return the cell value
mathematics and trigonometric function
absolute value of ABS return number
arccosine of ACOS return number
arccosine of acosh return number
arcsine of asin return number
arcsine of asinh return number
arcsine of atan return number
database and list management function
daverage returns the average value of selected database items
dcounta calculates the number of cells containing numbers in the database
dcounta calculates the number of non empty cells in the database
dget extracts a single record satisfying specified conditions from the database
Dmax returns the maximum value of selected database items
Dmin returns the minimum value of the selected database item
dpproct multiplied by the value in a specific field (the records in this field are the records that meet the specified conditions in the database)
dstdev estimates the standard deviation according to the example of the selected item in the database
dstdevp calculates the standard deviation according to the sample population of the selected item in the database
dsum calculates the standard deviation for the items that meet the specified conditions in the database The sum of the numbers in the field column of the records in the database
Dvar estimates the variance according to the example of the selected items in the database
dvarp calculates the variance according to the sample population of the selected items in the database
getviewdata returns the data stored in the PivotTable
date and time function
date returns the series number of a specific time
datedif calculates the variance between two dates Year, month Days
DateValue converts a date in text format to a series number
day converts a series number to a day in a month
Days360 calculates the number of days between two dates by 360 days per year
edate returns the series number of a date before or after the specified number of months
eomonth returns the series number of the last day of a month before or after the specified number of months Number of columns
hour converts the number of series to hours
minute converts the number of series to minutes
month converts the number of series to months
networkdays returns the complete number of working days between two dates
now returns the number of series of the current date and time
second converts the number of series to seconds
time returns the number of series of a specific time
time Time in this format is converted to series number
today returns the series number of the current day
weekday converts the series number to week
workday returns the series number of a certain date before or after the specified number of working days
year converts the series number to year
YearFrac returns the representative start_ Date and end_ The number of days in years between date
DDE and external functions
call the procere in DLL or code source
register.id returns the registration ID of the registered specified DLL or code source
sql.request connects to the external data source, runs the query from the worksheet, and then returns the result as an array, Without macro programming< Other information about call and register functions
engineering functions
besseli returns the modified Bessel function in (x)
besselj returns the modified Bessel function jn (x)
besselk returns the modified Bessel function kn (x)
bessely returns the Bessel function yn (x)
xlfctbin2dec BIN2DEC converts binary numbers to decimal numbers
bin2hex Convert binary numbers to hexadecimal numbers
bin2oct convert binary numbers to octal numbers
complex convert real and imaginary coefficients to complex numbers
Convert numbers in one measurement system to another
DEC2BIN convert decimal numbers to binary numbers
DEC2HEX convert decimal numbers to hexadecimal numbers
de C2oct converts decimal number to octal number
delta detects whether two values are equal
ERF returns error function
erfc returns co error function
gestep detects whether the number is greater than a certain threshold
HEX2BIN converts hexadecimal number to binary number
HEX2DEC converts hexadecimal number to decimal number
hex2oct converts hexadecimal number to decimal number Change to octal number
imabs returns the absolute value (molus) of complex number
imaginary returns the imaginary coefficient of complex number
imaginary returns the parameter theta, An angle in radians
imconjugate returns the conjugate complex of a complex number
imcos returns the cosine of the complex number
imdiv returns the quotient of two complex numbers
imexp returns the exponent of the complex number
imln returns the natural logarithm of the complex number
imlog10 returns the common logarithm of the complex number
imlog2 returns the logarithm of the base 2 of the complex number
impower returns the complex number Improct returns the proct of two complex numbers
imreal returns the real coefficient of complex numbers
imsin returns the sine of complex numbers
imsqrt returns the square root of complex numbers
imsub returns the difference of two complex numbers
imsum returns the sum of two complex numbers
OCT2BIN converts octal numbers to binary numbers
oct2dec converts octal numbers to decimal numbers Number
OCT2HEX converts octal number to hexadecimal number
financial function
accord returns the accrued interest of fixed-term interest paying securities
ACCRINTM returns the accrued interest of e one-time interest paying securities
AmorDEGRC returns the depreciation value of each accounting period
AmorLINC returns the depreciation value of each accounting period
CoupDayBS returns the current value The number of days in the interest payment period up to the transaction date
CoupDays returns the number of days in the interest payment period of the transaction date
CoupDaysNC returns the number of days from the transaction date to the next interest payment date
coupncd returns the date of the next interest payment date after the transaction date
coupnum returns the number of interest payable times between the transaction date and the maturity date
couppcd returns the previous interest payment date before the transaction date The date of the interest payment date
cumipmt returns the accumulated amount of interest repaid between two periods
cumprinc returns the accumulated amount of principal repaid between two periods
DB returns the depreciation value of an asset in a specified period by using the declining fixed balance method
DDB uses the double declining balance method or other specified methods, Returns the depreciation value of an asset in a specified period
disc returns the discount rate of the security
Dollard converts the price expressed by fraction to the price expressed by fraction
dollarfr converts the price expressed by fraction to the price expressed by fraction
ration returns the correction period of the fixed-term interest paying security
effect returns the actual annual interest rate FV returns the future value of the investment
fvschele returns the future value of the principal based on a series of compound interests
internal returns the interest rate of the one-time interest bearing securities
IPMT returns the interest repayment amount of the investment in a fixed period
IRR returns the internal rate of return of a group of cash flows
ispmt calculates the interest paid in a specific period of the investment
MDuration returns the hypothetical surface The Macauley correction period of a security with a value of $100
mirr returns the positive and negative cash flows, and uses the modified internal rate of return with different interest rates
nominal returns the nominal annual interest rate
NPER returns the number of investment periods
NPV is based on a series of cash flows and a fixed discount rate for each period, Returns the net present value of an investment
oddprice returns the price of a security with a face value of $100 that is not fixed on the down payment date
oddfield returns the yield of a security with a face value of $100 that is not fixed on the down payment date
oddprice returns the price of a security with a face value of $100 that is not fixed on the end payment date
oddfield returns the yield of a security with a face value of $100 that is not fixed on the end payment date Interest rate
PMT returns the amount of each payment of the investment or loan
PPMT returns the principal repayment of the investment in a given period
price returns the price of the $100 face value security with regular interest payment
pricesisc returns the price of the $100 face value security issued at discount
PriceMat returns the price of the $100 face value security with interest payment e < br/ >PV returns the present value of investment
rate returns the interest rate of annuity in each period
received returns the amount of securities with one-time interest payment e
SLN returns the straight-line depreciation cost of an asset in each period
Syd returns the depreciation value of an asset in a certain period calculated by the sum of years depreciation method
tbilleq returns the equivalent yield of treasury bonds
tbillpric E returns the price of treasury bills with a face value of $100
tbillyield returns the yield of treasury bills
VDB uses the declining balance method, Return the depreciation amount of assets in a specified period or a certain period of time
XIRR returns the internal rate of return of a group of irregular cash flows
xnpv returns the net present value of a group of irregular cash flows
yield returns the rate of return of regular interest bearing securities
YieldDisc returns the annual rate of return of discount issued securities, For example: Treasury bonds
YieldMat returns the annual yield of the securities with interest e
information function
cell returns the relevant cell format Location or content information
countblank calculates the number of empty cells in the range
error.type returns the number corresponding to the error type
info returns information about the current operating environment
isblank returns true if the value is empty
iserr returns true if the value is an error value other than # n / A
ISERROR returns true if the value is any error value
iseven returns true if the number is even
islogical returns true if the value is logical
ISNA returns true if the value is # n / a error
isn text returns true if the value is not text
isnumber returns true if the value is a number
Isodd returns true if the number is odd
isref returns true if the value is a reference
istext returns true if the value is text
n returns the value converted to a number
Na returns the error value # n / a
xlfcttype type returns the number representing the data type of the value
logical function
and if all parameters are true, Then return true
false returns the logical value false
If specifies the logical detection to be performed
not reverses the logical value of the parameter
or if any parameter is true, Then return true
true returns the logical value true
lookup and reference function
address returns the reference to a single cell in the worksheet in text form
areas returns the number of ranges in the reference
choose a value from the list of values
column returns the column number of the reference
columns returns the number of columns in the reference
lookup the top of the array Line and return the value of the indicator cell
hyperlink creates a shortcut or jump to open the Document on intranet or Internet
index uses index to select value from reference or array
direct returns reference represented by text value
lookup finds value in vector or array
match finds value in reference or array
offset returns reference offset from given reference
row returns line number of reference
rows returns reference The number of rows in
transpose returns the transpose of the array
vlookup finds the first column of the array and moves the row, Then return the cell value
mathematics and trigonometric function
absolute value of ABS return number
arccosine of ACOS return number
arccosine of acosh return number
arcsine of asin return number
arcsine of asinh return number
arcsine of atan return number
8. This is the name of the English version of the rune
for example & quot; Amn" It's the Chinese version & quot; Am & quot; This Rune
& quot# 8" Most runes have only one level
for example & quot; Amn" It's the Chinese version & quot; Am & quot; This Rune
& quot# 8" Most runes have only one level
9. Excel function Daquan database and inventory management function daverage return the average value of the selected database item dcount calculate the number of cells containing numbers in the database dcounta calculate the number of non empty cells in the database dget extract a single record that meets the specified conditions from the database Dmax return the maximum value in the selected database item Dmin return the latest value in the selected database item The small value dpproct is multiplied by the value in a specific field (the records in this field are the records meeting the specified conditions in the database). Dstdev estimates the standard deviation according to the examples of the selected items in the database. Dstdevp calculates the standard deviation according to the sample population of the selected items in the database. Dsum sums the numbers in the field column of the records meeting the conditions in the database. Dvar calculates the standard deviation according to the selected items in the database Dvarp calculates the variance according to the sample population of the selected items in the database. Getvalvotdata returns the date and time stored in the PivotTable. Date returns the series number of a specific time. Datedif calculates the year, month and time between two dates Days DateValue converts a date in text format to a series number Days360 converts a series number to a day in a month Days360 calculates the number of days between two dates by 360 days per year edate returns the series number of a date of a specified number of months before or after the start date eomonth returns the series number of the last day of a month before or after the specified number of months hour converts the series number to a small number Convert the number of series to minutes by hour minute convert the number of series to months networkdays return the complete number of working days between two dates now return the number of series of the current date and time second convert the number of series to seconds time return the number of series of a specific time TimeValue convert the time in text format today return the number of series of the current day weekday convert the number of series to minutes Workday returns the number of series on a date before or after the specified number of working days. Year converts the number of series to year. YearFrac returns start_ Date and end_ DDE and external function call call the procere register.id in DLL or code source to return the registered ID of the specified DLL or code source. Sql.request connects to the external data source, runs the query from the worksheet, and then returns the result as an array without macro programming. Other information about call and register functions engineering function besseli returns modified Bessel function in (x) besselj returns Bessel function jn (x) besselk returns modified Bessel function kn (x) bessely returns Bessel function yn (x) xlfctbin2dec BIN2DEC converts binary number to decimal number bin2hex converts binary number to hexadecimal number bin2oct Convert binary number to octal number complex convert real coefficient and virtual coefficient to complex convert number in one measurement unit system to another DEC2BIN convert decimal number to binary number DEC2HEX convert decimal number to hexadecimal number dec2oct convert decimal number to octal number delta detect whether two values are equal ERF return error Difference function erfc returns co error function gestep detects whether the number is greater than a certain threshold HEX2BIN converts hexadecimal number to binary number HEX2DEC converts hexadecimal number to decimal number hex2oct converts hexadecimal number to octal number imabs returns absolute value (molus) of complex number image returns imaginary coefficient of complex number image returns parameter theta, An angle in radians imconjugate returns the conjugate complex of a complex number imcos returns the cosine of a complex number imdiv returns the quotient of two complex numbers imexp returns the exponent of a complex number imln returns the natural logarithm of a complex number imlog10 returns the common logarithm of a complex number imlog2 returns the logarithm of a complex number based on 2 impower returns the integer power of a complex number improct returns the proct of two complex numbers imreal Return the real coefficient of complex number imsin return the sine of complex number imsqrt return the square root of complex number imsub return the difference between two complex numbers imsum return the sum of two complex numbers OCT2BIN convert octal number to binary number oct2dec convert octal number to decimal number OCT2HEX convert octal number to hexadecimal number financial function accept return the accrual of fixed-term interest bearing securities Interest ACCRINTM returns the accrued interest of the securities with one-time interest payment e AmorDEGRC returns the depreciation value of each accounting period AmorLINC returns the depreciation value of each accounting period CoupDayBS returns the number of days in the current interest payment period up to the transaction date CoupDays returns the number of days in the interest payment period of the transaction date CoupDaysNC returns the number of days from the transaction date to the next interest payment date coupncd returns Return the date of the next interest payment date after the transaction date coupnum return the number of interest payable between the transaction date and the maturity date couppcd return the date of the previous interest payment date before the transaction date cumipmt return the accumulated amount of interest repaid between two periods, Returns the depreciation value of an asset in a specified period. DDB uses the double declining balance method or other specified methods, Returns the depreciation value of an asset in a specified period disc returns the discount rate of the security dollarde converts the price expressed by fraction to the price expressed by fraction dollarfr converts the price expressed by fraction to the price expressed by fraction Based on a series of compound interest returns the future value of the principal internal returns the interest rate of the one-time interest bearing securities IPMT returns the interest repayment amount of the investment in a period IRR returns the internal rate of return of a group of cash flows ispmt calculates the interest paid in a specific period of the investment MDuration returns the Macauley modified term of the securities with the assumed face value of $100 mirr returns the use of positive and negative cash flows NPV is based on a series of cash flows and a fixed discount rate for each period, Returns the net present value of an investment. OddFPrice returns the price of a security with a face value of $100 and an unfixed down payment date. OddFYield returns the yield of a security with an unfixed down payment date. OddLPrice returns the price of a security with a face value of $100 and an unfixed end payment date. OddLYield returns the yield of a security with an unfixed end payment date. PMT returns the investment or loan PPMT returns the principal repayment amount of the investment in a given period price returns the price of the securities with a face value of $100 and regular interest payment pricesisc returns the price of the securities with a face value of $100 issued at discount PriceMat returns the price of the securities with a face value of $100 and e interest payment PV returns the present value of the investment rate rate rate returns the interest rate of each period of the annuity received Return the amount of securities with one-time interest payment at maturity SLN return the straight-line depreciation cost of an asset in each period Syd return the depreciation value of an asset in a period calculated by the sum of years depreciation method tbilleq return the equivalent yield of treasury bonds tbillprice return the price of treasury bonds with face value of $100 tbillyield return the yield of treasury bonds VDB use the decreasing balance method, Returns the depreciation amount of assets in a specified period or a certain period of time. XIRR returns the internal rate of return of a group of irregular cash flows. Xnpv returns the net present value of a group of irregular cash flows. Yield returns the rate of return of securities with regular interest payment. YieldDisc returns the annual rate of return of securities issued at discount, For example: Treasury YieldMat returns the information of the annual yield of the securities e for interest payment. The function cell returns the information about the format, location or content of the cells. Countblank calculates the number of empty cells in the region. Error.type returns the number corresponding to the error type. Info returns the information about the current operating environment. Isblank returns true if the value is empty. Iserr returns true if the value is an error value other than # n / A. ISERROR returns true if the value is any error value. Iseven returns true if the number is even. Islogical returns true if the value is logical. ISNA returns true if the value is # n / a error. Isnontext returns true if the value is not text. Isnumber returns true if the value is a number. Isodd returns true if the number is odd. Isref returns true if the value is a reference. Istext returns true if the value is text. N returns the value converted to a number Na returns the error value # n / a xlfcttype type returns the numeric logical function and representing the data type of the value. If all parameters are true, true false returns the logical value false if specifies the logical detection to be performed. Not reverses the logical value or of the parameter if any parameter is true, Then return true true return the logical value true find and reference function address returns a reference to a single cell in the worksheet as text area returns the number of ranges in the reference choose a value from the list of values column returns the column number of the reference columns returns the number of columns in the reference hlookup finds the top row of the array and returns the value indicating the cell hyperlink create shortcut Open the storage in the network server Index is used to select a value from a reference or array. Indirect returns a reference represented by a text value. Lookup finds a value in a vector or array. Match finds a value in a reference or array. Offset returns a reference offset from a given reference. Row returns the number of rows in the reference. Transfer returns the transpose vlooku of the array P finds the first column of the array and moves it over the row, Then return the absolute value of cells and trigonometric function ABS return number ACOS return number acosh return number anti hyperbolic cosine asin return number anti sinusoidal asinh return number anti hyperbolic sine atan return number arctangent atan2 return parameter anti hyperbolic tangent from X and Y coordinates Integer or the nearest multiple significant digits com bin returns the combination number of given number of objects cos the cosine of the returned number cosh the hyperbolic cosine of the returned number countif calculates the number of non empty cells in the region that meets the given conditions degrees converts radian to degree even rounds up the number to the nearest even integer exp returns the factorial factdo of the specified power of e fact return number Double returns the half factorial of the parameter number. Floor rounds the parameter number in the direction of decreasing the absolute value. GCD returns the greatest common divisor int and rounds the number down to the nearest integer. LCM returns the natural logarithm of the least common multiple ln returns the logarithm of the specified base of the log returns log10 returns the logarithm of the base of 10. Mdeterm returns the matrix determinant minverse returns the number of the array The inverse matrix of a group mmult returns the matrix proct of two arrays mod returns the remainder of the division of two numbers mround returns the value of the parameter rounded according to the specified cardinality multiple returns the polynomial of a group odd rounds the number to the nearest odd integer PI returns the pI value power of the returned number proct multiplies all the numbers given in the form of a parameter The integer part radius converts degrees to radians. Rand returns a random number between 0 and 1. Randbetween returns the specified number
10. 1.
E6=IF(J3=" A," 0,IF(J3=" B", 1000,IF(D6> 0,1000,0)))
2.
D6:D10,H6:H10[UNK]值
E6=IF(J3=" A," 0,IF(J3=" B", 1000,IF(D6> 0,1000,0)))
2.
D6:D10,H6:H10[UNK]值
Hot content