Hungry Hungry H... wait, what?

Went shopping at Target to buy gifts (for relatives) this Christmas and stumbled upon this, really Zynga? You're selling Hungry Hungry Hippos with the 'Farmville' brand? It's not based off the original game, it's exactly the same game, save a few color and head changes.

There's two other games I noticed, a Monopoly game based off of Cityville, and Words with Friends. But they are original in a way in both the layout and rule changes. But Farmville... this is completely unrelated. Except for the Farm Cash.

Speaking of that, isn't the sequel being played more nowadays?

D3: Three days in the AH

3 days in and getting some profits from the the D3 Auction House... one thing of note today was buying and reselling Encrusted Hooves... back to a merchant. I noticed that the cost of buying that commodity was less than the price of selling to the merchant, so I decided to take advantage of this and bought as many as I could afford (and as many as they had left). Instant 30k profit within a minute. (For people who put it on the AH and were expecting to make more money off selling this commodity at that rate... I have no words for you.)

I similarly take advantage of the fluctuating prices of gems which varies from 160 to 300ish for Amethyst. Again profiting at 112 per gem (or more).

3 days, that's approx 1.2m in profits so far. Got three more weeks before results are tallied up. (to compare, I can get around 100k gold in one 20-30 minute run.)

Reef Madness

This post is a day late from its original release, but my excuse is that I currently have finals this week. As well as taking advantages of gem prices in D3 that I'll go in more detail on another post.

It looks like a 90 degree flip of an older board (Splish Splash) but the curves are longer so the balls won't move as fast by the time you can gap, and the configuration was changed slightly so that you can consistently do a gap (or double gap).

Strategy: Fruit is easy to get, gaps are a bit harder, but if you doble gap right, you're in for some good points.

Recommended Powers: Gapple Sauce, Epic Fruit, x3, Timelord, Spirit Eagle. You could also use Baco Bouquet - it has been tested to give huge amount of bonus time (2:32 for a eagle) but you're relying on your luck that enough time balls will pop up.

Diablo 3: 60 and Climbing

Defeating Diablo might mean beating the game to some, and even more to people who hit 60, but it's far from over.

3 Week Gold Challenge: Raise as much money as possible (by this, meaning actual cash as well as gold) via equipment and commodity sales as well as loot drops in three weeks. 1 dollar will covert to 3.4 million gold based on current conversion rates.

There was almost no way to do something like this after one playthrough, so the last week was spent bringing up a character to lvl 60.

Notes:

• The campaign can by any means be called 'short' - it takes approximately 8-10 hours to complete at MP-2 if you're just completing the main objectives. (Note: There are achievements for completing each Act in less than 1 hour.)
• Leveling up here is quite quick (approximating 30 minutes with the proper skills, up to lvl 50, at which point you need to be on Hell difficulty to level up effectively)
• MP-2 is quite manageable with normal gear, after that point you should overgear via auction house.
• Was xp farming at the rate of 740k EXP / hour on Nightmare difficulty. and approx 2.75M xp/hr peak at Hell.

Current Strat I'm Using:

Note: It might not be the most effective, but works for me.

• Start game in normal mode (no MP), go up to lvl 10 or something.
• Accumulate enough gold to overgear via auction house (using Flawless Square gems for sockets)
• Play at MP-5, adjusting as necessary to get though the game by Lvl 30 or so. (If I'm doing a lot of overkill on enemies, MP is raised). Reduced to Normal after hitting 50 before Hell dif, and back up to MP-2 onwards.
• Accumulate as many subtle essence via blacksmith (by breaking it down) and sell via auction house (this sells for around 700 each at time of writing, far more than selling inferior magic items alone. If it's rare and has good stats, sell via AH.)
• My Barbarian Build for XP: here (Prior to inferno)
  • 1. Frenzy + Sidearm to build up rage quickly (and has high dps, with Sidearm more so)
  • 2. Rend + Ravage - used to take out standard mobs quickly. Note its total damage is 700% weapon dmg over 5 seconds, and MP level as well and dps was prioritized so it can take out common mobs on its own.
  • 3. Sprint + Marathon - to get from one enemy to the next faster.
  • 4. Revenge + Vengeance - to build up fury + regen health faster between mobs
  • 5. Battle Rage + Maurader's Rage for the dmg bonus. (Latter swapped with War Cry in Inferno)
  • 6. Ignore Pain + Ignorance is Bliss, since damage taken is quite high in some places.
  • Passives to increase atk, def, and regens rage.

Results:

The challenge concluded on January 6, 2013, raising over 110 million gold in the process, and not killing a single creature in the last week, relying entirely on gem and item flipping. The most successful sale was Depth Diggers (bought at 12M, sold at 36M - 9.99 USD before fees and converted.)

(Sea) Turtles Board

Silly Eagle, you're not a spirit turtle. (Placeholder image, waiting for Spirit Turtle to arrive)

Can someone tell me how it matches up? (notices turtles) Oh, right, the release of the Spirit sea turtle (also appears in several places on the board). Wonder what it does...

Strategy: This is hard to gap effectively since there's little room to gap on top, and they roll slower towards the bottom, making it less effective. Even more so to curve clear since the second curve will almost always get in the way. Use a Spirit Eagle and focus on the fruit.

I had a very hard time getting a 10m here, relying on a lucky 2:08 et for the eagle. Let's see how well the turtle performs - hopefully it releases this week.

Recommended Powers: Gapple Sauce, Epic Fruit, x3, Timelord, Spirit Eagle. Use Combo Corn if you have it, it helps a lot when it comes to gaps.

If Spirit Turtle is available, use Curvy Fries, Timelord, Epic Fruit, and Inferno Frog. Five hot frog shots every ten seconds can take out a curve pretty quickly.

Sea Turtle: Coming out of the deep, it is rumored that it can instantly fire hot frog shots after consuming a fruit as well as doubling your speed bonus.

Near-Finals Week Treats

This is actually sweeter than it looks.

Who sets aside a box of treats (more specifically, cookies and pastries, one per person). My professor for my grad class does. He offers the box to everyone, and only one person comes up. Then slowly, another person gets up and grabs one, and another...

Sugar to keep awake during class, he says. In reality, I'll need this stuff to keep awake at night while studying before finals, that's more important.

Excel VBA Macros: Borders and Formatting

Borders seem very complicated when you record a macro for borders, do any kind of text of text formatting, etc., and look at it in Visual Basic. There are a few ways to simplify this.

Border Formatting Example

You record a macro, make a selection, and set borders. You immediately get something like this:

    Selection.Borders(xlDiagonalDown).LineStyle = xlNone
    Selection.Borders(xlDiagonalUp).LineStyle = xlNone
    With Selection.Borders(xlEdgeLeft)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlMedium
    End With
    With Selection.Borders(xlEdgeTop)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlMedium
    End With
    ...

Need a TL;DR? Essentially it is

1. Removing any diagonal borders through the cell, and
2. replacing each border with a medium size black line.

The details are:

• .Borders(Direction) indicate which border you want changed.
  • xlDiagonalDown affects the line from the top-left to bottom-right of each cell selected.
  • xlDiagonalUp affects the line from the bottom-left to top-right of each cell selected.
  • xlEdgeLeft, xlEdgeRight, xlEdgeUp, and xlEdgeDown affects the left, right, top, and bottom borders of your selection. That means it treats your selection as a box, and the sides are what the code affects, see the above image for details.
  • xlInsideVertical and xlInsideHorizontal affects all the other vertical and horizontal lines (respectively) in your selection that the above didn't cover.
  • If you don't specify a direction, then all
• The parameters you can set for borders are:
  • .LineStyle controls the line style. See the top for details.
  • .Weight controls how thick the line will be.
  • .Color controls the color of the line. You can use RGB format.
  • .TintAndShade controls tint and shade, but they can be ignored if you're using RGB values.

You don't have to stick to just the current selection, it can be modified so that you can change the borders for any cell without having to select it (and there are some good uses for this), so you could substitute Selection with stuff like:

    With Worksheets("Sheet1").Cells(6, 1)              ' This way you can use variables when accessing. 
       .Borders(xlEdgeBottom).LineStyle = xlContinous
    End With

- OR -

    With [D2].Borders(xlEdgeTop)
       .LineStyle = xlContinous
       .Color = RGB (255,0,0)
    End With

Text Formatting

The same can be done with Selection.Font (the parameters above work on this as well). I am listing only important values.

• .Color controls the color of the test (use RGB)
• .PatternColor controls the color of the background (use RGB)
• .HorizontalAlignment controls text horizontal alignment (equal to xlLeft, xlRight, or xlCenter)
• .HorizontalAlignment controls text horizontal alignment (equal to xlTop, xlCenter, or xlBottom)
• .WrapText = (true to wrap)
• .ShrinkToFit = (true to apply)
• .Orientation = (what angle to rotate it by)
• .AddIndent = (true to indent)
• .IndentLevel to determine how far to indent (whole numbers only)
• .MergeCells to merge or remove the merge on the affected cell(s). To not do anything with the cells structure, don't include it.
• .Name = (font name, enclosed in quotes)
• .Size = (font size)
• .Strikethrough = (True to make it strikethrough)
• .Superscript = (True to make it superscript)
• .Subscript = (True to make it subscript)
• .OutlineFont = (True to put an outline on text, but it apparently does nothing)
• .Shadow = (True to put a shadow on text, but it apparently does nothing)