{ "_id": "6a23df62530b9bc726be75bc", "Package": "unexcel", "Title": "Revert Excel Serial Dates Back to Intended Day.Month Numerics", "Version": "0.1.0", "Authors@R": "person(\"Hercules\", \"Freitas\", email = \"hercules.freitas@uerj.br\",\nrole = c(\"aut\",\"cre\"),\ncomment = c(ORCID = \"0000-0003-1584-9157\"))", "Description": "Detects values imported from spreadsheets that were\nauto-converted to Excel date serials and reconstructs the\noriginally intended day.month decimals (for example, '30.3'\nthat Excel displayed as '30/03/2025'). The functions work in a\nvectorized manner, preserve non-serial values, and support both\nthe 1900 and 1904 date systems.", "License": "MIT + file LICENSE", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "URL": "https://github.com/drhrf/unexcel", "BugReports": "https://github.com/drhrf/unexcel/issues", "Language": "en-US", "Repository": "https://drhrf.r-universe.dev", "Date/Publication": "2025-10-04 16:16:04 UTC", "RemoteUrl": "https://github.com/drhrf/unexcel", "RemoteRef": "HEAD", "RemoteSha": "f2a29e629f9f92da03a8076a7f7676d070a72187", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-06 08:47:05 UTC", "User": "root" }, "Author": "Hercules Freitas [aut, cre] (ORCID:\n)", "Maintainer": "Hercules Freitas ", "MD5sum": "2e2caede25533569cb13c2a82cd52bdd", "_user": "drhrf", "_type": "src", "_file": "unexcel_0.1.0.tar.gz", "_fileid": "9d6462b2de49de031fda4c1e4196a4256661d7fbe69212ca7d99e307482dbba7", "_filesize": 86033, "_sha256": "9d6462b2de49de031fda4c1e4196a4256661d7fbe69212ca7d99e307482dbba7", "_created": "2026-06-06T08:47:05.000Z", "_published": "2026-06-06T08:50:42.442Z", "_distro": "noble", "_jobs": [ { "job": 79865299396, "time": 101, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7452980023" }, { "job": 79865299398, "time": 107, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7452980690" }, { "job": 79865299397, "time": 192, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7452986247" }, { "job": 79865299422, "time": 186, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7452984432" }, { "job": 79864479079, "time": 924, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7452968114" }, { "job": 79865299392, "time": 93, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7452979090" }, { "job": 79865299427, "time": 71, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7452976779" }, { "job": 79865299420, "time": 60, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7452975350" }, { "job": 79865299428, "time": 66, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7452976111" } ], "_buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/drhrf/unexcel", "_commit": { "id": "f2a29e629f9f92da03a8076a7f7676d070a72187", "author": "Hercules Rezende Freitas ", "committer": "Hercules Rezende Freitas ", "message": "Add cran-comments.md and update .Rbuildignore\n", "time": 1759594564 }, "_maintainer": { "name": "Hercules Freitas", "email": "hercules.freitas@uerj.br", "login": "drhrf", "orcid": "0000-0003-1584-9157", "description": "", "uuid": 91353422 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6", "role": "Depends" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "drhrf", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-40", "n": 3 } ], "_tags": [], "_stars": 0, "_contributors": [ { "user": "drhrf", "count": 3, "uuid": 91353422 } ], "_userbio": { "uuid": 91353422, "type": "user", "name": "drhrf" }, "_downloads": { "count": 84, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/unexcel" }, "_devurl": "https://github.com/drhrf/unexcel", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/unexcel.html", "manual.pdf" ], "_homeurl": "https://github.com/drhrf/unexcel", "_realowner": "drhrf", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2025-10-08" } ], "_exports": [ "fix_serial_columns", "restore_day_month" ], "_help": [ { "page": "fix_serial_columns", "title": "Fix likely-serial columns in a data frame", "topics": [ "fix_serial_columns" ] }, { "page": "restore_day_month", "title": "Revert Excel date serials to intended day.month numerics", "topics": [ "restore_day_month" ] } ], "_rundeps": [], "_vignettes": [ { "source": "unexcel.Rmd", "filename": "unexcel.html", "title": "Getting Started with unexcel", "author": "Hercules Freitas", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Excel date systems", "The 1900 leap-year bug", "Reconstructing day.month numerics", "Guardrails against false conversions", "Difference from formatted strings", "Working with data frames", "Summary", "Session information" ], "created": "2025-10-04 15:32:26", "modified": "2025-10-04 15:32:26", "commits": 1 } ], "_score": 3, "_indexed": true, "_nocasepkg": "unexcel", "_universes": [ "drhrf" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-06-06T08:48:51.000Z", "distro": "noble", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "f6aff52b94f20ae459b5dffcd62f97d6251fc10827cdd2f0a591453776a8443d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-06-06T08:48:55.000Z", "distro": "noble", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "0847135352779a353396ab77f3222afa3e36eb3bcb0430b6e00063bd8d178279", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-06-06T08:49:46.000Z", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "d34d66a8667baac3b960f53d2f49a7d30b766f40cdcd56b5a65b0bfaf7096d7f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-06-06T08:49:27.000Z", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "97392e98bc960ed66321601fad490d0083bcc50f39713ed82c9ef2c3ad311dd4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-06-06T08:48:50.000Z", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "737e0bfe93a894381a95677a8696ea2513856c4ba125e578771483956c3714c0", "status": "success", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-06-06T08:48:16.000Z", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "dbfcc18233d9d8f622568f85523f72864228b0ae416af04fce57dbc9b6762a84", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-06-06T08:48:05.000Z", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "a2be71058a9ae55244b0afc8db9709b7a6f95eec30e543738ef958453ec65820", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-06-06T08:48:11.000Z", "commit": "f2a29e629f9f92da03a8076a7f7676d070a72187", "fileid": "6f2adc23bd911eadd258d093cfa223aeb413de94b65d400f657aba52eb2742f4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/drhrf/actions/runs/27057512578" } ] }