25 September 2006

XML Feeds For Online Spread Sheets, Critical Conditions, Audits

If you've noticed Google spreadsheets, you'll see there are some XML opportunities. One of them is project management, and integrating the file-save feature with a calendar.

It would be nice if there was an aggregator that integrated with a calendar so that on a specific date I could be notified to revisit the data in the Googlespreadsheet, and see what's been changed. Perhaps one of my team members has a scheduled update or data-delivery, and I want that included.

I'd like for there to be a way to download, and integrate this datafile into the Googlespreadsheet, then export that data files as an XML feeds, and be able to integrate it with others things.

The trigger for this data delivery isn't necessarily time. Rather, when a key indicator falls below, or exceeds a certain threshold, I'd like the Feed to automatically conduct an online search, gather the updated information, then attached this new data to the existing feed, and then integrate the updates within the existing file.

Then I'd like to be able to confirm to the auditors that the message/file has done what is was supposed to do; and that the critical threshold has been noticed, and something has happened; and then be able to present to the auditor evidence that we conducted our review of that data, and can trace back to the documents and files that we took appropriate actions.

The final data file should show:

A. Here is the file

B. The re-visit date and links in the aggregator was successful

C. The new revisit date-condition is this.

D. A confirming message that the aggregator has been updated, the changes are ready, and the system is ready to monitor to the incoming data, and is still effectively integrating with the Google online spreadsheet.



-- This is the end of the content --
If you've noticed Google spreadsheets, you'll see there are some XML opportunities. One of them is project management, and integrating the file-save feature with a calendar.

It would be nice if there was an aggregator that integrated with a calendar so that on a specific date I could be notified to revisit the data in the Googlespreadsheet, and see what's been changed. Perhaps one of my team members has a scheduled update or data-delivery, and I want that included.

I'd like for there to be a way to download, and integrate this datafile into the Googlespreadsheet, then export that data files as an XML feeds, and be able to integrate it with others things.

The trigger for this data delivery isn't necessarily time. Rather, when a key indicator falls below, or exceeds a certain threshold, I'd like the Feed to automatically conduct an online search, gather the updated information, then attached this new data to the existing feed, and then integrate the updates within the existing file.

Then I'd like to be able to confirm to the auditors that the message/file has done what is was supposed to do; and that the critical threshold has been noticed, and something has happened; and then be able to present to the auditor evidence that we conducted our review of that data, and can trace back to the documents and files that we took appropriate actions.

The final data file should show:

A. Here is the file

B. The re-visit date and links in the aggregator was successful

C. The new revisit date-condition is this.

D. A confirming message that the aggregator has been updated, the changes are ready, and the system is ready to monitor to the incoming data, and is still effectively integrating with the Google online spreadsheet.



-- This is the end of the content --
" />