{ "_id": "6ad1eb85d3c80a766859c732", "Package": "ExcelFunctionsR", "Type": "Package", "Title": "Imports Excel Functions to R", "Version": "0.1.4", "Author": "Irakli Salia ", "Maintainer": "Nika Salia <2001salia@gmail.com>", "Description": "Implements 'Excel' functions in 'R' for your calculation\nsimplicity.You can use most of the aggregate functions,\naddressing functions,logical functions and text functions.\nHelps you a ton in learning how 'R' works as some 'Excel' users\nmight be struggling with the program.", "License": "GPL-3", "Encoding": "UTF-8", "LazyData": "true", "RoxygenNote": "7.1.0", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-16 08:10:48 UTC", "User": "root" }, "Config/pak/sysreqs": "libicu-dev", "Repository": "https://anosckin.r-universe.dev", "Date/Publication": "2020-06-22 08:40:03 UTC", "RemoteUrl": "https://github.com/cran/ExcelFunctionsR", "RemoteRef": "HEAD", "RemoteSha": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "_user": "anosckin", "_type": "src", "_file": "ExcelFunctionsR_0.1.4.tar.gz", "_fileid": "https://r2.ropensci.org/006f76f0b3b404cc95e3e4e4f36c4b757daea9ca3f28c375e122172139e4d35f", "_filesize": 191576, "_sha256": "006f76f0b3b404cc95e3e4e4f36c4b757daea9ca3f28c375e122172139e4d35f", "_expires": "2027-01-24T09:16:51.000Z", "_created": "2026-10-16T08:10:48.000Z", "_published": "2026-10-16T09:16:53.516Z", "_buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116878055975, "time": 122, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12033613207" }, { "job": 116878055886, "time": 110, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12033444234" }, { "job": 116878056098, "time": 191, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12036043667" }, { "job": 116878055985, "time": 155, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12035884756" }, { "job": 116876899924, "time": 189, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12032614424" }, { "job": 116878055716, "time": 82, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12034080203" }, { "job": 116878055945, "time": 83, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12033915051" }, { "job": 116878055703, "time": 74, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12032744459" }, { "job": 116878055729, "time": 77, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12034110110" } ], "_upstream": "https://github.com/cran/ExcelFunctionsR", "_commit": { "id": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "author": "Nika Salia <2001salia@gmail.com>", "committer": "cran-robot ", "message": "version 0.1.4\n", "time": 1592815203 }, "_maintainer": { "name": "Nika Salia", "email": "2001salia@gmail.com", "login": "anosckin", "description": "iOS Engineer for Poe/Quora", "uuid": 82905597 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 2.10", "role": "Depends" }, { "package": "stringr", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "roperators", "role": "Imports" }, { "package": "plyr", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "anosckin", "count": 1, "uuid": 82905597 } ], "_userbio": { "uuid": 82905597, "type": "user", "name": "Nika Salia", "followers": 20, "description": "iOS Engineer for Poe/Quora" }, "_downloads": { "count": 352, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ExcelFunctionsR" }, "_searchresults": 39, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/ExcelFunctionsR.html", "extra/manual.pdf" ], "_realowner": "anosckin", "_cranurl": false, "_releases": [ { "version": "0.1.4", "date": "2020-06-22" } ], "_exports": [ "AND", "AVERAGE", "AVERAGEIF", "AVERAGEIFS", "CONCAT", "CONCATENATE", "COUNT", "COUNTIF", "COUNTIFS", "DATE", "DATEDIF", "DATETOEXCELSERIES", "DAY", "DAYS", "EOMONTH", "FIND", "IF", "IFNA", "INDEX", "ISBLANK", "ISEVEN", "ISLOGICAL", "ISNUMBER", "ISODD", "LEFT", "LEN", "LOWER", "MATCH", "MAXIF", "MAXIFS", "MID", "MINIF", "MINIFS", "MONTH", "NOT", "NOW", "OR", "RAND", "RANDBETWEEN", "REPT", "RIGHT", "STDEV", "SUBSTITUTE", "SUMIF", "SUMIFS", "TODAY", "UPPER", "VLOOKUP", "WEEKDAY", "YEAR" ], "_datasets": [ { "name": "Sales", "title": "Random Sales Data", "object": "Sales", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Names", "Country", "Cost", "Sales" ], "rows": 24, "table": true, "tojson": true }, { "name": "Streets", "title": "Random Salesman Streets Data", "object": "Streets", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "Country", "Street" ], "rows": 4, "table": true, "tojson": true } ], "_help": [ { "page": "AND", "title": "Basic AND function from excel", "topics": [ "AND" ] }, { "page": "AVERAGE", "title": "Basic AVERAGE function from excel", "topics": [ "AVERAGE" ] }, { "page": "AVERAGEIF", "title": "Basic AVERAGEIF function from excel", "topics": [ "AVERAGEIF" ] }, { "page": "AVERAGEIFS", "title": "Basic AVERAGEIFS function from excel", "topics": [ "AVERAGEIFS" ] }, { "page": "CONCAT", "title": "Basic Concat function from excel", "topics": [ "CONCAT" ] }, { "page": "CONCATENATE", "title": "Basic Concatenate function from excel", "topics": [ "CONCATENATE" ] }, { "page": "COUNT", "title": "Basic COUNT function from excel", "topics": [ "COUNT" ] }, { "page": "COUNTIF", "title": "Basic COUNTIF function from excel", "topics": [ "COUNTIF" ] }, { "page": "COUNTIFS", "title": "Basic COUNTIFS function from excel", "topics": [ "COUNTIFS" ] }, { "page": "DATE", "title": "Basic DATE function from excel", "topics": [ "DATE" ] }, { "page": "DATEDIF", "title": "Basic DATEDIF function from excel", "topics": [ "DATEDIF" ] }, { "page": "DATETOEXCELSERIES", "title": "Date to excel date series function", "topics": [ "DATETOEXCELSERIES" ] }, { "page": "DAY", "title": "Basic DAY function from excel", "topics": [ "DAY" ] }, { "page": "DAYS", "title": "Basic DAYS function from excel", "topics": [ "DAYS" ] }, { "page": "EOMONTH", "title": "Basic EOMONTH function from excel", "topics": [ "EOMONTH" ] }, { "page": "FIND", "title": "Basic FIND function from excel", "topics": [ "FIND" ] }, { "page": "IF", "title": "Basic If function from excel", "topics": [ "IF" ] }, { "page": "IFNA", "title": "Basic IFNA function from excel", "topics": [ "IFNA" ] }, { "page": "INDEX", "title": "Basic INDEX function from excel", "topics": [ "INDEX" ] }, { "page": "ISBLANK", "title": "Basic ISBLANK function from excel", "topics": [ "ISBLANK" ] }, { "page": "ISEVEN", "title": "Basic ISEVEN function from excel", "topics": [ "ISEVEN" ] }, { "page": "ISLOGICAL", "title": "Basic ISLOGICAL function from excel", "topics": [ "ISLOGICAL" ] }, { "page": "ISNUMBER", "title": "Basic ISNUMBER function from excel", "topics": [ "ISNUMBER" ] }, { "page": "ISODD", "title": "Basic ISODD function from excel", "topics": [ "ISODD" ] }, { "page": "LEFT", "title": "Basic LEFT function from excel", "topics": [ "LEFT" ] }, { "page": "LEN", "title": "Basic LEN function from excel", "topics": [ "LEN" ] }, { "page": "LOWER", "title": "Basic LOWER function from excel", "topics": [ "LOWER" ] }, { "page": "MATCH", "title": "Basic MATCH function from excel", "topics": [ "MATCH" ] }, { "page": "MAXIF", "title": "Basic MAXIF function from excel", "topics": [ "MAXIF" ] }, { "page": "MAXIFS", "title": "Basic MAXIFS function from excel", "topics": [ "MAXIFS" ] }, { "page": "MID", "title": "Basic MID function from excel", "topics": [ "MID" ] }, { "page": "MINIF", "title": "Basic MINIF function from excel", "topics": [ "MINIF" ] }, { "page": "MINIFS", "title": "Basic MINIFS function from excel", "topics": [ "MINIFS" ] }, { "page": "MONTH", "title": "Basic MONTH function from excel", "topics": [ "MONTH" ] }, { "page": "NOT", "title": "Basic NOT function from excel", "topics": [ "NOT" ] }, { "page": "NOW", "title": "Basic NOW function from excel", "topics": [ "NOW" ] }, { "page": "OR", "title": "Basic OR function from excel", "topics": [ "OR" ] }, { "page": "RAND", "title": "Basic RAND function from excel.", "topics": [ "RAND" ] }, { "page": "RANDBETWEEN", "title": "Basic RANDBETWEEN function from excel", "topics": [ "RANDBETWEEN" ] }, { "page": "REPT", "title": "Basic REPT function from excel", "topics": [ "REPT" ] }, { "page": "RIGHT", "title": "Basic RIGHT function from excel", "topics": [ "RIGHT" ] }, { "page": "Sales", "title": "Random Sales Data", "topics": [ "Sales" ] }, { "page": "STDEV", "title": "Basic STDEV function from excel", "topics": [ "STDEV" ] }, { "page": "Streets", "title": "Random Salesman Streets Data", "topics": [ "Streets" ] }, { "page": "SUBSTITUTE", "title": "Basic SUBSTITUTE function from excel", "topics": [ "SUBSTITUTE" ] }, { "page": "SUMIF", "title": "Basic SUMIF function from excel", "topics": [ "SUMIF" ] }, { "page": "SUMIFS", "title": "Basic SUMIFS function from excel", "topics": [ "SUMIFS" ] }, { "page": "TODAY", "title": "Basic TODAY function from excel", "topics": [ "TODAY" ] }, { "page": "UPPER", "title": "Basic UPPER function from excel", "topics": [ "UPPER" ] }, { "page": "VLOOKUP", "title": "Basic VLOOKUP function from excel", "topics": [ "VLOOKUP" ] }, { "page": "WEEKDAY", "title": "Basic WEEKDAY function from excel", "topics": [ "WEEKDAY" ] }, { "page": "YEAR", "title": "Basic YEAR function from excel", "topics": [ "YEAR" ] } ], "_rundeps": [ "cli", "cpp11", "dplyr", "generics", "glue", "lifecycle", "lubridate", "magrittr", "pillar", "pkgconfig", "plyr", "purrr", "R6", "Rcpp", "rlang", "roperators", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "utf8", "vctrs", "withr" ], "_score": 1.591064607026499, "_indexed": true, "_nocasepkg": "excelfunctionsr", "_universes": [ "anosckin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.4", "date": "2026-10-16T08:12:51.000Z", "distro": "resolute", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/0355345a6677d85f3c7470bbc63eddc5783c4b0cbe9ce8aeaf6550a99d6b3f86", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.6.1", "os": "linux", "version": "0.1.4", "date": "2026-10-16T08:12:36.000Z", "distro": "resolute", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/2678a99aa6b39b82d8ed6d6aa0339970a95820197f1f8b074964a75571d52e1d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.5.3", "os": "mac", "version": "0.1.4", "date": "2026-10-16T09:10:55.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/5e5500b7559df81ec5707cb5673f2f291171e9d91e7132c63aa7160a49f42faa", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.6.1", "os": "mac", "version": "0.1.4", "date": "2026-10-16T09:15:44.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/f6a8fe7068ae0d41cf12a8a37c386854c0f2e36c737de6e28eedf2aeaa82dfb5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.4", "date": "2026-10-16T08:12:31.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/9894aadc53449fdd8f065ce82c02e1c8416f5530cdc689d6ae79d9e640f32216", "status": "success", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.7.0", "os": "win", "version": "0.1.4", "date": "2026-10-16T08:12:10.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/f2f58152639596f731b833244a237d8c5e82daf628b81a417164cf3e72683d8f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.5.3", "os": "win", "version": "0.1.4", "date": "2026-10-16T08:11:56.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/8ab006ad0d8a1b01f5db75739e2780c0028ad21774b63aa741824aa415ad94e6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" }, { "r": "4.6.1", "os": "win", "version": "0.1.4", "date": "2026-10-16T08:11:55.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "https://r2.ropensci.org/8641c35885d34ce9da0d885d958aa66058032bb77d362aeeb2e8ba591eee8585", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/38871610496" } ] }