Skip to content

Instantly share code, notes, and snippets.

@miguelvb
Last active October 14, 2016 13:00
Show Gist options
  • Save miguelvb/2f65e501776381af5b3b0fe6715697bc to your computer and use it in GitHub Desktop.
Save miguelvb/2f65e501776381af5b3b0fe6715697bc to your computer and use it in GitHub Desktop.
treemap
license: mit
{
"name": "flare",
"children": [
{
"name": "analytics",
"children": [
{
"name": "cluster",
"children": [
{"name": "AgglomerativeCluster", "value": 3938},
{"name": "CommunityStructure", "value": 3812},
{"name": "HierarchicalCluster", "value": 6714},
{"name": "MergeEdge", "value": 743}
]
},
{
"name": "graph",
"children": [
{"name": "BetweennessCentrality", "value": 3534},
{"name": "LinkDistance", "value": 5731},
{"name": "MaxFlowMinCut", "value": 7840},
{"name": "ShortestPaths", "value": 5914},
{"name": "SpanningTree", "value": 3416}
]
},
{
"name": "optimization",
"children": [
{"name": "AspectRatioBanker", "value": 7074}
]
}
]
},
{
"name": "animate",
"children": [
{"name": "Easing", "value": 17010},
{"name": "FunctionSequence", "value": 5842},
{
"name": "interpolate",
"children": [
{"name": "ArrayInterpolator", "value": 1983},
{"name": "ColorInterpolator", "value": 2047},
{"name": "DateInterpolator", "value": 1375},
{"name": "Interpolator", "value": 8746},
{"name": "MatrixInterpolator", "value": 2202},
{"name": "NumberInterpolator", "value": 1382},
{"name": "ObjectInterpolator", "value": 1629},
{"name": "PointInterpolator", "value": 1675},
{"name": "RectangleInterpolator", "value": 2042}
]
},
{"name": "ISchedulable", "value": 1041},
{"name": "Parallel", "value": 5176},
{"name": "Pause", "value": 449},
{"name": "Scheduler", "value": 5593},
{"name": "Sequence", "value": 5534},
{"name": "Transition", "value": 9201},
{"name": "Transitioner", "value": 19975},
{"name": "TransitionEvent", "value": 1116},
{"name": "Tween", "value": 6006}
]
},
{
"name": "data",
"children": [
{
"name": "converters",
"children": [
{"name": "Converters", "value": 721},
{"name": "DelimitedTextConverter", "value": 4294},
{"name": "GraphMLConverter", "value": 9800},
{"name": "IDataConverter", "value": 1314},
{"name": "JSONConverter", "value": 2220}
]
},
{"name": "DataField", "value": 1759},
{"name": "DataSchema", "value": 2165},
{"name": "DataSet", "value": 586},
{"name": "DataSource", "value": 3331},
{"name": "DataTable", "value": 772},
{"name": "DataUtil", "value": 3322}
]
},
{
"name": "display",
"children": [
{"name": "DirtySprite", "value": 8833},
{"name": "LineSprite", "value": 1732},
{"name": "RectSprite", "value": 3623},
{"name": "TextSprite", "value": 10066}
]
},
{
"name": "flex",
"children": [
{"name": "FlareVis", "value": 4116}
]
},
{
"name": "physics",
"children": [
{"name": "DragForce", "value": 1082},
{"name": "GravityForce", "value": 1336},
{"name": "IForce", "value": 319},
{"name": "NBodyForce", "value": 10498},
{"name": "Particle", "value": 2822},
{"name": "Simulation", "value": 9983},
{"name": "Spring", "value": 2213},
{"name": "SpringForce", "value": 1681}
]
},
{
"name": "query",
"children": [
{"name": "AggregateExpression", "value": 1616},
{"name": "And", "value": 1027},
{"name": "Arithmetic", "value": 3891},
{"name": "Average", "value": 891},
{"name": "BinaryExpression", "value": 2893},
{"name": "Comparison", "value": 5103},
{"name": "CompositeExpression", "value": 3677},
{"name": "Count", "value": 781},
{"name": "DateUtil", "value": 4141},
{"name": "Distinct", "value": 933},
{"name": "Expression", "value": 5130},
{"name": "ExpressionIterator", "value": 3617},
{"name": "Fn", "value": 3240},
{"name": "If", "value": 2732},
{"name": "IsA", "value": 2039},
{"name": "Literal", "value": 1214},
{"name": "Match", "value": 3748},
{"name": "Maximum", "value": 843},
{
"name": "methods",
"children": [
{"name": "add", "value": 593},
{"name": "and", "value": 330},
{"name": "average", "value": 287},
{"name": "count", "value": 277},
{"name": "distinct", "value": 292},
{"name": "div", "value": 595},
{"name": "eq", "value": 594},
{"name": "fn", "value": 460},
{"name": "gt", "value": 603},
{"name": "gte", "value": 625},
{"name": "iff", "value": 748},
{"name": "isa", "value": 461},
{"name": "lt", "value": 597},
{"name": "lte", "value": 619},
{"name": "max", "value": 283},
{"name": "min", "value": 283},
{"name": "mod", "value": 591},
{"name": "mul", "value": 603},
{"name": "neq", "value": 599},
{"name": "not", "value": 386},
{"name": "or", "value": 323},
{"name": "orderby", "value": 307},
{"name": "range", "value": 772},
{"name": "select", "value": 296},
{"name": "stddev", "value": 363},
{"name": "sub", "value": 600},
{"name": "sum", "value": 280},
{"name": "update", "value": 307},
{"name": "variance", "value": 335},
{"name": "where", "value": 299},
{"name": "xor", "value": 354},
{"name": "_", "value": 264}
]
},
{"name": "Minimum", "value": 843},
{"name": "Not", "value": 1554},
{"name": "Or", "value": 970},
{"name": "Query", "value": 13896},
{"name": "Range", "value": 1594},
{"name": "StringUtil", "value": 4130},
{"name": "Sum", "value": 791},
{"name": "Variable", "value": 1124},
{"name": "Variance", "value": 1876},
{"name": "Xor", "value": 1101}
]
},
{
"name": "scale",
"children": [
{"name": "IScaleMap", "value": 2105},
{"name": "LinearScale", "value": 1316},
{"name": "LogScale", "value": 3151},
{"name": "OrdinalScale", "value": 3770},
{"name": "QuantileScale", "value": 2435},
{"name": "QuantitativeScale", "value": 4839},
{"name": "RootScale", "value": 1756},
{"name": "Scale", "value": 4268},
{"name": "ScaleType", "value": 1821},
{"name": "TimeScale", "value": 5833}
]
},
{
"name": "util",
"children": [
{"name": "Arrays", "value": 8258},
{"name": "Colors", "value": 10001},
{"name": "Dates", "value": 8217},
{"name": "Displays", "value": 12555},
{"name": "Filter", "value": 2324},
{"name": "Geometry", "value": 10993},
{
"name": "heap",
"children": [
{"name": "FibonacciHeap", "value": 9354},
{"name": "HeapNode", "value": 1233}
]
},
{"name": "IEvaluable", "value": 335},
{"name": "IPredicate", "value": 383},
{"name": "IValueProxy", "value": 874},
{
"name": "math",
"children": [
{"name": "DenseMatrix", "value": 3165},
{"name": "IMatrix", "value": 2815},
{"name": "SparseMatrix", "value": 3366}
]
},
{"name": "Maths", "value": 17705},
{"name": "Orientation", "value": 1486},
{
"name": "palette",
"children": [
{"name": "ColorPalette", "value": 6367},
{"name": "Palette", "value": 1229},
{"name": "ShapePalette", "value": 2059},
{"name": "SizePalette", "value": 2291}
]
},
{"name": "Property", "value": 5559},
{"name": "Shapes", "value": 19118},
{"name": "Sort", "value": 6887},
{"name": "Stats", "value": 6557},
{"name": "Strings", "value": 22026}
]
},
{
"name": "vis",
"children": [
{
"name": "axis",
"children": [
{"name": "Axes", "value": 1302},
{"name": "Axis", "value": 24593},
{"name": "AxisGridLine", "value": 652},
{"name": "AxisLabel", "value": 636},
{"name": "CartesianAxes", "value": 6703}
]
},
{
"name": "controls",
"children": [
{"name": "AnchorControl", "value": 2138},
{"name": "ClickControl", "value": 3824},
{"name": "Control", "value": 1353},
{"name": "ControlList", "value": 4665},
{"name": "DragControl", "value": 2649},
{"name": "ExpandControl", "value": 2832},
{"name": "HoverControl", "value": 4896},
{"name": "IControl", "value": 763},
{"name": "PanZoomControl", "value": 5222},
{"name": "SelectionControl", "value": 7862},
{"name": "TooltipControl", "value": 8435}
]
},
{
"name": "data",
"children": [
{"name": "Data", "value": 20544},
{"name": "DataList", "value": 19788},
{"name": "DataSprite", "value": 10349},
{"name": "EdgeSprite", "value": 3301},
{"name": "NodeSprite", "value": 19382},
{
"name": "render",
"children": [
{"name": "ArrowType", "value": 698},
{"name": "EdgeRenderer", "value": 5569},
{"name": "IRenderer", "value": 353},
{"name": "ShapeRenderer", "value": 2247}
]
},
{"name": "ScaleBinding", "value": 11275},
{"name": "Tree", "value": 7147},
{"name": "TreeBuilder", "value": 9930}
]
},
{
"name": "events",
"children": [
{"name": "DataEvent", "value": 2313},
{"name": "SelectionEvent", "value": 1880},
{"name": "TooltipEvent", "value": 1701},
{"name": "VisualizationEvent", "value": 1117}
]
},
{
"name": "legend",
"children": [
{"name": "Legend", "value": 20859},
{"name": "LegendItem", "value": 4614},
{"name": "LegendRange", "value": 10530}
]
},
{
"name": "operator",
"children": [
{
"name": "distortion",
"children": [
{"name": "BifocalDistortion", "value": 4461},
{"name": "Distortion", "value": 6314},
{"name": "FisheyeDistortion", "value": 3444}
]
},
{
"name": "encoder",
"children": [
{"name": "ColorEncoder", "value": 3179},
{"name": "Encoder", "value": 4060},
{"name": "PropertyEncoder", "value": 4138},
{"name": "ShapeEncoder", "value": 1690},
{"name": "SizeEncoder", "value": 1830}
]
},
{
"name": "filter",
"children": [
{"name": "FisheyeTreeFilter", "value": 5219},
{"name": "GraphDistanceFilter", "value": 3165},
{"name": "VisibilityFilter", "value": 3509}
]
},
{"name": "IOperator", "value": 1286},
{
"name": "label",
"children": [
{"name": "Labeler", "value": 9956},
{"name": "RadialLabeler", "value": 3899},
{"name": "StackedAreaLabeler", "value": 3202}
]
},
{
"name": "layout",
"children": [
{"name": "AxisLayout", "value": 6725},
{"name": "BundledEdgeRouter", "value": 3727},
{"name": "CircleLayout", "value": 9317},
{"name": "CirclePackingLayout", "value": 12003},
{"name": "DendrogramLayout", "value": 4853},
{"name": "ForceDirectedLayout", "value": 8411},
{"name": "IcicleTreeLayout", "value": 4864},
{"name": "IndentedTreeLayout", "value": 3174},
{"name": "Layout", "value": 7881},
{"name": "NodeLinkTreeLayout", "value": 12870},
{"name": "PieLayout", "value": 2728},
{"name": "RadialTreeLayout", "value": 12348},
{"name": "RandomLayout", "value": 870},
{"name": "StackedAreaLayout", "value": 9121},
{"name": "TreeMapLayout", "value": 9191}
]
},
{"name": "Operator", "value": 2490},
{"name": "OperatorList", "value": 5248},
{"name": "OperatorSequence", "value": 4190},
{"name": "OperatorSwitch", "value": 2581},
{"name": "SortOperator", "value": 2023}
]
},
{"name": "Visualization", "value": 16540}
]
}
]
}
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<script src="https://d3js.org/d3.v3.min.js"></script>
<style>
#chart {
width: 760px;
height: 400px;
background: #ddd;
}
text {
pointer-events: none;
}
.treemap-svg .grandparent text {
font-weight: bold;
font-size: 20px;
}
.treemap-svg rect {
fill: none;
stroke: #fff;
}
.treemap-svg rect.parent,
.treemap-svg .grandparent rect {
stroke-width: 2px;
}
.treemap-svg .grandparent rect {
fill: orange;
}
.treemap-svg .grandparent:hover rect {
fill: #ee9700;
}
.treemap-svg .children rect.parent,
.treemap-svg .grandparent rect {
cursor: pointer;
}
.treemap-svg .children rect.parent {
fill: #666666;
fill-opacity: .5;
}
.treemap-svg .children:hover rect.child {
fill: #545454;
}
</style>
</head>
<body>
<div id="chart"></div>
<script>
var defaults = {
width: 760,
height: 400,
uid:"chart",
margin: {top: 50, right: 0, bottom: 0, left: 0},
child: "name",
value: "value"
};
var cf = defaults;
var margin = cf.margin,
width = cf.width,
height = cf.height - margin.top - margin.bottom,
formatNumber = d3.format(",d"),
transitioning;
// Great way to do a tooltip.
var tooltip = d3.select("body")
.append("div")
.style("position", "absolute")
.style("z-index", "10")
.style("visibility", "hidden")
.style("color", "white")
.style("padding", "8px")
.style("background-color", "rgba(0, 0, 0, 0.75)")
.style("border-radius", "6px")
.style("font", "12px sans-serif")
.text("tooltip");
// Format number depending on the value:
function formatNumber(d_) {
// this function can be called as formatNumber_tangible_data, which is in scripts.js
var d = Math.abs(d_);
var decs = Math.floor(d) == 0? d - Math.floor(d): d % Math.floor(d) ;
if(decs == 0) d_ = Math.round(d_);
if(d > 100000) return d3.format(",d")(Math.round(d_));
if(d > 10000) return d3.format("d")(Math.round(d_));
if(decs == 0) return d3.format("d")(Math.round(d_));
if( d > 10 & decs > 0.1) return d3.format(".1f")(d_);
if( d > 10 & decs <= 0.1) return d3.format(".0f")(d_);
if( d > 0 & decs > 0.01) return d3.format(".2f")(d_);
if( d > 0 & decs <= 0.01) return d3.format("e")(d_);
return d3.format("s")(d_);
}
function make_title(d){
console.log("making_title", d);
return d[cf.child] ? d[cf.child] + " (" + formatNumber(d[cf.value]) + ")" : d.key + " (" + formatNumber(d[cf.value]) + ")";
}
function google_colors(n) {
var colores_g = ["#3366cc", "#dc3912", "#ff9900", "#109618", "#990099", "#0099c6", "#dd4477", "#66aa00", "#b82e2e", "#316395", "#994499", "#22aa99", "#aaaa11", "#6633cc", "#e67300", "#8b0707", "#651067", "#329262", "#5574a6", "#3b3eac"];
return colores_g[n % colores_g.length];
}
var x = d3.scale.linear()
.domain([0, width])
.range([0, width]);
var y = d3.scale.linear()
.domain([0, height])
.range([0, height]);
var treemap = d3.layout.treemap()
.children(function(d, depth) { return depth ? null : d._children; })
.sort(function(a, b) { return a.value - b.value; })
.ratio(height / width * 0.5 * (1 + Math.sqrt(5)))
.round(false);
var svg = d3.select("#chart").append("svg")
.attr("width", width + margin.left + margin.right)
.attr("height", height + margin.bottom + margin.top)
.style("margin-left", -margin.left + "px")
.style("margin.right", -margin.right + "px")
.classed("treemap-svg", true)
.append("g")
.attr("transform", "translate(" + margin.left + "," + margin.top + ")")
.style("shape-rendering", "crispEdges");
var grandparent = svg.append("g")
.attr("class", "grandparent");
grandparent.append("rect")
.attr("y", -margin.top)
.attr("width", width)
.attr("height", margin.top);
grandparent.append("text")
.attr("x", 6)
.attr("y", 6 - margin.top)
.attr("dy", "1.3em");
d3.json("flare.json", function(root) {
//var names = d3.map(root, function(d){return d[cf.;}).keys()
//console.log("names", names);
initialize(root);
accumulate(root);
layout(root);
display(root);
function initialize(root) {
root.x = root.y = 0;
root.dx = width;
root.dy = height;
root.depth = 0;
}
// Aggregate the values for internal nodes. This is normally done by the
// treemap layout, but not here because of our custom implementation.
// We also take a snapshot of the original children (_children) to avoid
// the children being overwritten when when layout is computed.
function accumulate(d) {
return (d._children = d.children)
? d.value = d.children.reduce(function(p, v) { return p + accumulate(v); }, 0)
: d.value;
}
// Compute the treemap layout recursively such that each group of siblings
// uses the same size (1×1) rather than the dimensions of the parent cell.
// This optimizes the layout for the current zoom state. Note that a wrapper
// object is created for the parent node for each group of siblings so that
// the parent’s dimensions are not discarded as we recurse. Since each group
// of sibling was laid out in 1×1, we must rescale to fit using absolute
// coordinates. This lets us use a viewport to zoom.
function layout(d) {
if (d._children) {
treemap.nodes({_children: d._children});
d._children.forEach(function(c) {
c.x = d.x + c.x * d.dx;
c.y = d.y + c.y * d.dy;
c.dx *= d.dx;
c.dy *= d.dy;
c.parent = d;
layout(c);
});
}
}
function display(d) {
//c20.domain(names)
grandparent
.datum(d.parent)
.on("click", transition)
.select("text")
.text(name(d));
var g1 = svg.insert("g", ".grandparent")
.datum(d)
.attr("class", "depth");
var g = g1.selectAll("g")
.data(d._children)
.enter().append("g");
g.filter(function(d) { return d._children; })
.classed("children", true)
.on("click", transition);
g.selectAll(".child")
.data(function(d) { return d._children || [d]; })
.enter().append("rect")
.attr("class", "child")
.call(rect)
;
g.append("rect")
.attr("class", "parent")
.call(rect)
//.append("title")
// .text(function(d) { return formatNumber(d.value); });
.on("mouseover", function(d) {
tooltip.html(make_title(d));
tooltip.transition();
return tooltip.style("visibility", "visible").style("opacity", 1) //transition().duration(5000).style("opacity", 0);
})
.on("mousemove", function() {
tooltip.style("opacity", 1);
return tooltip.style("top", (d3.event.pageY-10)+"px").style("left",(d3.event.pageX+10)+"px");
})
.on("mouseout", function(){return tooltip.style("visibility", "hidden");});
g.append("text")
.attr("dy", ".75em")
.text(function(d) { return d.name; })
.call(text);
//console.log("rects", g.selectAll("rect"));
function transition(d) {
if (transitioning || !d) return;
transitioning = true;
var g2 = display(d);
//console.log("displayed", g2);
var t1 = g1.transition().duration(750),
t2 = g2.transition().duration(750);
// Update the domain only after entering new elements.
x.domain([d.x, d.x + d.dx]);
y.domain([d.y, d.y + d.dy]);
// Enable anti-aliasing during the transition.
svg.style("shape-rendering", null);
// Draw child nodes on top of parent nodes.
svg.selectAll(".depth").sort(function(a, b) { return a.depth - b.depth; });
// Fade-in entering text.
g2.selectAll("text").style("fill-opacity", 0);
// Transition to the new view.
t1.selectAll("text").call(text).style("fill-opacity", 0);
t2.selectAll("text").call(text).style("fill-opacity", 1);
t1.selectAll("rect").call(rect);
t2.selectAll("rect").call(rect);
//g.selectAll("text").each(function(s){console.log("s",s)});
// Remove the old node when the transition is finished.
t1.remove().each("end", function() {
svg.style("shape-rendering", "crispEdges");
transitioning = false;
});
//t2.each("end", wrapAll);;
}
return g;
}
function text_size(d){
var dx = x(d.x + d.dx) - x(d.x);
var dy = y(d.y + d.dy) - y(d.y);
var ref = (cf.width*cf.height) / (760 * 400);
var ss = 10 + 220 * ref * dx*dy/(cf.width*cf.height);
//console.log("size", ss, dx,dy);
var s = Math.floor(Math.max(9, ss));
return s;
}
function wrap_size(d){
var w = x(d.x + d.dx) - x(d.x);
var text = d3.select(this);
var self = this;
var cl = self.getComputedTextLength();
var fs = parseFloat(text.style("font-size"));
var ss = w / cl * fs /3.4;
ss = Math.max(12,ss) + "px";
var len = d.name.length;
/*console.log("name", d.name,
"length", len,
"font", fs,
"cl" , cl,
"cl/len", cl /len,
"w", w,
"prop", w / cl,
"ss", ss
);
*/
text.style("font-size", ss);
text.attr("dy", ".65em");
}
function text(text) {
text
//.style("font-size", function(d){return wrap_txt(d)})
.attr("x", function(d) { return x(d.x) + 6; })
//.attr("dx", function(d) {return x(d.x + d.dx) - x(d.x)})
.attr("y", function(d) { return y(d.y) + Math.max(6,text_size(d) /10); })
.attr("width", function(d) { return x(d.x + d.dx) - x(d.x); })
text.each(wrap_size);
}
function color_rect(d,i){
//console.log("col", d, i);
return c20(d.name);
}
function rect(rect) {
rect.attr("x", function(d) { return x(d.x); })
.attr("y", function(d) { return y(d.y); })
.attr("width", function(d) { return x(d.x + d.dx) - x(d.x); })
.attr("height", function(d) { return y(d.y + d.dy) - y(d.y); })
.style("fill", function(d,i){return google_colors(i)})
.style("fill-opacity", 0.6);
}
function name(d) {
return d.parent
? name(d.parent) + " // " + d.name + " (" + formatNumber(d.value) + ")"
: d.name + " (" + formatNumber(d.value) + ")";
}
});
</script>
</body>
Type Category Date Annual.total Average.households value
Income salary 2015-01-01 43100 38500 3400
Income interest income 2015-01-01 360 750 90
Income pesnion 2015-01-01 1800 6000 150
Income stock dividend 2015-01-01 4350 3800 2800
expenditures rent 2015-01-01 14400 15000 1200
expenditures lending rates 2015-01-01 524 600 50
expenditures loan interest 2015-01-01 1080 1300 90
expenditures food 2015-01-01 4133 4000 250
expenditures gas 2015-01-01 1420 4000 100
expenditures car insurance 2015-01-01 960 1500 240
expenditures clothes 2015-01-01 2703 1500 50
expenditures shoes 2015-01-01 1055 700 150
expenditures school for children 2015-01-01 1220 300 90
expenditures homeowner´s insurance 2015-01-01 540 650 45
expenditures bank charges 2015-01-01 180 200 15
expenditures water 2015-01-01 960 750 80
expenditures electricity 2015-01-01 1080 1008 90
expenditures heater 2015-01-01 1320 950 110
expenditures cinema 2015-01-01 90 70 25
expenditures restaurant 2015-01-01 1445 1560 75
expenditures entertainment 2015-01-01 6145 3120 89
expenditures health care 2015-01-01 1280 1200 150
surplus surplus 2015-01-01 10355 17019 3691
Income salary 2015-02-01 43100 38500 3400
Income interest income 2015-02-01 360 750 0
Income pesnion 2015-02-01 1800 6000 150
Income stock dividend 2015-02-01 4350 3800 0
expenditures rent 2015-02-01 14400 15000 1200
expenditures lending rates 2015-02-01 524 600 50
expenditures loan interest 2015-02-01 1080 1300 90
expenditures food 2015-02-01 4133 4000 300
expenditures gas 2015-02-01 1420 4000 90
expenditures car insurance 2015-02-01 960 1500 0
expenditures clothes 2015-02-01 2703 1500 70
expenditures shoes 2015-02-01 1055 700 0
expenditures school for children 2015-02-01 1220 300 70
expenditures homeowner´s insurance 2015-02-01 540 650 45
expenditures bank charges 2015-02-01 180 200 15
expenditures water 2015-02-01 960 750 80
expenditures electricity 2015-02-01 1080 1008 90
expenditures heater 2015-02-01 1320 950 110
expenditures cinema 2015-02-01 90 70 0
expenditures restaurant 2015-02-01 1445 1560 120
expenditures entertainment 2015-02-01 6145 3120 80
expenditures health care 2015-02-01 1280 1200 130
surplus surplus 2015-02-01 10355 17019 1140
Income salary 2015-03-01 43100 38500 3400
Income interest income 2015-03-01 360 750 0
Income pesnion 2015-03-01 1800 6000 150
Income stock dividend 2015-03-01 4350 3800 0
expenditures rent 2015-03-01 14400 15000 1200
expenditures lending rates 2015-03-01 524 600 47
expenditures loan interest 2015-03-01 1080 1300 90
expenditures food 2015-03-01 4133 4000 340
expenditures gas 2015-03-01 1420 4000 110
expenditures car insurance 2015-03-01 960 1500 0
expenditures clothes 2015-03-01 2703 1500 200
expenditures shoes 2015-03-01 1055 700 200
expenditures school for children 2015-03-01 1220 300 40
expenditures homeowner´s insurance 2015-03-01 540 650 45
expenditures bank charges 2015-03-01 180 200 15
expenditures water 2015-03-01 960 750 80
expenditures electricity 2015-03-01 1080 1008 90
expenditures heater 2015-03-01 1320 950 110
expenditures cinema 2015-03-01 90 70 20
expenditures restaurant 2015-03-01 1445 1560 140
expenditures entertainment 2015-03-01 6145 3120 95
expenditures health care 2015-03-01 1280 1200 100
surplus surplus 2015-03-01 10355 17019 728
Income salary 2015-04-01 43100 38500 3400
Income interest income 2015-04-01 360 750 190
Income pesnion 2015-04-01 1800 6000 150
Income stock dividend 2015-04-01 4350 3800 0
expenditures rent 2015-04-01 14400 15000 1200
expenditures lending rates 2015-04-01 524 600 47
expenditures loan interest 2015-04-01 1080 1300 90
expenditures food 2015-04-01 4133 4000 370
expenditures gas 2015-04-01 1420 4000 105
expenditures car insurance 2015-04-01 960 1500 240
expenditures clothes 2015-04-01 2703 1500 40
expenditures shoes 2015-04-01 1055 700 70
expenditures school for children 2015-04-01 1220 300 450
expenditures homeowner´s insurance 2015-04-01 540 650 45
expenditures bank charges 2015-04-01 180 200 15
expenditures water 2015-04-01 960 750 80
expenditures electricity 2015-04-01 1080 1008 90
expenditures heater 2015-04-01 1320 950 110
expenditures cinema 2015-04-01 90 70 20
expenditures restaurant 2015-04-01 1445 1560 130
expenditures entertainment 2015-04-01 6145 3120 75
expenditures health care 2015-04-01 1280 1200 100
surplus surplus 2015-04-01 10355 17019 563
Income salary 2015-05-01 43100 38500 3400
Income interest income 2015-05-01 360 750 0
Income pesnion 2015-05-01 1800 6000 150
Income stock dividend 2015-05-01 4350 3800 1300
expenditures rent 2015-05-01 14400 15000 1200
expenditures lending rates 2015-05-01 524 600 44
expenditures loan interest 2015-05-01 1080 1300 90
expenditures food 2015-05-01 4133 4000 380
expenditures gas 2015-05-01 1420 4000 98
expenditures car insurance 2015-05-01 960 1500 0
expenditures clothes 2015-05-01 2703 1500 340
expenditures shoes 2015-05-01 1055 700 0
expenditures school for children 2015-05-01 1220 300 80
expenditures homeowner´s insurance 2015-05-01 540 650 45
expenditures bank charges 2015-05-01 180 200 15
expenditures water 2015-05-01 960 750 80
expenditures electricity 2015-05-01 1080 1008 90
expenditures heater 2015-05-01 1320 950 110
expenditures cinema 2015-05-01 90 70 0
expenditures restaurant 2015-05-01 1445 1560 50
expenditures entertainment 2015-05-01 6145 3120 150
expenditures health care 2015-05-01 1280 1200 90
surplus surplus 2015-05-01 10355 17019 2078
Income salary 2015-06-01 43100 38500 3400
Income interest income 2015-06-01 360 750 0
Income pesnion 2015-06-01 1800 6000 150
Income stock dividend 2015-06-01 4350 3800 250
expenditures rent 2015-06-01 14400 15000 1200
expenditures lending rates 2015-06-01 524 600 44
expenditures loan interest 2015-06-01 1080 1300 90
expenditures food 2015-06-01 4133 4000 333
expenditures gas 2015-06-01 1420 4000 140
expenditures car insurance 2015-06-01 960 1500 0
expenditures clothes 2015-06-01 2703 1500 270
expenditures shoes 2015-06-01 1055 700 110
expenditures school for children 2015-06-01 1220 300 50
expenditures homeowner´s insurance 2015-06-01 540 650 45
expenditures bank charges 2015-06-01 180 200 15
expenditures water 2015-06-01 960 750 80
expenditures electricity 2015-06-01 1080 1008 90
expenditures heater 2015-06-01 1320 950 110
expenditures cinema 2015-06-01 90 70 0
expenditures restaurant 2015-06-01 1445 1560 55
expenditures entertainment 2015-06-01 6145 3120 111
expenditures health care 2015-06-01 1280 1200 70
surplus surplus 2015-06-01 10355 17019 1057
Income salary 2015-07-01 43100 38500 4100
Income interest income 2015-07-01 360 750 0
Income pesnion 2015-07-01 1800 6000 150
Income stock dividend 2015-07-01 4350 3800 0
expenditures rent 2015-07-01 14400 15000 1200
expenditures lending rates 2015-07-01 524 600 43
expenditures loan interest 2015-07-01 1080 1300 90
expenditures food 2015-07-01 4133 4000 370
expenditures gas 2015-07-01 1420 4000 139
expenditures car insurance 2015-07-01 960 1500 240
expenditures clothes 2015-07-01 2703 1500 130
expenditures shoes 2015-07-01 1055 700 150
expenditures school for children 2015-07-01 1220 300 100
expenditures homeowner´s insurance 2015-07-01 540 650 45
expenditures bank charges 2015-07-01 180 200 15
expenditures water 2015-07-01 960 750 80
expenditures electricity 2015-07-01 1080 1008 90
expenditures heater 2015-07-01 1320 950 110
expenditures cinema 2015-07-01 90 70 0
expenditures restaurant 2015-07-01 1445 1560 70
expenditures entertainment 2015-07-01 6145 3120 75
expenditures health care 2015-07-01 1280 1200 70
surplus surplus 2015-07-01 10355 17019 1303
Income salary 2015-08-01 43100 38500 3400
Income interest income 2015-08-01 360 750 0
Income pesnion 2015-08-01 1800 6000 150
Income stock dividend 2015-08-01 4350 3800 0
expenditures rent 2015-08-01 14400 15000 1200
expenditures lending rates 2015-08-01 524 600 43
expenditures loan interest 2015-08-01 1080 1300 90
expenditures food 2015-08-01 4133 4000 270
expenditures gas 2015-08-01 1420 4000 170
expenditures car insurance 2015-08-01 960 1500 0
expenditures clothes 2015-08-01 2703 1500 550
expenditures shoes 2015-08-01 1055 700 65
expenditures school for children 2015-08-01 1220 300 0
expenditures homeowner´s insurance 2015-08-01 540 650 45
expenditures bank charges 2015-08-01 180 200 15
expenditures water 2015-08-01 960 750 80
expenditures electricity 2015-08-01 1080 1008 90
expenditures heater 2015-08-01 1320 950 110
expenditures cinema 2015-08-01 90 70 25
expenditures restaurant 2015-08-01 1445 1560 350
expenditures entertainment 2015-08-01 6145 3120 5000
expenditures health care 2015-08-01 1280 1200 60
surplus surplus 2015-08-01 10355 17019 -4553
Income salary 2015-09-01 43100 38500 3400
Income interest income 2015-09-01 360 750 80
Income pesnion 2015-09-01 1800 6000 150
Income stock dividend 2015-09-01 4350 3800 0
expenditures rent 2015-09-01 14400 15000 1200
expenditures lending rates 2015-09-01 524 600 40
expenditures loan interest 2015-09-01 1080 1300 90
expenditures food 2015-09-01 4133 4000 340
expenditures gas 2015-09-01 1420 4000 150
expenditures car insurance 2015-09-01 960 1500 0
expenditures clothes 2015-09-01 2703 1500 90
expenditures shoes 2015-09-01 1055 700 80
expenditures school for children 2015-09-01 1220 300 150
expenditures homeowner´s insurance 2015-09-01 540 650 45
expenditures bank charges 2015-09-01 180 200 15
expenditures water 2015-09-01 960 750 80
expenditures electricity 2015-09-01 1080 1008 90
expenditures heater 2015-09-01 1320 950 110
expenditures cinema 2015-09-01 90 70 0
expenditures restaurant 2015-09-01 1445 1560 130
expenditures entertainment 2015-09-01 6145 3120 90
expenditures health care 2015-09-01 1280 1200 100
surplus surplus 2015-09-01 10355 17019 930
Income salary 2015-10-01 43100 38500 3400
Income interest income 2015-10-01 360 750 0
Income pesnion 2015-10-01 1800 6000 150
Income stock dividend 2015-10-01 4350 3800 0
expenditures rent 2015-10-01 14400 15000 1200
expenditures lending rates 2015-10-01 524 600 40
expenditures loan interest 2015-10-01 1080 1300 90
expenditures food 2015-10-01 4133 4000 390
expenditures gas 2015-10-01 1420 4000 100
expenditures car insurance 2015-10-01 960 1500 240
expenditures clothes 2015-10-01 2703 1500 75
expenditures shoes 2015-10-01 1055 700 0
expenditures school for children 2015-10-01 1220 300 50
expenditures homeowner´s insurance 2015-10-01 540 650 45
expenditures bank charges 2015-10-01 180 200 15
expenditures water 2015-10-01 960 750 80
expenditures electricity 2015-10-01 1080 1008 90
expenditures heater 2015-10-01 1320 950 110
expenditures cinema 2015-10-01 90 70 0
expenditures restaurant 2015-10-01 1445 1560 110
expenditures entertainment 2015-10-01 6145 3120 95
expenditures health care 2015-10-01 1280 1200 130
surplus surplus 2015-10-01 10355 17019 820
Income salary 2015-11-01 43100 38500 3400
Income interest income 2015-11-01 360 750 0
Income pesnion 2015-11-01 1800 6000 150
Income stock dividend 2015-11-01 4350 3800 0
expenditures rent 2015-11-01 14400 15000 1200
expenditures lending rates 2015-11-01 524 600 38
expenditures loan interest 2015-11-01 1080 1300 90
expenditures food 2015-11-01 4133 4000 340
expenditures gas 2015-11-01 1420 4000 103
expenditures car insurance 2015-11-01 960 1500 0
expenditures clothes 2015-11-01 2703 1500 88
expenditures shoes 2015-11-01 1055 700 100
expenditures school for children 2015-11-01 1220 300 70
expenditures homeowner´s insurance 2015-11-01 540 650 45
expenditures bank charges 2015-11-01 180 200 15
expenditures water 2015-11-01 960 750 80
expenditures electricity 2015-11-01 1080 1008 90
expenditures heater 2015-11-01 1320 950 110
expenditures cinema 2015-11-01 90 70 0
expenditures restaurant 2015-11-01 1445 1560 65
expenditures entertainment 2015-11-01 6145 3120 85
expenditures health care 2015-11-01 1280 1200 150
surplus surplus 2015-11-01 10355 17019 1031
Income salary 2015-12-01 43100 38500 5000
Income pesnion 2015-12-01 1800 6000 150
Income stock dividend 2015-12-01 4350 3800 0
expenditures rent 2015-12-01 14400 15000 1200
expenditures lending rates 2015-12-01 524 600 38
expenditures loan interest 2015-12-01 1080 1300 90
expenditures food 2015-12-01 4133 4000 450
expenditures gas 2015-12-01 1420 4000 115
expenditures car insurance 2015-12-01 960 1500 0
expenditures clothes 2015-12-01 2703 1500 800
expenditures shoes 2015-12-01 1055 700 130
expenditures school for children 2015-12-01 1220 300 70
expenditures homeowner´s insurance 2015-12-01 540 650 45
expenditures bank charges 2015-12-01 180 200 15
expenditures water 2015-12-01 960 750 80
expenditures electricity 2015-12-01 1080 1008 90
expenditures heater 2015-12-01 1320 950 110
expenditures cinema 2015-12-01 90 70 0
expenditures restaurant 2015-12-01 1445 1560 150
expenditures entertainment 2015-12-01 6145 3120 200
expenditures health care 2015-12-01 1280 1200 130
surplus surplus 2015-12-01 10355 17019 1567
Income salary 2016-01-01 43100 38500 3500
Income interest income 2016-01-01 360 750 0
Income pesnion 2016-01-01 1800 6000 150
Income stock dividend 2016-01-01 4350 3800 2800
expenditures rent 2016-01-01 14400 15000 1200
expenditures lending rates 2016-01-01 524 600 60
expenditures loan interest 2016-01-01 1080 1300 90
expenditures food 2016-01-01 4133 4000 300
expenditures gas 2016-01-01 1420 4000 130
expenditures car insurance 2016-01-01 960 1500 240
expenditures clothes 2016-01-01 2703 1500 130
expenditures shoes 2016-01-01 1055 700 0
expenditures school for children 2016-01-01 1220 300 90
expenditures homeowner´s insurance 2016-01-01 540 650 45
expenditures bank charges 2016-01-01 180 200 15
expenditures water 2016-01-01 960 750 80
expenditures electricity 2016-01-01 1080 1008 90
expenditures heater 2016-01-01 1320 950 110
expenditures cinema 2016-01-01 90 70 0
expenditures restaurant 2016-01-01 1445 1560 130
expenditures entertainment 2016-01-01 6145 3120 200
expenditures health care 2016-01-01 1280 1200 140
surplus surplus 2016-01-01 10355 17019 3540
Income salary 2016-02-01 43100 38500 3500
Income pesnion 2016-02-01 1800 6000 150
Income stock dividend 2016-02-01 4350 3800 0
expenditures rent 2016-02-01 14400 15000 1200
expenditures lending rates 2016-02-01 524 600 60
expenditures loan interest 2016-02-01 1080 1300 90
expenditures food 2016-02-01 4133 4000 210
expenditures gas 2016-02-01 1420 4000 110
expenditures car insurance 2016-02-01 960 1500 0
expenditures clothes 2016-02-01 2703 1500 90
expenditures shoes 2016-02-01 1055 700 80
expenditures school for children 2016-02-01 1220 300 70
expenditures homeowner´s insurance 2016-02-01 540 650 45
expenditures bank charges 2016-02-01 180 200 15
expenditures water 2016-02-01 960 750 80
expenditures electricity 2016-02-01 1080 1008 90
expenditures heater 2016-02-01 1320 950 110
expenditures cinema 2016-02-01 90 70 30
expenditures restaurant 2016-02-01 1445 1560 80
expenditures entertainment 2016-02-01 6145 3120 150
expenditures health care 2016-02-01 1280 1200 120
surplus surplus 2016-02-01 10355 17019 1140
Income salary 2016-03-01 43100 38500 3500
Income interest income 2016-03-01 360 750 0
Income pesnion 2016-03-01 1800 6000 150
Income stock dividend 2016-03-01 4350 3800 0
expenditures rent 2016-03-01 14400 15000 1200
expenditures lending rates 2016-03-01 524 600 57
expenditures loan interest 2016-03-01 1080 1300 88
expenditures food 2016-03-01 4133 4000 320
expenditures gas 2016-03-01 1420 4000 140
expenditures car insurance 2016-03-01 960 1500 0
expenditures clothes 2016-03-01 2703 1500 140
expenditures shoes 2016-03-01 1055 700 100
expenditures school for children 2016-03-01 1220 300 50
expenditures homeowner´s insurance 2016-03-01 540 650 45
expenditures bank charges 2016-03-01 180 200 15
expenditures water 2016-03-01 960 750 80
expenditures electricity 2016-03-01 1080 1008 90
expenditures heater 2016-03-01 1320 950 110
expenditures cinema 2016-03-01 90 70 25
expenditures restaurant 2016-03-01 1445 1560 140
expenditures entertainment 2016-03-01 6145 3120 90
expenditures health care 2016-03-01 1280 1200 124
surplus surplus 2016-03-01 10355 17019 960
Income salary 2016-04-01 43100 38500 3500
Income interest income 2016-04-01 360 750 400
Income pesnion 2016-04-01 1800 6000 150
Income stock dividend 2016-04-01 4350 3800 0
expenditures rent 2016-04-01 14400 15000 1200
expenditures lending rates 2016-04-01 524 600 56
expenditures loan interest 2016-04-01 1080 1300 86
expenditures food 2016-04-01 4133 4000 270
expenditures gas 2016-04-01 1420 4000 140
expenditures car insurance 2016-04-01 960 1500 240
expenditures clothes 2016-04-01 2703 1500 120
expenditures shoes 2016-04-01 1055 700 110
expenditures school for children 2016-04-01 1220 300 70
expenditures homeowner´s insurance 2016-04-01 540 650 45
expenditures bank charges 2016-04-01 180 200 15
expenditures water 2016-04-01 960 750 80
expenditures electricity 2016-04-01 1080 1008 90
expenditures heater 2016-04-01 1320 950 110
expenditures cinema 2016-04-01 90 70 0
expenditures restaurant 2016-04-01 1445 1560 150
expenditures entertainment 2016-04-01 6145 3120 140
expenditures health care 2016-04-01 1280 1200 90
surplus surplus 2016-04-01 10355 17019 1128
Income salary 2016-05-01 43100 38500 3500
Income interest income 2016-05-01 360 750 200
Income pesnion 2016-05-01 1800 6000 150
Income stock dividend 2016-05-01 4350 3800 1300
expenditures rent 2016-05-01 14400 15000 1200
expenditures lending rates 2016-05-01 524 600 55
expenditures loan interest 2016-05-01 1080 1300 85
expenditures food 2016-05-01 4133 4000 330
expenditures gas 2016-05-01 1420 4000 120
expenditures car insurance 2016-05-01 960 1500 0
expenditures clothes 2016-05-01 2703 1500 110
expenditures shoes 2016-05-01 1055 700 90
expenditures school for children 2016-05-01 1220 300 74
expenditures homeowner´s insurance 2016-05-01 540 650 45
expenditures bank charges 2016-05-01 180 200 15
expenditures water 2016-05-01 960 750 80
expenditures electricity 2016-05-01 1080 1008 90
expenditures heater 2016-05-01 1320 950 110
expenditures cinema 2016-05-01 90 70 0
expenditures restaurant 2016-05-01 1445 1560 100
expenditures entertainment 2016-05-01 6145 3120 111
expenditures health care 2016-05-01 1280 1200 99
surplus surplus 2016-05-01 10355 17019 2535
Income salary 2016-06-01 43100 38500 3500
Income interest income 2016-06-01 360 750 0
Income pesnion 2016-06-01 1800 6000 150
Income stock dividend 2016-06-01 4350 3800 250
expenditures rent 2016-06-01 14400 15000 1200
expenditures lending rates 2016-06-01 524 600 53
expenditures loan interest 2016-06-01 1080 1300 63
expenditures food 2016-06-01 4133 4000 330
expenditures gas 2016-06-01 1420 4000 111
expenditures car insurance 2016-06-01 960 1500 0
expenditures clothes 2016-06-01 2703 1500 100
expenditures shoes 2016-06-01 1055 700 0
expenditures school for children 2016-06-01 1220 300 67
expenditures homeowner´s insurance 2016-06-01 540 650 45
expenditures bank charges 2016-06-01 180 200 15
expenditures water 2016-06-01 960 750 80
expenditures electricity 2016-06-01 1080 1008 90
expenditures heater 2016-06-01 1320 950 110
expenditures cinema 2016-06-01 90 70 30
expenditures restaurant 2016-06-01 1445 1560 86
expenditures entertainment 2016-06-01 6145 3120 80
expenditures health care 2016-06-01 1280 1200 70
surplus surplus 2016-06-01 10355 17019 1440
Income salary 2016-07-01 43100 38500 4100
Income interest income 2016-07-01 360 750 0
Income pesnion 2016-07-01 1800 6000 150
Income stock dividend 2016-07-01 4350 3800 0
expenditures rent 2016-07-01 14400 15000 1200
expenditures lending rates 2016-07-01 524 600 50
expenditures loan interest 2016-07-01 1080 1300 81
expenditures food 2016-07-01 4133 4000 350
expenditures gas 2016-07-01 1420 4000 140
expenditures car insurance 2016-07-01 960 1500 240
expenditures clothes 2016-07-01 2703 1500 130
expenditures shoes 2016-07-01 1055 700 110
expenditures school for children 2016-07-01 1220 300 77
expenditures homeowner´s insurance 2016-07-01 540 650 45
expenditures bank charges 2016-07-01 180 200 15
expenditures water 2016-07-01 960 750 80
expenditures electricity 2016-07-01 1080 1008 90
expenditures heater 2016-07-01 1320 950 110
expenditures cinema 2016-07-01 90 70 15
expenditures restaurant 2016-07-01 1445 1560 135
expenditures entertainment 2016-07-01 6145 3120 200
expenditures health care 2016-07-01 1280 1200 50
surplus surplus 2016-07-01 10355 17019 1182
Income salary 2016-08-01 43100 38500 3500
Income interest income 2016-08-01 360 750 0
Income pesnion 2016-08-01 1800 6000 150
Income stock dividend 2016-08-01 4350 3800 0
expenditures rent 2016-08-01 14400 15000 1200
expenditures lending rates 2016-08-01 524 600 48
expenditures loan interest 2016-08-01 1080 1300 80
expenditures food 2016-08-01 4133 4000 370
expenditures gas 2016-08-01 1420 4000 99
expenditures car insurance 2016-08-01 960 1500 0
expenditures clothes 2016-08-01 2703 1500 120
expenditures shoes 2016-08-01 1055 700 200
expenditures school for children 2016-08-01 1220 300 0
expenditures homeowner´s insurance 2016-08-01 540 650 45
expenditures bank charges 2016-08-01 180 200 15
expenditures water 2016-08-01 960 750 80
expenditures electricity 2016-08-01 1080 1008 90
expenditures heater 2016-08-01 1320 950 110
expenditures cinema 2016-08-01 90 70 0
expenditures restaurant 2016-08-01 1445 1560 200
expenditures entertainment 2016-08-01 6145 3120 170
expenditures health care 2016-08-01 1280 1200 65
surplus surplus 2016-08-01 10355 17019 823
Income salary 2016-09-01 43100 38500 3500
Income interest income 2016-09-01 360 750 0
Income pesnion 2016-09-01 1800 6000 150
Income stock dividend 2016-09-01 4350 3800 0
expenditures rent 2016-09-01 14400 15000 1200
expenditures lending rates 2016-09-01 524 600 47
expenditures loan interest 2016-09-01 1080 1300 79
expenditures food 2016-09-01 4133 4000 250
expenditures gas 2016-09-01 1420 4000 160
expenditures car insurance 2016-09-01 960 1500 0
expenditures clothes 2016-09-01 2703 1500 95
expenditures shoes 2016-09-01 1055 700 170
expenditures school for children 2016-09-01 1220 300 88
expenditures homeowner´s insurance 2016-09-01 540 650 45
expenditures bank charges 2016-09-01 180 200 15
expenditures water 2016-09-01 960 750 80
expenditures electricity 2016-09-01 1080 1008 90
expenditures heater 2016-09-01 1320 950 110
expenditures cinema 2016-09-01 90 70 20
expenditures restaurant 2016-09-01 1445 1560 165
expenditures entertainment 2016-09-01 6145 3120 130
expenditures health care 2016-09-01 1280 1200 56
surplus surplus 2016-09-01 10355 17019 906
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment