Gizmokid2005, Organized Chaos!


Latest Tweet:

@alpha1beta same actually. I did get one batch of bad drives from WD. Same drive, 3 different ones (cont) http://t.co/sWvD2n3PYR

Convert Excel 5 digit (serial) date numbers to Date

Posted on Friday, May 3rd, 2013 at 12:34 PM in geek, tech by Michael

I spent a lot of time trying to figure this out and found the easiest way to do it. Below is the detail.

Excel’s serialized dates are the number of days since 1/1/1900. In order to figure out the date again, we have to add the serial number worth of days (subtracting one to account for the inability to not count 1/1/1900 as a day).

Quick Date Convert
A B C D
1 Original Date Serial Formula Converted Date
2 5/3/2013 41397 =DATE(1900,1,1)+B2-1 5/3/2013
3 5/3/2013 41397 =TEXT(B3,mm/dd/yyyy") 5/3/2013

 

How to Use Custom Car Models Trackmania 2 Stadium

Posted on Monday, March 4th, 2013 at 10:07 PM in games, geek, tech by Michael

After lots of looking on how to get this going appropriately I decided to post a quick how-to on getting a custom 3D car model going in TM2 Stadium. It’s actually much easier than it seems, so here we go!

  1. Locate your StadiumCar folder. It should be in your Documents folder under “ManiaPlanet” then in Skins, then Models. (Typical path on Windows 7 is Documents\ManiaPlanet\Skins\Models\StadiumCar). If this folder does not exist, create it.
  2. Next, locate the model that you would like to use (ManiaPark is a good resource for this). You need both the .zip AND the .loc (locator) files.
  3. Place BOTH files (the .zip and the .loc) in the StadiumCar folder identified above.
  4. If TrackMania 2 is open, close it now and restart it. If it’s closed, open it. This is required to allow the game to find the new files.
  5. FIREWALL & Port Forward!!!
    1. You will need to make sure that your firewall and port forwards have the following ports and protocols forwarded and unblocked to your computer in order for the skin to work:
    2. 2350 UDP & TCP
    3. 3450 UDP & TCP
  6. Now go into Stadium, then click on “Profile.”
  7. Next click on “Models.”
  8. Now select the appropriate model you want (they show up in the beginning of the list (all the way to the left)).
  9. Hit back to the main menu.
  10. ENJOY!

NOTE: These models aren’t small and will take time for other users to download them, until which time they will see a silver F1 car. This is normal and will resolve itself as the model is downloaded by other users.

Hope this helps someone else figure this out!

Farming Simulator 2013 Crop Symbol Breakdown

Posted on Saturday, December 15th, 2012 at 11:11 PM in tech, Uncategorized by Michael

So, if you play Farming Simulator 2013, you’re probably looking for an easy way to figure out what symbols are what crop well here you go.

I’ve taken a map provided graciously by another member of the community and added the crop symbols to it. Hopefully this will make your life easier as it did me :)

Feel free to save it, share it and use it!

Farming Simulator 2013 Map with Crops

Farming Simulator 2013 Map with Crops

Too Funny Not to Share

Posted on Tuesday, September 27th, 2011 at 2:32 PM in LOL by Michael

Pocket Tazer Stun Gun, a great gift for the wife.

A guy who purchased his lovely wife a pocket Tazer for their anniversary submitted this:

Last weekend I saw something at Larry’s Pistol & Pawn Shop that sparked my interest. The occasion was our 15th anniversary and I was looking for a little something extra for my wife Julie. What I came across was a 100,000-volt, pocket/purse-sized Tazer. The effects of the Tazer were supposed to be short lived, with no long term adverse affect on your assailant, allowing her adequate time to retreat to safety…?? WAY TOO COOL!

Continue Reading

My Time with the E7

Posted on Monday, September 12th, 2011 at 12:15 PM in geek, Reviews, tech by Michael

So, I was going to make this a nice long detailed review, but I can’t find time or the will to bring myself to do it. There are plenty of other excellent review out there of this device done by authors who are much more versed and well-written in mobile phone reviewing than I am. I apologize in advance if this isn’t what you’re looking for, but these are my few thoughts on the device. Continue Reading

Logitech Momo Review

Posted on Thursday, March 10th, 2011 at 11:01 PM in geek, Reviews, tech by Michael

I was recently alerted to an unbeatable deal on a Logitech Momo Racing Wheel and Pedals. A friend of mine found a set, in presumably working condition, at a local Goodwill store. After I did a bit of on the fly research and investigation, I figured it was an unbeatable deal and had him pick it up for me. Continue Reading

Thank You!

Posted on Friday, January 21st, 2011 at 4:47 PM in life by Michael

I’m a bit late, but this post needs to be out there. I just wanted to extend a huge thank you to everyone who helped and passed the word along about my A family in need post. I was able to gather enough to give the family a boost to their Christmas.

Continue Reading

A Family in Need

Posted on Friday, December 3rd, 2010 at 12:26 PM in life by Michael

Normally I wouldn’t write a post like this, there’s a lot of people out there that need help these days, especially in this economy. This case hits too close to home to not pass the word along. Last year my family was down and out and had a very hard time making ends meet and was on the verge of not having any type of Christmas for my younger siblings. Word got out and many many people came forward to help out my family. My brother came home one night from the farm he worked at with a carload full of gifts, etc for my family and sisters so they could have a Christmas celebration. This year, we are trying to Pay It Forward. Not only did that movie strike home and make a good point, but my family was helped last year, this year it’s time to help another.

My best friend, and best man from my wedding, has fallen on hard times. He has been getting less than 20 hours/week at work to support his family of 4, wife and 2 kids, 13 and 9, but since last week has been taken off the schedule by a boss who is egotistical and backstabbing to say the least. (I never got along with her either, and I get along with most people.) Now it’s the holidays, he has a job, but has no hours; the boss won’t fire him so she doesn’t have to pay unemployment (it’s a known fact as she’s done this with many other people in the past), but he’s still employed so he can’t get the benefits he needs to support his family.

Angela and Jason:

Angela and Jason

Ciera and Collin:

Ciera and Collin

My Mom and I are working gathering anything and everything we can to help this family out. As I said before, he has two kids, Ciera, 13, and Collin, 9, who could really use a Christmas to look forward too. Ciera wears a medium to large shirt and size 11 pants and 11 women’s shoe. Collin wears size large boys shirt (10/12) and size 12 boys pants and size 8 shoes. They have an Xbox 360 and Nintendo Wii that they could use games for as well.

Anything and everything would help. If you can give even a $5 gas card, or $5 cash towards gas, or food, that would mean more than you know to this family. They have hearts made of gold and would do ANYTHING and EVERYTHING they could to help you out, down to giving you the shirt of their back. Even in the situation they are in now, they would do that, if it would help you.

Please help us Pay It Forward to a family who is in desperate need. If you can help in ANY way please let me know. You can contact me at any one of the methods on my contact page.

I have a Paypal address you can use for donations as well: payitforward@gizmokid2005.com


Thanks to everyone who took the time to read this. Please pass it along, I’d like to help this family as much as I possibly can.

-Michael

Why work doesn’t happen at work. [VIDEO]

Posted on Monday, November 29th, 2010 at 12:50 PM in life by Michael

This is a PERFECT video/talk about why work doesn’t actually happen at work. Everybody, especially management, should watch this and take it to heart.

Why work doesn’t happen at work. [VIDEO].

Why I Don’t Want Kids

Posted on Wednesday, November 17th, 2010 at 7:28 PM in life by Michael

With all the people I’ve seen recently having kids or getting pregnant, I’ve decided to make a nice post as to why I have decided to not have kids. This post is not meant to offend, mock, make fun of, laugh at, or degrade anyone, it’s just my opinions and reasoning for not having kids myself. Continue Reading