Welcome Megan, I suspect that this is doable, but perhaps not in the way you're thinking. I have no experience with Google Spreadsheets, but I don't think there is any way to modify data or trigger macros attached to the sheets via the Visualization query API. What you could try, though, is setting up the calculations server-side in PHP or client-side in javascript, though if you're new to coding, then javascript is probably easier to work with. I took a quick look at the wiki entry you posted, and I *think* it requires some functions not explicitly provided by javascript, but it doesn't look like there's anything you *can't* do in js (with some custom functions) either.
Mozilla has very good javascript reference documentation: https://developer.mozilla.org/en/JavaScript/Reference, in particular you may have need of the Math object: https://developer.mozilla.org/en/JavaScript/Reference/Global_Objects/Math http://www.jsfiddle.net/ is a good place to play around with javascript to test things out (and you can save your code to share with others if you find something vexing or have a brilliant idea). Google's Visualization Playground ( http://code.google.com/apis/ajax/playground/?type=visualization) lets you experiment with the various kinds of charts, examine the different ways they can be constructed, and see what the options do. Googling "javascript tutorial" will get you a bunch of resources, though I would recommend against anything from W3Schools - they are often vague, incomplete, or just plain wrong about the subjects they purport to be experts in. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/qhUBk08GcUEJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
