declare smobs in alloc.c
[bpt/emacs.git] / etc / ses-example.ses
CommitLineData
7ed9159a
JY
1Sales summary - Acme fundraising
2
3 ~~~~~~~~~~~~~Summary~~~~~~~~~~~~~
4 --Totals-- Average
5 Eastern-area $46.70 2 $23.35
6 West-district $80.25 10 $8.03
7 North&South $99.69 5 $19.94
8 TOTAL ~$227 17 $13.33
9
10= = = = = =Details = = = = = =
1199/07/25 North&South $40.00
1299/08/16 West-district $5.25
1399/08/16 North&South $12.99
1499/08/25 West-district $8.61
1599/08/26 West-district $9.97
1699/09/04 Eastern-area $21.00
1700/01/15 West-district $5.50
1800/07/15 West-district $19.01
1900/07/26 North&South $27.95
2000/08/04 West-district $11.71
2100/08/16 Eastern-area $25.70
2200/08/25 West-district $4.95
2300/08/26 West-district $7.21
2400/09/01 North&South $1.25
2501/07/25 West-district $5.75
2601/08/04 West-district $2.29
2701/08/15 North&South $17.50
28
29\f
30(ses-cell A1 "Sales summary - Acme fundraising" "Sales summary - Acme fundraising" nil nil)
31(ses-cell B1 *skip* nil nil nil)
32(ses-cell C1 *skip* nil nil nil)
33(ses-cell D1 *skip* nil nil nil)
34(ses-cell E1 nil nil nil nil)
35
36(ses-cell A2 nil nil nil nil)
37(ses-cell B2 nil nil nil nil)
38(ses-cell C2 nil nil nil nil)
39(ses-cell D2 nil nil nil nil)
40(ses-cell E2 nil nil nil nil)
41
42(ses-cell A3 nil nil nil nil)
43(ses-cell B3 "Summary" "Summary" ses-tildefill-span nil)
44(ses-cell C3 *skip* nil nil nil)
45(ses-cell D3 *skip* nil nil nil)
46(ses-cell E3 *skip* nil nil nil)
47
48(ses-cell A4 nil nil nil nil)
49(ses-cell B4 nil nil nil nil)
50(ses-cell C4 "Totals" "Totals" ses-dashfill-span nil)
51(ses-cell D4 *skip* nil nil nil)
52(ses-cell E4 "Average" "Average" nil nil)
53
54(ses-cell A5 nil nil nil nil)
55(ses-cell B5 Eastern-area (quote Eastern-area) nil nil)
56(ses-cell C5 46.7 (apply (quote +) (ses-select (ses-range B11 B27) (quote Eastern-area) (ses-range C11 C27))) nil (C8 E5))
57(ses-cell D5 2 (length (ses-select (ses-range B11 B27) (quote Eastern-area) (ses-range C11 C27))) nil (D8 E5))
58(ses-cell E5 23.35 (/ C5 D5) nil nil)
59
60(ses-cell A6 nil nil nil nil)
61(ses-cell B6 West-district (quote West-district) nil nil)
62(ses-cell C6 80.25 (apply (quote +) (ses-select (ses-range B11 B27) (quote West-district) (ses-range C11 C27))) nil (C8 E6))
63(ses-cell D6 10 (length (ses-select (ses-range B11 B27) (quote West-district) (ses-range C11 C27))) nil (D8 E6))
64(ses-cell E6 8.025 (/ C6 D6) nil nil)
65
66(ses-cell A7 nil nil nil nil)
67(ses-cell B7 North&South (quote North&South) nil nil)
68(ses-cell C7 99.69 (apply (quote +) (ses-select (ses-range B11 B27) (quote North&South) (ses-range C11 C27))) nil (C8 E7))
69(ses-cell D7 5 (length (ses-select (ses-range B11 B27) (quote North&South) (ses-range C11 C27))) nil (D8 E7))
70(ses-cell E7 19.938 (/ C7 D7) nil nil)
71
72(ses-cell A8 nil nil nil nil)
73(ses-cell B8 "TOTAL" "TOTAL" nil nil)
74(ses-cell C8 226.64 (ses+ C5 C6 C7) "~$%.0f" (E8))
75(ses-cell D8 17 (ses+ D5 D6 D7) nil (E8))
76(ses-cell E8 13.331764705882351 (/ C8 D8) nil nil)
77
78(ses-cell A9 nil nil ses-center nil)
79(ses-cell B9 useless (quote useless) (lambda (x) (if (eq x (quote useless)) "" (prin1-to-string x))) nil)
80(ses-cell C9 nil nil nil nil)
81(ses-cell D9 nil nil nil nil)
82(ses-cell E9 nil nil nil nil)
83
84(ses-cell A10 "Details " "Details " (lambda (x) (replace-regexp-in-string "==" "= " (ses-center-span x 61))) nil)
85(ses-cell B10 *skip* nil nil nil)
86(ses-cell C10 *skip* nil nil nil)
87(ses-cell D10 "" "" nil nil)
88(ses-cell E10 nil nil nil nil)
89
90(ses-cell A11 990725 990725 nil nil)
91(ses-cell B11 North&South (quote North&South) nil (D7 C7 D6 C6 D5 C5))
92(ses-cell C11 40 40 nil (D7 C7 D6 C6 D5 C5))
93(ses-cell D11 nil nil nil nil)
94(ses-cell E11 nil nil nil nil)
95
96(ses-cell A12 990816 990816 nil nil)
97(ses-cell B12 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
98(ses-cell C12 5.25 5.25 nil (D7 C7 D6 C6 D5 C5))
99(ses-cell D12 nil nil nil nil)
100(ses-cell E12 nil nil nil nil)
101
102(ses-cell A13 990816 990816 nil nil)
103(ses-cell B13 North&South (quote North&South) nil (D7 C7 D6 C6 D5 C5))
104(ses-cell C13 12.99 12.99 nil (D7 C7 D6 C6 D5 C5))
105(ses-cell D13 nil nil nil nil)
106(ses-cell E13 nil nil nil nil)
107
108(ses-cell A14 990825 990825 nil nil)
109(ses-cell B14 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
110(ses-cell C14 8.61 8.61 nil (D7 C7 D6 C6 D5 C5))
111(ses-cell D14 nil nil nil nil)
112(ses-cell E14 nil nil nil nil)
113
114(ses-cell A15 990826 990826 nil nil)
115(ses-cell B15 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
116(ses-cell C15 9.97 9.97 nil (D7 C7 D6 C6 D5 C5))
117(ses-cell D15 nil nil nil nil)
118(ses-cell E15 nil nil nil nil)
119
120(ses-cell A16 990904 990904 nil nil)
121(ses-cell B16 Eastern-area (quote Eastern-area) nil (D7 C7 D6 C6 D5 C5))
d88da39a 122(ses-cell C16 21 (/ 42 2) nil (D7 C7 D6 C6 D5 C5))
7ed9159a
JY
123(ses-cell D16 nil nil nil nil)
124(ses-cell E16 nil nil nil nil)
125
126(ses-cell A17 115 115 nil nil)
127(ses-cell B17 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
128(ses-cell C17 5.5 5.5 nil (D7 C7 D6 C6 D5 C5))
129(ses-cell D17 nil nil nil nil)
130(ses-cell E17 nil nil nil nil)
131
132(ses-cell A18 715 715 nil nil)
133(ses-cell B18 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
134(ses-cell C18 19.01 19.01 nil (D7 C7 D6 C6 D5 C5))
135(ses-cell D18 nil nil nil nil)
136(ses-cell E18 nil nil nil nil)
137
138(ses-cell A19 726 726 nil nil)
139(ses-cell B19 North&South (quote North&South) nil (D7 C7 D6 C6 D5 C5))
140(ses-cell C19 27.95 27.95 nil (D7 C7 D6 C6 D5 C5))
141(ses-cell D19 nil nil nil nil)
142(ses-cell E19 nil nil nil nil)
143
144(ses-cell A20 804 804 nil nil)
145(ses-cell B20 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
146(ses-cell C20 11.71 11.71 nil (D7 C7 D6 C6 D5 C5))
147(ses-cell D20 nil nil nil nil)
148(ses-cell E20 nil nil nil nil)
149
150(ses-cell A21 816 816 nil nil)
151(ses-cell B21 Eastern-area (quote Eastern-area) nil (D7 C7 D6 C6 D5 C5))
152(ses-cell C21 25.7 25.7 nil (D7 C7 D6 C6 D5 C5))
153(ses-cell D21 nil nil nil nil)
154(ses-cell E21 nil nil nil nil)
155
156(ses-cell A22 825 825 nil nil)
157(ses-cell B22 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
158(ses-cell C22 4.95 4.95 nil (D7 C7 D6 C6 D5 C5))
159(ses-cell D22 nil nil nil nil)
160(ses-cell E22 nil nil nil nil)
161
162(ses-cell A23 826 826 nil nil)
163(ses-cell B23 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
164(ses-cell C23 7.21 7.21 nil (D7 C7 D6 C6 D5 C5))
165(ses-cell D23 nil nil nil nil)
166(ses-cell E23 nil nil nil nil)
167
168(ses-cell A24 901 901 nil nil)
169(ses-cell B24 North&South (quote North&South) nil (D7 C7 D6 C6 D5 C5))
170(ses-cell C24 1.25 1.25 nil (D7 C7 D6 C6 D5 C5))
171(ses-cell D24 nil nil nil nil)
172(ses-cell E24 nil nil nil nil)
173
174(ses-cell A25 10725 10725 nil nil)
175(ses-cell B25 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
176(ses-cell C25 5.75 5.75 nil (D7 C7 D6 C6 D5 C5))
177(ses-cell D25 nil nil nil nil)
178(ses-cell E25 nil nil nil nil)
179
180(ses-cell A26 10804 10804 nil nil)
181(ses-cell B26 West-district (quote West-district) nil (D7 C7 D6 C6 D5 C5))
182(ses-cell C26 2.29 2.29 nil (D7 C7 D6 C6 D5 C5))
183(ses-cell D26 nil nil nil nil)
184(ses-cell E26 nil nil nil nil)
185
186(ses-cell A27 10815 10815 nil nil)
187(ses-cell B27 North&South (quote North&South) nil (D7 C7 D6 C6 D5 C5))
188(ses-cell C27 17.5 17.5 nil (D7 C7 D6 C6 D5 C5))
189(ses-cell D27 nil nil nil nil)
190(ses-cell E27 nil nil nil nil)
191
192(ses-column-widths [8 14 6 3 7])
193(ses-column-printers [(lambda (x) (format "%02d/%02d/%02d" (/ x 10000) (% (/ x 100) 100) (% x 100))) ("%s") "$%.2f" nil "$%.2f"])
194(ses-default-printer "%.7g")
195(ses-header-row 0)
196
197( ;Global parameters (these are read first)
198 2 ;SES file-format
199 27 ;numrows
200 5 ;numcols
201)
202
203;;; Local Variables:
204;;; mode: ses
d88da39a 205;;; ses--symbolic-formulas: (("Eastern area") ("West-district") ("North&South") ("Other"))
7ed9159a 206;;; End:
ab5796a9 207
ba318903 208;;; Copyright (C) 2002-2014 Free Software Foundation, Inc.
b727702b
EZ
209
210;;; COPYING PERMISSIONS:
211;;;
ab73e885 212;;; This document is free software: you can redistribute it and/or modify
b727702b 213;;; it under the terms of the GNU General Public License as published by
ab73e885
GM
214;;; the Free Software Foundation, either version 3 of the License, or
215;;; (at your option) any later version.
b727702b
EZ
216;;;
217;;; This program is distributed in the hope that it will be useful,
218;;; but WITHOUT ANY WARRANTY; without even the implied warranty of
219;;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
220;;; GNU General Public License for more details.
221;;;
222;;; You should have received a copy of the GNU General Public License
ab73e885 223;;; along with this program. If not, see <http://www.gnu.org/licenses/>.