Challenge #308: Size it up

[MarqueeCrew]

Here's a challenge solution.

Spoiler

I didn't like the division by total input rather than by good data.

[kunderwood]

RegEx expressions are one of my favorite things to do. Good parsing challenge. 

Spoiler

[TonyA]

Followed the directions and got a different result. 

Spoiler

We were told to eliminate incomplete data so there should be 1845 rows, not 1850. The solution shows 1850.

[MatthewBr]

Spoiler

Love it - simple parse and prep

[DavidSkaife]

Here's my solution!

Spoiler

[mikemotter]

Spoiler

[ALTSkelly]

Spoiler

Spoiler

[TurboToad]

My solution, had to look at the source data to figure out how to separate some of the values. 

Spoiler

[Reesetrain2]

All,

Spoiler

I'm not really sure what happened as with the 1850 Total entries, I ended up with 286 Large amongst some other small differences.
-I used the Count tool & Append Field Tool, Text To Column, 2 Formula Tools.
-I always attempt to complete every challenge without the use of custom code, so no Regex for me.


-

 

[KarenYL]

Spoiler