1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<!-- $Id: formulas-ja.htm,v 1.7 2005/01/09 11:26:30 jfontain Exp $ -->
<html lang=ja>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-jp">
<meta name="Author" content="Jean-Luc Fontaine">
<meta name="Editor" content="Kosei Kitahara">
<meta name="Description" content="user manual for formulas in moodss">
<title>moodss formulas</title>
</head>
<body bgcolor="#FFFFFF" style="font-family: helvetica, verdana, arial">
<center><h2>moodss (Modular Object Oriented Dynamic SpreadSheet)ο</h2></center>
<h3>ܼ:</h3>
<!-- beginning of contents -->
<ul>
<li><a href="#about">1. ʸϤˤĤ</a>
<li><a href="#expressions">2. </a><ul>
<li><a href="#expressions.operands">2.1. ڥ</a>
<li><a href="#expressions.operators">2.2. 黻</a>
<li><a href="#expressions.functions">2.3. ե</a>
<li><a href="#expressions.errors">2.4. 顼</a>
</ul>
<li><a href="#formatting">3. </a>
<li><a href="#advanced">4. ٤ʻˡ</a>
</ul>
<!-- end of contents -->
<h3><a name="about"></a>1. ʸϤˤĤ</h3>
<p>ʸϡmoodssץꥱǥɤ줿⥸塼Υǡ뤫뤿ΰŪȻ;ޤǤޤٺ줿ϡmoodssΰ̥ɥȤƤformulas tablesˤɽޤ
<br>ޤʸϡå黻ҡؿ鹽뼰ˤơѲǽʿޤ
<h3><a name="expressions"></a>2. </h3>
<p>moodssmoompsοϡ桼̾ȡǡǺ줿ŪŪ黻ҡؿ鹽ޤŪϿ濴ȤʤäƤޤ
<p>ϡڥɡʥǡ롢شؿġˡ黻ҡ+-ġˡӳ̤Ȥ߹碌鹽ޤڥɡ黻ҡ̤δ֤˥ڡѤޤη̤Ƿݤ̵뤵ޤ
<p>㤨СåȤϡԥ塼ǻѤƤΥԥ塼ΤѲǽʥdzꡢ̤100軻뤳Ȥˤäơ̤ΥѡȤ뤿Ѥ뼰Ǥ
<p><center><img src="formula1.gif" alt="basic memory usage expression"></center>
<p>Ϳ줿̤<b>0</b>Ǥºݤ˻ѤƤϴ餫ϤǤΤǡμˤԶ礬뤳Ȥ˵դޤϡηʰʲ<b></b>ȸƤ֡ˤڥɤͤȤƲᤷƤ뤫Ǥ
<br>Υξ硢˿Ƥ褦ˡڥɤΤ1ĤưѴ뤿ˡŪؿѤưΤ˾ޤǤ礦
<p><center><img src="formula2.gif" alt="floating-point memory usage expression"></center>
<p>ãϡ¿μСͽǤ
<h4><a name="expressions.operands"></a>2.1. ڥ</h4>
<p>⤷ڥɤ͡<b>123</b>ʤɤΡˤȤƲǽʤͤȤư졢¾ư͡<b>12.345</b>ʤɤΡˤȤưޤ
<br>ڥɤϡȤƥ桼ˤľϤ뤫ʾ嵭ΥåȤˤ<b>100</b>Τ褦ˡˡޤϥǡΤ褦ʤɤΥǤѤǤޤ<b>ѥ</b><b>Ѳǽ</b>ʤɡˡ
<p>ưΥڥǤѴɬפʾϼưŪ˼¹Ԥޤ黻ˤưϤޤѤθưѤޤ㤨С5/4η̤1Ǥ5/4.0η̤1.25ˤʤޤ
<br>ưͤȶ̤ɽ뤿ᡢ.ʥɥåȡˤޤeѤޤ㤨С20.0/5.0η̤ϡ4ǤϤʤ4.0Ǥ
<p>ڥɤϡ嵭η֤ͤ<b>double(127544)</b>ʤɤοشؿξ⤢ޤ(<a href="#expressions.functions">ؿ</a>)
<h4><a name="expressions.operators"></a>2.2. 黻</h4>
<p>ϲꥹȤ̤ͥ˽äɾޤ黻Ҥ̤ͥι⤤˾夫¤٤Ƥޤ<ul>
<li><b>- + ~ !</b> ñޥʥñץ饹ӥåȥ磻NOTNOTӥåȥ磻NOTˤΤŬѲǽ
<li><b>* / %</b> 軻;;ˤΤŬѲǽ̤Ͼ˽ƱǤꡢ⾮ͤǤ
<li><b>+ -</b> û
<li><b><< >></b> եȡեȡˤΤŬѲǽեȤϾ˼ݻޤ
<li><b>< > <= >=</b> 꾯ʤ礭꾯ʤ礭⤷郎1֤ʤ0֤ޤ
<li><b>== !=</b> ⤷郎1֤ʤ0֤ޤ
<li><b>&</b> ӥåȥ磻ANDڥɤˤΤŬѲǽ
<li><b>^</b> ӥåȥ磻XOR¾Ū¡ˡڥɤˤΤŬѲǽ
<li><b>|</b> ӥåȥ磻ORڥɤˤΤŬѲǽ
<li><b>&&</b> AND2ĤΥڥɤξȤ1ξ̤1ˤʤޤ֡ꥢޤưˤΥڥɤˤΤŬѲǽ
<li><b>||</b> OR2ĤΥڥɤΤɤ餫1ǤС̤1ˤʤޤ֡ꥢޤưˤΥڥɤˤΤŬѲǽ
</ul>
<h4><a name="expressions.functions"></a>2.3. ؿ</h4>
<p>̩˸СδؿͣΰȤƣĤΥǡ(moodss formulasե˥ɥåɥɥå)ɬפǤɻǡͤǤ̤֤ͤǽ뤿ᡢformulasΥåץǡȤκݤˡŪ˥ǡͤѤ뤿Ǥ<ul>
<li><b>delta(</b><i>cell</i><b>)</b> ǡθߤͤȡ<b></b>եκǽͤȤΰ㤤֤ޤ㤨,䤨ä³Ф餯ƺǽ32ӥåȥˤƻѤ䤨Τʰ㤤֤ޤ<b>int(</b><i>cell</i><b> - last(</b><i>cell</i><b>))</b>Ʊͤ͡
<li><b>diff(</b><i>cell</i><b>)</b> ǡθߤͤȡ٤<b>ư</b>եκǽͤȤΰ㤤֤ޤ <b>double(</b><i>cell</i><b> - last(</b><i>cell</i><b>))</b>Ʊͤ͡
<li><b>last(</b><i>cell</i><b>)</b> Ǹ˥åץǡȤΥǡ֤ͤޤ
</ul>
<p><i><b>Note</b>:ϡݡ֤ޤǤ褦ˡåܡɤեå夵̾拾moodssޤmoompsˤˤꥢåץǡȤޤΥåץǡȤϡǿλ֤ޤ줿ǡͤѤ뤳ȡӾˤäƤϼκǸΥåץǡȤλΥΤΤĤͤǼη̤ɾΤ̣Ƥޤʤ⤷<b>diff()</b><b>delta()</b>ޤ<b>last()</b>δؿѤˡ⤷ƱΥ⥸塼륤°Ƥ뤤餫ΥǡޤǤ硢ϡåܡɥեå졼ȡʥݡ֡ˤ̵طˡƱΥǡβͤѹ졢䤨åץǡȤޤʤޤɾޤˡɾ뤿ӤˡǸΥåץǡȻ֡<b>diff(time)</b>ȡˤͤޤ</i>
<p>åץǡȻ֤ΰ㤤֤̤ʴؿ⤢ޤ:<ul>
<li><b>diff(time)</b> ߤλ֤ȡ<b>ư</b>եκǸΥåץǡȻ֤Ȥú֤ޤ
㤨С"<b>diff(</b><i>cell</i><b>) / diff(time)</b>"ȤϡǡĹΨ֤ޤ
</ul>
<p>ʲοشؿݡȤƤޤδؿä˻ꤷʤ¤ưưޤ<ul>
<li><b>abs(</b><i>number</i><b>)</b> <i>number</i>֤ͤޤ<i>number</i>⤷ưǤꡢ̤ƱեޥåȤ֤ޤ
<li><b>acos(</b><i>number</i><b>)</b> <i>number</i>Υ[<i>-PI/2,PI/2</i>]ϰϤ֤ޤ<i>number</i>ϰϤ[<i>-1,1</i>]ǤʤФʤޤ
<li><b>asin(</b><i>number</i><b>)</b> <i>number</i>Υ[<i>-PI/2,PI/2</i>]ϰϤ֤ޤ<i>number</i>ϰϤ[<i>-1,1</i>]ǤʤФʤޤ
<li><b>atan(</b><i>number</i><b>)</b> <i>number</i>Υȡ[<i>-PI/2,PI/2</i>]ϰϤ֤ޤ
<li><b>atan2(</b><i>y,x</i><b>)</b> ɸ<i>y/x</i>줿饸ñ̤γ١ϰ[<i>-PI/2,PI/2</i>]֤ͤޤ<i>x</i><i>y</i><i>0</i>ǤϤޤ⤷<i>x</i><i>0</i>礭硢<b>atan(</b><i>y/x</i><b>)</b>
<li><b>ceil(</b><i>number</i><b>)</b> ư<i>number</i>ʾǺǾ֤ޤ
<li><b>cos(</b><i>number</i><b>)</b> <i>number</i>Υ饸֤ͤޤ
<li><b>cosh(</b><i>number</i><b>)</b> <i>number</i>ж;֤ͤޤ̤Хեϥ顼֤ޤ
<li><b>double(</b><i>number</i><b>)</b> ⤷<i>number</i>ưξϤ֤ͤǤʤ<i>number</i>ưѴ֤ͤޤ
<li><b>exp(</b><i>number</i><b>)</b> <i>number</i>ؿȤ<i>e</i>(п) ߾֤ޤ̤Хեϥ顼֤ޤ
<li><b>floor(</b><i>number</i><b>)</b> ư<i>number</i>ʲǺ֤ޤ
<li><b>fmod(</b><i>x,y</i><b>)</b> <i>x/y</i>ư;֤ޤ⤷<i>y</i><i>0</i>ξϥ顼֤ޤ
<li><b>hypot(</b><i>x,y</i><b>)</b> ľѻѷ<b>sqrt(</b><i>x*x+y*y</i><b>)</b>μդĹ֤ޤ
<li><b>int(</b><i>number</i><b>)</b> ⤷<i>number</i>ȤƱͤǤʤС<i>number</i>Ƭˤä<i>number</i>ʵ졢ʤ32ӥåȥƥ32ӥåȤƱ64ӥåȥƥ64ӥåȤδ֤Ρˤ˰äѴѴ줿ͤᤷޤ
<li><b>log(</b><i>number</i><b>)</b> <i>number</i>μп֤ޤ<i>number</i>ǤʤФʤޤ
<li><b>log10(</b><i>number</i><b>)</b> <i>10</i>Ȥ<i>number</i>п֤ޤ<i>number</i>ǤʤФʤޤ
<li><b>pow(</b><i>x,y</i><b>)</b> <i>y</i>ؿȤ<i>x</i>߾֤ޤ⤷<i>x</i>ξ硢<i>y</i>ǤʤФʤޤ
<li><b>round(</b><i>number</i><b>)</b> ⤷<i>number</i>ξϤ֤ͤǤʤ<i>number</i>˴ݤ֤ͤޤ
<li><b>sin(</b><i>number</i><b>)</b> <i>number</i>Υ饸<i></i>֤ͤޤ
<li><b>sinh(</b><i>number</i><b>)</b> <i>number</i>ж֤ͤޤ̤Хեϥ顼֤ޤ
<li><b>sqrt(</b><i>number</i><b>)</b> <i>number</i>ʿ֤ޤ<i>number</i>ǤäƤϤʤޤ
<li><b>tan(</b><i>number</i><b>)</b> <i>number</i>ΥȤ饸֤ͤޤ
<li><b>tanh(</b><i>number</i><b>)</b> <i>number</i>ж֤ͤޤ
<li><b>wide(</b><i>number</i><b>)</b> <i>number</i>64ӥåȤʤ⤷<i>number</i>32ӥåȿξĥޤˤͤѴ֤ͤޤ
</ul>
<h4><a name="expressions.errors"></a>2.4. 顼</h4>
<p>顼ˤ졢ۤȤɤΥåƤưפǤޤ顼åŤɤߡ褯ͻ뤳ȤɬפǤ
<br><i><b>Note</b>: </i>ѡȤΤˡsafe Tclץ<b>expr</b>ޥɤ顼𤷤ޤ</i>
<p>ĤŵŪ顼åޤ
<ul>
<li><i>syntax error in expression "...": variable references require preceding $</i>: 餯ĤΥե٥åʸ¤Ǥ뤫̵ʿشؿ˴ޤޤƤ뤳Ȥ̣ޤ
<li><i>syntax error in expression "...": premature end of expression</i>: ̤ĤƤʤǽޤ
</ul>
<h3><a name="formatting"></a>3. </h3>
<p><i>(to be implemented)</i>
<h3><a name="advanced"></a>4. ٤ʻˡ</h3>
<p>ڥɤͤ10ʿ̾ˡ8ʿʥڥɤκǽʸ<b>0</b>ξˡ16ʿʥڥɤκǽ2ʸ<b>0x</b>ξˤǻǤޤ
<p>ưϡANSI˽Cѥˤǽʤ٤ƤˡǻǤޤ<b>f</b><b>F</b><b>l</b><b>L</b>ĤƤʤȤˡ㤨СʲƤͭưǤ<b>2.1</b><b>3.</b><b>6e4</b><b>7.91e+16</b>⤷ͤβԲǽʾϥ顼ˤʤޤϡ<b>?</b>ɽޤ
<p>ʲμͭǤ:<ul>
<li><b>x?y:z</b> CƱͤif-then-elseȤʤޤ⤷<b>x</b>ɾnon-zeroξ<b>y</b>͡Ǥʤ<b>z</b>֤ͤޤ
</ul>
<p>ʲΥؿݡȤƤޤ:<ul>
<li><b>rand()</b> ϰ[<i>0,1</i>]ư֤ͤޤrandؿγƷ̤ϡ˸ƤӽФrandؿη̤ޤǡ٤Ƥͤꤷޤͥ졼seedϥޥåǽꤵ뤫⤷<b>srand</b>ؿǤޤ
<li><b>srand(</b><i>number</i><b>)</b> numberǤʤФʤ餺randؿͥ졼seedꥻåȤ뤿Ѥޤseedκǽ͡<b>rand</b>ȡˤ֤ޤ
</ul>
<p>Ǹˡ<b>Tcl</b>̤Ƥ桼ΤᡢǡͤϤˡΥƥȤ<i>expr</i>ޥɤľϤΤǡڥɤȤʸޤह٤Ƥ<b>expr</b>ޥɤεǽѤ뤳Ȥޤ
</body>
</html>
|
