{ "_id": "6a1ef678b401979e7341728b", "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-05-19 06:37:42 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", "MD5sum": "25ecb2f771fa2cc2d7bcd8252d33fd49", "_user": "anosckin", "_type": "src", "_file": "ExcelFunctionsR_0.1.4.tar.gz", "_fileid": "edae828f42d5dcc535226d981fa38022216a5f96f0ab7c291ac5b8e3f2dec43a", "_filesize": 192975, "_sha256": "edae828f42d5dcc535226d981fa38022216a5f96f0ab7c291ac5b8e3f2dec43a", "_created": "2026-05-19T06:37:42.000Z", "_published": "2026-06-02T15:27:52.614Z", "_distro": "noble", "_jobs": [ { "job": 79107924753, "time": 126, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7076535563" }, { "job": 79107924744, "time": 126, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7076535773" }, { "job": 79107924827, "time": 177, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7076543142" }, { "job": 79107924712, "time": 183, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7076543955" }, { "job": 79107923192, "time": 162, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7076502451" }, { "job": 79107923623, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7362234195" }, { "job": 79107924781, "time": 94, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7076527750" }, { "job": 79107924850, "time": 82, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7076524123" }, { "job": 79107924569, "time": 84, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7076524707" } ], "_buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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", "description": "iOS Engineer for Poe/Quora" }, "_downloads": { "count": 320, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ExcelFunctionsR" }, "_searchresults": 27, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/ExcelFunctionsR.html", "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.4313637641589874, "_indexed": true, "_nocasepkg": "excelfunctionsr", "_universes": [ "anosckin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.4", "date": "2026-05-19T06:39:41.000Z", "distro": "noble", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "b22a9f1307dc907f3d7c4b430200ab975385f6a218f91c53447d56419e7ffa4c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.6.0", "os": "linux", "version": "0.1.4", "date": "2026-05-19T06:39:42.000Z", "distro": "noble", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "c28b8a2598669fbf85e13e40c2f3e0446667e2fdecdc684496efe9ce2bc0f3fc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.5.3", "os": "mac", "version": "0.1.4", "date": "2026-05-19T06:40:12.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "9de7204059cdf917fc80c6dbb755252a0a36ac14c621bc2566515466897b5994", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.6.0", "os": "mac", "version": "0.1.4", "date": "2026-05-19T06:40:19.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "16c187460965586b192b50af5edceedc549aabdd0dcc6dec707347da89210d87", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.7.0", "os": "win", "version": "0.1.4", "date": "2026-05-19T06:39:05.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "f7e2e924900b195d376a49ba8e7483ef0f6d8aeaec8f035c1988cb64665b7a7e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.5.3", "os": "win", "version": "0.1.4", "date": "2026-05-19T06:38:50.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "724ac6f500b8b23701a4a2050e07af9c27e2fdbdef321a3499b7a289552bebd5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.6.0", "os": "win", "version": "0.1.4", "date": "2026-05-19T06:38:53.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "5c66bb7261c30124e511cae9fd3ee25a56566ffcd98832ee35e0bb70aabee7a4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.4", "date": "2026-06-02T15:27:29.000Z", "commit": "c9f93368bc4916bdbfc6aaf4513aea64660fce12", "fileid": "00f82b0d504cb113dea3a5068fa1ec35bd5aaf698a585b45926cdd36c279c3b1", "status": "success", "buildurl": "https://github.com/r-universe/anosckin/actions/runs/26080613701" } ] }