csv2xlsx-student/setup.R at master · lagon/csv2xlsx-student · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
studentProjectsDirectory <- "~/Sources/CSV2XLS/Input"
outputDirectory <- "~/Sources/CSV2XLS/Output"


conversionSetup <- list(
  SkipLines = 3,
  ColumnNames = list(
    "A" = "DMU",
    "B" = "DMU-window",
    "C" = "Period",
    "D" = "rawMaterialAvailable",
    "E" = "rawMaterialMinimumCost",
    "F" = "potentialMarketForFinishedInventory",
    "G" = "maxMarketValueForFinishedInvetory",
    "H" = "account",
    "I" = "productFinalySell",
    "J" = "loan",
    "K" = "rawMaterialMinimumCostNEW",
    "L" = "accountNEW"
  ),

  ColumnsDefinitions = list(
    "A" = "#DMU",
    "B" = "#DMU-window",
    "C" = "#Period",
    "D" = "rawMaterialAvailable",
    "E" = "rawMaterialMinimumCost",
    "F" = "potentialMarketForFinishedInventory",
    "G" = "maxMarketValueForFinishedInvetory",
    "H" = "account",
    "I" = "productFinalySell",
    "J" = "loan",
    "K" = "=(MAX($E$2:$E$49)+MIN($E$2:$E$49))-E%&",
    "L" = "=H%&-J%&"
  )
)