{ "_id": "6ad1ffa9c96d212026e70598", "Package": "exceldata", "Type": "Package", "Title": "Streamline Data Import, Cleaning and Recoding from 'Excel'", "Version": "0.1.1.3", "Authors@R": "person(\"Lisa\", \"Avery\", , \"lisa.avery@uhn.ca\", role = c(\"aut\", \"cre\",\"cph\"),\ncomment = c(ORCID = \"0000-0002-8431-5143\"))", "Description": "A small group of functions to read in a data dictionary\nand the corresponding data table from 'Excel' and to automate\nthe cleaning, re-coding and creation of simple calculated\nvariables. This package was designed to be a companion to the\nmacro-enabled 'Excel' template available on the GitHub site,\nbut works with any similarly-formatted 'Excel' data.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-16 10:40:06 UTC", "User": "root" }, "Author": "Lisa Avery [aut, cre, cph]\n()", "Maintainer": "Lisa Avery ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2023-11-21 02:41:14 UTC", "RemoteUrl": "https://github.com/cran/exceldata", "RemoteRef": "HEAD", "RemoteSha": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "_user": "cran", "_type": "src", "_file": "exceldata_0.1.1.3.tar.gz", "_fileid": "https://r2.ropensci.org/3c7a37e8927d0e887230cdb26e1f122c9d90b4ea2a8194c556ff0826c21737b2", "_filesize": 152444, "_sha256": "3c7a37e8927d0e887230cdb26e1f122c9d90b4ea2a8194c556ff0826c21737b2", "_expires": "2027-01-24T10:42:48.000Z", "_created": "2026-10-16T10:40:06.000Z", "_published": "2026-10-16T10:42:49.855Z", "_buildurl": "https://github.com/r-universe/cran/actions/runs/38888411317", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116932888254, "time": 115, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12040423224" }, { "job": 116932888139, "time": 130, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12040552931" }, { "job": 116931876267, "time": 169, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12040183265" }, { "job": 116932888245, "time": 109, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12040482998" }, { "job": 116932889680, "time": 65, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12040463931" }, { "job": 116932888407, "time": 122, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12041245111" } ], "_upstream": "https://github.com/cran/exceldata", "_commit": { "id": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "author": "Lisa Avery ", "committer": "cran-robot ", "message": "version 0.1.1.3\n", "time": 1700534474 }, "_maintainer": { "name": "Lisa Avery", "email": "lisa.avery@uhn.ca", "orcid": "0000-0002-8431-5143" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "dplyr", "role": "Imports" }, { "package": "ggplot2", "role": "Imports" }, { "package": "graphics", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "readxl", "role": "Imports" }, { "package": "scales", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 1, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 631, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 509, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/exceldata" }, "_searchresults": 1, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/exceldata.html", "extra/manual.pdf", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_realowner": "cran", "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2022-01-10" }, { "version": "0.1.1", "date": "2022-02-23" }, { "version": "0.1.1.1", "date": "2022-03-10" }, { "version": "0.1.1.2", "date": "2022-04-04" }, { "version": "0.1.1.3", "date": "2023-11-20" } ], "_exports": [ "addFactorVariables", "checkData", "createCalculated", "importExcelData", "plotVariables", "readDataDict", "readExcelData" ], "_help": [ { "page": "addFactorVariables", "title": "Create factor variables from data dictionary", "topics": [ "addFactorVariables" ] }, { "page": "checkData", "title": "Check the entered data against the data dictionary", "topics": [ "checkData" ] }, { "page": "createCalculated", "title": "Create calculated variables", "topics": [ "createCalculated" ] }, { "page": "createCategorisedVar", "title": "Create categories from continuous data", "topics": [ "createCategorisedVar" ] }, { "page": "createCombinedVar", "title": "Create a combined variable from several dichotomous variables", "topics": [ "createCombinedVar" ] }, { "page": "createRecodedVar", "title": "Create survival variables (survival duration + status)", "topics": [ "createRecodedVar" ] }, { "page": "createSurvVar", "title": "Create survival variables (survival duration + status)", "topics": [ "createSurvVar" ] }, { "page": "importCodes", "title": "Return A data frame of codes", "topics": [ "importCodes" ] }, { "page": "importExcelData", "title": "Import Excel Data based on the specifications in a data dictionary", "topics": [ "importExcelData" ] }, { "page": "plotVariables", "title": "Return a list of univariate ggplots for each non-character variable", "topics": [ "plotVariables" ] }, { "page": "readDataDict", "title": "Read in the data dictionary", "topics": [ "readDataDict" ] }, { "page": "readExcelData", "title": "Read Excel Data", "topics": [ "readExcelData" ] } ], "_readme": "https://github.com/cran/exceldata/raw/HEAD/README.md", "_rundeps": [ "cellranger", "cli", "cpp11", "crayon", "dplyr", "farver", "generics", "ggplot2", "glue", "gtable", "hms", "isoband", "labeling", "lifecycle", "lubridate", "magrittr", "pillar", "pkgconfig", "prettyunits", "progress", "R6", "RColorBrewer", "readxl", "rematch", "rlang", "S7", "scales", "tibble", "tidyselect", "timechange", "utf8", "vctrs", "viridisLite", "withr" ], "_score": 1.6989700043360187, "_indexed": true, "_nocasepkg": "exceldata", "_universes": [ "cran" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.1.3", "date": "2026-10-16T10:42:01.000Z", "distro": "resolute", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "https://r2.ropensci.org/3403140dbc63726f414056c68bd5c3d0a0bd49509e041f25adf6b855a1553d00", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38888411317" }, { "r": "4.6.1", "os": "linux", "version": "0.1.1.3", "date": "2026-10-16T10:42:06.000Z", "distro": "resolute", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "https://r2.ropensci.org/b7c6aae97eae1f9d9dde595fc7d6fbefc95a9189ad6a34241682c63cdbb1ec5e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38888411317" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.1.3", "date": "2026-10-16T10:42:11.000Z", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "https://r2.ropensci.org/cee6bf242c9f969dc68c74a88299f837091c425256749e1757ad80f98a8a277f", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/38888411317" }, { "r": "4.7.0", "os": "win", "version": "0.1.1.3", "date": "2026-10-16T10:41:06.000Z", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "https://r2.ropensci.org/f6539e209b6856872042650601d9821492c81186f6eaf632423c1490662e716d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38888411317" }, { "r": "4.6.1", "os": "win", "version": "0.1.1.3", "date": "2026-10-16T10:41:45.000Z", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "https://r2.ropensci.org/ae0acb6bf56fefa7fed80723512b40c2546f048137bfc11abc9ec485ef9d353d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/38888411317" } ] }