{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["基本运算符号","数组运算符","特殊符号","函数","注意事项"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"基本运算符号","index":0,"n_rows":8,"n_cols":16,"rows_kept":8,"flags":["formulas_cached_only"]}
[]
[null,"基本运算符","说明","视觉符号",null,"逻辑符","说明","视觉符号",null,"比较符","说明","视觉符号",null,"定义符","说明","视觉符号"]
[null,"+","加","＋",null,"&&","并且","and",null,"=","等于","＝",null,"_","下标","n"]
[null,"-","减","－",null,"||","或者","or",null,">","大于","＞"]
[null,"*","乘","×",null,"!","非","no",null,"<","小于","＜"]
[null,"/","除","÷",{"$nulls":5},">=","大于等于","≥"]
[null,"^","平方","n",{"$nulls":5},"<=","小于等于","≤"]
[null,"%","余数",{"$nulls":6},"!=","不等于","≠"]

{"sheet":"数组运算符","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[1,1,1,2],[1,4,1,5]],"flags":["formulas_cached_only"]}
[]
[null,"数组与数值运算",null,null,"数组与数组运算"]
[null,"运算符","说明",null,"运算符","说明"]
[null,"+","累加，数组的每一个成员都上以数值",null,"+","附加，对第一个数组的每个增加，然后置换到多位数组"]
[null,"-","累减，数组的每一个成员都减去数值",null,"-","附减"]
[null,"*","累乘，数组的每一个成员都乘以数值",null,"*","附乘"]
[null,"/","累除，数组的每一个成员都除以数值",null,"/","附除"]
[null,"^","累方，数组的每一个成员都求平方数",null,"^","附平方"]
[null,"%","累余，数组的每一个成员都求余数",null,"%","附余数"]
[]
[{"$nulls":4},"注释：","数组与数组运算时，返回多维数组"]
[null,"注释：","数组与数值运算时，返回数组"]
[]
[null,"举例","[2,3] - 1 = [1,2]",null,null,"[2,3] + [5,7] = [[7,8],[9,10]]"]
[null,null,"[[7,8],[9,10]] + 1 = [[8,9],[10,11]]",null,null,"[[7,8],[9,10]] + [1,2] = [[[8,9],[9,10]],[[10,11],[11,12]]]"]
[]
[null,"备注：","为确保运算时结果正确，数组运算最后执行，并且数组代数必须提前声明"]
[null,null,"理论上，数组的维度可以超过三维度，但是应当尽量避免超过三维运算，因为会给计算机带来较大的负载，且现实中三维运算已足够"]

{"sheet":"特殊符号","index":2,"n_rows":17,"n_cols":16,"rows_kept":17,"flags":["formulas_cached_only"]}
[]
[null,"特殊符","说明","变量名",null,"条件符","说明","变量名",null,"数位符","说明","变量名",null,"运算符","说明","变量名"]
[null,"△","根的判别式","delta",null,"∞","无穷","infinity",null,"％","百分号","percent",null,"∩","交集"]
[null,"↑","气化溢出",null,null,"∥","平行","parallel",null,"‰","千分号","permil",null,"∪","并集"]
[null,"↓","不溶性沉淀",null,null,"⊥","垂直",null,null,".","小数点","point",null,"×","差集"]
[null,"←",{"$nulls":3},"≡","恒等于",null,null,"π","圆周率","pi",null,"±","正负值"]
[null,"→","变化",null,null,"≌","全等",{"$nulls":6},"Σ","集合","array"]
[null,"∈","属于",{"$nulls":10},"√","根号"]
[null,"∫","积分",null,null,"单位符号","说明"]
[null,"∠","角",null,null,"l","长度"]
[null,"°","角度",null,null,"m","质量"]
[null,"℃","摄氏度",null,null,"n","物质的量"]
[null,"∵","因为",null,null,"mol","摩尔"]
[null,"∴","所以"]
[null,"Ω","欧姆"]
[null,"＋","正电"]
[null,"－","负电"]

{"sheet":"函数","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,6]],"flags":["formulas_cached_only"]}
[null,"函数型变量：是通过“$”加上函数名加“()”和代数、数字组成\n多个参数用“,”分隔 .例如：$cos(45)、$except(a,b)"]
[]
[null,"基本函数","说明",null,"数组函数","说明","作用"]
[null,"floot(x)","向下取整",null,"intersect(x,y)","交集，缩写in","获取数组中相同项"]
[null,"ceil(x)","向上取整",null,"union(x,y)","并集，缩写un","获取数组中的"]
[null,"round(x)","四舍舍入",null,"except(x,y)","差集，缩写ex"]
[null,"abs(x)","绝对值",null,"distinct(x)","去重，缩写di"]
[null,"exp(x)","指数",null,"factor(x)","取数组中最大公约数"]
[null,"log(x)","对数",null,"multiple(x)","取数组的最小公倍数"]
[null,"sqrt(x)","平方根",null,"sum(x)","取数组之和"]
[null,"pi(x)","Xπ",null,"min(x)","最小值"]
[null,"sin(x)","正弦",null,"max(x)","最大值"]
[null,"acos(x)","余弦",null,"col(arr,n)","取二维数组的第N列"]
[null,"tan(x)","正切",null,"row(arr,n)","取二维数组的第N行"]
[null,"acos(x)","反余弦值",null,"pos(arr,x,y)","取二维数组的第x行，第y列"]
[null,"asin(x)","反正弦",null,"pos(arr,x,y,z)","取三维数组的第x行，第y列，第z深度"]
[null,"atan(x)","反正切值",null,"descend(arr)","降维度，将多维数组变成一维，去除重复值","求符合条件的结果集"]
[null,"atan2(x)","反正切值2",null,"ascend(x,y,way)","升维度，将两个一维数组通过加减乘除变成二维数组","用于查看不同条件下的结果集"]
[]
[null,"数值函数","说明",null,"计算函数","说明"]
[null,"int(x)","取整数",null,"rand(x,y)","X到Y的随机数"]
[null,"random()","随机数",null,"mod(x,y)","取余数"]
[{"$nulls":4},"pow(x,n)","X的N次方"]

{"sheet":"注意事项","index":4,"n_rows":25,"n_cols":2,"rows_kept":25,"flags":["formulas_cached_only"]}
[]
[null,"\n注意事项：\n1. 在mm_maths中，中括号表示的是数组，如果需要中括号运算，则小括号括住小括号就是中括号，运算顺序是，先算最里面的括号，再算外面的括号\n2. 数学中的符号有200多个，为了避免程序运算时无法识别问题，凡非键盘可直接打出的符号直接用函数型变量表达。\n3. 在添加运算函数时，需要注意运算级别：level = 2， 越高等级越优先运算\n4. 在公式中，代数尽量使用小写字母表示，大写字母为公式符号，如果非要用大写字母，则需先做代数声明"]
[]
[null,"一个数组中的第N个数的y次方用x_n^y表示 例如：[0,2,4]_3^3 = 2^3 = 2 * 2 * 2 = 8;"]
[]
[]
[]
[null,"数组降维度：descend(arr)，例如：descend([[[8,9],[9,10]],[[10,11],[11,12]]]) 值为：[8,9,10,11,12]"]
{"$rows_empty":15}
[null,"Math.toSource()返回该对象的源代码。  "]
[null,"Math.valueOf() 返回 Math 对象的原始值。  "]