{
  "_id": "6a104332acfb0bcc41c9de3b",
  "Package": "pivottabler",
  "Type": "Package",
  "Title": "Create Pivot Tables",
  "Version": "1.5.6",
  "Authors@R": "person(\"Christopher\", \"Bailiss\", email = \"cbailiss@gmail.com\",\nrole = c(\"aut\", \"cre\"))",
  "Description": "Create regular pivot tables with just a few lines of R.\nMore complex pivot tables can also be created, e.g. pivot\ntables with irregular layouts, multiple calculations and/or\nderived calculations based on multiple data frames.  Pivot\ntables are constructed using R only and can be written to a\nrange of output formats (plain text, 'HTML', 'Latex' and\n'Excel'), including with styling/formatting.",
  "License": "GPL-3",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "URL": "http://www.pivottabler.org.uk/,\nhttps://github.com/cbailiss/pivottabler",
  "BugReports": "https://github.com/cbailiss/pivottabler/issues",
  "VignetteBuilder": "knitr",
  "RoxygenNote": "7.3.2",
  "Config/pak/sysreqs": "cmake make libuv1-dev",
  "Repository": "https://cbailiss.r-universe.dev",
  "Date/Publication": "2025-08-14 08:27:09 UTC",
  "RemoteUrl": "https://github.com/cbailiss/pivottabler",
  "RemoteRef": "HEAD",
  "RemoteSha": "518d092564869bf0968a539fd0ea403ce95da018",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-11 07:00:59 UTC",
    "User": "root"
  },
  "Author": "Christopher Bailiss [aut, cre]",
  "Maintainer": "Christopher Bailiss <cbailiss@gmail.com>",
  "MD5sum": "4993213b6f55c5f47ddaf66e25aedb1b",
  "_user": "cbailiss",
  "_type": "src",
  "_file": "pivottabler_1.5.6.tar.gz",
  "_fileid": "c8dc8f2d8a8ffe3e1321bd69d46a8da0e829447d4065dc7dab4b9e9109cbd5a3",
  "_filesize": 3073921,
  "_sha256": "c8dc8f2d8a8ffe3e1321bd69d46a8da0e829447d4065dc7dab4b9e9109cbd5a3",
  "_created": "2026-05-11T07:00:59.000Z",
  "_published": "2026-05-22T11:51:14.415Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77373794564,
      "time": 176,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6912194256"
    },
    {
      "job": 77373794175,
      "time": 172,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6912194851"
    },
    {
      "job": 77373794577,
      "time": 249,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6912200404"
    },
    {
      "job": 77373794455,
      "time": 211,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6912196174"
    },
    {
      "job": 77373793997,
      "time": 225,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6912147112"
    },
    {
      "job": 77373793865,
      "time": 112,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7159796950"
    },
    {
      "job": 77373794337,
      "time": 128,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6912181856"
    },
    {
      "job": 77373794600,
      "time": 164,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6912191093"
    },
    {
      "job": 77373794484,
      "time": 135,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6912183610"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cbailiss/pivottabler",
  "_commit": {
    "id": "518d092564869bf0968a539fd0ea403ce95da018",
    "author": "Chris Bailiss <cbailiss@gmail.com>",
    "committer": "Chris Bailiss <cbailiss@gmail.com>",
    "message": "Automatic selection of openxlsx vs openxxlsx2 functions based on type of workbook passed in arguments.\n\nAlso first attempt at resolving default column width discrepancy between openxlsx and openxlsx2 (ideally needs simpler approach).\n",
    "time": 1755160029
  },
  "_maintainer": {
    "name": "Christopher Bailiss",
    "email": "cbailiss@gmail.com",
    "login": "cbailiss",
    "uuid": 11745789
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.3.0",
      "role": "Depends"
    },
    {
      "package": "R6",
      "version": ">= 2.2.0",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "version": ">= 0.5.0",
      "role": "Imports"
    },
    {
      "package": "data.table",
      "version": ">= 1.10.0",
      "role": "Imports"
    },
    {
      "package": "htmltools",
      "version": ">= 0.3.5",
      "role": "Imports"
    },
    {
      "package": "htmlwidgets",
      "version": ">= 0.8",
      "role": "Imports"
    },
    {
      "package": "ggplot2",
      "version": ">= 2.2.0",
      "role": "Suggests"
    },
    {
      "package": "jsonlite",
      "version": ">= 1.1",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "version": ">= 1.5.0",
      "role": "Suggests"
    },
    {
      "package": "listviewer",
      "version": ">= 1.4.0",
      "role": "Suggests"
    },
    {
      "package": "openxlsx",
      "version": ">= 4.0.17",
      "role": "Suggests"
    },
    {
      "package": "openxlsx2",
      "role": "Suggests"
    },
    {
      "package": "basictabler",
      "version": ">= 1.0.2",
      "role": "Suggests"
    },
    {
      "package": "shiny",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    }
  ],
  "_owner": "cbailiss",
  "_selfowned": true,
  "_usedby": 1,
  "_updates": [
    {
      "week": "2025-32",
      "n": 1
    },
    {
      "week": "2025-33",
      "n": 2
    }
  ],
  "_tags": [],
  "_topics": [
    "calculations",
    "html",
    "htmlwidget",
    "latex",
    "pivot-tables",
    "visualization"
  ],
  "_stars": 124,
  "_contributors": [
    {
      "user": "cbailiss",
      "count": 480,
      "uuid": 11745789
    },
    {
      "user": "janmarvin",
      "count": 6,
      "uuid": 1645626
    }
  ],
  "_userbio": {
    "uuid": 11745789,
    "type": "user",
    "name": "Chris Bailiss",
    "description": "BI Solution Architect"
  },
  "_downloads": {
    "count": 1197,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/pivottabler"
  },
  "_devurl": "https://github.com/cbailiss/pivottabler",
  "_searchresults": 388,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/pivottabler.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/cbailiss/pivottabler",
  "_realowner": "cbailiss",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2017-03-27"
    },
    {
      "version": "0.2.0",
      "date": "2017-04-28"
    },
    {
      "version": "0.3.0",
      "date": "2017-06-01"
    },
    {
      "version": "0.4.0",
      "date": "2017-10-02"
    },
    {
      "version": "1.0.0",
      "date": "2018-10-17"
    },
    {
      "version": "1.1.0",
      "date": "2019-02-17"
    },
    {
      "version": "1.2.0",
      "date": "2019-03-21"
    },
    {
      "version": "1.2.1",
      "date": "2019-08-05"
    },
    {
      "version": "1.2.2",
      "date": "2019-09-20"
    },
    {
      "version": "1.2.3",
      "date": "2019-11-01"
    },
    {
      "version": "1.3.0",
      "date": "2020-02-03"
    },
    {
      "version": "1.3.1",
      "date": "2020-04-01"
    },
    {
      "version": "1.4.0",
      "date": "2020-05-11"
    },
    {
      "version": "1.5.0",
      "date": "2020-06-16"
    },
    {
      "version": "1.5.1",
      "date": "2021-03-11"
    },
    {
      "version": "1.5.2",
      "date": "2021-05-12"
    },
    {
      "version": "1.5.3",
      "date": "2021-06-27"
    },
    {
      "version": "1.5.4",
      "date": "2022-10-04"
    },
    {
      "version": "1.5.5",
      "date": "2023-10-01"
    },
    {
      "version": "1.5.6",
      "date": "2025-04-22"
    }
  ],
  "_exports": [
    "getCompactTheme",
    "getDefaultTheme",
    "getLargePlainTheme",
    "getSimpleColoredTheme",
    "getStandardTableTheme",
    "getTheme",
    "PivotFilter",
    "PivotFilterOverrides",
    "PivotFilters",
    "PivotOpenXlsxStyle",
    "PivotOpenXlsxStyles",
    "PivotStyle",
    "PivotStyles",
    "PivotTable",
    "pivottabler",
    "pivottablerOutput",
    "qhpvt",
    "qlpvt",
    "qpvt",
    "renderBasicTable",
    "renderPivottabler"
  ],
  "_datasets": [
    {
      "name": "bhmtraindisruption",
      "title": "Birmingham Train Disruptions, Dec 2016-Feb 2017.",
      "object": "bhmtraindisruption",
      "class": [
        "data.frame"
      ],
      "fields": [
        "ServiceId",
        "LastCancellationAt",
        "LastCancellationLocation",
        "LastCancellationReasonCategory",
        "LastCancellationReasonDesc",
        "LastReinstatedAt",
        "LastChangeOfOriginAt",
        "LastChangeOfOriginLocation",
        "LastChangeOfOriginReasonCategory",
        "LastChangeOfOriginReasonDesc"
      ],
      "rows": 2982,
      "table": true,
      "tojson": true
    },
    {
      "name": "bhmtrains",
      "title": "Birmingham Trains, Dec 2016-Feb 2017.",
      "object": "bhmtrains",
      "class": [
        "data.frame"
      ],
      "fields": [
        "ServiceId",
        "Status",
        "TOC",
        "TrainCategory",
        "PowerType",
        "SchedSpeedMPH",
        "Origin",
        "OriginGbttDeparture",
        "OriginActualDeparture",
        "GbttArrival",
        "ActualArrival",
        "GbttDeparture",
        "ActualDeparture",
        "Destination",
        "DestinationGbttArrival",
        "DestinationActualArrival"
      ],
      "rows": 83710,
      "table": true,
      "tojson": true
    },
    {
      "name": "pvtperfresults",
      "title": "Performance Comparison Results",
      "object": "pvtperfresults",
      "class": [
        "data.frame"
      ],
      "fields": [
        "id",
        "evaluationMode",
        "rowCount",
        "cellCount",
        "argumentCheckMode",
        "processingLibrary",
        "description",
        "completed",
        "userTime",
        "systemTime",
        "elapsedTime"
      ],
      "rows": 216,
      "table": true,
      "tojson": true
    },
    {
      "name": "pvtperfsummary",
      "title": "Performance Comparison Summary",
      "object": "pvtperfsummary",
      "class": [
        "data.frame"
      ],
      "fields": [
        "id",
        "evaluationMode",
        "rowCount",
        "cellCount",
        "argumentCheckMode",
        "processingLibrary",
        "description",
        "userTimeAvg",
        "systemTimeAvg",
        "elapsedTimeAvg",
        "userTimeMin",
        "userTimeMax",
        "systemTimeMin",
        "systemTimeMax",
        "elapsedTimeMin",
        "elapsedTimeMax",
        "testName",
        "testIndex"
      ],
      "rows": 36,
      "table": true,
      "tojson": true
    },
    {
      "name": "trainstations",
      "title": "Train Stations",
      "object": "trainstations",
      "class": [
        "data.frame"
      ],
      "fields": [
        "CrsCode",
        "StationName",
        "OsEasting",
        "OsNorthing",
        "GridReference",
        "Latitude",
        "Longitude"
      ],
      "rows": 2568,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "bhmtraindisruption",
      "title": "Birmingham Train Disruptions, Dec 2016-Feb 2017.",
      "topics": [
        "bhmtraindisruption"
      ]
    },
    {
      "page": "bhmtrains",
      "title": "Birmingham Trains, Dec 2016-Feb 2017.",
      "topics": [
        "bhmtrains"
      ]
    },
    {
      "page": "checkArgument",
      "title": "Perform basic checks on a function argument.",
      "topics": [
        "checkArgument"
      ]
    },
    {
      "page": "cleanCssValue",
      "title": "Cleans up a CSS attribute value.",
      "topics": [
        "cleanCssValue"
      ]
    },
    {
      "page": "cleanOutlineArg",
      "title": "Clean the arguments specified for an outline group",
      "topics": [
        "cleanOutlineArg"
      ]
    },
    {
      "page": "containsText",
      "title": "Check whether a text value is present in another text value.",
      "topics": [
        "containsText"
      ]
    },
    {
      "page": "convertPvtStyleToBasicStyle",
      "title": "Convert a pivot table style to a basictabler style.",
      "topics": [
        "convertPvtStyleToBasicStyle"
      ]
    },
    {
      "page": "convertPvtTblToBasicTbl",
      "title": "Convert a pivot table to a basic table.",
      "topics": [
        "convertPvtTblToBasicTbl"
      ]
    },
    {
      "page": "expandHex",
      "title": "Expand hex.",
      "topics": [
        "expandHex"
      ]
    },
    {
      "page": "exportValueAs",
      "title": "Replace the current value with a placeholder during export.",
      "topics": [
        "exportValueAs"
      ]
    },
    {
      "page": "getBlankTheme",
      "title": "Get an empty theme for applying no styling to a table.",
      "topics": [
        "getBlankTheme"
      ]
    },
    {
      "page": "getCompactTheme",
      "title": "Get the compact theme for styling a pivot table.",
      "topics": [
        "getCompactTheme"
      ]
    },
    {
      "page": "getDefaultTheme",
      "title": "Get the default theme for styling a pivot table.",
      "topics": [
        "getDefaultTheme"
      ]
    },
    {
      "page": "getLargePlainTheme",
      "title": "Get the large plain theme for styling a pivot table.",
      "topics": [
        "getLargePlainTheme"
      ]
    },
    {
      "page": "getNextPosition",
      "title": "Find the first value in an array that is larger than the specified value.",
      "topics": [
        "getNextPosition"
      ]
    },
    {
      "page": "getPvtStyleDeclarations",
      "title": "Get pivot table style declarations from a pivot table style.",
      "topics": [
        "getPvtStyleDeclarations"
      ]
    },
    {
      "page": "getSimpleColoredTheme",
      "title": "Get a simple coloured theme.",
      "topics": [
        "getSimpleColoredTheme"
      ]
    },
    {
      "page": "getStandardTableTheme",
      "title": "Get the a theme for styling to a pivot table that looks more like a standard table (i.e. no row column headings).",
      "topics": [
        "getStandardTableTheme"
      ]
    },
    {
      "page": "getTheme",
      "title": "Get a built-in theme for styling a pivot table.",
      "topics": [
        "getTheme"
      ]
    },
    {
      "page": "getXlBorderFromCssBorder",
      "title": "Convert CSS border values to those used by the openxlsx package.",
      "topics": [
        "getXlBorderFromCssBorder"
      ]
    },
    {
      "page": "getXlBorderStyleFromCssBorder",
      "title": "Convert CSS border values to those used by the openxlsx package.",
      "topics": [
        "getXlBorderStyleFromCssBorder"
      ]
    },
    {
      "page": "isNumericValue",
      "title": "Check whether a numeric value is present.",
      "topics": [
        "isNumericValue"
      ]
    },
    {
      "page": "isTextValue",
      "title": "Check whether a text value is present.",
      "topics": [
        "isTextValue"
      ]
    },
    {
      "page": "oneToNULL",
      "title": "Convert a value of 1 to a NULL value.",
      "topics": [
        "oneToNULL"
      ]
    },
    {
      "page": "parseColor",
      "title": "Convert a CSS colour into a hex based colour code.",
      "topics": [
        "parseColor"
      ]
    },
    {
      "page": "parseCssBorder",
      "title": "Parse a CSS border value.",
      "topics": [
        "parseCssBorder"
      ]
    },
    {
      "page": "parseCssSizeToPt",
      "title": "Convert a CSS size value into points.",
      "topics": [
        "parseCssSizeToPt"
      ]
    },
    {
      "page": "parseCssSizeToPx",
      "title": "Convert a CSS size value into pixels",
      "topics": [
        "parseCssSizeToPx"
      ]
    },
    {
      "page": "parseCssString",
      "title": "Split a CSS attribute value into a vector/array.",
      "topics": [
        "parseCssString"
      ]
    },
    {
      "page": "parseXlBorder",
      "title": "Parse an xl-border value.",
      "topics": [
        "parseXlBorder"
      ]
    },
    {
      "page": "PivotBatch",
      "title": "R6 class the represents a Calculation Batch",
      "topics": [
        "PivotBatch"
      ]
    },
    {
      "page": "PivotBatchCalculator",
      "title": "R6 class that calculates the values for multiple cells in batches.",
      "topics": [
        "PivotBatchCalculator"
      ]
    },
    {
      "page": "PivotBatchStatistics",
      "title": "R6 class that provides summary statistics for batch calculations.",
      "topics": [
        "PivotBatchStatistics"
      ]
    },
    {
      "page": "PivotCalculation",
      "title": "R6 class that defines a calculation.",
      "topics": [
        "PivotCalculation"
      ]
    },
    {
      "page": "PivotCalculationGroup",
      "title": "R6 class that defines a group of calculations.",
      "topics": [
        "PivotCalculationGroup"
      ]
    },
    {
      "page": "PivotCalculationGroups",
      "title": "R6 class that contains multiple calculation groups.",
      "topics": [
        "PivotCalculationGroups"
      ]
    },
    {
      "page": "PivotCalculator",
      "title": "R6 class that computes the value of a cell or cells.",
      "topics": [
        "PivotCalculator"
      ]
    },
    {
      "page": "PivotCell",
      "title": "R6 class that represents a cell in a pivot table.",
      "topics": [
        "PivotCell"
      ]
    },
    {
      "page": "PivotCells",
      "title": "R6 class that contains the cells in a pivot table.",
      "topics": [
        "PivotCells"
      ]
    },
    {
      "page": "PivotData",
      "title": "R6 class that contains named data frames and associated totals.",
      "topics": [
        "PivotData"
      ]
    },
    {
      "page": "PivotDataGroup",
      "title": "R6 class that defines a row or column data group.",
      "topics": [
        "PivotDataGroup"
      ]
    },
    {
      "page": "PivotFilter",
      "title": "R6 class that defines a filter condition.",
      "topics": [
        "PivotFilter"
      ]
    },
    {
      "page": "PivotFilterOverrides",
      "title": "R6 class that defines a set of filter overrides.",
      "topics": [
        "PivotFilterOverrides"
      ]
    },
    {
      "page": "PivotFilters",
      "title": "R6 class that defines a set of filter conditions.",
      "topics": [
        "PivotFilters"
      ]
    },
    {
      "page": "PivotHtmlRenderer",
      "title": "R6 class that renders a pivot table in HTML.",
      "topics": [
        "PivotHtmlRenderer"
      ]
    },
    {
      "page": "PivotLatexRenderer",
      "title": "R6 class that renders a pivot table in Latex.",
      "topics": [
        "PivotLatexRenderer"
      ]
    },
    {
      "page": "PivotOpenXlsxRenderer",
      "title": "R6 class that renders a pivot table into an Excel worksheet.",
      "topics": [
        "PivotOpenXlsxRenderer"
      ]
    },
    {
      "page": "PivotOpenXlsxStyle",
      "title": "R6 class that specifies Excel styling as used by the openxlsx package.",
      "topics": [
        "PivotOpenXlsxStyle"
      ]
    },
    {
      "page": "PivotOpenXlsxStyles",
      "title": "R6 class that defines a collection of Excel styles as used by the openxlsx package.",
      "topics": [
        "PivotOpenXlsxStyles"
      ]
    },
    {
      "page": "PivotStyle",
      "title": "R6 class that specifies styling.",
      "topics": [
        "PivotStyle"
      ]
    },
    {
      "page": "PivotStyles",
      "title": "R6 class that defines a collection of styles.",
      "topics": [
        "PivotStyles"
      ]
    },
    {
      "page": "PivotTable",
      "title": "R6 class that represents a pivot table.",
      "topics": [
        "PivotTable"
      ]
    },
    {
      "page": "pivottabler",
      "title": "Render a pivot table as a HTML widget.",
      "topics": [
        "pivottabler"
      ]
    },
    {
      "page": "pivottablerOutput",
      "title": "Standard function for Shiny scaffolding.",
      "topics": [
        "pivottablerOutput"
      ]
    },
    {
      "page": "processIdentifier",
      "title": "Handle an identifier that may be illegal (e.g. containing spaces).",
      "topics": [
        "processIdentifier"
      ]
    },
    {
      "page": "processIdentifiers",
      "title": "Handle identifiers that may be illegal (e.g. containing spaces).",
      "topics": [
        "processIdentifiers"
      ]
    },
    {
      "page": "pvtperfresults",
      "title": "Performance Comparison Results",
      "topics": [
        "pvtperfresults"
      ]
    },
    {
      "page": "pvtperfsummary",
      "title": "Performance Comparison Summary",
      "topics": [
        "pvtperfsummary"
      ]
    },
    {
      "page": "qhpvt",
      "title": "Quickly render a basic pivot table in HTML.",
      "topics": [
        "qhpvt"
      ]
    },
    {
      "page": "qlpvt",
      "title": "Quickly get a Latex representation of a basic pivot table.",
      "topics": [
        "qlpvt"
      ]
    },
    {
      "page": "qpvt",
      "title": "Quickly build a basic pivot table.",
      "topics": [
        "qpvt"
      ]
    },
    {
      "page": "renderBasicTable",
      "title": "Output a table into a package vignette.",
      "topics": [
        "renderBasicTable"
      ]
    },
    {
      "page": "renderPivottabler",
      "title": "Standard function for Shiny scaffolding.",
      "topics": [
        "renderPivottabler"
      ]
    },
    {
      "page": "skipExportingValue",
      "title": "Should the current value be skipped during export?",
      "topics": [
        "skipExportingValue"
      ]
    },
    {
      "page": "trainstations",
      "title": "Train Stations",
      "topics": [
        "trainstations"
      ]
    },
    {
      "page": "typeSafeIntersect",
      "title": "Intersect two vectors without changing their data types.",
      "topics": [
        "typeSafeIntersect"
      ]
    },
    {
      "page": "typeSafeUnion",
      "title": "Union two vectors without changing their data types.",
      "topics": [
        "typeSafeUnion"
      ]
    },
    {
      "page": "typeSafeUnlist",
      "title": "Unlist a list into a vector in a type-safe way where possible.",
      "topics": [
        "typeSafeUnlist"
      ]
    },
    {
      "page": "vreConvertSimpleNumericRange",
      "title": "Convert a simple range expression to a standard R logical expression.",
      "topics": [
        "vreConvertSimpleNumericRange"
      ]
    },
    {
      "page": "vreGetSingleValue",
      "title": "Read the value from a single-valued value range expression.",
      "topics": [
        "vreGetSingleValue"
      ]
    },
    {
      "page": "vreHexToClr",
      "title": "Convert a colour in hex format (#RRGGBB) into a list.",
      "topics": [
        "vreHexToClr"
      ]
    },
    {
      "page": "vreIsEqual",
      "title": "Test if two numeric values are equal within tolerance.",
      "topics": [
        "vreIsEqual"
      ]
    },
    {
      "page": "vreIsMatch",
      "title": "Test whether a value matches a value range expression.",
      "topics": [
        "vreIsMatch"
      ]
    },
    {
      "page": "vreIsSimpleNumericRange",
      "title": "Determine if a value range expression is a simple range expression.",
      "topics": [
        "vreIsSimpleNumericRange"
      ]
    },
    {
      "page": "vreIsSingleValue",
      "title": "Determine if a value range expression is a single value.",
      "topics": [
        "vreIsSingleValue"
      ]
    },
    {
      "page": "vreScale2Colours",
      "title": "Scale a number from a range into a colour gradient.",
      "topics": [
        "vreScale2Colours"
      ]
    },
    {
      "page": "vreScaleNumber",
      "title": "Rescale a number from one range into another range.",
      "topics": [
        "vreScaleNumber"
      ]
    }
  ],
  "_readme": "https://github.com/cbailiss/pivottabler/raw/HEAD/README.md",
  "_rundeps": [
    "base64enc",
    "bslib",
    "cachem",
    "cli",
    "data.table",
    "digest",
    "dplyr",
    "evaluate",
    "fastmap",
    "fontawesome",
    "fs",
    "generics",
    "glue",
    "highr",
    "htmltools",
    "htmlwidgets",
    "jquerylib",
    "jsonlite",
    "knitr",
    "lifecycle",
    "magrittr",
    "memoise",
    "mime",
    "pillar",
    "pkgconfig",
    "R6",
    "rappdirs",
    "rlang",
    "rmarkdown",
    "sass",
    "tibble",
    "tidyselect",
    "tinytex",
    "utf8",
    "vctrs",
    "withr",
    "xfun",
    "yaml"
  ],
  "_vignettes": [
    {
      "source": "v00-vignettes.Rmd",
      "filename": "v00-vignettes.html",
      "title": "Create Pivot Tables in R",
      "author": "Chris Bailiss",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Contents",
        "Introducing pivottabler",
        "Basic Pivot Table",
        "Constructing the Basic Pivot Table",
        "Outputting the Pivot Table as Plain Text",
        "Extending the Basic Pivot Table",
        "Outline Layout",
        "Quick-Pivot Functions",
        "Examples Gallery",
        "Multiple Levels & Formatted Data Groups",
        "Multiple Calculations & Calculations on Rows",
        "Custom Calculations",
        "Results as a Matrix",
        "Latex Output",
        "Styling",
        "Finding and Formatting Data Groups",
        "Finding and Formatting Cells",
        "Conditional Formatting",
        "Mixing Data Groups and/or Calculations",
        "Combining Pivot Tables",
        "Further Reading"
      ],
      "created": "2020-02-03 08:43:38",
      "modified": "2020-05-09 09:18:19",
      "commits": 5
    }
  ],
  "_score": 8.237468815882517,
  "_indexed": true,
  "_nocasepkg": "pivottabler",
  "_universes": [
    "cbailiss"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.5.6",
      "date": "2026-05-11T07:03:37.000Z",
      "distro": "noble",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "73991ead1ebcc55238c7f7b480704c2739e900ce556dc3491d0f119013857272",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.5.6",
      "date": "2026-05-11T07:03:39.000Z",
      "distro": "noble",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "aab9b0abef4560d3825cb41420ef47f1b920ea7c8633002468a6af1cf18bd29d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.5.6",
      "date": "2026-05-11T07:04:06.000Z",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "68f5c8c40b0c11db454d1414cccb4e4a3a4909e130f2cd11e6ec3565a54a6c5f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.5.6",
      "date": "2026-05-11T07:03:54.000Z",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "dbe3993e365285a7b407f78fd0cc7d5cdb6fdc69961437ee0cb95a20905e1c02",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.5.6",
      "date": "2026-05-11T07:02:35.000Z",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "27c0dea7b790e49544ce47d3a451c9bba42ded677910de5c842dfeaf1f0be0c4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.5.6",
      "date": "2026-05-11T07:03:01.000Z",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "94a470dc612c2dd54a38eae7847127cb59dbf3dfeb969dbff0cf1066441df358",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.5.6",
      "date": "2026-05-11T07:02:38.000Z",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "e1fb9076c0caac231ef025dfe969a956c831618402de419736822f82b887f901",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.5.6",
      "date": "2026-05-22T11:50:57.000Z",
      "commit": "518d092564869bf0968a539fd0ea403ce95da018",
      "fileid": "f24defc78c80f019086a5f055f234a90096dd45c92f31cf86b311e480f850317",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cbailiss/actions/runs/25655163259"
    }
  ]
}