{
  "_id": "6a101b80acfb0bcc41c87325",
  "Package": "aftables",
  "Title": "Create Spreadsheet Publications Following Best Practice",
  "Version": "2.0.1",
  "Authors@R": "c(\nperson(\"Matt\", \"Dray\", , \"mwdray@gmail.com\", role = c(\"aut\")),\nperson(\"Tim\", \"Taylor\", role = \"ctb\"),\nperson(\"Matt\", \"Kerlogue\", role = \"ctb\"),\nperson(\"Crown Copyright\", role = c(\"cph\")),\nperson(\"Olivia\", \"Box Power\", , \"Olivia.BoxPower@dhsc.gov.uk\", role = c(\"cre\", \"ctb\")),\nperson(\"Zachary\", \"Gleisner\", , \"Zachary.Gleisner@dhsc.gov.uk\", role = \"ctb\")\n)",
  "Description": "Generate spreadsheet publications that follow best\npractice guidance from the UK government's Analysis Function,\navailable at\n<https://analysisfunction.civilservice.gov.uk/policy-store/releasing-statistics-in-spreadsheets/>,\nwith a focus on accessibility. See also the 'Python' package\n'gptables'.",
  "License": "MIT + file LICENSE",
  "URL": "https://best-practice-and-impact.github.io/aftables/,\nhttps://github.com/best-practice-and-impact/aftables",
  "BugReports": "https://github.com/best-practice-and-impact/aftables/issues",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "Config/pak/sysreqs": "libicu-dev",
  "Repository": "https://best-practice-and-impact.r-universe.dev",
  "Date/Publication": "2026-04-22 11:58:36 UTC",
  "RemoteUrl": "https://github.com/best-practice-and-impact/aftables",
  "RemoteRef": "HEAD",
  "RemoteSha": "189dce078f6bfd41293ef8773cb06c22a81ab867",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-22 08:58:28 UTC",
    "User": "root"
  },
  "Author": "Matt Dray [aut],\nTim Taylor [ctb],\nMatt Kerlogue [ctb],\nCrown Copyright [cph],\nOlivia Box Power [cre, ctb],\nZachary Gleisner [ctb]",
  "Maintainer": "Olivia Box Power <Olivia.BoxPower@dhsc.gov.uk>",
  "MD5sum": "6132116e445f602767d7742a4ccaf1e8",
  "_user": "best-practice-and-impact",
  "_type": "src",
  "_file": "aftables_2.0.1.tar.gz",
  "_fileid": "c8c7ce2d0358e310024715686829da6df10a2f7a25fca1283c07a74fb697a993",
  "_filesize": 1408914,
  "_sha256": "c8c7ce2d0358e310024715686829da6df10a2f7a25fca1283c07a74fb697a993",
  "_created": "2026-05-22T08:58:28.000Z",
  "_published": "2026-05-22T09:01:52.062Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77348542275,
      "time": 156,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7156753575"
    },
    {
      "job": 77348542273,
      "time": 148,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7156751133"
    },
    {
      "job": 77348542197,
      "time": 164,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7156745139"
    },
    {
      "job": 77348542193,
      "time": 143,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7156742436"
    },
    {
      "job": 77348104744,
      "time": 172,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7156704017"
    },
    {
      "job": 77348542231,
      "time": 103,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7156737055"
    },
    {
      "job": 77348542278,
      "time": 99,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7156736239"
    },
    {
      "job": 77348542305,
      "time": 109,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7156739114"
    },
    {
      "job": 77348542237,
      "time": 96,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7156735176"
    }
  ],
  "_buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/best-practice-and-impact/aftables",
  "_commit": {
    "id": "189dce078f6bfd41293ef8773cb06c22a81ab867",
    "author": "Olivia Box Power <Olivia.BoxPower@dhsc.gov.uk>",
    "committer": "Olivia Box Power <Olivia.BoxPower@dhsc.gov.uk>",
    "message": "Update CRAN comments\n",
    "time": 1776859116
  },
  "_maintainer": {
    "name": "Olivia Box Power",
    "email": "olivia.boxpower@dhsc.gov.uk",
    "login": "olivia-box-power",
    "description": "",
    "uuid": 85562659
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "openxlsx2",
      "role": "Imports"
    },
    {
      "package": "pillar",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "yaml",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "rstudioapi",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "best-practice-and-impact",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-33",
      "n": 1
    },
    {
      "week": "2026-07",
      "n": 1
    },
    {
      "week": "2026-09",
      "n": 2
    },
    {
      "week": "2026-11",
      "n": 1
    },
    {
      "week": "2026-12",
      "n": 4
    },
    {
      "week": "2026-13",
      "n": 1
    },
    {
      "week": "2026-17",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v2.0.0",
      "date": "2026-03-20"
    },
    {
      "name": "v2.0.1",
      "date": "2026-04-22"
    }
  ],
  "_topics": [
    "accessibility",
    "openxlsx",
    "reproducible-analytical-pipeline",
    "spreadsheet",
    "uk-gov-data-science"
  ],
  "_stars": 54,
  "_contributors": [
    {
      "user": "olivia-box-power",
      "count": 107,
      "uuid": 85562659
    },
    {
      "user": "zac-gleisner",
      "count": 80,
      "uuid": 191228565
    },
    {
      "user": "matt-dray",
      "count": 62,
      "uuid": 18232097
    },
    {
      "user": "mattkerlogue",
      "count": 2,
      "uuid": 35345053
    }
  ],
  "_userbio": {
    "uuid": 53307888,
    "type": "organization",
    "name": "Analysis Function ",
    "description": "The UK Government Analysis Function is a network for all civil servants working in UK government analysis."
  },
  "_downloads": {
    "count": 640,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/aftables"
  },
  "_devurl": "https://github.com/best-practice-and-impact/aftables",
  "_pkgdown": "https://best-practice-and-impact.github.io/aftables/",
  "_searchresults": 6,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/aftables.html",
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/best-practice-and-impact/aftables",
  "_realowner": "best-practice-and-impact",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.1",
      "date": "2025-02-19"
    },
    {
      "version": "1.0.2",
      "date": "2025-02-19"
    },
    {
      "version": "2.0.0",
      "date": "2026-03-20"
    },
    {
      "version": "2.0.1",
      "date": "2026-04-22"
    }
  ],
  "_exports": [
    "as_aftable",
    "at_template_aftable",
    "at_template_workflow",
    "create_aftable",
    "create_config_yaml",
    "generate_workbook",
    "is_aftable"
  ],
  "_datasets": [
    {
      "name": "demo_aftable",
      "title": "A Demo 'aftables' Object",
      "object": "demo_aftable",
      "class": [
        "aftable",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "tab_title",
        "sheet_type",
        "sheet_title",
        "blank_cells",
        "source",
        "custom_rows",
        "table"
      ],
      "rows": 5,
      "table": false,
      "tojson": true
    },
    {
      "name": "demo_df",
      "title": "A Demo 'data.frame' Object",
      "object": "demo_df",
      "class": [
        "data.frame"
      ],
      "fields": [
        "tab_title",
        "sheet_type",
        "sheet_title",
        "blank_cells",
        "source",
        "custom_rows",
        "table"
      ],
      "rows": 5,
      "table": false,
      "tojson": true
    },
    {
      "name": "demo_workbook",
      "title": "A Demo 'Workbook' Object",
      "object": "demo_workbook",
      "class": [
        "wbWorkbook",
        "R6"
      ],
      "fields": [],
      "table": false,
      "tojson": false
    }
  ],
  "_help": [
    {
      "page": "as_aftable",
      "title": "Coerce To An 'aftable' Object",
      "topics": [
        "as_aftable",
        "is_aftable"
      ]
    },
    {
      "page": "at_template_aftable",
      "title": "Insert 'create_aftable' template",
      "topics": [
        "at_template_aftable"
      ]
    },
    {
      "page": "at_template_workflow",
      "title": "Insert full 'aftables' template workflow",
      "topics": [
        "at_template_workflow"
      ]
    },
    {
      "page": "create_aftable",
      "title": "Create An 'aftable' Object",
      "topics": [
        "create_aftable"
      ]
    },
    {
      "page": "create_config_yaml",
      "title": "Create an aftables config.yaml",
      "topics": [
        "create_config_yaml"
      ]
    },
    {
      "page": "demo_aftable",
      "title": "A Demo 'aftables' Object",
      "topics": [
        "demo_aftable"
      ]
    },
    {
      "page": "demo_df",
      "title": "A Demo 'data.frame' Object",
      "topics": [
        "demo_df"
      ]
    },
    {
      "page": "demo_workbook",
      "title": "A Demo 'Workbook' Object",
      "topics": [
        "demo_workbook"
      ]
    },
    {
      "page": "generate_workbook",
      "title": "Generate A Workbook Object From An 'aftable'",
      "topics": [
        "generate_workbook"
      ]
    },
    {
      "page": "summary.aftable",
      "title": "Summarise An 'aftable' Object",
      "topics": [
        "summary.aftable"
      ]
    },
    {
      "page": "tbl_sum.aftable",
      "title": "Provide A Succinct Summary Of An 'aftable' Object",
      "topics": [
        "tbl_sum.aftable"
      ]
    }
  ],
  "_pkglogo": "https://github.com/best-practice-and-impact/aftables/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/best-practice-and-impact/aftables/raw/HEAD/README.md",
  "_rundeps": [
    "cli",
    "cpp11",
    "dplyr",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "openxlsx2",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr",
    "yaml"
  ],
  "_vignettes": [
    {
      "source": "checklist.Rmd",
      "filename": "checklist.html",
      "title": "Accessibility guidance checklist",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Purpose",
        "Checklists",
        "Tables",
        "Footnotes",
        "Formatting",
        "Structure",
        "Before publishing",
        "Contribute"
      ],
      "created": "2022-07-19 19:31:20",
      "modified": "2026-03-20 10:50:16",
      "commits": 7
    },
    {
      "source": "aftables.Rmd",
      "filename": "aftables.html",
      "title": "Introduction to {aftables}",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Purpose",
        "Installation",
        "Workflow",
        "1. Create an aftable",
        "Pre-prepare tables",
        "Meta-sheets",
        "Statistical tables",
        "Create aftable",
        "2. Convert to a workbook",
        "3. Write to file",
        "Output",
        "Final tweaks",
        "Contribute"
      ],
      "created": "2025-02-18 11:52:28",
      "modified": "2026-03-20 10:50:16",
      "commits": 5
    },
    {
      "source": "configfiles.Rmd",
      "filename": "configfiles.html",
      "title": "Config files",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Purpose",
        "Workbook properties and formatting which can be set in a config file",
        "Structure of a config file",
        "Applying a config file with generate_workbook()",
        "Example 1: No config arguments in generate_workbook",
        "Example 2: Using a custom config",
        "Example 3: Using a custom config file",
        "Example 4: Using a custom config file with a custom config"
      ],
      "created": "2026-03-20 10:50:16",
      "modified": "2026-03-20 10:50:16",
      "commits": 1
    },
    {
      "source": "structure.Rmd",
      "filename": "structure.html",
      "title": "Package structure",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Purpose",
        "Overview",
        "Files",
        "Code",
        "To create aftables",
        "Methods",
        "To create workbooks",
        "Add sheets",
        "Insert sheet elements",
        "Apply styles",
        "Contribute"
      ],
      "created": "2022-07-19 19:31:20",
      "modified": "2025-08-13 15:21:42",
      "commits": 6
    },
    {
      "source": "terminology.Rmd",
      "filename": "terminology.html",
      "title": "Spreadsheet terminology",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Purpose",
        "Terminology",
        "Example",
        "Contribute"
      ],
      "created": "2022-07-19 19:31:20",
      "modified": "2025-02-18 14:26:28",
      "commits": 4
    }
  ],
  "_score": 7.452553063228926,
  "_indexed": true,
  "_nocasepkg": "aftables",
  "_universes": [
    "best-practice-and-impact",
    "olivia-box-power"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2.0.1",
      "date": "2026-05-22T09:00:46.000Z",
      "distro": "noble",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "813e6d5b60f7ac000224a11193bbeffe8485662ee0c7598dab48aeef96348396",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "2.0.1",
      "date": "2026-05-22T09:00:41.000Z",
      "distro": "noble",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "217005fe43465d646e1862d79474b3a77b9847e127b8d4990dd26609022191c2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "2.0.1",
      "date": "2026-05-22T09:00:36.000Z",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "05b3d38153ccf47c3643e3245aacb13589e295e91ab75f57ea6fe6024767fd4f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "2.0.1",
      "date": "2026-05-22T09:00:23.000Z",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "6741ce77a1170f2ebea26c03986bd709f9e4e382afb47b9a5206451226cc41e8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "2.0.1",
      "date": "2026-05-22T09:00:29.000Z",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "ad22f669ff56066b507456c75d7288d08bc93099f8c1b6fd7166bebb45834187",
      "status": "success",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2.0.1",
      "date": "2026-05-22T08:59:46.000Z",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "47c0532451c8967b8b5e849800ad1d845b3faa59e0615e19a89c15ddc150f286",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "2.0.1",
      "date": "2026-05-22T08:59:56.000Z",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "eea05f4004eb21339730b97c48a8a0731fcd7ea6f11470c062ab483964f251b2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "2.0.1",
      "date": "2026-05-22T08:59:42.000Z",
      "commit": "189dce078f6bfd41293ef8773cb06c22a81ab867",
      "fileid": "5c09cdaad3d0db7597a1a340aba163fe2953bd92deca19470e4c11ccb404699f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/best-practice-and-impact/actions/runs/26278349027"
    }
  ]
}