Here's another example which is developing as I write. Check out this chart:
View attachment 9079
The spreadsheet for today shows that 1.3009 is an important resistance level for EUR/USD when it is trading around 1.3000. The bottom horizontal line on the chart marks this level. However, as shown on the chart EUR/USD has broken out of that level. The spreadsheet shows that 1.3041 is the next important level above 1.3009. This would be viewed as a resistance level. 1.3009 would now become new support. Now look at how EUR/USD behaved repeatedly when it reached the 1.3041 level. You should be able to now see that the levels indicated in the spreadsheet are meaningful.
Hamid, thanks for your posts. They really helped me understand this better.