The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

excel2eprime

The goal of excel2eprime is to provide a easy way to split experiment sentences by different factors.

Installation

You can install the development version of excel2eprime from GitHub with:

# install.packages("devtools")
devtools::install_github("wujackwill/excel2eprime")

Example

This is a basic example which shows you how to solve a common problem:

library(excel2eprime)

Split experiment materials of different design

data <- split_basic("D:\\personal\\excel2eprime\\inst\\extdata\\basic.xlsx","A")

data
#> # A tibble: 2 × 10
#>   A                        w1    w2    w3    w4    w5    w6    w7    w8    w9   
#>   <chr>                    <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have the doc in m… I     may   have  the   doc   in    my    left  hand 
#> 2 I have the doc in my le… I     have  the   doc   in    my    left  hand  <NA>

data <- split_12("D:\\personal\\excel2eprime\\inst\\extdata\\12.xlsx","A")

data$con1
#> # A tibble: 2 × 10
#>   A                        w1    w2    w3    w4    w5    w6    w7    w8    w9   
#>   <chr>                    <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have/has the doc … I     may   have  the   doc   in    my    left  "han…
#> 2 I have/has the doc in m… I     have  the   doc   in    my    left  hand  " "

data <- split_22("D:\\personal\\excel2eprime\\inst\\extdata\\22.xlsx","A")

data$con1
#> # A tibble: 2 × 10
#>   A                        w1    w2    w3    w4    w5    w6    w7    w8    w9   
#>   <chr>                    <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have/has the doc … I     may   have  the   doc   in    my    left  "han…
#> 2 I have/has the doc in m… I     have  the   doc   in    my    left  hand  " "

data <- split_222("D:\\personal\\excel2eprime\\inst\\extdata\\222.xlsx","A")

data$con1
#> # A tibble: 2 × 10
#>   A                        w1    w2    w3    w4    w5    w6    w7    w8    w9   
#>   <chr>                    <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have/has the doc … I     may   have  the   doc   in    my    left  "han…
#> 2 I have/has the doc in m… I     have  the   doc   in    my    left  hand  " "

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.