explorers: next-ship-estimates

{
    "blocks": [
        {
            "args": [],
            "type": "graphers",
            "block": [
                {
                    "type": "LineChart",
                    "title": "How many hours until Next becomes OurWorldInData.org? Here's what the team is predicting",
                    "ySlugs": "estimatedHoursUntilShip",
                    "subtitle": "When a project will ship is never a certainty\u2014lots of variables can impact the final ship date. One forecasting approaching is to build an ensemble of different models and average the results. In this chart, each model was trained differently before generating their predictions. Some implement a \"calm\" algorithm. Others, a \"caffeinated\" one. The ensemble should provide a better forecast than any individual prediction.",
                    "hasMapTab": "false",
                    "tableSlug": "Predictions",
                    "sourceDesc": "Data is updated daily from OCDC (Our world in Data Center for Data Collection)",
                    "Group Radio": "By person",
                    "hasChartTab": "true"
                },
                {
                    "type": "WorldMap",
                    "title": "How many hours until Next becomes OurWorldInData.org? Here's what the team is predicting, by country",
                    "ySlugs": "estimatedHoursUntilShip",
                    "subtitle": "Countries that have implemented strict lockdown measures have higher rates of indoor time and thus more optimistic about the amount of work we can get done in a shorter time period.",
                    "hasMapTab": "true",
                    "tableSlug": "Countries",
                    "sourceDesc": "This chart doesn't actually work yet, but wouldn't it be nice if we could do group by on the fly!",
                    "Group Radio": "By country",
                    "hasChartTab": "false"
                },
                {
                    "type": "LineChart",
                    "title": "Issues created & closed",
                    "ySlugs": "issuesCreated issuesClosed",
                    "hasMapTab": "false",
                    "tableSlug": "Issues",
                    "Group Radio": "Issues created",
                    "hasChartTab": "true"
                },
                {
                    "type": "LineChart",
                    "title": "Work remaining",
                    "ySlugs": "issuesStillOpen pDaysRemaining",
                    "hasMapTab": "false",
                    "tableSlug": "Issues",
                    "Group Radio": "Issues remaining",
                    "hasChartTab": "true"
                },
                {
                    "type": "LineChart",
                    "title": "P-days opened & closed",
                    "ySlugs": "pDaysCreated pDaysClosed",
                    "hasMapTab": "false",
                    "tableSlug": "Issues",
                    "Group Radio": "P-days created & closed",
                    "hasChartTab": "true"
                },
                {
                    "type": "LineChart",
                    "title": "Burndown",
                    "ySlugs": "burndownPDays burndownIssues",
                    "subtitle": "A negative burndown means we are creating more work than we are finishing",
                    "hasMapTab": "false",
                    "tableSlug": "Issues",
                    "Group Radio": "Burndown",
                    "hasChartTab": "true"
                }
            ]
        },
        {
            "args": [
                "https://docs.google.com/spreadsheets/d/1_zEQTYk_VVhxNC72N-UtCSWQ3KBslqavaMv8tdYc5eg/export?format=csv",
                "Predictions"
            ],
            "type": "table",
            "block": null
        },
        {
            "args": [
                "Predictions"
            ],
            "type": "columns",
            "block": [
                {
                    "name": "person",
                    "slug": "person",
                    "type": "EntityName"
                },
                {
                    "name": "Date",
                    "slug": "date",
                    "type": "Date"
                },
                {
                    "name": "hoursUntilShip",
                    "slug": "estimatedHoursUntilShip",
                    "type": "Numeric"
                }
            ]
        },
        {
            "args": [
                "https://docs.google.com/spreadsheets/d/1_zEQTYk_VVhxNC72N-UtCSWQ3KBslqavaMv8tdYc5eg/export?format=csv&gid=229137192",
                "Issues"
            ],
            "type": "table",
            "block": null
        },
        {
            "args": [
                "Issues"
            ],
            "type": "columns",
            "block": [
                {
                    "name": "person",
                    "slug": "entity",
                    "type": "EntityName"
                },
                {
                    "name": "Date",
                    "slug": "date",
                    "type": "Date"
                },
                {
                    "name": "Issues created",
                    "slug": "issuesCreated",
                    "type": "Numeric"
                },
                {
                    "name": "Issues closed",
                    "slug": "issuesClosed",
                    "type": "Numeric"
                },
                {
                    "name": "Issues still open",
                    "slug": "issuesStillOpen",
                    "type": "Numeric"
                },
                {
                    "name": "p-days remaining",
                    "slug": "pDaysRemaining",
                    "type": "Numeric"
                },
                {
                    "name": "Total issues created",
                    "slug": "issuesCreatedCumulative",
                    "type": "Numeric"
                },
                {
                    "name": "p-days created",
                    "slug": "pDaysCreated",
                    "type": "Numeric"
                },
                {
                    "name": "p-days closed",
                    "slug": "pDaysClosed",
                    "type": "Numeric"
                },
                {
                    "name": "burndown p-days",
                    "slug": "burndownPDays",
                    "type": "Numeric"
                },
                {
                    "name": "burndown issues",
                    "slug": "burndownIssues",
                    "type": "Numeric"
                }
            ]
        },
        {
            "args": [
                "https://docs.google.com/spreadsheets/d/1_zEQTYk_VVhxNC72N-UtCSWQ3KBslqavaMv8tdYc5eg/export?format=csv",
                "Countries"
            ],
            "type": "table",
            "block": null
        },
        {
            "args": [
                "Countries"
            ],
            "type": "columns",
            "block": [
                {
                    "name": "person",
                    "slug": "person",
                    "type": "String"
                },
                {
                    "name": "Date",
                    "slug": "date",
                    "type": "Date"
                },
                {
                    "name": "estimatedHoursUntilShip",
                    "slug": "estimatedHoursUntilShip",
                    "type": "Numeric"
                },
                {
                    "name": "country",
                    "slug": "country",
                    "type": "EntityName"
                }
            ]
        }
    ],
    "_version": 1,
    "yAxisMin": "0",
    "selection": [
        "Breck~Daniel~Marcel~Ernst~Esteban~Shahid"
    ],
    "explorerTitle": "When Will We Ship Next?",
    "explorerSubtitle": "A dashboard for measuring progress. [Edit sheet](https://docs.google.com/spreadsheets/d/1_zEQTYk_VVhxNC72N-UtCSWQ3KBslqavaMv8tdYc5eg).",
    "# end table. todo: fix empty rows bug": [],
    "# todo: add a select all entities selection option? selection=*": [],
    "# todo: would be nice if we could do real time groups by country": []
}