Bringer of Rain Elite Dynasty - - bjmbleagues.com

[JG34]

What was that trade again?

 

Found it.

 

Major Trade Deal

 

To Frenchsoup:

 

Alex Reyes

Michael Wacha

Brandon Drury

#17

#35

 

To Boozehounds:

 

EE

McCutchen

2017 BORED Championship

[L54]

Found it.

 

Oh yes, I remember hating it for Jim then and my position hasn't changed.

[Orgfiller]

That was a gift and a half even ignoring Reyes' TJS.

[BTS]

Shouldn't the boozehounds be streaming like 5 guys tomorrow?

[Jimcanuck]

Oh yes, I remember hating it for Jim then and my position hasn't changed.

 

Had been shopping them for a while, that was the best deal available. Turned an old team into the youngest with a top prospect list.

[jays4life19]

So we can start trading on Monday right?

[BTS]

So we can start trading on Monday right?

 

Yes. And Roster moves will be allowed through Wednesday in yahoo.

[jays4life19]

Abom, I will be contacting you shortly in regards to a Trevor Rosenthal trade.

[Abomination]

Abom, I will be contacting you shortly in regards to a Trevor Rosenthal trade.

 

Sure, I'll have to see if I can reasonably protect him through the next two cutdowns though. By my count, I'm already at 22, and that's without promotions next year.

[Jimcanuck]

I have speed for days, anyone interested in Billy Hamilton

 

83 runs and 58 SB in an off year for him

[jays4life19]

If any other rebuilding teams want Rosenthal they should contact me as I'll be moving him pretty quickly. He was light out last year, is still only 27 and will be back by August of next year

[jays4life19]

Also, Does anyone know if frenchsoup is okay? He was acting really strange on the board and then just completely disappeared.

[P2F]

Also, Does anyone know if frenchsoup is okay? He was acting really strange on the board and then just completely disappeared.

 

Allens.

[Spanky99]

Shouldn't the boozehounds be streaming like 5 guys tomorrow?

 

Meh...

[Spanky99]

Congrats on your title L54!

[BTS]

Congrats L54

[P2F]

Congrats on your win, L54.

[burlingtonbandit]

Better make a move today, drunks. Such a high cost paid to get Cutch, EE, Bats.

 

You sure like to brag about a pretty crappy team.

[L54]

Thanks guys. First BJMB title feels pretty good, although it didn't feel safe until the week was over.

 

From worst to first- anything is possible my friends.

[Abomination]

Thanks guys. First BJMB title feels pretty good, although it didn't feel safe until the week was over.

 

From worst to first- anything is possible my friends.

 

Grats. Hmm, I'm in worst right now. I like this precedent.

[L54]

Grats. Hmm, I'm in worst right now. I like this precedent.

 

Thanks Abom. If you believe you can achieve.

[Abomination]

Thanks Abom. If you believe you can achieve.

 

I expect next year to be the start of my compete cycle. I feel like my rebuild is (mostly) ready, with a ton of young talent to slowly filter its way up as well to fill in holes.

[BTS]

I have an excess of relievers and want to re-stock my farm a bit, so I'm putting Sean Doolittle on the market.

[Jimcanuck]

congrats L54

[jays4life19]

Nice work L54. Congrats!

[BTS]

I've started transferring rosters to the spreadsheet, and my plan is to chip away at it over the next few days. If people can help me, that would be great.

[P2F]

I've started transferring rosters to the spreadsheet, and my plan is to chip away at it over the next few days. If people can help me, that would be great.

 

I got you, boo.

[Abomination]

Paste the team into excel (from each team's page to prevent formatting issues) and run the following query:

 

let
   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type any}, {"Column7", type any}, {"Column8", type any}, {"Column9", type any}, {"Column10", type any}, {"Column11", type any}, {"Column12", type any}, {"Column13", type any}, {"Column14", type any}, {"Column15", type any}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}}),
   #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Column2"}),
   #"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","No new player Notes","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","New Player Note","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Player Note","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Day-to-Day","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","60-Day DL","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value5" = Table.ReplaceValue(#"Replaced Value4","10-Day DL","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value6" = Table.ReplaceValue(#"Replaced Value5","Not Active","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value7" = Table.ReplaceValue(#"Replaced Value6","(Empty)","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value8" = Table.ReplaceValue(#"Replaced Value7","Pitchers","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value9" = Table.ReplaceValue(#"Replaced Value8","","",Replacer.ReplaceText,{"Column2"}),
   #"Removed Blank Rows" = Table.SelectRows(#"Replaced Value9", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
   #"Removed Blank Rows"

 

Then just copy and paste

[BTS]

Paste the team into excel (from each team's page to prevent formatting issues) and run the following query:

 

let
   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type any}, {"Column7", type any}, {"Column8", type any}, {"Column9", type any}, {"Column10", type any}, {"Column11", type any}, {"Column12", type any}, {"Column13", type any}, {"Column14", type any}, {"Column15", type any}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}}),
   #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Column2"}),
   #"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","No new player Notes","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","New Player Note","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Player Note","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Day-to-Day","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","60-Day DL","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value5" = Table.ReplaceValue(#"Replaced Value4","10-Day DL","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value6" = Table.ReplaceValue(#"Replaced Value5","Not Active","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value7" = Table.ReplaceValue(#"Replaced Value6","(Empty)","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value8" = Table.ReplaceValue(#"Replaced Value7","Pitchers","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value9" = Table.ReplaceValue(#"Replaced Value8","","",Replacer.ReplaceText,{"Column2"}),
   #"Removed Blank Rows" = Table.SelectRows(#"Replaced Value9", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
   #"Removed Blank Rows"

 

Then just copy and paste

 

Thanks, but me and P2F just crushed it.

[P2F]

Paste the team into excel (from each team's page to prevent formatting issues) and run the following query:

 

let
   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type any}, {"Column7", type any}, {"Column8", type any}, {"Column9", type any}, {"Column10", type any}, {"Column11", type any}, {"Column12", type any}, {"Column13", type any}, {"Column14", type any}, {"Column15", type any}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}}),
   #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Column2"}),
   #"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","No new player Notes","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","New Player Note","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Player Note","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Day-to-Day","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","60-Day DL","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value5" = Table.ReplaceValue(#"Replaced Value4","10-Day DL","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value6" = Table.ReplaceValue(#"Replaced Value5","Not Active","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value7" = Table.ReplaceValue(#"Replaced Value6","(Empty)","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value8" = Table.ReplaceValue(#"Replaced Value7","Pitchers","",Replacer.ReplaceText,{"Column2"}),
   #"Replaced Value9" = Table.ReplaceValue(#"Replaced Value8","","",Replacer.ReplaceText,{"Column2"}),
   #"Removed Blank Rows" = Table.SelectRows(#"Replaced Value9", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
   #"Removed Blank Rows"

 

Then just copy and paste

 

Thanks, Abom. We totally did this!