64 lines
2.0 KiB
Markdown
64 lines
2.0 KiB
Markdown
# Excel Chart Generator
|
|
|
|
Using the excellent open source [excelize](https://github.com/qax-os/excelize) library, convert json data tracking numbers over time into an excel workbook of graphs.
|
|
|
|
## Input data
|
|
|
|
Here is some sample input data. Note that some of these key names are hard coded in the source code in order to reduce complexity.
|
|
|
|
```json
|
|
{
|
|
"Tracking": {
|
|
"AVG data 1": {
|
|
"Low": {
|
|
"DC1": {
|
|
"September-2024": 17948.94,
|
|
"August-2024": 17947.40,
|
|
"July-2024": 17470.34,
|
|
"June-2024": 17648.02,
|
|
"May-2024": 17314.25
|
|
},
|
|
"DC2": {
|
|
"September-2024": 21226.84,
|
|
"August-2024": 20956.31,
|
|
"July-2024": 20021.72,
|
|
"June-2024": 19713.80,
|
|
"May-2024": 19945.32
|
|
}
|
|
},
|
|
"Ultra": {
|
|
"DC1": {
|
|
"September-2024": 4544,
|
|
"August-2024": 4544,
|
|
"July-2024": 4685.90,
|
|
"June-2024": 4741.55,
|
|
"May-2024": 4830.26
|
|
},
|
|
"DC2": {
|
|
"September-2024": 5369.58,
|
|
"August-2024": 5372,
|
|
"July-2024": 5357.38,
|
|
"June-2024": 5344.6,
|
|
"May-2024": 5306.26
|
|
}
|
|
}
|
|
},
|
|
"count 1": {
|
|
"DC1": {
|
|
"September-2024": 6801.80,
|
|
"August-2024": 6804.71,
|
|
"July-2024": 6664.03,
|
|
"June-2024": 6673.87,
|
|
"May-2024": 6656.42
|
|
},
|
|
"DC2": {
|
|
"September-2024": 6751.17,
|
|
"August-2024": 6765.42,
|
|
"July-2024": 6597.65,
|
|
"June-2024": 6510.47,
|
|
"May-2024": 6487.19
|
|
}
|
|
}
|
|
}
|
|
}
|
|
``` |