Creating sorting order file from converted data using Excel

Prerequisites: you have converted weidu.log or BWS data

Final step:
Open Excel and use "Import Text" feature, import converted data, choose 'space' as text quantifier
You should now have long list of ModID ComponentNumber like this

|   ModID    | ComponentNumber |
--------------------------------
| DlcMerger  | 1               | 
| dsotscBGEE | 0               | 
| .          | .               | 

Next, for each line you should do the following:

• if there is a single ModID with single ComponentNumber and there is no other line with the same ModID, replace ComponentNumber with *

Example:

|           Before             |             After            |
|------------|-----------------|------------|-----------------|
| ModID      | ComponentNumber | ModID      | ComponentNumber |
| DlcMerger  | 1               | DlcMerger  | *               |
| dsotscBGEE | 0               | dsotscBGEE | *               |

• if there are few lines with the same ModID but different components, and there is no other line with the same ModID at any row below, replace all lines which contain the same ModID with ModID *. You must make sure by searching using ModID that there aren't any other lines which contain ModID below the initial group!

Good Example for NTotSC and drizztsaga: Those two mods do not have their components anywhere else so * can be used.

| ModID      | ComponentNumber | ModID      | ComponentNumber |
|------------|-----------------|------------|-----------------|
| NTotSC     | 0               | NTotSC     | *               |
| NTotSC     | 1               |            |                 |
| NTotSC     | 2               |            |                 |
| NTotSC     | 3               |            |                 |
| NTotSC     | 4               |            |                 |
| NTotSC     | 5               |            |                 |
| NTotSC     | 6               |            |                 |
| drizztsaga | 0               | drizztsaga | *               |
| drizztsaga | 1               |            |                 |
| drizztsaga | 2               |            |                 |
| drizztsaga | 3               |            |                 |

• If mod components are spited across lines and there are other mods between them you cannot use * everywhere because there are two places where RR exist (separated by other mods). You can put ComponentNumber into the same row inside Excel (columns C, D, E...)

Example for RR mod before conversion:

| ModID               | ComponentNumber |   |   |
|---------------------|-----------------|---|---|
| RR                  | 0               |   |   |
| RR                  | 1               |   |   |
| RR                  | 3               |   |   |
| RR                  | 4               |   |   |
| RR                  | 6               |   |   |
| RR                  | 7               |   |   |
| WSR                 | 100             |   |   |
| .                   | .               |   |   |
| (OtherMod)          | x               |   |   |
| .                   | .               |   |   |
| RelieveWizardSlayer | 0               |   |   |
| RR                  | 9               |   |   |
| RR                  | 10              |   |   |
| RR                  | 999             |   |   |

Example for RR after conversion:

| ModID               | CN  | CN | CN  | CN | CN | CN |
|---------------------|-----|----|-----|----|----|----|
| RR                  | 0   | 1  | 3   | 4  | 6  | 7  |
| WSR                 | 100 |    |     |    |    |    |
| .                   | .   |    |     |    |    |    |
| .                   | .   |    |     |    |    |    |
| .                   | .   |    |     |    |    |    |
| RelieveWizardSlayer | *   |    |     |    |    |    |
| RR                  | 9   | 10 | 999 |    |    |    |