{ "_id": "6a142b5facfb0bcc41d40c49", "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-05-25 10:55:35 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", "MD5sum": "7c548921a0ad8478a26ae5cc778a5ee4", "_user": "cran", "_type": "src", "_file": "exceldata_0.1.1.3.tar.gz", "_fileid": "ab843ee8e1ec2a6094fadf2210cbd28cfb2778452fffb34c38422d6653b65ec9", "_filesize": 152913, "_sha256": "ab843ee8e1ec2a6094fadf2210cbd28cfb2778452fffb34c38422d6653b65ec9", "_created": "2026-05-25T10:55:35.000Z", "_published": "2026-05-25T10:58:39.963Z", "_distro": "noble", "_jobs": [ { "job": 77699637959, "time": 155, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7196850105" }, { "job": 77699638013, "time": 135, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7196845264" }, { "job": 77699271661, "time": 176, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7196810619" }, { "job": 77699637953, "time": 110, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7196839067" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/26396650420", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 366, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/exceldata" }, "_searchresults": 1, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/exceldata.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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-05-25T10:58:00.000Z", "distro": "noble", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "cc454c5efb074e6ad5a1d8333f5b2c03c127def8783f7589ea3e426a120f3813", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26396650420" }, { "r": "4.6.0", "os": "linux", "version": "0.1.1.3", "date": "2026-05-25T10:57:37.000Z", "distro": "noble", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "5cf593959ffa6a2f2b7e2aab417d71aa35e640a42354779ecc95ab82e240b68f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26396650420" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.1.3", "date": "2026-05-25T10:57:41.000Z", "commit": "7f5ba972e103d1d72d03cdf7b89900d153641c9f", "fileid": "5bb0e255a60ae4fb358c0962f181684bc1fd55bbdd284c0f58bf0a2d292996b7", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/26396650420" } ] }