Designing a portable and human-readable data format…
0 reactions
Designing a portable and human-readable data format: trying to solve the displacement problem in spreadsheets with a plain-text specification
I borrowed part of the notation from A1 format and I'm using this format in some of my projects. Overlaps are handled as last-man-wins and enconding should be UFT-8.
Below is an example of a `.dss` file representing a complex and sparse spreadsheet.
It should handle multiple sheets, sparse data grid, metadata and formulas.
---
project: Financial Forecast
version: 2.1
---
[Quarterly Report]
@ A1
"Department", "Budget", "Actual"
"Marketing", 50000, 48500
"R&D", 120000, 131000
@ G1
"Status: Over Budget"
"Risk Level: Low"
@ A10
"Notes:"
"The R&D department exceeded budget due to hardware acquisition."
[Settings]
@ B2
"Tax Rate", 0.22
"Currency", "EUR"
#technology
source
I borrowed part of the notation from A1 format and I'm using this format in some of my projects. Overlaps are handled as last-man-wins and enconding should be UFT-8.
Below is an example of a `.dss` file representing a complex and sparse spreadsheet.
It should handle multiple sheets, sparse data grid, metadata and formulas.
---
project: Financial Forecast
version: 2.1
---
[Quarterly Report]
@ A1
"Department", "Budget", "Actual"
"Marketing", 50000, 48500
"R&D", 120000, 131000
@ G1
"Status: Over Budget"
"Risk Level: Low"
@ A10
"Notes:"
"The R&D department exceeded budget due to hardware acquisition."
[Settings]
@ B2
"Tax Rate", 0.22
"Currency", "EUR"
#technology
source
| 3,000 mlx | |
| 4 | |
| 0 |