Nick's Software Blog

Custom Database Software Development Melbourne

March 29th, 2015

Posted In: Agilent In Circuit Test, Machines Monitoring, Machines Monitoring Systems, Password Keeper, SEO, SEO Tips, Uncategorized, WEB APPS

Leave a Comment

Are always lots of lotteries offering big prizes around us.
But how can we win these big prices?

I always had an eye on them and tried to understand more about numbers and their statistics.

Nobody has the absolute answer and nobody can guess the lottery numbers, but is absolutely verified that checking the previously drawn numbers and calculating statistics you can improve your chances to win the lottery.

I won’t give you any crystal ball, but I will try to post here relevant statistics that could help you win. I will start with Saturday Lotto / Tatts Lotto and based on feedback that I get from readers this post could evolve and become an independent page or even a whole nine yards website…. who knows?

Where can you find the raw data? 
Few Aussie official lottery sites don’t publish anymore the whole past draws, but you still can find them on Lottery West and Tatts websites:

What can we do with all these numbers?
What I normally calculate is the frequency, pairs, triplets, quartets, draws sum and then group the numbers in four different categories ‘hot’, ‘cold’, ‘due’ and ‘previous’.

‘hot’ – numbers drawn in the last 10 draws, but not the last draw
‘cold’ – numbers having a lower overall frequency and  not drawn in the last 10 draws
‘due’ –  numbers having a higher overall frequency and  not drawn in the last 10 draws
‘previous’ – numbers drawn in the last draw

All these stuff can help filter out the numbers which are unlikely to be drawn in the next draw.

How exactly?
For all past draws I have calculated  frequency, pairs, triplets, quartets, draws sum and then group the numbers in four different categories ‘hot’, ‘cold’, ‘due’ and ‘previous’….. so I could see a pattern:
About 66% of drawn numbers are ‘hot’ number
About 15% of drawn numbers are ‘cold’ numbers
About 6% of drawn numbers are ‘due’ numbers
About 13% of drawn numbers are ‘previous’ numbers

This pattern is almost the same, over time…..draw after draw, since ’86.

So, what can you do?
If you play 6 number, play 4 x ‘hot’, 1 x ‘cold’, 1 x ‘previous’ by example….less numbers to choose from, more chances to win.

If you want to increase the chances to win a price (not necessarily the big one), play 6 or 7 or 8 ‘hot’ numbers…

Let’s see some updated Tattslotto statistics – just created this database:

I will update it weekly for Tatts Lotto and please comment – if you are interested in other lotteries – let me know and I will create few other on line lotto statistics databases.

June 15th, 2013

Posted In: TattsLotto Statistics

Tags: ,


If you are in EMS business, you know how important is to have a good test solution for all your products.
A common test solution is In Circuit Test and also you might have:

  •  Visual Inspection,
  • AOI (Automatic Optical Inspection),
  • X-RAY,
  • Functional Test
  • and many more.

ICT is many times a basic requirement for PCBA’s testing.
Test solution has to be properly designed and deployed in order to give you a good test coverage.

Once you have it designed, deployed, validated, you need to get under control the messages from the ICT machines.

ICT prints dockets for each failed PCBA and also creates logfiles, where tests results and measurement are recorded/logged.

It’s all good to have the data saved in the log files, but when you need to analyze large amount of information from the log files you need a tool that will help you extract and organize these data.

Scripts, OEM software tools have been made available, but quite often these tools were expensive and not really designed for engineering needs.

HPDC (HP Data Collector) Inception

I had the same issue as many others, had data available in the log files, but it was so damn hard to get them out of there and make them useful, meaningful, summarized in a good report.

For example, many time I’ve questioned myself:

  • Which are the top 10 ICT failures for a specific product (real time, would be nice)?
  • What’s the average test time for a product?
  • What’s the average measurement for a specific test?
  • What’s ICT loading/utilization?
  •  What’s the ICT yield (the real one)?
  • How many times the boards are tested (number of retests)?
  • Are going out to the customers only boards that passed ICT?
  • The right ICT program has been used to test the PCBAs?
  • What should I do with a fail board if the fail docket is missing? Do I have to test it again when failure data are available somewhere (log file)?

I couldn’t find too much help checking available solutions from ICT manufacturers like HP (Agilent), IFR (Marconi), Genrad and then I’ve started thinking how can it be done?

 HPDC – What it does?

HPDC is a file parser – it opens log files, from ICT Machines like HP3070, IFR4220, takes relevant information from them, and sends the information to a MySQL database.

Now that data are nicely organized, in a MySQL database purposely built for easy access, creating reports should be an easy task.

HPDA (HP Data Analyzer) – What it does?

HPDA is a software solution developed to interpret data collected by HPDC, bring them closer to you, make them useful.
Through comprehensive reports this software is capable to present a holistic image of your ICT testers.

Need to know yields, top defects, retest, cycle time – you’ll have them in a sec.

Need to know ICT machines utilization – done in a sec.

Need to see more specific failure report or failures related with a specific serial number or do paperless debug – no worries.

Need to know if a board was pass or fail last time when it was tested, or if that board was tested using the right program – too easy.

The whole bunch of log files data at your fingertips, that’s useful.

If you want to find more about HPDC & HPDA or ICT data collection/collectors in general check the webpage linked below:

Or contact me.

Have fun playing with your ICT machines….


March 30th, 2012

Posted In: Agilent In Circuit Test, HP In Circuit Test, HP3070, ICT, IFR In Circuit Test, IFR4220, Machines Monitoring, Machines Monitoring Systems, WEB APPS


Nick —
Regardless of how the rest of your day goes, here’s something to be happy about — today a honey pot you installed successfully identified a previously unknown email harvester (IP: The harvester was caught by your honey pot installed at:

You can find information about your newly identified harvester here:

Info on all the harvesters that have been spotted by your honey pots is also available here:

Don’t forget to tell your friends you made the Internet a little better today. You can refer them to Project Honey Pot directly from our website:

You’ve chosen to receive this message every time one of your honey pots or donated MXs helps identify a new harvester. We don’t blame you, we’re constantly checking in to see what we’ve caught. However, if you’re sick of these messages, you can turn them off by visiting your settings page:

Thanks from the entire Project Honey Pot team and, we’re sure if they knew, from the Internet community as a whole.

To block all future requests:

This message sent by:
Project Honey Pot (
c/o Unspam Technologies, Inc. (
P.O. Box 57265
Murray, Utah 84157-0265 USA

May 18th, 2014

Posted In: Project Honey Pot


We’ll start sharing info on Nick’s Software Facebook Page:


Please LIKE.

April 13th, 2014

Posted In: Google Traffic, Uncategorized


Got this new gorgeous phone Sony Xperia Z1 and it looks and feels amazing.
It has premium looks and premium hardware spec.

Sony advertise the phone as:

Then why my phone looks like a 3 years old, scratched phone after 2 weeks of light use?

The truth is Sony use scratch resistant glass, which is tough and good quality, but this glass is covered with ASF – Anti Shatter Film – which is absolutely low quality and catches scratches just rubbing your nails on it.
So, what can be done?
Looks like the only sensible thing to do is to change the AFS layer by yourself, coz telcos and Sony give you BS only.
Maybe once they get more similar complains they will treat the problem differently.

Removing the ASF you will loose the Sony logo, which is baked into this screen protector rather than etched onto the glass.
And also voids the warranty, they say….which is harsh and unfair having in mind that their ASF layer is faulty and low quality.

If your Xperia Z1 is not scratched yet you should hurry and buy a screen protector that probably is better and will last longer than the original ASF layer.

If your phone is scratched already, here are some good tips on how to remove the ASF without creating more damage to your phone.

Hope it helps to keep your Xperia Z1 scratch free, as it should be.


January 18th, 2014

Posted In: Sony Xperia Z1

Top 5-10 websites on the web  – lets have a look at next 5 websites that top the web.

6. Wikipedia
7. QQ
10. Twitter

As you can see Amazon was kicked out from Top 10. Would be interesting to see why?

Social Media


So, why did Alexa kicked out Amazon from Top 10?

Twitter is better at Social Media Chapter, I guess, not Google+ though:

Backlinks are telling quite the same story Twitter wins by far!

One parameter from here…is very much liked by Google (and Alexa) and can swap the position of these sites at any time in the Top, with minimum variation.

Which one will be?
Your Answers below….

September 2nd, 2013

Posted In: Uncategorized

Well, dummy words have no search or competition on the WEB. Let’s write NickSoftware reversed erawtfoskcin and see how quick Google index it and how this mini article will rank in SERP.

My guess, in two minutes, it will be ranking page 1 in SERP for keyword erawtfoskcin.

OK, let’s count.

Got number one in SERP in two days.

Nick’s Software

August 24th, 2013

Posted In: Uncategorized

Top 5 websites on the web  – everybody would like to get there, but for now the privilege is still within big boys reach only.

As per Alexa Top Sites the TOP 5 websites on the web is:
1. Google
2. Facebook
3. Youtube
4. Yahoo!
5. Baidu

We all know how these sites look like and what they offer.
Also we know that they are very popular among us, and we ALL use them daily, more or less.

But, what’s behind the scene? 
What’s the domain comparison between these “.com(s)”? 
Why are in top 5, besides their obvious impeccable content and attraction to us? 
Why is Google number one and Facebook number two?

Social Media 

Google is mentioned 3mil+ times in Google+, when Facebook has only 22K links in Google+, Youtube is a champion in Google+ with 7mil+ links and then Yahoo has 100K+ and Baidu about 3K.

On Twitter Facebook is the leader of the pack with 52K links followed by Youtube with 17K, Google and Baidu with 7K and Yahoo with few hundreds…

FLikes – of course Facebook leads the pack again with about 3.5mil, Google and Youtube follow with about 1mil+ and the other guys are below a mil.

FShares – Google has more than Facebook!!! – but both are close together at 4.2mil+ with Youtube coming next at 3mil and Yahoo at 900K and Baidu at 9K…

How many links the top 5 have?
Answer is lots….

Facebook – 7.7 billions 
Youtube – 3 billions
Google – 1.9 billions
Baidu – 240 millions
Yahoo – 39 millions

What’s their backlinks profile?

How many referring domains do they have?

So, why Google is first?
I think, because Facebook doesn’t have a search engine yet and Yahoo is all about rich content, Youtube is in no aggression pact area and Baidu is a non english search engine….

Will it change in the near future?
Can’t see any big challenger coming from outside top 5:
6. Wikipedia
7. QQ
8. LinkedIn
9. Windows Live
10. Amazon

But for sure I would like to see how top 5 will unfold once Facebook enters a bit more seriously in the search engine market.

What’s your view…
Leave a comment below.



August 22nd, 2013

Posted In: Backlinks Report

Just recovered this blog from a quite nasty hack – sorry if I had to delete some legit users.
Any legit users are welcome back – hackers stay away – I’m watching you!

July 16th, 2013

Posted In: hackers suck

These days computing technology evolves so fast and many times we get caught in a avalanche of upgrades or equipment change just to keep us up to date…

Of course all these new stuff cost money and is not quite easy to buy just to be on top. You have to have an increase need to upgrade.

On the other hand, many business have quite upgrading to reduce cost, and after a while they have found themselves in a deep predicament  and far behind their own industry standards…

How good or bad your IT equipment – where are you in all this IT saga – at home or at work?

An easy and free way to share these info with us would be to run GeekBench benchmark software on your equipment and fill out the following form.

GeekBench is free and cross-platform – Available for Windows, Mac, Linux, Android, BlackBerry, and iPhone


June 29th, 2013

Posted In: Uncategorized

Next Page »