| 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: |
| 208 | |
| 209 | ;;; Copyright (C) 2002, 2003, 2004, 2005, 2006, 2007, 2008 |
| 210 | ;;; Free Software Foundation, Inc. |
| 211 | |
| 212 | ;;; COPYING PERMISSIONS: |
| 213 | ;;; |
| 214 | ;;; This document is free software; you can redistribute it and/or modify |
| 215 | ;;; it under the terms of the GNU General Public License as published by |
| 216 | ;;; the Free Software Foundation; either version 3, or (at your option) |
| 217 | ;;; any later version. |
| 218 | ;;; |
| 219 | ;;; This program is distributed in the hope that it will be useful, |
| 220 | ;;; but WITHOUT ANY WARRANTY; without even the implied warranty of |
| 221 | ;;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| 222 | ;;; GNU General Public License for more details. |
| 223 | ;;; |
| 224 | ;;; You should have received a copy of the GNU General Public License |
| 225 | ;;; along with this program; see the file COPYING. If not, write to the |
| 226 | ;;; Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, |
| 227 | ;;; Boston, MA 02110-1301, USA. |
| 228 | |
| 229 | ;;; arch-tag: 4fcb0843-e3f9-4270-b8fb-998129190765 |