Dynamic formulas for spreadsheet cells
Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment formulas represent formulas for calculating adjustments to the value contained within the cell and other formulas can represent different calculat...
Saved in:
| Main Authors | , , |
|---|---|
| Format | Patent |
| Language | English |
| Published |
11.09.2009
|
| Subjects | |
| Online Access | Get full text |
Cover
Loading…
| Abstract | Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment formulas represent formulas for calculating adjustments to the value contained within the cell and other formulas can represent different calculation scenarios. Each of the formulas associated with the cell are dynamically updated and adjusted to react to changes elsewhere in the spreadsheet such that a user can recalculate the whole spreadsheet and move formulas around in the spreadsheet causing both the external data formula and all the adjustment formulas that may exist in the same cell to be updated accordingly. |
|---|---|
| AbstractList | Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment formulas represent formulas for calculating adjustments to the value contained within the cell and other formulas can represent different calculation scenarios. Each of the formulas associated with the cell are dynamically updated and adjusted to react to changes elsewhere in the spreadsheet such that a user can recalculate the whole spreadsheet and move formulas around in the spreadsheet causing both the external data formula and all the adjustment formulas that may exist in the same cell to be updated accordingly. |
| Author | JEFFREY J. DUZAK CHARLES D. ELLIS ALLAN FOLTING |
| Author_xml | – fullname: JEFFREY J. DUZAK – fullname: CHARLES D. ELLIS – fullname: ALLAN FOLTING |
| BookMark | eNrjYmDJy89L5WRQc6nMS8zNTFZIyy_KLc1JLAYxFIoLilITU4ozUlNLFJJTc3KKeRhY0xJzilN5oTQ3g7Kba4izh25qQX58anFBYnJqXmpJvGOokYGBpZGRgaGRuaOhMXGqAARHKi0 |
| ContentType | Patent |
| DBID | EVB |
| DatabaseName | esp@cenet |
| DatabaseTitleList | |
| Database_xml | – sequence: 1 dbid: EVB name: esp@cenet url: http://worldwide.espacenet.com/singleLineSearch?locale=en_EP sourceTypes: Open Access Repository |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Medicine Chemistry Sciences Physics |
| ExternalDocumentID | AU2009220127A1 |
| GroupedDBID | EVB |
| ID | FETCH-epo_espacenet_AU2009220127A13 |
| IEDL.DBID | EVB |
| IngestDate | Fri Jul 19 14:54:13 EDT 2024 |
| IsOpenAccess | true |
| IsPeerReviewed | false |
| IsScholarly | false |
| Language | English |
| LinkModel | DirectLink |
| MergedId | FETCHMERGED-epo_espacenet_AU2009220127A13 |
| Notes | Application Number: AU20090220127 |
| OpenAccessLink | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20090911&DB=EPODOC&CC=AU&NR=2009220127A1 |
| ParticipantIDs | epo_espacenet_AU2009220127A1 |
| PublicationCentury | 2000 |
| PublicationDate | 20090911 |
| PublicationDateYYYYMMDD | 2009-09-11 |
| PublicationDate_xml | – month: 09 year: 2009 text: 20090911 day: 11 |
| PublicationDecade | 2000 |
| PublicationYear | 2009 |
| RelatedCompanies | MICROSOFT CORPORATION |
| RelatedCompanies_xml | – name: MICROSOFT CORPORATION |
| Score | 2.743738 |
| Snippet | Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment... |
| SourceID | epo |
| SourceType | Open Access Repository |
| SubjectTerms | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| Title | Dynamic formulas for spreadsheet cells |
| URI | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20090911&DB=EPODOC&locale=&CC=AU&NR=2009220127A1 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1bS8MwFD6MeX3TqniZUlD6FrRt2q0PQ7ZeGMIuyCZ7G0mbMkG6Yjr8-55kq-5pbyGBkxtfzjXnADzljisYczhJ7UwQSr2AMCoo4soPPJrjjesyncORP5jRt7k3b8BX_RdG5wn90ckREVEp4r3S73X5b8SKdGylfOaf2LV6TabdyKq14wDZn21F_W48GUfj0ApD1CSt0bsecxzlZ-2hrnSAgnRbBYDFH331L6XcZSrJGRxOkF5RnUNDFAachHXtNQOOh1uXtwFHOkYzldi5xaG8ACvaFJI3lci5RgFYNUxZogSYyaUQlakM8vISHpN4Gg4ITr342-miN9tdp3sFzWJViGsws4ylCMb8pdPuqErm3Hf9NGAO9dw85x6_gdY-Srf7h-_gdOMkCYhtt6BZfa_FPfLaij_oI_oFbGmAyA |
| link.rule.ids | 230,309,783,888,25578,76884 |
| linkProvider | European Patent Office |
| linkToHtml | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1JT4NAFH5p6lJvihqXqiQabkSBAeHQmJYlqIU2hpreCMsQTQwlQuPf9820aE-9Td4ks-abt857AHeFqtEkUVM5U3IqE6JbckIoQVwZlk4KvHFepjMIDX9GXub6vANf7V8Ynif0hydHRERliPeGv9fVvxHL4bGV9X36iaTFkxcNHKnVji1kf4rkjAbudOJMbMm2UZOUwjfep6rMzzpEXWkHhWyTZdp330fsX0q1yVS8Q9id4nhlcwQdWgrQs9vaawLsB2uXtwB7PEYzq5G4xmF9DJKzKiQvMpFziQIwa4h1hRJgXn9Q2ojMIF-fwK3nRrYv49Tx307j4WxzndopdMtFSc9AzPMkQzAWD-ajySqZp4ZmZFaiEl0rilRPz6G_baSL7d030POjYByPn8PXSzhYOUwsWVH60G2-l_QK-W6TXvPj-gWeA4O4 |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=Dynamic+formulas+for+spreadsheet+cells&rft.inventor=JEFFREY+J.+DUZAK&rft.inventor=CHARLES+D.+ELLIS&rft.inventor=ALLAN+FOLTING&rft.date=2009-09-11&rft.externalDBID=A1&rft.externalDocID=AU2009220127A1 |