Challenge #128: Settle the Score

[Sashikumar]

My Solution.

Spoiler

[Steph_Maddrell]

Spoiler

[AntDavis42]

My Solution. great to do some regex as it always goes over my head.

Spoiler

[vbrown]

My solution.

[Erin]

Spoiler

Extra self inflicted practice with the transpose / crosstab tools because originally my results were like this:

But flipped them to this to be consistent with the output file: 

Also, curious to see how others solved the score issue because I just made a text input lookup file with the corresponding values. It felt like cheating. 

[Erin]

Thanks @NicoleJohnson ! 

Spoiler

I knew RegEx could account for the Uppercase / Lowercase scoring but couldn't conceptualize how to do it. So glad you posted it! 

[euanwilson]

Formula's upon Formula's. 

Spoiler

So for this one I decided to change the uppercase score denominators into numbers, 1 = A, 2 = B and so on.
Next I used formulas with Regex CountMatches to count the number of instances of each score  denominator by round. 
I used a select tool to change the fields to 'double' before the next round of formulas. 
To calculate the score of each player in each round I then just used formula's to subtract the negative scores from the total of positive scores. A select tool was then used to remove the now irrelevant columns and rename the relevant ones.

A transpose tool followed by a cross tab was then used to get the round numbers as the column headers and grouped by the score of each player. A select tool was used to rename the column headers and a final formula was used to calculate the total score of each player. 

[derekbelyea]

Spoiler

[Raghusrnvs]

Here is my solution.

[cwkoops]

Likely a better approach than this, but not too bad.