Computers Nyan Cat The Excel Macro!

0 Comments

If you’ve seen my previous post you’d know that Excel can be fun sometimes. Last time I used Excel to draw images using the cells as pixels. Today though we have a fully animated Nyan cat wohooo! NANA NANANA NANAN NANANANA NANA NA NA NA

Ok enough! Heard the song enough during testing.

And YES those are Excel cells being updated regularly for the animated cat!

Download 

 

Main Window

Program Running

 

Tags: , , , ,

Computers Excel Art

0 Comments

After my presentation of Excel macros at BarCamp Kuwait a friend sent me this link (http://imgclean.com/?p=2149) on Twitter and said that this was much better than my excel macro. I told him challenge accepted and spent a week and a half trying to figure out how I’m going to to what I had in mind. The Excel macro I had in mind would let you choose an image, it will import it, read pixels and use the colours to colour excel cells & make an image out of them.

At the end, the program works as follows:

  1. Open a UserForm to enable user to import an image.
  2. Image Control in the UserForm will zoom the image so it all shows inside the Image Control.
  3. Handle the UserForm and use GetPixel function to get the pixel colours as “Long” integers.
  4. A function will extract individual RGB colours.
  5. A new WorkBook is opened, rows/cols will be re-sized and Sheet is zoomed out.
  6. Cells will be coloured with the previously extracted RGB values.
Problems encountered:
  • You cannot draw an image twice in one Excel sheet. It seems that Excel runs in an issue with large number of formatted cells. That’s why I’m using a new Work Book each time, it’s actually good too so you can save it for the image only.
  • VB has a Picture Box Control which is not available in VBA, Excel has only an Image Control which doesn’t have all the functions of a Picture Box. I’m not an expert on this since it’s the first time I use Forms and Controls so I cannot tell the difference. All what I can say is after hundreds of searches online many people were looking for Picture Box Control in Excel but it’s simply not there. I had to use Image Control and create a handle for the UserForm, declare GetPixel function, import libraries and then use the GetPixel to get all the pixel colours for the image.
  • RGB colour conversion used to over-flow so the negative numbers were set to 0 and numbers above 255 are set to 255. Now one might say when it goes negative it should be set to 255 because it over-flows. I’m not sure I just got bored of all the searches I’ve done so I don’t really care how they work. Yes not ALL pixels are going to be perfect but hey its giving great results!
  • When using the GetPixel function with loop I used to get part of the image while all other pixels give “-1” value. After long debugging I discovered that when Excel goes into a loop and for long time it gives a “Not Responding” message then starts being responsive after it finishes. This causes the GetPixel to get bad pixels from handle of the UserForm. A work around would be a small 10 ms delay in the loop or a progress bar box which was done using UserForm.
This program is not written to be perfect it has bugs and it definitely could be better.

Images:

Excel Art Load Image

Excel Art Loading Image
Excel Art Result

Excel Art Result

Excel Art Result Zoomed

Excel Art Result Zoomed

Download Source File

Tags: , , , , , , , , ,

Internet Qualitynet Bad Customer Service 02

0 Comments

In a followup post to my problem in which I wrote a post about. I will briefly summarize the situation.

On Thursday the 25th of January 2012 I called Qualitynet because I felt that my connection was being slow.

Qualitynet then sent me a technician the 1st week. Then I was visited by Qualitynet employee in the 2nd week. He told me to send him a trace route report of all the Speedtest.net servers I ran the speed test through.

I was told by another Qualitynet employee that he personally don not acknowledge  Speedtest.net results!

They changed some of the settings, some sites became faster while others didn’t. Youtube became faster for a while but it’s slow again.

Downloading from:
Gave 20 to 40 kb/s download speed.
They CANNOT be all slow!
Today is the 15th of February 2012 almost 3 weeks since I 1st reported the problem to Qualitynet. I called them again today after another random disconnect which I’ve been getting recently and they told me they will send me another technician!
In terms of customer support service, I do not know what do they call this. I’m very unpleased with my customer support experience I’m getting.
Tags: , , ,

Internet Qualitynet Bad Customer Service

Comments Off on Qualitynet Bad Customer Service

I subscribed with Qualitynet in late 2010. I had problems from the beginning, they had to send a technician to check the quality of the line from my side and discovered that its from the ministry of communications. But I cannot blame them for that.

My connection type is 2 mbps gaming, which means download speed of little more than 2 mbps and upload speed of 1 mbps.

After about a year and just 10 days before my subscription ends I got disconnected and after calling Qualitynet they told me your phone line is bad and it is affecting the signal quality and that we have to decrease the speed, so they changed my connection from 2 mbps to 1 mbps for the mean while to at least be connected to the internet. They told me the problem is from my side and that I had to change the filter, telephone wires for the phone/router or even the building’s wires. Being a polite customer I always remained calm and followed their instructions because I thought that they had a list to go by before they reach a conclusion on the type of problem. What they don’t know is that they are talking to an electrical engineer, computer geek and a Cisco CCNA1 certified customer. In that case I would have already tested and concluded that the problem is not from my side. All those requests to restart your gateway, unplug the phone or change the DSL filter are really not necessary. For GOD sake I flash custom firmware for my routers and fix network related issues for friends.

The other thing is that statistically, it has always been a problem with the ministry and not my side.

The easiest thing for Qualitynet it seems, is sending you a technician home to check your connection. No offence to technicians but I like to minimize the number of strange people entering my home and invading my privacy, not to mention one of the last times where Qualitynet promised to send a technician at 5 PM but he came 8:45 PM. Imagine sitting there dressed properly and not being able to leave home waiting for the technician to arrive any moment for hours!

The last time I was told that the problem is from my side and that I had to change the building phone line after a visit by Qualitynet’s technician to my house. I purchased a complete roll of brand new original high grade phone line and replaced the whole line from the ministry distribution box to my flat several floors up. Still the quality of signal didn’t get any better and finally the problem was found to be form the ministry to my apartment. Thank you Qualitynet for letting me spend time and money on a totally unnecessary thing!

Lately I’ve been experiencing very slow speeds on everything! Youtube, VPN and all kind of downloads from all websites. I checked www.speedtest.net and found out the following.

Kuwait:

Zurich:

Frankfurt:

Paris:

New York:

Miami Florida:

 

Clearly the problem wasn’t from my side, my ping, download and upload speeds to servers in Kuwait were very good! My problem was with anything outside of Kuwait.

I called the customer support and explained the problem accurately on Thursday night. Saturday morning they called me and said we will send you a technician at 7 PM. I’m thinking to myself WTH?! I told the guy the problem is not from my side, my connection to Qualitynet servers and other servers in Kuwait are fine. The same guy called few minutes later asking me to do some speed tests and tell him the results. Imagine a guy from Qualitynet support asking me to do several speed tests and give him the number so he adds them up to see if they add up to my speed?! What?! I was thinking to myself. So if I run 4 speed tests that gave 0.5 mbps, we add them up to be 2 mbps and the download speed is fine?! At least that’s what I understood from his request but I could be wrong. (What kind of sorcery is this?!)

I thought what if we have general problem in Kuwait so I went to my relatives and tested the same exact servers on www.speedtest.net (Note they have Fasttelco). They have 1.5 mbps connection yet they managed to get the full 1.5 mbps download speed from all the server seen above in the results.

It’s Monday today and there is no respond from Qualitynet. I called them and they said they’ll probably call me tomorrow but they cannot promise it’s going to be solved.

Unfortunately it’s no longer about Quality!

Tags: , , ,

BarCamp BarCamp 2012

1 Comment

It’s been a while since I posted something to my blog or even update my website. Almost a year!

Since I presented at BarCamp and beed asked to provide my slides as well as the Excel files, there you go:

  • Presentation
  • Excel Files:
  1. 1st Macro Tests
  2. The Word Challenge Bot
  3. The Sudoku Solver
  4. Export / Import
  5. Draw
  6. Excute Commands

Computers Firefox Beats Other Browsers

0 Comments

A friend of mine sent me this a while ago, Firefox & IE statistical graphs have crossed, with Firefox taking the lead in Nov 2009.

Worldwide Web Browsers Statistics

The Firefox’s graph is still rising above others. Take that Microsoft!

Statistics source

Firefox has proven it’s self as a reliable browser over time, even Google have built Chrome using Firefox’s technology. Web developers should now focus on compatibility, since many websites might be targeted to work on IE, which is most of the time incompatible with any other browser.

Now with the upcoming release of Chrome OS, the whole idea of the Operating System is around the browser, that’s the future of internet computing. Now Microsoft will be trying to catch up & I don’t see them catching up anytime soon if they ever will!

General Girls are Hubs, Boys are Switches and Routers

4 Comments

Throughout my experience in life, I’ve came to a conclusion time ago that seems to prove it self on regular bases. While the title might be self explanatory to “geeks” and “network professionals” or at least would be easier to understand once you know what I’m talking about.

Girls talk & blabber too much! News spread like fire, gossips and rumors just spreads between all of them. If a girl is notified of something, she goes telling everybody about it, just like a hub!

For non network professionals, a hub is a network device that receives data & broadcast it to all connected devices on the network, whether it was their data packets or not everyone gets a copy of it.

You should be getting a part of the picture by now.

Hub

Hub

On the other hand however, boys are more careful when they speak, they speak less & they are more intelligent when it comes to the concept of spreading news. Tongues do not slip fast & they do not broadcast everything they hear, that’s why they are more like switches and routers.

Switches and routers are more intelligent devices in a network, received data are only transferred to a specific address depending on a lookup table that is called an ARP table. This way only the desired destination receives that certain desired data.

Switch

Switch

The bottom line here is … well I guess you already know it.

P.S: Another thing you should know here, though packets transferred through hubs are usually of a good quality, news spread by girls tend to mutate during transmission & original content quality degrade severely after few transmissions.

Computers What Happens When You Send Me a Virus?

4 Comments

One guy thought he could trick me & infect my pc through sending me a link to a website that downloads malware to your computer.
I bet he regrets that now.

  1. Website reported to Google & Firefox “Web Forgery Team”.
  2. Website reported to “McAfee site advisor”
  3. Virus sample sent & Antivirus vendors informed of the threat:
  • Avira
  • Avast
  • Bitdefender
  • AVG
  • F-Prot
  • Aladdin
  • Symantec (Norton)
  • NOD32
  • Clamav
  • eTrust
  • GData
  • F-Secure
  • And others through sharing submitted samples.

Note: Samples sent to AV vendors that couldn’t identify the threat.

Results: website has been blocked, more AV engines can recognize the threat.
Muhaha nice try!

The guy probably didn’t know I’m a Linux guy, otherwise he wouldn’t have sent it in the 1st place.

General What Does it Feels Without Piracy

0 Comments

A friend told me that I have to write about my feelings & impressions after switching to fully legal.
My iPOD only contains legal music now, my computer still have some tracks here & there that I didn’t have time to remove, but I’m not listening to any pirated stuff.
As for software, I do not use any pirated software. Though I might still have some installed on Windows here or there, lost track of them but I’ll be removing them as soon as I discover them.
This also goes for the videos, the thing is that I’m a bit messy when it comes to files, I got tens of folders here & there and on many hard drives & partitions, so it is a bit hard to keep track & remove them in time.

Am I missing anything?
Well, not really. I’m not addicted to certain series to begin with but I would probably have problem with music if I do not find what I want in tracks if you know what I mean.
iTunes is probably the best retail store when it comes to music, but Kuwait’s iTunes store sucks as I mentioned in an earlier post.
I’m currently relying on Amazon’s MP3 store to purchase all music tracks that I want. I’ve already got disappointed trying to find a certain track yesterday, the CD was available to purchase but nothing to download, though I have the CD (original), I wanted to gift a track to a friend, thought I’d get it original. Yeah yeah probably your thinking “this guy is nuts!”.
I’ll tell you to think of whatever you want, as long as I know I’m doing the right thing I don’t care! 😛

It feels great to be living legal, knowing that you aren’t stealing others work. You also feel proud being different.

General No More Piracy!

0 Comments

Long time ago, almost as long as we’ve been using computer, listening to music & watching movies, we’ve been using pirated software, listening to pirated music & watching pirated movies.

Why is that? Because no one told us it’s wrong and because all people around you used to copy music (casset days), share computer games on floppies or cds & when you go to buy a movie it’s most probably copied.

Well, time has come to change. Why the change?
It’s simply for religious, moral & ethical reasons.
Since all pirated stuff are essentially stolen, it all makes sense.
The bottom line here is, if you want it, buy it!

Some of people would go around in circles justifying the reason of them downloading music over the internet saying that a guy has purchased it & then distributed it.
If someone is actually making stealing easier for you, it doesn’t justify that you steal. The guy doesn’t own the music buy purchasing it, he can listen to it but cannot publish it.
People forget the fact that even soft copies such as software, music & videos are actually stuff you sell, just like a car except that the car cannot be duplicated freely. So you have to pay for another one in order to give it to a friend right? While a song is just copied.

Imagine two companies, a hardware & software vendors.
Both are making effort to manufacture & sell their products, yet the software would be loosing due to piracy, it is just not fair.

We can keep talking about the problem but the solution is to start by yourself.

I’ve been telling my friends that I’ve set a goal for myself, I’m getting rid of all pirated software, music & videos by 1st of January 2010.
I’m already using Linux with a lot of Free & OpenSouce software since 2007 so I don’t really have to worry about software much.
I’m not a fan of many series nor movies, but I like to own some stuff, so I do not have a big issue with movies either.
My main problem here is music, I’ve got an iPod but Kuwait’s iTunes store sucks! It doesn’t have any of the songs I want, it cannot even get the cover pages of the cd’s I’ve ripped.
I got about 35 CD’s didn’t get any of the album arts, not Arabic, not English, not even Yanni, one of the most known artists in New Age music.
I’ve come to know that Amazon has an MP3 store which I’m thinking to give it a try, currently I’m moving all pirated music files I own and which I really want to keep into a “to replace” directory, I won’t use any of the files but would either do a list of them or keep them there till I buy the original & delete the pirated file. A list looks better to be honest, cause the file might tempt you to click it. I think I’ll go with the list.

I must spend some good time on this, today is 31st Dec 2009, less than one day left. It’s not going to be easy, but everything begins with few steps.

Some friends are supportive, some against the idea & some is making fun of it, but hey! Legal is legal.
I believe what I’m doing is right no matter what justifications you give to “steal”.

I hope I’ll be posting some images of the CDs I’m getting rid of & posting the progress on the 1st of January 2010.

Till later…