- find_pet_by_id(long) - Method in class pet.store.client.Client
-
Returns a user based on a single ID, if the user does not have access to the pet
- find_pet_by_id(long) - Method in interface pet.store.service.Service
-
Returns a user based on a single ID, if the user does not have access to the pet
- find_pet_by_id(long) - Method in class pet.store.service.ServiceController
-
Returns a user based on a single ID, if the user does not have access to the pet
- find_pet_by_idFullResponse(long) - Method in class pet.store.client.Client
-
Returns a user based on a single ID, if the user does not have access to the pet
- findPets(Optional<List<String>>, int) - Method in class pet.store.client.Client
-
Returns all pets from the system that the user has access to
Nam sed condimentum est.
- findPets(Optional<List<String>>, int) - Method in interface pet.store.service.Service
-
Returns all pets from the system that the user has access to
Nam sed condimentum est.
- findPets(Optional<List<String>>, int) - Method in class pet.store.service.ServiceController
-
Returns all pets from the system that the user has access to
Nam sed condimentum est.
- FindPets200Response - Class in pet.store.path
-
- FindPets200Response(List<Pet>) - Constructor for class pet.store.path.FindPets200Response
-
- findPetsFullResponse(Optional<List<String>>, int) - Method in class pet.store.client.Client
-
Returns all pets from the system that the user has access to
Nam sed condimentum est.
- FindPetsTagsParameterTags - Class in pet.store.path
-
- FindPetsTagsParameterTags(List<String>) - Constructor for class pet.store.path.FindPetsTagsParameterTags
-


New Refreshment Request
*All fields are required
Refreshment Information
Date refreshment required:
Quantity:
*Please select a refreshment quantity


Javalanche report for class:
org.joda.time.Years
1: /*
2: * Copyright 2001-2010 Stephen Colebourne
3: *
4: * Licensed under the Apache License, Version 2.0 (the "License");
5: * you may not use this file except in compliance with the License.
6: * You may obtain a copy of the License at
7: *
8: * http://www.apache.org/licenses/LICENSE-2.0
9: *
10: * Unless required by applicable law or agreed to in writing, software
11: * distributed under the License is distributed on an "AS IS" BASIS,
12: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13: * See the License for the specific language governing permissions and
14: * limitations under the License.
15: */
16: package org.joda.time;
17:
18: import org.joda.convert.FromString;
19: import org.joda.convert.ToString;
20: import org.joda.time.base.BaseSingleFieldPeriod;
21: import org.joda.time.field.FieldUtils;
22: import org.joda.time.format.ISOPeriodFormat;
23: import org.joda.time.format.PeriodFormatter;
24:
25: /**
26: * An immutable time period representing a number of years.
27: *

28: * Years is an immutable period that can only store years.
29: * It does not store years, days or hours for example. As such it is a
30: * type-safe way of representing a number of years in an application.
31: *

32: * The number of years is set in the constructor, and may be queried using
33: * getYears(). Basic mathematical operations are provided -
34: * plus(), minus(), multipliedBy() and
35: * dividedBy().
36: *

37: * Years is thread-safe and immutable.
38: *
39: * @author Stephen Colebourne
40: * @since 1.4
41: */
42: public final class Years extends BaseSingleFieldPeriod {
43:
44: /** Constant representing zero years. */
45: public static final Years ZERO = new Years(0);
46: /** Constant representing one year. */
47: public static final Years ONE = new Years(1);
48: /** Constant representing two years. */
49: public static final Years TWO = new Years(2);
50: /** Constant representing three years. */
51: public static final Years THREE = new Years(3);
52: /** Constant representing the maximum number of years that can be stored in this object. */
53: public static final Years MAX_VALUE = new Years(Integer.MAX_VALUE);
54: /** Constant representing the minimum number of years that can be stored in this object. */
55: public static final Years MIN_VALUE = new Years(Integer.MIN_VALUE);
56:
57: /** The paser to use for this class. */
58: private static final PeriodFormatter PARSER = ISOPeriodFormat.standard().withParseType(PeriodType.years());
59: /** Serialization version. */
60: private static final long serialVersionUID =<PHONE_NUMBER>7380868L;
61:
62: //-----------------------------------------------------------------------
63: /**
64: * Obtains an instance of Years that may be cached.
65: * Years is immutable, so instances can be cached and shared.
66: * This factory method provides access to shared instances.
67: *
68: * @param years the number of years to obtain an instance for
69: * @return the instance of Years
70: */
71: public static Years years(int years) {
72: switch (years) {
73: case 0:
74: return ZERO;
75: case 1:
76: return ONE;
77: case 2:
78: return TWO;
79: case 3:
80: return THREE;
81: case Integer.MAX_VALUE:
82: return MAX_VALUE;
83: case Integer.MIN_VALUE:
84: return MIN_VALUE;
85: default:
86: return new Years(years);
87: }
88: }
89:
90: //-----------------------------------------------------------------------
91: /**
92: * Creates a Years representing the number of whole years
93: * between the two specified datetimes. This method corectly handles
94: * any daylight savings time changes that may occur during the interval.
95: *
96: * @param start the start instant, must not be null
97: * @param end the end instant, must not be null
98: * @return the period in years
99: * @throws IllegalArgumentException if the instants are null or invalid
100: */
101: public static Years yearsBetween(ReadableInstant start, ReadableInstant end) {
102: int amount = BaseSingleFieldPeriod.between(start, end, DurationFieldType.years());
103: return Years.years(amount);
104: }
105:
106: /**
107: * Creates a Years representing the number of whole years
108: * between the two specified partial datetimes.
109: *

110: * The two partials must contain the same fields, for example you can specify
111: * two LocalDate objects.
112: *
113: * @param start the start partial date, must not be null
114: * @param end the end partial date, must not be null
115: * @return the period in years
116: * @throws IllegalArgumentException if the partials are null or invalid
117: */
118: public static Years yearsBetween(ReadablePartial start, ReadablePartial end) {
119: if (start instanceof LocalDate && end instanceof LocalDate) {
120: Chronology chrono = DateTimeUtils.getChronology(start.getChronology());
121: int years = chrono.years().getDifference(
122: ((LocalDate) end).getLocalMillis(), ((LocalDate) start).getLocalMillis());
123: return Years.years(years);
124: }
125: int amount = BaseSingleFieldPeriod.between(start, end, ZERO);
126: return Years.years(amount);
127: }
128:
129: /**
130: * Creates a Years representing the number of whole years
131: * in the specified interval. This method corectly handles any daylight
132: * savings time changes that may occur during the interval.
133: *
134: * @param interval the interval to extract years from, null returns zero
135: * @return the period in years
136: * @throws IllegalArgumentException if the partials are null or invalid
137: */
138: public static Years yearsIn(ReadableInterval interval) {
139: if (interval == null) {
140: return Years.ZERO;
141: }
142: int amount = BaseSingleFieldPeriod.between(interval.getStart(), interval.getEnd(), DurationFieldType.years());
143: return Years.years(amount);
144: }
145:
146: /**
147: * Creates a new Years by parsing a string in the ISO8601 format 'PnY'.
148: *

149: * The parse will accept the full ISO syntax of PnYnMnWnDTnHnMnS however only the
150: * years component may be non-zero. If any other component is non-zero, an exception
151: * will be thrown.
152: *
153: * @param periodStr the period string, null returns zero
154: * @return the period in years
155: * @throws IllegalArgumentException if the string format is invalid
156: */
157: @FromString
158: public static Years parseYears(String periodStr) {
159: if (periodStr == null) {
160: return Years.ZERO;
161: }
162: Period p = PARSER.parsePeriod(periodStr);
163: return Years.years(p.getYears());
164: }
165:
166: //-----------------------------------------------------------------------
167: /**
168: * Creates a new instance representing a number of years.
169: * You should consider using the factory method {@link #years(int)}
170: * instead of the constructor.
171: *
172: * @param years the number of years to represent
173: */
174: private Years(int years) {
175: super(years);
176: }
177:
178: /**
179: * Resolves singletons.
180: *
181: * @return the singleton instance
182: */
183: private Object readResolve() {
184: return Years.years(getValue());
185: }
186:
187: //-----------------------------------------------------------------------
188: /**
189: * Gets the duration field type, which is years.
190: *
191: * @return the period type
192: */
193: public DurationFieldType getFieldType() {
194: return DurationFieldType.years();
195: }
196:
197: /**
198: * Gets the period type, which is years.
199: *
200: * @return the period type
201: */
202: public PeriodType getPeriodType() {
203: return PeriodType.years();
204: }
205:
206: //-----------------------------------------------------------------------
207: /**
208: * Gets the number of years that this period represents.
209: *
210: * @return the number of years in the period
211: */
212: public int getYears() {
213: return getValue();
214: }
215:
216: //-----------------------------------------------------------------------
217: /**
218: * Returns a new instance with the specified number of years added.
219: *

220: * This instance is immutable and unaffected by this method call.
221: *
222: * @param years the amount of years to add, may be negative
223: * @return the new period plus the specified number of years
224: * @throws ArithmeticException if the result overflows an int
225: */
226: public Years plus(int years) {
227: if (years == 0) {
228: return this;
229: }
230: return Years.years(FieldUtils.safeAdd(getValue(), years));
231: }
232:
233: /**
234: * Returns a new instance with the specified number of years added.
235: *

236: * This instance is immutable and unaffected by this method call.
237: *
238: * @param years the amount of years to add, may be negative, null means zero
239: * @return the new period plus the specified number of years
240: * @throws ArithmeticException if the result overflows an int
241: */
242: public Years plus(Years years) {
243: if (years == null) {
244: return this;
245: }
246: return plus(years.getValue());
247: }
248:
249: //-----------------------------------------------------------------------
250: /**
251: * Returns a new instance with the specified number of years taken away.
252: *

253: * This instance is immutable and unaffected by this method call.
254: *
255: * @param years the amount of years to take away, may be negative
256: * @return the new period minus the specified number of years
257: * @throws ArithmeticException if the result overflows an int
258: */
259: public Years minus(int years) {
260: return plus(FieldUtils.safeNegate(years));
261: }
262:
263: /**
264: * Returns a new instance with the specified number of years taken away.
265: *

266: * This instance is immutable and unaffected by this method call.
267: *
268: * @param years the amount of years to take away, may be negative, null means zero
269: * @return the new period minus the specified number of years
270: * @throws ArithmeticException if the result overflows an int
271: */
272: public Years minus(Years years) {
273: if (years == null) {
274: return this;
275: }
276: return minus(years.getValue());
277: }
278:
279: //-----------------------------------------------------------------------
280: /**
281: * Returns a new instance with the years multiplied by the specified scalar.
282: *

283: * This instance is immutable and unaffected by this method call.
284: *
285: * @param scalar the amount to multiply by, may be negative
286: * @return the new period multiplied by the specified scalar
287: * @throws ArithmeticException if the result overflows an int
288: */
289: public Years multipliedBy(int scalar) {
290: return Years.years(FieldUtils.safeMultiply(getValue(), scalar));
291: }
292:
293: /**
294: * Returns a new instance with the years divided by the specified divisor.
295: * The calculation uses integer division, thus 3 divided by 2 is 1.
296: *

297: * This instance is immutable and unaffected by this method call.
298: *
299: * @param divisor the amount to divide by, may be negative
300: * @return the new period divided by the specified divisor
301: * @throws ArithmeticException if the divisor is zero
302: */
303: public Years dividedBy(int divisor) {
304: if (divisor == 1) {
305: return this;
306: }
307: return Years.years(getValue() / divisor);
308: }
309:
310: //-----------------------------------------------------------------------
311: /**
312: * Returns a new instance with the years value negated.
313: *
314: * @return the new period with a negated value
315: * @throws ArithmeticException if the result overflows an int
316: */
317: public Years negated() {
318: return Years.years(FieldUtils.safeNegate(getValue()));
319: }
320:
321: //-----------------------------------------------------------------------
322: /**
323: * Is this years instance greater than the specified number of years.
324: *
325: * @param other the other period, null means zero
326: * @return true if this years instance is greater than the specified one
327: */
328: public boolean isGreaterThan(Years other) {
329: if (other == null) {
330: return getValue() > 0;
331: }
332: return getValue() > other.getValue();
333: }
334:
335: /**
336: * Is this years instance less than the specified number of years.
337: *
338: * @param other the other period, null means zero
339: * @return true if this years instance is less than the specified one
340: */
341: public boolean isLessThan(Years other) {
342: if (other == null) {
343: return getValue() < 0;
344: }
345: return getValue() < other.getValue();
346: }
347:
348: //-----------------------------------------------------------------------
349: /**
350: * Gets this instance as a String in the ISO8601 duration format.
351: *

352: * For example, "P4Y" represents 4 years.
353: *
354: * @return the value as an ISO8601 string
355: */
356: @ToString
357: public String toString() {
358: return "P" + String.valueOf(getValue()) + "Y";
359: }
360:
361: }
| ID | Line | Type | Detected |
|---|
| 21776 | 102 | Remove method call | |
| 21777 | 102(1) | Remove method call | |
| 21778 | 103 | Remove method call | |
| 21779 | 119 | Negate jump condition (Replace IFEQ with IFNE) | |
| 21780 | 119(1) | Negate jump condition (Replace IFEQ with IFNE) | |
| 21781 | 120 | Remove method call | |
| 21782 | 120(1) | Remove method call | |
| 21783 | 121 | Remove method call | |
| 21784 | 121(1) | Remove method call | |
| 21785 | 121(2) | Remove method call | |
| 21786 | 121(3) | Remove method call | |
| 21787 | 123 | Remove method call | |
| 21788 | 125 | Remove method call | |
| 21789 | 126 | Remove method call | |
| 21790 | 139 | Negate jump condition (Replace IFNONNULL with IFNULL) | |
| 21791 | 142 | Remove method call | |
| 21792 | 142(1) | Remove method call | |
| 21793 | 142(2) | Remove method call | |
| 21794 | 142(3) | Remove method call | |
| 21795 | 143 | Remove method call | |
| 21796 | 159 | Negate jump condition (Replace IFNONNULL with IFNULL) | |
| 21797 | 162 | Remove method call | |
| 21798 | 163 | Remove method call | |
| 21799 | 163(1) | Remove method call | |
| 21800 | 184 | Remove method call | |
| 21801 | 184(1) | Remove method call | |
| 21802 | 194 | Remove method call | |
| 21803 | 203 | Remove method call | |
| 21804 | 213 | Remove method call | |
| 21805 | 227 | Negate jump condition (Replace IFNE with IFEQ) | |
| 21806 | 230 | Remove method call | |
| 21807 | 230(1) | Remove method call | |
| 21808 | 230(2) | Remove method call | |
| 21809 | 243 | Negate jump condition (Replace IFNONNULL with IFNULL) | |
| 21810 | 246 | Remove method call | |
| 21811 | 246(1) | Remove method call | |
| 21812 | 260 | Remove method call | |
| 21813 | 260(1) | Remove method call | |
| 21814 | 273 | Negate jump condition (Replace IFNONNULL with IFNULL) | |
| 21815 | 276 | Remove method call | |
| 21816 | 276(1) | Remove method call | |
| 21817 | 290 | Remove method call | |
| 21818 | 290(1) | Remove method call | |
| 21819 | 290(2) | Remove method call | |
| 21820 | 304 | Replace a constant (Replace 1 with 2(INT)) | |
| 21821 | 304 | Replace a constant (Replace 1 with 0(INT)) | |
| 21822 | 304 | Negate jump condition (Replace IF_ICMPNE with IF_ICMPEQ) | |
| 21824 | 307 | Replace arithmetic operator (Replace IDIV with IMUL) | |
| 21823 | 307 | Remove method call | |
| 21825 | 307(1) | Remove method call | |
| 21826 | 318 | Remove method call | |
| 21827 | 318(1) | Remove method call | |
| 21828 | 318(2) | Remove method call | |
| 21829 | 329 | Negate jump condition (Replace IFNONNULL with IFNULL) | |
| 21833 | 330 | Replace a constant (Replace 1 with 0(INT)) | |
| 21832 | 330 | Replace a constant (Replace 1 with 2(INT)) | |
| 21834 | 330(1) | Replace a constant (Replace 0 with 1(INT)) | |
| 21835 | 330(1) | Replace a constant (Replace 0 with -1(INT)) | |
| 21831 | 330 | Negate jump condition (Replace IFLE with IFGT) | |
| 21830 | 330 | Remove method call | |
| 21839 | 332 | Replace a constant (Replace 1 with 2(INT)) | |
| 21840 | 332 | Replace a constant (Replace 1 with 0(INT)) | |
| 21841 | 332(1) | Replace a constant (Replace 0 with 1(INT)) | |
| 21842 | 332(1) | Replace a constant (Replace 0 with -1(INT)) | |
| 21838 | 332 | Negate jump condition (Replace IF_ICMPLE with IF_ICMPGT) | |
| 21836 | 332 | Remove method call | |
| 21837 | 332(1) | Remove method call | |
| 21843 | 342 | Negate jump condition (Replace IFNONNULL with IFNULL) | |
| 21847 | 343 | Replace a constant (Replace 1 with 0(INT)) | |
| 21846 | 343 | Replace a constant (Replace 1 with 2(INT)) | |
| 21848 | 343(1) | Replace a constant (Replace 0 with 1(INT)) | |
| 21849 | 343(1) | Replace a constant (Replace 0 with -1(INT)) | |
| 21845 | 343 | Negate jump condition (Replace IFGE with IFLT) | |
| 21844 | 343 | Remove method call | |
| 21854 | 345 | Replace a constant (Replace 1 with 0(INT)) | |
| 21853 | 345 | Replace a constant (Replace 1 with 2(INT)) | |
| 21855 | 345(1) | Replace a constant (Replace 0 with 1(INT)) | |
| 21856 | 345(1) | Replace a constant (Replace 0 with -1(INT)) | |
| 21852 | 345 | Negate jump condition (Replace IF_ICMPGE with IF_ICMPLT) | |
| 21850 | 345 | Remove method call | |
| 21851 | 345(1) | Remove method call | |
| 21857 | 358 | Remove method call | |
| 21858 | 358(1) | Remove method call | |
| 21859 | 358(2) | Remove method call | |
| 21860 | 358(3) | Remove method call | |
| 21861 | 358(4) | Remove method call | |
| 21862 | 358(5) | Remove method call | |


| Use a bookmarklet
[ref]
[ref]
to Change page background color type in white, #eeeeee, or use spacebar for your default color |
|
This page contains some VBA macros and User Defined Functions. If you need assistance to installing either please refer to Install a Macro or User Defined Function on my Formula page. |
Scope of the Color Palette: Each workbook has it’s own palette. To change the default, change your book.xlt template for new workbooks.
From HELP --> Index --> palette
Each Microsoft Excel workbook has a palette of 56 colors that you can apply to cells, fonts, gridlines, graphic objects, and fills and lines in a chart. If you are using a color monitor, you can customize the shade and intensity of the colors in the color palette for each workbook.When you change a color in the palette, it is changed for any element formatted with the color you changed, throughout the entire workbook. To use the same custom color scheme in a set of workbooks, you can copy the color palette from one workbook to another. For example, you can create a custom color palette that matches your company’s logo and image and then copy it into the workbooks used in company presentations. You can also replace the default color palette that Microsoft Excel uses when it creates a new workbook.
HELP --> Wizard --> copy palette
1 Open the workbook that contains the color palette you want to copy.
2 Switch to the workbook to which you want to copy the color palette.
3 On the Tools menu, click Options, and then click the Color tab.
4 In the Copy Colors From box, click the workbook that contains the color palette you want to copy.Note: I have not had any desire to change my own colors so expect them to be unchanged. Correct interpretation of the 56 colors in the ColorIndex is dependent upon the HTML wizard conversion on ColorIndex numbers. The RGB values definitely match color swatches.
The names for colors appears to have a wide variance; I am trying to find what Microsoft generally calls them if they are not named in Excel.
The following colors has been used in Microsoft KB documentation probably for the first 16 colors:
Black, Blue, Cyan, Green, Magenta, Red, Yellow, White, Dk Blue, Dk Cyan, Dk Green, Dk Magenta, Dk Red, Dk Yellow, Dk Gray, Lt Gray
More confusion found in MS KB documentation 0 - Black, 1 - Blue, 2 - Green, 3 - Cyan, 4 - Red, 5 - Magenta, 6 - Yellow/Brown, 7 - White, 8 - Gray,
9 - Bright Blue, A - Bright Green, B - Bright Cyan, C - Bright Red, D - Bright Magenta, E - Bright Yellow, F - Bright White
I have had to change some colors to match Microsoft usage from what I thought was normal usage. Assignment of name Gray may have to be changed. Color6 and Color27 appear to both be Yellow on my system even after resetting colors (Tools --> Options).
To see your 56 colors (to bring up box in VBA) In XL95 Help --> index --> Colorindex property
In XL97/XL2000 VBE HELP (Alt+F11, F1) --> index --> ColorIndex propertyIt would be hard to compare the palettes between XL95 and XL97. The XL95 palette is arranged by index number and the XL97 palette is arranged chromatically.
to see the palette in Excel
40 color palette is on a toolbar icon
56 color palette is available with Format, Cells, Patterns(tab)in VBA
Application.CommandBars("Fill Color").Visible = True ' -- 40 colors
Application.Dialogs.Item(xlDialogColorPalette).Show ' -- 56 colorsThis table was NOT generated by the Internet Assistant Wizard for Microsoft Excel. You can find this add-in on "http://www.microsoft.com/msoffice/freestuf/msexcel/index.htm" -->
Appearance of table redone 2000-12-09 in Excel 2000, I display 32,760 colors, Excel shows only 56 colors at any time. Following are the defaults.
Text within some cells can be viewed easier by selecting an area with the mouse.
zap colors Reset (F5)
interior font HTML bgcolor= Red< Green Blue Color Black [Color 1] #000000 #000000 0 0 0 [Black] White [Color 2] #FFFFFF #FFFFFF 255 255 255 [White] Red [Color 3] #FF0000 #FF0000 255 0 0 [Red] Green [Color 4] #00FF00 #00FF00 0 255 0 [Green] Blue [Color 5] #0000FF #0000FF 0 0 255 [Blue] Yellow [Color 6] #FFFF00 #FFFF00 255 255 0 [Yellow] Magenta [Color 7] #FF00FF #FF00FF 255 0 255 [Magenta] Cyan [Color 8] #00FFFF #00FFFF 0 255 255 [Cyan] [Color 9] [Color 9] #800000 #800000 128 0 0 [Color 9] [Color 10] [Color 10] #008000 #008000 0 128 0 [Color 10] [Color 11] [Color 11] #000080 #000080 0 0 128 [Color 11] [Color 12] [Color 12] #808000 #808000 128 128 0 [Color 12] [Color 13] [Color 13] #800080 #800080 128 0 128 [Color 13] [Color 14] [Color 14] #008080 #008080 0 128 128 [Color 14] [Color 15] [Color 15] #C0C0C0 #C0C0C0 192 192 192 [Color 15] [Color 16] [Color 16] #808080 #808080 128 128 128 [Color 16] [Color 17] [Color 17] #9999FF #9999FF 153 153 255 [Color 17] [Color 18] [Color 18] #993366 #993366 153 51 102 [Color 18] [Color 19] [Color 19] #FFFFCC #FFFFCC 255 255 204 [Color 19] [Color 20] [Color 20] #CCFFFF #CCFFFF 204 255 255 [Color 20] [Color 21] [Color 21] #660066 #660066 102 0 102 [Color 21] [Color 22] [Color 22] #FF8080 #FF8080 255 128 128 [Color 22] [Color 23] [Color 23] #0066CC #0066CC 0 102 204 [Color 23] [Color 24] [Color 24] #CCCCFF #CCCCFF 204 204 255 [Color 24] [Color 25] [Color 25] #000080 #000080 0 0 128 [Color 25] [Color 26] [Color 26] #FF00FF #FF00FF 255 0 255 [Color 26] [Color 27] [Color 27] #FFFF00 #FFFF00 255 255 0 [Color 27] [Color 28] [Color 28] #00FFFF #00FFFF 0 255 255 [Color 28] [Color 29] [Color 29] #800080 #800080 128 0 128 [Color 29] [Color 30] [Color 30] #800000 #800000 128 0 0 [Color 30] [Color 31] [Color 31] #008080 #008080 0 128 128 [Color 31] [Color 32] [Color 32] #0000FF #0000FF 0 0 255 [Color 32] [Color 33] [Color 33] #00CCFF #00CCFF 0 204 255 [Color 33] [Color 34] [Color 34] #CCFFFF #CCFFFF 204 255 255 [Color 34] [Color 35] [Color 35] #CCFFCC #CCFFCC 204 255 204 [Color 35] [Color 36] [Color 36] #FFFF99 #FFFF99 255 255 153 [Color 36] [Color 37] [Color 37] #99CCFF #99CCFF 153 204 255 [Color 37] [Color 38] [Color 38] #FF99CC #FF99CC 255 153 204 [Color 38] [Color 39] [Color 39] #CC99FF #CC99FF 204 153 255 [Color 39] [Color 40] [Color 40] #FFCC99 #FFCC99 255 204 153 [Color 40] [Color 41] [Color 41] #3366FF #3366FF 51 102 255 [Color 41] [Color 42] [Color 42] #33CCCC #33CCCC 51 204 204 [Color 42] [Color 43] [Color 43] #99CC00 #99CC00 153 204 0 [Color 43] [Color 44] [Color 44] #FFCC00 #FFCC00 255 204 0 [Color 44] [Color 45] [Color 45] #FF9900 #FF9900 255 153 0 [Color 45] [Color 46] [Color 46] #FF6600 #FF6600 255 102 0 [Color 46] [Color 47] [Color 47] #666699 #666699 102 102 153 [Color 47] [Color 48] [Color 48] #969696 #969696 150 150 150 [Color 48] [Color 49] [Color 49] #003366 #003366 0 51 102 [Color 49] [Color 50] [Color 50] #339966 #339966 51 153 102 [Color 50] [Color 51] [Color 51] #003300 #003300 0 51 0 [Color 51] [Color 52] [Color 52] #333300 #333300 51 51 0 [Color 52] [Color 53] [Color 53] #993300 #993300 153 51 0 [Color 53] [Color 54] [Color 54] #993366 #993366 153 51 102 [Color 54] [Color 55] [Color 55] #333399 #333399 51 51 153 [Color 55] [Color 56] [Color 56] #333333 #333333 51 51 51 [Color 56] Excel only recognizes names for Color 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan). The colors 1-16 are widely understood color names from the VGA color palette. Of the 56 colors only 40 colors appear on the palette. The 40 colors names indicated on the Excel color palette (see below) are for descriptive purposes only. The following color pairs are the same color
11 & 25, 5 & 32, 14 & 31, 8 & 28, 9 & 30, 13 & 29, 18 & 54, 20 &34, 7 & 26, and 6 & 27.The above table was created in Excel 2000 with help from the following macro, which includes Worksheet function HEX2DEC. The table was converted to HTML using XL2HTML macro which (at least when done) does not convert embedded HTML code within a cell.
Sub colors56() '57 colors, 0 to 56 Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 'pre XL97 xlManual Dim i As Long Dim str0 As String, str As String For i = 0 To 56 Cells(i + 1, 1).Interior.colorindex = i Cells(i + 1, 1).Value = "[Color " & i & "]" Cells(i + 1, 2).Font.colorindex = i Cells(i + 1, 2).Value = "[Color " & i & "]" str0 = Right("000000" & Hex(Cells(i + 1, 1).Interior.color), 6) 'Excel shows nibbles in reverse order so make it as RGB str = Right(str0, 2) & Mid(str0, 3, 2) & Left(str0, 2) 'generating 2 columns in the HTML table Cells(i + 1, 3) = "#" & str & "#" & str & "" Cells(i + 1, 4).Formula = "=Hex2dec(""" & Right(str0, 2) & """)" Cells(i + 1, 5).Formula = "=Hex2dec(""" & Mid(str0, 3, 2) & """)" Cells(i + 1, 6).Formula = "=Hex2dec(""" & Left(str0, 2) & """)" Cells(i + 1, 7) = "[Color " & i & ")" Next i done: Application.Calculation = xlCalculationAutomatic 'pre XL97 xlAutomatic Application.ScreenUpdating = True End SubColorIndex -- 56 Excel Colors [#colors56/#colorindex]
[Color 0] [Color 0] [Color 15] [Color 15] [Color 30] [Color 30] [Color 45] [Color 45] [Color 1] [Color 1] [Color 16] [Color 16] [Color 31] [Color 31] [Color 46] [Color 46] [Color 2] [Color 2] [Color 17] [Color 17] [Color 32] [Color 32] [Color 47] [Color 47] [Color 3] [Color 3] [Color 18] [Color 18] [Color 33] [Color 33] [Color 48] [Color 48] [Color 4] [Color 4] [Color 19] [Color 19] [Color 34] [Color 34] [Color 49] [Color 49] [Color 5] [Color 5] [Color 20] [Color 20] [Color 35] [Color 35] [Color 50] [Color 50] [Color 6] [Color 6] [Color 21] [Color 21] [Color 36] [Color 36] [Color 51] [Color 51] [Color 7] [Color 7] [Color 22] [Color 22] [Color 37] [Color 37] [Color 52] [Color 52] [Color 8] [Color 8] [Color 23] [Color 23] [Color 38] [Color 38] [Color 53] [Color 53] [Color 9] [Color 9] [Color 24] [Color 24] [Color 39] [Color 39] [Color 54] [Color 54] [Color 10] [Color 10] [Color 25] [Color 25] [Color 40] [Color 40] [Color 55] [Color 55] [Color 11] [Color 11] [Color 26] [Color 26] [Color 41] [Color 41] [Color 56] [Color 56] [Color 12] [Color 12] [Color 27] [Color 27] [Color 42] [Color 42] [Color 13] [Color 13] [Color 28] [Color 28] [Color 43] [Color 43] [Color 14] [Color 14] [Color 29] [Color 29] [Color 44] [Color 44]
The default ColorIndex numbers can be found in HELP -->. Index --> ColorIndex Property
1 53 52 51 49 11 55 56 9 46 12 10 14 5 47 16 3 45 43 50 42 41 13 48 7 44 6 4 8 33 54 15 38 40 36 35 34 37 39 2 additional 16 colors below are not shown on the 40 color toolbar palette but can be seen under Format, Cells, Pattern 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Of the descriptive color names only those for index numbers 1 - 8 can be used in coding. Black Brown Olive Green Dark Green Dark Teal Dark Blue Indigo Gray-80% Dark Red Orange Dark Yellow Green Teal Blue Blue-Gray Gray-50% Red Light Orange Lime Sea Green Aqua Light Blue Violet Gray-40% Pink Gold Yellow Bright Green Turquoise Sky Blue Plum Gray-25% Rose Tan Light Yellow Light Green Light Turquoise Pale Blue Lavender White *to be updated* Excel 2000 names colors below (font not patterns) ******** *** ***** ** Periwinkle Plum+ Ivory Lite Turquoise Dark Purple Coral Ocean Blue Ice Blue Dark Blue+ Pink+ Yellow+ Turquoise+ Violet+ Dark Red+ Teal+ Blue+ The colors names indicated on the color palette are for descriptive purposes only. Excel only recognizes names for Color 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan).
Hex equivalents used in HTML
#000000 #993300 #333300 #003300 #003366 #000080 #333399 #333333 #800000 #FF6600 #808000 #008000 #008080 #0000FF #666699 #808080 #FF0000 #FF9900 #99CC00 #339966 #33CCCC #3366FF #800080 #969696 #FF00FF #FFCC00 #FFFF00 #00FF00 #00FFFF #00CCFF #993366 #C0C0C0 #FF99CC #FFCC99 #FFFF99 #CCFFCC #CCFFFF #99CCFF #CC99FF #FFFFFF Additional 16 colors below are not shown on the 40 color toolbar palette but can be seen under Format, Cells, Pattern #9999FF #993366 #FFFFCC #CCFFFF #660066 #FF8080 #0066CC #CCCCFF #000080 #FF00FF #FFFF00 #00FFFF #800080 #800000 #008080 #0000FF Grayscale choices as seen in the Color Palette (#grayscale)
A B C D E F G H I 1 Palette Sample % R G B Dec Calc Formula 2 black 100 00 00 00 0 0 =(100-C2)*256/100 3 gray-80% 80 33 33 33 51 51.2 =(100-C3)*256/100 4 gray-50% 50 80 80 80 128 128 =(100-C4)*256/100 5 gray-40% 40 96 96 96 150 153.6 =(100-C5)*256/100 6 gray-25% 25 C0 C0 C0 192 192 =(100-C6)*256/100 7 white 0 FF FF FF 256 256 =(100-C7)*256/100 You can use the Color Detector to see the RGB or Hex color values by using it to click here or on the color palette custom panel.
Click to view this page in grayscale [IE only], hit F5 to restore. Background to White. Read more about bookmarklets.
Modifications to Palette on a grayscale
Tools, Options, Color (tab), Select a palette color to be modified, modify (button)
on my Excel 2000 at this point Standard tab has 17 preselected white/ gray/ black choices at the bottom, choose any of them and you get a gray scale when you switch to the custom tab you should see the RGB values being equal and will change as you slide the choice selector.Colors in Cell Formatting (#formatting)
The following colors may be used in formatting statements: (see color table above)
black, blue, green, cyan, red, magenta, yellow, white; and, Color1, color2, color3, ..., color56The parts of the format (unless changed) are:
positive numbers; negative numbers; zero; textCustom Formatting (#custom)
For more information on formatting see your Excel HELP and my Formula page and particularly Custom Cell Formatting.
-4 [>=5]General; [Red]-General; [Blue]General -1 [>=5]General; [Red]-General; [Blue]General 0 [>=5]General; [Red]-General; [Blue]General 2 [>=5]General; [Red]-General; [Blue]General 4 [>=5]General; [Red]-General; [Blue]General 5 [>=5]General; [Red]-General; [Blue]General 10 [>=5]General; [Red]-General; [Blue]General txt [>=5]General; [Red]-General; [Blue]General
Entry Formatted Format -- GetFormat(cell) was used to display Format -7 - 7.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ -3 - 3.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ -2 - 2.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ -1 - 1.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 0 0.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 1 1.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 2 2.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 3 3 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 4 4 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 5 5.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 6 6.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ 7 7.00 [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 42]General; [magenta]"Text:"@ Test Text:Test [Blue][>=5]0.00; [Red][<=2]-0.00; [Color 45]General; [magenta]"Text:"@ Format for ... (each format is separated by a semicolon)
Positive Numbers(default); Negative Numbers(default); Zero(All other numbers); TextAlso see my Formula page (starting at #cellformat). A generalized posting (2004-03-12) related to the above Cell Formatting, and to Conditional Formatting, and Event macros. Two more examples of cell formatting:
[Red][>=5]General;[Color40][>=2]General;[Color10]General;[Color30]@ [Red][>0]"No";[Green]"Yes"Conditional Formatting is covered on it's own page and can be used for color banding (like greenbar paper) [also see].
Pastel colors for 50% backgrounds HTML (#chrome)
FEF5A8 C5F19A FFD8A0 F5DDB7 B9D0E8 D6BFD4 F79494 D3D7CF template_talk
#FFFFCC #FBF4D4 #FFFF80 #F3E078 #B3B300 #BFCFFF #CCCCFF #F3E0FF #DCFFDC Changing the Colors of your DOS session (#DOS)
Color change is available at least in WinNT.Changing colors of your DOS window may or may not work for you. I changed mine mainly in order to work with a specific package so that the wording is black on white. This is easy to change but where there is no text the color will remain black. (directions). Color can also be changed in the DOS window with the color command (Color F0), which can be put into your Autoexec.bat -- to be effective you must reboot. The screen can still turn black upon exiting an application but can be instantly reverted to white by typing Color.
The DOS assignments of the 16 colors (0-15) (#OE)
The normal VGA assignments do not apply to Excel, but they do apply to older VGA monitors used on IBM mainframes and DOS color assignments.
0 1 2 3 4 5 6 7 000000
Black000080
Navy008000
Green008080
Teal800000
Maroon800080
Purple808000
OliveC0C0C0
SilverThe assignments 0-15 are NOT those used by Excel ColorIndex 10 11 12 13 14 15 808080
Gray0000FF
Blue00FF00
Lime00FFFF
Cyan*FF0000
RedFF00FF
Magenta*FFFF00
YellowFFFFFF
WhiteThe Colors supported by Internet Explorer and most browsers in alphabetical order (#HTML):
AQUA, BLACK, BLUE, FUCHSIA, GRAY, GREEN, LIME, MAROON, NAVY, OLIVE, PURPLE, RED, SILVER, TEAL, white (white), yellow [Select area with mouse to read]The above colors are supported in the HTML 3.2 standard but have not been universally accepted by all browsers. In HTML the colors are Fuchsia: #FF00FF instead of Magenta; and Aqua: #00FFFF instead of Cyan.
#gamma
The colors above and as fonts below are the choices of colors for Outlook Express and use the HTML names. Colors 0-6, and 8 are very hard to see the difference looking straight at the screen on what would now be an old laptop.
0 Black, 1 Navy, 2 Green, 3 Teal, 4 Maroon, 5 Purple 6 Olive, 7 Silver,
8 Gray, 9 Blue, 10 Lime, 11 Aqua+, 12 Red, 13 Fuschia, 14 Yellow, 15 White
0 Black, 1 Navy, 2 Green, 3 Teal, 4 Maroon, 5 Purple 6 Olive, 7 Silver,
8 Gray, 9 Blue, 10 Lime, 11 Aqua+, 12 Red, 13 Fuschia, 14 Yellow, 15 White
0 Black, 1 Navy, 2 Green, 3 Teal, 4 Maroon, 5 Purple 6 Olive, 7 Silver,
8 Gray, 9 Blue, 10 Lime, 11 Aqua+, 12 Red, 13 Fuschia, 14 Yellow, 15 White
0 Black, 1 Navy, 2 Green, 3 Teal, 4 Maroon, 5 Purple 6 Olive, 7 Silver,
8 Gray, 9 Blue, 10 Lime, 11 Aqua+, 12 Red, 13 Fuschia, 14 Yellow, 15 WhiteYou should be able to distinguish link colors, if you can’t, consider specifying your own default colors (or even overrides). Click here to establish visited links below.
Possible link
color changeslink #0000FF
visited #FF00FFlink #0000FF
visited #FF00FFYour own
link colorsunvisited link
visted linkunvisited link
visted linkYou can change your own default colors for links:
In Internet Explorer use Tools, Internet, General (tab), Fonts.
(Not recommended but Accessibility button has option to override web page colors.)
In Firefox use Tools, Options, General (icon on left), Fonts and Colors, OK. (color override on same dialog.)To temporarily override a web pages visited links color you can use a bookmarklet which would be in effect until you reload the page or hit F5 (Reset/Reload). The bookmarklet Links Visited to RED is particularly useful when viewing Google search results. (Try it yourself, and Reset with F5. If you like it drag to links bar or a folder in your links bar, and do look at my bookmarklets page.)
Since changing the actual colors is not possible, and would be ill advised, I’m not going to attempt to see if it is possible to have eight distinguishable font colors for my laptop when within Outlook Express usage.
The Gamma can be changed for colors, and is somewhat equivalent from moving up or down when viewing the laptop monitor, or by adjusting the tilt of the monitor. Most of problem distinguishing color pertains to fonts, backgrounds are okay and bold text better than plain text. To adjust the colors on the monitor use: Control Panel, Settings, Display (monitor), settings (tab), Advanced (button), Color (tab), and change the color. The gamma is seen as a color curve that you can distort for each of the primary colors (Red, Green, Blue). Other Display settings.
Help Help Help Help Help Help Help Help Help Help Help (#Help)
HELP - related information (#help)
HELP --> Find --> color --> color --> "Basic number format codes"HELP --> Index --> colorindex property --> colorindex property
Macros Macros Macros Macros Macros Macros Macros Macros Macros (#Macros)
Setting Colors in Excel VBA Macros (#macros)
ActiveCell.Borders.Color = RGB(255, 0, 0) ActiveCell.Borders(xlTop).Color = RGB(0, 0, 255) ActiveCell.Borders(xlBottom).ColorIndex = 18 ActiveCell.Font.ColorIndex = 17 ActiveCell.Font.Color = RGB(255, 0, 0) Selection.Interior.ColorIndex = xlNone 'xlColorIndexAutomatic or xlColorIndexNone Selection.Interior.ColorIndex = 5 Selection.Interior.Color = RGB(200, 250, 200) Selection.Interior.Color = &Hc8efac8 'h=Hex, o=Octal anyone still use octal ActiveCell.Font.Background = {xlAutomatic | xlOpaque | x1Transparent} Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate ActiveWindow.GridlineColor = RGB(255,0,0) Members of Excel Constants details: Const xlColorIndexNone = -4142 (&HFFFFEFD2) Const xlColorIndexAutomatic = -4105 (&HFFFFEFF7) Const xlAutomatic = -4105 (&HFFFFEFF7) Const xlBackgroundOpaque = 3 Const xlBackgroundTransparent = 2 Const xlOpaque = 3 Const xlTransparent = 2Coloring Formulas Blue, and remove other font colors (#ColorFormulas)
You could assign this to a toolbar button.Sub ColorFormulas() 'xl97 up use xlcelltypeformulas Cells.FONT.ColorIndex = xlAutomatic Selection.SpecialCells(xlFormulas).FONT.ColorIndex = 5 End SubAlso see Coloring Cells based on CellType as tested with SpecialCells.Coloring Unprotected Cells Blue (#FormatUnprotected)
Simulate a Lotus 1-2-3 feature to color unprotected cells blue (ref)Sub FormatUnprotected() For Each Item In Intersect(ActiveSheet.UsedRange, Selection.Cells) If Item.Locked = False Then Item.Font.colorindex = 32 End If Next End SubChanging Font based on interior color and column (#chgfont)
Check for interior color of 41 (light blue).Sub whiteONblue() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 'pre XL97 xlManua Dim cell As Range '---Range("A3:N100").Select For Each cell In Selection If cell.Interior.colorindex = 41 And cell.Column = 4 Then cell.Font.colorindex = 2 '2=white, 6=yellow End If Next cell Application.Calculation = xlCalculationAutomatic 'pre XL97 xlManua Application.ScreenUpdating = False End SubClear Constants from Color Cells (#ClearConstantsFromColorCells)
The purpose of ClearConstantsFromColorCells is clear out constants from the cells that have an interior color, and to retain the color of the cells. Formulas, and empty cells will not be affected and aren't even checked.You can select an entire column without taking 6 seconds to process every cell in that column because the cells processed must also have constants. Anything located by SpecialCells is by definition in the UsedRange. Anything outside the UsedRange could have color but won't have constants.
Have been doing so many change events lately that I turned off events during the execution. There is a little risk here with EnableEvents turned off should the subroutine fail for some reason.
Sub ClearConstantsFromColorCells() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim Cell As Range On Error Resume Next 'In case no cells in selection Application.EnableEvents = False For Each Cell In Intersect(Selection, _ Cells.SpecialCells(xlConstants)) If Cell.Interior.ColorIndex >= 0 Then Cell.ClearContents Next Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub
Function showRGB_wrong(rcell) showRGB = rcell.Interior.Color) End FunctionYou won't get too far in HTML using range.Interior.Color as above which is supposed to show RGB but shows them in the wrong order and without leading zeros. HTML has the RGB components in the correct RGB order, so the following would be what you need to equate to HTML color definitions. Most people get the HTML wrong because range.Interior.Color returns wrong order for RGB components. For this reason the tables show the #prefix used in HTML colors to avoid all ambiguity.Function showRGB(rcell) Dim xColor As String xColor = Right("000000" & Hex(rcell.Interior.Color), 6) ShowRGB = Right(xColor, 2) & Mid(xColor, 3, 2) _ & Left(xColor, 2) End Function Function showColorIndex(rcell) showColorIndex = rcell.Interior.ColorIndex End FunctionFunction ShowHTMLcolor(xcell) As String Dim xColor As String xColor = Right("000000" & Hex(xcell.Interior.Color), 6) ShowHTMLcolor = "#" & Right(xColor, 2) & Mid(xColor, 3, 2) _ & Left(xColor, 2) End Function Example: interior colorindex of B28 =ShowColorIndex(B28)
|
The shortcut key Ctrl+Alt+F9 forces a recalculation of *everything* in all open
workbooks whether or not Excel *thinks* recalculations are needed. Changing
a format does not trigger cell recalculation, so you will have to force this
when you want the values to change.
The use of Volatile would also work but would probably have a severe
impact on your use of Excel. the VBA equivalent of the shortcut is |
| A | B | C | D | E | |
| 1 | A1-1 | A1-1 | C1: =A1 | also tested for formulas like: | |
| 2 | A2-1 | A3-1 | C2: =A3 | =Sheet4'!A18 | |
| 3 | A3-1 | 100 | C3: =A4 | ='Sheet four'!A18 | |
| 4 | $100.00 | A2-1 | C4: =A2 | =(D20) |
See posting 2005-06-01 in Excel.miscSub ColorOfAssignment() Dim rng As Range, cell As Range Set rng = Selection 'rng.Interior.ColorIndex = xlAutomatic 'clear color For Each cell In Intersect(rng, _ rng.SpecialCells(xlFormulas)) On Error Resume Next cell.Interior.ColorIndex = _ Range(Mid(cell.Formula, 2)).Interior.ColorIndex On Error GoTo 0 Next cell End Sub
| A | B | C | D | E | |
| 1 | A1-1 | A1-1 | C1: =A1 | also tested for formulas like: | |
| 2 | A2-1 | A3-1 | C2: =A3 | =Sheet4'!A18 | |
| 3 | A3-1 | $100.00 | C3: =A4 | ='Sheet four'!A18 | |
| 4 | $100.00 | A2-1 | C4: =A2 | =(A20) |
Sub FormatOfAssignment() Dim rng As Range, cell As Range Set rng = Selection For Each cell In Intersect(rng, _ rng.SpecialCells(xlFormulas)) On Error GoTo passby Range(Mid(cell.Formula, 2)).Copy cell.PasteSpecial Paste:=xlFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False passby: On Error GoTo 0 Next cell End Sub
Sub Populate_color() Dim cell As Range For Each cell In Intersect(Selection, _ Selection.SpecialCells(xlCellTypeConstants, xlNumbers)) cell.Interior.ColorIndex = cell.Value Next cell End Sub
Option Explicit Global gblColorIndex As Long Sub SetInteriorColor() gblColorIndex = ActiveCell.Interior.ColorIndex End Sub Sub PutInteriorColor() Selection.Interior.ColorIndex = gblColorIndex End Sub Sub SameInteriorAsA1() Selection.Interior.ColorIndex = [A1].Interior.ColorIndex End SubAlso see Conditional Formatting.
This is a somewhat frequent request, that is going to be prone to errors in interpretation of what color is. You can obtain ColorIndex or RGB but how would you sort that meaningfully. Finally you are going to have problems with recalculaton.This topic is covered further on a separate page: Color, Sorting on Color
For Each cell In Selection 'Check for Black interior color If cell.Interior.ColorIndex = 1 Then [action] End If NextIf the colors you want to test are due to Conditional Formatting then use the same kind of test that you used for Conditional Formatting, and the results will be immediate (no recalculation needed) i.e.
- Count cells with a particular background cell color - PhilCxn<EMAIL_ADDRESS>- ShowColor(cellref) - Patrick Molloy
=COUNTIF(D12:D16,TRUE)
=SUMIF(D12:D16,TRUE,E12:E16)If the colors are not from C.F. you will have to use a User Defined Function to find this information and since formatting is not registered as a cell change you will have to wait for a recalculation to occur to get a valid answer. You can but should not make the macro Volatile, since by doing that you could bring your Excel to an extremely slow state. Examples follow in the next paragraph.
See my Functions for Determining Interior Color of Another Cell described earlier for RGB, ColorIndex, and HEX.
Chip Pearson has some additional color functions using a little different approach unfortunately for whatever reason he does not provide (#cpcolorsx) examples of his Functions For Cell Colors:
The following examples obtain the colorindex from another cell which is best, because colorindex colors can be changed by changing the palette.Processing Coloured Cells, Bob Phillips, informative text, and macro subroutinesInterior, colorindex of
=cellcolorindex(A$3,0)
if you installed in your personal.xls workbook to be available to all workbooks, use
=personal.xls!cellcolorindex(A$3,0)Font, colorindex of
=cellcolorindex(A$3,1)Count the cells with same interior color as A$3
=countbycolor(A$1:A$17,cellcolorindex(A$3,0))Count the cells with same font color as A$3
=countbycolor(A$1:A$16,cellcolorindex(A$3,1),1)Sum of the cells with same interior color as A$3
=sumbycolor(A$1:A$16,cellcolorindex(A$3))#NAME? error will occur if you misspell one of the UDF (User Defined Function) above or did not install the function. A #VALUE! error may occur if you did not install a function used inside or misuse it. Instructions to install macros and User Defined Functions can be found on my formula.htm page.
To work with shading instead of colorindex use .pattern instead of .colorindex and rename functions accordingly. Specific patterns include such name as: xlgray8, xlgrid, xlvertical
Conditional Formatting introduced in Excel 97 is limited to 3 conditions. With more than 3 conditions a macro would be required, such as shown below. Another kind of macro that you could use is an Event Macro. Note even if you have an Event macro you will probably want a normal macro to fix things up ahead of time. A more complicated macro differentiating text values, numbers, and empty cells in addition to ranges of numbers.Sub ColorRowBasedOnCellValue() 'David McRitchie, 2001-01-17 programming -- Color row based on value Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim cell As Range For Each cell In Intersect(Selection, ActiveCell.EntireColumn, _ ActiveSheet.UsedRange) Select Case cell.Value Case Is >= 50 cell.EntireRow.Interior.colorindex = 20 Case Is >= 40 cell.EntireRow.Interior.colorindex = 37 Case Is >= 20 cell.EntireRow.Interior.colorindex = 38 Case Is >= 0 cell.EntireRow.Interior.colorindex = 36 Case Else cell.EntireRow.Interior.colorindex = 44 End Select Next cell Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = False End Sub
The following will delete the entire row if it sees RED as define by ColorIndex = 3 There are some caveats:
- Conditional Formatting colors are invisible to VBA.
- The ColorIndex = 3 is the default someone could change it
- Not everybody is going to be able to distinguish RED from colors close to it and then there is Red/Green colorblindness.
- Not all monitors are going to show colors alike, though RED is pretty safe in that regard.
Comments for the following code can be found below the macro DelCellsUp on another web page.
Sub DeleteRowsRedInColA() 'David McRitchie 2002-01-17 ' http://www.mvps.org/dmcritchie/excel/colors.htm 'Will not find color due to Conditional Formatting Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 'pre XL97 xlManual Dim rng As Range, ix As Long Set rng = Intersect(Range("A:A"), ActiveSheet.UsedRange) For ix = rng.Count To 1 Step -1 If rng.Item(ix).Interior.ColorIndex = 3 Then rng.Item(ix).EntireRow.Delete End If Next Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub
Hex characters are actually characters, but represent binary numbers.RGB values are represented by 6 hex digits. The first pair of digits represents Red, the next Green, and the last Blue. The values range from 0 to 255, or in hex from 00 to FF. Given a six hex digit representation in hex characters such as 00C0C8 as hex characters simply use left, and mid to separate them the digit pairs. Look in HELP for more information about HEX2DEC and DEC2HEX. Suppose B14 had a Long (Binary) integer in it and you want 6 hex digits for RGB. HEX2DEC and DEC2HEX are part of the Statistical Analysis Toolpak [menu] [list]
There are 256³ RGB colors (16,777,216) and only 56 colorindex colors in the palette; so a one to one match of each is not only impossible, but the colors in the palette can be reassigned to different colors.
Conversion of Font color in Excel to a hex string for HTML (via VBA code) (#hexconvxl)
The following code was used in XL2HTMLx conversion of an Excel sheet to HTML. Note Excel appears to store binary values in reverse order or perhaps this is just “big-endian” (main frames, 1234 order) vs. “little-endian” (most PCs, 4321 order).
xColor = Right("000000" & Hex(Selection.Cells(r, C).FONT.Color), 6) xColor = "#" & Right(xColor, 2) & Mid(xColor, 3, 2) & Left(xColor, 2) If xColor <> "#000000" Then _ x = "<font color=""" & xColor & """>" & x & "</font>"Conversion of a single binary decimal number to decimal RGB components (WS formulas)=RIGHT("000000" & DEC2HEX(B14),6)If you have a character value such as 00C0C8 or you start from a Long (Binary) integer, your can incorporate the above formula into the following=HEX2DEC(Left(B15,2)) =HEX2DEC(MID(B15,3,2)) =HEX2DEC(MID(B15,5,2))I have not provided for the possibility of 3-digit hex numbers in HTML like #333 #608 which are equivalent to #333333 and #660088, simply because I would never create the values that way myself.
I also would never produce RGB(red,green,blue) strings for use in HTML and they are mostly done incorrectly (without quotes) in most places that I see them used and harder to work with visually when coding or comparing source.
To change a color in your palette go to Tools --> Options --> Color where you can change a color by double-clicking on a color cell. Use Reset to revert back to defaults. Also see Help --> colors, changingChanging the default Shading Color (Fill Color) / (#fillcolor)
The default shading color is yellow (RGB: 255, 255, 0). If you want to change it for a workbook you will have to change the color in that position of the palette. Best to exchange the color with another color on the palette say Lt Green (RGB: 204, 255, 204) using Tools, Options, Colors, Modify, Custom. You can always use Reset to restore normal palette for the workbook.
A frequent question in the newsgroups is how to change the default colors in the Cell Comments. The name of the author is picked up from your Tools, Options, General, User Name. (you cannot change the color of the red triangle)Cell Comments are Tool Tips so to change your default you must change your Windows default. To change only once cell comment double-click on the border of the cell comment and make your changes.
To change Tool Tips. (Changes to Windows settings affect ALL applications)
Windows START, settings, control panel, Display (monitor icon)Retain a copy of your Original Control Display Settings (#BackupDisplay)
Before continuing it might be a good idea to name your current settings and then name your new settings.You can select parts of the windows shown which will change the item selected, but tool tips is not one of them, you have to use the pull down.
- Press [Save As] button then assign the scheme to something like Windows out of the box mmm dd, yyyyy (current date).
- Press [Save As] button then assign your own name to the scheme i.e. “David 2000-06-22”, and all future changes would be made to this scheme.
- In the item: pull down, rather than pulling down you can simply place cursor in the box and then use the cursor to cycle up or down through the choices. Select “Tool Tip” and make changes to font, fontsize, text color, background color as wanted. not sure if you actually will change the fontname or not.
My own settings show: red text, yellow background, 8 point, MS Sans Serif, non bold, non italic. (I'm not sure what they were originally).
Also see entire comment box turns black.
More material on Cell Comments
The color of the tabs is controlled by Windows, you can change the scrollbar setting but it will affect everything in Windows and until Excel 2002 all tabs had to be the same color as the scrollbar. Changes to size of scrollbar will change size of tabs. Changes to color affect both tabs and all scrollbars in Windows (or at least in Office). You can change the fontsize on the sheet tab, but not the font color or font size within the sheet tabs. Before making changes see Retain a copy of your Original Control Display Settings on this page.In Excel 2002 you can color individual worksheet tabs. Here is a tip from Jessica Kovalik in exceltip at Microsoft ’s Office site.
In VBA (for Excel 2002) the equivalent would be:
- Select the sheets you want to color by holding down the CTRL key and clicking the tabs.
- On the Format menu, point to Sheet, and then click Tab Color. You can also right-click the sheet tab and then click Tab Color.
- Click the color you want, and click OK.
Activesheet.Tab.ColorIndex = 50I believe the normal reason to color tabs is to provide an organization to them. You can sort sheet tabs with a macro. You can enhance your sorted arrangement by preceding the sheet tab with some less conspicuous small letters prefixes. i.e.
k.FunctKeys, k.ShortCutKeys
If working with dates for sheetnames, spell the year out and place it first
2002-10, 2002-11, 2002-12, 2003-01
sort sheet tabs into alphabetical order in http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets
The main topic on that page is to create a Table of Contents with hyperlinks to the other sheets. Shorter versions with just membernames can be found in buildtoc.htm. A builtin alternative to navigate to a sheet via the More Sheets dialog listing (also available from a macro) is to right-click on a scrolling arrow in lower left corner, the sheets are listed in the same order as the worksheet tabs at the bottom of your spreadsheet (another reason to sort your worksheets).
Sort sheets by color of sheet tab, by colorindex number, Chip Pearson's sortws.htmThere is one problem that I know of with the arrangement of sheet tabs. You will probably have trouble with Mail Merge if the worksheet to be used in Mail Merge is not the first worksheet.
You can go through 90 worksheets very quickly using Ctrl+PageDn to go down through the worksheet tabs, or Ctrl+PageUp to backup through the tabs. I prefer to use a couple of macros and toolbar buttons –
Printing the comment indicator by aligning a shape over the upper right corner of cells with comments. see Print Worksheet with Comment Indicators (contextures.com)
- Red , upper-right corner of a cell indicates a Cell Comment
- Black, upper-left corner of a cell indicates highlight changes: Tools, Track changes, Highlight Changes
- Green, upper-left corner of a cell indicates a potential error in the formula in the cell. To turn off or adjust settings: select Tools, Options, and select the Error Checking (tab) and uncheck "Clear the Enable Background Error Checking". [new in Excel 2002 (dead link at MS]and you can change the color of error indicator triangle there as well. Not shown if Track Changes is also in effect.
- Purple, lower-right corner of a cell indicates a smart tag. [new in Excel 2002 (XP)] to turn off or adjust settings: select Tools, Options, and select the Error Checking tab. [more]
Setting the interior color of the active cell, specifically Applies to all cells in a selection that you can add to with the use of the Ctrl key.
Format --> cells --> patterns and colorsYou can install a button on your toolbar to hasten the process, it looks like a dripping paint can.
View --> customize --> toolbars --> custom --> format
select the dripping paint bucked, marked Fill Color and drag it to your toolbar (if not already there).
You can color code cells or text to help with reading and/or to help with data entry. Please keep in mind that laptops and color-blind people may not see colors the same as you do.
Related: Conditional Formatting, Format/Styles, Filtering, Tracking
- Pale color shading can be used to designate input areas, and can be expanded to different colors for input from different areas (departments).
- Formula results might be shown with a different text color, and the formulas themselves and other non-input areas such as descriptions might be protected from accidental changes.
- Cells with links will generally show up in blue or purple with underlining. Best not to change what people expect.
- Highlight cells for review that you modified or find questionable. Change them back at a later time. Also see tracking in Highlight changes.
Refer to RGB Hex Triplet Color Chart for Douglas R. Jacobson ’s charts. [ http://homepage.mac.com/jakesan/DHP/page0/page2/page2.html]Hex Color Chart for the HTML Resource Guide for a faster loading variation of Jacobson ’s hex chart by Jack Wilson. [http://www.bitmedia.com/colors/] It ’s faster because it uses tables with BGCOLOR instead of a lot of bit maps. [ archived copy]
Color Chart at Alan Barasch ’s Excel site has a slider to change the background color so you can check combinations of cell colors in foreground to varied background colors in HTML. Pretty neat. He also has a similar Font Color Chart (text background), and Color Chart (page background) a slider to change cell background color. (Charts and sliders each have 216 colors) Works only in Internet Explorer, but is one of the easiest to use.
6X6X6 Netscape Color Palette Map
Web colors - Wikipedia, the free encyclopedia, From Wikipedia, the free encyclopedia
cosmin.com - Color Detector, Freeware program to detect the color of any pixel on the screen. Simply run the program, point the mouse cursor anywhere on the screen, and the color detector window will display the RGB values, HTML hex code, and the color name of the color of the pixel pointed to by the mouse cursor. You can invoke the installed .exe link directly with IE, or if using Firefox by invoking through your customized Launchy extension to invoke with Explorer. ( colordector.exe)
If you are using Firefox for browsing HTML you might want to also install Colorzilla extension for working within Firefox – Eyedropper (color sampler, status bar options), ColorPicker, Page Zoomer, DOM inspector (if present). More extensions on my Firefox Customization (Notes) page.
Color Wheel Picker, is similar to Color Detector but works only on its page with a color wheel so you can pick your color (IE active-x only)
Back To Font Web Color Picker, select your colors and create the styles to place into your HTML coding. Also see CSS (Style Sheets) on other references on my Font page.
HTML Colors - Color picker, AMPsoft, displays the hex, dec and RGB values, via taskbar icon or hotkey (is not a detector)
Palette Grabber :: Firefox Add-ons, Creates a color palette for Photoshop, Paint Shop Pro, GIMP, Flash, Fireworks, Paint.NET, or OS X based on the current page.
In color television luminance is calculated (approximately) like this (1 = white, represented by 1V signal voltage):
L = R*0.3+G*0.59+B*0.11This formula was created to make the color video signal compatible with black and white monitors/receivers. Monochrome monitors are still in use as professional viewfinders on many TV cameras, since they create a sharper image than one made from a color matrix. Posted by Harald Staff, plus the reference below.
Poynton ’s Color FAQ, Charles Poynton [alt] [archive] -- see item #9.
- Color Cube (geocities archive), see The JavaScript Source: Image Effects: Basic Color Cube. Show what different background colors (in HTML) would look like from a choice of 216 (18x12) colors.
- Syd Allan: HTML Tag an Color Test Page, has a list of other sites with color information, and has color tables of colors used in SAS.
Not going to go into this in detail here or on the page for the Visual Basic Editor (VBE) Window but you can change the colors in the code window (Alt+F11, F7) for background, font and indicator for each of these texts: Normal, Selection, Syntax Error, Execution Point, Break Point, Comment, Keyword, Identifier, Bookmark, and Call Return. [VBE Tools menu, Options, Editor Format (tab) ]
There are bookmarklets (JavaScript code) that are stored as bookmarks that can be run in all browsers, but specific bookmarklets may be limited to one browser due to limitations in a browser. There are several webpages with bookmarklets that involve color at squarefree.com, specifically Color Bookmarklets and Bookmarklets for Zapping Annoyances.
- Changing Font color for certain words within a cell, Dave Peterson, macro, 2003-05-28 [also see Font page]
- Color, Sorting on Color, not recommended, at least not in any Excel through Excel 2000, but the topic does come up.
- A Color Picker Dialog Box, John Walkenbach, Tip49. An alternative to not being able to determine the current selected color in the color palette dialog boxes (xlDialogColorPalette).
- Coloring within Ranges, Examples
- Color Palette Generator, degraeve, Enter the URL of an image to get a color palette (10 colors) that matches the image. Useful in creating a website color palette that matches a key image to be used for a website. [referened by Favicon Generator]
- Color Tools, links provided at Univ. Of Minnesota
- Conditional Formatting was introduced with Excel 97 and is a terrific feature, but there is a limit of 3 conditional sets per cell grouping (like 3 wishes). Conditional Formatting, while in effect for a cell, will override the text colors that can be produced for numeric values by normal cell formatting.
- Conversion to Grayscale, a chapter in a book available online about color Grokking the GIMP by Carey Bunks.
- Jenks Natural Breaks, part of the Virtual Geography Department Project described in Cartography Working Group of the Department of Geography, Dartmouth College.
- Logos and Graphics into headers/footers, you can assign the top rows of your spreadsheet for use as headers to include logos, logos in color, and to include fonts in color. Fonts are available only in one color in the actual headings and footings-- black. For footers you are out of luck as far as alternatives to black.
- Office 2007: Using Color in Excel and PowerPoint, 2007, Excel and PowerPoint provide a number of common colors for quick access from the FILL buttons on the Ribbon. If you prefer to use a different color or a customized color from the dialog color box.
- Security hardware encryption, terms for similar information: cryptography, encryption, stenography, digital watermarks
- Restore Hyperlink Style, restore normal hyperlink colors and formatting
- Rowliner «, Chip Pearson. RowLiner add-in allows you have Excel automatically draw row and/or column lines around the active cell, making it easier to view rows and columns, especially when gridlines are not visible. But you lose the ability to use undo (Ctrl+Z) with macros and with addins.
- Setting Colors and Safe Colors in HTML, Dave Raggett's Introduction to CSS (Cascading Style Sheets)
- Using Colors in Excel Charts, PTS Blog, Jon Peltier by Jon Peltier
- Worksheet Change Events, shows changing color of cells upon Change.
- FONT, test for BOLD with ISBOLD(cell) UDF.
- FONTINFO macro on Formula page.
- Can't see font on a black background: When formatting Cell Comment or Text Box format the FONT from the Font tab, changing the line color under the Color Tab will not affect the font. (2004-03-31, McRitchie, misc)
- Printer out of a color of ink.
- File, Page Setup, Sheet, Print B&W — will remove interior color, and will print font, and borders in black. Print Preview shows up same as Printed copy (in black and white).
- Use of a template such as book.xlt and sheet.xlt
- Use of Format, Style can seem like a template was used to set up colors, but can't find any such format. Format, Style, should be normal and no shading
- Colors are only missing on monitor, due to High Contrast Accessibility option. A variation of same problem: The fill color, the fill pattern, or the line color of a WordArt or AutoShape object in an Office document does not change
- Also see companion page – Colors as seen on Monitor, and in Preview and Print, which attempts to show what you might see.
- You see a lot of gray (grey) on the sheet and you may see big page numbers. That would be page break Preview, eliminate with Eliminate with View, Normal
- Excel 2003 apply the Service Pack, can't find anything on printing problems, but have been told it fixes some kind of problem. Always be sure to keep your software updated. Description of the Excel 2003 post-Service Pack 1 hotfix package: February 20, 2005. Though there is a scaling problem with margins print 1 pages wide by 1 pages tall.
- How Printers Work [The PC Technology Guide], referenced in a LockerGnome newsletter 2001-08-08]
- InkJet printers and other types, glossary of color printer terminology
- See how Printer settings of “Print with Black Ink” and page setup -- Sheet -- Print B&W Only. See how these settings affect what you see.
Q97600 Printed Colors Different than on Screen: Blue is Purple, etc. This is not a problem with your printer driver, with Microsoft Windows, or with your printer. RGB colors (light) are additive. CMYK colors (pigments) are subtractive. Color-Matching Blues [PC Magazine Apr 9, 1996].Q149170 - Sample Visual Basic Code to Create Color Index Table
http://support.microsoft.com/?id=149170Q170781 XL: RGB Function May Map to Incorrect Color
The color property accepts an RGB triple and maps it to the nearest color index. When the property retrieves the color value, it returns the RGB color of the index, which may be different from the value you typed. In the example, RGB(65,0,0) is mapped to Dark Red (RGB(128,0,0)), but RGB(64,0,0) is mapped to Black (RGB(0,0,0)).
Q157202 - XL97: Color Palette Looks Different in MS Excel 97
http://support.microsoft.com/?id=157202
Q211533 - XL2000: Color Palette Looks Different in Microsoft Excel 2000
http://support.microsoft.com/?id=211533
Q291293 - XL2002: Color Palette Looks Different in Microsoft Excel 2002
http://support.microsoft.com/?id=291293288412 XL2002: How to Change the Color Palette for Workbooks
Q163230 - Thick Borders May Not Be Printed in Low Printer Resolution (163230) -- When you print thick borders in Microsoft Excel, the borders may be partially printed, or the borders may not be printed at all.
Q320531 -- OFF: Changes to Fill Color and Fill Pattern Are Not Displayed,
Incorrect/missing colors may occur with use of High Contrast under Display tab of Accessibility Options. Colors don't show on monitor however, you may be able to see the changes in print preview and on a printed page. Also see Problems topic.
| MS KB | Term | Article title -- http://support.microsoft.com/kb/ [ref] | Product |
| Q211661 | XL2000: | Black and White Printer Prints Colored Lines As Grayscale | Excel 2000 |
| Q248175 | XL2000: | Border Color of Lines Returns Incorrect RGB Value When Border Color Is Set to Automatic | VBA |
| Q176839 | XL: | Buttons on Toolbar Created in Earlier Version May Lose Color | Excel |
| Q211650 | XL2000: | Cannot Change Fill Color for Walls or Floor on 3-D Chart | Excel 2000 |
| Q214312 | XL2000: | Cannot Change Series Colors on a Surface Chart | Excel 2000 |
| Q95478 | XL: | Can't Print Color Headers and Footers | Excel |
| Q212746 | XL: | Cell Fill Color Bleeds into Adjacent Cells When Viewed in Web Browser | Excel |
| Q82015 | XL: | Changing Series Colors on a Surface Chart | Excel |
| Q211533 | XL2000: | Color Palette Looks Different in Microsoft Excel 2000 | VBA |
| Q229006 | XL: | Colors in HTML File Don't Appear as Expected When Opening Page in Excel | Excel |
| Q134261 | XL: | Data Map Colors Lost When File Exported to Macintosh | Excel |
| Q211828 | XL2000: | Fill Colors May Be Saved Incorrectly with WK3 File | Excel 2000 |
| Q214097 | XL2000: | Header or Footer Is Not Printed in Color | Excel 2000 |
| Q202355 | XL2000: | Hyperlink Colors Don't Show Expected Color Format | Excel 2000 |
| Q213191 | XL2000: | Modules Cannot Be Printed in Color | Excel 2000 |
| Q173083 | XL: | Modules Cannot Be Printed in Color | VBA |
| Q213201 | XL2000: | RGB Function May Map to Unexpected Color | VBA |
| Q213801 | XL: | Sample Visual Basic Code to Create Color Index Table | Excel |
| Q214353 | XL2000: | Toolbar Buttons Created in Earlier Version May Lose Color | Excel 2000 |
| Q211728 | XL2000: | Trendline Equation Label Does Not Use the Specified Color | Excel 2000 |
| Q211677 | XL2000: | Unexpected Font or Color Formatting Applied to Chart | Excel 2000 |
| Q213688 | XL2000: | Using ColorIndex Property to Set Color of Borders Results in Unexpected Behavior | VBA |
ColorIndex Property, article within Office Web Components in MSDN (shows the color palette).
Please send your comments concerning this web page to: David McRitchie send email comments
Copyright © 1997 - 2011 , F. David McRitchie, All Rights Reserved


Doing the most we can for our local community!
We cooperate with many different performing artists and create our own movies to learn more about the performing arts!
We host a tournament every year!
Click the arrows on the side to view another club, and join one of them today by clicking the club's name on the club profiles page to get to their description!


Hecke operators#
- class sage.modular.hecke.hecke_operator.DiamondBracketOperator(parent, d)#
Bases:
HeckeAlgebraElement_matrix
The diamond bracket operator \(\langle d \rangle\) for some \(d \in \ZZ / N\ZZ\) (which need not be a unit, although if it is not, the operator will be zero).
- class sage.modular.hecke.hecke_operator.HeckeAlgebraElement(parent)#
Bases:
AlgebraElement
Base class for elements of Hecke algebras.
- apply_sparse(x)#
Apply this Hecke operator to x, where we avoid computing the matrix of x if possible.
EXAMPLES:
sage: M = ModularSymbols(11) sage: T = M.hecke_operator(23) sage: T.apply_sparse(M.gen(0)) 24*(1,0) - 5*(1,9)
- charpoly(var='x')#
Return the characteristic polynomial of this Hecke operator.
INPUT:
var
- string (default: ‘x’)
OUTPUT: a monic polynomial in the given variable.
EXAMPLES:
sage: M = ModularSymbols(Gamma1(6),4) sage: M.hecke_operator(2).charpoly('x') x^6 - 14*x^5 + 29*x^4 + 172*x^3 - 124*x^2 - 320*x + 256
- codomain()#
The codomain of this operator. This is the Hecke module associated to the parent Hecke algebra.
EXAMPLES:
sage: R = ModularForms(Gamma0(7), 4).hecke_algebra() sage: sage.modular.hecke.hecke_operator.HeckeAlgebraElement(R).codomain() Modular Forms space of dimension 3 for Congruence Subgroup Gamma0(7) of weight 4 over Rational Field
- decomposition()#
Decompose the Hecke module under the action of this Hecke operator.
EXAMPLES:
sage: M = ModularSymbols(11) sage: t2 = M.hecke_operator(2) sage: t2.decomposition() [ Modular Symbols subspace of dimension 1 of Modular Symbols space of dimension 3 for Gamma_0(11) of weight 2 with sign 0 over Rational Field, Modular Symbols subspace of dimension 2 of Modular Symbols space of dimension 3 for Gamma_0(11) of weight 2 with sign 0 over Rational Field ]
sage: M = ModularSymbols(33, sign=1).new_submodule() sage: T = M.hecke_operator(2) sage: T.decomposition() [ Modular Symbols subspace of dimension 1 of Modular Symbols space of dimension 6 for Gamma_0(33) of weight 2 with sign 1 over Rational Field, Modular Symbols subspace of dimension 1 of Modular Symbols space of dimension 6 for Gamma_0(33) of weight 2 with sign 1 over Rational Field ]
- det()#
Return the determinant of this Hecke operator.
EXAMPLES:
sage: M = ModularSymbols(23) sage: T = M.hecke_operator(3) sage: T.det() 100
- domain()#
The domain of this operator. This is the Hecke module associated to the parent Hecke algebra.
EXAMPLES:
sage: R = ModularForms(Gamma0(7), 4).hecke_algebra() sage: sage.modular.hecke.hecke_operator.HeckeAlgebraElement(R).domain() Modular Forms space of dimension 3 for Congruence Subgroup Gamma0(7) of weight 4 over Rational Field
- fcp(var='x')#
Return the factorization of the characteristic polynomial of this Hecke operator.
EXAMPLES:
sage: M = ModularSymbols(23) sage: T = M.hecke_operator(3) sage: T.fcp('x') (x - 4) * (x^2 - 5)^2
- hecke_module_morphism()#
Return the endomorphism of Hecke modules defined by the matrix attached to this Hecke operator.
EXAMPLES:
sage: M = ModularSymbols(Gamma1(13)) sage: t = M.hecke_operator(2) sage: t Hecke operator T_2 on Modular Symbols space of dimension 15 for Gamma_1(13) of weight 2 with sign 0 over Rational Field sage: t.hecke_module_morphism() Hecke module morphism T_2 defined by the matrix [ 2 0 0 0 0 0 0 1 0 0 1 0 0 0 0] [ 0 2 0 1 0 1 0 0 -1 0 0 0 0 0 1] [ 0 1 2 0 0 0 0 0 0 0 0 -1 1 0 0] [ 1 0 0 2 0 -1 1 0 1 0 -1 1 -1 0 0] [ 0 0 1 0 2 0 -1 0 0 0 0 0 0 0 0] [ 0 0 0 0 0 0 0 0 0 0 0 1 -2 2 -1] [ 0 0 0 0 0 2 -1 0 -1 0 0 0 0 1 0] [ 0 0 0 0 1 0 0 2 0 0 0 0 0 0 -1] [ 0 0 0 0 0 1 0 0 -1 0 2 -1 0 2 -1] [ 0 0 0 0 0 1 1 0 0 -1 0 1 -1 2 0] [ 0 0 0 0 0 2 0 0 -1 -1 1 -1 0 1 0] [ 0 0 0 0 0 1 1 0 1 0 0 0 -1 1 0] [ 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0] [ 0 0 0 0 0 1 0 0 1 -1 2 0 0 0 -1] [ 0 0 0 0 0 0 0 0 0 1 0 -1 2 0 -1] Domain: Modular Symbols space of dimension 15 for Gamma_1(13) of weight ... Codomain: Modular Symbols space of dimension 15 for Gamma_1(13) of weight ...
- image()#
Return the image of this Hecke operator.
EXAMPLES:
sage: M = ModularSymbols(23) sage: T = M.hecke_operator(3) sage: T.fcp('x') (x - 4) * (x^2 - 5)^2 sage: T.image() Modular Symbols subspace of dimension 5 of Modular Symbols space of dimension 5 for Gamma_0(23) of weight 2 with sign 0 over Rational Field sage: (T-4).image() Modular Symbols subspace of dimension 4 of Modular Symbols space of dimension 5 for Gamma_0(23) of weight 2 with sign 0 over Rational Field sage: (T**2-5).image() Modular Symbols subspace of dimension 1 of Modular Symbols space of dimension 5 for Gamma_0(23) of weight 2 with sign 0 over Rational Field
- kernel()#
Return the kernel of this Hecke operator.
EXAMPLES:
sage: M = ModularSymbols(23) sage: T = M.hecke_operator(3) sage: T.fcp('x') (x - 4) * (x^2 - 5)^2 sage: T.kernel() Modular Symbols subspace of dimension 0 of Modular Symbols space of dimension 5 for Gamma_0(23) of weight 2 with sign 0 over Rational Field sage: (T-4).kernel() Modular Symbols subspace of dimension 1 of Modular Symbols space of dimension 5 for Gamma_0(23) of weight 2 with sign 0 over Rational Field sage: (T**2-5).kernel() Modular Symbols subspace of dimension 4 of Modular Symbols space of dimension 5 for Gamma_0(23) of weight 2 with sign 0 over Rational Field
- trace()#
Return the trace of this Hecke operator.
sage: M = ModularSymbols(1,12) sage: T = M.hecke_operator(2) sage: T.trace() 2001
- class sage.modular.hecke.hecke_operator.HeckeAlgebraElement_matrix(parent, A)#
Bases:
HeckeAlgebraElement
An element of the Hecke algebra represented by a matrix.
- matrix()#
Return the matrix that defines this Hecke algebra element.
EXAMPLES:
sage: M = ModularSymbols(1,12) sage: T = M.hecke_operator(2).matrix_form() sage: T.matrix() [ -24 0 0] [ 0 -24 0] [4860 0 2049]
- class sage.modular.hecke.hecke_operator.HeckeOperator(parent, n)#
Bases:
HeckeAlgebraElement
The Hecke operator \(T_n\) for some \(n\) (which need not be coprime to the level). The matrix is not computed until it is needed.
- index()#
Return the index of this Hecke operator, i.e., if this Hecke operator is \(T_n\), return the int \(n\).
EXAMPLES:
sage: T = ModularSymbols(11).hecke_operator(17) sage: T.index() 17
- matrix(*args, **kwds)#
Return the matrix underlying this Hecke operator.
EXAMPLES:
sage: T = ModularSymbols(11).hecke_operator(17) sage: T.matrix() [18 0 -4] [ 0 -2 0] [ 0 0 -2]
- matrix_form()#
Return the matrix form of this element of a Hecke algebra.
sage: T = ModularSymbols(11).hecke_operator(17) sage: T.matrix_form() Hecke operator on Modular Symbols space of dimension 3 for Gamma_0(11) of weight 2 with sign 0 over Rational Field defined by: [18 0 -4] [ 0 -2 0] [ 0 0 -2]
- sage.modular.hecke.hecke_operator.is_HeckeAlgebraElement(x)#
Return True if x is of type HeckeAlgebraElement.
EXAMPLES:
sage: from sage.modular.hecke.hecke_operator import is_HeckeAlgebraElement sage: M = ModularSymbols(Gamma0(7), 4) sage: is_HeckeAlgebraElement(M.T(3)) True sage: is_HeckeAlgebraElement(M.T(3) + M.T(5)) True
- sage.modular.hecke.hecke_operator.is_HeckeOperator(x)#
Return True if x is of type HeckeOperator.
EXAMPLES:
sage: from sage.modular.hecke.hecke_operator import is_HeckeOperator sage: M = ModularSymbols(Gamma0(7), 4) sage: is_HeckeOperator(M.T(3)) True sage: is_HeckeOperator(M.T(3) + M.T(5)) False


Version:
Queued by:
Completed:
Test Site:
New Deployment:
Do not restore
Production
Release
Development
Master
Start Deployment


Moses Sumney announces new double album, shares “Virile”
by Andrew SacherMoses Sumney has announced a followup to his great 2017 debut album Aromanticism. As Pitchfork points out, it’s a double album called græ, and it will be released in two parts. The first part comes out digitally in February 2020, and the second part (and physical release) comes out May 15 via Jagjaguwar. The first single is “Virile,” which is clearly a step forward for Moses and finds him taking his sound in directions he’s never gone before. It’s a pretty wild song, and it comes with a self-directed video which is Moses’ directorial debut. Check it out, along with the tracklist, below.
Tracklist
Part 1:
01 Insula
02 Cut Me
03 In Bloom
04 Virile
05 Conveyor
06 boxes
07 Gagarin
08 jill/jack
09 Colouour
10 also also also and and and
11 Neither/Nor
12 Polly
Part 2:
13 Two Dogs
14 Bystanders
15 Me in 20 Years
16 Keeps Me Alive
17 Lucky Me
18 and so I come to isolation
19 Bless Me
20 before you go


Click in the box to focus caret position then save button to save caret position, then click delete html, then click restore html and finally click restore position to see caret position restored
save position
delete html
restore html
restore position


If we cannot get accurate information, then people cannot solve problems together. If people cannot agree on what the problems are, how widespread they are, and how effective various solutions are, they will not be able to work on making life better for everyone. If we as a people do not make any progress, then the people who stand to gain from the current system continue to benefit. When no one can agree on how to solve problems, then the people who benefit from the existence of the problems will continue to receive those benefits.
in-context


Habitnator
Starting app
Habitnator
Add
Add Habit
What habit are you targeting?
Your goal is to:
Stop this habit
Improve this habit
How many times a day would be ideal:
How do you measure this habit?


|
attys-comm
|
#include <AttysCommBase.h>
Static Public Member Functions | |
| static float | phys2temperature (float volt) |
Public Attributes | |
| const std::string | CHANNEL_DESCRIPTION [NCHANNELS] |
| const std::string | CHANNEL_SHORT_DESCRIPTION [NCHANNELS] |
| const std::string | CHANNEL_UNITS [NCHANNELS] |
| const int | ADC_GAIN_FACTOR [7] = { 6, 1, 2, 3, 4, 8, 12 } |
| const float | ADC_REF = 2.42F |
| const float | oneG = 9.80665F |
| const float | ACCEL_FULL_SCALE [4] = { 2 * oneG, 4 * oneG, 8 * oneG, 16 * oneG } |
| const float | MAG_FULL_SCALE = 4800.0E-6F |
Static Public Attributes | |
| static const int | NCHANNELS = 10 |
| static const int | nMem = 1000 * 10 |
| static const int | INDEX_Acceleration_X = 0 |
| static const int | INDEX_Acceleration_Y = 1 |
| static const int | INDEX_Acceleration_Z = 2 |
| static const int | INDEX_Magnetic_field_X = 3 |
| static const int | INDEX_Magnetic_field_Y = 4 |
| static const int | INDEX_Magnetic_field_Z = 5 |
| static const int | INDEX_Analogue_channel_1 = 6 |
| static const int | INDEX_Analogue_channel_2 = 7 |
| static const int | INDEX_GPIO0 = 8 |
| static const int | INDEX_GPIO1 = 9 |
| static const int | ADC_RATE_125HZ = 0 |
| static const int | ADC_RATE_250HZ = 1 |
| static const int | ADC_RATE_500HZ = 2 |
| static const int | ADC_DEFAULT_RATE = ADC_RATE_250HZ |
| static const int | ADC_SAMPLINGRATE [4] |
| static const int | ADC_GAIN_6 = 0 |
| static const int | ADC_GAIN_1 = 1 |
| static const int | ADC_GAIN_2 = 2 |
| static const int | ADC_GAIN_3 = 3 |
| static const int | ADC_GAIN_4 = 4 |
| static const int | ADC_GAIN_8 = 5 |
| static const int | ADC_GAIN_12 = 6 |
| static const int | ADC_CURRENT_6NA = 0 |
| static const int | ADC_CURRENT_22NA = 1 |
| static const int | ADC_CURRENT_6UA = 2 |
| static const int | ADC_CURRENT_22UA = 3 |
| static const int | ADC_MUX_NORMAL = 0 |
| static const int | ADC_MUX_SHORT = 1 |
| static const int | ADC_MUX_SUPPLY = 3 |
| static const int | ADC_MUX_TEMPERATURE = 4 |
| static const int | ADC_MUX_TEST_SIGNAL = 5 |
| static const int | ADC_MUX_ECG_EINTHOVEN = 6 |
| static const int | ACCEL_2G = 0 |
| static const int | ACCEL_4G = 1 |
| static const int | ACCEL_8G = 2 |
| static const int | ACCEL_16G = 3 |
| static const int | MESSAGE_CONNECTED = 0 |
| static const int | MESSAGE_ERROR = 1 |
| static const int | MESSAGE_TIMEOUT = 7 |
| static const int | MESSAGE_RECONNECTED = 8 |
| static const int | MESSAGE_RECEIVING_DATA = 9 |
Platform independent definitions for the Attys
| AttysCommBase::AttysCommBase | ( | ) |
Constructor which is overloaded by AttysComm.
|
virtual |
Destructor which releases memory and closes any open connection.
|
pure virtual |
Closes the socket safely.
Implemented in AttysComm.
|
pure virtual |
Connects to the Attys by opening the socket. Throws char* exception if it fails.
Implemented in AttysComm.
|
inline |
Switches bias currents on
|
inline |
Returns the accelerometer current full scale reading in m/s^2.
|
inline |
Gets the sampling rate in form for the index.
|
inline |
Gets the ADC full range. This depends on the gain setting of the ADC.
|
inline |
Returns the name of the Attys
|
inline |
Gets the bias current as in index.
|
pure virtual |
returns the MAC address as a string.
Implemented in AttysComm.
|
pure virtual |
Returns an array of 14 bytes of the bluetooth address.
Implemented in AttysComm.
|
inline |
Charging indicator. Returns one if charging.
|
inline |
Returns the full scale magnetometer in Tesla.
| sample_p AttysCommBase::getSampleFromBuffer | ( | ) |
Gets a sample from the ringbuffer. This is a float* array of all channels.
|
inline |
Gets the sampling rate in Hz (not index number).
|
inline |
Returns one if the connection is active.
|
inline |
Is set to one if samples are available in the ringbuffer.
|
inlinestatic |
Temperature
| void AttysCommBase::quit | ( | ) |
Call this from the main activity to shut down the connection.
|
inline |
Register a realtime callback function which is called whenever a sample has arrived. AttysCommListener is an abstract class which needs to implement hasSample().
|
inline |
Callback which is called whenever a special error/event has occurred.
|
inline |
Resets the ringbuffer to zero content.
|
inline |
Sets the accelerometer full scale range using the index.
|
inline |
Gets the gain index for ADC1.
|
inline |
Gets the gain index for ADC2.
|
inline |
Sets the sampling rate using the sampling rate index numbers.
|
inline |
Sets the name of the Attys
|
inline |
Sets the bias current which can be switched on.
|
inlinevirtual |
Starts the data acquisition by starting the main thread. and sending possibly init commands.
Reimplemented in AttysComm.
|
inline |
Unregister the realtime sample callback.
|
inline |
Unregister the error/event callback.
|
static |
Setting full scale range of the accelerometer to 16G.
|
static |
Setting full scale range of the accelerometer to 2G.
|
static |
Setting full scale range of the accelerometer to 4G.
|
static |
Setting full scale range of the accelerometer to 8G.
Mapping of the index to the full scale accelerations.
|
static |
Bias current of 22nA.
|
static |
Bias current of 22uA.
|
static |
Bias current of 6nA.
|
static |
Bias current of 6uA.
|
static |
Constant defining the default sampling rate (250Hz).
|
static |
Gain index setting it to gain 6.
|
static |
Gain index setting it to gain 6.
|
static |
Gain index setting it to gain 2.
|
static |
Gain index setting it to gain 3.
|
static |
Gain index setting it to gain 4.
|
static |
Gain index setting it to gain 6.
|
static |
Gain index setting it to gain 5.
| const int AttysCommBase::ADC_GAIN_FACTOR[7] = { 6, 1, 2, 3, 4, 8, 12 } |
Mmapping between index and actual gain.
|
static |
Muliplexer routing: both positive ADC inputs are connected together.
|
static |
Muliplexer routing is normal: ADC1 and ADC2 are connected to the sigma/delta.
|
static |
Muliplexer routing: inputs are short circuited.
|
static |
Muliplexer routing: inputs are connected to power supply.
|
static |
Muliplexer routing: ADC measures internal temperature.
|
static |
Muliplexer routing: ADC measures test signal.
|
static |
Constant defining sampling rate of 125Hz.
|
static |
Constant defining sampling rate of 250Hz.
|
static |
Constant defining sampling rate of 500Hz (Attys2 only).
| const float AttysCommBase::ADC_REF = 2.42F |
The voltage reference of the ADC in volts.
|
static |
Array of the sampling rates mapping the index to the actual sampling rate.
| const std::string AttysCommBase::CHANNEL_DESCRIPTION[NCHANNELS] |
Long descriptions of the channels.
| const std::string AttysCommBase::CHANNEL_SHORT_DESCRIPTION[NCHANNELS] |
Short descriptions of the channels.
| const std::string AttysCommBase::CHANNEL_UNITS[NCHANNELS] |
Units of the channels.
|
static |
Channel index for X Acceleration.
|
static |
Channel index for Y Acceleration.
|
static |
Channel index for Z Acceleration.
|
static |
Index of analogue channel 1.
|
static |
Index of analogue channel 2.
|
static |
Index of the internal GPIO pin 1.
|
static |
Index of the internal GPIO pin 2.
|
static |
Magnetic field in X direction.
|
static |
Magnetic field in Y direction.
|
static |
Magnetic field in Z direction.
| const float AttysCommBase::MAG_FULL_SCALE = 4800.0E-6F |
Full scale range of the magnetometer in Tesla.
|
static |
Message callback: Connected.
|
static |
Message callback: Generic error.
|
static |
Message callback: Receiving data. One off once the connection has been set up.
|
static |
Message callback: Managed to reconnect.
|
static |
Message callback: Reception timeout detected by the watchdog.
|
static |
Total number of channels per samples.
|
static |
Number of entries in the ringbuffer. Buffer for 10secs at 1kHz.
| const float AttysCommBase::oneG = 9.80665F |
One g in m/s^2.


Our Premium Workshops
Drone
Workshop on Flying Objects
Learn to build your first drone
24 Dec
SuKyi Block 3rd Floor
Competitive Coding
Workshop on Programming
Code, Compile and Run
23 Dec
Main Building 4TH FLOOR
Workshop on Flying Objects
Learn to build your first drone
Workshop on Programming
Code, Compile and Run


--- layout: post status: publish published: true title: 5/27/08 Notes author: display_name: Corey Fineran login: Corey email<EMAIL_ADDRESS>url: '' author_login: Corey author_email<EMAIL_ADDRESS>excerpt: "* This homestand was just great. At the beginning of the homestand, the Cubs were 2 games behind the Cardinals. After going 8-2, the Cubbies are now 2 games up. The most remarkable aspect of this homestand was " wordpress_id: 78 wordpress_url: http://ivyenvy.wordpress.com/?p=78 date: '2008-05-19 18:43:19 +0000' date_gmt: '2008-05-19 18:43:19 +0000' categories: - General Baseball - Infield - Minor Leagues - Offense - Outfield - The Cubs tags: - Alfonso Soriano - Astros - Cardinals - Daryle Ward - Derek Lee - DL - Houston - Jim Edmonds - Micah Hoffpauir - NL Player of the Week - Optimism - Roy Oswalt - Spring Training - Triple A Iowa comments: [] ---
* This homestand was just great. At the beginning of the homestand, the Cubs were 2 games behind the Cardinals. After going 8-2, the Cubbies are now 2 games up. The most remarkable aspect of this homestand was Alfonso Soriano. In those 10 games, Soriano batted .525 with 7 HR and 16 RBI's. So it's no surprise that he was named the NL Player of the Week.
* So the Cubs leave the Friendly Confines and head South to play the Astros. The Astros are 12-4 in May. They typically don't play this well until their annual August/September surge. I never speak too optimistically about the Cubs, but I feel like the Cubs are going to go into Houston and expose these guys as pretenders. If the Cubs lose this series, I will never publicly speak optimistically about the Cubs again.
* Jim Edmonds will most likely start all three games in Houston, as the Cubs will face three lefties. This means they avoid Roy Oswalt. I am real interested in what Edmonds can do for the Cubs with some consistent playing time.
* Daryle Ward was placed on the DL and Micah Hoffpauir was brought up from Triple A Iowa. Hoffpauir had a great Spring Training, but sat out the first month of the season with an injury. In 9 games, he is batting .324 with 3 HR and 12 RBI's. He made an appearance in yesterdays game and was struckout. Hoffpauir is no spring chicken. He's 28 years old and has been plagued with injuries. Perhaps the Cubs are showcasing him for a potential trade. I'm not sure there's much guaranteed playing time for a first baseman with a team that has Derek Lee.


Personal
I am a recent Greenwich University graduate student in the BSc (Hons) Web Technologies with a great passion for web development and design.
My aim is to increase my current skills and develop personally and professionally as a web developer.
I am an enthusiastic and flexible person and I can use my technical and personal skills in order to learn and adapt myself to new technologies.
 Skills
HTML, CSS, Bootstrap.
PHP, Java Script.
C#, ASP.NET.
MS SQL, MySQL and web hosting.
Audio, image and video editing using MS Movie Maker or Adobe Photoshop
PowerPoint – producing beautiful presentations
Personal portfolio built in Wix, theme: Computer Services and Technical Support
Small projects built in Java Script and CSS events, transition and hover effects
Staff portal: css transition hover effects, opacity, accordions, login/signup/update/ajax search
Bibliotherapy website that a provides a messaging system, email notifications and pdf books reading
Built in C#, ASP.NET, this website helps people with setting notes, reminders, browsing links.
Built in C#, this desktop application provides a basic calculator and two guessing games.
Using Photoshop, the name has been cut and a broken window background has been added.
Using Photoshop and Java Script to transit between green and blue colors.
Using Photoshop, the car has been inserted inside black and white background.
Using Photoshop, the name has been cut and a broken window background has been added.
The Diablo hunter has been photoshopped to the Battlefield background.


{% extends 'home/base.html' %} {% block content %}
We spend so much time working with excel. Why not create some automation techniques to help improve our daily lives?


LEGENDS OF THE FALL A film review by Stan Sawyer Copyright 1995 Stan Sawyer
I am entirely infuriated. I have just watched the movie LEGENDS OF THE FALL.  Not that the cinematography had any problems. Just the scriptwriter and the director who thought that this was any more that a reflection of the worst of our own time.
Here is Tristan, a rugged individualist, who cares nothing for anyone but himself and his own grief. Now, don't get me wrong here: he has plenty to grieve in the death of this brother and the loss and regain of a mate. But his answer is self-pitying revenge and mourning.
I understand the necessity of mourning as much as any man. Yes, I mean man since it is men in our society who have this particular problem with grief. I have been as stuck in my own grief as anyone I know. I am certain that my desire to move beyond this grief into new relationships and self-understanding is at least one of the reasons that I find this movie so revolting.
Tristan, refuses to face his own grief. Instead, he first is a good student, then good at his vocation (rancher?), then ignores the problem (to the point of totally ignoring triggers like the cow caught in barbed-wire), then throws himself into his sadness (by throwing himself into the arms of his dead brothers mate), then runs away in search of distractions from his mourning, then gets caught up in enterprise. Finally, his "bonded males" (in this case a father and a brother) rescue the man who is still a boy, allowing him to run away one more time from the grief he should be facing.
Tristan asks his father if he has damned everyone around him as well as himself. His father cannot say "no." Only that "I won't allow that."
 I'm tired of a society that allows for two types of men: the business-like ones who ignore their "feelings" and the sensitive ones who totally immerse in the grief and pain of life. It's time to wake up, men. Don't let this sort of media/societal affirmation encourage you to remain stuck in the doldrums of life. Life into and through these experiences. Don't let them be a part of your stuckness! Let them be a part of your healing and awakening to the newness of more complete, less self-absorbed relationships. Let them give rise to a new you who can "be all that you can be" in ways that you never imagined.
Tristan wrestles with a bear in the final scene. The narrator tells us that this was a good death. He is wrong. Wrestling with our "nature" in our own death throes is not good. Good would mean some manner of comming to resolution with our own sense of self. Leaving the nature-wrestling, self-absorbed, dying self behind and becoming the fullness of the nature-loving, self-fulfilling, living self who recognizes now as now and then as then.
LEGENDS OF THE FALL is about losing self. Don't accept this encouragement to die while we are alive. LIVE.
-- Stan Sawyer<EMAIL_ADDRESS>The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews


JS Demo
Name
Weather
Enter your name in the box below
Enter your name:
Submit
Weather in Pittsburgh
ºF
LAST UPDATED:
Toggle Raw Data


Your browser does not support the canvas tag.
JavaScript is required to view the contents of this page.
Source code: stitchies PDialog.js Pmd5.js processing.js
Built with Processing and Processing.js


N |
SFClient\Auth |
|
I |
Authentication | Interface Authentication |
C |
PasswordAuth | Class PasswordAuth |
N |
SFClient |
|
C |
Client | Class Client |
C |
Element | Class Element |
N |
SFClient\Endpoint |
|
C |
Endpoint | Class Endpoint |
N |
SFClient\Exceptions |
|
C |
FailedToAuthenticate | Class FailedToAuthenticate |
N |
SFClient |
|
C |
NPSPClient | Class NPSPClient |
N |
SFClient\Result |
|
C |
BoolResult | Class BoolResult |
C |
Result | Class Result |
C |
SFCreationResult | Class SFCreationResult |
C |
SFObjectResult | Class SFObjectResult |
C |
SFRecordsResult | Class SFRecordsResult |
N |
SFClient\SalesForce |
|
C |
ReconnectingSFAPIClient | Class ReconnectingSFAPIClient |
C |
SFAPIClient | Class SFAPIClient |
C |
SFCreation | Class SFCreation |
C |
SFObject | Class SFObject |
C |
SFRecords | Class SFRecords |
C |
ScopedSFAPIClient | Class ScopedSFAPIClient |


A serious of multiple-choice questions with a timer. Each wrong answer will penalize your score time by ten second. Let's get ready to rumble!
Your final score is