Mega Man 7's Final Boss is Annoying

 I know all of the Mega Man games are difficult, especially the final bosses, but this is the one I'll be complaining about because I'm working my way through the legacy collections chronologically and this it the first one with the rewind function.

Yeah, I guess I'm a casual when it comes to Mega Man games, but this fight is seriously rough. Once you memorize his attack patterns and figure out which abilities make the fight easier you still have to have lightning fast reflexes. Or an E Tank I guess

So the new Harry Potter game looks pretty good

 Skip to content

It’s pretty crazy that the developers of Disney Infinity and Cars 2 the game are making something this ambitious. I don’t know if they can pull it off, but it sure looks promising.

One thing I’m a little disappointed in is that, other than playing it in the background, they didn’t spend any time mentioning the game’s soundtrack. Jeremy Soule’s music was integral to the very early games in the Harry Potter franchise, and I’m not surprised that they wouldn’t get him back for this, but it sure would be nice if they found a composer with a similar style. Then again, who can compete with this?

How to Create a PivotTable from Groups of Rows in Excel

 I'm going to post something a little different today.  I came across a challenge at work a few days ago that got me thinking about Excel.

So say you have a bunch of data that looks like this:

How would you organize this data so that rather than looking at 30+ lines of data, you only have to look at 4 lines to determine how many hours each division worked at each job?  If you try to create a pivot table from this data, you get this:

Well, that doesn't help.  We have how many hours each division worked, but the jobs are completely separate.  So how do we organize this by groups rather than by row/column?  It looks like the solution lies in some sort of if/and/vlookup function/formula.  But I don't have much time today, I'll look into this more later.  If you have an idea of how to solve this, let me know!

Happy Saint Patty's Day!

I hope you're all wearing green today.  Or perhaps you're green with envy?  Apparently parts of that expression can be traced all the way back to the ancient Greeks. Back then, the color green was associated with paleness, fear, illness, and poor humor.  I guess overtime people started associating it with other frowned-upon emotions like envy?  Thanks for coming to my Ted Talk.  Happy Saint Patrick's Day Errybody

WHOA HEY I'M BACK AGAIN

Hi. Long time to talk. I'm back from the dead to talk about the Steam Deck.

This thing looks supes cool, but even though I reserved mine within two hours of pre-orders becoming available, I won't be getting mine til Q3 of this year :( I've been doing a lot of research on the Deck and I have one question that I've yet to find an answer to: Can it run a virtual machine? Obviously there aren't any virtual machine apps within Steam, but what about Desktop mode?

It's just Linux, right? There are virtual machines on Linux. I know there are a lot of Windows Games that the Steam Deck can't currently run, but what if some older games were playable inside of a virtual machine on the Deck? It could open a new world of possibilities. If anyone's still here, let me know your thoughts or if this is even possible. I'm getting excited thinking about it.

Quick update: From what I've read, it looks like it should be possible, but it wouldn't be able to access the GPU.  That shouldn't be too much of a problem for older games that don't use many resources, right?  I just want a portable retro pc in the palm of my hands (not a laptop).  I have the original GPD Win but it's so slow.