Package: ExcelFunctionsR 0.1.4

ExcelFunctionsR: Imports Excel Functions to R

Implements 'Excel' functions in 'R' for your calculation simplicity.You can use most of the aggregate functions, addressing functions,logical functions and text functions. Helps you a ton in learning how 'R' works as some 'Excel' users might be struggling with the program.

Authors:Irakli Salia <[email protected]>

ExcelFunctionsR_0.1.4.tar.gz
ExcelFunctionsR_0.1.4.zip(r-4.5)ExcelFunctionsR_0.1.4.zip(r-4.4)ExcelFunctionsR_0.1.4.zip(r-4.3)
ExcelFunctionsR_0.1.4.tgz(r-4.4-any)ExcelFunctionsR_0.1.4.tgz(r-4.3-any)
ExcelFunctionsR_0.1.4.tar.gz(r-4.5-noble)ExcelFunctionsR_0.1.4.tar.gz(r-4.4-noble)
ExcelFunctionsR_0.1.4.tgz(r-4.4-emscripten)ExcelFunctionsR_0.1.4.tgz(r-4.3-emscripten)
ExcelFunctionsR.pdf |ExcelFunctionsR.html
ExcelFunctionsR/json (API)

# Install 'ExcelFunctionsR' in R:
install.packages('ExcelFunctionsR', repos = c('https://anosckin.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Datasets:
  • Sales - Random Sales Data
  • Streets - Random Salesman Streets Data

On CRAN:

This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.

1.32 score 21 scripts 340 downloads 50 exports 26 dependencies

Last updated 4 years agofrom:c9f93368bc. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 18 2024
R-4.5-winOKNov 18 2024
R-4.5-linuxOKNov 18 2024
R-4.4-winOKNov 18 2024
R-4.4-macOKNov 18 2024
R-4.3-winOKNov 18 2024
R-4.3-macOKNov 18 2024

Exports:ANDAVERAGEAVERAGEIFAVERAGEIFSCONCATCONCATENATECOUNTCOUNTIFCOUNTIFSDATEDATEDIFDATETOEXCELSERIESDAYDAYSEOMONTHFINDIFIFNAINDEXISBLANKISEVENISLOGICALISNUMBERISODDLEFTLENLOWERMATCHMAXIFMAXIFSMIDMINIFMINIFSMONTHNOTNOWORRANDRANDBETWEENREPTRIGHTSTDEVSUBSTITUTESUMIFSUMIFSTODAYUPPERVLOOKUPWEEKDAYYEAR

Dependencies:clicpp11dplyrfansigenericsgluelifecyclelubridatemagrittrpillarpkgconfigplyrpurrrR6Rcpprlangroperatorsstringistringrtibbletidyrtidyselecttimechangeutf8vctrswithr

Readme and manuals

Help Manual

Help pageTopics
Basic AND function from excelAND
Basic AVERAGE function from excelAVERAGE
Basic AVERAGEIF function from excelAVERAGEIF
Basic AVERAGEIFS function from excelAVERAGEIFS
Basic Concat function from excelCONCAT
Basic Concatenate function from excelCONCATENATE
Basic COUNT function from excelCOUNT
Basic COUNTIF function from excelCOUNTIF
Basic COUNTIFS function from excelCOUNTIFS
Basic DATE function from excelDATE
Basic DATEDIF function from excelDATEDIF
Date to excel date series functionDATETOEXCELSERIES
Basic DAY function from excelDAY
Basic DAYS function from excelDAYS
Basic EOMONTH function from excelEOMONTH
Basic FIND function from excelFIND
Basic If function from excelIF
Basic IFNA function from excelIFNA
Basic INDEX function from excelINDEX
Basic ISBLANK function from excelISBLANK
Basic ISEVEN function from excelISEVEN
Basic ISLOGICAL function from excelISLOGICAL
Basic ISNUMBER function from excelISNUMBER
Basic ISODD function from excelISODD
Basic LEFT function from excelLEFT
Basic LEN function from excelLEN
Basic LOWER function from excelLOWER
Basic MATCH function from excelMATCH
Basic MAXIF function from excelMAXIF
Basic MAXIFS function from excelMAXIFS
Basic MID function from excelMID
Basic MINIF function from excelMINIF
Basic MINIFS function from excelMINIFS
Basic MONTH function from excelMONTH
Basic NOT function from excelNOT
Basic NOW function from excelNOW
Basic OR function from excelOR
Basic RAND function from excel.RAND
Basic RANDBETWEEN function from excelRANDBETWEEN
Basic REPT function from excelREPT
Basic RIGHT function from excelRIGHT
Random Sales DataSales
Basic STDEV function from excelSTDEV
Random Salesman Streets DataStreets
Basic SUBSTITUTE function from excelSUBSTITUTE
Basic SUMIF function from excelSUMIF
Basic SUMIFS function from excelSUMIFS
Basic TODAY function from excelTODAY
Basic UPPER function from excelUPPER
Basic VLOOKUP function from excelVLOOKUP
Basic WEEKDAY function from excelWEEKDAY
Basic YEAR function from excelYEAR