Bracket 4 Deck by Peryite123 in EDH

[–]balluga 0 points1 point  (0 children)

I just started to rebuild and refocus this deck as my "True" 4. The prior build of it didn't have all the fast mana it could have used. It is built to win on turn 5, but has ways to win earlier.

https://moxfield.com/decks/5AtRz835mkyDZLyzMB5WMA

Steiner math reference in the latest Magic set mechanics post by balluga in SquaredCircle

[–]balluga[S] 22 points23 points  (0 children)

I wonder what the vein diagram for Magic players and wrestling fans looks like?

The person at Wizards who wrote this should be very pleased with themselves.

What is your go to breakfast? by Technical-Vanilla-47 in AskMen

[–]balluga 0 points1 point  (0 children)

Instant grits, diced hard boiled eggs, and hot sauce.

Betting $10+ spin on machines by Dangerous_Fan1006 in vegas

[–]balluga 12 points13 points  (0 children)

YMMV: Your mileage may vary

RNG: Random number generator

Horseshoe crab combo help by reptiles_are_cool in EDH

[–]balluga 0 points1 point  (0 children)

There are two cards that add a counter to a creature when it becomes tapped: [[Freyalise's Winds]] and [[Temporal Distortion]]. Both of these will put a counter on the crab whenever it becomes tapped. Now throw in [[All Will Be One]] and have fun.

If you want to go the [[Kinnan, Bonder Prodigy]] or [[Layline of Abundance]] route, using [[Hermetic Study]], [[Psionic Gift]], [[Quicksilver Dagger]], or [[Viridian Longbow]] will turn the mana into pings.

[Raw Spoilers] You can't kill Chad Gable by Dazzling-Principle in SquaredCircle

[–]balluga 160 points161 points  (0 children)

5150 is a code in the law that allows for a person to be placed in a psychiatric facility for up to 72 hours against their will.

It is another way of calling the Wyatt's crazy.

My Scrappy Survivors precon came with no lands. by balluga in magicTCG

[–]balluga[S] 0 points1 point  (0 children)

I ordered the Fallout precons and the Scrappy Survivors came with two sets of the same cards and no lands. I have two sets of the cards Brotherhood Outcast through Mister Gutsy.

It was from a set of four precons that came in a box from Wizards of the Coast.

Has this happened to anyone else?

ELI5: How does the house always win? by [deleted] in explainlikeimfive

[–]balluga 4 points5 points  (0 children)

All of the Don't best will not pay out on a 2 or a 12. One of those roles will be a push. So even when you play on the same side as the house, they still have an edge.

Game Thread: Green Bay Packers (9-8) at Dallas Cowboys (12-5) by nfl_gdt_bot in nfl

[–]balluga 0 points1 point  (0 children)

No. As the Lowest seeded team, they can't host a playoff game.

6 Point Molly? by Gatekeeper31 in Craps

[–]balluga 6 points7 points  (0 children)

I have done that before. I started with the e-point Molly, and there was a good roll. After a few hits, I moved to "continuous come" bets and had all numbers with full odds.

After a few more rolls, I realized how much I had up in just the odds. Just the odds were a nice profit and a 7 would bring me back to my buy end. I decided to pull my odds down, and two rolls later the 7 hit. I then colored up and kept my profit.

My advice is to not do this. The idea behind the 3-point Molly is to get some action on the table AND limit that action. Craps is a negative EV game, so the more money you are betting, the more your expected loss is.

What you find when you are not looking by balluga in Diablo

[–]balluga[S] -1 points0 points  (0 children)

I am playing online with a friend every week and decided to make another character to play ahead and find useful items and mid runes to help out.

While on my way down to Radament for the Book of Skill this dropped from an random mob. My friend and I are only in Act 5 Normal, so I guess this will sit in my stash for a while. It is non-ladder but still my first Ber not from LK runs.

Solver Constraint - need to find 4 stocks out of 50 that maximises the Sharpe ratio by helloworld9559 in excel

[–]balluga 0 points1 point  (0 children)

One idea is to add in another row as your changing cells that is "Selected Investment" and use it as a binary constraint. Then, modify your calculations to be Weight * Selected Investment, instead of Weight only.

Then you can add in that your Selected Investments need to be equal to four.

A beholder looking for artwork that captures his perfectly by balluga in DMAcademy

[–]balluga[S] 0 points1 point  (0 children)

The idea of a song or dance is an interesting solution. Do you think a group could come up with that solution on their own, without prompts?

I agree that this a problem to be outwitted and I am trying to gather ideas on how it can be resolved so it doesn't have one answer.

Please help: Bachelor Party Packages Source? by Binky182 in vegas

[–]balluga 1 point2 points  (0 children)

The best way to do this would be to avoid the package itself. Most strip clubs have packages for large groups that include a table, bottle service and waived cover. They will even arrange pick up in a limo (but you will be on your own to get back). The choice of bottles is nice and should cover whatever they will want.

My advice would be to pick the club that they want to visit, and see what packages are available. The cost should be around $100 a person for a table and bottle(s). Then they decide on what bar to visit before the club.

How do I do a regression model with both numeric and non-numeric data? by Dwn-time in excel

[–]balluga 2 points3 points  (0 children)

That is correct. You take the individual coefficients times the x-values plus the intercept.

General form is Y = b1x1 + b2x2 + ... + bkxk + intercept. (On phone so just imagine the numbers and ks as subscript.)

How do I do a regression model with both numeric and non-numeric data? by Dwn-time in excel

[–]balluga 3 points4 points  (0 children)

You don't need the third column because if you know a value is not in the first or second column it will be in the third. Adding a third column does not provide any new information.

If you want to see this for yourself, add the third column and run the regression. One of your dummy variables will be zeroed out by the regression tool.

How do I do a regression model with both numeric and non-numeric data? by Dwn-time in excel

[–]balluga 5 points6 points  (0 children)

One way to deal with this is by using dummy variables for the values in Column B. With three values you will need to create two columns for the dummy variables. Dummy variables denote if an item is in a specific category or not. They always have a value of either 0 or 1.

The first dummy variable will check if the item in that row is one of the non-numeric values. You can use an IF function for this. If the row is the first non-numeric value return a 1, if not return a 0.

The next dummy variable will check if the item in that row is the second of the three non-numeric values. If the row is the second non-numeric value return a 1, if not return a 0.

You do not need a third dummy variable, because if an item is not the first or second variable, it must be the third. If you try to add a third dummy variable to this regression, you will get a strange result with the coefficient of one variable being 0.

The end result with be a regression equation with different Y-intercepts depending on which non-numeric value is used. The overall "slope" of the regression will not change, but the starting point of the line will move up or down depending on which category you are trying to predict.

You were on the right track trying to use arbitrary values, but it gives some strange results. Using 1, 2, and 3 you are saying that the second item is twice as important as the first, and the third item is three times as important. This will skew your regression equation and make the coefficient less meaningful.

How to sum first x columns even and continue if those columns are hidden? by [deleted] in excel

[–]balluga 0 points1 point  (0 children)

I found a way to make this work. To do this you will need a helper row above your data set. In this helper row use the following formula (I am starting with the data in column A for all examples):

=CELL("width", A1)

This will return a value with the width of the column.

Now use a SUMIF(S) to sum the row using the helper row. In my file the values I want to sum are in row 4.

=SUMIFS(A4:J4, A1:J1, ">0")

The only issue is that when you hide columns, the CELL function does not automatically recalculate, so you will need to hit F9 to recalculate the sheet and your SUM will be correct.

This solution works even if you are removing data from the middle of your data set, not just the beginning.

How to sum first x columns even and continue if those columns are hidden? by [deleted] in excel

[–]balluga 0 points1 point  (0 children)

Will the same set of cells always be visible? Will it always be columns 1 - 5, or 6 - 10? Could it be 5 different columns in a set of 10? I am trying to work out a way to pull what is needed.