Welcome to the Tclers Wiki! Ruby Programming Language Sputnik: Sputnik Sightings Some web sites based on Sputnik. Summarize Spreadsheet Data With Excel's Array Formulas Excel Data Management Subtotals can reveal very useful management information. For example, managers might be interested to learn that sales increased by 10% last month. But they would be fascinated to learn that Pat Smith's sales of Widgets in the Northwest region doubled last month, while the sales of all other people fell sharply. Array formulas provide a way by which Excel users can discover such useful information. Introducing the Data To explain the power of array formulas I'll use this database. I named each column of data with the label shown in row 1. By assigning names in this way we anchor the names in the gray border rows, rows 2 and 15. Introducing Array Formulas, Example 1 Let's begin our examination of this data by summarizing the sales for Jill and Joe. Here's the formula for the cell shown: J3: {=SUM(IF(Seller=$I3,Total,0))} Notice the braces that surround this formula. The formula says that wherever TRUE appears, return the corresponding value from the Total column. Example 2
Lambda the Ultimate | Programming Languages Weblog Sputnik: What is Sputnik? Excel VBA Tutorial - Easy Excel Macros VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro. 2 MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program. 3 Workbook and Worksheet Object: Learn more about the Workbook and Worksheet object in Excel VBA. 4 Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA. 5 Variables: This chapter teaches you how to declare, initialize and display a variable in Excel VBA. 6 If Then Statement: Use the If Then statement in Excel VBA to execute code lines if a specific condition is met. 7 Loop: Looping is one of the most powerful programming techniques. 8 Macro Errors: This chapter teaches you how to deal with macro errors in Excel. 12 Array: An array is a group of variables.
ometa/ OMeta is a new object-oriented language for pattern matching. It is based on a variant of Parsing Expression Grammars (PEGs) which we have extended to handle arbitrary data types. OMeta's general-purpose pattern matching facilities provide a natural and convenient way for programmers to implement tokenizers, parsers, visitors, and tree transformers, all of which can be extended in interesting ways using familiar object-oriented mechanisms. I am about to release a new version of OMeta/Squeak. Documentation The most in-depth and up-to-date piece description of OMeta is in Chapter 2 of my Ph.D. dissertation. There are also some older materials that may be of interest: The original Dynamic Languages Symposium 2007 paper and slides. Downloads There are also several third-party implementations — here are the ones that I know about: Questions? Please e-mail me if you have questions, comments, or suggestions. Click here to return to my home page.
Kepler (software) Kepler also provides the following frameworks: Kepler also provides the following modules: Sputnik is a wiki with embedded Kepler[4]