Page last modified 12:45, 13 Mar 2009 by rberinger
Table of contents
Testing some ideas -- please add your thoughts or suggestions!
| Calc inside calc | Sum | Average | Max | Min | Log | Cos | Count | Row calculations | ||
| A | 1 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 83.00 (total row 1) |
| B | 1 | 13.333 | 14.2 | 15 | 16 | 17 | 18 | 19 | 20 | 157.53 (total row 2) |
| C | 1 | 23.333 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 3.00 (row 3, column 2) |
| D | -22 | |||||||||
| E | ||||||||||
| F | -22 (row 3, column 2 - row 3, column 5) | |||||||||
| G | ||||||||||
| H | ||||||||||
| I | $19.00 | $39.67 | 14.07 | 25.00 | 6.00 | 3.93182563272433 | -0.82930983286315 | 9 |
Calculation: Multiply two values from two colums
| Value 1 | Value 2 | Multiply |
|---|---|---|
| 20 | 10 | 200 |
| 20 | 4 | 80 |
| 15 | 2 | 30 |
|
|
I failed sorry...could you help? (Spider)
To explore:
- Use page.xml instead of wiki.page
- Is there a way to figure out the column number dynamically? (ie, instead of having to put [#] in xpath)
- Put into template (calc, range1, range2, numformat) -- need more ranges?
- Can we put a calculation inside of a calculation? (ie, see "calc inside calc" column above)
- Most frequently used calculations
- Sum -- list.sum()
- Average -- list.average()
- Count
- Min -- list.min()
- Max -- list.max()
- Cell lookup (ie, =B6)
- Other useful calculations/features
- Concatenate
- Named ranges
- Style rules
- Integrate with one of the ajax sorting scripts
- Google charts example
- Calculations provided by DekiScript currently
- Date functions
- list.apply() -- multiply, divide
- list.average()
- list.max()
- list.min()
- list.sum()
- Number functions
- String.eval()
- Tag page
- What links here
Images 0
You must login to post a comment.