Skip to content

Instantly share code, notes, and snippets.

@tostrowski

tostrowski/spendTableData.json

Created February 13, 2023 14:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tostrowski/d4f2b4d48b182447c584191be13c1ca5 to your computer and use it in GitHub Desktop.
Save tostrowski/d4f2b4d48b182447c584191be13c1ca5 to your computer and use it in GitHub Desktop.
Download ZIP
Spend table data
Raw
spendTableData.json
{
"rowTypes": {
"section": {
"rowStyle": "HEADER",
"columns": [
{
"cellKey": "Dimensions",
"colSpan": 2,
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "prev_yr",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr",
"colSpan": 3,
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr_budget_breakdown",
"colSpan": 12,
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr_act_fcst_breakdown",
"colSpan": 12,
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr_var_breakdown",
"colSpan": 12,
"cellFormat": "TEXT",
"isSticky": true
}
]
},
"standard": {
"rowStyle": "STANDARD",
"columns": [
{
"cellKey": "FunctionKey",
"cellFormat": "TEXT",
"isSticky": true,
"isRollup": true
},
{
"cellKey": "CostCenterKey",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "prev_yr_act",
"cellFormat": "NUMBER"
},
{
"cellKey": "curr_yr_budget",
"cellFormat": "NUMBER"
},
{
"cellKey": "curr_yr_act_fcst",
"cellFormat": "NUMBER"
},
{
"cellKey": "curr_yr_var",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202301",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202301",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202301",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202302",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202302",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202302",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202303",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202303",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202303",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202304",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202304",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202304",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202305",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202305",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202305",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202306",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202306",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202306",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202307",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202307",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202307",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202308",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202308",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202308",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202309",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202309",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202309",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202310",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202310",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202310",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202311",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202311",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202311",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202312",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202312",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202312",
"cellFormat": "NUMBER"
}
]
},
"header": {
"rowStyle": "HEADER",
"columns": [
{
"cellKey": "FunctionKey",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "CostCenterKey",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "prev_yr_act",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr_budget",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr_act_fcst",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "curr_yr_var",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202301",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202301",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202301",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202302",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202302",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202302",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202303",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202303",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202303",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202304",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202304",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202304",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202305",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202305",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202305",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202306",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202306",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202306",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202307",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202307",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202307",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202308",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202308",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202308",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202309",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202309",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202309",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202310",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202310",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202310",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202311",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202311",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202311",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "budget_202312",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "act_fcst_202312",
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "var_202312",
"cellFormat": "TEXT",
"isSticky": true
}
]
},
"total": {
"rowStyle": "TOTAL",
"columns": [
{
"cellKey": "TotalKey",
"colSpan": 2,
"cellFormat": "TEXT",
"isSticky": true
},
{
"cellKey": "prev_yr_act",
"cellFormat": "NUMBER"
},
{
"cellKey": "curr_yr_budget",
"cellFormat": "NUMBER"
},
{
"cellKey": "curr_yr_act_fcst",
"cellFormat": "NUMBER"
},
{
"cellKey": "curr_yr_var",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202301",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202301",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202301",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202302",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202302",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202302",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202303",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202303",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202303",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202304",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202304",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202304",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202305",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202305",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202305",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202306",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202306",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202306",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202307",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202307",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202307",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202308",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202308",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202308",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202309",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202309",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202309",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202310",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202310",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202310",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202311",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202311",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202311",
"cellFormat": "NUMBER"
},
{
"cellKey": "budget_202312",
"cellFormat": "NUMBER"
},
{
"cellKey": "act_fcst_202312",
"cellFormat": "NUMBER"
},
{
"cellKey": "var_202312",
"cellFormat": "NUMBER"
}
]
}
},
"data": [
{
"rowTypeKey": "section",
"cellKeys": {
"prev_yr": "2022",
"Dimensions": "",
"curr_yr_var_breakdown": "2023 Variance",
"curr_yr": "2023",
"curr_yr_budget_breakdown": "2023 Budget",
"curr_yr_act_fcst_breakdown": "2023 Act+Fcst"
}
},
{
"rowTypeKey": "header",
"cellKeys": {
"budget_202312": "Dec '23",
"budget_202311": "Nov '23",
"budget_202310": "Oct '23",
"curr_yr_var": "Variance",
"var_202311": "Nov '23",
"var_202312": "Dec '23",
"FunctionKey": "Function",
"var_202310": "Oct '23",
"budget_202309": "Sep '23",
"budget_202308": "Aug '23",
"budget_202307": "Jul '23",
"budget_202306": "Jun '23",
"budget_202305": "May '23",
"budget_202304": "Apr '23",
"budget_202303": "Mar '23",
"budget_202302": "Feb '23",
"budget_202301": "Jan '23",
"var_202309": "Sep '23",
"var_202304": "Apr '23",
"var_202303": "Mar '23",
"var_202308": "Aug '23",
"var_202307": "Jul '23",
"prev_yr_act": "Actuals",
"var_202306": "Jun '23",
"var_202305": "May '23",
"act_fcst_202312": "Dec '23",
"act_fcst_202311": "Nov '23",
"act_fcst_202310": "Oct '23",
"var_202302": "Feb '23",
"var_202301": "Jan '23",
"CostCenterKey": "Cost Center",
"curr_yr_budget": "Budget",
"curr_yr_act_fcst": "Act+Fcst",
"act_fcst_202309": "Sep '23",
"act_fcst_202308": "Aug '23",
"act_fcst_202307": "Jul '23",
"act_fcst_202306": "Jun '23",
"act_fcst_202305": "May '23",
"act_fcst_202304": "Apr '23",
"act_fcst_202303": "Mar '23",
"act_fcst_202302": "Feb '23",
"act_fcst_202301": "Jan '23"
}
},
{
"rowTypeKey": "standard",
"rowSpan": 2,
"cellKeys": {
"budget_202308": 5.000000,
"budget_202307": 5.000000,
"budget_202309": 5.000000,
"act_fcst_202312": 4.000000,
"act_fcst_202311": 4.000000,
"act_fcst_202310": 4.000000,
"var_202305": 1.000000,
"var_202306": 1.000000,
"prev_yr_act": 36.000000,
"var_202307": 1.000000,
"var_202308": 1.000000,
"var_202301": 1.000000,
"var_202302": 1.000000,
"var_202303": 1.000000,
"var_202304": 1.000000,
"budget_202311": 5.000000,
"budget_202310": 5.000000,
"curr_yr_budget": 60.000000,
"budget_202312": 5.000000,
"act_fcst_202309": 4.000000,
"FunctionKey": "r&d",
"act_fcst_202306": 4.000000,
"CostCenterKey": "cc1",
"act_fcst_202305": 4.000000,
"act_fcst_202308": 4.000000,
"curr_yr_act_fcst": 48.000000,
"act_fcst_202307": 4.000000,
"act_fcst_202302": 4.000000,
"act_fcst_202301": 4.000000,
"act_fcst_202304": 4.000000,
"act_fcst_202303": 4.000000,
"var_202309": 1.000000,
"curr_yr_var": 12.000000,
"var_202312": 1.000000,
"budget_202302": 5.000000,
"var_202310": 1.000000,
"budget_202301": 5.000000,
"var_202311": 1.000000,
"budget_202304": 5.000000,
"budget_202303": 5.000000,
"budget_202306": 5.000000,
"budget_202305": 5.000000
}
},
{
"rowTypeKey": "standard",
"cellKeys": {
"budget_202308": 10.000000,
"budget_202307": 10.000000,
"budget_202309": 10.000000,
"act_fcst_202312": 9.000000,
"act_fcst_202311": 9.000000,
"act_fcst_202310": 9.000000,
"var_202305": 2.000000,
"var_202306": 2.000000,
"prev_yr_act": 72.000000,
"var_202307": 1.000000,
"var_202308": 1.000000,
"var_202301": 2.000000,
"var_202302": 2.000000,
"var_202303": 2.000000,
"var_202304": 2.000000,
"budget_202311": 10.000000,
"budget_202310": 10.000000,
"curr_yr_budget": 120.000000,
"budget_202312": 10.000000,
"act_fcst_202309": 9.000000,
"FunctionKey": "r&d",
"act_fcst_202306": 8.000000,
"CostCenterKey": "cc2",
"act_fcst_202305": 8.000000,
"act_fcst_202308": 9.000000,
"curr_yr_act_fcst": 102.000000,
"act_fcst_202307": 9.000000,
"act_fcst_202302": 8.000000,
"act_fcst_202301": 8.000000,
"act_fcst_202304": 8.000000,
"act_fcst_202303": 8.000000,
"var_202309": 1.000000,
"curr_yr_var": 18.000000,
"var_202312": 1.000000,
"budget_202302": 10.000000,
"var_202310": 1.000000,
"budget_202301": 10.000000,
"var_202311": 1.000000,
"budget_202304": 10.000000,
"budget_202303": 10.000000,
"budget_202306": 10.000000,
"budget_202305": 10.000000
}
},
{
"rowTypeKey": "total",
"cellKeys": {
"budget_202308": 15.000000,
"budget_202307": 15.000000,
"budget_202309": 15.000000,
"act_fcst_202312": 13.000000,
"act_fcst_202311": 13.000000,
"act_fcst_202310": 13.000000,
"var_202305": 3.000000,
"var_202306": 3.000000,
"prev_yr_act": 108.000000,
"var_202307": 2.000000,
"var_202308": 2.000000,
"var_202301": 3.000000,
"var_202302": 3.000000,
"var_202303": 3.000000,
"var_202304": 3.000000,
"budget_202311": 15.000000,
"budget_202310": 15.000000,
"curr_yr_budget": 180.000000,
"budget_202312": 15.000000,
"act_fcst_202309": 13.000000,
"FunctionKey": "r&d",
"act_fcst_202306": 12.000000,
"CostCenterKey": "TotalKey",
"act_fcst_202305": 12.000000,
"act_fcst_202308": 13.000000,
"curr_yr_act_fcst": 150.000000,
"act_fcst_202307": 13.000000,
"act_fcst_202302": 12.000000,
"act_fcst_202301": 12.000000,
"act_fcst_202304": 12.000000,
"act_fcst_202303": 12.000000,
"var_202309": 2.000000,
"curr_yr_var": 30.000000,
"var_202312": 2.000000,
"budget_202302": 15.000000,
"var_202310": 2.000000,
"budget_202301": 15.000000,
"var_202311": 2.000000,
"budget_202304": 15.000000,
"budget_202303": 15.000000,
"budget_202306": 15.000000,
"budget_202305": 15.000000
}
}
],
"type": "TABLE_V2"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment