Commit | Line | Data |
---|---|---|
7ed9159a JY |
1 | Sales 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 = = = = = = | |
11 | 99/07/25 North&South $40.00 | |
12 | 99/08/16 West-district $5.25 | |
13 | 99/08/16 North&South $12.99 | |
14 | 99/08/25 West-district $8.61 | |
15 | 99/08/26 West-district $9.97 | |
16 | 99/09/04 Eastern-area $21.00 | |
17 | 00/01/15 West-district $5.50 | |
18 | 00/07/15 West-district $19.01 | |
19 | 00/07/26 North&South $27.95 | |
20 | 00/08/04 West-district $11.71 | |
21 | 00/08/16 Eastern-area $25.70 | |
22 | 00/08/25 West-district $4.95 | |
23 | 00/08/26 West-district $7.21 | |
24 | 00/09/01 North&South $1.25 | |
25 | 01/07/25 West-district $5.75 | |
26 | 01/08/04 West-district $2.29 | |
27 | 01/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)) | |
122 | (ses-cell C16 21 (/ life-universe-everything 2) nil (D7 C7 D6 C6 D5 C5)) | |
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 | |
205 | ;;; life-universe-everything: 42 | |
206 | ;;; symbolic-formulas: (("Eastern area") ("West-district") ("North&South") ("Other")) | |
207 | ;;; End: | |
ab5796a9 MB |
208 | |
209 | ;;; arch-tag: 4fcb0843-e3f9-4270-b8fb-998129190765 |