Skip to content

Instantly share code, notes, and snippets.

@AbnormalDistribution-2020

AbnormalDistribution-2020/index.html

Created April 20, 2020 10:48
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 AbnormalDistribution-2020/5bcfa8f8ad12e916169816a8baeb4d46 to your computer and use it in GitHub Desktop.
Save AbnormalDistribution-2020/5bcfa8f8ad12e916169816a8baeb4d46 to your computer and use it in GitHub Desktop.
Download ZIP
Inventory Exploratory Data Analysis
Raw
index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style type="text/css">
text {
font-family:Play;
font-size:14px;
}
.title {
font-family: Orbitron;
font-size: 18px;
}
.blocks:hover {
cursor: pointer;
}
</style>
<body>
</body>
<script src="https://d3js.org/d3.v5.min.js"></script>
<script>
var margins = {top:20, bottom:300, left:100, right:100};
var height = 500;
var width = 600;
var totalWidth = width+margins.left+margins.right;
var totalHeight = height+margins.top+margins.bottom;
var svg = d3.select('body')
.append('svg')
.attr('width', totalWidth)
.attr('height', totalHeight);
var graphGroup = svg.append('g')
.attr('transform', "translate("+margins.left+","+margins.top+")");
var jsonData = d3.json('inventory-data.json');
var selectedValue = 0;
jsonData.then(function(rawData) {
/*
var data = rawData.map(function(d) {
return {item:d.item, y19:+d.y19, y18:+d.y18, y17:+d.y17, y16:+d.y16}
});
*/
var data = rawData;
console.log(data)
var itemNames = data.map(function(d) { return d.item; });
var yearNames = data[0].values.map(function(d) { return d.year; });
var x0 = d3.scaleBand()
.rangeRound([0, width]).padding(.1);
var xScale = d3.scaleBand()
.rangeRound([0, width])
.padding(.5)
//.domain(data.map(function(d) {return d.item; }));
.domain(['2016','2017','2018','2019']);
var yScale = d3.scaleLinear()
.range([height,0])
.domain([0,1000000]);
graphGroup.append('g')
.attr('class', 'axis-x')
.attr('transform',"translate("+0+","+height+")")
.call(d3.axisBottom(xScale));
var yAxis = graphGroup.append('g')
.attr('class', 'axis-y')
.call(d3.axisLeft(yScale));
//.selectAll('text')
// .attr('text-anchor','end')
//.attr('transform',"translate("+(-15)+","+0+")");
var itemOne = data[0];
var rects = graphGroup.selectAll('.bars')
.data(itemOne.values)
.enter()
.append('rect')
.attr('class','bars')
.attr('x', function(d) {return xScale(d.year)})
.attr('y', function(d) {return yScale(d.cost)})
.attr('width', xScale.bandwidth())
.attr('height', function(d) {return height - yScale(d.cost)})
.style('fill', function(d) {return "#003366"});
var title = graphGroup.append('text')
.attr('x', width/2)
.attr('y', height+50)
.attr('class', 'title')
.attr('text-anchor','middle')
.text('Item 1');
function updateChart(iNumber) {
console.log(iNumber)
var dataSlice = data[iNumber];
var newData = dataSlice.values.map(function(d) {
return {year:d.year, cost:+d.cost}
});
/*
var costValues = [parseFloat(dataSlice.values[0].cost), parseFloat(dataSlice.values[1].cost), parseFloat(dataSlice.values[2].cost), parseFloat(dataSlice.values[3].cost)];
*/
var yMax = d3.max(newData.map(function(d){return d.cost;}))*1.1;
yScale
.domain([0, yMax]);
yAxis.transition()
.duration(500)
.call(d3.axisLeft(yScale));
graphGroup.selectAll('.bars').data(newData);
graphGroup.selectAll(".bars").transition()
.duration(500)
.attr('y', function(d) {return yScale(d.cost)})
.attr('height', function(d) {return height - yScale(d.cost)});
title.text(dataSlice.item);
}
/*
graphGroup.selectAll(".bar").transition()
.duration(500)
.attr("y", function(d) { return yScale(eval(valueToYear[value])); })
.attr("height", function(d) { return height - yScale(eval(valueToYear[value])); });
*/
/*
var colorScale = d3.scaleLinear()
.domain([0,45000000])
.range(['lightgreen','purple']);
*/
var colorScale = d3.scaleThreshold()
.domain([1000000, 5000000, 10000000, 20000000])
.range(["#fee5d9", "#fcae91", "#fb6a4a", "#de2d26", "#a50f15"]);
var maxColumn = 24;
graphGroup.selectAll('.blocks')
.data(data)
.enter()
.append('rect')
.attr('class','blocks')
.attr('x', function(d, i) {
return (i % maxColumn) * 25
})
.attr('y', function(d, i) {
return ~~((i / maxColumn) % maxColumn) * 25 + 600
})
.attr('height', 20)
.attr('width', 20)
.style('fill', function(d) {return colorScale(d.max)})
.on('click', function(d,i) {return updateChart(i); });
d3.select("#mySlider").on("change", function() {
selectedValue = this.value;
updateChart(selectedValue);
});
})
</script>
Raw
inventory-data.json
[{"item": "Expense 1", "values": [{"year": 2019, "cost": "833387.1"}, {"year": 2018, "cost": "780431.11"}, {"year": 2017, "cost": "651135.36"}, {"year": 2016, "cost": "759859.2"}], "max": "833387.1"}, {"item": "Expense 2", "values": [{"year": 2019, "cost": "676506.94"}, {"year": 2018, "cost": "418005.31"}, {"year": 2017, "cost": "580239.22"}, {"year": 2016, "cost": "361502.28"}], "max": "676506.94"}, {"item": "Expense 3", "values": [{"year": 2019, "cost": "3086484.41"}, {"year": 2018, "cost": "3255652.58"}, {"year": 2017, "cost": "5881099.87"}, {"year": 2016, "cost": "5144168"}], "max": "3086484.41"}, {"item": "Expense 4", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "89390.04"}, {"year": 2016, "cost": "319897.77"}], "max": "0"}, {"item": "Expense 5", "values": [{"year": 2019, "cost": "716835.08"}, {"year": 2018, "cost": "213218.39"}, {"year": 2017, "cost": "326989.47"}, {"year": 2016, "cost": "269850.3"}], "max": "716835.08"}, {"item": "Expense 6", "values": [{"year": 2019, "cost": "17101.99"}, {"year": 2018, "cost": "15306.96"}, {"year": 2017, "cost": "84247.42"}, {"year": 2016, "cost": "157825.13"}], "max": "17101.99"}, {"item": "Expense 7", "values": [{"year": 2019, "cost": "2271812.6"}, {"year": 2018, "cost": "1967855.15"}, {"year": 2017, "cost": "366370.66"}, {"year": 2016, "cost": "559710.4"}], "max": "2271812.6"}, {"item": "Expense 8", "values": [{"year": 2019, "cost": "397182.44"}, {"year": 2018, "cost": "485277.53"}, {"year": 2017, "cost": "366052.91"}, {"year": 2016, "cost": "214944.27"}], "max": "397182.44"}, {"item": "Expense 9", "values": [{"year": 2019, "cost": "2414284.78"}, {"year": 2018, "cost": "1047419.26"}, {"year": 2017, "cost": "689130.35"}, {"year": 2016, "cost": "725391.27"}], "max": "2414284.78"}, {"item": "Expense 10", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 11", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "0"}, {"year": 2016, "cost": "29702.25"}], "max": "0"}, {"item": "Expense 12", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "0"}, {"year": 2016, "cost": "46168.46"}], "max": "0"}, {"item": "Expense 13", "values": [{"year": 2019, "cost": "4599376.47"}, {"year": 2018, "cost": "4942058.53"}, {"year": 2017, "cost": "4328852.95"}, {"year": 2016, "cost": "4683392.92"}], "max": "4599376.47"}, {"item": "Expense 14", "values": [{"year": 2019, "cost": "136784.96"}, {"year": 2018, "cost": "122009.79"}, {"year": 2017, "cost": "213078.4"}, {"year": 2016, "cost": "123762.2"}], "max": "136784.96"}, {"item": "Expense 15", "values": [{"year": 2019, "cost": "642589"}, {"year": 2018, "cost": "748944.87"}, {"year": 2017, "cost": "1874911.57"}, {"year": 2016, "cost": "902585.92"}], "max": "642589"}, {"item": "Expense 16", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "395939.54"}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": "0"}, {"item": "Expense 17", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "363.55"}], "max": ""}, {"item": "Expense 18", "values": [{"year": 2019, "cost": "113450.84"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "3488.75"}, {"year": 2016, "cost": "3083743.02"}], "max": "113450.84"}, {"item": "Expense 19", "values": []}, {"item": "Expense 20", "values": []}, {"item": "Expense 21", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "285607.53"}], "max": "0"}, {"item": "Expense 22", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "37669.84"}], "max": "0"}, {"item": "Expense 23", "values": [{"year": 2019, "cost": "15905796.61"}, {"year": 2018, "cost": "14392119.02"}, {"year": 2017, "cost": "15778264.34"}, {"year": 2016, "cost": "17382866.94"}], "max": "15905796.61"}, {"item": "Expense 24", "values": [{"year": 2019, "cost": "8736487.1"}, {"year": 2018, "cost": "7632124.13"}, {"year": 2017, "cost": "8283776.17"}, {"year": 2016, "cost": "6277474.08"}], "max": "8736487.1"}, {"item": "Expense 25", "values": [{"year": 2019, "cost": "8804618.32"}, {"year": 2018, "cost": "9574908.65"}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "50881.9"}], "max": "8804618.32"}, {"item": "Expense 26", "values": [{"year": 2019, "cost": "2968.49"}], "max": "2968.49"}, {"item": "Expense 27", "values": [{"year": 2019, "cost": "19472.07"}, {"year": 2018, "cost": "337428.35"}, {"year": 2017, "cost": "69212.32"}, {"year": 2016, "cost": "50395.19"}], "max": "19472.07"}, {"item": "Expense 28", "values": [{"year": 2019, "cost": "3005242.61"}, {"year": 2018, "cost": "2311351.75"}, {"year": 2017, "cost": "3557996.43"}, {"year": 2016, "cost": "5283618.14"}], "max": "3005242.61"}, {"item": "Expense 29", "values": [{"year": 2019, "cost": "4658928.59"}, {"year": 2018, "cost": "2398171.79"}, {"year": 2017, "cost": "2502274.2"}, {"year": 2016, "cost": "1390380.241"}], "max": "4658928.59"}, {"item": "Expense 30", "values": [{"year": 2019, "cost": "41133513.79"}, {"year": 2018, "cost": "36646103.69"}, {"year": 2017, "cost": "30191523.46"}, {"year": 2016, "cost": "30435616.49"}], "max": "41133513.79"}, {"item": "Expense 31", "values": [{"year": 2019, "cost": "1341880.63"}, {"year": 2018, "cost": "1948751.37"}, {"year": 2017, "cost": "847831.96"}], "max": "1341880.63"}, {"item": "Expense 32", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": "10912.25"}, {"year": 2017, "cost": "225634.06"}], "max": ""}, {"item": "Expense 33", "values": [{"year": 2019, "cost": "754367.34"}, {"year": 2018, "cost": "729274.28"}, {"year": 2017, "cost": "446757.7"}, {"year": 2016, "cost": "330305.53"}], "max": "754367.34"}, {"item": "Expense 34", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "645253.48"}, {"year": 2016, "cost": "5060323.94"}], "max": "0"}, {"item": "Expense 35", "values": [{"year": 2019, "cost": "1327784.31"}, {"year": 2018, "cost": "1118665.72"}, {"year": 2017, "cost": "1042420.72"}, {"year": 2016, "cost": "954229.63"}], "max": "1327784.31"}, {"item": "Expense 36", "values": [{"year": 2019, "cost": "9376.71"}, {"year": 2018, "cost": "22833.65"}, {"year": 2017, "cost": "25992.63"}, {"year": 2016, "cost": "10761.79"}], "max": "9376.71"}, {"item": "Expense 37", "values": [{"year": 2019, "cost": "51824.08"}, {"year": 2018, "cost": "24492.47"}, {"year": 2017, "cost": "13678.65"}, {"year": 2016, "cost": "3402008.53"}], "max": "51824.08"}, {"item": "Expense 38", "values": [{"year": 2019, "cost": "78893.84"}, {"year": 2018, "cost": "22347.58"}, {"year": 2017, "cost": "98720.25"}, {"year": 2016, "cost": "7996.33"}], "max": "78893.84"}, {"item": "Expense 39", "values": [{"year": 2019, "cost": "12168.14"}, {"year": 2018, "cost": "30560.22"}, {"year": 2017, "cost": "3548.3"}, {"year": 2016, "cost": "306054.39"}], "max": "12168.14"}, {"item": "Expense 40", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 41", "values": [{"year": 2019, "cost": "50143.11"}, {"year": 2018, "cost": "65229.12"}, {"year": 2017, "cost": "71165.07"}, {"year": 2016, "cost": "485976.61"}], "max": "50143.11"}, {"item": "Expense 42", "values": [{"year": 2019, "cost": "87882.61"}, {"year": 2018, "cost": "48245.69"}, {"year": 2017, "cost": "102159.46"}, {"year": 2016, "cost": "209676.67"}], "max": "87882.61"}, {"item": "Expense 43", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "109.88"}], "max": ""}, {"item": "Expense 44", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 45", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "27855.21"}, {"year": 2016, "cost": "47435.84"}], "max": "0"}, {"item": "Expense 46", "values": [{"year": 2019, "cost": "3816918"}, {"year": 2018, "cost": "4227436.69"}, {"year": 2017, "cost": "2583605.33"}], "max": "3816918"}, {"item": "Expense 47", "values": [{"year": 2019, "cost": "3803355.22"}, {"year": 2018, "cost": "2748017.81"}, {"year": 2017, "cost": "2116093.66"}], "max": "3803355.22"}, {"item": "Expense 48", "values": []}, {"item": "Expense 49", "values": [{"year": 2019, "cost": "287939.23"}, {"year": 2018, "cost": "330351.64"}, {"year": 2017, "cost": "305.97"}], "max": "287939.23"}, {"item": "Expense 50", "values": []}, {"item": "Expense 51", "values": [{"year": 2019, "cost": "870434.25"}, {"year": 2018, "cost": "518119.01"}, {"year": 2017, "cost": "323411.5"}], "max": "870434.25"}, {"item": "Expense 52", "values": [{"year": 2019, "cost": "11151086.84"}, {"year": 2018, "cost": "9885573.88"}, {"year": 2017, "cost": "7500967.93"}, {"year": 2016, "cost": "10814879.14"}], "max": "11151086.84"}, {"item": "Expense 53", "values": [{"year": 2019, "cost": "277052.88"}, {"year": 2018, "cost": "286505.91"}, {"year": 2017, "cost": "352842.13"}, {"year": 2016, "cost": "3587585.7"}], "max": "277052.88"}, {"item": "Expense 54", "values": [{"year": 2019, "cost": "472590.58"}, {"year": 2018, "cost": "87167.87"}, {"year": 2017, "cost": "247990.78"}, {"year": 2016, "cost": "181056.12"}], "max": "472590.58"}, {"item": "Expense 55", "values": [{"year": 2019, "cost": "81528.04"}, {"year": 2018, "cost": "12033.77"}, {"year": 2017, "cost": "37835.77"}, {"year": 2016, "cost": "151716.44"}], "max": "81528.04"}, {"item": "Expense 56", "values": []}, {"item": "Expense 57", "values": [{"year": 2019, "cost": "257059.09"}, {"year": 2018, "cost": "275271.32"}, {"year": 2017, "cost": "411779.8"}, {"year": 2016, "cost": "1568141.26"}], "max": "257059.09"}, {"item": "Expense 58", "values": [{"year": 2019, "cost": "821589.09"}, {"year": 2018, "cost": "1062526.83"}, {"year": 2017, "cost": "349193.8597"}, {"year": 2016, "cost": "249284.3846"}], "max": "821589.09"}, {"item": "Expense 59", "values": [{"year": 2019, "cost": "3291387.3"}, {"year": 2018, "cost": "3141967.4"}, {"year": 2017, "cost": "2454786.29"}], "max": "3291387.3"}, {"item": "Expense 60", "values": [{"year": 2019, "cost": "46163.67"}, {"year": 2018, "cost": "102926.87"}, {"year": 2017, "cost": "103849.99"}], "max": "46163.67"}, {"item": "Expense 61", "values": [{"year": 2019, "cost": "16398457.49"}, {"year": 2018, "cost": "14853973.85"}, {"year": 2017, "cost": "11459246.55"}, {"year": 2016, "cost": "16552663.04"}], "max": "16398457.49"}, {"item": "Expense 62", "values": [{"year": 2019, "cost": "1017165.35"}, {"year": 2018, "cost": "817884.01"}, {"year": 2017, "cost": "801819.43"}, {"year": 2016, "cost": "396552.17"}], "max": "1017165.35"}, {"item": "Expense 63", "values": [{"year": 2019, "cost": "141587.16"}, {"year": 2018, "cost": "31919.67"}, {"year": 2017, "cost": "50739.27"}, {"year": 2016, "cost": "21153.63"}], "max": "141587.16"}, {"item": "Expense 64", "values": [{"year": 2019, "cost": "471636.35"}, {"year": 2018, "cost": "74272.41"}, {"year": 2017, "cost": "175249.04"}, {"year": 2016, "cost": "201372.73"}], "max": "471636.35"}, {"item": "Expense 65", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "33430.79"}, {"year": 2016, "cost": "80877.36"}], "max": "0"}, {"item": "Expense 66", "values": [{"year": 2019, "cost": "14414.03"}, {"year": 2018, "cost": "22896.07"}, {"year": 2017, "cost": "0"}, {"year": 2016, "cost": "29484.36"}], "max": "14414.03"}, {"item": "Expense 67", "values": [{"year": 2019, "cost": "30025.23"}, {"year": 2018, "cost": "30025.23"}, {"year": 2017, "cost": "399343.25"}, {"year": 2016, "cost": "259594.88"}], "max": "30025.23"}, {"item": "Expense 68", "values": [{"year": 2019, "cost": "782673.78"}, {"year": 2018, "cost": "511985.78"}, {"year": 2017, "cost": "386528.11"}, {"year": 2016, "cost": "322630.27"}], "max": "782673.78"}, {"item": "Expense 69", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 70", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 71", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 72", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 73", "values": [{"year": 2019, "cost": "324.52"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "20328.71"}], "max": "324.52"}, {"item": "Expense 74", "values": [{"year": 2019, "cost": "2818.02"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "2056.58"}], "max": "2818.02"}, {"item": "Expense 75", "values": []}, {"item": "Expense 76", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": "112005.49"}], "max": ""}, {"item": "Expense 77", "values": [{"year": 2019, "cost": "90013.87"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "0"}], "max": "90013.87"}, {"item": "Expense 78", "values": [{"year": 2019, "cost": "2550658.31"}, {"year": 2018, "cost": "1488983.17"}, {"year": 2017, "cost": "1961171.96"}, {"year": 2016, "cost": "1331994.11"}], "max": "2550658.31"}, {"item": "Expense 79", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 80", "values": [{"year": 2019, "cost": "14124.9"}, {"year": 2018, "cost": "54762.36"}, {"year": 2017, "cost": "33103.77"}, {"year": 2016, "cost": "29682.2"}], "max": "14124.9"}, {"item": "Expense 81", "values": [{"year": 2019, "cost": "940303.45"}, {"year": 2018, "cost": "780224.02"}], "max": "940303.45"}, {"item": "Expense 82", "values": [{"year": 2019, "cost": "1212514.15"}, {"year": 2018, "cost": "1169081.78"}, {"year": 2017, "cost": "1246439.09"}, {"year": 2016, "cost": "648001.77"}], "max": "1212514.15"}, {"item": "Expense 83", "values": [{"year": 2019, "cost": "700865.84"}, {"year": 2018, "cost": "396942.05"}, {"year": 2017, "cost": "827357.27"}, {"year": 2016, "cost": "692164.21"}], "max": "700865.84"}, {"item": "Expense 84", "values": [{"year": 2019, "cost": "878403.7"}, {"year": 2018, "cost": "354817.87"}, {"year": 2017, "cost": "278454.44"}, {"year": 2016, "cost": "85964.60613"}], "max": "878403.7"}, {"item": "Expense 85", "values": [{"year": 2019, "cost": "6296870.35"}, {"year": 2018, "cost": "4244811.25"}, {"year": 2017, "cost": "4346526.53"}, {"year": 2016, "cost": "2787806.896"}], "max": "6296870.35"}, {"item": "Expense 86", "values": [{"year": 2019, "cost": "4710253.33"}, {"year": 2018, "cost": "4266377.9"}, {"year": 2017, "cost": "5324488.84"}, {"year": 2016, "cost": "3958826.64"}], "max": "4710253.33"}, {"item": "Expense 87", "values": [{"year": 2019, "cost": "61512.28"}, {"year": 2018, "cost": "121113.6"}, {"year": 2017, "cost": "120854.85"}, {"year": 2016, "cost": "174238.51"}], "max": "61512.28"}, {"item": "Expense 88", "values": [{"year": 2019, "cost": "4771765.61"}, {"year": 2018, "cost": "4387491.5"}, {"year": 2017, "cost": "5445343.69"}, {"year": 2016, "cost": "4133065.15"}], "max": "4771765.61"}, {"item": "Expense 89", "values": [{"year": 2019, "cost": "248166.27"}, {"year": 2018, "cost": "220803.54"}, {"year": 2017, "cost": "267439.56"}, {"year": 2016, "cost": "112140.93"}], "max": "248166.27"}, {"item": "Expense 90", "values": [{"year": 2019, "cost": "686613.76"}, {"year": 2018, "cost": "633835.27"}, {"year": 2017, "cost": "97906.19"}, {"year": 2016, "cost": "714"}], "max": "686613.76"}, {"item": "Expense 91", "values": [{"year": 2019, "cost": "113757.26"}, {"year": 2018, "cost": "36559.48"}, {"year": 2017, "cost": "75788.43"}, {"year": 2016, "cost": "73767.94"}], "max": "113757.26"}, {"item": "Expense 92", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "3030.79"}], "max": "0"}, {"item": "Expense 93", "values": [{"year": 2019, "cost": "183.76"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "279.16"}, {"year": 2016, "cost": "75235.21"}], "max": "183.76"}, {"item": "Expense 94", "values": [{"year": 2019, "cost": "72126.73"}, {"year": 2018, "cost": "44699.49"}, {"year": 2017, "cost": "25282.96"}, {"year": 2016, "cost": "84418.09"}], "max": "72126.73"}, {"item": "Expense 95", "values": [{"year": 2019, "cost": "2474.87"}, {"year": 2018, "cost": "2474.87"}, {"year": 2017, "cost": "65067.14"}, {"year": 2016, "cost": "46200.59"}], "max": "2474.87"}, {"item": "Expense 96", "values": [{"year": 2019, "cost": "16836.49"}, {"year": 2018, "cost": "81047"}, {"year": 2017, "cost": "98010.77"}, {"year": 2016, "cost": "17586.02"}], "max": "16836.49"}, {"item": "Expense 97", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "14920.44"}], "max": ""}, {"item": "Expense 98", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 99", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 100", "values": [{"year": 2019, "cost": "780511.69"}, {"year": 2018, "cost": "1066222.01"}, {"year": 2017, "cost": "809180.86"}, {"year": 2016, "cost": "872344.94"}], "max": "780511.69"}, {"item": "Expense 101", "values": [{"year": 2019, "cost": "14528.24"}, {"year": 2018, "cost": "21595.44"}, {"year": 2017, "cost": "7385.02"}, {"year": 2016, "cost": "133336.53"}], "max": "14528.24"}, {"item": "Expense 102", "values": [{"year": 2019, "cost": "158.55"}, {"year": 2018, "cost": "112.97"}, {"year": 2017, "cost": "0"}], "max": "158.55"}, {"item": "Expense 103", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 104", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 105", "values": [{"year": 2019, "cost": "806423.14"}, {"year": 2018, "cost": "705711.82"}, {"year": 2017, "cost": "444887.29"}, {"year": 2016, "cost": "185171.44"}], "max": "806423.14"}, {"item": "Expense 106", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 107", "values": [{"year": 2019, "cost": "44908.48"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "1032.96"}], "max": "44908.48"}, {"item": "Expense 108", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "9519.04"}], "max": "0"}, {"item": "Expense 109", "values": [{"year": 2019, "cost": "383923.96"}, {"year": 2018, "cost": "465343.82"}, {"year": 2017, "cost": "457661.41"}], "max": "383923.96"}, {"item": "Expense 110", "values": [{"year": 2019, "cost": "2235833.17"}, {"year": 2018, "cost": "2423766.9"}, {"year": 2017, "cost": "1994095.04"}, {"year": 2016, "cost": "1506011.99"}], "max": "2235833.17"}, {"item": "Expense 111", "values": [{"year": 2019, "cost": "77849.75"}, {"year": 2018, "cost": "74409.48"}, {"year": 2017, "cost": "269565.08"}, {"year": 2016, "cost": "368248.83"}], "max": "77849.75"}, {"item": "Expense 112", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "22386.16"}, {"year": 2017, "cost": "485.91"}, {"year": 2016, "cost": "4799.58"}], "max": "0"}, {"item": "Expense 113", "values": [{"year": 2019, "cost": "82475.37"}], "max": "82475.37"}, {"item": "Expense 114", "values": []}, {"item": "Expense 115", "values": [{"year": 2019, "cost": "162216.19"}, {"year": 2018, "cost": "108377.23"}], "max": "162216.19"}, {"item": "Expense 116", "values": [{"year": 2019, "cost": "790000.75"}, {"year": 2018, "cost": "1086857.72"}, {"year": 2017, "cost": "702155.72"}], "max": "790000.75"}, {"item": "Expense 117", "values": [{"year": 2019, "cost": "0"}], "max": "0"}, {"item": "Expense 118", "values": [{"year": 2019, "cost": "320833.8"}, {"year": 2018, "cost": "70399.47"}, {"year": 2017, "cost": "110810.23"}, {"year": 2016, "cost": "532502.08"}], "max": "320833.8"}, {"item": "Expense 119", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "74444.15745"}], "max": ""}, {"item": "Expense 120", "values": [{"year": 2019, "cost": "428397.67"}, {"year": 2018, "cost": "387488.43"}, {"year": 2017, "cost": "615749.94"}, {"year": 2016, "cost": "248082.1356"}], "max": "428397.67"}, {"item": "Expense 121", "values": []}, {"item": "Expense 122", "values": [{"year": 2019, "cost": "4097606.7"}, {"year": 2018, "cost": "4173685.39"}, {"year": 2017, "cost": "3692861.92"}, {"year": 2016, "cost": "2734088.773"}], "max": "4097606.7"}, {"item": "Expense 123", "values": [{"year": 2019, "cost": "12082.44"}, {"year": 2018, "cost": "15111.16"}, {"year": 2017, "cost": "2137.17"}, {"year": 2016, "cost": "16144.61"}], "max": "12082.44"}, {"item": "Expense 124", "values": [{"year": 2019, "cost": "34504.17"}, {"year": 2018, "cost": "8435.5"}, {"year": 2017, "cost": "61911.66"}, {"year": 2016, "cost": "57130.32"}], "max": "34504.17"}, {"item": "Expense 125", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "16162.01"}], "max": ""}, {"item": "Expense 126", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 127", "values": [{"year": 2019, "cost": "7595.84"}, {"year": 2018, "cost": "7595.84"}, {"year": 2017, "cost": "20300.37"}, {"year": 2016, "cost": "49347.83"}], "max": "7595.84"}, {"item": "Expense 128", "values": [{"year": 2019, "cost": "1385522.12"}, {"year": 2018, "cost": "1203322.86"}, {"year": 2017, "cost": "924865.01"}, {"year": 2016, "cost": "744075.05"}], "max": "1385522.12"}, {"item": "Expense 129", "values": [{"year": 2019, "cost": "13251.85"}, {"year": 2018, "cost": "7780.45"}, {"year": 2017, "cost": "16495.11"}, {"year": 2016, "cost": "47859.08"}], "max": "13251.85"}, {"item": "Expense 130", "values": [{"year": 2019, "cost": "606.38"}, {"year": 2018, "cost": "140.4"}, {"year": 2017, "cost": "0"}, {"year": 2016, "cost": "17167.56"}], "max": "606.38"}, {"item": "Expense 131", "values": [{"year": 2019, "cost": "127723.2"}, {"year": 2018, "cost": "138576.01"}, {"year": 2017, "cost": "115702.52"}, {"year": 2016, "cost": "84602.66"}], "max": "127723.2"}, {"item": "Expense 132", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 133", "values": [{"year": 2019, "cost": "505816.06"}, {"year": 2018, "cost": "650621.41"}, {"year": 2017, "cost": "164220.64"}, {"year": 2016, "cost": "137026.15"}], "max": "505816.06"}, {"item": "Expense 134", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 135", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 136", "values": [{"year": 2019, "cost": ""}, {"year": 2018, "cost": ""}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "0"}], "max": ""}, {"item": "Expense 137", "values": [{"year": 2019, "cost": "13575.28"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "2928.6"}], "max": "13575.28"}, {"item": "Expense 138", "values": [{"year": 2019, "cost": "3733.16"}, {"year": 2018, "cost": "0"}], "max": "3733.16"}, {"item": "Expense 139", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "4631.39"}], "max": "0"}, {"item": "Expense 140", "values": [{"year": 2019, "cost": "937368.17"}, {"year": 2018, "cost": "411943.82"}, {"year": 2017, "cost": "323664.94"}], "max": "937368.17"}, {"item": "Expense 141", "values": [{"year": 2019, "cost": "724.97"}], "max": "724.97"}, {"item": "Expense 142", "values": []}, {"item": "Expense 143", "values": [{"year": 2019, "cost": "3042503.64"}, {"year": 2018, "cost": "2443527.45"}, {"year": 2017, "cost": "1636857.41"}, {"year": 2016, "cost": "1169515.27"}], "max": "3042503.64"}, {"item": "Expense 144", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "1.53"}, {"year": 2017, "cost": ""}, {"year": 2016, "cost": "21085"}], "max": "0"}, {"item": "Expense 145", "values": [{"year": 2019, "cost": "341.81"}, {"year": 2018, "cost": "341.81"}, {"year": 2017, "cost": "212.65"}, {"year": 2016, "cost": "4006.51"}], "max": "341.81"}, {"item": "Expense 146", "values": []}, {"item": "Expense 147", "values": [{"year": 2019, "cost": "694662.59"}, {"year": 2018, "cost": "885634.51"}, {"year": 2017, "cost": "328644.56"}, {"year": 2016, "cost": "413157.06"}], "max": "694662.59"}, {"item": "Expense 148", "values": [{"year": 2019, "cost": "0"}, {"year": 2018, "cost": "0"}], "max": "0"}, {"item": "Expense 149", "values": [{"year": 2019, "cost": "900609.43"}, {"year": 2018, "cost": "926125.99"}, {"year": 2017, "cost": "480760.77"}, {"year": 2016, "cost": "124807.6821"}], "max": "900609.43"}, {"item": "Expense 150", "values": [{"year": 2019, "cost": "3320.92"}, {"year": 2018, "cost": "162853.37"}, {"year": 2017, "cost": "787093.52"}], "max": "3320.92"}, {"item": "Expense 151", "values": [{"year": 2019, "cost": "18425.79"}, {"year": 2018, "cost": "0"}, {"year": 2017, "cost": "0"}], "max": "18425.79"}, {"item": "Expense 152", "values": [{"year": 2019, "cost": "728734.91"}], "max": "728734.91"}, {"item": "Expense 153", "values": [{"year": 2019, "cost": "5388599.09"}, {"year": 2018, "cost": "4418484.66"}, {"year": 2017, "cost": "3233568.91"}, {"year": 2016, "cost": "1732571.522"}], "max": "5388599.09"}, {"item": "Expense 154", "values": [{"year": 2019, "cost": "3589002.16"}, {"year": 2018, "cost": "2219393.49"}, {"year": 2017, "cost": "765754.45"}, {"year": 2016, "cost": "9282.84"}], "max": "3589002.16"}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment